enrollments
Data source: Big Local News · About: Big Local
1,109 rows where grade = "grade_4", 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1745861 | 1745861 | CO | school | 806240 | 1195 | Garfield Re-2 | 80624006396 | 2573 | Elk Creek Elementary | Regular School | No | Elementary | PK | 05 | 2021 | grade_4 | 16 | 0 | 18 | 1 | 0 | 0 | 0 | 15 | 20 | 35 | 16 | 0 | 18 | 1 | 0 | 0 | 0 | 15 | 20 | 35 | ||||||||||||||||||||||||||||||||||
1746450 | 1746450 | CO | school | 804800 | 1420 | Jefferson County R-1 | 80480000724 | 3025 | Foothills Elementary School | Regular School | No | Elementary | PK | 05 | 2021 | grade_4 | 19 | 3 | 13 | 4 | 0 | 0 | 2 | 15 | 26 | 41 | 19 | 3 | 13 | 4 | 0 | 0 | 2 | 15 | 26 | 41 | ||||||||||||||||||||||||||||||||||
1746897 | 1746897 | CO | school | 804800 | 1420 | Jefferson County R-1 | 80480000772 | 6844 | Peiffer Elementary School | Regular School | No | Elementary | PK | 05 | 2021 | grade_4 | 24 | 0 | 10 | 0 | 1 | 0 | 0 | 15 | 20 | 35 | 24 | 0 | 10 | 0 | 1 | 0 | 0 | 15 | 20 | 35 | ||||||||||||||||||||||||||||||||||
1746999 | 1746999 | CO | school | 804800 | 1420 | Jefferson County R-1 | 80480000780 | 7708 | Secrest Elementary School | Regular School | No | Elementary | PK | 05 | 2021 | grade_4 | 11 | 0 | 14 | 0 | 1 | 0 | 1 | 15 | 12 | 27 | 11 | 0 | 14 | 0 | 1 | 0 | 1 | 15 | 12 | 27 | ||||||||||||||||||||||||||||||||||
1747373 | 1747373 | CO | school | 806780 | 1480 | Stratton R-4 | 80678001162 | 8342 | Stratton Elementary School | Regular School | No | Elementary | PK | 05 | 2021 | grade_4 | 16 | 0 | 5 | 0 | 0 | 0 | 0 | 15 | 6 | 21 | 16 | 0 | 5 | 0 | 0 | 0 | 0 | 15 | 6 | 21 | ||||||||||||||||||||||||||||||||||
1747991 | 1747991 | CO | school | 805400 | 1560 | Thompson R2-J | 80540000928 | 870 | Big Thompson Elementary School | Regular School | No | Elementary | KG | 05 | 2021 | grade_4 | 18 | 0 | 7 | 0 | 1 | 0 | 1 | 15 | 12 | 27 | 18 | 0 | 7 | 0 | 1 | 0 | 1 | 15 | 12 | 27 | ||||||||||||||||||||||||||||||||||
1748516 | 1748516 | CO | school | 804350 | 2000 | Mesa County Valley 51 | 80435000599 | 1046 | Broadway Elementary School | Regular School | No | Elementary | PK | 05 | 2021 | grade_4 | 27 | 0 | 5 | 0 | 1 | 0 | 0 | 15 | 18 | 33 | 27 | 0 | 5 | 0 | 1 | 0 | 0 | 15 | 18 | 33 | ||||||||||||||||||||||||||||||||||
1749229 | 1749229 | CO | school | 804110 | 2540 | Fowler R-4J | 80411001981 | 56 | Fowler Elementary School | Regular School | No | Elementary | KG | 06 | 2021 | grade_4 | 20 | 0 | 6 | 0 | 0 | 0 | 1 | 15 | 12 | 27 | 20 | 0 | 6 | 0 | 0 | 0 | 1 | 15 | 12 | 27 | ||||||||||||||||||||||||||||||||||
1749547 | 1749547 | CO | school | 806120 | 2690 | Pueblo City 60 | 80612001034 | 1304 | Carlile Elementary School | Regular School | No | Elementary | PK | 05 | 2021 | grade_4 | 10 | 0 | 21 | 0 | 0 | 0 | 1 | 15 | 17 | 32 | 10 | 0 | 21 | 0 | 0 | 0 | 1 | 15 | 17 | 32 | ||||||||||||||||||||||||||||||||||
1749690 | 1749690 | 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_4 | 12 | 0 | 16 | 0 | 0 | 0 | 0 | 15 | 13 | 28 | 12 | 0 | 16 | 0 | 0 | 0 | 0 | 15 | 13 | 28 | ||||||||||||||||||||||||||||||||||
1749930 | 1749930 | CO | school | 806180 | 2720 | Rangely RE-4 | 80618001086 | 7268 | Parkview Elementary School | Regular School | No | Elementary | PK | 05 | 2021 | grade_4 | 30 | 0 | 3 | 0 | 0 | 0 | 0 | 15 | 18 | 33 | 30 | 0 | 3 | 0 | 0 | 0 | 0 | 15 | 18 | 33 | ||||||||||||||||||||||||||||||||||
1750291 | 1750291 | CO | school | 806810 | 3000 | Summit RE-1 | 80681001563 | 8385 | Summit Cove Elementary School | Regular School | No | Elementary | PK | 05 | 2021 | grade_4 | 20 | 0 | 11 | 0 | 0 | 0 | 1 | 15 | 17 | 32 | 20 | 0 | 11 | 0 | 0 | 0 | 1 | 15 | 17 | 32 | ||||||||||||||||||||||||||||||||||
1750315 | 1750315 | CO | school | 803180 | 3010 | Cripple Creek-Victor RE-1 | 80318000280 | 9080 | Cresson Elementary School | Regular School | No | Elementary | PK | 05 | 2021 | grade_4 | 21 | 0 | 1 | 0 | 0 | 0 | 0 | 15 | 7 | 22 | 21 | 0 | 1 | 0 | 0 | 0 | 0 | 15 | 7 | 22 | ||||||||||||||||||||||||||||||||||
1751150 | 1751150 | CO | school | 800020 | 8001 | Charter School Institute | 80002001998 | 657 | Academy of Arts and Knowledge Elementary | Regular School | Yes | Elementary | KG | 05 | 2021 | grade_4 | 20 | 1 | 4 | 0 | 0 | 1 | 1 | 15 | 12 | 27 | 20 | 1 | 4 | 0 | 0 | 1 | 1 | 15 | 12 | 27 | ||||||||||||||||||||||||||||||||||
1751157 | 1751157 | CO | school | 800020 | 8001 | Charter School Institute | 80002006796 | 1005 | Ascent Classical Academy Northern Colorado | Regular School | Yes | Elementary | KG | 06 | 2021 | grade_4 | 26 | 1 | 2 | 1 | 0 | 0 | 2 | 15 | 17 | 32 | 26 | 1 | 2 | 1 | 0 | 0 | 2 | 15 | 17 | 32 | ||||||||||||||||||||||||||||||||||
1751363 | 1751363 | CO | school | 800020 | 8001 | Charter School Institute | 80002006602 | 5957 | Montessori del Mundo Charter School | Regular School | Yes | Elementary | PK | 06 | 2021 | grade_4 | 1 | 3 | 29 | 1 | 0 | 0 | 0 | 15 | 19 | 34 | 1 | 3 | 29 | 1 | 0 | 0 | 0 | 15 | 19 | 34 | ||||||||||||||||||||||||||||||||||
1739150 | 1739150 | CO | school | 807230 | 70 | Westminster Public Schools | 80723001242 | 5834 | Mesa Elementary School | Regular School | No | Elementary | PK | 05 | 2021 | grade_4 | 5 | 2 | 19 | 1 | 4 | 1 | 1 | 16 | 17 | 33 | 5 | 2 | 19 | 1 | 4 | 1 | 1 | 16 | 17 | 33 | ||||||||||||||||||||||||||||||||||
1741010 | 1741010 | CO | school | 805370 | 470 | St Vrain Valley RE1J | 80537006430 | 7565 | St. Vrain Community Montessori School | Regular School | Yes | Elementary | PK | 08 | 2021 | grade_4 | 28 | 0 | 1 | 0 | 0 | 0 | 1 | 16 | 14 | 30 | 28 | 0 | 1 | 0 | 0 | 0 | 1 | 16 | 14 | 30 | ||||||||||||||||||||||||||||||||||
1741893 | 1741893 | CO | school | 803360 | 880 | Denver County 1 | 80336000313 | 650 | Beach Court Elementary School | Regular School | No | Elementary | PK | 05 | 2021 | grade_4 | 4 | 0 | 30 | 0 | 0 | 0 | 0 | 16 | 18 | 34 | 4 | 0 | 30 | 0 | 0 | 0 | 0 | 16 | 18 | 34 | ||||||||||||||||||||||||||||||||||
1742038 | 1742038 | CO | school | 803360 | 880 | Denver County 1 | 80336000330 | 1846 | Columbine Elementary School | Regular School | No | Elementary | PK | 05 | 2021 | grade_4 | 4 | 17 | 10 | 0 | 1 | 0 | 2 | 16 | 18 | 34 | 4 | 17 | 10 | 0 | 1 | 0 | 2 | 16 | 18 | 34 | ||||||||||||||||||||||||||||||||||
1742791 | 1742791 | CO | school | 803360 | 880 | Denver County 1 | 80336001636 | 6479 | Odyssey School of Denver | Regular School | Yes | Elementary | KG | 08 | 2021 | grade_4 | 15 | 4 | 1 | 1 | 2 | 0 | 3 | 16 | 10 | 26 | 15 | 4 | 1 | 1 | 2 | 0 | 3 | 16 | 10 | 26 | ||||||||||||||||||||||||||||||||||
1743021 | 1743021 | CO | school | 803360 | 880 | Denver County 1 | 80336000411 | 8232 | Stedman Elementary School | Regular School | No | Elementary | PK | 05 | 2021 | grade_4 | 7 | 19 | 8 | 0 | 0 | 0 | 0 | 16 | 18 | 34 | 7 | 19 | 8 | 0 | 0 | 0 | 0 | 16 | 18 | 34 | ||||||||||||||||||||||||||||||||||
1743145 | 1743145 | CO | school | 803360 | 880 | Denver County 1 | 80336000426 | 9548 | Whittier ECE-8 School | Regular School | No | Elementary | PK | 08 | 2021 | grade_4 | 2 | 6 | 10 | 2 | 0 | 1 | 1 | 16 | 6 | 22 | 2 | 6 | 10 | 2 | 0 | 1 | 1 | 16 | 6 | 22 | ||||||||||||||||||||||||||||||||||
1744250 | 1744250 | CO | school | 804530 | 980 | Harrison 2 | 80453001369 | 6460 | Oak Creek Elementary School | Regular School | No | Elementary | PK | 05 | 2021 | grade_4 | 12 | 1 | 12 | 0 | 1 | 0 | 3 | 16 | 13 | 29 | 12 | 1 | 12 | 0 | 1 | 0 | 3 | 16 | 13 | 29 | ||||||||||||||||||||||||||||||||||
1746438 | 1746438 | CO | school | 804800 | 1420 | Jefferson County R-1 | 80480000722 | 2946 | Fitzmorris Elementary School | Regular School | No | Elementary | PK | 05 | 2021 | grade_4 | 12 | 0 | 12 | 0 | 0 | 0 | 0 | 16 | 8 | 24 | 12 | 0 | 12 | 0 | 0 | 0 | 0 | 16 | 8 | 24 | ||||||||||||||||||||||||||||||||||
1746509 | 1746509 | CO | school | 804800 | 1420 | Jefferson County R-1 | 80480000734 | 3622 | Green Gables Elementary School | Regular School | No | Elementary | KG | 05 | 2021 | grade_4 | 22 | 1 | 10 | 0 | 2 | 0 | 1 | 16 | 20 | 36 | 22 | 1 | 10 | 0 | 2 | 0 | 1 | 16 | 20 | 36 | ||||||||||||||||||||||||||||||||||
1746629 | 1746629 | CO | school | 804800 | 1420 | Jefferson County R-1 | 80480000744 | 4802 | Kullerstrand Elementary School | Regular School | No | Elementary | PK | 05 | 2021 | grade_4 | 9 | 1 | 15 | 0 | 0 | 0 | 3 | 16 | 12 | 28 | 9 | 1 | 15 | 0 | 0 | 0 | 3 | 16 | 12 | 28 | ||||||||||||||||||||||||||||||||||
1749630 | 1749630 | CO | school | 806120 | 2690 | Pueblo City 60 | 80612000261 | 3924 | Heritage Elementary School | Regular School | No | Elementary | PK | 05 | 2021 | grade_4 | 18 | 0 | 35 | 0 | 0 | 0 | 1 | 16 | 38 | 54 | 18 | 0 | 35 | 0 | 0 | 0 | 1 | 16 | 38 | 54 | ||||||||||||||||||||||||||||||||||
1750259 | 1750259 | CO | school | 806810 | 3000 | Summit RE-1 | 80681001165 | 8374 | Frisco Elementary School | Regular School | No | Elementary | PK | 05 | 2021 | grade_4 | 34 | 0 | 6 | 0 | 0 | 0 | 1 | 16 | 25 | 41 | 34 | 0 | 6 | 0 | 0 | 0 | 1 | 16 | 25 | 41 | ||||||||||||||||||||||||||||||||||
1750299 | 1750299 | CO | school | 806810 | 3000 | Summit RE-1 | 80681001564 | 8993 | Upper Blue Elementary School | Regular School | No | Elementary | PK | 05 | 2021 | grade_4 | 20 | 0 | 10 | 0 | 0 | 0 | 6 | 16 | 20 | 36 | 20 | 0 | 10 | 0 | 0 | 0 | 6 | 16 | 20 | 36 | ||||||||||||||||||||||||||||||||||
1751352 | 1751352 | CO | school | 800020 | 8001 | Charter School Institute | 80002006589 | 5851 | Mountain Song Community School | Regular School | Yes | Elementary | KG | 08 | 2021 | grade_4 | 22 | 1 | 12 | 0 | 0 | 0 | 1 | 16 | 20 | 36 | 22 | 1 | 12 | 0 | 0 | 0 | 1 | 16 | 20 | 36 | ||||||||||||||||||||||||||||||||||
1743255 | 1743255 | CO | school | 803450 | 900 | Douglas County Re 1 | 80345001896 | 215 | American Academy | Regular School | Yes | Elementary | PK | 08 | 2021 | grade_4 | 200 | 2 | 22 | 3 | 55 | 0 | 25 | 162 | 145 | 307 | 200 | 2 | 22 | 3 | 55 | 0 | 25 | 162 | 145 | 307 | ||||||||||||||||||||||||||||||||||
1739140 | 1739140 | CO | school | 807230 | 70 | Westminster Public Schools | 80723001241 | 5388 | Colorado Sports Leadership Academy | Regular School | No | Elementary | KG | 08 | 2021 | grade_4 | 0 | 0 | 33 | 0 | 0 | 0 | 0 | 17 | 16 | 33 | 0 | 0 | 33 | 0 | 0 | 0 | 0 | 17 | 16 | 33 | ||||||||||||||||||||||||||||||||||
1739176 | 1739176 | CO | school | 807230 | 70 | Westminster Public Schools | 80723001246 | 7860 | Sherrelwood Elementary School | Regular School | No | Elementary | PK | 05 | 2021 | grade_4 | 3 | 0 | 35 | 0 | 0 | 0 | 1 | 17 | 22 | 39 | 3 | 0 | 35 | 0 | 0 | 0 | 1 | 17 | 22 | 39 | ||||||||||||||||||||||||||||||||||
1740469 | 1740469 | CO | school | 802700 | 190 | Byers 32J | 80270000163 | 1168 | Byers Elementary School | Regular School | No | Elementary | PK | 06 | 2021 | grade_4 | 26 | 0 | 5 | 0 | 0 | 0 | 0 | 17 | 14 | 31 | 26 | 0 | 5 | 0 | 0 | 0 | 0 | 17 | 14 | 31 | ||||||||||||||||||||||||||||||||||
1741179 | 1741179 | CO | school | 802490 | 480 | Boulder Valley Re 2 | 80249001227 | 1883 | Community Montessori School | Regular School | No | Elementary | PK | 06 | 2021 | grade_4 | 21 | 1 | 9 | 0 | 1 | 0 | 1 | 17 | 16 | 33 | 21 | 1 | 9 | 0 | 1 | 0 | 1 | 17 | 16 | 33 | ||||||||||||||||||||||||||||||||||
1741885 | 1741885 | CO | school | 803360 | 880 | Denver County 1 | 80336000311 | 520 | Barnum Elementary School | Regular School | No | Elementary | PK | 05 | 2021 | grade_4 | 1 | 1 | 46 | 0 | 0 | 0 | 1 | 17 | 32 | 49 | 1 | 1 | 46 | 0 | 0 | 0 | 1 | 17 | 32 | 49 | ||||||||||||||||||||||||||||||||||
1742653 | 1742653 | CO | school | 803360 | 880 | Denver County 1 | 80336006555 | 5621 | Monarch Montessori | Regular School | Yes | Elementary | KG | 05 | 2021 | grade_4 | 3 | 4 | 13 | 1 | 0 | 0 | 2 | 17 | 6 | 23 | 3 | 4 | 13 | 1 | 0 | 0 | 2 | 17 | 6 | 23 | ||||||||||||||||||||||||||||||||||
1744002 | 1744002 | CO | school | 803540 | 910 | Eagle County RE 50 | 80354000468 | 7296 | Red Sandstone Elementary School | Regular School | No | Elementary | PK | 05 | 2021 | grade_4 | 21 | 0 | 6 | 0 | 0 | 0 | 1 | 17 | 11 | 28 | 21 | 0 | 6 | 0 | 0 | 0 | 1 | 17 | 11 | 28 | ||||||||||||||||||||||||||||||||||
1744555 | 1744555 | CO | school | 803060 | 1010 | Colorado Springs 11 | 80306000226 | 1340 | Carver Elementary School | Regular School | No | Elementary | KG | 05 | 2021 | grade_4 | 11 | 4 | 16 | 0 | 0 | 1 | 5 | 17 | 20 | 37 | 11 | 4 | 16 | 0 | 0 | 1 | 5 | 17 | 20 | 37 | ||||||||||||||||||||||||||||||||||
1744844 | 1744844 | CO | school | 803060 | 1010 | Colorado Springs 11 | 80306000267 | 8466 | Taylor Elementary School | Regular School | No | Elementary | PK | 05 | 2021 | grade_4 | 19 | 5 | 6 | 0 | 0 | 1 | 5 | 17 | 19 | 36 | 19 | 5 | 6 | 0 | 0 | 1 | 5 | 17 | 19 | 36 | ||||||||||||||||||||||||||||||||||
1744864 | 1744864 | CO | school | 803060 | 1010 | Colorado Springs 11 | 80306006416 | 9445 | West Elementary School | Regular School | No | Elementary | PK | 05 | 2021 | grade_4 | 27 | 1 | 7 | 0 | 0 | 0 | 1 | 17 | 19 | 36 | 27 | 1 | 7 | 0 | 0 | 0 | 1 | 17 | 19 | 36 | ||||||||||||||||||||||||||||||||||
1745212 | 1745212 | CO | school | 801920 | 1040 | Academy 20 | 80192000007 | 7460 | Rockrimmon Elementary School | Regular School | No | Elementary | KG | 05 | 2021 | grade_4 | 40 | 0 | 8 | 0 | 0 | 0 | 3 | 17 | 34 | 51 | 40 | 0 | 8 | 0 | 0 | 0 | 3 | 17 | 34 | 51 | ||||||||||||||||||||||||||||||||||
1745395 | 1745395 | CO | school | 803870 | 1110 | District 49 | 80387006778 | 431 | Falcon Homeschool Program | Regular School | No | Other | KG | 12 | 2021 | grade_4 | 25 | 0 | 2 | 0 | 0 | 0 | 3 | 17 | 13 | 30 | 25 | 0 | 2 | 0 | 0 | 0 | 3 | 17 | 13 | 30 | ||||||||||||||||||||||||||||||||||
1745976 | 1745976 | CO | school | 804320 | 1350 | East Grand 2 | 80432000594 | 3182 | Fraser Valley Elementary School | Regular School | No | Elementary | PK | 05 | 2021 | grade_4 | 29 | 0 | 8 | 0 | 0 | 0 | 0 | 17 | 20 | 37 | 29 | 0 | 8 | 0 | 0 | 0 | 0 | 17 | 20 | 37 | ||||||||||||||||||||||||||||||||||
1746055 | 1746055 | CO | school | 807080 | 1390 | Huerfano Re-1 | 80708001845 | 63 | Peakview School | Regular School | No | Elementary | PK | 08 | 2021 | grade_4 | 9 | 0 | 18 | 0 | 2 | 0 | 0 | 17 | 12 | 29 | 9 | 0 | 18 | 0 | 2 | 0 | 0 | 17 | 12 | 29 | ||||||||||||||||||||||||||||||||||
1746268 | 1746268 | CO | school | 804800 | 1420 | Jefferson County R-1 | 80480000705 | 1790 | Colorow Elementary School | Regular School | No | Elementary | PK | 05 | 2021 | grade_4 | 18 | 0 | 10 | 0 | 0 | 0 | 0 | 17 | 11 | 28 | 18 | 0 | 10 | 0 | 0 | 0 | 0 | 17 | 11 | 28 | ||||||||||||||||||||||||||||||||||
1746658 | 1746658 | CO | school | 804800 | 1420 | Jefferson County R-1 | 80480000749 | 5024 | Lawrence Elementary School | Regular School | No | Elementary | PK | 05 | 2021 | grade_4 | 20 | 2 | 17 | 0 | 0 | 0 | 1 | 17 | 23 | 40 | 20 | 2 | 17 | 0 | 0 | 0 | 1 | 17 | 23 | 40 | ||||||||||||||||||||||||||||||||||
1746850 | 1746850 | CO | school | 804800 | 1420 | Jefferson County R-1 | 80480006256 | 6539 | Jefferson County Open Elementary School | Regular School | No | Elementary | PK | 06 | 2021 | grade_4 | 22 | 0 | 7 | 0 | 1 | 0 | 2 | 17 | 15 | 32 | 22 | 0 | 7 | 0 | 1 | 0 | 2 | 17 | 15 | 32 | ||||||||||||||||||||||||||||||||||
1746873 | 1746873 | CO | school | 804800 | 1420 | Jefferson County R-1 | 80480000769 | 6806 | Parr Elementary School | Regular School | No | Elementary | PK | 05 | 2021 | grade_4 | 14 | 0 | 16 | 0 | 1 | 0 | 4 | 17 | 18 | 35 | 14 | 0 | 16 | 0 | 1 | 0 | 4 | 17 | 18 | 35 | ||||||||||||||||||||||||||||||||||
1747804 | 1747804 | CO | school | 803990 | 1550 | Poudre R-1 | 80399006573 | 5917 | Mountain Sage Community School | Regular School | Yes | Elementary | KG | 08 | 2021 | grade_4 | 35 | 0 | 3 | 0 | 0 | 0 | 3 | 17 | 24 | 41 | 35 | 0 | 3 | 0 | 0 | 0 | 3 | 17 | 24 | 41 | ||||||||||||||||||||||||||||||||||
1747882 | 1747882 | CO | school | 803990 | 1550 | Poudre R-1 | 80399000542 | 7218 | Putnam Elementary School | Regular School | No | Elementary | PK | 05 | 2021 | grade_4 | 13 | 1 | 23 | 0 | 0 | 0 | 0 | 17 | 20 | 37 | 13 | 1 | 23 | 0 | 0 | 0 | 0 | 17 | 20 | 37 | ||||||||||||||||||||||||||||||||||
1748078 | 1748078 | CO | school | 805400 | 1560 | Thompson R2-J | 80540000934 | 5170 | Lincoln Elementary School | Regular School | No | Elementary | KG | 05 | 2021 | grade_4 | 19 | 0 | 11 | 0 | 1 | 0 | 1 | 17 | 15 | 32 | 19 | 0 | 11 | 0 | 1 | 0 | 1 | 17 | 15 | 32 | ||||||||||||||||||||||||||||||||||
1749946 | 1749946 | 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_4 | 15 | 0 | 15 | 0 | 0 | 0 | 1 | 17 | 14 | 31 | 15 | 0 | 15 | 0 | 0 | 0 | 1 | 17 | 14 | 31 | ||||||||||||||||||||||||||||||||||
1751321 | 1751321 | CO | school | 800020 | 8001 | Charter School Institute | 80002006701 | 5423 | Mountain Village Montessori Charter School | Regular School | Yes | Elementary | PK | 05 | 2021 | grade_4 | 27 | 0 | 1 | 0 | 1 | 0 | 0 | 17 | 12 | 29 | 27 | 0 | 1 | 0 | 1 | 0 | 0 | 17 | 12 | 29 | ||||||||||||||||||||||||||||||||||
1739162 | 1739162 | CO | school | 807230 | 70 | Westminster Public Schools | 80723001363 | 7810 | John E. Flynn A Marzano Academy | Regular School | No | Elementary | PK | 07 | 2021 | grade_4 | 9 | 0 | 26 | 0 | 2 | 0 | 1 | 18 | 20 | 38 | 9 | 0 | 26 | 0 | 2 | 0 | 1 | 18 | 20 | 38 | ||||||||||||||||||||||||||||||||||
1739246 | 1739246 | CO | school | 802070 | 100 | Alamosa RE-11J | 80207006792 | 270 | Alamosa Online | Regular School | No | Other | KG | 12 | 2021 | grade_4 | 7 | 2 | 30 | 5 | 0 | 0 | 1 | 18 | 27 | 45 | 7 | 2 | 30 | 5 | 0 | 0 | 1 | 18 | 27 | 45 | ||||||||||||||||||||||||||||||||||
1740747 | 1740747 | CO | school | 805370 | 470 | St Vrain Valley RE1J | 80537000896 | 1148 | Burlington Elementary School | Regular School | No | Elementary | PK | 05 | 2021 | grade_4 | 24 | 1 | 17 | 0 | 0 | 0 | 2 | 18 | 26 | 44 | 24 | 1 | 17 | 0 | 0 | 0 | 2 | 18 | 26 | 44 | ||||||||||||||||||||||||||||||||||
1740780 | 1740780 | CO | school | 805370 | 470 | St Vrain Valley RE1J | 80537001373 | 1844 | Columbine Elementary School | Regular School | No | Elementary | PK | 05 | 2021 | grade_4 | 4 | 1 | 38 | 0 | 0 | 0 | 0 | 18 | 25 | 43 | 4 | 1 | 38 | 0 | 0 | 0 | 0 | 18 | 25 | 43 | ||||||||||||||||||||||||||||||||||
1741684 | 1741684 | CO | school | 803210 | 770 | Crowley County RE-1-J | 80321001519 | 2054 | Crowley County Elementary K-6 | Regular School | No | Elementary | KG | 06 | 2021 | grade_4 | 6 | 1 | 27 | 0 | 0 | 0 | 0 | 18 | 16 | 34 | 6 | 1 | 27 | 0 | 0 | 0 | 0 | 18 | 16 | 34 | ||||||||||||||||||||||||||||||||||
1741815 | 1741815 | CO | school | 803330 | 870 | Delta County 50(J) | 80333001337 | 6700 | Paonia Elementary School | Regular School | No | Elementary | PK | 06 | 2021 | grade_4 | 27 | 0 | 4 | 0 | 0 | 0 | 0 | 18 | 13 | 31 | 27 | 0 | 4 | 0 | 0 | 0 | 0 | 18 | 13 | 31 | ||||||||||||||||||||||||||||||||||
1742118 | 1742118 | CO | school | 803360 | 880 | Denver County 1 | 80336001522 | 2174 | Denison Montessori School | Regular School | No | Elementary | PK | 06 | 2021 | grade_4 | 5 | 0 | 26 | 0 | 5 | 0 | 0 | 18 | 18 | 36 | 5 | 0 | 26 | 0 | 5 | 0 | 0 | 18 | 18 | 36 | ||||||||||||||||||||||||||||||||||
1744063 | 1744063 | CO | school | 803720 | 920 | Elizabeth School District | 80372001532 | 7925 | Singing Hills Elementary School | Regular School | No | Elementary | KG | 05 | 2021 | grade_4 | 40 | 0 | 6 | 1 | 0 | 0 | 2 | 18 | 31 | 49 | 40 | 0 | 6 | 1 | 0 | 0 | 2 | 18 | 31 | 49 | ||||||||||||||||||||||||||||||||||
1744296 | 1744296 | CO | school | 804530 | 980 | Harrison 2 | 80453000671 | 8337 | Stratmoor Hills Elementary School | Regular School | No | Elementary | PK | 05 | 2021 | grade_4 | 9 | 7 | 11 | 4 | 0 | 0 | 3 | 18 | 16 | 34 | 9 | 7 | 11 | 4 | 0 | 0 | 3 | 18 | 16 | 34 | ||||||||||||||||||||||||||||||||||
1744525 | 1744525 | CO | school | 803060 | 1010 | Colorado Springs 11 | 80306006456 | 517 | Academy for Advanced and Creative Learning | Regular School | Yes | Elementary | KG | 08 | 2021 | grade_4 | 25 | 0 | 4 | 0 | 0 | 0 | 2 | 18 | 13 | 31 | 25 | 0 | 4 | 0 | 0 | 0 | 2 | 18 | 13 | 31 | ||||||||||||||||||||||||||||||||||
1744583 | 1744583 | CO | school | 803060 | 1010 | Colorado Springs 11 | 80306000227 | 1798 | Columbia Elementary School | Regular School | No | Elementary | PK | 05 | 2021 | grade_4 | 17 | 2 | 12 | 0 | 0 | 0 | 5 | 18 | 18 | 36 | 17 | 2 | 12 | 0 | 0 | 0 | 5 | 18 | 18 | 36 | ||||||||||||||||||||||||||||||||||
1744685 | 1744685 | CO | school | 803060 | 1010 | Colorado Springs 11 | 80306000243 | 4138 | Howbert Elementary School | Regular School | No | Elementary | PK | 05 | 2021 | grade_4 | 28 | 3 | 3 | 0 | 1 | 0 | 1 | 18 | 18 | 36 | 28 | 3 | 3 | 0 | 1 | 0 | 1 | 18 | 18 | 36 | ||||||||||||||||||||||||||||||||||
1745274 | 1745274 | CO | school | 806060 | 1060 | Peyton 23 Jt | 80606001024 | 6898 | Peyton Elementary School | Regular School | No | Elementary | PK | 06 | 2021 | grade_4 | 25 | 0 | 8 | 0 | 0 | 0 | 4 | 18 | 19 | 37 | 25 | 0 | 8 | 0 | 0 | 0 | 4 | 18 | 19 | 37 | ||||||||||||||||||||||||||||||||||
1746490 | 1746490 | CO | school | 804800 | 1420 | Jefferson County R-1 | 80480000731 | 3450 | Glennon Heights Elementary School | Regular School | No | Elementary | KG | 05 | 2021 | grade_4 | 22 | 2 | 12 | 1 | 0 | 0 | 0 | 18 | 19 | 37 | 22 | 2 | 12 | 1 | 0 | 0 | 0 | 18 | 19 | 37 | ||||||||||||||||||||||||||||||||||
1746732 | 1746732 | CO | school | 804800 | 1420 | Jefferson County R-1 | 80480000754 | 5524 | Maple Grove Elementary School | Regular School | No | Elementary | KG | 05 | 2021 | grade_4 | 35 | 0 | 2 | 1 | 1 | 0 | 5 | 18 | 26 | 44 | 35 | 0 | 2 | 1 | 1 | 0 | 5 | 18 | 26 | 44 | ||||||||||||||||||||||||||||||||||
1747121 | 1747121 | CO | school | 804800 | 1420 | Jefferson County R-1 | 80480000790 | 8432 | Swanson Elementary School | Regular School | No | Elementary | PK | 05 | 2021 | grade_4 | 13 | 0 | 20 | 0 | 1 | 0 | 1 | 18 | 17 | 35 | 13 | 0 | 20 | 0 | 1 | 0 | 1 | 18 | 17 | 35 | ||||||||||||||||||||||||||||||||||
1747145 | 1747145 | CO | school | 804800 | 1420 | Jefferson County R-1 | 80480000792 | 8834 | Thomson Elementary School | Regular School | No | Elementary | KG | 05 | 2021 | grade_4 | 18 | 0 | 14 | 0 | 1 | 0 | 4 | 18 | 19 | 37 | 18 | 0 | 14 | 0 | 1 | 0 | 4 | 18 | 19 | 37 | ||||||||||||||||||||||||||||||||||
1748033 | 1748033 | CO | school | 805400 | 1560 | Thompson R2-J | 80540000932 | 3320 | Garfield Elementary School | Regular School | No | Elementary | KG | 05 | 2021 | grade_4 | 30 | 0 | 9 | 0 | 0 | 0 | 3 | 18 | 24 | 42 | 30 | 0 | 9 | 0 | 0 | 0 | 3 | 18 | 24 | 42 | ||||||||||||||||||||||||||||||||||
1748115 | 1748115 | CO | school | 805400 | 1560 | Thompson R2-J | 80540000936 | 5992 | Monroe Elementary School | Regular School | No | Elementary | KG | 05 | 2021 | grade_4 | 14 | 0 | 19 | 0 | 0 | 0 | 3 | 18 | 18 | 36 | 14 | 0 | 19 | 0 | 0 | 0 | 3 | 18 | 18 | 36 | ||||||||||||||||||||||||||||||||||
1748793 | 1748793 | CO | school | 804350 | 2000 | Mesa County Valley 51 | 80435000624 | 9434 | Scenic Elementary School | Regular School | No | Elementary | KG | 05 | 2021 | grade_4 | 27 | 0 | 3 | 0 | 0 | 0 | 3 | 18 | 15 | 33 | 27 | 0 | 3 | 0 | 0 | 0 | 3 | 18 | 15 | 33 | ||||||||||||||||||||||||||||||||||
1749350 | 1749350 | CO | school | 803840 | 2610 | Park County RE-2 | 80384000502 | 8114 | Edith Teter Elementary School | Regular School | No | Elementary | PK | 05 | 2021 | grade_4 | 27 | 0 | 5 | 0 | 0 | 0 | 0 | 18 | 14 | 32 | 27 | 0 | 5 | 0 | 0 | 0 | 0 | 18 | 14 | 32 | ||||||||||||||||||||||||||||||||||
1749683 | 1749683 | CO | school | 806120 | 2690 | Pueblo City 60 | 80612001060 | 6770 | Park View Elementary School | Regular School | No | Elementary | PK | 05 | 2021 | grade_4 | 10 | 1 | 38 | 1 | 0 | 0 | 0 | 18 | 32 | 50 | 10 | 1 | 38 | 1 | 0 | 0 | 0 | 18 | 32 | 50 | ||||||||||||||||||||||||||||||||||
1750139 | 1750139 | CO | school | 802850 | 2810 | Center 26 JT | 80285000177 | 1412 | Haskin Elementary School | Regular School | No | Elementary | PK | 05 | 2021 | grade_4 | 4 | 0 | 45 | 0 | 0 | 0 | 0 | 18 | 31 | 49 | 4 | 0 | 45 | 0 | 0 | 0 | 0 | 18 | 31 | 49 | ||||||||||||||||||||||||||||||||||
1750252 | 1750252 | CO | school | 806810 | 3000 | Summit RE-1 | 80681001166 | 8372 | Breckenridge Elementary School | Regular School | No | Elementary | KG | 05 | 2021 | grade_4 | 25 | 0 | 3 | 0 | 0 | 0 | 2 | 18 | 12 | 30 | 25 | 0 | 3 | 0 | 0 | 0 | 2 | 18 | 12 | 30 | ||||||||||||||||||||||||||||||||||
1751336 | 1751336 | CO | school | 800020 | 8001 | Charter School Institute | 80002006502 | 5453 | Mountain Middle School | Regular School | Yes | Middle | 04 | 08 | 2021 | grade_4 | 29 | 1 | 3 | 0 | 0 | 0 | 0 | 18 | 15 | 33 | 29 | 1 | 3 | 0 | 0 | 0 | 0 | 18 | 15 | 33 | ||||||||||||||||||||||||||||||||||
1738942 | 1738942 | CO | school | 802580 | 40 | School District 27J | 80258000148 | 6294 | North Elementary School | Regular School | No | Elementary | PK | 05 | 2021 | grade_4 | 4 | 0 | 24 | 1 | 1 | 0 | 1 | 19 | 12 | 31 | 4 | 0 | 24 | 1 | 1 | 0 | 1 | 19 | 12 | 31 | ||||||||||||||||||||||||||||||||||
1739184 | 1739184 | CO | school | 807230 | 70 | Westminster Public Schools | 80723001247 | 7952 | Skyline Vista Elementary School | Regular School | No | Elementary | PK | 06 | 2021 | grade_4 | 6 | 0 | 37 | 0 | 2 | 0 | 1 | 19 | 27 | 46 | 6 | 0 | 37 | 0 | 2 | 0 | 1 | 19 | 27 | 46 | ||||||||||||||||||||||||||||||||||
1740285 | 1740285 | CO | school | 802340 | 180 | Adams-Arapahoe 28J | 80234000075 | 6728 | Paris Elementary School | Regular School | No | Elementary | PK | 05 | 2021 | grade_4 | 0 | 6 | 31 | 1 | 1 | 0 | 1 | 19 | 21 | 40 | 0 | 6 | 31 | 1 | 1 | 0 | 1 | 19 | 21 | 40 | ||||||||||||||||||||||||||||||||||
1740762 | 1740762 | CO | school | 805370 | 470 | St Vrain Valley RE1J | 80537001887 | 1284 | Carbon Valley Academy | Regular School | Yes | Elementary | PK | 08 | 2021 | grade_4 | 24 | 1 | 6 | 0 | 0 | 0 | 0 | 19 | 12 | 31 | 24 | 1 | 6 | 0 | 0 | 0 | 0 | 19 | 12 | 31 | ||||||||||||||||||||||||||||||||||
1741933 | 1741933 | CO | school | 803360 | 880 | Denver County 1 | 80336000320 | 1106 | Bryant Webster Dual Language ECE-8 School | Regular School | No | Elementary | PK | 08 | 2021 | grade_4 | 3 | 0 | 31 | 0 | 0 | 0 | 0 | 19 | 15 | 34 | 3 | 0 | 31 | 0 | 0 | 0 | 0 | 19 | 15 | 34 | ||||||||||||||||||||||||||||||||||
1743570 | 1743570 | CO | school | 803450 | 900 | Douglas County Re 1 | 80345000441 | 4980 | Larkspur Elementary School | Regular School | No | Elementary | KG | 06 | 2021 | grade_4 | 26 | 0 | 5 | 0 | 0 | 0 | 0 | 19 | 12 | 31 | 26 | 0 | 5 | 0 | 0 | 0 | 0 | 19 | 12 | 31 | ||||||||||||||||||||||||||||||||||
1743578 | 1743578 | CO | school | 803450 | 900 | Douglas County Re 1 | 80345001960 | 5045 | Legacy Point Elementary School | Regular School | No | Elementary | PK | 05 | 2021 | grade_4 | 30 | 0 | 6 | 0 | 0 | 0 | 0 | 19 | 17 | 36 | 30 | 0 | 6 | 0 | 0 | 0 | 0 | 19 | 17 | 36 | ||||||||||||||||||||||||||||||||||
1744218 | 1744218 | CO | school | 804530 | 980 | Harrison 2 | 80453006663 | 5763 | Mountain Vista Homeschool Academy | Regular School | No | Other | KG | 12 | 2021 | grade_4 | 29 | 2 | 1 | 0 | 0 | 0 | 1 | 19 | 14 | 33 | 29 | 2 | 1 | 0 | 0 | 0 | 1 | 19 | 14 | 33 | ||||||||||||||||||||||||||||||||||
1744872 | 1744872 | CO | school | 803060 | 1010 | Colorado Springs 11 | 80306000274 | 9618 | Rogers Elementary School | Regular School | No | Elementary | PK | 05 | 2021 | grade_4 | 8 | 4 | 19 | 0 | 1 | 0 | 4 | 19 | 17 | 36 | 8 | 4 | 19 | 0 | 1 | 0 | 4 | 19 | 17 | 36 | ||||||||||||||||||||||||||||||||||
1745806 | 1745806 | CO | school | 804260 | 1180 | Roaring Fork RE-1 | 80426001540 | 2063 | Crystal River Elementary School | Regular School | No | Elementary | PK | 04 | 2021 | grade_4 | 11 | 0 | 45 | 0 | 1 | 0 | 1 | 19 | 39 | 58 | 11 | 0 | 45 | 0 | 1 | 0 | 1 | 19 | 39 | 58 | ||||||||||||||||||||||||||||||||||
1747405 | 1747405 | CO | school | 802670 | 1500 | Burlington RE-6J | 80267000160 | 1144 | Burlington Elementary School | Regular School | No | Elementary | PK | 04 | 2021 | grade_4 | 33 | 0 | 23 | 2 | 0 | 0 | 0 | 19 | 39 | 58 | 33 | 0 | 23 | 2 | 0 | 0 | 0 | 19 | 39 | 58 | ||||||||||||||||||||||||||||||||||
1748005 | 1748005 | CO | school | 805400 | 1560 | Thompson R2-J | 80540001352 | 1323 | Carrie Martin Elementary School | Regular School | No | Elementary | KG | 05 | 2021 | grade_4 | 29 | 0 | 1 | 0 | 0 | 0 | 1 | 19 | 12 | 31 | 29 | 0 | 1 | 0 | 0 | 0 | 1 | 19 | 12 | 31 | ||||||||||||||||||||||||||||||||||
1748667 | 1748667 | CO | school | 804350 | 2000 | Mesa County Valley 51 | 80435000615 | 5244 | Loma Elementary School | Regular School | No | Elementary | PK | 05 | 2021 | grade_4 | 30 | 0 | 2 | 0 | 0 | 0 | 1 | 19 | 14 | 33 | 30 | 0 | 2 | 0 | 0 | 0 | 1 | 19 | 14 | 33 | ||||||||||||||||||||||||||||||||||
1749159 | 1749159 | CO | school | 807290 | 2515 | Wiggins RE-50(J) | 80729001257 | 9576 | Wiggins Elementary School | Regular School | No | Elementary | PK | 06 | 2021 | grade_4 | 34 | 0 | 16 | 1 | 0 | 0 | 0 | 19 | 32 | 51 | 34 | 0 | 16 | 1 | 0 | 0 | 0 | 19 | 32 | 51 | ||||||||||||||||||||||||||||||||||
1749195 | 1749195 | CO | school | 806270 | 2530 | Rocky Ford R-2 | 80627001101 | 5114 | Jefferson Intermediate School | Regular School | No | Elementary | 03 | 06 | 2021 | grade_4 | 13 | 1 | 40 | 0 | 0 | 0 | 1 | 19 | 36 | 55 | 13 | 1 | 40 | 0 | 0 | 0 | 1 | 19 | 36 | 55 | ||||||||||||||||||||||||||||||||||
1750274 | 1750274 | CO | school | 806810 | 3000 | Summit RE-1 | 80681001167 | 8376 | Silverthorne Elementary School | Regular School | No | Elementary | PK | 05 | 2021 | grade_4 | 11 | 0 | 33 | 0 | 0 | 0 | 1 | 19 | 26 | 45 | 11 | 0 | 33 | 0 | 0 | 0 | 1 | 19 | 26 | 45 | ||||||||||||||||||||||||||||||||||
1751426 | 1751426 | CO | school | 800020 | 8001 | Charter School Institute | 80002006635 | 8821 | Two Rivers Community School | Regular School | Yes | Elementary | KG | 08 | 2021 | grade_4 | 24 | 0 | 13 | 0 | 1 | 0 | 1 | 19 | 20 | 39 | 24 | 0 | 13 | 0 | 1 | 0 | 1 | 19 | 20 | 39 | ||||||||||||||||||||||||||||||||||
1751503 | 1751503 | CO | school | 800282 | 9170 | Education reEnvisioned BOCES | 80028206752 | 1448 | Colorado Preparatory Academy Elementary School | Regular School | No | Elementary | KG | 05 | 2021 | grade_4 | 220 | 32 | 110 | 2 | 5 | 1 | 29 | 199 | 200 | 399 | 220 | 32 | 110 | 2 | 5 | 1 | 29 | 199 | 200 | 399 | ||||||||||||||||||||||||||||||||||
1740622 | 1740622 | CO | school | 802760 | 270 | Campo RE-6 | 80276000169 | 1248 | Campo Elementary School | Regular School | No | Elementary | PK | 05 | 2021 | grade_4 | 2 | 0 | 1 | 0 | 0 | 0 | 1 | 2 | 2 | 4 | 2 | 0 | 1 | 0 | 0 | 0 | 1 | 2 | 2 | 4 | ||||||||||||||||||||||||||||||||||
1743364 | 1743364 | CO | school | 803450 | 900 | Douglas County Re 1 | 80345000439 | 1578 | Cherry Valley Elementary School | Regular School | No | Elementary | KG | 06 | 2021 | grade_4 | 2 | 0 | 1 | 0 | 0 | 0 | 0 | 2 | 1 | 3 | 2 | 0 | 1 | 0 | 0 | 0 | 0 | 2 | 1 | 3 |
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]);