enrollments
Data source: Big Local News · About: Big Local
1,885 rows where grade = "pk_12_total", state = "CO" and year = 2017 sorted by ccd_school_low_grade
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
707818 | 707818 | CO | school | 10 | MAPLETON 1 | 0 | Not a school | 2017 | pk_12_total | 5 | 0 | 10 | 0 | 0 | 0 | 0 | 10 | 5 | 15 | 5 | 0 | 10 | 0 | 0 | 0 | 0 | 10 | 5 | 15 | |||||||||||||||||||||||||||||||||||||||||
708499 | 708499 | CO | school | 40 | SCHOOL DISTRICT 27J | 4034 | ELMWOOD BAPTIST SCHOOL | 2017 | pk_12_total | 2 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 2 | 2 | 2 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 2 | 2 | |||||||||||||||||||||||||||||||||||||||||
708647 | 708647 | CO | school | 70 | WESTMINSTER PUBLIC SCHOOLS | 0 | Not a school | 2017 | pk_12_total | 1 | 0 | 3 | 0 | 0 | 0 | 0 | 1 | 3 | 4 | 1 | 0 | 3 | 0 | 0 | 0 | 0 | 1 | 3 | 4 | |||||||||||||||||||||||||||||||||||||||||
709493 | 709493 | CO | school | 180 | ADAMS-ARAPAHOE 28J | 1 | FACILITIES WITH DISTRICT RUN EDUCATION | 2017 | pk_12_total | 7 | 3 | 4 | 0 | 0 | 0 | 2 | 9 | 7 | 16 | 7 | 3 | 4 | 0 | 0 | 0 | 2 | 9 | 7 | 16 | |||||||||||||||||||||||||||||||||||||||||
711230 | 711230 | CO | school | 870 | DELTA COUNTY 50(J) | 1980 | GREAT BEGINNINGS | 2017 | pk_12_total | 12 | 0 | 5 | 0 | 0 | 0 | 1 | 8 | 10 | 18 | 12 | 0 | 5 | 0 | 0 | 0 | 1 | 8 | 10 | 18 | |||||||||||||||||||||||||||||||||||||||||
711295 | 711295 | CO | school | 870 | DELTA COUNTY 50(J) | 4234 | LITTLE SPROUTS | 2017 | pk_12_total | 24 | 0 | 5 | 0 | 0 | 0 | 2 | 16 | 15 | 31 | 24 | 0 | 5 | 0 | 0 | 0 | 2 | 16 | 15 | 31 | |||||||||||||||||||||||||||||||||||||||||
715518 | 715518 | CO | school | 1420 | JEFFERSON COUNTY R-1 | 0 | Not a school | 2017 | pk_12_total | 10 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 6 | 10 | 10 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 6 | 10 | |||||||||||||||||||||||||||||||||||||||||
716936 | 716936 | CO | school | 1520 | DURANGO 9-R | 0 | Not a school | 2017 | pk_12_total | 12 | 0 | 8 | 5 | 1 | 0 | 1 | 20 | 7 | 27 | 12 | 0 | 8 | 5 | 1 | 0 | 1 | 20 | 7 | 27 | |||||||||||||||||||||||||||||||||||||||||
717071 | 717071 | CO | school | 1550 | POUDRE R-1 | 0 | Not a school | 2017 | pk_12_total | 6 | 0 | 5 | 0 | 0 | 0 | 0 | 8 | 3 | 11 | 6 | 0 | 5 | 0 | 0 | 0 | 0 | 8 | 3 | 11 | |||||||||||||||||||||||||||||||||||||||||
719076 | 719076 | CO | school | 2690 | PUEBLO CITY 60 | 0 | Not a school | 2017 | pk_12_total | 12 | 2 | 26 | 0 | 1 | 0 | 1 | 19 | 23 | 42 | 12 | 2 | 26 | 0 | 1 | 0 | 1 | 19 | 23 | 42 | |||||||||||||||||||||||||||||||||||||||||
719497 | 719497 | CO | school | 2730 | DEL NORTE C-7 | 0 | Not a school | 2017 | pk_12_total | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | |||||||||||||||||||||||||||||||||||||||||
720096 | 720096 | CO | school | 3100 | WINDSOR RE-4 | 0 | Not a school | 2017 | pk_12_total | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | |||||||||||||||||||||||||||||||||||||||||
721023 | 721023 | CO | school | 9999 | COLORADO DETENTION CENTER TOTAL | No school | COLORADO DETENTION CENTER TOTAL | 2017 | pk_12_total | 61 | 29 | 95 | 2 | 1 | 0 | 5 | 145 | 48 | 193 | 61 | 29 | 95 | 2 | 1 | 0 | 5 | 145 | 48 | 193 | |||||||||||||||||||||||||||||||||||||||||
711539 | 711539 | CO | school | 803360 | 880 | DENVER COUNTY 1 | 80336000331 | 1908 | CORY ELEMENTARY SCHOOL | Regular School | No | Elementary | 01 | 05 | 2017 | pk_12_total | 284 | 4 | 33 | 1 | 16 | 0 | 33 | 190 | 181 | 371 | 284 | 4 | 33 | 1 | 16 | 0 | 33 | 190 | 181 | 371 | ||||||||||||||||||||||||||||||||||
711793 | 711793 | CO | school | 803360 | 880 | DENVER COUNTY 1 | 80336001864 | 3340 | LENA ARCHULETA ELEMENTARY SCHOOL | Regular School | No | Elementary | 01 | 05 | 2017 | pk_12_total | 23 | 53 | 429 | 1 | 17 | 4 | 12 | 299 | 240 | 539 | 23 | 53 | 429 | 1 | 17 | 4 | 12 | 299 | 240 | 539 | ||||||||||||||||||||||||||||||||||
711863 | 711863 | CO | school | 803360 | 880 | DENVER COUNTY 1 | 80336001739 | 3647 | MARIE L. GREENWOOD ACADEMY | Regular School | No | Elementary | 01 | 08 | 2017 | pk_12_total | 12 | 64 | 503 | 3 | 10 | 0 | 9 | 294 | 307 | 601 | 12 | 64 | 503 | 3 | 10 | 0 | 9 | 294 | 307 | 601 | ||||||||||||||||||||||||||||||||||
718676 | 718676 | CO | school | 804050 | 2405 | FORT MORGAN RE-3 | 80405006698 | 1009 | BAKER ELEMENTARY SCHOOL | Regular School | No | Elementary | 01 | 05 | 2017 | pk_12_total | 77 | 11 | 199 | 2 | 0 | 1 | 5 | 152 | 143 | 295 | 77 | 11 | 199 | 2 | 0 | 1 | 5 | 152 | 143 | 295 | ||||||||||||||||||||||||||||||||||
718682 | 718682 | CO | school | 804050 | 2405 | FORT MORGAN RE-3 | 80405000556 | 1850 | COLUMBINE ELEMENTARY SCHOOL | Regular School | No | Elementary | 01 | 05 | 2017 | pk_12_total | 80 | 4 | 153 | 3 | 0 | 0 | 7 | 135 | 112 | 247 | 80 | 4 | 153 | 3 | 0 | 0 | 7 | 135 | 112 | 247 | ||||||||||||||||||||||||||||||||||
718697 | 718697 | CO | school | 804050 | 2405 | FORT MORGAN RE-3 | 80405000558 | 3620 | GREEN ACRES ELEMENTARY SCHOOL | Regular School | No | Elementary | 01 | 05 | 2017 | pk_12_total | 126 | 8 | 192 | 0 | 2 | 0 | 7 | 177 | 158 | 335 | 126 | 8 | 192 | 0 | 2 | 0 | 7 | 177 | 158 | 335 | ||||||||||||||||||||||||||||||||||
718708 | 718708 | CO | school | 804050 | 2405 | FORT MORGAN RE-3 | 80405006298 | 6954 | PIONEER ELEMENTARY SCHOOL | Regular School | No | Elementary | 01 | 05 | 2017 | pk_12_total | 64 | 28 | 199 | 4 | 0 | 0 | 1 | 144 | 152 | 296 | 64 | 28 | 199 | 4 | 0 | 0 | 1 | 144 | 152 | 296 | ||||||||||||||||||||||||||||||||||
719527 | 719527 | CO | school | 805760 | 2740 | MONTE VISTA C-8 | 80576000985 | 6036 | BILL METZ ELEMENTARY SCHOOL | Regular School | No | Elementary | 01 | 05 | 2017 | pk_12_total | 100 | 0 | 300 | 5 | 0 | 0 | 3 | 200 | 208 | 408 | 100 | 0 | 300 | 5 | 0 | 0 | 3 | 200 | 208 | 408 | ||||||||||||||||||||||||||||||||||
715328 | 715328 | CO | school | 804380 | 1220 | GARFIELD 16 | 80438000630 | 3578 | BEA UNDERWOOD ELEMENTARY SCHOOL | Regular School | No | Elementary | 02 | 05 | 2017 | pk_12_total | 200 | 1 | 123 | 2 | 1 | 1 | 9 | 166 | 171 | 337 | 200 | 1 | 123 | 2 | 1 | 1 | 9 | 166 | 171 | 337 | ||||||||||||||||||||||||||||||||||
717768 | 717768 | CO | school | 806960 | 1580 | TRINIDAD 1 | 80696001946 | 2944 | FISHER'S PEAK ELEMENTARY SCHOOL | Regular School | No | Elementary | 02 | 05 | 2017 | pk_12_total | 86 | 8 | 264 | 3 | 0 | 0 | 2 | 196 | 167 | 363 | 86 | 8 | 264 | 3 | 0 | 0 | 2 | 196 | 167 | 363 | ||||||||||||||||||||||||||||||||||
708877 | 708877 | CO | school | 806540 | 123 | SHERIDAN 2 | 80654001135 | 7837 | FORT LOGAN NORTHGATE | Regular School | No | Elementary | 03 | 08 | 2017 | pk_12_total | 77 | 22 | 472 | 4 | 11 | 2 | 14 | 300 | 302 | 602 | 77 | 22 | 472 | 4 | 11 | 2 | 14 | 300 | 302 | 602 | ||||||||||||||||||||||||||||||||||
712971 | 712971 | CO | school | 803450 | 900 | DOUGLAS COUNTY RE 1 | 80345006299 | 2954 | ROXBOROUGH INTERMEDIATE | Regular School | No | Elementary | 03 | 06 | 2017 | pk_12_total | 366 | 2 | 72 | 1 | 5 | 0 | 14 | 232 | 228 | 460 | 366 | 2 | 72 | 1 | 5 | 0 | 14 | 232 | 228 | 460 | ||||||||||||||||||||||||||||||||||
713191 | 713191 | CO | school | 803450 | 900 | DOUGLAS COUNTY RE 1 | 80345000442 | 6396 | NORTHEAST ELEMENTARY SCHOOL | Regular School | No | Elementary | 03 | 05 | 2017 | pk_12_total | 311 | 5 | 34 | 1 | 3 | 0 | 21 | 204 | 171 | 375 | 311 | 5 | 34 | 1 | 3 | 0 | 21 | 204 | 171 | 375 | ||||||||||||||||||||||||||||||||||
715619 | 715619 | CO | school | 804800 | 1420 | JEFFERSON COUNTY R-1 | 80480001603 | 779 | BERGEN VALLEY INTERMEDIATE SCHOOL | Regular School | No | Elementary | 03 | 05 | 2017 | pk_12_total | 265 | 1 | 16 | 1 | 3 | 0 | 8 | 144 | 150 | 294 | 265 | 1 | 16 | 1 | 3 | 0 | 8 | 144 | 150 | 294 | ||||||||||||||||||||||||||||||||||
716919 | 716919 | CO | school | 805190 | 1510 | LAKE COUNTY R-1 | 80519000855 | 4901 | LAKE COUNTY INTERMEDIATE SCHOOL | Regular School | No | Elementary | 03 | 06 | 2017 | pk_12_total | 71 | 2 | 222 | 2 | 1 | 0 | 4 | 158 | 144 | 302 | 71 | 2 | 222 | 2 | 1 | 0 | 4 | 158 | 144 | 302 | ||||||||||||||||||||||||||||||||||
717933 | 717933 | CO | school | 806690 | 1828 | VALLEY RE-1 | 80669006323 | 1321 | CAMPBELL ELEMENTARY SCHOOL | Regular School | No | Elementary | 03 | 05 | 2017 | pk_12_total | 274 | 8 | 123 | 2 | 2 | 0 | 12 | 209 | 212 | 421 | 274 | 8 | 123 | 2 | 2 | 0 | 12 | 209 | 212 | 421 | ||||||||||||||||||||||||||||||||||
718665 | 718665 | CO | school | 802610 | 2395 | BRUSH RE-2(J) | 80261000155 | 1438 | BEAVER VALLEY ELEMENTARY SCHOOL | Regular School | No | Elementary | 03 | 06 | 2017 | pk_12_total | 223 | 3 | 216 | 2 | 3 | 1 | 8 | 234 | 222 | 456 | 223 | 3 | 216 | 2 | 3 | 1 | 8 | 234 | 222 | 456 | ||||||||||||||||||||||||||||||||||
718749 | 718749 | CO | school | 805130 | 2520 | EAST OTERO R-1 | 80513001974 | 4841 | LA JUNTA INTERMEDIATE SCHOOL | Regular School | No | Elementary | 03 | 06 | 2017 | pk_12_total | 132 | 6 | 310 | 3 | 1 | 5 | 2 | 241 | 218 | 459 | 132 | 6 | 310 | 3 | 1 | 5 | 2 | 241 | 218 | 459 | ||||||||||||||||||||||||||||||||||
718765 | 718765 | CO | school | 806270 | 2530 | ROCKY FORD R-2 | 80627001101 | 5114 | JEFFERSON INTERMEDIATE SCHOOL | Regular School | No | Elementary | 03 | 06 | 2017 | pk_12_total | 57 | 0 | 180 | 1 | 0 | 0 | 1 | 113 | 126 | 239 | 57 | 0 | 180 | 1 | 0 | 0 | 1 | 113 | 126 | 239 | ||||||||||||||||||||||||||||||||||
719036 | 719036 | CO | school | 805220 | 2660 | LAMAR RE-2 | 80522000864 | 6794 | PARKVIEW ELEMENTARY SCHOOL | Regular School | No | Elementary | 03 | 05 | 2017 | pk_12_total | 104 | 1 | 184 | 1 | 1 | 0 | 3 | 154 | 140 | 294 | 104 | 1 | 184 | 1 | 1 | 0 | 3 | 154 | 140 | 294 | ||||||||||||||||||||||||||||||||||
719730 | 719730 | CO | school | 806870 | 2830 | TELLURIDE R-1 | 80687001170 | 8786 | TELLURIDE INTERMEDIATE SCHOOL | Regular School | No | Elementary | 03 | 06 | 2017 | pk_12_total | 250 | 2 | 50 | 1 | 1 | 0 | 5 | 170 | 139 | 309 | 250 | 2 | 50 | 1 | 1 | 0 | 5 | 170 | 139 | 309 | ||||||||||||||||||||||||||||||||||
720028 | 720028 | CO | school | 803600 | 3085 | EATON RE-2 | 80360001986 | 754 | BENJAMIN EATON ELEMENTARY SCHOOL | Regular School | No | Elementary | 03 | 05 | 2017 | pk_12_total | 280 | 0 | 91 | 0 | 1 | 0 | 8 | 201 | 179 | 380 | 280 | 0 | 91 | 0 | 1 | 0 | 8 | 201 | 179 | 380 | ||||||||||||||||||||||||||||||||||
720109 | 720109 | CO | school | 807350 | 3100 | WINDSOR RE-4 | 80735001262 | 6750 | MOUNTAIN VIEW ELEMENTARY SCHOOL | Regular School | No | Elementary | 03 | 05 | 2017 | pk_12_total | 322 | 3 | 87 | 0 | 10 | 0 | 10 | 243 | 189 | 432 | 322 | 3 | 87 | 0 | 10 | 0 | 10 | 243 | 189 | 432 | ||||||||||||||||||||||||||||||||||
707947 | 707947 | CO | school | 805550 | 10 | MAPLETON 1 | 80555006672 | 3590 | GLOBAL INTERMEDIATE ACADEMY | Regular School | No | Elementary | 04 | 08 | 2017 | pk_12_total | 11 | 4 | 179 | 0 | 1 | 0 | 0 | 95 | 100 | 195 | 11 | 4 | 179 | 0 | 1 | 0 | 0 | 95 | 100 | 195 | ||||||||||||||||||||||||||||||||||
711179 | 711179 | CO | school | 803210 | 770 | CROWLEY COUNTY RE-1-J | 80321001519 | 2054 | CROWLEY COUNTY WARD INTERMEDIATE | Regular School | No | Elementary | 04 | 06 | 2017 | pk_12_total | 56 | 2 | 45 | 2 | 0 | 0 | 0 | 46 | 59 | 105 | 56 | 2 | 45 | 2 | 0 | 0 | 0 | 46 | 59 | 105 | ||||||||||||||||||||||||||||||||||
715640 | 715640 | CO | school | 804800 | 1420 | JEFFERSON COUNTY R-1 | 80480000913 | 952 | BRADFORD INTERMEDIATE SCHOOL | Regular School | No | Elementary | 04 | 07 | 2017 | pk_12_total | 313 | 2 | 16 | 2 | 4 | 0 | 7 | 171 | 173 | 344 | 313 | 2 | 16 | 2 | 4 | 0 | 7 | 171 | 173 | 344 | ||||||||||||||||||||||||||||||||||
719173 | 719173 | CO | school | 806120 | 2690 | PUEBLO CITY 60 | 80612006361 | 2096 | CORWIN INTERNATIONAL MAGNET SCHOOL | Regular School | No | Elementary | 04 | 08 | 2017 | pk_12_total | 222 | 13 | 398 | 6 | 5 | 0 | 6 | 353 | 297 | 650 | 222 | 13 | 398 | 6 | 5 | 0 | 6 | 353 | 297 | 650 | ||||||||||||||||||||||||||||||||||
719546 | 719546 | CO | school | 805760 | 2740 | MONTE VISTA C-8 | 80576001560 | 6520 | MONTE VISTA ON-LINE ACADEMY | Alternative School | No | Other | 04 | 12 | 2017 | pk_12_total | 62 | 0 | 36 | 1 | 1 | 1 | 6 | 53 | 54 | 107 | 62 | 0 | 36 | 1 | 1 | 1 | 6 | 53 | 54 | 107 | ||||||||||||||||||||||||||||||||||
710021 | 710021 | CO | school | 802190 | 220 | ARCHULETA COUNTY 50 JT | 80219000040 | 6657 | PAGOSA SPRINGS MIDDLE SCHOOL | Regular School | No | Middle | 05 | 08 | 2017 | pk_12_total | 304 | 2 | 171 | 37 | 3 | 2 | 15 | 271 | 263 | 534 | 304 | 2 | 171 | 37 | 3 | 2 | 15 | 271 | 263 | 534 | ||||||||||||||||||||||||||||||||||
710395 | 710395 | CO | school | 805370 | 470 | ST VRAIN VALLEY RE 1J | 80537000910 | 5288 | LONGS PEAK MIDDLE SCHOOL | Regular School | No | Middle | 05 | 08 | 2017 | pk_12_total | 139 | 9 | 259 | 3 | 3 | 0 | 6 | 205 | 214 | 419 | 139 | 9 | 259 | 3 | 3 | 0 | 6 | 205 | 214 | 419 | ||||||||||||||||||||||||||||||||||
710983 | 710983 | CO | school | 806330 | 500 | SALIDA R-32 | 80633006500 | 1554 | CREST ACADEMY | Regular School | No | Middle | 05 | 08 | 2017 | pk_12_total | 22 | 0 | 2 | 0 | 0 | 0 | 1 | 14 | 11 | 25 | 22 | 0 | 2 | 0 | 0 | 0 | 1 | 14 | 11 | 25 | ||||||||||||||||||||||||||||||||||
710993 | 710993 | CO | school | 806330 | 500 | SALIDA R-32 | 80633001107 | 4680 | SALIDA MIDDLE SCHOOL | Regular School | No | Middle | 05 | 08 | 2017 | pk_12_total | 252 | 2 | 49 | 4 | 2 | 0 | 12 | 158 | 163 | 321 | 252 | 2 | 49 | 4 | 2 | 0 | 12 | 158 | 163 | 321 | ||||||||||||||||||||||||||||||||||
711235 | 711235 | CO | school | 803330 | 870 | DELTA COUNTY 50(J) | 80333002001 | 2152 | DELTA ACADEMY OF APPLIED LEARNING | Alternative School | No | Middle | 05 | 08 | 2017 | pk_12_total | 14 | 0 | 3 | 0 | 0 | 0 | 2 | 10 | 9 | 19 | 14 | 0 | 3 | 0 | 0 | 0 | 2 | 10 | 9 | 19 | ||||||||||||||||||||||||||||||||||
712000 | 712000 | CO | school | 803360 | 880 | DENVER COUNTY 1 | 80336006519 | 4507 | KIPP MONTBELLO COLLEGE PREP | Regular School | Yes | Middle | 05 | 08 | 2017 | pk_12_total | 14 | 91 | 334 | 0 | 5 | 2 | 9 | 232 | 223 | 455 | 14 | 91 | 334 | 0 | 5 | 2 | 9 | 232 | 223 | 455 | ||||||||||||||||||||||||||||||||||
712018 | 712018 | CO | school | 803360 | 880 | DENVER COUNTY 1 | 80336001865 | 4732 | KIPP SUNSHINE PEAK ACADEMY | Regular School | Yes | Middle | 05 | 08 | 2017 | pk_12_total | 6 | 3 | 386 | 0 | 4 | 1 | 0 | 208 | 192 | 400 | 6 | 3 | 386 | 0 | 4 | 1 | 0 | 208 | 192 | 400 | ||||||||||||||||||||||||||||||||||
713533 | 713533 | CO | school | 803540 | 910 | EAGLE COUNTY RE 50 | 80354006422 | 9061 | VAIL SKI AND SNOWBOARD ACADEMY (VSSA) | Alternative School | No | Other | 05 | 12 | 2017 | pk_12_total | 179 | 0 | 5 | 1 | 0 | 0 | 6 | 105 | 86 | 191 | 179 | 0 | 5 | 1 | 0 | 0 | 6 | 105 | 86 | 191 | ||||||||||||||||||||||||||||||||||
713665 | 713665 | CO | school | 804530 | 980 | HARRISON 2 | 80453006691 | 369 | ATLAS PREPARATORY MIDDLE SCHOOL | Regular School | Yes | Middle | 05 | 08 | 2017 | pk_12_total | 52 | 49 | 363 | 5 | 3 | 4 | 24 | 252 | 248 | 500 | 52 | 49 | 363 | 5 | 3 | 4 | 24 | 252 | 248 | 500 | ||||||||||||||||||||||||||||||||||
715201 | 715201 | CO | school | 804260 | 1180 | ROARING FORK RE-1 | 80426000133 | 561 | BASALT MIDDLE SCHOOL | Regular School | No | Middle | 05 | 08 | 2017 | pk_12_total | 231 | 0 | 254 | 0 | 11 | 0 | 6 | 226 | 276 | 502 | 231 | 0 | 254 | 0 | 11 | 0 | 6 | 226 | 276 | 502 | ||||||||||||||||||||||||||||||||||
715215 | 715215 | CO | school | 804260 | 1180 | ROARING FORK RE-1 | 80426000586 | 1296 | CARBONDALE MIDDLE SCHOOL | Regular School | No | Middle | 05 | 08 | 2017 | pk_12_total | 105 | 0 | 214 | 1 | 1 | 1 | 4 | 164 | 162 | 326 | 105 | 0 | 214 | 1 | 1 | 1 | 4 | 164 | 162 | 326 | ||||||||||||||||||||||||||||||||||
715297 | 715297 | CO | school | 806240 | 1195 | GARFIELD RE-2 | 80624001096 | 7356 | RIFLE MIDDLE SCHOOL | Regular School | No | Middle | 05 | 08 | 2017 | pk_12_total | 391 | 5 | 431 | 1 | 4 | 0 | 23 | 427 | 428 | 855 | 391 | 5 | 431 | 1 | 4 | 0 | 23 | 427 | 428 | 855 | ||||||||||||||||||||||||||||||||||
715307 | 715307 | CO | school | 806240 | 1195 | GARFIELD RE-2 | 80624001098 | 7388 | RIVERSIDE SCHOOL | Regular School | No | Middle | 05 | 08 | 2017 | pk_12_total | 357 | 3 | 293 | 1 | 3 | 1 | 13 | 365 | 306 | 671 | 357 | 3 | 293 | 1 | 3 | 1 | 13 | 365 | 306 | 671 | ||||||||||||||||||||||||||||||||||
716909 | 716909 | CO | school | 802670 | 1500 | BURLINGTON RE-6J | 80267000161 | 1150 | BURLINGTON MIDDLE SCHOOL | Regular School | No | Middle | 05 | 08 | 2017 | pk_12_total | 114 | 4 | 84 | 2 | 3 | 0 | 1 | 112 | 96 | 208 | 114 | 4 | 84 | 2 | 3 | 0 | 1 | 112 | 96 | 208 | ||||||||||||||||||||||||||||||||||
718990 | 718990 | CO | school | 802280 | 2640 | ASPEN 1 | 80228000046 | 430 | ASPEN MIDDLE SCHOOL | Regular School | No | Middle | 05 | 08 | 2017 | pk_12_total | 379 | 9 | 50 | 0 | 8 | 0 | 3 | 225 | 224 | 449 | 379 | 9 | 50 | 0 | 8 | 0 | 3 | 225 | 224 | 449 | ||||||||||||||||||||||||||||||||||
719502 | 719502 | CO | school | 803300 | 2730 | DEL NORTE C-7 | 80330000289 | 2148 | DEL NORTE MIDDLE SCHOOL | Regular School | No | Middle | 05 | 08 | 2017 | pk_12_total | 46 | 0 | 59 | 1 | 0 | 0 | 2 | 60 | 48 | 108 | 46 | 0 | 59 | 1 | 0 | 0 | 2 | 60 | 48 | 108 | ||||||||||||||||||||||||||||||||||
720560 | 720560 | CO | school | 800016 | 3200 | YUMA 1 | 80001601819 | 9791 | YUMA MIDDLE SCHOOL | Regular School | No | Middle | 05 | 08 | 2017 | pk_12_total | 116 | 2 | 137 | 0 | 0 | 0 | 2 | 128 | 129 | 257 | 116 | 2 | 137 | 0 | 0 | 0 | 2 | 128 | 129 | 257 | ||||||||||||||||||||||||||||||||||
720583 | 720583 | CO | school | 800017 | 3210 | WRAY RD-2 | 80001701817 | 9729 | BUCHANAN MIDDLE SCHOOL | Regular School | No | Middle | 05 | 08 | 2017 | pk_12_total | 152 | 2 | 55 | 1 | 0 | 0 | 3 | 103 | 110 | 213 | 152 | 2 | 55 | 1 | 0 | 0 | 3 | 103 | 110 | 213 | ||||||||||||||||||||||||||||||||||
707977 | 707977 | CO | school | 806900 | 20 | ADAMS 12 FIVE STAR SCHOOLS | 80690001726 | 57 | ROCKY TOP MIDDLE SCHOOL | Regular School | No | Middle | 06 | 08 | 2017 | pk_12_total | 958 | 20 | 248 | 4 | 73 | 0 | 35 | 692 | 646 | 1338 | 958 | 20 | 248 | 4 | 73 | 0 | 35 | 692 | 646 | 1338 | ||||||||||||||||||||||||||||||||||
707994 | 707994 | CO | school | 806900 | 20 | ADAMS 12 FIVE STAR SCHOOLS | 80690001172 | 210 | VANTAGE POINT | Alternative School | No | Other | 06 | 12 | 2017 | pk_12_total | 153 | 6 | 188 | 3 | 2 | 0 | 5 | 211 | 146 | 357 | 153 | 6 | 188 | 3 | 2 | 0 | 5 | 211 | 146 | 357 | ||||||||||||||||||||||||||||||||||
708017 | 708017 | CO | school | 806900 | 20 | ADAMS 12 FIVE STAR SCHOOLS | 80690001620 | 1480 | CENTURY MIDDLE SCHOOL | Regular School | No | Middle | 06 | 08 | 2017 | pk_12_total | 636 | 24 | 281 | 13 | 41 | 3 | 23 | 503 | 518 | 1021 | 636 | 24 | 281 | 13 | 41 | 3 | 23 | 503 | 518 | 1021 | ||||||||||||||||||||||||||||||||||
708143 | 708143 | CO | school | 806900 | 20 | ADAMS 12 FIVE STAR SCHOOLS | 80690001179 | 4187 | SILVER HILLS MIDDLE SCHOOL | Regular School | No | Middle | 06 | 08 | 2017 | pk_12_total | 453 | 28 | 518 | 8 | 61 | 1 | 31 | 555 | 545 | 1100 | 453 | 28 | 518 | 8 | 61 | 1 | 31 | 555 | 545 | 1100 | ||||||||||||||||||||||||||||||||||
708176 | 708176 | CO | school | 806900 | 20 | ADAMS 12 FIVE STAR SCHOOLS | 80690001183 | 5814 | THE INTERNATIONAL SCHOOL AT THORNTON MIDDLE | Regular School | No | Middle | 06 | 08 | 2017 | pk_12_total | 110 | 36 | 739 | 8 | 17 | 0 | 13 | 492 | 431 | 923 | 110 | 36 | 739 | 8 | 17 | 0 | 13 | 492 | 431 | 923 | ||||||||||||||||||||||||||||||||||
708199 | 708199 | CO | school | 806900 | 20 | ADAMS 12 FIVE STAR SCHOOLS | 80690001186 | 6342 | SHADOW RIDGE MIDDLE SCHOOL | Regular School | No | Middle | 06 | 08 | 2017 | pk_12_total | 467 | 18 | 381 | 3 | 57 | 1 | 25 | 470 | 482 | 952 | 467 | 18 | 381 | 3 | 57 | 1 | 25 | 470 | 482 | 952 | ||||||||||||||||||||||||||||||||||
708219 | 708219 | CO | school | 806900 | 20 | ADAMS 12 FIVE STAR SCHOOLS | 80690001187 | 6398 | NORTHGLENN MIDDLE SCHOOL | Regular School | No | Middle | 06 | 08 | 2017 | pk_12_total | 216 | 18 | 517 | 6 | 27 | 2 | 12 | 447 | 351 | 798 | 216 | 18 | 517 | 6 | 27 | 2 | 12 | 447 | 351 | 798 | ||||||||||||||||||||||||||||||||||
708333 | 708333 | CO | school | 806900 | 20 | ADAMS 12 FIVE STAR SCHOOLS | 80690001194 | 9444 | WESTLAKE MIDDLE SCHOOL | Regular School | No | Middle | 06 | 08 | 2017 | pk_12_total | 765 | 16 | 264 | 2 | 58 | 2 | 42 | 595 | 554 | 1149 | 765 | 16 | 264 | 2 | 58 | 2 | 42 | 595 | 554 | 1149 | ||||||||||||||||||||||||||||||||||
708354 | 708354 | CO | school | 801950 | 30 | ADAMS COUNTY 14 | 80195000009 | 20 | ADAMS CITY MIDDLE SCHOOL | Regular School | No | Middle | 06 | 08 | 2017 | pk_12_total | 101 | 18 | 672 | 6 | 4 | 1 | 16 | 442 | 376 | 818 | 101 | 18 | 672 | 6 | 4 | 1 | 16 | 442 | 376 | 818 | ||||||||||||||||||||||||||||||||||
708392 | 708392 | CO | school | 801950 | 30 | ADAMS COUNTY 14 | 80195000015 | 4516 | KEARNEY MIDDLE SCHOOL | Regular School | No | Middle | 06 | 08 | 2017 | pk_12_total | 88 | 28 | 669 | 3 | 2 | 0 | 5 | 419 | 376 | 795 | 88 | 28 | 669 | 3 | 2 | 0 | 5 | 419 | 376 | 795 | ||||||||||||||||||||||||||||||||||
708450 | 708450 | CO | school | 802580 | 40 | SCHOOL DISTRICT 27J | 80258000729 | 1021 | BRIGHTON HERITAGE ACADEMY | Alternative School | No | Other | 06 | 12 | 2017 | pk_12_total | 91 | 3 | 110 | 4 | 2 | 0 | 6 | 128 | 88 | 216 | 91 | 3 | 110 | 4 | 2 | 0 | 6 | 128 | 88 | 216 | ||||||||||||||||||||||||||||||||||
708538 | 708538 | CO | school | 802580 | 40 | SCHOOL DISTRICT 27J | 80258001377 | 6638 | OVERLAND TRAIL MIDDLE SCHOOL | Regular School | No | Middle | 06 | 08 | 2017 | pk_12_total | 217 | 9 | 350 | 2 | 8 | 1 | 21 | 314 | 294 | 608 | 217 | 9 | 350 | 2 | 8 | 1 | 21 | 314 | 294 | 608 | ||||||||||||||||||||||||||||||||||
708542 | 708542 | CO | school | 802580 | 40 | SCHOOL DISTRICT 27J | 80258006420 | 6702 | OTHO E STUART MIDDLE SCHOOL | Regular School | No | Middle | 06 | 08 | 2017 | pk_12_total | 332 | 28 | 340 | 2 | 32 | 0 | 31 | 392 | 373 | 765 | 332 | 28 | 340 | 2 | 32 | 0 | 31 | 392 | 373 | 765 | ||||||||||||||||||||||||||||||||||
708551 | 708551 | CO | school | 802580 | 40 | SCHOOL DISTRICT 27J | 80258006362 | 7131 | PRAIRIE VIEW MIDDLE SCHOOL | Regular School | No | Middle | 06 | 08 | 2017 | pk_12_total | 387 | 14 | 350 | 3 | 41 | 3 | 25 | 411 | 412 | 823 | 387 | 14 | 350 | 3 | 41 | 3 | 25 | 411 | 412 | 823 | ||||||||||||||||||||||||||||||||||
708597 | 708597 | CO | school | 802580 | 40 | SCHOOL DISTRICT 27J | 80258000152 | 9230 | VIKAN MIDDLE SCHOOL | Regular School | No | Middle | 06 | 08 | 2017 | pk_12_total | 180 | 7 | 380 | 3 | 2 | 0 | 9 | 305 | 276 | 581 | 180 | 7 | 380 | 3 | 2 | 0 | 9 | 305 | 276 | 581 | ||||||||||||||||||||||||||||||||||
708619 | 708619 | CO | school | 802430 | 50 | BENNETT 29J | 80243000093 | 774 | BENNETT MIDDLE SCHOOL | Regular School | No | Middle | 06 | 08 | 2017 | pk_12_total | 175 | 1 | 50 | 2 | 0 | 0 | 7 | 126 | 109 | 235 | 175 | 1 | 50 | 2 | 0 | 0 | 7 | 126 | 109 | 235 | ||||||||||||||||||||||||||||||||||
708640 | 708640 | CO | school | 806750 | 60 | STRASBURG 31J | 80675001160 | 8332 | HEMPHILL MIDDLE SCHOOL | Regular School | No | Middle | 06 | 08 | 2017 | pk_12_total | 150 | 1 | 36 | 2 | 1 | 0 | 2 | 100 | 92 | 192 | 150 | 1 | 36 | 2 | 1 | 0 | 2 | 100 | 92 | 192 | ||||||||||||||||||||||||||||||||||
708706 | 708706 | CO | school | 807230 | 70 | WESTMINSTER PUBLIC SCHOOLS | 80723001241 | 5388 | M. SCOTT CARPENTER MIDDLE SCHOOL | Regular School | No | Middle | 06 | 08 | 2017 | pk_12_total | 41 | 7 | 442 | 2 | 19 | 1 | 7 | 277 | 242 | 519 | 41 | 7 | 442 | 2 | 19 | 1 | 7 | 277 | 242 | 519 | ||||||||||||||||||||||||||||||||||
708717 | 708717 | CO | school | 807230 | 70 | WESTMINSTER PUBLIC SCHOOLS | 80723006458 | 7305 | IVER C. RANUM MIDDLE SCHOOL | Regular School | No | Middle | 06 | 08 | 2017 | pk_12_total | 76 | 8 | 596 | 6 | 22 | 4 | 11 | 363 | 360 | 723 | 76 | 8 | 596 | 6 | 22 | 4 | 11 | 363 | 360 | 723 | ||||||||||||||||||||||||||||||||||
708729 | 708729 | CO | school | 807230 | 70 | WESTMINSTER PUBLIC SCHOOLS | 80723001244 | 7812 | SHAW HEIGHTS MIDDLE SCHOOL | Regular School | No | Middle | 06 | 08 | 2017 | pk_12_total | 126 | 16 | 422 | 7 | 44 | 1 | 9 | 302 | 323 | 625 | 126 | 16 | 422 | 7 | 44 | 1 | 9 | 302 | 323 | 625 | ||||||||||||||||||||||||||||||||||
708779 | 708779 | CO | school | 802070 | 100 | ALAMOSA RE-11J | 80207000026 | 114 | ORTEGA MIDDLE SCHOOL | Regular School | No | Middle | 06 | 08 | 2017 | pk_12_total | 163 | 3 | 335 | 9 | 6 | 0 | 8 | 262 | 262 | 524 | 163 | 3 | 335 | 9 | 6 | 0 | 8 | 262 | 262 | 524 | ||||||||||||||||||||||||||||||||||
708799 | 708799 | CO | school | 802070 | 100 | ALAMOSA RE-11J | 80207006508 | 368 | ALAMOSA OMBUDSMAN SCHOOL OF EXCELLENCE | Alternative School | No | Other | 06 | 12 | 2017 | pk_12_total | 12 | 1 | 44 | 1 | 0 | 0 | 1 | 31 | 28 | 59 | 12 | 1 | 44 | 1 | 0 | 0 | 1 | 31 | 28 | 59 | ||||||||||||||||||||||||||||||||||
708815 | 708815 | CO | school | 806420 | 110 | SANGRE DE CRISTO RE-22J | 80642001116 | 7630 | SANGRE DE CRISTO UNDIVIDED HIGH SCHOOL | Regular School | No | Other | 06 | 12 | 2017 | pk_12_total | 96 | 4 | 42 | 4 | 0 | 0 | 3 | 79 | 70 | 149 | 96 | 4 | 42 | 4 | 0 | 0 | 3 | 79 | 70 | 149 | ||||||||||||||||||||||||||||||||||
708853 | 708853 | CO | school | 803780 | 120 | ENGLEWOOD 1 | 80378001772 | 2750 | ENGLEWOOD LEADERSHIP ACADEMY | Regular School | No | Other | 06 | 09 | 2017 | pk_12_total | 59 | 0 | 15 | 0 | 4 | 0 | 2 | 42 | 38 | 80 | 59 | 0 | 15 | 0 | 4 | 0 | 2 | 42 | 38 | 80 | ||||||||||||||||||||||||||||||||||
708889 | 708889 | CO | school | 806540 | 123 | SHERIDAN 2 | 80654006565 | 8123 | SOAR ACADEMY | Alternative School | No | Other | 06 | 12 | 2017 | pk_12_total | 14 | 2 | 80 | 1 | 0 | 1 | 1 | 56 | 43 | 99 | 14 | 2 | 80 | 1 | 0 | 1 | 1 | 56 | 43 | 99 | ||||||||||||||||||||||||||||||||||
708901 | 708901 | CO | school | 802910 | 130 | CHERRY CREEK 5 | 80291001711 | 18 | LIBERTY MIDDLE SCHOOL | Regular School | No | Middle | 06 | 08 | 2017 | pk_12_total | 653 | 108 | 164 | 9 | 138 | 2 | 72 | 592 | 554 | 1146 | 653 | 108 | 164 | 9 | 138 | 2 | 72 | 592 | 554 | 1146 | ||||||||||||||||||||||||||||||||||
708905 | 708905 | CO | school | 802910 | 130 | CHERRY CREEK 5 | 80291001878 | 141 | SKY VISTA MIDDLE SCHOOL | Regular School | No | Middle | 06 | 08 | 2017 | pk_12_total | 433 | 100 | 164 | 3 | 73 | 2 | 51 | 412 | 414 | 826 | 433 | 100 | 164 | 3 | 73 | 2 | 51 | 412 | 414 | 826 | ||||||||||||||||||||||||||||||||||
708975 | 708975 | CO | school | 802910 | 130 | CHERRY CREEK 5 | 80291000185 | 1566 | CAMPUS MIDDLE SCHOOL | Regular School | No | Middle | 06 | 08 | 2017 | pk_12_total | 894 | 45 | 163 | 3 | 215 | 3 | 70 | 715 | 678 | 1393 | 894 | 45 | 163 | 3 | 215 | 3 | 70 | 715 | 678 | 1393 | ||||||||||||||||||||||||||||||||||
708979 | 708979 | CO | school | 802910 | 130 | CHERRY CREEK 5 | 80291000207 | 1568 | WEST MIDDLE SCHOOL | Regular School | No | Middle | 06 | 08 | 2017 | pk_12_total | 906 | 20 | 190 | 7 | 84 | 2 | 50 | 610 | 649 | 1259 | 906 | 20 | 190 | 7 | 84 | 2 | 50 | 610 | 649 | 1259 | ||||||||||||||||||||||||||||||||||
709065 | 709065 | CO | school | 802910 | 130 | CHERRY CREEK 5 | 80291001672 | 2897 | FALCON CREEK MIDDLE SCHOOL | Regular School | No | Middle | 06 | 08 | 2017 | pk_12_total | 562 | 70 | 158 | 7 | 89 | 5 | 49 | 472 | 468 | 940 | 562 | 70 | 158 | 7 | 89 | 5 | 49 | 472 | 468 | 940 | ||||||||||||||||||||||||||||||||||
709069 | 709069 | CO | school | 802910 | 130 | CHERRY CREEK 5 | 80291006367 | 3030 | FOX RIDGE MIDDLE SCHOOL | Regular School | No | Middle | 06 | 08 | 2017 | pk_12_total | 972 | 100 | 176 | 5 | 100 | 0 | 85 | 731 | 707 | 1438 | 972 | 100 | 176 | 5 | 100 | 0 | 85 | 731 | 707 | 1438 | ||||||||||||||||||||||||||||||||||
709115 | 709115 | CO | school | 802910 | 130 | CHERRY CREEK 5 | 80291001328 | 4100 | HORIZON MIDDLE SCHOOL | Regular School | No | Middle | 06 | 08 | 2017 | pk_12_total | 397 | 166 | 267 | 13 | 34 | 1 | 75 | 522 | 431 | 953 | 397 | 166 | 267 | 13 | 34 | 1 | 75 | 522 | 431 | 953 | ||||||||||||||||||||||||||||||||||
709151 | 709151 | CO | school | 802910 | 130 | CHERRY CREEK 5 | 80291000197 | 4975 | LAREDO MIDDLE SCHOOL | Regular School | No | Middle | 06 | 08 | 2017 | pk_12_total | 542 | 180 | 243 | 6 | 79 | 8 | 64 | 559 | 563 | 1122 | 542 | 180 | 243 | 6 | 79 | 8 | 64 | 559 | 563 | 1122 | ||||||||||||||||||||||||||||||||||
709232 | 709232 | CO | school | 802910 | 130 | CHERRY CREEK 5 | 80291000201 | 7158 | PRAIRIE MIDDLE SCHOOL | Regular School | No | Middle | 06 | 08 | 2017 | pk_12_total | 394 | 447 | 707 | 14 | 84 | 7 | 118 | 929 | 842 | 1771 | 394 | 447 | 707 | 14 | 84 | 7 | 118 | 929 | 842 | 1771 | ||||||||||||||||||||||||||||||||||
709279 | 709279 | CO | school | 802910 | 130 | CHERRY CREEK 5 | 80291000034 | 8848 | THUNDER RIDGE MIDDLE SCHOOL | Regular School | No | Middle | 06 | 08 | 2017 | pk_12_total | 738 | 131 | 237 | 8 | 92 | 5 | 82 | 663 | 630 | 1293 | 738 | 131 | 237 | 8 | 92 | 5 | 82 | 663 | 630 | 1293 | ||||||||||||||||||||||||||||||||||
709347 | 709347 | CO | school | 805310 | 140 | LITTLETON 6 | 80531000876 | 2804 | EUCLID MIDDLE SCHOOL | Regular School | No | Middle | 06 | 08 | 2017 | pk_12_total | 522 | 7 | 141 | 5 | 18 | 4 | 24 | 346 | 375 | 721 | 522 | 7 | 141 | 5 | 18 | 4 | 24 | 346 | 375 | 721 | ||||||||||||||||||||||||||||||||||
709358 | 709358 | CO | school | 805310 | 140 | LITTLETON 6 | 80531000879 | 3472 | GODDARD MIDDLE SCHOOL | Regular School | No | Middle | 06 | 08 | 2017 | pk_12_total | 421 | 11 | 257 | 3 | 16 | 0 | 36 | 387 | 357 | 744 | 421 | 11 | 257 | 3 | 16 | 0 | 36 | 387 | 357 | 744 | ||||||||||||||||||||||||||||||||||
709375 | 709375 | CO | school | 805310 | 140 | LITTLETON 6 | 80531000885 | 4316 | NEWTON MIDDLE SCHOOL | Regular School | No | Middle | 06 | 08 | 2017 | pk_12_total | 467 | 16 | 62 | 3 | 25 | 0 | 27 | 314 | 286 | 600 | 467 | 16 | 62 | 3 | 25 | 0 | 27 | 314 | 286 | 600 | ||||||||||||||||||||||||||||||||||
709379 | 709379 | CO | school | 805310 | 140 | LITTLETON 6 | 80531001351 | 4447 | JOHN WESLEY POWELL MIDDLE SCHOOL | Regular School | No | Middle | 06 | 08 | 2017 | pk_12_total | 794 | 13 | 88 | 4 | 27 | 1 | 50 | 514 | 463 | 977 | 794 | 13 | 88 | 4 | 27 | 1 | 50 | 514 | 463 | 977 | ||||||||||||||||||||||||||||||||||
709483 | 709483 | CO | school | 803270 | 170 | DEER TRAIL 26J | 80327000288 | 2140 | DEER TRAIL JUNIOR-SENIOR HIGH SCHOOL | Regular School | No | Other | 06 | 12 | 2017 | pk_12_total | 72 | 0 | 29 | 0 | 0 | 0 | 2 | 46 | 57 | 103 | 72 | 0 | 29 | 0 | 0 | 0 | 2 | 46 | 57 | 103 | ||||||||||||||||||||||||||||||||||
709541 | 709541 | CO | school | 802340 | 180 | ADAMS-ARAPAHOE 28J | 80234000054 | 464 | AURORA HILLS MIDDLE SCHOOL | Regular School | No | Middle | 06 | 08 | 2017 | pk_12_total | 104 | 200 | 518 | 3 | 33 | 5 | 45 | 452 | 456 | 908 | 104 | 200 | 518 | 3 | 33 | 5 | 45 | 452 | 456 | 908 |
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]);