enrollments
Data source: Big Local News · About: Big Local
2,748 rows where grade = "grade_12" 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1368413 | 1368413 | MA | Middlesex | school | 2507020 | 160 | Lowell | 250702001041 | 1600505 | Lowell High | Regular School | No | High | 09 | 12 | 2020 | grade_12 | 215 | 99 | 177 | 0 | 232 | 1 | 17 | 367 | 374 | * | 741.0 | 215 | 99 | 177 | 0 | 232 | 1 | 17 | 367 | 374 | 741 | ||||||||||||||||||||||||||||||||
1679786 | 1679786 | MA | Suffolk | school | 2500049 | 424 | Boston Day and Evening Academy Charter (District) | 250004901245 | 4240505 | Boston Day and Evening Academy Charter (District) - Boston Day and Evening Academy Charter School | Regular School | Yes | High | 09 | 12 | 2021 | grade_12 | 10 | 99 | 89 | 1 | 2 | 0 | 4 | 99 | 106 | * | 205.0 | 10 | 99 | 89 | 1 | 2 | 0 | 4 | 99 | 106 | 205 | ||||||||||||||||||||||||||||||||
2040968 | 2040968 | MA | Suffolk | school | 2502790 | 35 | Boston | 250279000261 | 350525 | Jeremiah E Burke High | Regular School | No | High | 09 | 12 | 2019 | grade_12 | 1 | 99 | 18 | 0 | 1 | 0 | 1 | 64 | 56 | 120.0 | 1 | 99 | 18 | 0 | 1 | 0 | 1 | 64 | 56 | 120 | |||||||||||||||||||||||||||||||||
933791 | 933791 | MA | Suffolk | school | 2502790 | 35 | Boston | 250279002725 | 350657 | TechBoston Academy | Regular School | No | 4 | 06 | 12 | 2016 | grade_12 | 5 | 97 | 20 | 2 | 7 | 0 | 4 | 82 | 53 | 135 | 5 | 97 | 20 | 2 | 7 | 0 | 4 | 82 | 53 | 135 | |||||||||||||||||||||||||||||||||
937997 | 937997 | MA | Norfolk | school | 2509930 | 244 | Randolph | 250993001596 | 2440505 | Randolph High | Regular School | No | 3 | 09 | 12 | 2016 | grade_12 | 24 | 96 | 22 | 1 | 32 | 0 | 3 | 107 | 71 | 178 | 24 | 96 | 22 | 1 | 32 | 0 | 3 | 107 | 71 | 178 | |||||||||||||||||||||||||||||||||
938810 | 938810 | MA | Hampden | school | 2511130 | 281 | Springfield | 251113002444 | 2810500 | Springfield Central High | Regular School | No | 3 | 09 | 12 | 2016 | grade_12 | 85 | 96 | 225 | 0 | 27 | 0 | 3 | 221 | 215 | 436 | 85 | 96 | 225 | 0 | 27 | 0 | 3 | 221 | 215 | 436 | |||||||||||||||||||||||||||||||||
1123419 | 1123419 | MA | Suffolk | school | 2502790 | 35 | Boston | 250279002725 | 350657 | TechBoston Academy | Regular School | No | Other | 06 | 12 | 2017 | grade_12 | 6 | 96 | 23 | 0 | 3 | 0 | 2 | 71 | 59 | 130 | 6 | 96 | 23 | 0 | 3 | 0 | 2 | 71 | 59 | 130 | |||||||||||||||||||||||||||||||||
2236221 | 2236221 | MA | Hampden | school | 2511130 | 281 | Springfield | 251113002444 | 2810500 | Springfield: Springfield Central High | Regular School | No | High | 09 | 12 | 2018 | grade_12 | 82 | 96 | 195 | 0 | 26 | 0 | 5 | 212 | 192 | 404.0 | 82 | 96 | 195 | 0 | 26 | 0 | 5 | 212 | 192 | 404 | |||||||||||||||||||||||||||||||||
739609 | 739609 | MA | Middlesex | school | 2507170 | 165 | Malden | 250717001106 | 1650505 | Malden High | Regular School | No | 3 | 09 | 12 | 2015 | grade_12 | 148 | 95 | 97 | 2 | 114 | 2 | 16 | 246 | 228 | 474 | 148 | 95 | 97 | 2 | 114 | 2 | 16 | 246 | 228 | 474 | |||||||||||||||||||||||||||||||||
1678555 | 1678555 | MA | Bristol | school | 2511520 | 293 | Taunton | 251152001915 | 2930505 | Taunton - Taunton High | Regular School | No | High | 08 | 12 | 2021 | grade_12 | 276 | 94 | 60 | 0 | 5 | 0 | 15 | 222 | 228 | * | 450.0 | 276 | 94 | 60 | 0 | 5 | 0 | 15 | 222 | 228 | 450 | ||||||||||||||||||||||||||||||||
2233417 | 2233417 | MA | Middlesex | school | 2507170 | 165 | Malden | 250717001106 | 1650505 | Malden: Malden High | Regular School | No | High | 09 | 12 | 2018 | grade_12 | 120 | 94 | 113 | 1 | 113 | 0 | 13 | 219 | 235 | 454.0 | 120 | 94 | 113 | 1 | 113 | 0 | 13 | 219 | 235 | 454 | |||||||||||||||||||||||||||||||||
736806 | 736806 | MA | Suffolk | school | 2502790 | 35 | Boston | 250279000215 | 350515 | Charlestown High | Regular School | No | 3 | 09 | 12 | 2015 | grade_12 | 9 | 93 | 74 | 1 | 42 | 0 | 1 | 118 | 102 | 220 | 9 | 93 | 74 | 1 | 42 | 0 | 1 | 118 | 102 | 220 | |||||||||||||||||||||||||||||||||
743479 | 743479 | MA | Suffolk | school | 2500049 | 424 | Boston Day and Evening Academy Charter (District) | 250004901245 | 4240505 | Boston Day and Evening Academy Charter School | Regular School | Yes | 3 | 09 | 12 | 2015 | grade_12 | 16 | 93 | 48 | 1 | 3 | 1 | 4 | 73 | 93 | 166 | 16 | 93 | 48 | 1 | 3 | 1 | 4 | 73 | 93 | 166 | |||||||||||||||||||||||||||||||||
941933 | 941933 | MA | Bristol | school | 2511020 | 872 | Southeastern Regional Vocational Technical | 251102002290 | 8720605 | Southeastern Regional Vocational Technical | Vocational Education School | No | 3 | 09 | 12 | 2016 | grade_12 | 166 | 92 | 39 | 0 | 0 | 0 | 5 | 164 | 138 | 302 | 166 | 92 | 39 | 0 | 0 | 0 | 5 | 164 | 138 | 302 | |||||||||||||||||||||||||||||||||
1370224 | 1370224 | MA | Norfolk | school | 2509930 | 244 | Randolph | 250993001596 | 2440505 | Randolph High | Regular School | No | High | 09 | 12 | 2020 | grade_12 | 15 | 92 | 15 | 0 | 30 | 1 | 4 | 87 | 70 | * | 157.0 | 15 | 92 | 15 | 0 | 30 | 1 | 4 | 87 | 70 | 157 | ||||||||||||||||||||||||||||||||
2230088 | 2230088 | MA | Suffolk | school | 2502790 | 35 | Boston | 250279000215 | 350515 | Boston: Charlestown High | Regular School | No | High | 09 | 12 | 2018 | grade_12 | 13 | 92 | 93 | 0 | 42 | 0 | 2 | 132 | 110 | 242.0 | 13 | 92 | 93 | 0 | 42 | 0 | 2 | 132 | 110 | 242 | |||||||||||||||||||||||||||||||||
736893 | 736893 | MA | Suffolk | school | 2502790 | 35 | Boston | 250279000205 | 350575 | O'Bryant School Math/Science | Regular School | No | 3 | 07 | 12 | 2015 | grade_12 | 31 | 91 | 57 | 0 | 57 | 1 | 1 | 111 | 127 | 238 | 31 | 91 | 57 | 0 | 57 | 1 | 1 | 111 | 127 | 238 | |||||||||||||||||||||||||||||||||
1123380 | 1123380 | MA | Suffolk | school | 2502790 | 35 | Boston | 250279000205 | 350575 | O'Bryant School Math/Science | Regular School | No | High | 07 | 12 | 2017 | grade_12 | 26 | 91 | 80 | 1 | 62 | 0 | 5 | 110 | 155 | 265 | 26 | 91 | 80 | 1 | 62 | 0 | 5 | 110 | 155 | 265 | |||||||||||||||||||||||||||||||||
2230118 | 2230118 | MA | Suffolk | school | 2502790 | 35 | Boston | 250279000282 | 350537 | Boston: Madison Park High | Career and Technical School | No | High | 09 | 12 | 2018 | grade_12 | 8 | 91 | 84 | 1 | 3 | 1 | 3 | 107 | 84 | 191.0 | 8 | 91 | 84 | 1 | 3 | 1 | 3 | 107 | 84 | 191 | |||||||||||||||||||||||||||||||||
735869 | 735869 | MA | Middlesex | school | 2502100 | 14 | Ashland | 250210000070 | 140505 | Ashland High | Regular School | No | 3 | 09 | 12 | 2015 | grade_12 | 142 | 9 | 8 | 0 | 4 | 0 | 5 | 80 | 88 | 168 | 142 | 9 | 8 | 0 | 4 | 0 | 5 | 80 | 88 | 168 | |||||||||||||||||||||||||||||||||
736118 | 736118 | MA | Essex | school | 2502640 | 30 | Beverly | 250264000164 | 300505 | Beverly High | Regular School | No | 3 | 09 | 12 | 2015 | grade_12 | 281 | 9 | 26 | 0 | 7 | 0 | 2 | 135 | 190 | 325 | 281 | 9 | 26 | 0 | 7 | 0 | 2 | 135 | 190 | 325 | |||||||||||||||||||||||||||||||||
736912 | 736912 | MA | Suffolk | school | 2502790 | 35 | Boston | 250279002674 | 350655 | Lyon Upper 9-12 | Regular School | No | 3 | 09 | 12 | 2015 | grade_12 | 9 | 9 | 9 | 0 | 3 | 0 | 2 | 20 | 12 | 32 | 9 | 9 | 9 | 0 | 3 | 0 | 2 | 20 | 12 | 32 | |||||||||||||||||||||||||||||||||
737301 | 737301 | MA | Middlesex | school | 2503240 | 48 | Burlington | 250324000426 | 480505 | Burlington High | Regular School | No | 3 | 09 | 12 | 2015 | grade_12 | 187 | 9 | 9 | 0 | 39 | 1 | 9 | 127 | 127 | 254 | 187 | 9 | 9 | 0 | 39 | 1 | 9 | 127 | 127 | 254 | |||||||||||||||||||||||||||||||||
737734 | 737734 | MA | Bristol | school | 2504020 | 72 | Dartmouth | 250402000540 | 720505 | Dartmouth High | Regular School | No | 3 | 09 | 12 | 2015 | grade_12 | 229 | 9 | 4 | 1 | 9 | 1 | 1 | 124 | 130 | 254 | 229 | 9 | 4 | 1 | 9 | 1 | 1 | 124 | 130 | 254 | |||||||||||||||||||||||||||||||||
737825 | 737825 | MA | Middlesex | school | 2504320 | 79 | Dracut | 250432000579 | 790505 | Dracut Senior High | Regular School | No | 3 | 09 | 12 | 2015 | grade_12 | 204 | 9 | 9 | 0 | 9 | 0 | 2 | 117 | 116 | 233 | 204 | 9 | 9 | 0 | 9 | 0 | 2 | 117 | 116 | 233 | |||||||||||||||||||||||||||||||||
739111 | 739111 | MA | Worcester | school | 2506780 | 153 | Leominster | 250678002272 | 1530605 | Center For Technical Education Innovation | Vocational Education School | No | 3 | 09 | 12 | 2015 | grade_12 | 81 | 9 | 24 | 0 | 5 | 0 | 3 | 73 | 49 | 122 | 81 | 9 | 24 | 0 | 5 | 0 | 3 | 73 | 49 | 122 | |||||||||||||||||||||||||||||||||
739623 | 739623 | MA | Bristol | school | 2507230 | 167 | Mansfield | 250723001114 | 1670505 | Mansfield High | Regular School | No | 3 | 09 | 12 | 2015 | grade_12 | 288 | 9 | 5 | 3 | 18 | 1 | 3 | 152 | 175 | 327 | 288 | 9 | 5 | 3 | 18 | 1 | 3 | 152 | 175 | 327 | |||||||||||||||||||||||||||||||||
739680 | 739680 | MA | Middlesex | school | 2507320 | 170 | Marlborough | 250732001133 | 1700505 | Marlborough High | Regular School | No | 3 | 09 | 12 | 2015 | grade_12 | 174 | 9 | 73 | 0 | 13 | 0 | 1 | 142 | 128 | 270 | 174 | 9 | 73 | 0 | 13 | 0 | 1 | 142 | 128 | 270 | |||||||||||||||||||||||||||||||||
740846 | 740846 | MA | Essex | school | 2509360 | 229 | Peabody | 250936001504 | 2290510 | Peabody Veterans Memorial High | Regular School | No | 3 | 09 | 12 | 2015 | grade_12 | 360 | 9 | 63 | 1 | 10 | 0 | 10 | 235 | 218 | 453 | 360 | 9 | 63 | 1 | 10 | 0 | 10 | 235 | 218 | 453 | |||||||||||||||||||||||||||||||||
741385 | 741385 | MA | Essex | school | 2510380 | 258 | Salem | 251038001664 | 2580505 | Salem High | Regular School | No | 3 | 09 | 12 | 2015 | grade_12 | 150 | 9 | 84 | 2 | 11 | 0 | 13 | 136 | 133 | 269 | 150 | 9 | 84 | 2 | 11 | 0 | 13 | 136 | 133 | 269 | |||||||||||||||||||||||||||||||||
742544 | 742544 | MA | Middlesex | school | 2512210 | 315 | Wayland | 251221002010 | 3150505 | Wayland High School | Regular School | No | 3 | 09 | 12 | 2015 | grade_12 | 158 | 9 | 12 | 0 | 22 | 0 | 5 | 111 | 95 | 206 | 158 | 9 | 12 | 0 | 22 | 0 | 5 | 111 | 95 | 206 | |||||||||||||||||||||||||||||||||
745076 | 745076 | MA | Middlesex | school | 2511060 | 829 | South Middlesex Regional Vocational Technical | 251106002291 | 8290605 | Joseph P Keefe Technical High School | Vocational Education School | No | 3 | 09 | 12 | 2015 | grade_12 | 54 | 9 | 82 | 0 | 4 | 0 | 3 | 85 | 67 | 152 | 54 | 9 | 82 | 0 | 4 | 0 | 3 | 85 | 67 | 152 | |||||||||||||||||||||||||||||||||
934483 | 934483 | MA | Worcester | school | 2503750 | 64 | Clinton | 250375000513 | 640505 | Clinton Senior High | Regular School | No | 3 | 09 | 12 | 2016 | grade_12 | 60 | 9 | 25 | 0 | 3 | 0 | 0 | 48 | 49 | 97 | 60 | 9 | 25 | 0 | 3 | 0 | 0 | 48 | 49 | 97 | |||||||||||||||||||||||||||||||||
935657 | 935657 | MA | Middlesex | school | 2506330 | 139 | Hopkinton | 250633000920 | 1390505 | Hopkinton High | Regular School | No | 3 | 09 | 12 | 2016 | grade_12 | 271 | 9 | 6 | 1 | 19 | 0 | 1 | 153 | 154 | 307 | 271 | 9 | 6 | 1 | 19 | 0 | 1 | 153 | 154 | 307 | |||||||||||||||||||||||||||||||||
936468 | 936468 | MA | Bristol | school | 2507230 | 167 | Mansfield | 250723001114 | 1670505 | Mansfield High | Regular School | No | 3 | 09 | 12 | 2016 | grade_12 | 280 | 9 | 7 | 2 | 16 | 2 | 2 | 158 | 160 | 318 | 280 | 9 | 7 | 2 | 16 | 2 | 2 | 158 | 160 | 318 | |||||||||||||||||||||||||||||||||
936944 | 936944 | MA | Middlesex | school | 2508340 | 198 | Natick | 250834001303 | 1980505 | Natick High | Regular School | No | 3 | 09 | 12 | 2016 | grade_12 | 307 | 9 | 14 | 0 | 28 | 0 | 20 | 187 | 191 | 378 | 307 | 9 | 14 | 0 | 28 | 0 | 20 | 187 | 191 | 378 | |||||||||||||||||||||||||||||||||
938255 | 938255 | MA | Essex | school | 2510500 | 262 | Saugus | 251050001684 | 2620505 | Saugus High | Regular School | No | 3 | 09 | 12 | 2016 | grade_12 | 147 | 9 | 16 | 1 | 5 | 0 | 1 | 68 | 111 | 179 | 147 | 9 | 16 | 1 | 5 | 0 | 1 | 68 | 111 | 179 | |||||||||||||||||||||||||||||||||
938991 | 938991 | MA | Essex | school | 2511430 | 291 | Swampscott | 251143001887 | 2910505 | Swampscott High | Regular School | No | 3 | 09 | 12 | 2016 | grade_12 | 144 | 9 | 6 | 0 | 1 | 0 | 1 | 71 | 90 | 161 | 144 | 9 | 6 | 0 | 1 | 0 | 1 | 71 | 90 | 161 | |||||||||||||||||||||||||||||||||
939168 | 939168 | MA | Middlesex | school | 2511910 | 305 | Wakefield | 251191001951 | 3050505 | Wakefield Memorial High | Regular School | No | 3 | 09 | 12 | 2016 | grade_12 | 222 | 9 | 7 | 0 | 9 | 1 | 4 | 109 | 143 | 252 | 222 | 9 | 7 | 0 | 9 | 1 | 4 | 109 | 143 | 252 | |||||||||||||||||||||||||||||||||
939353 | 939353 | MA | Middlesex | school | 2512210 | 315 | Wayland | 251221002010 | 3150505 | Wayland High School | Regular School | No | 3 | 09 | 12 | 2016 | grade_12 | 165 | 9 | 11 | 0 | 32 | 0 | 9 | 104 | 122 | 226 | 165 | 9 | 11 | 0 | 32 | 0 | 9 | 104 | 122 | 226 | |||||||||||||||||||||||||||||||||
940332 | 940332 | 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 | 2016 | grade_12 | 102 | 9 | 12 | 0 | 54 | 0 | 5 | 97 | 85 | 182 | 102 | 9 | 12 | 0 | 54 | 0 | 5 | 97 | 85 | 182 | |||||||||||||||||||||||||||||||||
941239 | 941239 | MA | Hampden | school | 2505730 | 680 | Hampden-Wilbraham | 250573000824 | 6800505 | Minnechaug Regional High | Regular School | No | 3 | 09 | 12 | 2016 | grade_12 | 241 | 9 | 16 | 0 | 9 | 0 | 7 | 137 | 145 | 282 | 241 | 9 | 16 | 0 | 9 | 0 | 7 | 137 | 145 | 282 | |||||||||||||||||||||||||||||||||
941867 | 941867 | 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_12 | 125 | 9 | 14 | 1 | 0 | 0 | 5 | 89 | 65 | 154 | 125 | 9 | 14 | 1 | 0 | 0 | 5 | 89 | 65 | 154 | |||||||||||||||||||||||||||||||||
941879 | 941879 | 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 | 2016 | grade_12 | 287 | 9 | 17 | 3 | 9 | 1 | 13 | 182 | 157 | 339 | 287 | 9 | 17 | 3 | 9 | 1 | 13 | 182 | 157 | 339 | |||||||||||||||||||||||||||||||||
1124205 | 1124205 | MA | Hampden | school | 2503660 | 61 | Chicopee | 250366000495 | 610510 | Chicopee Comprehensive High School | Regular School | No | High | 09 | 12 | 2017 | grade_12 | 248 | 9 | 77 | 1 | 10 | 3 | 7 | 207 | 148 | 355 | 248 | 9 | 77 | 1 | 10 | 3 | 7 | 207 | 148 | 355 | |||||||||||||||||||||||||||||||||
1124472 | 1124472 | MA | Middlesex | school | 2504320 | 79 | Dracut | 250432000579 | 790505 | Dracut Senior High | Regular School | No | High | 09 | 12 | 2017 | grade_12 | 148 | 9 | 13 | 0 | 11 | 2 | 4 | 90 | 97 | 187 | 148 | 9 | 13 | 0 | 11 | 2 | 4 | 90 | 97 | 187 | |||||||||||||||||||||||||||||||||
1126001 | 1126001 | MA | Worcester | school | 2506780 | 153 | Leominster | 250678002272 | 1530605 | Center For Technical Education Innovation | Career and Technical School | No | High | 09 | 12 | 2017 | grade_12 | 72 | 9 | 39 | 0 | 2 | 0 | 3 | 77 | 48 | 125 | 72 | 9 | 39 | 0 | 2 | 0 | 3 | 77 | 48 | 125 | |||||||||||||||||||||||||||||||||
1126848 | 1126848 | MA | Middlesex | school | 2507560 | 176 | Medford | 250756001174 | 1760605 | Medford Vocational Technical High | Career and Technical School | No | High | 09 | 12 | 2017 | grade_12 | 37 | 9 | 2 | 0 | 1 | 0 | 1 | 35 | 15 | 50 | 37 | 9 | 2 | 0 | 1 | 0 | 1 | 35 | 15 | 50 | |||||||||||||||||||||||||||||||||
1128390 | 1128390 | MA | Norfolk | school | 2509870 | 243 | Quincy | 250987001577 | 2430510 | North Quincy High | Regular School | No | High | 09 | 12 | 2017 | grade_12 | 104 | 9 | 5 | 0 | 166 | 0 | 1 | 144 | 140 | 285 | 104 | 9 | 5 | 0 | 166 | 0 | 1 | 144 | 140 | 285 | |||||||||||||||||||||||||||||||||
1128896 | 1128896 | MA | Worcester | school | 2510770 | 271 | Shrewsbury | 251077001717 | 2710505 | Shrewsbury Sr High | Regular School | No | High | 09 | 12 | 2017 | grade_12 | 283 | 9 | 26 | 1 | 79 | 0 | 12 | 202 | 206 | 410 | 283 | 9 | 26 | 1 | 79 | 0 | 12 | 202 | 206 | 410 | |||||||||||||||||||||||||||||||||
1131682 | 1131682 | MA | Hampden | school | 2500522 | 499 | Hampden Charter School of Science (District) | 250052202680 | 4990305 | Hampden Charter School of Science | Regular School | Yes | Other | 06 | 12 | 2017 | grade_12 | 13 | 9 | 15 | 0 | 1 | 0 | 1 | 15 | 24 | 39 | 13 | 9 | 15 | 0 | 1 | 0 | 1 | 15 | 24 | 39 | |||||||||||||||||||||||||||||||||
1132995 | 1132995 | MA | Barnstable | school | 2503310 | 815 | Cape Cod Regional Vocational Technical | 250331002264 | 8150605 | Cape Cod Region Vocational Technical | Career and Technical School | No | High | 09 | 12 | 2017 | grade_12 | 117 | 9 | 13 | 5 | 1 | 0 | 4 | 90 | 59 | 149 | 117 | 9 | 13 | 5 | 1 | 0 | 4 | 90 | 59 | 149 | |||||||||||||||||||||||||||||||||
1368049 | 1368049 | MA | Essex | school | 2506660 | 149 | Lawrence | 250666002856 | 1490515 | Lawrence High School | Regular School | No | High | 09 | 12 | 2020 | grade_12 | 21 | 9 | 717 | 0 | 11 | 0 | 2 | 401 | 349 | 10 | 760.0 | 21 | 9 | 717 | 0 | 11 | 0 | 2 | 401 | 349 | 10 | 760 | |||||||||||||||||||||||||||||||
1368156 | 1368156 | MA | Worcester | school | 2506780 | 153 | Leominster | 250678002272 | 1530605 | Center For Technical Education Innovation | Career and Technical School | No | High | 09 | 12 | 2020 | grade_12 | 78 | 9 | 48 | 0 | 1 | 3 | 5 | 98 | 46 | * | 144.0 | 78 | 9 | 48 | 0 | 1 | 3 | 5 | 98 | 46 | 144 | ||||||||||||||||||||||||||||||||
1368699 | 1368699 | MA | Bristol | school | 2507230 | 167 | Mansfield | 250723001114 | 1670505 | Mansfield High | Regular School | No | High | 09 | 12 | 2020 | grade_12 | 267 | 9 | 7 | 0 | 17 | 0 | 8 | 165 | 143 | * | 308.0 | 267 | 9 | 7 | 0 | 17 | 0 | 8 | 165 | 143 | 308 | ||||||||||||||||||||||||||||||||
1368981 | 1368981 | MA | Essex | school | 2507740 | 181 | Methuen | 250774001213 | 1810505 | Methuen High | Regular School | No | High | 09 | 12 | 2020 | grade_12 | 238 | 9 | 165 | 0 | 18 | 1 | 26 | 227 | 230 | * | 457.0 | 238 | 9 | 165 | 0 | 18 | 1 | 26 | 227 | 230 | 457 | ||||||||||||||||||||||||||||||||
1370266 | 1370266 | MA | Middlesex | school | 2509990 | 246 | Reading | 250999001611 | 2460505 | Reading Memorial High | Regular School | No | High | 09 | 12 | 2020 | grade_12 | 266 | 9 | 6 | 1 | 19 | 0 | 3 | 136 | 168 | * | 304.0 | 266 | 9 | 6 | 1 | 19 | 0 | 3 | 136 | 168 | 304 | ||||||||||||||||||||||||||||||||
1370484 | 1370484 | MA | Essex | school | 2510500 | 262 | Saugus | 251050001684 | 2620505 | Saugus High | Regular School | No | High | 09 | 12 | 2020 | grade_12 | 113 | 9 | 28 | 1 | 9 | 0 | 1 | 88 | 73 | * | 161.0 | 113 | 9 | 28 | 1 | 9 | 0 | 1 | 88 | 73 | 161 | ||||||||||||||||||||||||||||||||
1371597 | 1371597 | MA | Middlesex | school | 2512210 | 315 | Wayland | 251221002010 | 3150505 | Wayland High School | Regular School | No | High | 09 | 12 | 2020 | grade_12 | 142 | 9 | 14 | 0 | 29 | 0 | 12 | 106 | 100 | * | 206.0 | 142 | 9 | 14 | 0 | 29 | 0 | 12 | 106 | 100 | 206 | ||||||||||||||||||||||||||||||||
1372383 | 1372383 | MA | Worcester | school | 2513230 | 348 | Worcester | 251323002121 | 3480350 | Claremont Academy | Regular School | No | High | 07 | 12 | 2020 | grade_12 | 4 | 9 | 81 | 0 | 9 | 0 | 1 | 49 | 55 | * | 104.0 | 4 | 9 | 81 | 0 | 9 | 0 | 1 | 49 | 55 | 104 | ||||||||||||||||||||||||||||||||
1373315 | 1373315 | MA | Worcester | school | 2504360 | 658 | Dudley-Charlton Reg | 250436000591 | 6580505 | Shepherd Hill Regional High | Regular School | No | High | 09 | 12 | 2020 | grade_12 | 219 | 9 | 19 | 2 | 4 | 0 | 5 | 125 | 132 | * | 258.0 | 219 | 9 | 19 | 2 | 4 | 0 | 5 | 125 | 132 | 258 | ||||||||||||||||||||||||||||||||
1373570 | 1373570 | MA | Barnstable | school | 2500544 | 712 | Monomoy Regional School District | 250054402836 | 7120515 | Monomoy Regional High School | Regular School | No | High | 08 | 12 | 2020 | grade_12 | 103 | 9 | 3 | 2 | 3 | 0 | 4 | 65 | 59 | * | 124.0 | 103 | 9 | 3 | 2 | 3 | 0 | 4 | 65 | 59 | 124 | ||||||||||||||||||||||||||||||||
1373838 | 1373838 | MA | Plymouth | school | 2510830 | 760 | Silver Lake | 251083001722 | 7600505 | Silver Lake Regional High | Regular School | No | High | 09 | 12 | 2020 | grade_12 | 266 | 9 | 3 | 1 | 5 | 1 | 3 | 149 | 139 | * | 288.0 | 266 | 9 | 3 | 1 | 5 | 1 | 3 | 149 | 139 | 288 | ||||||||||||||||||||||||||||||||
1374070 | 1374070 | MA | Plymouth | school | 2512930 | 780 | Whitman-Hanson | 251293002135 | 7800505 | Whitman Hanson Regional | Regular School | No | High | 09 | 12 | 2020 | grade_12 | 255 | 9 | 12 | 1 | 7 | 2 | 4 | 143 | 147 | * | 290.0 | 255 | 9 | 12 | 1 | 7 | 2 | 4 | 143 | 147 | 290 | ||||||||||||||||||||||||||||||||
1374172 | 1374172 | MA | Barnstable | school | 2511800 | 879 | Upper Cape Cod Regional Vocational Technical | 251180002296 | 8790605 | Upper Cape Cod Vocational Technical | Career and Technical School | No | High | 09 | 12 | 2020 | grade_12 | 145 | 9 | 3 | 1 | 4 | 0 | 8 | 108 | 62 | * | 170.0 | 145 | 9 | 3 | 1 | 4 | 0 | 8 | 108 | 62 | 170 | ||||||||||||||||||||||||||||||||
1672151 | 1672151 | MA | Essex | school | 2501950 | 9 | Andover | 250195000045 | 90505 | Andover - Andover High | Regular School | No | High | 09 | 12 | 2021 | grade_12 | 304 | 9 | 25 | 0 | 97 | 0 | 11 | 196 | 249 | * | 446.0 | 304 | 9 | 25 | 0 | 97 | 0 | 11 | 196 | 249 | 446 | ||||||||||||||||||||||||||||||||
1673167 | 1673167 | MA | Suffolk | school | 2502790 | 35 | Boston | 250279000226 | 350530 | Boston - East Boston High | Regular School | No | High | 09 | 12 | 2021 | grade_12 | 27 | 9 | 198 | 0 | 7 | 0 | 6 | 150 | 97 | * | 247.0 | 27 | 9 | 198 | 0 | 7 | 0 | 6 | 150 | 97 | 247 | ||||||||||||||||||||||||||||||||
1674675 | 1674675 | MA | Norfolk | school | 2505010 | 101 | Franklin | 250501000737 | 1010505 | Franklin - Franklin High | Regular School | No | High | 09 | 12 | 2021 | grade_12 | 381 | 9 | 15 | 2 | 33 | 0 | 9 | 232 | 217 | * | 449.0 | 381 | 9 | 15 | 2 | 33 | 0 | 9 | 232 | 217 | 449 | ||||||||||||||||||||||||||||||||
1675402 | 1675402 | MA | Worcester | school | 2506780 | 153 | Leominster | 250678002272 | 1530605 | Leominster - Center For Technical Education Innovation | Career and Technical School | No | High | 09 | 12 | 2021 | grade_12 | 91 | 9 | 56 | 0 | 2 | 1 | 4 | 103 | 60 | * | 163.0 | 91 | 9 | 56 | 0 | 2 | 1 | 4 | 103 | 60 | 163 | ||||||||||||||||||||||||||||||||
1677514 | 1677514 | MA | Middlesex | school | 2509990 | 246 | Reading | 250999001611 | 2460505 | Reading - Reading Memorial High | Regular School | No | High | 09 | 12 | 2021 | grade_12 | 293 | 9 | 8 | 1 | 14 | 0 | 5 | 168 | 161 | * | 330.0 | 293 | 9 | 8 | 1 | 14 | 0 | 5 | 168 | 161 | 330 | ||||||||||||||||||||||||||||||||
1677736 | 1677736 | MA | Essex | school | 2510500 | 262 | Saugus | 251050001684 | 2620505 | Saugus - Saugus High | Regular School | No | High | 09 | 12 | 2021 | grade_12 | 119 | 9 | 29 | 2 | 6 | 0 | 2 | 93 | 73 | * | 167.0 | 119 | 9 | 29 | 2 | 6 | 0 | 2 | 93 | 73 | 167 | ||||||||||||||||||||||||||||||||
1678577 | 1678577 | MA | Middlesex | school | 2511580 | 295 | Tewksbury | 251158001926 | 2950505 | Tewksbury - Tewksbury Memorial High | Regular School | No | High | 09 | 12 | 2021 | grade_12 | 177 | 9 | 13 | 0 | 8 | 0 | 2 | 91 | 117 | * | 209.0 | 177 | 9 | 13 | 0 | 8 | 0 | 2 | 91 | 117 | 209 | ||||||||||||||||||||||||||||||||
1678707 | 1678707 | MA | Norfolk | school | 2511970 | 307 | Walpole | 251197001964 | 3070505 | Walpole - Walpole High | Regular School | No | High | 09 | 12 | 2021 | grade_12 | 224 | 9 | 16 | 2 | 15 | 0 | 4 | 139 | 131 | * | 270.0 | 224 | 9 | 16 | 2 | 15 | 0 | 4 | 139 | 131 | 270 | ||||||||||||||||||||||||||||||||
1678941 | 1678941 | MA | Worcester | school | 2512600 | 321 | Westborough | 251260002059 | 3210505 | Westborough - Westborough High | Regular School | No | High | 09 | 12 | 2021 | grade_12 | 203 | 9 | 22 | 0 | 74 | 1 | 9 | 166 | 151 | * | 318.0 | 203 | 9 | 22 | 0 | 74 | 1 | 9 | 166 | 151 | 318 | ||||||||||||||||||||||||||||||||
1679723 | 1679723 | MA | Suffolk | school | 2500075 | 410 | Excel Academy Charter (District) | 250007502084 | 4100205 | Excel Academy Charter (District) - Excel Academy Charter School | Regular School | Yes | High | 05 | 12 | 2021 | grade_12 | 12 | 9 | 136 | 1 | 0 | 0 | 0 | 79 | 79 | * | 158.0 | 12 | 9 | 136 | 1 | 0 | 0 | 0 | 79 | 79 | 158 | ||||||||||||||||||||||||||||||||
1681368 | 1681368 | 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_12 | 88 | 9 | 71 | 3 | 1 | 0 | 3 | 106 | 68 | * | 175.0 | 88 | 9 | 71 | 3 | 1 | 0 | 3 | 106 | 68 | 175 | ||||||||||||||||||||||||||||||||
2041002 | 2041002 | MA | Suffolk | school | 2502790 | 35 | Boston | 250279000837 | 350543 | Greater Egleston Community High School | Regular School | No | High | 09 | 12 | 2019 | grade_12 | 2 | 9 | 22 | 0 | 0 | 0 | 2 | 20 | 15 | 35.0 | 2 | 9 | 22 | 0 | 0 | 0 | 2 | 20 | 15 | 35 | |||||||||||||||||||||||||||||||||
2041859 | 2041859 | MA | Essex | school | 2503990 | 71 | Danvers | 250399000529 | 710505 | Danvers High | Regular School | No | High | 09 | 12 | 2019 | grade_12 | 208 | 9 | 15 | 0 | 8 | 0 | 2 | 122 | 120 | 242.0 | 208 | 9 | 15 | 0 | 8 | 0 | 2 | 122 | 120 | 242 | |||||||||||||||||||||||||||||||||
2043820 | 2043820 | MA | Middlesex | school | 2507320 | 170 | Marlborough | 250732001133 | 1700505 | Marlborough High | Regular School | No | High | 09 | 12 | 2019 | grade_12 | 129 | 9 | 149 | 0 | 6 | 0 | 6 | 164 | 135 | 299.0 | 129 | 9 | 149 | 0 | 6 | 0 | 6 | 164 | 135 | 299 | |||||||||||||||||||||||||||||||||
2045339 | 2045339 | MA | Middlesex | school | 2509990 | 246 | Reading | 250999001611 | 2460505 | Reading Memorial High | Regular School | No | High | 09 | 12 | 2019 | grade_12 | 291 | 9 | 6 | 0 | 15 | 0 | 1 | 159 | 163 | 322.0 | 291 | 9 | 6 | 0 | 15 | 0 | 1 | 159 | 163 | 322 | |||||||||||||||||||||||||||||||||
2045438 | 2045438 | MA | Plymouth | school | 2510170 | 251 | Rockland | 251017001643 | 2510505 | Rockland Senior High | Regular School | No | High | 09 | 12 | 2019 | grade_12 | 91 | 9 | 15 | 0 | 0 | 0 | 2 | 52 | 65 | 117.0 | 91 | 9 | 15 | 0 | 0 | 0 | 2 | 52 | 65 | 117 | |||||||||||||||||||||||||||||||||
2046305 | 2046305 | MA | Essex | school | 2511430 | 291 | Swampscott | 251143001887 | 2910505 | Swampscott High | Regular School | No | High | 09 | 12 | 2019 | grade_12 | 148 | 9 | 7 | 0 | 7 | 1 | 4 | 90 | 86 | 176.0 | 148 | 9 | 7 | 0 | 7 | 1 | 4 | 90 | 86 | 176 | |||||||||||||||||||||||||||||||||
2046944 | 2046944 | MA | Hampden | school | 2512510 | 332 | West Springfield | 251251002052 | 3320505 | West Springfield High | Regular School | No | High | 09 | 12 | 2019 | grade_12 | 198 | 9 | 48 | 0 | 23 | 0 | 4 | 142 | 140 | 282.0 | 198 | 9 | 48 | 0 | 23 | 0 | 4 | 142 | 140 | 282 | |||||||||||||||||||||||||||||||||
2046983 | 2046983 | MA | Norfolk | school | 2512810 | 335 | Westwood | 251281002100 | 3350505 | Westwood High | Regular School | No | High | 09 | 12 | 2019 | grade_12 | 233 | 9 | 5 | 0 | 15 | 0 | 2 | 133 | 131 | 264.0 | 233 | 9 | 5 | 0 | 15 | 0 | 2 | 133 | 131 | 264 | |||||||||||||||||||||||||||||||||
2047456 | 2047456 | MA | Worcester | school | 2513230 | 348 | Worcester | 251323002121 | 3480350 | Claremont Academy | Regular School | No | High | 07 | 12 | 2019 | grade_12 | 7 | 9 | 63 | 0 | 8 | 0 | 0 | 40 | 47 | 87.0 | 7 | 9 | 63 | 0 | 8 | 0 | 0 | 40 | 47 | 87 | |||||||||||||||||||||||||||||||||
2047901 | 2047901 | MA | Hampshire | school | 2500044 | 479 | Pioneer Valley Performing Arts Charter Public (District) | 250004400816 | 4790505 | Pioneer Valley Performing Arts Charter Public School | Regular School | Yes | High | 07 | 12 | 2019 | grade_12 | 39 | 9 | 7 | 0 | 1 | 0 | 8 | 14 | 50 | 64.0 | 39 | 9 | 7 | 0 | 1 | 0 | 8 | 14 | 50 | 64 | |||||||||||||||||||||||||||||||||
2048100 | 2048100 | MA | Middlesex | school | 2501710 | 600 | Acton-Boxborough | 250171000012 | 6000505 | Acton-Boxborough Regional High | Regular School | No | High | 09 | 12 | 2019 | grade_12 | 294 | 9 | 21 | 0 | 159 | 0 | 17 | 271 | 229 | 500.0 | 294 | 9 | 21 | 0 | 159 | 0 | 17 | 271 | 229 | 500 | |||||||||||||||||||||||||||||||||
2048385 | 2048385 | MA | Barnstable | school | 2504560 | 660 | Nauset | 250456000610 | 6600505 | Nauset Regional High | Regular School | No | High | 09 | 12 | 2019 | grade_12 | 208 | 9 | 8 | 1 | 5 | 0 | 9 | 107 | 133 | 240.0 | 208 | 9 | 8 | 1 | 5 | 0 | 9 | 107 | 133 | 240 | |||||||||||||||||||||||||||||||||
2049144 | 2049144 | MA | Plymouth | school | 2512930 | 780 | Whitman-Hanson | 251293002135 | 7800505 | Whitman Hanson Regional | Regular School | No | High | 09 | 12 | 2019 | grade_12 | 268 | 9 | 8 | 2 | 4 | 0 | 12 | 148 | 155 | 303.0 | 268 | 9 | 8 | 2 | 4 | 0 | 12 | 148 | 155 | 303 | |||||||||||||||||||||||||||||||||
2049308 | 2049308 | 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_12 | 4 | 9 | 7 | 0 | 0 | 0 | 1 | 12 | 9 | 21.0 | 4 | 9 | 7 | 0 | 0 | 0 | 1 | 12 | 9 | 21 | |||||||||||||||||||||||||||||||||
2228928 | 2228928 | MA | Essex | school | 2501950 | 9 | Andover | 250195000045 | 90505 | Andover: Andover High | Regular School | No | High | 09 | 12 | 2018 | grade_12 | 311 | 9 | 19 | 0 | 64 | 0 | 8 | 197 | 213 | 411.0 | 311 | 9 | 19 | 0 | 64 | 0 | 8 | 197 | 213 | 411 | |||||||||||||||||||||||||||||||||
2229358 | 2229358 | MA | Middlesex | school | 2502670 | 31 | Billerica | 250267000177 | 310505 | Billerica: Billerica Memorial High School | Regular School | No | High | 09 | 12 | 2018 | grade_12 | 241 | 9 | 10 | 0 | 16 | 2 | 3 | 130 | 151 | 281.0 | 241 | 9 | 10 | 0 | 16 | 2 | 3 | 130 | 151 | 281 | |||||||||||||||||||||||||||||||||
2230220 | 2230220 | MA | Suffolk | school | 2502790 | 35 | Boston | 250279002674 | 350655 | Boston: Lyon Upper 9-12 | Regular School | No | High | 09 | 12 | 2018 | grade_12 | 8 | 9 | 7 | 0 | 0 | 0 | 3 | 18 | 9 | 27.0 | 8 | 9 | 7 | 0 | 0 | 0 | 3 | 18 | 9 | 27 | |||||||||||||||||||||||||||||||||
2231015 | 2231015 | MA | Hampden | school | 2503660 | 61 | Chicopee | 250366000496 | 610505 | Chicopee: Chicopee High | Regular School | No | High | 09 | 12 | 2018 | grade_12 | 139 | 9 | 84 | 0 | 8 | 1 | 3 | 116 | 128 | 244.0 | 139 | 9 | 84 | 0 | 8 | 1 | 3 | 116 | 128 | 244 | |||||||||||||||||||||||||||||||||
2232959 | 2232959 | MA | Hampden | school | 2506990 | 159 | Longmeadow | 250699001020 | 1590505 | Longmeadow: Longmeadow High | Regular School | No | High | 09 | 12 | 2018 | grade_12 | 184 | 9 | 8 | 0 | 18 | 0 | 2 | 112 | 109 | 221.0 | 184 | 9 | 8 | 0 | 18 | 0 | 2 | 112 | 109 | 221 | |||||||||||||||||||||||||||||||||
2233436 | 2233436 | MA | Bristol | school | 2507230 | 167 | Mansfield | 250723001114 | 1670505 | Mansfield: Mansfield High | Regular School | No | High | 09 | 12 | 2018 | grade_12 | 262 | 9 | 11 | 2 | 10 | 0 | 8 | 141 | 161 | 302.0 | 262 | 9 | 11 | 2 | 10 | 0 | 8 | 141 | 161 | 302 | |||||||||||||||||||||||||||||||||
2233504 | 2233504 | MA | Middlesex | school | 2507320 | 170 | Marlborough | 250732001133 | 1700505 | Marlborough: Marlborough High | Regular School | No | High | 09 | 12 | 2018 | grade_12 | 160 | 9 | 112 | 0 | 15 | 0 | 2 | 146 | 152 | 298.0 | 160 | 9 | 112 | 0 | 15 | 0 | 2 | 146 | 152 | 298 | |||||||||||||||||||||||||||||||||
2233835 | 2233835 | MA | Worcester | school | 2507860 | 185 | Milford | 250786001239 | 1850505 | Milford: Milford High | Regular School | No | High | 09 | 12 | 2018 | grade_12 | 184 | 9 | 71 | 4 | 11 | 1 | 2 | 129 | 153 | 282.0 | 184 | 9 | 71 | 4 | 11 | 1 | 2 | 129 | 153 | 282 | |||||||||||||||||||||||||||||||||
2234545 | 2234545 | MA | Bristol | school | 2508730 | 212 | North Attleborough | 250873001405 | 2120505 | North Attleborough: North Attleboro High | Regular School | No | High | 09 | 12 | 2018 | grade_12 | 264 | 9 | 20 | 2 | 14 | 0 | 5 | 138 | 176 | 314.0 | 264 | 9 | 20 | 2 | 14 | 0 | 5 | 138 | 176 | 314 | |||||||||||||||||||||||||||||||||
2235717 | 2235717 | MA | Worcester | school | 2510770 | 271 | Shrewsbury | 251077001717 | 2710505 | Shrewsbury: Shrewsbury Sr High | Regular School | No | High | 09 | 12 | 2018 | grade_12 | 310 | 9 | 33 | 0 | 74 | 1 | 11 | 193 | 245 | 438.0 | 310 | 9 | 33 | 0 | 74 | 1 | 11 | 193 | 245 | 438 |
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]);