enrollments
Data source: Big Local News · About: Big Local
1,106 rows where grade = "grade_1", state = "CO" and year = 2021 sorted by female
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1746753 | 1746753 | CO | school | 804800 | 1420 | Jefferson County R-1 | 80480000756 | 5892 | Miller Special Education | Special Education School | No | Other | PK | 12 | 2021 | grade_1 | 2 | 0 | 0 | 0 | 0 | 0 | 0 | 2 | 0 | 2 | 2 | 0 | 0 | 0 | 0 | 0 | 0 | 2 | 0 | 2 | ||||||||||||||||||||||||||||||||||
1747043 | 1747043 | CO | school | 804800 | 1420 | Jefferson County R-1 | 80480006307 | 8036 | Sobesky Academy | Special Education School | No | Other | KG | 12 | 2021 | grade_1 | 2 | 0 | 0 | 0 | 0 | 0 | 0 | 2 | 0 | 2 | 2 | 0 | 0 | 0 | 0 | 0 | 0 | 2 | 0 | 2 | ||||||||||||||||||||||||||||||||||
1748290 | 1748290 | CO | school | 802520 | 1750 | Branson Reorganized 82 | 80252000141 | 978 | Branson School | Regular School | No | Other | PK | 12 | 2021 | grade_1 | 3 | 0 | 0 | 0 | 0 | 0 | 0 | 3 | 0 | 3 | 3 | 0 | 0 | 0 | 0 | 0 | 0 | 3 | 0 | 3 | ||||||||||||||||||||||||||||||||||
1740570 | 1740570 | CO | school | 806090 | 240 | Pritchett RE-3 | 80609001026 | 7174 | Pritchett Elementary School | Regular School | No | Elementary | PK | 05 | 2021 | grade_1 | 3 | 0 | 0 | 0 | 0 | 0 | 0 | 2 | 1 | 3 | 3 | 0 | 0 | 0 | 0 | 0 | 0 | 2 | 1 | 3 | ||||||||||||||||||||||||||||||||||
1741263 | 1741263 | CO | school | 802490 | 480 | Boulder Valley Re 2 | 80249000117 | 3488 | Gold Hill Elementary School | Regular School | No | Elementary | KG | 05 | 2021 | grade_1 | 1 | 0 | 1 | 0 | 0 | 0 | 0 | 1 | 1 | 2 | 1 | 0 | 1 | 0 | 0 | 0 | 0 | 1 | 1 | 2 | ||||||||||||||||||||||||||||||||||
1747355 | 1747355 | CO | school | 806510 | 1460 | Hi-Plains R-23 | 80651001130 | 7746 | Hi-Plains School District R-23 | Regular School | No | Other | PK | 12 | 2021 | grade_1 | 5 | 0 | 1 | 0 | 0 | 0 | 0 | 5 | 1 | 6 | 5 | 0 | 1 | 0 | 0 | 0 | 0 | 5 | 1 | 6 | ||||||||||||||||||||||||||||||||||
1747387 | 1747387 | CO | school | 802460 | 1490 | Bethune R-5 | 80246000095 | 842 | Bethune Public Schools | Regular School | No | Other | PK | 12 | 2021 | grade_1 | 6 | 0 | 3 | 0 | 0 | 0 | 1 | 9 | 1 | 10 | 6 | 0 | 3 | 0 | 0 | 0 | 1 | 9 | 1 | 10 | ||||||||||||||||||||||||||||||||||
1748260 | 1748260 | CO | school | 802010 | 1620 | Aguilar Reorganized 6 | 80201000022 | 58 | Aguilar Elementary School | Regular School | No | Elementary | PK | 05 | 2021 | grade_1 | 3 | 0 | 1 | 0 | 0 | 0 | 0 | 3 | 1 | 4 | 3 | 0 | 1 | 0 | 0 | 0 | 0 | 3 | 1 | 4 | ||||||||||||||||||||||||||||||||||
1748805 | 1748805 | CO | school | 803150 | 2010 | Creede School District | 80315000279 | 1966 | Creede School | Regular School | No | Other | PK | 12 | 2021 | grade_1 | 3 | 0 | 1 | 0 | 0 | 0 | 0 | 3 | 1 | 4 | 3 | 0 | 1 | 0 | 0 | 0 | 0 | 3 | 1 | 4 | ||||||||||||||||||||||||||||||||||
1748918 | 1748918 | CO | school | 803090 | 2035 | Montezuma-Cortez RE-1 | 80309000841 | 7082 | Pleasant View Elementary School | Regular School | No | Elementary | KG | 05 | 2021 | grade_1 | 2 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 1 | 2 | 2 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 1 | 2 | ||||||||||||||||||||||||||||||||||
1748996 | 1748996 | CO | school | 805790 | 2180 | Montrose County RE-1J | 80579006499 | 6262 | Peak Virtual Academy | Regular School | No | Other | KG | 12 | 2021 | grade_1 | 1 | 0 | 1 | 0 | 0 | 0 | 0 | 1 | 1 | 2 | 1 | 0 | 1 | 0 | 0 | 0 | 0 | 1 | 1 | 2 | ||||||||||||||||||||||||||||||||||
1749775 | 1749775 | CO | school | 806150 | 2700 | Pueblo County 70 | 80615006496 | 5990 | 70 Online | Alternative School | No | Other | KG | 12 | 2021 | grade_1 | 0 | 0 | 2 | 0 | 0 | 0 | 0 | 1 | 1 | 2 | 0 | 0 | 2 | 0 | 0 | 0 | 0 | 1 | 1 | 2 | ||||||||||||||||||||||||||||||||||
1750111 | 1750111 | CO | school | 805700 | 2800 | Moffat 2 | 80570000974 | 5958 | Moffat Prek-12 School | Regular School | No | Other | PK | 12 | 2021 | grade_1 | 6 | 0 | 2 | 1 | 0 | 0 | 0 | 8 | 1 | 9 | 6 | 0 | 2 | 1 | 0 | 0 | 0 | 8 | 1 | 9 | ||||||||||||||||||||||||||||||||||
1740914 | 1740914 | CO | school | 805370 | 470 | St Vrain Valley RE1J | 80537000911 | 5364 | Lyons Elementary School | Regular School | No | Elementary | PK | 05 | 2021 | grade_1 | 29 | 0 | 3 | 0 | 0 | 0 | 1 | 23 | 10 | 33 | 29 | 0 | 3 | 0 | 0 | 0 | 1 | 23 | 10 | 33 | ||||||||||||||||||||||||||||||||||
1741812 | 1741812 | CO | school | 803330 | 870 | Delta County 50(J) | 80333001337 | 6700 | Paonia Elementary School | Regular School | No | Elementary | PK | 06 | 2021 | grade_1 | 25 | 0 | 4 | 0 | 0 | 0 | 0 | 19 | 10 | 29 | 25 | 0 | 4 | 0 | 0 | 0 | 0 | 19 | 10 | 29 | ||||||||||||||||||||||||||||||||||
1742577 | 1742577 | CO | school | 803360 | 880 | Denver County 1 | 80336006442 | 4795 | Kunsmiller Creative Arts Academy | Regular School | No | Other | KG | 12 | 2021 | grade_1 | 3 | 1 | 19 | 1 | 1 | 0 | 0 | 15 | 10 | 25 | 3 | 1 | 19 | 1 | 1 | 0 | 0 | 15 | 10 | 25 | ||||||||||||||||||||||||||||||||||
1744067 | 1744067 | CO | school | 805010 | 930 | Kiowa C-2 | 80501000824 | 4724 | Kiowa Elementary School | Regular School | No | Elementary | PK | 05 | 2021 | grade_1 | 10 | 1 | 4 | 0 | 0 | 0 | 0 | 5 | 10 | 15 | 10 | 1 | 4 | 0 | 0 | 0 | 0 | 5 | 10 | 15 | ||||||||||||||||||||||||||||||||||
1744969 | 1744969 | CO | school | 805490 | 1030 | Manitou Springs 14 | 80549000948 | 9010 | Ute Pass Elementary School | Regular School | No | Elementary | PK | 06 | 2021 | grade_1 | 16 | 0 | 3 | 0 | 0 | 0 | 0 | 9 | 10 | 19 | 16 | 0 | 3 | 0 | 0 | 0 | 0 | 9 | 10 | 19 | ||||||||||||||||||||||||||||||||||
1745302 | 1745302 | CO | school | 804500 | 1070 | Hanover 28 | 80450006304 | 6701 | Prairie Heights Elementary School | Regular School | No | Elementary | PK | 05 | 2021 | grade_1 | 10 | 0 | 7 | 0 | 0 | 0 | 2 | 9 | 10 | 19 | 10 | 0 | 7 | 0 | 0 | 0 | 2 | 9 | 10 | 19 | ||||||||||||||||||||||||||||||||||
1746847 | 1746847 | CO | school | 804800 | 1420 | Jefferson County R-1 | 80480006256 | 6539 | Jefferson County Open Elementary School | Regular School | No | Elementary | PK | 06 | 2021 | grade_1 | 20 | 0 | 3 | 0 | 0 | 0 | 5 | 18 | 10 | 28 | 20 | 0 | 3 | 0 | 0 | 0 | 5 | 18 | 10 | 28 | ||||||||||||||||||||||||||||||||||
1747183 | 1747183 | CO | school | 804800 | 1420 | Jefferson County R-1 | 80480000794 | 9154 | Vivian Elementary School | Regular School | No | Elementary | PK | 05 | 2021 | grade_1 | 14 | 0 | 5 | 0 | 1 | 0 | 0 | 10 | 10 | 20 | 14 | 0 | 5 | 0 | 1 | 0 | 0 | 10 | 10 | 20 | ||||||||||||||||||||||||||||||||||
1747597 | 1747597 | CO | school | 803990 | 1550 | Poudre R-1 | 80399006776 | 473 | PSD Mountain Schools | Regular School | No | Elementary | PK | 05 | 2021 | grade_1 | 20 | 0 | 1 | 0 | 0 | 0 | 1 | 12 | 10 | 22 | 20 | 0 | 1 | 0 | 0 | 0 | 1 | 12 | 10 | 22 | ||||||||||||||||||||||||||||||||||
1747836 | 1747836 | CO | school | 803990 | 1550 | Poudre R-1 | 80399006334 | 7104 | Polaris Expeditionary Learning School | Alternative School | No | Other | KG | 12 | 2021 | grade_1 | 16 | 0 | 1 | 1 | 0 | 0 | 0 | 8 | 10 | 18 | 16 | 0 | 1 | 1 | 0 | 0 | 0 | 8 | 10 | 18 | ||||||||||||||||||||||||||||||||||
1748465 | 1748465 | CO | school | 803030 | 1990 | Plateau Valley 50 | 80303000219 | 7024 | Plateau Valley Elementary School | Regular School | No | Elementary | PK | 06 | 2021 | grade_1 | 14 | 1 | 0 | 0 | 0 | 0 | 0 | 5 | 10 | 15 | 14 | 1 | 0 | 0 | 0 | 0 | 0 | 5 | 10 | 15 | ||||||||||||||||||||||||||||||||||
1751318 | 1751318 | CO | school | 800020 | 8001 | Charter School Institute | 80002006701 | 5423 | Mountain Village Montessori Charter School | Regular School | Yes | Elementary | PK | 05 | 2021 | grade_1 | 20 | 0 | 0 | 0 | 0 | 0 | 0 | 10 | 10 | 20 | 20 | 0 | 0 | 0 | 0 | 0 | 0 | 10 | 10 | 20 | ||||||||||||||||||||||||||||||||||
1751516 | 1751516 | CO | school | 800282 | 9170 | Education reEnvisioned BOCES | 80028206804 | 1892 | Orton Academy | Regular School | No | Other | KG | 12 | 2021 | grade_1 | 15 | 1 | 0 | 0 | 3 | 0 | 0 | 9 | 10 | 19 | 15 | 1 | 0 | 0 | 3 | 0 | 0 | 9 | 10 | 19 | ||||||||||||||||||||||||||||||||||
1739258 | 1739258 | CO | school | 806420 | 110 | Sangre De Cristo Re-22J | 80642001115 | 7626 | Sangre de Cristo Elementary School | Regular School | No | Elementary | PK | 05 | 2021 | grade_1 | 10 | 0 | 7 | 0 | 0 | 0 | 0 | 6 | 11 | 17 | 10 | 0 | 7 | 0 | 0 | 0 | 0 | 6 | 11 | 17 | ||||||||||||||||||||||||||||||||||
1740759 | 1740759 | CO | school | 805370 | 470 | St Vrain Valley RE1J | 80537001887 | 1284 | Carbon Valley Academy | Regular School | Yes | Elementary | PK | 08 | 2021 | grade_1 | 15 | 0 | 9 | 1 | 0 | 0 | 1 | 15 | 11 | 26 | 15 | 0 | 9 | 1 | 0 | 0 | 1 | 15 | 11 | 26 | ||||||||||||||||||||||||||||||||||
1741534 | 1741534 | CO | school | 800001 | 520 | Cheyenne County Re-5 | 80000100214 | 1608 | Cheyenne Wells Elementary School | Regular School | No | Elementary | PK | 06 | 2021 | grade_1 | 15 | 0 | 2 | 0 | 0 | 0 | 0 | 6 | 11 | 17 | 15 | 0 | 2 | 0 | 0 | 0 | 0 | 6 | 11 | 17 | ||||||||||||||||||||||||||||||||||
1741618 | 1741618 | CO | school | 806390 | 560 | Sanford 6J | 80639001113 | 7612 | Sanford Elementary School | Regular School | No | Elementary | PK | 06 | 2021 | grade_1 | 19 | 0 | 3 | 0 | 0 | 0 | 2 | 13 | 11 | 24 | 19 | 0 | 3 | 0 | 0 | 0 | 2 | 13 | 11 | 24 | ||||||||||||||||||||||||||||||||||
1742027 | 1742027 | CO | school | 803360 | 880 | Denver County 1 | 80336000329 | 1816 | Columbian Elementary School | Regular School | No | Elementary | PK | 05 | 2021 | grade_1 | 5 | 3 | 23 | 0 | 0 | 1 | 1 | 22 | 11 | 33 | 5 | 3 | 23 | 0 | 0 | 1 | 1 | 22 | 11 | 33 | ||||||||||||||||||||||||||||||||||
1743988 | 1743988 | CO | school | 803540 | 910 | Eagle County RE 50 | 80354001478 | 5742 | Homestake Peak School | Regular School | No | Elementary | PK | 08 | 2021 | grade_1 | 10 | 0 | 19 | 0 | 0 | 0 | 0 | 18 | 11 | 29 | 10 | 0 | 19 | 0 | 0 | 0 | 0 | 18 | 11 | 29 | ||||||||||||||||||||||||||||||||||
1745416 | 1745416 | CO | school | 803870 | 1110 | District 49 | 80387006794 | 467 | Mountain View Academy | Regular School | Yes | Elementary | KG | 08 | 2021 | grade_1 | 14 | 0 | 3 | 0 | 0 | 0 | 4 | 10 | 11 | 21 | 14 | 0 | 3 | 0 | 0 | 0 | 4 | 10 | 11 | 21 | ||||||||||||||||||||||||||||||||||
1746435 | 1746435 | CO | school | 804800 | 1420 | Jefferson County R-1 | 80480000722 | 2946 | Fitzmorris Elementary School | Regular School | No | Elementary | PK | 05 | 2021 | grade_1 | 12 | 0 | 10 | 0 | 2 | 0 | 1 | 14 | 11 | 25 | 12 | 0 | 10 | 0 | 2 | 0 | 1 | 14 | 11 | 25 | ||||||||||||||||||||||||||||||||||
1747308 | 1747308 | CO | school | 803510 | 1430 | Eads RE-1 | 80351000458 | 2328 | Eads Elementary School | Regular School | No | Elementary | PK | 05 | 2021 | grade_1 | 18 | 1 | 1 | 0 | 0 | 0 | 0 | 9 | 11 | 20 | 18 | 1 | 1 | 0 | 0 | 0 | 0 | 9 | 11 | 20 | ||||||||||||||||||||||||||||||||||
1747441 | 1747441 | CO | school | 803480 | 1520 | Durango 9-R | 80348001066 | 225 | Animas Valley Elementary School | Regular School | No | Elementary | PK | 05 | 2021 | grade_1 | 14 | 0 | 11 | 3 | 0 | 0 | 0 | 17 | 11 | 28 | 14 | 0 | 11 | 3 | 0 | 0 | 0 | 17 | 11 | 28 | ||||||||||||||||||||||||||||||||||
1748589 | 1748589 | CO | school | 804350 | 2000 | Mesa County Valley 51 | 80435001552 | 2724 | New Emerson School at Columbus | Regular School | No | Elementary | KG | 05 | 2021 | grade_1 | 19 | 0 | 2 | 0 | 0 | 0 | 1 | 11 | 11 | 22 | 19 | 0 | 2 | 0 | 0 | 0 | 1 | 11 | 11 | 22 | ||||||||||||||||||||||||||||||||||
1749257 | 1749257 | CO | school | 806840 | 2570 | Swink 33 | 80684001168 | 8452 | Swink Elementary School | Regular School | No | Elementary | KG | 06 | 2021 | grade_1 | 14 | 0 | 5 | 0 | 1 | 0 | 0 | 9 | 11 | 20 | 14 | 0 | 5 | 0 | 1 | 0 | 0 | 9 | 11 | 20 | ||||||||||||||||||||||||||||||||||
1749441 | 1749441 | CO | school | 805220 | 2660 | Lamar Re-2 | 80522000860 | 200 | Alta Vista Charter School | Regular School | Yes | Elementary | KG | 06 | 2021 | grade_1 | 11 | 0 | 9 | 0 | 0 | 0 | 0 | 9 | 11 | 20 | 11 | 0 | 9 | 0 | 0 | 0 | 0 | 9 | 11 | 20 | ||||||||||||||||||||||||||||||||||
1749991 | 1749991 | CO | school | 806450 | 2750 | Sargent RE-33J | 80645001117 | 7660 | Sargent Elementary School | Regular School | No | Elementary | KG | 06 | 2021 | grade_1 | 16 | 0 | 4 | 1 | 0 | 0 | 0 | 10 | 11 | 21 | 16 | 0 | 4 | 1 | 0 | 0 | 0 | 10 | 11 | 21 | ||||||||||||||||||||||||||||||||||
1740587 | 1740587 | CO | school | 806630 | 250 | Springfield RE-4 | 80663001141 | 8160 | Springfield Elementary School | Regular School | No | Elementary | PK | 05 | 2021 | grade_1 | 19 | 0 | 2 | 2 | 0 | 0 | 0 | 11 | 12 | 23 | 19 | 0 | 2 | 2 | 0 | 0 | 0 | 11 | 12 | 23 | ||||||||||||||||||||||||||||||||||
1740603 | 1740603 | CO | school | 806990 | 260 | Vilas RE-5 | 80699001206 | 9090 | Vilas Elementary School | Regular School | No | Elementary | PK | 06 | 2021 | grade_1 | 20 | 0 | 1 | 0 | 0 | 0 | 1 | 10 | 12 | 22 | 20 | 0 | 1 | 0 | 0 | 0 | 1 | 10 | 12 | 22 | ||||||||||||||||||||||||||||||||||
1741696 | 1741696 | CO | school | 807200 | 860 | Custer County School District C-1 | 80720001226 | 2088 | Custer County Elementary School | Regular School | No | Elementary | PK | 05 | 2021 | grade_1 | 23 | 0 | 1 | 0 | 1 | 0 | 2 | 15 | 12 | 27 | 23 | 0 | 1 | 0 | 1 | 0 | 2 | 15 | 12 | 27 | ||||||||||||||||||||||||||||||||||
1741804 | 1741804 | CO | school | 803330 | 870 | Delta County 50(J) | 80333006667 | 6295 | North Fork School of Integrated Studies | Regular School | No | Elementary | KG | 06 | 2021 | grade_1 | 17 | 0 | 4 | 0 | 0 | 0 | 0 | 9 | 12 | 21 | 17 | 0 | 4 | 0 | 0 | 0 | 0 | 9 | 12 | 21 | ||||||||||||||||||||||||||||||||||
1743824 | 1743824 | CO | school | 803450 | 900 | Douglas County Re 1 | 80345000446 | 7718 | Sedalia Elementary School | Regular School | No | Elementary | PK | 06 | 2021 | grade_1 | 16 | 0 | 11 | 0 | 0 | 0 | 2 | 17 | 12 | 29 | 16 | 0 | 11 | 0 | 0 | 0 | 2 | 17 | 12 | 29 | ||||||||||||||||||||||||||||||||||
1744537 | 1744537 | CO | school | 803060 | 1010 | Colorado Springs 11 | 80306000224 | 1032 | Bristol Elementary School | Regular School | No | Elementary | KG | 05 | 2021 | grade_1 | 22 | 2 | 13 | 0 | 0 | 0 | 1 | 26 | 12 | 38 | 22 | 2 | 13 | 0 | 0 | 0 | 1 | 26 | 12 | 38 | ||||||||||||||||||||||||||||||||||
1745981 | 1745981 | CO | school | 804320 | 1350 | East Grand 2 | 80432000595 | 3556 | Granby Elementary School | Regular School | No | Elementary | PK | 05 | 2021 | grade_1 | 28 | 0 | 6 | 0 | 0 | 0 | 1 | 23 | 12 | 35 | 28 | 0 | 6 | 0 | 0 | 0 | 1 | 23 | 12 | 35 | ||||||||||||||||||||||||||||||||||
1746697 | 1746697 | CO | school | 804800 | 1420 | Jefferson County R-1 | 80480000752 | 5354 | Lumberg Elementary School | Regular School | No | Elementary | PK | 06 | 2021 | grade_1 | 6 | 1 | 33 | 1 | 1 | 1 | 1 | 32 | 12 | 44 | 6 | 1 | 33 | 1 | 1 | 1 | 1 | 32 | 12 | 44 | ||||||||||||||||||||||||||||||||||
1746887 | 1746887 | CO | school | 804800 | 1420 | Jefferson County R-1 | 80480000771 | 6828 | Peck Elementary School | Regular School | No | Elementary | KG | 05 | 2021 | grade_1 | 18 | 0 | 9 | 0 | 1 | 0 | 3 | 19 | 12 | 31 | 18 | 0 | 9 | 0 | 1 | 0 | 3 | 19 | 12 | 31 | ||||||||||||||||||||||||||||||||||
1746958 | 1746958 | CO | school | 804800 | 1420 | Jefferson County R-1 | 80480006724 | 7468 | Rose Stein International Elementary | Regular School | No | Elementary | PK | 06 | 2021 | grade_1 | 6 | 1 | 22 | 1 | 0 | 0 | 0 | 18 | 12 | 30 | 6 | 1 | 22 | 1 | 0 | 0 | 0 | 18 | 12 | 30 | ||||||||||||||||||||||||||||||||||
1747500 | 1747500 | CO | school | 803480 | 1520 | Durango 9-R | 80348006712 | 4384 | The Juniper School | Regular School | Yes | Elementary | KG | 05 | 2021 | grade_1 | 20 | 0 | 2 | 0 | 0 | 1 | 1 | 12 | 12 | 24 | 20 | 0 | 2 | 0 | 0 | 1 | 1 | 12 | 12 | 24 | ||||||||||||||||||||||||||||||||||
1747995 | 1747995 | CO | school | 805400 | 1560 | Thompson R2-J | 80540000930 | 890 | Mary Blair Elementary School | Regular School | No | Elementary | KG | 05 | 2021 | grade_1 | 15 | 0 | 6 | 0 | 0 | 0 | 2 | 11 | 12 | 23 | 15 | 0 | 6 | 0 | 0 | 0 | 2 | 11 | 12 | 23 | ||||||||||||||||||||||||||||||||||
1748030 | 1748030 | CO | school | 805400 | 1560 | Thompson R2-J | 80540000932 | 3320 | Garfield Elementary School | Regular School | No | Elementary | KG | 05 | 2021 | grade_1 | 27 | 0 | 8 | 1 | 0 | 0 | 0 | 24 | 12 | 36 | 27 | 0 | 8 | 1 | 0 | 0 | 0 | 24 | 12 | 36 | ||||||||||||||||||||||||||||||||||
1748112 | 1748112 | CO | school | 805400 | 1560 | Thompson R2-J | 80540000936 | 5992 | Monroe Elementary School | Regular School | No | Elementary | KG | 05 | 2021 | grade_1 | 15 | 0 | 15 | 0 | 0 | 0 | 1 | 19 | 12 | 31 | 15 | 0 | 15 | 0 | 0 | 0 | 1 | 19 | 12 | 31 | ||||||||||||||||||||||||||||||||||
1748334 | 1748334 | CO | school | 805280 | 1790 | Limon RE-4J | 80528000870 | 5132 | Limon Elementary School | Regular School | No | Elementary | KG | 05 | 2021 | grade_1 | 17 | 0 | 7 | 0 | 1 | 0 | 1 | 14 | 12 | 26 | 17 | 0 | 7 | 0 | 1 | 0 | 1 | 14 | 12 | 26 | ||||||||||||||||||||||||||||||||||
1749137 | 1749137 | CO | school | 807140 | 2505 | Weldon Valley RE-20(J) | 80714001217 | 9352 | Weldon Valley Elementary School | Regular School | No | Elementary | PK | 06 | 2021 | grade_1 | 18 | 0 | 1 | 0 | 0 | 0 | 0 | 7 | 12 | 19 | 18 | 0 | 1 | 0 | 0 | 0 | 0 | 7 | 12 | 19 | ||||||||||||||||||||||||||||||||||
1749226 | 1749226 | CO | school | 804110 | 2540 | Fowler R-4J | 80411001981 | 56 | Fowler Elementary School | Regular School | No | Elementary | KG | 06 | 2021 | grade_1 | 19 | 0 | 8 | 0 | 0 | 0 | 0 | 15 | 12 | 27 | 19 | 0 | 8 | 0 | 0 | 0 | 0 | 15 | 12 | 27 | ||||||||||||||||||||||||||||||||||
1749520 | 1749520 | CO | school | 806120 | 2690 | Pueblo City 60 | 80612001031 | 822 | Bessemer Elementary School | Regular School | No | Elementary | PK | 05 | 2021 | grade_1 | 4 | 4 | 25 | 1 | 0 | 0 | 0 | 22 | 12 | 34 | 4 | 4 | 25 | 1 | 0 | 0 | 0 | 22 | 12 | 34 | ||||||||||||||||||||||||||||||||||
1751154 | 1751154 | CO | school | 800020 | 8001 | Charter School Institute | 80002006796 | 1005 | Ascent Classical Academy Northern Colorado | Regular School | Yes | Elementary | KG | 06 | 2021 | grade_1 | 29 | 0 | 1 | 1 | 0 | 0 | 1 | 20 | 12 | 32 | 29 | 0 | 1 | 1 | 0 | 0 | 1 | 20 | 12 | 32 | ||||||||||||||||||||||||||||||||||
1738939 | 1738939 | CO | school | 802580 | 40 | School District 27J | 80258000148 | 6294 | North Elementary School | Regular School | No | Elementary | PK | 05 | 2021 | grade_1 | 4 | 0 | 27 | 0 | 0 | 0 | 1 | 19 | 13 | 32 | 4 | 0 | 27 | 0 | 0 | 0 | 1 | 19 | 13 | 32 | ||||||||||||||||||||||||||||||||||
1743142 | 1743142 | CO | school | 803360 | 880 | Denver County 1 | 80336000426 | 9548 | Whittier ECE-8 School | Regular School | No | Elementary | PK | 08 | 2021 | grade_1 | 6 | 11 | 9 | 0 | 0 | 0 | 1 | 14 | 13 | 27 | 6 | 11 | 9 | 0 | 0 | 0 | 1 | 14 | 13 | 27 | ||||||||||||||||||||||||||||||||||
1747539 | 1747539 | CO | school | 803480 | 1520 | Durango 9-R | 80348000457 | 8388 | Sunnyside Elementary School | Regular School | No | Elementary | PK | 05 | 2021 | grade_1 | 14 | 0 | 9 | 1 | 0 | 0 | 1 | 12 | 13 | 25 | 14 | 0 | 9 | 1 | 0 | 0 | 1 | 12 | 13 | 25 | ||||||||||||||||||||||||||||||||||
1747801 | 1747801 | CO | school | 803990 | 1550 | Poudre R-1 | 80399006573 | 5917 | Mountain Sage Community School | Regular School | Yes | Elementary | KG | 08 | 2021 | grade_1 | 23 | 0 | 1 | 0 | 0 | 0 | 2 | 13 | 13 | 26 | 23 | 0 | 1 | 0 | 0 | 0 | 2 | 13 | 13 | 26 | ||||||||||||||||||||||||||||||||||
1748369 | 1748369 | CO | school | 806690 | 1828 | Valley RE-1 | 80669001361 | 1220 | Caliche Elementary School | Regular School | No | Elementary | PK | 06 | 2021 | grade_1 | 17 | 0 | 3 | 0 | 0 | 0 | 1 | 8 | 13 | 21 | 17 | 0 | 3 | 0 | 0 | 0 | 1 | 8 | 13 | 21 | ||||||||||||||||||||||||||||||||||
1748890 | 1748890 | CO | school | 803090 | 2035 | Montezuma-Cortez RE-1 | 80309000837 | 5090 | Lewis-Arriola Elementary School | Regular School | No | Elementary | KG | 05 | 2021 | grade_1 | 19 | 0 | 0 | 1 | 0 | 0 | 1 | 8 | 13 | 21 | 19 | 0 | 0 | 1 | 0 | 0 | 1 | 8 | 13 | 21 | ||||||||||||||||||||||||||||||||||
1749347 | 1749347 | CO | school | 803840 | 2610 | Park County RE-2 | 80384000502 | 8114 | Edith Teter Elementary School | Regular School | No | Elementary | PK | 05 | 2021 | grade_1 | 28 | 0 | 3 | 0 | 1 | 0 | 1 | 20 | 13 | 33 | 28 | 0 | 3 | 0 | 1 | 0 | 1 | 20 | 13 | 33 | ||||||||||||||||||||||||||||||||||
1750433 | 1750433 | CO | school | 804200 | 3080 | Weld County RE-1 | 80420000575 | 3398 | Gilcrest Elementary School | Regular School | No | Elementary | PK | 05 | 2021 | grade_1 | 14 | 0 | 19 | 0 | 0 | 0 | 0 | 20 | 13 | 33 | 14 | 0 | 19 | 0 | 0 | 0 | 0 | 20 | 13 | 33 | ||||||||||||||||||||||||||||||||||
1750494 | 1750494 | CO | school | 804920 | 3090 | Weld County School District RE-3J | 80492001760 | 1299 | Cardinal Community Academy Charter School | Regular School | Yes | Elementary | KG | 08 | 2021 | grade_1 | 18 | 0 | 1 | 0 | 0 | 0 | 0 | 6 | 13 | 19 | 18 | 0 | 1 | 0 | 0 | 0 | 0 | 6 | 13 | 19 | ||||||||||||||||||||||||||||||||||
1751126 | 1751126 | CO | school | 800020 | 8001 | Charter School Institute | 80002002018 | 653 | Stone Creek School | Regular School | Yes | Elementary | KG | 08 | 2021 | grade_1 | 25 | 0 | 2 | 0 | 1 | 0 | 1 | 16 | 13 | 29 | 25 | 0 | 2 | 0 | 1 | 0 | 1 | 16 | 13 | 29 | ||||||||||||||||||||||||||||||||||
1751393 | 1751393 | CO | school | 800020 | 8001 | Charter School Institute | 80002006320 | 7278 | Ricardo Flores Magon Academy | Regular School | Yes | Elementary | KG | 08 | 2021 | grade_1 | 2 | 0 | 17 | 0 | 0 | 0 | 0 | 6 | 13 | 19 | 2 | 0 | 17 | 0 | 0 | 0 | 0 | 6 | 13 | 19 | ||||||||||||||||||||||||||||||||||
1751486 | 1751486 | CO | school | 800004 | 9130 | Expeditionary BOCES | 80000400709 | 2840 | Rocky Mountain School of Expeditionary Learning | Regular School | No | Other | KG | 12 | 2021 | grade_1 | 21 | 0 | 3 | 0 | 0 | 0 | 3 | 14 | 13 | 27 | 21 | 0 | 3 | 0 | 0 | 0 | 3 | 14 | 13 | 27 | ||||||||||||||||||||||||||||||||||
1739137 | 1739137 | CO | school | 807230 | 70 | Westminster Public Schools | 80723001241 | 5388 | Colorado Sports Leadership Academy | Regular School | No | Elementary | KG | 08 | 2021 | grade_1 | 2 | 0 | 30 | 1 | 0 | 0 | 0 | 19 | 14 | 33 | 2 | 0 | 30 | 1 | 0 | 0 | 0 | 19 | 14 | 33 | ||||||||||||||||||||||||||||||||||
1740369 | 1740369 | CO | school | 802340 | 180 | Adams-Arapahoe 28J | 80234006732 | 9053 | Vega Collegiate Academy | Regular School | Yes | Elementary | KG | 08 | 2021 | grade_1 | 3 | 0 | 22 | 0 | 8 | 0 | 0 | 19 | 14 | 33 | 3 | 0 | 22 | 0 | 8 | 0 | 0 | 19 | 14 | 33 | ||||||||||||||||||||||||||||||||||
1742237 | 1742237 | CO | school | 803360 | 880 | Denver County 1 | 80336000337 | 2364 | Eagleton Elementary School | Regular School | No | Elementary | PK | 05 | 2021 | grade_1 | 7 | 2 | 34 | 0 | 0 | 0 | 0 | 29 | 14 | 43 | 7 | 2 | 34 | 0 | 0 | 0 | 0 | 29 | 14 | 43 | ||||||||||||||||||||||||||||||||||
1742354 | 1742354 | CO | school | 803360 | 880 | Denver County 1 | 80336001738 | 3605 | Grant Ranch ECE-8 School | Regular School | No | Elementary | PK | 08 | 2021 | grade_1 | 10 | 4 | 11 | 0 | 0 | 0 | 2 | 13 | 14 | 27 | 10 | 4 | 11 | 0 | 0 | 0 | 2 | 13 | 14 | 27 | ||||||||||||||||||||||||||||||||||
1742643 | 1742643 | CO | school | 803360 | 880 | Denver County 1 | 80336006445 | 5608 | Mathematics and Science Leadership Academy | Regular School | No | Elementary | KG | 05 | 2021 | grade_1 | 1 | 0 | 19 | 0 | 0 | 0 | 3 | 9 | 14 | 23 | 1 | 0 | 19 | 0 | 0 | 0 | 3 | 9 | 14 | 23 | ||||||||||||||||||||||||||||||||||
1742983 | 1742983 | CO | school | 803360 | 880 | Denver County 1 | 80336006525 | 8131 | Oakland Elementary | Regular School | No | Elementary | PK | 05 | 2021 | grade_1 | 0 | 7 | 29 | 0 | 2 | 2 | 3 | 29 | 14 | 43 | 0 | 7 | 29 | 0 | 2 | 2 | 3 | 29 | 14 | 43 | ||||||||||||||||||||||||||||||||||
1744293 | 1744293 | CO | school | 804530 | 980 | Harrison 2 | 80453000671 | 8337 | Stratmoor Hills Elementary School | Regular School | No | Elementary | PK | 05 | 2021 | grade_1 | 14 | 5 | 13 | 0 | 0 | 0 | 2 | 20 | 14 | 34 | 14 | 5 | 13 | 0 | 0 | 0 | 2 | 20 | 14 | 34 | ||||||||||||||||||||||||||||||||||
1744643 | 1744643 | CO | school | 803060 | 1010 | Colorado Springs 11 | 80306001318 | 3470 | Globe Charter School | Regular School | Yes | Elementary | KG | 06 | 2021 | grade_1 | 11 | 3 | 6 | 0 | 0 | 0 | 1 | 7 | 14 | 21 | 11 | 3 | 6 | 0 | 0 | 0 | 1 | 7 | 14 | 21 | ||||||||||||||||||||||||||||||||||
1744723 | 1744723 | CO | school | 803060 | 1010 | Colorado Springs 11 | 80306000252 | 5576 | Twain Elementary School | Regular School | No | Elementary | PK | 05 | 2021 | grade_1 | 18 | 6 | 18 | 2 | 0 | 0 | 1 | 31 | 14 | 45 | 18 | 6 | 18 | 2 | 0 | 0 | 1 | 31 | 14 | 45 | ||||||||||||||||||||||||||||||||||
1744841 | 1744841 | CO | school | 803060 | 1010 | Colorado Springs 11 | 80306000267 | 8466 | Taylor Elementary School | Regular School | No | Elementary | PK | 05 | 2021 | grade_1 | 17 | 3 | 5 | 1 | 1 | 1 | 1 | 15 | 14 | 29 | 17 | 3 | 5 | 1 | 1 | 1 | 1 | 15 | 14 | 29 | ||||||||||||||||||||||||||||||||||
1745389 | 1745389 | CO | school | 803870 | 1110 | District 49 | 80387006778 | 431 | Falcon Homeschool Program | Regular School | No | Other | KG | 12 | 2021 | grade_1 | 18 | 0 | 4 | 0 | 1 | 0 | 1 | 10 | 14 | 24 | 18 | 0 | 4 | 0 | 1 | 0 | 1 | 10 | 14 | 24 | ||||||||||||||||||||||||||||||||||
1745883 | 1745883 | CO | school | 806240 | 1195 | Garfield Re-2 | 80624001598 | 4510 | Kathryn Senor Elementary School | Regular School | No | Elementary | PK | 05 | 2021 | grade_1 | 9 | 0 | 17 | 0 | 0 | 0 | 1 | 13 | 14 | 27 | 9 | 0 | 17 | 0 | 0 | 0 | 1 | 13 | 14 | 27 | ||||||||||||||||||||||||||||||||||
1746231 | 1746231 | CO | school | 804800 | 1420 | Jefferson County R-1 | 80480000702 | 1238 | Campbell Elementary School | Regular School | No | Elementary | KG | 05 | 2021 | grade_1 | 27 | 0 | 7 | 0 | 1 | 0 | 1 | 22 | 14 | 36 | 27 | 0 | 7 | 0 | 1 | 0 | 1 | 22 | 14 | 36 | ||||||||||||||||||||||||||||||||||
1746265 | 1746265 | CO | school | 804800 | 1420 | Jefferson County R-1 | 80480000705 | 1790 | Colorow Elementary School | Regular School | No | Elementary | PK | 05 | 2021 | grade_1 | 23 | 0 | 4 | 0 | 0 | 0 | 3 | 16 | 14 | 30 | 23 | 0 | 4 | 0 | 0 | 0 | 3 | 16 | 14 | 30 | ||||||||||||||||||||||||||||||||||
1746525 | 1746525 | CO | school | 804800 | 1420 | Jefferson County R-1 | 80480006723 | 3691 | Great Work Montessori | Regular School | Yes | Elementary | PK | 06 | 2021 | grade_1 | 13 | 1 | 10 | 0 | 1 | 0 | 3 | 14 | 14 | 28 | 13 | 1 | 10 | 0 | 1 | 0 | 3 | 14 | 14 | 28 | ||||||||||||||||||||||||||||||||||
1746894 | 1746894 | CO | school | 804800 | 1420 | Jefferson County R-1 | 80480000772 | 6844 | Peiffer Elementary School | Regular School | No | Elementary | PK | 05 | 2021 | grade_1 | 25 | 0 | 8 | 0 | 2 | 0 | 2 | 23 | 14 | 37 | 25 | 0 | 8 | 0 | 2 | 0 | 2 | 23 | 14 | 37 | ||||||||||||||||||||||||||||||||||
1747233 | 1747233 | CO | school | 804800 | 1420 | Jefferson County R-1 | 80480000800 | 9424 | West Jefferson Elementary School | Regular School | No | Elementary | PK | 05 | 2021 | grade_1 | 23 | 0 | 1 | 0 | 2 | 0 | 3 | 15 | 14 | 29 | 23 | 0 | 1 | 0 | 2 | 0 | 3 | 15 | 14 | 29 | ||||||||||||||||||||||||||||||||||
1748513 | 1748513 | CO | school | 804350 | 2000 | Mesa County Valley 51 | 80435000599 | 1046 | Broadway Elementary School | Regular School | No | Elementary | PK | 05 | 2021 | grade_1 | 27 | 0 | 0 | 0 | 2 | 0 | 0 | 15 | 14 | 29 | 27 | 0 | 0 | 0 | 2 | 0 | 0 | 15 | 14 | 29 | ||||||||||||||||||||||||||||||||||
1748949 | 1748949 | CO | school | 805460 | 2070 | Mancos Re-6 | 80546000943 | 5446 | Mancos Elementary School | Regular School | No | Elementary | KG | 05 | 2021 | grade_1 | 16 | 0 | 7 | 1 | 0 | 0 | 1 | 11 | 14 | 25 | 16 | 0 | 7 | 1 | 0 | 0 | 1 | 11 | 14 | 25 | ||||||||||||||||||||||||||||||||||
1751147 | 1751147 | CO | school | 800020 | 8001 | Charter School Institute | 80002001998 | 657 | Academy of Arts and Knowledge Elementary | Regular School | Yes | Elementary | KG | 05 | 2021 | grade_1 | 19 | 0 | 4 | 0 | 0 | 0 | 3 | 12 | 14 | 26 | 19 | 0 | 4 | 0 | 0 | 0 | 3 | 12 | 14 | 26 | ||||||||||||||||||||||||||||||||||
1743252 | 1743252 | CO | school | 803450 | 900 | Douglas County Re 1 | 80345001896 | 215 | American Academy | Regular School | Yes | Elementary | PK | 08 | 2021 | grade_1 | 175 | 3 | 29 | 0 | 61 | 0 | 29 | 153 | 144 | 297 | 175 | 3 | 29 | 0 | 61 | 0 | 29 | 153 | 144 | 297 | ||||||||||||||||||||||||||||||||||
1739209 | 1739209 | CO | school | 807230 | 70 | Westminster Public Schools | 80723006675 | 9236 | Westminster Academy for International Studies | Regular School | No | Elementary | PK | 08 | 2021 | grade_1 | 9 | 0 | 19 | 1 | 0 | 0 | 1 | 15 | 15 | 30 | 9 | 0 | 19 | 1 | 0 | 0 | 1 | 15 | 15 | 30 | ||||||||||||||||||||||||||||||||||
1739435 | 1739435 | CO | school | 802910 | 130 | Cherry Creek 5 | 80291000763 | 1510 | Challenge School | Regular School | No | Elementary | PK | 08 | 2021 | grade_1 | 16 | 2 | 3 | 0 | 11 | 0 | 8 | 25 | 15 | 40 | 16 | 2 | 3 | 0 | 11 | 0 | 8 | 25 | 15 | 40 | ||||||||||||||||||||||||||||||||||
1739993 | 1739993 | CO | school | 802340 | 180 | Adams-Arapahoe 28J | 80234006399 | 213 | AXL Academy | Regular School | Yes | Elementary | PK | 08 | 2021 | grade_1 | 6 | 9 | 14 | 1 | 0 | 0 | 2 | 17 | 15 | 32 | 6 | 9 | 14 | 1 | 0 | 0 | 2 | 17 | 15 | 32 | ||||||||||||||||||||||||||||||||||
1740865 | 1740865 | CO | school | 805370 | 470 | St Vrain Valley RE1J | 80537000904 | 4278 | Indian Peaks Elementary School | Regular School | No | Elementary | PK | 05 | 2021 | grade_1 | 2 | 0 | 35 | 0 | 2 | 0 | 0 | 24 | 15 | 39 | 2 | 0 | 35 | 0 | 2 | 0 | 0 | 24 | 15 | 39 | ||||||||||||||||||||||||||||||||||
1741191 | 1741191 | CO | school | 802490 | 480 | Boulder Valley Re 2 | 80249000111 | 2240 | Douglass Elementary School | Regular School | No | Elementary | PK | 05 | 2021 | grade_1 | 37 | 0 | 5 | 0 | 0 | 0 | 1 | 28 | 15 | 43 | 37 | 0 | 5 | 0 | 0 | 0 | 1 | 28 | 15 | 43 | ||||||||||||||||||||||||||||||||||
1741249 | 1741249 | CO | school | 802490 | 480 | Boulder Valley Re 2 | 80249000115 | 2970 | Flatirons Elementary School | Regular School | No | Elementary | KG | 05 | 2021 | grade_1 | 27 | 1 | 1 | 0 | 0 | 0 | 1 | 15 | 15 | 30 | 27 | 1 | 1 | 0 | 0 | 0 | 1 | 15 | 15 | 30 | ||||||||||||||||||||||||||||||||||
1741930 | 1741930 | CO | school | 803360 | 880 | Denver County 1 | 80336000320 | 1106 | Bryant Webster Dual Language ECE-8 School | Regular School | No | Elementary | PK | 08 | 2021 | grade_1 | 7 | 0 | 24 | 0 | 0 | 0 | 3 | 19 | 15 | 34 | 7 | 0 | 24 | 0 | 0 | 0 | 3 | 19 | 15 | 34 | ||||||||||||||||||||||||||||||||||
1742281 | 1742281 | CO | school | 803360 | 880 | Denver County 1 | 80336000347 | 2880 | Fairview Elementary School | Regular School | No | Elementary | PK | 05 | 2021 | grade_1 | 2 | 14 | 12 | 0 | 1 | 0 | 1 | 15 | 15 | 30 | 2 | 14 | 12 | 0 | 1 | 0 | 1 | 15 | 15 | 30 |
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]);