enrollments
Data source: Big Local News · About: Big Local
487 rows where grade = "grade_9", state = "CO" and year = 2017 sorted by district_state_id
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
707824 | 707824 | CO | school | 805550 | 10 | MAPLETON 1 | 80555001857 | 187 | MAPLETON EXPEDITIONARY SCHOOL OF THE ARTS | Regular School | No | High | 07 | 12 | 2017 | grade_9 | 34 | 1 | 94 | 0 | 1 | 0 | 3 | 69 | 64 | 133 | 34 | 1 | 94 | 0 | 1 | 0 | 3 | 69 | 64 | 133 | ||||||||||||||||||||||||||||||||||
707829 | 707829 | CO | school | 805550 | 10 | MAPLETON 1 | 80555001858 | 212 | MAPLETON EARLY COLLEGE HIGH SCHOOL | Regular School | No | High | 09 | 12 | 2017 | grade_9 | 14 | 2 | 39 | 1 | 3 | 1 | 0 | 31 | 29 | 60 | 14 | 2 | 39 | 1 | 3 | 1 | 0 | 31 | 29 | 60 | ||||||||||||||||||||||||||||||||||
707834 | 707834 | CO | school | 805550 | 10 | MAPLETON 1 | 80555001860 | 263 | GLOBAL LEADERSHIP ACADEMY | Regular School | No | High | 09 | 12 | 2017 | grade_9 | 4 | 0 | 65 | 0 | 1 | 0 | 0 | 37 | 33 | 70 | 4 | 0 | 65 | 0 | 1 | 0 | 0 | 37 | 33 | 70 | ||||||||||||||||||||||||||||||||||
707839 | 707839 | CO | school | 805550 | 10 | MAPLETON 1 | 80555001872 | 309 | ACADEMY HIGH SCHOOL | Regular School | No | High | 09 | 12 | 2017 | grade_9 | 10 | 6 | 106 | 2 | 1 | 0 | 4 | 80 | 49 | 129 | 10 | 6 | 106 | 2 | 1 | 0 | 4 | 80 | 49 | 129 | ||||||||||||||||||||||||||||||||||
707874 | 707874 | CO | school | 805550 | 10 | MAPLETON 1 | 80555002017 | 503 | YORK INTERNATIONAL | Regular School | No | Other | KG | 12 | 2017 | grade_9 | 7 | 1 | 78 | 0 | 2 | 0 | 3 | 45 | 46 | 91 | 7 | 1 | 78 | 0 | 2 | 0 | 3 | 45 | 46 | 91 | ||||||||||||||||||||||||||||||||||
707926 | 707926 | CO | school | 805550 | 10 | MAPLETON 1 | 80555006671 | 695 | BIG PICTURE COLLEGE AND CAREER ACADEMY | Regular School | No | Other | 09 | 10 | 2017 | grade_9 | 8 | 0 | 42 | 0 | 1 | 0 | 5 | 20 | 36 | 56 | 8 | 0 | 42 | 0 | 1 | 0 | 5 | 20 | 36 | 56 | ||||||||||||||||||||||||||||||||||
707939 | 707939 | CO | school | 805550 | 10 | MAPLETON 1 | 80555006488 | 1796 | COLORADO CONNECTIONS ACADEMY | Regular School | No | Other | KG | 12 | 2017 | grade_9 | 223 | 11 | 77 | 4 | 4 | 3 | 22 | 167 | 177 | 344 | 223 | 11 | 77 | 4 | 4 | 3 | 22 | 167 | 177 | 344 | ||||||||||||||||||||||||||||||||||
708790 | 708790 | CO | school | 802070 | 100 | ALAMOSA RE-11J | 80207000027 | 118 | ALAMOSA HIGH SCHOOL | Regular School | No | High | 09 | 12 | 2017 | grade_9 | 58 | 4 | 112 | 2 | 2 | 1 | 4 | 88 | 95 | 183 | 58 | 4 | 112 | 2 | 2 | 1 | 4 | 88 | 95 | 183 | ||||||||||||||||||||||||||||||||||
708798 | 708798 | CO | school | 802070 | 100 | ALAMOSA RE-11J | 80207006508 | 368 | ALAMOSA OMBUDSMAN SCHOOL OF EXCELLENCE | Alternative School | No | Other | 06 | 12 | 2017 | grade_9 | 1 | 1 | 18 | 0 | 0 | 0 | 0 | 14 | 6 | 20 | 1 | 1 | 18 | 0 | 0 | 0 | 0 | 14 | 6 | 20 | ||||||||||||||||||||||||||||||||||
713927 | 713927 | CO | school | 804080 | 1000 | FOUNTAIN 8 | 80408000096 | 203 | WELTE EDUCATION CENTER | Alternative School | No | High | 09 | 12 | 2017 | grade_9 | 3 | 1 | 1 | 0 | 0 | 0 | 0 | 2 | 3 | 5 | 3 | 1 | 1 | 0 | 0 | 0 | 0 | 2 | 3 | 5 | ||||||||||||||||||||||||||||||||||
713970 | 713970 | CO | school | 804080 | 1000 | FOUNTAIN 8 | 80408000562 | 3110 | FOUNTAIN-FORT CARSON HIGH SCHOOL | Regular School | No | High | 09 | 12 | 2017 | grade_9 | 248 | 70 | 152 | 3 | 5 | 11 | 39 | 285 | 243 | 528 | 248 | 70 | 152 | 3 | 5 | 11 | 39 | 285 | 243 | 528 | ||||||||||||||||||||||||||||||||||
714007 | 714007 | CO | school | 803060 | 1010 | COLORADO SPRINGS 11 | 80306006428 | 269 | ACHIEVE ONLINE | Regular School | No | Other | 06 | 12 | 2017 | grade_9 | 17 | 3 | 9 | 0 | 0 | 0 | 1 | 11 | 19 | 30 | 17 | 3 | 9 | 0 | 0 | 0 | 1 | 11 | 19 | 30 | ||||||||||||||||||||||||||||||||||
714031 | 714031 | CO | school | 803060 | 1010 | COLORADO SPRINGS 11 | 80306001888 | 871 | THE BIJOU SCHOOL | Alternative School | No | High | 09 | 12 | 2017 | grade_9 | 5 | 1 | 4 | 0 | 0 | 0 | 3 | 10 | 3 | 13 | 5 | 1 | 4 | 0 | 0 | 0 | 3 | 10 | 3 | 13 | ||||||||||||||||||||||||||||||||||
714067 | 714067 | CO | school | 803060 | 1010 | COLORADO SPRINGS 11 | 80306001589 | 1616 | CIVA CHARTER ACADEMY | Regular School | Yes | High | 09 | 12 | 2017 | grade_9 | 26 | 1 | 7 | 0 | 1 | 0 | 2 | 15 | 22 | 37 | 26 | 1 | 7 | 0 | 1 | 0 | 2 | 15 | 22 | 37 | ||||||||||||||||||||||||||||||||||
714088 | 714088 | CO | school | 803060 | 1010 | COLORADO SPRINGS 11 | 80306000228 | 1870 | CORONADO HIGH SCHOOL | Regular School | No | High | 09 | 12 | 2017 | grade_9 | 248 | 18 | 113 | 3 | 4 | 2 | 30 | 224 | 194 | 418 | 248 | 18 | 113 | 3 | 4 | 2 | 30 | 224 | 194 | 418 | ||||||||||||||||||||||||||||||||||
714093 | 714093 | CO | school | 803060 | 1010 | COLORADO SPRINGS 11 | 80306001299 | 1885 | COMMUNITY PREP CHARTER SCHOOL | Alternative School | Yes | High | 09 | 12 | 2017 | grade_9 | 3 | 0 | 0 | 0 | 0 | 0 | 0 | 3 | 0 | 3 | 3 | 0 | 0 | 0 | 0 | 0 | 0 | 3 | 0 | 3 | ||||||||||||||||||||||||||||||||||
714098 | 714098 | CO | school | 803060 | 1010 | COLORADO SPRINGS 11 | 80306000268 | 2202 | DOHERTY HIGH SCHOOL | Regular School | No | High | 09 | 12 | 2017 | grade_9 | 327 | 45 | 164 | 3 | 14 | 3 | 49 | 313 | 292 | 605 | 327 | 45 | 164 | 3 | 14 | 3 | 49 | 313 | 292 | 605 | ||||||||||||||||||||||||||||||||||
714103 | 714103 | CO | school | 803060 | 1010 | COLORADO SPRINGS 11 | 80306006580 | 2400 | EARLY COLLEGE HIGH SCHOOL | Alternative School | No | High | 09 | 12 | 2017 | grade_9 | 19 | 3 | 18 | 0 | 0 | 0 | 8 | 20 | 28 | 48 | 19 | 3 | 18 | 0 | 0 | 0 | 8 | 20 | 28 | 48 | ||||||||||||||||||||||||||||||||||
714118 | 714118 | CO | school | 803060 | 1010 | COLORADO SPRINGS 11 | 80306000232 | 2528 | NIKOLA TESLA EDUCATION OPPORTUNITY CENTER | Alternative School | No | Other | 06 | 12 | 2017 | grade_9 | 7 | 2 | 5 | 0 | 0 | 0 | 0 | 7 | 7 | 14 | 7 | 2 | 5 | 0 | 0 | 0 | 0 | 7 | 7 | 14 | ||||||||||||||||||||||||||||||||||
714209 | 714209 | CO | school | 803060 | 1010 | COLORADO SPRINGS 11 | 80306001841 | 5146 | LIFE SKILLS CENTER OF COLORADO SPRINGS | Alternative School | Yes | High | 09 | 12 | 2017 | grade_9 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | ||||||||||||||||||||||||||||||||||
714254 | 714254 | CO | school | 803060 | 1010 | COLORADO SPRINGS 11 | 80306000254 | 5948 | MITCHELL HIGH SCHOOL | Regular School | No | High | 09 | 12 | 2017 | grade_9 | 105 | 39 | 144 | 6 | 6 | 1 | 22 | 160 | 163 | 323 | 105 | 39 | 144 | 6 | 6 | 1 | 22 | 160 | 163 | 323 | ||||||||||||||||||||||||||||||||||
714271 | 714271 | CO | school | 803060 | 1010 | COLORADO SPRINGS 11 | 80306000257 | 6680 | PALMER HIGH SCHOOL | Regular School | No | High | 09 | 12 | 2017 | grade_9 | 214 | 37 | 182 | 1 | 7 | 4 | 36 | 239 | 242 | 481 | 214 | 37 | 182 | 1 | 7 | 4 | 36 | 239 | 242 | 481 | ||||||||||||||||||||||||||||||||||
714402 | 714402 | CO | school | 802940 | 1020 | CHEYENNE MOUNTAIN 12 | 80294000211 | 1590 | CHEYENNE MOUNTAIN HIGH SCHOOL | Regular School | No | High | 09 | 12 | 2017 | grade_9 | 226 | 9 | 36 | 2 | 7 | 0 | 20 | 151 | 149 | 300 | 226 | 9 | 36 | 2 | 7 | 0 | 20 | 151 | 149 | 300 | ||||||||||||||||||||||||||||||||||
714444 | 714444 | CO | school | 802940 | 1020 | CHEYENNE MOUNTAIN 12 | 80294006370 | 9057 | THE VANGUARD SCHOOL (HIGH) | Regular School | Yes | High | 09 | 12 | 2017 | grade_9 | 63 | 2 | 23 | 0 | 2 | 0 | 5 | 44 | 51 | 95 | 63 | 2 | 23 | 0 | 2 | 0 | 5 | 44 | 51 | 95 | ||||||||||||||||||||||||||||||||||
714461 | 714461 | CO | school | 805490 | 1030 | MANITOU SPRINGS 14 | 80549000946 | 5468 | MANITOU SPRINGS HIGH SCHOOL | Regular School | No | High | 09 | 12 | 2017 | grade_9 | 124 | 1 | 7 | 0 | 0 | 0 | 5 | 66 | 71 | 137 | 124 | 1 | 7 | 0 | 0 | 0 | 5 | 66 | 71 | 137 | ||||||||||||||||||||||||||||||||||
714495 | 714495 | CO | school | 801920 | 1040 | ACADEMY 20 | 80192000002 | 76 | AIR ACADEMY HIGH SCHOOL | Regular School | No | High | 09 | 12 | 2017 | grade_9 | 248 | 7 | 39 | 1 | 14 | 1 | 19 | 158 | 171 | 329 | 248 | 7 | 39 | 1 | 14 | 1 | 19 | 158 | 171 | 329 | ||||||||||||||||||||||||||||||||||
714500 | 714500 | CO | school | 801920 | 1040 | ACADEMY 20 | 80192006434 | 110 | ACADEMY ONLINE | Regular School | No | Other | KG | 12 | 2017 | grade_9 | 23 | 2 | 3 | 0 | 0 | 0 | 1 | 19 | 10 | 29 | 23 | 2 | 3 | 0 | 0 | 0 | 1 | 19 | 10 | 29 | ||||||||||||||||||||||||||||||||||
714507 | 714507 | CO | school | 801920 | 1040 | ACADEMY 20 | 80192000858 | 209 | ASPEN VALLEY CAMPUS | Alternative School | No | High | 07 | 12 | 2017 | grade_9 | 21 | 0 | 1 | 1 | 1 | 0 | 0 | 17 | 7 | 24 | 21 | 0 | 1 | 1 | 1 | 0 | 0 | 17 | 7 | 24 | ||||||||||||||||||||||||||||||||||
714542 | 714542 | CO | school | 801920 | 1040 | ACADEMY 20 | 80192001943 | 1630 | THE CLASSICAL ACADEMY HIGH SCHOOL | Regular School | Yes | High | 09 | 12 | 2017 | grade_9 | 149 | 4 | 19 | 0 | 4 | 0 | 6 | 98 | 84 | 182 | 149 | 4 | 19 | 0 | 4 | 0 | 6 | 98 | 84 | 182 | ||||||||||||||||||||||||||||||||||
714570 | 714570 | CO | school | 801920 | 1040 | ACADEMY 20 | 80192001905 | 2195 | DISCOVERY CANYON CAMPUS HIGH SCHOOL | Regular School | No | High | 09 | 12 | 2017 | grade_9 | 217 | 8 | 39 | 1 | 11 | 1 | 8 | 154 | 131 | 285 | 217 | 8 | 39 | 1 | 11 | 1 | 8 | 154 | 131 | 285 | ||||||||||||||||||||||||||||||||||
714631 | 714631 | CO | school | 801920 | 1040 | ACADEMY 20 | 80192001429 | 5126 | LIBERTY HIGH SCHOOL | Regular School | No | High | 09 | 12 | 2017 | grade_9 | 262 | 20 | 46 | 4 | 8 | 1 | 27 | 185 | 183 | 368 | 262 | 20 | 46 | 4 | 8 | 1 | 27 | 185 | 183 | 368 | ||||||||||||||||||||||||||||||||||
714648 | 714648 | CO | school | 801920 | 1040 | ACADEMY 20 | 80192001645 | 6937 | PINE CREEK HIGH SCHOOL | Regular School | No | High | 09 | 12 | 2017 | grade_9 | 298 | 15 | 53 | 2 | 23 | 3 | 31 | 241 | 184 | 425 | 298 | 15 | 53 | 2 | 23 | 3 | 31 | 241 | 184 | 425 | ||||||||||||||||||||||||||||||||||
714669 | 714669 | CO | school | 801920 | 1040 | ACADEMY 20 | 80192001321 | 7240 | RAMPART HIGH SCHOOL | Regular School | No | High | 09 | 12 | 2017 | grade_9 | 281 | 21 | 79 | 1 | 28 | 2 | 25 | 234 | 203 | 437 | 281 | 21 | 79 | 1 | 28 | 2 | 25 | 234 | 203 | 437 | ||||||||||||||||||||||||||||||||||
714693 | 714693 | CO | school | 801920 | 1040 | ACADEMY 20 | 80192006447 | 8779 | TCA COLLEGE PATHWAYS | Regular School | Yes | High | 07 | 12 | 2017 | grade_9 | 61 | 3 | 9 | 0 | 1 | 1 | 9 | 44 | 40 | 84 | 61 | 3 | 9 | 0 | 1 | 1 | 9 | 44 | 40 | 84 | ||||||||||||||||||||||||||||||||||
714732 | 714732 | CO | school | 803750 | 1050 | ELLICOTT 22 | 80375000485 | 2642 | ELLICOTT SENIOR HIGH SCHOOL | Regular School | No | High | 09 | 12 | 2017 | grade_9 | 46 | 2 | 26 | 1 | 0 | 0 | 2 | 38 | 39 | 77 | 46 | 2 | 26 | 1 | 0 | 0 | 2 | 38 | 39 | 77 | ||||||||||||||||||||||||||||||||||
714737 | 714737 | CO | school | 806060 | 1060 | PEYTON 23 JT | 80606006637 | 1346 | CAREER BUILDING ACADEMY | Regular School | Yes | High | 09 | 12 | 2017 | grade_9 | 2 | 0 | 0 | 0 | 0 | 0 | 0 | 2 | 0 | 2 | 2 | 0 | 0 | 0 | 0 | 0 | 0 | 2 | 0 | 2 | ||||||||||||||||||||||||||||||||||
714742 | 714742 | CO | school | 806060 | 1060 | PEYTON 23 JT | 80606006692 | 6626 | PEYTON ONLINE ACADEMY | Regular School | No | High | 09 | 12 | 2017 | grade_9 | 4 | 0 | 0 | 0 | 0 | 0 | 0 | 3 | 1 | 4 | 4 | 0 | 0 | 0 | 0 | 0 | 0 | 3 | 1 | 4 | ||||||||||||||||||||||||||||||||||
714759 | 714759 | CO | school | 806060 | 1060 | PEYTON 23 JT | 80606001025 | 6902 | PEYTON SENIOR HIGH SCHOOL | Regular School | No | High | 09 | 12 | 2017 | grade_9 | 48 | 0 | 5 | 0 | 1 | 0 | 2 | 31 | 25 | 56 | 48 | 0 | 5 | 0 | 1 | 0 | 2 | 31 | 25 | 56 | ||||||||||||||||||||||||||||||||||
714767 | 714767 | CO | school | 804500 | 1070 | HANOVER 28 | 80450000661 | 3758 | HANOVER JUNIOR-SENIOR HIGH SCHOOL | Regular School | No | Other | 06 | 12 | 2017 | grade_9 | 12 | 0 | 8 | 0 | 0 | 0 | 0 | 9 | 11 | 20 | 12 | 0 | 8 | 0 | 0 | 0 | 0 | 9 | 11 | 20 | ||||||||||||||||||||||||||||||||||
714825 | 714825 | CO | school | 805820 | 1080 | LEWIS-PALMER 38 | 80582001003 | 5100 | LEWIS-PALMER HIGH SCHOOL | Regular School | No | High | 09 | 12 | 2017 | grade_9 | 216 | 4 | 24 | 2 | 2 | 0 | 11 | 140 | 119 | 259 | 216 | 4 | 24 | 2 | 2 | 0 | 11 | 140 | 119 | 259 | ||||||||||||||||||||||||||||||||||
714830 | 714830 | CO | school | 805820 | 1080 | LEWIS-PALMER 38 | 80582006369 | 6678 | PALMER RIDGE HIGH SCHOOL | Regular School | No | High | 09 | 12 | 2017 | grade_9 | 236 | 4 | 23 | 0 | 14 | 1 | 11 | 154 | 135 | 289 | 236 | 4 | 23 | 0 | 14 | 1 | 11 | 154 | 135 | 289 | ||||||||||||||||||||||||||||||||||
708814 | 708814 | CO | school | 806420 | 110 | SANGRE DE CRISTO RE-22J | 80642001116 | 7630 | SANGRE DE CRISTO UNDIVIDED HIGH SCHOOL | Regular School | No | Other | 06 | 12 | 2017 | grade_9 | 12 | 0 | 8 | 2 | 0 | 0 | 0 | 9 | 13 | 22 | 12 | 0 | 8 | 2 | 0 | 0 | 0 | 9 | 13 | 22 | ||||||||||||||||||||||||||||||||||
714880 | 714880 | CO | school | 803870 | 1110 | FALCON 49 | 80387006462 | 2877 | SPRINGS STUDIO FOR ACADEMIC EXCELLENCE | Regular School | No | Other | KG | 12 | 2017 | grade_9 | 36 | 4 | 9 | 0 | 1 | 0 | 2 | 20 | 32 | 52 | 36 | 4 | 9 | 0 | 1 | 0 | 2 | 20 | 32 | 52 | ||||||||||||||||||||||||||||||||||
714898 | 714898 | CO | school | 803870 | 1110 | FALCON 49 | 80387000507 | 2908 | FALCON HIGH SCHOOL | Regular School | No | High | 09 | 12 | 2017 | grade_9 | 214 | 14 | 55 | 1 | 4 | 0 | 15 | 159 | 144 | 303 | 214 | 14 | 55 | 1 | 4 | 0 | 15 | 159 | 144 | 303 | ||||||||||||||||||||||||||||||||||
714903 | 714903 | CO | school | 803870 | 1110 | FALCON 49 | 80387006393 | 3475 | GOAL ACADEMY | Alternative School | Yes | High | 09 | 12 | 2017 | grade_9 | 106 | 3 | 121 | 1 | 0 | 1 | 7 | 99 | 140 | 239 | 106 | 3 | 121 | 1 | 0 | 1 | 7 | 99 | 140 | 239 | ||||||||||||||||||||||||||||||||||
714940 | 714940 | CO | school | 803870 | 1110 | FALCON 49 | 80387006693 | 6653 | POWER TECHNICAL EARLY COLLEGE | Career and Technical School | Yes | Other | 06 | 10 | 2017 | grade_9 | 13 | 0 | 6 | 0 | 1 | 1 | 1 | 20 | 2 | 22 | 13 | 0 | 6 | 0 | 1 | 1 | 1 | 20 | 2 | 22 | ||||||||||||||||||||||||||||||||||
714945 | 714945 | CO | school | 803870 | 1110 | FALCON 49 | 80387006403 | 6810 | PATRIOT HIGH SCHOOL | Alternative School | No | High | 09 | 12 | 2017 | grade_9 | 10 | 1 | 3 | 0 | 0 | 0 | 0 | 13 | 1 | 14 | 10 | 1 | 3 | 0 | 0 | 0 | 0 | 13 | 1 | 14 | ||||||||||||||||||||||||||||||||||
714950 | 714950 | CO | school | 803870 | 1110 | FALCON 49 | 80387006694 | 6821 | PIKES PEAK EARLY COLLEGE | Regular School | No | High | 09 | 12 | 2017 | grade_9 | 10 | 0 | 5 | 0 | 0 | 0 | 0 | 6 | 9 | 15 | 10 | 0 | 5 | 0 | 0 | 0 | 0 | 6 | 9 | 15 | ||||||||||||||||||||||||||||||||||
714990 | 714990 | CO | school | 803870 | 1110 | FALCON 49 | 80387002000 | 7463 | ROCKY MOUNTAIN CLASSICAL ACADEMY | Regular School | Yes | Other | KG | 12 | 2017 | grade_9 | 19 | 1 | 2 | 0 | 0 | 0 | 1 | 10 | 13 | 23 | 19 | 1 | 2 | 0 | 0 | 0 | 1 | 10 | 13 | 23 | ||||||||||||||||||||||||||||||||||
714997 | 714997 | CO | school | 803870 | 1110 | FALCON 49 | 80387001594 | 7613 | SAND CREEK HIGH SCHOOL | Regular School | No | High | 09 | 12 | 2017 | grade_9 | 142 | 34 | 72 | 1 | 19 | 3 | 36 | 159 | 148 | 307 | 142 | 34 | 72 | 1 | 19 | 3 | 36 | 159 | 148 | 307 | ||||||||||||||||||||||||||||||||||
715022 | 715022 | CO | school | 803870 | 1110 | FALCON 49 | 80387006408 | 8791 | VISTA RIDGE HIGH SCHOOL | Regular School | No | High | 09 | 12 | 2017 | grade_9 | 243 | 31 | 104 | 4 | 18 | 1 | 37 | 243 | 195 | 438 | 243 | 31 | 104 | 4 | 18 | 1 | 37 | 243 | 195 | 438 | ||||||||||||||||||||||||||||||||||
715045 | 715045 | CO | school | 803630 | 1120 | EDISON 54 JT | 80363006648 | 2523 | EDISON PREP | Regular School | No | High | 09 | 12 | 2017 | grade_9 | 2 | 0 | 2 | 0 | 0 | 0 | 0 | 1 | 3 | 4 | 2 | 0 | 2 | 0 | 0 | 0 | 0 | 1 | 3 | 4 | ||||||||||||||||||||||||||||||||||
715053 | 715053 | CO | school | 803630 | 1120 | EDISON 54 JT | 80363001278 | 2526 | EDISON JUNIOR-SENIOR HIGH SCHOOL | Regular School | No | Other | 06 | 12 | 2017 | grade_9 | 9 | 0 | 1 | 0 | 0 | 0 | 1 | 6 | 5 | 11 | 9 | 0 | 1 | 0 | 0 | 0 | 1 | 6 | 5 | 11 | ||||||||||||||||||||||||||||||||||
715069 | 715069 | CO | school | 805670 | 1130 | MIAMI/YODER 60 JT | 80567000972 | 5854 | MIAMI-YODER MIDDLE/HIGH SCHOOL | Regular School | No | Other | 06 | 12 | 2017 | grade_9 | 15 | 0 | 5 | 0 | 0 | 0 | 0 | 9 | 11 | 20 | 15 | 0 | 5 | 0 | 0 | 0 | 0 | 9 | 11 | 20 | ||||||||||||||||||||||||||||||||||
715077 | 715077 | CO | school | 802790 | 1140 | CANON CITY RE-1 | 80279006536 | 419 | CANON ONLINE ACADEMY | Regular School | No | Other | 06 | 12 | 2017 | grade_9 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | ||||||||||||||||||||||||||||||||||
715086 | 715086 | CO | school | 802790 | 1140 | CANON CITY RE-1 | 80279000172 | 1266 | CANON CITY HIGH SCHOOL | Regular School | No | High | 09 | 12 | 2017 | grade_9 | 215 | 2 | 40 | 2 | 2 | 0 | 5 | 121 | 145 | 266 | 215 | 2 | 40 | 2 | 2 | 0 | 5 | 121 | 145 | 266 | ||||||||||||||||||||||||||||||||||
715143 | 715143 | CO | school | 803960 | 1150 | FREMONT RE-2 | 80396000514 | 3002 | FLORENCE HIGH SCHOOL | Regular School | No | High | 09 | 12 | 2017 | grade_9 | 69 | 1 | 16 | 0 | 2 | 0 | 1 | 43 | 46 | 89 | 69 | 1 | 16 | 0 | 2 | 0 | 1 | 43 | 46 | 89 | ||||||||||||||||||||||||||||||||||
715177 | 715177 | CO | school | 803120 | 1160 | COTOPAXI RE-3 | 80312000277 | 3228 | COTOPAXI JUNIOR-SENIOR HIGH SCHOOL | Regular School | No | Other | 06 | 12 | 2017 | grade_9 | 21 | 0 | 2 | 0 | 0 | 0 | 1 | 12 | 12 | 24 | 21 | 0 | 2 | 0 | 0 | 0 | 1 | 12 | 12 | 24 | ||||||||||||||||||||||||||||||||||
715205 | 715205 | CO | school | 804260 | 1180 | ROARING FORK RE-1 | 80426000584 | 570 | BASALT HIGH SCHOOL | Regular School | No | High | 09 | 12 | 2017 | grade_9 | 54 | 0 | 70 | 1 | 0 | 0 | 1 | 65 | 61 | 126 | 54 | 0 | 70 | 1 | 0 | 0 | 1 | 65 | 61 | 126 | ||||||||||||||||||||||||||||||||||
715240 | 715240 | CO | school | 804260 | 1180 | ROARING FORK RE-1 | 80426000588 | 3468 | GLENWOOD SPRINGS HIGH SCHOOL | Regular School | No | High | 09 | 12 | 2017 | grade_9 | 109 | 2 | 115 | 0 | 1 | 0 | 11 | 129 | 109 | 238 | 109 | 2 | 115 | 0 | 1 | 0 | 11 | 129 | 109 | 238 | ||||||||||||||||||||||||||||||||||
715245 | 715245 | CO | school | 804260 | 1180 | ROARING FORK RE-1 | 80426000590 | 7422 | ROARING FORK HIGH SCHOOL | Regular School | No | High | 09 | 12 | 2017 | grade_9 | 40 | 0 | 46 | 1 | 1 | 0 | 0 | 44 | 44 | 88 | 40 | 0 | 46 | 1 | 1 | 0 | 0 | 44 | 44 | 88 | ||||||||||||||||||||||||||||||||||
715259 | 715259 | CO | school | 806240 | 1195 | GARFIELD RE-2 | 80624001906 | 65 | COAL RIDGE HIGH SCHOOL | Regular School | No | High | 09 | 12 | 2017 | grade_9 | 77 | 0 | 64 | 0 | 1 | 0 | 1 | 80 | 63 | 143 | 77 | 0 | 64 | 0 | 1 | 0 | 1 | 80 | 63 | 143 | ||||||||||||||||||||||||||||||||||
715301 | 715301 | CO | school | 806240 | 1195 | GARFIELD RE-2 | 80624001097 | 7360 | RIFLE HIGH SCHOOL | Regular School | No | High | 09 | 12 | 2017 | grade_9 | 94 | 1 | 120 | 0 | 1 | 0 | 4 | 122 | 98 | 220 | 94 | 1 | 120 | 0 | 1 | 0 | 4 | 122 | 98 | 220 | ||||||||||||||||||||||||||||||||||
708819 | 708819 | CO | school | 803780 | 120 | ENGLEWOOD 1 | 80378001310 | 206 | COLORADO'S FINEST HIGH SCHOOL OF CHOICE | Alternative School | No | High | 09 | 12 | 2017 | grade_9 | 44 | 1 | 28 | 0 | 1 | 0 | 0 | 45 | 29 | 74 | 44 | 1 | 28 | 0 | 1 | 0 | 0 | 45 | 29 | 74 | ||||||||||||||||||||||||||||||||||
708848 | 708848 | CO | school | 803780 | 120 | ENGLEWOOD 1 | 80378000491 | 2746 | ENGLEWOOD HIGH SCHOOL | Regular School | No | High | 09 | 12 | 2017 | grade_9 | 72 | 6 | 68 | 0 | 1 | 0 | 6 | 84 | 69 | 153 | 72 | 6 | 68 | 0 | 1 | 0 | 6 | 84 | 69 | 153 | ||||||||||||||||||||||||||||||||||
715336 | 715336 | CO | school | 804380 | 1220 | GARFIELD 16 | 80438000631 | 3586 | GRAND VALLEY HIGH SCHOOL | Regular School | No | High | 09 | 12 | 2017 | grade_9 | 61 | 0 | 28 | 2 | 0 | 0 | 0 | 50 | 41 | 91 | 61 | 0 | 28 | 2 | 0 | 0 | 0 | 50 | 41 | 91 | ||||||||||||||||||||||||||||||||||
708881 | 708881 | CO | school | 806540 | 123 | SHERIDAN 2 | 80654001134 | 7842 | SHERIDAN HIGH SCHOOL | Regular School | No | High | 09 | 12 | 2017 | grade_9 | 13 | 7 | 86 | 2 | 4 | 0 | 3 | 54 | 61 | 115 | 13 | 7 | 86 | 2 | 4 | 0 | 3 | 54 | 61 | 115 | ||||||||||||||||||||||||||||||||||
708888 | 708888 | CO | school | 806540 | 123 | SHERIDAN 2 | 80654006565 | 8123 | SOAR ACADEMY | Alternative School | No | Other | 06 | 12 | 2017 | grade_9 | 0 | 0 | 3 | 0 | 0 | 0 | 0 | 2 | 1 | 3 | 0 | 0 | 3 | 0 | 0 | 0 | 0 | 2 | 1 | 3 | ||||||||||||||||||||||||||||||||||
708970 | 708970 | CO | school | 802910 | 130 | CHERRY CREEK 5 | 80291001951 | 1551 | CHEROKEE TRAIL HIGH SCHOOL | Regular School | No | High | 09 | 12 | 2017 | grade_9 | 480 | 84 | 120 | 0 | 66 | 0 | 49 | 416 | 383 | 799 | 480 | 84 | 120 | 0 | 66 | 0 | 49 | 416 | 383 | 799 | ||||||||||||||||||||||||||||||||||
708983 | 708983 | CO | school | 802910 | 130 | CHERRY CREEK 5 | 80291000186 | 1570 | CHERRY CREEK HIGH SCHOOL | Regular School | No | High | 09 | 12 | 2017 | grade_9 | 657 | 32 | 110 | 2 | 121 | 1 | 35 | 505 | 453 | 958 | 657 | 32 | 110 | 2 | 121 | 1 | 35 | 505 | 453 | 958 | ||||||||||||||||||||||||||||||||||
709048 | 709048 | CO | school | 802910 | 130 | CHERRY CREEK 5 | 80291006156 | 2357 | EAGLECREST HIGH SCHOOL | Regular School | No | High | 09 | 12 | 2017 | grade_9 | 380 | 86 | 151 | 4 | 42 | 2 | 46 | 362 | 349 | 711 | 380 | 86 | 151 | 4 | 42 | 2 | 46 | 362 | 349 | 711 | ||||||||||||||||||||||||||||||||||
709073 | 709073 | CO | school | 802910 | 130 | CHERRY CREEK 5 | 80291001625 | 3589 | GRANDVIEW HIGH SCHOOL | Regular School | No | High | 09 | 12 | 2017 | grade_9 | 385 | 43 | 130 | 1 | 57 | 2 | 39 | 343 | 314 | 657 | 385 | 43 | 130 | 1 | 57 | 2 | 39 | 343 | 314 | 657 | ||||||||||||||||||||||||||||||||||
709187 | 709187 | CO | school | 802910 | 130 | CHERRY CREEK 5 | 80291006563 | 6367 | OPTIONS SCHOOL | Alternative School | No | Other | KG | 12 | 2017 | grade_9 | 17 | 2 | 3 | 0 | 0 | 0 | 1 | 12 | 11 | 23 | 17 | 2 | 3 | 0 | 0 | 0 | 1 | 12 | 11 | 23 | ||||||||||||||||||||||||||||||||||
709197 | 709197 | CO | school | 802910 | 130 | CHERRY CREEK 5 | 80291001272 | 6625 | OVERLAND HIGH SCHOOL | Regular School | No | High | 09 | 12 | 2017 | grade_9 | 149 | 170 | 239 | 3 | 35 | 2 | 38 | 345 | 291 | 636 | 149 | 170 | 239 | 3 | 35 | 2 | 38 | 345 | 291 | 636 | ||||||||||||||||||||||||||||||||||
709258 | 709258 | CO | school | 802910 | 130 | CHERRY CREEK 5 | 80291000203 | 8020 | SMOKY HILL HIGH SCHOOL | Regular School | No | High | 09 | 12 | 2017 | grade_9 | 232 | 114 | 131 | 6 | 40 | 0 | 28 | 281 | 270 | 551 | 232 | 114 | 131 | 6 | 40 | 0 | 28 | 281 | 270 | 551 | ||||||||||||||||||||||||||||||||||
715356 | 715356 | CO | school | 804230 | 1330 | GILPIN COUNTY RE-1 | 80423001298 | 1634 | GILPIN COUNTY UNDIVIDED HIGH SCHOOL | Regular School | No | Other | 06 | 12 | 2017 | grade_9 | 34 | 0 | 6 | 0 | 0 | 0 | 0 | 14 | 26 | 40 | 34 | 0 | 6 | 0 | 0 | 0 | 0 | 14 | 26 | 40 | ||||||||||||||||||||||||||||||||||
715361 | 715361 | CO | school | 805070 | 1340 | WEST GRAND 1-JT | 80507000830 | 9420 | WEST GRAND HIGH SCHOOL | Regular School | No | High | 09 | 12 | 2017 | grade_9 | 28 | 0 | 17 | 0 | 0 | 0 | 0 | 24 | 21 | 45 | 28 | 0 | 17 | 0 | 0 | 0 | 0 | 24 | 21 | 45 | ||||||||||||||||||||||||||||||||||
715396 | 715396 | CO | school | 804320 | 1350 | EAST GRAND 2 | 80432000596 | 5864 | MIDDLE PARK HIGH SCHOOL | Regular School | No | High | 09 | 12 | 2017 | grade_9 | 81 | 1 | 16 | 0 | 0 | 1 | 0 | 60 | 39 | 99 | 81 | 1 | 16 | 0 | 0 | 1 | 0 | 60 | 39 | 99 | ||||||||||||||||||||||||||||||||||
715411 | 715411 | CO | school | 804470 | 1360 | GUNNISON WATERSHED RE1J | 80447000655 | 2006 | CRESTED BUTTE SECONDARY SCHOOL | Regular School | No | Other | 06 | 12 | 2017 | grade_9 | 52 | 1 | 1 | 0 | 0 | 0 | 1 | 27 | 28 | 55 | 52 | 1 | 1 | 0 | 0 | 0 | 1 | 27 | 28 | 55 | ||||||||||||||||||||||||||||||||||
715423 | 715423 | CO | school | 804470 | 1360 | GUNNISON WATERSHED RE1J | 80447000656 | 3694 | GUNNISON HIGH SCHOOL | Regular School | No | High | 09 | 12 | 2017 | grade_9 | 88 | 0 | 21 | 2 | 0 | 0 | 2 | 52 | 61 | 113 | 88 | 0 | 21 | 2 | 0 | 0 | 2 | 52 | 61 | 113 | ||||||||||||||||||||||||||||||||||
715453 | 715453 | CO | school | 804620 | 1380 | HINSDALE COUNTY RE 1 | 80462001969 | 4899 | LAKE CITY COMMUNITY SCHOOL | Regular School | No | Other | PK | 12 | 2017 | grade_9 | 7 | 0 | 1 | 0 | 0 | 0 | 0 | 5 | 3 | 8 | 7 | 0 | 1 | 0 | 0 | 0 | 0 | 5 | 3 | 8 | ||||||||||||||||||||||||||||||||||
715482 | 715482 | CO | school | 807080 | 1390 | HUERFANO RE-1 | 80708001212 | 9212 | JOHN MALL HIGH SCHOOL | Regular School | No | High | 09 | 12 | 2017 | grade_9 | 17 | 0 | 21 | 4 | 0 | 0 | 0 | 23 | 19 | 42 | 17 | 0 | 21 | 4 | 0 | 0 | 0 | 23 | 19 | 42 | ||||||||||||||||||||||||||||||||||
709321 | 709321 | CO | school | 805310 | 140 | LITTLETON 6 | 80531000873 | 298 | ARAPAHOE HIGH SCHOOL | Regular School | No | High | 09 | 12 | 2017 | grade_9 | 479 | 7 | 50 | 3 | 18 | 1 | 33 | 279 | 312 | 591 | 479 | 7 | 50 | 3 | 18 | 1 | 33 | 279 | 312 | 591 | ||||||||||||||||||||||||||||||||||
709362 | 709362 | CO | school | 805310 | 140 | LITTLETON 6 | 80531000881 | 3930 | HERITAGE HIGH SCHOOL | Regular School | No | High | 09 | 12 | 2017 | grade_9 | 308 | 3 | 63 | 1 | 12 | 0 | 13 | 192 | 208 | 400 | 308 | 3 | 63 | 1 | 12 | 0 | 13 | 192 | 208 | 400 | ||||||||||||||||||||||||||||||||||
709383 | 709383 | CO | school | 805310 | 140 | LITTLETON 6 | 80531000884 | 5224 | LITTLETON HIGH SCHOOL | Regular School | No | High | 09 | 12 | 2017 | grade_9 | 151 | 5 | 102 | 2 | 9 | 1 | 10 | 138 | 142 | 280 | 151 | 5 | 102 | 2 | 9 | 1 | 10 | 138 | 142 | 280 | ||||||||||||||||||||||||||||||||||
715498 | 715498 | CO | school | 805160 | 1400 | LA VETA RE-2 | 80516000854 | 4864 | LA VETA JUNIOR-SENIOR HIGH SCHOOL | Regular School | No | Other | 06 | 12 | 2017 | grade_9 | 15 | 0 | 8 | 0 | 0 | 0 | 0 | 5 | 18 | 23 | 15 | 0 | 8 | 0 | 0 | 0 | 0 | 5 | 18 | 23 | ||||||||||||||||||||||||||||||||||
715511 | 715511 | CO | school | 807050 | 1410 | NORTH PARK R-1 | 80705001209 | 6358 | NORTH PARK SCHOOL | Regular School | No | Other | PK | 12 | 2017 | grade_9 | 9 | 0 | 3 | 0 | 0 | 0 | 0 | 8 | 4 | 12 | 9 | 0 | 3 | 0 | 0 | 0 | 0 | 8 | 4 | 12 | ||||||||||||||||||||||||||||||||||
715532 | 715532 | CO | school | 804800 | 1420 | JEFFERSON COUNTY R-1 | 80480006163 | 33 | MC LAIN HIGH SCHOOL | Alternative School | No | High | 07 | 12 | 2017 | grade_9 | 11 | 0 | 2 | 0 | 0 | 0 | 2 | 9 | 6 | 15 | 11 | 0 | 2 | 0 | 0 | 0 | 2 | 9 | 6 | 15 | ||||||||||||||||||||||||||||||||||
715541 | 715541 | CO | school | 804800 | 1420 | JEFFERSON COUNTY R-1 | 80480000691 | 108 | ALAMEDA INTERNATIONAL JUNIOR/SENIOR HIGH SCHOOL | Regular School | No | High | 07 | 12 | 2017 | grade_9 | 26 | 4 | 160 | 3 | 3 | 0 | 3 | 114 | 85 | 199 | 26 | 4 | 160 | 3 | 3 | 0 | 3 | 114 | 85 | 199 | ||||||||||||||||||||||||||||||||||
715565 | 715565 | CO | school | 804800 | 1420 | JEFFERSON COUNTY R-1 | 80480000694 | 370 | ARVADA HIGH SCHOOL | Regular School | No | High | 09 | 12 | 2017 | grade_9 | 73 | 3 | 79 | 0 | 5 | 0 | 7 | 93 | 74 | 167 | 73 | 3 | 79 | 0 | 5 | 0 | 7 | 93 | 74 | 167 | ||||||||||||||||||||||||||||||||||
715570 | 715570 | CO | school | 804800 | 1420 | JEFFERSON COUNTY R-1 | 80480000695 | 378 | ARVADA WEST HIGH SCHOOL | Regular School | No | High | 09 | 12 | 2017 | grade_9 | 343 | 5 | 74 | 2 | 13 | 1 | 15 | 239 | 214 | 453 | 343 | 5 | 74 | 2 | 13 | 1 | 15 | 239 | 214 | 453 | ||||||||||||||||||||||||||||||||||
715595 | 715595 | CO | school | 804800 | 1420 | JEFFERSON COUNTY R-1 | 80480000697 | 664 | BEAR CREEK HIGH SCHOOL | Regular School | No | High | 09 | 12 | 2017 | grade_9 | 201 | 5 | 159 | 1 | 20 | 2 | 11 | 200 | 199 | 399 | 201 | 5 | 159 | 1 | 20 | 2 | 11 | 200 | 199 | 399 | ||||||||||||||||||||||||||||||||||
715662 | 715662 | CO | school | 804800 | 1420 | JEFFERSON COUNTY R-1 | 80480006587 | 1451 | ADDENBROOKE CLASSICAL ACADEMY | Regular School | Yes | Other | 06 | 12 | 2017 | grade_9 | 18 | 0 | 10 | 0 | 0 | 0 | 0 | 10 | 18 | 28 | 18 | 0 | 10 | 0 | 0 | 0 | 0 | 10 | 18 | 28 | ||||||||||||||||||||||||||||||||||
715667 | 715667 | CO | school | 804800 | 1420 | JEFFERSON COUNTY R-1 | 80480001383 | 1522 | CHATFIELD HIGH SCHOOL | Regular School | No | High | 09 | 12 | 2017 | grade_9 | 367 | 1 | 60 | 0 | 4 | 1 | 18 | 239 | 212 | 451 | 367 | 1 | 60 | 0 | 4 | 1 | 18 | 239 | 212 | 451 | ||||||||||||||||||||||||||||||||||
715701 | 715701 | CO | school | 804800 | 1420 | JEFFERSON COUNTY R-1 | 80480000707 | 1864 | COLUMBINE HIGH SCHOOL | Regular School | No | High | 09 | 12 | 2017 | grade_9 | 331 | 6 | 102 | 3 | 25 | 2 | 15 | 255 | 229 | 484 | 331 | 6 | 102 | 3 | 25 | 2 | 15 | 255 | 229 | 484 | ||||||||||||||||||||||||||||||||||
715733 | 715733 | CO | school | 804800 | 1420 | JEFFERSON COUNTY R-1 | 80480001766 | 1880 | COMPASS MONTESSORI - GOLDEN CHARTER SCHOOL | Regular School | Yes | Other | PK | 12 | 2017 | grade_9 | 31 | 0 | 5 | 0 | 0 | 0 | 6 | 17 | 25 | 42 | 31 | 0 | 5 | 0 | 0 | 0 | 6 | 17 | 25 | 42 | ||||||||||||||||||||||||||||||||||
715741 | 715741 | CO | school | 804800 | 1420 | JEFFERSON COUNTY R-1 | 80480001542 | 1886 | CONIFER SENIOR HIGH SCHOOL | Regular School | No | High | 09 | 12 | 2017 | grade_9 | 202 | 0 | 13 | 2 | 2 | 0 | 5 | 126 | 98 | 224 | 202 | 0 | 13 | 2 | 2 | 0 | 5 | 126 | 98 | 224 | ||||||||||||||||||||||||||||||||||
715749 | 715749 | CO | school | 804800 | 1420 | JEFFERSON COUNTY R-1 | 80480001543 | 2093 | DAKOTA RIDGE SENIOR HIGH SCHOOL | Regular School | No | High | 09 | 12 | 2017 | grade_9 | 291 | 3 | 70 | 2 | 14 | 1 | 10 | 215 | 176 | 391 | 291 | 3 | 70 | 2 | 14 | 1 | 10 | 215 | 176 | 391 | ||||||||||||||||||||||||||||||||||
715756 | 715756 | CO | school | 804800 | 1420 | JEFFERSON COUNTY R-1 | 80480000964 | 2120 | D'EVELYN JUNIOR/SENIOR HIGH SCHOOL | Regular School | No | High | 07 | 12 | 2017 | grade_9 | 129 | 2 | 17 | 0 | 16 | 2 | 8 | 78 | 96 | 174 | 129 | 2 | 17 | 0 | 16 | 2 | 8 | 78 | 96 | 174 | ||||||||||||||||||||||||||||||||||
715840 | 715840 | CO | school | 804800 | 1420 | JEFFERSON COUNTY R-1 | 80480000719 | 2836 | EVERGREEN HIGH SCHOOL | Regular School | No | High | 09 | 12 | 2017 | grade_9 | 257 | 1 | 15 | 0 | 6 | 0 | 6 | 144 | 141 | 285 | 257 | 1 | 15 | 0 | 6 | 0 | 6 | 144 | 141 | 285 |
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]);