Data source: Big Local News · About: Big Local

4,719 rows where grade = "grade_8", state = "NY" and year = 2019 sorted by multiracial descending

View and edit SQL

year

  • 2019 · 4,719

grade

  • grade_8 · 4,719
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
2139844 NY Albany   school 3607980 10500010000   COHOES 360798000570 10500010008 COHOES MIDDLE SCHOOL public Regular School No Middle 06 08 2019   grade_8 99.0 13.0 10.0   2.0     2.0     9.0   61.0 74.0     *       88     23   135 99 13 10   2     2     9   61 74         88   23   135
2140319 NY Albany   school 3613080 10802060000   GUILDERLAND 361308001071 10802060008 FARNSWORTH MIDDLE SCHOOL public Regular School No Middle 06 08 2019   grade_8 268.0 19.0 26.0   0.0     48.0     9.0   175.0 195.0     6       85     48   370 268 19 26   0     48     9   175 195     6   85   48   370
2151206 NY Chautauqua   school 3609420 60800010000   DUNKIRK 360942000718 60800010010 DUNKIRK MIDDLE SCHOOL public Regular School No Middle 03 08 2019   grade_8 53.0 7.0 84.0   0.0           9.0   81.0 72.0     29       115     12   153 53 7 84   0           9   81 72     29   115   12   153
2151548 NY Chautauqua   school 3615630 61700010000   JAMESTOWN 361563001351 61700010010 THOMAS JEFFERSON MIDDLE SCHOOL public Regular School No Middle 05 08 2019   grade_8 53.0 7.0 31.0               9.0   57.0 43.0     *       74     13   100 53 7 31               9   57 43         74   13   100
2155956 NY Erie   school 3631470 140203060000   WILLIAMSVILLE 363147004756 140203060012 CASEY MIDDLE SCHOOL public Regular School No Middle 05 08 2019   grade_8 117.0 11.0 10.0   2.0     15.0     9.0   68.0 96.0     *       27     12   164 117 11 10   2     15     9   68 96         27   12   164
2156830 NY Erie   school 3605850 140600010000   BUFFALO 360585000308 140600010102 CITY HONORS SCHOOL public Regular School No High 05 12 2019   grade_8 88.0 19.0 10.0   0.0     14.0     9.0   64.0 76.0     *       42     11   140 88 19 10   0     14     9   64 76         42   11   140
2159167 NY Erie   school 3621900 142301060000   ORCHARD PARK 362190003111 142301060002 ORCHARD PARK MIDDLE SCHOOL public Regular School No Middle 06 08 2019   grade_8 340.0 0.0 8.0   0.0     5.0     9.0   182.0 180.0     *       51     49   362 340 0 8   0     5     9   182 180         51   49   362
2185786 NY New York   school 3600077 310200010000   NYC GEOG DIST # 2 - MANHATTAN 360007704405 310200010114 EAST SIDE MIDDLE SCHOOL public Regular School No Middle 06 08 2019   grade_8 101.0 5.0 17.0   2.0     18.0     9.0   72.0 80.0             25     26   152 101 5 17   2     18     9   72 80         25   26   152
2198193 NY Orleans   school 3618960 450801060000   MEDINA 361896001716 450801060004 MEDINA HIGH SCHOOL public Regular School No High 08 12 2019   grade_8 93.0 3.0 11.0   1.0     1.0     9.0   52.0 66.0     *       68     13   118 93 3 11   1     1     9   52 66         68   13   118
2211037 NY Saratoga   school 3626670 520302060000   SHENENDEHOWA 362667001421 520302060011 ACADIA MIDDLE SCHOOL public Regular School No Middle 06 08 2019   grade_8 186.0 10.0 12.0         46.0     9.0   137.0 126.0     *       43     20   263 186 10 12         46     9   137 126         43   20   263
2216870 NY Suffolk   school 3621270 580404030000   NORTHPORT 362127003028 580404030007 EAST NORTHPORT MIDDLE SCHOOL public Regular School No Middle 06 08 2019   grade_8 182.0   29.0         11.0     9.0   118.0 113.0     10       40     37   231 182   29         11     9   118 113     10   40   37   231
2216889 NY Suffolk   school 3621270 580404030000   NORTHPORT 362127003032 580404030008 NORTHPORT MIDDLE SCHOOL public Regular School No Middle 06 08 2019   grade_8 208.0 1.0 5.0         7.0     9.0   131.0 99.0     *       31     29   230 208 1 5         7     9   131 99         31   29   230
2217592 NY Suffolk   school 3604080 580501030000   BAY SHORE 360408000165 580501030007 BAY SHORE MIDDLE SCHOOL public Regular School No Middle 06 08 2019   grade_8 146.0 81.0 196.0   0.0     20.0     9.0   251.0 201.0     32       266     69   452 146 81 196   0     20     9   251 201     32   266   69   452
2217649 NY Suffolk   school 3615540 580502020000   ISLIP 361554001325 580502020004 ISLIP MIDDLE SCHOOL public Regular School No Middle 06 08 2019   grade_8 133.0 13.0 69.0   0.0     7.0     9.0   123.0 108.0     *       77     28   231 133 13 69   0     7     9   123 108         77   28   231
2226427 NY Westchester   school 3622020 661401030000   OSSINING 362202003118 661401030006 ANNE M DORNER MIDDLE SCHOOL public Regular School No Middle 06 09 2019   grade_8 83.0 32.0 198.0         28.0     9.0   170.0 180.0     20       203     48   350 83 32 198         28     9   170 180     20   203   48   350
2226731 NY Westchester   school 3622680 661601030000   PELHAM 362268003187 661601030006 PELHAM MIDDLE SCHOOL public Regular School No Middle 06 08 2019   grade_8 153.0 9.0 33.0         9.0     9.0   106.0 107.0     *       20     28   213 153 9 33         9     9   106 107         20   28   213
2227415 NY Westchester   school 3631260 662200010000   WHITE PLAINS 363126004177 662200010012 WHITE PLAINS MIDDLE SCHOOL public Regular School No Middle 06 08 2019   grade_8 121.0 59.0 277.0         18.0     9.0   262.0 222.0     36       286     72   484 121 59 277         18     9   262 222     36   286   72   484
2152213 NY Chemung   school 3610590 70902060000   ELMIRA HEIGHTS 361059002828 70902060004 COHEN MIDDLE SCHOOL public Regular School No Middle 06 08 2019   grade_8 72.0 1.0 0.0   1.0     1.0     8.0   41.0 42.0             43     24   83 72 1 0   1     1     8   41 42         43   24   83
2155424 NY Dutchess   school 3629880 132101060000   WAPPINGERS 362988004026 132101060010 WAPPINGERS JUNIOR HIGH SCHOOL public Regular School No Middle 07 08 2019   grade_8 245.0 23.0 94.0         21.0     8.0   200.0 191.0     8       *     73   391 245 23 94         21     8   200 191     8       73   391
2155690 NY Erie   school 3602920 140201060000   AMHERST 360292004335 140201060001 AMHERST MIDDLE SCHOOL public Regular School No Middle 06 08 2019   grade_8 158.0 37.0 12.0   1.0     11.0     8.0   117.0 110.0     9       79     21   227 158 37 12   1     11     8   117 110     9   79   21   227
2156678 NY Erie   school 3605850 140600010000   BUFFALO 360585000369 140600010081 PS 81 public Regular School No Elementary PK 08 2019   grade_8 9.0 53.0 8.0   4.0     5.0     8.0   55.0 32.0     0       66     18   87 9 53 8   4     5     8   55 32     0   66   18   87
2158996 NY Erie   school 3616680 141901060000   LANCASTER 361668001482 141901060007 LANCASTER MIDDLE SCHOOL public Regular School No Middle 07 08 2019   grade_8 379.0 4.0 19.0   0.0     5.0     8.0   220.0 195.0     *       86     84   415 379 4 19   0     5     8   220 195         86   84   415
2159471 NY Erie   school 3616230 142601030000   KENMORE 361623001410 142601030025 KENMORE EAST SENIOR HIGH SCHOOL public Regular School No High 08 12 2019   grade_8 184.0 15.0 9.0   0.0     7.0     8.0   110.0 113.0     7       98     50   223 184 15 9   0     7     8   110 113     7   98   50   223
2159490 NY Erie   school 3616230 142601030000   KENMORE 361623001412 142601030026 KENMORE WEST SENIOR HIGH SCHOOL public Regular School No High 08 12 2019   grade_8 203.0 15.0 17.0   1.0     10.0     8.0   125.0 129.0     10       130     45   254 203 15 17   1     10     8   125 129     10   130   45   254
2159604 NY Erie   school 3630780 142801060000   WEST SENECA 363078004150 142801060011 WEST MIDDLE SCHOOL public Regular School No Middle 06 08 2019   grade_8 262.0 5.0 10.0   1.0     3.0     8.0   155.0 134.0             111     53   289 262 5 10   1     3     8   155 134         111   53   289
2165057 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_8 93.0 14.0 65.0   0.0     6.0     8.0   44.0 142.0     0       54     43   186 93 14 65   0     6     8   44 142     0   54   43   186
2170092 NY Kings   school 3600152 332100010000   NYC GEOG DIST #21 - BROOKLYN 360015203011 332100010098 IS 98 BAY ACADEMY public Regular School No Middle 06 08 2019   grade_8 290.0 13.0 40.0   4.0     136.0     8.0   211.0 280.0     5       *     50   491 290 13 40   4     136     8   211 280     5       50   491
2175279 NY Monroe   school 3614460 261101060000   HILTON 361446001200 261101060005 MERTON WILLIAMS MIDDLE SCHOOL public Regular School No Middle 06 08 2019   grade_8 291.0 8.0 21.0   1.0     7.0     8.0   165.0 171.0     *       *     39   336 291 8 21   1     7     8   165 171             39   336
2177407 NY Monroe   school 3630360 261901060000   WEBSTER 363036004081 261901060010 WILLINK MIDDLE SCHOOL public Regular School No Middle 06 08 2019   grade_8 275.0 6.0 15.0   0.0     10.0     8.0   154.0 160.0     *       57     29   314 275 6 15   0     10     8   154 160         57   29   314
2177578 NY Montgomery   school 3602970 270100010000   AMSTERDAM 360297000071 270100010009 WILBUR H LYNCH LITERACY ACADEMY public Regular School No Middle 06 08 2019   grade_8 115.0 21.0 137.0   3.0     5.0     8.0   139.0 150.0     20       212     40   289 115 21 137   3     5     8   139 150     20   212   40   289
2179155 NY Nassau   school 3611550 280209030000   FREEPORT 361155000915 280209030006 JOHN W DODD MIDDLE SCHOOL public Regular School No Middle 07 08 2019   grade_8 24.0 117.0 315.0   1.0     8.0     8.0   254.0 219.0     75       329     75   473 24 117 315   1     8     8   254 219     75   329   75   473
2181226 NY Nassau   school 3619020 280253070000   BELLMORE-MERRICK 361902001722 280253070002 GRAND AVENUE MIDDLE SCHOOL public Regular School No Middle 07 08 2019   grade_8 365.0 12.0 46.0   4.0     34.0     8.0   228.0 241.0     *       67     *   469 365 12 46   4     34     8   228 241         67       469
2182499 NY Nassau   school 3626370 280501060000   NORTH SHORE 362637003613 280501060005 NORTH SHORE MIDDLE SCHOOL public Regular School No Middle 06 08 2019   grade_8 162.0 2.0 22.0   1.0     12.0     8.0   107.0 100.0     *       30     38   207 162 2 22   1     12     8   107 100         30   38   207
2193633 NY Oneida   school 3631320 412902060000   WHITESBORO 363132004196 412902060006 WHITESBORO MIDDLE SCHOOL public Regular School No Middle 07 08 2019   grade_8 227.0 0.0 8.0         3.0     8.0   134.0 112.0     *       89     41   246 227 0 8         3     8   134 112         89   41   246
2195514 NY Onondaga   school 3628590 421800010000   SYRACUSE 362859003860 421800010022 FRAZER K-8 SCHOOL public Regular School No Elementary PK 08 2019   grade_8 34.0 56.0 21.0   2.0     21.0     8.0   81.0 61.0     32       131     24   142 34 56 21   2     21     8   81 61     32   131   24   142
2212063 NY Schenectady   school 3625980 530501060000   SCHALMONT 362598003570 530501060004 SCHALMONT MIDDLE SCHOOL public Regular School No Middle 05 08 2019   grade_8 142.0 1.0 6.0   1.0     1.0     8.0   79.0 80.0             51     27   159 142 1 6   1     1     8   79 80         51   27   159
2216984 NY Suffolk   school 3613290 580405060000   HALF HOLLOW HILLS 361329001081 580405060008 CANDLEWOOD MIDDLE SCHOOL public Regular School No Middle 06 08 2019   grade_8 151.0 31.0 26.0   1.0     53.0     8.0   134.0 136.0     0       50     52   270 151 31 26   1     53     8   134 136     0   50   52   270
2217136 NY Suffolk   school 3613620 580406060000   HARBORFIELDS 361362001116 580406060005 OLDFIELD MIDDLE SCHOOL public Regular School No Middle 06 08 2019   grade_8 179.0 14.0 26.0         12.0     8.0   109.0 130.0     *       42     34   239 179 14 26         12     8   109 130         42   34   239
2217288 NY Suffolk   school 3608130 580410030000   COMMACK 360813000581 580410030019 COMMACK MIDDLE SCHOOL public Regular School No Middle 06 08 2019   grade_8 390.0 8.0 43.0   2.0     30.0     8.0   236.0 245.0     *       52     77   481 390 8 43   2     30     8   236 245         52   77   481
2224033 NY Westchester   school 3614190 660203060000   HENDRICK HUDSON 361419001161 660203060007 BLUE MOUNTAIN MIDDLE SCHOOL public Regular School No Middle 06 08 2019   grade_8 105.0 12.0 34.0   1.0     3.0     8.0   79.0 84.0     *       46     34   163 105 12 34   1     3     8   79 84         46   34   163
2226826 NY Westchester   school 3625260 661800010000   RYE 362526003493 661800010005 RYE MIDDLE SCHOOL public Regular School No Middle 06 08 2019   grade_8 229.0 3.0 12.0   2.0     14.0     8.0   150.0 118.0     *       8     30   268 229 3 12   2     14     8   150 118         8   30   268
2226883 NY Westchester   school 3625290 661901030000   RYE NECK 362529003495 661901030004 RYE NECK MIDDLE SCHOOL public Regular School No Middle 06 08 2019   grade_8 85.0 5.0 36.0         9.0     8.0   78.0 65.0     *       23     20   143 85 5 36         9     8   78 65         23   20   143
2140433 NY Albany   school 3630210 11200010000   WATERVLIET 363021004061 11200010010 WATERVLIET JUNIOR-SENIOR HIGH SCHOOL public Regular School No High 07 12 2019   grade_8 34.0 24.0 19.0   0.0     7.0     7.0   57.0 34.0     8       64     7   91 34 24 19   0     7     7   57 34     8   64   7   91
2151339 NY Chautauqua   school 3626880 61501040000   SILVER CREEK 362688005588 61501040002 SILVER CREEK MIDDLE SCHOOL public Regular School No Middle 06 08 2019   grade_8 61.0 0.0 4.0   10.0           7.0   40.0 42.0     *       47     *   82 61 0 4   10           7   40 42         47       82
2156944 NY Erie   school 3605850 140600010000   BUFFALO 360585000381 140600010119 WATERFRONT ELEMENTARY SCHOOL public Regular School No Elementary PK 08 2019   grade_8 10.0 43.0 10.0   2.0     13.0     7.0   45.0 40.0     *       77     15   85 10 43 10   2     13     7   45 40         77   15   85
2157761 NY Erie   school 3618600 140702030000   MARYVALE 361860001677 140702030005 MARYVALE MIDDLE SCHOOL public Regular School No Middle 06 08 2019   grade_8 137.0 11.0 7.0   2.0     6.0     7.0   105.0 65.0     10       87     24   170 137 11 7   2     6     7   105 65     10   87   24   170
2158084 NY Erie   school 3607590 140801060000   CLARENCE 360759000542 140801060008 CLARENCE MIDDLE SCHOOL public Regular School No Middle 06 08 2019   grade_8 316.0 5.0 16.0   0.0     8.0     7.0   167.0 185.0     *       49     44   352 316 5 16   0     8     7   167 185         49   44   352
2159547 NY Erie   school 3630780 142801060000   WEST SENECA 363078004144 142801060005 EAST MIDDLE SCHOOL public Regular School No Middle 05 08 2019   grade_8 169.0 5.0 9.0   0.0     3.0     7.0   102.0 91.0     *       67     26   193 169 5 9   0     3     7   102 91         67   26   193
2161124 NY Greene   school 3606160 190301040000   CAIRO-DURHAM 360616001568 190301040004 CAIRO-DURHAM MIDDLE SCHOOL public Regular School No Other PK 12 2019   grade_8 79.0 2.0 5.0   0.0     0.0     7.0   47.0 46.0     *       57     14   93 79 2 5   0     0     7   47 46         57   14   93
2165532 NY Kings   school 3601100 331500861011   BROOKLYN URBAN GARDEN CHARTE 360110006402 331500861011 BROOKLYN URBAN GARDEN CHARTER SCHOOL charter Regular School Yes Middle 06 08 2019   grade_8 9.0 34.0 39.0         4.0     7.0   46.0 47.0     *       64     24   93 9 34 39         4     7   46 47         64   24   93
2179744 NY Nassau   school 3631710 280214030000   HEWLETT WOODMERE 363171004230 280214030006 WOODMERE MIDDLE SCHOOL public Regular School No Middle 06 08 2019   grade_8 170.0 16.0 38.0   1.0     24.0     7.0   145.0 111.0     *       *     31   256 170 16 38   1     24     7   145 111             31   256
2183544 NY Nassau   school 3610980 280522030000   FARMINGDALE 361098000878 280522030008 HOWITT SCHOOL public Regular School No Middle 06 08 2019   grade_8 281.0 33.0 90.0   0.0     29.0     7.0   247.0 193.0     21       *     90   440 281 33 90   0     29     7   247 193     21       90   440
2186147 NY New York   school 3600077 310200010000   NYC GEOG DIST # 2 - MANHATTAN 360007706158 310200010276 BATTERY PARK CITY SCHOOL public Regular School No Elementary PK 08 2019   grade_8 42.0 8.0 16.0   1.0     17.0     7.0   48.0 43.0     *       17     24   91 42 8 16   1     17     7   48 43         17   24   91
2186375 NY New York   school 3600077 310200010000   NYC GEOG DIST # 2 - MANHATTAN 360007702862 310200010413 SCHOOL OF THE FUTURE HIGH SCHOOL public Regular School No High 06 12 2019   grade_8 40.0 11.0 24.0   1.0     22.0     7.0   48.0 57.0     0       47     25   105 40 11 24   1     22     7   48 57     0   47   25   105
2188313 NY New York   school 3600078 310300010000   NYC GEOG DIST # 3 - MANHATTAN 360007805773 310300010334 ANDERSON SCHOOL (THE) public Regular School No Elementary KG 08 2019   grade_8 37.0 0.0 8.0         12.0     7.0   26.0 38.0     *       8     5   64 37 0 8         12     7   26 38         8   5   64
2193785 NY Onondaga   school 3630630 420101060000   WEST GENESEE 363063004118 420101060008 WEST GENESEE MIDDLE SCHOOL public Regular School No Middle 06 08 2019   grade_8 170.0 6.0 5.0   1.0     3.0     7.0   104.0 88.0     *       64     29   192 170 6 5   1     3     7   104 88         64   29   192
2198554 NY Oswego   school 3606900 460801060000   CENTRAL SQUARE 360690000999 460801060008 CENTRAL SQUARE MIDDLE SCHOOL public Regular School No Middle 06 08 2019   grade_8 254.0 4.0 11.0   1.0     1.0     7.0   142.0 136.0             *     28   278 254 4 11   1     1     7   142 136             28   278
2201860 NY Queens   school 3600099 342600010000   NYC GEOG DIST #26 - QUEENS 360009902281 342600010067 JHS 67 LOUIS PASTEUR public Regular School No Middle 06 08 2019   grade_8 50.0 14.0 40.0   1.0     164.0     7.0   139.0 137.0     8       113     31   276 50 14 40   1     164     7   139 137     8   113   31   276
2201974 NY Queens   school 3600099 342600010000   NYC GEOG DIST #26 - QUEENS 360009902568 342600010158 MS 158 MARIE CURIE public Regular School No Middle 06 08 2019   grade_8 57.0 17.0 48.0   1.0     233.0     7.0   190.0 173.0     30       211     42   363 57 17 48   1     233     7   190 173     30   211   42   363
2202202 NY Queens   school 3600099 342600010000   NYC GEOG DIST #26 - QUEENS 360009902716 342600010216 JHS 216 GEORGE J RYAN public Regular School No Middle 06 08 2019   grade_8 60.0 24.0 69.0   5.0     304.0     7.0   248.0 221.0     25       *     *   469 60 24 69   5     304     7   248 221     25           469
2204159 NY Queens   school 3600100 342800010000   NYC GEOG DIST #28 - QUEENS 360010002653 342800010190 JHS 190 RUSSELL SAGE public Regular School No Middle 06 08 2019   grade_8 110.0 23.0 96.0   4.0     99.0     7.0   195.0 144.0     33       *     *   339 110 23 96   4     99     7   195 144     33           339
2212025 NY Schenectady   school 3620880 530301060000   NISKAYUNA 362088004488 530301060008 IROQUOIS MIDDLE SCHOOL public Regular School No Middle 06 08 2019   grade_8 137.0 6.0 9.0   0.0     20.0     7.0   84.0 95.0     *       28     *   179 137 6 9   0     20     7   84 95         28       179
2214286 NY Suffolk   school 3602940 580106030000   AMITYVILLE 360294000062 580106030004 EDMUND W MILES MIDDLE SCHOOL public Regular School No Middle 07 09 2019   grade_8 13.0 68.0 108.0   1.0     1.0     7.0   99.0 99.0     45       161     28   198 13 68 108   1     1     7   99 99     45   161   28   198
2215293 NY Suffolk   school 3624840 580209020000   ROCKY POINT 362484005420 580209020004 ROCKY POINT MIDDLE SCHOOL public Regular School No Middle 06 08 2019   grade_8 191.0 3.0 31.0   0.0     3.0     7.0   107.0 128.0     8       78     38   235 191 3 31   0     3     7   107 128     8   78   38   235
2215464 NY Suffolk   school 3619200 580211060000   MIDDLE COUNTRY 361920001745 580211060011 SELDEN MIDDLE SCHOOL public Regular School No Middle 06 08 2019   grade_8 241.0 22.0 68.0         31.0     7.0   198.0 171.0             141     51   369 241 22 68         31     7   198 171         141   51   369
2220062 NY Sullivan   school 3610950 590501060000   FALLSBURG 361095000874 590501060002 FALLSBURG JUNIOR-SENIOR HIGH SCHOOL public Regular School No High 07 12 2019   grade_8 46.0 8.0 60.0   0.0     0.0     7.0   69.0 52.0     23       76     19   121 46 8 60   0     0     7   69 52     23   76   19   121
2220860 NY Tompkins   school 3609330 610301060000   DRYDEN 360933002719 610301060008 DRYDEN MIDDLE SCHOOL public Regular School No Middle 06 08 2019   grade_8 106.0 1.0 4.0   0.0     1.0     7.0   63.0 56.0             *     18   119 106 1 4   0     1     7   63 56             18   119
2221221 NY Tompkins   school 3616710 610801040000   LANSING 361671001491 610801040003 LANSING MIDDLE SCHOOL public Regular School No Middle 05 08 2019   grade_8 75.0 1.0 3.0   0.0     2.0     7.0   53.0 35.0     *       24     9   88 75 1 3   0     2     7   53 35         24   9   88
2222114 NY Ulster   school 3629790 621801060000   WALLKILL 362979004003 621801060006 JOHN G BORDEN MIDDLE SCHOOL public Regular School No Middle 07 08 2019   grade_8 174.0 11.0 53.0   0.0     2.0     7.0   119.0 128.0     *       81     32   247 174 11 53   0     2     7   119 128         81   32   247
2222285 NY Warren   school 3612240 630300010000   GLENS FALLS 361224000980 630300010006 GLENS FALLS MIDDLE SCHOOL public Regular School No Middle 05 08 2019   grade_8 134.0 3.0 6.0         3.0     7.0   76.0 77.0             78     35   153 134 3 6         3     7   76 77         78   35   153
2222798 NY Washington   school 3614970 641301060000   HUDSON FALLS 361497001253 641301060002 HUDSON FALLS MIDDLE SCHOOL public Regular School No Middle 06 08 2019   grade_8 158.0 1.0 10.0         0.0     7.0   90.0 86.0     *       86     36   176 158 1 10         0     7   90 86         86   36   176
2224413 NY Westchester   school 3615450 660402020000   IRVINGTON 361545001314 660402020003 IRVINGTON MIDDLE SCHOOL public Regular School No Middle 06 08 2019   grade_8 97.0 6.0 7.0         12.0     7.0   60.0 69.0     *       9     7   129 97 6 7         12     7   60 69         9   7   129
2139388 NY Albany   school 3602460 10100010000   ALBANY 360246006624 10100010050 EDMUND J O'NEAL MS OF EXCELLENCE public Regular School No Middle 06 08 2019   grade_8 13.0 82.0 23.0         7.0     6.0   69.0 62.0     17       115     *   131 13 82 23         7     6   69 62     17   115       131
2154968 NY Dutchess   school 3603270 131601060000   ARLINGTON 360327003266 131601060012 LAGRANGE MIDDLE SCHOOL public Regular School No Middle 06 08 2019   grade_8 186.0 41.0 77.0   0.0     9.0     6.0   164.0 155.0     13       119     55   319 186 41 77   0     9     6   164 155     13   119   55   319
2156393 NY Erie   school 3605850 140600010000   BUFFALO 360585000339 140600010043 LOVEJOY DISCOVERY SCHOOL #43 public Regular School No Elementary PK 08 2019   grade_8 17.0 18.0 12.0         0.0     6.0   31.0 22.0     *       45     8   53 17 18 12         0     6   31 22         45   8   53
2156773 NY Erie   school 3605850 140600010000   BUFFALO 360585000297 140600010097 BUFFALO ACADEMY-VIS & PERF ARTS public Regular School No High 05 12 2019   grade_8 18.0 60.0 10.0   1.0     0.0     6.0   35.0 60.0     0       60     19   95 18 60 10   1     0     6   35 60     0   60   19   95
2157020 NY Erie   school 3605850 140600010000   BUFFALO 360585003481 140600010129 PFC WILLIAM J GRABIARZ #79 public Regular School No Elementary PK 08 2019   grade_8 10.0 15.0 15.0   0.0     4.0     6.0   27.0 23.0     9       39     8   50 10 15 15   0     4     6   27 23     9   39   8   50
2162682 NY Kings   school 3600091 331300010000   NYC GEOG DIST #13 - BROOKLYN 360009102064 331300010008 PS 8 ROBERT FULTON public Regular School No Elementary KG 08 2019   grade_8 48.0 21.0 13.0   0.0     2.0     6.0   41.0 49.0     *       26     12   90 48 21 13   0     2     6   41 49         26   12   90
2165304 NY Kings   school 3600092 331500010000   NYC GEOG DIST #15 - BROOKLYN 360009204890 331500011497 BOERUM HILL SCHOOL FOR INTERNATIONAL public Regular School No High 06 12 2019   grade_8 43.0 32.0 20.0   2.0     3.0     6.0   65.0 41.0     6       46     30   106 43 32 20   2     3     6   65 41     6   46   30   106
2169750 NY Kings   school 3600151 332000010000   NYC GEOG DIST #20 - BROOKLYN 360015102775 332000010259 JHS 259 WILLIAM MCKINLEY public Regular School No Middle 06 08 2019   grade_8 213.0 4.0 120.0   1.0     275.0     6.0   346.0 273.0     62       490     74   619 213 4 120   1     275     6   346 273     62   490   74   619
2174443 NY Monroe   school 3612630 260501060000   GREECE 361263001039 260501060008 OLYMPIA HIGH SCHOOL public Regular School No High 06 12 2019   grade_8 67.0 25.0 27.0   0.0     4.0     6.0   58.0 71.0     8       *     *   129 67 25 27   0     4     6   58 71     8           129
2178718 NY Nassau   school 3617160 280205030000   LEVITTOWN 361716001532 280205030010 WISDOM LANE MIDDLE SCHOOL public Regular School No Middle 06 08 2019   grade_8 150.0 3.0 49.0         37.0     6.0   129.0 116.0     *       59     28   245 150 3 49         37     6   129 116         59   28   245
2180846 NY Nassau   school 3630660 280227030000   WEST HEMPSTEAD 363066000501 280227030004 WEST HEMPSTEAD MIDDLE SCHOOL public Regular School No Middle 07 08 2019   grade_8 34.0 36.0 59.0   1.0     10.0     6.0   72.0 74.0     8       71     23   146 34 36 59   1     10     6   72 74     8   71   23   146
2185843 NY New York   school 3600077 310200010000   NYC GEOG DIST # 2 - MANHATTAN 360007702468 310200010126 PS 126 JACOB AUGUST RIIS public Regular School No Elementary PK 08 2019   grade_8 16.0 3.0 13.0   0.0     70.0     6.0   64.0 44.0     *       60     21   108 16 3 13   0     70     6   64 44         60   21   108
2186337 NY New York   school 3600077 310200010000   NYC GEOG DIST # 2 - MANHATTAN 360007706130 310200010397 SPRUCE STREET SCHOOL public Regular School No Elementary PK 08 2019   grade_8 18.0 3.0 19.0   0.0     15.0     6.0   38.0 23.0     *       23     15   61 18 3 19   0     15     6   38 23         23   15   61
2197091 NY Orange   school 3619320 441000010000   MIDDLETOWN 361932001765 441000010010 MIDDLETOWN TWIN TOWERS MIDDLE SCH public Regular School No Middle 06 08 2019   grade_8 35.0 77.0 182.0   0.0     9.0     6.0   150.0 159.0     26       *     47   309 35 77 182   0     9     6   150 159     26       47   309
2199751 NY Putnam   school 3605310 480601060000   BREWSTER 360531000266 480601060005 HENRY H WELLS MIDDLE SCHOOL public Regular School No Middle 06 08 2019   grade_8 130.0 7.0 78.0   0.0     6.0     6.0   116.0 111.0     14       *     33   227 130 7 78   0     6     6   116 111     14       33   227
2201879 NY Queens   school 3600099 342600010000   NYC GEOG DIST #26 - QUEENS 360009902301 342600010074 JHS 74 NATHANIEL HAWTHORNE public Regular School No Middle 06 08 2019   grade_8 72.0 16.0 39.0   0.0     242.0     6.0   191.0 184.0     29       186     47   375 72 16 39   0     242     6   191 184     29   186   47   375
2205964 NY Queens   school 3600102 343000010000   NYC GEOG DIST #30 - QUEENS 360010202514 343000010141 IS 141 STEINWAY (THE) public Regular School No Middle 06 08 2019   grade_8 154.0 18.0 124.0   3.0     78.0     6.0   204.0 179.0     25       224     *   383 154 18 124   3     78     6   204 179     25   224       383
2211987 NY Schenectady   school 3620880 530301060000   NISKAYUNA 362088000304 530301060006 VAN ANTWERP MIDDLE SCHOOL public Regular School No Middle 06 08 2019   grade_8 110.0 7.0 6.0   0.0     22.0     6.0   76.0 75.0     *       21     19   151 110 7 6   0     22     6   76 75         21   19   151
2212443 NY Schenectady   school 3626010 530600010000   SCHENECTADY 362601006573 530600010035 ONEIDA MIDDLE SCHOOL public Regular School No Middle 06 08 2019   grade_8 49.0 76.0 57.0         32.0     6.0   121.0 99.0     10       177     54   220 49 76 57         32     6   121 99     10   177   54   220
2214191 NY Suffolk   school 3608310 580105030000   COPIAGUE 360831000610 580105030006 COPIAGUE MIDDLE SCHOOL public Regular School No Middle 06 08 2019   grade_8 40.0 91.0 231.0         8.0     6.0   201.0 175.0     48       *     57   376 40 91 231         8     6   201 175     48       57   376
2214400 NY Suffolk   school 3608880 580107030000   DEER PARK 360888004716 580107030009 ROBERT FROST MIDDLE SCHOOL public Regular School No Middle 06 08 2019   grade_8 123.0 60.0 78.0   1.0     34.0     6.0   167.0 135.0     17       161     36   302 123 60 78   1     34     6   167 135     17   161   36   302
2217877 NY Suffolk   school 3625920 580504030000   SAYVILLE 362592003558 580504030005 SAYVILLE MIDDLE SCHOOL public Regular School No Middle 06 08 2019   grade_8 206.0 2.0 19.0         7.0     6.0   127.0 113.0     *       *     25   240 206 2 19         7     6   127 113             25   240
2218371 NY Suffolk   school 3630690 580509030000   WEST ISLIP 363069004126 580509030010 BEACH STREET MIDDLE SCHOOL public Regular School No Middle 06 08 2019   grade_8 157.0 0.0 19.0   0.0     3.0     6.0   88.0 97.0             33     37   185 157 0 19   0     3     6   88 97         33   37   185
2222456 NY Warren   school 3624030 630902030000   QUEENSBURY 362403003317 630902030003 QUEENSBURY MIDDLE SCHOOL public Regular School No Middle 06 08 2019   grade_8 231.0 5.0 3.0         3.0     6.0   135.0 113.0             93     43   248 231 5 3         3     6   135 113         93   43   248
2223064 NY Wayne   school 3620640 650101060000   NEWARK 362064002894 650101060005 NEWARK MIDDLE SCHOOL public Regular School No Middle 06 08 2019   grade_8 103.0 9.0 30.0               6.0   84.0 64.0     *       87     24   148 103 9 30               6   84 64         87   24   148
2223520 NY Wayne   school 3631440 651402040000   WILLIAMSON 363144004204 651402040001 WILLIAMSON MIDDLE SCHOOL public Regular School No Middle 05 08 2019   grade_8 54.0 2.0 8.0         1.0     6.0   37.0 34.0     *       38     10   71 54 2 8         1     6   37 34         38   10   71
2223938 NY Westchester   school 3608580 660202030000   CROTON HARMON 360858000660 660202030002 PIERRE VAN CORTLANDT SCHOOL public Regular School No Middle 05 08 2019   grade_8 62.0 3.0 23.0         4.0     6.0   55.0 43.0     5       8     21   98 62 3 23         4     6   55 43     5   8   21   98
2224489 NY Westchester   school 3609120 660403030000   DOBBS FERRY 360912004681 660403030003 DOBBS FERRY MIDDLE SCHOOL public Regular School No Middle 06 08 2019   grade_8 78.0 3.0 26.0         13.0     6.0   55.0 71.0     *       19     *   126 78 3 26         13     6   55 71         19       126

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