enrollments
Data source: Big Local News · About: Big Local
4,915 rows where grade = "grade_6" and state = "CO" sorted by multiracial_int descending
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1935400 | 1935400 | CO | school | 803360 | 880 | DENVER COUNTY 1 | 80336006562 | 5897 | MCAULIFFE INTERNATIONAL SCHOOL | Regular School | No | Middle | 06 | 08 | 2019 | grade_6 | 320 | 72 | 81 | 0 | 9 | 0 | 48 | 288 | 242 | 530 | 320 | 72 | 81 | 0 | 9 | 0 | 48 | 288 | 242 | 530 | ||||||||||||||||||||||||||||||||||
1898062 | 1898062 | CO | school | 803360 | 880 | DENVER COUNTY 1 | 80336006562 | 5897 | MCAULIFFE INTERNATIONAL SCHOOL | Regular School | No | Middle | 06 | 08 | 2018 | grade_6 | 311 | 55 | 53 | 5 | 11 | 1 | 44 | 250 | 230 | 480 | 311 | 55 | 53 | 5 | 11 | 1 | 44 | 250 | 230 | 480 | ||||||||||||||||||||||||||||||||||
1739709 | 1739709 | CO | school | 802910 | 130 | Cherry Creek 5 | 80291000201 | 7158 | Prairie Middle School | Regular School | No | Middle | 06 | 08 | 2021 | grade_6 | 102 | 141 | 235 | 4 | 21 | 4 | 42 | 278 | 271 | 549 | 102 | 141 | 235 | 4 | 21 | 4 | 42 | 278 | 271 | 549 | ||||||||||||||||||||||||||||||||||
1800497 | 1800497 | CO | school | 802910 | 130 | Cherry Creek 5 | 80291000185 | 1566 | Campus Middle School | Regular School | No | Middle | 06 | 08 | 2020 | grade_6 | 304 | 16 | 65 | 3 | 77 | 1 | 42 | 243 | 265 | 508 | 304 | 16 | 65 | 3 | 77 | 1 | 42 | 243 | 265 | 508 | ||||||||||||||||||||||||||||||||||
1800756 | 1800756 | CO | school | 802910 | 130 | Cherry Creek 5 | 80291000201 | 7158 | Prairie Middle School | Regular School | No | Middle | 06 | 08 | 2020 | grade_6 | 108 | 129 | 211 | 3 | 27 | 3 | 42 | 269 | 254 | 523 | 108 | 129 | 211 | 3 | 27 | 3 | 42 | 269 | 254 | 523 | ||||||||||||||||||||||||||||||||||
1805538 | 1805538 | CO | school | 804080 | 1000 | Fountain 8 | 80408000563 | 3106 | Fountain Middle School | Regular School | No | Middle | 06 | 08 | 2020 | grade_6 | 199 | 38 | 87 | 4 | 6 | 11 | 42 | 197 | 190 | 387 | 199 | 38 | 87 | 4 | 6 | 11 | 42 | 197 | 190 | 387 | ||||||||||||||||||||||||||||||||||
1806679 | 1806679 | CO | school | 803870 | 1110 | District 49 | 80387001799 | 7960 | Skyview Middle School | Regular School | No | Middle | 06 | 08 | 2020 | grade_6 | 183 | 17 | 84 | 3 | 18 | 0 | 42 | 185 | 162 | 347 | 183 | 17 | 84 | 3 | 18 | 0 | 42 | 185 | 162 | 347 | ||||||||||||||||||||||||||||||||||
1895118 | 1895118 | CO | school | 802910 | 130 | CHERRY CREEK 5 | 80291000201 | 7158 | PRAIRIE MIDDLE SCHOOL | Regular School | No | Middle | 06 | 08 | 2018 | grade_6 | 132 | 159 | 237 | 8 | 14 | 3 | 41 | 293 | 301 | 594 | 132 | 159 | 237 | 8 | 14 | 3 | 41 | 293 | 301 | 594 | ||||||||||||||||||||||||||||||||||
1937245 | 1937245 | CO | school | 804080 | 1000 | FOUNTAIN 8 | 80408000563 | 3106 | FOUNTAIN MIDDLE SCHOOL | Regular School | No | Middle | 06 | 08 | 2019 | grade_6 | 176 | 22 | 107 | 6 | 2 | 4 | 41 | 193 | 165 | 358 | 176 | 22 | 107 | 6 | 2 | 4 | 41 | 193 | 165 | 358 | ||||||||||||||||||||||||||||||||||
1800418 | 1800418 | CO | school | 802910 | 130 | Cherry Creek 5 | 80291001878 | 141 | Sky Vista Middle School | Regular School | No | Middle | 06 | 08 | 2020 | grade_6 | 151 | 47 | 57 | 0 | 29 | 0 | 40 | 164 | 160 | 324 | 151 | 47 | 57 | 0 | 29 | 0 | 40 | 164 | 160 | 324 | ||||||||||||||||||||||||||||||||||
1803720 | 1803720 | CO | school | 803360 | 880 | Denver County 1 | 80336006562 | 5897 | McAuliffe International School | Regular School | No | Middle | 06 | 08 | 2020 | grade_6 | 354 | 51 | 73 | 3 | 14 | 0 | 40 | 278 | 257 | 535 | 354 | 51 | 73 | 3 | 14 | 0 | 40 | 278 | 257 | 535 | ||||||||||||||||||||||||||||||||||
1900918 | 1900918 | CO | school | 803870 | 1110 | FALCON 49 | 80387001799 | 7960 | SKYVIEW MIDDLE SCHOOL | Regular School | No | Middle | 06 | 08 | 2018 | grade_6 | 199 | 20 | 85 | 2 | 17 | 0 | 39 | 202 | 160 | 362 | 199 | 20 | 85 | 2 | 17 | 0 | 39 | 202 | 160 | 362 | ||||||||||||||||||||||||||||||||||
1742701 | 1742701 | CO | school | 803360 | 880 | Denver County 1 | 80336006562 | 5897 | McAuliffe International School | Regular School | No | Middle | 06 | 08 | 2021 | grade_6 | 301 | 88 | 99 | 2 | 15 | 1 | 38 | 250 | 294 | 544 | 301 | 88 | 99 | 2 | 15 | 1 | 38 | 250 | 294 | 544 | ||||||||||||||||||||||||||||||||||
1806557 | 1806557 | CO | school | 803870 | 1110 | District 49 | 80387000506 | 2906 | Falcon Middle School | Regular School | No | Middle | 06 | 08 | 2020 | grade_6 | 196 | 10 | 66 | 1 | 8 | 0 | 38 | 162 | 157 | 319 | 196 | 10 | 66 | 1 | 8 | 0 | 38 | 162 | 157 | 319 | ||||||||||||||||||||||||||||||||||
1134590 | 1134590 | CO | school | 802910 | 130 | CHERRY CREEK 5 | 80291000201 | 7158 | PRAIRIE MIDDLE SCHOOL | Regular School | No | 2.0 | 06 | 08 | 2015 | grade_6 | 144.0 | 144.0 | 238.0 | 5.0 | 30.0 | 3.0 | 37.0 | 309.0 | 292.0 | 601.0 | 144 | 144 | 238 | 5 | 30 | 3 | 37 | 309 | 292 | 601 | ||||||||||||||||||||||||||||||||||
1134637 | 1134637 | CO | school | 802910 | 130 | CHERRY CREEK 5 | 80291000034 | 8848 | THUNDER RIDGE MIDDLE SCHOOL | Regular School | No | 2.0 | 06 | 08 | 2015 | grade_6 | 278.0 | 29.0 | 83.0 | 2.0 | 17.0 | 2.0 | 37.0 | 225.0 | 223.0 | 448.0 | 278 | 29 | 83 | 2 | 17 | 2 | 37 | 225 | 223 | 448 | ||||||||||||||||||||||||||||||||||
1739368 | 1739368 | CO | school | 802910 | 130 | Cherry Creek 5 | 80291001878 | 141 | Sky Vista Middle School | Regular School | No | Middle | 06 | 08 | 2021 | grade_6 | 131 | 29 | 52 | 0 | 26 | 1 | 37 | 146 | 130 | 276 | 131 | 29 | 52 | 0 | 26 | 1 | 37 | 146 | 130 | 276 | ||||||||||||||||||||||||||||||||||
1739450 | 1739450 | CO | school | 802910 | 130 | Cherry Creek 5 | 80291000185 | 1566 | Campus Middle School | Regular School | No | Middle | 06 | 08 | 2021 | grade_6 | 256 | 20 | 65 | 2 | 63 | 1 | 37 | 230 | 214 | 444 | 256 | 20 | 65 | 2 | 63 | 1 | 37 | 230 | 214 | 444 | ||||||||||||||||||||||||||||||||||
836874 | 836874 | CO | school | 802910 | 130 | CHERRY CREEK 5 | 80291000201 | 7158 | PRAIRIE MIDDLE SCHOOL | Regular School | No | 2.0 | 06 | 08 | 2016 | grade_6 | 142 | 155 | 219 | 6 | 25 | 3 | 36 | 310 | 276 | 586 | 142 | 155 | 219 | 6 | 25 | 3 | 36 | 310 | 276 | 586 | ||||||||||||||||||||||||||||||||||
1739630 | 1739630 | CO | school | 802910 | 130 | Cherry Creek 5 | 80291000197 | 4975 | Laredo Middle School | Regular School | No | Middle | 06 | 08 | 2021 | grade_6 | 135 | 46 | 84 | 0 | 19 | 3 | 36 | 170 | 153 | 323 | 135 | 46 | 84 | 0 | 19 | 3 | 36 | 170 | 153 | 323 | ||||||||||||||||||||||||||||||||||
1932422 | 1932422 | CO | school | 802910 | 130 | CHERRY CREEK 5 | 80291000201 | 7158 | PRAIRIE MIDDLE SCHOOL | Regular School | No | Middle | 06 | 08 | 2019 | grade_6 | 105 | 141 | 206 | 5 | 30 | 6 | 36 | 291 | 238 | 529 | 105 | 141 | 206 | 5 | 30 | 6 | 36 | 291 | 238 | 529 | ||||||||||||||||||||||||||||||||||
1937130 | 1937130 | CO | school | 806480 | 990 | WIDEFIELD 3 | 80648001120 | 4394 | JANITELL JUNIOR HIGH SCHOOL | Regular School | No | Middle | 06 | 08 | 2019 | grade_6 | 91 | 24 | 81 | 0 | 4 | 4 | 36 | 136 | 104 | 240 | 91 | 24 | 81 | 0 | 4 | 4 | 36 | 136 | 104 | 240 | ||||||||||||||||||||||||||||||||||
709229 | 709229 | CO | school | 802910 | 130 | CHERRY CREEK 5 | 80291000201 | 7158 | PRAIRIE MIDDLE SCHOOL | Regular School | No | Middle | 06 | 08 | 2017 | grade_6 | 121 | 150 | 228 | 4 | 27 | 3 | 35 | 302 | 266 | 568 | 121 | 150 | 228 | 4 | 27 | 3 | 35 | 302 | 266 | 568 | ||||||||||||||||||||||||||||||||||
1899868 | 1899868 | CO | school | 804080 | 1000 | FOUNTAIN 8 | 80408000563 | 3106 | FOUNTAIN MIDDLE SCHOOL | Regular School | No | Middle | 06 | 08 | 2018 | grade_6 | 193 | 27 | 102 | 3 | 1 | 4 | 35 | 186 | 179 | 365 | 193 | 27 | 102 | 3 | 1 | 4 | 35 | 186 | 179 | 365 | ||||||||||||||||||||||||||||||||||
1937181 | 1937181 | CO | school | 806480 | 990 | WIDEFIELD 3 | 80648001126 | 9294 | WATSON JUNIOR HIGH SCHOOL | Regular School | No | Middle | 06 | 08 | 2019 | grade_6 | 124 | 28 | 71 | 0 | 2 | 3 | 35 | 128 | 135 | 263 | 124 | 28 | 71 | 0 | 2 | 3 | 35 | 128 | 135 | 263 | ||||||||||||||||||||||||||||||||||
1938330 | 1938330 | CO | school | 803870 | 1110 | DISTRICT 49 | 80387001799 | 7960 | SKYVIEW MIDDLE SCHOOL | Regular School | No | Middle | 06 | 08 | 2019 | grade_6 | 200 | 24 | 82 | 3 | 6 | 1 | 35 | 182 | 169 | 351 | 200 | 24 | 82 | 3 | 6 | 1 | 35 | 182 | 169 | 351 | ||||||||||||||||||||||||||||||||||
713956 | 713956 | CO | school | 804080 | 1000 | FOUNTAIN 8 | 80408000563 | 3106 | FOUNTAIN MIDDLE SCHOOL | Regular School | No | Middle | 06 | 08 | 2017 | grade_6 | 156 | 23 | 114 | 2 | 4 | 4 | 34 | 171 | 166 | 337 | 156 | 23 | 114 | 2 | 4 | 4 | 34 | 171 | 166 | 337 | ||||||||||||||||||||||||||||||||||
842597 | 842597 | CO | school | 803870 | 1110 | FALCON 49 | 80387001799 | 7960 | SKYVIEW MIDDLE SCHOOL | Regular School | No | 2.0 | 06 | 08 | 2016 | grade_6 | 239 | 25 | 93 | 3 | 14 | 2 | 34 | 210 | 200 | 410 | 239 | 25 | 93 | 3 | 14 | 2 | 34 | 210 | 200 | 410 | ||||||||||||||||||||||||||||||||||
1134480 | 1134480 | CO | school | 802910 | 130 | CHERRY CREEK 5 | 80291001328 | 4100 | HORIZON MIDDLE SCHOOL | Regular School | No | 2.0 | 06 | 08 | 2015 | grade_6 | 129.0 | 64.0 | 76.0 | 4.0 | 18.0 | 0.0 | 34.0 | 167.0 | 158.0 | 325.0 | 129 | 64 | 76 | 4 | 18 | 0 | 34 | 167 | 158 | 325 | ||||||||||||||||||||||||||||||||||
1744459 | 1744459 | CO | school | 804080 | 1000 | Fountain 8 | 80408000563 | 3106 | Fountain Middle School | Regular School | No | Middle | 06 | 08 | 2021 | grade_6 | 171 | 30 | 107 | 4 | 4 | 5 | 34 | 187 | 168 | 355 | 171 | 30 | 107 | 4 | 4 | 5 | 34 | 187 | 168 | 355 | ||||||||||||||||||||||||||||||||||
1745594 | 1745594 | CO | school | 803870 | 1110 | District 49 | 80387001799 | 7960 | Skyview Middle School | Regular School | No | Middle | 06 | 08 | 2021 | grade_6 | 189 | 25 | 67 | 2 | 7 | 4 | 34 | 173 | 155 | 328 | 189 | 25 | 67 | 2 | 7 | 4 | 34 | 173 | 155 | 328 | ||||||||||||||||||||||||||||||||||
1900220 | 1900220 | CO | school | 803060 | 1010 | COLORADO SPRINGS 11 | 80306000234 | 7556 | SABIN MIDDLE SCHOOL | Regular School | No | Middle | 06 | 08 | 2018 | grade_6 | 140 | 27 | 90 | 3 | 8 | 1 | 34 | 158 | 145 | 303 | 140 | 27 | 90 | 3 | 8 | 1 | 34 | 158 | 145 | 303 | ||||||||||||||||||||||||||||||||||
1932164 | 1932164 | CO | school | 802910 | 130 | CHERRY CREEK 5 | 80291000185 | 1566 | CAMPUS MIDDLE SCHOOL | Regular School | No | Middle | 06 | 08 | 2019 | grade_6 | 304 | 11 | 45 | 1 | 82 | 2 | 34 | 251 | 228 | 479 | 304 | 11 | 45 | 1 | 82 | 2 | 34 | 251 | 228 | 479 | ||||||||||||||||||||||||||||||||||
1938014 | 1938014 | CO | school | 801920 | 1040 | ACADEMY 20 | 80192001462 | 8851 | TIMBERVIEW MIDDLE SCHOOL | Regular School | No | Middle | 06 | 08 | 2019 | grade_6 | 252 | 12 | 61 | 3 | 4 | 2 | 34 | 206 | 162 | 368 | 252 | 12 | 61 | 3 | 4 | 2 | 34 | 206 | 162 | 368 | ||||||||||||||||||||||||||||||||||
714905 | 714905 | CO | school | 803870 | 1110 | FALCON 49 | 80387001393 | 4102 | HORIZON MIDDLE SCHOOL | Regular School | No | Middle | 06 | 08 | 2017 | grade_6 | 122 | 25 | 72 | 1 | 9 | 2 | 33 | 149 | 115 | 264 | 122 | 25 | 72 | 1 | 9 | 2 | 33 | 149 | 115 | 264 | ||||||||||||||||||||||||||||||||||
836716 | 836716 | CO | school | 802910 | 130 | CHERRY CREEK 5 | 80291006367 | 3030 | FOX RIDGE MIDDLE SCHOOL | Regular School | No | 2.0 | 06 | 08 | 2016 | grade_6 | 315 | 30 | 67 | 2 | 30 | 0 | 32 | 247 | 229 | 476 | 315 | 30 | 67 | 2 | 30 | 0 | 32 | 247 | 229 | 476 | ||||||||||||||||||||||||||||||||||
1805899 | 1805899 | CO | school | 803060 | 1010 | Colorado Springs 11 | 80306000234 | 7556 | Sabin Middle School | Regular School | No | Middle | 06 | 08 | 2020 | grade_6 | 125 | 17 | 99 | 0 | 4 | 1 | 32 | 148 | 130 | 278 | 125 | 17 | 99 | 0 | 4 | 1 | 32 | 148 | 130 | 278 | ||||||||||||||||||||||||||||||||||
841571 | 841571 | CO | school | 804080 | 1000 | FOUNTAIN 8 | 80408000563 | 3106 | FOUNTAIN MIDDLE SCHOOL | Regular School | No | 2.0 | 06 | 08 | 2016 | grade_6 | 153 | 28 | 93 | 5 | 2 | 4 | 31 | 158 | 158 | 316 | 153 | 28 | 93 | 5 | 2 | 4 | 31 | 158 | 158 | 316 | ||||||||||||||||||||||||||||||||||
1800588 | 1800588 | CO | school | 802910 | 130 | Cherry Creek 5 | 80291001672 | 2897 | Falcon Creek Middle School | Regular School | No | Middle | 06 | 08 | 2020 | grade_6 | 168 | 24 | 54 | 5 | 26 | 1 | 31 | 160 | 149 | 309 | 168 | 24 | 54 | 5 | 26 | 1 | 31 | 160 | 149 | 309 | ||||||||||||||||||||||||||||||||||
1800677 | 1800677 | CO | school | 802910 | 130 | Cherry Creek 5 | 80291000197 | 4975 | Laredo Middle School | Regular School | No | Middle | 06 | 08 | 2020 | grade_6 | 142 | 61 | 91 | 4 | 23 | 0 | 31 | 176 | 176 | 352 | 142 | 61 | 91 | 4 | 23 | 0 | 31 | 176 | 176 | 352 | ||||||||||||||||||||||||||||||||||
1894860 | 1894860 | CO | school | 802910 | 130 | CHERRY CREEK 5 | 80291000185 | 1566 | CAMPUS MIDDLE SCHOOL | Regular School | No | Middle | 06 | 08 | 2018 | grade_6 | 310 | 14 | 64 | 0 | 75 | 0 | 31 | 275 | 219 | 494 | 310 | 14 | 64 | 0 | 75 | 0 | 31 | 275 | 219 | 494 | ||||||||||||||||||||||||||||||||||
1895167 | 1895167 | CO | school | 802910 | 130 | CHERRY CREEK 5 | 80291000034 | 8848 | THUNDER RIDGE MIDDLE SCHOOL | Regular School | No | Middle | 06 | 08 | 2018 | grade_6 | 255 | 44 | 73 | 1 | 23 | 2 | 31 | 228 | 201 | 429 | 255 | 44 | 73 | 1 | 23 | 2 | 31 | 228 | 201 | 429 | ||||||||||||||||||||||||||||||||||
714999 | 714999 | CO | school | 803870 | 1110 | FALCON 49 | 80387001799 | 7960 | SKYVIEW MIDDLE SCHOOL | Regular School | No | Middle | 06 | 08 | 2017 | grade_6 | 199 | 33 | 77 | 3 | 11 | 1 | 30 | 199 | 155 | 354 | 199 | 33 | 77 | 3 | 11 | 1 | 30 | 199 | 155 | 354 | ||||||||||||||||||||||||||||||||||
1806571 | 1806571 | CO | school | 803870 | 1110 | District 49 | 80387001393 | 4102 | Horizon Middle School | Regular School | No | Middle | 06 | 08 | 2020 | grade_6 | 131 | 14 | 84 | 1 | 6 | 0 | 30 | 124 | 142 | 266 | 131 | 14 | 84 | 1 | 6 | 0 | 30 | 124 | 142 | 266 | ||||||||||||||||||||||||||||||||||
1900546 | 1900546 | CO | school | 801920 | 1040 | ACADEMY 20 | 80192001593 | 6140 | MOUNTAIN RIDGE MIDDLE SCHOOL | Regular School | No | Middle | 06 | 08 | 2018 | grade_6 | 219 | 16 | 52 | 0 | 21 | 0 | 30 | 161 | 177 | 338 | 219 | 16 | 52 | 0 | 21 | 0 | 30 | 161 | 177 | 338 | ||||||||||||||||||||||||||||||||||
1900617 | 1900617 | CO | school | 801920 | 1040 | ACADEMY 20 | 80192001462 | 8851 | TIMBERVIEW MIDDLE SCHOOL | Regular School | No | Middle | 06 | 08 | 2018 | grade_6 | 305 | 12 | 58 | 2 | 1 | 1 | 30 | 197 | 212 | 409 | 305 | 12 | 58 | 2 | 1 | 1 | 30 | 197 | 212 | 409 | ||||||||||||||||||||||||||||||||||
841460 | 841460 | CO | school | 806480 | 990 | WIDEFIELD 3 | 80648001120 | 4394 | JANITELL JUNIOR HIGH SCHOOL | Regular School | No | 2.0 | 06 | 08 | 2016 | grade_6 | 110 | 28 | 60 | 2 | 0 | 3 | 29 | 138 | 94 | 232 | 110 | 28 | 60 | 2 | 0 | 3 | 29 | 138 | 94 | 232 | ||||||||||||||||||||||||||||||||||
841809 | 841809 | CO | school | 803060 | 1010 | COLORADO SPRINGS 11 | 80306001683 | 4424 | JENKINS MIDDLE SCHOOL | Regular School | No | 2.0 | 06 | 08 | 2016 | grade_6 | 183 | 8 | 66 | 3 | 11 | 2 | 29 | 156 | 146 | 302 | 183 | 8 | 66 | 3 | 11 | 2 | 29 | 156 | 146 | 302 | ||||||||||||||||||||||||||||||||||
842169 | 842169 | CO | school | 801920 | 1040 | ACADEMY 20 | 80192006616 | 1921 | DISCOVERY CANYON CAMPUS MIDDLE SCHOOL | Regular School | No | 2.0 | 06 | 08 | 2016 | grade_6 | 264 | 12 | 45 | 1 | 20 | 0 | 29 | 187 | 184 | 371 | 264 | 12 | 45 | 1 | 20 | 0 | 29 | 187 | 184 | 371 | ||||||||||||||||||||||||||||||||||
1745231 | 1745231 | CO | school | 801920 | 1040 | Academy 20 | 80192001462 | 8851 | Timberview Middle School | Regular School | No | Middle | 06 | 08 | 2021 | grade_6 | 156 | 9 | 54 | 0 | 5 | 1 | 29 | 131 | 123 | 254 | 156 | 9 | 54 | 0 | 5 | 1 | 29 | 131 | 123 | 254 | ||||||||||||||||||||||||||||||||||
1745485 | 1745485 | CO | school | 803870 | 1110 | District 49 | 80387001393 | 4102 | Horizon Middle School | Regular School | No | Middle | 06 | 08 | 2021 | grade_6 | 101 | 24 | 93 | 1 | 7 | 1 | 29 | 133 | 123 | 256 | 101 | 24 | 93 | 1 | 7 | 1 | 29 | 133 | 123 | 256 | ||||||||||||||||||||||||||||||||||
1800406 | 1800406 | CO | school | 802910 | 130 | Cherry Creek 5 | 80291001711 | 18 | Liberty Middle School | Regular School | No | Middle | 06 | 08 | 2020 | grade_6 | 170 | 33 | 63 | 1 | 38 | 0 | 29 | 186 | 148 | 334 | 170 | 33 | 63 | 1 | 38 | 0 | 29 | 186 | 148 | 334 | ||||||||||||||||||||||||||||||||||
1899755 | 1899755 | CO | school | 806480 | 990 | WIDEFIELD 3 | 80648001120 | 4394 | JANITELL JUNIOR HIGH SCHOOL | Regular School | No | Middle | 06 | 08 | 2018 | grade_6 | 138 | 24 | 93 | 1 | 3 | 8 | 29 | 151 | 145 | 296 | 138 | 24 | 93 | 1 | 3 | 8 | 29 | 151 | 145 | 296 | ||||||||||||||||||||||||||||||||||
1932473 | 1932473 | CO | school | 802910 | 130 | CHERRY CREEK 5 | 80291000034 | 8848 | THUNDER RIDGE MIDDLE SCHOOL | Regular School | No | Middle | 06 | 08 | 2019 | grade_6 | 220 | 43 | 98 | 3 | 15 | 2 | 29 | 221 | 189 | 410 | 220 | 43 | 98 | 3 | 15 | 2 | 29 | 221 | 189 | 410 | ||||||||||||||||||||||||||||||||||
708972 | 708972 | CO | school | 802910 | 130 | CHERRY CREEK 5 | 80291000185 | 1566 | CAMPUS MIDDLE SCHOOL | Regular School | No | Middle | 06 | 08 | 2017 | grade_6 | 275 | 16 | 43 | 0 | 75 | 2 | 28 | 230 | 209 | 439 | 275 | 16 | 43 | 0 | 75 | 2 | 28 | 230 | 209 | 439 | ||||||||||||||||||||||||||||||||||
1139150 | 1139150 | CO | school | 804080 | 1000 | FOUNTAIN 8 | 80408000561 | 1332 | CARSON MIDDLE SCHOOL | Regular School | No | 2.0 | 06 | 08 | 2015 | grade_6 | 106.0 | 44.0 | 71.0 | 6.0 | 5.0 | 6.0 | 28.0 | 121.0 | 145.0 | 266.0 | 106 | 44 | 71 | 6 | 5 | 6 | 28 | 121 | 145 | 266 | ||||||||||||||||||||||||||||||||||
1139176 | 1139176 | CO | school | 804080 | 1000 | FOUNTAIN 8 | 80408000563 | 3106 | FOUNTAIN MIDDLE SCHOOL | Regular School | No | 2.0 | 06 | 08 | 2015 | grade_6 | 162.0 | 32.0 | 63.0 | 6.0 | 6.0 | 5.0 | 28.0 | 150.0 | 152.0 | 302.0 | 162 | 32 | 63 | 6 | 6 | 5 | 28 | 150 | 152 | 302 | ||||||||||||||||||||||||||||||||||
1800775 | 1800775 | CO | school | 802910 | 130 | Cherry Creek 5 | 80291006728 | 7514 | Infinity Middle School | Regular School | No | Middle | 06 | 08 | 2020 | grade_6 | 172 | 18 | 40 | 0 | 23 | 0 | 28 | 140 | 141 | 281 | 172 | 18 | 40 | 0 | 23 | 0 | 28 | 140 | 141 | 281 | ||||||||||||||||||||||||||||||||||
1805512 | 1805512 | CO | school | 804080 | 1000 | Fountain 8 | 80408000561 | 1332 | Carson Middle School | Regular School | No | Middle | 06 | 08 | 2020 | grade_6 | 131 | 39 | 58 | 4 | 6 | 9 | 28 | 139 | 136 | 275 | 131 | 39 | 58 | 4 | 6 | 9 | 28 | 139 | 136 | 275 | ||||||||||||||||||||||||||||||||||
1898643 | 1898643 | CO | school | 803450 | 900 | DOUGLAS COUNTY RE 1 | 80345006404 | 264 | CIMARRON MIDDLE | Regular School | No | Middle | 06 | 08 | 2018 | grade_6 | 329 | 3 | 47 | 1 | 5 | 2 | 28 | 209 | 206 | 415 | 329 | 3 | 47 | 1 | 5 | 2 | 28 | 209 | 206 | 415 | ||||||||||||||||||||||||||||||||||
1932303 | 1932303 | CO | school | 802910 | 130 | CHERRY CREEK 5 | 80291001328 | 4100 | HORIZON MIDDLE SCHOOL | Regular School | No | Middle | 06 | 08 | 2019 | grade_6 | 116 | 66 | 103 | 1 | 20 | 1 | 28 | 187 | 148 | 335 | 116 | 66 | 103 | 1 | 20 | 1 | 28 | 187 | 148 | 335 | ||||||||||||||||||||||||||||||||||
1937058 | 1937058 | CO | school | 804530 | 980 | HARRISON 2 | 80453000669 | 6686 | PANORAMA MIDDLE SCHOOL | Regular School | No | Middle | 06 | 08 | 2019 | grade_6 | 36 | 38 | 121 | 3 | 8 | 4 | 28 | 127 | 111 | 238 | 36 | 38 | 121 | 3 | 8 | 4 | 28 | 127 | 111 | 238 | ||||||||||||||||||||||||||||||||||
1937486 | 1937486 | CO | school | 803060 | 1010 | COLORADO SPRINGS 11 | 80306001683 | 4424 | JENKINS MIDDLE SCHOOL | Regular School | No | Middle | 06 | 08 | 2019 | grade_6 | 186 | 13 | 77 | 1 | 6 | 2 | 28 | 165 | 148 | 313 | 186 | 13 | 77 | 1 | 6 | 2 | 28 | 165 | 148 | 313 | ||||||||||||||||||||||||||||||||||
1937780 | 1937780 | CO | school | 801920 | 1040 | ACADEMY 20 | 80192000001 | 74 | CHALLENGER MIDDLE SCHOOL | Regular School | No | Middle | 06 | 08 | 2019 | grade_6 | 227 | 6 | 37 | 0 | 26 | 0 | 28 | 157 | 167 | 324 | 227 | 6 | 37 | 0 | 26 | 0 | 28 | 157 | 167 | 324 | ||||||||||||||||||||||||||||||||||
709588 | 709588 | CO | school | 802340 | 180 | ADAMS-ARAPAHOE 28J | 80234001322 | 1800 | COLUMBIA MIDDLE SCHOOL | Regular School | No | Middle | 06 | 08 | 2017 | grade_6 | 82 | 49 | 91 | 0 | 13 | 0 | 27 | 135 | 127 | 262 | 82 | 49 | 91 | 0 | 13 | 0 | 27 | 135 | 127 | 262 | ||||||||||||||||||||||||||||||||||
714704 | 714704 | CO | school | 801920 | 1040 | ACADEMY 20 | 80192001462 | 8851 | TIMBERVIEW MIDDLE SCHOOL | Regular School | No | Middle | 06 | 08 | 2017 | grade_6 | 234 | 15 | 65 | 1 | 7 | 1 | 27 | 171 | 179 | 350 | 234 | 15 | 65 | 1 | 7 | 1 | 27 | 171 | 179 | 350 | ||||||||||||||||||||||||||||||||||
1139851 | 1139851 | CO | school | 801920 | 1040 | ACADEMY 20 | 80192001593 | 6140 | MOUNTAIN RIDGE MIDDLE SCHOOL | Regular School | No | 2.0 | 06 | 08 | 2015 | grade_6 | 246.0 | 19.0 | 64.0 | 1.0 | 24.0 | 0.0 | 27.0 | 196.0 | 185.0 | 381.0 | 246 | 19 | 64 | 1 | 24 | 0 | 27 | 196 | 185 | 381 | ||||||||||||||||||||||||||||||||||
1739589 | 1739589 | CO | school | 802910 | 130 | Cherry Creek 5 | 80291001328 | 4100 | Horizon Middle School | Regular School | No | Middle | 06 | 08 | 2021 | grade_6 | 113 | 54 | 111 | 2 | 12 | 1 | 27 | 154 | 166 | 320 | 113 | 54 | 111 | 2 | 12 | 1 | 27 | 154 | 166 | 320 | ||||||||||||||||||||||||||||||||||
1800501 | 1800501 | CO | school | 802910 | 130 | Cherry Creek 5 | 80291000207 | 1568 | West Middle School | Regular School | No | Middle | 06 | 08 | 2020 | grade_6 | 283 | 9 | 52 | 3 | 19 | 1 | 27 | 209 | 185 | 394 | 283 | 9 | 52 | 3 | 19 | 1 | 27 | 209 | 185 | 394 | ||||||||||||||||||||||||||||||||||
1805784 | 1805784 | CO | school | 803060 | 1010 | Colorado Springs 11 | 80306001683 | 4424 | Jenkins Middle School | Regular School | No | Middle | 06 | 08 | 2020 | grade_6 | 168 | 23 | 52 | 0 | 3 | 1 | 27 | 146 | 128 | 274 | 168 | 23 | 52 | 0 | 3 | 1 | 27 | 146 | 128 | 274 | ||||||||||||||||||||||||||||||||||
1899805 | 1899805 | CO | school | 806480 | 990 | WIDEFIELD 3 | 80648001126 | 9294 | WATSON JUNIOR HIGH SCHOOL | Regular School | No | Middle | 06 | 08 | 2018 | grade_6 | 113 | 27 | 70 | 7 | 2 | 4 | 27 | 128 | 122 | 250 | 113 | 27 | 70 | 7 | 2 | 4 | 27 | 128 | 122 | 250 | ||||||||||||||||||||||||||||||||||
1900823 | 1900823 | CO | school | 803870 | 1110 | FALCON 49 | 80387001393 | 4102 | HORIZON MIDDLE SCHOOL | Regular School | No | Middle | 06 | 08 | 2018 | grade_6 | 139 | 19 | 69 | 2 | 6 | 1 | 27 | 132 | 131 | 263 | 139 | 19 | 69 | 2 | 6 | 1 | 27 | 132 | 131 | 263 | ||||||||||||||||||||||||||||||||||
1937925 | 1937925 | CO | school | 801920 | 1040 | ACADEMY 20 | 80192001593 | 6140 | MOUNTAIN RIDGE MIDDLE SCHOOL | Regular School | No | Middle | 06 | 08 | 2019 | grade_6 | 195 | 12 | 68 | 0 | 18 | 3 | 27 | 151 | 172 | 323 | 195 | 12 | 68 | 0 | 18 | 3 | 27 | 151 | 172 | 323 | ||||||||||||||||||||||||||||||||||
836922 | 836922 | CO | school | 802910 | 130 | CHERRY CREEK 5 | 80291000034 | 8848 | THUNDER RIDGE MIDDLE SCHOOL | Regular School | No | 2.0 | 06 | 08 | 2016 | grade_6 | 250 | 40 | 75 | 2 | 35 | 2 | 26 | 216 | 214 | 430 | 250 | 40 | 75 | 2 | 35 | 2 | 26 | 216 | 214 | 430 | ||||||||||||||||||||||||||||||||||
1739545 | 1739545 | CO | school | 802910 | 130 | Cherry Creek 5 | 80291006367 | 3030 | Fox Ridge Middle School | Regular School | No | Middle | 06 | 08 | 2021 | grade_6 | 229 | 29 | 53 | 1 | 30 | 1 | 26 | 187 | 182 | 369 | 229 | 29 | 53 | 1 | 30 | 1 | 26 | 187 | 182 | 369 | ||||||||||||||||||||||||||||||||||
1745023 | 1745023 | CO | school | 801920 | 1040 | Academy 20 | 80192006788 | 1421 | Chinook Trail Middle School | Regular School | No | Middle | 06 | 08 | 2021 | grade_6 | 217 | 14 | 45 | 0 | 18 | 2 | 26 | 157 | 165 | 322 | 217 | 14 | 45 | 0 | 18 | 2 | 26 | 157 | 165 | 322 | ||||||||||||||||||||||||||||||||||
1751507 | 1751507 | CO | school | 800282 | 9170 | Education reEnvisioned BOCES | 80028206764 | 1501 | Colorado Preparatory Academy Middle School | Regular School | No | Middle | 06 | 08 | 2021 | grade_6 | 207 | 26 | 111 | 0 | 0 | 1 | 26 | 192 | 179 | 371 | 207 | 26 | 111 | 0 | 0 | 1 | 26 | 192 | 179 | 371 | ||||||||||||||||||||||||||||||||||
1800592 | 1800592 | CO | school | 802910 | 130 | Cherry Creek 5 | 80291006367 | 3030 | Fox Ridge Middle School | Regular School | No | Middle | 06 | 08 | 2020 | grade_6 | 227 | 9 | 55 | 5 | 29 | 0 | 26 | 188 | 163 | 351 | 227 | 9 | 55 | 5 | 29 | 0 | 26 | 188 | 163 | 351 | ||||||||||||||||||||||||||||||||||
1806113 | 1806113 | CO | school | 801920 | 1040 | Academy 20 | 80192006788 | 1421 | Chinook Trail Middle School | Regular School | No | Middle | 06 | 08 | 2020 | grade_6 | 199 | 7 | 35 | 1 | 28 | 0 | 26 | 150 | 146 | 296 | 199 | 7 | 35 | 1 | 28 | 0 | 26 | 150 | 146 | 296 | ||||||||||||||||||||||||||||||||||
1899609 | 1899609 | CO | school | 804530 | 980 | HARRISON 2 | 80453000666 | 3522 | FOX MEADOW MIDDLE SCHOOL | Regular School | No | Middle | 06 | 08 | 2018 | grade_6 | 67 | 31 | 107 | 3 | 4 | 3 | 26 | 120 | 121 | 241 | 67 | 31 | 107 | 3 | 4 | 3 | 26 | 120 | 121 | 241 | ||||||||||||||||||||||||||||||||||
1932082 | 1932082 | CO | school | 802910 | 130 | CHERRY CREEK 5 | 80291001711 | 18 | LIBERTY MIDDLE SCHOOL | Regular School | No | Middle | 06 | 08 | 2019 | grade_6 | 208 | 28 | 65 | 4 | 42 | 1 | 26 | 200 | 174 | 374 | 208 | 28 | 65 | 4 | 42 | 1 | 26 | 200 | 174 | 374 | ||||||||||||||||||||||||||||||||||
1932341 | 1932341 | CO | school | 802910 | 130 | CHERRY CREEK 5 | 80291000197 | 4975 | LAREDO MIDDLE SCHOOL | Regular School | No | Middle | 06 | 08 | 2019 | grade_6 | 145 | 48 | 85 | 5 | 24 | 3 | 26 | 172 | 164 | 336 | 145 | 48 | 85 | 5 | 24 | 3 | 26 | 172 | 164 | 336 | ||||||||||||||||||||||||||||||||||
1937846 | 1937846 | CO | school | 801920 | 1040 | ACADEMY 20 | 80192006616 | 1921 | DISCOVERY CANYON CAMPUS MIDDLE SCHOOL | Regular School | No | Middle | 06 | 08 | 2019 | grade_6 | 225 | 10 | 35 | 0 | 14 | 0 | 26 | 153 | 157 | 310 | 225 | 10 | 35 | 0 | 14 | 0 | 26 | 153 | 157 | 310 | ||||||||||||||||||||||||||||||||||
1938226 | 1938226 | CO | school | 803870 | 1110 | DISTRICT 49 | 80387001393 | 4102 | HORIZON MIDDLE SCHOOL | Regular School | No | Middle | 06 | 08 | 2019 | grade_6 | 118 | 17 | 71 | 2 | 8 | 0 | 26 | 130 | 112 | 242 | 118 | 17 | 71 | 2 | 8 | 0 | 26 | 130 | 112 | 242 | ||||||||||||||||||||||||||||||||||
708898 | 708898 | CO | school | 802910 | 130 | CHERRY CREEK 5 | 80291001711 | 18 | LIBERTY MIDDLE SCHOOL | Regular School | No | Middle | 06 | 08 | 2017 | grade_6 | 222 | 32 | 62 | 5 | 41 | 0 | 25 | 209 | 178 | 387 | 222 | 32 | 62 | 5 | 41 | 0 | 25 | 209 | 178 | 387 | ||||||||||||||||||||||||||||||||||
712151 | 712151 | CO | school | 803360 | 880 | DENVER COUNTY 1 | 80336006562 | 5897 | MCAULIFFE INTERNATIONAL SCHOOL | Regular School | No | Middle | 06 | 08 | 2017 | grade_6 | 235 | 40 | 51 | 1 | 10 | 0 | 25 | 182 | 180 | 362 | 235 | 40 | 51 | 1 | 10 | 0 | 25 | 182 | 180 | 362 | ||||||||||||||||||||||||||||||||||
839519 | 839519 | CO | school | 803360 | 880 | DENVER COUNTY 1 | 80336000361 | 3746 | HAMILTON MIDDLE SCHOOL | Regular School | No | 2.0 | 06 | 08 | 2016 | grade_6 | 123 | 45 | 116 | 0 | 18 | 1 | 25 | 172 | 156 | 328 | 123 | 45 | 116 | 0 | 18 | 1 | 25 | 172 | 156 | 328 | ||||||||||||||||||||||||||||||||||
841920 | 841920 | CO | school | 803060 | 1010 | COLORADO SPRINGS 11 | 80306000263 | 7523 | RUSSELL MIDDLE SCHOOL | Regular School | No | 2.0 | 06 | 08 | 2016 | grade_6 | 104 | 15 | 62 | 1 | 1 | 2 | 25 | 99 | 111 | 210 | 104 | 15 | 62 | 1 | 1 | 2 | 25 | 99 | 111 | 210 | ||||||||||||||||||||||||||||||||||
1739454 | 1739454 | CO | school | 802910 | 130 | Cherry Creek 5 | 80291000207 | 1568 | West Middle School | Regular School | No | Middle | 06 | 08 | 2021 | grade_6 | 264 | 6 | 45 | 3 | 30 | 0 | 25 | 209 | 164 | 373 | 264 | 6 | 45 | 3 | 30 | 0 | 25 | 209 | 164 | 373 | ||||||||||||||||||||||||||||||||||
1745146 | 1745146 | CO | school | 801920 | 1040 | Academy 20 | 80192001593 | 6140 | Mountain Ridge Middle School | Regular School | No | Middle | 06 | 08 | 2021 | grade_6 | 140 | 12 | 54 | 0 | 13 | 1 | 25 | 115 | 130 | 245 | 140 | 12 | 54 | 0 | 13 | 1 | 25 | 115 | 130 | 245 | ||||||||||||||||||||||||||||||||||
1805466 | 1805466 | CO | school | 806480 | 990 | Widefield 3 | 80648001125 | 8178 | Sproul Junior High School | Regular School | No | Middle | 06 | 08 | 2020 | grade_6 | 102 | 12 | 73 | 1 | 3 | 4 | 25 | 108 | 112 | 220 | 102 | 12 | 73 | 1 | 3 | 4 | 25 | 108 | 112 | 220 | ||||||||||||||||||||||||||||||||||
1806190 | 1806190 | CO | school | 801920 | 1040 | Academy 20 | 80192001402 | 2358 | Eagleview Middle School | Regular School | No | Middle | 06 | 08 | 2020 | grade_6 | 231 | 11 | 57 | 2 | 8 | 1 | 25 | 161 | 174 | 335 | 231 | 11 | 57 | 2 | 8 | 1 | 25 | 161 | 174 | 335 | ||||||||||||||||||||||||||||||||||
1894786 | 1894786 | CO | school | 802910 | 130 | CHERRY CREEK 5 | 80291001711 | 18 | LIBERTY MIDDLE SCHOOL | Regular School | No | Middle | 06 | 08 | 2018 | grade_6 | 196 | 32 | 67 | 1 | 40 | 0 | 25 | 175 | 186 | 361 | 196 | 32 | 67 | 1 | 40 | 0 | 25 | 175 | 186 | 361 | ||||||||||||||||||||||||||||||||||
1894954 | 1894954 | CO | school | 802910 | 130 | CHERRY CREEK 5 | 80291006367 | 3030 | FOX RIDGE MIDDLE SCHOOL | Regular School | No | Middle | 06 | 08 | 2018 | grade_6 | 233 | 15 | 63 | 1 | 27 | 0 | 25 | 201 | 163 | 364 | 233 | 15 | 63 | 1 | 27 | 0 | 25 | 201 | 163 | 364 | ||||||||||||||||||||||||||||||||||
1932953 | 1932953 | CO | school | 802340 | 180 | ADAMS-ARAPAHOE 28J | 80234000073 | 6160 | MRACHEK MIDDLE SCHOOL | Regular School | No | Middle | 06 | 08 | 2019 | grade_6 | 57 | 74 | 167 | 1 | 14 | 6 | 25 | 183 | 161 | 344 | 57 | 74 | 167 | 1 | 14 | 6 | 25 | 183 | 161 | 344 | ||||||||||||||||||||||||||||||||||
1936581 | 1936581 | CO | school | 803450 | 900 | DOUGLAS COUNTY RE 1 | 80345001962 | 7448 | ROCKY HEIGHTS MIDDLE SCHOOL | Regular School | No | Middle | 06 | 08 | 2019 | grade_6 | 334 | 3 | 39 | 3 | 30 | 0 | 25 | 218 | 216 | 434 | 334 | 3 | 39 | 3 | 30 | 0 | 25 | 218 | 216 | 434 | ||||||||||||||||||||||||||||||||||
1937170 | 1937170 | CO | school | 806480 | 990 | WIDEFIELD 3 | 80648001125 | 8178 | SPROUL JUNIOR HIGH SCHOOL | Regular School | No | Middle | 06 | 08 | 2019 | grade_6 | 87 | 14 | 57 | 1 | 3 | 4 | 25 | 100 | 91 | 191 | 87 | 14 | 57 | 1 | 3 | 4 | 25 | 100 | 91 | 191 | ||||||||||||||||||||||||||||||||||
709148 | 709148 | CO | school | 802910 | 130 | CHERRY CREEK 5 | 80291000197 | 4975 | LAREDO MIDDLE SCHOOL | Regular School | No | Middle | 06 | 08 | 2017 | grade_6 | 190 | 55 | 78 | 3 | 23 | 3 | 24 | 180 | 196 | 376 | 190 | 55 | 78 | 3 | 23 | 3 | 24 | 180 | 196 | 376 | ||||||||||||||||||||||||||||||||||
713846 | 713846 | CO | school | 806480 | 990 | WIDEFIELD 3 | 80648001120 | 4394 | JANITELL JUNIOR HIGH SCHOOL | Regular School | No | Middle | 06 | 08 | 2017 | grade_6 | 118 | 23 | 73 | 4 | 5 | 6 | 24 | 136 | 117 | 253 | 118 | 23 | 73 | 4 | 5 | 6 | 24 | 136 | 117 | 253 | ||||||||||||||||||||||||||||||||||
714304 | 714304 | CO | school | 803060 | 1010 | COLORADO SPRINGS 11 | 80306000263 | 7523 | RUSSELL MIDDLE SCHOOL | Regular School | No | Middle | 06 | 08 | 2017 | grade_6 | 105 | 13 | 60 | 0 | 4 | 0 | 24 | 100 | 106 | 206 | 105 | 13 | 60 | 0 | 4 | 0 | 24 | 100 | 106 | 206 |
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]);