enrollments

Data source: Big Local News · About: Big Local

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

✎ 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
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
1130160 1130160 MA Worcester   school 2512600 321   Westborough 251260002604 3210305 Sarah W Gibbons Middle   Regular School No Middle 07 08 2017   grade_7 180 4 21 0   92     0   18   157 158                       315 180 4 21 0   92     0   18   157 158                 315
1367237 1367237 MA Barnstable   school 2504860 96   Falmouth 250486000687 960405 Lawrence   Regular School No Middle 07 08 2020   grade_7 205 15 14 1   13     0   18   142 124 *                     266.0 205 15 14 1   13     0   18   142 124                 266
1369465 1369465 MA Middlesex   school 2508610 207   Newton 250861000310 2070310 Charles E Brown Middle   Regular School No Middle 06 08 2020   grade_7 180 9 18 1   51     0   18   141 136 *                     277.0 180 9 18 1   51     0   18   141 136                 277
1371915 1371915 MA Norfolk   school 2512840 336   Weymouth 251284001840 3360020 Maria Weston Chapman Middle School   Regular School No Middle 06 08 2020   grade_7 310 37 53 1   22     0   18   219 222 *                     441.0 310 37 53 1   22     0   18   219 222                 441
1673736 1673736 MA Norfolk   school 2503300 50   Canton 250330000456 500305 Canton - Wm H Galvin Middle   Regular School No Middle 06 08 2021   grade_7 197 29 8 2   27     2   18   137 146 *                     283.0 197 29 8 2   27     2   18   137 146                 283
1675828 1675828 MA Essex   school 2507110 163   Lynn 250711001063 1630405 Lynn - Breed Middle School   Regular School No Middle 06 08 2021   grade_7 35 38 361 1   47     0   18   255 245 *                     500.0 35 38 361 1   47     0   18   255 245                 500
1676244 1676244 MA Plymouth   school 2507770 182   Middleborough 250777001378 1820305 Middleborough - John T. Nichols Middle   Regular School No Middle 06 08 2021   grade_7 221 6 9 1   1     0   18   125 131 *                     256.0 221 6 9 1   1     0   18   125 131                 256
1676796 1676796 MA Hampshire   school 2508850 210   Northampton 250885001430 2100410 Northampton - John F Kennedy Middle School   Regular School No Middle 06 08 2021   grade_7 142 9 33 0   4     0   18   102 103 *                     206.0 142 9 33 0   4     0   18   102 103                 206
1676830 1676830 MA Essex   school 2508700 211   North Andover 250870001398 2110305 North Andover - North Andover Middle   Regular School No Middle 06 08 2021   grade_7 255 9 56 1   33     0   18   166 206 *                     372.0 255 9 56 1   33     0   18   166 206                 372
1679651 1679651 MA Worcester   school 2513230 348   Worcester 251323002253 3480420 Worcester - Worcester East Middle   Regular School No Middle 07 08 2021   grade_7 102 79 168 0   17     0   18   201 183 *                     384.0 102 79 168 0   17     0   18   201 183                 384
1680550 1680550 MA Norfolk   school 2504290 655   Dover-Sherborn 250429000575 6550405 Dover-Sherborn - Dover-Sherborn Regional Middle School   Regular School No Middle 06 08 2021   grade_7 120 6 14 0   29     0   18   96 91 *                     187.0 120 6 14 0   29     0   18   96 91                 187
2040121 2040121 MA Barnstable   school 2502310 20   Barnstable 250231002678 200315 Barnstable Intermediate School   Regular School No Middle 06 07 2019   grade_7 264 27 65 0   8     0   18   207 175                       382.0 264 27 65 0   8     0   18   207 175                 382
2041024 2041024 MA Suffolk   school 2502790 35   Boston 250279000203 350560 Boston Latin   Regular School No High 07 12 2019   grade_7 195 34 71 0   92     0   18   202 208                       410.0 195 34 71 0   92     0   18   202 208                 410
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
2045072 2045072 MA Berkshire   school 2509630 236   Pittsfield 250963001525 2360305 John T Reid Middle   Regular School No Middle 06 08 2019   grade_7 114 24 20 1   2     0   18   88 91                       179.0 114 24 20 1   2     0   18   88 91                 179
2045147 2045147 MA Plymouth   school 2509720 239   Plymouth 250972002531 2390405 Plymouth Commun Intermediate   Regular School No Middle 06 08 2019   grade_7 299 5 27 1   8     0   18   187 170                       358.0 299 5 27 1   8     0   18   187 170                 358
2046607 2046607 MA Plymouth   school 2512060 310   Wareham 251206002603 3100305 Wareham Middle   Regular School No Middle 05 07 2019   grade_7 110 13 22 1   2     1   18   90 77                       167.0 110 13 22 1   2     1   18   90 77                 167
2048095 2048095 MA Middlesex   school 2501710 600   Acton-Boxborough 250171000013 6000405 Raymond J Grey Junior High   Regular School No Middle 07 08 2019   grade_7 231 10 25 2   149     0   18   239 196                       435.0 231 10 25 2   149     0   18   239 196                 435
2232006 2232006 MA Essex   school 2505280 107   Gloucester 250528000779 1070305 Gloucester: Ralph B O'Maley Middle   Regular School No Middle 06 08 2018   grade_7 169 5 14 1   4     2   18   123 90                       213.0 169 5 14 1   4     2   18   123 90                 213
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
736874 736874 MA Suffolk   school 2502790 35   Boston 250279000203 350560 Boston Latin   Regular School No 3 07 12 2015   grade_7 202 29 55 0   103     0   17   183 223                       406 202 29 55 0   103     0   17   183 223                 406
739509 739509 MA Essex   school 2507110 163   Lynn 250711000301 1630305 Thurgood Marshall Mid   Regular School No 2 06 08 2015   grade_7 37 38 208 0   27     0   17   181 146                       327 37 38 208 0   27     0   17   181 146                 327
740267 740267 MA Bristol   school 2508430 201   New Bedford 250843001334 2010405 Keith Middle School   Regular School No 2 06 08 2015   grade_7 117 56 95 3   2     2   17   158 134                       292 117 56 95 3   2     2   17   158 134                 292
742134 742134 MA Middlesex   school 2511340 288   Sudbury 251134001872 2880305 Ephraim Curtis Middle   Regular School No 2 06 08 2015   grade_7 278 7 3 1   19     0   17   178 147                       325 278 7 3 1   19     0   17   178 147                 325
743368 743368 MA Worcester   school 2513230 348   Worcester 251323002253 3480420 Worcester East Middle   Regular School No 2 06 08 2015   grade_7 78 74 157 0   29     0   17   175 180                       355 78 74 157 0   29     0   17   175 180                 355
743371 743371 MA Worcester   school 2513230 348   Worcester 251323002223 3480423 Sullivan Middle   Regular School No 2 06 08 2015   grade_7 95 69 175 0   50     0   17   198 208                       406 95 69 175 0   50     0   17   198 208                 406
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
936976 936976 MA Norfolk   school 2508370 199   Needham 250837001308 1990405 Pollard Middle   Regular School No 2 07 08 2016   grade_7 358 8 22 0   34     0   17   224 215                       439 358 8 22 0   34     0   17   224 215                 439
937240 937240 MA Middlesex   school 2508610 207   Newton 250861000314 2070315 F A Day Middle   Regular School No 2 06 08 2016   grade_7 200 20 18 1   32     0   17   144 144                       288 200 20 18 1   32     0   17   144 144                 288
1124803 1124803 MA Bristol   school 2504830 95   Fall River 250483000671 950320 Matthew J Kuss Middle   Regular School No Middle 06 08 2017   grade_7 151 15 51 2   13     0   17   112 137                       249 151 15 51 2   13     0   17   112 137                 249
1127530 1127530 MA Middlesex   school 2508610 207   Newton 250861000310 2070310 Charles E Brown Middle   Regular School No Middle 06 08 2017   grade_7 162 14 22 0   66     0   17   161 120                       281 162 14 22 0   66     0   17   161 120                 281
1369160 1369160 MA Middlesex   school 2508340 198   Natick 250834001305 1980310 Wilson Middle   Regular School No Middle 05 08 2020   grade_7 185 9 13 0   15     0   17   126 113 *                     239.0 185 9 13 0   15     0   17   126 113                 239
1372391 1372391 MA Worcester   school 2513230 348   Worcester 251323002223 3480423 Sullivan Middle   Regular School No Middle 06 08 2020   grade_7 134 67 168 2   42     0   17   226 204 *                     430.0 134 67 168 2   42     0   17   226 204                 430
1374300 1374300 MA Norfolk   school 2500556 3902   TEC Connections Academy Commonwealth Virtual School District 250055602817 39020900 TEC Connections Academy Commonwealth Virtual School   Regular School No Other KG 12 2020   grade_7 109 14 39 0   2     0   17   87 94 *                     181.0 109 14 39 0   2     0   17   87 94                 181
1675132 1675132 MA Middlesex   school 2506330 139   Hopkinton 250633000468 1390305 Hopkinton - Hopkinton Middle School   Regular School No Middle 06 08 2021   grade_7 194 3 15 1   67     0   17   149 148 *                     297.0 194 3 15 1   67     0   17   149 148                 297
1676332 1676332 MA Norfolk   school 2507980 189   Milton 250798001257 1890410 Milton - Charles S Pierce Middle   Regular School No Middle 06 08 2021   grade_7 206 41 18 1   24     0   17   151 156 *                     307.0 206 41 18 1   24     0   17   151 156                 307
1678441 1678441 MA Middlesex   school 2511340 288   Sudbury 251134001872 2880305 Sudbury - Ephraim Curtis Middle   Regular School No Middle 06 08 2021   grade_7 218 12 10 0   35     1   17   146 146 *                     293.0 218 12 10 0   35     1   17   146 146                 293
1679118 1679118 MA Hampden   school 2512510 332   West Springfield 251251001243 3320305 West Springfield - West Springfield Middle   Regular School No Middle 06 08 2021   grade_7 196 11 60 0   28     0   17   155 157 *                     312.0 196 11 60 0   28     0   17   155 157                 312
2041812 2041812 MA Middlesex   school 2503840 67   Concord 250384000522 670305 Concord Middle   Regular School No Middle 06 08 2019   grade_7 173 11 16 1   16     0   17   111 123                       234.0 173 11 16 1   16     0   17   111 123                 234
2042522 2042522 MA Worcester   school 2505130 103   Gardner 250513002431 1030405 Gardner Middle School   Regular School No Middle 05 07 2019   grade_7 127 8 36 0   1     0   17   93 96                       189.0 127 8 36 0   1     0   17   93 96                 189
2043655 2043655 MA Essex   school 2507110 163   Lynn 250711001063 1630405 Breed Middle School   Regular School No Middle 06 08 2019   grade_7 51 38 319 0   37     0   17   261 201                       462.0 51 38 319 0   37     0   17   261 201                 462
2044405 2044405 MA Bristol   school 2508430 201   New Bedford 250843001337 2010410 Normandin Middle School   Regular School No Middle 06 08 2019   grade_7 231 29 142 1   5     0   17   226 199                       425.0 231 29 142 1   5     0   17   226 199                 425
2044541 2044541 MA Middlesex   school 2508610 207   Newton 250861000314 2070315 F A Day Middle   Regular School No Middle 06 08 2019   grade_7 227 15 42 0   49     0   17   185 165                       350.0 227 15 42 0   49     0   17   185 165                 350
2046373 2046373 MA Bristol   school 2511520 293   Taunton 251152001662 2930315 Benjamin Friedman Middle   Regular School No Middle 05 07 2019   grade_7 185 24 26 0   3     1   17   129 127                       256.0 185 24 26 0   3     1   17   129 127                 256
2047122 2047122 MA Middlesex   school 2513110 344   Winchester 251311002167 3440305 McCall Middle   Regular School No Middle 06 08 2019   grade_7 281 3 14 2   60     0   17   176 200                       377.0 281 3 14 2   60     0   17   176 200                 377
2047461 2047461 MA Worcester   school 2513230 348   Worcester 251323002253 3480420 Worcester East Middle   Regular School No Middle 07 08 2019   grade_7 64 75 189 1   38     0   17   196 188                       384.0 64 75 189 1   38     0   17   196 188                 384
2234360 2234360 MA Middlesex   school 2508610 207   Newton 250861001042 2070320 Newton: Oak Hill Middle   Regular School No Middle 06 08 2018   grade_7 143 8 12 0   53     0   17   108 125                       233.0 143 8 12 0   53     0   17   108 125                 233
2237863 2237863 MA Worcester   school 2513230 348   Worcester 251323002253 3480420 Worcester: Worcester East Middle   Regular School No Middle 06 08 2018   grade_7 78 69 204 0   22     0   17   196 194                       390.0 78 69 204 0   22     0   17   196 194                 390
740270 740270 MA Bristol   school 2508430 201   New Bedford 250843001337 2010410 Normandin Middle School   Regular School No 2 06 08 2015   grade_7 212 29 97 1   1     2   16   183 175                       358 212 29 97 1   1     2   16   183 175                 358
743965 743965 MA Middlesex   school 2501710 600   Acton-Boxborough 250171000013 6000405 Raymond J Grey Junior High   Regular School No 2 07 08 2015   grade_7 262 7 10 2   131     0   16   220 208                       428 262 7 10 2   131     0   16   220 208                 428
935025 935025 MA Worcester   school 2504890 97   Fitchburg 250489001523 970048 Memorial Intermediate   Regular School No 2 05 08 2016   grade_7 53 11 80 0   7     0   16   73 94                       167 53 11 80 0   7     0   16   73 94                 167
939348 939348 MA Middlesex   school 2512210 315   Wayland 251221002502 3150305 Wayland Middle School   Regular School No 2 06 08 2016   grade_7 163 11 8 0   35     0   16   111 122                       233 163 11 8 0   35     0   16   111 122                 233
1126486 1126486 MA Essex   school 2507110 163   Lynn 250711001063 1630405 Breed Middle School   Regular School No Middle 06 08 2017   grade_7 65 43 261 5   57     0   16   226 221                       447 65 43 261 5   57     0   16   226 221                 447
1127377 1127377 MA Bristol   school 2508430 201   New Bedford 250843001337 2010410 Normandin Middle School   Regular School No Middle 06 08 2017   grade_7 204 31 135 0   4     0   16   205 185                       390 204 31 135 0   4     0   16   205 185                 390
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
1128879 1128879 MA Worcester   school 2510770 271   Shrewsbury 251077001825 2710030 Oak Middle School   Regular School No Middle 07 08 2017   grade_7 307 6 50 1   131     0   16   258 253                       511 307 6 50 1   131     0   16   258 253                 511
1129513 1129513 MA Norfolk   school 2511250 285   Stoughton 251125001865 2850405 O'Donnell Middle School   Regular School No Middle 06 08 2017   grade_7 138 55 17 0   14     1   16   133 108                       241 138 55 17 0   14     1   16   133 108                 241
1129560 1129560 MA Middlesex   school 2511340 288   Sudbury 251134001872 2880305 Ephraim Curtis Middle   Regular School No Middle 06 08 2017   grade_7 285 6 6 0   19     1   16   188 145                       333 285 6 6 0   19     1   16   188 145                 333
1366812 1366812 MA Bristol   school 2504020 72   Dartmouth 250402000541 720050 Dartmouth Middle   Regular School No Middle 06 08 2020   grade_7 274 3 11 0   2     1   16   173 134 *                     307.0 274 3 11 0   2     1   16   173 134                 307
1367191 1367191 MA Bristol   school 2504830 95   Fall River 250483000672 950315 Morton Middle   Regular School No Middle 06 08 2020   grade_7 127 19 46 1   6     1   16   99 117 *                     216.0 127 19 46 1   6     1   16   99 117                 216
1367386 1367386 MA Middlesex   school 2504980 100   Framingham 250498000733 1000310 Walsh Middle   Regular School No Middle 06 08 2020   grade_7 132 10 69 1   9     0   16   114 123 *                     237.0 132 10 69 1   9     0   16   114 123                 237
1368795 1368795 MA Barnstable   school 2507440 172   Mashpee 250744002638 1720020 Mashpee Middle School   Regular School No Middle 07 08 2020   grade_7 107 6 5 8   5     0   16   71 76 *                     147.0 107 6 5 8   5     0   16   71 76                 147
1369621 1369621 MA Bristol   school 2508730 212   North Attleborough 250873001207 2120305 North Attleborough Middle   Regular School No Middle 06 08 2020   grade_7 329 11 22 0   16     2   16   175 221 *                     396.0 329 11 22 0   16     2   16   175 221                 396
1672319 1672319 MA Barnstable   school 2502310 20   Barnstable 250231002678 200315 Barnstable - Barnstable Intermediate School   Regular School No Middle 06 07 2021   grade_7 225 24 73 4   8     1   16   189 162 *                     351.0 225 24 73 4   8     1   16   189 162                 351
1674422 1674422 MA Bristol   school 2504830 95   Fall River 250483000672 950315 Fall River - Morton Middle   Regular School No Middle 06 08 2021   grade_7 127 22 59 1   10     0   16   132 103 *                     235.0 127 22 59 1   10     0   16   132 103                 235
1679647 1679647 MA Worcester   school 2513230 348   Worcester 251323002202 3480405 Worcester - Burncoat Middle School   Regular School No Middle 07 08 2021   grade_7 118 56 128 0   19     0   16   161 176 *                     337.0 118 56 128 0   19     0   16   161 176                 337
1680287 1680287 MA Middlesex   school 2501710 600   Acton-Boxborough 250171000013 6000405 Acton-Boxborough - Raymond J Grey Junior High   Regular School No Middle 07 08 2021   grade_7 214 14 25 1   139     1   16   203 207 *                     410.0 214 14 25 1   139     1   16   203 207                 410
1680788 1680788 MA Essex   school 2507410 705   Masconomet 250741001097 7050405 Masconomet - Masconomet Regional Middle School   Regular School No Middle 07 08 2021   grade_7 274 3 11 0   9     1   16   149 165 *                     314.0 274 3 11 0   9     1   16   149 165                 314
2042263 2042263 MA Bristol   school 2504830 95   Fall River 250483000672 950315 Morton Middle   Regular School No Middle 06 08 2019   grade_7 106 14 49 0   10     0   16   111 84                       195.0 106 14 49 0   10     0   16   111 84                 195
2044402 2044402 MA Bristol   school 2508430 201   New Bedford 250843001334 2010405 Keith Middle School   Regular School No Middle 06 08 2019   grade_7 131 49 110 1   5     0   16   162 150                       312.0 131 49 110 1   5     0   16   162 150                 312
2046990 2046990 MA Norfolk   school 2512840 336   Weymouth 251284001840 3360020 Maria Weston Chapman Middle School   Regular School No Middle 06 08 2019   grade_7 325 37 48 2   24     1   16   222 231                       453.0 325 37 48 2   24     1   16   222 231                 453
2047464 2047464 MA Worcester   school 2513230 348   Worcester 251323002223 3480423 Sullivan Middle   Regular School No Middle 06 08 2019   grade_7 106 67 191 0   44     0   16   207 217                       424.0 106 67 191 0   44     0   16   207 217                 424
2047579 2047579 MA Middlesex   school 2500068 418   Christa McAuliffe Charter Public (District) 250006801746 4180305 Christa McAuliffe Charter Public School   Regular School Yes Middle 06 08 2019   grade_7 82 8 20 0   7     0   16   65 68                       133.0 82 8 20 0   7     0   16   65 68                 133
2231622 2231622 MA Bristol   school 2504830 95   Fall River 250483000671 950320 Fall River: Matthew J Kuss Middle   Regular School No Middle 06 08 2018   grade_7 157 26 61 0   7     0   16   136 131                       267.0 157 26 61 0   7     0   16   136 131                 267
2233306 2233306 MA Essex   school 2507110 163   Lynn 250711001063 1630405 Lynn: Breed Middle School   Regular School No Middle 06 08 2018   grade_7 67 37 264 1   49     0   16   216 218                       434.0 67 37 264 1   49     0   16   216 218                 434
2236863 2236863 MA Middlesex   school 2512210 315   Wayland 251221002502 3150305 Wayland: Wayland Middle School   Regular School No Middle 06 08 2018   grade_7 137 12 9 0   35     0   16   100 109                       209.0 137 12 9 0   35     0   16   100 109                 209
2237856 2237856 MA Worcester   school 2513230 348   Worcester 251323002202 3480405 Worcester: Burncoat Middle School   Regular School No Middle 07 08 2018   grade_7 108 64 138 0   9     0   16   153 182                       335.0 108 64 138 0   9     0   16   153 182                 335
2237867 2237867 MA Worcester   school 2513230 348   Worcester 251323002223 3480423 Worcester: Sullivan Middle   Regular School No Middle 06 08 2018   grade_7 92 67 210 1   38     0   16   226 198                       424.0 92 67 210 1   38     0   16   226 198                 424
739158 739158 MA Middlesex   school 2506840 155   Lexington 250684002551 1550305 Jonas Clarke Middle   Regular School No 2 06 08 2015   grade_7 144 5 8 0   108     0   15   139 141                       280 144 5 8 0   108     0   15   139 141                 280
739161 739161 MA Middlesex   school 2506840 155   Lexington 250684002552 1550310 Wm Diamond Middle   Regular School No 2 06 08 2015   grade_7 128 14 6 0   94     0   15   128 129                       257 128 14 6 0   94     0   15   128 129                 257
741018 741018 MA Plymouth   school 2509720 239   Plymouth 250972002531 2390405 Plymouth Commun Intermediate   Regular School No 2 06 08 2015   grade_7 306 8 11 0   4     0   15   159 185                       344 306 8 11 0   4     0   15   159 185                 344
743018 743018 MA Middlesex   school 2513110 344   Winchester 251311002167 3440305 McCall Middle   Regular School No 2 06 08 2015   grade_7 264 6 13 1   66     0   15   172 193                       365 264 6 13 1   66     0   15   172 193                 365
933738 933738 MA Suffolk   school 2502790 35   Boston 250279000203 350560 Boston Latin   Regular School No 3 07 12 2016   grade_7 191 21 42 2   120     0   15   189 202                       391 191 21 42 2   120     0   15   189 202                 391
934959 934959 MA Bristol   school 2504830 95   Fall River 250483000672 950315 Morton Middle   Regular School No 2 06 08 2016   grade_7 126 14 37 0   8     1   15   111 90                       201 126 14 37 0   8     1   15   111 90                 201
939285 939285 MA Plymouth   school 2512060 310   Wareham 251206002603 3100305 Wareham Middle   Regular School No 2 05 08 2016   grade_7 144 11 11 4   1     0   15   100 86                       186 144 11 11 4   1     0   15   100 86                 186
939688 939688 MA Norfolk   school 2512840 336   Weymouth 251284001840 3360020 Maria Weston Chapman Middle School   Regular School No 2 05 08 2016   grade_7 355 27 30 2   19     0   15   227 221                       448 355 27 30 2   19     0   15   227 221                 448
940180 940180 MA Worcester   school 2513230 348   Worcester 251323002223 3480423 Sullivan Middle   Regular School No 2 06 08 2016   grade_7 114 61 168 1   41     0   15   216 184                       400 114 61 168 1   41     0   15   216 184                 400
1122323 1122323 MA Barnstable   school 2502310 20   Barnstable 250231002678 200315 Barnstable Intermediate School   Regular School No Middle 06 07 2017   grade_7 302 34 36 2   8     0   15   200 197                       397 302 34 36 2   8     0   15   200 197                 397
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
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
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
1365095 1365095 MA Barnstable   school 2502310 20   Barnstable 250231002678 200315 Barnstable Intermediate School   Regular School No Middle 06 07 2020   grade_7 274 28 53 0   9     2   15   190 191 *                     381.0 274 28 53 0   9     2   15   190 191                 381
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
1370566 1370566 MA Norfolk   school 2510620 266   Sharon 251062002560 2660305 Sharon Middle   Regular School No Middle 06 08 2020   grade_7 164 8 11 0   87     0   15   131 154 *                     285.0 164 8 11 0   87     0   15   131 154                 285
1371606 1371606 MA Worcester   school 2512240 316   Webster 251224002849 3160315 Webster Middle School   Regular School No Middle 05 08 2020   grade_7 84 4 52 0   5     1   15   79 82 *                     161.0 84 4 52 0   5     1   15   79 82                 161
1674380 1674380 MA Bristol   school 2504830 95   Fall River 250483002811 950017 Fall River - Henry Lord Community School   Regular School No Elementary PK 08 2021   grade_7 38 6 25 0   3     0   15   52 35 *                     87.0 38 6 25 0   3     0   15   52 35                 87
1674502 1674502 MA Worcester   school 2504890 97   Fitchburg 250489002672 970315 Fitchburg - Arthur M Longsjo Middle School   Regular School No Middle 05 08 2021   grade_7 42 14 89 0   5     0   15   82 83 *                     165.0 42 14 89 0   5     0   15   82 83                 165
1676584 1676584 MA Bristol   school 2508430 201   New Bedford 250843001339 2010415 New Bedford - Roosevelt Middle School   Regular School No Middle 06 08 2021   grade_7 95 41 132 0   0     1   15   147 137 *                     284.0 95 41 132 0   0     1   15   147 137                 284
1678842 1678842 MA Middlesex   school 2512210 315   Wayland 251221002502 3150305 Wayland - Wayland Middle School   Regular School No Middle 06 08 2021   grade_7 127 15 13 0   32     1   15   96 107 *                     203.0 127 15 13 0   32     1   15   96 107                 203

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