enrollments

Data source: Big Local News · About: Big Local

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

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

grade ✖

  • grade_7 · 3,471 ✖
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
744434 744434 MA Norfolk   school 2506510 690   King Philip 250651000941 6900510 King Philip Middle School   Regular School No 2 07 08 2015   grade_7 384 2 16 0   7     0   11   218 202                       420 384 2 16 0   7     0   11   218 202                 420
1677139 1677139 MA Essex   school 2509360 229   Peabody 250936001495 2290305 Peabody - J Henry Higgins Middle   Regular School No Middle 06 08 2021   grade_7 379 17 77 1   13     1   12   246 254 *                     500.0 379 17 77 1   13     1   12   246 254                 500
742882 742882 MA Norfolk   school 2512840 336   Weymouth 251284001840 3360020 Maria Weston Chapman Middle School   Regular School No 2 07 08 2015   grade_7 375 19 39 2   30     0   9   241 233                       474 375 19 39 2   30     0   9   241 233                 474
2044969 2044969 MA Essex   school 2509360 229   Peabody 250936001495 2290305 J Henry Higgins Middle   Regular School No Middle 06 08 2019   grade_7 371 18 67 0   8     0   7   240 231                       471.0 371 18 67 0   8     0   7   240 231                 471
1130463 1130463 MA Norfolk   school 2512840 336   Weymouth 251284001840 3360020 Maria Weston Chapman Middle School   Regular School No Middle 05 08 2017   grade_7 370 34 29 0   23     1   22   248 231                       479 370 34 29 0   23     1   22   248 231                 479
2234864 2234864 MA Essex   school 2509360 229   Peabody 250936001495 2290305 Peabody: J Henry Higgins Middle   Regular School No Middle 06 08 2018   grade_7 367 20 77 0   8     0   7   246 233                       479.0 367 20 77 0   8     0   7   246 233                 479
1132283 1132283 MA Norfolk   school 2506510 690   King Philip 250651000941 6900510 King Philip Middle School   Regular School No Middle 07 08 2017   grade_7 364 6 14 0   8     0   8   217 182                       400 364 6 14 0   8     0   8   217 182                 400
1369198 1369198 MA Norfolk   school 2508370 199   Needham 250837001308 1990405 Pollard Middle   Regular School No Middle 07 08 2020   grade_7 363 8 30 0   35     0   23   226 233 *                     459.0 363 8 30 0   35     0   23   226 233                 459
1369896 1369896 MA Essex   school 2509360 229   Peabody 250936001495 2290305 J Henry Higgins Middle   Regular School No Middle 06 08 2020   grade_7 363 20 79 0   3     0   12   247 230 *                     477.0 363 20 79 0   3     0   12   247 230                 477
741562 741562 MA Worcester   school 2510770 271   Shrewsbury 251077001825 2710030 Oak Middle School   Regular School No 2 07 08 2015   grade_7 360 12 31 2   113     0   11   285 244                       529 360 12 31 2   113     0   11   285 244                 529
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
937668 937668 MA Essex   school 2509360 229   Peabody 250936001495 2290305 J Henry Higgins Middle   Regular School No 2 06 08 2016   grade_7 357 6 50 0   7     0   9   223 206                       429 357 6 50 0   7     0   9   223 206                 429
1676445 1676445 MA Norfolk   school 2508370 199   Needham 250837001308 1990405 Needham - Pollard Middle   Regular School No Middle 07 08 2021   grade_7 357 12 42 0   31     0   19   218 243 *                     461.0 357 12 42 0   31     0   19   218 243                 461
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
1127219 1127219 MA Norfolk   school 2508370 199   Needham 250837001308 1990405 Pollard Middle   Regular School No Middle 07 08 2017   grade_7 352 10 15 2   41     0   25   211 234                       445 352 10 15 2   41     0   25   211 234                 445
2048555 2048555 MA Norfolk   school 2506510 690   King Philip 250651000941 6900510 King Philip Middle School   Regular School No Middle 07 08 2019   grade_7 347 6 17 1   13     0   4   204 184                       388.0 347 6 17 1   13     0   4   204 184                 388
941260 941260 MA Norfolk   school 2506510 690   King Philip 250651000941 6900510 King Philip Middle School   Regular School No 2 07 08 2016   grade_7 343 9 9 0   7     0   4   191 181                       372 343 9 9 0   7     0   4   191 181                 372
740565 740565 MA Bristol   school 2508730 212   North Attleborough 250873001207 2120305 North Attleborough Middle   Regular School No 2 06 08 2015   grade_7 342 7 11 1   24     1   10   193 203                       396 342 7 11 1   24     1   10   193 203                 396
935508 935508 MA Plymouth   school 2506090 131   Hingham 250609000875 1310410 Hingham Middle School   Regular School No 2 06 08 2016   grade_7 342 5 4 0   8     0   6   173 192                       365 342 5 4 0   8     0   6   173 192                 365
1125487 1125487 MA Plymouth   school 2506090 131   Hingham 250609000875 1310410 Hingham Middle School   Regular School No Middle 06 08 2017   grade_7 340 4 11 0   8     1   11   195 180                       375 340 4 11 0   8     1   11   195 180                 375
1128042 1128042 MA Essex   school 2509360 229   Peabody 250936001495 2290305 J Henry Higgins Middle   Regular School No Middle 06 08 2017   grade_7 332 16 69 0   7     0   10   227 207                       434 332 16 69 0   7     0   10   227 207                 434
2044269 2044269 MA Norfolk   school 2508370 199   Needham 250837001308 1990405 Pollard Middle   Regular School No Middle 07 08 2019   grade_7 332 12 33 0   39     0   23   210 229                       439.0 332 12 33 0   39     0   23   210 229                 439
739715 739715 MA Plymouth   school 2507350 171   Marshfield 250735001143 1710310 Furnace Brook Middle   Regular School No 2 06 08 2015   grade_7 331 3 6 2   4     0   2   177 171                       348 331 3 6 2   4     0   2   177 171                 348
1126723 1126723 MA Plymouth   school 2507350 171   Marshfield 250735001143 1710310 Furnace Brook Middle   Regular School No Middle 06 08 2017   grade_7 330 0 9 0   2     0   6   196 151                       347 330 0 9 0   2     0   6   196 151                 347
1672197 1672197 MA Middlesex   school 2501980 10   Arlington 250198000063 100410 Arlington - Ottoson Middle   Regular School No Middle 07 08 2021   grade_7 330 21 37 0   41     0   27   237 219 *                     456.0 330 21 37 0   41     0   27   237 219                 456
1680756 1680756 MA Norfolk   school 2506510 690   King Philip 250651000941 6900510 King Philip - King Philip Middle School   Regular School No Middle 07 08 2021   grade_7 330 6 27 1   7     0   14   205 180 *                     385.0 330 6 27 1   7     0   14   205 180                 385
937357 937357 MA Essex   school 2508700 211   North Andover 250870001398 2110305 North Andover Middle   Regular School No 2 06 08 2016   grade_7 329 9 32 1   32     0   8   216 195                       411 329 9 32 1   32     0   8   216 195                 411
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
2040001 2040001 MA Middlesex   school 2501980 10   Arlington 250198000063 100410 Ottoson Middle   Regular School No Middle 07 08 2019   grade_7 329 10 29 0   52     2   19   205 236                       441.0 329 10 29 0   52     2   19   205 236                 441
2046827 2046827 MA Hampden   school 2512630 325   Westfield 251263001570 3250310 Westfield Middle School   Regular School No Middle 07 08 2019   grade_7 329 9 56 0   9     0   10   204 209                       413.0 329 9 56 0   9     0   10   204 209                 413
2233544 2233544 MA Plymouth   school 2507350 171   Marshfield 250735001143 1710310 Marshfield: Furnace Brook Middle   Regular School No Middle 06 08 2018   grade_7 328 1 8 0   4     1   3   183 161                       345.0 328 1 8 0   4     1   3   183 161                 345
2237291 2237291 MA Norfolk   school 2512840 336   Weymouth 251284001840 3360020 Weymouth: Maria Weston Chapman Middle School   Regular School No Middle 05 08 2018   grade_7 327 25 32 2   20     1   12   225 194                       419.0 327 25 32 2   20     1   12   225 194                 419
740841 740841 MA Essex   school 2509360 229   Peabody 250936001495 2290305 J Henry Higgins Middle   Regular School No 2 06 08 2015   grade_7 326 11 55 0   7     0   10   210 199                       409 326 11 55 0   7     0   10   210 199                 409
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
740131 740131 MA Norfolk   school 2508370 199   Needham 250837001308 1990405 Pollard Middle   Regular School No 2 07 08 2015   grade_7 324 13 19 0   33     0   14   201 202                       403 324 13 19 0   33     0   14   201 202                 403
2232303 2232303 MA Plymouth   school 2506090 131   Hingham 250609000875 1310410 Hingham: Hingham Middle School   Regular School No Middle 06 08 2018   grade_7 322 2 8 0   16     0   10   189 169                       358.0 322 2 8 0   16     0   10   189 169                 358
1364974 1364974 MA Middlesex   school 2501980 10   Arlington 250198000063 100410 Ottoson Middle   Regular School No Middle 07 08 2020   grade_7 321 15 33 1   53     1   31   247 207 *                     455.0 321 15 33 1   53     1   31   247 207                 455
2234037 2234037 MA Norfolk   school 2508370 199   Needham 250837001308 1990405 Needham: Pollard Middle   Regular School No Middle 07 08 2018   grade_7 320 6 31 0   30     0   21   193 215                       408.0 320 6 31 0   30     0   21   193 215                 408
936463 936463 MA Bristol   school 2507230 167   Mansfield 250723001112 1670035 Harold L Qualters Middle   Regular School No 2 06 08 2016   grade_7 314 13 11 0   19     0   12   187 182                       369 314 13 11 0   19     0   12   187 182                 369
2239114 2239114 MA Norfolk   school 2506510 690   King Philip 250651000941 6900510 King Philip: King Philip Middle School   Regular School No Middle 07 08 2018   grade_7 314 8 10 0   4     0   10   177 169                       346.0 314 8 10 0   4     0   10   177 169                 346
937395 937395 MA Bristol   school 2508730 212   North Attleborough 250873001207 2120305 North Attleborough Middle   Regular School No 2 06 08 2016   grade_7 313 7 13 0   20     0   10   193 170                       363 313 7 13 0   20     0   10   193 170                 363
939413 939413 MA Norfolk   school 2512270 317   Wellesley 251227002029 3170305 Wellesley Middle   Regular School No 2 06 08 2016   grade_7 313 13 20 0   47     0   23   215 201                       416 313 13 20 0   47     0   23   215 201                 416
1370073 1370073 MA Plymouth   school 2509720 239   Plymouth 250972002531 2390405 Plymouth Commun Intermediate   Regular School No Middle 06 08 2020   grade_7 311 12 26 0   4     1   11   181 184 *                     365.0 311 12 26 0   4     1   11   181 184                 365
1679214 1679214 MA Norfolk   school 2512840 336   Weymouth 251284002607 3360310 Weymouth - Abigail Adams Middle School   Regular School No Middle 05 08 2021   grade_7 311 28 63 1   31     0   22   230 226 *                     456.0 311 28 63 1   31     0   22   230 226                 456
1127717 1127717 MA Bristol   school 2508730 212   North Attleborough 250873001207 2120305 North Attleborough Middle   Regular School No Middle 06 08 2017   grade_7 310 6 19 2   23     0   12   193 179                       372 310 6 19 2   23     0   12   193 179                 372
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
936559 936559 MA Plymouth   school 2507350 171   Marshfield 250735001143 1710310 Furnace Brook Middle   Regular School No 2 06 08 2016   grade_7 309 0 13 1   4     0   3   160 170                       330 309 0 13 1   4     0   3   160 170                 330
1368785 1368785 MA Plymouth   school 2507350 171   Marshfield 250735001143 1710310 Furnace Brook Middle   Regular School No Middle 06 08 2020   grade_7 309 2 9 2   3     0   10   158 177 *                     335.0 309 2 9 2   3     0   10   158 177                 335
2239151 2239151 MA Essex   school 2507410 705   Masconomet 250741001097 7050405 Masconomet: Masconomet Regional Middle School   Regular School No Middle 07 08 2018   grade_7 309 2 6 0   8     0   8   168 165                       333.0 309 2 6 0   8     0   8   168 165                 333
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
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
744466 744466 MA Essex   school 2507410 705   Masconomet 250741001097 7050405 Masconomet Regional Middle School   Regular School No 2 07 08 2015   grade_7 306 0 8 1   5     0   7   162 165                       327 306 0 8 1   5     0   7   162 165                 327
939827 939827 MA Middlesex   school 2513110 344   Winchester 251311002167 3440305 McCall Middle   Regular School No 2 06 08 2016   grade_7 306 2 12 1   50     0   9   180 200                       380 306 2 12 1   50     0   9   180 200                 380
1373492 1373492 MA Norfolk   school 2506510 690   King Philip 250651000941 6900510 King Philip Middle School   Regular School No Middle 07 08 2020   grade_7 306 6 15 1   11     0   13   181 171 *                     352.0 306 6 15 1   11     0   13   181 171                 352
739618 739618 MA Bristol   school 2507230 167   Mansfield 250723001112 1670035 Harold L Qualters Middle   Regular School No 2 06 08 2015   grade_7 305 8 12 0   16     0   10   188 163                       351 305 8 12 0   16     0   10   188 163                 351
2042826 2042826 MA Plymouth   school 2506090 131   Hingham 250609000875 1310410 Hingham Middle School   Regular School No Middle 06 08 2019   grade_7 304 7 9 0   6     0   13   175 164                       339.0 304 7 9 0   6     0   13   175 164                 339
738662 738662 MA Plymouth   school 2506090 131   Hingham 250609000875 1310410 Hingham Middle School   Regular School No 2 06 08 2015   grade_7 303 1 14 0   8     0   9   176 159                       335 303 1 14 0   8     0   9   176 159                 335
932726 932726 MA Middlesex   school 2501980 10   Arlington 250198000063 100410 Ottoson Middle   Regular School No 2 06 08 2016   grade_7 303 15 22 0   28     0   14   189 193                       382 303 15 22 0   28     0   14   189 193                 382
934588 934588 MA Bristol   school 2504020 72   Dartmouth 250402000541 720050 Dartmouth Middle   Regular School No 2 06 08 2016   grade_7 303 6 6 1   1     0   13   156 174                       330 303 6 6 1   1     0   13   156 174                 330
1122176 1122176 MA Middlesex   school 2501980 10   Arlington 250198000063 100410 Ottoson Middle   Regular School No Middle 06 08 2017   grade_7 302 16 22 0   48     0   21   201 208                       409 302 16 22 0   48     0   21   201 208                 409
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
2044694 2044694 MA Bristol   school 2508730 212   North Attleborough 250873001207 2120305 North Attleborough Middle   Regular School No Middle 06 08 2019   grade_7 302 10 18 0   19     0   15   175 189                       364.0 302 10 18 0   19     0   15   175 189                 364
1124357 1124357 MA Bristol   school 2504020 72   Dartmouth 250402000541 720050 Dartmouth Middle   Regular School No Middle 06 08 2017   grade_7 301 4 8 0   1     0   20   167 167                       334 301 4 8 0   1     0   20   167 167                 334
2228982 2228982 MA Middlesex   school 2501980 10   Arlington 250198000063 100410 Arlington: Ottoson Middle   Regular School No Middle 06 08 2018   grade_7 301 22 20 0   41     0   31   180 235                       415.0 301 22 20 0   41     0   31   180 235                 415
941291 941291 MA Essex   school 2507410 705   Masconomet 250741001097 7050405 Masconomet Regional Middle School   Regular School No 2 07 08 2016   grade_7 299 2 4 1   14     1   9   154 176                       330 299 2 4 1   14     1   9   154 176                 330
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
744774 744774 MA Plymouth   school 2510830 760   Silver Lake 251083001721 7600405 Silver Lake Regional Middle School   Regular School No 2 06 08 2015   grade_7 298 5 2 0   5     1   2   157 156                       313 298 5 2 0   5     1   2   157 156                 313
737729 737729 MA Bristol   school 2504020 72   Dartmouth 250402000541 720050 Dartmouth Middle   Regular School No 2 06 08 2015   grade_7 297 3 8 1   12     0   7   187 141                       328 297 3 8 1   12     0   7   187 141                 328
1674990 1674990 MA Plymouth   school 2506090 131   Hingham 250609000875 1310410 Hingham - Hingham Middle School   Regular School No Middle 06 08 2021   grade_7 297 5 12 0   15     0   7   183 153 *                     336.0 297 5 12 0   15     0   7   183 153                 336
2045670 2045670 MA Worcester   school 2510770 271   Shrewsbury 251077001825 2710030 Oak Middle School   Regular School No Middle 07 08 2019   grade_7 297 20 34 1   144     0   15   270 241                       511.0 297 20 34 1   144     0   15   270 241                 511
742604 742604 MA Norfolk   school 2512270 317   Wellesley 251227002029 3170305 Wellesley Middle   Regular School No 2 06 08 2015   grade_7 296 21 20 0   32     0   14   188 195                       383 296 21 20 0   32     0   14   188 195                 383
938944 938944 MA Middlesex   school 2511340 288   Sudbury 251134001872 2880305 Ephraim Curtis Middle   Regular School No 2 06 08 2016   grade_7 296 8 13 0   17     0   5   168 171                       339 296 8 13 0   17     0   5   168 171                 339
742271 742271 MA Middlesex   school 2511580 295   Tewksbury 251158000366 2950305 John W. Wynn Middle   Regular School No 2 07 08 2015   grade_7 295 2 10 0   7     1   1   172 144                       316 295 2 10 0   7     1   1   172 144                 316
941600 941600 MA Plymouth   school 2510830 760   Silver Lake 251083001721 7600405 Silver Lake Regional Middle School   Regular School No 2 06 08 2016   grade_7 295 3 1 0   5     0   1   146 159                       305 295 3 1 0   5     0   1   146 159                 305
1128250 1128250 MA Plymouth   school 2509720 239   Plymouth 250972002531 2390405 Plymouth Commun Intermediate   Regular School No Middle 06 08 2017   grade_7 295 8 8 0   3     0   14   186 142                       328 295 8 8 0   3     0   14   186 142                 328
2235700 2235700 MA Worcester   school 2510770 271   Shrewsbury 251077001825 2710030 Shrewsbury: Oak Middle School   Regular School No Middle 07 08 2018   grade_7 295 15 39 1   131     0   12   237 256                       493.0 295 15 39 1   131     0   12   237 256                 493
735971 735971 MA Barnstable   school 2502310 20   Barnstable 250231002678 200315 Barnstable Intermediate School   Regular School No 2 06 07 2015   grade_7 292 29 38 4   13     1   11   185 203                       388 292 29 38 4   13     1   11   185 203                 388
938367 938367 MA Worcester   school 2510770 271   Shrewsbury 251077001825 2710030 Oak Middle School   Regular School No 2 07 08 2016   grade_7 292 11 31 2   126     0   18   247 233                       480 292 11 31 2   126     0   18   247 233                 480
1127671 1127671 MA Essex   school 2508700 211   North Andover 250870001398 2110305 North Andover Middle   Regular School No Middle 06 08 2017   grade_7 291 15 34 0   29     1   5   194 181                       375 291 15 34 0   29     1   5   194 181                 375
1122488 1122488 MA Essex   school 2502640 30   Beverly 250264000165 300305 Briscoe Middle   Regular School No Middle 06 08 2017   grade_7 290 12 28 0   8     0   11   199 150                       349 290 12 28 0   8     0   11   199 150                 349
1132320 1132320 MA Essex   school 2507410 705   Masconomet 250741001097 7050405 Masconomet Regional Middle School   Regular School No Middle 07 08 2017   grade_7 290 1 9 0   10     0   6   149 167                       316 290 1 9 0   10     0   6   149 167                 316
2236939 2236939 MA Norfolk   school 2512270 317   Wellesley 251227002029 3170305 Wellesley: Wellesley Middle   Regular School No Middle 06 08 2018   grade_7 288 8 18 0   51     0   28   214 179                       393.0 288 8 18 0   51     0   28   214 179                 393
1129730 1129730 MA Middlesex   school 2511580 295   Tewksbury 251158000366 2950305 John W. Wynn Middle   Regular School No Middle 07 08 2017   grade_7 286 6 8 0   10     0   2   132 180                       312 286 6 8 0   10     0   2   132 180                 312
1371753 1371753 MA Hampden   school 2512630 325   Westfield 251263001570 3250310 Westfield Middle School   Regular School No Middle 07 08 2020   grade_7 286 5 73 0   9     0   10   188 195 *                     383.0 286 5 73 0   9     0   10   188 195                 383
1672443 1672443 MA Essex   school 2502640 30   Beverly 250264000165 300305 Beverly - Beverly Middle School   Regular School No Middle 05 08 2021   grade_7 286 11 52 0   9     1   14   192 181 *                     373.0 286 11 52 0   9     1   14   192 181                 373
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
2044656 2044656 MA Essex   school 2508700 211   North Andover 250870001398 2110305 North Andover Middle   Regular School No Middle 06 08 2019   grade_7 284 13 35 2   26     0   6   182 184                       366.0 284 13 35 2   26     0   6   182 184                 366
2234539 2234539 MA Bristol   school 2508730 212   North Attleborough 250873001207 2120305 North Attleborough: North Attleborough Middle   Regular School No Middle 06 08 2018   grade_7 284 10 14 1   25     1   11   183 163                       346.0 284 10 14 1   25     1   11   183 163                 346
740522 740522 MA Essex   school 2508700 211   North Andover 250870001398 2110305 North Andover Middle   Regular School No 2 06 08 2015   grade_7 281 13 32 0   30     3   4   173 190                       363 281 13 32 0   30     3   4   173 190                 363
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
2048585 2048585 MA Essex   school 2507410 705   Masconomet 250741001097 7050405 Masconomet Regional Middle School   Regular School No Middle 07 08 2019   grade_7 281 0 9 0   13     0   6   142 167                       309.0 281 0 9 0   13     0   6   142 167                 309
737820 737820 MA Middlesex   school 2504320 79   Dracut 250432001625 790410 Justus C. Richardson Middle School   Regular School No 2 06 08 2015   grade_7 280 16 22 1   12     0   7   182 156                       338 280 16 22 1   12     0   7   182 156                 338
937847 937847 MA Plymouth   school 2509720 239   Plymouth 250972002531 2390405 Plymouth Commun Intermediate   Regular School No 2 06 08 2016   grade_7 280 7 10 1   5     0   19   160 162                       322 280 7 10 1   5     0   19   160 162                 322
1365221 1365221 MA Essex   school 2502640 30   Beverly 250264000165 300305 Beverly Middle School   Regular School No Middle 05 08 2020   grade_7 280 9 55 0   12     0   7   189 174 *                     363.0 280 9 55 0   12     0   7   189 174                 363
2233430 2233430 MA Bristol   school 2507230 167   Mansfield 250723001112 1670035 Mansfield: Harold L Qualters Middle   Regular School No Middle 06 08 2018   grade_7 280 5 15 0   12     0   14   175 151                       326.0 280 5 15 0   12     0   14   175 151                 326
2234493 2234493 MA Essex   school 2508700 211   North Andover 250870001398 2110305 North Andover: North Andover Middle   Regular School No Middle 06 08 2018   grade_7 280 8 33 1   21     1   10   186 168                       354.0 280 8 33 1   21     1   10   186 168                 354
1679004 1679004 MA Hampden   school 2512630 325   Westfield 251263001570 3250310 Westfield - Westfield Middle School   Regular School No Middle 07 08 2021   grade_7 279 9 71 1   14     0   10   205 179 *                     384.0 279 9 71 1   14     0   10   205 179                 384
2041882 2041882 MA Bristol   school 2504020 72   Dartmouth 250402000541 720050 Dartmouth Middle   Regular School No Middle 06 08 2019   grade_7 279 5 15 0   1     0   20   174 146                       320.0 279 5 15 0   1     0   20   174 146                 320
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
2237461 2237461 MA Middlesex   school 2513110 344   Winchester 251311002167 3440305 Winchester: McCall Middle   Regular School No Middle 06 08 2018   grade_7 278 5 13 1   67     0   13   195 182                       377.0 278 5 13 1   67     0   13   195 182                 377

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