enrollments

Data source: Big Local News · About: Big Local

499 rows where grade = "grade_8", state = "MA" and year = 2021 sorted by male

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

  • 2021 · 499 ✖

grade ✖

  • grade_8 · 499 ✖
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
1674758 1674758 MA Dukes   school 2505340 109   Gosnold 250534000725 1090005 Gosnold - Cuttyhunk Elementary   Regular School No Middle 07 07 2021   grade_8 * * * *   *     *   *   * * *                     0.0                                             0
1675706 1675706 MA Worcester   school 2507080 162   Lunenburg 250708002882 1620605 Lunenburg - Advanced Community Experience Program   Special Education School No Ungraded UG UG 2021   grade_8 * * * *   *     *   *   * * *                     0.0                                             0
1680452 1680452 MA Bristol   school 2503030 625   Bridgewater-Raynham 250303002866 6250415 Bridgewater-Raynham - Therapeutic Day School   Special Education School No High 07 12 2021   grade_8 * * * *   *     *   *   1 * *                     1.0                         1                   1
1673104 1673104 MA Suffolk   school 2502790 35   Boston 250279000946 350382 Boston - Mission Hill School   Regular School No Elementary PK 08 2021   grade_8 3 2 12 0   0     0   1   10 8 *                     18.0 3 2 12 0   0     0   1   10 8                 18
1678142 1678142 MA Hampden   school 2511130 281   Springfield 251113001809 2810095 Springfield - Alfred G. Zanetti Montessori Magnet School   Regular School No Elementary PK 08 2021   grade_8 7 2 17 0   0     0   1   10 17 *                     27.0 7 2 17 0   0     0   1   10 17                 27
1680006 1680006 MA Essex   school 2500083 455   Hill View Montessori Charter Public (District) 250008301846 4550050 Hill View Montessori Charter Public (District) - Hill View Montessori Charter Public School   Regular School Yes Elementary KG 08 2021   grade_8 20 2 9 0   1     0   0   10 22 *                     32.0 20 2 9 0   1     0   0   10 22                 32
1680114 1680114 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_8 27 0 0 0   1     0   3   10 21 *                     31.0 27 0 0 0   1     0   3   10 21                 31
1676951 1676951 MA Middlesex   school 2508820 217   North Reading 250882002592 2170305 North Reading - North Reading Middle   Regular School No Middle 06 08 2021   grade_8 168 0 8 0   6     0   3   100 85 *                     185.0 168 0 8 0   6     0   3   100 85                 185
1672349 1672349 MA Hampshire   school 2502430 24   Belchertown 250243001873 240025 Belchertown - Jabish Middle School   Regular School No Middle 07 08 2021   grade_8 165 7 7 0   3     1   4   101 85 *                     187.0 165 7 7 0   3     1   4   101 85                 187
1674162 1674162 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_8 148 14 2 1   0     1   6   102 70 *                     172.0 148 14 2 1   0     1   6   102 70                 172
1675159 1675159 MA Middlesex   school 2506390 141   Hudson 250639000926 1410505 Hudson - Hudson High   Regular School No High 08 12 2021   grade_8 164 6 26 0   2     0   8   102 104 *                     206.0 164 6 26 0   2     0   8   102 104                 206
1675649 1675649 MA Middlesex   school 2507020 160   Lowell 250702000086 1600345 Lowell - Dr An Wang School   Regular School No Middle 05 08 2021   grade_8 52 13 69 0   29     0   8   102 69 *                     171.0 52 13 69 0   29     0   8   102 69                 171
1676216 1676216 MA Essex   school 2507740 181   Methuen 250774001556 1810055 Methuen - Tenney Grammar School   Regular School No Elementary PK 08 2021   grade_8 54 7 103 0   6     0   7   102 75 *                     177.0 54 7 103 0   6     0   7   102 75                 177
1681013 1681013 MA Essex   school 2509450 745   Pentucket 250945001512 7450405 Pentucket - Pentucket Regional Middle   Regular School No Middle 07 08 2021   grade_8 184 1 13 0   1     0   4   102 101 *                     203.0 184 1 13 0   1     0   4   102 101                 203
1674423 1674423 MA Bristol   school 2504830 95   Fall River 250483000672 950315 Fall River - Morton Middle   Regular School No Middle 06 08 2021   grade_8 125 20 48 1   6     1   18   103 116 *                     219.0 125 20 48 1   6     1   18   103 116                 219
1677608 1677608 MA Plymouth   school 2510170 251   Rockland 251017001642 2510305 Rockland - John W Rogers Middle   Regular School No Middle 05 08 2021   grade_8 136 11 33 0   2     0   11   103 90 *                     193.0 136 11 33 0   2     0   11   103 90                 193
1678504 1678504 MA Bristol   school 2511460 292   Swansea 251146001894 2920305 Swansea - Joseph Case Jr High   Regular School No Middle 06 08 2021   grade_8 178 3 5 0   0     0   3   103 86 *                     189.0 178 3 5 0   0     0   3   103 86                 189
1672274 1672274 MA Worcester   school 2502220 17   Auburn 250222002567 170305 Auburn - Auburn Middle   Regular School No Middle 06 08 2021   grade_8 152 5 26 0   10     0   9   104 98 *                     202.0 152 5 26 0   10     0   9   104 98                 202
1673795 1673795 MA Middlesex   school 2503510 56   Chelmsford 250351000478 560310 Chelmsford - McCarthy Middle School   Regular School No Middle 05 08 2021   grade_8 127 7 11 0   22     0   10   104 73 *                     177.0 127 7 11 0   22     0   10   104 73                 177
1678484 1678484 MA Essex   school 2511430 291   Swampscott 251143002562 2910305 Swampscott - Swampscott Middle   Regular School No Middle 05 08 2021   grade_8 152 4 15 2   2     0   9   105 79 *                     184.0 152 4 15 2   2     0   9   105 79                 184
1680611 1680611 MA Bristol   school 2505070 665   Freetown-Lakeville 250507000748 6650305 Freetown-Lakeville - Freetown-Lakeville Middle School   Regular School No Middle 06 09 2021   grade_8 213 8 4 1   4     0   4   105 129 *                     234.0 213 8 4 1   4     0   4   105 129                 234
1676991 1676991 MA Plymouth   school 2509030 219   Norwell 250903001456 2190405 Norwell - Norwell Middle School   Regular School No Middle 06 08 2021   grade_8 169 0 2 0   5     0   4   106 74 *                     180.0 169 0 2 0   5     0   4   106 74                 180
1677416 1677416 MA Norfolk   school 2509870 243   Quincy 250987001561 2430305 Quincy - Atlantic Middle   Regular School No Middle 06 08 2021   grade_8 67 4 8 0   111     0   3   106 87 *                     193.0 67 4 8 0   111     0   3   106 87                 193
1680731 1680731 MA Hampden   school 2505730 680   Hampden-Wilbraham 250573002141 6800310 Hampden-Wilbraham - Wilbraham Middle   Regular School No Middle 06 08 2021   grade_8 174 5 14 0   7     0   5   106 99 *                     205.0 174 5 14 0   7     0   5   106 99                 205
1674686 1674686 MA Worcester   school 2505130 103   Gardner 250513000751 1030505 Gardner - Gardner High   Regular School No High 08 12 2021   grade_8 127 5 46 0   5     0   22   107 97 *                     205.0 127 5 46 0   5     0   22   107 97                 205
1679041 1679041 MA Middlesex   school 2512660 326   Westford 251266002080 3260330 Westford - Stony Brook School   Regular School No Middle 06 08 2021   grade_8 134 2 6 0   48     0   7   107 90 *                     197.0 134 2 6 0   48     0   7   107 90                 197
1680803 1680803 MA Worcester   school 2507680 710   Mendon-Upton 250768001279 7100015 Mendon-Upton - Miscoe Hill School   Regular School No Middle 05 08 2021   grade_8 180 0 14 0   7     0   7   107 101 *                     208.0 180 0 14 0   7     0   7   107 101                 208
1673737 1673737 MA Norfolk   school 2503300 50   Canton 250330000456 500305 Canton - Wm H Galvin Middle   Regular School No Middle 06 08 2021   grade_8 161 34 7 0   28     0   13   108 135 *                     243.0 161 34 7 0   28     0   13   108 135                 243
1676721 1676721 MA Middlesex   school 2508610 207   Newton 250861001042 2070320 Newton - Oak Hill Middle   Regular School No Middle 06 08 2021   grade_8 107 7 10 0   55     0   13   108 84 *                     192.0 107 7 10 0   55     0   13   108 84                 192
1677792 1677792 MA Bristol   school 2510590 265   Seekonk 251059001700 2650405 Seekonk - Dr. Kevin M. Hurley Middle School   Regular School No Middle 06 08 2021   grade_8 161 2 8 0   3     0   9   108 74 *                     183.0 161 2 8 0   3     0   9   108 74                 183
1681184 1681184 MA Essex   school 2511740 773   Triton 251174001470 7730405 Triton - Triton Regional Middle School   Regular School No Middle 07 08 2021   grade_8 168 0 7 0   9     0   5   109 80 *                     189.0 168 0 7 0   9     0   5   109 80                 189
1673041 1673041 MA Suffolk   school 2502790 35   Boston 250279000343 350370 Boston - William Monroe Trotter   Regular School No Elementary PK 08 2021   grade_8 1 12 5 0   0     0   1   11 8 *                     19.0 1 12 5 0   0     0   1   11 8                 19
1679768 1679768 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_8 0 12 5 0   0     0   3   11 9 *                     20.0 0 12 5 0   0     0   3   11 9                 20
1680043 1680043 MA Dukes   school 2500035 466   Martha's Vineyard Charter (District) 250003500569 4660550 Martha's Vineyard Charter (District) - Martha's Vineyard Charter School   Regular School Yes Other KG 12 2021   grade_8 13 0 4 0   0     0   3   11 9 *                     20.0 13 0 4 0   0     0   3   11 9                 20
1672212 1672212 MA Middlesex   school 2502100 14   Ashland 250210000938 140405 Ashland - Ashland Middle   Regular School No Middle 06 08 2021   grade_8 142 7 33 0   28     0   8   110 108 *                     218.0 142 7 33 0   28     0   8   110 108                 218
1673791 1673791 MA Middlesex   school 2503510 56   Chelmsford 250351000476 560305 Chelmsford - Col Moses Parker School   Regular School No Middle 05 08 2021   grade_8 127 4 15 2   29     0   5   110 72 *                     182.0 127 4 15 2   29     0   5   110 72                 182
1674148 1674148 MA Plymouth   school 2504410 82   Duxbury 250441000975 820305 Duxbury - Duxbury Middle   Regular School No Middle 06 08 2021   grade_8 229 0 6 1   3     0   6   110 135 *                     245.0 229 0 6 1   3     0   6   110 135                 245
1677771 1677771 MA Plymouth   school 2510560 264   Scituate 251056001690 2640305 Scituate - Gates Middle School   Regular School No Middle 06 08 2021   grade_8 205 8 5 0   1     0   2   110 111 *                     221.0 205 8 5 0   1     0   2   110 111                 221
1674552 1674552 MA Norfolk   school 2504950 99   Foxborough 250495000709 990405 Foxborough - John J Ahern   Regular School No Middle 05 08 2021   grade_8 175 15 6 1   7     0   5   111 98 *                     209.0 175 15 6 1   7     0   5   111 98                 209
1675678 1675678 MA Hampden   school 2507050 161   Ludlow 250705001055 1610305 Ludlow - Paul R Baird Middle   Regular School No Middle 06 08 2021   grade_8 174 4 23 0   0     0   8   111 98 *                     209.0 174 4 23 0   0     0   8   111 98                 209
1677468 1677468 MA Norfolk   school 2509930 244   Randolph 250993001392 2440410 Randolph - Randolph Community Middle   Regular School No Middle 06 08 2021   grade_8 26 81 42 1   49     0   12   111 100 *                     211.0 26 81 42 1   49     0   12   111 100                 211
1678843 1678843 MA Middlesex   school 2512210 315   Wayland 251221002502 3150305 Wayland - Wayland Middle School   Regular School No Middle 06 08 2021   grade_8 159 14 11 0   44     0   12   111 129 *                     240.0 159 14 11 0   44     0   12   111 129                 240
1677732 1677732 MA Essex   school 2510500 262   Saugus 251050001685 2620305 Saugus - Saugus Middle School   Regular School No Middle 06 08 2021   grade_8 136 8 44 1   11     2   4   112 94 *                     206.0 136 8 44 1   11     2   4   112 94                 206
1673464 1673464 MA Plymouth   school 2503090 44   Brockton 250309000407 440415 Brockton - South Middle School   Regular School No Middle 06 08 2021   grade_8 26 142 30 0   0     0   6   113 91 *                     204.0 26 142 30 0   0     0   6   113 91                 204
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
1674621 1674621 MA Middlesex   school 2504980 100   Framingham 250498000733 1000310 Framingham - Walsh Middle   Regular School No Middle 06 08 2021   grade_8 132 12 74 0   9     0   17   114 130 *                     244.0 132 12 74 0   9     0   17   114 130                 244
1677699 1677699 MA Barnstable   school 2510470 261   Sandwich 251047002824 2610305 Sandwich - Sandwich STEM Academy   Regular School No Middle 07 08 2021   grade_8 208 5 2 1   3     0   3   114 107 *                     222.0 208 5 2 1   3     0   3   114 107                 222
1677889 1677889 MA Bristol   school 2510860 273   Somerset 251086002537 2730305 Somerset - Somerset Middle School   Regular School No Middle 06 08 2021   grade_8 187 3 14 1   3     0   4   114 98 *                     212.0 187 3 14 1   3     0   4   114 98                 212
1680982 1680982 MA Plymouth   school 2509150 740   Old Rochester 250915001473 7400405 Old Rochester - Old Rochester Regional Jr High   Regular School No Middle 07 08 2021   grade_8 185 6 3 0   4     0   13   114 97 *                     211.0 185 6 3 0   4     0   13   114 97                 211
1673354 1673354 MA Norfolk   school 2502940 40   Braintree 250294000372 400310 Braintree - South Middle School   Regular School No Middle 06 08 2021   grade_8 168 9 10 0   54     0   1   115 127 *                     242.0 168 9 10 0   54     0   1   115 127                 242
1677026 1677026 MA Norfolk   school 2509060 220   Norwood 250906001468 2200305 Norwood - Dr. Philip O. Coakley Middle School   Regular School No Middle 06 08 2021   grade_8 157 28 39 0   14     1   6   115 130 *                     245.0 157 28 39 0   14     1   6   115 130                 245
1679252 1679252 MA Middlesex   school 2513050 342   Wilmington 251305001578 3420330 Wilmington - Wilmington Middle School   Regular School No Middle 06 08 2021   grade_8 214 4 13 0   13     0   5   115 134 *                     249.0 214 4 13 0   13     0   5   115 134                 249
1680309 1680309 MA Hampshire   school 2501920 605   Amherst-Pelham 250192000043 6050405 Amherst-Pelham - Amherst Regional Middle School   Regular School No Middle 07 08 2021   grade_8 101 14 40 0   26     0   22   115 88 *                     203.0 101 14 40 0   26     0   22   115 88                 203
1680519 1680519 MA Barnstable   school 2504140 645   Dennis-Yarmouth 250414000558 6450505 Dennis-Yarmouth - Dennis-Yarmouth Regional High   Regular School No High 08 12 2021   grade_8 151 21 33 6   6     0   11   115 113 *                     228.0 151 21 33 6   6     0   11   115 113                 228
1674618 1674618 MA Middlesex   school 2504980 100   Framingham 250498000464 1000305 Framingham - Fuller Middle   Regular School No Middle 06 08 2021   grade_8 57 19 110 0   1     0   4   116 75 *                     191.0 57 19 110 0   1     0   4   116 75                 191
1677678 1677678 MA Essex   school 2510380 258   Salem 251038002404 2580305 Salem - Collins Middle   Regular School No Middle 06 08 2021   grade_8 84 15 95 0   7     0   5   117 89 *                     206.0 84 15 95 0   7     0   5   117 89                 206
1678817 1678817 MA Middlesex   school 2512180 314   Watertown 251218002501 3140305 Watertown - Watertown Middle   Regular School No Middle 06 08 2021   grade_8 150 8 23 2   19     0   8   117 93 *                     210.0 150 8 23 2   19     0   8   117 93                 210
1674952 1674952 MA Essex   school 2505970 128   Haverhill 250597000850 1280100 Haverhill - Consentino Middle School   Regular School No Middle 05 08 2021   grade_8 113 15 85 1   7     0   3   118 106 *                     224.0 113 15 85 1   7     0   3   118 106                 224
1678757 1678757 MA Middlesex   school 2512000 308   Waltham 251200001977 3080415 Waltham - John W. McDevitt Middle School   Regular School No Middle 06 08 2021   grade_8 68 20 136 0   13     0   3   118 122 *                     240.0 68 20 136 0   13     0   3   118 122                 240
1673197 1673197 MA Suffolk   school 2502790 35   Boston 250279000204 350545 Boston - Boston Latin Academy   Regular School No High 07 12 2021   grade_8 94 56 73 1   43     0   14   119 162 *                     281.0 94 56 73 1   43     0   14   119 162                 281
1672844 1672844 MA Suffolk   school 2502790 35   Boston 250279000291 350229 Boston - Maurice J Tobin   Regular School No Elementary PK 08 2021   grade_8 3 8 26 0   1     0   0   12 26 *                     38.0 3 8 26 0   1     0   0   12 26                 38
1673277 1673277 MA Suffolk   school 2502790 35   Boston 250279000312 350691 Boston - Rafael Hernandez   Regular School No Elementary PK 08 2021   grade_8 2 0 23 0   0     0   0   12 13 *                     25.0 2 0 23 0   0     0   0   12 13                 25
1673918 1673918 MA Berkshire   school 2503720 63   Clarksburg 250372000510 630010 Clarksburg - Clarksburg Elementary   Regular School No Elementary KG 08 2021   grade_8 20 0 0 0   0     0   2   12 10 *                     22.0 20 0 0 0   0     0   2   12 10                 22
1672335 1672335 MA Middlesex   school 2502400 23   Bedford 250240000130 230305 Bedford - John Glenn Middle   Regular School No Middle 06 08 2021   grade_8 141 10 12 1   41     0   1   120 86 *                     206.0 141 10 12 1   41     0   1   120 86                 206
1673606 1673606 MA Middlesex   school 2503240 48   Burlington 250324000429 480303 Burlington - Marshall Simonds Middle   Regular School No Middle 06 08 2021   grade_8 158 17 14 0   53     0   14   121 135 *                     256.0 158 17 14 0   53     0   14   121 135                 256
1675029 1675029 MA Middlesex   school 2506240 136   Holliston 250624001304 1360305 Holliston - Robert H. Adams Middle School   Regular School No Middle 06 08 2021   grade_8 195 0 14 0   14     0   7   121 109 *                     230.0 195 0 14 0   14     0   7   121 109                 230
1680449 1680449 MA Bristol   school 2503030 625   Bridgewater-Raynham 250303001674 6250315 Bridgewater-Raynham - Raynham Middle School   Regular School No Middle 05 08 2021   grade_8 158 14 4 0   4     0   8   122 65 *                     188.0 158 14 4 0   4     0   8   122 65                 188
1673971 1673971 MA Middlesex   school 2503840 67   Concord 250384000522 670305 Concord - Concord Middle   Regular School No Middle 06 08 2021   grade_8 177 11 12 0   25     0   11   123 113 *                     236.0 177 11 12 0   25     0   11   123 113                 236
1676408 1676408 MA Middlesex   school 2508340 198   Natick 250834001305 1980310 Natick - Wilson Middle   Regular School No Middle 05 08 2021   grade_8 181 10 12 0   15     0   16   123 111 *                     234.0 181 10 12 0   15     0   16   123 111                 234
1673351 1673351 MA Norfolk   school 2502940 40   Braintree 250294000364 400305 Braintree - East Middle School   Regular School No Middle 05 08 2021   grade_8 135 28 15 0   64     0   1   124 119 *                     243.0 135 28 15 0   64     0   1   124 119                 243
1677319 1677319 MA Plymouth   school 2509720 239   Plymouth 250972001380 2390305 Plymouth - Plymouth South Middle   Regular School No Middle 06 08 2021   grade_8 219 5 9 0   2     0   8   124 119 *                     243.0 219 5 9 0   2     0   8   124 119                 243
1674014 1674014 MA Essex   school 2503990 71   Danvers 250399002517 710305 Danvers - Holten Richmond Middle School   Regular School No Middle 06 08 2021   grade_8 215 10 23 0   3     0   8   126 133 *                     259.0 215 10 23 0   3     0   8   126 133                 259
1677175 1677175 MA Plymouth   school 2509420 231   Pembroke 250942001823 2310305 Pembroke - Pembroke Community Middle School   Regular School No Middle 07 08 2021   grade_8 222 0 5 0   2     0   1   126 104 *                     230.0 222 0 5 0   2     0   1   126 104                 230
1678269 1678269 MA Hampden   school 2511130 281   Springfield 251113002600 2810325 Springfield - Forest Park Middle   Regular School No Middle 06 08 2021   grade_8 26 41 149 0   10     0   7   126 107 *                     233.0 26 41 149 0   10     0   7   126 107                 233
1679159 1679159 MA Norfolk   school 2512810 335   Westwood 251281002097 3350305 Westwood - E W Thurston Middle   Regular School No Middle 06 08 2021   grade_8 178 5 9 0   28     0   3   126 97 *                     223.0 178 5 9 0   28     0   3   126 97                 223
1678573 1678573 MA Middlesex   school 2511580 295   Tewksbury 251158000366 2950305 Tewksbury - John W. Wynn Middle   Regular School No Middle 07 08 2021   grade_8 209 12 14 0   14     0   1   127 123 *                     250.0 209 12 14 0   14     0   1   127 123                 250
1673460 1673460 MA Plymouth   school 2503090 44   Brockton 250309000389 440405 Brockton - East Middle School   Regular School No Middle 06 08 2021   grade_8 24 188 31 2   3     0   10   128 130 *                     258.0 24 188 31 2   3     0   10   128 130                 258
1681539 1681539 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_8 170 18 57 0   6     0   20   128 143 *                     271.0 170 18 57 0   6     0   20   128 143                 271
1680126 1680126 MA Suffolk   school 2500063 484   Roxbury Preparatory Charter (District) 250006301453 4840505 Roxbury Preparatory Charter (District) - Roxbury Preparatory Charter School   Regular School Yes High 05 12 2021   grade_8 1 143 107 0   1     0   2   129 125 *                     254.0 1 143 107 0   1     0   2   129 125                 254
1681081 1681081 MA Plymouth   school 2510830 760   Silver Lake 251083001721 7600405 Silver Lake - Silver Lake Regional Middle School   Regular School No Middle 07 08 2021   grade_8 240 5 9 1   0     0   4   129 130 *                     259.0 240 5 9 1   0     0   4   129 130                 259
1672504 1672504 MA Suffolk   school 2502790 35   Boston 250279002458 350004 Boston - Lyon K-8   Regular School No Elementary KG 08 2021   grade_8 3 4 8 0   1     0   1   13 4 *                     17.0 3 4 8 0   1     0   1   13 4                 17
1672783 1672783 MA Suffolk   school 2502790 35   Boston 250279000272 350182 Boston - Joseph J Hurley   Regular School No Elementary PK 08 2021   grade_8 0 1 19 0   0     0   0   13 7 *                     20.0 0 1 19 0   0     0   0   13 7                 20
1672912 1672912 MA Suffolk   school 2502790 35   Boston 250279000692 350262 Boston - Lyndon   Regular School No Elementary PK 08 2021   grade_8 4 6 16 0   0     0   1   13 14 *                     27.0 4 6 16 0   0     0   1   13 14                 27
1673005 1673005 MA Suffolk   school 2502790 35   Boston 250279000333 350346 Boston - Warren-Prescott   Regular School No Elementary PK 08 2021   grade_8 12 5 11 0   1     0   4   13 20 *                     33.0 12 5 11 0   1     0   4   13 20                 33
1675307 1675307 MA Essex   school 2506660 149   Lawrence 250666002625 1490537 Lawrence - School for Exceptional Studies   Regular School No Other KG 12 2021   grade_8 2 0 12 0   0     0   1   13 2 *                     15.0 2 0 12 0   0     0   1   13 2                 15
1674071 1674071 MA Norfolk   school 2504050 73   Dedham 250405000551 730305 Dedham - Dedham Middle School   Regular School No Middle 06 08 2021   grade_8 167 20 43 1   4     0   12   130 117 *                     247.0 167 20 43 1   4     0   12   130 117                 247
1677818 1677818 MA Norfolk   school 2510620 266   Sharon 251062002560 2660305 Sharon - Sharon Middle   Regular School No Middle 06 08 2021   grade_8 165 10 10 0   89     0   14   133 155 *                     288.0 165 10 10 0   89     0   14   133 155                 288
1678274 1678274 MA Hampden   school 2511130 281   Springfield 251113002602 2810330 Springfield - M Marcus Kiley Middle   Regular School No Middle 06 08 2021   grade_8 22 53 155 0   4     0   2   133 103 *                     236.0 22 53 155 0   4     0   2   133 103                 236
1674472 1674472 MA Barnstable   school 2504860 96   Falmouth 250486000687 960405 Falmouth - Lawrence   Regular School No Middle 07 08 2021   grade_8 197 15 15 1   12     0   17   134 123 *                     257.0 197 15 15 1   12     0   17   134 123                 257
1675955 1675955 MA Essex   school 2507260 168   Marblehead 250726001789 1680300 Marblehead - Marblehead Veterans Middle School   Regular School No Middle 07 08 2021   grade_8 223 7 13 0   2     0   4   134 115 *                     249.0 223 7 13 0   2     0   4   134 115                 249
1676245 1676245 MA Plymouth   school 2507770 182   Middleborough 250777001378 1820305 Middleborough - John T. Nichols Middle   Regular School No Middle 06 08 2021   grade_8 237 11 7 3   0     0   7   134 131 *                     265.0 237 11 7 3   0     0   7   134 131                 265
1676715 1676715 MA Middlesex   school 2508610 207   Newton 250861000310 2070310 Newton - Charles E Brown Middle   Regular School No Middle 06 08 2021   grade_8 173 9 17 1   52     0   18   135 135 *                     270.0 173 9 17 1   52     0   18   135 135                 270
1675851 1675851 MA Essex   school 2507110 163   Lynn 250711002277 1630605 Lynn - Lynn Vocational Technical Institute   Career and Technical School No Other PK 12 2021   grade_8 31 16 214 0   24     0   6   136 154 *                     291.0 31 16 214 0   24     0   6   136 154                 291
1678402 1678402 MA Norfolk   school 2511250 285   Stoughton 251125001865 2850405 Stoughton - O'Donnell Middle School   Regular School No Middle 06 08 2021   grade_8 148 66 39 0   9     6   22   136 154 *                     290.0 148 66 39 0   9     6   22   136 154                 290
1673467 1673467 MA Plymouth   school 2503090 44   Brockton 250309000410 440420 Brockton - West Middle School   Regular School No Middle 06 08 2021   grade_8 52 160 23 2   8     0   6   137 114 *                     251.0 52 160 23 2   8     0   6   137 114                 251
1672057 1672057 MA Hampden   school 2501800 5   Agawam 250180000025 50405 Agawam - Agawam Junior High   Regular School No Middle 07 08 2021   grade_8 229 13 20 0   4     0   9   138 137 *                     275.0 229 13 20 0   4     0   9   138 137                 275
1680789 1680789 MA Essex   school 2507410 705   Masconomet 250741001097 7050405 Masconomet - Masconomet Regional Middle School   Regular School No Middle 07 08 2021   grade_8 250 2 5 0   5     0   0   138 124 *                     262.0 250 2 5 0   5     0   0   138 124                 262
1681255 1681255 MA Worcester   school 2511880 775   Wachusett 251188000888 7750305 Wachusett - Mountview Middle   Regular School No Middle 06 08 2021   grade_8 223 7 23 0   13     0   8   138 136 *                     274.0 223 7 23 0   13     0   8   138 136                 274
1673898 1673898 MA Hampden   school 2503660 61   Chicopee 250366000491 610305 Chicopee - Bellamy Middle   Regular School No Middle 06 08 2021   grade_8 134 8 111 1   3     0   14   139 132 *                     271.0 134 8 111 1   3     0   14   139 132                 271
1678660 1678660 MA Middlesex   school 2511910 305   Wakefield 251191000776 3050310 Wakefield - Galvin Middle School   Regular School No Middle 05 08 2021   grade_8 219 6 22 1   8     0   11   139 128 *                     267.0 219 6 22 1   8     0   11   139 128                 267

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