enrollments
Data source: Big Local News · About: Big Local
3,382 rows where grade = "grade_9" and state = "CO" sorted by hispanic 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
846079 | 846079 | CO | school | 803390 | 2055 | DOLORES RE-4A | 80339000432 | 2208 | DOLORES HIGH SCHOOL | Regular School | No | 3.0 | 09 | 12 | 2016 | grade_9 | 37 | 0 | 9 | 3 | 0 | 0 | 0 | 24 | 25 | 49 | 37 | 0 | 9 | 3 | 0 | 0 | 0 | 24 | 25 | 49 | ||||||||||||||||||||||||||||||||||
846097 | 846097 | CO | school | 805460 | 2070 | MANCOS RE-6 | 80546000944 | 5452 | MANCOS HIGH SCHOOL | Regular School | No | 3.0 | 09 | 12 | 2016 | grade_9 | 18 | 0 | 9 | 5 | 0 | 0 | 0 | 18 | 14 | 32 | 18 | 0 | 9 | 5 | 0 | 0 | 0 | 18 | 14 | 32 | ||||||||||||||||||||||||||||||||||
847492 | 847492 | CO | school | 3030 | AKRON R-1 | 90 | AKRON HIGH SCHOOL | 2016 | grade_9 | 28 | 0 | 9 | 0 | 1 | 0 | 0 | 22 | 16 | 38 | 28 | 0 | 9 | 0 | 1 | 0 | 0 | 22 | 16 | 38 | |||||||||||||||||||||||||||||||||||||||||
848154 | 848154 | CO | school | 800017 | 3210 | WRAY RD-2 | 80001701818 | 9733 | WRAY HIGH SCHOOL | Regular School | No | 3.0 | 09 | 12 | 2016 | grade_9 | 36 | 0 | 9 | 0 | 1 | 0 | 0 | 24 | 22 | 46 | 36 | 0 | 9 | 0 | 1 | 0 | 0 | 24 | 22 | 46 | ||||||||||||||||||||||||||||||||||
848487 | 848487 | CO | school | 800023 | 9000 | Colorado School for the Deaf and Blind | 80002306410 | 1924 | COLORADO SCHOOL FOR THE DEAF AND BLIND | Special Education School | No | 4.0 | PK | 12 | 2016 | grade_9 | 5 | 2 | 9 | 0 | 0 | 0 | 0 | 8 | 8 | 16 | 5 | 2 | 9 | 0 | 0 | 0 | 0 | 8 | 8 | 16 | ||||||||||||||||||||||||||||||||||
1741067 | 1741067 | CO | school | 805370 | 470 | St Vrain Valley RE1J | 80537001572 | 8927 | Twin Peaks Charter Academy | Regular School | Yes | Other | KG | 12 | 2021 | grade_9 | 28 | 1 | 9 | 0 | 3 | 0 | 2 | 24 | 19 | 43 | 28 | 1 | 9 | 0 | 3 | 0 | 2 | 24 | 19 | 43 | ||||||||||||||||||||||||||||||||||
1741787 | 1741787 | CO | school | 803330 | 870 | Delta County 50(J) | 80333000300 | 4128 | Hotchkiss High School | Regular School | No | High | 09 | 12 | 2021 | grade_9 | 43 | 0 | 9 | 0 | 0 | 0 | 0 | 30 | 22 | 52 | 43 | 0 | 9 | 0 | 0 | 0 | 0 | 30 | 22 | 52 | ||||||||||||||||||||||||||||||||||
1741836 | 1741836 | CO | school | 803360 | 880 | Denver County 1 | 80336001724 | 40 | Ridge View Academy Charter School | Alternative School | Yes | High | 07 | 12 | 2021 | grade_9 | 4 | 3 | 9 | 0 | 0 | 1 | 2 | 19 | 0 | 19 | 4 | 3 | 9 | 0 | 0 | 1 | 2 | 19 | 0 | 19 | ||||||||||||||||||||||||||||||||||
1744621 | 1744621 | CO | school | 803060 | 1010 | Colorado Springs 11 | 80306000232 | 2528 | Nikola Tesla Education Opportunity Center | Alternative School | No | High | 06 | 12 | 2021 | grade_9 | 6 | 3 | 9 | 0 | 0 | 0 | 2 | 6 | 14 | 20 | 6 | 3 | 9 | 0 | 0 | 0 | 2 | 6 | 14 | 20 | ||||||||||||||||||||||||||||||||||
1745221 | 1745221 | CO | school | 801920 | 1040 | Academy 20 | 80192006447 | 8779 | TCA College Pathways | Regular School | Yes | High | 07 | 12 | 2021 | grade_9 | 59 | 5 | 9 | 0 | 1 | 0 | 9 | 28 | 55 | 83 | 59 | 5 | 9 | 0 | 1 | 0 | 9 | 28 | 55 | 83 | ||||||||||||||||||||||||||||||||||
1746861 | 1746861 | CO | school | 804800 | 1420 | Jefferson County R-1 | 80480000765 | 6541 | Jefferson County Open Secondary | Regular School | No | High | 07 | 12 | 2021 | grade_9 | 41 | 1 | 9 | 0 | 0 | 0 | 2 | 29 | 24 | 53 | 41 | 1 | 9 | 0 | 0 | 0 | 2 | 29 | 24 | 53 | ||||||||||||||||||||||||||||||||||
1748683 | 1748683 | CO | school | 804350 | 2000 | Mesa County Valley 51 | 80435006384 | 5828 | Mesa Valley Community School | Regular School | Yes | Other | KG | 12 | 2021 | grade_9 | 26 | 0 | 9 | 0 | 1 | 0 | 1 | 14 | 23 | 37 | 26 | 0 | 9 | 0 | 1 | 0 | 1 | 14 | 23 | 37 | ||||||||||||||||||||||||||||||||||
1748963 | 1748963 | CO | school | 805460 | 2070 | Mancos Re-6 | 80546000944 | 5452 | Mancos High School | Regular School | No | High | 09 | 12 | 2021 | grade_9 | 26 | 0 | 9 | 2 | 0 | 0 | 1 | 23 | 15 | 38 | 26 | 0 | 9 | 2 | 0 | 0 | 1 | 23 | 15 | 38 | ||||||||||||||||||||||||||||||||||
1749421 | 1749421 | CO | school | 802280 | 2640 | Aspen 1 | 80228000047 | 432 | Aspen High School | Regular School | No | High | 09 | 12 | 2021 | grade_9 | 130 | 2 | 9 | 0 | 3 | 0 | 1 | 63 | 82 | 145 | 130 | 2 | 9 | 0 | 3 | 0 | 1 | 63 | 82 | 145 | ||||||||||||||||||||||||||||||||||
1749785 | 1749785 | CO | school | 806150 | 2700 | Pueblo County 70 | 80615006496 | 5990 | 70 Online | Alternative School | No | Other | KG | 12 | 2021 | grade_9 | 3 | 2 | 9 | 0 | 0 | 0 | 3 | 13 | 4 | 17 | 3 | 2 | 9 | 0 | 0 | 0 | 3 | 13 | 4 | 17 | ||||||||||||||||||||||||||||||||||
1799519 | 1799519 | CO | school | 806900 | 20 | Adams 12 Five Star Schools | 80690000728 | 1519 | Stargate Charter School | Regular School | Yes | Other | KG | 12 | 2020 | grade_9 | 78 | 1 | 9 | 1 | 22 | 0 | 5 | 61 | 55 | 116 | 78 | 1 | 9 | 1 | 22 | 0 | 5 | 61 | 55 | 116 | ||||||||||||||||||||||||||||||||||
1802675 | 1802675 | CO | school | 802130 | 580 | South Conejos RE-10 | 80213000035 | 252 | Antonito High School | Regular School | No | High | 09 | 12 | 2020 | grade_9 | 2 | 0 | 9 | 0 | 0 | 0 | 0 | 5 | 6 | 11 | 2 | 0 | 9 | 0 | 0 | 0 | 0 | 5 | 6 | 11 | ||||||||||||||||||||||||||||||||||
1803883 | 1803883 | CO | school | 803360 | 880 | Denver County 1 | 80336001795 | 7163 | Prep Academy | Alternative School | No | High | 06 | 12 | 2020 | grade_9 | 2 | 7 | 9 | 0 | 0 | 0 | 1 | 10 | 9 | 19 | 2 | 7 | 9 | 0 | 0 | 0 | 1 | 10 | 9 | 19 | ||||||||||||||||||||||||||||||||||
1805705 | 1805705 | CO | school | 803060 | 1010 | Colorado Springs 11 | 80306000232 | 2528 | Nikola Tesla Education Opportunity Center | Alternative School | No | High | 06 | 12 | 2020 | grade_9 | 12 | 3 | 9 | 0 | 1 | 0 | 0 | 10 | 15 | 25 | 12 | 3 | 9 | 0 | 1 | 0 | 0 | 10 | 15 | 25 | ||||||||||||||||||||||||||||||||||
1806153 | 1806153 | CO | school | 801920 | 1040 | Academy 20 | 80192001943 | 1630 | The Classical Academy High School | Regular School | Yes | High | 09 | 12 | 2020 | grade_9 | 142 | 4 | 9 | 1 | 6 | 0 | 6 | 87 | 81 | 168 | 142 | 4 | 9 | 1 | 6 | 0 | 6 | 87 | 81 | 168 | ||||||||||||||||||||||||||||||||||
1807662 | 1807662 | CO | school | 804800 | 1420 | Jefferson County R-1 | 80480001921 | 4404 | Jefferson Academy | Regular School | Yes | Other | KG | 12 | 2020 | grade_9 | 47 | 0 | 9 | 3 | 1 | 0 | 2 | 34 | 28 | 62 | 47 | 0 | 9 | 3 | 1 | 0 | 2 | 34 | 28 | 62 | ||||||||||||||||||||||||||||||||||
1808248 | 1808248 | CO | school | 804800 | 1420 | Jefferson County R-1 | 80480006466 | 8793 | Two Roads Charter School | Regular School | Yes | Other | PK | 12 | 2020 | grade_9 | 43 | 0 | 9 | 0 | 2 | 0 | 2 | 31 | 25 | 56 | 43 | 0 | 9 | 0 | 2 | 0 | 2 | 31 | 25 | 56 | ||||||||||||||||||||||||||||||||||
1810448 | 1810448 | CO | school | 802370 | 2600 | Platte Canyon 1 | 80237000087 | 7046 | Platte Canyon High School | Regular School | No | High | 09 | 12 | 2020 | grade_9 | 47 | 0 | 9 | 1 | 0 | 0 | 4 | 35 | 26 | 61 | 47 | 0 | 9 | 1 | 0 | 0 | 4 | 35 | 26 | 61 | ||||||||||||||||||||||||||||||||||
1810983 | 1810983 | CO | school | 806150 | 2700 | Pueblo County 70 | 80615001082 | 7534 | Rye High School | Regular School | No | High | 09 | 12 | 2020 | grade_9 | 51 | 0 | 9 | 0 | 0 | 0 | 3 | 34 | 29 | 63 | 51 | 0 | 9 | 0 | 0 | 0 | 3 | 34 | 29 | 63 | ||||||||||||||||||||||||||||||||||
1811128 | 1811128 | CO | school | 806450 | 2750 | Sargent RE-33J | 80645001118 | 7664 | Sargent Senior High School | Regular School | No | High | 09 | 12 | 2020 | grade_9 | 11 | 0 | 9 | 0 | 0 | 0 | 0 | 11 | 9 | 20 | 11 | 0 | 9 | 0 | 0 | 0 | 0 | 11 | 9 | 20 | ||||||||||||||||||||||||||||||||||
1895679 | 1895679 | CO | school | 802340 | 180 | ADAMS-ARAPAHOE 28J | 80234001789 | 6546 | OPTIONS SCHOOL | Regular School | No | Other | KG | 12 | 2018 | grade_9 | 31 | 0 | 9 | 0 | 0 | 0 | 2 | 26 | 16 | 42 | 31 | 0 | 9 | 0 | 0 | 0 | 2 | 26 | 16 | 42 | ||||||||||||||||||||||||||||||||||
1897961 | 1897961 | CO | school | 803360 | 880 | DENVER COUNTY 1 | 80336006669 | 5044 | LEGACY OPTIONS HIGH SCHOOL | Alternative School | No | High | 09 | 12 | 2018 | grade_9 | 1 | 7 | 9 | 0 | 0 | 0 | 2 | 11 | 8 | 19 | 1 | 7 | 9 | 0 | 0 | 0 | 2 | 11 | 8 | 19 | ||||||||||||||||||||||||||||||||||
1904444 | 1904444 | CO | school | 803090 | 2035 | MONTEZUMA-CORTEZ RE-1 | 80309001692 | 8133 | SOUTHWEST OPEN CHARTER SCHOOL | Alternative School | Yes | High | 09 | 12 | 2018 | grade_9 | 27 | 0 | 9 | 7 | 1 | 0 | 2 | 29 | 17 | 46 | 27 | 0 | 9 | 7 | 1 | 0 | 2 | 29 | 17 | 46 | ||||||||||||||||||||||||||||||||||
1904758 | 1904758 | CO | school | 804110 | 2540 | FOWLER R-4J | 80411000568 | 3134 | FOWLER HIGH SCHOOL | Regular School | No | High | 09 | 12 | 2018 | grade_9 | 23 | 0 | 9 | 0 | 0 | 1 | 0 | 21 | 12 | 33 | 23 | 0 | 9 | 0 | 0 | 1 | 0 | 21 | 12 | 33 | ||||||||||||||||||||||||||||||||||
1905686 | 1905686 | CO | school | 806870 | 2830 | TELLURIDE R-1 | 80687001171 | 8794 | TELLURIDE HIGH SCHOOL | Regular School | No | High | 09 | 12 | 2018 | grade_9 | 49 | 1 | 9 | 0 | 1 | 0 | 2 | 29 | 33 | 62 | 49 | 1 | 9 | 0 | 1 | 0 | 2 | 29 | 33 | 62 | ||||||||||||||||||||||||||||||||||
1905726 | 1905726 | CO | school | 804860 | 2862 | JULESBURG RE-1 | 80486000813 | 4492 | JULESBURG HIGH SCHOOL | Regular School | No | High | 07 | 12 | 2018 | grade_9 | 11 | 0 | 9 | 0 | 0 | 0 | 1 | 9 | 12 | 21 | 11 | 0 | 9 | 0 | 0 | 0 | 1 | 9 | 12 | 21 | ||||||||||||||||||||||||||||||||||
1906646 | 1906646 | CO | school | 800020 | 8001 | CHARTER SCHOOL INSTITUTE | 80002006305 | 1279 | CAPROCK ACADEMY | Regular School | Yes | Other | KG | 12 | 2018 | grade_9 | 44 | 1 | 9 | 0 | 0 | 0 | 5 | 29 | 30 | 59 | 44 | 1 | 9 | 0 | 0 | 0 | 5 | 29 | 30 | 59 | ||||||||||||||||||||||||||||||||||
1931612 | 1931612 | CO | school | 802580 | 40 | SCHOOL DISTRICT 27J | 80258000729 | 1021 | BRIGHTON HERITAGE ACADEMY | Alternative School | No | High | 06 | 12 | 2019 | grade_9 | 1 | 0 | 9 | 0 | 0 | 0 | 0 | 9 | 1 | 10 | 1 | 0 | 9 | 0 | 0 | 0 | 0 | 9 | 1 | 10 | ||||||||||||||||||||||||||||||||||
1934186 | 1934186 | CO | school | 802640 | 490 | BUENA VISTA R-31 | 80264000157 | 1130 | BUENA VISTA HIGH SCHOOL | Regular School | No | High | 09 | 12 | 2019 | grade_9 | 67 | 1 | 9 | 0 | 0 | 1 | 0 | 43 | 35 | 78 | 67 | 1 | 9 | 0 | 0 | 1 | 0 | 43 | 35 | 78 | ||||||||||||||||||||||||||||||||||
1934344 | 1934344 | CO | school | 806390 | 560 | SANFORD 6J | 80639001114 | 7616 | SANFORD JUNIOR/SENIOR HIGH SCHOOL | Regular School | No | High | 07 | 12 | 2019 | grade_9 | 17 | 0 | 9 | 0 | 0 | 0 | 0 | 10 | 16 | 26 | 17 | 0 | 9 | 0 | 0 | 0 | 0 | 10 | 16 | 26 | ||||||||||||||||||||||||||||||||||
1938996 | 1938996 | CO | school | 804800 | 1420 | JEFFERSON COUNTY R-1 | 80480006587 | 1451 | ADDENBROOKE CLASSICAL ACADEMY | Regular School | Yes | High | 06 | 12 | 2019 | grade_9 | 32 | 0 | 9 | 0 | 2 | 0 | 2 | 22 | 23 | 45 | 32 | 0 | 9 | 0 | 2 | 0 | 2 | 22 | 23 | 45 | ||||||||||||||||||||||||||||||||||
1939635 | 1939635 | CO | school | 804800 | 1420 | JEFFERSON COUNTY R-1 | 80480000765 | 6541 | JEFFERSON COUNTY OPEN SECONDARY | Regular School | No | High | 07 | 12 | 2019 | grade_9 | 46 | 0 | 9 | 0 | 0 | 1 | 3 | 29 | 30 | 59 | 46 | 0 | 9 | 0 | 0 | 1 | 3 | 29 | 30 | 59 | ||||||||||||||||||||||||||||||||||
1939929 | 1939929 | CO | school | 804800 | 1420 | JEFFERSON COUNTY R-1 | 80480006466 | 8793 | TWO ROADS CHARTER SCHOOL | Regular School | Yes | Other | PK | 12 | 2019 | grade_9 | 36 | 1 | 9 | 0 | 1 | 0 | 3 | 25 | 25 | 50 | 36 | 1 | 9 | 0 | 1 | 0 | 3 | 25 | 25 | 50 | ||||||||||||||||||||||||||||||||||
1940400 | 1940400 | CO | school | 803990 | 1550 | POUDRE R-1 | 80399001717 | 146 | RIDGEVIEW CLASSICAL CHARTER SCHOOLS | Regular School | Yes | Other | KG | 12 | 2019 | grade_9 | 48 | 0 | 9 | 0 | 1 | 0 | 3 | 27 | 34 | 61 | 48 | 0 | 9 | 0 | 1 | 0 | 3 | 27 | 34 | 61 | ||||||||||||||||||||||||||||||||||
1942143 | 1942143 | CO | school | 806840 | 2570 | SWINK 33 | 80684001169 | 8456 | SWINK JUNIOR-SENIOR HIGH SCHOOL | Regular School | No | High | 07 | 12 | 2019 | grade_9 | 13 | 2 | 9 | 0 | 1 | 0 | 1 | 16 | 10 | 26 | 13 | 2 | 9 | 0 | 1 | 0 | 1 | 16 | 10 | 26 | ||||||||||||||||||||||||||||||||||
1942234 | 1942234 | CO | school | 803840 | 2610 | PARK COUNTY RE-2 | 80384000503 | 8118 | SOUTH PARK HIGH SCHOOL | Regular School | No | High | 09 | 12 | 2019 | grade_9 | 22 | 1 | 9 | 0 | 0 | 0 | 2 | 14 | 20 | 34 | 22 | 1 | 9 | 0 | 0 | 0 | 2 | 14 | 20 | 34 | ||||||||||||||||||||||||||||||||||
1942670 | 1942670 | CO | school | 806150 | 2700 | PUEBLO COUNTY 70 | 80615006496 | 5990 | 70 ONLINE | Alternative School | No | Other | KG | 12 | 2019 | grade_9 | 8 | 0 | 9 | 0 | 0 | 0 | 2 | 13 | 6 | 19 | 8 | 0 | 9 | 0 | 0 | 0 | 2 | 13 | 6 | 19 | ||||||||||||||||||||||||||||||||||
1942879 | 1942879 | CO | school | 806450 | 2750 | SARGENT RE-33J | 80645001118 | 7664 | SARGENT SENIOR HIGH SCHOOL | Regular School | No | High | 09 | 12 | 2019 | grade_9 | 19 | 0 | 9 | 0 | 1 | 0 | 0 | 15 | 14 | 29 | 19 | 0 | 9 | 0 | 1 | 0 | 0 | 15 | 14 | 29 | ||||||||||||||||||||||||||||||||||
1943460 | 1943460 | CO | school | 807350 | 3100 | WINDSOR RE-4 | 80735006650 | 9393 | WINDSOR CHARTER ACADEMY MIDDLE AND EARLY COLLEGE HIGH SCHOOL | Regular School | Yes | High | 06 | 12 | 2019 | grade_9 | 83 | 0 | 9 | 1 | 5 | 0 | 3 | 46 | 55 | 101 | 83 | 0 | 9 | 1 | 5 | 0 | 3 | 46 | 55 | 101 | ||||||||||||||||||||||||||||||||||
1135662 | 1135662 | CO | school | 805370 | 470 | ST VRAIN VALLEY RE 1J | 80537000902 | 3196 | FREDERICK SENIOR HIGH SCHOOL | Regular School | No | 3.0 | 09 | 12 | 2015 | grade_9 | 176.0 | 1.0 | 89.0 | 0.0 | 2.0 | 1.0 | 2.0 | 143.0 | 128.0 | 271.0 | 176 | 1 | 89 | 0 | 2 | 1 | 2 | 143 | 128 | 271 | ||||||||||||||||||||||||||||||||||
1140773 | 1140773 | CO | school | 804800 | 1420 | JEFFERSON COUNTY R-1 | 80480000694 | 370 | ARVADA HIGH SCHOOL | Regular School | No | 3.0 | 09 | 12 | 2015 | grade_9 | 120.0 | 8.0 | 89.0 | 6.0 | 10.0 | 2.0 | 9.0 | 141.0 | 103.0 | 244.0 | 120 | 8 | 89 | 6 | 10 | 2 | 9 | 141 | 103 | 244 | ||||||||||||||||||||||||||||||||||
1142793 | 1142793 | CO | school | 805400 | 1560 | THOMPSON R2-J | 80540001786 | 6163 | MOUNTAIN VIEW HIGH SCHOOL | Regular School | No | 3.0 | 09 | 12 | 2015 | grade_9 | 221.0 | 7.0 | 89.0 | 1.0 | 5.0 | 0.0 | 7.0 | 161.0 | 169.0 | 330.0 | 221 | 7 | 89 | 1 | 5 | 0 | 7 | 161 | 169 | 330 | ||||||||||||||||||||||||||||||||||
712902 | 712902 | CO | school | 803450 | 900 | DOUGLAS COUNTY RE 1 | 80345000440 | 2230 | DOUGLAS COUNTY HIGH SCHOOL | Regular School | No | High | 09 | 12 | 2017 | grade_9 | 383 | 3 | 89 | 1 | 15 | 2 | 19 | 261 | 251 | 512 | 383 | 3 | 89 | 1 | 15 | 2 | 19 | 261 | 251 | 512 | ||||||||||||||||||||||||||||||||||
841408 | 841408 | CO | school | 804530 | 980 | HARRISON 2 | 80453001382 | 7882 | SIERRA HIGH SCHOOL | Regular School | No | 3.0 | 09 | 12 | 2016 | grade_9 | 42 | 60 | 89 | 2 | 8 | 4 | 8 | 113 | 100 | 213 | 42 | 60 | 89 | 2 | 8 | 4 | 8 | 113 | 100 | 213 | ||||||||||||||||||||||||||||||||||
1744591 | 1744591 | CO | school | 803060 | 1010 | Colorado Springs 11 | 80306000228 | 1870 | Coronado High School | Regular School | No | High | 09 | 12 | 2021 | grade_9 | 276 | 26 | 89 | 4 | 4 | 2 | 28 | 242 | 187 | 429 | 276 | 26 | 89 | 4 | 4 | 2 | 28 | 242 | 187 | 429 | ||||||||||||||||||||||||||||||||||
1803014 | 1803014 | CO | school | 803360 | 880 | Denver County 1 | 80336006730 | 1529 | DSST: Conservatory Green High School | Regular School | Yes | Secondary | 09 | 11 | 2020 | grade_9 | 18 | 46 | 89 | 1 | 7 | 0 | 4 | 85 | 80 | 165 | 18 | 46 | 89 | 1 | 7 | 0 | 4 | 85 | 80 | 165 | ||||||||||||||||||||||||||||||||||
1811595 | 1811595 | CO | school | 804200 | 3080 | Weld County RE-1 | 80420000580 | 9032 | Valley High School | Regular School | No | High | 09 | 12 | 2020 | grade_9 | 51 | 1 | 89 | 1 | 0 | 0 | 1 | 82 | 61 | 143 | 51 | 1 | 89 | 1 | 0 | 0 | 1 | 82 | 61 | 143 | ||||||||||||||||||||||||||||||||||
1904228 | 1904228 | CO | school | 804350 | 2000 | MESA COUNTY VALLEY 51 | 80435000620 | 6666 | PALISADE HIGH SCHOOL | Regular School | No | High | 09 | 12 | 2018 | grade_9 | 196 | 3 | 89 | 1 | 2 | 0 | 13 | 145 | 159 | 304 | 196 | 3 | 89 | 1 | 2 | 0 | 13 | 145 | 159 | 304 | ||||||||||||||||||||||||||||||||||
1936062 | 1936062 | CO | school | 803450 | 900 | DOUGLAS COUNTY RE 1 | 80345001918 | 1367 | CASTLE VIEW HIGH SCHOOL | Regular School | No | High | 09 | 12 | 2019 | grade_9 | 423 | 5 | 89 | 4 | 13 | 0 | 23 | 298 | 259 | 557 | 423 | 5 | 89 | 4 | 13 | 0 | 23 | 298 | 259 | 557 | ||||||||||||||||||||||||||||||||||
1937206 | 1937206 | CO | school | 806480 | 990 | WIDEFIELD 3 | 80648001129 | 9566 | WIDEFIELD HIGH SCHOOL | Regular School | No | High | 09 | 12 | 2019 | grade_9 | 159 | 31 | 89 | 4 | 4 | 5 | 43 | 182 | 153 | 335 | 159 | 31 | 89 | 4 | 4 | 5 | 43 | 182 | 153 | 335 | ||||||||||||||||||||||||||||||||||
1938328 | 1938328 | CO | school | 803870 | 1110 | DISTRICT 49 | 80387001594 | 7613 | SAND CREEK HIGH SCHOOL | Regular School | No | High | 09 | 12 | 2019 | grade_9 | 150 | 34 | 89 | 3 | 15 | 0 | 27 | 166 | 152 | 318 | 150 | 34 | 89 | 3 | 15 | 0 | 27 | 166 | 152 | 318 | ||||||||||||||||||||||||||||||||||
1133339 | 1133339 | CO | school | 805550 | 10 | MAPLETON 1 | 80555006488 | 1796 | COLORADO CONNECTIONS ACADEMY | Regular School | No | 4.0 | KG | 12 | 2015 | grade_9 | 232.0 | 6.0 | 88.0 | 3.0 | 4.0 | 1.0 | 20.0 | 164.0 | 190.0 | 354.0 | 232 | 6 | 88 | 3 | 4 | 1 | 20 | 164 | 190 | 354 | ||||||||||||||||||||||||||||||||||
1142569 | 1142569 | CO | school | 803990 | 1550 | POUDRE R-1 | 80399000545 | 7470 | ROCKY MOUNTAIN HIGH SCHOOL | Regular School | No | 3.0 | 09 | 12 | 2015 | grade_9 | 407.0 | 4.0 | 88.0 | 1.0 | 17.0 | 1.0 | 21.0 | 285.0 | 254.0 | 539.0 | 407 | 4 | 88 | 1 | 17 | 1 | 21 | 285 | 254 | 539 | ||||||||||||||||||||||||||||||||||
710626 | 710626 | CO | school | 802490 | 480 | BOULDER VALLEY RE 2 | 80249000103 | 1070 | BROOMFIELD HIGH SCHOOL | Regular School | No | High | 09 | 12 | 2017 | grade_9 | 301 | 5 | 88 | 1 | 11 | 1 | 15 | 212 | 210 | 422 | 301 | 5 | 88 | 1 | 11 | 1 | 15 | 212 | 210 | 422 | ||||||||||||||||||||||||||||||||||
1743425 | 1743425 | CO | school | 803450 | 900 | Douglas County Re 1 | 80345000440 | 2230 | Douglas County High School | Regular School | No | High | 09 | 12 | 2021 | grade_9 | 346 | 2 | 88 | 3 | 15 | 1 | 39 | 258 | 236 | 494 | 346 | 2 | 88 | 3 | 15 | 1 | 39 | 258 | 236 | 494 | ||||||||||||||||||||||||||||||||||
1807375 | 1807375 | CO | school | 804800 | 1420 | Jefferson County R-1 | 80480000707 | 1864 | Columbine High School | Regular School | No | High | 09 | 12 | 2020 | grade_9 | 304 | 11 | 88 | 5 | 11 | 2 | 16 | 233 | 204 | 437 | 304 | 11 | 88 | 5 | 11 | 2 | 16 | 233 | 204 | 437 | ||||||||||||||||||||||||||||||||||
1930960 | 1930960 | CO | school | 805550 | 10 | MAPLETON 1 | 80555001857 | 187 | MAPLETON EXPEDITIONARY SCHOOL OF THE ARTS | Regular School | No | High | 07 | 12 | 2019 | grade_9 | 24 | 2 | 88 | 4 | 1 | 0 | 3 | 65 | 57 | 122 | 24 | 2 | 88 | 4 | 1 | 0 | 3 | 65 | 57 | 122 | ||||||||||||||||||||||||||||||||||
1934703 | 1934703 | CO | school | 803360 | 880 | DENVER COUNTY 1 | 80336006730 | 1529 | DSST: CONSERVATORY GREEN HIGH SCHOOL | Regular School | Yes | Secondary | 09 | 10 | 2019 | grade_9 | 20 | 30 | 88 | 1 | 7 | 0 | 8 | 95 | 59 | 154 | 20 | 30 | 88 | 1 | 7 | 0 | 8 | 95 | 59 | 154 | ||||||||||||||||||||||||||||||||||
1133242 | 1133242 | CO | school | 805550 | 10 | MAPLETON 1 | 80555001872 | 309 | ACADEMY HIGH SCHOOL | Regular School | No | 3.0 | 09 | 12 | 2015 | grade_9 | 25.0 | 3.0 | 87.0 | 0.0 | 1.0 | 0.0 | 1.0 | 63.0 | 54.0 | 117.0 | 25 | 3 | 87 | 0 | 1 | 0 | 1 | 63 | 54 | 117 | ||||||||||||||||||||||||||||||||||
1140225 | 1140225 | CO | school | 803870 | 1110 | FALCON 49 | 80387006408 | 8791 | VISTA RIDGE HIGH SCHOOL | Regular School | No | 3.0 | 09 | 12 | 2015 | grade_9 | 190.0 | 33.0 | 87.0 | 3.0 | 6.0 | 2.0 | 26.0 | 189.0 | 158.0 | 347.0 | 190 | 33 | 87 | 3 | 6 | 2 | 26 | 189 | 158 | 347 | ||||||||||||||||||||||||||||||||||
1142332 | 1142332 | CO | school | 803990 | 1550 | POUDRE R-1 | 80399000528 | 3046 | FORT COLLINS HIGH SCHOOL | Regular School | No | 3.0 | 09 | 12 | 2015 | grade_9 | 331.0 | 4.0 | 87.0 | 7.0 | 16.0 | 0.0 | 15.0 | 234.0 | 226.0 | 460.0 | 331 | 4 | 87 | 7 | 16 | 0 | 15 | 234 | 226 | 460 | ||||||||||||||||||||||||||||||||||
837029 | 837029 | CO | school | 805310 | 140 | LITTLETON 6 | 80531000884 | 5224 | LITTLETON HIGH SCHOOL | Regular School | No | 3.0 | 09 | 12 | 2016 | grade_9 | 187 | 3 | 87 | 0 | 8 | 0 | 8 | 151 | 142 | 293 | 187 | 3 | 87 | 0 | 8 | 0 | 8 | 151 | 142 | 293 | ||||||||||||||||||||||||||||||||||
837967 | 837967 | CO | school | 805370 | 470 | ST VRAIN VALLEY RE 1J | 80537000902 | 3196 | FREDERICK SENIOR HIGH SCHOOL | Regular School | No | 3.0 | 09 | 12 | 2016 | grade_9 | 152 | 2 | 87 | 1 | 3 | 0 | 0 | 118 | 127 | 245 | 152 | 2 | 87 | 1 | 3 | 0 | 0 | 118 | 127 | 245 | ||||||||||||||||||||||||||||||||||
842897 | 842897 | CO | school | 806240 | 1195 | GARFIELD RE-2 | 80624001097 | 7360 | RIFLE HIGH SCHOOL | Regular School | No | 3.0 | 09 | 12 | 2016 | grade_9 | 96 | 0 | 87 | 2 | 0 | 0 | 5 | 99 | 91 | 190 | 96 | 0 | 87 | 2 | 0 | 0 | 5 | 99 | 91 | 190 | ||||||||||||||||||||||||||||||||||
843174 | 843174 | CO | school | 1420 | JEFFERSON COUNTY R-1 | 378 | ARVADA WEST HIGH SCHOOL | 2016 | grade_9 | 353 | 2 | 87 | 4 | 15 | 0 | 18 | 243 | 236 | 479 | 353 | 2 | 87 | 4 | 15 | 0 | 18 | 243 | 236 | 479 | |||||||||||||||||||||||||||||||||||||||||
1748623 | 1748623 | CO | school | 804350 | 2000 | Mesa County Valley 51 | 80435000612 | 3570 | Grand Junction High School | Regular School | No | High | 09 | 12 | 2021 | grade_9 | 244 | 3 | 87 | 1 | 6 | 1 | 10 | 201 | 151 | 352 | 244 | 3 | 87 | 1 | 6 | 1 | 10 | 201 | 151 | 352 | ||||||||||||||||||||||||||||||||||
1896367 | 1896367 | CO | school | 805370 | 470 | ST VRAIN VALLEY RE 1J | 80537000918 | 6276 | NIWOT HIGH SCHOOL | Regular School | No | High | 09 | 12 | 2018 | grade_9 | 185 | 2 | 87 | 2 | 19 | 0 | 7 | 163 | 139 | 302 | 185 | 2 | 87 | 2 | 19 | 0 | 7 | 163 | 139 | 302 | ||||||||||||||||||||||||||||||||||
1901488 | 1901488 | CO | school | 804800 | 1420 | JEFFERSON COUNTY R-1 | 80480000695 | 378 | ARVADA WEST HIGH SCHOOL | Regular School | No | High | 09 | 12 | 2018 | grade_9 | 330 | 5 | 87 | 1 | 10 | 0 | 17 | 221 | 229 | 450 | 330 | 5 | 87 | 1 | 10 | 0 | 17 | 221 | 229 | 450 | ||||||||||||||||||||||||||||||||||
1933693 | 1933693 | CO | school | 805370 | 470 | ST VRAIN VALLEY RE 1J | 80537000918 | 6276 | NIWOT HIGH SCHOOL | Regular School | No | High | 09 | 12 | 2019 | grade_9 | 191 | 1 | 87 | 0 | 17 | 0 | 7 | 145 | 158 | 303 | 191 | 1 | 87 | 0 | 17 | 0 | 7 | 145 | 158 | 303 | ||||||||||||||||||||||||||||||||||
1943343 | 1943343 | CO | school | 804200 | 3080 | WELD COUNTY RE-1 | 80420000580 | 9032 | VALLEY HIGH SCHOOL | Regular School | No | High | 09 | 12 | 2019 | grade_9 | 57 | 1 | 87 | 0 | 2 | 0 | 2 | 76 | 73 | 149 | 57 | 1 | 87 | 0 | 2 | 0 | 2 | 76 | 73 | 149 | ||||||||||||||||||||||||||||||||||
1145164 | 1145164 | CO | school | 804200 | 3080 | WELD COUNTY RE-1 | 80420000580 | 9032 | VALLEY HIGH SCHOOL | Regular School | No | 3.0 | 09 | 12 | 2015 | grade_9 | 64.0 | 0.0 | 86.0 | 2.0 | 0.0 | 0.0 | 2.0 | 69.0 | 85.0 | 154.0 | 64 | 0 | 86 | 2 | 0 | 0 | 2 | 69 | 85 | 154 | ||||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||
1743328 | 1743328 | CO | school | 803450 | 900 | Douglas County Re 1 | 80345001918 | 1367 | Castle View High School | Regular School | No | High | 09 | 12 | 2021 | grade_9 | 399 | 3 | 86 | 2 | 10 | 0 | 21 | 262 | 259 | 521 | 399 | 3 | 86 | 2 | 10 | 0 | 21 | 262 | 259 | 521 | ||||||||||||||||||||||||||||||||||
1938903 | 1938903 | CO | school | 804800 | 1420 | JEFFERSON COUNTY R-1 | 80480000695 | 378 | ARVADA WEST HIGH SCHOOL | Regular School | No | High | 09 | 12 | 2019 | grade_9 | 337 | 5 | 86 | 0 | 10 | 0 | 14 | 228 | 224 | 452 | 337 | 5 | 86 | 0 | 10 | 0 | 14 | 228 | 224 | 452 | ||||||||||||||||||||||||||||||||||
1136917 | 1136917 | CO | school | 803360 | 880 | DENVER COUNTY 1 | 80336006636 | 2175 | DSST: COLE HIGH SCHOOL | Regular School | Yes | 4.0 | 09 | 09 | 2015 | grade_9 | 18.0 | 33.0 | 85.0 | 1.0 | 3.0 | 0.0 | 2.0 | 82.0 | 60.0 | 142.0 | 18 | 33 | 85 | 1 | 3 | 0 | 2 | 82 | 60 | 142 | ||||||||||||||||||||||||||||||||||
1138307 | 1138307 | CO | school | 803450 | 900 | DOUGLAS COUNTY RE 1 | 80345006391 | 3995 | HOPE ONLINE LEARNING ACADEMY HIGH SCHOOL | Regular School | Yes | 3.0 | 09 | 12 | 2015 | grade_9 | 20.0 | 10.0 | 85.0 | 2.0 | 0.0 | 0.0 | 1.0 | 59.0 | 59.0 | 118.0 | 20 | 10 | 85 | 2 | 0 | 0 | 1 | 59 | 59 | 118 | ||||||||||||||||||||||||||||||||||
1142775 | 1142775 | CO | school | 805400 | 1560 | THOMPSON R2-J | 80540000935 | 5316 | LOVELAND HIGH SCHOOL | Regular School | No | 3.0 | 09 | 12 | 2015 | grade_9 | 282.0 | 3.0 | 85.0 | 3.0 | 9.0 | 0.0 | 6.0 | 215.0 | 173.0 | 388.0 | 282 | 3 | 85 | 3 | 9 | 0 | 6 | 215 | 173 | 388 | ||||||||||||||||||||||||||||||||||
842620 | 842620 | CO | school | 803870 | 1110 | FALCON 49 | 80387006408 | 8791 | VISTA RIDGE HIGH SCHOOL | Regular School | No | 3.0 | 09 | 12 | 2016 | grade_9 | 256 | 28 | 85 | 2 | 15 | 2 | 29 | 223 | 194 | 417 | 256 | 28 | 85 | 2 | 15 | 2 | 29 | 223 | 194 | 417 | ||||||||||||||||||||||||||||||||||
844991 | 844991 | CO | school | 803990 | 1550 | POUDRE R-1 | 80399000545 | 7470 | ROCKY MOUNTAIN HIGH SCHOOL | Regular School | No | 3.0 | 09 | 12 | 2016 | grade_9 | 399 | 6 | 85 | 2 | 7 | 0 | 22 | 257 | 264 | 521 | 399 | 6 | 85 | 2 | 7 | 0 | 22 | 257 | 264 | 521 | ||||||||||||||||||||||||||||||||||
1799962 | 1799962 | CO | school | 802580 | 40 | School District 27J | 80258006474 | 2399 | Eagle Ridge Academy | Regular School | Yes | High | 09 | 12 | 2020 | grade_9 | 70 | 2 | 85 | 0 | 2 | 1 | 4 | 78 | 86 | 164 | 70 | 2 | 85 | 0 | 2 | 1 | 4 | 78 | 86 | 164 | ||||||||||||||||||||||||||||||||||
1802008 | 1802008 | CO | school | 805370 | 470 | St Vrain Valley RE1J | 80537000918 | 6276 | Niwot High School | Regular School | No | High | 09 | 12 | 2020 | grade_9 | 175 | 4 | 85 | 1 | 19 | 0 | 9 | 133 | 160 | 293 | 175 | 4 | 85 | 1 | 19 | 0 | 9 | 133 | 160 | 293 | ||||||||||||||||||||||||||||||||||
1805503 | 1805503 | CO | school | 806480 | 990 | Widefield 3 | 80648001129 | 9566 | Widefield High School | Regular School | No | High | 09 | 12 | 2020 | grade_9 | 159 | 30 | 85 | 2 | 6 | 6 | 32 | 161 | 159 | 320 | 159 | 30 | 85 | 2 | 6 | 6 | 32 | 161 | 159 | 320 | ||||||||||||||||||||||||||||||||||
1809259 | 1809259 | CO | school | 805400 | 1560 | Thompson R2-J | 80540001786 | 6163 | Mountain View High School | Regular School | No | High | 09 | 12 | 2020 | grade_9 | 188 | 7 | 85 | 2 | 2 | 0 | 11 | 149 | 146 | 295 | 188 | 7 | 85 | 2 | 2 | 0 | 11 | 149 | 146 | 295 | ||||||||||||||||||||||||||||||||||
1893803 | 1893803 | CO | school | 805550 | 10 | MAPLETON 1 | 80555006488 | 1796 | COLORADO CONNECTIONS ACADEMY | Regular School | No | Other | KG | 12 | 2018 | grade_9 | 228 | 11 | 85 | 2 | 5 | 2 | 24 | 178 | 179 | 357 | 228 | 11 | 85 | 2 | 5 | 2 | 24 | 178 | 179 | 357 | ||||||||||||||||||||||||||||||||||
1900582 | 1900582 | CO | school | 801920 | 1040 | ACADEMY 20 | 80192001321 | 7240 | RAMPART HIGH SCHOOL | Regular School | No | High | 09 | 12 | 2018 | grade_9 | 270 | 24 | 85 | 1 | 22 | 0 | 33 | 209 | 226 | 435 | 270 | 24 | 85 | 1 | 22 | 0 | 33 | 209 | 226 | 435 | ||||||||||||||||||||||||||||||||||
1933647 | 1933647 | CO | school | 805370 | 470 | ST VRAIN VALLEY RE 1J | 80537006423 | 5722 | MEAD HIGH SCHOOL | Regular School | No | High | 09 | 12 | 2019 | grade_9 | 197 | 0 | 85 | 1 | 7 | 0 | 10 | 162 | 138 | 300 | 197 | 0 | 85 | 1 | 7 | 0 | 10 | 162 | 138 | 300 | ||||||||||||||||||||||||||||||||||
1750661 | 1750661 | CO | school | 804830 | 3110 | Johnstown-Milliken RE-5J | 80483000810 | 7490 | Roosevelt High School | Regular School | No | High | 09 | 12 | 2021 | grade_9 | 192 | 0 | 84 | 0 | 2 | 1 | 4 | 147 | 136 | 283 | 192 | 0 | 84 | 0 | 2 | 1 | 4 | 147 | 136 | 283 | ||||||||||||||||||||||||||||||||||
1799323 | 1799323 | CO | school | 805550 | 10 | Mapleton 1 | 80555001860 | 263 | Global Leadership Academy | Regular School | No | High | 09 | 12 | 2020 | grade_9 | 3 | 1 | 84 | 0 | 2 | 0 | 1 | 46 | 45 | 91 | 3 | 1 | 84 | 0 | 2 | 0 | 1 | 46 | 45 | 91 | ||||||||||||||||||||||||||||||||||
1901950 | 1901950 | CO | school | 804800 | 1420 | JEFFERSON COUNTY R-1 | 80480000739 | 4422 | JEFFERSON JUNIOR/SENIOR HIGH SCHOOL | Regular School | No | High | 07 | 12 | 2018 | grade_9 | 20 | 6 | 84 | 4 | 0 | 0 | 0 | 56 | 58 | 114 | 20 | 6 | 84 | 4 | 0 | 0 | 0 | 56 | 58 | 114 | ||||||||||||||||||||||||||||||||||
1941600 | 1941600 | CO | school | 804350 | 2000 | MESA COUNTY VALLEY 51 | 80435000620 | 6666 | PALISADE HIGH SCHOOL | Regular School | No | High | 09 | 12 | 2019 | grade_9 | 165 | 2 | 84 | 3 | 1 | 0 | 13 | 134 | 134 | 268 | 165 | 2 | 84 | 3 | 1 | 0 | 13 | 134 | 134 | 268 | ||||||||||||||||||||||||||||||||||
1137899 | 1137899 | CO | school | 803360 | 880 | DENVER COUNTY 1 | 80336006551 | 9693 | WEST GENERATIONS ACADEMY | Regular School | No | 4.0 | 06 | 11 | 2015 | grade_9 | 8.0 | 6.0 | 83.0 | 3.0 | 0.0 | 0.0 | 2.0 | 56.0 | 46.0 | 102.0 | 8 | 6 | 83 | 3 | 0 | 0 | 2 | 56 | 46 | 102 | ||||||||||||||||||||||||||||||||||
711754 | 711754 | CO | school | 803360 | 880 | DENVER COUNTY 1 | 80336006527 | 2757 | HIGH TECH EARLY COLLEGE | Regular School | No | High | 09 | 12 | 2017 | grade_9 | 2 | 15 | 83 | 1 | 1 | 1 | 0 | 62 | 41 | 103 | 2 | 15 | 83 | 1 | 1 | 1 | 0 | 62 | 41 | 103 | ||||||||||||||||||||||||||||||||||
838352 | 838352 | CO | school | 802490 | 480 | BOULDER VALLEY RE 2 | 80249000114 | 2892 | FAIRVIEW HIGH SCHOOL | Regular School | No | 3.0 | 09 | 12 | 2016 | grade_9 | 406 | 6 | 83 | 5 | 53 | 1 | 34 | 285 | 303 | 588 | 406 | 6 | 83 | 5 | 53 | 1 | 34 | 285 | 303 | 588 | ||||||||||||||||||||||||||||||||||
840438 | 840438 | CO | school | 803450 | 900 | DOUGLAS COUNTY RE 1 | 80345001578 | 1503 | CHAPARRAL HIGH SCHOOL | Regular School | No | 3.0 | 09 | 12 | 2016 | grade_9 | 454 | 8 | 83 | 6 | 18 | 1 | 33 | 296 | 307 | 603 | 454 | 8 | 83 | 6 | 18 | 1 | 33 | 296 | 307 | 603 | ||||||||||||||||||||||||||||||||||
843351 | 843351 | CO | school | 804800 | 1420 | JEFFERSON COUNTY R-1 | 80480001543 | 2093 | DAKOTA RIDGE SENIOR HIGH SCHOOL | Regular School | No | 3.0 | 09 | 12 | 2016 | grade_9 | 292 | 3 | 83 | 3 | 16 | 0 | 11 | 201 | 207 | 408 | 292 | 3 | 83 | 3 | 16 | 0 | 11 | 201 | 207 | 408 |
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]);