enrollments

Data source: Big Local News · About: Big Local

497 rows where grade = "grade_7", state = "MA" and year = 2017 sorted by male descending

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

  • 2017 · 497 ✖

grade ✖

  • grade_7 · 497 ✖
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
1123680 1123680 MA Plymouth   school 2503090 44   Brockton 250309000404 440410 North Middle School   Regular School No Middle 06 08 2017   grade_7 18 140 22 0   3     1   5   99 90                       189 18 140 22 0   3     1   5   99 90                 189
1125449 1125449 MA Essex   school 2505970 128   Haverhill 250597000850 1280100 Consentino Middle School   Regular School No Elementary 01 08 2017   grade_7 96 8 98 0   3     0   1   99 107                       206 96 8 98 0   3     0   1   99 107                 206
1128164 1128164 MA Berkshire   school 2509630 236   Pittsfield 250963001532 2360310 Theodore Herberg Middle   Regular School No Middle 06 08 2017   grade_7 159 20 18 0   2     0   15   99 115                       214 159 20 18 0   2     0   15   99 115                 214
1131917 1131917 MA Bristol   school 2503030 625   Bridgewater-Raynham 250303001674 6250315 Raynham Middle School   Regular School No Middle 05 08 2017   grade_7 165 5 6 0   2     0   9   99 88                       187 165 5 6 0   2     0   9   99 88                 187
1127410 1127410 MA Essex   school 2508580 204   Newburyport 250858001355 2040305 Rupert A Nock Middle   Regular School No Middle 06 08 2017   grade_7 155 2 1 0   1     0   4   98 65                       163 155 2 1 0   1     0   4   98 65                 163
1127838 1127838 MA Bristol   school 2509000 218   Norton 250900001452 2180305 Norton Middle   Regular School No Middle 06 08 2017   grade_7 179 4 5 0   2     0   6   98 98                       196 179 4 5 0   2     0   6   98 98                 196
1132069 1132069 MA Worcester   school 2504360 658   Dudley-Charlton Reg 250436001597 6580310 Charlton Middle School   Regular School No Middle 05 08 2017   grade_7 165 2 4 0   3     0   2   98 78                       176 165 2 4 0   3     0   2   98 78                 176
1122360 1122360 MA Hampshire   school 2502430 24   Belchertown 250243001873 240025 Jabish Middle School   Regular School No Middle 07 08 2017   grade_7 175 3 2 0   2     1   5   97 91                       188 175 3 2 0   2     1   5   97 91                 188
1124795 1124795 MA Bristol   school 2504830 95   Fall River 250483000655 950305 Talbot Innovation School   Regular School No Middle 06 08 2017   grade_7 88 14 59 0   8     0   15   97 87                       184 88 14 59 0   8     0   15   97 87                 184
1125687 1125687 MA Middlesex   school 2506390 141   Hudson 250639000927 1410410 David J. Quinn Middle School   Regular School No Middle 05 07 2017   grade_7 177 4 16 0   0     1   7   97 108                       205 177 4 16 0   0     1   7   97 108                 205
1132166 1132166 MA Middlesex   school 2505500 673   Groton-Dunstable 250550000805 6730305 Groton Dunstable Regional Middle   Regular School No Middle 05 08 2017   grade_7 174 1 4 0   19     0   4   97 105                       202 174 1 4 0   19     0   4   97 105                 202
1122032 1122032 MA Essex   school 2501860 7   Amesbury 250186000035 70013 Amesbury Middle   Regular School No Middle 05 08 2017   grade_7 160 0 10 0   2     0   6   96 82                       178 160 0 10 0   2     0   6   96 82                 178
1125108 1125108 MA Worcester   school 2505130 103   Gardner 250513002431 1030405 Gardner Middle School   Regular School No Middle 05 07 2017   grade_7 123 6 30 1   3     0   18   96 85                       181 123 6 30 1   3     0   18   96 85                 181
1129637 1129637 MA Bristol   school 2511460 292   Swansea 251146001894 2920305 Joseph Case Jr High   Regular School No Middle 06 08 2017   grade_7 170 1 2 0   0     0   0   96 77                       173 170 1 2 0   0     0   0   96 77                 173
1129945 1129945 MA Middlesex   school 2512000 308   Waltham 251200001977 3080415 John W. McDevitt Middle School   Regular School No Middle 06 08 2017   grade_7 83 17 82 0   6     0   3   96 95                       191 83 17 82 0   6     0   3   96 95                 191
1132254 1132254 MA Hampden   school 2505730 680   Hampden-Wilbraham 250573002141 6800310 Wilbraham Middle   Regular School No Middle 06 08 2017   grade_7 172 5 12 0   4     0   7   96 104                       200 172 5 12 0   4     0   7   96 104                 200
1129611 1129611 MA Essex   school 2511430 291   Swampscott 251143002562 2910305 Swampscott Middle   Regular School No Middle 05 08 2017   grade_7 162 8 24 0   8     0   3   95 110                       205 162 8 24 0   8     0   3   95 110                 205
1123676 1123676 MA Plymouth   school 2503090 44   Brockton 250309000389 440405 East Middle School   Regular School No Middle 06 08 2017   grade_7 22 124 15 0   3     2   9   94 81                       175 22 124 15 0   3     2   9   94 81                 175
1126832 1126832 MA Middlesex   school 2507560 176   Medford 250756002063 1760320 John J. McGlynn Middle School   Regular School No Middle 06 08 2017   grade_7 83 28 19 0   27     0   4   94 67                       161 83 28 19 0   27     0   4   94 67                 161
1128671 1128671 MA Essex   school 2510380 258   Salem 251038002404 2580305 Collins Middle   Regular School No Middle 06 08 2017   grade_7 88 8 64 0   5     0   7   94 78                       172 88 8 64 0   5     0   7   94 78                 172
1131790 1131790 MA Worcester   school 2502040 610   Ashburnham-Westminster 250204000831 6100305 Overlook Middle School   Regular School No Middle 06 08 2017   grade_7 171 0 5 0   1     0   1   94 84                       178 171 0 5 0   1     0   1   94 84                 178
1122195 1122195 MA Middlesex   school 2502100 14   Ashland 250210000938 140405 Ashland Middle   Regular School No Middle 06 08 2017   grade_7 146 5 23 0   27     0   5   93 113                       206 146 5 23 0   27     0   5   93 113                 206
1125021 1125021 MA Middlesex   school 2504980 100   Framingham 250498001530 1000302 Cameron Middle School   Regular School No Middle 06 08 2017   grade_7 117 12 36 1   6     0   6   93 85                       178 117 12 36 1   6     0   6   93 85                 178
1130719 1130719 MA Middlesex   school 2513200 347   Woburn 251320002186 3470405 John F Kennedy Middle School   Regular School No Middle 06 08 2017   grade_7 141 13 18 2   13     0   3   93 97                       190 141 13 18 2   13     0   3   93 97                 190
1130723 1130723 MA Middlesex   school 2513200 347   Woburn 251320002182 3470410 Daniel L Joyce Middle School   Regular School No Middle 06 08 2017   grade_7 146 10 12 2   10     1   5   93 93                       186 146 10 12 2   10     1   5   93 93                 186
1131524 1131524 MA Suffolk   school 2500533 480   UP Academy Charter School of Boston (District) 250053302713 4800405 UP Academy Charter School of Boston   Regular School Yes Middle 06 08 2017   grade_7 8 77 64 1   8     2   8   93 75                       168 8 77 64 1   8     2   8   93 75                 168
1132809 1132809 MA Essex   school 2511740 773   Triton 251174001470 7730405 Triton Regional Middle School   Regular School No Middle 07 08 2017   grade_7 176 3 5 0   4     1   4   93 100                       193 176 3 5 0   4     1   4   93 100                 193
1122543 1122543 MA Middlesex   school 2502670 31   Billerica 250267000182 310310 Locke Middle   Regular School No Middle 06 08 2017   grade_7 147 3 3 0   12     0   7   92 80                       172 147 3 3 0   12     0   7   92 80                 172
1123236 1123236 MA Suffolk   school 2502790 35   Boston 250279002013 350383 Lilla G. Frederick Middle School   Regular School No Middle 06 08 2017   grade_7 3 83 71 0   14     0   5   92 84                       176 3 83 71 0   14     0   5   92 84                 176
1129980 1129980 MA Plymouth   school 2512060 310   Wareham 251206002603 3100305 Wareham Middle   Regular School No Middle 05 08 2017   grade_7 148 15 9 3   1     0   15   92 99                       191 148 15 9 3   1     0   15   92 99                 191
1124882 1124882 MA Worcester   school 2504890 97   Fitchburg 250489001523 970048 Memorial Intermediate   Regular School No Middle 05 08 2017   grade_7 42 6 98 0   7     0   10   91 72                       163 42 6 98 0   7     0   10   91 72                 163
1126297 1126297 MA Middlesex   school 2507020 160   Lowell 250702001955 1600360 Kathryn P. Stoklosa Middle School   Regular School No Middle 05 08 2017   grade_7 19 17 53 0   89     0   3   91 90                       181 19 17 53 0   89     0   3   91 90                 181
1126282 1126282 MA Middlesex   school 2507020 160   Lowell 250702001034 1600330 Henry J Robinson Middle   Regular School No Middle 05 08 2017   grade_7 49 26 55 0   34     0   5   90 79                       169 49 26 55 0   34     0   5   90 79                 169
1127526 1127526 MA Middlesex   school 2508610 207   Newton 250861000307 2070305 Bigelow Middle   Regular School No Middle 06 08 2017   grade_7 120 10 15 2   26     0   11   90 94                       184 120 10 15 2   26     0   11   90 94                 184
1128160 1128160 MA Berkshire   school 2509630 236   Pittsfield 250963001525 2360305 John T Reid Middle   Regular School No Middle 06 08 2017   grade_7 133 20 24 1   0     0   16   90 104                       194 133 20 24 1   0     0   16   90 104                 194
1129466 1129466 MA Middlesex   school 2511220 284   Stoneham 251122001857 2840405 Stoneham Central Middle School   Regular School No Middle 05 08 2017   grade_7 145 1 12 0   7     0   6   90 81                       171 145 1 12 0   7     0   6   90 81                 171
1123439 1123439 MA Suffolk   school 2502790 35   Boston 250279000312 350691 Rafael Hernandez   Regular School No Elementary PK 08 2017   grade_7 1 0 25 0   0     0   0   9 17                       26 1 0 25 0   0     0   0   9 17                 26
1124147 1124147 MA Hampden   school 2503660 61   Chicopee 250366000720 610021 Chicopee Academy   Alternative School No Other 06 12 2017   grade_7 1 0 9 0   0     0   0   9 1                       10 1 0 9 0   0     0   0   9 1                 10
1126503 1126503 MA Essex   school 2507110 163   Lynn 250711002647 1630525 Fecteau-Leary Junior/Senior High School   Regular School No High 07 12 2017   grade_7 3 0 7 0   0     0   1   9 2                       11 3 0 7 0   0     0   1   9 2                 11
1124502 1124502 MA Plymouth   school 2504440 83   East Bridgewater 250444000597 830505 East Bridgewater JR./SR. High School   Regular School No High 07 12 2017   grade_7 188 2 3 1   0     0   2   89 107                       196 188 2 3 1   0     0   2   89 107                 196
1128534 1128534 MA Suffolk   school 2510050 248   Revere 251005002113 2480305 Susan B. Anthony Middle School   Regular School No Middle 06 08 2017   grade_7 66 5 98 0   13     0   2   89 95                       184 66 5 98 0   13     0   2   89 95                 184
1128812 1128812 MA Bristol   school 2510590 265   Seekonk 251059001700 2650405 Dr. Kevin M. Hurley Middle School   Regular School No Middle 06 08 2017   grade_7 150 3 10 0   6     0   5   89 85                       174 150 3 10 0   6     0   5   89 85                 174
1124062 1124062 MA Middlesex   school 2503510 56   Chelmsford 250351000476 560305 Col Moses Parker School   Regular School No Middle 05 08 2017   grade_7 133 3 11 0   34     0   0   88 93                       181 133 3 11 0   34     0   0   88 93                 181
1126828 1126828 MA Middlesex   school 2507560 176   Medford 250756001638 1760315 Madeleine Dugger Andrews   Regular School No Middle 06 08 2017   grade_7 113 21 15 0   8     0   10   88 79                       167 113 21 15 0   8     0   10   88 79                 167
1127538 1127538 MA Middlesex   school 2508610 207   Newton 250861001042 2070320 Oak Hill Middle   Regular School No Middle 06 08 2017   grade_7 110 11 12 0   37     0   19   88 101                       189 110 11 12 0   37     0   19   88 101                 189
1129886 1129886 MA Norfolk   school 2511970 307   Walpole 251197001965 3070310 Eleanor N Johnson Middle   Regular School No Middle 06 08 2017   grade_7 124 5 6 0   16     0   6   88 69                       157 124 5 6 0   16     0   6   88 69                 157
1130302 1130302 MA Middlesex   school 2512660 326   Westford 251266002080 3260330 Stony Brook School   Regular School No Middle 06 08 2017   grade_7 126 4 3 1   45     0   7   88 98                       186 126 4 3 1   45     0   7   88 98                 186
1132038 1132038 MA Norfolk   school 2504290 655   Dover-Sherborn 250429000575 6550405 Dover-Sherborn Regional Middle School   Regular School No Middle 06 08 2017   grade_7 137 6 8 0   16     0   7   88 86                       174 137 6 8 0   16     0   7   88 86                 174
1130018 1130018 MA Middlesex   school 2512180 314   Watertown 251218002501 3140305 Watertown Middle   Regular School No Middle 06 08 2017   grade_7 102 8 24 0   19     0   10   87 76                       163 102 8 24 0   19     0   10   87 76                 163
1122383 1122383 MA Norfolk   school 2502460 25   Bellingham 250246001683 250315 Bellingham Memorial School   Regular School No Elementary 04 07 2017   grade_7 165 5 3 0   5     0   4   86 96                       182 165 5 3 0   5     0   4   86 96                 182
1123476 1123476 MA Barnstable   school 2502820 36   Bourne 250282001517 360325 Bourne Middle School   Regular School No Middle 05 08 2017   grade_7 170 3 2 2   6     0   0   86 97                       183 170 3 2 2   6     0   0   86 97                 183
1125981 1125981 MA Worcester   school 2506780 153   Leominster 250678000742 1530045 Samoset School   Regular School No Middle 06 08 2017   grade_7 85 15 55 0   2     0   5   86 76                       162 85 15 55 0   2     0   5   86 76                 162
1126287 1126287 MA Middlesex   school 2507020 160   Lowell 250702000073 1600340 James Sullivan Middle School   Regular School No Middle 05 08 2017   grade_7 66 20 63 0   18     0   5   86 86                       172 66 20 63 0   18     0   5   86 86                 172
1128472 1128472 MA Middlesex   school 2509990 246   Reading 250999001612 2460310 Walter S Parker Middle   Regular School No Middle 06 08 2017   grade_7 157 2 2 0   8     0   3   86 86                       172 157 2 2 0   8     0   3   86 86                 172
1128468 1128468 MA Middlesex   school 2509990 246   Reading 250999001605 2460305 Arthur W Coolidge Middle   Regular School No Middle 06 08 2017   grade_7 136 5 1 0   9     0   1   85 67                       152 136 5 1 0   9     0   1   85 67                 152
1131112 1131112 MA Suffolk   school 2500075 410   Excel Academy Charter (District) 250007502084 4100205 Excel Academy Charter School   Regular School Yes Other 05 10 2017   grade_7 14 10 146 3   1     0   0   85 89                       174 14 10 146 3   1     0   0   85 89                 174
1121957 1121957 MA Plymouth   school 2501650 1   Abington 250165000002 10405 Frolio Middle School   Regular School No Middle 07 08 2017   grade_7 142 2 9 0   5     0   1   84 75                       159 142 2 9 0   5     0   1   84 75                 159
1126272 1126272 MA Middlesex   school 2507020 160   Lowell 250702001036 1600315 James S Daley Middle School   Regular School No Middle 05 08 2017   grade_7 48 5 32 0   73     0   11   84 85                       169 48 5 32 0   73     0   11   84 85                 169
1128530 1128530 MA Suffolk   school 2510050 248   Revere 251005001976 2480057 Garfield Middle School   Regular School No Middle 06 08 2017   grade_7 47 4 104 0   10     0   4   84 85                       169 47 4 104 0   10     0   4   84 85                 169
1128586 1128586 MA Plymouth   school 2510170 251   Rockland 251017001642 2510305 John W Rogers Middle   Regular School No Middle 05 08 2017   grade_7 135 6 14 0   4     0   11   84 86                       170 135 6 14 0   4     0   11   84 86                 170
1123692 1123692 MA Plymouth   school 2503090 44   Brockton 250309002688 440421 Ashfield Middle School   Regular School No Middle 06 08 2017   grade_7 77 64 16 0   4     1   6   83 85                       168 77 64 16 0   4     1   6   83 85                 168
1125086 1125086 MA Norfolk   school 2505010 101   Franklin 250501000871 1010310 Remington Middle   Regular School No Middle 06 08 2017   grade_7 137 1 6 0   8     0   5   83 74                       157 137 1 6 0   8     0   5   83 74                 157
1125090 1125090 MA Norfolk   school 2505010 101   Franklin 250501000738 1010405 Horace Mann   Regular School No Middle 06 08 2017   grade_7 136 3 4 0   13     0   1   83 74                       157 136 3 4 0   13     0   1   83 74                 157
1126533 1126533 MA Essex   school 2507140 164   Lynnfield 250714001091 1640405 Lynnfield Middle School   Regular School No Middle 05 08 2017   grade_7 164 1 3 0   5     0   4   83 94                       177 164 1 3 0   5     0   4   83 94                 177
1126933 1126933 MA Essex   school 2507740 181   Methuen 250774002558 1810050 Comprehensive Grammar School   Regular School No Elementary PK 08 2017   grade_7 95 0 36 0   11     0   5   83 64                       147 95 0 36 0   11     0   5   83 64                 147
1129061 1129061 MA Worcester   school 2511010 277   Southbridge 251101002865 2770315 Southbridge Middle School   Regular School No Middle 06 08 2017   grade_7 57 1 98 1   0     0   4   83 78                       161 57 1 98 1   0     0   4   83 78                 161
1123684 1123684 MA Plymouth   school 2503090 44   Brockton 250309000407 440415 South Middle School   Regular School No Middle 06 08 2017   grade_7 47 75 31 0   2     1   10   82 84                       166 47 75 31 0   2     1   10   82 84                 166
1125813 1125813 MA Essex   school 2506660 149   Lawrence 250666002623 1490027 Parthum Middle School   Regular School No Middle 05 08 2017   grade_7 12 5 127 0   0     0   1   82 63                       145 12 5 127 0   0     0   1   82 63                 145
1126292 1126292 MA Middlesex   school 2507020 160   Lowell 250702000086 1600345 Dr An Wang School   Regular School No Middle 05 08 2017   grade_7 55 15 62 0   29     0   4   82 83                       165 55 15 62 0   29     0   4   82 83                 165
1126944 1126944 MA Essex   school 2507740 181   Methuen 250774001556 1810055 Tenney Grammar School   Regular School No Elementary PK 08 2017   grade_7 77 0 69 0   1     0   7   82 72                       154 77 0 69 0   1     0   7   82 72                 154
1123410 1123410 MA Suffolk   school 2502790 35   Boston 250279002721 350656 Mario Umana Academy   Regular School No Elementary PK 08 2017   grade_7 11 7 131 0   6     0   1   81 75                       156 11 7 131 0   6     0   1   81 75                 156
1125082 1125082 MA Norfolk   school 2505010 101   Franklin 250501001785 1010040 Annie Sullivan Middle School   Regular School No Middle 06 08 2017   grade_7 140 0 5 0   6     2   1   81 73                       154 140 0 5 0   6     2   1   81 73                 154
1132064 1132064 MA Worcester   school 2504360 658   Dudley-Charlton Reg 250436001595 6580305 Dudley Middle School   Regular School No Middle 05 08 2017   grade_7 145 2 15 0   2     0   2   81 85                       166 145 2 15 0   2     0   2   81 85                 166
1128361 1128361 MA Norfolk   school 2509870 243   Quincy 250987001561 2430305 Atlantic Middle   Regular School No Middle 06 08 2017   grade_7 66 2 0 0   82     1   9   80 80                       160 66 2 0 0   82     1   9   80 80                 160
1130651 1130651 MA Suffolk   school 2513170 346   Winthrop 251317002179 3460305 Winthrop Middle School   Regular School No Middle 06 08 2017   grade_7 127 1 20 0   1     0   2   80 71                       151 127 1 20 0   1     0   2   80 71                 151
1131207 1131207 MA Suffolk   school 2500071 428   Brooke Charter School Roslindale (District) 250007101747 4280305 Brooke Charter School   Regular School Yes Other KG 09 2017   grade_7 7 75 49 2   1     0   5   80 59                       139 7 75 49 2   1     0   5   80 59                 139
1123092 1123092 MA Suffolk   school 2502790 35   Boston 250279000323 350308 Sarah Greenwood   Regular School No Elementary PK 08 2017   grade_7 0 8 14 0   0     0   0   8 14                       22 0 8 14 0   0     0   0   8 14                 22
1131272 1131272 MA Suffolk   school 2500070 438   Codman Academy Charter Public (District) 250007001667 4380505 Codman Academy Charter Public School   Regular School Yes Other PK 12 2017   grade_7 0 15 4 0   0     0   1   8 12                       20 0 15 4 0   0     0   1   8 12                 20
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
1127169 1127169 MA Middlesex   school 2508340 198   Natick 250834001297 1980305 J F Kennedy Middle School   Regular School No Middle 05 08 2017   grade_7 126 4 5 0   13     0   7   79 76                       155 126 4 5 0   13     0   7   79 76                 155
1129350 1129350 MA Hampden   school 2511130 281   Springfield 251113002601 2810328 John F Kennedy Middle   Regular School No Middle 06 08 2017   grade_7 14 24 109 0   1     0   2   79 71                       150 14 24 109 0   1     0   2   79 71                 150
1126590 1126590 MA Middlesex   school 2507170 165   Malden 250717001363 1650057 Salemwood   Regular School No Elementary KG 08 2017   grade_7 27 38 50 1   25     0   5   78 68                       146 27 38 50 1   25     0   5   78 68                 146
1122242 1122242 MA Bristol   school 2502190 16   Attleboro 250219000087 160315 Cyril K. Brennan Middle School   Regular School No Middle 05 08 2017   grade_7 97 8 24 0   4     0   8   77 64                       141 97 8 24 0   4     0   8   77 64                 141
1122116 1122116 MA Essex   school 2501950 9   Andover 250195001678 90350 Wood Hill Middle School   Regular School No Middle 06 08 2017   grade_7 88 3 10 0   39     0   3   76 67                       143 88 3 10 0   39     0   3   76 67                 143
1125922 1125922 MA Worcester   school 2506720 151   Leicester 250672000973 1510015 Leicester Middle   Regular School No Middle 06 08 2017   grade_7 133 8 15 0   2     0   3   76 85                       161 133 8 15 0   2     0   3   76 85                 161
1126339 1126339 MA Worcester   school 2507080 162   Lunenburg 250708002870 1620305 Lunenburg Middle School   Regular School No Middle 06 08 2017   grade_7 119 3 15 2   2     3   1   76 69                       145 119 3 15 2   2     3   1   76 69                 145
1129882 1129882 MA Norfolk   school 2511970 307   Walpole 251197001959 3070305 Bird Middle   Regular School No Middle 06 08 2017   grade_7 132 4 9 1   7     0   3   76 80                       156 132 4 9 1   7     0   3   76 80                 156
1129941 1129941 MA Middlesex   school 2512000 308   Waltham 251200001971 3080404 John F Kennedy Middle   Regular School No Middle 06 08 2017   grade_7 93 15 41 0   6     0   4   76 83                       159 93 15 41 0   6     0   4   76 83                 159
1130335 1130335 MA Middlesex   school 2512750 330   Weston 251275000793 3300305 Weston Middle   Regular School No Middle 06 08 2017   grade_7 110 13 9 2   28     0   6   76 92                       168 110 13 9 2   28     0   6   76 92                 168
1131967 1131967 MA Berkshire   school 2503390 635   Central Berkshire 250339000466 6350305 Nessacus Regional Middle School   Regular School No Middle 06 08 2017   grade_7 123 2 2 0   1     0   6   76 58                       134 123 2 2 0   1     0   6   76 58                 134
1123414 1123414 MA Suffolk   school 2502790 35   Boston 250279002725 350657 TechBoston Academy   Regular School No Other 06 12 2017   grade_7 3 63 40 0   3     0   7   75 41                       116 3 63 40 0   3     0   7   75 41                 116
1125729 1125729 MA Essex   school 2506480 144   Ipswich 250648000937 1440305 Ipswich Middle School   Regular School No Middle 06 08 2017   grade_7 149 1 5 0   0     0   9   75 89                       164 149 1 5 0   0     0   9   75 89                 164
1125856 1125856 MA Essex   school 2506660 149   Lawrence 250666002758 1490085 Spark Academy   Regular School No Middle 06 08 2017   grade_7 3 3 149 0   3     0   0   75 83                       158 3 3 149 0   3     0   0   75 83                 158
1129777 1129777 MA Middlesex   school 2511760 301   Tyngsborough 251176001715 3010305 Tyngsborough Middle   Regular School No Middle 06 08 2017   grade_7 125 4 7 0   7     0   5   75 73                       148 125 4 7 0   7     0   5   75 73                 148
1122112 1122112 MA Essex   school 2501950 9   Andover 250195002511 90310 Andover West Middle   Regular School No Middle 06 08 2017   grade_7 128 3 9 0   28     0   4   74 98                       172 128 3 9 0   28     0   4   74 98                 172
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
1124705 1124705 MA Bristol   school 2504800 94   Fairhaven 250480002572 940305 Hastings Middle   Regular School No Middle 06 08 2017   grade_7 127 1 6 0   3     0   4   74 67                       141 127 1 6 0   3     0   4   74 67                 141
1126955 1126955 MA Essex   school 2507740 181   Methuen 250774001376 1810060 Donald P Timony Grammar   Regular School No Elementary PK 08 2017   grade_7 50 0 80 0   8     1   12   73 78                       151 50 0 80 0   8     1   12   73 78                 151
1129042 1129042 MA Worcester   school 2510980 276   Southborough 251098001221 2760305 P Brent Trottier   Regular School No Middle 06 08 2017   grade_7 122 1 8 0   18     0   8   73 84                       157 122 1 8 0   18     0   8   73 84                 157
1132028 1132028 MA Bristol   school 2504200 650   Dighton-Rehoboth 250420002430 6500310 Dorothy L Beckwith   Regular School No Middle 05 08 2017   grade_7 135 1 7 1   1     0   0   73 72                       145 135 1 7 1   1     0   0   73 72                 145

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