enrollments

Data source: Big Local News · About: Big Local

9,536 rows where state = "MA" and year = 2021 sorted by multiracial_int descending

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

  • 2021 · 9,536 ✖
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
1673575 1673575 MA Norfolk   school 2503150 46   Brookline 250315000415 460505 Brookline - Brookline High   Regular School No High 09 12 2021   grade_9 256 32 79 0   86     0   56   268 240 *                     509.0 256 32 79 0   86     0   56   268 240                 509
1673576 1673576 MA Norfolk   school 2503150 46   Brookline 250315000415 460505 Brookline - Brookline High   Regular School No High 09 12 2021   grade_10 263 50 53 0   72     0   52   242 247 *                     490.0 263 50 53 0   72     0   52   242 247                 490
1673577 1673577 MA Norfolk   school 2503150 46   Brookline 250315000415 460505 Brookline - Brookline High   Regular School No High 09 12 2021   grade_11 296 31 64 0   71     1   52   274 238 *                     515.0 296 31 64 0   71     1   52   274 238                 515
1673475 1673475 MA Plymouth   school 2503090 44   Brockton 250309000385 440505 Brockton - Brockton High   Regular School No High 09 12 2021   grade_10 132 759 198 3   27     2   50   651 520 *                     1171.0 132 759 198 3   27     2   50   651 520                 1171
1673474 1673474 MA Plymouth   school 2503090 44   Brockton 250309000385 440505 Brockton - Brockton High   Regular School No High 09 12 2021   grade_9 187 617 165 1   24     2   48   589 455 *                     1044.0 187 617 165 1   24     2   48   589 455                 1044
1680759 1680759 MA Middlesex   school 2506930 695   Lincoln-Sudbury 250693001011 6950505 Lincoln-Sudbury - Lincoln-Sudbury Regional High   Regular School No High 09 12 2021   grade_10 270 20 17 0   7     1   48   169 194 *                     363.0 270 20 17 0   7     1   48   169 194                 363
1680758 1680758 MA Middlesex   school 2506930 695   Lincoln-Sudbury 250693001011 6950505 Lincoln-Sudbury - Lincoln-Sudbury Regional High   Regular School No High 09 12 2021   grade_9 279 21 16 1   5     0   47   180 189 *                     369.0 279 21 16 1   5     0   47   180 189                 369
1673713 1673713 MA Middlesex   school 2503270 49   Cambridge 250327000436 490506 Cambridge - Cambridge Rindge and Latin   Regular School No High 09 12 2021   grade_11 186 129 65 2   46     2   46   246 230 *                     476.0 186 129 65 2   46     2   46   246 230                 476
1673712 1673712 MA Middlesex   school 2503270 49   Cambridge 250327000436 490506 Cambridge - Cambridge Rindge and Latin   Regular School No High 09 12 2021   grade_10 179 128 79 0   45     3   44   226 252 *                     478.0 179 128 79 0   45     3   44   226 252                 478
1675453 1675453 MA Middlesex   school 2506840 155   Lexington 250684001001 1550505 Lexington - Lexington High   Regular School No High 09 12 2021   grade_9 224 25 27 0   231     0   43   261 288 *                     550.0 224 25 27 0   231     0   43   261 288                 550
1673578 1673578 MA Norfolk   school 2503150 46   Brookline 250315000415 460505 Brookline - Brookline High   Regular School No High 09 12 2021   grade_12 263 45 65 0   88     1   41   248 255 *                     503.0 263 45 65 0   88     1   41   248 255                 503
1681357 1681357 MA Bristol   school 2508440 825   Greater New Bedford Regional Vocational Technical 250844002266 8250605 Greater New Bedford Regional Vocational Technical - Gr New Bedford Vocational Technical   Career and Technical School No High 09 12 2021   grade_10 300 43 136 0   7     0   41   293 234 *                     527.0 300 43 136 0   7     0   41   293 234                 527
1676723 1676723 MA Middlesex   school 2508610 207   Newton 250861001374 2070505 Newton - Newton North High   Regular School No High 09 12 2021   grade_10 308 22 55 2   66     0   40   257 235 *                     493.0 308 22 55 2   66     0   40   257 235                 493
1676724 1676724 MA Middlesex   school 2508610 207   Newton 250861001374 2070505 Newton - Newton North High   Regular School No High 09 12 2021   grade_11 316 31 60 0   91     0   40   279 259 *                     538.0 316 31 60 0   91     0   40   279 259                 538
1673476 1673476 MA Plymouth   school 2503090 44   Brockton 250309000385 440505 Brockton - Brockton High   Regular School No High 09 12 2021   grade_11 131 580 128 3   22     2   39   450 455 *                     905.0 131 580 128 3   22     2   39   450 455                 905
1672397 1672397 MA Middlesex   school 2502490 26   Belmont 250249000149 260305 Belmont - Winthrop L Chenery Middle   Regular School No Middle 05 08 2021   grade_5 201 14 14 2   66     0   38   164 171 *                     335.0 201 14 14 2   66     0   38   164 171                 335
1674437 1674437 MA Bristol   school 2504830 95   Fall River 250483000649 950505 Fall River - B M C Durfee High   Regular School No High 09 12 2021   grade_9 250 57 149 0   31     0   38   279 246 *                     525.0 250 57 149 0   31     0   38   279 246                 525
1678552 1678552 MA Bristol   school 2511520 293   Taunton 251152001915 2930505 Taunton - Taunton High   Regular School No High 08 12 2021   grade_9 314 122 79 5   5     2   38   293 272 *                     565.0 314 122 79 5   5     2   38   293 272                 565
1675654 1675654 MA Middlesex   school 2507020 160   Lowell 250702001041 1600505 Lowell - Lowell High   Regular School No High 09 12 2021   grade_9 202 80 340 0   221     0   37   479 401 *                     880.0 202 80 340 0   221     0   37   479 401                 880
1673711 1673711 MA Middlesex   school 2503270 49   Cambridge 250327000436 490506 Cambridge - Cambridge Rindge and Latin   Regular School No High 09 12 2021   grade_9 162 114 73 0   43     0   36   198 228 *                     428.0 162 114 73 0   43     0   36   198 228                 428
1676588 1676588 MA Bristol   school 2508430 201   New Bedford 250843001336 2010505 New Bedford - New Bedford High   Regular School No High 09 12 2021   grade_11 216 109 298 3   7     2   36   359 311 *                     671.0 216 109 298 3   7     2   36   359 311                 671
1675454 1675454 MA Middlesex   school 2506840 155   Lexington 250684001001 1550505 Lexington - Lexington High   Regular School No High 09 12 2021   grade_10 257 15 25 0   267     0   35   305 293 *                     599.0 257 15 25 0   267     0   35   305 293                 599
1676587 1676587 MA Bristol   school 2508430 201   New Bedford 250843001336 2010505 New Bedford - New Bedford High   Regular School No High 09 12 2021   grade_10 263 97 352 5   4     0   35   397 359 *                     756.0 263 97 352 5   4     0   35   397 359                 756
1676729 1676729 MA Middlesex   school 2508610 207   Newton 250861001375 2070510 Newton - Newton South High   Regular School No High 09 12 2021   grade_11 268 28 34 0   114     0   35   268 210 *                     479.0 268 28 34 0   114     0   35   268 210                 479
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
1675456 1675456 MA Middlesex   school 2506840 155   Lexington 250684001001 1550505 Lexington - Lexington High   Regular School No High 09 12 2021   grade_12 252 14 25 2   203     0   34   260 270 *                     530.0 252 14 25 2   203     0   34   260 270                 530
1676578 1676578 MA Bristol   school 2508430 201   New Bedford 250843001334 2010405 New Bedford - Keith Middle School   Regular School No Middle 06 08 2021   grade_7 113 62 137 2   3     0   34   198 153 *                     351.0 113 62 137 2   3     0   34   198 153                 351
1676586 1676586 MA Bristol   school 2508430 201   New Bedford 250843001336 2010505 New Bedford - New Bedford High   Regular School No High 09 12 2021   grade_9 296 101 315 2   7     1   34   407 349 *                     756.0 296 101 315 2   7     1   34   407 349                 756
1674438 1674438 MA Bristol   school 2504830 95   Fall River 250483000649 950505 Fall River - B M C Durfee High   Regular School No High 09 12 2021   grade_10 297 57 169 1   26     0   33   288 294 *                     583.0 297 57 169 1   26     0   33   288 294                 583
1676725 1676725 MA Middlesex   school 2508610 207   Newton 250861001374 2070505 Newton - Newton North High   Regular School No High 09 12 2021   grade_12 309 37 48 1   71     0   33   248 249 *                     499.0 309 37 48 1   71     0   33   248 249                 499
1678551 1678551 MA Bristol   school 2511520 293   Taunton 251152001915 2930505 Taunton - Taunton High   Regular School No High 08 12 2021   grade_8 426 113 92 4   5     2   33   337 338 *                     675.0 426 113 92 4   5     2   33   337 338                 675
1676722 1676722 MA Middlesex   school 2508610 207   Newton 250861001374 2070505 Newton - Newton North High   Regular School No High 09 12 2021   grade_9 319 24 63 0   77     0   32   261 253 *                     515.0 319 24 63 0   77     0   32   261 253                 515
1676728 1676728 MA Middlesex   school 2508610 207   Newton 250861001375 2070510 Newton - Newton South High   Regular School No High 09 12 2021   grade_10 297 14 26 0   116     0   32   236 248 *                     485.0 297 14 26 0   116     0   32   236 248                 485
1681356 1681356 MA Bristol   school 2508440 825   Greater New Bedford Regional Vocational Technical 250844002266 8250605 Greater New Bedford Regional Vocational Technical - Gr New Bedford Vocational Technical   Career and Technical School No High 09 12 2021   grade_9 349 43 131 4   7     1   32   306 261 *                     567.0 349 43 131 4   7     1   32   306 261                 567
1673477 1673477 MA Plymouth   school 2503090 44   Brockton 250309000385 440505 Brockton - Brockton High   Regular School No High 09 12 2021   grade_12 166 561 110 4   19     4   31   471 424 *                     895.0 166 561 110 4   19     4   31   471 424                 895
1678779 1678779 MA Plymouth   school 2512060 310   Wareham 251206001988 3100003 Wareham - John William Decas   Regular School No Elementary PK 02 2021   grade_1 124 7 18 3   1     0   31   91 93 *                     184.0 124 7 18 3   1     0   31   91 93                 184
1673714 1673714 MA Middlesex   school 2503270 49   Cambridge 250327000436 490506 Cambridge - Cambridge Rindge and Latin   Regular School No High 09 12 2021   grade_12 182 128 60 2   47     2   30   225 225 *                     451.0 182 128 60 2   47     2   30   225 225                 451
1674518 1674518 MA Worcester   school 2504890 97   Fitchburg 250489000697 970505 Fitchburg - Fitchburg High   Regular School No High 09 12 2021   grade_12 77 28 132 0   12     0   30   127 152 *                     279.0 77 28 132 0   12     0   30   127 152                 279
1675455 1675455 MA Middlesex   school 2506840 155   Lexington 250684001001 1550505 Lexington - Lexington High   Regular School No High 09 12 2021   grade_11 269 32 25 0   226     0   30   293 289 *                     582.0 269 32 25 0   226     0   30   293 289                 582
1677254 1677254 MA Berkshire   school 2509630 236   Pittsfield 250963001534 2360510 Pittsfield - Taconic High   Regular School No High 09 12 2021   grade_10 130 29 27 0   3     0   30   108 110 *                     219.0 130 29 27 0   3     0   30   108 110                 219
1678785 1678785 MA Plymouth   school 2512060 310   Wareham 251206002603 3100305 Wareham - Wareham Middle   Regular School No Middle 05 07 2021   grade_7 126 14 12 3   2     0   30   84 103 *                     187.0 126 14 12 3   2     0   30   84 103                 187
1672198 1672198 MA Middlesex   school 2501980 10   Arlington 250198000063 100410 Arlington - Ottoson Middle   Regular School No Middle 07 08 2021   grade_8 309 15 35 1   46     1   29   239 196 *                     436.0 309 15 35 1   46     1   29   239 196                 436
1674439 1674439 MA Bristol   school 2504830 95   Fall River 250483000649 950505 Fall River - B M C Durfee High   Regular School No High 09 12 2021   grade_11 262 51 140 1   28     0   29   270 241 *                     511.0 262 51 140 1   28     0   29   270 241                 511
1675452 1675452 MA Middlesex   school 2506840 155   Lexington 250684002552 1550310 Lexington - Wm Diamond Middle   Regular School No Middle 06 08 2021   grade_8 136 8 12 0   139     0   29   158 166 *                     324.0 136 8 12 0   139     0   29   158 166                 324
1676730 1676730 MA Middlesex   school 2508610 207   Newton 250861001375 2070510 Newton - Newton South High   Regular School No High 09 12 2021   grade_12 301 20 35 0   106     0   29   254 236 *                     491.0 301 20 35 0   106     0   29   254 236                 491
1679308 1679308 MA Middlesex   school 2513110 344   Winchester 251311002167 3440305 Winchester - McCall Middle   Regular School No Middle 06 08 2021   grade_7 272 7 9 0   71     0   29   205 183 *                     388.0 272 7 9 0   71     0   29   205 183                 388
1672255 1672255 MA Bristol   school 2502190 16   Attleboro 250219000084 160505 Attleboro - Attleboro High   Regular School No High 09 12 2021   grade_9 291 30 73 1   26     0   28   240 209 *                     449.0 291 30 73 1   26     0   28   240 209                 449
1672399 1672399 MA Middlesex   school 2502490 26   Belmont 250249000149 260305 Belmont - Winthrop L Chenery Middle   Regular School No Middle 05 08 2021   grade_7 211 13 20 1   92     2   28   189 178 *                     367.0 211 13 20 1   92     2   28   189 178                 367
1677816 1677816 MA Norfolk   school 2510620 266   Sharon 251062002560 2660305 Sharon - Sharon Middle   Regular School No Middle 06 08 2021   grade_6 136 16 19 1   91     1   28   143 148 *                     292.0 136 16 19 1   91     1   28   143 148                 292
1679309 1679309 MA Middlesex   school 2513110 344   Winchester 251311002167 3440305 Winchester - McCall Middle   Regular School No Middle 06 08 2021   grade_8 236 5 13 1   65     0   28   168 180 *                     348.0 236 5 13 1   65     0   28   168 180                 348
1680291 1680291 MA Middlesex   school 2501710 600   Acton-Boxborough 250171000012 6000505 Acton-Boxborough - Acton-Boxborough Regional High   Regular School No High 09 12 2021   grade_11 236 10 24 0   152     0   28   228 220 *                     450.0 236 10 24 0   152     0   28   228 220                 450
1681351 1681351 MA Bristol   school 2505485 821   Greater Fall River Regional Vocational Technical 250548502269 8210605 Greater Fall River Regional Vocational Technical - Diman Regional Vocational Technical High   Career and Technical School No High 09 12 2021   grade_12 267 13 33 2   9     0   28   195 157 *                     352.0 267 13 33 2   9     0   28   195 157                 352
1681362 1681362 MA Middlesex   school 2505480 828   Greater Lowell Regional Vocational Technical 250548002268 8280605 Greater Lowell Regional Vocational Technical - Gr Lowell Regional Vocational Technical   Career and Technical School No High 09 12 2021   grade_11 198 29 214 2   89     0   28   276 281 3                     560.0 198 29 214 2   89     0   28   276 281 3               560
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
1674684 1674684 MA Worcester   school 2505130 103   Gardner 250513002431 1030405 Gardner - Gardner Middle School   Regular School No Middle 05 07 2021   grade_6 119 4 39 1   1     0   27   109 82 *                     191.0 119 4 39 1   1     0   27   109 82                 191
1676412 1676412 MA Middlesex   school 2508340 198   Natick 250834001303 1980505 Natick - Natick High   Regular School No High 09 12 2021   grade_11 296 13 24 1   22     0   27   194 187 *                     383.0 296 13 24 1   22     0   27   194 187                 383
1676716 1676716 MA Middlesex   school 2508610 207   Newton 250861000314 2070315 Newton - F A Day Middle   Regular School No Middle 06 08 2021   grade_6 205 18 32 1   50     2   27   171 164 *                     335.0 205 18 32 1   50     2   27   171 164                 335
1678440 1678440 MA Middlesex   school 2511340 288   Sudbury 251134001872 2880305 Sudbury - Ephraim Curtis Middle   Regular School No Middle 06 08 2021   grade_6 196 7 14 0   33     1   27   159 119 *                     278.0 196 7 14 0   33     1   27   159 119                 278
1680313 1680313 MA Hampshire   school 2501920 605   Amherst-Pelham 250192000042 6050505 Amherst-Pelham - Amherst Regional High   Regular School No High 09 12 2021   grade_12 121 13 40 0   23     0   27   104 119 *                     224.0 121 13 40 0   23     0   27   104 119                 224
1681404 1681404 MA Bristol   school 2511020 872   Southeastern Regional Vocational Technical 251102002290 8720605 Southeastern Regional Vocational Technical - Southeastern Regional Vocational Technical   Career and Technical School No High 09 12 2021   grade_12 168 114 45 0   7     0   27   184 176 *                     361.0 168 114 45 0   7     0   27   184 176                 361
1674424 1674424 MA Bristol   school 2504830 95   Fall River 250483000671 950320 Fall River - Matthew J Kuss Middle   Regular School No Middle 06 08 2021   grade_6 121 22 59 0   9     0   26   124 113 *                     237.0 121 22 59 0   9     0   26   124 113                 237
1674517 1674517 MA Worcester   school 2504890 97   Fitchburg 250489000697 970505 Fitchburg - Fitchburg High   Regular School No High 09 12 2021   grade_11 79 19 139 0   17     0   26   160 120 *                     280.0 79 19 139 0   17     0   26   160 120                 280
1674622 1674622 MA Middlesex   school 2504980 100   Framingham 250498002573 1000515 Framingham - Framingham High School   Regular School No High 09 12 2021   grade_9 326 39 245 0   24     1   26   356 305 *                     661.0 326 39 245 0   24     1   26   356 305                 661
1674623 1674623 MA Middlesex   school 2504980 100   Framingham 250498002573 1000515 Framingham - Framingham High School   Regular School No High 09 12 2021   grade_10 335 37 226 1   28     1   26   329 325 *                     654.0 335 37 226 1   28     1   26   329 325                 654
1675657 1675657 MA Middlesex   school 2507020 160   Lowell 250702001041 1600505 Lowell - Lowell High   Regular School No High 09 12 2021   grade_12 212 89 176 0   248     0   26   360 391 *                     751.0 212 89 176 0   248     0   26   360 391                 751
1676579 1676579 MA Bristol   school 2508430 201   New Bedford 250843001334 2010405 New Bedford - Keith Middle School   Regular School No Middle 06 08 2021   grade_8 124 44 137 0   5     0   26   184 152 *                     336.0 124 44 137 0   5     0   26   184 152                 336
1676589 1676589 MA Bristol   school 2508430 201   New Bedford 250843001336 2010505 New Bedford - New Bedford High   Regular School No High 09 12 2021   grade_12 155 109 235 4   8     2   26   274 265 *                     539.0 155 109 235 4   8     2   26   274 265                 539
1678910 1678910 MA Norfolk   school 2512270 317   Wellesley 251227002030 3170505 Wellesley - Wellesley Sr High   Regular School No High 09 12 2021   grade_10 261 11 17 0   52     0   26   197 170 *                     367.0 261 11 17 0   52     0   26   197 170                 367
1680495 1680495 MA Middlesex   school 2503870 640   Concord-Carlisle 250387000527 6400505 Concord-Carlisle - Concord Carlisle High   Regular School No High 09 12 2021   grade_9 253 14 24 1   21     0   26   168 170 *                     339.0 253 14 24 1   21     0   26   168 170                 339
1681359 1681359 MA Bristol   school 2508440 825   Greater New Bedford Regional Vocational Technical 250844002266 8250605 Greater New Bedford Regional Vocational Technical - Gr New Bedford Vocational Technical   Career and Technical School No High 09 12 2021   grade_12 297 37 132 3   3     0   26   237 261 *                     498.0 297 37 132 3   3     0   26   237 261                 498
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
1672400 1672400 MA Middlesex   school 2502490 26   Belmont 250249000149 260305 Belmont - Winthrop L Chenery Middle   Regular School No Middle 05 08 2021   grade_8 212 14 16 0   76     0   25   175 168 *                     343.0 212 14 16 0   76     0   25   175 168                 343
1674426 1674426 MA Bristol   school 2504830 95   Fall River 250483000671 950320 Fall River - Matthew J Kuss Middle   Regular School No Middle 06 08 2021   grade_8 143 16 59 0   10     0   25   113 140 *                     253.0 143 16 59 0   10     0   25   113 140                 253
1675655 1675655 MA Middlesex   school 2507020 160   Lowell 250702001041 1600505 Lowell - Lowell High   Regular School No High 09 12 2021   grade_10 123 69 231 0   212     0   25   355 305 *                     660.0 123 69 231 0   212     0   25   355 305                 660
1675656 1675656 MA Middlesex   school 2507020 160   Lowell 250702001041 1600505 Lowell - Lowell High   Regular School No High 09 12 2021   grade_11 206 99 179 0   227     0   25   362 374 *                     736.0 206 99 179 0   227     0   25   362 374                 736
1676228 1676228 MA Essex   school 2507740 181   Methuen 250774001213 1810505 Methuen - Methuen High   Regular School No High 09 12 2021   grade_10 217 11 234 0   23     0   25   271 239 *                     510.0 217 11 234 0   23     0   25   271 239                 510
1676450 1676450 MA Norfolk   school 2508370 199   Needham 250837001315 1990505 Needham - Needham High   Regular School No High 09 12 2021   grade_11 345 10 18 2   44     1   25   214 229 2                     445.0 345 10 18 2   44     1   25   214 229 2               445
1676717 1676717 MA Middlesex   school 2508610 207   Newton 250861000314 2070315 Newton - F A Day Middle   Regular School No Middle 06 08 2021   grade_7 176 18 26 1   62     0   25   153 155 *                     308.0 176 18 26 1   62     0   25   153 155                 308
1677242 1677242 MA Berkshire   school 2509630 236   Pittsfield 250963001525 2360305 Pittsfield - John T Reid Middle   Regular School No Middle 06 08 2021   grade_6 100 22 34 1   2     0   25   96 88 *                     184.0 100 22 34 1   2     0   25   96 88                 184
1678906 1678906 MA Norfolk   school 2512270 317   Wellesley 251227002029 3170305 Wellesley - Wellesley Middle   Regular School No Middle 06 08 2021   grade_6 219 11 24 0   58     0   25   168 169 *                     337.0 219 11 24 0   58     0   25   168 169                 337
1672258 1672258 MA Bristol   school 2502190 16   Attleboro 250219000084 160505 Attleboro - Attleboro High   Regular School No High 09 12 2021   grade_12 281 25 61 0   27     2   24   215 205 *                     420.0 281 25 61 0   27     2   24   215 205                 420
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
1674425 1674425 MA Bristol   school 2504830 95   Fall River 250483000671 950320 Fall River - Matthew J Kuss Middle   Regular School No Middle 06 08 2021   grade_7 144 13 52 0   12     0   24   116 129 *                     245.0 144 13 52 0   12     0   24   116 129                 245
1675450 1675450 MA Middlesex   school 2506840 155   Lexington 250684002552 1550310 Lexington - Wm Diamond Middle   Regular School No Middle 06 08 2021   grade_6 127 13 12 0   113     0   24   152 137 *                     289.0 127 13 12 0   113     0   24   152 137                 289
1675451 1675451 MA Middlesex   school 2506840 155   Lexington 250684002552 1550310 Lexington - Wm Diamond Middle   Regular School No Middle 06 08 2021   grade_7 113 13 9 0   140     0   24   144 155 *                     299.0 113 13 9 0   140     0   24   144 155                 299
1676577 1676577 MA Bristol   school 2508430 201   New Bedford 250843001334 2010405 New Bedford - Keith Middle School   Regular School No Middle 06 08 2021   grade_6 128 59 135 0   1     0   24   181 166 *                     347.0 128 59 135 0   1     0   24   181 166                 347
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
1678553 1678553 MA Bristol   school 2511520 293   Taunton 251152001915 2930505 Taunton - Taunton High   Regular School No High 08 12 2021   grade_10 298 108 70 1   6     1   24   264 244 *                     508.0 298 108 70 1   6     1   24   264 244                 508
1678908 1678908 MA Norfolk   school 2512270 317   Wellesley 251227002029 3170305 Wellesley - Wellesley Middle   Regular School No Middle 06 08 2021   grade_8 252 20 12 0   64     0   24   158 213 *                     372.0 252 20 12 0   64     0   24   158 213                 372
1679648 1679648 MA Worcester   school 2513230 348   Worcester 251323002202 3480405 Worcester - Burncoat Middle School   Regular School No Middle 07 08 2021   grade_8 96 52 161 0   18     0   24   181 170 *                     351.0 96 52 161 0   18     0   24   181 170                 351
1679649 1679649 MA Worcester   school 2513230 348   Worcester 251323002213 3480415 Worcester - Forest Grove Middle   Regular School No Middle 07 08 2021   grade_7 206 63 145 0   20     0   24   229 229 *                     458.0 206 63 145 0   20     0   24   229 229                 458
1680517 1680517 MA Barnstable   school 2504140 645   Dennis-Yarmouth 250414000562 6450305 Dennis-Yarmouth - Mattacheese Middle School   Regular School No Middle 06 07 2021   grade_6 129 16 22 6   2     0   24   99 100 *                     199.0 129 16 22 6   2     0   24   99 100                 199
1681358 1681358 MA Bristol   school 2508440 825   Greater New Bedford Regional Vocational Technical 250844002266 8250605 Greater New Bedford Regional Vocational Technical - Gr New Bedford Vocational Technical   Career and Technical School No High 09 12 2021   grade_11 306 47 135 1   7     1   24   266 255 *                     521.0 306 47 135 1   7     1   24   266 255                 521
1681541 1681541 MA Norfolk   school 2500556 3902   TEC Connections Academy Commonwealth Virtual School District 250055602817 39020900 TEC Connections Academy Commonwealth Virtual School District - TEC Connections Academy Commonwealth Virtual School   Regular School No Other KG 12 2021   grade_10 243 30 52 2   6     0   24   144 213 *                     357.0 243 30 52 2   6     0   24   144 213                 357
1672401 1672401 MA Middlesex   school 2502490 26   Belmont 250249000143 260505 Belmont - Belmont High   Regular School No High 09 12 2021   grade_9 225 14 19 1   52     0   23   169 165 *                     334.0 225 14 19 1   52     0   23   169 165                 334
1673217 1673217 MA Suffolk   school 2502790 35   Boston 250279000203 350560 Boston - Boston Latin   Regular School No High 07 12 2021   grade_7 189 29 55 0   121     2   23   228 191 *                     419.0 189 29 55 0   121     2   23   228 191                 419
1674044 1674044 MA Bristol   school 2504020 72   Dartmouth 250402000540 720505 Dartmouth - Dartmouth High   Regular School No High 09 12 2021   grade_10 198 7 14 0   0     0   23   126 116 *                     242.0 198 7 14 0   0     0   23   126 116                 242
1674419 1674419 MA Bristol   school 2504830 95   Fall River 250483000655 950305 Fall River - Talbot Innovation School   Regular School No Middle 06 08 2021   grade_7 84 15 70 1   5     0   23   105 93 *                     198.0 84 15 70 1   5     0   23   105 93                 198
1676413 1676413 MA Middlesex   school 2508340 198   Natick 250834001303 1980505 Natick - Natick High   Regular School No High 09 12 2021   grade_12 321 12 30 0   21     1   23   191 217 *                     408.0 321 12 30 0   21     1   23   191 217                 408
1676448 1676448 MA Norfolk   school 2508370 199   Needham 250837001315 1990505 Needham - Needham High   Regular School No High 09 12 2021   grade_9 322 10 30 0   38     1   23   204 216 4                     424.0 322 10 30 0   38     1   23   204 216 4               424

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