enrollments

Data source: Big Local News · About: Big Local

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

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

grade ✖

  • grade_7 · 3,371 ✖
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
1372117 1372117 MA Middlesex   school 2513200 347   Woburn 251320002182 3470410 Daniel L Joyce Middle School   Regular School No Middle 06 08 2020   grade_7 142 18 28 0   9     0   8   102 103 *                     205.0 142 18 28 0   9     0   8   102 103                 205
1672477 1672477 MA Middlesex   school 2502670 31   Billerica 250267000183 310305 Billerica - Marshall Middle School   Regular School No Middle 05 07 2021   grade_7 155 14 18 0   13     0   4   102 102 *                     204.0 155 14 18 0   13     0   4   102 102                 204
1675677 1675677 MA Hampden   school 2507050 161   Ludlow 250705001055 1610305 Ludlow - Paul R Baird Middle   Regular School No Middle 06 08 2021   grade_7 150 4 41 0   0     0   7   102 100 *                     202.0 150 4 41 0   0     0   7   102 100                 202
1676403 1676403 MA Middlesex   school 2508340 198   Natick 250834001297 1980305 Natick - J F Kennedy Middle School   Regular School No Middle 05 08 2021   grade_7 147 0 15 0   21     0   4   102 85 *                     187.0 147 0 15 0   21     0   4   102 85                 187
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
1677174 1677174 MA Plymouth   school 2509420 231   Pembroke 250942001823 2310305 Pembroke - Pembroke Community Middle School   Regular School No Middle 07 08 2021   grade_7 193 1 1 0   1     0   5   102 99 *                     201.0 193 1 1 0   1     0   5   102 99                 201
1678816 1678816 MA Middlesex   school 2512180 314   Watertown 251218002501 3140305 Watertown - Watertown Middle   Regular School No Middle 06 08 2021   grade_7 104 5 50 0   17     0   8   102 82 *                     184.0 104 5 50 0   17     0   8   102 82                 184
2045521 2045521 MA Barnstable   school 2510470 261   Sandwich 251047002824 2610305 Sandwich STEM Academy   Regular School No Middle 07 08 2019   grade_7 215 0 2 0   2     0   2   102 118                       221.0 215 0 2 0   2     0   2   102 118                 221
2229347 2229347 MA Middlesex   school 2502670 31   Billerica 250267000183 310305 Billerica: Marshall Middle School   Regular School No Middle 06 08 2018   grade_7 177 8 8 0   12     1   4   102 108                       210.0 177 8 8 0   12     1   4   102 108                 210
2235317 2235317 MA Suffolk   school 2510050 248   Revere 251005001963 2480014 Revere: Rumney Marsh Academy   Regular School No Middle 06 08 2018   grade_7 94 7 84 1   6     1   2   102 93                       195.0 94 7 84 1   6     1   2   102 93                 195
2239085 2239085 MA Hampden   school 2505730 680   Hampden-Wilbraham 250573002141 6800310 Hampden-Wilbraham: Wilbraham Middle   Regular School No Middle 06 08 2018   grade_7 170 3 11 2   7     0   2   102 93                       195.0 170 3 11 2   7     0   2   102 93                 195
736000 736000 MA Hampshire   school 2502430 24   Belchertown 250243001873 240025 Jabish Middle School   Regular School No 2 07 08 2015   grade_7 181 0 10 0   2     0   2   103 92                       195 181 0 10 0   2     0   2   103 92                 195
737660 737660 MA Middlesex   school 2503840 67   Concord 250384000522 670305 Concord Middle   Regular School No 2 06 08 2015   grade_7 174 7 8 0   13     0   8   103 107                       210 174 7 8 0   13     0   8   103 107                 210
740946 740946 MA Berkshire   school 2509630 236   Pittsfield 250963001532 2360310 Theodore Herberg Middle   Regular School No 2 06 08 2015   grade_7 160 30 16 0   6     0   5   103 114                       217 160 30 16 0   6     0   5   103 114                 217
933842 933842 MA Barnstable   school 2502820 36   Bourne 250282001517 360325 Bourne Middle School   Regular School No 2 05 08 2016   grade_7 155 3 5 1   6     0   12   103 79                       182 155 3 5 1   6     0   12   103 79                 182
934340 934340 MA Middlesex   school 2503510 56   Chelmsford 250351000476 560305 Col Moses Parker School   Regular School No 2 05 08 2016   grade_7 151 7 6 0   20     0   5   103 86                       189 151 7 6 0   20     0   5   103 86                 189
937478 937478 MA Middlesex   school 2508820 217   North Reading 250882002592 2170305 North Reading Middle   Regular School No 2 06 08 2016   grade_7 188 4 3 0   8     0   5   103 105                       208 188 4 3 0   8     0   5   103 105                 208
939523 939523 MA Hampden   school 2512630 325   Westfield 251263001570 3250310 South Middle School   Regular School No 2 06 08 2016   grade_7 166 4 19 0   7     0   3   103 96                       199 166 4 19 0   7     0   3   103 96                 199
941080 941080 MA Worcester   school 2504360 658   Dudley-Charlton Reg 250436001597 6580310 Charlton Middle School   Regular School No 2 05 08 2016   grade_7 180 0 19 0   1     0   6   103 103                       206 180 0 19 0   1     0   6   103 103                 206
1122237 1122237 MA Bristol   school 2502190 16   Attleboro 250219000096 160305 Robert J. Coelho Middle School   Regular School No Middle 05 08 2017   grade_7 153 8 21 0   5     0   8   103 92                       195 153 8 21 0   5     0   8   103 92                 195
1122340 1122340 MA Middlesex   school 2502400 23   Bedford 250240000130 230305 John Glenn Middle   Regular School No Middle 06 08 2017   grade_7 140 13 8 0   40     0   6   103 104                       207 140 13 8 0   40     0   6   103 104                 207
1124276 1124276 MA Middlesex   school 2503840 67   Concord 250384000522 670305 Concord Middle   Regular School No Middle 06 08 2017   grade_7 198 11 11 1   14     0   14   103 146                       249 198 11 11 1   14     0   14   103 146                 249
1370001 1370001 MA Berkshire   school 2509630 236   Pittsfield 250963001532 2360310 Theodore Herberg Middle   Regular School No Middle 06 08 2020   grade_7 136 30 28 0   2     0   15   103 108 *                     211.0 136 30 28 0   2     0   15   103 108                 211
1370281 1370281 MA Suffolk   school 2510050 248   Revere 251005001963 2480014 Rumney Marsh Academy   Regular School No Middle 06 08 2020   grade_7 64 6 121 1   13     0   10   103 112 *                     215.0 64 6 121 1   13     0   10   103 112                 215
1370310 1370310 MA Suffolk   school 2510050 248   Revere 251005001976 2480057 Garfield Middle School   Regular School No Middle 06 08 2020   grade_7 68 8 119 0   7     0   3   103 102 *                     205.0 68 8 119 0   7     0   3   103 102                 205
1373465 1373465 MA Hampden   school 2505730 680   Hampden-Wilbraham 250573002141 6800310 Wilbraham Middle   Regular School No Middle 06 08 2020   grade_7 167 5 14 0   7     0   5   103 95 *                     198.0 167 5 14 0   7     0   5   103 95                 198
1672334 1672334 MA Middlesex   school 2502400 23   Bedford 250240000130 230305 Bedford - John Glenn Middle   Regular School No Middle 06 08 2021   grade_7 133 13 6 0   40     0   8   103 97 *                     200.0 133 13 6 0   40     0   8   103 97                 200
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
1674861 1674861 MA Plymouth   school 2505790 122   Hanover 250579002548 1220305 Hanover - Hanover Middle   Regular School No Middle 05 08 2021   grade_7 170 1 8 0   4     0   0   103 80 *                     183.0 170 1 8 0   4     0   0   103 80                 183
1676968 1676968 MA Bristol   school 2509000 218   Norton 250900001452 2180305 Norton - Norton Middle   Regular School No Middle 06 08 2021   grade_7 180 5 5 0   8     0   8   103 103 *                     206.0 180 5 5 0   8     0   8   103 103                 206
2040015 2040015 MA Middlesex   school 2502100 14   Ashland 250210000938 140405 Ashland Middle   Regular School No Middle 06 08 2019   grade_7 137 4 31 1   29     0   6   103 105                       208.0 137 4 31 1   29     0   6   103 105                 208
2043906 2043906 MA Norfolk   school 2507530 175   Medfield 250753001156 1750305 Thomas Blake Middle   Regular School No Middle 06 08 2019   grade_7 169 2 6 2   8     0   8   103 92                       195.0 169 2 6 2   8     0   8   103 92                 195
2045354 2045354 MA Suffolk   school 2510050 248   Revere 251005001963 2480014 Rumney Marsh Academy   Regular School No Middle 06 08 2019   grade_7 56 11 115 1   10     0   5   103 95                       198.0 56 11 115 1   10     0   5   103 95                 198
2233310 2233310 MA Essex   school 2507110 163   Lynn 250711001083 1630420 Lynn: Pickering Middle   Regular School No Middle 06 08 2018   grade_7 66 20 79 2   22     0   10   103 96                       199.0 66 20 79 2   22     0   10   103 96                 199
2233608 2233608 MA Norfolk   school 2507530 175   Medfield 250753001156 1750305 Medfield: Thomas Blake Middle   Regular School No Middle 06 08 2018   grade_7 192 2 6 1   10     0   7   103 115                       218.0 192 2 6 1   10     0   7   103 115                 218
2234589 2234589 MA Worcester   school 2508940 214   Northbridge 250894002591 2140305 Northbridge: Northbridge Middle   Regular School No Middle 05 08 2018   grade_7 164 1 10 0   0     0   10   103 82                       185.0 164 1 10 0   0     0   10   103 82                 185
2237113 2237113 MA Middlesex   school 2512660 326   Westford 251266000170 3260310 Westford: Blanchard Middle   Regular School No Middle 06 08 2018   grade_7 133 2 1 0   56     0   1   103 90                       193.0 133 2 1 0   56     0   1   103 90                 193
738533 738533 MA Plymouth   school 2505790 122   Hanover 250579002548 1220305 Hanover Middle   Regular School No 2 05 08 2015   grade_7 192 1 2 0   3     0   0   104 94                       198 192 1 2 0   3     0   0   104 94                 198
739515 739515 MA Essex   school 2507110 163   Lynn 250711001083 1630420 Pickering Middle   Regular School No 2 06 08 2015   grade_7 93 16 71 1   28     0   6   104 111                       215 93 16 71 1   28     0   6   104 111                 215
742717 742717 MA Hampden   school 2512630 325   Westfield 251263001570 3250310 South Middle School   Regular School No 2 06 08 2015   grade_7 164 4 29 0   8     0   2   104 103                       207 164 4 29 0   8     0   2   104 103                 207
935148 935148 MA Middlesex   school 2504980 100   Framingham 250498000733 1000310 Walsh Middle   Regular School No 2 06 08 2016   grade_7 136 7 58 0   20     0   6   104 123                       227 136 7 58 0   20     0   6   104 123                 227
938774 938774 MA Hampden   school 2511130 281   Springfield 251113002602 2810330 M Marcus Kiley Middle   Regular School No 2 06 08 2016   grade_7 26 54 119 0   9     0   3   104 107                       211 26 54 119 0   9     0   3   104 107                 211
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
1129339 1129339 MA Hampden   school 2511130 281   Springfield 251113002599 2810320 John J Duggan Middle   Regular School No Other 06 11 2017   grade_7 29 43 101 0   4     0   2   104 75                       179 29 43 101 0   4     0   2   104 75                 179
1132337 1132337 MA Worcester   school 2507680 710   Mendon-Upton 250768001279 7100015 Miscoe Hill School   Regular School No Middle 05 08 2017   grade_7 183 2 11 0   5     0   0   104 97                       201 183 2 11 0   5     0   0   104 97                 201
1365050 1365050 MA Worcester   school 2502220 17   Auburn 250222002567 170305 Auburn Middle   Regular School No Middle 06 08 2020   grade_7 154 4 26 0   9     0   9   104 98 *                     202.0 154 4 26 0   9     0   9   104 98                 202
1365255 1365255 MA Middlesex   school 2502670 31   Billerica 250267000183 310305 Marshall Middle School   Regular School No Middle 05 07 2020   grade_7 155 16 17 1   12     0   5   104 102 *                     206.0 155 16 17 1   12     0   5   104 102                 206
1367451 1367451 MA Worcester   school 2505130 103   Gardner 250513002431 1030405 Gardner Middle School   Regular School No Middle 05 07 2020   grade_7 126 3 47 0   5     0   19   104 96 *                     200.0 126 3 47 0   5     0   19   104 96                 200
1672480 1672480 MA Middlesex   school 2502670 31   Billerica 250267000182 310310 Billerica - Locke Middle   Regular School No Middle 05 07 2021   grade_7 146 4 10 0   12     0   9   104 77 *                     181.0 146 4 10 0   12     0   9   104 77                 181
1674742 1674742 MA Essex   school 2505280 107   Gloucester 250528000779 1070305 Gloucester - Ralph B O'Maley Middle   Regular School No Middle 06 08 2021   grade_7 166 2 23 1   3     0   6   104 97 *                     201.0 166 2 23 1   3     0   6   104 97                 201
2039818 2039818 MA Plymouth   school 2501650 1   Abington 250165000002 10405 Abington Middle School   Regular School No Middle 05 08 2019   grade_7 170 2 12 0   3     0   0   104 83                       187.0 170 2 12 0   3     0   0   104 83                 187
2041186 2041186 MA Norfolk   school 2502940 40   Braintree 250294000372 400310 South Middle School   Regular School No Middle 06 08 2019   grade_7 165 11 11 0   36     0   0   104 119                       223.0 165 11 11 0   36     0   0   104 119                 223
2041309 2041309 MA Plymouth   school 2503090 44   Brockton 250309002691 440422 Joseph F. Plouffe Academy   Regular School No Middle 06 08 2019   grade_7 60 84 69 0   9     0   10   104 128                       232.0 60 84 69 0   9     0   10   104 128                 232
2046577 2046577 MA Middlesex   school 2512000 308   Waltham 251200001977 3080415 John W. McDevitt Middle School   Regular School No Middle 06 08 2019   grade_7 89 21 102 0   10     0   4   104 122                       226.0 89 21 102 0   10     0   4   104 122                 226
2048456 2048456 MA Middlesex   school 2505500 673   Groton-Dunstable 250550000805 6730305 Groton Dunstable Regional Middle   Regular School No Middle 05 08 2019   grade_7 182 2 2 1   8     1   4   104 96                       200.0 182 2 2 1   8     1   4   104 96                 200
2048599 2048599 MA Worcester   school 2507680 710   Mendon-Upton 250768001279 7100015 Miscoe Hill School   Regular School No Middle 05 08 2019   grade_7 171 1 11 0   4     0   11   104 94                       198.0 171 1 11 0   4     0   11   104 94                 198
2238997 2238997 MA Middlesex   school 2505500 673   Groton-Dunstable 250550000805 6730305 Groton-Dunstable: Groton Dunstable Regional Middle   Regular School No Middle 05 08 2018   grade_7 161 1 4 1   10     1   2   104 76                       180.0 161 1 4 1   10     1   2   104 76                 180
933026 933026 MA Middlesex   school 2502670 31   Billerica 250267000183 310305 Marshall Middle School   Regular School No 2 06 08 2016   grade_7 172 5 7 0   8     0   2   105 89                       194 172 5 7 0   8     0   2   105 89                 194
936609 936609 MA Norfolk   school 2507530 175   Medfield 250753001156 1750305 Thomas Blake Middle   Regular School No 2 06 08 2016   grade_7 178 1 4 0   10     0   7   105 95                       200 178 1 4 0   10     0   7   105 95                 200
938033 938033 MA Middlesex   school 2509990 246   Reading 250999001612 2460310 Walter S Parker Middle   Regular School No 2 06 08 2016   grade_7 174 6 4 1   7     0   1   105 88                       193 174 6 4 1   7     0   1   105 88                 193
939323 939323 MA Middlesex   school 2512180 314   Watertown 251218002501 3140305 Watertown Middle   Regular School No 2 06 08 2016   grade_7 137 8 38 2   20     0   6   105 106                       211 137 8 38 2   20     0   6   105 106                 211
1122272 1122272 MA Worcester   school 2502220 17   Auburn 250222002567 170305 Auburn Middle   Regular School No Middle 06 08 2017   grade_7 179 3 14 0   5     0   9   105 105                       210 179 3 14 0   5     0   9   105 105                 210
1123550 1123550 MA Norfolk   school 2502940 40   Braintree 250294000372 400310 South Middle School   Regular School No Middle 06 08 2017   grade_7 170 4 10 0   37     0   1   105 117                       222 170 4 10 0   37     0   1   105 117                 222
1132078 1132078 MA Barnstable   school 2504560 660   Nauset 250456000609 6600305 Nauset Regional Middle   Regular School No Middle 06 08 2017   grade_7 166 4 5 0   2     1   5   105 78                       183 166 4 5 0   2     1   5   105 78                 183
1367913 1367913 MA Middlesex   school 2506390 141   Hudson 250639000927 1410410 David J. Quinn Middle School   Regular School No Middle 05 07 2020   grade_7 159 6 25 0   2     0   11   105 98 *                     203.0 159 6 25 0   2     0   11   105 98                 203
1370167 1370167 MA Norfolk   school 2509870 243   Quincy 250987001561 2430305 Atlantic Middle   Regular School No Middle 06 08 2020   grade_7 68 4 8 0   111     0   3   105 89 *                     194.0 68 4 8 0   111     0   3   105 89                 194
1674419 1674419 MA Bristol   school 2504830 95   Fall River 250483000655 950305 Fall River - Talbot Innovation School   Regular School No Middle 06 08 2021   grade_7 84 15 70 1   5     0   23   105 93 *                     198.0 84 15 70 1   5     0   23   105 93                 198
1676909 1676909 MA Worcester   school 2508940 214   Northbridge 250894002591 2140305 Northbridge - Northbridge Middle   Regular School No Middle 05 08 2021   grade_7 164 1 19 0   2     0   5   105 86 *                     191.0 164 1 19 0   2     0   5   105 86                 191
2046321 2046321 MA Bristol   school 2511460 292   Swansea 251146001894 2920305 Joseph Case Jr High   Regular School No Middle 06 08 2019   grade_7 186 3 5 0   1     0   1   105 91                       196.0 186 3 5 0   1     0   1   105 91                 196
2235561 2235561 MA Essex   school 2510500 262   Saugus 251050001685 2620305 Saugus: Belmonte Saugus Middle   Regular School No Middle 06 08 2018   grade_7 144 11 36 1   6     1   6   105 100                       205.0 144 11 36 1   6     1   6   105 100                 205
2236760 2236760 MA Middlesex   school 2512000 308   Waltham 251200001977 3080415 Waltham: John W. McDevitt Middle School   Regular School No Middle 06 08 2018   grade_7 84 17 92 0   6     1   6   105 101                       206.0 84 17 92 0   6     1   6   105 101                 206
2237073 2237073 MA Hampden   school 2512630 325   Westfield 251263001570 3250310 Westfield: South Middle School   Regular School No Middle 06 08 2018   grade_7 141 7 40 0   9     0   1   105 93                       198.0 141 7 40 0   9     0   1   105 93                 198
2238596 2238596 MA Hampshire   school 2501920 605   Amherst-Pelham 250192000043 6050405 Amherst-Pelham: Amherst Regional Middle School   Regular School No Middle 07 08 2018   grade_7 105 16 33 0   22     0   18   105 89                       194.0 105 16 33 0   22     0   18   105 89                 194
735928 735928 MA Worcester   school 2502220 17   Auburn 250222002567 170305 Auburn Middle   Regular School No 2 06 08 2015   grade_7 164 4 10 1   6     0   11   106 90                       196 164 4 10 1   6     0   11   106 90                 196
737150 737150 MA Plymouth   school 2503090 44   Brockton 250309000404 440410 North Middle School   Regular School No 2 06 08 2015   grade_7 18 133 19 1   2     1   9   106 77                       183 18 133 19 1   2     1   9   106 77                 183
742053 742053 MA Middlesex   school 2511220 284   Stoneham 251122001857 2840405 Stoneham Central Middle School   Regular School No 2 05 08 2015   grade_7 181 4 9 0   7     0   5   106 100                       206 181 4 9 0   7     0   5   106 100                 206
744335 744335 MA Middlesex   school 2505500 673   Groton-Dunstable 250550000805 6730305 Groton Dunstable Regional Middle   Regular School No 2 05 08 2015   grade_7 194 2 1 0   9     1   0   106 101                       207 194 2 1 0   9     1   0   106 101                 207
933903 933903 MA Norfolk   school 2502940 40   Braintree 250294000372 400310 South Middle School   Regular School No 2 06 08 2016   grade_7 173 4 4 0   33     0   3   106 111                       217 173 4 4 0   33     0   3   106 111                 217
935475 935475 MA Essex   school 2505970 128   Haverhill 250597000850 1280100 Consentino Middle School   Regular School No 1 01 08 2016   grade_7 136 7 66 0   2     0   2   106 107                       213 136 7 66 0   2     0   2   106 107                 213
941710 941710 MA Essex   school 2511740 773   Triton 251174001470 7730405 Triton Regional Middle School   Regular School No 2 07 08 2016   grade_7 185 0 7 2   3     0   3   106 94                       200 185 0 7 2   3     0   3   106 94                 200
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
1126787 1126787 MA Norfolk   school 2507530 175   Medfield 250753001156 1750305 Thomas Blake Middle   Regular School No Middle 06 08 2017   grade_7 189 1 3 0   7     0   7   106 101                       207 189 1 3 0   7     0   7   106 101                 207
1131765 1131765 MA Hampshire   school 2501920 605   Amherst-Pelham 250192000043 6050405 Amherst Regional Middle School   Regular School No Middle 07 08 2017   grade_7 137 14 31 0   18     1   13   106 108                       214 137 14 31 0   18     1   13   106 108                 214
1132655 1132655 MA Worcester   school 2500001 753   Quabbin 250000102003 7530405 Quabbin Regional Middle School   Regular School No Middle 07 08 2017   grade_7 190 0 12 0   1     0   5   106 102                       208 190 0 12 0   1     0   5   106 102                 208
1371225 1371225 MA Essex   school 2511430 291   Swampscott 251143002562 2910305 Swampscott Middle   Regular School No Middle 05 08 2020   grade_7 157 3 16 2   2     0   8   106 82 *                     188.0 157 3 16 2   2     0   8   106 82                 188
1677558 1677558 MA Suffolk   school 2510050 248   Revere 251005001976 2480057 Revere - Garfield Middle School   Regular School No Middle 06 08 2021   grade_7 65 7 112 0   8     0   1   106 87 *                     193.0 65 7 112 0   8     0   1   106 87                 193
1679378 1679378 MA Middlesex   school 2513200 347   Woburn 251320002182 3470410 Woburn - Daniel L Joyce Middle School   Regular School No Middle 06 08 2021   grade_7 134 8 26 1   6     0   8   106 77 *                     183.0 134 8 26 1   6     0   8   106 77                 183
2042260 2042260 MA Bristol   school 2504830 95   Fall River 250483000655 950305 Talbot Innovation School   Regular School No Middle 06 08 2019   grade_7 69 15 71 0   8     0   18   106 75                       181.0 69 15 71 0   8     0   18   106 75                 181
2042744 2042744 MA Essex   school 2505970 128   Haverhill 250597002881 1280030 Caleb Dustin Hunking School   Regular School No Elementary KG 08 2019   grade_7 147 12 35 0   3     1   3   106 95                       201.0 147 12 35 0   3     1   3   106 95                 201
2044621 2044621 MA Hampshire   school 2508850 210   Northampton 250885001430 2100410 John F Kennedy Middle School   Regular School No Middle 06 08 2019   grade_7 134 4 35 1   6     0   11   106 85                       191.0 134 4 35 1   6     0   11   106 85                 191
2045554 2045554 MA Essex   school 2510500 262   Saugus 251050001685 2620305 Belmonte Saugus Middle   Regular School No Middle 06 08 2019   grade_7 130 10 54 1   12     0   1   106 102                       208.0 130 10 54 1   12     0   1   106 102                 208
2045713 2045713 MA Bristol   school 2510860 273   Somerset 251086002537 2730305 Somerset Middle School   Regular School No Middle 06 08 2019   grade_7 197 0 9 0   0     0   1   106 101                       207.0 197 0 9 0   0     0   1   106 101                 207
2230502 2230502 MA Plymouth   school 2503090 44   Brockton 250309000410 440420 Brockton: West Middle School   Regular School No Middle 06 08 2018   grade_7 48 123 36 0   8     0   11   106 120                       226.0 48 123 36 0   8     0   11   106 120                 226
2235751 2235751 MA Bristol   school 2510860 273   Somerset 251086002537 2730305 Somerset: Somerset Middle School   Regular School No Middle 06 08 2018   grade_7 180 4 7 0   1     0   6   106 92                       198.0 180 4 7 0   1     0   6   106 92                 198
735793 735793 MA Essex   school 2501950 9   Andover 250195002510 90305 Doherty Middle   Regular School No 2 06 08 2015   grade_7 159 3 11 0   13     0   6   107 85                       192 159 3 11 0   13     0   6   107 85                 192
932874 932874 MA Hampshire   school 2502430 24   Belchertown 250243001873 240025 Jabish Middle School   Regular School No 2 07 08 2016   grade_7 185 4 3 0   5     0   4   107 94                       201 185 4 3 0   5     0   4   107 94                 201
935295 935295 MA Worcester   school 2505370 110   Grafton 250537002520 1100305 Grafton Middle   Regular School No 2 07 08 2016   grade_7 176 4 9 0   23     0   8   107 113                       220 176 4 9 0   23     0   8   107 113                 220
936938 936938 MA Middlesex   school 2508340 198   Natick 250834001305 1980310 Wilson Middle   Regular School No 2 05 08 2016   grade_7 170 7 26 0   13     1   17   107 127                       234 170 7 26 0   13     1   17   107 127                 234
938053 938053 MA Suffolk   school 2510050 248   Revere 251005001963 2480014 Rumney Marsh Academy   Regular School No 2 06 08 2016   grade_7 88 6 79 4   12     0   3   107 85                       192 88 6 79 4   12     0   3   107 85                 192
1128422 1128422 MA Norfolk   school 2509930 244   Randolph 250993001392 2440410 Randolph Community Middle   Regular School No Middle 06 08 2017   grade_7 38 110 26 0   31     1   10   107 109                       216 38 110 26 0   31     1   10   107 109                 216

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