Data source: Big Local News · About: Big Local

4,722 rows where grade = "grade_8", state = "NY" and year = 2018 sorted by total_int descending

View and edit SQL

year

  • 2018 · 4,722

grade

  • grade_8 · 4,722
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 ▲
2110451 NY Queens   school 3600098 342400010000   NYC GEOG DIST #24 - QUEENS 360009802300 342400010073 IS 73 FRANK SANSIVIERI INTER SCHOOL public Regular School No Middle 06 08 2018   grade_8 89.0 10.0 429.0   0.0     237.0     2.0   422.0 345.0     *       563     138   767 89 10 429   0     237     2   422 345         563   138   767
2110394 NY Queens   school 3600098 342400010000   NYC GEOG DIST #24 - QUEENS 360009802263 342400010061 IS 61 LEONARDO DA VINCI public Regular School No Middle 06 08 2018   grade_8 14.0 13.0 622.0   4.0     50.0     0.0   369.0 334.0     182       671     141   703 14 13 622   4     50     0   369 334     182   671   141   703
2126031 NY Suffolk   school 3619230 580212060000   LONGWOOD 361923001754 580212060006 LONGWOOD JUNIOR HIGH SCHOOL public Regular School No Middle 07 08 2018   grade_8 342.0 116.0 188.0   0.0     19.0     32.0   357.0 340.0     *       365     107   697 342 116 188   0     19     32   357 340         365   107   697
2081495 NY Kings   school 3600153 332200010000   NYC GEOG DIST #22 - BROOKLYN 360015302748 332200010234 JHS 234 ARTHUR W CUNNINGHAM public Regular School No Middle 06 08 2018   grade_8 330.0 104.0 74.0   6.0     169.0     2.0   346.0 339.0     62       450     81   685 330 104 74   6     169     2   346 339     62   450   81   685
2119457 NY Rockland   school 3620340 500101060000   CLARKSTOWN 362034005897 500101060022 FELIX FESTA DETERMINATION MIDDLE SCH public Regular School No Middle 08 08 2018   grade_8 430.0 24.0 107.0   1.0     107.0     8.0   384.0 293.0     12       *     133   677 430 24 107   1     107     8   384 293     12       133   677
2104390 NY Onondaga   school 3621210 420303060000   NORTH SYRACUSE 362121003001 420303060010 NORTH SYRACUSE JUNIOR HIGH SCHOOL public Regular School No Secondary 08 09 2018   grade_8 536.0 30.0 47.0   3.0     14.0     46.0   353.0 323.0     *       266     73   676 536 30 47   3     14     46   353 323         266   73   676
2113263 NY Queens   school 3600123 342700010000   NYC GEOG DIST #27 - QUEENS 360012305269 342700010137 MS 137 AMERICA'S SCHOOL-HEROES public Regular School No Middle 06 08 2018   grade_8 12.0 29.0 203.0   26.0     370.0     3.0   351.0 292.0     65       556     96   643 12 29 203   26     370     3   351 292     65   556   96   643
2119742 NY Rockland   school 3614010 500201060000   HAVERSTRAW-STONY POINT 361401005738 500201060013 FIELDSTONE MIDDLE SCHOOL public Regular School No Middle 07 08 2018   grade_8 172.0 92.0 342.0   0.0     26.0     0.0   335.0 297.0     53       362     83   632 172 92 342   0     26     0   335 297     53   362   83   632
2113396 NY Queens   school 3600123 342700010000   NYC GEOG DIST #27 - QUEENS 360012302704 342700010210 JHS 210 ELIZABETH BLACKWELL public Regular School No Middle 06 08 2018   grade_8 16.0 43.0 372.0   17.0     178.0     1.0   328.0 299.0     87       526     99   627 16 43 372   17     178     1   328 299     87   526   99   627
2110204 NY Queens   school 3600098 342400010000   NYC GEOG DIST #24 - QUEENS 360009803117 342400010005 IS 5 WALTER CROWLEY INTERMEDIATE public Regular School No Middle 06 08 2018   grade_8 18.0 11.0 302.0   0.0     288.0     3.0   309.0 313.0     92       488     97   622 18 11 302   0     288     3   309 313     92   488   97   622
2116379 NY Queens   school 3600102 343000010000   NYC GEOG DIST #30 - QUEENS 360010202527 343000010145 IS 145 JOSEPH PULITZER public Regular School No Middle 06 08 2018   grade_8 8.0 8.0 514.0   3.0     44.0     1.0   304.0 274.0     *       553     103   578 8 8 514   3     44     1   304 274         553   103   578
2080070 NY Kings   school 3600151 332000010000   NYC GEOG DIST #20 - BROOKLYN 360015102775 332000010259 JHS 259 WILLIAM MCKINLEY public Regular School No Middle 06 08 2018   grade_8 191.0 12.0 117.0   0.0     254.0     2.0   299.0 277.0     61       460     72   576 191 12 117   0     254     2   299 277     61   460   72   576
2137754 NY Westchester   school 3631260 662200010000   WHITE PLAINS 363126004177 662200010012 WHITE PLAINS MIDDLE SCHOOL public Regular School No Middle 06 08 2018   grade_8 120.0 76.0 354.0         18.0     8.0   256.0 320.0     53       342     81   576 120 76 354         18     8   256 320     53   342   81   576
2107772 NY Orange   school 3619650 441201060000   MONROE WOODBURY 361965001794 441201060009 MONROE-WOODBURY MIDDLE SCHOOL public Regular School No Middle 06 08 2018   grade_8 348.0 43.0 119.0   0.0     48.0     7.0   284.0 281.0     *       134     70   565 348 43 119   0     48     7   284 281         134   70   565
2093959 NY Nassau   school 3618630 280523030000   MASSAPEQUA 361863001682 280523030010 BERNER MIDDLE SCHOOL public Regular School No Middle 06 08 2018   grade_8 522.0 1.0 17.0   0.0     14.0     5.0   265.0 294.0     *       *     62   559 522 1 17   0     14     5   265 294             62   559
2114612 NY Queens   school 3600100 342800010000   NYC GEOG DIST #28 - QUEENS 360010002718 342800010217 JHS 217 ROBERT A VAN WYCK public Regular School No Middle 06 08 2018   grade_8 14.0 86.0 229.0   11.0     215.0     3.0   304.0 254.0     99       388     *   558 14 86 229   11     215     3   304 254     99   388       558
2110679 NY Queens   school 3600098 342400010000   NYC GEOG DIST #24 - QUEENS 360009802464 342400010125 IS 125 THOMAS J MCCANN WOODSIDE public Regular School No Middle 06 08 2018   grade_8 30.0 7.0 270.0   4.0     228.0     0.0   280.0 259.0     *       420     89   539 30 7 270   4     228     0   280 259         420   89   539
2111667 NY Queens   school 3600122 342500010000   NYC GEOG DIST #25 - QUEENS 360012202639 342500010185 JHS 185 EDWARD BLEEKER public Regular School No Middle 06 08 2018   grade_8 60.0 17.0 148.0   1.0     304.0     2.0   265.0 267.0     68       410     75   532 60 17 148   1     304     2   265 267     68   410   75   532
2127646 NY Suffolk   school 3608130 580410030000   COMMACK 360813000581 580410030019 COMMACK MIDDLE SCHOOL public Regular School No Middle 06 08 2018   grade_8 417.0 8.0 32.0   0.0     56.0     19.0   296.0 236.0     5       69     100   532 417 8 32   0     56     19   296 236     5   69   100   532
2114441 NY Queens   school 3600100 342800010000   NYC GEOG DIST #28 - QUEENS 360010002567 342800010157 JHS 157 STEPHEN A HALSEY public Regular School No Middle 06 09 2018   grade_8 227.0 38.0 120.0   1.0     121.0     18.0   254.0 271.0     49       275     66   525 227 38 120   1     121     18   254 271     49   275   66   525
2079918 NY Kings   school 3600151 332000010000   NYC GEOG DIST #20 - BROOKLYN 360015102682 332000010201 JHS 201 DYKER HEIGHTS (THE) public Regular School No Middle 06 08 2018   grade_8 193.0 2.0 70.0         251.0     7.0   283.0 240.0     *       *     80   523 193 2 70         251     7   283 240             80   523
2079975 NY Kings   school 3600151 332000010000   NYC GEOG DIST #20 - BROOKLYN 360015102724 332000010220 JHS 220 JOHN J PERSHING public Regular School No Middle 06 08 2018   grade_8 20.0 8.0 219.0   0.0     273.0     1.0   272.0 249.0     173       448     78   521 20 8 219   0     273     1   272 249     173   448   78   521
2115600 NY Queens   school 3600101 342900010000   NYC GEOG DIST #29 - QUEENS 360010101997 342900010238 IS 238 SUSAN B ANTHONY ACADEMY public Regular School No Middle 06 08 2018   grade_8 11.0 181.0 145.0   26.0     155.0     2.0   253.0 267.0     100       467     *   520 11 181 145   26     155     2   253 267     100   467       520
2080412 NY Kings   school 3600152 332100010000   NYC GEOG DIST #21 - BROOKLYN 360015203011 332100010098 IS 98 BAY ACADEMY public Regular School No Middle 06 08 2018   grade_8 305.0 11.0 43.0   1.0     128.0     9.0   235.0 262.0     *       273     49   497 305 11 43   1     128     9   235 262         273   49   497
2112617 NY Queens   school 3600099 342600010000   NYC GEOG DIST #26 - QUEENS 360009902716 342600010216 JHS 216 GEORGE J RYAN public Regular School No Middle 06 08 2018   grade_8 66.0 21.0 56.0   3.0     332.0     5.0   246.0 237.0     23       329     *   483 66 21 56   3     332     5   246 237     23   329       483
2089760 NY Nassau   school 3621570 280211030000   OCEANSIDE 362157004528 280211030009 SCHOOL 9M-OCEANSIDE MIDDLE SCHOOL public Regular School No Middle 07 08 2018   grade_8 372.0 7.0 79.0         13.0     4.0   249.0 226.0     9       83     58   475 372 7 79         13     4   249 226     9   83   58   475
2089456 NY Nassau   school 3611550 280209030000   FREEPORT 361155000915 280209030006 JOHN W DODD MIDDLE SCHOOL public Regular School No Middle 07 08 2018   grade_8 31.0 114.0 317.0   2.0     5.0     5.0   249.0 225.0     70       356     87   474 31 114 317   2     5     5   249 225     70   356   87   474
2121908 NY Saratoga   school 3625770 521800010000   SARATOGA SPRINGS 362577000269 521800010015 MAPLE AVENUE MIDDLE SCHOOL public Regular School No Middle 06 08 2018   grade_8 422.0 8.0 15.0         11.0     13.0   232.0 237.0     *       81     53   469 422 8 15         11     13   232 237         81   53   469
2127817 NY Suffolk   school 3627300 580413030000   SOUTH HUNTINGTON 362730003724 580413030013 HENRY L STIMSON MIDDLE SCHOOL public Regular School No Middle 07 08 2018   grade_8 209.0 29.0 185.0   2.0     27.0     15.0   249.0 218.0     56       234     70   467 209 29 185   2     27     15   249 218     56   234   70   467
2093826 NY Nassau   school 3610980 280522030000   FARMINGDALE 361098000878 280522030008 HOWITT SCHOOL public Regular School No Middle 06 08 2018   grade_8 312.0 26.0 93.0   1.0     26.0     6.0   240.0 224.0     12       125     69   464 312 26 93   1     26     6   240 224     12   125   69   464
2065725 NY Dutchess   school 3629880 132101060000   WAPPINGERS 362988004024 132101060009 VAN WYCK JUNIOR HIGH SCHOOL public Regular School No Middle 07 08 2018   grade_8 352.0 21.0 58.0         24.0     8.0   242.0 221.0             *     *   463 352 21 58         24     8   242 221                 463
2074294 NY Kings   school 3600119 331400010000   NYC GEOG DIST #14 - BROOKLYN 360011902816 331400010318 IS 318 EUGENO MARIA DE HOSTOS public Regular School No Middle 06 08 2018   grade_8 52.0 86.0 278.0   2.0     39.0     4.0   217.0 244.0     35       300     84   461 52 86 278   2     39     4   217 244     35   300   84   461
2118868 NY Richmond   school 3600103 353100010000   NYC GEOG DIST #31 - SI 360010301974 353100010072 IS 72 ROCCO LAURIE public Regular School No Middle 06 08 2018   grade_8 210.0 21.0 122.0   2.0     100.0     6.0   259.0 202.0     28       283     104   461 210 21 122   2     100     6   259 202     28   283   104   461
2091546 NY Nassau   school 3619020 280253070000   BELLMORE-MERRICK 361902001722 280253070002 GRAND AVENUE MIDDLE SCHOOL public Regular School No Middle 07 08 2018   grade_8 356.0 8.0 52.0   1.0     35.0     8.0   237.0 223.0     *       63     64   460 356 8 52   1     35     8   237 223         63   64   460
2088411 NY Nassau   school 3614130 280201030000   HEMPSTEAD 361413001153 280201030010 ALVERTA B GRAY SCHULTZ MIDDLE SCH public Regular School No Middle 06 08 2018   grade_8 10.0 114.0 330.0   0.0     4.0     1.0   225.0 234.0     166       411     32   459 10 114 330   0     4     1   225 234     166   411   32   459
2080013 NY Kings   school 3600151 332000010000   NYC GEOG DIST #20 - BROOKLYN 360015102735 332000010227 JHS 227 EDWARD B SHALLOW public Regular School No Middle 06 08 2018   grade_8 64.0 2.0 116.0   1.0     275.0     0.0   245.0 213.0     *       *     *   458 64 2 116   1     275     0   245 213                 458
2116759 NY Queens   school 3600102 343000010000   NYC GEOG DIST #30 - QUEENS 360010203146 343000011227 IS 227 LOUIS ARMSTRONG public Regular School No Middle 05 08 2018   grade_8 114.0 36.0 241.0   4.0     59.0     3.0   219.0 238.0     17       348     66   457 114 36 241   4     59     3   219 238     17   348   66   457
2105055 NY Onondaga   school 3603870 420901060000   BALDWINSVILLE 360387000146 420901060006 THEODORE R DURGEE JUNIOR HIGH SCH public Regular School No Secondary 08 09 2018   grade_8 389.0 12.0 22.0   1.0     5.0     21.0   222.0 228.0             137     66   450 389 12 22   1     5     21   222 228         137   66   450
2069259 NY Erie   school 3616680 141901060000   LANCASTER 361668001482 141901060007 LANCASTER MIDDLE SCHOOL public Regular School No Middle 07 08 2018   grade_8 419.0 4.0 8.0   1.0     12.0     4.0   236.0 212.0     *       112     65   448 419 4 8   1     12     4   236 212         112   65   448
2138647 NY Westchester   school 3616620 662401060000   LAKELAND 361662001472 662401060008 LAKELAND-COPPER BEECH MIDDLE SCH public Regular School No Middle 06 08 2018   grade_8 338.0 20.0 77.0   0.0     10.0     3.0   210.0 238.0     *       101     60   448 338 20 77   0     10     3   210 238         101   60   448
2127437 NY Suffolk   school 3613290 580405060000   HALF HOLLOW HILLS 361329001094 580405060014 WEST HOLLOW MIDDLE SCHOOL public Regular School No Middle 06 08 2018   grade_8 263.0 55.0 39.0   0.0     70.0     16.0   201.0 242.0     6       81     85   443 263 55 39   0     70     16   201 242     6   81   85   443
2050449 NY Albany   school 3621000 10623060000   NORTH COLONIE CSD 362100002986 10623060009 SHAKER JUNIOR HIGH SCHOOL public Regular School No Middle 07 08 2018   grade_8 326.0 25.0 23.0   1.0     51.0     13.0   234.0 205.0     *       96     62   439 326 25 23   1     51     13   234 205         96   62   439
2124454 NY Suffolk   school 3617380 580104030000   LINDENHURST 361738001547 580104030011 LINDENHURST MIDDLE SCHOOL public Regular School No Middle 06 08 2018   grade_8 311.0 8.0 100.0   1.0     13.0     3.0   233.0 203.0     12       *     73   436 311 8 100   1     13     3   233 203     12       73   436
2092116 NY Nassau   school 3623580 280404030000   PORT WASHINGTON 362358003288 280404030008 CARRIE PALMER WEBER MIDDLE SCHOOL public Regular School No Middle 06 08 2018   grade_8 285.0 8.0 67.0   1.0     64.0     8.0   227.0 206.0     20       *     66   433 285 8 67   1     64     8   227 206     20       66   433
2118564 NY Richmond   school 3600103 353100010000   NYC GEOG DIST #31 - SI 360010302057 353100010051 IS 51 EDWIN MARKHAM public Regular School No Middle 06 08 2018   grade_8 115.0 116.0 168.0   2.0     27.0     4.0   216.0 216.0     *       328     126   432 115 116 168   2     27     4   216 216         328   126   432
2080754 NY Kings   school 3600152 332100010000   NYC GEOG DIST #21 - BROOKLYN 360015202754 332100010239 MARK TWAIN IS 239-GIFTED & TALENTED public Regular School No Middle 06 08 2018   grade_8 219.0 26.0 22.0   0.0     126.0     36.0   206.0 223.0     *       140     42   429 219 26 22   0     126     36   206 223         140   42   429
2116607 NY Queens   school 3600102 343000010000   NYC GEOG DIST #30 - QUEENS 360010204802 343000010230 IS 230 public Regular School No Middle 06 08 2018   grade_8 20.0 4.0 269.0   2.0     133.0     1.0   232.0 197.0     *       350     57   429 20 4 269   2     133     1   232 197         350   57   429
2096239 NY New York   school 3600077 310200010000   NYC GEOG DIST # 2 - MANHATTAN 360007702597 310200010167 JHS 167 ROBERT F WAGNER public Regular School No Middle 06 08 2018   grade_8 207.0 24.0 70.0   2.0     108.0     17.0   223.0 205.0     16       152     80   428 207 24 70   2     108     17   223 205     16   152   80   428
2111838 NY Queens   school 3600122 342500010000   NYC GEOG DIST #25 - QUEENS 360012201996 342500010237 IS 237 public Regular School No Middle 06 08 2018   grade_8 8.0 30.0 74.0   1.0     312.0     1.0   213.0 213.0     *       359     55   426 8 30 74   1     312     1   213 213         359   55   426
2118906 NY Richmond   school 3600103 353100010000   NYC GEOG DIST #31 - SI 360010304526 353100010075 IS 75 FRANK D PAULO public Regular School No Middle 06 08 2018   grade_8 327.0 7.0 43.0   3.0     43.0     2.0   229.0 196.0     6       157     92   425 327 7 43   3     43     2   229 196     6   157   92   425
2055503 NY Bronx   school 3600087 321000010000   NYC GEOG DIST #10 - BRONX 360008702440 321000010118 JHS 118 WILLIAM W NILES public Regular School No Middle 06 08 2018   grade_8 15.0 96.0 250.0   2.0     55.0     1.0   201.0 218.0     48       368     88   419 15 96 250   2     55     1   201 218     48   368   88   419
2080716 NY Kings   school 3600152 332100010000   NYC GEOG DIST #21 - BROOKLYN 360015202736 332100010228 IS 228 DAVID A BOODY public Regular School No Middle 06 08 2018   grade_8 170.0 21.0 96.0   2.0     127.0     1.0   195.0 222.0     34       343     61   417 170 21 96   2     127     1   195 222     34   343   61   417
2127950 NY Suffolk   school 3604080 580501030000   BAY SHORE 360408000165 580501030007 BAY SHORE MIDDLE SCHOOL public Regular School No Middle 06 08 2018   grade_8 141.0 83.0 174.0   0.0     15.0     4.0   212.0 205.0     22       234     72   417 141 83 174   0     15     4   212 205     22   234   72   417
2129413 NY Suffolk   school 3624690 580602040000   RIVERHEAD 362469003358 580602040006 RIVERHEAD MIDDLE SCHOOL public Regular School No Middle 05 08 2018   grade_8 173.0 50.0 183.0   2.0     3.0     2.0   218.0 195.0     77       253     56   413 173 50 183   2     3     2   218 195     77   253   56   413
2062286 NY Chemung   school 3610560 70600010000   ELMIRA 361056000814 70600010021 ERNIE DAVIS ACADEMY public Regular School No Secondary 08 09 2018   grade_8 296.0 71.0 13.0         4.0     27.0   222.0 189.0     *       278     *   411 296 71 13         4     27   222 189         278       411
2112294 NY Queens   school 3600099 342600010000   NYC GEOG DIST #26 - QUEENS 360009902301 342600010074 JHS 74 NATHANIEL HAWTHORNE public Regular School No Middle 06 08 2018   grade_8 61.0 25.0 43.0   0.0     278.0     4.0   204.0 207.0     34       198     53   411 61 25 43   0     278     4   204 207     34   198   53   411
2080792 NY Kings   school 3600152 332100010000   NYC GEOG DIST #21 - BROOKLYN 360015202792 332100010281 IS 281 JOSEPH B CAVALLARO public Regular School No Middle 06 08 2018   grade_8 113.0 25.0 93.0   0.0     175.0     2.0   235.0 173.0     61       *     *   408 113 25 93   0     175     2   235 173     61           408
2125233 NY Suffolk   school 3625350 580205060000   SACHEM 362535003509 580205060011 SENECA MIDDLE SCHOOL public Regular School No Middle 06 08 2018   grade_8 334.0 11.0 33.0   1.0     21.0     4.0   187.0 217.0     *       76     78   404 334 11 33   1     21     4   187 217         76   78   404
2075016 NY Kings   school 3600092 331500010000   NYC GEOG DIST #15 - BROOKLYN 360009204474 331500010088 JHS 88 PETER ROUGET public Regular School No Middle 06 08 2018   grade_8 54.0 37.0 223.0   1.0     83.0     3.0   233.0 168.0     25       324     108   401 54 37 223   1     83     3   233 168     25   324   108   401
2093522 NY Nassau   school 3614340 280517030000   HICKSVILLE 361434001186 280517030011 HICKSVILLE MIDDLE SCHOOL public Regular School No Middle 06 08 2018   grade_8 147.0 9.0 119.0   0.0     122.0     3.0   211.0 189.0     27       181     43   400 147 9 119   0     122     3   211 189     27   181   43   400
2135550 NY Westchester   school 3618240 660701030000   MAMARONECK 361824001646 660701030005 HOMMOCKS SCHOOL public Regular School No Middle 06 08 2018   grade_8 307.0 9.0 61.0   1.0     15.0     6.0   204.0 195.0     10       68     52   399 307 9 61   1     15     6   204 195     10   68   52   399
2136519 NY Westchester   school 3620490 661100010000   NEW ROCHELLE 362049001892 661100010013 ALBERT LEONARD MIDDLE SCHOOL public Regular School No Middle 06 08 2018   grade_8 167.0 89.0 112.0   0.0     27.0     2.0   195.0 202.0     19       136     41   397 167 89 112   0     27     2   195 202     19   136   41   397
2111724 NY Queens   school 3600122 342500010000   NYC GEOG DIST #25 - QUEENS 360012202664 342500010194 JHS 194 WILLIAM CARR public Regular School No Middle 06 08 2018   grade_8 115.0 4.0 126.0   1.0     146.0     1.0   207.0 186.0     *       *     *   393 115 4 126   1     146     1   207 186                 393
2117918 NY Richmond   school 3600103 353100010000   NYC GEOG DIST #31 - SI 360010301966 353100010007 IS 7 ELIAS BERNSTEIN public Regular School No Middle 06 08 2018   grade_8 340.0 3.0 25.0   2.0     20.0     3.0   191.0 202.0     *       144     68   393 340 3 25   2     20     3   191 202         144   68   393
2050601 NY Albany   school 3613080 10802060000   GUILDERLAND 361308001071 10802060008 FARNSWORTH MIDDLE SCHOOL public Regular School No Middle 06 08 2018   grade_8 297.0 8.0 10.0   0.0     58.0     18.0   190.0 201.0     *       65     57   391 297 8 10   0     58     18   190 201         65   57   391
2137545 NY Westchester   school 3625950 662001030000   SCARSDALE 362595003565 662001030011 SCARSDALE MIDDLE SCHOOL public Regular School No Middle 06 08 2018   grade_8 267.0 7.0 28.0         70.0     19.0   213.0 178.0     *             40   391 267 7 28         70     19   213 178             40   391
2079557 NY Kings   school 3600151 332000010000   NYC GEOG DIST #20 - BROOKLYN 360015102266 332000010062 JHS 62 DITMAS public Regular School No Middle 06 08 2018   grade_8 54.0 91.0 117.0   2.0     125.0     1.0   190.0 200.0     81       *     *   390 54 91 117   2     125     1   190 200     81           390
2091565 NY Nassau   school 3619020 280253070000   BELLMORE-MERRICK 361902001726 280253070004 MERRICK AVENUE MIDDLE SCHOOL public Regular School No Middle 07 08 2018   grade_8 321.0 8.0 35.0   1.0     21.0     3.0   201.0 188.0     *       41     69   389 321 8 35   1     21     3   201 188         41   69   389
2129052 NY Suffolk   school 3605280 580512030000   BRENTWOOD 360528000248 580512030020 EAST MIDDLE SCHOOL public Regular School No Middle 06 08 2018   grade_8 14.0 43.0 324.0   2.0     6.0     0.0   208.0 181.0     91       361     60   389 14 43 324   2     6     0   208 181     91   361   60   389
2085599 NY Monroe   school 3614460 261101060000   HILTON 361446001200 261101060005 MERTON WILLIAMS MIDDLE SCHOOL public Regular School No Middle 07 08 2018   grade_8 360.0 6.0 13.0   0.0     1.0     8.0   187.0 201.0     *       104     46   388 360 6 13   0     1     8   187 201         104   46   388
2069430 NY Erie   school 3621900 142301060000   ORCHARD PARK 362190003111 142301060002 ORCHARD PARK MIDDLE SCHOOL public Regular School No Middle 06 08 2018   grade_8 368.0 7.0 5.0   1.0     6.0     0.0   196.0 191.0     *       51     58   387 368 7 5   1     6     0   196 191         51   58   387
2096030 NY New York   school 3600077 310200010000   NYC GEOG DIST # 2 - MANHATTAN 360007704447 310200010104 JHS 104 SIMON BARUCH public Regular School No Middle 06 08 2018   grade_8 125.0 31.0 82.0   2.0     134.0     13.0   224.0 163.0     9       184     79   387 125 31 82   2     134     13   224 163     9   184   79   387
2124207 NY Suffolk   school 3620910 580103030000   NORTH BABYLON 362091004737 580103030002 ROBERT MOSES MIDDLE SCHOOL public Regular School No Middle 06 08 2018   grade_8 154.0 107.0 104.0   0.0     17.0     4.0   201.0 185.0     15       168     60   386 154 107 104   0     17     4   201 185     15   168   60   386
2136538 NY Westchester   school 3620490 661100010000   NEW ROCHELLE 362049001897 661100010014 ISAAC E YOUNG MIDDLE SCHOOL public Regular School No Middle 06 08 2018   grade_8 49.0 76.0 242.0         17.0         197.0 187.0     *       269     58   384 49 76 242         17         197 187         269   58   384
2065345 NY Dutchess   school 3603270 131601060000   ARLINGTON 360327005597 131601060015 UNION VALE MIDDLE SCHOOL public Regular School No Middle 06 08 2018   grade_8 300.0 15.0 33.0         20.0     15.0   188.0 195.0     *       56     47   383 300 15 33         20     15   188 195         56   47   383
2118165 NY Richmond   school 3600103 353100010000   NYC GEOG DIST #31 - SI 360010302120 353100010024 IS 24 MYRA S BARNES public Regular School No Middle 06 08 2018   grade_8 312.0 0.0 51.0   1.0     18.0     1.0   211.0 172.0     *       *     *   383 312 0 51   1     18     1   211 172                 383
2068366 NY Erie   school 3607590 140801060000   CLARENCE 360759000542 140801060008 CLARENCE MIDDLE SCHOOL public Regular School No Middle 06 08 2018   grade_8 345.0 3.0 6.0   2.0     16.0     9.0   199.0 182.0     *       48     57   381 345 3 6   2     16     9   199 182         48   57   381
2120122 NY Rockland   school 3628320 500401060000   SUFFERN 362832003817 500401060011 SUFFERN MIDDLE SCHOOL public Regular School No Middle 06 08 2018   grade_8 246.0 27.0 78.0   1.0     19.0     10.0   195.0 186.0     16       110     77   381 246 27 78   1     19     10   195 186     16   110   77   381
2112389 NY Queens   school 3600099 342600010000   NYC GEOG DIST #26 - QUEENS 360009902568 342600010158 MS 158 MARIE CURIE public Regular School No Middle 06 08 2018   grade_8 62.0 23.0 60.0   0.0     234.0     1.0   204.0 176.0     31       211     48   380 62 23 60   0     234     1   204 176     31   211   48   380
2129014 NY Suffolk   school 3605280 580512030000   BRENTWOOD 360528000254 580512030016 NORTH MIDDLE SCHOOL public Regular School No Middle 06 08 2018   grade_8 11.0 38.0 323.0         7.0     0.0   176.0 203.0     79       336     40   379 11 38 323         7     0   176 203     79   336   40   379
2118317 NY Richmond   school 3600103 353100010000   NYC GEOG DIST #31 - SI 360010301970 353100010034 IS 34 TOTTENVILLE public Regular School No Middle 06 08 2018   grade_8 324.0 1.0 36.0   3.0     13.0     0.0   195.0 182.0     7       120     106   377 324 1 36   3     13     0   195 182     7   120   106   377
2065744 NY Dutchess   school 3629880 132101060000   WAPPINGERS 362988004026 132101060010 WAPPINGERS JUNIOR HIGH SCHOOL public Regular School No Middle 07 08 2018   grade_8 246.0 34.0 68.0         19.0     8.0   204.0 171.0     6       *     50   375 246 34 68         19     8   204 171     6       50   375
2069012 NY Erie   school 3611670 141604060000   FRONTIER 361167000920 141604060007 FRONTIER MIDDLE SCHOOL public Regular School No Middle 06 08 2018   grade_8 335.0 4.0 15.0   1.0     4.0     15.0   197.0 177.0     *       127     73   374 335 4 15   1     4     15   197 177         127   73   374
2110584 NY Queens   school 3600098 342400010000   NYC GEOG DIST #24 - QUEENS 360009802355 342400010093 IS 93 RIDGEWOOD public Regular School No Middle 06 08 2018   grade_8 64.0 6.0 261.0   1.0     41.0     0.0   202.0 171.0     56       354     87   373 64 6 261   1     41     0   202 171     56   354   87   373
2113358 NY Queens   school 3600123 342700010000   NYC GEOG DIST #27 - QUEENS 360012302685 342700010202 JHS 202 ROBERT H GODDARD public Regular School No Middle 06 08 2018   grade_8 33.0 26.0 169.0   16.0     128.0     1.0   189.0 184.0     31       297     *   373 33 26 169   16     128     1   189 184     31   297       373
2103269 NY Oneida   school 3624900 411800010000   ROME 362490003446 411800010010 LYNDON H STROUGH MIDDLE SCHOOL public Regular School No Middle 07 08 2018   grade_8 304.0 34.0 24.0         4.0     3.0   187.0 182.0     *       233     86   369 304 34 24         4     3   187 182         233   86   369
2049936 NY Albany   school 3604710 10306060000   BETHLEHEM 360471000210 10306060007 BETHLEHEM CENTRAL MIDDLE SCHOOL public Regular School No Middle 06 08 2018   grade_8 323.0 5.0 11.0         25.0     4.0   169.0 199.0     *       50     38   368 323 5 11         25     4   169 199         50   38   368
2125784 NY Suffolk   school 3619200 580211060000   MIDDLE COUNTRY 361920001737 580211060009 DAWNWOOD MIDDLE SCHOOL public Regular School No Middle 06 08 2018   grade_8 250.0 15.0 71.0         31.0     1.0   198.0 170.0     26       145     60   368 250 15 71         31     1   198 170     26   145   60   368
2074978 NY Kings   school 3600092 331500010000   NYC GEOG DIST #15 - BROOKLYN 360009202226 331500010051 MS 51 WILLIAM ALEXANDER public Regular School No Middle 06 08 2018   grade_8 185.0 32.0 80.0   0.0     55.0     15.0   157.0 210.0     6       *     *   367 185 32 80   0     55     15   157 210     6           367
2127095 NY Suffolk   school 3615090 580403030000   HUNTINGTON 361509001260 580403030014 J TAYLOR FINLEY MIDDLE SCHOOL public Regular School No Middle 07 08 2018   grade_8 159.0 27.0 168.0         6.0     6.0   197.0 169.0     *       195     59   366 159 27 168         6     6   197 169         195   59   366
2136766 NY Westchester   school 3622020 661401030000   OSSINING 362202003118 661401030006 ANNE M DORNER MIDDLE SCHOOL public Regular School No Middle 06 08 2018   grade_8 92.0 44.0 198.0   1.0     20.0     9.0   191.0 173.0     26       *     57   364 92 44 198   1     20     9   191 173     26       57   364
2126373 NY Suffolk   school 3618690 580232030000   WILLIAM FLOYD 361869005579 580232030010 WILLIAM FLOYD MIDDLE SCHOOL public Regular School No Middle 06 08 2018   grade_8 186.0 47.0 108.0   0.0     15.0     7.0   189.0 174.0     19       229     35   363 186 47 108   0     15     7   189 174     19   229   35   363
2091831 NY Nassau   school 3630960 280401030000   WESTBURY 363096004161 280401030006 WESTBURY MIDDLE SCHOOL public Regular School No Middle 06 08 2018   grade_8 5.0 85.0 269.0   0.0     2.0     1.0   184.0 178.0     84       306     46   362 5 85 269   0     2     1   184 178     84   306   46   362
2109995 NY Putnam   school 3606570 480102060000   CARMEL 360657000439 480102060007 GEORGE FISCHER MIDDLE SCHOOL public Regular School No Middle 05 08 2018   grade_8 240.0 14.0 83.0   1.0     15.0     8.0   183.0 178.0     *       113     48   361 240 14 83   1     15     8   183 178         113   48   361
2125822 NY Suffolk   school 3619200 580211060000   MIDDLE COUNTRY 361920001745 580211060011 SELDEN MIDDLE SCHOOL public Regular School No Middle 06 08 2018   grade_8 250.0 21.0 65.0         22.0     2.0   197.0 163.0             150     58   360 250 21 65         22     2   197 163         150   58   360
2125214 NY Suffolk   school 3625350 580205060000   SACHEM 362535003507 580205060007 SAGAMORE MIDDLE SCHOOL public Regular School No Middle 06 08 2018   grade_8 250.0 17.0 64.0         23.0     4.0   173.0 185.0     19       *     44   358 250 17 64         23     4   173 185     19       44   358
2134201 NY Westchester   school 3619950 660102060000   BEDFORD 361995001823 660102060005 FOX LANE MIDDLE SCHOOL public Regular School No Middle 06 08 2018   grade_8 209.0 8.0 109.0         10.0     19.0   192.0 163.0     38       117     43   355 209 8 109         10     19   192 163     38   117   43   355
2115296 NY Queens   school 3600101 342900010000   NYC GEOG DIST #29 - QUEENS 360010102409 342900010109 JEAN NUZZI INTERMEDIATE SCHOOL public Regular School No Middle 06 08 2018   grade_8 11.0 140.0 70.0   9.0     121.0     1.0   189.0 163.0     31       239     50   352 11 140 70   9     121     1   189 163     31   239   50   352
2088753 NY Nassau   school 3609840 280203030000   EAST MEADOW 360984000762 280203030009 WOODLAND MIDDLE SCHOOL public Regular School No Middle 06 08 2018   grade_8 202.0 17.0 54.0   2.0     75.0     1.0   191.0 160.0     *       100     42   351 202 17 54   2     75     1   191 160         100   42   351
2137355 NY Westchester   school 3623460 661904030000   PORT CHESTER-RYE 362346003277 661904030010 PORT CHESTER MIDDLE SCHOOL public Regular School No Middle 06 08 2018   grade_8 47.0 13.0 282.0   0.0     6.0     0.0   187.0 161.0     *       261     35   348 47 13 282   0     6     0   187 161         261   35   348

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