enrollments
Data source: Big Local News · About: Big Local
497 rows where grade = "grade_7", state = "MA" and year = 2017 sorted by rowid descending
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1131323 | 1131323 | MA | Suffolk | school | 2500029 | 444 | Neighborhood House Charter (District) | 250002900545 | 4440205 | Neighborhood House Charter School | Regular School | Yes | Elementary | PK | 08 | 2017 | grade_7 | 8 | 23 | 4 | 2 | 1 | 0 | 0 | 23 | 15 | 38 | 8 | 23 | 4 | 2 | 1 | 0 | 0 | 23 | 15 | 38 | |||||||||||||||||||||||||||||||||
1131308 | 1131308 | MA | Hampden | school | 2500028 | 441 | Sabis International Charter (District) | 250002800537 | 4410505 | Sabis International Charter School | Regular School | Yes | Other | KG | 12 | 2017 | grade_7 | 31 | 35 | 47 | 0 | 4 | 0 | 12 | 58 | 71 | 129 | 31 | 35 | 47 | 0 | 4 | 0 | 12 | 58 | 71 | 129 | |||||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||||
1131244 | 1131244 | MA | Middlesex | school | 2500025 | 435 | Innovation Academy Charter (District) | 250002500524 | 4350305 | Innovation Academy Charter School | Regular School | Yes | Other | 05 | 12 | 2017 | grade_7 | 84 | 4 | 1 | 0 | 9 | 0 | 2 | 47 | 53 | 100 | 84 | 4 | 1 | 0 | 9 | 0 | 2 | 47 | 53 | 100 | |||||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||||
1131215 | 1131215 | MA | Essex | school | 2500082 | 429 | KIPP Academy Lynn Charter (District) | 250008201845 | 4290010 | KIPP Academy Lynn Charter School | Regular School | Yes | Other | KG | 12 | 2017 | grade_7 | 7 | 33 | 71 | 0 | 2 | 0 | 6 | 57 | 62 | 119 | 7 | 33 | 71 | 0 | 2 | 0 | 6 | 57 | 62 | 119 | |||||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||||
1131170 | 1131170 | MA | Suffolk | school | 2500077 | 419 | Helen Y. Davis Leadership Academy Charter Public (District) | 250007702091 | 4190305 | Helen Y. Davis Leadership Academy Charter Public School | Regular School | Yes | Middle | 06 | 08 | 2017 | grade_7 | 0 | 71 | 6 | 0 | 0 | 0 | 0 | 39 | 38 | 77 | 0 | 71 | 6 | 0 | 0 | 0 | 0 | 39 | 38 | 77 | |||||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||||
1131134 | 1131134 | MA | Franklin | school | 2500076 | 413 | Four Rivers Charter Public (District) | 250007602086 | 4130505 | Four Rivers Charter Public School | Regular School | Yes | High | 07 | 12 | 2017 | grade_7 | 33 | 1 | 1 | 0 | 0 | 0 | 1 | 18 | 18 | 36 | 33 | 1 | 1 | 0 | 0 | 0 | 1 | 18 | 18 | 36 | |||||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||||
1131112 | 1131112 | MA | Suffolk | school | 2500075 | 410 | Excel Academy Charter (District) | 250007502084 | 4100205 | Excel Academy Charter School | Regular School | Yes | Other | 05 | 10 | 2017 | grade_7 | 14 | 10 | 146 | 3 | 1 | 0 | 0 | 85 | 89 | 174 | 14 | 10 | 146 | 3 | 1 | 0 | 0 | 85 | 89 | 174 | |||||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||||
1131042 | 1131042 | MA | Worcester | school | 2513230 | 348 | Worcester | 251323002223 | 3480423 | Sullivan Middle | Regular School | No | Middle | 06 | 08 | 2017 | grade_7 | 103 | 57 | 181 | 1 | 49 | 0 | 22 | 209 | 204 | 413 | 103 | 57 | 181 | 1 | 49 | 0 | 22 | 209 | 204 | 413 | |||||||||||||||||||||||||||||||||
1131038 | 1131038 | MA | Worcester | school | 2513230 | 348 | Worcester | 251323002253 | 3480420 | Worcester East Middle | Regular School | No | Middle | 06 | 08 | 2017 | grade_7 | 84 | 60 | 190 | 0 | 22 | 0 | 9 | 193 | 172 | 365 | 84 | 60 | 190 | 0 | 22 | 0 | 9 | 193 | 172 | 365 | |||||||||||||||||||||||||||||||||
1131034 | 1131034 | MA | Worcester | school | 2513230 | 348 | Worcester | 251323002213 | 3480415 | Forest Grove Middle | Regular School | No | Middle | 07 | 08 | 2017 | grade_7 | 219 | 58 | 163 | 0 | 31 | 0 | 21 | 262 | 230 | 492 | 219 | 58 | 163 | 0 | 31 | 0 | 21 | 262 | 230 | 492 | |||||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||||
1131017 | 1131017 | MA | Worcester | school | 2513230 | 348 | Worcester | 251323001076 | 3480285 | University Pk Campus School | Regular School | No | High | 07 | 12 | 2017 | grade_7 | 4 | 4 | 29 | 0 | 9 | 0 | 1 | 30 | 17 | 47 | 4 | 4 | 29 | 0 | 9 | 0 | 1 | 30 | 17 | 47 | |||||||||||||||||||||||||||||||||
1130723 | 1130723 | MA | Middlesex | school | 2513200 | 347 | Woburn | 251320002182 | 3470410 | Daniel L Joyce Middle School | Regular School | No | Middle | 06 | 08 | 2017 | grade_7 | 146 | 10 | 12 | 2 | 10 | 1 | 5 | 93 | 93 | 186 | 146 | 10 | 12 | 2 | 10 | 1 | 5 | 93 | 93 | 186 | |||||||||||||||||||||||||||||||||
1130719 | 1130719 | MA | Middlesex | school | 2513200 | 347 | Woburn | 251320002186 | 3470405 | John F Kennedy Middle School | Regular School | No | Middle | 06 | 08 | 2017 | grade_7 | 141 | 13 | 18 | 2 | 13 | 0 | 3 | 93 | 97 | 190 | 141 | 13 | 18 | 2 | 13 | 0 | 3 | 93 | 97 | 190 | |||||||||||||||||||||||||||||||||
1130651 | 1130651 | MA | Suffolk | school | 2513170 | 346 | Winthrop | 251317002179 | 3460305 | Winthrop Middle School | Regular School | No | Middle | 06 | 08 | 2017 | grade_7 | 127 | 1 | 20 | 0 | 1 | 0 | 2 | 80 | 71 | 151 | 127 | 1 | 20 | 0 | 1 | 0 | 2 | 80 | 71 | 151 | |||||||||||||||||||||||||||||||||
1130633 | 1130633 | MA | Middlesex | school | 2513110 | 344 | Winchester | 251311002167 | 3440305 | McCall Middle | Regular School | No | Middle | 06 | 08 | 2017 | grade_7 | 264 | 0 | 14 | 1 | 66 | 1 | 19 | 178 | 187 | 365 | 264 | 0 | 14 | 1 | 66 | 1 | 19 | 178 | 187 | 365 | |||||||||||||||||||||||||||||||||
1130583 | 1130583 | MA | Middlesex | school | 2513080 | 343 | Winchendon | 251308002796 | 3430315 | Murdock Middle School | Regular School | No | Middle | 06 | 08 | 2017 | grade_7 | 74 | 5 | 9 | 1 | 3 | 0 | 2 | 47 | 47 | 94 | 74 | 5 | 9 | 1 | 3 | 0 | 2 | 47 | 47 | 94 | |||||||||||||||||||||||||||||||||
1130564 | 1130564 | MA | Middlesex | school | 2513050 | 342 | Wilmington | 251305001578 | 3420330 | Wilmington Middle School | Regular School | No | Middle | 06 | 08 | 2017 | grade_7 | 267 | 5 | 16 | 1 | 11 | 0 | 8 | 161 | 147 | 308 | 267 | 5 | 16 | 1 | 11 | 0 | 8 | 161 | 147 | 308 | |||||||||||||||||||||||||||||||||
1130463 | 1130463 | MA | Norfolk | school | 2512840 | 336 | Weymouth | 251284001840 | 3360020 | Maria Weston Chapman Middle School | Regular School | No | Middle | 05 | 08 | 2017 | grade_7 | 370 | 34 | 29 | 0 | 23 | 1 | 22 | 248 | 231 | 479 | 370 | 34 | 29 | 0 | 23 | 1 | 22 | 248 | 231 | 479 | |||||||||||||||||||||||||||||||||
1130445 | 1130445 | MA | Norfolk | school | 2512810 | 335 | Westwood | 251281002097 | 3350305 | E W Thurston Middle | Regular School | No | Middle | 06 | 08 | 2017 | grade_7 | 203 | 10 | 10 | 0 | 34 | 0 | 5 | 121 | 141 | 262 | 203 | 10 | 10 | 0 | 34 | 0 | 5 | 121 | 141 | 262 | |||||||||||||||||||||||||||||||||
1130397 | 1130397 | MA | Hampden | school | 2512510 | 332 | West Springfield | 251251001243 | 3320305 | West Springfield Middle | Regular School | No | Middle | 06 | 08 | 2017 | grade_7 | 195 | 10 | 56 | 1 | 17 | 0 | 7 | 149 | 137 | 286 | 195 | 10 | 56 | 1 | 17 | 0 | 7 | 149 | 137 | 286 | |||||||||||||||||||||||||||||||||
1130353 | 1130353 | MA | Bristol | school | 2512780 | 331 | Westport | 251278002861 | 3310515 | Westport Junior/Senior High School | Regular School | No | High | 07 | 12 | 2017 | grade_7 | 114 | 0 | 3 | 0 | 2 | 0 | 5 | 66 | 58 | 124 | 114 | 0 | 3 | 0 | 2 | 0 | 5 | 66 | 58 | 124 | |||||||||||||||||||||||||||||||||
1130335 | 1130335 | MA | Middlesex | school | 2512750 | 330 | Weston | 251275000793 | 3300305 | Weston Middle | Regular School | No | Middle | 06 | 08 | 2017 | grade_7 | 110 | 13 | 9 | 2 | 28 | 0 | 6 | 76 | 92 | 168 | 110 | 13 | 9 | 2 | 28 | 0 | 6 | 76 | 92 | 168 | |||||||||||||||||||||||||||||||||
1130302 | 1130302 | MA | Middlesex | school | 2512660 | 326 | Westford | 251266002080 | 3260330 | Stony Brook School | Regular School | No | Middle | 06 | 08 | 2017 | grade_7 | 126 | 4 | 3 | 1 | 45 | 0 | 7 | 88 | 98 | 186 | 126 | 4 | 3 | 1 | 45 | 0 | 7 | 88 | 98 | 186 | |||||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||||
1130258 | 1130258 | MA | Hampden | school | 2512630 | 325 | Westfield | 251263001570 | 3250310 | South Middle School | Regular School | No | Middle | 06 | 08 | 2017 | grade_7 | 161 | 3 | 31 | 0 | 5 | 0 | 0 | 102 | 98 | 200 | 161 | 3 | 31 | 0 | 5 | 0 | 0 | 102 | 98 | 200 | |||||||||||||||||||||||||||||||||
1130254 | 1130254 | MA | Hampden | school | 2512630 | 325 | Westfield | 251263001569 | 3250305 | North Middle School | Regular School | No | Middle | 06 | 08 | 2017 | grade_7 | 185 | 3 | 29 | 0 | 5 | 1 | 4 | 122 | 105 | 227 | 185 | 3 | 29 | 0 | 5 | 1 | 4 | 122 | 105 | 227 | |||||||||||||||||||||||||||||||||
1130195 | 1130195 | MA | Plymouth | school | 2512420 | 323 | West Bridgewater | 251242002039 | 3230505 | West Bridgewater Junior/Senior | Regular School | No | High | 07 | 12 | 2017 | grade_7 | 105 | 2 | 5 | 0 | 1 | 0 | 0 | 61 | 52 | 113 | 105 | 2 | 5 | 0 | 1 | 0 | 0 | 61 | 52 | 113 | |||||||||||||||||||||||||||||||||
1130177 | 1130177 | MA | Worcester | school | 2512390 | 322 | West Boylston | 251239002035 | 3220505 | West Boylston Junior/Senior High | Regular School | No | Other | 06 | 12 | 2017 | grade_7 | 79 | 1 | 9 | 1 | 1 | 0 | 4 | 45 | 50 | 95 | 79 | 1 | 9 | 1 | 1 | 0 | 4 | 45 | 50 | 95 | |||||||||||||||||||||||||||||||||
1130160 | 1130160 | MA | Worcester | school | 2512600 | 321 | Westborough | 251260002604 | 3210305 | Sarah W Gibbons Middle | Regular School | No | Middle | 07 | 08 | 2017 | grade_7 | 180 | 4 | 21 | 0 | 92 | 0 | 18 | 157 | 158 | 315 | 180 | 4 | 21 | 0 | 92 | 0 | 18 | 157 | 158 | 315 | |||||||||||||||||||||||||||||||||
1130124 | 1130124 | MA | Norfolk | school | 2512270 | 317 | Wellesley | 251227002029 | 3170305 | Wellesley Middle | Regular School | No | Middle | 06 | 08 | 2017 | grade_7 | 266 | 17 | 18 | 0 | 29 | 0 | 20 | 169 | 181 | 350 | 266 | 17 | 18 | 0 | 29 | 0 | 20 | 169 | 181 | 350 | |||||||||||||||||||||||||||||||||
1130065 | 1130065 | MA | Worcester | school | 2512240 | 316 | Webster | 251224002849 | 3160315 | Webster Middle School | Regular School | No | Middle | 05 | 08 | 2017 | grade_7 | 96 | 10 | 31 | 1 | 3 | 2 | 10 | 66 | 87 | 153 | 96 | 10 | 31 | 1 | 3 | 2 | 10 | 66 | 87 | 153 | |||||||||||||||||||||||||||||||||
1130048 | 1130048 | MA | Middlesex | school | 2512210 | 315 | Wayland | 251221002502 | 3150305 | Wayland Middle School | Regular School | No | Middle | 06 | 08 | 2017 | grade_7 | 131 | 9 | 6 | 0 | 41 | 1 | 9 | 102 | 95 | 197 | 131 | 9 | 6 | 0 | 41 | 1 | 9 | 102 | 95 | 197 | |||||||||||||||||||||||||||||||||
1130018 | 1130018 | MA | Middlesex | school | 2512180 | 314 | Watertown | 251218002501 | 3140305 | Watertown Middle | Regular School | No | Middle | 06 | 08 | 2017 | grade_7 | 102 | 8 | 24 | 0 | 19 | 0 | 10 | 87 | 76 | 163 | 102 | 8 | 24 | 0 | 19 | 0 | 10 | 87 | 76 | 163 | |||||||||||||||||||||||||||||||||
1129980 | 1129980 | MA | Plymouth | school | 2512060 | 310 | Wareham | 251206002603 | 3100305 | Wareham Middle | Regular School | No | Middle | 05 | 08 | 2017 | grade_7 | 148 | 15 | 9 | 3 | 1 | 0 | 15 | 92 | 99 | 191 | 148 | 15 | 9 | 3 | 1 | 0 | 15 | 92 | 99 | 191 | |||||||||||||||||||||||||||||||||
1129963 | 1129963 | MA | Hampshire | school | 2512030 | 309 | Ware | 251203001983 | 3090505 | Ware Junior/Senior High School | Regular School | No | High | 07 | 12 | 2017 | grade_7 | 80 | 2 | 6 | 1 | 0 | 0 | 3 | 57 | 35 | 92 | 80 | 2 | 6 | 1 | 0 | 0 | 3 | 57 | 35 | 92 | |||||||||||||||||||||||||||||||||
1129945 | 1129945 | MA | Middlesex | school | 2512000 | 308 | Waltham | 251200001977 | 3080415 | John W. McDevitt Middle School | Regular School | No | Middle | 06 | 08 | 2017 | grade_7 | 83 | 17 | 82 | 0 | 6 | 0 | 3 | 96 | 95 | 191 | 83 | 17 | 82 | 0 | 6 | 0 | 3 | 96 | 95 | 191 | |||||||||||||||||||||||||||||||||
1129941 | 1129941 | MA | Middlesex | school | 2512000 | 308 | Waltham | 251200001971 | 3080404 | John F Kennedy Middle | Regular School | No | Middle | 06 | 08 | 2017 | grade_7 | 93 | 15 | 41 | 0 | 6 | 0 | 4 | 76 | 83 | 159 | 93 | 15 | 41 | 0 | 6 | 0 | 4 | 76 | 83 | 159 | |||||||||||||||||||||||||||||||||
1129886 | 1129886 | MA | Norfolk | school | 2511970 | 307 | Walpole | 251197001965 | 3070310 | Eleanor N Johnson Middle | Regular School | No | Middle | 06 | 08 | 2017 | grade_7 | 124 | 5 | 6 | 0 | 16 | 0 | 6 | 88 | 69 | 157 | 124 | 5 | 6 | 0 | 16 | 0 | 6 | 88 | 69 | 157 | |||||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||||
1129834 | 1129834 | MA | Middlesex | school | 2511910 | 305 | Wakefield | 251191000776 | 3050310 | Galvin Middle School | Regular School | No | Middle | 05 | 08 | 2017 | grade_7 | 252 | 9 | 12 | 0 | 11 | 0 | 6 | 140 | 150 | 290 | 252 | 9 | 12 | 0 | 11 | 0 | 6 | 140 | 150 | 290 | |||||||||||||||||||||||||||||||||
1129791 | 1129791 | MA | Worcester | school | 2511850 | 304 | Uxbridge | 251185001939 | 3040015 | McCloskey Middle School | Regular School | No | Middle | 06 | 08 | 2017 | grade_7 | 116 | 0 | 7 | 0 | 3 | 0 | 5 | 67 | 64 | 131 | 116 | 0 | 7 | 0 | 3 | 0 | 5 | 67 | 64 | 131 | |||||||||||||||||||||||||||||||||
1129777 | 1129777 | MA | Middlesex | school | 2511760 | 301 | Tyngsborough | 251176001715 | 3010305 | Tyngsborough Middle | Regular School | No | Middle | 06 | 08 | 2017 | grade_7 | 125 | 4 | 7 | 0 | 7 | 0 | 5 | 75 | 73 | 148 | 125 | 4 | 7 | 0 | 7 | 0 | 5 | 75 | 73 | 148 | |||||||||||||||||||||||||||||||||
1129746 | 1129746 | MA | Dukes | school | 2512570 | 296 | Tisbury | 251257002054 | 2960005 | Tisbury Elementary | Regular School | No | Elementary | PK | 08 | 2017 | grade_7 | 23 | 0 | 9 | 3 | 1 | 0 | 3 | 19 | 20 | 39 | 23 | 0 | 9 | 3 | 1 | 0 | 3 | 19 | 20 | 39 | |||||||||||||||||||||||||||||||||
1129730 | 1129730 | MA | Middlesex | school | 2511580 | 295 | Tewksbury | 251158000366 | 2950305 | John W. Wynn Middle | Regular School | No | Middle | 07 | 08 | 2017 | grade_7 | 286 | 6 | 8 | 0 | 10 | 0 | 2 | 132 | 180 | 312 | 286 | 6 | 8 | 0 | 10 | 0 | 2 | 132 | 180 | 312 | |||||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||||
1129695 | 1129695 | MA | Bristol | school | 2511520 | 293 | Taunton | 251152002416 | 2930305 | John F Parker Middle | Regular School | No | Middle | 05 | 07 | 2017 | grade_7 | 86 | 19 | 29 | 0 | 6 | 1 | 7 | 70 | 78 | 148 | 86 | 19 | 29 | 0 | 6 | 1 | 7 | 70 | 78 | 148 | |||||||||||||||||||||||||||||||||
1129685 | 1129685 | MA | Bristol | school | 2511520 | 293 | Taunton | 251152001911 | 2930042 | Joseph H Martin | Regular School | No | Middle | 05 | 07 | 2017 | grade_7 | 187 | 35 | 30 | 0 | 6 | 0 | 10 | 127 | 141 | 268 | 187 | 35 | 30 | 0 | 6 | 0 | 10 | 127 | 141 | 268 | |||||||||||||||||||||||||||||||||
1129637 | 1129637 | MA | Bristol | school | 2511460 | 292 | Swansea | 251146001894 | 2920305 | Joseph Case Jr High | Regular School | No | Middle | 06 | 08 | 2017 | grade_7 | 170 | 1 | 2 | 0 | 0 | 0 | 0 | 96 | 77 | 173 | 170 | 1 | 2 | 0 | 0 | 0 | 0 | 96 | 77 | 173 | |||||||||||||||||||||||||||||||||
1129611 | 1129611 | MA | Essex | school | 2511430 | 291 | Swampscott | 251143002562 | 2910305 | Swampscott Middle | Regular School | No | Middle | 05 | 08 | 2017 | grade_7 | 162 | 8 | 24 | 0 | 8 | 0 | 3 | 95 | 110 | 205 | 162 | 8 | 24 | 0 | 8 | 0 | 3 | 95 | 110 | 205 | |||||||||||||||||||||||||||||||||
1129582 | 1129582 | MA | Worcester | school | 2511400 | 290 | Sutton | 251140001413 | 2900305 | Sutton Middle School | Regular School | No | Middle | 06 | 08 | 2017 | grade_7 | 120 | 0 | 1 | 0 | 1 | 0 | 4 | 61 | 65 | 126 | 120 | 0 | 1 | 0 | 1 | 0 | 4 | 61 | 65 | 126 | |||||||||||||||||||||||||||||||||
1129560 | 1129560 | MA | Middlesex | school | 2511340 | 288 | Sudbury | 251134001872 | 2880305 | Ephraim Curtis Middle | Regular School | No | Middle | 06 | 08 | 2017 | grade_7 | 285 | 6 | 6 | 0 | 19 | 1 | 16 | 188 | 145 | 333 | 285 | 6 | 6 | 0 | 19 | 1 | 16 | 188 | 145 | 333 | |||||||||||||||||||||||||||||||||
1129513 | 1129513 | MA | Norfolk | school | 2511250 | 285 | Stoughton | 251125001865 | 2850405 | O'Donnell Middle School | Regular School | No | Middle | 06 | 08 | 2017 | grade_7 | 138 | 55 | 17 | 0 | 14 | 1 | 16 | 133 | 108 | 241 | 138 | 55 | 17 | 0 | 14 | 1 | 16 | 133 | 108 | 241 | |||||||||||||||||||||||||||||||||
1129466 | 1129466 | MA | Middlesex | school | 2511220 | 284 | Stoneham | 251122001857 | 2840405 | Stoneham Central Middle School | Regular School | No | Middle | 05 | 08 | 2017 | grade_7 | 145 | 1 | 12 | 0 | 7 | 0 | 6 | 90 | 81 | 171 | 145 | 1 | 12 | 0 | 7 | 0 | 6 | 90 | 81 | 171 | |||||||||||||||||||||||||||||||||
1129397 | 1129397 | MA | Hampden | school | 2511130 | 281 | Springfield | 251113002855 | 2810485 | Van Sickle International Baccalaureate | Regular School | No | Middle | 06 | 08 | 2017 | grade_7 | 14 | 10 | 74 | 0 | 4 | 0 | 0 | 60 | 42 | 102 | 14 | 10 | 74 | 0 | 4 | 0 | 0 | 60 | 42 | 102 | |||||||||||||||||||||||||||||||||
1129393 | 1129393 | MA | Hampden | school | 2511130 | 281 | Springfield | 251113002859 | 2810480 | Van Sickle Academy | Regular School | No | Middle | 06 | 08 | 2017 | grade_7 | 10 | 16 | 67 | 0 | 3 | 0 | 2 | 52 | 46 | 98 | 10 | 16 | 67 | 0 | 3 | 0 | 2 | 52 | 46 | 98 | |||||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||||
1129366 | 1129366 | MA | Hampden | school | 2511130 | 281 | Springfield | 251113002733 | 2810355 | South End Middle School | Regular School | No | Middle | 06 | 08 | 2017 | grade_7 | 2 | 10 | 68 | 0 | 0 | 0 | 2 | 41 | 41 | 82 | 2 | 10 | 68 | 0 | 0 | 0 | 2 | 41 | 41 | 82 | |||||||||||||||||||||||||||||||||
1129362 | 1129362 | MA | Hampden | school | 2511130 | 281 | Springfield | 251113002642 | 2810350 | STEM Middle Academy | Regular School | No | Middle | 06 | 08 | 2017 | grade_7 | 16 | 25 | 58 | 0 | 2 | 0 | 0 | 67 | 34 | 101 | 16 | 25 | 58 | 0 | 2 | 0 | 0 | 67 | 34 | 101 | |||||||||||||||||||||||||||||||||
1129358 | 1129358 | MA | Hampden | school | 2511130 | 281 | Springfield | 251113002740 | 2810345 | Springfield Public Day Middle School | Regular School | No | Middle | 06 | 08 | 2017 | grade_7 | 1 | 4 | 11 | 0 | 0 | 0 | 0 | 12 | 4 | 16 | 1 | 4 | 11 | 0 | 0 | 0 | 0 | 12 | 4 | 16 | |||||||||||||||||||||||||||||||||
1129354 | 1129354 | MA | Hampden | school | 2511130 | 281 | Springfield | 251113002602 | 2810330 | M Marcus Kiley Middle | Regular School | No | Middle | 06 | 08 | 2017 | grade_7 | 27 | 59 | 144 | 0 | 5 | 0 | 0 | 128 | 107 | 235 | 27 | 59 | 144 | 0 | 5 | 0 | 0 | 128 | 107 | 235 | |||||||||||||||||||||||||||||||||
1129350 | 1129350 | MA | Hampden | school | 2511130 | 281 | Springfield | 251113002601 | 2810328 | John F Kennedy Middle | Regular School | No | Middle | 06 | 08 | 2017 | grade_7 | 14 | 24 | 109 | 0 | 1 | 0 | 2 | 79 | 71 | 150 | 14 | 24 | 109 | 0 | 1 | 0 | 2 | 79 | 71 | 150 | |||||||||||||||||||||||||||||||||
1129346 | 1129346 | MA | Hampden | school | 2511130 | 281 | Springfield | 251113002600 | 2810325 | Forest Park Middle | Regular School | No | Middle | 06 | 08 | 2017 | grade_7 | 15 | 51 | 152 | 0 | 16 | 1 | 3 | 113 | 125 | 238 | 15 | 51 | 152 | 0 | 16 | 1 | 3 | 113 | 125 | 238 | |||||||||||||||||||||||||||||||||
1129339 | 1129339 | MA | Hampden | school | 2511130 | 281 | Springfield | 251113002599 | 2810320 | John J Duggan Middle | Regular School | No | Other | 06 | 11 | 2017 | grade_7 | 29 | 43 | 101 | 0 | 4 | 0 | 2 | 104 | 75 | 179 | 29 | 43 | 101 | 0 | 4 | 0 | 2 | 104 | 75 | 179 | |||||||||||||||||||||||||||||||||
1129331 | 1129331 | MA | Hampden | school | 2511130 | 281 | Springfield | 251113002137 | 2810205 | The Springfield Renaissance School an Expeditionary Learning School | Regular School | No | Other | 06 | 12 | 2017 | grade_7 | 28 | 27 | 54 | 0 | 1 | 0 | 0 | 57 | 53 | 110 | 28 | 27 | 54 | 0 | 1 | 0 | 0 | 57 | 53 | 110 | |||||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||||
1129079 | 1129079 | MA | Hampshire | school | 2510920 | 278 | South Hadley | 251092001752 | 2780305 | Michael E. Smith Middle School | Regular School | No | Middle | 05 | 08 | 2017 | grade_7 | 106 | 4 | 18 | 0 | 4 | 0 | 5 | 65 | 72 | 137 | 106 | 4 | 18 | 0 | 4 | 0 | 5 | 65 | 72 | 137 | |||||||||||||||||||||||||||||||||
1129061 | 1129061 | MA | Worcester | school | 2511010 | 277 | Southbridge | 251101002865 | 2770315 | Southbridge Middle School | Regular School | No | Middle | 06 | 08 | 2017 | grade_7 | 57 | 1 | 98 | 1 | 0 | 0 | 4 | 83 | 78 | 161 | 57 | 1 | 98 | 1 | 0 | 0 | 4 | 83 | 78 | 161 | |||||||||||||||||||||||||||||||||
1129042 | 1129042 | MA | Worcester | school | 2510980 | 276 | Southborough | 251098001221 | 2760305 | P Brent Trottier | Regular School | No | Middle | 06 | 08 | 2017 | grade_7 | 122 | 1 | 8 | 0 | 18 | 0 | 8 | 73 | 84 | 157 | 122 | 1 | 8 | 0 | 18 | 0 | 8 | 73 | 84 | 157 | |||||||||||||||||||||||||||||||||
1129009 | 1129009 | MA | Middlesex | school | 2510890 | 274 | Somerville | 251089002498 | 2740410 | Next Wave Junior High | Alternative School | No | Middle | 06 | 08 | 2017 | grade_7 | * | * | * | * | * | * | * | 3 | * | * | 3 | ||||||||||||||||||||||||||||||||||||||||||
1129005 | 1129005 | MA | Middlesex | school | 2510890 | 274 | Somerville | 251089001749 | 2740120 | Winter Hill Community | Regular School | No | Elementary | PK | 08 | 2017 | grade_7 | 5 | 7 | 45 | 0 | 6 | 0 | 1 | 35 | 29 | 64 | 5 | 7 | 45 | 0 | 6 | 0 | 1 | 35 | 29 | 64 | |||||||||||||||||||||||||||||||||
1128994 | 1128994 | MA | Middlesex | school | 2510890 | 274 | Somerville | 251089000891 | 2740115 | West Somerville Neighborhood | Regular School | No | Elementary | PK | 08 | 2017 | grade_7 | 26 | 9 | 10 | 0 | 3 | 0 | 3 | 27 | 24 | 51 | 26 | 9 | 10 | 0 | 3 | 0 | 3 | 27 | 24 | 51 | |||||||||||||||||||||||||||||||||
1128983 | 1128983 | MA | Middlesex | school | 2510890 | 274 | Somerville | 251089001736 | 2740111 | E Somerville Community | Regular School | No | Elementary | KG | 08 | 2017 | grade_7 | 5 | 5 | 42 | 0 | 1 | 1 | 0 | 26 | 28 | 54 | 5 | 5 | 42 | 0 | 1 | 1 | 0 | 26 | 28 | 54 | |||||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||||
1128962 | 1128962 | MA | Middlesex | school | 2510890 | 274 | Somerville | 251089001738 | 2740083 | John F Kennedy | Regular School | No | Elementary | PK | 08 | 2017 | grade_7 | 34 | 6 | 13 | 0 | 7 | 0 | 2 | 37 | 25 | 62 | 34 | 6 | 13 | 0 | 7 | 0 | 2 | 37 | 25 | 62 | |||||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||||
1128930 | 1128930 | MA | Bristol | school | 2510860 | 273 | Somerset | 251086002537 | 2730305 | Somerset Middle School | Regular School | No | Middle | 06 | 08 | 2017 | grade_7 | 187 | 0 | 7 | 0 | 0 | 0 | 3 | 101 | 96 | 197 | 187 | 0 | 7 | 0 | 0 | 0 | 3 | 101 | 96 | 197 | |||||||||||||||||||||||||||||||||
1128879 | 1128879 | MA | Worcester | school | 2510770 | 271 | Shrewsbury | 251077001825 | 2710030 | Oak Middle School | Regular School | No | Middle | 07 | 08 | 2017 | grade_7 | 307 | 6 | 50 | 1 | 131 | 0 | 16 | 258 | 253 | 511 | 307 | 6 | 50 | 1 | 131 | 0 | 16 | 258 | 253 | 511 | |||||||||||||||||||||||||||||||||
1128843 | 1128843 | MA | Norfolk | school | 2510620 | 266 | Sharon | 251062002560 | 2660305 | Sharon Middle | Regular School | No | Middle | 06 | 08 | 2017 | grade_7 | 187 | 10 | 14 | 1 | 80 | 0 | 14 | 160 | 146 | 306 | 187 | 10 | 14 | 1 | 80 | 0 | 14 | 160 | 146 | 306 | |||||||||||||||||||||||||||||||||
1128812 | 1128812 | MA | Bristol | school | 2510590 | 265 | Seekonk | 251059001700 | 2650405 | Dr. Kevin M. Hurley Middle School | Regular School | No | Middle | 06 | 08 | 2017 | grade_7 | 150 | 3 | 10 | 0 | 6 | 0 | 5 | 89 | 85 | 174 | 150 | 3 | 10 | 0 | 6 | 0 | 5 | 89 | 85 | 174 | |||||||||||||||||||||||||||||||||
1128788 | 1128788 | MA | Plymouth | school | 2510560 | 264 | Scituate | 251056001690 | 2640305 | Gates Intermediate School | Regular School | No | Middle | 07 | 08 | 2017 | grade_7 | 243 | 9 | 0 | 0 | 6 | 0 | 3 | 126 | 135 | 261 | 243 | 9 | 0 | 0 | 6 | 0 | 3 | 126 | 135 | 261 | |||||||||||||||||||||||||||||||||
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 |
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]);