enrollments
Data source: Big Local News · About: Big Local
585 rows where grade = "grade_8", state = "CO" and year = 2016 sorted by native_hawaiian_pacific_islander_int
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
835493 | 835493 | CO | school | 10 | MAPLETON 1 | 187 | MAPLETON EXPEDITIONARY SCHOOL OF THE ARTS | 2016 | grade_8 | 32 | 2 | 88 | 0 | 1 | 0 | 2 | 64 | 61 | 125 | 32 | 2 | 88 | 0 | 1 | 0 | 2 | 64 | 61 | 125 | |||||||||||||||||||||||||||||||||||||||||
835511 | 835511 | CO | school | 10 | MAPLETON 1 | 263 | GLOBAL LEADERSHIP ACADEMY | 2016 | grade_8 | 3 | 0 | 55 | 0 | 1 | 0 | 0 | 26 | 33 | 59 | 3 | 0 | 55 | 0 | 1 | 0 | 0 | 26 | 33 | 59 | |||||||||||||||||||||||||||||||||||||||||
835528 | 835528 | CO | school | 10 | MAPLETON 1 | 501 | MONTEREY COMMUNITY SCHOOL | 2016 | grade_8 | 11 | 2 | 36 | 1 | 0 | 0 | 0 | 31 | 19 | 50 | 11 | 2 | 36 | 1 | 0 | 0 | 0 | 31 | 19 | 50 | |||||||||||||||||||||||||||||||||||||||||
835539 | 835539 | CO | school | 10 | MAPLETON 1 | 502 | MEADOW COMMUNITY SCHOOL | 2016 | grade_8 | 10 | 2 | 36 | 0 | 1 | 0 | 0 | 25 | 24 | 49 | 10 | 2 | 36 | 0 | 1 | 0 | 0 | 25 | 24 | 49 | |||||||||||||||||||||||||||||||||||||||||
835553 | 835553 | CO | school | 10 | MAPLETON 1 | 503 | YORK INTERNATIONAL | 2016 | grade_8 | 7 | 0 | 52 | 0 | 1 | 0 | 3 | 30 | 33 | 63 | 7 | 0 | 52 | 0 | 1 | 0 | 3 | 30 | 33 | 63 | |||||||||||||||||||||||||||||||||||||||||
835602 | 835602 | CO | school | 10 | MAPLETON 1 | 509 | CLAYTON PARTNERSHIP SCHOOL | 2016 | grade_8 | 8 | 3 | 42 | 1 | 0 | 0 | 4 | 26 | 32 | 58 | 8 | 3 | 42 | 1 | 0 | 0 | 4 | 26 | 32 | 58 | |||||||||||||||||||||||||||||||||||||||||
835615 | 835615 | CO | school | 805550 | 10 | MAPLETON 1 | 80555006488 | 1796 | COLORADO CONNECTIONS ACADEMY | Regular School | No | 4.0 | KG | 12 | 2016 | grade_8 | 196 | 7 | 73 | 3 | 5 | 0 | 20 | 149 | 155 | 304 | 196 | 7 | 73 | 3 | 5 | 0 | 20 | 149 | 155 | 304 | ||||||||||||||||||||||||||||||||||
835628 | 835628 | CO | school | 805550 | 10 | MAPLETON 1 | 80555000959 | 9036 | VALLEY VIEW K-8 | Regular School | No | 1.0 | KG | 08 | 2016 | grade_8 | 6 | 0 | 38 | 2 | 1 | 0 | 1 | 28 | 20 | 48 | 6 | 0 | 38 | 2 | 1 | 0 | 1 | 28 | 20 | 48 | ||||||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||
836105 | 836105 | CO | school | 802580 | 40 | SCHOOL DISTRICT 27J | 80258000729 | 1021 | BRIGHTON HERITAGE ACADEMY | Alternative Education School | No | 4.0 | 06 | 12 | 2016 | grade_8 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | ||||||||||||||||||||||||||||||||||
836120 | 836120 | CO | school | 802580 | 40 | SCHOOL DISTRICT 27J | 80258001729 | 1052 | BROMLEY EAST CHARTER SCHOOL | Regular School | Yes | 1.0 | PK | 08 | 2016 | grade_8 | 65 | 0 | 33 | 0 | 4 | 0 | 6 | 55 | 53 | 108 | 65 | 0 | 33 | 0 | 4 | 0 | 6 | 55 | 53 | 108 | ||||||||||||||||||||||||||||||||||
836141 | 836141 | CO | school | 802580 | 40 | SCHOOL DISTRICT 27J | 80258006465 | 2945 | FOUNDATIONS ACADEMY | Regular School | Yes | 1.0 | KG | 08 | 2016 | grade_8 | 53 | 0 | 20 | 0 | 1 | 0 | 1 | 38 | 37 | 75 | 53 | 0 | 20 | 0 | 1 | 0 | 1 | 38 | 37 | 75 | ||||||||||||||||||||||||||||||||||
836161 | 836161 | CO | school | 802580 | 40 | SCHOOL DISTRICT 27J | 80258006325 | 4950 | LANDMARK ACADEMY AT REUNION | Regular School | Yes | 1.0 | KG | 08 | 2016 | grade_8 | 51 | 6 | 21 | 0 | 2 | 0 | 3 | 43 | 40 | 83 | 51 | 6 | 21 | 0 | 2 | 0 | 3 | 43 | 40 | 83 | ||||||||||||||||||||||||||||||||||
836192 | 836192 | CO | school | 802580 | 40 | SCHOOL DISTRICT 27J | 80258001377 | 6638 | OVERLAND TRAIL MIDDLE SCHOOL | Regular School | No | 2.0 | 06 | 08 | 2016 | grade_8 | 63 | 1 | 132 | 2 | 3 | 0 | 4 | 116 | 89 | 205 | 63 | 1 | 132 | 2 | 3 | 0 | 4 | 116 | 89 | 205 | ||||||||||||||||||||||||||||||||||
836196 | 836196 | CO | school | 802580 | 40 | SCHOOL DISTRICT 27J | 80258006420 | 6702 | OTHO E STUART MIDDLE SCHOOL | Regular School | No | 2.0 | 06 | 08 | 2016 | grade_8 | 106 | 7 | 90 | 1 | 11 | 0 | 11 | 134 | 92 | 226 | 106 | 7 | 90 | 1 | 11 | 0 | 11 | 134 | 92 | 226 | ||||||||||||||||||||||||||||||||||
836205 | 836205 | CO | school | 802580 | 40 | SCHOOL DISTRICT 27J | 80258006362 | 7131 | PRAIRIE VIEW MIDDLE SCHOOL | Regular School | No | 2.0 | 06 | 08 | 2016 | grade_8 | 123 | 4 | 120 | 2 | 16 | 0 | 7 | 149 | 123 | 272 | 123 | 4 | 120 | 2 | 16 | 0 | 7 | 149 | 123 | 272 | ||||||||||||||||||||||||||||||||||
836252 | 836252 | CO | school | 802580 | 40 | SCHOOL DISTRICT 27J | 80258000152 | 9230 | VIKAN MIDDLE SCHOOL | Regular School | No | 2.0 | 06 | 08 | 2016 | grade_8 | 67 | 2 | 123 | 3 | 1 | 0 | 5 | 108 | 93 | 201 | 67 | 2 | 123 | 3 | 1 | 0 | 5 | 108 | 93 | 201 | ||||||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||||||||||||
836294 | 836294 | CO | school | 806750 | 60 | STRASBURG 31J | 80675001160 | 8332 | HEMPHILL MIDDLE SCHOOL | Regular School | No | 2.0 | 06 | 08 | 2016 | grade_8 | 75 | 2 | 10 | 1 | 0 | 0 | 1 | 51 | 38 | 89 | 75 | 2 | 10 | 1 | 0 | 0 | 1 | 51 | 38 | 89 | ||||||||||||||||||||||||||||||||||
836344 | 836344 | CO | school | 807230 | 70 | WESTMINSTER PUBLIC SCHOOLS | 80723006567 | 4334 | COLORADO STEM ACADEMY | Regular School | No | 1.0 | 03 | 08 | 2016 | grade_8 | 16 | 0 | 22 | 0 | 3 | 0 | 1 | 28 | 14 | 42 | 16 | 0 | 22 | 0 | 3 | 0 | 1 | 28 | 14 | 42 | ||||||||||||||||||||||||||||||||||
836356 | 836356 | CO | school | 807230 | 70 | WESTMINSTER PUBLIC SCHOOLS | 80723001241 | 5388 | M. SCOTT CARPENTER MIDDLE SCHOOL | Regular School | No | 2.0 | 06 | 08 | 2016 | grade_8 | 14 | 1 | 140 | 0 | 4 | 0 | 2 | 92 | 69 | 161 | 14 | 1 | 140 | 0 | 4 | 0 | 2 | 92 | 69 | 161 | ||||||||||||||||||||||||||||||||||
836367 | 836367 | CO | school | 807230 | 70 | WESTMINSTER PUBLIC SCHOOLS | 80723006458 | 7305 | IVER C. RANUM MIDDLE SCHOOL | Regular School | No | 2.0 | 06 | 08 | 2016 | grade_8 | 24 | 2 | 198 | 0 | 9 | 0 | 8 | 122 | 119 | 241 | 24 | 2 | 198 | 0 | 9 | 0 | 8 | 122 | 119 | 241 | ||||||||||||||||||||||||||||||||||
836379 | 836379 | CO | school | 807230 | 70 | WESTMINSTER PUBLIC SCHOOLS | 80723001244 | 7812 | SHAW HEIGHTS MIDDLE SCHOOL | Regular School | No | 2.0 | 06 | 08 | 2016 | grade_8 | 47 | 2 | 133 | 2 | 7 | 0 | 4 | 101 | 94 | 195 | 47 | 2 | 133 | 2 | 7 | 0 | 4 | 101 | 94 | 195 | ||||||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||||||||||||
836459 | 836459 | 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_8 | 13 | 0 | 9 | 2 | 0 | 0 | 0 | 9 | 15 | 24 | 13 | 0 | 9 | 2 | 0 | 0 | 0 | 9 | 15 | 24 | ||||||||||||||||||||||||||||||||||
836498 | 836498 | CO | school | 803780 | 120 | ENGLEWOOD 1 | 80378001772 | 2750 | ENGLEWOOD LEADERSHIP ACADEMY | Regular School | No | 2.0 | 06 | 09 | 2016 | grade_8 | 10 | 0 | 6 | 0 | 0 | 0 | 0 | 8 | 8 | 16 | 10 | 0 | 6 | 0 | 0 | 0 | 0 | 8 | 8 | 16 | ||||||||||||||||||||||||||||||||||
836501 | 836501 | CO | school | 803780 | 120 | ENGLEWOOD 1 | 80378006331 | 2752 | ENGLEWOOD MIDDLE SCHOOL | Regular School | No | 2.0 | 07 | 08 | 2016 | grade_8 | 70 | 4 | 64 | 1 | 0 | 0 | 5 | 77 | 67 | 144 | 70 | 4 | 64 | 1 | 0 | 0 | 5 | 77 | 67 | 144 | ||||||||||||||||||||||||||||||||||
836522 | 836522 | CO | school | 806540 | 123 | SHERIDAN 2 | 80654001135 | 7837 | FORT LOGAN NORTHGATE | Regular School | No | 1.0 | 03 | 08 | 2016 | grade_8 | 10 | 6 | 91 | 3 | 6 | 0 | 3 | 58 | 61 | 119 | 10 | 6 | 91 | 3 | 6 | 0 | 3 | 58 | 61 | 119 | ||||||||||||||||||||||||||||||||||
836546 | 836546 | CO | school | 130 | CHERRY CREEK 5 | 18 | LIBERTY MIDDLE SCHOOL | 2016 | grade_8 | 214 | 28 | 75 | 0 | 37 | 0 | 22 | 187 | 189 | 376 | 214 | 28 | 75 | 0 | 37 | 0 | 22 | 187 | 189 | 376 | |||||||||||||||||||||||||||||||||||||||||
836550 | 836550 | CO | school | 130 | CHERRY CREEK 5 | 141 | SKY VISTA MIDDLE SCHOOL | 2016 | grade_8 | 169 | 36 | 44 | 0 | 19 | 0 | 21 | 162 | 127 | 289 | 169 | 36 | 44 | 0 | 19 | 0 | 21 | 162 | 127 | 289 | |||||||||||||||||||||||||||||||||||||||||
836611 | 836611 | CO | school | 802910 | 130 | CHERRY CREEK 5 | 80291000763 | 1510 | CHALLENGE SCHOOL | Regular School | No | 1.0 | PK | 08 | 2016 | grade_8 | 39 | 2 | 9 | 0 | 18 | 0 | 2 | 36 | 34 | 70 | 39 | 2 | 9 | 0 | 18 | 0 | 2 | 36 | 34 | 70 | ||||||||||||||||||||||||||||||||||
836625 | 836625 | CO | school | 802910 | 130 | CHERRY CREEK 5 | 80291000207 | 1568 | WEST MIDDLE SCHOOL | Regular School | No | 2.0 | 06 | 08 | 2016 | grade_8 | 325 | 9 | 50 | 1 | 26 | 0 | 14 | 221 | 204 | 425 | 325 | 9 | 50 | 1 | 26 | 0 | 14 | 221 | 204 | 425 | ||||||||||||||||||||||||||||||||||
836639 | 836639 | CO | school | 802910 | 130 | CHERRY CREEK 5 | 80291001152 | 1571 | CHERRY CREEK CHARTER ACADEMY | Regular School | Yes | 1.0 | KG | 08 | 2016 | grade_8 | 24 | 3 | 8 | 0 | 11 | 0 | 3 | 18 | 31 | 49 | 24 | 3 | 8 | 0 | 11 | 0 | 3 | 18 | 31 | 49 | ||||||||||||||||||||||||||||||||||
836718 | 836718 | CO | school | 802910 | 130 | CHERRY CREEK 5 | 80291006367 | 3030 | FOX RIDGE MIDDLE SCHOOL | Regular School | No | 2.0 | 06 | 08 | 2016 | grade_8 | 296 | 29 | 47 | 0 | 32 | 0 | 20 | 219 | 205 | 424 | 296 | 29 | 47 | 0 | 32 | 0 | 20 | 219 | 205 | 424 | ||||||||||||||||||||||||||||||||||
836765 | 836765 | CO | school | 802910 | 130 | CHERRY CREEK 5 | 80291001328 | 4100 | HORIZON MIDDLE SCHOOL | Regular School | No | 2.0 | 06 | 08 | 2016 | grade_8 | 144 | 73 | 86 | 4 | 18 | 0 | 16 | 176 | 165 | 341 | 144 | 73 | 86 | 4 | 18 | 0 | 16 | 176 | 165 | 341 | ||||||||||||||||||||||||||||||||||
836794 | 836794 | CO | school | 802910 | 130 | CHERRY CREEK 5 | 80291000197 | 4975 | LAREDO MIDDLE SCHOOL | Regular School | No | 2.0 | 06 | 08 | 2016 | grade_8 | 184 | 71 | 95 | 3 | 26 | 0 | 18 | 218 | 179 | 397 | 184 | 71 | 95 | 3 | 26 | 0 | 18 | 218 | 179 | 397 | ||||||||||||||||||||||||||||||||||
836830 | 836830 | CO | school | 802910 | 130 | CHERRY CREEK 5 | 80291006563 | 6367 | OPTIONS SCHOOL | Alternative Education School | No | 4.0 | KG | 12 | 2016 | grade_8 | 38 | 2 | 5 | 0 | 0 | 0 | 3 | 29 | 19 | 48 | 38 | 2 | 5 | 0 | 0 | 0 | 3 | 29 | 19 | 48 | ||||||||||||||||||||||||||||||||||
837020 | 837020 | CO | school | 805310 | 140 | LITTLETON 6 | 80531000885 | 4316 | NEWTON MIDDLE SCHOOL | Regular School | No | 2.0 | 06 | 08 | 2016 | grade_8 | 176 | 3 | 20 | 1 | 7 | 0 | 15 | 105 | 117 | 222 | 176 | 3 | 20 | 1 | 7 | 0 | 15 | 105 | 117 | 222 | ||||||||||||||||||||||||||||||||||
837024 | 837024 | CO | school | 805310 | 140 | LITTLETON 6 | 80531001351 | 4447 | JOHN WESLEY POWELL MIDDLE SCHOOL | Regular School | No | 2.0 | 06 | 08 | 2016 | grade_8 | 252 | 2 | 32 | 2 | 15 | 0 | 15 | 160 | 158 | 318 | 252 | 2 | 32 | 2 | 15 | 0 | 15 | 160 | 158 | 318 | ||||||||||||||||||||||||||||||||||
837038 | 837038 | CO | school | 805310 | 140 | LITTLETON 6 | 80531001515 | 5229 | LITTLETON ACADEMY | Regular School | Yes | 1.0 | KG | 08 | 2016 | grade_8 | 37 | 0 | 3 | 0 | 7 | 0 | 3 | 25 | 25 | 50 | 37 | 0 | 3 | 0 | 7 | 0 | 3 | 25 | 25 | 50 | ||||||||||||||||||||||||||||||||||
837048 | 837048 | CO | school | 805310 | 140 | LITTLETON 6 | 80531001626 | 5233 | LITTLETON PREP CHARTER SCHOOL | Regular School | Yes | 1.0 | PK | 08 | 2016 | grade_8 | 34 | 0 | 15 | 1 | 1 | 0 | 5 | 25 | 31 | 56 | 34 | 0 | 15 | 1 | 1 | 0 | 5 | 25 | 31 | 56 | ||||||||||||||||||||||||||||||||||
837127 | 837127 | CO | school | 803270 | 170 | DEER TRAIL 26J | 80327000288 | 2140 | DEER TRAIL JUNIOR-SENIOR HIGH SCHOOL | Regular School | No | 4.0 | 06 | 12 | 2016 | grade_8 | 13 | 0 | 1 | 0 | 0 | 0 | 0 | 5 | 9 | 14 | 13 | 0 | 1 | 0 | 0 | 0 | 0 | 5 | 9 | 14 | ||||||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||
837683 | 837683 | CO | school | 807110 | 230 | WALSH RE-1 | 80711001216 | 9226 | WALSH HIGH SCHOOL | Regular School | No | 3.0 | 07 | 12 | 2016 | grade_8 | 7 | 0 | 1 | 0 | 0 | 0 | 0 | 6 | 2 | 8 | 7 | 0 | 1 | 0 | 0 | 0 | 0 | 6 | 2 | 8 | ||||||||||||||||||||||||||||||||||
837696 | 837696 | CO | school | 806090 | 240 | PRITCHETT RE-3 | 80609001952 | 7176 | PRITCHETT MIDDLE SCHOOL | Regular School | No | 2.0 | 06 | 08 | 2016 | grade_8 | 8 | 0 | 0 | 0 | 0 | 0 | 0 | 5 | 3 | 8 | 8 | 0 | 0 | 0 | 0 | 0 | 0 | 5 | 3 | 8 | ||||||||||||||||||||||||||||||||||
837716 | 837716 | CO | school | 806630 | 250 | SPRINGFIELD RE-4 | 80663001142 | 8168 | SPRINGFIELD JUNIOR/SENIOR HIGH SCHOOL | Regular School | No | 3.0 | 07 | 12 | 2016 | grade_8 | 11 | 0 | 2 | 0 | 0 | 0 | 0 | 6 | 7 | 13 | 11 | 0 | 2 | 0 | 0 | 0 | 0 | 6 | 7 | 13 | ||||||||||||||||||||||||||||||||||
837726 | 837726 | CO | school | 806990 | 260 | VILAS RE-5 | 80699001805 | 9085 | V.I.L.A.S. ONLINE SCHOOL | Regular School | No | 1.0 | KG | 08 | 2016 | grade_8 | 4 | 0 | 0 | 0 | 0 | 0 | 0 | 3 | 1 | 4 | 4 | 0 | 0 | 0 | 0 | 0 | 0 | 3 | 1 | 4 | ||||||||||||||||||||||||||||||||||
837741 | 837741 | CO | school | 806990 | 260 | VILAS RE-5 | 80699001207 | 9100 | VILAS UNDIVIDED HIGH SCHOOL | Regular School | No | 3.0 | 07 | 12 | 2016 | grade_8 | 2 | 0 | 2 | 0 | 0 | 0 | 0 | 3 | 1 | 4 | 2 | 0 | 2 | 0 | 0 | 0 | 0 | 3 | 1 | 4 | ||||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||
837770 | 837770 | CO | school | 805250 | 290 | LAS ANIMAS RE-1 | 80525000867 | 4986 | LAS ANIMAS JUNIOR HIGH SCHOOL | Regular School | No | 2.0 | 07 | 08 | 2016 | grade_8 | 13 | 0 | 23 | 0 | 0 | 0 | 1 | 20 | 17 | 37 | 13 | 0 | 23 | 0 | 0 | 0 | 1 | 20 | 17 | 37 | ||||||||||||||||||||||||||||||||||
837790 | 837790 | CO | school | 805580 | 310 | MC CLAVE RE-2 | 80558000963 | 5670 | MC CLAVE UNDIVIDED HIGH SCHOOL | Regular School | No | 3.0 | 07 | 12 | 2016 | grade_8 | 21 | 0 | 0 | 0 | 0 | 0 | 0 | 8 | 13 | 21 | 21 | 0 | 0 | 0 | 0 | 0 | 0 | 8 | 13 | 21 | ||||||||||||||||||||||||||||||||||
837829 | 837829 | CO | school | 470 | ST VRAIN VALLEY RE 1J | 120 | APEX HOME SCHOOL ENRICHMENT PROGRAM | 2016 | grade_8 | 46 | 0 | 4 | 0 | 1 | 0 | 3 | 24 | 30 | 54 | 46 | 0 | 4 | 0 | 1 | 0 | 3 | 24 | 30 | 54 | |||||||||||||||||||||||||||||||||||||||||
837835 | 837835 | CO | school | 470 | ST VRAIN VALLEY RE 1J | 226 | ALTONA MIDDLE SCHOOL | 2016 | grade_8 | 200 | 2 | 39 | 1 | 28 | 0 | 5 | 138 | 137 | 275 | 200 | 2 | 39 | 1 | 28 | 0 | 5 | 138 | 137 | 275 | |||||||||||||||||||||||||||||||||||||||||
837879 | 837879 | CO | school | 805370 | 470 | ST VRAIN VALLEY RE 1J | 80537001887 | 1284 | CARBON VALLEY ACADEMY | Regular School | Yes | 1.0 | PK | 08 | 2016 | grade_8 | 7 | 0 | 2 | 0 | 0 | 0 | 0 | 6 | 3 | 9 | 7 | 0 | 2 | 0 | 0 | 0 | 0 | 6 | 3 | 9 | ||||||||||||||||||||||||||||||||||
837921 | 837921 | CO | school | 805370 | 470 | ST VRAIN VALLEY RE 1J | 80537000900 | 2760 | ERIE MIDDLE SCHOOL | Regular School | No | 2.0 | 06 | 08 | 2016 | grade_8 | 231 | 1 | 26 | 1 | 4 | 0 | 8 | 121 | 150 | 271 | 231 | 1 | 26 | 1 | 4 | 0 | 8 | 121 | 150 | 271 | ||||||||||||||||||||||||||||||||||
837956 | 837956 | CO | school | 805370 | 470 | ST VRAIN VALLEY RE 1J | 80537000901 | 3192 | THUNDER VALLEY PK-8 | Regular School | No | 1.0 | PK | 08 | 2016 | grade_8 | 47 | 0 | 49 | 0 | 1 | 0 | 1 | 46 | 52 | 98 | 47 | 0 | 49 | 0 | 1 | 0 | 1 | 46 | 52 | 98 | ||||||||||||||||||||||||||||||||||
837962 | 837962 | CO | school | 805370 | 470 | ST VRAIN VALLEY RE 1J | 80537001774 | 3194 | COAL RIDGE MIDDLE SCHOOL | Regular School | No | 2.0 | 06 | 08 | 2016 | grade_8 | 184 | 3 | 60 | 2 | 3 | 0 | 1 | 138 | 115 | 253 | 184 | 3 | 60 | 2 | 3 | 0 | 1 | 138 | 115 | 253 | ||||||||||||||||||||||||||||||||||
837993 | 837993 | CO | school | 805370 | 470 | ST VRAIN VALLEY RE 1J | 80537006388 | 4333 | IMAGINE CHARTER | Regular School | Yes | 1.0 | PK | 08 | 2016 | grade_8 | 35 | 0 | 7 | 1 | 0 | 0 | 1 | 24 | 20 | 44 | 35 | 0 | 7 | 1 | 0 | 0 | 1 | 24 | 20 | 44 | ||||||||||||||||||||||||||||||||||
838028 | 838028 | CO | school | 805370 | 470 | ST VRAIN VALLEY RE 1J | 80537000910 | 5288 | LONGS PEAK MIDDLE SCHOOL | Regular School | No | 2.0 | 05 | 08 | 2016 | grade_8 | 42 | 1 | 98 | 2 | 2 | 0 | 3 | 80 | 68 | 148 | 42 | 1 | 98 | 2 | 2 | 0 | 3 | 80 | 68 | 148 | ||||||||||||||||||||||||||||||||||
838044 | 838044 | CO | school | 805370 | 470 | ST VRAIN VALLEY RE 1J | 80537000912 | 5368 | LYONS MIDDLE/SENIOR HIGH SCHOOL | Regular School | No | 4.0 | 06 | 12 | 2016 | grade_8 | 42 | 1 | 2 | 0 | 4 | 0 | 0 | 25 | 24 | 49 | 42 | 1 | 2 | 0 | 4 | 0 | 0 | 25 | 24 | 49 | ||||||||||||||||||||||||||||||||||
838063 | 838063 | CO | school | 805370 | 470 | ST VRAIN VALLEY RE 1J | 80537000915 | 5730 | MEAD MIDDLE SCHOOL | Regular School | No | 2.0 | 06 | 08 | 2016 | grade_8 | 119 | 0 | 25 | 0 | 2 | 0 | 2 | 80 | 68 | 148 | 119 | 0 | 25 | 0 | 2 | 0 | 2 | 80 | 68 | 148 | ||||||||||||||||||||||||||||||||||
838072 | 838072 | CO | school | 805370 | 470 | ST VRAIN VALLEY RE 1J | 80537006594 | 6010 | TIMBERLINE PK-8 | Regular School | No | 1.0 | PK | 08 | 2016 | grade_8 | 22 | 0 | 96 | 0 | 1 | 0 | 0 | 61 | 58 | 119 | 22 | 0 | 96 | 0 | 1 | 0 | 0 | 61 | 58 | 119 | ||||||||||||||||||||||||||||||||||
838137 | 838137 | CO | school | 805370 | 470 | ST VRAIN VALLEY RE 1J | 80537006430 | 7565 | ST. VRAIN COMMUNITY MONTESSORI SCHOOL | Regular School | Yes | 1.0 | PK | 08 | 2016 | grade_8 | 8 | 0 | 0 | 0 | 0 | 0 | 0 | 2 | 6 | 8 | 8 | 0 | 0 | 0 | 0 | 0 | 0 | 2 | 6 | 8 | ||||||||||||||||||||||||||||||||||
838187 | 838187 | CO | school | 805370 | 470 | ST VRAIN VALLEY RE 1J | 80537006198 | 9430 | WESTVIEW MIDDLE SCHOOL | Regular School | No | 2.0 | 06 | 08 | 2016 | grade_8 | 192 | 1 | 45 | 2 | 10 | 0 | 7 | 125 | 132 | 257 | 192 | 1 | 45 | 2 | 10 | 0 | 7 | 125 | 132 | 257 | ||||||||||||||||||||||||||||||||||
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 |
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]);