Data source: Big Local News · About: Big Local

90,079 rows where state = "NY" and year = 2021 sorted by ell descending

View and edit SQL

year

  • 2021 · 90,079
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
1462364 NY Kings   school 3600120 331900010000   NYC GEOG DIST #19 - BROOKLYN 360012002604 331900010171 IS 171 ABRAHAM LINCOLN public Regular School No Middle 06 08 2021   pk_12_total 3.0 26.0 275.0   6.0     26.0         200.0 136.0     99       322     61   336 3 26 275   6     26         200 136     99   322   61   336
1472054 NY Nassau   school 3612180 280100010000   GLEN COVE 361218000977 280100010008 ROBERT M FINLEY MIDDLE SCHOOL public Regular School No Middle 06 08 2021   pk_12_total 179.0 62.0 474.0         20.0     13.0   365.0 383.0     99       560     140   748 179 62 474         20     13   365 383     99   560   140   748
1477298 NY Nassau   school 3614340 280517030000   HICKSVILLE 361434001188 280517030006 OLD COUNTRY ROAD SCHOOL public Regular School No Elementary KG 05 2021   pk_12_total 40.0 8.0 188.0   3.0     84.0     6.0   160.0 169.0     99       154     20   329 40 8 188   3     84     6   160 169     99   154   20   329
1478742 NY New York   school 3600135 307500010000   NYC SPEC SCHOOLS - DIST 75 360013502858 307500014224 PS 224 public Special Education School No Elementary PK 08 2021   pk_12_total 38.0 63.0 139.0   28.0     117.0     7.0   293.0 99.0     99       286     385   392 38 63 139   28     117     7   293 99     99   286   385   392
1484537 NY New York   school 3600083 310600010000   NYC GEOG DIST # 6 - MANHATTAN 360008301675 310600010004 PS 4 DUKE ELLINGTON public Regular School No Elementary PK 05 2021   pk_12_total 3.0 43.0 392.0   6.0     14.0     1.0   241.0 218.0     99       361     92   459 3 43 392   6     14     1   241 218     99   361   92   459
1493951 NY Queens   school 3600098 342400010000   NYC GEOG DIST #24 - QUEENS 360009802084 342400010014 PS 14 FAIRVIEW public Regular School No Elementary KG 05 2021   grade_2 2.0 2.0 173.0   0.0     11.0     3.0   91.0 100.0     99       147     40   191 2 2 173   0     11     3   91 100     99   147   40   191
1510472 NY Suffolk   school 3600008 580235060000   SOUTH COUNTRY 360000800192 580235060004 BELLPORT MIDDLE SCHOOL public Regular School No Middle 06 08 2021   pk_12_total 348.0 159.0 402.0   5.0     23.0     46.0   494.0 489.0     99       600     148   983 348 159 402   5     23     46   494 489     99   600   148   983
1511840 NY Suffolk   school 3604080 580501030000   BAY SHORE 360408000165 580501030007 BAY SHORE MIDDLE SCHOOL public Regular School No Middle 06 08 2021   pk_12_total 342.0 239.0 615.0   4.0     63.0     55.0   682.0 636.0     99       777     217   1318 342 239 615   4     63     55   682 636     99   777   217   1318
1520618 NY Westchester   school 3622020 661401030000   OSSINING 362202003120 661401030002 CLAREMONT SCHOOL public Regular School No Elementary 03 05 2021   pk_12_total 131.0 54.0 476.0         17.0     24.0   364.0 338.0     99       446     75   702 131 54 476         17     24   364 338     99   446   75   702
1440058 NY Bronx   school 3600087 321000010000   NYC GEOG DIST #10 - BRONX 360008706397 321000011351 BRONX COLLABORATIVE HIGH SCHOOL public Regular School No High 09 12 2021   pk_12_total 19.0 142.0 351.0   7.0     19.0     6.0   280.0 264.0     98       438     139   544 19 142 351   7     19     6   280 264     98   438   139   544
1463604 NY Kings   school 3600151 332000010000   NYC GEOG DIST #20 - BROOKLYN 360015102618 332000010176 PS 176 OVINGTON public Regular School No Elementary KG 05 2021   grade_1 16.0 3.0 26.0   0.0     125.0     2.0   90.0 82.0     98       157     20   172 16 3 26   0     125     2   90 82     98   157   20   172
1473187 NY Nassau   school 3611550 280209030000   FREEPORT 361155000911 280209030003 CAROLINE G ATKINSON SCHOOL public Regular School No Middle 05 06 2021   grade_5 37.0 88.0 326.0   2.0     1.0     13.0   241.0 226.0     98       307     69   467 37 88 326   2     1     13   241 226     98   307   69   467
1475531 NY Nassau   school 3617730 280300010000   LONG BEACH 361773001599 280300010008 LONG BEACH HIGH SCHOOL public Regular School No High 09 12 2021   pk_12_total 765.0 94.0 386.0         62.0     5.0   674.0 638.0     98       327     191   1312 765 94 386         62     5   674 638     98   327   191   1312
1475634 NY Nassau   school 3630960 280401030000   WESTBURY 363096004162 280401030007 WESTBURY HIGH SCHOOL public Regular School No High 09 12 2021   grade_12 5.0 87.0 263.0   2.0     8.0     0.0   191.0 174.0     98       250     27   365 5 87 263   2     8     0   191 174     98   250   27   365
1478723 NY New York   school 3600135 307500010000   NYC SPEC SCHOOLS - DIST 75 360013504354 307500014177 PS 177 public Special Education School No Elementary KG 08 2021   pk_12_total 84.0 127.0 90.0   6.0     91.0     3.0   308.0 93.0     98       324     401   401 84 127 90   6     91     3   308 93     98   324   401   401
1489914 NY Onondaga   school 3628590 421800010000   SYRACUSE 362859006481 421800010072 DELAWARE PRIMARY SCHOOL public Regular School No Elementary PK 05 2021   pk_12_total 63.0 184.0 217.0   1.0     1.0     50.0   268.0 248.0     98       460     115   516 63 184 217   1     1     50   268 248     98   460   115   516
1494441 NY Queens   school 3600098 342400010000   NYC GEOG DIST #24 - QUEENS 360009806430 342400010211 ELM TREE ELEMENTARY SCHOOL public Regular School No Elementary PK 05 2021   grade_1 10.0 8.0 142.0   0.0     17.0     0.0   74.0 103.0     98       165     30   177 10 8 142   0     17     0   74 103     98   165   30   177
1497149 NY Queens   school 3600123 342700010000   NYC GEOG DIST #27 - QUEENS 360012302704 342700010210 JHS 210 ELIZABETH BLACKWELL public Regular School No Middle 06 08 2021   grade_8 22.0 37.0 373.0   17.0     185.0     3.0   347.0 290.0     98       474     113   637 22 37 373   17     185     3   347 290     98   474   113   637
1503005 NY Richmond   school 3601019 353100860984   NEW WORLD PREP CHARTER SCHOO 360101906215 353100860984 NEW WORLD PREP CHARTER SCHOOL charter Regular School Yes Middle KG 08 2021   pk_12_total 14.0 170.0 430.0   5.0     9.0     4.0   285.0 347.0     98       573     169   632 14 170 430   5     9     4   285 347     98   573   169   632
1504022 NY Rockland   school 3627810 500402060000   EAST RAMAPO 362781003770 500402060001 FLEETWOOD ELEMENTARY SCHOOL public Regular School No Elementary KG 03 2021   grade_3 1.0 23.0 141.0   0.0     0.0     0.0   87.0 78.0     98       150     17   165 1 23 141   0     0     0   87 78     98   150   17   165
1504213 NY Rockland   school 3627810 500402060000   EAST RAMAPO 362781003769 500402060016 ELMWOOD ELEMENTARY SCHOOL public Regular School No Elementary KG 06 2021   grade_4 3.0 34.0 125.0         9.0     1.0   91.0 81.0     98       154     *   172 3 34 125         9     1   91 81     98   154       172
1504252 NY Rockland   school 3627810 500402060000   EAST RAMAPO 362781003775 500402060019 LIME KILN ELEMENTARY SCHOOL public Regular School No Elementary 01 06 2021   grade_5 3.0 43.0 123.0         5.0     2.0   98.0 78.0     98       156     25   176 3 43 123         5     2   98 78     98   156   25   176
1510244 NY Suffolk   school 3618690 580232030000   WILLIAM FLOYD 361869004677 580232030008 JOHN S HOBART ELEMENTARY SCHOOL public Regular School No Elementary KG 05 2021   pk_12_total 223.0 168.0 329.0   3.0     17.0     58.0   417.0 381.0     98       489     133   798 223 168 329   3     17     58   417 381     98   489   133   798
1510909 NY Suffolk   school 3615090 580403030000   HUNTINGTON 361509001264 580403030005 JEFFERSON SCHOOL public Regular School No Elementary KG 03 2021   pk_12_total 78.0 12.0 188.0         7.0     8.0   132.0 161.0     98       172     44   293 78 12 188         7     8   132 161     98   172   44   293
1511666 NY Suffolk   school 3627300 580413030000   SOUTH HUNTINGTON 362730003729 580413030011 WALT WHITMAN HIGH SCHOOL public Regular School No High 09 12 2021   grade_9 182.0 41.0 281.0   0.0     24.0     19.0   284.0 263.0     98       332     84   547 182 41 281   0     24     19   284 263     98   332   84   547
1435327 NY Bronx   school 3600084 320700010000   NYC GEOG DIST # 7 - BRONX 360008405504 320700011551 URBAN ASSEMBLY BRONX OF LETTERS public Regular School No High 06 12 2021   pk_12_total 18.0 193.0 398.0   6.0     4.0     1.0   326.0 294.0     97       575     180   620 18 193 398   6     4     1   326 294     97   575   180   620
1438364 NY Bronx   school 3600086 320900010000   NYC GEOG DIST # 9 - BRONX 360008605981 320900011365 ACADEMY FOR LANGUAGE AND TECHNOLOGY public Regular School No High 09 12 2021   grade_9     97.0                   57.0 40.0     97       95     *   97     97                   57 40     97   95       97
1439108 NY Bronx   school 3600087 321000010000   NYC GEOG DIST #10 - BRONX 360008705138 321000010059 PS 59 COMM SCHOOL OF TECHNOLOGY public Regular School No Elementary PK 05 2021   pk_12_total 9.0 136.0 315.0   4.0     2.0     1.0   253.0 214.0     97       466     127   467 9 136 315   4     2     1   253 214     97   466   127   467
1439355 NY Bronx   school 3600087 321000010000   NYC GEOG DIST #10 - BRONX 360008704693 321000010207 PS 207 public Regular School No Elementary PK 05 2021   pk_12_total 26.0 26.0 326.0   3.0     10.0     1.0   203.0 189.0     97       332     85   392 26 26 326   3     10     1   203 189     97   332   85   392
1442965 NY Bronx   school 3601027 321200860965   DR R IZQUIERDO HEALTH/SCIENC 360102706234 321200860965 DR R IZQUIERDO HEALTH/SCIENCE CHARTE charter Regular School Yes High 06 12 2021   pk_12_total 16.0 160.0 555.0   3.0     2.0     3.0   350.0 389.0     97       695     144   739 16 160 555   3     2     3   350 389     97   695   144   739
1452959 NY Erie   school 3616440 141800010000   LACKAWANNA 361644001452 141800010008 LACKAWANNA HIGH SCHOOL public Regular School No High 09 12 2021   pk_12_total 354.0 80.0 51.0   4.0     10.0     14.0   276.0 237.0     97       361     81   513 354 80 51   4     10     14   276 237     97   361   81   513
1458241 NY Kings   school 3600119 331400010000   NYC GEOG DIST #14 - BROOKLYN 360011903091 331400011478 HIGH SCHOOL-ENTERPRISE, BUS & TECH public Regular School No High 09 12 2021   pk_12_total 22.0 191.0 415.0   10.0     51.0     3.0   452.0 240.0     97       627     134   692 22 191 415   10     51     3   452 240     97   627   134   692
1458744 NY Kings   school 3600092 331500010000   NYC GEOG DIST #15 - BROOKLYN 360009202359 331500010094 PS 94 HENRY LONGFELLOW (THE) public Regular School No Elementary KG 05 2021   grade_2 4.0 1.0 39.0   1.0     146.0     1.0   104.0 88.0     97       190     *   192 4 1 39   1     146     1   104 88     97   190       192
1458745 NY Kings   school 3600092 331500010000   NYC GEOG DIST #15 - BROOKLYN 360009202359 331500010094 PS 94 HENRY LONGFELLOW (THE) public Regular School No Elementary KG 05 2021   grade_3 1.0 0.0 50.0   0.0     164.0     0.0   114.0 101.0     97       215     20   215 1 0 50   0     164     0   114 101     97   215   20   215
1472339 NY Nassau   school 3629280 280202030000   UNIONDALE 362928003942 280202030006 SMITH STREET ELEMENTARY SCHOOL public Regular School No Elementary PK 05 2021   pk_12_total 11.0 163.0 280.0   2.0     3.0     2.0   257.0 204.0     97       271     69   461 11 163 280   2     3     2   257 204     97   271   69   461
1478096 NY New York   school 3600135 307500010000   NYC SPEC SCHOOLS - DIST 75 360013502224 307500012168 PS 168 public Special Education School No Other PK 12 2021   pk_12_total 18.0 176.0 292.0   6.0     19.0     4.0   379.0 136.0     97       448     511   515 18 176 292   6     19     4   379 136     97   448   511   515
1478552 NY New York   school 3600135 307500010000   NYC SPEC SCHOOLS - DIST 75 360013504782 307500013396 PS 396 public Special Education School No Elementary KG 07 2021   pk_12_total 36.0 246.0 93.0   74.0     31.0     1.0   347.0 134.0     97       429     481   481 36 246 93   74     31     1   347 134     97   429   481   481
1489477 NY Onondaga   school 3628590 421800010000   SYRACUSE 362859003856 421800010008 EDWARD SMITH K-8 SCHOOL public Regular School No Elementary PK 08 2021   pk_12_total 246.0 304.0 50.0   3.0     26.0     56.0   352.0 333.0     97       438     172   685 246 304 50   3     26     56   352 333     97   438   172   685
1491453 NY Orange   school 3619650 441201060000   MONROE WOODBURY 361965001795 441201060006 MONROE-WOODBURY HIGH SCHOOL public Regular School No High 09 12 2021   pk_12_total 1224.0 234.0 763.0   3.0     172.0     42.0   1236.0 1202.0     97       733     362   2438 1224 234 763   3     172     42   1236 1202     97   733   362   2438
1493952 NY Queens   school 3600098 342400010000   NYC GEOG DIST #24 - QUEENS 360009802084 342400010014 PS 14 FAIRVIEW public Regular School No Elementary KG 05 2021   grade_3 6.0 1.0 230.0   1.0     10.0     0.0   109.0 139.0     97       206     46   248 6 1 230   1     10     0   109 139     97   206   46   248
1495801 NY Queens   school 3600122 342500010000   NYC GEOG DIST #25 - QUEENS 360012201950 342500011460 FLUSHING HIGH SCHOOL public Regular School No High 09 12 2021   grade_9 15.0 51.0 273.0   2.0     65.0     8.0   235.0 179.0     97       365     91   414 15 51 273   2     65     8   235 179     97   365   91   414
1497710 NY Queens   school 3600123 342700010000   NYC GEOG DIST #27 - QUEENS 360012302013 342700011480 JOHN ADAMS HIGH SCHOOL public Regular School No High 09 12 2021   grade_10 30.0 176.0 241.0   0.0     230.0     9.0   345.0 341.0     97       577     102   686 30 176 241   0     230     9   345 341     97   577   102   686
1502822 NY Richmond   school 3600103 353100010000   NYC GEOG DIST #31 - SI 360010302035 353100011440 NEW DORP HIGH SCHOOL public Regular School No High 09 12 2021   grade_11 506.0 97.0 259.0   1.0     106.0     5.0   520.0 454.0     97       598     334   974 506 97 259   1     106     5   520 454     97   598   334   974
1515621 NY Ulster   school 3616290 620600010000   KINGSTON 361629001432 620600010012 GEORGE WASHINGTON SCHOOL public Regular School No Elementary PK 04 2021   pk_12_total 166.0 49.0 189.0         19.0     39.0   224.0 238.0     97       266     95   462 166 49 189         19     39   224 238     97   266   95   462
1521242 NY Westchester   school 3623460 661904030000   PORT CHESTER-RYE 362346003278 661904030008 PORT CHESTER SENIOR HIGH SCHOOL public Regular School No High 09 12 2021   grade_9 48.0 11.0 338.0   3.0     2.0     1.0   216.0 187.0     97       272     54   403 48 11 338   3     2     1   216 187     97   272   54   403
1435422 NY Bronx   school 3600054 320700860820   KIPP ACADEMY CHARTER SCH 360005404452 320700860820 KIPP ACADEMY CHARTER SCHOOL charter Regular School Yes Other KG 12 2021   pk_12_total 11.0 476.0 625.0   7.0     2.0     5.0   570.0 556.0     96       1004     190   1126 11 476 625   7     2     5   570 556     96   1004   190   1126
1439730 NY Bronx   school 3600087 321000010000   NYC GEOG DIST #10 - BRONX 360008706297 321000010363 ACAD-PERSONAL LDSHP AND EXCELLENCE public Regular School No Middle 06 08 2021   grade_7 6.0 37.0 246.0   5.0     10.0     0.0   169.0 135.0     96       283     73   304 6 37 246   5     10     0   169 135     96   283   73   304
1440343 NY Bronx   school 3600087 321000010000   NYC GEOG DIST #10 - BRONX 360008705557 321000011549 DISCOVERY HIGH SCHOOL public Regular School No High 08 12 2021   pk_12_total 8.0 80.0 360.0   1.0     17.0     1.0   258.0 209.0     96       427     124   467 8 80 360   1     17     1   258 209     96   427   124   467
1457222 NY Kings   school 3600091 331300010000   NYC GEOG DIST #13 - BROOKLYN 360009101371 331300011439 BROOKLYN INTERNATIONAL HS public Regular School No High 09 12 2021   grade_11 5.0 27.0 49.0         28.0         56.0 53.0     96       99     0   109 5 27 49         28         56 53     96   99   0   109
1463475 NY Kings   school 3600151 332000010000   NYC GEOG DIST #20 - BROOKLYN 360015102396 332000010105 PS 105 BLYTHEBOURNE (THE) public Regular School No Elementary KG 05 2021   grade_2 4.0 0.0 8.0   1.0     182.0         109.0 86.0     96       174     26   195 4 0 8   1     182         109 86     96   174   26   195
1478533 NY New York   school 3600135 307500010000   NYC SPEC SCHOOLS - DIST 75 360013500806 307500013373 PS 373 BROOKLYN TRANSITION CENTER public Special Education School No Secondary 09 11 2021   pk_12_total 23.0 206.0 140.0   3.0     11.0     3.0   278.0 108.0     96       349     386   386 23 206 140   3     11     3   278 108     96   349   386   386
1480148 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   pk_12_total 228.0 60.0 98.0   2.0     200.0     38.0   287.0 339.0     96       155     77   626 228 60 98   2     200     38   287 339     96   155   77   626
1487545 NY Oneida   school 3629370 412300010000   UTICA 362937003963 412300010024 THOMAS R PROCTOR HIGH SCHOOL public Regular School No High 09 12 2021   grade_10 201.0 161.0 119.0   2.0     135.0     32.0   316.0 334.0     96       509     98   650 201 161 119   2     135     32   316 334     96   509   98   650
1494474 NY Queens   school 3600098 342400010000   NYC GEOG DIST #24 - QUEENS 360009802739 342400010229 PS 229 EMANUEL KAPLAN public Regular School No Elementary PK 05 2021   pk_12_total 220.0 27.0 531.0   2.0     504.0     6.0   661.0 629.0     96       902     225   1290 220 27 531   2     504     6   661 629     96   902   225   1290
1501884 NY Richmond   school 3600103 353100010000   NYC GEOG DIST #31 - SI 360010302102 353100010019 PS 19 CURTIS SCHOOL (THE) public Regular School No Elementary PK 05 2021   pk_12_total 24.0 64.0 400.0   4.0     30.0     7.0   271.0 258.0     96       435     149   529 24 64 400   4     30     7   271 258     96   435   149   529
1509997 NY Suffolk   school 3622470 580224030000   PATCHOGUE-MEDFORD 362247003160 580224030003 BAY ELEMENTARY SCHOOL public Regular School No Elementary KG 05 2021   pk_12_total 135.0 18.0 186.0         9.0     15.0   178.0 185.0     96       213     25   363 135 18 186         9     15   178 185     96   213   25   363
1510111 NY Suffolk   school 3622470 580224030000   PATCHOGUE-MEDFORD 362247003162 580224030009 EAGLE ELEMENTARY SCHOOL public Regular School No Elementary PK 05 2021   pk_12_total 172.0 50.0 288.0         11.0     18.0   276.0 263.0     96       312     85   539 172 50 288         11     18   276 263     96   312   85   539
1510947 NY Suffolk   school 3615090 580403030000   HUNTINGTON 361509006451 580403030010 JACK ABRAMS STEM MAGNET SCHOOL public Regular School No Middle 04 06 2021   pk_12_total 209.0 39.0 184.0   1.0     14.0     21.0   265.0 203.0     96       226     75   468 209 39 184   1     14     21   265 203     96   226   75   468
1437911 NY Bronx   school 3600086 320900010000   NYC GEOG DIST # 9 - BRONX 360008605664 320900010323 BRONX WRITING ACADEMY public Regular School No Middle 06 08 2021   pk_12_total 12.0 88.0 223.0   2.0     6.0         171.0 160.0     95       317     86   331 12 88 223   2     6         171 160     95   317   86   331
1438994 NY Bronx   school 3600087 321000010000   NYC GEOG DIST #10 - BRONX 360008701304 321000010037 PS 37 MULTIPLE INTELLIGENCE SCHOOL public Regular School No Elementary KG 08 2021   pk_12_total 11.0 97.0 445.0   3.0     10.0     4.0   298.0 272.0     95       503     153   570 11 97 445   3     10     4   298 272     95   503   153   570
1447525 NY Columbia   school 3614940 101300010000   HUDSON 361494001248 101300010003 MONTGOMERY C SMITH ELEMENTARY public Regular School No Elementary PK 05 2021   pk_12_total 311.0 128.0 144.0   1.0     81.0     114.0   400.0 379.0     95       496     109   779 311 128 144   1     81     114   400 379     95   496   109   779
1458923 NY Kings   school 3600092 331500010000   NYC GEOG DIST #15 - BROOKLYN 360009202602 331500010169 PS 169 SUNSET PARK public Regular School No Elementary KG 05 2021   kindergarten_full_day 6.0 0.0 48.0   0.0     146.0     0.0   109.0 91.0     95       180     *   200 6 0 48   0     146     0   109 91     95   180       200
1464207 NY Kings   school 3600151 332000010000   NYC GEOG DIST #20 - BROOKLYN 360015105955 332000011609 URBAN ASSEMBLY SCHL-LEADER-EMPOWER public Regular School No High 06 12 2021   pk_12_total 105.0 66.0 107.0   5.0     291.0     11.0     585.0     95       515     100   585 105 66 107   5     291     11     585     95   515   100   585
1464860 NY Kings   school 3600152 332100010000   NYC GEOG DIST #21 - BROOKLYN 360015204312 332100011540 JOHN DEWEY HIGH SCHOOL public Regular School No High 09 12 2021   grade_11 74.0 139.0 119.0   0.0     166.0     9.0   244.0 263.0     95       422     51   507 74 139 119   0     166     9   244 263     95   422   51   507
1470629 NY Monroe   school 3624750 261600010000   ROCHESTER 362475003363 261600010061 EAST UPPER HIGH SCHOOL public Regular School No High 09 12 2021   pk_12_total 54.0 383.0 245.0   3.0     20.0     4.0   374.0 335.0     95       574     111   709 54 383 245   3     20     4   374 335     95   574   111   709
1478077 NY New York   school 3600135 307500010000   NYC SPEC SCHOOLS - DIST 75 360013503373 307500012017 PS 17 public Special Education School No Other KG 12 2021   pk_12_total 17.0 181.0 286.0   5.0     21.0         414.0 96.0     95       456     509   510 17 181 286   5     21         414 96     95   456   509   510
1481656 NY New York   school 3600077 310200010000   NYC GEOG DIST # 2 - MANHATTAN 360007704778 310200011575 MANHATTAN COMP NIGHT AND DAY HS public Regular School No High 10 12 2021   grade_11 6.0 48.0 103.0   2.0     27.0     1.0   98.0 89.0     95       156     33   187 6 48 103   2     27     1   98 89     95   156   33   187
1491472 NY Orange   school 3619650 441201060000   MONROE WOODBURY 361965001794 441201060009 MONROE-WOODBURY MIDDLE SCHOOL public Regular School No Middle 06 11 2021   pk_12_total 713.0 138.0 639.0   5.0     104.0     47.0   837.0 809.0     95       567     261   1646 713 138 639   5     104     47   837 809     95   567   261   1646
1493890 NY Queens   school 3600098 342400010000   NYC GEOG DIST #24 - QUEENS 360009801406 342400010007 PS 7 LOUIS F SIMEONE public Regular School No Elementary PK 05 2021   grade_1 14.0 1.0 53.0   4.0     133.0     2.0   103.0 104.0     95       177     *   207 14 1 53   4     133     2   103 104     95   177       207
1493896 NY Queens   school 3600098 342400010000   NYC GEOG DIST #24 - QUEENS 360009801406 342400010007 PS 7 LOUIS F SIMEONE public Regular School No Elementary PK 05 2021   grade_4 8.0 0.0 69.0   0.0     121.0     0.0   103.0 95.0     95       179     27   198 8 0 69   0     121     0   103 95     95   179   27   198
1493970 NY Queens   school 3600098 342400010000   NYC GEOG DIST #24 - QUEENS 360009804146 342400010016 PS 16 NANCY DEBENEDITTIS SCHOOL (THE public Regular School No Elementary KG 05 2021   grade_2 1.0 0.0 157.0   0.0     6.0     0.0   93.0 71.0     95       143     31   164 1 0 157   0     6     0   93 71     95   143   31   164
1495087 NY Queens   school 3600122 342500010000   NYC GEOG DIST #25 - QUEENS 360012202119 342500010024 PS 24 ANDREW JACKSON public Regular School No Elementary PK 05 2021   grade_1 2.0 2.0 22.0   2.0     127.0     1.0   92.0 64.0     95       103     25   156 2 2 22   2     127     1   92 64     95   103   25   156
1495791 NY Queens   school 3600122 342500010000   NYC GEOG DIST #25 - QUEENS 360012201950 342500011460 FLUSHING HIGH SCHOOL public Regular School No High 09 12 2021   grade_10 12.0 41.0 255.0   4.0     65.0     4.0   209.0 172.0     95       320     69   381 12 41 255   4     65     4   209 172     95   320   69   381
1496678 NY Queens   school 3600123 342700010000   NYC GEOG DIST #27 - QUEENS 360012304352 342700010056 PS 56 HARRY EICHLER public Regular School No Elementary 02 05 2021   pk_12_total 35.0 16.0 162.0   9.0     101.0     8.0   161.0 170.0     95       270     68   331 35 16 162   9     101     8   161 170     95   270   68   331
1497115 NY Queens   school 3600123 342700010000   NYC GEOG DIST #27 - QUEENS 360012302685 342700010202 JHS 202 ROBERT H GODDARD public Regular School No Middle 06 08 2021   pk_12_total 63.0 82.0 487.0   41.0     345.0     10.0   540.0 488.0     95       803     186   1028 63 82 487   41     345     10   540 488     95   803   186   1028
1497148 NY Queens   school 3600123 342700010000   NYC GEOG DIST #27 - QUEENS 360012302704 342700010210 JHS 210 ELIZABETH BLACKWELL public Regular School No Middle 06 08 2021   grade_7 12.0 25.0 341.0   14.0     161.0     5.0   304.0 254.0     95       439     *   558 12 25 341   14     161     5   304 254     95   439       558
1501637 NY Richmond   school 3600103 353100010000   NYC GEOG DIST #31 - SI 360010302046 353100010002 IS 2 GEORGE L EGBERT public Regular School No Middle 06 08 2021   pk_12_total 401.0 92.0 293.0   2.0     181.0     16.0   499.0 486.0     95       683     230   985 401 92 293   2     181     16   499 486     95   683   230   985
1504215 NY Rockland   school 3627810 500402060000   EAST RAMAPO 362781003769 500402060016 ELMWOOD ELEMENTARY SCHOOL public Regular School No Elementary KG 06 2021   grade_6 7.0 36.0 134.0         7.0     3.0   99.0 88.0     95       155     15   187 7 36 134         7     3   99 88     95   155   15   187
1511656 NY Suffolk   school 3627300 580413030000   SOUTH HUNTINGTON 362730003729 580413030011 WALT WHITMAN HIGH SCHOOL public Regular School No High 09 12 2021   grade_10 170.0 39.0 227.0   2.0     33.0     14.0   252.0 233.0     95       282     81   485 170 39 227   2     33     14   252 233     95   282   81   485
1512763 NY Suffolk   school 3605280 580512030000   BRENTWOOD 360528000253 580512030006 NORTH ELEMENTARY SCHOOL public Regular School No Elementary 01 05 2021   grade_4 1.0 8.0 189.0   1.0     1.0     0.0   106.0 94.0     95       182     40   200 1 8 189   1     1     0   106 94     95   182   40   200
1513329 NY Suffolk   school 3624690 580602040000   RIVERHEAD 362469003359 580602040008 RIVERHEAD SENIOR HIGH SCHOOL public Regular School No High 09 12 2021   grade_11 169.0 27.0 193.0   3.0     2.0     1.0   206.0 189.0     95       182     37   395 169 27 193   3     2     1   206 189     95   182   37   395
1438462 NY Bronx   school 3600086 320900010000   NYC GEOG DIST # 9 - BRONX 360008602961 320900011505 BRONX SCHOOL FOR LAW, GOV, JUSTICE public Regular School No High 06 12 2021   pk_12_total 6.0 154.0 575.0   5.0     8.0     4.0   319.0 433.0     94       655     189   752 6 154 575   5     8     4   319 433     94   655   189   752
1441483 NY Bronx   school 3600088 321100010000   NYC GEOG DIST #11 - BRONX 360008806338 321100010567 LINDEN TREE ELEMENTARY SCHOOL public Regular School No Elementary PK 05 2021   pk_12_total 9.0 49.0 223.0   4.0     79.0     2.0   201.0 165.0     94       316     81   366 9 49 223   4     79     2   201 165     94   316   81   366
1450622 NY Erie   school 3605850 140600010000   BUFFALO 360585000350 140600010059 PS 59 DR CHARLES DREW SCI MAGNET public Regular School No Elementary PK 08 2021   pk_12_total 70.0 423.0 60.0         100.0     38.0   350.0 341.0     94       608     197   691 70 423 60         100     38   350 341     94   608   197   691
1458917 NY Kings   school 3600092 331500010000   NYC GEOG DIST #15 - BROOKLYN 360009202602 331500010169 PS 169 SUNSET PARK public Regular School No Elementary KG 05 2021   grade_4 8.0 1.0 58.0   0.0     142.0     0.0   106.0 103.0     94       194     47   209 8 1 58   0     142     0   106 103     94   194   47   209
1462744 NY Kings   school 3600120 331900010000   NYC GEOG DIST #19 - BROOKLYN 360012006419 331900010662 LIBERTY AVENUE MIDDLE SCHOOL public Regular School No Middle 06 08 2021   pk_12_total 6.0 125.0 359.0   13.0     29.0     3.0   266.0 269.0     94       521     150   535 6 125 359   13     29     3   266 269     94   521   150   535
1481079 NY New York   school 3600077 310200010000   NYC GEOG DIST # 2 - MANHATTAN 360007700691 310200011420 HS-HEALTH PROFESSIONS & HUMAN SVCS public Regular School No High 09 12 2021   pk_12_total 147.0 256.0 956.0   17.0     399.0     26.0   494.0 1307.0     94       1330     290   1801 147 256 956   17     399     26   494 1307     94   1330   290   1801
1481181 NY New York   school 3600077 310200010000   NYC GEOG DIST # 2 - MANHATTAN 360007706191 310200011438 INTERNATIONAL HS AT UNION SQUARE public Regular School No High 09 12 2021   grade_11 13.0 20.0 51.0   0.0     17.0         60.0 41.0     94       95     *   101 13 20 51   0     17         60 41     94   95       101
1485069 NY New York   school 3600083 310600010000   NYC GEOG DIST # 6 - MANHATTAN 360008305647 310600010324 MS 324 PATRIA MIRABAL public Regular School No Middle 06 08 2021   pk_12_total 9.0 21.0 229.0         5.0         123.0 141.0     94       225     71   264 9 21 229         5         123 141     94   225   71   264
1493828 NY Putnam   school 3605310 480601060000   BREWSTER 360531000264 480601060003 BREWSTER HIGH SCHOOL public Regular School No High 09 12 2021   pk_12_total 539.0 33.0 361.0   1.0     38.0     23.0   534.0 461.0     94       369     154   995 539 33 361   1     38     23   534 461     94   369   154   995
1495329 NY Queens   school 3600122 342500010000   NYC GEOG DIST #25 - QUEENS 360012202592 342500010165 PS 165 EDITH K BERGTRAUM public Regular School No Elementary PK 05 2021   pk_12_total 78.0 84.0 162.0   8.0     377.0     13.0   364.0 358.0     94       485     176   722 78 84 162   8     377     13   364 358     94   485   176   722
1504098 NY Rockland   school 3627810 500402060000   EAST RAMAPO 362781003776 500402060005 MARGETTS ELEMENTARY SCHOOL public Regular School No Elementary KG 03 2021   grade_3 4.0 36.0 113.0   1.0     7.0     0.0   77.0 84.0     94       140     *   161 4 36 113   1     7     0   77 84     94   140       161
1512757 NY Suffolk   school 3605280 580512030000   BRENTWOOD 360528000253 580512030006 NORTH ELEMENTARY SCHOOL public Regular School No Elementary 01 05 2021   grade_1 2.0 18.0 146.0   0.0     5.0     3.0   82.0 92.0     94       163     10   174 2 18 146   0     5     3   82 92     94   163   10   174
1493999 NY Queens   school 3600098 342400010000   NYC GEOG DIST #24 - QUEENS 360009802103 342400010019 PS 19 MARINO JEANTET public Regular School No Elementary PK 05 2021   pk_12_total 8.0 1.0 1623.0         69.0     1.0   850.0 852.0     931       1495     383   1702 8 1 1623         69     1   850 852     931   1495   383   1702
1461129 NY Kings   school 3600095 331700010000   NYC GEOG DIST #17 - BROOKLYN 360009501937 331700011600 CLARA BARTON HIGH SCHOOL public Career and Technical School No High 09 12 2021   pk_12_total 19.0 1136.0 128.0   14.0     18.0     17.0   303.0 1029.0     93       1045     238   1332 19 1136 128   14     18     17   303 1029     93   1045   238   1332
1463580 NY Kings   school 3600151 332000010000   NYC GEOG DIST #20 - BROOKLYN 360015102587 332000010164 PS 164 CAESAR RODNEY public Regular School No Elementary PK 05 2021   pk_12_total 75.0 3.0 258.0   4.0     278.0     2.0   303.0 317.0     93       502     130   620 75 3 258   4     278     2   303 317     93   502   130   620
1463737 NY Kings   school 3600151 332000010000   NYC GEOG DIST #20 - BROOKLYN 360015102679 332000010200 PS 200 BENSON SCHOOL public Regular School No Elementary PK 05 2021   grade_1 106.0 1.0 27.0   1.0     77.0     3.0   117.0 98.0     93       172     *   215 106 1 27   1     77     3   117 98     93   172       215
1470876 NY Monroe   school 3624750 261600010000   ROCHESTER 362475006710 261600010107 MONROE LOWER SCHOOL public Regular School No Middle 07 08 2021   pk_12_total 12.0 111.0 140.0         1.0     2.0   129.0 137.0     93       258     70   266 12 111 140         1     2   129 137     93   258   70   266
1473188 NY Nassau   school 3611550 280209030000   FREEPORT 361155000911 280209030003 CAROLINE G ATKINSON SCHOOL public Regular School No Middle 05 06 2021   grade_6 42.0 101.0 346.0   2.0     1.0     8.0   252.0 248.0     93       329     75   500 42 101 346   2     1     8   252 248     93   329   75   500
1476443 NY Nassau   school 3619500 280410030000   MINEOLA 361950001780 280410030006 MINEOLA HIGH SCHOOL public Regular School No High 08 12 2021   pk_12_total 568.0 37.0 322.0         140.0     18.0   545.0 540.0     93       389     119   1085 568 37 322         140     18   545 540     93   389   119   1085

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]);