enrollments

Data source: Big Local News · About: Big Local

4,038 rows where grade = "grade_6" and state = "MA" sorted by total_int descending

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

grade ✖

  • grade_6 · 4,038 ✖
Link rowid state county county_state_id admin_level district_nces_id district_state_id district_state_type district school_nces_id school_state_id school school_state_type ccd_school_type ccd_charter_school ccd_school_lvl ccd_school_low_grade ccd_school_high_grade year term grade white black hispanic native_american native_american_alaskan_native asian native_hawaiian asian_pacific_islander native_hawaiian_pacific_islander pacific_islander multiracial unknown_race male female non_binary unknown_gender ell ell_percent homeless homeless_percent low_income free_and_reduced free_and_reduced_percent disability section_504 total white_int black_int hispanic_int native_american_int native_american_alaskan_native_int asian_int native_hawaiian_int asian_pacific_islander_int native_hawaiian_pacific_islander_int pacific_islander_int multiracial_int unknown_race_int male_int female_int non_binary_int unknown_gender_int ell_int homeless_int low_income_int free_and_reduced_int disability_int section_504_int total_int ▲
2043654 2043654 MA Essex   school 2507110 163   Lynn 250711001063 1630405 Breed Middle School   Regular School No Middle 06 08 2019   grade_6 63 55 348 1   49     0   13   263 266                       529.0 63 55 348 1   49     0   13   263 266                 529
1368586 1368586 MA Essex   school 2507110 163   Lynn 250711001063 1630405 Breed Middle School   Regular School No Middle 06 08 2020   grade_6 36 48 359 1   54     0   19   260 257 *                     517.0 36 48 359 1   54     0   19   260 257                 517
1369895 1369895 MA Essex   school 2509360 229   Peabody 250936001495 2290305 J Henry Higgins Middle   Regular School No Middle 06 08 2020   grade_6 388 15 76 0   14     1   11   248 257 *                     505.0 388 15 76 0   14     1   11   248 257                 505
1370604 1370604 MA Worcester   school 2510770 271   Shrewsbury 251077001716 2710305 Sherwood Middle School   Regular School No Middle 05 06 2020   grade_6 257 10 43 2   171     0   21   253 251 *                     504.0 257 10 43 2   171     0   21   253 251                 504
2235712 2235712 MA Worcester   school 2510770 271   Shrewsbury 251077001716 2710305 Shrewsbury: Sherwood Middle School   Regular School No Middle 05 06 2018   grade_6 291 15 35 1   143     0   18   263 240                       503.0 291 15 35 1   143     0   18   263 240                 503
938376 938376 MA Worcester   school 2510770 271   Shrewsbury 251077001716 2710305 Sherwood Middle School   Regular School No 2 05 06 2016   grade_6 302 8 43 2   129     0   16   254 246                       500 302 8 43 2   129     0   16   254 246                 500
1369200 1369200 MA Norfolk   school 2508370 199   Needham 250837002690 1990410 High Rock School   Regular School No Middle 06 06 2020   grade_6 396 14 43 0   26     0   20   245 254 *                     499.0 396 14 43 0   26     0   20   245 254                 499
939726 939726 MA Norfolk   school 2512840 336   Weymouth 251284002607 3360310 Abigail Adams Middle School   Regular School No 2 05 06 2016   grade_6 389 30 33 0   22     1   23   267 231                       498 389 30 33 0   22     1   23   267 231                 498
1368583 1368583 MA Essex   school 2507110 163   Lynn 250711000301 1630305 Thurgood Marshall Mid   Regular School No Middle 06 08 2020   grade_6 43 57 350 1   27     0   19   255 242 *                     497.0 43 57 350 1   27     0   19   255 242                 497
1677855 1677855 MA Worcester   school 2510770 271   Shrewsbury 251077001716 2710305 Shrewsbury - Sherwood Middle School   Regular School No Middle 05 06 2021   grade_6 240 13 53 2   159     0   24   236 255 *                     491.0 240 13 53 2   159     0   24   236 255                 491
1128891 1128891 MA Worcester   school 2510770 271   Shrewsbury 251077001716 2710305 Sherwood Middle School   Regular School No Middle 05 06 2017   grade_6 300 11 35 1   130     0   13   240 250                       490 300 11 35 1   130     0   13   240 250                 490
1364973 1364973 MA Middlesex   school 2501980 10   Arlington 250198002889 100305 Gibbs School   Regular School No Middle 06 06 2020   grade_6 356 20 40 0   40     0   30   255 231 *                     486.0 356 20 40 0   40     0   30   255 231                 486
1672196 1672196 MA Middlesex   school 2501980 10   Arlington 250198002889 100305 Arlington - Gibbs School   Regular School No Middle 06 06 2021   grade_6 334 21 31 2   60     1   34   260 223 *                     483.0 334 21 31 2   60     1   34   260 223                 483
2044968 2044968 MA Essex   school 2509360 229   Peabody 250936001495 2290305 J Henry Higgins Middle   Regular School No Middle 06 08 2019   grade_6 377 20 66 0   4     0   10   248 229                       477.0 377 20 66 0   4     0   10   248 229                 477
1128041 1128041 MA Essex   school 2509360 229   Peabody 250936001495 2290305 J Henry Higgins Middle   Regular School No Middle 06 08 2017   grade_6 371 21 66 0   8     0   10   248 228                       476 371 21 66 0   8     0   10   248 228                 476
1677138 1677138 MA Essex   school 2509360 229   Peabody 250936001495 2290305 Peabody - J Henry Higgins Middle   Regular School No Middle 06 08 2021   grade_6 344 26 86 0   9     0   11   241 235 *                     476.0 344 26 86 0   9     0   11   241 235                 476
1675827 1675827 MA Essex   school 2507110 163   Lynn 250711001063 1630405 Lynn - Breed Middle School   Regular School No Middle 06 08 2021   grade_6 52 39 329 1   37     0   17   257 217 *                     475.0 52 39 329 1   37     0   17   257 217                 475
742920 742920 MA Norfolk   school 2512840 336   Weymouth 251284002607 3360310 Abigail Adams Middle School   Regular School No 2 05 06 2015   grade_6 369 31 31 2   20     0   17   237 233                       470 369 31 31 2   20     0   17   237 233                 470
2233305 2233305 MA Essex   school 2507110 163   Lynn 250711001063 1630405 Lynn: Breed Middle School   Regular School No Middle 06 08 2018   grade_6 49 45 316 0   41     0   19   265 205                       470.0 49 45 316 0   41     0   19   265 205                 470
741571 741571 MA Worcester   school 2510770 271   Shrewsbury 251077001716 2710305 Sherwood Middle School   Regular School No 2 05 06 2015   grade_6 288 11 30 2   122     0   16   237 232                       469 288 11 30 2   122     0   16   237 232                 469
1675824 1675824 MA Essex   school 2507110 163   Lynn 250711000301 1630305 Lynn - Thurgood Marshall Mid   Regular School No Middle 06 08 2021   grade_6 38 46 336 1   34     1   13   233 236 *                     469.0 38 46 336 1   34     1   13   233 236                 469
2237337 2237337 MA Norfolk   school 2512840 336   Weymouth 251284002607 3360310 Weymouth: Abigail Adams Middle School   Regular School No Middle 05 06 2018   grade_6 352 31 46 2   22     1   15   229 240                       469.0 352 31 46 2   22     1   15   229 240                 469
2045679 2045679 MA Worcester   school 2510770 271   Shrewsbury 251077001716 2710305 Sherwood Middle School   Regular School No Middle 05 06 2019   grade_6 236 15 50 1   149     0   17   248 220                       468.0 236 15 50 1   149     0   17   248 220                 468
1371953 1371953 MA Norfolk   school 2512840 336   Weymouth 251284002607 3360310 Abigail Adams Middle School   Regular School No Middle 05 08 2020   grade_6 323 24 58 1   33     0   24   236 227 *                     463.0 323 24 58 1   33     0   24   236 227                 463
2040000 2040000 MA Middlesex   school 2501980 10   Arlington 250198002889 100305 Gibbs School   Regular School No Middle 06 06 2019   grade_6 321 15 34 1   61     1   30   250 213                       463.0 321 15 34 1   61     1   30   250 213                 463
1130509 1130509 MA Norfolk   school 2512840 336   Weymouth 251284002607 3360310 Abigail Adams Middle School   Regular School No Middle 05 06 2017   grade_6 365 24 33 2   20     1   13   241 217                       458 365 24 33 2   20     1   13   241 217                 458
2234863 2234863 MA Essex   school 2509360 229   Peabody 250936001495 2290305 Peabody: J Henry Higgins Middle   Regular School No Middle 06 08 2018   grade_6 360 16 65 0   7     0   9   238 219                       457.0 360 16 65 0   7     0   9   238 219                 457
2233301 2233301 MA Essex   school 2507110 163   Lynn 250711000301 1630305 Lynn: Thurgood Marshall Mid   Regular School No Middle 06 08 2018   grade_6 45 45 317 0   33     0   15   230 225                       455.0 45 45 317 0   33     0   15   230 225                 455
1126485 1126485 MA Essex   school 2507110 163   Lynn 250711001063 1630405 Breed Middle School   Regular School No Middle 06 08 2017   grade_6 78 43 266 1   47     0   17   233 219                       452 78 43 266 1   47     0   17   233 219                 452
936978 936978 MA Norfolk   school 2508370 199   Needham 250837002690 1990410 High Rock School   Regular School No 2 06 06 2016   grade_6 360 11 13 2   39     0   26   218 233                       451 360 11 13 2   39     0   26   218 233                 451
2044271 2044271 MA Norfolk   school 2508370 199   Needham 250837002690 1990410 High Rock School   Regular School No Middle 06 06 2019   grade_6 359 9 28 0   30     0   24   224 226                       450.0 359 9 28 0   30     0   24   224 226                 450
2234040 2234040 MA Norfolk   school 2508370 199   Needham 250837002690 1990410 Needham: High Rock School   Regular School No Middle 06 06 2018   grade_6 339 11 30 0   45     0   25   221 229                       450.0 339 11 30 0   45     0   25   221 229                 450
2043651 2043651 MA Essex   school 2507110 163   Lynn 250711000301 1630305 Thurgood Marshall Mid   Regular School No Middle 06 08 2019   grade_6 39 48 322 0   33     0   7   232 217                       449.0 39 48 322 0   33     0   7   232 217                 449
936359 936359 MA Essex   school 2507110 163   Lynn 250711001063 1630405 Breed Middle School   Regular School No 2 06 08 2016   grade_6 67 46 254 5   59     0   17   225 223                       448 67 46 254 5   59     0   17   225 223                 448
740133 740133 MA Norfolk   school 2508370 199   Needham 250837002690 1990410 High Rock School   Regular School No 2 06 06 2015   grade_6 370 7 18 0   34     0   18   225 222                       447 370 7 18 0   34     0   18   225 222                 447
937667 937667 MA Essex   school 2509360 229   Peabody 250936001495 2290305 J Henry Higgins Middle   Regular School No 2 06 08 2016   grade_6 342 17 68 0   7     0   9   227 216                       443 342 17 68 0   7     0   9   227 216                 443
2228981 2228981 MA Middlesex   school 2501980 10   Arlington 250198000063 100410 Arlington: Ottoson Middle   Regular School No Middle 06 08 2018   grade_6 328 11 28 0   52     1   22   204 238                       442.0 328 11 28 0   52     1   22   204 238                 442
2234195 2234195 MA Bristol   school 2508430 201   New Bedford 250843001337 2010410 New Bedford: Normandin Middle School   Regular School No Middle 06 08 2018   grade_6 242 25 144 2   7     0   20   228 212                       440.0 242 25 144 2   7     0   20   228 212                 440
2047028 2047028 MA Norfolk   school 2512840 336   Weymouth 251284002607 3360310 Abigail Adams Middle School   Regular School No Middle 05 06 2019   grade_6 319 32 46 1   17     0   16   211 220                       431.0 319 32 46 1   17     0   16   211 220                 431
740840 740840 MA Essex   school 2509360 229   Peabody 250936001495 2290305 J Henry Higgins Middle   Regular School No 2 06 08 2015   grade_6 357 4 52 0   5     0   8   230 196                       426 357 4 52 0   5     0   8   230 196                 426
1679213 1679213 MA Norfolk   school 2512840 336   Weymouth 251284002607 3360310 Weymouth - Abigail Adams Middle School   Regular School No Middle 05 08 2021   grade_6 281 37 60 1   27     1   17   187 237 *                     424.0 281 37 60 1   27     1   17   187 237                 424
742603 742603 MA Norfolk   school 2512270 317   Wellesley 251227002029 3170305 Wellesley Middle   Regular School No 2 06 08 2015   grade_6 320 14 21 0   43     0   25   227 196                       423 320 14 21 0   43     0   25   227 196                 423
1122175 1122175 MA Middlesex   school 2501980 10   Arlington 250198000063 100410 Ottoson Middle   Regular School No Middle 06 08 2017   grade_6 306 21 22 0   45     0   27   188 233                       421 306 21 22 0   45     0   27   188 233                 421
1127222 1127222 MA Norfolk   school 2508370 199   Needham 250837002690 1990410 High Rock School   Regular School No Middle 06 06 2017   grade_6 331 8 28 0   30     0   24   200 221                       421 331 8 28 0   30     0   24   200 221                 421
937107 937107 MA Bristol   school 2508430 201   New Bedford 250843001337 2010410 Normandin Middle School   Regular School No 2 06 08 2016   grade_6 221 41 133 0   4     0   17   229 187                       416 221 41 133 0   4     0   17   229 187                 416
739511 739511 MA Essex   school 2507110 163   Lynn 250711001063 1630405 Breed Middle School   Regular School No 2 06 08 2015   grade_6 66 43 242 1   46     0   12   225 185                       410 66 43 242 1   46     0   12   225 185                 410
740521 740521 MA Essex   school 2508700 211   North Andover 250870001398 2110305 North Andover Middle   Regular School No 2 06 08 2015   grade_6 332 7 32 1   31     0   6   220 189                       409 332 7 32 1   31     0   6   220 189                 409
932725 932725 MA Middlesex   school 2501980 10   Arlington 250198000063 100410 Ottoson Middle   Regular School No 2 06 08 2016   grade_6 302 17 18 0   50     0   22   193 216                       409 302 17 18 0   50     0   22   193 216                 409
1371656 1371656 MA Norfolk   school 2512270 317   Wellesley 251227002029 3170305 Wellesley Middle   Regular School No Middle 06 08 2020   grade_6 287 16 20 0   59     0   26   190 218 *                     408.0 287 16 20 0   59     0   26   190 218                 408
1127376 1127376 MA Bristol   school 2508430 201   New Bedford 250843001337 2010410 Normandin Middle School   Regular School No Middle 06 08 2017   grade_6 205 32 132 3   6     0   28   211 195                       406 205 32 132 3   6     0   28   211 195                 406
936356 936356 MA Essex   school 2507110 163   Lynn 250711000301 1630305 Thurgood Marshall Mid   Regular School No 2 06 08 2016   grade_6 52 37 259 5   37     0   15   213 192                       405 52 37 259 5   37     0   15   213 192                 405
1372047 1372047 MA Middlesex   school 2513110 344   Winchester 251311002167 3440305 McCall Middle   Regular School No Middle 06 08 2020   grade_6 285 5 10 0   75     0   29   218 186 *                     404.0 285 5 10 0   75     0   29   218 186                 404
2044404 2044404 MA Bristol   school 2508430 201   New Bedford 250843001337 2010410 Normandin Middle School   Regular School No Middle 06 08 2019   grade_6 179 38 150 3   2     0   30   218 184                       402.0 179 38 150 3   2     0   30   218 184                 402
2040120 2040120 MA Barnstable   school 2502310 20   Barnstable 250231002678 200315 Barnstable Intermediate School   Regular School No Middle 06 07 2019   grade_6 288 31 56 0   10     2   12   201 198                       399.0 288 31 56 0   10     2   12   201 198                 399
1371752 1371752 MA Hampden   school 2512630 325   Westfield 251263002894 3250075 Westfield Intermediate School   Regular School No Middle 05 06 2020   grade_6 294 11 67 1   15     0   10   212 186 *                     398.0 294 11 67 1   15     0   10   212 186                 398
735849 735849 MA Middlesex   school 2501980 10   Arlington 250198000063 100410 Ottoson Middle   Regular School No 2 06 08 2015   grade_6 308 16 28 0   31     0   14   193 204                       397 308 16 28 0   31     0   14   193 204                 397
1676447 1676447 MA Norfolk   school 2508370 199   Needham 250837002690 1990410 Needham - High Rock School   Regular School No Middle 06 06 2021   grade_6 293 22 20 0   40     1   18   198 196 *                     394.0 293 22 20 0   40     1   18   198 196                 394
2046729 2046729 MA Norfolk   school 2512270 317   Wellesley 251227002029 3170305 Wellesley Middle   Regular School No Middle 06 08 2019   grade_6 264 22 15 0   65     0   28   180 213                       394.0 264 22 15 0   65     0   28   180 213                 394
1130123 1130123 MA Norfolk   school 2512270 317   Wellesley 251227002029 3170305 Wellesley Middle   Regular School No Middle 06 08 2017   grade_6 291 9 18 0   46     0   28   215 177                       392 291 9 18 0   46     0   28   215 177                 392
1365220 1365220 MA Essex   school 2502640 30   Beverly 250264000165 300305 Beverly Middle School   Regular School No Middle 05 08 2020   grade_6 295 13 58 0   8     1   17   205 187 *                     392.0 295 13 58 0   8     1   17   205 187                 392
2044693 2044693 MA Bristol   school 2508730 212   North Attleborough 250873001207 2120305 North Attleborough Middle   Regular School No Middle 06 08 2019   grade_6 328 8 20 1   17     2   15   170 221                       391.0 328 8 20 1   17     2   15   170 221                 391
738661 738661 MA Plymouth   school 2506090 131   Hingham 250609000875 1310410 Hingham Middle School   Regular School No 2 06 08 2015   grade_6 366 5 3 0   9     0   5   188 200                       388 366 5 3 0   9     0   5   188 200                 388
2046826 2046826 MA Hampden   school 2512630 325   Westfield 251263002894 3250075 Westfield Intermediate School   Regular School No Middle 05 06 2019   grade_6 293 7 67 1   11     0   9   184 204                       388.0 293 7 67 1   11     0   9   184 204                 388
1126481 1126481 MA Essex   school 2507110 163   Lynn 250711000301 1630305 Thurgood Marshall Mid   Regular School No Middle 06 08 2017   grade_6 42 36 260 1   34     0   14   188 199                       387 42 36 260 1   34     0   14   188 199                 387
1130632 1130632 MA Middlesex   school 2513110 344   Winchester 251311002167 3440305 McCall Middle   Regular School No Middle 06 08 2017   grade_6 283 6 12 1   68     0   16   200 186                       386 283 6 12 1   68     0   16   200 186                 386
1365176 1365176 MA Middlesex   school 2502490 26   Belmont 250249000149 260305 Winthrop L Chenery Middle   Regular School No Middle 05 08 2020   grade_6 225 12 23 1   96     1   27   193 192 *                     385.0 225 12 23 1   96     1   27   193 192                 385
937356 937356 MA Essex   school 2508700 211   North Andover 250870001398 2110305 North Andover Middle   Regular School No 2 06 08 2016   grade_6 298 18 34 0   28     1   4   197 186                       383 298 18 34 0   28     1   4   197 186                 383
2043814 2043814 MA Middlesex   school 2507320 170   Marlborough 250732002639 1700045 1 LT Charles W. Whitcomb School   Regular School No Middle 05 08 2019   grade_6 166 13 186 0   7     0   9   191 190                       381.0 166 13 186 0   7     0   9   191 190                 381
739617 739617 MA Bristol   school 2507230 167   Mansfield 250723001112 1670035 Harold L Qualters Middle   Regular School No 2 06 08 2015   grade_6 325 15 8 0   19     0   12   193 186                       379 325 15 8 0   19     0   12   193 186                 379
2236938 2236938 MA Norfolk   school 2512270 317   Wellesley 251227002029 3170305 Wellesley: Wellesley Middle   Regular School No Middle 06 08 2018   grade_6 270 14 33 0   45     0   17   184 195                       379.0 270 14 33 0   45     0   17   184 195                 379
2229128 2229128 MA Barnstable   school 2502310 20   Barnstable 250231002678 200315 Barnstable: Barnstable Intermediate School   Regular School No Middle 06 07 2018   grade_6 263 30 58 0   9     0   18   206 172                       378.0 263 30 58 0   9     0   18   206 172                 378
932844 932844 MA Barnstable   school 2502310 20   Barnstable 250231002678 200315 Barnstable Intermediate School   Regular School No 2 06 07 2016   grade_6 290 34 27 2   8     0   16   190 187                       377 290 34 27 2   8     0   16   190 187                 377
1369582 1369582 MA Essex   school 2508700 211   North Andover 250870001398 2110305 North Andover Middle   Regular School No Middle 06 08 2020   grade_6 255 11 55 1   36     0   18   170 206 *                     376.0 255 11 55 1   36     0   18   170 206                 376
1365094 1365094 MA Barnstable   school 2502310 20   Barnstable 250231002678 200315 Barnstable Intermediate School   Regular School No Middle 06 07 2020   grade_6 242 24 78 4   8     1   18   202 173 *                     375.0 242 24 78 4   8     1   18   202 173                 375
1675994 1675994 MA Middlesex   school 2507320 170   Marlborough 250732002639 1700045 Marlborough - 1 LT Charles W. Whitcomb School   Regular School No Middle 05 08 2021   grade_6 136 16 205 0   4     0   14   178 197 *                     375.0 136 16 205 0   4     0   14   178 197                 375
2237460 2237460 MA Middlesex   school 2513110 344   Winchester 251311002167 3440305 Winchester: McCall Middle   Regular School No Middle 06 08 2018   grade_6 279 4 14 2   61     0   15   177 198                       375.0 279 4 14 2   61     0   15   177 198                 375
935507 935507 MA Plymouth   school 2506090 131   Hingham 250609000875 1310410 Hingham Middle School   Regular School No 2 06 08 2016   grade_6 341 4 9 0   9     1   10   191 183                       374 341 4 9 0   9     1   10   191 183                 374
743017 743017 MA Middlesex   school 2513110 344   Winchester 251311002167 3440305 McCall Middle   Regular School No 2 06 08 2015   grade_6 303 0 11 0   51     0   8   182 191                       373 303 0 11 0   51     0   8   182 191                 373
1368744 1368744 MA Middlesex   school 2507320 170   Marlborough 250732002639 1700045 1 LT Charles W. Whitcomb School   Regular School No Middle 05 08 2020   grade_6 120 12 215 1   14     0   9   204 167 *                     371.0 120 12 215 1   14     0   9   204 167                 371
1676829 1676829 MA Essex   school 2508700 211   North Andover 250870001398 2110305 North Andover - North Andover Middle   Regular School No Middle 06 08 2021   grade_6 257 16 52 1   30     0   15   197 174 *                     371.0 257 16 52 1   30     0   15   197 174                 371
937394 937394 MA Bristol   school 2508730 212   North Attleborough 250873001207 2120305 North Attleborough Middle   Regular School No 2 06 08 2016   grade_6 317 5 15 2   22     1   8   190 180                       370 317 5 15 2   22     1   8   190 180                 370
2234538 2234538 MA Bristol   school 2508730 212   North Attleborough 250873001207 2120305 North Attleborough: North Attleborough Middle   Regular School No Middle 06 08 2018   grade_6 308 9 17 0   20     0   15   176 193                       369.0 308 9 17 0   20     0   15   176 193                 369
2235070 2235070 MA Plymouth   school 2509720 239   Plymouth 250972002531 2390405 Plymouth: Plymouth Commun Intermediate   Regular School No Middle 06 08 2018   grade_6 308 7 27 1   8     0   18   196 173                       369.0 308 7 27 1   8     0   18   196 173                 369
1369331 1369331 MA Bristol   school 2508430 201   New Bedford 250843001337 2010410 Normandin Middle School   Regular School No Middle 06 08 2020   grade_6 182 32 136 0   5     0   12   201 166 *                     367.0 182 32 136 0   5     0   12   201 166                 367
1672398 1672398 MA Middlesex   school 2502490 26   Belmont 250249000149 260305 Belmont - Winthrop L Chenery Middle   Regular School No Middle 05 08 2021   grade_6 251 8 8 0   74     0   24   184 181 *                     365.0 251 8 8 0   74     0   24   184 181                 365
1672442 1672442 MA Essex   school 2502640 30   Beverly 250264000165 300305 Beverly - Beverly Middle School   Regular School No Middle 05 08 2021   grade_6 270 14 59 1   7     0   13   178 186 *                     364.0 270 14 59 1   7     0   13   178 186                 364
2040202 2040202 MA Middlesex   school 2502490 26   Belmont 250249000149 260305 Winthrop L Chenery Middle   Regular School No Middle 05 08 2019   grade_6 229 14 18 0   77     0   26   191 173                       364.0 229 14 18 0   77     0   26   191 173                 364
2044401 2044401 MA Bristol   school 2508430 201   New Bedford 250843001334 2010405 Keith Middle School   Regular School No Middle 06 08 2019   grade_6 127 56 149 1   6     1   24   198 166                       364.0 127 56 149 1   6     1   24   198 166                 364
735970 735970 MA Barnstable   school 2502310 20   Barnstable 250231002678 200315 Barnstable Intermediate School   Regular School No 2 06 07 2015   grade_6 275 28 35 3   5     2   15   209 154                       363 275 28 35 3   5     2   15   209 154                 363
939826 939826 MA Middlesex   school 2513110 344   Winchester 251311002167 3440305 McCall Middle   Regular School No 2 06 08 2016   grade_6 264 0 14 1   63     1   20   181 182                       363 264 0 14 1   63     1   20   181 182                 363
2040253 2040253 MA Essex   school 2502640 30   Beverly 250264000165 300305 Beverly Middle School   Regular School No Middle 05 08 2019   grade_6 283 8 53 0   12     0   7   185 178                       363.0 283 8 53 0   12     0   7   185 178                 363
2044655 2044655 MA Essex   school 2508700 211   North Andover 250870001398 2110305 North Andover Middle   Regular School No Middle 06 08 2019   grade_6 263 13 41 2   31     0   13   181 182                       363.0 263 13 41 2   31     0   13   181 182                 363
939412 939412 MA Norfolk   school 2512270 317   Wellesley 251227002029 3170305 Wellesley Middle   Regular School No 2 06 08 2016   grade_6 279 17 18 0   27     0   21   177 185                       362 279 17 18 0   27     0   21   177 185                 362
1125486 1125486 MA Plymouth   school 2506090 131   Hingham 250609000875 1310410 Hingham Middle School   Regular School No Middle 06 08 2017   grade_6 323 2 10 0   16     0   11   195 167                       362 323 2 10 0   16     0   11   195 167                 362
1369328 1369328 MA Bristol   school 2508430 201   New Bedford 250843001334 2010405 Keith Middle School   Regular School No Middle 06 08 2020   grade_6 120 59 143 2   3     0   34   202 159 *                     361.0 120 59 143 2   3     0   34   202 159                 361
2229229 2229229 MA Middlesex   school 2502490 26   Belmont 250249000149 260305 Belmont: Winthrop L Chenery Middle   Regular School No Middle 05 08 2018   grade_6 246 13 24 1   52     0   25   178 183                       361.0 246 13 24 1   52     0   25   178 183                 361
2234492 2234492 MA Essex   school 2508700 211   North Andover 250870001398 2110305 North Andover: North Andover Middle   Regular School No Middle 06 08 2018   grade_6 282 12 33 1   28     0   5   182 179                       361.0 282 12 33 1   28     0   5   182 179                 361
2045146 2045146 MA Plymouth   school 2509720 239   Plymouth 250972002531 2390405 Plymouth Commun Intermediate   Regular School No Middle 06 08 2019   grade_6 310 10 25 0   3     1   11   174 186                       360.0 310 10 25 0   3     1   11   174 186                 360
1672318 1672318 MA Barnstable   school 2502310 20   Barnstable 250231002678 200315 Barnstable - Barnstable Intermediate School   Regular School No Middle 06 07 2021   grade_6 221 33 70 2   7     0   25   190 168 *                     358.0 221 33 70 2   7     0   25   190 168                 358
740564 740564 MA Bristol   school 2508730 212   North Attleborough 250873001207 2120305 North Attleborough Middle   Regular School No 2 06 08 2015   grade_6 309 7 11 0   18     0   12   193 164                       357 309 7 11 0   18     0   12   193 164                 357

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