enrollments
Data source: Big Local News · About: Big Local
1,920 rows where grade = "pk_12_total", state = "CO" and year = 2021 sorted by native_hawaiian_pacific_islander_int
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1738261 | 1738261 | CO | school | 10 | Mapleton 1 | 0 | Not a school | 2021 | pk_12_total | 3 | 0 | 3 | 0 | 0 | 0 | 0 | 5 | 1 | 6 | 3 | 0 | 3 | 0 | 0 | 0 | 0 | 5 | 1 | 6 | |||||||||||||||||||||||||||||||||||||||||
1738273 | 1738273 | CO | school | 805550 | 10 | Mapleton 1 | 80555001858 | 212 | Mapleton Early College High School | Regular School | No | High | 09 | 12 | 2021 | pk_12_total | 34 | 2 | 217 | 3 | 10 | 0 | 4 | 117 | 153 | 270 | 34 | 2 | 217 | 3 | 10 | 0 | 4 | 117 | 153 | 270 | ||||||||||||||||||||||||||||||||||
1738278 | 1738278 | CO | school | 805550 | 10 | Mapleton 1 | 80555001860 | 263 | Global Leadership Academy | Regular School | No | High | 09 | 12 | 2021 | pk_12_total | 15 | 4 | 248 | 0 | 1 | 0 | 1 | 137 | 132 | 269 | 15 | 4 | 248 | 0 | 1 | 0 | 1 | 137 | 132 | 269 | ||||||||||||||||||||||||||||||||||
1738293 | 1738293 | CO | school | 805550 | 10 | Mapleton 1 | 80555002031 | 502 | Meadow Community School | Regular School | No | Elementary | PK | 08 | 2021 | pk_12_total | 63 | 8 | 305 | 1 | 18 | 0 | 11 | 211 | 195 | 406 | 63 | 8 | 305 | 1 | 18 | 0 | 11 | 211 | 195 | 406 | ||||||||||||||||||||||||||||||||||
1738307 | 1738307 | CO | school | 805550 | 10 | Mapleton 1 | 80555002017 | 503 | York International | Regular School | No | Other | KG | 12 | 2021 | pk_12_total | 88 | 11 | 818 | 2 | 35 | 0 | 18 | 498 | 474 | 972 | 88 | 11 | 818 | 2 | 35 | 0 | 18 | 498 | 474 | 972 | ||||||||||||||||||||||||||||||||||
1738315 | 1738315 | CO | school | 805550 | 10 | Mapleton 1 | 80555001997 | 504 | Welby Community School | Regular School | No | Elementary | PK | 06 | 2021 | pk_12_total | 60 | 0 | 301 | 1 | 6 | 0 | 3 | 173 | 198 | 371 | 60 | 0 | 301 | 1 | 6 | 0 | 3 | 173 | 198 | 371 | ||||||||||||||||||||||||||||||||||
1738326 | 1738326 | CO | school | 805550 | 10 | Mapleton 1 | 80555002004 | 505 | Achieve Academy | Regular School | No | Elementary | PK | 08 | 2021 | pk_12_total | 41 | 6 | 349 | 0 | 8 | 0 | 16 | 207 | 213 | 420 | 41 | 6 | 349 | 0 | 8 | 0 | 16 | 207 | 213 | 420 | ||||||||||||||||||||||||||||||||||
1738360 | 1738360 | CO | school | 805550 | 10 | Mapleton 1 | 80555006671 | 695 | Big Picture College and Career Academy | Regular School | No | High | 09 | 12 | 2021 | pk_12_total | 26 | 0 | 78 | 1 | 0 | 0 | 8 | 59 | 54 | 113 | 26 | 0 | 78 | 1 | 0 | 0 | 8 | 59 | 54 | 113 | ||||||||||||||||||||||||||||||||||
1738375 | 1738375 | CO | school | 805550 | 10 | Mapleton 1 | 80555006808 | 2768 | Preschool on Poze | Regular School | No | Prekindergarten | PK | PK | 2021 | pk_12_total | 14 | 1 | 113 | 0 | 8 | 0 | 5 | 77 | 64 | 141 | 14 | 1 | 113 | 0 | 8 | 0 | 5 | 77 | 64 | 141 | ||||||||||||||||||||||||||||||||||
1738382 | 1738382 | CO | school | 805550 | 10 | Mapleton 1 | 80555006672 | 3590 | Global Intermediate Academy | Regular School | No | Middle | 04 | 08 | 2021 | pk_12_total | 13 | 3 | 268 | 2 | 1 | 0 | 5 | 145 | 147 | 292 | 13 | 3 | 268 | 2 | 1 | 0 | 5 | 145 | 147 | 292 | ||||||||||||||||||||||||||||||||||
1738387 | 1738387 | CO | school | 805550 | 10 | Mapleton 1 | 80555006673 | 3623 | Global Primary Academy | Regular School | No | Elementary | PK | 03 | 2021 | pk_12_total | 28 | 3 | 225 | 0 | 4 | 0 | 9 | 139 | 130 | 269 | 28 | 3 | 225 | 0 | 4 | 0 | 9 | 139 | 130 | 269 | ||||||||||||||||||||||||||||||||||
1738390 | 1738390 | CO | school | 805550 | 10 | Mapleton 1 | 80555006433 | 6315 | North Valley School for Young Adults | Alternative School | No | High | 09 | 12 | 2021 | pk_12_total | 15 | 1 | 58 | 1 | 0 | 0 | 2 | 42 | 35 | 77 | 15 | 1 | 58 | 1 | 0 | 0 | 2 | 42 | 35 | 77 | ||||||||||||||||||||||||||||||||||
1738400 | 1738400 | CO | school | 805550 | 10 | Mapleton 1 | 80555006786 | 8823 | Trailside Academy | Regular School | No | Elementary | PK | 08 | 2021 | pk_12_total | 95 | 1 | 392 | 2 | 5 | 0 | 10 | 240 | 265 | 505 | 95 | 1 | 392 | 2 | 5 | 0 | 10 | 240 | 265 | 505 | ||||||||||||||||||||||||||||||||||
1738408 | 1738408 | CO | school | 806900 | 20 | Adams 12 Five Star Schools | 80690001709 | 14 | Glacier Peak Elementary School | Regular School | No | Elementary | KG | 05 | 2021 | pk_12_total | 185 | 8 | 162 | 0 | 22 | 0 | 16 | 209 | 184 | 393 | 185 | 8 | 162 | 0 | 22 | 0 | 16 | 209 | 184 | 393 | ||||||||||||||||||||||||||||||||||
1738420 | 1738420 | CO | school | 806900 | 20 | Adams 12 Five Star Schools | 80690006435 | 70 | Adams12 Five Star Preschool | Regular School | No | Prekindergarten | PK | PK | 2021 | pk_12_total | 22 | 0 | 24 | 0 | 3 | 0 | 1 | 22 | 28 | 50 | 22 | 0 | 24 | 0 | 3 | 0 | 1 | 22 | 28 | 50 | ||||||||||||||||||||||||||||||||||
1738443 | 1738443 | CO | school | 806900 | 20 | Adams 12 Five Star Schools | 80690001173 | 1388 | Centennial Elementary School | Regular School | No | Elementary | PK | 05 | 2021 | pk_12_total | 141 | 2 | 246 | 1 | 7 | 0 | 9 | 199 | 207 | 406 | 141 | 2 | 246 | 1 | 7 | 0 | 9 | 199 | 207 | 406 | ||||||||||||||||||||||||||||||||||
1738448 | 1738448 | CO | school | 806900 | 20 | Adams 12 Five Star Schools | 80690001620 | 1480 | Century Middle School | Regular School | No | Middle | 06 | 08 | 2021 | pk_12_total | 492 | 21 | 339 | 4 | 39 | 0 | 46 | 483 | 458 | 941 | 492 | 21 | 339 | 4 | 39 | 0 | 46 | 483 | 458 | 941 | ||||||||||||||||||||||||||||||||||
1738462 | 1738462 | CO | school | 806900 | 20 | Adams 12 Five Star Schools | 80690000728 | 1519 | Stargate Charter School | Regular School | Yes | Other | KG | 12 | 2021 | pk_12_total | 859 | 10 | 160 | 2 | 336 | 0 | 119 | 734 | 752 | 1486 | 859 | 10 | 160 | 2 | 336 | 0 | 119 | 734 | 752 | 1486 | ||||||||||||||||||||||||||||||||||
1738469 | 1738469 | CO | school | 806900 | 20 | Adams 12 Five Star Schools | 80690001174 | 1878 | Coronado Hills Elementary School | Regular School | No | Elementary | PK | 05 | 2021 | pk_12_total | 77 | 8 | 408 | 3 | 9 | 0 | 8 | 266 | 247 | 513 | 77 | 8 | 408 | 3 | 9 | 0 | 8 | 266 | 247 | 513 | ||||||||||||||||||||||||||||||||||
1738477 | 1738477 | CO | school | 806900 | 20 | Adams 12 Five Star Schools | 80690001305 | 1914 | Cotton Creek Elementary School | Regular School | No | Elementary | KG | 05 | 2021 | pk_12_total | 326 | 6 | 103 | 3 | 26 | 0 | 41 | 254 | 251 | 505 | 326 | 6 | 103 | 3 | 26 | 0 | 41 | 254 | 251 | 505 | ||||||||||||||||||||||||||||||||||
1738506 | 1738506 | CO | school | 806900 | 20 | Adams 12 Five Star Schools | 80690001290 | 2576 | Cherry Drive Elementary School | Regular School | No | Elementary | PK | 05 | 2021 | pk_12_total | 158 | 2 | 155 | 0 | 11 | 0 | 11 | 182 | 155 | 337 | 158 | 2 | 155 | 0 | 11 | 0 | 11 | 182 | 155 | 337 | ||||||||||||||||||||||||||||||||||
1738514 | 1738514 | CO | school | 806900 | 20 | Adams 12 Five Star Schools | 80690001401 | 2578 | Skyview Elementary School | Regular School | No | Elementary | KG | 05 | 2021 | pk_12_total | 172 | 5 | 180 | 2 | 16 | 0 | 17 | 208 | 184 | 392 | 172 | 5 | 180 | 2 | 16 | 0 | 17 | 208 | 184 | 392 | ||||||||||||||||||||||||||||||||||
1738529 | 1738529 | CO | school | 806900 | 20 | Adams 12 Five Star Schools | 80690001460 | 2582 | Rocky Mountain Elementary School | Regular School | No | Elementary | KG | 05 | 2021 | pk_12_total | 67 | 8 | 226 | 1 | 6 | 0 | 11 | 164 | 155 | 319 | 67 | 8 | 226 | 1 | 6 | 0 | 11 | 164 | 155 | 319 | ||||||||||||||||||||||||||||||||||
1738536 | 1738536 | CO | school | 806900 | 20 | Adams 12 Five Star Schools | 80690001461 | 2584 | Riverdale Elementary School | Regular School | No | Elementary | PK | 05 | 2021 | pk_12_total | 178 | 1 | 204 | 0 | 13 | 0 | 20 | 221 | 195 | 416 | 178 | 1 | 204 | 0 | 13 | 0 | 20 | 221 | 195 | 416 | ||||||||||||||||||||||||||||||||||
1738544 | 1738544 | CO | school | 806900 | 20 | Adams 12 Five Star Schools | 80690001176 | 2918 | Federal Heights Elementary School | Regular School | No | Elementary | PK | 05 | 2021 | pk_12_total | 29 | 2 | 419 | 0 | 1 | 0 | 3 | 228 | 226 | 454 | 29 | 2 | 419 | 0 | 1 | 0 | 3 | 228 | 226 | 454 | ||||||||||||||||||||||||||||||||||
1738552 | 1738552 | CO | school | 806900 | 20 | Adams 12 Five Star Schools | 80690001177 | 4000 | Hillcrest Elementary School | Regular School | No | Elementary | KG | 05 | 2021 | pk_12_total | 64 | 14 | 293 | 1 | 23 | 0 | 15 | 209 | 201 | 410 | 64 | 14 | 293 | 1 | 23 | 0 | 15 | 209 | 201 | 410 | ||||||||||||||||||||||||||||||||||
1738567 | 1738567 | CO | school | 806900 | 20 | Adams 12 Five Star Schools | 80690001178 | 4172 | Hulstrom Options K-8 School | Regular School | No | Elementary | KG | 08 | 2021 | pk_12_total | 382 | 14 | 98 | 3 | 91 | 0 | 65 | 308 | 345 | 653 | 382 | 14 | 98 | 3 | 91 | 0 | 65 | 308 | 345 | 653 | ||||||||||||||||||||||||||||||||||
1738571 | 1738571 | CO | school | 806900 | 20 | Adams 12 Five Star Schools | 80690001179 | 4187 | Silver Hills Middle School | Regular School | No | Middle | 06 | 08 | 2021 | pk_12_total | 339 | 19 | 601 | 8 | 45 | 0 | 36 | 544 | 504 | 1048 | 339 | 19 | 601 | 8 | 45 | 0 | 36 | 544 | 504 | 1048 | ||||||||||||||||||||||||||||||||||
1738576 | 1738576 | CO | school | 806900 | 20 | Adams 12 Five Star Schools | 80690006480 | 4699 | New America School - Thornton | Alternative School | Yes | High | 09 | 12 | 2021 | pk_12_total | 12 | 4 | 243 | 0 | 0 | 0 | 1 | 131 | 129 | 260 | 12 | 4 | 243 | 0 | 0 | 0 | 1 | 131 | 129 | 260 | ||||||||||||||||||||||||||||||||||
1738595 | 1738595 | CO | school | 806900 | 20 | Adams 12 Five Star Schools | 80690001181 | 5418 | Malley Drive Elementary School | Regular School | No | Elementary | PK | 05 | 2021 | pk_12_total | 138 | 9 | 263 | 1 | 8 | 0 | 17 | 231 | 205 | 436 | 138 | 9 | 263 | 1 | 8 | 0 | 17 | 231 | 205 | 436 | ||||||||||||||||||||||||||||||||||
1738624 | 1738624 | CO | school | 806900 | 20 | Adams 12 Five Star Schools | 80690001362 | 6150 | Mountain View Elementary School | Regular School | No | Elementary | PK | 05 | 2021 | pk_12_total | 343 | 4 | 141 | 1 | 29 | 0 | 37 | 301 | 254 | 555 | 343 | 4 | 141 | 1 | 29 | 0 | 37 | 301 | 254 | 555 | ||||||||||||||||||||||||||||||||||
1738629 | 1738629 | CO | school | 806900 | 20 | Adams 12 Five Star Schools | 80690001186 | 6342 | Shadow Ridge Middle School | Regular School | No | Middle | 06 | 08 | 2021 | pk_12_total | 353 | 7 | 382 | 2 | 37 | 0 | 34 | 445 | 370 | 815 | 353 | 7 | 382 | 2 | 37 | 0 | 34 | 445 | 370 | 815 | ||||||||||||||||||||||||||||||||||
1738649 | 1738649 | CO | school | 806900 | 20 | Adams 12 Five Star Schools | 80690001187 | 6398 | Northglenn Middle School | Regular School | No | Middle | 06 | 08 | 2021 | pk_12_total | 154 | 14 | 629 | 5 | 18 | 0 | 18 | 469 | 369 | 838 | 154 | 14 | 629 | 5 | 18 | 0 | 18 | 469 | 369 | 838 | ||||||||||||||||||||||||||||||||||
1738676 | 1738676 | CO | school | 806900 | 20 | Adams 12 Five Star Schools | 80690006550 | 6956 | Pathways Future Center | Alternative School | No | Other | KG | 12 | 2021 | pk_12_total | 133 | 6 | 231 | 5 | 7 | 0 | 10 | 242 | 150 | 392 | 133 | 6 | 231 | 5 | 7 | 0 | 10 | 242 | 150 | 392 | ||||||||||||||||||||||||||||||||||
1738690 | 1738690 | CO | school | 806900 | 20 | Adams 12 Five Star Schools | 80690002028 | 7795 | Silver Creek Elementary | Regular School | No | Elementary | KG | 05 | 2021 | pk_12_total | 360 | 6 | 128 | 0 | 39 | 0 | 28 | 306 | 255 | 561 | 360 | 6 | 128 | 0 | 39 | 0 | 28 | 306 | 255 | 561 | ||||||||||||||||||||||||||||||||||
1738704 | 1738704 | CO | school | 806900 | 20 | Adams 12 Five Star Schools | 80690006303 | 8225 | Stellar Elementary School | Regular School | No | Elementary | KG | 05 | 2021 | pk_12_total | 167 | 12 | 233 | 2 | 25 | 0 | 26 | 225 | 240 | 465 | 167 | 12 | 233 | 2 | 25 | 0 | 26 | 225 | 240 | 465 | ||||||||||||||||||||||||||||||||||
1738725 | 1738725 | CO | school | 806900 | 20 | Adams 12 Five Star Schools | 80690006561 | 8310 | STEM Launch | Regular School | No | Elementary | KG | 08 | 2021 | pk_12_total | 138 | 2 | 658 | 3 | 6 | 0 | 18 | 442 | 383 | 825 | 138 | 2 | 658 | 3 | 6 | 0 | 18 | 442 | 383 | 825 | ||||||||||||||||||||||||||||||||||
1738750 | 1738750 | CO | school | 806900 | 20 | Adams 12 Five Star Schools | 80690001191 | 8842 | Thornton Elementary School | Regular School | No | Elementary | PK | 05 | 2021 | pk_12_total | 61 | 13 | 253 | 0 | 5 | 0 | 7 | 183 | 156 | 339 | 61 | 13 | 253 | 0 | 5 | 0 | 7 | 183 | 156 | 339 | ||||||||||||||||||||||||||||||||||
1738765 | 1738765 | CO | school | 806900 | 20 | Adams 12 Five Star Schools | 80690006417 | 9431 | Westgate Charter | Regular School | Yes | Other | KG | 12 | 2021 | pk_12_total | 348 | 7 | 94 | 1 | 41 | 0 | 24 | 268 | 247 | 515 | 348 | 7 | 94 | 1 | 41 | 0 | 24 | 268 | 247 | 515 | ||||||||||||||||||||||||||||||||||
1738769 | 1738769 | CO | school | 806900 | 20 | Adams 12 Five Star Schools | 80690001194 | 9444 | Westlake Middle School | Regular School | No | Middle | 06 | 08 | 2021 | pk_12_total | 627 | 7 | 267 | 7 | 51 | 0 | 60 | 517 | 502 | 1019 | 627 | 7 | 267 | 7 | 51 | 0 | 60 | 517 | 502 | 1019 | ||||||||||||||||||||||||||||||||||
1738776 | 1738776 | CO | school | 806900 | 20 | Adams 12 Five Star Schools | 80690001195 | 9494 | Westview Elementary School | Regular School | No | Elementary | PK | 05 | 2021 | pk_12_total | 144 | 6 | 213 | 2 | 12 | 0 | 23 | 223 | 177 | 400 | 144 | 6 | 213 | 2 | 12 | 0 | 23 | 223 | 177 | 400 | ||||||||||||||||||||||||||||||||||
1738794 | 1738794 | CO | school | 801950 | 30 | Adams County 14 | 80195001307 | 22 | Lester R Arnold High School | Alternative School | No | High | 09 | 12 | 2021 | pk_12_total | 21 | 2 | 150 | 1 | 0 | 0 | 2 | 101 | 75 | 176 | 21 | 2 | 150 | 1 | 0 | 0 | 2 | 101 | 75 | 176 | ||||||||||||||||||||||||||||||||||
1738800 | 1738800 | CO | school | 801950 | 30 | Adams County 14 | 80195001947 | 124 | Stars Early Learning Center | Regular School | No | Prekindergarten | PK | PK | 2021 | pk_12_total | 8 | 2 | 59 | 1 | 2 | 0 | 0 | 37 | 35 | 72 | 8 | 2 | 59 | 1 | 2 | 0 | 0 | 37 | 35 | 72 | ||||||||||||||||||||||||||||||||||
1738822 | 1738822 | CO | school | 801950 | 30 | Adams County 14 | 80195000013 | 2308 | Dupont Elementary School | Regular School | No | Elementary | KG | 05 | 2021 | pk_12_total | 41 | 5 | 347 | 1 | 1 | 0 | 4 | 207 | 192 | 399 | 41 | 5 | 347 | 1 | 1 | 0 | 4 | 207 | 192 | 399 | ||||||||||||||||||||||||||||||||||
1738833 | 1738833 | CO | school | 801950 | 30 | Adams County 14 | 80195000016 | 4536 | Kemp Elementary School | Regular School | No | Elementary | PK | 05 | 2021 | pk_12_total | 43 | 4 | 423 | 0 | 0 | 0 | 3 | 246 | 227 | 473 | 43 | 4 | 423 | 0 | 0 | 0 | 3 | 246 | 227 | 473 | ||||||||||||||||||||||||||||||||||
1738835 | 1738835 | CO | school | 801950 | 30 | Adams County 14 | 80195000404 | 5880 | Mildred L Sanville Preschool | Regular School | No | Prekindergarten | PK | PK | 2021 | pk_12_total | 2 | 3 | 69 | 0 | 0 | 0 | 1 | 48 | 27 | 75 | 2 | 3 | 69 | 0 | 0 | 0 | 1 | 48 | 27 | 75 | ||||||||||||||||||||||||||||||||||
1738843 | 1738843 | CO | school | 801950 | 30 | Adams County 14 | 80195000017 | 5982 | Monaco Elementary School | Regular School | No | Elementary | KG | 05 | 2021 | pk_12_total | 39 | 3 | 246 | 0 | 0 | 0 | 2 | 152 | 138 | 290 | 39 | 3 | 246 | 0 | 0 | 0 | 2 | 152 | 138 | 290 | ||||||||||||||||||||||||||||||||||
1738850 | 1738850 | CO | school | 801950 | 30 | Adams County 14 | 80195000018 | 6534 | Hanson Elementary School | Regular School | No | Elementary | PK | 05 | 2021 | pk_12_total | 15 | 5 | 327 | 0 | 0 | 0 | 1 | 192 | 156 | 348 | 15 | 5 | 327 | 0 | 0 | 0 | 1 | 192 | 156 | 348 | ||||||||||||||||||||||||||||||||||
1738858 | 1738858 | CO | school | 801950 | 30 | Adams County 14 | 80195000019 | 7500 | Rose Hill Elementary School | Regular School | No | Elementary | PK | 05 | 2021 | pk_12_total | 37 | 11 | 293 | 0 | 1 | 0 | 5 | 191 | 156 | 347 | 37 | 11 | 293 | 0 | 1 | 0 | 5 | 191 | 156 | 347 | ||||||||||||||||||||||||||||||||||
1738869 | 1738869 | CO | school | 802580 | 40 | School District 27J | 80258001948 | 700 | Belle Creek Charter School | Regular School | Yes | Elementary | KG | 08 | 2021 | pk_12_total | 197 | 10 | 385 | 0 | 12 | 0 | 30 | 318 | 316 | 634 | 197 | 10 | 385 | 0 | 12 | 0 | 30 | 318 | 316 | 634 | ||||||||||||||||||||||||||||||||||
1738876 | 1738876 | CO | school | 802580 | 40 | School District 27J | 80258006549 | 1013 | Brantner Elementary School | Regular School | No | Elementary | PK | 05 | 2021 | pk_12_total | 404 | 7 | 188 | 2 | 43 | 0 | 26 | 331 | 339 | 670 | 404 | 7 | 188 | 2 | 43 | 0 | 26 | 331 | 339 | 670 | ||||||||||||||||||||||||||||||||||
1738882 | 1738882 | CO | school | 802580 | 40 | School District 27J | 80258000729 | 1021 | Innovations & Options | Alternative School | No | High | 06 | 12 | 2021 | pk_12_total | 73 | 2 | 142 | 2 | 0 | 0 | 6 | 131 | 94 | 225 | 73 | 2 | 142 | 2 | 0 | 0 | 6 | 131 | 94 | 225 | ||||||||||||||||||||||||||||||||||
1738945 | 1738945 | CO | school | 802580 | 40 | School District 27J | 80258000148 | 6294 | North Elementary School | Regular School | No | Elementary | PK | 05 | 2021 | pk_12_total | 32 | 1 | 157 | 2 | 1 | 0 | 2 | 111 | 84 | 195 | 32 | 1 | 157 | 2 | 1 | 0 | 2 | 111 | 84 | 195 | ||||||||||||||||||||||||||||||||||
1738970 | 1738970 | CO | school | 802580 | 40 | School District 27J | 80258006362 | 7131 | Prairie View Middle School | Regular School | No | Middle | 06 | 08 | 2021 | pk_12_total | 242 | 6 | 351 | 1 | 22 | 0 | 23 | 343 | 302 | 645 | 242 | 6 | 351 | 1 | 22 | 0 | 23 | 343 | 302 | 645 | ||||||||||||||||||||||||||||||||||
1738996 | 1738996 | CO | school | 802580 | 40 | School District 27J | 80258006377 | 7725 | SD 27J Preschool at the Brighton LRC | Regular School | No | Prekindergarten | PK | PK | 2021 | pk_12_total | 20 | 1 | 52 | 0 | 3 | 0 | 2 | 44 | 34 | 78 | 20 | 1 | 52 | 0 | 3 | 0 | 2 | 44 | 34 | 78 | ||||||||||||||||||||||||||||||||||
1739004 | 1739004 | CO | school | 802580 | 40 | School District 27J | 80258001822 | 8032 | John W Thimmig Elementary School | Regular School | No | Elementary | PK | 05 | 2021 | pk_12_total | 193 | 18 | 306 | 1 | 23 | 0 | 18 | 309 | 250 | 559 | 193 | 18 | 306 | 1 | 23 | 0 | 18 | 309 | 250 | 559 | ||||||||||||||||||||||||||||||||||
1739012 | 1739012 | CO | school | 802580 | 40 | School District 27J | 80258000150 | 8060 | South Elementary School | Regular School | No | Elementary | PK | 05 | 2021 | pk_12_total | 63 | 3 | 317 | 1 | 1 | 0 | 9 | 209 | 185 | 394 | 63 | 3 | 317 | 1 | 1 | 0 | 9 | 209 | 185 | 394 | ||||||||||||||||||||||||||||||||||
1739020 | 1739020 | CO | school | 802580 | 40 | School District 27J | 80258000151 | 8130 | Southeast Elementary School | Regular School | No | Elementary | PK | 05 | 2021 | pk_12_total | 162 | 5 | 313 | 1 | 6 | 0 | 11 | 261 | 237 | 498 | 162 | 5 | 313 | 1 | 6 | 0 | 11 | 261 | 237 | 498 | ||||||||||||||||||||||||||||||||||
1739033 | 1739033 | CO | school | 802580 | 40 | School District 27J | 80258000152 | 9230 | Vikan Middle School | Regular School | No | Middle | 06 | 08 | 2021 | pk_12_total | 205 | 6 | 422 | 1 | 2 | 0 | 13 | 371 | 278 | 649 | 205 | 6 | 422 | 1 | 2 | 0 | 13 | 371 | 278 | 649 | ||||||||||||||||||||||||||||||||||
1739045 | 1739045 | CO | school | 802430 | 50 | Bennett 29J | 80243006789 | 562 | Bennett Intermediate School | Regular School | No | Middle | 04 | 06 | 2021 | pk_12_total | 148 | 5 | 91 | 0 | 1 | 0 | 18 | 137 | 126 | 263 | 148 | 5 | 91 | 0 | 1 | 0 | 18 | 137 | 126 | 263 | ||||||||||||||||||||||||||||||||||
1739046 | 1739046 | CO | school | 802430 | 50 | Bennett 29J | 80243001751 | 763 | Bennett Preschool | Regular School | No | Prekindergarten | PK | PK | 2021 | pk_12_total | 29 | 0 | 13 | 0 | 0 | 0 | 1 | 21 | 22 | 43 | 29 | 0 | 13 | 0 | 0 | 0 | 1 | 21 | 22 | 43 | ||||||||||||||||||||||||||||||||||
1739055 | 1739055 | CO | school | 802430 | 50 | Bennett 29J | 80243000093 | 774 | Bennett Middle School | Regular School | No | Middle | 07 | 08 | 2021 | pk_12_total | 99 | 3 | 78 | 1 | 0 | 0 | 10 | 94 | 97 | 191 | 99 | 3 | 78 | 1 | 0 | 0 | 10 | 94 | 97 | 191 | ||||||||||||||||||||||||||||||||||
1739064 | 1739064 | CO | school | 806750 | 60 | Strasburg 31J | 80675001669 | 7133 | Prairie Creek High School | Alternative School | No | High | 09 | 12 | 2021 | pk_12_total | 9 | 0 | 3 | 0 | 0 | 0 | 1 | 9 | 4 | 13 | 9 | 0 | 3 | 0 | 0 | 0 | 1 | 9 | 4 | 13 | ||||||||||||||||||||||||||||||||||
1739081 | 1739081 | CO | school | 806750 | 60 | Strasburg 31J | 80675001161 | 8334 | Strasburg High School | Regular School | No | High | 09 | 12 | 2021 | pk_12_total | 220 | 1 | 80 | 3 | 2 | 0 | 8 | 176 | 138 | 314 | 220 | 1 | 80 | 3 | 2 | 0 | 8 | 176 | 138 | 314 | ||||||||||||||||||||||||||||||||||
1739082 | 1739082 | CO | school | 807230 | 70 | Westminster Public Schools | 80723006799 | 1137 | Early Learning Center at Francis M. Day | Regular School | No | Prekindergarten | PK | PK | 2021 | pk_12_total | 7 | 0 | 4 | 0 | 0 | 0 | 0 | 5 | 6 | 11 | 7 | 0 | 4 | 0 | 0 | 0 | 0 | 5 | 6 | 11 | ||||||||||||||||||||||||||||||||||
1739172 | 1739172 | CO | school | 807230 | 70 | Westminster Public Schools | 80723001244 | 7812 | Shaw Heights Middle School | Regular School | No | Middle | 06 | 08 | 2021 | pk_12_total | 77 | 21 | 359 | 6 | 23 | 0 | 18 | 264 | 240 | 504 | 77 | 21 | 359 | 6 | 23 | 0 | 18 | 264 | 240 | 504 | ||||||||||||||||||||||||||||||||||
1739225 | 1739225 | CO | school | 807230 | 70 | Westminster Public Schools | 80723006721 | 9734 | Early Learning Center at Perl Mack | Regular School | No | Prekindergarten | PK | PK | 2021 | pk_12_total | 19 | 0 | 9 | 0 | 0 | 0 | 3 | 21 | 10 | 31 | 19 | 0 | 9 | 0 | 0 | 0 | 3 | 21 | 10 | 31 | ||||||||||||||||||||||||||||||||||
1739264 | 1739264 | CO | school | 806420 | 110 | Sangre De Cristo Re-22J | 80642001115 | 7626 | Sangre de Cristo Elementary School | Regular School | No | Elementary | PK | 05 | 2021 | pk_12_total | 75 | 0 | 36 | 0 | 0 | 0 | 1 | 60 | 52 | 112 | 75 | 0 | 36 | 0 | 0 | 0 | 1 | 60 | 52 | 112 | ||||||||||||||||||||||||||||||||||
1739273 | 1739273 | CO | school | 806420 | 110 | Sangre De Cristo Re-22J | 80642001116 | 7630 | Sangre de Cristo Undivided High School | Regular School | No | High | 06 | 12 | 2021 | pk_12_total | 66 | 1 | 51 | 5 | 1 | 0 | 4 | 67 | 61 | 128 | 66 | 1 | 51 | 5 | 1 | 0 | 4 | 67 | 61 | 128 | ||||||||||||||||||||||||||||||||||
1739278 | 1739278 | CO | school | 803780 | 120 | Englewood 1 | 80378001310 | 206 | Colorado's Finest High School of Choice | Alternative School | No | High | 09 | 12 | 2021 | pk_12_total | 157 | 1 | 82 | 1 | 0 | 0 | 14 | 119 | 136 | 255 | 157 | 1 | 82 | 1 | 0 | 0 | 14 | 119 | 136 | 255 | ||||||||||||||||||||||||||||||||||
1739302 | 1739302 | CO | school | 803780 | 120 | Englewood 1 | 80378000489 | 1652 | Clayton Elementary School | Regular School | No | Elementary | KG | 06 | 2021 | pk_12_total | 167 | 13 | 174 | 1 | 2 | 0 | 26 | 200 | 183 | 383 | 167 | 13 | 174 | 1 | 2 | 0 | 26 | 200 | 183 | 383 | ||||||||||||||||||||||||||||||||||
1739314 | 1739314 | CO | school | 803780 | 120 | Englewood 1 | 80378006331 | 2752 | Englewood Middle School | Regular School | No | Middle | 07 | 08 | 2021 | pk_12_total | 113 | 12 | 111 | 2 | 1 | 0 | 12 | 133 | 118 | 251 | 113 | 12 | 111 | 2 | 1 | 0 | 12 | 133 | 118 | 251 | ||||||||||||||||||||||||||||||||||
1739324 | 1739324 | CO | school | 803780 | 120 | Englewood 1 | 80378000497 | 9620 | Wm E Bishop Elementary School | Regular School | No | Elementary | KG | 06 | 2021 | pk_12_total | 58 | 12 | 112 | 1 | 2 | 0 | 11 | 108 | 88 | 196 | 58 | 12 | 112 | 1 | 2 | 0 | 11 | 108 | 88 | 196 | ||||||||||||||||||||||||||||||||||
1739335 | 1739335 | CO | school | 806540 | 123 | Sheridan 2 | 80654001135 | 7837 | Fort Logan Northgate | Regular School | No | Middle | 03 | 08 | 2021 | pk_12_total | 65 | 21 | 394 | 5 | 9 | 0 | 17 | 249 | 262 | 511 | 65 | 21 | 394 | 5 | 9 | 0 | 17 | 249 | 262 | 511 | ||||||||||||||||||||||||||||||||||
1739341 | 1739341 | CO | school | 806540 | 123 | Sheridan 2 | 80654000032 | 7843 | Early Childhood Education Center | Regular School | No | Prekindergarten | PK | PK | 2021 | pk_12_total | 19 | 8 | 88 | 1 | 3 | 0 | 2 | 69 | 52 | 121 | 19 | 8 | 88 | 1 | 3 | 0 | 2 | 69 | 52 | 121 | ||||||||||||||||||||||||||||||||||
1739347 | 1739347 | CO | school | 806540 | 123 | Sheridan 2 | 80654006565 | 8123 | SOAR Academy | Alternative School | No | High | 06 | 12 | 2021 | pk_12_total | 20 | 1 | 60 | 2 | 0 | 0 | 4 | 42 | 45 | 87 | 20 | 1 | 60 | 2 | 0 | 0 | 4 | 42 | 45 | 87 | ||||||||||||||||||||||||||||||||||
1739354 | 1739354 | CO | school | 802910 | 130 | Cherry Creek 5 | 80291001710 | 16 | Fox Hollow Elementary School | Regular School | No | Elementary | PK | 05 | 2021 | pk_12_total | 331 | 37 | 92 | 1 | 75 | 0 | 47 | 301 | 282 | 583 | 331 | 37 | 92 | 1 | 75 | 0 | 47 | 301 | 282 | 583 | ||||||||||||||||||||||||||||||||||
1739375 | 1739375 | CO | school | 802910 | 130 | Cherry Creek 5 | 80291006770 | 188 | Colorado Skies Academy | Regular School | Yes | Middle | 06 | 08 | 2021 | pk_12_total | 174 | 6 | 35 | 1 | 6 | 0 | 14 | 174 | 62 | 236 | 174 | 6 | 35 | 1 | 6 | 0 | 14 | 174 | 62 | 236 | ||||||||||||||||||||||||||||||||||
1739389 | 1739389 | CO | school | 802910 | 130 | Cherry Creek 5 | 80291002032 | 243 | Coyote Hills Elementary School | Regular School | No | Elementary | PK | 05 | 2021 | pk_12_total | 346 | 31 | 92 | 1 | 44 | 0 | 50 | 294 | 270 | 564 | 346 | 31 | 92 | 1 | 44 | 0 | 50 | 294 | 270 | 564 | ||||||||||||||||||||||||||||||||||
1739412 | 1739412 | CO | school | 802910 | 130 | Cherry Creek 5 | 80291000184 | 714 | Belleview Elementary School | Regular School | No | Elementary | PK | 05 | 2021 | pk_12_total | 262 | 21 | 41 | 1 | 177 | 0 | 34 | 279 | 257 | 536 | 262 | 21 | 41 | 1 | 177 | 0 | 34 | 279 | 257 | 536 | ||||||||||||||||||||||||||||||||||
1739434 | 1739434 | CO | school | 802910 | 130 | Cherry Creek 5 | 80291006791 | 1429 | Cherry Creek Elevation | Regular School | No | High | 06 | 12 | 2021 | pk_12_total | 89 | 10 | 24 | 1 | 3 | 0 | 6 | 52 | 81 | 133 | 89 | 10 | 24 | 1 | 3 | 0 | 6 | 52 | 81 | 133 | ||||||||||||||||||||||||||||||||||
1739486 | 1739486 | CO | school | 802910 | 130 | Cherry Creek 5 | 80291000187 | 1574 | Cherry Hills Village Elementary School | Regular School | No | Elementary | PK | 05 | 2021 | pk_12_total | 415 | 4 | 33 | 4 | 20 | 0 | 37 | 258 | 255 | 513 | 415 | 4 | 33 | 4 | 20 | 0 | 37 | 258 | 255 | 513 | ||||||||||||||||||||||||||||||||||
1739493 | 1739493 | CO | school | 802910 | 130 | Cherry Creek 5 | 80291001297 | 1614 | Cimarron Elementary School | Regular School | No | Elementary | PK | 05 | 2021 | pk_12_total | 156 | 66 | 126 | 3 | 7 | 0 | 67 | 220 | 205 | 425 | 156 | 66 | 126 | 3 | 7 | 0 | 67 | 220 | 205 | 425 | ||||||||||||||||||||||||||||||||||
1739515 | 1739515 | CO | school | 802910 | 130 | Cherry Creek 5 | 80291001671 | 2094 | Dakota Valley Elementary School | Regular School | No | Elementary | PK | 05 | 2021 | pk_12_total | 282 | 42 | 98 | 2 | 42 | 0 | 49 | 243 | 272 | 515 | 282 | 42 | 98 | 2 | 42 | 0 | 49 | 243 | 272 | 515 | ||||||||||||||||||||||||||||||||||
1739588 | 1739588 | CO | school | 802910 | 130 | Cherry Creek 5 | 80291000195 | 4078 | Homestead Elementary School | Regular School | No | Elementary | PK | 05 | 2021 | pk_12_total | 288 | 6 | 47 | 3 | 34 | 0 | 26 | 200 | 204 | 404 | 288 | 6 | 47 | 3 | 34 | 0 | 26 | 200 | 204 | 404 | ||||||||||||||||||||||||||||||||||
1739618 | 1739618 | CO | school | 802910 | 130 | Cherry Creek 5 | 80291006769 | 4412 | The Journey Preschool | Regular School | No | Prekindergarten | PK | PK | 2021 | pk_12_total | 24 | 17 | 34 | 0 | 10 | 0 | 4 | 40 | 49 | 89 | 24 | 17 | 34 | 0 | 10 | 0 | 4 | 40 | 49 | 89 | ||||||||||||||||||||||||||||||||||
1739626 | 1739626 | CO | school | 802910 | 130 | Cherry Creek 5 | 80291006544 | 4448 | Black Forest Hills Elementary School | Regular School | No | Elementary | PK | 05 | 2021 | pk_12_total | 366 | 37 | 74 | 2 | 55 | 0 | 57 | 324 | 267 | 591 | 366 | 37 | 74 | 2 | 55 | 0 | 57 | 324 | 267 | 591 | ||||||||||||||||||||||||||||||||||
1739628 | 1739628 | CO | school | 802910 | 130 | Cherry Creek 5 | 80291006632 | 4896 | The Cottage at Holly Ridge | Regular School | No | Prekindergarten | PK | PK | 2021 | pk_12_total | 37 | 21 | 25 | 3 | 11 | 0 | 5 | 56 | 46 | 102 | 37 | 21 | 25 | 3 | 11 | 0 | 5 | 56 | 46 | 102 | ||||||||||||||||||||||||||||||||||
1739640 | 1739640 | CO | school | 802910 | 130 | Cherry Creek 5 | 80291001329 | 5744 | Meadow Point Elementary School | Regular School | No | Elementary | PK | 05 | 2021 | pk_12_total | 176 | 57 | 145 | 1 | 21 | 0 | 36 | 233 | 203 | 436 | 176 | 57 | 145 | 1 | 21 | 0 | 36 | 233 | 203 | 436 | ||||||||||||||||||||||||||||||||||
1739656 | 1739656 | CO | school | 802910 | 130 | Cherry Creek 5 | 80291006607 | 6225 | Mountain Vista Elementary School | Regular School | No | Elementary | PK | 05 | 2021 | pk_12_total | 356 | 119 | 103 | 4 | 65 | 0 | 63 | 392 | 318 | 710 | 356 | 119 | 103 | 4 | 65 | 0 | 63 | 392 | 318 | 710 | ||||||||||||||||||||||||||||||||||
1739672 | 1739672 | CO | school | 802910 | 130 | Cherry Creek 5 | 80291006617 | 6475 | Outback Preschool | Regular School | No | Prekindergarten | PK | PK | 2021 | pk_12_total | 28 | 8 | 12 | 0 | 4 | 0 | 6 | 29 | 29 | 58 | 28 | 8 | 12 | 0 | 4 | 0 | 6 | 29 | 29 | 58 | ||||||||||||||||||||||||||||||||||
1739700 | 1739700 | CO | school | 802910 | 130 | Cherry Creek 5 | 80291000199 | 7102 | Polton Community Elementary School | Regular School | No | Elementary | PK | 05 | 2021 | pk_12_total | 185 | 121 | 106 | 2 | 26 | 0 | 61 | 255 | 246 | 501 | 185 | 121 | 106 | 2 | 26 | 0 | 61 | 255 | 246 | 501 | ||||||||||||||||||||||||||||||||||
1739751 | 1739751 | CO | school | 802910 | 130 | Cherry Creek 5 | 80291001468 | 8380 | Summit Elementary School | Regular School | No | Elementary | PK | 05 | 2021 | pk_12_total | 144 | 39 | 105 | 3 | 16 | 0 | 29 | 184 | 152 | 336 | 144 | 39 | 105 | 3 | 16 | 0 | 29 | 184 | 152 | 336 | ||||||||||||||||||||||||||||||||||
1739779 | 1739779 | CO | school | 802910 | 130 | Cherry Creek 5 | 80291001330 | 8887 | Trails West Elementary School | Regular School | No | Elementary | PK | 05 | 2021 | pk_12_total | 274 | 19 | 85 | 1 | 22 | 0 | 54 | 246 | 209 | 455 | 274 | 19 | 85 | 1 | 22 | 0 | 54 | 246 | 209 | 455 | ||||||||||||||||||||||||||||||||||
1739787 | 1739787 | CO | school | 802910 | 130 | Cherry Creek 5 | 80291000204 | 9108 | Village East Community Elementary School | Regular School | No | Elementary | PK | 05 | 2021 | pk_12_total | 129 | 251 | 229 | 7 | 36 | 0 | 45 | 359 | 338 | 697 | 129 | 251 | 229 | 7 | 36 | 0 | 45 | 359 | 338 | 697 | ||||||||||||||||||||||||||||||||||
1739815 | 1739815 | CO | school | 805310 | 140 | Littleton 6 | 80531006800 | 1145 | Village at Highland | Regular School | No | Prekindergarten | PK | PK | 2021 | pk_12_total | 112 | 2 | 18 | 1 | 2 | 0 | 6 | 83 | 58 | 141 | 112 | 2 | 18 | 1 | 2 | 0 | 6 | 83 | 58 | 141 | ||||||||||||||||||||||||||||||||||
1739823 | 1739823 | CO | school | 805310 | 140 | Littleton 6 | 80531000874 | 1382 | Centennial Academy of Fine Arts Education | Regular School | No | Elementary | KG | 05 | 2021 | pk_12_total | 249 | 5 | 160 | 3 | 8 | 0 | 28 | 236 | 217 | 453 | 249 | 5 | 160 | 3 | 8 | 0 | 28 | 236 | 217 | 453 | ||||||||||||||||||||||||||||||||||
1739830 | 1739830 | CO | school | 805310 | 140 | Littleton 6 | 80531000875 | 2382 | East Elementary School | Regular School | No | Elementary | KG | 05 | 2021 | pk_12_total | 77 | 5 | 133 | 1 | 12 | 0 | 5 | 113 | 120 | 233 | 77 | 5 | 133 | 1 | 12 | 0 | 5 | 113 | 120 | 233 | ||||||||||||||||||||||||||||||||||
1739845 | 1739845 | CO | school | 805310 | 140 | Littleton 6 | 80531000879 | 3472 | Goddard Middle School | Regular School | No | Middle | 06 | 08 | 2021 | pk_12_total | 417 | 8 | 255 | 5 | 21 | 0 | 38 | 368 | 376 | 744 | 417 | 8 | 255 | 5 | 21 | 0 | 38 | 368 | 376 | 744 | ||||||||||||||||||||||||||||||||||
1739890 | 1739890 | CO | school | 805310 | 140 | Littleton 6 | 80531001626 | 5233 | Littleton Prep Charter School | Regular School | Yes | Elementary | PK | 08 | 2021 | pk_12_total | 398 | 5 | 113 | 1 | 18 | 0 | 32 | 279 | 288 | 567 | 398 | 5 | 113 | 1 | 18 | 0 | 32 | 279 | 288 | 567 |
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]);