Data source: Big Local News · About: Big Local

4,719 rows where grade = "grade_8", state = "NY" and year = 2019 sorted by low_income_int 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
2191619 NY Niagara   school 3620760 400601060000   NEWFANE 362076001415 400601060001 NEWFANE EARLY CHLDHD CTR public Regular School No Prekindergarten PK PK 2019   grade_8 0.0                   0.0   0.0 0.0                   *   0 0                   0   0 0                 0
2207009 NY Rensselaer   school 3631410 490801080000   NO GREENBUSH COM 363141004203 490801080001 NORTH GREENBUSH SCHOOL public Regular School No Elementary KG 01 2019   grade_8 0.0 0.0 0.0         0.0         0.0 0.0     *             *   0 0 0 0         0         0 0                 0
2216376 NY Suffolk   school 3602880 580303020000   AMAGANSETT 360288000059 580303020001 AMAGANSETT SCHOOL public Regular School No Elementary PK 06 2019   grade_8 0.0 0.0 0.0               0.0   0.0 0.0     0                 0 0 0 0               0   0 0     0           0
2216452 NY Suffolk   school 3619710 580306020000   MONTAUK 361971001805 580306020001 MONTAUK SCHOOL public Regular School No Elementary PK 08 2019   grade_8 26.0 1.0 5.0         0.0     0.0   19.0 13.0     *             5   32 26 1 5         0     0   19 13             5   32
2218903 NY Suffolk   school 3621540 580514020000   FIRE ISLAND 362154003056 580514020001 WOODHULL SCHOOL public Regular School No Elementary PK 06 2019   grade_8 0.0 0.0 0.0         0.0         0.0 0.0     *             *   0 0 0 0         0         0 0                 0
2219739 NY Suffolk   school 3625410 580910080000   SAGAPONACK 362541003516 580910080001 SAGAPONACK SCHOOL public Regular School No Elementary KG 03 2019   grade_8 0.0   0.0                   0.0 0.0                       0 0   0                   0 0                 0
2219910 NY Suffolk   school 3611100 581004020000   FISHERS ISLAND 361110000884 581004020001 FISHERS ISLAND SCHOOL public Regular School No Other PK 12 2019   grade_8 2.0 0.0 0.0               0.0   0.0 2.0                   0   2 2 0 0               0   0 2             0   2
2220043 NY Suffolk   school 3620520 581015080000   NEW SUFFOLK 362052001905 581015080001 NEW SUFFOLK SCHOOL public Regular School No Elementary PK 06 2019   grade_8 0.0   0.0                   0.0 0.0     *             *   0 0   0                   0 0                 0
2224641 NY Westchester   school 3610200 660406030000   EDGEMONT 361020004508 660406030002 SEELY PLACE SCHOOL public Regular School No Elementary KG 06 2019   grade_8 0.0 0.0 0.0         0.0     0.0   0.0 0.0     0             0   0 0 0 0         0     0   0 0     0       0   0
2226769 NY Westchester   school 3625260 661800010000   RYE 362526003490 661800010002 MILTON SCHOOL public Regular School No Elementary KG 05 2019   grade_8 0.0   0.0   0.0     0.0     0.0   0.0 0.0     0             0   0 0   0   0     0     0   0 0     0       0   0
2227092 NY Westchester   school 3625950 662001030000   SCARSDALE 362595003560 662001030001 EDGEWOOD SCHOOL public Regular School No Elementary KG 05 2019   grade_8 0.0 0.0 0.0         0.0     0.0   0.0 0.0     0             0   0 0 0 0         0     0   0 0     0       0   0
2227111 NY Westchester   school 3625950 662001030000   SCARSDALE 362595003561 662001030002 FOX MEADOW SCHOOL public Regular School No Elementary KG 05 2019   grade_8 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0     0             0   0 0 0 0   0     0     0   0 0     0       0   0
2227130 NY Westchester   school 3625950 662001030000   SCARSDALE 362595003562 662001030003 GREENACRES SCHOOL public Regular School No Elementary KG 05 2019   grade_8 0.0   0.0         0.0     0.0   0.0 0.0     0             0   0 0   0         0     0   0 0     0       0   0
2227149 NY Westchester   school 3625950 662001030000   SCARSDALE 362595003563 662001030004 HEATHCOTE SCHOOL public Regular School No Elementary KG 05 2019   grade_8 0.0 0.0 0.0         0.0     0.0   0.0 0.0     0             0   0 0 0 0         0     0   0 0     0       0   0
2227168 NY Westchester   school 3625950 662001030000   SCARSDALE 362595003564 662001030005 QUAKER RIDGE SCHOOL public Regular School No Elementary KG 05 2019   grade_8 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0     0             0   0 0 0 0   0     0     0   0 0     0       0   0
2227187 NY Westchester   school 3625950 662001030000   SCARSDALE 362595003566 662001030010 SCARSDALE SENIOR HIGH SCHOOL public Regular School No High 09 12 2019   grade_8 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0     0             0   0 0 0 0   0     0     0   0 0     0       0   0
2227206 NY Westchester   school 3625950 662001030000   SCARSDALE 362595003565 662001030011 SCARSDALE MIDDLE SCHOOL public Regular School No Middle 06 08 2019   grade_8 250.0 6.0 19.0         80.0     21.0   191.0 185.0     *             42   376 250 6 19         80     21   191 185             42   376
2199960 NY Queens   school 3600098 342400010000   NYC GEOG DIST #24 - QUEENS 360009802263 342400010061 IS 61 LEONARDO DA VINCI public Regular School No Middle 06 08 2019   grade_8 16.0 24.0 654.0   1.0     57.0     2.0   407.0 347.0     189       706     134   754 16 24 654   1     57     2   407 347     189   706   134   754
2202981 NY Queens   school 3600123 342700010000   NYC GEOG DIST #27 - QUEENS 360012302704 342700010210 JHS 210 ELIZABETH BLACKWELL public Regular School No Middle 06 08 2019   grade_8 31.0 19.0 382.0   17.0     189.0     0.0   359.0 279.0     103       531     105   638 31 19 382   17     189     0   359 279     103   531   105   638
2205983 NY Queens   school 3600102 343000010000   NYC GEOG DIST #30 - QUEENS 360010202527 343000010145 IS 145 JOSEPH PULITZER public Regular School No Middle 06 08 2019   grade_8 8.0 14.0 493.0   1.0     52.0     1.0   303.0 266.0     *       525     84   569 8 14 493   1     52     1   303 266         525   84   569
2202848 NY Queens   school 3600123 342700010000   NYC GEOG DIST #27 - QUEENS 360012305269 342700010137 MS 137 AMERICA'S SCHOOL OF HEROES public Regular School No Middle 06 08 2019   grade_8 13.0 30.0 206.0   5.0     362.0     1.0   307.0 310.0     57       506     105   617 13 30 206   5     362     1   307 310     57   506   105   617
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
2200017 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 2019   grade_8 90.0 1.0 396.0   2.0     200.0     3.0   384.0 308.0     *       466     143   692 90 1 396   2     200     3   384 308         466   143   692
2199770 NY Queens   school 3600098 342400010000   NYC GEOG DIST #24 - QUEENS 360009803117 342400010005 IS 5 WALTER CROWLEY INTERMEDIATE public Regular School No Middle 06 08 2019   grade_8 11.0 10.0 306.0   6.0     266.0     3.0   309.0 293.0     90       451     108   602 11 10 306   6     266     3   309 293     90   451   108   602
2171175 NY Kings   school 3600153 332200010000   NYC GEOG DIST #22 - BROOKLYN 360015302748 332200010234 JHS 234 ARTHUR W CUNNINGHAM public Regular School No Middle 06 08 2019   grade_8 271.0 123.0 82.0   10.0     147.0     3.0   338.0 298.0     *       439     *   636 271 123 82   10     147     3   338 298         439       636
2200245 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 2019   grade_8 31.0 15.0 308.0   2.0     211.0     1.0   289.0 279.0     *       420     95   568 31 15 308   2     211     1   289 279         420   95   568
2170472 NY Kings   school 3600152 332100010000   NYC GEOG DIST #21 - BROOKLYN 360015202792 332100010281 IS 281 JOSEPH B CAVALLARO public Regular School No Middle 06 08 2019   grade_8 138.0 29.0 126.0   2.0     200.0     1.0   261.0 235.0     *       416     87   496 138 29 126   2     200     1   261 235         416   87   496
2201385 NY Queens   school 3600122 342500010000   NYC GEOG DIST #25 - QUEENS 360012201996 342500010237 IS 237 public Regular School No Middle 06 08 2019   grade_8 8.0 31.0 87.0   2.0     371.0     5.0   288.0 216.0     113       416     61   504 8 31 87   2     371     5   288 216     113   416   61   504
2205204 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 2019   grade_8 15.0 154.0 140.0   21.0     130.0     2.0   231.0 231.0     73       384     71   462 15 154 140   21     130     2   231 231     73   384   71   462
2208168 NY Richmond   school 3600103 353100010000   NYC GEOG DIST #31 - SI 360010302057 353100010051 IS 51 EDWIN MARKHAM public Regular School No Middle 06 08 2019   grade_8 120.0 107.0 217.0   1.0     25.0     5.0   239.0 236.0     27       380     140   475 120 107 217   1     25     5   239 236     27   380   140   475
2169237 NY Kings   school 3600151 332000010000   NYC GEOG DIST #20 - BROOKLYN 360015102266 332000010062 JHS 62 DITMAS public Regular School No Middle 06 08 2019   grade_8 63.0 80.0 157.0   2.0     139.0     1.0   240.0 202.0     87       378     79   442 63 80 157   2     139     1   240 202     87   378   79   442
2209365 NY Rockland   school 3614010 500201060000   HAVERSTRAW-STONY POINT 361401005738 500201060013 FIELDSTONE MIDDLE SCHOOL public Regular School No Middle 07 08 2019   grade_8 162.0 97.0 352.0   4.0     36.0     4.0   343.0 312.0     57       377     110   655 162 97 352   4     36     4   343 312     57   377   110   655
2178091 NY Nassau   school 3614130 280201030000   HEMPSTEAD 361413001153 280201030010 ALVERTA B GRAY SCHULTZ MIDDLE SCH public Regular School No Middle 06 08 2019   grade_8 28.0 116.0 298.0   3.0     4.0     1.0   238.0 212.0     141       362     52   450 28 116 298   3     4     1   238 212     141   362   52   450
2215673 NY Suffolk   school 3619230 580212060000   LONGWOOD 361923001754 580212060006 LONGWOOD JUNIOR HIGH SCHOOL public Regular School No Middle 07 08 2019   grade_8 348.0 115.0 169.0   4.0     28.0     27.0   342.0 349.0     *       352     115   691 348 115 169   4     28     27   342 349         352   115   691
2201214 NY Queens   school 3600122 342500010000   NYC GEOG DIST #25 - QUEENS 360012202639 342500010185 JHS 185 EDWARD BLEEKER public Regular School No Middle 06 08 2019   grade_8 63.0 10.0 156.0   2.0     266.0     3.0   246.0 254.0     *       345     76   500 63 10 156   2     266     3   246 254         345   76   500
2164734 NY Kings   school 3600092 331500010000   NYC GEOG DIST #15 - BROOKLYN 360009204474 331500010088 JHS 88 PETER ROUGET public Regular School No Middle 06 08 2019   grade_8 44.0 41.0 280.0   1.0     74.0     3.0   250.0 193.0     34       339     102   443 44 41 280   1     74     3   250 193     34   339   102   443
2218656 NY Suffolk   school 3605280 580512030000   BRENTWOOD 360528000254 580512030016 NORTH MIDDLE SCHOOL public Regular School No Middle 06 08 2019   grade_8 10.0 30.0 320.0   0.0     7.0     1.0   169.0 199.0     *       338     29   368 10 30 320   0     7     1   169 199         338   29   368
2206211 NY Queens   school 3600102 343000010000   NYC GEOG DIST #30 - QUEENS 360010204802 343000010230 IS 230 public Regular School No Middle 06 08 2019   grade_8 23.0 2.0 260.0   6.0     155.0     2.0   247.0 201.0     *       332     50   448 23 2 260   6     155     2   247 201         332   50   448
2169674 NY Kings   school 3600151 332000010000   NYC GEOG DIST #20 - BROOKLYN 360015102729 332000010223 JHS 223 MONTAUK (THE) public Regular School No Middle 06 08 2019   grade_8 42.0 4.0 93.0   0.0     206.0         189.0 156.0     92       330     54   345 42 4 93   0     206         189 156     92   330   54   345
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
2200150 NY Queens   school 3600098 342400010000   NYC GEOG DIST #24 - QUEENS 360009802355 342400010093 IS 93 RIDGEWOOD public Regular School No Middle 06 08 2019   grade_8 62.0 5.0 259.0   1.0     27.0     0.0   175.0 179.0     50       329     71   354 62 5 259   1     27     0   175 179     50   329   71   354
2206382 NY Queens   school 3600102 343000010000   NYC GEOG DIST #30 - QUEENS 360010203146 343000011227 IS 227 LOUIS ARMSTRONG public Regular School No Middle 05 08 2019   grade_8 129.0 48.0 236.0   2.0     50.0     0.0   213.0 252.0     7       329     67   465 129 48 236   2     50     0   213 252     7   329   67   465
2218694 NY Suffolk   school 3605280 580512030000   BRENTWOOD 360528000248 580512030020 EAST MIDDLE SCHOOL public Regular School No Middle 06 08 2019   grade_8 14.0 24.0 298.0   1.0     5.0     1.0   181.0 162.0     84       323     56   343 14 24 298   1     5     1   181 162     84   323   56   343
2181511 NY Nassau   school 3630960 280401030000   WESTBURY 363096004161 280401030006 WESTBURY MIDDLE SCHOOL public Regular School No Middle 06 08 2019   grade_8 2.0 85.0 261.0         7.0         184.0 171.0     66       314     32   355 2 85 261         7         184 171     66   314   32   355
2145183 NY Bronx   school 3600087 321000010000   NYC GEOG DIST #10 - BRONX 360008702440 321000010118 JHS 118 WILLIAM W NILES public Regular School No Middle 06 08 2019   grade_8 6.0 78.0 213.0   1.0     59.0     1.0   187.0 171.0     *       313     82   358 6 78 213   1     59     1   187 171         313   82   358
2200036 NY Queens   school 3600098 342400010000   NYC GEOG DIST #24 - QUEENS 360009804609 342400010077 IS 77 public Regular School No Middle 06 08 2019   grade_8 29.0 7.0 276.0   1.0     27.0     0.0   162.0 178.0     74       312     87   340 29 7 276   1     27     0   162 178     74   312   87   340
2171327 NY Kings   school 3600153 332200010000   NYC GEOG DIST #22 - BROOKLYN 360015302012 332200010278 JHS 278 MARINE PARK public Regular School No Middle 06 08 2019   grade_8 113.0 178.0 73.0   3.0     49.0     5.0   228.0 193.0     13       303     74   421 113 178 73   3     49     5   228 193     13   303   74   421
2193405 NY Oneida   school 3629370 412300010000   UTICA 362937003962 412300010023 SENATOR JAMES H DONOVAN MIDDLE SCH public Regular School No Middle 07 08 2019   grade_8 67.0 97.0 72.0   1.0     85.0     17.0   158.0 181.0     *       303     63   339 67 97 72   1     85     17   158 181         303   63   339
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
2204045 NY Queens   school 3600100 342800010000   NYC GEOG DIST #28 - QUEENS 360010002567 342800010157 JHS 157 STEPHEN A HALSEY public Regular School No Middle 06 09 2019   grade_8 214.0 28.0 136.0   3.0     116.0     17.0   248.0 266.0     44       284     67   514 214 28 136   3     116     17   248 266     44   284   67   514
2218713 NY Suffolk   school 3605280 580512030000   BRENTWOOD 360528000258 580512030021 SOUTH MIDDLE SCHOOL public Regular School No Middle 06 08 2019   grade_8 9.0 32.0 261.0   1.0     8.0     1.0   153.0 159.0     73       284     39   312 9 32 261   1     8     1   153 159     73   284   39   312
2227016 NY Westchester   school 3623460 661904030000   PORT CHESTER-RYE 362346003277 661904030010 PORT CHESTER MIDDLE SCHOOL public Regular School No Middle 06 08 2019   grade_8 42.0 14.0 281.0   1.0     8.0     1.0   168.0 179.0     90       284     42   347 42 14 281   1     8     1   168 179     90   284   42   347
2226199 NY Westchester   school 3620490 661100010000   NEW ROCHELLE 362049001897 661100010014 ISAAC E YOUNG MIDDLE SCHOOL public Regular School No Middle 06 08 2019   grade_8 53.0 82.0 259.0         15.0         235.0 174.0     43       283     50   409 53 82 259         15         235 174     43   283   50   409
2145354 NY Bronx   school 3600087 321000010000   NYC GEOG DIST #10 - BRONX 360008705798 321000010244 NEW SCHOOL-LEADERSHIP & JOURNAL public Regular School No Middle 06 08 2019   grade_8 6.0 35.0 227.0   1.0     14.0     0.0   152.0 131.0     72       282     74   283 6 35 227   1     14     0   152 131     72   282   74   283
2202943 NY Queens   school 3600123 342700010000   NYC GEOG DIST #27 - QUEENS 360012302685 342700010202 JHS 202 ROBERT H GODDARD public Regular School No Middle 06 08 2019   grade_8 22.0 28.0 168.0   16.0     126.0     3.0   182.0 181.0     27       282     67   363 22 28 168   16     126     3   182 181     27   282   67   363
2193386 NY Oneida   school 3629370 412300010000   UTICA 362937003952 412300010022 JOHN F KENNEDY MIDDLE SCHOOL public Regular School No Middle 07 08 2019   grade_8 143.0 79.0 56.0   2.0     50.0     21.0   179.0 172.0     54       281     42   351 143 79 56   2     50     21   179 172     54   281   42   351
2218637 NY Suffolk   school 3605280 580512030000   BRENTWOOD 360528000263 580512030015 WEST MIDDLE SCHOOL public Regular School No Middle 06 08 2019   grade_8 19.0 33.0 241.0         12.0     2.0   170.0 137.0     89       278     60   307 19 33 241         12     2   170 137     89   278   60   307
2219055 NY Suffolk   school 3624690 580602040000   RIVERHEAD 362469003358 580602040006 RIVERHEAD MIDDLE SCHOOL public Regular School No Middle 06 08 2019   grade_8 172.0 48.0 204.0   2.0     5.0     1.0   239.0 193.0     72       278     63   432 172 48 204   2     5     1   239 193     72   278   63   432
2200454 NY Queens   school 3600098 342400010000   NYC GEOG DIST #24 - QUEENS 360009806431 342400010311 CORONA ARTS AND SCIENCES ACADEMY public Regular School No Middle 06 08 2019   grade_8 1.0 4.0 276.0   0.0     4.0     0.0   135.0 150.0     53       276     58   285 1 4 276   0     4     0   135 150     53   276   58   285
2152004 NY Chemung   school 3610560 70600010000   ELMIRA 361056000814 70600010021 ERNIE DAVIS ACADEMY public Regular School No Secondary 08 09 2019   grade_8 324.0 72.0 13.0         2.0     36.0   227.0 220.0             273     57   447 324 72 13         2     36   227 220         273   57   447
2203019 NY Queens   school 3600123 342700010000   NYC GEOG DIST #27 - QUEENS 360012301995 342700010226 JHS 226 VIRGIL I GRISSOM public Regular School No Middle 06 08 2019   grade_8 8.0 110.0 59.0   56.0     94.0     2.0   182.0 147.0     26       271     66   329 8 110 59   56     94     2   182 147     26   271   66   329
2193975 NY Onondaga   school 3621210 420303060000   NORTH SYRACUSE 362121003001 420303060010 NORTH SYRACUSE JUNIOR HIGH SCHOOL public Regular School No Secondary 08 09 2019   grade_8 521.0 29.0 29.0   4.0     17.0     37.0   319.0 318.0     *       266     81   637 521 29 29   4     17     37   319 318         266   81   637
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
2192854 NY Oneida   school 3624900 411800010000   ROME 362490003446 411800010010 LYNDON H STROUGH MIDDLE SCHOOL public Regular School No Middle 07 08 2019   grade_8 319.0 33.0 29.0   0.0     8.0     2.0   200.0 191.0     *       246     57   391 319 33 29   0     8     2   200 191         246   57   391
2216053 NY Suffolk   school 3618690 580232030000   WILLIAM FLOYD 361869005744 580232030012 WILLIAM PACA MIDDLE SCHOOL public Regular School No Middle 06 08 2019   grade_8 155.0 57.0 111.0   4.0     9.0     18.0   180.0 174.0     16       239     63   354 155 57 111   4     9     18   180 174     16   239   63   354
2172714 NY Kings   school 3600097 333200010000   NYC GEOG DIST #32 - BROOKLYN 360009702000 333200010383 JHS 383 PHILIPPA SCHUYLER public Regular School No Middle 05 08 2019   grade_8 3.0 113.0 155.0   1.0     10.0     3.0   137.0 148.0     20       235     47   285 3 113 155   1     10     3   137 148     20   235   47   285
2146836 NY Bronx   school 3600088 321100010000   NYC GEOG DIST #11 - BRONX 360008802469 321100010127 JHS 127 CASTLE HILL (THE) public Regular School No Middle 06 08 2019   grade_8 7.0 59.0 117.0   6.0     111.0     2.0   143.0 159.0     42       232     54   302 7 59 117   6     111     2   143 159     42   232   54   302
2170054 NY Kings   school 3600152 332100010000   NYC GEOG DIST #21 - BROOKLYN 360015202367 332100010096 IS 96 SETH LOW public Regular School No Middle 06 08 2019   grade_8 82.0 24.0 82.0   1.0     100.0     3.0   153.0 139.0     73       232     76   292 82 24 82   1     100     3   153 139     73   232   76   292
2217459 NY Suffolk   school 3627300 580413030000   SOUTH HUNTINGTON 362730003724 580413030013 HENRY L STIMSON MIDDLE SCHOOL public Regular School No Middle 07 08 2019   grade_8 177.0 39.0 169.0   2.0     31.0     14.0   218.0 214.0     45       232     73   432 177 39 169   2     31     14   218 214     45   232   73   432
2209916 NY Rockland   school 3627810 500402060000   EAST RAMAPO 362781003781 500402060013 CHESTNUT RIDGE MIDDLE SCHOOL public Regular School No Middle 07 08 2019   grade_8 6.0 88.0 151.0         8.0     2.0   133.0 122.0     63       230     73   255 6 88 151         8     2   133 122     63   230   73   255
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
2204900 NY Queens   school 3600101 342900010000   NYC GEOG DIST #29 - QUEENS 360010102409 342900010109 JEAN NUZZI INTERMEDIATE SCHOOL public Regular School No Middle 06 08 2019   grade_8 14.0 141.0 65.0   12.0     124.0     2.0   173.0 185.0     30       221     54   358 14 141 65   12     124     2   173 185     30   221   54   358
2209954 NY Rockland   school 3627810 500402060000   EAST RAMAPO 362781003778 500402060015 POMONA MIDDLE SCHOOL public Regular School No Middle 07 08 2019   grade_8 7.0 66.0 153.0         4.0     1.0   109.0 122.0     74       221     45   231 7 66 153         4     1   109 122     74   221   45   231
2164031 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 2019   grade_8 53.0 49.0 220.0   1.0     26.0     1.0   194.0 156.0     *       219     53   350 53 49 220   1     26     1   194 156         219   53   350
2207370 NY Rensselaer   school 3628950 491700010000   TROY 362895003919 491700010021 TROY MIDDLE SCHOOL public Regular School No Middle 06 08 2019   grade_8 134.0 102.0 41.0   1.0     3.0     12.0   154.0 139.0     *       219     47   293 134 102 41   1     3     12   154 139         219   47   293
2214096 NY Suffolk   school 3617380 580104030000   LINDENHURST 361738001547 580104030011 LINDENHURST MIDDLE SCHOOL public Regular School No Middle 06 08 2019   grade_8 337.0 9.0 115.0   0.0     18.0     4.0   243.0 240.0     12       219     84   483 337 9 115   0     18     4   243 240     12   219   84   483
2144917 NY Bronx   school 3600087 321000010000   NYC GEOG DIST #10 - BRONX 360008702202 321000010045 THOMAS C GIORDANO MS 45 public Regular School No Middle 06 08 2019   grade_8 8.0 36.0 178.0   1.0     4.0     3.0   121.0 109.0     47       218     41   230 8 36 178   1     4     3   121 109     47   218   41   230
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
2146988 NY Bronx   school 3600088 321100010000   NYC GEOG DIST #11 - BRONX 360008801989 321100010181 IS 181 PABLO CASALS public Regular School No Middle 06 08 2019   grade_8 17.0 166.0 75.0   9.0     14.0     1.0   154.0 128.0     6       211     72   282 17 166 75   9     14     1   154 128     6   211   72   282
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
2228118 NY Westchester   school 3631920 662300010000   YONKERS 363192005591 662300010055 YONKERS MIDDLE SCHOOL public Regular School No Middle 06 08 2019   grade_8 45.0 44.0 136.0   0.0     18.0     2.0   139.0 106.0     19       209     49   245 45 44 136   0     18     2   139 106     19   209   49   245
2191999 NY Niagara   school 3620820 400800010000   NIAGARA FALLS 362082005952 400800010041 LASALLE PREPARATORY SCHOOL public Regular School No Middle 07 08 2019   grade_8 126.0 86.0 24.0   10.0     4.0     26.0   139.0 137.0     9       208     63   276 126 86 24   10     4     26   139 137     9   208   63   276
2142637 NY Bronx   school 3600085 320800010000   NYC GEOG DIST # 8 - BRONX 360008506302 320800010562 BLUEPRINT MIDDLE SCHOOL public Regular School No Middle 06 08 2019   grade_8 19.0 35.0 121.0   6.0     53.0         123.0 111.0     *       204     44   234 19 35 121   6     53         123 111         204   44   234
2163575 NY Kings   school 3601111 331300861063   BROOKLYN LABORATORY CHARTER S 360111106493 331300861063 BROOKLYN LABORATORY CHARTER SCHOOL charter Regular School Yes Middle 06 10 2019   grade_8 2.0 167.0 33.0   1.0     4.0     1.0   117.0 91.0     5       204     65   208 2 167 33   1     4     1   117 91     5   204   65   208
2139369 NY Albany   school 3602460 10100010000   ALBANY 360246005747 10100010045 MYERS MIDDLE SCHOOL public Regular School No Middle 06 08 2019   grade_8 47.0 167.0 45.0   0.0     24.0     11.0   141.0 153.0     28       203     33   294 47 167 45   0     24     11   141 153     28   203   33   294
2183240 NY Nassau   school 3614340 280517030000   HICKSVILLE 361434001186 280517030011 HICKSVILLE MIDDLE SCHOOL public Regular School No Middle 06 08 2019   grade_8 125.0 5.0 130.0   1.0     142.0     10.0   206.0 207.0     32       203     54   413 125 5 130   1     142     10   206 207     32   203   54   413
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
2178300 NY Nassau   school 3629280 280202030000   UNIONDALE 362928003943 280202030009 TURTLE HOOK MIDDLE SCHOOL public Regular School No Middle 06 08 2019   grade_8 5.0 113.0 146.0         3.0     1.0   139.0 129.0     42       202     49   268 5 113 146         3     1   139 129     42   202   49   268
2205926 NY Queens   school 3600102 343000010000   NYC GEOG DIST #30 - QUEENS 360010202466 343000010126 ALBERT SHANKER SCH-VISUAL/PERF ARTS public Regular School No Middle 06 08 2019   grade_8 19.0 38.0 110.0   0.0     63.0     2.0   125.0 107.0     16       202     43   232 19 38 110   0     63     2   125 107     16   202   43   232
2216015 NY Suffolk   school 3618690 580232030000   WILLIAM FLOYD 361869005579 580232030010 WILLIAM FLOYD MIDDLE SCHOOL public Regular School No Middle 06 08 2019   grade_8 139.0 39.0 126.0   0.0     14.0     17.0   165.0 170.0     *       201     32   335 139 39 126   0     14     17   165 170         201   32   335
2146969 NY Bronx   school 3600088 321100010000   NYC GEOG DIST #11 - BRONX 360008802628 321100010180 MS 180 DR DANIEL HALE WILLIAMS public Regular School No Middle 06 08 2019   grade_8 6.0 198.0 64.0   7.0     11.0     5.0   136.0 155.0     7       200     41   291 6 198 64   7     11     5   136 155     7   200   41   291
2197680 NY Orange   school 3620700 441600010000   NEWBURGH 362070002912 441600010016 SOUTH MIDDLE SCHOOL public Regular School No Middle 06 08 2019   grade_8 41.0 73.0 140.0   0.0     4.0     3.0   149.0 112.0     56       200     46   261 41 73 140   0     4     3   149 112     56   200   46   261
2145050 NY Bronx   school 3600087 321000010000   NYC GEOG DIST #10 - BRONX 360008702316 321000010080 JHS 80 MOSHOLU PARKWAY (THE) public Regular School No Middle 06 08 2019   grade_8 7.0 27.0 152.0   3.0     32.0     0.0   120.0 101.0     69       198     46   221 7 27 152   3     32     0   120 101     69   198   46   221
2225895 NY Westchester   school 3620100 660900010000   MOUNT VERNON 362010006668 660900010027 MOUNT VERNON STEAM ACADEMY public Regular School No Secondary 08 10 2019   grade_8 9.0 139.0 64.0   1.0     6.0     0.0   103.0 116.0     22       197     39   219 9 139 64   1     6     0   103 116     22   197   39   219
2195609 NY Onondaga   school 3628590 421800010000   SYRACUSE 362859003862 421800010035 GRANT MIDDLE SCHOOL public Regular School No Middle 06 08 2019   grade_8 61.0 85.0 24.0   0.0     29.0     19.0   117.0 101.0     *       196     47   218 61 85 24   0     29     19   117 101         196   47   218
2202031 NY Queens   school 3600099 342600010000   NYC GEOG DIST #26 - QUEENS 360009902608 342600010172 IRWIN ALTMAN MIDDLE SCHOOL 172 public Regular School No Middle 06 08 2019   grade_8 33.0 28.0 55.0   5.0     204.0     4.0   178.0 151.0     15       196     54   329 33 28 55   5     204     4   178 151     15   196   54   329
2191980 NY Niagara   school 3620820 400800010000   NIAGARA FALLS 362082005951 400800010040 GASKILL PREPARATORY SCHOOL public Regular School No Middle 07 08 2019   grade_8 69.0 96.0 13.0   9.0     3.0     30.0   109.0 111.0             194     35   220 69 96 13   9     3     30   109 111         194   35   220
2162473 NY Jefferson   school 3630120 222000010000   WATERTOWN 363012004047 222000010013 CASE MIDDLE SCHOOL public Regular School No Middle 07 10 2019   grade_8 198.0 27.0 28.0   2.0     12.0     22.0   148.0 141.0     *       193     63   289 198 27 28   2     12     22   148 141         193   63   289
2171213 NY Kings   school 3600153 332200010000   NYC GEOG DIST #22 - BROOKLYN 360015302755 332200010240 ANDRIES HUDDE public Regular School No Middle 06 08 2019   grade_8 21.0 130.0 40.0   2.0     42.0     1.0   121.0 115.0     38       193     *   236 21 130 40   2     42     1   121 115     38   193       236
2166292 NY Kings   school 3600095 331700010000   NYC GEOG DIST #17 - BROOKLYN 360009502262 331700010061 MS 61 DR GLADSTONE H ATWELL public Regular School No Middle 06 08 2019   grade_8 0.0 233.0 27.0   0.0     11.0     0.0   133.0 138.0     9       190     54   271 0 233 27   0     11     0   133 138     9   190   54   271

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