enrollments

Data source: Big Local News · About: Big Local

4,038 rows where grade = "grade_6" and state = "MA" sorted by black descending

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

grade ✖

  • grade_6 · 4,038 ✖
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
1372540 1372540 MA Suffolk   school 2500071 428   Brooke Charter School (District) 250007101747 4280305 Brooke Charter School   Regular School Yes Other KG 12 2020   grade_6 6 99 64 0   5     0   2   80 96 *                     176.0 6 99 64 0   5     0   2   80 96                 176
934021 934021 MA Plymouth   school 2503090 44   Brockton 250309002691 440422 Joseph F. Plouffe Academy   Regular School No 2 06 08 2016   grade_6 49 98 59 0   4     1   17   103 125                       228 49 98 59 0   4     1   17   103 125                 228
737152 737152 MA Plymouth   school 2503090 44   Brockton 250309000407 440415 South Middle School   Regular School No 2 06 08 2015   grade_6 47 97 23 0   11     0   11   106 83                       189 47 97 23 0   11     0   11   106 83                 189
1673458 1673458 MA Plymouth   school 2503090 44   Brockton 250309000389 440405 Brockton - East Middle School   Regular School No Middle 06 08 2021   grade_6 24 97 18 0   0     1   7   91 56 *                     147.0 24 97 18 0   0     1   7   91 56                 147
737146 737146 MA Plymouth   school 2503090 44   Brockton 250309000389 440405 East Middle School   Regular School No 2 06 08 2015   grade_6 19 96 18 0   1     1   7   77 65                       142 19 96 18 0   1     1   7   77 65                 142
1679803 1679803 MA Suffolk   school 2500071 428   Brooke Charter School (District) 250007101747 4280305 Brooke Charter School (District) - Brooke Charter School   Regular School Yes Other KG 12 2021   grade_6 14 96 63 1   4     0   4   85 97 *                     182.0 14 96 63 1   4     0   4   85 97                 182
934012 934012 MA Plymouth   school 2503090 44   Brockton 250309000407 440415 South Middle School   Regular School No 2 06 08 2016   grade_6 53 95 27 0   4     1   9   95 94                       189 53 95 27 0   4     1   9   95 94                 189
1123695 1123695 MA Plymouth   school 2503090 44   Brockton 250309002691 440422 Joseph F. Plouffe Academy   Regular School No Middle 06 08 2017   grade_6 60 95 72 1   8     0   12   124 124                       248 60 95 72 1   8     0   12   124 124                 248
1123683 1123683 MA Plymouth   school 2503090 44   Brockton 250309000407 440415 South Middle School   Regular School No Middle 06 08 2017   grade_6 26 94 30 0   6     1   14   89 82                       171 26 94 30 0   6     1   14   89 82                 171
1681488 1681488 MA Plymouth   school 2500559 3513   New Heights Charter School of Brockton (District) 250055902869 35130305 New Heights Charter School of Brockton (District) - New Heights Charter School of Brockton   Regular School Yes High 06 12 2021   grade_6 1 94 11 2   2     0   7   63 54 *                     117.0 1 94 11 2   2     0   7   63 54                 117
2045292 2045292 MA Norfolk   school 2509930 244   Randolph 250993001392 2440410 Randolph Community Middle   Regular School No Middle 06 08 2019   grade_6 25 94 50 1   45     0   14   126 103                       229.0 25 94 50 1   45     0   14   126 103                 229
2239998 2239998 MA Plymouth   school 2500559 3513   New Heights Charter School of Brockton (District) 250055902869 35130305 New Heights Charter School of Brockton (District): New Heights Charter School of Brockton   Regular School Yes Middle 06 09 2018   grade_6 2 94 10 1   0     0   0   52 55                       107.0 2 94 10 1   0     0   0   52 55                 107
1133178 1133178 MA Plymouth   school 2500559 3513   New Heights Charter of Brockton 250055902869 35130305 New Heights Charter School of Brockton   Regular School Yes Middle 06 08 2017   grade_6 1 92 10 0   0     0   2   55 50                       105 1 92 10 0   0     0   2   55 50                 105
1673414 1673414 MA Plymouth   school 2503090 44   Brockton 250309000390 440023 Brockton - Edgar B Davis   Regular School No Elementary KG 08 2021   grade_6 14 92 17 0   3     2   3   51 80 *                     131.0 14 92 17 0   3     2   3   51 80                 131
1673471 1673471 MA Plymouth   school 2503090 44   Brockton 250309002691 440422 Brockton - Joseph F. Plouffe Academy   Regular School No Middle 06 08 2021   grade_6 35 91 83 1   6     1   8   109 116 *                     225.0 35 91 83 1   6     1   8   109 116                 225
2238356 2238356 MA Suffolk   school 2500533 480   UP Academy Charter School of Boston (District) 250053302713 4800405 UP Academy Charter School of Boston (District): UP Academy Charter School of Boston   Regular School Yes Middle 06 08 2018   grade_6 4 90 69 0   16     1   3   89 94                       183.0 4 90 69 0   16     1   3   89 94                 183
736112 736112 MA Essex   school 2502640 30   Beverly 250264000165 300305 Briscoe Middle   Regular School No 2 06 08 2015   grade_6 268 9 30 0   7     0   8   170 152                       322 268 9 30 0   7     0   8   170 152                 322
737616 737616 MA Worcester   school 2503750 64   Clinton 250375000512 640305 Clinton Middle School   Regular School No 2 04 08 2015   grade_6 101 9 27 0   2     0   3   72 70                       142 101 9 27 0   2     0   3   72 70                 142
740092 740092 MA Middlesex   school 2508340 198   Natick 250834001305 1980310 Wilson Middle   Regular School No 2 05 08 2015   grade_6 175 9 24 0   12     1   10   109 122                       231 175 9 24 0   12     1   10   109 122                 231
741114 741114 MA Norfolk   school 2509870 243   Quincy 250987001563 2430310 Broad Meadows Middle   Regular School No 2 06 08 2015   grade_6 88 9 4 1   22     0   6   67 63                       130 88 9 4 1   22     0   6   67 63                 130
741253 741253 MA Suffolk   school 2510050 248   Revere 251005001976 2480057 Garfield Middle School   Regular School No 2 06 08 2015   grade_6 62 9 90 2   15     0   3   81 100                       181 62 9 90 2   15     0   3   81 100                 181
741849 741849 MA Hampden   school 2511130 281   Springfield 251113001809 2810095 Alfred G. Zanetti Montessori Magnet School   Regular School No 1 PK 08 2015   grade_6 7 9 6 0   1     0   3   13 13                       26 7 9 6 0   1     0   3   13 13                 26
742133 742133 MA Middlesex   school 2511340 288   Sudbury 251134001872 2880305 Ephraim Curtis Middle   Regular School No 2 06 08 2015   grade_6 287 9 10 0   15     0   7   160 168                       328 287 9 10 0   15     0   7   160 168                 328
743107 743107 MA Worcester   school 2513230 348   Worcester 251323002197 3480020 Belmont Street Community   Regular School No 1 PK 06 2015   grade_6 4 9 17 0   5     0   1   21 15                       36 4 9 17 0   5     0   1   21 15                 36
743144 743144 MA Worcester   school 2513230 348   Worcester 251323002204 3480050 Chandler Elementary Community   Regular School No 1 KG 06 2015   grade_6 2 9 23 0   5     0   3   18 24                       42 2 9 23 0   5     0   3   18 24                 42
743160 743160 MA Worcester   school 2513230 348   Worcester 251323002610 3480053 City View   Regular School No 1 PK 06 2015   grade_6 19 9 32 0   2     0   3   34 31                       65 19 9 32 0   2     0   3   34 31                 65
743199 743199 MA Worcester   school 2513230 348   Worcester 251323002215 3480100 Goddard School/Science Technical   Regular School No 1 PK 06 2015   grade_6 7 9 47 0   10     0   3   42 34                       76 7 9 47 0   10     0   3   42 34                 76
743297 743297 MA Worcester   school 2513230 348   Worcester 251323002242 3480215 Rice Square   Regular School No 1 KG 06 2015   grade_6 11 9 16 0   1     0   4   23 18                       41 11 9 16 0   1     0   4   23 18                 41
743334 743334 MA Worcester   school 2513230 348   Worcester 251323002248 3480240 Union Hill School   Regular School No 1 KG 06 2015   grade_6 8 9 26 1   3     0   4   25 26                       51 8 9 26 1   3     0   4   25 26                 51
744122 744122 MA Plymouth   school 2503030 625   Bridgewater-Raynham 250303002657 6250300 Williams Intermediate School   Regular School No 2 04 06 2015   grade_6 228 9 4 0   3     0   8   123 129                       252 228 9 4 0   3     0   8   123 129                 252
932926 932926 MA Middlesex   school 2502490 26   Belmont 250249000149 260305 Winthrop L Chenery Middle   Regular School No 2 05 08 2016   grade_6 245 9 15 0   53     0   19   171 170                       341 245 9 15 0   53     0   19   171 170                 341
933782 933782 MA Suffolk   school 2502790 35   Boston 250279002721 350656 Mario Umana Academy   Regular School No 1 KG 08 2016   grade_6 20 9 132 1   6     0   2   86 84                       170 20 9 132 1   6     0   2   86 84                 170
934444 934444 MA Hampden   school 2503660 61   Chicopee 250366000491 610305 Bellamy Middle   Regular School No 2 06 08 2016   grade_6 153 9 101 0   6     0   5   144 130                       274 153 9 101 0   6     0   5   144 130                 274
934808 934808 MA Middlesex   school 2504770 93   Everett 250477000631 930010 Sumner G. Whittier School   Regular School No 1 KG 08 2016   grade_6 14 9 38 0   4     0   1   31 35                       66 14 9 38 0   4     0   1   31 35                 66
937846 937846 MA Plymouth   school 2509720 239   Plymouth 250972002531 2390405 Plymouth Commun Intermediate   Regular School No 2 06 08 2016   grade_6 292 9 10 0   3     0   15   181 148                       329 292 9 10 0   3     0   15   181 148                 329
938199 938199 MA Essex   school 2510380 258   Salem 251038002404 2580305 Collins Middle   Regular School No 2 06 08 2016   grade_6 84 9 53 0   5     0   9   91 69                       160 84 9 53 0   5     0   9   91 69                 160
938337 938337 MA Norfolk   school 2510620 266   Sharon 251062002560 2660305 Sharon Middle   Regular School No 2 06 08 2016   grade_6 188 9 13 1   83     0   12   162 144                       306 188 9 13 1   83     0   12   162 144                 306
939347 939347 MA Middlesex   school 2512210 315   Wayland 251221002502 3150305 Wayland Middle School   Regular School No 2 06 08 2016   grade_6 128 9 6 0   40     1   9   100 93                       193 128 9 6 0   40     1   9   100 93                 193
939361 939361 MA Worcester   school 2512240 316   Webster 251224002849 3160315 Webster Middle School   Regular School No 2 05 08 2016   grade_6 102 9 33 1   3     1   13   71 91                       162 102 9 33 1   3     1   13   71 91                 162
939674 939674 MA Norfolk   school 2512810 335   Westwood 251281002097 3350305 E W Thurston Middle   Regular School No 2 06 08 2016   grade_6 211 9 9 0   33     0   5   125 142                       267 211 9 9 0   33     0   5   125 142                 267
939916 939916 MA Worcester   school 2513230 348   Worcester 251323002197 3480020 Belmont Street Community   Regular School No 1 PK 06 2016   grade_6 2 9 24 0   4     0   0   19 20                       39 2 9 24 0   4     0   0   19 20                 39
940122 940122 MA Worcester   school 2513230 348   Worcester 251323002245 3480225 Worcester Arts Magnet School   Regular School No 1 PK 06 2016   grade_6 19 9 7 0   0     0   4   16 23                       39 19 9 7 0   0     0   4   16 23                 39
1122700 1122700 MA Suffolk   school 2502790 35   Boston 250279000223 350077 Dennis C Haley   Regular School No Elementary PK 08 2017   grade_6 9 9 24 0   1     0   3   21 25                       46 9 9 24 0   1     0   3   21 25                 46
1123091 1123091 MA Suffolk   school 2502790 35   Boston 250279000323 350308 Sarah Greenwood   Regular School No Elementary PK 08 2017   grade_6 0 9 25 0   0     0   1   19 16                       35 0 9 25 0   0     0   1   19 16                 35
1123199 1123199 MA Suffolk   school 2502790 35   Boston 250279002677 350377 Higginson/Lewis K-8   Regular School No Elementary KG 08 2017   grade_6 0 9 12 0   0     0   1   14 8                       22 0 9 12 0   0     0   1   14 8                 22
1123732 1123732 MA Norfolk   school 2503150 46   Brookline 250315000416 460005 Edith C Baker   Regular School No Elementary KG 08 2017   grade_6 36 9 5 0   16     0   8   36 38                       74 36 9 5 0   16     0   8   36 38                 74
1124105 1124105 MA Suffolk   school 2503540 57   Chelsea 250354001158 570050 Clark Avenue School   Regular School No Middle 05 08 2017   grade_6 6 9 128 1   1     0   2   87 60                       147 6 9 128 1   1     0   2   87 60                 147
1124465 1124465 MA Middlesex   school 2504320 79   Dracut 250432001625 790410 Justus C. Richardson Middle School   Regular School No Middle 06 08 2017   grade_6 221 9 25 1   17     0   4   149 128                       277 221 9 25 1   17     0   4   149 128                 277
1126060 1126060 MA Middlesex   school 2506840 155   Lexington 250684002552 1550310 Wm Diamond Middle   Regular School No Middle 06 08 2017   grade_6 150 9 8 0   117     0   21   148 157                       305 150 9 8 0   117     0   21   148 157                 305
1126088 1126088 MA Middlesex   school 2506900 157   Lincoln 250690001008 1570305 Hanscom Middle   Regular School No Elementary 04 08 2017   grade_6 30 9 10 0   1     0   3   22 31                       53 30 9 10 0   1     0   3   22 31                 53
1126266 1126266 MA Middlesex   school 2507020 160   Lowell 250702001026 1600310 B.F. Butler Middle School   Regular School No Middle 05 08 2017   grade_6 43 9 41 0   32     0   7   70 62                       132 43 9 41 0   32     0   7   70 62                 132
1127011 1127011 MA Worcester   school 2507860 185   Milford 250786001240 1850305 Stacy Middle   Regular School No Middle 06 08 2017   grade_6 228 9 92 4   12     0   11   178 178                       356 228 9 92 4   12     0   11   178 178                 356
1127716 1127716 MA Bristol   school 2508730 212   North Attleborough 250873001207 2120305 North Attleborough Middle   Regular School No Middle 06 08 2017   grade_6 284 9 14 1   22     1   11   181 161                       342 284 9 14 1   22     1   11   181 161                 342
1128495 1128495 MA Suffolk   school 2510050 248   Revere 251005001963 2480014 Rumney Marsh Academy   Regular School No Middle 06 08 2017   grade_6 100 9 87 0   6     1   2   108 97                       205 100 9 87 0   6     1   2   108 97                 205
1128842 1128842 MA Norfolk   school 2510620 266   Sharon 251062002560 2660305 Sharon Middle   Regular School No Middle 06 08 2017   grade_6 155 9 17 0   72     1   12   123 143                       266 155 9 17 0   72     1   12   123 143                 266
1129373 1129373 MA Hampden   school 2511130 281   Springfield 251113002830 2810365 Chestnut Accelerated Middle School (North)   Regular School No Middle 06 08 2017   grade_6 1 9 83 0   0     0   0   40 53                       93 1 9 83 0   0     0   0   40 53                 93
1129833 1129833 MA Middlesex   school 2511910 305   Wakefield 251191000776 3050310 Galvin Middle School   Regular School No Middle 05 08 2017   grade_6 217 9 19 0   6     0   6   146 111                       257 217 9 19 0   6     0   6   146 111                 257
1130123 1130123 MA Norfolk   school 2512270 317   Wellesley 251227002029 3170305 Wellesley Middle   Regular School No Middle 06 08 2017   grade_6 291 9 18 0   46     0   28   215 177                       392 291 9 18 0   46     0   28   215 177                 392
1130740 1130740 MA Worcester   school 2513230 348   Worcester 251323002197 3480020 Belmont Street Community   Regular School No Elementary PK 06 2017   grade_6 6 9 26 0   2     0   2   20 25                       45 6 9 26 0   2     0   2   20 25                 45
1130912 1130912 MA Worcester   school 2513230 348   Worcester 251323002214 3480177 Francis J McGrath Elementary   Regular School No Elementary PK 06 2017   grade_6 13 9 16 0   1     0   5   19 25                       44 13 9 16 0   1     0   5   19 25                 44
1130997 1130997 MA Worcester   school 2513230 348   Worcester 251323002248 3480240 Union Hill School   Regular School No Elementary KG 06 2017   grade_6 6 9 41 0   2     0   3   30 31                       61 6 9 41 0   2     0   3   30 31                 61
1131913 1131913 MA Plymouth   school 2503030 625   Bridgewater-Raynham 250303002657 6250300 Williams Intermediate School   Regular School No Elementary 04 06 2017   grade_6 233 9 5 1   5     0   9   141 121                       262 233 9 5 1   5     0   9   141 121                 262
1132077 1132077 MA Barnstable   school 2504560 660   Nauset 250456000609 6600305 Nauset Regional Middle   Regular School No Middle 06 08 2017   grade_6 138 9 4 0   4     0   4   76 83                       159 138 9 4 0   4     0   4   76 83                 159
1366558 1366558 MA Middlesex   school 2503510 56   Chelmsford 250351000476 560305 Col Moses Parker School   Regular School No Middle 05 08 2020   grade_6 129 9 12 2   27     0   7   123 63 *                     186.0 129 9 12 2   27     0   7   123 63                 186
1366599 1366599 MA Suffolk   school 2503540 57   Chelsea 250354001776 570055 Joseph A. Browne School   Regular School No Middle 05 08 2020   grade_6 11 9 136 0   0     0   2   91 67 *                     158.0 11 9 136 0   0     0   2   91 67                 158
1367236 1367236 MA Barnstable   school 2504860 96   Falmouth 250486000688 960305 Morse Pond School   Regular School No Middle 05 06 2020   grade_6 217 9 15 11   4     0   24   148 132 *                     280.0 217 9 15 11   4     0   24   148 132                 280
1367257 1367257 MA Worcester   school 2504890 97   Fitchburg 250489001523 970048 Memorial Middle School   Regular School No Middle 05 08 2020   grade_6 59 9 92 0   9     1   11   82 99 *                     181.0 59 9 92 0   9     1   11   82 99                 181
1368693 1368693 MA Bristol   school 2507230 167   Mansfield 250723001112 1670035 Harold L Qualters Middle   Regular School No Middle 06 08 2020   grade_6 231 9 20 0   16     0   7   149 134 *                     283.0 231 9 20 0   16     0   7   149 134                 283
1370000 1370000 MA Berkshire   school 2509630 236   Pittsfield 250963001532 2360310 Theodore Herberg Middle   Regular School No Middle 06 08 2020   grade_6 127 9 25 1   3     0   9   87 87 *                     174.0 127 9 25 1   3     0   9   87 87                 174
1370280 1370280 MA Suffolk   school 2510050 248   Revere 251005001963 2480014 Rumney Marsh Academy   Regular School No Middle 06 08 2020   grade_6 87 9 109 0   10     0   6   133 88 *                     221.0 87 9 109 0   10     0   6   133 88                 221
1371022 1371022 MA Hampden   school 2511130 281   Springfield 251113002830 2810365 Chestnut Academy   Regular School No Middle 06 08 2020   grade_6 3 9 95 0   1     0   0   67 41 *                     108.0 3 9 95 0   1     0   0   67 41                 108
1371863 1371863 MA Hampden   school 2512510 332   West Springfield 251251001243 3320305 West Springfield Middle   Regular School No Middle 06 08 2020   grade_6 203 9 61 0   25     0   16   154 160 *                     314.0 203 9 61 0   25     0   16   154 160                 314
1372131 1372131 MA Worcester   school 2513230 348   Worcester 251323002197 3480020 Belmont Street Community   Regular School No Elementary PK 06 2020   grade_6 13 9 25 0   3     0   3   28 25 *                     53.0 13 9 25 0   3     0   3   28 25                 53
1372199 1372199 MA Worcester   school 2513230 348   Worcester 251323002207 3480060 Columbus Park   Regular School No Elementary PK 06 2020   grade_6 24 9 31 1   4     0   2   38 33 *                     71.0 24 9 31 1   4     0   2   38 33                 71
1372482 1372482 MA Berkshire   school 2500079 414   Berkshire Arts and Technology Charter Public (District) 250007901842 4140305 Berkshire Arts and Technology Charter Public School   Regular School Yes High 06 12 2020   grade_6 50 9 9 0   1     0   3   39 33 *                     72.0 50 9 9 0   1     0   3   39 33                 72
1372506 1372506 MA Middlesex   school 2500068 418   Christa McAuliffe Charter Public (District) 250006801746 4180305 Christa McAuliffe Charter Public School   Regular School Yes Middle 06 08 2020   grade_6 67 9 56 0   11     0   2   74 71 *                     145.0 67 9 56 0   11     0   2   74 71                 145
1672244 1672244 MA Bristol   school 2502190 16   Attleboro 250219000096 160305 Attleboro - Robert J. Coelho Middle School   Regular School No Middle 05 08 2021   grade_6 97 9 15 0   8     0   7   75 61 *                     136.0 97 9 15 0   8     0   7   75 61                 136
1673969 1673969 MA Middlesex   school 2503840 67   Concord 250384000522 670305 Concord - Concord Middle   Regular School No Middle 06 08 2021   grade_6 159 9 15 0   11     0   21   114 101 *                     215.0 159 9 15 0   11     0   21   114 101                 215
1674989 1674989 MA Plymouth   school 2506090 131   Hingham 250609000875 1310410 Hingham - Hingham Middle School   Regular School No Middle 06 08 2021   grade_6 265 9 13 0   3     0   8   144 153 *                     298.0 265 9 13 0   3     0   8   144 153                 298
1676269 1676269 MA Worcester   school 2507860 185   Milford 250786001240 1850305 Milford - Stacy Middle   Regular School No Middle 06 08 2021   grade_6 204 9 86 7   4     1   19   175 155 *                     330.0 204 9 86 7   4     1   19   175 155                 330
1676406 1676406 MA Middlesex   school 2508340 198   Natick 250834001305 1980310 Natick - Wilson Middle   Regular School No Middle 05 08 2021   grade_6 149 9 12 1   18     1   11   102 99 *                     201.0 149 9 12 1   18     1   11   102 99                 201
1677320 1677320 MA Plymouth   school 2509720 239   Plymouth 250972002531 2390405 Plymouth - Plymouth Commun Intermediate   Regular School No Middle 06 08 2021   grade_6 267 9 24 0   6     0   18   167 157 *                     324.0 267 9 24 0   6     0   18   167 157                 324
1677424 1677424 MA Norfolk   school 2509870 243   Quincy 250987001581 2430320 Quincy - South West Middle School   Regular School No Middle 05 08 2021   grade_6 36 9 15 1   38     1   5   74 31 *                     105.0 36 9 15 1   38     1   5   74 31                 105
1678293 1678293 MA Hampden   school 2511130 281   Springfield 251113002818 2810475 Springfield - Conservatory of the Arts   Regular School No High 06 12 2021   grade_6 7 9 38 0   1     1   0   19 37 *                     56.0 7 9 38 0   1     1   0   19 37                 56
1678482 1678482 MA Essex   school 2511430 291   Swampscott 251143002562 2910305 Swampscott - Swampscott Middle   Regular School No Middle 05 08 2021   grade_6 107 9 24 0   7     0   6   75 78 *                     153.0 107 9 24 0   7     0   6   75 78                 153
1679377 1679377 MA Middlesex   school 2513200 347   Woburn 251320002182 3470410 Woburn - Daniel L Joyce Middle School   Regular School No Middle 06 08 2021   grade_6 106 9 20 2   3     0   6   70 76 *                     146.0 106 9 20 2   3     0   6   70 76                 146
1679505 1679505 MA Worcester   school 2513230 348   Worcester 251323002224 3480136 Worcester - Heard Street   Regular School No Elementary KG 06 2021   grade_6 17 9 4 0   4     0   1   15 20 *                     35.0 17 9 4 0   4     0   1   15 20                 35
1679618 1679618 MA Worcester   school 2513230 348   Worcester 251323002248 3480240 Worcester - Union Hill School   Regular School No Elementary KG 06 2021   grade_6 12 9 39 0   0     0   0   24 36 *                     60.0 12 9 39 0   0     0   0   24 36                 60
1679769 1679769 MA Middlesex   school 2500068 418   Christa McAuliffe Charter Public (District) 250006801746 4180305 Christa McAuliffe Charter Public (District) - Christa McAuliffe Charter Public School   Regular School Yes Middle 06 08 2021   grade_6 50 9 48 1   12     0   10   75 55 *                     130.0 50 9 48 1   12     0   10   75 55                 130
2040048 2040048 MA Bristol   school 2502190 16   Attleboro 250219000096 160305 Robert J. Coelho Middle School   Regular School No Middle 05 08 2019   grade_6 120 9 24 0   6     0   10   98 71                       169.0 120 9 24 0   6     0   10   98 71                 169
2040134 2040134 MA Middlesex   school 2502400 23   Bedford 250240000130 230305 John Glenn Middle   Regular School No Middle 06 08 2019   grade_6 142 9 8 1   36     0   1   112 85                       197.0 142 9 8 1   36     0   1   112 85                 197
2040469 2040469 MA Suffolk   school 2502790 35   Boston 250279000230 350096 Eliot Elementary   Regular School No Elementary PK 08 2019   grade_6 41 9 22 0   8     0   1   40 41                       81.0 41 9 22 0   8     0   1   40 41                 81
2040622 2040622 MA Suffolk   school 2502790 35   Boston 250279000278 350190 Joyce Kilmer   Regular School No Elementary PK 08 2019   grade_6 25 9 12 0   8     0   6   23 37                       60.0 25 9 12 0   8     0   6   23 37                 60
2040792 2040792 MA Suffolk   school 2502790 35   Boston 250279000331 350326 Gardner Pilot Academy   Regular School No Elementary PK 08 2019   grade_6 10 9 25 0   1     0   3   24 24                       48.0 10 9 25 0   1     0   3   24 24                 48
2040809 2040809 MA Suffolk   school 2502790 35   Boston 250279000333 350346 Warren-Prescott   Regular School No Elementary PK 08 2019   grade_6 29 9 14 0   4     0   5   27 34                       61.0 29 9 14 0   4     0   5   27 34                 61
2041738 2041738 MA Hampden   school 2503660 61   Chicopee 250366000491 610305 Bellamy Middle   Regular School No Middle 06 08 2019   grade_6 143 9 120 0   5     0   11   148 140                       288.0 143 9 120 0   5     0   11   148 140                 288
2041741 2041741 MA Hampden   school 2503660 61   Chicopee 250366000722 610310 Dupont Middle   Regular School No Middle 06 08 2019   grade_6 122 9 111 1   8     0   9   141 119                       260.0 122 9 111 1   8     0   9   141 119                 260
2044092 2044092 MA Worcester   school 2507860 185   Milford 250786001240 1850305 Stacy Middle   Regular School No Middle 06 08 2019   grade_6 193 9 107 14   5     0   13   185 156                       341.0 193 9 107 14   5     0   13   185 156                 341
2044271 2044271 MA Norfolk   school 2508370 199   Needham 250837002690 1990410 High Rock School   Regular School No Middle 06 06 2019   grade_6 359 9 28 0   30     0   24   224 226                       450.0 359 9 28 0   30     0   24   224 226                 450
2044543 2044543 MA Middlesex   school 2508610 207   Newton 250861001042 2070320 Oak Hill Middle   Regular School No Middle 06 08 2019   grade_6 108 9 13 0   62     0   14   121 85                       206.0 108 9 13 0   62     0   14   121 85                 206

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