Data source: Big Local News · About: Big Local

4,741 rows where grade = "grade_7", state = "NY" and year = 2021 sorted by low_income_int

View and edit SQL

year

  • 2021 · 4,741

grade

  • grade_7 · 4,741
Link rowid state county county_state_id admin_level district_nces_id district_state_id district_state_type district school_nces_id school_state_id school school_state_type ccd_school_type ccd_charter_school ccd_school_lvl ccd_school_low_grade ccd_school_high_grade year term grade white black hispanic native_american native_american_alaskan_native asian native_hawaiian asian_pacific_islander native_hawaiian_pacific_islander pacific_islander multiracial unknown_race male female non_binary unknown_gender ell ell_percent homeless homeless_percent low_income free_and_reduced free_and_reduced_percent disability section_504 total white_int black_int hispanic_int native_american_int native_american_alaskan_native_int asian_int native_hawaiian_int asian_pacific_islander_int native_hawaiian_pacific_islander_int pacific_islander_int multiracial_int unknown_race_int male_int female_int non_binary_int unknown_gender_int ell_int homeless_int low_income_int ▼ free_and_reduced_int disability_int section_504_int total_int
1434391 NY Allegany   school 3606360 21102040000   CANASERAGA 360636000418 21102040001 CANASERAGA SCHOOL public Regular School No Other PK 12 2021   grade_7 11.0   0.0         0.0         6.0 5.0             *     0   11 11   0         0         6 5             0   11
1434448 NY Allegany   school 3631350 22101040000   WHITESVILLE 363135004575 22101040001 WHITESVILLE CENTRAL SCHOOL public Regular School No Other PK 12 2021   grade_7 4.0   1.0                   3.0 2.0     *       *     0   5 4   1                   3 2             0   5
1435455 NY Bronx   school 3600144 320700860889   SOUTH BRONX CHARTER SCHOOL 360014405787 320700860889 SOUTH BRONX CHARTER SCHOOL charter Regular School Yes Elementary KG 08 2021   grade_7 2.0 4.0 29.0   0.0     0.0         12.0 23.0     *       *     *   35 2 4 29   0     0         12 23                 35
1435588 NY Bronx   school 3601115 320700860994   BOYS PREP CHARTER SCHOOL OF 360111506454 320700860994 BOYS PREP CHARTER SCHOOL OF NY charter Regular School Yes Elementary PK 07 2021   grade_7 0.0 25.0 31.0   1.0     0.0     0.0   57.0 0.0     *       *     18   57 0 25 31   1     0     0   57 0             18   57
1438343 NY Bronx   school 3600086 320900010000   NYC GEOG DIST # 9 - BRONX 360008606395 320900011350 NEW DIRECTIONS SECONDARY SCHOOL public Regular School No High 07 12 2021   grade_7 0.0 0.0 1.0   0.0     0.0         0.0 1.0     *       *     *   1 0 0 1   0     0         0 1                 1
1439654 NY Bronx   school 3600087 321000010000   NYC GEOG DIST #10 - BRONX 360008705675 321000010331 BRONX SCHOOL OF YOUNG LEADERS (THE) public Regular School No Middle 06 08 2021   grade_7 5.0 34.0 100.0   1.0     4.0     0.0   62.0 82.0     *       *     47   144 5 34 100   1     4     0   62 82             47   144
1444461 NY Cattaraugus   school 3607440 43011020000   RANDOLPH ACAD UFSD 360744004507 43011020001 RANDOLPH ACADEMY public Regular School No Other KG 12 2021   grade_7 8.0 0.0 0.0   0.0     0.0     0.0   5.0 3.0             *     6   8 8 0 0   0     0     0   5 3             6   8
1444499 NY Cattaraugus   school 3625440 43200050000   SALAMANCA 362544003519 43200050002 SALAMANCA HIGH SCHOOL public Regular School No High 07 12 2021   grade_7 2.0 0.0 0.0   0.0     0.0     0.0   0.0 2.0             *     *   2 2 0 0   0     0     0   0 2                 2
1444556 NY Cattaraugus   school 3625440 43200050000   SALAMANCA 362544006681 43200050008 WARRIOR ACADEMY public Alternative School No High 10 12 2021   grade_7         0.0           0.0   0.0 0.0             *     *   0         0           0   0 0                 0
1445107 NY Chautauqua   school 3611610 60301040000   FREWSBURG 361161000917 60301040004 FREWSBURG JUNIOR-SENIOR HIGH SCH public Regular School No High 07 12 2021   grade_7 51.0 0.0 3.0   0.0     0.0     0.0   26.0 28.0             *     10   54 51 0 3   0     0     0   26 28             10   54
1446171 NY Chemung   school 3610560 70600010000   ELMIRA 361056000814 70600010021 ERNIE DAVIS ACADEMY public Regular School No Middle 07 08 2021   grade_7 322.0 47.0 15.0   1.0     1.0     58.0   217.0 227.0     *       *     69   444 322 47 15   1     1     58   217 227             69   444
1446323 NY Chemung   school 3614850 70901060000   HORSEHEADS 361485001242 70901060010 HORSEHEADS MIDDLE SCHOOL public Regular School No Middle 07 08 2021   grade_7 246.0 3.0 10.0         5.0     11.0   133.0 142.0     *       *     *   275 246 3 10         5     11   133 142                 275
1446722 NY Chenango   school 3622260 81501040000   OXFORD 362226003144 81501040001 OXFORD ACADEMY MIDDLE SCHOOL public Regular School No Middle 05 08 2021   grade_7 53.0 0.0 2.0         0.0     1.0   27.0 29.0             *     5   56 53 0 2         0     1   27 29             5   56
1447045 NY Clinton   school 3621250 90501040000   NORTHEASTRN CLNTON 362125003018 90501040007 NORTHEASTERN CLINTON MIDDLE SCHOOL public Regular School No Middle 06 08 2021   grade_7 89.0 0.0 0.0   0.0     1.0     0.0   40.0 50.0             *     21   90 89 0 0   0     1     0   40 50             21   90
1447349 NY Clinton   school 3600009 91402060000   SARANAC 360000904670 91402060007 SARANAC MIDDLE SCHOOL public Regular School No Middle 06 08 2021   grade_7 101.0   2.0         1.0     2.0   62.0 44.0             *     *   106 101   2         1     2   62 44                 106
1448603 NY Dutchess   school 3615180 130801060000   HYDE PARK 361518001270 130801060006 HAVILAND MIDDLE SCHOOL public Regular School No Middle 06 08 2021   grade_7 159.0 30.0 49.0   2.0     0.0     12.0   137.0 115.0     *       *     51   252 159 30 49   2     0     12   137 115             51   252
1449363 NY Dutchess   school 3624480 131801040000   RHINEBECK 362448003343 131801040003 BULKELEY MIDDLE SCHOOL public Regular School No Middle 06 08 2021   grade_7 57.0 1.0 6.0   0.0     3.0     7.0   38.0 36.0     *       *     *   74 57 1 6   0     3     7   38 36                 74
1452289 NY Erie   school 3610170 141201060000   EDEN 361017000791 141201060001 EDEN MIDDLE & HIGH SCHOOL public Regular School No High 06 12 2021   grade_7 83.0 1.0 2.0   3.0     0.0     4.0   49.0 44.0     *       *     22   93 83 1 2   3     0     4   49 44             22   93
1452916 NY Erie   school 3614550 141701040000   HOLLAND 361455006651 141701040004 HOLLAND MIDDLE SCHOOL public Regular School No Middle 04 08 2021   grade_7 54.0 0.0 1.0   1.0           2.0   32.0 26.0             *     16   58 54 0 1   1           2   32 26             16   58
1453106 NY Erie   school 3616680 141901060000   LANCASTER 361668001482 141901060007 LANCASTER MIDDLE SCHOOL public Regular School No Middle 07 08 2021   grade_7 358.0 3.0 19.0   2.0     10.0     8.0   206.0 194.0     *       *     70   400 358 3 19   2     10     8   206 194             70   400
1453828 NY Essex   school 3616140 150601040000   KEENE 361614001394 150601040001 KEENE CENTRAL SCHOOL public Regular School No Other KG 12 2021   grade_7 18.0 0.0 1.0   0.0     0.0     0.0   10.0 9.0             *     0   19 18 0 1   0     0     0   10 9             0   19
1453904 NY Essex   school 3620730 151001040000   NEWCOMB 362073002918 151001040001 NEWCOMB CENTRAL SCHOOL public Regular School No Other PK 12 2021   grade_7 6.0 0.0 0.0         0.0         4.0 2.0             *     *   6 6 0 0         0         4 2                 6
1454911 NY Genesee   school 3610380 180901040000   ELBA 361038000802 180901040002 ELBA JUNIOR-SENIOR HIGH SCHOOL public Regular School No High 07 12 2021   grade_7 24.0 0.0 4.0   0.0               13.0 15.0     *       *     *   28 24 0 4   0               13 15                 28
1455177 NY Greene   school 3606720 190401060000   CATSKILL 360672000458 190401060007 CATSKILL MIDDLE SCHOOL public Regular School No Middle 06 08 2021   grade_7 68.0 7.0 14.0   0.0     2.0     6.0   52.0 45.0     *       *     *   97 68 7 14   0     2     6   52 45                 97
1455291 NY Greene   school 3612870 190701040000   GREENVILLE 361287003484 190701040001 GREENVILLE MIDDLE SCHOOL public Regular School No Middle 06 08 2021   grade_7 85.0 1.0 4.0         0.0     2.0   46.0 46.0     *       *     11   92 85 1 4         0     2   46 46             11   92
1455424 NY Hamilton   school 3616530 200601040000   LAKE PLEASANT 361653001461 200601040001 LAKE PLEASANT SCHOOL public Regular School No Elementary PK 08 2021   grade_7 5.0                   0.0   5.0 0.0             *     0   5 5                   0   5 0             0   5
1455443 NY Hamilton   school 3617760 200701040000   LONG LAKE 361776001601 200701040001 LONG LAKE CENTRAL SCHOOL public Regular School No Other PK 12 2021   grade_7 6.0 0.0 0.0               0.0   3.0 3.0     *       *     0   6 6 0 0               0   3 3             0   6
1455652 NY Herkimer   school 3617460 210800050000   LITTLE FALLS 361746001594 210800050006 LITTLE FALLS MIDDLE SCHOOL public Regular School No Middle 06 11 2021   grade_7 70.0 0.0 5.0         1.0     5.0   37.0 44.0             *     *   81 70 0 5         1     5   37 44                 81
1463841 NY Kings   school 3600151 332000010000   NYC GEOG DIST #20 - BROOKLYN 360015102729 332000010223 JHS 223 MONTAUK (THE) public Regular School No Middle 06 08 2021   grade_7 37.0 14.0 87.0   4.0     141.0     2.0   181.0 104.0     *       *     51   285 37 14 87   4     141     2   181 104             51   285
1469028 NY Monroe   school 3615390 260803060000   WEST IRONDEQUOIT 361539001301 260803060002 DAKE JUNIOR HIGH SCHOOL public Regular School No Middle 07 08 2021   grade_7 215.0 21.0 47.0   0.0     10.0     12.0   157.0 148.0     *       *     *   305 215 21 47   0     10     12   157 148                 305
1469769 NY Monroe   school 3609930 261313030000   EAST ROCHESTER 360993000767 261313030002 EAST ROCHESTER JUNIOR-SENIOR HS public Regular School No High 06 12 2021   grade_7 52.0 8.0 8.0   0.0     2.0     5.0   40.0 35.0     *       *         75 52 8 8   0     2     5   40 35                 75
1469883 NY Monroe   school 3623160 261401060000   PITTSFORD 362316004490 261401060008 BARKER ROAD MIDDLE SCHOOL public Regular School No Middle 06 08 2021   grade_7 144.0 10.0 17.0   0.0     30.0     14.0   123.0 92.0             *     *   215 144 10 17   0     30     14   123 92                 215
1469902 NY Monroe   school 3623160 261401060000   PITTSFORD 362316003243 261401060009 THORNELL ROAD SCHOOL public Regular School No Elementary KG 05 2021   grade_7 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0             *     0   0 0 0 0   0     0     0   0 0             0   0
1469940 NY Monroe   school 3623160 261401060000   PITTSFORD 362316005850 261401060011 CALKINS ROAD MIDDLE SCHOOL public Regular School No Middle 06 08 2021   grade_7 176.0 9.0 10.0         31.0     13.0   123.0 116.0     *       *     37   239 176 9 10         31     13   123 116             37   239
1470871 NY Monroe   school 3624750 261600010000   ROCHESTER 362475006710 261600010107 MONROE LOWER SCHOOL public Regular School No Middle 07 08 2021   grade_7 6.0 49.0 64.0         0.0     2.0   61.0 60.0     *       *     37   121 6 49 64         0     2   61 60             37   121
1471365 NY Monroe   school 3605580 261801060000   BROCKPORT 360558000286 261801060005 A D OLIVER MIDDLE SCHOOL public Regular School No Middle 06 08 2021   grade_7 169.0 10.0 24.0   0.0     2.0     13.0   109.0 109.0     *       *     41   218 169 10 24   0     2     13   109 109             41   218
1472847 NY Nassau   school 3617160 280205030000   LEVITTOWN 361716001524 280205030013 JONAS E SALK MIDDLE SCHOOL public Regular School No Middle 06 08 2021   grade_7 202.0 2.0 61.0   0.0     28.0     7.0   148.0 152.0     *       *     23   300 202 2 61   0     28     7   148 152             23   300
1472942 NY Nassau   school 3626400 280206030000   SEAFORD 362640003618 280206030005 SEAFORD MIDDLE SCHOOL public Regular School No Middle 06 08 2021   grade_7 141.0 0.0 13.0         3.0     1.0   90.0 68.0     5       *     *   158 141 0 13         3     1   90 68     5           158
1473835 NY Nassau   school 3631710 280214030000   HEWLETT WOODMERE 363171004230 280214030006 WOODMERE MIDDLE SCHOOL public Regular School No Middle 06 08 2021   grade_7 131.0 24.0 39.0   1.0     26.0     2.0   114.0 109.0     12       *     35   223 131 24 39   1     26     2   114 109     12       35   223
1474139 NY Nassau   school 3611760 280218030000   GARDEN CITY 361176001637 280218030001 HEMLOCK SCHOOL public Regular School No Elementary KG 01 2021   grade_7 0.0 0.0 0.0         0.0     0.0   0.0 0.0             *     0   0 0 0 0         0     0   0 0             0   0
1474158 NY Nassau   school 3611760 280218030000   GARDEN CITY 361176000944 280218030002 HOMESTEAD SCHOOL public Regular School No Elementary KG 01 2021   grade_7 0.0   0.0         0.0     0.0   0.0 0.0     *       *     0   0 0   0         0     0   0 0             0   0
1474177 NY Nassau   school 3611760 280218030000   GARDEN CITY 361176000945 280218030003 LOCUST SCHOOL public Regular School No Elementary KG 01 2021   grade_7 0.0   0.0         0.0         0.0 0.0     0       *     0   0 0   0         0         0 0     0       0   0
1474234 NY Nassau   school 3611760 280218030000   GARDEN CITY 361176000941 280218030006 GARDEN CITY MIDDLE SCHOOL public Regular School No Middle 06 08 2021   grade_7 217.0 3.0 15.0         24.0     9.0   130.0 138.0     *       *     33   268 217 3 15         24     9   130 138             33   268
1475336 NY Nassau   school 3619020 280253070000   BELLMORE-MERRICK 361902001722 280253070002 GRAND AVENUE MIDDLE SCHOOL public Regular School No Middle 07 08 2021   grade_7 303.0 8.0 48.0   2.0     35.0     7.0   193.0 210.0     *       *     78   403 303 8 48   2     35     7   193 210             78   403
1475355 NY Nassau   school 3619020 280253070000   BELLMORE-MERRICK 361902001726 280253070004 MERRICK AVENUE MIDDLE SCHOOL public Regular School No Middle 07 08 2021   grade_7 297.0 5.0 42.0         31.0     3.0   197.0 181.0     *       *     44   378 297 5 42         31     3   197 181             44   378
1475773 NY Nassau   school 3625050 280403030000   ROSLYN 362505003470 280403030008 ROSLYN HIGH SCHOOL public Regular School No High 09 12 2021   grade_7 0.0 0.0 0.0         0.0     0.0   0.0 0.0             *     0   0 0 0 0         0     0   0 0             0   0
1475906 NY Nassau   school 3623580 280404030000   PORT WASHINGTON 362358003288 280404030008 CARRIE PALMER WEBER MIDDLE SCHOOL public Regular School No Middle 06 08 2021   grade_7 263.0 4.0 89.0         38.0     14.0   220.0 188.0     *       *     62   408 263 4 89         38     14   220 188             62   408
1476248 NY Nassau   school 3612510 280407030000   GREAT NECK 361251001016 280407030015 GREAT NECK NORTH HIGH SCHOOL public Regular School No High 09 12 2021   grade_7 0.0 0.0 0.0         0.0     0.0   0.0 0.0     0       *     0   0 0 0 0         0     0   0 0     0       0   0
1476267 NY Nassau   school 3612510 280407030000   GREAT NECK 361251002027 280407030016 VILLAGE SCHOOL public Alternative School No High 08 12 2021   grade_7 0.0   0.0         0.0         0.0 0.0             *     0   0 0   0         0         0 0             0   0
1476837 NY Nassau   school 3617700 280503060000   LOCUST VALLEY 361770001664 280503060002 LOCUST VALLEY MIDDLE SCHOOL public Regular School No Middle 06 10 2021   grade_7 87.0 2.0 28.0         7.0     1.0   63.0 62.0     8       *     19   125 87 2 28         7     1   63 62     8       19   125
1477863 NY New York   school 3600135 307500010000   NYC SPEC SCHOOLS - DIST 75 360013503340 307500011035 PS 35 public Special Education School No Other 04 12 2021   grade_7 0.0 0.0 1.0   0.0     0.0     0.0   0.0 1.0     0       *     0   1 0 0 1   0     0     0   0 1     0       0   1
1477977 NY New York   school 3600135 307500010000   NYC SPEC SCHOOLS - DIST 75 360013502026 307500011721 PS 721 MANHATTAN OCC TRNING CTR public Special Education School No High 09 12 2021   grade_7 0.0 0.0 4.0         0.0     0.0   4.0 0.0     *       *     *   4 0 0 4         0     0   4 0                 4
1478205 NY New York   school 3600135 307500010000   NYC SPEC SCHOOLS - DIST 75 360013506649 307500012596 MS 596 public Special Education School No Elementary PK 08 2021   grade_7 0.0 0.0 1.0   0.0     0.0         1.0 0.0     0       *     *   1 0 0 1   0     0         1 0     0           1
1478509 NY New York   school 3600135 307500010000   NYC SPEC SCHOOLS - DIST 75 360013500812 307500013372 PS 372 CHILDREN'S SCHOOL (THE) public Special Education School No Elementary PK 07 2021   grade_7 0.0 4.0 1.0   0.0     0.0     0.0   3.0 2.0     0       *     5   5 0 4 1   0     0     0   3 2     0       5   5
1478566 NY New York   school 3600135 307500010000   NYC SPEC SCHOOLS - DIST 75 360013501927 307500013721 PS 721 BROOKLYN OCCUP TRNING CTR public Special Education School No Other KG 12 2021   grade_7 1.0 0.0 0.0   0.0     0.0         1.0 0.0     0       *     *   1 1 0 0   0     0         1 0     0           1
1478585 NY New York   school 3600135 307500010000   NYC SPEC SCHOOLS - DIST 75 360013504319 307500013753 PS 753 SCHOOL FOR CAREER DVLPMNT public Special Education School No High 06 12 2021   grade_7 0.0 2.0 3.0         0.0     0.0   4.0 1.0     *       *     *   5 0 2 3         0     0   4 1                 5
1480143 NY New York   school 3600077 310200010000   NYC GEOG DIST # 2 - MANHATTAN 360007704406 310200010217 PS/IS 217 ROOSEVELT ISLAND public Regular School No Elementary PK 08 2021   grade_7 12.0 4.0 8.0   0.0     8.0     0.0   14.0 18.0     *       *     9   32 12 4 8   0     8     0   14 18             9   32
1482385 NY New York   school 3600078 310300010000   NYC GEOG DIST # 3 - MANHATTAN 360007805773 310300010334 ANDERSON SCHOOL (THE) public Regular School No Elementary KG 08 2021   grade_7 28.0 1.0 3.0         19.0     5.0   30.0 26.0     *       *     8   56 28 1 3         19     5   30 26             8   56
1482727 NY New York   school 3600078 310300010000   NYC GEOG DIST # 3 - MANHATTAN 360007806115 310300011859 SPECIAL MUSIC SCHOOL public Regular School No Other KG 12 2021   grade_7 10.0 1.0 1.0   0.0     1.0     1.0   7.0 7.0     *       *     *   14 10 1 1   0     1     1   7 7                 14
1482841 NY New York   school 3600169 310300860897   SUCCESS ACAD-HARLEM 1 360016905862 310300860897 SUCCESS ACADEMY CHARTER-HARLEM 1 charter Regular School Yes Other KG 12 2021   grade_7 2.0 37.0 23.0   4.0     0.0     0.0   38.0 28.0     0       *     *   66 2 37 23   4     0     0   38 28     0           66
1483658 NY New York   school 3600142 310400861061   NYC AUTISM CHARTER-EAST HARLE 360014205779 310400861061 NYC AUTISM CHARTER SCHOOL EAST HARLE charter Special Education School Yes Other 01 12 2021   grade_7 1.0 0.0 0.0   0.0     0.0     0.0   0.0 1.0     *       *     *   1 1 0 0   0     0     0   0 1                 1
1486280 NY Niagara   school 3621240 400900010000   NORTH TONAWANDA 362124003007 400900010012 NORTH TONAWANDA MIDDLE SCHOOL public Regular School No Middle 07 08 2021   grade_7 215.0 3.0 9.0   1.0     2.0     13.0   130.0 113.0     *       *     *   243 215 3 9   1     2     13   130 113                 243
1486926 NY Oneida   school 3624360 411701040000   REMSEN 362436003338 411701040002 REMSEN JUNIOR-SENIOR HIGH SCHOOL public Regular School No High 07 12 2021   grade_7 27.0   0.0               0.0   11.0 16.0             *     *   27 27   0               0   11 16                 27
1488180 NY Onondaga   school 3609990 420401060000   EAST SYRACUSE MINOA 360999004718 420401060001 PARK HILL SCHOOL public Regular School No Prekindergarten PK PK 2021   grade_7 0.0 0.0 0.0         0.0     0.0   0.0 0.0             *     *   0 0 0 0         0     0   0 0                 0
1488370 NY Onondaga   school 3609090 420411060000   JAMESVILLE-DEWITT 360909000698 420411060005 JAMESVILLE-DEWITT MIDDLE SCHOOL public Regular School No Middle 05 08 2021   grade_7 144.0 16.0 7.0   2.0     20.0     16.0   95.0 110.0     5       *     17   205 144 16 7   2     20     16   95 110     5       17   205
1488446 NY Onondaga   school 3615990 420501060000   JORDAN ELBRIDGE 361599002581 420501060004 JORDAN-ELBRIDGE MIDDLE SCHOOL public Regular School No Middle 04 08 2021   grade_7 79.0 0.0 5.0   1.0     0.0     0.0   47.0 38.0     *       *     *   85 79 0 5   1     0     0   47 38                 85
1489092 NY Onondaga   school 3617520 421501060000   LIVERPOOL 361752001560 421501060002 CHESTNUT HILL MIDDLE SCHOOL public Regular School No Middle 07 08 2021   grade_7 110.0 23.0 4.0   0.0     23.0     12.0   98.0 74.0     10       *     *   172 110 23 4   0     23     12   98 74     10           172
1489510 NY Onondaga   school 3628590 421800010000   SYRACUSE 362859003870 421800010011 MEACHEM ELEMENTARY SCHOOL public Regular School No Elementary PK 07 2021   grade_7 1.0 0.0 0.0   0.0           0.0   1.0 0.0             *     *   1 1 0 0   0           0   1 0                 1
1490137 NY Ontario   school 3606330 430300050000   CANANDAIGUA 360633000416 430300050004 CANANDAIGUA MIDDLE SCHOOL public Regular School No Middle 06 08 2021   grade_7 234.0 2.0 19.0   0.0     5.0     10.0   138.0 132.0     *       *     49   270 234 2 19   0     5     10   138 132             49   270
1490878 NY Orange   school 3608430 440301060000   CORNWALL 360843005575 440301060005 CORNWALL MIDDLE SCHOOL public Regular School No Middle 05 08 2021   grade_7 159.0 13.0 47.0   0.0     12.0     7.0   115.0 123.0     8       *     34   238 159 13 47   0     12     7   115 123     8       34   238
1490916 NY Orange   school 3623010 440401060000   PINE BUSH 362301003225 440401060004 CRISPELL MIDDLE SCHOOL public Regular School No Middle 06 08 2021   grade_7 159.0 9.0 17.0   2.0     3.0     6.0   98.0 98.0     *       *     *   196 159 9 17   2     3     6   98 98                 196
1491068 NY Orange   school 3612330 440601040000   GOSHEN 361233000997 440601040004 C J HOOKER MIDDLE SCHOOL public Regular School No Middle 06 08 2021   grade_7 175.0 8.0 44.0         11.0     6.0   126.0 118.0     *       *     35   244 175 8 44         11     6   126 118             35   244
1493025 NY Oswego   school 3622920 462001060000   PHOENIX 362292003221 462001060004 EMERSON J DILLON MIDDLE SCHOOL public Regular School No Middle 05 08 2021   grade_7 112.0 1.0 1.0               5.0   63.0 56.0             *     14   119 112 1 1               5   63 56             14   119
1493557 NY Putnam   school 3618120 480101060000   MAHOPAC 361812006584 480101060008 MAHOPAC FALLS SCHOOL public Alternative School No Middle 06 08 2021   grade_7 1.0   0.0         1.0         2.0 0.0             *     *   2 1   0         1         2 0                 2
1493728 NY Putnam   school 3611860 480404020000   GARRISON 361186000948 480404020001 GARRISON SCHOOL public Regular School No Elementary KG 08 2021   grade_7 22.0 0.0 5.0         0.0     1.0   14.0 14.0     *       *     5   28 22 0 5         0     1   14 14             5   28
1500435 NY Queens   school 3600102 343000010000   NYC GEOG DIST #30 - QUEENS 360010202535 343000010235 ACADEMY FOR NEW AMERICANS public Regular School No Middle 06 08 2021   grade_7 2.0 0.0 23.0   0.0     3.0         18.0 10.0     28       *     *   28 2 0 23   0     3         18 10     28           28
1503304 NY Rockland   school 3620340 500101060000   CLARKSTOWN 362034004444 500101060020 BIRCHWOOD SCHOOL public Special Education School No Other KG 12 2021   grade_7 3.0 0.0 4.0         0.0     0.0   6.0 1.0     *       *     7   7 3 0 4         0     0   6 1             7   7
1503418 NY Rockland   school 3620190 500108030000   NANUET 362019001853 500108030003 A MACARTHUR BARR MIDDLE SCH public Regular School No Middle 07 08 2021   grade_7 79.0 12.0 39.0         38.0     5.0   88.0 85.0     10       *     *   173 79 12 39         38     5   88 85     10           173
1503608 NY Rockland   school 3614010 500201060000   HAVERSTRAW-STONY POINT 361401005738 500201060013 FIELDSTONE MIDDLE SCHOOL public Regular School No Middle 07 08 2021   grade_7 138.0 89.0 360.0   1.0     21.0     2.0   323.0 288.0     116       *     88   611 138 89 360   1     21     2   323 288     116       88   611
1504482 NY Saint Lawrence   school 3612360 511101060000   GOUVERNEUR 361236001000 511101060006 GOUVERNEUR ELEMENTARY SCHOOL public Regular School No Elementary PK 04 2021   grade_7 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0     *       *     0   0 0 0 0   0     0     0   0 0             0   0
1506116 NY Schenectady   school 3626310 530202060000   SCOTIA GLENVILLE 362631003610 530202060007 SCOTIA-GLENVILLE MIDDLE SCHOOL public Regular School No Middle 06 08 2021   grade_7 158.0 9.0 7.0   1.0     1.0     0.0   92.0 84.0     *       *     *   176 158 9 7   1     1     0   92 84                 176
1506705 NY Schoharie   school 3612120 540801040000   GILBOA CONESVILLE 361212000970 540801040001 GILBOA-CONESVILLE CENTRAL SCHOOL public Regular School No Other PK 12 2021   grade_7 19.0 1.0 0.0         0.0     0.0   12.0 8.0             *     5   20 19 1 0         0     0   12 8             5   20
1507864 NY Steuben   school 3600011 573002040000   WAYLAND-COHOCTON 360001101445 573002040004 COHOCTON ELEMENTARY SCHOOL public Regular School No Prekindergarten PK PK 2021   grade_7 0.0                   0.0   0.0 0.0             *     *   0 0                   0   0 0                 0
1508852 NY Suffolk   school 3628200 580201060000   THREE VILLAGE 362820003806 580201060009 PAUL J GELINAS JUNIOR HIGH SCHOOL public Regular School No Middle 07 09 2021   grade_7 194.0 2.0 20.0   1.0     22.0     5.0   112.0 132.0     *       *     30   244 194 2 20   1     22     5   112 132             30   244
1509536 NY Suffolk   school 3624840 580209020000   ROCKY POINT 362484005420 580209020004 ROCKY POINT MIDDLE SCHOOL public Regular School No Middle 06 08 2021   grade_7 155.0 3.0 36.0         3.0     10.0   91.0 116.0     *       *     41   207 155 3 36         3     10   91 116             41   207
1510467 NY Suffolk   school 3600008 580235060000   SOUTH COUNTRY 360000800192 580235060004 BELLPORT MIDDLE SCHOOL public Regular School No Middle 06 08 2021   grade_7 129.0 57.0 131.0   1.0     5.0     15.0   183.0 155.0     37       *     53   338 129 57 131   1     5     15   183 155     37       53   338
1510847 NY Suffolk   school 3608010 580402060000   COLD SPRING HARBOR 360801001044 580402060005 GOOSEHILL PRIMARY CENTER public Regular School No Elementary KG 01 2021   grade_7 0.0   0.0         0.0     0.0   0.0 0.0     0       *     0   0 0   0         0     0   0 0     0       0   0
1511379 NY Suffolk   school 3613620 580406060000   HARBORFIELDS 361362001116 580406060005 OLDFIELD MIDDLE SCHOOL public Regular School No Middle 06 08 2021   grade_7 189.0 9.0 39.0   1.0     12.0     12.0   140.0 122.0     5       *     48   262 189 9 39   1     12     12   140 122     5       48   262
1512519 NY Suffolk   school 3608160 580507060000   CONNETQUOT 360816000603 580507060011 OAKDALE-BOHEMIA MIDDLE SCHOOL public Regular School No Middle 06 08 2021   grade_7 152.0 2.0 31.0         6.0     2.0   102.0 91.0     *       *     *   193 152 2 31         6     2   102 91                 193
1513393 NY Suffolk   school 3617400 580603020000   LITTLE FLOWER 361740001552 580603020001 LITTLE FLOWER SCHOOL public Special Education School No Other 03 12 2021   grade_7 2.0 0.0 3.0               0.0   4.0 1.0             *     5   5 2 0 3               0   4 1             5   5
1513735 NY Suffolk   school 3616260 580805060000   KINGS PARK 361626001483 580805060007 WILLIAM T ROGERS MIDDLE SCHOOL public Regular School No Middle 06 08 2021   grade_7 179.0 1.0 29.0         3.0     3.0   105.0 110.0     *       *     *   215 179 1 29         3     3   105 110                 215
1513811 NY Suffolk   school 3631020 580902020000   WESTHAMPTON BEACH 363102004167 580902020004 WESTHAMPTON MIDDLE SCHOOL public Regular School No Middle 06 08 2021   grade_7 121.0 2.0 46.0   1.0     2.0     5.0   85.0 92.0     13       *     24   177 121 2 46   1     2     5   85 92     13       24   177
1513830 NY Suffolk   school 3624060 580903020000   QUOGUE 362406003319 580903020001 QUOGUE ELEMENTARY SCHOOL public Regular School No Elementary PK 06 2021   grade_7 0.0   0.0         0.0     0.0   0.0 0.0     *       *     0   0 0   0         0     0   0 0             0   0
1513925 NY Suffolk   school 3627540 580906030000   SOUTHAMPTON 362754003744 580906030002 SOUTHAMPTON INTERMEDIATE SCHOOL public Regular School No Middle 05 10 2021   grade_7 33.0 0.0 38.0   8.0     0.0     1.0   38.0 42.0     *       *     *   80 33 0 38   8     0     1   38 42                 80
1514134 NY Suffolk   school 3621930 581002020000   OYSTERPONDS 362193003114 581002020001 OYSTERPONDS ELEMENTARY SCHOOL public Regular School No Elementary PK 06 2021   grade_7 0.0 0.0 0.0         0.0     0.0   0.0 0.0     0       *     0   0 0 0 0         0     0   0 0     0       0   0
1514191 NY Suffolk   school 3627620 581005020000   SOUTHOLD 362762003751 581005020003 SOUTHOLD JUNIOR-SENIOR HIGH SCHOOL public Regular School No High 07 12 2021   grade_7 30.0 2.0 21.0         0.0     1.0   32.0 22.0     11       *     6   54 30 2 21         0     1   32 22     11       6   54
1515122 NY Tompkins   school 3615030 610327020000   GEORGE JR REPUBLIC 361503001257 610327020002 GEORGE JUNIOR REPUBLIC SCHOOL public Special Education School No High 07 12 2021   grade_7 1.0 1.0 0.0   0.0           0.0   2.0 0.0             *     *   2 1 1 0   0           0   2 0                 2
1516243 NY Ulster   school 3625800 621601060000   SAUGERTIES 362580002741 621601060005 SAUGERTIES JUNIOR HIGH SCHOOL public Regular School No Middle 07 08 2021   grade_7 136.0 5.0 31.0         1.0     21.0   105.0 89.0     *       *     *   194 136 5 31         1     21   105 89                 194
1516414 NY Ulster   school 3610500 622002060000   ELLENVILLE 361050003217 622002060005 ELLENVILLE MIDDLE SCHOOL public Regular School No Middle 06 08 2021   grade_7 57.0 8.0 51.0   0.0     1.0     12.0   65.0 64.0     *       *     28   129 57 8 51   0     1     12   65 64             28   129
1517136 NY Washington   school 3625470 641501040000   SALEM 362547003521 641501040001 SALEM HIGH SCHOOL public Regular School No High 07 12 2021   grade_7 33.0 0.0 2.0   0.0               12.0 23.0             *     *   35 33 0 2   0               12 23                 35

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

CREATE TABLE "enrollments" (
   [state] TEXT,
   [county] TEXT,
   [county_state_id] INTEGER,
   [admin_level] TEXT,
   [district_nces_id] INTEGER,
   [district_state_id] TEXT,
   [district_state_type] TEXT,
   [district] TEXT,
   [school_nces_id] INTEGER,
   [school_state_id] INTEGER,
   [school] TEXT,
   [school_state_type] TEXT,
   [ccd_school_type] TEXT,
   [ccd_charter_school] TEXT,
   [ccd_school_lvl] TEXT,
   [ccd_school_low_grade] TEXT,
   [ccd_school_high_grade] TEXT,
   [year] INTEGER,
   [term] TEXT,
   [grade] TEXT,
   [white] TEXT,
   [black] TEXT,
   [hispanic] TEXT,
   [native_american] TEXT,
   [native_american_alaskan_native] TEXT,
   [asian] TEXT,
   [native_hawaiian] TEXT,
   [asian_pacific_islander] TEXT,
   [native_hawaiian_pacific_islander] TEXT,
   [pacific_islander] TEXT,
   [multiracial] TEXT,
   [unknown_race] TEXT,
   [male] TEXT,
   [female] TEXT,
   [non_binary] TEXT,
   [unknown_gender] TEXT,
   [ell] TEXT,
   [ell_percent] TEXT,
   [homeless] TEXT,
   [homeless_percent] TEXT,
   [low_income] TEXT,
   [free_and_reduced] TEXT,
   [free_and_reduced_percent] TEXT,
   [disability] TEXT,
   [section_504] TEXT,
   [total] TEXT
, [white_int] INTEGER, [black_int] INTEGER, [hispanic_int] INTEGER, [native_american_int] INTEGER, [native_american_alaskan_native_int] INTEGER, [asian_int] INTEGER, [native_hawaiian_int] INTEGER, [asian_pacific_islander_int] INTEGER, [native_hawaiian_pacific_islander_int] INTEGER, [pacific_islander_int] INTEGER, [multiracial_int] INTEGER, [unknown_race_int] INTEGER, [male_int] INTEGER, [female_int] INTEGER, [non_binary_int] INTEGER, [unknown_gender_int] INTEGER, [ell_int] INTEGER, [homeless_int] INTEGER, [low_income_int] INTEGER, [free_and_reduced_int] INTEGER, [disability_int] INTEGER, [section_504_int] INTEGER, [total_int] INTEGER);
CREATE INDEX [idx_enrollments_state_grade]
    ON [enrollments] ([state], [grade]);
CREATE INDEX [idx_enrollments_grade]
    ON [enrollments] ([grade]);
CREATE INDEX [idx_enrollments_year]
    ON [enrollments] ([year]);
CREATE INDEX [idx_enrollments_state_year]
    ON [enrollments] ([state], [year]);
CREATE INDEX [idx_enrollments_school_nces_id]
    ON [enrollments] ([school_nces_id]);
CREATE INDEX [idx_enrollments_district_nces_id]
    ON [enrollments] ([district_nces_id]);