enrollments
Data source: Big Local News · About: Big Local
1,104 rows where grade = "grade_2", state = "CO" and year = 2020 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1801635 | 1801635 | CO | school | 806990 | 260 | Vilas RE-5 | 80699001206 | 9090 | Vilas Elementary School | Regular School | No | Elementary | PK | 06 | 2020 | grade_2 | 8 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 4 | 8 | 8 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 4 | 8 | ||||||||||||||||||||||||||||||||||
1801700 | 1801700 | CO | school | 805580 | 310 | McClave Re-2 | 80558000962 | 5666 | McClave Elementary School | Regular School | No | Elementary | PK | 06 | 2020 | grade_2 | 15 | 1 | 0 | 0 | 0 | 0 | 0 | 7 | 9 | 16 | 15 | 1 | 0 | 0 | 0 | 0 | 0 | 7 | 9 | 16 | ||||||||||||||||||||||||||||||||||
1802293 | 1802293 | CO | school | 802490 | 480 | Boulder Valley Re 2 | 80249000117 | 3488 | Gold Hill Elementary School | Regular School | No | Elementary | KG | 05 | 2020 | grade_2 | 3 | 0 | 0 | 0 | 0 | 0 | 1 | 3 | 1 | 4 | 3 | 0 | 0 | 0 | 0 | 0 | 1 | 3 | 1 | 4 | ||||||||||||||||||||||||||||||||||
1802314 | 1802314 | CO | school | 802490 | 480 | Boulder Valley Re 2 | 80249000119 | 4386 | Jamestown Elementary School | Regular School | No | Elementary | KG | 05 | 2020 | grade_2 | 2 | 0 | 0 | 0 | 0 | 0 | 0 | 2 | 0 | 2 | 2 | 0 | 0 | 0 | 0 | 0 | 0 | 2 | 0 | 2 | ||||||||||||||||||||||||||||||||||
1802582 | 1802582 | CO | school | 803000 | 540 | Clear Creek RE-1 | 80300001999 | 3385 | Georgetown Community School | Regular School | Yes | Elementary | PK | 06 | 2020 | grade_2 | 12 | 0 | 0 | 0 | 0 | 0 | 0 | 5 | 7 | 12 | 12 | 0 | 0 | 0 | 0 | 0 | 0 | 5 | 7 | 12 | ||||||||||||||||||||||||||||||||||
1802832 | 1802832 | CO | school | 803330 | 870 | Delta County 50(J) | 80333006667 | 6295 | North Fork School of Integrated Studies | Regular School | No | Elementary | KG | 06 | 2020 | grade_2 | 7 | 0 | 0 | 0 | 0 | 0 | 0 | 3 | 4 | 7 | 7 | 0 | 0 | 0 | 0 | 0 | 0 | 3 | 4 | 7 | ||||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||
1805186 | 1805186 | CO | school | 803690 | 950 | Elbert 200 | 80369000480 | 2570 | Elbert Elementary School | Regular School | No | Elementary | PK | 05 | 2020 | grade_2 | 7 | 1 | 0 | 0 | 0 | 1 | 0 | 5 | 4 | 9 | 7 | 1 | 0 | 0 | 0 | 1 | 0 | 5 | 4 | 9 | ||||||||||||||||||||||||||||||||||
1805913 | 1805913 | CO | school | 803060 | 1010 | Colorado Springs 11 | 80306000265 | 8246 | Steele Elementary School | Regular School | No | Elementary | KG | 05 | 2020 | grade_2 | 40 | 3 | 0 | 0 | 2 | 0 | 3 | 28 | 20 | 48 | 40 | 3 | 0 | 0 | 2 | 0 | 3 | 28 | 20 | 48 | ||||||||||||||||||||||||||||||||||
1806838 | 1806838 | CO | school | 803120 | 1160 | Cotopaxi RE-3 | 80312000276 | 3220 | Cotopaxi Elementary School | Regular School | No | Elementary | PK | 05 | 2020 | grade_2 | 16 | 1 | 0 | 0 | 0 | 0 | 0 | 9 | 8 | 17 | 16 | 1 | 0 | 0 | 0 | 0 | 0 | 9 | 8 | 17 | ||||||||||||||||||||||||||||||||||
1807129 | 1807129 | CO | school | 804620 | 1380 | Hinsdale County RE 1 | 80462001969 | 4899 | Lake City Community School | Regular School | No | Other | PK | 12 | 2020 | grade_2 | 7 | 1 | 0 | 1 | 0 | 0 | 1 | 7 | 3 | 10 | 7 | 1 | 0 | 1 | 0 | 0 | 1 | 7 | 3 | 10 | ||||||||||||||||||||||||||||||||||
1807852 | 1807852 | CO | school | 804800 | 1420 | Jefferson County R-1 | 80480000756 | 5892 | Miller Special Education | Special Education School | No | Other | PK | 12 | 2020 | grade_2 | 5 | 0 | 0 | 0 | 0 | 0 | 0 | 3 | 2 | 5 | 5 | 0 | 0 | 0 | 0 | 0 | 0 | 3 | 2 | 5 | ||||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||
1808345 | 1808345 | CO | school | 804800 | 1420 | Jefferson County R-1 | 80480000800 | 9424 | West Jefferson Elementary School | Regular School | No | Elementary | PK | 05 | 2020 | grade_2 | 42 | 0 | 0 | 0 | 0 | 0 | 2 | 25 | 19 | 44 | 42 | 0 | 0 | 0 | 0 | 0 | 2 | 25 | 19 | 44 | ||||||||||||||||||||||||||||||||||
1808717 | 1808717 | CO | school | 803990 | 1550 | Poudre R-1 | 80399006776 | 473 | PSD Mountain Schools | Regular School | No | Elementary | KG | 05 | 2020 | grade_2 | 12 | 0 | 0 | 0 | 0 | 0 | 0 | 6 | 6 | 12 | 12 | 0 | 0 | 0 | 0 | 0 | 0 | 6 | 6 | 12 | ||||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||
1809327 | 1809327 | CO | school | 803810 | 1570 | Estes Park R-3 | 80381006426 | 2788 | Estes Park Options School | Alternative School | No | Other | KG | 12 | 2020 | grade_2 | 6 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 2 | 6 | 6 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 2 | 6 | ||||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||
1809542 | 1809542 | CO | school | 803930 | 1850 | Frenchman RE-3 | 80393000511 | 2980 | Fleming Elementary School | Regular School | No | Elementary | PK | 06 | 2020 | grade_2 | 16 | 0 | 0 | 0 | 0 | 0 | 0 | 8 | 8 | 16 | 16 | 0 | 0 | 0 | 0 | 0 | 0 | 8 | 8 | 16 | ||||||||||||||||||||||||||||||||||
1809608 | 1809608 | CO | school | 803030 | 1990 | Plateau Valley 50 | 80303000219 | 7024 | Plateau Valley Elementary School | Regular School | No | Elementary | PK | 05 | 2020 | grade_2 | 13 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 9 | 13 | 13 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 9 | 13 | ||||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||
1810057 | 1810057 | CO | school | 803090 | 2035 | Montezuma-Cortez RE-1 | 80309000841 | 7082 | Pleasant View Elementary School | Regular School | No | Elementary | KG | 05 | 2020 | grade_2 | 4 | 0 | 0 | 0 | 0 | 0 | 1 | 3 | 2 | 5 | 4 | 0 | 0 | 0 | 0 | 0 | 1 | 3 | 2 | 5 | ||||||||||||||||||||||||||||||||||
1810191 | 1810191 | CO | school | 805850 | 2190 | West End RE-2 | 80585001398 | 6196 | Naturita Elementary School | Regular School | No | Elementary | PK | 06 | 2020 | grade_2 | 14 | 0 | 0 | 0 | 0 | 0 | 0 | 8 | 6 | 14 | 14 | 0 | 0 | 0 | 0 | 0 | 0 | 8 | 6 | 14 | ||||||||||||||||||||||||||||||||||
1810455 | 1810455 | CO | school | 803840 | 2610 | Park County RE-2 | 80384001695 | 3681 | Guffey Charter School | Regular School | Yes | Elementary | PK | 08 | 2020 | grade_2 | 5 | 0 | 0 | 0 | 0 | 0 | 0 | 3 | 2 | 5 | 5 | 0 | 0 | 0 | 0 | 0 | 0 | 3 | 2 | 5 | ||||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||
1811154 | 1811154 | CO | school | 806660 | 2770 | Steamboat Springs RE-2 | 80666001749 | 6363 | North Routt Charter School | Regular School | Yes | Elementary | KG | 08 | 2020 | grade_2 | 10 | 0 | 0 | 0 | 0 | 0 | 0 | 5 | 5 | 10 | 10 | 0 | 0 | 0 | 0 | 0 | 0 | 5 | 5 | 10 | ||||||||||||||||||||||||||||||||||
1811533 | 1811533 | CO | school | 805340 | 3060 | Lone Star 101 | 80534000894 | 5254 | Lone Star Elementary School | Regular School | No | Elementary | KG | 05 | 2020 | grade_2 | 7 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 3 | 7 | 7 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 3 | 7 | ||||||||||||||||||||||||||||||||||
1811545 | 1811545 | CO | school | 807410 | 3070 | Woodlin R-104 | 80741001270 | 9700 | Woodlin Elementary School | Regular School | No | Elementary | PK | 05 | 2020 | grade_2 | 6 | 0 | 0 | 0 | 0 | 0 | 0 | 3 | 3 | 6 | 6 | 0 | 0 | 0 | 0 | 0 | 0 | 3 | 3 | 6 | ||||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||
1812507 | 1812507 | CO | school | 800020 | 8001 | Charter School Institute | 80002006651 | 8061 | Salida Montessori Charter School | Regular School | Yes | Elementary | PK | 08 | 2020 | grade_2 | 10 | 0 | 0 | 0 | 0 | 0 | 1 | 5 | 6 | 11 | 10 | 0 | 0 | 0 | 0 | 0 | 1 | 5 | 6 | 11 | ||||||||||||||||||||||||||||||||||
1800977 | 1800977 | CO | school | 805310 | 140 | Littleton 6 | 80531000889 | 7606 | Sandburg Elementary School | Regular School | No | Elementary | KG | 05 | 2020 | grade_2 | 73 | 0 | 1 | 0 | 2 | 0 | 1 | 45 | 32 | 77 | 73 | 0 | 1 | 0 | 2 | 0 | 1 | 45 | 32 | 77 | ||||||||||||||||||||||||||||||||||
1801602 | 1801602 | CO | school | 806090 | 240 | Pritchett RE-3 | 80609001026 | 7174 | Pritchett Elementary School | Regular School | No | Elementary | PK | 05 | 2020 | grade_2 | 4 | 0 | 1 | 0 | 0 | 0 | 0 | 3 | 2 | 5 | 4 | 0 | 1 | 0 | 0 | 0 | 0 | 3 | 2 | 5 | ||||||||||||||||||||||||||||||||||
1801651 | 1801651 | CO | school | 802760 | 270 | Campo RE-6 | 80276000169 | 1248 | Campo Elementary School | Regular School | No | Elementary | PK | 05 | 2020 | grade_2 | 1 | 0 | 1 | 0 | 0 | 0 | 2 | 2 | 2 | 4 | 1 | 0 | 1 | 0 | 0 | 0 | 2 | 2 | 2 | 4 | ||||||||||||||||||||||||||||||||||
1802139 | 1802139 | CO | school | 802490 | 480 | Boulder Valley Re 2 | 80249001630 | 919 | Boulder Community School/Integrated Studies | Regular School | No | Elementary | KG | 05 | 2020 | grade_2 | 42 | 1 | 1 | 0 | 1 | 0 | 6 | 32 | 19 | 51 | 42 | 1 | 1 | 0 | 1 | 0 | 6 | 32 | 19 | 51 | ||||||||||||||||||||||||||||||||||
1802370 | 1802370 | CO | school | 802490 | 480 | Boulder Valley Re 2 | 80249000129 | 5838 | Mesa Elementary School | Regular School | No | Elementary | KG | 05 | 2020 | grade_2 | 36 | 0 | 1 | 0 | 2 | 0 | 2 | 21 | 20 | 41 | 36 | 0 | 1 | 0 | 2 | 0 | 2 | 21 | 20 | 41 | ||||||||||||||||||||||||||||||||||
1802418 | 1802418 | CO | school | 802490 | 480 | Boulder Valley Re 2 | 80249006199 | 6642 | Horizons K-8 School | Alternative School | Yes | Elementary | KG | 08 | 2020 | grade_2 | 32 | 0 | 1 | 0 | 1 | 0 | 4 | 23 | 15 | 38 | 32 | 0 | 1 | 0 | 1 | 0 | 4 | 23 | 15 | 38 | ||||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||
1805152 | 1805152 | CO | school | 805010 | 930 | Kiowa C-2 | 80501000824 | 4724 | Kiowa Elementary School | Regular School | No | Elementary | PK | 05 | 2020 | grade_2 | 11 | 0 | 1 | 0 | 0 | 0 | 0 | 4 | 8 | 12 | 11 | 0 | 1 | 0 | 0 | 0 | 0 | 4 | 8 | 12 | ||||||||||||||||||||||||||||||||||
1805202 | 1805202 | CO | school | 801980 | 960 | Agate 300 | 80198000020 | 44 | Agate Elementary School | Regular School | No | Elementary | PK | 05 | 2020 | grade_2 | 3 | 0 | 1 | 0 | 0 | 0 | 0 | 4 | 0 | 4 | 3 | 0 | 1 | 0 | 0 | 0 | 0 | 4 | 0 | 4 | ||||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||
1806541 | 1806541 | CO | school | 803870 | 1110 | District 49 | 80387006462 | 2877 | Springs Studio for Academic Excellence | Regular School | No | Other | KG | 12 | 2020 | grade_2 | 6 | 0 | 1 | 0 | 0 | 0 | 0 | 4 | 3 | 7 | 6 | 0 | 1 | 0 | 0 | 0 | 0 | 4 | 3 | 7 | ||||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||
1807062 | 1807062 | CO | school | 804320 | 1350 | East Grand 2 | 80432000594 | 3182 | Fraser Valley Elementary School | Regular School | No | Elementary | PK | 05 | 2020 | grade_2 | 39 | 0 | 1 | 0 | 0 | 0 | 0 | 28 | 12 | 40 | 39 | 0 | 1 | 0 | 0 | 0 | 0 | 28 | 12 | 40 | ||||||||||||||||||||||||||||||||||
1807116 | 1807116 | CO | school | 804470 | 1360 | Gunnison Watershed RE1J | 80447001507 | 5577 | Marble Charter School | Regular School | Yes | Other | KG | 10 | 2020 | grade_2 | 8 | 0 | 1 | 0 | 0 | 0 | 0 | 5 | 4 | 9 | 8 | 0 | 1 | 0 | 0 | 0 | 0 | 5 | 4 | 9 | ||||||||||||||||||||||||||||||||||
1807187 | 1807187 | CO | school | 807050 | 1410 | North Park R-1 | 80705001209 | 6358 | North Park School | Regular School | No | Other | PK | 12 | 2020 | grade_2 | 6 | 0 | 1 | 0 | 0 | 0 | 0 | 3 | 4 | 7 | 6 | 0 | 1 | 0 | 0 | 0 | 0 | 3 | 4 | 7 | ||||||||||||||||||||||||||||||||||
1807346 | 1807346 | CO | school | 804800 | 1420 | Jefferson County R-1 | 80480000704 | 1730 | Coal Creek Canyon K-8 Elementary School | Regular School | No | Elementary | KG | 08 | 2020 | grade_2 | 17 | 0 | 1 | 0 | 0 | 0 | 0 | 7 | 11 | 18 | 17 | 0 | 1 | 0 | 0 | 0 | 0 | 7 | 11 | 18 | ||||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||
1807821 | 1807821 | CO | school | 804800 | 1420 | Jefferson County R-1 | 80480000754 | 5524 | Maple Grove Elementary School | Regular School | No | Elementary | KG | 05 | 2020 | grade_2 | 42 | 0 | 1 | 0 | 1 | 0 | 5 | 26 | 23 | 49 | 42 | 0 | 1 | 0 | 1 | 0 | 5 | 26 | 23 | 49 | ||||||||||||||||||||||||||||||||||
1807829 | 1807829 | CO | school | 804800 | 1420 | Jefferson County R-1 | 80480001316 | 5580 | Marshdale Elementary School | Regular School | No | Elementary | KG | 05 | 2020 | grade_2 | 50 | 0 | 1 | 0 | 0 | 0 | 2 | 28 | 25 | 53 | 50 | 0 | 1 | 0 | 0 | 0 | 2 | 28 | 25 | 53 | ||||||||||||||||||||||||||||||||||
1807961 | 1807961 | CO | school | 804800 | 1420 | Jefferson County R-1 | 80480000768 | 6804 | Parmalee Elementary School | Regular School | No | Elementary | KG | 05 | 2020 | grade_2 | 46 | 0 | 1 | 1 | 2 | 0 | 1 | 33 | 18 | 51 | 46 | 0 | 1 | 1 | 2 | 0 | 1 | 33 | 18 | 51 | ||||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||
1808408 | 1808408 | CO | school | 804800 | 1420 | Jefferson County R-1 | 80480000805 | 9648 | Wilmot Elementary School | Regular School | No | Elementary | PK | 05 | 2020 | grade_2 | 41 | 1 | 1 | 0 | 0 | 0 | 0 | 18 | 25 | 43 | 41 | 1 | 1 | 0 | 0 | 0 | 0 | 18 | 25 | 43 | ||||||||||||||||||||||||||||||||||
1808424 | 1808424 | CO | school | 803510 | 1430 | Eads RE-1 | 80351000458 | 2328 | Eads Elementary School | Regular School | No | Elementary | PK | 05 | 2020 | grade_2 | 8 | 0 | 1 | 0 | 0 | 0 | 1 | 7 | 3 | 10 | 8 | 0 | 1 | 0 | 0 | 0 | 1 | 7 | 3 | 10 | ||||||||||||||||||||||||||||||||||
1808441 | 1808441 | CO | school | 806930 | 1440 | Plainview RE-2 | 80693001198 | 6992 | Plainview Elementary School | Regular School | No | Elementary | PK | 05 | 2020 | grade_2 | 2 | 0 | 1 | 0 | 0 | 0 | 0 | 3 | 0 | 3 | 2 | 0 | 1 | 0 | 0 | 0 | 0 | 3 | 0 | 3 | ||||||||||||||||||||||||||||||||||
1808460 | 1808460 | CO | school | 802260 | 1450 | Arriba-Flagler C-20 | 80226000509 | 2960 | Flagler Public School | Regular School | No | Other | PK | 12 | 2020 | grade_2 | 11 | 0 | 1 | 0 | 0 | 0 | 0 | 5 | 7 | 12 | 11 | 0 | 1 | 0 | 0 | 0 | 0 | 5 | 7 | 12 | ||||||||||||||||||||||||||||||||||
1808475 | 1808475 | CO | school | 806510 | 1460 | Hi-Plains R-23 | 80651001130 | 7746 | Hi-Plains School District R-23 | Regular School | No | Other | PK | 12 | 2020 | grade_2 | 9 | 0 | 1 | 0 | 0 | 0 | 0 | 4 | 6 | 10 | 9 | 0 | 1 | 0 | 0 | 0 | 0 | 4 | 6 | 10 | ||||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||
1808955 | 1808955 | CO | school | 803990 | 1550 | Poudre R-1 | 80399006564 | 7043 | PSD Options School | Regular School | No | Elementary | KG | 08 | 2020 | grade_2 | 14 | 0 | 1 | 0 | 0 | 0 | 1 | 8 | 8 | 16 | 14 | 0 | 1 | 0 | 0 | 0 | 1 | 8 | 8 | 16 | ||||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||
1808997 | 1808997 | CO | school | 803990 | 1550 | Poudre R-1 | 80399006431 | 7198 | PSD Global Academy | Regular School | No | Other | KG | 12 | 2020 | grade_2 | 12 | 0 | 1 | 0 | 0 | 0 | 0 | 7 | 6 | 13 | 12 | 0 | 1 | 0 | 0 | 0 | 0 | 7 | 6 | 13 | ||||||||||||||||||||||||||||||||||
1809435 | 1809435 | CO | school | 802520 | 1750 | Branson Reorganized 82 | 80252000141 | 978 | Branson School | Regular School | No | Other | PK | 12 | 2020 | grade_2 | 1 | 0 | 1 | 0 | 0 | 0 | 0 | 2 | 0 | 2 | 1 | 0 | 1 | 0 | 0 | 0 | 0 | 2 | 0 | 2 | ||||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||
1809573 | 1809573 | CO | school | 806030 | 1870 | Plateau RE-5 | 80603001022 | 6834 | Peetz Elementary School | Regular School | No | Elementary | PK | 06 | 2020 | grade_2 | 14 | 0 | 1 | 0 | 0 | 0 | 0 | 9 | 6 | 15 | 14 | 0 | 1 | 0 | 0 | 0 | 0 | 9 | 6 | 15 | ||||||||||||||||||||||||||||||||||
1809592 | 1809592 | CO | school | 803240 | 1980 | De Beque 49JT | 80324000286 | 2126 | De Beque PK-12 School District 49JT | Regular School | No | Other | PK | 12 | 2020 | grade_2 | 11 | 1 | 1 | 0 | 1 | 0 | 0 | 6 | 8 | 14 | 11 | 1 | 1 | 0 | 1 | 0 | 0 | 6 | 8 | 14 | ||||||||||||||||||||||||||||||||||
1809663 | 1809663 | CO | school | 804350 | 2000 | Mesa County Valley 51 | 80435000599 | 1046 | Broadway Elementary School | Regular School | No | Elementary | PK | 05 | 2020 | grade_2 | 41 | 0 | 1 | 0 | 0 | 0 | 2 | 24 | 20 | 44 | 41 | 0 | 1 | 0 | 0 | 0 | 2 | 24 | 20 | 44 | ||||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||
1809753 | 1809753 | CO | school | 804350 | 2000 | Mesa County Valley 51 | 80435000611 | 3350 | Gateway School | Regular School | No | Other | PK | 12 | 2020 | grade_2 | 3 | 0 | 1 | 0 | 0 | 0 | 0 | 2 | 2 | 4 | 3 | 0 | 1 | 0 | 0 | 0 | 0 | 2 | 2 | 4 | ||||||||||||||||||||||||||||||||||
1809818 | 1809818 | CO | school | 804350 | 2000 | Mesa County Valley 51 | 80435006384 | 5828 | Mesa Valley Community School | Regular School | Yes | Other | KG | 12 | 2020 | grade_2 | 27 | 0 | 1 | 0 | 0 | 0 | 0 | 8 | 20 | 28 | 27 | 0 | 1 | 0 | 0 | 0 | 0 | 8 | 20 | 28 | ||||||||||||||||||||||||||||||||||
1810001 | 1810001 | CO | school | 803090 | 2035 | Montezuma-Cortez RE-1 | 80309001093 | 609 | Battle Rock Charter School | Regular School | Yes | Elementary | KG | 06 | 2020 | grade_2 | 3 | 0 | 1 | 4 | 0 | 0 | 2 | 6 | 4 | 10 | 3 | 0 | 1 | 4 | 0 | 0 | 2 | 6 | 4 | 10 | ||||||||||||||||||||||||||||||||||
1810209 | 1810209 | CO | school | 805850 | 2190 | West End RE-2 | 80585001693 | 6718 | Paradox Valley Charter School | Regular School | Yes | Other | PK | 12 | 2020 | grade_2 | 4 | 0 | 1 | 0 | 0 | 0 | 0 | 2 | 3 | 5 | 4 | 0 | 1 | 0 | 0 | 0 | 0 | 2 | 3 | 5 | ||||||||||||||||||||||||||||||||||
1810530 | 1810530 | CO | school | 802280 | 2640 | Aspen 1 | 80228001703 | 42 | Aspen Community Charter School | Regular School | Yes | Elementary | PK | 08 | 2020 | grade_2 | 13 | 0 | 1 | 0 | 1 | 0 | 0 | 7 | 8 | 15 | 13 | 0 | 1 | 0 | 1 | 0 | 0 | 7 | 8 | 15 | ||||||||||||||||||||||||||||||||||
1811243 | 1811243 | CO | school | 805700 | 2800 | Moffat 2 | 80570000974 | 5958 | Moffat Prek-12 School | Regular School | No | Other | PK | 12 | 2020 | grade_2 | 5 | 1 | 1 | 1 | 0 | 0 | 0 | 4 | 4 | 8 | 5 | 1 | 1 | 1 | 0 | 0 | 0 | 4 | 4 | 8 | ||||||||||||||||||||||||||||||||||
1811281 | 1811281 | CO | school | 806570 | 2820 | Silverton 1 | 80657001136 | 7900 | Silverton Elementary School | Regular School | No | Elementary | PK | 05 | 2020 | grade_2 | 4 | 0 | 1 | 0 | 0 | 0 | 0 | 2 | 3 | 5 | 4 | 0 | 1 | 0 | 0 | 0 | 0 | 2 | 3 | 5 | ||||||||||||||||||||||||||||||||||
1811318 | 1811318 | CO | school | 805880 | 2840 | Norwood R-2J | 80588001012 | 6422 | Norwood Public Schools | Regular School | No | Other | PK | 12 | 2020 | grade_2 | 10 | 0 | 1 | 0 | 0 | 0 | 0 | 5 | 6 | 11 | 10 | 0 | 1 | 0 | 0 | 0 | 0 | 5 | 6 | 11 | ||||||||||||||||||||||||||||||||||
1811497 | 1811497 | CO | school | 802220 | 3040 | Arickaree R-2 | 80222000041 | 304 | Arickaree Elementary School | Regular School | No | Elementary | PK | 05 | 2020 | grade_2 | 1 | 0 | 1 | 0 | 0 | 0 | 0 | 2 | 0 | 2 | 1 | 0 | 1 | 0 | 0 | 0 | 0 | 2 | 0 | 2 | ||||||||||||||||||||||||||||||||||
1811513 | 1811513 | CO | school | 805940 | 3050 | Otis R-3 | 80594001016 | 6582 | Otis Elementary School | Regular School | No | Elementary | PK | 05 | 2020 | grade_2 | 14 | 0 | 1 | 0 | 0 | 0 | 0 | 7 | 8 | 15 | 14 | 0 | 1 | 0 | 0 | 0 | 0 | 7 | 8 | 15 | ||||||||||||||||||||||||||||||||||
1812099 | 1812099 | CO | school | 806720 | 3147 | Prairie RE-11 | 80672001157 | 7154 | Prairie Elementary School | Regular School | No | Elementary | PK | 05 | 2020 | grade_2 | 16 | 0 | 1 | 0 | 0 | 0 | 0 | 9 | 8 | 17 | 16 | 0 | 1 | 0 | 0 | 0 | 0 | 9 | 8 | 17 | ||||||||||||||||||||||||||||||||||
1812118 | 1812118 | CO | school | 804440 | 3148 | Pawnee RE-12 | 80444000653 | 6812 | Pawnee School PK-12 | Regular School | No | Other | PK | 12 | 2020 | grade_2 | 3 | 0 | 1 | 0 | 0 | 0 | 0 | 2 | 2 | 4 | 3 | 0 | 1 | 0 | 0 | 0 | 0 | 2 | 2 | 4 | ||||||||||||||||||||||||||||||||||
1812414 | 1812414 | CO | school | 800020 | 8001 | Charter School Institute | 80002006701 | 5423 | Mountain Village Montessori Charter School | Regular School | Yes | Elementary | PK | 05 | 2020 | grade_2 | 19 | 0 | 1 | 0 | 0 | 0 | 0 | 9 | 11 | 20 | 19 | 0 | 1 | 0 | 0 | 0 | 0 | 9 | 11 | 20 | ||||||||||||||||||||||||||||||||||
1812437 | 1812437 | CO | school | 800020 | 8001 | Charter School Institute | 80002006706 | 5845 | Monument View Montessori Charter School | Regular School | Yes | Elementary | PK | 05 | 2020 | grade_2 | 6 | 0 | 1 | 0 | 0 | 0 | 0 | 3 | 4 | 7 | 6 | 0 | 1 | 0 | 0 | 0 | 0 | 3 | 4 | 7 | ||||||||||||||||||||||||||||||||||
1799538 | 1799538 | CO | school | 806900 | 20 | Adams 12 Five Star Schools | 80690001668 | 1937 | Coyote Ridge Elementary School | Regular School | No | Elementary | KG | 05 | 2020 | grade_2 | 52 | 0 | 10 | 0 | 8 | 1 | 2 | 37 | 36 | 73 | 52 | 0 | 10 | 0 | 8 | 1 | 2 | 37 | 36 | 73 | ||||||||||||||||||||||||||||||||||
1799765 | 1799765 | CO | school | 806900 | 20 | Adams 12 Five Star Schools | 80690006468 | 8275 | STEM Lab | Regular School | No | Elementary | PK | 08 | 2020 | grade_2 | 51 | 1 | 10 | 0 | 7 | 0 | 3 | 39 | 33 | 72 | 51 | 1 | 10 | 0 | 7 | 0 | 3 | 39 | 33 | 72 | ||||||||||||||||||||||||||||||||||
1800399 | 1800399 | CO | school | 802910 | 130 | Cherry Creek 5 | 80291001710 | 16 | Fox Hollow Elementary School | Regular School | No | Elementary | PK | 05 | 2020 | grade_2 | 54 | 10 | 10 | 1 | 15 | 0 | 7 | 49 | 48 | 97 | 54 | 10 | 10 | 1 | 15 | 0 | 7 | 49 | 48 | 97 | ||||||||||||||||||||||||||||||||||
1800521 | 1800521 | CO | school | 802910 | 130 | Cherry Creek 5 | 80291001273 | 1572 | High Plains Elementary School | Regular School | No | Elementary | PK | 05 | 2020 | grade_2 | 61 | 4 | 10 | 0 | 13 | 0 | 4 | 44 | 48 | 92 | 61 | 4 | 10 | 0 | 13 | 0 | 4 | 44 | 48 | 92 | ||||||||||||||||||||||||||||||||||
1800542 | 1800542 | CO | school | 802910 | 130 | Cherry Creek 5 | 80291000188 | 1916 | Cottonwood Creek Elementary School | Regular School | No | Elementary | PK | 05 | 2020 | grade_2 | 73 | 3 | 10 | 0 | 14 | 1 | 6 | 56 | 51 | 107 | 73 | 3 | 10 | 0 | 14 | 1 | 6 | 56 | 51 | 107 | ||||||||||||||||||||||||||||||||||
1800698 | 1800698 | CO | school | 802910 | 130 | Cherry Creek 5 | 80291006607 | 6225 | Mountain Vista Elementary School | Regular School | No | Elementary | PK | 05 | 2020 | grade_2 | 66 | 16 | 10 | 2 | 12 | 0 | 8 | 61 | 53 | 114 | 66 | 16 | 10 | 2 | 12 | 0 | 8 | 61 | 53 | 114 | ||||||||||||||||||||||||||||||||||
1801346 | 1801346 | CO | school | 802340 | 180 | Adams-Arapahoe 28J | 80234001674 | 7232 | Aurora Quest K-8 | Regular School | No | Elementary | KG | 08 | 2020 | grade_2 | 23 | 10 | 10 | 0 | 4 | 0 | 6 | 27 | 26 | 53 | 23 | 10 | 10 | 0 | 4 | 0 | 6 | 27 | 26 | 53 | ||||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||
1801826 | 1801826 | CO | school | 805370 | 470 | St Vrain Valley RE1J | 80537000899 | 2758 | Erie Elementary School | Regular School | No | Elementary | PK | 05 | 2020 | grade_2 | 28 | 0 | 10 | 0 | 1 | 0 | 1 | 26 | 14 | 40 | 28 | 0 | 10 | 0 | 1 | 0 | 1 | 26 | 14 | 40 | ||||||||||||||||||||||||||||||||||
1802360 | 1802360 | CO | school | 802490 | 480 | Boulder Valley Re 2 | 80249000128 | 5606 | Creekside Elementary School at Martin Park | Regular School | No | Elementary | PK | 05 | 2020 | grade_2 | 37 | 0 | 10 | 0 | 5 | 0 | 5 | 30 | 27 | 57 | 37 | 0 | 10 | 0 | 5 | 0 | 5 | 30 | 27 | 57 | ||||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||
1803449 | 1803449 | CO | school | 803360 | 880 | Denver County 1 | 80336001835 | 3987 | Highline Academy Southeast | Regular School | Yes | Elementary | KG | 08 | 2020 | grade_2 | 30 | 8 | 10 | 0 | 0 | 0 | 3 | 21 | 30 | 51 | 30 | 8 | 10 | 0 | 0 | 0 | 3 | 21 | 30 | 51 | ||||||||||||||||||||||||||||||||||
1804173 | 1804173 | CO | school | 803360 | 880 | Denver County 1 | 80336000426 | 9548 | Whittier ECE-8 School | Regular School | No | Elementary | PK | 08 | 2020 | grade_2 | 1 | 12 | 10 | 0 | 1 | 0 | 1 | 8 | 17 | 25 | 1 | 12 | 10 | 0 | 1 | 0 | 1 | 8 | 17 | 25 | ||||||||||||||||||||||||||||||||||
1804247 | 1804247 | CO | school | 803450 | 900 | Douglas County Re 1 | 80345000492 | 11 | Academy Charter School | Regular School | Yes | Elementary | PK | 08 | 2020 | grade_2 | 72 | 2 | 10 | 1 | 4 | 0 | 6 | 42 | 53 | 95 | 72 | 2 | 10 | 1 | 4 | 0 | 6 | 42 | 53 | 95 |
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]);