enrollments
Data source: Big Local News · About: Big Local
3,471 rows where grade = "grade_7" and state = "MA"
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
739260 | 739260 | MA | Middlesex | school | 2507020 | 160 | Lowell | 250702001038 | 1600018 | Pyne Arts | Regular School | No | 1 | PK | 08 | 2015 | grade_7 | 34 | 6 | 13 | 0 | 7 | 0 | 0 | 26 | 34 | 60 | 34 | 6 | 13 | 0 | 7 | 0 | 0 | 26 | 34 | 60 | |||||||||||||||||||||||||||||||||
739320 | 739320 | MA | Middlesex | school | 2507020 | 160 | Lowell | 250702002726 | 1600085 | Laura Lee Therapeutic Day School | Regular School | No | 1 | 01 | 07 | 2015 | grade_7 | * | * | * | * | * | * | * | 4 | * | 4 | 4 | 4 | |||||||||||||||||||||||||||||||||||||||||
739329 | 739329 | MA | Middlesex | school | 2507020 | 160 | Lowell | 250702001954 | 1600090 | Bartlett Community Partnership | Regular School | No | 1 | PK | 08 | 2015 | grade_7 | 17 | 1 | 23 | 0 | 13 | 0 | 2 | 31 | 25 | 56 | 17 | 1 | 23 | 0 | 13 | 0 | 2 | 31 | 25 | 56 | |||||||||||||||||||||||||||||||||
739333 | 739333 | MA | Middlesex | school | 2507020 | 160 | Lowell | 250702001026 | 1600310 | B.F.Butler Middle School | Regular School | No | 2 | 05 | 08 | 2015 | grade_7 | 38 | 8 | 42 | 0 | 46 | 1 | 7 | 65 | 77 | 142 | 38 | 8 | 42 | 0 | 46 | 1 | 7 | 65 | 77 | 142 | |||||||||||||||||||||||||||||||||
739337 | 739337 | MA | Middlesex | school | 2507020 | 160 | Lowell | 250702001036 | 1600315 | James S Daley Middle School | Regular School | No | 2 | 05 | 08 | 2015 | grade_7 | 40 | 6 | 25 | 0 | 77 | 0 | 5 | 83 | 70 | 153 | 40 | 6 | 25 | 0 | 77 | 0 | 5 | 83 | 70 | 153 | |||||||||||||||||||||||||||||||||
739346 | 739346 | MA | Middlesex | school | 2507020 | 160 | Lowell | 250702001034 | 1600330 | Henry J Robinson Middle | Regular School | No | 2 | 05 | 08 | 2015 | grade_7 | 52 | 18 | 65 | 0 | 23 | 0 | 5 | 85 | 78 | 163 | 52 | 18 | 65 | 0 | 23 | 0 | 5 | 85 | 78 | 163 | |||||||||||||||||||||||||||||||||
739350 | 739350 | MA | Middlesex | school | 2507020 | 160 | Lowell | 250702000073 | 1600340 | James Sullivan Middle School | Regular School | No | 2 | 05 | 08 | 2015 | grade_7 | 61 | 8 | 64 | 0 | 19 | 0 | 5 | 75 | 82 | 157 | 61 | 8 | 64 | 0 | 19 | 0 | 5 | 75 | 82 | 157 | |||||||||||||||||||||||||||||||||
739354 | 739354 | MA | Middlesex | school | 2507020 | 160 | Lowell | 250702000086 | 1600345 | Dr An Wang School | Regular School | No | 2 | 05 | 08 | 2015 | grade_7 | 66 | 11 | 66 | 0 | 27 | 0 | 5 | 94 | 81 | 175 | 66 | 11 | 66 | 0 | 27 | 0 | 5 | 94 | 81 | 175 | |||||||||||||||||||||||||||||||||
739358 | 739358 | MA | Middlesex | school | 2507020 | 160 | Lowell | 250702001955 | 1600360 | Kathryn P. Stoklosa Middle School | Regular School | No | 2 | 05 | 08 | 2015 | grade_7 | 17 | 14 | 52 | 0 | 72 | 0 | 5 | 90 | 70 | 160 | 17 | 14 | 52 | 0 | 72 | 0 | 5 | 90 | 70 | 160 | |||||||||||||||||||||||||||||||||
739373 | 739373 | MA | Hampden | school | 2507050 | 161 | Ludlow | 250705001055 | 1610305 | Paul R Baird Middle | Regular School | No | 2 | 06 | 08 | 2015 | grade_7 | 169 | 3 | 17 | 0 | 2 | 0 | 7 | 97 | 101 | 198 | 169 | 3 | 17 | 0 | 2 | 0 | 7 | 97 | 101 | 198 | |||||||||||||||||||||||||||||||||
739388 | 739388 | MA | Worcester | school | 2507080 | 162 | Lunenburg | 250708001060 | 1620020 | Turkey Hill Middle | Regular School | No | 2 | 04 | 07 | 2015 | grade_7 | 106 | 4 | 2 | 0 | 2 | 0 | 0 | 63 | 51 | 114 | 106 | 4 | 2 | 0 | 2 | 0 | 0 | 63 | 51 | 114 | |||||||||||||||||||||||||||||||||
739509 | 739509 | MA | Essex | school | 2507110 | 163 | Lynn | 250711000301 | 1630305 | Thurgood Marshall Mid | Regular School | No | 2 | 06 | 08 | 2015 | grade_7 | 37 | 38 | 208 | 0 | 27 | 0 | 17 | 181 | 146 | 327 | 37 | 38 | 208 | 0 | 27 | 0 | 17 | 181 | 146 | 327 | |||||||||||||||||||||||||||||||||
739512 | 739512 | MA | Essex | school | 2507110 | 163 | Lynn | 250711001063 | 1630405 | Breed Middle School | Regular School | No | 2 | 06 | 08 | 2015 | grade_7 | 78 | 38 | 233 | 0 | 49 | 0 | 9 | 214 | 193 | 407 | 78 | 38 | 233 | 0 | 49 | 0 | 9 | 214 | 193 | 407 | |||||||||||||||||||||||||||||||||
739515 | 739515 | MA | Essex | school | 2507110 | 163 | Lynn | 250711001083 | 1630420 | Pickering Middle | Regular School | No | 2 | 06 | 08 | 2015 | grade_7 | 93 | 16 | 71 | 1 | 28 | 0 | 6 | 104 | 111 | 215 | 93 | 16 | 71 | 1 | 28 | 0 | 6 | 104 | 111 | 215 | |||||||||||||||||||||||||||||||||
739527 | 739527 | MA | Essex | school | 2507110 | 163 | Lynn | 250711002647 | 1630525 | Fecteau-Leary Junior/Senior High School | Regular School | No | 3 | 07 | 12 | 2015 | grade_7 | 1 | 0 | 4 | 0 | 1 | 0 | 1 | 2 | 5 | 7 | 1 | 0 | 4 | 0 | 1 | 0 | 1 | 2 | 5 | 7 | |||||||||||||||||||||||||||||||||
739534 | 739534 | MA | Essex | school | 2507110 | 163 | Lynn | 250711002277 | 1630605 | Lynn Vocational Technical Institute | Vocational Education School | No | 3 | 07 | 12 | 2015 | grade_7 | * | * | * | * | * | * | * | 1 | 3 | 4 | 1 | 3 | 4 | ||||||||||||||||||||||||||||||||||||||||
739554 | 739554 | MA | Essex | school | 2507140 | 164 | Lynnfield | 250714001091 | 1640405 | Lynnfield Middle School | Regular School | No | 2 | 05 | 08 | 2015 | grade_7 | 150 | 7 | 1 | 0 | 4 | 0 | 5 | 86 | 81 | 167 | 150 | 7 | 1 | 0 | 4 | 0 | 5 | 86 | 81 | 167 | |||||||||||||||||||||||||||||||||
739567 | 739567 | MA | Middlesex | school | 2507170 | 165 | Malden | 250717001344 | 1650003 | Beebe | Regular School | No | 1 | KG | 08 | 2015 | grade_7 | 30 | 21 | 12 | 1 | 22 | 0 | 1 | 42 | 45 | 87 | 30 | 21 | 12 | 1 | 22 | 0 | 1 | 42 | 45 | 87 | |||||||||||||||||||||||||||||||||
739576 | 739576 | MA | Middlesex | school | 2507170 | 165 | Malden | 250717001345 | 1650013 | Ferryway | Regular School | No | 1 | KG | 08 | 2015 | grade_7 | 28 | 16 | 28 | 0 | 22 | 0 | 6 | 54 | 46 | 100 | 28 | 16 | 28 | 0 | 22 | 0 | 6 | 54 | 46 | 100 | |||||||||||||||||||||||||||||||||
739585 | 739585 | MA | Middlesex | school | 2507170 | 165 | Malden | 250717001351 | 1650027 | Forestdale | Regular School | No | 1 | KG | 08 | 2015 | grade_7 | 27 | 11 | 11 | 0 | 7 | 0 | 2 | 32 | 26 | 58 | 27 | 11 | 11 | 0 | 7 | 0 | 2 | 32 | 26 | 58 | |||||||||||||||||||||||||||||||||
739594 | 739594 | MA | Middlesex | school | 2507170 | 165 | Malden | 250717001361 | 1650047 | Linden | Regular School | No | 1 | KG | 08 | 2015 | grade_7 | 29 | 14 | 21 | 0 | 22 | 0 | 4 | 45 | 45 | 90 | 29 | 14 | 21 | 0 | 22 | 0 | 4 | 45 | 45 | 90 | |||||||||||||||||||||||||||||||||
739604 | 739604 | MA | Middlesex | school | 2507170 | 165 | Malden | 250717001363 | 1650057 | Salemwood | Regular School | No | 1 | KG | 08 | 2015 | grade_7 | 31 | 31 | 30 | 0 | 24 | 0 | 3 | 65 | 54 | 119 | 31 | 31 | 30 | 0 | 24 | 0 | 3 | 65 | 54 | 119 | |||||||||||||||||||||||||||||||||
739618 | 739618 | MA | Bristol | school | 2507230 | 167 | Mansfield | 250723001112 | 1670035 | Harold L Qualters Middle | Regular School | No | 2 | 06 | 08 | 2015 | grade_7 | 305 | 8 | 12 | 0 | 16 | 0 | 10 | 188 | 163 | 351 | 305 | 8 | 12 | 0 | 16 | 0 | 10 | 188 | 163 | 351 | |||||||||||||||||||||||||||||||||
739642 | 739642 | MA | Essex | school | 2507260 | 168 | Marblehead | 250726001789 | 1680300 | Marblehead Veterans Middle School | Regular School | No | 2 | 07 | 08 | 2015 | grade_7 | 210 | 8 | 15 | 0 | 4 | 0 | 9 | 124 | 122 | 246 | 210 | 8 | 15 | 0 | 4 | 0 | 9 | 124 | 122 | 246 | |||||||||||||||||||||||||||||||||
739675 | 739675 | MA | Middlesex | school | 2507320 | 170 | Marlborough | 250732002639 | 1700045 | 1 LT Charles W. Whitcomb School | Regular School | No | 2 | 05 | 08 | 2015 | grade_7 | 177 | 6 | 115 | 1 | 10 | 0 | 8 | 158 | 159 | 317 | 177 | 6 | 115 | 1 | 10 | 0 | 8 | 158 | 159 | 317 | |||||||||||||||||||||||||||||||||
739715 | 739715 | MA | Plymouth | school | 2507350 | 171 | Marshfield | 250735001143 | 1710310 | Furnace Brook Middle | Regular School | No | 2 | 06 | 08 | 2015 | grade_7 | 331 | 3 | 6 | 2 | 4 | 0 | 2 | 177 | 171 | 348 | 331 | 3 | 6 | 2 | 4 | 0 | 2 | 177 | 171 | 348 | |||||||||||||||||||||||||||||||||
739725 | 739725 | MA | Barnstable | school | 2507440 | 172 | Mashpee | 250744002638 | 1720020 | Mashpee Middle School | Regular School | No | 2 | 07 | 08 | 2015 | grade_7 | 101 | 6 | 4 | 5 | 5 | 0 | 6 | 66 | 61 | 127 | 101 | 6 | 4 | 5 | 5 | 0 | 6 | 66 | 61 | 127 | |||||||||||||||||||||||||||||||||
739751 | 739751 | MA | Middlesex | school | 2507500 | 174 | Maynard | 250750000105 | 1740305 | Fowler School | Regular School | No | 2 | 04 | 07 | 2015 | grade_7 | 95 | 3 | 11 | 0 | 5 | 0 | 2 | 60 | 56 | 116 | 95 | 3 | 11 | 0 | 5 | 0 | 2 | 60 | 56 | 116 | |||||||||||||||||||||||||||||||||
739765 | 739765 | MA | Norfolk | school | 2507530 | 175 | Medfield | 250753001156 | 1750305 | Thomas Blake Middle | Regular School | No | 2 | 06 | 08 | 2015 | grade_7 | 191 | 2 | 5 | 1 | 11 | 0 | 6 | 111 | 105 | 216 | 191 | 2 | 5 | 1 | 11 | 0 | 6 | 111 | 105 | 216 | |||||||||||||||||||||||||||||||||
739800 | 739800 | MA | Middlesex | school | 2507560 | 176 | Medford | 250756001638 | 1760315 | Madeleine Dugger Andrews | Regular School | No | 2 | 06 | 08 | 2015 | grade_7 | 101 | 19 | 10 | 0 | 9 | 0 | 6 | 68 | 77 | 145 | 101 | 19 | 10 | 0 | 9 | 0 | 6 | 68 | 77 | 145 | |||||||||||||||||||||||||||||||||
739803 | 739803 | MA | Middlesex | school | 2507560 | 176 | Medford | 250756002063 | 1760320 | John J. McGlynn Middle School | Regular School | No | 2 | 06 | 08 | 2015 | grade_7 | 80 | 29 | 13 | 0 | 18 | 0 | 3 | 81 | 62 | 143 | 80 | 29 | 13 | 0 | 18 | 0 | 3 | 81 | 62 | 143 | |||||||||||||||||||||||||||||||||
739826 | 739826 | MA | Norfolk | school | 2507590 | 177 | Medway | 250759002483 | 1770305 | Medway Middle | Regular School | No | 2 | 05 | 08 | 2015 | grade_7 | 197 | 2 | 6 | 2 | 3 | 0 | 6 | 121 | 95 | 216 | 197 | 2 | 6 | 2 | 3 | 0 | 6 | 121 | 95 | 216 | |||||||||||||||||||||||||||||||||
739864 | 739864 | MA | Middlesex | school | 2507620 | 178 | Melrose | 250762002557 | 1780305 | Melrose Middle | Regular School | No | 2 | 06 | 08 | 2015 | grade_7 | 236 | 13 | 10 | 0 | 20 | 0 | 14 | 137 | 156 | 293 | 236 | 13 | 10 | 0 | 20 | 0 | 14 | 137 | 156 | 293 | |||||||||||||||||||||||||||||||||
739878 | 739878 | MA | Essex | school | 2507740 | 181 | Methuen | 250774001211 | 1810030 | Marsh Grammar School | Regular School | No | 1 | PK | 08 | 2015 | grade_7 | 103 | 2 | 19 | 0 | 5 | 1 | 3 | 69 | 64 | 133 | 103 | 2 | 19 | 0 | 5 | 1 | 3 | 69 | 64 | 133 | |||||||||||||||||||||||||||||||||
739888 | 739888 | MA | Essex | school | 2507740 | 181 | Methuen | 250774002558 | 1810050 | Comprehensive Grammar School | Regular School | No | 1 | PK | 08 | 2015 | grade_7 | 88 | 4 | 33 | 0 | 3 | 0 | 1 | 60 | 69 | 129 | 88 | 4 | 33 | 0 | 3 | 0 | 1 | 60 | 69 | 129 | |||||||||||||||||||||||||||||||||
739898 | 739898 | MA | Essex | school | 2507740 | 181 | Methuen | 250774001556 | 1810055 | Tenney Grammar School | Regular School | No | 1 | PK | 08 | 2015 | grade_7 | 76 | 7 | 67 | 0 | 4 | 0 | 2 | 81 | 75 | 156 | 76 | 7 | 67 | 0 | 4 | 0 | 2 | 81 | 75 | 156 | |||||||||||||||||||||||||||||||||
739908 | 739908 | MA | Essex | school | 2507740 | 181 | Methuen | 250774001376 | 1810060 | Donald P Timony Grammar | Regular School | No | 1 | PK | 08 | 2015 | grade_7 | 67 | 6 | 60 | 0 | 4 | 0 | 2 | 70 | 69 | 139 | 67 | 6 | 60 | 0 | 4 | 0 | 2 | 70 | 69 | 139 | |||||||||||||||||||||||||||||||||
739928 | 739928 | MA | Plymouth | school | 2507770 | 182 | Middleborough | 250777001378 | 1820305 | John T. Nichols Middle | Regular School | No | 2 | 06 | 08 | 2015 | grade_7 | 230 | 3 | 9 | 6 | 0 | 0 | 8 | 128 | 128 | 256 | 230 | 3 | 9 | 6 | 0 | 0 | 8 | 128 | 128 | 256 | |||||||||||||||||||||||||||||||||
739954 | 739954 | MA | Worcester | school | 2507860 | 185 | Milford | 250786001240 | 1850305 | Stacy Middle | Regular School | No | 2 | 05 | 07 | 2015 | grade_7 | 229 | 9 | 58 | 6 | 7 | 0 | 7 | 157 | 159 | 316 | 229 | 9 | 58 | 6 | 7 | 0 | 7 | 157 | 159 | 316 | |||||||||||||||||||||||||||||||||
739969 | 739969 | MA | Worcester | school | 2507890 | 186 | Millbury | 250789001249 | 1860505 | Millbury Junior/Senior High | Regular School | No | 3 | 07 | 12 | 2015 | grade_7 | 129 | 0 | 11 | 0 | 0 | 0 | 2 | 64 | 78 | 142 | 129 | 0 | 11 | 0 | 0 | 0 | 2 | 64 | 78 | 142 | |||||||||||||||||||||||||||||||||
739984 | 739984 | MA | Norfolk | school | 2507920 | 187 | Millis | 250792001254 | 1870020 | Millis Middle | Regular School | No | 2 | 05 | 08 | 2015 | grade_7 | 106 | 2 | 7 | 0 | 2 | 0 | 1 | 60 | 58 | 118 | 106 | 2 | 7 | 0 | 2 | 0 | 1 | 60 | 58 | 118 | |||||||||||||||||||||||||||||||||
740016 | 740016 | MA | Norfolk | school | 2507980 | 189 | Milton | 250798001257 | 1890410 | Charles S Pierce Middle | Regular School | No | 2 | 06 | 08 | 2015 | grade_7 | 192 | 47 | 22 | 1 | 17 | 1 | 9 | 153 | 136 | 289 | 192 | 47 | 22 | 1 | 17 | 1 | 9 | 153 | 136 | 289 | |||||||||||||||||||||||||||||||||
740032 | 740032 | MA | Hampden | school | 2508040 | 191 | Monson | 250804001655 | 1910310 | Granite Valley Middle | Regular School | No | 2 | 05 | 08 | 2015 | grade_7 | 88 | 0 | 2 | 0 | 0 | 1 | 2 | 43 | 50 | 93 | 88 | 0 | 2 | 0 | 0 | 1 | 2 | 43 | 50 | 93 | |||||||||||||||||||||||||||||||||
740055 | 740055 | MA | Nantucket | school | 2508250 | 197 | Nantucket | 250825001281 | 1970010 | Cyrus Peirce | Regular School | No | 2 | 06 | 08 | 2015 | grade_7 | 83 | 14 | 27 | 0 | 3 | 1 | 4 | 65 | 67 | 132 | 83 | 14 | 27 | 0 | 3 | 1 | 4 | 65 | 67 | 132 | |||||||||||||||||||||||||||||||||
740089 | 740089 | MA | Middlesex | school | 2508340 | 198 | Natick | 250834001297 | 1980305 | J F Kennedy Middle School | Regular School | No | 2 | 05 | 08 | 2015 | grade_7 | 166 | 3 | 6 | 0 | 11 | 0 | 1 | 95 | 92 | 187 | 166 | 3 | 6 | 0 | 11 | 0 | 1 | 95 | 92 | 187 | |||||||||||||||||||||||||||||||||
740093 | 740093 | MA | Middlesex | school | 2508340 | 198 | Natick | 250834001305 | 1980310 | Wilson Middle | Regular School | No | 2 | 05 | 08 | 2015 | grade_7 | 200 | 10 | 8 | 0 | 13 | 1 | 10 | 121 | 121 | 242 | 200 | 10 | 8 | 0 | 13 | 1 | 10 | 121 | 121 | 242 | |||||||||||||||||||||||||||||||||
740131 | 740131 | MA | Norfolk | school | 2508370 | 199 | Needham | 250837001308 | 1990405 | Pollard Middle | Regular School | No | 2 | 07 | 08 | 2015 | grade_7 | 324 | 13 | 19 | 0 | 33 | 0 | 14 | 201 | 202 | 403 | 324 | 13 | 19 | 0 | 33 | 0 | 14 | 201 | 202 | 403 | |||||||||||||||||||||||||||||||||
740267 | 740267 | MA | Bristol | school | 2508430 | 201 | New Bedford | 250843001334 | 2010405 | Keith Middle School | Regular School | No | 2 | 06 | 08 | 2015 | grade_7 | 117 | 56 | 95 | 3 | 2 | 2 | 17 | 158 | 134 | 292 | 117 | 56 | 95 | 3 | 2 | 2 | 17 | 158 | 134 | 292 | |||||||||||||||||||||||||||||||||
740270 | 740270 | MA | Bristol | school | 2508430 | 201 | New Bedford | 250843001337 | 2010410 | Normandin Middle School | Regular School | No | 2 | 06 | 08 | 2015 | grade_7 | 212 | 29 | 97 | 1 | 1 | 2 | 16 | 183 | 175 | 358 | 212 | 29 | 97 | 1 | 1 | 2 | 16 | 183 | 175 | 358 | |||||||||||||||||||||||||||||||||
740273 | 740273 | MA | Bristol | school | 2508430 | 201 | New Bedford | 250843001339 | 2010415 | Roosevelt Middle School | Regular School | No | 2 | 06 | 08 | 2015 | grade_7 | 123 | 31 | 93 | 1 | 2 | 2 | 10 | 136 | 126 | 262 | 123 | 31 | 93 | 1 | 2 | 2 | 10 | 136 | 126 | 262 | |||||||||||||||||||||||||||||||||
740286 | 740286 | MA | Bristol | school | 2508430 | 201 | New Bedford | 250843002681 | 2010515 | Whaling City Junior/Senior High School | Regular School | No | 4 | 06 | 12 | 2015 | grade_7 | * | * | * | * | * | * | * | 3 | 2 | 5 | 3 | 2 | 5 | ||||||||||||||||||||||||||||||||||||||||
740299 | 740299 | MA | Essex | school | 2508580 | 204 | Newburyport | 250858001355 | 2040305 | Rupert A Nock Middle | Regular School | No | 2 | 06 | 08 | 2015 | grade_7 | 156 | 1 | 6 | 0 | 5 | 0 | 4 | 70 | 102 | 172 | 156 | 1 | 6 | 0 | 5 | 0 | 4 | 70 | 102 | 172 | |||||||||||||||||||||||||||||||||
740398 | 740398 | MA | Middlesex | school | 2508610 | 207 | Newton | 250861000307 | 2070305 | Bigelow Middle | Regular School | No | 2 | 06 | 08 | 2015 | grade_7 | 108 | 18 | 12 | 0 | 22 | 0 | 8 | 75 | 93 | 168 | 108 | 18 | 12 | 0 | 22 | 0 | 8 | 75 | 93 | 168 | |||||||||||||||||||||||||||||||||
740401 | 740401 | MA | Middlesex | school | 2508610 | 207 | Newton | 250861000310 | 2070310 | Charles E Brown Middle | Regular School | No | 2 | 06 | 08 | 2015 | grade_7 | 152 | 13 | 16 | 1 | 51 | 0 | 9 | 123 | 119 | 242 | 152 | 13 | 16 | 1 | 51 | 0 | 9 | 123 | 119 | 242 | |||||||||||||||||||||||||||||||||
740404 | 740404 | MA | Middlesex | school | 2508610 | 207 | Newton | 250861000314 | 2070315 | F A Day Middle | Regular School | No | 2 | 06 | 08 | 2015 | grade_7 | 220 | 20 | 32 | 0 | 49 | 0 | 22 | 175 | 168 | 343 | 220 | 20 | 32 | 0 | 49 | 0 | 22 | 175 | 168 | 343 | |||||||||||||||||||||||||||||||||
740407 | 740407 | MA | Middlesex | school | 2508610 | 207 | Newton | 250861001042 | 2070320 | Oak Hill Middle | Regular School | No | 2 | 06 | 08 | 2015 | grade_7 | 137 | 20 | 11 | 0 | 27 | 0 | 13 | 120 | 88 | 208 | 137 | 20 | 11 | 0 | 27 | 0 | 13 | 120 | 88 | 208 | |||||||||||||||||||||||||||||||||
740434 | 740434 | MA | Berkshire | school | 2508670 | 209 | North Adams | 250867001388 | 2090008 | J S Sullivan | Regular School | No | 1 | KG | 07 | 2015 | grade_7 | 23 | 3 | 2 | 0 | 0 | 0 | 1 | 16 | 13 | 29 | 23 | 3 | 2 | 0 | 0 | 0 | 1 | 16 | 13 | 29 | |||||||||||||||||||||||||||||||||
740442 | 740442 | MA | Berkshire | school | 2508670 | 209 | North Adams | 250867001389 | 2090015 | Greylock | Regular School | No | 1 | KG | 07 | 2015 | grade_7 | 21 | 0 | 0 | 0 | 0 | 0 | 1 | 14 | 8 | 22 | 21 | 0 | 0 | 0 | 0 | 0 | 1 | 14 | 8 | 22 | |||||||||||||||||||||||||||||||||
740451 | 740451 | MA | Berkshire | school | 2508670 | 209 | North Adams | 250867001390 | 2090035 | Brayton | Regular School | No | 1 | PK | 07 | 2015 | grade_7 | 38 | 1 | 1 | 0 | 0 | 0 | 2 | 24 | 18 | 42 | 38 | 1 | 1 | 0 | 0 | 0 | 2 | 24 | 18 | 42 | |||||||||||||||||||||||||||||||||
740483 | 740483 | MA | Hampshire | school | 2508850 | 210 | Northampton | 250885001430 | 2100410 | John F Kennedy Middle School | Regular School | No | 2 | 06 | 08 | 2015 | grade_7 | 132 | 4 | 41 | 2 | 4 | 0 | 9 | 95 | 97 | 192 | 132 | 4 | 41 | 2 | 4 | 0 | 9 | 95 | 97 | 192 | |||||||||||||||||||||||||||||||||
740522 | 740522 | MA | Essex | school | 2508700 | 211 | North Andover | 250870001398 | 2110305 | North Andover Middle | Regular School | No | 2 | 06 | 08 | 2015 | grade_7 | 281 | 13 | 32 | 0 | 30 | 3 | 4 | 173 | 190 | 363 | 281 | 13 | 32 | 0 | 30 | 3 | 4 | 173 | 190 | 363 | |||||||||||||||||||||||||||||||||
740565 | 740565 | MA | Bristol | school | 2508730 | 212 | North Attleborough | 250873001207 | 2120305 | North Attleborough Middle | Regular School | No | 2 | 06 | 08 | 2015 | grade_7 | 342 | 7 | 11 | 1 | 24 | 1 | 10 | 193 | 203 | 396 | 342 | 7 | 11 | 1 | 24 | 1 | 10 | 193 | 203 | 396 | |||||||||||||||||||||||||||||||||
740598 | 740598 | MA | Worcester | school | 2508880 | 213 | Northborough | 250888001440 | 2130305 | Robert E. Melican Middle School | Regular School | No | 2 | 06 | 08 | 2015 | grade_7 | 170 | 2 | 7 | 1 | 22 | 2 | 4 | 119 | 89 | 208 | 170 | 2 | 7 | 1 | 22 | 2 | 4 | 119 | 89 | 208 | |||||||||||||||||||||||||||||||||
740608 | 740608 | MA | Worcester | school | 2508940 | 214 | Northbridge | 250894002591 | 2140305 | Northbridge Middle | Regular School | No | 2 | 05 | 08 | 2015 | grade_7 | 159 | 0 | 11 | 0 | 2 | 0 | 7 | 93 | 86 | 179 | 159 | 0 | 11 | 0 | 2 | 0 | 7 | 93 | 86 | 179 | |||||||||||||||||||||||||||||||||
740623 | 740623 | MA | Worcester | school | 2508760 | 215 | North Brookfield | 250876001411 | 2150505 | North Brookfield High | Regular School | No | 3 | 07 | 12 | 2015 | grade_7 | 47 | 0 | 2 | 0 | 1 | 0 | 1 | 28 | 23 | 51 | 47 | 0 | 2 | 0 | 1 | 0 | 1 | 28 | 23 | 51 | |||||||||||||||||||||||||||||||||
740649 | 740649 | MA | Middlesex | school | 2508820 | 217 | North Reading | 250882002592 | 2170305 | North Reading Middle | Regular School | No | 2 | 06 | 08 | 2015 | grade_7 | 210 | 1 | 5 | 0 | 5 | 0 | 1 | 113 | 109 | 222 | 210 | 1 | 5 | 0 | 5 | 0 | 1 | 113 | 109 | 222 | |||||||||||||||||||||||||||||||||
740667 | 740667 | MA | Bristol | school | 2509000 | 218 | Norton | 250900001452 | 2180305 | Norton Middle | Regular School | No | 2 | 06 | 08 | 2015 | grade_7 | 193 | 2 | 4 | 0 | 3 | 1 | 2 | 100 | 105 | 205 | 193 | 2 | 4 | 0 | 3 | 1 | 2 | 100 | 105 | 205 | |||||||||||||||||||||||||||||||||
740688 | 740688 | MA | Plymouth | school | 2509030 | 219 | Norwell | 250903001456 | 2190405 | Norwell Middle School | Regular School | No | 2 | 06 | 08 | 2015 | grade_7 | 194 | 3 | 0 | 0 | 6 | 1 | 2 | 100 | 106 | 206 | 194 | 3 | 0 | 0 | 6 | 1 | 2 | 100 | 106 | 206 | |||||||||||||||||||||||||||||||||
740722 | 740722 | MA | Norfolk | school | 2509060 | 220 | Norwood | 250906001468 | 2200305 | Dr. Philip O. Coakley Middle School | Regular School | No | 2 | 06 | 08 | 2015 | grade_7 | 163 | 48 | 23 | 0 | 12 | 0 | 3 | 131 | 118 | 249 | 163 | 48 | 23 | 0 | 12 | 0 | 3 | 131 | 118 | 249 | |||||||||||||||||||||||||||||||||
740737 | 740737 | MA | Dukes | school | 2504650 | 221 | Oak Bluffs | 250465000625 | 2210005 | Oak Bluffs Elementary | Regular School | No | 1 | PK | 08 | 2015 | grade_7 | 28 | 1 | 3 | 0 | 1 | 0 | 6 | 15 | 24 | 39 | 28 | 1 | 3 | 0 | 1 | 0 | 6 | 15 | 24 | 39 | |||||||||||||||||||||||||||||||||
740759 | 740759 | MA | Worcester | school | 2509270 | 226 | Oxford | 250927002810 | 2260305 | Project C.O.F.F.E.E. | Special Education School | No | 4 | 05 | 12 | 2015 | grade_7 | * | * | * | * | * | * | * | 1 | 1 | 2 | 1 | 1 | 2 | ||||||||||||||||||||||||||||||||||||||||
740765 | 740765 | MA | Worcester | school | 2509270 | 226 | Oxford | 250927001483 | 2260405 | Oxford Middle | Regular School | No | 2 | 05 | 08 | 2015 | grade_7 | 123 | 0 | 17 | 0 | 1 | 0 | 3 | 67 | 77 | 144 | 123 | 0 | 17 | 0 | 1 | 0 | 3 | 67 | 77 | 144 | |||||||||||||||||||||||||||||||||
740780 | 740780 | MA | Hampden | school | 2509300 | 227 | Palmer | 250930002595 | 2270305 | Converse Middle | Regular School | No | 2 | 05 | 07 | 2015 | grade_7 | 107 | 4 | 5 | 0 | 2 | 0 | 0 | 73 | 45 | 118 | 107 | 4 | 5 | 0 | 2 | 0 | 0 | 73 | 45 | 118 | |||||||||||||||||||||||||||||||||
740841 | 740841 | MA | Essex | school | 2509360 | 229 | Peabody | 250936001495 | 2290305 | J Henry Higgins Middle | Regular School | No | 2 | 06 | 08 | 2015 | grade_7 | 326 | 11 | 55 | 0 | 7 | 0 | 10 | 210 | 199 | 409 | 326 | 11 | 55 | 0 | 7 | 0 | 10 | 210 | 199 | 409 | |||||||||||||||||||||||||||||||||
740876 | 740876 | MA | Plymouth | school | 2509420 | 231 | Pembroke | 250942001823 | 2310305 | Pembroke Community Middle School | Regular School | No | 2 | 07 | 08 | 2015 | grade_7 | 240 | 2 | 0 | 1 | 4 | 1 | 2 | 129 | 121 | 250 | 240 | 2 | 0 | 1 | 4 | 1 | 2 | 129 | 121 | 250 | |||||||||||||||||||||||||||||||||
740943 | 740943 | MA | Berkshire | school | 2509630 | 236 | Pittsfield | 250963001525 | 2360305 | John T Reid Middle | Regular School | No | 2 | 06 | 08 | 2015 | grade_7 | 117 | 20 | 17 | 0 | 2 | 0 | 11 | 93 | 74 | 167 | 117 | 20 | 17 | 0 | 2 | 0 | 11 | 93 | 74 | 167 | |||||||||||||||||||||||||||||||||
740946 | 740946 | MA | Berkshire | school | 2509630 | 236 | Pittsfield | 250963001532 | 2360310 | Theodore Herberg Middle | Regular School | No | 2 | 06 | 08 | 2015 | grade_7 | 160 | 30 | 16 | 0 | 6 | 0 | 5 | 103 | 114 | 217 | 160 | 30 | 16 | 0 | 6 | 0 | 5 | 103 | 114 | 217 | |||||||||||||||||||||||||||||||||
741015 | 741015 | MA | Plymouth | school | 2509720 | 239 | Plymouth | 250972001380 | 2390305 | Plymouth South Middle | Regular School | No | 2 | 05 | 08 | 2015 | grade_7 | 217 | 2 | 4 | 0 | 2 | 0 | 7 | 119 | 113 | 232 | 217 | 2 | 4 | 0 | 2 | 0 | 7 | 119 | 113 | 232 | |||||||||||||||||||||||||||||||||
741018 | 741018 | MA | Plymouth | school | 2509720 | 239 | Plymouth | 250972002531 | 2390405 | Plymouth Commun Intermediate | Regular School | No | 2 | 06 | 08 | 2015 | grade_7 | 306 | 8 | 11 | 0 | 4 | 0 | 15 | 159 | 185 | 344 | 306 | 8 | 11 | 0 | 4 | 0 | 15 | 159 | 185 | 344 | |||||||||||||||||||||||||||||||||
741043 | 741043 | MA | Barnstable | school | 2509840 | 242 | Provincetown | 250984002694 | 2420020 | Provincetown Schools | Regular School | No | 1 | PK | 08 | 2015 | grade_7 | 2 | 4 | 1 | 0 | 0 | 0 | 1 | 3 | 5 | 8 | 2 | 4 | 1 | 0 | 0 | 0 | 1 | 3 | 5 | 8 | |||||||||||||||||||||||||||||||||
741112 | 741112 | MA | Norfolk | school | 2509870 | 243 | Quincy | 250987001561 | 2430305 | Atlantic Middle | Regular School | No | 2 | 06 | 08 | 2015 | grade_7 | 49 | 1 | 2 | 0 | 87 | 0 | 1 | 73 | 67 | 140 | 49 | 1 | 2 | 0 | 87 | 0 | 1 | 73 | 67 | 140 | |||||||||||||||||||||||||||||||||
741115 | 741115 | MA | Norfolk | school | 2509870 | 243 | Quincy | 250987001563 | 2430310 | Broad Meadows Middle | Regular School | No | 2 | 06 | 08 | 2015 | grade_7 | 66 | 9 | 4 | 0 | 21 | 0 | 4 | 53 | 51 | 104 | 66 | 9 | 4 | 0 | 21 | 0 | 4 | 53 | 51 | 104 | |||||||||||||||||||||||||||||||||
741118 | 741118 | MA | Norfolk | school | 2509870 | 243 | Quincy | 250987001564 | 2430315 | Central Middle | Regular School | No | 2 | 06 | 08 | 2015 | grade_7 | 129 | 9 | 3 | 0 | 72 | 0 | 3 | 97 | 119 | 216 | 129 | 9 | 3 | 0 | 72 | 0 | 3 | 97 | 119 | 216 | |||||||||||||||||||||||||||||||||
741122 | 741122 | MA | Norfolk | school | 2509870 | 243 | Quincy | 250987001581 | 2430320 | Reay E Sterling Middle | Regular School | No | 2 | 05 | 08 | 2015 | grade_7 | 37 | 19 | 9 | 0 | 17 | 0 | 4 | 46 | 40 | 86 | 37 | 19 | 9 | 0 | 17 | 0 | 4 | 46 | 40 | 86 | |||||||||||||||||||||||||||||||||
741126 | 741126 | MA | Norfolk | school | 2509870 | 243 | Quincy | 250987001381 | 2430325 | Point Webster Middle | Regular School | No | 2 | 05 | 08 | 2015 | grade_7 | 34 | 5 | 4 | 0 | 27 | 0 | 7 | 44 | 33 | 77 | 34 | 5 | 4 | 0 | 27 | 0 | 7 | 44 | 33 | 77 | |||||||||||||||||||||||||||||||||
741163 | 741163 | MA | Norfolk | school | 2509930 | 244 | Randolph | 250993001392 | 2440410 | Randolph Community Middle | Regular School | No | 2 | 06 | 08 | 2015 | grade_7 | 24 | 139 | 31 | 0 | 33 | 2 | 4 | 114 | 119 | 233 | 24 | 139 | 31 | 0 | 33 | 2 | 4 | 114 | 119 | 233 | |||||||||||||||||||||||||||||||||
741202 | 741202 | MA | Middlesex | school | 2509990 | 246 | Reading | 250999001605 | 2460305 | Arthur W Coolidge Middle | Regular School | No | 2 | 06 | 08 | 2015 | grade_7 | 140 | 5 | 1 | 0 | 7 | 0 | 4 | 88 | 69 | 157 | 140 | 5 | 1 | 0 | 7 | 0 | 4 | 88 | 69 | 157 | |||||||||||||||||||||||||||||||||
741205 | 741205 | MA | Middlesex | school | 2509990 | 246 | Reading | 250999001612 | 2460310 | Walter S Parker Middle | Regular School | No | 2 | 06 | 08 | 2015 | grade_7 | 169 | 3 | 4 | 1 | 11 | 0 | 1 | 86 | 103 | 189 | 169 | 3 | 4 | 1 | 11 | 0 | 1 | 86 | 103 | 189 | |||||||||||||||||||||||||||||||||
741225 | 741225 | MA | Suffolk | school | 2510050 | 248 | Revere | 251005001963 | 2480014 | Rumney Marsh Academy | Regular School | No | 2 | 06 | 08 | 2015 | grade_7 | 89 | 9 | 75 | 2 | 4 | 0 | 6 | 91 | 94 | 185 | 89 | 9 | 75 | 2 | 4 | 0 | 6 | 91 | 94 | 185 | |||||||||||||||||||||||||||||||||
741254 | 741254 | MA | Suffolk | school | 2510050 | 248 | Revere | 251005001976 | 2480057 | Garfield Middle School | Regular School | No | 2 | 06 | 08 | 2015 | grade_7 | 54 | 4 | 87 | 0 | 10 | 0 | 6 | 76 | 85 | 161 | 54 | 4 | 87 | 0 | 10 | 0 | 6 | 76 | 85 | 161 | |||||||||||||||||||||||||||||||||
741257 | 741257 | MA | Suffolk | school | 2510050 | 248 | Revere | 251005002113 | 2480305 | Susan B. Anthony Middle School | Regular School | No | 2 | 06 | 08 | 2015 | grade_7 | 54 | 5 | 88 | 1 | 11 | 1 | 10 | 79 | 91 | 170 | 54 | 5 | 88 | 1 | 11 | 1 | 10 | 79 | 91 | 170 | |||||||||||||||||||||||||||||||||
741276 | 741276 | MA | Berkshire | school | 2510080 | 249 | Richmond | 251008001635 | 2490005 | Richmond Consolidated | Regular School | No | 1 | PK | 08 | 2015 | grade_7 | 20 | 0 | 1 | 0 | 0 | 0 | 0 | 11 | 10 | 21 | 20 | 0 | 1 | 0 | 0 | 0 | 0 | 11 | 10 | 21 | |||||||||||||||||||||||||||||||||
741301 | 741301 | MA | Plymouth | school | 2510170 | 251 | Rockland | 251017001642 | 2510305 | John W Rogers Middle | Regular School | No | 2 | 05 | 08 | 2015 | grade_7 | 175 | 9 | 16 | 0 | 0 | 0 | 9 | 112 | 97 | 209 | 175 | 9 | 16 | 0 | 0 | 0 | 9 | 112 | 97 | 209 | |||||||||||||||||||||||||||||||||
741317 | 741317 | MA | Essex | school | 2510200 | 252 | Rockport | 251020000506 | 2520305 | Rockport Middle | Regular School | No | 2 | 06 | 08 | 2015 | grade_7 | 75 | 1 | 2 | 0 | 2 | 0 | 0 | 39 | 41 | 80 | 75 | 1 | 2 | 0 | 2 | 0 | 0 | 39 | 41 | 80 | |||||||||||||||||||||||||||||||||
741356 | 741356 | MA | Essex | school | 2510380 | 258 | Salem | 251038002559 | 2580025 | Nathaniel Bowditch | Regular School | No | 1 | KG | 08 | 2015 | grade_7 | 12 | 2 | 37 | 0 | 0 | 0 | 0 | 23 | 28 | 51 | 12 | 2 | 37 | 0 | 0 | 0 | 0 | 23 | 28 | 51 | |||||||||||||||||||||||||||||||||
741371 | 741371 | MA | Essex | school | 2510380 | 258 | Salem | 251038000773 | 2580050 | Saltonstall School | Regular School | No | 1 | KG | 08 | 2015 | grade_7 | 29 | 3 | 19 | 0 | 0 | 0 | 1 | 30 | 22 | 52 | 29 | 3 | 19 | 0 | 0 | 0 | 1 | 30 | 22 | 52 | |||||||||||||||||||||||||||||||||
741380 | 741380 | MA | Essex | school | 2510380 | 258 | Salem | 251038002404 | 2580305 | Collins Middle | Regular School | No | 2 | 06 | 08 | 2015 | grade_7 | 107 | 9 | 78 | 0 | 6 | 0 | 9 | 110 | 99 | 209 | 107 | 9 | 78 | 0 | 6 | 0 | 9 | 110 | 99 | 209 | |||||||||||||||||||||||||||||||||
741411 | 741411 | MA | Barnstable | school | 2510470 | 261 | Sandwich | 251047002824 | 2610305 | Sandwich STEM Academy | Regular School | No | 2 | 07 | 08 | 2015 | grade_7 | 241 | 5 | 4 | 1 | 7 | 0 | 1 | 133 | 126 | 259 | 241 | 5 | 4 | 1 | 7 | 0 | 1 | 133 | 126 | 259 | |||||||||||||||||||||||||||||||||
741443 | 741443 | MA | Essex | school | 2510500 | 262 | Saugus | 251050001685 | 2620305 | Belmonte Saugus Middle | Regular School | No | 2 | 06 | 08 | 2015 | grade_7 | 168 | 12 | 26 | 1 | 7 | 0 | 1 | 116 | 99 | 215 | 168 | 12 | 26 | 1 | 7 | 0 | 1 | 116 | 99 | 215 | |||||||||||||||||||||||||||||||||
741486 | 741486 | MA | Plymouth | school | 2510560 | 264 | Scituate | 251056001690 | 2640305 | Gates Intermediate School | Regular School | No | 2 | 07 | 08 | 2015 | grade_7 | 215 | 8 | 0 | 0 | 4 | 0 | 5 | 118 | 114 | 232 | 215 | 8 | 0 | 0 | 4 | 0 | 5 | 118 | 114 | 232 |
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]);