Data source: Big Local News · About: Big Local

90,098 rows where state = "NY" and year = 2020 sorted by multiracial descending

View and edit SQL

year

  • 2020 · 90,098
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
1585959 NY Queens   school 3600122 342500010000   NYC GEOG DIST #25 - QUEENS 360012204485 342500011525 TOWNSEND HARRIS HIGH SCHOOL public Regular School No High 09 12 2020   pk_12_total 233.0 62.0 139.0   13.0     675.0     99.0   424.0 797.0     *       610     92   1221 233 62 139   13     675     99   424 797         610   92   1221
1576288 NY Niagara   school 3620820 400800010000   NIAGARA FALLS 362082005951 400800010040 GASKILL PREPARATORY SCHOOL public Regular School No Middle 07 08 2020   pk_12_total 147.0 214.0 51.0   12.0     4.0     98.0   251.0 275.0     *       448     116   526 147 214 51   12     4     98   251 275         448   116   526
1524342 NY Albany   school 3630210 11200010000   WATERVLIET 363021004060 11200010002 WATERVLIET ELEMENTARY SCHOOL public Regular School No Elementary PK 06 2020   pk_12_total 338.0 111.0 136.0         60.0     97.0   395.0 347.0     57       547     110   742 338 111 136         60     97   395 347     57   547   110   742
1576193 NY Niagara   school 3620820 400800010000   NIAGARA FALLS 362082002931 400800010020 HYDE PARK SCHOOL public Regular School No Elementary PK 06 2020   pk_12_total 145.0 194.0 39.0   19.0           96.0   248.0 245.0             418     101   493 145 194 39   19           96   248 245         418   101   493
1591621 NY Rensselaer   school 3628950 491700010000   TROY 362895003915 491700010014 PS 14 public Regular School No Elementary PK 05 2020   pk_12_total 163.0 149.0 110.0         14.0     96.0   263.0 269.0     37       444     81   532 163 149 110         14     96   263 269     37   444   81   532
1600038 NY Suffolk   school 3619230 580212060000   LONGWOOD 361923001753 580212060005 LONGWOOD HIGH SCHOOL public Regular School No High 09 12 2020   pk_12_total 1401.0 528.0 777.0   12.0     103.0     95.0   1478.0 1438.0     116       1470     470   2916 1401 528 777   12     103     95   1478 1438     116   1470   470   2916
1533652 NY Broome   school 3610710 31501060000   UNION-ENDICOTT 361071000851 31501060009 JENNIE F SNAPP MIDDLE SCHOOL public Regular School No Middle 06 08 2020   pk_12_total 525.0 70.0 79.0   1.0     15.0     94.0   373.0 411.0     *       428     114   784 525 70 79   1     15     94   373 411         428   114   784
1569885 NY New York   school 3600077 310200010000   NYC GEOG DIST # 2 - MANHATTAN 360007702184 310200010041 PS 41 GREENWICH VILLAGE public Regular School No Elementary PK 05 2020   pk_12_total 451.0 8.0 63.0         50.0     94.0   343.0 323.0     11       49     119   666 451 8 63         50     94   343 323     11   49   119   666
1577713 NY Oneida   school 3629370 412300010000   UTICA 362937003963 412300010024 THOMAS R PROCTOR HIGH SCHOOL public Regular School No High 09 12 2020   pk_12_total 900.0 662.0 503.0   8.0     525.0     93.0   1364.0 1327.0     392       2143     489   2691 900 662 503   8     525     93   1364 1327     392   2143   489   2691
1576326 NY Niagara   school 3620820 400800010000   NIAGARA FALLS 362082005954 400800010042 CATARACT ELEMENTARY SCHOOL public Regular School No Elementary PK 06 2020   pk_12_total 197.0 157.0 43.0   3.0     6.0     92.0   255.0 243.0     5       381     158   498 197 157 43   3     6     92   255 243     5   381   158   498
1534621 NY Cayuga   school 3603480 50100010000   AUBURN 360348000102 50100010002 CASEY PARK ELEMENTARY SCHOOL public Regular School No Elementary KG 06 2020   pk_12_total 342.0 33.0 28.0         2.0     91.0   251.0 245.0             402     89   496 342 33 28         2     91   251 245         402   89   496
1548871 NY Kings   school 3600092 331500010000   NYC GEOG DIST #15 - BROOKLYN 360009202251 331500010058 PS 58 CARROLL (THE) public Regular School No Elementary PK 05 2020   pk_12_total 736.0 22.0 109.0   1.0     43.0     91.0   519.0 483.0     48       118     149   1002 736 22 109   1     43     91   519 483     48   118   149   1002
1579347 NY Onondaga   school 3617520 421501060000   LIVERPOOL 361752001565 421501060011 LIVERPOOL HIGH SCHOOL public Regular School No High 09 12 2020   pk_12_total 1610.0 237.0 104.0   13.0     119.0     91.0   1073.0 1101.0     20       859     387   2174 1610 237 104   13     119     91   1073 1101     20   859   387   2174
1605852 NY Ulster   school 3616290 620600010000   KINGSTON 361629001434 620600010020 J WATSON BAILEY MIDDLE SCHOOL public Regular School No Middle 05 08 2020   pk_12_total 607.0 103.0 277.0   1.0     22.0     90.0   524.0 576.0     68       568     246   1100 607 103 277   1     22     90   524 576     68   568   246   1100
1523067 NY Albany   school 3602460 10100010000   ALBANY 360246000022 10100010018 DELAWARE COMMUNITY SCHOOL public Regular School No Elementary PK 05 2020   kindergarten_full_day 6.0 12.0 28.0         3.0     9.0   30.0 28.0     17       *     0   58 6 12 28         3     9   30 28     17       0   58
1523293 NY Albany   school 3602460 10100010000   ALBANY 360246006624 10100010050 EDMUND J O'NEAL MS OF EXCELLENCE public Regular School No Middle 06 08 2020   grade_8 17.0 112.0 24.0   0.0     5.0     9.0   74.0 93.0     19       145     *   167 17 112 24   0     5     9   74 93     19   145       167
1523801 NY Albany   school 3627210 10601060000   SOUTH COLONIE 362721004750 10601060003 ROESSLEVILLE SCHOOL public Regular School No Elementary PK 04 2020   grade_3 39.0 4.0 8.0         5.0     9.0   27.0 38.0     *       33     7   65 39 4 8         5     9   27 38         33   7   65
1523834 NY Albany   school 3627210 10601060000   SOUTH COLONIE 362721003711 10601060006 SHAKER ROAD ELEMENTARY SCHOOL public Regular School No Elementary KG 04 2020   grade_1 38.0 3.0 9.0   1.0     14.0     9.0   39.0 35.0     16       35     *   74 38 3 9   1     14     9   39 35     16   35       74
1523992 NY Albany   school 3621000 10623060000   NORTH COLONIE CSD 362100002980 10623060003 BOGHT HILLS SCHOOL public Regular School No Elementary KG 06 2020   grade_4 41.0 4.0 2.0   0.0     27.0     9.0   36.0 47.0     *       16     *   83 41 4 2   0     27     9   36 47         16       83
1524062 NY Albany   school 3621000 10623060000   NORTH COLONIE CSD 362100002987 10623060008 SOUTHGATE SCHOOL public Regular School No Elementary KG 06 2020   grade_1 48.0 8.0 4.0   0.0     18.0     9.0   48.0 39.0     12       23     29   87 48 8 4   0     18     9   48 39     12   23   29   87
1524067 NY Albany   school 3621000 10623060000   NORTH COLONIE CSD 362100002987 10623060008 SOUTHGATE SCHOOL public Regular School No Elementary KG 06 2020   grade_3 29.0 6.0 1.0   0.0     18.0     9.0   31.0 32.0     9       18     6   63 29 6 1   0     18     9   31 32     9   18   6   63
1524206 NY Albany   school 3613080 10802060000   GUILDERLAND 361308001070 10802060005 GUILDERLAND HIGH SCHOOL public Regular School No High 09 12 2020   grade_9 276.0 21.0 17.0   0.0     47.0     9.0   173.0 197.0     11       81     48   370 276 21 17   0     47     9   173 197     11   81   48   370
1524357 NY Albany   school 3630210 11200010000   WATERVLIET 363021004061 11200010010 WATERVLIET JUNIOR-SENIOR HIGH SCHOOL public Regular School No High 07 12 2020   grade_8 46.0 15.0 14.0         12.0     9.0   48.0 48.0     *       73     18   96 46 15 14         12     9   48 48         73   18   96
1527135 NY Bronx   school 3601096 320800861044   SUCCESS ACAD CHARTER SCH-BR 3 360109606390 320800861044 SUCCESS ACAD CHARTER SCH-BRONX 3 charter Regular School Yes Elementary KG 07 2020   pk_12_total 11.0 565.0 475.0   9.0     15.0     9.0   535.0 549.0     44       849     203   1084 11 565 475   9     15     9   535 549     44   849   203   1084
1528104 NY Bronx   school 3600086 320900010000   NYC GEOG DIST # 9 - BRONX 360008606345 320900010568 YOUNG WOMEN'S LDSHP SCHOOL-BRONX public Regular School No High 06 12 2020   pk_12_total 7.0 165.0 349.0   4.0     17.0     9.0     551.0     28       473     105   551 7 165 349   4     17     9     551     28   473   105   551
1528907 NY Bronx   school 3600087 321000010000   NYC GEOG DIST #10 - BRONX 360008702121 321000010024 PS 24 SPUYTEN DUYVIL public Regular School No Elementary KG 05 2020   grade_1 51.0 18.0 57.0   1.0     15.0     9.0   70.0 81.0     11       48     22   151 51 18 57   1     15     9   70 81     11   48   22   151
1528911 NY Bronx   school 3600087 321000010000   NYC GEOG DIST #10 - BRONX 360008702121 321000010024 PS 24 SPUYTEN DUYVIL public Regular School No Elementary KG 05 2020   grade_2 55.0 13.0 62.0   2.0     12.0     9.0   89.0 64.0     12       42     27   153 55 13 62   2     12     9   89 64     12   42   27   153
1530362 NY Bronx   school 3600087 321000010000   NYC GEOG DIST #10 - BRONX 360008705190 321000011696 HS AMER STUDIES AT LEHMAN COLL public Regular School No High 09 12 2020   grade_9 32.0 7.0 19.0   1.0     14.0     9.0   29.0 53.0             26     *   82 32 7 19   1     14     9   29 53         26       82
1530707 NY Bronx   school 3600088 321100010000   NYC GEOG DIST #11 - BRONX 360008802306 321100010076 PS 76 BENNINGTON SCHOOL (THE) public Regular School No Elementary KG 05 2020   pk_12_total 47.0 343.0 378.0   2.0     51.0     9.0   417.0 413.0     116       675     170   830 47 343 378   2     51     9   417 413     116   675   170   830
1531106 NY Bronx   school 3600088 321100010000   NYC GEOG DIST #11 - BRONX 360008802628 321100010180 MS 180 DR DANIEL HALE WILLIAMS public Regular School No Middle 06 08 2020   pk_12_total 28.0 704.0 254.0   12.0     35.0     9.0   500.0 542.0     25       807     231   1042 28 704 254   12     35     9   500 542     25   807   231   1042
1531600 NY Bronx   school 3600088 321100010000   NYC GEOG DIST #11 - BRONX 360008805687 321100011299 ASTOR COLLEGIATE ACADEMY public Regular School No High 09 12 2020   pk_12_total 65.0 128.0 234.0   7.0     37.0     9.0   269.0 211.0     37       390     104   480 65 128 234   7     37     9   269 211     37   390   104   480
1531790 NY Bronx   school 3600089 321100860855   BRONX CHARTER SCH BETTER LEA 360008905554 321100860855 BRONX CHARTER SCH BETTER LEARNING charter Regular School Yes Elementary PK 05 2020   pk_12_total 11.0 456.0 63.0   7.0     7.0     9.0   249.0 304.0     7       445     70   553 11 456 63   7     7     9   249 304     7   445   70   553
1533075 NY Broome   school 3604870 30200010000   BINGHAMTON 360487000224 30200010002 CALVIN COOLIDGE SCHOOL public Regular School No Elementary PK 05 2020   grade_5 17.0 10.0 8.0   0.0     0.0     9.0   26.0 18.0             33     11   44 17 10 8   0     0     9   26 18         33   11   44
1533150 NY Broome   school 3604870 30200010000   BINGHAMTON 360487000232 30200010012 THEODORE ROOSEVELT SCHOOL public Regular School No Elementary PK 05 2020   grade_4 17.0 13.0 13.0         0.0     9.0   26.0 26.0     5       46     *   52 17 13 13         0     9   26 26     5   46       52
1533167 NY Broome   school 3604870 30200010000   BINGHAMTON 360487000235 30200010014 WOODROW WILSON SCHOOL public Regular School No Elementary KG 05 2020   grade_2 15.0 10.0 9.0         5.0     9.0   22.0 26.0     7       *     7   48 15 10 9         5     9   22 26     7       7   48
1533243 NY Broome   school 3604870 30200010000   BINGHAMTON 360487000229 30200010022 HORACE MANN SCHOOL public Regular School No Elementary PK 05 2020   grade_2 12.0 10.0 12.0               9.0   22.0 21.0             33     10   43 12 10 12               9   22 21         33   10   43
1533291 NY Broome   school 3613710 30501040000   HARPURSVILLE 361371001119 30501040003 HARPURSVILLE JUNIOR-SENIOR HIGH SCH public Regular School No High 07 12 2020   pk_12_total 302.0 5.0 3.0   2.0     1.0     9.0   184.0 138.0             217     52   322 302 5 3   2     1     9   184 138         217   52   322
1533397 NY Broome   school 3607290 30701060000   CHENANGO VALLEY 360729000518 30701060003 CHENANGO BRIDGE ELEMENTARY SCHOOL public Regular School No Elementary 03 05 2020   grade_4 109.0 3.0 3.0   0.0     2.0     9.0   68.0 58.0     *       62     18   126 109 3 3   0     2     9   68 58         62   18   126
1533398 NY Broome   school 3607290 30701060000   CHENANGO VALLEY 360729000518 30701060003 CHENANGO BRIDGE ELEMENTARY SCHOOL public Regular School No Elementary 03 05 2020   grade_5 110.0 1.0 4.0   0.0     1.0     9.0   68.0 57.0     *       57     22   125 110 1 4   0     1     9   68 57         57   22   125
1533410 NY Broome   school 3607290 30701060000   CHENANGO VALLEY 360729000040 30701060004 PORT DICKINSON ELEMENTARY SCHOOL public Regular School No Elementary PK 02 2020   grade_1 114.0 1.0 3.0         2.0     9.0   65.0 64.0     *       67     9   129 114 1 3         2     9   65 64         67   9   129
1533448 NY Broome   school 3618150 31101060000   MAINE ENDWELL 361815001627 31101060003 HOMER BRINK SCHOOL public Regular School No Elementary PK 05 2020   grade_1 96.0 7.0 4.0   0.0     0.0     9.0   59.0 57.0     *       44     *   116 96 7 4   0     0     9   59 57         44       116
1533538 NY Broome   school 3631380 31401060000   WHITNEY POINT 363138004201 31401060002 TIOUGHNIOGA RIVERSIDE ACADEMY public Regular School No Middle 04 08 2020   pk_12_total 514.0 4.0 6.0   1.0     2.0     9.0   251.0 285.0     *       351     94   536 514 4 6   1     2     9   251 285         351   94   536
1533600 NY Broome   school 3610710 31501060000   UNION-ENDICOTT 361071004314 31501060002 GEORGE F JOHNSON ELEMENTARY SCHOOL public Regular School No Elementary KG 05 2020   grade_1 64.0 2.0 11.0   1.0     0.0     9.0   41.0 46.0             9     *   87 64 2 11   1     0     9   41 46         9       87
1533605 NY Broome   school 3610710 31501060000   UNION-ENDICOTT 361071004314 31501060002 GEORGE F JOHNSON ELEMENTARY SCHOOL public Regular School No Elementary KG 05 2020   grade_3 73.0 8.0 10.0   1.0     2.0     9.0   55.0 48.0             21     15   103 73 8 10   1     2     9   55 48         21   15   103
1533606 NY Broome   school 3610710 31501060000   UNION-ENDICOTT 361071004314 31501060002 GEORGE F JOHNSON ELEMENTARY SCHOOL public Regular School No Elementary KG 05 2020   grade_4 71.0 5.0 8.0   0.0     0.0     9.0   53.0 40.0             43     *   93 71 5 8   0     0     9   53 40         43       93
1533633 NY Broome   school 3610710 31501060000   UNION-ENDICOTT 361071006576 31501060007 LINNAEUS W WEST SCHOOL public Regular School No High 08 12 2020   pk_12_total 55.0 7.0 3.0               9.0   41.0 33.0             40     12   74 55 7 3               9   41 33         40   12   74
1533676 NY Broome   school 3610710 31501060000   UNION-ENDICOTT 361071000853 31501060013 THOMAS J WATSON SR ELEM SCHOOL public Regular School No Elementary KG 05 2020   grade_1 34.0 6.0 4.0         1.0     9.0   37.0 17.0             16     6   54 34 6 4         1     9   37 17         16   6   54
1534089 NY Cattaraugus   school 3610530 40901040000   ELLICOTTVILLE 361053004318 40901040002 ELLICOTTVILLE MIDDLE/HIGH SCHOOL public Regular School No High 06 12 2020   pk_12_total 302.0   7.0   8.0     3.0     9.0   166.0 163.0             110     40   329 302   7   8     3     9   166 163         110   40   329
1534239 NY Cattaraugus   school 3621720 42400010000   OLEAN 362172003077 42400010004 EAST VIEW ELEMENTARY SCHOOL public Regular School No Elementary PK 03 2020   kindergarten_full_day 70.0 2.0 2.0   1.0     6.0     9.0   47.0 43.0     *       53     13   90 70 2 2   1     6     9   47 43         53   13   90
1534249 NY Cattaraugus   school 3621720 42400010000   OLEAN 362172003082 42400010013 OLEAN SENIOR HIGH SCHOOL public Regular School No High 07 12 2020   grade_12 96.0 4.0 7.0   0.0     6.0     9.0   69.0 53.0             *     23   122 96 4 7   0     6     9   69 53             23   122
1534256 NY Cattaraugus   school 3621720 42400010000   OLEAN 362172003082 42400010013 OLEAN SENIOR HIGH SCHOOL public Regular School No High 07 12 2020   grade_8 116.0 6.0 4.0   3.0     4.0     9.0   74.0 68.0             84     33   142 116 6 4   3     4     9   74 68         84   33   142
1534564 NY Cattaraugus   school 3608970 43501060000   YORKSHRE-PIONEER 360897000685 43501060004 PIONEER MIDDLE SCHOOL public Regular School No Middle 05 08 2020   pk_12_total 694.0 4.0 15.0         6.0     9.0   354.0 374.0             404     174   728 694 4 15         6     9   354 374         404   174   728
1534615 NY Cayuga   school 3603480 50100010000   AUBURN 360348000102 50100010002 CASEY PARK ELEMENTARY SCHOOL public Regular School No Elementary KG 06 2020   grade_6 58.0 2.0 1.0         1.0     9.0   43.0 28.0             54     14   71 58 2 1         1     9   43 28         54   14   71
1534690 NY Cayuga   school 3603480 50100010000   AUBURN 360348000109 50100010008 WILLIAM H SEWARD ELEMENTARY SCHOOL public Regular School No Elementary KG 06 2020   grade_5 64.0 2.0 5.0   0.0     0.0     9.0   43.0 37.0     *       42     7   80 64 2 5   0     0     9   43 37         42   7   80
1535153 NY Chautauqua   school 3600018 60503040000   CHAUTAUQUA LAKE 360001801936 60503040001 CHAUTAUQUA LAKE SECONDARY SCHOOL public Regular School No High 07 12 2020   pk_12_total 372.0 2.0 7.0   2.0           9.0   182.0 210.0             190     53   392 372 2 7   2           9   182 210         190   53   392
1535191 NY Chautauqua   school 3623070 60601040000   PINE VALLEY 362307003233 60601040002 PINE VALLEY ELEMENTARY SCHOOL public Regular School No Elementary PK 06 2020   pk_12_total 256.0 1.0 15.0   2.0           9.0   146.0 137.0             200     44   283 256 1 15   2           9   146 137         200   44   283
1535339 NY Chautauqua   school 3609420 60800010000   DUNKIRK 360942000718 60800010010 DUNKIRK MIDDLE SCHOOL public Regular School No Middle 06 08 2020   grade_8 59.0 4.0 72.0   1.0     0.0     9.0   77.0 68.0     *       105     14   145 59 4 72   1     0     9   77 68         105   14   145
1535485 NY Chautauqua   school 3626880 61501040000   SILVER CREEK 362688003665 61501040003 SILVER CREEK ELEMENTARY SCHOOL public Regular School No Elementary PK 05 2020   grade_2 46.0 1.0 2.0   9.0     1.0     9.0   33.0 35.0     0       43     12   68 46 1 2   9     1     9   33 35     0   43   12   68
1535486 NY Chautauqua   school 3626880 61501040000   SILVER CREEK 362688003665 61501040003 SILVER CREEK ELEMENTARY SCHOOL public Regular School No Elementary PK 05 2020   grade_3 52.0 0.0 11.0   9.0     0.0     9.0   38.0 43.0     *       47     15   81 52 0 11   9     0     9   38 43         47   15   81
1535657 NY Chautauqua   school 3615630 61700010000   JAMESTOWN 361563001355 61700010009 SAMUEL G LOVE ELEMENTARY SCHOOL public Regular School No Elementary PK 04 2020   grade_3 26.0 4.0 26.0   0.0           9.0   35.0 30.0     *       62     14   65 26 4 26   0           9   35 30         62   14   65
1535680 NY Chautauqua   school 3615630 61700010000   JAMESTOWN 361563001351 61700010010 THOMAS JEFFERSON MIDDLE SCHOOL public Regular School No Middle 05 08 2020   grade_7 66.0 4.0 22.0         0.0     9.0   40.0 61.0     *       75     13   101 66 4 22         0     9   40 61         75   13   101
1535681 NY Chautauqua   school 3615630 61700010000   JAMESTOWN 361563001351 61700010010 THOMAS JEFFERSON MIDDLE SCHOOL public Regular School No Middle 05 08 2020   grade_8 63.0 2.0 11.0         0.0     9.0   46.0 39.0     *       52     14   85 63 2 11         0     9   46 39         52   14   85
1535975 NY Chemung   school 3610560 70600010000   ELMIRA 361056000816 70600010006 DIVEN SCHOOL public Regular School No Elementary PK 02 2020   grade_1 73.0 16.0 10.0               9.0   54.0 54.0     *       78     21   108 73 16 10               9   54 54         78   21   108
1536173 NY Chemung   school 3610560 70600010000   ELMIRA 361056000810 70600010022 BROADWAY ELEMENTARY SCHOOL public Regular School No Elementary 03 06 2020   grade_6 88.0 6.0 2.0               9.0   57.0 48.0             52     17   105 88 6 2               9   57 48         52   17   105
1536190 NY Chemung   school 3601128 70600861078   FINN ACADEMY:AN ELMIRA CHART 360112806541 70600861078 FINN ACADEMY:AN ELMIRA CHARTER SCHOO charter Regular School Yes Elementary KG 07 2020   grade_4 53.0 1.0 5.0         0.0     9.0   38.0 30.0     *       37     5   68 53 1 5         0     9   38 30         37   5   68
1536193 NY Chemung   school 3601128 70600861078   FINN ACADEMY:AN ELMIRA CHART 360112806541 70600861078 FINN ACADEMY:AN ELMIRA CHARTER SCHOO charter Regular School Yes Elementary KG 07 2020   grade_7 13.0 0.0 3.0         0.0     9.0   13.0 12.0     *       17     7   25 13 0 3         0     9   13 12         17   7   25
1536325 NY Chemung   school 3614850 70901060000   HORSEHEADS 361485001244 70901060011 HORSEHEADS INTERMEDIATE SCHOOL public Regular School No Middle 05 06 2020   grade_6 246.0 3.0 9.0         6.0     9.0   132.0 141.0     *       *     *   273 246 3 9         6     9   132 141                 273
1537452 NY Columbia   school 3612030 100902040000   GERMANTOWN 361203006337 100902040004 GERMANTOWN JUNIOR-SENIOR HIGH SCHOOL public Regular School No High 07 12 2020   pk_12_total 219.0 1.0 23.0         4.0     9.0   146.0 110.0     *       105     45   256 219 1 23         4     9   146 110         105   45   256
1537575 NY Columbia   school 3615210 101401040000   KINDERHOOK 361521001278 101401040004 ICHABOD CRANE ELEMENTARY SCHOOL public Regular School No Elementary KG 03 2020   grade_2 114.0 1.0 26.0   1.0     2.0     9.0   71.0 82.0     21       66     17   153 114 1 26   1     2     9   71 82     21   66   17   153
1537749 NY Cortland   school 3608460 110200010000   CORTLAND 360846000650 110200010009 RANDALL MIDDLE SCHOOL public Regular School No Middle 05 06 2020   grade_5 144.0 7.0 9.0         1.0     9.0   86.0 84.0             *     *   170 144 7 9         1     9   86 84                 170
1537766 NY Cortland   school 3608460 110200010000   CORTLAND 360846000647 110200010010 FE SMITH INTERMEDIATE SCHOOL public Regular School No Elementary 03 04 2020   grade_3 142.0 5.0 8.0         1.0     9.0   79.0 86.0     *       107     23   165 142 5 8         1     9   79 86         107   23   165
1537782 NY Cortland   school 3608460 110200010000   CORTLAND 360846000646 110200010011 CORTLAND HIGH SCHOOL public Regular School No High 09 12 2020   grade_11 136.0 7.0 4.0         1.0     9.0   71.0 86.0     *       62     11   157 136 7 4         1     9   71 86         62   11   157
1537809 NY Cortland   school 3608460 110200010000   CORTLAND 360846006612 110200010012 CORTLAND JUNIOR HIGH SCHOOL public Regular School No Middle 07 08 2020   grade_8 143.0 6.0 10.0         0.0     9.0   83.0 85.0     *       *     *   168 143 6 10         0     9   83 85                 168
1537927 NY Cortland   school 3614640 110701060000   HOMER 361464003477 110701060006 HOMER JUNIOR HIGH SCHOOL public Regular School No Middle 06 08 2020   pk_12_total 441.0 2.0 20.0         2.0     9.0   231.0 243.0     5       220     62   474 441 2 20         2     9   231 243     5   220   62   474
1538079 NY Delaware   school 3607050 120401040000   CHARLOTTE VALLEY 360705000497 120401040001 CHARLOTTE VALLEY SCHOOL public Regular School No Other PK 12 2020   pk_12_total 382.0 1.0 19.0         1.0     9.0   219.0 193.0             240     78   412 382 1 19         1     9   219 193         240   78   412
1538447 NY Dutchess   school 3604140 130200010000   BEACON 360414000177 130200010005 BEACON HIGH SCHOOL public Regular School No High 09 12 2020   grade_11 104.0 35.0 73.0         3.0     9.0   108.0 116.0     6       107     42   224 104 35 73         3     9   108 116     6   107   42   224
1538448 NY Dutchess   school 3604140 130200010000   BEACON 360414000177 130200010005 BEACON HIGH SCHOOL public Regular School No High 09 12 2020   grade_12 101.0 46.0 64.0         2.0     9.0   100.0 122.0     *       104     37   222 101 46 64         2     9   100 122         104   37   222
1538636 NY Dutchess   school 3615180 130801060000   HYDE PARK 361518001269 130801060007 FRANKLIN D ROOSEVELT SENIOR HS public Regular School No High 09 12 2020   grade_10 184.0 42.0 47.0         8.0     9.0   161.0 129.0     9       141     46   290 184 42 47         8     9   161 129     9   141   46   290
1538791 NY Dutchess   school 3623040 131301040000   PINE PLAINS 362304003230 131301040001 SEYMOUR SMITH INTERMEDIATE LRN CTR public Regular School No Elementary 02 05 2020   grade_2 45.0 0.0 8.0         0.0     9.0   35.0 27.0     *       29     7   62 45 0 8         0     9   35 27         29   7   62
1538848 NY Dutchess   school 3623760 131500010000   POUGHKEEPSIE 362376003302 131500010001 WARRING MAGNET ACAD OF SCI & TECH public Regular School No Other 01 10 2020   grade_2 5.0 33.0 28.0   0.0     0.0     9.0   46.0 29.0     9       58     12   75 5 33 28   0     0     9   46 29     9   58   12   75
1538887 NY Dutchess   school 3623760 131500010000   POUGHKEEPSIE 362376003304 131500010006 G W KRIEGER SCHOOL public Regular School No Elementary KG 06 2020   grade_3 8.0 39.0 40.0   0.0     0.0     9.0   55.0 41.0     16       74     26   96 8 39 40   0     0     9   55 41     16   74   26   96
1538941 NY Dutchess   school 3623760 131500010000   POUGHKEEPSIE 362376003307 131500010010 POUGHKEEPSIE HIGH SCHOOL public Regular School No High 09 12 2020   grade_11 13.0 146.0 96.0   0.0     1.0     9.0   126.0 139.0     30       189     41   265 13 146 96   0     1     9   126 139     30   189   41   265
1539175 NY Dutchess   school 3603270 131601060000   ARLINGTON 360327005597 131601060015 UNION VALE MIDDLE SCHOOL public Regular School No Middle 06 08 2020   grade_6 197.0 17.0 46.0         5.0     9.0   138.0 136.0     *       *     44   274 197 17 46         5     9   138 136             44   274
1539390 NY Dutchess   school 3624480 131801040000   RHINEBECK 362448003343 131801040003 BULKELEY MIDDLE SCHOOL public Regular School No Middle 06 08 2020   pk_12_total 201.0 4.0 20.0         8.0     9.0   118.0 124.0     *       55     29   242 201 4 20         8     9   118 124         55   29   242
1539586 NY Dutchess   school 3629880 132101060000   WAPPINGERS 362988004022 132101060011 ROY C KETCHAM SENIOR HIGH SCH public Regular School No High 09 12 2020   grade_10 243.0 39.0 83.0   0.0     18.0     9.0   212.0 180.0     7       134     52   392 243 39 83   0     18     9   212 180     7   134   52   392
1539596 NY Dutchess   school 3629880 132101060000   WAPPINGERS 362988004022 132101060011 ROY C KETCHAM SENIOR HIGH SCH public Regular School No High 09 12 2020   grade_9 249.0 26.0 95.0   0.0     18.0     9.0   203.0 194.0     6       138     72   397 249 26 95   0     18     9   203 194     6   138   72   397
1539643 NY Dutchess   school 3629880 132101060000   WAPPINGERS 362988004018 132101060015 JOHN JAY SENIOR HIGH SCHOOL public Regular School No High 09 12 2020   grade_10 332.0 25.0 77.0   0.0     27.0     9.0   249.0 221.0     14       83     57   470 332 25 77   0     27     9   249 221     14   83   57   470
1539770 NY Erie   school 3602550 140101060000   ALDEN 360255000041 140101060003 ALDEN PRIMARY AT TOWNLINE public Regular School No Elementary KG 02 2020   pk_12_total 361.0 3.0 4.0   1.0     2.0     9.0   179.0 201.0     *       124     37   380 361 3 4   1     2     9   179 201         124   37   380
1539916 NY Erie   school 3631470 140203060000   WILLIAMSVILLE 363147004216 140203060001 MILL MIDDLE SCHOOL public Regular School No Middle 05 08 2020   grade_6 172.0 7.0 10.0         14.0     9.0   99.0 113.0     *       44     25   212 172 7 10         14     9   99 113         44   25   212
1539952 NY Erie   school 3631470 140203060000   WILLIAMSVILLE 363147004214 140203060003 MAPLE EAST ELEMENTARY SCHOOL public Regular School No Elementary KG 04 2020   grade_4 80.0 1.0 2.0         22.0     9.0   57.0 57.0     *       18     12   114 80 1 2         22     9   57 57         18   12   114
1539990 NY Erie   school 3631470 140203060000   WILLIAMSVILLE 363147004212 140203060005 HEIM ELEMENTARY SCHOOL public Regular School No Elementary KG 04 2020   grade_4 90.0 4.0 10.0   1.0     17.0     9.0   62.0 69.0     9       28     16   131 90 4 10   1     17     9   62 69     9   28   16   131
1540049 NY Erie   school 3631470 140203060000   WILLIAMSVILLE 363147004213 140203060009 HEIM MIDDLE SCHOOL public Regular School No Middle 05 08 2020   grade_6 120.0 2.0 9.0   0.0     14.0     9.0   80.0 74.0     9       26     18   154 120 2 9   0     14     9   80 74     9   26   18   154
1540063 NY Erie   school 3631470 140203060000   WILLIAMSVILLE 363147004218 140203060010 WILLIAMSVILLE NORTH HIGH SCHOOL public Regular School No High 09 12 2020   grade_12 269.0 17.0 6.0   1.0     29.0     9.0   171.0 160.0     *       50     39   331 269 17 6   1     29     9   171 160         50   39   331
1540085 NY Erie   school 3631470 140203060000   WILLIAMSVILLE 363147004209 140203060011 COUNTRY PARKWAY ELEMENTARY SCHOOL public Regular School No Elementary KG 04 2020   grade_4 61.0 2.0 8.0   0.0     37.0     9.0   54.0 63.0     9       16     8   117 61 2 8   0     37     9   54 63     9   16   8   117
1540143 NY Erie   school 3631470 140203060000   WILLIAMSVILLE 363147000457 140203060015 TRANSIT MIDDLE SCHOOL public Regular School No Middle 05 08 2020   grade_5 141.0 9.0 7.0   0.0     47.0     9.0   117.0 96.0     8       30     25   213 141 9 7   0     47     9   117 96     8   30   25   213
1540203 NY Erie   school 3628500 140207060000   SWEET HOME 362850003831 140207060005 SWEET HOME MIDDLE SCHOOL public Regular School No Middle 06 08 2020   grade_8 166.0 60.0 19.0         19.0     9.0   149.0 124.0     9       142     34   273 166 60 19         19     9   149 124     9   142   34   273
1540215 NY Erie   school 3628500 140207060000   SWEET HOME 362850003832 140207060006 SWEET HOME SENIOR HIGH SCHOOL public Regular School No High 09 12 2020   grade_12 181.0 60.0 20.0   2.0     14.0     9.0   152.0 134.0     10       141     22   286 181 60 20   2     14     9   152 134     10   141   22   286
1540444 NY Erie   school 3605850 140600010000   BUFFALO 360585000329 140600010027 PS 27 HILLERY PARK ACADEMY public Regular School No Elementary PK 08 2020   grade_2 18.0 17.0 11.0   0.0     2.0     9.0   25.0 32.0     *       45     11   57 18 17 11   0     2     9   25 32         45   11   57
1540542 NY Erie   school 3605850 140600010000   BUFFALO 360585000339 140600010043 LOVEJOY DISCOVERY SCHOOL #43 public Regular School No Elementary PK 08 2020   grade_5 23.0 22.0 13.0         2.0     9.0   30.0 39.0     *       62     24   69 23 22 13         2     9   30 39         62   24   69
1540654 NY Erie   school 3605850 140600010000   BUFFALO 360585000352 140600010061 PS 61 ARTHUR O EVE SCHOOL OF DISTINC public Regular School No Elementary PK 04 2020   grade_3 2.0 47.0 7.0         2.0     9.0   37.0 30.0     *       61     29   67 2 47 7         2     9   37 30         61   29   67

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