enrollments

Data source: Big Local News · About: Big Local

491 rows where grade = "grade_7", state = "MA" and year = 2016 sorted by district_state_id descending

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

  • 2016 · 491 ✖

grade ✖

  • grade_7 · 491 ✖
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
935084 935084 MA Norfolk   school 2504950 99   Foxborough 250495000709 990405 John J Ahern   Regular School No 2 05 08 2016   grade_7 177 5 5 0   7     0   2   99 97                       196 177 5 5 0   7     0   2   99 97                 196
935025 935025 MA Worcester   school 2504890 97   Fitchburg 250489001523 970048 Memorial Intermediate   Regular School No 2 05 08 2016   grade_7 53 11 80 0   7     0   16   73 94                       167 53 11 80 0   7     0   16   73 94                 167
935035 935035 MA Worcester   school 2504890 97   Fitchburg 250489002672 970315 Arthur M Longsjo Middle School   Regular School No 2 05 08 2016   grade_7 35 8 58 0   3     0   9   58 55                       113 35 8 58 0   3     0   9   58 55                 113
935045 935045 MA Worcester   school 2504890 97   Fitchburg 250489002775 970340 McKay Arts Academy   Regular School No 1 PK 08 2016   grade_7 26 5 36 0   3     0   8   32 46                       78 26 5 36 0   3     0   8   32 46                 78
935005 935005 MA Barnstable   school 2504860 96   Falmouth 250486000687 960405 Lawrence   Regular School No 2 07 08 2016   grade_7 233 10 7 4   7     0   19   136 144                       280 233 10 7 4   7     0   19   136 144                 280
934918 934918 MA Bristol   school 2504830 95   Fall River 250483002811 950017 Henry Lord Community School   Regular School No 1 PK 07 2016   grade_7 41 6 12 0   4     0   5   31 37                       68 41 6 12 0   4     0   5   31 37                 68
934927 934927 MA Bristol   school 2504830 95   Fall River 250483000666 950045 John J Doran   Regular School No 1 PK 08 2016   grade_7 30 2 19 0   3     0   4   31 27                       58 30 2 19 0   3     0   4   31 27                 58
934956 934956 MA Bristol   school 2504830 95   Fall River 250483000655 950305 Talbot Innovation School   Regular School No 2 06 08 2016   grade_7 113 13 56 0   13     0   6   94 107                       201 113 13 56 0   13     0   6   94 107                 201
934959 934959 MA Bristol   school 2504830 95   Fall River 250483000672 950315 Morton Middle   Regular School No 2 06 08 2016   grade_7 126 14 37 0   8     1   15   111 90                       201 126 14 37 0   8     1   15   111 90                 201
934962 934962 MA Bristol   school 2504830 95   Fall River 250483000671 950320 Matthew J Kuss Middle   Regular School No 2 06 08 2016   grade_7 161 10 46 0   8     0   8   122 111                       233 161 10 46 0   8     0   8   122 111                 233
934968 934968 MA Bristol   school 2504830 95   Fall River 250483002838 950335 Resiliency Middle School   Regular School No 2 07 08 2016   grade_7 3 4 4 0   0     0   0   5 6                       11 3 4 4 0   0     0   0   5 6                 11
934972 934972 MA Bristol   school 2504830 95   Fall River 250483002852 950340 Stone Day School   Regular School No 1 01 08 2016   grade_7 2 1 5 0   0     0   1   7 2                       9 2 1 5 0   0     0   1   7 2                 9
934878 934878 MA Bristol   school 2504800 94   Fairhaven 250480002572 940305 Hastings Middle   Regular School No 2 06 08 2016   grade_7 126 1 7 2   5     0   1   79 63                       142 126 1 7 2   5     0   1   79 63                 142
934809 934809 MA Middlesex   school 2504770 93   Everett 250477000631 930010 Sumner G. Whittier School   Regular School No 1 KG 08 2016   grade_7 6 3 26 0   3     0   0   21 17                       38 6 3 26 0   3     0   0   21 17                 38
934824 934824 MA Middlesex   school 2504770 93   Everett 250477002033 930018 Madeline English School   Regular School No 1 KG 08 2016   grade_7 31 12 25 0   4     0   3   35 40                       75 31 12 25 0   4     0   3   35 40                 75
934833 934833 MA Middlesex   school 2504770 93   Everett 250477002038 930028 George Keverian School   Regular School No 1 KG 08 2016   grade_7 43 13 35 0   12     0   3   58 48                       106 43 13 35 0   12     0   3   58 48                 106
934848 934848 MA Middlesex   school 2504770 93   Everett 250477001520 930038 Lafayette School   Regular School No 1 KG 08 2016   grade_7 30 18 30 0   8     0   3   40 49                       89 30 18 30 0   8     0   3   40 49                 89
934857 934857 MA Middlesex   school 2504770 93   Everett 250477001521 930058 Parlin School   Regular School No 1 KG 08 2016   grade_7 21 24 43 0   1     0   2   48 43                       91 21 24 43 0   1     0   2   48 43                 91
932669 932669 MA Essex   school 2501950 9   Andover 250195002510 90305 Doherty Middle   Regular School No 2 06 08 2016   grade_7 149 1 9 0   26     0   6   89 102                       191 149 1 9 0   26     0   6   89 102                 191
932672 932672 MA Essex   school 2501950 9   Andover 250195002511 90310 Andover West Middle   Regular School No 2 06 08 2016   grade_7 138 2 8 1   30     0   3   89 93                       182 138 2 8 1   30     0   3   89 93                 182
932675 932675 MA Essex   school 2501950 9   Andover 250195001678 90350 Wood Hill Middle School   Regular School No 2 06 08 2016   grade_7 103 7 7 0   39     0   3   65 94                       159 103 7 7 0   39     0   3   65 94                 159
934791 934791 MA Dukes   school 2509090 89   Edgartown 250909001469 890005 Edgartown Elementary   Regular School No 1 PK 08 2016   grade_7 34 1 3 2   0     0   0   17 23                       40 34 1 3 2   0     0   0   17 23                 40
934778 934778 MA Bristol   school 2504620 88   Easton 250462000618 880405 Easton Middle School   Regular School No 2 06 08 2016   grade_7 247 18 11 0   9     0   6   134 157                       291 247 18 11 0   9     0   6   134 157                 291
934756 934756 MA Hampden   school 2504500 87   East Longmeadow 250450000602 870305 Birchland Park   Regular School No 2 06 08 2016   grade_7 171 2 8 0   10     1   2   97 97                       194 171 2 8 0   10     1   2   97 97                 194
934738 934738 MA Hampshire   school 2504590 86   Easthampton 250459000616 860305 White Brook Middle School   Regular School No 2 05 08 2016   grade_7 91 4 6 0   3     0   4   52 56                       108 91 4 6 0   3     0   4   52 56                 108
934707 934707 MA Plymouth   school 2504440 83   East Bridgewater 250444000597 830505 East Bridgewater JR./SR. High School   Regular School No 3 07 12 2016   grade_7 171 2 0 1   3     0   5   87 95                       182 171 2 0 1   3     0   5   87 95                 182
934693 934693 MA Plymouth   school 2504410 82   Duxbury 250441000975 820305 Duxbury Middle   Regular School No 2 06 08 2016   grade_7 242 1 7 0   5     0   5   135 125                       260 242 1 7 0   5     0   5   135 125                 260
934678 934678 MA Middlesex   school 2504320 79   Dracut 250432001625 790410 Justus C. Richardson Middle School   Regular School No 2 06 08 2016   grade_7 258 19 23 0   16     0   4   167 153                       320 258 19 23 0   16     0   4   167 153                 320
941838 941838 MA Plymouth   school 2512930 780   Whitman-Hanson 251293000207 7800310 Whitman Middle   Regular School No 2 06 08 2016   grade_7 200 1 3 1   2     1   4   93 119                       212 200 1 3 1   2     1   4   93 119                 212
941841 941841 MA Plymouth   school 2512930 780   Whitman-Hanson 251293001286 7800315 Hanson Middle School   Regular School No 2 06 08 2016   grade_7 119 3 2 0   2     0   4   72 58                       130 119 3 2 0   2     0   4   72 58                 130
941812 941812 MA Worcester   school 2512100 778   Quaboag Regional 251210002794 7780305 Quaboag Regional Middle Innovation School   Regular School No 2 07 08 2016   grade_7 129 0 6 0   0     0   3   68 70                       138 129 0 6 0   0     0   3   68 70                 138
941767 941767 MA Worcester   school 2511880 775   Wachusett 251188001492 7750040 Paxton Center   Regular School No 1 KG 08 2016   grade_7 57 1 4 0   0     0   1   36 27                       63 57 1 4 0   0     0   1   36 27                 63
941776 941776 MA Worcester   school 2511880 775   Wachusett 251188001553 7750045 Thomas Prince   Regular School No 1 KG 08 2016   grade_7 49 1 2 0   1     0   0   28 25                       53 49 1 2 0   1     0   0   28 25                 53
941782 941782 MA Worcester   school 2511880 775   Wachusett 251188000888 7750305 Mountview Middle   Regular School No 2 06 08 2016   grade_7 240 4 14 1   17     0   9   131 154                       285 240 4 14 1   17     0   9   131 154                 285
941785 941785 MA Worcester   school 2511880 775   Wachusett 251188001280 7750310 Central Tree Middle   Regular School No 2 06 08 2016   grade_7 123 5 6 0   3     0   2   74 65                       139 123 5 6 0   3     0   2   74 65                 139
941789 941789 MA Worcester   school 2511880 775   Wachusett 251188001494 7750315 Chocksett Middle School   Regular School No 2 05 08 2016   grade_7 87 1 4 0   1     0   0   57 36                       93 87 1 4 0   1     0   0   57 36                 93
941731 941731 MA Dukes   school 2500043 774   Up-Island Regional 250004301927 7740020 West Tisbury Elementary   Regular School No 1 PK 08 2016   grade_7 16 1 1 1   0     0   0   6 13                       19 16 1 1 1   0     0   0   6 13                 19
941710 941710 MA Essex   school 2511740 773   Triton 251174001470 7730405 Triton Regional Middle School   Regular School No 2 07 08 2016   grade_7 185 0 7 2   3     0   3   106 94                       200 185 0 7 2   3     0   3   106 94                 200
941675 941675 MA Worcester   school 2511490 770   Tantasqua 251149001899 7700405 Tantasqua Regional Jr High   Regular School No 2 07 08 2016   grade_7 263 1 12 0   2     0   3   128 153                       281 263 1 12 0   2     0   3   128 153                 281
934639 934639 MA Worcester   school 2504230 77   Douglas 250423002788 770305 Douglas Middle School   Regular School No 2 06 08 2016   grade_7 119 2 3 0   0     1   2   62 65                       127 119 2 3 0   0     1   2   62 65                 127
941668 941668 MA Worcester   school 2500002 767   Spencer-E Brookfield 250000200639 7670415 Knox Trail Middle School   Regular School No 2 05 08 2016   grade_7 95 1 8 1   0     0   2   49 58                       107 95 1 8 1   0     0   2   49 58                 107
941647 941647 MA Hampden   school 2500013 766   Southwick-Tolland-Granville Regional School District 250001301782 7660505 Southwick Regional School   Regular School No 3 07 12 2016   grade_7 103 3 7 0   1     0   2   62 54                       116 103 3 7 0   1     0   2   62 54                 116
941627 941627 MA Berkshire   school 2511040 765   Southern Berkshire 251104001774 7650505 Mt Everett Regional   Regular School No 3 07 12 2016   grade_7 44 2 3 0   0     0   5   28 26                       54 44 2 3 0   0     0   5   28 26                 54
941600 941600 MA Plymouth   school 2510830 760   Silver Lake 251083001721 7600405 Silver Lake Regional Middle School   Regular School No 2 06 08 2016   grade_7 295 3 1 0   5     0   1   146 159                       305 295 3 1 0   5     0   1   146 159                 305
941589 941589 MA Franklin   school 2509900 755   Ralph C Mahar 250990001587 7550505 Ralph C Mahar Regional   Regular School No 3 07 12 2016   grade_7 88 6 14 0   3     0   8   60 59                       119 88 6 14 0   3     0   8   60 59                 119
941580 941580 MA Worcester   school 2500001 753   Quabbin 250000102003 7530405 Quabbin Regional Middle School   Regular School No 2 07 08 2016   grade_7 202 1 7 0   2     0   8   101 119                       220 202 1 7 0   2     0   8   101 119                 220
941545 941545 MA Franklin   school 2509600 750   Pioneer Valley 250960001515 7500505 Pioneer Valley Regional   Regular School No 3 07 12 2016   grade_7 81 2 5 0   1     0   1   53 37                       90 81 2 5 0   1     0   1   53 37                 90
941508 941508 MA Essex   school 2509450 745   Pentucket 250945001512 7450405 Pentucket Regional Middle   Regular School No 2 07 08 2016   grade_7 227 4 3 0   6     0   4   121 123                       244 227 4 3 0   6     0   4   121 123                 244
941478 941478 MA Plymouth   school 2509150 740   Old Rochester 250915001473 7400405 Old Rochester Regional Jr High   Regular School No 2 07 08 2016   grade_7 216 9 1 0   3     0   10   112 127                       239 216 9 1 0   3     0   10   112 127                 239
941462 941462 MA Middlesex   school 2508790 735   North Middlesex 250879002280 7350030 Hawthorne Brook   Regular School No 2 05 08 2016   grade_7 107 1 4 0   2     0   7   61 60                       121 107 1 4 0   2     0   7   61 60                 121
941471 941471 MA Middlesex   school 2508790 735   North Middlesex 250879001762 7350310 Nissitissit Middle School   Regular School No 2 05 08 2016   grade_7 133 2 3 1   2     0   7   73 75                       148 133 2 3 1   2     0   7   73 75                 148
934617 934617 MA Norfolk   school 2504050 73   Dedham 250405000551 730305 Dedham Middle School   Regular School No 2 06 08 2016   grade_7 166 16 27 1   4     0   9   116 107                       223 166 16 27 1   4     0   9   116 107                 223
941423 941423 MA Worcester   school 2508310 725   Nashoba 250831001102 7250025 Florence Sawyer School   Regular School No 1 PK 08 2016   grade_7 97 1 1 0   2     0   0   48 53                       101 97 1 1 0   2     0   0   48 53                 101
941426 941426 MA Worcester   school 2508310 725   Nashoba 250831000947 7250305 Luther Burbank Middle School   Regular School No 2 06 08 2016   grade_7 86 3 2 0   2     0   3   51 45                       96 86 3 2 0   2     0   3   51 45                 96
941429 941429 MA Worcester   school 2508310 725   Nashoba 250831001868 7250310 Hale   Regular School No 2 06 08 2016   grade_7 82 0 1 0   5     0   0   58 30                       88 82 0 1 0   5     0   0   58 30                 88
941395 941395 MA Worcester   school 2508280 720   Narragansett 250828001467 7200305 Narragansett Middle   Regular School No 2 05 08 2016   grade_7 89 1 5 0   1     0   4   51 49                       100 89 1 5 0   1     0   4   51 49                 100
934588 934588 MA Bristol   school 2504020 72   Dartmouth 250402000541 720050 Dartmouth Middle   Regular School No 2 06 08 2016   grade_7 303 6 6 1   1     0   13   156 174                       330 303 6 6 1   1     0   13   156 174                 330
941376 941376 MA Franklin   school 2507990 717   Mohawk Trail 250799001265 7170505 Mohawk Trail Regional High   Regular School No 3 07 12 2016   grade_7 86 0 2 1   0     0   3   45 47                       92 86 0 2 1   0     0   3   45 47                 92
941339 941339 MA Berkshire   school 2508160 715   Mount Greylock 250816001273 7150505 Mt Greylock Regional High   Regular School No 3 07 12 2016   grade_7 86 2 7 0   3     0   10   56 52                       108 86 2 7 0   3     0   10   56 52                 108
941332 941332 MA Barnstable   school 2500544 712   Monomoy Regional School District 250054402832 7120315 Monomoy Regional Middle School   Regular School No 2 05 07 2016   grade_7 116 6 5 1   0     0   6   58 76                       134 116 6 5 1   0     0   6   58 76                 134
941305 941305 MA Worcester   school 2507680 710   Mendon-Upton 250768001279 7100015 Miscoe Hill School   Regular School No 2 04 08 2016   grade_7 180 2 9 0   3     0   7   89 112                       201 180 2 9 0   3     0   7   89 112                 201
934561 934561 MA Essex   school 2503990 71   Danvers 250399002517 710305 Holten Richmond Middle School   Regular School No 2 06 08 2016   grade_7 243 5 21 0   5     0   8   146 136                       282 243 5 21 0   5     0   8   146 136                 282
941291 941291 MA Essex   school 2507410 705   Masconomet 250741001097 7050405 Masconomet Regional Middle School   Regular School No 2 07 08 2016   grade_7 299 2 4 1   14     1   9   154 176                       330 299 2 4 1   14     1   9   154 176                 330
932606 932606 MA Essex   school 2501860 7   Amesbury 250186000035 70013 Amesbury Middle   Regular School No 2 05 08 2016   grade_7 143 3 11 0   1     0   10   89 79                       168 143 3 11 0   1     0   10   89 79                 168
941280 941280 MA Essex   school 2500067 698   Manchester Essex Regional 250006702653 6980030 Manchester Essex Regional Middle School   Regular School No 2 06 08 2016   grade_7 125 0 1 0   4     0   1   62 69                       131 125 0 1 0   4     0   1   62 69                 131
941260 941260 MA Norfolk   school 2506510 690   King Philip 250651000941 6900510 King Philip Middle School   Regular School No 2 07 08 2016   grade_7 343 9 9 0   7     0   4   191 181                       372 343 9 9 0   7     0   4   191 181                 372
941240 941240 MA Hampshire   school 2505740 683   Hampshire 250574000825 6830505 Hampshire Regional High   Regular School No 3 07 12 2016   grade_7 129 2 5 1   1     0   1   64 75                       139 129 2 5 1   1     0   1   64 75                 139
941231 941231 MA Hampden   school 2505730 680   Hampden-Wilbraham 250573002547 6800305 Thornton Burgess   Regular School No 2 05 08 2016   grade_7 56 2 3 0   0     0   1   37 25                       62 56 2 3 0   0     0   1   37 25                 62
941234 941234 MA Hampden   school 2505730 680   Hampden-Wilbraham 250573002141 6800310 Wilbraham Middle   Regular School No 2 06 08 2016   grade_7 134 3 5 0   10     0   3   63 92                       155 134 3 5 0   10     0   3   63 92                 155
941210 941210 MA Essex   school 2505670 675   Hamilton-Wenham 250567001276 6750310 Miles River Middle   Regular School No 2 06 08 2016   grade_7 123 3 3 0   6     0   3   74 64                       138 123 3 3 0   6     0   3   74 64                 138
941183 941183 MA Franklin   school 2505270 674   Gill-Montague 250527002386 6740310 Great Falls Middle   Regular School No 2 06 08 2016   grade_7 68 0 4 0   0     0   2   24 50                       74 68 0 4 0   0     0   2   24 50                 74
941161 941161 MA Middlesex   school 2505500 673   Groton-Dunstable 250550000805 6730305 Groton Dunstable Regional Middle   Regular School No 2 05 08 2016   grade_7 184 3 2 0   13     0   1   115 88                       203 184 3 2 0   13     0   1   115 88                 203
941139 941139 MA Hampshire   school 2505160 672   Gateway 250516002667 6720405 Gateway Regional Junior High School   Regular School No 2 07 08 2016   grade_7 76 0 5 0   0     0   1   43 39                       82 76 0 5 0   0     0   1   43 39                 82
941120 941120 MA Franklin   school 2505100 670   Frontier 250510000749 6700505 Frontier Regional   Regular School No 3 07 12 2016   grade_7 102 1 5 0   4     0   3   58 57                       115 102 1 5 0   4     0   3   58 57                 115
934519 934519 MA Middlesex   school 2503840 67   Concord 250384000522 670305 Concord Middle   Regular School No 2 06 08 2016   grade_7 189 12 11 0   14     0   6   122 110                       232 189 12 11 0   14     0   6   122 110                 232
941114 941114 MA Bristol   school 2505070 665   Freetown-Lakeville 250507000748 6650305 Freetown-Lakeville Middle School   Regular School No 2 06 08 2016   grade_7 245 1 2 0   2     0   3   130 123                       253 245 1 2 0   2     0   3   130 123                 253
941087 941087 MA Barnstable   school 2504560 660   Nauset 250456000609 6600305 Nauset Regional Middle   Regular School No 2 06 08 2016   grade_7 158 3 10 1   4     0   3   83 96                       179 158 3 10 1   4     0   3   83 96                 179
941076 941076 MA Worcester   school 2504360 658   Dudley-Charlton Reg 250436001595 6580305 Dudley Middle School   Regular School No 2 05 08 2016   grade_7 131 3 12 1   4     0   5   83 73                       156 131 3 12 1   4     0   5   83 73                 156
941080 941080 MA Worcester   school 2504360 658   Dudley-Charlton Reg 250436001597 6580310 Charlton Middle School   Regular School No 2 05 08 2016   grade_7 180 0 19 0   1     0   6   103 103                       206 180 0 19 0   1     0   6   103 103                 206
941056 941056 MA Norfolk   school 2504290 655   Dover-Sherborn 250429000575 6550405 Dover-Sherborn Regional Middle School   Regular School No 2 06 08 2016   grade_7 149 3 2 1   11     0   6   95 77                       172 149 3 2 1   11     0   6   95 77                 172
941043 941043 MA Bristol   school 2504200 650   Dighton-Rehoboth 250420000400 6500305 Dighton Middle School   Regular School No 2 05 08 2016   grade_7 108 1 5 0   1     0   2   63 54                       117 108 1 5 0   1     0   2   63 54                 117
941047 941047 MA Bristol   school 2504200 650   Dighton-Rehoboth 250420002430 6500310 Dorothy L Beckwith   Regular School No 2 05 08 2016   grade_7 127 2 6 0   0     0   5   78 62                       140 127 2 6 0   0     0   5   78 62                 140
934492 934492 MA Norfolk   school 2503780 65   Cohasset 250378000518 650505 Cohasset Middle/High School   Regular School No 4 06 12 2016   grade_7 134 5 0 0   5     0   0   72 72                       144 134 5 0 0   5     0   0   72 72                 144
941025 941025 MA Barnstable   school 2504140 645   Dennis-Yarmouth 250414000562 6450305 Mattacheese Middle School   Regular School No 2 06 07 2016   grade_7 155 20 20 10   4     1   14   125 99                       224 155 20 20 10   4     1   14   125 99                 224
934477 934477 MA Worcester   school 2503750 64   Clinton 250375000512 640305 Clinton Middle School   Regular School No 2 04 08 2016   grade_7 102 15 29 0   2     0   3   79 72                       151 102 15 29 0   2     0   3   79 72                 151
940998 940998 MA Berkshire   school 2503390 635   Central Berkshire 250339000466 6350305 Nessacus Regional Middle School   Regular School No 2 06 08 2016   grade_7 139 1 5 1   2     0   6   79 75                       154 139 1 5 1   2     0   6   79 75                 154
934467 934467 MA Berkshire   school 2503720 63   Clarksburg 250372000510 630010 Clarksburg Elementary   Regular School No 1 KG 08 2016   grade_7 16 0 0 0   0     0   0   5 11                       16 16 0 0 0   0     0   0   5 11                 16
940959 940959 MA Bristol   school 2503030 625   Bridgewater-Raynham 250303001674 6250315 Raynham Middle School   Regular School No 2 05 08 2016   grade_7 168 4 5 0   4     0   7   86 102                       188 168 4 5 0   4     0   7   86 102                 188
940961 940961 MA Plymouth   school 2503030 625   Bridgewater-Raynham 250303002659 6250320 Bridgewater Middle School   Regular School No 2 07 08 2016   grade_7 226 11 4 0   2     0   9   121 131                       252 226 11 4 0   2     0   9   121 131                 252
940937 940937 MA Worcester   school 2502715 622   Blackstone-Millville 250271501082 6220405 Frederick W. Hartnett Middle School   Regular School No 2 06 08 2016   grade_7 120 2 10 0   3     0   1   69 67                       136 120 2 10 0   3     0   1   69 67                 136
940917 940917 MA Worcester   school 2502580 620   Berlin-Boylston 250258000160 6200505 Tahanto Regional High   Regular School No 4 06 12 2016   grade_7 76 1 1 0   5     0   3   44 42                       86 76 1 1 0   5     0   3   44 42                 86
940909 940909 MA Berkshire   school 2502530 618   Berkshire Hills 250253002000 6180310 Monument Valley Regional Middle School   Regular School No 2 05 08 2016   grade_7 83 2 7 0   3     2   3   50 50                       100 83 2 7 0   3     2   3   50 50                 100
940895 940895 MA Middlesex   school 2500542 616   Ayer Shirley School District 250054202737 6160305 Ayer Shirley Regional Middle School   Regular School No 2 06 08 2016   grade_7 94 6 8 2   4     0   13   62 65                       127 94 6 8 2   4     0   13   62 65                 127
940873 940873 MA Worcester   school 2502160 615   Athol-Royalston 250216000176 6150305 Athol-Royalston Middle School   Regular School No 2 05 08 2016   grade_7 99 1 10 0   0     0   4   61 53                       114 99 1 10 0   0     0   4   61 53                 114
940846 940846 MA Worcester   school 2502040 610   Ashburnham-Westminster 250204000831 6100305 Overlook Middle School   Regular School No 2 06 08 2016   grade_7 189 0 7 0   3     0   1   99 101                       200 189 0 7 0   3     0   1   99 101                 200
934408 934408 MA Hampden   school 2503660 61   Chicopee 250366000720 610021 Chicopee Academy   Alternative Education School No 4 06 12 2016   grade_7 * * * *   *     *   *   4 1                       5                         4 1                 5
934445 934445 MA Hampden   school 2503660 61   Chicopee 250366000491 610305 Bellamy Middle   Regular School No 2 06 08 2016   grade_7 160 8 97 1   9     0   8   144 139                       283 160 8 97 1   9     0   8   144 139                 283
934448 934448 MA Hampden   school 2503660 61   Chicopee 250366000722 610310 Dupont Middle   Regular School No 2 06 08 2016   grade_7 151 6 83 1   7     0   7   142 113                       255 151 6 83 1   7     0   7   142 113                 255
940825 940825 MA Hampshire   school 2501920 605   Amherst-Pelham 250192000043 6050405 Amherst Regional Middle School   Regular School No 2 07 08 2016   grade_7 121 16 42 0   16     1   20   100 116                       216 121 16 42 0   16     1   20   100 116                 216
940818 940818 MA Berkshire   school 2501780 603   Adams-Cheshire 250178000021 6030505 Hoosac Valley Middle & High School   Regular School No 4 06 12 2016   grade_7 88 7 0 0   2     0   0   55 42                       97 88 7 0 0   2     0   0   55 42                 97

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