enrollments
Data source: Big Local News · About: Big Local
1,106 rows where grade = "grade_1", state = "CO" and year = 2021 sorted by hispanic
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1740554 | 1740554 | CO | school | 807110 | 230 | Walsh RE-1 | 80711001215 | 9222 | Walsh Elementary School | Regular School | No | Elementary | PK | 06 | 2021 | grade_1 | 14 | 0 | 0 | 0 | 0 | 0 | 0 | 6 | 8 | 14 | 14 | 0 | 0 | 0 | 0 | 0 | 0 | 6 | 8 | 14 | ||||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||
1740669 | 1740669 | CO | school | 805580 | 310 | McClave Re-2 | 80558000962 | 5666 | McClave Elementary School | Regular School | No | Elementary | PK | 06 | 2021 | grade_1 | 14 | 0 | 0 | 0 | 0 | 0 | 0 | 7 | 7 | 14 | 14 | 0 | 0 | 0 | 0 | 0 | 0 | 7 | 7 | 14 | ||||||||||||||||||||||||||||||||||
1741576 | 1741576 | CO | school | 803000 | 540 | Clear Creek RE-1 | 80300001332 | 4700 | King-Murphy Elementary School | Regular School | No | Elementary | PK | 06 | 2021 | grade_1 | 12 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 8 | 12 | 12 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 8 | 12 | ||||||||||||||||||||||||||||||||||
1742880 | 1742880 | CO | school | 803360 | 880 | Denver County 1 | 80336006641 | 7243 | Reach Charter School | Regular School | Yes | Elementary | PK | 05 | 2021 | grade_1 | 5 | 2 | 0 | 0 | 0 | 0 | 2 | 6 | 3 | 9 | 5 | 2 | 0 | 0 | 0 | 0 | 2 | 6 | 3 | 9 | ||||||||||||||||||||||||||||||||||
1745938 | 1745938 | CO | school | 804230 | 1330 | Gilpin County RE-1 | 80423000581 | 1632 | Gilpin County Elementary School | Regular School | No | Elementary | PK | 05 | 2021 | grade_1 | 27 | 1 | 0 | 1 | 2 | 0 | 0 | 16 | 15 | 31 | 27 | 1 | 0 | 1 | 2 | 0 | 0 | 16 | 15 | 31 | ||||||||||||||||||||||||||||||||||
1746037 | 1746037 | CO | school | 804620 | 1380 | Hinsdale County RE 1 | 80462001969 | 4899 | Lake City Community School | Regular School | No | Other | PK | 12 | 2021 | grade_1 | 4 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 3 | 4 | 4 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 3 | 4 | ||||||||||||||||||||||||||||||||||
1746303 | 1746303 | CO | school | 804800 | 1420 | Jefferson County R-1 | 80480001766 | 1880 | Compass Montessori - Golden Charter School | Regular School | Yes | Other | PK | 12 | 2021 | grade_1 | 17 | 0 | 0 | 0 | 1 | 0 | 0 | 12 | 6 | 18 | 17 | 0 | 0 | 0 | 1 | 0 | 0 | 12 | 6 | 18 | ||||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||
1746863 | 1746863 | CO | school | 804800 | 1420 | Jefferson County R-1 | 80480000768 | 6804 | Parmalee Elementary School | Regular School | No | Elementary | KG | 05 | 2021 | grade_1 | 39 | 0 | 0 | 0 | 1 | 0 | 0 | 21 | 19 | 40 | 39 | 0 | 0 | 0 | 1 | 0 | 0 | 21 | 19 | 40 | ||||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||
1747865 | 1747865 | CO | school | 803990 | 1550 | Poudre R-1 | 80399006431 | 7198 | PSD Global Academy | Regular School | No | Other | KG | 12 | 2021 | grade_1 | 14 | 0 | 0 | 0 | 0 | 0 | 0 | 5 | 9 | 14 | 14 | 0 | 0 | 0 | 0 | 0 | 0 | 5 | 9 | 14 | ||||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||
1748319 | 1748319 | CO | school | 804740 | 1780 | Genoa-Hugo C113 | 80474000686 | 4162 | Genoa-Hugo School | Regular School | No | Other | PK | 12 | 2021 | grade_1 | 12 | 1 | 0 | 0 | 0 | 0 | 0 | 10 | 3 | 13 | 12 | 1 | 0 | 0 | 0 | 0 | 0 | 10 | 3 | 13 | ||||||||||||||||||||||||||||||||||
1748349 | 1748349 | CO | school | 804890 | 1810 | Karval RE-23 | 80489000814 | 4502 | Karval Elementary School | Regular School | No | Elementary | PK | 06 | 2021 | grade_1 | 4 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 3 | 4 | 4 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 3 | 4 | ||||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||
1748629 | 1748629 | CO | school | 804350 | 2000 | Mesa County Valley 51 | 80435006498 | 3604 | Grand River Academy | Regular School | No | Other | KG | 12 | 2021 | grade_1 | 5 | 0 | 0 | 0 | 0 | 0 | 0 | 2 | 3 | 5 | 5 | 0 | 0 | 0 | 0 | 0 | 0 | 2 | 3 | 5 | ||||||||||||||||||||||||||||||||||
1748790 | 1748790 | CO | school | 804350 | 2000 | Mesa County Valley 51 | 80435000624 | 9434 | Scenic Elementary School | Regular School | No | Elementary | KG | 05 | 2021 | grade_1 | 35 | 0 | 0 | 0 | 0 | 0 | 1 | 21 | 15 | 36 | 35 | 0 | 0 | 0 | 0 | 0 | 1 | 21 | 15 | 36 | ||||||||||||||||||||||||||||||||||
1748832 | 1748832 | CO | school | 805730 | 2020 | Moffat County RE: No 1 | 80573000980 | 5656 | Maybell School | Regular School | No | Elementary | KG | 06 | 2021 | grade_1 | 3 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 2 | 3 | 3 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 2 | 3 | ||||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||
1749068 | 1749068 | CO | school | 805850 | 2190 | West End RE-2 | 80585001693 | 6718 | Paradox Valley Charter School | Regular School | Yes | Other | PK | 12 | 2021 | grade_1 | 6 | 0 | 0 | 0 | 0 | 0 | 0 | 3 | 3 | 6 | 6 | 0 | 0 | 0 | 0 | 0 | 0 | 3 | 3 | 6 | ||||||||||||||||||||||||||||||||||
1749210 | 1749210 | CO | school | 805520 | 2535 | Manzanola 3J | 80552000949 | 5498 | Manzanola Elementary School | Regular School | No | Elementary | PK | 05 | 2021 | grade_1 | 5 | 0 | 0 | 0 | 0 | 0 | 2 | 5 | 2 | 7 | 5 | 0 | 0 | 0 | 0 | 0 | 2 | 5 | 2 | 7 | ||||||||||||||||||||||||||||||||||
1749332 | 1749332 | CO | school | 803840 | 2610 | Park County RE-2 | 80384000501 | 4908 | Lake George Charter School | Regular School | Yes | Elementary | PK | 08 | 2021 | grade_1 | 11 | 0 | 0 | 0 | 0 | 0 | 0 | 7 | 4 | 11 | 11 | 0 | 0 | 0 | 0 | 0 | 0 | 7 | 4 | 11 | ||||||||||||||||||||||||||||||||||
1749397 | 1749397 | CO | school | 802280 | 2640 | Aspen 1 | 80228001703 | 42 | Aspen Community Charter School | Regular School | Yes | Elementary | PK | 08 | 2021 | grade_1 | 15 | 0 | 0 | 0 | 1 | 0 | 0 | 8 | 8 | 16 | 15 | 0 | 0 | 0 | 1 | 0 | 0 | 8 | 8 | 16 | ||||||||||||||||||||||||||||||||||
1749756 | 1749756 | CO | school | 806150 | 2700 | Pueblo County 70 | 80615001071 | 852 | Beulah Elementary School | Regular School | No | Elementary | KG | 05 | 2021 | grade_1 | 10 | 0 | 0 | 0 | 0 | 0 | 1 | 8 | 3 | 11 | 10 | 0 | 0 | 0 | 0 | 0 | 1 | 8 | 3 | 11 | ||||||||||||||||||||||||||||||||||
1749796 | 1749796 | CO | school | 806150 | 2700 | Pueblo County 70 | 80615006763 | 6817 | PSAS Homeschool Program | Regular School | No | Elementary | KG | 08 | 2021 | grade_1 | 8 | 0 | 0 | 0 | 0 | 0 | 0 | 6 | 2 | 8 | 8 | 0 | 0 | 0 | 0 | 0 | 0 | 6 | 2 | 8 | ||||||||||||||||||||||||||||||||||
1750153 | 1750153 | CO | school | 806570 | 2820 | Silverton 1 | 80657001136 | 7900 | Silverton Elementary School | Regular School | No | Elementary | PK | 05 | 2021 | grade_1 | 4 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 3 | 4 | 4 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 3 | 4 | ||||||||||||||||||||||||||||||||||
1750417 | 1750417 | CO | school | 807410 | 3070 | Woodlin R-104 | 80741001270 | 9700 | Woodlin Elementary School | Regular School | No | Elementary | PK | 05 | 2021 | grade_1 | 4 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 4 | 4 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 4 | ||||||||||||||||||||||||||||||||||
1750968 | 1750968 | CO | school | 802550 | 3146 | Briggsdale RE-10 | 80255000142 | 1008 | Briggsdale Elementary School | Regular School | No | Elementary | PK | 05 | 2021 | grade_1 | 12 | 0 | 0 | 0 | 0 | 0 | 0 | 7 | 5 | 12 | 12 | 0 | 0 | 0 | 0 | 0 | 0 | 7 | 5 | 12 | ||||||||||||||||||||||||||||||||||
1750984 | 1750984 | CO | school | 806720 | 3147 | Prairie RE-11 | 80672001157 | 7154 | Prairie Elementary School | Regular School | No | Elementary | PK | 05 | 2021 | grade_1 | 11 | 0 | 0 | 0 | 1 | 0 | 0 | 8 | 4 | 12 | 11 | 0 | 0 | 0 | 1 | 0 | 0 | 8 | 4 | 12 | ||||||||||||||||||||||||||||||||||
1751000 | 1751000 | CO | school | 804440 | 3148 | Pawnee RE-12 | 80444000653 | 6812 | Pawnee School PK-12 | Regular School | No | Other | PK | 12 | 2021 | grade_1 | 6 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 6 | 6 | 6 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 6 | 6 | ||||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||
1751342 | 1751342 | CO | school | 800020 | 8001 | Charter School Institute | 80002006706 | 5845 | Monument View Montessori Charter School | Regular School | Yes | Elementary | PK | 05 | 2021 | grade_1 | 7 | 0 | 0 | 0 | 0 | 0 | 0 | 2 | 5 | 7 | 7 | 0 | 0 | 0 | 0 | 0 | 0 | 2 | 5 | 7 | ||||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||
1740619 | 1740619 | CO | school | 802760 | 270 | Campo RE-6 | 80276000169 | 1248 | Campo Elementary School | Regular School | No | Elementary | PK | 05 | 2021 | grade_1 | 6 | 0 | 1 | 0 | 0 | 0 | 0 | 5 | 2 | 7 | 6 | 0 | 1 | 0 | 0 | 0 | 0 | 5 | 2 | 7 | ||||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||
1741287 | 1741287 | CO | school | 802490 | 480 | Boulder Valley Re 2 | 80249000119 | 4386 | Jamestown Elementary School | Regular School | No | Elementary | KG | 05 | 2021 | grade_1 | 3 | 0 | 1 | 0 | 0 | 0 | 0 | 1 | 3 | 4 | 3 | 0 | 1 | 0 | 0 | 0 | 0 | 1 | 3 | 4 | ||||||||||||||||||||||||||||||||||
1741369 | 1741369 | CO | school | 802490 | 480 | Boulder Valley Re 2 | 80249000130 | 6208 | Nederland Elementary School | Regular School | No | Elementary | PK | 05 | 2021 | grade_1 | 28 | 0 | 1 | 0 | 0 | 0 | 1 | 14 | 16 | 30 | 28 | 0 | 1 | 0 | 0 | 0 | 1 | 14 | 16 | 30 | ||||||||||||||||||||||||||||||||||
1741518 | 1741518 | CO | school | 805040 | 510 | Kit Carson R-1 | 80504000827 | 4738 | Kit Carson Elementary School | Regular School | No | Elementary | PK | 05 | 2021 | grade_1 | 4 | 0 | 1 | 0 | 0 | 0 | 1 | 3 | 3 | 6 | 4 | 0 | 1 | 0 | 0 | 0 | 1 | 3 | 3 | 6 | ||||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||
1741724 | 1741724 | CO | school | 803330 | 870 | Delta County 50(J) | 80333000295 | 1952 | North Fork Montessori @ Crawford | Regular School | No | Elementary | PK | 06 | 2021 | grade_1 | 11 | 0 | 1 | 0 | 0 | 0 | 0 | 6 | 6 | 12 | 11 | 0 | 1 | 0 | 0 | 0 | 0 | 6 | 6 | 12 | ||||||||||||||||||||||||||||||||||
1743210 | 1743210 | CO | school | 803420 | 890 | Dolores County RE No.2 | 80342000435 | 7764 | Seventh Street Elementary School | Regular School | No | Elementary | PK | 05 | 2021 | grade_1 | 13 | 0 | 1 | 0 | 0 | 0 | 0 | 6 | 8 | 14 | 13 | 0 | 1 | 0 | 0 | 0 | 0 | 6 | 8 | 14 | ||||||||||||||||||||||||||||||||||
1743789 | 1743789 | CO | school | 803450 | 900 | Douglas County Re 1 | 80345001288 | 7319 | Renaissance Expedition Learn Outward Bound School | Regular School | No | Elementary | KG | 06 | 2021 | grade_1 | 42 | 1 | 1 | 0 | 0 | 0 | 2 | 26 | 20 | 46 | 42 | 1 | 1 | 0 | 0 | 0 | 2 | 26 | 20 | 46 | ||||||||||||||||||||||||||||||||||
1743863 | 1743863 | CO | school | 803450 | 900 | Douglas County Re 1 | 80345001963 | 8853 | Timber Trail Elementary School | Regular School | No | Elementary | PK | 05 | 2021 | grade_1 | 33 | 0 | 1 | 0 | 0 | 0 | 1 | 20 | 15 | 35 | 33 | 0 | 1 | 0 | 0 | 0 | 1 | 20 | 15 | 35 | ||||||||||||||||||||||||||||||||||
1744101 | 1744101 | CO | school | 803690 | 950 | Elbert 200 | 80369000480 | 2570 | Elbert Elementary School | Regular School | No | Elementary | PK | 05 | 2021 | grade_1 | 19 | 0 | 1 | 0 | 0 | 0 | 0 | 15 | 5 | 20 | 19 | 0 | 1 | 0 | 0 | 0 | 0 | 15 | 5 | 20 | ||||||||||||||||||||||||||||||||||
1744117 | 1744117 | CO | school | 801980 | 960 | Agate 300 | 80198000020 | 44 | Agate Elementary School | Regular School | No | Elementary | PK | 05 | 2021 | grade_1 | 2 | 0 | 1 | 0 | 0 | 0 | 0 | 1 | 2 | 3 | 2 | 0 | 1 | 0 | 0 | 0 | 0 | 1 | 2 | 3 | ||||||||||||||||||||||||||||||||||
1745375 | 1745375 | CO | school | 805820 | 1080 | Lewis-Palmer 38 | 80582001810 | 7165 | Prairie Winds Elementary School | Regular School | No | Elementary | PK | 06 | 2021 | grade_1 | 33 | 0 | 1 | 0 | 1 | 0 | 1 | 21 | 15 | 36 | 33 | 0 | 1 | 0 | 1 | 0 | 1 | 21 | 15 | 36 | ||||||||||||||||||||||||||||||||||
1745627 | 1745627 | CO | school | 803630 | 1120 | Edison 54 JT | 80363000478 | 2514 | Edison Elementary School | Regular School | No | Elementary | PK | 05 | 2021 | grade_1 | 6 | 0 | 1 | 0 | 0 | 0 | 0 | 3 | 4 | 7 | 6 | 0 | 1 | 0 | 0 | 0 | 0 | 3 | 4 | 7 | ||||||||||||||||||||||||||||||||||
1745683 | 1745683 | CO | school | 802790 | 1140 | Canon City RE-1 | 80279000174 | 5166 | Lincoln School of Science and Technology | Regular School | No | Elementary | KG | 05 | 2021 | grade_1 | 36 | 1 | 1 | 0 | 0 | 0 | 2 | 21 | 19 | 40 | 36 | 1 | 1 | 0 | 0 | 0 | 2 | 21 | 19 | 40 | ||||||||||||||||||||||||||||||||||
1745750 | 1745750 | CO | school | 803120 | 1160 | Cotopaxi RE-3 | 80312000276 | 3220 | Cotopaxi Elementary School | Regular School | No | Elementary | PK | 05 | 2021 | grade_1 | 14 | 0 | 1 | 1 | 0 | 0 | 1 | 13 | 4 | 17 | 14 | 0 | 1 | 1 | 0 | 0 | 1 | 13 | 4 | 17 | ||||||||||||||||||||||||||||||||||
1746027 | 1746027 | CO | school | 804470 | 1360 | Gunnison Watershed RE1J | 80447001507 | 5577 | Marble Charter School | Regular School | Yes | Other | KG | 10 | 2021 | grade_1 | 7 | 0 | 1 | 0 | 0 | 0 | 0 | 6 | 2 | 8 | 7 | 0 | 1 | 0 | 0 | 0 | 0 | 6 | 2 | 8 | ||||||||||||||||||||||||||||||||||
1746081 | 1746081 | CO | school | 805160 | 1400 | La Veta Re-2 | 80516000853 | 4860 | La Veta Elementary School | Regular School | No | Elementary | PK | 05 | 2021 | grade_1 | 10 | 0 | 1 | 1 | 0 | 0 | 0 | 8 | 4 | 12 | 10 | 0 | 1 | 1 | 0 | 0 | 0 | 8 | 4 | 12 | ||||||||||||||||||||||||||||||||||
1746286 | 1746286 | CO | school | 804800 | 1420 | Jefferson County R-1 | 80480001649 | 1869 | Compass Montessori - Wheat Ridge Charter School | Regular School | Yes | Elementary | PK | 06 | 2021 | grade_1 | 27 | 0 | 1 | 0 | 0 | 0 | 5 | 14 | 19 | 33 | 27 | 0 | 1 | 0 | 0 | 0 | 5 | 14 | 19 | 33 | ||||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||
1747292 | 1747292 | CO | school | 804800 | 1420 | Jefferson County R-1 | 80480000805 | 9648 | Wilmot Elementary School | Regular School | No | Elementary | PK | 05 | 2021 | grade_1 | 45 | 0 | 1 | 0 | 0 | 0 | 0 | 23 | 23 | 46 | 45 | 0 | 1 | 0 | 0 | 0 | 0 | 23 | 23 | 46 | ||||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||
1747325 | 1747325 | CO | school | 806930 | 1440 | Plainview RE-2 | 80693001198 | 6992 | Plainview Elementary School | Regular School | No | Elementary | PK | 05 | 2021 | grade_1 | 2 | 0 | 1 | 0 | 0 | 0 | 0 | 1 | 2 | 3 | 2 | 0 | 1 | 0 | 0 | 0 | 0 | 1 | 2 | 3 | ||||||||||||||||||||||||||||||||||
1747340 | 1747340 | CO | school | 802260 | 1450 | Arriba-Flagler C-20 | 80226000509 | 2960 | Flagler Public School | Regular School | No | Other | PK | 12 | 2021 | grade_1 | 7 | 0 | 1 | 0 | 0 | 0 | 0 | 4 | 4 | 8 | 7 | 0 | 1 | 0 | 0 | 0 | 0 | 4 | 4 | 8 | ||||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||
1747463 | 1747463 | CO | school | 803480 | 1520 | Durango 9-R | 80348006614 | 2097 | District 9-R Shared School | Regular School | No | Other | KG | 12 | 2021 | grade_1 | 28 | 0 | 1 | 0 | 0 | 0 | 0 | 22 | 7 | 29 | 28 | 0 | 1 | 0 | 0 | 0 | 0 | 22 | 7 | 29 | ||||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||
1747696 | 1747696 | CO | school | 803990 | 1550 | Poudre R-1 | 80399006613 | 3242 | Fort Collins Montessori School | Regular School | Yes | Elementary | PK | 06 | 2021 | grade_1 | 24 | 0 | 1 | 0 | 1 | 0 | 0 | 11 | 15 | 26 | 24 | 0 | 1 | 0 | 1 | 0 | 0 | 11 | 15 | 26 | ||||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||
1748188 | 1748188 | CO | school | 803810 | 1570 | Estes Park R-3 | 80381006426 | 2788 | Estes Park Options School | Alternative School | No | Other | KG | 12 | 2021 | grade_1 | 7 | 0 | 1 | 0 | 0 | 0 | 0 | 5 | 3 | 8 | 7 | 0 | 1 | 0 | 0 | 0 | 0 | 5 | 3 | 8 | ||||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||
1748400 | 1748400 | CO | school | 803930 | 1850 | Frenchman RE-3 | 80393000511 | 2980 | Fleming Elementary School | Regular School | No | Elementary | PK | 06 | 2021 | grade_1 | 12 | 0 | 1 | 0 | 0 | 0 | 0 | 8 | 5 | 13 | 12 | 0 | 1 | 0 | 0 | 0 | 0 | 8 | 5 | 13 | ||||||||||||||||||||||||||||||||||
1748431 | 1748431 | CO | school | 806030 | 1870 | Plateau RE-5 | 80603001022 | 6834 | Peetz Elementary School | Regular School | No | Elementary | PK | 06 | 2021 | grade_1 | 13 | 0 | 1 | 0 | 0 | 0 | 0 | 9 | 5 | 14 | 13 | 0 | 1 | 0 | 0 | 0 | 0 | 9 | 5 | 14 | ||||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||
1749206 | 1749206 | CO | school | 806270 | 2530 | Rocky Ford R-2 | 80627001104 | 9264 | Washington Primary School | Regular School | No | Elementary | PK | 02 | 2021 | grade_1 | 54 | 1 | 1 | 0 | 0 | 0 | 0 | 32 | 24 | 56 | 54 | 1 | 1 | 0 | 0 | 0 | 0 | 32 | 24 | 56 | ||||||||||||||||||||||||||||||||||
1749242 | 1749242 | CO | school | 802880 | 2560 | Cheraw 31 | 80288000182 | 1546 | Cheraw School | Regular School | No | Other | PK | 12 | 2021 | grade_1 | 8 | 0 | 1 | 0 | 0 | 0 | 0 | 4 | 5 | 9 | 8 | 0 | 1 | 0 | 0 | 0 | 0 | 4 | 5 | 9 | ||||||||||||||||||||||||||||||||||
1749323 | 1749323 | CO | school | 803840 | 2610 | Park County RE-2 | 80384001695 | 3681 | Guffey Charter School | Regular School | Yes | Elementary | PK | 08 | 2021 | grade_1 | 4 | 0 | 1 | 0 | 0 | 0 | 0 | 3 | 2 | 5 | 4 | 0 | 1 | 0 | 0 | 0 | 0 | 3 | 2 | 5 | ||||||||||||||||||||||||||||||||||
1749381 | 1749381 | CO | school | 804560 | 2630 | Haxtun RE-2J | 80456000673 | 3846 | Haxtun Elementary School | Regular School | No | Elementary | PK | 08 | 2021 | grade_1 | 22 | 0 | 1 | 0 | 0 | 0 | 0 | 14 | 9 | 23 | 22 | 0 | 1 | 0 | 0 | 0 | 0 | 14 | 9 | 23 | ||||||||||||||||||||||||||||||||||
1750026 | 1750026 | CO | school | 806660 | 2770 | Steamboat Springs RE-2 | 80666001749 | 6363 | North Routt Charter School | Regular School | Yes | Elementary | PK | 08 | 2021 | grade_1 | 10 | 0 | 1 | 0 | 0 | 0 | 2 | 6 | 7 | 13 | 10 | 0 | 1 | 0 | 0 | 0 | 2 | 6 | 7 | 13 | ||||||||||||||||||||||||||||||||||
1750075 | 1750075 | CO | school | 805910 | 2780 | South Routt RE 3 | 80591001015 | 8120 | South Routt Elementary School | Regular School | No | Elementary | KG | 05 | 2021 | grade_1 | 15 | 0 | 1 | 0 | 0 | 0 | 0 | 10 | 6 | 16 | 15 | 0 | 1 | 0 | 0 | 0 | 0 | 10 | 6 | 16 | ||||||||||||||||||||||||||||||||||
1750097 | 1750097 | CO | school | 805700 | 2800 | Moffat 2 | 80570001511 | 2018 | Crestone Charter School | Regular School | Yes | Other | KG | 12 | 2021 | grade_1 | 4 | 0 | 1 | 0 | 0 | 0 | 0 | 1 | 4 | 5 | 4 | 0 | 1 | 0 | 0 | 0 | 0 | 1 | 4 | 5 | ||||||||||||||||||||||||||||||||||
1750385 | 1750385 | CO | school | 805940 | 3050 | Otis R-3 | 80594001016 | 6582 | Otis Elementary School | Regular School | No | Elementary | PK | 05 | 2021 | grade_1 | 15 | 0 | 1 | 0 | 0 | 0 | 0 | 8 | 8 | 16 | 15 | 0 | 1 | 0 | 0 | 0 | 0 | 8 | 8 | 16 | ||||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||
1751049 | 1751049 | CO | school | 800018 | 3220 | Idalia RJ-3 | 80001801741 | 4227 | Idalia Elementary School | Regular School | No | Elementary | PK | 06 | 2021 | grade_1 | 4 | 0 | 1 | 0 | 0 | 0 | 0 | 2 | 3 | 5 | 4 | 0 | 1 | 0 | 0 | 0 | 0 | 2 | 3 | 5 | ||||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||
1751413 | 1751413 | CO | school | 800020 | 8001 | Charter School Institute | 80002006651 | 8061 | Salida Montessori Charter School | Regular School | Yes | Elementary | PK | 08 | 2021 | grade_1 | 10 | 0 | 1 | 0 | 0 | 0 | 0 | 5 | 6 | 11 | 10 | 0 | 1 | 0 | 0 | 0 | 0 | 5 | 6 | 11 | ||||||||||||||||||||||||||||||||||
1751458 | 1751458 | 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_1 | 3 | 0 | 1 | 0 | 0 | 0 | 0 | 1 | 3 | 4 | 3 | 0 | 1 | 0 | 0 | 0 | 0 | 1 | 3 | 4 | ||||||||||||||||||||||||||||||||||
1738478 | 1738478 | CO | school | 806900 | 20 | Adams 12 Five Star Schools | 80690001668 | 1937 | Coyote Ridge Elementary School | Regular School | No | Elementary | KG | 05 | 2021 | grade_1 | 42 | 2 | 10 | 0 | 4 | 0 | 4 | 30 | 32 | 62 | 42 | 2 | 10 | 0 | 4 | 0 | 4 | 30 | 32 | 62 | ||||||||||||||||||||||||||||||||||
1738752 | 1738752 | CO | school | 806900 | 20 | Adams 12 Five Star Schools | 80690006417 | 9431 | Westgate Charter | Regular School | Yes | Other | KG | 12 | 2021 | grade_1 | 37 | 1 | 10 | 0 | 3 | 0 | 2 | 23 | 30 | 53 | 37 | 1 | 10 | 0 | 3 | 0 | 2 | 23 | 30 | 53 | ||||||||||||||||||||||||||||||||||
1739788 | 1739788 | CO | school | 802910 | 130 | Cherry Creek 5 | 80291000206 | 9200 | Walnut Hills Community Elementary School | Regular School | No | Elementary | PK | 05 | 2021 | grade_1 | 25 | 3 | 10 | 0 | 3 | 0 | 4 | 20 | 25 | 45 | 25 | 3 | 10 | 0 | 3 | 0 | 4 | 20 | 25 | 45 | ||||||||||||||||||||||||||||||||||
1740769 | 1740769 | CO | school | 805370 | 470 | St Vrain Valley RE1J | 80537000897 | 1434 | Central Elementary School | Regular School | No | Elementary | PK | 05 | 2021 | grade_1 | 31 | 1 | 10 | 0 | 0 | 0 | 2 | 22 | 22 | 44 | 31 | 1 | 10 | 0 | 0 | 0 | 2 | 22 | 22 | 44 | ||||||||||||||||||||||||||||||||||
1741308 | 1741308 | CO | school | 802490 | 480 | Boulder Valley Re 2 | 80249000121 | 4874 | Lafayette Elementary School | Regular School | No | Elementary | PK | 05 | 2021 | grade_1 | 54 | 0 | 10 | 0 | 1 | 0 | 10 | 34 | 41 | 75 | 54 | 0 | 10 | 0 | 1 | 0 | 10 | 34 | 41 | 75 | ||||||||||||||||||||||||||||||||||
1741421 | 1741421 | CO | school | 802490 | 480 | Boulder Valley Re 2 | 80249001365 | 7528 | Ryan Elementary School | Regular School | No | Elementary | PK | 05 | 2021 | grade_1 | 46 | 2 | 10 | 0 | 2 | 0 | 8 | 32 | 36 | 68 | 46 | 2 | 10 | 0 | 2 | 0 | 8 | 32 | 36 | 68 | ||||||||||||||||||||||||||||||||||
1741634 | 1741634 | CO | school | 802130 | 580 | South Conejos RE-10 | 80213000033 | 248 | Guadalupe Elementary School | Regular School | No | Elementary | PK | 06 | 2021 | grade_1 | 0 | 0 | 10 | 0 | 0 | 0 | 0 | 6 | 4 | 10 | 0 | 0 | 10 | 0 | 0 | 0 | 0 | 6 | 4 | 10 | ||||||||||||||||||||||||||||||||||
1741666 | 1741666 | CO | school | 804140 | 740 | Sierra Grande R-30 | 80414000572 | 7880 | Sierra Grande K-12 School | Regular School | No | Other | PK | 12 | 2021 | grade_1 | 3 | 0 | 10 | 0 | 0 | 0 | 0 | 6 | 7 | 13 | 3 | 0 | 10 | 0 | 0 | 0 | 0 | 6 | 7 | 13 | ||||||||||||||||||||||||||||||||||
1742476 | 1742476 | CO | school | 803360 | 880 | Denver County 1 | 80336006570 | 4213 | Isabella Bird Community School | Regular School | No | Elementary | PK | 05 | 2021 | grade_1 | 44 | 10 | 10 | 0 | 8 | 0 | 8 | 40 | 40 | 80 | 44 | 10 | 10 | 0 | 8 | 0 | 8 | 40 | 40 | 80 | ||||||||||||||||||||||||||||||||||
1742569 | 1742569 | CO | school | 803360 | 880 | Denver County 1 | 80336000372 | 4782 | Hallett Academy | Regular School | No | Elementary | PK | 05 | 2021 | grade_1 | 1 | 31 | 10 | 0 | 0 | 0 | 0 | 24 | 18 | 42 | 1 | 31 | 10 | 0 | 0 | 0 | 0 | 24 | 18 | 42 | ||||||||||||||||||||||||||||||||||
1743380 | 1743380 | CO | school | 803450 | 900 | Douglas County Re 1 | 80345000812 | 1873 | Parker Core Knowledge Charter School | Regular School | Yes | Elementary | KG | 08 | 2021 | grade_1 | 53 | 0 | 10 | 1 | 12 | 0 | 4 | 42 | 38 | 80 | 53 | 0 | 10 | 1 | 12 | 0 | 4 | 42 | 38 | 80 | ||||||||||||||||||||||||||||||||||
1743467 | 1743467 | CO | school | 803450 | 900 | Douglas County Re 1 | 80345006337 | 2952 | Mammoth Heights Elementary | Regular School | No | Elementary | PK | 06 | 2021 | grade_1 | 60 | 4 | 10 | 0 | 4 | 0 | 3 | 40 | 41 | 81 | 60 | 4 | 10 | 0 | 4 | 0 | 3 | 40 | 41 | 81 |
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]);