enrollments

Data source: Big Local News · About: Big Local

497 rows where grade = "grade_7", state = "MA" and year = 2017 sorted by school

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

  • 2017 · 497 ✖

grade ✖

  • grade_7 · 497 ✖
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
1126677 1126677 MA Middlesex   school 2507320 170   Marlborough 250732002639 1700045 1 LT Charles W. Whitcomb School   Regular School No Middle 05 08 2017   grade_7 132 9 137 0   3     0   13   163 131                       294 132 9 137 0   3     0   13   163 131                 294
1124927 1124927 MA Berkshire   school 2504920 98   Florida 250492000706 980005 Abbott Memorial   Regular School No Elementary PK 08 2017   grade_7 11 0 0 0   0     0   0   6 5                       11 11 0 0 0   0     0   0   6 5                 11
1131333 1131333 MA Worcester   school 2500051 445   Abby Kelley Foster Charter Public (District) 250005101247 4450105 Abby Kelley Foster Charter Public School   Regular School Yes Other KG 12 2017   grade_7 23 63 28 0   7     0   0   55 66                       121 23 63 28 0   7     0   0   55 66                 121
1131127 1131127 MA Suffolk   school 2500021 412   Academy Of the Pacific Rim Charter Public (District) 250002100511 4120530 Academy Of the Pacific Rim Charter Public School   Regular School Yes Other 05 12 2017   grade_7 13 47 20 0   1     0   0   37 44                       81 13 47 20 0   1     0   0   37 44                 81
1131223 1131223 MA Middlesex   school 2500085 430   Advanced Math and Science Academy Charter (District) 250008501984 4300305 Advanced Math and Science Academy Charter School   Regular School Yes Other 06 12 2017   grade_7 103 3 9 0   27     0   9   71 80                       151 103 3 9 0   27     0   9   71 80                 151
1122008 1122008 MA Hampden   school 2501800 5   Agawam 250180000025 50405 Agawam Junior High   Regular School No Middle 07 08 2017   grade_7 211 5 21 0   7     0   9   122 131                       253 211 5 21 0   7     0   9   122 131                 253
1121974 1121974 MA Bristol   school 2501740 3   Acushnet 250174000015 30305 Albert F Ford Middle School   Regular School No Middle 05 08 2017   grade_7 73 0 3 0   0     0   1   42 35                       77 73 0 3 0   0     0   1   42 35                 77
1128973 1128973 MA Middlesex   school 2510890 274   Somerville 251089001739 2740087 Albert F. Argenziano School at Lincoln Park   Regular School No Elementary PK 08 2017   grade_7 18 2 19 0   7     0   2   20 28                       48 18 2 19 0   7     0   2   20 28                 48
1125782 1125782 MA Essex   school 2506660 149   Lawrence 250666000950 1490015 Alexander B Bruce   Regular School No Elementary 03 08 2017   grade_7 2 2 75 0   0     0   0   39 40                       79 2 2 75 0   0     0   0   39 40                 79
1129216 1129216 MA Hampden   school 2511130 281   Springfield 251113001809 2810095 Alfred G. Zanetti Montessori Magnet School   Regular School No Elementary PK 08 2017   grade_7 6 9 14 0   0     0   2   15 16                       31 6 9 14 0   0     0   2   15 16                 31
1131108 1131108 MA Bristol   school 2500525 409   Alma del Mar Charter School (District) 250052502708 4090205 Alma del Mar Charter School   Regular School Yes Elementary KG 07 2017   grade_7 15 7 13 0   2     0   3   17 23                       40 15 7 13 0   2     0   3   17 23                 40
1122032 1122032 MA Essex   school 2501860 7   Amesbury 250186000035 70013 Amesbury Middle   Regular School No Middle 05 08 2017   grade_7 160 0 10 0   2     0   6   96 82                       178 160 0 10 0   2     0   6   96 82                 178
1131765 1131765 MA Hampshire   school 2501920 605   Amherst-Pelham 250192000043 6050405 Amherst Regional Middle School   Regular School No Middle 07 08 2017   grade_7 137 14 31 0   18     1   13   106 108                       214 137 14 31 0   18     1   13   106 108                 214
1123871 1123871 MA Middlesex   school 2503270 49   Cambridge 250327001621 490006 Amigos School   Regular School No Elementary PK 08 2017   grade_7 8 1 11 0   1     0   4   13 12                       25 8 1 11 0   1     0   4   13 12                 25
1122112 1122112 MA Essex   school 2501950 9   Andover 250195002511 90310 Andover West Middle   Regular School No Middle 06 08 2017   grade_7 128 3 9 0   28     0   4   74 98                       172 128 3 9 0   28     0   4   74 98                 172
1125082 1125082 MA Norfolk   school 2505010 101   Franklin 250501001785 1010040 Annie Sullivan Middle School   Regular School No Middle 06 08 2017   grade_7 140 0 5 0   6     2   1   81 73                       154 140 0 5 0   6     2   1   81 73                 154
1133164 1133164 MA Bristol   school 2500552 3509   Argosy Collegiate Charter School (District) 250055202827 35090305 Argosy Collegiate Charter School   Regular School Yes Middle 06 08 2017   grade_7 78 4 12 1   2     1   4   52 50                       102 78 4 12 1   2     1   4   52 50                 102
1125787 1125787 MA Essex   school 2506660 149   Lawrence 250666001945 1490017 Arlington Middle School   Regular School No Middle 05 08 2017   grade_7 3 1 142 0   0     0   0   65 81                       146 3 1 142 0   0     0   0   65 81                 146
1128951 1128951 MA Middlesex   school 2510890 274   Somerville 251089001731 2740075 Arthur D Healey   Regular School No Elementary PK 08 2017   grade_7 21 1 20 0   2     0   2   23 23                       46 21 1 20 0   2     0   2   23 23                 46
1124894 1124894 MA Worcester   school 2504890 97   Fitchburg 250489002672 970315 Arthur M Longsjo Middle School   Regular School No Middle 05 08 2017   grade_7 38 6 49 0   7     0   10   62 48                       110 38 6 49 0   7     0   10   62 48                 110
1128468 1128468 MA Middlesex   school 2509990 246   Reading 250999001605 2460305 Arthur W Coolidge Middle   Regular School No Middle 06 08 2017   grade_7 136 5 1 0   9     0   1   85 67                       152 136 5 1 0   9     0   1   85 67                 152
1123692 1123692 MA Plymouth   school 2503090 44   Brockton 250309002688 440421 Ashfield Middle School   Regular School No Middle 06 08 2017   grade_7 77 64 16 0   4     1   6   83 85                       168 77 64 16 0   4     1   6   83 85                 168
1122195 1122195 MA Middlesex   school 2502100 14   Ashland 250210000938 140405 Ashland Middle   Regular School No Middle 06 08 2017   grade_7 146 5 23 0   27     0   5   93 113                       206 146 5 23 0   27     0   5   93 113                 206
1131815 1131815 MA Worcester   school 2502160 615   Athol-Royalston 250216000176 6150305 Athol-Royalston Middle School   Regular School No Middle 05 08 2017   grade_7 96 1 6 1   0     0   3   53 54                       107 96 1 6 1   0     0   3   53 54                 107
1128361 1128361 MA Norfolk   school 2509870 243   Quincy 250987001561 2430305 Atlantic Middle   Regular School No Middle 06 08 2017   grade_7 66 2 0 0   82     1   9   80 80                       160 66 2 0 0   82     1   9   80 80                 160
1131620 1131620 MA Bristol   school 2500041 491   Atlantis Charter (District) 250004100601 4910550 Atlantis Charter School   Regular School Yes Other KG 11 2017   grade_7 86 3 7 0   2     0   2   50 50                       100 86 3 7 0   2     0   2   50 50                 100
1122272 1122272 MA Worcester   school 2502220 17   Auburn 250222002567 170305 Auburn Middle   Regular School No Middle 06 08 2017   grade_7 179 3 14 0   5     0   9   105 105                       210 179 3 14 0   5     0   9   105 105                 210
1122290 1122290 MA Norfolk   school 2502250 18   Avon 250225001295 180510 Avon Middle High School   Regular School No High 07 12 2017   grade_7 39 12 2 0   3     0   3   33 26                       59 39 12 2 0   3     0   3   33 26                 59
1131840 1131840 MA Middlesex   school 2500542 616   Ayer Shirley School District 250054202737 6160305 Ayer Shirley Regional Middle School   Regular School No Middle 06 08 2017   grade_7 88 5 10 1   2     1   6   52 61                       113 88 5 10 1   2     1   6   52 61                 113
1126267 1126267 MA Middlesex   school 2507020 160   Lowell 250702001026 1600310 B.F. Butler Middle School   Regular School No Middle 05 08 2017   grade_7 49 14 31 0   38     0   9   69 72                       141 49 14 31 0   38     0   9   69 72                 141
1129370 1129370 MA Hampden   school 2511130 281   Springfield 251113002744 2810360 Balliet Middle School   Regular School No Middle 06 08 2017   grade_7 1 2 8 0   0     0   0   7 4                       11 1 2 8 0   0     0   0   7 4                 11
1122323 1122323 MA Barnstable   school 2502310 20   Barnstable 250231002678 200315 Barnstable Intermediate School   Regular School No Middle 06 07 2017   grade_7 302 34 36 2   8     0   15   200 197                       397 302 34 36 2   8     0   15   200 197                 397
1126262 1126262 MA Middlesex   school 2507020 160   Lowell 250702001954 1600090 Bartlett Community Partnership   Regular School No Elementary PK 08 2017   grade_7 12 7 18 0   22     0   0   30 29                       59 12 7 18 0   22     0   0   30 29                 59
1133118 1133118 MA Hampden   school 2500550 3502   Baystate Academy Charter Public School (District) 250055002784 35020405 Baystate Academy Charter Public School   Regular School Yes Other 06 10 2017   grade_7 5 26 50 0   1     0   0   41 41                       82 5 26 50 0   1     0   0   41 41                 82
1126548 1126548 MA Middlesex   school 2507170 165   Malden 250717001344 1650003 Beebe   Regular School No Elementary KG 08 2017   grade_7 24 13 10 0   37     0   1   35 50                       85 24 13 10 0   37     0   1   35 50                 85
1124190 1124190 MA Hampden   school 2503660 61   Chicopee 250366000491 610305 Bellamy Middle   Regular School No Middle 06 08 2017   grade_7 170 7 90 1   5     0   6   142 137                       279 170 7 90 1   5     0   6   142 137                 279
1122383 1122383 MA Norfolk   school 2502460 25   Bellingham 250246001683 250315 Bellingham Memorial School   Regular School No Elementary 04 07 2017   grade_7 165 5 3 0   5     0   4   86 96                       182 165 5 3 0   5     0   4   86 96                 182
1128739 1128739 MA Essex   school 2510500 262   Saugus 251050001685 2620305 Belmonte Saugus Middle   Regular School No Middle 06 08 2017   grade_7 179 12 23 1   6     0   1   109 113                       222 179 12 23 1   6     0   1   109 113                 222
1131361 1131361 MA Norfolk   school 2500030 447   Benjamin Franklin Classical Charter Public (District) 250003000547 4470205 Benjamin Franklin Classical Charter Public School   Regular School Yes Elementary KG 08 2017   grade_7 30 4 0 0   15     0   1   23 27                       50 30 4 0 0   15     0   1   23 27                 50
1129699 1129699 MA Bristol   school 2511520 293   Taunton 251152001662 2930315 Benjamin Friedman Middle   Regular School No Middle 05 07 2017   grade_7 221 22 31 2   3     0   7   142 144                       286 221 22 31 2   3     0   7   142 144                 286
1122439 1122439 MA Bristol   school 2502520 27   Berkley 250252001613 270305 Berkley Middle School   Regular School No Middle 05 08 2017   grade_7 98 1 3 0   2     0   2   54 52                       106 98 1 3 0   2     0   2   54 52                 106
1131142 1131142 MA Berkshire   school 2500079 414   Berkshire Arts and Technology Charter Public (District) 250007901842 4140305 Berkshire Arts and Technology Charter Public School   Regular School Yes Other 06 12 2017   grade_7 55 7 5 0   0     0   4   35 36                       71 55 7 5 0   0     0   4   35 36                 71
1127526 1127526 MA Middlesex   school 2508610 207   Newton 250861000307 2070305 Bigelow Middle   Regular School No Middle 06 08 2017   grade_7 120 10 15 2   26     0   11   90 94                       184 120 10 15 2   26     0   11   90 94                 184
1124560 1124560 MA Hampden   school 2504500 87   East Longmeadow 250450000602 870305 Birchland Park   Regular School No Middle 06 08 2017   grade_7 190 4 14 0   17     0   0   115 110                       225 190 4 14 0   17     0   0   115 110                 225
1129882 1129882 MA Norfolk   school 2511970 307   Walpole 251197001959 3070305 Bird Middle   Regular School No Middle 06 08 2017   grade_7 132 4 9 1   7     0   3   76 80                       156 132 4 9 1   7     0   3   76 80                 156
1130298 1130298 MA Middlesex   school 2512660 326   Westford 251266000170 3260310 Blanchard Middle   Regular School No Middle 06 08 2017   grade_7 144 2 1 2   63     1   1   116 98                       214 144 2 1 2   63     1   1   116 98                 214
1131366 1131366 MA Suffolk   school 2500053 449   Boston Collegiate Charter (District) 250005301256 4490305 Boston Collegiate Charter School   Regular School Yes Other 05 12 2017   grade_7 43 31 23 0   0     0   1   47 51                       98 43 31 23 0   0     0   1   47 51                 98
1131118 1131118 MA Suffolk   school 2500526 411   Boston Green Academy Horace Mann Charter School (District) 250052602703 4110305 Boston Green Academy Horace Mann Charter School   Regular School Yes Other 06 12 2017   grade_7 2 38 16 0   1     0   2   35 24                       59 2 38 16 0   1     0   2   35 24                 59
1123360 1123360 MA Suffolk   school 2502790 35   Boston 250279000203 350560 Boston Latin   Regular School No High 07 12 2017   grade_7 169 23 57 0   116     0   21   162 224                       386 169 23 57 0   116     0   21   162 224                 386
1123335 1123335 MA Suffolk   school 2502790 35   Boston 250279000204 350545 Boston Latin Academy   Regular School No High 07 12 2017   grade_7 82 55 64 0   48     0   13   110 152                       262 82 55 64 0   48     0   13   110 152                 262
1131150 1131150 MA Suffolk   school 2500080 416   Boston Preparatory Charter Public (District) 250008001843 4160305 Boston Preparatory Charter Public School   Regular School Yes Other 06 12 2017   grade_7 1 38 20 0   1     0   1   34 27                       61 1 38 20 0   1     0   1   34 27                 61
1122597 1122597 MA Suffolk   school 2502790 35   Boston 250279002687 350012 Boston Teachers Union School   Regular School No Elementary PK 08 2017   grade_7 1 10 20 0   1     0   3   25 10                       35 1 10 20 0   1     0   3   25 10                 35
1123476 1123476 MA Barnstable   school 2502820 36   Bourne 250282001517 360325 Bourne Middle School   Regular School No Middle 05 08 2017   grade_7 170 3 2 2   6     0   0   86 97                       183 170 3 2 2   6     0   0   86 97                 183
1127587 1127587 MA Berkshire   school 2508670 209   North Adams 250867001390 2090035 Brayton   Regular School No Elementary PK 07 2017   grade_7 24 0 2 0   0     0   2   16 12                       28 24 0 2 0   0     0   2   16 12                 28
1126486 1126486 MA Essex   school 2507110 163   Lynn 250711001063 1630405 Breed Middle School   Regular School No Middle 06 08 2017   grade_7 65 43 261 5   57     0   16   226 221                       447 65 43 261 5   57     0   16   226 221                 447
1131920 1131920 MA Plymouth   school 2503030 625   Bridgewater-Raynham 250303002659 6250320 Bridgewater Middle School   Regular School No Middle 07 08 2017   grade_7 226 6 7 0   2     1   10   152 100                       252 226 6 7 0   2     1   10   152 100                 252
1122488 1122488 MA Essex   school 2502640 30   Beverly 250264000165 300305 Briscoe Middle   Regular School No Middle 06 08 2017   grade_7 290 12 28 0   8     0   11   199 150                       349 290 12 28 0   8     0   11   199 150                 349
1128365 1128365 MA Norfolk   school 2509870 243   Quincy 250987001563 2430310 Broad Meadows Middle   Regular School No Middle 06 08 2017   grade_7 80 6 6 0   19     0   4   66 49                       115 80 6 6 0   19     0   4   66 49                 115
1125355 1125355 MA Worcester   school 2505880 125   Harvard 250588000838 1250505 Bromfield   Regular School No Other 06 12 2017   grade_7 76 2 3 0   16     0   1   44 54                       98 76 2 3 0   16     0   1   44 54                 98
1131207 1131207 MA Suffolk   school 2500071 428   Brooke Charter School Roslindale (District) 250007101747 4280305 Brooke Charter School   Regular School Yes Other KG 09 2017   grade_7 7 75 49 2   1     0   5   80 59                       139 7 75 49 2   1     0   5   80 59                 139
1131031 1131031 MA Worcester   school 2513230 348   Worcester 251323002202 3480405 Burncoat Middle School   Regular School No Middle 07 08 2017   grade_7 105 31 120 0   14     0   25   161 134                       295 105 31 120 0   14     0   25   161 134                 295
1125406 1125406 MA Essex   school 2505970 128   Haverhill 250597000848 1280035 Caleb Dustin Hunking   Regular School No Middle 06 08 2017   grade_7 100 6 21 0   2     0   1   64 66                       130 100 6 21 0   2     0   1   64 66                 130
1123955 1123955 MA Middlesex   school 2503270 49   Cambridge 250327002759 490305 Cambridge Street Upper School   Regular School No Middle 06 08 2017   grade_7 23 30 20 1   8     1   8   44 47                       91 23 30 20 1   8     1   8   44 47                 91
1125021 1125021 MA Middlesex   school 2504980 100   Framingham 250498001530 1000302 Cameron Middle School   Regular School No Middle 06 08 2017   grade_7 117 12 36 1   6     0   6   93 85                       178 117 12 36 1   6     0   6   93 85                 178
1131239 1131239 MA Barnstable   school 2500024 432   Cape Cod Lighthouse Charter (District) 250002400516 4320530 Cape Cod Lighthouse Charter School   Regular School Yes Middle 06 08 2017   grade_7 72 2 4 0   0     0   5   33 50                       83 72 2 4 0   0     0   5   33 50                 83
1124015 1124015 MA Middlesex   school 2503330 51   Carlisle 250333000457 510025 Carlisle School   Regular School No Elementary PK 08 2017   grade_7 52 2 3 0   8     0   8   42 31                       73 52 2 3 0   8     0   8   42 31                 73
1122638 1122638 MA Suffolk   school 2502790 35   Boston 250279000210 350036 Carter Developmental Center   Regular School No High 07 12 2017   grade_7 * * * *   *     *   *   1 2                       *                         1 2                  
1124027 1124027 MA Plymouth   school 2503360 52   Carver 250336002662 520405 Carver Middle/High School   Regular School No Other 06 12 2017   grade_7 109 2 4 0   1     0   0   70 46                       116 109 2 4 0   1     0   0   70 46                 116
1128369 1128369 MA Norfolk   school 2509870 243   Quincy 250987001564 2430315 Central Middle   Regular School No Middle 06 08 2017   grade_7 102 6 6 0   86     2   5   112 95                       207 102 6 6 0   86     2   5   112 95                 207
1132897 1132897 MA Worcester   school 2511880 775   Wachusett 251188001280 7750310 Central Tree Middle   Regular School No Middle 06 08 2017   grade_7 109 1 4 0   1     0   5   67 53                       120 109 1 4 0   1     0   5   67 53                 120
1127530 1127530 MA Middlesex   school 2508610 207   Newton 250861000310 2070310 Charles E Brown Middle   Regular School No Middle 06 08 2017   grade_7 162 14 22 0   66     0   17   161 120                       281 162 14 22 0   66     0   17   161 120                 281
1127085 1127085 MA Norfolk   school 2507980 189   Milton 250798001257 1890410 Charles S Pierce Middle   Regular School No Middle 06 08 2017   grade_7 208 36 15 2   15     2   11   145 144                       289 208 36 15 2   15     2   11   145 144                 289
1132069 1132069 MA Worcester   school 2504360 658   Dudley-Charlton Reg 250436001597 6580310 Charlton Middle School   Regular School No Middle 05 08 2017   grade_7 165 2 4 0   3     0   2   98 78                       176 165 2 4 0   3     0   2   98 78                 176
1129374 1129374 MA Hampden   school 2511130 281   Springfield 251113002830 2810365 Chestnut Accelerated Middle School (North)   Regular School No Middle 06 08 2017   grade_7 2 11 91 0   0     0   0   58 46                       104 2 11 91 0   0     0   0   58 46                 104
1129378 1129378 MA Hampden   school 2511130 281   Springfield 251113002837 2810366 Chestnut Accelerated Middle School (South)   Regular School No Middle 06 08 2017   grade_7 4 13 87 0   1     0   0   53 52                       105 4 13 87 0   1     0   0   53 52                 105
1129382 1129382 MA Hampden   school 2511130 281   Springfield 251113002840 2810367 Chestnut Accelerated Middle School (Talented and Gifted)   Regular School No Middle 06 08 2017   grade_7 15 23 62 1   1     0   2   50 54                       104 15 23 62 1   1     0   2   50 54                 104
1124147 1124147 MA Hampden   school 2503660 61   Chicopee 250366000720 610021 Chicopee Academy   Alternative School No Other 06 12 2017   grade_7 1 0 9 0   0     0   0   9 1                       10 1 0 9 0   0     0   0   9 1                 10
1132902 1132902 MA Worcester   school 2511880 775   Wachusett 251188001494 7750315 Chocksett Middle School   Regular School No Middle 05 08 2017   grade_7 87 3 1 0   1     0   0   48 44                       92 87 3 1 0   1     0   0   48 44                 92
1131166 1131166 MA Middlesex   school 2500068 418   Christa McAuliffe Charter Public (District) 250006801746 4180305 Christa McAuliffe Charter Public School   Regular School Yes Middle 06 08 2017   grade_7 73 10 25 2   5     1   9   63 62                       125 73 10 25 2   5     1   9   63 62                 125
1131024 1131024 MA Worcester   school 2513230 348   Worcester 251323002121 3480350 Claremont Academy   Regular School No High 07 12 2017   grade_7 7 7 63 0   8     0   1   39 47                       86 7 7 63 0   8     0   1   39 47                 86
1123259 1123259 MA Suffolk   school 2502790 35   Boston 250279000216 350430 Clarence R Edwards Middle   Regular School No Middle 06 08 2017   grade_7 9 16 75 0   7     0   3   58 52                       110 9 16 75 0   7     0   3   58 52                 110
1124106 1124106 MA Suffolk   school 2503540 57   Chelsea 250354001158 570050 Clark Avenue School   Regular School No Middle 05 08 2017   grade_7 1 2 117 0   2     0   1   65 58                       123 1 2 117 0   2     0   1   65 58                 123
1124214 1124214 MA Berkshire   school 2503720 63   Clarksburg 250372000510 630010 Clarksburg Elementary   Regular School No Elementary KG 08 2017   grade_7 16 0 1 0   1     0   1   10 9                       19 16 0 1 0   1     0   1   10 9                 19
1124226 1124226 MA Worcester   school 2503750 64   Clinton 250375000512 640305 Clinton Middle School   Regular School No Elementary 04 08 2017   grade_7 90 4 30 0   1     0   2   70 57                       127 90 4 30 0   1     0   2   70 57                 127
1131272 1131272 MA Suffolk   school 2500070 438   Codman Academy Charter Public (District) 250007001667 4380505 Codman Academy Charter Public School   Regular School Yes Other PK 12 2017   grade_7 0 15 4 0   0     0   1   8 12                       20 0 15 4 0   0     0   1   8 12                 20
1124245 1124245 MA Norfolk   school 2503780 65   Cohasset 250378000518 650505 Cohasset Middle/High School   Regular School No Other 06 12 2017   grade_7 114 4 3 2   3     0   2   64 64                       128 114 4 3 2   3     0   2   64 64                 128
1124062 1124062 MA Middlesex   school 2503510 56   Chelmsford 250351000476 560305 Col Moses Parker School   Regular School No Middle 05 08 2017   grade_7 133 3 11 0   34     0   0   88 93                       181 133 3 11 0   34     0   0   88 93                 181
1127568 1127568 MA Berkshire   school 2508670 209   North Adams 250867001388 2090008 Colegrove Park Elementary   Regular School No Elementary KG 07 2017   grade_7 24 0 0 0   0     0   1   11 14                       25 24 0 0 0   0     0   1   11 14                 25
1128671 1128671 MA Essex   school 2510380 258   Salem 251038002404 2580305 Collins Middle   Regular School No Middle 06 08 2017   grade_7 88 8 64 0   5     0   7   94 78                       172 88 8 64 0   5     0   7   94 78                 172
1131252 1131252 MA Middlesex   school 2500086 436   Community Charter School of Cambridge (District) 250008601996 4360305 Community Charter School of Cambridge   Regular School Yes Other 06 12 2017   grade_7 4 28 13 0   4     0   1   25 25                       50 4 28 13 0   4     0   1   25 25                 50
1131298 1131298 MA Essex   school 2500027 440   Community Day Charter Public School - Prospect (District) 250002700535 4400205 Community Day Charter Public School - Prospect   Regular School Yes Elementary PK 08 2017   grade_7 2 0 19 0   1     0   0   12 10                       22 2 0 19 0   1     0   0   12 10                 22
1126933 1126933 MA Essex   school 2507740 181   Methuen 250774002558 1810050 Comprehensive Grammar School   Regular School No Elementary PK 08 2017   grade_7 95 0 36 0   11     0   5   83 64                       147 95 0 36 0   11     0   5   83 64                 147
1124276 1124276 MA Middlesex   school 2503840 67   Concord 250384000522 670305 Concord Middle   Regular School No Middle 06 08 2017   grade_7 198 11 11 1   14     0   14   103 146                       249 198 11 11 1   14     0   14   103 146                 249
1125449 1125449 MA Essex   school 2505970 128   Haverhill 250597000850 1280100 Consentino Middle School   Regular School No Elementary 01 08 2017   grade_7 96 8 98 0   3     0   1   99 107                       206 96 8 98 0   3     0   1   99 107                 206
1131287 1131287 MA Suffolk   school 2500060 439   Conservatory Lab Charter (District) 250006001439 4390050 Conservatory Lab Charter School   Regular School Yes Elementary PK 08 2017   grade_7 3 27 11 0   0     0   0   20 21                       41 3 27 11 0   0     0   0   20 21                 41
1129386 1129386 MA Hampden   school 2511130 281   Springfield 251113002818 2810475 Conservatory of the Arts   Regular School No Other 06 11 2017   grade_7 3 12 43 0   0     0   1   17 42                       59 3 12 43 0   0     0   1   17 42                 59
1127973 1127973 MA Hampden   school 2509300 227   Palmer 250930002595 2270305 Converse Middle   Regular School No Middle 06 07 2017   grade_7 102 4 10 0   1     0   2   67 52                       119 102 4 10 0   1     0   2   67 52                 119
1122629 1122629 MA Suffolk   school 2502790 35   Boston 250279002622 350020 Curley K-8 School   Regular School No Elementary PK 08 2017   grade_7 2 16 51 0   1     0   0   45 25                       70 2 16 51 0   1     0   0   45 25                 70
1125193 1125193 MA Dukes   school 2505340 109   Gosnold 250534000725 1090005 Cuttyhunk Elementary   Regular School No Middle 06 07 2017   grade_7 * * * *   *     *   *   * *                       *                                              
1122242 1122242 MA Bristol   school 2502190 16   Attleboro 250219000087 160315 Cyril K. Brennan Middle School   Regular School No Middle 05 08 2017   grade_7 97 8 24 0   4     0   8   77 64                       141 97 8 24 0   4     0   8   77 64                 141

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