enrollments
Data source: Big Local News · About: Big Local
1,104 rows where grade = "grade_2", state = "CO" and year = 2020 sorted by male
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1804406 | 1804406 | CO | school | 803450 | 900 | Douglas County Re 1 | 80345000439 | 1578 | Cherry Valley Elementary School | Regular School | No | Elementary | KG | 06 | 2020 | grade_2 | 7 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 8 | 8 | 7 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 8 | 8 | ||||||||||||||||||||||||||||||||||
1809975 | 1809975 | CO | school | 805730 | 2020 | Moffat County RE: No 1 | 80573000980 | 5656 | Maybell School | Regular School | No | Elementary | KG | 06 | 2020 | grade_2 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 1 | ||||||||||||||||||||||||||||||||||
1801018 | 1801018 | CO | school | 180 | Adams-Arapahoe 28J | 1 | Facilities with District Run Education | 2020 | grade_2 | 0 | 0 | 2 | 0 | 0 | 0 | 0 | 1 | 1 | 2 | 0 | 0 | 2 | 0 | 0 | 0 | 0 | 1 | 1 | 2 | |||||||||||||||||||||||||||||||||||||||||
1808155 | 1808155 | CO | school | 804800 | 1420 | Jefferson County R-1 | 80480006307 | 8036 | Sobesky Academy | Special Education School | No | Other | KG | 12 | 2020 | grade_2 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | ||||||||||||||||||||||||||||||||||
1808507 | 1808507 | CO | school | 802460 | 1490 | Bethune R-5 | 80246000095 | 842 | Bethune Public Schools | Regular School | No | Other | PK | 12 | 2020 | grade_2 | 5 | 0 | 1 | 0 | 0 | 0 | 0 | 1 | 5 | 6 | 5 | 0 | 1 | 0 | 0 | 0 | 0 | 1 | 5 | 6 | ||||||||||||||||||||||||||||||||||
1809446 | 1809446 | CO | school | 804980 | 1760 | Kim Reorganized 88 | 80498000822 | 4690 | Kim Elementary School | Regular School | No | Elementary | PK | 05 | 2020 | grade_2 | 1 | 0 | 2 | 0 | 0 | 0 | 0 | 1 | 2 | 3 | 1 | 0 | 2 | 0 | 0 | 0 | 0 | 1 | 2 | 3 | ||||||||||||||||||||||||||||||||||
1809491 | 1809491 | CO | school | 804890 | 1810 | Karval RE-23 | 80489000814 | 4502 | Karval Elementary School | Regular School | No | Elementary | PK | 06 | 2020 | grade_2 | 2 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 1 | 2 | 2 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 1 | 2 | ||||||||||||||||||||||||||||||||||
1809776 | 1809776 | CO | school | 804350 | 2000 | Mesa County Valley 51 | 80435006498 | 3604 | Grand River Academy | Regular School | No | Other | KG | 12 | 2020 | grade_2 | 2 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 1 | 2 | 2 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 1 | 2 | ||||||||||||||||||||||||||||||||||
1809951 | 1809951 | CO | school | 803150 | 2010 | Creede School District | 80315000279 | 1966 | Creede School | Regular School | No | Other | PK | 12 | 2020 | grade_2 | 4 | 0 | 2 | 0 | 0 | 0 | 0 | 1 | 5 | 6 | 4 | 0 | 2 | 0 | 0 | 0 | 0 | 1 | 5 | 6 | ||||||||||||||||||||||||||||||||||
1810139 | 1810139 | CO | school | 805790 | 2180 | Montrose County RE-1J | 80579006499 | 6262 | Peak Virtual Academy | Regular School | No | Other | KG | 12 | 2020 | grade_2 | 6 | 0 | 2 | 0 | 0 | 0 | 0 | 1 | 7 | 8 | 6 | 0 | 2 | 0 | 0 | 0 | 0 | 1 | 7 | 8 | ||||||||||||||||||||||||||||||||||
1810907 | 1810907 | CO | school | 806150 | 2700 | Pueblo County 70 | 80615006496 | 5990 | 70 Online | Alternative School | No | Other | KG | 12 | 2020 | grade_2 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 1 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 1 | 0 | 1 | ||||||||||||||||||||||||||||||||||
1812184 | 1812184 | CO | school | 800019 | 3230 | Liberty J-4 | 80001901744 | 5123 | Liberty School | Career and Technical School | No | Other | PK | 12 | 2020 | grade_2 | 3 | 0 | 2 | 0 | 0 | 0 | 0 | 1 | 4 | 5 | 3 | 0 | 2 | 0 | 0 | 0 | 0 | 1 | 4 | 5 | ||||||||||||||||||||||||||||||||||
1801674 | 1801674 | CO | school | 805250 | 290 | Las Animas RE-1 | 80525000866 | 1812 | Las Animas Elementary School | Regular School | No | Elementary | KG | 06 | 2020 | grade_2 | 16 | 0 | 10 | 0 | 0 | 0 | 2 | 10 | 18 | 28 | 16 | 0 | 10 | 0 | 0 | 0 | 2 | 10 | 18 | 28 | ||||||||||||||||||||||||||||||||||
1802661 | 1802661 | CO | school | 802130 | 580 | South Conejos RE-10 | 80213000033 | 248 | Guadalupe Elementary School | Regular School | No | Elementary | PK | 06 | 2020 | grade_2 | 2 | 0 | 10 | 0 | 0 | 0 | 0 | 10 | 2 | 12 | 2 | 0 | 10 | 0 | 0 | 0 | 0 | 10 | 2 | 12 | ||||||||||||||||||||||||||||||||||
1804224 | 1804224 | CO | school | 803360 | 880 | Denver County 1 | 80336001637 | 9739 | Wyatt Academy | Regular School | Yes | Elementary | KG | 05 | 2020 | grade_2 | 3 | 6 | 17 | 0 | 0 | 0 | 0 | 10 | 16 | 26 | 3 | 6 | 17 | 0 | 0 | 0 | 0 | 10 | 16 | 26 | ||||||||||||||||||||||||||||||||||
1804239 | 1804239 | CO | school | 803420 | 890 | Dolores County RE No.2 | 80342000435 | 7764 | Seventh Street Elementary School | Regular School | No | Elementary | PK | 05 | 2020 | grade_2 | 15 | 0 | 1 | 0 | 0 | 0 | 0 | 10 | 6 | 16 | 15 | 0 | 1 | 0 | 0 | 0 | 0 | 10 | 6 | 16 | ||||||||||||||||||||||||||||||||||
1805430 | 1805430 | CO | school | 806480 | 990 | Widefield 3 | 80648001885 | 5033 | James Madison Charter Academy School | Regular School | Yes | Elementary | KG | 08 | 2020 | grade_2 | 9 | 2 | 2 | 0 | 0 | 0 | 4 | 10 | 7 | 17 | 9 | 2 | 2 | 0 | 0 | 0 | 4 | 10 | 7 | 17 | ||||||||||||||||||||||||||||||||||
1805728 | 1805728 | CO | school | 803060 | 1010 | Colorado Springs 11 | 80306001318 | 3470 | Globe Charter School | Regular School | Yes | Elementary | KG | 06 | 2020 | grade_2 | 14 | 2 | 5 | 0 | 1 | 0 | 4 | 10 | 16 | 26 | 14 | 2 | 5 | 0 | 1 | 0 | 4 | 10 | 16 | 26 | ||||||||||||||||||||||||||||||||||
1806786 | 1806786 | CO | school | 802790 | 1140 | Canon City RE-1 | 80279001538 | 6752 | Mount View Core Knowledge Charter School | Regular School | Yes | Elementary | PK | 08 | 2020 | grade_2 | 21 | 0 | 5 | 0 | 1 | 0 | 1 | 10 | 18 | 28 | 21 | 0 | 5 | 0 | 1 | 0 | 1 | 10 | 18 | 28 | ||||||||||||||||||||||||||||||||||
1808817 | 1808817 | CO | school | 803990 | 1550 | Poudre R-1 | 80399006613 | 3242 | Fort Collins Montessori School | Regular School | Yes | Elementary | PK | 06 | 2020 | grade_2 | 15 | 0 | 2 | 0 | 0 | 0 | 1 | 10 | 8 | 18 | 15 | 0 | 2 | 0 | 0 | 0 | 1 | 10 | 8 | 18 | ||||||||||||||||||||||||||||||||||
1808968 | 1808968 | CO | school | 803990 | 1550 | Poudre R-1 | 80399006334 | 7104 | Polaris Expeditionary Learning School | Alternative School | No | Other | KG | 12 | 2020 | grade_2 | 15 | 1 | 1 | 0 | 0 | 0 | 1 | 10 | 8 | 18 | 15 | 1 | 1 | 0 | 0 | 0 | 1 | 10 | 8 | 18 | ||||||||||||||||||||||||||||||||||
1809391 | 1809391 | CO | school | 804650 | 1600 | Hoehne Reorganized 3 | 80465000680 | 4048 | Hoehne Schools | Regular School | No | Other | PK | 12 | 2020 | grade_2 | 12 | 0 | 10 | 0 | 1 | 0 | 1 | 10 | 14 | 24 | 12 | 0 | 10 | 0 | 1 | 0 | 1 | 10 | 14 | 24 | ||||||||||||||||||||||||||||||||||
1810013 | 1810013 | CO | school | 803090 | 2035 | Montezuma-Cortez RE-1 | 80309006622 | 2036 | Children's Kiva Montessori School | Regular School | Yes | Elementary | KG | 08 | 2020 | grade_2 | 10 | 0 | 0 | 3 | 0 | 0 | 1 | 10 | 4 | 14 | 10 | 0 | 0 | 3 | 0 | 0 | 1 | 10 | 4 | 14 | ||||||||||||||||||||||||||||||||||
1810030 | 1810030 | CO | school | 803090 | 2035 | Montezuma-Cortez RE-1 | 80309000837 | 5090 | Lewis-Arriola Elementary School | Regular School | No | Elementary | KG | 05 | 2020 | grade_2 | 20 | 0 | 2 | 0 | 0 | 0 | 0 | 10 | 12 | 22 | 20 | 0 | 2 | 0 | 0 | 0 | 0 | 10 | 12 | 22 | ||||||||||||||||||||||||||||||||||
1810574 | 1810574 | CO | school | 805220 | 2660 | Lamar Re-2 | 80522000860 | 200 | Alta Vista Charter School | Regular School | Yes | Elementary | KG | 06 | 2020 | grade_2 | 12 | 0 | 8 | 0 | 0 | 0 | 0 | 10 | 10 | 20 | 12 | 0 | 8 | 0 | 0 | 0 | 0 | 10 | 10 | 20 | ||||||||||||||||||||||||||||||||||
1812487 | 1812487 | CO | school | 800020 | 8001 | Charter School Institute | 80002006320 | 7278 | Ricardo Flores Magon Academy | Regular School | Yes | Elementary | KG | 08 | 2020 | grade_2 | 0 | 1 | 21 | 0 | 0 | 0 | 0 | 10 | 12 | 22 | 0 | 1 | 21 | 0 | 0 | 0 | 0 | 10 | 12 | 22 | ||||||||||||||||||||||||||||||||||
1800289 | 1800289 | CO | school | 802070 | 100 | Alamosa RE-11J | 80207006459 | 115 | Alamosa Elementary School | Regular School | No | Elementary | KG | 05 | 2020 | grade_2 | 44 | 2 | 118 | 2 | 0 | 0 | 3 | 103 | 66 | 169 | 44 | 2 | 118 | 2 | 0 | 0 | 3 | 103 | 66 | 169 | ||||||||||||||||||||||||||||||||||
1801791 | 1801791 | CO | school | 805370 | 470 | St Vrain Valley RE1J | 80537001887 | 1284 | Carbon Valley Academy | Regular School | Yes | Elementary | PK | 08 | 2020 | grade_2 | 15 | 0 | 8 | 0 | 0 | 0 | 0 | 11 | 12 | 23 | 15 | 0 | 8 | 0 | 0 | 0 | 0 | 11 | 12 | 23 | ||||||||||||||||||||||||||||||||||
1802563 | 1802563 | CO | school | 800001 | 520 | Cheyenne County Re-5 | 80000100214 | 1608 | Cheyenne Wells Elementary School | Regular School | No | Elementary | PK | 06 | 2020 | grade_2 | 20 | 0 | 2 | 0 | 0 | 0 | 0 | 11 | 11 | 22 | 20 | 0 | 2 | 0 | 0 | 0 | 0 | 11 | 11 | 22 | ||||||||||||||||||||||||||||||||||
1802696 | 1802696 | CO | school | 804140 | 740 | Sierra Grande R-30 | 80414000572 | 7880 | Sierra Grande K-12 School | Regular School | No | Other | PK | 12 | 2020 | grade_2 | 2 | 0 | 15 | 0 | 0 | 0 | 0 | 11 | 6 | 17 | 2 | 0 | 15 | 0 | 0 | 0 | 0 | 11 | 6 | 17 | ||||||||||||||||||||||||||||||||||
1803900 | 1803900 | CO | school | 803360 | 880 | Denver County 1 | 80336006641 | 7243 | Reach Charter School | Regular School | Yes | Elementary | PK | 05 | 2020 | grade_2 | 8 | 4 | 6 | 0 | 0 | 0 | 0 | 11 | 7 | 18 | 8 | 4 | 6 | 0 | 0 | 0 | 0 | 11 | 7 | 18 | ||||||||||||||||||||||||||||||||||
1805300 | 1805300 | CO | school | 804530 | 980 | Harrison 2 | 80453006663 | 5763 | Mountain Vista Homeschool Academy | Regular School | No | Other | KG | 12 | 2020 | grade_2 | 19 | 0 | 2 | 0 | 0 | 0 | 0 | 11 | 10 | 21 | 19 | 0 | 2 | 0 | 0 | 0 | 0 | 11 | 10 | 21 | ||||||||||||||||||||||||||||||||||
1806477 | 1806477 | CO | school | 803870 | 1110 | District 49 | 80387006725 | 101 | ALLIES | Alternative School | No | Elementary | 02 | 05 | 2020 | grade_2 | 14 | 0 | 6 | 0 | 0 | 0 | 4 | 11 | 13 | 24 | 14 | 0 | 6 | 0 | 0 | 0 | 4 | 11 | 13 | 24 | ||||||||||||||||||||||||||||||||||
1806779 | 1806779 | CO | school | 802790 | 1140 | Canon City RE-1 | 80279000175 | 5704 | McKinley Elementary School | Regular School | No | Elementary | KG | 05 | 2020 | grade_2 | 20 | 0 | 2 | 0 | 0 | 0 | 1 | 11 | 12 | 23 | 20 | 0 | 2 | 0 | 0 | 0 | 1 | 11 | 12 | 23 | ||||||||||||||||||||||||||||||||||
1807399 | 1807399 | CO | school | 804800 | 1420 | Jefferson County R-1 | 80480001766 | 1880 | Compass Montessori - Golden Charter School | Regular School | Yes | Other | PK | 12 | 2020 | grade_2 | 18 | 0 | 1 | 0 | 0 | 0 | 1 | 11 | 9 | 20 | 18 | 0 | 1 | 0 | 0 | 0 | 1 | 11 | 9 | 20 | ||||||||||||||||||||||||||||||||||
1809202 | 1809202 | CO | school | 805400 | 1560 | Thompson R2-J | 80540006558 | 5121 | LEAP School | Regular School | No | Other | KG | 12 | 2020 | grade_2 | 14 | 0 | 2 | 0 | 0 | 0 | 1 | 11 | 6 | 17 | 14 | 0 | 2 | 0 | 0 | 0 | 1 | 11 | 6 | 17 | ||||||||||||||||||||||||||||||||||
1809464 | 1809464 | CO | school | 804740 | 1780 | Genoa-Hugo C113 | 80474000686 | 4162 | Genoa-Hugo School | Regular School | No | Other | PK | 12 | 2020 | grade_2 | 15 | 0 | 0 | 0 | 0 | 0 | 0 | 11 | 4 | 15 | 15 | 0 | 0 | 0 | 0 | 0 | 0 | 11 | 4 | 15 | ||||||||||||||||||||||||||||||||||
1809558 | 1809558 | CO | school | 805640 | 1860 | Buffalo RE-4J | 80564000969 | 5802 | Merino Elementary School | Regular School | No | Elementary | KG | 06 | 2020 | grade_2 | 23 | 0 | 1 | 1 | 0 | 0 | 0 | 11 | 14 | 25 | 23 | 0 | 1 | 1 | 0 | 0 | 0 | 11 | 14 | 25 | ||||||||||||||||||||||||||||||||||
1810558 | 1810558 | CO | school | 804290 | 2650 | Granada RE-1 | 80429000592 | 3542 | Granada Elementary School | Regular School | No | Elementary | PK | 06 | 2020 | grade_2 | 7 | 0 | 10 | 0 | 1 | 0 | 0 | 11 | 7 | 18 | 7 | 0 | 10 | 0 | 1 | 0 | 0 | 11 | 7 | 18 | ||||||||||||||||||||||||||||||||||
1810818 | 1810818 | CO | school | 806120 | 2690 | Pueblo City 60 | 80612006711 | 6775 | Pueblo School for Arts & Sciences at Fulton Heights | Regular School | Yes | Elementary | KG | 07 | 2020 | grade_2 | 11 | 0 | 15 | 0 | 0 | 0 | 0 | 11 | 15 | 26 | 11 | 0 | 15 | 0 | 0 | 0 | 0 | 11 | 15 | 26 | ||||||||||||||||||||||||||||||||||
1811338 | 1811338 | CO | school | 804860 | 2862 | Julesburg Re-1 | 80486000811 | 4488 | Julesburg Elementary School | Regular School | No | Elementary | PK | 06 | 2020 | grade_2 | 12 | 0 | 6 | 0 | 0 | 0 | 0 | 11 | 7 | 18 | 12 | 0 | 6 | 0 | 0 | 0 | 0 | 11 | 7 | 18 | ||||||||||||||||||||||||||||||||||
1811622 | 1811622 | CO | school | 804920 | 3090 | Weld County School District RE-3J | 80492001760 | 1299 | Cardinal Community Academy Charter School | Regular School | Yes | Elementary | KG | 08 | 2020 | grade_2 | 21 | 0 | 0 | 0 | 0 | 0 | 0 | 11 | 10 | 21 | 21 | 0 | 0 | 0 | 0 | 0 | 0 | 11 | 10 | 21 | ||||||||||||||||||||||||||||||||||
1801586 | 1801586 | CO | school | 807110 | 230 | Walsh RE-1 | 80711001215 | 9222 | Walsh Elementary School | Regular School | No | Elementary | PK | 06 | 2020 | grade_2 | 15 | 0 | 4 | 0 | 0 | 0 | 0 | 12 | 7 | 19 | 15 | 0 | 4 | 0 | 0 | 0 | 0 | 12 | 7 | 19 | ||||||||||||||||||||||||||||||||||
1802645 | 1802645 | CO | school | 806390 | 560 | Sanford 6J | 80639001113 | 7612 | Sanford Elementary School | Regular School | No | Elementary | PK | 06 | 2020 | grade_2 | 25 | 0 | 6 | 0 | 0 | 0 | 0 | 12 | 19 | 31 | 25 | 0 | 6 | 0 | 0 | 0 | 0 | 12 | 19 | 31 | ||||||||||||||||||||||||||||||||||
1802723 | 1802723 | CO | school | 807200 | 860 | Custer County School District C-1 | 80720001226 | 2088 | Custer County Elementary School | Regular School | No | Elementary | PK | 05 | 2020 | grade_2 | 32 | 0 | 1 | 0 | 0 | 0 | 0 | 12 | 21 | 33 | 32 | 0 | 1 | 0 | 0 | 0 | 0 | 12 | 21 | 33 | ||||||||||||||||||||||||||||||||||
1802801 | 1802801 | CO | school | 803330 | 870 | Delta County 50(J) | 80333000299 | 4124 | Hotchkiss Elementary School | Regular School | No | Elementary | PK | 08 | 2020 | grade_2 | 21 | 0 | 3 | 0 | 0 | 0 | 1 | 12 | 13 | 25 | 21 | 0 | 3 | 0 | 0 | 0 | 1 | 12 | 13 | 25 | ||||||||||||||||||||||||||||||||||
1803663 | 1803663 | CO | school | 803360 | 880 | Denver County 1 | 80336006445 | 5608 | Mathematics and Science Leadership Academy | Regular School | No | Elementary | KG | 05 | 2020 | grade_2 | 0 | 0 | 21 | 0 | 1 | 0 | 0 | 12 | 10 | 22 | 0 | 0 | 21 | 0 | 1 | 0 | 0 | 12 | 10 | 22 | ||||||||||||||||||||||||||||||||||
1803808 | 1803808 | CO | school | 803360 | 880 | Denver County 1 | 80336001636 | 6479 | Odyssey School of Denver | Regular School | Yes | Elementary | KG | 08 | 2020 | grade_2 | 14 | 1 | 5 | 0 | 0 | 0 | 6 | 12 | 14 | 26 | 14 | 1 | 5 | 0 | 0 | 0 | 6 | 12 | 14 | 26 | ||||||||||||||||||||||||||||||||||
1804627 | 1804627 | CO | school | 803450 | 900 | Douglas County Re 1 | 80345000441 | 4980 | Larkspur Elementary School | Regular School | No | Elementary | KG | 06 | 2020 | grade_2 | 24 | 0 | 4 | 0 | 0 | 0 | 0 | 12 | 16 | 28 | 24 | 0 | 4 | 0 | 0 | 0 | 0 | 12 | 16 | 28 | ||||||||||||||||||||||||||||||||||
1805169 | 1805169 | CO | school | 806600 | 940 | Big Sandy 100J | 80660001138 | 7914 | Simla Elementary School | Regular School | No | Elementary | PK | 05 | 2020 | grade_2 | 20 | 0 | 3 | 0 | 0 | 0 | 3 | 12 | 14 | 26 | 20 | 0 | 3 | 0 | 0 | 0 | 3 | 12 | 14 | 26 | ||||||||||||||||||||||||||||||||||
1806486 | 1806486 | CO | school | 803870 | 1110 | District 49 | 80387006778 | 431 | Falcon Homeschool Program | Regular School | No | Other | KG | 12 | 2020 | grade_2 | 20 | 0 | 1 | 0 | 0 | 0 | 4 | 12 | 13 | 25 | 20 | 0 | 1 | 0 | 0 | 0 | 4 | 12 | 13 | 25 | ||||||||||||||||||||||||||||||||||
1809732 | 1809732 | CO | school | 804350 | 2000 | Mesa County Valley 51 | 80435001552 | 2724 | New Emerson School at Columbus | Regular School | No | Elementary | KG | 05 | 2020 | grade_2 | 22 | 0 | 1 | 0 | 0 | 0 | 1 | 12 | 12 | 24 | 22 | 0 | 1 | 0 | 0 | 0 | 1 | 12 | 12 | 24 | ||||||||||||||||||||||||||||||||||
1810277 | 1810277 | CO | school | 807140 | 2505 | Weldon Valley RE-20(J) | 80714001217 | 9352 | Weldon Valley Elementary School | Regular School | No | Elementary | PK | 06 | 2020 | grade_2 | 15 | 0 | 2 | 0 | 0 | 0 | 0 | 12 | 5 | 17 | 15 | 0 | 2 | 0 | 0 | 0 | 0 | 12 | 5 | 17 | ||||||||||||||||||||||||||||||||||
1810925 | 1810925 | CO | school | 806150 | 2700 | Pueblo County 70 | 80615006763 | 6817 | PSAS Homeschool Program | Regular School | No | Elementary | KG | 08 | 2020 | grade_2 | 14 | 0 | 3 | 0 | 0 | 0 | 0 | 12 | 5 | 17 | 14 | 0 | 3 | 0 | 0 | 0 | 0 | 12 | 5 | 17 | ||||||||||||||||||||||||||||||||||
1811615 | 1811615 | CO | school | 803600 | 3085 | Eaton RE-2 | 80360000477 | 3286 | Galeton Elementary School | Regular School | No | Elementary | KG | 05 | 2020 | grade_2 | 15 | 0 | 8 | 0 | 0 | 0 | 0 | 12 | 11 | 23 | 15 | 0 | 8 | 0 | 0 | 0 | 0 | 12 | 11 | 23 | ||||||||||||||||||||||||||||||||||
1812583 | 1812583 | CO | school | 800004 | 9130 | Expeditionary BOCES | 80000400709 | 2840 | Rocky Mountain School of Expeditionary Learning | Regular School | No | Other | KG | 12 | 2020 | grade_2 | 20 | 0 | 4 | 0 | 1 | 0 | 1 | 12 | 14 | 26 | 20 | 0 | 4 | 0 | 1 | 0 | 1 | 12 | 14 | 26 | ||||||||||||||||||||||||||||||||||
1799751 | 1799751 | CO | school | 806900 | 20 | Adams 12 Five Star Schools | 80690006375 | 8211 | The Studio School | Regular School | No | Elementary | KG | 05 | 2020 | grade_2 | 22 | 1 | 20 | 0 | 1 | 0 | 3 | 13 | 34 | 47 | 22 | 1 | 20 | 0 | 1 | 0 | 3 | 13 | 34 | 47 | ||||||||||||||||||||||||||||||||||
1800309 | 1800309 | CO | school | 806420 | 110 | Sangre De Cristo Re-22J | 80642001115 | 7626 | Sangre de Cristo Elementary School | Regular School | No | Elementary | PK | 05 | 2020 | grade_2 | 15 | 0 | 5 | 0 | 0 | 0 | 0 | 13 | 7 | 20 | 15 | 0 | 5 | 0 | 0 | 0 | 0 | 13 | 7 | 20 | ||||||||||||||||||||||||||||||||||
1805216 | 1805216 | CO | school | 802730 | 970 | Calhan RJ-1 | 80273000167 | 1210 | Calhan Elementary School | Regular School | No | Elementary | PK | 05 | 2020 | grade_2 | 17 | 4 | 4 | 0 | 0 | 0 | 0 | 13 | 12 | 25 | 17 | 4 | 4 | 0 | 0 | 0 | 0 | 13 | 12 | 25 | ||||||||||||||||||||||||||||||||||
1805373 | 1805373 | CO | school | 804530 | 980 | Harrison 2 | 80453000671 | 8337 | Stratmoor Hills Elementary School | Regular School | No | Elementary | PK | 05 | 2020 | grade_2 | 12 | 3 | 10 | 2 | 0 | 0 | 2 | 13 | 16 | 29 | 12 | 3 | 10 | 2 | 0 | 0 | 2 | 13 | 16 | 29 | ||||||||||||||||||||||||||||||||||
1805619 | 1805619 | CO | school | 803060 | 1010 | Colorado Springs 11 | 80306000224 | 1032 | Bristol Elementary School | Regular School | No | Elementary | KG | 05 | 2020 | grade_2 | 23 | 4 | 10 | 1 | 0 | 0 | 5 | 13 | 30 | 43 | 23 | 4 | 10 | 1 | 0 | 0 | 5 | 13 | 30 | 43 | ||||||||||||||||||||||||||||||||||
1807945 | 1807945 | CO | school | 804800 | 1420 | Jefferson County R-1 | 80480006256 | 6539 | Jefferson County Open Elementary School | Regular School | No | Elementary | PK | 06 | 2020 | grade_2 | 22 | 0 | 5 | 0 | 0 | 0 | 2 | 13 | 16 | 29 | 22 | 0 | 5 | 0 | 0 | 0 | 2 | 13 | 16 | 29 | ||||||||||||||||||||||||||||||||||
1808004 | 1808004 | CO | school | 804800 | 1420 | Jefferson County R-1 | 80480000773 | 6848 | Peak Expeditionary - Pennington | Regular School | No | Elementary | PK | 05 | 2020 | grade_2 | 9 | 0 | 8 | 1 | 0 | 1 | 2 | 13 | 8 | 21 | 9 | 0 | 8 | 1 | 0 | 1 | 2 | 13 | 8 | 21 | ||||||||||||||||||||||||||||||||||
1808580 | 1808580 | CO | school | 803480 | 1520 | Durango 9-R | 80348006614 | 2097 | District 9-R Shared School | Regular School | No | Other | KG | 12 | 2020 | grade_2 | 20 | 0 | 2 | 0 | 0 | 0 | 0 | 13 | 9 | 22 | 20 | 0 | 2 | 0 | 0 | 0 | 0 | 13 | 9 | 22 | ||||||||||||||||||||||||||||||||||
1810389 | 1810389 | CO | school | 806840 | 2570 | Swink 33 | 80684001168 | 8452 | Swink Elementary School | Regular School | No | Elementary | KG | 06 | 2020 | grade_2 | 20 | 0 | 9 | 0 | 0 | 0 | 0 | 13 | 16 | 29 | 20 | 0 | 9 | 0 | 0 | 0 | 0 | 13 | 16 | 29 | ||||||||||||||||||||||||||||||||||
1800186 | 1800186 | CO | school | 807230 | 70 | Westminster Public Schools | 80723006567 | 4334 | Colorado STEM Academy | Regular School | No | Elementary | PK | 08 | 2020 | grade_2 | 10 | 0 | 15 | 1 | 4 | 0 | 4 | 14 | 20 | 34 | 10 | 0 | 15 | 1 | 4 | 0 | 4 | 14 | 20 | 34 | ||||||||||||||||||||||||||||||||||
1802840 | 1802840 | CO | school | 803330 | 870 | Delta County 50(J) | 80333001337 | 6700 | Paonia Elementary School | Regular School | No | Elementary | PK | 06 | 2020 | grade_2 | 20 | 0 | 4 | 0 | 0 | 0 | 2 | 14 | 12 | 26 | 20 | 0 | 4 | 0 | 0 | 0 | 2 | 14 | 12 | 26 | ||||||||||||||||||||||||||||||||||
1802955 | 1802955 | CO | school | 803360 | 880 | Denver County 1 | 80336000320 | 1106 | Bryant Webster Dual Language ECE-8 School | Regular School | No | Elementary | PK | 08 | 2020 | grade_2 | 3 | 0 | 21 | 1 | 0 | 0 | 2 | 14 | 13 | 27 | 3 | 0 | 21 | 1 | 0 | 0 | 2 | 14 | 13 | 27 | ||||||||||||||||||||||||||||||||||
1803376 | 1803376 | CO | school | 803360 | 880 | Denver County 1 | 80336001738 | 3605 | Grant Ranch ECE-8 School | Regular School | No | Elementary | PK | 08 | 2020 | grade_2 | 10 | 0 | 17 | 0 | 0 | 0 | 3 | 14 | 16 | 30 | 10 | 0 | 17 | 0 | 0 | 0 | 3 | 14 | 16 | 30 | ||||||||||||||||||||||||||||||||||
1805063 | 1805063 | CO | school | 803540 | 910 | Eagle County RE 50 | 80354006366 | 4838 | June Creek Elementary School | Regular School | No | Elementary | PK | 05 | 2020 | grade_2 | 3 | 0 | 23 | 0 | 0 | 0 | 0 | 14 | 12 | 26 | 3 | 0 | 23 | 0 | 0 | 0 | 0 | 14 | 12 | 26 | ||||||||||||||||||||||||||||||||||
1805940 | 1805940 | CO | school | 803060 | 1010 | Colorado Springs 11 | 80306001642 | 8902 | Trailblazer Elementary School | Regular School | No | Elementary | PK | 05 | 2020 | grade_2 | 25 | 4 | 6 | 0 | 0 | 0 | 1 | 14 | 22 | 36 | 25 | 4 | 6 | 0 | 0 | 0 | 1 | 14 | 22 | 36 | ||||||||||||||||||||||||||||||||||
1807232 | 1807232 | CO | school | 804800 | 1420 | Jefferson County R-1 | 80480000692 | 148 | Allendale Elementary School | Regular School | No | Elementary | PK | 05 | 2020 | grade_2 | 15 | 0 | 9 | 0 | 0 | 0 | 0 | 14 | 10 | 24 | 15 | 0 | 9 | 0 | 0 | 0 | 0 | 14 | 10 | 24 | ||||||||||||||||||||||||||||||||||
1807322 | 1807322 | CO | school | 804800 | 1420 | Jefferson County R-1 | 80480000702 | 1238 | Campbell Elementary School | Regular School | No | Elementary | KG | 05 | 2020 | grade_2 | 30 | 0 | 2 | 1 | 1 | 0 | 0 | 14 | 20 | 34 | 30 | 0 | 2 | 1 | 1 | 0 | 0 | 14 | 20 | 34 | ||||||||||||||||||||||||||||||||||
1807579 | 1807579 | CO | school | 804800 | 1420 | Jefferson County R-1 | 80480000731 | 3450 | Glennon Heights Elementary School | Regular School | No | Elementary | KG | 05 | 2020 | grade_2 | 19 | 1 | 10 | 0 | 1 | 0 | 0 | 14 | 17 | 31 | 19 | 1 | 10 | 0 | 1 | 0 | 0 | 14 | 17 | 31 | ||||||||||||||||||||||||||||||||||
1807775 | 1807775 | CO | school | 804800 | 1420 | Jefferson County R-1 | 80480000751 | 5222 | Little Elementary School | Regular School | No | Elementary | KG | 05 | 2020 | grade_2 | 16 | 2 | 16 | 0 | 1 | 0 | 2 | 14 | 23 | 37 | 16 | 2 | 16 | 0 | 1 | 0 | 2 | 14 | 23 | 37 | ||||||||||||||||||||||||||||||||||
1808053 | 1808053 | CO | school | 804800 | 1420 | Jefferson County R-1 | 80480001812 | 7462 | Rocky Mountain Academy of Evergreen | Regular School | Yes | Elementary | KG | 08 | 2020 | grade_2 | 21 | 0 | 1 | 1 | 0 | 0 | 2 | 14 | 11 | 25 | 21 | 0 | 1 | 1 | 0 | 0 | 2 | 14 | 11 | 25 | ||||||||||||||||||||||||||||||||||
1808090 | 1808090 | CO | school | 804800 | 1420 | Jefferson County R-1 | 80480001036 | 7701 | Collegiate Academy of Colorado | Regular School | Yes | Other | KG | 12 | 2020 | grade_2 | 24 | 0 | 2 | 0 | 0 | 0 | 1 | 14 | 13 | 27 | 24 | 0 | 2 | 0 | 0 | 0 | 1 | 14 | 13 | 27 | ||||||||||||||||||||||||||||||||||
1808241 | 1808241 | CO | school | 804800 | 1420 | Jefferson County R-1 | 80480006466 | 8793 | Two Roads Charter School | Regular School | Yes | Other | PK | 12 | 2020 | grade_2 | 27 | 0 | 6 | 0 | 0 | 0 | 0 | 14 | 19 | 33 | 27 | 0 | 6 | 0 | 0 | 0 | 0 | 14 | 19 | 33 | ||||||||||||||||||||||||||||||||||
1808569 | 1808569 | CO | school | 803480 | 1520 | Durango 9-R | 80348006696 | 1526 | Colorado Connections Academy @ Durango | Regular School | No | Other | KG | 12 | 2020 | grade_2 | 22 | 1 | 8 | 0 | 1 | 0 | 1 | 14 | 19 | 33 | 22 | 1 | 8 | 0 | 1 | 0 | 1 | 14 | 19 | 33 | ||||||||||||||||||||||||||||||||||
1808616 | 1808616 | CO | school | 803480 | 1520 | Durango 9-R | 80348006712 | 4384 | The Juniper School | Regular School | Yes | Elementary | KG | 05 | 2020 | grade_2 | 19 | 0 | 1 | 0 | 0 | 0 | 1 | 14 | 7 | 21 | 19 | 0 | 1 | 0 | 0 | 0 | 1 | 14 | 7 | 21 | ||||||||||||||||||||||||||||||||||
1808927 | 1808927 | CO | school | 803990 | 1550 | Poudre R-1 | 80399006573 | 5917 | Mountain Sage Community School | Regular School | Yes | Elementary | KG | 08 | 2020 | grade_2 | 29 | 0 | 0 | 0 | 0 | 0 | 1 | 14 | 16 | 30 | 29 | 0 | 0 | 0 | 0 | 0 | 1 | 14 | 16 | 30 | ||||||||||||||||||||||||||||||||||
1810296 | 1810296 | CO | school | 807290 | 2515 | Wiggins RE-50(J) | 80729001257 | 9576 | Wiggins Elementary School | Regular School | No | Elementary | PK | 06 | 2020 | grade_2 | 20 | 1 | 14 | 0 | 0 | 0 | 1 | 14 | 22 | 36 | 20 | 1 | 14 | 0 | 0 | 0 | 1 | 14 | 22 | 36 | ||||||||||||||||||||||||||||||||||
1810480 | 1810480 | CO | school | 803840 | 2610 | Park County RE-2 | 80384000502 | 8114 | Edith Teter Elementary School | Regular School | No | Elementary | PK | 05 | 2020 | grade_2 | 29 | 0 | 6 | 0 | 1 | 0 | 1 | 14 | 23 | 37 | 29 | 0 | 6 | 0 | 1 | 0 | 1 | 14 | 23 | 37 | ||||||||||||||||||||||||||||||||||
1811481 | 1811481 | CO | school | 802040 | 3030 | Akron R-1 | 80204000024 | 86 | Akron Elementary School | Regular School | No | Elementary | PK | 08 | 2020 | grade_2 | 24 | 0 | 5 | 0 | 0 | 0 | 2 | 14 | 17 | 31 | 24 | 0 | 5 | 0 | 0 | 0 | 2 | 14 | 17 | 31 | ||||||||||||||||||||||||||||||||||
1812272 | 1812272 | CO | school | 800020 | 8001 | Charter School Institute | 80002006784 | 1371 | Coperni 3 | Regular School | Yes | Elementary | KG | 06 | 2020 | grade_2 | 9 | 6 | 10 | 0 | 0 | 0 | 0 | 14 | 11 | 25 | 9 | 6 | 10 | 0 | 0 | 0 | 0 | 14 | 11 | 25 | ||||||||||||||||||||||||||||||||||
1804295 | 1804295 | CO | school | 803450 | 900 | Douglas County Re 1 | 80345001896 | 215 | American Academy | Regular School | Yes | Elementary | PK | 08 | 2020 | grade_2 | 207 | 3 | 13 | 2 | 53 | 0 | 23 | 142 | 159 | 301 | 207 | 3 | 13 | 2 | 53 | 0 | 23 | 142 | 159 | 301 | ||||||||||||||||||||||||||||||||||
1799395 | 1799395 | CO | school | 805550 | 10 | Mapleton 1 | 80555001932 | 507 | Adventure Elementary | Regular School | No | Elementary | PK | 06 | 2020 | grade_2 | 6 | 1 | 33 | 0 | 0 | 0 | 1 | 15 | 26 | 41 | 6 | 1 | 33 | 0 | 0 | 0 | 1 | 15 | 26 | 41 | ||||||||||||||||||||||||||||||||||
1803059 | 1803059 | CO | school | 803360 | 880 | Denver County 1 | 80336000330 | 1846 | Columbine Elementary School | Regular School | No | Elementary | PK | 05 | 2020 | grade_2 | 7 | 11 | 8 | 1 | 0 | 0 | 2 | 15 | 14 | 29 | 7 | 11 | 8 | 1 | 0 | 0 | 2 | 15 | 14 | 29 | ||||||||||||||||||||||||||||||||||
1804395 | 1804395 | CO | school | 803450 | 900 | Douglas County Re 1 | 80345006494 | 1555 | Cloverleaf Home Education | Alternative School | No | Other | KG | 12 | 2020 | grade_2 | 26 | 0 | 2 | 0 | 1 | 0 | 1 | 15 | 15 | 30 | 26 | 0 | 2 | 0 | 1 | 0 | 1 | 15 | 15 | 30 | ||||||||||||||||||||||||||||||||||
1805328 | 1805328 | CO | school | 804530 | 980 | Harrison 2 | 80453001369 | 6460 | Oak Creek Elementary School | Regular School | No | Elementary | PK | 05 | 2020 | grade_2 | 12 | 0 | 14 | 0 | 1 | 0 | 1 | 15 | 13 | 28 | 12 | 0 | 14 | 0 | 1 | 0 | 1 | 15 | 13 | 28 | ||||||||||||||||||||||||||||||||||
1805626 | 1805626 | CO | school | 803060 | 1010 | Colorado Springs 11 | 80306000225 | 1126 | Buena Vista Elementary School | Regular School | No | Elementary | PK | 08 | 2020 | grade_2 | 23 | 0 | 10 | 0 | 0 | 0 | 0 | 15 | 18 | 33 | 23 | 0 | 10 | 0 | 0 | 0 | 0 | 15 | 18 | 33 | ||||||||||||||||||||||||||||||||||
1805802 | 1805802 | CO | school | 803060 | 1010 | Colorado Springs 11 | 80306000251 | 5404 | Madison Elementary School | Regular School | No | Elementary | PK | 05 | 2020 | grade_2 | 20 | 2 | 19 | 0 | 1 | 0 | 2 | 15 | 29 | 44 | 20 | 2 | 19 | 0 | 1 | 0 | 2 | 15 | 29 | 44 | ||||||||||||||||||||||||||||||||||
1805874 | 1805874 | CO | school | 803060 | 1010 | Colorado Springs 11 | 80306000260 | 7228 | Queen Palmer Elementary School | Regular School | No | Elementary | KG | 05 | 2020 | grade_2 | 13 | 4 | 9 | 1 | 0 | 1 | 2 | 15 | 15 | 30 | 13 | 4 | 9 | 1 | 0 | 1 | 2 | 15 | 15 | 30 | ||||||||||||||||||||||||||||||||||
1805952 | 1805952 | CO | school | 803060 | 1010 | Colorado Springs 11 | 80306006416 | 9445 | West Elementary School | Regular School | No | Elementary | PK | 05 | 2020 | grade_2 | 17 | 1 | 9 | 0 | 0 | 1 | 4 | 15 | 17 | 32 | 17 | 1 | 9 | 0 | 0 | 1 | 4 | 15 | 17 | 32 | ||||||||||||||||||||||||||||||||||
1806367 | 1806367 | CO | school | 806060 | 1060 | Peyton 23 Jt | 80606001024 | 6898 | Peyton Elementary School | Regular School | No | Elementary | PK | 06 | 2020 | grade_2 | 22 | 0 | 5 | 0 | 0 | 0 | 1 | 15 | 13 | 28 | 22 | 0 | 5 | 0 | 0 | 0 | 1 | 15 | 13 | 28 | ||||||||||||||||||||||||||||||||||
1806829 | 1806829 | CO | school | 803960 | 1150 | Fremont RE-2 | 80396000516 | 6858 | Penrose Elementary School | Regular School | No | Elementary | PK | 06 | 2020 | grade_2 | 32 | 0 | 1 | 0 | 0 | 0 | 0 | 15 | 18 | 33 | 32 | 0 | 1 | 0 | 0 | 0 | 0 | 15 | 18 | 33 | ||||||||||||||||||||||||||||||||||
1807279 | 1807279 | CO | school | 804800 | 1420 | Jefferson County R-1 | 80480000699 | 724 | Belmar School of Integrated Arts | Regular School | No | Elementary | KG | 05 | 2020 | grade_2 | 26 | 1 | 9 | 2 | 2 | 0 | 2 | 15 | 27 | 42 | 26 | 1 | 9 | 2 | 2 | 0 | 2 | 15 | 27 | 42 | ||||||||||||||||||||||||||||||||||
1807378 | 1807378 | CO | school | 804800 | 1420 | Jefferson County R-1 | 80480001649 | 1869 | Compass Montessori - Wheat Ridge Charter School | Regular School | Yes | Elementary | PK | 06 | 2020 | grade_2 | 31 | 0 | 1 | 0 | 0 | 0 | 0 | 15 | 17 | 32 | 31 | 0 | 1 | 0 | 0 | 0 | 0 | 15 | 17 | 32 | ||||||||||||||||||||||||||||||||||
1807526 | 1807526 | CO | school | 804800 | 1420 | Jefferson County R-1 | 80480000722 | 2946 | Fitzmorris Elementary School | Regular School | No | Elementary | PK | 05 | 2020 | grade_2 | 16 | 2 | 6 | 0 | 1 | 0 | 0 | 15 | 10 | 25 | 16 | 2 | 6 | 0 | 1 | 0 | 0 | 15 | 10 | 25 | ||||||||||||||||||||||||||||||||||
1807618 | 1807618 | CO | school | 804800 | 1420 | Jefferson County R-1 | 80480006723 | 3691 | Great Work Montessori | Regular School | Yes | Elementary | PK | 05 | 2020 | grade_2 | 19 | 0 | 7 | 0 | 1 | 0 | 1 | 15 | 13 | 28 | 19 | 0 | 7 | 0 | 1 | 0 | 1 | 15 | 13 | 28 |
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]);