enrollments
Data source: Big Local News · About: Big Local
585 rows where grade = "grade_8", 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
842105 | 842105 | CO | school | 1040 | ACADEMY 20 | 74 | CHALLENGER MIDDLE SCHOOL | 2016 | grade_8 | 206 | 11 | 22 | 1 | 15 | 2 | 18 | 145 | 130 | 275 | 206 | 11 | 22 | 1 | 15 | 2 | 18 | 145 | 130 | 275 | |||||||||||||||||||||||||||||||||||||||||
842121 | 842121 | CO | school | 1040 | ACADEMY 20 | 209 | ASPEN VALLEY CAMPUS | 2016 | grade_8 | 24 | 1 | 2 | 1 | 0 | 0 | 2 | 23 | 7 | 30 | 24 | 1 | 2 | 1 | 0 | 0 | 2 | 23 | 7 | 30 | |||||||||||||||||||||||||||||||||||||||||
842152 | 842152 | CO | school | 801920 | 1040 | ACADEMY 20 | 80192001931 | 1629 | THE CLASSICAL ACADEMY MIDDLE SCHOOL | Regular School | Yes | 2.0 | 07 | 08 | 2016 | grade_8 | 190 | 5 | 23 | 0 | 5 | 0 | 9 | 127 | 105 | 232 | 190 | 5 | 23 | 0 | 5 | 0 | 9 | 127 | 105 | 232 | ||||||||||||||||||||||||||||||||||
842166 | 842166 | CO | school | 801920 | 1040 | ACADEMY 20 | 80192006478 | 1901 | ACADEMY CALVERT K-8 ONLINE SCHOOL | Regular School | No | 1.0 | KG | 08 | 2016 | grade_8 | 13 | 1 | 2 | 0 | 0 | 0 | 0 | 7 | 9 | 16 | 13 | 1 | 2 | 0 | 0 | 0 | 0 | 7 | 9 | 16 | ||||||||||||||||||||||||||||||||||
842171 | 842171 | CO | school | 801920 | 1040 | ACADEMY 20 | 80192006616 | 1921 | DISCOVERY CANYON CAMPUS MIDDLE SCHOOL | Regular School | No | 2.0 | 06 | 08 | 2016 | grade_8 | 254 | 7 | 37 | 1 | 13 | 1 | 12 | 177 | 148 | 325 | 254 | 7 | 37 | 1 | 13 | 1 | 12 | 177 | 148 | 325 | ||||||||||||||||||||||||||||||||||
842197 | 842197 | CO | school | 801920 | 1040 | ACADEMY 20 | 80192001402 | 2358 | EAGLEVIEW MIDDLE SCHOOL | Regular School | No | 2.0 | 06 | 08 | 2016 | grade_8 | 246 | 11 | 42 | 2 | 13 | 0 | 19 | 164 | 169 | 333 | 246 | 11 | 42 | 2 | 13 | 0 | 19 | 164 | 169 | 333 | ||||||||||||||||||||||||||||||||||
842250 | 842250 | CO | school | 801920 | 1040 | ACADEMY 20 | 80192001593 | 6140 | MOUNTAIN RIDGE MIDDLE SCHOOL | Regular School | No | 2.0 | 06 | 08 | 2016 | grade_8 | 271 | 19 | 54 | 1 | 28 | 2 | 22 | 208 | 189 | 397 | 271 | 19 | 54 | 1 | 28 | 2 | 22 | 208 | 189 | 397 | ||||||||||||||||||||||||||||||||||
842307 | 842307 | CO | school | 801920 | 1040 | ACADEMY 20 | 80192006447 | 8779 | TCA COLLEGE PATHWAYS | Regular School | Yes | 3.0 | 07 | 12 | 2016 | grade_8 | 43 | 2 | 7 | 0 | 0 | 1 | 7 | 31 | 29 | 60 | 43 | 2 | 7 | 0 | 0 | 1 | 7 | 31 | 29 | 60 | ||||||||||||||||||||||||||||||||||
842321 | 842321 | CO | school | 801920 | 1040 | ACADEMY 20 | 80192001462 | 8851 | TIMBERVIEW MIDDLE SCHOOL | Regular School | No | 2.0 | 06 | 08 | 2016 | grade_8 | 237 | 16 | 49 | 4 | 6 | 2 | 25 | 177 | 162 | 339 | 237 | 16 | 49 | 4 | 6 | 2 | 25 | 177 | 162 | 339 | ||||||||||||||||||||||||||||||||||
835641 | 835641 | CO | school | 20 | ADAMS 12 FIVE STAR SCHOOLS | 57 | ROCKY TOP MIDDLE SCHOOL | 2016 | grade_8 | 338 | 6 | 80 | 1 | 24 | 1 | 4 | 231 | 223 | 454 | 338 | 6 | 80 | 1 | 24 | 1 | 4 | 231 | 223 | 454 | |||||||||||||||||||||||||||||||||||||||||
835658 | 835658 | CO | school | 20 | ADAMS 12 FIVE STAR SCHOOLS | 210 | VANTAGE POINT | 2016 | grade_8 | 14 | 0 | 16 | 0 | 0 | 0 | 0 | 21 | 9 | 30 | 14 | 0 | 16 | 0 | 0 | 0 | 0 | 21 | 9 | 30 | |||||||||||||||||||||||||||||||||||||||||
835680 | 835680 | CO | school | 806900 | 20 | ADAMS 12 FIVE STAR SCHOOLS | 80690001620 | 1480 | CENTURY MIDDLE SCHOOL | Regular School | No | 2.0 | 06 | 08 | 2016 | grade_8 | 223 | 11 | 109 | 6 | 14 | 1 | 7 | 180 | 191 | 371 | 223 | 11 | 109 | 6 | 14 | 1 | 7 | 180 | 191 | 371 | ||||||||||||||||||||||||||||||||||
835689 | 835689 | CO | school | 806900 | 20 | ADAMS 12 FIVE STAR SCHOOLS | 80690000728 | 1519 | STARGATE CHARTER SCHOOL | Regular School | Yes | 4.0 | KG | 09 | 2016 | grade_8 | 44 | 1 | 8 | 0 | 14 | 0 | 1 | 33 | 35 | 68 | 44 | 1 | 8 | 0 | 14 | 0 | 1 | 33 | 35 | 68 | ||||||||||||||||||||||||||||||||||
835785 | 835785 | CO | school | 806900 | 20 | ADAMS 12 FIVE STAR SCHOOLS | 80690006503 | 3439 | GLOBAL VILLAGE ACADEMY | Regular School | Yes | 1.0 | KG | 08 | 2016 | grade_8 | 20 | 0 | 27 | 0 | 1 | 0 | 1 | 30 | 19 | 49 | 20 | 0 | 27 | 0 | 1 | 0 | 1 | 30 | 19 | 49 | ||||||||||||||||||||||||||||||||||
835808 | 835808 | 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_8 | 50 | 1 | 5 | 0 | 9 | 1 | 2 | 42 | 26 | 68 | 50 | 1 | 5 | 0 | 9 | 1 | 2 | 42 | 26 | 68 | ||||||||||||||||||||||||||||||||||
835813 | 835813 | CO | school | 806900 | 20 | ADAMS 12 FIVE STAR SCHOOLS | 80690001179 | 4187 | SILVER HILLS MIDDLE SCHOOL | Regular School | No | 2.0 | 06 | 08 | 2016 | grade_8 | 174 | 9 | 155 | 3 | 24 | 0 | 6 | 197 | 174 | 371 | 174 | 9 | 155 | 3 | 24 | 0 | 6 | 197 | 174 | 371 | ||||||||||||||||||||||||||||||||||
835843 | 835843 | 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_8 | 43 | 7 | 224 | 5 | 6 | 0 | 4 | 157 | 132 | 289 | 43 | 7 | 224 | 5 | 6 | 0 | 4 | 157 | 132 | 289 | ||||||||||||||||||||||||||||||||||
835865 | 835865 | CO | school | 806900 | 20 | ADAMS 12 FIVE STAR SCHOOLS | 80690001186 | 6342 | SHADOW RIDGE MIDDLE SCHOOL | Regular School | No | 2.0 | 06 | 08 | 2016 | grade_8 | 176 | 6 | 132 | 1 | 22 | 0 | 2 | 180 | 159 | 339 | 176 | 6 | 132 | 1 | 22 | 0 | 2 | 180 | 159 | 339 | ||||||||||||||||||||||||||||||||||
835883 | 835883 | CO | school | 806900 | 20 | ADAMS 12 FIVE STAR SCHOOLS | 80690001187 | 6398 | NORTHGLENN MIDDLE SCHOOL | Regular School | No | 2.0 | 06 | 08 | 2016 | grade_8 | 86 | 15 | 180 | 2 | 9 | 1 | 4 | 158 | 139 | 297 | 86 | 15 | 180 | 2 | 9 | 1 | 4 | 158 | 139 | 297 | ||||||||||||||||||||||||||||||||||
835898 | 835898 | CO | school | 806900 | 20 | ADAMS 12 FIVE STAR SCHOOLS | 80690006507 | 6802 | PROSPECT RIDGE ACADEMY | Regular School | Yes | 4.0 | KG | 10 | 2016 | grade_8 | 97 | 0 | 6 | 0 | 8 | 0 | 1 | 63 | 49 | 112 | 97 | 0 | 6 | 0 | 8 | 0 | 1 | 63 | 49 | 112 | ||||||||||||||||||||||||||||||||||
835907 | 835907 | CO | school | 806900 | 20 | ADAMS 12 FIVE STAR SCHOOLS | 80690006550 | 6956 | PATHWAYS FUTURE CENTER | Alternative Education School | No | 4.0 | KG | 12 | 2016 | grade_8 | 2 | 1 | 1 | 0 | 0 | 0 | 0 | 4 | 0 | 4 | 2 | 1 | 1 | 0 | 0 | 0 | 0 | 4 | 0 | 4 | ||||||||||||||||||||||||||||||||||
835948 | 835948 | CO | school | 806900 | 20 | ADAMS 12 FIVE STAR SCHOOLS | 80690006468 | 8275 | STEM LAB | Regular School | No | 1.0 | KG | 08 | 2016 | grade_8 | 40 | 0 | 9 | 0 | 3 | 0 | 1 | 31 | 22 | 53 | 40 | 0 | 9 | 0 | 3 | 0 | 1 | 31 | 22 | 53 | ||||||||||||||||||||||||||||||||||
835958 | 835958 | CO | school | 806900 | 20 | ADAMS 12 FIVE STAR SCHOOLS | 80690006561 | 8310 | STEM LAUNCH | Regular School | No | 1.0 | KG | 08 | 2016 | grade_8 | 24 | 3 | 118 | 1 | 4 | 0 | 1 | 87 | 64 | 151 | 24 | 3 | 118 | 1 | 4 | 0 | 1 | 87 | 64 | 151 | ||||||||||||||||||||||||||||||||||
835986 | 835986 | CO | school | 806900 | 20 | ADAMS 12 FIVE STAR SCHOOLS | 80690006417 | 9431 | WESTGATE CHARTER | Regular School | Yes | 4.0 | KG | 12 | 2016 | grade_8 | 25 | 0 | 7 | 0 | 1 | 0 | 0 | 23 | 10 | 33 | 25 | 0 | 7 | 0 | 1 | 0 | 0 | 23 | 10 | 33 | ||||||||||||||||||||||||||||||||||
835993 | 835993 | CO | school | 806900 | 20 | ADAMS 12 FIVE STAR SCHOOLS | 80690001194 | 9444 | WESTLAKE MIDDLE SCHOOL | Regular School | No | 2.0 | 06 | 08 | 2016 | grade_8 | 252 | 3 | 90 | 1 | 31 | 0 | 5 | 200 | 182 | 382 | 252 | 3 | 90 | 1 | 31 | 0 | 5 | 200 | 182 | 382 | ||||||||||||||||||||||||||||||||||
836011 | 836011 | CO | school | 30 | ADAMS COUNTY 14 | 20 | ADAMS CITY MIDDLE SCHOOL | 2016 | grade_8 | 28 | 7 | 218 | 1 | 2 | 0 | 4 | 130 | 130 | 260 | 28 | 7 | 218 | 1 | 2 | 0 | 4 | 130 | 130 | 260 | |||||||||||||||||||||||||||||||||||||||||
836049 | 836049 | CO | school | 801950 | 30 | ADAMS COUNTY 14 | 80195000015 | 4516 | KEARNEY MIDDLE SCHOOL | Regular School | No | 2.0 | 06 | 08 | 2016 | grade_8 | 30 | 10 | 244 | 1 | 1 | 0 | 2 | 148 | 140 | 288 | 30 | 10 | 244 | 1 | 1 | 0 | 2 | 148 | 140 | 288 | ||||||||||||||||||||||||||||||||||
837137 | 837137 | CO | school | 180 | ADAMS-ARAPAHOE 28J | 1 | FACILITIES WITH DISTRICT RUN EDUCATION | 2016 | grade_8 | 0 | 1 | 0 | 1 | 0 | 0 | 0 | 2 | 0 | 2 | 0 | 1 | 0 | 1 | 0 | 0 | 0 | 2 | 0 | 2 | |||||||||||||||||||||||||||||||||||||||||
837149 | 837149 | CO | school | 180 | ADAMS-ARAPAHOE 28J | 213 | AXL ACADEMY | 2016 | grade_8 | 9 | 17 | 10 | 0 | 0 | 0 | 0 | 17 | 19 | 36 | 9 | 17 | 10 | 0 | 0 | 0 | 0 | 17 | 19 | 36 | |||||||||||||||||||||||||||||||||||||||||
837181 | 837181 | CO | school | 180 | ADAMS-ARAPAHOE 28J | 458 | AURORA ACADEMY CHARTER SCHOOL | 2016 | grade_8 | 15 | 8 | 14 | 0 | 0 | 0 | 2 | 25 | 14 | 39 | 15 | 8 | 14 | 0 | 0 | 0 | 2 | 25 | 14 | 39 | |||||||||||||||||||||||||||||||||||||||||
837186 | 837186 | CO | school | 180 | ADAMS-ARAPAHOE 28J | 464 | AURORA HILLS MIDDLE SCHOOL | 2016 | grade_8 | 21 | 80 | 173 | 2 | 14 | 1 | 13 | 185 | 119 | 304 | 21 | 80 | 173 | 2 | 14 | 1 | 13 | 185 | 119 | 304 | |||||||||||||||||||||||||||||||||||||||||
837195 | 837195 | CO | school | 180 | ADAMS-ARAPAHOE 28J | 465 | AURORA FRONTIER K-8 | 2016 | grade_8 | 27 | 13 | 16 | 1 | 8 | 0 | 5 | 36 | 34 | 70 | 27 | 13 | 16 | 1 | 8 | 0 | 5 | 36 | 34 | 70 | |||||||||||||||||||||||||||||||||||||||||
837206 | 837206 | CO | school | 180 | ADAMS-ARAPAHOE 28J | 914 | BOSTON K-8 SCHOOL | 2016 | grade_8 | 0 | 4 | 28 | 0 | 8 | 0 | 1 | 14 | 27 | 41 | 0 | 4 | 28 | 0 | 8 | 0 | 1 | 14 | 27 | 41 | |||||||||||||||||||||||||||||||||||||||||
837229 | 837229 | CO | school | 802340 | 180 | ADAMS-ARAPAHOE 28J | 80234000057 | 1720 | CLYDE MILLER K-8 | Regular School | No | 1.0 | PK | 08 | 2016 | grade_8 | 11 | 6 | 45 | 0 | 2 | 0 | 1 | 33 | 32 | 65 | 11 | 6 | 45 | 0 | 2 | 0 | 1 | 33 | 32 | 65 | ||||||||||||||||||||||||||||||||||
837235 | 837235 | CO | school | 802340 | 180 | ADAMS-ARAPAHOE 28J | 80234001322 | 1800 | COLUMBIA MIDDLE SCHOOL | Regular School | No | 2.0 | 06 | 08 | 2016 | grade_8 | 89 | 56 | 108 | 1 | 16 | 0 | 17 | 144 | 143 | 287 | 89 | 56 | 108 | 1 | 16 | 0 | 17 | 144 | 143 | 287 | ||||||||||||||||||||||||||||||||||
837263 | 837263 | CO | school | 802340 | 180 | ADAMS-ARAPAHOE 28J | 80234000060 | 2384 | EAST MIDDLE SCHOOL | Regular School | No | 2.0 | 06 | 08 | 2016 | grade_8 | 20 | 55 | 236 | 1 | 16 | 3 | 9 | 183 | 157 | 340 | 20 | 55 | 236 | 1 | 16 | 3 | 9 | 183 | 157 | 340 | ||||||||||||||||||||||||||||||||||
837279 | 837279 | 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_8 | 8 | 8 | 45 | 2 | 2 | 0 | 3 | 30 | 38 | 68 | 8 | 8 | 45 | 2 | 2 | 0 | 3 | 30 | 38 | 68 | ||||||||||||||||||||||||||||||||||
837312 | 837312 | CO | school | 802340 | 180 | ADAMS-ARAPAHOE 28J | 80234006318 | 3471 | GLOBAL VILLAGE ACADEMY AURORA | Regular School | Yes | 1.0 | KG | 08 | 2016 | grade_8 | 8 | 10 | 32 | 0 | 2 | 0 | 2 | 20 | 34 | 54 | 8 | 10 | 32 | 0 | 2 | 0 | 2 | 20 | 34 | 54 | ||||||||||||||||||||||||||||||||||
837371 | 837371 | CO | school | 802340 | 180 | ADAMS-ARAPAHOE 28J | 80234001916 | 5298 | LOTUS SCHOOL FOR EXCELLENCE | Regular School | Yes | 4.0 | KG | 12 | 2016 | grade_8 | 16 | 33 | 23 | 0 | 1 | 0 | 0 | 39 | 34 | 73 | 16 | 33 | 23 | 0 | 1 | 0 | 0 | 39 | 34 | 73 | ||||||||||||||||||||||||||||||||||
837395 | 837395 | CO | school | 802340 | 180 | ADAMS-ARAPAHOE 28J | 80234000073 | 6160 | MRACHEK MIDDLE SCHOOL | Regular School | No | 2.0 | 06 | 08 | 2016 | grade_8 | 45 | 72 | 146 | 1 | 12 | 2 | 10 | 161 | 127 | 288 | 45 | 72 | 146 | 1 | 12 | 2 | 10 | 161 | 127 | 288 | ||||||||||||||||||||||||||||||||||
837404 | 837404 | CO | school | 802340 | 180 | ADAMS-ARAPAHOE 28J | 80234001881 | 6189 | MURPHY CREEK K-8 SCHOOL | Regular School | No | 1.0 | PK | 08 | 2016 | grade_8 | 25 | 12 | 28 | 0 | 1 | 0 | 6 | 39 | 33 | 72 | 25 | 12 | 28 | 0 | 1 | 0 | 6 | 39 | 33 | 72 | ||||||||||||||||||||||||||||||||||
837410 | 837410 | 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_8 | 17 | 45 | 190 | 3 | 5 | 0 | 9 | 130 | 139 | 269 | 17 | 45 | 190 | 3 | 5 | 0 | 9 | 130 | 139 | 269 | ||||||||||||||||||||||||||||||||||
837422 | 837422 | CO | school | 802340 | 180 | ADAMS-ARAPAHOE 28J | 80234001789 | 6546 | OPTIONS SCHOOL | Regular School | No | 4.0 | KG | 12 | 2016 | grade_8 | 67 | 0 | 6 | 0 | 2 | 0 | 0 | 39 | 36 | 75 | 67 | 0 | 6 | 0 | 2 | 0 | 0 | 39 | 36 | 75 | ||||||||||||||||||||||||||||||||||
837457 | 837457 | CO | school | 802340 | 180 | ADAMS-ARAPAHOE 28J | 80234001674 | 7232 | AURORA QUEST K-8 | Regular School | No | 1.0 | KG | 08 | 2016 | grade_8 | 39 | 10 | 12 | 0 | 11 | 1 | 7 | 40 | 40 | 80 | 39 | 10 | 12 | 0 | 11 | 1 | 7 | 40 | 40 | 80 | ||||||||||||||||||||||||||||||||||
837491 | 837491 | CO | school | 802340 | 180 | ADAMS-ARAPAHOE 28J | 80234000079 | 8078 | SOUTH MIDDLE SCHOOL | Regular School | No | 2.0 | 06 | 08 | 2016 | grade_8 | 20 | 57 | 183 | 2 | 8 | 0 | 10 | 138 | 142 | 280 | 20 | 57 | 183 | 2 | 8 | 0 | 10 | 138 | 142 | 280 | ||||||||||||||||||||||||||||||||||
837512 | 837512 | CO | school | 802340 | 180 | ADAMS-ARAPAHOE 28J | 80234006322 | 9056 | VANGUARD CLASSICAL SCHOOL - WEST | Regular School | Yes | 1.0 | KG | 08 | 2016 | grade_8 | 9 | 7 | 30 | 1 | 0 | 0 | 1 | 21 | 27 | 48 | 9 | 7 | 30 | 1 | 0 | 0 | 1 | 21 | 27 | 48 | ||||||||||||||||||||||||||||||||||
837538 | 837538 | CO | school | 802340 | 180 | ADAMS-ARAPAHOE 28J | 80234006483 | 9083 | VISTA PEAK P-8 EXPLORATORY | Regular School | No | 1.0 | PK | 08 | 2016 | grade_8 | 24 | 8 | 43 | 1 | 1 | 1 | 9 | 45 | 42 | 87 | 24 | 8 | 43 | 1 | 1 | 1 | 9 | 45 | 42 | 87 | ||||||||||||||||||||||||||||||||||
837564 | 837564 | CO | school | 802340 | 180 | ADAMS-ARAPAHOE 28J | 80234006611 | 9189 | VANGUARD CLASSICAL SCHOOL - EAST | Regular School | Yes | 4.0 | KG | 11 | 2016 | grade_8 | 18 | 17 | 19 | 0 | 4 | 0 | 2 | 36 | 24 | 60 | 18 | 17 | 19 | 0 | 4 | 0 | 2 | 36 | 24 | 60 | ||||||||||||||||||||||||||||||||||
837573 | 837573 | CO | school | 802340 | 180 | ADAMS-ARAPAHOE 28J | 80234000082 | 9396 | AURORA WEST COLLEGE PREPARATORY ACADEMY | Regular School | No | 4.0 | 06 | 12 | 2016 | grade_8 | 14 | 32 | 201 | 2 | 50 | 0 | 8 | 152 | 155 | 307 | 14 | 32 | 201 | 2 | 50 | 0 | 8 | 152 | 155 | 307 | ||||||||||||||||||||||||||||||||||
845389 | 845389 | CO | school | 1620 | AGUILAR REORGANIZED 6 | 66 | AGUILAR JUNIOR-SENIOR HIGH SCHOOL | 2016 | grade_8 | 3 | 0 | 6 | 0 | 0 | 0 | 0 | 6 | 3 | 9 | 3 | 0 | 6 | 0 | 0 | 0 | 0 | 6 | 3 | 9 | |||||||||||||||||||||||||||||||||||||||||
847485 | 847485 | CO | school | 3030 | AKRON R-1 | 86 | AKRON ELEMENTARY SCHOOL | 2016 | grade_8 | 11 | 0 | 3 | 0 | 0 | 0 | 1 | 6 | 9 | 15 | 11 | 0 | 3 | 0 | 0 | 0 | 1 | 6 | 9 | 15 | |||||||||||||||||||||||||||||||||||||||||
836425 | 836425 | CO | school | 100 | ALAMOSA RE-11J | 114 | ORTEGA MIDDLE SCHOOL | 2016 | grade_8 | 54 | 3 | 107 | 2 | 2 | 1 | 3 | 80 | 92 | 172 | 54 | 3 | 107 | 2 | 2 | 1 | 3 | 80 | 92 | 172 | |||||||||||||||||||||||||||||||||||||||||
836443 | 836443 | CO | school | 100 | ALAMOSA RE-11J | 368 | ALAMOSA OMBUDSMAN SCHOOL OF EXCELLENCE | 2016 | grade_8 | 1 | 1 | 3 | 0 | 0 | 0 | 0 | 3 | 2 | 5 | 1 | 1 | 3 | 0 | 0 | 0 | 0 | 3 | 2 | 5 | |||||||||||||||||||||||||||||||||||||||||
837663 | 837663 | CO | school | 802190 | 220 | ARCHULETA COUNTY 50 JT | 80219000040 | 6657 | PAGOSA SPRINGS MIDDLE SCHOOL | Regular School | No | 2.0 | 05 | 08 | 2016 | grade_8 | 80 | 0 | 3 | 30 | 2 | 2 | 2 | 57 | 62 | 119 | 80 | 0 | 3 | 30 | 2 | 2 | 2 | 57 | 62 | 119 | ||||||||||||||||||||||||||||||||||
847507 | 847507 | CO | school | 3040 | ARICKAREE R-2 | 308 | ARICKAREE UNDIVIDED HIGH SCHOOL | 2016 | grade_8 | 9 | 0 | 2 | 0 | 0 | 0 | 0 | 8 | 3 | 11 | 9 | 0 | 2 | 0 | 0 | 0 | 0 | 8 | 3 | 11 | |||||||||||||||||||||||||||||||||||||||||
844442 | 844442 | CO | school | 802260 | 1450 | ARRIBA-FLAGLER C-20 | 80226000509 | 2960 | FLAGLER PUBLIC SCHOOL | Regular School | No | 4.0 | PK | 12 | 2016 | grade_8 | 10 | 0 | 1 | 0 | 0 | 0 | 0 | 7 | 4 | 11 | 10 | 0 | 1 | 0 | 0 | 0 | 0 | 7 | 4 | 11 | ||||||||||||||||||||||||||||||||||
846539 | 846539 | CO | school | 2640 | ASPEN 1 | 42 | ASPEN COMMUNITY CHARTER SCHOOL | 2016 | grade_8 | 12 | 0 | 0 | 0 | 0 | 0 | 0 | 7 | 5 | 12 | 12 | 0 | 0 | 0 | 0 | 0 | 0 | 7 | 5 | 12 | |||||||||||||||||||||||||||||||||||||||||
846551 | 846551 | CO | school | 2640 | ASPEN 1 | 430 | ASPEN MIDDLE SCHOOL | 2016 | grade_8 | 113 | 3 | 18 | 1 | 4 | 0 | 0 | 75 | 64 | 139 | 113 | 3 | 18 | 1 | 4 | 0 | 0 | 75 | 64 | 139 | |||||||||||||||||||||||||||||||||||||||||
848067 | 848067 | CO | school | 802310 | 3145 | AULT-HIGHLAND RE-9 | 80231001466 | 3961 | HIGHLAND MIDDLE SCHOOL | Regular School | No | 2.0 | 06 | 08 | 2016 | grade_8 | 45 | 0 | 28 | 0 | 0 | 0 | 1 | 37 | 37 | 74 | 45 | 0 | 28 | 0 | 0 | 0 | 1 | 37 | 37 | 74 | ||||||||||||||||||||||||||||||||||
844626 | 844626 | CO | school | 1530 | BAYFIELD 10 JT-R | 636 | BAYFIELD MIDDLE SCHOOL | 2016 | grade_8 | 66 | 0 | 13 | 2 | 2 | 0 | 1 | 42 | 42 | 84 | 66 | 0 | 13 | 2 | 2 | 0 | 1 | 42 | 42 | 84 | |||||||||||||||||||||||||||||||||||||||||
836274 | 836274 | CO | school | 50 | BENNETT 29J | 774 | BENNETT MIDDLE SCHOOL | 2016 | grade_8 | 73 | 1 | 21 | 0 | 0 | 0 | 3 | 51 | 47 | 98 | 73 | 1 | 21 | 0 | 0 | 0 | 3 | 51 | 47 | 98 | |||||||||||||||||||||||||||||||||||||||||
844489 | 844489 | CO | school | 1490 | BETHUNE R-5 | 842 | BETHUNE PUBLIC SCHOOLS | 2016 | grade_8 | 5 | 0 | 2 | 0 | 0 | 0 | 0 | 5 | 2 | 7 | 5 | 0 | 2 | 0 | 0 | 0 | 0 | 5 | 2 | 7 | |||||||||||||||||||||||||||||||||||||||||
841235 | 841235 | CO | school | 806600 | 940 | BIG SANDY 100J | 80660001140 | 7918 | SIMLA JUNIOR HIGH SCHOOL | Regular School | No | 2.0 | 06 | 08 | 2016 | grade_8 | 20 | 0 | 1 | 0 | 0 | 1 | 0 | 16 | 6 | 22 | 20 | 0 | 1 | 0 | 0 | 1 | 0 | 16 | 6 | 22 | ||||||||||||||||||||||||||||||||||
838201 | 838201 | CO | school | 480 | BOULDER VALLEY RE 2 | 441 | ASPEN CREEK K-8 SCHOOL | 2016 | grade_8 | 110 | 1 | 14 | 0 | 11 | 1 | 6 | 82 | 61 | 143 | 110 | 1 | 14 | 0 | 11 | 1 | 6 | 82 | 61 | 143 | |||||||||||||||||||||||||||||||||||||||||
838219 | 838219 | CO | school | 480 | BOULDER VALLEY RE 2 | 866 | BOULDER EXPLORE | 2016 | grade_8 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 1 | |||||||||||||||||||||||||||||||||||||||||
838250 | 838250 | CO | school | 480 | BOULDER VALLEY RE 2 | 930 | BOULDER UNIVERSAL | 2016 | grade_8 | 5 | 0 | 2 | 0 | 0 | 0 | 0 | 2 | 5 | 7 | 5 | 0 | 2 | 0 | 0 | 0 | 0 | 2 | 5 | 7 | |||||||||||||||||||||||||||||||||||||||||
838260 | 838260 | CO | school | 802490 | 480 | BOULDER VALLEY RE 2 | 80249000102 | 1066 | BROOMFIELD HEIGHTS MIDDLE SCHOOL | Regular School | No | 2.0 | 06 | 08 | 2016 | grade_8 | 145 | 3 | 44 | 1 | 5 | 0 | 10 | 99 | 109 | 208 | 145 | 3 | 44 | 1 | 5 | 0 | 10 | 99 | 109 | 208 | ||||||||||||||||||||||||||||||||||
838269 | 838269 | 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_8 | 122 | 0 | 48 | 2 | 13 | 0 | 10 | 95 | 100 | 195 | 122 | 0 | 48 | 2 | 13 | 0 | 10 | 95 | 100 | 195 | ||||||||||||||||||||||||||||||||||
838273 | 838273 | CO | school | 802490 | 480 | BOULDER VALLEY RE 2 | 80249000106 | 1352 | CASEY MIDDLE SCHOOL | Regular School | No | 2.0 | 06 | 08 | 2016 | grade_8 | 96 | 3 | 92 | 1 | 12 | 0 | 5 | 115 | 94 | 209 | 96 | 3 | 92 | 1 | 12 | 0 | 5 | 115 | 94 | 209 | ||||||||||||||||||||||||||||||||||
838282 | 838282 | CO | school | 802490 | 480 | BOULDER VALLEY RE 2 | 80249000108 | 1390 | CENTENNIAL MIDDLE SCHOOL | Regular School | No | 2.0 | 06 | 08 | 2016 | grade_8 | 139 | 0 | 37 | 3 | 12 | 0 | 11 | 100 | 102 | 202 | 139 | 0 | 37 | 3 | 12 | 0 | 11 | 100 | 102 | 202 | ||||||||||||||||||||||||||||||||||
838338 | 838338 | CO | school | 802490 | 480 | BOULDER VALLEY RE 2 | 80249001771 | 2589 | ELDORADO K-8 SCHOOL | Regular School | No | 1.0 | KG | 08 | 2016 | grade_8 | 112 | 0 | 10 | 0 | 12 | 0 | 10 | 86 | 58 | 144 | 112 | 0 | 10 | 0 | 12 | 0 | 10 | 86 | 58 | 144 | ||||||||||||||||||||||||||||||||||
838390 | 838390 | CO | school | 802490 | 480 | BOULDER VALLEY RE 2 | 80249001467 | 3499 | HALCYON SCHOOL (SPECIAL EDUCATION) | Special Education School | No | 4.0 | 06 | 12 | 2016 | grade_8 | 5 | 0 | 0 | 0 | 0 | 0 | 0 | 5 | 0 | 5 | 5 | 0 | 0 | 0 | 0 | 0 | 0 | 5 | 0 | 5 | ||||||||||||||||||||||||||||||||||
838420 | 838420 | CO | school | 802490 | 480 | BOULDER VALLEY RE 2 | 80249002013 | 4496 | JUSTICE HIGH CHARTER SCHOOL | Alternative Education School | Yes | 4.0 | 06 | 12 | 2016 | grade_8 | 1 | 0 | 1 | 0 | 0 | 0 | 1 | 2 | 1 | 3 | 1 | 0 | 1 | 0 | 0 | 0 | 1 | 2 | 1 | 3 | ||||||||||||||||||||||||||||||||||
838441 | 838441 | CO | school | 802490 | 480 | BOULDER VALLEY RE 2 | 80249000122 | 4878 | ANGEVINE MIDDLE SCHOOL | Regular School | No | 2.0 | 06 | 08 | 2016 | grade_8 | 112 | 1 | 99 | 1 | 6 | 0 | 9 | 127 | 101 | 228 | 112 | 1 | 99 | 1 | 6 | 0 | 9 | 127 | 101 | 228 | ||||||||||||||||||||||||||||||||||
838452 | 838452 | CO | school | 802490 | 480 | BOULDER VALLEY RE 2 | 80249000125 | 5306 | LOUISVILLE MIDDLE SCHOOL | Regular School | No | 2.0 | 06 | 08 | 2016 | grade_8 | 168 | 1 | 29 | 1 | 5 | 0 | 12 | 104 | 112 | 216 | 168 | 1 | 29 | 1 | 5 | 0 | 12 | 104 | 112 | 216 | ||||||||||||||||||||||||||||||||||
838483 | 838483 | CO | school | 802490 | 480 | BOULDER VALLEY RE 2 | 80249001573 | 6000 | MONARCH K-8 SCHOOL | Regular School | No | 1.0 | PK | 08 | 2016 | grade_8 | 124 | 2 | 12 | 0 | 11 | 0 | 6 | 72 | 83 | 155 | 124 | 2 | 12 | 0 | 11 | 0 | 6 | 72 | 83 | 155 | ||||||||||||||||||||||||||||||||||
838507 | 838507 | CO | school | 802490 | 480 | BOULDER VALLEY RE 2 | 80249000131 | 6212 | NEDERLAND MIDDLE-SENIOR HIGH SCHOOL | Regular School | No | 4.0 | 06 | 12 | 2016 | grade_8 | 35 | 0 | 0 | 0 | 1 | 0 | 3 | 16 | 23 | 39 | 35 | 0 | 0 | 0 | 1 | 0 | 3 | 16 | 23 | 39 | ||||||||||||||||||||||||||||||||||
838512 | 838512 | CO | school | 802490 | 480 | BOULDER VALLEY RE 2 | 80249000132 | 6224 | NEVIN PLATT MIDDLE SCHOOL | Regular School | No | 2.0 | 06 | 08 | 2016 | grade_8 | 158 | 2 | 16 | 1 | 2 | 0 | 10 | 93 | 96 | 189 | 158 | 2 | 16 | 1 | 2 | 0 | 10 | 93 | 96 | 189 | ||||||||||||||||||||||||||||||||||
838521 | 838521 | CO | school | 802490 | 480 | BOULDER VALLEY RE 2 | 80249006199 | 6642 | HORIZONS K-8 SCHOOL | Alternative Education School | Yes | 1.0 | KG | 08 | 2016 | grade_8 | 29 | 0 | 2 | 0 | 2 | 0 | 1 | 19 | 15 | 34 | 29 | 0 | 2 | 0 | 2 | 0 | 1 | 19 | 15 | 34 | ||||||||||||||||||||||||||||||||||
838535 | 838535 | CO | school | 802490 | 480 | BOULDER VALLEY RE 2 | 80249001792 | 6816 | PEAK TO PEAK CHARTER SCHOOL | Regular School | Yes | 4.0 | KG | 12 | 2016 | grade_8 | 89 | 2 | 11 | 0 | 24 | 1 | 8 | 69 | 66 | 135 | 89 | 2 | 11 | 0 | 24 | 1 | 8 | 69 | 66 | 135 | ||||||||||||||||||||||||||||||||||
838566 | 838566 | CO | school | 802490 | 480 | BOULDER VALLEY RE 2 | 80249000134 | 8135 | SOUTHERN HILLS MIDDLE SCHOOL | Regular School | No | 2.0 | 06 | 08 | 2016 | grade_8 | 150 | 1 | 8 | 1 | 9 | 0 | 8 | 99 | 78 | 177 | 150 | 1 | 8 | 1 | 9 | 0 | 8 | 99 | 78 | 177 | ||||||||||||||||||||||||||||||||||
838570 | 838570 | CO | school | 802490 | 480 | BOULDER VALLEY RE 2 | 80249001517 | 8387 | SUMMIT MIDDLE CHARTER SCHOOL | Regular School | Yes | 2.0 | 06 | 08 | 2016 | grade_8 | 63 | 0 | 6 | 1 | 32 | 0 | 10 | 62 | 50 | 112 | 63 | 0 | 6 | 1 | 32 | 0 | 10 | 62 | 50 | 112 | ||||||||||||||||||||||||||||||||||
845402 | 845402 | CO | school | 1750 | BRANSON REORGANIZED 82 | 948 | BRANSON SCHOOL ONLINE | 2016 | grade_8 | 37 | 1 | 6 | 1 | 0 | 0 | 1 | 20 | 26 | 46 | 37 | 1 | 6 | 1 | 0 | 0 | 1 | 20 | 26 | 46 | |||||||||||||||||||||||||||||||||||||||||
845416 | 845416 | CO | school | 1750 | BRANSON REORGANIZED 82 | 978 | BRANSON SCHOOL | 2016 | grade_8 | 2 | 0 | 0 | 0 | 0 | 0 | 1 | 1 | 2 | 3 | 2 | 0 | 0 | 0 | 0 | 0 | 1 | 1 | 2 | 3 | |||||||||||||||||||||||||||||||||||||||||
848087 | 848087 | CO | school | 802550 | 3146 | BRIGGSDALE RE-10 | 80255000143 | 1012 | BRIGGSDALE UNDIVIDED HIGH SCHOOL | Regular School | No | 4.0 | 06 | 12 | 2016 | grade_8 | 19 | 0 | 0 | 0 | 0 | 0 | 1 | 10 | 10 | 20 | 19 | 0 | 0 | 0 | 0 | 0 | 1 | 10 | 10 | 20 | ||||||||||||||||||||||||||||||||||
846226 | 846226 | CO | school | 802610 | 2395 | BRUSH RE-2(J) | 80261000153 | 1094 | BRUSH MIDDLE SCHOOL | Regular School | No | 2.0 | 07 | 08 | 2016 | grade_8 | 60 | 0 | 65 | 0 | 1 | 0 | 0 | 65 | 61 | 126 | 60 | 0 | 65 | 0 | 1 | 0 | 0 | 65 | 61 | 126 | ||||||||||||||||||||||||||||||||||
838601 | 838601 | 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_8 | 58 | 0 | 4 | 0 | 1 | 0 | 1 | 25 | 39 | 64 | 58 | 0 | 4 | 0 | 1 | 0 | 1 | 25 | 39 | 64 | ||||||||||||||||||||||||||||||||||
845546 | 845546 | CO | school | 805640 | 1860 | BUFFALO RE-4J | 80564000970 | 5806 | MERINO JUNIOR SENIOR HIGH SCHOOL | Regular School | No | 3.0 | 07 | 12 | 2016 | grade_8 | 21 | 1 | 1 | 0 | 0 | 0 | 0 | 12 | 11 | 23 | 21 | 1 | 1 | 0 | 0 | 0 | 0 | 12 | 11 | 23 | ||||||||||||||||||||||||||||||||||
844504 | 844504 | CO | school | 802670 | 1500 | BURLINGTON RE-6J | 80267000161 | 1150 | BURLINGTON MIDDLE SCHOOL | Regular School | No | 2.0 | 05 | 08 | 2016 | grade_8 | 15 | 1 | 24 | 1 | 1 | 0 | 0 | 17 | 25 | 42 | 15 | 1 | 24 | 1 | 1 | 0 | 0 | 17 | 25 | 42 | ||||||||||||||||||||||||||||||||||
837605 | 837605 | CO | school | 802700 | 190 | BYERS 32J | 80270000164 | 1176 | BYERS JUNIOR-SENIOR HIGH SCHOOL | Regular School | No | 3.0 | 07 | 12 | 2016 | grade_8 | 29 | 0 | 6 | 0 | 1 | 0 | 0 | 17 | 19 | 36 | 29 | 0 | 6 | 0 | 1 | 0 | 0 | 17 | 19 | 36 | ||||||||||||||||||||||||||||||||||
837623 | 837623 | CO | school | 802700 | 190 | BYERS 32J | 80270006605 | 2356 | ELEVATE ACADEMY | Regular School | Yes | 4.0 | KG | 12 | 2016 | grade_8 | 25 | 5 | 74 | 0 | 0 | 0 | 2 | 52 | 54 | 106 | 25 | 5 | 74 | 0 | 0 | 0 | 2 | 52 | 54 | 106 | ||||||||||||||||||||||||||||||||||
837637 | 837637 | CO | school | 802700 | 190 | BYERS 32J | 80270006548 | 3362 | GREAT PLAINS ACADEMY | Regular School | No | 4.0 | KG | 12 | 2016 | grade_8 | 7 | 0 | 1 | 0 | 0 | 0 | 0 | 4 | 4 | 8 | 7 | 0 | 1 | 0 | 0 | 0 | 0 | 4 | 4 | 8 | ||||||||||||||||||||||||||||||||||
837651 | 837651 | CO | school | 802700 | 190 | BYERS 32J | 80270006620 | 6263 | COLORADO DIGITAL ACADEMY - MIDDLE | Regular School | Yes | 2.0 | 07 | 08 | 2016 | grade_8 | 74 | 1 | 14 | 4 | 1 | 0 | 0 | 51 | 43 | 94 | 74 | 1 | 14 | 4 | 1 | 0 | 0 | 51 | 43 | 94 | ||||||||||||||||||||||||||||||||||
841271 | 841271 | CO | school | 802730 | 970 | CALHAN RJ-1 | 80273000510 | 1215 | CALHAN MIDDLE SCHOOL | Regular School | No | 2.0 | 06 | 08 | 2016 | grade_8 | 30 | 4 | 4 | 0 | 0 | 0 | 0 | 21 | 17 | 38 | 30 | 4 | 4 | 0 | 0 | 0 | 0 | 21 | 17 | 38 | ||||||||||||||||||||||||||||||||||
837756 | 837756 | CO | school | 802760 | 270 | CAMPO RE-6 | 80276000170 | 1252 | CAMPO UNDIVIDED HIGH SCHOOL | Regular School | No | 4.0 | 06 | 12 | 2016 | grade_8 | 2 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 2 | 2 | 2 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 2 | 2 | ||||||||||||||||||||||||||||||||||
842672 | 842672 | CO | school | 1140 | CANON CITY RE-1 | 419 | CANON ONLINE ACADEMY | 2016 | grade_8 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 1 | |||||||||||||||||||||||||||||||||||||||||
842677 | 842677 | CO | school | 802790 | 1140 | CANON CITY RE-1 | 80279000171 | 1262 | CANON CITY MIDDLE SCHOOL | Regular School | No | 2.0 | 06 | 08 | 2016 | grade_8 | 103 | 1 | 22 | 0 | 1 | 0 | 0 | 66 | 61 | 127 | 103 | 1 | 22 | 0 | 1 | 0 | 0 | 66 | 61 | 127 | ||||||||||||||||||||||||||||||||||
842691 | 842691 | CO | school | 802790 | 1140 | CANON CITY RE-1 | 80279000173 | 3802 | HARRISON SCHOOL | Regular School | No | 1.0 | KG | 08 | 2016 | grade_8 | 96 | 1 | 17 | 0 | 0 | 0 | 3 | 51 | 66 | 117 | 96 | 1 | 17 | 0 | 0 | 0 | 3 | 51 | 66 | 117 | ||||||||||||||||||||||||||||||||||
842715 | 842715 | 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_8 | 19 | 1 | 4 | 0 | 2 | 0 | 0 | 9 | 17 | 26 | 19 | 1 | 4 | 0 | 2 | 0 | 0 | 9 | 17 | 26 | ||||||||||||||||||||||||||||||||||
842725 | 842725 | CO | school | 802790 | 1140 | CANON CITY RE-1 | 80279001433 | 7950 | CANON EXPLORATORY SCHOOL | Regular School | No | 1.0 | KG | 08 | 2016 | grade_8 | 13 | 0 | 2 | 0 | 0 | 0 | 1 | 7 | 9 | 16 | 13 | 0 | 2 | 0 | 0 | 0 | 1 | 7 | 9 | 16 |
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]);