enrollments
Data source: Big Local News · About: Big Local
1,920 rows where grade = "pk_12_total", state = "CO" and year = 2021 sorted by district
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1744984 | 1744984 | CO | school | 801920 | 1040 | Academy 20 | 80192001643 | 17 | Academy Endeavour Elementary School | Regular School | No | Elementary | KG | 05 | 2021 | pk_12_total | 278 | 9 | 53 | 1 | 13 | 0 | 29 | 181 | 202 | 383 | 278 | 9 | 53 | 1 | 13 | 0 | 29 | 181 | 202 | 383 | ||||||||||||||||||||||||||||||||||
1744991 | 1744991 | CO | school | 801920 | 1040 | Academy 20 | 80192001644 | 19 | Academy International Elementary School | Regular School | No | Elementary | PK | 05 | 2021 | pk_12_total | 270 | 14 | 52 | 0 | 62 | 2 | 50 | 214 | 236 | 450 | 270 | 14 | 52 | 0 | 62 | 2 | 50 | 214 | 236 | 450 | ||||||||||||||||||||||||||||||||||
1744995 | 1744995 | CO | school | 801920 | 1040 | Academy 20 | 80192000001 | 74 | Challenger Middle School | Regular School | No | Middle | 06 | 08 | 2021 | pk_12_total | 444 | 15 | 84 | 3 | 48 | 4 | 62 | 353 | 307 | 660 | 444 | 15 | 84 | 3 | 48 | 4 | 62 | 353 | 307 | 660 | ||||||||||||||||||||||||||||||||||
1745000 | 1745000 | CO | school | 801920 | 1040 | Academy 20 | 80192000002 | 76 | Air Academy High School | Regular School | No | High | 09 | 12 | 2021 | pk_12_total | 988 | 50 | 197 | 6 | 46 | 1 | 95 | 699 | 684 | 1383 | 988 | 50 | 197 | 6 | 46 | 1 | 95 | 699 | 684 | 1383 | ||||||||||||||||||||||||||||||||||
1745005 | 1745005 | CO | school | 801920 | 1040 | Academy 20 | 80192006434 | 110 | Village High School | Regular School | No | High | 09 | 12 | 2021 | pk_12_total | 252 | 10 | 28 | 0 | 7 | 0 | 13 | 155 | 155 | 310 | 252 | 10 | 28 | 0 | 7 | 0 | 13 | 155 | 155 | 310 | ||||||||||||||||||||||||||||||||||
1745012 | 1745012 | CO | school | 801920 | 1040 | Academy 20 | 80192000858 | 209 | Aspen Valley Campus | Alternative School | No | High | 07 | 12 | 2021 | pk_12_total | 95 | 3 | 24 | 0 | 1 | 0 | 8 | 84 | 47 | 131 | 95 | 3 | 24 | 0 | 1 | 0 | 8 | 84 | 47 | 131 | ||||||||||||||||||||||||||||||||||
1745019 | 1745019 | CO | school | 801920 | 1040 | Academy 20 | 80192000123 | 249 | Antelope Trails Elementary School | Regular School | No | Elementary | PK | 05 | 2021 | pk_12_total | 213 | 4 | 35 | 0 | 12 | 1 | 19 | 152 | 132 | 284 | 213 | 4 | 35 | 0 | 12 | 1 | 19 | 152 | 132 | 284 | ||||||||||||||||||||||||||||||||||
1745021 | 1745021 | CO | school | 801920 | 1040 | Academy 20 | 80192006619 | 1033 | Briargate Preschool | Regular School | No | Prekindergarten | PK | PK | 2021 | pk_12_total | 38 | 2 | 14 | 2 | 9 | 0 | 5 | 36 | 34 | 70 | 38 | 2 | 14 | 2 | 9 | 0 | 5 | 36 | 34 | 70 | ||||||||||||||||||||||||||||||||||
1745026 | 1745026 | CO | school | 801920 | 1040 | Academy 20 | 80192006788 | 1421 | Chinook Trail Middle School | Regular School | No | Middle | 06 | 08 | 2021 | pk_12_total | 507 | 24 | 102 | 2 | 49 | 2 | 64 | 370 | 380 | 750 | 507 | 24 | 102 | 2 | 49 | 2 | 64 | 370 | 380 | 750 | ||||||||||||||||||||||||||||||||||
1745040 | 1745040 | CO | school | 801920 | 1040 | Academy 20 | 80192006775 | 1511 | Home School Academy | Regular School | No | Other | KG | 12 | 2021 | pk_12_total | 373 | 6 | 59 | 1 | 4 | 0 | 27 | 215 | 255 | 470 | 373 | 6 | 59 | 1 | 4 | 0 | 27 | 215 | 255 | 470 | ||||||||||||||||||||||||||||||||||
1745047 | 1745047 | CO | school | 801920 | 1040 | Academy 20 | 80192006329 | 1615 | Chinook Trail Elementary School | Regular School | No | Elementary | KG | 05 | 2021 | pk_12_total | 446 | 14 | 75 | 2 | 51 | 1 | 48 | 313 | 324 | 637 | 446 | 14 | 75 | 2 | 51 | 1 | 48 | 313 | 324 | 637 | ||||||||||||||||||||||||||||||||||
1745055 | 1745055 | CO | school | 801920 | 1040 | Academy 20 | 80192001592 | 1627 | The Classical Academy Charter | Regular School | Yes | Elementary | KG | 06 | 2021 | pk_12_total | 1709 | 31 | 199 | 7 | 92 | 2 | 132 | 1117 | 1055 | 2172 | 1709 | 31 | 199 | 7 | 92 | 2 | 132 | 1117 | 1055 | 2172 | ||||||||||||||||||||||||||||||||||
1745058 | 1745058 | CO | school | 801920 | 1040 | Academy 20 | 80192001931 | 1629 | The Classical Academy Middle School | Regular School | Yes | Middle | 07 | 08 | 2021 | pk_12_total | 325 | 10 | 45 | 2 | 16 | 2 | 21 | 217 | 204 | 421 | 325 | 10 | 45 | 2 | 16 | 2 | 21 | 217 | 204 | 421 | ||||||||||||||||||||||||||||||||||
1745063 | 1745063 | CO | school | 801920 | 1040 | Academy 20 | 80192001943 | 1630 | The Classical Academy High School | Regular School | Yes | High | 09 | 12 | 2021 | pk_12_total | 487 | 9 | 47 | 1 | 19 | 3 | 19 | 278 | 307 | 585 | 487 | 9 | 47 | 1 | 19 | 3 | 19 | 278 | 307 | 585 | ||||||||||||||||||||||||||||||||||
1745073 | 1745073 | CO | school | 801920 | 1040 | Academy 20 | 80192006478 | 1901 | Journey K8 | Regular School | No | Elementary | KG | 08 | 2021 | pk_12_total | 109 | 2 | 23 | 0 | 4 | 0 | 3 | 58 | 83 | 141 | 109 | 2 | 23 | 0 | 4 | 0 | 3 | 58 | 83 | 141 | ||||||||||||||||||||||||||||||||||
1745077 | 1745077 | CO | school | 801920 | 1040 | Academy 20 | 80192006616 | 1921 | Discovery Canyon Campus Middle School | Regular School | No | Middle | 06 | 08 | 2021 | pk_12_total | 525 | 28 | 97 | 1 | 40 | 1 | 61 | 386 | 367 | 753 | 525 | 28 | 97 | 1 | 40 | 1 | 61 | 386 | 367 | 753 | ||||||||||||||||||||||||||||||||||
1745084 | 1745084 | CO | school | 801920 | 1040 | Academy 20 | 80192006631 | 1929 | Discovery Canyon Campus Elementary School | Regular School | No | Elementary | PK | 05 | 2021 | pk_12_total | 342 | 18 | 87 | 0 | 30 | 1 | 40 | 291 | 227 | 518 | 342 | 18 | 87 | 0 | 30 | 1 | 40 | 291 | 227 | 518 | ||||||||||||||||||||||||||||||||||
1745090 | 1745090 | CO | school | 801920 | 1040 | Academy 20 | 80192001905 | 2195 | Discovery Canyon Campus High School | Regular School | No | High | 09 | 12 | 2021 | pk_12_total | 800 | 33 | 158 | 4 | 81 | 0 | 84 | 616 | 544 | 1160 | 800 | 33 | 158 | 4 | 81 | 0 | 84 | 616 | 544 | 1160 | ||||||||||||||||||||||||||||||||||
1745097 | 1745097 | CO | school | 801920 | 1040 | Academy 20 | 80192000003 | 2248 | Douglass Valley Elementary School | Regular School | No | Elementary | KG | 05 | 2021 | pk_12_total | 162 | 21 | 69 | 1 | 7 | 3 | 33 | 162 | 134 | 296 | 162 | 21 | 69 | 1 | 7 | 3 | 33 | 162 | 134 | 296 | ||||||||||||||||||||||||||||||||||
1745101 | 1745101 | CO | school | 801920 | 1040 | Academy 20 | 80192001402 | 2358 | Eagleview Middle School | Regular School | No | Middle | 06 | 08 | 2021 | pk_12_total | 690 | 20 | 145 | 1 | 23 | 2 | 63 | 454 | 490 | 944 | 690 | 20 | 145 | 1 | 23 | 2 | 63 | 454 | 490 | 944 | ||||||||||||||||||||||||||||||||||
1745108 | 1745108 | CO | school | 801920 | 1040 | Academy 20 | 80192000004 | 2524 | Edith Wolford Elementary School | Regular School | No | Elementary | PK | 05 | 2021 | pk_12_total | 272 | 2 | 58 | 1 | 0 | 0 | 19 | 194 | 158 | 352 | 272 | 2 | 58 | 1 | 0 | 0 | 19 | 194 | 158 | 352 | ||||||||||||||||||||||||||||||||||
1745116 | 1745116 | CO | school | 801920 | 1040 | Academy 20 | 80192001496 | 2800 | Explorer Elementary School | Regular School | No | Elementary | PK | 05 | 2021 | pk_12_total | 329 | 18 | 71 | 0 | 15 | 3 | 30 | 257 | 209 | 466 | 329 | 18 | 71 | 0 | 15 | 3 | 30 | 257 | 209 | 466 | ||||||||||||||||||||||||||||||||||
1745124 | 1745124 | CO | school | 801920 | 1040 | Academy 20 | 80192001319 | 3104 | Foothills Elementary School | Regular School | No | Elementary | KG | 05 | 2021 | pk_12_total | 269 | 14 | 89 | 2 | 8 | 0 | 37 | 220 | 199 | 419 | 269 | 14 | 89 | 2 | 8 | 0 | 37 | 220 | 199 | 419 | ||||||||||||||||||||||||||||||||||
1745131 | 1745131 | CO | school | 801920 | 1040 | Academy 20 | 80192001387 | 3238 | Frontier Elementary School | Regular School | No | Elementary | PK | 05 | 2021 | pk_12_total | 159 | 9 | 60 | 2 | 14 | 2 | 27 | 136 | 137 | 273 | 159 | 9 | 60 | 2 | 14 | 2 | 27 | 136 | 137 | 273 | ||||||||||||||||||||||||||||||||||
1745139 | 1745139 | CO | school | 801920 | 1040 | Academy 20 | 80192001320 | 3985 | High Plains Elementary School | Regular School | No | Elementary | PK | 05 | 2021 | pk_12_total | 141 | 11 | 77 | 0 | 12 | 3 | 23 | 138 | 129 | 267 | 141 | 11 | 77 | 0 | 12 | 3 | 23 | 138 | 129 | 267 | ||||||||||||||||||||||||||||||||||
1745145 | 1745145 | CO | school | 801920 | 1040 | Academy 20 | 80192001429 | 5126 | Liberty High School | Regular School | No | High | 09 | 12 | 2021 | pk_12_total | 1243 | 59 | 259 | 10 | 38 | 4 | 108 | 874 | 847 | 1721 | 1243 | 59 | 259 | 10 | 38 | 4 | 108 | 874 | 847 | 1721 | ||||||||||||||||||||||||||||||||||
1745149 | 1745149 | CO | school | 801920 | 1040 | Academy 20 | 80192001593 | 6140 | Mountain Ridge Middle School | Regular School | No | Middle | 06 | 08 | 2021 | pk_12_total | 517 | 35 | 180 | 0 | 40 | 6 | 76 | 396 | 458 | 854 | 517 | 35 | 180 | 0 | 40 | 6 | 76 | 396 | 458 | 854 | ||||||||||||||||||||||||||||||||||
1745157 | 1745157 | CO | school | 801920 | 1040 | Academy 20 | 80192000005 | 6158 | Mountain View Elementary School | Regular School | No | Elementary | KG | 05 | 2021 | pk_12_total | 420 | 11 | 88 | 1 | 27 | 4 | 48 | 313 | 286 | 599 | 420 | 11 | 88 | 1 | 27 | 4 | 48 | 313 | 286 | 599 | ||||||||||||||||||||||||||||||||||
1745168 | 1745168 | CO | school | 801920 | 1040 | Academy 20 | 80192006745 | 6242 | New Summit Charter Academy | Regular School | Yes | Elementary | KG | 08 | 2021 | pk_12_total | 430 | 21 | 76 | 3 | 20 | 3 | 52 | 275 | 330 | 605 | 430 | 21 | 76 | 3 | 20 | 3 | 52 | 275 | 330 | 605 | ||||||||||||||||||||||||||||||||||
1745175 | 1745175 | CO | school | 801920 | 1040 | Academy 20 | 80192006758 | 6247 | Legacy Peak Elementary School | Regular School | No | Elementary | PK | 05 | 2021 | pk_12_total | 393 | 13 | 78 | 7 | 22 | 1 | 51 | 290 | 275 | 565 | 393 | 13 | 78 | 7 | 22 | 1 | 51 | 290 | 275 | 565 | ||||||||||||||||||||||||||||||||||
1745181 | 1745181 | CO | school | 801920 | 1040 | Academy 20 | 80192001645 | 6937 | Pine Creek High School | Regular School | No | High | 09 | 12 | 2021 | pk_12_total | 1113 | 42 | 244 | 9 | 91 | 8 | 137 | 867 | 777 | 1644 | 1113 | 42 | 244 | 9 | 91 | 8 | 137 | 867 | 777 | 1644 | ||||||||||||||||||||||||||||||||||
1745188 | 1745188 | CO | school | 801920 | 1040 | Academy 20 | 80192001430 | 6960 | Pioneer Elementary School | Regular School | No | Elementary | KG | 05 | 2021 | pk_12_total | 212 | 16 | 86 | 2 | 9 | 0 | 29 | 171 | 183 | 354 | 212 | 16 | 86 | 2 | 9 | 0 | 29 | 171 | 183 | 354 | ||||||||||||||||||||||||||||||||||
1745195 | 1745195 | CO | school | 801920 | 1040 | Academy 20 | 80192000531 | 7159 | Prairie Hills Elementary School | Regular School | No | Elementary | KG | 05 | 2021 | pk_12_total | 266 | 17 | 71 | 3 | 4 | 2 | 26 | 213 | 176 | 389 | 266 | 17 | 71 | 3 | 4 | 2 | 26 | 213 | 176 | 389 | ||||||||||||||||||||||||||||||||||
1745200 | 1745200 | CO | school | 801920 | 1040 | Academy 20 | 80192001321 | 7240 | Rampart High School | Regular School | No | High | 09 | 12 | 2021 | pk_12_total | 946 | 58 | 289 | 7 | 85 | 10 | 124 | 757 | 762 | 1519 | 946 | 58 | 289 | 7 | 85 | 10 | 124 | 757 | 762 | 1519 | ||||||||||||||||||||||||||||||||||
1745207 | 1745207 | CO | school | 801920 | 1040 | Academy 20 | 80192006336 | 7247 | Ranch Creek Elementary | Regular School | No | Elementary | PK | 05 | 2021 | pk_12_total | 355 | 16 | 97 | 1 | 13 | 0 | 49 | 255 | 276 | 531 | 355 | 16 | 97 | 1 | 13 | 0 | 49 | 255 | 276 | 531 | ||||||||||||||||||||||||||||||||||
1745215 | 1745215 | CO | school | 801920 | 1040 | Academy 20 | 80192000007 | 7460 | Rockrimmon Elementary School | Regular School | No | Elementary | KG | 05 | 2021 | pk_12_total | 247 | 8 | 54 | 0 | 6 | 1 | 24 | 155 | 185 | 340 | 247 | 8 | 54 | 0 | 6 | 1 | 24 | 155 | 185 | 340 | ||||||||||||||||||||||||||||||||||
1745222 | 1745222 | CO | school | 801920 | 1040 | Academy 20 | 80192006447 | 8779 | TCA College Pathways | Regular School | Yes | High | 07 | 12 | 2021 | pk_12_total | 394 | 15 | 42 | 1 | 20 | 2 | 38 | 235 | 277 | 512 | 394 | 15 | 42 | 1 | 20 | 2 | 38 | 235 | 277 | 512 | ||||||||||||||||||||||||||||||||||
1745229 | 1745229 | CO | school | 801920 | 1040 | Academy 20 | 80192001842 | 8813 | The Da Vinci Academy School | Regular School | No | Elementary | PK | 05 | 2021 | pk_12_total | 246 | 13 | 72 | 4 | 46 | 1 | 34 | 218 | 198 | 416 | 246 | 13 | 72 | 4 | 46 | 1 | 34 | 218 | 198 | 416 | ||||||||||||||||||||||||||||||||||
1745234 | 1745234 | CO | school | 801920 | 1040 | Academy 20 | 80192001462 | 8851 | Timberview Middle School | Regular School | No | Middle | 06 | 08 | 2021 | pk_12_total | 621 | 33 | 172 | 5 | 17 | 3 | 86 | 485 | 452 | 937 | 621 | 33 | 172 | 5 | 17 | 3 | 86 | 485 | 452 | 937 | ||||||||||||||||||||||||||||||||||
1745241 | 1745241 | CO | school | 801920 | 1040 | Academy 20 | 80192000008 | 9714 | Woodmen-Roberts Elementary School | Regular School | No | Elementary | PK | 05 | 2021 | pk_12_total | 314 | 12 | 52 | 2 | 14 | 0 | 36 | 217 | 213 | 430 | 314 | 12 | 52 | 2 | 14 | 0 | 36 | 217 | 213 | 430 | ||||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||
1738412 | 1738412 | CO | school | 806900 | 20 | Adams 12 Five Star Schools | 80690001726 | 57 | Rocky Top Middle School | Regular School | No | Middle | 06 | 08 | 2021 | pk_12_total | 640 | 18 | 238 | 4 | 66 | 5 | 61 | 537 | 495 | 1032 | 640 | 18 | 238 | 4 | 66 | 5 | 61 | 537 | 495 | 1032 | ||||||||||||||||||||||||||||||||||
1738419 | 1738419 | CO | school | 806900 | 20 | Adams 12 Five Star Schools | 80690001733 | 59 | Meridian Elementary School | Regular School | No | Elementary | KG | 05 | 2021 | pk_12_total | 364 | 6 | 82 | 0 | 33 | 1 | 45 | 287 | 244 | 531 | 364 | 6 | 82 | 0 | 33 | 1 | 45 | 287 | 244 | 531 | ||||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||
1738428 | 1738428 | CO | school | 806900 | 20 | Adams 12 Five Star Schools | 80690001172 | 210 | Vantage Point | Alternative School | No | High | 06 | 12 | 2021 | pk_12_total | 118 | 9 | 196 | 2 | 10 | 1 | 8 | 215 | 129 | 344 | 118 | 9 | 196 | 2 | 10 | 1 | 8 | 215 | 129 | 344 | ||||||||||||||||||||||||||||||||||
1738435 | 1738435 | CO | school | 806900 | 20 | Adams 12 Five Star Schools | 80690001619 | 301 | Arapahoe Ridge Elementary School | Regular School | No | Elementary | PK | 05 | 2021 | pk_12_total | 221 | 6 | 228 | 3 | 30 | 1 | 19 | 263 | 245 | 508 | 221 | 6 | 228 | 3 | 30 | 1 | 19 | 263 | 245 | 508 | ||||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||
1738484 | 1738484 | CO | school | 806900 | 20 | Adams 12 Five Star Schools | 80690001668 | 1937 | Coyote Ridge Elementary School | Regular School | No | Elementary | KG | 05 | 2021 | pk_12_total | 295 | 5 | 52 | 0 | 25 | 1 | 20 | 189 | 209 | 398 | 295 | 5 | 52 | 0 | 25 | 1 | 20 | 189 | 209 | 398 | ||||||||||||||||||||||||||||||||||
1738491 | 1738491 | CO | school | 806900 | 20 | Adams 12 Five Star Schools | 80690001622 | 2361 | Eagleview Elementary School | Regular School | No | Elementary | KG | 05 | 2021 | pk_12_total | 284 | 11 | 143 | 2 | 43 | 1 | 25 | 271 | 238 | 509 | 284 | 11 | 143 | 2 | 43 | 1 | 25 | 271 | 238 | 509 | ||||||||||||||||||||||||||||||||||
1738498 | 1738498 | CO | school | 806900 | 20 | Adams 12 Five Star Schools | 80690001175 | 2410 | Tarver Elementary School | Regular School | No | Elementary | PK | 05 | 2021 | pk_12_total | 252 | 6 | 162 | 3 | 27 | 1 | 22 | 241 | 232 | 473 | 252 | 6 | 162 | 3 | 27 | 1 | 22 | 241 | 232 | 473 | ||||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||
1738521 | 1738521 | CO | school | 806900 | 20 | Adams 12 Five Star Schools | 80690001419 | 2580 | Hunters Glen Elementary School | Regular School | No | Elementary | PK | 05 | 2021 | pk_12_total | 185 | 13 | 153 | 2 | 21 | 1 | 19 | 204 | 190 | 394 | 185 | 13 | 153 | 2 | 21 | 1 | 19 | 204 | 190 | 394 | ||||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||
1738557 | 1738557 | CO | school | 806900 | 20 | Adams 12 Five Star Schools | 80690001491 | 4108 | Horizon High School | Regular School | No | High | 09 | 12 | 2021 | pk_12_total | 1206 | 31 | 610 | 4 | 121 | 3 | 92 | 1002 | 1065 | 2067 | 1206 | 31 | 610 | 4 | 121 | 3 | 92 | 1002 | 1065 | 2067 | ||||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||
1738581 | 1738581 | CO | school | 806900 | 20 | Adams 12 Five Star Schools | 80690001784 | 5043 | Legacy High School | Regular School | No | High | 09 | 12 | 2021 | pk_12_total | 1530 | 27 | 554 | 8 | 182 | 3 | 113 | 1255 | 1162 | 2417 | 1530 | 27 | 554 | 8 | 182 | 3 | 113 | 1255 | 1162 | 2417 | ||||||||||||||||||||||||||||||||||
1738588 | 1738588 | CO | school | 806900 | 20 | Adams 12 Five Star Schools | 80690001306 | 5058 | Leroy Drive Elementary School | Regular School | No | Elementary | KG | 05 | 2021 | pk_12_total | 97 | 14 | 221 | 3 | 14 | 1 | 15 | 199 | 166 | 365 | 97 | 14 | 221 | 3 | 14 | 1 | 15 | 199 | 166 | 365 | ||||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||
1738603 | 1738603 | CO | school | 806900 | 20 | Adams 12 Five Star Schools | 80690001182 | 5706 | McElwain Elementary School | Regular School | No | Elementary | KG | 05 | 2021 | pk_12_total | 59 | 11 | 255 | 1 | 38 | 2 | 5 | 189 | 182 | 371 | 59 | 11 | 255 | 1 | 38 | 2 | 5 | 189 | 182 | 371 | ||||||||||||||||||||||||||||||||||
1738607 | 1738607 | CO | school | 806900 | 20 | Adams 12 Five Star Schools | 80690001183 | 5814 | Thornton Middle School | Regular School | No | Middle | 06 | 08 | 2021 | pk_12_total | 97 | 41 | 727 | 6 | 18 | 3 | 16 | 469 | 439 | 908 | 97 | 41 | 727 | 6 | 18 | 3 | 16 | 469 | 439 | 908 | ||||||||||||||||||||||||||||||||||
1738612 | 1738612 | CO | school | 806900 | 20 | Adams 12 Five Star Schools | 80690001192 | 5816 | Thornton High School | Regular School | No | High | 09 | 12 | 2021 | pk_12_total | 294 | 41 | 1099 | 14 | 59 | 1 | 36 | 779 | 765 | 1544 | 294 | 41 | 1099 | 14 | 59 | 1 | 36 | 779 | 765 | 1544 | ||||||||||||||||||||||||||||||||||
1738617 | 1738617 | CO | school | 806900 | 20 | Adams 12 Five Star Schools | 80690001996 | 6060 | Mountain Range High School | Regular School | No | High | 09 | 12 | 2021 | pk_12_total | 876 | 37 | 770 | 13 | 92 | 2 | 63 | 917 | 936 | 1853 | 876 | 37 | 770 | 13 | 92 | 2 | 63 | 917 | 936 | 1853 | ||||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||
1738636 | 1738636 | CO | school | 806900 | 20 | Adams 12 Five Star Schools | 80690001184 | 6355 | North Mor Elementary School | Regular School | No | Elementary | PK | 05 | 2021 | pk_12_total | 102 | 5 | 262 | 2 | 11 | 1 | 12 | 203 | 192 | 395 | 102 | 5 | 262 | 2 | 11 | 1 | 12 | 203 | 192 | 395 | ||||||||||||||||||||||||||||||||||
1738644 | 1738644 | CO | school | 806900 | 20 | Adams 12 Five Star Schools | 80690001185 | 6376 | North Star Elementary School | Regular School | No | Elementary | PK | 05 | 2021 | pk_12_total | 38 | 18 | 288 | 2 | 9 | 2 | 8 | 193 | 172 | 365 | 38 | 18 | 288 | 2 | 9 | 2 | 8 | 193 | 172 | 365 | ||||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||
1738654 | 1738654 | CO | school | 806900 | 20 | Adams 12 Five Star Schools | 80690001188 | 6402 | Northglenn High School | Regular School | No | High | 09 | 12 | 2021 | pk_12_total | 452 | 29 | 1430 | 14 | 68 | 4 | 42 | 1092 | 947 | 2039 | 452 | 29 | 1430 | 14 | 68 | 4 | 42 | 1092 | 947 | 2039 | ||||||||||||||||||||||||||||||||||
1738668 | 1738668 | CO | school | 806900 | 20 | Adams 12 Five Star Schools | 80690006507 | 6802 | Prospect Ridge Academy | Regular School | Yes | Other | KG | 12 | 2021 | pk_12_total | 1037 | 8 | 165 | 3 | 126 | 2 | 93 | 700 | 734 | 1434 | 1037 | 8 | 165 | 3 | 126 | 2 | 93 | 700 | 734 | 1434 | ||||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||
1738683 | 1738683 | CO | school | 806900 | 20 | Adams 12 Five Star Schools | 80690001945 | 7155 | Prairie Hills Elementary School | Regular School | No | Elementary | KG | 05 | 2021 | pk_12_total | 299 | 3 | 89 | 2 | 29 | 1 | 27 | 225 | 225 | 450 | 299 | 3 | 89 | 2 | 29 | 1 | 27 | 225 | 225 | 450 | ||||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||
1738697 | 1738697 | CO | school | 806900 | 20 | Adams 12 Five Star Schools | 80690006375 | 8211 | The Studio School | Regular School | No | Elementary | KG | 05 | 2021 | pk_12_total | 128 | 6 | 96 | 3 | 7 | 1 | 25 | 95 | 171 | 266 | 128 | 6 | 96 | 3 | 7 | 1 | 25 | 95 | 171 | 266 | ||||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||
1738714 | 1738714 | CO | school | 806900 | 20 | Adams 12 Five Star Schools | 80690006468 | 8275 | STEM Lab | Regular School | No | Elementary | PK | 08 | 2021 | pk_12_total | 434 | 7 | 170 | 2 | 41 | 1 | 51 | 402 | 304 | 706 | 434 | 7 | 170 | 2 | 41 | 1 | 51 | 402 | 304 | 706 | ||||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||
1738732 | 1738732 | CO | school | 806900 | 20 | Adams 12 Five Star Schools | 80690001190 | 8361 | Stukey Elementary School | Regular School | No | Elementary | KG | 05 | 2021 | pk_12_total | 91 | 5 | 212 | 8 | 25 | 2 | 12 | 187 | 168 | 355 | 91 | 5 | 212 | 8 | 25 | 2 | 12 | 187 | 168 | 355 | ||||||||||||||||||||||||||||||||||
1738742 | 1738742 | CO | school | 806900 | 20 | Adams 12 Five Star Schools | 80690006740 | 8814 | Thunder Vista P-8 | Regular School | No | Elementary | PK | 08 | 2021 | pk_12_total | 574 | 4 | 79 | 0 | 53 | 3 | 33 | 402 | 344 | 746 | 574 | 4 | 79 | 0 | 53 | 3 | 33 | 402 | 344 | 746 | ||||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||
1738784 | 1738784 | CO | school | 806900 | 20 | Adams 12 Five Star Schools | 80690001196 | 9682 | Woodglen Elementary School | Regular School | No | Elementary | PK | 05 | 2021 | pk_12_total | 182 | 1 | 199 | 6 | 21 | 1 | 31 | 229 | 212 | 441 | 182 | 1 | 199 | 6 | 21 | 1 | 31 | 229 | 212 | 441 | ||||||||||||||||||||||||||||||||||
1738789 | 1738789 | CO | school | 801950 | 30 | Adams County 14 | 80195000009 | 20 | Adams City Middle School | Regular School | No | Middle | 06 | 08 | 2021 | pk_12_total | 63 | 9 | 629 | 6 | 0 | 2 | 9 | 379 | 339 | 718 | 63 | 9 | 629 | 6 | 0 | 2 | 9 | 379 | 339 | 718 | ||||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||
1738799 | 1738799 | CO | school | 801950 | 30 | Adams County 14 | 80195000010 | 24 | Adams City High School | Regular School | No | High | 09 | 12 | 2021 | pk_12_total | 126 | 25 | 1478 | 8 | 6 | 2 | 11 | 850 | 806 | 1656 | 126 | 25 | 1478 | 8 | 6 | 2 | 11 | 850 | 806 | 1656 | ||||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||
1738808 | 1738808 | CO | school | 801950 | 30 | Adams County 14 | 80195000011 | 186 | Alsup Elementary School | Regular School | No | Elementary | KG | 05 | 2021 | pk_12_total | 46 | 1 | 308 | 1 | 0 | 1 | 8 | 196 | 169 | 365 | 46 | 1 | 308 | 1 | 0 | 1 | 8 | 196 | 169 | 365 | ||||||||||||||||||||||||||||||||||
1738815 | 1738815 | CO | school | 801950 | 30 | Adams County 14 | 80195000012 | 1426 | Central Elementary School | Regular School | No | Elementary | KG | 05 | 2021 | pk_12_total | 39 | 39 | 332 | 1 | 1 | 1 | 4 | 229 | 188 | 417 | 39 | 39 | 332 | 1 | 1 | 1 | 4 | 229 | 188 | 417 | ||||||||||||||||||||||||||||||||||
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 |
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]);