enrollments

Data source: Big Local News · About: Big Local

33,145 rows where grade = "grade_7" and state = "NY" sorted by ell descending

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

grade ✖

  • grade_7 · 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
1003338 1003338 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_7 28.0 7.0 259.0   4.0     228.0     0.0   277.0 249.0     97       265     87   526 28 7 259   4     228     0   277 249     97   265   87   526
1439730 1439730 NY Bronx   school 3600087 321000010000   NYC GEOG DIST #10 - BRONX 360008706297 321000010363 ACAD-PERSONAL LDSHP AND EXCELLENCE public Regular School No Middle 06 08 2021   grade_7 6.0 37.0 246.0   5.0     10.0     0.0   169.0 135.0     96       283     73   304 6 37 246   5     10     0   169 135     96   283   73   304
1021597 1021597 NY Suffolk   school 3605280 580512030000   BRENTWOOD 360528000263 580512030015 WEST MIDDLE SCHOOL public Regular School No Middle 06 08 2017   grade_7 31.0 39.0 213.0   1.0     9.0     3.0   149.0 147.0     95       253     51   296 31 39 213   1     9     3   149 147     95   253   51   296
1497148 1497148 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_7 12.0 25.0 341.0   14.0     161.0     5.0   304.0 254.0     95       439     *   558 12 25 341   14     161     5   304 254     95   439       558
1593744 1593744 NY Rockland   school 3614010 500201060000   HAVERSTRAW-STONY POINT 361401005738 500201060013 FIELDSTONE MIDDLE SCHOOL public Regular School No Middle 07 08 2020   grade_7 179.0 85.0 398.0   1.0     20.0     6.0   343.0 346.0     93       389     104   689 179 85 398   1     20     6   343 346     93   389   104   689
1495552 1495552 NY Queens   school 3600122 342500010000   NYC GEOG DIST #25 - QUEENS 360012201996 342500010237 IS 237 public Regular School No Middle 06 08 2021   grade_7 2.0 19.0 83.0   0.0     338.0     2.0   246.0 198.0     92       340     67   444 2 19 83   0     338     2   246 198     92   340   67   444
2181510 2181510 NY Nassau   school 3630960 280401030000   WESTBURY 363096004161 280401030006 WESTBURY MIDDLE SCHOOL public Regular School No Middle 06 08 2019   grade_7 5.0 77.0 279.0         7.0         205.0 163.0     91       335     50   368 5 77 279         7         205 163     91   335   50   368
1002863 1002863 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_7 18.0 8.0 308.0   0.0     288.0     2.0   308.0 316.0     90       368     98   624 18 8 308   0     288     2   308 316     90   368   98   624
1499390 1499390 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 2021   grade_7 8.0 109.0 129.0   28.0     124.0     5.0   220.0 183.0     90       294     69   403 8 109 129   28     124     5   220 183     90   294   69   403
2091830 2091830 NY Nassau   school 3630960 280401030000   WESTBURY 363096004161 280401030006 WESTBURY MIDDLE SCHOOL public Regular School No Middle 06 08 2018   grade_7 6.0 83.0 262.0   0.0     4.0     0.0   181.0 174.0     90       308     34   355 6 83 262   0     4     0   181 174     90   308   34   355
2209953 2209953 NY Rockland   school 3627810 500402060000   EAST RAMAPO 362781003778 500402060015 POMONA MIDDLE SCHOOL public Regular School No Middle 07 08 2019   grade_7 4.0 69.0 172.0         9.0     0.0   131.0 123.0     90       229     65   254 4 69 172         9     0   131 123     90   229   65   254
943792 943792 NY Bronx   school 3600084 320700010000   NYC GEOG DIST # 7 - BRONX 360008402138 320700010029 PS/MS 29 MELROSE SCHOOL public Regular School No Elementary PK 08 2017   grade_7 1.0 19.0 57.0   0.0     2.0     0.0   35.0 44.0     9       75     20   79 1 19 57   0     2     0   35 44     9   75   20   79
947022 947022 NY Bronx   school 3600086 320900010000   NYC GEOG DIST # 9 - BRONX 360008606345 320900010568 YOUNG WOMEN'S LDSHP SCHOOL-BRONX public Regular School No Other 06 12 2017   grade_7 1.0 34.0 44.0   1.0     2.0     0.0     82.0     9       70     15   82 1 34 44   1     2     0     82     9   70   15   82
947345 947345 NY Bronx   school 3600086 320900010000   NYC GEOG DIST # 9 - BRONX 360008605177 320900011413 BRONX HIGH SCHOOL FOR MEDICAL SCIE public Regular School No Other 06 12 2017   grade_7 1.0 15.0 34.0   0.0     3.0     0.0   30.0 23.0     9       44     10   53 1 15 34   0     3     0   30 23     9   44   10   53
951012 951012 NY Bronx   school 3600090 321200010000   NYC GEOG DIST #12 - BRONX 360009005166 321200010190 ESMT-IS 190 public Regular School No Middle 06 08 2017   grade_7 1.0 15.0 62.0   2.0     1.0         35.0 46.0     9       70     *   81 1 15 62   2     1         35 46     9   70       81
951297 951297 NY Bronx   school 3600090 321200010000   NYC GEOG DIST #12 - BRONX 360009005970 321200010372 URBAN ASSEMBLY-WILDLIFE CONSERVATION public Regular School No Other 06 12 2017   grade_7 2.0 21.0 48.0   0.0     1.0     0.0   36.0 36.0     9       60     20   72 2 21 48   0     1     0   36 36     9   60   20   72
951487 951487 NY Bronx   school 3600090 321200010000   NYC GEOG DIST #12 - BRONX 360009005679 321200011271 EAST BRONX ACADEMY FOR THE FUTURE public Regular School No Other 06 12 2017   grade_7 0.0 22.0 63.0   1.0     0.0     1.0   40.0 47.0     9       80     26   87 0 22 63   1     0     1   40 47     9   80   26   87
961766 961766 NY Erie   school 3600067 141800860044   GLOBAL CONCEPTS CHARTER SCHOO 360006704861 141800860044 GLOBAL CONCEPTS CHARTER SCHOOL charter Regular School Yes Other KG 12 2017   grade_7 49.0 18.0 7.0         1.0     0.0   30.0 45.0     9       65     7   75 49 18 7         1     0   30 45     9   65   7   75
966041 966041 NY Kings   school 3600091 331300010000   NYC GEOG DIST #13 - BROOKLYN 360009106205 331300010691 FORT GREEN PREPARATORY ACADEMY public Regular School No Middle 06 8 2017   grade_7 6.0 43.0 21.0   1.0     4.0         42.0 33.0     9       61     24   75 6 43 21   1     4         42 33     9   61   24   75
980405 980405 NY Monroe   school 3630360 261901060000   WEBSTER 363036001207 261901060007 SPRY MIDDLE SCHOOL public Regular School No Middle 06 08 2017   grade_7 288.0 7.0 26.0   0.0     14.0     3.0   176.0 162.0     9       72     33   338 288 7 26   0     14     3   176 162     9   72   33   338
982438 982438 NY Nassau   school 3621570 280211030000   OCEANSIDE 362157004528 280211030009 SCHOOL 9M-OCEANSIDE MIDDLE SCHOOL public Regular School No Middle 07 08 2017   grade_7 374.0 7.0 71.0   0.0     13.0     4.0   246.0 223.0     9       59     56   469 374 7 71   0     13     4   246 223     9   59   56   469
988005 988005 NY New York   school 3600076 310100010000   NYC GEOG DIST # 1 - MANHATTAN 360007603508 310100010184 PS 184 SHUANG WEN public Regular School No Elementary PK 08 2017   grade_7 6.0 3.0 9.0   3.0     65.0     2.0   47.0 41.0     9       62     20   88 6 3 9   3     65     2   47 41     9   62   20   88
991900 991900 NY New York   school 3600079 310400010000   NYC GEOG DIST # 4 - MANHATTAN 360007902294 310400010072 LEXINGTON ACADEMY (THE) public Regular School No Elementary PK 08 2017   grade_7 1.0 9.0 74.0   0.0     2.0     0.0   46.0 40.0     9       70     20   86 1 9 74   0     2     0   46 40     9   70   20   86
992660 992660 NY New York   school 3600081 310500010000   NYC GEOG DIST # 5 - MANHATTAN 360008102455 310500010123 PS 123 MAHALIA JACKSON public Regular School No Elementary PK 08 2017   grade_7 2.0 31.0 18.0   0.0     2.0     0.0   31.0 22.0     9       45     16   53 2 31 18   0     2     0   31 22     9   45   16   53
994351 994351 NY New York   school 3601075 310600861013   KIPP NYC WASHINGTON HEIGHTS 360107506307 310600861013 KIPP NYC WASHINGTON HEIGHTS CHARTER charter Regular School Yes Other KG 09 2017   grade_7 0.0 11.0 68.0   0.0     1.0     1.0   43.0 38.0     9       76     13   81 0 11 68   0     1     1   43 38     9   76   13   81
996498 996498 NY Oneida   school 3601084 412300861058   UTICA ACADEMY OF SCIENCE CHA 360108406447 412300861058 UTICA ACADEMY OF SCIENCE CHARTER SCH charter Regular School Yes Other 06 12 2017   grade_7 49.0 17.0 0.0   12.0     9.0     7.0   46.0 48.0     9       80     5   94 49 17 0   12     9     7   46 48     9   80   5   94
1008126 1008126 NY Queens   school 3600101 342900010000   NYC GEOG DIST #29 - QUEENS 360010102659 342900010192 IS 192 LINDEN (THE) public Regular School No Middle 06 08 2017   grade_7 4.0 111.0 10.0   4.0     2.0     1.0   72.0 60.0     9       91     33   132 4 111 10   4     2     1   72 60     9   91   33   132
1012705 1012705 NY Rockland   school 3628320 500401060000   RAMAPO 362832003817 500401060011 SUFFERN MIDDLE SCHOOL public Regular School No Middle 06 08 2017   grade_7 249.0 24.0 65.0   1.0     19.0     9.0   188.0 179.0     9       91     76   367 249 24 65   1     19     9   188 179     9   91   76   367
1016771 1016771 NY Suffolk   school 3630540 580102030000   WEST BABYLON 363054004105 580102030007 WEST BABYLON JUNIOR HIGH SCHOOL public Regular School No Middle 06 08 2017   grade_7 214.0 33.0 65.0   1.0     24.0     6.0   178.0 165.0     9       134     74   343 214 33 65   1     24     6   178 165     9   134   74   343
1019355 1019355 NY Suffolk   school 3627900 580304020000   SPRINGS 362790003787 580304020001 SPRINGS SCHOOL public Regular School No Elementary PK 08 2017   grade_7 28.0 0.0 40.0         1.0     1.0   34.0 36.0     9       10     9   70 28 0 40         1     1   34 36     9   10   9   70
1022661 1022661 NY Suffolk   school 3627540 580906030000   SOUTHAMPTON 362754003744 580906030002 SOUTHAMPTON INTERMEDIATE SCHOOL public Regular School No Elementary KG 08 2017   grade_7 63.0 7.0 43.0   4.0     2.0         70.0 49.0     9       48     16   119 63 7 43   4     2         70 49     9   48   16   119
1023136 1023136 NY Sullivan   school 3617220 590901060000   LIBERTY 361722001539 590901060006 LIBERTY MIDDLE/HIGH SCHOOL public Regular School No Other 05 12 2017   grade_7 46.0 5.0 36.0         3.0     7.0   55.0 42.0     9       61     19   97 46 5 36         3     7   55 42     9   61   19   97
1030204 1030204 NY Westchester   school 3625950 662001030000   SCARSDALE 362595003565 662001030011 SCARSDALE MIDDLE SCHOOL public Regular School No Middle 06 08 2017   grade_7 273.0 5.0 24.0   0.0     73.0     20.0   216.0 179.0     9             41   395 273 5 24   0     73     20   216 179     9       41   395
1030451 1030451 NY Westchester   school 3631920 662300010000   YONKERS 363192001077 662300010002 FAMILY SCHOOL 32 public Regular School No Elementary PK 08 2017   grade_7 12.0 19.0 45.0   0.0     2.0     2.0   46.0 34.0     9       72     42   80 12 19 45   0     2     2   46 34     9   72   42   80
1031021 1031021 NY Westchester   school 3631920 662300010000   YONKERS 363192004853 662300010045 CEDAR PLACE ELEMENTARY SCHOOL public Regular School No Elementary PK 08 2017   grade_7 4.0 7.0 49.0   0.0     0.0     0.0   33.0 27.0     9       57     15   60 4 7 49   0     0     0   33 27     9   57   15   60
1433840 1433840 NY Albany   school 3627210 10601060000   SOUTH COLONIE 362721003710 10601060012 SAND CREEK MIDDLE SCHOOL public Regular School No Middle 05 08 2021   grade_7 122.0 13.0 20.0         25.0     11.0   89.0 102.0     9       86     31   191 122 13 20         25     11   89 102     9   86   31   191
1435664 1435664 NY Bronx   school 3601070 320700861028   FAMILY LIFE ACADEMY CHARTER 360107006318 320700861028 FAMILY LIFE ACADEMY CHARTER SCH II charter Regular School Yes Elementary KG 08 2021   grade_7 0.0 41.0 99.0   1.0     1.0     0.0   62.0 80.0     9       132     20   142 0 41 99   1     1     0   62 80     9   132   20   142
1436538 1436538 NY Bronx   school 3600085 320800010000   NYC GEOG DIST # 8 - BRONX 360008505982 320800010371 URBAN INSTITUTE OF MATHEMATICS public Regular School No Middle 06 08 2021   grade_7 24.0 8.0 80.0   3.0     4.0     1.0   48.0 72.0     9       87     33   120 24 8 80   3     4     1   48 72     9   87   33   120
1441136 1441136 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 2021   grade_7 7.0 220.0 76.0   6.0     17.0     4.0   160.0 170.0     9       235     65   330 7 220 76   6     17     4   160 170     9   235   65   330
1441459 1441459 NY Bronx   school 3600088 321100010000   NYC GEOG DIST #11 - BRONX 360008806322 321100010566 PELHAM GARDENS MIDDLE SCHOOL public Regular School No Middle 06 08 2021   grade_7 3.0 84.0 32.0   2.0     6.0         61.0 66.0     9       106     33   127 3 84 32   2     6         61 66     9   106   33   127
1442390 1442390 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 2021   grade_7 1.0 13.0 40.0   0.0     0.0     0.0   29.0 25.0     9       50     17   54 1 13 40   0     0     0   29 25     9   50   17   54
1447596 1447596 NY Columbia   school 3615210 101401040000   KINDERHOOK 361521001277 101401040006 ICHABOD CRANE MIDDLE SCHOOL public Regular School No Middle 04 08 2021   grade_7 105.0 1.0 18.0         2.0     3.0   63.0 66.0     9       46     20   129 105 1 18         2     3   63 66     9   46   20   129
1450788 1450788 NY Erie   school 3605850 140600010000   BUFFALO 360585000369 140600010081 PS 81 public Regular School No Elementary PK 08 2021   grade_7 21.0 28.0 15.0   0.0     5.0     7.0   43.0 33.0     9       51     13   76 21 28 15   0     5     7   43 33     9   51   13   76
1457875 1457875 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_7 1.0 24.0 53.0         3.0     2.0   41.0 42.0     9       75     29   83 1 24 53         3     2   41 42     9   75   29   83
1462701 1462701 NY Kings   school 3600120 331900010000   NYC GEOG DIST #19 - BROOKLYN 360012006417 331900010654 VAN SICLEN COMMUNITY MIDDLE SCHOOL public Regular School No Middle 06 08 2021   grade_7 0.0 53.0 28.0         2.0         43.0 40.0     9       77     27   83 0 53 28         2         43 40     9   77   27   83
1464297 1464297 NY Kings   school 3600152 332100010000   NYC GEOG DIST #21 - BROOKLYN 360015203011 332100010098 IS 98 BAY ACADEMY public Regular School No Middle 06 08 2021   grade_7 279.0 12.0 42.0   3.0     162.0     30.0   251.0 277.0     9       270     59   528 279 12 42   3     162     30   251 277     9   270   59   528
1467128 1467128 NY Kings   school 3601017 333200860987   BUSHWICK ASCEND CHARTER SCHO 360101706172 333200860987 BUSHWICK ASCEND CHARTER SCHOOL charter Regular School Yes Elementary KG 08 2021   grade_7 0.0 18.0 66.0   1.0     0.0     0.0   46.0 39.0     9       69     21   85 0 18 66   1     0     0   46 39     9   69   21   85
1469560 1469560 NY Monroe   school 3622710 261201060000   PENFIELD 362271003191 261201060008 BAY TRAIL MIDDLE SCHOOL public Regular School No Middle 06 08 2021   grade_7 282.0 10.0 20.0         12.0     25.0   184.0 165.0     9       78     35   349 282 10 20         12     25   184 165     9   78   35   349
1470681 1470681 NY Monroe   school 3624750 261600010000   ROCHESTER 362475006076 261600010068 JOSEPH C WILSON FOUNDATION ACADEMY public Regular School No Elementary KG 08 2021   grade_7 1.0 67.0 14.0   0.0     2.0     1.0   46.0 39.0     9       80     22   85 1 67 14   0     2     1   46 39     9   80   22   85
1470947 1470947 NY Monroe   school 3600026 261600860811   EUGENIO MARIA DE HOSTOS CHART 360002604363 261600860811 EUGENIO MARIA DE HOSTOS CHARTER SCHO charter Regular School Yes Other KG 12 2021   grade_7 2.0 11.0 39.0   1.0           0.0   30.0 23.0     9       41     *   53 2 11 39   1           0   30 23     9   41       53
1471517 1471517 NY Monroe   school 3630360 261901060000   WEBSTER 363036004081 261901060010 WILLINK MIDDLE SCHOOL public Regular School No Middle 06 08 2021   grade_7 249.0 12.0 21.0   1.0     12.0     8.0   134.0 169.0     9       89     30   303 249 12 21   1     12     8   134 169     9   89   30   303
1478718 1478718 NY New York   school 3600135 307500010000   NYC SPEC SCHOOLS - DIST 75 360013504354 307500014177 PS 177 public Special Education School No Elementary KG 08 2021   grade_7 8.0 3.0 7.0   0.0     9.0     0.0   18.0 9.0     9       19     27   27 8 3 7   0     9     0   18 9     9   19   27   27
1478946 1478946 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_7 7.0 9.0 11.0   0.0     0.0     0.0   21.0 6.0     9       23     27   27 7 9 11   0     0     0   21 6     9   23   27   27
1483012 1483012 NY New York   school 3600079 310400010000   NYC GEOG DIST # 4 - MANHATTAN 360007902246 310400010057 JAMES WELDON JOHNSON SCHOOL public Regular School No Elementary PK 08 2021   grade_7 0.0 25.0 60.0   0.0     3.0     0.0   47.0 41.0     9       76     29   88 0 25 60   0     3     0   47 41     9   76   29   88
1483278 1483278 NY New York   school 3600079 310400010000   NYC GEOG DIST # 4 - MANHATTAN 360007906003 310400010372 ESPERANZA PREPARATORY ACADEMY public Regular School No High 06 12 2021   grade_7 0.0 19.0 43.0   0.0     1.0     0.0   27.0 36.0     9       59     22   63 0 19 43   0     1     0   27 36     9   59   22   63
1484418 1484418 NY New York   school 3601078 310500861001   DEMOCRACY PREP ENDURANCE 360107806310 310500861001 DEMOCRACY PREP ENDURANCE CHARTER charter Regular School Yes High 06 12 2021   grade_7 2.0 96.0 34.0   0.0     2.0     2.0   75.0 61.0     9       121     33   136 2 96 34   0     2     2   75 61     9   121   33   136
1486147 1486147 NY Niagara   school 3620820 400800010000   NIAGARA FALLS 362082005952 400800010041 LASALLE PREPARATORY SCHOOL public Regular School No Middle 07 08 2021   grade_7 130.0 75.0 22.0   5.0     9.0     30.0   123.0 148.0     9       202     42   271 130 75 22   5     9     30   123 148     9   202   42   271
1488123 1488123 NY Onondaga   school 3621210 420303060000   NORTH SYRACUSE 362121003004 420303060011 ROXBORO ROAD MIDDLE SCHOOL public Regular School No Middle 05 07 2021   grade_7 183.0 13.0 19.0   0.0     6.0     14.0   114.0 121.0     9       126     44   235 183 13 19   0     6     14   114 121     9   126   44   235
1495742 1495742 NY Queens   school 3600122 342500010000   NYC GEOG DIST #25 - QUEENS 360012205879 342500011281 EAST-WEST SCHOOL OF INTERNATION STUD public Regular School No High 06 12 2021   grade_7 0.0 4.0 10.0   0.0     81.0     1.0   59.0 37.0     9       76     11   96 0 4 10   0     81     1   59 37     9   76   11   96
1498573 1498573 NY Queens   school 3600100 342800010000   NYC GEOG DIST #28 - QUEENS 360010006188 342800011167 METROPOLITAN EXPEDITIONARY LRNING public Regular School No High 06 12 2021   grade_7 19.0 16.0 42.0   9.0     35.0     6.0   76.0 51.0     9       79     25   127 19 16 42   9     35     6   76 51     9   79   25   127
1501727 1501727 NY Richmond   school 3600103 353100010000   NYC GEOG DIST #31 - SI 360010301966 353100010007 IS 7 ELIAS BERNSTEIN public Regular School No Middle 06 08 2021   grade_7 295.0 3.0 46.0   2.0     38.0     2.0   218.0 168.0     9       155     89   386 295 3 46   2     38     2   218 168     9   155   89   386
1503836 1503836 NY Rockland   school 3622560 500308030000   PEARL RIVER 362256003177 500308030009 PEARL RIVER MIDDLE SCHOOL public Regular School No Middle 05 07 2021   grade_7 145.0 1.0 26.0         7.0     3.0   104.0 78.0     9       24     33   182 145 1 26         7     3   104 78     9   24   33   182
1513602 1513602 NY Suffolk   school 3627060 580801060000   SMITHTOWN 362706005840 580801060019 ACCOMPSETT MIDDLE SCHOOL public Regular School No Middle 06 08 2021   grade_7 134.0 5.0 22.0         13.0     2.0   88.0 88.0     9       31     35   176 134 5 22         13     2   88 88     9   31   35   176
1526693 1526693 NY Bronx   school 3600085 320800010000   NYC GEOG DIST # 8 - BRONX 360008505652 320800011269 BRONX STUDIO SCHOOL-WRITERS-ARTISTS public Regular School No High 06 12 2020   grade_7 2.0 14.0 74.0         0.0     0.0   37.0 53.0     9       79     33   90 2 14 74         0     0   37 53     9   79   33   90
1526826 1526826 NY Bronx   school 3600085 320800010000   NYC GEOG DIST # 8 - BRONX 360008505984 320800011376 ANTONIA PANTOJA PREP ACADEMY public Regular School No High 06 12 2020   grade_7 0.0 10.0 48.0   2.0     1.0         29.0 32.0     9       54     14   61 0 10 48   2     1         29 32     9   54   14   61
1527928 1527928 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 2020   grade_7 0.0 19.0 82.0         0.0     0.0   45.0 56.0     9       94     *   101 0 19 82         0     0   45 56     9   94       101
1528308 1528308 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_7 2.0 22.0 46.0   0.0     0.0         31.0 39.0     9       68     27   70 2 22 46   0     0         31 39     9   68   27   70
1532374 1532374 NY Bronx   school 3600090 321200010000   NYC GEOG DIST #12 - BRONX 360009005806 321200010286 FANNIE LOU HAMER MIDDLE SCHOOL public Regular School No Middle 06 08 2020   grade_7 2.0 30.0 58.0   0.0     2.0         57.0 35.0     9       80     15   92 2 30 58   0     2         57 35     9   80   15   92
1538625 1538625 NY Dutchess   school 3615180 130801060000   HYDE PARK 361518001270 130801060006 HAVILAND MIDDLE SCHOOL public Regular School No Middle 06 08 2020   grade_7 166.0 26.0 57.0   0.0     3.0     15.0   138.0 129.0     9       144     48   267 166 26 57   0     3     15   138 129     9   144   48   267
1540506 1540506 NY Erie   school 3605850 140600010000   BUFFALO 360585000335 140600010037 MARVA J DANIEL FUTURES PREP SCHOOL public Regular School No Elementary PK 08 2020   grade_7 3.0 44.0 2.0   0.0     5.0     0.0   24.0 30.0     9       52     5   54 3 44 2   0     5     0   24 30     9   52   5   54
1541836 1541836 NY Erie   school 3607230 140701060000   CHEEKTOWAGA 360723005572 140701060007 CHEEKTOWAGA MIDDLE SCHOOL public Regular School No Middle 05 08 2020   grade_7 71.0 71.0 23.0   1.0     7.0     9.0   106.0 76.0     9       120     30   182 71 71 23   1     7     9   106 76     9   120   30   182
1547935 1547935 NY Kings   school 3600119 331400010000   NYC GEOG DIST #14 - BROOKLYN 360011902221 331400010050 JHS 50 JOHN D WELLS public Regular School No Middle 06 08 2020   grade_7 0.0 28.0 77.0   2.0     3.0     0.0   63.0 47.0     9       103     30   110 0 28 77   2     3     0   63 47     9   103   30   110
1547973 1547973 NY Kings   school 3600119 331400010000   NYC GEOG DIST #14 - BROOKLYN 360011902326 331400010084 PS 84 JOSE DE DIEGO public Regular School No Elementary PK 08 2020   grade_7 9.0 10.0 64.0   0.0     2.0     4.0   46.0 43.0     9       55     20   89 9 10 64   0     2     4   46 43     9   55   20   89
1550804 1550804 NY Kings   school 3600095 331700010000   NYC GEOG DIST #17 - BROOKLYN 360009505819 331700010353 ELIJAH STROUD MIDDLE SCHOOL public Regular School No Middle 06 08 2020   grade_7 3.0 36.0 16.0   2.0     3.0     2.0   30.0 32.0     9       60     24   62 3 36 16   2     3     2   30 32     9   60   24   62
1553844 1553844 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 2020   grade_7 21.0 0.0 31.0   0.0     8.0         33.0 27.0     9       51     17   60 21 0 31   0     8         33 27     9   51   17   60
1554281 1554281 NY Kings   school 3600151 332000010000   NYC GEOG DIST #20 - BROOKLYN 360015105955 332000011609 URBAN ASSEMBLY SCH-CRIMINAL JUSTICE public Regular School No High 06 12 2020   grade_7 11.0 6.0 19.0   0.0     34.0     1.0     71.0     9       62     13   71 11 6 19   0     34     1     71     9   62   13   71
1555155 1555155 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_7 30.0 116.0 24.0   5.0     9.0     3.0   105.0 82.0     9       *     49   187 30 116 24   5     9     3   105 82     9       49   187
1560247 1560247 NY Monroe   school 3624750 261600010000   ROCHESTER 362475003383 261600010008 SCHOOL 8-ROBERTO CLEMENTE public Regular School No Elementary PK 08 2020   grade_7 6.0 51.0 25.0   0.0     1.0     0.0   45.0 38.0     9       81     27   83 6 51 25   0     1     0   45 38     9   81   27   83
1561406 1561406 NY Monroe   school 3625170 261701060000   RUSH HENRIETTA 362517004534 261701060014 CHARLES H ROTH JR HIGH SCHOOL public Regular School No Middle 07 09 2020   grade_7 113.0 26.0 17.0         21.0     7.0   89.0 95.0     9       98     19   184 113 26 17         21     7   89 95     9   98   19   184
1561425 1561425 NY Monroe   school 3625170 261701060000   RUSH HENRIETTA 362517000492 261701060015 HENRY V BURGER JUNIOR HIGH SCHOOL public Regular School No Middle 07 09 2020   grade_7 138.0 25.0 19.0   1.0     31.0     17.0   116.0 115.0     9       88     15   231 138 25 19   1     31     17   116 115     9   88   15   231
1562432 1562432 NY Nassau   school 3600988 280201860947   EVERGREEN CHARTER SCHOOL 360098806137 280201860947 EVERGREEN CHARTER SCHOOL charter Regular School Yes Elementary KG 08 2020   grade_7 0.0 12.0 37.0   0.0     0.0         24.0 25.0     9       36     7   49 0 12 37   0     0         24 25     9   36   7   49
1565396 1565396 NY Nassau   school 3626520 280252070000   SEWANHAKA 362652003626 280252070002 ELMONT MEMORIAL HIGH SCHOOL public Regular School No High 07 12 2020   grade_7 5.0 140.0 52.0         33.0     9.0   127.0 112.0     9       149     24   239 5 140 52         33     9   127 112     9   149   24   239
1567353 1567353 NY Nassau   school 3615810 280515030000   JERICHO 361581001369 280515030006 JERICHO MIDDLE SCHOOL public Regular School No Middle 06 08 2020   grade_7 87.0 9.0 4.0         163.0     3.0   148.0 118.0     9       38     27   266 87 9 4         163     3   148 118     9   38   27   266
1575124 1575124 NY New York   school 3600083 310600010000   NYC GEOG DIST # 6 - MANHATTAN 360008305642 310600010278 PAULA HEDBAVNY SCHOOL public Regular School No Elementary KG 08 2020   grade_7 8.0 0.0 59.0         0.0     2.0   26.0 43.0     9       51     20   69 8 0 59         0     2   26 43     9   51   20   69
1581223 1581223 NY Orange   school 3612330 440601040000   GOSHEN 361233000997 440601040004 C J HOOKER MIDDLE SCHOOL public Regular School No Middle 06 08 2020   grade_7 199.0 13.0 7.0         10.0     4.0   120.0 113.0     9       71     43   233 199 13 7         10     4   120 113     9   71   43   233
1587664 1587664 NY Queens   school 3600123 342700010000   NYC GEOG DIST #27 - QUEENS 360012305731 342700011262 CHANNEL VIEW SCHOOL FOR RESEARCH public Regular School No High 06 12 2020   grade_7 15.0 54.0 65.0   4.0     12.0     4.0   84.0 70.0     9       104     19   154 15 54 65   4     12     4   84 70     9   104   19   154
1592110 1592110 NY Richmond   school 3600103 353100010000   NYC GEOG DIST #31 - SI 360010302120 353100010024 IS 24 MYRA S BARNES public Regular School No Middle 06 08 2020   grade_7 318.0 8.0 74.0   2.0     35.0     6.0   243.0 200.0     9       207     117   443 318 8 74   2     35     6   243 200     9   207   117   443
1600717 1600717 NY Suffolk   school 3609660 580301020000   EAST HAMPTON 360966000737 580301020003 EAST HAMPTON MIDDLE SCHOOL public Regular School No Middle 06 08 2020   grade_7 34.0 4.0 68.0   1.0     2.0     1.0   48.0 62.0     9       59     14   110 34 4 68   1     2     1   48 62     9   59   14   110
1604555 1604555 NY Sullivan   school 3617220 590901060000   LIBERTY 361722006667 590901060008 LIBERTY MIDDLE SCHOOL public Regular School No Middle 05 08 2020   grade_7 76.0 11.0 59.0   0.0     3.0     4.0   93.0 60.0     9       95     21   153 76 11 59   0     3     4   93 60     9   95   21   153
1612193 1612193 NY Westchester   school 3631920 662300010000   YONKERS 363192004270 662300010028 KAHLIL GIBRAN SCHOOL public Regular School No Elementary PK 08 2020   grade_7 19.0 16.0 36.0   0.0     4.0     1.0   42.0 34.0     9       58     21   76 19 16 36   0     4     1   42 34     9   58   21   76
2051531 2051531 NY Bronx   school 3600084 320700010000   NYC GEOG DIST # 7 - BRONX 360008405650 320700011221 SOUTH BRONX PREPARATORY public Regular School No High 06 12 2018   grade_7 3.0 17.0 78.0   0.0     1.0     1.0   46.0 54.0     9       98     31   100 3 17 78   0     1     1   46 54     9   98   31   100
2051797 2051797 NY Bronx   school 3600084 320700010000   NYC GEOG DIST # 7 - BRONX 360008405504 320700011551 URBAN ASSEMBLY BRONX OF LETTERS public Regular School No High 06 12 2018   grade_7 2.0 29.0 55.0         0.0     0.0   39.0 47.0     9       83     23   86 2 29 55         0     0   39 47     9   83   23   86
2053127 2053127 NY Bronx   school 3600085 320800010000   NYC GEOG DIST # 8 - BRONX 360008505984 320800011376 ANTONIA PANTOJA PREP ACADEMY public Regular School No High 06 12 2018   grade_7 3.0 8.0 64.0   1.0     1.0         42.0 35.0     9       64     21   77 3 8 64   1     1         42 35     9   64   21   77
2054590 2054590 NY Bronx   school 3600086 320900010000   NYC GEOG DIST # 9 - BRONX 360008606395 320900011350 NEW DIRECTIONS SECONDARY SCHOOL public Regular School No High 06 12 2018   grade_7 0.0 6.0 19.0   2.0     0.0         14.0 13.0     9       26     11   27 0 6 19   2     0         14 13     9   26   11   27
2058656 2058656 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_7 2.0 11.0 45.0   1.0     2.0     0.0   34.0 27.0     9       50     16   61 2 11 45   1     2     0   34 27     9   50   16   61
2063691 2063691 NY Columbia   school 3614940 101300010000   HUDSON 361494006579 101300010004 HUDSON JUNIOR HIGH SCHOOL public Regular School No Middle 06 08 2018   grade_7 51.0 13.0 16.0   0.0     12.0     6.0   46.0 52.0     9       69     14   98 51 13 16   0     12     6   46 52     9   69   14   98
2065743 2065743 NY Dutchess   school 3629880 132101060000   WAPPINGERS 362988004026 132101060010 WAPPINGERS JUNIOR HIGH SCHOOL public Regular School No Middle 07 08 2018   grade_7 245.0 19.0 92.0         25.0     8.0   202.0 187.0     9       142     73   389 245 19 92         25     8   202 187     9   142   73   389
2067301 2067301 NY Erie   school 3605850 140600010000   BUFFALO 360585000381 140600010119 WATERFRONT ELEMENTARY SCHOOL public Regular School No Elementary PK 08 2018   grade_7 10.0 40.0 12.0   2.0     11.0     7.0   41.0 41.0     9       74     18   82 10 40 12   2     11     7   41 41     9   74   18   82
2069771 2069771 NY Erie   school 3600025 142601860031   CHARTER SCHOOL FOR APPLIED TE 360002504349 142601860031 CHARTER SCHOOL FOR APPLIED TECHNOLOG charter Regular School Yes Other KG 12 2018   grade_7 42.0 68.0 51.0   0.0     8.0     9.0   84.0 94.0     9       152     26   178 42 68 51   0     8     9   84 94     9   152   26   178
2076611 2076611 NY Kings   school 3600095 331700010000   NYC GEOG DIST #17 - BROOKLYN 360009502504 331700010138 PS 138 public Regular School No Elementary PK 08 2018   grade_7 4.0 56.0 11.0   0.0     0.0     0.0   35.0 36.0     9       65     12   71 4 56 11   0     0     0   35 36     9   65   12   71

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