enrollments
Data source: Big Local News · About: Big Local
586 rows where grade = "grade_7", state = "CO" and year = 2016 sorted by native_american_alaskan_native
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
835510 | 835510 | CO | school | 10 | MAPLETON 1 | 263 | GLOBAL LEADERSHIP ACADEMY | 2016 | grade_7 | 7 | 1 | 46 | 0 | 0 | 0 | 0 | 30 | 24 | 54 | 7 | 1 | 46 | 0 | 0 | 0 | 0 | 30 | 24 | 54 | |||||||||||||||||||||||||||||||||||||||||
835527 | 835527 | CO | school | 10 | MAPLETON 1 | 501 | MONTEREY COMMUNITY SCHOOL | 2016 | grade_7 | 6 | 1 | 44 | 0 | 0 | 0 | 1 | 24 | 28 | 52 | 6 | 1 | 44 | 0 | 0 | 0 | 1 | 24 | 28 | 52 | |||||||||||||||||||||||||||||||||||||||||
835552 | 835552 | CO | school | 10 | MAPLETON 1 | 503 | YORK INTERNATIONAL | 2016 | grade_7 | 7 | 0 | 42 | 0 | 2 | 0 | 3 | 29 | 25 | 54 | 7 | 0 | 42 | 0 | 2 | 0 | 3 | 29 | 25 | 54 | |||||||||||||||||||||||||||||||||||||||||
835572 | 835572 | CO | school | 10 | MAPLETON 1 | 505 | ACHIEVE ACADEMY | 2016 | grade_7 | 8 | 0 | 46 | 0 | 1 | 0 | 1 | 28 | 28 | 56 | 8 | 0 | 46 | 0 | 1 | 0 | 1 | 28 | 28 | 56 | |||||||||||||||||||||||||||||||||||||||||
835601 | 835601 | CO | school | 10 | MAPLETON 1 | 509 | CLAYTON PARTNERSHIP SCHOOL | 2016 | grade_7 | 12 | 1 | 38 | 0 | 5 | 0 | 4 | 32 | 28 | 60 | 12 | 1 | 38 | 0 | 5 | 0 | 4 | 32 | 28 | 60 | |||||||||||||||||||||||||||||||||||||||||
835657 | 835657 | CO | school | 20 | ADAMS 12 FIVE STAR SCHOOLS | 210 | VANTAGE POINT | 2016 | grade_7 | 4 | 1 | 3 | 0 | 0 | 0 | 1 | 8 | 1 | 9 | 4 | 1 | 3 | 0 | 0 | 0 | 1 | 8 | 1 | 9 | |||||||||||||||||||||||||||||||||||||||||
835688 | 835688 | CO | school | 806900 | 20 | ADAMS 12 FIVE STAR SCHOOLS | 80690000728 | 1519 | STARGATE CHARTER SCHOOL | Regular School | Yes | 4.0 | KG | 09 | 2016 | grade_7 | 57 | 0 | 7 | 0 | 17 | 0 | 2 | 40 | 43 | 83 | 57 | 0 | 7 | 0 | 17 | 0 | 2 | 40 | 43 | 83 | ||||||||||||||||||||||||||||||||||
835807 | 835807 | CO | school | 806900 | 20 | ADAMS 12 FIVE STAR SCHOOLS | 80690001178 | 4172 | HULSTROM OPTIONS K-8 SCHOOL | Regular School | No | 1.0 | KG | 08 | 2016 | grade_7 | 63 | 1 | 13 | 0 | 7 | 1 | 3 | 43 | 45 | 88 | 63 | 1 | 13 | 0 | 7 | 1 | 3 | 43 | 45 | 88 | ||||||||||||||||||||||||||||||||||
835864 | 835864 | CO | school | 806900 | 20 | ADAMS 12 FIVE STAR SCHOOLS | 80690001186 | 6342 | SHADOW RIDGE MIDDLE SCHOOL | Regular School | No | 2.0 | 06 | 08 | 2016 | grade_7 | 169 | 10 | 123 | 0 | 16 | 0 | 5 | 161 | 162 | 323 | 169 | 10 | 123 | 0 | 16 | 0 | 5 | 161 | 162 | 323 | ||||||||||||||||||||||||||||||||||
835947 | 835947 | CO | school | 806900 | 20 | ADAMS 12 FIVE STAR SCHOOLS | 80690006468 | 8275 | STEM LAB | Regular School | No | 1.0 | KG | 08 | 2016 | grade_7 | 45 | 1 | 9 | 0 | 1 | 0 | 1 | 32 | 25 | 57 | 45 | 1 | 9 | 0 | 1 | 0 | 1 | 32 | 25 | 57 | ||||||||||||||||||||||||||||||||||
835957 | 835957 | CO | school | 806900 | 20 | ADAMS 12 FIVE STAR SCHOOLS | 80690006561 | 8310 | STEM LAUNCH | Regular School | No | 1.0 | KG | 08 | 2016 | grade_7 | 32 | 1 | 118 | 0 | 5 | 0 | 0 | 81 | 75 | 156 | 32 | 1 | 118 | 0 | 5 | 0 | 0 | 81 | 75 | 156 | ||||||||||||||||||||||||||||||||||
835985 | 835985 | CO | school | 806900 | 20 | ADAMS 12 FIVE STAR SCHOOLS | 80690006417 | 9431 | WESTGATE CHARTER | Regular School | Yes | 4.0 | KG | 12 | 2016 | grade_7 | 41 | 0 | 7 | 0 | 4 | 0 | 1 | 26 | 27 | 53 | 41 | 0 | 7 | 0 | 4 | 0 | 1 | 26 | 27 | 53 | ||||||||||||||||||||||||||||||||||
836119 | 836119 | CO | school | 802580 | 40 | SCHOOL DISTRICT 27J | 80258001729 | 1052 | BROMLEY EAST CHARTER SCHOOL | Regular School | Yes | 1.0 | PK | 08 | 2016 | grade_7 | 75 | 0 | 30 | 0 | 1 | 1 | 1 | 58 | 50 | 108 | 75 | 0 | 30 | 0 | 1 | 1 | 1 | 58 | 50 | 108 | ||||||||||||||||||||||||||||||||||
836160 | 836160 | CO | school | 802580 | 40 | SCHOOL DISTRICT 27J | 80258006325 | 4950 | LANDMARK ACADEMY AT REUNION | Regular School | Yes | 1.0 | KG | 08 | 2016 | grade_7 | 42 | 4 | 25 | 0 | 1 | 0 | 5 | 42 | 35 | 77 | 42 | 4 | 25 | 0 | 1 | 0 | 5 | 42 | 35 | 77 | ||||||||||||||||||||||||||||||||||
836273 | 836273 | CO | school | 50 | BENNETT 29J | 774 | BENNETT MIDDLE SCHOOL | 2016 | grade_7 | 69 | 0 | 17 | 0 | 0 | 0 | 2 | 48 | 40 | 88 | 69 | 0 | 17 | 0 | 0 | 0 | 2 | 48 | 40 | 88 | |||||||||||||||||||||||||||||||||||||||||
836293 | 836293 | CO | school | 806750 | 60 | STRASBURG 31J | 80675001160 | 8332 | HEMPHILL MIDDLE SCHOOL | Regular School | No | 2.0 | 06 | 08 | 2016 | grade_7 | 60 | 1 | 16 | 0 | 0 | 0 | 0 | 49 | 28 | 77 | 60 | 1 | 16 | 0 | 0 | 0 | 0 | 49 | 28 | 77 | ||||||||||||||||||||||||||||||||||
836343 | 836343 | CO | school | 807230 | 70 | WESTMINSTER PUBLIC SCHOOLS | 80723006567 | 4334 | COLORADO STEM ACADEMY | Regular School | No | 1.0 | 03 | 08 | 2016 | grade_7 | 20 | 1 | 21 | 0 | 0 | 0 | 0 | 26 | 16 | 42 | 20 | 1 | 21 | 0 | 0 | 0 | 0 | 26 | 16 | 42 | ||||||||||||||||||||||||||||||||||
836355 | 836355 | CO | school | 807230 | 70 | WESTMINSTER PUBLIC SCHOOLS | 80723001241 | 5388 | M. SCOTT CARPENTER MIDDLE SCHOOL | Regular School | No | 2.0 | 06 | 08 | 2016 | grade_7 | 9 | 3 | 156 | 0 | 9 | 0 | 1 | 97 | 81 | 178 | 9 | 3 | 156 | 0 | 9 | 0 | 1 | 97 | 81 | 178 | ||||||||||||||||||||||||||||||||||
836442 | 836442 | CO | school | 100 | ALAMOSA RE-11J | 368 | ALAMOSA OMBUDSMAN SCHOOL OF EXCELLENCE | 2016 | grade_7 | 2 | 0 | 2 | 0 | 0 | 0 | 0 | 2 | 2 | 4 | 2 | 0 | 2 | 0 | 0 | 0 | 0 | 2 | 2 | 4 | |||||||||||||||||||||||||||||||||||||||||
836497 | 836497 | CO | school | 803780 | 120 | ENGLEWOOD 1 | 80378001772 | 2750 | ENGLEWOOD LEADERSHIP ACADEMY | Regular School | No | 2.0 | 06 | 09 | 2016 | grade_7 | 27 | 0 | 5 | 0 | 2 | 0 | 1 | 15 | 20 | 35 | 27 | 0 | 5 | 0 | 2 | 0 | 1 | 15 | 20 | 35 | ||||||||||||||||||||||||||||||||||
836500 | 836500 | CO | school | 803780 | 120 | ENGLEWOOD 1 | 80378006331 | 2752 | ENGLEWOOD MIDDLE SCHOOL | Regular School | No | 2.0 | 07 | 08 | 2016 | grade_7 | 74 | 2 | 76 | 0 | 0 | 0 | 5 | 76 | 81 | 157 | 74 | 2 | 76 | 0 | 0 | 0 | 5 | 76 | 81 | 157 | ||||||||||||||||||||||||||||||||||
836549 | 836549 | CO | school | 130 | CHERRY CREEK 5 | 141 | SKY VISTA MIDDLE SCHOOL | 2016 | grade_7 | 163 | 31 | 59 | 0 | 22 | 1 | 14 | 143 | 147 | 290 | 163 | 31 | 59 | 0 | 22 | 1 | 14 | 143 | 147 | 290 | |||||||||||||||||||||||||||||||||||||||||
836610 | 836610 | CO | school | 802910 | 130 | CHERRY CREEK 5 | 80291000763 | 1510 | CHALLENGE SCHOOL | Regular School | No | 1.0 | PK | 08 | 2016 | grade_7 | 34 | 6 | 7 | 0 | 20 | 1 | 7 | 41 | 34 | 75 | 34 | 6 | 7 | 0 | 20 | 1 | 7 | 41 | 34 | 75 | ||||||||||||||||||||||||||||||||||
836713 | 836713 | CO | school | 802910 | 130 | CHERRY CREEK 5 | 80291001672 | 2897 | FALCON CREEK MIDDLE SCHOOL | Regular School | No | 2.0 | 06 | 08 | 2016 | grade_7 | 190 | 26 | 56 | 0 | 26 | 0 | 17 | 161 | 154 | 315 | 190 | 26 | 56 | 0 | 26 | 0 | 17 | 161 | 154 | 315 | ||||||||||||||||||||||||||||||||||
836717 | 836717 | CO | school | 802910 | 130 | CHERRY CREEK 5 | 80291006367 | 3030 | FOX RIDGE MIDDLE SCHOOL | Regular School | No | 2.0 | 06 | 08 | 2016 | grade_7 | 299 | 28 | 54 | 0 | 32 | 0 | 25 | 222 | 216 | 438 | 299 | 28 | 54 | 0 | 32 | 0 | 25 | 222 | 216 | 438 | ||||||||||||||||||||||||||||||||||
836829 | 836829 | CO | school | 802910 | 130 | CHERRY CREEK 5 | 80291006563 | 6367 | OPTIONS SCHOOL | Alternative Education School | No | 4.0 | KG | 12 | 2016 | grade_7 | 46 | 0 | 8 | 0 | 1 | 0 | 3 | 28 | 30 | 58 | 46 | 0 | 8 | 0 | 1 | 0 | 3 | 28 | 30 | 58 | ||||||||||||||||||||||||||||||||||
837037 | 837037 | CO | school | 805310 | 140 | LITTLETON 6 | 80531001515 | 5229 | LITTLETON ACADEMY | Regular School | Yes | 1.0 | KG | 08 | 2016 | grade_7 | 44 | 1 | 1 | 0 | 5 | 0 | 2 | 20 | 33 | 53 | 44 | 1 | 1 | 0 | 5 | 0 | 2 | 20 | 33 | 53 | ||||||||||||||||||||||||||||||||||
837047 | 837047 | CO | school | 805310 | 140 | LITTLETON 6 | 80531001626 | 5233 | LITTLETON PREP CHARTER SCHOOL | Regular School | Yes | 1.0 | PK | 08 | 2016 | grade_7 | 41 | 1 | 16 | 0 | 2 | 0 | 0 | 25 | 35 | 60 | 41 | 1 | 16 | 0 | 2 | 0 | 0 | 25 | 35 | 60 | ||||||||||||||||||||||||||||||||||
837126 | 837126 | CO | school | 803270 | 170 | DEER TRAIL 26J | 80327000288 | 2140 | DEER TRAIL JUNIOR-SENIOR HIGH SCHOOL | Regular School | No | 4.0 | 06 | 12 | 2016 | grade_7 | 10 | 0 | 3 | 0 | 0 | 0 | 0 | 7 | 6 | 13 | 10 | 0 | 3 | 0 | 0 | 0 | 0 | 7 | 6 | 13 | ||||||||||||||||||||||||||||||||||
837136 | 837136 | CO | school | 180 | ADAMS-ARAPAHOE 28J | 1 | FACILITIES WITH DISTRICT RUN EDUCATION | 2016 | grade_7 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 1 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 1 | |||||||||||||||||||||||||||||||||||||||||
837180 | 837180 | CO | school | 180 | ADAMS-ARAPAHOE 28J | 458 | AURORA ACADEMY CHARTER SCHOOL | 2016 | grade_7 | 13 | 13 | 24 | 0 | 1 | 0 | 3 | 28 | 26 | 54 | 13 | 13 | 24 | 0 | 1 | 0 | 3 | 28 | 26 | 54 | |||||||||||||||||||||||||||||||||||||||||
837185 | 837185 | CO | school | 180 | ADAMS-ARAPAHOE 28J | 464 | AURORA HILLS MIDDLE SCHOOL | 2016 | grade_7 | 41 | 61 | 189 | 0 | 4 | 3 | 14 | 151 | 161 | 312 | 41 | 61 | 189 | 0 | 4 | 3 | 14 | 151 | 161 | 312 | |||||||||||||||||||||||||||||||||||||||||
837194 | 837194 | CO | school | 180 | ADAMS-ARAPAHOE 28J | 465 | AURORA FRONTIER K-8 | 2016 | grade_7 | 32 | 12 | 21 | 0 | 10 | 0 | 8 | 47 | 36 | 83 | 32 | 12 | 21 | 0 | 10 | 0 | 8 | 47 | 36 | 83 | |||||||||||||||||||||||||||||||||||||||||
837205 | 837205 | CO | school | 180 | ADAMS-ARAPAHOE 28J | 914 | BOSTON K-8 SCHOOL | 2016 | grade_7 | 0 | 5 | 18 | 0 | 9 | 1 | 0 | 17 | 16 | 33 | 0 | 5 | 18 | 0 | 9 | 1 | 0 | 17 | 16 | 33 | |||||||||||||||||||||||||||||||||||||||||
837278 | 837278 | CO | school | 802340 | 180 | ADAMS-ARAPAHOE 28J | 80234006644 | 2673 | EDNA AND JOHN W. MOSLEY P-8 | Regular School | No | 1.0 | PK | 08 | 2016 | grade_7 | 12 | 7 | 39 | 0 | 2 | 1 | 3 | 38 | 26 | 64 | 12 | 7 | 39 | 0 | 2 | 1 | 3 | 38 | 26 | 64 | ||||||||||||||||||||||||||||||||||
837403 | 837403 | CO | school | 802340 | 180 | ADAMS-ARAPAHOE 28J | 80234001881 | 6189 | MURPHY CREEK K-8 SCHOOL | Regular School | No | 1.0 | PK | 08 | 2016 | grade_7 | 26 | 9 | 28 | 0 | 4 | 0 | 12 | 38 | 41 | 79 | 26 | 9 | 28 | 0 | 4 | 0 | 12 | 38 | 41 | 79 | ||||||||||||||||||||||||||||||||||
837421 | 837421 | CO | school | 802340 | 180 | ADAMS-ARAPAHOE 28J | 80234001789 | 6546 | OPTIONS SCHOOL | Regular School | No | 4.0 | KG | 12 | 2016 | grade_7 | 53 | 2 | 12 | 0 | 0 | 0 | 3 | 40 | 30 | 70 | 53 | 2 | 12 | 0 | 0 | 0 | 3 | 40 | 30 | 70 | ||||||||||||||||||||||||||||||||||
837456 | 837456 | CO | school | 802340 | 180 | ADAMS-ARAPAHOE 28J | 80234001674 | 7232 | AURORA QUEST K-8 | Regular School | No | 1.0 | KG | 08 | 2016 | grade_7 | 36 | 9 | 20 | 0 | 13 | 1 | 8 | 46 | 41 | 87 | 36 | 9 | 20 | 0 | 13 | 1 | 8 | 46 | 41 | 87 | ||||||||||||||||||||||||||||||||||
837511 | 837511 | CO | school | 802340 | 180 | ADAMS-ARAPAHOE 28J | 80234006322 | 9056 | VANGUARD CLASSICAL SCHOOL - WEST | Regular School | Yes | 1.0 | KG | 08 | 2016 | grade_7 | 6 | 6 | 40 | 0 | 0 | 0 | 3 | 25 | 30 | 55 | 6 | 6 | 40 | 0 | 0 | 0 | 3 | 25 | 30 | 55 | ||||||||||||||||||||||||||||||||||
837604 | 837604 | CO | school | 802700 | 190 | BYERS 32J | 80270000164 | 1176 | BYERS JUNIOR-SENIOR HIGH SCHOOL | Regular School | No | 3.0 | 07 | 12 | 2016 | grade_7 | 32 | 0 | 5 | 0 | 0 | 0 | 1 | 18 | 20 | 38 | 32 | 0 | 5 | 0 | 0 | 0 | 1 | 18 | 20 | 38 | ||||||||||||||||||||||||||||||||||
837636 | 837636 | CO | school | 802700 | 190 | BYERS 32J | 80270006548 | 3362 | GREAT PLAINS ACADEMY | Regular School | No | 4.0 | KG | 12 | 2016 | grade_7 | 10 | 0 | 3 | 0 | 0 | 0 | 0 | 4 | 9 | 13 | 10 | 0 | 3 | 0 | 0 | 0 | 0 | 4 | 9 | 13 | ||||||||||||||||||||||||||||||||||
837682 | 837682 | CO | school | 807110 | 230 | WALSH RE-1 | 80711001216 | 9226 | WALSH HIGH SCHOOL | Regular School | No | 3.0 | 07 | 12 | 2016 | grade_7 | 5 | 0 | 4 | 0 | 0 | 0 | 0 | 4 | 5 | 9 | 5 | 0 | 4 | 0 | 0 | 0 | 0 | 4 | 5 | 9 | ||||||||||||||||||||||||||||||||||
837695 | 837695 | CO | school | 806090 | 240 | PRITCHETT RE-3 | 80609001952 | 7176 | PRITCHETT MIDDLE SCHOOL | Regular School | No | 2.0 | 06 | 08 | 2016 | grade_7 | 2 | 0 | 1 | 0 | 0 | 0 | 0 | 2 | 1 | 3 | 2 | 0 | 1 | 0 | 0 | 0 | 0 | 2 | 1 | 3 | ||||||||||||||||||||||||||||||||||
837715 | 837715 | CO | school | 806630 | 250 | SPRINGFIELD RE-4 | 80663001142 | 8168 | SPRINGFIELD JUNIOR/SENIOR HIGH SCHOOL | Regular School | No | 3.0 | 07 | 12 | 2016 | grade_7 | 14 | 0 | 5 | 0 | 0 | 0 | 0 | 12 | 7 | 19 | 14 | 0 | 5 | 0 | 0 | 0 | 0 | 12 | 7 | 19 | ||||||||||||||||||||||||||||||||||
837725 | 837725 | CO | school | 806990 | 260 | VILAS RE-5 | 80699001805 | 9085 | V.I.L.A.S. ONLINE SCHOOL | Regular School | No | 1.0 | KG | 08 | 2016 | grade_7 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 1 | ||||||||||||||||||||||||||||||||||
837740 | 837740 | CO | school | 806990 | 260 | VILAS RE-5 | 80699001207 | 9100 | VILAS UNDIVIDED HIGH SCHOOL | Regular School | No | 3.0 | 07 | 12 | 2016 | grade_7 | 2 | 0 | 2 | 0 | 0 | 0 | 0 | 1 | 3 | 4 | 2 | 0 | 2 | 0 | 0 | 0 | 0 | 1 | 3 | 4 | ||||||||||||||||||||||||||||||||||
837755 | 837755 | CO | school | 802760 | 270 | CAMPO RE-6 | 80276000170 | 1252 | CAMPO UNDIVIDED HIGH SCHOOL | Regular School | No | 4.0 | 06 | 12 | 2016 | grade_7 | 3 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 3 | 3 | 3 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 3 | 3 | ||||||||||||||||||||||||||||||||||
837769 | 837769 | CO | school | 805250 | 290 | LAS ANIMAS RE-1 | 80525000867 | 4986 | LAS ANIMAS JUNIOR HIGH SCHOOL | Regular School | No | 2.0 | 07 | 08 | 2016 | grade_7 | 40 | 0 | 8 | 0 | 0 | 0 | 0 | 20 | 28 | 48 | 40 | 0 | 8 | 0 | 0 | 0 | 0 | 20 | 28 | 48 | ||||||||||||||||||||||||||||||||||
837789 | 837789 | CO | school | 805580 | 310 | MC CLAVE RE-2 | 80558000963 | 5670 | MC CLAVE UNDIVIDED HIGH SCHOOL | Regular School | No | 3.0 | 07 | 12 | 2016 | grade_7 | 13 | 0 | 0 | 0 | 0 | 0 | 1 | 4 | 10 | 14 | 13 | 0 | 0 | 0 | 0 | 0 | 1 | 4 | 10 | 14 | ||||||||||||||||||||||||||||||||||
837834 | 837834 | CO | school | 470 | ST VRAIN VALLEY RE 1J | 226 | ALTONA MIDDLE SCHOOL | 2016 | grade_7 | 193 | 2 | 30 | 0 | 21 | 0 | 7 | 127 | 126 | 253 | 193 | 2 | 30 | 0 | 21 | 0 | 7 | 127 | 126 | 253 | |||||||||||||||||||||||||||||||||||||||||
837878 | 837878 | CO | school | 805370 | 470 | ST VRAIN VALLEY RE 1J | 80537001887 | 1284 | CARBON VALLEY ACADEMY | Regular School | Yes | 1.0 | PK | 08 | 2016 | grade_7 | 13 | 0 | 8 | 0 | 0 | 1 | 0 | 10 | 12 | 22 | 13 | 0 | 8 | 0 | 0 | 1 | 0 | 10 | 12 | 22 | ||||||||||||||||||||||||||||||||||
837920 | 837920 | CO | school | 805370 | 470 | ST VRAIN VALLEY RE 1J | 80537000900 | 2760 | ERIE MIDDLE SCHOOL | Regular School | No | 2.0 | 06 | 08 | 2016 | grade_7 | 258 | 2 | 37 | 0 | 11 | 0 | 6 | 164 | 150 | 314 | 258 | 2 | 37 | 0 | 11 | 0 | 6 | 164 | 150 | 314 | ||||||||||||||||||||||||||||||||||
837943 | 837943 | CO | school | 805370 | 470 | ST VRAIN VALLEY RE 1J | 80537001890 | 2964 | FLAGSTAFF CHARTER ACADEMY | Regular School | Yes | 1.0 | PK | 08 | 2016 | grade_7 | 72 | 0 | 7 | 0 | 7 | 1 | 1 | 41 | 47 | 88 | 72 | 0 | 7 | 0 | 7 | 1 | 1 | 41 | 47 | 88 | ||||||||||||||||||||||||||||||||||
837992 | 837992 | CO | school | 805370 | 470 | ST VRAIN VALLEY RE 1J | 80537006388 | 4333 | IMAGINE CHARTER | Regular School | Yes | 1.0 | PK | 08 | 2016 | grade_7 | 36 | 1 | 10 | 0 | 1 | 0 | 0 | 26 | 22 | 48 | 36 | 1 | 10 | 0 | 1 | 0 | 0 | 26 | 22 | 48 | ||||||||||||||||||||||||||||||||||
838027 | 838027 | CO | school | 805370 | 470 | ST VRAIN VALLEY RE 1J | 80537000910 | 5288 | LONGS PEAK MIDDLE SCHOOL | Regular School | No | 2.0 | 05 | 08 | 2016 | grade_7 | 44 | 3 | 74 | 0 | 0 | 0 | 3 | 61 | 63 | 124 | 44 | 3 | 74 | 0 | 0 | 0 | 3 | 61 | 63 | 124 | ||||||||||||||||||||||||||||||||||
838043 | 838043 | CO | school | 805370 | 470 | ST VRAIN VALLEY RE 1J | 80537000912 | 5368 | LYONS MIDDLE/SENIOR HIGH SCHOOL | Regular School | No | 4.0 | 06 | 12 | 2016 | grade_7 | 54 | 0 | 4 | 0 | 0 | 0 | 3 | 33 | 28 | 61 | 54 | 0 | 4 | 0 | 0 | 0 | 3 | 33 | 28 | 61 | ||||||||||||||||||||||||||||||||||
838071 | 838071 | CO | school | 805370 | 470 | ST VRAIN VALLEY RE 1J | 80537006594 | 6010 | TIMBERLINE PK-8 | Regular School | No | 1.0 | PK | 08 | 2016 | grade_7 | 18 | 2 | 97 | 0 | 0 | 0 | 1 | 53 | 65 | 118 | 18 | 2 | 97 | 0 | 0 | 0 | 1 | 53 | 65 | 118 | ||||||||||||||||||||||||||||||||||
838136 | 838136 | CO | school | 805370 | 470 | ST VRAIN VALLEY RE 1J | 80537006430 | 7565 | ST. VRAIN COMMUNITY MONTESSORI SCHOOL | Regular School | Yes | 1.0 | PK | 08 | 2016 | grade_7 | 5 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 5 | 5 | 5 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 5 | 5 | ||||||||||||||||||||||||||||||||||
838179 | 838179 | CO | school | 805370 | 470 | ST VRAIN VALLEY RE 1J | 80537001572 | 8927 | TWIN PEAKS CHARTER ACADEMY | Regular School | Yes | 4.0 | KG | 12 | 2016 | grade_7 | 38 | 1 | 28 | 0 | 12 | 0 | 2 | 51 | 30 | 81 | 38 | 1 | 28 | 0 | 12 | 0 | 2 | 51 | 30 | 81 | ||||||||||||||||||||||||||||||||||
838200 | 838200 | CO | school | 480 | BOULDER VALLEY RE 2 | 441 | ASPEN CREEK K-8 SCHOOL | 2016 | grade_7 | 107 | 2 | 16 | 0 | 5 | 0 | 11 | 72 | 69 | 141 | 107 | 2 | 16 | 0 | 5 | 0 | 11 | 72 | 69 | 141 | |||||||||||||||||||||||||||||||||||||||||
838218 | 838218 | CO | school | 480 | BOULDER VALLEY RE 2 | 866 | BOULDER EXPLORE | 2016 | grade_7 | 1 | 0 | 2 | 0 | 0 | 0 | 1 | 2 | 2 | 4 | 1 | 0 | 2 | 0 | 0 | 0 | 1 | 2 | 2 | 4 | |||||||||||||||||||||||||||||||||||||||||
838249 | 838249 | CO | school | 480 | BOULDER VALLEY RE 2 | 930 | BOULDER UNIVERSAL | 2016 | grade_7 | 3 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 2 | 3 | 3 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 2 | 3 | |||||||||||||||||||||||||||||||||||||||||
838272 | 838272 | CO | school | 802490 | 480 | BOULDER VALLEY RE 2 | 80249000106 | 1352 | CASEY MIDDLE SCHOOL | Regular School | No | 2.0 | 06 | 08 | 2016 | grade_7 | 122 | 3 | 78 | 0 | 3 | 0 | 6 | 94 | 118 | 212 | 122 | 3 | 78 | 0 | 3 | 0 | 6 | 94 | 118 | 212 | ||||||||||||||||||||||||||||||||||
838281 | 838281 | CO | school | 802490 | 480 | BOULDER VALLEY RE 2 | 80249000108 | 1390 | CENTENNIAL MIDDLE SCHOOL | Regular School | No | 2.0 | 06 | 08 | 2016 | grade_7 | 134 | 2 | 46 | 0 | 17 | 1 | 18 | 110 | 108 | 218 | 134 | 2 | 46 | 0 | 17 | 1 | 18 | 110 | 108 | 218 | ||||||||||||||||||||||||||||||||||
838337 | 838337 | CO | school | 802490 | 480 | BOULDER VALLEY RE 2 | 80249001771 | 2589 | ELDORADO K-8 SCHOOL | Regular School | No | 1.0 | KG | 08 | 2016 | grade_7 | 120 | 2 | 14 | 0 | 13 | 0 | 12 | 85 | 76 | 161 | 120 | 2 | 14 | 0 | 13 | 0 | 12 | 85 | 76 | 161 | ||||||||||||||||||||||||||||||||||
838389 | 838389 | CO | school | 802490 | 480 | BOULDER VALLEY RE 2 | 80249001467 | 3499 | HALCYON SCHOOL (SPECIAL EDUCATION) | Special Education School | No | 4.0 | 06 | 12 | 2016 | grade_7 | 2 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 1 | 2 | 2 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 1 | 2 | ||||||||||||||||||||||||||||||||||
838440 | 838440 | CO | school | 802490 | 480 | BOULDER VALLEY RE 2 | 80249000122 | 4878 | ANGEVINE MIDDLE SCHOOL | Regular School | No | 2.0 | 06 | 08 | 2016 | grade_7 | 145 | 2 | 92 | 0 | 11 | 0 | 3 | 144 | 109 | 253 | 145 | 2 | 92 | 0 | 11 | 0 | 3 | 144 | 109 | 253 | ||||||||||||||||||||||||||||||||||
838451 | 838451 | CO | school | 802490 | 480 | BOULDER VALLEY RE 2 | 80249000125 | 5306 | LOUISVILLE MIDDLE SCHOOL | Regular School | No | 2.0 | 06 | 08 | 2016 | grade_7 | 153 | 1 | 28 | 0 | 4 | 0 | 15 | 108 | 93 | 201 | 153 | 1 | 28 | 0 | 4 | 0 | 15 | 108 | 93 | 201 | ||||||||||||||||||||||||||||||||||
838482 | 838482 | CO | school | 802490 | 480 | BOULDER VALLEY RE 2 | 80249001573 | 6000 | MONARCH K-8 SCHOOL | Regular School | No | 1.0 | PK | 08 | 2016 | grade_7 | 119 | 3 | 11 | 0 | 12 | 1 | 9 | 84 | 71 | 155 | 119 | 3 | 11 | 0 | 12 | 1 | 9 | 84 | 71 | 155 | ||||||||||||||||||||||||||||||||||
838506 | 838506 | CO | school | 802490 | 480 | BOULDER VALLEY RE 2 | 80249000131 | 6212 | NEDERLAND MIDDLE-SENIOR HIGH SCHOOL | Regular School | No | 4.0 | 06 | 12 | 2016 | grade_7 | 44 | 0 | 2 | 0 | 0 | 0 | 3 | 22 | 27 | 49 | 44 | 0 | 2 | 0 | 0 | 0 | 3 | 22 | 27 | 49 | ||||||||||||||||||||||||||||||||||
838511 | 838511 | CO | school | 802490 | 480 | BOULDER VALLEY RE 2 | 80249000132 | 6224 | NEVIN PLATT MIDDLE SCHOOL | Regular School | No | 2.0 | 06 | 08 | 2016 | grade_7 | 159 | 0 | 19 | 0 | 8 | 1 | 8 | 113 | 82 | 195 | 159 | 0 | 19 | 0 | 8 | 1 | 8 | 113 | 82 | 195 | ||||||||||||||||||||||||||||||||||
838534 | 838534 | CO | school | 802490 | 480 | BOULDER VALLEY RE 2 | 80249001792 | 6816 | PEAK TO PEAK CHARTER SCHOOL | Regular School | Yes | 4.0 | KG | 12 | 2016 | grade_7 | 85 | 1 | 17 | 0 | 22 | 1 | 9 | 79 | 56 | 135 | 85 | 1 | 17 | 0 | 22 | 1 | 9 | 79 | 56 | 135 | ||||||||||||||||||||||||||||||||||
838565 | 838565 | CO | school | 802490 | 480 | BOULDER VALLEY RE 2 | 80249000134 | 8135 | SOUTHERN HILLS MIDDLE SCHOOL | Regular School | No | 2.0 | 06 | 08 | 2016 | grade_7 | 157 | 0 | 17 | 0 | 9 | 0 | 13 | 99 | 97 | 196 | 157 | 0 | 17 | 0 | 9 | 0 | 13 | 99 | 97 | 196 | ||||||||||||||||||||||||||||||||||
838569 | 838569 | CO | school | 802490 | 480 | BOULDER VALLEY RE 2 | 80249001517 | 8387 | SUMMIT MIDDLE CHARTER SCHOOL | Regular School | Yes | 2.0 | 06 | 08 | 2016 | grade_7 | 77 | 0 | 8 | 0 | 21 | 0 | 13 | 66 | 53 | 119 | 77 | 0 | 8 | 0 | 21 | 0 | 13 | 66 | 53 | 119 | ||||||||||||||||||||||||||||||||||
838600 | 838600 | CO | school | 802640 | 490 | BUENA VISTA R-31 | 80264000158 | 1132 | HARRY L MC GINNIS MIDDLE SCHOOL | Regular School | No | 2.0 | 06 | 08 | 2016 | grade_7 | 73 | 2 | 11 | 0 | 1 | 0 | 1 | 51 | 37 | 88 | 73 | 2 | 11 | 0 | 1 | 0 | 1 | 51 | 37 | 88 | ||||||||||||||||||||||||||||||||||
838618 | 838618 | CO | school | 806330 | 500 | SALIDA R-32 | 80633006500 | 1554 | CREST ACADEMY | Regular School | No | 2.0 | 05 | 08 | 2016 | grade_7 | 5 | 0 | 0 | 0 | 0 | 0 | 1 | 3 | 3 | 6 | 5 | 0 | 0 | 0 | 0 | 0 | 1 | 3 | 3 | 6 | ||||||||||||||||||||||||||||||||||
838655 | 838655 | CO | school | 805040 | 510 | KIT CARSON R-1 | 80504000826 | 4742 | KIT CARSON JUNIOR-SENIOR HIGH SCHOOL | Regular School | No | 4.0 | 06 | 12 | 2016 | grade_7 | 11 | 0 | 0 | 0 | 0 | 0 | 0 | 2 | 9 | 11 | 11 | 0 | 0 | 0 | 0 | 0 | 0 | 2 | 9 | 11 | ||||||||||||||||||||||||||||||||||
838671 | 838671 | CO | school | 800001 | 520 | CHEYENNE COUNTY RE-5 | 80000100215 | 1612 | CHEYENNE WELLS JUNIOR/HIGH SCHOOL | Regular School | No | 3.0 | 07 | 12 | 2016 | grade_7 | 2 | 0 | 2 | 0 | 0 | 0 | 0 | 3 | 1 | 4 | 2 | 0 | 2 | 0 | 0 | 0 | 0 | 3 | 1 | 4 | ||||||||||||||||||||||||||||||||||
838675 | 838675 | CO | school | 803000 | 540 | CLEAR CREEK RE-1 | 80300006157 | 1660 | CLEAR CREEK MIDDLE SCHOOL | Regular School | No | 2.0 | 07 | 08 | 2016 | grade_7 | 46 | 0 | 9 | 0 | 0 | 0 | 0 | 31 | 24 | 55 | 46 | 0 | 9 | 0 | 0 | 0 | 0 | 31 | 24 | 55 | ||||||||||||||||||||||||||||||||||
838711 | 838711 | CO | school | 805100 | 550 | NORTH CONEJOS RE-1J | 80510000842 | 1276 | CENTAURI MIDDLE SCHOOL | Regular School | No | 2.0 | 06 | 08 | 2016 | grade_7 | 30 | 0 | 39 | 0 | 0 | 0 | 0 | 32 | 37 | 69 | 30 | 0 | 39 | 0 | 0 | 0 | 0 | 32 | 37 | 69 | ||||||||||||||||||||||||||||||||||
838739 | 838739 | CO | school | 805100 | 550 | NORTH CONEJOS RE-1J | 80510006601 | 6339 | NORTH CONEJOS ALTERNATIVE PROGRAM | Alternative Education School | No | 4.0 | KG | 12 | 2016 | grade_7 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 1 | 1 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 1 | 1 | ||||||||||||||||||||||||||||||||||
838756 | 838756 | CO | school | 806390 | 560 | SANFORD 6J | 80639001114 | 7616 | SANFORD JUNIOR/SENIOR HIGH SCHOOL | Regular School | No | 3.0 | 07 | 12 | 2016 | grade_7 | 10 | 0 | 9 | 0 | 0 | 0 | 1 | 9 | 11 | 20 | 10 | 0 | 9 | 0 | 0 | 0 | 1 | 9 | 11 | 20 | ||||||||||||||||||||||||||||||||||
838785 | 838785 | CO | school | 806360 | 640 | CENTENNIAL R-1 | 80636001416 | 1398 | CENTENNIAL SCHOOL | Regular School | No | 4.0 | PK | 12 | 2016 | grade_7 | 5 | 0 | 17 | 0 | 0 | 0 | 0 | 10 | 12 | 22 | 5 | 0 | 17 | 0 | 0 | 0 | 0 | 10 | 12 | 22 | ||||||||||||||||||||||||||||||||||
838800 | 838800 | CO | school | 804140 | 740 | SIERRA GRANDE R-30 | 80414000572 | 7880 | SIERRA GRANDE K-12 SCHOOL | Regular School | No | 4.0 | KG | 12 | 2016 | grade_7 | 9 | 0 | 23 | 0 | 0 | 0 | 0 | 15 | 17 | 32 | 9 | 0 | 23 | 0 | 0 | 0 | 0 | 15 | 17 | 32 | ||||||||||||||||||||||||||||||||||
838817 | 838817 | CO | school | 803210 | 770 | CROWLEY COUNTY RE-1-J | 80321000282 | 2058 | CROWLEY COUNTY JUNIOR AND SENIOR HIGH SCHOOL | Regular School | No | 3.0 | 07 | 12 | 2016 | grade_7 | 16 | 0 | 15 | 0 | 0 | 0 | 0 | 15 | 16 | 31 | 16 | 0 | 15 | 0 | 0 | 0 | 0 | 15 | 16 | 31 | ||||||||||||||||||||||||||||||||||
838830 | 838830 | CO | school | 807200 | 860 | CUSTER COUNTY SCHOOL DISTRICT C-1 | 80720001732 | 2091 | CUSTER MIDDLE SCHOOL | Regular School | No | 2.0 | 06 | 08 | 2016 | grade_7 | 22 | 1 | 0 | 0 | 0 | 0 | 2 | 13 | 12 | 25 | 22 | 1 | 0 | 0 | 0 | 0 | 2 | 13 | 12 | 25 | ||||||||||||||||||||||||||||||||||
838859 | 838859 | CO | school | 803330 | 870 | DELTA COUNTY 50(J) | 80333002001 | 2152 | DELTA ACADEMY OF APPLIED LEARNING | Alternative Education School | No | 2.0 | 05 | 08 | 2016 | grade_7 | 7 | 0 | 1 | 0 | 0 | 0 | 0 | 7 | 1 | 8 | 7 | 0 | 1 | 0 | 0 | 0 | 0 | 7 | 1 | 8 | ||||||||||||||||||||||||||||||||||
838886 | 838886 | CO | school | 803330 | 870 | DELTA COUNTY 50(J) | 80333002024 | 2166 | DELTA VISION SCHOOL | Alternative Education School | Yes | 4.0 | KG | 12 | 2016 | grade_7 | 33 | 0 | 1 | 0 | 0 | 0 | 0 | 15 | 19 | 34 | 33 | 0 | 1 | 0 | 0 | 0 | 0 | 15 | 19 | 34 | ||||||||||||||||||||||||||||||||||
838905 | 838905 | CO | school | 803330 | 870 | DELTA COUNTY 50(J) | 80333000299 | 4124 | HOTCHKISS ELEMENTARY SCHOOL | Regular School | No | 1.0 | PK | 08 | 2016 | grade_7 | 56 | 1 | 7 | 0 | 0 | 0 | 0 | 35 | 29 | 64 | 56 | 1 | 7 | 0 | 0 | 0 | 0 | 35 | 29 | 64 | ||||||||||||||||||||||||||||||||||
838947 | 838947 | CO | school | 803330 | 870 | DELTA COUNTY 50(J) | 80333000304 | 6708 | PAONIA HIGH SCHOOL | Regular School | No | 3.0 | 07 | 12 | 2016 | grade_7 | 24 | 1 | 6 | 0 | 1 | 0 | 0 | 16 | 16 | 32 | 24 | 1 | 6 | 0 | 1 | 0 | 0 | 16 | 16 | 32 | ||||||||||||||||||||||||||||||||||
839060 | 839060 | CO | school | 803360 | 880 | DENVER COUNTY 1 | 80336000320 | 1106 | BRYANT WEBSTER DUAL LANGUAGE ECE-8 SCHOOL | Regular School | No | 1.0 | PK | 08 | 2016 | grade_7 | 1 | 0 | 38 | 0 | 0 | 0 | 0 | 21 | 18 | 39 | 1 | 0 | 38 | 0 | 0 | 0 | 0 | 21 | 18 | 39 | ||||||||||||||||||||||||||||||||||
839089 | 839089 | CO | school | 803360 | 880 | DENVER COUNTY 1 | 80336006449 | 1345 | CESAR CHAVEZ ACADEMY DENVER | Regular School | Yes | 1.0 | KG | 08 | 2016 | grade_7 | 1 | 0 | 38 | 0 | 0 | 0 | 1 | 24 | 16 | 40 | 1 | 0 | 38 | 0 | 0 | 0 | 1 | 24 | 16 | 40 | ||||||||||||||||||||||||||||||||||
839208 | 839208 | CO | school | 803360 | 880 | DENVER COUNTY 1 | 80336006482 | 2127 | DENVER LANGUAGE SCHOOL | Regular School | Yes | 1.0 | KG | 07 | 2016 | grade_7 | 11 | 4 | 5 | 0 | 2 | 0 | 0 | 6 | 16 | 22 | 11 | 4 | 5 | 0 | 2 | 0 | 0 | 6 | 16 | 22 | ||||||||||||||||||||||||||||||||||
839224 | 839224 | CO | school | 803360 | 880 | DENVER COUNTY 1 | 80336006568 | 2167 | DENVER PUBLIC MONTESSORI JUNIOR/SENIOR HIGH SCHOOL | Regular School | No | 2.0 | 07 | 09 | 2016 | grade_7 | 12 | 0 | 26 | 0 | 1 | 0 | 1 | 15 | 25 | 40 | 12 | 0 | 26 | 0 | 1 | 0 | 1 | 15 | 25 | 40 | ||||||||||||||||||||||||||||||||||
839241 | 839241 | CO | school | 803360 | 880 | DENVER COUNTY 1 | 80336006546 | 2181 | DSST: GREEN VALLEY RANCH MIDDLE SCHOOL | Regular School | Yes | 2.0 | 06 | 08 | 2016 | grade_7 | 14 | 41 | 83 | 0 | 13 | 2 | 8 | 85 | 76 | 161 | 14 | 41 | 83 | 0 | 13 | 2 | 8 | 85 | 76 | 161 | ||||||||||||||||||||||||||||||||||
839273 | 839273 | CO | school | 803360 | 880 | DENVER COUNTY 1 | 80336006516 | 2188 | DENVER CENTER FOR 21ST LEARNING AT WYMAN | Alternative Education School | No | 4.0 | 06 | 12 | 2016 | grade_7 | 0 | 4 | 7 | 0 | 0 | 0 | 0 | 9 | 2 | 11 | 0 | 4 | 7 | 0 | 0 | 0 | 0 | 9 | 2 | 11 | ||||||||||||||||||||||||||||||||||
839300 | 839300 | CO | school | 803360 | 880 | DENVER COUNTY 1 | 80336006618 | 2218 | DSST: CONSERVATORY GREEN MIDDLE SCHOOL | Regular School | Yes | 2.0 | 06 | 07 | 2016 | grade_7 | 30 | 49 | 54 | 0 | 6 | 0 | 9 | 85 | 63 | 148 | 30 | 49 | 54 | 0 | 6 | 0 | 9 | 85 | 63 | 148 | ||||||||||||||||||||||||||||||||||
839303 | 839303 | CO | school | 803360 | 880 | DENVER COUNTY 1 | 80336006523 | 2223 | DSST: COLE MIDDLE SCHOOL | Regular School | Yes | 2.0 | 06 | 08 | 2016 | grade_7 | 14 | 22 | 111 | 0 | 1 | 0 | 2 | 74 | 76 | 150 | 14 | 22 | 111 | 0 | 1 | 0 | 2 | 74 | 76 | 150 | ||||||||||||||||||||||||||||||||||
839307 | 839307 | CO | school | 803360 | 880 | DENVER COUNTY 1 | 80336006624 | 2227 | DENVER DISCOVERY SCHOOL | Regular School | No | 2.0 | 06 | 07 | 2016 | grade_7 | 66 | 22 | 15 | 0 | 2 | 0 | 5 | 50 | 60 | 110 | 66 | 22 | 15 | 0 | 2 | 0 | 5 | 50 | 60 | 110 | ||||||||||||||||||||||||||||||||||
839384 | 839384 | CO | school | 803360 | 880 | DENVER COUNTY 1 | 80336001834 | 2789 | ESCUELA TLATELOLCO SCHOOL | Regular School | No | 4.0 | KG | 12 | 2016 | grade_7 | 0 | 0 | 11 | 0 | 0 | 0 | 0 | 5 | 6 | 11 | 0 | 0 | 11 | 0 | 0 | 0 | 0 | 5 | 6 | 11 |
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]);