enrollments
Data source: Big Local News · About: Big Local
1,916 rows where grade = "pk_12_total", state = "CO" and year = 2020 sorted by district_nces_id
This data as json, CSV (advanced)
Link | rowid | state | county | county_state_id | admin_level | district_nces_id ▼ | district_state_id | district_state_type | district | school_nces_id | school_state_id | school | school_state_type | ccd_school_type | ccd_charter_school | ccd_school_lvl | ccd_school_low_grade | ccd_school_high_grade | year | term | grade | white | black | hispanic | native_american | native_american_alaskan_native | asian | native_hawaiian | asian_pacific_islander | native_hawaiian_pacific_islander | pacific_islander | multiracial | unknown_race | male | female | non_binary | unknown_gender | ell | ell_percent | homeless | homeless_percent | low_income | free_and_reduced | free_and_reduced_percent | disability | section_504 | total | white_int | black_int | hispanic_int | native_american_int | native_american_alaskan_native_int | asian_int | native_hawaiian_int | asian_pacific_islander_int | native_hawaiian_pacific_islander_int | pacific_islander_int | multiracial_int | unknown_race_int | male_int | female_int | non_binary_int | unknown_gender_int | ell_int | homeless_int | low_income_int | free_and_reduced_int | disability_int | section_504_int | total_int |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1802569 | 1802569 | CO | school | 800001 | 520 | Cheyenne County Re-5 | 80000100214 | 1608 | Cheyenne Wells Elementary School | Regular School | No | Elementary | PK | 06 | 2020 | pk_12_total | 114 | 2 | 11 | 0 | 0 | 0 | 0 | 64 | 63 | 127 | 114 | 2 | 11 | 0 | 0 | 0 | 0 | 64 | 63 | 127 | ||||||||||||||||||||||||||||||||||
1802577 | 1802577 | CO | school | 800001 | 520 | Cheyenne County Re-5 | 80000100215 | 1612 | Cheyenne Wells Junior/High School | Regular School | No | High | 07 | 12 | 2020 | pk_12_total | 59 | 0 | 11 | 0 | 0 | 0 | 0 | 44 | 26 | 70 | 59 | 0 | 11 | 0 | 0 | 0 | 0 | 44 | 26 | 70 | ||||||||||||||||||||||||||||||||||
1812592 | 1812592 | CO | school | 800004 | 9130 | Expeditionary BOCES | 80000400709 | 2840 | Rocky Mountain School of Expeditionary Learning | Regular School | No | Other | KG | 12 | 2020 | pk_12_total | 275 | 8 | 43 | 0 | 6 | 0 | 36 | 195 | 173 | 368 | 275 | 8 | 43 | 0 | 6 | 0 | 36 | 195 | 173 | 368 | ||||||||||||||||||||||||||||||||||
1812129 | 1812129 | CO | school | 800016 | 3200 | Yuma 1 | 80001601745 | 5221 | Little Indians Preschool | Regular School | No | Prekindergarten | PK | PK | 2020 | pk_12_total | 29 | 0 | 35 | 0 | 0 | 0 | 0 | 37 | 27 | 64 | 29 | 0 | 35 | 0 | 0 | 0 | 0 | 37 | 27 | 64 | ||||||||||||||||||||||||||||||||||
1812135 | 1812135 | CO | school | 800016 | 3200 | Yuma 1 | 80001601819 | 9791 | Yuma Middle School | Regular School | No | Middle | 05 | 08 | 2020 | pk_12_total | 123 | 0 | 145 | 0 | 0 | 0 | 0 | 127 | 141 | 268 | 123 | 0 | 145 | 0 | 0 | 0 | 0 | 127 | 141 | 268 | ||||||||||||||||||||||||||||||||||
1812141 | 1812141 | CO | school | 800016 | 3200 | Yuma 1 | 80001601820 | 9795 | Kenneth P Morris Elementary School | Regular School | No | Elementary | KG | 04 | 2020 | pk_12_total | 138 | 0 | 182 | 0 | 0 | 0 | 0 | 159 | 161 | 320 | 138 | 0 | 182 | 0 | 0 | 0 | 0 | 159 | 161 | 320 | ||||||||||||||||||||||||||||||||||
1812146 | 1812146 | CO | school | 800016 | 3200 | Yuma 1 | 80001601821 | 9799 | Yuma High School | Regular School | No | High | 09 | 12 | 2020 | pk_12_total | 114 | 1 | 134 | 0 | 1 | 0 | 1 | 125 | 126 | 251 | 114 | 1 | 134 | 0 | 1 | 0 | 1 | 125 | 126 | 251 | ||||||||||||||||||||||||||||||||||
1812152 | 1812152 | CO | school | 800017 | 3210 | Wray RD-2 | 80001701816 | 9725 | Wray Elementary School | Regular School | No | Elementary | PK | 04 | 2020 | pk_12_total | 224 | 0 | 108 | 0 | 0 | 0 | 3 | 174 | 161 | 335 | 224 | 0 | 108 | 0 | 0 | 0 | 3 | 174 | 161 | 335 | ||||||||||||||||||||||||||||||||||
1812158 | 1812158 | CO | school | 800017 | 3210 | Wray RD-2 | 80001701817 | 9729 | Buchanan Middle School | Regular School | No | Middle | 05 | 08 | 2020 | pk_12_total | 160 | 0 | 63 | 1 | 0 | 0 | 1 | 101 | 124 | 225 | 160 | 0 | 63 | 1 | 0 | 0 | 1 | 101 | 124 | 225 | ||||||||||||||||||||||||||||||||||
1812163 | 1812163 | CO | school | 800017 | 3210 | Wray RD-2 | 80001701818 | 9733 | Wray High School | Regular School | No | High | 09 | 12 | 2020 | pk_12_total | 134 | 0 | 60 | 1 | 0 | 0 | 4 | 105 | 94 | 199 | 134 | 0 | 60 | 1 | 0 | 0 | 4 | 105 | 94 | 199 | ||||||||||||||||||||||||||||||||||
1812171 | 1812171 | CO | school | 800018 | 3220 | Idalia RJ-3 | 80001801741 | 4227 | Idalia Elementary School | Regular School | No | Elementary | PK | 06 | 2020 | pk_12_total | 85 | 0 | 25 | 0 | 0 | 0 | 0 | 46 | 64 | 110 | 85 | 0 | 25 | 0 | 0 | 0 | 0 | 46 | 64 | 110 | ||||||||||||||||||||||||||||||||||
1812179 | 1812179 | CO | school | 800018 | 3220 | Idalia RJ-3 | 80001801742 | 4231 | Idalia Junior-Senior High School | Regular School | No | High | 07 | 12 | 2020 | pk_12_total | 65 | 0 | 24 | 1 | 0 | 0 | 0 | 45 | 45 | 90 | 65 | 0 | 24 | 1 | 0 | 0 | 0 | 45 | 45 | 90 | ||||||||||||||||||||||||||||||||||
1812193 | 1812193 | CO | school | 800019 | 3230 | Liberty J-4 | 80001901744 | 5123 | Liberty School | Career and Technical School | No | Other | PK | 12 | 2020 | pk_12_total | 59 | 0 | 8 | 0 | 0 | 0 | 1 | 38 | 30 | 68 | 59 | 0 | 8 | 0 | 0 | 0 | 1 | 38 | 30 | 68 | ||||||||||||||||||||||||||||||||||
1812208 | 1812208 | CO | school | 800020 | 8001 | Charter School Institute | 80002000727 | 15 | Academy of Charter Schools | Regular School | Yes | Other | PK | 12 | 2020 | pk_12_total | 1100 | 15 | 531 | 1 | 143 | 1 | 95 | 937 | 949 | 1886 | 1100 | 15 | 531 | 1 | 143 | 1 | 95 | 937 | 949 | 1886 | ||||||||||||||||||||||||||||||||||
1812214 | 1812214 | CO | school | 800020 | 8001 | Charter School Institute | 80002006418 | 75 | Animas High School | Regular School | Yes | High | 09 | 12 | 2020 | pk_12_total | 160 | 0 | 34 | 6 | 2 | 1 | 5 | 106 | 102 | 208 | 160 | 0 | 34 | 6 | 2 | 1 | 5 | 106 | 102 | 208 | ||||||||||||||||||||||||||||||||||
1812218 | 1812218 | CO | school | 800020 | 8001 | Charter School Institute | 80002006777 | 149 | Colorado Early Colleges Fort Collins West | Regular School | Yes | Middle | 06 | 08 | 2020 | pk_12_total | 27 | 0 | 7 | 0 | 0 | 0 | 1 | 18 | 17 | 35 | 27 | 0 | 7 | 0 | 0 | 0 | 1 | 18 | 17 | 35 | ||||||||||||||||||||||||||||||||||
1812226 | 1812226 | CO | school | 800020 | 8001 | Charter School Institute | 80002006768 | 493 | Axis International Academy | Regular School | Yes | Elementary | KG | 05 | 2020 | pk_12_total | 142 | 5 | 46 | 1 | 6 | 0 | 3 | 99 | 104 | 203 | 142 | 5 | 46 | 1 | 6 | 0 | 3 | 99 | 104 | 203 | ||||||||||||||||||||||||||||||||||
1812236 | 1812236 | CO | school | 800020 | 8001 | Charter School Institute | 80002002018 | 653 | Stone Creek School | Regular School | Yes | Elementary | KG | 08 | 2020 | pk_12_total | 223 | 2 | 79 | 0 | 4 | 1 | 12 | 180 | 141 | 321 | 223 | 2 | 79 | 0 | 4 | 1 | 12 | 180 | 141 | 321 | ||||||||||||||||||||||||||||||||||
1812246 | 1812246 | CO | school | 800020 | 8001 | Charter School Institute | 80002002033 | 655 | High Point Academy | Regular School | Yes | Elementary | PK | 08 | 2020 | pk_12_total | 133 | 221 | 318 | 13 | 25 | 4 | 1 | 363 | 352 | 715 | 133 | 221 | 318 | 13 | 25 | 4 | 1 | 363 | 352 | 715 | ||||||||||||||||||||||||||||||||||
1812255 | 1812255 | CO | school | 800020 | 8001 | Charter School Institute | 80002001998 | 657 | Academy of Arts and Knowledge Elementary | Regular School | Yes | Elementary | KG | 05 | 2020 | pk_12_total | 157 | 5 | 32 | 0 | 4 | 1 | 13 | 99 | 113 | 212 | 157 | 5 | 32 | 0 | 4 | 1 | 13 | 99 | 113 | 212 | ||||||||||||||||||||||||||||||||||
1812270 | 1812270 | CO | school | 800020 | 8001 | Charter School Institute | 80002006305 | 1279 | Caprock Academy | Regular School | Yes | Other | KG | 12 | 2020 | pk_12_total | 711 | 5 | 99 | 0 | 21 | 1 | 41 | 422 | 456 | 878 | 711 | 5 | 99 | 0 | 21 | 1 | 41 | 422 | 456 | 878 | ||||||||||||||||||||||||||||||||||
1812278 | 1812278 | CO | school | 800020 | 8001 | Charter School Institute | 80002006784 | 1371 | Coperni 3 | Regular School | Yes | Elementary | KG | 06 | 2020 | pk_12_total | 92 | 30 | 92 | 1 | 3 | 3 | 5 | 115 | 111 | 226 | 92 | 30 | 92 | 1 | 3 | 3 | 5 | 115 | 111 | 226 | ||||||||||||||||||||||||||||||||||
1812292 | 1812292 | CO | school | 800020 | 8001 | Charter School Institute | 80002006779 | 1387 | Colorado Early Colleges Windsor | Regular School | Yes | Other | KG | 12 | 2020 | pk_12_total | 152 | 1 | 18 | 0 | 2 | 0 | 12 | 93 | 92 | 185 | 152 | 1 | 18 | 0 | 2 | 0 | 12 | 93 | 92 | 185 | ||||||||||||||||||||||||||||||||||
1812304 | 1812304 | CO | school | 800020 | 8001 | Charter School Institute | 80002006708 | 1505 | Colorado Military Academy | Regular School | Yes | Other | KG | 12 | 2020 | pk_12_total | 247 | 55 | 162 | 6 | 14 | 5 | 20 | 321 | 188 | 509 | 247 | 55 | 162 | 6 | 14 | 5 | 20 | 321 | 188 | 509 | ||||||||||||||||||||||||||||||||||
1812309 | 1812309 | CO | school | 800020 | 8001 | Charter School Institute | 80002006710 | 1633 | Colorado Early Colleges Aurora | Regular School | Yes | High | 09 | 12 | 2020 | pk_12_total | 52 | 50 | 205 | 3 | 16 | 0 | 17 | 147 | 196 | 343 | 52 | 50 | 205 | 3 | 16 | 0 | 17 | 147 | 196 | 343 | ||||||||||||||||||||||||||||||||||
1812319 | 1812319 | CO | school | 800020 | 8001 | Charter School Institute | 80002001912 | 1791 | Colorado Springs Charter Academy | Regular School | Yes | Elementary | KG | 08 | 2020 | pk_12_total | 269 | 10 | 116 | 0 | 0 | 0 | 36 | 210 | 221 | 431 | 269 | 10 | 116 | 0 | 0 | 0 | 36 | 210 | 221 | 431 | ||||||||||||||||||||||||||||||||||
1812324 | 1812324 | CO | school | 800020 | 8001 | Charter School Institute | 80002006310 | 1795 | Colorado Springs Early Colleges | Regular School | Yes | High | 09 | 12 | 2020 | pk_12_total | 352 | 32 | 121 | 5 | 26 | 1 | 42 | 286 | 293 | 579 | 352 | 32 | 121 | 5 | 26 | 1 | 42 | 286 | 293 | 579 | ||||||||||||||||||||||||||||||||||
1812331 | 1812331 | CO | school | 800020 | 8001 | Charter School Institute | 80002001876 | 1882 | Community Leadership Academy | Regular School | Yes | Elementary | PK | 05 | 2020 | pk_12_total | 37 | 3 | 410 | 1 | 0 | 0 | 5 | 227 | 229 | 456 | 37 | 3 | 410 | 1 | 0 | 0 | 5 | 227 | 229 | 456 | ||||||||||||||||||||||||||||||||||
1812342 | 1812342 | CO | school | 800020 | 8001 | Charter School Institute | 80002001569 | 2035 | Crown Pointe Charter Academy | Regular School | Yes | Elementary | KG | 08 | 2020 | pk_12_total | 144 | 0 | 291 | 2 | 20 | 0 | 12 | 223 | 246 | 469 | 144 | 0 | 291 | 2 | 20 | 0 | 12 | 223 | 246 | 469 | ||||||||||||||||||||||||||||||||||
1812350 | 1812350 | CO | school | 800020 | 8001 | Charter School Institute | 80002006542 | 2067 | Colorado Early College Fort Collins | Regular School | Yes | High | 06 | 12 | 2020 | pk_12_total | 1023 | 18 | 187 | 1 | 44 | 6 | 40 | 641 | 678 | 1319 | 1023 | 18 | 187 | 1 | 44 | 6 | 40 | 641 | 678 | 1319 | ||||||||||||||||||||||||||||||||||
1812355 | 1812355 | CO | school | 800020 | 8001 | Charter School Institute | 80002006634 | 2196 | COLORADO EARLY COLLEGES - Douglas County | Regular School | Yes | High | 09 | 12 | 2020 | pk_12_total | 494 | 13 | 70 | 5 | 22 | 0 | 47 | 279 | 372 | 651 | 494 | 13 | 70 | 5 | 22 | 0 | 47 | 279 | 372 | 651 | ||||||||||||||||||||||||||||||||||
1812363 | 1812363 | CO | school | 800020 | 8001 | Charter School Institute | 80002006390 | 2837 | Early College of Arvada | Regular School | Yes | High | 06 | 12 | 2020 | pk_12_total | 86 | 5 | 216 | 1 | 25 | 0 | 2 | 156 | 179 | 335 | 86 | 5 | 216 | 1 | 25 | 0 | 2 | 156 | 179 | 335 | ||||||||||||||||||||||||||||||||||
1812374 | 1812374 | CO | school | 800020 | 8001 | Charter School Institute | 80002006586 | 3326 | Colorado International Language Academy | Regular School | Yes | Elementary | KG | 08 | 2020 | pk_12_total | 191 | 36 | 140 | 1 | 6 | 1 | 6 | 168 | 213 | 381 | 191 | 36 | 140 | 1 | 6 | 1 | 6 | 168 | 213 | 381 | ||||||||||||||||||||||||||||||||||
1812388 | 1812388 | CO | school | 800020 | 8001 | Charter School Institute | 80002006639 | 3393 | Golden View Classical Academy | Regular School | Yes | Other | KG | 12 | 2020 | pk_12_total | 550 | 5 | 61 | 4 | 30 | 1 | 27 | 337 | 341 | 678 | 550 | 5 | 61 | 4 | 30 | 1 | 27 | 337 | 341 | 678 | ||||||||||||||||||||||||||||||||||
1812398 | 1812398 | CO | school | 800020 | 8001 | Charter School Institute | 80002006503 | 3439 | Global Village Academy - Northglenn | Regular School | Yes | Elementary | KG | 08 | 2020 | pk_12_total | 348 | 8 | 467 | 4 | 28 | 2 | 26 | 406 | 477 | 883 | 348 | 8 | 467 | 4 | 28 | 2 | 26 | 406 | 477 | 883 | ||||||||||||||||||||||||||||||||||
1812399 | 1812399 | CO | school | 800020 | 8001 | Charter School Institute | 80002006653 | 3513 | Early Learning Center at New Legacy Charter School | Regular School | Yes | Prekindergarten | PK | PK | 2020 | pk_12_total | 0 | 2 | 6 | 0 | 0 | 0 | 0 | 6 | 2 | 8 | 0 | 2 | 6 | 0 | 0 | 0 | 0 | 6 | 2 | 8 | ||||||||||||||||||||||||||||||||||
1812407 | 1812407 | CO | school | 800020 | 8001 | Charter School Institute | 80002006595 | 4403 | James Irwin Charter Academy | Regular School | Yes | Elementary | KG | 05 | 2020 | pk_12_total | 143 | 32 | 108 | 3 | 7 | 1 | 32 | 172 | 154 | 326 | 143 | 32 | 108 | 3 | 7 | 1 | 32 | 172 | 154 | 326 | ||||||||||||||||||||||||||||||||||
1812412 | 1812412 | CO | school | 800020 | 8001 | Charter School Institute | 80002006700 | 5147 | Launch High School | Regular School | Yes | High | 09 | 12 | 2020 | pk_12_total | 57 | 2 | 14 | 0 | 0 | 0 | 4 | 44 | 33 | 77 | 57 | 2 | 14 | 0 | 0 | 0 | 4 | 44 | 33 | 77 | ||||||||||||||||||||||||||||||||||
1812419 | 1812419 | CO | school | 800020 | 8001 | Charter School Institute | 80002006701 | 5423 | Mountain Village Montessori Charter School | Regular School | Yes | Elementary | PK | 05 | 2020 | pk_12_total | 153 | 0 | 6 | 0 | 2 | 0 | 0 | 90 | 71 | 161 | 153 | 0 | 6 | 0 | 2 | 0 | 0 | 90 | 71 | 161 | ||||||||||||||||||||||||||||||||||
1812429 | 1812429 | CO | school | 800020 | 8001 | Charter School Institute | 80002006761 | 5431 | Coperni 2 | Regular School | Yes | Elementary | KG | 07 | 2020 | pk_12_total | 82 | 38 | 66 | 1 | 0 | 0 | 10 | 91 | 106 | 197 | 82 | 38 | 66 | 1 | 0 | 0 | 10 | 91 | 106 | 197 | ||||||||||||||||||||||||||||||||||
1812435 | 1812435 | CO | school | 800020 | 8001 | Charter School Institute | 80002006502 | 5453 | Mountain Middle School | Regular School | Yes | Middle | 04 | 08 | 2020 | pk_12_total | 213 | 0 | 22 | 4 | 2 | 1 | 3 | 126 | 119 | 245 | 213 | 0 | 22 | 4 | 2 | 1 | 3 | 126 | 119 | 245 | ||||||||||||||||||||||||||||||||||
1812440 | 1812440 | CO | school | 800020 | 8001 | Charter School Institute | 80002006706 | 5845 | Monument View Montessori Charter School | Regular School | Yes | Elementary | PK | 05 | 2020 | pk_12_total | 40 | 0 | 4 | 0 | 1 | 0 | 1 | 24 | 22 | 46 | 40 | 0 | 4 | 0 | 1 | 0 | 1 | 24 | 22 | 46 | ||||||||||||||||||||||||||||||||||
1812452 | 1812452 | CO | school | 800020 | 8001 | Charter School Institute | 80002006589 | 5851 | Mountain Song Community School | Regular School | Yes | Elementary | KG | 08 | 2020 | pk_12_total | 240 | 3 | 93 | 5 | 4 | 1 | 24 | 188 | 182 | 370 | 240 | 3 | 93 | 5 | 4 | 1 | 24 | 188 | 182 | 370 | ||||||||||||||||||||||||||||||||||
1812460 | 1812460 | CO | school | 800020 | 8001 | Charter School Institute | 80002006602 | 5957 | Montessori del Mundo Charter School | Regular School | Yes | Elementary | PK | 06 | 2020 | pk_12_total | 47 | 17 | 283 | 0 | 2 | 2 | 8 | 186 | 173 | 359 | 47 | 17 | 283 | 0 | 2 | 2 | 8 | 186 | 173 | 359 | ||||||||||||||||||||||||||||||||||
1812466 | 1812466 | CO | school | 800020 | 8001 | Charter School Institute | 80002001882 | 6219 | New America School - Lowry | Alternative School | Yes | High | 09 | 12 | 2020 | pk_12_total | 16 | 26 | 212 | 7 | 23 | 1 | 0 | 139 | 146 | 285 | 16 | 26 | 212 | 7 | 23 | 1 | 0 | 139 | 146 | 285 | ||||||||||||||||||||||||||||||||||
1812471 | 1812471 | CO | school | 800020 | 8001 | Charter School Institute | 80002006661 | 6266 | New Legacy Charter School | Alternative School | Yes | High | 09 | 12 | 2020 | pk_12_total | 5 | 18 | 74 | 0 | 0 | 1 | 0 | 18 | 80 | 98 | 5 | 18 | 74 | 0 | 0 | 1 | 0 | 18 | 80 | 98 | ||||||||||||||||||||||||||||||||||
1812485 | 1812485 | CO | school | 800020 | 8001 | Charter School Institute | 80002001915 | 6914 | The Pinnacle Charter School | Regular School | Yes | Other | KG | 12 | 2020 | pk_12_total | 269 | 20 | 1622 | 6 | 73 | 3 | 25 | 958 | 1060 | 2018 | 269 | 20 | 1622 | 6 | 73 | 3 | 25 | 958 | 1060 | 2018 | ||||||||||||||||||||||||||||||||||
1812495 | 1812495 | CO | school | 800020 | 8001 | Charter School Institute | 80002006320 | 7278 | Ricardo Flores Magon Academy | Regular School | Yes | Elementary | KG | 08 | 2020 | pk_12_total | 5 | 3 | 253 | 0 | 0 | 0 | 0 | 124 | 137 | 261 | 5 | 3 | 253 | 0 | 0 | 0 | 0 | 124 | 137 | 261 | ||||||||||||||||||||||||||||||||||
1812505 | 1812505 | CO | school | 800020 | 8001 | Charter School Institute | 80002001913 | 7512 | Ross Montessori School | Regular School | Yes | Elementary | KG | 08 | 2020 | pk_12_total | 210 | 0 | 73 | 0 | 3 | 1 | 5 | 135 | 157 | 292 | 210 | 0 | 73 | 0 | 3 | 1 | 5 | 135 | 157 | 292 | ||||||||||||||||||||||||||||||||||
1812515 | 1812515 | CO | school | 800020 | 8001 | Charter School Institute | 80002006651 | 8061 | Salida Montessori Charter School | Regular School | Yes | Elementary | PK | 08 | 2020 | pk_12_total | 75 | 2 | 4 | 0 | 0 | 0 | 5 | 36 | 50 | 86 | 75 | 2 | 4 | 0 | 0 | 0 | 5 | 36 | 50 | 86 | ||||||||||||||||||||||||||||||||||
1812526 | 1812526 | CO | school | 800020 | 8001 | Charter School Institute | 80002006635 | 8821 | Two Rivers Community School | Regular School | Yes | Elementary | KG | 08 | 2020 | pk_12_total | 217 | 6 | 112 | 0 | 7 | 0 | 7 | 185 | 164 | 349 | 217 | 6 | 112 | 0 | 7 | 0 | 7 | 185 | 164 | 349 | ||||||||||||||||||||||||||||||||||
1812541 | 1812541 | CO | school | 800020 | 8001 | Charter School Institute | 80002006437 | 8825 | Thomas MacLaren State Charter School | Regular School | Yes | Other | KG | 12 | 2020 | pk_12_total | 573 | 11 | 189 | 2 | 22 | 0 | 70 | 414 | 453 | 867 | 573 | 11 | 189 | 2 | 22 | 0 | 70 | 414 | 453 | 867 | ||||||||||||||||||||||||||||||||||
1812546 | 1812546 | CO | school | 800020 | 8001 | Charter School Institute | 80002006585 | 9037 | Victory Preparatory Academy High State Charter School | Regular School | Yes | High | 09 | 12 | 2020 | pk_12_total | 5 | 1 | 117 | 0 | 0 | 0 | 0 | 52 | 71 | 123 | 5 | 1 | 117 | 0 | 0 | 0 | 0 | 52 | 71 | 123 | ||||||||||||||||||||||||||||||||||
1812550 | 1812550 | CO | school | 800020 | 8001 | Charter School Institute | 80002006579 | 9040 | Victory Preparatory Academy Middle State Charter School | Regular School | Yes | Middle | 06 | 08 | 2020 | pk_12_total | 10 | 3 | 188 | 0 | 0 | 0 | 3 | 95 | 109 | 204 | 10 | 3 | 188 | 0 | 0 | 0 | 3 | 95 | 109 | 204 | ||||||||||||||||||||||||||||||||||
1812564 | 1812564 | CO | school | 800023 | 9000 | Colorado School for the Deaf and Blind | 80002306410 | 1924 | Colorado School for the Deaf and Blind | Special Education School | No | Other | PK | 12 | 2020 | pk_12_total | 74 | 12 | 84 | 0 | 14 | 0 | 5 | 105 | 84 | 189 | 74 | 12 | 84 | 0 | 14 | 0 | 5 | 105 | 84 | 189 | ||||||||||||||||||||||||||||||||||
1812600 | 1812600 | CO | school | 800282 | 9170 | Education reEnvisioned BOCES | 80028206752 | 1448 | Colorado Preparatory Academy Elementary School | Regular School | No | Elementary | KG | 05 | 2020 | pk_12_total | 357 | 61 | 233 | 8 | 9 | 4 | 42 | 377 | 337 | 714 | 357 | 61 | 233 | 8 | 9 | 4 | 42 | 377 | 337 | 714 | ||||||||||||||||||||||||||||||||||
1812604 | 1812604 | CO | school | 800282 | 9170 | Education reEnvisioned BOCES | 80028206764 | 1501 | Colorado Preparatory Academy Middle School | Regular School | No | Middle | 06 | 08 | 2020 | pk_12_total | 392 | 32 | 215 | 8 | 6 | 2 | 30 | 309 | 376 | 685 | 392 | 32 | 215 | 8 | 6 | 2 | 30 | 309 | 376 | 685 | ||||||||||||||||||||||||||||||||||
1812609 | 1812609 | CO | school | 800282 | 9170 | Education reEnvisioned BOCES | 80028206600 | 1550 | Colorado Preparatory Academy High School | Regular School | No | High | 09 | 12 | 2020 | pk_12_total | 381 | 43 | 201 | 7 | 9 | 2 | 16 | 266 | 393 | 659 | 381 | 43 | 201 | 7 | 9 | 2 | 16 | 266 | 393 | 659 | ||||||||||||||||||||||||||||||||||
1812614 | 1812614 | CO | school | 800282 | 9170 | Education reEnvisioned BOCES | 80028206664 | 6971 | Pikes Peak Online School | Alternative School | No | High | 09 | 12 | 2020 | pk_12_total | 442 | 49 | 248 | 7 | 9 | 1 | 22 | 399 | 379 | 778 | 442 | 49 | 248 | 7 | 9 | 1 | 22 | 399 | 379 | 778 | ||||||||||||||||||||||||||||||||||
1812619 | 1812619 | CO | school | 800292 | 9175 | Colorado River BOCES | 80029201503 | 6134 | Yampah Mountain School | Alternative School | No | High | 06 | 12 | 2020 | pk_12_total | 80 | 1 | 81 | 4 | 0 | 1 | 1 | 81 | 87 | 168 | 80 | 1 | 81 | 4 | 0 | 1 | 1 | 81 | 87 | 168 | ||||||||||||||||||||||||||||||||||
1806073 | 1806073 | CO | school | 801920 | 1040 | Academy 20 | 80192001643 | 17 | Academy Endeavour Elementary School | Regular School | No | Elementary | KG | 05 | 2020 | pk_12_total | 301 | 8 | 58 | 1 | 10 | 0 | 37 | 199 | 216 | 415 | 301 | 8 | 58 | 1 | 10 | 0 | 37 | 199 | 216 | 415 | ||||||||||||||||||||||||||||||||||
1806081 | 1806081 | CO | school | 801920 | 1040 | Academy 20 | 80192001644 | 19 | Academy International Elementary School | Regular School | No | Elementary | PK | 05 | 2020 | pk_12_total | 315 | 17 | 60 | 3 | 67 | 5 | 54 | 250 | 271 | 521 | 315 | 17 | 60 | 3 | 67 | 5 | 54 | 250 | 271 | 521 | ||||||||||||||||||||||||||||||||||
1806085 | 1806085 | CO | school | 801920 | 1040 | Academy 20 | 80192000001 | 74 | Challenger Middle School | Regular School | No | Middle | 06 | 08 | 2020 | pk_12_total | 501 | 18 | 84 | 3 | 55 | 2 | 57 | 378 | 342 | 720 | 501 | 18 | 84 | 3 | 55 | 2 | 57 | 378 | 342 | 720 | ||||||||||||||||||||||||||||||||||
1806090 | 1806090 | CO | school | 801920 | 1040 | Academy 20 | 80192000002 | 76 | Air Academy High School | Regular School | No | High | 09 | 12 | 2020 | pk_12_total | 1005 | 46 | 190 | 4 | 56 | 1 | 101 | 715 | 688 | 1403 | 1005 | 46 | 190 | 4 | 56 | 1 | 101 | 715 | 688 | 1403 | ||||||||||||||||||||||||||||||||||
1806095 | 1806095 | CO | school | 801920 | 1040 | Academy 20 | 80192006434 | 110 | Village High School | Regular School | No | High | 09 | 12 | 2020 | pk_12_total | 179 | 4 | 22 | 0 | 2 | 0 | 7 | 113 | 101 | 214 | 179 | 4 | 22 | 0 | 2 | 0 | 7 | 113 | 101 | 214 | ||||||||||||||||||||||||||||||||||
1806102 | 1806102 | CO | school | 801920 | 1040 | Academy 20 | 80192000858 | 209 | Aspen Valley Campus | Alternative School | No | High | 07 | 12 | 2020 | pk_12_total | 114 | 6 | 30 | 2 | 2 | 0 | 5 | 97 | 62 | 159 | 114 | 6 | 30 | 2 | 2 | 0 | 5 | 97 | 62 | 159 | ||||||||||||||||||||||||||||||||||
1806109 | 1806109 | CO | school | 801920 | 1040 | Academy 20 | 80192000123 | 249 | Antelope Trails Elementary School | Regular School | No | Elementary | PK | 05 | 2020 | pk_12_total | 255 | 11 | 36 | 3 | 14 | 0 | 18 | 177 | 160 | 337 | 255 | 11 | 36 | 3 | 14 | 0 | 18 | 177 | 160 | 337 | ||||||||||||||||||||||||||||||||||
1806111 | 1806111 | CO | school | 801920 | 1040 | Academy 20 | 80192006619 | 1033 | Briargate Preschool | Regular School | No | Prekindergarten | PK | PK | 2020 | pk_12_total | 73 | 2 | 21 | 1 | 9 | 1 | 9 | 57 | 59 | 116 | 73 | 2 | 21 | 1 | 9 | 1 | 9 | 57 | 59 | 116 | ||||||||||||||||||||||||||||||||||
1806116 | 1806116 | CO | school | 801920 | 1040 | Academy 20 | 80192006788 | 1421 | Chinook Trail Middle School | Regular School | No | Middle | 06 | 08 | 2020 | pk_12_total | 351 | 14 | 67 | 2 | 40 | 0 | 53 | 262 | 265 | 527 | 351 | 14 | 67 | 2 | 40 | 0 | 53 | 262 | 265 | 527 | ||||||||||||||||||||||||||||||||||
1806130 | 1806130 | CO | school | 801920 | 1040 | Academy 20 | 80192006775 | 1511 | Home School Academy | Regular School | No | Other | KG | 12 | 2020 | pk_12_total | 424 | 4 | 64 | 3 | 7 | 0 | 29 | 265 | 266 | 531 | 424 | 4 | 64 | 3 | 7 | 0 | 29 | 265 | 266 | 531 | ||||||||||||||||||||||||||||||||||
1806138 | 1806138 | CO | school | 801920 | 1040 | Academy 20 | 80192006329 | 1615 | Chinook Trail Elementary School | Regular School | No | Elementary | KG | 05 | 2020 | pk_12_total | 460 | 15 | 67 | 2 | 39 | 1 | 50 | 291 | 343 | 634 | 460 | 15 | 67 | 2 | 39 | 1 | 50 | 291 | 343 | 634 | ||||||||||||||||||||||||||||||||||
1806146 | 1806146 | CO | school | 801920 | 1040 | Academy 20 | 80192001592 | 1627 | The Classical Academy Charter | Regular School | Yes | Elementary | KG | 06 | 2020 | pk_12_total | 1754 | 30 | 197 | 7 | 79 | 2 | 127 | 1124 | 1072 | 2196 | 1754 | 30 | 197 | 7 | 79 | 2 | 127 | 1124 | 1072 | 2196 | ||||||||||||||||||||||||||||||||||
1806149 | 1806149 | CO | school | 801920 | 1040 | Academy 20 | 80192001931 | 1629 | The Classical Academy Middle School | Regular School | Yes | Middle | 07 | 08 | 2020 | pk_12_total | 360 | 7 | 39 | 2 | 15 | 1 | 9 | 223 | 210 | 433 | 360 | 7 | 39 | 2 | 15 | 1 | 9 | 223 | 210 | 433 | ||||||||||||||||||||||||||||||||||
1806154 | 1806154 | CO | school | 801920 | 1040 | Academy 20 | 80192001943 | 1630 | The Classical Academy High School | Regular School | Yes | High | 09 | 12 | 2020 | pk_12_total | 496 | 8 | 46 | 1 | 19 | 3 | 23 | 306 | 290 | 596 | 496 | 8 | 46 | 1 | 19 | 3 | 23 | 306 | 290 | 596 | ||||||||||||||||||||||||||||||||||
1806164 | 1806164 | CO | school | 801920 | 1040 | Academy 20 | 80192006478 | 1901 | Journey K8 | Regular School | No | Elementary | KG | 08 | 2020 | pk_12_total | 92 | 3 | 31 | 0 | 4 | 0 | 7 | 56 | 81 | 137 | 92 | 3 | 31 | 0 | 4 | 0 | 7 | 56 | 81 | 137 | ||||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||
1806268 | 1806268 | CO | school | 801920 | 1040 | Academy 20 | 80192006758 | 6247 | Legacy Peak Elementary School | Regular School | No | Elementary | PK | 05 | 2020 | pk_12_total | 401 | 17 | 75 | 2 | 23 | 2 | 38 | 280 | 278 | 558 | 401 | 17 | 75 | 2 | 23 | 2 | 38 | 280 | 278 | 558 | ||||||||||||||||||||||||||||||||||
1806274 | 1806274 | CO | school | 801920 | 1040 | Academy 20 | 80192001645 | 6937 | Pine Creek High School | Regular School | No | High | 09 | 12 | 2020 | pk_12_total | 1143 | 43 | 218 | 8 | 85 | 8 | 126 | 860 | 771 | 1631 | 1143 | 43 | 218 | 8 | 85 | 8 | 126 | 860 | 771 | 1631 | ||||||||||||||||||||||||||||||||||
1806282 | 1806282 | CO | school | 801920 | 1040 | Academy 20 | 80192001430 | 6960 | Pioneer Elementary School | Regular School | No | Elementary | KG | 05 | 2020 | pk_12_total | 239 | 22 | 101 | 1 | 11 | 0 | 33 | 195 | 212 | 407 | 239 | 22 | 101 | 1 | 11 | 0 | 33 | 195 | 212 | 407 | ||||||||||||||||||||||||||||||||||
1806289 | 1806289 | CO | school | 801920 | 1040 | Academy 20 | 80192000531 | 7159 | Prairie Hills Elementary School | Regular School | No | Elementary | KG | 05 | 2020 | pk_12_total | 269 | 10 | 76 | 4 | 6 | 1 | 39 | 226 | 179 | 405 | 269 | 10 | 76 | 4 | 6 | 1 | 39 | 226 | 179 | 405 | ||||||||||||||||||||||||||||||||||
1806294 | 1806294 | CO | school | 801920 | 1040 | Academy 20 | 80192001321 | 7240 | Rampart High School | Regular School | No | High | 09 | 12 | 2020 | pk_12_total | 1026 | 67 | 295 | 6 | 100 | 10 | 121 | 808 | 817 | 1625 | 1026 | 67 | 295 | 6 | 100 | 10 | 121 | 808 | 817 | 1625 | ||||||||||||||||||||||||||||||||||
1806301 | 1806301 | CO | school | 801920 | 1040 | Academy 20 | 80192006336 | 7247 | Ranch Creek Elementary | Regular School | No | Elementary | PK | 05 | 2020 | pk_12_total | 369 | 20 | 100 | 1 | 16 | 3 | 50 | 270 | 289 | 559 | 369 | 20 | 100 | 1 | 16 | 3 | 50 | 270 | 289 | 559 | ||||||||||||||||||||||||||||||||||
1806310 | 1806310 | CO | school | 801920 | 1040 | Academy 20 | 80192000007 | 7460 | Rockrimmon Elementary School | Regular School | No | Elementary | KG | 05 | 2020 | pk_12_total | 267 | 8 | 57 | 0 | 3 | 1 | 20 | 175 | 181 | 356 | 267 | 8 | 57 | 0 | 3 | 1 | 20 | 175 | 181 | 356 | ||||||||||||||||||||||||||||||||||
1806317 | 1806317 | CO | school | 801920 | 1040 | Academy 20 | 80192006447 | 8779 | TCA College Pathways | Regular School | Yes | High | 07 | 12 | 2020 | pk_12_total | 401 | 13 | 47 | 1 | 22 | 3 | 35 | 223 | 299 | 522 | 401 | 13 | 47 | 1 | 22 | 3 | 35 | 223 | 299 | 522 | ||||||||||||||||||||||||||||||||||
1806325 | 1806325 | CO | school | 801920 | 1040 | Academy 20 | 80192001842 | 8813 | The Da Vinci Academy School | Regular School | No | Elementary | PK | 05 | 2020 | pk_12_total | 273 | 12 | 67 | 5 | 59 | 1 | 45 | 229 | 233 | 462 | 273 | 12 | 67 | 5 | 59 | 1 | 45 | 229 | 233 | 462 | ||||||||||||||||||||||||||||||||||
1806330 | 1806330 | CO | school | 801920 | 1040 | Academy 20 | 80192001462 | 8851 | Timberview Middle School | Regular School | No | Middle | 06 | 08 | 2020 | pk_12_total | 766 | 32 | 160 | 10 | 13 | 3 | 78 | 545 | 517 | 1062 | 766 | 32 | 160 | 10 | 13 | 3 | 78 | 545 | 517 | 1062 | ||||||||||||||||||||||||||||||||||
1806338 | 1806338 | CO | school | 801920 | 1040 | Academy 20 | 80192000008 | 9714 | Woodmen-Roberts Elementary School | Regular School | No | Elementary | PK | 05 | 2020 | pk_12_total | 355 | 15 | 62 | 4 | 11 | 0 | 32 | 248 | 231 | 479 | 355 | 15 | 62 | 4 | 11 | 0 | 32 | 248 | 231 | 479 |
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]);