enrollments
Data source: Big Local News · About: Big Local
694 rows where grade = "grade_6", state = "CO" and year = 2021 sorted by total
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1741613 | 1741613 | CO | school | 805100 | 550 | North Conejos RE-1J | 80510006601 | 6339 | North Conejos Alternative Program | Alternative School | No | Other | KG | 12 | 2021 | grade_6 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | ||||||||||||||||||||||||||||||||||
1746622 | 1746622 | CO | school | 804800 | 1420 | Jefferson County R-1 | 80480006306 | 4798 | Connections Learning Center on the Earle Johnson Campus | Alternative School | No | Middle | 06 | 08 | 2021 | grade_6 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | ||||||||||||||||||||||||||||||||||
1742606 | 1742606 | CO | school | 803360 | 880 | Denver County 1 | 80336000375 | 5158 | Lincoln Elementary School | Regular School | No | Elementary | PK | 06 | 2021 | grade_6 | 6 | 0 | 3 | 0 | 0 | 0 | 1 | 8 | 2 | 10 | 6 | 0 | 3 | 0 | 0 | 0 | 1 | 8 | 2 | 10 | ||||||||||||||||||||||||||||||||||
1746530 | 1746530 | CO | school | 804800 | 1420 | Jefferson County R-1 | 80480006723 | 3691 | Great Work Montessori | Regular School | Yes | Elementary | PK | 06 | 2021 | grade_6 | 6 | 0 | 4 | 0 | 0 | 0 | 0 | 3 | 7 | 10 | 6 | 0 | 4 | 0 | 0 | 0 | 0 | 3 | 7 | 10 | ||||||||||||||||||||||||||||||||||
1747468 | 1747468 | CO | school | 803480 | 1520 | Durango 9-R | 80348006614 | 2097 | District 9-R Shared School | Regular School | No | Other | KG | 12 | 2021 | grade_6 | 8 | 1 | 1 | 0 | 0 | 0 | 0 | 5 | 5 | 10 | 8 | 1 | 1 | 0 | 0 | 0 | 0 | 5 | 5 | 10 | ||||||||||||||||||||||||||||||||||
1748436 | 1748436 | CO | school | 806030 | 1870 | Plateau RE-5 | 80603001022 | 6834 | Peetz Elementary School | Regular School | No | Elementary | PK | 06 | 2021 | grade_6 | 9 | 0 | 1 | 0 | 0 | 0 | 0 | 4 | 6 | 10 | 9 | 0 | 1 | 0 | 0 | 0 | 0 | 4 | 6 | 10 | ||||||||||||||||||||||||||||||||||
1749430 | 1749430 | CO | school | 804290 | 2650 | Granada RE-1 | 80429000592 | 3542 | Granada Elementary School | Regular School | No | Elementary | PK | 06 | 2021 | grade_6 | 1 | 0 | 9 | 0 | 0 | 0 | 0 | 3 | 7 | 10 | 1 | 0 | 9 | 0 | 0 | 0 | 0 | 3 | 7 | 10 | ||||||||||||||||||||||||||||||||||
1750819 | 1750819 | CO | school | 804410 | 3120 | Greeley 6 | 80441001483 | 5660 | S. Christa McAuliffe STEM Academy | Regular School | No | Elementary | KG | 08 | 2021 | grade_6 | 33 | 2 | 58 | 1 | 3 | 0 | 3 | 61 | 39 | 100 | 33 | 2 | 58 | 1 | 3 | 0 | 3 | 61 | 39 | 100 | ||||||||||||||||||||||||||||||||||
1740492 | 1740492 | CO | school | 802700 | 190 | Byers 32J | 80270006759 | 2793 | Astravo Academy Middle School | Regular School | Yes | Middle | 06 | 08 | 2021 | grade_6 | 83 | 4 | 13 | 0 | 1 | 0 | 0 | 53 | 48 | 101 | 83 | 4 | 13 | 0 | 1 | 0 | 0 | 53 | 48 | 101 | ||||||||||||||||||||||||||||||||||
1740835 | 1740835 | CO | school | 805370 | 470 | St Vrain Valley RE1J | 80537000901 | 3192 | Thunder Valley PK-8 | Regular School | No | Elementary | PK | 08 | 2021 | grade_6 | 38 | 0 | 56 | 0 | 3 | 1 | 3 | 57 | 44 | 101 | 38 | 0 | 56 | 0 | 3 | 1 | 3 | 57 | 44 | 101 | ||||||||||||||||||||||||||||||||||
1742803 | 1742803 | CO | school | 803360 | 880 | Denver County 1 | 80336001838 | 6508 | Omar D Blair Charter School | Regular School | Yes | Elementary | KG | 08 | 2021 | grade_6 | 1 | 48 | 33 | 0 | 8 | 3 | 8 | 54 | 47 | 101 | 1 | 48 | 33 | 0 | 8 | 3 | 8 | 54 | 47 | 101 | ||||||||||||||||||||||||||||||||||
1743242 | 1743242 | CO | school | 803450 | 900 | Douglas County Re 1 | 80345006492 | 135 | Ben Franklin Academy | Regular School | Yes | Elementary | PK | 08 | 2021 | grade_6 | 85 | 2 | 7 | 1 | 3 | 0 | 4 | 52 | 50 | 102 | 85 | 2 | 7 | 1 | 3 | 0 | 4 | 52 | 50 | 102 | ||||||||||||||||||||||||||||||||||
1743481 | 1743481 | CO | school | 803450 | 900 | Douglas County Re 1 | 80345006309 | 2953 | Stone Mountain Elementary | Regular School | No | Elementary | PK | 06 | 2021 | grade_6 | 79 | 2 | 12 | 0 | 3 | 0 | 6 | 62 | 40 | 102 | 79 | 2 | 12 | 0 | 3 | 0 | 6 | 62 | 40 | 102 | ||||||||||||||||||||||||||||||||||
1743654 | 1743654 | CO | school | 803450 | 900 | Douglas County Re 1 | 80345006588 | 6019 | Aspen View Academy | Regular School | Yes | Elementary | PK | 08 | 2021 | grade_6 | 76 | 0 | 14 | 2 | 2 | 0 | 8 | 50 | 52 | 102 | 76 | 0 | 14 | 2 | 2 | 0 | 8 | 50 | 52 | 102 | ||||||||||||||||||||||||||||||||||
1745678 | 1745678 | CO | school | 802790 | 1140 | Canon City RE-1 | 80279000173 | 3802 | Harrison School | Regular School | No | Elementary | KG | 08 | 2021 | grade_6 | 69 | 0 | 24 | 1 | 0 | 1 | 7 | 49 | 53 | 102 | 69 | 0 | 24 | 1 | 0 | 1 | 7 | 49 | 53 | 102 | ||||||||||||||||||||||||||||||||||
1749078 | 1749078 | CO | school | 802610 | 2395 | Brush RE-2(J) | 80261000153 | 1094 | Brush Middle School | Regular School | No | Middle | 06 | 08 | 2021 | grade_6 | 50 | 0 | 52 | 0 | 0 | 0 | 0 | 52 | 50 | 102 | 50 | 0 | 52 | 0 | 0 | 0 | 0 | 52 | 50 | 102 | ||||||||||||||||||||||||||||||||||
1743695 | 1743695 | CO | school | 803450 | 900 | Douglas County Re 1 | 80345001339 | 6406 | Northridge Elementary School | Regular School | No | Elementary | PK | 06 | 2021 | grade_6 | 67 | 3 | 15 | 0 | 11 | 0 | 7 | 43 | 60 | 103 | 67 | 3 | 15 | 0 | 11 | 0 | 7 | 43 | 60 | 103 | ||||||||||||||||||||||||||||||||||
1740139 | 1740139 | CO | school | 802340 | 180 | Adams-Arapahoe 28J | 80234006644 | 2673 | Edna and John W. Mosley P-8 | Regular School | No | Elementary | PK | 08 | 2021 | grade_6 | 12 | 15 | 69 | 0 | 3 | 1 | 4 | 58 | 46 | 104 | 12 | 15 | 69 | 0 | 3 | 1 | 4 | 58 | 46 | 104 | ||||||||||||||||||||||||||||||||||
1742852 | 1742852 | CO | school | 803360 | 880 | Denver County 1 | 80336006398 | 7045 | Place Bridge Academy | Regular School | No | Elementary | PK | 08 | 2021 | grade_6 | 12 | 37 | 37 | 1 | 16 | 0 | 2 | 55 | 50 | 105 | 12 | 37 | 37 | 1 | 16 | 0 | 2 | 55 | 50 | 105 | ||||||||||||||||||||||||||||||||||
1742194 | 1742194 | CO | school | 803360 | 880 | Denver County 1 | 80336006528 | 2209 | DCIS at Montbello | Regular School | No | High | 06 | 12 | 2021 | grade_6 | 1 | 8 | 93 | 0 | 1 | 2 | 1 | 56 | 50 | 106 | 1 | 8 | 93 | 0 | 1 | 2 | 1 | 56 | 50 | 106 | ||||||||||||||||||||||||||||||||||
1742638 | 1742638 | CO | school | 803360 | 880 | Denver County 1 | 80336001406 | 5605 | Dr. Martin Luther King Jr. Early College | Regular School | No | High | 06 | 12 | 2021 | grade_6 | 8 | 23 | 62 | 1 | 8 | 2 | 2 | 50 | 56 | 106 | 8 | 23 | 62 | 1 | 8 | 2 | 2 | 50 | 56 | 106 | ||||||||||||||||||||||||||||||||||
1741358 | 1741358 | CO | school | 802490 | 480 | Boulder Valley Re 2 | 80249001573 | 6000 | Monarch K-8 School | Regular School | No | Elementary | PK | 08 | 2021 | grade_6 | 84 | 1 | 6 | 0 | 10 | 1 | 5 | 52 | 55 | 107 | 84 | 1 | 6 | 0 | 10 | 1 | 5 | 52 | 55 | 107 | ||||||||||||||||||||||||||||||||||
1749906 | 1749906 | CO | school | 806150 | 2700 | Pueblo County 70 | 80615001085 | 9134 | Vineland Middle School | Regular School | No | Middle | 06 | 08 | 2021 | grade_6 | 56 | 0 | 45 | 0 | 0 | 0 | 6 | 55 | 52 | 107 | 56 | 0 | 45 | 0 | 0 | 0 | 6 | 55 | 52 | 107 | ||||||||||||||||||||||||||||||||||
1744333 | 1744333 | CO | school | 806480 | 990 | Widefield 3 | 80648006772 | 3692 | Grand Mountain School | Regular School | No | Elementary | PK | 08 | 2021 | grade_6 | 40 | 10 | 37 | 1 | 2 | 5 | 13 | 59 | 49 | 108 | 40 | 10 | 37 | 1 | 2 | 5 | 13 | 59 | 49 | 108 | ||||||||||||||||||||||||||||||||||
1743272 | 1743272 | CO | school | 803450 | 900 | Douglas County Re 1 | 80345006392 | 265 | Clear Sky Elementary | Regular School | No | Elementary | PK | 06 | 2021 | grade_6 | 81 | 2 | 17 | 0 | 2 | 0 | 7 | 56 | 53 | 109 | 81 | 2 | 17 | 0 | 2 | 0 | 7 | 56 | 53 | 109 | ||||||||||||||||||||||||||||||||||
1748786 | 1748786 | CO | school | 804350 | 2000 | Mesa County Valley 51 | 80435000629 | 9406 | West Middle School | Regular School | No | Middle | 06 | 08 | 2021 | grade_6 | 81 | 1 | 17 | 0 | 3 | 0 | 7 | 60 | 49 | 109 | 81 | 1 | 17 | 0 | 3 | 0 | 7 | 60 | 49 | 109 | ||||||||||||||||||||||||||||||||||
1745761 | 1745761 | CO | school | 803120 | 1160 | Cotopaxi RE-3 | 80312000277 | 3228 | Cotopaxi Junior-Senior High School | Regular School | No | High | 06 | 12 | 2021 | grade_6 | 10 | 0 | 1 | 0 | 0 | 0 | 0 | 4 | 7 | 11 | 10 | 0 | 1 | 0 | 0 | 0 | 0 | 4 | 7 | 11 | ||||||||||||||||||||||||||||||||||
1746105 | 1746105 | CO | school | 807050 | 1410 | North Park R-1 | 80705001209 | 6358 | North Park School | Regular School | No | Other | PK | 12 | 2021 | grade_6 | 7 | 0 | 4 | 0 | 0 | 0 | 0 | 5 | 6 | 11 | 7 | 0 | 4 | 0 | 0 | 0 | 0 | 5 | 6 | 11 | ||||||||||||||||||||||||||||||||||
1747050 | 1747050 | CO | school | 804800 | 1420 | Jefferson County R-1 | 80480006307 | 8036 | Sobesky Academy | Special Education School | No | Other | KG | 12 | 2021 | grade_6 | 5 | 1 | 4 | 1 | 0 | 0 | 0 | 10 | 1 | 11 | 5 | 1 | 4 | 1 | 0 | 0 | 0 | 10 | 1 | 11 | ||||||||||||||||||||||||||||||||||
1749056 | 1749056 | CO | school | 805850 | 2190 | West End RE-2 | 80585001398 | 6196 | Naturita Elementary School | Regular School | No | Elementary | PK | 06 | 2021 | grade_6 | 9 | 0 | 2 | 0 | 0 | 0 | 0 | 6 | 5 | 11 | 9 | 0 | 2 | 0 | 0 | 0 | 0 | 6 | 5 | 11 | ||||||||||||||||||||||||||||||||||
1749337 | 1749337 | CO | school | 803840 | 2610 | Park County RE-2 | 80384000501 | 4908 | Lake George Charter School | Regular School | Yes | Elementary | PK | 08 | 2021 | grade_6 | 7 | 0 | 2 | 0 | 0 | 0 | 2 | 6 | 5 | 11 | 7 | 0 | 2 | 0 | 0 | 0 | 2 | 6 | 5 | 11 | ||||||||||||||||||||||||||||||||||
1749801 | 1749801 | CO | school | 806150 | 2700 | Pueblo County 70 | 80615006763 | 6817 | PSAS Homeschool Program | Regular School | No | Elementary | KG | 08 | 2021 | grade_6 | 10 | 0 | 1 | 0 | 0 | 0 | 0 | 8 | 3 | 11 | 10 | 0 | 1 | 0 | 0 | 0 | 0 | 8 | 3 | 11 | ||||||||||||||||||||||||||||||||||
1751466 | 1751466 | CO | school | 800023 | 9000 | Colorado School for the Deaf and Blind | 80002306410 | 1924 | Colorado School for the Deaf and Blind | Special Education School | No | Other | PK | 12 | 2021 | grade_6 | 4 | 1 | 3 | 0 | 2 | 0 | 1 | 7 | 4 | 11 | 4 | 1 | 3 | 0 | 2 | 0 | 1 | 7 | 4 | 11 | ||||||||||||||||||||||||||||||||||
1746556 | 1746556 | CO | school | 804800 | 1420 | Jefferson County R-1 | 80480000975 | 4402 | Jefferson Academy Elementary | Regular School | Yes | Elementary | KG | 06 | 2021 | grade_6 | 75 | 2 | 15 | 0 | 7 | 0 | 11 | 57 | 53 | 110 | 75 | 2 | 15 | 0 | 7 | 0 | 11 | 57 | 53 | 110 | ||||||||||||||||||||||||||||||||||
1749570 | 1749570 | CO | school | 806120 | 2690 | Pueblo City 60 | 80612001730 | 1488 | Chavez/Huerta K-12 Preparatory Academy | Regular School | Yes | Other | KG | 12 | 2021 | grade_6 | 20 | 1 | 88 | 1 | 0 | 0 | 0 | 56 | 54 | 110 | 20 | 1 | 88 | 1 | 0 | 0 | 0 | 56 | 54 | 110 | ||||||||||||||||||||||||||||||||||
1745584 | 1745584 | CO | school | 803870 | 1110 | District 49 | 80387002000 | 7463 | Rocky Mountain Classical Academy | Regular School | Yes | Elementary | KG | 08 | 2021 | grade_6 | 64 | 3 | 32 | 1 | 0 | 1 | 10 | 52 | 59 | 111 | 64 | 3 | 32 | 1 | 0 | 1 | 10 | 52 | 59 | 111 | ||||||||||||||||||||||||||||||||||
1746141 | 1746141 | CO | school | 804800 | 1420 | Jefferson County R-1 | 80480006489 | 109 | Arvada K-8 | Regular School | No | Elementary | KG | 08 | 2021 | grade_6 | 45 | 5 | 57 | 1 | 0 | 0 | 3 | 57 | 54 | 111 | 45 | 5 | 57 | 1 | 0 | 0 | 3 | 57 | 54 | 111 | ||||||||||||||||||||||||||||||||||
1738332 | 1738332 | CO | school | 805550 | 10 | Mapleton 1 | 80555002007 | 506 | Explore Pk-8 | Regular School | No | Elementary | PK | 08 | 2021 | grade_6 | 25 | 3 | 81 | 0 | 0 | 2 | 1 | 49 | 63 | 112 | 25 | 3 | 81 | 0 | 0 | 2 | 1 | 49 | 63 | 112 | ||||||||||||||||||||||||||||||||||
1748136 | 1748136 | CO | school | 805400 | 1560 | Thompson R2-J | 80540002006 | 6220 | New Vision Charter School | Regular School | Yes | Elementary | KG | 08 | 2021 | grade_6 | 87 | 0 | 22 | 0 | 0 | 0 | 3 | 62 | 50 | 112 | 87 | 0 | 22 | 0 | 0 | 0 | 3 | 62 | 50 | 112 | ||||||||||||||||||||||||||||||||||
1747551 | 1747551 | CO | school | 802400 | 1530 | Bayfield 10 Jt-R | 80240000089 | 636 | Bayfield Middle School | Regular School | No | Middle | 06 | 08 | 2021 | grade_6 | 89 | 1 | 16 | 2 | 0 | 0 | 5 | 61 | 52 | 113 | 89 | 1 | 16 | 2 | 0 | 0 | 5 | 61 | 52 | 113 | ||||||||||||||||||||||||||||||||||
1749449 | 1749449 | CO | school | 805220 | 2660 | Lamar Re-2 | 80522000861 | 4956 | Lamar Middle School | Regular School | No | Middle | 06 | 08 | 2021 | grade_6 | 32 | 0 | 79 | 0 | 0 | 0 | 2 | 65 | 48 | 113 | 32 | 0 | 79 | 0 | 0 | 0 | 2 | 65 | 48 | 113 | ||||||||||||||||||||||||||||||||||
1742585 | 1742585 | CO | school | 803360 | 880 | Denver County 1 | 80336006442 | 4795 | Kunsmiller Creative Arts Academy | Regular School | No | Other | KG | 12 | 2021 | grade_6 | 15 | 3 | 88 | 3 | 3 | 0 | 3 | 53 | 62 | 115 | 15 | 3 | 88 | 3 | 3 | 0 | 3 | 53 | 62 | 115 | ||||||||||||||||||||||||||||||||||
1738721 | 1738721 | CO | school | 806900 | 20 | Adams 12 Five Star Schools | 80690006561 | 8310 | STEM Launch | Regular School | No | Elementary | KG | 08 | 2021 | grade_6 | 19 | 0 | 93 | 0 | 1 | 0 | 3 | 57 | 59 | 116 | 19 | 0 | 93 | 0 | 1 | 0 | 3 | 57 | 59 | 116 | ||||||||||||||||||||||||||||||||||
1743967 | 1743967 | CO | school | 803540 | 910 | Eagle County RE 50 | 80354001309 | 2355 | Eagle Valley Middle School | Regular School | No | Middle | 06 | 08 | 2021 | grade_6 | 65 | 1 | 46 | 1 | 0 | 0 | 4 | 54 | 63 | 117 | 65 | 1 | 46 | 1 | 0 | 0 | 4 | 54 | 63 | 117 | ||||||||||||||||||||||||||||||||||
1745664 | 1745664 | CO | school | 802790 | 1140 | Canon City RE-1 | 80279000171 | 1262 | Canon City Middle School | Regular School | No | Middle | 06 | 08 | 2021 | grade_6 | 93 | 0 | 17 | 1 | 0 | 0 | 6 | 57 | 60 | 117 | 93 | 0 | 17 | 1 | 0 | 0 | 6 | 57 | 60 | 117 | ||||||||||||||||||||||||||||||||||
1748172 | 1748172 | CO | school | 805400 | 1560 | Thompson R2-J | 80540001286 | 9228 | Walt Clark Middle School | Regular School | No | Middle | 06 | 08 | 2021 | grade_6 | 86 | 2 | 26 | 0 | 1 | 0 | 2 | 62 | 55 | 117 | 86 | 2 | 26 | 0 | 1 | 0 | 2 | 62 | 55 | 117 | ||||||||||||||||||||||||||||||||||
1749597 | 1749597 | CO | school | 806120 | 2690 | Pueblo City 60 | 80612006361 | 2096 | Corwin International Magnet School | Regular School | No | Middle | 04 | 08 | 2021 | grade_6 | 25 | 1 | 87 | 0 | 2 | 0 | 2 | 62 | 55 | 117 | 25 | 1 | 87 | 0 | 2 | 0 | 2 | 62 | 55 | 117 | ||||||||||||||||||||||||||||||||||
1740536 | 1740536 | CO | school | 802190 | 220 | Archuleta County 50 Jt | 80219000040 | 6657 | Pagosa Springs Middle School | Regular School | No | Middle | 05 | 08 | 2021 | grade_6 | 48 | 0 | 53 | 13 | 0 | 0 | 4 | 62 | 56 | 118 | 48 | 0 | 53 | 13 | 0 | 0 | 4 | 62 | 56 | 118 | ||||||||||||||||||||||||||||||||||
1741083 | 1741083 | CO | school | 802490 | 480 | Boulder Valley Re 2 | 80249001758 | 441 | Aspen Creek K-8 School | Regular School | No | Elementary | PK | 08 | 2021 | grade_6 | 82 | 2 | 17 | 0 | 11 | 0 | 6 | 59 | 59 | 118 | 82 | 2 | 17 | 0 | 11 | 0 | 6 | 59 | 59 | 118 | ||||||||||||||||||||||||||||||||||
1742538 | 1742538 | CO | school | 803360 | 880 | Denver County 1 | 80336006519 | 4507 | KIPP Northeast Denver Middle School | Regular School | Yes | Middle | 05 | 08 | 2021 | grade_6 | 3 | 28 | 80 | 0 | 5 | 0 | 2 | 63 | 55 | 118 | 3 | 28 | 80 | 0 | 5 | 0 | 2 | 63 | 55 | 118 | ||||||||||||||||||||||||||||||||||
1745339 | 1745339 | CO | school | 805820 | 1080 | Lewis-Palmer 38 | 80582001536 | 5093 | Monument Charter Academy Secondary School | Regular School | Yes | Middle | 06 | 09 | 2021 | grade_6 | 95 | 2 | 9 | 0 | 5 | 0 | 7 | 54 | 64 | 118 | 95 | 2 | 9 | 0 | 5 | 0 | 7 | 54 | 64 | 118 | ||||||||||||||||||||||||||||||||||
1739155 | 1739155 | CO | school | 807230 | 70 | Westminster Public Schools | 80723006458 | 7305 | Iver C. Ranum Middle School | Regular School | No | Middle | 06 | 08 | 2021 | grade_6 | 15 | 3 | 94 | 1 | 5 | 0 | 1 | 54 | 65 | 119 | 15 | 3 | 94 | 1 | 5 | 0 | 1 | 54 | 65 | 119 | ||||||||||||||||||||||||||||||||||
1740910 | 1740910 | CO | school | 805370 | 470 | St Vrain Valley RE1J | 80537000910 | 5288 | Longs Peak Middle School | Regular School | No | Middle | 05 | 08 | 2021 | grade_6 | 39 | 1 | 72 | 2 | 1 | 0 | 4 | 58 | 61 | 119 | 39 | 1 | 72 | 2 | 1 | 0 | 4 | 58 | 61 | 119 | ||||||||||||||||||||||||||||||||||
1741012 | 1741012 | CO | school | 805370 | 470 | St Vrain Valley RE1J | 80537006430 | 7565 | St. Vrain Community Montessori School | Regular School | Yes | Elementary | PK | 08 | 2021 | grade_6 | 11 | 0 | 1 | 0 | 0 | 0 | 0 | 8 | 4 | 12 | 11 | 0 | 1 | 0 | 0 | 0 | 0 | 8 | 4 | 12 | ||||||||||||||||||||||||||||||||||
1746092 | 1746092 | CO | school | 805160 | 1400 | La Veta Re-2 | 80516000854 | 4864 | La Veta Junior-Senior High School | Regular School | No | High | 06 | 12 | 2021 | grade_6 | 7 | 0 | 5 | 0 | 0 | 0 | 0 | 11 | 1 | 12 | 7 | 0 | 5 | 0 | 0 | 0 | 0 | 11 | 1 | 12 | ||||||||||||||||||||||||||||||||||
1748069 | 1748069 | CO | school | 805400 | 1560 | Thompson R2-J | 80540006558 | 5121 | LEAP School | Regular School | No | Other | KG | 12 | 2021 | grade_6 | 12 | 0 | 0 | 0 | 0 | 0 | 0 | 3 | 9 | 12 | 12 | 0 | 0 | 0 | 0 | 0 | 0 | 3 | 9 | 12 | ||||||||||||||||||||||||||||||||||
1748327 | 1748327 | CO | school | 804740 | 1780 | Genoa-Hugo C113 | 80474000686 | 4162 | Genoa-Hugo School | Regular School | No | Other | PK | 12 | 2021 | grade_6 | 12 | 0 | 0 | 0 | 0 | 0 | 0 | 5 | 7 | 12 | 12 | 0 | 0 | 0 | 0 | 0 | 0 | 5 | 7 | 12 | ||||||||||||||||||||||||||||||||||
1748637 | 1748637 | CO | school | 804350 | 2000 | Mesa County Valley 51 | 80435006498 | 3604 | Grand River Academy | Regular School | No | Other | KG | 12 | 2021 | grade_6 | 10 | 0 | 2 | 0 | 0 | 0 | 0 | 6 | 6 | 12 | 10 | 0 | 2 | 0 | 0 | 0 | 0 | 6 | 6 | 12 | ||||||||||||||||||||||||||||||||||
1750031 | 1750031 | CO | school | 806660 | 2770 | Steamboat Springs RE-2 | 80666001749 | 6363 | North Routt Charter School | Regular School | Yes | Elementary | PK | 08 | 2021 | grade_6 | 12 | 0 | 0 | 0 | 0 | 0 | 0 | 7 | 5 | 12 | 12 | 0 | 0 | 0 | 0 | 0 | 0 | 7 | 5 | 12 | ||||||||||||||||||||||||||||||||||
1750428 | 1750428 | CO | school | 807410 | 3070 | Woodlin R-104 | 80741001271 | 9704 | Woodlin Undivided High School | Regular School | No | High | 06 | 12 | 2021 | grade_6 | 11 | 0 | 1 | 0 | 0 | 0 | 0 | 7 | 5 | 12 | 11 | 0 | 1 | 0 | 0 | 0 | 0 | 7 | 5 | 12 | ||||||||||||||||||||||||||||||||||
1751266 | 1751266 | CO | school | 800020 | 8001 | Charter School Institute | 80002006390 | 2837 | Early College of Arvada | Regular School | Yes | High | 06 | 12 | 2021 | grade_6 | 6 | 0 | 5 | 0 | 0 | 1 | 0 | 6 | 6 | 12 | 6 | 0 | 5 | 0 | 0 | 1 | 0 | 6 | 6 | 12 | ||||||||||||||||||||||||||||||||||
1741144 | 1741144 | CO | school | 802490 | 480 | Boulder Valley Re 2 | 80249000104 | 1136 | Manhattan Middle School of the Arts and Academics | Regular School | No | Middle | 06 | 08 | 2021 | grade_6 | 72 | 2 | 33 | 1 | 3 | 0 | 9 | 59 | 61 | 120 | 72 | 2 | 33 | 1 | 3 | 0 | 9 | 59 | 61 | 120 | ||||||||||||||||||||||||||||||||||
1741211 | 1741211 | CO | school | 802490 | 480 | Boulder Valley Re 2 | 80249001771 | 2589 | Eldorado K-8 School | Regular School | No | Elementary | PK | 08 | 2021 | grade_6 | 92 | 1 | 9 | 1 | 6 | 0 | 11 | 61 | 59 | 120 | 92 | 1 | 9 | 1 | 6 | 0 | 11 | 61 | 59 | 120 | ||||||||||||||||||||||||||||||||||
1743680 | 1743680 | CO | school | 803450 | 900 | Douglas County Re 1 | 80345006455 | 6365 | Skyview Academy | Regular School | Yes | Other | PK | 12 | 2021 | grade_6 | 61 | 0 | 15 | 0 | 33 | 0 | 11 | 55 | 65 | 120 | 61 | 0 | 15 | 0 | 33 | 0 | 11 | 55 | 65 | 120 | ||||||||||||||||||||||||||||||||||
1747667 | 1747667 | CO | school | 803990 | 1550 | Poudre R-1 | 80399000524 | 1190 | Cache La Poudre Middle School | Regular School | No | Middle | 06 | 08 | 2021 | grade_6 | 107 | 0 | 9 | 0 | 0 | 0 | 4 | 62 | 58 | 120 | 107 | 0 | 9 | 0 | 0 | 0 | 4 | 62 | 58 | 120 | ||||||||||||||||||||||||||||||||||
1741441 | 1741441 | CO | school | 802490 | 480 | Boulder Valley Re 2 | 80249001517 | 8387 | Summit Middle Charter School | Regular School | Yes | Middle | 06 | 08 | 2021 | grade_6 | 80 | 0 | 7 | 1 | 24 | 0 | 9 | 60 | 61 | 121 | 80 | 0 | 7 | 1 | 24 | 0 | 9 | 60 | 61 | 121 | ||||||||||||||||||||||||||||||||||
1746178 | 1746178 | CO | school | 804800 | 1420 | Jefferson County R-1 | 80480000696 | 660 | Bear Creek K-8 School | Regular School | No | Elementary | KG | 08 | 2021 | grade_6 | 44 | 2 | 61 | 0 | 11 | 0 | 3 | 68 | 53 | 121 | 44 | 2 | 61 | 0 | 11 | 0 | 3 | 68 | 53 | 121 | ||||||||||||||||||||||||||||||||||
1742557 | 1742557 | CO | school | 803360 | 880 | Denver County 1 | 80336001865 | 4732 | KIPP Sunshine Peak Academy | Regular School | Yes | Middle | 05 | 08 | 2021 | grade_6 | 4 | 1 | 116 | 0 | 1 | 0 | 0 | 58 | 64 | 122 | 4 | 1 | 116 | 0 | 1 | 0 | 0 | 58 | 64 | 122 | ||||||||||||||||||||||||||||||||||
1742728 | 1742728 | CO | school | 803360 | 880 | Denver County 1 | 80336000386 | 6098 | Morey Middle School | Regular School | No | Middle | 06 | 08 | 2021 | grade_6 | 73 | 12 | 29 | 1 | 0 | 0 | 7 | 74 | 48 | 122 | 73 | 12 | 29 | 1 | 0 | 0 | 7 | 74 | 48 | 122 | ||||||||||||||||||||||||||||||||||
1743993 | 1743993 | CO | school | 803540 | 910 | Eagle County RE 50 | 80354001478 | 5742 | Homestake Peak School | Regular School | No | Elementary | PK | 08 | 2021 | grade_6 | 44 | 2 | 76 | 0 | 0 | 0 | 1 | 71 | 52 | 123 | 44 | 2 | 76 | 0 | 0 | 0 | 1 | 71 | 52 | 123 | ||||||||||||||||||||||||||||||||||
1750587 | 1750587 | CO | school | 807350 | 3100 | Windsor RE-4 | 80735006782 | 9563 | Windsor Charter Academy Middle School | Regular School | Yes | Middle | 06 | 08 | 2021 | grade_6 | 101 | 0 | 14 | 1 | 1 | 0 | 7 | 61 | 63 | 124 | 101 | 0 | 14 | 1 | 1 | 0 | 7 | 61 | 63 | 124 | ||||||||||||||||||||||||||||||||||
1742974 | 1742974 | CO | school | 803360 | 880 | Denver County 1 | 80336002012 | 8085 | STRIVE Prep - Federal | Regular School | Yes | Middle | 06 | 08 | 2021 | grade_6 | 3 | 3 | 115 | 0 | 2 | 2 | 0 | 63 | 62 | 125 | 3 | 3 | 115 | 0 | 2 | 2 | 0 | 63 | 62 | 125 | ||||||||||||||||||||||||||||||||||
1749414 | 1749414 | CO | school | 802280 | 2640 | Aspen 1 | 80228000046 | 430 | Aspen Middle School | Regular School | No | Middle | 05 | 08 | 2021 | grade_6 | 104 | 0 | 17 | 0 | 2 | 1 | 1 | 68 | 57 | 125 | 104 | 0 | 17 | 0 | 2 | 1 | 1 | 68 | 57 | 125 | ||||||||||||||||||||||||||||||||||
1748585 | 1748585 | CO | school | 804350 | 2000 | Mesa County Valley 51 | 80435000605 | 2392 | East Middle School | Regular School | No | Middle | 06 | 08 | 2021 | grade_6 | 80 | 1 | 30 | 2 | 2 | 0 | 11 | 64 | 62 | 126 | 80 | 1 | 30 | 2 | 2 | 0 | 11 | 64 | 62 | 126 | ||||||||||||||||||||||||||||||||||
1738663 | 1738663 | CO | school | 806900 | 20 | Adams 12 Five Star Schools | 80690006507 | 6802 | Prospect Ridge Academy | Regular School | Yes | Other | KG | 12 | 2021 | grade_6 | 95 | 1 | 13 | 0 | 8 | 0 | 12 | 71 | 58 | 129 | 95 | 1 | 13 | 0 | 8 | 0 | 12 | 71 | 58 | 129 | ||||||||||||||||||||||||||||||||||
1742769 | 1742769 | CO | school | 803360 | 880 | Denver County 1 | 80336001869 | 6350 | Bruce Randolph School | Regular School | No | High | 06 | 12 | 2021 | grade_6 | 2 | 12 | 111 | 1 | 1 | 0 | 2 | 60 | 69 | 129 | 2 | 12 | 111 | 1 | 1 | 0 | 2 | 60 | 69 | 129 | ||||||||||||||||||||||||||||||||||
1739964 | 1739964 | CO | school | 803270 | 170 | Deer Trail 26J | 80327000288 | 2140 | Deer Trail Junior-Senior High School | Regular School | No | High | 06 | 12 | 2021 | grade_6 | 7 | 0 | 6 | 0 | 0 | 0 | 0 | 10 | 3 | 13 | 7 | 0 | 6 | 0 | 0 | 0 | 0 | 10 | 3 | 13 | ||||||||||||||||||||||||||||||||||
1740559 | 1740559 | CO | school | 807110 | 230 | Walsh RE-1 | 80711001215 | 9222 | Walsh Elementary School | Regular School | No | Elementary | PK | 06 | 2021 | grade_6 | 10 | 0 | 2 | 0 | 0 | 0 | 1 | 5 | 8 | 13 | 10 | 0 | 2 | 0 | 0 | 0 | 1 | 5 | 8 | 13 | ||||||||||||||||||||||||||||||||||
1741539 | 1741539 | CO | school | 800001 | 520 | Cheyenne County Re-5 | 80000100214 | 1608 | Cheyenne Wells Elementary School | Regular School | No | Elementary | PK | 06 | 2021 | grade_6 | 12 | 0 | 1 | 0 | 0 | 0 | 0 | 7 | 6 | 13 | 12 | 0 | 1 | 0 | 0 | 0 | 0 | 7 | 6 | 13 | ||||||||||||||||||||||||||||||||||
1744509 | 1744509 | CO | school | 803060 | 1010 | Colorado Springs 11 | 80306006428 | 269 | Achieve Online | Alternative School | No | High | 06 | 12 | 2021 | grade_6 | 6 | 2 | 5 | 0 | 0 | 0 | 0 | 7 | 6 | 13 | 6 | 2 | 5 | 0 | 0 | 0 | 0 | 7 | 6 | 13 | ||||||||||||||||||||||||||||||||||
1747378 | 1747378 | CO | school | 806780 | 1480 | Stratton R-4 | 80678000138 | 8351 | Stratton Middle School | Regular School | No | Middle | 06 | 08 | 2021 | grade_6 | 9 | 0 | 4 | 0 | 0 | 0 | 0 | 8 | 5 | 13 | 9 | 0 | 4 | 0 | 0 | 0 | 0 | 8 | 5 | 13 | ||||||||||||||||||||||||||||||||||
1749004 | 1749004 | CO | school | 805790 | 2180 | Montrose County RE-1J | 80579006499 | 6262 | Peak Virtual Academy | Regular School | No | Other | KG | 12 | 2021 | grade_6 | 12 | 0 | 1 | 0 | 0 | 0 | 0 | 9 | 4 | 13 | 12 | 0 | 1 | 0 | 0 | 0 | 0 | 9 | 4 | 13 | ||||||||||||||||||||||||||||||||||
1749277 | 1749277 | CO | school | 805970 | 2580 | Ouray R-1 | 80597001018 | 6596 | Ouray Elementary School | Regular School | No | Elementary | PK | 06 | 2021 | grade_6 | 13 | 0 | 0 | 0 | 0 | 0 | 0 | 7 | 6 | 13 | 13 | 0 | 0 | 0 | 0 | 0 | 0 | 7 | 6 | 13 | ||||||||||||||||||||||||||||||||||
1749763 | 1749763 | CO | school | 806150 | 2700 | Pueblo County 70 | 80615001072 | 856 | Beulah Middle School | Regular School | No | Middle | 06 | 08 | 2021 | grade_6 | 9 | 0 | 4 | 0 | 0 | 0 | 0 | 5 | 8 | 13 | 9 | 0 | 4 | 0 | 0 | 0 | 0 | 5 | 8 | 13 | ||||||||||||||||||||||||||||||||||
1750401 | 1750401 | CO | school | 805340 | 3060 | Lone Star 101 | 80534006376 | 5238 | Lone Star Middle School | Regular School | No | Middle | 06 | 08 | 2021 | grade_6 | 8 | 0 | 5 | 0 | 0 | 0 | 0 | 5 | 8 | 13 | 8 | 0 | 5 | 0 | 0 | 0 | 0 | 5 | 8 | 13 | ||||||||||||||||||||||||||||||||||
1745324 | 1745324 | CO | school | 805820 | 1080 | Lewis-Palmer 38 | 80582001371 | 3539 | Bear Creek Elementary School | Regular School | No | Elementary | PK | 06 | 2021 | grade_6 | 100 | 1 | 16 | 2 | 1 | 0 | 12 | 75 | 57 | 132 | 100 | 1 | 16 | 2 | 1 | 0 | 12 | 75 | 57 | 132 | ||||||||||||||||||||||||||||||||||
1749806 | 1749806 | CO | school | 806150 | 2700 | Pueblo County 70 | 80615001078 | 7086 | Pleasant View Middle School | Regular School | No | Middle | 06 | 08 | 2021 | grade_6 | 53 | 0 | 75 | 0 | 0 | 0 | 4 | 67 | 65 | 132 | 53 | 0 | 75 | 0 | 0 | 0 | 4 | 67 | 65 | 132 | ||||||||||||||||||||||||||||||||||
1739983 | 1739983 | CO | school | 802340 | 180 | Adams-Arapahoe 28J | 80234006736 | 126 | Academy of Advanced Learning | Regular School | Yes | Elementary | KG | 08 | 2021 | grade_6 | 6 | 25 | 90 | 0 | 1 | 0 | 11 | 70 | 63 | 133 | 6 | 25 | 90 | 0 | 1 | 0 | 11 | 70 | 63 | 133 | ||||||||||||||||||||||||||||||||||
1750916 | 1750916 | CO | school | 804020 | 3140 | Weld Re-8 Schools | 80402000553 | 3066 | Fort Lupton Middle School | Regular School | No | Middle | 06 | 08 | 2021 | grade_6 | 27 | 0 | 103 | 0 | 1 | 0 | 3 | 77 | 57 | 134 | 27 | 0 | 103 | 0 | 1 | 0 | 3 | 77 | 57 | 134 | ||||||||||||||||||||||||||||||||||
1738457 | 1738457 | CO | school | 806900 | 20 | Adams 12 Five Star Schools | 80690000728 | 1519 | Stargate Charter School | Regular School | Yes | Other | KG | 12 | 2021 | grade_6 | 67 | 0 | 16 | 0 | 39 | 0 | 13 | 74 | 61 | 135 | 67 | 0 | 16 | 0 | 39 | 0 | 13 | 74 | 61 | 135 | ||||||||||||||||||||||||||||||||||
1741407 | 1741407 | CO | school | 802490 | 480 | Boulder Valley Re 2 | 80249001792 | 6816 | Peak to Peak Charter School | Regular School | Yes | Other | KG | 12 | 2021 | grade_6 | 85 | 1 | 19 | 0 | 26 | 0 | 4 | 72 | 63 | 135 | 85 | 1 | 19 | 0 | 26 | 0 | 4 | 72 | 63 | 135 | ||||||||||||||||||||||||||||||||||
1744678 | 1744678 | CO | school | 803060 | 1010 | Colorado Springs 11 | 80306000242 | 4090 | Mann Middle School | Regular School | No | Middle | 06 | 08 | 2021 | grade_6 | 72 | 8 | 49 | 1 | 0 | 0 | 6 | 70 | 66 | 136 | 72 | 8 | 49 | 1 | 0 | 0 | 6 | 70 | 66 | 136 | ||||||||||||||||||||||||||||||||||
1750336 | 1750336 | CO | school | 807380 | 3020 | Woodland Park Re-2 | 80738001268 | 9694 | Woodland Park Middle School | Regular School | No | Middle | 06 | 08 | 2021 | grade_6 | 107 | 0 | 21 | 0 | 2 | 0 | 7 | 67 | 70 | 137 | 107 | 0 | 21 | 0 | 2 | 0 | 7 | 67 | 70 | 137 | ||||||||||||||||||||||||||||||||||
1744890 | 1744890 | CO | school | 802940 | 1020 | Cheyenne Mountain 12 | 80294001326 | 1582 | The Vanguard School (Elementary) | Regular School | Yes | Elementary | KG | 06 | 2021 | grade_6 | 76 | 6 | 35 | 0 | 9 | 1 | 11 | 69 | 69 | 138 | 76 | 6 | 35 | 0 | 9 | 1 | 11 | 69 | 69 | 138 | ||||||||||||||||||||||||||||||||||
1747507 | 1747507 | CO | school | 803480 | 1520 | Durango 9-R | 80348000452 | 5888 | Miller Middle School | Regular School | No | Middle | 06 | 08 | 2021 | grade_6 | 90 | 3 | 26 | 12 | 0 | 0 | 7 | 65 | 73 | 138 | 90 | 3 | 26 | 12 | 0 | 0 | 7 | 65 | 73 | 138 | ||||||||||||||||||||||||||||||||||
1747965 | 1747965 | CO | school | 805400 | 1560 | Thompson R2-J | 80540000925 | 510 | Conrad Ball Middle School | Regular School | No | Middle | 06 | 08 | 2021 | grade_6 | 68 | 1 | 59 | 2 | 0 | 0 | 8 | 68 | 70 | 138 | 68 | 1 | 59 | 2 | 0 | 0 | 8 | 68 | 70 | 138 | ||||||||||||||||||||||||||||||||||
1742147 | 1742147 | CO | school | 803360 | 880 | Denver County 1 | 80336001574 | 2184 | Denver School of the Arts | Regular School | No | High | 06 | 12 | 2021 | grade_6 | 87 | 8 | 26 | 1 | 4 | 0 | 13 | 49 | 90 | 139 | 87 | 8 | 26 | 1 | 4 | 0 | 13 | 49 | 90 | 139 | ||||||||||||||||||||||||||||||||||
1740764 | 1740764 | CO | school | 805370 | 470 | St Vrain Valley RE1J | 80537001887 | 1284 | Carbon Valley Academy | Regular School | Yes | Elementary | PK | 08 | 2021 | grade_6 | 6 | 0 | 7 | 0 | 0 | 1 | 0 | 11 | 3 | 14 | 6 | 0 | 7 | 0 | 0 | 1 | 0 | 11 | 3 | 14 | ||||||||||||||||||||||||||||||||||
1741729 | 1741729 | CO | school | 803330 | 870 | Delta County 50(J) | 80333000295 | 1952 | North Fork Montessori @ Crawford | Regular School | No | Elementary | PK | 06 | 2021 | grade_6 | 9 | 0 | 4 | 0 | 0 | 0 | 1 | 6 | 8 | 14 | 9 | 0 | 4 | 0 | 0 | 0 | 1 | 6 | 8 | 14 | ||||||||||||||||||||||||||||||||||
1743203 | 1743203 | CO | school | 803420 | 890 | Dolores County RE No.2 | 80342000429 | 2216 | Dove Creek High School | Regular School | No | High | 06 | 12 | 2021 | grade_6 | 13 | 0 | 1 | 0 | 0 | 0 | 0 | 9 | 5 | 14 | 13 | 0 | 1 | 0 | 0 | 0 | 0 | 9 | 5 | 14 |
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]);