enrollments

Data source: Big Local News · About: Big Local

4,038 rows where grade = "grade_6" and state = "MA" sorted by asian_int 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
1370604 1370604 MA Worcester   school 2510770 271   Shrewsbury 251077001716 2710305 Sherwood Middle School   Regular School No Middle 05 06 2020   grade_6 257 10 43 2   171     0   21   253 251 *                     504.0 257 10 43 2   171     0   21   253 251                 504
1677855 1677855 MA Worcester   school 2510770 271   Shrewsbury 251077001716 2710305 Shrewsbury - Sherwood Middle School   Regular School No Middle 05 06 2021   grade_6 240 13 53 2   159     0   24   236 255 *                     491.0 240 13 53 2   159     0   24   236 255                 491
2045679 2045679 MA Worcester   school 2510770 271   Shrewsbury 251077001716 2710305 Sherwood Middle School   Regular School No Middle 05 06 2019   grade_6 236 15 50 1   149     0   17   248 220                       468.0 236 15 50 1   149     0   17   248 220                 468
2235712 2235712 MA Worcester   school 2510770 271   Shrewsbury 251077001716 2710305 Shrewsbury: Sherwood Middle School   Regular School No Middle 05 06 2018   grade_6 291 15 35 1   143     0   18   263 240                       503.0 291 15 35 1   143     0   18   263 240                 503
1368205 1368205 MA Middlesex   school 2506840 155   Lexington 250684002552 1550310 Wm Diamond Middle   Regular School No Middle 06 08 2020   grade_6 118 13 9 0   134     0   26   148 152 *                     300.0 118 13 9 0   134     0   26   148 152                 300
2043289 2043289 MA Middlesex   school 2506840 155   Lexington 250684002552 1550310 Wm Diamond Middle   Regular School No Middle 06 08 2019   grade_6 131 6 12 0   134     0   30   148 165                       313.0 131 6 12 0   134     0   30   148 165                 313
1128891 1128891 MA Worcester   school 2510770 271   Shrewsbury 251077001716 2710305 Sherwood Middle School   Regular School No Middle 05 06 2017   grade_6 300 11 35 1   130     0   13   240 250                       490 300 11 35 1   130     0   13   240 250                 490
1368202 1368202 MA Middlesex   school 2506840 155   Lexington 250684002551 1550305 Jonas Clarke Middle   Regular School No Middle 06 08 2020   grade_6 148 15 8 1   130     1   12   179 136 *                     315.0 148 15 8 1   130     1   12   179 136                 315
938376 938376 MA Worcester   school 2510770 271   Shrewsbury 251077001716 2710305 Sherwood Middle School   Regular School No 2 05 06 2016   grade_6 302 8 43 2   129     0   16   254 246                       500 302 8 43 2   129     0   16   254 246                 500
1126056 1126056 MA Middlesex   school 2506840 155   Lexington 250684002551 1550305 Jonas Clarke Middle   Regular School No Middle 06 08 2017   grade_6 136 17 11 0   129     0   10   158 145                       303 136 17 11 0   129     0   10   158 145                 303
2043286 2043286 MA Middlesex   school 2506840 155   Lexington 250684002551 1550305 Jonas Clarke Middle   Regular School No Middle 06 08 2019   grade_6 144 11 12 0   128     0   11   147 159                       306.0 144 11 12 0   128     0   11   147 159                 306
2232872 2232872 MA Middlesex   school 2506840 155   Lexington 250684002551 1550305 Lexington: Jonas Clarke Middle   Regular School No Middle 06 08 2018   grade_6 124 16 15 0   125     0   23   150 153                       303.0 124 16 15 0   125     0   23   150 153                 303
741571 741571 MA Worcester   school 2510770 271   Shrewsbury 251077001716 2710305 Sherwood Middle School   Regular School No 2 05 06 2015   grade_6 288 11 30 2   122     0   16   237 232                       469 288 11 30 2   122     0   16   237 232                 469
1675447 1675447 MA Middlesex   school 2506840 155   Lexington 250684002551 1550305 Lexington - Jonas Clarke Middle   Regular School No Middle 06 08 2021   grade_6 115 11 11 1   120     0   20   150 128 *                     278.0 115 11 11 1   120     0   20   150 128                 278
2046759 2046759 MA Worcester   school 2512600 321   Westborough 251260001734 3210045 Mill Pond School   Regular School No Middle 04 06 2019   grade_6 175 2 17 0   120     0   7   152 169                       321.0 175 2 17 0   120     0   7   152 169                 321
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
1675450 1675450 MA Middlesex   school 2506840 155   Lexington 250684002552 1550310 Lexington - Wm Diamond Middle   Regular School No Middle 06 08 2021   grade_6 127 13 12 0   113     0   24   152 137 *                     289.0 127 13 12 0   113     0   24   152 137                 289
1678935 1678935 MA Worcester   school 2512600 321   Westborough 251260001734 3210045 Westborough - Mill Pond School   Regular School No Middle 04 06 2021   grade_6 145 11 24 1   111     0   3   153 142 *                     295.0 145 11 24 1   111     0   3   153 142                 295
1371685 1371685 MA Worcester   school 2512600 321   Westborough 251260001734 3210045 Mill Pond School   Regular School No Middle 04 06 2020   grade_6 164 15 12 0   108     0   8   146 161 *                     307.0 164 15 12 0   108     0   8   146 161                 307
1370172 1370172 MA Norfolk   school 2509870 243   Quincy 250987001564 2430315 Central Middle   Regular School No Middle 06 08 2020   grade_6 94 8 6 0   105     2   4   111 108 *                     219.0 94 8 6 0   105     2   4   111 108                 219
739357 739357 MA Middlesex   school 2507020 160   Lowell 250702001955 1600360 Kathryn P. Stoklosa Middle School   Regular School No 2 05 08 2015   grade_6 16 5 39 0   102     0   5   88 79                       167 16 5 39 0   102     0   5   88 79                 167
936003 936003 MA Middlesex   school 2506840 155   Lexington 250684002551 1550305 Jonas Clarke Middle   Regular School No 2 06 08 2016   grade_6 159 19 11 0   102     0   11   167 135                       302 159 19 11 0   102     0   11   167 135                 302
2045240 2045240 MA Norfolk   school 2509870 243   Quincy 250987001561 2430305 Atlantic Middle   Regular School No Middle 06 08 2019   grade_6 71 3 8 0   101     0   3   95 91                       186.0 71 3 8 0   101     0   3   95 91                 186
1370166 1370166 MA Norfolk   school 2509870 243   Quincy 250987001561 2430305 Atlantic Middle   Regular School No Middle 06 08 2020   grade_6 60 7 9 0   100     1   3   90 90 *                     180.0 60 7 9 0   100     1   3   90 90                 180
1370565 1370565 MA Norfolk   school 2510620 266   Sharon 251062002560 2660305 Sharon Middle   Regular School No Middle 06 08 2020   grade_6 148 14 17 0   99     0   19   156 141 *                     297.0 148 14 17 0   99     0   19   156 141                 297
1365176 1365176 MA Middlesex   school 2502490 26   Belmont 250249000149 260305 Winthrop L Chenery Middle   Regular School No Middle 05 08 2020   grade_6 225 12 23 1   96     1   27   193 192 *                     385.0 225 12 23 1   96     1   27   193 192                 385
2233114 2233114 MA Middlesex   school 2507020 160   Lowell 250702001955 1600360 Lowell: Kathryn P. Stoklosa Middle School   Regular School No Middle 05 08 2018   grade_6 21 6 50 0   94     0   4   86 89                       175.0 21 6 50 0   94     0   4   86 89                 175
2232876 2232876 MA Middlesex   school 2506840 155   Lexington 250684002552 1550310 Lexington: Wm Diamond Middle   Regular School No Middle 06 08 2018   grade_6 123 13 11 0   93     0   25   128 137                       265.0 123 13 11 0   93     0   25   128 137                 265
933744 933744 MA Suffolk   school 2502790 35   Boston 250279001296 350565 Quincy Upper School   Regular School No 4 06 12 2016   grade_6 6 18 24 1   91     0   4   73 71                       144 6 18 24 1   91     0   4   73 71                 144
936006 936006 MA Middlesex   school 2506840 155   Lexington 250684002552 1550310 Wm Diamond Middle   Regular School No 2 06 08 2016   grade_6 143 13 4 0   91     0   20   128 143                       271 143 13 4 0   91     0   20   128 143                 271
1677816 1677816 MA Norfolk   school 2510620 266   Sharon 251062002560 2660305 Sharon - Sharon Middle   Regular School No Middle 06 08 2021   grade_6 136 16 19 1   91     1   28   143 148 *                     292.0 136 16 19 1   91     1   28   143 148                 292
2235181 2235181 MA Norfolk   school 2509870 243   Quincy 250987001561 2430305 Quincy: Atlantic Middle   Regular School No Middle 06 08 2018   grade_6 73 6 4 0   91     1   9   100 84                       184.0 73 6 4 0   91     1   9   100 84                 184
2236973 2236973 MA Worcester   school 2512600 321   Westborough 251260001734 3210045 Westborough: Mill Pond School   Regular School No Middle 04 06 2018   grade_6 182 4 21 0   91     1   10   154 155                       309.0 182 4 21 0   91     1   10   154 155                 309
741117 741117 MA Norfolk   school 2509870 243   Quincy 250987001564 2430315 Central Middle   Regular School No 2 06 08 2015   grade_6 121 6 6 0   90     1   6   117 113                       230 121 6 6 0   90     1   6   117 113                 230
937946 937946 MA Norfolk   school 2509870 243   Quincy 250987001564 2430315 Central Middle   Regular School No 2 06 08 2016   grade_6 108 5 5 0   90     2   5   120 95                       215 108 5 5 0   90     2   5   120 95                 215
1128368 1128368 MA Norfolk   school 2509870 243   Quincy 250987001564 2430315 Central Middle   Regular School No Middle 06 08 2017   grade_6 105 6 6 0   89     0   5   109 102                       211 105 6 6 0   89     0   5   109 102                 211
739157 739157 MA Middlesex   school 2506840 155   Lexington 250684002551 1550305 Jonas Clarke Middle   Regular School No 2 06 08 2015   grade_6 126 12 9 1   88     0   14   122 128                       250 126 12 9 1   88     0   14   122 128                 250
1130158 1130158 MA Worcester   school 2512600 321   Westborough 251260001734 3210045 Mill Pond School   Regular School No Elementary 04 06 2017   grade_6 161 1 16 0   88     0   13   151 128                       279 161 1 16 0   88     0   13   151 128                 279
1677414 1677414 MA Norfolk   school 2509870 243   Quincy 250987001561 2430305 Quincy - Atlantic Middle   Regular School No Middle 06 08 2021   grade_6 48 12 16 0   88     0   6   93 77 *                     170.0 48 12 16 0   88     0   6   93 77                 170
939441 939441 MA Worcester   school 2512600 321   Westborough 251260001734 3210045 Mill Pond School   Regular School No 2 04 06 2016   grade_6 177 3 22 0   86     0   20   155 153                       308 177 3 22 0   86     0   20   155 153                 308
1368386 1368386 MA Middlesex   school 2507020 160   Lowell 250702001036 1600315 James S Daley Middle School   Regular School No Middle 05 08 2020   grade_6 46 8 27 0   86     0   12   100 79 *                     179.0 46 8 27 0   86     0   12   100 79                 179
1368407 1368407 MA Middlesex   school 2507020 160   Lowell 250702001955 1600360 Kathryn P. Stoklosa Middle School   Regular School No Middle 05 08 2020   grade_6 26 8 49 0   84     0   3   93 77 *                     170.0 26 8 49 0   84     0   3   93 77                 170
2041030 2041030 MA Suffolk   school 2502790 35   Boston 250279001296 350565 Quincy Upper School   Regular School No High 06 12 2019   grade_6 10 19 22 0   84     0   8   78 65                       143.0 10 19 22 0   84     0   8   78 65                 143
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
1673223 1673223 MA Suffolk   school 2502790 35   Boston 250279001296 350565 Boston - Quincy Upper School   Regular School No High 06 12 2021   grade_6 9 20 20 0   83     0   4   67 69 *                     136.0 9 20 20 0   83     0   4   67 69                 136
2045246 2045246 MA Norfolk   school 2509870 243   Quincy 250987001564 2430315 Central Middle   Regular School No Middle 06 08 2019   grade_6 92 5 6 0   83     2   9   94 103                       197.0 92 5 6 0   83     2   9   94 103                 197
739160 739160 MA Middlesex   school 2506840 155   Lexington 250684002552 1550310 Wm Diamond Middle   Regular School No 2 06 08 2015   grade_6 147 8 8 0   82     0   13   138 120                       258 147 8 8 0   82     0   13   138 120                 258
936204 936204 MA Middlesex   school 2507020 160   Lowell 250702001955 1600360 Kathryn P. Stoklosa Middle School   Regular School No 2 05 08 2016   grade_6 19 15 56 0   82     0   4   87 89                       176 19 15 56 0   82     0   4   87 89                 176
1123367 1123367 MA Suffolk   school 2502790 35   Boston 250279001296 350565 Quincy Upper School   Regular School No Other 06 12 2017   grade_6 8 20 19 0   82     0   5   71 63                       134 8 20 19 0   82     0   5   71 63                 134
1365986 1365986 MA Suffolk   school 2502790 35   Boston 250279001296 350565 Quincy Upper School   Regular School No High 06 12 2020   grade_6 7 24 23 0   82     0   5   71 70 *                     141.0 7 24 23 0   82     0   5   71 70                 141
2045640 2045640 MA Norfolk   school 2510620 266   Sharon 251062002560 2660305 Sharon Middle   Regular School No Middle 06 08 2019   grade_6 170 10 10 0   82     0   14   138 148                       286.0 170 10 10 0   82     0   14   138 148                 286
2235663 2235663 MA Norfolk   school 2510620 266   Sharon 251062002560 2660305 Sharon: Sharon Middle   Regular School No Middle 06 08 2018   grade_6 168 11 10 1   82     0   13   154 131                       285.0 168 11 10 1   82     0   13   154 131                 285
741532 741532 MA Norfolk   school 2510620 266   Sharon 251062002560 2660305 Sharon Middle   Regular School No 2 06 08 2015   grade_6 162 14 12 0   81     1   11   153 128                       281 162 14 12 0   81     1   11   153 128                 281
2233089 2233089 MA Middlesex   school 2507020 160   Lowell 250702001036 1600315 Lowell: James S Daley Middle School   Regular School No Middle 05 08 2018   grade_6 55 6 36 0   81     0   8   97 89                       186.0 55 6 36 0   81     0   8   97 89                 186
1365634 1365634 MA Suffolk   school 2502790 35   Boston 250279000315 350240 Richard J Murphy   Regular School No Elementary PK 08 2020   grade_6 16 19 31 0   80     0   6   94 58 *                     152.0 16 19 31 0   80     0   6   94 58                 152
2043471 2043471 MA Middlesex   school 2507020 160   Lowell 250702001036 1600315 James S Daley Middle School   Regular School No Middle 05 08 2019   grade_6 42 7 35 0   80     0   7   99 72                       171.0 42 7 35 0   80     0   7   99 72                 171
741111 741111 MA Norfolk   school 2509870 243   Quincy 250987001561 2430305 Atlantic Middle   Regular School No 2 06 08 2015   grade_6 67 6 6 2   79     0   3   77 86                       163 67 6 6 2   79     0   3   77 86                 163
937940 937940 MA Norfolk   school 2509870 243   Quincy 250987001561 2430305 Atlantic Middle   Regular School No 2 06 08 2016   grade_6 71 1 0 0   79     1   9   81 80                       161 71 1 0 0   79     1   9   81 80                 161
1126271 1126271 MA Middlesex   school 2507020 160   Lowell 250702001036 1600315 James S Daley Middle School   Regular School No Middle 05 08 2017   grade_6 47 8 34 0   79     0   6   92 82                       174 47 8 34 0   79     0   6   92 82                 174
1675631 1675631 MA Middlesex   school 2507020 160   Lowell 250702001036 1600315 Lowell - James S Daley Middle School   Regular School No Middle 05 08 2021   grade_6 50 6 36 0   79     0   9   97 83 *                     180.0 50 6 36 0   79     0   9   97 83                 180
1677420 1677420 MA Norfolk   school 2509870 243   Quincy 250987001564 2430315 Quincy - Central Middle   Regular School No Middle 06 08 2021   grade_6 104 5 8 0   78     1   3   100 99 *                     199.0 104 5 8 0   78     1   3   100 99                 199
736880 736880 MA Suffolk   school 2502790 35   Boston 250279001296 350565 Quincy Upper School   Regular School No 4 06 12 2015   grade_6 12 17 18 0   77     1   6   75 56                       131 12 17 18 0   77     1   6   75 56                 131
936183 936183 MA Middlesex   school 2507020 160   Lowell 250702001036 1600315 James S Daley Middle School   Regular School No 2 05 08 2016   grade_6 46 6 30 0   77     0   9   82 86                       168 46 6 30 0   77     0   9   82 86                 168
1126296 1126296 MA Middlesex   school 2507020 160   Lowell 250702001955 1600360 Kathryn P. Stoklosa Middle School   Regular School No Middle 05 08 2017   grade_6 10 3 52 0   77     0   6   80 68                       148 10 3 52 0   77     0   6   80 68                 148
2040202 2040202 MA Middlesex   school 2502490 26   Belmont 250249000149 260305 Winthrop L Chenery Middle   Regular School No Middle 05 08 2019   grade_6 229 14 18 0   77     0   26   191 173                       364.0 229 14 18 0   77     0   26   191 173                 364
2043490 2043490 MA Middlesex   school 2507020 160   Lowell 250702001955 1600360 Kathryn P. Stoklosa Middle School   Regular School No Middle 05 08 2019   grade_6 18 12 50 0   77     0   10   81 86                       167.0 18 12 50 0   77     0   10   81 86                 167
2230172 2230172 MA Suffolk   school 2502790 35   Boston 250279001296 350565 Boston: Quincy Upper School   Regular School No High 06 12 2018   grade_6 9 29 28 0   76     0   5   68 79                       147.0 9 29 28 0   76     0   5   68 79                 147
1372047 1372047 MA Middlesex   school 2513110 344   Winchester 251311002167 3440305 McCall Middle   Regular School No Middle 06 08 2020   grade_6 285 5 10 0   75     0   29   218 186 *                     404.0 285 5 10 0   75     0   29   218 186                 404
1672398 1672398 MA Middlesex   school 2502490 26   Belmont 250249000149 260305 Belmont - Winthrop L Chenery Middle   Regular School No Middle 05 08 2021   grade_6 251 8 8 0   74     0   24   184 181 *                     365.0 251 8 8 0   74     0   24   184 181                 365
1672867 1672867 MA Suffolk   school 2502790 35   Boston 250279000315 350240 Boston - Richard J Murphy   Regular School No Elementary PK 08 2021   grade_6 10 24 23 1   74     0   7   78 61 *                     139.0 10 24 23 1   74     0   7   78 61                 139
1128360 1128360 MA Norfolk   school 2509870 243   Quincy 250987001561 2430305 Atlantic Middle   Regular School No Middle 06 08 2017   grade_6 48 13 7 0   73     0   7   68 80                       148 48 13 7 0   73     0   7   68 80                 148
742633 742633 MA Worcester   school 2512600 321   Westborough 251260001734 3210045 Mill Pond School   Regular School No 2 04 06 2015   grade_6 204 4 16 1   72     1   11   180 129                       309 204 4 16 1   72     1   11   180 129                 309
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
1675651 1675651 MA Middlesex   school 2507020 160   Lowell 250702001955 1600360 Lowell - Kathryn P. Stoklosa Middle School   Regular School No Middle 05 08 2021   grade_6 23 5 62 0   72     0   7   95 74 *                     169.0 23 5 62 0   72     0   7   95 74                 169
1679036 1679036 MA Middlesex   school 2512660 326   Westford 251266000170 3260310 Westford - Blanchard Middle   Regular School No Middle 06 08 2021   grade_6 95 4 3 0   72     0   7   84 97 *                     181.0 95 4 3 0   72     0   7   84 97                 181
1130301 1130301 MA Middlesex   school 2512660 326   Westford 251266002080 3260330 Stony Brook School   Regular School No Middle 06 08 2017   grade_6 176 0 0 0   70     0   5   144 107                       251 176 0 0 0   70     0   5   144 107                 251
739336 739336 MA Middlesex   school 2507020 160   Lowell 250702001036 1600315 James S Daley Middle School   Regular School No 2 05 08 2015   grade_6 51 10 24 0   69     0   8   85 77                       162 51 10 24 0   69     0   8   85 77                 162
933397 933397 MA Suffolk   school 2502790 35   Boston 250279000315 350240 Richard J Murphy   Regular School No 1 PK 08 2016   grade_6 23 28 24 1   69     1   3   72 77                       149 23 28 24 1   69     1   3   72 77                 149
2235189 2235189 MA Norfolk   school 2509870 243   Quincy 250987001564 2430315 Quincy: Central Middle   Regular School No Middle 06 08 2018   grade_6 121 4 5 0   69     1   6   92 114                       206.0 121 4 5 0   69     1   6   92 114                 206
1130632 1130632 MA Middlesex   school 2513110 344   Winchester 251311002167 3440305 McCall Middle   Regular School No Middle 06 08 2017   grade_6 283 6 12 1   68     0   16   200 186                       386 283 6 12 1   68     0   16   200 186                 386
2040677 2040677 MA Suffolk   school 2502790 35   Boston 250279000315 350240 Richard J Murphy   Regular School No Elementary PK 08 2019   grade_6 15 24 34 0   68     1   4   83 63                       146.0 15 24 34 0   68     1   4   83 63                 146
1369467 1369467 MA Middlesex   school 2508610 207   Newton 250861000314 2070315 F A Day Middle   Regular School No Middle 06 08 2020   grade_6 195 19 24 1   67     0   24   164 166 *                     330.0 195 19 24 1   67     0   24   164 166                 330
937236 937236 MA Middlesex   school 2508610 207   Newton 250861000310 2070310 Charles E Brown Middle   Regular School No 2 06 08 2016   grade_6 168 13 21 0   66     0   16   160 124                       284 168 13 21 0   66     0   16   160 124                 284
1675131 1675131 MA Middlesex   school 2506330 139   Hopkinton 250633000468 1390305 Hopkinton - Hopkinton Middle School   Regular School No Middle 06 08 2021   grade_6 210 3 8 2   66     0   14   161 142 *                     303.0 210 3 8 2   66     0   14   161 142                 303
1122971 1122971 MA Suffolk   school 2502790 35   Boston 250279000315 350240 Richard J Murphy   Regular School No Elementary PK 08 2017   grade_6 32 28 23 0   65     0   2   74 76                       150 32 28 23 0   65     0   2   74 76                 150
1369470 1369470 MA Middlesex   school 2508610 207   Newton 250861001042 2070320 Oak Hill Middle   Regular School No Middle 06 08 2020   grade_6 137 18 10 0   65     0   10   126 114 *                     240.0 137 18 10 0   65     0   10   126 114                 240
2042966 2042966 MA Middlesex   school 2506330 139   Hopkinton 250633000468 1390305 Hopkinton Middle School   Regular School No Middle 06 08 2019   grade_6 212 1 13 0   65     0   10   151 150                       301.0 212 1 13 0   65     0   10   151 150                 301
2046729 2046729 MA Norfolk   school 2512270 317   Wellesley 251227002029 3170305 Wellesley Middle   Regular School No Middle 06 08 2019   grade_6 264 22 15 0   65     0   28   180 213                       394.0 264 22 15 0   65     0   28   180 213                 394
1676713 1676713 MA Middlesex   school 2508610 207   Newton 250861000310 2070310 Newton - Charles E Brown Middle   Regular School No Middle 06 08 2021   grade_6 160 11 19 1   64     0   16   140 131 *                     271.0 160 11 19 1   64     0   16   140 131                 271
2048094 2048094 MA Middlesex   school 2501710 600   Acton-Boxborough 250171000009 6000030 Luther Conant School   Regular School No Elementary KG 06 2019   grade_6 18 1 8 0   64     1   2   43 51                       94.0 18 1 8 0   64     1   2   43 51                 94
939826 939826 MA Middlesex   school 2513110 344   Winchester 251311002167 3440305 McCall Middle   Regular School No 2 06 08 2016   grade_6 264 0 14 1   63     1   20   181 182                       363 264 0 14 1   63     1   20   181 182                 363
2047121 2047121 MA Middlesex   school 2513110 344   Winchester 251311002167 3440305 McCall Middle   Regular School No Middle 06 08 2019   grade_6 245 3 11 1   63     0   30   178 175                       353.0 245 3 11 1   63     0   30   178 175                 353
1122421 1122421 MA Middlesex   school 2502490 26   Belmont 250249000149 260305 Winthrop L Chenery Middle   Regular School No Middle 05 08 2017   grade_6 233 15 11 0   62     1   19   171 170                       341 233 15 11 0   62     1   19   171 170                 341
2041182 2041182 MA Norfolk   school 2502940 40   Braintree 250294000364 400305 East Middle School   Regular School No Middle 06 08 2019   grade_6 154 27 17 0   62     0   2   134 128                       262.0 154 27 17 0   62     0   2   134 128                 262
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
2040000 2040000 MA Middlesex   school 2501980 10   Arlington 250198002889 100305 Gibbs School   Regular School No Middle 06 06 2019   grade_6 321 15 34 1   61     1   30   250 213                       463.0 321 15 34 1   61     1   30   250 213                 463
2229777 2229777 MA Suffolk   school 2502790 35   Boston 250279000315 350240 Boston: Richard J Murphy   Regular School No Elementary PK 08 2018   grade_6 22 18 40 0   61     0   5   70 76                       146.0 22 18 40 0   61     0   5   70 76                 146
2237460 2237460 MA Middlesex   school 2513110 344   Winchester 251311002167 3440305 Winchester: McCall Middle   Regular School No Middle 06 08 2018   grade_6 279 4 14 2   61     0   15   177 198                       375.0 279 4 14 2   61     0   15   177 198                 375
1672196 1672196 MA Middlesex   school 2501980 10   Arlington 250198002889 100305 Arlington - Gibbs School   Regular School No Middle 06 06 2021   grade_6 334 21 31 2   60     1   34   260 223 *                     483.0 334 21 31 2   60     1   34   260 223                 483
1679039 1679039 MA Middlesex   school 2512660 326   Westford 251266002080 3260330 Westford - Stony Brook School   Regular School No Middle 06 08 2021   grade_6 132 1 3 0   60     0   10   101 105 *                     206.0 132 1 3 0   60     0   10   101 105                 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]);