enrollments
Data source: Big Local News · About: Big Local
13,072 rows where state = "CO" and year = 2016 sorted by unknown_gender_int
This data as json, CSV (advanced)
grade ✖
- pk_12_total 1,849
- grade_4 1,067
- grade_1 1,066
- grade_2 1,065
- grade_3 1,062
- grade_5 1,059
- kindergarten_full_day 958
- grade_6 702
- pre_kindergarten 623
- grade_7 580
- grade_8 579
- grade_10 477
- grade_12 475
- grade_11 474
- grade_9 474
- kindergarten_half_day 462
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
835587 | 835587 | CO | school | 10 | MAPLETON 1 | 507 | ADVENTURE ELEMENTARY | 2016 | grade_2 | 4 | 0 | 38 | 0 | 0 | 0 | 2 | 21 | 23 | 44 | 4 | 0 | 38 | 0 | 0 | 0 | 2 | 21 | 23 | 44 | |||||||||||||||||||||||||||||||||||||||||
835588 | 835588 | CO | school | 10 | MAPLETON 1 | 507 | ADVENTURE ELEMENTARY | 2016 | grade_3 | 9 | 0 | 35 | 1 | 0 | 0 | 2 | 20 | 27 | 47 | 9 | 0 | 35 | 1 | 0 | 0 | 2 | 20 | 27 | 47 | |||||||||||||||||||||||||||||||||||||||||
835589 | 835589 | CO | school | 10 | MAPLETON 1 | 507 | ADVENTURE ELEMENTARY | 2016 | grade_4 | 3 | 0 | 39 | 0 | 0 | 0 | 0 | 21 | 21 | 42 | 3 | 0 | 39 | 0 | 0 | 0 | 0 | 21 | 21 | 42 | |||||||||||||||||||||||||||||||||||||||||
835590 | 835590 | CO | school | 10 | MAPLETON 1 | 507 | ADVENTURE ELEMENTARY | 2016 | grade_5 | 3 | 0 | 35 | 1 | 1 | 0 | 1 | 25 | 16 | 41 | 3 | 0 | 35 | 1 | 1 | 0 | 1 | 25 | 16 | 41 | |||||||||||||||||||||||||||||||||||||||||
835591 | 835591 | CO | school | 10 | MAPLETON 1 | 507 | ADVENTURE ELEMENTARY | 2016 | grade_6 | 6 | 0 | 45 | 0 | 0 | 0 | 1 | 24 | 28 | 52 | 6 | 0 | 45 | 0 | 0 | 0 | 1 | 24 | 28 | 52 | |||||||||||||||||||||||||||||||||||||||||
835592 | 835592 | CO | school | 10 | MAPLETON 1 | 507 | ADVENTURE ELEMENTARY | 2016 | kindergarten_full_day | 5 | 0 | 39 | 1 | 0 | 0 | 2 | 28 | 19 | 47 | 5 | 0 | 39 | 1 | 0 | 0 | 2 | 28 | 19 | 47 | |||||||||||||||||||||||||||||||||||||||||
835593 | 835593 | CO | school | 10 | MAPLETON 1 | 507 | ADVENTURE ELEMENTARY | 2016 | pk_12_total | 49 | 1 | 335 | 3 | 1 | 1 | 9 | 208 | 191 | 399 | 49 | 1 | 335 | 3 | 1 | 1 | 9 | 208 | 191 | 399 | |||||||||||||||||||||||||||||||||||||||||
835594 | 835594 | CO | school | 10 | MAPLETON 1 | 507 | ADVENTURE ELEMENTARY | 2016 | pre_kindergarten | 12 | 0 | 57 | 0 | 0 | 0 | 0 | 34 | 35 | 69 | 12 | 0 | 57 | 0 | 0 | 0 | 0 | 34 | 35 | 69 | |||||||||||||||||||||||||||||||||||||||||
835595 | 835595 | CO | school | 10 | MAPLETON 1 | 509 | CLAYTON PARTNERSHIP SCHOOL | 2016 | grade_1 | 9 | 1 | 32 | 0 | 4 | 0 | 3 | 29 | 20 | 49 | 9 | 1 | 32 | 0 | 4 | 0 | 3 | 29 | 20 | 49 | |||||||||||||||||||||||||||||||||||||||||
835596 | 835596 | CO | school | 10 | MAPLETON 1 | 509 | CLAYTON PARTNERSHIP SCHOOL | 2016 | grade_2 | 8 | 2 | 45 | 0 | 2 | 1 | 1 | 33 | 26 | 59 | 8 | 2 | 45 | 0 | 2 | 1 | 1 | 33 | 26 | 59 | |||||||||||||||||||||||||||||||||||||||||
835597 | 835597 | CO | school | 10 | MAPLETON 1 | 509 | CLAYTON PARTNERSHIP SCHOOL | 2016 | grade_3 | 10 | 0 | 46 | 0 | 1 | 0 | 0 | 28 | 29 | 57 | 10 | 0 | 46 | 0 | 1 | 0 | 0 | 28 | 29 | 57 | |||||||||||||||||||||||||||||||||||||||||
835598 | 835598 | CO | school | 10 | MAPLETON 1 | 509 | CLAYTON PARTNERSHIP SCHOOL | 2016 | grade_4 | 8 | 1 | 37 | 0 | 3 | 0 | 1 | 22 | 28 | 50 | 8 | 1 | 37 | 0 | 3 | 0 | 1 | 22 | 28 | 50 | |||||||||||||||||||||||||||||||||||||||||
835599 | 835599 | CO | school | 10 | MAPLETON 1 | 509 | CLAYTON PARTNERSHIP SCHOOL | 2016 | grade_5 | 10 | 2 | 37 | 0 | 2 | 0 | 1 | 27 | 25 | 52 | 10 | 2 | 37 | 0 | 2 | 0 | 1 | 27 | 25 | 52 | |||||||||||||||||||||||||||||||||||||||||
835600 | 835600 | CO | school | 10 | MAPLETON 1 | 509 | CLAYTON PARTNERSHIP SCHOOL | 2016 | grade_6 | 14 | 1 | 34 | 0 | 1 | 0 | 0 | 25 | 25 | 50 | 14 | 1 | 34 | 0 | 1 | 0 | 0 | 25 | 25 | 50 | |||||||||||||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||||||||||||
835603 | 835603 | CO | school | 10 | MAPLETON 1 | 509 | CLAYTON PARTNERSHIP SCHOOL | 2016 | kindergarten_full_day | 6 | 0 | 30 | 0 | 1 | 0 | 1 | 15 | 23 | 38 | 6 | 0 | 30 | 0 | 1 | 0 | 1 | 15 | 23 | 38 | |||||||||||||||||||||||||||||||||||||||||
835604 | 835604 | CO | school | 10 | MAPLETON 1 | 509 | CLAYTON PARTNERSHIP SCHOOL | 2016 | pk_12_total | 85 | 11 | 341 | 1 | 19 | 1 | 15 | 237 | 236 | 473 | 85 | 11 | 341 | 1 | 19 | 1 | 15 | 237 | 236 | 473 | |||||||||||||||||||||||||||||||||||||||||
835605 | 835605 | CO | school | 805550 | 10 | MAPLETON 1 | 80555006488 | 1796 | COLORADO CONNECTIONS ACADEMY | Regular School | No | 4.0 | KG | 12 | 2016 | grade_1 | 48 | 1 | 25 | 0 | 2 | 0 | 5 | 47 | 34 | 81 | 48 | 1 | 25 | 0 | 2 | 0 | 5 | 47 | 34 | 81 | ||||||||||||||||||||||||||||||||||
835606 | 835606 | CO | school | 805550 | 10 | MAPLETON 1 | 80555006488 | 1796 | COLORADO CONNECTIONS ACADEMY | Regular School | No | 4.0 | KG | 12 | 2016 | grade_10 | 201 | 7 | 66 | 2 | 6 | 3 | 16 | 124 | 177 | 301 | 201 | 7 | 66 | 2 | 6 | 3 | 16 | 124 | 177 | 301 | ||||||||||||||||||||||||||||||||||
835607 | 835607 | CO | school | 805550 | 10 | MAPLETON 1 | 80555006488 | 1796 | COLORADO CONNECTIONS ACADEMY | Regular School | No | 4.0 | KG | 12 | 2016 | grade_11 | 191 | 6 | 41 | 2 | 1 | 2 | 17 | 91 | 169 | 260 | 191 | 6 | 41 | 2 | 1 | 2 | 17 | 91 | 169 | 260 | ||||||||||||||||||||||||||||||||||
835608 | 835608 | CO | school | 805550 | 10 | MAPLETON 1 | 80555006488 | 1796 | COLORADO CONNECTIONS ACADEMY | Regular School | No | 4.0 | KG | 12 | 2016 | grade_12 | 155 | 2 | 36 | 2 | 6 | 1 | 17 | 92 | 127 | 219 | 155 | 2 | 36 | 2 | 6 | 1 | 17 | 92 | 127 | 219 | ||||||||||||||||||||||||||||||||||
835609 | 835609 | CO | school | 805550 | 10 | MAPLETON 1 | 80555006488 | 1796 | COLORADO CONNECTIONS ACADEMY | Regular School | No | 4.0 | KG | 12 | 2016 | grade_2 | 54 | 5 | 21 | 0 | 1 | 0 | 7 | 55 | 33 | 88 | 54 | 5 | 21 | 0 | 1 | 0 | 7 | 55 | 33 | 88 | ||||||||||||||||||||||||||||||||||
835610 | 835610 | CO | school | 805550 | 10 | MAPLETON 1 | 80555006488 | 1796 | COLORADO CONNECTIONS ACADEMY | Regular School | No | 4.0 | KG | 12 | 2016 | grade_3 | 78 | 5 | 17 | 0 | 2 | 1 | 5 | 58 | 50 | 108 | 78 | 5 | 17 | 0 | 2 | 1 | 5 | 58 | 50 | 108 | ||||||||||||||||||||||||||||||||||
835611 | 835611 | CO | school | 805550 | 10 | MAPLETON 1 | 80555006488 | 1796 | COLORADO CONNECTIONS ACADEMY | Regular School | No | 4.0 | KG | 12 | 2016 | grade_4 | 73 | 5 | 17 | 0 | 0 | 0 | 6 | 44 | 57 | 101 | 73 | 5 | 17 | 0 | 0 | 0 | 6 | 44 | 57 | 101 | ||||||||||||||||||||||||||||||||||
835612 | 835612 | CO | school | 805550 | 10 | MAPLETON 1 | 80555006488 | 1796 | COLORADO CONNECTIONS ACADEMY | Regular School | No | 4.0 | KG | 12 | 2016 | grade_5 | 84 | 7 | 16 | 1 | 7 | 0 | 5 | 57 | 63 | 120 | 84 | 7 | 16 | 1 | 7 | 0 | 5 | 57 | 63 | 120 | ||||||||||||||||||||||||||||||||||
835613 | 835613 | CO | school | 805550 | 10 | MAPLETON 1 | 80555006488 | 1796 | COLORADO CONNECTIONS ACADEMY | Regular School | No | 4.0 | KG | 12 | 2016 | grade_6 | 100 | 2 | 29 | 4 | 2 | 0 | 10 | 78 | 69 | 147 | 100 | 2 | 29 | 4 | 2 | 0 | 10 | 78 | 69 | 147 | ||||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||
835616 | 835616 | CO | school | 805550 | 10 | MAPLETON 1 | 80555006488 | 1796 | COLORADO CONNECTIONS ACADEMY | Regular School | No | 4.0 | KG | 12 | 2016 | grade_9 | 220 | 11 | 95 | 3 | 5 | 0 | 23 | 161 | 196 | 357 | 220 | 11 | 95 | 3 | 5 | 0 | 23 | 161 | 196 | 357 | ||||||||||||||||||||||||||||||||||
835617 | 835617 | CO | school | 805550 | 10 | MAPLETON 1 | 80555006488 | 1796 | COLORADO CONNECTIONS ACADEMY | Regular School | No | 4.0 | KG | 12 | 2016 | kindergarten_full_day | 50 | 1 | 24 | 1 | 1 | 0 | 8 | 36 | 49 | 85 | 50 | 1 | 24 | 1 | 1 | 0 | 8 | 36 | 49 | 85 | ||||||||||||||||||||||||||||||||||
835618 | 835618 | CO | school | 805550 | 10 | MAPLETON 1 | 80555006488 | 1796 | COLORADO CONNECTIONS ACADEMY | Regular School | No | 4.0 | KG | 12 | 2016 | pk_12_total | 1621 | 68 | 508 | 20 | 43 | 7 | 153 | 1116 | 1304 | 2420 | 1621 | 68 | 508 | 20 | 43 | 7 | 153 | 1116 | 1304 | 2420 | ||||||||||||||||||||||||||||||||||
835619 | 835619 | CO | school | 805550 | 10 | MAPLETON 1 | 80555006433 | 6315 | NORTH VALLEY SCHOOL FOR YOUNG ADULTS | Regular School | No | 3.0 | 09 | 12 | 2016 | grade_12 | 12 | 1 | 54 | 2 | 1 | 0 | 2 | 42 | 30 | 72 | 12 | 1 | 54 | 2 | 1 | 0 | 2 | 42 | 30 | 72 | ||||||||||||||||||||||||||||||||||
835620 | 835620 | CO | school | 805550 | 10 | MAPLETON 1 | 80555006433 | 6315 | NORTH VALLEY SCHOOL FOR YOUNG ADULTS | Regular School | No | 3.0 | 09 | 12 | 2016 | pk_12_total | 12 | 1 | 54 | 2 | 1 | 0 | 2 | 42 | 30 | 72 | 12 | 1 | 54 | 2 | 1 | 0 | 2 | 42 | 30 | 72 | ||||||||||||||||||||||||||||||||||
835621 | 835621 | CO | school | 805550 | 10 | MAPLETON 1 | 80555000959 | 9036 | VALLEY VIEW K-8 | Regular School | No | 1.0 | KG | 08 | 2016 | grade_1 | 11 | 0 | 39 | 0 | 0 | 0 | 0 | 20 | 30 | 50 | 11 | 0 | 39 | 0 | 0 | 0 | 0 | 20 | 30 | 50 | ||||||||||||||||||||||||||||||||||
835622 | 835622 | CO | school | 805550 | 10 | MAPLETON 1 | 80555000959 | 9036 | VALLEY VIEW K-8 | Regular School | No | 1.0 | KG | 08 | 2016 | grade_2 | 8 | 1 | 33 | 0 | 0 | 0 | 1 | 23 | 20 | 43 | 8 | 1 | 33 | 0 | 0 | 0 | 1 | 23 | 20 | 43 | ||||||||||||||||||||||||||||||||||
835623 | 835623 | CO | school | 805550 | 10 | MAPLETON 1 | 80555000959 | 9036 | VALLEY VIEW K-8 | Regular School | No | 1.0 | KG | 08 | 2016 | grade_3 | 6 | 0 | 42 | 0 | 0 | 0 | 2 | 23 | 27 | 50 | 6 | 0 | 42 | 0 | 0 | 0 | 2 | 23 | 27 | 50 | ||||||||||||||||||||||||||||||||||
835624 | 835624 | CO | school | 805550 | 10 | MAPLETON 1 | 80555000959 | 9036 | VALLEY VIEW K-8 | Regular School | No | 1.0 | KG | 08 | 2016 | grade_4 | 4 | 0 | 44 | 1 | 0 | 0 | 1 | 28 | 22 | 50 | 4 | 0 | 44 | 1 | 0 | 0 | 1 | 28 | 22 | 50 | ||||||||||||||||||||||||||||||||||
835625 | 835625 | CO | school | 805550 | 10 | MAPLETON 1 | 80555000959 | 9036 | VALLEY VIEW K-8 | Regular School | No | 1.0 | KG | 08 | 2016 | grade_5 | 7 | 0 | 49 | 0 | 0 | 1 | 1 | 28 | 30 | 58 | 7 | 0 | 49 | 0 | 0 | 1 | 1 | 28 | 30 | 58 | ||||||||||||||||||||||||||||||||||
835626 | 835626 | CO | school | 805550 | 10 | MAPLETON 1 | 80555000959 | 9036 | VALLEY VIEW K-8 | Regular School | No | 1.0 | KG | 08 | 2016 | grade_6 | 8 | 0 | 48 | 0 | 1 | 0 | 2 | 30 | 29 | 59 | 8 | 0 | 48 | 0 | 1 | 0 | 2 | 30 | 29 | 59 | ||||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||
835629 | 835629 | CO | school | 805550 | 10 | MAPLETON 1 | 80555000959 | 9036 | VALLEY VIEW K-8 | Regular School | No | 1.0 | KG | 08 | 2016 | kindergarten_full_day | 5 | 0 | 29 | 0 | 0 | 0 | 0 | 15 | 19 | 34 | 5 | 0 | 29 | 0 | 0 | 0 | 0 | 15 | 19 | 34 | ||||||||||||||||||||||||||||||||||
835630 | 835630 | CO | school | 805550 | 10 | MAPLETON 1 | 80555000959 | 9036 | VALLEY VIEW K-8 | Regular School | No | 1.0 | KG | 08 | 2016 | pk_12_total | 59 | 1 | 376 | 4 | 2 | 1 | 9 | 216 | 236 | 452 | 59 | 1 | 376 | 4 | 2 | 1 | 9 | 216 | 236 | 452 | ||||||||||||||||||||||||||||||||||
835631 | 835631 | CO | school | 20 | ADAMS 12 FIVE STAR SCHOOLS | 14 | GLACIER PEAK ELEMENTARY SCHOOL | 2016 | grade_1 | 38 | 0 | 29 | 1 | 4 | 1 | 5 | 49 | 29 | 78 | 38 | 0 | 29 | 1 | 4 | 1 | 5 | 49 | 29 | 78 | |||||||||||||||||||||||||||||||||||||||||
835632 | 835632 | CO | school | 20 | ADAMS 12 FIVE STAR SCHOOLS | 14 | GLACIER PEAK ELEMENTARY SCHOOL | 2016 | grade_2 | 40 | 2 | 33 | 1 | 5 | 0 | 3 | 37 | 47 | 84 | 40 | 2 | 33 | 1 | 5 | 0 | 3 | 37 | 47 | 84 | |||||||||||||||||||||||||||||||||||||||||
835633 | 835633 | CO | school | 20 | ADAMS 12 FIVE STAR SCHOOLS | 14 | GLACIER PEAK ELEMENTARY SCHOOL | 2016 | grade_3 | 59 | 3 | 26 | 0 | 2 | 0 | 7 | 59 | 38 | 97 | 59 | 3 | 26 | 0 | 2 | 0 | 7 | 59 | 38 | 97 | |||||||||||||||||||||||||||||||||||||||||
835634 | 835634 | CO | school | 20 | ADAMS 12 FIVE STAR SCHOOLS | 14 | GLACIER PEAK ELEMENTARY SCHOOL | 2016 | grade_4 | 51 | 0 | 37 | 0 | 0 | 0 | 0 | 44 | 44 | 88 | 51 | 0 | 37 | 0 | 0 | 0 | 0 | 44 | 44 | 88 | |||||||||||||||||||||||||||||||||||||||||
835635 | 835635 | CO | school | 20 | ADAMS 12 FIVE STAR SCHOOLS | 14 | GLACIER PEAK ELEMENTARY SCHOOL | 2016 | grade_5 | 53 | 1 | 37 | 0 | 5 | 1 | 6 | 51 | 52 | 103 | 53 | 1 | 37 | 0 | 5 | 1 | 6 | 51 | 52 | 103 | |||||||||||||||||||||||||||||||||||||||||
835636 | 835636 | CO | school | 20 | ADAMS 12 FIVE STAR SCHOOLS | 14 | GLACIER PEAK ELEMENTARY SCHOOL | 2016 | kindergarten_full_day | 14 | 0 | 9 | 0 | 0 | 0 | 1 | 18 | 6 | 24 | 14 | 0 | 9 | 0 | 0 | 0 | 1 | 18 | 6 | 24 | |||||||||||||||||||||||||||||||||||||||||
835637 | 835637 | CO | school | 20 | ADAMS 12 FIVE STAR SCHOOLS | 14 | GLACIER PEAK ELEMENTARY SCHOOL | 2016 | kindergarten_half_day | 22 | 0 | 12 | 0 | 3 | 0 | 2 | 22 | 17 | 39 | 22 | 0 | 12 | 0 | 3 | 0 | 2 | 22 | 17 | 39 | |||||||||||||||||||||||||||||||||||||||||
835638 | 835638 | CO | school | 20 | ADAMS 12 FIVE STAR SCHOOLS | 14 | GLACIER PEAK ELEMENTARY SCHOOL | 2016 | pk_12_total | 277 | 6 | 183 | 2 | 19 | 2 | 24 | 280 | 233 | 513 | 277 | 6 | 183 | 2 | 19 | 2 | 24 | 280 | 233 | 513 | |||||||||||||||||||||||||||||||||||||||||
835639 | 835639 | CO | school | 20 | ADAMS 12 FIVE STAR SCHOOLS | 57 | ROCKY TOP MIDDLE SCHOOL | 2016 | grade_6 | 340 | 7 | 90 | 1 | 22 | 0 | 11 | 247 | 224 | 471 | 340 | 7 | 90 | 1 | 22 | 0 | 11 | 247 | 224 | 471 | |||||||||||||||||||||||||||||||||||||||||
835640 | 835640 | CO | school | 20 | ADAMS 12 FIVE STAR SCHOOLS | 57 | ROCKY TOP MIDDLE SCHOOL | 2016 | grade_7 | 310 | 3 | 75 | 2 | 30 | 0 | 11 | 226 | 205 | 431 | 310 | 3 | 75 | 2 | 30 | 0 | 11 | 226 | 205 | 431 | |||||||||||||||||||||||||||||||||||||||||
835641 | 835641 | CO | school | 20 | ADAMS 12 FIVE STAR SCHOOLS | 57 | ROCKY TOP MIDDLE SCHOOL | 2016 | grade_8 | 338 | 6 | 80 | 1 | 24 | 1 | 4 | 231 | 223 | 454 | 338 | 6 | 80 | 1 | 24 | 1 | 4 | 231 | 223 | 454 | |||||||||||||||||||||||||||||||||||||||||
835642 | 835642 | CO | school | 20 | ADAMS 12 FIVE STAR SCHOOLS | 57 | ROCKY TOP MIDDLE SCHOOL | 2016 | pk_12_total | 988 | 16 | 245 | 4 | 76 | 1 | 26 | 704 | 652 | 1356 | 988 | 16 | 245 | 4 | 76 | 1 | 26 | 704 | 652 | 1356 | |||||||||||||||||||||||||||||||||||||||||
835643 | 835643 | CO | school | 20 | ADAMS 12 FIVE STAR SCHOOLS | 59 | MERIDIAN ELEMENTARY SCHOOL | 2016 | grade_1 | 87 | 2 | 11 | 1 | 7 | 0 | 4 | 64 | 48 | 112 | 87 | 2 | 11 | 1 | 7 | 0 | 4 | 64 | 48 | 112 | |||||||||||||||||||||||||||||||||||||||||
835644 | 835644 | CO | school | 20 | ADAMS 12 FIVE STAR SCHOOLS | 59 | MERIDIAN ELEMENTARY SCHOOL | 2016 | grade_2 | 99 | 2 | 14 | 0 | 6 | 0 | 6 | 61 | 66 | 127 | 99 | 2 | 14 | 0 | 6 | 0 | 6 | 61 | 66 | 127 | |||||||||||||||||||||||||||||||||||||||||
835645 | 835645 | CO | school | 20 | ADAMS 12 FIVE STAR SCHOOLS | 59 | MERIDIAN ELEMENTARY SCHOOL | 2016 | grade_3 | 95 | 3 | 9 | 0 | 17 | 1 | 5 | 60 | 70 | 130 | 95 | 3 | 9 | 0 | 17 | 1 | 5 | 60 | 70 | 130 | |||||||||||||||||||||||||||||||||||||||||
835646 | 835646 | CO | school | 20 | ADAMS 12 FIVE STAR SCHOOLS | 59 | MERIDIAN ELEMENTARY SCHOOL | 2016 | grade_4 | 119 | 1 | 14 | 0 | 6 | 0 | 4 | 85 | 59 | 144 | 119 | 1 | 14 | 0 | 6 | 0 | 4 | 85 | 59 | 144 | |||||||||||||||||||||||||||||||||||||||||
835647 | 835647 | CO | school | 20 | ADAMS 12 FIVE STAR SCHOOLS | 59 | MERIDIAN ELEMENTARY SCHOOL | 2016 | grade_5 | 107 | 3 | 17 | 1 | 7 | 0 | 10 | 69 | 76 | 145 | 107 | 3 | 17 | 1 | 7 | 0 | 10 | 69 | 76 | 145 | |||||||||||||||||||||||||||||||||||||||||
835648 | 835648 | CO | school | 20 | ADAMS 12 FIVE STAR SCHOOLS | 59 | MERIDIAN ELEMENTARY SCHOOL | 2016 | kindergarten_full_day | 70 | 4 | 9 | 0 | 4 | 0 | 1 | 43 | 45 | 88 | 70 | 4 | 9 | 0 | 4 | 0 | 1 | 43 | 45 | 88 | |||||||||||||||||||||||||||||||||||||||||
835649 | 835649 | CO | school | 20 | ADAMS 12 FIVE STAR SCHOOLS | 59 | MERIDIAN ELEMENTARY SCHOOL | 2016 | kindergarten_half_day | 16 | 0 | 5 | 0 | 1 | 0 | 3 | 14 | 11 | 25 | 16 | 0 | 5 | 0 | 1 | 0 | 3 | 14 | 11 | 25 | |||||||||||||||||||||||||||||||||||||||||
835650 | 835650 | CO | school | 20 | ADAMS 12 FIVE STAR SCHOOLS | 59 | MERIDIAN ELEMENTARY SCHOOL | 2016 | pk_12_total | 593 | 15 | 79 | 2 | 48 | 1 | 33 | 396 | 375 | 771 | 593 | 15 | 79 | 2 | 48 | 1 | 33 | 396 | 375 | 771 | |||||||||||||||||||||||||||||||||||||||||
835651 | 835651 | CO | school | 20 | ADAMS 12 FIVE STAR SCHOOLS | 70 | ADAMS12 FIVE STAR PRESCHOOL | 2016 | pk_12_total | 388 | 22 | 560 | 1 | 53 | 2 | 26 | 581 | 471 | 1052 | 388 | 22 | 560 | 1 | 53 | 2 | 26 | 581 | 471 | 1052 | |||||||||||||||||||||||||||||||||||||||||
835652 | 835652 | CO | school | 20 | ADAMS 12 FIVE STAR SCHOOLS | 70 | ADAMS12 FIVE STAR PRESCHOOL | 2016 | pre_kindergarten | 388 | 22 | 560 | 1 | 53 | 2 | 26 | 581 | 471 | 1052 | 388 | 22 | 560 | 1 | 53 | 2 | 26 | 581 | 471 | 1052 | |||||||||||||||||||||||||||||||||||||||||
835653 | 835653 | CO | school | 20 | ADAMS 12 FIVE STAR SCHOOLS | 210 | VANTAGE POINT | 2016 | grade_10 | 15 | 1 | 21 | 0 | 0 | 0 | 0 | 25 | 12 | 37 | 15 | 1 | 21 | 0 | 0 | 0 | 0 | 25 | 12 | 37 | |||||||||||||||||||||||||||||||||||||||||
835654 | 835654 | CO | school | 20 | ADAMS 12 FIVE STAR SCHOOLS | 210 | VANTAGE POINT | 2016 | grade_11 | 51 | 2 | 54 | 1 | 3 | 0 | 2 | 58 | 55 | 113 | 51 | 2 | 54 | 1 | 3 | 0 | 2 | 58 | 55 | 113 | |||||||||||||||||||||||||||||||||||||||||
835655 | 835655 | CO | school | 20 | ADAMS 12 FIVE STAR SCHOOLS | 210 | VANTAGE POINT | 2016 | grade_12 | 35 | 1 | 38 | 3 | 1 | 0 | 0 | 38 | 40 | 78 | 35 | 1 | 38 | 3 | 1 | 0 | 0 | 38 | 40 | 78 | |||||||||||||||||||||||||||||||||||||||||
835656 | 835656 | CO | school | 20 | ADAMS 12 FIVE STAR SCHOOLS | 210 | VANTAGE POINT | 2016 | grade_6 | 1 | 0 | 1 | 0 | 0 | 0 | 0 | 2 | 0 | 2 | 1 | 0 | 1 | 0 | 0 | 0 | 0 | 2 | 0 | 2 | |||||||||||||||||||||||||||||||||||||||||
835657 | 835657 | CO | school | 20 | ADAMS 12 FIVE STAR SCHOOLS | 210 | VANTAGE POINT | 2016 | grade_7 | 4 | 1 | 3 | 0 | 0 | 0 | 1 | 8 | 1 | 9 | 4 | 1 | 3 | 0 | 0 | 0 | 1 | 8 | 1 | 9 | |||||||||||||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||||||||||||
835659 | 835659 | CO | school | 20 | ADAMS 12 FIVE STAR SCHOOLS | 210 | VANTAGE POINT | 2016 | grade_9 | 4 | 1 | 5 | 0 | 0 | 0 | 0 | 7 | 3 | 10 | 4 | 1 | 5 | 0 | 0 | 0 | 0 | 7 | 3 | 10 | |||||||||||||||||||||||||||||||||||||||||
835660 | 835660 | CO | school | 20 | ADAMS 12 FIVE STAR SCHOOLS | 210 | VANTAGE POINT | 2016 | pk_12_total | 124 | 6 | 138 | 4 | 4 | 0 | 3 | 159 | 120 | 279 | 124 | 6 | 138 | 4 | 4 | 0 | 3 | 159 | 120 | 279 | |||||||||||||||||||||||||||||||||||||||||
835661 | 835661 | CO | school | 20 | ADAMS 12 FIVE STAR SCHOOLS | 301 | ARAPAHOE RIDGE ELEMENTARY SCHOOL | 2016 | grade_1 | 50 | 3 | 41 | 0 | 4 | 0 | 4 | 46 | 56 | 102 | 50 | 3 | 41 | 0 | 4 | 0 | 4 | 46 | 56 | 102 | |||||||||||||||||||||||||||||||||||||||||
835662 | 835662 | CO | school | 20 | ADAMS 12 FIVE STAR SCHOOLS | 301 | ARAPAHOE RIDGE ELEMENTARY SCHOOL | 2016 | grade_2 | 70 | 0 | 31 | 0 | 4 | 1 | 3 | 63 | 46 | 109 | 70 | 0 | 31 | 0 | 4 | 1 | 3 | 63 | 46 | 109 | |||||||||||||||||||||||||||||||||||||||||
835663 | 835663 | CO | school | 20 | ADAMS 12 FIVE STAR SCHOOLS | 301 | ARAPAHOE RIDGE ELEMENTARY SCHOOL | 2016 | grade_3 | 70 | 2 | 29 | 0 | 5 | 0 | 10 | 54 | 62 | 116 | 70 | 2 | 29 | 0 | 5 | 0 | 10 | 54 | 62 | 116 | |||||||||||||||||||||||||||||||||||||||||
835664 | 835664 | CO | school | 20 | ADAMS 12 FIVE STAR SCHOOLS | 301 | ARAPAHOE RIDGE ELEMENTARY SCHOOL | 2016 | grade_4 | 77 | 1 | 29 | 0 | 3 | 0 | 4 | 71 | 43 | 114 | 77 | 1 | 29 | 0 | 3 | 0 | 4 | 71 | 43 | 114 | |||||||||||||||||||||||||||||||||||||||||
835665 | 835665 | CO | school | 20 | ADAMS 12 FIVE STAR SCHOOLS | 301 | ARAPAHOE RIDGE ELEMENTARY SCHOOL | 2016 | grade_5 | 51 | 2 | 34 | 1 | 6 | 0 | 3 | 58 | 39 | 97 | 51 | 2 | 34 | 1 | 6 | 0 | 3 | 58 | 39 | 97 | |||||||||||||||||||||||||||||||||||||||||
835666 | 835666 | CO | school | 20 | ADAMS 12 FIVE STAR SCHOOLS | 301 | ARAPAHOE RIDGE ELEMENTARY SCHOOL | 2016 | kindergarten_full_day | 33 | 1 | 7 | 1 | 0 | 1 | 3 | 21 | 25 | 46 | 33 | 1 | 7 | 1 | 0 | 1 | 3 | 21 | 25 | 46 | |||||||||||||||||||||||||||||||||||||||||
835667 | 835667 | CO | school | 20 | ADAMS 12 FIVE STAR SCHOOLS | 301 | ARAPAHOE RIDGE ELEMENTARY SCHOOL | 2016 | kindergarten_half_day | 25 | 0 | 21 | 0 | 1 | 0 | 3 | 28 | 22 | 50 | 25 | 0 | 21 | 0 | 1 | 0 | 3 | 28 | 22 | 50 | |||||||||||||||||||||||||||||||||||||||||
835668 | 835668 | CO | school | 20 | ADAMS 12 FIVE STAR SCHOOLS | 301 | ARAPAHOE RIDGE ELEMENTARY SCHOOL | 2016 | pk_12_total | 376 | 9 | 192 | 2 | 23 | 2 | 30 | 341 | 293 | 634 | 376 | 9 | 192 | 2 | 23 | 2 | 30 | 341 | 293 | 634 | |||||||||||||||||||||||||||||||||||||||||
835669 | 835669 | CO | school | 806900 | 20 | ADAMS 12 FIVE STAR SCHOOLS | 80690000382 | 1020 | BRIGHT HORIZONS PRE-KINDERGARTEN SCHOOL | Regular School | No | 1.0 | PK | PK | 2016 | pk_12_total | 25 | 1 | 4 | 0 | 0 | 0 | 0 | 15 | 15 | 30 | 25 | 1 | 4 | 0 | 0 | 0 | 0 | 15 | 15 | 30 | ||||||||||||||||||||||||||||||||||
835670 | 835670 | CO | school | 806900 | 20 | ADAMS 12 FIVE STAR SCHOOLS | 80690000382 | 1020 | BRIGHT HORIZONS PRE-KINDERGARTEN SCHOOL | Regular School | No | 1.0 | PK | PK | 2016 | pre_kindergarten | 25 | 1 | 4 | 0 | 0 | 0 | 0 | 15 | 15 | 30 | 25 | 1 | 4 | 0 | 0 | 0 | 0 | 15 | 15 | 30 | ||||||||||||||||||||||||||||||||||
835671 | 835671 | CO | school | 806900 | 20 | ADAMS 12 FIVE STAR SCHOOLS | 80690001173 | 1388 | CENTENNIAL ELEMENTARY SCHOOL | Regular School | No | 1.0 | PK | 05 | 2016 | grade_1 | 33 | 0 | 22 | 0 | 1 | 0 | 3 | 26 | 33 | 59 | 33 | 0 | 22 | 0 | 1 | 0 | 3 | 26 | 33 | 59 | ||||||||||||||||||||||||||||||||||
835672 | 835672 | CO | school | 806900 | 20 | ADAMS 12 FIVE STAR SCHOOLS | 80690001173 | 1388 | CENTENNIAL ELEMENTARY SCHOOL | Regular School | No | 1.0 | PK | 05 | 2016 | grade_2 | 38 | 1 | 40 | 2 | 1 | 0 | 1 | 46 | 37 | 83 | 38 | 1 | 40 | 2 | 1 | 0 | 1 | 46 | 37 | 83 | ||||||||||||||||||||||||||||||||||
835673 | 835673 | CO | school | 806900 | 20 | ADAMS 12 FIVE STAR SCHOOLS | 80690001173 | 1388 | CENTENNIAL ELEMENTARY SCHOOL | Regular School | No | 1.0 | PK | 05 | 2016 | grade_3 | 26 | 2 | 38 | 2 | 4 | 0 | 1 | 35 | 38 | 73 | 26 | 2 | 38 | 2 | 4 | 0 | 1 | 35 | 38 | 73 | ||||||||||||||||||||||||||||||||||
835674 | 835674 | CO | school | 806900 | 20 | ADAMS 12 FIVE STAR SCHOOLS | 80690001173 | 1388 | CENTENNIAL ELEMENTARY SCHOOL | Regular School | No | 1.0 | PK | 05 | 2016 | grade_4 | 32 | 1 | 36 | 0 | 3 | 0 | 0 | 38 | 34 | 72 | 32 | 1 | 36 | 0 | 3 | 0 | 0 | 38 | 34 | 72 | ||||||||||||||||||||||||||||||||||
835675 | 835675 | CO | school | 806900 | 20 | ADAMS 12 FIVE STAR SCHOOLS | 80690001173 | 1388 | CENTENNIAL ELEMENTARY SCHOOL | Regular School | No | 1.0 | PK | 05 | 2016 | grade_5 | 37 | 2 | 36 | 0 | 2 | 0 | 4 | 44 | 37 | 81 | 37 | 2 | 36 | 0 | 2 | 0 | 4 | 44 | 37 | 81 | ||||||||||||||||||||||||||||||||||
835676 | 835676 | CO | school | 806900 | 20 | ADAMS 12 FIVE STAR SCHOOLS | 80690001173 | 1388 | CENTENNIAL ELEMENTARY SCHOOL | Regular School | No | 1.0 | PK | 05 | 2016 | kindergarten_half_day | 20 | 0 | 29 | 0 | 3 | 0 | 2 | 27 | 27 | 54 | 20 | 0 | 29 | 0 | 3 | 0 | 2 | 27 | 27 | 54 | ||||||||||||||||||||||||||||||||||
835677 | 835677 | CO | school | 806900 | 20 | ADAMS 12 FIVE STAR SCHOOLS | 80690001173 | 1388 | CENTENNIAL ELEMENTARY SCHOOL | Regular School | No | 1.0 | PK | 05 | 2016 | pk_12_total | 186 | 6 | 201 | 4 | 14 | 0 | 11 | 216 | 206 | 422 | 186 | 6 | 201 | 4 | 14 | 0 | 11 | 216 | 206 | 422 | ||||||||||||||||||||||||||||||||||
835678 | 835678 | CO | school | 806900 | 20 | ADAMS 12 FIVE STAR SCHOOLS | 80690001620 | 1480 | CENTURY MIDDLE SCHOOL | Regular School | No | 2.0 | 06 | 08 | 2016 | grade_6 | 216 | 7 | 88 | 4 | 16 | 0 | 9 | 166 | 174 | 340 | 216 | 7 | 88 | 4 | 16 | 0 | 9 | 166 | 174 | 340 | ||||||||||||||||||||||||||||||||||
835679 | 835679 | CO | school | 806900 | 20 | ADAMS 12 FIVE STAR SCHOOLS | 80690001620 | 1480 | CENTURY MIDDLE SCHOOL | Regular School | No | 2.0 | 06 | 08 | 2016 | grade_7 | 225 | 14 | 93 | 2 | 13 | 0 | 4 | 173 | 178 | 351 | 225 | 14 | 93 | 2 | 13 | 0 | 4 | 173 | 178 | 351 | ||||||||||||||||||||||||||||||||||
835680 | 835680 | CO | school | 806900 | 20 | ADAMS 12 FIVE STAR SCHOOLS | 80690001620 | 1480 | CENTURY MIDDLE SCHOOL | Regular School | No | 2.0 | 06 | 08 | 2016 | grade_8 | 223 | 11 | 109 | 6 | 14 | 1 | 7 | 180 | 191 | 371 | 223 | 11 | 109 | 6 | 14 | 1 | 7 | 180 | 191 | 371 | ||||||||||||||||||||||||||||||||||
835681 | 835681 | CO | school | 806900 | 20 | ADAMS 12 FIVE STAR SCHOOLS | 80690001620 | 1480 | CENTURY MIDDLE SCHOOL | Regular School | No | 2.0 | 06 | 08 | 2016 | pk_12_total | 664 | 32 | 290 | 12 | 43 | 1 | 20 | 519 | 543 | 1062 | 664 | 32 | 290 | 12 | 43 | 1 | 20 | 519 | 543 | 1062 | ||||||||||||||||||||||||||||||||||
835682 | 835682 | CO | school | 806900 | 20 | ADAMS 12 FIVE STAR SCHOOLS | 80690000728 | 1519 | STARGATE CHARTER SCHOOL | Regular School | Yes | 4.0 | KG | 09 | 2016 | grade_1 | 58 | 2 | 10 | 1 | 18 | 0 | 8 | 50 | 47 | 97 | 58 | 2 | 10 | 1 | 18 | 0 | 8 | 50 | 47 | 97 | ||||||||||||||||||||||||||||||||||
835683 | 835683 | CO | school | 806900 | 20 | ADAMS 12 FIVE STAR SCHOOLS | 80690000728 | 1519 | STARGATE CHARTER SCHOOL | Regular School | Yes | 4.0 | KG | 09 | 2016 | grade_2 | 60 | 1 | 9 | 0 | 18 | 0 | 8 | 43 | 53 | 96 | 60 | 1 | 9 | 0 | 18 | 0 | 8 | 43 | 53 | 96 | ||||||||||||||||||||||||||||||||||
835684 | 835684 | CO | school | 806900 | 20 | ADAMS 12 FIVE STAR SCHOOLS | 80690000728 | 1519 | STARGATE CHARTER SCHOOL | Regular School | Yes | 4.0 | KG | 09 | 2016 | grade_3 | 59 | 0 | 9 | 1 | 20 | 0 | 9 | 44 | 54 | 98 | 59 | 0 | 9 | 1 | 20 | 0 | 9 | 44 | 54 | 98 | ||||||||||||||||||||||||||||||||||
835685 | 835685 | CO | school | 806900 | 20 | ADAMS 12 FIVE STAR SCHOOLS | 80690000728 | 1519 | STARGATE CHARTER SCHOOL | Regular School | Yes | 4.0 | KG | 09 | 2016 | grade_4 | 63 | 0 | 11 | 1 | 14 | 1 | 2 | 41 | 51 | 92 | 63 | 0 | 11 | 1 | 14 | 1 | 2 | 41 | 51 | 92 | ||||||||||||||||||||||||||||||||||
835686 | 835686 | CO | school | 806900 | 20 | ADAMS 12 FIVE STAR SCHOOLS | 80690000728 | 1519 | STARGATE CHARTER SCHOOL | Regular School | Yes | 4.0 | KG | 09 | 2016 | grade_5 | 55 | 0 | 5 | 1 | 11 | 0 | 3 | 37 | 38 | 75 | 55 | 0 | 5 | 1 | 11 | 0 | 3 | 37 | 38 | 75 |
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]);