enrollments
Data source: Big Local News · About: Big Local
13,321 rows where state = "CO" and year = 2020 sorted by native_american_alaskan_native descending
This data as json, CSV (advanced)
grade ✖
- pk_12_total 1,916
- grade_5 1,108
- grade_2 1,104
- grade_1 1,102
- grade_4 1,102
- grade_3 1,101
- kindergarten_full_day 1,087
- grade_6 690
- pre_kindergarten 684
- grade_7 626
- grade_8 620
- grade_12 506
- grade_10 503
- grade_11 503
- grade_9 489
- kindergarten_half_day 180
Link | rowid | state | county | county_state_id | admin_level | district_nces_id | district_state_id | district_state_type | district | school_nces_id | school_state_id | school | school_state_type | ccd_school_type | ccd_charter_school | ccd_school_lvl | ccd_school_low_grade | ccd_school_high_grade | year | term | grade | white | black | hispanic | native_american | native_american_alaskan_native ▲ | asian | native_hawaiian | asian_pacific_islander | native_hawaiian_pacific_islander | pacific_islander | multiracial | unknown_race | male | female | non_binary | unknown_gender | ell | ell_percent | homeless | homeless_percent | low_income | free_and_reduced | free_and_reduced_percent | disability | section_504 | total | white_int | black_int | hispanic_int | native_american_int | native_american_alaskan_native_int | asian_int | native_hawaiian_int | asian_pacific_islander_int | native_hawaiian_pacific_islander_int | pacific_islander_int | multiracial_int | unknown_race_int | male_int | female_int | non_binary_int | unknown_gender_int | ell_int | homeless_int | low_income_int | free_and_reduced_int | disability_int | section_504_int | total_int |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1810028 | 1810028 | CO | school | 803090 | 2035 | Montezuma-Cortez RE-1 | 80309000835 | 4546 | Kemper Elementary School | Regular School | No | Elementary | KG | 05 | 2020 | pk_12_total | 180 | 0 | 77 | 93 | 6 | 0 | 23 | 194 | 185 | 379 | 180 | 0 | 77 | 93 | 6 | 0 | 23 | 194 | 185 | 379 | ||||||||||||||||||||||||||||||||||
1799948 | 1799948 | CO | school | 802580 | 40 | School District 27J | 80258000144 | 1022 | Brighton High School | Regular School | No | High | 09 | 12 | 2020 | pk_12_total | 754 | 16 | 962 | 9 | 16 | 5 | 54 | 921 | 895 | 1816 | 754 | 16 | 962 | 9 | 16 | 5 | 54 | 921 | 895 | 1816 | ||||||||||||||||||||||||||||||||||
1800323 | 1800323 | CO | school | 806420 | 110 | Sangre De Cristo Re-22J | 80642001116 | 7630 | Sangre de Cristo Undivided High School | Regular School | No | High | 06 | 12 | 2020 | pk_12_total | 83 | 1 | 49 | 9 | 1 | 0 | 6 | 75 | 74 | 149 | 83 | 1 | 49 | 9 | 1 | 0 | 6 | 75 | 74 | 149 | ||||||||||||||||||||||||||||||||||
1800504 | 1800504 | CO | school | 802910 | 130 | Cherry Creek 5 | 80291000207 | 1568 | West Middle School | Regular School | No | Middle | 06 | 08 | 2020 | pk_12_total | 895 | 28 | 157 | 9 | 81 | 2 | 77 | 670 | 579 | 1249 | 895 | 28 | 157 | 9 | 81 | 2 | 77 | 670 | 579 | 1249 | ||||||||||||||||||||||||||||||||||
1800509 | 1800509 | CO | school | 802910 | 130 | Cherry Creek 5 | 80291000186 | 1570 | Cherry Creek High School | Regular School | No | High | 09 | 12 | 2020 | pk_12_total | 2488 | 126 | 522 | 9 | 485 | 4 | 172 | 1917 | 1889 | 3806 | 2488 | 126 | 522 | 9 | 485 | 4 | 172 | 1917 | 1889 | 3806 | ||||||||||||||||||||||||||||||||||
1801162 | 1801162 | CO | school | 802340 | 180 | Adams-Arapahoe 28J | 80234000060 | 2384 | East Middle School | Regular School | No | Middle | 06 | 08 | 2020 | pk_12_total | 36 | 111 | 706 | 9 | 24 | 6 | 21 | 474 | 439 | 913 | 36 | 111 | 706 | 9 | 24 | 6 | 21 | 474 | 439 | 913 | ||||||||||||||||||||||||||||||||||
1801395 | 1801395 | CO | school | 802340 | 180 | Adams-Arapahoe 28J | 80234000079 | 8078 | South Middle School | Regular School | No | Middle | 06 | 08 | 2020 | pk_12_total | 42 | 140 | 499 | 9 | 18 | 19 | 33 | 397 | 363 | 760 | 42 | 140 | 499 | 9 | 18 | 19 | 33 | 397 | 363 | 760 | ||||||||||||||||||||||||||||||||||
1801561 | 1801561 | CO | school | 802190 | 220 | Archuleta County 50 Jt | 80219000038 | 6652 | Pagosa Springs Elementary School | Regular School | No | Elementary | KG | 04 | 2020 | grade_2 | 48 | 0 | 50 | 9 | 2 | 0 | 2 | 57 | 54 | 111 | 48 | 0 | 50 | 9 | 2 | 0 | 2 | 57 | 54 | 111 | ||||||||||||||||||||||||||||||||||
1802073 | 1802073 | CO | school | 805370 | 470 | St Vrain Valley RE1J | 80537001284 | 7954 | Skyline High School | Regular School | No | High | 09 | 12 | 2020 | pk_12_total | 537 | 17 | 869 | 9 | 27 | 7 | 16 | 782 | 700 | 1482 | 537 | 17 | 869 | 9 | 27 | 7 | 16 | 782 | 700 | 1482 | ||||||||||||||||||||||||||||||||||
1804105 | 1804105 | CO | school | 803360 | 880 | Denver County 1 | 80336000418 | 8888 | Traylor Academy | Regular School | No | Elementary | PK | 05 | 2020 | pk_12_total | 67 | 15 | 323 | 9 | 16 | 0 | 8 | 216 | 222 | 438 | 67 | 15 | 323 | 9 | 16 | 0 | 8 | 216 | 222 | 438 | ||||||||||||||||||||||||||||||||||
1804377 | 1804377 | CO | school | 803450 | 900 | Douglas County Re 1 | 80345001578 | 1503 | Chaparral High School | Regular School | No | High | 09 | 12 | 2020 | pk_12_total | 1600 | 42 | 337 | 9 | 84 | 8 | 113 | 1107 | 1086 | 2193 | 1600 | 42 | 337 | 9 | 84 | 8 | 113 | 1107 | 1086 | 2193 | ||||||||||||||||||||||||||||||||||
1804616 | 1804616 | CO | school | 803450 | 900 | Douglas County Re 1 | 80345006400 | 4271 | Legend High School | Regular School | No | High | 09 | 12 | 2020 | pk_12_total | 1728 | 17 | 275 | 9 | 71 | 3 | 112 | 1108 | 1107 | 2215 | 1728 | 17 | 275 | 9 | 71 | 3 | 112 | 1108 | 1107 | 2215 | ||||||||||||||||||||||||||||||||||
1804828 | 1804828 | CO | school | 803450 | 900 | Douglas County Re 1 | 80345001341 | 7118 | Ponderosa High School | Regular School | No | High | 09 | 12 | 2020 | pk_12_total | 1145 | 4 | 176 | 9 | 34 | 4 | 68 | 761 | 679 | 1440 | 1145 | 4 | 176 | 9 | 34 | 4 | 68 | 761 | 679 | 1440 | ||||||||||||||||||||||||||||||||||
1805451 | 1805451 | CO | school | 806480 | 990 | Widefield 3 | 80648001588 | 5841 | Mesa Ridge High School | Regular School | No | High | 09 | 12 | 2020 | pk_12_total | 619 | 141 | 396 | 9 | 23 | 16 | 121 | 727 | 598 | 1325 | 619 | 141 | 396 | 9 | 23 | 16 | 121 | 727 | 598 | 1325 | ||||||||||||||||||||||||||||||||||
1805504 | 1805504 | CO | school | 806480 | 990 | Widefield 3 | 80648001129 | 9566 | Widefield High School | Regular School | No | High | 09 | 12 | 2020 | pk_12_total | 588 | 125 | 359 | 9 | 15 | 23 | 141 | 650 | 610 | 1260 | 588 | 125 | 359 | 9 | 15 | 23 | 141 | 650 | 610 | 1260 | ||||||||||||||||||||||||||||||||||
1805522 | 1805522 | CO | school | 804080 | 1000 | Fountain 8 | 80408000560 | 1334 | Abrams Elementary School | Regular School | No | Elementary | KG | 05 | 2020 | pk_12_total | 201 | 80 | 119 | 9 | 5 | 9 | 44 | 243 | 224 | 467 | 201 | 80 | 119 | 9 | 5 | 9 | 44 | 243 | 224 | 467 | ||||||||||||||||||||||||||||||||||
1805536 | 1805536 | CO | school | 804080 | 1000 | Fountain 8 | 80408000566 | 3102 | Aragon Elementary School | Regular School | No | Elementary | PK | 05 | 2020 | pk_12_total | 327 | 55 | 180 | 9 | 4 | 7 | 90 | 328 | 344 | 672 | 327 | 55 | 180 | 9 | 4 | 7 | 90 | 328 | 344 | 672 | ||||||||||||||||||||||||||||||||||
1805541 | 1805541 | CO | school | 804080 | 1000 | Fountain 8 | 80408000563 | 3106 | Fountain Middle School | Regular School | No | Middle | 06 | 08 | 2020 | pk_12_total | 549 | 101 | 286 | 9 | 12 | 17 | 110 | 563 | 521 | 1084 | 549 | 101 | 286 | 9 | 12 | 17 | 110 | 563 | 521 | 1084 | ||||||||||||||||||||||||||||||||||
1805560 | 1805560 | CO | school | 804080 | 1000 | Fountain 8 | 80408001481 | 4474 | Jordahl Elementary School | Regular School | No | Elementary | KG | 05 | 2020 | pk_12_total | 325 | 41 | 144 | 9 | 5 | 11 | 66 | 309 | 292 | 601 | 325 | 41 | 144 | 9 | 5 | 11 | 66 | 309 | 292 | 601 | ||||||||||||||||||||||||||||||||||
1806565 | 1806565 | CO | school | 803870 | 1110 | District 49 | 80387000507 | 2908 | Falcon High School | Regular School | No | High | 09 | 12 | 2020 | pk_12_total | 848 | 54 | 227 | 9 | 30 | 1 | 71 | 646 | 594 | 1240 | 848 | 54 | 227 | 9 | 30 | 1 | 71 | 646 | 594 | 1240 | ||||||||||||||||||||||||||||||||||
1806703 | 1806703 | CO | school | 803870 | 1110 | District 49 | 80387006408 | 8791 | Vista Ridge High School | Regular School | No | High | 09 | 12 | 2020 | pk_12_total | 849 | 136 | 389 | 9 | 67 | 16 | 149 | 850 | 765 | 1615 | 849 | 136 | 389 | 9 | 67 | 16 | 149 | 850 | 765 | 1615 | ||||||||||||||||||||||||||||||||||
1807220 | 1807220 | CO | school | 804800 | 1420 | Jefferson County R-1 | 80480000691 | 108 | Alameda International Junior/Senior High School | Regular School | No | High | 07 | 12 | 2020 | pk_12_total | 143 | 9 | 871 | 9 | 57 | 1 | 27 | 593 | 524 | 1117 | 143 | 9 | 871 | 9 | 57 | 1 | 27 | 593 | 524 | 1117 | ||||||||||||||||||||||||||||||||||
1807320 | 1807320 | CO | school | 804800 | 1420 | Jefferson County R-1 | 80480001907 | 965 | Brady Exploration School | Alternative School | No | High | 09 | 12 | 2020 | pk_12_total | 157 | 7 | 203 | 9 | 1 | 1 | 17 | 226 | 169 | 395 | 157 | 7 | 203 | 9 | 1 | 1 | 17 | 226 | 169 | 395 | ||||||||||||||||||||||||||||||||||
1807418 | 1807418 | CO | school | 804800 | 1420 | Jefferson County R-1 | 80480000708 | 1976 | Creighton Middle School | Regular School | No | Middle | 06 | 08 | 2020 | pk_12_total | 347 | 23 | 424 | 9 | 25 | 4 | 42 | 442 | 432 | 874 | 347 | 23 | 424 | 9 | 25 | 4 | 42 | 442 | 432 | 874 | ||||||||||||||||||||||||||||||||||
1807733 | 1807733 | CO | school | 804800 | 1420 | Jefferson County R-1 | 80480000747 | 4942 | Lakewood High School | Regular School | No | High | 09 | 12 | 2020 | grade_11 | 309 | 6 | 173 | 9 | 29 | 2 | 18 | 283 | 263 | 546 | 309 | 6 | 173 | 9 | 29 | 2 | 18 | 283 | 263 | 546 | ||||||||||||||||||||||||||||||||||
1808578 | 1808578 | CO | school | 803480 | 1520 | Durango 9-R | 80348006696 | 1526 | Colorado Connections Academy @ Durango | Regular School | No | Other | KG | 12 | 2020 | pk_12_total | 509 | 16 | 217 | 9 | 13 | 1 | 45 | 415 | 395 | 810 | 509 | 16 | 217 | 9 | 13 | 1 | 45 | 415 | 395 | 810 | ||||||||||||||||||||||||||||||||||
1808651 | 1808651 | CO | school | 803480 | 1520 | Durango 9-R | 80348000456 | 7994 | Escalante Middle School | Regular School | No | Middle | 06 | 08 | 2020 | grade_7 | 120 | 0 | 43 | 9 | 1 | 0 | 10 | 78 | 105 | 183 | 120 | 0 | 43 | 9 | 1 | 0 | 10 | 78 | 105 | 183 | ||||||||||||||||||||||||||||||||||
1808678 | 1808678 | CO | school | 802400 | 1530 | Bayfield 10 Jt-R | 80240006747 | 642 | Bayfield Primary School | Regular School | No | Elementary | PK | 02 | 2020 | pk_12_total | 238 | 1 | 51 | 9 | 0 | 1 | 9 | 153 | 156 | 309 | 238 | 1 | 51 | 9 | 0 | 1 | 9 | 153 | 156 | 309 | ||||||||||||||||||||||||||||||||||
1808753 | 1808753 | CO | school | 803990 | 1550 | Poudre R-1 | 80399000519 | 612 | Bauder Elementary School | Regular School | No | Elementary | PK | 05 | 2020 | pk_12_total | 421 | 15 | 122 | 9 | 6 | 3 | 11 | 298 | 289 | 587 | 421 | 15 | 122 | 9 | 6 | 3 | 11 | 298 | 289 | 587 | ||||||||||||||||||||||||||||||||||
1809313 | 1809313 | CO | school | 805400 | 1560 | Thompson R2-J | 80540001286 | 9228 | Walt Clark Middle School | Regular School | No | Middle | 06 | 08 | 2020 | pk_12_total | 372 | 1 | 75 | 9 | 2 | 1 | 12 | 259 | 213 | 472 | 372 | 1 | 75 | 9 | 2 | 1 | 12 | 259 | 213 | 472 | ||||||||||||||||||||||||||||||||||
1809767 | 1809767 | CO | school | 804350 | 2000 | Mesa County Valley 51 | 80435000612 | 3570 | Grand Junction High School | Regular School | No | High | 09 | 12 | 2020 | pk_12_total | 974 | 9 | 360 | 9 | 19 | 0 | 81 | 759 | 693 | 1452 | 974 | 9 | 360 | 9 | 19 | 0 | 81 | 759 | 693 | 1452 | ||||||||||||||||||||||||||||||||||
1809871 | 1809871 | CO | school | 804350 | 2000 | Mesa County Valley 51 | 80435000620 | 6666 | Palisade High School | Regular School | No | High | 09 | 12 | 2020 | pk_12_total | 710 | 6 | 318 | 9 | 10 | 0 | 38 | 537 | 554 | 1091 | 710 | 6 | 318 | 9 | 10 | 0 | 38 | 537 | 554 | 1091 | ||||||||||||||||||||||||||||||||||
1810025 | 1810025 | CO | school | 803090 | 2035 | Montezuma-Cortez RE-1 | 80309000835 | 4546 | Kemper Elementary School | Regular School | No | Elementary | KG | 05 | 2020 | grade_4 | 34 | 0 | 18 | 9 | 1 | 0 | 5 | 32 | 35 | 67 | 34 | 0 | 18 | 9 | 1 | 0 | 5 | 32 | 35 | 67 | ||||||||||||||||||||||||||||||||||
1810069 | 1810069 | CO | school | 803090 | 2035 | Montezuma-Cortez RE-1 | 80309001692 | 8133 | Southwest Open Charter School | Alternative School | Yes | High | 09 | 12 | 2020 | grade_9 | 11 | 0 | 5 | 9 | 0 | 0 | 0 | 15 | 10 | 25 | 11 | 0 | 5 | 9 | 0 | 0 | 0 | 15 | 10 | 25 | ||||||||||||||||||||||||||||||||||
1811887 | 1811887 | CO | school | 804410 | 3120 | Greeley 6 | 80441000641 | 3610 | Greeley Central High School | Regular School | No | High | 09 | 12 | 2020 | pk_12_total | 336 | 77 | 1062 | 9 | 30 | 1 | 17 | 767 | 765 | 1532 | 336 | 77 | 1062 | 9 | 30 | 1 | 17 | 767 | 765 | 1532 | ||||||||||||||||||||||||||||||||||
1806570 | 1806570 | CO | school | 803870 | 1110 | District 49 | 80387006393 | 3475 | GOAL Academy | Alternative School | Yes | High | 09 | 12 | 2020 | pk_12_total | 1989 | 203 | 2455 | 86 | 22 | 23 | 187 | 2411 | 2554 | 4965 | 1989 | 203 | 2455 | 86 | 22 | 23 | 187 | 2411 | 2554 | 4965 | ||||||||||||||||||||||||||||||||||
1799640 | 1799640 | CO | school | 806900 | 20 | Adams 12 Five Star Schools | 80690001784 | 5043 | Legacy High School | Regular School | No | High | 09 | 12 | 2020 | pk_12_total | 1595 | 31 | 536 | 8 | 197 | 3 | 75 | 1284 | 1161 | 2445 | 1595 | 31 | 536 | 8 | 197 | 3 | 75 | 1284 | 1161 | 2445 | ||||||||||||||||||||||||||||||||||
1799848 | 1799848 | CO | school | 801950 | 30 | Adams County 14 | 80195000009 | 20 | Adams City Middle School | Regular School | No | Middle | 06 | 08 | 2020 | pk_12_total | 68 | 9 | 675 | 8 | 1 | 1 | 11 | 397 | 376 | 773 | 68 | 9 | 675 | 8 | 1 | 1 | 11 | 397 | 376 | 773 | ||||||||||||||||||||||||||||||||||
1800595 | 1800595 | CO | school | 802910 | 130 | Cherry Creek 5 | 80291006367 | 3030 | Fox Ridge Middle School | Regular School | No | Middle | 06 | 08 | 2020 | pk_12_total | 698 | 52 | 162 | 8 | 84 | 0 | 81 | 587 | 498 | 1085 | 698 | 52 | 162 | 8 | 84 | 0 | 81 | 587 | 498 | 1085 | ||||||||||||||||||||||||||||||||||
1800960 | 1800960 | CO | school | 805310 | 140 | Littleton 6 | 80531000764 | 6292 | Village at North | Regular School | No | Prekindergarten | PK | PK | 2020 | pk_12_total | 240 | 13 | 107 | 8 | 12 | 0 | 17 | 229 | 168 | 397 | 240 | 13 | 107 | 8 | 12 | 0 | 17 | 229 | 168 | 397 | ||||||||||||||||||||||||||||||||||
1800961 | 1800961 | CO | school | 805310 | 140 | Littleton 6 | 80531000764 | 6292 | Village at North | Regular School | No | Prekindergarten | PK | PK | 2020 | pre_kindergarten | 240 | 13 | 107 | 8 | 12 | 0 | 17 | 229 | 168 | 397 | 240 | 13 | 107 | 8 | 12 | 0 | 17 | 229 | 168 | 397 | ||||||||||||||||||||||||||||||||||
1801084 | 1801084 | CO | school | 802340 | 180 | Adams-Arapahoe 28J | 80234000054 | 464 | Aurora Hills Middle School | Regular School | No | Middle | 06 | 08 | 2020 | pk_12_total | 62 | 159 | 460 | 8 | 32 | 12 | 44 | 406 | 371 | 777 | 62 | 159 | 460 | 8 | 32 | 12 | 44 | 406 | 371 | 777 | ||||||||||||||||||||||||||||||||||
1801110 | 1801110 | CO | school | 802340 | 180 | Adams-Arapahoe 28J | 80234000056 | 1458 | Aurora Central High School | Regular School | No | High | 09 | 12 | 2020 | grade_9 | 18 | 69 | 310 | 8 | 19 | 8 | 15 | 235 | 212 | 447 | 18 | 69 | 310 | 8 | 19 | 8 | 15 | 235 | 212 | 447 | ||||||||||||||||||||||||||||||||||
1801210 | 1801210 | CO | school | 802340 | 180 | Adams-Arapahoe 28J | 80234000064 | 4024 | Hinkley High School | Regular School | No | High | 09 | 12 | 2020 | grade_11 | 25 | 66 | 356 | 8 | 20 | 4 | 13 | 234 | 258 | 492 | 25 | 66 | 356 | 8 | 20 | 4 | 13 | 234 | 258 | 492 | ||||||||||||||||||||||||||||||||||
1801363 | 1801363 | CO | school | 802340 | 180 | Adams-Arapahoe 28J | 80234001389 | 7250 | Rangeview High School | Regular School | No | High | 09 | 12 | 2020 | grade_10 | 120 | 126 | 233 | 8 | 30 | 4 | 35 | 287 | 269 | 556 | 120 | 126 | 233 | 8 | 30 | 4 | 35 | 287 | 269 | 556 | ||||||||||||||||||||||||||||||||||
1801574 | 1801574 | CO | school | 802190 | 220 | Archuleta County 50 Jt | 80219000039 | 6658 | Pagosa Springs High School | Regular School | No | High | 09 | 12 | 2020 | grade_12 | 60 | 0 | 17 | 8 | 3 | 0 | 0 | 44 | 44 | 88 | 60 | 0 | 17 | 8 | 3 | 0 | 0 | 44 | 44 | 88 | ||||||||||||||||||||||||||||||||||
1802269 | 1802269 | CO | school | 802490 | 480 | Boulder Valley Re 2 | 80249000114 | 2892 | Fairview High School | Regular School | No | High | 09 | 12 | 2020 | pk_12_total | 1511 | 18 | 232 | 8 | 215 | 3 | 144 | 1136 | 995 | 2131 | 1511 | 18 | 232 | 8 | 215 | 3 | 144 | 1136 | 995 | 2131 | ||||||||||||||||||||||||||||||||||
1803396 | 1803396 | CO | school | 803360 | 880 | Denver County 1 | 80336001776 | 3641 | Green Valley Elementary School | Regular School | No | Elementary | PK | 05 | 2020 | pk_12_total | 73 | 142 | 368 | 8 | 57 | 10 | 25 | 358 | 325 | 683 | 73 | 142 | 368 | 8 | 57 | 10 | 25 | 358 | 325 | 683 | ||||||||||||||||||||||||||||||||||
1803639 | 1803639 | CO | school | 803360 | 880 | Denver County 1 | 80336001867 | 5342 | Lowry Elementary School | Regular School | No | Elementary | PK | 05 | 2020 | pk_12_total | 187 | 161 | 104 | 8 | 18 | 2 | 45 | 284 | 241 | 525 | 187 | 161 | 104 | 8 | 18 | 2 | 45 | 284 | 241 | 525 | ||||||||||||||||||||||||||||||||||
1805118 | 1805118 | CO | school | 803720 | 920 | Elizabeth School District | 80372001586 | 2572 | Legacy Academy | Regular School | Yes | Elementary | KG | 08 | 2020 | pk_12_total | 404 | 8 | 26 | 8 | 7 | 0 | 12 | 216 | 249 | 465 | 404 | 8 | 26 | 8 | 7 | 0 | 12 | 216 | 249 | 465 | ||||||||||||||||||||||||||||||||||
1805480 | 1805480 | CO | school | 806480 | 990 | Widefield 3 | 80648001126 | 9294 | Watson Junior High School | Regular School | No | Middle | 06 | 08 | 2020 | pk_12_total | 239 | 62 | 171 | 8 | 5 | 1 | 74 | 275 | 285 | 560 | 239 | 62 | 171 | 8 | 5 | 1 | 74 | 275 | 285 | 560 | ||||||||||||||||||||||||||||||||||
1805886 | 1805886 | CO | school | 803060 | 1010 | Colorado Springs 11 | 80306000262 | 7482 | Roosevelt Charter Academy | Regular School | Yes | Elementary | KG | 05 | 2020 | pk_12_total | 87 | 33 | 417 | 8 | 2 | 0 | 35 | 297 | 285 | 582 | 87 | 33 | 417 | 8 | 2 | 0 | 35 | 297 | 285 | 582 | ||||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||
1806412 | 1806412 | CO | school | 805820 | 1080 | Lewis-Palmer 38 | 80582001371 | 3539 | Bear Creek Elementary School | Regular School | No | Elementary | PK | 06 | 2020 | pk_12_total | 747 | 15 | 118 | 8 | 11 | 1 | 63 | 496 | 467 | 963 | 747 | 15 | 118 | 8 | 11 | 1 | 63 | 496 | 467 | 963 | ||||||||||||||||||||||||||||||||||
1807230 | 1807230 | CO | school | 804800 | 1420 | Jefferson County R-1 | 80480006489 | 109 | Arvada K-8 | Regular School | No | Elementary | KG | 08 | 2020 | pk_12_total | 204 | 27 | 380 | 8 | 8 | 3 | 22 | 345 | 307 | 652 | 204 | 27 | 380 | 8 | 8 | 3 | 22 | 345 | 307 | 652 | ||||||||||||||||||||||||||||||||||
1807319 | 1807319 | CO | school | 804800 | 1420 | Jefferson County R-1 | 80480001907 | 965 | Brady Exploration School | Alternative School | No | High | 09 | 12 | 2020 | grade_12 | 119 | 4 | 150 | 8 | 1 | 1 | 14 | 172 | 125 | 297 | 119 | 4 | 150 | 8 | 1 | 1 | 14 | 172 | 125 | 297 | ||||||||||||||||||||||||||||||||||
1807414 | 1807414 | CO | school | 804800 | 1420 | Jefferson County R-1 | 80480001542 | 1886 | Conifer Senior High School | Regular School | No | High | 09 | 12 | 2020 | pk_12_total | 759 | 1 | 61 | 8 | 14 | 2 | 28 | 447 | 426 | 873 | 759 | 1 | 61 | 8 | 14 | 2 | 28 | 447 | 426 | 873 | ||||||||||||||||||||||||||||||||||
1807664 | 1807664 | CO | school | 804800 | 1420 | Jefferson County R-1 | 80480001921 | 4404 | Jefferson Academy | Regular School | Yes | Other | KG | 12 | 2020 | pk_12_total | 822 | 8 | 110 | 8 | 23 | 1 | 79 | 517 | 534 | 1051 | 822 | 8 | 110 | 8 | 23 | 1 | 79 | 517 | 534 | 1051 | ||||||||||||||||||||||||||||||||||
1807894 | 1807894 | CO | school | 804800 | 1420 | Jefferson County R-1 | 80480001317 | 6090 | Moore Middle School | Regular School | No | Middle | 06 | 08 | 2020 | pk_12_total | 328 | 14 | 196 | 8 | 12 | 0 | 25 | 295 | 288 | 583 | 328 | 14 | 196 | 8 | 12 | 0 | 25 | 295 | 288 | 583 | ||||||||||||||||||||||||||||||||||
1808631 | 1808631 | CO | school | 803480 | 1520 | Durango 9-R | 80348000453 | 6222 | Needham Elementary School | Regular School | No | Elementary | PK | 05 | 2020 | kindergarten_full_day | 43 | 1 | 14 | 8 | 1 | 0 | 4 | 45 | 26 | 71 | 43 | 1 | 14 | 8 | 1 | 0 | 4 | 45 | 26 | 71 | ||||||||||||||||||||||||||||||||||
1808667 | 1808667 | CO | school | 802400 | 1530 | Bayfield 10 Jt-R | 80240000089 | 636 | Bayfield Middle School | Regular School | No | Middle | 06 | 08 | 2020 | grade_7 | 97 | 0 | 20 | 8 | 2 | 0 | 5 | 68 | 64 | 132 | 97 | 0 | 20 | 8 | 2 | 0 | 5 | 68 | 64 | 132 | ||||||||||||||||||||||||||||||||||
1808899 | 1808899 | CO | school | 803990 | 1550 | Poudre R-1 | 80399000536 | 5168 | Lincoln Middle School | Regular School | No | Middle | 06 | 08 | 2020 | pk_12_total | 281 | 9 | 279 | 8 | 5 | 1 | 24 | 323 | 284 | 607 | 281 | 9 | 279 | 8 | 5 | 1 | 24 | 323 | 284 | 607 | ||||||||||||||||||||||||||||||||||
1809260 | 1809260 | CO | school | 805400 | 1560 | Thompson R2-J | 80540001786 | 6163 | Mountain View High School | Regular School | No | High | 09 | 12 | 2020 | pk_12_total | 785 | 27 | 293 | 8 | 20 | 1 | 38 | 600 | 572 | 1172 | 785 | 27 | 293 | 8 | 20 | 1 | 38 | 600 | 572 | 1172 | ||||||||||||||||||||||||||||||||||
1809841 | 1809841 | CO | school | 804350 | 2000 | Mesa County Valley 51 | 80435000609 | 6070 | Fruita Monument High School | Regular School | No | High | 10 | 12 | 2020 | pk_12_total | 1084 | 4 | 169 | 8 | 17 | 4 | 48 | 693 | 641 | 1334 | 1084 | 4 | 169 | 8 | 17 | 4 | 48 | 693 | 641 | 1334 | ||||||||||||||||||||||||||||||||||
1810103 | 1810103 | CO | school | 805460 | 2070 | Mancos Re-6 | 80546000944 | 5452 | Mancos High School | Regular School | No | High | 09 | 12 | 2020 | pk_12_total | 102 | 1 | 19 | 8 | 1 | 0 | 7 | 73 | 65 | 138 | 102 | 1 | 19 | 8 | 1 | 0 | 7 | 73 | 65 | 138 | ||||||||||||||||||||||||||||||||||
1811734 | 1811734 | CO | school | 807350 | 3100 | Windsor RE-4 | 80735001264 | 9672 | Windsor High School | Regular School | No | High | 09 | 12 | 2020 | pk_12_total | 1093 | 8 | 220 | 8 | 15 | 0 | 33 | 693 | 684 | 1377 | 1093 | 8 | 220 | 8 | 15 | 0 | 33 | 693 | 684 | 1377 | ||||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||
1808694 | 1808694 | CO | school | 804770 | 1540 | Ignacio 11 JT | 80477000689 | 4258 | Ignacio High School | Regular School | No | High | 09 | 12 | 2020 | pk_12_total | 57 | 0 | 71 | 78 | 2 | 1 | 12 | 116 | 105 | 221 | 57 | 0 | 71 | 78 | 2 | 1 | 12 | 116 | 105 | 221 | ||||||||||||||||||||||||||||||||||
1799487 | 1799487 | CO | school | 806900 | 20 | Adams 12 Five Star Schools | 80690001172 | 210 | Vantage Point | Alternative School | No | High | 06 | 12 | 2020 | pk_12_total | 121 | 9 | 235 | 7 | 8 | 1 | 2 | 232 | 151 | 383 | 121 | 9 | 235 | 7 | 8 | 1 | 2 | 232 | 151 | 383 | ||||||||||||||||||||||||||||||||||
1799507 | 1799507 | CO | school | 806900 | 20 | Adams 12 Five Star Schools | 80690001620 | 1480 | Century Middle School | Regular School | No | Middle | 06 | 08 | 2020 | pk_12_total | 515 | 19 | 300 | 7 | 50 | 0 | 27 | 475 | 443 | 918 | 515 | 19 | 300 | 7 | 50 | 0 | 27 | 475 | 443 | 918 | ||||||||||||||||||||||||||||||||||
1799630 | 1799630 | CO | school | 806900 | 20 | Adams 12 Five Star Schools | 80690001179 | 4187 | Silver Hills Middle School | Regular School | No | Middle | 06 | 08 | 2020 | pk_12_total | 375 | 19 | 614 | 7 | 44 | 1 | 28 | 541 | 547 | 1088 | 375 | 19 | 614 | 7 | 44 | 1 | 28 | 541 | 547 | 1088 | ||||||||||||||||||||||||||||||||||
1799843 | 1799843 | CO | school | 806900 | 20 | Adams 12 Five Star Schools | 80690001196 | 9682 | Woodglen Elementary School | Regular School | No | Elementary | PK | 05 | 2020 | pk_12_total | 214 | 5 | 215 | 7 | 20 | 1 | 20 | 245 | 237 | 482 | 214 | 5 | 215 | 7 | 20 | 1 | 20 | 245 | 237 | 482 | ||||||||||||||||||||||||||||||||||
1799858 | 1799858 | CO | school | 801950 | 30 | Adams County 14 | 80195000010 | 24 | Adams City High School | Regular School | No | High | 09 | 12 | 2020 | pk_12_total | 140 | 33 | 1514 | 7 | 6 | 3 | 18 | 870 | 851 | 1721 | 140 | 33 | 1514 | 7 | 6 | 3 | 18 | 870 | 851 | 1721 | ||||||||||||||||||||||||||||||||||
1800215 | 1800215 | CO | school | 807230 | 70 | Westminster Public Schools | 80723001242 | 5834 | Mesa Elementary School | Regular School | No | Elementary | PK | 05 | 2020 | pk_12_total | 66 | 9 | 199 | 7 | 12 | 5 | 7 | 160 | 145 | 305 | 66 | 9 | 199 | 7 | 12 | 5 | 7 | 160 | 145 | 305 | ||||||||||||||||||||||||||||||||||
1800416 | 1800416 | CO | school | 802910 | 130 | Cherry Creek 5 | 80291006750 | 102 | Altitude Elementary School | Regular School | No | Elementary | PK | 05 | 2020 | pk_12_total | 500 | 36 | 112 | 7 | 67 | 3 | 54 | 397 | 382 | 779 | 500 | 36 | 112 | 7 | 67 | 3 | 54 | 397 | 382 | 779 | ||||||||||||||||||||||||||||||||||
1800500 | 1800500 | CO | school | 802910 | 130 | Cherry Creek 5 | 80291000185 | 1566 | Campus Middle School | Regular School | No | Middle | 06 | 08 | 2020 | pk_12_total | 923 | 46 | 179 | 7 | 246 | 3 | 112 | 792 | 724 | 1516 | 923 | 46 | 179 | 7 | 246 | 3 | 112 | 792 | 724 | 1516 | ||||||||||||||||||||||||||||||||||
1800574 | 1800574 | CO | school | 802910 | 130 | Cherry Creek 5 | 80291006156 | 2357 | Eaglecrest High School | Regular School | No | High | 09 | 12 | 2020 | grade_9 | 378 | 112 | 178 | 7 | 65 | 2 | 54 | 413 | 383 | 796 | 378 | 112 | 178 | 7 | 65 | 2 | 54 | 413 | 383 | 796 | ||||||||||||||||||||||||||||||||||
1800599 | 1800599 | CO | school | 802910 | 130 | Cherry Creek 5 | 80291001625 | 3589 | Grandview High School | Regular School | No | High | 09 | 12 | 2020 | grade_9 | 436 | 69 | 108 | 7 | 102 | 3 | 57 | 401 | 381 | 782 | 436 | 69 | 108 | 7 | 102 | 3 | 57 | 401 | 381 | 782 | ||||||||||||||||||||||||||||||||||
1800721 | 1800721 | CO | school | 802910 | 130 | Cherry Creek 5 | 80291001272 | 6625 | Overland High School | Regular School | No | High | 09 | 12 | 2020 | grade_10 | 123 | 196 | 251 | 7 | 25 | 3 | 37 | 339 | 303 | 642 | 123 | 196 | 251 | 7 | 25 | 3 | 37 | 339 | 303 | 642 | ||||||||||||||||||||||||||||||||||
1800755 | 1800755 | CO | school | 802910 | 130 | Cherry Creek 5 | 80291000200 | 7116 | Ponderosa Elementary School | Regular School | No | Elementary | PK | 05 | 2020 | pk_12_total | 128 | 174 | 219 | 7 | 35 | 2 | 53 | 336 | 282 | 618 | 128 | 174 | 219 | 7 | 35 | 2 | 53 | 336 | 282 | 618 | ||||||||||||||||||||||||||||||||||
1800758 | 1800758 | CO | school | 802910 | 130 | Cherry Creek 5 | 80291000201 | 7158 | Prairie Middle School | Regular School | No | Middle | 06 | 08 | 2020 | grade_8 | 116 | 164 | 240 | 7 | 15 | 1 | 33 | 299 | 277 | 576 | 116 | 164 | 240 | 7 | 15 | 1 | 33 | 299 | 277 | 576 | ||||||||||||||||||||||||||||||||||
1800788 | 1800788 | CO | school | 802910 | 130 | Cherry Creek 5 | 80291000203 | 8020 | Smoky Hill High School | Regular School | No | High | 09 | 12 | 2020 | grade_11 | 236 | 92 | 136 | 7 | 38 | 5 | 38 | 292 | 260 | 552 | 236 | 92 | 136 | 7 | 38 | 5 | 38 | 292 | 260 | 552 | ||||||||||||||||||||||||||||||||||
1801301 | 1801301 | CO | school | 802340 | 180 | Adams-Arapahoe 28J | 80234001881 | 6189 | Murphy Creek K-8 School | Regular School | No | Elementary | PK | 08 | 2020 | pk_12_total | 268 | 104 | 238 | 7 | 37 | 0 | 70 | 363 | 361 | 724 | 268 | 104 | 238 | 7 | 37 | 0 | 70 | 363 | 361 | 724 | ||||||||||||||||||||||||||||||||||
1801545 | 1801545 | CO | school | 802700 | 190 | Byers 32J | 80270006630 | 6241 | Colorado Virtual Academy | Regular School | Yes | Elementary | KG | 06 | 2020 | pk_12_total | 151 | 16 | 55 | 7 | 8 | 0 | 0 | 118 | 119 | 237 | 151 | 16 | 55 | 7 | 8 | 0 | 0 | 118 | 119 | 237 | ||||||||||||||||||||||||||||||||||
1801988 | 1801988 | CO | school | 805370 | 470 | St Vrain Valley RE1J | 80537006594 | 6010 | Timberline PK-8 | Regular School | No | Elementary | PK | 08 | 2020 | pk_12_total | 98 | 9 | 770 | 7 | 4 | 2 | 8 | 465 | 433 | 898 | 98 | 9 | 770 | 7 | 4 | 2 | 8 | 465 | 433 | 898 | ||||||||||||||||||||||||||||||||||
1803025 | 1803025 | CO | school | 803360 | 880 | Denver County 1 | 80336001862 | 1748 | Colorado High School Charter | Alternative School | Yes | High | 09 | 12 | 2020 | pk_12_total | 11 | 74 | 180 | 7 | 1 | 1 | 9 | 156 | 127 | 283 | 11 | 74 | 180 | 7 | 1 | 1 | 9 | 156 | 127 | 283 | ||||||||||||||||||||||||||||||||||
1803264 | 1803264 | CO | school | 803360 | 880 | Denver County 1 | 80336000337 | 2364 | Eagleton Elementary School | Regular School | No | Elementary | PK | 05 | 2020 | pk_12_total | 19 | 10 | 264 | 7 | 4 | 0 | 5 | 158 | 151 | 309 | 19 | 10 | 264 | 7 | 4 | 0 | 5 | 158 | 151 | 309 | ||||||||||||||||||||||||||||||||||
1803723 | 1803723 | CO | school | 803360 | 880 | Denver County 1 | 80336006562 | 5897 | McAuliffe International School | Regular School | No | Middle | 06 | 08 | 2020 | pk_12_total | 1021 | 184 | 215 | 7 | 34 | 1 | 127 | 854 | 735 | 1589 | 1021 | 184 | 215 | 7 | 34 | 1 | 127 | 854 | 735 | 1589 | ||||||||||||||||||||||||||||||||||
1803846 | 1803846 | CO | school | 803360 | 880 | Denver County 1 | 80336000391 | 6754 | Park Hill School | Regular School | No | Elementary | PK | 05 | 2020 | pk_12_total | 538 | 50 | 75 | 7 | 8 | 2 | 40 | 346 | 374 | 720 | 538 | 50 | 75 | 7 | 8 | 2 | 40 | 346 | 374 | 720 | ||||||||||||||||||||||||||||||||||
1804000 | 1804000 | CO | school | 803360 | 880 | Denver County 1 | 80336000408 | 8086 | South High School | Regular School | No | High | 09 | 12 | 2020 | grade_9 | 254 | 61 | 151 | 7 | 35 | 1 | 18 | 251 | 276 | 527 | 254 | 61 | 151 | 7 | 35 | 1 | 18 | 251 | 276 | 527 | ||||||||||||||||||||||||||||||||||
1804098 | 1804098 | CO | school | 803360 | 880 | Denver County 1 | 80336000417 | 8822 | Thomas Jefferson High School | Regular School | No | High | 09 | 12 | 2020 | pk_12_total | 458 | 208 | 434 | 7 | 50 | 2 | 76 | 655 | 580 | 1235 | 458 | 208 | 434 | 7 | 50 | 2 | 76 | 655 | 580 | 1235 | ||||||||||||||||||||||||||||||||||
1804873 | 1804873 | CO | school | 803450 | 900 | Douglas County Re 1 | 80345001962 | 7448 | Rocky Heights Middle School | Regular School | No | Middle | 06 | 08 | 2020 | pk_12_total | 1058 | 9 | 130 | 7 | 89 | 1 | 52 | 691 | 655 | 1346 | 1058 | 9 | 130 | 7 | 89 | 1 | 52 | 691 | 655 | 1346 | ||||||||||||||||||||||||||||||||||
1804936 | 1804936 | CO | school | 803450 | 900 | Douglas County Re 1 | 80345001529 | 8847 | Thunderridge High School | Regular School | No | High | 09 | 12 | 2020 | pk_12_total | 1560 | 17 | 243 | 7 | 97 | 4 | 114 | 1036 | 1006 | 2042 | 1560 | 17 | 243 | 7 | 97 | 4 | 114 | 1036 | 1006 | 2042 | ||||||||||||||||||||||||||||||||||
1805014 | 1805014 | CO | school | 803540 | 910 | Eagle County RE 50 | 80354001531 | 793 | Berry Creek Middle School | Regular School | No | Middle | 06 | 08 | 2020 | pk_12_total | 60 | 1 | 208 | 7 | 2 | 0 | 2 | 140 | 140 | 280 | 60 | 1 | 208 | 7 | 2 | 0 | 2 | 140 | 140 | 280 | ||||||||||||||||||||||||||||||||||
1805479 | 1805479 | CO | school | 806480 | 990 | Widefield 3 | 80648001126 | 9294 | Watson Junior High School | Regular School | No | Middle | 06 | 08 | 2020 | grade_8 | 73 | 18 | 45 | 7 | 2 | 0 | 24 | 89 | 80 | 169 | 73 | 18 | 45 | 7 | 2 | 0 | 24 | 89 | 80 | 169 | ||||||||||||||||||||||||||||||||||
1805548 | 1805548 | CO | school | 804080 | 1000 | Fountain 8 | 80408000564 | 3108 | Mesa Elementary School | Regular School | No | Elementary | KG | 05 | 2020 | pk_12_total | 301 | 31 | 109 | 7 | 6 | 9 | 61 | 269 | 255 | 524 | 301 | 31 | 109 | 7 | 6 | 9 | 61 | 269 | 255 | 524 | ||||||||||||||||||||||||||||||||||
1805566 | 1805566 | CO | school | 804080 | 1000 | Fountain 8 | 80408000856 | 6138 | Mountainside Elementary School | Regular School | No | Elementary | KG | 05 | 2020 | kindergarten_full_day | 47 | 11 | 25 | 7 | 0 | 0 | 13 | 54 | 49 | 103 | 47 | 11 | 25 | 7 | 0 | 0 | 13 | 54 | 49 | 103 | ||||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||
1806682 | 1806682 | CO | school | 803870 | 1110 | District 49 | 80387001799 | 7960 | Skyview Middle School | Regular School | No | Middle | 06 | 08 | 2020 | pk_12_total | 559 | 71 | 260 | 7 | 43 | 2 | 116 | 570 | 488 | 1058 | 559 | 71 | 260 | 7 | 43 | 2 | 116 | 570 | 488 | 1058 |
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]);