enrollments
Data source: Big Local News · About: Big Local
627 rows where grade = "grade_8", state = "CO" and year = 2021 sorted by male descending
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1742069 | 1742069 | CO | school | 803360 | 880 | Denver County 1 | 80336006566 | 2115 | DSST: Montview Middle School | Regular School | Yes | Middle | 06 | 08 | 2021 | grade_8 | 29 | 45 | 56 | 0 | 6 | 1 | 20 | 98 | 59 | 157 | 29 | 45 | 56 | 0 | 6 | 1 | 20 | 98 | 59 | 157 | ||||||||||||||||||||||||||||||||||
1742694 | 1742694 | CO | school | 803360 | 880 | Denver County 1 | 80336000379 | 5826 | Merrill Middle School | Regular School | No | Middle | 06 | 08 | 2021 | grade_8 | 105 | 15 | 57 | 1 | 11 | 1 | 8 | 98 | 100 | 198 | 105 | 15 | 57 | 1 | 11 | 1 | 8 | 98 | 100 | 198 | ||||||||||||||||||||||||||||||||||
1747955 | 1747955 | CO | school | 803990 | 1550 | Poudre R-1 | 80399000551 | 9374 | Wellington Middle School | Regular School | No | Middle | 06 | 08 | 2021 | grade_8 | 147 | 2 | 33 | 1 | 0 | 0 | 7 | 98 | 92 | 190 | 147 | 2 | 33 | 1 | 0 | 0 | 7 | 98 | 92 | 190 | ||||||||||||||||||||||||||||||||||
1747207 | 1747207 | CO | school | 804800 | 1420 | Jefferson County R-1 | 80480002036 | 9299 | Wayne Carle Middle School | Regular School | No | Middle | 06 | 08 | 2021 | grade_8 | 156 | 2 | 37 | 1 | 4 | 2 | 9 | 96 | 115 | 211 | 156 | 2 | 37 | 1 | 4 | 2 | 9 | 96 | 115 | 211 | ||||||||||||||||||||||||||||||||||
1748869 | 1748869 | CO | school | 803090 | 2035 | Montezuma-Cortez RE-1 | 80309000833 | 1888 | Montezuma-Cortez Middle School | Regular School | No | Middle | 06 | 08 | 2021 | grade_8 | 96 | 1 | 38 | 52 | 0 | 0 | 8 | 96 | 99 | 195 | 96 | 1 | 38 | 52 | 0 | 0 | 8 | 96 | 99 | 195 | ||||||||||||||||||||||||||||||||||
1739171 | 1739171 | CO | school | 807230 | 70 | Westminster Public Schools | 80723001244 | 7812 | Shaw Heights Middle School | Regular School | No | Middle | 06 | 08 | 2021 | grade_8 | 28 | 8 | 126 | 2 | 10 | 0 | 8 | 95 | 87 | 182 | 28 | 8 | 126 | 2 | 10 | 0 | 8 | 95 | 87 | 182 | ||||||||||||||||||||||||||||||||||
1748723 | 1748723 | CO | school | 804350 | 2000 | Mesa County Valley 51 | 80435000619 | 6562 | Orchard Mesa Middle School | Regular School | No | Middle | 06 | 08 | 2021 | grade_8 | 122 | 0 | 51 | 0 | 2 | 0 | 12 | 95 | 92 | 187 | 122 | 0 | 51 | 0 | 2 | 0 | 12 | 95 | 92 | 187 | ||||||||||||||||||||||||||||||||||
1748744 | 1748744 | CO | school | 804350 | 2000 | Mesa County Valley 51 | 80435000205 | 7281 | Redlands Middle School | Regular School | No | Middle | 06 | 08 | 2021 | grade_8 | 150 | 0 | 17 | 0 | 2 | 0 | 10 | 94 | 85 | 179 | 150 | 0 | 17 | 0 | 2 | 0 | 10 | 94 | 85 | 179 | ||||||||||||||||||||||||||||||||||
1744389 | 1744389 | CO | school | 806480 | 990 | Widefield 3 | 80648001125 | 8178 | Sproul Junior High School | Regular School | No | Middle | 06 | 08 | 2021 | grade_8 | 89 | 14 | 52 | 0 | 4 | 4 | 24 | 93 | 94 | 187 | 89 | 14 | 52 | 0 | 4 | 4 | 24 | 93 | 94 | 187 | ||||||||||||||||||||||||||||||||||
1745822 | 1745822 | CO | school | 804260 | 1180 | Roaring Fork RE-1 | 80426000587 | 3464 | Glenwood Springs Middle School | Regular School | No | Middle | 06 | 08 | 2021 | grade_8 | 79 | 1 | 91 | 0 | 1 | 0 | 2 | 93 | 81 | 174 | 79 | 1 | 91 | 0 | 1 | 0 | 2 | 93 | 81 | 174 | ||||||||||||||||||||||||||||||||||
1747657 | 1747657 | CO | school | 803990 | 1550 | Poudre R-1 | 80399000523 | 898 | Boltz Middle School | Regular School | No | Middle | 06 | 08 | 2021 | grade_8 | 114 | 3 | 54 | 1 | 1 | 0 | 7 | 93 | 87 | 180 | 114 | 3 | 54 | 1 | 1 | 0 | 7 | 93 | 87 | 180 | ||||||||||||||||||||||||||||||||||
1750756 | 1750756 | CO | school | 804410 | 3120 | Greeley 6 | 80441000639 | 3162 | Franklin Middle School | Regular School | No | Middle | 06 | 08 | 2021 | grade_8 | 18 | 1 | 157 | 1 | 4 | 0 | 2 | 93 | 90 | 183 | 18 | 1 | 157 | 1 | 4 | 0 | 2 | 93 | 90 | 183 | ||||||||||||||||||||||||||||||||||
1746723 | 1746723 | CO | school | 804800 | 1420 | Jefferson County R-1 | 80480001384 | 5454 | Mandalay Middle School | Regular School | No | Middle | 06 | 08 | 2021 | grade_8 | 106 | 6 | 40 | 0 | 21 | 1 | 14 | 92 | 96 | 188 | 106 | 6 | 40 | 0 | 21 | 1 | 14 | 92 | 96 | 188 | ||||||||||||||||||||||||||||||||||
1746841 | 1746841 | CO | school | 804800 | 1420 | Jefferson County R-1 | 80480000760 | 6330 | North Arvada Middle School | Regular School | No | Middle | 06 | 08 | 2021 | grade_8 | 79 | 4 | 90 | 1 | 4 | 1 | 5 | 92 | 92 | 184 | 79 | 4 | 90 | 1 | 4 | 1 | 5 | 92 | 92 | 184 | ||||||||||||||||||||||||||||||||||
1741928 | 1741928 | CO | school | 803360 | 880 | Denver County 1 | 80336006682 | 1077 | Bear Valley International School | Regular School | No | Middle | 06 | 08 | 2021 | grade_8 | 21 | 6 | 118 | 1 | 6 | 0 | 3 | 91 | 64 | 155 | 21 | 6 | 118 | 1 | 6 | 0 | 3 | 91 | 64 | 155 | ||||||||||||||||||||||||||||||||||
1748969 | 1748969 | CO | school | 805790 | 2180 | Montrose County RE-1J | 80579000987 | 1392 | Centennial Middle School | Regular School | No | Middle | 06 | 08 | 2021 | grade_8 | 87 | 0 | 91 | 1 | 0 | 0 | 5 | 91 | 93 | 184 | 87 | 0 | 91 | 1 | 0 | 0 | 5 | 91 | 93 | 184 | ||||||||||||||||||||||||||||||||||
1749709 | 1749709 | CO | school | 806120 | 2690 | Pueblo City 60 | 80612001061 | 7481 | Roncalli Stem Academy | Regular School | No | Middle | 06 | 08 | 2021 | grade_8 | 38 | 3 | 110 | 1 | 0 | 1 | 0 | 91 | 62 | 153 | 38 | 3 | 110 | 1 | 0 | 1 | 0 | 91 | 62 | 153 | ||||||||||||||||||||||||||||||||||
1745902 | 1745902 | CO | school | 806240 | 1195 | Garfield Re-2 | 80624001098 | 7388 | Riverside School | Regular School | No | Middle | 06 | 08 | 2021 | grade_8 | 78 | 1 | 71 | 1 | 0 | 0 | 4 | 90 | 65 | 155 | 78 | 1 | 71 | 1 | 0 | 0 | 4 | 90 | 65 | 155 | ||||||||||||||||||||||||||||||||||
1746417 | 1746417 | CO | school | 804800 | 1420 | Jefferson County R-1 | 80480000720 | 2820 | Everitt Middle School | Regular School | No | Middle | 06 | 08 | 2021 | grade_8 | 99 | 4 | 81 | 5 | 3 | 1 | 10 | 90 | 113 | 203 | 99 | 4 | 81 | 5 | 3 | 1 | 10 | 90 | 113 | 203 | ||||||||||||||||||||||||||||||||||
1739966 | 1739966 | CO | school | 803270 | 170 | Deer Trail 26J | 80327000288 | 2140 | Deer Trail Junior-Senior High School | Regular School | No | High | 06 | 12 | 2021 | grade_8 | 7 | 0 | 11 | 0 | 0 | 0 | 1 | 9 | 10 | 19 | 7 | 0 | 11 | 0 | 0 | 0 | 1 | 9 | 10 | 19 | ||||||||||||||||||||||||||||||||||
1748255 | 1748255 | CO | school | 804650 | 1600 | Hoehne Reorganized 3 | 80465000680 | 4048 | Hoehne Schools | Regular School | No | Other | PK | 12 | 2021 | grade_8 | 7 | 0 | 16 | 0 | 1 | 0 | 0 | 9 | 15 | 24 | 7 | 0 | 16 | 0 | 1 | 0 | 0 | 9 | 15 | 24 | ||||||||||||||||||||||||||||||||||
1749438 | 1749438 | CO | school | 804290 | 2650 | Granada RE-1 | 80429000593 | 3546 | Granada Undivided High School | Regular School | No | High | 07 | 12 | 2021 | grade_8 | 4 | 0 | 11 | 0 | 0 | 0 | 0 | 9 | 6 | 15 | 4 | 0 | 11 | 0 | 0 | 0 | 0 | 9 | 6 | 15 | ||||||||||||||||||||||||||||||||||
1750939 | 1750939 | CO | school | 804020 | 3140 | Weld Re-8 Schools | 80402006606 | 7219 | Kenneth Homyak PK-8 | Regular School | No | Elementary | PK | 08 | 2021 | grade_8 | 11 | 0 | 5 | 0 | 0 | 0 | 0 | 9 | 7 | 16 | 11 | 0 | 5 | 0 | 0 | 0 | 0 | 9 | 7 | 16 | ||||||||||||||||||||||||||||||||||
1750997 | 1750997 | CO | school | 806720 | 3147 | Prairie RE-11 | 80672001158 | 7156 | Prairie Junior-Senior High School | Regular School | No | High | 06 | 12 | 2021 | grade_8 | 18 | 0 | 1 | 0 | 0 | 0 | 0 | 9 | 10 | 19 | 18 | 0 | 1 | 0 | 0 | 0 | 0 | 9 | 10 | 19 | ||||||||||||||||||||||||||||||||||
1751543 | 1751543 | CO | school | 9999 | COLORADO DETENTION CENTER TOTAL | No school | COLORADO DETENTION CENTER TOTAL | 2021 | grade_8 | 5 | 1 | 2 | 0 | 1 | 0 | 0 | 9 | 0 | 9 | 5 | 1 | 2 | 0 | 1 | 0 | 0 | 9 | 0 | 9 | |||||||||||||||||||||||||||||||||||||||||
1741048 | 1741048 | CO | school | 805370 | 470 | St Vrain Valley RE1J | 80537006739 | 8055 | Soaring Heights PK-8 | Regular School | No | Elementary | PK | 08 | 2021 | grade_8 | 128 | 3 | 25 | 0 | 7 | 0 | 4 | 89 | 78 | 167 | 128 | 3 | 25 | 0 | 7 | 0 | 4 | 89 | 78 | 167 | ||||||||||||||||||||||||||||||||||
1750338 | 1750338 | CO | school | 807380 | 3020 | Woodland Park Re-2 | 80738001268 | 9694 | Woodland Park Middle School | Regular School | No | Middle | 06 | 08 | 2021 | grade_8 | 140 | 1 | 20 | 0 | 2 | 0 | 10 | 89 | 84 | 173 | 140 | 1 | 20 | 0 | 2 | 0 | 10 | 89 | 84 | 173 | ||||||||||||||||||||||||||||||||||
1740640 | 1740640 | CO | school | 805250 | 290 | Las Animas RE-1 | 80525006678 | 443 | AIM Global | Alternative School | No | High | 06 | 12 | 2021 | grade_8 | 54 | 4 | 101 | 0 | 0 | 0 | 4 | 88 | 75 | 163 | 54 | 4 | 101 | 0 | 0 | 0 | 4 | 88 | 75 | 163 | ||||||||||||||||||||||||||||||||||
1744676 | 1744676 | CO | school | 803060 | 1010 | Colorado Springs 11 | 80306000241 | 4070 | Holmes Middle School | Regular School | No | Middle | 06 | 08 | 2021 | grade_8 | 113 | 8 | 39 | 1 | 5 | 1 | 17 | 88 | 96 | 184 | 113 | 8 | 39 | 1 | 5 | 1 | 17 | 88 | 96 | 184 | ||||||||||||||||||||||||||||||||||
1746337 | 1746337 | CO | school | 804800 | 1420 | Jefferson County R-1 | 80480000964 | 2120 | D'Evelyn Junior/Senior High School | Regular School | No | High | 06 | 12 | 2021 | grade_8 | 146 | 2 | 24 | 1 | 21 | 0 | 6 | 88 | 112 | 200 | 146 | 2 | 24 | 1 | 21 | 0 | 6 | 88 | 112 | 200 | ||||||||||||||||||||||||||||||||||
1742201 | 1742201 | CO | school | 803360 | 880 | Denver County 1 | 80336006618 | 2218 | DSST: Conservatory Green Middle School | Regular School | Yes | Middle | 06 | 08 | 2021 | grade_8 | 24 | 32 | 88 | 1 | 7 | 0 | 8 | 87 | 73 | 160 | 24 | 32 | 88 | 1 | 7 | 0 | 8 | 87 | 73 | 160 | ||||||||||||||||||||||||||||||||||
1740945 | 1740945 | CO | school | 805370 | 470 | St Vrain Valley RE1J | 80537000915 | 5730 | Mead Middle School | Regular School | No | Middle | 06 | 08 | 2021 | grade_8 | 133 | 1 | 34 | 0 | 1 | 1 | 4 | 86 | 88 | 174 | 133 | 1 | 34 | 0 | 1 | 1 | 4 | 86 | 88 | 174 | ||||||||||||||||||||||||||||||||||
1741126 | 1741126 | CO | school | 802490 | 480 | Boulder Valley Re 2 | 80249006463 | 930 | Boulder Universal | Regular School | No | Other | KG | 12 | 2021 | grade_8 | 106 | 2 | 19 | 0 | 5 | 0 | 13 | 86 | 59 | 145 | 106 | 2 | 19 | 0 | 5 | 0 | 13 | 86 | 59 | 145 | ||||||||||||||||||||||||||||||||||
1742159 | 1742159 | CO | school | 803360 | 880 | Denver County 1 | 80336006572 | 2186 | DSST: Byers Middle School | Regular School | Yes | Middle | 06 | 08 | 2021 | grade_8 | 64 | 27 | 48 | 2 | 6 | 0 | 13 | 86 | 74 | 160 | 64 | 27 | 48 | 2 | 6 | 0 | 13 | 86 | 74 | 160 | ||||||||||||||||||||||||||||||||||
1744151 | 1744151 | CO | school | 804530 | 980 | Harrison 2 | 80453006691 | 369 | Atlas Preparatory Middle School | Regular School | Yes | Middle | 05 | 08 | 2021 | grade_8 | 8 | 11 | 139 | 1 | 0 | 1 | 5 | 86 | 79 | 165 | 8 | 11 | 139 | 1 | 0 | 1 | 5 | 86 | 79 | 165 | ||||||||||||||||||||||||||||||||||
1747509 | 1747509 | CO | school | 803480 | 1520 | Durango 9-R | 80348000452 | 5888 | Miller Middle School | Regular School | No | Middle | 06 | 08 | 2021 | grade_8 | 119 | 0 | 35 | 7 | 0 | 0 | 6 | 86 | 81 | 167 | 119 | 0 | 35 | 7 | 0 | 0 | 6 | 86 | 81 | 167 | ||||||||||||||||||||||||||||||||||
1738895 | 1738895 | CO | school | 802580 | 40 | School District 27J | 80258001729 | 1052 | Bromley East Charter School | Regular School | Yes | Elementary | PK | 08 | 2021 | grade_8 | 97 | 0 | 49 | 0 | 0 | 0 | 4 | 85 | 65 | 150 | 97 | 0 | 49 | 0 | 0 | 0 | 4 | 85 | 65 | 150 | ||||||||||||||||||||||||||||||||||
1742171 | 1742171 | CO | school | 803360 | 880 | Denver County 1 | 80336006746 | 2190 | DSST Middle School @ Noel Campus | Regular School | Yes | Middle | 06 | 08 | 2021 | grade_8 | 9 | 38 | 103 | 0 | 3 | 0 | 7 | 85 | 75 | 160 | 9 | 38 | 103 | 0 | 3 | 0 | 7 | 85 | 75 | 160 | ||||||||||||||||||||||||||||||||||
1751389 | 1751389 | CO | school | 800020 | 8001 | Charter School Institute | 80002001915 | 6914 | The Pinnacle Charter School | Regular School | Yes | Other | KG | 12 | 2021 | grade_8 | 20 | 0 | 160 | 0 | 6 | 0 | 4 | 85 | 105 | 190 | 20 | 0 | 160 | 0 | 6 | 0 | 4 | 85 | 105 | 190 | ||||||||||||||||||||||||||||||||||
1742134 | 1742134 | CO | school | 803360 | 880 | Denver County 1 | 80336006546 | 2181 | DSST: Green Valley Ranch Middle School | Regular School | Yes | Middle | 06 | 08 | 2021 | grade_8 | 8 | 44 | 93 | 0 | 12 | 1 | 5 | 84 | 79 | 163 | 8 | 44 | 93 | 0 | 12 | 1 | 5 | 84 | 79 | 163 | ||||||||||||||||||||||||||||||||||
1750750 | 1750750 | CO | school | 804410 | 3120 | Greeley 6 | 80441001696 | 2850 | University Schools | Regular School | Yes | Other | KG | 12 | 2021 | grade_8 | 89 | 1 | 68 | 0 | 1 | 0 | 7 | 83 | 83 | 166 | 89 | 1 | 68 | 0 | 1 | 0 | 7 | 83 | 83 | 166 | ||||||||||||||||||||||||||||||||||
1740907 | 1740907 | CO | school | 805370 | 470 | St Vrain Valley RE1J | 80537000908 | 5286 | Sunset Middle School | Regular School | No | Middle | 06 | 08 | 2021 | grade_8 | 66 | 0 | 69 | 0 | 2 | 0 | 3 | 82 | 58 | 140 | 66 | 0 | 69 | 0 | 2 | 0 | 3 | 82 | 58 | 140 | ||||||||||||||||||||||||||||||||||
1742494 | 1742494 | CO | school | 803360 | 880 | Denver County 1 | 80336006554 | 4381 | DSST: College View Middle School | Regular School | Yes | Middle | 06 | 08 | 2021 | grade_8 | 6 | 4 | 139 | 0 | 7 | 0 | 2 | 82 | 76 | 158 | 6 | 4 | 139 | 0 | 7 | 0 | 2 | 82 | 76 | 158 | ||||||||||||||||||||||||||||||||||
1750687 | 1750687 | CO | school | 804410 | 3120 | Greeley 6 | 80441001990 | 54 | Bella Romero Academy of Applied Technology | Regular School | No | Elementary | KG | 08 | 2021 | grade_8 | 8 | 7 | 115 | 0 | 1 | 1 | 0 | 82 | 50 | 132 | 8 | 7 | 115 | 0 | 1 | 1 | 0 | 82 | 50 | 132 | ||||||||||||||||||||||||||||||||||
1738723 | 1738723 | CO | school | 806900 | 20 | Adams 12 Five Star Schools | 80690006561 | 8310 | STEM Launch | Regular School | No | Elementary | KG | 08 | 2021 | grade_8 | 20 | 1 | 111 | 1 | 1 | 0 | 3 | 81 | 56 | 137 | 20 | 1 | 111 | 1 | 1 | 0 | 3 | 81 | 56 | 137 | ||||||||||||||||||||||||||||||||||
1739144 | 1739144 | CO | school | 807230 | 70 | Westminster Public Schools | 80723001241 | 5388 | Colorado Sports Leadership Academy | Regular School | No | Elementary | KG | 08 | 2021 | grade_8 | 9 | 2 | 127 | 2 | 1 | 2 | 1 | 81 | 63 | 144 | 9 | 2 | 127 | 2 | 1 | 2 | 1 | 81 | 63 | 144 | ||||||||||||||||||||||||||||||||||
1748174 | 1748174 | CO | school | 805400 | 1560 | Thompson R2-J | 80540001286 | 9228 | Walt Clark Middle School | Regular School | No | Middle | 06 | 08 | 2021 | grade_8 | 129 | 1 | 20 | 5 | 0 | 0 | 4 | 81 | 78 | 159 | 129 | 1 | 20 | 5 | 0 | 0 | 4 | 81 | 78 | 159 | ||||||||||||||||||||||||||||||||||
1748989 | 1748989 | CO | school | 805790 | 2180 | Montrose County RE-1J | 80579000989 | 6054 | Columbine Middle School | Regular School | No | Middle | 06 | 08 | 2021 | grade_8 | 95 | 1 | 54 | 0 | 0 | 1 | 5 | 81 | 75 | 156 | 95 | 1 | 54 | 0 | 0 | 1 | 5 | 81 | 75 | 156 | ||||||||||||||||||||||||||||||||||
1750207 | 1750207 | CO | school | 804860 | 2862 | Julesburg Re-1 | 80486006387 | 4369 | Destinations Career Academy of Colorado | Alternative School | No | High | 06 | 12 | 2021 | grade_8 | 85 | 9 | 34 | 2 | 1 | 1 | 10 | 80 | 62 | 142 | 85 | 9 | 34 | 2 | 1 | 1 | 10 | 80 | 62 | 142 | ||||||||||||||||||||||||||||||||||
1740600 | 1740600 | CO | school | 806630 | 250 | Springfield RE-4 | 80663001142 | 8168 | Springfield Junior/Senior High School | Regular School | No | High | 06 | 12 | 2021 | grade_8 | 15 | 0 | 3 | 1 | 1 | 0 | 1 | 8 | 13 | 21 | 15 | 0 | 3 | 1 | 1 | 0 | 1 | 8 | 13 | 21 | ||||||||||||||||||||||||||||||||||
1741547 | 1741547 | CO | school | 800001 | 520 | Cheyenne County Re-5 | 80000100215 | 1612 | Cheyenne Wells Junior/High School | Regular School | No | High | 07 | 12 | 2021 | grade_8 | 11 | 0 | 2 | 0 | 0 | 0 | 0 | 8 | 5 | 13 | 11 | 0 | 2 | 0 | 0 | 0 | 0 | 8 | 5 | 13 | ||||||||||||||||||||||||||||||||||
1743149 | 1743149 | CO | school | 803360 | 880 | Denver County 1 | 80336000426 | 9548 | Whittier ECE-8 School | Regular School | No | Elementary | PK | 08 | 2021 | grade_8 | 0 | 9 | 12 | 0 | 0 | 0 | 2 | 8 | 15 | 23 | 0 | 9 | 12 | 0 | 0 | 0 | 2 | 8 | 15 | 23 | ||||||||||||||||||||||||||||||||||
1744620 | 1744620 | CO | school | 803060 | 1010 | Colorado Springs 11 | 80306000232 | 2528 | Nikola Tesla Education Opportunity Center | Alternative School | No | High | 06 | 12 | 2021 | grade_8 | 6 | 1 | 9 | 0 | 0 | 0 | 0 | 8 | 8 | 16 | 6 | 1 | 9 | 0 | 0 | 0 | 0 | 8 | 8 | 16 | ||||||||||||||||||||||||||||||||||
1746107 | 1746107 | CO | school | 807050 | 1410 | North Park R-1 | 80705001209 | 6358 | North Park School | Regular School | No | Other | PK | 12 | 2021 | grade_8 | 8 | 0 | 6 | 0 | 0 | 0 | 0 | 8 | 6 | 14 | 8 | 0 | 6 | 0 | 0 | 0 | 0 | 8 | 6 | 14 | ||||||||||||||||||||||||||||||||||
1746473 | 1746473 | CO | school | 804800 | 1420 | Jefferson County R-1 | 80480001920 | 3201 | Free Horizon Montessori | Regular School | No | Elementary | PK | 08 | 2021 | grade_8 | 14 | 0 | 1 | 0 | 0 | 0 | 0 | 8 | 7 | 15 | 14 | 0 | 1 | 0 | 0 | 0 | 0 | 8 | 7 | 15 | ||||||||||||||||||||||||||||||||||
1746624 | 1746624 | CO | school | 804800 | 1420 | Jefferson County R-1 | 80480006306 | 4798 | Connections Learning Center on the Earle Johnson Campus | Alternative School | No | Middle | 06 | 08 | 2021 | grade_8 | 4 | 0 | 5 | 0 | 0 | 0 | 0 | 8 | 1 | 9 | 4 | 0 | 5 | 0 | 0 | 0 | 0 | 8 | 1 | 9 | ||||||||||||||||||||||||||||||||||
1748413 | 1748413 | CO | school | 803930 | 1850 | Frenchman RE-3 | 80393000512 | 2988 | Fleming High School | Regular School | No | High | 07 | 12 | 2021 | grade_8 | 10 | 0 | 0 | 0 | 0 | 0 | 0 | 8 | 2 | 10 | 10 | 0 | 0 | 0 | 0 | 0 | 0 | 8 | 2 | 10 | ||||||||||||||||||||||||||||||||||
1748444 | 1748444 | CO | school | 806030 | 1870 | Plateau RE-5 | 80603001023 | 6838 | Peetz Junior-Senior High School | Regular School | No | High | 07 | 12 | 2021 | grade_8 | 7 | 0 | 1 | 1 | 0 | 0 | 0 | 8 | 1 | 9 | 7 | 0 | 1 | 1 | 0 | 0 | 0 | 8 | 1 | 9 | ||||||||||||||||||||||||||||||||||
1748457 | 1748457 | CO | school | 803240 | 1980 | De Beque 49JT | 80324000286 | 2126 | De Beque PK-12 School District 49JT | Regular School | No | Other | PK | 12 | 2021 | grade_8 | 10 | 1 | 4 | 0 | 1 | 0 | 0 | 8 | 8 | 16 | 10 | 1 | 4 | 0 | 1 | 0 | 0 | 8 | 8 | 16 | ||||||||||||||||||||||||||||||||||
1749061 | 1749061 | CO | school | 805850 | 2190 | West End RE-2 | 80585006727 | 6307 | Nucla Middle School | Regular School | No | Middle | 07 | 08 | 2021 | grade_8 | 11 | 1 | 1 | 0 | 0 | 0 | 1 | 8 | 6 | 14 | 11 | 1 | 1 | 0 | 0 | 0 | 1 | 8 | 6 | 14 | ||||||||||||||||||||||||||||||||||
1749150 | 1749150 | CO | school | 807140 | 2505 | Weldon Valley RE-20(J) | 80714001218 | 9360 | Weldon Valley Jr/Sr High School | Regular School | No | High | 07 | 12 | 2021 | grade_8 | 15 | 1 | 1 | 0 | 0 | 0 | 0 | 8 | 9 | 17 | 15 | 1 | 1 | 0 | 0 | 0 | 0 | 8 | 9 | 17 | ||||||||||||||||||||||||||||||||||
1749765 | 1749765 | CO | school | 806150 | 2700 | Pueblo County 70 | 80615001072 | 856 | Beulah Middle School | Regular School | No | Middle | 06 | 08 | 2021 | grade_8 | 12 | 0 | 2 | 0 | 0 | 0 | 0 | 8 | 6 | 14 | 12 | 0 | 2 | 0 | 0 | 0 | 0 | 8 | 6 | 14 | ||||||||||||||||||||||||||||||||||
1749988 | 1749988 | CO | school | 805760 | 2740 | Monte Vista C-8 | 80576001560 | 6520 | Monte Vista On-Line Academy | Alternative School | No | Other | 04 | 12 | 2021 | grade_8 | 11 | 0 | 4 | 0 | 1 | 0 | 0 | 8 | 8 | 16 | 11 | 0 | 4 | 0 | 1 | 0 | 0 | 8 | 8 | 16 | ||||||||||||||||||||||||||||||||||
1750223 | 1750223 | CO | school | 804860 | 2862 | Julesburg Re-1 | 80486000813 | 4492 | Julesburg High School | Regular School | No | High | 07 | 12 | 2021 | grade_8 | 10 | 0 | 7 | 0 | 0 | 0 | 0 | 8 | 9 | 17 | 10 | 0 | 7 | 0 | 0 | 0 | 0 | 8 | 9 | 17 | ||||||||||||||||||||||||||||||||||
1750268 | 1750268 | CO | school | 806810 | 3000 | Summit RE-1 | 80681006464 | 8375 | Snowy Peaks Junior/Senior High School | Alternative School | No | High | 07 | 12 | 2021 | grade_8 | 9 | 0 | 3 | 0 | 1 | 0 | 0 | 8 | 5 | 13 | 9 | 0 | 3 | 0 | 1 | 0 | 0 | 8 | 5 | 13 | ||||||||||||||||||||||||||||||||||
1750981 | 1750981 | CO | school | 802550 | 3146 | Briggsdale RE-10 | 80255000143 | 1012 | Briggsdale Undivided High School | Regular School | No | High | 06 | 12 | 2021 | grade_8 | 12 | 0 | 1 | 0 | 1 | 0 | 0 | 8 | 6 | 14 | 12 | 0 | 1 | 0 | 1 | 0 | 0 | 8 | 6 | 14 | ||||||||||||||||||||||||||||||||||
1751468 | 1751468 | CO | school | 800023 | 9000 | Colorado School for the Deaf and Blind | 80002306410 | 1924 | Colorado School for the Deaf and Blind | Special Education School | No | Other | PK | 12 | 2021 | grade_8 | 4 | 1 | 7 | 0 | 0 | 0 | 0 | 8 | 4 | 12 | 4 | 1 | 7 | 0 | 0 | 0 | 0 | 8 | 4 | 12 | ||||||||||||||||||||||||||||||||||
1741387 | 1741387 | CO | school | 802490 | 480 | Boulder Valley Re 2 | 80249000132 | 6224 | Nevin Platt Middle School | Regular School | No | Middle | 06 | 08 | 2021 | grade_8 | 131 | 1 | 15 | 1 | 3 | 0 | 16 | 79 | 88 | 167 | 131 | 1 | 15 | 1 | 3 | 0 | 16 | 79 | 88 | 167 | ||||||||||||||||||||||||||||||||||
1741439 | 1741439 | CO | school | 802490 | 480 | Boulder Valley Re 2 | 80249000134 | 8135 | Southern Hills Middle School | Regular School | No | Middle | 06 | 08 | 2021 | grade_8 | 127 | 3 | 10 | 0 | 4 | 1 | 14 | 79 | 80 | 159 | 127 | 3 | 10 | 0 | 4 | 1 | 14 | 79 | 80 | 159 | ||||||||||||||||||||||||||||||||||
1742352 | 1742352 | CO | school | 803360 | 880 | Denver County 1 | 80336000357 | 3600 | Grant Beacon Middle School | Regular School | No | Middle | 06 | 08 | 2021 | grade_8 | 30 | 10 | 95 | 1 | 5 | 0 | 6 | 79 | 68 | 147 | 30 | 10 | 95 | 1 | 5 | 0 | 6 | 79 | 68 | 147 | ||||||||||||||||||||||||||||||||||
1746143 | 1746143 | CO | school | 804800 | 1420 | Jefferson County R-1 | 80480006489 | 109 | Arvada K-8 | Regular School | No | Elementary | KG | 08 | 2021 | grade_8 | 46 | 9 | 82 | 0 | 1 | 1 | 5 | 79 | 65 | 144 | 46 | 9 | 82 | 0 | 1 | 1 | 5 | 79 | 65 | 144 | ||||||||||||||||||||||||||||||||||
1742640 | 1742640 | CO | school | 803360 | 880 | Denver County 1 | 80336001406 | 5605 | Dr. Martin Luther King Jr. Early College | Regular School | No | High | 06 | 12 | 2021 | grade_8 | 8 | 37 | 94 | 0 | 8 | 0 | 6 | 78 | 75 | 153 | 8 | 37 | 94 | 0 | 8 | 0 | 6 | 78 | 75 | 153 | ||||||||||||||||||||||||||||||||||
1747537 | 1747537 | CO | school | 803480 | 1520 | Durango 9-R | 80348000456 | 7994 | Escalante Middle School | Regular School | No | Middle | 06 | 08 | 2021 | grade_8 | 114 | 0 | 48 | 11 | 0 | 0 | 6 | 78 | 101 | 179 | 114 | 0 | 48 | 11 | 0 | 0 | 6 | 78 | 101 | 179 | ||||||||||||||||||||||||||||||||||
1748170 | 1748170 | CO | school | 805400 | 1560 | Thompson R2-J | 80540001354 | 8925 | Turner Middle School | Regular School | No | Middle | 06 | 08 | 2021 | grade_8 | 130 | 2 | 22 | 0 | 1 | 0 | 2 | 78 | 79 | 157 | 130 | 2 | 22 | 0 | 1 | 0 | 2 | 78 | 79 | 157 | ||||||||||||||||||||||||||||||||||
1750480 | 1750480 | CO | school | 803600 | 3085 | Eaton RE-2 | 80360000475 | 2452 | Eaton Middle School | Regular School | No | Middle | 06 | 08 | 2021 | grade_8 | 108 | 0 | 43 | 0 | 0 | 0 | 1 | 78 | 74 | 152 | 108 | 0 | 43 | 0 | 0 | 0 | 1 | 78 | 74 | 152 | ||||||||||||||||||||||||||||||||||
1741085 | 1741085 | CO | school | 802490 | 480 | Boulder Valley Re 2 | 80249001758 | 441 | Aspen Creek K-8 School | Regular School | No | Elementary | PK | 08 | 2021 | grade_8 | 101 | 3 | 16 | 1 | 8 | 0 | 3 | 77 | 55 | 132 | 101 | 3 | 16 | 1 | 8 | 0 | 3 | 77 | 55 | 132 | ||||||||||||||||||||||||||||||||||
1741409 | 1741409 | CO | school | 802490 | 480 | Boulder Valley Re 2 | 80249001792 | 6816 | Peak to Peak Charter School | Regular School | Yes | Other | KG | 12 | 2021 | grade_8 | 88 | 1 | 18 | 1 | 22 | 2 | 4 | 77 | 59 | 136 | 88 | 1 | 18 | 1 | 22 | 2 | 4 | 77 | 59 | 136 | ||||||||||||||||||||||||||||||||||
1741745 | 1741745 | CO | school | 803330 | 870 | Delta County 50(J) | 80333000296 | 2160 | Delta Middle School | Regular School | No | Middle | 06 | 08 | 2021 | grade_8 | 83 | 0 | 53 | 1 | 5 | 0 | 4 | 77 | 69 | 146 | 83 | 0 | 53 | 1 | 5 | 0 | 4 | 77 | 69 | 146 | ||||||||||||||||||||||||||||||||||
1739313 | 1739313 | CO | school | 803780 | 120 | Englewood 1 | 80378006331 | 2752 | Englewood Middle School | Regular School | No | Middle | 07 | 08 | 2021 | grade_8 | 59 | 7 | 56 | 2 | 0 | 0 | 7 | 76 | 55 | 131 | 59 | 7 | 56 | 2 | 0 | 0 | 7 | 76 | 55 | 131 | ||||||||||||||||||||||||||||||||||
1741137 | 1741137 | CO | school | 802490 | 480 | Boulder Valley Re 2 | 80249000102 | 1066 | Broomfield Heights Middle School | Regular School | No | Middle | 06 | 08 | 2021 | grade_8 | 111 | 2 | 32 | 1 | 7 | 0 | 12 | 76 | 89 | 165 | 111 | 2 | 32 | 1 | 7 | 0 | 12 | 76 | 89 | 165 | ||||||||||||||||||||||||||||||||||
1749599 | 1749599 | CO | school | 806120 | 2690 | Pueblo City 60 | 80612006361 | 2096 | Corwin International Magnet School | Regular School | No | Middle | 04 | 08 | 2021 | grade_8 | 25 | 4 | 103 | 0 | 1 | 0 | 6 | 76 | 63 | 139 | 25 | 4 | 103 | 0 | 1 | 0 | 6 | 76 | 63 | 139 | ||||||||||||||||||||||||||||||||||
1743969 | 1743969 | CO | school | 803540 | 910 | Eagle County RE 50 | 80354001309 | 2355 | Eagle Valley Middle School | Regular School | No | Middle | 06 | 08 | 2021 | grade_8 | 87 | 1 | 46 | 2 | 0 | 0 | 5 | 75 | 66 | 141 | 87 | 1 | 46 | 2 | 0 | 0 | 5 | 75 | 66 | 141 | ||||||||||||||||||||||||||||||||||
1744400 | 1744400 | CO | school | 806480 | 990 | Widefield 3 | 80648001126 | 9294 | Watson Junior High School | Regular School | No | Middle | 06 | 08 | 2021 | grade_8 | 69 | 14 | 53 | 0 | 1 | 0 | 21 | 75 | 83 | 158 | 69 | 14 | 53 | 0 | 1 | 0 | 21 | 75 | 83 | 158 | ||||||||||||||||||||||||||||||||||
1745729 | 1745729 | CO | school | 803960 | 1150 | Fremont RE-2 | 80396000514 | 3002 | Florence Jr./Sr. High School | Regular School | No | High | 07 | 12 | 2021 | grade_8 | 90 | 1 | 25 | 0 | 1 | 0 | 5 | 75 | 47 | 122 | 90 | 1 | 25 | 0 | 1 | 0 | 5 | 75 | 47 | 122 | ||||||||||||||||||||||||||||||||||
1748828 | 1748828 | CO | school | 805730 | 2020 | Moffat County RE: No 1 | 80573000977 | 1938 | Craig Middle School | Regular School | No | Middle | 06 | 08 | 2021 | grade_8 | 112 | 0 | 36 | 0 | 0 | 0 | 2 | 75 | 75 | 150 | 112 | 0 | 36 | 0 | 0 | 0 | 2 | 75 | 75 | 150 | ||||||||||||||||||||||||||||||||||
1748587 | 1748587 | CO | school | 804350 | 2000 | Mesa County Valley 51 | 80435000605 | 2392 | East Middle School | Regular School | No | Middle | 06 | 08 | 2021 | grade_8 | 102 | 1 | 32 | 0 | 2 | 0 | 8 | 74 | 71 | 145 | 102 | 1 | 32 | 0 | 2 | 0 | 8 | 74 | 71 | 145 | ||||||||||||||||||||||||||||||||||
1743121 | 1743121 | CO | school | 803360 | 880 | Denver County 1 | 80336006444 | 9389 | STRIVE Prep - Westwood | Regular School | Yes | Middle | 06 | 08 | 2021 | grade_8 | 3 | 4 | 111 | 0 | 4 | 0 | 0 | 71 | 51 | 122 | 3 | 4 | 111 | 0 | 4 | 0 | 0 | 71 | 51 | 122 | ||||||||||||||||||||||||||||||||||
1740538 | 1740538 | CO | school | 802190 | 220 | Archuleta County 50 Jt | 80219000040 | 6657 | Pagosa Springs Middle School | Regular School | No | Middle | 05 | 08 | 2021 | grade_8 | 71 | 0 | 48 | 13 | 0 | 0 | 5 | 70 | 67 | 137 | 71 | 0 | 48 | 13 | 0 | 0 | 5 | 70 | 67 | 137 | ||||||||||||||||||||||||||||||||||
1741360 | 1741360 | CO | school | 802490 | 480 | Boulder Valley Re 2 | 80249001573 | 6000 | Monarch K-8 School | Regular School | No | Elementary | PK | 08 | 2021 | grade_8 | 103 | 2 | 10 | 0 | 10 | 0 | 3 | 70 | 58 | 128 | 103 | 2 | 10 | 0 | 10 | 0 | 3 | 70 | 58 | 128 | ||||||||||||||||||||||||||||||||||
1743917 | 1743917 | CO | school | 803540 | 910 | Eagle County RE 50 | 80354001723 | 39 | Gypsum Creek Middle School | Regular School | No | Middle | 06 | 08 | 2021 | grade_8 | 35 | 0 | 83 | 1 | 0 | 0 | 2 | 70 | 51 | 121 | 35 | 0 | 83 | 1 | 0 | 0 | 2 | 70 | 51 | 121 | ||||||||||||||||||||||||||||||||||
1746591 | 1746591 | CO | school | 804800 | 1420 | Jefferson County R-1 | 80480000739 | 4422 | Jefferson Junior/Senior High School | Regular School | No | High | 07 | 12 | 2021 | grade_8 | 14 | 7 | 102 | 3 | 0 | 1 | 4 | 70 | 61 | 131 | 14 | 7 | 102 | 3 | 0 | 1 | 4 | 70 | 61 | 131 | ||||||||||||||||||||||||||||||||||
1739600 | 1739600 | CO | school | 802910 | 130 | Cherry Creek 5 | 80291006676 | 4189 | Heritage Heights Academy | Regular School | Yes | Elementary | KG | 08 | 2021 | grade_8 | 8 | 3 | 5 | 0 | 2 | 0 | 0 | 7 | 11 | 18 | 8 | 3 | 5 | 0 | 2 | 0 | 0 | 7 | 11 | 18 | ||||||||||||||||||||||||||||||||||
1742166 | 1742166 | CO | school | 803360 | 880 | Denver County 1 | 80336006516 | 2188 | Denver Center for 21st-Century Learning at Wyman | Alternative School | No | High | 06 | 12 | 2021 | grade_8 | 1 | 3 | 4 | 0 | 0 | 0 | 0 | 7 | 1 | 8 | 1 | 3 | 4 | 0 | 0 | 0 | 0 | 7 | 1 | 8 | ||||||||||||||||||||||||||||||||||
1743104 | 1743104 | CO | school | 803360 | 880 | Denver County 1 | 80336006514 | 8995 | Vista Academy | Alternative School | No | High | 06 | 12 | 2021 | grade_8 | 2 | 4 | 9 | 0 | 0 | 0 | 0 | 7 | 8 | 15 | 2 | 4 | 9 | 0 | 0 | 0 | 0 | 7 | 8 | 15 | ||||||||||||||||||||||||||||||||||
1745705 | 1745705 | CO | school | 802790 | 1140 | Canon City RE-1 | 80279001538 | 6752 | Mount View Core Knowledge Charter School | Regular School | Yes | Elementary | PK | 08 | 2021 | grade_8 | 21 | 0 | 2 | 0 | 0 | 0 | 1 | 7 | 17 | 24 | 21 | 0 | 2 | 0 | 0 | 0 | 1 | 7 | 17 | 24 | ||||||||||||||||||||||||||||||||||
1746262 | 1746262 | CO | school | 804800 | 1420 | Jefferson County R-1 | 80480000704 | 1730 | Coal Creek Canyon K-8 Elementary School | Regular School | No | Elementary | KG | 08 | 2021 | grade_8 | 11 | 0 | 0 | 0 | 0 | 0 | 0 | 7 | 4 | 11 | 11 | 0 | 0 | 0 | 0 | 0 | 0 | 7 | 4 | 11 | ||||||||||||||||||||||||||||||||||
1746352 | 1746352 | CO | school | 804800 | 1420 | Jefferson County R-1 | 80480006695 | 2189 | Doral Academy of Colorado | Regular School | Yes | Other | KG | 10 | 2021 | grade_8 | 9 | 1 | 5 | 0 | 0 | 0 | 1 | 7 | 9 | 16 | 9 | 1 | 5 | 0 | 0 | 0 | 1 | 7 | 9 | 16 | ||||||||||||||||||||||||||||||||||
1747318 | 1747318 | CO | school | 803510 | 1430 | Eads RE-1 | 80351001277 | 2332 | Eads Middle School | Regular School | No | Middle | 06 | 08 | 2021 | grade_8 | 11 | 0 | 1 | 0 | 0 | 0 | 0 | 7 | 5 | 12 | 11 | 0 | 1 | 0 | 0 | 0 | 0 | 7 | 5 | 12 | ||||||||||||||||||||||||||||||||||
1747350 | 1747350 | CO | school | 802260 | 1450 | Arriba-Flagler C-20 | 80226000509 | 2960 | Flagler Public School | Regular School | No | Other | PK | 12 | 2021 | grade_8 | 10 | 0 | 2 | 0 | 0 | 0 | 0 | 7 | 5 | 12 | 10 | 0 | 2 | 0 | 0 | 0 | 0 | 7 | 5 | 12 | ||||||||||||||||||||||||||||||||||
1747397 | 1747397 | CO | school | 802460 | 1490 | Bethune R-5 | 80246000095 | 842 | Bethune Public Schools | Regular School | No | Other | PK | 12 | 2021 | grade_8 | 9 | 0 | 6 | 0 | 0 | 0 | 0 | 7 | 8 | 15 | 9 | 0 | 6 | 0 | 0 | 0 | 0 | 7 | 8 | 15 |
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]);