enrollments

Data source: Big Local News · About: Big Local

3,471 rows where grade = "grade_7" and state = "MA" sorted by black descending

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

grade ✖

  • grade_7 · 3,471 ✖
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
737153 737153 MA Plymouth   school 2503090 44   Brockton 250309000407 440415 South Middle School   Regular School No 2 06 08 2015   grade_7 32 99 32 0   7     0   9   94 85                       179 32 99 32 0   7     0   9   94 85                 179
2041297 2041297 MA Plymouth   school 2503090 44   Brockton 250309000404 440410 North Middle School   Regular School No Middle 07 08 2019   grade_7 14 99 29 1   4     0   8   96 59                       155.0 14 99 29 1   4     0   8   96 59                 155
2047616 2047616 MA Suffolk   school 2500071 428   Brooke Charter School (District) 250007101747 4280305 Brooke Charter School   Regular School Yes Other KG 11 2019   grade_7 5 99 73 0   2     0   0   91 88                       179.0 5 99 73 0   2     0   0   91 88                 179
2238035 2238035 MA Suffolk   school 2500071 428   Brooke Charter School (District) 250007101747 4280305 Brooke Charter School (District): Brooke Charter School   Regular School Yes Other KG 10 2018   grade_7 9 99 59 0   3     0   4   88 86                       174.0 9 99 59 0   3     0   4   88 86                 174
1123696 1123696 MA Plymouth   school 2503090 44   Brockton 250309002691 440422 Joseph F. Plouffe Academy   Regular School No Middle 06 08 2017   grade_7 48 98 65 0   3     1   19   102 132                       234 48 98 65 0   3     1   19   102 132                 234
1374253 1374253 MA Plymouth   school 2500559 3513   New Heights Charter School of Brockton (District) 250055902869 35130305 New Heights Charter School of Brockton   Regular School Yes Secondary 06 11 2020   grade_7 4 98 4 0   0     0   1   47 60 *                     107.0 4 98 4 0   0     0   1   47 60                 107
1679804 1679804 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_7 5 98 66 0   4     0   3   83 93 *                     176.0 5 98 66 0   4     0   3   83 93                 176
737162 737162 MA Plymouth   school 2503090 44   Brockton 250309002691 440422 Joseph F. Plouffe Academy   Regular School No 2 06 08 2015   grade_7 58 97 54 1   5     0   6   108 113                       221 58 97 54 1   5     0   6   108 113                 221
737156 737156 MA Plymouth   school 2503090 44   Brockton 250309000410 440420 West Middle School   Regular School No 2 06 08 2015   grade_7 69 95 32 1   8     2   8   113 102                       215 69 95 32 1   8     2   8   113 102                 215
2239999 2239999 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_7 1 95 10 0   0     0   2   51 57                       108.0 1 95 10 0   0     0   2   51 57                 108
736923 736923 MA Suffolk   school 2502790 35   Boston 250279002725 350657 TechBoston Academy   Regular School No 4 06 12 2015   grade_7 3 94 27 1   7     0   2   75 59                       134 3 94 27 1   7     0   2   75 59                 134
1123688 1123688 MA Plymouth   school 2503090 44   Brockton 250309000410 440420 West Middle School   Regular School No Middle 06 08 2017   grade_7 49 92 27 1   8     1   13   102 89                       191 49 92 27 1   8     1   13   102 89                 191
1133179 1133179 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_7 4 92 8 0   0     0   0   59 45                       104 4 92 8 0   0     0   0   59 45                 104
1370219 1370219 MA Norfolk   school 2509930 244   Randolph 250993001392 2440410 Randolph Community Middle   Regular School No Middle 06 08 2020   grade_7 25 92 45 1   44     0   14   118 103 *                     221.0 25 92 45 1   44     0   14   118 103                 221
934022 934022 MA Plymouth   school 2503090 44   Brockton 250309002691 440422 Joseph F. Plouffe Academy   Regular School No 2 06 08 2016   grade_7 63 91 51 2   7     0   10   111 113                       224 63 91 51 2   7     0   10   111 113                 224
2235243 2235243 MA Norfolk   school 2509930 244   Randolph 250993001392 2440410 Randolph: Randolph Community Middle   Regular School No Middle 06 08 2018   grade_7 28 91 29 1   32     0   10   95 96                       191.0 28 91 29 1   32     0   10   95 96                 191
735898 735898 MA Bristol   school 2502190 16   Attleboro 250219000096 160305 Robert J. Coelho Middle School   Regular School No 2 05 08 2015   grade_7 134 9 11 0   8     0   4   94 72                       166 134 9 11 0   8     0   4   94 72                 166
737585 737585 MA Hampden   school 2503660 61   Chicopee 250366000491 610305 Bellamy Middle   Regular School No 2 06 08 2015   grade_7 155 9 131 0   2     0   5   156 146                       302 155 9 131 0   2     0   5   156 146                 302
738294 738294 MA Middlesex   school 2504980 100   Framingham 250498000733 1000310 Walsh Middle   Regular School No 2 06 08 2015   grade_7 113 9 75 0   18     1   9   118 107                       225 113 9 75 0   18     1   9   118 107                 225
738629 738629 MA Essex   school 2505970 128   Haverhill 250597000850 1280100 Consentino Middle School   Regular School No 1 KG 08 2015   grade_7 131 9 81 1   5     0   1   111 117                       228 131 9 81 1   5     0   1   111 117                 228
739954 739954 MA Worcester   school 2507860 185   Milford 250786001240 1850305 Stacy Middle   Regular School No 2 05 07 2015   grade_7 229 9 58 6   7     0   7   157 159                       316 229 9 58 6   7     0   7   157 159                 316
741115 741115 MA Norfolk   school 2509870 243   Quincy 250987001563 2430310 Broad Meadows Middle   Regular School No 2 06 08 2015   grade_7 66 9 4 0   21     0   4   53 51                       104 66 9 4 0   21     0   4   53 51                 104
741118 741118 MA Norfolk   school 2509870 243   Quincy 250987001564 2430315 Central Middle   Regular School No 2 06 08 2015   grade_7 129 9 3 0   72     0   3   97 119                       216 129 9 3 0   72     0   3   97 119                 216
741225 741225 MA Suffolk   school 2510050 248   Revere 251005001963 2480014 Rumney Marsh Academy   Regular School No 2 06 08 2015   grade_7 89 9 75 2   4     0   6   91 94                       185 89 9 75 2   4     0   6   91 94                 185
741301 741301 MA Plymouth   school 2510170 251   Rockland 251017001642 2510305 John W Rogers Middle   Regular School No 2 05 08 2015   grade_7 175 9 16 0   0     0   9   112 97                       209 175 9 16 0   0     0   9   112 97                 209
741380 741380 MA Essex   school 2510380 258   Salem 251038002404 2580305 Collins Middle   Regular School No 2 06 08 2015   grade_7 107 9 78 0   6     0   9   110 99                       209 107 9 78 0   6     0   9   110 99                 209
743357 743357 MA Worcester   school 2513230 348   Worcester 251323002121 3480350 Claremont Academy   Regular School No 3 07 12 2015   grade_7 7 9 80 0   8     0   3   49 58                       107 7 9 80 0   8     0   3   49 58                 107
743700 743700 MA Suffolk   school 2500539 457   Brooke Charter School East Boston (District) 250053902720 4570205 Brooke Charter School East Boston   Regular School Yes 1 KG 07 2015   grade_7 2 9 22 0   2     0   1   16 20                       36 2 9 22 0   2     0   1   16 20                 36
932778 932778 MA Bristol   school 2502190 16   Attleboro 250219000087 160315 Cyril K. Brennan Middle School   Regular School No 2 05 08 2016   grade_7 95 9 17 0   6     2   12   79 62                       141 95 9 17 0   6     2   12   79 62                 141
932782 932782 MA Bristol   school 2502190 16   Attleboro 250219000945 160320 Wamsutta Middle School   Regular School No 2 05 08 2016   grade_7 86 9 30 0   11     0   9   73 72                       145 86 9 30 0   11     0   9   73 72                 145
933441 933441 MA Suffolk   school 2502790 35   Boston 250279000692 350262 Lyndon   Regular School No 1 PK 08 2016   grade_7 5 9 23 0   0     0   0   19 18                       37 5 9 23 0   0     0   0   19 18                 37
934154 934154 MA Middlesex   school 2503240 48   Burlington 250324000429 480303 Marshall Simonds Middle   Regular School No 2 06 08 2016   grade_7 216 9 8 1   29     0   9   147 125                       272 216 9 8 1   29     0   9   147 125                 272
936201 936201 MA Middlesex   school 2507020 160   Lowell 250702000086 1600345 Dr An Wang School   Regular School No 2 05 08 2016   grade_7 61 9 68 0   29     0   4   93 78                       171 61 9 68 0   29     0   4   93 78                 171
936743 936743 MA Essex   school 2507740 181   Methuen 250774001556 1810055 Tenney Grammar School   Regular School No 1 PK 08 2016   grade_7 68 9 50 0   12     0   1   75 65                       140 68 9 50 0   12     0   1   75 65                 140
936798 936798 MA Worcester   school 2507860 185   Milford 250786001240 1850305 Stacy Middle   Regular School No 2 05 08 2016   grade_7 209 9 72 6   5     0   10   163 148                       311 209 9 72 6   5     0   10   163 148                 311
937237 937237 MA Middlesex   school 2508610 207   Newton 250861000310 2070310 Charles E Brown Middle   Regular School No 2 06 08 2016   grade_7 169 9 13 1   50     0   12   142 112                       254 169 9 13 1   50     0   12   142 112                 254
937357 937357 MA Essex   school 2508700 211   North Andover 250870001398 2110305 North Andover Middle   Regular School No 2 06 08 2016   grade_7 329 9 32 1   32     0   8   216 195                       411 329 9 32 1   32     0   8   216 195                 411
938200 938200 MA Essex   school 2510380 258   Salem 251038002404 2580305 Collins Middle   Regular School No 2 06 08 2016   grade_7 100 9 63 0   7     0   9   100 88                       188 100 9 63 0   7     0   9   100 88                 188
938795 938795 MA Hampden   school 2511130 281   Springfield 251113002840 2810367 Chestnut Accelerated Middle School (Talented and Gifted)   Regular School No 2 06 08 2016   grade_7 10 9 53 0   2     0   3   33 44                       77 10 9 53 0   2     0   3   33 44                 77
939080 939080 MA Middlesex   school 2511580 295   Tewksbury 251158000366 2950305 John W. Wynn Middle   Regular School No 2 07 08 2016   grade_7 267 9 7 0   10     0   4   145 152                       297 267 9 7 0   10     0   4   145 152                 297
939675 939675 MA Norfolk   school 2512810 335   Westwood 251281002097 3350305 E W Thurston Middle   Regular School No 2 06 08 2016   grade_7 222 9 10 0   19     0   2   116 146                       262 222 9 10 0   19     0   2   116 146                 262
940686 940686 MA Plymouth   school 2500040 488   South Shore Charter Public (District) 250004000600 4880550 South Shore Charter Public School   Regular School Yes 4 KG 12 2016   grade_7 30 9 2 0   3     0   1   20 25                       45 30 9 2 0   3     0   1   20 25                 45
941260 941260 MA Norfolk   school 2506510 690   King Philip 250651000941 6900510 King Philip Middle School   Regular School No 2 07 08 2016   grade_7 343 9 9 0   7     0   4   191 181                       372 343 9 9 0   7     0   4   191 181                 372
941478 941478 MA Plymouth   school 2509150 740   Old Rochester 250915001473 7400405 Old Rochester Regional Jr High   Regular School No 2 07 08 2016   grade_7 216 9 1 0   3     0   10   112 127                       239 216 9 1 0   3     0   10   112 127                 239
1122247 1122247 MA Bristol   school 2502190 16   Attleboro 250219000945 160320 Wamsutta Middle School   Regular School No Middle 05 08 2017   grade_7 90 9 22 0   10     1   4   74 62                       136 90 9 22 0   10     1   4   74 62                 136
1122539 1122539 MA Middlesex   school 2502670 31   Billerica 250267000183 310305 Marshall Middle School   Regular School No Middle 06 08 2017   grade_7 186 9 7 1   10     0   2   106 109                       215 186 9 7 1   10     0   2   106 109                 215
1123180 1123180 MA Suffolk   school 2502790 35   Boston 250279002689 350375 Edison K-8   Regular School No Elementary PK 08 2017   grade_7 17 9 41 0   5     0   1   41 32                       73 17 9 41 0   5     0   1   41 32                 73
1124111 1124111 MA Suffolk   school 2503540 57   Chelsea 250354001776 570055 Joseph A. Browne School   Regular School No Middle 05 08 2017   grade_7 5 9 115 0   4     0   0   67 66                       133 5 9 115 0   4     0   0   67 66                 133
1124194 1124194 MA Hampden   school 2503660 61   Chicopee 250366000722 610310 Dupont Middle   Regular School No Middle 06 08 2017   grade_7 127 9 93 0   0     0   7   138 98                       236 127 9 93 0   0     0   7   138 98                 236
1125025 1125025 MA Middlesex   school 2504980 100   Framingham 250498000464 1000305 Fuller Middle   Regular School No Middle 06 08 2017   grade_7 78 9 55 0   3     1   0   79 67                       146 78 9 55 0   3     1   0   79 67                 146
1126568 1126568 MA Middlesex   school 2507170 165   Malden 250717001351 1650027 Forestdale   Regular School No Elementary KG 08 2017   grade_7 23 9 11 0   3     0   5   21 30                       51 23 9 11 0   3     0   5   21 30                 51
1126609 1126609 MA Bristol   school 2507230 167   Mansfield 250723001112 1670035 Harold L Qualters Middle   Regular School No Middle 06 08 2017   grade_7 267 9 10 0   18     0   14   162 156                       318 267 9 10 0   18     0   14   162 156                 318
1126677 1126677 MA Middlesex   school 2507320 170   Marlborough 250732002639 1700045 1 LT Charles W. Whitcomb School   Regular School No Middle 05 08 2017   grade_7 132 9 137 0   3     0   13   163 131                       294 132 9 137 0   3     0   13   163 131                 294
1127012 1127012 MA Worcester   school 2507860 185   Milford 250786001240 1850305 Stacy Middle   Regular School No Middle 06 08 2017   grade_7 204 9 70 1   5     0   10   161 138                       299 204 9 70 1   5     0   10   161 138                 299
1127174 1127174 MA Middlesex   school 2508340 198   Natick 250834001305 1980310 Wilson Middle   Regular School No Middle 05 08 2017   grade_7 180 9 12 1   9     0   14   112 113                       225 180 9 12 1   9     0   14   112 113                 225
1128496 1128496 MA Suffolk   school 2510050 248   Revere 251005001963 2480014 Rumney Marsh Academy   Regular School No Middle 06 08 2017   grade_7 82 9 74 2   11     0   10   104 84                       188 82 9 74 2   11     0   10   104 84                 188
1128788 1128788 MA Plymouth   school 2510560 264   Scituate 251056001690 2640305 Gates Intermediate School   Regular School No Middle 07 08 2017   grade_7 243 9 0 0   6     0   3   126 135                       261 243 9 0 0   6     0   3   126 135                 261
1128994 1128994 MA Middlesex   school 2510890 274   Somerville 251089000891 2740115 West Somerville Neighborhood   Regular School No Elementary PK 08 2017   grade_7 26 9 10 0   3     0   3   27 24                       51 26 9 10 0   3     0   3   27 24                 51
1129216 1129216 MA Hampden   school 2511130 281   Springfield 251113001809 2810095 Alfred G. Zanetti Montessori Magnet School   Regular School No Elementary PK 08 2017   grade_7 6 9 14 0   0     0   2   15 16                       31 6 9 14 0   0     0   2   15 16                 31
1129834 1129834 MA Middlesex   school 2511910 305   Wakefield 251191000776 3050310 Galvin Middle School   Regular School No Middle 05 08 2017   grade_7 252 9 12 0   11     0   6   140 150                       290 252 9 12 0   11     0   6   140 150                 290
1130048 1130048 MA Middlesex   school 2512210 315   Wayland 251221002502 3150305 Wayland Middle School   Regular School No Middle 06 08 2017   grade_7 131 9 6 0   41     1   9   102 95                       197 131 9 6 0   41     1   9   102 95                 197
1131563 1131563 MA Essex   school 2500084 485   Salem Academy Charter (District) 250008401847 4850485 Salem Academy Charter School   Regular School Yes Other 06 12 2017   grade_7 33 9 23 0   5     0   2   28 44                       72 33 9 23 0   5     0   2   28 44                 72
1365221 1365221 MA Essex   school 2502640 30   Beverly 250264000165 300305 Beverly Middle School   Regular School No Middle 05 08 2020   grade_7 280 9 55 0   12     0   7   189 174 *                     363.0 280 9 55 0   12     0   7   189 174                 363
1365740 1365740 MA Suffolk   school 2502790 35   Boston 250279000323 350308 Sarah Greenwood   Regular School No Elementary PK 08 2020   grade_7 2 9 17 0   0     0   0   17 11 *                     28.0 2 9 17 0   0     0   0   17 11                 28
1366120 1366120 MA Norfolk   school 2502940 40   Braintree 250294000372 400310 South Middle School   Regular School No Middle 06 08 2020   grade_7 181 9 8 0   53     0   1   122 130 *                     252.0 181 9 8 0   53     0   1   122 130                 252
1366320 1366320 MA Norfolk   school 2503150 46   Brookline 250315000423 460035 William H Lincoln   Regular School No Elementary KG 08 2020   grade_7 48 9 8 0   8     0   5   29 49 *                     78.0 48 9 8 0   8     0   5   29 49                 78
1366931 1366931 MA Plymouth   school 2504440 83   East Bridgewater 250444000597 830505 East Bridgewater JR./SR. High School   Regular School No High 07 12 2020   grade_7 151 9 1 1   0     1   6   100 69 *                     169.0 151 9 1 1   0     1   6   100 69                 169
1367268 1367268 MA Worcester   school 2504890 97   Fitchburg 250489002672 970315 Arthur M Longsjo Middle School   Regular School No Middle 05 08 2020   grade_7 31 9 92 0   4     1   12   77 72 *                     149.0 31 9 92 0   4     1   12   77 72                 149
1368140 1368140 MA Worcester   school 2506780 153   Leominster 250678000742 1530045 Samoset School   Regular School No Middle 06 08 2020   grade_7 90 9 59 1   4     1   5   78 90 *                     169.0 90 9 59 1   4     1   5   78 90                 169
1368870 1368870 MA Middlesex   school 2507560 176   Medford 250756001638 1760315 Madeleine Dugger Andrews   Regular School No Middle 06 08 2020   grade_7 98 9 11 1   11     0   12   82 60 *                     142.0 98 9 11 1   11     0   12   82 60                 142
1369160 1369160 MA Middlesex   school 2508340 198   Natick 250834001305 1980310 Wilson Middle   Regular School No Middle 05 08 2020   grade_7 185 9 13 0   15     0   17   126 113 *                     239.0 185 9 13 0   15     0   17   126 113                 239
1369465 1369465 MA Middlesex   school 2508610 207   Newton 250861000310 2070310 Charles E Brown Middle   Regular School No Middle 06 08 2020   grade_7 180 9 18 1   51     0   18   141 136 *                     277.0 180 9 18 1   51     0   18   141 136                 277
1369468 1369468 MA Middlesex   school 2508610 207   Newton 250861000314 2070315 F A Day Middle   Regular School No Middle 06 08 2020   grade_7 215 9 31 1   52     0   20   163 165 *                     328.0 215 9 31 1   52     0   20   163 165                 328
1371566 1371566 MA Middlesex   school 2512180 314   Watertown 251218002501 3140305 Watertown Middle   Regular School No Middle 06 08 2020   grade_7 148 9 19 2   19     0   8   114 91 *                     205.0 148 9 19 2   19     0   8   114 91                 205
1372950 1372950 MA Bristol   school 2500519 496   Global Learning Charter Public (District) 250051902629 4960305 Global Learning Charter Public School   Regular School Yes High 05 12 2020   grade_7 35 9 40 1   1     0   3   42 47 *                     89.0 35 9 40 1   1     0   3   42 47                 89
1372963 1372963 MA Hampshire   school 2500517 497   Pioneer Valley Chinese Immersion Charter (District) 250051702619 4970205 Pioneer Valley Chinese Immersion Charter School   Regular School Yes Other KG 12 2020   grade_7 30 9 3 0   9     0   8   35 24 *                     59.0 30 9 3 0   9     0   8   35 24                 59
1373318 1373318 MA Barnstable   school 2504560 660   Nauset 250456000609 6600305 Nauset Regional Middle   Regular School No Middle 06 08 2020   grade_7 175 9 13 1   3     0   2   98 105 *                     203.0 175 9 13 1   3     0   2   98 105                 203
1374268 1374268 MA Hampden   school 2500588 3516   Hampden Charter School of Science West (District) 250058802888 35160305 Hampden Charter School of Science West   Regular School Yes Middle 06 10 2020   grade_7 36 9 21 0   0     0   1   33 34 *                     67.0 36 9 21 0   0     0   1   33 34                 67
1672273 1672273 MA Worcester   school 2502220 17   Auburn 250222002567 170305 Auburn - Auburn Middle   Regular School No Middle 06 08 2021   grade_7 175 9 20 0   6     0   8   94 124 *                     218.0 175 9 20 0   6     0   8   94 124                 218
1673018 1673018 MA Suffolk   school 2502790 35   Boston 250279000342 350363 Boston - William McKinley   Regular School No Other KG 12 2021   grade_7 5 9 8 0   0     0   0   16 6 *                     22.0 5 9 8 0   0     0   0   16 6                 22
1673103 1673103 MA Suffolk   school 2502790 35   Boston 250279000946 350382 Boston - Mission Hill School   Regular School No Elementary PK 08 2021   grade_7 3 9 6 0   0     0   0   16 2 *                     18.0 3 9 6 0   0     0   0   16 2                 18
1674161 1674161 MA Plymouth   school 2504440 83   East Bridgewater 250444000597 830505 East Bridgewater - East Bridgewater JR./SR. High School   Regular School No High 07 12 2021   grade_7 154 9 6 1   1     0   7   103 75 *                     178.0 154 9 6 1   1     0   7   103 75                 178
1674471 1674471 MA Barnstable   school 2504860 96   Falmouth 250486000687 960405 Falmouth - Lawrence   Regular School No Middle 07 08 2021   grade_7 197 9 15 9   3     0   20   131 122 *                     253.0 197 9 15 9   3     0   20   131 122                 253
1674620 1674620 MA Middlesex   school 2504980 100   Framingham 250498000733 1000310 Framingham - Walsh Middle   Regular School No Middle 06 08 2021   grade_7 148 9 86 0   16     0   7   127 139 *                     266.0 148 9 86 0   16     0   7   127 139                 266
1674913 1674913 MA Essex   school 2505970 128   Haverhill 250597002881 1280030 Haverhill - Caleb Dustin Hunking School   Regular School No Elementary KG 08 2021   grade_7 112 9 46 1   3     0   1   88 84 *                     172.0 112 9 46 1   3     0   1   88 84                 172
1675652 1675652 MA Middlesex   school 2507020 160   Lowell 250702001955 1600360 Lowell - Kathryn P. Stoklosa Middle School   Regular School No Middle 05 08 2021   grade_7 26 9 49 0   80     0   4   91 77 *                     168.0 26 9 49 0   80     0   4   91 77                 168
1676796 1676796 MA Hampshire   school 2508850 210   Northampton 250885001430 2100410 Northampton - John F Kennedy Middle School   Regular School No Middle 06 08 2021   grade_7 142 9 33 0   4     0   18   102 103 *                     206.0 142 9 33 0   4     0   18   102 103                 206
1676830 1676830 MA Essex   school 2508700 211   North Andover 250870001398 2110305 North Andover - North Andover Middle   Regular School No Middle 06 08 2021   grade_7 255 9 56 1   33     0   18   166 206 *                     372.0 255 9 56 1   33     0   18   166 206                 372
1677430 1677430 MA Norfolk   school 2509870 243   Quincy 250987001381 2430325 Quincy - Point Webster Middle   Regular School No Middle 05 08 2021   grade_7 26 9 7 1   39     1   6   50 39 *                     89.0 26 9 7 1   39     1   6   50 39                 89
1679004 1679004 MA Hampden   school 2512630 325   Westfield 251263001570 3250310 Westfield - Westfield Middle School   Regular School No Middle 07 08 2021   grade_7 279 9 71 1   14     0   10   205 179 *                     384.0 279 9 71 1   14     0   10   205 179                 384
1679641 1679641 MA Worcester   school 2513230 348   Worcester 251323002121 3480350 Worcester - Claremont Academy   Regular School No High 07 12 2021   grade_7 11 9 70 0   8     0   0   47 51 *                     98.0 11 9 70 0   8     0   0   47 51                 98
1680214 1680214 MA Bristol   school 2500519 496   Global Learning Charter Public (District) 250051902629 4960305 Global Learning Charter Public (District) - Global Learning Charter Public School   Regular School Yes High 05 12 2021   grade_7 36 9 40 0   2     0   4   48 43 *                     91.0 36 9 40 0   2     0   4   48 43                 91
1680828 1680828 MA Barnstable   school 2500544 712   Monomoy Regional School District 250054402832 7120315 Monomoy Regional School District - Monomoy Regional Middle School   Regular School No Middle 05 07 2021   grade_7 100 9 13 2   3     0   13   64 76 *                     140.0 100 9 13 2   3     0   13   64 76                 140
1681496 1681496 MA Hampden   school 2500586 3514   Libertas Charter School (District) 250058602878 35140305 Libertas Academy Charter School (District) - Libertas Academy Charter School   Regular School Yes Middle 06 08 2021   grade_7 0 9 74 0   1     0   2   37 49 *                     86.0 0 9 74 0   1     0   2   37 49                 86
2040049 2040049 MA Bristol   school 2502190 16   Attleboro 250219000096 160305 Robert J. Coelho Middle School   Regular School No Middle 05 08 2019   grade_7 124 9 25 0   9     0   11   91 87                       178.0 124 9 25 0   9     0   11   91 87                 178
2040254 2040254 MA Essex   school 2502640 30   Beverly 250264000165 300305 Beverly Middle School   Regular School No Middle 05 08 2019   grade_7 243 9 50 0   9     0   9   172 148                       320.0 243 9 50 0   9     0   9   172 148                 320
2040654 2040654 MA Suffolk   school 2502790 35   Boston 250279000291 350229 Maurice J Tobin   Regular School No Elementary PK 08 2019   grade_7 1 9 23 0   3     0   0   18 18                       36.0 1 9 23 0   3     0   0   18 18                 36
2040783 2040783 MA Suffolk   school 2502790 35   Boston 250279000323 350308 Sarah Greenwood   Regular School No Elementary PK 08 2019   grade_7 0 9 14 0   0     0   0   16 7                       23.0 0 9 14 0   0     0   0   16 7                 23
2041183 2041183 MA Norfolk   school 2502940 40   Braintree 250294000364 400305 East Middle School   Regular School No Middle 06 08 2019   grade_7 155 9 16 0   39     0   1   113 107                       220.0 155 9 16 0   39     0   1   113 107                 220
2042051 2042051 MA Hampden   school 2504500 87   East Longmeadow 250450000602 870305 Birchland Park   Regular School No Middle 06 08 2019   grade_7 179 9 15 0   9     0   6   110 108                       218.0 179 9 15 0   9     0   6   110 108                 218

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