enrollments
Data source: Big Local News · About: Big Local
92,494 rows where state = "CO" sorted by female_int
This data as json, CSV (advanced)
grade ✖
- pk_12_total 13,220
- grade_1 7,600
- grade_2 7,600
- grade_3 7,594
- grade_4 7,591
- grade_5 7,589
- kindergarten_full_day 6,985
- grade_6 4,878
- pre_kindergarten 4,598
- grade_7 4,208
- grade_8 4,180
- grade_11 3,424
- grade_12 3,422
- grade_10 3,416
- grade_9 3,336
- kindergarten_half_day 2,363
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1747203 | 1747203 | CO | school | 804800 | 1420 | Jefferson County R-1 | 80480006438 | 9245 | Warren Tech North | Career and Technical School | No | High | 10 | 12 | 2021 | grade_12 | 1 | 0 | 1 | 0 | 0 | 0 | 0 | 2 | 0 | 2 | 1 | 0 | 1 | 0 | 0 | 0 | 0 | 2 | 0 | 2 | ||||||||||||||||||||||||||||||||||
1747215 | 1747215 | CO | school | 804800 | 1420 | Jefferson County R-1 | 80480000798 | 9328 | Weber Elementary School | Regular School | No | Elementary | KG | 05 | 2021 | kindergarten_half_day | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | ||||||||||||||||||||||||||||||||||
1747327 | 1747327 | CO | school | 806930 | 1440 | Plainview RE-2 | 80693001198 | 6992 | Plainview Elementary School | Regular School | No | Elementary | PK | 05 | 2021 | grade_3 | 2 | 0 | 1 | 0 | 0 | 0 | 0 | 3 | 0 | 3 | 2 | 0 | 1 | 0 | 0 | 0 | 0 | 3 | 0 | 3 | ||||||||||||||||||||||||||||||||||
1747333 | 1747333 | CO | school | 806930 | 1440 | Plainview RE-2 | 80693001199 | 7009 | Plainview Junior-Senior High School | Regular School | No | High | 06 | 12 | 2021 | grade_10 | 5 | 0 | 0 | 0 | 0 | 0 | 0 | 5 | 0 | 5 | 5 | 0 | 0 | 0 | 0 | 0 | 0 | 5 | 0 | 5 | ||||||||||||||||||||||||||||||||||
1747334 | 1747334 | CO | school | 806930 | 1440 | Plainview RE-2 | 80693001199 | 7009 | Plainview Junior-Senior High School | Regular School | No | High | 06 | 12 | 2021 | grade_11 | 2 | 0 | 0 | 0 | 0 | 0 | 0 | 2 | 0 | 2 | 2 | 0 | 0 | 0 | 0 | 0 | 0 | 2 | 0 | 2 | ||||||||||||||||||||||||||||||||||
1747338 | 1747338 | CO | school | 806930 | 1440 | Plainview RE-2 | 80693001199 | 7009 | Plainview Junior-Senior High School | Regular School | No | High | 06 | 12 | 2021 | grade_9 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 2 | 0 | 2 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 2 | 0 | 2 | ||||||||||||||||||||||||||||||||||
1747471 | 1747471 | CO | school | 803480 | 1520 | Durango 9-R | 80348006614 | 2097 | District 9-R Shared School | Regular School | No | Other | KG | 12 | 2021 | grade_9 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | ||||||||||||||||||||||||||||||||||
1747581 | 1747581 | CO | school | 1550 | Poudre R-1 | 0 | Not a school | 2021 | grade_11 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | |||||||||||||||||||||||||||||||||||||||||
1747582 | 1747582 | CO | school | 1550 | Poudre R-1 | 0 | Not a school | 2021 | pk_12_total | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | |||||||||||||||||||||||||||||||||||||||||
1747790 | 1747790 | CO | school | 803990 | 1550 | Poudre R-1 | 80399001409 | 5292 | Lopez Elementary School | Regular School | No | Elementary | PK | 05 | 2021 | kindergarten_half_day | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | ||||||||||||||||||||||||||||||||||
1747810 | 1747810 | CO | school | 803990 | 1550 | Poudre R-1 | 80399006573 | 5917 | Mountain Sage Community School | Regular School | Yes | Elementary | KG | 08 | 2021 | kindergarten_half_day | 4 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 0 | 4 | 4 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 0 | 4 | ||||||||||||||||||||||||||||||||||
1747828 | 1747828 | CO | school | 803990 | 1550 | Poudre R-1 | 80399006564 | 7043 | PSD Options School | Regular School | No | Elementary | KG | 08 | 2021 | grade_2 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | ||||||||||||||||||||||||||||||||||
1747833 | 1747833 | CO | school | 803990 | 1550 | Poudre R-1 | 80399006564 | 7043 | PSD Options School | Regular School | No | Elementary | KG | 08 | 2021 | grade_7 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | ||||||||||||||||||||||||||||||||||
1748064 | 1748064 | CO | school | 805400 | 1560 | Thompson R2-J | 80540006558 | 5121 | LEAP School | Regular School | No | Other | KG | 12 | 2021 | grade_12 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | ||||||||||||||||||||||||||||||||||
1748193 | 1748193 | CO | school | 803810 | 1570 | Estes Park R-3 | 80381006426 | 2788 | Estes Park Options School | Alternative School | No | Other | KG | 12 | 2021 | grade_6 | 2 | 0 | 0 | 0 | 0 | 0 | 0 | 2 | 0 | 2 | 2 | 0 | 0 | 0 | 0 | 0 | 0 | 2 | 0 | 2 | ||||||||||||||||||||||||||||||||||
1748194 | 1748194 | CO | school | 803810 | 1570 | Estes Park R-3 | 80381006426 | 2788 | Estes Park Options School | Alternative School | No | Other | KG | 12 | 2021 | kindergarten_full_day | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | ||||||||||||||||||||||||||||||||||
1748290 | 1748290 | CO | school | 802520 | 1750 | Branson Reorganized 82 | 80252000141 | 978 | Branson School | Regular School | No | Other | PK | 12 | 2021 | grade_1 | 3 | 0 | 0 | 0 | 0 | 0 | 0 | 3 | 0 | 3 | 3 | 0 | 0 | 0 | 0 | 0 | 0 | 3 | 0 | 3 | ||||||||||||||||||||||||||||||||||
1748315 | 1748315 | CO | school | 804980 | 1760 | Kim Reorganized 88 | 80498000823 | 4694 | Kim Undivided High School | Regular School | No | High | 06 | 12 | 2021 | grade_7 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | ||||||||||||||||||||||||||||||||||
1748316 | 1748316 | CO | school | 804980 | 1760 | Kim Reorganized 88 | 80498000823 | 4694 | Kim Undivided High School | Regular School | No | High | 06 | 12 | 2021 | grade_8 | 4 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 0 | 4 | 4 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 0 | 4 | ||||||||||||||||||||||||||||||||||
1748350 | 1748350 | CO | school | 804890 | 1810 | Karval RE-23 | 80489000814 | 4502 | Karval Elementary School | Regular School | No | Elementary | PK | 06 | 2021 | grade_2 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | ||||||||||||||||||||||||||||||||||
1748610 | 1748610 | CO | school | 804350 | 2000 | Mesa County Valley 51 | 80435000611 | 3350 | Gateway School | Regular School | No | Other | PK | 12 | 2021 | grade_2 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | ||||||||||||||||||||||||||||||||||
1748654 | 1748654 | CO | school | 804350 | 2000 | Mesa County Valley 51 | 80435006581 | 4439 | Juniper Ridge Community School | Regular School | Yes | Elementary | KG | 08 | 2021 | kindergarten_half_day | 2 | 0 | 0 | 0 | 0 | 0 | 0 | 2 | 0 | 2 | 2 | 0 | 0 | 0 | 0 | 0 | 0 | 2 | 0 | 2 | ||||||||||||||||||||||||||||||||||
1748836 | 1748836 | CO | school | 805730 | 2020 | Moffat County RE: No 1 | 80573000980 | 5656 | Maybell School | Regular School | No | Elementary | KG | 06 | 2021 | grade_5 | 2 | 0 | 0 | 0 | 0 | 0 | 0 | 2 | 0 | 2 | 2 | 0 | 0 | 0 | 0 | 0 | 0 | 2 | 0 | 2 | ||||||||||||||||||||||||||||||||||
1748865 | 1748865 | CO | school | 803090 | 2035 | Montezuma-Cortez RE-1 | 80309001093 | 609 | Battle Rock Charter School | Regular School | Yes | Elementary | KG | 06 | 2021 | kindergarten_half_day | 1 | 0 | 1 | 0 | 0 | 0 | 0 | 2 | 0 | 2 | 1 | 0 | 1 | 0 | 0 | 0 | 0 | 2 | 0 | 2 | ||||||||||||||||||||||||||||||||||
1748880 | 1748880 | CO | school | 803090 | 2035 | Montezuma-Cortez RE-1 | 80309006622 | 2036 | Children's Kiva Montessori School | Regular School | Yes | Elementary | KG | 08 | 2021 | kindergarten_half_day | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | ||||||||||||||||||||||||||||||||||
1748888 | 1748888 | CO | school | 803090 | 2035 | Montezuma-Cortez RE-1 | 80309000835 | 4546 | Kemper Elementary School | Regular School | No | Elementary | KG | 05 | 2021 | kindergarten_half_day | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 1 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 1 | 0 | 1 | ||||||||||||||||||||||||||||||||||
1748903 | 1748903 | CO | school | 803090 | 2035 | Montezuma-Cortez RE-1 | 80309000838 | 5436 | Manaugh Elementary School | Regular School | No | Elementary | KG | 05 | 2021 | kindergarten_half_day | 0 | 1 | 0 | 0 | 0 | 0 | 1 | 2 | 0 | 2 | 0 | 1 | 0 | 0 | 0 | 0 | 1 | 2 | 0 | 2 | ||||||||||||||||||||||||||||||||||
1748911 | 1748911 | CO | school | 803090 | 2035 | Montezuma-Cortez RE-1 | 80309000839 | 5836 | Mesa Elementary School | Regular School | No | Elementary | KG | 05 | 2021 | kindergarten_half_day | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 1 | 0 | 1 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 1 | 0 | 1 | ||||||||||||||||||||||||||||||||||
1749000 | 1749000 | CO | school | 805790 | 2180 | Montrose County RE-1J | 80579006499 | 6262 | Peak Virtual Academy | Regular School | No | Other | KG | 12 | 2021 | grade_2 | 5 | 0 | 0 | 0 | 0 | 0 | 0 | 5 | 0 | 5 | 5 | 0 | 0 | 0 | 0 | 0 | 0 | 5 | 0 | 5 | ||||||||||||||||||||||||||||||||||
1749069 | 1749069 | CO | school | 805850 | 2190 | West End RE-2 | 80585001693 | 6718 | Paradox Valley Charter School | Regular School | Yes | Other | PK | 12 | 2021 | grade_12 | 2 | 0 | 0 | 0 | 0 | 0 | 0 | 2 | 0 | 2 | 2 | 0 | 0 | 0 | 0 | 0 | 0 | 2 | 0 | 2 | ||||||||||||||||||||||||||||||||||
1749073 | 1749073 | CO | school | 805850 | 2190 | West End RE-2 | 80585001693 | 6718 | Paradox Valley Charter School | Regular School | Yes | Other | PK | 12 | 2021 | grade_5 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | ||||||||||||||||||||||||||||||||||
1749217 | 1749217 | CO | school | 805520 | 2535 | Manzanola 3J | 80552000949 | 5498 | Manzanola Elementary School | Regular School | No | Elementary | PK | 05 | 2021 | pre_kindergarten | 3 | 0 | 0 | 0 | 0 | 0 | 0 | 3 | 0 | 3 | 3 | 0 | 0 | 0 | 0 | 0 | 0 | 3 | 0 | 3 | ||||||||||||||||||||||||||||||||||
1749327 | 1749327 | CO | school | 803840 | 2610 | Park County RE-2 | 80384001695 | 3681 | Guffey Charter School | Regular School | Yes | Elementary | PK | 08 | 2021 | grade_6 | 2 | 0 | 1 | 0 | 0 | 0 | 0 | 3 | 0 | 3 | 2 | 0 | 1 | 0 | 0 | 0 | 0 | 3 | 0 | 3 | ||||||||||||||||||||||||||||||||||
1749338 | 1749338 | CO | school | 803840 | 2610 | Park County RE-2 | 80384000501 | 4908 | Lake George Charter School | Regular School | Yes | Elementary | PK | 08 | 2021 | grade_7 | 2 | 0 | 0 | 0 | 0 | 0 | 0 | 2 | 0 | 2 | 2 | 0 | 0 | 0 | 0 | 0 | 0 | 2 | 0 | 2 | ||||||||||||||||||||||||||||||||||
1749363 | 1749363 | CO | school | 804710 | 2620 | Holyoke Re-1J | 80471006610 | 2686 | Holyoke Alternative School | Alternative School | No | High | 07 | 12 | 2021 | grade_8 | 1 | 0 | 1 | 0 | 0 | 0 | 0 | 2 | 0 | 2 | 1 | 0 | 1 | 0 | 0 | 0 | 0 | 2 | 0 | 2 | ||||||||||||||||||||||||||||||||||
1749364 | 1749364 | CO | school | 804710 | 2620 | Holyoke Re-1J | 80471006610 | 2686 | Holyoke Alternative School | Alternative School | No | High | 07 | 12 | 2021 | grade_9 | 1 | 0 | 1 | 0 | 0 | 0 | 0 | 2 | 0 | 2 | 1 | 0 | 1 | 0 | 0 | 0 | 0 | 2 | 0 | 2 | ||||||||||||||||||||||||||||||||||
1749782 | 1749782 | CO | school | 806150 | 2700 | Pueblo County 70 | 80615006496 | 5990 | 70 Online | Alternative School | No | Other | KG | 12 | 2021 | grade_6 | 1 | 0 | 2 | 0 | 0 | 0 | 0 | 3 | 0 | 3 | 1 | 0 | 2 | 0 | 0 | 0 | 0 | 3 | 0 | 3 | ||||||||||||||||||||||||||||||||||
1749985 | 1749985 | CO | school | 805760 | 2740 | Monte Vista C-8 | 80576001560 | 6520 | Monte Vista On-Line Academy | Alternative School | No | Other | 04 | 12 | 2021 | grade_5 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | ||||||||||||||||||||||||||||||||||
1750059 | 1750059 | CO | school | 806660 | 2770 | Steamboat Springs RE-2 | 80666001924 | 9757 | Yampa Valley High School | Alternative School | No | High | 09 | 12 | 2021 | grade_10 | 2 | 0 | 1 | 0 | 0 | 0 | 0 | 3 | 0 | 3 | 2 | 0 | 1 | 0 | 0 | 0 | 0 | 3 | 0 | 3 | ||||||||||||||||||||||||||||||||||
1750108 | 1750108 | CO | school | 805700 | 2800 | Moffat 2 | 80570001511 | 2018 | Crestone Charter School | Regular School | Yes | Other | KG | 12 | 2021 | grade_9 | 2 | 0 | 3 | 0 | 0 | 0 | 1 | 6 | 0 | 6 | 2 | 0 | 3 | 0 | 0 | 0 | 1 | 6 | 0 | 6 | ||||||||||||||||||||||||||||||||||
1750371 | 1750371 | CO | school | 802220 | 3040 | Arickaree R-2 | 80222000041 | 304 | Arickaree Elementary School | Regular School | No | Elementary | PK | 05 | 2021 | grade_3 | 1 | 0 | 1 | 0 | 0 | 0 | 0 | 2 | 0 | 2 | 1 | 0 | 1 | 0 | 0 | 0 | 0 | 2 | 0 | 2 | ||||||||||||||||||||||||||||||||||
1751001 | 1751001 | CO | school | 804440 | 3148 | Pawnee RE-12 | 80444000653 | 6812 | Pawnee School PK-12 | Regular School | No | Other | PK | 12 | 2021 | grade_10 | 3 | 0 | 0 | 0 | 0 | 0 | 0 | 3 | 0 | 3 | 3 | 0 | 0 | 0 | 0 | 0 | 0 | 3 | 0 | 3 | ||||||||||||||||||||||||||||||||||
1751005 | 1751005 | CO | school | 804440 | 3148 | Pawnee RE-12 | 80444000653 | 6812 | Pawnee School PK-12 | Regular School | No | Other | PK | 12 | 2021 | grade_3 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | ||||||||||||||||||||||||||||||||||
1751010 | 1751010 | CO | school | 804440 | 3148 | Pawnee RE-12 | 80444000653 | 6812 | Pawnee School PK-12 | Regular School | No | Other | PK | 12 | 2021 | grade_8 | 3 | 0 | 1 | 0 | 0 | 0 | 0 | 4 | 0 | 4 | 3 | 0 | 1 | 0 | 0 | 0 | 0 | 4 | 0 | 4 | ||||||||||||||||||||||||||||||||||
1751066 | 1751066 | CO | school | 800019 | 3230 | Liberty J-4 | 80001901744 | 5123 | Liberty School | Career and Technical School | No | Other | PK | 12 | 2021 | grade_10 | 3 | 0 | 0 | 0 | 0 | 0 | 0 | 3 | 0 | 3 | 3 | 0 | 0 | 0 | 0 | 0 | 0 | 3 | 0 | 3 | ||||||||||||||||||||||||||||||||||
1751074 | 1751074 | CO | school | 800019 | 3230 | Liberty J-4 | 80001901744 | 5123 | Liberty School | Career and Technical School | No | Other | PK | 12 | 2021 | grade_7 | 2 | 0 | 0 | 0 | 0 | 0 | 0 | 2 | 0 | 2 | 2 | 0 | 0 | 0 | 0 | 0 | 0 | 2 | 0 | 2 | ||||||||||||||||||||||||||||||||||
1751075 | 1751075 | CO | school | 800019 | 3230 | Liberty J-4 | 80001901744 | 5123 | Liberty School | Career and Technical School | No | Other | PK | 12 | 2021 | grade_8 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | ||||||||||||||||||||||||||||||||||
1751432 | 1751432 | CO | school | 800020 | 8001 | Charter School Institute | 80002006635 | 8821 | Two Rivers Community School | Regular School | Yes | Elementary | KG | 08 | 2021 | kindergarten_half_day | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | ||||||||||||||||||||||||||||||||||
1751489 | 1751489 | CO | school | 800004 | 9130 | Expeditionary BOCES | 80000400709 | 2840 | Rocky Mountain School of Expeditionary Learning | Regular School | No | Other | KG | 12 | 2021 | grade_12 | 2 | 0 | 3 | 0 | 1 | 0 | 2 | 8 | 0 | 8 | 2 | 0 | 3 | 0 | 1 | 0 | 2 | 8 | 0 | 8 | ||||||||||||||||||||||||||||||||||
1751542 | 1751542 | CO | school | 9999 | COLORADO DETENTION CENTER TOTAL | No school | COLORADO DETENTION CENTER TOTAL | 2021 | grade_7 | 3 | 1 | 1 | 0 | 0 | 0 | 0 | 5 | 0 | 5 | 3 | 1 | 1 | 0 | 0 | 0 | 0 | 5 | 0 | 5 | |||||||||||||||||||||||||||||||||||||||||
1751543 | 1751543 | CO | school | 9999 | COLORADO DETENTION CENTER TOTAL | No school | COLORADO DETENTION CENTER TOTAL | 2021 | grade_8 | 5 | 1 | 2 | 0 | 1 | 0 | 0 | 9 | 0 | 9 | 5 | 1 | 2 | 0 | 1 | 0 | 0 | 9 | 0 | 9 | |||||||||||||||||||||||||||||||||||||||||
1799457 | 1799457 | CO | school | 20 | Adams 12 Five Star Schools | 0 | Not a school | 2020 | grade_10 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | |||||||||||||||||||||||||||||||||||||||||
1799732 | 1799732 | CO | school | 806900 | 20 | Adams 12 Five Star Schools | 80690006550 | 6956 | Pathways Future Center | Alternative School | No | Other | KG | 12 | 2020 | grade_7 | 2 | 2 | 1 | 0 | 0 | 0 | 1 | 6 | 0 | 6 | 2 | 2 | 1 | 0 | 0 | 0 | 1 | 6 | 0 | 6 | ||||||||||||||||||||||||||||||||||
1800122 | 1800122 | CO | school | 806750 | 60 | Strasburg 31J | 80675001669 | 7133 | Prairie Creek High School | Alternative School | No | High | 09 | 12 | 2020 | grade_10 | 2 | 0 | 0 | 0 | 0 | 0 | 0 | 2 | 0 | 2 | 2 | 0 | 0 | 0 | 0 | 0 | 0 | 2 | 0 | 2 | ||||||||||||||||||||||||||||||||||
1800123 | 1800123 | CO | school | 806750 | 60 | Strasburg 31J | 80675001669 | 7133 | Prairie Creek High School | Alternative School | No | High | 09 | 12 | 2020 | grade_11 | 1 | 0 | 0 | 0 | 0 | 0 | 1 | 2 | 0 | 2 | 1 | 0 | 0 | 0 | 0 | 0 | 1 | 2 | 0 | 2 | ||||||||||||||||||||||||||||||||||
1800300 | 1800300 | CO | school | 802070 | 100 | Alamosa RE-11J | 80207006508 | 368 | Alamosa Ombudsman School of Excellence | Alternative School | No | High | 06 | 12 | 2020 | grade_10 | 2 | 0 | 7 | 0 | 1 | 0 | 0 | 10 | 0 | 10 | 2 | 0 | 7 | 0 | 1 | 0 | 0 | 10 | 0 | 10 | ||||||||||||||||||||||||||||||||||
1800303 | 1800303 | CO | school | 802070 | 100 | Alamosa RE-11J | 80207006508 | 368 | Alamosa Ombudsman School of Excellence | Alternative School | No | High | 06 | 12 | 2020 | grade_6 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | ||||||||||||||||||||||||||||||||||
1800304 | 1800304 | CO | school | 802070 | 100 | Alamosa RE-11J | 80207006508 | 368 | Alamosa Ombudsman School of Excellence | Alternative School | No | High | 06 | 12 | 2020 | grade_7 | 2 | 0 | 0 | 0 | 0 | 0 | 0 | 2 | 0 | 2 | 2 | 0 | 0 | 0 | 0 | 0 | 0 | 2 | 0 | 2 | ||||||||||||||||||||||||||||||||||
1801016 | 1801016 | CO | school | 180 | Adams-Arapahoe 28J | 1 | Facilities with District Run Education | 2020 | grade_11 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 1 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 1 | 0 | 1 | |||||||||||||||||||||||||||||||||||||||||
1801020 | 1801020 | CO | school | 180 | Adams-Arapahoe 28J | 1 | Facilities with District Run Education | 2020 | grade_5 | 1 | 0 | 1 | 0 | 0 | 0 | 1 | 3 | 0 | 3 | 1 | 0 | 1 | 0 | 0 | 0 | 1 | 3 | 0 | 3 | |||||||||||||||||||||||||||||||||||||||||
1801021 | 1801021 | CO | school | 180 | Adams-Arapahoe 28J | 1 | Facilities with District Run Education | 2020 | grade_6 | 0 | 0 | 2 | 0 | 0 | 0 | 0 | 2 | 0 | 2 | 0 | 0 | 2 | 0 | 0 | 0 | 0 | 2 | 0 | 2 | |||||||||||||||||||||||||||||||||||||||||
1801606 | 1801606 | CO | school | 806090 | 240 | Pritchett RE-3 | 80609001026 | 7174 | Pritchett Elementary School | Regular School | No | Elementary | PK | 05 | 2020 | kindergarten_full_day | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | ||||||||||||||||||||||||||||||||||
1801653 | 1801653 | CO | school | 802760 | 270 | Campo RE-6 | 80276000169 | 1248 | Campo Elementary School | Regular School | No | Elementary | PK | 05 | 2020 | grade_4 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | ||||||||||||||||||||||||||||||||||
1801662 | 1801662 | CO | school | 802760 | 270 | Campo RE-6 | 80276000170 | 1252 | Campo Undivided High School | Regular School | No | High | 06 | 12 | 2020 | grade_8 | 3 | 0 | 0 | 0 | 0 | 0 | 0 | 3 | 0 | 3 | 3 | 0 | 0 | 0 | 0 | 0 | 0 | 3 | 0 | 3 | ||||||||||||||||||||||||||||||||||
1802154 | 1802154 | CO | school | 802490 | 480 | Boulder Valley Re 2 | 80249006463 | 930 | Boulder Universal | Regular School | No | Other | KG | 12 | 2020 | grade_6 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | ||||||||||||||||||||||||||||||||||
1802296 | 1802296 | CO | school | 802490 | 480 | Boulder Valley Re 2 | 80249000117 | 3488 | Gold Hill Elementary School | Regular School | No | Elementary | KG | 05 | 2020 | kindergarten_full_day | 2 | 0 | 0 | 0 | 0 | 0 | 0 | 2 | 0 | 2 | 2 | 0 | 0 | 0 | 0 | 0 | 0 | 2 | 0 | 2 | ||||||||||||||||||||||||||||||||||
1802314 | 1802314 | CO | school | 802490 | 480 | Boulder Valley Re 2 | 80249000119 | 4386 | Jamestown Elementary School | Regular School | No | Elementary | KG | 05 | 2020 | grade_2 | 2 | 0 | 0 | 0 | 0 | 0 | 0 | 2 | 0 | 2 | 2 | 0 | 0 | 0 | 0 | 0 | 0 | 2 | 0 | 2 | ||||||||||||||||||||||||||||||||||
1802317 | 1802317 | CO | school | 802490 | 480 | Boulder Valley Re 2 | 80249000119 | 4386 | Jamestown Elementary School | Regular School | No | Elementary | KG | 05 | 2020 | grade_5 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | ||||||||||||||||||||||||||||||||||
1802325 | 1802325 | CO | school | 802490 | 480 | Boulder Valley Re 2 | 80249002013 | 4496 | Justice High Charter School | Alternative School | Yes | High | 06 | 12 | 2020 | grade_8 | 3 | 0 | 2 | 0 | 0 | 0 | 0 | 5 | 0 | 5 | 3 | 0 | 2 | 0 | 0 | 0 | 0 | 5 | 0 | 5 | ||||||||||||||||||||||||||||||||||
1802526 | 1802526 | CO | school | 806330 | 500 | Salida R-32 | 80633006413 | 4085 | Horizons Exploratory Academy | Alternative School | No | High | 09 | 12 | 2020 | grade_9 | 1 | 0 | 1 | 0 | 0 | 0 | 0 | 2 | 0 | 2 | 1 | 0 | 1 | 0 | 0 | 0 | 0 | 2 | 0 | 2 | ||||||||||||||||||||||||||||||||||
1802585 | 1802585 | CO | school | 803000 | 540 | Clear Creek RE-1 | 80300001999 | 3385 | Georgetown Community School | Regular School | Yes | Elementary | PK | 06 | 2020 | grade_5 | 9 | 0 | 0 | 0 | 0 | 0 | 0 | 9 | 0 | 9 | 9 | 0 | 0 | 0 | 0 | 0 | 0 | 9 | 0 | 9 | ||||||||||||||||||||||||||||||||||
1802641 | 1802641 | CO | school | 805100 | 550 | North Conejos RE-1J | 80510006601 | 6339 | North Conejos Alternative Program | Alternative School | No | Other | KG | 12 | 2020 | grade_8 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | ||||||||||||||||||||||||||||||||||
1802766 | 1802766 | CO | school | 803330 | 870 | Delta County 50(J) | 80333001953 | 2155 | Grand Mesa Choice Academy | Alternative School | No | High | 07 | 12 | 2020 | grade_7 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | ||||||||||||||||||||||||||||||||||
1802767 | 1802767 | CO | school | 803330 | 870 | Delta County 50(J) | 80333001953 | 2155 | Grand Mesa Choice Academy | Alternative School | No | High | 07 | 12 | 2020 | grade_9 | 2 | 0 | 2 | 0 | 0 | 0 | 0 | 4 | 0 | 4 | 2 | 0 | 2 | 0 | 0 | 0 | 0 | 4 | 0 | 4 | ||||||||||||||||||||||||||||||||||
1802835 | 1802835 | CO | school | 803330 | 870 | Delta County 50(J) | 80333006667 | 6295 | North Fork School of Integrated Studies | Regular School | No | Elementary | KG | 06 | 2020 | grade_5 | 3 | 0 | 0 | 1 | 0 | 0 | 0 | 4 | 0 | 4 | 3 | 0 | 0 | 1 | 0 | 0 | 0 | 4 | 0 | 4 | ||||||||||||||||||||||||||||||||||
1802860 | 1802860 | CO | school | 803360 | 880 | Denver County 1 | 80336001724 | 40 | Ridge View Academy Charter School | Alternative School | Yes | High | 07 | 12 | 2020 | grade_10 | 6 | 1 | 6 | 0 | 0 | 1 | 1 | 15 | 0 | 15 | 6 | 1 | 6 | 0 | 0 | 1 | 1 | 15 | 0 | 15 | ||||||||||||||||||||||||||||||||||
1802861 | 1802861 | CO | school | 803360 | 880 | Denver County 1 | 80336001724 | 40 | Ridge View Academy Charter School | Alternative School | Yes | High | 07 | 12 | 2020 | grade_11 | 1 | 2 | 2 | 1 | 0 | 0 | 0 | 6 | 0 | 6 | 1 | 2 | 2 | 1 | 0 | 0 | 0 | 6 | 0 | 6 | ||||||||||||||||||||||||||||||||||
1802862 | 1802862 | CO | school | 803360 | 880 | Denver County 1 | 80336001724 | 40 | Ridge View Academy Charter School | Alternative School | Yes | High | 07 | 12 | 2020 | grade_12 | 12 | 11 | 15 | 0 | 0 | 1 | 2 | 41 | 0 | 41 | 12 | 11 | 15 | 0 | 0 | 1 | 2 | 41 | 0 | 41 | ||||||||||||||||||||||||||||||||||
1802863 | 1802863 | CO | school | 803360 | 880 | Denver County 1 | 80336001724 | 40 | Ridge View Academy Charter School | Alternative School | Yes | High | 07 | 12 | 2020 | grade_8 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | ||||||||||||||||||||||||||||||||||
1802864 | 1802864 | CO | school | 803360 | 880 | Denver County 1 | 80336001724 | 40 | Ridge View Academy Charter School | Alternative School | Yes | High | 07 | 12 | 2020 | grade_9 | 15 | 6 | 24 | 0 | 0 | 0 | 1 | 46 | 0 | 46 | 15 | 6 | 24 | 0 | 0 | 0 | 1 | 46 | 0 | 46 | ||||||||||||||||||||||||||||||||||
1802865 | 1802865 | CO | school | 803360 | 880 | Denver County 1 | 80336001724 | 40 | Ridge View Academy Charter School | Alternative School | Yes | High | 07 | 12 | 2020 | pk_12_total | 35 | 20 | 47 | 1 | 0 | 2 | 4 | 109 | 0 | 109 | 35 | 20 | 47 | 1 | 0 | 2 | 4 | 109 | 0 | 109 | ||||||||||||||||||||||||||||||||||
1802982 | 1802982 | CO | school | 803360 | 880 | Denver County 1 | 80336000323 | 1324 | Carson Elementary School | Regular School | No | Elementary | PK | 05 | 2020 | pre_kindergarten | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | ||||||||||||||||||||||||||||||||||
1803187 | 1803187 | CO | school | 803360 | 880 | Denver County 1 | 80336006516 | 2188 | Denver Center for 21st-Century Learning at Wyman | Alternative School | No | High | 06 | 12 | 2020 | grade_6 | 0 | 3 | 2 | 0 | 0 | 0 | 0 | 5 | 0 | 5 | 0 | 3 | 2 | 0 | 0 | 0 | 0 | 5 | 0 | 5 | ||||||||||||||||||||||||||||||||||
1803188 | 1803188 | CO | school | 803360 | 880 | Denver County 1 | 80336006516 | 2188 | Denver Center for 21st-Century Learning at Wyman | Alternative School | No | High | 06 | 12 | 2020 | grade_7 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 2 | 0 | 2 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 2 | 0 | 2 | ||||||||||||||||||||||||||||||||||
1803310 | 1803310 | CO | school | 803360 | 880 | Denver County 1 | 80336006685 | 2919 | Sandra Todd-Williams Academy | Regular School | No | Elementary | PK | KG | 2020 | kindergarten_full_day | 0 | 2 | 0 | 0 | 1 | 0 | 0 | 3 | 0 | 3 | 0 | 2 | 0 | 0 | 1 | 0 | 0 | 3 | 0 | 3 | ||||||||||||||||||||||||||||||||||
1804090 | 1804090 | CO | school | 803360 | 880 | Denver County 1 | 80336006734 | 8787 | The Boys School of Denver | Regular School | Yes | Middle | 06 | 08 | 2020 | grade_6 | 17 | 1 | 12 | 0 | 1 | 0 | 3 | 34 | 0 | 34 | 17 | 1 | 12 | 0 | 1 | 0 | 3 | 34 | 0 | 34 | ||||||||||||||||||||||||||||||||||
1804091 | 1804091 | CO | school | 803360 | 880 | Denver County 1 | 80336006734 | 8787 | The Boys School of Denver | Regular School | Yes | Middle | 06 | 08 | 2020 | grade_7 | 17 | 3 | 23 | 1 | 0 | 1 | 1 | 46 | 0 | 46 | 17 | 3 | 23 | 1 | 0 | 1 | 1 | 46 | 0 | 46 | ||||||||||||||||||||||||||||||||||
1804092 | 1804092 | CO | school | 803360 | 880 | Denver County 1 | 80336006734 | 8787 | The Boys School of Denver | Regular School | Yes | Middle | 06 | 08 | 2020 | grade_8 | 35 | 5 | 14 | 1 | 1 | 0 | 4 | 60 | 0 | 60 | 35 | 5 | 14 | 1 | 1 | 0 | 4 | 60 | 0 | 60 | ||||||||||||||||||||||||||||||||||
1804093 | 1804093 | CO | school | 803360 | 880 | Denver County 1 | 80336006734 | 8787 | The Boys School of Denver | Regular School | Yes | Middle | 06 | 08 | 2020 | pk_12_total | 69 | 9 | 49 | 2 | 2 | 1 | 8 | 140 | 0 | 140 | 69 | 9 | 49 | 2 | 2 | 1 | 8 | 140 | 0 | 140 | ||||||||||||||||||||||||||||||||||
1804392 | 1804392 | CO | school | 803450 | 900 | Douglas County Re 1 | 80345006494 | 1555 | Cloverleaf Home Education | Alternative School | No | Other | KG | 12 | 2020 | grade_10 | 3 | 0 | 0 | 0 | 0 | 0 | 0 | 3 | 0 | 3 | 3 | 0 | 0 | 0 | 0 | 0 | 0 | 3 | 0 | 3 | ||||||||||||||||||||||||||||||||||
1804407 | 1804407 | CO | school | 803450 | 900 | Douglas County Re 1 | 80345000439 | 1578 | Cherry Valley Elementary School | Regular School | No | Elementary | KG | 06 | 2020 | grade_3 | 2 | 0 | 0 | 0 | 0 | 0 | 0 | 2 | 0 | 2 | 2 | 0 | 0 | 0 | 0 | 0 | 0 | 2 | 0 | 2 | ||||||||||||||||||||||||||||||||||
1804450 | 1804450 | CO | school | 803450 | 900 | Douglas County Re 1 | 80345001526 | 1925 | Cougar Run Elementary School | Regular School | No | Elementary | KG | 06 | 2020 | kindergarten_half_day | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | ||||||||||||||||||||||||||||||||||
1804500 | 1804500 | CO | school | 803450 | 900 | Douglas County Re 1 | 80345001527 | 2338 | Eagle Academy | Alternative School | No | High | 09 | 12 | 2020 | grade_10 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | ||||||||||||||||||||||||||||||||||
1804553 | 1804553 | CO | school | 803450 | 900 | Douglas County Re 1 | 80345001275 | 3138 | Fox Creek Elementary School | Regular School | No | Elementary | PK | 06 | 2020 | kindergarten_half_day | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | ||||||||||||||||||||||||||||||||||
1804571 | 1804571 | CO | school | 803450 | 900 | Douglas County Re 1 | 80345001875 | 3241 | Frontier Valley Elementary School | Regular School | No | Elementary | PK | 05 | 2020 | kindergarten_half_day | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | ||||||||||||||||||||||||||||||||||
1804623 | 1804623 | CO | school | 803450 | 900 | Douglas County Re 1 | 80345001638 | 4292 | Iron Horse Elementary School | Regular School | No | Elementary | PK | 05 | 2020 | kindergarten_half_day | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | ||||||||||||||||||||||||||||||||||
1804680 | 1804680 | CO | school | 803450 | 900 | Douglas County Re 1 | 80345006472 | 5607 | Sage Canyon Elementary | Regular School | No | Elementary | PK | 06 | 2020 | kindergarten_half_day | 4 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 0 | 4 | 4 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 0 | 4 | ||||||||||||||||||||||||||||||||||
1805068 | 1805068 | CO | school | 803540 | 910 | Eagle County RE 50 | 80354006366 | 4838 | June Creek Elementary School | Regular School | No | Elementary | PK | 05 | 2020 | kindergarten_half_day | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | ||||||||||||||||||||||||||||||||||
1805102 | 1805102 | CO | school | 803540 | 910 | Eagle County RE 50 | 80354006533 | 9701 | World Academy | Regular School | No | Other | KG | 12 | 2020 | grade_4 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | ||||||||||||||||||||||||||||||||||
1805131 | 1805131 | CO | school | 803720 | 920 | Elizabeth School District | 80372001775 | 3236 | Frontier High School | Alternative School | No | High | 09 | 12 | 2020 | grade_9 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 1 |
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]);