enrollments

Data source: Big Local News · About: Big Local

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

✎ 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
1674757 1674757 MA Dukes   school 2505340 109   Gosnold 250534000725 1090005 Gosnold - Cuttyhunk Elementary   Regular School No Middle 07 07 2021   grade_7 * * * *   *     *   *   * * *                     2.0                                             2
1675705 1675705 MA Worcester   school 2507080 162   Lunenburg 250708002882 1620605 Lunenburg - Advanced Community Experience Program   Special Education School No Ungraded UG UG 2021   grade_7 * * * *   *     *   *   * * *                     0.0                                             0
1676598 1676598 MA Bristol   school 2508430 201   New Bedford 250843002681 2010515 New Bedford - Whaling City Junior/Senior High School   Regular School No High 06 12 2021   grade_7 * * * *   *     *   *   1 1 *                     2.0                         1 1                 2
1672782 1672782 MA Suffolk   school 2502790 35   Boston 250279000272 350182 Boston - Joseph J Hurley   Regular School No Elementary PK 08 2021   grade_7 2 1 16 0   0     0   0   10 9 *                     19.0 2 1 16 0   0     0   0   10 9                 19
1675306 1675306 MA Essex   school 2506660 149   Lawrence 250666002625 1490537 Lawrence - School for Exceptional Studies   Regular School No Other KG 12 2021   grade_7 0 0 11 0   0     0   0   10 1 *                     11.0 0 0 11 0   0     0   0   10 1                 11
1676592 1676592 MA Bristol   school 2508430 201   New Bedford 250843002590 2010510 New Bedford - Trinity Day Academy   Regular School No Other 04 12 2021   grade_7 6 4 2 0   0     0   0   10 2 *                     12.0 6 4 2 0   0     0   0   10 2                 12
1680113 1680113 MA Essex   school 2500062 482   River Valley Charter (District) 250006201446 4820050 River Valley Charter (District) - River Valley Charter School   Regular School Yes Elementary KG 08 2021   grade_7 28 1 2 1   0     0   0   10 22 *                     32.0 28 1 2 1   0     0   0   10 22                 32
1674210 1674210 MA Hampden   school 2504500 87   East Longmeadow 250450000602 870305 East Longmeadow - Birchland Park   Regular School No Middle 06 08 2021   grade_7 159 7 8 0   19     0   11   100 104 *                     204.0 159 7 8 0   19     0   11   100 104                 204
1678261 1678261 MA Hampden   school 2511130 281   Springfield 251113002599 2810320 Springfield - John J Duggan Middle   Regular School No High 06 12 2021   grade_7 18 45 101 1   4     0   0   100 69 *                     169.0 18 45 101 1   4     0   0   100 69                 169
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
1677698 1677698 MA Barnstable   school 2510470 261   Sandwich 251047002824 2610305 Sandwich - Sandwich STEM Academy   Regular School No Middle 07 08 2021   grade_7 193 3 6 2   6     0   2   101 111 *                     212.0 193 3 6 2   6     0   2   101 111                 212
1677731 1677731 MA Essex   school 2510500 262   Saugus 251050001685 2620305 Saugus - Saugus Middle School   Regular School No Middle 06 08 2021   grade_7 145 18 40 1   7     1   5   101 116 *                     217.0 145 18 40 1   7     1   5   101 116                 217
1680308 1680308 MA Hampshire   school 2501920 605   Amherst-Pelham 250192000043 6050405 Amherst-Pelham - Amherst Regional Middle School   Regular School No Middle 07 08 2021   grade_7 119 18 44 0   14     0   15   101 109 *                     210.0 119 18 44 0   14     0   15   101 109                 210
1672477 1672477 MA Middlesex   school 2502670 31   Billerica 250267000183 310305 Billerica - Marshall Middle School   Regular School No Middle 05 07 2021   grade_7 155 14 18 0   13     0   4   102 102 *                     204.0 155 14 18 0   13     0   4   102 102                 204
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
1676403 1676403 MA Middlesex   school 2508340 198   Natick 250834001297 1980305 Natick - J F Kennedy Middle School   Regular School No Middle 05 08 2021   grade_7 147 0 15 0   21     0   4   102 85 *                     187.0 147 0 15 0   21     0   4   102 85                 187
1676796 1676796 MA Hampshire   school 2508850 210   Northampton 250885001430 2100410 Northampton - John F Kennedy Middle School   Regular School No Middle 06 08 2021   grade_7 142 9 33 0   4     0   18   102 103 *                     206.0 142 9 33 0   4     0   18   102 103                 206
1677174 1677174 MA Plymouth   school 2509420 231   Pembroke 250942001823 2310305 Pembroke - Pembroke Community Middle School   Regular School No Middle 07 08 2021   grade_7 193 1 1 0   1     0   5   102 99 *                     201.0 193 1 1 0   1     0   5   102 99                 201
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
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
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
1674861 1674861 MA Plymouth   school 2505790 122   Hanover 250579002548 1220305 Hanover - Hanover Middle   Regular School No Middle 05 08 2021   grade_7 170 1 8 0   4     0   0   103 80 *                     183.0 170 1 8 0   4     0   0   103 80                 183
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
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
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
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
1676909 1676909 MA Worcester   school 2508940 214   Northbridge 250894002591 2140305 Northbridge - Northbridge Middle   Regular School No Middle 05 08 2021   grade_7 164 1 19 0   2     0   5   105 86 *                     191.0 164 1 19 0   2     0   5   105 86                 191
1677558 1677558 MA Suffolk   school 2510050 248   Revere 251005001976 2480057 Revere - Garfield Middle School   Regular School No Middle 06 08 2021   grade_7 65 7 112 0   8     0   1   106 87 *                     193.0 65 7 112 0   8     0   1   106 87                 193
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
1674614 1674614 MA Middlesex   school 2504980 100   Framingham 250498001530 1000302 Framingham - Cameron Middle School   Regular School No Middle 06 08 2021   grade_7 136 13 42 0   2     0   10   107 96 *                     203.0 136 13 42 0   2     0   10   107 96                 203
1677318 1677318 MA Plymouth   school 2509720 239   Plymouth 250972001380 2390305 Plymouth - Plymouth South Middle   Regular School No Middle 06 08 2021   grade_7 196 2 7 1   0     0   5   107 104 *                     211.0 196 2 7 1   0     0   5   107 104                 211
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
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
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
1677421 1677421 MA Norfolk   school 2509870 243   Quincy 250987001564 2430315 Quincy - Central Middle   Regular School No Middle 06 08 2021   grade_7 93 7 7 0   103     2   5   109 108 *                     217.0 93 7 7 0   103     2   5   109 108                 217
1677770 1677770 MA Plymouth   school 2510560 264   Scituate 251056001690 2640305 Scituate - Gates Middle School   Regular School No Middle 06 08 2021   grade_7 186 7 3 0   2     0   5   109 94 *                     203.0 186 7 3 0   2     0   5   109 94                 203
1677888 1677888 MA Bristol   school 2510860 273   Somerset 251086002537 2730305 Somerset - Somerset Middle School   Regular School No Middle 06 08 2021   grade_7 198 3 12 1   4     0   5   109 114 *                     223.0 198 3 12 1   4     0   5   109 114                 223
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
1680802 1680802 MA Worcester   school 2507680 710   Mendon-Upton 250768001279 7100015 Mendon-Upton - Miscoe Hill School   Regular School No Middle 05 08 2021   grade_7 172 0 11 0   7     0   5   109 86 *                     195.0 172 0 11 0   7     0   5   109 86                 195
1681538 1681538 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_7 159 15 40 0   11     1   15   109 132 *                     241.0 159 15 40 0   11     1   15   109 132                 241
1674531 1674531 MA Berkshire   school 2504920 98   Florida 250492000706 980005 Florida - Abbott Memorial   Regular School No Elementary PK 08 2021   grade_7 18 0 0 0   0     0   0   11 7 *                     18.0 18 0 0 0   0     0   0   11 7                 18
1677346 1677346 MA Barnstable   school 2509840 242   Provincetown 250984002694 2420020 Provincetown - Provincetown Schools   Regular School No Elementary PK 08 2021   grade_7 10 3 2 0   0     0   3   11 7 *                     18.0 10 3 2 0   0     0   3   11 7                 18
1678276 1678276 MA Hampden   school 2511130 281   Springfield 251113002740 2810345 Springfield - Springfield Public Day Middle School   Regular School No Middle 06 08 2021   grade_7 1 4 7 0   0     0   0   11 1 *                     12.0 1 4 7 0   0     0   0   11 1                 12
1678587 1678587 MA Dukes   school 2512570 296   Tisbury 251257002054 2960005 Tisbury - Tisbury Elementary   Regular School No Elementary PK 08 2021   grade_7 17 1 19 0   0     0   1   11 27 *                     38.0 17 1 19 0   0     0   1   11 27                 38
1673605 1673605 MA Middlesex   school 2503240 48   Burlington 250324000429 480303 Burlington - Marshall Simonds Middle   Regular School No Middle 06 08 2021   grade_7 172 20 10 0   33     0   4   110 129 *                     239.0 172 20 10 0   33     0   4   110 129                 239
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
1677677 1677677 MA Essex   school 2510380 258   Salem 251038002404 2580305 Salem - Collins Middle   Regular School No Middle 06 08 2021   grade_7 97 18 87 0   8     0   12   111 111 *                     222.0 97 18 87 0   8     0   12   111 111                 222
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
1679158 1679158 MA Norfolk   school 2512810 335   Westwood 251281002097 3350305 Westwood - E W Thurston Middle   Regular School No Middle 06 08 2021   grade_7 154 5 15 1   26     0   10   113 98 *                     211.0 154 5 15 1   26     0   10   113 98                 211
1673466 1673466 MA Plymouth   school 2503090 44   Brockton 250309000410 440420 Brockton - West Middle School   Regular School No Middle 06 08 2021   grade_7 33 131 34 1   7     0   14   115 105 *                     220.0 33 131 34 1   7     0   14   115 105                 220
1674551 1674551 MA Norfolk   school 2504950 99   Foxborough 250495000709 990405 Foxborough - John J Ahern   Regular School No Middle 05 08 2021   grade_7 172 13 16 1   8     0   5   115 100 *                     215.0 172 13 16 1   8     0   5   115 100                 215
1673196 1673196 MA Suffolk   school 2502790 35   Boston 250279000204 350545 Boston - Boston Latin Academy   Regular School No High 07 12 2021   grade_7 88 45 68 0   42     0   14   116 140 *                     257.0 88 45 68 0   42     0   14   116 140                 257
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
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
1678756 1678756 MA Middlesex   school 2512000 308   Waltham 251200001977 3080415 Waltham - John W. McDevitt Middle School   Regular School No Middle 06 08 2021   grade_7 68 15 128 0   7     0   4   116 106 *                     222.0 68 15 128 0   7     0   4   116 106                 222
1680981 1680981 MA Plymouth   school 2509150 740   Old Rochester 250915001473 7400405 Old Rochester - Old Rochester Regional Jr High   Regular School No Middle 07 08 2021   grade_7 184 2 2 0   2     0   13   117 86 *                     203.0 184 2 2 0   2     0   13   117 86                 203
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
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
1680610 1680610 MA Bristol   school 2505070 665   Freetown-Lakeville 250507000748 6650305 Freetown-Lakeville - Freetown-Lakeville Middle School   Regular School No Middle 06 09 2021   grade_7 220 4 0 0   2     0   3   118 111 *                     229.0 220 4 0 0   2     0   3   118 111                 229
1673970 1673970 MA Middlesex   school 2503840 67   Concord 250384000522 670305 Concord - Concord Middle   Regular School No Middle 06 08 2021   grade_7 165 18 19 0   16     0   12   119 111 *                     230.0 165 18 19 0   16     0   12   119 111                 230
1672527 1672527 MA Suffolk   school 2502790 35   Boston 250279002687 350012 Boston - Boston Teachers Union School   Regular School No Elementary PK 08 2021   grade_7 4 11 13 0   3     0   0   12 19 *                     31.0 4 11 13 0   3     0   0   12 19                 31
1673040 1673040 MA Suffolk   school 2502790 35   Boston 250279000343 350370 Boston - William Monroe Trotter   Regular School No Elementary PK 08 2021   grade_7 0 14 12 0   0     0   0   12 14 *                     26.0 0 14 12 0   0     0   0   12 14                 26
1679767 1679767 MA Suffolk   school 2500527 417   Bridge Boston Charter School (District) 250052702710 4170205 Bridge Boston Charter School (District) - Bridge Boston Charter School   Regular School Yes Elementary PK 08 2021   grade_7 0 17 10 0   0     0   0   12 15 *                     27.0 0 17 10 0   0     0   0   12 15                 27
1679838 1679838 MA Essex   school 2500535 431   Community Day Charter Public School - R. Kingman Webster (District) 250053502719 4310205 Community Day Charter Public School - R. Kingman Webster (District) - Community Day Charter Public School - R. Kingman Webster   Regular School Yes Elementary PK 08 2021   grade_7 3 2 29 0   1     0   0   12 23 *                     35.0 3 2 29 0   1     0   0   12 23                 35
1679870 1679870 MA Suffolk   school 2500070 438   Codman Academy Charter Public (District) 250007001667 4380505 Codman Academy Charter Public (District) - Codman Academy Charter Public School   Regular School Yes Other PK 12 2021   grade_7 0 18 4 0   0     0   0   12 10 *                     22.0 0 18 4 0   0     0   0   12 10                 22
1680720 1680720 MA Hampden   school 2505730 680   Hampden-Wilbraham 250573000822 6800005 Hampden-Wilbraham - Green Meadows Elementary   Regular School No Elementary PK 08 2021   grade_7 9 1 3 0   0     0   2   12 3 *                     15.0 9 1 3 0   0     0   2   12 3                 15
1674951 1674951 MA Essex   school 2505970 128   Haverhill 250597000850 1280100 Haverhill - Consentino Middle School   Regular School No Middle 05 08 2021   grade_7 81 10 115 0   6     0   4   120 96 *                     216.0 81 10 115 0   6     0   4   120 96                 216
1673469 1673469 MA Plymouth   school 2503090 44   Brockton 250309002688 440421 Brockton - Ashfield Middle School   Regular School No Middle 06 08 2021   grade_7 53 106 34 1   10     0   5   121 88 *                     209.0 53 106 34 1   10     0   5   121 88                 209
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
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
1678539 1678539 MA Bristol   school 2511520 293   Taunton 251152001911 2930042 Taunton - Joseph H Martin   Regular School No Middle 05 07 2021   grade_7 145 39 26 0   2     0   13   121 104 *                     225.0 145 39 26 0   2     0   13   121 104                 225
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
1680518 1680518 MA Barnstable   school 2504140 645   Dennis-Yarmouth 250414000562 6450305 Dennis-Yarmouth - Mattacheese Middle School   Regular School No Middle 06 07 2021   grade_7 131 31 45 7   4     1   13   122 110 *                     232.0 131 31 45 7   4     1   13   122 110                 232
1673463 1673463 MA Plymouth   school 2503090 44   Brockton 250309000407 440415 Brockton - South Middle School   Regular School No Middle 06 08 2021   grade_7 23 134 31 0   2     0   13   123 80 *                     203.0 23 134 31 0   2     0   13   123 80                 203
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
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
1673472 1673472 MA Plymouth   school 2503090 44   Brockton 250309002691 440422 Brockton - Joseph F. Plouffe Academy   Regular School No Middle 06 08 2021   grade_7 49 104 71 2   11     0   11   124 124 *                     248.0 49 104 71 2   11     0   11   124 124                 248
1673459 1673459 MA Plymouth   school 2503090 44   Brockton 250309000389 440405 Brockton - East Middle School   Regular School No Middle 06 08 2021   grade_7 27 144 47 1   3     0   10   125 107 *                     232.0 27 144 47 1   3     0   10   125 107                 232
1674041 1674041 MA Bristol   school 2504020 72   Dartmouth 250402000541 720050 Dartmouth - Dartmouth Middle   Regular School No Middle 06 08 2021   grade_7 247 3 17 0   1     0   12   125 155 *                     280.0 247 3 17 0   1     0   12   125 155                 280
1676244 1676244 MA Plymouth   school 2507770 182   Middleborough 250777001378 1820305 Middleborough - John T. Nichols Middle   Regular School No Middle 06 08 2021   grade_7 221 6 9 1   1     0   18   125 131 *                     256.0 221 6 9 1   1     0   18   125 131                 256
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
1681254 1681254 MA Worcester   school 2511880 775   Wachusett 251188000888 7750305 Wachusett - Mountview Middle   Regular School No Middle 06 08 2021   grade_7 199 12 17 0   8     0   10   126 120 *                     246.0 199 12 17 0   8     0   10   126 120                 246
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
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
1681080 1681080 MA Plymouth   school 2510830 760   Silver Lake 251083001721 7600405 Silver Lake - Silver Lake Regional Middle School   Regular School No Middle 07 08 2021   grade_7 246 0 9 2   3     0   4   128 135 *                     264.0 246 0 9 2   3     0   4   128 135                 264
1676714 1676714 MA Middlesex   school 2508610 207   Newton 250861000310 2070310 Newton - Charles E Brown Middle   Regular School No Middle 06 08 2021   grade_7 168 3 12 1   58     0   11   129 124 *                     253.0 168 3 12 1   58     0   11   129 124                 253
1672624 1672624 MA Suffolk   school 2502790 35   Boston 250279000223 350077 Boston - Dennis C Haley   Regular School No Elementary PK 08 2021   grade_7 2 12 7 0   0     0   3   13 11 *                     24.0 2 12 7 0   0     0   3   13 11                 24
1673276 1673276 MA Suffolk   school 2502790 35   Boston 250279000312 350691 Boston - Rafael Hernandez   Regular School No Elementary PK 08 2021   grade_7 1 0 27 0   0     0   1   13 16 *                     29.0 1 0 27 0   0     0   1   13 16                 29
1673917 1673917 MA Berkshire   school 2503720 63   Clarksburg 250372000510 630010 Clarksburg - Clarksburg Elementary   Regular School No Elementary KG 08 2021   grade_7 30 0 0 0   0     0   0   13 17 *                     30.0 30 0 0 0   0     0   0   13 17                 30
1678294 1678294 MA Hampden   school 2511130 281   Springfield 251113002818 2810475 Springfield - Conservatory of the Arts   Regular School No High 06 12 2021   grade_7 10 5 36 0   0     0   2   13 40 *                     53.0 10 5 36 0   0     0   2   13 40                 53
1674471 1674471 MA Barnstable   school 2504860 96   Falmouth 250486000687 960405 Falmouth - Lawrence   Regular School No Middle 07 08 2021   grade_7 197 9 15 9   3     0   20   131 122 *                     253.0 197 9 15 9   3     0   20   131 122                 253
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
1674422 1674422 MA Bristol   school 2504830 95   Fall River 250483000672 950315 Fall River - Morton Middle   Regular School No Middle 06 08 2021   grade_7 127 22 59 1   10     0   16   132 103 *                     235.0 127 22 59 1   10     0   16   132 103                 235
1678572 1678572 MA Middlesex   school 2511580 295   Tewksbury 251158000366 2950305 Tewksbury - John W. Wynn Middle   Regular School No Middle 07 08 2021   grade_7 228 8 15 1   4     0   5   132 129 *                     261.0 228 8 15 1   4     0   5   132 129                 261
1677529 1677529 MA Suffolk   school 2510050 248   Revere 251005001963 2480014 Revere - Rumney Marsh Academy   Regular School No Middle 06 08 2021   grade_7 86 8 110 0   9     0   4   133 84 *                     217.0 86 8 110 0   9     0   4   133 84                 217
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
1676180 1676180 MA Middlesex   school 2507620 178   Melrose 250762002557 1780305 Melrose - Melrose Middle   Regular School No Middle 06 08 2021   grade_7 215 20 15 0   18     0   10   134 144 *                     278.0 215 20 15 0   18     0   10   134 144                 278
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
1673736 1673736 MA Norfolk   school 2503300 50   Canton 250330000456 500305 Canton - Wm H Galvin Middle   Regular School No Middle 06 08 2021   grade_7 197 29 8 2   27     2   18   137 146 *                     283.0 197 29 8 2   27     2   18   137 146                 283
1673350 1673350 MA Norfolk   school 2502940 40   Braintree 250294000364 400305 Braintree - East Middle School   Regular School No Middle 05 08 2021   grade_7 180 21 17 0   53     1   3   138 137 *                     275.0 180 21 17 0   53     1   3   138 137                 275

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