enrollments

Data source: Big Local News · About: Big Local

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

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

grade ✖

  • grade_6 · 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
1611774 1611774 NY Westchester   school 3631260 662200010000   WHITE PLAINS 363126004177 662200010012 WHITE PLAINS MIDDLE SCHOOL public Regular School No Middle 06 08 2020   grade_6 101.0 81.0 331.0         20.0     24.0   278.0 279.0     98       344     82   557 101 81 331         20     24   278 279     98   344   82   557
2113394 2113394 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_6 19.0 34.0 368.0   11.0     166.0     3.0   305.0 296.0     98       520     116   601 19 34 368   11     166     3   305 296     98   520   116   601
1007194 1007194 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 2017   grade_6 29.0 91.0 204.0   18.0     187.0     4.0   259.0 274.0     97       285     102   533 29 91 204   18     187     4   259 274     97   285   102   533
2169235 2169235 NY Kings   school 3600151 332000010000   NYC GEOG DIST #20 - BROOKLYN 360015102266 332000010062 JHS 62 DITMAS public Regular School No Middle 06 08 2019   grade_6 54.0 61.0 124.0   2.0     131.0     4.0   200.0 176.0     96       *     82   376 54 61 124   2     131     4   200 176     96       82   376
1030013 1030013 NY Westchester   school 3623460 661904030000   PORT CHESTER-RYE 362346003277 661904030010 PORT CHESTER MIDDLE SCHOOL public Regular School No Middle 06 08 2017   grade_6 49.0 14.0 273.0         7.0         177.0 166.0     95       276     50   343 49 14 273         7         177 166     95   276   50   343
1504215 1504215 NY Rockland   school 3627810 500402060000   EAST RAMAPO 362781003769 500402060016 ELMWOOD ELEMENTARY SCHOOL public Regular School No Elementary KG 06 2021   grade_6 7.0 36.0 134.0         7.0     3.0   99.0 88.0     95       155     15   187 7 36 134         7     3   99 88     95   155   15   187
2114610 2114610 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_6 21.0 94.0 218.0   25.0     173.0     2.0   313.0 220.0     95       389     87   533 21 94 218   25     173     2   313 220     95   389   87   533
2129012 2129012 NY Suffolk   school 3605280 580512030000   BRENTWOOD 360528000254 580512030016 NORTH MIDDLE SCHOOL public Regular School No Middle 06 08 2018   grade_6 14.0 22.0 344.0         8.0     0.0   205.0 183.0     95       357     33   388 14 22 344         8     0   205 183     95   357   33   388
2137353 2137353 NY Westchester   school 3623460 661904030000   PORT CHESTER-RYE 362346003277 661904030010 PORT CHESTER MIDDLE SCHOOL public Regular School No Middle 06 08 2018   grade_6 51.0 12.0 280.0   3.0     2.0     1.0   179.0 170.0     95       269     48   349 51 12 280   3     2     1   179 170     95   269   48   349
2227413 2227413 NY Westchester   school 3631260 662200010000   WHITE PLAINS 363126004177 662200010012 WHITE PLAINS MIDDLE SCHOOL public Regular School No Middle 06 08 2019   grade_6 115.0 58.0 324.0         26.0     18.0   258.0 283.0     95       346     84   541 115 58 324         26     18   258 283     95   346   84   541
1021672 1021672 NY Suffolk   school 3605280 580512030000   BRENTWOOD 360528000258 580512030021 SOUTH MIDDLE SCHOOL public Regular School No Middle 06 08 2017   grade_6 11.0 30.0 272.0   1.0     5.0     1.0   161.0 159.0     94       301     50   320 11 30 272   1     5     1   161 159     94   301   50   320
2079992 2079992 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_6 24.0 4.0 73.0   1.0     175.0     0.0   143.0 134.0     94       274     47   277 24 4 73   1     175     0   143 134     94   274   47   277
2111836 2111836 NY Queens   school 3600122 342500010000   NYC GEOG DIST #25 - QUEENS 360012201996 342500010237 IS 237 public Regular School No Middle 06 08 2018   grade_6 8.0 15.0 60.0   0.0     345.0     1.0   238.0 191.0     94       370     61   429 8 15 60   0     345     1   238 191     94   370   61   429
1473188 1473188 NY Nassau   school 3611550 280209030000   FREEPORT 361155000911 280209030003 CAROLINE G ATKINSON SCHOOL public Regular School No Middle 05 06 2021   grade_6 42.0 101.0 346.0   2.0     1.0     8.0   252.0 248.0     93       329     75   500 42 101 346   2     1     8   252 248     93   329   75   500
2080068 2080068 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_6 212.0 7.0 127.0   1.0     293.0     4.0   346.0 298.0     93       526     81   644 212 7 127   1     293     4   346 298     93   526   81   644
2089397 2089397 NY Nassau   school 3611550 280209030000   FREEPORT 361155000911 280209030003 CAROLINE G ATKINSON SCHOOL public Regular School No Middle 05 06 2018   grade_6 33.0 153.0 350.0   1.0     9.0     11.0   293.0 264.0     93       407     110   557 33 153 350   1     9     11   293 264     93   407   110   557
2110202 2110202 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_6 8.0 9.0 305.0   5.0     228.0     0.0   295.0 260.0     93       448     97   555 8 9 305   5     228     0   295 260     93   448   97   555
2110677 2110677 NY Queens   school 3600098 342400010000   NYC GEOG DIST #24 - QUEENS 360009802464 342400010125 IS 125 THOMAS J MCCANN WOODSIDE public Regular School No Middle 06 08 2018   grade_6 13.0 5.0 232.0   5.0     145.0     1.0   207.0 194.0     93       *     *   401 13 5 232   5     145     1   207 194     93           401
2128993 2128993 NY Suffolk   school 3605280 580512030000   BRENTWOOD 360528000263 580512030015 WEST MIDDLE SCHOOL public Regular School No Middle 06 08 2018   grade_6 16.0 45.0 236.0   0.0     18.0     0.0   165.0 150.0     93       280     69   315 16 45 236   0     18     0   165 150     93   280   69   315
1463916 1463916 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_6 165.0 5.0 107.0   5.0     254.0     11.0   294.0 253.0     92       406     100   547 165 5 107   5     254     11   294 253     92   406   100   547
2110886 2110886 NY Queens   school 3600098 342400010000   NYC GEOG DIST #24 - QUEENS 360009806431 342400010311 CORONA ARTS AND SCIENCES ACADEMY public Regular School No Middle 06 08 2018   grade_6 1.0 4.0 303.0   1.0     5.0     1.0   152.0 163.0     92       308     63   315 1 4 303   1     5     1   152 163     92   308   63   315
2137752 2137752 NY Westchester   school 3631260 662200010000   WHITE PLAINS 363126004177 662200010012 WHITE PLAINS MIDDLE SCHOOL public Regular School No Middle 06 08 2018   grade_6 111.0 70.0 323.0         25.0     21.0   270.0 280.0     92       334     75   550 111 70 323         25     21   270 280     92   334   75   550
2170394 2170394 NY Kings   school 3600152 332100010000   NYC GEOG DIST #21 - BROOKLYN 360015202736 332100010228 IS 228 DAVID A BOODY public Regular School No Middle 06 08 2019   grade_6 204.0 29.0 110.0   1.0     154.0     5.0   274.0 229.0     92       395     87   503 204 29 110   1     154     5   274 229     92   395   87   503
2204214 2204214 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 2019   grade_6 22.0 78.0 247.0   23.0     178.0     6.0   270.0 284.0     92       410     102   554 22 78 247   23     178     6   270 284     92   410   102   554
2080790 2080790 NY Kings   school 3600152 332100010000   NYC GEOG DIST #21 - BROOKLYN 360015202792 332100010281 IS 281 JOSEPH B CAVALLARO public Regular School No Middle 06 08 2018   grade_6 127.0 27.0 102.0   1.0     182.0     1.0   240.0 200.0     91       381     89   440 127 27 102   1     182     1   240 200     91   381   89   440
2218654 2218654 NY Suffolk   school 3605280 580512030000   BRENTWOOD 360528000254 580512030016 NORTH MIDDLE SCHOOL public Regular School No Middle 06 08 2019   grade_6 7.0 29.0 361.0   3.0     4.0     3.0   202.0 205.0     90       376     34   407 7 29 361   3     4     3   202 205     90   376   34   407
944114 944114 NY Bronx   school 3600084 320700010000   NYC GEOG DIST # 7 - BRONX 360008405920 320700010343 ACADEMY OF APPLIED MATH AND TECH public Regular School No Middle 06 08 2017   grade_6 1.0 27.0 74.0         0.0     1.0   62.0 41.0     9       96     23   103 1 27 74         0     1   62 41     9   96   23   103
945520 945520 NY Bronx   school 3600085 320800010000   NYC GEOG DIST # 8 - BRONX 360008506156 320800010448 SOUNDVIEW ACADEMY public Regular School No Middle 06 08 2017   grade_6 4.0 39.0 86.0   0.0     2.0         63.0 68.0     9       99     37   131 4 39 86   0     2         63 68     9   99   37   131
949928 949928 NY Bronx   school 3600088 321100010000   NYC GEOG DIST #11 - BRONX 360008801989 321100010181 IS 181 PABLO CASALS public Regular School No Middle 06 08 2017   grade_6 15.0 177.0 78.0   6.0     14.0     1.0   156.0 135.0     9       235     75   291 15 177 78   6     14     1   156 135     9   235   75   291
949985 949985 NY Bronx   school 3600088 321100010000   NYC GEOG DIST #11 - BRONX 360008805800 321100010287 NORTH BRONX SCHOOL OF EMPOWERMENT public Regular School No Middle 06 08 2017   grade_6 3.0 50.0 32.0   2.0     2.0         56.0 33.0     9       80     29   89 3 50 32   2     2         56 33     9   80   29   89
951771 951771 NY Bronx   school 3601027 321200860965   DR R IZQUIERDO HEALTH/SCIENC 360102706234 321200860965 DR R IZQUIERDO HEALTH/SCIENCE CHARTE charter Regular School Yes Other 06 12 2017   grade_6 5.0 26.0 75.0   1.0     0.0     0.0   47.0 60.0     9       104     27   107 5 26 75   1     0     0   47 60     9   104   27   107
959257 959257 NY Erie   school 3605850 140600010000   BUFFALO 360585000324 140600010019 NATIVE AMERICAN MAGNET public Regular School No Elementary PK 8 2017   grade_6 3.0 23.0 8.0   11.0     10.0     2.0   30.0 27.0     9       48     15   57 3 23 8   11     10     2   30 27     9   48   15   57
962373 962373 NY Erie   school 3600025 142601860031   CHARTER SCHOOL FOR APPLIED TE 360002504349 142601860031 CHARTER SCHOOL FOR APPLIED TECHNOLOG charter Regular School Yes Other KG 12 2017   grade_6 48.0 67.0 51.0   0.0     6.0     12.0   92.0 92.0     9       154     28   184 48 67 51   0     6     12   92 92     9   154   28   184
968244 968244 NY Kings   school 3600092 331500010000   NYC GEOG DIST #15 - BROOKLYN 360009204890 331500011497 SCHOOL FOR INTERNATIONAL STUDIES public Regular School No Other 06 12 2017   grade_6 52.0 34.0 20.0   1.0     4.0     7.0   76.0 42.0     9       43     32   118 52 34 20   1     4     7   76 42     9   43   32   118
968662 968662 NY Kings   school 3600094 331600010000   NYC GEOG DIST #16 - BROOKLYN 360009402499 331600010057 JHS 57 WHITELAW REID public Regular School No Middle 06 8 2017   grade_6 2.0 34.0 26.0         3.0         30.0 35.0     9       *     21   65 2 34 26         3         30 35     9       21   65
969308 969308 NY Kings   school 3600095 331700010000   NYC GEOG DIST #17 - BROOKLYN 360009502504 331700010138 PS 138 public Regular School No Elementary PK 8 2017   grade_6 3.0 56.0 9.0   0.0     0.0     0.0   35.0 33.0     9       65     13   68 3 56 9   0     0     0   35 33     9   65   13   68
970448 970448 NY Kings   school 3600096 331800010000   NYC GEOG DIST #18 - BROOKLYN 360009602707 331800010211 IS 211 JOHN WILSON public Regular School No Middle 06 8 2017   grade_6 4.0 147.0 13.0   1.0     3.0     0.0   89.0 79.0     9       139     39   168 4 147 13   1     3     0   89 79     9   139   39   168
975426 975426 NY Kings   school 3600097 333200010000   NYC GEOG DIST #32 - BROOKLYN 360009702199 333200010045 PS/IS 45 HORACE E GREENE public Regular School No Elementary PK 08 2017   grade_6 4.0 37.0 34.0   1.0     1.0     0.0   40.0 37.0     9       60     13   77 4 37 34   1     1     0   40 37     9   60   13   77
980195 980195 NY Monroe   school 3625170 261701060000   RUSH HENRIETTA 362517004534 261701060014 CHARLES H ROTH MIDDLE SCHOOL public Regular School No Middle 06 08 2017   grade_6 147.0 33.0 16.0   1.0     16.0     12.0   117.0 108.0     9       109     20   225 147 33 16   1     16     12   117 108     9   109   20   225
982380 982380 NY Nassau   school 3621570 280211030000   OCEANSIDE 362157003062 280211030005 SCHOOL 5 public Regular School No Elementary 01 06 2017   grade_6 65.0 2.0 22.0         5.0     1.0   57.0 38.0     9       11     27   95 65 2 22         5     1   57 38     9   11   27   95
988821 988821 NY New York   school 3600077 310200010000   NYC GEOG DIST # 2 - MANHATTAN 360007702468 310200010126 PS 126 JACOB AUGUST RIIS public Regular School No Elementary PK 08 2017   grade_6 15.0 4.0 16.0   0.0     76.0     7.0   71.0 47.0     9       73     25   118 15 4 16   0     76     7   71 47     9   73   25   118
993229 993229 NY New York   school 3600158 310500860894   DEMOCRACY PREP CHARTER SCHOO 360015805847 310500860894 DEMOCRACY PREP CHARTER SCHOOL charter Regular School Yes Other 06 12 2017   grade_6 1.0 69.0 26.0   3.0     0.0     0.0   58.0 41.0     9       85     26   99 1 69 26   3     0     0   58 41     9   85   26   99
993305 993305 NY New York   school 3601010 310500860989   DEMOCRACY PREP HARLEM CHARTER 360101006183 310500860989 DEMOCRACY PREP HARLEM CHARTER SCHOOL charter Regular School Yes Other KG 12 2017   grade_6 1.0 67.0 19.0   2.0     0.0     1.0   45.0 45.0     9       71     19   90 1 67 19   2     0     1   45 45     9   71   19   90
994008 994008 NY New York   school 3600083 310600010000   NYC GEOG DIST # 6 - MANHATTAN 360008305990 310600010366 WASHINGTON HEIGHTS ACADEMY public Regular School No Elementary PK 08 2017   grade_6 1.0 2.0 50.0   0.0     2.0     0.0   29.0 26.0     9       47     10   55 1 2 50   0     2     0   29 26     9   47   10   55
1000392 1000392 NY Orange   school 3619650 441201060000   MONROE WOODBURY 361965001794 441201060009 MONROE-WOODBURY MIDDLE SCHOOL public Regular School No Middle 06 08 2017   grade_6 323.0 49.0 122.0   2.0     37.0     2.0   271.0 264.0     9       137     91   535 323 49 122   2     37     2   271 264     9   137   91   535
1004648 1004648 NY Queens   school 3600122 342500010000   NYC GEOG DIST #25 - QUEENS 360012205879 342500011281 EAST-WEST SCHOOL OF INTERNATION STUD public Regular School No Other 06 12 2017   grade_6 4.0 2.0 16.0   0.0     86.0     1.0   55.0 54.0     9       89     12   109 4 2 16   0     86     1   55 54     9   89   12   109
1006814 1006814 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_6 2.0 82.0 21.0   12.0     12.0     1.0   66.0 64.0     9       113     37   130 2 82 21   12     12     1   66 64     9   113   37   130
1011488 1011488 NY Richmond   school 3600103 353100010000   NYC GEOG DIST #31 - SI 360010304526 353100010075 IS 75 FRANK D PAULO public Regular School No Middle 06 08 2017   grade_6 340.0 8.0 53.0   2.0     40.0     4.0   224.0 223.0     9       151     112   447 340 8 53   2     40     4   224 223     9   151   112   447
1015383 1015383 NY Schenectady   school 3626010 530600010000   SCHENECTADY 362601006117 530600010034 CENTRAL PARK MIDDLE SCHOOL public Regular School No Middle 06 08 2017   grade_6 48.0 64.0 47.0   1.0     55.0     14.0   115.0 114.0     9       193     36   229 48 64 47   1     55     14   115 114     9   193   36   229
1023059 1023059 NY Sullivan   school 3610950 590501060000   FALLSBURG 361095000873 590501060003 BENJAMIN COSOR ELEMENTARY SCHOOL public Regular School No Elementary PK 06 2017   grade_6 43.0 5.0 42.0   0.0     1.0     7.0   55.0 43.0     9       63     16   98 43 5 42   0     1     7   55 43     9   63   16   98
1028854 1028854 NY Westchester   school 3620100 660900010000   MOUNT VERNON 362010004345 660900010023 BENJAMIN TURNER MIDDLE SCHOOL public Regular School No Middle 06 08 2017   grade_6 9.0 95.0 13.0         1.0     0.0   57.0 61.0     9       91     26   118 9 95 13         1     0   57 61     9   91   26   118
1434257 1434257 NY Albany   school 3630210 11200010000   WATERVLIET 363021004060 11200010002 WATERVLIET ELEMENTARY SCHOOL public Regular School No Elementary PK 06 2021   grade_6 46.0 25.0 14.0   0.0     3.0     16.0   63.0 41.0     9       69     15   104 46 25 14   0     3     16   63 41     9   69   15   104
1434979 1434979 NY Bronx   school 3600084 320700010000   NYC GEOG DIST # 7 - BRONX 360008405785 320700010296 SO BRONX ACADEMY-APPLIED MEDIA public Regular School No Middle 06 08 2021   grade_6 2.0 33.0 63.0   1.0               47.0 52.0     9       89     37   99 2 33 63   1               47 52     9   89   37   99
1435416 1435416 NY Bronx   school 3600054 320700860820   KIPP ACADEMY CHARTER SCH 360005404452 320700860820 KIPP ACADEMY CHARTER SCHOOL charter Regular School Yes Other KG 12 2021   grade_6 0.0 45.0 44.0   2.0     1.0     0.0   56.0 36.0     9       84     16   92 0 45 44   2     1     0   56 36     9   84   16   92
1435549 1435549 NY Bronx   school 3601001 320700860957   ACADEMIC LEADERSHIP CHARTER 360100106154 320700860957 ACADEMIC LEADERSHIP CHARTER SCHOOL charter Regular School Yes Elementary KG 08 2021   grade_6 0.0 33.0 37.0   0.0     1.0     1.0   40.0 32.0     9       66     *   72 0 33 37   0     1     1   40 32     9   66       72
1435891 1435891 NY Bronx   school 3601194 320700861145   CREO COLLEGE PREP CHARTER SC 360119406693 320700861145 CREO COLLEGE PREP CHARTER SCHOOL charter Regular School Yes Middle 05 06 2021   grade_6 2.0 41.0 59.0   0.0     3.0     1.0   60.0 46.0     9       82     28   106 2 41 59   0     3     1   60 46     9   82   28   106
1436556 1436556 NY Bronx   school 3600085 320800010000   NYC GEOG DIST # 8 - BRONX 360008505986 320800010375 BRONX MATHEMATICS PREP SCH (THE) public Regular School No Middle 06 08 2021   grade_6 1.0 20.0 29.0   2.0     3.0         29.0 26.0     9       55     16   55 1 20 29   2     3         29 26     9   55   16   55
1437012 1437012 NY Bronx   school 3600063 320800860846   BRONX CHARTER SCHOOL-ARTS 360006304875 320800860846 BRONX CHARTER SCHOOL FOR THE ARTS charter Regular School Yes Elementary KG 08 2021   grade_6 0.0 34.0 70.0   0.0     0.0     0.0   45.0 59.0     9       92     37   104 0 34 70   0     0     0   45 59     9   92   37   104
1438646 1438646 NY Bronx   school 3601025 320900860962   METROPOLITAN LIGHTHOUSE CHAR 360102506233 320900860962 METROPOLITAN LIGHTHOUSE CHARTER SCH charter Regular School Yes Other KG 12 2021   grade_6 1.0 21.0 32.0   0.0     0.0         30.0 24.0     9       50     8   54 1 21 32   0     0         30 24     9   50   8   54
1450483 1450483 NY Erie   school 3605850 140600010000   BUFFALO 360585000335 140600010037 MARVA J DANIEL FUTURES PREP SCHOOL public Regular School No Elementary PK 08 2021   grade_6 3.0 42.0 6.0         1.0     1.0   33.0 20.0     9       49     17   53 3 42 6         1     1   33 20     9   49   17   53
1451528 1451528 NY Erie   school 3600105 140600860861   BUFFALO ACAD-SCI CHARTER SCH 360010505602 140600860861 BUFFALO ACAD-SCI CHARTER SCHOOL charter Regular School Yes Other KG 12 2021   grade_6 14.0 42.0 12.0   1.0     17.0     4.0   42.0 48.0     9       79     17   90 14 42 12   1     17     4   42 48     9   79   17   90
1453618 1453618 NY Erie   school 3600025 142601860031   CHARTER SCHOOL FOR APPLIED TE 360002504349 142601860031 CHARTER SCHOOL FOR APPLIED TECHNOLOG charter Regular School Yes Other KG 12 2021   grade_6 29.0 75.0 42.0   3.0     13.0     20.0   89.0 93.0     9       152     12   182 29 75 42   3     13     20   89 93     9   152   12   182
1460173 1460173 NY Kings   school 3601029 331600860971   BEDFORD STUY NEW BEGINNINGS 360102906236 331600860971 BEDFORD STUY NEW BEGINNINGS CHARTER charter Regular School Yes Elementary KG 08 2021   grade_6 0.0 43.0 51.0   1.0     0.0     0.0   51.0 44.0     9       86     23   95 0 43 51   1     0     0   51 44     9   86   23   95
1460762 1460762 NY Kings   school 3600095 331700010000   NYC GEOG DIST #17 - BROOKLYN 360009505870 331700010484 RONALD EDMONDS LEARNING CTR II public Regular School No Middle 06 08 2021   grade_6 2.0 45.0 9.0   1.0     1.0     1.0   33.0 26.0     9       49     21   59 2 45 9   1     1     1   33 26     9   49   21   59
1464239 1464239 NY Kings   school 3600152 332100010000   NYC GEOG DIST #21 - BROOKLYN 360015202363 332100010095 PS 95 GRAVESEND (THE) public Regular School No Elementary PK 08 2021   grade_6 17.0 4.0 25.0   0.0     21.0     1.0   37.0 31.0     9       57     *   68 17 4 25   0     21     1   37 31     9   57       68
1464638 1464638 NY Kings   school 3600152 332100010000   NYC GEOG DIST #21 - BROOKLYN 360015202754 332100010239 MARK TWAIN IS 239-GIFTED & TALENTED public Regular School No Middle 06 08 2021   grade_6 240.0 32.0 48.0   2.0     107.0     31.0   216.0 244.0     9       164     78   460 240 32 48   2     107     31   216 244     9   164   78   460
1472523 1472523 NY Nassau   school 3609840 280203030000   EAST MEADOW 360984000106 280203030008 CLARKE MIDDLE SCHOOL public Regular School No Middle 06 08 2021   grade_6 93.0 7.0 60.0         51.0     1.0   110.0 102.0     9       57     36   212 93 7 60         51     1   110 102     9   57   36   212
1474119 1474119 NY Nassau   school 3611460 280217020000   FRANKLIN SQUARE 361146000903 280217020004 WASHINGTON STREET SCHOOL public Regular School No Elementary PK 06 2021   grade_6 90.0 8.0 44.0   1.0     22.0     2.0   86.0 81.0     9       46     27   167 90 8 44   1     22     2   86 81     9   46   27   167
1476190 1476190 NY Nassau   school 3612510 280407030000   GREAT NECK 361251001015 280407030012 GREAT NECK NORTH MIDDLE SCHOOL public Regular School No Middle 06 08 2021   grade_6 170.0 3.0 26.0         47.0     6.0   142.0 110.0     9             46   252 170 3 26         47     6   142 110     9       46   252
1478603 1478603 NY New York   school 3600135 307500010000   NYC SPEC SCHOOLS - DIST 75 360013504815 307500013771 PS 771 public Special Education School No Other KG 12 2021   grade_6 4.0 20.0 6.0   1.0     12.0     0.0   34.0 9.0     9       36     43   43 4 20 6   1     12     0   34 9     9   36   43   43
1480142 1480142 NY New York   school 3600077 310200010000   NYC GEOG DIST # 2 - MANHATTAN 360007704406 310200010217 PS/IS 217 ROOSEVELT ISLAND public Regular School No Elementary PK 08 2021   grade_6 6.0 8.0 12.0   0.0     6.0     1.0   18.0 15.0     9       19     8   33 6 8 12   0     6     1   18 15     9   19   8   33
1480313 1480313 NY New York   school 3600077 310200010000   NYC GEOG DIST # 2 - MANHATTAN 360007706602 310200010297 MS 297 public Regular School No Middle 06 08 2021   grade_6 89.0 42.0 80.0   1.0     17.0     13.0   110.0 132.0     9       116     62   242 89 42 80   1     17     13   110 132     9   116   62   242
1483068 1483068 NY New York   school 3600079 310400010000   NYC GEOG DIST # 4 - MANHATTAN 360007902366 310400010096 PS 96 JOSEPH LANZETTA public Regular School No Elementary PK 08 2021   grade_6 2.0 17.0 35.0   0.0     0.0     1.0   26.0 29.0     9       53     18   55 2 17 35   0     0     1   26 29     9   53   18   55
1483277 1483277 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_6 0.0 11.0 31.0   0.0     0.0     1.0   20.0 23.0     9       41     14   43 0 11 31   0     0     1   20 23     9   41   14   43
1484398 1484398 NY New York   school 3601010 310500860989   DEMOCRACY PREP HARLEM CHARTER 360101006183 310500860989 DEMOCRACY PREP HARLEM CHARTER SCHOOL charter Regular School Yes Other KG 12 2021   grade_6 2.0 85.0 40.0   0.0     1.0     0.0   62.0 66.0     9       114     32   128 2 85 40   0     1     0   62 66     9   114   32   128
1488122 1488122 NY Onondaga   school 3621210 420303060000   NORTH SYRACUSE 362121003004 420303060011 ROXBORO ROAD MIDDLE SCHOOL public Regular School No Middle 05 07 2021   grade_6 180.0 17.0 23.0   1.0     13.0     26.0   143.0 117.0     9       147     49   260 180 17 23   1     13     26   143 117     9   147   49   260
1493651 1493651 NY Putnam   school 3606570 480102060000   CARMEL 360657000439 480102060007 GEORGE FISCHER MIDDLE SCHOOL public Regular School No Middle 05 08 2021   grade_6 162.0 4.0 77.0   1.0     4.0     11.0   133.0 126.0     9       *     40   259 162 4 77   1     4     11   133 126     9       40   259
1494316 1494316 NY Queens   school 3600098 342400010000   NYC GEOG DIST #24 - QUEENS 360009802423 342400010113 PS/IS 113 ANTHONY J PRANZO public Regular School No Elementary PK 08 2021   grade_6 35.0 0.0 45.0   0.0     12.0     3.0   44.0 51.0     9       49     13   95 35 0 45   0     12     3   44 51     9   49   13   95
1494943 1494943 NY Queens   school 3601082 342400861048   MIDDLE VILLAGE PREP CHARTER 360108206433 342400861048 MIDDLE VILLAGE PREP CHARTER SCHOOL charter Regular School Yes Middle 06 08 2021   grade_6 43.0 3.0 89.0   1.0     13.0     1.0   74.0 76.0     9       97     23   150 43 3 89   1     13     1   74 76     9   97   23   150
1496007 1496007 NY Queens   school 3600099 342600010000   NYC GEOG DIST #26 - QUEENS 360009902281 342600010067 JHS 67 LOUIS PASTEUR public Regular School No Middle 06 08 2021   grade_6 63.0 11.0 41.0   1.0     211.0     15.0   186.0 156.0     9       141     39   342 63 11 41   1     211     15   186 156     9   141   39   342
1498097 1498097 NY Queens   school 3600100 342800010000   NYC GEOG DIST #28 - QUEENS 360010002376 342800010099 PS 99 KEW GARDENS public Regular School No Elementary KG 06 2021   grade_6 20.0 5.0 26.0   2.0     17.0     1.0   36.0 35.0     9       47     15   71 20 5 26   2     17     1   36 35     9   47   15   71
1499237 1499237 NY Queens   school 3600101 342900010000   NYC GEOG DIST #29 - QUEENS 360010102506 342900010138 PS/MS 138 SUNRISE public Regular School No Elementary PK 08 2021   grade_6 3.0 66.0 7.0   0.0     4.0     3.0   46.0 37.0     9       65     17   83 3 66 7   0     4     3   46 37     9   65   17   83
1500852 1500852 NY Queens   school 3600987 343000860952   GROWING UP GREEN CHARTER 360098706124 343000860952 GROWING UP GREEN CHARTER SCHOOL charter Regular School Yes Elementary KG 08 2021   grade_6 26.0 18.0 41.0   0.0     6.0     4.0   48.0 47.0     9       63     22   95 26 18 41   0     6     4   48 47     9   63   22   95
1501080 1501080 NY Rensselaer   school 3609630 490301060000   EAST GREENBUSH 360963000734 490301060008 HOWARD L GOFF SCHOOL public Regular School No Middle 06 08 2021   grade_6 225.0 10.0 24.0   0.0     24.0     8.0   154.0 137.0     9       69     38   291 225 10 24   0     24     8   154 137     9   69   38   291
1501574 1501574 NY Rensselaer   school 3628950 491700010000   TROY 362895003919 491700010021 TROY MIDDLE SCHOOL public Regular School No Middle 06 08 2021   grade_6 107.0 74.0 48.0   0.0     4.0     34.0   137.0 130.0     9       265     44   267 107 74 48   0     4     34   137 130     9   265   44   267
1501726 1501726 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_6 306.0 0.0 46.0   4.0     45.0     6.0   213.0 194.0     9       152     79   407 306 0 46   4     45     6   213 194     9   152   79   407
1513810 1513810 NY Suffolk   school 3631020 580902020000   WESTHAMPTON BEACH 363102004167 580902020004 WESTHAMPTON MIDDLE SCHOOL public Regular School No Middle 06 08 2021   grade_6 32.0 1.0 27.0   0.0     1.0     3.0   34.0 30.0     9       29     *   64 32 1 27   0     1     3   34 30     9   29       64
1519035 1519035 NY Westchester   school 3610650 660409020000   ELMSFORD 361065000838 660409020002 ALICE E GRADY ELEMENTARY SCHOOL public Regular School No Elementary 02 06 2021   grade_6 3.0 11.0 40.0         4.0     2.0   32.0 28.0     9       30     8   60 3 11 40         4     2   32 28     9   30   8   60
1521809 1521809 NY Westchester   school 3631920 662300010000   YONKERS 363192004258 662300010013 SCHOOL 13 public Regular School No Elementary PK 08 2021   grade_6 5.0 13.0 48.0   0.0     2.0     2.0   37.0 33.0     9       56     9   70 5 13 48   0     2     2   37 33     9   56   9   70
1526540 1526540 NY Bronx   school 3600085 320800010000   NYC GEOG DIST # 8 - BRONX 360008505982 320800010371 URBAN INSTITUTE OF MATHEMATICS public Regular School No Middle 06 08 2020   grade_6 24.0 6.0 80.0   2.0     4.0     1.0   46.0 71.0     9       82     33   117 24 6 80   2     4     1   46 71     9   82   33   117
1528687 1528687 NY Bronx   school 3601071 320900861004   MOTT HALL CHARTER SCHOOL 360107106328 320900861004 MOTT HALL CHARTER SCHOOL charter Regular School Yes Middle 06 08 2020   grade_6 2.0 28.0 38.0   1.0     2.0         39.0 32.0     9       63     19   71 2 28 38   1     2         39 32     9   63   19   71
1532354 1532354 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 2020   grade_6 1.0 16.0 39.0   0.0     0.0     0.0   32.0 24.0     9       *     19   56 1 16 39   0     0     0   32 24     9       19   56
1540049 1540049 NY Erie   school 3631470 140203060000   WILLIAMSVILLE 363147004213 140203060009 HEIM MIDDLE SCHOOL public Regular School No Middle 05 08 2020   grade_6 120.0 2.0 9.0   0.0     14.0     9.0   80.0 74.0     9       26     18   154 120 2 9   0     14     9   80 74     9   26   18   154
1540429 1540429 NY Erie   school 3605850 140600010000   BUFFALO 360585000324 140600010019 NATIVE AMERICAN MAGNET public Regular School No Elementary PK 08 2020   grade_6 8.0 18.0 12.0   3.0     11.0     1.0   36.0 17.0     9       50     17   53 8 18 12   3     11     1   36 17     9   50   17   53
1550784 1550784 NY Kings   school 3600095 331700010000   NYC GEOG DIST #17 - BROOKLYN 360009505818 331700010352 EBBETS FIELD MIDDLE SCHOOL public Regular School No Middle 06 08 2020   grade_6 3.0 27.0 8.0         2.0         21.0 19.0     9       39     *   40 3 27 8         2         21 19     9   39       40
1551848 1551848 NY Kings   school 3600096 331800010000   NYC GEOG DIST #18 - BROOKLYN 360009602795 331800010285 IS 285 MEYER LEVIN public Regular School No Middle 06 08 2020   grade_6 3.0 194.0 11.0   1.0     2.0     2.0   100.0 113.0     9       156     49   213 3 194 11   1     2     2   100 113     9   156   49   213
1554375 1554375 NY Kings   school 3600152 332100010000   NYC GEOG DIST #21 - BROOKLYN 360015203011 332100010098 IS 98 BAY ACADEMY public Regular School No Middle 06 08 2020   grade_6 290.0 14.0 46.0   3.0     164.0     30.0   260.0 287.0     9       316     64   547 290 14 46   3     164     30   260 287     9   316   64   547
1557225 1557225 NY Kings   school 3601017 333200860987   BUSHWICK ASCEND CHARTER SCHO 360101706172 333200860987 BUSHWICK ASCEND CHARTER SCHOOL charter Regular School Yes Elementary KG 08 2020   grade_6 1.0 22.0 64.0   0.0     0.0     0.0   44.0 43.0     9       71     22   87 1 22 64   0     0     0   44 43     9   71   22   87
1560227 1560227 NY Monroe   school 3624750 261600010000   ROCHESTER 362475003382 261600010007 SCHOOL 7-VIRGIL GRISSOM public Regular School No Elementary PK 06 2020   grade_6 6.0 42.0 18.0   0.0     3.0     0.0   35.0 34.0     9       67     18   69 6 42 18   0     3     0   35 34     9   67   18   69
1560531 1560531 NY Monroe   school 3624750 261600010000   ROCHESTER 362475003405 261600010034 SCHOOL 34-DR LOUIS A CERULLI public Regular School No Elementary PK 06 2020   grade_6 3.0 46.0 16.0   0.0     6.0     0.0   44.0 27.0     9       68     18   71 3 46 16   0     6     0   44 27     9   68   18   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]);