enrollments
Data source: Big Local News · About: Big Local
13,286 rows where state = "CO" and year = 2021 sorted by hispanic
This data as json, CSV (advanced)
grade ✖
- pk_12_total 1,920
- grade_5 1,114
- grade_2 1,109
- grade_4 1,109
- grade_3 1,108
- grade_1 1,106
- kindergarten_full_day 1,094
- grade_6 694
- pre_kindergarten 685
- grade_7 634
- grade_8 627
- grade_11 509
- grade_12 508
- grade_10 505
- grade_9 495
- kindergarten_half_day 69
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1739061 | 1739061 | CO | school | 806750 | 60 | Strasburg 31J | 80675001669 | 7133 | Prairie Creek High School | Alternative School | No | High | 09 | 12 | 2021 | grade_10 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | ||||||||||||||||||||||||||||||||||
1739062 | 1739062 | CO | school | 806750 | 60 | Strasburg 31J | 80675001669 | 7133 | Prairie Creek High School | Alternative School | No | High | 09 | 12 | 2021 | grade_11 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 1 | ||||||||||||||||||||||||||||||||||
1739430 | 1739430 | CO | school | 802910 | 130 | Cherry Creek 5 | 80291006791 | 1429 | Cherry Creek Elevation | Regular School | No | High | 06 | 12 | 2021 | grade_6 | 1 | 0 | 0 | 0 | 1 | 0 | 0 | 1 | 1 | 2 | 1 | 0 | 0 | 0 | 1 | 0 | 0 | 1 | 1 | 2 | ||||||||||||||||||||||||||||||||||
1739431 | 1739431 | CO | school | 802910 | 130 | Cherry Creek 5 | 80291006791 | 1429 | Cherry Creek Elevation | Regular School | No | High | 06 | 12 | 2021 | grade_7 | 3 | 1 | 0 | 0 | 0 | 0 | 0 | 3 | 1 | 4 | 3 | 1 | 0 | 0 | 0 | 0 | 0 | 3 | 1 | 4 | ||||||||||||||||||||||||||||||||||
1739432 | 1739432 | CO | school | 802910 | 130 | Cherry Creek 5 | 80291006791 | 1429 | Cherry Creek Elevation | Regular School | No | High | 06 | 12 | 2021 | grade_8 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | ||||||||||||||||||||||||||||||||||
1739433 | 1739433 | CO | school | 802910 | 130 | Cherry Creek 5 | 80291006791 | 1429 | Cherry Creek Elevation | Regular School | No | High | 06 | 12 | 2021 | grade_9 | 1 | 0 | 0 | 1 | 0 | 0 | 0 | 1 | 1 | 2 | 1 | 0 | 0 | 1 | 0 | 0 | 0 | 1 | 1 | 2 | ||||||||||||||||||||||||||||||||||
1739877 | 1739877 | CO | school | 805310 | 140 | Littleton 6 | 80531001515 | 5229 | Littleton Academy | Regular School | Yes | Elementary | KG | 08 | 2021 | grade_7 | 36 | 1 | 0 | 0 | 3 | 0 | 3 | 21 | 22 | 43 | 36 | 1 | 0 | 0 | 3 | 0 | 3 | 21 | 22 | 43 | ||||||||||||||||||||||||||||||||||
1739969 | 1739969 | CO | school | 180 | Adams-Arapahoe 28J | 1 | Facilities with District Run Education | 2021 | grade_11 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 1 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 1 | |||||||||||||||||||||||||||||||||||||||||
1739972 | 1739972 | CO | school | 180 | Adams-Arapahoe 28J | 1 | Facilities with District Run Education | 2021 | grade_4 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 1 | 1 | |||||||||||||||||||||||||||||||||||||||||
1739976 | 1739976 | CO | school | 180 | Adams-Arapahoe 28J | 1 | Facilities with District Run Education | 2021 | grade_9 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 1 | |||||||||||||||||||||||||||||||||||||||||
1740533 | 1740533 | CO | school | 802190 | 220 | Archuleta County 50 Jt | 80219000038 | 6652 | Pagosa Springs Elementary School | Regular School | No | Elementary | KG | 04 | 2021 | kindergarten_half_day | 2 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 2 | 2 | 2 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 2 | 2 | ||||||||||||||||||||||||||||||||||
1740554 | 1740554 | CO | school | 807110 | 230 | Walsh RE-1 | 80711001215 | 9222 | Walsh Elementary School | Regular School | No | Elementary | PK | 06 | 2021 | grade_1 | 14 | 0 | 0 | 0 | 0 | 0 | 0 | 6 | 8 | 14 | 14 | 0 | 0 | 0 | 0 | 0 | 0 | 6 | 8 | 14 | ||||||||||||||||||||||||||||||||||
1740560 | 1740560 | CO | school | 807110 | 230 | Walsh RE-1 | 80711001215 | 9222 | Walsh Elementary School | Regular School | No | Elementary | PK | 06 | 2021 | kindergarten_full_day | 10 | 0 | 0 | 0 | 0 | 0 | 0 | 7 | 3 | 10 | 10 | 0 | 0 | 0 | 0 | 0 | 0 | 7 | 3 | 10 | ||||||||||||||||||||||||||||||||||
1740563 | 1740563 | CO | school | 807110 | 230 | Walsh RE-1 | 80711001216 | 9226 | Walsh High School | Regular School | No | High | 07 | 12 | 2021 | grade_10 | 3 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 3 | 3 | 3 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 3 | 3 | ||||||||||||||||||||||||||||||||||
1740564 | 1740564 | CO | school | 807110 | 230 | Walsh RE-1 | 80711001216 | 9226 | Walsh High School | Regular School | No | High | 07 | 12 | 2021 | grade_11 | 6 | 0 | 0 | 0 | 0 | 0 | 0 | 2 | 4 | 6 | 6 | 0 | 0 | 0 | 0 | 0 | 0 | 2 | 4 | 6 | ||||||||||||||||||||||||||||||||||
1740570 | 1740570 | CO | school | 806090 | 240 | Pritchett RE-3 | 80609001026 | 7174 | Pritchett Elementary School | Regular School | No | Elementary | PK | 05 | 2021 | grade_1 | 3 | 0 | 0 | 0 | 0 | 0 | 0 | 2 | 1 | 3 | 3 | 0 | 0 | 0 | 0 | 0 | 0 | 2 | 1 | 3 | ||||||||||||||||||||||||||||||||||
1740575 | 1740575 | CO | school | 806090 | 240 | Pritchett RE-3 | 80609001026 | 7174 | Pritchett Elementary School | Regular School | No | Elementary | PK | 05 | 2021 | kindergarten_full_day | 6 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 5 | 6 | 6 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 5 | 6 | ||||||||||||||||||||||||||||||||||
1740577 | 1740577 | CO | school | 806090 | 240 | Pritchett RE-3 | 80609001026 | 7174 | Pritchett Elementary School | Regular School | No | Elementary | PK | 05 | 2021 | pre_kindergarten | 5 | 0 | 0 | 0 | 0 | 0 | 0 | 3 | 2 | 5 | 5 | 0 | 0 | 0 | 0 | 0 | 0 | 3 | 2 | 5 | ||||||||||||||||||||||||||||||||||
1740579 | 1740579 | CO | school | 806090 | 240 | Pritchett RE-3 | 80609001952 | 7176 | Pritchett Middle School | Regular School | No | Middle | 06 | 08 | 2021 | grade_7 | 4 | 0 | 0 | 0 | 0 | 0 | 0 | 2 | 2 | 4 | 4 | 0 | 0 | 0 | 0 | 0 | 0 | 2 | 2 | 4 | ||||||||||||||||||||||||||||||||||
1740583 | 1740583 | CO | school | 806090 | 240 | Pritchett RE-3 | 80609001027 | 7180 | Pritchett High School | Regular School | No | High | 09 | 12 | 2021 | grade_11 | 4 | 0 | 0 | 0 | 0 | 0 | 0 | 2 | 2 | 4 | 4 | 0 | 0 | 0 | 0 | 0 | 0 | 2 | 2 | 4 | ||||||||||||||||||||||||||||||||||
1740595 | 1740595 | CO | school | 806630 | 250 | Springfield RE-4 | 80663001142 | 8168 | Springfield Junior/Senior High School | Regular School | No | High | 06 | 12 | 2021 | grade_10 | 14 | 0 | 0 | 0 | 0 | 0 | 0 | 6 | 8 | 14 | 14 | 0 | 0 | 0 | 0 | 0 | 0 | 6 | 8 | 14 | ||||||||||||||||||||||||||||||||||
1740596 | 1740596 | CO | school | 806630 | 250 | Springfield RE-4 | 80663001142 | 8168 | Springfield Junior/Senior High School | Regular School | No | High | 06 | 12 | 2021 | grade_11 | 7 | 1 | 0 | 0 | 0 | 0 | 2 | 6 | 4 | 10 | 7 | 1 | 0 | 0 | 0 | 0 | 2 | 6 | 4 | 10 | ||||||||||||||||||||||||||||||||||
1740604 | 1740604 | CO | school | 806990 | 260 | Vilas RE-5 | 80699001206 | 9090 | Vilas Elementary School | Regular School | No | Elementary | PK | 06 | 2021 | grade_2 | 12 | 1 | 0 | 0 | 2 | 0 | 1 | 8 | 8 | 16 | 12 | 1 | 0 | 0 | 2 | 0 | 1 | 8 | 8 | 16 | ||||||||||||||||||||||||||||||||||
1740605 | 1740605 | CO | school | 806990 | 260 | Vilas RE-5 | 80699001206 | 9090 | Vilas Elementary School | Regular School | No | Elementary | PK | 06 | 2021 | grade_3 | 21 | 0 | 0 | 0 | 0 | 0 | 1 | 9 | 13 | 22 | 21 | 0 | 0 | 0 | 0 | 0 | 1 | 9 | 13 | 22 | ||||||||||||||||||||||||||||||||||
1740607 | 1740607 | CO | school | 806990 | 260 | Vilas RE-5 | 80699001206 | 9090 | Vilas Elementary School | Regular School | No | Elementary | PK | 06 | 2021 | grade_5 | 13 | 1 | 0 | 0 | 1 | 0 | 0 | 12 | 3 | 15 | 13 | 1 | 0 | 0 | 1 | 0 | 0 | 12 | 3 | 15 | ||||||||||||||||||||||||||||||||||
1740609 | 1740609 | CO | school | 806990 | 260 | Vilas RE-5 | 80699001206 | 9090 | Vilas Elementary School | Regular School | No | Elementary | PK | 06 | 2021 | kindergarten_full_day | 8 | 1 | 0 | 0 | 0 | 1 | 1 | 6 | 5 | 11 | 8 | 1 | 0 | 0 | 0 | 1 | 1 | 6 | 5 | 11 | ||||||||||||||||||||||||||||||||||
1740620 | 1740620 | CO | school | 802760 | 270 | Campo RE-6 | 80276000169 | 1248 | Campo Elementary School | Regular School | No | Elementary | PK | 05 | 2021 | grade_2 | 2 | 0 | 0 | 0 | 0 | 0 | 1 | 2 | 1 | 3 | 2 | 0 | 0 | 0 | 0 | 0 | 1 | 2 | 1 | 3 | ||||||||||||||||||||||||||||||||||
1740624 | 1740624 | CO | school | 802760 | 270 | Campo RE-6 | 80276000169 | 1248 | Campo Elementary School | Regular School | No | Elementary | PK | 05 | 2021 | kindergarten_full_day | 1 | 0 | 0 | 0 | 0 | 0 | 1 | 2 | 0 | 2 | 1 | 0 | 0 | 0 | 0 | 0 | 1 | 2 | 0 | 2 | ||||||||||||||||||||||||||||||||||
1740626 | 1740626 | CO | school | 802760 | 270 | Campo RE-6 | 80276000169 | 1248 | Campo Elementary School | Regular School | No | Elementary | PK | 05 | 2021 | pre_kindergarten | 4 | 0 | 0 | 0 | 0 | 0 | 1 | 2 | 3 | 5 | 4 | 0 | 0 | 0 | 0 | 0 | 1 | 2 | 3 | 5 | ||||||||||||||||||||||||||||||||||
1740627 | 1740627 | CO | school | 802760 | 270 | Campo RE-6 | 80276000170 | 1252 | Campo Undivided High School | Regular School | No | High | 06 | 12 | 2021 | grade_10 | 1 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 2 | 2 | 1 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 2 | 2 | ||||||||||||||||||||||||||||||||||
1740628 | 1740628 | CO | school | 802760 | 270 | Campo RE-6 | 80276000170 | 1252 | Campo Undivided High School | Regular School | No | High | 06 | 12 | 2021 | grade_11 | 4 | 0 | 0 | 0 | 0 | 0 | 0 | 2 | 2 | 4 | 4 | 0 | 0 | 0 | 0 | 0 | 0 | 2 | 2 | 4 | ||||||||||||||||||||||||||||||||||
1740629 | 1740629 | CO | school | 802760 | 270 | Campo RE-6 | 80276000170 | 1252 | Campo Undivided High School | Regular School | No | High | 06 | 12 | 2021 | grade_12 | 3 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 2 | 3 | 3 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 2 | 3 | ||||||||||||||||||||||||||||||||||
1740631 | 1740631 | CO | school | 802760 | 270 | Campo RE-6 | 80276000170 | 1252 | Campo Undivided High School | Regular School | No | High | 06 | 12 | 2021 | grade_7 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 1 | ||||||||||||||||||||||||||||||||||
1740669 | 1740669 | CO | school | 805580 | 310 | McClave Re-2 | 80558000962 | 5666 | McClave Elementary School | Regular School | No | Elementary | PK | 06 | 2021 | grade_1 | 14 | 0 | 0 | 0 | 0 | 0 | 0 | 7 | 7 | 14 | 14 | 0 | 0 | 0 | 0 | 0 | 0 | 7 | 7 | 14 | ||||||||||||||||||||||||||||||||||
1740670 | 1740670 | CO | school | 805580 | 310 | McClave Re-2 | 80558000962 | 5666 | McClave Elementary School | Regular School | No | Elementary | PK | 06 | 2021 | grade_2 | 7 | 0 | 0 | 0 | 0 | 0 | 0 | 3 | 4 | 7 | 7 | 0 | 0 | 0 | 0 | 0 | 0 | 3 | 4 | 7 | ||||||||||||||||||||||||||||||||||
1740671 | 1740671 | CO | school | 805580 | 310 | McClave Re-2 | 80558000962 | 5666 | McClave Elementary School | Regular School | No | Elementary | PK | 06 | 2021 | grade_3 | 13 | 1 | 0 | 0 | 0 | 0 | 0 | 6 | 8 | 14 | 13 | 1 | 0 | 0 | 0 | 0 | 0 | 6 | 8 | 14 | ||||||||||||||||||||||||||||||||||
1740672 | 1740672 | CO | school | 805580 | 310 | McClave Re-2 | 80558000962 | 5666 | McClave Elementary School | Regular School | No | Elementary | PK | 06 | 2021 | grade_4 | 12 | 1 | 0 | 0 | 0 | 0 | 0 | 8 | 5 | 13 | 12 | 1 | 0 | 0 | 0 | 0 | 0 | 8 | 5 | 13 | ||||||||||||||||||||||||||||||||||
1740673 | 1740673 | CO | school | 805580 | 310 | McClave Re-2 | 80558000962 | 5666 | McClave Elementary School | Regular School | No | Elementary | PK | 06 | 2021 | grade_5 | 18 | 0 | 0 | 0 | 0 | 0 | 0 | 7 | 11 | 18 | 18 | 0 | 0 | 0 | 0 | 0 | 0 | 7 | 11 | 18 | ||||||||||||||||||||||||||||||||||
1740674 | 1740674 | CO | school | 805580 | 310 | McClave Re-2 | 80558000962 | 5666 | McClave Elementary School | Regular School | No | Elementary | PK | 06 | 2021 | grade_6 | 24 | 0 | 0 | 0 | 0 | 0 | 0 | 16 | 8 | 24 | 24 | 0 | 0 | 0 | 0 | 0 | 0 | 16 | 8 | 24 | ||||||||||||||||||||||||||||||||||
1740675 | 1740675 | CO | school | 805580 | 310 | McClave Re-2 | 80558000962 | 5666 | McClave Elementary School | Regular School | No | Elementary | PK | 06 | 2021 | kindergarten_full_day | 11 | 0 | 0 | 0 | 0 | 0 | 0 | 6 | 5 | 11 | 11 | 0 | 0 | 0 | 0 | 0 | 0 | 6 | 5 | 11 | ||||||||||||||||||||||||||||||||||
1740676 | 1740676 | CO | school | 805580 | 310 | McClave Re-2 | 80558000962 | 5666 | McClave Elementary School | Regular School | No | Elementary | PK | 06 | 2021 | pk_12_total | 111 | 2 | 0 | 0 | 0 | 0 | 0 | 61 | 52 | 113 | 111 | 2 | 0 | 0 | 0 | 0 | 0 | 61 | 52 | 113 | ||||||||||||||||||||||||||||||||||
1740677 | 1740677 | CO | school | 805580 | 310 | McClave Re-2 | 80558000962 | 5666 | McClave Elementary School | Regular School | No | Elementary | PK | 06 | 2021 | pre_kindergarten | 12 | 0 | 0 | 0 | 0 | 0 | 0 | 8 | 4 | 12 | 12 | 0 | 0 | 0 | 0 | 0 | 0 | 8 | 4 | 12 | ||||||||||||||||||||||||||||||||||
1740678 | 1740678 | CO | school | 805580 | 310 | McClave Re-2 | 80558000963 | 5670 | McClave Undivided High School | Regular School | No | High | 07 | 12 | 2021 | grade_10 | 16 | 0 | 0 | 0 | 0 | 0 | 1 | 7 | 10 | 17 | 16 | 0 | 0 | 0 | 0 | 0 | 1 | 7 | 10 | 17 | ||||||||||||||||||||||||||||||||||
1740679 | 1740679 | CO | school | 805580 | 310 | McClave Re-2 | 80558000963 | 5670 | McClave Undivided High School | Regular School | No | High | 07 | 12 | 2021 | grade_11 | 14 | 0 | 0 | 0 | 0 | 0 | 0 | 3 | 11 | 14 | 14 | 0 | 0 | 0 | 0 | 0 | 0 | 3 | 11 | 14 | ||||||||||||||||||||||||||||||||||
1740680 | 1740680 | CO | school | 805580 | 310 | McClave Re-2 | 80558000963 | 5670 | McClave Undivided High School | Regular School | No | High | 07 | 12 | 2021 | grade_12 | 8 | 0 | 0 | 0 | 0 | 0 | 1 | 2 | 7 | 9 | 8 | 0 | 0 | 0 | 0 | 0 | 1 | 2 | 7 | 9 | ||||||||||||||||||||||||||||||||||
1740681 | 1740681 | CO | school | 805580 | 310 | McClave Re-2 | 80558000963 | 5670 | McClave Undivided High School | Regular School | No | High | 07 | 12 | 2021 | grade_7 | 26 | 0 | 0 | 0 | 0 | 0 | 0 | 13 | 13 | 26 | 26 | 0 | 0 | 0 | 0 | 0 | 0 | 13 | 13 | 26 | ||||||||||||||||||||||||||||||||||
1740682 | 1740682 | CO | school | 805580 | 310 | McClave Re-2 | 80558000963 | 5670 | McClave Undivided High School | Regular School | No | High | 07 | 12 | 2021 | grade_8 | 13 | 0 | 0 | 0 | 0 | 0 | 0 | 6 | 7 | 13 | 13 | 0 | 0 | 0 | 0 | 0 | 0 | 6 | 7 | 13 | ||||||||||||||||||||||||||||||||||
1740683 | 1740683 | CO | school | 805580 | 310 | McClave Re-2 | 80558000963 | 5670 | McClave Undivided High School | Regular School | No | High | 07 | 12 | 2021 | grade_9 | 21 | 0 | 0 | 0 | 0 | 0 | 1 | 14 | 8 | 22 | 21 | 0 | 0 | 0 | 0 | 0 | 1 | 14 | 8 | 22 | ||||||||||||||||||||||||||||||||||
1740684 | 1740684 | CO | school | 805580 | 310 | McClave Re-2 | 80558000963 | 5670 | McClave Undivided High School | Regular School | No | High | 07 | 12 | 2021 | pk_12_total | 98 | 0 | 0 | 0 | 0 | 0 | 3 | 45 | 56 | 101 | 98 | 0 | 0 | 0 | 0 | 0 | 3 | 45 | 56 | 101 | ||||||||||||||||||||||||||||||||||
1740743 | 1740743 | CO | school | 805370 | 470 | St Vrain Valley RE1J | 80537006381 | 878 | Blue Mountain Elementary | Regular School | No | Elementary | PK | 05 | 2021 | pre_kindergarten | 28 | 0 | 0 | 0 | 5 | 0 | 0 | 17 | 16 | 33 | 28 | 0 | 0 | 0 | 5 | 0 | 0 | 17 | 16 | 33 | ||||||||||||||||||||||||||||||||||
1740827 | 1740827 | CO | school | 805370 | 470 | St Vrain Valley RE1J | 80537001890 | 2964 | Flagstaff Charter Academy | Regular School | Yes | Elementary | PK | 08 | 2021 | kindergarten_half_day | 15 | 0 | 0 | 0 | 2 | 0 | 1 | 8 | 10 | 18 | 15 | 0 | 0 | 0 | 2 | 0 | 1 | 8 | 10 | 18 | ||||||||||||||||||||||||||||||||||
1740883 | 1740883 | CO | school | 805370 | 470 | St Vrain Valley RE1J | 80537006388 | 4333 | Firestone Charter Academy | Regular School | Yes | Elementary | PK | 08 | 2021 | pre_kindergarten | 6 | 0 | 0 | 0 | 0 | 0 | 0 | 5 | 1 | 6 | 6 | 0 | 0 | 0 | 0 | 0 | 0 | 5 | 1 | 6 | ||||||||||||||||||||||||||||||||||
1741034 | 1741034 | CO | school | 805370 | 470 | St Vrain Valley RE1J | 80537006532 | 7839 | St. Vrain Global Online Academy | Alternative School | No | High | 09 | 12 | 2021 | grade_9 | 6 | 0 | 0 | 0 | 0 | 1 | 0 | 3 | 4 | 7 | 6 | 0 | 0 | 0 | 0 | 1 | 0 | 3 | 4 | 7 | ||||||||||||||||||||||||||||||||||
1741094 | 1741094 | CO | school | 802490 | 480 | Boulder Valley Re 2 | 80249000099 | 652 | Bear Creek Elementary School | Regular School | No | Elementary | KG | 05 | 2021 | kindergarten_full_day | 24 | 0 | 0 | 0 | 0 | 0 | 5 | 14 | 15 | 29 | 24 | 0 | 0 | 0 | 0 | 0 | 5 | 14 | 15 | 29 | ||||||||||||||||||||||||||||||||||
1741253 | 1741253 | CO | school | 802490 | 480 | Boulder Valley Re 2 | 80249000115 | 2970 | Flatirons Elementary School | Regular School | No | Elementary | KG | 05 | 2021 | grade_5 | 34 | 0 | 0 | 0 | 1 | 0 | 3 | 23 | 15 | 38 | 34 | 0 | 0 | 0 | 1 | 0 | 3 | 23 | 15 | 38 | ||||||||||||||||||||||||||||||||||
1741254 | 1741254 | CO | school | 802490 | 480 | Boulder Valley Re 2 | 80249000115 | 2970 | Flatirons Elementary School | Regular School | No | Elementary | KG | 05 | 2021 | kindergarten_full_day | 21 | 0 | 0 | 0 | 0 | 0 | 2 | 14 | 9 | 23 | 21 | 0 | 0 | 0 | 0 | 0 | 2 | 14 | 9 | 23 | ||||||||||||||||||||||||||||||||||
1741264 | 1741264 | CO | school | 802490 | 480 | Boulder Valley Re 2 | 80249000117 | 3488 | Gold Hill Elementary School | Regular School | No | Elementary | KG | 05 | 2021 | grade_2 | 5 | 0 | 0 | 0 | 0 | 0 | 1 | 4 | 2 | 6 | 5 | 0 | 0 | 0 | 0 | 0 | 1 | 4 | 2 | 6 | ||||||||||||||||||||||||||||||||||
1741265 | 1741265 | CO | school | 802490 | 480 | Boulder Valley Re 2 | 80249000117 | 3488 | Gold Hill Elementary School | Regular School | No | Elementary | KG | 05 | 2021 | grade_3 | 4 | 0 | 0 | 0 | 0 | 0 | 0 | 3 | 1 | 4 | 4 | 0 | 0 | 0 | 0 | 0 | 0 | 3 | 1 | 4 | ||||||||||||||||||||||||||||||||||
1741266 | 1741266 | CO | school | 802490 | 480 | Boulder Valley Re 2 | 80249000117 | 3488 | Gold Hill Elementary School | Regular School | No | Elementary | KG | 05 | 2021 | grade_4 | 3 | 0 | 0 | 0 | 0 | 0 | 0 | 3 | 0 | 3 | 3 | 0 | 0 | 0 | 0 | 0 | 0 | 3 | 0 | 3 | ||||||||||||||||||||||||||||||||||
1741267 | 1741267 | CO | school | 802490 | 480 | Boulder Valley Re 2 | 80249000117 | 3488 | Gold Hill Elementary School | Regular School | No | Elementary | KG | 05 | 2021 | grade_5 | 5 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 1 | 5 | 5 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 1 | 5 | ||||||||||||||||||||||||||||||||||
1741270 | 1741270 | CO | school | 480 | Boulder Valley Re 2 | 3629 | Children's House Preschool | 2021 | pk_12_total | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 1 | |||||||||||||||||||||||||||||||||||||||||
1741271 | 1741271 | CO | school | 480 | Boulder Valley Re 2 | 3629 | Children's House Preschool | 2021 | pre_kindergarten | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 1 | |||||||||||||||||||||||||||||||||||||||||
1741279 | 1741279 | CO | school | 802490 | 480 | Boulder Valley Re 2 | 80249000118 | 3882 | Heatherwood Elementary School | Regular School | No | Elementary | PK | 05 | 2021 | pre_kindergarten | 19 | 0 | 0 | 0 | 2 | 0 | 0 | 14 | 7 | 21 | 19 | 0 | 0 | 0 | 2 | 0 | 0 | 14 | 7 | 21 | ||||||||||||||||||||||||||||||||||
1741288 | 1741288 | CO | school | 802490 | 480 | Boulder Valley Re 2 | 80249000119 | 4386 | Jamestown Elementary School | Regular School | No | Elementary | KG | 05 | 2021 | grade_2 | 3 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 2 | 3 | 3 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 2 | 3 | ||||||||||||||||||||||||||||||||||
1741289 | 1741289 | CO | school | 802490 | 480 | Boulder Valley Re 2 | 80249000119 | 4386 | Jamestown Elementary School | Regular School | No | Elementary | KG | 05 | 2021 | grade_3 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | ||||||||||||||||||||||||||||||||||
1741290 | 1741290 | CO | school | 802490 | 480 | Boulder Valley Re 2 | 80249000119 | 4386 | Jamestown Elementary School | Regular School | No | Elementary | KG | 05 | 2021 | grade_4 | 3 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 2 | 3 | 3 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 2 | 3 | ||||||||||||||||||||||||||||||||||
1741291 | 1741291 | CO | school | 802490 | 480 | Boulder Valley Re 2 | 80249000119 | 4386 | Jamestown Elementary School | Regular School | No | Elementary | KG | 05 | 2021 | grade_5 | 6 | 0 | 0 | 0 | 0 | 0 | 0 | 3 | 3 | 6 | 6 | 0 | 0 | 0 | 0 | 0 | 0 | 3 | 3 | 6 | ||||||||||||||||||||||||||||||||||
1741370 | 1741370 | CO | school | 802490 | 480 | Boulder Valley Re 2 | 80249000130 | 6208 | Nederland Elementary School | Regular School | No | Elementary | PK | 05 | 2021 | grade_2 | 24 | 0 | 0 | 0 | 0 | 0 | 2 | 15 | 11 | 26 | 24 | 0 | 0 | 0 | 0 | 0 | 2 | 15 | 11 | 26 | ||||||||||||||||||||||||||||||||||
1741377 | 1741377 | CO | school | 802490 | 480 | Boulder Valley Re 2 | 80249000131 | 6212 | Nederland Middle-Senior High School | Regular School | No | High | 06 | 12 | 2021 | grade_10 | 25 | 0 | 0 | 0 | 2 | 0 | 0 | 16 | 11 | 27 | 25 | 0 | 0 | 0 | 2 | 0 | 0 | 16 | 11 | 27 | ||||||||||||||||||||||||||||||||||
1741490 | 1741490 | CO | school | 806330 | 500 | Salida R-32 | 80633006500 | 1554 | Crest Academy | Regular School | No | Middle | 05 | 08 | 2021 | grade_5 | 7 | 0 | 0 | 0 | 0 | 0 | 0 | 3 | 4 | 7 | 7 | 0 | 0 | 0 | 0 | 0 | 0 | 3 | 4 | 7 | ||||||||||||||||||||||||||||||||||
1741492 | 1741492 | CO | school | 806330 | 500 | Salida R-32 | 80633006500 | 1554 | Crest Academy | Regular School | No | Middle | 05 | 08 | 2021 | grade_7 | 8 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 4 | 8 | 8 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 4 | 8 | ||||||||||||||||||||||||||||||||||
1741498 | 1741498 | CO | school | 806330 | 500 | Salida R-32 | 80633006413 | 4085 | Horizons Exploratory Academy | Alternative School | No | High | 09 | 12 | 2021 | grade_9 | 5 | 0 | 0 | 0 | 0 | 0 | 0 | 2 | 3 | 5 | 5 | 0 | 0 | 0 | 0 | 0 | 0 | 2 | 3 | 5 | ||||||||||||||||||||||||||||||||||
1741519 | 1741519 | CO | school | 805040 | 510 | Kit Carson R-1 | 80504000827 | 4738 | Kit Carson Elementary School | Regular School | No | Elementary | PK | 05 | 2021 | grade_2 | 8 | 1 | 0 | 0 | 0 | 0 | 0 | 2 | 7 | 9 | 8 | 1 | 0 | 0 | 0 | 0 | 0 | 2 | 7 | 9 | ||||||||||||||||||||||||||||||||||
1741523 | 1741523 | CO | school | 805040 | 510 | Kit Carson R-1 | 80504000827 | 4738 | Kit Carson Elementary School | Regular School | No | Elementary | PK | 05 | 2021 | kindergarten_full_day | 6 | 0 | 0 | 0 | 0 | 0 | 0 | 2 | 4 | 6 | 6 | 0 | 0 | 0 | 0 | 0 | 0 | 2 | 4 | 6 | ||||||||||||||||||||||||||||||||||
1741527 | 1741527 | CO | school | 805040 | 510 | Kit Carson R-1 | 80504000826 | 4742 | Kit Carson Junior-Senior High School | Regular School | No | High | 06 | 12 | 2021 | grade_11 | 5 | 0 | 0 | 0 | 0 | 0 | 0 | 3 | 2 | 5 | 5 | 0 | 0 | 0 | 0 | 0 | 0 | 3 | 2 | 5 | ||||||||||||||||||||||||||||||||||
1741528 | 1741528 | CO | school | 805040 | 510 | Kit Carson R-1 | 80504000826 | 4742 | Kit Carson Junior-Senior High School | Regular School | No | High | 06 | 12 | 2021 | grade_12 | 9 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 8 | 9 | 9 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 8 | 9 | ||||||||||||||||||||||||||||||||||
1741531 | 1741531 | CO | school | 805040 | 510 | Kit Carson R-1 | 80504000826 | 4742 | Kit Carson Junior-Senior High School | Regular School | No | High | 06 | 12 | 2021 | grade_8 | 6 | 0 | 0 | 0 | 0 | 0 | 0 | 5 | 1 | 6 | 6 | 0 | 0 | 0 | 0 | 0 | 0 | 5 | 1 | 6 | ||||||||||||||||||||||||||||||||||
1741535 | 1741535 | CO | school | 800001 | 520 | Cheyenne County Re-5 | 80000100214 | 1608 | Cheyenne Wells Elementary School | Regular School | No | Elementary | PK | 06 | 2021 | grade_2 | 11 | 0 | 0 | 0 | 0 | 0 | 0 | 10 | 1 | 11 | 11 | 0 | 0 | 0 | 0 | 0 | 0 | 10 | 1 | 11 | ||||||||||||||||||||||||||||||||||
1741542 | 1741542 | CO | school | 800001 | 520 | Cheyenne County Re-5 | 80000100214 | 1608 | Cheyenne Wells Elementary School | Regular School | No | Elementary | PK | 06 | 2021 | pre_kindergarten | 7 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 3 | 7 | 7 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 3 | 7 | ||||||||||||||||||||||||||||||||||
1741543 | 1741543 | CO | school | 800001 | 520 | Cheyenne County Re-5 | 80000100215 | 1612 | Cheyenne Wells Junior/High School | Regular School | No | High | 07 | 12 | 2021 | grade_10 | 13 | 0 | 0 | 0 | 0 | 0 | 0 | 7 | 6 | 13 | 13 | 0 | 0 | 0 | 0 | 0 | 0 | 7 | 6 | 13 | ||||||||||||||||||||||||||||||||||
1741554 | 1741554 | CO | school | 803000 | 540 | Clear Creek RE-1 | 80300001999 | 3385 | Georgetown Community School | Regular School | Yes | Elementary | PK | 06 | 2021 | grade_2 | 12 | 0 | 0 | 0 | 0 | 0 | 0 | 9 | 3 | 12 | 12 | 0 | 0 | 0 | 0 | 0 | 0 | 9 | 3 | 12 | ||||||||||||||||||||||||||||||||||
1741558 | 1741558 | CO | school | 803000 | 540 | Clear Creek RE-1 | 80300001999 | 3385 | Georgetown Community School | Regular School | Yes | Elementary | PK | 06 | 2021 | grade_6 | 9 | 0 | 0 | 0 | 0 | 0 | 0 | 6 | 3 | 9 | 9 | 0 | 0 | 0 | 0 | 0 | 0 | 6 | 3 | 9 | ||||||||||||||||||||||||||||||||||
1741568 | 1741568 | CO | school | 803000 | 540 | Clear Creek RE-1 | 80300000218 | 4212 | Carlson Elementary School | Regular School | No | Elementary | PK | 06 | 2021 | kindergarten_full_day | 15 | 0 | 0 | 0 | 0 | 0 | 1 | 11 | 5 | 16 | 15 | 0 | 0 | 0 | 0 | 0 | 1 | 11 | 5 | 16 | ||||||||||||||||||||||||||||||||||
1741576 | 1741576 | CO | school | 803000 | 540 | Clear Creek RE-1 | 80300001332 | 4700 | King-Murphy Elementary School | Regular School | No | Elementary | PK | 06 | 2021 | grade_1 | 12 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 8 | 12 | 12 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 8 | 12 | ||||||||||||||||||||||||||||||||||
1741579 | 1741579 | CO | school | 803000 | 540 | Clear Creek RE-1 | 80300001332 | 4700 | King-Murphy Elementary School | Regular School | No | Elementary | PK | 06 | 2021 | grade_4 | 11 | 0 | 0 | 0 | 0 | 0 | 0 | 5 | 6 | 11 | 11 | 0 | 0 | 0 | 0 | 0 | 0 | 5 | 6 | 11 | ||||||||||||||||||||||||||||||||||
1741582 | 1741582 | CO | school | 803000 | 540 | Clear Creek RE-1 | 80300001332 | 4700 | King-Murphy Elementary School | Regular School | No | Elementary | PK | 06 | 2021 | kindergarten_full_day | 14 | 0 | 0 | 1 | 0 | 0 | 0 | 7 | 8 | 15 | 14 | 0 | 0 | 1 | 0 | 0 | 0 | 7 | 8 | 15 | ||||||||||||||||||||||||||||||||||
1741584 | 1741584 | CO | school | 803000 | 540 | Clear Creek RE-1 | 80300001332 | 4700 | King-Murphy Elementary School | Regular School | No | Elementary | PK | 06 | 2021 | pre_kindergarten | 16 | 0 | 0 | 0 | 0 | 0 | 0 | 9 | 7 | 16 | 16 | 0 | 0 | 0 | 0 | 0 | 0 | 9 | 7 | 16 | ||||||||||||||||||||||||||||||||||
1741611 | 1741611 | CO | school | 805100 | 550 | North Conejos RE-1J | 80510006601 | 6339 | North Conejos Alternative Program | Alternative School | No | Other | KG | 12 | 2021 | grade_4 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 1 | ||||||||||||||||||||||||||||||||||
1741612 | 1741612 | CO | school | 805100 | 550 | North Conejos RE-1J | 80510006601 | 6339 | North Conejos Alternative Program | Alternative School | No | Other | KG | 12 | 2021 | grade_5 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 1 | 0 | 1 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 1 | 0 | 1 | ||||||||||||||||||||||||||||||||||
1741697 | 1741697 | CO | school | 807200 | 860 | Custer County School District C-1 | 80720001226 | 2088 | Custer County Elementary School | Regular School | No | Elementary | PK | 05 | 2021 | grade_2 | 22 | 0 | 0 | 1 | 0 | 0 | 0 | 14 | 9 | 23 | 22 | 0 | 0 | 1 | 0 | 0 | 0 | 14 | 9 | 23 | ||||||||||||||||||||||||||||||||||
1741700 | 1741700 | CO | school | 807200 | 860 | Custer County School District C-1 | 80720001226 | 2088 | Custer County Elementary School | Regular School | No | Elementary | PK | 05 | 2021 | grade_5 | 18 | 0 | 0 | 2 | 0 | 0 | 2 | 8 | 14 | 22 | 18 | 0 | 0 | 2 | 0 | 0 | 2 | 8 | 14 | 22 | ||||||||||||||||||||||||||||||||||
1741703 | 1741703 | CO | school | 807200 | 860 | Custer County School District C-1 | 80720001226 | 2088 | Custer County Elementary School | Regular School | No | Elementary | PK | 05 | 2021 | pre_kindergarten | 23 | 0 | 0 | 0 | 0 | 0 | 2 | 9 | 16 | 25 | 23 | 0 | 0 | 0 | 0 | 0 | 2 | 9 | 16 | 25 | ||||||||||||||||||||||||||||||||||
1741704 | 1741704 | CO | school | 807200 | 860 | Custer County School District C-1 | 80720001732 | 2091 | Custer Middle School | Regular School | No | Middle | 06 | 08 | 2021 | grade_6 | 28 | 2 | 0 | 0 | 0 | 0 | 1 | 13 | 18 | 31 | 28 | 2 | 0 | 0 | 0 | 0 | 1 | 13 | 18 | 31 | ||||||||||||||||||||||||||||||||||
1741705 | 1741705 | CO | school | 807200 | 860 | Custer County School District C-1 | 80720001732 | 2091 | Custer Middle School | Regular School | No | Middle | 06 | 08 | 2021 | grade_7 | 29 | 0 | 0 | 0 | 0 | 0 | 1 | 17 | 13 | 30 | 29 | 0 | 0 | 0 | 0 | 0 | 1 | 17 | 13 | 30 | ||||||||||||||||||||||||||||||||||
1741706 | 1741706 | CO | school | 807200 | 860 | Custer County School District C-1 | 80720001732 | 2091 | Custer Middle School | Regular School | No | Middle | 06 | 08 | 2021 | grade_8 | 24 | 0 | 0 | 0 | 0 | 0 | 1 | 15 | 10 | 25 | 24 | 0 | 0 | 0 | 0 | 0 | 1 | 15 | 10 | 25 | ||||||||||||||||||||||||||||||||||
1741707 | 1741707 | CO | school | 807200 | 860 | Custer County School District C-1 | 80720001732 | 2091 | Custer Middle School | Regular School | No | Middle | 06 | 08 | 2021 | pk_12_total | 81 | 2 | 0 | 0 | 0 | 0 | 3 | 45 | 41 | 86 | 81 | 2 | 0 | 0 | 0 | 0 | 3 | 45 | 41 | 86 | ||||||||||||||||||||||||||||||||||
1741708 | 1741708 | CO | school | 807200 | 860 | Custer County School District C-1 | 80720001225 | 2092 | Custer County High School | Regular School | No | High | 09 | 12 | 2021 | grade_10 | 24 | 0 | 0 | 0 | 0 | 0 | 1 | 15 | 10 | 25 | 24 | 0 | 0 | 0 | 0 | 0 | 1 | 15 | 10 | 25 | ||||||||||||||||||||||||||||||||||
1741709 | 1741709 | CO | school | 807200 | 860 | Custer County School District C-1 | 80720001225 | 2092 | Custer County High School | Regular School | No | High | 09 | 12 | 2021 | grade_11 | 19 | 0 | 0 | 0 | 0 | 0 | 0 | 8 | 11 | 19 | 19 | 0 | 0 | 0 | 0 | 0 | 0 | 8 | 11 | 19 | ||||||||||||||||||||||||||||||||||
1741710 | 1741710 | CO | school | 807200 | 860 | Custer County School District C-1 | 80720001225 | 2092 | Custer County High School | Regular School | No | High | 09 | 12 | 2021 | grade_12 | 27 | 1 | 0 | 0 | 0 | 0 | 2 | 13 | 17 | 30 | 27 | 1 | 0 | 0 | 0 | 0 | 2 | 13 | 17 | 30 | ||||||||||||||||||||||||||||||||||
1741728 | 1741728 | CO | school | 803330 | 870 | Delta County 50(J) | 80333000295 | 1952 | North Fork Montessori @ Crawford | Regular School | No | Elementary | PK | 06 | 2021 | grade_5 | 19 | 0 | 0 | 0 | 0 | 0 | 1 | 10 | 10 | 20 | 19 | 0 | 0 | 0 | 0 | 0 | 1 | 10 | 10 | 20 |
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]);