Data source: Big Local News · About: Big Local

90,098 rows where state = "NY" and year = 2020 sorted by white 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
1542867 NY Erie   school 3611670 141604060000   FRONTIER 361167000920 141604060007 FRONTIER MIDDLE SCHOOL public Regular School No Middle 06 08 2020   pk_12_total 999.0 20.0 65.0   3.0     12.0     43.0   600.0 542.0     7       371     222   1142 999 20 65   3     12     43   600 542     7   371   222   1142
1582140 NY Orange   school 3629970 442101060000   WARWICK VALLEY 362997004034 442101060002 WARWICK VALLEY HIGH SCHOOL public Regular School No High 09 12 2020   pk_12_total 999.0 63.0 202.0   2.0     34.0     26.0   691.0 635.0     11       260     176   1326 999 63 202   2     34     26   691 635     11   260   176   1326
1596390 NY Schenectady   school 3620880 530301060000   NISKAYUNA 362088002959 530301060007 NISKAYUNA HIGH SCHOOL public Regular School No High 09 12 2020   pk_12_total 996.0 67.0 68.0   1.0     200.0     46.0   721.0 657.0     10       226     158   1378 996 67 68   1     200     46   721 657     10   226   158   1378
1533782 NY Broome   school 3615900 31502060000   JOHNSON CITY 361590001375 31502060006 JOHNSON CITY SENIOR HIGH SCHOOL public Regular School No High 09 12 2020   grade_9 99.0 40.0 13.0         16.0     10.0   83.0 95.0     7       124     17   178 99 40 13         16     10   83 95     7   124   17   178
1533969 NY Broome   school 3602730 31701060000   WINDSOR 360273000048 31701060004 A F PALMER ES / WINDSOR CENTRAL MS public Regular School No Elementary PK 08 2020   grade_6 99.0 1.0 8.0         3.0     6.0   60.0 57.0     *       74     19   117 99 1 8         3     6   60 57         74   19   117
1535033 NY Chautauqua   school 3627660 60201060000   SOUTHWESTERN 362766003755 60201060006 SOUTHWESTERN MIDDLE SCHOOL public Regular School No Middle 06 08 2020   grade_6 99.0 0.0 6.0   1.0     1.0     4.0   57.0 54.0     *       45     15   111 99 0 6   1     1     4   57 54         45   15   111
1537615 NY Columbia   school 3615210 101401040000   KINDERHOOK 361521001277 101401040006 ICHABOD CRANE MIDDLE SCHOOL public Regular School No Middle 04 08 2020   grade_4 99.0 3.0 11.0         0.0     1.0   59.0 55.0     *       42     12   114 99 3 11         0     1   59 55         42   12   114
1539457 NY Dutchess   school 3629880 132101060000   WAPPINGERS 362988004016 132101060004 GAYHEAD SCHOOL public Regular School No Elementary KG 06 2020   grade_3 99.0 7.0 9.0         4.0     4.0   63.0 60.0     *       24     15   123 99 7 9         4     4   63 60         24   15   123
1542029 NY Erie   school 3609030 140707030000   DEPEW 360903000688 140707030005 CAYUGA HTS ELEMENTARY SCHOOL public Regular School No Elementary PK 05 2020   kindergarten_full_day 99.0 2.0 7.0   3.0     1.0     5.0   59.0 58.0     *       61     20   117 99 2 7   3     1     5   59 58         61   20   117
1542313 NY Erie   school 3610170 141201060000   EDEN 361017000791 141201060001 EDEN MIDDLE & HIGH SCHOOL public Regular School No High 06 12 2020   grade_9 99.0 2.0 1.0   0.0     1.0     1.0   51.0 53.0     *       26     15   104 99 2 1   0     1     1   51 53         26   15   104
1542720 NY Erie   school 3613350 141601060000   HAMBURG 361335001100 141601060004 UNION PLEASANT AVENUE ELEMENTARY SCH public Regular School No Elementary KG 05 2020   grade_1 99.0 1.0 5.0         0.0     1.0   48.0 58.0             29     30   106 99 1 5         0     1   48 58         29   30   106
1542724 NY Erie   school 3613350 141601060000   HAMBURG 361335001100 141601060004 UNION PLEASANT AVENUE ELEMENTARY SCH public Regular School No Elementary KG 05 2020   grade_2 99.0 0.0 2.0         0.0     3.0   54.0 50.0             24     21   104 99 0 2         0     3   54 50         24   21   104
1543372 NY Erie   school 3621900 142301060000   ORCHARD PARK 362190003109 142301060007 ELLICOTT ROAD ELEMENTARY SCHOOL public Regular School No Elementary KG 05 2020   grade_4 99.0 0.0 1.0         0.0     2.0   43.0 59.0             9     14   102 99 0 1         0     2   43 59         9   14   102
1543803 NY Erie   school 3630780 142801060000   WEST SENECA 363078004754 142801060018 WEST ELEMENTARY SCHOOL public Regular School No Elementary KG 05 2020   grade_1 99.0 3.0 10.0   0.0     2.0     2.0   53.0 63.0             38     22   116 99 3 10   0     2     2   53 63         38   22   116
1544354 NY Franklin   school 3618180 161501060000   MALONE 361818001633 161501060011 DAVIS ELEMENTARY SCHOOL public Regular School No Elementary PK 05 2020   grade_1 99.0 0.0 1.0   0.0     1.0     0.0   52.0 49.0             68     9   101 99 0 1   0     1     0   52 49         68   9   101
1544795 NY Fulton   school 3600005 171102040000   BROADALBIN-PERTH 360000500283 171102040002 LEARNING COMMUN-BROADALBIN-PERTH (TH public Regular School No Elementary PK 02 2020   grade_2 99.0 0.0 3.0         1.0     1.0   56.0 48.0     *       40     8   104 99 0 3         1     1   56 48         40   8   104
1545067 NY Genesee   school 3616950 181001060000   LE ROY 361695001506 181001060002 LE ROY JUNIOR-SENIOR HIGH SCHOOL public Regular School No High 07 12 2020   grade_8 99.0 2.0 3.0         0.0     0.0   57.0 47.0     *       46     13   104 99 2 3         0     0   57 47         46   13   104
1546316 NY Jefferson   school 3611910 220401040000   GENERAL BROWN 361191000958 220401040002 BROWNVILLE SCHOOL public Regular School No Elementary 03 06 2020   grade_3 99.0 1.0 1.0         3.0     0.0   47.0 57.0     *       46     22   104 99 1 1         3     0   47 57         46   22   104
1546351 NY Jefferson   school 3611910 220401040000   GENERAL BROWN 361191000960 220401040004 GENERAL BROWN JUNIOR-SENIOR HS public Regular School No High 07 12 2020   grade_11 99.0 1.0 2.0   1.0     0.0     0.0   53.0 50.0     *       28     16   103 99 1 2   1     0     0   53 50         28   16   103
1546401 NY Jefferson   school 3607650 220701040000   THOUSAND ISLANDS 360765000546 220701040002 CAPE VINCENT ELEMENTARY SCHOOL public Regular School No Elementary KG 05 2020   pk_12_total 99.0   8.0               1.0   49.0 59.0     *       58     10   108 99   8               1   49 59         58   10   108
1549228 NY Kings   school 3600092 331500010000   NYC GEOG DIST #15 - BROOKLYN 360009205498 331500010447 MATH & SCIENCE EXPLORATORY SCH (THE) public Regular School No Middle 06 08 2020   grade_8 99.0 20.0 36.0   0.0     23.0     4.0   97.0 85.0     *       56     47   182 99 20 36   0     23     4   97 85         56   47   182
1555571 NY Kings   school 3600153 332200010000   NYC GEOG DIST #22 - BROOKLYN 360015302769 332200010255 PS 255 BARBARA REING SCHOOL public Regular School No Elementary KG 05 2020   grade_5 99.0 6.0 18.0   0.0     24.0     0.0   84.0 63.0     24       110     22   147 99 6 18   0     24     0   84 63     24   110   22   147
1557699 NY Livingston   school 3617640 240801060000   LIVONIA 361764001577 240801060001 LIVONIA ELEMENTARY SCHOOL public Regular School No Elementary PK 05 2020   grade_5 99.0 1.0 3.0               2.0   51.0 54.0     *       42     13   105 99 1 3               2   51 54         42   13   105
1557712 NY Livingston   school 3617640 240801060000   LIVONIA 361764001578 240801060002 LIVONIA MIDDLE/HIGH SCHOOL public Regular School No High 06 12 2020   grade_10 99.0 1.0 5.0         1.0     2.0   58.0 50.0     *       38     18   108 99 1 5         1     2   58 50         38   18   108
1557948 NY Madison   school 3606780 250201060000   CAZENOVIA 360678000467 250201060001 CAZENOVIA MIDDLE SCHOOL public Regular School No Middle 05 07 2020   grade_7 99.0 1.0 2.0         2.0     0.0   52.0 52.0     *       23     10   104 99 1 2         2     0   52 52         23   10   104
1558110 NY Madison   school 3606390 250901060000   CANASTOTA 360639000420 250901060003 PETERBORO STREET ELEMENTARY SCHOOL public Regular School No Elementary PK 01 2020   grade_1 99.0 0.0 3.0   1.0           8.0   55.0 56.0     *       75     15   111 99 0 3   1           8   55 56         75   15   111
1559089 NY Monroe   school 3609690 260801060000   EAST IRONDEQUOIT 360969005576 260801060012 EAST IRONDEQUOIT MIDDLE SCHOOL public Regular School No Middle 06 08 2020   grade_8 99.0 71.0 62.0   0.0     4.0     14.0   119.0 131.0     6       146     28   250 99 71 62   0     4     14   119 131     6   146   28   250
1559484 NY Monroe   school 3614460 261101060000   HILTON 361446001197 261101060001 VILLAGE ELEMENTARY SCHOOL public Regular School No Elementary PK 06 2020   grade_4 99.0 2.0 12.0   0.0     0.0     3.0   56.0 60.0             49     12   116 99 2 12   0     0     3   56 60         49   12   116
1561470 NY Monroe   school 3605580 261801060000   BROCKPORT 360558000287 261801060002 GINTHER ELEMENTARY SCHOOL public Regular School No Elementary PK 01 2020   pre_kindergarten_half_day 99.0 1.0 17.0   2.0     0.0     6.0   60.0 65.0     0       48     23   125 99 1 17   2     0     6   60 65     0   48   23   125
1565446 NY Nassau   school 3626520 280252070000   SEWANHAKA 362652003629 280252070005 NEW HYDE PARK MEMORIAL HIGH SCHOOL public Regular School No High 07 12 2020   grade_11 99.0 6.0 41.0   0.0     150.0     5.0   151.0 150.0     9       77     25   301 99 6 41   0     150     5   151 150     9   77   25   301
1566499 NY Nassau   school 3614280 280409030000   HERRICKS 361428001179 280409030007 HERRICKS MIDDLE SCHOOL public Regular School No Middle 06 08 2020   grade_8 99.0 2.0 19.0         209.0     5.0   170.0 164.0     *       34     38   334 99 2 19         209     5   170 164         34   38   334
1570052 NY New York   school 3600077 310200010000   NYC GEOG DIST # 2 - MANHATTAN 360007704405 310200010114 EAST SIDE MIDDLE SCHOOL public Regular School No Middle 06 08 2020   grade_8 99.0 4.0 17.0   0.0     20.0     11.0   59.0 92.0     *       21     23   151 99 4 17   0     20     11   59 92         21   23   151
1570651 NY New York   school 3600077 310200010000   NYC GEOG DIST # 2 - MANHATTAN 360007705084 310200010416 ELEANOR ROOSEVELT HIGH SCHOOL public Regular School No High 09 12 2020   grade_10 99.0 4.0 7.0   2.0     20.0     3.0   56.0 79.0             29     21   135 99 4 7   2     20     3   56 79         29   21   135
1576813 NY Oneida   school 3607770 411101060000   CLINTON 360777000555 411101060001 CLINTON ELEMENTARY SCHOOL public Regular School No Elementary KG 05 2020   grade_5 99.0 1.0 2.0         1.0     3.0   60.0 46.0     *       32     9   106 99 1 2         1     3   60 46         32   9   106
1577440 NY Oneida   school 3614580 412201060000   HOLLAND PATENT 361458001210 412201060003 HOLLAND PATENT ELEMENTARY SCHOOL public Regular School No Elementary 03 05 2020   grade_5 99.0                       55.0 44.0     *       47     12   99 99                       55 44         47   12   99
1579110 NY Onondaga   school 3618480 421101060000   MARCELLUS 361848001663 421101060001 K C HEFFERNAN ELEMENTARY SCHOOL public Regular School No Elementary KG 03 2020   grade_3 99.0 1.0 5.0         0.0     0.0   47.0 58.0     *       19     *   105 99 1 5         0     0   47 58         19       105
1579529 NY Onondaga   school 3626940 421601060000   SKANEATELES 362694003669 421601060004 STATE STREET INTERMEDIATE SCHOOL public Regular School No Elementary 03 05 2020   grade_4 99.0   2.0         0.0     3.0   53.0 51.0             17     11   104 99   2         0     3   53 51         17   11   104
1579552 NY Onondaga   school 3626940 421601060000   SKANEATELES 362694003667 421601060005 SKANEATELES MIDDLE SCHOOL public Regular School No Middle 06 08 2020   grade_8 99.0   1.0         2.0         55.0 47.0     *       8     13   102 99   1         2         55 47         8   13   102
1581524 NY Orange   school 3619650 441201060000   MONROE WOODBURY 361965001797 441201060001 PINE TREE ELEMENTARY SCHOOL public Regular School No Elementary 02 05 2020   grade_4 99.0 20.0 62.0   0.0     19.0     9.0   106.0 103.0     8       57     44   209 99 20 62   0     19     9   106 103     8   57   44   209
1583363 NY Otsego   school 3621780 471400010000   ONEONTA 362178003095 471400010002 ONEONTA SENIOR HIGH SCHOOL public Regular School No High 09 12 2020   grade_11 99.0 11.0 11.0         8.0     1.0   67.0 63.0     *       23     21   130 99 11 11         8     1   67 63         23   21   130
1584819 NY Queens   school 3600098 342400010000   NYC GEOG DIST #24 - QUEENS 360009805828 342400011264 ACADEMY-FINANCE & ENTERPRISE public Regular School No High 09 12 2020   pk_12_total 99.0 22.0 363.0   9.0     161.0     23.0   336.0 341.0     33       561     85   677 99 22 363   9     161     23   336 341     33   561   85   677
1586320 NY Queens   school 3600099 342600010000   NYC GEOG DIST #26 - QUEENS 360009902608 342600010172 IRWIN ALTMAN MIDDLE SCHOOL 172 public Regular School No Middle 06 08 2020   pk_12_total 99.0 87.0 153.0   17.0     637.0     13.0   510.0 496.0     66       598     174   1006 99 87 153   17     637     13   510 496     66   598   174   1006
1586632 NY Queens   school 3600099 342600010000   NYC GEOG DIST #26 - QUEENS 360009901917 342600011495 BAYSIDE HIGH SCHOOL public Regular School No High 09 12 2020   grade_12 99.0 54.0 86.0   19.0     243.0     2.0   262.0 241.0     *       *     *   503 99 54 86   19     243     2   262 241                 503
1588462 NY Queens   school 3600100 342800010000   NYC GEOG DIST #28 - QUEENS 360010002653 342800010190 JHS 190 RUSSELL SAGE public Regular School No Middle 06 08 2020   grade_7 99.0 25.0 109.0   5.0     127.0     14.0   197.0 182.0     *       178     58   379 99 25 109   5     127     14   197 182         178   58   379
1593916 NY Rockland   school 3621480 500304030000   NYACK 362148003049 500304030007 NYACK MIDDLE SCHOOL public Regular School No Middle 06 08 2020   grade_8 99.0 45.0 52.0   1.0     12.0     6.0   99.0 116.0     6       82     39   215 99 45 52   1     12     6   99 116     6   82   39   215
1595894 NY Saratoga   school 3625770 521800010000   SARATOGA SPRINGS 362577003538 521800010006 DOROTHY NOLAN ELEMENTARY SCHOOL public Regular School No Elementary KG 05 2020   kindergarten_full_day 99.0 2.0 5.0         3.0     10.0   63.0 56.0             29     18   119 99 2 5         3     10   63 56         29   18   119
1597441 NY Steuben   school 3604050 570302060000   BATH 360405000163 570302060003 HAVERLING SENIOR HIGH SCHOOL public Regular School No High 09 12 2020   grade_10 99.0 6.0 2.0         1.0         53.0 55.0             54     14   108 99 6 2         1         53 55         54   14   108
1598018 NY Suffolk   school 3603720 580101030000   BABYLON 360372000122 580101030001 BABYLON MEMORIAL GRADE SCHOOL public Regular School No Elementary 03 06 2020   grade_6 99.0 3.0 13.0         9.0     1.0   69.0 56.0     *       23     *   125 99 3 13         9     1   69 56         23       125
1599944 NY Suffolk   school 3619200 580211060000   MIDDLE COUNTRY 361920004343 580211060018 UNITY DRIVE KINDERGARTEN-PRE K public Regular School No Elementary PK KG 2020   pre_kindergarten_full_day 99.0 4.0 35.0         15.0     6.0   81.0 78.0     0       44     *   159 99 4 35         15     6   81 78     0   44       159
1600620 NY Suffolk   school 3600008 580235060000   SOUTH COUNTRY 360000800195 580235060005 FRANK P LONG INTERMEDIATE SCH public Regular School No Elementary 04 05 2020   grade_5 99.0 48.0 133.0         6.0     18.0   149.0 155.0     37       213     44   304 99 48 133         6     18   149 155     37   213   44   304
1601007 NY Suffolk   school 3615090 580403030000   HUNTINGTON 361509001266 580403030002 SOUTHDOWN SCHOOL public Regular School No Elementary KG 03 2020   pk_12_total 99.0 17.0 157.0   1.0     1.0     8.0   142.0 141.0     107       178     40   283 99 17 157   1     1     8   142 141     107   178   40   283
1602100 NY Suffolk   school 3609720 580503030000   EAST ISLIP 360972000751 580503030003 JOHN F KENNEDY ELEMENTARY SCHOOL public Regular School No Elementary 03 05 2020   grade_3 99.0 0.0 21.0         2.0     7.0   67.0 62.0     8       26     *   129 99 0 21         2     7   67 62     8   26       129
1604192 NY Suffolk   school 3600125 580912060000   ESTPRT-S MANOR CSD 360012504330 580912060004 DAYTON AVENUE SCHOOL public Regular School No Elementary 03 06 2020   grade_5 99.0 2.0 11.0         0.0     0.0   48.0 64.0     *       26     23   112 99 2 11         0     0   48 64         26   23   112
1604812 NY Tioga   school 3630270 600101060000   WAVERLY 363027004068 600101060004 LINCOLN STREET ELEMENTARY SCHOOL public Regular School No Elementary PK 01 2020   grade_1 99.0 0.0 0.0               2.0   46.0 55.0             61     16   101 99 0 0               2   46 55         61   16   101
1605926 NY Ulster   school 3614400 620803040000   HIGHLAND 361440001191 620803040001 HIGHLAND ELEMENTARY SCHOOL public Regular School No Elementary KG 05 2020   kindergarten_full_day 99.0 11.0 15.0   0.0     3.0     5.0   84.0 49.0     *       47     19   133 99 11 15   0     3     5   84 49         47   19   133
1606284 NY Ulster   school 3621840 621201060000   ONTEORA 362184004849 621201060006 ONTEORA MIDDLE SCHOOL public Regular School No Middle 07 08 2020   grade_7 99.0 1.0 16.0   0.0     3.0     10.0   69.0 60.0     *       60     23   129 99 1 16   0     3     10   69 60         60   23   129
1607444 NY Wayne   school 3620640 650101060000   NEWARK 362064002894 650101060005 NEWARK MIDDLE SCHOOL public Regular School No Middle 06 08 2020   grade_8 99.0 11.0 30.0   0.0           1.0   74.0 67.0     *       *     20   141 99 11 30   0           1   74 67             20   141
1608791 NY Westchester   school 3615450 660402020000   IRVINGTON 361545001314 660402020003 IRVINGTON MIDDLE SCHOOL public Regular School No Middle 06 08 2020   grade_6 99.0 6.0 16.0         13.0     6.0   78.0 62.0     *       *     19   140 99 6 16         13     6   78 62             19   140
1608793 NY Westchester   school 3615450 660402020000   IRVINGTON 361545001314 660402020003 IRVINGTON MIDDLE SCHOOL public Regular School No Middle 06 08 2020   grade_8 99.0 7.0 19.0         13.0     10.0   77.0 71.0     *       16     21   148 99 7 19         13     10   77 71         16   21   148
1608883 NY Westchester   school 3613950 660404030000   HASTINGS ON HUDSON 361395001132 660404030001 HILLSIDE ELEMENTARY SCHOOL public Regular School No Elementary KG 04 2020   grade_3 99.0 2.0 25.0         5.0     7.0   80.0 58.0     *       *     27   138 99 2 25         5     7   80 58             27   138
1611243 NY Westchester   school 3625290 661901030000   RYE NECK 362529003495 661901030004 RYE NECK MIDDLE SCHOOL public Regular School No Middle 06 08 2020   grade_7 99.0 7.0 35.0         11.0     10.0   74.0 88.0     5       27     20   162 99 7 35         11     10   74 88     5   27   20   162
1613022 NY Yates   school 3622740 680601060000   PENN YAN 362274003200 680601060001 PENN YAN ACADEMY public Regular School No High 09 12 2020   grade_11 99.0   2.0   0.0     1.0     4.0   50.0 56.0     *       47     9   106 99   2   0     1     4   50 56         47   9   106
1533059 NY Broome   school 3607260 30101060000   CHENANGO FORKS 360726000514 30101060004 CHENANGO FORKS MIDDLE SCHOOL public Regular School No Middle 06 08 2020   grade_8 98.0 1.0 5.0               2.0   56.0 50.0             41     16   106 98 1 5               2   56 50         41   16   106
1533344 NY Broome   school 3628380 30601060000   SUSQUEHANNA VALLEY 362838003824 30601060005 RICHARD T STANK MIDDLE SCHOOL public Regular School No Middle 06 08 2020   grade_8 98.0 3.0 3.0   0.0     2.0     5.0   55.0 56.0     *       53     17   111 98 3 3   0     2     5   55 56         53   17   111
1535008 NY Chautauqua   school 3627660 60201060000   SOUTHWESTERN 362766003756 60201060003 SOUTHWESTERN SENIOR HIGH SCHOOL public Regular School No High 09 12 2020   grade_11 98.0 1.0 5.0   1.0     1.0     3.0   61.0 48.0     *       36     13   109 98 1 5   1     1     3   61 48         36   13   109
1535787 NY Chautauqua   school 3611520 62201060000   FREDONIA 361152000907 62201060003 FREDONIA HIGH SCHOOL public Regular School No High 09 12 2020   grade_11 98.0 1.0 9.0         2.0     2.0   64.0 48.0     *       *     6   112 98 1 9         2     2   64 48             6   112
1536781 NY Chenango   school 3626700 82001040000   SHERBURNE EARLVL 362670003644 82001040003 SHERBURNE-EARLVILLE MIDDLE SCHOOL public Regular School No Middle 06 08 2020   grade_6 98.0 1.0           0.0     1.0   55.0 45.0             100     29   100 98 1           0     1   55 45         100   29   100
1537334 NY Clinton   school 3600009 91402060000   SARANAC 360000904670 91402060007 SARANAC MIDDLE SCHOOL public Regular School No Middle 06 08 2020   grade_8 98.0   1.0         0.0     3.0   49.0 53.0             *     *   102 98   1         0     3   49 53                 102
1537571 NY Columbia   school 3615210 101401040000   KINDERHOOK 361521001278 101401040004 ICHABOD CRANE ELEMENTARY SCHOOL public Regular School No Elementary KG 03 2020   grade_1 98.0 0.0 19.0   0.0     1.0     6.0   78.0 46.0     10       54     13   124 98 0 19   0     1     6   78 46     10   54   13   124
1542838 NY Erie   school 3611670 141604060000   FRONTIER 361167000926 141604060006 PINEHURST ELEMENTARY SCHOOL public Regular School No Elementary KG 05 2020   grade_2 98.0 0.0 3.0   0.0     0.0     3.0   50.0 54.0             14     11   104 98 0 3   0     0     3   50 54         14   11   104
1546318 NY Jefferson   school 3611910 220401040000   GENERAL BROWN 361191000958 220401040002 BROWNVILLE SCHOOL public Regular School No Elementary 03 06 2020   grade_5 98.0 2.0 1.0         1.0     2.0   49.0 55.0     *       32     19   104 98 2 1         1     2   49 55         32   19   104
1548767 NY Kings   school 3600092 331500010000   NYC GEOG DIST #15 - BROOKLYN 360009202139 331500010029 PS 29 JOHN M HARRIGAN public Regular School No Elementary PK 05 2020   grade_3 98.0 5.0 15.0   0.0     4.0     7.0   68.0 61.0     5       20     19   129 98 5 15   0     4     7   68 61     5   20   19   129
1554286 NY Kings   school 3600151 332000010000   NYC GEOG DIST #20 - BROOKLYN 360015105955 332000011609 URBAN ASSEMBLY SCH-CRIMINAL JUSTICE public Regular School No High 06 12 2020   pk_12_total 98.0 65.0 107.0   4.0     290.0     9.0     573.0     74       506     86   573 98 65 107   4     290     9     573     74   506   86   573
1557355 NY Lewis   school 3617820 230901040000   LOWVILLE 361782001602 230901040001 LOWVILLE ELEMENTARY SCHOOL public Regular School No Elementary PK 05 2020   grade_3 98.0 0.0 1.0               4.0   52.0 51.0     *       58     10   103 98 0 1               4   52 51         58   10   103
1557397 NY Lewis   school 3617820 230901040000   LOWVILLE 361782004350 230901040003 LOWVILLE MIDDLE SCHOOL public Regular School No Middle 06 08 2020   grade_7 98.0 2.0 1.0   0.0     0.0     4.0   53.0 52.0             42     12   105 98 2 1   0     0     4   53 52         42   12   105
1557704 NY Livingston   school 3617640 240801060000   LIVONIA 361764001577 240801060001 LIVONIA ELEMENTARY SCHOOL public Regular School No Elementary PK 05 2020   kindergarten_full_day 98.0 0.0 2.0               3.0   67.0 36.0     *       41     12   103 98 0 2               3   67 36         41   12   103
1557798 NY Livingston   school 3608790 241001060000   DANSVILLE 360879000667 241001060003 DANSVILLE HIGH SCHOOL public Regular School No High 07 12 2020   grade_9 98.0 3.0 1.0         0.0     1.0   52.0 51.0     *       59     19   103 98 3 1         0     1   52 51         59   19   103
1557982 NY Madison   school 3606780 250201060000   CAZENOVIA 360678000465 250201060006 BURTON STREET ELEMENTARY SCHOOL public Regular School No Elementary KG 04 2020   grade_3 98.0 0.0 1.0         1.0     2.0   59.0 43.0     *       30     7   102 98 0 1         1     2   59 43         30   7   102
1559560 NY Monroe   school 3614460 261101060000   HILTON 361446004592 261101060006 NORTHWOOD ELEMENTARY SCHOOL public Regular School No Elementary KG 06 2020   grade_4 98.0 4.0 10.0         0.0     4.0   60.0 56.0     0       26     8   116 98 4 10         0     4   60 56     0   26   8   116
1565038 NY Nassau   school 3615510 280226030000   ISLAND TREES 361551001321 280226030004 J FRED SPARKE SCHOOL public Regular School No Elementary KG 01 2020   kindergarten_full_day 98.0 4.0 47.0   1.0     25.0     2.0   83.0 94.0     19       33     15   177 98 4 47   1     25     2   83 94     19   33   15   177
1565408 NY Nassau   school 3626520 280252070000   SEWANHAKA 362652003627 280252070003 FLORAL PARK MEMORIAL HIGH SCHOOL public Regular School No High 07 12 2020   grade_11 98.0 28.0 35.0   0.0     54.0     1.0   122.0 94.0     0       53     23   216 98 28 35   0     54     1   122 94     0   53   23   216
1576713 NY Oneida   school 3605040 410401060000   ADIRONDACK 360504000241 410401060005 ADIRONDACK HIGH SCHOOL public Regular School No High 09 12 2020   grade_11 98.0             2.0     2.0   50.0 52.0             50     *   102 98             2     2   50 52         50       102
1578155 NY Onondaga   school 3621210 420303060000   NORTH SYRACUSE 362121002996 420303060003 CICERO ELEMENTARY SCHOOL public Regular School No Elementary KG 04 2020   grade_1 98.0 2.0 4.0   0.0     7.0     6.0   56.0 61.0     5       28     19   117 98 2 4   0     7     6   56 61     5   28   19   117
1578160 NY Onondaga   school 3621210 420303060000   NORTH SYRACUSE 362121002996 420303060003 CICERO ELEMENTARY SCHOOL public Regular School No Elementary KG 04 2020   grade_3 98.0 0.0 1.0   0.0     10.0     6.0   60.0 55.0     7       39     20   115 98 0 1   0     10     6   60 55     7   39   20   115
1578674 NY Onondaga   school 3607320 420701060000   WESTHILL 360732000521 420701060002 CHERRY ROAD ELEMENTARY SCHOOL public Regular School No Elementary 02 04 2020   grade_4 98.0 8.0 10.0   1.0     6.0     6.0   58.0 71.0     0       35     13   129 98 8 10   1     6     6   58 71     0   35   13   129
1578713 NY Onondaga   school 3607320 420701060000   WESTHILL 360732000522 420701060004 ONONDAGA HILL MIDDLE SCHOOL public Regular School No Middle 05 08 2020   grade_5 98.0 7.0 2.0   1.0     3.0     10.0   54.0 67.0     *       33     *   121 98 7 2   1     3     10   54 67         33       121
1580460 NY Ontario   school 3612300 430901060000   GORHAM-MIDDLESEX 361230000992 430901060002 GORHAM ELEMENTARY SCHOOL public Regular School No Elementary 03 05 2020   grade_4 98.0   0.0         0.0     0.0   52.0 46.0     *       *     16   98 98   0         0     0   52 46             16   98
1580651 NY Ontario   school 3622890 431301060000   PHELPS-CLIFTON SPR 362289003213 431301060003 MIDLAKES INTERMEDIATE SCHOOL public Regular School No Elementary 03 06 2020   grade_5 98.0 1.0 10.0         1.0     4.0   57.0 57.0     *       51     18   114 98 1 10         1     4   57 57         51   18   114
1581505 NY Orange   school 3619560 441101040000   MINISINK VALLEY 361956004822 441101040005 MINISINK VALLEY INTERMEDIATE SCHOOL public Regular School No Elementary 03 05 2020   grade_4 98.0 5.0 45.0         8.0         79.0 77.0     12       56     17   156 98 5 45         8         79 77     12   56   17   156
1581575 NY Orange   school 3619650 441201060000   MONROE WOODBURY 361965004198 441201060005 SMITH CLOVE ELEMENTARY SCHOOL public Regular School No Elementary KG 01 2020   grade_1 98.0 30.0 112.0         26.0     6.0   122.0 150.0     34       127     57   272 98 30 112         26     6   122 150     34   127   57   272
1582666 NY Oswego   school 3613590 460701040000   HANNIBAL 361359001111 460701040001 KENNEY MIDDLE SCHOOL public Regular School No Middle 05 08 2020   grade_6 98.0 0.0 1.0   0.0     0.0     0.0   52.0 47.0     *       68     17   99 98 0 1   0     0     0   52 47         68   17   99
1582668 NY Oswego   school 3613590 460701040000   HANNIBAL 361359001111 460701040001 KENNEY MIDDLE SCHOOL public Regular School No Middle 05 08 2020   grade_8 98.0 2.0 6.0   0.0     2.0     2.0   55.0 55.0     *       74     13   110 98 2 6   0     2     2   55 55         74   13   110
1582701 NY Oswego   school 3613590 460701040000   HANNIBAL 361359001112 460701040003 FAIRLEY SCHOOL public Regular School No Elementary PK 04 2020   grade_3 98.0   2.0               0.0   54.0 46.0     *       76     13   100 98   2               0   54 46         76   13   100
1583372 NY Otsego   school 3621780 471400010000   ONEONTA 362178003095 471400010002 ONEONTA SENIOR HIGH SCHOOL public Regular School No High 09 12 2020   grade_9 98.0 4.0 13.0         3.0     2.0   61.0 59.0     *       36     22   120 98 4 13         3     2   61 59         36   22   120
1585275 NY Queens   school 3600122 342500010000   NYC GEOG DIST #25 - QUEENS 360012202148 342500010032 PS 32 STATE STREET public Regular School No Elementary PK 05 2020   pk_12_total 98.0 7.0 208.0   6.0     690.0     23.0   516.0 516.0     139       684     140   1032 98 7 208   6     690     23   516 516     139   684   140   1032
1586583 NY Queens   school 3600099 342600010000   NYC GEOG DIST #26 - QUEENS 360009901919 342600011415 BENJAMIN N CARDOZO HIGH SCHOOL public Regular School No High 09 12 2020   grade_9 98.0 240.0 236.0   12.0     365.0     8.0   465.0 494.0     47       676     184   959 98 240 236   12     365     8   465 494     47   676   184   959
1592508 NY Richmond   school 3600103 353100010000   NYC GEOG DIST #31 - SI 360010302057 353100010051 IS 51 EDWIN MARKHAM public Regular School No Middle 06 08 2020   grade_6 98.0 95.0 222.0   4.0     24.0     10.0   232.0 221.0     47       366     138   453 98 95 222   4     24     10   232 221     47   366   138   453
1593567 NY Rockland   school 3620190 500108030000   NANUET 362019001854 500108030004 NANUET SENIOR HIGH SCHOOL public Regular School No High 09 12 2020   grade_12 98.0 12.0 37.0   0.0     36.0     4.0   96.0 91.0     6       47     15   187 98 12 37   0     36     4   96 91     6   47   15   187
1597315 NY Seneca   school 3600014 561006060000   WATERLOO 360001401431 561006060003 WATERLOO MIDDLE SCHOOL public Regular School No Middle 06 08 2020   grade_6 98.0 9.0 2.0         2.0     2.0   64.0 49.0     *       71     21   113 98 9 2         2     2   64 49         71   21   113
1597750 NY Steuben   school 3614820 571800010000   HORNELL 361482001232 571800010001 HORNELL INTERMEDIATE SCHOOL public Regular School No Middle 04 06 2020   grade_4 98.0 4.0 4.0         2.0     9.0   57.0 60.0     *       *     23   117 98 4 4         2     9   57 60             23   117

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