enrollments
Data source: Big Local News · About: Big Local
13,321 rows where state = "CO" and year = 2020 sorted by district
This data as json, CSV (advanced)
grade ✖
- pk_12_total 1,901
- grade_5 1,101
- grade_2 1,097
- grade_1 1,095
- grade_4 1,095
- grade_3 1,094
- kindergarten_full_day 1,081
- grade_6 684
- pre_kindergarten 682
- grade_7 619
- grade_8 614
- grade_12 501
- grade_10 498
- grade_11 498
- grade_9 484
- kindergarten_half_day 177
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1806167 | 1806167 | CO | school | 801920 | 1040 | Academy 20 | 80192006616 | 1921 | Discovery Canyon Campus Middle School | Regular School | No | Middle | 06 | 08 | 2020 | grade_8 | 205 | 5 | 46 | 1 | 20 | 0 | 27 | 156 | 148 | 304 | 205 | 5 | 46 | 1 | 20 | 0 | 27 | 156 | 148 | 304 | ||||||||||||||||||||||||||||||||||
1806168 | 1806168 | CO | school | 801920 | 1040 | Academy 20 | 80192006616 | 1921 | Discovery Canyon Campus Middle School | Regular School | No | Middle | 06 | 08 | 2020 | pk_12_total | 566 | 25 | 108 | 1 | 45 | 0 | 70 | 412 | 403 | 815 | 566 | 25 | 108 | 1 | 45 | 0 | 70 | 412 | 403 | 815 | ||||||||||||||||||||||||||||||||||
1806169 | 1806169 | CO | school | 801920 | 1040 | Academy 20 | 80192006631 | 1929 | Discovery Canyon Campus Elementary School | Regular School | No | Elementary | PK | 05 | 2020 | grade_1 | 48 | 5 | 11 | 0 | 3 | 0 | 8 | 40 | 35 | 75 | 48 | 5 | 11 | 0 | 3 | 0 | 8 | 40 | 35 | 75 | ||||||||||||||||||||||||||||||||||
1806170 | 1806170 | CO | school | 801920 | 1040 | Academy 20 | 80192006631 | 1929 | Discovery Canyon Campus Elementary School | Regular School | No | Elementary | PK | 05 | 2020 | grade_2 | 53 | 2 | 12 | 0 | 9 | 1 | 3 | 48 | 32 | 80 | 53 | 2 | 12 | 0 | 9 | 1 | 3 | 48 | 32 | 80 | ||||||||||||||||||||||||||||||||||
1806171 | 1806171 | CO | school | 801920 | 1040 | Academy 20 | 80192006631 | 1929 | Discovery Canyon Campus Elementary School | Regular School | No | Elementary | PK | 05 | 2020 | grade_3 | 61 | 2 | 10 | 0 | 7 | 0 | 4 | 51 | 33 | 84 | 61 | 2 | 10 | 0 | 7 | 0 | 4 | 51 | 33 | 84 | ||||||||||||||||||||||||||||||||||
1806172 | 1806172 | CO | school | 801920 | 1040 | Academy 20 | 80192006631 | 1929 | Discovery Canyon Campus Elementary School | Regular School | No | Elementary | PK | 05 | 2020 | grade_4 | 57 | 2 | 13 | 0 | 4 | 0 | 8 | 50 | 34 | 84 | 57 | 2 | 13 | 0 | 4 | 0 | 8 | 50 | 34 | 84 | ||||||||||||||||||||||||||||||||||
1806173 | 1806173 | CO | school | 801920 | 1040 | Academy 20 | 80192006631 | 1929 | Discovery Canyon Campus Elementary School | Regular School | No | Elementary | PK | 05 | 2020 | grade_5 | 80 | 7 | 8 | 0 | 6 | 0 | 6 | 56 | 51 | 107 | 80 | 7 | 8 | 0 | 6 | 0 | 6 | 56 | 51 | 107 | ||||||||||||||||||||||||||||||||||
1806174 | 1806174 | CO | school | 801920 | 1040 | Academy 20 | 80192006631 | 1929 | Discovery Canyon Campus Elementary School | Regular School | No | Elementary | PK | 05 | 2020 | kindergarten_full_day | 50 | 2 | 10 | 0 | 3 | 0 | 8 | 33 | 40 | 73 | 50 | 2 | 10 | 0 | 3 | 0 | 8 | 33 | 40 | 73 | ||||||||||||||||||||||||||||||||||
1806175 | 1806175 | CO | school | 801920 | 1040 | Academy 20 | 80192006631 | 1929 | Discovery Canyon Campus Elementary School | Regular School | No | Elementary | PK | 05 | 2020 | pk_12_total | 362 | 21 | 69 | 0 | 33 | 1 | 39 | 290 | 235 | 525 | 362 | 21 | 69 | 0 | 33 | 1 | 39 | 290 | 235 | 525 | ||||||||||||||||||||||||||||||||||
1806176 | 1806176 | CO | school | 801920 | 1040 | Academy 20 | 80192006631 | 1929 | Discovery Canyon Campus Elementary School | Regular School | No | Elementary | PK | 05 | 2020 | pre_kindergarten | 13 | 1 | 5 | 0 | 1 | 0 | 2 | 12 | 10 | 22 | 13 | 1 | 5 | 0 | 1 | 0 | 2 | 12 | 10 | 22 | ||||||||||||||||||||||||||||||||||
1806177 | 1806177 | CO | school | 801920 | 1040 | Academy 20 | 80192001905 | 2195 | Discovery Canyon Campus High School | Regular School | No | High | 09 | 12 | 2020 | grade_10 | 227 | 11 | 45 | 2 | 22 | 0 | 21 | 164 | 164 | 328 | 227 | 11 | 45 | 2 | 22 | 0 | 21 | 164 | 164 | 328 | ||||||||||||||||||||||||||||||||||
1806178 | 1806178 | CO | school | 801920 | 1040 | Academy 20 | 80192001905 | 2195 | Discovery Canyon Campus High School | Regular School | No | High | 09 | 12 | 2020 | grade_11 | 176 | 15 | 36 | 1 | 18 | 0 | 14 | 149 | 111 | 260 | 176 | 15 | 36 | 1 | 18 | 0 | 14 | 149 | 111 | 260 | ||||||||||||||||||||||||||||||||||
1806179 | 1806179 | CO | school | 801920 | 1040 | Academy 20 | 80192001905 | 2195 | Discovery Canyon Campus High School | Regular School | No | High | 09 | 12 | 2020 | grade_12 | 218 | 13 | 41 | 1 | 12 | 1 | 9 | 171 | 124 | 295 | 218 | 13 | 41 | 1 | 12 | 1 | 9 | 171 | 124 | 295 | ||||||||||||||||||||||||||||||||||
1806180 | 1806180 | CO | school | 801920 | 1040 | Academy 20 | 80192001905 | 2195 | Discovery Canyon Campus High School | Regular School | No | High | 09 | 12 | 2020 | grade_9 | 200 | 3 | 36 | 1 | 16 | 1 | 18 | 148 | 127 | 275 | 200 | 3 | 36 | 1 | 16 | 1 | 18 | 148 | 127 | 275 | ||||||||||||||||||||||||||||||||||
1806181 | 1806181 | CO | school | 801920 | 1040 | Academy 20 | 80192001905 | 2195 | Discovery Canyon Campus High School | Regular School | No | High | 09 | 12 | 2020 | pk_12_total | 821 | 42 | 158 | 5 | 68 | 2 | 62 | 632 | 526 | 1158 | 821 | 42 | 158 | 5 | 68 | 2 | 62 | 632 | 526 | 1158 | ||||||||||||||||||||||||||||||||||
1806182 | 1806182 | CO | school | 801920 | 1040 | Academy 20 | 80192000003 | 2248 | Douglass Valley Elementary School | Regular School | No | Elementary | KG | 05 | 2020 | grade_1 | 34 | 8 | 11 | 0 | 1 | 0 | 5 | 30 | 29 | 59 | 34 | 8 | 11 | 0 | 1 | 0 | 5 | 30 | 29 | 59 | ||||||||||||||||||||||||||||||||||
1806183 | 1806183 | CO | school | 801920 | 1040 | Academy 20 | 80192000003 | 2248 | Douglass Valley Elementary School | Regular School | No | Elementary | KG | 05 | 2020 | grade_2 | 29 | 1 | 12 | 0 | 1 | 2 | 2 | 21 | 26 | 47 | 29 | 1 | 12 | 0 | 1 | 2 | 2 | 21 | 26 | 47 | ||||||||||||||||||||||||||||||||||
1806184 | 1806184 | CO | school | 801920 | 1040 | Academy 20 | 80192000003 | 2248 | Douglass Valley Elementary School | Regular School | No | Elementary | KG | 05 | 2020 | grade_3 | 29 | 5 | 7 | 0 | 2 | 0 | 5 | 23 | 25 | 48 | 29 | 5 | 7 | 0 | 2 | 0 | 5 | 23 | 25 | 48 | ||||||||||||||||||||||||||||||||||
1806185 | 1806185 | CO | school | 801920 | 1040 | Academy 20 | 80192000003 | 2248 | Douglass Valley Elementary School | Regular School | No | Elementary | KG | 05 | 2020 | grade_4 | 29 | 2 | 15 | 0 | 1 | 1 | 7 | 28 | 27 | 55 | 29 | 2 | 15 | 0 | 1 | 1 | 7 | 28 | 27 | 55 | ||||||||||||||||||||||||||||||||||
1806186 | 1806186 | CO | school | 801920 | 1040 | Academy 20 | 80192000003 | 2248 | Douglass Valley Elementary School | Regular School | No | Elementary | KG | 05 | 2020 | grade_5 | 23 | 4 | 10 | 0 | 0 | 0 | 4 | 19 | 22 | 41 | 23 | 4 | 10 | 0 | 0 | 0 | 4 | 19 | 22 | 41 | ||||||||||||||||||||||||||||||||||
1806187 | 1806187 | CO | school | 801920 | 1040 | Academy 20 | 80192000003 | 2248 | Douglass Valley Elementary School | Regular School | No | Elementary | KG | 05 | 2020 | kindergarten_full_day | 42 | 3 | 11 | 1 | 3 | 0 | 5 | 30 | 35 | 65 | 42 | 3 | 11 | 1 | 3 | 0 | 5 | 30 | 35 | 65 | ||||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||
1806189 | 1806189 | CO | school | 801920 | 1040 | Academy 20 | 80192000003 | 2248 | Douglass Valley Elementary School | Regular School | No | Elementary | KG | 05 | 2020 | pk_12_total | 187 | 23 | 66 | 1 | 8 | 3 | 28 | 152 | 164 | 316 | 187 | 23 | 66 | 1 | 8 | 3 | 28 | 152 | 164 | 316 | ||||||||||||||||||||||||||||||||||
1806190 | 1806190 | CO | school | 801920 | 1040 | Academy 20 | 80192001402 | 2358 | Eagleview Middle School | Regular School | No | Middle | 06 | 08 | 2020 | grade_6 | 231 | 11 | 57 | 2 | 8 | 1 | 25 | 161 | 174 | 335 | 231 | 11 | 57 | 2 | 8 | 1 | 25 | 161 | 174 | 335 | ||||||||||||||||||||||||||||||||||
1806191 | 1806191 | CO | school | 801920 | 1040 | Academy 20 | 80192001402 | 2358 | Eagleview Middle School | Regular School | No | Middle | 06 | 08 | 2020 | grade_7 | 258 | 7 | 46 | 0 | 10 | 2 | 17 | 155 | 185 | 340 | 258 | 7 | 46 | 0 | 10 | 2 | 17 | 155 | 185 | 340 | ||||||||||||||||||||||||||||||||||
1806192 | 1806192 | CO | school | 801920 | 1040 | Academy 20 | 80192001402 | 2358 | Eagleview Middle School | Regular School | No | Middle | 06 | 08 | 2020 | grade_8 | 240 | 7 | 63 | 2 | 7 | 0 | 23 | 170 | 172 | 342 | 240 | 7 | 63 | 2 | 7 | 0 | 23 | 170 | 172 | 342 | ||||||||||||||||||||||||||||||||||
1806193 | 1806193 | CO | school | 801920 | 1040 | Academy 20 | 80192001402 | 2358 | Eagleview Middle School | Regular School | No | Middle | 06 | 08 | 2020 | pk_12_total | 729 | 25 | 166 | 4 | 25 | 3 | 65 | 486 | 531 | 1017 | 729 | 25 | 166 | 4 | 25 | 3 | 65 | 486 | 531 | 1017 | ||||||||||||||||||||||||||||||||||
1806194 | 1806194 | CO | school | 801920 | 1040 | Academy 20 | 80192000004 | 2524 | Edith Wolford Elementary School | Regular School | No | Elementary | PK | 05 | 2020 | grade_1 | 31 | 0 | 6 | 0 | 0 | 0 | 0 | 23 | 14 | 37 | 31 | 0 | 6 | 0 | 0 | 0 | 0 | 23 | 14 | 37 | ||||||||||||||||||||||||||||||||||
1806195 | 1806195 | CO | school | 801920 | 1040 | Academy 20 | 80192000004 | 2524 | Edith Wolford Elementary School | Regular School | No | Elementary | PK | 05 | 2020 | grade_2 | 39 | 0 | 9 | 0 | 1 | 0 | 2 | 28 | 23 | 51 | 39 | 0 | 9 | 0 | 1 | 0 | 2 | 28 | 23 | 51 | ||||||||||||||||||||||||||||||||||
1806196 | 1806196 | CO | school | 801920 | 1040 | Academy 20 | 80192000004 | 2524 | Edith Wolford Elementary School | Regular School | No | Elementary | PK | 05 | 2020 | grade_3 | 41 | 1 | 9 | 0 | 0 | 0 | 0 | 34 | 17 | 51 | 41 | 1 | 9 | 0 | 0 | 0 | 0 | 34 | 17 | 51 | ||||||||||||||||||||||||||||||||||
1806197 | 1806197 | CO | school | 801920 | 1040 | Academy 20 | 80192000004 | 2524 | Edith Wolford Elementary School | Regular School | No | Elementary | PK | 05 | 2020 | grade_4 | 102 | 0 | 13 | 0 | 0 | 0 | 8 | 61 | 62 | 123 | 102 | 0 | 13 | 0 | 0 | 0 | 8 | 61 | 62 | 123 | ||||||||||||||||||||||||||||||||||
1806198 | 1806198 | CO | school | 801920 | 1040 | Academy 20 | 80192000004 | 2524 | Edith Wolford Elementary School | Regular School | No | Elementary | PK | 05 | 2020 | grade_5 | 42 | 0 | 4 | 0 | 1 | 0 | 3 | 27 | 23 | 50 | 42 | 0 | 4 | 0 | 1 | 0 | 3 | 27 | 23 | 50 | ||||||||||||||||||||||||||||||||||
1806199 | 1806199 | CO | school | 801920 | 1040 | Academy 20 | 80192000004 | 2524 | Edith Wolford Elementary School | Regular School | No | Elementary | PK | 05 | 2020 | kindergarten_full_day | 29 | 0 | 11 | 0 | 0 | 0 | 3 | 25 | 18 | 43 | 29 | 0 | 11 | 0 | 0 | 0 | 3 | 25 | 18 | 43 | ||||||||||||||||||||||||||||||||||
1806200 | 1806200 | CO | school | 801920 | 1040 | Academy 20 | 80192000004 | 2524 | Edith Wolford Elementary School | Regular School | No | Elementary | PK | 05 | 2020 | kindergarten_half_day | 4 | 1 | 0 | 0 | 0 | 0 | 0 | 2 | 3 | 5 | 4 | 1 | 0 | 0 | 0 | 0 | 0 | 2 | 3 | 5 | ||||||||||||||||||||||||||||||||||
1806201 | 1806201 | CO | school | 801920 | 1040 | Academy 20 | 80192000004 | 2524 | Edith Wolford Elementary School | Regular School | No | Elementary | PK | 05 | 2020 | pk_12_total | 301 | 2 | 56 | 0 | 2 | 0 | 17 | 210 | 168 | 378 | 301 | 2 | 56 | 0 | 2 | 0 | 17 | 210 | 168 | 378 | ||||||||||||||||||||||||||||||||||
1806202 | 1806202 | CO | school | 801920 | 1040 | Academy 20 | 80192000004 | 2524 | Edith Wolford Elementary School | Regular School | No | Elementary | PK | 05 | 2020 | pre_kindergarten | 13 | 0 | 4 | 0 | 0 | 0 | 1 | 10 | 8 | 18 | 13 | 0 | 4 | 0 | 0 | 0 | 1 | 10 | 8 | 18 | ||||||||||||||||||||||||||||||||||
1806203 | 1806203 | CO | school | 801920 | 1040 | Academy 20 | 80192001496 | 2800 | Explorer Elementary School | Regular School | No | Elementary | PK | 05 | 2020 | grade_1 | 49 | 1 | 14 | 0 | 2 | 0 | 5 | 39 | 32 | 71 | 49 | 1 | 14 | 0 | 2 | 0 | 5 | 39 | 32 | 71 | ||||||||||||||||||||||||||||||||||
1806204 | 1806204 | CO | school | 801920 | 1040 | Academy 20 | 80192001496 | 2800 | Explorer Elementary School | Regular School | No | Elementary | PK | 05 | 2020 | grade_2 | 63 | 5 | 5 | 0 | 2 | 0 | 2 | 37 | 40 | 77 | 63 | 5 | 5 | 0 | 2 | 0 | 2 | 37 | 40 | 77 | ||||||||||||||||||||||||||||||||||
1806205 | 1806205 | CO | school | 801920 | 1040 | Academy 20 | 80192001496 | 2800 | Explorer Elementary School | Regular School | No | Elementary | PK | 05 | 2020 | grade_3 | 62 | 1 | 12 | 0 | 2 | 1 | 5 | 49 | 34 | 83 | 62 | 1 | 12 | 0 | 2 | 1 | 5 | 49 | 34 | 83 | ||||||||||||||||||||||||||||||||||
1806206 | 1806206 | CO | school | 801920 | 1040 | Academy 20 | 80192001496 | 2800 | Explorer Elementary School | Regular School | No | Elementary | PK | 05 | 2020 | grade_4 | 56 | 3 | 16 | 0 | 0 | 1 | 4 | 42 | 38 | 80 | 56 | 3 | 16 | 0 | 0 | 1 | 4 | 42 | 38 | 80 | ||||||||||||||||||||||||||||||||||
1806207 | 1806207 | CO | school | 801920 | 1040 | Academy 20 | 80192001496 | 2800 | Explorer Elementary School | Regular School | No | Elementary | PK | 05 | 2020 | grade_5 | 61 | 3 | 14 | 0 | 1 | 1 | 7 | 47 | 40 | 87 | 61 | 3 | 14 | 0 | 1 | 1 | 7 | 47 | 40 | 87 | ||||||||||||||||||||||||||||||||||
1806208 | 1806208 | CO | school | 801920 | 1040 | Academy 20 | 80192001496 | 2800 | Explorer Elementary School | Regular School | No | Elementary | PK | 05 | 2020 | kindergarten_full_day | 53 | 3 | 10 | 0 | 1 | 1 | 7 | 35 | 40 | 75 | 53 | 3 | 10 | 0 | 1 | 1 | 7 | 35 | 40 | 75 | ||||||||||||||||||||||||||||||||||
1806209 | 1806209 | CO | school | 801920 | 1040 | Academy 20 | 80192001496 | 2800 | Explorer Elementary School | Regular School | No | Elementary | PK | 05 | 2020 | pk_12_total | 369 | 17 | 77 | 0 | 10 | 4 | 34 | 271 | 240 | 511 | 369 | 17 | 77 | 0 | 10 | 4 | 34 | 271 | 240 | 511 | ||||||||||||||||||||||||||||||||||
1806210 | 1806210 | CO | school | 801920 | 1040 | Academy 20 | 80192001496 | 2800 | Explorer Elementary School | Regular School | No | Elementary | PK | 05 | 2020 | pre_kindergarten | 25 | 1 | 6 | 0 | 2 | 0 | 4 | 22 | 16 | 38 | 25 | 1 | 6 | 0 | 2 | 0 | 4 | 22 | 16 | 38 | ||||||||||||||||||||||||||||||||||
1806211 | 1806211 | CO | school | 801920 | 1040 | Academy 20 | 80192001319 | 3104 | Foothills Elementary School | Regular School | No | Elementary | KG | 05 | 2020 | grade_1 | 42 | 4 | 10 | 2 | 2 | 0 | 10 | 36 | 34 | 70 | 42 | 4 | 10 | 2 | 2 | 0 | 10 | 36 | 34 | 70 | ||||||||||||||||||||||||||||||||||
1806212 | 1806212 | CO | school | 801920 | 1040 | Academy 20 | 80192001319 | 3104 | Foothills Elementary School | Regular School | No | Elementary | KG | 05 | 2020 | grade_2 | 39 | 2 | 14 | 0 | 1 | 0 | 6 | 30 | 32 | 62 | 39 | 2 | 14 | 0 | 1 | 0 | 6 | 30 | 32 | 62 | ||||||||||||||||||||||||||||||||||
1806213 | 1806213 | CO | school | 801920 | 1040 | Academy 20 | 80192001319 | 3104 | Foothills Elementary School | Regular School | No | Elementary | KG | 05 | 2020 | grade_3 | 48 | 1 | 22 | 0 | 1 | 0 | 8 | 40 | 40 | 80 | 48 | 1 | 22 | 0 | 1 | 0 | 8 | 40 | 40 | 80 | ||||||||||||||||||||||||||||||||||
1806214 | 1806214 | CO | school | 801920 | 1040 | Academy 20 | 80192001319 | 3104 | Foothills Elementary School | Regular School | No | Elementary | KG | 05 | 2020 | grade_4 | 47 | 3 | 16 | 0 | 1 | 0 | 6 | 34 | 39 | 73 | 47 | 3 | 16 | 0 | 1 | 0 | 6 | 34 | 39 | 73 | ||||||||||||||||||||||||||||||||||
1806215 | 1806215 | CO | school | 801920 | 1040 | Academy 20 | 80192001319 | 3104 | Foothills Elementary School | Regular School | No | Elementary | KG | 05 | 2020 | grade_5 | 58 | 2 | 12 | 0 | 1 | 0 | 4 | 42 | 35 | 77 | 58 | 2 | 12 | 0 | 1 | 0 | 4 | 42 | 35 | 77 | ||||||||||||||||||||||||||||||||||
1806216 | 1806216 | CO | school | 801920 | 1040 | Academy 20 | 80192001319 | 3104 | Foothills Elementary School | Regular School | No | Elementary | KG | 05 | 2020 | kindergarten_full_day | 51 | 1 | 18 | 0 | 0 | 0 | 8 | 45 | 33 | 78 | 51 | 1 | 18 | 0 | 0 | 0 | 8 | 45 | 33 | 78 | ||||||||||||||||||||||||||||||||||
1806217 | 1806217 | CO | school | 801920 | 1040 | Academy 20 | 80192001319 | 3104 | Foothills Elementary School | Regular School | No | Elementary | KG | 05 | 2020 | pk_12_total | 285 | 13 | 92 | 2 | 6 | 0 | 42 | 227 | 213 | 440 | 285 | 13 | 92 | 2 | 6 | 0 | 42 | 227 | 213 | 440 | ||||||||||||||||||||||||||||||||||
1806218 | 1806218 | CO | school | 801920 | 1040 | Academy 20 | 80192001387 | 3238 | Frontier Elementary School | Regular School | No | Elementary | PK | 05 | 2020 | grade_1 | 24 | 1 | 9 | 0 | 3 | 0 | 1 | 17 | 21 | 38 | 24 | 1 | 9 | 0 | 3 | 0 | 1 | 17 | 21 | 38 | ||||||||||||||||||||||||||||||||||
1806219 | 1806219 | CO | school | 801920 | 1040 | Academy 20 | 80192001387 | 3238 | Frontier Elementary School | Regular School | No | Elementary | PK | 05 | 2020 | grade_2 | 24 | 3 | 7 | 1 | 5 | 1 | 7 | 28 | 20 | 48 | 24 | 3 | 7 | 1 | 5 | 1 | 7 | 28 | 20 | 48 | ||||||||||||||||||||||||||||||||||
1806220 | 1806220 | CO | school | 801920 | 1040 | Academy 20 | 80192001387 | 3238 | Frontier Elementary School | Regular School | No | Elementary | PK | 05 | 2020 | grade_3 | 38 | 1 | 12 | 1 | 2 | 0 | 5 | 27 | 32 | 59 | 38 | 1 | 12 | 1 | 2 | 0 | 5 | 27 | 32 | 59 | ||||||||||||||||||||||||||||||||||
1806221 | 1806221 | CO | school | 801920 | 1040 | Academy 20 | 80192001387 | 3238 | Frontier Elementary School | Regular School | No | Elementary | PK | 05 | 2020 | grade_4 | 31 | 2 | 12 | 0 | 3 | 0 | 6 | 24 | 30 | 54 | 31 | 2 | 12 | 0 | 3 | 0 | 6 | 24 | 30 | 54 | ||||||||||||||||||||||||||||||||||
1806222 | 1806222 | CO | school | 801920 | 1040 | Academy 20 | 80192001387 | 3238 | Frontier Elementary School | Regular School | No | Elementary | PK | 05 | 2020 | grade_5 | 25 | 3 | 8 | 0 | 3 | 1 | 6 | 25 | 21 | 46 | 25 | 3 | 8 | 0 | 3 | 1 | 6 | 25 | 21 | 46 | ||||||||||||||||||||||||||||||||||
1806223 | 1806223 | CO | school | 801920 | 1040 | Academy 20 | 80192001387 | 3238 | Frontier Elementary School | Regular School | No | Elementary | PK | 05 | 2020 | kindergarten_full_day | 25 | 0 | 11 | 0 | 5 | 0 | 3 | 27 | 17 | 44 | 25 | 0 | 11 | 0 | 5 | 0 | 3 | 27 | 17 | 44 | ||||||||||||||||||||||||||||||||||
1806224 | 1806224 | CO | school | 801920 | 1040 | Academy 20 | 80192001387 | 3238 | Frontier Elementary School | Regular School | No | Elementary | PK | 05 | 2020 | pk_12_total | 180 | 12 | 62 | 2 | 22 | 2 | 33 | 163 | 150 | 313 | 180 | 12 | 62 | 2 | 22 | 2 | 33 | 163 | 150 | 313 | ||||||||||||||||||||||||||||||||||
1806225 | 1806225 | CO | school | 801920 | 1040 | Academy 20 | 80192001387 | 3238 | Frontier Elementary School | Regular School | No | Elementary | PK | 05 | 2020 | pre_kindergarten | 13 | 2 | 3 | 0 | 1 | 0 | 5 | 15 | 9 | 24 | 13 | 2 | 3 | 0 | 1 | 0 | 5 | 15 | 9 | 24 | ||||||||||||||||||||||||||||||||||
1806226 | 1806226 | CO | school | 801920 | 1040 | Academy 20 | 80192001320 | 3985 | High Plains Elementary School | Regular School | No | Elementary | PK | 05 | 2020 | grade_1 | 28 | 1 | 20 | 0 | 4 | 0 | 3 | 30 | 26 | 56 | 28 | 1 | 20 | 0 | 4 | 0 | 3 | 30 | 26 | 56 | ||||||||||||||||||||||||||||||||||
1806227 | 1806227 | CO | school | 801920 | 1040 | Academy 20 | 80192001320 | 3985 | High Plains Elementary School | Regular School | No | Elementary | PK | 05 | 2020 | grade_2 | 20 | 2 | 14 | 0 | 3 | 0 | 8 | 24 | 23 | 47 | 20 | 2 | 14 | 0 | 3 | 0 | 8 | 24 | 23 | 47 | ||||||||||||||||||||||||||||||||||
1806228 | 1806228 | CO | school | 801920 | 1040 | Academy 20 | 80192001320 | 3985 | High Plains Elementary School | Regular School | No | Elementary | PK | 05 | 2020 | grade_3 | 27 | 2 | 14 | 0 | 4 | 1 | 5 | 25 | 28 | 53 | 27 | 2 | 14 | 0 | 4 | 1 | 5 | 25 | 28 | 53 | ||||||||||||||||||||||||||||||||||
1806229 | 1806229 | CO | school | 801920 | 1040 | Academy 20 | 80192001320 | 3985 | High Plains Elementary School | Regular School | No | Elementary | PK | 05 | 2020 | grade_4 | 23 | 5 | 11 | 0 | 3 | 0 | 1 | 23 | 20 | 43 | 23 | 5 | 11 | 0 | 3 | 0 | 1 | 23 | 20 | 43 | ||||||||||||||||||||||||||||||||||
1806230 | 1806230 | CO | school | 801920 | 1040 | Academy 20 | 80192001320 | 3985 | High Plains Elementary School | Regular School | No | Elementary | PK | 05 | 2020 | grade_5 | 30 | 4 | 11 | 1 | 6 | 0 | 2 | 29 | 25 | 54 | 30 | 4 | 11 | 1 | 6 | 0 | 2 | 29 | 25 | 54 | ||||||||||||||||||||||||||||||||||
1806231 | 1806231 | CO | school | 801920 | 1040 | Academy 20 | 80192001320 | 3985 | High Plains Elementary School | Regular School | No | Elementary | PK | 05 | 2020 | kindergarten_full_day | 25 | 2 | 11 | 0 | 0 | 1 | 6 | 23 | 22 | 45 | 25 | 2 | 11 | 0 | 0 | 1 | 6 | 23 | 22 | 45 | ||||||||||||||||||||||||||||||||||
1806232 | 1806232 | CO | school | 801920 | 1040 | Academy 20 | 80192001320 | 3985 | High Plains Elementary School | Regular School | No | Elementary | PK | 05 | 2020 | kindergarten_half_day | 2 | 0 | 0 | 0 | 0 | 0 | 0 | 2 | 0 | 2 | 2 | 0 | 0 | 0 | 0 | 0 | 0 | 2 | 0 | 2 | ||||||||||||||||||||||||||||||||||
1806233 | 1806233 | CO | school | 801920 | 1040 | Academy 20 | 80192001320 | 3985 | High Plains Elementary School | Regular School | No | Elementary | PK | 05 | 2020 | pk_12_total | 166 | 17 | 88 | 1 | 22 | 2 | 26 | 167 | 155 | 322 | 166 | 17 | 88 | 1 | 22 | 2 | 26 | 167 | 155 | 322 | ||||||||||||||||||||||||||||||||||
1806234 | 1806234 | CO | school | 801920 | 1040 | Academy 20 | 80192001320 | 3985 | High Plains Elementary School | Regular School | No | Elementary | PK | 05 | 2020 | pre_kindergarten | 11 | 1 | 7 | 0 | 2 | 0 | 1 | 11 | 11 | 22 | 11 | 1 | 7 | 0 | 2 | 0 | 1 | 11 | 11 | 22 | ||||||||||||||||||||||||||||||||||
1806235 | 1806235 | CO | school | 801920 | 1040 | Academy 20 | 80192001429 | 5126 | Liberty High School | Regular School | No | High | 09 | 12 | 2020 | grade_10 | 305 | 14 | 65 | 3 | 15 | 1 | 34 | 228 | 209 | 437 | 305 | 14 | 65 | 3 | 15 | 1 | 34 | 228 | 209 | 437 | ||||||||||||||||||||||||||||||||||
1806236 | 1806236 | CO | school | 801920 | 1040 | Academy 20 | 80192001429 | 5126 | Liberty High School | Regular School | No | High | 09 | 12 | 2020 | grade_11 | 322 | 16 | 72 | 3 | 10 | 0 | 21 | 228 | 216 | 444 | 322 | 16 | 72 | 3 | 10 | 0 | 21 | 228 | 216 | 444 | ||||||||||||||||||||||||||||||||||
1806237 | 1806237 | CO | school | 801920 | 1040 | Academy 20 | 80192001429 | 5126 | Liberty High School | Regular School | No | High | 09 | 12 | 2020 | grade_12 | 244 | 21 | 44 | 5 | 8 | 1 | 32 | 184 | 171 | 355 | 244 | 21 | 44 | 5 | 8 | 1 | 32 | 184 | 171 | 355 | ||||||||||||||||||||||||||||||||||
1806238 | 1806238 | CO | school | 801920 | 1040 | Academy 20 | 80192001429 | 5126 | Liberty High School | Regular School | No | High | 09 | 12 | 2020 | grade_9 | 279 | 14 | 77 | 3 | 13 | 2 | 32 | 192 | 228 | 420 | 279 | 14 | 77 | 3 | 13 | 2 | 32 | 192 | 228 | 420 | ||||||||||||||||||||||||||||||||||
1806239 | 1806239 | CO | school | 801920 | 1040 | Academy 20 | 80192001429 | 5126 | Liberty High School | Regular School | No | High | 09 | 12 | 2020 | pk_12_total | 1150 | 65 | 258 | 14 | 46 | 4 | 119 | 832 | 824 | 1656 | 1150 | 65 | 258 | 14 | 46 | 4 | 119 | 832 | 824 | 1656 | ||||||||||||||||||||||||||||||||||
1806240 | 1806240 | CO | school | 801920 | 1040 | Academy 20 | 80192001593 | 6140 | Mountain Ridge Middle School | Regular School | No | Middle | 06 | 08 | 2020 | grade_6 | 192 | 9 | 56 | 0 | 12 | 3 | 17 | 146 | 143 | 289 | 192 | 9 | 56 | 0 | 12 | 3 | 17 | 146 | 143 | 289 | ||||||||||||||||||||||||||||||||||
1806241 | 1806241 | CO | school | 801920 | 1040 | Academy 20 | 80192001593 | 6140 | Mountain Ridge Middle School | Regular School | No | Middle | 06 | 08 | 2020 | grade_7 | 203 | 13 | 75 | 0 | 19 | 2 | 30 | 163 | 179 | 342 | 203 | 13 | 75 | 0 | 19 | 2 | 30 | 163 | 179 | 342 | ||||||||||||||||||||||||||||||||||
1806242 | 1806242 | CO | school | 801920 | 1040 | Academy 20 | 80192001593 | 6140 | Mountain Ridge Middle School | Regular School | No | Middle | 06 | 08 | 2020 | grade_8 | 230 | 20 | 56 | 1 | 18 | 3 | 30 | 175 | 183 | 358 | 230 | 20 | 56 | 1 | 18 | 3 | 30 | 175 | 183 | 358 | ||||||||||||||||||||||||||||||||||
1806243 | 1806243 | CO | school | 801920 | 1040 | Academy 20 | 80192001593 | 6140 | Mountain Ridge Middle School | Regular School | No | Middle | 06 | 08 | 2020 | pk_12_total | 625 | 42 | 187 | 1 | 49 | 8 | 77 | 484 | 505 | 989 | 625 | 42 | 187 | 1 | 49 | 8 | 77 | 484 | 505 | 989 | ||||||||||||||||||||||||||||||||||
1806244 | 1806244 | CO | school | 801920 | 1040 | Academy 20 | 80192000005 | 6158 | Mountain View Elementary School | Regular School | No | Elementary | KG | 05 | 2020 | grade_1 | 69 | 0 | 15 | 0 | 0 | 0 | 7 | 49 | 42 | 91 | 69 | 0 | 15 | 0 | 0 | 0 | 7 | 49 | 42 | 91 | ||||||||||||||||||||||||||||||||||
1806245 | 1806245 | CO | school | 801920 | 1040 | Academy 20 | 80192000005 | 6158 | Mountain View Elementary School | Regular School | No | Elementary | KG | 05 | 2020 | grade_2 | 75 | 3 | 13 | 0 | 6 | 1 | 5 | 53 | 50 | 103 | 75 | 3 | 13 | 0 | 6 | 1 | 5 | 53 | 50 | 103 | ||||||||||||||||||||||||||||||||||
1806246 | 1806246 | CO | school | 801920 | 1040 | Academy 20 | 80192000005 | 6158 | Mountain View Elementary School | Regular School | No | Elementary | KG | 05 | 2020 | grade_3 | 65 | 3 | 19 | 0 | 10 | 1 | 7 | 58 | 47 | 105 | 65 | 3 | 19 | 0 | 10 | 1 | 7 | 58 | 47 | 105 | ||||||||||||||||||||||||||||||||||
1806247 | 1806247 | CO | school | 801920 | 1040 | Academy 20 | 80192000005 | 6158 | Mountain View Elementary School | Regular School | No | Elementary | KG | 05 | 2020 | grade_4 | 81 | 3 | 7 | 1 | 4 | 1 | 4 | 55 | 46 | 101 | 81 | 3 | 7 | 1 | 4 | 1 | 4 | 55 | 46 | 101 | ||||||||||||||||||||||||||||||||||
1806248 | 1806248 | CO | school | 801920 | 1040 | Academy 20 | 80192000005 | 6158 | Mountain View Elementary School | Regular School | No | Elementary | KG | 05 | 2020 | grade_5 | 82 | 3 | 11 | 0 | 6 | 0 | 9 | 58 | 53 | 111 | 82 | 3 | 11 | 0 | 6 | 0 | 9 | 58 | 53 | 111 | ||||||||||||||||||||||||||||||||||
1806249 | 1806249 | CO | school | 801920 | 1040 | Academy 20 | 80192000005 | 6158 | Mountain View Elementary School | Regular School | No | Elementary | KG | 05 | 2020 | kindergarten_full_day | 62 | 1 | 16 | 0 | 4 | 0 | 7 | 41 | 49 | 90 | 62 | 1 | 16 | 0 | 4 | 0 | 7 | 41 | 49 | 90 | ||||||||||||||||||||||||||||||||||
1806250 | 1806250 | CO | school | 801920 | 1040 | Academy 20 | 80192000005 | 6158 | Mountain View Elementary School | Regular School | No | Elementary | KG | 05 | 2020 | kindergarten_half_day | 3 | 0 | 0 | 0 | 0 | 0 | 0 | 3 | 0 | 3 | 3 | 0 | 0 | 0 | 0 | 0 | 0 | 3 | 0 | 3 | ||||||||||||||||||||||||||||||||||
1806251 | 1806251 | CO | school | 801920 | 1040 | Academy 20 | 80192000005 | 6158 | Mountain View Elementary School | Regular School | No | Elementary | KG | 05 | 2020 | pk_12_total | 437 | 13 | 81 | 1 | 30 | 3 | 39 | 317 | 287 | 604 | 437 | 13 | 81 | 1 | 30 | 3 | 39 | 317 | 287 | 604 | ||||||||||||||||||||||||||||||||||
1806252 | 1806252 | CO | school | 801920 | 1040 | Academy 20 | 80192006745 | 6242 | New Summit Charter Academy | Regular School | Yes | Elementary | KG | 08 | 2020 | grade_1 | 65 | 3 | 15 | 0 | 2 | 0 | 14 | 49 | 50 | 99 | 65 | 3 | 15 | 0 | 2 | 0 | 14 | 49 | 50 | 99 | ||||||||||||||||||||||||||||||||||
1806253 | 1806253 | CO | school | 801920 | 1040 | Academy 20 | 80192006745 | 6242 | New Summit Charter Academy | Regular School | Yes | Elementary | KG | 08 | 2020 | grade_2 | 42 | 2 | 10 | 0 | 3 | 0 | 6 | 31 | 32 | 63 | 42 | 2 | 10 | 0 | 3 | 0 | 6 | 31 | 32 | 63 | ||||||||||||||||||||||||||||||||||
1806254 | 1806254 | CO | school | 801920 | 1040 | Academy 20 | 80192006745 | 6242 | New Summit Charter Academy | Regular School | Yes | Elementary | KG | 08 | 2020 | grade_3 | 50 | 3 | 9 | 0 | 3 | 0 | 7 | 36 | 36 | 72 | 50 | 3 | 9 | 0 | 3 | 0 | 7 | 36 | 36 | 72 | ||||||||||||||||||||||||||||||||||
1806255 | 1806255 | CO | school | 801920 | 1040 | Academy 20 | 80192006745 | 6242 | New Summit Charter Academy | Regular School | Yes | Elementary | KG | 08 | 2020 | grade_4 | 45 | 2 | 6 | 0 | 1 | 1 | 6 | 31 | 30 | 61 | 45 | 2 | 6 | 0 | 1 | 1 | 6 | 31 | 30 | 61 | ||||||||||||||||||||||||||||||||||
1806256 | 1806256 | CO | school | 801920 | 1040 | Academy 20 | 80192006745 | 6242 | New Summit Charter Academy | Regular School | Yes | Elementary | KG | 08 | 2020 | grade_5 | 34 | 5 | 6 | 0 | 1 | 1 | 4 | 27 | 24 | 51 | 34 | 5 | 6 | 0 | 1 | 1 | 4 | 27 | 24 | 51 | ||||||||||||||||||||||||||||||||||
1806257 | 1806257 | CO | school | 801920 | 1040 | Academy 20 | 80192006745 | 6242 | New Summit Charter Academy | Regular School | Yes | Elementary | KG | 08 | 2020 | grade_6 | 48 | 4 | 9 | 0 | 2 | 0 | 4 | 28 | 39 | 67 | 48 | 4 | 9 | 0 | 2 | 0 | 4 | 28 | 39 | 67 | ||||||||||||||||||||||||||||||||||
1806258 | 1806258 | CO | school | 801920 | 1040 | Academy 20 | 80192006745 | 6242 | New Summit Charter Academy | Regular School | Yes | Elementary | KG | 08 | 2020 | grade_7 | 31 | 3 | 6 | 0 | 0 | 1 | 0 | 19 | 22 | 41 | 31 | 3 | 6 | 0 | 0 | 1 | 0 | 19 | 22 | 41 | ||||||||||||||||||||||||||||||||||
1806259 | 1806259 | CO | school | 801920 | 1040 | Academy 20 | 80192006745 | 6242 | New Summit Charter Academy | Regular School | Yes | Elementary | KG | 08 | 2020 | kindergarten_full_day | 52 | 4 | 13 | 0 | 3 | 0 | 13 | 30 | 55 | 85 | 52 | 4 | 13 | 0 | 3 | 0 | 13 | 30 | 55 | 85 | ||||||||||||||||||||||||||||||||||
1806260 | 1806260 | CO | school | 801920 | 1040 | Academy 20 | 80192006745 | 6242 | New Summit Charter Academy | Regular School | Yes | Elementary | KG | 08 | 2020 | kindergarten_half_day | 14 | 0 | 0 | 0 | 0 | 0 | 1 | 6 | 9 | 15 | 14 | 0 | 0 | 0 | 0 | 0 | 1 | 6 | 9 | 15 | ||||||||||||||||||||||||||||||||||
1806261 | 1806261 | CO | school | 801920 | 1040 | Academy 20 | 80192006745 | 6242 | New Summit Charter Academy | Regular School | Yes | Elementary | KG | 08 | 2020 | pk_12_total | 381 | 26 | 74 | 0 | 15 | 3 | 55 | 257 | 297 | 554 | 381 | 26 | 74 | 0 | 15 | 3 | 55 | 257 | 297 | 554 | ||||||||||||||||||||||||||||||||||
1806262 | 1806262 | CO | school | 801920 | 1040 | Academy 20 | 80192006758 | 6247 | Legacy Peak Elementary School | Regular School | No | Elementary | PK | 05 | 2020 | grade_1 | 66 | 1 | 11 | 0 | 1 | 1 | 7 | 32 | 55 | 87 | 66 | 1 | 11 | 0 | 1 | 1 | 7 | 32 | 55 | 87 | ||||||||||||||||||||||||||||||||||
1806263 | 1806263 | CO | school | 801920 | 1040 | Academy 20 | 80192006758 | 6247 | Legacy Peak Elementary School | Regular School | No | Elementary | PK | 05 | 2020 | grade_2 | 68 | 2 | 15 | 1 | 1 | 0 | 8 | 46 | 49 | 95 | 68 | 2 | 15 | 1 | 1 | 0 | 8 | 46 | 49 | 95 | ||||||||||||||||||||||||||||||||||
1806264 | 1806264 | CO | school | 801920 | 1040 | Academy 20 | 80192006758 | 6247 | Legacy Peak Elementary School | Regular School | No | Elementary | PK | 05 | 2020 | grade_3 | 60 | 4 | 11 | 1 | 8 | 0 | 4 | 42 | 46 | 88 | 60 | 4 | 11 | 1 | 8 | 0 | 4 | 42 | 46 | 88 | ||||||||||||||||||||||||||||||||||
1806265 | 1806265 | CO | school | 801920 | 1040 | Academy 20 | 80192006758 | 6247 | Legacy Peak Elementary School | Regular School | No | Elementary | PK | 05 | 2020 | grade_4 | 64 | 2 | 11 | 0 | 7 | 0 | 9 | 57 | 36 | 93 | 64 | 2 | 11 | 0 | 7 | 0 | 9 | 57 | 36 | 93 | ||||||||||||||||||||||||||||||||||
1806266 | 1806266 | CO | school | 801920 | 1040 | Academy 20 | 80192006758 | 6247 | Legacy Peak Elementary School | Regular School | No | Elementary | PK | 05 | 2020 | grade_5 | 62 | 4 | 8 | 0 | 1 | 1 | 2 | 38 | 40 | 78 | 62 | 4 | 8 | 0 | 1 | 1 | 2 | 38 | 40 | 78 |
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]);