enrollments
Data source: Big Local News · About: Big Local
495 rows where grade = "grade_8", state = "MA" and year = 2018 sorted by male
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2230211 | 2230211 | MA | Suffolk | school | 35 | Boston | 350652 | 2018 | grade_8 | * | * | * | * | * | * | * | * | * | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||
2231645 | 2231645 | MA | Bristol | school | 2504830 | 95 | Fall River | 250483002858 | 950515 | Fall River: Fall River Gateway to College @ BCC | Regular School | No | High | 12 | 12 | 2018 | grade_8 | * | * | * | * | * | * | * | * | * | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||
2232023 | 2232023 | MA | Dukes | school | 2505340 | 109 | Gosnold | 250534000725 | 1090005 | Gosnold: Cuttyhunk Elementary | Regular School | No | Middle | 07 | 08 | 2018 | grade_8 | * | * | * | * | * | * | * | * | * | 1.0 | 1 | ||||||||||||||||||||||||||||||||||||||||||
2237229 | 2237229 | MA | Hampden | school | 2512510 | 332 | West Springfield | 251251002790 | 3320515 | West Springfield: 21st Century Skills Academy | Regular School | No | High | 12 | 12 | 2018 | grade_8 | * | * | * | * | * | * | * | * | * | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||
2234771 | 2234771 | MA | Worcester | school | 2509270 | 226 | Oxford | 250927002810 | 2260305 | Oxford: Project C.O.F.F.E.E. | Special Education School | No | High | 08 | 12 | 2018 | grade_8 | * | * | * | * | * | * | * | 1 | * | 1.0 | 1 | 1 | |||||||||||||||||||||||||||||||||||||||||
2233324 | 2233324 | MA | Essex | school | 2507110 | 163 | Lynn | 250711002647 | 1630525 | Lynn: Fecteau-Leary Junior/Senior High School | Regular School | No | High | 07 | 12 | 2018 | grade_8 | 3 | 0 | 9 | 0 | 0 | 0 | 1 | 10 | 3 | 13.0 | 3 | 0 | 9 | 0 | 0 | 0 | 1 | 10 | 3 | 13 | |||||||||||||||||||||||||||||||||
2238104 | 2238104 | MA | Suffolk | school | 2500070 | 438 | Codman Academy Charter Public (District) | 250007001667 | 4380505 | Codman Academy Charter Public (District): Codman Academy Charter Public School | Regular School | Yes | Other | PK | 12 | 2018 | grade_8 | 0 | 15 | 4 | 0 | 0 | 0 | 1 | 10 | 10 | 20.0 | 0 | 15 | 4 | 0 | 0 | 0 | 1 | 10 | 10 | 20 | |||||||||||||||||||||||||||||||||
2238249 | 2238249 | MA | Essex | school | 2500083 | 455 | Hill View Montessori Charter Public (District) | 250008301846 | 4550050 | Hill View Montessori Charter Public (District): Hill View Montessori Charter Public School | Regular School | Yes | Elementary | KG | 08 | 2018 | grade_8 | 20 | 1 | 9 | 0 | 0 | 0 | 1 | 10 | 21 | 31.0 | 20 | 1 | 9 | 0 | 0 | 0 | 1 | 10 | 21 | 31 | |||||||||||||||||||||||||||||||||
2234637 | 2234637 | MA | Middlesex | school | 2508820 | 217 | North Reading | 250882002592 | 2170305 | North Reading: North Reading Middle | Regular School | No | Middle | 06 | 08 | 2018 | grade_8 | 170 | 0 | 4 | 0 | 7 | 1 | 6 | 100 | 88 | 188.0 | 170 | 0 | 4 | 0 | 7 | 1 | 6 | 100 | 88 | 188 | |||||||||||||||||||||||||||||||||
2239625 | 2239625 | MA | Essex | school | 2511740 | 773 | Triton | 251174001470 | 7730405 | Triton: Triton Regional Middle School | Regular School | No | Middle | 07 | 08 | 2018 | grade_8 | 183 | 3 | 7 | 0 | 4 | 1 | 4 | 100 | 102 | 202.0 | 183 | 3 | 7 | 0 | 4 | 1 | 4 | 100 | 102 | 202 | |||||||||||||||||||||||||||||||||
2234660 | 2234660 | MA | Bristol | school | 2509000 | 218 | Norton | 250900001452 | 2180305 | Norton: Norton Middle | Regular School | No | Middle | 06 | 08 | 2018 | grade_8 | 191 | 6 | 6 | 0 | 3 | 0 | 5 | 102 | 109 | 211.0 | 191 | 6 | 6 | 0 | 3 | 0 | 5 | 102 | 109 | 211 | |||||||||||||||||||||||||||||||||
2234987 | 2234987 | MA | Berkshire | school | 2509630 | 236 | Pittsfield | 250963001532 | 2360310 | Pittsfield: Theodore Herberg Middle | Regular School | No | Middle | 06 | 08 | 2018 | grade_8 | 160 | 20 | 22 | 0 | 2 | 0 | 15 | 102 | 117 | 219.0 | 160 | 20 | 22 | 0 | 2 | 0 | 15 | 102 | 117 | 219 | |||||||||||||||||||||||||||||||||
2236761 | 2236761 | MA | Middlesex | school | 2512000 | 308 | Waltham | 251200001977 | 3080415 | Waltham: John W. McDevitt Middle School | Regular School | No | Middle | 06 | 08 | 2018 | grade_8 | 79 | 20 | 89 | 0 | 7 | 0 | 3 | 102 | 96 | 198.0 | 79 | 20 | 89 | 0 | 7 | 0 | 3 | 102 | 96 | 198 | |||||||||||||||||||||||||||||||||
2230883 | 2230883 | MA | Middlesex | school | 2503510 | 56 | Chelmsford | 250351000478 | 560310 | Chelmsford: McCarthy Middle School | Regular School | No | Middle | 05 | 08 | 2018 | grade_8 | 159 | 8 | 9 | 0 | 30 | 1 | 5 | 103 | 109 | 212.0 | 159 | 8 | 9 | 0 | 30 | 1 | 5 | 103 | 109 | 212 | |||||||||||||||||||||||||||||||||
2239169 | 2239169 | MA | Worcester | school | 2507680 | 710 | Mendon-Upton | 250768001279 | 7100015 | Mendon-Upton: Miscoe Hill School | Regular School | No | Middle | 05 | 08 | 2018 | grade_8 | 182 | 2 | 11 | 0 | 4 | 0 | 1 | 103 | 97 | 200.0 | 182 | 2 | 11 | 0 | 4 | 0 | 1 | 103 | 97 | 200 | |||||||||||||||||||||||||||||||||
2232266 | 2232266 | MA | Essex | school | 2505970 | 128 | Haverhill | 250597000850 | 1280100 | Haverhill: Consentino Middle School | Regular School | No | Middle | 03 | 08 | 2018 | grade_8 | 91 | 9 | 101 | 0 | 3 | 0 | 0 | 104 | 100 | 204.0 | 91 | 9 | 101 | 0 | 3 | 0 | 0 | 104 | 100 | 204 | |||||||||||||||||||||||||||||||||
2232347 | 2232347 | MA | Middlesex | school | 2506240 | 136 | Holliston | 250624001304 | 1360305 | Holliston: Robert H. Adams Middle School | Regular School | No | Middle | 06 | 08 | 2018 | grade_8 | 198 | 2 | 7 | 1 | 20 | 0 | 4 | 104 | 128 | 232.0 | 198 | 2 | 7 | 1 | 20 | 0 | 4 | 104 | 128 | 232 | |||||||||||||||||||||||||||||||||
2235752 | 2235752 | MA | Bristol | school | 2510860 | 273 | Somerset | 251086002537 | 2730305 | Somerset: Somerset Middle School | Regular School | No | Middle | 06 | 08 | 2018 | grade_8 | 185 | 0 | 10 | 0 | 0 | 0 | 3 | 104 | 94 | 198.0 | 185 | 0 | 10 | 0 | 0 | 0 | 3 | 104 | 94 | 198 | |||||||||||||||||||||||||||||||||
2230369 | 2230369 | MA | Norfolk | school | 2502940 | 40 | Braintree | 250294000372 | 400310 | Braintree: South Middle School | Regular School | No | Middle | 06 | 08 | 2018 | grade_8 | 169 | 4 | 10 | 0 | 38 | 0 | 1 | 105 | 117 | 222.0 | 169 | 4 | 10 | 0 | 38 | 0 | 1 | 105 | 117 | 222 | |||||||||||||||||||||||||||||||||
2239086 | 2239086 | MA | Hampden | school | 2505730 | 680 | Hampden-Wilbraham | 250573002141 | 6800310 | Hampden-Wilbraham: Wilbraham Middle | Regular School | No | Middle | 06 | 08 | 2018 | grade_8 | 190 | 6 | 12 | 0 | 6 | 0 | 5 | 105 | 114 | 219.0 | 190 | 6 | 12 | 0 | 6 | 0 | 5 | 105 | 114 | 219 | |||||||||||||||||||||||||||||||||
2229147 | 2229147 | MA | Middlesex | school | 2502400 | 23 | Bedford | 250240000130 | 230305 | Bedford: John Glenn Middle | Regular School | No | Middle | 06 | 08 | 2018 | grade_8 | 145 | 14 | 9 | 0 | 39 | 0 | 6 | 106 | 107 | 213.0 | 145 | 14 | 9 | 0 | 39 | 0 | 6 | 106 | 107 | 213 | |||||||||||||||||||||||||||||||||
2238910 | 2238910 | MA | Barnstable | school | 2504560 | 660 | Nauset | 250456000609 | 6600305 | Nauset: Nauset Regional Middle | Regular School | No | Middle | 06 | 08 | 2018 | grade_8 | 166 | 3 | 5 | 0 | 3 | 1 | 6 | 106 | 78 | 184.0 | 166 | 3 | 5 | 0 | 3 | 1 | 6 | 106 | 78 | 184 | |||||||||||||||||||||||||||||||||
2229348 | 2229348 | MA | Middlesex | school | 2502670 | 31 | Billerica | 250267000183 | 310305 | Billerica: Marshall Middle School | Regular School | No | Middle | 06 | 08 | 2018 | grade_8 | 187 | 10 | 7 | 1 | 10 | 0 | 2 | 107 | 110 | 217.0 | 187 | 10 | 7 | 1 | 10 | 0 | 2 | 107 | 110 | 217 | |||||||||||||||||||||||||||||||||
2230041 | 2230041 | MA | Suffolk | school | 2502790 | 35 | Boston | 250279002013 | 350383 | Boston: Lilla G. Frederick Middle School | Regular School | No | Middle | 06 | 08 | 2018 | grade_8 | 3 | 91 | 87 | 0 | 18 | 0 | 3 | 107 | 95 | 202.0 | 3 | 91 | 87 | 0 | 18 | 0 | 3 | 107 | 95 | 202 | |||||||||||||||||||||||||||||||||
2230503 | 2230503 | MA | Plymouth | school | 2503090 | 44 | Brockton | 250309000410 | 440420 | Brockton: West Middle School | Regular School | No | Middle | 06 | 08 | 2018 | grade_8 | 46 | 104 | 29 | 1 | 8 | 1 | 9 | 107 | 91 | 198.0 | 46 | 104 | 29 | 1 | 8 | 1 | 9 | 107 | 91 | 198 | |||||||||||||||||||||||||||||||||
2237074 | 2237074 | MA | Hampden | school | 2512630 | 325 | Westfield | 251263001570 | 3250310 | Westfield: South Middle School | Regular School | No | Middle | 06 | 08 | 2018 | grade_8 | 163 | 3 | 29 | 0 | 6 | 0 | 0 | 107 | 94 | 201.0 | 163 | 3 | 29 | 0 | 6 | 0 | 0 | 107 | 94 | 201 | |||||||||||||||||||||||||||||||||
2236216 | 2236216 | MA | Hampden | school | 2511130 | 281 | Springfield | 251113002855 | 2810485 | Springfield: Van Sickle Academy | Regular School | No | Middle | 06 | 08 | 2018 | grade_8 | 25 | 27 | 149 | 0 | 4 | 0 | 2 | 108 | 99 | 207.0 | 25 | 27 | 149 | 0 | 4 | 0 | 2 | 108 | 99 | 207 | |||||||||||||||||||||||||||||||||
2236864 | 2236864 | MA | Middlesex | school | 2512210 | 315 | Wayland | 251221002502 | 3150305 | Wayland: Wayland Middle School | Regular School | No | Middle | 06 | 08 | 2018 | grade_8 | 135 | 10 | 8 | 0 | 44 | 1 | 9 | 108 | 99 | 207.0 | 135 | 10 | 8 | 0 | 44 | 1 | 9 | 108 | 99 | 207 | |||||||||||||||||||||||||||||||||
2229079 | 2229079 | MA | Worcester | school | 2502220 | 17 | Auburn | 250222002567 | 170305 | Auburn: Auburn Middle | Regular School | No | Middle | 06 | 08 | 2018 | grade_8 | 184 | 3 | 14 | 0 | 5 | 0 | 10 | 109 | 107 | 216.0 | 184 | 3 | 14 | 0 | 5 | 0 | 10 | 109 | 107 | 216 | |||||||||||||||||||||||||||||||||
2231211 | 2231211 | MA | Norfolk | school | 2504050 | 73 | Dedham | 250405000551 | 730305 | Dedham: Dedham Middle School | Regular School | No | Middle | 06 | 08 | 2018 | grade_8 | 149 | 9 | 40 | 0 | 4 | 0 | 6 | 109 | 99 | 208.0 | 149 | 9 | 40 | 0 | 4 | 0 | 6 | 109 | 99 | 208 | |||||||||||||||||||||||||||||||||
2231619 | 2231619 | MA | Bristol | school | 2504830 | 95 | Fall River | 250483000672 | 950315 | Fall River: Morton Middle | Regular School | No | Middle | 06 | 08 | 2018 | grade_8 | 113 | 19 | 46 | 1 | 6 | 1 | 7 | 109 | 84 | 193.0 | 113 | 19 | 46 | 1 | 6 | 1 | 7 | 109 | 84 | 193 | |||||||||||||||||||||||||||||||||
2234449 | 2234449 | MA | Hampshire | school | 2508850 | 210 | Northampton | 250885001430 | 2100410 | Northampton: John F Kennedy Middle School | Regular School | No | Middle | 06 | 08 | 2018 | grade_8 | 165 | 3 | 25 | 1 | 8 | 0 | 14 | 109 | 107 | 216.0 | 165 | 3 | 25 | 1 | 8 | 0 | 14 | 109 | 107 | 216 | |||||||||||||||||||||||||||||||||
2238597 | 2238597 | MA | Hampshire | school | 2501920 | 605 | Amherst-Pelham | 250192000043 | 6050405 | Amherst-Pelham: Amherst Regional Middle School | Regular School | No | Middle | 07 | 08 | 2018 | grade_8 | 142 | 14 | 29 | 0 | 17 | 1 | 13 | 109 | 107 | 216.0 | 142 | 14 | 29 | 0 | 17 | 1 | 13 | 109 | 107 | 216 | |||||||||||||||||||||||||||||||||
2229545 | 2229545 | MA | Suffolk | school | 2502790 | 35 | Boston | 250279000230 | 350096 | Boston: Eliot Elementary | Regular School | No | Elementary | PK | 08 | 2018 | grade_8 | 9 | 6 | 7 | 1 | 2 | 0 | 1 | 11 | 15 | 26.0 | 9 | 6 | 7 | 1 | 2 | 0 | 1 | 11 | 15 | 26 | |||||||||||||||||||||||||||||||||
2229966 | 2229966 | MA | Suffolk | school | 2502790 | 35 | Boston | 250279000343 | 350370 | Boston: William Monroe Trotter | Regular School | No | Elementary | PK | 08 | 2018 | grade_8 | 0 | 13 | 9 | 0 | 0 | 0 | 1 | 11 | 12 | 23.0 | 0 | 13 | 9 | 0 | 0 | 0 | 1 | 11 | 12 | 23 | |||||||||||||||||||||||||||||||||
2234209 | 2234209 | MA | Bristol | school | 2508430 | 201 | New Bedford | 250843002590 | 2010510 | New Bedford: Trinity Day Academy | Regular School | No | High | 06 | 12 | 2018 | grade_8 | 7 | 1 | 5 | 0 | 0 | 0 | 2 | 11 | 4 | 15.0 | 7 | 1 | 5 | 0 | 0 | 0 | 2 | 11 | 4 | 15 | |||||||||||||||||||||||||||||||||
2234216 | 2234216 | MA | Bristol | school | 2508430 | 201 | New Bedford | 250843002681 | 2010515 | New Bedford: Whaling City Junior/Senior High School | Regular School | No | High | 06 | 12 | 2018 | grade_8 | 6 | 3 | 5 | 0 | 0 | 0 | 0 | 11 | 3 | 14.0 | 6 | 3 | 5 | 0 | 0 | 0 | 0 | 11 | 3 | 14 | |||||||||||||||||||||||||||||||||
2233609 | 2233609 | MA | Norfolk | school | 2507530 | 175 | Medfield | 250753001156 | 1750305 | Medfield: Thomas Blake Middle | Regular School | No | Middle | 06 | 08 | 2018 | grade_8 | 188 | 1 | 3 | 0 | 9 | 0 | 8 | 110 | 99 | 209.0 | 188 | 1 | 3 | 0 | 9 | 0 | 8 | 110 | 99 | 209 | |||||||||||||||||||||||||||||||||
2234590 | 2234590 | MA | Worcester | school | 2508940 | 214 | Northbridge | 250894002591 | 2140305 | Northbridge: Northbridge Middle | Regular School | No | Middle | 05 | 08 | 2018 | grade_8 | 176 | 2 | 10 | 0 | 5 | 0 | 8 | 110 | 91 | 201.0 | 176 | 2 | 10 | 0 | 5 | 0 | 8 | 110 | 91 | 201 | |||||||||||||||||||||||||||||||||
2230495 | 2230495 | MA | Plymouth | school | 2503090 | 44 | Brockton | 250309000404 | 440410 | Brockton: North Middle School | Regular School | No | Middle | 06 | 08 | 2018 | grade_8 | 20 | 164 | 23 | 0 | 3 | 2 | 4 | 111 | 105 | 216.0 | 20 | 164 | 23 | 0 | 3 | 2 | 4 | 111 | 105 | 216 | |||||||||||||||||||||||||||||||||
2235318 | 2235318 | MA | Suffolk | school | 2510050 | 248 | Revere | 251005001963 | 2480014 | Revere: Rumney Marsh Academy | Regular School | No | Middle | 06 | 08 | 2018 | grade_8 | 87 | 8 | 82 | 2 | 9 | 0 | 9 | 111 | 86 | 197.0 | 87 | 8 | 82 | 2 | 9 | 0 | 9 | 111 | 86 | 197 | |||||||||||||||||||||||||||||||||
2230141 | 2230141 | MA | Suffolk | school | 2502790 | 35 | Boston | 250279000204 | 350545 | Boston: Boston Latin Academy | Regular School | No | High | 07 | 12 | 2018 | grade_8 | 83 | 54 | 62 | 0 | 45 | 0 | 13 | 113 | 144 | 257.0 | 83 | 54 | 62 | 0 | 45 | 0 | 13 | 113 | 144 | 257 | |||||||||||||||||||||||||||||||||
2235562 | 2235562 | MA | Essex | school | 2510500 | 262 | Saugus | 251050001685 | 2620305 | Saugus: Belmonte Saugus Middle | Regular School | No | Middle | 06 | 08 | 2018 | grade_8 | 186 | 12 | 21 | 1 | 6 | 1 | 2 | 113 | 116 | 229.0 | 186 | 12 | 21 | 1 | 6 | 1 | 2 | 113 | 116 | 229 | |||||||||||||||||||||||||||||||||
2238834 | 2238834 | MA | Barnstable | school | 2504140 | 645 | Dennis-Yarmouth | 250414000558 | 6450505 | Dennis-Yarmouth: Dennis-Yarmouth Regional High | Regular School | No | High | 08 | 12 | 2018 | grade_8 | 154 | 26 | 29 | 6 | 4 | 0 | 11 | 113 | 117 | 230.0 | 154 | 26 | 29 | 6 | 4 | 0 | 11 | 113 | 117 | 230 | |||||||||||||||||||||||||||||||||
2238942 | 2238942 | MA | Bristol | school | 2505070 | 665 | Freetown-Lakeville | 250507000748 | 6650305 | Freetown-Lakeville: Freetown-Lakeville Middle School | Regular School | No | Middle | 06 | 08 | 2018 | grade_8 | 215 | 2 | 10 | 1 | 2 | 1 | 6 | 113 | 124 | 237.0 | 215 | 2 | 10 | 1 | 2 | 1 | 6 | 113 | 124 | 237 | |||||||||||||||||||||||||||||||||
2234906 | 2234906 | MA | Plymouth | school | 2509420 | 231 | Pembroke | 250942001823 | 2310305 | Pembroke: Pembroke Community Middle School | Regular School | No | Middle | 07 | 08 | 2018 | grade_8 | 241 | 0 | 3 | 0 | 4 | 0 | 3 | 114 | 137 | 251.0 | 241 | 0 | 3 | 0 | 4 | 0 | 3 | 114 | 137 | 251 | |||||||||||||||||||||||||||||||||
2235244 | 2235244 | MA | Norfolk | school | 2509930 | 244 | Randolph | 250993001392 | 2440410 | Randolph: Randolph Community Middle | Regular School | No | Middle | 06 | 08 | 2018 | grade_8 | 38 | 107 | 28 | 0 | 32 | 1 | 14 | 114 | 106 | 220.0 | 38 | 107 | 28 | 0 | 32 | 1 | 14 | 114 | 106 | 220 | |||||||||||||||||||||||||||||||||
2232007 | 2232007 | MA | Essex | school | 2505280 | 107 | Gloucester | 250528000779 | 1070305 | Gloucester: Ralph B O'Maley Middle | Regular School | No | Middle | 06 | 08 | 2018 | grade_8 | 198 | 3 | 21 | 0 | 2 | 0 | 5 | 115 | 114 | 229.0 | 198 | 3 | 21 | 0 | 2 | 0 | 5 | 115 | 114 | 229 | |||||||||||||||||||||||||||||||||
2233993 | 2233993 | MA | Middlesex | school | 2508340 | 198 | Natick | 250834001305 | 1980310 | Natick: Wilson Middle | Regular School | No | Middle | 05 | 08 | 2018 | grade_8 | 175 | 9 | 14 | 1 | 11 | 0 | 18 | 115 | 113 | 228.0 | 175 | 9 | 14 | 1 | 11 | 0 | 18 | 115 | 113 | 228 | |||||||||||||||||||||||||||||||||
2239776 | 2239776 | MA | Plymouth | school | 2512930 | 780 | Whitman-Hanson | 251293000207 | 7800310 | Whitman-Hanson: Whitman Middle | Regular School | No | Middle | 06 | 08 | 2018 | grade_8 | 177 | 6 | 10 | 0 | 2 | 0 | 4 | 115 | 84 | 199.0 | 177 | 6 | 10 | 0 | 2 | 0 | 4 | 115 | 84 | 199 | |||||||||||||||||||||||||||||||||
2235191 | 2235191 | MA | Norfolk | school | 2509870 | 243 | Quincy | 250987001564 | 2430315 | Quincy: Central Middle | Regular School | No | Middle | 06 | 08 | 2018 | grade_8 | 103 | 5 | 7 | 0 | 90 | 1 | 6 | 116 | 96 | 212.0 | 103 | 5 | 7 | 0 | 90 | 1 | 6 | 116 | 96 | 212 | |||||||||||||||||||||||||||||||||
2234577 | 2234577 | MA | Worcester | school | 2508880 | 213 | Northborough | 250888001440 | 2130305 | Northborough: Robert E. Melican Middle School | Regular School | No | Middle | 06 | 08 | 2018 | grade_8 | 180 | 3 | 5 | 1 | 22 | 3 | 7 | 117 | 104 | 221.0 | 180 | 3 | 5 | 1 | 22 | 3 | 7 | 117 | 104 | 221 | |||||||||||||||||||||||||||||||||
2239481 | 2239481 | MA | Worcester | school | 2500001 | 753 | Quabbin | 250000102003 | 7530405 | Quabbin: Quabbin Regional Middle School | Regular School | No | Middle | 07 | 08 | 2018 | grade_8 | 203 | 0 | 14 | 0 | 1 | 0 | 4 | 117 | 105 | 222.0 | 203 | 0 | 14 | 0 | 1 | 0 | 4 | 117 | 105 | 222 | |||||||||||||||||||||||||||||||||
2235523 | 2235523 | MA | Barnstable | school | 2510470 | 261 | Sandwich | 251047002824 | 2610305 | Sandwich: Sandwich STEM Academy | Regular School | No | Middle | 07 | 08 | 2018 | grade_8 | 216 | 2 | 1 | 2 | 4 | 1 | 0 | 118 | 108 | 226.0 | 216 | 2 | 1 | 2 | 4 | 1 | 0 | 118 | 108 | 226 | |||||||||||||||||||||||||||||||||
2237114 | 2237114 | MA | Middlesex | school | 2512660 | 326 | Westford | 251266000170 | 3260310 | Westford: Blanchard Middle | Regular School | No | Middle | 06 | 08 | 2018 | grade_8 | 144 | 3 | 2 | 1 | 65 | 1 | 2 | 118 | 100 | 218.0 | 144 | 3 | 2 | 1 | 65 | 1 | 2 | 118 | 100 | 218 | |||||||||||||||||||||||||||||||||
2238391 | 2238391 | MA | Suffolk | school | 2500063 | 484 | Roxbury Preparatory Charter (District) | 250006301453 | 4840505 | Roxbury Preparatory Charter (District): Roxbury Preparatory Charter School | Regular School | Yes | Middle | 05 | 11 | 2018 | grade_8 | 1 | 136 | 115 | 0 | 1 | 0 | 2 | 118 | 137 | 255.0 | 1 | 136 | 115 | 0 | 1 | 0 | 2 | 118 | 137 | 255 | |||||||||||||||||||||||||||||||||
2239399 | 2239399 | MA | Essex | school | 2509450 | 745 | Pentucket | 250945001512 | 7450405 | Pentucket: Pentucket Regional Middle | Regular School | No | Middle | 07 | 08 | 2018 | grade_8 | 199 | 0 | 8 | 0 | 6 | 0 | 2 | 118 | 97 | 215.0 | 199 | 0 | 8 | 0 | 6 | 0 | 2 | 118 | 97 | 215 | |||||||||||||||||||||||||||||||||
2232152 | 2232152 | MA | Plymouth | school | 2505790 | 122 | Hanover | 250579002548 | 1220305 | Hanover: Hanover Middle | Regular School | No | Middle | 05 | 08 | 2018 | grade_8 | 204 | 2 | 3 | 0 | 7 | 0 | 0 | 119 | 97 | 216.0 | 204 | 2 | 3 | 0 | 7 | 0 | 0 | 119 | 97 | 216 | |||||||||||||||||||||||||||||||||
2234728 | 2234728 | MA | Norfolk | school | 2509060 | 220 | Norwood | 250906001468 | 2200305 | Norwood: Dr. Philip O. Coakley Middle School | Regular School | No | Middle | 06 | 08 | 2018 | grade_8 | 169 | 27 | 26 | 0 | 9 | 0 | 4 | 119 | 116 | 235.0 | 169 | 27 | 26 | 0 | 9 | 0 | 4 | 119 | 116 | 235 | |||||||||||||||||||||||||||||||||
2237274 | 2237274 | MA | Norfolk | school | 2512810 | 335 | Westwood | 251281002097 | 3350305 | Westwood: E W Thurston Middle | Regular School | No | Middle | 06 | 08 | 2018 | grade_8 | 202 | 11 | 9 | 0 | 34 | 0 | 5 | 119 | 142 | 261.0 | 202 | 11 | 9 | 0 | 34 | 0 | 5 | 119 | 142 | 261 | |||||||||||||||||||||||||||||||||
2229378 | 2229378 | MA | Suffolk | school | 2502790 | 35 | Boston | 250279002458 | 350004 | Boston: Lyon K-8 | Regular School | No | Elementary | KG | 08 | 2018 | grade_8 | 6 | 3 | 10 | 0 | 1 | 0 | 0 | 12 | 8 | 20.0 | 6 | 3 | 10 | 0 | 1 | 0 | 0 | 12 | 8 | 20 | |||||||||||||||||||||||||||||||||
2229753 | 2229753 | MA | Suffolk | school | 2502790 | 35 | Boston | 250279000291 | 350229 | Boston: Maurice J Tobin | Regular School | No | Elementary | PK | 08 | 2018 | grade_8 | 0 | 8 | 18 | 0 | 0 | 0 | 1 | 12 | 15 | 27.0 | 0 | 8 | 18 | 0 | 0 | 0 | 1 | 12 | 15 | 27 | |||||||||||||||||||||||||||||||||
2229826 | 2229826 | MA | Suffolk | school | 2502790 | 35 | Boston | 250279000692 | 350262 | Boston: Lyndon | Regular School | No | Elementary | PK | 08 | 2018 | grade_8 | 6 | 6 | 17 | 0 | 1 | 0 | 2 | 12 | 20 | 32.0 | 6 | 6 | 17 | 0 | 1 | 0 | 2 | 12 | 20 | 32 | |||||||||||||||||||||||||||||||||
2229996 | 2229996 | MA | Suffolk | school | 2502790 | 35 | Boston | 250279002669 | 350376 | Boston: King K-8 | Regular School | No | Elementary | PK | 08 | 2018 | grade_8 | 2 | 18 | 7 | 0 | 0 | 0 | 0 | 12 | 15 | 27.0 | 2 | 18 | 7 | 0 | 0 | 0 | 0 | 12 | 15 | 27 | |||||||||||||||||||||||||||||||||
2238130 | 2238130 | MA | Essex | school | 2500027 | 440 | Community Day Charter Public School - Prospect (District) | 250002700535 | 4400205 | Community Day Charter Public School - Prospect (District): Community Day Charter Public School - Prospect | Regular School | Yes | Elementary | PK | 08 | 2018 | grade_8 | 2 | 0 | 19 | 0 | 1 | 0 | 0 | 12 | 10 | 22.0 | 2 | 0 | 19 | 0 | 1 | 0 | 0 | 12 | 10 | 22 | |||||||||||||||||||||||||||||||||
2230365 | 2230365 | MA | Norfolk | school | 2502940 | 40 | Braintree | 250294000364 | 400305 | Braintree: East Middle School | Regular School | No | Middle | 06 | 08 | 2018 | grade_8 | 182 | 9 | 10 | 1 | 34 | 0 | 5 | 120 | 121 | 241.0 | 182 | 9 | 10 | 1 | 34 | 0 | 5 | 120 | 121 | 241 | |||||||||||||||||||||||||||||||||
2231378 | 2231378 | MA | Hampden | school | 2504500 | 87 | East Longmeadow | 250450000602 | 870305 | East Longmeadow: Birchland Park | Regular School | No | Middle | 06 | 08 | 2018 | grade_8 | 187 | 6 | 19 | 0 | 17 | 0 | 1 | 121 | 109 | 230.0 | 187 | 6 | 19 | 0 | 17 | 0 | 1 | 121 | 109 | 230 | |||||||||||||||||||||||||||||||||
2236194 | 2236194 | MA | Hampden | school | 2511130 | 281 | Springfield | 251113002830 | 2810365 | Springfield: Chestnut Academy | Regular School | No | Middle | 06 | 08 | 2018 | grade_8 | 9 | 26 | 190 | 1 | 1 | 0 | 2 | 121 | 108 | 229.0 | 9 | 26 | 190 | 1 | 1 | 0 | 2 | 121 | 108 | 229 | |||||||||||||||||||||||||||||||||
2235068 | 2235068 | MA | Plymouth | school | 2509720 | 239 | Plymouth | 250972001380 | 2390305 | Plymouth: Plymouth South Middle | Regular School | No | Middle | 06 | 08 | 2018 | grade_8 | 219 | 2 | 7 | 0 | 2 | 0 | 8 | 122 | 116 | 238.0 | 219 | 2 | 7 | 0 | 2 | 0 | 8 | 122 | 116 | 238 | |||||||||||||||||||||||||||||||||
2231302 | 2231302 | MA | Plymouth | school | 2504410 | 82 | Duxbury | 250441000975 | 820305 | Duxbury: Duxbury Middle | Regular School | No | Middle | 06 | 08 | 2018 | grade_8 | 227 | 0 | 6 | 1 | 3 | 0 | 10 | 123 | 124 | 247.0 | 227 | 0 | 6 | 1 | 3 | 0 | 10 | 123 | 124 | 247 | |||||||||||||||||||||||||||||||||
2231779 | 2231779 | MA | Norfolk | school | 2504950 | 99 | Foxborough | 250495000709 | 990405 | Foxborough: John J Ahern | Regular School | No | Middle | 05 | 08 | 2018 | grade_8 | 184 | 9 | 18 | 2 | 6 | 0 | 4 | 123 | 100 | 223.0 | 184 | 9 | 18 | 2 | 6 | 0 | 4 | 123 | 100 | 223 | |||||||||||||||||||||||||||||||||
2233145 | 2233145 | MA | Hampden | school | 2507050 | 161 | Ludlow | 250705001055 | 1610305 | Ludlow: Paul R Baird Middle | Regular School | No | Middle | 06 | 08 | 2018 | grade_8 | 204 | 7 | 17 | 0 | 1 | 0 | 7 | 124 | 112 | 236.0 | 204 | 7 | 17 | 0 | 1 | 0 | 7 | 124 | 112 | 236 | |||||||||||||||||||||||||||||||||
2233460 | 2233460 | MA | Essex | school | 2507260 | 168 | Marblehead | 250726001789 | 1680300 | Marblehead: Marblehead Veterans Middle School | Regular School | No | Middle | 07 | 08 | 2018 | grade_8 | 227 | 6 | 12 | 0 | 1 | 0 | 7 | 124 | 129 | 253.0 | 227 | 6 | 12 | 0 | 1 | 0 | 7 | 124 | 129 | 253 | |||||||||||||||||||||||||||||||||
2237070 | 2237070 | MA | Hampden | school | 2512630 | 325 | Westfield | 251263001569 | 3250305 | Westfield: North Middle School | Regular School | No | Middle | 06 | 08 | 2018 | grade_8 | 184 | 5 | 32 | 0 | 6 | 1 | 4 | 124 | 108 | 232.0 | 184 | 5 | 32 | 0 | 6 | 1 | 4 | 124 | 108 | 232 | |||||||||||||||||||||||||||||||||
2230815 | 2230815 | MA | Norfolk | school | 2503300 | 50 | Canton | 250330000456 | 500305 | Canton: Wm H Galvin Middle | Regular School | No | Middle | 06 | 08 | 2018 | grade_8 | 181 | 34 | 19 | 0 | 23 | 0 | 5 | 125 | 137 | 262.0 | 181 | 34 | 19 | 0 | 23 | 0 | 5 | 125 | 137 | 262 | |||||||||||||||||||||||||||||||||
2236175 | 2236175 | MA | Hampden | school | 2511130 | 281 | Springfield | 251113002602 | 2810330 | Springfield: M Marcus Kiley Middle | Regular School | No | Middle | 06 | 08 | 2018 | grade_8 | 26 | 53 | 143 | 0 | 6 | 0 | 2 | 125 | 105 | 230.0 | 26 | 53 | 143 | 0 | 6 | 0 | 2 | 125 | 105 | 230 | |||||||||||||||||||||||||||||||||
2228815 | 2228815 | MA | Hampden | school | 2501800 | 5 | Agawam | 250180000025 | 50405 | Agawam: Agawam Junior High | Regular School | No | Middle | 07 | 08 | 2018 | grade_8 | 216 | 6 | 24 | 0 | 7 | 0 | 9 | 129 | 133 | 262.0 | 216 | 6 | 24 | 0 | 7 | 0 | 9 | 129 | 133 | 262 | |||||||||||||||||||||||||||||||||
2236167 | 2236167 | MA | Hampden | school | 2511130 | 281 | Springfield | 251113002600 | 2810325 | Springfield: Forest Park Middle | Regular School | No | Middle | 06 | 08 | 2018 | grade_8 | 13 | 51 | 163 | 0 | 20 | 1 | 3 | 129 | 122 | 251.0 | 13 | 51 | 163 | 0 | 20 | 1 | 3 | 129 | 122 | 251 | |||||||||||||||||||||||||||||||||
2229718 | 2229718 | MA | Suffolk | school | 2502790 | 35 | Boston | 250279000278 | 350190 | Boston: Joyce Kilmer | Regular School | No | Elementary | PK | 08 | 2018 | grade_8 | 6 | 8 | 10 | 0 | 3 | 0 | 0 | 13 | 14 | 27.0 | 6 | 8 | 10 | 0 | 3 | 0 | 0 | 13 | 14 | 27 | |||||||||||||||||||||||||||||||||
2230037 | 2230037 | MA | Suffolk | school | 2502790 | 35 | Boston | 250279000946 | 350382 | Boston: Mission Hill School | Regular School | No | Elementary | PK | 08 | 2018 | grade_8 | 5 | 4 | 8 | 0 | 0 | 0 | 1 | 13 | 5 | 18.0 | 5 | 4 | 8 | 0 | 0 | 0 | 1 | 13 | 5 | 18 | |||||||||||||||||||||||||||||||||
2230687 | 2230687 | MA | Middlesex | school | 2503270 | 49 | Cambridge | 250327001621 | 490006 | Cambridge: Amigos School | Regular School | No | Elementary | PK | 08 | 2018 | grade_8 | 9 | 1 | 10 | 0 | 1 | 0 | 4 | 13 | 12 | 25.0 | 9 | 1 | 10 | 0 | 1 | 0 | 4 | 13 | 12 | 25 | |||||||||||||||||||||||||||||||||
2231030 | 2231030 | MA | Berkshire | school | 2503720 | 63 | Clarksburg | 250372000510 | 630010 | Clarksburg: Clarksburg Elementary | Regular School | No | Elementary | KG | 08 | 2018 | grade_8 | 18 | 0 | 1 | 0 | 1 | 0 | 1 | 13 | 8 | 21.0 | 18 | 0 | 1 | 0 | 1 | 0 | 1 | 13 | 8 | 21 | |||||||||||||||||||||||||||||||||
2236036 | 2236036 | MA | Hampden | school | 2511130 | 281 | Springfield | 251113001809 | 2810095 | Springfield: Alfred G. Zanetti Montessori Magnet School | Regular School | No | Elementary | PK | 08 | 2018 | grade_8 | 5 | 8 | 13 | 0 | 0 | 0 | 2 | 13 | 15 | 28.0 | 5 | 8 | 13 | 0 | 0 | 0 | 2 | 13 | 15 | 28 | |||||||||||||||||||||||||||||||||
2236178 | 2236178 | MA | Hampden | school | 2511130 | 281 | Springfield | 251113002740 | 2810345 | Springfield: Springfield Public Day Middle School | Regular School | No | Middle | 06 | 08 | 2018 | grade_8 | 1 | 3 | 13 | 0 | 0 | 0 | 0 | 13 | 4 | 17.0 | 1 | 3 | 13 | 0 | 0 | 0 | 0 | 13 | 4 | 17 | |||||||||||||||||||||||||||||||||
2238213 | 2238213 | MA | Hampshire | school | 2500031 | 450 | Hilltown Cooperative Charter Public (District) | 250003100549 | 4500105 | Hilltown Cooperative Charter Public (District): Hilltown Cooperative Charter Public School | Regular School | Yes | Elementary | KG | 08 | 2018 | grade_8 | 23 | 0 | 6 | 0 | 1 | 0 | 2 | 13 | 19 | 32.0 | 23 | 0 | 6 | 0 | 1 | 0 | 2 | 13 | 19 | 32 | |||||||||||||||||||||||||||||||||
2238228 | 2238228 | MA | Hampden | school | 2500087 | 453 | Holyoke Community Charter (District) | 250008701997 | 4530005 | Holyoke Community Charter (District): Holyoke Community Charter School | Regular School | Yes | Elementary | KG | 08 | 2018 | grade_8 | 2 | 2 | 39 | 0 | 0 | 0 | 0 | 13 | 30 | 43.0 | 2 | 2 | 39 | 0 | 0 | 0 | 0 | 13 | 30 | 43 | |||||||||||||||||||||||||||||||||
2232475 | 2232475 | MA | Middlesex | school | 2506330 | 139 | Hopkinton | 250633000468 | 1390305 | Hopkinton: Hopkinton Middle School | Regular School | No | Middle | 06 | 08 | 2018 | grade_8 | 228 | 2 | 3 | 1 | 35 | 0 | 8 | 130 | 147 | 277.0 | 228 | 2 | 3 | 1 | 35 | 0 | 8 | 130 | 147 | 277 | |||||||||||||||||||||||||||||||||
2231006 | 2231006 | MA | Hampden | school | 2503660 | 61 | Chicopee | 250366000491 | 610305 | Chicopee: Bellamy Middle | Regular School | No | Middle | 06 | 08 | 2018 | grade_8 | 163 | 7 | 87 | 0 | 4 | 0 | 5 | 131 | 135 | 266.0 | 163 | 7 | 87 | 0 | 4 | 0 | 5 | 131 | 135 | 266 | |||||||||||||||||||||||||||||||||
2236547 | 2236547 | MA | Middlesex | school | 2511580 | 295 | Tewksbury | 251158000366 | 2950305 | Tewksbury: John W. Wynn Middle | Regular School | No | Middle | 07 | 08 | 2018 | grade_8 | 285 | 6 | 9 | 0 | 10 | 0 | 2 | 131 | 181 | 312.0 | 285 | 6 | 9 | 0 | 10 | 0 | 2 | 131 | 181 | 312 | |||||||||||||||||||||||||||||||||
2235608 | 2235608 | MA | Plymouth | school | 2510560 | 264 | Scituate | 251056001690 | 2640305 | Scituate: Gates Middle School | Regular School | No | Middle | 06 | 08 | 2018 | grade_8 | 249 | 12 | 0 | 0 | 6 | 0 | 3 | 132 | 138 | 270.0 | 249 | 12 | 0 | 0 | 6 | 0 | 3 | 132 | 138 | 270 | |||||||||||||||||||||||||||||||||
2239363 | 2239363 | MA | Plymouth | school | 2509150 | 740 | Old Rochester | 250915001473 | 7400405 | Old Rochester: Old Rochester Regional Jr High | Regular School | No | Middle | 07 | 08 | 2018 | grade_8 | 238 | 5 | 5 | 0 | 3 | 0 | 10 | 133 | 128 | 261.0 | 238 | 5 | 5 | 0 | 3 | 0 | 10 | 133 | 128 | 261 | |||||||||||||||||||||||||||||||||
2231859 | 2231859 | MA | Middlesex | school | 2504980 | 100 | Framingham | 250498000733 | 1000310 | Framingham: Walsh Middle | Regular School | No | Middle | 06 | 08 | 2018 | grade_8 | 133 | 12 | 82 | 0 | 21 | 0 | 9 | 134 | 123 | 257.0 | 133 | 12 | 82 | 0 | 21 | 0 | 9 | 134 | 123 | 257 | |||||||||||||||||||||||||||||||||
2232050 | 2232050 | MA | Worcester | school | 2505370 | 110 | Grafton | 250537002520 | 1100305 | Grafton: Grafton Middle | Regular School | No | Middle | 07 | 08 | 2018 | grade_8 | 215 | 3 | 9 | 0 | 31 | 0 | 9 | 135 | 132 | 267.0 | 215 | 3 | 9 | 0 | 31 | 0 | 9 | 135 | 132 | 267 | |||||||||||||||||||||||||||||||||
2236331 | 2236331 | MA | Norfolk | school | 2511250 | 285 | Stoughton | 251125001865 | 2850405 | Stoughton: O'Donnell Middle School | Regular School | No | Middle | 06 | 08 | 2018 | grade_8 | 139 | 53 | 19 | 0 | 13 | 1 | 17 | 135 | 107 | 242.0 | 139 | 53 | 19 | 0 | 13 | 1 | 17 | 135 | 107 | 242 | |||||||||||||||||||||||||||||||||
2236649 | 2236649 | MA | Middlesex | school | 2511910 | 305 | Wakefield | 251191000776 | 3050310 | Wakefield: Galvin Middle School | Regular School | No | Middle | 05 | 08 | 2018 | grade_8 | 248 | 7 | 12 | 1 | 11 | 0 | 5 | 136 | 148 | 284.0 | 248 | 7 | 12 | 1 | 11 | 0 | 5 | 136 | 148 | 284 | |||||||||||||||||||||||||||||||||
2234201 | 2234201 | MA | Bristol | school | 2508430 | 201 | New Bedford | 250843001339 | 2010415 | New Bedford: Roosevelt Middle School | Regular School | No | Middle | 06 | 08 | 2018 | grade_8 | 95 | 44 | 111 | 1 | 2 | 1 | 9 | 138 | 125 | 263.0 | 95 | 44 | 111 | 1 | 2 | 1 | 9 | 138 | 125 | 263 | |||||||||||||||||||||||||||||||||
2233724 | 2233724 | MA | Middlesex | school | 2507620 | 178 | Melrose | 250762002557 | 1780305 | Melrose: Melrose Middle | Regular School | No | Middle | 06 | 08 | 2018 | grade_8 | 220 | 14 | 6 | 0 | 12 | 0 | 13 | 139 | 126 | 265.0 | 220 | 14 | 6 | 0 | 12 | 0 | 13 | 139 | 126 | 265 | |||||||||||||||||||||||||||||||||
2233797 | 2233797 | MA | Plymouth | school | 2507770 | 182 | Middleborough | 250777001378 | 1820305 | Middleborough: John T. Nichols Middle | Regular School | No | Middle | 06 | 08 | 2018 | grade_8 | 247 | 6 | 13 | 1 | 2 | 0 | 5 | 139 | 135 | 274.0 | 247 | 6 | 13 | 1 | 2 | 0 | 5 | 139 | 135 | 274 | |||||||||||||||||||||||||||||||||
2231284 | 2231284 | MA | Middlesex | school | 2504320 | 79 | Dracut | 250432001625 | 790410 | Dracut: Justus C. Richardson Middle School | Regular School | No | Middle | 06 | 08 | 2018 | grade_8 | 238 | 25 | 20 | 0 | 21 | 0 | 7 | 141 | 170 | 311.0 | 238 | 25 | 20 | 0 | 21 | 0 | 7 | 141 | 170 | 311 | |||||||||||||||||||||||||||||||||
2232878 | 2232878 | MA | Middlesex | school | 2506840 | 155 | Lexington | 250684002552 | 1550310 | Lexington: Wm Diamond Middle | Regular School | No | Middle | 06 | 08 | 2018 | grade_8 | 159 | 11 | 4 | 0 | 107 | 0 | 20 | 141 | 160 | 301.0 | 159 | 11 | 4 | 0 | 107 | 0 | 20 | 141 | 160 | 301 |
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]);