enrollments

Data source: Big Local News · About: Big Local

496 rows where grade = "grade_7", state = "MA" and year = 2021 sorted by female_int 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
1677139 1677139 MA Essex   school 2509360 229   Peabody 250936001495 2290305 Peabody - J Henry Higgins Middle   Regular School No Middle 06 08 2021   grade_7 379 17 77 1   13     1   12   246 254 *                     500.0 379 17 77 1   13     1   12   246 254                 500
1677846 1677846 MA Worcester   school 2510770 271   Shrewsbury 251077001825 2710030 Shrewsbury - Oak Middle School   Regular School No Middle 07 08 2021   grade_7 251 13 41 2   172     0   23   248 254 *                     502.0 251 13 41 2   172     0   23   248 254                 502
1675828 1675828 MA Essex   school 2507110 163   Lynn 250711001063 1630405 Lynn - Breed Middle School   Regular School No Middle 06 08 2021   grade_7 35 38 361 1   47     0   18   255 245 *                     500.0 35 38 361 1   47     0   18   255 245                 500
1676445 1676445 MA Norfolk   school 2508370 199   Needham 250837001308 1990405 Needham - Pollard Middle   Regular School No Middle 07 08 2021   grade_7 357 12 42 0   31     0   19   218 243 *                     461.0 357 12 42 0   31     0   19   218 243                 461
1675825 1675825 MA Essex   school 2507110 163   Lynn 250711000301 1630305 Lynn - Thurgood Marshall Mid   Regular School No Middle 06 08 2021   grade_7 40 53 344 1   27     0   20   253 231 *                     485.0 40 53 344 1   27     0   20   253 231                 485
1679649 1679649 MA Worcester   school 2513230 348   Worcester 251323002213 3480415 Worcester - Forest Grove Middle   Regular School No Middle 07 08 2021   grade_7 206 63 145 0   20     0   24   229 229 *                     458.0 206 63 145 0   20     0   24   229 229                 458
1679214 1679214 MA Norfolk   school 2512840 336   Weymouth 251284002607 3360310 Weymouth - Abigail Adams Middle School   Regular School No Middle 05 08 2021   grade_7 311 28 63 1   31     0   22   230 226 *                     456.0 311 28 63 1   31     0   22   230 226                 456
1679654 1679654 MA Worcester   school 2513230 348   Worcester 251323002223 3480423 Worcester - Sullivan Middle   Regular School No Middle 06 08 2021   grade_7 136 67 182 1   35     0   23   224 220 *                     444.0 136 67 182 1   35     0   23   224 220                 444
1672197 1672197 MA Middlesex   school 2501980 10   Arlington 250198000063 100410 Arlington - Ottoson Middle   Regular School No Middle 07 08 2021   grade_7 330 21 37 0   41     0   27   237 219 *                     456.0 330 21 37 0   41     0   27   237 219                 456
1678907 1678907 MA Norfolk   school 2512270 317   Wellesley 251227002029 3170305 Wellesley - Wellesley Middle   Regular School No Middle 06 08 2021   grade_7 265 15 22 0   57     0   23   174 208 *                     382.0 265 15 22 0   57     0   23   174 208                 382
1680287 1680287 MA Middlesex   school 2501710 600   Acton-Boxborough 250171000013 6000405 Acton-Boxborough - Raymond J Grey Junior High   Regular School No Middle 07 08 2021   grade_7 214 14 25 1   139     1   16   203 207 *                     410.0 214 14 25 1   139     1   16   203 207                 410
1676830 1676830 MA Essex   school 2508700 211   North Andover 250870001398 2110305 North Andover - North Andover Middle   Regular School No Middle 06 08 2021   grade_7 255 9 56 1   33     0   18   166 206 *                     372.0 255 9 56 1   33     0   18   166 206                 372
1673217 1673217 MA Suffolk   school 2502790 35   Boston 250279000203 350560 Boston - Boston Latin   Regular School No High 07 12 2021   grade_7 189 29 55 0   121     2   23   228 191 *                     419.0 189 29 55 0   121     2   23   228 191                 419
1679308 1679308 MA Middlesex   school 2513110 344   Winchester 251311002167 3440305 Winchester - McCall Middle   Regular School No Middle 06 08 2021   grade_7 272 7 9 0   71     0   29   205 183 *                     388.0 272 7 9 0   71     0   29   205 183                 388
1679651 1679651 MA Worcester   school 2513230 348   Worcester 251323002253 3480420 Worcester - Worcester East Middle   Regular School No Middle 07 08 2021   grade_7 102 79 168 0   17     0   18   201 183 *                     384.0 102 79 168 0   17     0   18   201 183                 384
1676581 1676581 MA Bristol   school 2508430 201   New Bedford 250843001337 2010410 New Bedford - Normandin Middle School   Regular School No Middle 06 08 2021   grade_7 179 33 148 0   5     0   12   195 182 *                     377.0 179 33 148 0   5     0   12   195 182                 377
1672443 1672443 MA Essex   school 2502640 30   Beverly 250264000165 300305 Beverly - Beverly Middle School   Regular School No Middle 05 08 2021   grade_7 286 11 52 0   9     1   14   192 181 *                     373.0 286 11 52 0   9     1   14   192 181                 373
1680756 1680756 MA Norfolk   school 2506510 690   King Philip 250651000941 6900510 King Philip - King Philip Middle School   Regular School No Middle 07 08 2021   grade_7 330 6 27 1   7     0   14   205 180 *                     385.0 330 6 27 1   7     0   14   205 180                 385
1679004 1679004 MA Hampden   school 2512630 325   Westfield 251263001570 3250310 Westfield - Westfield Middle School   Regular School No Middle 07 08 2021   grade_7 279 9 71 1   14     0   10   205 179 *                     384.0 279 9 71 1   14     0   10   205 179                 384
1672399 1672399 MA Middlesex   school 2502490 26   Belmont 250249000149 260305 Belmont - Winthrop L Chenery Middle   Regular School No Middle 05 08 2021   grade_7 211 13 20 1   92     2   28   189 178 *                     367.0 211 13 20 1   92     2   28   189 178                 367
1679647 1679647 MA Worcester   school 2513230 348   Worcester 251323002202 3480405 Worcester - Burncoat Middle School   Regular School No Middle 07 08 2021   grade_7 118 56 128 0   19     0   16   161 176 *                     337.0 118 56 128 0   19     0   16   161 176                 337
1676868 1676868 MA Bristol   school 2508730 212   North Attleborough 250873001207 2120305 North Attleborough - North Attleborough Middle   Regular School No Middle 06 08 2021   grade_7 254 13 19 1   24     0   14   152 173 *                     325.0 254 13 19 1   24     0   14   152 173                 325
1675995 1675995 MA Middlesex   school 2507320 170   Marlborough 250732002639 1700045 Marlborough - 1 LT Charles W. Whitcomb School   Regular School No Middle 05 08 2021   grade_7 126 13 209 1   9     0   10   198 170 *                     368.0 126 13 209 1   9     0   10   198 170                 368
1680788 1680788 MA Essex   school 2507410 705   Masconomet 250741001097 7050405 Masconomet - Masconomet Regional Middle School   Regular School No Middle 07 08 2021   grade_7 274 3 11 0   9     1   16   149 165 *                     314.0 274 3 11 0   9     1   16   149 165                 314
1676270 1676270 MA Worcester   school 2507860 185   Milford 250786001240 1850305 Milford - Stacy Middle   Regular School No Middle 06 08 2021   grade_7 199 14 107 7   8     0   12   183 164 *                     347.0 199 14 107 7   8     0   12   183 164                 347
1677321 1677321 MA Plymouth   school 2509720 239   Plymouth 250972002531 2390405 Plymouth - Plymouth Commun Intermediate   Regular School No Middle 06 08 2021   grade_7 249 11 39 0   3     0   19   158 163 *                     321.0 249 11 39 0   3     0   19   158 163                 321
1672056 1672056 MA Hampden   school 2501800 5   Agawam 250180000025 50405 Agawam - Agawam Junior High   Regular School No Middle 07 08 2021   grade_7 241 4 39 0   12     0   11   145 162 *                     307.0 241 4 39 0   12     0   11   145 162                 307
1672319 1672319 MA Barnstable   school 2502310 20   Barnstable 250231002678 200315 Barnstable - Barnstable Intermediate School   Regular School No Middle 06 07 2021   grade_7 225 24 73 4   8     1   16   189 162 *                     351.0 225 24 73 4   8     1   16   189 162                 351
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
1679118 1679118 MA Hampden   school 2512510 332   West Springfield 251251001243 3320305 West Springfield - West Springfield Middle   Regular School No Middle 06 08 2021   grade_7 196 11 60 0   28     0   17   155 157 *                     312.0 196 11 60 0   28     0   17   155 157                 312
1676332 1676332 MA Norfolk   school 2507980 189   Milton 250798001257 1890410 Milton - Charles S Pierce Middle   Regular School No Middle 06 08 2021   grade_7 206 41 18 1   24     0   17   151 156 *                     307.0 206 41 18 1   24     0   17   151 156                 307
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
1675451 1675451 MA Middlesex   school 2506840 155   Lexington 250684002552 1550310 Lexington - Wm Diamond Middle   Regular School No Middle 06 08 2021   grade_7 113 13 9 0   140     0   24   144 155 *                     299.0 113 13 9 0   140     0   24   144 155                 299
1676717 1676717 MA Middlesex   school 2508610 207   Newton 250861000314 2070315 Newton - F A Day Middle   Regular School No Middle 06 08 2021   grade_7 176 18 26 1   62     0   25   153 155 *                     308.0 176 18 26 1   62     0   25   153 155                 308
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
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
1676578 1676578 MA Bristol   school 2508430 201   New Bedford 250843001334 2010405 New Bedford - Keith Middle School   Regular School No Middle 06 08 2021   grade_7 113 62 137 2   3     0   34   198 153 *                     351.0 113 62 137 2   3     0   34   198 153                 351
1675132 1675132 MA Middlesex   school 2506330 139   Hopkinton 250633000468 1390305 Hopkinton - Hopkinton Middle School   Regular School No Middle 06 08 2021   grade_7 194 3 15 1   67     0   17   149 148 *                     297.0 194 3 15 1   67     0   17   149 148                 297
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
1678441 1678441 MA Middlesex   school 2511340 288   Sudbury 251134001872 2880305 Sudbury - Ephraim Curtis Middle   Regular School No Middle 06 08 2021   grade_7 218 12 10 0   35     1   17   146 146 *                     293.0 218 12 10 0   35     1   17   146 146                 293
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
1675389 1675389 MA Worcester   school 2506780 153   Leominster 250678002045 1530320 Leominster - Sky View Middle School   Regular School No Middle 06 08 2021   grade_7 136 34 97 1   14     0   12   151 143 *                     294.0 136 34 97 1   14     0   12   151 143                 294
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
1676035 1676035 MA Plymouth   school 2507350 171   Marshfield 250735001143 1710310 Marshfield - Furnace Brook Middle   Regular School No Middle 06 08 2021   grade_7 260 2 15 0   5     1   3   145 141 *                     286.0 260 2 15 0   5     1   3   145 141                 286
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
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
1677817 1677817 MA Norfolk   school 2510620 266   Sharon 251062002560 2660305 Sharon - Sharon Middle   Regular School No Middle 06 08 2021   grade_7 139 14 18 0   101     0   19   153 138 *                     291.0 139 14 18 0   101     0   19   153 138                 291
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
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
1676584 1676584 MA Bristol   school 2508430 201   New Bedford 250843001339 2010415 New Bedford - Roosevelt Middle School   Regular School No Middle 06 08 2021   grade_7 95 41 132 0   0     1   15   147 137 *                     284.0 95 41 132 0   0     1   15   147 137                 284
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
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
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
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
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
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
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
1678550 1678550 MA Bristol   school 2511520 293   Taunton 251152001662 2930315 Taunton - Benjamin Friedman Middle   Regular School No Middle 05 07 2021   grade_7 211 33 18 0   2     0   11   145 130 *                     275.0 211 33 18 0   2     0   11   145 130                 275
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
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
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
1678401 1678401 MA Norfolk   school 2511250 285   Stoughton 251125001865 2850405 Stoughton - O'Donnell Middle School   Regular School No Middle 06 08 2021   grade_7 144 56 39 0   18     0   11   140 128 *                     268.0 144 56 39 0   18     0   11   140 128                 268
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
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
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
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
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
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
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
1680125 1680125 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_7 2 147 111 1   0     1   2   142 122 *                     264.0 2 147 111 1   0     1   2   142 122                 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
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
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
1677561 1677561 MA Suffolk   school 2510050 248   Revere 251005002113 2480305 Revere - Susan B. Anthony Middle School   Regular School No Middle 06 08 2021   grade_7 59 11 124 0   2     0   2   83 115 *                     198.0 59 11 124 0   2     0   2   83 115                 198
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
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
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
1679040 1679040 MA Middlesex   school 2512660 326   Westford 251266002080 3260330 Westford - Stony Brook School   Regular School No Middle 06 08 2021   grade_7 123 1 9 1   59     0   5   82 114 *                     198.0 123 1 9 1   59     0   5   82 114                 198
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
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
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
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
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
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
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
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
1673353 1673353 MA Norfolk   school 2502940 40   Braintree 250294000372 400310 Braintree - South Middle School   Regular School No Middle 06 08 2021   grade_7 140 8 4 0   49     0   3   96 108 *                     204.0 140 8 4 0   49     0   3   96 108                 204
1674780 1674780 MA Worcester   school 2505370 110   Grafton 250537002520 1100305 Grafton - Grafton Middle   Regular School No Middle 07 08 2021   grade_7 186 6 20 1   28     0   5   138 108 *                     246.0 186 6 20 1   28     0   5   138 108                 246
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
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
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
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
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
1678842 1678842 MA Middlesex   school 2512210 315   Wayland 251221002502 3150305 Wayland - Wayland Middle School   Regular School No Middle 06 08 2021   grade_7 127 15 13 0   32     1   15   96 107 *                     203.0 127 15 13 0   32     1   15   96 107                 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
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
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
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
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

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