enrollments
Data source: Big Local News · About: Big Local
1,885 rows where grade = "pk_12_total", state = "CO" and year = 2017 sorted by school_state_id
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 | |||||||||||||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||||||||||||
711331 | 711331 | CO | school | 803360 | 880 | DENVER COUNTY 1 | 80336000305 | 10 | ABRAHAM LINCOLN HIGH SCHOOL | Regular School | No | High | 09 | 12 | 2017 | pk_12_total | 31 | 33 | 1026 | 8 | 55 | 0 | 6 | 632 | 527 | 1159 | 31 | 33 | 1026 | 8 | 55 | 0 | 6 | 632 | 527 | 1159 | ||||||||||||||||||||||||||||||||||
712694 | 712694 | CO | school | 803450 | 900 | DOUGLAS COUNTY RE 1 | 80345000492 | 11 | ACADEMY CHARTER SCHOOL | Regular School | Yes | Elementary | PK | 08 | 2017 | pk_12_total | 656 | 10 | 84 | 3 | 16 | 0 | 27 | 390 | 406 | 796 | 656 | 10 | 84 | 3 | 16 | 0 | 27 | 390 | 406 | 796 | ||||||||||||||||||||||||||||||||||
712703 | 712703 | CO | school | 803450 | 900 | DOUGLAS COUNTY RE 1 | 80345000436 | 12 | ACRES GREEN ELEMENTARY SCHOOL | Regular School | No | Elementary | PK | 06 | 2017 | pk_12_total | 330 | 13 | 98 | 4 | 165 | 2 | 57 | 345 | 324 | 669 | 330 | 13 | 98 | 4 | 165 | 2 | 57 | 345 | 324 | 669 | ||||||||||||||||||||||||||||||||||
707973 | 707973 | CO | school | 806900 | 20 | ADAMS 12 FIVE STAR SCHOOLS | 80690001709 | 14 | GLACIER PEAK ELEMENTARY SCHOOL | Regular School | No | Elementary | KG | 05 | 2017 | pk_12_total | 256 | 9 | 189 | 2 | 12 | 1 | 20 | 271 | 218 | 489 | 256 | 9 | 189 | 2 | 12 | 1 | 20 | 271 | 218 | 489 | ||||||||||||||||||||||||||||||||||
720634 | 720634 | CO | school | 800020 | 8001 | CHARTER SCHOOL INSTITUTE | 80002000727 | 15 | ACADEMY OF CHARTER SCHOOLS | Regular School | Yes | Other | PK | 12 | 2017 | pk_12_total | 1112 | 13 | 483 | 7 | 140 | 2 | 73 | 922 | 908 | 1830 | 1112 | 13 | 483 | 7 | 140 | 2 | 73 | 922 | 908 | 1830 | ||||||||||||||||||||||||||||||||||
708896 | 708896 | CO | school | 802910 | 130 | CHERRY CREEK 5 | 80291001710 | 16 | FOX HOLLOW ELEMENTARY SCHOOL | Regular School | No | Elementary | PK | 05 | 2017 | pk_12_total | 440 | 30 | 81 | 3 | 105 | 0 | 41 | 362 | 338 | 700 | 440 | 30 | 81 | 3 | 105 | 0 | 41 | 362 | 338 | 700 | ||||||||||||||||||||||||||||||||||
714479 | 714479 | CO | school | 801920 | 1040 | ACADEMY 20 | 80192001643 | 17 | ACADEMY ENDEAVOUR ELEMENTARY SCHOOL | Regular School | No | Elementary | KG | 05 | 2017 | pk_12_total | 430 | 20 | 70 | 2 | 14 | 2 | 36 | 263 | 311 | 574 | 430 | 20 | 70 | 2 | 14 | 2 | 36 | 263 | 311 | 574 | ||||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||
714487 | 714487 | CO | school | 801920 | 1040 | ACADEMY 20 | 80192001644 | 19 | ACADEMY INTERNATIONAL ELEMENTARY SCHOOL | Regular School | No | Elementary | PK | 05 | 2017 | pk_12_total | 380 | 32 | 68 | 0 | 72 | 1 | 38 | 277 | 314 | 591 | 380 | 32 | 68 | 0 | 72 | 1 | 38 | 277 | 314 | 591 | ||||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||
708359 | 708359 | CO | school | 801950 | 30 | ADAMS COUNTY 14 | 80195001307 | 22 | LESTER R ARNOLD HIGH SCHOOL | Alternative School | No | High | 09 | 12 | 2017 | pk_12_total | 20 | 7 | 207 | 2 | 0 | 0 | 3 | 123 | 116 | 239 | 20 | 7 | 207 | 2 | 0 | 0 | 3 | 123 | 116 | 239 | ||||||||||||||||||||||||||||||||||
708364 | 708364 | CO | school | 801950 | 30 | ADAMS COUNTY 14 | 80195000010 | 24 | ADAMS CITY HIGH SCHOOL | Regular School | No | High | 09 | 12 | 2017 | pk_12_total | 206 | 44 | 1516 | 11 | 5 | 1 | 16 | 907 | 892 | 1799 | 206 | 44 | 1516 | 11 | 5 | 1 | 16 | 907 | 892 | 1799 | ||||||||||||||||||||||||||||||||||
719310 | 719310 | CO | school | 806150 | 2700 | PUEBLO COUNTY 70 | 80615001714 | 25 | SKY VIEW MIDDLE SCHOOL | Regular School | No | Middle | 06 | 08 | 2017 | pk_12_total | 393 | 3 | 197 | 1 | 4 | 0 | 30 | 308 | 320 | 628 | 393 | 3 | 197 | 1 | 4 | 0 | 30 | 308 | 320 | 628 | ||||||||||||||||||||||||||||||||||
719317 | 719317 | CO | school | 806150 | 2700 | PUEBLO COUNTY 70 | 80615001718 | 26 | DESERT SAGE ELEMENTARY SCHOOL | Regular School | No | Elementary | PK | 05 | 2017 | pk_12_total | 219 | 3 | 190 | 0 | 3 | 0 | 12 | 240 | 187 | 427 | 219 | 3 | 190 | 0 | 3 | 0 | 12 | 240 | 187 | 427 | ||||||||||||||||||||||||||||||||||
715527 | 715527 | CO | school | 804800 | 1420 | JEFFERSON COUNTY R-1 | 80480001446 | 30 | ADAMS ELEMENTARY SCHOOL | Regular School | No | Elementary | PK | 06 | 2017 | pk_12_total | 294 | 2 | 106 | 0 | 27 | 1 | 23 | 248 | 205 | 453 | 294 | 2 | 106 | 0 | 27 | 1 | 23 | 248 | 205 | 453 | ||||||||||||||||||||||||||||||||||
715533 | 715533 | CO | school | 804800 | 1420 | JEFFERSON COUNTY R-1 | 80480006163 | 33 | MC LAIN HIGH SCHOOL | Alternative School | No | High | 07 | 12 | 2017 | pk_12_total | 260 | 2 | 97 | 9 | 0 | 0 | 16 | 215 | 169 | 384 | 260 | 2 | 97 | 9 | 0 | 0 | 16 | 215 | 169 | 384 | ||||||||||||||||||||||||||||||||||
715535 | 715535 | CO | school | 804800 | 1420 | JEFFERSON COUNTY R-1 | 80480001349 | 34 | MC LAIN COMMUNITY HIGH SCHOOL | Alternative School | No | High | 08 | 12 | 2017 | pk_12_total | 62 | 2 | 36 | 1 | 3 | 1 | 5 | 65 | 45 | 110 | 62 | 2 | 36 | 1 | 3 | 1 | 5 | 65 | 45 | 110 | ||||||||||||||||||||||||||||||||||
720644 | 720644 | CO | school | 800020 | 8001 | CHARTER SCHOOL INSTITUTE | 80002001720 | 35 | FRONTIER CHARTER ACADEMY | Regular School | Yes | Elementary | KG | 08 | 2017 | pk_12_total | 65 | 2 | 5 | 0 | 0 | 0 | 0 | 36 | 36 | 72 | 65 | 2 | 5 | 0 | 0 | 0 | 0 | 36 | 36 | 72 | ||||||||||||||||||||||||||||||||||
713416 | 713416 | CO | school | 803540 | 910 | EAGLE COUNTY RE 50 | 80354001721 | 37 | RED HILL ELEMENTARY SCHOOL | Regular School | No | Elementary | PK | 05 | 2017 | pk_12_total | 137 | 0 | 233 | 3 | 1 | 0 | 13 | 206 | 181 | 387 | 137 | 0 | 233 | 3 | 1 | 0 | 13 | 206 | 181 | 387 | ||||||||||||||||||||||||||||||||||
713424 | 713424 | CO | school | 803540 | 910 | EAGLE COUNTY RE 50 | 80354001722 | 38 | BRUSH CREEK ELEMENTARY SCHOOL | Regular School | No | Elementary | PK | 05 | 2017 | pk_12_total | 338 | 1 | 78 | 2 | 3 | 0 | 9 | 230 | 201 | 431 | 338 | 1 | 78 | 2 | 3 | 0 | 9 | 230 | 201 | 431 | ||||||||||||||||||||||||||||||||||
713429 | 713429 | CO | school | 803540 | 910 | EAGLE COUNTY RE 50 | 80354001723 | 39 | GYPSUM CREEK MIDDLE SCHOOL | Regular School | No | Middle | 06 | 08 | 2017 | pk_12_total | 116 | 0 | 251 | 0 | 4 | 0 | 2 | 201 | 172 | 373 | 116 | 0 | 251 | 0 | 4 | 0 | 2 | 201 | 172 | 373 | ||||||||||||||||||||||||||||||||||
711336 | 711336 | CO | school | 803360 | 880 | DENVER COUNTY 1 | 80336001724 | 40 | RIDGE VIEW ACADEMY CHARTER SCHOOL | Alternative School | Yes | High | 09 | 12 | 2017 | pk_12_total | 67 | 35 | 104 | 1 | 0 | 0 | 3 | 210 | 0 | 210 | 67 | 35 | 104 | 1 | 0 | 0 | 3 | 210 | 0 | 210 | ||||||||||||||||||||||||||||||||||
718978 | 718978 | CO | school | 802280 | 2640 | ASPEN 1 | 80228001703 | 42 | ASPEN COMMUNITY CHARTER SCHOOL | Regular School | Yes | Elementary | PK | 08 | 2017 | pk_12_total | 126 | 0 | 5 | 1 | 1 | 1 | 1 | 66 | 69 | 135 | 126 | 0 | 5 | 1 | 1 | 1 | 1 | 66 | 69 | 135 | ||||||||||||||||||||||||||||||||||
713643 | 713643 | CO | school | 801980 | 960 | AGATE 300 | 80198000020 | 44 | AGATE ELEMENTARY SCHOOL | Regular School | No | Elementary | KG | 05 | 2017 | pk_12_total | 3 | 0 | 2 | 0 | 0 | 0 | 0 | 1 | 4 | 5 | 3 | 0 | 2 | 0 | 0 | 0 | 0 | 1 | 4 | 5 | ||||||||||||||||||||||||||||||||||
712666 | 712666 | CO | school | 803420 | 890 | DOLORES COUNTY RE NO.2 | 80342001958 | 50 | RICO ELEMENTARY SCHOOL | Regular School | No | Elementary | PK | 06 | 2017 | pk_12_total | 8 | 0 | 0 | 0 | 0 | 0 | 0 | 2 | 6 | 8 | 8 | 0 | 0 | 0 | 0 | 0 | 0 | 2 | 6 | 8 | ||||||||||||||||||||||||||||||||||
719687 | 719687 | CO | school | 802850 | 2810 | CENTER 26 JT | 80285002008 | 51 | THE ACADEMIC RECOVERY CENTER OF SAN LUIS VALLEY | Alternative School | No | High | 09 | 12 | 2017 | pk_12_total | 1 | 1 | 4 | 0 | 0 | 0 | 0 | 5 | 1 | 6 | 1 | 1 | 4 | 0 | 0 | 0 | 0 | 5 | 1 | 6 | ||||||||||||||||||||||||||||||||||
720212 | 720212 | CO | school | 804410 | 3120 | GREELEY 6 | 80441001988 | 52 | HEIMAN ELEMENTARY SCHOOL | Regular School | No | Elementary | KG | 05 | 2017 | pk_12_total | 309 | 10 | 332 | 3 | 10 | 3 | 12 | 348 | 331 | 679 | 309 | 10 | 332 | 3 | 10 | 3 | 12 | 348 | 331 | 679 | ||||||||||||||||||||||||||||||||||
720222 | 720222 | CO | school | 804410 | 3120 | GREELEY 6 | 80441001989 | 53 | WINOGRAD K-8 ELEMENTARY SCHOOL | Regular School | No | Elementary | KG | 08 | 2017 | pk_12_total | 321 | 1 | 392 | 2 | 7 | 0 | 9 | 376 | 356 | 732 | 321 | 1 | 392 | 2 | 7 | 0 | 9 | 376 | 356 | 732 | ||||||||||||||||||||||||||||||||||
720232 | 720232 | CO | school | 804410 | 3120 | GREELEY 6 | 80441001990 | 54 | BELLA ROMERO ACADEMY OF APPLIED TECHNOLOGY | Regular School | No | Elementary | KG | 08 | 2017 | pk_12_total | 124 | 77 | 915 | 1 | 10 | 1 | 4 | 621 | 511 | 1132 | 124 | 77 | 915 | 1 | 10 | 1 | 4 | 621 | 511 | 1132 | ||||||||||||||||||||||||||||||||||
720104 | 720104 | CO | school | 807350 | 3100 | WINDSOR RE-4 | 80735001987 | 55 | GRANDVIEW ELEMENTARY SCHOOL | Regular School | No | Elementary | PK | 05 | 2017 | pk_12_total | 408 | 3 | 42 | 2 | 1 | 0 | 12 | 243 | 225 | 468 | 408 | 3 | 42 | 2 | 1 | 0 | 12 | 243 | 225 | 468 | ||||||||||||||||||||||||||||||||||
718801 | 718801 | CO | school | 804110 | 2540 | FOWLER R-4J | 80411001981 | 56 | FOWLER ELEMENTARY SCHOOL | Regular School | No | Elementary | KG | 06 | 2017 | pk_12_total | 144 | 0 | 55 | 0 | 0 | 0 | 5 | 96 | 108 | 204 | 144 | 0 | 55 | 0 | 0 | 0 | 5 | 96 | 108 | 204 | ||||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||
717811 | 717811 | CO | school | 802010 | 1620 | AGUILAR REORGANIZED 6 | 80201000022 | 58 | AGUILAR ELEMENTARY SCHOOL | Regular School | No | Elementary | PK | 06 | 2017 | pk_12_total | 33 | 0 | 47 | 0 | 0 | 0 | 0 | 45 | 35 | 80 | 33 | 0 | 47 | 0 | 0 | 0 | 0 | 45 | 35 | 80 | ||||||||||||||||||||||||||||||||||
707985 | 707985 | CO | school | 806900 | 20 | ADAMS 12 FIVE STAR SCHOOLS | 80690001733 | 59 | MERIDIAN ELEMENTARY SCHOOL | Regular School | No | Elementary | KG | 05 | 2017 | pk_12_total | 612 | 13 | 87 | 2 | 37 | 3 | 28 | 414 | 368 | 782 | 612 | 13 | 87 | 2 | 37 | 3 | 28 | 414 | 368 | 782 | ||||||||||||||||||||||||||||||||||
710162 | 710162 | CO | school | 805370 | 470 | ST VRAIN VALLEY RE 1J | 80537001830 | 60 | LEGACY ELEMENTARY SCHOOL | Regular School | No | Elementary | PK | 05 | 2017 | pk_12_total | 488 | 5 | 114 | 3 | 11 | 0 | 16 | 339 | 298 | 637 | 488 | 5 | 114 | 3 | 11 | 0 | 16 | 339 | 298 | 637 | ||||||||||||||||||||||||||||||||||
710170 | 710170 | CO | school | 805370 | 470 | ST VRAIN VALLEY RE 1J | 80537001832 | 61 | ALPINE ELEMENTARY SCHOOL | Regular School | No | Elementary | PK | 05 | 2017 | pk_12_total | 301 | 8 | 193 | 0 | 16 | 1 | 21 | 278 | 262 | 540 | 301 | 8 | 193 | 0 | 16 | 1 | 21 | 278 | 262 | 540 | ||||||||||||||||||||||||||||||||||
715466 | 715466 | CO | school | 807080 | 1390 | HUERFANO RE-1 | 80708001845 | 63 | PEAKVIEW SCHOOL | Regular School | No | Elementary | PK | 08 | 2017 | pk_12_total | 111 | 4 | 206 | 17 | 3 | 1 | 0 | 177 | 165 | 342 | 111 | 4 | 206 | 17 | 3 | 1 | 0 | 177 | 165 | 342 | ||||||||||||||||||||||||||||||||||
715260 | 715260 | CO | school | 806240 | 1195 | GARFIELD RE-2 | 80624001906 | 65 | COAL RIDGE HIGH SCHOOL | Regular School | No | High | 09 | 12 | 2017 | pk_12_total | 282 | 1 | 232 | 1 | 2 | 0 | 9 | 289 | 238 | 527 | 282 | 1 | 232 | 1 | 2 | 0 | 9 | 289 | 238 | 527 | ||||||||||||||||||||||||||||||||||
717819 | 717819 | CO | school | 802010 | 1620 | AGUILAR REORGANIZED 6 | 80201000023 | 66 | AGUILAR JUNIOR-SENIOR HIGH SCHOOL | Regular School | No | High | 07 | 12 | 2017 | pk_12_total | 14 | 0 | 30 | 0 | 0 | 0 | 0 | 27 | 17 | 44 | 14 | 0 | 30 | 0 | 0 | 0 | 0 | 27 | 17 | 44 | ||||||||||||||||||||||||||||||||||
711341 | 711341 | CO | school | 803360 | 880 | DENVER COUNTY 1 | 80336001894 | 67 | ACADEMY OF URBAN LEARNING | Regular School | Yes | High | 09 | 12 | 2017 | pk_12_total | 2 | 6 | 99 | 4 | 1 | 0 | 0 | 63 | 49 | 112 | 2 | 6 | 99 | 4 | 1 | 0 | 0 | 63 | 49 | 112 | ||||||||||||||||||||||||||||||||||
707986 | 707986 | CO | school | 806900 | 20 | ADAMS 12 FIVE STAR SCHOOLS | 80690006435 | 70 | ADAMS12 FIVE STAR PRESCHOOL | Regular School | No | Elementary | PK | PK | 2017 | pk_12_total | 85 | 11 | 198 | 2 | 14 | 1 | 8 | 184 | 135 | 319 | 85 | 11 | 198 | 2 | 14 | 1 | 8 | 184 | 135 | 319 | ||||||||||||||||||||||||||||||||||
710181 | 710181 | CO | school | 805370 | 470 | ST VRAIN VALLEY RE 1J | 80537006530 | 71 | ASPEN RIDGE PREPARATORY SCHOOL | Regular School | Yes | Elementary | KG | 07 | 2017 | pk_12_total | 324 | 8 | 33 | 0 | 28 | 0 | 6 | 189 | 210 | 399 | 324 | 8 | 33 | 0 | 28 | 0 | 6 | 189 | 210 | 399 | ||||||||||||||||||||||||||||||||||
714491 | 714491 | CO | school | 801920 | 1040 | ACADEMY 20 | 80192000001 | 74 | CHALLENGER MIDDLE SCHOOL | Regular School | No | Middle | 06 | 08 | 2017 | pk_12_total | 654 | 20 | 85 | 6 | 53 | 3 | 58 | 450 | 429 | 879 | 654 | 20 | 85 | 6 | 53 | 3 | 58 | 450 | 429 | 879 | ||||||||||||||||||||||||||||||||||
720649 | 720649 | CO | school | 800020 | 8001 | CHARTER SCHOOL INSTITUTE | 80002006418 | 75 | ANIMAS HIGH SCHOOL | Regular School | Yes | High | 09 | 12 | 2017 | pk_12_total | 231 | 2 | 28 | 9 | 0 | 0 | 4 | 144 | 130 | 274 | 231 | 2 | 28 | 9 | 0 | 0 | 4 | 144 | 130 | 274 | ||||||||||||||||||||||||||||||||||
714496 | 714496 | CO | school | 801920 | 1040 | ACADEMY 20 | 80192000002 | 76 | AIR ACADEMY HIGH SCHOOL | Regular School | No | High | 09 | 12 | 2017 | pk_12_total | 999 | 39 | 165 | 6 | 39 | 6 | 87 | 675 | 666 | 1341 | 999 | 39 | 165 | 6 | 39 | 6 | 87 | 675 | 666 | 1341 | ||||||||||||||||||||||||||||||||||
719917 | 719917 | CO | school | 802040 | 3030 | AKRON R-1 | 80204000024 | 86 | AKRON ELEMENTARY SCHOOL | Regular School | No | Elementary | PK | 08 | 2017 | pk_12_total | 201 | 1 | 54 | 2 | 3 | 0 | 8 | 146 | 123 | 269 | 201 | 1 | 54 | 2 | 3 | 0 | 8 | 146 | 123 | 269 | ||||||||||||||||||||||||||||||||||
719923 | 719923 | CO | school | 802040 | 3030 | AKRON R-1 | 80204000025 | 90 | AKRON HIGH SCHOOL | Regular School | No | High | 09 | 12 | 2017 | pk_12_total | 90 | 0 | 14 | 0 | 2 | 0 | 3 | 60 | 49 | 109 | 90 | 0 | 14 | 0 | 2 | 0 | 3 | 60 | 49 | 109 | ||||||||||||||||||||||||||||||||||
711209 | 711209 | CO | school | 803330 | 870 | DELTA COUNTY 50(J) | 80333006681 | 93 | ACHIEVE BLENDED LEARNING ACADEMY | Regular School | No | Other | 06 | 12 | 2017 | pk_12_total | 6 | 0 | 1 | 0 | 0 | 0 | 0 | 4 | 3 | 7 | 6 | 0 | 1 | 0 | 0 | 0 | 0 | 4 | 3 | 7 | ||||||||||||||||||||||||||||||||||
711348 | 711348 | CO | school | 803360 | 880 | DENVER COUNTY 1 | 80336006592 | 99 | ACADEMY 360 | Regular School | Yes | Elementary | PK | 05 | 2017 | pk_12_total | 23 | 68 | 109 | 3 | 1 | 3 | 4 | 103 | 108 | 211 | 23 | 68 | 109 | 3 | 1 | 3 | 4 | 103 | 108 | 211 | ||||||||||||||||||||||||||||||||||
715542 | 715542 | CO | school | 804800 | 1420 | JEFFERSON COUNTY R-1 | 80480000691 | 108 | ALAMEDA INTERNATIONAL JUNIOR/SENIOR HIGH SCHOOL | Regular School | No | High | 07 | 12 | 2017 | pk_12_total | 157 | 15 | 979 | 12 | 50 | 1 | 25 | 650 | 589 | 1239 | 157 | 15 | 979 | 12 | 50 | 1 | 25 | 650 | 589 | 1239 | ||||||||||||||||||||||||||||||||||
715552 | 715552 | CO | school | 804800 | 1420 | JEFFERSON COUNTY R-1 | 80480006489 | 109 | ARVADA K-8 | Regular School | No | Elementary | KG | 08 | 2017 | pk_12_total | 224 | 25 | 322 | 6 | 10 | 3 | 22 | 310 | 302 | 612 | 224 | 25 | 322 | 6 | 10 | 3 | 22 | 310 | 302 | 612 | ||||||||||||||||||||||||||||||||||
714501 | 714501 | CO | school | 801920 | 1040 | ACADEMY 20 | 80192006434 | 110 | ACADEMY ONLINE | Regular School | No | Other | KG | 12 | 2017 | pk_12_total | 71 | 5 | 9 | 0 | 0 | 0 | 3 | 50 | 38 | 88 | 71 | 5 | 9 | 0 | 0 | 0 | 3 | 50 | 38 | 88 | ||||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||
708786 | 708786 | CO | school | 802070 | 100 | ALAMOSA RE-11J | 80207006459 | 115 | ALAMOSA ELEMENTARY SCHOOL | Regular School | No | Elementary | KG | 05 | 2017 | pk_12_total | 325 | 14 | 774 | 12 | 7 | 1 | 25 | 591 | 567 | 1158 | 325 | 14 | 774 | 12 | 7 | 1 | 25 | 591 | 567 | 1158 | ||||||||||||||||||||||||||||||||||
708791 | 708791 | CO | school | 802070 | 100 | ALAMOSA RE-11J | 80207000027 | 118 | ALAMOSA HIGH SCHOOL | Regular School | No | High | 09 | 12 | 2017 | pk_12_total | 203 | 10 | 362 | 6 | 6 | 2 | 9 | 295 | 303 | 598 | 203 | 10 | 362 | 6 | 6 | 2 | 9 | 295 | 303 | 598 | ||||||||||||||||||||||||||||||||||
710195 | 710195 | CO | school | 805370 | 470 | ST VRAIN VALLEY RE 1J | 80537006539 | 120 | APEX HOME SCHOOL ENRICHMENT PROGRAM | Regular School | No | Other | KG | 12 | 2017 | pk_12_total | 670 | 3 | 81 | 3 | 18 | 0 | 27 | 419 | 383 | 802 | 670 | 3 | 81 | 3 | 18 | 0 | 27 | 419 | 383 | 802 | ||||||||||||||||||||||||||||||||||
708365 | 708365 | CO | school | 801950 | 30 | ADAMS COUNTY 14 | 80195001947 | 124 | STARS EARLY LEARNING CENTER | Regular School | No | Elementary | PK | PK | 2017 | pk_12_total | 13 | 9 | 96 | 0 | 0 | 0 | 2 | 65 | 55 | 120 | 13 | 9 | 96 | 0 | 0 | 0 | 2 | 65 | 55 | 120 | ||||||||||||||||||||||||||||||||||
710556 | 710556 | CO | school | 802490 | 480 | BOULDER VALLEY RE 2 | 80249001219 | 125 | ARAPAHOE RIDGE HIGH SCHOOL | Alternative School | No | High | 09 | 12 | 2017 | pk_12_total | 32 | 2 | 63 | 1 | 1 | 0 | 1 | 52 | 48 | 100 | 32 | 2 | 63 | 1 | 1 | 0 | 1 | 52 | 48 | 100 | ||||||||||||||||||||||||||||||||||
712715 | 712715 | CO | school | 803450 | 900 | DOUGLAS COUNTY RE 1 | 80345006492 | 135 | BEN FRANKLIN ACADEMY | Regular School | Yes | Elementary | PK | 08 | 2017 | pk_12_total | 693 | 7 | 94 | 1 | 50 | 0 | 38 | 439 | 444 | 883 | 693 | 7 | 94 | 1 | 50 | 0 | 38 | 439 | 444 | 883 | ||||||||||||||||||||||||||||||||||
709494 | 709494 | CO | school | 802340 | 180 | ADAMS-ARAPAHOE 28J | 80234006625 | 136 | APS EARLY BEGINNINGS - A ZOOM SITE | Regular School | No | Elementary | PK | PK | 2017 | pk_12_total | 6 | 8 | 25 | 1 | 1 | 0 | 1 | 23 | 19 | 42 | 6 | 8 | 25 | 1 | 1 | 0 | 1 | 23 | 19 | 42 | ||||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||
717085 | 717085 | CO | school | 803990 | 1550 | POUDRE R-1 | 80399001717 | 146 | RIDGEVIEW CLASSICAL CHARTER SCHOOLS | Regular School | Yes | Other | KG | 12 | 2017 | pk_12_total | 585 | 2 | 107 | 3 | 34 | 1 | 42 | 363 | 411 | 774 | 585 | 2 | 107 | 3 | 34 | 1 | 42 | 363 | 411 | 774 | ||||||||||||||||||||||||||||||||||
715560 | 715560 | CO | school | 804800 | 1420 | JEFFERSON COUNTY R-1 | 80480000692 | 148 | ALLENDALE ELEMENTARY SCHOOL | Regular School | No | Elementary | PK | 06 | 2017 | pk_12_total | 138 | 0 | 82 | 5 | 2 | 1 | 15 | 129 | 114 | 243 | 138 | 0 | 82 | 5 | 2 | 1 | 15 | 129 | 114 | 243 | ||||||||||||||||||||||||||||||||||
708373 | 708373 | CO | school | 801950 | 30 | ADAMS COUNTY 14 | 80195000011 | 186 | ALSUP ELEMENTARY SCHOOL | Regular School | No | Elementary | KG | 05 | 2017 | pk_12_total | 67 | 6 | 439 | 3 | 3 | 2 | 12 | 265 | 267 | 532 | 67 | 6 | 439 | 3 | 3 | 2 | 12 | 265 | 267 | 532 | ||||||||||||||||||||||||||||||||||
707825 | 707825 | CO | school | 805550 | 10 | MAPLETON 1 | 80555001857 | 187 | MAPLETON EXPEDITIONARY SCHOOL OF THE ARTS | Regular School | No | High | 07 | 12 | 2017 | pk_12_total | 145 | 13 | 453 | 7 | 5 | 1 | 14 | 324 | 314 | 638 | 145 | 13 | 453 | 7 | 5 | 1 | 14 | 324 | 314 | 638 | ||||||||||||||||||||||||||||||||||
719021 | 719021 | CO | school | 805220 | 2660 | LAMAR RE-2 | 80522000860 | 200 | ALTA VISTA CHARTER SCHOOL | Regular School | Yes | Elementary | KG | 06 | 2017 | pk_12_total | 84 | 2 | 37 | 1 | 0 | 0 | 2 | 63 | 63 | 126 | 84 | 2 | 37 | 1 | 0 | 0 | 2 | 63 | 63 | 126 | ||||||||||||||||||||||||||||||||||
712719 | 712719 | CO | school | 803450 | 900 | DOUGLAS COUNTY RE 1 | 80345006218 | 201 | DANIEL C OAKES HIGH SCHOOL--CASTLE ROCK | Alternative School | No | High | 09 | 12 | 2017 | pk_12_total | 123 | 1 | 25 | 0 | 1 | 0 | 11 | 97 | 64 | 161 | 123 | 1 | 25 | 0 | 1 | 0 | 11 | 97 | 64 | 161 | ||||||||||||||||||||||||||||||||||
713928 | 713928 | CO | school | 804080 | 1000 | FOUNTAIN 8 | 80408000096 | 203 | WELTE EDUCATION CENTER | Alternative School | No | High | 09 | 12 | 2017 | pk_12_total | 54 | 8 | 30 | 1 | 0 | 2 | 12 | 65 | 42 | 107 | 54 | 8 | 30 | 1 | 0 | 2 | 12 | 65 | 42 | 107 | ||||||||||||||||||||||||||||||||||
713434 | 713434 | CO | school | 803540 | 910 | EAGLE COUNTY RE 50 | 80354001756 | 205 | RED CANYON HIGH SCHOOL | Alternative School | No | High | 09 | 12 | 2017 | pk_12_total | 42 | 0 | 128 | 0 | 0 | 0 | 2 | 114 | 58 | 172 | 42 | 0 | 128 | 0 | 0 | 0 | 2 | 114 | 58 | 172 | ||||||||||||||||||||||||||||||||||
708820 | 708820 | CO | school | 803780 | 120 | ENGLEWOOD 1 | 80378001310 | 206 | COLORADO'S FINEST HIGH SCHOOL OF CHOICE | Alternative School | No | High | 09 | 12 | 2017 | pk_12_total | 175 | 5 | 100 | 2 | 3 | 1 | 7 | 164 | 129 | 293 | 175 | 5 | 100 | 2 | 3 | 1 | 7 | 164 | 129 | 293 | ||||||||||||||||||||||||||||||||||
714508 | 714508 | CO | school | 801920 | 1040 | ACADEMY 20 | 80192000858 | 209 | ASPEN VALLEY CAMPUS | Alternative School | No | High | 07 | 12 | 2017 | pk_12_total | 127 | 2 | 28 | 2 | 3 | 2 | 5 | 94 | 75 | 169 | 127 | 2 | 28 | 2 | 3 | 2 | 5 | 94 | 75 | 169 | ||||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||
707830 | 707830 | CO | school | 805550 | 10 | MAPLETON 1 | 80555001858 | 212 | MAPLETON EARLY COLLEGE HIGH SCHOOL | Regular School | No | High | 09 | 12 | 2017 | pk_12_total | 55 | 4 | 171 | 2 | 4 | 1 | 8 | 121 | 124 | 245 | 55 | 4 | 171 | 2 | 4 | 1 | 8 | 121 | 124 | 245 | ||||||||||||||||||||||||||||||||||
709505 | 709505 | CO | school | 802340 | 180 | ADAMS-ARAPAHOE 28J | 80234006399 | 213 | AXL ACADEMY | Regular School | Yes | Elementary | PK | 08 | 2017 | pk_12_total | 117 | 169 | 224 | 3 | 7 | 1 | 42 | 288 | 275 | 563 | 117 | 169 | 224 | 3 | 7 | 1 | 42 | 288 | 275 | 563 | ||||||||||||||||||||||||||||||||||
709513 | 709513 | CO | school | 802340 | 180 | ADAMS-ARAPAHOE 28J | 80234000052 | 214 | ALTURA ELEMENTARY SCHOOL | Regular School | No | Elementary | PK | 05 | 2017 | pk_12_total | 51 | 55 | 443 | 2 | 13 | 4 | 8 | 313 | 263 | 576 | 51 | 55 | 443 | 2 | 13 | 4 | 8 | 313 | 263 | 576 | ||||||||||||||||||||||||||||||||||
712730 | 712730 | CO | school | 803450 | 900 | DOUGLAS COUNTY RE 1 | 80345001896 | 215 | AMERICAN ACADEMY | Regular School | Yes | Elementary | PK | 08 | 2017 | pk_12_total | 1319 | 13 | 128 | 11 | 207 | 0 | 92 | 881 | 889 | 1770 | 1319 | 13 | 128 | 11 | 207 | 0 | 92 | 881 | 889 | 1770 | ||||||||||||||||||||||||||||||||||
709519 | 709519 | CO | school | 802340 | 180 | ADAMS-ARAPAHOE 28J | 80234006476 | 219 | APS ONLINE SCHOOL | Regular School | No | High | 09 | 12 | 2017 | pk_12_total | 37 | 27 | 105 | 4 | 2 | 0 | 9 | 76 | 108 | 184 | 37 | 27 | 105 | 4 | 2 | 0 | 9 | 76 | 108 | 184 | ||||||||||||||||||||||||||||||||||
711356 | 711356 | CO | school | 803360 | 880 | DENVER COUNTY 1 | 80336000306 | 220 | AMESSE ELEMENTARY SCHOOL | Regular School | No | Elementary | PK | 05 | 2017 | pk_12_total | 19 | 82 | 347 | 3 | 4 | 5 | 10 | 252 | 218 | 470 | 19 | 82 | 347 | 3 | 4 | 5 | 10 | 252 | 218 | 470 | ||||||||||||||||||||||||||||||||||
716943 | 716943 | CO | school | 803480 | 1520 | DURANGO 9-R | 80348001066 | 225 | ANIMAS VALLEY ELEMENTARY SCHOOL | Regular School | No | Elementary | PK | 05 | 2017 | pk_12_total | 183 | 1 | 92 | 6 | 1 | 0 | 10 | 154 | 139 | 293 | 183 | 1 | 92 | 6 | 1 | 0 | 10 | 154 | 139 | 293 | ||||||||||||||||||||||||||||||||||
710199 | 710199 | CO | school | 805370 | 470 | ST VRAIN VALLEY RE 1J | 80537001886 | 226 | ALTONA MIDDLE SCHOOL | Regular School | No | Middle | 06 | 08 | 2017 | pk_12_total | 607 | 9 | 91 | 1 | 78 | 3 | 23 | 410 | 402 | 812 | 607 | 9 | 91 | 1 | 78 | 3 | 23 | 410 | 402 | 812 | ||||||||||||||||||||||||||||||||||
708912 | 708912 | CO | school | 802910 | 130 | CHERRY CREEK 5 | 80291001670 | 242 | ANTELOPE RIDGE ELEMENTARY SCHOOL | Regular School | No | Elementary | PK | 05 | 2017 | pk_12_total | 369 | 65 | 118 | 1 | 35 | 6 | 48 | 333 | 309 | 642 | 369 | 65 | 118 | 1 | 35 | 6 | 48 | 333 | 309 | 642 | ||||||||||||||||||||||||||||||||||
708919 | 708919 | CO | school | 802910 | 130 | CHERRY CREEK 5 | 80291002032 | 243 | COYOTE HILLS ELEMENTARY SCHOOL | Regular School | No | Elementary | PK | 05 | 2017 | pk_12_total | 450 | 24 | 82 | 2 | 69 | 2 | 46 | 344 | 331 | 675 | 450 | 24 | 82 | 2 | 69 | 2 | 46 | 344 | 331 | 675 | ||||||||||||||||||||||||||||||||||
711132 | 711132 | CO | school | 802130 | 580 | SOUTH CONEJOS RE-10 | 80213000033 | 248 | GUADALUPE ELEMENTARY SCHOOL | Regular School | No | Elementary | KG | 06 | 2017 | pk_12_total | 13 | 1 | 107 | 2 | 0 | 0 | 0 | 59 | 64 | 123 | 13 | 1 | 107 | 2 | 0 | 0 | 0 | 59 | 64 | 123 | ||||||||||||||||||||||||||||||||||
714516 | 714516 | CO | school | 801920 | 1040 | ACADEMY 20 | 80192000123 | 249 | ANTELOPE TRAILS ELEMENTARY SCHOOL | Regular School | No | Elementary | PK | 05 | 2017 | pk_12_total | 300 | 6 | 52 | 1 | 5 | 0 | 22 | 193 | 193 | 386 | 300 | 6 | 52 | 1 | 5 | 0 | 22 | 193 | 193 | 386 | ||||||||||||||||||||||||||||||||||
711135 | 711135 | CO | school | 802130 | 580 | SOUTH CONEJOS RE-10 | 80213001464 | 250 | ANTONITO MIDDLE SCHOOL | Regular School | No | Middle | 07 | 08 | 2017 | pk_12_total | 2 | 0 | 27 | 1 | 0 | 0 | 1 | 13 | 18 | 31 | 2 | 0 | 27 | 1 | 0 | 0 | 1 | 13 | 18 | 31 | ||||||||||||||||||||||||||||||||||
711140 | 711140 | CO | school | 802130 | 580 | SOUTH CONEJOS RE-10 | 80213000035 | 252 | ANTONITO HIGH SCHOOL | Regular School | No | High | 09 | 12 | 2017 | pk_12_total | 0 | 0 | 57 | 1 | 0 | 0 | 0 | 28 | 30 | 58 | 0 | 0 | 57 | 1 | 0 | 0 | 0 | 28 | 30 | 58 | ||||||||||||||||||||||||||||||||||
718037 | 718037 | CO | school | 804350 | 2000 | MESA COUNTY VALLEY 51 | 80435000597 | 262 | APPLETON ELEMENTARY SCHOOL | Regular School | No | Elementary | PK | 05 | 2017 | pk_12_total | 307 | 4 | 67 | 2 | 14 | 3 | 17 | 200 | 214 | 414 | 307 | 4 | 67 | 2 | 14 | 3 | 17 | 200 | 214 | 414 | ||||||||||||||||||||||||||||||||||
707835 | 707835 | CO | school | 805550 | 10 | MAPLETON 1 | 80555001860 | 263 | GLOBAL LEADERSHIP ACADEMY | Regular School | No | High | 09 | 12 | 2017 | pk_12_total | 13 | 1 | 182 | 0 | 2 | 0 | 1 | 105 | 94 | 199 | 13 | 1 | 182 | 0 | 2 | 0 | 1 | 105 | 94 | 199 | ||||||||||||||||||||||||||||||||||
712734 | 712734 | CO | school | 803450 | 900 | DOUGLAS COUNTY RE 1 | 80345006404 | 264 | CIMARRON MIDDLE | Regular School | No | Middle | 06 | 08 | 2017 | pk_12_total | 1181 | 14 | 159 | 6 | 24 | 1 | 63 | 746 | 702 | 1448 | 1181 | 14 | 159 | 6 | 24 | 1 | 63 | 746 | 702 | 1448 | ||||||||||||||||||||||||||||||||||
712743 | 712743 | CO | school | 803450 | 900 | DOUGLAS COUNTY RE 1 | 80345006392 | 265 | CLEAR SKY ELEMENTARY | Regular School | No | Elementary | PK | 06 | 2017 | pk_12_total | 580 | 6 | 151 | 3 | 11 | 2 | 36 | 420 | 369 | 789 | 580 | 6 | 151 | 3 | 11 | 2 | 36 | 420 | 369 | 789 | ||||||||||||||||||||||||||||||||||
712752 | 712752 | CO | school | 803450 | 900 | DOUGLAS COUNTY RE 1 | 80345006368 | 266 | GOLD RUSH ELEMENTARY | Regular School | No | Elementary | PK | 05 | 2017 | pk_12_total | 523 | 7 | 56 | 2 | 21 | 0 | 38 | 342 | 305 | 647 | 523 | 7 | 56 | 2 | 21 | 0 | 38 | 342 | 305 | 647 |
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]);