enrollments

Data source: Big Local News · About: Big Local

496 rows where grade = "grade_7", state = "MA" and year = 2021 sorted by district_state_id 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
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
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
1674492 1674492 MA Worcester   school 2504890 97   Fitchburg 250489001523 970048 Fitchburg - Memorial Middle School   Regular School No Middle 05 08 2021   grade_7 50 10 84 0   6     1   11   70 92 *                     162.0 50 10 84 0   6     1   11   70 92                 162
1674502 1674502 MA Worcester   school 2504890 97   Fitchburg 250489002672 970315 Fitchburg - Arthur M Longsjo Middle School   Regular School No Middle 05 08 2021   grade_7 42 14 89 0   5     0   15   82 83 *                     165.0 42 14 89 0   5     0   15   82 83                 165
1674512 1674512 MA Worcester   school 2504890 97   Fitchburg 250489002775 970340 Fitchburg - McKay Arts Academy   Regular School No Elementary PK 08 2021   grade_7 9 6 41 0   1     0   4   27 34 *                     61.0 9 6 41 0   1     0   4   27 34                 61
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
1674380 1674380 MA Bristol   school 2504830 95   Fall River 250483002811 950017 Fall River - Henry Lord Community School   Regular School No Elementary PK 08 2021   grade_7 38 6 25 0   3     0   15   52 35 *                     87.0 38 6 25 0   3     0   15   52 35                 87
1674390 1674390 MA Bristol   school 2504830 95   Fall River 250483000666 950045 Fall River - John J Doran   Regular School No Elementary PK 08 2021   grade_7 24 3 17 0   1     0   3   25 23 *                     48.0 24 3 17 0   1     0   3   25 23                 48
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
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
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
1674431 1674431 MA Bristol   school 2504830 95   Fall River 250483002852 950340 Fall River - Stone PK-12 School   Regular School No Other 01 12 2021   grade_7 7 1 0 0   0     0   0   7 1 *                     8.0 7 1 0 0   0     0   0   7 1                 8
1674441 1674441 MA Bristol   school 2504830 95   Fall River 250483002873 950525 Fall River - Resiliency Preparatory Academy   Alternative School No High 07 12 2021   grade_7 4 0 3 0   0     0   0   4 3 *                     7.0 4 0 3 0   0     0   0   4 3                 7
1674338 1674338 MA Bristol   school 2504800 94   Fairhaven 250480002572 940305 Fairhaven - Hastings Middle   Regular School No Middle 06 08 2021   grade_7 121 6 12 1   4     0   6   76 74 *                     150.0 121 6 12 1   4     0   6   76 74                 150
1674265 1674265 MA Middlesex   school 2504770 93   Everett 250477000631 930010 Everett - Sumner G. Whittier School   Regular School No Elementary KG 08 2021   grade_7 6 10 51 0   4     0   1   32 40 *                     72.0 6 10 51 0   4     0   1   32 40                 72
1674280 1674280 MA Middlesex   school 2504770 93   Everett 250477002033 930018 Everett - Madeline English School   Regular School No Elementary KG 08 2021   grade_7 28 6 45 0   6     0   3   46 42 *                     88.0 28 6 45 0   6     0   3   46 42                 88
1674289 1674289 MA Middlesex   school 2504770 93   Everett 250477002038 930028 Everett - George Keverian School   Regular School No Elementary KG 08 2021   grade_7 19 5 94 0   2     0   1   69 52 *                     121.0 19 5 94 0   2     0   1   69 52                 121
1674295 1674295 MA Middlesex   school 2504770 93   Everett 250477002787 930030 Everett - Devens School   Regular School No Other KG 12 2021   grade_7 4 2 3 0   0     0   1   9 1 *                     10.0 4 2 3 0   0     0   1   9 1                 10
1674308 1674308 MA Middlesex   school 2504770 93   Everett 250477001520 930038 Everett - Lafayette School   Regular School No Elementary KG 08 2021   grade_7 30 19 68 0   13     0   1   64 67 *                     131.0 30 19 68 0   13     0   1   64 67                 131
1674317 1674317 MA Middlesex   school 2504770 93   Everett 250477001521 930058 Everett - Parlin School   Regular School No Elementary KG 08 2021   grade_7 11 14 77 0   3     0   1   53 53 *                     106.0 11 14 77 0   3     0   1   53 53                 106
1672140 1672140 MA Essex   school 2501950 9   Andover 250195002510 90305 Andover - Doherty Middle   Regular School No Middle 06 08 2021   grade_7 112 1 11 0   12     0   6   66 76 *                     142.0 112 1 11 0   12     0   6   66 76                 142
1672143 1672143 MA Essex   school 2501950 9   Andover 250195002511 90310 Andover - Andover West Middle   Regular School No Middle 06 08 2021   grade_7 120 11 14 0   40     0   2   95 92 *                     187.0 120 11 14 0   40     0   2   95 92                 187
1672146 1672146 MA Essex   school 2501950 9   Andover 250195001678 90350 Andover - Wood Hill Middle School   Regular School No Middle 06 08 2021   grade_7 66 4 10 0   35     1   7   53 70 *                     123.0 66 4 10 0   35     1   7   53 70                 123
1674246 1674246 MA Dukes   school 2509090 89   Edgartown 250909001469 890005 Edgartown - Edgartown Elementary   Regular School No Elementary PK 08 2021   grade_7 22 3 7 1   0     0   2   14 21 *                     35.0 22 3 7 1   0     0   2   14 21                 35
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
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
1674192 1674192 MA Hampshire   school 2504590 86   Easthampton 250459000616 860305 Easthampton - White Brook Middle School   Regular School No Middle 05 08 2021   grade_7 68 1 15 0   7     0   1   59 32 *                     92.0 68 1 15 0   7     0   1   59 32                 92
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
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
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
1681309 1681309 MA Plymouth   school 2512930 780   Whitman-Hanson 251293000207 7800310 Whitman-Hanson - Whitman Middle   Regular School No Middle 06 08 2021   grade_7 161 8 12 2   2     0   8   98 95 *                     193.0 161 8 12 2   2     0   8   98 95                 193
1681313 1681313 MA Plymouth   school 2512930 780   Whitman-Hanson 251293001286 7800315 Whitman-Hanson - Hanson Middle School   Regular School No Middle 05 08 2021   grade_7 104 0 7 0   1     0   4   58 58 *                     116.0 104 0 7 0   1     0   4   58 58                 116
1681284 1681284 MA Worcester   school 2512100 778   Quaboag Regional 251210002794 7780305 Quaboag Regional - Quaboag Regional Middle Innovation School   Regular School No Middle 07 08 2021   grade_7 81 0 5 0   0     0   2   44 44 *                     88.0 81 0 5 0   0     0   2   44 44                 88
1681239 1681239 MA Worcester   school 2511880 775   Wachusett 251188001492 7750040 Wachusett - Paxton Center   Regular School No Elementary KG 08 2021   grade_7 51 1 9 0   5     0   3   35 34 *                     69.0 51 1 9 0   5     0   3   35 34                 69
1681248 1681248 MA Worcester   school 2511880 775   Wachusett 251188001553 7750045 Wachusett - Thomas Prince   Regular School No Elementary KG 08 2021   grade_7 37 2 0 0   2     0   3   25 19 *                     44.0 37 2 0 0   2     0   3   25 19                 44
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
1681257 1681257 MA Worcester   school 2511880 775   Wachusett 251188001280 7750310 Wachusett - Central Tree Middle   Regular School No Middle 06 08 2021   grade_7 89 3 9 0   3     0   5   55 54 *                     109.0 89 3 9 0   3     0   5   55 54                 109
1681261 1681261 MA Worcester   school 2511880 775   Wachusett 251188001494 7750315 Wachusett - Chocksett Middle School   Regular School No Middle 05 08 2021   grade_7 74 1 6 0   0     0   2   46 37 *                     83.0 74 1 6 0   0     0   2   46 37                 83
1681203 1681203 MA Dukes   school 2500043 774   Up-Island Regional 250004301927 7740020 Up-Island Regional - West Tisbury Elementary   Regular School No Elementary PK 08 2021   grade_7 41 1 3 1   0     0   5   23 27 *                     51.0 41 1 3 1   0     0   5   23 27                 51
1681183 1681183 MA Essex   school 2511740 773   Triton 251174001470 7730405 Triton - Triton Regional Middle School   Regular School No Middle 07 08 2021   grade_7 152 2 7 0   6     1   2   84 86 *                     170.0 152 2 7 0   6     1   2   84 86                 170
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
1674093 1674093 MA Worcester   school 2504230 77   Douglas 250423002788 770305 Douglas - Douglas Middle School   Regular School No Middle 06 08 2021   grade_7 78 0 3 0   1     0   4   44 42 *                     86.0 78 0 3 0   1     0   4   44 42                 86
1681142 1681142 MA Worcester   school 2500002 767   Spencer-E Brookfield 250000200639 7670415 Spencer-E Brookfield - Knox Trail Middle School   Regular School No Middle 05 08 2021   grade_7 99 4 17 0   2     0   6   66 62 *                     128.0 99 4 17 0   2     0   6   66 62                 128
1681121 1681121 MA Hampden   school 2500013 766   Southwick-Tolland-Granville Regional School District 250001301782 7660505 Southwick-Tolland-Granville Regional School District - Southwick Regional School   Regular School No High 07 12 2021   grade_7 104 6 6 0   2     0   4   56 66 *                     122.0 104 6 6 0   2     0   4   56 66                 122
1681107 1681107 MA Berkshire   school 2511040 765   Southern Berkshire 251104001774 7650505 Southern Berkshire - Mt Everett Regional   Regular School No High 06 12 2021   grade_7 31 0 2 0   0     0   2   22 13 *                     35.0 31 0 2 0   0     0   2   22 13                 35
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
1681074 1681074 MA Franklin   school 2509900 755   Ralph C Mahar 250990001587 7550505 Ralph C Mahar - Ralph C Mahar Regional   Regular School No High 07 12 2021   grade_7 112 0 10 0   4     0   1   63 64 *                     127.0 112 0 10 0   4     0   1   63 64                 127
1681067 1681067 MA Worcester   school 2500001 753   Quabbin 250000102003 7530405 Quabbin - Quabbin Regional Middle School   Regular School No Middle 06 08 2021   grade_7 165 0 12 0   1     1   2   93 88 *                     181.0 165 0 12 0   1     1   2   93 88                 181
1681034 1681034 MA Franklin   school 2509600 750   Pioneer Valley 250960001515 7500505 Pioneer Valley - Pioneer Valley Regional   Regular School No High 07 12 2021   grade_7 53 1 0 0   1     0   2   28 29 *                     57.0 53 1 0 0   1     0   2   28 29                 57
1681012 1681012 MA Essex   school 2509450 745   Pentucket 250945001512 7450405 Pentucket - Pentucket Regional Middle   Regular School No Middle 07 08 2021   grade_7 132 0 9 1   2     0   1   73 72 *                     145.0 132 0 9 1   2     0   1   73 72                 145
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
1680965 1680965 MA Middlesex   school 2508790 735   North Middlesex 250879002280 7350030 North Middlesex - Hawthorne Brook   Regular School No Middle 05 08 2021   grade_7 122 0 4 0   3     0   4   72 61 *                     133.0 122 0 4 0   3     0   4   72 61                 133
1680974 1680974 MA Middlesex   school 2508790 735   North Middlesex 250879001762 7350310 North Middlesex - Nissitissit Middle School   Regular School No Middle 05 08 2021   grade_7 103 2 5 0   1     0   8   65 54 *                     119.0 103 2 5 0   1     0   8   65 54                 119
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
1680923 1680923 MA Worcester   school 2508310 725   Nashoba 250831001102 7250025 Nashoba - Florence Sawyer School   Regular School No Elementary PK 08 2021   grade_7 68 1 2 0   0     0   6   38 39 *                     77.0 68 1 2 0   0     0   6   38 39                 77
1680926 1680926 MA Worcester   school 2508310 725   Nashoba 250831000947 7250305 Nashoba - Luther Burbank Middle School   Regular School No Middle 06 08 2021   grade_7 58 1 13 0   0     0   2   39 35 *                     74.0 58 1 13 0   0     0   2   39 35                 74
1680929 1680929 MA Worcester   school 2508310 725   Nashoba 250831001868 7250310 Nashoba - Hale   Regular School No Middle 06 08 2021   grade_7 85 1 2 0   3     0   5   53 43 *                     96.0 85 1 2 0   3     0   5   53 43                 96
1680895 1680895 MA Worcester   school 2508280 720   Narragansett 250828001467 7200305 Narragansett - Narragansett Middle   Regular School No Middle 05 08 2021   grade_7 106 0 7 1   2     0   7   66 57 *                     123.0 106 0 7 1   2     0   7   66 57                 123
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
1680880 1680880 MA Franklin   school 2507990 717   Mohawk Trail 250799001265 7170505 Mohawk Trail - Mohawk Trail Regional School   Regular School No High 07 12 2021   grade_7 50 0 4 0   0     0   1   28 27 *                     55.0 50 0 4 0   0     0   1   28 27                 55
1680850 1680850 MA Berkshire   school 2508160 715   Mount Greylock 250816001273 7150505 Mount Greylock - Mt Greylock Regional High   Regular School No High 07 12 2021   grade_7 68 2 6 0   0     0   1   41 36 *                     77.0 68 2 6 0   0     0   1   41 36                 77
1680828 1680828 MA Barnstable   school 2500544 712   Monomoy Regional School District 250054402832 7120315 Monomoy Regional School District - Monomoy Regional Middle School   Regular School No Middle 05 07 2021   grade_7 100 9 13 2   3     0   13   64 76 *                     140.0 100 9 13 2   3     0   13   64 76                 140
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
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
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
1672076 1672076 MA Essex   school 2501860 7   Amesbury 250186000035 70013 Amesbury - Amesbury Middle   Regular School No Middle 05 08 2021   grade_7 119 3 21 0   2     0   10   90 65 *                     155.0 119 3 21 0   2     0   10   90 65                 155
1680777 1680777 MA Essex   school 2500067 698   Manchester Essex Regional 250006702653 6980030 Manchester Essex Regional - Manchester Essex Regional Middle School   Regular School No Middle 06 08 2021   grade_7 112 0 1 0   0     0   0   59 54 *                     113.0 112 0 1 0   0     0   0   59 54                 113
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
1680736 1680736 MA Hampshire   school 2505740 683   Hampshire 250574000825 6830505 Hampshire - Hampshire Regional High   Regular School No High 07 12 2021   grade_7 119 0 3 1   3     0   2   54 74 *                     128.0 119 0 3 1   3     0   2   54 74                 128
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
1680730 1680730 MA Hampden   school 2505730 680   Hampden-Wilbraham 250573002141 6800310 Hampden-Wilbraham - Wilbraham Middle   Regular School No Middle 06 08 2021   grade_7 166 6 19 0   3     0   7   99 102 *                     201.0 166 6 19 0   3     0   7   99 102                 201
1680706 1680706 MA Essex   school 2505670 675   Hamilton-Wenham 250567001276 6750310 Hamilton-Wenham - Miles River Middle   Regular School No Middle 06 08 2021   grade_7 119 0 3 0   4     0   1   69 58 *                     127.0 119 0 3 0   4     0   1   69 58                 127
1680679 1680679 MA Franklin   school 2505270 674   Gill-Montague 250527002386 6740310 Gill-Montague - Great Falls Middle   Regular School No Middle 06 08 2021   grade_7 62 1 11 0   0     1   7   47 35 *                     82.0 62 1 11 0   0     1   7   47 35                 82
1680657 1680657 MA Middlesex   school 2505500 673   Groton-Dunstable 250550000805 6730305 Groton-Dunstable - Groton Dunstable Regional Middle   Regular School No Middle 05 08 2021   grade_7 149 3 7 0   9     0   4   85 87 *                     172.0 149 3 7 0   9     0   4   85 87                 172
1680637 1680637 MA Hampshire   school 2505160 672   Gateway 250516002667 6720405 Gateway - Gateway Regional Middle School   Regular School No Middle 06 08 2021   grade_7 59 1 8 0   0     1   0   34 35 *                     69.0 59 1 8 0   0     1   0   34 35                 69
1680616 1680616 MA Franklin   school 2505100 670   Frontier 250510000749 6700505 Frontier - Frontier Regional   Regular School No High 07 12 2021   grade_7 90 2 13 0   2     0   7   67 47 *                     114.0 90 2 13 0   2     0   7   67 47                 114
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
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
1680583 1680583 MA Barnstable   school 2504560 660   Nauset 250456000609 6600305 Nauset - Nauset Regional Middle   Regular School No Middle 06 08 2021   grade_7 159 8 12 0   4     0   7   99 90 *                     190.0 159 8 12 0   4     0   7   99 90                 190
1680571 1680571 MA Worcester   school 2504360 658   Dudley-Charlton Reg 250436001595 6580305 Dudley-Charlton Reg - Dudley Middle School   Regular School No Middle 05 08 2021   grade_7 116 6 15 1   1     0   6   63 82 *                     145.0 116 6 15 1   1     0   6   63 82                 145
1680575 1680575 MA Worcester   school 2504360 658   Dudley-Charlton Reg 250436001597 6580310 Dudley-Charlton Reg - Charlton Middle School   Regular School No Middle 05 08 2021   grade_7 161 1 15 1   3     0   3   93 91 *                     184.0 161 1 15 1   3     0   3   93 91                 184
1680550 1680550 MA Norfolk   school 2504290 655   Dover-Sherborn 250429000575 6550405 Dover-Sherborn - Dover-Sherborn Regional Middle School   Regular School No Middle 06 08 2021   grade_7 120 6 14 0   29     0   18   96 91 *                     187.0 120 6 14 0   29     0   18   96 91                 187
1680538 1680538 MA Bristol   school 2504200 650   Dighton-Rehoboth 250420000400 6500305 Dighton-Rehoboth - Dighton Middle School   Regular School No Middle 05 08 2021   grade_7 88 2 4 0   1     0   5   59 41 *                     100.0 88 2 4 0   1     0   5   59 41                 100
1680542 1680542 MA Bristol   school 2504200 650   Dighton-Rehoboth 250420002430 6500310 Dighton-Rehoboth - Dorothy L Beckwith   Regular School No Middle 05 08 2021   grade_7 116 1 7 1   2     0   4   63 68 *                     131.0 116 1 7 1   2     0   4   63 68                 131
1673942 1673942 MA Norfolk   school 2503780 65   Cohasset 250378002910 650305 Cohasset - Cohasset Middle School   Regular School No Middle 06 08 2021   grade_7 124 4 1 0   1     0   0   64 66 *                     130.0 124 4 1 0   1     0   0   64 66                 130
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
1673927 1673927 MA Worcester   school 2503750 64   Clinton 250375000512 640305 Clinton - Clinton Middle School   Regular School No Middle 05 08 2021   grade_7 112 6 40 0   2     0   5   94 71 *                     165.0 112 6 40 0   2     0   5   94 71                 165
1680489 1680489 MA Berkshire   school 2503390 635   Central Berkshire 250339000466 6350305 Central Berkshire - Nessacus Regional Middle School   Regular School No Middle 06 08 2021   grade_7 110 0 3 1   0     0   1   59 56 *                     115.0 110 0 3 1   0     0   1   59 56                 115
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
1680448 1680448 MA Bristol   school 2503030 625   Bridgewater-Raynham 250303001674 6250315 Bridgewater-Raynham - Raynham Middle School   Regular School No Middle 05 08 2021   grade_7 149 16 1 0   5     0   5   94 82 *                     176.0 149 16 1 0   5     0   5   94 82                 176
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
1680427 1680427 MA Worcester   school 2502715 622   Blackstone-Millville 250271501082 6220405 Blackstone-Millville - Frederick W. Hartnett Middle School   Regular School No Middle 06 08 2021   grade_7 109 3 11 0   2     0   7   61 71 *                     132.0 109 3 11 0   2     0   7   61 71                 132
1680407 1680407 MA Worcester   school 2502580 620   Berlin-Boylston 250258000160 6200505 Berlin-Boylston - Tahanto Regional High   Regular School No High 06 12 2021   grade_7 77 1 6 0   5     1   2   45 47 *                     92.0 77 1 6 0   5     1   2   45 47                 92
1680386 1680386 MA Berkshire   school 2502530 618   Berkshire Hills 250253002000 6180310 Berkshire Hills - W.E.B. Du Bois Regional Middle School   Regular School No Middle 05 08 2021   grade_7 73 0 10 0   3     0   4   47 43 *                     90.0 73 0 10 0   3     0   4   47 43                 90
1680372 1680372 MA Middlesex   school 2500542 616   Ayer Shirley School District 250054202737 6160305 Ayer Shirley School District - Ayer Shirley Regional Middle School   Regular School No Middle 06 08 2021   grade_7 98 7 23 1   4     0   4   72 65 *                     137.0 98 7 23 1   4     0   4   72 65                 137
1680351 1680351 MA Worcester   school 2502160 615   Athol-Royalston 250216000176 6150305 Athol-Royalston - Athol-Royalston Middle School   Regular School No Middle 05 08 2021   grade_7 92 3 15 0   1     0   5   71 45 *                     116.0 92 3 15 0   1     0   5   71 45                 116
1680329 1680329 MA Worcester   school 2502040 610   Ashburnham-Westminster 250204000831 6100305 Ashburnham-Westminster - Overlook Middle School   Regular School No Middle 06 08 2021   grade_7 160 4 15 0   0     0   10   99 90 *                     189.0 160 4 15 0   0     0   10   99 90                 189
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
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
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

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