Data source: Big Local News · About: Big Local

3,459 rows where grade = "grade_8" and state = "MA" sorted by male descending

View and edit SQL

year

grade

  • grade_8 · 3,459
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
739098 MA Worcester   school 2506780 153   Leominster 250678000742 1530045 Samoset School   Regular School No 2 06 08 2015   grade_8 110 7 40 1   4     0   6   99 69                       168 110 7 40 1   4     0   6   99 69                 168
742715 MA Hampden   school 2512630 325   Westfield 251263001569 3250305 North Middle School   Regular School No 2 06 08 2015   grade_8 177 5 16 1   5     0   6   99 111                       210 177 5 16 1   5     0   6   99 111                 210
936364 MA Essex   school 2507110 163   Lynn 250711001083 1630420 Pickering Middle   Regular School No 2 06 08 2016   grade_8 88 15 73 1   25     0   5   99 108                       207 88 15 73 1   25     0   5   99 108                 207
937320 MA Hampshire   school 2508850 210   Northampton 250885001430 2100410 John F Kennedy Middle School   Regular School No 2 06 08 2016   grade_8 134 4 43 2   5     0   10   99 99                       198 134 4 43 2   5     0   10   99 99                 198
1130255 MA Hampden   school 2512630 325   Westfield 251263001569 3250305 North Middle School   Regular School No Middle 06 08 2017   grade_8 179 3 21 0   2     1   4   99 111                       210 179 3 21 0   2     1   4   99 111                 210
1366240 MA Plymouth   school 2503090 44   Brockton 250309002691 440422 Joseph F. Plouffe Academy   Regular School No Middle 06 08 2020   grade_8 52 82 70 0   9     0   10   99 124 *                     223.0 52 82 70 0   9     0   10   99 124                 223
1367914 MA Middlesex   school 2506390 141   Hudson 250639000926 1410505 Hudson High   Regular School No High 08 12 2020   grade_8 181 1 25 0   8     0   2   99 118 *                     217.0 181 1 25 0   8     0   2   99 118                 217
1373066 MA Worcester   school 2502040 610   Ashburnham-Westminster 250204000831 6100305 Overlook Middle School   Regular School No Middle 06 08 2020   grade_8 176 2 15 1   1     0   2   99 98 *                     197.0 176 2 15 1   1     0   2   99 98                 197
1373287 MA Norfolk   school 2504290 655   Dover-Sherborn 250429000575 6550405 Dover-Sherborn Regional Middle School   Regular School No Middle 06 08 2020   grade_8 138 3 10 1   17     0   8   99 78 *                     177.0 138 3 10 1   17     0   8   99 78                 177
1672246 MA Bristol   school 2502190 16   Attleboro 250219000096 160305 Attleboro - Robert J. Coelho Middle School   Regular School No Middle 05 08 2021   grade_8 128 12 23 0   6     0   11   99 81 *                     180.0 128 12 23 0   6     0   11   99 81                 180
1673470 MA Plymouth   school 2503090 44   Brockton 250309002688 440421 Brockton - Ashfield Middle School   Regular School No Middle 06 08 2021   grade_8 62 116 24 2   8     2   4   99 119 *                     218.0 62 116 24 2   8     2   4   99 119                 218
1674671 MA Norfolk   school 2505010 101   Franklin 250501000738 1010405 Franklin - Horace Mann   Regular School No Middle 06 08 2021   grade_8 138 2 10 0   14     0   2   99 67 *                     166.0 138 2 10 0   14     0   2   99 67                 166
1674862 MA Plymouth   school 2505790 122   Hanover 250579002548 1220305 Hanover - Hanover Middle   Regular School No Middle 05 08 2021   grade_8 195 5 7 0   6     0   3   99 117 *                     216.0 195 5 7 0   6     0   3   99 117                 216
1675633 MA Middlesex   school 2507020 160   Lowell 250702001036 1600315 Lowell - James S Daley Middle School   Regular School No Middle 05 08 2021   grade_8 42 9 34 0   77     0   7   99 70 *                     169.0 42 9 34 0   77     0   7   99 70                 169
1676969 MA Bristol   school 2509000 218   Norton 250900001452 2180305 Norton - Norton Middle   Regular School No Middle 06 08 2021   grade_8 179 2 9 0   3     0   9   99 103 *                     202.0 179 2 9 0   3     0   9   99 103                 202
1677247 MA Berkshire   school 2509630 236   Pittsfield 250963001532 2360310 Pittsfield - Theodore Herberg Middle   Regular School No Middle 06 08 2021   grade_8 135 26 26 0   0     0   14   99 102 *                     201.0 135 26 26 0   0     0   14   99 102                 201
1677559 MA Suffolk   school 2510050 248   Revere 251005001976 2480057 Revere - Garfield Middle School   Regular School No Middle 06 08 2021   grade_8 68 9 118 0   8     0   3   99 107 *                     206.0 68 9 118 0   8     0   3   99 107                 206
1679069 MA Middlesex   school 2512750 330   Weston 251275000793 3300305 Weston - Weston Middle   Regular School No Middle 06 08 2021   grade_8 104 16 14 0   28     0   13   99 76 *                     175.0 104 16 14 0   28     0   13   99 76                 175
1680584 MA Barnstable   school 2504560 660   Nauset 250456000609 6600305 Nauset - Nauset Regional Middle   Regular School No Middle 06 08 2021   grade_8 180 9 11 1   3     0   3   99 108 *                     207.0 180 9 11 1   3     0   3   99 108                 207
2040914 MA Suffolk   school 2502790 35   Boston 250279002013 350383 Lilla G. Frederick Middle School   Regular School No Middle 06 08 2019   grade_8 0 74 72 0   16     1   4   99 68                       167.0 0 74 72 0   16     1   4   99 68                 167
2045594 MA Plymouth   school 2510560 264   Scituate 251056001690 2640305 Gates Middle School   Regular School No Middle 06 08 2019   grade_8 206 3 3 0   3     0   2   99 118                       217.0 206 3 3 0   3     0   2   99 118                 217
2228915 MA Essex   school 2501950 9   Andover 250195002510 90305 Andover: Doherty Middle   Regular School No Middle 06 08 2018   grade_8 131 1 8 1   24     0   4   99 70                       169.0 131 1 8 1   24     0   4   99 70                 169
2231093 MA Middlesex   school 2503840 67   Concord 250384000522 670305 Concord: Concord Middle   Regular School No Middle 06 08 2018   grade_8 196 10 12 1   14     0   14   99 148                       247.0 196 10 12 1   14     0   14   99 148                 247
2231623 MA Bristol   school 2504830 95   Fall River 250483000671 950320 Fall River: Matthew J Kuss Middle   Regular School No Middle 06 08 2018   grade_8 136 16 45 1   13     0   16   99 128                       227.0 136 16 45 1   13     0   16   99 128                 227
2234233 MA Essex   school 2508580 204   Newburyport 250858001355 2040305 Newburyport: Rupert A Nock Middle   Regular School No Middle 06 08 2018   grade_8 158 1 3 0   1     0   4   99 68                       167.0 158 1 3 0   1     0   4   99 68                 167
2235495 MA Essex   school 2510380 258   Salem 251038002404 2580305 Salem: Collins Middle   Regular School No Middle 06 08 2018   grade_8 82 7 69 0   6     0   9   99 74                       173.0 82 7 69 0   6     0   9   99 74                 173
2238901 MA Worcester   school 2504360 658   Dudley-Charlton Reg 250436001597 6580310 Dudley-Charlton Reg: Charlton Middle School   Regular School No Middle 05 08 2018   grade_8 168 2 6 0   3     0   2   99 82                       181.0 168 2 6 0   3     0   2   99 82                 181
736418 MA Suffolk   school 2502790 35   Boston 250279000269 350179 John W McCormack   Regular School No 2 06 08 2015   grade_8 11 71 103 0   16     0   2   98 105                       203 11 71 103 0   16     0   2   98 105                 203
737151 MA Plymouth   school 2503090 44   Brockton 250309000404 440410 North Middle School   Regular School No 2 06 08 2015   grade_8 26 135 23 1   5     0   8   98 100                       198 26 135 23 1   5     0   8   98 100                 198
739359 MA Middlesex   school 2507020 160   Lowell 250702001955 1600360 Kathryn P. Stoklosa Middle School   Regular School No 2 05 08 2015   grade_8 19 9 37 0   107     0   4   98 78                       176 19 9 37 0   107     0   4   98 78                 176
739827 MA Norfolk   school 2507590 177   Medway 250759002483 1770305 Medway Middle   Regular School No 2 05 08 2015   grade_8 184 2 3 0   6     1   4   98 102                       200 184 2 3 0   6     1   4   98 102                 200
741113 MA Norfolk   school 2509870 243   Quincy 250987001561 2430305 Atlantic Middle   Regular School No 2 06 08 2015   grade_8 66 5 5 0   102     1   3   98 84                       182 66 5 5 0   102     1   3   98 84                 182
741719 MA Worcester   school 2511010 277   Southbridge 251101002755 2770415 Southbridge Middle/High School   Regular School No 4 06 12 2015   grade_8 101 0 79 0   2     0   0   98 84                       182 101 0 79 0   2     0   0   98 84                 182
744254 MA Worcester   school 2504360 658   Dudley-Charlton Reg 250436001597 6580310 Charlton Middle School   Regular School No 2 05 08 2015   grade_8 176 0 9 0   3     0   3   98 93                       191 176 0 9 0   3     0   3   98 93                 191
932741 MA Middlesex   school 2502100 14   Ashland 250210000938 140405 Ashland Middle   Regular School No 2 06 08 2016   grade_8 137 7 29 2   20     0   4   98 101                       199 137 7 29 2   20     0   4   98 101                 199
934520 MA Middlesex   school 2503840 67   Concord 250384000522 670305 Concord Middle   Regular School No 2 06 08 2016   grade_8 170 7 9 0   14     0   8   98 110                       208 170 7 9 0   14     0   8   98 110                 208
937497 MA Bristol   school 2509000 218   Norton 250900001452 2180305 Norton Middle   Regular School No 2 06 08 2016   grade_8 190 2 4 0   3     1   4   98 106                       204 190 2 4 0   3     1   4   98 106                 204
941026 MA Barnstable   school 2504140 645   Dennis-Yarmouth 250414000558 6450505 Dennis-Yarmouth Regional High   Regular School No 3 08 12 2016   grade_8 167 21 19 3   5     0   12   98 129                       227 167 21 19 3   5     0   12   98 129                 227
941306 MA Worcester   school 2507680 710   Mendon-Upton 250768001279 7100015 Miscoe Hill School   Regular School No 2 04 08 2016   grade_8 185 2 5 0   4     0   4   98 102                       200 185 2 5 0   4     0   4   98 102                 200
1122544 MA Middlesex   school 2502670 31   Billerica 250267000182 310310 Locke Middle   Regular School No Middle 06 08 2017   grade_8 163 4 6 0   14     0   3   98 92                       190 163 4 6 0   14     0   3   98 92                 190
1124951 MA Norfolk   school 2504950 99   Foxborough 250495000709 990405 John J Ahern   Regular School No Middle 05 08 2017   grade_8 174 5 5 0   7     0   2   98 95                       193 174 5 5 0   7     0   2   98 95                 193
1129467 MA Middlesex   school 2511220 284   Stoneham 251122001857 2840405 Stoneham Central Middle School   Regular School No Middle 05 08 2017   grade_8 169 4 15 0   9     0   7   98 106                       204 169 4 15 0   9     0   7   98 106                 204
1129612 MA Essex   school 2511430 291   Swampscott 251143002562 2910305 Swampscott Middle   Regular School No Middle 05 08 2017   grade_8 161 8 21 0   1     0   6   98 99                       197 161 8 21 0   1     0   6   98 99                 197
1365144 MA Norfolk   school 2502460 25   Bellingham 250246000139 250505 Bellingham High School   Regular School No High 08 12 2020   grade_8 150 3 13 1   8     0   7   98 84 *                     182.0 150 3 13 1   8     0   7   98 84                 182
1365959 MA Suffolk   school 2502790 35   Boston 250279000204 350545 Boston Latin Academy   Regular School No High 07 12 2020   grade_8 92 66 69 0   36     0   6   98 171 *                     269.0 92 66 69 0   36     0   6   98 171                 269
1368401 MA Middlesex   school 2507020 160   Lowell 250702000073 1600340 James Sullivan Middle School   Regular School No Middle 05 08 2020   grade_8 56 16 71 0   27     0   5   98 77 *                     175.0 56 16 71 0   27     0   5   98 77                 175
1369744 MA Plymouth   school 2509030 219   Norwell 250903001456 2190405 Norwell Middle School   Regular School No Middle 06 08 2020   grade_8 148 0 3 0   5     1   5   98 64 *                     162.0 148 0 3 0   5     1   5   98 64                 162
2041634 MA Middlesex   school 2503510 56   Chelmsford 250351000478 560310 McCarthy Middle School   Regular School No Middle 05 08 2019   grade_8 152 6 6 0   29     0   7   98 102                       200.0 152 6 6 0   29     0   7   98 102                 200
2043519 MA Hampden   school 2507050 161   Ludlow 250705001055 1610305 Paul R Baird Middle   Regular School No Middle 06 08 2019   grade_8 184 2 16 2   2     0   2   98 110                       208.0 184 2 16 2   2     0   2   98 110                 208
2044437 MA Essex   school 2508580 204   Newburyport 250858001355 2040305 Rupert A Nock Middle   Regular School No Middle 06 08 2019   grade_8 177 0 8 0   1     0   3   98 91                       189.0 177 0 8 0   1     0   3   98 91                 189
2229044 MA Bristol   school 2502190 16   Attleboro 250219000096 160305 Attleboro: Robert J. Coelho Middle School   Regular School No Middle 05 08 2018   grade_8 147 8 24 0   5     0   8   98 94                       192.0 147 8 24 0   5     0   8   98 94                 192
2236159 MA Hampden   school 2511130 281   Springfield 251113002599 2810320 Springfield: John J Duggan Middle   Regular School No High 06 12 2018   grade_8 25 48 92 0   4     0   2   98 73                       171.0 25 48 92 0   4     0   2   98 73                 171
2238622 MA Worcester   school 2502040 610   Ashburnham-Westminster 250204000831 6100305 Ashburnham-Westminster: Overlook Middle School   Regular School No Middle 06 08 2018   grade_8 176 0 6 0   1     0   1   98 86                       184.0 176 0 6 0   1     0   1   98 86                 184
736784 MA Suffolk   school 2502790 35   Boston 250279000216 350430 Clarence R Edwards Middle   Regular School No 2 06 08 2015   grade_8 11 16 121 0   18     0   2   97 71                       168 11 16 121 0   18     0   2   97 71                 168
740300 MA Essex   school 2508580 204   Newburyport 250858001355 2040305 Rupert A Nock Middle   Regular School No 2 06 08 2015   grade_8 183 3 6 0   2     0   2   97 99                       196 183 3 6 0   2     0   2   97 99                 196
742516 MA Middlesex   school 2512180 314   Watertown 251218002501 3140305 Watertown Middle   Regular School No 2 06 08 2015   grade_8 134 5 23 0   12     1   10   97 88                       185 134 5 23 0   12     1   10   97 88                 185
742718 MA Hampden   school 2512630 325   Westfield 251263001570 3250310 South Middle School   Regular School No 2 06 08 2015   grade_8 157 6 20 0   10     0   3   97 99                       196 157 6 20 0   10     0   3   97 99                 196
742749 MA Middlesex   school 2512660 326   Westford 251266000170 3260310 Blanchard Middle   Regular School No 2 06 08 2015   grade_8 160 1 3 0   37     0   5   97 109                       206 160 1 3 0   37     0   5   97 109                 206
1122196 MA Middlesex   school 2502100 14   Ashland 250210000938 140405 Ashland Middle   Regular School No Middle 06 08 2017   grade_8 144 4 27 0   19     0   8   97 105                       202 144 4 27 0   19     0   8   97 105                 202
1122273 MA Worcester   school 2502220 17   Auburn 250222002567 170305 Auburn Middle   Regular School No Middle 06 08 2017   grade_8 181 4 5 1   12     0   5   97 111                       208 181 4 5 1   12     0   5   97 111                 208
1125022 MA Middlesex   school 2504980 100   Framingham 250498001530 1000302 Cameron Middle School   Regular School No Middle 06 08 2017   grade_8 120 17 40 0   2     0   7   97 89                       186 120 17 40 0   2     0   7   97 89                 186
1126298 MA Middlesex   school 2507020 160   Lowell 250702001955 1600360 Kathryn P. Stoklosa Middle School   Regular School No Middle 05 08 2017   grade_8 17 3 46 0   106     0   6   97 81                       178 17 3 46 0   106     0   6   97 81                 178
1127411 MA Essex   school 2508580 204   Newburyport 250858001355 2040305 Rupert A Nock Middle   Regular School No Middle 06 08 2017   grade_8 180 0 2 0   5     0   4   97 94                       191 180 0 2 0   5     0   4   97 94                 191
1130299 MA Middlesex   school 2512660 326   Westford 251266000170 3260310 Blanchard Middle   Regular School No Middle 06 08 2017   grade_8 142 2 1 2   57     0   5   97 112                       209 142 2 1 2   57     0   5   97 112                 209
1367452 MA Worcester   school 2505130 103   Gardner 250513000751 1030505 Gardner High   Regular School No High 08 12 2020   grade_8 131 6 41 0   1     0   12   97 94 *                     191.0 131 6 41 0   1     0   12   97 94                 191
1672144 MA Essex   school 2501950 9   Andover 250195002511 90310 Andover - Andover West Middle   Regular School No Middle 06 08 2021   grade_8 119 6 14 0   29     0   7   97 78 *                     175.0 119 6 14 0   29     0   7   97 78                 175
1679038 MA Middlesex   school 2512660 326   Westford 251266000170 3260310 Westford - Blanchard Middle   Regular School No Middle 06 08 2021   grade_8 104 7 6 2   54     0   10   97 86 *                     183.0 104 7 6 2   54     0   10   97 86                 183
1679379 MA Middlesex   school 2513200 347   Woburn 251320002182 3470410 Woburn - Daniel L Joyce Middle School   Regular School No Middle 06 08 2021   grade_8 133 17 31 0   8     0   6   97 98 *                     195.0 133 17 31 0   8     0   6   97 98                 195
2039945 MA Essex   school 2501950 9   Andover 250195002510 90305 Doherty Middle   Regular School No Middle 06 08 2019   grade_8 162 1 6 2   26     0   4   97 104                       201.0 162 1 6 2   26     0   4   97 104                 201
2041307 MA Plymouth   school 2503090 44   Brockton 250309002688 440421 Ashfield Middle School   Regular School No Middle 06 08 2019   grade_8 48 93 20 1   5     0   6   97 76                       173.0 48 93 20 1   5     0   6   97 76                 173
2045076 MA Berkshire   school 2509630 236   Pittsfield 250963001532 2360310 Theodore Herberg Middle   Regular School No Middle 06 08 2019   grade_8 127 21 27 0   3     0   18   97 99                       196.0 127 21 27 0   3     0   18   97 99                 196
2045335 MA Middlesex   school 2509990 246   Reading 250999001612 2460310 Walter S Parker Middle   Regular School No Middle 06 08 2019   grade_8 172 3 7 0   11     0   3   97 99                       196.0 172 3 7 0   11     0   3   97 99                 196
2048139 MA Worcester   school 2502040 610   Ashburnham-Westminster 250204000831 6100305 Overlook Middle School   Regular School No Middle 06 08 2019   grade_8 188 0 7 0   1     0   4   97 103                       200.0 188 0 7 0   1     0   4   97 103                 200
2229002 MA Middlesex   school 2502100 14   Ashland 250210000938 140405 Ashland: Ashland Middle   Regular School No Middle 06 08 2018   grade_8 148 5 22 0   27     0   6   97 111                       208.0 148 5 22 0   27     0   6   97 111                 208
2229167 MA Hampshire   school 2502430 24   Belchertown 250243001873 240025 Belchertown: Jabish Middle School   Regular School No Middle 07 08 2018   grade_8 181 2 1 0   2     1   5   97 95                       192.0 181 2 1 0   2     1   5   97 95                 192
2231615 MA Bristol   school 2504830 95   Fall River 250483000655 950305 Fall River: Talbot Innovation School   Regular School No Middle 06 08 2018   grade_8 73 18 63 0   8     0   19   97 84                       181.0 73 18 63 0   8     0   19   97 84                 181
2232506 MA Middlesex   school 2506390 141   Hudson 250639000926 1410505 Hudson: Hudson High   Regular School No High 08 12 2018   grade_8 176 6 20 0   0     1   6   97 112                       209.0 176 6 20 0   0     1   6   97 112                 209
2233654 MA Middlesex   school 2507560 176   Medford 250756002063 1760320 Medford: John J. McGlynn Middle School   Regular School No Middle 06 08 2018   grade_8 84 29 21 0   29     0   5   97 71                       168.0 84 29 21 0   29     0   5   97 71                 168
2238749 MA Bristol   school 2503030 625   Bridgewater-Raynham 250303001674 6250315 Bridgewater-Raynham: Raynham Middle School   Regular School No Middle 05 08 2018   grade_8 163 4 7 0   2     0   9   97 88                       185.0 163 4 7 0   2     0   9   97 88                 185
735986 MA Middlesex   school 2502400 23   Bedford 250240000130 230305 John Glenn Middle   Regular School No 2 06 08 2015   grade_8 129 12 8 0   15     1   15   96 84                       180 129 12 8 0   15     1   15   96 84                 180
740599 MA Worcester   school 2508880 213   Northborough 250888001440 2130305 Robert E. Melican Middle School   Regular School No 2 06 08 2015   grade_8 183 0 8 1   18     0   8   96 122                       218 183 0 8 1   18     0   8   96 122                 218
741964 MA Hampden   school 2511130 281   Springfield 251113002601 2810328 John F Kennedy Middle   Regular School No 2 06 08 2015   grade_8 31 44 96 0   0     0   5   96 80                       176 31 44 96 0   0     0   5   96 80                 176
743033 MA Suffolk   school 2513170 346   Winthrop 251317002180 3460505 Winthrop Sr High   Regular School No 3 08 12 2015   grade_8 150 2 13 0   0     0   7   96 76                       172 150 2 13 0   0     0   7   96 76                 172
933634 MA Suffolk   school 2502790 35   Boston 250279002013 350383 Lilla G. Frederick Middle School   Regular School No 2 06 08 2016   grade_8 3 92 85 0   12     1   3   96 100                       196 3 92 85 0   12     1   3   96 100                 196
938764 MA Hampden   school 2511130 281   Springfield 251113002599 2810320 John J Duggan Middle   Regular School No 4 06 10 2016   grade_8 28 48 83 0   6     1   4   96 74                       170 28 48 83 0   6     1   4   96 74                 170
940847 MA Worcester   school 2502040 610   Ashburnham-Westminster 250204000831 6100305 Overlook Middle School   Regular School No 2 06 08 2016   grade_8 176 3 3 0   2     0   3   96 91                       187 176 3 3 0   2     0   3   96 91                 187
1125110 MA Worcester   school 2505130 103   Gardner 250513000751 1030505 Gardner High   Regular School No High 08 12 2017   grade_8 144 5 22 0   3     0   7   96 85                       181 144 5 22 0   3     0   7   96 85                 181
1127539 MA Middlesex   school 2508610 207   Newton 250861001042 2070320 Oak Hill Middle   Regular School No Middle 06 08 2017   grade_8 127 13 14 0   51     0   12   96 121                       217 127 13 14 0   51     0   12   96 121                 217
1129981 MA Plymouth   school 2512060 310   Wareham 251206002603 3100305 Wareham Middle   Regular School No Middle 05 08 2017   grade_8 137 8 13 4   2     0   18   96 86                       182 137 8 13 4   2     0   18   96 86                 182
1369653 MA Worcester   school 2508880 213   Northborough 250888001440 2130305 Robert E. Melican Middle School   Regular School No Middle 06 08 2020   grade_8 148 8 14 0   21     2   11   96 108 *                     204.0 148 8 14 0   21     2   11   96 108                 204
1676404 MA Middlesex   school 2508340 198   Natick 250834001297 1980305 Natick - J F Kennedy Middle School   Regular School No Middle 05 08 2021   grade_8 123 4 11 0   15     0   14   96 71 *                     167.0 123 4 11 0   15     0   14   96 71                 167
1677530 MA Suffolk   school 2510050 248   Revere 251005001963 2480014 Revere - Rumney Marsh Academy   Regular School No Middle 06 08 2021   grade_8 58 7 121 1   11     0   10   96 112 *                     208.0 58 7 121 1   11     0   10   96 112                 208
1679805 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_8 7 82 80 1   2     0   6   96 82 *                     178.0 7 82 80 1   2     0   6   96 82                 178
1680829 MA Barnstable   school 2500544 712   Monomoy Regional School District 250054402836 7120515 Monomoy Regional School District - Monomoy Regional High School   Regular School No High 08 12 2021   grade_8 149 10 17 0   2     1   2   96 85 *                     181.0 149 10 17 0   2     1   2   96 85                 181
2040136 MA Middlesex   school 2502400 23   Bedford 250240000130 230305 John Glenn Middle   Regular School No Middle 06 08 2019   grade_8 126 14 12 0   32     0   7   96 95                       191.0 126 14 12 0   32     0   7   96 95                 191
2233311 MA Essex   school 2507110 163   Lynn 250711001083 1630420 Lynn: Pickering Middle   Regular School No Middle 06 08 2018   grade_8 79 11 77 2   15     0   15   96 103                       199.0 79 11 77 2   15     0   15   96 103                 199
736790 MA Suffolk   school 2502790 35   Boston 250279000345 350470 Wm B Rogers Middle   Regular School No 2 06 08 2015   grade_8 4 107 47 1   11     0   5   95 80                       175 4 107 47 1   11     0   5   95 80                 175
743091 MA Middlesex   school 2513200 347   Woburn 251320002186 3470405 John F Kennedy Middle School   Regular School No 2 06 08 2015   grade_8 145 11 14 1   11     0   2   95 89                       184 145 11 14 1   11     0   2   95 89                 184
744126 MA Bristol   school 2503030 625   Bridgewater-Raynham 250303001674 6250315 Raynham Middle School   Regular School No 2 05 08 2015   grade_8 170 5 4 0   1     0   7   95 92                       187 170 5 4 0   1     0   7   95 92                 187
937948 MA Norfolk   school 2509870 243   Quincy 250987001564 2430315 Central Middle   Regular School No 2 06 08 2016   grade_8 130 10 3 0   74     0   2   95 124                       219 130 10 3 0   74     0   2   95 124                 219

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