enrollments
Data source: Big Local News · About: Big Local
1,109 rows where grade = "grade_2", state = "CO" and year = 2021 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1749348 | 1749348 | CO | school | 803840 | 2610 | Park County RE-2 | 80384000502 | 8114 | Edith Teter Elementary School | Regular School | No | Elementary | PK | 05 | 2021 | grade_2 | 23 | 0 | 5 | 0 | 0 | 0 | 1 | 14 | 15 | 29 | 23 | 0 | 5 | 0 | 0 | 0 | 1 | 14 | 15 | 29 | ||||||||||||||||||||||||||||||||||
1749688 | 1749688 | CO | school | 806120 | 2690 | Pueblo City 60 | 80612006711 | 6775 | Pueblo School for Arts & Sciences at Fulton Heights | Regular School | Yes | Elementary | KG | 08 | 2021 | grade_2 | 12 | 0 | 18 | 0 | 0 | 0 | 0 | 14 | 16 | 30 | 12 | 0 | 18 | 0 | 0 | 0 | 0 | 14 | 16 | 30 | ||||||||||||||||||||||||||||||||||
1750008 | 1750008 | CO | school | 804590 | 2760 | Hayden RE-1 | 80459000675 | 2522 | Hayden Valley Elementary School | Regular School | No | Elementary | PK | 05 | 2021 | grade_2 | 28 | 0 | 1 | 0 | 0 | 0 | 1 | 14 | 16 | 30 | 28 | 0 | 1 | 0 | 0 | 0 | 1 | 14 | 16 | 30 | ||||||||||||||||||||||||||||||||||
1750289 | 1750289 | CO | school | 806810 | 3000 | Summit RE-1 | 80681001563 | 8385 | Summit Cove Elementary School | Regular School | No | Elementary | PK | 05 | 2021 | grade_2 | 16 | 0 | 11 | 1 | 0 | 0 | 0 | 14 | 14 | 28 | 16 | 0 | 11 | 1 | 0 | 0 | 0 | 14 | 14 | 28 | ||||||||||||||||||||||||||||||||||
1751319 | 1751319 | CO | school | 800020 | 8001 | Charter School Institute | 80002006701 | 5423 | Mountain Village Montessori Charter School | Regular School | Yes | Elementary | PK | 05 | 2021 | grade_2 | 21 | 0 | 1 | 0 | 0 | 0 | 0 | 14 | 8 | 22 | 21 | 0 | 1 | 0 | 0 | 0 | 0 | 14 | 8 | 22 | ||||||||||||||||||||||||||||||||||
1739210 | 1739210 | CO | school | 807230 | 70 | Westminster Public Schools | 80723006675 | 9236 | Westminster Academy for International Studies | Regular School | No | Elementary | PK | 08 | 2021 | grade_2 | 8 | 1 | 21 | 1 | 0 | 0 | 0 | 15 | 16 | 31 | 8 | 1 | 21 | 1 | 0 | 0 | 0 | 15 | 16 | 31 | ||||||||||||||||||||||||||||||||||
1739288 | 1739288 | CO | school | 803780 | 120 | Englewood 1 | 80378000488 | 1556 | Cherrelyn Elementary School | Regular School | No | Elementary | KG | 06 | 2021 | grade_2 | 11 | 0 | 19 | 0 | 0 | 0 | 4 | 15 | 19 | 34 | 11 | 0 | 19 | 0 | 0 | 0 | 4 | 15 | 19 | 34 | ||||||||||||||||||||||||||||||||||
1741177 | 1741177 | CO | school | 802490 | 480 | Boulder Valley Re 2 | 80249001227 | 1883 | Community Montessori School | Regular School | No | Elementary | PK | 06 | 2021 | grade_2 | 23 | 0 | 6 | 0 | 1 | 0 | 2 | 15 | 17 | 32 | 23 | 0 | 6 | 0 | 1 | 0 | 2 | 15 | 17 | 32 | ||||||||||||||||||||||||||||||||||
1741370 | 1741370 | CO | school | 802490 | 480 | Boulder Valley Re 2 | 80249000130 | 6208 | Nederland Elementary School | Regular School | No | Elementary | PK | 05 | 2021 | grade_2 | 24 | 0 | 0 | 0 | 0 | 0 | 2 | 15 | 11 | 26 | 24 | 0 | 0 | 0 | 0 | 0 | 2 | 15 | 11 | 26 | ||||||||||||||||||||||||||||||||||
1741883 | 1741883 | CO | school | 803360 | 880 | Denver County 1 | 80336000311 | 520 | Barnum Elementary School | Regular School | No | Elementary | PK | 05 | 2021 | grade_2 | 0 | 2 | 37 | 1 | 0 | 0 | 0 | 15 | 25 | 40 | 0 | 2 | 37 | 1 | 0 | 0 | 0 | 15 | 25 | 40 | ||||||||||||||||||||||||||||||||||
1742004 | 1742004 | CO | school | 803360 | 880 | Denver County 1 | 80336000327 | 1774 | Colfax Elementary School | Regular School | No | Elementary | PK | 05 | 2021 | grade_2 | 3 | 3 | 22 | 0 | 0 | 0 | 1 | 15 | 14 | 29 | 3 | 3 | 22 | 0 | 0 | 0 | 1 | 15 | 14 | 29 | ||||||||||||||||||||||||||||||||||
1742651 | 1742651 | CO | school | 803360 | 880 | Denver County 1 | 80336006555 | 5621 | Monarch Montessori | Regular School | Yes | Elementary | KG | 05 | 2021 | grade_2 | 4 | 4 | 22 | 1 | 0 | 0 | 0 | 15 | 16 | 31 | 4 | 4 | 22 | 1 | 0 | 0 | 0 | 15 | 16 | 31 | ||||||||||||||||||||||||||||||||||
1742929 | 1742929 | CO | school | 803360 | 880 | Denver County 1 | 80336000401 | 7698 | Schmitt Elementary School | Regular School | No | Elementary | PK | 05 | 2021 | grade_2 | 2 | 8 | 22 | 0 | 1 | 0 | 0 | 15 | 18 | 33 | 2 | 8 | 22 | 0 | 1 | 0 | 0 | 15 | 18 | 33 | ||||||||||||||||||||||||||||||||||
1744216 | 1744216 | CO | school | 804530 | 980 | Harrison 2 | 80453006663 | 5763 | Mountain Vista Homeschool Academy | Regular School | No | Other | KG | 12 | 2021 | grade_2 | 25 | 1 | 2 | 0 | 2 | 0 | 0 | 15 | 15 | 30 | 25 | 1 | 2 | 0 | 2 | 0 | 0 | 15 | 15 | 30 | ||||||||||||||||||||||||||||||||||
1744248 | 1744248 | CO | school | 804530 | 980 | Harrison 2 | 80453001369 | 6460 | Oak Creek Elementary School | Regular School | No | Elementary | PK | 05 | 2021 | grade_2 | 14 | 0 | 14 | 0 | 0 | 0 | 3 | 15 | 16 | 31 | 14 | 0 | 14 | 0 | 0 | 0 | 3 | 15 | 16 | 31 | ||||||||||||||||||||||||||||||||||
1746053 | 1746053 | CO | school | 807080 | 1390 | Huerfano Re-1 | 80708001845 | 63 | Peakview School | Regular School | No | Elementary | PK | 08 | 2021 | grade_2 | 8 | 0 | 22 | 2 | 0 | 0 | 0 | 15 | 17 | 32 | 8 | 0 | 22 | 2 | 0 | 0 | 0 | 15 | 17 | 32 | ||||||||||||||||||||||||||||||||||
1746232 | 1746232 | CO | school | 804800 | 1420 | Jefferson County R-1 | 80480000702 | 1238 | Campbell Elementary School | Regular School | No | Elementary | KG | 05 | 2021 | grade_2 | 20 | 0 | 8 | 0 | 1 | 0 | 2 | 15 | 16 | 31 | 20 | 0 | 8 | 0 | 1 | 0 | 2 | 15 | 16 | 31 | ||||||||||||||||||||||||||||||||||
1746526 | 1746526 | CO | school | 804800 | 1420 | Jefferson County R-1 | 80480006723 | 3691 | Great Work Montessori | Regular School | Yes | Elementary | PK | 06 | 2021 | grade_2 | 16 | 0 | 12 | 0 | 1 | 0 | 1 | 15 | 15 | 30 | 16 | 0 | 12 | 0 | 1 | 0 | 1 | 15 | 15 | 30 | ||||||||||||||||||||||||||||||||||
1746627 | 1746627 | CO | school | 804800 | 1420 | Jefferson County R-1 | 80480000744 | 4802 | Kullerstrand Elementary School | Regular School | No | Elementary | PK | 05 | 2021 | grade_2 | 23 | 0 | 11 | 0 | 1 | 0 | 3 | 15 | 23 | 38 | 23 | 0 | 11 | 0 | 1 | 0 | 3 | 15 | 23 | 38 | ||||||||||||||||||||||||||||||||||
1747234 | 1747234 | CO | school | 804800 | 1420 | Jefferson County R-1 | 80480000800 | 9424 | West Jefferson Elementary School | Regular School | No | Elementary | PK | 05 | 2021 | grade_2 | 30 | 0 | 1 | 0 | 0 | 0 | 1 | 15 | 17 | 32 | 30 | 0 | 1 | 0 | 0 | 0 | 1 | 15 | 17 | 32 | ||||||||||||||||||||||||||||||||||
1747442 | 1747442 | CO | school | 803480 | 1520 | Durango 9-R | 80348001066 | 225 | Animas Valley Elementary School | Regular School | No | Elementary | PK | 05 | 2021 | grade_2 | 25 | 0 | 4 | 3 | 0 | 0 | 1 | 15 | 18 | 33 | 25 | 0 | 4 | 3 | 0 | 0 | 1 | 15 | 18 | 33 | ||||||||||||||||||||||||||||||||||
1748031 | 1748031 | CO | school | 805400 | 1560 | Thompson R2-J | 80540000932 | 3320 | Garfield Elementary School | Regular School | No | Elementary | KG | 05 | 2021 | grade_2 | 17 | 1 | 3 | 1 | 0 | 0 | 0 | 15 | 7 | 22 | 17 | 1 | 3 | 1 | 0 | 0 | 0 | 15 | 7 | 22 | ||||||||||||||||||||||||||||||||||
1748055 | 1748055 | CO | school | 805400 | 1560 | Thompson R2-J | 80540001301 | 5018 | Laurene Edmondson Elementary School | Regular School | No | Elementary | KG | 05 | 2021 | grade_2 | 28 | 0 | 15 | 0 | 0 | 0 | 0 | 15 | 28 | 43 | 28 | 0 | 15 | 0 | 0 | 0 | 0 | 15 | 28 | 43 | ||||||||||||||||||||||||||||||||||
1748280 | 1748280 | CO | school | 802520 | 1750 | Branson Reorganized 82 | 80252001728 | 948 | Branson School Online | Regular School | No | Other | KG | 12 | 2021 | grade_2 | 34 | 2 | 4 | 0 | 0 | 0 | 1 | 15 | 26 | 41 | 34 | 2 | 4 | 0 | 0 | 0 | 1 | 15 | 26 | 41 | ||||||||||||||||||||||||||||||||||
1749928 | 1749928 | CO | school | 806180 | 2720 | Rangely RE-4 | 80618001086 | 7268 | Parkview Elementary School | Regular School | No | Elementary | PK | 05 | 2021 | grade_2 | 23 | 0 | 3 | 0 | 0 | 0 | 2 | 15 | 13 | 28 | 23 | 0 | 3 | 0 | 0 | 0 | 2 | 15 | 13 | 28 | ||||||||||||||||||||||||||||||||||
1750522 | 1750522 | CO | school | 804920 | 3090 | Weld County School District RE-3J | 80492000817 | 4526 | Hoff Elementary School | Regular School | No | Elementary | PK | 05 | 2021 | grade_2 | 26 | 0 | 9 | 0 | 0 | 0 | 3 | 15 | 23 | 38 | 26 | 0 | 9 | 0 | 0 | 0 | 3 | 15 | 23 | 38 | ||||||||||||||||||||||||||||||||||
1751178 | 1751178 | CO | school | 800020 | 8001 | Charter School Institute | 80002006784 | 1371 | Coperni 3 | Regular School | Yes | Elementary | KG | 07 | 2021 | grade_2 | 17 | 1 | 17 | 0 | 0 | 0 | 2 | 15 | 22 | 37 | 17 | 1 | 17 | 0 | 0 | 0 | 2 | 15 | 22 | 37 | ||||||||||||||||||||||||||||||||||
1751394 | 1751394 | CO | school | 800020 | 8001 | Charter School Institute | 80002006320 | 7278 | Ricardo Flores Magon Academy | Regular School | Yes | Elementary | KG | 08 | 2021 | grade_2 | 2 | 1 | 25 | 0 | 0 | 0 | 0 | 15 | 13 | 28 | 2 | 1 | 25 | 0 | 0 | 0 | 0 | 15 | 13 | 28 | ||||||||||||||||||||||||||||||||||
1743253 | 1743253 | CO | school | 803450 | 900 | Douglas County Re 1 | 80345001896 | 215 | American Academy | Regular School | Yes | Elementary | PK | 08 | 2021 | grade_2 | 205 | 1 | 27 | 1 | 53 | 0 | 19 | 158 | 148 | 306 | 205 | 1 | 27 | 1 | 53 | 0 | 19 | 158 | 148 | 306 | ||||||||||||||||||||||||||||||||||
1738692 | 1738692 | CO | school | 806900 | 20 | Adams 12 Five Star Schools | 80690006375 | 8211 | The Studio School | Regular School | No | Elementary | KG | 05 | 2021 | grade_2 | 24 | 0 | 20 | 0 | 1 | 0 | 3 | 16 | 32 | 48 | 24 | 0 | 20 | 0 | 1 | 0 | 3 | 16 | 32 | 48 | ||||||||||||||||||||||||||||||||||
1738940 | 1738940 | CO | school | 802580 | 40 | School District 27J | 80258000148 | 6294 | North Elementary School | Regular School | No | Elementary | PK | 05 | 2021 | grade_2 | 5 | 0 | 24 | 0 | 0 | 0 | 0 | 16 | 13 | 29 | 5 | 0 | 24 | 0 | 0 | 0 | 0 | 16 | 13 | 29 | ||||||||||||||||||||||||||||||||||
1739994 | 1739994 | CO | school | 802340 | 180 | Adams-Arapahoe 28J | 80234006399 | 213 | AXL Academy | Regular School | Yes | Elementary | PK | 08 | 2021 | grade_2 | 12 | 13 | 10 | 1 | 1 | 0 | 3 | 16 | 24 | 40 | 12 | 13 | 10 | 1 | 1 | 0 | 3 | 16 | 24 | 40 | ||||||||||||||||||||||||||||||||||
1740291 | 1740291 | CO | school | 802340 | 180 | Adams-Arapahoe 28J | 80234000076 | 6758 | Park Lane Elementary School | Regular School | No | Elementary | PK | 05 | 2021 | grade_2 | 2 | 2 | 18 | 0 | 2 | 3 | 2 | 16 | 13 | 29 | 2 | 2 | 18 | 0 | 2 | 3 | 2 | 16 | 13 | 29 | ||||||||||||||||||||||||||||||||||
1740770 | 1740770 | CO | school | 805370 | 470 | St Vrain Valley RE1J | 80537000897 | 1434 | Central Elementary School | Regular School | No | Elementary | PK | 05 | 2021 | grade_2 | 34 | 0 | 5 | 0 | 0 | 0 | 3 | 16 | 26 | 42 | 34 | 0 | 5 | 0 | 0 | 0 | 3 | 16 | 26 | 42 | ||||||||||||||||||||||||||||||||||
1740979 | 1740979 | CO | school | 805370 | 470 | St Vrain Valley RE1J | 80537000920 | 6404 | Northridge Elementary School | Regular School | No | Elementary | PK | 05 | 2021 | grade_2 | 5 | 0 | 31 | 0 | 1 | 0 | 2 | 16 | 23 | 39 | 5 | 0 | 31 | 0 | 1 | 0 | 2 | 16 | 23 | 39 | ||||||||||||||||||||||||||||||||||
1741602 | 1741602 | CO | school | 805100 | 550 | North Conejos RE-1J | 80510000845 | 5422 | Manassa Elementary School | Regular School | No | Elementary | KG | 05 | 2021 | grade_2 | 13 | 0 | 13 | 1 | 0 | 0 | 0 | 16 | 11 | 27 | 13 | 0 | 13 | 1 | 0 | 0 | 0 | 16 | 11 | 27 | ||||||||||||||||||||||||||||||||||
1741619 | 1741619 | CO | school | 806390 | 560 | Sanford 6J | 80639001113 | 7612 | Sanford Elementary School | Regular School | No | Elementary | PK | 06 | 2021 | grade_2 | 16 | 0 | 10 | 0 | 0 | 0 | 1 | 16 | 11 | 27 | 16 | 0 | 10 | 0 | 0 | 0 | 1 | 16 | 11 | 27 | ||||||||||||||||||||||||||||||||||
1742677 | 1742677 | CO | school | 803360 | 880 | Denver County 1 | 80336000377 | 5702 | McKinley-Thatcher Elementary School | Regular School | No | Elementary | PK | 05 | 2021 | grade_2 | 19 | 1 | 6 | 0 | 0 | 0 | 3 | 16 | 13 | 29 | 19 | 1 | 6 | 0 | 0 | 0 | 3 | 16 | 13 | 29 | ||||||||||||||||||||||||||||||||||
1743136 | 1743136 | CO | school | 803360 | 880 | Denver County 1 | 80336000424 | 9496 | Castro Elementary School | Regular School | No | Elementary | KG | 05 | 2021 | grade_2 | 2 | 5 | 29 | 0 | 0 | 0 | 1 | 16 | 21 | 37 | 2 | 5 | 29 | 0 | 0 | 0 | 1 | 16 | 21 | 37 | ||||||||||||||||||||||||||||||||||
1744052 | 1744052 | CO | school | 803720 | 920 | Elizabeth School District | 80372001479 | 7517 | Running Creek Elementary School | Regular School | No | Elementary | KG | 05 | 2021 | grade_2 | 33 | 0 | 4 | 0 | 0 | 0 | 0 | 16 | 21 | 37 | 33 | 0 | 4 | 0 | 0 | 0 | 0 | 16 | 21 | 37 | ||||||||||||||||||||||||||||||||||
1744227 | 1744227 | CO | school | 804530 | 980 | Harrison 2 | 80453006810 | 5898 | Atlas Preparatory Elementary School | Regular School | Yes | Elementary | KG | 02 | 2021 | grade_2 | 2 | 0 | 24 | 0 | 0 | 0 | 0 | 16 | 10 | 26 | 2 | 0 | 24 | 0 | 0 | 0 | 0 | 16 | 10 | 26 | ||||||||||||||||||||||||||||||||||
1745465 | 1745465 | CO | school | 803870 | 1110 | District 49 | 80387000505 | 2902 | Falcon Elementary School of Technology | Regular School | No | Elementary | PK | 05 | 2021 | grade_2 | 26 | 1 | 13 | 0 | 0 | 0 | 3 | 16 | 27 | 43 | 26 | 1 | 13 | 0 | 0 | 0 | 3 | 16 | 27 | 43 | ||||||||||||||||||||||||||||||||||
1746448 | 1746448 | CO | school | 804800 | 1420 | Jefferson County R-1 | 80480000724 | 3025 | Foothills Elementary School | Regular School | No | Elementary | PK | 05 | 2021 | grade_2 | 20 | 0 | 8 | 3 | 1 | 0 | 1 | 16 | 17 | 33 | 20 | 0 | 8 | 3 | 1 | 0 | 1 | 16 | 17 | 33 | ||||||||||||||||||||||||||||||||||
1746488 | 1746488 | CO | school | 804800 | 1420 | Jefferson County R-1 | 80480000731 | 3450 | Glennon Heights Elementary School | Regular School | No | Elementary | KG | 05 | 2021 | grade_2 | 17 | 3 | 10 | 0 | 0 | 0 | 1 | 16 | 15 | 31 | 17 | 3 | 10 | 0 | 0 | 0 | 1 | 16 | 15 | 31 | ||||||||||||||||||||||||||||||||||
1746691 | 1746691 | CO | school | 804800 | 1420 | Jefferson County R-1 | 80480001486 | 5350 | Lukas Elementary School | Regular School | No | Elementary | KG | 05 | 2021 | grade_2 | 28 | 0 | 7 | 1 | 0 | 0 | 4 | 16 | 24 | 40 | 28 | 0 | 7 | 1 | 0 | 0 | 4 | 16 | 24 | 40 | ||||||||||||||||||||||||||||||||||
1746888 | 1746888 | CO | school | 804800 | 1420 | Jefferson County R-1 | 80480000771 | 6828 | Peck Elementary School | Regular School | No | Elementary | KG | 05 | 2021 | grade_2 | 26 | 1 | 10 | 2 | 1 | 0 | 3 | 16 | 27 | 43 | 26 | 1 | 10 | 2 | 1 | 0 | 3 | 16 | 27 | 43 | ||||||||||||||||||||||||||||||||||
1746997 | 1746997 | CO | school | 804800 | 1420 | Jefferson County R-1 | 80480000780 | 7708 | Secrest Elementary School | Regular School | No | Elementary | PK | 05 | 2021 | grade_2 | 17 | 2 | 14 | 1 | 1 | 0 | 2 | 16 | 21 | 37 | 17 | 2 | 14 | 1 | 1 | 0 | 2 | 16 | 21 | 37 | ||||||||||||||||||||||||||||||||||
1747982 | 1747982 | CO | school | 805400 | 1560 | Thompson R2-J | 80540000924 | 865 | B F Kitchen Elementary School | Regular School | No | Elementary | KG | 05 | 2021 | grade_2 | 24 | 0 | 7 | 0 | 0 | 0 | 0 | 16 | 15 | 31 | 24 | 0 | 7 | 0 | 0 | 0 | 0 | 16 | 15 | 31 | ||||||||||||||||||||||||||||||||||
1748335 | 1748335 | CO | school | 805280 | 1790 | Limon RE-4J | 80528000870 | 5132 | Limon Elementary School | Regular School | No | Elementary | KG | 05 | 2021 | grade_2 | 25 | 0 | 7 | 0 | 0 | 0 | 0 | 16 | 16 | 32 | 25 | 0 | 7 | 0 | 0 | 0 | 0 | 16 | 16 | 32 | ||||||||||||||||||||||||||||||||||
1751119 | 1751119 | CO | school | 800020 | 8001 | Charter School Institute | 80002006768 | 493 | Axis International Academy | Regular School | Yes | Elementary | PK | 08 | 2021 | grade_2 | 16 | 2 | 11 | 0 | 1 | 0 | 2 | 16 | 16 | 32 | 16 | 2 | 11 | 0 | 1 | 0 | 2 | 16 | 16 | 32 | ||||||||||||||||||||||||||||||||||
1751327 | 1751327 | CO | school | 800020 | 8001 | Charter School Institute | 80002006761 | 5431 | Coperni 2 | Regular School | Yes | Elementary | KG | 08 | 2021 | grade_2 | 16 | 4 | 9 | 0 | 0 | 0 | 5 | 16 | 18 | 34 | 16 | 4 | 9 | 0 | 0 | 0 | 5 | 16 | 18 | 34 | ||||||||||||||||||||||||||||||||||
1739908 | 1739908 | CO | school | 805310 | 140 | Littleton 6 | 80531000891 | 5574 | Twain Elementary School | Regular School | No | Elementary | KG | 05 | 2021 | grade_2 | 27 | 1 | 3 | 0 | 1 | 0 | 4 | 17 | 19 | 36 | 27 | 1 | 3 | 0 | 1 | 0 | 4 | 17 | 19 | 36 | ||||||||||||||||||||||||||||||||||
1740778 | 1740778 | CO | school | 805370 | 470 | St Vrain Valley RE1J | 80537001373 | 1844 | Columbine Elementary School | Regular School | No | Elementary | PK | 05 | 2021 | grade_2 | 3 | 0 | 29 | 0 | 0 | 0 | 0 | 17 | 15 | 32 | 3 | 0 | 29 | 0 | 0 | 0 | 0 | 17 | 15 | 32 | ||||||||||||||||||||||||||||||||||
1741844 | 1741844 | CO | school | 803360 | 880 | Denver County 1 | 80336006592 | 99 | Academy 360 | Regular School | Yes | Elementary | PK | 05 | 2021 | grade_2 | 5 | 10 | 13 | 0 | 1 | 1 | 0 | 17 | 13 | 30 | 5 | 10 | 13 | 0 | 1 | 1 | 0 | 17 | 13 | 30 | ||||||||||||||||||||||||||||||||||
1742789 | 1742789 | CO | school | 803360 | 880 | Denver County 1 | 80336001636 | 6479 | Odyssey School of Denver | Regular School | Yes | Elementary | KG | 08 | 2021 | grade_2 | 18 | 0 | 3 | 1 | 0 | 0 | 4 | 17 | 9 | 26 | 18 | 0 | 3 | 1 | 0 | 0 | 4 | 17 | 9 | 26 | ||||||||||||||||||||||||||||||||||
1744308 | 1744308 | CO | school | 804530 | 980 | Harrison 2 | 80453001443 | 8923 | Turman Elementary School | Regular School | No | Elementary | PK | 05 | 2021 | grade_2 | 10 | 5 | 17 | 0 | 1 | 0 | 1 | 17 | 17 | 34 | 10 | 5 | 17 | 0 | 1 | 0 | 1 | 17 | 17 | 34 | ||||||||||||||||||||||||||||||||||
1744523 | 1744523 | CO | school | 803060 | 1010 | Colorado Springs 11 | 80306006456 | 517 | Academy for Advanced and Creative Learning | Regular School | Yes | Elementary | KG | 08 | 2021 | grade_2 | 27 | 0 | 7 | 0 | 1 | 0 | 4 | 17 | 22 | 39 | 27 | 0 | 7 | 0 | 1 | 0 | 4 | 17 | 22 | 39 | ||||||||||||||||||||||||||||||||||
1744538 | 1744538 | CO | school | 803060 | 1010 | Colorado Springs 11 | 80306000224 | 1032 | Bristol Elementary School | Regular School | No | Elementary | KG | 05 | 2021 | grade_2 | 23 | 2 | 7 | 0 | 0 | 0 | 3 | 17 | 18 | 35 | 23 | 2 | 7 | 0 | 0 | 0 | 3 | 17 | 18 | 35 | ||||||||||||||||||||||||||||||||||
1744785 | 1744785 | CO | school | 803060 | 1010 | Colorado Springs 11 | 80306000260 | 7228 | Queen Palmer Elementary School | Regular School | No | Elementary | KG | 05 | 2021 | grade_2 | 16 | 6 | 15 | 1 | 0 | 0 | 1 | 17 | 22 | 39 | 16 | 6 | 15 | 1 | 0 | 0 | 1 | 17 | 22 | 39 | ||||||||||||||||||||||||||||||||||
1745272 | 1745272 | CO | school | 806060 | 1060 | Peyton 23 Jt | 80606001024 | 6898 | Peyton Elementary School | Regular School | No | Elementary | PK | 06 | 2021 | grade_2 | 21 | 0 | 8 | 0 | 0 | 0 | 5 | 17 | 17 | 34 | 21 | 0 | 8 | 0 | 0 | 0 | 5 | 17 | 17 | 34 | ||||||||||||||||||||||||||||||||||
1746514 | 1746514 | CO | school | 804800 | 1420 | Jefferson County R-1 | 80480000735 | 3624 | Green Mountain Elementary School | Regular School | No | Elementary | PK | 05 | 2021 | grade_2 | 20 | 0 | 9 | 0 | 2 | 0 | 0 | 17 | 14 | 31 | 20 | 0 | 9 | 0 | 2 | 0 | 0 | 17 | 14 | 31 | ||||||||||||||||||||||||||||||||||
1747880 | 1747880 | CO | school | 803990 | 1550 | Poudre R-1 | 80399000542 | 7218 | Putnam Elementary School | Regular School | No | Elementary | PK | 05 | 2021 | grade_2 | 10 | 3 | 24 | 0 | 0 | 0 | 2 | 17 | 22 | 39 | 10 | 3 | 24 | 0 | 0 | 0 | 2 | 17 | 22 | 39 | ||||||||||||||||||||||||||||||||||
1748570 | 1748570 | CO | school | 804350 | 2000 | Mesa County Valley 51 | 80435001691 | 2224 | Dos Rios Elementary School | Regular School | No | Elementary | PK | 05 | 2021 | grade_2 | 30 | 0 | 10 | 0 | 0 | 0 | 3 | 17 | 26 | 43 | 30 | 0 | 10 | 0 | 0 | 0 | 3 | 17 | 26 | 43 | ||||||||||||||||||||||||||||||||||
1748665 | 1748665 | CO | school | 804350 | 2000 | Mesa County Valley 51 | 80435000615 | 5244 | Loma Elementary School | Regular School | No | Elementary | PK | 05 | 2021 | grade_2 | 31 | 0 | 4 | 0 | 0 | 0 | 3 | 17 | 21 | 38 | 31 | 0 | 4 | 0 | 0 | 0 | 3 | 17 | 21 | 38 | ||||||||||||||||||||||||||||||||||
1748933 | 1748933 | CO | school | 803390 | 2055 | Dolores RE-4A | 80339000430 | 2204 | Dolores Elementary School | Regular School | No | Elementary | KG | 05 | 2021 | grade_2 | 37 | 0 | 4 | 2 | 0 | 0 | 0 | 17 | 26 | 43 | 37 | 0 | 4 | 2 | 0 | 0 | 0 | 17 | 26 | 43 | ||||||||||||||||||||||||||||||||||
1749749 | 1749749 | CO | school | 806150 | 2700 | Pueblo County 70 | 80615001069 | 472 | Avondale Elementary School | Regular School | No | Elementary | PK | 05 | 2021 | grade_2 | 7 | 0 | 18 | 0 | 0 | 0 | 0 | 17 | 8 | 25 | 7 | 0 | 18 | 0 | 0 | 0 | 0 | 17 | 8 | 25 | ||||||||||||||||||||||||||||||||||
1749944 | 1749944 | CO | school | 803300 | 2730 | Upper Rio Grande School District C-7 | 80330000289 | 2148 | Del Norte Elementary School | Regular School | No | Elementary | KG | 06 | 2021 | grade_2 | 13 | 0 | 14 | 0 | 0 | 0 | 0 | 17 | 10 | 27 | 13 | 0 | 14 | 0 | 0 | 0 | 0 | 17 | 10 | 27 | ||||||||||||||||||||||||||||||||||
1750297 | 1750297 | CO | school | 806810 | 3000 | Summit RE-1 | 80681001564 | 8993 | Upper Blue Elementary School | Regular School | No | Elementary | PK | 05 | 2021 | grade_2 | 17 | 0 | 13 | 0 | 0 | 0 | 0 | 17 | 13 | 30 | 17 | 0 | 13 | 0 | 0 | 0 | 0 | 17 | 13 | 30 | ||||||||||||||||||||||||||||||||||
1745049 | 1745049 | CO | school | 801920 | 1040 | Academy 20 | 80192001592 | 1627 | The Classical Academy Charter | Regular School | Yes | Elementary | KG | 06 | 2021 | grade_2 | 246 | 3 | 29 | 1 | 22 | 0 | 24 | 170 | 155 | 325 | 246 | 3 | 29 | 1 | 22 | 0 | 24 | 170 | 155 | 325 | ||||||||||||||||||||||||||||||||||
1739095 | 1739095 | CO | school | 807230 | 70 | Westminster Public Schools | 80723001235 | 2876 | Fairview Elementary School | Regular School | No | Elementary | PK | 05 | 2021 | grade_2 | 5 | 1 | 31 | 0 | 3 | 0 | 1 | 18 | 23 | 41 | 5 | 1 | 31 | 0 | 3 | 0 | 1 | 18 | 23 | 41 | ||||||||||||||||||||||||||||||||||
1739174 | 1739174 | CO | school | 807230 | 70 | Westminster Public Schools | 80723001246 | 7860 | Sherrelwood Elementary School | Regular School | No | Elementary | PK | 05 | 2021 | grade_2 | 7 | 0 | 34 | 0 | 0 | 1 | 0 | 18 | 24 | 42 | 7 | 0 | 34 | 0 | 0 | 1 | 0 | 18 | 24 | 42 | ||||||||||||||||||||||||||||||||||
1739594 | 1739594 | CO | school | 802910 | 130 | Cherry Creek 5 | 80291006676 | 4189 | Heritage Heights Academy | Regular School | Yes | Elementary | KG | 08 | 2021 | grade_2 | 26 | 6 | 2 | 0 | 13 | 1 | 2 | 18 | 32 | 50 | 26 | 6 | 2 | 0 | 13 | 1 | 2 | 18 | 32 | 50 | ||||||||||||||||||||||||||||||||||
1741682 | 1741682 | CO | school | 803210 | 770 | Crowley County RE-1-J | 80321001519 | 2054 | Crowley County Elementary K-6 | Regular School | No | Elementary | KG | 06 | 2021 | grade_2 | 18 | 0 | 10 | 0 | 0 | 0 | 0 | 18 | 10 | 28 | 18 | 0 | 10 | 0 | 0 | 0 | 0 | 18 | 10 | 28 | ||||||||||||||||||||||||||||||||||
1741891 | 1741891 | CO | school | 803360 | 880 | Denver County 1 | 80336000313 | 650 | Beach Court Elementary School | Regular School | No | Elementary | PK | 05 | 2021 | grade_2 | 1 | 1 | 36 | 1 | 0 | 0 | 0 | 18 | 21 | 39 | 1 | 1 | 36 | 1 | 0 | 0 | 0 | 18 | 21 | 39 | ||||||||||||||||||||||||||||||||||
1742036 | 1742036 | CO | school | 803360 | 880 | Denver County 1 | 80336000330 | 1846 | Columbine Elementary School | Regular School | No | Elementary | PK | 05 | 2021 | grade_2 | 6 | 13 | 12 | 0 | 0 | 0 | 0 | 18 | 13 | 31 | 6 | 13 | 12 | 0 | 0 | 0 | 0 | 18 | 13 | 31 | ||||||||||||||||||||||||||||||||||
1742780 | 1742780 | CO | school | 803360 | 880 | Denver County 1 | 80336001750 | 6397 | Academia Ana Marie Sandoval | Regular School | No | Elementary | PK | 06 | 2021 | grade_2 | 11 | 0 | 26 | 0 | 2 | 0 | 1 | 18 | 22 | 40 | 11 | 0 | 26 | 0 | 2 | 0 | 1 | 18 | 22 | 40 | ||||||||||||||||||||||||||||||||||
1743816 | 1743816 | CO | school | 803450 | 900 | Douglas County Re 1 | 80345001407 | 7610 | Sand Creek Elementary School | Regular School | No | Elementary | PK | 06 | 2021 | grade_2 | 24 | 1 | 5 | 0 | 1 | 0 | 9 | 18 | 22 | 40 | 24 | 1 | 5 | 0 | 1 | 0 | 9 | 18 | 22 | 40 | ||||||||||||||||||||||||||||||||||
1743872 | 1743872 | CO | school | 803450 | 900 | Douglas County Re 1 | 80345001585 | 8897 | Trailblazer Elementary School | Regular School | No | Elementary | PK | 06 | 2021 | grade_2 | 30 | 1 | 6 | 0 | 0 | 0 | 1 | 18 | 20 | 38 | 30 | 1 | 6 | 0 | 0 | 0 | 1 | 18 | 20 | 38 | ||||||||||||||||||||||||||||||||||
1743981 | 1743981 | CO | school | 803540 | 910 | Eagle County RE 50 | 80354006222 | 3710 | Gypsum Elementary School | Regular School | No | Elementary | PK | 05 | 2021 | grade_2 | 5 | 0 | 30 | 0 | 0 | 0 | 0 | 18 | 17 | 35 | 5 | 0 | 30 | 0 | 0 | 0 | 0 | 18 | 17 | 35 | ||||||||||||||||||||||||||||||||||
1743989 | 1743989 | CO | school | 803540 | 910 | Eagle County RE 50 | 80354001478 | 5742 | Homestake Peak School | Regular School | No | Elementary | PK | 08 | 2021 | grade_2 | 13 | 0 | 25 | 0 | 1 | 0 | 0 | 18 | 21 | 39 | 13 | 0 | 25 | 0 | 1 | 0 | 0 | 18 | 21 | 39 | ||||||||||||||||||||||||||||||||||
1744515 | 1744515 | CO | school | 803060 | 1010 | Colorado Springs 11 | 80306000222 | 452 | Audubon Elementary School | Regular School | No | Elementary | PK | 05 | 2021 | grade_2 | 23 | 2 | 13 | 0 | 0 | 0 | 2 | 18 | 22 | 40 | 23 | 2 | 13 | 0 | 0 | 0 | 2 | 18 | 22 | 40 | ||||||||||||||||||||||||||||||||||
1744830 | 1744830 | CO | school | 803060 | 1010 | Colorado Springs 11 | 80306000266 | 8346 | Stratton Elementary School | Regular School | No | Elementary | PK | 05 | 2021 | grade_2 | 32 | 2 | 3 | 2 | 0 | 0 | 0 | 18 | 21 | 39 | 32 | 2 | 3 | 2 | 0 | 0 | 0 | 18 | 21 | 39 | ||||||||||||||||||||||||||||||||||
1744850 | 1744850 | CO | school | 803060 | 1010 | Colorado Springs 11 | 80306001642 | 8902 | Trailblazer Elementary School | Regular School | No | Elementary | PK | 05 | 2021 | grade_2 | 26 | 0 | 10 | 0 | 0 | 0 | 3 | 18 | 21 | 39 | 26 | 0 | 10 | 0 | 0 | 0 | 3 | 18 | 21 | 39 | ||||||||||||||||||||||||||||||||||
1745103 | 1745103 | CO | school | 801920 | 1040 | Academy 20 | 80192000004 | 2524 | Edith Wolford Elementary School | Regular School | No | Elementary | PK | 05 | 2021 | grade_2 | 29 | 0 | 4 | 0 | 0 | 0 | 0 | 18 | 15 | 33 | 29 | 0 | 4 | 0 | 0 | 0 | 0 | 18 | 15 | 33 | ||||||||||||||||||||||||||||||||||
1745367 | 1745367 | CO | school | 805820 | 1080 | Lewis-Palmer 38 | 80582001397 | 6682 | Palmer Lake Elementary School | Regular School | No | Elementary | PK | 06 | 2021 | grade_2 | 32 | 0 | 11 | 1 | 0 | 0 | 0 | 18 | 26 | 44 | 32 | 0 | 11 | 1 | 0 | 0 | 0 | 18 | 26 | 44 | ||||||||||||||||||||||||||||||||||
1745939 | 1745939 | CO | school | 804230 | 1330 | Gilpin County RE-1 | 80423000581 | 1632 | Gilpin County Elementary School | Regular School | No | Elementary | PK | 05 | 2021 | grade_2 | 29 | 0 | 2 | 0 | 0 | 0 | 2 | 18 | 15 | 33 | 29 | 0 | 2 | 0 | 0 | 0 | 2 | 18 | 15 | 33 | ||||||||||||||||||||||||||||||||||
1745974 | 1745974 | CO | school | 804320 | 1350 | East Grand 2 | 80432000594 | 3182 | Fraser Valley Elementary School | Regular School | No | Elementary | PK | 05 | 2021 | grade_2 | 36 | 0 | 8 | 0 | 0 | 0 | 0 | 18 | 26 | 44 | 36 | 0 | 8 | 0 | 0 | 0 | 0 | 18 | 26 | 44 | ||||||||||||||||||||||||||||||||||
1746456 | 1746456 | CO | school | 804800 | 1420 | Jefferson County R-1 | 80480000725 | 3088 | Foster Dual Language PK-8 | Regular School | No | Elementary | PK | 08 | 2021 | grade_2 | 15 | 0 | 32 | 0 | 1 | 0 | 2 | 18 | 32 | 50 | 15 | 0 | 32 | 0 | 1 | 0 | 2 | 18 | 32 | 50 | ||||||||||||||||||||||||||||||||||
1746959 | 1746959 | CO | school | 804800 | 1420 | Jefferson County R-1 | 80480006724 | 7468 | Rose Stein International Elementary | Regular School | No | Elementary | PK | 06 | 2021 | grade_2 | 6 | 0 | 29 | 0 | 0 | 0 | 2 | 18 | 19 | 37 | 6 | 0 | 29 | 0 | 0 | 0 | 2 | 18 | 19 | 37 | ||||||||||||||||||||||||||||||||||
1748003 | 1748003 | CO | school | 805400 | 1560 | Thompson R2-J | 80540001352 | 1323 | Carrie Martin Elementary School | Regular School | No | Elementary | KG | 05 | 2021 | grade_2 | 26 | 0 | 6 | 0 | 1 | 0 | 1 | 18 | 16 | 34 | 26 | 0 | 6 | 0 | 1 | 0 | 1 | 18 | 16 | 34 | ||||||||||||||||||||||||||||||||||
1748249 | 1748249 | CO | school | 804650 | 1600 | Hoehne Reorganized 3 | 80465000680 | 4048 | Hoehne Schools | Regular School | No | Other | PK | 12 | 2021 | grade_2 | 10 | 0 | 16 | 0 | 0 | 0 | 0 | 18 | 8 | 26 | 10 | 0 | 16 | 0 | 0 | 0 | 0 | 18 | 8 | 26 | ||||||||||||||||||||||||||||||||||
1749588 | 1749588 | CO | school | 806120 | 2690 | Pueblo City 60 | 80612001038 | 1828 | Columbian Elementary School | Regular School | No | Elementary | PK | 05 | 2021 | grade_2 | 10 | 2 | 23 | 2 | 0 | 0 | 0 | 18 | 19 | 37 | 10 | 2 | 23 | 2 | 0 | 0 | 0 | 18 | 19 | 37 | ||||||||||||||||||||||||||||||||||
1749607 | 1749607 | CO | school | 806120 | 2690 | Pueblo City 60 | 80612001041 | 2438 | Eva R Baca Elementary School | Regular School | No | Elementary | PK | 05 | 2021 | grade_2 | 6 | 1 | 31 | 1 | 0 | 0 | 1 | 18 | 22 | 40 | 6 | 1 | 31 | 1 | 0 | 0 | 1 | 18 | 22 | 40 | ||||||||||||||||||||||||||||||||||
1750137 | 1750137 | CO | school | 802850 | 2810 | Center 26 JT | 80285000177 | 1412 | Haskin Elementary School | Regular School | No | Elementary | PK | 05 | 2021 | grade_2 | 2 | 0 | 30 | 0 | 0 | 0 | 0 | 18 | 14 | 32 | 2 | 0 | 30 | 0 | 0 | 0 | 0 | 18 | 14 | 32 | ||||||||||||||||||||||||||||||||||
1750313 | 1750313 | CO | school | 803180 | 3010 | Cripple Creek-Victor RE-1 | 80318000280 | 9080 | Cresson Elementary School | Regular School | No | Elementary | PK | 05 | 2021 | grade_2 | 18 | 0 | 4 | 1 | 1 | 0 | 1 | 18 | 7 | 25 | 18 | 0 | 4 | 1 | 1 | 0 | 1 | 18 | 7 | 25 | ||||||||||||||||||||||||||||||||||
1750346 | 1750346 | CO | school | 807380 | 3020 | Woodland Park Re-2 | 80738001269 | 9698 | Columbine Elementary School | Regular School | No | Elementary | PK | 05 | 2021 | grade_2 | 27 | 0 | 6 | 0 | 1 | 0 | 2 | 18 | 18 | 36 | 27 | 0 | 6 | 0 | 1 | 0 | 2 | 18 | 18 | 36 | ||||||||||||||||||||||||||||||||||
1751404 | 1751404 | CO | school | 800020 | 8001 | Charter School Institute | 80002001913 | 7512 | Ross Montessori School | Regular School | Yes | Elementary | KG | 08 | 2021 | grade_2 | 35 | 0 | 8 | 0 | 1 | 0 | 0 | 18 | 26 | 44 | 35 | 0 | 8 | 0 | 1 | 0 | 0 | 18 | 26 | 44 | ||||||||||||||||||||||||||||||||||
1751501 | 1751501 | CO | school | 800282 | 9170 | Education reEnvisioned BOCES | 80028206752 | 1448 | Colorado Preparatory Academy Elementary School | Regular School | No | Elementary | KG | 05 | 2021 | grade_2 | 199 | 30 | 106 | 1 | 1 | 3 | 42 | 188 | 194 | 382 | 199 | 30 | 106 | 1 | 1 | 3 | 42 | 188 | 194 | 382 | ||||||||||||||||||||||||||||||||||
1740232 | 1740232 | CO | school | 802340 | 180 | Adams-Arapahoe 28J | 80234000070 | 5361 | Lyn Knoll Elementary School | Regular School | No | Elementary | PK | 05 | 2021 | grade_2 | 4 | 7 | 24 | 0 | 0 | 0 | 3 | 19 | 19 | 38 | 4 | 7 | 24 | 0 | 0 | 0 | 3 | 19 | 19 | 38 | ||||||||||||||||||||||||||||||||||
1741079 | 1741079 | CO | school | 802490 | 480 | Boulder Valley Re 2 | 80249001758 | 441 | Aspen Creek K-8 School | Regular School | No | Elementary | PK | 08 | 2021 | grade_2 | 37 | 0 | 8 | 0 | 1 | 0 | 6 | 19 | 33 | 52 | 37 | 0 | 8 | 0 | 1 | 0 | 6 | 19 | 33 | 52 |
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]);