enrollments

Data source: Big Local News · About: Big Local

4,038 rows where grade = "grade_6" and state = "MA" sorted by female 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
738230 738230 MA Norfolk   school 2504950 99   Foxborough 250495000709 990405 John J Ahern   Regular School No 2 05 08 2015   grade_6 178 7 4 0   9     0   3   102 99                       201 178 7 4 0   9     0   3   102 99                 201
740945 740945 MA Berkshire   school 2509630 236   Pittsfield 250963001532 2360310 Theodore Herberg Middle   Regular School No 2 06 08 2015   grade_6 155 21 23 1   6     0   7   114 99                       213 155 21 23 1   6     0   7   114 99                 213
742716 742716 MA Hampden   school 2512630 325   Westfield 251263001570 3250310 South Middle School   Regular School No 2 06 08 2015   grade_6 167 4 20 0   6     0   2   100 99                       199 167 4 20 0   6     0   2   100 99                 199
935382 935382 MA Plymouth   school 2505790 122   Hanover 250579002548 1220305 Hanover Middle   Regular School No 2 05 08 2016   grade_6 206 1 3 0   4     0   0   115 99                       214 206 1 3 0   4     0   0   115 99                 214
939255 939255 MA Middlesex   school 2512000 308   Waltham 251200001977 3080415 John W. McDevitt Middle School   Regular School No 2 06 08 2016   grade_6 89 16 84 0   6     0   2   98 99                       197 89 16 84 0   6     0   2   98 99                 197
941160 941160 MA Middlesex   school 2505500 673   Groton-Dunstable 250550000805 6730305 Groton Dunstable Regional Middle   Regular School No 2 05 08 2016   grade_6 169 1 4 0   20     0   4   99 99                       198 169 1 4 0   20     0   4   99 99                 198
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
1371002 1371002 MA Hampden   school 2511130 281   Springfield 251113002600 2810325 Forest Park Middle   Regular School No Middle 06 08 2020   grade_6 11 59 142 0   13     0   6   132 99 *                     231.0 11 59 142 0   13     0   6   132 99                 231
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
1676967 1676967 MA Bristol   school 2509000 218   Norton 250900001452 2180305 Norton - Norton Middle   Regular School No Middle 06 08 2021   grade_6 160 6 9 2   3     0   9   90 99 *                     189.0 160 6 9 2   3     0   9   90 99                 189
1677317 1677317 MA Plymouth   school 2509720 239   Plymouth 250972001380 2390305 Plymouth - Plymouth South Middle   Regular School No Middle 06 08 2021   grade_6 196 6 4 0   0     0   5   112 99 *                     211.0 196 6 4 0   0     0   5   112 99                 211
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
1677730 1677730 MA Essex   school 2510500 262   Saugus 251050001685 2620305 Saugus - Saugus Middle School   Regular School No Middle 06 08 2021   grade_6 109 10 58 5   9     1   8   101 99 *                     200.0 109 10 58 5   9     1   8   101 99                 200
1678755 1678755 MA Middlesex   school 2512000 308   Waltham 251200001977 3080415 Waltham - John W. McDevitt Middle School   Regular School No Middle 06 08 2021   grade_6 57 17 126 0   7     0   0   108 99 *                     207.0 57 17 126 0   7     0   0   108 99                 207
1680656 1680656 MA Middlesex   school 2505500 673   Groton-Dunstable 250550000805 6730305 Groton-Dunstable - Groton Dunstable Regional Middle   Regular School No Middle 05 08 2021   grade_6 167 2 5 0   18     1   4   98 99 *                     197.0 167 2 5 0   18     1   4   98 99                 197
2042521 2042521 MA Worcester   school 2505130 103   Gardner 250513002431 1030405 Gardner Middle School   Regular School No Middle 05 07 2019   grade_6 131 3 48 0   5     0   19   107 99                       206.0 131 3 48 0   5     0   19   107 99                 206
2047189 2047189 MA Middlesex   school 2513200 347   Woburn 251320002182 3470410 Daniel L Joyce Middle School   Regular School No Middle 06 08 2019   grade_6 137 16 23 0   8     1   6   92 99                       191.0 137 16 23 0   8     1   6   92 99                 191
2232150 2232150 MA Plymouth   school 2505790 122   Hanover 250579002548 1220305 Hanover: Hanover Middle   Regular School No Middle 05 08 2018   grade_6 210 1 5 0   6     0   1   124 99                       223.0 210 1 5 0   6     0   1   124 99                 223
2238034 2238034 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_6 10 102 72 0   3     0   1   89 99                       188.0 10 102 72 0   3     0   1   89 99                 188
739764 739764 MA Norfolk   school 2507530 175   Medfield 250753001156 1750305 Thomas Blake Middle   Regular School No 2 06 08 2015   grade_6 184 0 3 0   8     0   7   104 98                       202 184 0 3 0   8     0   7   104 98                 202
742052 742052 MA Middlesex   school 2511220 284   Stoneham 251122001857 2840405 Stoneham Central Middle School   Regular School No 2 05 08 2015   grade_6 163 3 13 0   6     0   7   94 98                       192 163 3 13 0   6     0   7   94 98                 192
937427 937427 MA Worcester   school 2508880 213   Northborough 250888001440 2130305 Robert E. Melican Middle School   Regular School No 2 06 08 2016   grade_6 167 2 6 1   23     1   8   110 98                       208 167 2 6 1   23     1   8   110 98                 208
937437 937437 MA Worcester   school 2508940 214   Northbridge 250894002591 2140305 Northbridge Middle   Regular School No 2 05 08 2016   grade_6 192 2 11 0   4     0   4   115 98                       213 192 2 11 0   4     0   4   115 98                 213
941304 941304 MA Worcester   school 2507680 710   Mendon-Upton 250768001279 7100015 Miscoe Hill School   Regular School No 2 04 08 2016   grade_6 183 2 12 0   5     0   1   105 98                       203 183 2 12 0   5     0   1   105 98                 203
1123475 1123475 MA Barnstable   school 2502820 36   Bourne 250282001517 360325 Bourne Middle School   Regular School No Middle 05 08 2017   grade_6 157 1 2 2   5     0   7   76 98                       174 157 1 2 2   5     0   7   76 98                 174
1125020 1125020 MA Middlesex   school 2504980 100   Framingham 250498001530 1000302 Cameron Middle School   Regular School No Middle 06 08 2017   grade_6 141 10 24 0   3     0   4   84 98                       182 141 10 24 0   3     0   4   84 98                 182
1366562 1366562 MA Middlesex   school 2503510 56   Chelmsford 250351000478 560310 McCarthy Middle School   Regular School No Middle 05 08 2020   grade_6 140 5 9 0   34     0   7   97 98 *                     195.0 140 5 9 0   34     0   7   97 98                 195
1370517 1370517 MA Plymouth   school 2510560 264   Scituate 251056001690 2640305 Gates Middle School   Regular School No Middle 06 08 2020   grade_6 196 6 3 0   2     0   3   112 98 *                     210.0 196 6 3 0   2     0   3   112 98                 210
1677560 1677560 MA Suffolk   school 2510050 248   Revere 251005002113 2480305 Revere - Susan B. Anthony Middle School   Regular School No Middle 06 08 2021   grade_6 58 7 99 0   6     0   2   74 98 *                     172.0 58 7 99 0   6     0   2   74 98                 172
1678815 1678815 MA Middlesex   school 2512180 314   Watertown 251218002501 3140305 Watertown - Watertown Middle   Regular School No Middle 06 08 2021   grade_6 110 6 36 0   12     0   14   80 98 *                     178.0 110 6 36 0   12     0   14   80 98                 178
2040077 2040077 MA Worcester   school 2502220 17   Auburn 250222002567 170305 Auburn Middle   Regular School No Middle 06 08 2019   grade_6 154 3 23 0   7     0   9   98 98                       196.0 154 3 23 0   7     0   9   98 98                 196
2044724 2044724 MA Worcester   school 2508880 213   Northborough 250888001440 2130305 Robert E. Melican Middle School   Regular School No Middle 06 08 2019   grade_6 127 2 16 0   28     1   7   83 98                       181.0 127 2 16 0   28     1   7   83 98                 181
2048379 2048379 MA Barnstable   school 2504560 660   Nauset 250456000609 6600305 Nauset Regional Middle   Regular School No Middle 06 08 2019   grade_6 164 9 12 1   3     0   3   94 98                       192.0 164 9 12 1   3     0   3   94 98                 192
2230501 2230501 MA Plymouth   school 2503090 44   Brockton 250309000410 440420 Brockton: West Middle School   Regular School No Middle 06 08 2018   grade_6 46 122 31 0   6     1   7   115 98                       213.0 46 122 31 0   6     1   7   115 98                 213
739514 739514 MA Essex   school 2507110 163   Lynn 250711001083 1630420 Pickering Middle   Regular School No 2 06 08 2015   grade_6 97 13 69 1   21     0   9   113 97                       210 97 13 69 1   21     0   9   113 97                 210
744011 744011 MA Worcester   school 2502040 610   Ashburnham-Westminster 250204000831 6100305 Overlook Middle School   Regular School No 2 06 08 2015   grade_6 178 1 8 0   3     0   1   94 97                       191 178 1 8 0   3     0   1   94 97                 191
744252 744252 MA Worcester   school 2504360 658   Dudley-Charlton Reg 250436001597 6580310 Charlton Middle School   Regular School No 2 05 08 2015   grade_6 169 0 18 0   2     0   6   98 97                       195 169 0 18 0   2     0   6   98 97                 195
744259 744259 MA Barnstable   school 2504560 660   Nauset 250456000609 6600305 Nauset Regional Middle   Regular School No 2 06 08 2015   grade_6 152 3 8 0   3     0   3   72 97                       169 152 3 8 0   3     0   3   72 97                 169
933841 933841 MA Barnstable   school 2502820 36   Bourne 250282001517 360325 Bourne Middle School   Regular School No 2 05 08 2016   grade_6 172 4 1 2   6     0   2   90 97                       187 172 4 1 2   6     0   2   90 97                 187
939901 939901 MA Middlesex   school 2513200 347   Woburn 251320002182 3470410 Daniel L Joyce Middle School   Regular School No 2 06 08 2016   grade_6 150 11 11 2   9     1   6   93 97                       190 150 11 11 2   9     1   6   93 97                 190
1124881 1124881 MA Worcester   school 2504890 97   Fitchburg 250489001523 970048 Memorial Intermediate   Regular School No Middle 05 08 2017   grade_6 64 12 103 0   12     0   13   107 97                       204 64 12 103 0   12     0   13   107 97                 204
1127862 1127862 MA Plymouth   school 2509030 219   Norwell 250903001456 2190405 Norwell Middle School   Regular School No Middle 06 08 2017   grade_6 171 1 1 0   3     0   1   80 97                       177 171 1 1 0   3     0   1   80 97                 177
1128163 1128163 MA Berkshire   school 2509630 236   Pittsfield 250963001532 2360310 Theodore Herberg Middle   Regular School No Middle 06 08 2017   grade_6 129 23 29 0   3     0   21   108 97                       205 129 23 29 0   3     0   21   108 97                 205
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
1128670 1128670 MA Essex   school 2510380 258   Salem 251038002404 2580305 Collins Middle   Regular School No Middle 06 08 2017   grade_6 113 13 49 0   6     0   8   92 97                       189 113 13 49 0   6     0   8   92 97                 189
1366840 1366840 MA Norfolk   school 2504050 73   Dedham 250405000551 730305 Dedham Middle School   Regular School No Middle 06 08 2020   grade_6 166 11 32 0   3     0   9   124 97 *                     221.0 166 11 32 0   3     0   9   124 97                 221
1371244 1371244 MA Bristol   school 2511460 292   Swansea 251146001894 2920305 Joseph Case Jr High   Regular School No Middle 06 08 2020   grade_6 169 0 3 1   4     0   1   81 97 *                     178.0 169 0 3 1   4     0   1   81 97                 178
1673793 1673793 MA Middlesex   school 2503510 56   Chelmsford 250351000478 560310 Chelmsford - McCarthy Middle School   Regular School No Middle 05 08 2021   grade_6 129 5 17 0   28     1   16   99 97 *                     196.0 129 5 17 0   28     1   16   99 97                 196
1675676 1675676 MA Hampden   school 2507050 161   Ludlow 250705001055 1610305 Ludlow - Paul R Baird Middle   Regular School No Middle 06 08 2021   grade_6 136 4 20 1   0     0   9   73 97 *                     170.0 136 4 20 1   0     0   9   73 97                 170
1678841 1678841 MA Middlesex   school 2512210 315   Wayland 251221002502 3150305 Wayland - Wayland Middle School   Regular School No Middle 06 08 2021   grade_6 132 16 8 0   28     0   15   102 97 *                     199.0 132 16 8 0   28     0   15   102 97                 199
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
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
2040297 2040297 MA Middlesex   school 2502670 31   Billerica 250267000183 310305 Marshall Middle School   Regular School No Middle 06 08 2019   grade_6 156 14 11 1   12     0   4   101 97                       198.0 156 14 11 1   12     0   4   101 97                 198
2046860 2046860 MA Middlesex   school 2512660 326   Westford 251266002080 3260330 Stony Brook School   Regular School No Middle 06 08 2019   grade_6 144 1 6 0   45     0   8   107 97                       204.0 144 1 6 0   45     0   8   107 97                 204
2231709 2231709 MA Worcester   school 2504890 97   Fitchburg 250489001523 970048 Fitchburg: Memorial Intermediate   Regular School No Middle 05 08 2018   grade_6 58 8 97 0   14     0   10   90 97                       187.0 58 8 97 0   14     0   10   90 97                 187
2231777 2231777 MA Norfolk   school 2504950 99   Foxborough 250495000709 990405 Foxborough: John J Ahern   Regular School No Middle 05 08 2018   grade_6 175 15 12 0   3     0   3   111 97                       208.0 175 15 12 0   3     0   3   111 97                 208
2234231 2234231 MA Essex   school 2508580 204   Newburyport 250858001355 2040305 Newburyport: Rupert A Nock Middle   Regular School No Middle 06 08 2018   grade_6 178 3 7 0   7     0   3   101 97                       198.0 178 3 7 0   7     0   3   101 97                 198
2235750 2235750 MA Bristol   school 2510860 273   Somerset 251086002537 2730305 Somerset: Somerset Middle School   Regular School No Middle 06 08 2018   grade_6 199 1 8 0   0     0   2   113 97                       210.0 199 1 8 0   0     0   2   113 97                 210
2238620 2238620 MA Worcester   school 2502040 610   Ashburnham-Westminster 250204000831 6100305 Ashburnham-Westminster: Overlook Middle School   Regular School No Middle 06 08 2018   grade_6 172 2 12 1   1     0   2   93 97                       190.0 172 2 12 1   1     0   2   93 97                 190
2238908 2238908 MA Barnstable   school 2504560 660   Nauset 250456000609 6600305 Nauset: Nauset Regional Middle   Regular School No Middle 06 08 2018   grade_6 152 8 13 0   5     0   7   88 97                       185.0 152 8 13 0   5     0   7   88 97                 185
741224 741224 MA Suffolk   school 2510050 248   Revere 251005001963 2480014 Rumney Marsh Academy   Regular School No 2 06 08 2015   grade_6 93 10 87 4   13     0   3   114 96                       210 93 10 87 4   13     0   3   114 96                 210
937318 937318 MA Hampshire   school 2508850 210   Northampton 250885001430 2100410 John F Kennedy Middle School   Regular School No 2 06 08 2016   grade_6 154 3 24 1   5     0   11   102 96                       198 154 3 24 1   5     0   11   102 96                 198
939556 939556 MA Middlesex   school 2512660 326   Westford 251266002080 3260330 Stony Brook School   Regular School No 2 06 08 2016   grade_6 124 4 4 1   43     0   7   87 96                       183 124 4 4 1   43     0   7   87 96                 183
939584 939584 MA Middlesex   school 2512750 330   Weston 251275000793 3300305 Weston Middle   Regular School No 2 06 08 2016   grade_6 119 14 8 2   24     0   7   78 96                       174 119 14 8 2   24     0   7   78 96                 174
1122111 1122111 MA Essex   school 2501950 9   Andover 250195002511 90310 Andover West Middle   Regular School No Middle 06 08 2017   grade_6 145 1 4 0   26     0   6   86 96                       182 145 1 4 0   26     0   6   86 96                 182
1122339 1122339 MA Middlesex   school 2502400 23   Bedford 250240000130 230305 John Glenn Middle   Regular School No Middle 06 08 2017   grade_6 131 13 12 0   28     0   7   95 96                       191 131 13 12 0   28     0   7   95 96                 191
1122354 1122354 MA Hampshire   school 2502430 24   Belchertown 250243001871 240006 Chestnut Hill Community School   Regular School No Elementary 04 06 2017   grade_6 183 2 6 0   6     1   7   109 96                       205 183 2 6 0   6     1   7   109 96                 205
1124500 1124500 MA Plymouth   school 2504440 83   East Bridgewater 250444000976 830010 Gordon W Mitchell   Regular School No Elementary 03 06 2017   grade_6 170 6 3 1   3     0   4   90 96                       187 170 6 3 1   3     0   4   90 96                 187
1128421 1128421 MA Norfolk   school 2509930 244   Randolph 250993001392 2440410 Randolph Community Middle   Regular School No Middle 06 08 2017   grade_6 31 87 28 2   30     0   11   93 96                       189 31 87 28 2   30     0   11   93 96                 189
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
1677769 1677769 MA Plymouth   school 2510560 264   Scituate 251056001690 2640305 Scituate - Gates Middle School   Regular School No Middle 06 08 2021   grade_6 181 10 9 1   1     0   11   117 96 *                     213.0 181 10 9 1   1     0   11   117 96                 213
2043517 2043517 MA Hampden   school 2507050 161   Ludlow 250705001055 1610305 Paul R Baird Middle   Regular School No Middle 06 08 2019   grade_6 179 7 19 2   0     0   4   115 96                       211.0 179 7 19 2   0     0   4   115 96                 211
2045382 2045382 MA Suffolk   school 2510050 248   Revere 251005001976 2480057 Garfield Middle School   Regular School No Middle 06 08 2019   grade_6 70 7 114 0   7     0   3   105 96                       201.0 70 7 114 0   7     0   3   105 96                 201
2048455 2048455 MA Middlesex   school 2505500 673   Groton-Dunstable 250550000805 6730305 Groton Dunstable Regional Middle   Regular School No Middle 05 08 2019   grade_6 162 5 5 0   9     0   4   89 96                       185.0 162 5 5 0   9     0   4   89 96                 185
2048598 2048598 MA Worcester   school 2507680 710   Mendon-Upton 250768001279 7100015 Miscoe Hill School   Regular School No Middle 05 08 2019   grade_6 177 0 11 0   6     0   7   105 96                       201.0 177 0 11 0   6     0   7   105 96                 201
736159 736159 MA Middlesex   school 2502670 31   Billerica 250267000182 310310 Locke Middle   Regular School No 2 06 08 2015   grade_6 169 4 5 0   13     0   5   101 95                       196 169 4 5 0   13     0   5   101 95                 196
740666 740666 MA Bristol   school 2509000 218   Norton 250900001452 2180305 Norton Middle   Regular School No 2 06 08 2015   grade_6 196 1 3 0   4     1   3   113 95                       208 196 1 3 0   4     1   3   113 95                 208
741379 741379 MA Essex   school 2510380 258   Salem 251038002404 2580305 Collins Middle   Regular School No 2 06 08 2015   grade_6 102 13 64 0   8     0   7   99 95                       194 102 13 64 0   8     0   7   99 95                 194
936398 936398 MA Essex   school 2507140 164   Lynnfield 250714001091 1640405 Lynnfield Middle School   Regular School No 2 05 08 2016   grade_6 164 1 4 0   5     0   3   82 95                       177 164 1 4 0   5     0   3   82 95                 177
937233 937233 MA Middlesex   school 2508610 207   Newton 250861000307 2070305 Bigelow Middle   Regular School No 2 06 08 2016   grade_6 118 8 13 2   26     0   12   84 95                       179 118 8 13 2   26     0   12   84 95                 179
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
938407 938407 MA Bristol   school 2510860 273   Somerset 251086002537 2730305 Somerset Middle School   Regular School No 2 06 08 2016   grade_6 185 0 8 0   0     1   2   101 95                       196 185 0 8 0   0     1   2   101 95                 196
939898 939898 MA Middlesex   school 2513200 347   Woburn 251320002186 3470405 John F Kennedy Middle School   Regular School No 2 06 08 2016   grade_6 142 12 20 2   13     0   2   96 95                       191 142 12 20 2   13     0   2   96 95                 191
1129353 1129353 MA Hampden   school 2511130 281   Springfield 251113002602 2810330 M Marcus Kiley Middle   Regular School No Middle 06 08 2017   grade_6 25 34 141 0   5     0   2   112 95                       207 25 34 141 0   5     0   2   112 95                 207
1129979 1129979 MA Plymouth   school 2512060 310   Wareham 251206002603 3100305 Wareham Middle   Regular School No Middle 05 08 2017   grade_6 161 16 11 2   0     0   14   109 95                       204 161 16 11 2   0     0   14   109 95                 204
1130257 1130257 MA Hampden   school 2512630 325   Westfield 251263001570 3250310 South Middle School   Regular School No Middle 06 08 2017   grade_6 140 4 40 0   7     0   2   98 95                       193 140 4 40 0   7     0   2   98 95                 193
1370358 1370358 MA Plymouth   school 2510170 251   Rockland 251017001642 2510305 John W Rogers Middle   Regular School No Middle 05 08 2020   grade_6 145 11 32 0   3     0   3   99 95 *                     194.0 145 11 32 0   3     0   3   99 95                 194
2231936 2231936 MA Worcester   school 2505130 103   Gardner 250513002431 1030405 Gardner: Gardner Middle School   Regular School No Middle 05 07 2018   grade_6 136 7 30 0   2     0   14   94 95                       189.0 136 7 30 0   2     0   14   94 95                 189
2235354 2235354 MA Suffolk   school 2510050 248   Revere 251005002113 2480305 Revere: Susan B. Anthony Middle School   Regular School No Middle 06 08 2018   grade_6 68 2 114 0   4     0   1   94 95                       189.0 68 2 114 0   4     0   1   94 95                 189
740942 740942 MA Berkshire   school 2509630 236   Pittsfield 250963001525 2360305 John T Reid Middle   Regular School No 2 06 08 2015   grade_6 123 19 26 0   0     0   13   87 94                       181 123 19 26 0   0     0   13   87 94                 181
744407 744407 MA Hampden   school 2505730 680   Hampden-Wilbraham 250573002141 6800310 Wilbraham Middle   Regular School No 2 06 08 2015   grade_6 139 4 5 0   10     0   3   67 94                       161 139 4 5 0   10     0   3   67 94                 161
932773 932773 MA Bristol   school 2502190 16   Attleboro 250219000096 160305 Robert J. Coelho Middle School   Regular School No 2 05 08 2016   grade_6 157 7 20 0   5     0   7   102 94                       196 157 7 20 0   5     0   7   102 94                 196
932892 932892 MA Norfolk   school 2502460 25   Bellingham 250246001683 250315 Bellingham Memorial School   Regular School No 2 04 07 2016   grade_6 168 5 2 0   4     0   4   89 94                       183 168 5 2 0   4     0   4   89 94                 183
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
936670 936670 MA Norfolk   school 2507590 177   Medway 250759002483 1770305 Medway Middle   Regular School No 2 05 08 2016   grade_6 173 2 6 1   8     0   4   100 94                       194 173 2 6 1   8     0   4   100 94                 194
939553 939553 MA Middlesex   school 2512660 326   Westford 251266000170 3260310 Blanchard Middle   Regular School No 2 06 08 2016   grade_6 141 1 1 2   55     1   1   108 94                       202 141 1 1 2   55     1   1   108 94                 202
1124559 1124559 MA Hampden   school 2504500 87   East Longmeadow 250450000602 870305 Birchland Park   Regular School No Middle 06 08 2017   grade_6 182 8 11 0   10     0   3   120 94                       214 182 8 11 0   10     0   3   120 94                 214
1126859 1126859 MA Norfolk   school 2507590 177   Medway 250759002483 1770305 Medway Middle   Regular School No Middle 05 08 2017   grade_6 161 1 6 1   5     0   2   82 94                       176 161 1 6 1   5     0   2   82 94                 176
1128929 1128929 MA Bristol   school 2510860 273   Somerset 251086002537 2730305 Somerset Middle School   Regular School No Middle 06 08 2017   grade_6 186 4 7 0   1     0   5   109 94                       203 186 4 7 0   1     0   5   109 94                 203
1131206 1131206 MA Suffolk   school 2500071 428   Brooke Charter School Roslindale (District) 250007101747 4280305 Brooke Charter School   Regular School Yes Other KG 09 2017   grade_6 14 107 58 0   2     0   6   93 94                       187 14 107 58 0   2     0   6   93 94                 187

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