enrollments
Data source: Big Local News · About: Big Local
13,321 rows where state = "CO" and year = 2020 sorted by total_int
This data as json, CSV (advanced)
grade ✖
- pk_12_total 1,916
- grade_5 1,108
- grade_2 1,104
- grade_1 1,102
- grade_4 1,102
- grade_3 1,101
- kindergarten_full_day 1,087
- grade_6 690
- pre_kindergarten 684
- grade_7 626
- grade_8 620
- grade_12 506
- grade_10 503
- grade_11 503
- grade_9 489
- kindergarten_half_day 180
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 ▼ |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 | |||||||||||||||||||||||||||||||||||||||||
1800143 | 1800143 | CO | school | 70 | Westminster Public Schools | 0 | Not a school | 2020 | grade_12 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 1 | |||||||||||||||||||||||||||||||||||||||||
1800144 | 1800144 | CO | school | 70 | Westminster Public Schools | 0 | Not a school | 2020 | pk_12_total | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 1 | |||||||||||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||||||||||||
1801023 | 1801023 | CO | school | 180 | Adams-Arapahoe 28J | 1 | Facilities with District Run Education | 2020 | grade_8 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 1 | |||||||||||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||
1802323 | 1802323 | CO | school | 802490 | 480 | Boulder Valley Re 2 | 80249002013 | 4496 | Justice High Charter School | Alternative School | Yes | High | 06 | 12 | 2020 | grade_6 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 1 | ||||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||
1804920 | 1804920 | CO | school | 803450 | 900 | Douglas County Re 1 | 80345000447 | 8126 | South Ridge Elementary An IB World School | Regular School | No | Elementary | PK | 06 | 2020 | kindergarten_half_day | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 1 | ||||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||
1805099 | 1805099 | CO | school | 803540 | 910 | Eagle County RE 50 | 80354006533 | 9701 | World Academy | Regular School | No | Other | KG | 12 | 2020 | grade_10 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 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 | ||||||||||||||||||||||||||||||||||
1805103 | 1805103 | CO | school | 803540 | 910 | Eagle County RE 50 | 80354006533 | 9701 | World Academy | Regular School | No | Other | KG | 12 | 2020 | grade_5 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 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 | ||||||||||||||||||||||||||||||||||
1805205 | 1805205 | CO | school | 801980 | 960 | Agate 300 | 80198000020 | 44 | Agate Elementary School | Regular School | No | Elementary | PK | 05 | 2020 | grade_5 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | ||||||||||||||||||||||||||||||||||
1805212 | 1805212 | CO | school | 801980 | 960 | Agate 300 | 80198000021 | 48 | Agate Junior Senior High School | Regular School | No | High | 06 | 12 | 2020 | grade_8 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | ||||||||||||||||||||||||||||||||||
1805416 | 1805416 | CO | school | 806480 | 990 | Widefield 3 | 80648006772 | 3692 | Grand Mountain School | Regular School | No | Elementary | PK | 08 | 2020 | kindergarten_half_day | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | ||||||||||||||||||||||||||||||||||
1805436 | 1805436 | CO | school | 806480 | 990 | Widefield 3 | 80648001885 | 5033 | James Madison Charter Academy School | Regular School | Yes | Elementary | KG | 08 | 2020 | grade_8 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 1 | ||||||||||||||||||||||||||||||||||
1805445 | 1805445 | CO | school | 806480 | 990 | Widefield 3 | 80648001121 | 5602 | Martin Luther King Jr Elementary School | Regular School | No | Elementary | KG | 05 | 2020 | kindergarten_half_day | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 1 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 1 | 0 | 1 | ||||||||||||||||||||||||||||||||||
1805498 | 1805498 | CO | school | 806480 | 990 | Widefield 3 | 80648001128 | 9562 | Widefield Elementary School of the Arts | Regular School | No | Elementary | KG | 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 | ||||||||||||||||||||||||||||||||||
1805599 | 1805599 | CO | school | 803060 | 1010 | Colorado Springs 11 | 80306000222 | 452 | Audubon 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 | ||||||||||||||||||||||||||||||||||
1805647 | 1805647 | CO | school | 803060 | 1010 | Colorado Springs 11 | 80306001435 | 1613 | Chipeta Elementary School | Regular School | No | Elementary | PK | 05 | 2020 | kindergarten_half_day | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 1 | ||||||||||||||||||||||||||||||||||
1805697 | 1805697 | CO | school | 803060 | 1010 | Colorado Springs 11 | 80306000231 | 2510 | Edison 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 | ||||||||||||||||||||||||||||||||||
1805741 | 1805741 | CO | school | 803060 | 1010 | Colorado Springs 11 | 80306000238 | 3592 | Grant Elementary School | Regular School | No | Elementary | KG | 05 | 2020 | kindergarten_half_day | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 1 | 1 | ||||||||||||||||||||||||||||||||||
1805781 | 1805781 | CO | school | 803060 | 1010 | Colorado Springs 11 | 80306000245 | 4358 | Jackson Elementary School | Regular School | No | Elementary | PK | 05 | 2020 | kindergarten_half_day | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 1 | ||||||||||||||||||||||||||||||||||
1805799 | 1805799 | CO | school | 803060 | 1010 | Colorado Springs 11 | 80306001841 | 5146 | Eastlake High School of Colorado Springs | Alternative School | Yes | High | 09 | 12 | 2020 | grade_9 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 1 | 0 | 1 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 1 | 0 | 1 | ||||||||||||||||||||||||||||||||||
1805807 | 1805807 | CO | school | 803060 | 1010 | Colorado Springs 11 | 80306000251 | 5404 | Madison 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 | ||||||||||||||||||||||||||||||||||
1805816 | 1805816 | CO | school | 803060 | 1010 | Colorado Springs 11 | 80306000252 | 5576 | Twain 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 | ||||||||||||||||||||||||||||||||||
1805833 | 1805833 | CO | school | 803060 | 1010 | Colorado Springs 11 | 80306001470 | 5610 | Martinez 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 | ||||||||||||||||||||||||||||||||||
1805909 | 1805909 | CO | school | 803060 | 1010 | Colorado Springs 11 | 80306001641 | 7705 | Scott 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 | ||||||||||||||||||||||||||||||||||
1806080 | 1806080 | CO | school | 801920 | 1040 | Academy 20 | 80192001644 | 19 | Academy International Elementary School | Regular School | No | Elementary | PK | 05 | 2020 | kindergarten_half_day | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 1 | ||||||||||||||||||||||||||||||||||
1806188 | 1806188 | CO | school | 801920 | 1040 | Academy 20 | 80192000003 | 2248 | Douglass Valley Elementary School | Regular School | No | Elementary | KG | 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 | ||||||||||||||||||||||||||||||||||
1806363 | 1806363 | CO | school | 806060 | 1060 | Peyton 23 Jt | 80606006692 | 6626 | Peyton Online Academy | Regular School | No | High | 05 | 12 | 2020 | grade_8 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | ||||||||||||||||||||||||||||||||||
1806364 | 1806364 | CO | school | 806060 | 1060 | Peyton 23 Jt | 80606006692 | 6626 | Peyton Online Academy | Regular School | No | High | 05 | 12 | 2020 | grade_9 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | ||||||||||||||||||||||||||||||||||
1806391 | 1806391 | CO | school | 804500 | 1070 | Hanover 28 | 80450006720 | 3941 | Hanover Online Academy | Regular School | No | High | 06 | 12 | 2020 | grade_10 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 1 | ||||||||||||||||||||||||||||||||||
1806392 | 1806392 | CO | school | 804500 | 1070 | Hanover 28 | 80450006720 | 3941 | Hanover Online Academy | Regular School | No | High | 06 | 12 | 2020 | grade_11 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 1 | ||||||||||||||||||||||||||||||||||
1806393 | 1806393 | CO | school | 804500 | 1070 | Hanover 28 | 80450006720 | 3941 | Hanover Online Academy | Regular School | No | High | 06 | 12 | 2020 | grade_7 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 1 | ||||||||||||||||||||||||||||||||||
1806466 | 1806466 | CO | school | 805820 | 1080 | Lewis-Palmer 38 | 80582001397 | 6682 | Palmer Lake 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 | ||||||||||||||||||||||||||||||||||
1806749 | 1806749 | CO | school | 1140 | Canon City RE-1 | 0 | Not a school | 2020 | grade_11 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 1 | 1 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 1 | 1 | |||||||||||||||||||||||||||||||||||||||||
1806894 | 1806894 | CO | school | 804260 | 1180 | Roaring Fork RE-1 | 80426001540 | 2063 | Crystal River Elementary School | Regular School | No | Elementary | PK | 04 | 2020 | kindergarten_half_day | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | ||||||||||||||||||||||||||||||||||
1806937 | 1806937 | CO | school | 804260 | 1180 | Roaring Fork RE-1 | 80426001597 | 8038 | Sopris 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 | ||||||||||||||||||||||||||||||||||
1806959 | 1806959 | CO | school | 806240 | 1195 | Garfield Re-2 | 80624006436 | 3281 | Graham Mesa 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 | ||||||||||||||||||||||||||||||||||
1807005 | 1807005 | CO | school | 806240 | 1195 | Garfield Re-2 | 80624001358 | 9231 | Wamsley 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 | ||||||||||||||||||||||||||||||||||
1807267 | 1807267 | CO | school | 804800 | 1420 | Jefferson County R-1 | 80480000696 | 660 | Bear Creek K-8 School | Regular School | No | Elementary | KG | 08 | 2020 | kindergarten_half_day | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 1 | ||||||||||||||||||||||||||||||||||
1807284 | 1807284 | CO | school | 804800 | 1420 | Jefferson County R-1 | 80480000699 | 724 | Belmar School of Integrated Arts | Regular School | No | Elementary | KG | 05 | 2020 | kindergarten_half_day | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 1 | 1 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 1 | 1 | ||||||||||||||||||||||||||||||||||
1807361 | 1807361 | CO | school | 804800 | 1420 | Jefferson County R-1 | 80480000705 | 1790 | Colorow 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 | ||||||||||||||||||||||||||||||||||
1807543 | 1807543 | CO | school | 804800 | 1420 | Jefferson County R-1 | 80480000724 | 3025 | Foothills Elementary School | Regular School | No | Elementary | PK | 05 | 2020 | kindergarten_half_day | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 1 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 1 | 0 | 1 | ||||||||||||||||||||||||||||||||||
1807836 | 1807836 | CO | school | 804800 | 1420 | Jefferson County R-1 | 80480000988 | 5623 | Longview High School | 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 | ||||||||||||||||||||||||||||||||||
1807859 | 1807859 | CO | school | 804800 | 1420 | Jefferson County R-1 | 80480000756 | 5892 | Miller Special Education | Special Education School | No | Other | PK | 12 | 2020 | kindergarten_full_day | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | ||||||||||||||||||||||||||||||||||
1807885 | 1807885 | CO | school | 804800 | 1420 | Jefferson County R-1 | 80480001607 | 5994 | Montessori Peaks Charter Academy | Regular School | Yes | Elementary | PK | 08 | 2020 | grade_7 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 1 | 1 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 1 | 1 | ||||||||||||||||||||||||||||||||||
1807974 | 1807974 | CO | school | 804800 | 1420 | Jefferson County R-1 | 80480000769 | 6806 | Parr Elementary School | Regular School | No | Elementary | PK | 05 | 2020 | kindergarten_half_day | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 1 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 1 | 0 | 1 | ||||||||||||||||||||||||||||||||||
1808132 | 1808132 | CO | school | 804800 | 1420 | Jefferson County R-1 | 80480001044 | 7833 | Shelton 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 | ||||||||||||||||||||||||||||||||||
1808151 | 1808151 | CO | school | 804800 | 1420 | Jefferson County R-1 | 80480006307 | 8036 | Sobesky Academy | Special Education School | No | Other | KG | 12 | 2020 | grade_1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | ||||||||||||||||||||||||||||||||||
1808155 | 1808155 | CO | school | 804800 | 1420 | Jefferson County R-1 | 80480006307 | 8036 | Sobesky Academy | Special Education School | No | Other | KG | 12 | 2020 | grade_2 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | ||||||||||||||||||||||||||||||||||
1808157 | 1808157 | CO | school | 804800 | 1420 | Jefferson County R-1 | 80480006307 | 8036 | Sobesky Academy | Special Education School | No | Other | KG | 12 | 2020 | grade_4 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | ||||||||||||||||||||||||||||||||||
1808221 | 1808221 | CO | school | 804800 | 1420 | Jefferson County R-1 | 80480000788 | 8300 | Stott 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 | ||||||||||||||||||||||||||||||||||
1808275 | 1808275 | CO | school | 804800 | 1420 | Jefferson County R-1 | 80480001450 | 9008 | Ute Meadows Elementary School | Regular School | No | Elementary | KG | 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 | ||||||||||||||||||||||||||||||||||
1808292 | 1808292 | CO | school | 804800 | 1420 | Jefferson County R-1 | 80480000793 | 9058 | Vanderhoof Elementary School | Regular School | No | Elementary | KG | 05 | 2020 | kindergarten_half_day | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 1 | 1 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 1 | 1 | ||||||||||||||||||||||||||||||||||
1808350 | 1808350 | CO | school | 804800 | 1420 | Jefferson County R-1 | 80480000800 | 9424 | West Jefferson 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 | ||||||||||||||||||||||||||||||||||
1808392 | 1808392 | CO | school | 804800 | 1420 | Jefferson County R-1 | 80480001451 | 9490 | Westridge 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 | ||||||||||||||||||||||||||||||||||
1808699 | 1808699 | CO | school | 1550 | Poudre R-1 | 0 | Not a school | 2020 | grade_8 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 1 | |||||||||||||||||||||||||||||||||||||||||
1808744 | 1808744 | CO | school | 803990 | 1550 | Poudre R-1 | 80399006380 | 498 | Bethke Elementary School | Regular School | No | Elementary | KG | 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 | ||||||||||||||||||||||||||||||||||
1808865 | 1808865 | CO | school | 803990 | 1550 | Poudre R-1 | 80399000147 | 4793 | Kruse 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 | ||||||||||||||||||||||||||||||||||
1808923 | 1808923 | CO | school | 803990 | 1550 | Poudre R-1 | 80399000165 | 5688 | McGraw Elementary School | Regular School | No | Elementary | PK | 05 | 2020 | kindergarten_half_day | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 1 | ||||||||||||||||||||||||||||||||||
1809061 | 1809061 | CO | school | 803990 | 1550 | Poudre R-1 | 80399000548 | 8852 | Timnath 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 | ||||||||||||||||||||||||||||||||||
1809150 | 1809150 | CO | school | 805400 | 1560 | Thompson R2-J | 80540000931 | 1385 | Centennial Elementary School | Regular School | No | Elementary | KG | 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 | ||||||||||||||||||||||||||||||||||
1809196 | 1809196 | CO | school | 805400 | 1560 | Thompson R2-J | 80540001301 | 5018 | Laurene Edmondson Elementary School | Regular School | No | Elementary | KG | 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 | ||||||||||||||||||||||||||||||||||
1809201 | 1809201 | CO | school | 805400 | 1560 | Thompson R2-J | 80540006558 | 5121 | LEAP School | Regular School | No | Other | KG | 12 | 2020 | grade_12 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 1 | ||||||||||||||||||||||||||||||||||
1809285 | 1809285 | CO | school | 805400 | 1560 | Thompson R2-J | 80540006432 | 7113 | Ponderosa Elementary | Regular School | No | Elementary | KG | 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 | ||||||||||||||||||||||||||||||||||
1809317 | 1809317 | CO | school | 805400 | 1560 | Thompson R2-J | 80540000941 | 9260 | Harold Ferguson High School | Alternative School | No | High | 09 | 12 | 2020 | grade_9 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 1 | ||||||||||||||||||||||||||||||||||
1809333 | 1809333 | CO | school | 803810 | 1570 | Estes Park R-3 | 80381006426 | 2788 | Estes Park Options School | Alternative School | No | Other | KG | 12 | 2020 | grade_8 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 1 | ||||||||||||||||||||||||||||||||||
1809334 | 1809334 | CO | school | 803810 | 1570 | Estes Park R-3 | 80381006426 | 2788 | Estes Park Options School | Alternative School | No | Other | KG | 12 | 2020 | grade_9 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | ||||||||||||||||||||||||||||||||||
1809431 | 1809431 | CO | school | 802520 | 1750 | Branson Reorganized 82 | 80252000141 | 978 | Branson School | Regular School | No | Other | PK | 12 | 2020 | grade_1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 1 | ||||||||||||||||||||||||||||||||||
1809443 | 1809443 | CO | school | 802520 | 1750 | Branson Reorganized 82 | 80252000141 | 978 | Branson School | Regular School | No | Other | PK | 12 | 2020 | kindergarten_full_day | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | ||||||||||||||||||||||||||||||||||
1809447 | 1809447 | CO | school | 804980 | 1760 | Kim Reorganized 88 | 80498000822 | 4690 | Kim Elementary School | Regular School | No | Elementary | PK | 05 | 2020 | grade_3 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 1 | ||||||||||||||||||||||||||||||||||
1809455 | 1809455 | CO | school | 804980 | 1760 | Kim Reorganized 88 | 80498000823 | 4694 | Kim Undivided High School | Regular School | No | High | 06 | 12 | 2020 | grade_6 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | ||||||||||||||||||||||||||||||||||
1809457 | 1809457 | CO | school | 804980 | 1760 | Kim Reorganized 88 | 80498000823 | 4694 | Kim Undivided High School | Regular School | No | High | 06 | 12 | 2020 | grade_8 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 1 | ||||||||||||||||||||||||||||||||||
1809490 | 1809490 | CO | school | 804890 | 1810 | Karval RE-23 | 80489000814 | 4502 | Karval Elementary School | Regular School | No | Elementary | PK | 06 | 2020 | grade_1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | ||||||||||||||||||||||||||||||||||
1809499 | 1809499 | CO | school | 804890 | 1810 | Karval RE-23 | 80489000815 | 4506 | Karval Junior-Senior High School | Regular School | No | High | 07 | 12 | 2020 | grade_10 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 1 | ||||||||||||||||||||||||||||||||||
1809603 | 1809603 | CO | school | 803030 | 1990 | Plateau Valley 50 | 80303001434 | 3582 | Grand Mesa High School | 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 | ||||||||||||||||||||||||||||||||||
1809681 | 1809681 | CO | school | 804350 | 2000 | Mesa County Valley 51 | 80435000601 | 1520 | Chatfield 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 | ||||||||||||||||||||||||||||||||||
1809716 | 1809716 | CO | school | 804350 | 2000 | Mesa County Valley 51 | 80435001691 | 2224 | Dos Rios Elementary School | Regular School | No | Elementary | PK | 05 | 2020 | kindergarten_half_day | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 1 | ||||||||||||||||||||||||||||||||||
1809749 | 1809749 | CO | school | 804350 | 2000 | Mesa County Valley 51 | 80435000611 | 3350 | Gateway School | Regular School | No | Other | PK | 12 | 2020 | grade_1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | ||||||||||||||||||||||||||||||||||
1809752 | 1809752 | CO | school | 804350 | 2000 | Mesa County Valley 51 | 80435000611 | 3350 | Gateway School | Regular School | No | Other | PK | 12 | 2020 | grade_12 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 1 | ||||||||||||||||||||||||||||||||||
1809760 | 1809760 | CO | school | 804350 | 2000 | Mesa County Valley 51 | 80435000611 | 3350 | Gateway School | Regular School | No | Other | PK | 12 | 2020 | grade_9 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 1 | ||||||||||||||||||||||||||||||||||
1809975 | 1809975 | CO | school | 805730 | 2020 | Moffat County RE: No 1 | 80573000980 | 5656 | Maybell School | Regular School | No | Elementary | KG | 06 | 2020 | grade_2 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 1 | ||||||||||||||||||||||||||||||||||
1809977 | 1809977 | CO | school | 805730 | 2020 | Moffat County RE: No 1 | 80573000980 | 5656 | Maybell School | Regular School | No | Elementary | KG | 06 | 2020 | grade_4 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | ||||||||||||||||||||||||||||||||||
1810062 | 1810062 | CO | school | 803090 | 2035 | Montezuma-Cortez RE-1 | 80309000841 | 7082 | Pleasant View Elementary School | Regular School | No | Elementary | KG | 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 |
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]);