Data source: Big Local News · About: Big Local

33,145 rows where grade = "grade_8" and state = "NY" sorted by total_int descending

View and edit SQL

year

grade

  • grade_8 · 33,145
Link rowid state county county_state_id admin_level district_nces_id district_state_id district_state_type district school_nces_id school_state_id school school_state_type ccd_school_type ccd_charter_school ccd_school_lvl ccd_school_low_grade ccd_school_high_grade year term grade white black hispanic native_american native_american_alaskan_native asian native_hawaiian asian_pacific_islander native_hawaiian_pacific_islander pacific_islander multiracial unknown_race male female non_binary unknown_gender ell ell_percent homeless homeless_percent low_income free_and_reduced free_and_reduced_percent disability section_504 total white_int black_int hispanic_int native_american_int native_american_alaskan_native_int asian_int native_hawaiian_int asian_pacific_islander_int native_hawaiian_pacific_islander_int pacific_islander_int multiracial_int unknown_race_int male_int female_int non_binary_int unknown_gender_int ell_int homeless_int low_income_int free_and_reduced_int disability_int section_504_int total_int ▲
806750 NY Queens   school 3600098 342400010000   NYC GEOG DIST #24 - QUEENS 360009802263 342400010061 IS 61 LEONARDO DA VINCI public Regular School No 2 06 08 2015   grade_8 16.0 35.0 667.0   1.0     59.0     1.0   416.0 363.0             723     149   779 16 35 667   1     59     1   416 363         723   149   779
1494128 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 2021   grade_8 92.0 10.0 463.0   4.0     210.0     0.0   417.0 362.0     78       532     149   779 92 10 463   4     210     0   417 362     78   532   149   779
1093114 NY Queens   school 3600098 342400010000   NYC GEOG DIST #24 - QUEENS 360009802263 342400010061 IS 61 LEONARDO DA VINCI public Regular School No 2.0 05 08 2016   grade_8 10.0 21.0 684.0   1.0     60.0     2.0   407.0 371.0             745     147   778 10 21 684   1     60     2   407 371         745   147   778
1600053 NY Suffolk   school 3619230 580212060000   LONGWOOD 361923001754 580212060006 LONGWOOD JUNIOR HIGH SCHOOL public Regular School No Middle 07 08 2020   grade_8 358.0 138.0 211.0   3.0     36.0     29.0   406.0 369.0     54       410     122   775 358 138 211   3     36     29   406 369     54   410   122   775
1584245 NY Queens   school 3600098 342400010000   NYC GEOG DIST #24 - QUEENS 360009802263 342400010061 IS 61 LEONARDO DA VINCI public Regular School No Middle 06 08 2020   grade_8 14.0 21.0 688.0   3.0     47.0     0.0   430.0 343.0     187       714     184   773 14 21 688   3     47     0   430 343     187   714   184   773
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
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
1003054 NY Queens   school 3600098 342400010000   NYC GEOG DIST #24 - QUEENS 360009802263 342400010061 IS 61 LEONARDO DA VINCI public Regular School No Middle 06 08 2017   grade_8 13.0 25.0 661.0   0.0     37.0     1.0   389.0 348.0     211       698     149   737 13 25 661   0     37     1   389 348     211   698   149   737
1509917 NY Suffolk   school 3619230 580212060000   LONGWOOD 361923001754 580212060006 LONGWOOD JUNIOR HIGH SCHOOL public Regular School No Middle 07 08 2021   grade_8 320.0 156.0 196.0   2.0     27.0     35.0   380.0 356.0     40       300     125   736 320 156 196   2     27     35   380 356     40   300   125   736
1494071 NY Queens   school 3600098 342400010000   NYC GEOG DIST #24 - QUEENS 360009802263 342400010061 IS 61 LEONARDO DA VINCI public Regular School No Middle 06 08 2021   grade_8 15.0 12.0 669.0   4.0     28.0     1.0   386.0 343.0     245       654     155   729 15 12 669   4     28     1   386 343     245   654   155   729
800727 NY Onondaga   school 3621210 420303060000   NORTH SYRACUSE 362121003001 420303060010 NORTH SYRACUSE JUNIOR HIGH SCHOOL public Regular School No 4 08 09 2015   grade_8 624.0 25.0 28.0   11.0     8.0     32.0   365.0 363.0             *     *   728 624 25 28   11     8     32   365 363                 728
1003111 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 2017   grade_8 125.0 7.0 409.0   2.0     183.0     1.0   409.0 318.0     *       344     132   727 125 7 409   2     183     1   409 318         344   132   727
1018653 NY Suffolk   school 3619230 580212060000   LONGWOOD 361923001754 580212060006 LONGWOOD JUNIOR HIGH SCHOOL public Regular School No Middle 07 08 2017   grade_8 400.0 126.0 148.0   4.0     29.0     14.0   371.0 350.0     *       383     124   721 400 126 148   4     29     14   371 350         383   124   721
812583 NY Queens   school 3600102 343000010000   NYC GEOG DIST #30 - QUEENS 360010202527 343000010145 IS 145 JOSEPH PULITZER public Regular School No 2 06 08 2015   grade_8 19.0 16.0 624.0   2.0     53.0     0.0   381.0 333.0             652     133   714 19 16 624   2     53     0   381 333         652   133   714
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
1008963 NY Queens   school 3600102 343000010000   NYC GEOG DIST #30 - QUEENS 360010202527 343000010145 IS 145 JOSEPH PULITZER public Regular School No Middle 06 08 2017   grade_8 13.0 9.0 611.0   3.0     60.0     0.0   356.0 340.0     123       660     125   696 13 9 611   3     60     0   356 340     123   660   125   696
1503609 NY Rockland   school 3614010 500201060000   HAVERSTRAW-STONY POINT 361401005738 500201060013 FIELDSTONE MIDDLE SCHOOL public Regular School No Middle 07 08 2021   grade_8 177.0 93.0 399.0   1.0     21.0     3.0   343.0 351.0     *       225     92   694 177 93 399   1     21     3   343 351         225   92   694
806807 NY Queens   school 3600098 342400010000   NYC GEOG DIST #24 - QUEENS 360009802300 342400010073 IS 73 FRANK SANSIVIERI INTER SCHOOL public Regular School No 2 06 08 2015   grade_8 113.0 13.0 415.0   0.0     151.0     0.0   362.0 330.0             378     125   692 113 13 415   0     151     0   362 330         378   125   692
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
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
1584302 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 2020   grade_8 91.0 11.0 375.0   2.0     204.0     2.0   356.0 329.0     *       434     125   685 91 11 375   2     204     2   356 329         434   125   685
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
1099004 NY Queens   school 3600102 343000010000   NYC GEOG DIST #30 - QUEENS 360010202527 343000010145 IS 145 JOSEPH PULITZER public Regular School No 2.0 05 08 2016   grade_8 9.0 12.0 604.0   0.0     52.0     1.0   337.0 341.0             656     93   678 9 12 604   0     52     1   337 341         656   93   678
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
1005885 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 2017   grade_8 22.0 40.0 204.0   43.0     363.0     0.0   337.0 335.0     58       579     *   672 22 40 204   43     363     0   337 335     58   579       672
997012 NY Onondaga   school 3621210 420303060000   NORTH SYRACUSE 362121003001 420303060010 NORTH SYRACUSE JUNIOR HIGH SCHOOL public Regular School No Other 08 09 2017   grade_8 559.0 34.0 25.0   4.0     17.0     32.0   340.0 331.0     *       254     77   671 559 34 25   4     17     32   340 331         254   77   671
1578260 NY Onondaga   school 3621210 420303060000   NORTH SYRACUSE 362121003001 420303060010 NORTH SYRACUSE JUNIOR HIGH SCHOOL public Regular School No Secondary 08 09 2020   grade_8 553.0 23.0 24.0   2.0     29.0     39.0   342.0 328.0     7       *     89   670 553 23 24   2     29     39   342 328     7       89   670
809581 NY Queens   school 3600123 342700010000   NYC GEOG DIST #27 - QUEENS 360012305269 342700010137 MS 137 AMERICA'S SCHOOL-HEROES public Regular School No 2 06 08 2015   grade_8 16.0 42.0 199.0   34.0     375.0     1.0   335.0 332.0             568     80   667 16 42 199   34     375     1   335 332         568   80   667
1087091 NY Onondaga   school 3621210 420303060000   NORTH SYRACUSE 362121003001 420303060010 NORTH SYRACUSE JUNIOR HIGH SCHOOL public Regular School No 4.0 08 09 2016   grade_8 568.0 30.0 23.0   7.0     17.0     22.0   356.0 311.0             *     76   667 568 30 23   7     17     22   356 311             76   667
1093171 NY Queens   school 3600098 342400010000   NYC GEOG DIST #24 - QUEENS 360009802300 342400010073 IS 73 FRANK SANSIVIERI INTER SCHOOL public Regular School No 2.0 05 08 2016   grade_8 100.0 9.0 371.0   1.0     183.0     3.0   354.0 313.0             *     107   667 100 9 371   1     183     3   354 313             107   667
1102101 NY Rockland   school 3620340 500101060000   CLARKSTOWN 362034005897 500101060022 FELIX FESTA DETERMINATION MIDDLE SCH public Regular School No 4.0 08 08 2016   grade_8 460.0 28.0 90.0   1.0     78.0     6.0   342.0 321.0             *     102   663 460 28 90   1     78     6   342 321             102   663
1497016 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 2021   grade_8 22.0 24.0 244.0   7.0     361.0     3.0   352.0 309.0     58       528     100   661 22 24 244   7     361     3   352 309     58   528   100   661
974231 NY Kings   school 3600153 332200010000   NYC GEOG DIST #22 - BROOKLYN 360015302748 332200010234 JHS 234 ARTHUR W CUNNINGHAM public Regular School No Middle 06 8 2017   grade_8 282.0 125.0 84.0   4.0     160.0     3.0   332.0 326.0     54       387     70   658 282 125 84   4     160     3   332 326     54   387   70   658
1108808 NY Suffolk   school 3619230 580212060000   LONGWOOD 361923001754 580212060006 LONGWOOD JUNIOR HIGH SCHOOL public Regular School No 2.0 07 08 2016   grade_8 325.0 120.0 154.0   3.0     34.0     19.0   322.0 333.0             354     108   655 325 120 154   3     34     19   322 333         354   108   655
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
822368 NY Suffolk   school 3619230 580212060000   LONGWOOD 361923001754 580212060006 LONGWOOD JUNIOR HIGH SCHOOL public Regular School No 2 07 08 2015   grade_8 325.0 115.0 169.0   2.0     24.0     18.0   336.0 317.0             328     99   653 325 115 169   2     24     18   336 317         328   99   653
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
2209080 NY Rockland   school 3620340 500101060000   CLARKSTOWN 362034005897 500101060022 FELIX FESTA DETERMINATION MIDDLE SCH public Regular School No Middle 08 08 2019   grade_8 389.0 36.0 107.0         92.0     18.0   335.0 307.0     13       *     106   642 389 36 107         92     18   335 307     13       106   642
809714 NY Queens   school 3600123 342700010000   NYC GEOG DIST #27 - QUEENS 360012302704 342700010210 JHS 210 ELIZABETH BLACKWELL public Regular School No 2 06 08 2015   grade_8 22.0 38.0 396.0   0.0     185.0     0.0   354.0 287.0             543     101   641 22 38 396   0     185     0   354 287         543   101   641
1012041 NY Rockland   school 3620340 500101060000   CLARKSTOWN 362034005897 500101060022 FELIX FESTA DETERMINATION MIDDLE SCH public Regular School No Middle 08 08 2017   grade_8 425.0 23.0 101.0         77.0     15.0   339.0 302.0     9       *     *   641 425 23 101         77     15   339 302     9           641
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
1497149 NY Queens   school 3600123 342700010000   NYC GEOG DIST #27 - QUEENS 360012302704 342700010210 JHS 210 ELIZABETH BLACKWELL public Regular School No Middle 06 08 2021   grade_8 22.0 37.0 373.0   17.0     185.0     3.0   347.0 290.0     98       474     113   637 22 37 373   17     185     3   347 290     98   474   113   637
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
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
1064215 NY Kings   school 3600153 332200010000   NYC GEOG DIST #22 - BROOKLYN 360015302748 332200010234 JHS 234 ARTHUR W CUNNINGHAM public Regular School No 2.0 05 8 2016   grade_8 300.0 98.0 62.0   3.0     170.0     0.0   335.0 298.0             391     74   633 300 98 62   3     170     0   335 298         391   74   633
1096078 NY Queens   school 3600123 342700010000   NYC GEOG DIST #27 - QUEENS 360012302704 342700010210 JHS 210 ELIZABETH BLACKWELL public Regular School No 2.0 06 08 2016   grade_8 29.0 33.0 386.0   1.0     183.0     1.0   326.0 307.0             524     112   633 29 33 386   1     183     1   326 307         524   112   633
1554035 NY Kings   school 3600151 332000010000   NYC GEOG DIST #20 - BROOKLYN 360015102775 332000010259 JHS 259 WILLIAM MCKINLEY public Regular School No Middle 06 08 2020   grade_8 198.0 7.0 135.0   2.0     287.0     3.0   341.0 291.0     52       494     70   632 198 7 135   2     287     3   341 291     52   494   70   632
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
1488105 NY Onondaga   school 3621210 420303060000   NORTH SYRACUSE 362121003001 420303060010 NORTH SYRACUSE JUNIOR HIGH SCHOOL public Regular School No Secondary 08 09 2021   grade_8 491.0 31.0 33.0   4.0     25.0     41.0   307.0 318.0     9       *     *   625 491 31 33   4     25     41   307 318     9           625
777699 NY Kings   school 3600153 332200010000   NYC GEOG DIST #22 - BROOKLYN 360015302748 332200010234 JHS 234 ARTHUR W CUNNINGHAM public Regular School No 2 06 8 2015   grade_8 274.0 92.0 79.0   3.0     176.0     0.0   337.0 287.0             *     *   624 274 92 79   3     176     0   337 287                 624
1593745 NY Rockland   school 3614010 500201060000   HAVERSTRAW-STONY POINT 361401005738 500201060013 FIELDSTONE MIDDLE SCHOOL public Regular School No Middle 07 08 2020   grade_8 149.0 84.0 364.0   3.0     21.0     2.0   317.0 306.0     52       357     93   623 149 84 364   3     21     2   317 306     52   357   93   623
1587133 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 2020   grade_8 17.0 26.0 210.0   4.0     365.0     0.0   340.0 282.0     *       526     104   622 17 26 210   4     365     0   340 282         526   104   622
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
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
1587266 NY Queens   school 3600123 342700010000   NYC GEOG DIST #27 - QUEENS 360012302704 342700010210 JHS 210 ELIZABETH BLACKWELL public Regular School No Middle 06 08 2020   grade_8 19.0 35.0 354.0   12.0     194.0     3.0   313.0 304.0     108       494     103   617 19 35 354   12     194     3   313 304     108   494   103   617
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
1095945 NY Queens   school 3600123 342700010000   NYC GEOG DIST #27 - QUEENS 360012305269 342700010137 MS 137 AMERICA'S SCHOOL-HEROES public Regular School No 2.0 06 08 2016   grade_8 14.0 25.0 194.0   45.0     335.0     1.0   316.0 298.0             *     76   614 14 25 194   45     335     1   316 298             76   614
1006018 NY Queens   school 3600123 342700010000   NYC GEOG DIST #27 - QUEENS 360012302704 342700010210 JHS 210 ELIZABETH BLACKWELL public Regular School No Middle 06 08 2017   grade_8 21.0 38.0 374.0   11.0     169.0     0.0   307.0 306.0     99       442     95   613 21 38 374   11     169     0   307 306     99   442   95   613
1463918 NY Kings   school 3600151 332000010000   NYC GEOG DIST #20 - BROOKLYN 360015102775 332000010259 JHS 259 WILLIAM MCKINLEY public Regular School No Middle 06 08 2021   grade_8 191.0 2.0 115.0   1.0     295.0     9.0   298.0 315.0     52       439     78   613 191 2 115   1     295     9   298 315     52   439   78   613
806560 NY Queens   school 3600098 342400010000   NYC GEOG DIST #24 - QUEENS 360009803117 342400010005 IS 5 WALTER CROWLEY INTERMEDIATE public Regular School No 2 06 09 2015   grade_8 18.0 10.0 320.0   5.0     257.0     1.0   312.0 299.0             367     93   611 18 10 320   5     257     1   312 299         367   93   611
807035 NY Queens   school 3600098 342400010000   NYC GEOG DIST #24 - QUEENS 360009802464 342400010125 IS 125 THOMAS J MCCANN WOODSIDE public Regular School No 2 06 08 2015   grade_8 33.0 9.0 348.0   3.0     216.0     0.0   311.0 298.0             368     92   609 33 9 348   3     216     0   311 298         368   92   609
1503324 NY Rockland   school 3620340 500101060000   CLARKSTOWN 362034005897 500101060022 FELIX FESTA DETERMINATION MIDDLE SCH public Regular School No Middle 08 08 2021   grade_8 352.0 29.0 126.0         83.0     19.0   334.0 275.0     14       117     99   609 352 29 126         83     19   334 275     14   117   99   609
815908 NY Rockland   school 3614010 500201060000   HAVERSTRAW-STONY POINT 361401005738 500201060013 FIELDSTONE MIDDLE SCHOOL public Regular School No 2 07 08 2015   grade_8 204.0 75.0 300.0         27.0     2.0   322.0 286.0             299     68   608 204 75 300         27     2   322 286         299   68   608
1076660 NY Nassau   school 3618630 280523030000   MASSAPEQUA 361863001682 280523030010 BERNER MIDDLE SCHOOL public Regular School No 2.0 07 08 2016   grade_8 576.0 2.0 22.0   1.0     6.0     1.0   321.0 287.0             68     55   608 576 2 22   1     6     1   321 287         68   55   608
1012326 NY Rockland   school 3614010 500201060000   HAVERSTRAW-STONY POINT 361401005738 500201060013 FIELDSTONE MIDDLE SCHOOL public Regular School No Middle 07 08 2017   grade_8 193.0 76.0 311.0   1.0     25.0     1.0   291.0 316.0     *       339     78   607 193 76 311   1     25     1   291 316         339   78   607
1593460 NY Rockland   school 3620340 500101060000   CLARKSTOWN 362034005897 500101060022 FELIX FESTA DETERMINATION MIDDLE SCH public Regular School No Middle 08 08 2020   grade_8 353.0 26.0 117.0         94.0     15.0   286.0 319.0     18       *     117   605 353 26 117         94     15   286 319     18       117   605
1603245 NY Suffolk   school 3606870 580513030000   CENTRAL ISLIP 360687000478 580513030008 RALPH REED SCHOOL public Regular School No Middle 07 08 2020   grade_8 67.0 93.0 432.0   1.0     8.0     2.0   322.0 281.0     149       411     69   603 67 93 432   1     8     2   322 281     149   411   69   603
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
1553978 NY Kings   school 3600151 332000010000   NYC GEOG DIST #20 - BROOKLYN 360015102735 332000010227 JHS 227 EDWARD B SHALLOW public Regular School No Middle 06 08 2020   grade_8 75.0 3.0 172.0   0.0     347.0     2.0   347.0 252.0     133       539     89   599 75 3 172   0     347     2   347 252     133   539   89   599
1513109 NY Suffolk   school 3606870 580513030000   CENTRAL ISLIP 360687000478 580513030008 RALPH REED SCHOOL public Regular School No Middle 07 08 2021   grade_8 22.0 96.0 465.0   1.0     10.0     3.0   296.0 301.0     *       435     66   597 22 96 465   1     10     3   296 301         435   66   597
1002864 NY Queens   school 3600098 342400010000   NYC GEOG DIST #24 - QUEENS 360009803117 342400010005 IS 5 WALTER CROWLEY INTERMEDIATE public Regular School No Middle 06 08 2017   grade_8 9.0 9.0 306.0   1.0     269.0     2.0   320.0 276.0     83       314     83   596 9 9 306   1     269     2   320 276     83   314   83   596
1102386 NY Rockland   school 3614010 500201060000   HAVERSTRAW-STONY POINT 361401005738 500201060013 FIELDSTONE MIDDLE SCHOOL public Regular School No 2.0 07 08 2016   grade_8 185.0 82.0 308.0   2.0     18.0     1.0   309.0 287.0             307     75   596 185 82 308   2     18     1   309 287         307   75   596
1493881 NY Queens   school 3600098 342400010000   NYC GEOG DIST #24 - QUEENS 360009803117 342400010005 IS 5 WALTER CROWLEY INTERMEDIATE public Regular School No Middle 06 08 2021   grade_8 14.0 13.0 350.0   3.0     216.0     0.0   320.0 276.0     106       465     133   596 14 13 350   3     216     0   320 276     106   465   133   596
804128 NY Orange   school 3619650 441201060000   MONROE WOODBURY 361965001794 441201060009 MONROE-WOODBURY MIDDLE SCHOOL public Regular School No 2 06 08 2015   grade_8 390.0 39.0 121.0   1.0     35.0     6.0   320.0 272.0             88     76   592 390 39 121   1     35     6   320 272         88   76   592
1092924 NY Queens   school 3600098 342400010000   NYC GEOG DIST #24 - QUEENS 360009803117 342400010005 IS 5 WALTER CROWLEY INTERMEDIATE public Regular School No 2.0 05 08 2016   grade_8 16.0 10.0 324.0   1.0     235.0     0.0   287.0 299.0             352     78   586 16 10 324   1     235     0   287 299         352   78   586
1003339 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 2017   grade_8 26.0 7.0 305.0   3.0     241.0     0.0   320.0 262.0     77       289     106   582 26 7 305   3     241     0   320 262     77   289   106   582
823983 NY Suffolk   school 3608130 580410030000   COMMACK 360813000581 580410030019 COMMACK MIDDLE SCHOOL public Regular School No 2 06 08 2015   grade_8 495.0 7.0 31.0         44.0     2.0   299.0 280.0             56     95   579 495 7 31         44     2   299 280         56   95   579
1581623 NY Orange   school 3619650 441201060000   MONROE WOODBURY 361965001794 441201060009 MONROE-WOODBURY MIDDLE SCHOOL public Regular School No Middle 06 10 2020   grade_8 292.0 52.0 186.0   0.0     36.0     13.0   293.0 286.0     *       201     98   579 292 52 186   0     36     13   293 286         201   98   579
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
1500170 NY Queens   school 3600102 343000010000   NYC GEOG DIST #30 - QUEENS 360010202527 343000010145 IS 145 JOSEPH PULITZER public Regular School No Middle 06 08 2021   grade_8 11.0 8.0 510.0   1.0     46.0     1.0   294.0 283.0     71       534     87   577 11 8 510   1     46     1   294 283     71   534   87   577
1000394 NY Orange   school 3619650 441201060000   MONROE WOODBURY 361965001794 441201060009 MONROE-WOODBURY MIDDLE SCHOOL public Regular School No Middle 06 08 2017   grade_8 353.0 48.0 126.0   1.0     44.0     4.0   282.0 294.0     11       156     90   576 353 48 126   1     44     4   282 294     11   156   90   576
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
1553883 NY Kings   school 3600151 332000010000   NYC GEOG DIST #20 - BROOKLYN 360015102682 332000010201 JHS 201 DYKER HEIGHTS (THE) public Regular School No Middle 06 08 2020   grade_8 180.0 4.0 89.0   0.0     301.0     1.0   320.0 255.0     51       *     *   575 180 4 89   0     301     1   320 255     51           575
1110423 NY Suffolk   school 3608130 580410030000   COMMACK 360813000581 580410030019 COMMACK MIDDLE SCHOOL public Regular School No 2.0 06 08 2016   grade_8 488.0 6.0 35.0         41.0     4.0   303.0 271.0             46     91   574 488 6 35         41     4   303 271         46   91   574
1463766 NY Kings   school 3600151 332000010000   NYC GEOG DIST #20 - BROOKLYN 360015102682 332000010201 JHS 201 DYKER HEIGHTS (THE) public Regular School No Middle 06 08 2021   grade_8 160.0 1.0 83.0   1.0     328.0     1.0   302.0 272.0     54       419     76   574 160 1 83   1     328     1   302 272     54   419   76   574
1588520 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 2020   grade_8 23.0 88.0 250.0   26.0     184.0     2.0   344.0 229.0     88       *     95   573 23 88 250   26     184     2   344 229     88       95   573
1584055 NY Queens   school 3600098 342400010000   NYC GEOG DIST #24 - QUEENS 360009803117 342400010005 IS 5 WALTER CROWLEY INTERMEDIATE public Regular School No Middle 06 08 2020   grade_8 8.0 12.0 317.0   5.0     230.0         307.0 265.0     *       437     98   572 8 12 317   5     230         307 265         437   98   572
811804 NY Queens   school 3600101 342900010000   NYC GEOG DIST #29 - QUEENS 360010101997 342900010238 IS 238 SUSAN B ANTHONY ACADEMY public Regular School No 2 06 09 2015   grade_8 10.0 267.0 132.0   10.0     145.0     7.0   280.0 291.0             519     75   571 10 267 132   10     145     7   280 291         519   75   571
810873 NY Queens   school 3600100 342800010000   NYC GEOG DIST #28 - QUEENS 360010002718 342800010217 JHS 217 ROBERT A VAN WYCK public Regular School No 2 06 08 2015   grade_8 30.0 82.0 241.0   8.0     209.0         298.0 272.0             323     92   570 30 82 241   8     209         298 272         323   92   570
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
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
1584530 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 2020   grade_8 26.0 11.0 310.0   2.0     217.0     1.0   295.0 272.0     72       466     89   567 26 11 310   2     217     1   295 272     72   466   89   567
790220 NY Nassau   school 3618630 280523030000   MASSAPEQUA 361863001682 280523030010 BERNER MIDDLE SCHOOL public Regular School No 2 07 08 2015   grade_8 537.0 3.0 22.0   0.0     4.0         294.0 272.0             *     59   566 537 3 22   0     4         294 272             59   566
1498403 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 2021   grade_8 22.0 73.0 264.0   23.0     180.0     3.0   282.0 283.0     93       401     97   565 22 73 264   23     180     3   282 283     93   401   97   565
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
972825 NY Kings   school 3600151 332000010000   NYC GEOG DIST #20 - BROOKLYN 360015102775 332000010259 JHS 259 WILLIAM MCKINLEY public Regular School No Middle 06 8 2017   grade_8 183.0 10.0 120.0   0.0     250.0     1.0   299.0 265.0     53       402     54   564 183 10 120   0     250     1   299 265     53   402   54   564

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