enrollments
Data source: Big Local News · About: Big Local
634 rows where grade = "grade_7", state = "CO" and year = 2021 sorted by total_int 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 ▲ |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1742702 | 1742702 | CO | school | 803360 | 880 | Denver County 1 | 80336006562 | 5897 | McAuliffe International School | Regular School | No | Middle | 06 | 08 | 2021 | grade_7 | 349 | 56 | 78 | 2 | 17 | 0 | 41 | 278 | 265 | 543 | 349 | 56 | 78 | 2 | 17 | 0 | 41 | 278 | 265 | 543 | ||||||||||||||||||||||||||||||||||
1739710 | 1739710 | CO | school | 802910 | 130 | Cherry Creek 5 | 80291000201 | 7158 | Prairie Middle School | Regular School | No | Middle | 06 | 08 | 2021 | grade_7 | 97 | 130 | 187 | 2 | 24 | 3 | 44 | 243 | 244 | 487 | 97 | 130 | 187 | 2 | 24 | 3 | 44 | 243 | 244 | 487 | ||||||||||||||||||||||||||||||||||
1739451 | 1739451 | CO | school | 802910 | 130 | Cherry Creek 5 | 80291000185 | 1566 | Campus Middle School | Regular School | No | Middle | 06 | 08 | 2021 | grade_7 | 292 | 18 | 61 | 2 | 74 | 1 | 37 | 231 | 254 | 485 | 292 | 18 | 61 | 2 | 74 | 1 | 37 | 231 | 254 | 485 | ||||||||||||||||||||||||||||||||||
1743664 | 1743664 | CO | school | 803450 | 900 | Douglas County Re 1 | 80345001747 | 6164 | Mountain Ridge Middle School | Regular School | No | Middle | 07 | 08 | 2021 | grade_7 | 361 | 8 | 57 | 1 | 24 | 0 | 30 | 245 | 236 | 481 | 361 | 8 | 57 | 1 | 24 | 0 | 30 | 245 | 236 | 481 | ||||||||||||||||||||||||||||||||||
1743803 | 1743803 | CO | school | 803450 | 900 | Douglas County Re 1 | 80345001962 | 7448 | Rocky Heights Middle School | Regular School | No | Middle | 06 | 08 | 2021 | grade_7 | 321 | 2 | 49 | 0 | 33 | 0 | 22 | 223 | 204 | 427 | 321 | 2 | 49 | 0 | 33 | 0 | 22 | 223 | 204 | 427 | ||||||||||||||||||||||||||||||||||
1743264 | 1743264 | CO | school | 803450 | 900 | Douglas County Re 1 | 80345006404 | 264 | Cimarron Middle | Regular School | No | Middle | 06 | 08 | 2021 | grade_7 | 327 | 7 | 58 | 1 | 0 | 0 | 31 | 224 | 200 | 424 | 327 | 7 | 58 | 1 | 0 | 0 | 31 | 224 | 200 | 424 | ||||||||||||||||||||||||||||||||||
1743285 | 1743285 | CO | school | 803450 | 900 | Douglas County Re 1 | 80345006371 | 267 | Mesa Middle School | Regular School | No | Middle | 06 | 08 | 2021 | grade_7 | 292 | 6 | 73 | 2 | 6 | 1 | 21 | 227 | 174 | 401 | 292 | 6 | 73 | 2 | 6 | 1 | 21 | 227 | 174 | 401 | ||||||||||||||||||||||||||||||||||
1751508 | 1751508 | CO | school | 800282 | 9170 | Education reEnvisioned BOCES | 80028206764 | 1501 | Colorado Preparatory Academy Middle School | Regular School | No | Middle | 06 | 08 | 2021 | grade_7 | 214 | 15 | 123 | 2 | 2 | 3 | 34 | 212 | 181 | 393 | 214 | 15 | 123 | 2 | 2 | 3 | 34 | 212 | 181 | 393 | ||||||||||||||||||||||||||||||||||
1743778 | 1743778 | CO | school | 803450 | 900 | Douglas County Re 1 | 80345001528 | 7245 | Ranch View Middle School | Regular School | No | Middle | 07 | 08 | 2021 | grade_7 | 301 | 8 | 54 | 1 | 9 | 0 | 18 | 193 | 198 | 391 | 301 | 8 | 54 | 1 | 9 | 0 | 18 | 193 | 198 | 391 | ||||||||||||||||||||||||||||||||||
1739455 | 1739455 | CO | school | 802910 | 130 | Cherry Creek 5 | 80291000207 | 1568 | West Middle School | Regular School | No | Middle | 06 | 08 | 2021 | grade_7 | 286 | 5 | 48 | 3 | 17 | 1 | 29 | 211 | 178 | 389 | 286 | 5 | 48 | 3 | 17 | 1 | 29 | 211 | 178 | 389 | ||||||||||||||||||||||||||||||||||
1739762 | 1739762 | CO | school | 802910 | 130 | Cherry Creek 5 | 80291000034 | 8848 | Thunder Ridge Middle School | Regular School | No | Middle | 06 | 08 | 2021 | grade_7 | 195 | 40 | 96 | 2 | 25 | 2 | 29 | 194 | 195 | 389 | 195 | 40 | 96 | 2 | 25 | 2 | 29 | 194 | 195 | 389 | ||||||||||||||||||||||||||||||||||
1743416 | 1743416 | CO | school | 803450 | 900 | Douglas County Re 1 | 80345006219 | 2012 | Cresthill Middle School | Regular School | No | Middle | 07 | 08 | 2021 | grade_7 | 279 | 9 | 60 | 0 | 23 | 0 | 16 | 194 | 193 | 387 | 279 | 9 | 60 | 0 | 23 | 0 | 16 | 194 | 193 | 387 | ||||||||||||||||||||||||||||||||||
1739546 | 1739546 | CO | school | 802910 | 130 | Cherry Creek 5 | 80291006367 | 3030 | Fox Ridge Middle School | Regular School | No | Middle | 06 | 08 | 2021 | grade_7 | 235 | 16 | 57 | 5 | 33 | 1 | 32 | 201 | 178 | 379 | 235 | 16 | 57 | 5 | 33 | 1 | 32 | 201 | 178 | 379 | ||||||||||||||||||||||||||||||||||
1745353 | 1745353 | CO | school | 805820 | 1080 | Lewis-Palmer 38 | 80582001002 | 5098 | Lewis-Palmer Middle School | Regular School | No | Middle | 07 | 08 | 2021 | grade_7 | 302 | 8 | 39 | 1 | 7 | 0 | 22 | 208 | 171 | 379 | 302 | 8 | 39 | 1 | 7 | 0 | 22 | 208 | 171 | 379 | ||||||||||||||||||||||||||||||||||
1747115 | 1747115 | CO | school | 804800 | 1420 | Jefferson County R-1 | 80480001054 | 8381 | Summit Ridge Middle School | Regular School | No | Middle | 06 | 08 | 2021 | grade_7 | 273 | 3 | 63 | 0 | 22 | 0 | 14 | 198 | 177 | 375 | 273 | 3 | 63 | 0 | 22 | 0 | 14 | 198 | 177 | 375 | ||||||||||||||||||||||||||||||||||
1744460 | 1744460 | CO | school | 804080 | 1000 | Fountain 8 | 80408000563 | 3106 | Fountain Middle School | Regular School | No | Middle | 06 | 08 | 2021 | grade_7 | 183 | 31 | 86 | 5 | 7 | 10 | 47 | 187 | 182 | 369 | 183 | 31 | 86 | 5 | 7 | 10 | 47 | 187 | 182 | 369 | ||||||||||||||||||||||||||||||||||
1743712 | 1743712 | CO | school | 803450 | 900 | Douglas County Re 1 | 80345001582 | 6773 | Sierra Middle School | Regular School | No | Middle | 07 | 08 | 2021 | grade_7 | 262 | 12 | 62 | 1 | 5 | 0 | 20 | 185 | 177 | 362 | 262 | 12 | 62 | 1 | 5 | 0 | 20 | 185 | 177 | 362 | ||||||||||||||||||||||||||||||||||
1743419 | 1743419 | CO | school | 803450 | 900 | Douglas County Re 1 | 80345000438 | 2226 | Castle Rock Middle School | Regular School | No | Middle | 07 | 08 | 2021 | grade_7 | 258 | 3 | 63 | 2 | 10 | 0 | 19 | 173 | 182 | 355 | 258 | 3 | 63 | 2 | 10 | 0 | 19 | 173 | 182 | 355 | ||||||||||||||||||||||||||||||||||
1738569 | 1738569 | CO | school | 806900 | 20 | Adams 12 Five Star Schools | 80690001179 | 4187 | Silver Hills Middle School | Regular School | No | Middle | 06 | 08 | 2021 | grade_7 | 113 | 5 | 213 | 3 | 8 | 0 | 12 | 190 | 164 | 354 | 113 | 5 | 213 | 3 | 8 | 0 | 12 | 190 | 164 | 354 | ||||||||||||||||||||||||||||||||||
1738767 | 1738767 | CO | school | 806900 | 20 | Adams 12 Five Star Schools | 80690001194 | 9444 | Westlake Middle School | Regular School | No | Middle | 06 | 08 | 2021 | grade_7 | 221 | 2 | 86 | 4 | 19 | 0 | 21 | 181 | 172 | 353 | 221 | 2 | 86 | 4 | 19 | 0 | 21 | 181 | 172 | 353 | ||||||||||||||||||||||||||||||||||
1747862 | 1747862 | CO | school | 803990 | 1550 | Poudre R-1 | 80399001091 | 7161 | Preston Middle School | Regular School | No | Middle | 06 | 08 | 2021 | grade_7 | 282 | 4 | 38 | 0 | 12 | 2 | 12 | 187 | 163 | 350 | 282 | 4 | 38 | 0 | 12 | 2 | 12 | 187 | 163 | 350 | ||||||||||||||||||||||||||||||||||
1738410 | 1738410 | CO | school | 806900 | 20 | Adams 12 Five Star Schools | 80690001726 | 57 | Rocky Top Middle School | Regular School | No | Middle | 06 | 08 | 2021 | grade_7 | 219 | 5 | 75 | 3 | 23 | 2 | 20 | 172 | 175 | 347 | 219 | 5 | 75 | 3 | 23 | 2 | 20 | 172 | 175 | 347 | ||||||||||||||||||||||||||||||||||
1739631 | 1739631 | CO | school | 802910 | 130 | Cherry Creek 5 | 80291000197 | 4975 | Laredo Middle School | Regular School | No | Middle | 06 | 08 | 2021 | grade_7 | 129 | 62 | 97 | 5 | 25 | 0 | 29 | 177 | 170 | 347 | 129 | 62 | 97 | 5 | 25 | 0 | 29 | 177 | 170 | 347 | ||||||||||||||||||||||||||||||||||
1739357 | 1739357 | CO | school | 802910 | 130 | Cherry Creek 5 | 80291001711 | 18 | Liberty Middle School | Regular School | No | Middle | 06 | 08 | 2021 | grade_7 | 178 | 34 | 61 | 1 | 35 | 1 | 33 | 189 | 154 | 343 | 178 | 34 | 61 | 1 | 35 | 1 | 33 | 189 | 154 | 343 | ||||||||||||||||||||||||||||||||||
1745595 | 1745595 | CO | school | 803870 | 1110 | District 49 | 80387001799 | 7960 | Skyview Middle School | Regular School | No | Middle | 06 | 08 | 2021 | grade_7 | 179 | 21 | 79 | 2 | 18 | 0 | 38 | 170 | 167 | 337 | 179 | 21 | 79 | 2 | 18 | 0 | 38 | 170 | 167 | 337 | ||||||||||||||||||||||||||||||||||
1746364 | 1746364 | CO | school | 804800 | 1420 | Jefferson County R-1 | 80480000712 | 2288 | Drake Junior High School | Regular School | No | Middle | 06 | 08 | 2021 | grade_7 | 252 | 3 | 60 | 2 | 7 | 0 | 9 | 160 | 173 | 333 | 252 | 3 | 60 | 2 | 7 | 0 | 9 | 160 | 173 | 333 | ||||||||||||||||||||||||||||||||||
1745232 | 1745232 | CO | school | 801920 | 1040 | Academy 20 | 80192001462 | 8851 | Timberview Middle School | Regular School | No | Middle | 06 | 08 | 2021 | grade_7 | 228 | 9 | 56 | 1 | 6 | 0 | 25 | 164 | 161 | 325 | 228 | 9 | 56 | 1 | 6 | 0 | 25 | 164 | 161 | 325 | ||||||||||||||||||||||||||||||||||
1739369 | 1739369 | CO | school | 802910 | 130 | Cherry Creek 5 | 80291001878 | 141 | Sky Vista Middle School | Regular School | No | Middle | 06 | 08 | 2021 | grade_7 | 146 | 49 | 57 | 0 | 28 | 0 | 41 | 165 | 156 | 321 | 146 | 49 | 57 | 0 | 28 | 0 | 41 | 165 | 156 | 321 | ||||||||||||||||||||||||||||||||||
1745099 | 1745099 | CO | school | 801920 | 1040 | Academy 20 | 80192001402 | 2358 | Eagleview Middle School | Regular School | No | Middle | 06 | 08 | 2021 | grade_7 | 224 | 10 | 54 | 1 | 7 | 0 | 25 | 151 | 170 | 321 | 224 | 10 | 54 | 1 | 7 | 0 | 25 | 151 | 170 | 321 | ||||||||||||||||||||||||||||||||||
1738605 | 1738605 | CO | school | 806900 | 20 | Adams 12 Five Star Schools | 80690001183 | 5814 | Thornton Middle School | Regular School | No | Middle | 06 | 08 | 2021 | grade_7 | 31 | 13 | 254 | 3 | 8 | 1 | 5 | 164 | 151 | 315 | 31 | 13 | 254 | 3 | 8 | 1 | 5 | 164 | 151 | 315 | ||||||||||||||||||||||||||||||||||
1738446 | 1738446 | CO | school | 806900 | 20 | Adams 12 Five Star Schools | 80690001620 | 1480 | Century Middle School | Regular School | No | Middle | 06 | 08 | 2021 | grade_7 | 170 | 3 | 115 | 0 | 9 | 0 | 17 | 159 | 155 | 314 | 170 | 3 | 115 | 0 | 9 | 0 | 17 | 159 | 155 | 314 | ||||||||||||||||||||||||||||||||||
1739590 | 1739590 | CO | school | 802910 | 130 | Cherry Creek 5 | 80291001328 | 4100 | Horizon Middle School | Regular School | No | Middle | 06 | 08 | 2021 | grade_7 | 103 | 54 | 116 | 2 | 13 | 1 | 20 | 173 | 136 | 309 | 103 | 54 | 116 | 2 | 13 | 1 | 20 | 173 | 136 | 309 | ||||||||||||||||||||||||||||||||||
1738985 | 1738985 | CO | school | 802580 | 40 | School District 27J | 80258006753 | 7351 | Rodger Quist Middle School | Regular School | No | Middle | 06 | 08 | 2021 | grade_7 | 163 | 6 | 99 | 1 | 18 | 1 | 17 | 150 | 155 | 305 | 163 | 6 | 99 | 1 | 18 | 1 | 17 | 150 | 155 | 305 | ||||||||||||||||||||||||||||||||||
1739542 | 1739542 | CO | school | 802910 | 130 | Cherry Creek 5 | 80291001672 | 2897 | Falcon Creek Middle School | Regular School | No | Middle | 06 | 08 | 2021 | grade_7 | 160 | 27 | 58 | 5 | 25 | 1 | 27 | 153 | 150 | 303 | 160 | 27 | 58 | 5 | 25 | 1 | 27 | 153 | 150 | 303 | ||||||||||||||||||||||||||||||||||
1746189 | 1746189 | CO | school | 804800 | 1420 | Jefferson County R-1 | 80480000698 | 694 | Bell Middle School | Regular School | No | Middle | 06 | 08 | 2021 | grade_7 | 222 | 3 | 56 | 4 | 4 | 1 | 11 | 169 | 132 | 301 | 222 | 3 | 56 | 4 | 4 | 1 | 11 | 169 | 132 | 301 | ||||||||||||||||||||||||||||||||||
1746368 | 1746368 | CO | school | 804800 | 1420 | Jefferson County R-1 | 80480000713 | 2300 | Dunstan Middle School | Regular School | No | Middle | 06 | 08 | 2021 | grade_7 | 205 | 5 | 63 | 4 | 10 | 0 | 13 | 153 | 147 | 300 | 205 | 5 | 63 | 4 | 10 | 0 | 13 | 153 | 147 | 300 | ||||||||||||||||||||||||||||||||||
1748107 | 1748107 | CO | school | 805400 | 1560 | Thompson R2-J | 80540001655 | 5335 | Lucile Erwin Middle School | Regular School | No | Middle | 06 | 08 | 2021 | grade_7 | 195 | 0 | 89 | 0 | 1 | 0 | 13 | 168 | 130 | 298 | 195 | 0 | 89 | 0 | 1 | 0 | 13 | 168 | 130 | 298 | ||||||||||||||||||||||||||||||||||
1738647 | 1738647 | CO | school | 806900 | 20 | Adams 12 Five Star Schools | 80690001187 | 6398 | Northglenn Middle School | Regular School | No | Middle | 06 | 08 | 2021 | grade_7 | 50 | 4 | 230 | 2 | 8 | 0 | 3 | 181 | 116 | 297 | 50 | 4 | 230 | 2 | 8 | 0 | 3 | 181 | 116 | 297 | ||||||||||||||||||||||||||||||||||
1745024 | 1745024 | CO | school | 801920 | 1040 | Academy 20 | 80192006788 | 1421 | Chinook Trail Middle School | Regular School | No | Middle | 06 | 08 | 2021 | grade_7 | 199 | 5 | 38 | 1 | 26 | 0 | 26 | 152 | 143 | 295 | 199 | 5 | 38 | 1 | 26 | 0 | 26 | 152 | 143 | 295 | ||||||||||||||||||||||||||||||||||
1745472 | 1745472 | CO | school | 803870 | 1110 | District 49 | 80387000506 | 2906 | Falcon Middle School | Regular School | No | Middle | 06 | 08 | 2021 | grade_7 | 173 | 14 | 67 | 2 | 9 | 0 | 30 | 159 | 136 | 295 | 173 | 14 | 67 | 2 | 9 | 0 | 30 | 159 | 136 | 295 | ||||||||||||||||||||||||||||||||||
1745147 | 1745147 | CO | school | 801920 | 1040 | Academy 20 | 80192001593 | 6140 | Mountain Ridge Middle School | Regular School | No | Middle | 06 | 08 | 2021 | grade_7 | 185 | 9 | 60 | 0 | 13 | 3 | 20 | 141 | 149 | 290 | 185 | 9 | 60 | 0 | 13 | 3 | 20 | 141 | 149 | 290 | ||||||||||||||||||||||||||||||||||
1750648 | 1750648 | CO | school | 804830 | 3110 | Johnstown-Milliken RE-5J | 80483000809 | 5902 | Milliken Middle School | Regular School | No | Middle | 06 | 08 | 2021 | grade_7 | 194 | 0 | 84 | 0 | 5 | 0 | 6 | 137 | 152 | 289 | 194 | 0 | 84 | 0 | 5 | 0 | 6 | 137 | 152 | 289 | ||||||||||||||||||||||||||||||||||
1744902 | 1744902 | CO | school | 802940 | 1020 | Cheyenne Mountain 12 | 80294000209 | 1588 | Cheyenne Mountain Junior High School | Regular School | No | Middle | 07 | 08 | 2021 | grade_7 | 209 | 3 | 43 | 0 | 13 | 2 | 15 | 139 | 146 | 285 | 209 | 3 | 43 | 0 | 13 | 2 | 15 | 139 | 146 | 285 | ||||||||||||||||||||||||||||||||||
1740250 | 1740250 | CO | school | 802340 | 180 | Adams-Arapahoe 28J | 80234000073 | 6160 | Mrachek Middle School | Regular School | No | Middle | 06 | 08 | 2021 | grade_7 | 41 | 55 | 150 | 3 | 11 | 5 | 18 | 144 | 139 | 283 | 41 | 55 | 150 | 3 | 11 | 5 | 18 | 144 | 139 | 283 | ||||||||||||||||||||||||||||||||||
1746603 | 1746603 | CO | school | 804800 | 1420 | Jefferson County R-1 | 80480000742 | 4548 | Ken Caryl Middle School | Regular School | No | Middle | 06 | 08 | 2021 | grade_7 | 209 | 5 | 48 | 0 | 7 | 0 | 14 | 151 | 132 | 283 | 209 | 5 | 48 | 0 | 7 | 0 | 14 | 151 | 132 | 283 | ||||||||||||||||||||||||||||||||||
1738627 | 1738627 | CO | school | 806900 | 20 | Adams 12 Five Star Schools | 80690001186 | 6342 | Shadow Ridge Middle School | Regular School | No | Middle | 06 | 08 | 2021 | grade_7 | 127 | 4 | 121 | 0 | 13 | 0 | 14 | 152 | 127 | 279 | 127 | 4 | 121 | 0 | 13 | 0 | 14 | 152 | 127 | 279 | ||||||||||||||||||||||||||||||||||
1750280 | 1750280 | CO | school | 806810 | 3000 | Summit RE-1 | 80681001400 | 8377 | Summit Middle School | Regular School | No | Middle | 06 | 08 | 2021 | grade_7 | 155 | 1 | 110 | 0 | 2 | 0 | 11 | 149 | 130 | 279 | 155 | 1 | 110 | 0 | 2 | 0 | 11 | 149 | 130 | 279 | ||||||||||||||||||||||||||||||||||
1744699 | 1744699 | CO | school | 803060 | 1010 | Colorado Springs 11 | 80306001683 | 4424 | Jenkins Middle School | Regular School | No | Middle | 06 | 08 | 2021 | grade_7 | 162 | 27 | 56 | 0 | 2 | 1 | 29 | 152 | 125 | 277 | 162 | 27 | 56 | 0 | 2 | 1 | 29 | 152 | 125 | 277 | ||||||||||||||||||||||||||||||||||
1746324 | 1746324 | CO | school | 804800 | 1420 | Jefferson County R-1 | 80480000708 | 1976 | Creighton Middle School | Regular School | No | Middle | 06 | 08 | 2021 | grade_7 | 103 | 4 | 145 | 2 | 7 | 2 | 14 | 140 | 137 | 277 | 103 | 4 | 145 | 2 | 7 | 2 | 14 | 140 | 137 | 277 | ||||||||||||||||||||||||||||||||||
1740725 | 1740725 | CO | school | 805370 | 470 | St Vrain Valley RE1J | 80537001886 | 226 | Altona Middle School | Regular School | No | Middle | 06 | 08 | 2021 | grade_7 | 197 | 2 | 46 | 1 | 20 | 0 | 10 | 152 | 124 | 276 | 197 | 2 | 46 | 1 | 20 | 0 | 10 | 152 | 124 | 276 | ||||||||||||||||||||||||||||||||||
1749733 | 1749733 | CO | school | 806120 | 2690 | Pueblo City 60 | 80612001067 | 9188 | W H Heaton Middle School | Regular School | No | Middle | 06 | 08 | 2021 | grade_7 | 58 | 9 | 198 | 1 | 1 | 1 | 7 | 147 | 128 | 275 | 58 | 9 | 198 | 1 | 1 | 1 | 7 | 147 | 128 | 275 | ||||||||||||||||||||||||||||||||||
1739729 | 1739729 | CO | school | 802910 | 130 | Cherry Creek 5 | 80291006728 | 7514 | Infinity Middle School | Regular School | No | Middle | 06 | 08 | 2021 | grade_7 | 169 | 19 | 36 | 0 | 25 | 0 | 25 | 137 | 137 | 274 | 169 | 19 | 36 | 0 | 25 | 0 | 25 | 137 | 137 | 274 | ||||||||||||||||||||||||||||||||||
1747941 | 1747941 | CO | school | 803990 | 1550 | Poudre R-1 | 80399006162 | 9330 | Webber Middle School | Regular School | No | Middle | 06 | 08 | 2021 | grade_7 | 218 | 2 | 40 | 1 | 1 | 1 | 11 | 143 | 131 | 274 | 218 | 2 | 40 | 1 | 1 | 1 | 11 | 143 | 131 | 274 | ||||||||||||||||||||||||||||||||||
1748597 | 1748597 | CO | school | 804350 | 2000 | Mesa County Valley 51 | 80435000608 | 3244 | Fruita Middle School | Regular School | No | Middle | 06 | 07 | 2021 | grade_7 | 220 | 2 | 40 | 0 | 2 | 0 | 9 | 141 | 132 | 273 | 220 | 2 | 40 | 0 | 2 | 0 | 9 | 141 | 132 | 273 | ||||||||||||||||||||||||||||||||||
1740802 | 1740802 | CO | school | 805370 | 470 | St Vrain Valley RE1J | 80537000900 | 2760 | Erie Middle School | Regular School | No | Middle | 06 | 08 | 2021 | grade_7 | 225 | 4 | 32 | 0 | 9 | 0 | 2 | 141 | 131 | 272 | 225 | 4 | 32 | 0 | 9 | 0 | 2 | 141 | 131 | 272 | ||||||||||||||||||||||||||||||||||
1747734 | 1747734 | CO | school | 803990 | 1550 | Poudre R-1 | 80399001849 | 4698 | Kinard Core Knowledge Middle School | Regular School | No | Middle | 06 | 08 | 2021 | grade_7 | 204 | 3 | 24 | 1 | 22 | 1 | 16 | 136 | 135 | 271 | 204 | 3 | 24 | 1 | 22 | 1 | 16 | 136 | 135 | 271 | ||||||||||||||||||||||||||||||||||
1740841 | 1740841 | CO | school | 805370 | 470 | St Vrain Valley RE1J | 80537001774 | 3194 | Coal Ridge Middle School | Regular School | No | Middle | 06 | 08 | 2021 | grade_7 | 196 | 1 | 56 | 0 | 6 | 0 | 11 | 136 | 134 | 270 | 196 | 1 | 56 | 0 | 6 | 0 | 11 | 136 | 134 | 270 | ||||||||||||||||||||||||||||||||||
1742438 | 1742438 | CO | school | 803360 | 880 | Denver County 1 | 80336000364 | 3990 | Hill Campus of Arts and Sciences | Regular School | No | Middle | 06 | 08 | 2021 | grade_7 | 124 | 49 | 69 | 0 | 8 | 1 | 15 | 129 | 137 | 266 | 124 | 49 | 69 | 0 | 8 | 1 | 15 | 129 | 137 | 266 | ||||||||||||||||||||||||||||||||||
1744811 | 1744811 | CO | school | 803060 | 1010 | Colorado Springs 11 | 80306000234 | 7556 | Sabin Middle School | Regular School | No | Middle | 06 | 08 | 2021 | grade_7 | 111 | 16 | 99 | 0 | 6 | 1 | 28 | 147 | 114 | 261 | 111 | 16 | 99 | 0 | 6 | 1 | 28 | 147 | 114 | 261 | ||||||||||||||||||||||||||||||||||
1747754 | 1747754 | CO | school | 803990 | 1550 | Poudre R-1 | 80399001408 | 5068 | Lesher Middle School | Regular School | No | Middle | 06 | 08 | 2021 | grade_7 | 176 | 1 | 62 | 0 | 7 | 0 | 12 | 153 | 105 | 258 | 176 | 1 | 62 | 0 | 7 | 0 | 12 | 153 | 105 | 258 | ||||||||||||||||||||||||||||||||||
1738959 | 1738959 | CO | school | 802580 | 40 | School District 27J | 80258006420 | 6702 | Otho E Stuart Middle School | Regular School | No | Middle | 06 | 08 | 2021 | grade_7 | 112 | 18 | 101 | 1 | 14 | 0 | 11 | 140 | 117 | 257 | 112 | 18 | 101 | 1 | 14 | 0 | 11 | 140 | 117 | 257 | ||||||||||||||||||||||||||||||||||
1740520 | 1740520 | CO | school | 802700 | 190 | Byers 32J | 80270006755 | 9033 | Astravo Online Academy Middle School | Regular School | Yes | Middle | 06 | 08 | 2021 | grade_7 | 157 | 20 | 71 | 0 | 5 | 3 | 0 | 119 | 137 | 256 | 157 | 20 | 71 | 0 | 5 | 3 | 0 | 119 | 137 | 256 | ||||||||||||||||||||||||||||||||||
1740120 | 1740120 | CO | school | 802340 | 180 | Adams-Arapahoe 28J | 80234000060 | 2384 | East Middle School | Regular School | No | Middle | 06 | 08 | 2021 | grade_7 | 6 | 28 | 198 | 3 | 8 | 3 | 6 | 135 | 117 | 252 | 6 | 28 | 198 | 3 | 8 | 3 | 6 | 135 | 117 | 252 | ||||||||||||||||||||||||||||||||||
1747458 | 1747458 | CO | school | 803480 | 1520 | Durango 9-R | 80348006696 | 1526 | Colorado Connections Academy @ Durango | Regular School | No | Other | KG | 12 | 2021 | grade_7 | 158 | 11 | 59 | 0 | 6 | 1 | 17 | 130 | 122 | 252 | 158 | 11 | 59 | 0 | 6 | 1 | 17 | 130 | 122 | 252 | ||||||||||||||||||||||||||||||||||
1739832 | 1739832 | CO | school | 805310 | 140 | Littleton 6 | 80531000876 | 2804 | Euclid Middle School | Regular School | No | Middle | 06 | 08 | 2021 | grade_7 | 189 | 2 | 46 | 2 | 1 | 2 | 9 | 139 | 112 | 251 | 189 | 2 | 46 | 2 | 1 | 2 | 9 | 139 | 112 | 251 | ||||||||||||||||||||||||||||||||||
1745486 | 1745486 | CO | school | 803870 | 1110 | District 49 | 80387001393 | 4102 | Horizon Middle School | Regular School | No | Middle | 06 | 08 | 2021 | grade_7 | 121 | 17 | 74 | 0 | 6 | 0 | 33 | 113 | 138 | 251 | 121 | 17 | 74 | 0 | 6 | 0 | 33 | 113 | 138 | 251 | ||||||||||||||||||||||||||||||||||
1745075 | 1745075 | CO | school | 801920 | 1040 | Academy 20 | 80192006616 | 1921 | Discovery Canyon Campus Middle School | Regular School | No | Middle | 06 | 08 | 2021 | grade_7 | 176 | 12 | 32 | 0 | 15 | 1 | 14 | 122 | 128 | 250 | 176 | 12 | 32 | 0 | 15 | 1 | 14 | 122 | 128 | 250 | ||||||||||||||||||||||||||||||||||
1743709 | 1743709 | CO | school | 803450 | 900 | Douglas County Re 1 | 80345000443 | 6772 | Sagewood Middle School | Regular School | No | Middle | 06 | 08 | 2021 | grade_7 | 196 | 4 | 35 | 3 | 2 | 0 | 8 | 137 | 111 | 248 | 196 | 4 | 35 | 3 | 2 | 0 | 8 | 137 | 111 | 248 | ||||||||||||||||||||||||||||||||||
1739863 | 1739863 | CO | school | 805310 | 140 | Littleton 6 | 80531001351 | 4447 | John Wesley Powell Middle School | Regular School | No | Middle | 06 | 08 | 2021 | grade_7 | 183 | 5 | 32 | 0 | 10 | 1 | 16 | 128 | 119 | 247 | 183 | 5 | 32 | 0 | 10 | 1 | 16 | 128 | 119 | 247 | ||||||||||||||||||||||||||||||||||
1738787 | 1738787 | CO | school | 801950 | 30 | Adams County 14 | 80195000009 | 20 | Adams City Middle School | Regular School | No | Middle | 06 | 08 | 2021 | grade_7 | 22 | 3 | 216 | 1 | 0 | 0 | 3 | 134 | 111 | 245 | 22 | 3 | 216 | 1 | 0 | 0 | 3 | 134 | 111 | 245 | ||||||||||||||||||||||||||||||||||
1743258 | 1743258 | CO | school | 803450 | 900 | Douglas County Re 1 | 80345001896 | 215 | American Academy | Regular School | Yes | Elementary | PK | 08 | 2021 | grade_7 | 167 | 1 | 22 | 1 | 35 | 0 | 18 | 129 | 115 | 244 | 167 | 1 | 22 | 1 | 35 | 0 | 18 | 129 | 115 | 244 | ||||||||||||||||||||||||||||||||||
1746239 | 1746239 | CO | school | 804800 | 1420 | Jefferson County R-1 | 80480000703 | 1318 | Carmody Middle School | Regular School | No | Middle | 06 | 08 | 2021 | grade_7 | 122 | 4 | 96 | 1 | 9 | 1 | 11 | 128 | 116 | 244 | 122 | 4 | 96 | 1 | 9 | 1 | 11 | 128 | 116 | 244 | ||||||||||||||||||||||||||||||||||
1738824 | 1738824 | CO | school | 801950 | 30 | Adams County 14 | 80195000015 | 4516 | Kearney Middle School | Regular School | No | Middle | 06 | 08 | 2021 | grade_7 | 26 | 2 | 212 | 1 | 0 | 0 | 1 | 128 | 114 | 242 | 26 | 2 | 212 | 1 | 0 | 0 | 1 | 128 | 114 | 242 | ||||||||||||||||||||||||||||||||||
1746844 | 1746844 | CO | school | 804800 | 1420 | Jefferson County R-1 | 80480001283 | 6470 | Oberon Junior High School | Regular School | No | Middle | 06 | 08 | 2021 | grade_7 | 188 | 3 | 42 | 0 | 4 | 0 | 5 | 108 | 134 | 242 | 188 | 3 | 42 | 0 | 4 | 0 | 5 | 108 | 134 | 242 | ||||||||||||||||||||||||||||||||||
1740031 | 1740031 | CO | school | 802340 | 180 | Adams-Arapahoe 28J | 80234000054 | 464 | Aurora Hills Middle School | Regular School | No | Middle | 06 | 08 | 2021 | grade_7 | 19 | 50 | 139 | 1 | 12 | 6 | 14 | 126 | 115 | 241 | 19 | 50 | 139 | 1 | 12 | 6 | 14 | 126 | 115 | 241 | ||||||||||||||||||||||||||||||||||
1750779 | 1750779 | CO | school | 804410 | 3120 | Greeley 6 | 80441000642 | 3880 | Heath Middle School | Regular School | No | Middle | 06 | 08 | 2021 | grade_7 | 41 | 14 | 167 | 2 | 11 | 1 | 3 | 124 | 115 | 239 | 41 | 14 | 167 | 2 | 11 | 1 | 3 | 124 | 115 | 239 | ||||||||||||||||||||||||||||||||||
1742416 | 1742416 | CO | school | 803360 | 880 | Denver County 1 | 80336000361 | 3746 | Hamilton Middle School | Regular School | No | Middle | 06 | 08 | 2021 | grade_7 | 58 | 38 | 120 | 0 | 6 | 1 | 13 | 108 | 128 | 236 | 58 | 38 | 120 | 0 | 6 | 1 | 13 | 108 | 128 | 236 | ||||||||||||||||||||||||||||||||||
1742941 | 1742941 | CO | school | 803360 | 880 | Denver County 1 | 80336000403 | 7942 | Skinner Middle School | Regular School | No | Middle | 06 | 08 | 2021 | grade_7 | 86 | 4 | 137 | 0 | 2 | 0 | 5 | 128 | 106 | 234 | 86 | 4 | 137 | 0 | 2 | 0 | 5 | 128 | 106 | 234 | ||||||||||||||||||||||||||||||||||
1748626 | 1748626 | CO | school | 804350 | 2000 | Mesa County Valley 51 | 80435001656 | 3584 | Grand Mesa Middle School | Regular School | No | Middle | 06 | 08 | 2021 | grade_7 | 135 | 0 | 85 | 0 | 1 | 1 | 11 | 127 | 106 | 233 | 135 | 0 | 85 | 0 | 1 | 1 | 11 | 127 | 106 | 233 | ||||||||||||||||||||||||||||||||||
1739031 | 1739031 | CO | school | 802580 | 40 | School District 27J | 80258000152 | 9230 | Vikan Middle School | Regular School | No | Middle | 06 | 08 | 2021 | grade_7 | 59 | 4 | 164 | 0 | 0 | 0 | 5 | 150 | 82 | 232 | 59 | 4 | 164 | 0 | 0 | 0 | 5 | 150 | 82 | 232 | ||||||||||||||||||||||||||||||||||
1750691 | 1750691 | CO | school | 804410 | 3120 | Greeley 6 | 80441000634 | 988 | Brentwood Middle School | Regular School | No | Middle | 06 | 08 | 2021 | grade_7 | 54 | 4 | 161 | 1 | 7 | 0 | 4 | 123 | 108 | 231 | 54 | 4 | 161 | 1 | 7 | 0 | 4 | 123 | 108 | 231 | ||||||||||||||||||||||||||||||||||
1739843 | 1739843 | CO | school | 805310 | 140 | Littleton 6 | 80531000879 | 3472 | Goddard Middle School | Regular School | No | Middle | 06 | 08 | 2021 | grade_7 | 129 | 0 | 80 | 1 | 7 | 0 | 12 | 123 | 106 | 229 | 129 | 0 | 80 | 1 | 7 | 0 | 12 | 123 | 106 | 229 | ||||||||||||||||||||||||||||||||||
1741071 | 1741071 | CO | school | 805370 | 470 | St Vrain Valley RE1J | 80537006198 | 9430 | Westview Middle School | Regular School | No | Middle | 06 | 08 | 2021 | grade_7 | 177 | 1 | 41 | 1 | 2 | 0 | 7 | 129 | 100 | 229 | 177 | 1 | 41 | 1 | 2 | 0 | 7 | 129 | 100 | 229 | ||||||||||||||||||||||||||||||||||
1749737 | 1749737 | CO | school | 806150 | 2700 | Pueblo County 70 | 80615001714 | 25 | Sky View Middle School | Regular School | No | Middle | 06 | 08 | 2021 | grade_7 | 140 | 2 | 69 | 0 | 1 | 0 | 16 | 120 | 108 | 228 | 140 | 2 | 69 | 0 | 1 | 0 | 16 | 120 | 108 | 228 | ||||||||||||||||||||||||||||||||||
1750599 | 1750599 | CO | school | 807350 | 3100 | Windsor RE-4 | 80735001265 | 9670 | Windsor Middle School | Regular School | No | Middle | 06 | 08 | 2021 | grade_7 | 190 | 1 | 29 | 0 | 0 | 0 | 7 | 120 | 107 | 227 | 190 | 1 | 29 | 0 | 0 | 0 | 7 | 120 | 107 | 227 | ||||||||||||||||||||||||||||||||||
1750044 | 1750044 | CO | school | 806660 | 2770 | Steamboat Springs RE-2 | 80666001146 | 8210 | Steamboat Springs Middle School | Regular School | No | Middle | 06 | 08 | 2021 | grade_7 | 178 | 4 | 38 | 0 | 4 | 1 | 1 | 115 | 111 | 226 | 178 | 4 | 38 | 0 | 4 | 1 | 1 | 115 | 111 | 226 | ||||||||||||||||||||||||||||||||||
1749109 | 1749109 | CO | school | 804050 | 2405 | Fort Morgan Re-3 | 80405001281 | 3074 | Fort Morgan Middle School | Regular School | No | Middle | 06 | 08 | 2021 | grade_7 | 70 | 12 | 139 | 2 | 0 | 0 | 2 | 110 | 115 | 225 | 70 | 12 | 139 | 2 | 0 | 0 | 2 | 110 | 115 | 225 | ||||||||||||||||||||||||||||||||||
1738370 | 1738370 | CO | school | 805550 | 10 | Mapleton 1 | 80555006488 | 1796 | Colorado Connections Academy | Regular School | No | Other | KG | 12 | 2021 | grade_7 | 141 | 16 | 46 | 2 | 3 | 0 | 16 | 128 | 96 | 224 | 141 | 16 | 46 | 2 | 3 | 0 | 16 | 128 | 96 | 224 | ||||||||||||||||||||||||||||||||||
1744433 | 1744433 | CO | school | 804080 | 1000 | Fountain 8 | 80408000561 | 1332 | Carson Middle School | Regular School | No | Middle | 06 | 08 | 2021 | grade_7 | 110 | 32 | 50 | 1 | 2 | 5 | 24 | 116 | 108 | 224 | 110 | 32 | 50 | 1 | 2 | 5 | 24 | 116 | 108 | 224 | ||||||||||||||||||||||||||||||||||
1747656 | 1747656 | CO | school | 803990 | 1550 | Poudre R-1 | 80399000523 | 898 | Boltz Middle School | Regular School | No | Middle | 06 | 08 | 2021 | grade_7 | 145 | 1 | 62 | 2 | 2 | 0 | 11 | 109 | 114 | 223 | 145 | 1 | 62 | 2 | 2 | 0 | 11 | 109 | 114 | 223 | ||||||||||||||||||||||||||||||||||
1746132 | 1746132 | CO | school | 804800 | 1420 | Jefferson County R-1 | 80480000691 | 108 | Alameda International Junior/Senior High School | Regular School | No | High | 07 | 12 | 2021 | grade_7 | 26 | 4 | 171 | 3 | 10 | 1 | 7 | 119 | 103 | 222 | 26 | 4 | 171 | 3 | 10 | 1 | 7 | 119 | 103 | 222 | ||||||||||||||||||||||||||||||||||
1746726 | 1746726 | CO | school | 804800 | 1420 | Jefferson County R-1 | 80480001746 | 5472 | Manning Options School | Regular School | No | Middle | 06 | 08 | 2021 | grade_7 | 177 | 2 | 29 | 1 | 5 | 0 | 8 | 98 | 124 | 222 | 177 | 2 | 29 | 1 | 5 | 0 | 8 | 98 | 124 | 222 | ||||||||||||||||||||||||||||||||||
1740081 | 1740081 | CO | school | 802340 | 180 | Adams-Arapahoe 28J | 80234001322 | 1800 | Columbia Middle School | Regular School | No | Middle | 06 | 08 | 2021 | grade_7 | 47 | 35 | 111 | 1 | 9 | 0 | 18 | 118 | 103 | 221 | 47 | 35 | 111 | 1 | 9 | 0 | 18 | 118 | 103 | 221 | ||||||||||||||||||||||||||||||||||
1740354 | 1740354 | CO | school | 802340 | 180 | Adams-Arapahoe 28J | 80234000079 | 8078 | South Middle School | Regular School | No | Middle | 06 | 08 | 2021 | grade_7 | 17 | 29 | 155 | 3 | 6 | 4 | 7 | 108 | 113 | 221 | 17 | 29 | 155 | 3 | 6 | 4 | 7 | 108 | 113 | 221 | ||||||||||||||||||||||||||||||||||
1740493 | 1740493 | CO | school | 802700 | 190 | Byers 32J | 80270006759 | 2793 | Astravo Academy Middle School | Regular School | Yes | Middle | 06 | 08 | 2021 | grade_7 | 161 | 8 | 33 | 3 | 11 | 1 | 0 | 114 | 103 | 217 | 161 | 8 | 33 | 3 | 11 | 1 | 0 | 114 | 103 | 217 | ||||||||||||||||||||||||||||||||||
1744347 | 1744347 | CO | school | 806480 | 990 | Widefield 3 | 80648001120 | 4394 | Janitell Junior High School | Regular School | No | Middle | 06 | 08 | 2021 | grade_7 | 106 | 15 | 63 | 1 | 3 | 4 | 24 | 112 | 104 | 216 | 106 | 15 | 63 | 1 | 3 | 4 | 24 | 112 | 104 | 216 | ||||||||||||||||||||||||||||||||||
1746341 | 1746341 | CO | school | 804800 | 1420 | Jefferson County R-1 | 80480001315 | 2130 | Deer Creek Middle School | Regular School | No | Middle | 06 | 08 | 2021 | grade_7 | 181 | 4 | 18 | 0 | 7 | 0 | 6 | 104 | 112 | 216 | 181 | 4 | 18 | 0 | 7 | 0 | 6 | 104 | 112 | 216 | ||||||||||||||||||||||||||||||||||
1749655 | 1749655 | CO | school | 806120 | 2690 | Pueblo City 60 | 80612001055 | 5048 | Pueblo Academy of Arts | Regular School | No | Middle | 06 | 08 | 2021 | grade_7 | 42 | 4 | 160 | 0 | 2 | 0 | 6 | 112 | 102 | 214 | 42 | 4 | 160 | 0 | 2 | 0 | 6 | 112 | 102 | 214 | ||||||||||||||||||||||||||||||||||
1740446 | 1740446 | CO | school | 802340 | 180 | Adams-Arapahoe 28J | 80234000082 | 9396 | Aurora West College Preparatory Academy | Regular School | No | High | 06 | 12 | 2021 | grade_7 | 8 | 22 | 157 | 3 | 15 | 2 | 5 | 114 | 98 | 212 | 8 | 22 | 157 | 3 | 15 | 2 | 5 | 114 | 98 | 212 | ||||||||||||||||||||||||||||||||||
1745056 | 1745056 | CO | school | 801920 | 1040 | Academy 20 | 80192001931 | 1629 | The Classical Academy Middle School | Regular School | Yes | Middle | 07 | 08 | 2021 | grade_7 | 161 | 7 | 23 | 0 | 6 | 1 | 14 | 101 | 111 | 212 | 161 | 7 | 23 | 0 | 6 | 1 | 14 | 101 | 111 | 212 |
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]);