enrollments
Data source: Big Local News · About: Big Local
13,321 rows where state = "CO" and year = 2020 sorted by hispanic 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1800808 | 1800808 | CO | school | 802910 | 130 | Cherry Creek 5 | 80291000034 | 8848 | Thunder Ridge Middle School | Regular School | No | Middle | 06 | 08 | 2020 | grade_6 | 207 | 39 | 99 | 2 | 24 | 1 | 24 | 197 | 199 | 396 | 207 | 39 | 99 | 2 | 24 | 1 | 24 | 197 | 199 | 396 | ||||||||||||||||||||||||||||||||||
1800889 | 1800889 | CO | school | 805310 | 140 | Littleton 6 | 80531000879 | 3472 | Goddard Middle School | Regular School | No | Middle | 06 | 08 | 2020 | grade_8 | 125 | 4 | 99 | 4 | 8 | 0 | 14 | 126 | 128 | 254 | 125 | 4 | 99 | 4 | 8 | 0 | 14 | 126 | 128 | 254 | ||||||||||||||||||||||||||||||||||
1801278 | 1801278 | CO | school | 802340 | 180 | Adams-Arapahoe 28J | 80234006495 | 5751 | Meadowood Child Development Center | Regular School | No | Prekindergarten | PK | PK | 2020 | pk_12_total | 54 | 56 | 99 | 0 | 16 | 0 | 52 | 158 | 119 | 277 | 54 | 56 | 99 | 0 | 16 | 0 | 52 | 158 | 119 | 277 | ||||||||||||||||||||||||||||||||||
1801279 | 1801279 | CO | school | 802340 | 180 | Adams-Arapahoe 28J | 80234006495 | 5751 | Meadowood Child Development Center | Regular School | No | Prekindergarten | PK | PK | 2020 | pre_kindergarten | 54 | 56 | 99 | 0 | 16 | 0 | 52 | 158 | 119 | 277 | 54 | 56 | 99 | 0 | 16 | 0 | 52 | 158 | 119 | 277 | ||||||||||||||||||||||||||||||||||
1801944 | 1801944 | CO | school | 805370 | 470 | St Vrain Valley RE1J | 80537000910 | 5288 | Longs Peak Middle School | Regular School | No | Middle | 05 | 08 | 2020 | grade_8 | 41 | 2 | 99 | 2 | 3 | 0 | 3 | 80 | 70 | 150 | 41 | 2 | 99 | 2 | 3 | 0 | 3 | 80 | 70 | 150 | ||||||||||||||||||||||||||||||||||
1803130 | 1803130 | CO | school | 803360 | 880 | Denver County 1 | 80336006450 | 2145 | DSST: Green Valley Ranch High School | Regular School | Yes | High | 09 | 12 | 2020 | grade_9 | 7 | 34 | 99 | 0 | 18 | 0 | 3 | 77 | 84 | 161 | 7 | 34 | 99 | 0 | 18 | 0 | 3 | 77 | 84 | 161 | ||||||||||||||||||||||||||||||||||
1803151 | 1803151 | CO | school | 803360 | 880 | Denver County 1 | 80336006636 | 2175 | DSST: Cole High School | Regular School | Yes | High | 09 | 12 | 2020 | grade_9 | 4 | 21 | 99 | 0 | 0 | 0 | 1 | 67 | 58 | 125 | 4 | 21 | 99 | 0 | 0 | 0 | 1 | 67 | 58 | 125 | ||||||||||||||||||||||||||||||||||
1803213 | 1803213 | CO | school | 803360 | 880 | Denver County 1 | 80336006528 | 2209 | DCIS at Montbello | Regular School | No | High | 06 | 12 | 2020 | grade_11 | 0 | 7 | 99 | 1 | 4 | 0 | 3 | 50 | 64 | 114 | 0 | 7 | 99 | 1 | 4 | 0 | 3 | 50 | 64 | 114 | ||||||||||||||||||||||||||||||||||
1804207 | 1804207 | CO | school | 803360 | 880 | Denver County 1 | 80336006547 | 9702 | West Leadership Academy | Regular School | No | High | 06 | 12 | 2020 | grade_10 | 4 | 9 | 99 | 0 | 4 | 0 | 2 | 55 | 63 | 118 | 4 | 9 | 99 | 0 | 4 | 0 | 2 | 55 | 63 | 118 | ||||||||||||||||||||||||||||||||||
1804289 | 1804289 | CO | school | 803450 | 900 | Douglas County Re 1 | 80345006492 | 135 | Ben Franklin Academy | Regular School | Yes | Elementary | PK | 08 | 2020 | pk_12_total | 718 | 11 | 99 | 5 | 53 | 1 | 43 | 475 | 455 | 930 | 718 | 11 | 99 | 5 | 53 | 1 | 43 | 475 | 455 | 930 | ||||||||||||||||||||||||||||||||||
1805449 | 1805449 | CO | school | 806480 | 990 | Widefield 3 | 80648001588 | 5841 | Mesa Ridge High School | Regular School | No | High | 09 | 12 | 2020 | grade_12 | 144 | 35 | 99 | 3 | 4 | 4 | 27 | 174 | 142 | 316 | 144 | 35 | 99 | 3 | 4 | 4 | 27 | 174 | 142 | 316 | ||||||||||||||||||||||||||||||||||
1805899 | 1805899 | CO | school | 803060 | 1010 | Colorado Springs 11 | 80306000234 | 7556 | Sabin Middle School | Regular School | No | Middle | 06 | 08 | 2020 | grade_6 | 125 | 17 | 99 | 0 | 4 | 1 | 32 | 148 | 130 | 278 | 125 | 17 | 99 | 0 | 4 | 1 | 32 | 148 | 130 | 278 | ||||||||||||||||||||||||||||||||||
1811729 | 1811729 | CO | school | 807350 | 3100 | Windsor RE-4 | 80735001265 | 9670 | Windsor Middle School | Regular School | No | Middle | 06 | 08 | 2020 | pk_12_total | 607 | 4 | 99 | 0 | 5 | 0 | 18 | 398 | 335 | 733 | 607 | 4 | 99 | 0 | 5 | 0 | 18 | 398 | 335 | 733 | ||||||||||||||||||||||||||||||||||
1812029 | 1812029 | CO | school | 804950 | 3130 | Platte Valley RE-7 | 80495001697 | 7054 | Platte Valley Middle School | Regular School | No | Middle | 06 | 08 | 2020 | pk_12_total | 150 | 0 | 99 | 0 | 0 | 0 | 1 | 138 | 112 | 250 | 150 | 0 | 99 | 0 | 0 | 0 | 1 | 138 | 112 | 250 | ||||||||||||||||||||||||||||||||||
1812270 | 1812270 | CO | school | 800020 | 8001 | Charter School Institute | 80002006305 | 1279 | Caprock Academy | Regular School | Yes | Other | KG | 12 | 2020 | pk_12_total | 711 | 5 | 99 | 0 | 21 | 1 | 41 | 422 | 456 | 878 | 711 | 5 | 99 | 0 | 21 | 1 | 41 | 422 | 456 | 878 | ||||||||||||||||||||||||||||||||||
1801367 | 1801367 | CO | school | 802340 | 180 | Adams-Arapahoe 28J | 80234001389 | 7250 | Rangeview High School | Regular School | No | High | 09 | 12 | 2020 | pk_12_total | 531 | 446 | 983 | 13 | 128 | 13 | 139 | 1171 | 1082 | 2253 | 531 | 446 | 983 | 13 | 128 | 13 | 139 | 1171 | 1082 | 2253 | ||||||||||||||||||||||||||||||||||
1800638 | 1800638 | CO | school | 802910 | 130 | Cherry Creek 5 | 80291001328 | 4100 | Horizon Middle School | Regular School | No | Middle | 06 | 08 | 2020 | grade_8 | 135 | 45 | 98 | 2 | 10 | 2 | 19 | 162 | 149 | 311 | 135 | 45 | 98 | 2 | 10 | 2 | 19 | 162 | 149 | 311 | ||||||||||||||||||||||||||||||||||
1800679 | 1800679 | CO | school | 802910 | 130 | Cherry Creek 5 | 80291000197 | 4975 | Laredo Middle School | Regular School | No | Middle | 06 | 08 | 2020 | grade_8 | 179 | 45 | 98 | 5 | 19 | 3 | 24 | 181 | 192 | 373 | 179 | 45 | 98 | 5 | 19 | 3 | 24 | 181 | 192 | 373 | ||||||||||||||||||||||||||||||||||
1801876 | 1801876 | CO | school | 805370 | 470 | St Vrain Valley RE1J | 80537000902 | 3196 | Frederick Senior High School | Regular School | No | High | 09 | 12 | 2020 | grade_10 | 204 | 1 | 98 | 1 | 3 | 0 | 4 | 168 | 143 | 311 | 204 | 1 | 98 | 1 | 3 | 0 | 4 | 168 | 143 | 311 | ||||||||||||||||||||||||||||||||||
1801943 | 1801943 | CO | school | 805370 | 470 | St Vrain Valley RE1J | 80537000910 | 5288 | Longs Peak Middle School | Regular School | No | Middle | 05 | 08 | 2020 | grade_7 | 29 | 0 | 98 | 1 | 2 | 0 | 2 | 57 | 75 | 132 | 29 | 0 | 98 | 1 | 2 | 0 | 2 | 57 | 75 | 132 | ||||||||||||||||||||||||||||||||||
1803192 | 1803192 | CO | school | 803360 | 880 | Denver County 1 | 80336006746 | 2190 | DSST Middle School @ Noel Campus | Regular School | Yes | Middle | 06 | 07 | 2020 | grade_6 | 10 | 32 | 98 | 0 | 2 | 1 | 7 | 71 | 79 | 150 | 10 | 32 | 98 | 0 | 2 | 1 | 7 | 71 | 79 | 150 | ||||||||||||||||||||||||||||||||||
1803789 | 1803789 | CO | school | 803360 | 880 | Denver County 1 | 80336001869 | 6350 | Bruce Randolph School | Regular School | No | High | 06 | 12 | 2020 | grade_7 | 4 | 13 | 98 | 1 | 1 | 0 | 3 | 56 | 64 | 120 | 4 | 13 | 98 | 1 | 1 | 0 | 3 | 56 | 64 | 120 | ||||||||||||||||||||||||||||||||||
1803831 | 1803831 | CO | school | 803360 | 880 | Denver County 1 | 80336001955 | 6509 | Denver Online High School | Regular School | No | High | 09 | 12 | 2020 | pk_12_total | 139 | 21 | 98 | 2 | 9 | 1 | 17 | 115 | 172 | 287 | 139 | 21 | 98 | 2 | 9 | 1 | 17 | 115 | 172 | 287 | ||||||||||||||||||||||||||||||||||
1804722 | 1804722 | CO | school | 803450 | 900 | Douglas County Re 1 | 80345006588 | 6019 | Aspen View Academy | Regular School | Yes | Elementary | PK | 08 | 2020 | pk_12_total | 742 | 2 | 98 | 3 | 14 | 0 | 45 | 464 | 440 | 904 | 742 | 2 | 98 | 3 | 14 | 0 | 45 | 464 | 440 | 904 | ||||||||||||||||||||||||||||||||||
1805674 | 1805674 | CO | school | 803060 | 1010 | Colorado Springs 11 | 80306000228 | 1870 | Coronado High School | Regular School | No | High | 09 | 12 | 2020 | grade_9 | 244 | 25 | 98 | 5 | 1 | 0 | 20 | 207 | 186 | 393 | 244 | 25 | 98 | 5 | 1 | 0 | 20 | 207 | 186 | 393 | ||||||||||||||||||||||||||||||||||
1805993 | 1805993 | CO | school | 802940 | 1020 | Cheyenne Mountain 12 | 80294000209 | 1588 | Cheyenne Mountain Junior High School | Regular School | No | Middle | 07 | 08 | 2020 | pk_12_total | 429 | 11 | 98 | 1 | 13 | 1 | 44 | 299 | 298 | 597 | 429 | 11 | 98 | 1 | 13 | 1 | 44 | 299 | 298 | 597 | ||||||||||||||||||||||||||||||||||
1807256 | 1807256 | CO | school | 804800 | 1420 | Jefferson County R-1 | 80480006643 | 491 | Addenbrooke Classical Grammar School | Regular School | Yes | Elementary | PK | 05 | 2020 | pk_12_total | 321 | 6 | 98 | 1 | 7 | 0 | 16 | 197 | 252 | 449 | 321 | 6 | 98 | 1 | 7 | 0 | 16 | 197 | 252 | 449 | ||||||||||||||||||||||||||||||||||
1811802 | 1811802 | CO | school | 804410 | 3120 | Greeley 6 | 80441001990 | 54 | Bella Romero Academy of Applied Technology | Regular School | No | Elementary | KG | 08 | 2020 | kindergarten_full_day | 21 | 15 | 98 | 0 | 2 | 0 | 1 | 74 | 63 | 137 | 21 | 15 | 98 | 0 | 2 | 0 | 1 | 74 | 63 | 137 | ||||||||||||||||||||||||||||||||||
1799482 | 1799482 | CO | school | 806900 | 20 | Adams 12 Five Star Schools | 80690001172 | 210 | Vantage Point | Alternative School | No | High | 06 | 12 | 2020 | grade_11 | 42 | 2 | 97 | 1 | 1 | 0 | 0 | 90 | 53 | 143 | 42 | 2 | 97 | 1 | 1 | 0 | 0 | 90 | 53 | 143 | ||||||||||||||||||||||||||||||||||
1799782 | 1799782 | CO | school | 806900 | 20 | Adams 12 Five Star Schools | 80690006561 | 8310 | STEM Launch | Regular School | No | Elementary | KG | 08 | 2020 | grade_8 | 27 | 0 | 97 | 1 | 2 | 0 | 0 | 75 | 52 | 127 | 27 | 0 | 97 | 1 | 2 | 0 | 0 | 75 | 52 | 127 | ||||||||||||||||||||||||||||||||||
1800732 | 1800732 | CO | school | 802910 | 130 | Cherry Creek 5 | 80291006183 | 6820 | Peakview Elementary School | Regular School | No | Elementary | PK | 05 | 2020 | pk_12_total | 348 | 37 | 97 | 0 | 31 | 5 | 54 | 292 | 280 | 572 | 348 | 37 | 97 | 0 | 31 | 5 | 54 | 292 | 280 | 572 | ||||||||||||||||||||||||||||||||||
1802183 | 1802183 | CO | school | 802490 | 480 | Boulder Valley Re 2 | 80249000107 | 1380 | Centaurus High School | Regular School | No | High | 09 | 12 | 2020 | grade_12 | 189 | 5 | 97 | 1 | 12 | 0 | 9 | 182 | 131 | 313 | 189 | 5 | 97 | 1 | 12 | 0 | 9 | 182 | 131 | 313 | ||||||||||||||||||||||||||||||||||
1803225 | 1803225 | CO | school | 803360 | 880 | Denver County 1 | 80336006523 | 2223 | DSST: Cole Middle School | Regular School | Yes | Middle | 06 | 08 | 2020 | grade_7 | 5 | 16 | 97 | 2 | 0 | 0 | 3 | 56 | 67 | 123 | 5 | 16 | 97 | 2 | 0 | 0 | 3 | 56 | 67 | 123 | ||||||||||||||||||||||||||||||||||
1803244 | 1803244 | CO | school | 803360 | 880 | Denver County 1 | 80336006658 | 2244 | DSST: College View High School | Regular School | Yes | High | 09 | 12 | 2020 | grade_12 | 4 | 2 | 97 | 0 | 8 | 0 | 1 | 56 | 56 | 112 | 4 | 2 | 97 | 0 | 8 | 0 | 1 | 56 | 56 | 112 | ||||||||||||||||||||||||||||||||||
1803688 | 1803688 | CO | school | 803360 | 880 | Denver County 1 | 80336001276 | 5685 | McGlone Academy | Regular School | No | Elementary | PK | 08 | 2020 | grade_5 | 2 | 9 | 97 | 0 | 0 | 6 | 2 | 66 | 50 | 116 | 2 | 9 | 97 | 0 | 0 | 6 | 2 | 66 | 50 | 116 | ||||||||||||||||||||||||||||||||||
1804151 | 1804151 | CO | school | 803360 | 880 | Denver County 1 | 80336006444 | 9389 | STRIVE Prep - Westwood | Regular School | Yes | Middle | 06 | 08 | 2020 | grade_8 | 1 | 2 | 97 | 1 | 5 | 0 | 0 | 63 | 43 | 106 | 1 | 2 | 97 | 1 | 5 | 0 | 0 | 63 | 43 | 106 | ||||||||||||||||||||||||||||||||||
1804155 | 1804155 | CO | school | 803360 | 880 | Denver County 1 | 80336006479 | 9390 | STRIVE Prep - Lake | Regular School | Yes | Middle | 06 | 08 | 2020 | grade_8 | 2 | 7 | 97 | 0 | 0 | 0 | 0 | 60 | 46 | 106 | 2 | 7 | 97 | 0 | 0 | 0 | 0 | 60 | 46 | 106 | ||||||||||||||||||||||||||||||||||
1804371 | 1804371 | CO | school | 803450 | 900 | Douglas County Re 1 | 80345001918 | 1367 | Castle View High School | Regular School | No | High | 09 | 12 | 2020 | grade_9 | 419 | 3 | 97 | 3 | 18 | 1 | 20 | 285 | 276 | 561 | 419 | 3 | 97 | 3 | 18 | 1 | 20 | 285 | 276 | 561 | ||||||||||||||||||||||||||||||||||
1805671 | 1805671 | CO | school | 803060 | 1010 | Colorado Springs 11 | 80306000228 | 1870 | Coronado High School | Regular School | No | High | 09 | 12 | 2020 | grade_10 | 195 | 13 | 97 | 4 | 9 | 0 | 16 | 173 | 161 | 334 | 195 | 13 | 97 | 4 | 9 | 0 | 16 | 173 | 161 | 334 | ||||||||||||||||||||||||||||||||||
1806681 | 1806681 | CO | school | 803870 | 1110 | District 49 | 80387001799 | 7960 | Skyview Middle School | Regular School | No | Middle | 06 | 08 | 2020 | grade_8 | 201 | 27 | 97 | 1 | 15 | 1 | 38 | 216 | 164 | 380 | 201 | 27 | 97 | 1 | 15 | 1 | 38 | 216 | 164 | 380 | ||||||||||||||||||||||||||||||||||
1806911 | 1806911 | CO | school | 804260 | 1180 | Roaring Fork RE-1 | 80426000588 | 3468 | Glenwood Springs High School | Regular School | No | High | 09 | 12 | 2020 | grade_12 | 95 | 1 | 97 | 1 | 4 | 0 | 7 | 111 | 94 | 205 | 95 | 1 | 97 | 1 | 4 | 0 | 7 | 111 | 94 | 205 | ||||||||||||||||||||||||||||||||||
1807207 | 1807207 | CO | school | 804800 | 1420 | Jefferson County R-1 | 80480001446 | 30 | Adams Elementary School | Regular School | No | Elementary | PK | 05 | 2020 | pk_12_total | 225 | 14 | 97 | 1 | 25 | 0 | 19 | 208 | 173 | 381 | 225 | 14 | 97 | 1 | 25 | 0 | 19 | 208 | 173 | 381 | ||||||||||||||||||||||||||||||||||
1808012 | 1808012 | CO | school | 804800 | 1420 | Jefferson County R-1 | 80480000775 | 7114 | Pomona High School | Regular School | No | High | 09 | 12 | 2020 | grade_11 | 169 | 8 | 97 | 1 | 7 | 1 | 11 | 140 | 154 | 294 | 169 | 8 | 97 | 1 | 7 | 1 | 11 | 140 | 154 | 294 | ||||||||||||||||||||||||||||||||||
1811185 | 1811185 | CO | school | 806660 | 2770 | Steamboat Springs RE-2 | 80666001360 | 8358 | Strawberry Park Elementary School | Regular School | No | Elementary | KG | 05 | 2020 | pk_12_total | 355 | 6 | 97 | 2 | 1 | 0 | 17 | 238 | 240 | 478 | 355 | 6 | 97 | 2 | 1 | 0 | 17 | 238 | 240 | 478 | ||||||||||||||||||||||||||||||||||
1811413 | 1811413 | CO | school | 806810 | 3000 | Summit RE-1 | 80681001164 | 8378 | Summit High School | Regular School | No | High | 09 | 12 | 2020 | grade_9 | 147 | 2 | 97 | 0 | 1 | 0 | 3 | 146 | 104 | 250 | 147 | 2 | 97 | 0 | 1 | 0 | 3 | 146 | 104 | 250 | ||||||||||||||||||||||||||||||||||
1811604 | 1811604 | CO | school | 803600 | 3085 | Eaton RE-2 | 80360000474 | 2448 | Eaton Elementary School | Regular School | No | Elementary | PK | 02 | 2020 | pk_12_total | 304 | 3 | 97 | 2 | 1 | 1 | 6 | 228 | 186 | 414 | 304 | 3 | 97 | 2 | 1 | 1 | 6 | 228 | 186 | 414 | ||||||||||||||||||||||||||||||||||
1812475 | 1812475 | CO | school | 800020 | 8001 | Charter School Institute | 80002001915 | 6914 | The Pinnacle Charter School | Regular School | Yes | Other | KG | 12 | 2020 | grade_12 | 22 | 1 | 97 | 0 | 6 | 0 | 1 | 50 | 77 | 127 | 22 | 1 | 97 | 0 | 6 | 0 | 1 | 50 | 77 | 127 | ||||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||
1799326 | 1799326 | CO | school | 805550 | 10 | Mapleton 1 | 80555001872 | 309 | Academy High School | Regular School | No | High | 09 | 12 | 2020 | grade_11 | 7 | 2 | 96 | 0 | 2 | 0 | 3 | 58 | 52 | 110 | 7 | 2 | 96 | 0 | 2 | 0 | 3 | 58 | 52 | 110 | ||||||||||||||||||||||||||||||||||
1800113 | 1800113 | CO | school | 802430 | 50 | Bennett 29J | 80243000091 | 770 | Bennett Elementary School | Regular School | No | Elementary | KG | 03 | 2020 | pk_12_total | 162 | 2 | 96 | 0 | 0 | 2 | 17 | 147 | 132 | 279 | 162 | 2 | 96 | 0 | 0 | 2 | 17 | 147 | 132 | 279 | ||||||||||||||||||||||||||||||||||
1800404 | 1800404 | CO | school | 802910 | 130 | Cherry Creek 5 | 80291001710 | 16 | Fox Hollow Elementary School | Regular School | No | Elementary | PK | 05 | 2020 | pk_12_total | 375 | 46 | 96 | 4 | 91 | 0 | 45 | 341 | 316 | 657 | 375 | 46 | 96 | 4 | 91 | 0 | 45 | 341 | 316 | 657 | ||||||||||||||||||||||||||||||||||
1800587 | 1800587 | CO | school | 802910 | 130 | Cherry Creek 5 | 80291006649 | 2653 | Endeavor Academy | Alternative School | No | High | 09 | 12 | 2020 | pk_12_total | 128 | 36 | 96 | 2 | 6 | 2 | 13 | 172 | 111 | 283 | 128 | 36 | 96 | 2 | 6 | 2 | 13 | 172 | 111 | 283 | ||||||||||||||||||||||||||||||||||
1802179 | 1802179 | CO | school | 802490 | 480 | Boulder Valley Re 2 | 80249000106 | 1352 | Casey Middle School | Regular School | No | Middle | 06 | 08 | 2020 | grade_8 | 132 | 0 | 96 | 1 | 9 | 0 | 10 | 122 | 126 | 248 | 132 | 0 | 96 | 1 | 9 | 0 | 10 | 122 | 126 | 248 | ||||||||||||||||||||||||||||||||||
1803064 | 1803064 | CO | school | 803360 | 880 | Denver County 1 | 80336000330 | 1846 | Columbine Elementary School | Regular School | No | Elementary | PK | 05 | 2020 | pk_12_total | 66 | 100 | 96 | 3 | 4 | 0 | 6 | 146 | 129 | 275 | 66 | 100 | 96 | 3 | 4 | 0 | 6 | 146 | 129 | 275 | ||||||||||||||||||||||||||||||||||
1803563 | 1803563 | CO | school | 803360 | 880 | Denver County 1 | 80336006670 | 4509 | KIPP Northeast Denver Leadership Academy | Regular School | Yes | High | 09 | 12 | 2020 | grade_11 | 6 | 17 | 96 | 0 | 7 | 0 | 0 | 54 | 72 | 126 | 6 | 17 | 96 | 0 | 7 | 0 | 0 | 54 | 72 | 126 | ||||||||||||||||||||||||||||||||||
1804057 | 1804057 | CO | school | 803360 | 880 | Denver County 1 | 80336006576 | 8347 | STRIVE Prep - Excel | Regular School | Yes | High | 09 | 12 | 2020 | grade_9 | 0 | 2 | 96 | 2 | 0 | 0 | 0 | 59 | 41 | 100 | 0 | 2 | 96 | 2 | 0 | 0 | 0 | 59 | 41 | 100 | ||||||||||||||||||||||||||||||||||
1804163 | 1804163 | CO | school | 803360 | 880 | Denver County 1 | 80336001957 | 9425 | Westerly Creek Elementary | Regular School | No | Elementary | PK | 05 | 2020 | pk_12_total | 502 | 40 | 96 | 4 | 26 | 0 | 53 | 347 | 374 | 721 | 502 | 40 | 96 | 4 | 26 | 0 | 53 | 347 | 374 | 721 | ||||||||||||||||||||||||||||||||||
1804608 | 1804608 | CO | school | 803450 | 900 | Douglas County Re 1 | 80345006391 | 3995 | HOPE Online Learning Academy High School | Regular School | Yes | High | 09 | 12 | 2020 | grade_11 | 34 | 9 | 96 | 0 | 1 | 0 | 4 | 70 | 74 | 144 | 34 | 9 | 96 | 0 | 1 | 0 | 4 | 70 | 74 | 144 | ||||||||||||||||||||||||||||||||||
1804848 | 1804848 | CO | school | 803450 | 900 | Douglas County Re 1 | 80345001528 | 7245 | Ranch View Middle School | Regular School | No | Middle | 07 | 08 | 2020 | pk_12_total | 635 | 5 | 96 | 6 | 20 | 0 | 33 | 414 | 381 | 795 | 635 | 5 | 96 | 6 | 20 | 0 | 33 | 414 | 381 | 795 | ||||||||||||||||||||||||||||||||||
1804964 | 1804964 | CO | school | 803450 | 900 | Douglas County Re 1 | 80345006666 | 9397 | World Compass Academy | Regular School | Yes | Elementary | PK | 08 | 2020 | pk_12_total | 440 | 10 | 96 | 0 | 24 | 1 | 48 | 307 | 312 | 619 | 440 | 10 | 96 | 0 | 24 | 1 | 48 | 307 | 312 | 619 | ||||||||||||||||||||||||||||||||||
1805267 | 1805267 | CO | school | 804530 | 980 | Harrison 2 | 80453000666 | 3522 | Fox Meadow Middle School | Regular School | No | Middle | 06 | 08 | 2020 | grade_6 | 56 | 32 | 96 | 2 | 4 | 0 | 18 | 110 | 98 | 208 | 56 | 32 | 96 | 2 | 4 | 0 | 18 | 110 | 98 | 208 | ||||||||||||||||||||||||||||||||||
1805361 | 1805361 | CO | school | 804530 | 980 | Harrison 2 | 80453001382 | 7882 | Sierra High School | Regular School | No | High | 09 | 12 | 2020 | grade_11 | 31 | 41 | 96 | 1 | 8 | 4 | 18 | 102 | 97 | 199 | 31 | 41 | 96 | 1 | 8 | 4 | 18 | 102 | 97 | 199 | ||||||||||||||||||||||||||||||||||
1805540 | 1805540 | CO | school | 804080 | 1000 | Fountain 8 | 80408000563 | 3106 | Fountain Middle School | Regular School | No | Middle | 06 | 08 | 2020 | grade_8 | 168 | 36 | 96 | 2 | 3 | 3 | 30 | 178 | 160 | 338 | 168 | 36 | 96 | 2 | 3 | 3 | 30 | 178 | 160 | 338 | ||||||||||||||||||||||||||||||||||
1806982 | 1806982 | CO | school | 806240 | 1195 | Garfield Re-2 | 80624001097 | 7360 | Rifle High School | Regular School | No | High | 09 | 12 | 2020 | grade_10 | 82 | 0 | 96 | 0 | 1 | 0 | 3 | 89 | 93 | 182 | 82 | 0 | 96 | 0 | 1 | 0 | 3 | 89 | 93 | 182 | ||||||||||||||||||||||||||||||||||
1807372 | 1807372 | CO | school | 804800 | 1420 | Jefferson County R-1 | 80480000707 | 1864 | Columbine High School | Regular School | No | High | 09 | 12 | 2020 | grade_10 | 334 | 6 | 96 | 0 | 16 | 0 | 14 | 222 | 244 | 466 | 334 | 6 | 96 | 0 | 16 | 0 | 14 | 222 | 244 | 466 | ||||||||||||||||||||||||||||||||||
1810883 | 1810883 | CO | school | 806150 | 2700 | Pueblo County 70 | 80615001069 | 472 | Avondale Elementary School | Regular School | No | Elementary | PK | 05 | 2020 | pk_12_total | 66 | 0 | 96 | 0 | 0 | 0 | 8 | 87 | 83 | 170 | 66 | 0 | 96 | 0 | 0 | 0 | 8 | 87 | 83 | 170 | ||||||||||||||||||||||||||||||||||
1811634 | 1811634 | CO | school | 804920 | 3090 | Weld County School District RE-3J | 80492000819 | 1446 | Weld Central Senior High School | Regular School | No | High | 09 | 12 | 2020 | grade_9 | 91 | 3 | 96 | 0 | 1 | 0 | 1 | 101 | 91 | 192 | 91 | 3 | 96 | 0 | 1 | 0 | 1 | 101 | 91 | 192 | ||||||||||||||||||||||||||||||||||
1811662 | 1811662 | CO | school | 804920 | 3090 | Weld County School District RE-3J | 80492002026 | 9347 | Weld Central Middle School | Regular School | No | Middle | 06 | 08 | 2020 | grade_7 | 82 | 2 | 96 | 0 | 2 | 0 | 2 | 99 | 85 | 184 | 82 | 2 | 96 | 0 | 2 | 0 | 2 | 99 | 85 | 184 | ||||||||||||||||||||||||||||||||||
1800020 | 1800020 | CO | school | 802580 | 40 | School District 27J | 80258006420 | 6702 | Otho E Stuart Middle School | Regular School | No | Middle | 06 | 08 | 2020 | grade_6 | 114 | 17 | 95 | 2 | 12 | 0 | 13 | 137 | 116 | 253 | 114 | 17 | 95 | 2 | 12 | 0 | 13 | 137 | 116 | 253 | ||||||||||||||||||||||||||||||||||
1800205 | 1800205 | CO | school | 807230 | 70 | Westminster Public Schools | 80723001241 | 5388 | M. Scott Carpenter Middle School | Regular School | No | Middle | 06 | 08 | 2020 | grade_6 | 9 | 2 | 95 | 0 | 2 | 0 | 0 | 59 | 49 | 108 | 9 | 2 | 95 | 0 | 2 | 0 | 0 | 59 | 49 | 108 | ||||||||||||||||||||||||||||||||||
1800912 | 1800912 | CO | school | 805310 | 140 | Littleton 6 | 80531000884 | 5224 | Littleton High School | Regular School | No | High | 09 | 12 | 2020 | grade_10 | 203 | 12 | 95 | 1 | 8 | 1 | 14 | 153 | 181 | 334 | 203 | 12 | 95 | 1 | 8 | 1 | 14 | 153 | 181 | 334 | ||||||||||||||||||||||||||||||||||
1803510 | 1803510 | CO | school | 803360 | 880 | Denver County 1 | 80336006733 | 4253 | Inspire Elementary | Regular School | No | Elementary | PK | 04 | 2020 | pk_12_total | 198 | 22 | 95 | 0 | 5 | 0 | 27 | 174 | 173 | 347 | 198 | 22 | 95 | 0 | 5 | 0 | 27 | 174 | 173 | 347 | ||||||||||||||||||||||||||||||||||
1803658 | 1803658 | CO | school | 803360 | 880 | Denver County 1 | 80336001406 | 5605 | Dr. Martin Luther King Jr. Early College | Regular School | No | High | 06 | 12 | 2020 | grade_7 | 6 | 39 | 95 | 0 | 9 | 0 | 4 | 77 | 76 | 153 | 6 | 39 | 95 | 0 | 9 | 0 | 4 | 77 | 76 | 153 | ||||||||||||||||||||||||||||||||||
1803915 | 1803915 | CO | school | 803360 | 880 | Denver County 1 | 80336006647 | 7361 | RiseUp Community School | Alternative School | Yes | High | 09 | 12 | 2020 | pk_12_total | 8 | 15 | 95 | 3 | 0 | 1 | 7 | 78 | 51 | 129 | 8 | 15 | 95 | 3 | 0 | 1 | 7 | 78 | 51 | 129 | ||||||||||||||||||||||||||||||||||
1805825 | 1805825 | CO | school | 803060 | 1010 | Colorado Springs 11 | 80306001379 | 5604 | King Elementary School | Regular School | No | Elementary | PK | 05 | 2020 | pk_12_total | 185 | 30 | 95 | 3 | 4 | 0 | 27 | 177 | 167 | 344 | 185 | 30 | 95 | 3 | 4 | 0 | 27 | 177 | 167 | 344 | ||||||||||||||||||||||||||||||||||
1807328 | 1807328 | CO | school | 804800 | 1420 | Jefferson County R-1 | 80480000703 | 1318 | Carmody Middle School | Regular School | No | Middle | 06 | 08 | 2020 | grade_6 | 138 | 6 | 95 | 1 | 10 | 2 | 10 | 136 | 126 | 262 | 138 | 6 | 95 | 1 | 10 | 2 | 10 | 136 | 126 | 262 | ||||||||||||||||||||||||||||||||||
1809238 | 1809238 | CO | school | 805400 | 1560 | Thompson R2-J | 80540000935 | 5316 | Loveland High School | Regular School | No | High | 09 | 12 | 2020 | grade_10 | 264 | 6 | 95 | 1 | 8 | 1 | 11 | 192 | 194 | 386 | 264 | 6 | 95 | 1 | 8 | 1 | 11 | 192 | 194 | 386 | ||||||||||||||||||||||||||||||||||
1809730 | 1809730 | CO | school | 804350 | 2000 | Mesa County Valley 51 | 80435000605 | 2392 | East Middle School | Regular School | No | Middle | 06 | 08 | 2020 | pk_12_total | 318 | 4 | 95 | 3 | 9 | 2 | 24 | 236 | 219 | 455 | 318 | 4 | 95 | 3 | 9 | 2 | 24 | 236 | 219 | 455 | ||||||||||||||||||||||||||||||||||
1809740 | 1809740 | CO | school | 804350 | 2000 | Mesa County Valley 51 | 80435000608 | 3244 | Fruita Middle School | Regular School | No | Middle | 06 | 07 | 2020 | pk_12_total | 482 | 1 | 95 | 3 | 7 | 0 | 21 | 305 | 304 | 609 | 482 | 1 | 95 | 3 | 7 | 0 | 21 | 305 | 304 | 609 | ||||||||||||||||||||||||||||||||||
1810701 | 1810701 | CO | school | 806120 | 2690 | Pueblo City 60 | 80612001730 | 1488 | Chavez/Huerta K-12 Preparatory Academy | Regular School | Yes | Other | KG | 12 | 2020 | grade_7 | 16 | 3 | 95 | 1 | 0 | 0 | 0 | 61 | 54 | 115 | 16 | 3 | 95 | 1 | 0 | 0 | 0 | 61 | 54 | 115 | ||||||||||||||||||||||||||||||||||
1810948 | 1810948 | CO | school | 806150 | 2700 | Pueblo County 70 | 80615001079 | 7208 | Pueblo County High School | Regular School | No | High | 09 | 12 | 2020 | grade_12 | 137 | 0 | 95 | 0 | 1 | 0 | 5 | 119 | 119 | 238 | 137 | 0 | 95 | 0 | 1 | 0 | 5 | 119 | 119 | 238 | ||||||||||||||||||||||||||||||||||
1811661 | 1811661 | CO | school | 804920 | 3090 | Weld County School District RE-3J | 80492002026 | 9347 | Weld Central Middle School | Regular School | No | Middle | 06 | 08 | 2020 | grade_6 | 76 | 1 | 95 | 2 | 3 | 0 | 4 | 102 | 79 | 181 | 76 | 1 | 95 | 2 | 3 | 0 | 4 | 102 | 79 | 181 | ||||||||||||||||||||||||||||||||||
1800725 | 1800725 | CO | school | 802910 | 130 | Cherry Creek 5 | 80291001272 | 6625 | Overland High School | Regular School | No | High | 09 | 12 | 2020 | pk_12_total | 473 | 658 | 940 | 20 | 133 | 10 | 145 | 1249 | 1130 | 2379 | 473 | 658 | 940 | 20 | 133 | 10 | 145 | 1249 | 1130 | 2379 | ||||||||||||||||||||||||||||||||||
1799312 | 1799312 | CO | school | 805550 | 10 | Mapleton 1 | 80555001857 | 187 | Mapleton Expeditionary School of the Arts | Regular School | No | High | 07 | 12 | 2020 | grade_8 | 20 | 3 | 94 | 1 | 2 | 1 | 4 | 65 | 60 | 125 | 20 | 3 | 94 | 1 | 2 | 1 | 4 | 65 | 60 | 125 | ||||||||||||||||||||||||||||||||||
1799417 | 1799417 | CO | school | 805550 | 10 | Mapleton 1 | 80555006671 | 695 | Big Picture College and Career Academy | Regular School | No | High | 09 | 12 | 2020 | pk_12_total | 30 | 0 | 94 | 1 | 1 | 0 | 10 | 66 | 70 | 136 | 30 | 0 | 94 | 1 | 1 | 0 | 10 | 66 | 70 | 136 | ||||||||||||||||||||||||||||||||||
1799638 | 1799638 | CO | school | 806900 | 20 | Adams 12 Five Star Schools | 80690001784 | 5043 | Legacy High School | Regular School | No | High | 09 | 12 | 2020 | grade_12 | 371 | 7 | 94 | 1 | 47 | 1 | 6 | 278 | 249 | 527 | 371 | 7 | 94 | 1 | 47 | 1 | 6 | 278 | 249 | 527 | ||||||||||||||||||||||||||||||||||
1800295 | 1800295 | CO | school | 802070 | 100 | Alamosa RE-11J | 80207000027 | 118 | Alamosa High School | Regular School | No | High | 09 | 12 | 2020 | grade_10 | 44 | 1 | 94 | 1 | 2 | 1 | 3 | 76 | 70 | 146 | 44 | 1 | 94 | 1 | 2 | 1 | 3 | 76 | 70 | 146 | ||||||||||||||||||||||||||||||||||
1802037 | 1802037 | CO | school | 805370 | 470 | St Vrain Valley RE1J | 80537006598 | 7561 | Spark! Discovery Preschool | Regular School | No | Prekindergarten | PK | PK | 2020 | pk_12_total | 184 | 4 | 94 | 0 | 5 | 1 | 16 | 169 | 135 | 304 | 184 | 4 | 94 | 0 | 5 | 1 | 16 | 169 | 135 | 304 | ||||||||||||||||||||||||||||||||||
1802038 | 1802038 | CO | school | 805370 | 470 | St Vrain Valley RE1J | 80537006598 | 7561 | Spark! Discovery Preschool | Regular School | No | Prekindergarten | PK | PK | 2020 | pre_kindergarten | 184 | 4 | 94 | 0 | 5 | 1 | 16 | 169 | 135 | 304 | 184 | 4 | 94 | 0 | 5 | 1 | 16 | 169 | 135 | 304 | ||||||||||||||||||||||||||||||||||
1803155 | 1803155 | CO | school | 803360 | 880 | Denver County 1 | 80336006546 | 2181 | DSST: Green Valley Ranch Middle School | Regular School | Yes | Middle | 06 | 08 | 2020 | grade_6 | 9 | 40 | 94 | 0 | 11 | 5 | 2 | 89 | 72 | 161 | 9 | 40 | 94 | 0 | 11 | 5 | 2 | 89 | 72 | 161 | ||||||||||||||||||||||||||||||||||
1803559 | 1803559 | CO | school | 803360 | 880 | Denver County 1 | 80336006519 | 4507 | KIPP Northeast Denver Middle School | Regular School | Yes | Middle | 05 | 08 | 2020 | grade_7 | 6 | 20 | 94 | 0 | 6 | 1 | 3 | 60 | 70 | 130 | 6 | 20 | 94 | 0 | 6 | 1 | 3 | 60 | 70 | 130 | ||||||||||||||||||||||||||||||||||
1803687 | 1803687 | CO | school | 803360 | 880 | Denver County 1 | 80336001276 | 5685 | McGlone Academy | Regular School | No | Elementary | PK | 08 | 2020 | grade_4 | 2 | 14 | 94 | 1 | 1 | 8 | 3 | 58 | 65 | 123 | 2 | 14 | 94 | 1 | 1 | 8 | 3 | 58 | 65 | 123 | ||||||||||||||||||||||||||||||||||
1805269 | 1805269 | CO | school | 804530 | 980 | Harrison 2 | 80453000666 | 3522 | Fox Meadow Middle School | Regular School | No | Middle | 06 | 08 | 2020 | grade_8 | 45 | 23 | 94 | 0 | 2 | 2 | 20 | 105 | 81 | 186 | 45 | 23 | 94 | 0 | 2 | 2 | 20 | 105 | 81 | 186 | ||||||||||||||||||||||||||||||||||
1805360 | 1805360 | CO | school | 804530 | 980 | Harrison 2 | 80453001382 | 7882 | Sierra High School | Regular School | No | High | 09 | 12 | 2020 | grade_10 | 39 | 40 | 94 | 2 | 7 | 2 | 16 | 103 | 97 | 200 | 39 | 40 | 94 | 2 | 7 | 2 | 16 | 103 | 97 | 200 | ||||||||||||||||||||||||||||||||||
1805857 | 1805857 | CO | school | 803060 | 1010 | Colorado Springs 11 | 80306000256 | 6306 | North Middle School | Regular School | No | Middle | 06 | 08 | 2020 | grade_7 | 102 | 23 | 94 | 1 | 0 | 1 | 19 | 120 | 120 | 240 | 102 | 23 | 94 | 1 | 0 | 1 | 19 | 120 | 120 | 240 | ||||||||||||||||||||||||||||||||||
1806434 | 1806434 | CO | school | 805820 | 1080 | Lewis-Palmer 38 | 80582001536 | 5093 | Monument Charter Academy | Regular School | Yes | Elementary | PK | 08 | 2020 | pk_12_total | 793 | 13 | 94 | 2 | 25 | 0 | 39 | 481 | 485 | 966 | 793 | 13 | 94 | 2 | 25 | 0 | 39 | 481 | 485 | 966 | ||||||||||||||||||||||||||||||||||
1806701 | 1806701 | CO | school | 803870 | 1110 | District 49 | 80387006408 | 8791 | Vista Ridge High School | Regular School | No | High | 09 | 12 | 2020 | grade_12 | 200 | 32 | 94 | 3 | 19 | 5 | 38 | 223 | 168 | 391 | 200 | 32 | 94 | 3 | 19 | 5 | 38 | 223 | 168 | 391 | ||||||||||||||||||||||||||||||||||
1807506 | 1807506 | CO | school | 804800 | 1420 | Jefferson County R-1 | 80480000720 | 2820 | Everitt Middle School | Regular School | No | Middle | 06 | 08 | 2020 | grade_8 | 93 | 2 | 94 | 2 | 3 | 0 | 7 | 100 | 101 | 201 | 93 | 2 | 94 | 2 | 3 | 0 | 7 | 100 | 101 | 201 | ||||||||||||||||||||||||||||||||||
1807921 | 1807921 | CO | school | 804800 | 1420 | Jefferson County R-1 | 80480006311 | 6139 | Mountain Phoenix Community School | Regular School | Yes | Elementary | PK | 08 | 2020 | pk_12_total | 521 | 6 | 94 | 2 | 4 | 1 | 36 | 316 | 348 | 664 | 521 | 6 | 94 | 2 | 4 | 1 | 36 | 316 | 348 | 664 | ||||||||||||||||||||||||||||||||||
1807937 | 1807937 | CO | school | 804800 | 1420 | Jefferson County R-1 | 80480000760 | 6330 | North Arvada Middle School | Regular School | No | Middle | 06 | 08 | 2020 | grade_7 | 86 | 3 | 94 | 0 | 4 | 1 | 5 | 93 | 100 | 193 | 86 | 3 | 94 | 0 | 4 | 1 | 5 | 93 | 100 | 193 |
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]);