enrollments
Data source: Big Local News · About: Big Local
586 rows where grade = "grade_7", state = "CO" and year = 2016 sorted by district_state_id
This data as json, CSV (advanced)
Link | rowid | state | county | county_state_id | admin_level | district_nces_id | district_state_id ▼ | district_state_type | district | school_nces_id | school_state_id | school | school_state_type | ccd_school_type | ccd_charter_school | ccd_school_lvl | ccd_school_low_grade | ccd_school_high_grade | year | term | grade | white | black | hispanic | native_american | native_american_alaskan_native | asian | native_hawaiian | asian_pacific_islander | native_hawaiian_pacific_islander | pacific_islander | multiracial | unknown_race | male | female | non_binary | unknown_gender | ell | ell_percent | homeless | homeless_percent | low_income | free_and_reduced | free_and_reduced_percent | disability | section_504 | total | white_int | black_int | hispanic_int | native_american_int | native_american_alaskan_native_int | asian_int | native_hawaiian_int | asian_pacific_islander_int | native_hawaiian_pacific_islander_int | pacific_islander_int | multiracial_int | unknown_race_int | male_int | female_int | non_binary_int | unknown_gender_int | ell_int | homeless_int | low_income_int | free_and_reduced_int | disability_int | section_504_int | total_int |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
835492 | 835492 | CO | school | 10 | MAPLETON 1 | 187 | MAPLETON EXPEDITIONARY SCHOOL OF THE ARTS | 2016 | grade_7 | 32 | 2 | 85 | 1 | 2 | 0 | 3 | 50 | 75 | 125 | 32 | 2 | 85 | 1 | 2 | 0 | 3 | 50 | 75 | 125 | |||||||||||||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||||||||||||
835538 | 835538 | CO | school | 10 | MAPLETON 1 | 502 | MEADOW COMMUNITY SCHOOL | 2016 | grade_7 | 9 | 2 | 40 | 2 | 0 | 0 | 0 | 23 | 30 | 53 | 9 | 2 | 40 | 2 | 0 | 0 | 0 | 23 | 30 | 53 | |||||||||||||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||||||||||||
835614 | 835614 | CO | school | 805550 | 10 | MAPLETON 1 | 80555006488 | 1796 | COLORADO CONNECTIONS ACADEMY | Regular School | No | 4.0 | KG | 12 | 2016 | grade_7 | 171 | 9 | 48 | 2 | 5 | 0 | 14 | 124 | 125 | 249 | 171 | 9 | 48 | 2 | 5 | 0 | 14 | 124 | 125 | 249 | ||||||||||||||||||||||||||||||||||
835627 | 835627 | CO | school | 805550 | 10 | MAPLETON 1 | 80555000959 | 9036 | VALLEY VIEW K-8 | Regular School | No | 1.0 | KG | 08 | 2016 | grade_7 | 4 | 0 | 54 | 1 | 0 | 0 | 1 | 21 | 39 | 60 | 4 | 0 | 54 | 1 | 0 | 0 | 1 | 21 | 39 | 60 | ||||||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||||||||||||
841545 | 841545 | CO | school | 804080 | 1000 | FOUNTAIN 8 | 80408000561 | 1332 | CARSON MIDDLE SCHOOL | Regular School | No | 2.0 | 06 | 08 | 2016 | grade_7 | 92 | 43 | 57 | 2 | 3 | 5 | 25 | 101 | 126 | 227 | 92 | 43 | 57 | 2 | 3 | 5 | 25 | 101 | 126 | 227 | ||||||||||||||||||||||||||||||||||
841572 | 841572 | CO | school | 804080 | 1000 | FOUNTAIN 8 | 80408000563 | 3106 | FOUNTAIN MIDDLE SCHOOL | Regular School | No | 2.0 | 06 | 08 | 2016 | grade_7 | 150 | 28 | 70 | 5 | 7 | 3 | 27 | 151 | 139 | 290 | 150 | 28 | 70 | 5 | 7 | 3 | 27 | 151 | 139 | 290 | ||||||||||||||||||||||||||||||||||
841620 | 841620 | CO | school | 1010 | COLORADO SPRINGS 11 | 269 | ACHIEVE ONLINE | 2016 | grade_7 | 9 | 0 | 4 | 0 | 0 | 0 | 0 | 9 | 4 | 13 | 9 | 0 | 4 | 0 | 0 | 0 | 0 | 9 | 4 | 13 | |||||||||||||||||||||||||||||||||||||||||
841638 | 841638 | CO | school | 1010 | COLORADO SPRINGS 11 | 517 | ACADEMY FOR ADVANCED AND CREATIVE LEARNING | 2016 | grade_7 | 23 | 0 | 0 | 1 | 3 | 0 | 1 | 19 | 9 | 28 | 23 | 0 | 0 | 1 | 3 | 0 | 1 | 19 | 9 | 28 | |||||||||||||||||||||||||||||||||||||||||
841731 | 841731 | CO | school | 803060 | 1010 | COLORADO SPRINGS 11 | 80306000232 | 2528 | NIKOLA TESLA EDUCATION OPPORTUNITY CENTER | Alternative Education School | No | 4.0 | 06 | 12 | 2016 | grade_7 | 2 | 0 | 1 | 0 | 1 | 0 | 0 | 3 | 1 | 4 | 2 | 0 | 1 | 0 | 1 | 0 | 0 | 3 | 1 | 4 | ||||||||||||||||||||||||||||||||||
841751 | 841751 | CO | school | 803060 | 1010 | COLORADO SPRINGS 11 | 80306006379 | 3360 | GALILEO SCHOOL OF MATH AND SCIENCE | Regular School | No | 2.0 | 06 | 08 | 2016 | grade_7 | 83 | 24 | 57 | 2 | 1 | 0 | 11 | 81 | 97 | 178 | 83 | 24 | 57 | 2 | 1 | 0 | 11 | 81 | 97 | 178 | ||||||||||||||||||||||||||||||||||
841786 | 841786 | CO | school | 803060 | 1010 | COLORADO SPRINGS 11 | 80306000241 | 4070 | HOLMES MIDDLE SCHOOL | Regular School | No | 2.0 | 06 | 08 | 2016 | grade_7 | 170 | 12 | 47 | 1 | 11 | 0 | 15 | 129 | 127 | 256 | 170 | 12 | 47 | 1 | 11 | 0 | 15 | 129 | 127 | 256 | ||||||||||||||||||||||||||||||||||
841790 | 841790 | CO | school | 803060 | 1010 | COLORADO SPRINGS 11 | 80306000242 | 4090 | MANN MIDDLE SCHOOL | Regular School | No | 2.0 | 06 | 08 | 2016 | grade_7 | 74 | 11 | 33 | 3 | 0 | 1 | 7 | 65 | 64 | 129 | 74 | 11 | 33 | 3 | 0 | 1 | 7 | 65 | 64 | 129 | ||||||||||||||||||||||||||||||||||
841810 | 841810 | CO | school | 803060 | 1010 | COLORADO SPRINGS 11 | 80306001683 | 4424 | JENKINS MIDDLE SCHOOL | Regular School | No | 2.0 | 06 | 08 | 2016 | grade_7 | 230 | 23 | 57 | 0 | 6 | 2 | 19 | 170 | 167 | 337 | 230 | 23 | 57 | 0 | 6 | 2 | 19 | 170 | 167 | 337 | ||||||||||||||||||||||||||||||||||
841882 | 841882 | CO | school | 803060 | 1010 | COLORADO SPRINGS 11 | 80306000256 | 6306 | NORTH MIDDLE SCHOOL | Regular School | No | 2.0 | 06 | 08 | 2016 | grade_7 | 99 | 16 | 80 | 1 | 2 | 1 | 20 | 97 | 122 | 219 | 99 | 16 | 80 | 1 | 2 | 1 | 20 | 97 | 122 | 219 | ||||||||||||||||||||||||||||||||||
841921 | 841921 | CO | school | 803060 | 1010 | COLORADO SPRINGS 11 | 80306000263 | 7523 | RUSSELL MIDDLE SCHOOL | Regular School | No | 2.0 | 06 | 08 | 2016 | grade_7 | 126 | 16 | 61 | 1 | 4 | 1 | 15 | 107 | 117 | 224 | 126 | 16 | 61 | 1 | 4 | 1 | 15 | 107 | 117 | 224 | ||||||||||||||||||||||||||||||||||
841925 | 841925 | CO | school | 803060 | 1010 | COLORADO SPRINGS 11 | 80306000234 | 7556 | SABIN MIDDLE SCHOOL | Regular School | No | 2.0 | 06 | 08 | 2016 | grade_7 | 99 | 23 | 98 | 3 | 4 | 2 | 17 | 139 | 107 | 246 | 99 | 23 | 98 | 3 | 4 | 2 | 17 | 139 | 107 | 246 | ||||||||||||||||||||||||||||||||||
841952 | 841952 | CO | school | 803060 | 1010 | COLORADO SPRINGS 11 | 80306006421 | 8457 | JACK SWIGERT AEROSPACE ACADEMY | Regular School | No | 2.0 | 06 | 08 | 2016 | grade_7 | 44 | 18 | 91 | 4 | 2 | 0 | 13 | 94 | 78 | 172 | 44 | 18 | 91 | 4 | 2 | 0 | 13 | 94 | 78 | 172 | ||||||||||||||||||||||||||||||||||
841970 | 841970 | CO | school | 803060 | 1010 | COLORADO SPRINGS 11 | 80306000272 | 9404 | WEST MIDDLE SCHOOL | Regular School | No | 2.0 | 06 | 08 | 2016 | grade_7 | 43 | 4 | 26 | 0 | 2 | 1 | 3 | 44 | 35 | 79 | 43 | 4 | 26 | 0 | 2 | 1 | 3 | 44 | 35 | 79 | ||||||||||||||||||||||||||||||||||
842011 | 842011 | CO | school | 802940 | 1020 | CHEYENNE MOUNTAIN 12 | 80294000209 | 1588 | CHEYENNE MOUNTAIN JUNIOR HIGH SCHOOL | Regular School | No | 2.0 | 07 | 08 | 2016 | grade_7 | 229 | 6 | 36 | 2 | 6 | 0 | 15 | 166 | 128 | 294 | 229 | 6 | 36 | 2 | 6 | 0 | 15 | 166 | 128 | 294 | ||||||||||||||||||||||||||||||||||
842053 | 842053 | CO | school | 802940 | 1020 | CHEYENNE MOUNTAIN 12 | 80294006402 | 9051 | THE VANGUARD SCHOOL (MIDDLE) | Regular School | Yes | 2.0 | 07 | 08 | 2016 | grade_7 | 65 | 7 | 22 | 0 | 6 | 0 | 7 | 52 | 55 | 107 | 65 | 7 | 22 | 0 | 6 | 0 | 7 | 52 | 55 | 107 | ||||||||||||||||||||||||||||||||||
842070 | 842070 | CO | school | 805490 | 1030 | MANITOU SPRINGS 14 | 80549000945 | 5464 | MANITOU SPRINGS MIDDLE SCHOOL | Regular School | No | 2.0 | 06 | 08 | 2016 | grade_7 | 101 | 1 | 9 | 1 | 2 | 0 | 5 | 74 | 45 | 119 | 101 | 1 | 9 | 1 | 2 | 0 | 5 | 74 | 45 | 119 | ||||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||
842341 | 842341 | CO | school | 803750 | 1050 | ELLICOTT 22 | 80375001735 | 2640 | ELLICOTT MIDDLE SCHOOL | Regular School | No | 2.0 | 06 | 08 | 2016 | grade_7 | 51 | 3 | 35 | 0 | 0 | 0 | 1 | 55 | 35 | 90 | 51 | 3 | 35 | 0 | 0 | 0 | 1 | 55 | 35 | 90 | ||||||||||||||||||||||||||||||||||
842363 | 842363 | CO | school | 806060 | 1060 | PEYTON 23 JT | 80606001399 | 6900 | PEYTON JUNIOR HIGH SCHOOL | Regular School | No | 2.0 | 07 | 08 | 2016 | grade_7 | 46 | 0 | 5 | 1 | 3 | 0 | 2 | 35 | 22 | 57 | 46 | 0 | 5 | 1 | 3 | 0 | 2 | 35 | 22 | 57 | ||||||||||||||||||||||||||||||||||
842375 | 842375 | CO | school | 804500 | 1070 | HANOVER 28 | 80450000661 | 3758 | HANOVER JUNIOR-SENIOR HIGH SCHOOL | Regular School | No | 4.0 | 06 | 12 | 2016 | grade_7 | 18 | 0 | 5 | 0 | 0 | 0 | 0 | 14 | 9 | 23 | 18 | 0 | 5 | 0 | 0 | 0 | 0 | 14 | 9 | 23 | ||||||||||||||||||||||||||||||||||
842413 | 842413 | CO | school | 805820 | 1080 | LEWIS-PALMER 38 | 80582001536 | 5093 | MONUMENT CHARTER ACADEMY | Regular School | Yes | 1.0 | PK | 08 | 2016 | grade_7 | 84 | 1 | 8 | 1 | 0 | 0 | 3 | 56 | 41 | 97 | 84 | 1 | 8 | 1 | 0 | 0 | 3 | 56 | 41 | 97 | ||||||||||||||||||||||||||||||||||
842429 | 842429 | CO | school | 805820 | 1080 | LEWIS-PALMER 38 | 80582001002 | 5098 | LEWIS-PALMER MIDDLE SCHOOL | Regular School | No | 2.0 | 07 | 08 | 2016 | grade_7 | 333 | 3 | 39 | 2 | 13 | 1 | 21 | 218 | 194 | 412 | 333 | 3 | 39 | 2 | 13 | 1 | 21 | 218 | 194 | 412 | ||||||||||||||||||||||||||||||||||
836458 | 836458 | CO | school | 806420 | 110 | SANGRE DE CRISTO RE-22J | 80642001116 | 7630 | SANGRE DE CRISTO UNDIVIDED HIGH SCHOOL | Regular School | No | 4.0 | 06 | 12 | 2016 | grade_7 | 9 | 1 | 9 | 1 | 0 | 0 | 1 | 11 | 10 | 21 | 9 | 1 | 9 | 1 | 0 | 0 | 1 | 11 | 10 | 21 | ||||||||||||||||||||||||||||||||||
842467 | 842467 | CO | school | 1110 | FALCON 49 | 555 | BANNING LEWIS RANCH ACADEMY | 2016 | grade_7 | 59 | 3 | 14 | 0 | 3 | 0 | 5 | 36 | 48 | 84 | 59 | 3 | 14 | 0 | 3 | 0 | 5 | 36 | 48 | 84 | |||||||||||||||||||||||||||||||||||||||||
842488 | 842488 | CO | school | 803870 | 1110 | FALCON 49 | 80387006462 | 2877 | SPRINGS STUDIO FOR ACADEMIC EXCELLENCE | Regular School | No | 4.0 | KG | 12 | 2016 | grade_7 | 33 | 4 | 5 | 0 | 2 | 0 | 2 | 22 | 24 | 46 | 33 | 4 | 5 | 0 | 2 | 0 | 2 | 22 | 24 | 46 | ||||||||||||||||||||||||||||||||||
842502 | 842502 | CO | school | 803870 | 1110 | FALCON 49 | 80387000506 | 2906 | FALCON MIDDLE SCHOOL | Regular School | No | 2.0 | 06 | 08 | 2016 | grade_7 | 246 | 10 | 31 | 1 | 5 | 0 | 11 | 167 | 137 | 304 | 246 | 10 | 31 | 1 | 5 | 0 | 11 | 167 | 137 | 304 | ||||||||||||||||||||||||||||||||||
842516 | 842516 | CO | school | 803870 | 1110 | FALCON 49 | 80387001393 | 4102 | HORIZON MIDDLE SCHOOL | Regular School | No | 2.0 | 06 | 08 | 2016 | grade_7 | 118 | 17 | 57 | 0 | 5 | 1 | 13 | 103 | 108 | 211 | 118 | 17 | 57 | 0 | 5 | 1 | 13 | 103 | 108 | 211 | ||||||||||||||||||||||||||||||||||
842525 | 842525 | CO | school | 803870 | 1110 | FALCON 49 | 80387006386 | 4251 | IMAGINE INDIGO RANCH | Regular School | Yes | 1.0 | KG | 08 | 2016 | grade_7 | 25 | 2 | 19 | 1 | 2 | 0 | 4 | 18 | 35 | 53 | 25 | 2 | 19 | 1 | 2 | 0 | 4 | 18 | 35 | 53 | ||||||||||||||||||||||||||||||||||
842550 | 842550 | CO | school | 803870 | 1110 | FALCON 49 | 80387006403 | 6810 | PATRIOT LEARNING CENTER | Alternative Education School | No | 4.0 | 06 | 12 | 2016 | grade_7 | 2 | 1 | 2 | 0 | 0 | 0 | 0 | 3 | 2 | 5 | 2 | 1 | 2 | 0 | 0 | 0 | 0 | 3 | 2 | 5 | ||||||||||||||||||||||||||||||||||
842560 | 842560 | CO | school | 803870 | 1110 | FALCON 49 | 80387001844 | 6935 | PIKES PEAK SCHOOL EXPEDITIONARY LEARNING | Regular School | Yes | 1.0 | KG | 08 | 2016 | grade_7 | 39 | 3 | 6 | 1 | 0 | 0 | 0 | 31 | 18 | 49 | 39 | 3 | 6 | 1 | 0 | 0 | 0 | 31 | 18 | 49 | ||||||||||||||||||||||||||||||||||
842587 | 842587 | CO | school | 803870 | 1110 | FALCON 49 | 80387002000 | 7463 | ROCKY MOUNTAIN CLASSICAL ACADEMY | Regular School | Yes | 1.0 | KG | 08 | 2016 | grade_7 | 93 | 3 | 25 | 0 | 3 | 1 | 16 | 65 | 76 | 141 | 93 | 3 | 25 | 0 | 3 | 1 | 16 | 65 | 76 | 141 | ||||||||||||||||||||||||||||||||||
842598 | 842598 | CO | school | 803870 | 1110 | FALCON 49 | 80387001799 | 7960 | SKYVIEW MIDDLE SCHOOL | Regular School | No | 2.0 | 06 | 08 | 2016 | grade_7 | 229 | 32 | 79 | 1 | 10 | 3 | 19 | 195 | 178 | 373 | 229 | 32 | 79 | 1 | 10 | 3 | 19 | 195 | 178 | 373 | ||||||||||||||||||||||||||||||||||
842649 | 842649 | CO | school | 803630 | 1120 | EDISON 54 JT | 80363001278 | 2526 | EDISON JUNIOR-SENIOR HIGH SCHOOL | Regular School | No | 4.0 | 06 | 12 | 2016 | grade_7 | 10 | 0 | 1 | 0 | 0 | 0 | 0 | 8 | 3 | 11 | 10 | 0 | 1 | 0 | 0 | 0 | 0 | 8 | 3 | 11 | ||||||||||||||||||||||||||||||||||
842665 | 842665 | CO | school | 805670 | 1130 | MIAMI/YODER 60 JT | 80567000972 | 5854 | MIAMI-YODER MIDDLE/HIGH SCHOOL | Regular School | No | 4.0 | 06 | 12 | 2016 | grade_7 | 8 | 0 | 5 | 0 | 0 | 0 | 0 | 7 | 6 | 13 | 8 | 0 | 5 | 0 | 0 | 0 | 0 | 7 | 6 | 13 | ||||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||
842748 | 842748 | CO | school | 803960 | 1150 | FREMONT RE-2 | 80396001595 | 3226 | FREMONT MIDDLE SCHOOL | Regular School | No | 2.0 | 06 | 08 | 2016 | grade_7 | 78 | 0 | 19 | 0 | 0 | 0 | 5 | 54 | 48 | 102 | 78 | 0 | 19 | 0 | 0 | 0 | 5 | 54 | 48 | 102 | ||||||||||||||||||||||||||||||||||
842770 | 842770 | CO | school | 803120 | 1160 | COTOPAXI RE-3 | 80312000277 | 3228 | COTOPAXI JUNIOR-SENIOR HIGH SCHOOL | Regular School | No | 4.0 | 06 | 12 | 2016 | grade_7 | 12 | 0 | 1 | 0 | 0 | 0 | 0 | 8 | 5 | 13 | 12 | 0 | 1 | 0 | 0 | 0 | 0 | 8 | 5 | 13 | ||||||||||||||||||||||||||||||||||
842780 | 842780 | CO | school | 1180 | ROARING FORK RE-1 | 429 | CARBONDALE COMMUNITY CHARTER SCHOOL | 2016 | grade_7 | 13 | 0 | 2 | 0 | 0 | 0 | 0 | 9 | 6 | 15 | 13 | 0 | 2 | 0 | 0 | 0 | 0 | 9 | 6 | 15 | |||||||||||||||||||||||||||||||||||||||||
842794 | 842794 | CO | school | 1180 | ROARING FORK RE-1 | 561 | BASALT MIDDLE SCHOOL | 2016 | grade_7 | 60 | 0 | 71 | 0 | 3 | 0 | 1 | 55 | 80 | 135 | 60 | 0 | 71 | 0 | 3 | 0 | 1 | 55 | 80 | 135 | |||||||||||||||||||||||||||||||||||||||||
842809 | 842809 | CO | school | 804260 | 1180 | ROARING FORK RE-1 | 80426000586 | 1296 | CARBONDALE MIDDLE SCHOOL | Regular School | No | 2.0 | 05 | 08 | 2016 | grade_7 | 29 | 0 | 75 | 0 | 0 | 0 | 2 | 58 | 48 | 106 | 29 | 0 | 75 | 0 | 0 | 0 | 2 | 58 | 48 | 106 | ||||||||||||||||||||||||||||||||||
842830 | 842830 | CO | school | 804260 | 1180 | ROARING FORK RE-1 | 80426000587 | 3464 | GLENWOOD SPRINGS MIDDLE SCHOOL | Regular School | No | 2.0 | 06 | 08 | 2016 | grade_7 | 96 | 0 | 111 | 0 | 2 | 0 | 1 | 104 | 106 | 210 | 96 | 0 | 111 | 0 | 2 | 0 | 1 | 104 | 106 | 210 | ||||||||||||||||||||||||||||||||||
842891 | 842891 | CO | school | 806240 | 1195 | GARFIELD RE-2 | 80624001096 | 7356 | RIFLE MIDDLE SCHOOL | Regular School | No | 2.0 | 05 | 08 | 2016 | grade_7 | 88 | 0 | 106 | 0 | 0 | 0 | 7 | 101 | 100 | 201 | 88 | 0 | 106 | 0 | 0 | 0 | 7 | 101 | 100 | 201 | ||||||||||||||||||||||||||||||||||
842901 | 842901 | CO | school | 806240 | 1195 | GARFIELD RE-2 | 80624001098 | 7388 | RIVERSIDE SCHOOL | Regular School | No | 2.0 | 05 | 08 | 2016 | grade_7 | 95 | 0 | 66 | 0 | 1 | 1 | 4 | 92 | 75 | 167 | 95 | 0 | 66 | 0 | 1 | 1 | 4 | 92 | 75 | 167 | ||||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||
842935 | 842935 | CO | school | 804380 | 1220 | GARFIELD 16 | 80438001368 | 8274 | GRAND VALLEY MIDDLE SCHOOL | Regular School | No | 2.0 | 06 | 08 | 2016 | grade_7 | 55 | 1 | 30 | 1 | 0 | 0 | 4 | 53 | 38 | 91 | 55 | 1 | 30 | 1 | 0 | 0 | 4 | 53 | 38 | 91 | ||||||||||||||||||||||||||||||||||
836521 | 836521 | CO | school | 806540 | 123 | SHERIDAN 2 | 80654001135 | 7837 | FORT LOGAN NORTHGATE | Regular School | No | 1.0 | 03 | 08 | 2016 | grade_7 | 14 | 5 | 76 | 2 | 2 | 0 | 2 | 56 | 45 | 101 | 14 | 5 | 76 | 2 | 2 | 0 | 2 | 56 | 45 | 101 | ||||||||||||||||||||||||||||||||||
836545 | 836545 | CO | school | 130 | CHERRY CREEK 5 | 18 | LIBERTY MIDDLE SCHOOL | 2016 | grade_7 | 208 | 27 | 58 | 1 | 52 | 1 | 24 | 173 | 198 | 371 | 208 | 27 | 58 | 1 | 52 | 1 | 24 | 173 | 198 | 371 | |||||||||||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||
836620 | 836620 | CO | school | 802910 | 130 | CHERRY CREEK 5 | 80291000185 | 1566 | CAMPUS MIDDLE SCHOOL | Regular School | No | 2.0 | 06 | 08 | 2016 | grade_7 | 305 | 14 | 65 | 1 | 62 | 0 | 22 | 233 | 236 | 469 | 305 | 14 | 65 | 1 | 62 | 0 | 22 | 233 | 236 | 469 | ||||||||||||||||||||||||||||||||||
836624 | 836624 | CO | school | 802910 | 130 | CHERRY CREEK 5 | 80291000207 | 1568 | WEST MIDDLE SCHOOL | Regular School | No | 2.0 | 06 | 08 | 2016 | grade_7 | 281 | 7 | 55 | 3 | 29 | 0 | 18 | 183 | 210 | 393 | 281 | 7 | 55 | 3 | 29 | 0 | 18 | 183 | 210 | 393 | ||||||||||||||||||||||||||||||||||
836638 | 836638 | CO | school | 802910 | 130 | CHERRY CREEK 5 | 80291001152 | 1571 | CHERRY CREEK CHARTER ACADEMY | Regular School | Yes | 1.0 | KG | 08 | 2016 | grade_7 | 46 | 6 | 2 | 1 | 19 | 0 | 4 | 40 | 38 | 78 | 46 | 6 | 2 | 1 | 19 | 0 | 4 | 40 | 38 | 78 | ||||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||
836764 | 836764 | CO | school | 802910 | 130 | CHERRY CREEK 5 | 80291001328 | 4100 | HORIZON MIDDLE SCHOOL | Regular School | No | 2.0 | 06 | 08 | 2016 | grade_7 | 131 | 59 | 78 | 5 | 16 | 0 | 32 | 174 | 147 | 321 | 131 | 59 | 78 | 5 | 16 | 0 | 32 | 174 | 147 | 321 | ||||||||||||||||||||||||||||||||||
836793 | 836793 | CO | school | 802910 | 130 | CHERRY CREEK 5 | 80291000197 | 4975 | LAREDO MIDDLE SCHOOL | Regular School | No | 2.0 | 06 | 08 | 2016 | grade_7 | 190 | 68 | 87 | 2 | 27 | 4 | 23 | 206 | 195 | 401 | 190 | 68 | 87 | 2 | 27 | 4 | 23 | 206 | 195 | 401 | ||||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||
836875 | 836875 | CO | school | 802910 | 130 | CHERRY CREEK 5 | 80291000201 | 7158 | PRAIRIE MIDDLE SCHOOL | Regular School | No | 2.0 | 06 | 08 | 2016 | grade_7 | 130 | 144 | 240 | 8 | 34 | 2 | 42 | 308 | 292 | 600 | 130 | 144 | 240 | 8 | 34 | 2 | 42 | 308 | 292 | 600 | ||||||||||||||||||||||||||||||||||
836923 | 836923 | CO | school | 802910 | 130 | CHERRY CREEK 5 | 80291000034 | 8848 | THUNDER RIDGE MIDDLE SCHOOL | Regular School | No | 2.0 | 06 | 08 | 2016 | grade_7 | 268 | 35 | 77 | 2 | 16 | 3 | 36 | 209 | 228 | 437 | 268 | 35 | 77 | 2 | 16 | 3 | 36 | 209 | 228 | 437 | ||||||||||||||||||||||||||||||||||
842950 | 842950 | CO | school | 804230 | 1330 | GILPIN COUNTY RE-1 | 80423001298 | 1634 | GILPIN COUNTY UNDIVIDED HIGH SCHOOL | Regular School | No | 4.0 | 06 | 12 | 2016 | grade_7 | 25 | 0 | 2 | 0 | 1 | 0 | 1 | 18 | 11 | 29 | 25 | 0 | 2 | 0 | 1 | 0 | 1 | 18 | 11 | 29 | ||||||||||||||||||||||||||||||||||
842965 | 842965 | CO | school | 805070 | 1340 | WEST GRAND 1-JT | 80507000829 | 9422 | WEST GRAND ELEMENTARY AND MIDDLE SCHOOL | Regular School | No | 1.0 | KG | 08 | 2016 | grade_7 | 21 | 0 | 10 | 0 | 0 | 0 | 2 | 20 | 13 | 33 | 21 | 0 | 10 | 0 | 0 | 0 | 2 | 20 | 13 | 33 | ||||||||||||||||||||||||||||||||||
842970 | 842970 | CO | school | 804320 | 1350 | EAST GRAND 2 | 80432001343 | 2376 | EAST GRAND MIDDLE SCHOOL | Regular School | No | 2.0 | 06 | 08 | 2016 | grade_7 | 89 | 0 | 16 | 1 | 0 | 0 | 1 | 58 | 49 | 107 | 89 | 0 | 16 | 1 | 0 | 0 | 1 | 58 | 49 | 107 | ||||||||||||||||||||||||||||||||||
842995 | 842995 | CO | school | 804320 | 1350 | EAST GRAND 2 | 80432001780 | 4277 | INDIAN PEAKS CHARTER SCHOOL | Regular School | Yes | 1.0 | KG | 08 | 2016 | grade_7 | 5 | 0 | 0 | 0 | 0 | 0 | 0 | 3 | 2 | 5 | 5 | 0 | 0 | 0 | 0 | 0 | 0 | 3 | 2 | 5 | ||||||||||||||||||||||||||||||||||
843015 | 843015 | CO | school | 804470 | 1360 | GUNNISON WATERSHED RE1J | 80447000655 | 2006 | CRESTED BUTTE SECONDARY SCHOOL | Regular School | No | 4.0 | 06 | 12 | 2016 | grade_7 | 53 | 0 | 3 | 0 | 0 | 0 | 0 | 31 | 25 | 56 | 53 | 0 | 3 | 0 | 0 | 0 | 0 | 31 | 25 | 56 | ||||||||||||||||||||||||||||||||||
843032 | 843032 | CO | school | 804470 | 1360 | GUNNISON WATERSHED RE1J | 80447001600 | 3697 | GUNNISON MIDDLE SCHOOL | Regular School | No | 2.0 | 06 | 08 | 2016 | grade_7 | 69 | 1 | 15 | 0 | 1 | 0 | 1 | 37 | 50 | 87 | 69 | 1 | 15 | 0 | 1 | 0 | 1 | 37 | 50 | 87 | ||||||||||||||||||||||||||||||||||
843043 | 843043 | CO | school | 804470 | 1360 | GUNNISON WATERSHED RE1J | 80447001507 | 5577 | MARBLE CHARTER SCHOOL | Regular School | Yes | 4.0 | KG | 10 | 2016 | grade_7 | 5 | 0 | 0 | 0 | 0 | 0 | 1 | 1 | 5 | 6 | 5 | 0 | 0 | 0 | 0 | 0 | 1 | 1 | 5 | 6 | ||||||||||||||||||||||||||||||||||
843056 | 843056 | CO | school | 804620 | 1380 | HINSDALE COUNTY RE 1 | 80462001969 | 4899 | LAKE CITY COMMUNITY SCHOOL | Regular School | No | 4.0 | PK | 12 | 2016 | grade_7 | 6 | 0 | 0 | 0 | 0 | 0 | 0 | 2 | 4 | 6 | 6 | 0 | 0 | 0 | 0 | 0 | 0 | 2 | 4 | 6 | ||||||||||||||||||||||||||||||||||
843068 | 843068 | CO | school | 1390 | HUERFANO RE-1 | 63 | PEAKVIEW SCHOOL | 2016 | grade_7 | 9 | 2 | 27 | 2 | 1 | 0 | 0 | 26 | 15 | 41 | 9 | 2 | 27 | 2 | 1 | 0 | 0 | 26 | 15 | 41 | |||||||||||||||||||||||||||||||||||||||||
843079 | 843079 | CO | school | 807080 | 1390 | HUERFANO RE-1 | 80708001211 | 3306 | GARDNER ELEMENTARY SCHOOL | Regular School | No | 1.0 | PK | 08 | 2016 | grade_7 | 4 | 0 | 11 | 0 | 0 | 0 | 0 | 8 | 7 | 15 | 4 | 0 | 11 | 0 | 0 | 0 | 0 | 8 | 7 | 15 | ||||||||||||||||||||||||||||||||||
836991 | 836991 | CO | school | 805310 | 140 | LITTLETON 6 | 80531000876 | 2804 | EUCLID MIDDLE SCHOOL | Regular School | No | 2.0 | 06 | 08 | 2016 | grade_7 | 160 | 1 | 54 | 1 | 4 | 0 | 8 | 115 | 113 | 228 | 160 | 1 | 54 | 1 | 4 | 0 | 8 | 115 | 113 | 228 | ||||||||||||||||||||||||||||||||||
837002 | 837002 | CO | school | 805310 | 140 | LITTLETON 6 | 80531000879 | 3472 | GODDARD MIDDLE SCHOOL | Regular School | No | 2.0 | 06 | 08 | 2016 | grade_7 | 156 | 3 | 95 | 2 | 7 | 0 | 10 | 138 | 135 | 273 | 156 | 3 | 95 | 2 | 7 | 0 | 10 | 138 | 135 | 273 | ||||||||||||||||||||||||||||||||||
837019 | 837019 | CO | school | 805310 | 140 | LITTLETON 6 | 80531000885 | 4316 | NEWTON MIDDLE SCHOOL | Regular School | No | 2.0 | 06 | 08 | 2016 | grade_7 | 152 | 3 | 21 | 1 | 14 | 0 | 3 | 102 | 92 | 194 | 152 | 3 | 21 | 1 | 14 | 0 | 3 | 102 | 92 | 194 | ||||||||||||||||||||||||||||||||||
837023 | 837023 | CO | school | 805310 | 140 | LITTLETON 6 | 80531001351 | 4447 | JOHN WESLEY POWELL MIDDLE SCHOOL | Regular School | No | 2.0 | 06 | 08 | 2016 | grade_7 | 273 | 5 | 33 | 1 | 7 | 0 | 13 | 169 | 163 | 332 | 273 | 5 | 33 | 1 | 7 | 0 | 13 | 169 | 163 | 332 | ||||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||
843101 | 843101 | CO | school | 805160 | 1400 | LA VETA RE-2 | 80516000854 | 4864 | LA VETA JUNIOR-SENIOR HIGH SCHOOL | Regular School | No | 4.0 | 06 | 12 | 2016 | grade_7 | 18 | 0 | 6 | 0 | 0 | 0 | 0 | 10 | 14 | 24 | 18 | 0 | 6 | 0 | 0 | 0 | 0 | 10 | 14 | 24 |
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]);