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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1746041 | 1746041 | CO | school | 804620 | 1380 | Hinsdale County RE 1 | 80462001969 | 4899 | Lake City Community School | Regular School | No | Other | PK | 12 | 2021 | grade_2 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 1 | ||||||||||||||||||||||||||||||||||
1748304 | 1748304 | CO | school | 804980 | 1760 | Kim Reorganized 88 | 80498000822 | 4690 | Kim Elementary School | Regular School | No | Elementary | PK | 05 | 2021 | grade_2 | 2 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 2 | 2 | 2 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 2 | 2 | ||||||||||||||||||||||||||||||||||
1749779 | 1749779 | CO | school | 806150 | 2700 | Pueblo County 70 | 80615006496 | 5990 | 70 Online | Alternative School | No | Other | KG | 12 | 2021 | grade_2 | 1 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 2 | 2 | 1 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 2 | 2 | ||||||||||||||||||||||||||||||||||
1741288 | 1741288 | CO | school | 802490 | 480 | Boulder Valley Re 2 | 80249000119 | 4386 | Jamestown Elementary School | Regular School | No | Elementary | KG | 05 | 2021 | grade_2 | 3 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 2 | 3 | 3 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 2 | 3 | ||||||||||||||||||||||||||||||||||
1746710 | 1746710 | CO | school | 804800 | 1420 | Jefferson County R-1 | 80480001606 | 5415 | Rocky Mountain Deaf School | Special Education School | Yes | Other | PK | 12 | 2021 | grade_2 | 2 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 1 | 2 | 2 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 1 | 2 | ||||||||||||||||||||||||||||||||||
1746757 | 1746757 | CO | school | 804800 | 1420 | Jefferson County R-1 | 80480000756 | 5892 | Miller Special Education | Special Education School | No | Other | PK | 12 | 2021 | grade_2 | 5 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 4 | 5 | 5 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 4 | 5 | ||||||||||||||||||||||||||||||||||
1747359 | 1747359 | CO | school | 806510 | 1460 | Hi-Plains R-23 | 80651001130 | 7746 | Hi-Plains School District R-23 | Regular School | No | Other | PK | 12 | 2021 | grade_2 | 3 | 0 | 3 | 0 | 0 | 0 | 0 | 1 | 5 | 6 | 3 | 0 | 3 | 0 | 0 | 0 | 0 | 1 | 5 | 6 | ||||||||||||||||||||||||||||||||||
1747828 | 1747828 | CO | school | 803990 | 1550 | Poudre R-1 | 80399006564 | 7043 | PSD Options School | Regular School | No | Elementary | KG | 08 | 2021 | grade_2 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | ||||||||||||||||||||||||||||||||||
1748294 | 1748294 | CO | school | 802520 | 1750 | Branson Reorganized 82 | 80252000141 | 978 | Branson School | Regular School | No | Other | PK | 12 | 2021 | grade_2 | 5 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 4 | 5 | 5 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 4 | 5 | ||||||||||||||||||||||||||||||||||
1748350 | 1748350 | CO | school | 804890 | 1810 | Karval RE-23 | 80489000814 | 4502 | Karval Elementary School | Regular School | No | Elementary | PK | 06 | 2021 | grade_2 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | ||||||||||||||||||||||||||||||||||
1748610 | 1748610 | CO | school | 804350 | 2000 | Mesa County Valley 51 | 80435000611 | 3350 | Gateway School | Regular School | No | Other | PK | 12 | 2021 | grade_2 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | ||||||||||||||||||||||||||||||||||
1748833 | 1748833 | CO | school | 805730 | 2020 | Moffat County RE: No 1 | 80573000980 | 5656 | Maybell School | Regular School | No | Elementary | KG | 06 | 2021 | grade_2 | 2 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 1 | 2 | 2 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 1 | 2 | ||||||||||||||||||||||||||||||||||
1750101 | 1750101 | CO | school | 805700 | 2800 | Moffat 2 | 80570001511 | 2018 | Crestone Charter School | Regular School | Yes | Other | KG | 12 | 2021 | grade_2 | 6 | 0 | 1 | 0 | 1 | 0 | 0 | 1 | 7 | 8 | 6 | 0 | 1 | 0 | 1 | 0 | 0 | 1 | 7 | 8 | ||||||||||||||||||||||||||||||||||
1739259 | 1739259 | CO | school | 806420 | 110 | Sangre De Cristo Re-22J | 80642001115 | 7626 | Sangre de Cristo Elementary School | Regular School | No | Elementary | PK | 05 | 2021 | grade_2 | 9 | 0 | 8 | 0 | 0 | 0 | 0 | 10 | 7 | 17 | 9 | 0 | 8 | 0 | 0 | 0 | 0 | 10 | 7 | 17 | ||||||||||||||||||||||||||||||||||
1740555 | 1740555 | CO | school | 807110 | 230 | Walsh RE-1 | 80711001215 | 9222 | Walsh Elementary School | Regular School | No | Elementary | PK | 06 | 2021 | grade_2 | 12 | 1 | 2 | 1 | 0 | 0 | 0 | 10 | 6 | 16 | 12 | 1 | 2 | 1 | 0 | 0 | 0 | 10 | 6 | 16 | ||||||||||||||||||||||||||||||||||
1740760 | 1740760 | CO | school | 805370 | 470 | St Vrain Valley RE1J | 80537001887 | 1284 | Carbon Valley Academy | Regular School | Yes | Elementary | PK | 08 | 2021 | grade_2 | 17 | 0 | 11 | 0 | 0 | 0 | 0 | 10 | 18 | 28 | 17 | 0 | 11 | 0 | 0 | 0 | 0 | 10 | 18 | 28 | ||||||||||||||||||||||||||||||||||
1741008 | 1741008 | CO | school | 805370 | 470 | St Vrain Valley RE1J | 80537006430 | 7565 | St. Vrain Community Montessori School | Regular School | Yes | Elementary | PK | 08 | 2021 | grade_2 | 21 | 0 | 2 | 0 | 0 | 0 | 2 | 10 | 15 | 25 | 21 | 0 | 2 | 0 | 0 | 0 | 2 | 10 | 15 | 25 | ||||||||||||||||||||||||||||||||||
1741535 | 1741535 | CO | school | 800001 | 520 | Cheyenne County Re-5 | 80000100214 | 1608 | Cheyenne Wells Elementary School | Regular School | No | Elementary | PK | 06 | 2021 | grade_2 | 11 | 0 | 0 | 0 | 0 | 0 | 0 | 10 | 1 | 11 | 11 | 0 | 0 | 0 | 0 | 0 | 0 | 10 | 1 | 11 | ||||||||||||||||||||||||||||||||||
1741595 | 1741595 | CO | school | 805100 | 550 | North Conejos RE-1J | 80510000844 | 4836 | La Jara Elementary School | Regular School | No | Elementary | PK | 05 | 2021 | grade_2 | 12 | 0 | 14 | 0 | 0 | 1 | 0 | 10 | 17 | 27 | 12 | 0 | 14 | 0 | 0 | 1 | 0 | 10 | 17 | 27 | ||||||||||||||||||||||||||||||||||
1741725 | 1741725 | CO | school | 803330 | 870 | Delta County 50(J) | 80333000295 | 1952 | North Fork Montessori @ Crawford | Regular School | No | Elementary | PK | 06 | 2021 | grade_2 | 12 | 0 | 1 | 0 | 0 | 0 | 0 | 10 | 3 | 13 | 12 | 0 | 1 | 0 | 0 | 0 | 0 | 10 | 3 | 13 | ||||||||||||||||||||||||||||||||||
1742420 | 1742420 | CO | school | 803360 | 880 | Denver County 1 | 80336000362 | 3778 | International Academy of Denver at Harrington | Regular School | No | Elementary | PK | 05 | 2021 | grade_2 | 0 | 6 | 17 | 1 | 0 | 0 | 0 | 10 | 14 | 24 | 0 | 6 | 17 | 1 | 0 | 0 | 0 | 10 | 14 | 24 | ||||||||||||||||||||||||||||||||||
1742644 | 1742644 | CO | school | 803360 | 880 | Denver County 1 | 80336006445 | 5608 | Mathematics and Science Leadership Academy | Regular School | No | Elementary | KG | 05 | 2021 | grade_2 | 1 | 3 | 25 | 0 | 1 | 0 | 2 | 10 | 22 | 32 | 1 | 3 | 25 | 0 | 1 | 0 | 2 | 10 | 22 | 32 | ||||||||||||||||||||||||||||||||||
1742881 | 1742881 | CO | school | 803360 | 880 | Denver County 1 | 80336006641 | 7243 | Reach Charter School | Regular School | Yes | Elementary | PK | 05 | 2021 | grade_2 | 10 | 0 | 2 | 0 | 0 | 0 | 3 | 10 | 5 | 15 | 10 | 0 | 2 | 0 | 0 | 0 | 3 | 10 | 5 | 15 | ||||||||||||||||||||||||||||||||||
1743194 | 1743194 | CO | school | 803360 | 880 | Denver County 1 | 80336001637 | 9739 | Wyatt Academy | Regular School | Yes | Elementary | KG | 05 | 2021 | grade_2 | 3 | 9 | 13 | 0 | 0 | 0 | 1 | 10 | 16 | 26 | 3 | 9 | 13 | 0 | 0 | 0 | 1 | 10 | 16 | 26 | ||||||||||||||||||||||||||||||||||
1743568 | 1743568 | CO | school | 803450 | 900 | Douglas County Re 1 | 80345000441 | 4980 | Larkspur Elementary School | Regular School | No | Elementary | KG | 06 | 2021 | grade_2 | 14 | 1 | 3 | 0 | 0 | 0 | 3 | 10 | 11 | 21 | 14 | 1 | 3 | 0 | 0 | 0 | 3 | 10 | 11 | 21 | ||||||||||||||||||||||||||||||||||
1744102 | 1744102 | CO | school | 803690 | 950 | Elbert 200 | 80369000480 | 2570 | Elbert Elementary School | Regular School | No | Elementary | PK | 05 | 2021 | grade_2 | 13 | 0 | 2 | 0 | 0 | 0 | 1 | 10 | 6 | 16 | 13 | 0 | 2 | 0 | 0 | 0 | 1 | 10 | 6 | 16 | ||||||||||||||||||||||||||||||||||
1745417 | 1745417 | CO | school | 803870 | 1110 | District 49 | 80387006794 | 467 | Mountain View Academy | Regular School | Yes | Elementary | KG | 08 | 2021 | grade_2 | 10 | 0 | 4 | 0 | 1 | 0 | 4 | 10 | 9 | 19 | 10 | 0 | 4 | 0 | 1 | 0 | 4 | 10 | 9 | 19 | ||||||||||||||||||||||||||||||||||
1746436 | 1746436 | CO | school | 804800 | 1420 | Jefferson County R-1 | 80480000722 | 2946 | Fitzmorris Elementary School | Regular School | No | Elementary | PK | 05 | 2021 | grade_2 | 21 | 0 | 7 | 2 | 0 | 1 | 0 | 10 | 21 | 31 | 21 | 0 | 7 | 2 | 0 | 1 | 0 | 10 | 21 | 31 | ||||||||||||||||||||||||||||||||||
1747131 | 1747131 | CO | school | 804800 | 1420 | Jefferson County R-1 | 80480006466 | 8793 | Two Roads Charter School | Regular School | Yes | Other | PK | 12 | 2021 | grade_2 | 20 | 0 | 3 | 0 | 0 | 0 | 1 | 10 | 14 | 24 | 20 | 0 | 3 | 0 | 0 | 0 | 1 | 10 | 14 | 24 | ||||||||||||||||||||||||||||||||||
1747501 | 1747501 | CO | school | 803480 | 1520 | Durango 9-R | 80348006712 | 4384 | The Juniper School | Regular School | Yes | Elementary | KG | 05 | 2021 | grade_2 | 18 | 0 | 1 | 0 | 0 | 0 | 1 | 10 | 10 | 20 | 18 | 0 | 1 | 0 | 0 | 0 | 1 | 10 | 10 | 20 | ||||||||||||||||||||||||||||||||||
1748466 | 1748466 | CO | school | 803030 | 1990 | Plateau Valley 50 | 80303000219 | 7024 | Plateau Valley Elementary School | Regular School | No | Elementary | PK | 06 | 2021 | grade_2 | 16 | 1 | 1 | 0 | 0 | 0 | 0 | 10 | 8 | 18 | 16 | 1 | 1 | 0 | 0 | 0 | 0 | 10 | 8 | 18 | ||||||||||||||||||||||||||||||||||
1748898 | 1748898 | CO | school | 803090 | 2035 | Montezuma-Cortez RE-1 | 80309000838 | 5436 | Manaugh Elementary School | Regular School | No | Elementary | KG | 05 | 2021 | grade_2 | 7 | 0 | 6 | 16 | 0 | 0 | 2 | 10 | 21 | 31 | 7 | 0 | 6 | 16 | 0 | 0 | 2 | 10 | 21 | 31 | ||||||||||||||||||||||||||||||||||
1749290 | 1749290 | CO | school | 806210 | 2590 | Ridgway R-2 | 80621001089 | 7342 | Ridgway Elementary School | Regular School | No | Elementary | PK | 05 | 2021 | grade_2 | 18 | 0 | 3 | 0 | 0 | 0 | 0 | 10 | 11 | 21 | 18 | 0 | 3 | 0 | 0 | 0 | 0 | 10 | 11 | 21 | ||||||||||||||||||||||||||||||||||
1751490 | 1751490 | CO | school | 800004 | 9130 | Expeditionary BOCES | 80000400709 | 2840 | Rocky Mountain School of Expeditionary Learning | Regular School | No | Other | KG | 12 | 2021 | grade_2 | 22 | 0 | 2 | 0 | 0 | 0 | 2 | 10 | 16 | 26 | 22 | 0 | 2 | 0 | 0 | 0 | 2 | 10 | 16 | 26 | ||||||||||||||||||||||||||||||||||
1741250 | 1741250 | CO | school | 802490 | 480 | Boulder Valley Re 2 | 80249000115 | 2970 | Flatirons Elementary School | Regular School | No | Elementary | KG | 05 | 2021 | grade_2 | 19 | 0 | 1 | 0 | 0 | 0 | 1 | 11 | 10 | 21 | 19 | 0 | 1 | 0 | 0 | 0 | 1 | 11 | 10 | 21 | ||||||||||||||||||||||||||||||||||
1741577 | 1741577 | CO | school | 803000 | 540 | Clear Creek RE-1 | 80300001332 | 4700 | King-Murphy Elementary School | Regular School | No | Elementary | PK | 06 | 2021 | grade_2 | 21 | 0 | 1 | 0 | 0 | 0 | 0 | 11 | 11 | 22 | 21 | 0 | 1 | 0 | 0 | 0 | 0 | 11 | 11 | 22 | ||||||||||||||||||||||||||||||||||
1741774 | 1741774 | CO | school | 803330 | 870 | Delta County 50(J) | 80333000299 | 4124 | Hotchkiss Elementary School | Regular School | No | Elementary | PK | 08 | 2021 | grade_2 | 14 | 0 | 4 | 0 | 0 | 0 | 0 | 11 | 7 | 18 | 14 | 0 | 4 | 0 | 0 | 0 | 0 | 11 | 7 | 18 | ||||||||||||||||||||||||||||||||||
1742355 | 1742355 | CO | school | 803360 | 880 | Denver County 1 | 80336001738 | 3605 | Grant Ranch ECE-8 School | Regular School | No | Elementary | PK | 08 | 2021 | grade_2 | 9 | 2 | 12 | 0 | 1 | 0 | 1 | 11 | 14 | 25 | 9 | 2 | 12 | 0 | 1 | 0 | 1 | 11 | 14 | 25 | ||||||||||||||||||||||||||||||||||
1743143 | 1743143 | CO | school | 803360 | 880 | Denver County 1 | 80336000426 | 9548 | Whittier ECE-8 School | Regular School | No | Elementary | PK | 08 | 2021 | grade_2 | 1 | 11 | 8 | 0 | 0 | 0 | 1 | 11 | 10 | 21 | 1 | 11 | 8 | 0 | 0 | 0 | 1 | 11 | 10 | 21 | ||||||||||||||||||||||||||||||||||
1744000 | 1744000 | CO | school | 803540 | 910 | Eagle County RE 50 | 80354000468 | 7296 | Red Sandstone Elementary School | Regular School | No | Elementary | PK | 05 | 2021 | grade_2 | 16 | 1 | 8 | 0 | 0 | 0 | 0 | 11 | 14 | 25 | 16 | 1 | 8 | 0 | 0 | 0 | 0 | 11 | 14 | 25 | ||||||||||||||||||||||||||||||||||
1744842 | 1744842 | CO | school | 803060 | 1010 | Colorado Springs 11 | 80306000267 | 8466 | Taylor Elementary School | Regular School | No | Elementary | PK | 05 | 2021 | grade_2 | 10 | 0 | 8 | 0 | 0 | 0 | 2 | 11 | 9 | 20 | 10 | 0 | 8 | 0 | 0 | 0 | 2 | 11 | 9 | 20 | ||||||||||||||||||||||||||||||||||
1745384 | 1745384 | CO | school | 803870 | 1110 | District 49 | 80387006725 | 101 | ALLIES | Alternative School | No | Elementary | 02 | 05 | 2021 | grade_2 | 16 | 0 | 1 | 0 | 0 | 0 | 1 | 11 | 7 | 18 | 16 | 0 | 1 | 0 | 0 | 0 | 1 | 11 | 7 | 18 | ||||||||||||||||||||||||||||||||||
1746193 | 1746193 | CO | school | 804800 | 1420 | Jefferson County R-1 | 80480000699 | 724 | Belmar School of Integrated Arts | Regular School | No | Elementary | KG | 05 | 2021 | grade_2 | 12 | 3 | 13 | 0 | 1 | 0 | 1 | 11 | 19 | 30 | 12 | 3 | 13 | 0 | 1 | 0 | 1 | 11 | 19 | 30 | ||||||||||||||||||||||||||||||||||
1748676 | 1748676 | CO | school | 804350 | 2000 | Mesa County Valley 51 | 80435006384 | 5828 | Mesa Valley Community School | Regular School | Yes | Other | KG | 12 | 2021 | grade_2 | 22 | 0 | 3 | 0 | 0 | 1 | 3 | 11 | 18 | 29 | 22 | 0 | 3 | 0 | 0 | 1 | 3 | 11 | 18 | 29 | ||||||||||||||||||||||||||||||||||
1748872 | 1748872 | CO | school | 803090 | 2035 | Montezuma-Cortez RE-1 | 80309006622 | 2036 | Children's Kiva Montessori School | Regular School | Yes | Elementary | KG | 08 | 2021 | grade_2 | 9 | 0 | 3 | 7 | 0 | 0 | 1 | 11 | 9 | 20 | 9 | 0 | 3 | 7 | 0 | 0 | 1 | 11 | 9 | 20 | ||||||||||||||||||||||||||||||||||
1749382 | 1749382 | CO | school | 804560 | 2630 | Haxtun RE-2J | 80456000673 | 3846 | Haxtun Elementary School | Regular School | No | Elementary | PK | 08 | 2021 | grade_2 | 17 | 0 | 1 | 0 | 0 | 0 | 0 | 11 | 7 | 18 | 17 | 0 | 1 | 0 | 0 | 0 | 0 | 11 | 7 | 18 | ||||||||||||||||||||||||||||||||||
1749757 | 1749757 | CO | school | 806150 | 2700 | Pueblo County 70 | 80615001071 | 852 | Beulah Elementary School | Regular School | No | Elementary | KG | 05 | 2021 | grade_2 | 14 | 0 | 2 | 0 | 0 | 0 | 1 | 11 | 6 | 17 | 14 | 0 | 2 | 0 | 0 | 0 | 1 | 11 | 6 | 17 | ||||||||||||||||||||||||||||||||||
1750211 | 1750211 | CO | school | 804860 | 2862 | Julesburg Re-1 | 80486000811 | 4488 | Julesburg Elementary School | Regular School | No | Elementary | PK | 06 | 2021 | grade_2 | 11 | 0 | 7 | 0 | 0 | 0 | 0 | 11 | 7 | 18 | 11 | 0 | 7 | 0 | 0 | 0 | 0 | 11 | 7 | 18 | ||||||||||||||||||||||||||||||||||
1750250 | 1750250 | CO | school | 806810 | 3000 | Summit RE-1 | 80681001166 | 8372 | Breckenridge Elementary School | Regular School | No | Elementary | KG | 05 | 2021 | grade_2 | 25 | 0 | 1 | 0 | 0 | 0 | 0 | 11 | 15 | 26 | 25 | 0 | 1 | 0 | 0 | 0 | 0 | 11 | 15 | 26 | ||||||||||||||||||||||||||||||||||
1750354 | 1750354 | CO | school | 802040 | 3030 | Akron R-1 | 80204000024 | 86 | Akron Elementary School | Regular School | No | Elementary | PK | 08 | 2021 | grade_2 | 18 | 0 | 4 | 0 | 0 | 0 | 2 | 11 | 13 | 24 | 18 | 0 | 4 | 0 | 0 | 0 | 2 | 11 | 13 | 24 | ||||||||||||||||||||||||||||||||||
1750759 | 1750759 | CO | school | 804410 | 3120 | Greeley 6 | 80441006719 | 3173 | Fred Tjardes School of Innovation | Regular School | No | Elementary | KG | 08 | 2021 | grade_2 | 9 | 0 | 5 | 0 | 0 | 0 | 0 | 11 | 3 | 14 | 9 | 0 | 5 | 0 | 0 | 0 | 0 | 11 | 3 | 14 | ||||||||||||||||||||||||||||||||||
1738318 | 1738318 | CO | school | 805550 | 10 | Mapleton 1 | 80555002004 | 505 | Achieve Academy | Regular School | No | Elementary | PK | 08 | 2021 | grade_2 | 3 | 1 | 24 | 0 | 2 | 0 | 0 | 12 | 18 | 30 | 3 | 1 | 24 | 0 | 2 | 0 | 0 | 12 | 18 | 30 | ||||||||||||||||||||||||||||||||||
1742028 | 1742028 | CO | school | 803360 | 880 | Denver County 1 | 80336000329 | 1816 | Columbian Elementary School | Regular School | No | Elementary | PK | 05 | 2021 | grade_2 | 4 | 1 | 21 | 0 | 0 | 0 | 0 | 12 | 14 | 26 | 4 | 1 | 21 | 0 | 0 | 0 | 0 | 12 | 14 | 26 | ||||||||||||||||||||||||||||||||||
1744133 | 1744133 | CO | school | 802730 | 970 | Calhan RJ-1 | 80273000167 | 1210 | Calhan Elementary School | Regular School | No | Elementary | PK | 05 | 2021 | grade_2 | 17 | 2 | 1 | 2 | 0 | 0 | 0 | 12 | 10 | 22 | 17 | 2 | 1 | 2 | 0 | 0 | 0 | 12 | 10 | 22 | ||||||||||||||||||||||||||||||||||
1744644 | 1744644 | CO | school | 803060 | 1010 | Colorado Springs 11 | 80306001318 | 3470 | Globe Charter School | Regular School | Yes | Elementary | KG | 06 | 2021 | grade_2 | 16 | 2 | 1 | 0 | 0 | 0 | 4 | 12 | 11 | 23 | 16 | 2 | 1 | 0 | 0 | 0 | 4 | 12 | 11 | 23 | ||||||||||||||||||||||||||||||||||
1746082 | 1746082 | CO | school | 805160 | 1400 | La Veta Re-2 | 80516000853 | 4860 | La Veta Elementary School | Regular School | No | Elementary | PK | 05 | 2021 | grade_2 | 16 | 0 | 3 | 0 | 0 | 0 | 0 | 12 | 7 | 19 | 16 | 0 | 3 | 0 | 0 | 0 | 0 | 12 | 7 | 19 | ||||||||||||||||||||||||||||||||||
1747107 | 1747107 | CO | school | 804800 | 1420 | Jefferson County R-1 | 80480000788 | 8300 | Stott Elementary School | Regular School | No | Elementary | PK | 05 | 2021 | grade_2 | 26 | 0 | 4 | 0 | 0 | 0 | 2 | 12 | 20 | 32 | 26 | 0 | 4 | 0 | 0 | 0 | 2 | 12 | 20 | 32 | ||||||||||||||||||||||||||||||||||
1747540 | 1747540 | CO | school | 803480 | 1520 | Durango 9-R | 80348000457 | 8388 | Sunnyside Elementary School | Regular School | No | Elementary | PK | 05 | 2021 | grade_2 | 14 | 0 | 7 | 1 | 0 | 0 | 0 | 12 | 10 | 22 | 14 | 0 | 7 | 1 | 0 | 0 | 0 | 12 | 10 | 22 | ||||||||||||||||||||||||||||||||||
1748417 | 1748417 | CO | school | 805640 | 1860 | Buffalo RE-4J | 80564000969 | 5802 | Merino Elementary School | Regular School | No | Elementary | KG | 06 | 2021 | grade_2 | 22 | 0 | 3 | 0 | 0 | 0 | 0 | 12 | 13 | 25 | 22 | 0 | 3 | 0 | 0 | 0 | 0 | 12 | 13 | 25 | ||||||||||||||||||||||||||||||||||
1748590 | 1748590 | CO | school | 804350 | 2000 | Mesa County Valley 51 | 80435001552 | 2724 | New Emerson School at Columbus | Regular School | No | Elementary | KG | 05 | 2021 | grade_2 | 20 | 0 | 0 | 0 | 1 | 0 | 0 | 12 | 9 | 21 | 20 | 0 | 0 | 0 | 1 | 0 | 0 | 12 | 9 | 21 | ||||||||||||||||||||||||||||||||||
1749227 | 1749227 | CO | school | 804110 | 2540 | Fowler R-4J | 80411001981 | 56 | Fowler Elementary School | Regular School | No | Elementary | KG | 06 | 2021 | grade_2 | 18 | 0 | 6 | 0 | 0 | 0 | 0 | 12 | 12 | 24 | 18 | 0 | 6 | 0 | 0 | 0 | 0 | 12 | 12 | 24 | ||||||||||||||||||||||||||||||||||
1749273 | 1749273 | CO | school | 805970 | 2580 | Ouray R-1 | 80597001018 | 6596 | Ouray Elementary School | Regular School | No | Elementary | PK | 06 | 2021 | grade_2 | 9 | 0 | 3 | 0 | 1 | 0 | 1 | 12 | 2 | 14 | 9 | 0 | 3 | 0 | 1 | 0 | 1 | 12 | 2 | 14 | ||||||||||||||||||||||||||||||||||
1749484 | 1749484 | CO | school | 807320 | 2680 | Wiley RE-13 Jt | 80732001260 | 9604 | Wiley Elementary School | Regular School | No | Elementary | PK | 05 | 2021 | grade_2 | 10 | 0 | 10 | 0 | 0 | 0 | 2 | 12 | 10 | 22 | 10 | 0 | 10 | 0 | 0 | 0 | 2 | 12 | 10 | 22 | ||||||||||||||||||||||||||||||||||
1751148 | 1751148 | CO | school | 800020 | 8001 | Charter School Institute | 80002001998 | 657 | Academy of Arts and Knowledge Elementary | Regular School | Yes | Elementary | KG | 05 | 2021 | grade_2 | 18 | 2 | 3 | 0 | 1 | 0 | 3 | 12 | 15 | 27 | 18 | 2 | 3 | 0 | 1 | 0 | 3 | 12 | 15 | 27 | ||||||||||||||||||||||||||||||||||
1739104 | 1739104 | CO | school | 807230 | 70 | Westminster Public Schools | 80723001238 | 3792 | Harris Park Elementary School | Regular School | No | Elementary | PK | 05 | 2021 | grade_2 | 9 | 1 | 22 | 0 | 2 | 0 | 0 | 13 | 21 | 34 | 9 | 1 | 22 | 0 | 2 | 0 | 0 | 13 | 21 | 34 | ||||||||||||||||||||||||||||||||||
1739825 | 1739825 | CO | school | 805310 | 140 | Littleton 6 | 80531000875 | 2382 | East Elementary School | Regular School | No | Elementary | KG | 05 | 2021 | grade_2 | 15 | 0 | 12 | 1 | 2 | 0 | 0 | 13 | 17 | 30 | 15 | 0 | 12 | 1 | 2 | 0 | 0 | 13 | 17 | 30 | ||||||||||||||||||||||||||||||||||
1740370 | 1740370 | CO | school | 802340 | 180 | Adams-Arapahoe 28J | 80234006732 | 9053 | Vega Collegiate Academy | Regular School | Yes | Elementary | KG | 08 | 2021 | grade_2 | 2 | 1 | 19 | 0 | 14 | 0 | 1 | 13 | 24 | 37 | 2 | 1 | 19 | 0 | 14 | 0 | 1 | 13 | 24 | 37 | ||||||||||||||||||||||||||||||||||
1741813 | 1741813 | CO | school | 803330 | 870 | Delta County 50(J) | 80333001337 | 6700 | Paonia Elementary School | Regular School | No | Elementary | PK | 06 | 2021 | grade_2 | 20 | 0 | 5 | 0 | 0 | 0 | 0 | 13 | 12 | 25 | 20 | 0 | 5 | 0 | 0 | 0 | 0 | 13 | 12 | 25 | ||||||||||||||||||||||||||||||||||
1742330 | 1742330 | CO | school | 803360 | 880 | Denver County 1 | 80336000354 | 3478 | Godsman Elementary School | Regular School | No | Elementary | PK | 05 | 2021 | grade_2 | 4 | 1 | 26 | 0 | 1 | 0 | 1 | 13 | 20 | 33 | 4 | 1 | 26 | 0 | 1 | 0 | 1 | 13 | 20 | 33 | ||||||||||||||||||||||||||||||||||
1742388 | 1742388 | CO | school | 803360 | 880 | Denver County 1 | 80336006477 | 3655 | Center for Talent Development at Greenlee | Regular School | No | Elementary | PK | 05 | 2021 | grade_2 | 5 | 12 | 13 | 0 | 0 | 0 | 1 | 13 | 18 | 31 | 5 | 12 | 13 | 0 | 0 | 0 | 1 | 13 | 18 | 31 | ||||||||||||||||||||||||||||||||||
1742581 | 1742581 | CO | school | 803360 | 880 | Denver County 1 | 80336006442 | 4795 | Kunsmiller Creative Arts Academy | Regular School | No | Other | KG | 12 | 2021 | grade_2 | 3 | 0 | 30 | 0 | 2 | 0 | 0 | 13 | 22 | 35 | 3 | 0 | 30 | 0 | 2 | 0 | 0 | 13 | 22 | 35 | ||||||||||||||||||||||||||||||||||
1743825 | 1743825 | CO | school | 803450 | 900 | Douglas County Re 1 | 80345000446 | 7718 | Sedalia Elementary School | Regular School | No | Elementary | PK | 06 | 2021 | grade_2 | 18 | 1 | 14 | 1 | 0 | 0 | 1 | 13 | 22 | 35 | 18 | 1 | 14 | 1 | 0 | 0 | 1 | 13 | 22 | 35 | ||||||||||||||||||||||||||||||||||
1745393 | 1745393 | CO | school | 803870 | 1110 | District 49 | 80387006778 | 431 | Falcon Homeschool Program | Regular School | No | Other | KG | 12 | 2021 | grade_2 | 29 | 0 | 3 | 0 | 0 | 0 | 2 | 13 | 21 | 34 | 29 | 0 | 3 | 0 | 0 | 0 | 2 | 13 | 21 | 34 | ||||||||||||||||||||||||||||||||||
1745742 | 1745742 | CO | school | 803960 | 1150 | Fremont RE-2 | 80396000516 | 6858 | Penrose Elementary School | Regular School | No | Elementary | PK | 06 | 2021 | grade_2 | 19 | 0 | 2 | 0 | 0 | 0 | 4 | 13 | 12 | 25 | 19 | 0 | 2 | 0 | 0 | 0 | 4 | 13 | 12 | 25 | ||||||||||||||||||||||||||||||||||
1745960 | 1745960 | CO | school | 805070 | 1340 | West Grand 1-JT | 80507000829 | 9422 | West Grand Elementary and Middle School | Regular School | No | Elementary | KG | 08 | 2021 | grade_2 | 19 | 0 | 7 | 0 | 0 | 0 | 1 | 13 | 14 | 27 | 19 | 0 | 7 | 0 | 0 | 0 | 1 | 13 | 14 | 27 | ||||||||||||||||||||||||||||||||||
1746287 | 1746287 | CO | school | 804800 | 1420 | Jefferson County R-1 | 80480001649 | 1869 | Compass Montessori - Wheat Ridge Charter School | Regular School | Yes | Elementary | PK | 06 | 2021 | grade_2 | 30 | 1 | 2 | 0 | 0 | 0 | 1 | 13 | 21 | 34 | 30 | 1 | 2 | 0 | 0 | 0 | 1 | 13 | 21 | 34 | ||||||||||||||||||||||||||||||||||
1746895 | 1746895 | CO | school | 804800 | 1420 | Jefferson County R-1 | 80480000772 | 6844 | Peiffer Elementary School | Regular School | No | Elementary | PK | 05 | 2021 | grade_2 | 20 | 0 | 6 | 0 | 4 | 0 | 1 | 13 | 18 | 31 | 20 | 0 | 6 | 0 | 4 | 0 | 1 | 13 | 18 | 31 | ||||||||||||||||||||||||||||||||||
1746903 | 1746903 | CO | school | 804800 | 1420 | Jefferson County R-1 | 80480000773 | 6848 | Peak Expeditionary - Pennington | Regular School | No | Elementary | PK | 05 | 2021 | grade_2 | 15 | 0 | 7 | 0 | 1 | 0 | 2 | 13 | 12 | 25 | 15 | 0 | 7 | 0 | 1 | 0 | 2 | 13 | 12 | 25 | ||||||||||||||||||||||||||||||||||
1746986 | 1746986 | CO | school | 804800 | 1420 | Jefferson County R-1 | 80480001036 | 7701 | Collegiate Academy of Colorado | Regular School | Yes | Other | KG | 12 | 2021 | grade_2 | 24 | 1 | 0 | 0 | 0 | 0 | 1 | 13 | 13 | 26 | 24 | 1 | 0 | 0 | 0 | 0 | 1 | 13 | 13 | 26 | ||||||||||||||||||||||||||||||||||
1747371 | 1747371 | CO | school | 806780 | 1480 | Stratton R-4 | 80678001162 | 8342 | Stratton Elementary School | Regular School | No | Elementary | PK | 05 | 2021 | grade_2 | 12 | 0 | 6 | 0 | 0 | 0 | 0 | 13 | 5 | 18 | 12 | 0 | 6 | 0 | 0 | 0 | 0 | 13 | 5 | 18 | ||||||||||||||||||||||||||||||||||
1747697 | 1747697 | CO | school | 803990 | 1550 | Poudre R-1 | 80399006613 | 3242 | Fort Collins Montessori School | Regular School | Yes | Elementary | PK | 06 | 2021 | grade_2 | 25 | 1 | 0 | 0 | 0 | 0 | 0 | 13 | 13 | 26 | 25 | 1 | 0 | 0 | 0 | 0 | 0 | 13 | 13 | 26 | ||||||||||||||||||||||||||||||||||
1749258 | 1749258 | CO | school | 806840 | 2570 | Swink 33 | 80684001168 | 8452 | Swink Elementary School | Regular School | No | Elementary | KG | 06 | 2021 | grade_2 | 21 | 0 | 3 | 0 | 0 | 0 | 0 | 13 | 11 | 24 | 21 | 0 | 3 | 0 | 0 | 0 | 0 | 13 | 11 | 24 | ||||||||||||||||||||||||||||||||||
1749992 | 1749992 | CO | school | 806450 | 2750 | Sargent RE-33J | 80645001117 | 7660 | Sargent Elementary School | Regular School | No | Elementary | KG | 06 | 2021 | grade_2 | 24 | 0 | 7 | 0 | 0 | 0 | 1 | 13 | 19 | 32 | 24 | 0 | 7 | 0 | 0 | 0 | 1 | 13 | 19 | 32 | ||||||||||||||||||||||||||||||||||
1751127 | 1751127 | CO | school | 800020 | 8001 | Charter School Institute | 80002002018 | 653 | Stone Creek School | Regular School | Yes | Elementary | KG | 08 | 2021 | grade_2 | 26 | 0 | 6 | 0 | 0 | 0 | 0 | 13 | 19 | 32 | 26 | 0 | 6 | 0 | 0 | 0 | 0 | 13 | 19 | 32 | ||||||||||||||||||||||||||||||||||
1739318 | 1739318 | CO | school | 803780 | 120 | Englewood 1 | 80378000497 | 9620 | Wm E Bishop Elementary School | Regular School | No | Elementary | KG | 06 | 2021 | grade_2 | 7 | 2 | 11 | 1 | 0 | 0 | 3 | 14 | 10 | 24 | 7 | 2 | 11 | 1 | 0 | 0 | 3 | 14 | 10 | 24 | ||||||||||||||||||||||||||||||||||
1739852 | 1739852 | CO | school | 805310 | 140 | Littleton 6 | 80531000882 | 3950 | Highland Elementary School | Regular School | No | Elementary | KG | 05 | 2021 | grade_2 | 29 | 0 | 1 | 0 | 1 | 1 | 2 | 14 | 20 | 34 | 29 | 0 | 1 | 0 | 1 | 1 | 2 | 14 | 20 | 34 | ||||||||||||||||||||||||||||||||||
1739954 | 1739954 | CO | school | 803270 | 170 | Deer Trail 26J | 80327000287 | 2136 | Deer Trail Elementary School | Regular School | No | Elementary | PK | 05 | 2021 | grade_2 | 10 | 0 | 13 | 0 | 0 | 0 | 1 | 14 | 10 | 24 | 10 | 0 | 13 | 0 | 0 | 0 | 1 | 14 | 10 | 24 | ||||||||||||||||||||||||||||||||||
1740062 | 1740062 | CO | school | 802340 | 180 | Adams-Arapahoe 28J | 80234001388 | 1470 | Century Elementary School | Regular School | No | Elementary | PK | 05 | 2021 | grade_2 | 4 | 7 | 17 | 0 | 3 | 0 | 3 | 14 | 20 | 34 | 4 | 7 | 17 | 0 | 3 | 0 | 3 | 14 | 20 | 34 | ||||||||||||||||||||||||||||||||||
1740467 | 1740467 | CO | school | 802700 | 190 | Byers 32J | 80270000163 | 1168 | Byers Elementary School | Regular School | No | Elementary | PK | 06 | 2021 | grade_2 | 26 | 0 | 3 | 0 | 1 | 0 | 1 | 14 | 17 | 31 | 26 | 0 | 3 | 0 | 1 | 0 | 1 | 14 | 17 | 31 | ||||||||||||||||||||||||||||||||||
1740644 | 1740644 | CO | school | 805250 | 290 | Las Animas RE-1 | 80525000866 | 1812 | Las Animas Elementary School | Regular School | No | Elementary | KG | 06 | 2021 | grade_2 | 17 | 0 | 9 | 0 | 0 | 0 | 1 | 14 | 13 | 27 | 17 | 0 | 9 | 0 | 0 | 0 | 1 | 14 | 13 | 27 | ||||||||||||||||||||||||||||||||||
1741697 | 1741697 | CO | school | 807200 | 860 | Custer County School District C-1 | 80720001226 | 2088 | Custer County Elementary School | Regular School | No | Elementary | PK | 05 | 2021 | grade_2 | 22 | 0 | 0 | 1 | 0 | 0 | 0 | 14 | 9 | 23 | 22 | 0 | 0 | 1 | 0 | 0 | 0 | 14 | 9 | 23 | ||||||||||||||||||||||||||||||||||
1742050 | 1742050 | CO | school | 803360 | 880 | Denver County 1 | 80336000332 | 1928 | Cowell Elementary School | Regular School | No | Elementary | PK | 05 | 2021 | grade_2 | 2 | 1 | 31 | 1 | 0 | 1 | 0 | 14 | 22 | 36 | 2 | 1 | 31 | 1 | 0 | 1 | 0 | 14 | 22 | 36 | ||||||||||||||||||||||||||||||||||
1742592 | 1742592 | CO | school | 803360 | 880 | Denver County 1 | 80336006748 | 4850 | KIPP Sunshine Peak Elementary | Regular School | Yes | Elementary | PK | 02 | 2021 | grade_2 | 1 | 0 | 28 | 0 | 0 | 0 | 0 | 14 | 15 | 29 | 1 | 0 | 28 | 0 | 0 | 0 | 0 | 14 | 15 | 29 | ||||||||||||||||||||||||||||||||||
1742984 | 1742984 | CO | school | 803360 | 880 | Denver County 1 | 80336006525 | 8131 | Oakland Elementary | Regular School | No | Elementary | PK | 05 | 2021 | grade_2 | 0 | 8 | 22 | 0 | 2 | 0 | 0 | 14 | 18 | 32 | 0 | 8 | 22 | 0 | 2 | 0 | 0 | 14 | 18 | 32 | ||||||||||||||||||||||||||||||||||
1743108 | 1743108 | CO | school | 803360 | 880 | Denver County 1 | 80336000421 | 9050 | Valverde Elementary School | Regular School | No | Elementary | PK | 05 | 2021 | grade_2 | 1 | 0 | 35 | 0 | 0 | 0 | 0 | 14 | 22 | 36 | 1 | 0 | 35 | 0 | 0 | 0 | 0 | 14 | 22 | 36 | ||||||||||||||||||||||||||||||||||
1745699 | 1745699 | CO | school | 802790 | 1140 | Canon City RE-1 | 80279001538 | 6752 | Mount View Core Knowledge Charter School | Regular School | Yes | Elementary | PK | 08 | 2021 | grade_2 | 24 | 0 | 3 | 0 | 0 | 0 | 1 | 14 | 14 | 28 | 24 | 0 | 3 | 0 | 0 | 0 | 1 | 14 | 14 | 28 | ||||||||||||||||||||||||||||||||||
1746775 | 1746775 | CO | school | 804800 | 1420 | Jefferson County R-1 | 80480000758 | 5972 | Molholm Elementary School | Regular School | No | Elementary | PK | 06 | 2021 | grade_2 | 6 | 1 | 20 | 0 | 0 | 0 | 0 | 14 | 13 | 27 | 6 | 1 | 20 | 0 | 0 | 0 | 0 | 14 | 13 | 27 | ||||||||||||||||||||||||||||||||||
1746848 | 1746848 | CO | school | 804800 | 1420 | Jefferson County R-1 | 80480006256 | 6539 | Jefferson County Open Elementary School | Regular School | No | Elementary | PK | 06 | 2021 | grade_2 | 25 | 0 | 1 | 0 | 0 | 0 | 2 | 14 | 14 | 28 | 25 | 0 | 1 | 0 | 0 | 0 | 2 | 14 | 14 | 28 | ||||||||||||||||||||||||||||||||||
1747143 | 1747143 | CO | school | 804800 | 1420 | Jefferson County R-1 | 80480000792 | 8834 | Thomson Elementary School | Regular School | No | Elementary | KG | 05 | 2021 | grade_2 | 17 | 0 | 14 | 0 | 2 | 0 | 1 | 14 | 20 | 34 | 17 | 0 | 14 | 0 | 2 | 0 | 1 | 14 | 20 | 34 | ||||||||||||||||||||||||||||||||||
1748162 | 1748162 | CO | school | 805400 | 1560 | Thompson R2-J | 80540000939 | 8918 | Truscott Elementary School | Regular School | No | Elementary | KG | 05 | 2021 | grade_2 | 19 | 0 | 17 | 0 | 0 | 0 | 2 | 14 | 24 | 38 | 19 | 0 | 17 | 0 | 0 | 0 | 2 | 14 | 24 | 38 |
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]);