enrollments
Data source: Big Local News · About: Big Local
2,773 rows where grade = "grade_11" and state = "MA" sorted by black 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
738009 | 738009 | MA | Middlesex | school | 2504770 | 93 | Everett | 250477000634 | 930505 | Everett High | Regular School | No | 3 | 09 | 12 | 2015 | grade_11 | 163 | 99 | 149 | 2 | 30 | 0 | 6 | 236 | 213 | 449 | 163 | 99 | 149 | 2 | 30 | 0 | 6 | 236 | 213 | 449 | |||||||||||||||||||||||||||||||||
1675656 | 1675656 | MA | Middlesex | school | 2507020 | 160 | Lowell | 250702001041 | 1600505 | Lowell - Lowell High | Regular School | No | High | 09 | 12 | 2021 | grade_11 | 206 | 99 | 179 | 0 | 227 | 0 | 25 | 362 | 374 | * | 736.0 | 206 | 99 | 179 | 0 | 227 | 0 | 25 | 362 | 374 | 736 | ||||||||||||||||||||||||||||||||
1123418 | 1123418 | MA | Suffolk | school | 2502790 | 35 | Boston | 250279002725 | 350657 | TechBoston Academy | Regular School | No | Other | 06 | 12 | 2017 | grade_11 | 3 | 98 | 24 | 1 | 5 | 1 | 2 | 64 | 70 | 134 | 3 | 98 | 24 | 1 | 5 | 1 | 2 | 64 | 70 | 134 | |||||||||||||||||||||||||||||||||
2043495 | 2043495 | MA | Middlesex | school | 2507020 | 160 | Lowell | 250702001041 | 1600505 | Lowell High | Regular School | No | High | 09 | 12 | 2019 | grade_11 | 232 | 98 | 195 | 0 | 237 | 1 | 19 | 386 | 396 | 782.0 | 232 | 98 | 195 | 0 | 237 | 1 | 19 | 386 | 396 | 782 | |||||||||||||||||||||||||||||||||
1123379 | 1123379 | MA | Suffolk | school | 2502790 | 35 | Boston | 250279000205 | 350575 | O'Bryant School Math/Science | Regular School | No | High | 07 | 12 | 2017 | grade_11 | 22 | 97 | 84 | 0 | 77 | 0 | 6 | 136 | 150 | 286 | 22 | 97 | 84 | 0 | 77 | 0 | 6 | 136 | 150 | 286 | |||||||||||||||||||||||||||||||||
1365937 | 1365937 | MA | Suffolk | school | 2502790 | 35 | Boston | 250279000282 | 350537 | Madison Park High | Career and Technical School | No | High | 09 | 12 | 2020 | grade_11 | 6 | 97 | 125 | 1 | 7 | 1 | 1 | 147 | 91 | * | 238.0 | 6 | 97 | 125 | 1 | 7 | 1 | 1 | 147 | 91 | 238 | ||||||||||||||||||||||||||||||||
1368683 | 1368683 | MA | Middlesex | school | 2507170 | 165 | Malden | 250717001106 | 1650505 | Malden High | Regular School | No | High | 09 | 12 | 2020 | grade_11 | 100 | 97 | 125 | 0 | 104 | 0 | 7 | 249 | 183 | * | 433.0 | 100 | 97 | 125 | 0 | 104 | 0 | 7 | 249 | 183 | 433 | ||||||||||||||||||||||||||||||||
2042162 | 2042162 | MA | Middlesex | school | 2504770 | 93 | Everett | 250477000634 | 930505 | Everett High | Regular School | No | High | 09 | 12 | 2019 | grade_11 | 128 | 97 | 265 | 2 | 23 | 2 | 5 | 270 | 252 | 522.0 | 128 | 97 | 265 | 2 | 23 | 2 | 5 | 270 | 252 | 522 | |||||||||||||||||||||||||||||||||
2233416 | 2233416 | MA | Middlesex | school | 2507170 | 165 | Malden | 250717001106 | 1650505 | Malden: Malden High | Regular School | No | High | 09 | 12 | 2018 | grade_11 | 130 | 97 | 103 | 2 | 108 | 0 | 15 | 218 | 237 | 455.0 | 130 | 97 | 103 | 2 | 108 | 0 | 15 | 218 | 237 | 455 | |||||||||||||||||||||||||||||||||
933686 | 933686 | MA | Suffolk | school | 2502790 | 35 | Boston | 250279000261 | 350525 | Jeremiah E Burke High | Regular School | No | 3 | 09 | 12 | 2016 | grade_11 | 5 | 96 | 19 | 0 | 0 | 0 | 1 | 64 | 57 | 121 | 5 | 96 | 19 | 0 | 0 | 0 | 1 | 64 | 57 | 121 | |||||||||||||||||||||||||||||||||
1123272 | 1123272 | MA | Suffolk | school | 2502790 | 35 | Boston | 250279000208 | 350505 | Brighton High | Regular School | No | High | 09 | 12 | 2017 | grade_11 | 8 | 96 | 96 | 2 | 9 | 0 | 2 | 131 | 82 | 213 | 8 | 96 | 96 | 2 | 9 | 0 | 2 | 131 | 82 | 213 | |||||||||||||||||||||||||||||||||
1673235 | 1673235 | MA | Suffolk | school | 2502790 | 35 | Boston | 250279000205 | 350575 | Boston - O'Bryant School Math/Science | Regular School | No | High | 07 | 12 | 2021 | grade_11 | 37 | 96 | 86 | 1 | 61 | 0 | 4 | 125 | 160 | * | 285.0 | 37 | 96 | 86 | 1 | 61 | 0 | 4 | 125 | 160 | 285 | ||||||||||||||||||||||||||||||||
1678308 | 1678308 | MA | Hampden | school | 2511130 | 281 | Springfield | 251113002444 | 2810500 | Springfield - Springfield Central High | Regular School | No | High | 09 | 12 | 2021 | grade_11 | 54 | 96 | 231 | 0 | 20 | 0 | 5 | 208 | 198 | * | 406.0 | 54 | 96 | 231 | 0 | 20 | 0 | 5 | 208 | 198 | 406 | ||||||||||||||||||||||||||||||||
2231503 | 2231503 | MA | Middlesex | school | 2504770 | 93 | Everett | 250477000634 | 930505 | Everett: Everett High | Regular School | No | High | 09 | 12 | 2018 | grade_11 | 141 | 96 | 251 | 1 | 23 | 1 | 5 | 260 | 258 | 518.0 | 141 | 96 | 251 | 1 | 23 | 1 | 5 | 260 | 258 | 518 | |||||||||||||||||||||||||||||||||
936453 | 936453 | MA | Middlesex | school | 2507170 | 165 | Malden | 250717001106 | 1650505 | Malden High | Regular School | No | 3 | 09 | 12 | 2016 | grade_11 | 113 | 95 | 90 | 2 | 98 | 1 | 20 | 201 | 218 | 419 | 113 | 95 | 90 | 2 | 98 | 1 | 20 | 201 | 218 | 419 | |||||||||||||||||||||||||||||||||
2045297 | 2045297 | MA | Norfolk | school | 2509930 | 244 | Randolph | 250993001596 | 2440505 | Randolph High | Regular School | No | High | 09 | 12 | 2019 | grade_11 | 14 | 95 | 14 | 1 | 29 | 1 | 4 | 87 | 71 | 158.0 | 14 | 95 | 14 | 1 | 29 | 1 | 4 | 87 | 71 | 158 | |||||||||||||||||||||||||||||||||
2230184 | 2230184 | MA | Suffolk | school | 2502790 | 35 | Boston | 250279000205 | 350575 | Boston: O'Bryant School Math/Science | Regular School | No | High | 07 | 12 | 2018 | grade_11 | 25 | 95 | 82 | 2 | 65 | 1 | 6 | 126 | 150 | 276.0 | 25 | 95 | 82 | 2 | 65 | 1 | 6 | 126 | 150 | 276 | |||||||||||||||||||||||||||||||||
2230238 | 2230238 | MA | Suffolk | school | 2502790 | 35 | Boston | 250279002725 | 350657 | Boston: TechBoston Academy | Regular School | No | High | 06 | 12 | 2018 | grade_11 | 3 | 95 | 26 | 1 | 8 | 0 | 2 | 78 | 57 | 135.0 | 3 | 95 | 26 | 1 | 8 | 0 | 2 | 78 | 57 | 135 | |||||||||||||||||||||||||||||||||
2230194 | 2230194 | MA | Suffolk | school | 2502790 | 35 | Boston | 250279001902 | 350581 | Boston: Community Academy of Science and Health | Regular School | No | High | 09 | 12 | 2018 | grade_11 | 0 | 94 | 27 | 0 | 1 | 0 | 4 | 67 | 59 | 126.0 | 0 | 94 | 27 | 0 | 1 | 0 | 4 | 67 | 59 | 126 | |||||||||||||||||||||||||||||||||
741996 | 741996 | MA | Hampden | school | 2511130 | 281 | Springfield | 251113002444 | 2810500 | Springfield Central High | Regular School | No | 3 | 09 | 12 | 2015 | grade_11 | 73 | 93 | 212 | 0 | 26 | 0 | 16 | 210 | 210 | 420 | 73 | 93 | 212 | 0 | 26 | 0 | 16 | 210 | 210 | 420 | |||||||||||||||||||||||||||||||||
937115 | 937115 | MA | Bristol | school | 2508430 | 201 | New Bedford | 250843001336 | 2010505 | New Bedford High | Regular School | No | 3 | 09 | 12 | 2016 | grade_11 | 284 | 93 | 276 | 5 | 6 | 3 | 28 | 351 | 344 | 695 | 284 | 93 | 276 | 5 | 6 | 3 | 28 | 351 | 344 | 695 | |||||||||||||||||||||||||||||||||
1673176 | 1673176 | MA | Suffolk | school | 2502790 | 35 | Boston | 250279000282 | 350537 | Boston - Madison Park High | Career and Technical School | No | High | 09 | 12 | 2021 | grade_11 | 5 | 93 | 124 | 2 | 1 | 1 | 3 | 130 | 99 | * | 229.0 | 5 | 93 | 124 | 2 | 1 | 1 | 3 | 130 | 99 | 229 | ||||||||||||||||||||||||||||||||
745112 | 745112 | MA | Bristol | school | 2511020 | 872 | Southeastern Regional Vocational Technical | 251102002290 | 8720605 | Southeastern Regional Vocational Technical | Vocational Education School | No | 3 | 09 | 12 | 2015 | grade_11 | 175 | 92 | 39 | 0 | 1 | 0 | 6 | 168 | 145 | 313 | 175 | 92 | 39 | 0 | 1 | 0 | 6 | 168 | 145 | 313 | |||||||||||||||||||||||||||||||||
1366025 | 1366025 | MA | Suffolk | school | 2502790 | 35 | Boston | 250279002725 | 350657 | TechBoston Academy | Regular School | No | High | 06 | 12 | 2020 | grade_11 | 4 | 92 | 32 | 1 | 5 | 0 | 0 | 66 | 68 | * | 134.0 | 4 | 92 | 32 | 1 | 5 | 0 | 0 | 66 | 68 | 134 | ||||||||||||||||||||||||||||||||
1681493 | 1681493 | MA | Plymouth | school | 2500559 | 3513 | New Heights Charter School of Brockton (District) | 250055902869 | 35130305 | New Heights Charter School of Brockton (District) - New Heights Charter School of Brockton | Regular School | Yes | High | 06 | 12 | 2021 | grade_11 | 1 | 92 | 8 | 0 | 0 | 0 | 0 | 49 | 52 | * | 101.0 | 1 | 92 | 8 | 0 | 0 | 0 | 0 | 49 | 52 | 101 | ||||||||||||||||||||||||||||||||
933699 | 933699 | MA | Suffolk | school | 2502790 | 35 | Boston | 250279000282 | 350537 | Madison Park High | Vocational Education School | No | 3 | 09 | 12 | 2016 | grade_11 | 13 | 90 | 117 | 5 | 1 | 1 | 7 | 131 | 103 | 234 | 13 | 90 | 117 | 5 | 1 | 1 | 7 | 131 | 103 | 234 | |||||||||||||||||||||||||||||||||
936209 | 936209 | MA | Middlesex | school | 2507020 | 160 | Lowell | 250702001041 | 1600505 | Lowell High | Regular School | No | 3 | 09 | 12 | 2016 | grade_11 | 274 | 90 | 165 | 1 | 247 | 0 | 6 | 394 | 389 | 783 | 274 | 90 | 165 | 1 | 247 | 0 | 6 | 394 | 389 | 783 | |||||||||||||||||||||||||||||||||
1123339 | 1123339 | MA | Suffolk | school | 2502790 | 35 | Boston | 250279000204 | 350545 | Boston Latin Academy | Regular School | No | High | 07 | 12 | 2017 | grade_11 | 82 | 90 | 56 | 1 | 68 | 1 | 5 | 127 | 176 | 303 | 82 | 90 | 56 | 1 | 68 | 1 | 5 | 127 | 176 | 303 | |||||||||||||||||||||||||||||||||
1367090 | 1367090 | MA | Middlesex | school | 2504770 | 93 | Everett | 250477000634 | 930505 | Everett High | Regular School | No | High | 09 | 12 | 2020 | grade_11 | 96 | 90 | 221 | 0 | 24 | 0 | 11 | 233 | 209 | * | 442.0 | 96 | 90 | 221 | 0 | 24 | 0 | 11 | 233 | 209 | 442 | ||||||||||||||||||||||||||||||||
1677471 | 1677471 | MA | Norfolk | school | 2509930 | 244 | Randolph | 250993001596 | 2440505 | Randolph - Randolph High | Regular School | No | High | 09 | 12 | 2021 | grade_11 | 15 | 90 | 28 | 0 | 31 | 0 | 2 | 105 | 61 | * | 166.0 | 15 | 90 | 28 | 0 | 31 | 0 | 2 | 105 | 61 | 166 | ||||||||||||||||||||||||||||||||
2046377 | 2046377 | MA | Bristol | school | 2511520 | 293 | Taunton | 251152001915 | 2930505 | Taunton High | Regular School | No | High | 08 | 12 | 2019 | grade_11 | 311 | 90 | 63 | 0 | 8 | 2 | 15 | 224 | 264 | 489.0 | 311 | 90 | 63 | 0 | 8 | 2 | 15 | 224 | 264 | 489 | |||||||||||||||||||||||||||||||||
736911 | 736911 | MA | Suffolk | school | 2502790 | 35 | Boston | 250279002674 | 350655 | Lyon Upper 9-12 | Regular School | No | 3 | 09 | 12 | 2015 | grade_11 | 13 | 9 | 11 | 0 | 1 | 0 | 2 | 20 | 16 | 36 | 13 | 9 | 11 | 0 | 1 | 0 | 2 | 20 | 16 | 36 | |||||||||||||||||||||||||||||||||
739816 | 739816 | MA | Middlesex | school | 2507560 | 176 | Medford | 250756001174 | 1760605 | Medford Vocational Technical High | Vocational Education School | No | 3 | 09 | 12 | 2015 | grade_11 | 51 | 9 | 8 | 0 | 2 | 0 | 1 | 50 | 21 | 71 | 51 | 9 | 8 | 0 | 2 | 0 | 1 | 50 | 21 | 71 | |||||||||||||||||||||||||||||||||
741209 | 741209 | MA | Middlesex | school | 2509990 | 246 | Reading | 250999001611 | 2460505 | Reading Memorial High | Regular School | No | 3 | 09 | 12 | 2015 | grade_11 | 286 | 9 | 5 | 0 | 13 | 0 | 6 | 175 | 144 | 319 | 286 | 9 | 5 | 0 | 13 | 0 | 6 | 175 | 144 | 319 | |||||||||||||||||||||||||||||||||
742543 | 742543 | MA | Middlesex | school | 2512210 | 315 | Wayland | 251221002010 | 3150505 | Wayland High School | Regular School | No | 3 | 09 | 12 | 2015 | grade_11 | 170 | 9 | 12 | 0 | 32 | 0 | 9 | 109 | 123 | 232 | 170 | 9 | 12 | 0 | 32 | 0 | 9 | 109 | 123 | 232 | |||||||||||||||||||||||||||||||||
743511 | 743511 | MA | Middlesex | school | 2500085 | 430 | Advanced Math and Science Academy Charter (District) | 250008501984 | 4300305 | Advanced Math and Science Academy Charter School | Regular School | Yes | 4 | 06 | 12 | 2015 | grade_11 | 103 | 9 | 12 | 0 | 57 | 0 | 5 | 98 | 88 | 186 | 103 | 9 | 12 | 0 | 57 | 0 | 5 | 98 | 88 | 186 | |||||||||||||||||||||||||||||||||
744264 | 744264 | MA | Barnstable | school | 2504560 | 660 | Nauset | 250456000610 | 6600505 | Nauset Regional High | Regular School | No | 3 | 09 | 12 | 2015 | grade_11 | 220 | 9 | 6 | 0 | 6 | 0 | 3 | 124 | 120 | 244 | 220 | 9 | 6 | 0 | 6 | 0 | 3 | 124 | 120 | 244 | |||||||||||||||||||||||||||||||||
745045 | 745045 | MA | Barnstable | school | 2503310 | 815 | Cape Cod Regional Vocational Technical | 250331002264 | 8150605 | Cape Cod Region Vocational Technical | Vocational Education School | No | 3 | 09 | 12 | 2015 | grade_11 | 135 | 9 | 14 | 1 | 1 | 0 | 5 | 93 | 72 | 165 | 135 | 9 | 14 | 1 | 1 | 0 | 5 | 93 | 72 | 165 | |||||||||||||||||||||||||||||||||
745058 | 745058 | MA | Bristol | school | 2505485 | 821 | Greater Fall River Regional Vocational Technical | 250548502269 | 8210605 | Diman Regional Vocational Technical High | Vocational Education School | No | 3 | 09 | 12 | 2015 | grade_11 | 292 | 9 | 18 | 3 | 9 | 1 | 13 | 186 | 159 | 345 | 292 | 9 | 18 | 3 | 9 | 1 | 13 | 186 | 159 | 345 | |||||||||||||||||||||||||||||||||
936661 | 936661 | MA | Middlesex | school | 2507560 | 176 | Medford | 250756001174 | 1760605 | Medford Vocational Technical High | Vocational Education School | No | 3 | 09 | 12 | 2016 | grade_11 | 35 | 9 | 2 | 0 | 0 | 0 | 1 | 34 | 13 | 47 | 35 | 9 | 2 | 0 | 0 | 0 | 1 | 34 | 13 | 47 | |||||||||||||||||||||||||||||||||
936804 | 936804 | MA | Worcester | school | 2507860 | 185 | Milford | 250786001239 | 1850505 | Milford High | Regular School | No | 3 | 08 | 12 | 2016 | grade_11 | 210 | 9 | 46 | 0 | 2 | 0 | 2 | 144 | 125 | 269 | 210 | 9 | 46 | 0 | 2 | 0 | 2 | 144 | 125 | 269 | |||||||||||||||||||||||||||||||||
939211 | 939211 | MA | Norfolk | school | 2511970 | 307 | Walpole | 251197001964 | 3070505 | Walpole High | Regular School | No | 3 | 09 | 12 | 2016 | grade_11 | 260 | 9 | 3 | 1 | 8 | 0 | 3 | 143 | 141 | 284 | 260 | 9 | 3 | 1 | 8 | 0 | 3 | 143 | 141 | 284 | |||||||||||||||||||||||||||||||||
939298 | 939298 | MA | Plymouth | school | 2512060 | 310 | Wareham | 251206001991 | 3100505 | Wareham Senior High | Regular School | No | 3 | 09 | 12 | 2016 | grade_11 | 84 | 9 | 12 | 1 | 1 | 0 | 15 | 58 | 64 | 122 | 84 | 9 | 12 | 1 | 1 | 0 | 15 | 58 | 64 | 122 | |||||||||||||||||||||||||||||||||
939327 | 939327 | MA | Middlesex | school | 2512180 | 314 | Watertown | 251218002005 | 3140505 | Watertown High | Regular School | No | 3 | 09 | 12 | 2016 | grade_11 | 129 | 9 | 19 | 0 | 17 | 1 | 4 | 94 | 85 | 179 | 129 | 9 | 19 | 0 | 17 | 1 | 4 | 94 | 85 | 179 | |||||||||||||||||||||||||||||||||
941866 | 941866 | MA | Barnstable | school | 2503310 | 815 | Cape Cod Regional Vocational Technical | 250331002264 | 8150605 | Cape Cod Region Vocational Technical | Vocational Education School | No | 3 | 09 | 12 | 2016 | grade_11 | 116 | 9 | 13 | 5 | 1 | 0 | 4 | 89 | 59 | 148 | 116 | 9 | 13 | 5 | 1 | 0 | 4 | 89 | 59 | 148 | |||||||||||||||||||||||||||||||||
1123332 | 1123332 | MA | Suffolk | school | 2502790 | 35 | Boston | 250279000837 | 350543 | Greater Egleston Community High School | Regular School | No | High | 09 | 12 | 2017 | grade_11 | 1 | 9 | 30 | 0 | 0 | 0 | 1 | 28 | 13 | 41 | 1 | 9 | 30 | 0 | 0 | 0 | 1 | 28 | 13 | 41 | |||||||||||||||||||||||||||||||||
1124199 | 1124199 | MA | Hampden | school | 2503660 | 61 | Chicopee | 250366000496 | 610505 | Chicopee High | Regular School | No | High | 09 | 12 | 2017 | grade_11 | 146 | 9 | 87 | 0 | 9 | 1 | 3 | 115 | 140 | 255 | 146 | 9 | 87 | 0 | 9 | 1 | 3 | 115 | 140 | 255 | |||||||||||||||||||||||||||||||||
1124864 | 1124864 | MA | Barnstable | school | 2504860 | 96 | Falmouth | 250486000686 | 960505 | Falmouth High | Regular School | No | High | 09 | 12 | 2017 | grade_11 | 158 | 9 | 9 | 1 | 6 | 0 | 14 | 103 | 94 | 197 | 158 | 9 | 9 | 1 | 6 | 0 | 14 | 103 | 94 | 197 | |||||||||||||||||||||||||||||||||
1126142 | 1126142 | MA | Hampden | school | 2506990 | 159 | Longmeadow | 250699001020 | 1590505 | Longmeadow High | Regular School | No | High | 09 | 12 | 2017 | grade_11 | 186 | 9 | 9 | 0 | 20 | 0 | 2 | 115 | 111 | 226 | 186 | 9 | 9 | 0 | 20 | 0 | 2 | 115 | 111 | 226 | |||||||||||||||||||||||||||||||||
1129990 | 1129990 | MA | Plymouth | school | 2512060 | 310 | Wareham | 251206001991 | 3100505 | Wareham Senior High | Regular School | No | High | 09 | 12 | 2017 | grade_11 | 87 | 9 | 10 | 2 | 2 | 0 | 10 | 56 | 64 | 120 | 87 | 9 | 10 | 2 | 2 | 0 | 10 | 56 | 64 | 120 | |||||||||||||||||||||||||||||||||
1132989 | 1132989 | MA | Bristol | school | 2503080 | 810 | Bristol-Plymouth Regional Vocational Technical | 250308002262 | 8100605 | Bristol-Plymouth Vocational Technical | Career and Technical School | No | High | 09 | 12 | 2017 | grade_11 | 267 | 9 | 21 | 2 | 4 | 0 | 8 | 172 | 138 | 311 | 267 | 9 | 21 | 2 | 4 | 0 | 8 | 172 | 138 | 311 | |||||||||||||||||||||||||||||||||
1133034 | 1133034 | MA | Middlesex | school | 2507985 | 830 | Minuteman Regional Vocational Technical | 250798501264 | 8300605 | Minuteman Regional High | Career and Technical School | No | High | 09 | 12 | 2017 | grade_11 | 110 | 9 | 16 | 0 | 6 | 0 | 2 | 91 | 52 | 143 | 110 | 9 | 16 | 0 | 6 | 0 | 2 | 91 | 52 | 143 | |||||||||||||||||||||||||||||||||
1365181 | 1365181 | MA | Middlesex | school | 2502490 | 26 | Belmont | 250249000143 | 260505 | Belmont High | Regular School | No | High | 09 | 12 | 2020 | grade_11 | 220 | 9 | 12 | 0 | 64 | 0 | 23 | 168 | 160 | * | 328.0 | 220 | 9 | 12 | 0 | 64 | 0 | 23 | 168 | 160 | 328 | ||||||||||||||||||||||||||||||||
1367440 | 1367440 | MA | Norfolk | school | 2505010 | 101 | Franklin | 250501000737 | 1010505 | Franklin High | Regular School | No | High | 09 | 12 | 2020 | grade_11 | 380 | 9 | 13 | 2 | 33 | 0 | 10 | 235 | 212 | * | 447.0 | 380 | 9 | 13 | 2 | 33 | 0 | 10 | 235 | 212 | 447 | ||||||||||||||||||||||||||||||||
1368749 | 1368749 | MA | Middlesex | school | 2507320 | 170 | Marlborough | 250732001133 | 1700505 | Marlborough High | Regular School | No | High | 09 | 12 | 2020 | grade_11 | 104 | 9 | 138 | 0 | 3 | 0 | 6 | 127 | 133 | * | 260.0 | 104 | 9 | 138 | 0 | 3 | 0 | 6 | 127 | 133 | 260 | ||||||||||||||||||||||||||||||||
1369587 | 1369587 | MA | Essex | school | 2508700 | 211 | North Andover | 250870001397 | 2110505 | North Andover High | Regular School | No | High | 09 | 12 | 2020 | grade_11 | 290 | 9 | 37 | 0 | 29 | 0 | 5 | 191 | 179 | * | 370.0 | 290 | 9 | 37 | 0 | 29 | 0 | 5 | 191 | 179 | 370 | ||||||||||||||||||||||||||||||||
1370265 | 1370265 | MA | Middlesex | school | 2509990 | 246 | Reading | 250999001611 | 2460505 | Reading Memorial High | Regular School | No | High | 09 | 12 | 2020 | grade_11 | 293 | 9 | 8 | 1 | 15 | 0 | 5 | 170 | 160 | * | 331.0 | 293 | 9 | 8 | 1 | 15 | 0 | 5 | 170 | 160 | 331 | ||||||||||||||||||||||||||||||||
1370483 | 1370483 | MA | Essex | school | 2510500 | 262 | Saugus | 251050001684 | 2620505 | Saugus High | Regular School | No | High | 09 | 12 | 2020 | grade_11 | 128 | 9 | 36 | 2 | 6 | 0 | 2 | 102 | 80 | * | 183.0 | 128 | 9 | 36 | 2 | 6 | 0 | 2 | 102 | 80 | 183 | ||||||||||||||||||||||||||||||||
1371324 | 1371324 | MA | Middlesex | school | 2511580 | 295 | Tewksbury | 251158001926 | 2950505 | Tewksbury Memorial High | Regular School | No | High | 09 | 12 | 2020 | grade_11 | 182 | 9 | 12 | 0 | 8 | 0 | 2 | 94 | 119 | * | 213.0 | 182 | 9 | 12 | 0 | 8 | 0 | 2 | 94 | 119 | 213 | ||||||||||||||||||||||||||||||||
1371455 | 1371455 | MA | Norfolk | school | 2511970 | 307 | Walpole | 251197001964 | 3070505 | Walpole High | Regular School | No | High | 09 | 12 | 2020 | grade_11 | 224 | 9 | 16 | 1 | 15 | 0 | 4 | 139 | 130 | * | 269.0 | 224 | 9 | 16 | 1 | 15 | 0 | 4 | 139 | 130 | 269 | ||||||||||||||||||||||||||||||||
1371690 | 1371690 | MA | Worcester | school | 2512600 | 321 | Westborough | 251260002059 | 3210505 | Westborough High | Regular School | No | High | 09 | 12 | 2020 | grade_11 | 203 | 9 | 20 | 1 | 75 | 1 | 9 | 165 | 153 | * | 318.0 | 203 | 9 | 20 | 1 | 75 | 1 | 9 | 165 | 153 | 318 | ||||||||||||||||||||||||||||||||
1372382 | 1372382 | MA | Worcester | school | 2513230 | 348 | Worcester | 251323002121 | 3480350 | Claremont Academy | Regular School | No | High | 07 | 12 | 2020 | grade_11 | 6 | 9 | 53 | 0 | 5 | 0 | 1 | 45 | 29 | * | 74.0 | 6 | 9 | 53 | 0 | 5 | 0 | 1 | 45 | 29 | 74 | ||||||||||||||||||||||||||||||||
1372458 | 1372458 | MA | Suffolk | school | 2500075 | 410 | Excel Academy Charter (District) | 250007502084 | 4100205 | Excel Academy Charter School | Regular School | Yes | High | 05 | 12 | 2020 | grade_11 | 14 | 9 | 144 | 1 | 0 | 0 | 0 | 84 | 84 | * | 168.0 | 14 | 9 | 144 | 1 | 0 | 0 | 0 | 84 | 84 | 168 | ||||||||||||||||||||||||||||||||
1373489 | 1373489 | MA | Norfolk | school | 2506510 | 690 | King Philip | 250651000940 | 6900505 | King Philip Regional High | Regular School | No | High | 09 | 12 | 2020 | grade_11 | 283 | 9 | 8 | 0 | 8 | 0 | 6 | 155 | 159 | * | 314.0 | 283 | 9 | 8 | 0 | 8 | 0 | 6 | 155 | 159 | 314 | ||||||||||||||||||||||||||||||||
1374119 | 1374119 | MA | Middlesex | school | 2511060 | 829 | South Middlesex Regional Vocational Technical | 251106002291 | 8290605 | Joseph P Keefe Technical High School | Career and Technical School | No | High | 09 | 12 | 2020 | grade_11 | 96 | 9 | 77 | 3 | 1 | 0 | 4 | 116 | 74 | * | 190.0 | 96 | 9 | 77 | 3 | 1 | 0 | 4 | 116 | 74 | 190 | ||||||||||||||||||||||||||||||||
1672150 | 1672150 | MA | Essex | school | 2501950 | 9 | Andover | 250195000045 | 90505 | Andover - Andover High | Regular School | No | High | 09 | 12 | 2021 | grade_11 | 275 | 9 | 31 | 2 | 85 | 0 | 6 | 193 | 215 | * | 408.0 | 275 | 9 | 31 | 2 | 85 | 0 | 6 | 193 | 215 | 408 | ||||||||||||||||||||||||||||||||
1672403 | 1672403 | MA | Middlesex | school | 2502490 | 26 | Belmont | 250249000143 | 260505 | Belmont - Belmont High | Regular School | No | High | 09 | 12 | 2021 | grade_11 | 229 | 9 | 17 | 0 | 59 | 0 | 21 | 163 | 172 | * | 335.0 | 229 | 9 | 17 | 0 | 59 | 0 | 21 | 163 | 172 | 335 | ||||||||||||||||||||||||||||||||
1674475 | 1674475 | MA | Barnstable | school | 2504860 | 96 | Falmouth | 250486000686 | 960505 | Falmouth - Falmouth High | Regular School | No | High | 09 | 12 | 2021 | grade_11 | 148 | 9 | 9 | 1 | 6 | 0 | 12 | 92 | 92 | * | 185.0 | 148 | 9 | 9 | 1 | 6 | 0 | 12 | 92 | 92 | 185 | ||||||||||||||||||||||||||||||||
1675999 | 1675999 | MA | Middlesex | school | 2507320 | 170 | Marlborough | 250732001133 | 1700505 | Marlborough - Marlborough High | Regular School | No | High | 09 | 12 | 2021 | grade_11 | 94 | 9 | 135 | 0 | 4 | 0 | 6 | 131 | 117 | * | 248.0 | 94 | 9 | 135 | 0 | 4 | 0 | 6 | 131 | 117 | 248 | ||||||||||||||||||||||||||||||||
1677735 | 1677735 | MA | Essex | school | 2510500 | 262 | Saugus | 251050001684 | 2620505 | Saugus - Saugus High | Regular School | No | High | 09 | 12 | 2021 | grade_11 | 134 | 9 | 25 | 1 | 6 | 0 | 1 | 83 | 93 | * | 176.0 | 134 | 9 | 25 | 1 | 6 | 0 | 1 | 83 | 93 | 176 | ||||||||||||||||||||||||||||||||
1678328 | 1678328 | MA | Hampden | school | 2511130 | 281 | Springfield | 251113002724 | 2810570 | Springfield - Springfield High School | Regular School | No | High | 09 | 12 | 2021 | grade_11 | 5 | 9 | 37 | 0 | 0 | 0 | 0 | 30 | 21 | * | 51.0 | 5 | 9 | 37 | 0 | 0 | 0 | 0 | 30 | 21 | 51 | ||||||||||||||||||||||||||||||||
1678487 | 1678487 | MA | Essex | school | 2511430 | 291 | Swampscott | 251143001887 | 2910505 | Swampscott - Swampscott High | Regular School | No | High | 09 | 12 | 2021 | grade_11 | 146 | 9 | 27 | 0 | 7 | 0 | 2 | 87 | 104 | * | 191.0 | 146 | 9 | 27 | 0 | 7 | 0 | 2 | 87 | 104 | 191 | ||||||||||||||||||||||||||||||||
1680734 | 1680734 | MA | Hampden | school | 2505730 | 680 | Hampden-Wilbraham | 250573000824 | 6800505 | Hampden-Wilbraham - Minnechaug Regional High | Regular School | No | High | 09 | 12 | 2021 | grade_11 | 226 | 9 | 22 | 2 | 10 | 0 | 7 | 127 | 149 | * | 276.0 | 226 | 9 | 22 | 2 | 10 | 0 | 7 | 127 | 149 | 276 | ||||||||||||||||||||||||||||||||
1681367 | 1681367 | MA | Middlesex | school | 2511060 | 829 | South Middlesex Regional Vocational Technical | 251106002291 | 8290605 | South Middlesex Regional Vocational Technical - Joseph P Keefe Technical High School | Career and Technical School | No | High | 09 | 12 | 2021 | grade_11 | 96 | 9 | 92 | 5 | 2 | 0 | 8 | 127 | 85 | * | 212.0 | 96 | 9 | 92 | 5 | 2 | 0 | 8 | 127 | 85 | 212 | ||||||||||||||||||||||||||||||||
2039954 | 2039954 | MA | Essex | school | 2501950 | 9 | Andover | 250195000045 | 90505 | Andover High | Regular School | No | High | 09 | 12 | 2019 | grade_11 | 319 | 9 | 26 | 0 | 67 | 0 | 9 | 218 | 212 | 430.0 | 319 | 9 | 26 | 0 | 67 | 0 | 9 | 218 | 212 | 430 | |||||||||||||||||||||||||||||||||
2042943 | 2042943 | MA | Hampden | school | 2506270 | 137 | Holyoke | 250627000900 | 1370505 | Holyoke High | Regular School | No | High | 09 | 12 | 2019 | grade_11 | 63 | 9 | 322 | 0 | 5 | 0 | 6 | 195 | 210 | 405.0 | 63 | 9 | 322 | 0 | 5 | 0 | 6 | 195 | 210 | 405 | |||||||||||||||||||||||||||||||||
2045338 | 2045338 | MA | Middlesex | school | 2509990 | 246 | Reading | 250999001611 | 2460505 | Reading Memorial High | Regular School | No | High | 09 | 12 | 2019 | grade_11 | 269 | 9 | 5 | 1 | 20 | 0 | 3 | 139 | 168 | 307.0 | 269 | 9 | 5 | 1 | 20 | 0 | 3 | 139 | 168 | 307 | |||||||||||||||||||||||||||||||||
2046486 | 2046486 | MA | Middlesex | school | 2511910 | 305 | Wakefield | 251191001951 | 3050505 | Wakefield Memorial High | Regular School | No | High | 09 | 12 | 2019 | grade_11 | 225 | 9 | 12 | 0 | 9 | 0 | 7 | 127 | 135 | 262.0 | 225 | 9 | 12 | 0 | 9 | 0 | 7 | 127 | 135 | 262 | |||||||||||||||||||||||||||||||||
2048376 | 2048376 | MA | Worcester | school | 2504360 | 658 | Dudley-Charlton Reg | 250436000591 | 6580505 | Shepherd Hill Regional High | Regular School | No | High | 09 | 12 | 2019 | grade_11 | 231 | 9 | 22 | 2 | 4 | 0 | 5 | 133 | 139 | 273.0 | 231 | 9 | 22 | 2 | 4 | 0 | 5 | 133 | 139 | 273 | |||||||||||||||||||||||||||||||||
2048909 | 2048909 | MA | Plymouth | school | 2510830 | 760 | Silver Lake | 251083001722 | 7600505 | Silver Lake Regional High | Regular School | No | High | 09 | 12 | 2019 | grade_11 | 283 | 9 | 3 | 1 | 5 | 1 | 3 | 159 | 146 | 305.0 | 283 | 9 | 3 | 1 | 5 | 1 | 3 | 159 | 146 | 305 | |||||||||||||||||||||||||||||||||
2049307 | 2049307 | MA | Hampden | school | 2500555 | 3508 | Phoenix Academy Public Charter High School Springfield (District) | 250055502821 | 35080505 | Phoenix Academy Public Charter High School Springfield | Regular School | Yes | High | 09 | 12 | 2019 | grade_11 | 2 | 9 | 10 | 0 | 0 | 0 | 1 | 14 | 8 | 22.0 | 2 | 9 | 10 | 0 | 0 | 0 | 1 | 14 | 8 | 22 | |||||||||||||||||||||||||||||||||
2230667 | 2230667 | MA | Middlesex | school | 2503240 | 48 | Burlington | 250324000426 | 480505 | Burlington: Burlington High | Regular School | No | High | 09 | 12 | 2018 | grade_11 | 183 | 9 | 14 | 1 | 35 | 0 | 9 | 112 | 139 | 251.0 | 183 | 9 | 14 | 1 | 35 | 0 | 9 | 112 | 139 | 251 | |||||||||||||||||||||||||||||||||
2231288 | 2231288 | MA | Middlesex | school | 2504320 | 79 | Dracut | 250432000579 | 790505 | Dracut: Dracut Senior High | Regular School | No | High | 09 | 12 | 2018 | grade_11 | 167 | 9 | 13 | 0 | 15 | 1 | 4 | 101 | 108 | 209.0 | 167 | 9 | 13 | 0 | 15 | 1 | 4 | 101 | 108 | 209 | |||||||||||||||||||||||||||||||||
2231783 | 2231783 | MA | Norfolk | school | 2504950 | 99 | Foxborough | 250495000708 | 990505 | Foxborough: Foxborough High | Regular School | No | High | 09 | 12 | 2018 | grade_11 | 186 | 9 | 5 | 0 | 6 | 0 | 2 | 119 | 89 | 208.0 | 186 | 9 | 5 | 0 | 6 | 0 | 2 | 119 | 89 | 208 | |||||||||||||||||||||||||||||||||
2231924 | 2231924 | MA | Norfolk | school | 2505010 | 101 | Franklin | 250501000737 | 1010505 | Franklin: Franklin High | Regular School | No | High | 09 | 12 | 2018 | grade_11 | 368 | 9 | 8 | 1 | 27 | 2 | 8 | 203 | 220 | 423.0 | 368 | 9 | 8 | 1 | 27 | 2 | 8 | 203 | 220 | 423 | |||||||||||||||||||||||||||||||||
2232816 | 2232816 | MA | Worcester | school | 2506780 | 153 | Leominster | 250678002272 | 1530605 | Leominster: Center For Technical Education Innovation | Career and Technical School | No | High | 09 | 12 | 2018 | grade_11 | 80 | 9 | 37 | 0 | 5 | 0 | 5 | 101 | 35 | 136.0 | 80 | 9 | 37 | 0 | 5 | 0 | 5 | 101 | 35 | 136 | |||||||||||||||||||||||||||||||||
2235298 | 2235298 | MA | Middlesex | school | 2509990 | 246 | Reading | 250999001611 | 2460505 | Reading: Reading Memorial High | Regular School | No | High | 09 | 12 | 2018 | grade_11 | 299 | 9 | 7 | 0 | 15 | 0 | 1 | 165 | 166 | 331.0 | 299 | 9 | 7 | 0 | 15 | 0 | 1 | 165 | 166 | 331 | |||||||||||||||||||||||||||||||||
2235716 | 2235716 | MA | Worcester | school | 2510770 | 271 | Shrewsbury | 251077001717 | 2710505 | Shrewsbury: Shrewsbury Sr High | Regular School | No | High | 09 | 12 | 2018 | grade_11 | 285 | 9 | 34 | 0 | 91 | 1 | 9 | 191 | 237 | 429.0 | 285 | 9 | 34 | 0 | 91 | 1 | 9 | 191 | 237 | 429 | |||||||||||||||||||||||||||||||||
2236433 | 2236433 | MA | Essex | school | 2511430 | 291 | Swampscott | 251143001887 | 2910505 | Swampscott: Swampscott High | Regular School | No | High | 09 | 12 | 2018 | grade_11 | 148 | 9 | 10 | 0 | 6 | 1 | 4 | 88 | 90 | 178.0 | 148 | 9 | 10 | 0 | 6 | 1 | 4 | 88 | 90 | 178 | |||||||||||||||||||||||||||||||||
2238353 | 2238353 | MA | Hampshire | school | 2500044 | 479 | Pioneer Valley Performing Arts Charter Public (District) | 250004400816 | 4790505 | Pioneer Valley Performing Arts Charter Public (District): Pioneer Valley Performing Arts Charter Public School | Regular School | Yes | High | 07 | 12 | 2018 | grade_11 | 42 | 9 | 7 | 0 | 1 | 0 | 8 | 18 | 49 | 67.0 | 42 | 9 | 7 | 0 | 1 | 0 | 8 | 18 | 49 | 67 | |||||||||||||||||||||||||||||||||
2239844 | 2239844 | MA | Middlesex | school | 2511060 | 829 | South Middlesex Regional Vocational Technical | 251106002291 | 8290605 | South Middlesex Regional Vocational Technical: Joseph P Keefe Technical High School | Career and Technical School | No | High | 09 | 12 | 2018 | grade_11 | 78 | 9 | 83 | 2 | 0 | 0 | 5 | 115 | 62 | 177.0 | 78 | 9 | 83 | 2 | 0 | 0 | 5 | 115 | 62 | 177 | |||||||||||||||||||||||||||||||||
741167 | 741167 | MA | Norfolk | school | 2509930 | 244 | Randolph | 250993001596 | 2440505 | Randolph High | Regular School | No | 3 | 09 | 12 | 2015 | grade_11 | 22 | 89 | 20 | 1 | 29 | 0 | 3 | 100 | 64 | 164 | 22 | 89 | 20 | 1 | 29 | 0 | 3 | 100 | 64 | 164 | |||||||||||||||||||||||||||||||||
2044412 | 2044412 | MA | Bristol | school | 2508430 | 201 | New Bedford | 250843001336 | 2010505 | New Bedford High | Regular School | No | High | 09 | 12 | 2019 | grade_11 | 159 | 89 | 261 | 4 | 7 | 1 | 21 | 297 | 245 | 542.0 | 159 | 89 | 261 | 4 | 7 | 1 | 21 | 297 | 245 | 542 | |||||||||||||||||||||||||||||||||
2235248 | 2235248 | MA | Norfolk | school | 2509930 | 244 | Randolph | 250993001596 | 2440505 | Randolph: Randolph High | Regular School | No | High | 09 | 12 | 2018 | grade_11 | 10 | 89 | 18 | 1 | 30 | 0 | 7 | 78 | 77 | 155.0 | 10 | 89 | 18 | 1 | 30 | 0 | 7 | 78 | 77 | 155 | |||||||||||||||||||||||||||||||||
1128427 | 1128427 | MA | Norfolk | school | 2509930 | 244 | Randolph | 250993001596 | 2440505 | Randolph High | Regular School | No | High | 09 | 12 | 2017 | grade_11 | 18 | 88 | 17 | 1 | 39 | 1 | 8 | 96 | 76 | 172 | 18 | 88 | 17 | 1 | 39 | 1 | 8 | 96 | 76 | 172 | |||||||||||||||||||||||||||||||||
1129441 | 1129441 | MA | Hampden | school | 2511130 | 281 | Springfield | 251113002293 | 2810620 | Roger L. Putnam Vocational Technical Academy | Career and Technical School | No | High | 09 | 12 | 2017 | grade_11 | 52 | 88 | 207 | 0 | 5 | 0 | 6 | 163 | 195 | 358 | 52 | 88 | 207 | 0 | 5 | 0 | 6 | 163 | 195 | 358 | |||||||||||||||||||||||||||||||||
2041042 | 2041042 | MA | Suffolk | school | 2502790 | 35 | Boston | 250279000205 | 350575 | O'Bryant School Math/Science | Regular School | No | High | 07 | 12 | 2019 | grade_11 | 18 | 88 | 76 | 1 | 68 | 0 | 8 | 101 | 158 | 259.0 | 18 | 88 | 76 | 1 | 68 | 0 | 8 | 101 | 158 | 259 | |||||||||||||||||||||||||||||||||
1123389 | 1123389 | MA | Suffolk | school | 2502790 | 35 | Boston | 250279001902 | 350581 | Community Academy of Science and Health | Regular School | No | High | 09 | 12 | 2017 | grade_11 | 3 | 87 | 23 | 0 | 3 | 0 | 0 | 68 | 48 | 116 | 3 | 87 | 23 | 0 | 3 | 0 | 0 | 68 | 48 | 116 | |||||||||||||||||||||||||||||||||
1129402 | 1129402 | MA | Hampden | school | 2511130 | 281 | Springfield | 251113002444 | 2810500 | Springfield Central High | Regular School | No | High | 09 | 12 | 2017 | grade_11 | 88 | 87 | 174 | 0 | 25 | 0 | 4 | 192 | 186 | 378 | 88 | 87 | 174 | 0 | 25 | 0 | 4 | 192 | 186 | 378 | |||||||||||||||||||||||||||||||||
2230077 | 2230077 | MA | Suffolk | school | 2502790 | 35 | Boston | 250279000208 | 350505 | Boston: Brighton High | Regular School | No | High | 09 | 12 | 2018 | grade_11 | 12 | 87 | 92 | 1 | 8 | 0 | 4 | 117 | 87 | 204.0 | 12 | 87 | 92 | 1 | 8 | 0 | 4 | 117 | 87 | 204 |
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]);