enrollments

Data source: Big Local News · About: Big Local

33,145 rows where grade = "grade_7" and state = "NY" sorted by white descending

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

grade ✖

  • grade_7 · 33,145 ✖
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
800156 800156 NY Oneida   school 3629370 412300010000   UTICA 362937003962 412300010023 SENATOR JAMES H DONOVAN MIDDLE SCH public Regular School No 2 07 08 2015   grade_7 99.0 123.0 62.0   0.0     51.0     17.0   185.0 167.0             314     84   352 99 123 62   0     51     17   185 167         314   84   352
805970 805970 NY Otsego   school 3621780 471400010000   ONEONTA 362178003094 471400010007 ONEONTA MIDDLE SCHOOL public Regular School No 2 06 08 2015   grade_7 99.0 13.0 9.0         5.0     1.0   59.0 68.0             50     *   127 99 13 9         5     1   59 68         50       127
810815 810815 NY Queens   school 3600100 342800010000   NYC GEOG DIST #28 - QUEENS 360010002653 342800010190 JHS 190 RUSSELL SAGE public Regular School No 2 06 09 2015   grade_7 99.0 30.0 115.0   2.0     109.0     4.0   209.0 150.0             204     63   359 99 30 115   2     109     4   209 150         204   63   359
952836 952836 NY Cattaraugus   school 3600015 40302060000   ALLEGANY-LIMESTONE 360001500053 40302060001 ALLEGANY-LIMESTONE MIDDLE-HIGH public Regular School No Other 06 12 2017   grade_7 99.0 2.0 2.0   1.0     0.0     1.0   55.0 50.0             41     5   105 99 2 2   1     0     1   55 50         41   5   105
976700 976700 NY Madison   school 3606780 250201060000   CAZENOVIA 360678000467 250201060001 CAZENOVIA MIDDLE SCHOOL public Regular School No Middle 05 07 2017   grade_7 99.0 1.0 2.0   1.0     3.0     0.0   43.0 63.0             20     16   106 99 1 2   1     3     0   43 63         20   16   106
984186 984186 NY Nassau   school 3626520 280252070000   SEWANHAKA 362652003629 280252070005 NEW HYDE PARK MEMORIAL HIGH SCHOOL public Regular School No High 07 12 2017   grade_7 99.0 8.0 36.0         119.0     4.0   128.0 138.0     *       55     34   266 99 8 36         119     4   128 138         55   34   266
984566 984566 NY Nassau   school 3610050 280402030000   EAST WILLISTON 361005000782 280402030002 WILLETS ROAD SCHOOL public Regular School No Middle 05 07 2017   grade_7 99.0 1.0 14.0         36.0     1.0   86.0 65.0     *       12     18   151 99 1 14         36     1   86 65         12   18   151
1085665 1085665 NY Oneida   school 3607770 411101060000   CLINTON 360777000556 411101060004 CLINTON MIDDLE SCHOOL public Regular School No 2.0 06 08 2016   grade_7 99.0 1.0 0.0         3.0     1.0   45.0 59.0             31     7   104 99 1 0         3     1   45 59         31   7   104
1103164 1103164 NY Saint Lawrence   school 3606470 510201060000   CANTON 360647004763 510201060004 J M MCKENNEY MIDDLE SCHOOL public Regular School No 2.0 05 08 2016   grade_7 99.0 2.0 0.0   0.0     0.0     1.0   48.0 54.0             46     23   102 99 2 0   0     0     1   48 54         46   23   102
1103240 1103240 NY Saint Lawrence   school 3612360 511101060000   GOUVERNEUR 361236001002 511101060005 GOUVERNEUR JUNIOR-SENIOR HIGH SCHOOL public Regular School No 4.0 06 12 2016   grade_7 99.0 2.0 2.0   1.0     0.0     1.0   51.0 54.0             66     21   105 99 2 2   1     0     1   51 54         66   21   105
1114260 1114260 NY Tompkins   school 3615570 610600010000   ITHACA 361557001335 610600010015 DEWITT MIDDLE SCHOOL public Regular School No 2.0 06 08 2016   grade_7 99.0 16.0 8.0         29.0     7.0   95.0 64.0             61     18   159 99 16 8         29     7   95 64         61   18   159
1468990 1468990 NY Monroe   school 3609690 260801060000   EAST IRONDEQUOIT 360969005576 260801060012 EAST IRONDEQUOIT MIDDLE SCHOOL public Regular School No Middle 06 08 2021   grade_7 99.0 43.0 50.0   0.0     3.0     21.0   104.0 112.0     *       128     16   216 99 43 50   0     3     21   104 112         128   16   216
1505337 1505337 NY Saratoga   school 3608370 520401040000   CORINTH 360837002624 520401040008 CORINTH MIDDLE SCHOOL public Regular School No Middle 06 08 2021   grade_7 99.0   1.0         0.0     1.0   50.0 51.0     *       52     11   101 99   1         0     1   50 51         52   11   101
1510980 1510980 NY Suffolk   school 3615090 580403030000   HUNTINGTON 361509001260 580403030014 J TAYLOR FINLEY MIDDLE SCHOOL public Regular School No Middle 07 08 2021   grade_7 99.0 24.0 215.0         6.0     14.0   186.0 172.0     78       235     47   358 99 24 215         6     14   186 172     78   235   47   358
1557948 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
1588462 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
1606284 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
1611243 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
2085142 2085142 NY Monroe   school 3609690 260801060000   EAST IRONDEQUOIT 360969005576 260801060012 EAST IRONDEQUOIT MIDDLE SCHOOL public Regular School No Middle 06 08 2018   grade_7 99.0 45.0 54.0         3.0     12.0   112.0 101.0     14       139     23   213 99 45 54         3     12   112 101     14   139   23   213
2102071 2102071 NY Niagara   school 3620760 400601060000   NEWFANE 362076002921 400601060008 NEWFANE MIDDLE SCHOOL public Regular School No Middle 05 08 2018   grade_7 99.0 0.0 2.0         0.0     2.0   51.0 52.0             47     14   103 99 0 2         0     2   51 52         47   14   103
2109595 2109595 NY Otsego   school 3621780 471400010000   ONEONTA 362178003094 471400010007 ONEONTA MIDDLE SCHOOL public Regular School No Middle 06 08 2018   grade_7 99.0 4.0 14.0         4.0     1.0   64.0 58.0     *       50     24   122 99 4 14         4     1   64 58         50   24   122
2151490 2151490 NY Chautauqua   school 3615630 61700010000   JAMESTOWN 361563004390 61700010006 PERSELL MIDDLE SCHOOL public Regular School No Middle 05 08 2019   grade_7 99.0 3.0 23.0   2.0     1.0     16.0   76.0 68.0     *       98     22   144 99 3 23   2     1     16   76 68         98   22   144
2157760 2157760 NY Erie   school 3618600 140702030000   MARYVALE 361860001677 140702030005 MARYVALE MIDDLE SCHOOL public Regular School No Middle 06 08 2019   grade_7 99.0 20.0 9.0   1.0     8.0     10.0   68.0 79.0     14       87     24   147 99 20 9   1     8     10   68 79     14   87   24   147
2165075 2165075 NY Kings   school 3600092 331500010000   NYC GEOG DIST #15 - BROOKLYN 360009205498 331500010447 MATH & SCIENCE EXPLORATORY SCH (THE) public Regular School No Middle 06 08 2019   grade_7 99.0 19.0 35.0   0.0     25.0     4.0   94.0 88.0     *       51     47   182 99 19 35   0     25     4   94 88         51   47   182
2174822 2174822 NY Monroe   school 3609690 260801060000   EAST IRONDEQUOIT 360969005576 260801060012 EAST IRONDEQUOIT MIDDLE SCHOOL public Regular School No Middle 06 08 2019   grade_7 99.0 70.0 54.0         5.0     12.0   118.0 122.0     10       146     28   240 99 70 54         5     12   118 122     10   146   28   240
2177577 2177577 NY Montgomery   school 3602970 270100010000   AMSTERDAM 360297000071 270100010009 WILBUR H LYNCH LITERACY ACADEMY public Regular School No Middle 06 08 2019   grade_7 99.0 12.0 127.0   0.0     4.0     14.0   144.0 112.0     25       193     55   256 99 12 127   0     4     14   144 112     25   193   55   256
2198059 2198059 NY Orleans   school 3602520 450101060000   ALBION 360252000034 450101060005 CARL I BERGERSON MIDDLE SCHOOL public Regular School No Middle 06 08 2019   grade_7 99.0 13.0 23.0   2.0     1.0         72.0 66.0     6       91     18   138 99 13 23   2     1         72 66     6   91   18   138
2207806 2207806 NY Richmond   school 3600103 353100010000   NYC GEOG DIST #31 - SI 360010302130 353100010027 IS 27 ANNING S PRALL public Regular School No Middle 06 08 2019   grade_7 99.0 68.0 146.0   2.0     33.0     3.0   184.0 167.0     14       252     *   351 99 68 146   2     33     3   184 167     14   252       351
2209535 2209535 NY Rockland   school 3621480 500304030000   NYACK 362148003049 500304030007 NYACK MIDDLE SCHOOL public Regular School No Middle 06 08 2019   grade_7 99.0 41.0 50.0         14.0     6.0   94.0 116.0     10       74     37   210 99 41 50         14     6   94 116     10   74   37   210
2224412 2224412 NY Westchester   school 3615450 660402020000   IRVINGTON 361545001314 660402020003 IRVINGTON MIDDLE SCHOOL public Regular School No Middle 06 08 2019   grade_7 99.0 4.0 17.0         11.0     11.0   75.0 67.0     *       16     21   142 99 4 17         11     11   75 67         16   21   142
766279 766279 NY Franklin   school 3625740 161401060000   SARANAC LAKE 362574003534 161401060003 SARANAC LAKE MIDDLE SCHOOL public Regular School No 2 06 8 2015   grade_7 98.0 0.0 0.0         0.0         53.0 45.0             35     12   98 98 0 0         0         53 45         35   12   98
780396 780396 NY Madison   school 3606390 250901060000   CANASTOTA 360639000419 250901060004 CANASTOTA HIGH SCHOOL public Regular School No 3 07 12 2015   grade_7 98.0 1.0 2.0   1.0     1.0     5.0   50.0 58.0             53     13   108 98 1 2   1     1     5   50 58         53   13   108
789497 789497 NY Nassau   school 3622290 280506060000   OYSTER BAY 362229003147 280506060002 OYSTER BAY HIGH SCHOOL public Regular School No 3 07 12 2015   grade_7 98.0 2.0 21.0   1.0     2.0     2.0   52.0 74.0             25     11   126 98 2 21   1     2     2   52 74         25   11   126
802018 802018 NY Onondaga   school 3626940 421601060000   SKANEATELES 362694003667 421601060005 SKANEATELES MIDDLE SCHOOL public Regular School No 2 06 08 2015   grade_7 98.0 0.0 2.0   1.0     1.0     0.0   53.0 49.0             *     8   102 98 0 2   1     1     0   53 49             8   102
805647 805647 NY Oswego   school 3623880 461801040000   PULASKI 362388006170 461801040004 PULASKI MIDDLE SCHOOL public Regular School No 2 06 08 2015   grade_7 98.0 2.0 1.0   1.0           0.0   58.0 44.0             63     19   102 98 2 1   1           0   58 44         63   19   102
813513 813513 NY Rensselaer   school 3616740 490601060000   LANSINGBURGH 361674001492 490601060002 KNICKERBACKER MIDDLE SCHOOL public Regular School No 2 06 08 2015   grade_7 98.0 38.0 14.0   0.0     1.0     6.0   82.0 75.0             *     35   157 98 38 14   0     1     6   82 75             35   157
831145 831145 NY Westchester   school 3615450 660402020000   IRVINGTON 361545001314 660402020003 IRVINGTON MIDDLE SCHOOL public Regular School No 2 06 08 2015   grade_7 98.0 10.0 11.0   1.0     10.0     7.0   76.0 61.0             7     16   137 98 10 11   1     10     7   76 61         7   16   137
980215 980215 NY Monroe   school 3625170 261701060000   RUSH HENRIETTA 362517000492 261701060015 HENRY V BURGER MIDDLE SCHOOL public Regular School No Middle 06 08 2017   grade_7 98.0 34.0 11.0   1.0     16.0     4.0   79.0 85.0     0       69     20   164 98 34 11   1     16     4   79 85     0   69   20   164
1011375 1011375 NY Richmond   school 3600103 353100010000   NYC GEOG DIST #31 - SI 360010306006 353100010063 MARSH AVE SCH FOR EXPEDITIONARY LRN public Regular School No Middle 06 08 2017   grade_7 98.0 8.0 38.0   0.0     12.0     3.0   67.0 92.0     *       68     36   159 98 8 38   0     12     3   67 92         68   36   159
1015897 1015897 NY Seneca   school 3600014 561006060000   WATERLOO 360001401431 561006060003 WATERLOO MIDDLE SCHOOL public Regular School No Middle 06 08 2017   grade_7 98.0 4.0 3.0   1.0     0.0     2.0   50.0 58.0     *       67     23   108 98 4 3   1     0     2   50 58         67   23   108
1023421 1023421 NY Tioga   school 3630270 600101060000   WAVERLY 363027005437 600101060005 WAVERLY MIDDLE SCHOOL public Regular School No Middle 05 08 2017   grade_7 98.0 2.0 2.0         1.0     0.0   52.0 51.0     *       *     16   103 98 2 2         1     0   52 51             16   103
1024067 1024067 NY Tompkins   school 3615570 610600010000   ITHACA 361557001335 610600010015 DEWITT MIDDLE SCHOOL public Regular School No Middle 06 08 2017   grade_7 98.0 16.0 8.0   0.0     29.0     15.0   77.0 89.0     *       66     20   166 98 16 8   0     29     15   77 89         66   20   166
1028589 1028589 NY Westchester   school 3623310 660809030000   PLEASANTVILLE 362331004745 660809030004 PLEASANTVILLE MIDDLE SCHOOL public Regular School No Middle 05 08 2017   grade_7 98.0 4.0 11.0         8.0     0.0   49.0 72.0     *       15     28   121 98 4 11         8     0   49 72         15   28   121
1029425 1029425 NY Westchester   school 3622020 661401030000   OSSINING 362202003118 661401030006 ANNE M DORNER MIDDLE SCHOOL public Regular School No Middle 06 08 2017   grade_7 98.0 42.0 194.0   1.0     21.0     6.0   192.0 170.0     27       197     59   362 98 42 194   1     21     6   192 170     27   197   59   362
1117110 1117110 NY Westchester   school 3608580 660202030000   CROTON HARMON 360858000660 660202030002 PIERRE VAN CORTLANDT SCHOOL public Regular School No 2.0 05 08 2016   grade_7 98.0 7.0 18.0   0.0     8.0     1.0   48.0 84.0             6     16   132 98 7 18   0     8     1   48 84         6   16   132
1446798 1446798 NY Chenango   school 3626700 82001040000   SHERBURNE EARLVL 362670003644 82001040003 SHERBURNE-EARLVILLE MIDDLE SCHOOL public Regular School No Middle 06 08 2021   grade_7 98.0 1.0 0.0         0.0     2.0   54.0 47.0             63     26   101 98 1 0         0     2   54 47         63   26   101
1449762 1449762 NY Erie   school 3602550 140101060000   ALDEN 360255000038 140101060005 ALDEN MIDDLE SCHOOL public Regular School No Middle 05 08 2021   grade_7 98.0 3.0 2.0   1.0     2.0     1.0   49.0 58.0             31     8   107 98 3 2   1     2     1   49 58         31   8   107
1485824 1485824 NY Niagara   school 3620760 400601060000   NEWFANE 362076002921 400601060008 NEWFANE MIDDLE SCHOOL public Regular School No Middle 04 08 2021   grade_7 98.0 2.0 2.0   0.0     0.0     11.0   50.0 63.0             61     27   113 98 2 2   0     0     11   50 63         61   27   113
1518656 1518656 NY Westchester   school 3615450 660402020000   IRVINGTON 361545001314 660402020003 IRVINGTON MIDDLE SCHOOL public Regular School No Middle 06 08 2021   grade_7 98.0 6.0 16.0         12.0     6.0   79.0 59.0     *       *     19   138 98 6 16         12     6   79 59             19   138
1557397 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
1597791 1597791 NY Steuben   school 3614820 571800010000   HORNELL 361482001233 571800010006 HORNELL JUNIOR-SENIOR HIGH SCHOOL public Regular School No High 07 12 2020   grade_7 98.0 7.0 7.0         1.0     5.0   52.0 66.0     0       67     20   118 98 7 7         1     5   52 66     0   67   20   118
2105377 2105377 NY Onondaga   school 3617520 421501060000   LIVERPOOL 361752001560 421501060002 CHESTNUT HILL MIDDLE SCHOOL public Regular School No Middle 07 08 2018   grade_7 98.0 24.0 10.0   1.0     11.0     14.0   77.0 81.0     7       103     40   158 98 24 10   1     11     14   77 81     7   103   40   158
2138836 2138836 NY Wyoming   school 3603420 670201060000   ATTICA 360342000098 670201060004 ATTICA JUNIOR HIGH SCHOOL public Regular School No Middle 05 08 2018   grade_7 98.0 0.0 2.0               2.0   63.0 39.0     *       41     16   102 98 0 2               2   63 39         41   16   102
2165056 2165056 NY Kings   school 3600092 331500010000   NYC GEOG DIST #15 - BROOKLYN 360009205501 331500010443 NEW VOICES SCH-ACAD & CREATIVE ARTS public Regular School No Middle 06 08 2019   grade_7 98.0 9.0 63.0   0.0     12.0     6.0   50.0 138.0     *       63     39   188 98 9 63   0     12     6   50 138         63   39   188
2173530 2173530 NY Livingston   school 3608790 241001060000   DANSVILLE 360879000667 241001060003 DANSVILLE HIGH SCHOOL public Regular School No High 07 12 2019   grade_7 98.0 0.0 3.0         0.0     2.0   48.0 55.0     *       58     11   103 98 0 3         0     2   48 55         58   11   103
2193138 2193138 NY Oneida   school 3614580 412201060000   HOLLAND PATENT 361458001211 412201060001 HOLLAND PATENT MIDDLE SCHOOL public Regular School No Middle 06 08 2019   grade_7 98.0   0.0         2.0     0.0   50.0 50.0     *       *     19   100 98   0         2     0   50 50             19   100
2221087 2221087 NY Tompkins   school 3615570 610600010000   ITHACA 361557001330 610600010014 BOYNTON MIDDLE SCHOOL public Regular School No Middle 06 08 2019   grade_7 98.0 17.0 11.0   1.0     7.0     21.0   84.0 71.0     *       52     32   155 98 17 11   1     7     21   84 71         52   32   155
759059 759059 NY Clinton   school 3621250 90501040000   NORTHEASTRN CLNTON 362125003018 90501040007 NORTHEASTERN CLINTON MIDDLE SCHOOL public Regular School No 2.0 06 09 2015   grade_7 97.0 1.0 2.0   1.0     0.0     0.0   57.0 44.0             49     *   101 97 1 2   1     0     0   57 44         49       101
759344 759344 NY Clinton   school 3600009 91402060000   SARANAC 360000904670 91402060007 SARANAC MIDDLE SCHOOL public Regular School No 2.0 06 08 2015   grade_7 97.0 2.0 0.0   0.0     1.0     0.0   58.0 42.0             38     16   100 97 2 0   0     1     0   58 42         38   16   100
798997 798997 NY Niagara   school 3625140 401201060000   ROYALTON HARTLAND 362514005836 401201060004 ROYALTON-HARTLAND MIDDLE SCHOOL public Regular School No 2 05 08 2015   grade_7 97.0 2.0 4.0   3.0     0.0     1.0   52.0 55.0             *     11   107 97 2 4   3     0     1   52 55             11   107
804963 804963 NY Orleans   school 3618960 450801060000   MEDINA 361896001715 450801060003 CLIFFORD WISE INTERMEDIATE/MIDDLE public Regular School No 1 03 07 2015   grade_7 97.0 9.0 8.0   0.0     0.0     20.0   57.0 77.0             81     14   134 97 9 8   0     0     20   57 77         81   14   134
833159 833159 NY Westchester   school 3622020 661401030000   OSSINING 362202003118 661401030006 ANNE M DORNER MIDDLE SCHOOL public Regular School No 2 06 09 2015   grade_7 97.0 44.0 188.0         16.0     9.0   167.0 187.0             193     52   354 97 44 188         16     9   167 187         193   52   354
952342 952342 NY Broome   school 3631380 31401060000   WHITNEY POINT 363138004201 31401060002 TIOUGHNIOGA RIVERSIDE ACADEMY public Regular School No Elementary 04 08 2017   grade_7 97.0 0.0 3.0   0.0     0.0     1.0   50.0 51.0             61     12   101 97 0 3   0     0     1   50 51         61   12   101
964768 964768 NY Herkimer   school 3630930 212001040000   MOUNT MARKHAM 363093004155 212001040005 MT MARKHAM MIDDLE SCHOOL public Regular School No Middle 05 8 2017   grade_7 97.0 0.0 1.0         0.0     0.0   46.0 52.0     *       46     25   98 97 0 1         0     0   46 52         46   25   98
965167 965167 NY Jefferson   school 3611910 220401040000   GENERAL BROWN 361191000960 220401040004 GENERAL BROWN JUNIOR-SENIOR HS public Regular School No High 07 12 2017   grade_7 97.0 3.0 0.0   0.0     1.0     0.0   62.0 39.0     *       46     16   101 97 3 0   0     1     0   62 39         46   16   101
1009893 1009893 NY Rensselaer   school 3616740 490601060000   LANSINGBURGH 361674001492 490601060002 KNICKERBACKER MIDDLE SCHOOL public Regular School No Middle 06 08 2017   grade_7 97.0 32.0 20.0         1.0     9.0   97.0 62.0     *       102     20   159 97 32 20         1     9   97 62         102   20   159
1031496 1031496 NY Wyoming   school 3603420 670201060000   ATTICA 360342000098 670201060004 ATTICA JUNIOR HIGH SCHOOL public Regular School No Middle 05 08 2017   grade_7 97.0   3.0         0.0     1.0   53.0 48.0     *       38     19   101 97   3         0     1   53 48         38   19   101
1099953 1099953 NY Rensselaer   school 3616740 490601060000   LANSINGBURGH 361674001492 490601060002 KNICKERBACKER MIDDLE SCHOOL public Regular School No 2.0 06 08 2016   grade_7 97.0 28.0 27.0         2.0     16.0   92.0 78.0             109     31   170 97 28 27         2     16   92 78         109   31   170
1113614 1113614 NY Tioga   school 3630270 600101060000   WAVERLY 363027005437 600101060005 WAVERLY MIDDLE SCHOOL public Regular School No 2.0 06 08 2016   grade_7 97.0 0.0 1.0         5.0         50.0 53.0             61     17   103 97 0 1         5         50 53         61   17   103
1444005 1444005 NY Broome   school 3602730 31701060000   WINDSOR 360273000048 31701060004 A F PALMER ES / WINDSOR CENTRAL MS public Regular School No Elementary PK 08 2021   grade_7 97.0 1.0 7.0   0.0     3.0     6.0   61.0 53.0     *       70     19   114 97 1 7   0     3     6   61 53         70   19   114
1492512 1492512 NY Oswego   school 3613590 460701040000   HANNIBAL 361359001111 460701040001 KENNEY MIDDLE SCHOOL public Regular School No Middle 05 08 2021   grade_7 97.0 1.0 1.0   0.0           0.0   50.0 49.0     *       60     17   99 97 1 1   0           0   50 49         60   17   99
1493253 1493253 NY Otsego   school 3621780 471400010000   ONEONTA 362178003094 471400010007 ONEONTA MIDDLE SCHOOL public Regular School No Middle 06 08 2021   grade_7 97.0 11.0 8.0   0.0     2.0     11.0   65.0 64.0             53     21   129 97 11 8   0     2     11   65 64         53   21   129
1507902 1507902 NY Suffolk   school 3603720 580101030000   BABYLON 360372000121 580101030002 BABYLON JUNIOR-SENIOR HIGH SCHOOL public Regular School No High 07 12 2021   grade_7 97.0 2.0 14.0         9.0     1.0   68.0 55.0     *       20     15   123 97 2 14         9     1   68 55         20   15   123
1515825 1515825 NY Ulster   school 3614400 620803040000   HIGHLAND 361440001193 620803040003 HIGHLAND MIDDLE SCHOOL public Regular School No Middle 06 08 2021   grade_7 97.0 6.0 17.0         5.0     4.0   71.0 58.0     *       46     15   129 97 6 17         5     4   71 58         46   15   129
1533210 1533210 NY Broome   school 3604870 30200010000   BINGHAMTON 360487000234 30200010016 WEST MIDDLE SCHOOL public Regular School No Middle 06 08 2020   grade_7 97.0 48.0 25.0   1.0     5.0     24.0   103.0 97.0     *       143     34   200 97 48 25   1     5     24   103 97         143   34   200
1536782 1536782 NY Chenango   school 3626700 82001040000   SHERBURNE EARLVL 362670003644 82001040003 SHERBURNE-EARLVILLE MIDDLE SCHOOL public Regular School No Middle 06 08 2020   grade_7 97.0 1.0           1.0     2.0   54.0 47.0             55     22   101 97 1           1     2   54 47         55   22   101
1548182 1548182 NY Kings   school 3600119 331400010000   NYC GEOG DIST #14 - BROOKLYN 360011902816 331400010318 IS 318 EUGENIO MARIA DE HOSTOS public Regular School No Middle 06 08 2020   grade_7 97.0 71.0 223.0   2.0     33.0     3.0   221.0 208.0     *       276     89   429 97 71 223   2     33     3   221 208         276   89   429
1576663 1576663 NY Oneida   school 3605040 410401060000   ADIRONDACK 360504004187 410401060001 ADIRONDACK MIDDLE SCHOOL public Regular School No Middle 06 08 2020   grade_7 97.0                   0.0   43.0 54.0             55     10   97 97                   0   43 54         55   10   97
2075338 2075338 NY Kings   school 3600092 331500010000   NYC GEOG DIST #15 - BROOKLYN 360009205501 331500010443 NEW VOICES SCH-ACAD & CREATIVE ARTS public Regular School No Middle 06 08 2018   grade_7 97.0 14.0 68.0         6.0     8.0   46.0 147.0     0       53     43   193 97 14 68         6     8   46 147     0   53   43   193
2120596 2120596 NY Saint Lawrence   school 3612360 511101060000   GOUVERNEUR 361236001002 511101060005 GOUVERNEUR JUNIOR-SENIOR HIGH SCHOOL public Regular School No High 05 12 2018   grade_7 97.0 1.0 1.0         1.0     0.0   46.0 54.0     *       65     12   100 97 1 1         1     0   46 54         65   12   100
2183087 2183087 NY Nassau   school 3615810 280515030000   JERICHO 361581001369 280515030006 JERICHO MIDDLE SCHOOL public Regular School No Middle 06 08 2019   grade_7 97.0 7.0 6.0         153.0     2.0   138.0 127.0     *       *     40   265 97 7 6         153     2   138 127             40   265
2192264 2192264 NY Niagara   school 3625140 401201060000   ROYALTON HARTLAND 362514005836 401201060004 ROYALTON-HARTLAND MIDDLE SCHOOL public Regular School No Middle 05 08 2019   grade_7 97.0 1.0 2.0         0.0     1.0   54.0 47.0     *       44     15   101 97 1 2         0     1   54 47         44   15   101
2220365 2220365 NY Sullivan   school 3619740 591401060000   MONTICELLO 361974001811 591401060006 ROBERT J KAISER MIDDLE SCHOOL public Regular School No Middle 06 08 2019   grade_7 97.0 47.0 80.0         3.0     12.0   118.0 121.0     5       161     52   239 97 47 80         3     12   118 121     5   161   52   239
756133 756133 NY Cattaraugus   school 3600015 40302060000   ALLEGANY-LIMESTONE 360001504317 40302060004 ALLEGANY-LIMESTONE MIDDLE SCHOOL public Regular School No 2.0 06 08 2015   grade_7 96.0 3.0 3.0   1.0     4.0     1.0   60.0 48.0             40     16   108 96 3 3   1     4     1   60 48         40   16   108
779826 779826 NY Livingston   school 3603660 240101040000   AVON 360366004863 240101040003 AVON MIDDLE SCHOOL public Regular School No 2 05 08 2015   grade_7 96.0 0.0 3.0         3.0     2.0   45.0 59.0             30     8   104 96 0 3         3     2   45 59         30   8   104
942785 942785 NY Albany   school 3607980 10500010000   COHOES 360798000570 10500010008 COHOES MIDDLE SCHOOL public Regular School No Middle 06 08 2017   grade_7 96.0 15.0 12.0   1.0     1.0     2.0   65.0 62.0     0       94     17   127 96 15 12   1     1     2   65 62     0   94   17   127
963856 963856 NY Genesee   school 3616950 181001060000   LE ROY 361695001506 181001060002 LE ROY JUNIOR-SENIOR HIGH SCHOOL public Regular School No High 07 12 2017   grade_7 96.0 1.0 2.0   0.0     1.0     0.0   48.0 52.0     *       37     11   100 96 1 2   0     1     0   48 52         37   11   100
1002236 1002236 NY Otsego   school 3621780 471400010000   ONEONTA 362178003094 471400010007 ONEONTA MIDDLE SCHOOL public Regular School No Middle 06 08 2017   grade_7 96.0 7.0 9.0         2.0     0.0   57.0 57.0     *       51     16   114 96 7 9         2     0   57 57         51   16   114
1006302 1006302 NY Queens   school 3600123 342700010000   NYC GEOG DIST #27 - QUEENS 360012305831 342700010323 SCHOLARS' ACADEMY public Regular School No Other 06 12 2017   grade_7 96.0 38.0 38.0   6.0     51.0     2.0   101.0 130.0             96     28   231 96 38 38   6     51     2   101 130         96   28   231
1031686 1031686 NY Yates   school 3622740 680601060000   PENN YAN 362274003202 680601060002 PENN YAN MIDDLE SCHOOL public Regular School No Middle 06 08 2017   grade_7 96.0   9.0         2.0     4.0   56.0 55.0     *       71     20   111 96   9         2     4   56 55         71   20   111
1046031 1046031 NY Columbia   school 3628620 100501040000   TACONIC HILLS 362862003886 100501040003 TACONIC HILLS JUNIOR/SENIOR HIGH public Regular School No 3.0 07 12 2016   grade_7 96.0 2.0 9.0         1.0     5.0   55.0 58.0             69     22   113 96 2 9         1     5   55 58         69   22   113
1066551 1066551 NY Livingston   school 3608790 241001060000   DANSVILLE 360879000667 241001060003 DANSVILLE HIGH SCHOOL public Regular School No 3.0 07 12 2016   grade_7 96.0 2.0 5.0   0.0     0.0     0.0   46.0 57.0             60     11   103 96 2 5   0     0     0   46 57         60   11   103
1091536 1091536 NY Oswego   school 3613590 460701040000   HANNIBAL 361359001111 460701040001 KENNEY MIDDLE SCHOOL public Regular School No 2.0 05 08 2016   grade_7 96.0 0.0 1.0   2.0           1.0   61.0 39.0             75     12   100 96 0 1   2           1   61 39         75   12   100
1092809 1092809 NY Putnam   school 3624000 480503040000   PUTNAM VALLEY 362400003315 480503040002 PUTNAM VALLEY MIDDLE SCHOOL public Regular School No 2.0 05 08 2016   grade_7 96.0 4.0 23.0         4.0     1.0   60.0 68.0             18     21   128 96 4 23         4     1   60 68         18   21   128
1105387 1105387 NY Schenectady   school 3626010 530600010000   SCHENECTADY 362601003585 530600010024 MONT PLEASANT MIDDLE SCHOOL public Regular School No 2.0 07 09 2016   grade_7 96.0 123.0 74.0         48.0     6.0   183.0 164.0             295     100   347 96 123 74         48     6   183 164         295   100   347
1106508 1106508 NY Steuben   school 3614820 571800010000   HORNELL 361482005978 571800010008 HORNELL JUNIOR HIGH SCHOOL public Regular School No 2.0 07 08 2016   grade_7 96.0 4.0 2.0   0.0     0.0     14.0   60.0 56.0             *     *   116 96 4 2   0     0     14   60 56                 116
1114735 1114735 NY Ulster   school 3614400 620803040000   HIGHLAND 361440001193 620803040003 HIGHLAND MIDDLE SCHOOL public Regular School No 2.0 06 08 2016   grade_7 96.0 8.0 21.0   0.0     4.0     5.0   67.0 67.0             51     26   134 96 8 21   0     4     5   67 67         51   26   134
1445050 1445050 NY Chautauqua   school 3627660 60201060000   SOUTHWESTERN 362766003755 60201060006 SOUTHWESTERN MIDDLE SCHOOL public Regular School No Middle 06 08 2021   grade_7 96.0   6.0   1.0     1.0     5.0   55.0 54.0             43     16   109 96   6   1     1     5   55 54         43   16   109
1472524 1472524 NY Nassau   school 3609840 280203030000   EAST MEADOW 360984000106 280203030008 CLARKE MIDDLE SCHOOL public Regular School No Middle 06 08 2021   grade_7 96.0 11.0 60.0         63.0     0.0   124.0 106.0     *       62     35   230 96 11 60         63     0   124 106         62   35   230
1490973 1490973 NY Orange   school 3623010 440401060000   PINE BUSH 362301003224 440401060007 CIRCLEVILLE MIDDLE SCHOOL public Regular School No Middle 06 08 2021   grade_7 96.0 34.0 40.0         4.0     8.0   94.0 88.0     *       115     38   182 96 34 40         4     8   94 88         115   38   182

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