enrollments
Data source: Big Local News · About: Big Local
586 rows where grade = "grade_7", state = "CO" and year = 2016 sorted by district
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
842104 | 842104 | CO | school | 1040 | ACADEMY 20 | 74 | CHALLENGER MIDDLE SCHOOL | 2016 | grade_7 | 212 | 7 | 29 | 4 | 14 | 1 | 19 | 144 | 142 | 286 | 212 | 7 | 29 | 4 | 14 | 1 | 19 | 144 | 142 | 286 | |||||||||||||||||||||||||||||||||||||||||
842120 | 842120 | CO | school | 1040 | ACADEMY 20 | 209 | ASPEN VALLEY CAMPUS | 2016 | grade_7 | 12 | 1 | 5 | 0 | 0 | 0 | 0 | 12 | 6 | 18 | 12 | 1 | 5 | 0 | 0 | 0 | 0 | 12 | 6 | 18 | |||||||||||||||||||||||||||||||||||||||||
842151 | 842151 | CO | school | 801920 | 1040 | ACADEMY 20 | 80192001931 | 1629 | THE CLASSICAL ACADEMY MIDDLE SCHOOL | Regular School | Yes | 2.0 | 07 | 08 | 2016 | grade_7 | 189 | 4 | 22 | 0 | 8 | 1 | 13 | 117 | 120 | 237 | 189 | 4 | 22 | 0 | 8 | 1 | 13 | 117 | 120 | 237 | ||||||||||||||||||||||||||||||||||
842165 | 842165 | CO | school | 801920 | 1040 | ACADEMY 20 | 80192006478 | 1901 | ACADEMY CALVERT K-8 ONLINE SCHOOL | Regular School | No | 1.0 | KG | 08 | 2016 | grade_7 | 10 | 0 | 4 | 0 | 0 | 0 | 1 | 9 | 6 | 15 | 10 | 0 | 4 | 0 | 0 | 0 | 1 | 9 | 6 | 15 | ||||||||||||||||||||||||||||||||||
842170 | 842170 | CO | school | 801920 | 1040 | ACADEMY 20 | 80192006616 | 1921 | DISCOVERY CANYON CAMPUS MIDDLE SCHOOL | Regular School | No | 2.0 | 06 | 08 | 2016 | grade_7 | 234 | 13 | 35 | 2 | 15 | 1 | 21 | 179 | 142 | 321 | 234 | 13 | 35 | 2 | 15 | 1 | 21 | 179 | 142 | 321 | ||||||||||||||||||||||||||||||||||
842196 | 842196 | CO | school | 801920 | 1040 | ACADEMY 20 | 80192001402 | 2358 | EAGLEVIEW MIDDLE SCHOOL | Regular School | No | 2.0 | 06 | 08 | 2016 | grade_7 | 239 | 8 | 44 | 3 | 7 | 0 | 25 | 157 | 169 | 326 | 239 | 8 | 44 | 3 | 7 | 0 | 25 | 157 | 169 | 326 | ||||||||||||||||||||||||||||||||||
842249 | 842249 | CO | school | 801920 | 1040 | ACADEMY 20 | 80192001593 | 6140 | MOUNTAIN RIDGE MIDDLE SCHOOL | Regular School | No | 2.0 | 06 | 08 | 2016 | grade_7 | 252 | 21 | 66 | 1 | 24 | 0 | 32 | 201 | 195 | 396 | 252 | 21 | 66 | 1 | 24 | 0 | 32 | 201 | 195 | 396 | ||||||||||||||||||||||||||||||||||
842306 | 842306 | CO | school | 801920 | 1040 | ACADEMY 20 | 80192006447 | 8779 | TCA COLLEGE PATHWAYS | Regular School | Yes | 3.0 | 07 | 12 | 2016 | grade_7 | 46 | 1 | 3 | 1 | 3 | 0 | 1 | 29 | 26 | 55 | 46 | 1 | 3 | 1 | 3 | 0 | 1 | 29 | 26 | 55 | ||||||||||||||||||||||||||||||||||
842320 | 842320 | CO | school | 801920 | 1040 | ACADEMY 20 | 80192001462 | 8851 | TIMBERVIEW MIDDLE SCHOOL | Regular School | No | 2.0 | 06 | 08 | 2016 | grade_7 | 277 | 14 | 69 | 2 | 8 | 0 | 18 | 208 | 180 | 388 | 277 | 14 | 69 | 2 | 8 | 0 | 18 | 208 | 180 | 388 | ||||||||||||||||||||||||||||||||||
835640 | 835640 | CO | school | 20 | ADAMS 12 FIVE STAR SCHOOLS | 57 | ROCKY TOP MIDDLE SCHOOL | 2016 | grade_7 | 310 | 3 | 75 | 2 | 30 | 0 | 11 | 226 | 205 | 431 | 310 | 3 | 75 | 2 | 30 | 0 | 11 | 226 | 205 | 431 | |||||||||||||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||||||||||||
835679 | 835679 | CO | school | 806900 | 20 | ADAMS 12 FIVE STAR SCHOOLS | 80690001620 | 1480 | CENTURY MIDDLE SCHOOL | Regular School | No | 2.0 | 06 | 08 | 2016 | grade_7 | 225 | 14 | 93 | 2 | 13 | 0 | 4 | 173 | 178 | 351 | 225 | 14 | 93 | 2 | 13 | 0 | 4 | 173 | 178 | 351 | ||||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||
835784 | 835784 | CO | school | 806900 | 20 | ADAMS 12 FIVE STAR SCHOOLS | 80690006503 | 3439 | GLOBAL VILLAGE ACADEMY | Regular School | Yes | 1.0 | KG | 08 | 2016 | grade_7 | 14 | 1 | 23 | 1 | 4 | 0 | 0 | 20 | 23 | 43 | 14 | 1 | 23 | 1 | 4 | 0 | 0 | 20 | 23 | 43 | ||||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||
835812 | 835812 | CO | school | 806900 | 20 | ADAMS 12 FIVE STAR SCHOOLS | 80690001179 | 4187 | SILVER HILLS MIDDLE SCHOOL | Regular School | No | 2.0 | 06 | 08 | 2016 | grade_7 | 166 | 9 | 166 | 4 | 24 | 0 | 5 | 199 | 175 | 374 | 166 | 9 | 166 | 4 | 24 | 0 | 5 | 199 | 175 | 374 | ||||||||||||||||||||||||||||||||||
835842 | 835842 | CO | school | 806900 | 20 | ADAMS 12 FIVE STAR SCHOOLS | 80690001183 | 5814 | THE INTERNATIONAL SCHOOL AT THORNTON MIDDLE | Regular School | No | 2.0 | 06 | 08 | 2016 | grade_7 | 34 | 16 | 254 | 2 | 4 | 0 | 5 | 176 | 139 | 315 | 34 | 16 | 254 | 2 | 4 | 0 | 5 | 176 | 139 | 315 | ||||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||
835882 | 835882 | CO | school | 806900 | 20 | ADAMS 12 FIVE STAR SCHOOLS | 80690001187 | 6398 | NORTHGLENN MIDDLE SCHOOL | Regular School | No | 2.0 | 06 | 08 | 2016 | grade_7 | 86 | 14 | 162 | 4 | 13 | 0 | 3 | 151 | 131 | 282 | 86 | 14 | 162 | 4 | 13 | 0 | 3 | 151 | 131 | 282 | ||||||||||||||||||||||||||||||||||
835897 | 835897 | CO | school | 806900 | 20 | ADAMS 12 FIVE STAR SCHOOLS | 80690006507 | 6802 | PROSPECT RIDGE ACADEMY | Regular School | Yes | 4.0 | KG | 10 | 2016 | grade_7 | 87 | 2 | 4 | 1 | 13 | 0 | 5 | 55 | 57 | 112 | 87 | 2 | 4 | 1 | 13 | 0 | 5 | 55 | 57 | 112 | ||||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||
835992 | 835992 | CO | school | 806900 | 20 | ADAMS 12 FIVE STAR SCHOOLS | 80690001194 | 9444 | WESTLAKE MIDDLE SCHOOL | Regular School | No | 2.0 | 06 | 08 | 2016 | grade_7 | 260 | 1 | 82 | 1 | 21 | 0 | 8 | 190 | 183 | 373 | 260 | 1 | 82 | 1 | 21 | 0 | 8 | 190 | 183 | 373 | ||||||||||||||||||||||||||||||||||
836010 | 836010 | CO | school | 30 | ADAMS COUNTY 14 | 20 | ADAMS CITY MIDDLE SCHOOL | 2016 | grade_7 | 38 | 6 | 212 | 3 | 1 | 0 | 3 | 149 | 114 | 263 | 38 | 6 | 212 | 3 | 1 | 0 | 3 | 149 | 114 | 263 | |||||||||||||||||||||||||||||||||||||||||
836048 | 836048 | CO | school | 801950 | 30 | ADAMS COUNTY 14 | 80195000015 | 4516 | KEARNEY MIDDLE SCHOOL | Regular School | No | 2.0 | 06 | 08 | 2016 | grade_7 | 29 | 9 | 239 | 1 | 0 | 0 | 1 | 151 | 128 | 279 | 29 | 9 | 239 | 1 | 0 | 0 | 1 | 151 | 128 | 279 | ||||||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||||||||||||
837148 | 837148 | CO | school | 180 | ADAMS-ARAPAHOE 28J | 213 | AXL ACADEMY | 2016 | grade_7 | 5 | 16 | 17 | 1 | 1 | 0 | 1 | 19 | 22 | 41 | 5 | 16 | 17 | 1 | 1 | 0 | 1 | 19 | 22 | 41 | |||||||||||||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||||||||||||
837228 | 837228 | CO | school | 802340 | 180 | ADAMS-ARAPAHOE 28J | 80234000057 | 1720 | CLYDE MILLER K-8 | Regular School | No | 1.0 | PK | 08 | 2016 | grade_7 | 11 | 13 | 39 | 1 | 0 | 0 | 6 | 36 | 34 | 70 | 11 | 13 | 39 | 1 | 0 | 0 | 6 | 36 | 34 | 70 | ||||||||||||||||||||||||||||||||||
837234 | 837234 | CO | school | 802340 | 180 | ADAMS-ARAPAHOE 28J | 80234001322 | 1800 | COLUMBIA MIDDLE SCHOOL | Regular School | No | 2.0 | 06 | 08 | 2016 | grade_7 | 85 | 40 | 126 | 2 | 15 | 0 | 6 | 145 | 129 | 274 | 85 | 40 | 126 | 2 | 15 | 0 | 6 | 145 | 129 | 274 | ||||||||||||||||||||||||||||||||||
837262 | 837262 | CO | school | 802340 | 180 | ADAMS-ARAPAHOE 28J | 80234000060 | 2384 | EAST MIDDLE SCHOOL | Regular School | No | 2.0 | 06 | 08 | 2016 | grade_7 | 25 | 57 | 257 | 4 | 14 | 2 | 11 | 192 | 178 | 370 | 25 | 57 | 257 | 4 | 14 | 2 | 11 | 192 | 178 | 370 | ||||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||
837311 | 837311 | CO | school | 802340 | 180 | ADAMS-ARAPAHOE 28J | 80234006318 | 3471 | GLOBAL VILLAGE ACADEMY AURORA | Regular School | Yes | 1.0 | KG | 08 | 2016 | grade_7 | 14 | 21 | 53 | 1 | 2 | 0 | 5 | 47 | 49 | 96 | 14 | 21 | 53 | 1 | 2 | 0 | 5 | 47 | 49 | 96 | ||||||||||||||||||||||||||||||||||
837370 | 837370 | CO | school | 802340 | 180 | ADAMS-ARAPAHOE 28J | 80234001916 | 5298 | LOTUS SCHOOL FOR EXCELLENCE | Regular School | Yes | 4.0 | KG | 12 | 2016 | grade_7 | 12 | 29 | 32 | 1 | 3 | 0 | 0 | 39 | 38 | 77 | 12 | 29 | 32 | 1 | 3 | 0 | 0 | 39 | 38 | 77 | ||||||||||||||||||||||||||||||||||
837394 | 837394 | CO | school | 802340 | 180 | ADAMS-ARAPAHOE 28J | 80234000073 | 6160 | MRACHEK MIDDLE SCHOOL | Regular School | No | 2.0 | 06 | 08 | 2016 | grade_7 | 66 | 75 | 127 | 3 | 12 | 7 | 12 | 170 | 132 | 302 | 66 | 75 | 127 | 3 | 12 | 7 | 12 | 170 | 132 | 302 | ||||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||
837409 | 837409 | CO | school | 802340 | 180 | ADAMS-ARAPAHOE 28J | 80234000074 | 6310 | NORTH MIDDLE SCHOOL HEALTH SCIENCES AND TECHNOLOGY CAMPUS | Regular School | No | 2.0 | 06 | 08 | 2016 | grade_7 | 19 | 37 | 212 | 4 | 6 | 2 | 9 | 130 | 159 | 289 | 19 | 37 | 212 | 4 | 6 | 2 | 9 | 130 | 159 | 289 | ||||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||
837490 | 837490 | CO | school | 802340 | 180 | ADAMS-ARAPAHOE 28J | 80234000079 | 8078 | SOUTH MIDDLE SCHOOL | Regular School | No | 2.0 | 06 | 08 | 2016 | grade_7 | 20 | 54 | 162 | 2 | 4 | 0 | 5 | 127 | 120 | 247 | 20 | 54 | 162 | 2 | 4 | 0 | 5 | 127 | 120 | 247 | ||||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||
837537 | 837537 | CO | school | 802340 | 180 | ADAMS-ARAPAHOE 28J | 80234006483 | 9083 | VISTA PEAK P-8 EXPLORATORY | Regular School | No | 1.0 | PK | 08 | 2016 | grade_7 | 38 | 5 | 46 | 1 | 2 | 1 | 7 | 50 | 50 | 100 | 38 | 5 | 46 | 1 | 2 | 1 | 7 | 50 | 50 | 100 | ||||||||||||||||||||||||||||||||||
837563 | 837563 | CO | school | 802340 | 180 | ADAMS-ARAPAHOE 28J | 80234006611 | 9189 | VANGUARD CLASSICAL SCHOOL - EAST | Regular School | Yes | 4.0 | KG | 11 | 2016 | grade_7 | 23 | 23 | 24 | 1 | 0 | 0 | 2 | 32 | 41 | 73 | 23 | 23 | 24 | 1 | 0 | 0 | 2 | 32 | 41 | 73 | ||||||||||||||||||||||||||||||||||
837572 | 837572 | CO | school | 802340 | 180 | ADAMS-ARAPAHOE 28J | 80234000082 | 9396 | AURORA WEST COLLEGE PREPARATORY ACADEMY | Regular School | No | 4.0 | 06 | 12 | 2016 | grade_7 | 17 | 26 | 211 | 1 | 38 | 0 | 4 | 140 | 157 | 297 | 17 | 26 | 211 | 1 | 38 | 0 | 4 | 140 | 157 | 297 | ||||||||||||||||||||||||||||||||||
845388 | 845388 | CO | school | 1620 | AGUILAR REORGANIZED 6 | 66 | AGUILAR JUNIOR-SENIOR HIGH SCHOOL | 2016 | grade_7 | 1 | 0 | 9 | 0 | 0 | 0 | 0 | 5 | 5 | 10 | 1 | 0 | 9 | 0 | 0 | 0 | 0 | 5 | 5 | 10 | |||||||||||||||||||||||||||||||||||||||||
847484 | 847484 | CO | school | 3030 | AKRON R-1 | 86 | AKRON ELEMENTARY SCHOOL | 2016 | grade_7 | 20 | 0 | 5 | 0 | 0 | 0 | 1 | 15 | 11 | 26 | 20 | 0 | 5 | 0 | 0 | 0 | 1 | 15 | 11 | 26 | |||||||||||||||||||||||||||||||||||||||||
836424 | 836424 | CO | school | 100 | ALAMOSA RE-11J | 114 | ORTEGA MIDDLE SCHOOL | 2016 | grade_7 | 44 | 2 | 106 | 5 | 2 | 0 | 0 | 76 | 83 | 159 | 44 | 2 | 106 | 5 | 2 | 0 | 0 | 76 | 83 | 159 | |||||||||||||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||||||||||||
837662 | 837662 | CO | school | 802190 | 220 | ARCHULETA COUNTY 50 JT | 80219000040 | 6657 | PAGOSA SPRINGS MIDDLE SCHOOL | Regular School | No | 2.0 | 05 | 08 | 2016 | grade_7 | 92 | 1 | 7 | 11 | 2 | 0 | 4 | 51 | 66 | 117 | 92 | 1 | 7 | 11 | 2 | 0 | 4 | 51 | 66 | 117 | ||||||||||||||||||||||||||||||||||
847506 | 847506 | CO | school | 3040 | ARICKAREE R-2 | 308 | ARICKAREE UNDIVIDED HIGH SCHOOL | 2016 | grade_7 | 2 | 0 | 1 | 0 | 0 | 0 | 0 | 2 | 1 | 3 | 2 | 0 | 1 | 0 | 0 | 0 | 0 | 2 | 1 | 3 | |||||||||||||||||||||||||||||||||||||||||
844441 | 844441 | CO | school | 802260 | 1450 | ARRIBA-FLAGLER C-20 | 80226000509 | 2960 | FLAGLER PUBLIC SCHOOL | Regular School | No | 4.0 | PK | 12 | 2016 | grade_7 | 20 | 0 | 1 | 0 | 0 | 0 | 0 | 7 | 14 | 21 | 20 | 0 | 1 | 0 | 0 | 0 | 0 | 7 | 14 | 21 | ||||||||||||||||||||||||||||||||||
846538 | 846538 | CO | school | 2640 | ASPEN 1 | 42 | ASPEN COMMUNITY CHARTER SCHOOL | 2016 | grade_7 | 15 | 0 | 0 | 0 | 0 | 0 | 0 | 8 | 7 | 15 | 15 | 0 | 0 | 0 | 0 | 0 | 0 | 8 | 7 | 15 | |||||||||||||||||||||||||||||||||||||||||
846550 | 846550 | CO | school | 2640 | ASPEN 1 | 430 | ASPEN MIDDLE SCHOOL | 2016 | grade_7 | 100 | 0 | 8 | 0 | 1 | 0 | 0 | 57 | 52 | 109 | 100 | 0 | 8 | 0 | 1 | 0 | 0 | 57 | 52 | 109 | |||||||||||||||||||||||||||||||||||||||||
848066 | 848066 | CO | school | 802310 | 3145 | AULT-HIGHLAND RE-9 | 80231001466 | 3961 | HIGHLAND MIDDLE SCHOOL | Regular School | No | 2.0 | 06 | 08 | 2016 | grade_7 | 48 | 0 | 25 | 0 | 0 | 0 | 1 | 41 | 33 | 74 | 48 | 0 | 25 | 0 | 0 | 0 | 1 | 41 | 33 | 74 | ||||||||||||||||||||||||||||||||||
844625 | 844625 | CO | school | 1530 | BAYFIELD 10 JT-R | 636 | BAYFIELD MIDDLE SCHOOL | 2016 | grade_7 | 109 | 0 | 14 | 3 | 1 | 0 | 2 | 61 | 68 | 129 | 109 | 0 | 14 | 3 | 1 | 0 | 2 | 61 | 68 | 129 | |||||||||||||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||||||||||||
844488 | 844488 | CO | school | 1490 | BETHUNE R-5 | 842 | BETHUNE PUBLIC SCHOOLS | 2016 | grade_7 | 6 | 0 | 2 | 0 | 0 | 0 | 0 | 3 | 5 | 8 | 6 | 0 | 2 | 0 | 0 | 0 | 0 | 3 | 5 | 8 | |||||||||||||||||||||||||||||||||||||||||
841234 | 841234 | CO | school | 806600 | 940 | BIG SANDY 100J | 80660001140 | 7918 | SIMLA JUNIOR HIGH SCHOOL | Regular School | No | 2.0 | 06 | 08 | 2016 | grade_7 | 16 | 0 | 2 | 1 | 0 | 0 | 1 | 12 | 8 | 20 | 16 | 0 | 2 | 1 | 0 | 0 | 1 | 12 | 8 | 20 | ||||||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||||||||||||
838259 | 838259 | CO | school | 802490 | 480 | BOULDER VALLEY RE 2 | 80249000102 | 1066 | BROOMFIELD HEIGHTS MIDDLE SCHOOL | Regular School | No | 2.0 | 06 | 08 | 2016 | grade_7 | 119 | 1 | 36 | 2 | 9 | 0 | 8 | 89 | 86 | 175 | 119 | 1 | 36 | 2 | 9 | 0 | 8 | 89 | 86 | 175 | ||||||||||||||||||||||||||||||||||
838268 | 838268 | CO | school | 802490 | 480 | BOULDER VALLEY RE 2 | 80249000104 | 1136 | MANHATTAN MIDDLE SCHOOL OF THE ARTS AND ACADEMICS | Regular School | No | 2.0 | 06 | 08 | 2016 | grade_7 | 104 | 4 | 33 | 2 | 5 | 0 | 10 | 81 | 77 | 158 | 104 | 4 | 33 | 2 | 5 | 0 | 10 | 81 | 77 | 158 | ||||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||
838520 | 838520 | CO | school | 802490 | 480 | BOULDER VALLEY RE 2 | 80249006199 | 6642 | HORIZONS K-8 SCHOOL | Alternative Education School | Yes | 1.0 | KG | 08 | 2016 | grade_7 | 35 | 1 | 2 | 1 | 3 | 0 | 0 | 20 | 22 | 42 | 35 | 1 | 2 | 1 | 3 | 0 | 0 | 20 | 22 | 42 | ||||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||
845401 | 845401 | CO | school | 1750 | BRANSON REORGANIZED 82 | 948 | BRANSON SCHOOL ONLINE | 2016 | grade_7 | 32 | 0 | 4 | 0 | 0 | 0 | 0 | 22 | 14 | 36 | 32 | 0 | 4 | 0 | 0 | 0 | 0 | 22 | 14 | 36 | |||||||||||||||||||||||||||||||||||||||||
845415 | 845415 | CO | school | 1750 | BRANSON REORGANIZED 82 | 978 | BRANSON SCHOOL | 2016 | grade_7 | 4 | 1 | 3 | 0 | 0 | 0 | 0 | 3 | 5 | 8 | 4 | 1 | 3 | 0 | 0 | 0 | 0 | 3 | 5 | 8 | |||||||||||||||||||||||||||||||||||||||||
848086 | 848086 | CO | school | 802550 | 3146 | BRIGGSDALE RE-10 | 80255000143 | 1012 | BRIGGSDALE UNDIVIDED HIGH SCHOOL | Regular School | No | 4.0 | 06 | 12 | 2016 | grade_7 | 7 | 0 | 2 | 0 | 1 | 0 | 0 | 5 | 5 | 10 | 7 | 0 | 2 | 0 | 1 | 0 | 0 | 5 | 5 | 10 | ||||||||||||||||||||||||||||||||||
846225 | 846225 | CO | school | 802610 | 2395 | BRUSH RE-2(J) | 80261000153 | 1094 | BRUSH MIDDLE SCHOOL | Regular School | No | 2.0 | 07 | 08 | 2016 | grade_7 | 45 | 0 | 48 | 0 | 0 | 0 | 1 | 38 | 56 | 94 | 45 | 0 | 48 | 0 | 0 | 0 | 1 | 38 | 56 | 94 | ||||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||
845545 | 845545 | CO | school | 805640 | 1860 | BUFFALO RE-4J | 80564000970 | 5806 | MERINO JUNIOR SENIOR HIGH SCHOOL | Regular School | No | 3.0 | 07 | 12 | 2016 | grade_7 | 25 | 0 | 0 | 1 | 0 | 0 | 0 | 14 | 12 | 26 | 25 | 0 | 0 | 1 | 0 | 0 | 0 | 14 | 12 | 26 | ||||||||||||||||||||||||||||||||||
844503 | 844503 | CO | school | 802670 | 1500 | BURLINGTON RE-6J | 80267000161 | 1150 | BURLINGTON MIDDLE SCHOOL | Regular School | No | 2.0 | 05 | 08 | 2016 | grade_7 | 24 | 1 | 17 | 0 | 0 | 0 | 0 | 24 | 18 | 42 | 24 | 1 | 17 | 0 | 0 | 0 | 0 | 24 | 18 | 42 | ||||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||
837622 | 837622 | CO | school | 802700 | 190 | BYERS 32J | 80270006605 | 2356 | ELEVATE ACADEMY | Regular School | Yes | 4.0 | KG | 12 | 2016 | grade_7 | 34 | 6 | 73 | 2 | 0 | 1 | 0 | 64 | 52 | 116 | 34 | 6 | 73 | 2 | 0 | 1 | 0 | 64 | 52 | 116 | ||||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||
837650 | 837650 | CO | school | 802700 | 190 | BYERS 32J | 80270006620 | 6263 | COLORADO DIGITAL ACADEMY - MIDDLE | Regular School | Yes | 2.0 | 07 | 08 | 2016 | grade_7 | 95 | 7 | 14 | 4 | 5 | 0 | 0 | 62 | 63 | 125 | 95 | 7 | 14 | 4 | 5 | 0 | 0 | 62 | 63 | 125 | ||||||||||||||||||||||||||||||||||
841270 | 841270 | CO | school | 802730 | 970 | CALHAN RJ-1 | 80273000510 | 1215 | CALHAN MIDDLE SCHOOL | Regular School | No | 2.0 | 06 | 08 | 2016 | grade_7 | 38 | 5 | 2 | 0 | 0 | 0 | 1 | 22 | 24 | 46 | 38 | 5 | 2 | 0 | 0 | 0 | 1 | 22 | 24 | 46 | ||||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||
842676 | 842676 | CO | school | 802790 | 1140 | CANON CITY RE-1 | 80279000171 | 1262 | CANON CITY MIDDLE SCHOOL | Regular School | No | 2.0 | 06 | 08 | 2016 | grade_7 | 100 | 1 | 22 | 3 | 0 | 0 | 4 | 63 | 67 | 130 | 100 | 1 | 22 | 3 | 0 | 0 | 4 | 63 | 67 | 130 | ||||||||||||||||||||||||||||||||||
842690 | 842690 | CO | school | 802790 | 1140 | CANON CITY RE-1 | 80279000173 | 3802 | HARRISON SCHOOL | Regular School | No | 1.0 | KG | 08 | 2016 | grade_7 | 99 | 0 | 23 | 1 | 2 | 1 | 2 | 76 | 52 | 128 | 99 | 0 | 23 | 1 | 2 | 1 | 2 | 76 | 52 | 128 | ||||||||||||||||||||||||||||||||||
842714 | 842714 | CO | school | 802790 | 1140 | CANON CITY RE-1 | 80279001538 | 6752 | MOUNT VIEW CORE KNOWLEDGE CHARTER SCHOOL | Regular School | Yes | 1.0 | PK | 08 | 2016 | grade_7 | 24 | 1 | 4 | 0 | 0 | 0 | 0 | 13 | 16 | 29 | 24 | 1 | 4 | 0 | 0 | 0 | 0 | 13 | 16 | 29 | ||||||||||||||||||||||||||||||||||
842724 | 842724 | CO | school | 802790 | 1140 | CANON CITY RE-1 | 80279001433 | 7950 | CANON EXPLORATORY SCHOOL | Regular School | No | 1.0 | KG | 08 | 2016 | grade_7 | 20 | 0 | 0 | 0 | 0 | 0 | 2 | 11 | 11 | 22 | 20 | 0 | 0 | 0 | 0 | 0 | 2 | 11 | 11 | 22 | ||||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||
847272 | 847272 | CO | school | 802850 | 2810 | CENTER 26 JT | 80285000178 | 1416 | SKOGLUND MIDDLE SCHOOL | Regular School | No | 2.0 | 06 | 08 | 2016 | grade_7 | 3 | 0 | 41 | 1 | 0 | 0 | 0 | 24 | 21 | 45 | 3 | 0 | 41 | 1 | 0 | 0 | 0 | 24 | 21 | 45 | ||||||||||||||||||||||||||||||||||
848197 | 848197 | CO | school | 8001 | CHARTER SCHOOL INSTITUTE | 15 | ACADEMY OF CHARTER SCHOOLS | 2016 | grade_7 | 77 | 2 | 48 | 0 | 14 | 0 | 3 | 69 | 75 | 144 | 77 | 2 | 48 | 0 | 14 | 0 | 3 | 69 | 75 | 144 |
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]);