enrollments

Data source: Big Local News · About: Big Local

496 rows where grade = "grade_7", state = "MA" and year = 2021 sorted by multiracial descending

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

  • 2021 · 496 ✖

grade ✖

  • grade_7 · 496 ✖
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
1672211 1672211 MA Middlesex   school 2502100 14   Ashland 250210000938 140405 Ashland - Ashland Middle   Regular School No Middle 06 08 2021   grade_7 143 6 35 3   28     0   9   118 106 *                     224.0 143 6 35 3   28     0   9   118 106                 224
1672480 1672480 MA Middlesex   school 2502670 31   Billerica 250267000182 310310 Billerica - Locke Middle   Regular School No Middle 05 07 2021   grade_7 146 4 10 0   12     0   9   104 77 *                     181.0 146 4 10 0   12     0   9   104 77                 181
1674070 1674070 MA Norfolk   school 2504050 73   Dedham 250405000551 730305 Dedham - Dedham Middle School   Regular School No Middle 06 08 2021   grade_7 158 12 28 0   2     0   9   116 93 *                     209.0 158 12 28 0   2     0   9   116 93                 209
1674818 1674818 MA Franklin   school 2505490 114   Greenfield 250549000800 1140305 Greenfield - Greenfield Middle   Regular School No Middle 05 07 2021   grade_7 85 5 19 0   1     0   9   61 58 *                     119.0 85 5 19 0   1     0   9   61 58                 119
1675005 1675005 MA Norfolk   school 2506150 133   Holbrook 250615000878 1330505 Holbrook - Holbrook Middle High School   Regular School No High 06 12 2021   grade_7 51 18 17 1   5     0   9   54 47 *                     101.0 51 18 17 1   5     0   9   54 47                 101
1675448 1675448 MA Middlesex   school 2506840 155   Lexington 250684002551 1550305 Lexington - Jonas Clarke Middle   Regular School No Middle 06 08 2021   grade_7 139 15 10 1   127     1   9   172 130 *                     302.0 139 15 10 1   127     1   9   172 130                 302
1675514 1675514 MA Hampden   school 2506990 159   Longmeadow 250699000743 1590305 Longmeadow - Williams Middle   Regular School No Middle 06 08 2021   grade_7 94 0 7 0   17     2   9   55 74 *                     129.0 94 0 7 0   17     2   9   55 74                 129
1675831 1675831 MA Essex   school 2507110 163   Lynn 250711001083 1630420 Lynn - Pickering Middle   Regular School No Middle 06 08 2021   grade_7 76 10 99 3   19     0   9   112 104 *                     216.0 76 10 99 3   19     0   9   112 104                 216
1676086 1676086 MA Norfolk   school 2507530 175   Medfield 250753001156 1750305 Medfield - Thomas Blake Middle   Regular School No Middle 06 08 2021   grade_7 160 0 14 0   3     0   9   96 90 *                     186.0 160 0 14 0   3     0   9   96 90                 186
1676285 1676285 MA Worcester   school 2507890 186   Millbury 250789001249 1860505 Millbury - Millbury Junior/Senior High   Regular School No High 07 12 2021   grade_7 93 1 14 0   3     0   9   55 65 *                     120.0 93 1 14 0   3     0   9   55 65                 120
1676720 1676720 MA Middlesex   school 2508610 207   Newton 250861001042 2070320 Newton - Oak Hill Middle   Regular School No Middle 06 08 2021   grade_7 135 17 11 0   59     0   9   123 108 *                     231.0 135 17 11 0   59     0   9   123 108                 231
1677246 1677246 MA Berkshire   school 2509630 236   Pittsfield 250963001532 2360310 Pittsfield - Theodore Herberg Middle   Regular School No Middle 06 08 2021   grade_7 123 12 28 1   3     0   9   92 84 *                     176.0 123 12 28 1   3     0   9   92 84                 176
1678547 1678547 MA Bristol   school 2511520 293   Taunton 251152002416 2930305 Taunton - John F Parker Middle   Regular School No Middle 05 07 2021   grade_7 84 34 28 2   1     1   9   70 89 *                     159.0 84 34 28 2   1     1   9   70 89                 159
1678936 1678936 MA Worcester   school 2512600 321   Westborough 251260002604 3210305 Westborough - Sarah W Gibbons Middle   Regular School No Middle 07 08 2021   grade_7 153 15 14 0   98     0   9   134 155 *                     289.0 153 15 14 0   98     0   9   134 155                 289
1672273 1672273 MA Worcester   school 2502220 17   Auburn 250222002567 170305 Auburn - Auburn Middle   Regular School No Middle 06 08 2021   grade_7 175 9 20 0   6     0   8   94 124 *                     218.0 175 9 20 0   6     0   8   94 124                 218
1672334 1672334 MA Middlesex   school 2502400 23   Bedford 250240000130 230305 Bedford - John Glenn Middle   Regular School No Middle 06 08 2021   grade_7 133 13 6 0   40     0   8   103 97 *                     200.0 133 13 6 0   40     0   8   103 97                 200
1672366 1672366 MA Norfolk   school 2502460 25   Bellingham 250246001683 250315 Bellingham - Bellingham Memorial School   Regular School No Middle 04 07 2021   grade_7 158 4 14 0   4     0   8   81 107 *                     188.0 158 4 14 0   4     0   8   81 107                 188
1673415 1673415 MA Plymouth   school 2503090 44   Brockton 250309000390 440023 Brockton - Edgar B Davis   Regular School No Elementary KG 08 2021   grade_7 17 76 20 1   0     0   8   55 67 *                     122.0 17 76 20 1   0     0   8   55 67                 122
1673897 1673897 MA Hampden   school 2503660 61   Chicopee 250366000491 610305 Chicopee - Bellamy Middle   Regular School No Middle 06 08 2021   grade_7 138 8 133 0   4     0   8   164 127 *                     291.0 138 8 133 0   4     0   8   164 127                 291
1674231 1674231 MA Bristol   school 2504620 88   Easton 250462000618 880405 Easton - Easton Middle School   Regular School No Middle 06 08 2021   grade_7 221 13 15 0   11     0   8   134 134 *                     268.0 221 13 15 0   11     0   8   134 134                 268
1674617 1674617 MA Middlesex   school 2504980 100   Framingham 250498000464 1000305 Framingham - Fuller Middle   Regular School No Middle 06 08 2021   grade_7 58 15 101 1   4     0   8   111 76 *                     187.0 58 15 101 1   4     0   8   111 76                 187
1675644 1675644 MA Middlesex   school 2507020 160   Lowell 250702000073 1600340 Lowell - James Sullivan Middle School   Regular School No Middle 05 08 2021   grade_7 49 7 77 0   25     0   8   79 87 *                     166.0 49 7 77 0   25     0   8   79 87                 166
1675910 1675910 MA Middlesex   school 2507170 165   Malden 250717001361 1650047 Malden - Linden   Regular School No Elementary KG 08 2021   grade_7 27 16 19 0   14     0   8   46 38 *                     84.0 27 16 19 0   14     0   8   46 38                 84
1676124 1676124 MA Middlesex   school 2507560 176   Medford 250756002063 1760320 Medford - John J. McGlynn Middle School   Regular School No Middle 06 08 2021   grade_7 83 27 26 1   11     0   8   78 78 *                     156.0 83 27 26 1   11     0   8   78 78                 156
1676215 1676215 MA Essex   school 2507740 181   Methuen 250774001556 1810055 Methuen - Tenney Grammar School   Regular School No Elementary PK 08 2021   grade_7 52 5 71 0   2     0   8   77 61 *                     138.0 52 5 71 0   2     0   8   77 61                 138
1676711 1676711 MA Middlesex   school 2508610 207   Newton 250861000307 2070305 Newton - Bigelow Middle   Regular School No Middle 06 08 2021   grade_7 108 6 13 0   29     0   8   72 92 *                     164.0 108 6 13 0   29     0   8   72 92                 164
1676968 1676968 MA Bristol   school 2509000 218   Norton 250900001452 2180305 Norton - Norton Middle   Regular School No Middle 06 08 2021   grade_7 180 5 5 0   8     0   8   103 103 *                     206.0 180 5 5 0   8     0   8   103 103                 206
1677025 1677025 MA Norfolk   school 2509060 220   Norwood 250906001468 2200305 Norwood - Dr. Philip O. Coakley Middle School   Regular School No Middle 06 08 2021   grade_7 131 26 38 0   12     0   8   109 106 *                     215.0 131 26 38 0   12     0   8   109 106                 215
1677467 1677467 MA Norfolk   school 2509930 244   Randolph 250993001392 2440410 Randolph - Randolph Community Middle   Regular School No Middle 06 08 2021   grade_7 32 120 40 0   40     1   8   122 119 *                     241.0 32 120 40 0   40     1   8   122 119                 241
1678273 1678273 MA Hampden   school 2511130 281   Springfield 251113002602 2810330 Springfield - M Marcus Kiley Middle   Regular School No Middle 06 08 2021   grade_7 23 51 158 1   4     0   8   131 114 *                     245.0 23 51 158 1   4     0   8   131 114                 245
1678459 1678459 MA Worcester   school 2511400 290   Sutton 251140001413 2900305 Sutton - Sutton Middle School   Regular School No Middle 06 08 2021   grade_7 85 0 7 0   2     0   8   48 54 *                     102.0 85 0 7 0   2     0   8   48 54                 102
1678816 1678816 MA Middlesex   school 2512180 314   Watertown 251218002501 3140305 Watertown - Watertown Middle   Regular School No Middle 06 08 2021   grade_7 104 5 50 0   17     0   8   102 82 *                     184.0 104 5 50 0   17     0   8   102 82                 184
1679068 1679068 MA Middlesex   school 2512750 330   Weston 251275000793 3300305 Weston - Weston Middle   Regular School No Middle 06 08 2021   grade_7 92 7 11 0   29     0   8   79 68 *                     147.0 92 7 11 0   29     0   8   79 68                 147
1679251 1679251 MA Middlesex   school 2513050 342   Wilmington 251305001578 3420330 Wilmington - Wilmington Middle School   Regular School No Middle 06 08 2021   grade_7 234 3 10 0   13     0   8   143 125 *                     268.0 234 3 10 0   13     0   8   143 125                 268
1679378 1679378 MA Middlesex   school 2513200 347   Woburn 251320002182 3470410 Woburn - Daniel L Joyce Middle School   Regular School No Middle 06 08 2021   grade_7 134 8 26 1   6     0   8   106 77 *                     183.0 134 8 26 1   6     0   8   106 77                 183
1679824 1679824 MA Middlesex   school 2500085 430   Advanced Math and Science Academy Charter (District) 250008501984 4300305 Advanced Math and Science Academy Charter (District) - Advanced Math and Science Academy Charter School   Regular School Yes High 06 12 2021   grade_7 94 5 10 0   8     0   8   60 65 *                     125.0 94 5 10 0   8     0   8   60 65                 125
1679903 1679903 MA Hampden   school 2500028 441   Sabis International Charter (District) 250002800537 4410505 Sabis International Charter (District) - Sabis International Charter School   Regular School Yes Other KG 12 2021   grade_7 16 42 52 0   11     0   8   69 60 *                     129.0 16 42 52 0   11     0   8   69 60                 129
1680167 1680167 MA Plymouth   school 2500040 488   South Shore Charter Public (District) 250004000600 4880550 South Shore Charter Public (District) - South Shore Charter Public School   Regular School Yes Other KG 12 2021   grade_7 36 33 3 0   4     0   8   47 37 *                     84.0 36 33 3 0   4     0   8   47 37                 84
1680974 1680974 MA Middlesex   school 2508790 735   North Middlesex 250879001762 7350310 North Middlesex - Nissitissit Middle School   Regular School No Middle 05 08 2021   grade_7 103 2 5 0   1     0   8   65 54 *                     119.0 103 2 5 0   1     0   8   65 54                 119
1681149 1681149 MA Worcester   school 2511490 770   Tantasqua 251149001899 7700405 Tantasqua - Tantasqua Regional Jr High   Regular School No Middle 07 08 2021   grade_7 261 7 18 1   4     0   8   156 143 *                     299.0 261 7 18 1   4     0   8   156 143                 299
1681309 1681309 MA Plymouth   school 2512930 780   Whitman-Hanson 251293000207 7800310 Whitman-Hanson - Whitman Middle   Regular School No Middle 06 08 2021   grade_7 161 8 12 2   2     0   8   98 95 *                     193.0 161 8 12 2   2     0   8   98 95                 193
1681525 1681525 MA Franklin   school 2500551 3901   Massachusetts Virtual Academy at Greenfield Commonwealth Virtual District 250055102808 39010900 Greenfield Commonwealth Virtual District - Greenfield Commonwealth Virtual School   Regular School No Other KG 12 2021   grade_7 63 6 17 0   7     0   8   54 46 1                     101.0 63 6 17 0   7     0   8   54 46 1               101
1672146 1672146 MA Essex   school 2501950 9   Andover 250195001678 90350 Andover - Wood Hill Middle School   Regular School No Middle 06 08 2021   grade_7 66 4 10 0   35     1   7   53 70 *                     123.0 66 4 10 0   35     1   7   53 70                 123
1672792 1672792 MA Suffolk   school 2502790 35   Boston 250279000273 350183 Boston - Joseph Lee   Regular School No Elementary PK 08 2021   grade_7 0 36 23 0   3     0   7   32 37 *                     69.0 0 36 23 0   3     0   7   32 37                 69
1673572 1673572 MA Norfolk   school 2503150 46   Brookline 250315000419 460045 Brookline - John D Runkle   Regular School No Elementary PK 08 2021   grade_7 35 2 10 0   7     0   7   22 39 *                     61.0 35 2 10 0   7     0   7   22 39                 61
1673790 1673790 MA Middlesex   school 2503510 56   Chelmsford 250351000476 560305 Chelmsford - Col Moses Parker School   Regular School No Middle 05 08 2021   grade_7 124 10 17 2   27     0   7   121 66 *                     187.0 124 10 17 2   27     0   7   121 66                 187
1673900 1673900 MA Hampden   school 2503660 61   Chicopee 250366000722 610310 Chicopee - Dupont Middle   Regular School No Middle 06 08 2021   grade_7 125 15 124 0   4     0   7   145 130 *                     275.0 125 15 124 0   4     0   7   145 130                 275
1674013 1674013 MA Essex   school 2503990 71   Danvers 250399002517 710305 Danvers - Holten Richmond Middle School   Regular School No Middle 06 08 2021   grade_7 218 3 23 0   7     0   7   144 114 *                     258.0 218 3 23 0   7     0   7   144 114                 258
1674147 1674147 MA Plymouth   school 2504410 82   Duxbury 250441000975 820305 Duxbury - Duxbury Middle   Regular School No Middle 06 08 2021   grade_7 208 1 8 0   3     0   7   123 104 *                     227.0 208 1 8 0   3     0   7   123 104                 227
1674161 1674161 MA Plymouth   school 2504440 83   East Bridgewater 250444000597 830505 East Bridgewater - East Bridgewater JR./SR. High School   Regular School No High 07 12 2021   grade_7 154 9 6 1   1     0   7   103 75 *                     178.0 154 9 6 1   1     0   7   103 75                 178
1674620 1674620 MA Middlesex   school 2504980 100   Framingham 250498000733 1000310 Framingham - Walsh Middle   Regular School No Middle 06 08 2021   grade_7 148 9 86 0   16     0   7   127 139 *                     266.0 148 9 86 0   16     0   7   127 139                 266
1674876 1674876 MA Worcester   school 2505880 125   Harvard 250588000838 1250505 Harvard - Bromfield   Regular School No High 06 12 2021   grade_7 71 1 3 0   4     0   7   36 49 *                     86.0 71 1 3 0   4     0   7   36 49                 86
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
1675677 1675677 MA Hampden   school 2507050 161   Ludlow 250705001055 1610305 Ludlow - Paul R Baird Middle   Regular School No Middle 06 08 2021   grade_7 150 4 41 0   0     0   7   102 100 *                     202.0 150 4 41 0   0     0   7   102 100                 202
1675954 1675954 MA Essex   school 2507260 168   Marblehead 250726001789 1680300 Marblehead - Marblehead Veterans Middle School   Regular School No Middle 07 08 2021   grade_7 171 3 17 0   5     0   7   99 104 *                     203.0 171 3 17 0   5     0   7   99 104                 203
1676141 1676141 MA Norfolk   school 2507590 177   Medway 250759002483 1770305 Medway - Medway Middle   Regular School No Middle 05 08 2021   grade_7 150 4 9 0   7     1   7   70 108 *                     178.0 150 4 9 0   7     1   7   70 108                 178
1676205 1676205 MA Essex   school 2507740 181   Methuen 250774002558 1810050 Methuen - Comprehensive Grammar School   Regular School No Elementary PK 08 2021   grade_7 64 7 43 0   8     0   7   72 57 *                     129.0 64 7 43 0   8     0   7   72 57                 129
1676763 1676763 MA Berkshire   school 2508670 209   North Adams 250867001387 2090505 North Adams - Drury High   Regular School No High 07 12 2021   grade_7 68 8 7 0   0     1   7   45 46 *                     91.0 68 8 7 0   0     1   7   45 46                 91
1677791 1677791 MA Bristol   school 2510590 265   Seekonk 251059001700 2650405 Seekonk - Dr. Kevin M. Hurley Middle School   Regular School No Middle 06 08 2021   grade_7 110 5 13 0   14     0   7   74 73 *                     149.0 110 5 13 0   14     0   7   74 73                 149
1677985 1677985 MA Worcester   school 2510980 276   Southborough 251098001221 2760305 Southborough - P Brent Trottier   Regular School No Middle 06 08 2021   grade_7 78 2 12 0   25     0   7   61 63 *                     124.0 78 2 12 0   25     0   7   61 63                 124
1680071 1680071 MA Middlesex   school 2500055 470   Mystic Valley Regional Charter (District) 250005501260 4700105 Mystic Valley Regional Charter (District) - Mystic Valley Regional Charter School   Regular School Yes Other KG 12 2021   grade_7 64 34 8 0   36     0   7   79 70 *                     149.0 64 34 8 0   36     0   7   79 70                 149
1680117 1680117 MA Plymouth   school 2500057 483   Rising Tide Charter Public (District) 250005701271 4830305 Rising Tide Charter Public (District) - Rising Tide Charter Public School   Regular School Yes High 05 12 2021   grade_7 77 0 5 0   1     0   7   41 49 *                     90.0 77 0 5 0   1     0   7   41 49                 90
1680427 1680427 MA Worcester   school 2502715 622   Blackstone-Millville 250271501082 6220405 Blackstone-Millville - Frederick W. Hartnett Middle School   Regular School No Middle 06 08 2021   grade_7 109 3 11 0   2     0   7   61 71 *                     132.0 109 3 11 0   2     0   7   61 71                 132
1680450 1680450 MA Bristol   school 2503030 625   Bridgewater-Raynham 250303002659 6250320 Bridgewater-Raynham - Bridgewater Middle School   Regular School No Middle 07 08 2021   grade_7 211 22 8 0   7     0   7   128 127 *                     255.0 211 22 8 0   7     0   7   128 127                 255
1680583 1680583 MA Barnstable   school 2504560 660   Nauset 250456000609 6600305 Nauset - Nauset Regional Middle   Regular School No Middle 06 08 2021   grade_7 159 8 12 0   4     0   7   99 90 *                     190.0 159 8 12 0   4     0   7   99 90                 190
1680616 1680616 MA Franklin   school 2505100 670   Frontier 250510000749 6700505 Frontier - Frontier Regional   Regular School No High 07 12 2021   grade_7 90 2 13 0   2     0   7   67 47 *                     114.0 90 2 13 0   2     0   7   67 47                 114
1680679 1680679 MA Franklin   school 2505270 674   Gill-Montague 250527002386 6740310 Gill-Montague - Great Falls Middle   Regular School No Middle 06 08 2021   grade_7 62 1 11 0   0     1   7   47 35 *                     82.0 62 1 11 0   0     1   7   47 35                 82
1680730 1680730 MA Hampden   school 2505730 680   Hampden-Wilbraham 250573002141 6800310 Hampden-Wilbraham - Wilbraham Middle   Regular School No Middle 06 08 2021   grade_7 166 6 19 0   3     0   7   99 102 *                     201.0 166 6 19 0   3     0   7   99 102                 201
1680895 1680895 MA Worcester   school 2508280 720   Narragansett 250828001467 7200305 Narragansett - Narragansett Middle   Regular School No Middle 05 08 2021   grade_7 106 0 7 1   2     0   7   66 57 *                     123.0 106 0 7 1   2     0   7   66 57                 123
1672140 1672140 MA Essex   school 2501950 9   Andover 250195002510 90305 Andover - Doherty Middle   Regular School No Middle 06 08 2021   grade_7 112 1 11 0   12     0   6   66 76 *                     142.0 112 1 11 0   12     0   6   66 76                 142
1673709 1673709 MA Middlesex   school 2503270 49   Cambridge 250327002756 490320 Cambridge - Vassal Lane Upper School   Regular School No Middle 06 08 2021   grade_7 39 28 7 0   14     0   6   53 41 *                     94.0 39 28 7 0   14     0   6   53 41                 94
1673751 1673751 MA Middlesex   school 2503330 51   Carlisle 250333000457 510025 Carlisle - Carlisle School   Regular School No Elementary PK 08 2021   grade_7 61 0 2 0   9     0   6   43 35 *                     78.0 61 0 2 0   9     0   6   43 35                 78
1673794 1673794 MA Middlesex   school 2503510 56   Chelmsford 250351000478 560310 Chelmsford - McCarthy Middle School   Regular School No Middle 05 08 2021   grade_7 145 8 8 0   39     0   6   101 105 *                     206.0 145 8 8 0   39     0   6   101 105                 206
1673823 1673823 MA Suffolk   school 2503540 57   Chelsea 250354001772 570045 Chelsea - Eugene Wright Science and Technology Academy   Regular School No Middle 05 08 2021   grade_7 9 11 117 2   0     0   6   79 66 *                     145.0 9 11 117 2   0     0   6   79 66                 145
1674132 1674132 MA Middlesex   school 2504320 79   Dracut 250432001625 790410 Dracut - Justus C. Richardson Middle School   Regular School No Middle 06 08 2021   grade_7 219 24 33 0   21     0   6   143 160 *                     303.0 219 24 33 0   21     0   6   143 160                 303
1674338 1674338 MA Bristol   school 2504800 94   Fairhaven 250480002572 940305 Fairhaven - Hastings Middle   Regular School No Middle 06 08 2021   grade_7 121 6 12 1   4     0   6   76 74 *                     150.0 121 6 12 1   4     0   6   76 74                 150
1674742 1674742 MA Essex   school 2505280 107   Gloucester 250528000779 1070305 Gloucester - Ralph B O'Maley Middle   Regular School No Middle 06 08 2021   grade_7 166 2 23 1   3     0   6   104 97 *                     201.0 166 2 23 1   3     0   6   104 97                 201
1675028 1675028 MA Middlesex   school 2506240 136   Holliston 250624001304 1360305 Holliston - Robert H. Adams Middle School   Regular School No Middle 06 08 2021   grade_7 182 3 16 0   14     1   6   109 113 *                     222.0 182 3 16 0   14     1   6   109 113                 222
1675298 1675298 MA Essex   school 2506660 149   Lawrence 250666002654 1490525 Lawrence - Frost Middle School   Regular School No Middle 05 08 2021   grade_7 9 3 113 0   3     0   6   74 60 *                     134.0 9 3 113 0   3     0   6   74 60                 134
1675935 1675935 MA Bristol   school 2507230 167   Mansfield 250723001112 1670035 Mansfield - Harold L Qualters Middle   Regular School No Middle 06 08 2021   grade_7 225 12 23 0   17     0   6   150 133 *                     283.0 225 12 23 0   17     0   6   150 133                 283
1676045 1676045 MA Barnstable   school 2507440 172   Mashpee 250744002638 1720020 Mashpee - Mashpee Middle School   Regular School No Middle 07 08 2021   grade_7 89 5 5 8   2     0   6   58 57 *                     115.0 89 5 5 8   2     0   6   58 57                 115
1676407 1676407 MA Middlesex   school 2508340 198   Natick 250834001305 1980310 Natick - Wilson Middle   Regular School No Middle 05 08 2021   grade_7 175 15 6 1   21     0   6   118 106 *                     224.0 175 15 6 1   21     0   6   118 106                 224
1676950 1676950 MA Middlesex   school 2508820 217   North Reading 250882002592 2170305 North Reading - North Reading Middle   Regular School No Middle 06 08 2021   grade_7 159 1 11 0   13     0   6   80 110 *                     190.0 159 1 11 0   13     0   6   80 110                 190
1677430 1677430 MA Norfolk   school 2509870 243   Quincy 250987001381 2430325 Quincy - Point Webster Middle   Regular School No Middle 05 08 2021   grade_7 26 9 7 1   39     1   6   50 39 *                     89.0 26 9 7 1   39     1   6   50 39                 89
1678268 1678268 MA Hampden   school 2511130 281   Springfield 251113002600 2810325 Springfield - Forest Park Middle   Regular School No Middle 06 08 2021   grade_7 10 49 137 0   12     0   6   121 93 *                     214.0 10 49 137 0   12     0   6   121 93                 214
1678362 1678362 MA Middlesex   school 2511220 284   Stoneham 251122001857 2840405 Stoneham - Stoneham Central Middle School   Regular School No Middle 05 08 2021   grade_7 159 6 18 0   8     0   6   107 89 *                     197.0 159 6 18 0   8     0   6   107 89                 197
1678612 1678612 MA Middlesex   school 2511760 301   Tyngsborough 251176001715 3010305 Tyngsborough - Tyngsborough Middle   Regular School No Middle 06 08 2021   grade_7 112 10 5 0   16     0   6   83 66 *                     149.0 112 10 5 0   16     0   6   83 66                 149
1678659 1678659 MA Middlesex   school 2511910 305   Wakefield 251191000776 3050310 Wakefield - Galvin Middle School   Regular School No Middle 05 08 2021   grade_7 220 7 21 0   10     0   6   126 138 *                     264.0 220 7 21 0   10     0   6   126 138                 264
1678753 1678753 MA Middlesex   school 2512000 308   Waltham 251200001971 3080404 Waltham - John F Kennedy Middle   Regular School No Middle 06 08 2021   grade_7 105 19 45 0   10     0   6   109 76 *                     185.0 105 19 45 0   10     0   6   109 76                 185
1679037 1679037 MA Middlesex   school 2512660 326   Westford 251266000170 3260310 Westford - Blanchard Middle   Regular School No Middle 06 08 2021   grade_7 102 3 7 1   50     0   6   79 90 *                     169.0 102 3 7 1   50     0   6   79 90                 169
1679082 1679082 MA Bristol   school 2512780 331   Westport 251278002861 3310515 Westport - Westport Junior/Senior High School   Regular School No High 07 12 2021   grade_7 98 0 2 0   0     0   6   61 45 *                     106.0 98 0 2 0   0     0   6   61 45                 106
1679375 1679375 MA Middlesex   school 2513200 347   Woburn 251320002186 3470405 Woburn - John F Kennedy Middle School   Regular School No Middle 06 08 2021   grade_7 94 19 10 0   13     2   6   71 73 *                     144.0 94 19 10 0   13     2   6   71 73                 144
1680227 1680227 MA Hampshire   school 2500517 497   Pioneer Valley Chinese Immersion Charter (District) 250051702619 4970205 Pioneer Valley Chinese Immersion Charter (District) - Pioneer Valley Chinese Immersion Charter School   Regular School Yes Other KG 12 2021   grade_7 18 11 9 0   11     0   6   30 25 *                     55.0 18 11 9 0   11     0   6   30 25                 55
1680571 1680571 MA Worcester   school 2504360 658   Dudley-Charlton Reg 250436001595 6580305 Dudley-Charlton Reg - Dudley Middle School   Regular School No Middle 05 08 2021   grade_7 116 6 15 1   1     0   6   63 82 *                     145.0 116 6 15 1   1     0   6   63 82                 145
1680923 1680923 MA Worcester   school 2508310 725   Nashoba 250831001102 7250025 Nashoba - Florence Sawyer School   Regular School No Elementary PK 08 2021   grade_7 68 1 2 0   0     0   6   38 39 *                     77.0 68 1 2 0   0     0   6   38 39                 77
1681142 1681142 MA Worcester   school 2500002 767   Spencer-E Brookfield 250000200639 7670415 Spencer-E Brookfield - Knox Trail Middle School   Regular School No Middle 05 08 2021   grade_7 99 4 17 0   2     0   6   66 62 *                     128.0 99 4 17 0   2     0   6   66 62                 128
1681489 1681489 MA Plymouth   school 2500559 3513   New Heights Charter School of Brockton (District) 250055902869 35130305 New Heights Charter School of Brockton (District) - New Heights Charter School of Brockton   Regular School Yes High 06 12 2021   grade_7 1 105 9 0   1     0   6   60 62 *                     122.0 1 105 9 0   1     0   6   60 62                 122
1672289 1672289 MA Norfolk   school 2502250 18   Avon 250225001295 180510 Avon - Avon Middle High School   Regular School No High 07 12 2021   grade_7 28 14 5 3   4     0   5   33 26 *                     59.0 28 14 5 3   4     0   5   33 26                 59
1672413 1672413 MA Bristol   school 2502520 27   Berkley 250252001613 270305 Berkley - Berkley Middle School   Regular School No Middle 05 08 2021   grade_7 104 0 0 0   0     0   5   56 53 *                     109.0 104 0 0 0   0     0   5   56 53                 109
1673120 1673120 MA Suffolk   school 2502790 35   Boston 250279000952 350426 Boston - Dr. William Henderson Upper   Regular School No Other 02 12 2021   grade_7 6 33 19 0   0     0   5   34 29 *                     63.0 6 33 19 0   0     0   5   34 29                 63

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