Data source: Big Local News · About: Big Local

33,145 rows where grade = "grade_8" and state = "NY" sorted by ell 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
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
1603093 NY Suffolk   school 3605280 580512030000   BRENTWOOD 360528000258 580512030021 SOUTH MIDDLE SCHOOL public Regular School No Middle 06 08 2020   grade_8 13.0 31.0 332.0   0.0     12.0     0.0   219.0 169.0     99       365     48   388 13 31 332   0     12     0   219 169     99   365   48   388
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
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
2079994 NY Kings   school 3600151 332000010000   NYC GEOG DIST #20 - BROOKLYN 360015102729 332000010223 JHS 223 MONTAUK (THE) public Regular School No Middle 06 08 2018   grade_8 25.0 9.0 78.0   2.0     205.0     2.0   174.0 147.0     95       311     40   321 25 9 78   2     205     2   174 147     95   311   40   321
946434 NY Bronx   school 3600086 320900010000   NYC GEOG DIST # 9 - BRONX 360008605192 320900010117 IS 117 JOSEPH H WADE public Regular School No Middle 06 08 2017   grade_8 4.0 36.0 184.0   0.0     5.0     0.0   128.0 101.0     94       196     69   229 4 36 184   0     5     0   128 101     94   196   69   229
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
1581946 NY Orange   school 3620700 441600010000   NEWBURGH 362070002912 441600010016 SOUTH MIDDLE SCHOOL public Regular School No Middle 06 08 2020   grade_8 50.0 65.0 186.0   2.0     10.0     17.0   182.0 148.0     93       204     26   330 50 65 186   2     10     17   182 148     93   204   26   330
1603036 NY Suffolk   school 3605280 580512030000   BRENTWOOD 360528000254 580512030016 NORTH MIDDLE SCHOOL public Regular School No Middle 06 08 2020   grade_8 7.0 20.0 343.0   0.0     5.0     1.0   194.0 182.0     93       349     49   376 7 20 343   0     5     1   194 182     93   349   49   376
1008184 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 2017   grade_8 11.0 184.0 135.0   20.0     175.0     1.0   266.0 260.0     92       420     72   526 11 184 135   20     175     1   266 260     92   420   72   526
1463405 NY Kings   school 3600151 332000010000   NYC GEOG DIST #20 - BROOKLYN 360015102266 332000010062 JHS 62 DITMAS public Regular School No Middle 06 08 2021   grade_8 52.0 69.0 136.0   2.0     134.0     4.0   212.0 185.0     92       317     80   397 52 69 136   2     134     4   212 185     92   317   80   397
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
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
1529715 NY Bronx   school 3600087 321000010000   NYC GEOG DIST #10 - BRONX 360008706297 321000010363 ACAD-PERSONAL LDSHP AND EXCELLENCE public Regular School No Middle 06 08 2020   grade_8 2.0 44.0 264.0   5.0     4.0     0.0   173.0 146.0     91       296     89   319 2 44 264   5     4     0   173 146     91   296   89   319
2128995 NY Suffolk   school 3605280 580512030000   BRENTWOOD 360528000263 580512030015 WEST MIDDLE SCHOOL public Regular School No Middle 06 08 2018   grade_8 28.0 36.0 211.0   1.0     9.0     3.0   144.0 144.0     91       248     45   288 28 36 211   1     9     3   144 144     91   248   45   288
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
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
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
943109 NY Albany   school 3621000 10623060000   NORTH COLONIE CSD 362100002986 10623060009 SHAKER JUNIOR HIGH SCHOOL public Regular School No Middle 07 08 2017   grade_8 308.0 26.0 20.0   0.0     75.0     13.0   220.0 222.0     9       103     68   442 308 26 20   0     75     13   220 222     9   103   68   442
944439 NY Bronx   school 3600084 320700010000   NYC GEOG DIST # 7 - BRONX 360008405504 320700011551 URBAN ASSEMBLY BRONX OF LETTERS public Regular School No Other 06 12 2017   grade_8 5.0 30.0 46.0         0.0     0.0   44.0 37.0     9       78     22   81 5 30 46         0     0   44 37     9   78   22   81
951165 NY Bronx   school 3600090 321200010000   NYC GEOG DIST #12 - BRONX 360009005690 321200010273 FREDERICK DOUGLASS ACAD V MIDDLE SCH public Regular School No Middle 06 08 2017   grade_8 3.0 21.0 56.0   0.0     1.0         47.0 34.0     9       *     23   81 3 21 56   0     1         47 34     9       23   81
959259 NY Erie   school 3605850 140600010000   BUFFALO 360585000324 140600010019 NATIVE AMERICAN MAGNET public Regular School No Elementary PK 8 2017   grade_8 5.0 25.0 7.0   9.0     10.0     2.0   26.0 32.0     9       47     14   58 5 25 7   9     10     2   26 32     9   47   14   58
959487 NY Erie   school 3605850 140600010000   BUFFALO 360585000350 140600010059 PS 59 DR CHARLES DREW SCI MAGNET public Regular School No Elementary PK 8 2017   grade_8 9.0 77.0 8.0   1.0     7.0     1.0   61.0 42.0     9       83     30   103 9 77 8   1     7     1   61 42     9   83   30   103
962337 NY Erie   school 3616230 142601030000   KENMORE 361623001410 142601030025 KENMORE EAST SENIOR HIGH SCHOOL public Regular School No High 08 12 2017   grade_8 186.0 22.0 11.0   1.0     5.0     11.0   115.0 121.0     9       105     46   236 186 22 11   1     5     11   115 121     9   105   46   236
966498 NY Kings   school 3601094 331300861056   UNITY PREP CHARTER SCH OF BR 360109406404 331300861056 UNITY PREP CHARTER SCH OF BROOKLYN charter Regular School Yes Other 06 9 2017   grade_8 2.0 74.0 23.0   1.0     2.0         57.0 45.0     9       85     24   102 2 74 23   1     2         57 45     9   85   24   102
973072 NY Kings   school 3600151 332000010000   NYC GEOG DIST #20 - BROOKLYN 360015105955 332000011609 URBAN ASSEMBLY SCH-CRIMINAL JUSTICE public Regular School No Other 06 12 2017   grade_8 8.0 13.0 13.0   0.0     35.0     0.0     69.0     9       *     *   69 8 13 13   0     35     0     69     9           69
973357 NY Kings   school 3600152 332100010000   NYC GEOG DIST #21 - BROOKLYN 360015202702 332100010209 PS 209 MARGARET MEAD public Regular School No Elementary PK 8 2017   grade_8 26.0 1.0 13.0         12.0     0.0   24.0 28.0     9       40     *   52 26 1 13         12     0   24 28     9   40       52
974155 NY Kings   school 3600153 332200010000   NYC GEOG DIST #22 - BROOKLYN 360015302695 332200010206 PS 206 JOSEPH F LAMB public Regular School No Elementary PK 8 2017   grade_8 52.0 4.0 18.0   1.0     46.0     1.0   75.0 47.0     9       92     17   122 52 4 18   1     46     1   75 47     9   92   17   122
975732 NY Kings   school 3600097 333200010000   NYC GEOG DIST #32 - BROOKLYN 360009702000 333200010383 JHS 383 PHILIPPA SCHUYLER public Regular School No Middle 05 08 2017   grade_8 4.0 111.0 164.0   0.0     15.0     0.0   130.0 164.0     9       231     38   294 4 111 164   0     15     0   130 164     9   231   38   294
982439 NY Nassau   school 3621570 280211030000   OCEANSIDE 362157004528 280211030009 SCHOOL 9M-OCEANSIDE MIDDLE SCHOOL public Regular School No Middle 07 08 2017   grade_8 330.0 4.0 67.0   1.0     15.0     15.0   212.0 220.0     9       56     49   432 330 4 67   1     15     15   212 220     9   56   49   432
992224 NY New York   school 3600079 310400010000   NYC GEOG DIST # 4 - MANHATTAN 360007905634 310400010825 ISAAC NEWTON MS FOR MATH & SCI public Regular School No Middle 06 08 2017   grade_8 2.0 22.0 51.0         6.0         43.0 38.0     9       73     *   81 2 22 51         6         43 38     9   73       81
993706 NY New York   school 3600083 310600010000   NYC GEOG DIST # 6 - MANHATTAN 360008302643 310600010187 PS/IS 187 HUDSON CLIFFS public Regular School No Elementary PK 08 2017   grade_8 22.0 1.0 67.0   0.0     2.0     1.0   51.0 42.0     9       65     20   93 22 1 67   0     2     1   51 42     9   65   20   93
998000 NY Onondaga   school 3617520 421501060000   LIVERPOOL 361752001560 421501060002 CHESTNUT HILL MIDDLE SCHOOL public Regular School No Middle 07 08 2017   grade_8 127.0 22.0 11.0   1.0     11.0     3.0   92.0 83.0     9       *     *   175 127 22 11   1     11     3   92 83     9           175
999178 NY Ontario   school 3611970 430700010000   GENEVA 361197000963 430700010005 GENEVA MIDDLE SCHOOL public Regular School No Middle 06 08 2017   grade_8 76.0 16.0 34.0   1.0     3.0     5.0   65.0 70.0     9       79     13   135 76 16 34   1     3     5   65 70     9   79   13   135
1002503 NY Putnam   school 3618120 480101060000   MAHOPAC 361812001625 480101060004 MAHOPAC MIDDLE SCHOOL public Regular School No Middle 06 08 2017   grade_8 270.0 4.0 62.0         10.0     8.0   182.0 172.0     9       45     68   354 270 4 62         10     8   182 172     9   45   68   354
1003320 NY Queens   school 3600098 342400010000   NYC GEOG DIST #24 - QUEENS 360009802442 342400010119 IS 119 GLENDALE (THE) public Regular School No Elementary KG 08 2017   grade_8 105.0 4.0 60.0   0.0     60.0     0.0   116.0 113.0     9       146     24   229 105 4 60   0     60     0   116 113     9   146   24   229
1006265 NY Queens   school 3600123 342700010000   NYC GEOG DIST #27 - QUEENS 360012306127 342700010318 WATERSIDE SCHOOL FOR LEADESHIP public Regular School No Middle 06 08 2017   grade_8 7.0 42.0 22.0   1.0     3.0     0.0   45.0 30.0     9       *     27   75 7 42 22   1     3     0   45 30     9       27   75
1006816 NY Queens   school 3600100 342800010000   NYC GEOG DIST #28 - QUEENS 360010002297 342800010072 CATHERINE & COUNT BASIE MS 72 public Regular School No Middle 06 08 2017   grade_8 1.0 130.0 22.0   10.0     24.0     0.0   116.0 71.0     9       139     49   187 1 130 22   10     24     0   116 71     9   139   49   187
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
1022548 NY Suffolk   school 3631020 580902020000   WESTHAMPTON BEACH 363102004167 580902020004 WESTHAMPTON MIDDLE SCHOOL public Regular School No Middle 06 08 2017   grade_8 122.0 3.0 36.0   1.0     5.0     7.0   91.0 83.0     9       61     30   174 122 3 36   1     5     7   91 83     9   61   30   174
1028210 NY Westchester   school 3618240 660701030000   MAMARONECK 361824001646 660701030005 HOMMOCKS SCHOOL public Regular School No Middle 06 08 2017   grade_8 288.0 14.0 74.0   0.0     18.0     10.0   199.0 205.0     9       73     38   404 288 14 74   0     18     10   199 205     9   73   38   404
1030680 NY Westchester   school 3631920 662300010000   YONKERS 363192004263 662300010019 EUGENIO MARIA DE HOSTOS MICROSOCIETY public Regular School No Elementary PK 08 2017   grade_8 2.0 6.0 49.0   0.0     0.0     0.0   27.0 30.0     9       57     5   57 2 6 49   0     0     0   27 30     9   57   5   57
1030908 NY Westchester   school 3631920 662300010000   YONKERS 363192004249 662300010036 CROSS HILL ACADEMY public Regular School No Elementary PK 08 2017   grade_8 3.0 31.0 40.0   0.0     1.0     1.0   43.0 33.0     9       70     36   76 3 31 40   0     1     1   43 33     9   70   36   76
1434164 NY Albany   school 3613080 10802060000   GUILDERLAND 361308001071 10802060008 FARNSWORTH MIDDLE SCHOOL public Regular School No Middle 06 08 2021   grade_8 278.0 7.0 19.0   1.0     38.0     18.0   174.0 187.0     9       80     47   361 278 7 19   1     38     18   174 187     9   80   47   361
1437052 NY Bronx   school 3600165 320800860903   HYDE LEADERSHIP CHARTER SCHO 360016505889 320800860903 HYDE LEADERSHIP CHARTER SCHOOL charter Regular School Yes Other KG 12 2021   grade_8 0.0 27.0 51.0   0.0     0.0     0.0   48.0 30.0     9       73     20   78 0 27 51   0     0     0   48 30     9   73   20   78
1437926 NY Bronx   school 3600086 320900010000   NYC GEOG DIST # 9 - BRONX 360008605666 320900010327 COMP MODEL SCH PROJECT MS 327 public Regular School No High 06 12 2021   grade_8 0.0 19.0 78.0         0.0     0.0   43.0 54.0     9       88     19   97 0 19 78         0     0   43 54     9   88   19   97
1438686 NY Bronx   school 3601071 320900861004   MOTT HALL CHARTER SCHOOL 360107106328 320900861004 MOTT HALL CHARTER SCHOOL charter Regular School Yes Middle 06 08 2021   grade_8 0.0 46.0 55.0   0.0     1.0         49.0 53.0     9       88     21   102 0 46 55   0     1         49 53     9   88   21   102
1442315 NY Bronx   school 3600090 321200010000   NYC GEOG DIST #12 - BRONX 360009002706 321200010211 PS 211 public Regular School No Elementary PK 08 2021   grade_8 0.0 14.0 46.0   0.0     0.0     0.0   29.0 31.0     9       54     19   60 0 14 46   0     0     0   29 31     9   54   19   60
1442486 NY Bronx   school 3600090 321200010000   NYC GEOG DIST #12 - BRONX 360009004878 321200010318 IS 318 MATH, SCIENCE & TECH THRO ART public Regular School No Middle 06 08 2021   grade_8 1.0 27.0 41.0   0.0     0.0     0.0   39.0 30.0     9       69     23   69 1 27 41   0     0     0   39 30     9   69   23   69
1448604 NY Dutchess   school 3615180 130801060000   HYDE PARK 361518001270 130801060006 HAVILAND MIDDLE SCHOOL public Regular School No Middle 06 08 2021   grade_8 165.0 25.0 60.0   0.0     3.0     14.0   139.0 128.0     9       133     49   267 165 25 60   0     3     14   139 128     9   133   49   267
1457876 NY Kings   school 3600119 331400010000   NYC GEOG DIST #14 - BROOKLYN 360011902467 331400010126 JOHN ERICSSON MIDDLE SCHOOL 126 public Regular School No Middle 06 08 2021   grade_8 4.0 19.0 81.0         0.0     0.0   67.0 37.0     9       90     27   104 4 19 81         0     0   67 37     9   90   27   104
1463728 NY Kings   school 3600151 332000010000   NYC GEOG DIST #20 - BROOKLYN 360015102657 332000010192 PS 192 MAGNET SCHOOL-MATH AND SCI public Regular School No Elementary PK 08 2021   grade_8 22.0 0.0 30.0   0.0     8.0     0.0   33.0 27.0     9       49     18   60 22 0 30   0     8     0   33 27     9   49   18   60
1464203 NY Kings   school 3600151 332000010000   NYC GEOG DIST #20 - BROOKLYN 360015105955 332000011609 URBAN ASSEMBLY SCHL-LEADER-EMPOWER public Regular School No High 06 12 2021   grade_8 12.0 6.0 18.0   0.0     35.0     1.0     72.0     9       61     13   72 12 6 18   0     35     1     72     9   61   13   72
1475242 NY Nassau   school 3626520 280252070000   SEWANHAKA 362652003626 280252070002 ELMONT MEMORIAL HIGH SCHOOL public Regular School No High 07 12 2021   grade_8 5.0 143.0 50.0   0.0     36.0     9.0   128.0 115.0     9       165     29   243 5 143 50   0     36     9   128 115     9   165   29   243
1475280 NY Nassau   school 3626520 280252070000   SEWANHAKA 362652003628 280252070004 H FRANK CAREY HIGH SCHOOL public Regular School No High 07 12 2021   grade_8 189.0 5.0 66.0   2.0     41.0     6.0   158.0 151.0     9       72     35   309 189 5 66   2     41     6   158 151     9   72   35   309
1477199 NY Nassau   school 3615810 280515030000   JERICHO 361581001369 280515030006 JERICHO MIDDLE SCHOOL public Regular School No Middle 06 08 2021   grade_8 87.0 9.0 5.0         167.0     3.0   152.0 119.0     9       38     25   271 87 9 5         167     3   152 119     9   38   25   271
1478073 NY New York   school 3600135 307500010000   NYC SPEC SCHOOLS - DIST 75 360013503373 307500012017 PS 17 public Special Education School No Other KG 12 2021   grade_8 1.0 20.0 43.0   1.0     3.0         51.0 17.0     9       62     68   68 1 20 43   1     3         51 17     9   62   68   68
1478947 NY New York   school 3600135 307500010000   NYC SPEC SCHOOLS - DIST 75 360013500957 307500015373 PS 373 public Special Education School No Elementary PK 08 2021   grade_8 5.0 9.0 18.0   0.0     0.0     0.0   22.0 10.0     9       32     32   32 5 9 18   0     0     0   22 10     9   32   32   32
1479308 NY New York   school 3600076 310100010000   NYC GEOG DIST # 1 - MANHATTAN 360007606021 310100010378 SCHOOL FOR GLOBAL LEADERS public Regular School No Middle 06 08 2021   grade_8 9.0 12.0 36.0   0.0     7.0     1.0   40.0 25.0     9       52     21   65 9 12 36   0     7     1   40 25     9   52   21   65
1480562 NY New York   school 3600077 310200010000   NYC GEOG DIST # 2 - MANHATTAN 360007706462 310200010933 CITY KNOLL MIDDLE SCHOOL public Regular School No Middle 06 08 2021   grade_8 4.0 7.0 25.0   0.0     3.0         24.0 15.0     9       34     13   39 4 7 25   0     3         24 15     9   34   13   39
1483032 NY New York   school 3600079 310400010000   NYC GEOG DIST # 4 - MANHATTAN 360007902294 310400010072 LEXINGTON ACADEMY (THE) public Regular School No Elementary PK 08 2021   grade_8 3.0 15.0 57.0   3.0     1.0     2.0   44.0 37.0     9       77     29   81 3 15 57   3     1     2   44 37     9   77   29   81
1484970 NY New York   school 3600083 310600010000   NYC GEOG DIST # 6 - MANHATTAN 360008305642 310600010278 PAULA HEDBAVNY SCHOOL public Regular School No Elementary KG 08 2021   grade_8 7.0 0.0 58.0         0.0     2.0   26.0 41.0     9       48     20   67 7 0 58         0     2   26 41     9   48   20   67
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
1494280 NY Queens   school 3600098 342400010000   NYC GEOG DIST #24 - QUEENS 360009802386 342400010102 PS 102 BAYVIEW public Regular School No Elementary PK 08 2021   grade_8 3.0 4.0 41.0   2.0     92.0     0.0   72.0 70.0     9       113     11   142 3 4 41   2     92     0   72 70     9   113   11   142
1497548 NY Queens   school 3600123 342700010000   NYC GEOG DIST #27 - QUEENS 360012305731 342700011262 CHANNEL VIEW SCHOOL FOR RESEARCH public Regular School No High 06 12 2021   grade_8 15.0 51.0 60.0   4.0     12.0     3.0   78.0 67.0     9       107     19   145 15 51 60   4     12     3   78 67     9   107   19   145
1497605 NY Queens   school 3600123 342700010000   NYC GEOG DIST #27 - QUEENS 360012306079 342700011309 ACADEMY OF MEDICAL TECHNOLOGY public Regular School No High 06 12 2021   grade_8 1.0 33.0 34.0   1.0     3.0     0.0   36.0 36.0     9       58     11   72 1 33 34   1     3     0   36 36     9   58   11   72
1508872 NY Suffolk   school 3628200 580201060000   THREE VILLAGE 362820003807 580201060010 ROBERT CUSHMAN MURPHY JR HIGH SCHOOL public Regular School No Middle 07 09 2021   grade_8 166.0 6.0 26.0         48.0     7.0   129.0 124.0     9       38     36   253 166 6 26         48     7   129 124     9   38   36   253
1510145 NY Suffolk   school 3622470 580224030000   PATCHOGUE-MEDFORD 362247003167 580224030011 SAXTON MIDDLE SCHOOL public Regular School No Middle 06 08 2021   grade_8 75.0 6.0 70.0   0.0     5.0     4.0   90.0 70.0     9       91     25   160 75 6 70   0     5     4   90 70     9   91   25   160
1511380 NY Suffolk   school 3613620 580406060000   HARBORFIELDS 361362001116 580406060005 OLDFIELD MIDDLE SCHOOL public Regular School No Middle 06 08 2021   grade_8 183.0 11.0 41.0   0.0     18.0     12.0   134.0 131.0     9       43     47   265 183 11 41   0     18     12   134 131     9   43   47   265
1513812 NY Suffolk   school 3631020 580902020000   WESTHAMPTON BEACH 363102004167 580902020004 WESTHAMPTON MIDDLE SCHOOL public Regular School No Middle 06 08 2021   grade_8 103.0 3.0 54.0   0.0     2.0     5.0   84.0 83.0     9       55     19   167 103 3 54   0     2     5   84 83     9   55   19   167
1518372 NY Westchester   school 3610080 660301030000   EASTCHESTER 361008000784 660301030005 EASTCHESTER MIDDLE SCHOOL public Regular School No Secondary 06 11 2021   grade_8 158.0 4.0 29.0   0.0     35.0     15.0   141.0 100.0     9       *     38   241 158 4 29   0     35     15   141 100     9       38   241
1526561 NY Bronx   school 3600085 320800010000   NYC GEOG DIST # 8 - BRONX 360008505986 320800010375 BRONX MATHEMATICS PREP SCH (THE) public Regular School No Middle 06 08 2020   grade_8 0.0 23.0 47.0   0.0     5.0         42.0 33.0     9       75     35   75 0 23 47   0     5         42 33     9   75   35   75
1526808 NY Bronx   school 3600085 320800010000   NYC GEOG DIST # 8 - BRONX 360008505985 320800011367 ARCHIMEDES ACAD-MATH, SCI, TECH public Regular School No High 06 12 2020   grade_8 2.0 31.0 52.0   0.0     13.0     0.0   51.0 47.0     9       85     29   98 2 31 52   0     13     0   51 47     9   85   29   98
1528309 NY Bronx   school 3600086 320900010000   NYC GEOG DIST # 9 - BRONX 360008605865 320900011324 BRONX EARLY COL ACAD-TEACH/LEARN public Regular School No High 06 12 2020   grade_8 2.0 19.0 38.0   0.0     1.0         28.0 32.0     9       52     13   60 2 19 38   0     1         28 32     9   52   13   60
1528461 NY Bronx   school 3600086 320900010000   NYC GEOG DIST # 9 - BRONX 360008602961 320900011505 BRONX SCHOOL FOR LAW, GOV, JUSTICE public Regular School No High 06 12 2020   grade_8 0.0 16.0 66.0   3.0     1.0     1.0   41.0 46.0     9       *     23   87 0 16 66   3     1     1   41 46     9       23   87
1532451 NY Bronx   school 3600090 321200010000   NYC GEOG DIST #12 - BRONX 360009004878 321200010318 IS 318 MATH, SCIENCE & TECH THRO ART public Regular School No Middle 06 08 2020   grade_8 0.0 31.0 47.0                   43.0 35.0     9       73     22   78 0 31 47                   43 35     9   73   22   78
1540203 NY Erie   school 3628500 140207060000   SWEET HOME 362850003831 140207060005 SWEET HOME MIDDLE SCHOOL public Regular School No Middle 06 08 2020   grade_8 166.0 60.0 19.0         19.0     9.0   149.0 124.0     9       142     34   273 166 60 19         19     9   149 124     9   142   34   273
1555156 NY Kings   school 3600153 332200010000   NYC GEOG DIST #22 - BROOKLYN 360015302007 332200010078 JHS 78 ROY H MANN public Regular School No Middle 06 08 2020   grade_8 31.0 127.0 20.0   0.0     13.0     1.0   104.0 88.0     9       134     53   192 31 127 20   0     13     1   104 88     9   134   53   192
1558538 NY Monroe   school 3611880 260401060000   GATES CHILI 361188000951 260401060004 GATES-CHILI MIDDLE SCHOOL public Regular School No Middle 06 08 2020   grade_8 151.0 39.0 37.0   1.0     17.0     37.0   130.0 152.0     9       148     30   282 151 39 37   1     17     37   130 152     9   148   30   282
1567354 NY Nassau   school 3615810 280515030000   JERICHO 361581001369 280515030006 JERICHO MIDDLE SCHOOL public Regular School No Middle 06 08 2020   grade_8 93.0 7.0 6.0         169.0     2.0   147.0 130.0     9       *     40   277 93 7 6         169     2   147 130     9       40   277
1568285 NY New York   school 3600135 307500010000   NYC SPEC SCHOOLS - DIST 75 360013504468 307500012186 PS 186 WALTER J DAMROSCH SCHOOL public Special Education School No Other KG 11 2020   grade_8 0.0 23.0 25.0   1.0     1.0     0.0   45.0 5.0     9       47     50   50 0 23 25   1     1     0   45 5     9   47   50   50
1570736 NY New York   school 3600077 310200010000   NYC GEOG DIST # 2 - MANHATTAN 360007706462 310200010933 CITY KNOLL MIDDLE SCHOOL public Regular School No Middle 06 08 2020   grade_8 3.0 17.0 31.0   1.0     6.0     1.0   40.0 19.0     9       41     16   59 3 17 31   1     6     1   40 19     9   41   16   59
1573111 NY New York   school 3600079 310400010000   NYC GEOG DIST # 4 - MANHATTAN 360007902061 310400010007 PS 7 SAMUEL STERN public Regular School No Elementary PK 08 2020   grade_8 1.0 19.0 39.0   1.0     5.0     1.0   38.0 28.0     9       63     29   66 1 19 39   1     5     1   38 28     9   63   29   66
1573396 NY New York   school 3600079 310400010000   NYC GEOG DIST # 4 - MANHATTAN 360007902694 310400010206 PS 206 JOSE CELSO BARBOSA public Regular School No Middle 03 08 2020   grade_8 3.0 16.0 54.0   0.0     1.0     1.0   41.0 34.0     9       63     34   75 3 16 54   0     1     1   41 34     9   63   34   75
1573947 NY New York   school 3600081 310500010000   NYC GEOG DIST # 5 - MANHATTAN 360008102455 310500010123 PS 123 MAHALIA JACKSON public Regular School No Elementary PK 08 2020   grade_8 0.0 41.0 20.0   2.0     2.0     0.0   41.0 24.0     9       61     22   65 0 41 20   2     2     0   41 24     9   61   22   65
1574479 NY New York   school 3600158 310500860894   DEMOCRACY PREP CHARTER SCHOO 360015805847 310500860894 DEMOCRACY PREP CHARTER SCHOOL charter Regular School Yes High 06 12 2020   grade_8 1.0 82.0 34.0   1.0     0.0     1.0   61.0 58.0     9       99     28   119 1 82 34   1     0     1   61 58     9   99   28   119
1581129 NY Orange   school 3623010 440401060000   PINE BUSH 362301003224 440401060007 CIRCLEVILLE MIDDLE SCHOOL public Regular School No Middle 06 08 2020   grade_8 74.0 39.0 51.0   1.0     6.0     9.0   85.0 95.0     9       107     18   180 74 39 51   1     6     9   85 95     9   107   18   180
1604328 NY Suffolk   school 3627620 581005020000   SOUTHOLD 362762003751 581005020003 SOUTHOLD JUNIOR-SENIOR HIGH SCHOOL public Regular School No High 07 12 2020   grade_8 47.0 0.0 28.0         1.0     2.0   31.0 47.0     9       33     11   78 47 0 28         1     2   31 47     9   33   11   78
1611814 NY Westchester   school 3631920 662300010000   YONKERS 363192001077 662300010002 FAMILY SCHOOL 32 public Regular School No Elementary PK 08 2020   grade_8 14.0 9.0 44.0   1.0     7.0     0.0   37.0 38.0     9       66     29   75 14 9 44   1     7     0   37 38     9   66   29   75
1612099 NY Westchester   school 3631920 662300010000   YONKERS 363192004266 662300010023 SCHOOL 23 public Regular School No Elementary PK 08 2020   grade_8 6.0 12.0 38.0   1.0     2.0     0.0   28.0 31.0     9       58     *   59 6 12 38   1     2     0   28 31     9   58       59
2052026 NY Bronx   school 3601001 320700860957   ACADEMIC LEADERSHIP CHARTER 360100106154 320700860957 ACADEMIC LEADERSHIP CHARTER SCHOOL charter Regular School Yes Elementary PK 08 2018   grade_8 2.0 42.0 38.0   1.0     0.0     0.0   36.0 47.0     9       67     7   83 2 42 38   1     0     0   36 47     9   67   7   83
2058657 NY Bronx   school 3600090 321200010000   NYC GEOG DIST #12 - BRONX 360009005970 321200010372 URBAN ASSEMBLY-WILDLIFE CONSERVATION public Regular School No High 06 12 2018   grade_8 2.0 20.0 48.0   0.0     2.0     0.0   31.0 41.0     9       66     19   72 2 20 48   0     2     0   31 41     9   66   19   72
2066637 NY Erie   school 3605850 140600010000   BUFFALO 360585000332 140600010031 HARRIET ROSS TUBMAN ACADEMY public Regular School No Elementary PK 08 2018   grade_8 4.0 25.0 3.0   0.0     6.0     1.0   17.0 22.0     9       37     *   39 4 25 3   0     6     1   17 22     9   37       39
2067720 NY Erie   school 3600105 140600860861   BUFFALO ACAD-SCI CHARTER SCH 360010505602 140600860861 BUFFALO ACAD-SCI CHARTER SCHOOL charter Regular School Yes Other 05 12 2018   grade_8 11.0 42.0 4.0   0.0     16.0     0.0   41.0 32.0     9       63     10   73 11 42 4   0     16     0   41 32     9   63   10   73
2075453 NY Kings   school 3600092 331500010000   NYC GEOG DIST #15 - BROOKLYN 360009206567 331500010839 MS 839 public Regular School No Middle 06 08 2018   grade_8 34.0 17.0 35.0   2.0     16.0     1.0   64.0 41.0     9       54     31   105 34 17 35   2     16     1   64 41     9   54   31   105
2075985 NY Kings   school 3600094 331600010000   NYC GEOG DIST #16 - BROOKLYN 360009402499 331600010057 JHS 57 WHITELAW REID public Regular School No Middle 06 08 2018   grade_8 3.0 51.0 23.0         3.0     0.0   46.0 34.0     9       75     29   80 3 51 23         3     0   46 34     9   75   29   80
2077733 NY Kings   school 3600096 331800010000   NYC GEOG DIST #18 - BROOKLYN 360009602707 331800010211 IS 211 JOHN WILSON public Regular School No Middle 06 08 2018   grade_8 2.0 155.0 19.0   0.0     2.0     1.0   91.0 88.0     9       157     43   179 2 155 19   0     2     1   91 88     9   157   43   179
2078930 NY Kings   school 3600120 331900010000   NYC GEOG DIST #19 - BROOKLYN 360012006418 331900010661 VISTA ACADEMY public Regular School No Middle 06 08 2018   grade_8 5.0 31.0 78.0   5.0     5.0     0.0   51.0 73.0     9       *     *   124 5 31 78   5     5     0   51 73     9           124
2079006 NY Kings   school 3600120 331900010000   NYC GEOG DIST #19 - BROOKLYN 360012006100 331900010678 EAST NEW YORK MIDDLE SCH-EXCELLENCE public Regular School No Middle 06 08 2018   grade_8 1.0 42.0 31.0   0.0     1.0         29.0 46.0     9       *     *   75 1 42 31   0     1         29 46     9           75
2079462 NY Kings   school 3601050 331900860997   INVICTUS PREPARATORY CHARTER 360105006293 331900860997 INVICTUS PREPARATORY CHARTER SCHOOL charter Regular School Yes Middle 05 08 2018   grade_8 0.0 66.0 21.0   1.0     3.0     0.0   54.0 37.0     9       71     20   91 0 66 21   1     3     0   54 37     9   71   20   91

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