enrollments
Data source: Big Local News · About: Big Local
491 rows where grade = "grade_7", state = "MA" and year = 2016 sorted by female
This data as json, CSV (advanced)
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
936167 | 936167 | MA | Middlesex | school | 2507020 | 160 | Lowell | 250702002726 | 1600085 | Laura Lee Therapeutic Day School | Regular School | No | 1 | 02 | 07 | 2016 | grade_7 | * | * | * | * | * | * | * | 3 | * | 3 | 3 | 3 | |||||||||||||||||||||||||||||||||||||||||
938479 | 938479 | MA | Middlesex | school | 2510890 | 274 | Somerville | 251089002498 | 2740410 | Next Wave Junior High | Alternative Education School | No | 2 | 06 | 08 | 2016 | grade_7 | 1 | 3 | 5 | 0 | 0 | 0 | 0 | 7 | * | 9 | 1 | 3 | 5 | 0 | 0 | 0 | 0 | 7 | 9 | ||||||||||||||||||||||||||||||||||
932584 | 932584 | MA | Hampden | school | 2501800 | 5 | Agawam | 250180000026 | 50303 | Roberta G. Doering School | Regular School | No | 2 | 04 | 08 | 2016 | grade_7 | * | * | * | * | * | * | * | 2 | 1 | 3 | 2 | 1 | 3 | ||||||||||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||||||||
937117 | 937117 | MA | Bristol | school | 2508430 | 201 | New Bedford | 250843002590 | 2010510 | Trinity Day Academy | Regular School | No | 4 | 06 | 12 | 2016 | grade_7 | * | * | * | * | * | * | * | 3 | 1 | 4 | 3 | 1 | 4 | ||||||||||||||||||||||||||||||||||||||||
933187 | 933187 | MA | Suffolk | school | 2502790 | 35 | Boston | 250279000230 | 350096 | Eliot Elementary | Regular School | No | 1 | PK | 08 | 2016 | grade_7 | 8 | 7 | 11 | 0 | 3 | 0 | 1 | 20 | 10 | 30 | 8 | 7 | 11 | 0 | 3 | 0 | 1 | 20 | 10 | 30 | |||||||||||||||||||||||||||||||||
933515 | 933515 | MA | Suffolk | school | 2502790 | 35 | Boston | 250279000331 | 350326 | Gardner Pilot Academy | Regular School | No | 1 | PK | 08 | 2016 | grade_7 | 7 | 5 | 20 | 0 | 1 | 0 | 1 | 24 | 10 | 34 | 7 | 5 | 20 | 0 | 1 | 0 | 1 | 24 | 10 | 34 | |||||||||||||||||||||||||||||||||
935412 | 935412 | MA | Hampshire | school | 2505940 | 127 | Hatfield | 250594000845 | 1270505 | Smith Academy | Regular School | No | 3 | 07 | 12 | 2016 | grade_7 | 35 | 0 | 1 | 0 | 0 | 0 | 0 | 26 | 10 | 36 | 35 | 0 | 1 | 0 | 0 | 0 | 0 | 26 | 10 | 36 | |||||||||||||||||||||||||||||||||
937286 | 937286 | MA | Berkshire | school | 2508670 | 209 | North Adams | 250867001390 | 2090035 | Brayton | Regular School | No | 1 | PK | 07 | 2016 | grade_7 | 26 | 1 | 1 | 0 | 0 | 0 | 3 | 21 | 10 | 31 | 26 | 1 | 1 | 0 | 0 | 0 | 3 | 21 | 10 | 31 | |||||||||||||||||||||||||||||||||
938986 | 938986 | MA | Essex | school | 2511430 | 291 | Swampscott | 251143002562 | 2910305 | Swampscott Middle | Regular School | No | 2 | 05 | 08 | 2016 | grade_7 | 157 | 7 | 20 | 0 | 2 | 0 | 5 | 91 | 100 | 191 | 157 | 7 | 20 | 0 | 2 | 0 | 5 | 91 | 100 | 191 | |||||||||||||||||||||||||||||||||
937774 | 937774 | MA | Berkshire | school | 2509630 | 236 | Pittsfield | 250963001532 | 2360310 | Theodore Herberg Middle | Regular School | No | 2 | 06 | 08 | 2016 | grade_7 | 147 | 20 | 26 | 1 | 6 | 0 | 9 | 108 | 101 | 209 | 147 | 20 | 26 | 1 | 6 | 0 | 9 | 108 | 101 | 209 | |||||||||||||||||||||||||||||||||
938082 | 938082 | MA | Suffolk | school | 2510050 | 248 | Revere | 251005001976 | 2480057 | Garfield Middle School | Regular School | No | 2 | 06 | 08 | 2016 | grade_7 | 60 | 7 | 90 | 2 | 14 | 0 | 4 | 76 | 101 | 177 | 60 | 7 | 90 | 2 | 14 | 0 | 4 | 76 | 101 | 177 | |||||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||||
936399 | 936399 | MA | Essex | school | 2507140 | 164 | Lynnfield | 250714001091 | 1640405 | Lynnfield Middle School | Regular School | No | 2 | 05 | 08 | 2016 | grade_7 | 170 | 1 | 10 | 0 | 6 | 0 | 5 | 90 | 102 | 192 | 170 | 1 | 10 | 0 | 6 | 0 | 5 | 90 | 102 | 192 | |||||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||||
935678 | 935678 | MA | Middlesex | school | 2506390 | 141 | Hudson | 250639000927 | 1410410 | David J. Quinn Middle School | Regular School | No | 2 | 05 | 07 | 2016 | grade_7 | 191 | 4 | 11 | 2 | 3 | 0 | 3 | 111 | 103 | 214 | 191 | 4 | 11 | 2 | 3 | 0 | 3 | 111 | 103 | 214 | |||||||||||||||||||||||||||||||||
938085 | 938085 | MA | Suffolk | school | 2510050 | 248 | Revere | 251005002113 | 2480305 | Susan B. Anthony Middle School | Regular School | No | 2 | 06 | 08 | 2016 | grade_7 | 68 | 6 | 103 | 2 | 4 | 0 | 6 | 86 | 103 | 189 | 68 | 6 | 103 | 2 | 4 | 0 | 6 | 86 | 103 | 189 | |||||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||||
938865 | 938865 | MA | Middlesex | school | 2511220 | 284 | Stoneham | 251122001857 | 2840405 | Stoneham Central Middle School | Regular School | No | 2 | 05 | 08 | 2016 | grade_7 | 171 | 4 | 15 | 0 | 8 | 0 | 7 | 101 | 104 | 205 | 171 | 4 | 15 | 0 | 8 | 0 | 7 | 101 | 104 | 205 | |||||||||||||||||||||||||||||||||
937478 | 937478 | MA | Middlesex | school | 2508820 | 217 | North Reading | 250882002592 | 2170305 | North Reading Middle | Regular School | No | 2 | 06 | 08 | 2016 | grade_7 | 188 | 4 | 3 | 0 | 8 | 0 | 5 | 103 | 105 | 208 | 188 | 4 | 3 | 0 | 8 | 0 | 5 | 103 | 105 | 208 | |||||||||||||||||||||||||||||||||
932802 | 932802 | MA | Worcester | school | 2502220 | 17 | Auburn | 250222002567 | 170305 | Auburn Middle | Regular School | No | 2 | 06 | 08 | 2016 | grade_7 | 181 | 3 | 6 | 1 | 10 | 0 | 5 | 100 | 106 | 206 | 181 | 3 | 6 | 1 | 10 | 0 | 5 | 100 | 106 | 206 | |||||||||||||||||||||||||||||||||
937319 | 937319 | MA | Hampshire | school | 2508850 | 210 | Northampton | 250885001430 | 2100410 | John F Kennedy Middle School | Regular School | No | 2 | 06 | 08 | 2016 | grade_7 | 145 | 7 | 33 | 0 | 6 | 0 | 11 | 96 | 106 | 202 | 145 | 7 | 33 | 0 | 6 | 0 | 11 | 96 | 106 | 202 | |||||||||||||||||||||||||||||||||
937992 | 937992 | MA | Norfolk | school | 2509930 | 244 | Randolph | 250993001392 | 2440410 | Randolph Community Middle | Regular School | No | 2 | 06 | 08 | 2016 | grade_7 | 29 | 113 | 37 | 0 | 41 | 1 | 8 | 123 | 106 | 229 | 29 | 113 | 37 | 0 | 41 | 1 | 8 | 123 | 106 | 229 | |||||||||||||||||||||||||||||||||
939323 | 939323 | MA | Middlesex | school | 2512180 | 314 | Watertown | 251218002501 | 3140305 | Watertown Middle | Regular School | No | 2 | 06 | 08 | 2016 | grade_7 | 137 | 8 | 38 | 2 | 20 | 0 | 6 | 105 | 106 | 211 | 137 | 8 | 38 | 2 | 20 | 0 | 6 | 105 | 106 | 211 | |||||||||||||||||||||||||||||||||
932740 | 932740 | MA | Middlesex | school | 2502100 | 14 | Ashland | 250210000938 | 140405 | Ashland Middle | Regular School | No | 2 | 06 | 08 | 2016 | grade_7 | 150 | 4 | 25 | 0 | 18 | 0 | 8 | 98 | 107 | 205 | 150 | 4 | 25 | 0 | 18 | 0 | 8 | 98 | 107 | 205 | |||||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||||
935475 | 935475 | MA | Essex | school | 2505970 | 128 | Haverhill | 250597000850 | 1280100 | Consentino Middle School | Regular School | No | 1 | 01 | 08 | 2016 | grade_7 | 136 | 7 | 66 | 0 | 2 | 0 | 2 | 106 | 107 | 213 | 136 | 7 | 66 | 0 | 2 | 0 | 2 | 106 | 107 | 213 | |||||||||||||||||||||||||||||||||
938774 | 938774 | MA | Hampden | school | 2511130 | 281 | Springfield | 251113002602 | 2810330 | M Marcus Kiley Middle | Regular School | No | 2 | 06 | 08 | 2016 | grade_7 | 26 | 54 | 119 | 0 | 9 | 0 | 3 | 104 | 107 | 211 | 26 | 54 | 119 | 0 | 9 | 0 | 3 | 104 | 107 | 211 | |||||||||||||||||||||||||||||||||
937947 | 937947 | MA | Norfolk | school | 2509870 | 243 | Quincy | 250987001564 | 2430315 | Central Middle | Regular School | No | 2 | 06 | 08 | 2016 | grade_7 | 119 | 5 | 6 | 0 | 89 | 1 | 6 | 117 | 109 | 226 | 119 | 5 | 6 | 0 | 89 | 1 | 6 | 117 | 109 | 226 | |||||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||||
935383 | 935383 | MA | Plymouth | school | 2505790 | 122 | Hanover | 250579002548 | 1220305 | Hanover Middle | Regular School | No | 2 | 05 | 08 | 2016 | grade_7 | 214 | 1 | 5 | 0 | 7 | 0 | 0 | 117 | 110 | 227 | 214 | 1 | 5 | 0 | 7 | 0 | 0 | 117 | 110 | 227 | |||||||||||||||||||||||||||||||||
933903 | 933903 | MA | Norfolk | school | 2502940 | 40 | Braintree | 250294000372 | 400310 | South Middle School | Regular School | No | 2 | 06 | 08 | 2016 | grade_7 | 173 | 4 | 4 | 0 | 33 | 0 | 3 | 106 | 111 | 217 | 173 | 4 | 4 | 0 | 33 | 0 | 3 | 106 | 111 | 217 | |||||||||||||||||||||||||||||||||
934016 | 934016 | MA | Plymouth | school | 2503090 | 44 | Brockton | 250309000410 | 440420 | West Middle School | Regular School | No | 2 | 06 | 08 | 2016 | grade_7 | 55 | 124 | 28 | 0 | 5 | 2 | 10 | 113 | 111 | 224 | 55 | 124 | 28 | 0 | 5 | 2 | 10 | 113 | 111 | 224 | |||||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||||
939554 | 939554 | MA | Middlesex | school | 2512660 | 326 | Westford | 251266000170 | 3260310 | Blanchard Middle | Regular School | No | 2 | 06 | 08 | 2016 | grade_7 | 143 | 3 | 1 | 2 | 51 | 0 | 5 | 94 | 111 | 205 | 143 | 3 | 1 | 2 | 51 | 0 | 5 | 94 | 111 | 205 | |||||||||||||||||||||||||||||||||
937237 | 937237 | MA | Middlesex | school | 2508610 | 207 | Newton | 250861000310 | 2070310 | Charles E Brown Middle | Regular School | No | 2 | 06 | 08 | 2016 | grade_7 | 169 | 9 | 13 | 1 | 50 | 0 | 12 | 142 | 112 | 254 | 169 | 9 | 13 | 1 | 50 | 0 | 12 | 142 | 112 | 254 | |||||||||||||||||||||||||||||||||
937428 | 937428 | MA | Worcester | school | 2508880 | 213 | Northborough | 250888001440 | 2130305 | Robert E. Melican Middle School | Regular School | No | 2 | 06 | 08 | 2016 | grade_7 | 194 | 2 | 10 | 2 | 25 | 0 | 10 | 131 | 112 | 243 | 194 | 2 | 10 | 2 | 25 | 0 | 10 | 131 | 112 | 243 | |||||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||||
934022 | 934022 | MA | Plymouth | school | 2503090 | 44 | Brockton | 250309002691 | 440422 | Joseph F. Plouffe Academy | Regular School | No | 2 | 06 | 08 | 2016 | grade_7 | 63 | 91 | 51 | 2 | 7 | 0 | 10 | 111 | 113 | 224 | 63 | 91 | 51 | 2 | 7 | 0 | 10 | 111 | 113 | 224 | |||||||||||||||||||||||||||||||||
934344 | 934344 | MA | Middlesex | school | 2503510 | 56 | Chelmsford | 250351000478 | 560310 | McCarthy Middle School | Regular School | No | 2 | 05 | 08 | 2016 | grade_7 | 184 | 4 | 7 | 0 | 22 | 0 | 6 | 110 | 113 | 223 | 184 | 4 | 7 | 0 | 22 | 0 | 6 | 110 | 113 | 223 | |||||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||||
935295 | 935295 | MA | Worcester | school | 2505370 | 110 | Grafton | 250537002520 | 1100305 | Grafton Middle | Regular School | No | 2 | 07 | 08 | 2016 | grade_7 | 176 | 4 | 9 | 0 | 23 | 0 | 8 | 107 | 113 | 220 | 176 | 4 | 9 | 0 | 23 | 0 | 8 | 107 | 113 | 220 | |||||||||||||||||||||||||||||||||
935545 | 935545 | MA | Middlesex | school | 2506240 | 136 | Holliston | 250624001304 | 1360305 | Robert H. Adams Middle School | Regular School | No | 2 | 06 | 08 | 2016 | grade_7 | 198 | 1 | 5 | 2 | 15 | 0 | 5 | 113 | 113 | 226 | 198 | 1 | 5 | 2 | 15 | 0 | 5 | 113 | 113 | 226 | |||||||||||||||||||||||||||||||||
937704 | 937704 | MA | Plymouth | school | 2509420 | 231 | Pembroke | 250942001823 | 2310305 | Pembroke Community Middle School | Regular School | No | 2 | 07 | 08 | 2016 | grade_7 | 236 | 3 | 3 | 0 | 2 | 0 | 3 | 134 | 113 | 247 | 236 | 3 | 3 | 0 | 2 | 0 | 3 | 134 | 113 | 247 | |||||||||||||||||||||||||||||||||
938768 | 938768 | MA | Hampden | school | 2511130 | 281 | Springfield | 251113002600 | 2810325 | Forest Park Middle | Regular School | No | 2 | 06 | 08 | 2016 | grade_7 | 22 | 47 | 141 | 0 | 18 | 0 | 0 | 114 | 114 | 228 | 22 | 47 | 141 | 0 | 18 | 0 | 0 | 114 | 114 | 228 | |||||||||||||||||||||||||||||||||
937243 | 937243 | MA | Middlesex | school | 2508610 | 207 | Newton | 250861001042 | 2070320 | Oak Hill Middle | Regular School | No | 2 | 06 | 08 | 2016 | grade_7 | 122 | 10 | 15 | 0 | 47 | 0 | 14 | 93 | 115 | 208 | 122 | 10 | 15 | 0 | 47 | 0 | 14 | 93 | 115 | 208 | |||||||||||||||||||||||||||||||||
938218 | 938218 | MA | Barnstable | school | 2510470 | 261 | Sandwich | 251047002824 | 2610305 | Sandwich STEM Academy | Regular School | No | 2 | 07 | 08 | 2016 | grade_7 | 222 | 1 | 2 | 3 | 9 | 1 | 1 | 123 | 116 | 239 | 222 | 1 | 2 | 3 | 9 | 1 | 1 | 123 | 116 | 239 | |||||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||||
933900 | 933900 | MA | Norfolk | school | 2502940 | 40 | Braintree | 250294000364 | 400305 | East Middle School | Regular School | No | 2 | 06 | 08 | 2016 | grade_7 | 191 | 15 | 8 | 0 | 37 | 0 | 3 | 137 | 117 | 254 | 191 | 15 | 8 | 0 | 37 | 0 | 3 | 137 | 117 | 254 | |||||||||||||||||||||||||||||||||
937844 | 937844 | MA | Plymouth | school | 2509720 | 239 | Plymouth | 250972001380 | 2390305 | Plymouth South Middle | Regular School | No | 2 | 05 | 08 | 2016 | grade_7 | 241 | 2 | 2 | 1 | 4 | 0 | 5 | 138 | 117 | 255 | 241 | 2 | 2 | 1 | 4 | 0 | 5 | 138 | 117 | 255 | |||||||||||||||||||||||||||||||||
939056 | 939056 | MA | Bristol | school | 2511520 | 293 | Taunton | 251152001662 | 2930315 | Benjamin Friedman Middle | Regular School | No | 2 | 05 | 07 | 2016 | grade_7 | 192 | 19 | 25 | 1 | 1 | 0 | 12 | 133 | 117 | 250 | 192 | 19 | 25 | 1 | 1 | 0 | 12 | 133 | 117 | 250 | |||||||||||||||||||||||||||||||||
939520 | 939520 | MA | Hampden | school | 2512630 | 325 | Westfield | 251263001569 | 3250305 | North Middle School | Regular School | No | 2 | 06 | 08 | 2016 | grade_7 | 185 | 2 | 22 | 0 | 2 | 1 | 5 | 99 | 118 | 217 | 185 | 2 | 22 | 0 | 2 | 1 | 5 | 99 | 118 | 217 | |||||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||||
933310 | 933310 | MA | Suffolk | school | 2502790 | 35 | Boston | 250279000272 | 350182 | Joseph J Hurley | Regular School | No | 1 | PK | 08 | 2016 | grade_7 | 0 | 0 | 17 | 0 | 0 | 0 | 0 | 5 | 12 | 17 | 0 | 0 | 17 | 0 | 0 | 0 | 0 | 5 | 12 | 17 | |||||||||||||||||||||||||||||||||
933602 | 933602 | MA | Suffolk | school | 2502790 | 35 | Boston | 250279002677 | 350377 | Higginson/Lewis K-8 | Regular School | No | 1 | PK | 08 | 2016 | grade_7 | 1 | 16 | 10 | 0 | 1 | 0 | 0 | 16 | 12 | 28 | 1 | 16 | 10 | 0 | 1 | 0 | 0 | 16 | 12 | 28 | |||||||||||||||||||||||||||||||||
940475 | 940475 | MA | Hampshire | school | 2500031 | 450 | Hilltown Cooperative Charter Public (District) | 250003100549 | 4500105 | Hilltown Cooperative Charter Public School | Regular School | Yes | 1 | KG | 08 | 2016 | grade_7 | 29 | 0 | 2 | 0 | 0 | 0 | 0 | 19 | 12 | 31 | 29 | 0 | 2 | 0 | 0 | 0 | 0 | 19 | 12 | 31 | |||||||||||||||||||||||||||||||||
936007 | 936007 | MA | Middlesex | school | 2506840 | 155 | Lexington | 250684002552 | 1550310 | Wm Diamond Middle | Regular School | No | 2 | 06 | 08 | 2016 | grade_7 | 147 | 5 | 10 | 1 | 78 | 0 | 13 | 134 | 120 | 254 | 147 | 5 | 10 | 1 | 78 | 0 | 13 | 134 | 120 | 254 | |||||||||||||||||||||||||||||||||
939348 | 939348 | MA | Middlesex | school | 2512210 | 315 | Wayland | 251221002502 | 3150305 | Wayland Middle School | Regular School | No | 2 | 06 | 08 | 2016 | grade_7 | 163 | 11 | 8 | 0 | 35 | 0 | 16 | 111 | 122 | 233 | 163 | 11 | 8 | 0 | 35 | 0 | 16 | 111 | 122 | 233 | |||||||||||||||||||||||||||||||||
935148 | 935148 | MA | Middlesex | school | 2504980 | 100 | Framingham | 250498000733 | 1000310 | Walsh Middle | Regular School | No | 2 | 06 | 08 | 2016 | grade_7 | 136 | 7 | 58 | 0 | 20 | 0 | 6 | 104 | 123 | 227 | 136 | 7 | 58 | 0 | 20 | 0 | 6 | 104 | 123 | 227 | |||||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||||
940647 | 940647 | MA | Suffolk | school | 2500063 | 484 | Roxbury Preparatory Charter (District) | 250006301453 | 4840505 | Roxbury Preparatory Charter School | Regular School | Yes | 2 | 05 | 09 | 2016 | grade_7 | 1 | 119 | 114 | 1 | 1 | 1 | 1 | 114 | 124 | 238 | 1 | 119 | 114 | 1 | 1 | 1 | 1 | 114 | 124 | 238 | |||||||||||||||||||||||||||||||||
934154 | 934154 | MA | Middlesex | school | 2503240 | 48 | Burlington | 250324000429 | 480303 | Marshall Simonds Middle | Regular School | No | 2 | 06 | 08 | 2016 | grade_7 | 216 | 9 | 8 | 1 | 29 | 0 | 9 | 147 | 125 | 272 | 216 | 9 | 8 | 1 | 29 | 0 | 9 | 147 | 125 | 272 | |||||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||||
936220 | 936220 | MA | Hampden | school | 2507050 | 161 | Ludlow | 250705001055 | 1610305 | Paul R Baird Middle | Regular School | No | 2 | 06 | 08 | 2016 | grade_7 | 204 | 5 | 15 | 1 | 3 | 2 | 5 | 110 | 125 | 235 | 204 | 5 | 15 | 1 | 3 | 2 | 5 | 110 | 125 | 235 | |||||||||||||||||||||||||||||||||
937551 | 937551 | MA | Norfolk | school | 2509060 | 220 | Norwood | 250906001468 | 2200305 | Dr. Philip O. Coakley Middle School | Regular School | No | 2 | 06 | 08 | 2016 | grade_7 | 178 | 19 | 23 | 0 | 21 | 0 | 7 | 123 | 125 | 248 | 178 | 19 | 23 | 0 | 21 | 0 | 7 | 123 | 125 | 248 | |||||||||||||||||||||||||||||||||
939557 | 939557 | MA | Middlesex | school | 2512660 | 326 | Westford | 251266002080 | 3260330 | Stony Brook School | Regular School | No | 2 | 06 | 08 | 2016 | grade_7 | 185 | 1 | 6 | 0 | 51 | 0 | 9 | 127 | 125 | 252 | 185 | 1 | 6 | 0 | 51 | 0 | 9 | 127 | 125 | 252 | |||||||||||||||||||||||||||||||||
939045 | 939045 | MA | Bristol | school | 2511520 | 293 | Taunton | 251152001911 | 2930042 | Joseph H Martin | Regular School | No | 2 | 05 | 07 | 2016 | grade_7 | 156 | 34 | 32 | 0 | 4 | 0 | 8 | 108 | 126 | 234 | 156 | 34 | 32 | 0 | 4 | 0 | 8 | 108 | 126 | 234 | |||||||||||||||||||||||||||||||||
936773 | 936773 | MA | Plymouth | school | 2507770 | 182 | Middleborough | 250777001378 | 1820305 | John T. Nichols Middle | Regular School | No | 2 | 06 | 08 | 2016 | grade_7 | 246 | 4 | 9 | 0 | 2 | 0 | 5 | 139 | 127 | 266 | 246 | 4 | 9 | 0 | 2 | 0 | 5 | 139 | 127 | 266 | |||||||||||||||||||||||||||||||||
936938 | 936938 | MA | Middlesex | school | 2508340 | 198 | Natick | 250834001305 | 1980310 | Wilson Middle | Regular School | No | 2 | 05 | 08 | 2016 | grade_7 | 170 | 7 | 26 | 0 | 13 | 1 | 17 | 107 | 127 | 234 | 170 | 7 | 26 | 0 | 13 | 1 | 17 | 107 | 127 | 234 | |||||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||||
935948 | 935948 | MA | Worcester | school | 2506780 | 153 | Leominster | 250678002045 | 1530320 | Sky View Middle School | Regular School | No | 2 | 06 | 08 | 2016 | grade_7 | 160 | 17 | 88 | 0 | 10 | 0 | 8 | 155 | 128 | 283 | 160 | 17 | 88 | 0 | 10 | 0 | 8 | 155 | 128 | 283 | |||||||||||||||||||||||||||||||||
933074 | 933074 | MA | Suffolk | school | 2502790 | 35 | Boston | 250279002687 | 350012 | Boston Teachers Union School | Regular School | No | 1 | PK | 08 | 2016 | grade_7 | 2 | 10 | 14 | 0 | 1 | 0 | 2 | 16 | 13 | 29 | 2 | 10 | 14 | 0 | 1 | 0 | 2 | 16 | 13 | 29 | |||||||||||||||||||||||||||||||||
933809 | 933809 | MA | Suffolk | school | 2502790 | 35 | Boston | 250279000312 | 350691 | Rafael Hernandez | Regular School | No | 1 | PK | 08 | 2016 | grade_7 | 0 | 1 | 24 | 0 | 0 | 0 | 0 | 12 | 13 | 25 | 0 | 1 | 24 | 0 | 0 | 0 | 0 | 12 | 13 | 25 | |||||||||||||||||||||||||||||||||
938656 | 938656 | MA | Hampden | school | 2511130 | 281 | Springfield | 251113001809 | 2810095 | Alfred G. Zanetti Montessori Magnet School | Regular School | No | 1 | PK | 08 | 2016 | grade_7 | 8 | 8 | 8 | 0 | 1 | 0 | 1 | 13 | 13 | 26 | 8 | 8 | 8 | 0 | 1 | 0 | 1 | 13 | 13 | 26 | |||||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||||
936486 | 936486 | MA | Essex | school | 2507260 | 168 | Marblehead | 250726001789 | 1680300 | Marblehead Veterans Middle School | Regular School | No | 2 | 07 | 08 | 2016 | grade_7 | 216 | 6 | 19 | 0 | 5 | 0 | 9 | 125 | 130 | 255 | 216 | 6 | 19 | 0 | 5 | 0 | 9 | 125 | 130 | 255 | |||||||||||||||||||||||||||||||||
938292 | 938292 | MA | Plymouth | school | 2510560 | 264 | Scituate | 251056001690 | 2640305 | Gates Intermediate School | Regular School | No | 2 | 07 | 08 | 2016 | grade_7 | 243 | 7 | 1 | 0 | 2 | 0 | 3 | 126 | 130 | 256 | 243 | 7 | 1 | 0 | 2 | 0 | 3 | 126 | 130 | 256 | |||||||||||||||||||||||||||||||||
938338 | 938338 | MA | Norfolk | school | 2510620 | 266 | Sharon | 251062002560 | 2660305 | Sharon Middle | Regular School | No | 2 | 06 | 08 | 2016 | grade_7 | 165 | 14 | 12 | 0 | 83 | 1 | 10 | 155 | 130 | 285 | 165 | 14 | 12 | 0 | 83 | 1 | 10 | 155 | 130 | 285 | |||||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||||
936004 | 936004 | MA | Middlesex | school | 2506840 | 155 | Lexington | 250684002551 | 1550305 | Jonas Clarke Middle | Regular School | No | 2 | 06 | 08 | 2016 | grade_7 | 130 | 14 | 10 | 1 | 95 | 0 | 14 | 130 | 134 | 264 | 130 | 14 | 10 | 1 | 95 | 0 | 14 | 130 | 134 | 264 | |||||||||||||||||||||||||||||||||
937111 | 937111 | MA | Bristol | school | 2508430 | 201 | New Bedford | 250843001339 | 2010415 | Roosevelt Middle School | Regular School | No | 2 | 06 | 08 | 2016 | grade_7 | 106 | 30 | 102 | 0 | 0 | 0 | 19 | 122 | 135 | 257 | 106 | 30 | 102 | 0 | 0 | 0 | 19 | 122 | 135 | 257 | |||||||||||||||||||||||||||||||||
939442 | 939442 | MA | Worcester | school | 2512600 | 321 | Westborough | 251260002604 | 3210305 | Sarah W Gibbons Middle | Regular School | No | 2 | 07 | 08 | 2016 | grade_7 | 203 | 4 | 19 | 1 | 78 | 1 | 10 | 181 | 135 | 316 | 203 | 4 | 19 | 1 | 78 | 1 | 10 | 181 | 135 | 316 | |||||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||||
936863 | 936863 | MA | Norfolk | school | 2507980 | 189 | Milton | 250798001257 | 1890410 | Charles S Pierce Middle | Regular School | No | 2 | 06 | 08 | 2016 | grade_7 | 207 | 49 | 13 | 1 | 21 | 1 | 9 | 163 | 138 | 301 | 207 | 49 | 13 | 1 | 21 | 1 | 9 | 163 | 138 | 301 | |||||||||||||||||||||||||||||||||
934286 | 934286 | MA | Norfolk | school | 2503300 | 50 | Canton | 250330000456 | 500305 | Wm H Galvin Middle | Regular School | No | 2 | 06 | 08 | 2016 | grade_7 | 186 | 30 | 9 | 0 | 34 | 0 | 14 | 134 | 139 | 273 | 186 | 30 | 9 | 0 | 34 | 0 | 14 | 134 | 139 | 273 | |||||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||||
940172 | 940172 | MA | Worcester | school | 2513230 | 348 | Worcester | 251323002202 | 3480405 | Burncoat Middle School | Regular School | No | 2 | 07 | 08 | 2016 | grade_7 | 74 | 49 | 120 | 1 | 8 | 0 | 14 | 127 | 139 | 266 | 74 | 49 | 120 | 1 | 8 | 0 | 14 | 127 | 139 | 266 | |||||||||||||||||||||||||||||||||
933532 | 933532 | MA | Suffolk | school | 2502790 | 35 | Boston | 250279000333 | 350346 | Warren-Prescott | Regular School | No | 1 | PK | 08 | 2016 | grade_7 | 11 | 11 | 10 | 1 | 1 | 0 | 0 | 20 | 14 | 34 | 11 | 11 | 10 | 1 | 1 | 0 | 0 | 20 | 14 | 34 | |||||||||||||||||||||||||||||||||
940423 | 940423 | MA | Suffolk | school | 2500029 | 444 | Neighborhood House Charter (District) | 250002900545 | 4440205 | Neighborhood House Charter School | Regular School | Yes | 1 | PK | 08 | 2016 | grade_7 | 5 | 17 | 7 | 0 | 2 | 0 | 0 | 17 | 14 | 31 | 5 | 17 | 7 | 0 | 2 | 0 | 0 | 17 | 14 | 31 | |||||||||||||||||||||||||||||||||
936519 | 936519 | MA | Middlesex | school | 2507320 | 170 | Marlborough | 250732002639 | 1700045 | 1 LT Charles W. Whitcomb School | Regular School | No | 2 | 05 | 08 | 2016 | grade_7 | 153 | 5 | 134 | 0 | 7 | 0 | 7 | 163 | 143 | 306 | 153 | 5 | 134 | 0 | 7 | 0 | 7 | 163 | 143 | 306 | |||||||||||||||||||||||||||||||||
936709 | 936709 | MA | Middlesex | school | 2507620 | 178 | Melrose | 250762002557 | 1780305 | Melrose Middle | Regular School | No | 2 | 06 | 08 | 2016 | grade_7 | 233 | 15 | 5 | 0 | 9 | 0 | 7 | 126 | 143 | 269 | 233 | 15 | 5 | 0 | 9 | 0 | 7 | 126 | 143 | 269 | |||||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||||
937240 | 937240 | MA | Middlesex | school | 2508610 | 207 | Newton | 250861000314 | 2070315 | F A Day Middle | Regular School | No | 2 | 06 | 08 | 2016 | grade_7 | 200 | 20 | 18 | 1 | 32 | 0 | 17 | 144 | 144 | 288 | 200 | 20 | 18 | 1 | 32 | 0 | 17 | 144 | 144 | 288 | |||||||||||||||||||||||||||||||||
939163 | 939163 | MA | Middlesex | school | 2511910 | 305 | Wakefield | 251191000776 | 3050310 | Galvin Middle School | Regular School | No | 2 | 05 | 08 | 2016 | grade_7 | 263 | 10 | 15 | 1 | 3 | 1 | 2 | 150 | 145 | 295 | 263 | 10 | 15 | 1 | 3 | 1 | 2 | 150 | 145 | 295 | |||||||||||||||||||||||||||||||||
939675 | 939675 | MA | Norfolk | school | 2512810 | 335 | Westwood | 251281002097 | 3350305 | E W Thurston Middle | Regular School | No | 2 | 06 | 08 | 2016 | grade_7 | 222 | 9 | 10 | 0 | 19 | 0 | 2 | 116 | 146 | 262 | 222 | 9 | 10 | 0 | 19 | 0 | 2 | 116 | 146 | 262 |
Advanced export
JSON shape: default, array, newline-delimited
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]);