enrollments
Data source: Big Local News · About: Big Local
4,236 rows where grade = "grade_7" and state = "CO" sorted by total
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
710051 | 710051 | CO | school | 806090 | 240 | PRITCHETT RE-3 | 80609001952 | 7176 | PRITCHETT MIDDLE SCHOOL | Regular School | No | Middle | 06 | 08 | 2017 | grade_7 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 1 | ||||||||||||||||||||||||||||||||||
710781 | 710781 | CO | school | 802490 | 480 | BOULDER VALLEY RE 2 | 80249002013 | 4496 | JUSTICE HIGH CHARTER SCHOOL | Alternative School | Yes | Other | 06 | 12 | 2017 | grade_7 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 1 | 1 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 1 | 1 | ||||||||||||||||||||||||||||||||||
715075 | 715075 | CO | school | 802790 | 1140 | CANON CITY RE-1 | 80279006536 | 419 | CANON ONLINE ACADEMY | Regular School | No | Other | 06 | 12 | 2017 | grade_7 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | ||||||||||||||||||||||||||||||||||
717069 | 717069 | CO | school | 1550 | POUDRE R-1 | 0 | Not a school | 2017 | grade_7 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | |||||||||||||||||||||||||||||||||||||||||
718935 | 718935 | CO | school | 804710 | 2620 | HOLYOKE RE-1J | 80471006610 | 2686 | HOLYOKE ALTERNATIVE SCHOOL | Alternative School | No | High | 07 | 12 | 2017 | grade_7 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 1 | 1 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 1 | 1 | ||||||||||||||||||||||||||||||||||
720548 | 720548 | CO | school | 804440 | 3148 | PAWNEE RE-12 | 80444000653 | 6812 | PAWNEE SCHOOL PK-12 | Regular School | No | Other | PK | 12 | 2017 | grade_7 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 1 | ||||||||||||||||||||||||||||||||||
837136 | 837136 | CO | school | 180 | ADAMS-ARAPAHOE 28J | 1 | FACILITIES WITH DISTRICT RUN EDUCATION | 2016 | grade_7 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 1 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 1 | |||||||||||||||||||||||||||||||||||||||||
837725 | 837725 | CO | school | 806990 | 260 | VILAS RE-5 | 80699001805 | 9085 | V.I.L.A.S. ONLINE SCHOOL | Regular School | No | 1.0 | KG | 08 | 2016 | grade_7 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 1 | ||||||||||||||||||||||||||||||||||
838739 | 838739 | CO | school | 805100 | 550 | NORTH CONEJOS RE-1J | 80510006601 | 6339 | NORTH CONEJOS ALTERNATIVE PROGRAM | Alternative Education School | No | 4.0 | KG | 12 | 2016 | grade_7 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 1 | 1 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 1 | 1 | ||||||||||||||||||||||||||||||||||
841162 | 841162 | CO | school | 803540 | 910 | EAGLE COUNTY RE 50 | 80354006533 | 9701 | WORLD ACADEMY | Regular School | No | 4.0 | KG | 12 | 2016 | grade_7 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | ||||||||||||||||||||||||||||||||||
844651 | 844651 | CO | school | 1550 | POUDRE R-1 | 0 | Not a school | 2016 | grade_7 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 1 | |||||||||||||||||||||||||||||||||||||||||
845477 | 845477 | CO | school | 804890 | 1810 | KARVAL RE-23 | 80489000815 | 4506 | KARVAL JUNIOR-SENIOR HIGH SCHOOL | Regular School | No | 4.0 | 06 | 12 | 2016 | grade_7 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | ||||||||||||||||||||||||||||||||||
845974 | 845974 | CO | school | 805730 | 2020 | MOFFAT COUNTY RE:NO 1 | 80573000981 | 5962 | MOFFAT COUNTY HIGH SCHOOL | Regular School | No | 3.0 | 09 | 12 | 2016 | grade_7 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 1 | ||||||||||||||||||||||||||||||||||
848504 | 848504 | CO | school | 899300 | 9050 | SAN JUAN BOCES | 89930006497 | 8121 | SOUTHWEST COLORADO E-SCHOOL | Regular School | No | 4.0 | 06 | 12 | 2016 | grade_7 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | ||||||||||||||||||||||||||||||||||
1739974 | 1739974 | CO | school | 180 | Adams-Arapahoe 28J | 1 | Facilities with District Run Education | 2021 | grade_7 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | |||||||||||||||||||||||||||||||||||||||||
1740631 | 1740631 | CO | school | 802760 | 270 | Campo RE-6 | 80276000170 | 1252 | Campo Undivided High School | Regular School | No | High | 06 | 12 | 2021 | grade_7 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 1 | ||||||||||||||||||||||||||||||||||
1745263 | 1745263 | CO | school | 806060 | 1060 | Peyton 23 Jt | 80606006692 | 6626 | Peyton Online Academy | Regular School | No | Other | KG | 12 | 2021 | grade_7 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 1 | ||||||||||||||||||||||||||||||||||
1746623 | 1746623 | CO | school | 804800 | 1420 | Jefferson County R-1 | 80480006306 | 4798 | Connections Learning Center on the Earle Johnson Campus | Alternative School | No | Middle | 06 | 08 | 2021 | grade_7 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | ||||||||||||||||||||||||||||||||||
1746789 | 1746789 | CO | school | 804800 | 1420 | Jefferson County R-1 | 80480001607 | 5994 | Montessori Peaks Charter Academy | Regular School | Yes | Elementary | PK | 08 | 2021 | grade_7 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | ||||||||||||||||||||||||||||||||||
1747833 | 1747833 | CO | school | 803990 | 1550 | Poudre R-1 | 80399006564 | 7043 | PSD Options School | Regular School | No | Elementary | KG | 08 | 2021 | grade_7 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | ||||||||||||||||||||||||||||||||||
1748315 | 1748315 | CO | school | 804980 | 1760 | Kim Reorganized 88 | 80498000823 | 4694 | Kim Undivided High School | Regular School | No | High | 06 | 12 | 2021 | grade_7 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | ||||||||||||||||||||||||||||||||||
1802766 | 1802766 | CO | school | 803330 | 870 | Delta County 50(J) | 80333001953 | 2155 | Grand Mesa Choice Academy | Alternative School | No | High | 07 | 12 | 2020 | grade_7 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | ||||||||||||||||||||||||||||||||||
1806393 | 1806393 | CO | school | 804500 | 1070 | Hanover 28 | 80450006720 | 3941 | Hanover Online Academy | Regular School | No | High | 06 | 12 | 2020 | grade_7 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 1 | ||||||||||||||||||||||||||||||||||
1807885 | 1807885 | CO | school | 804800 | 1420 | Jefferson County R-1 | 80480001607 | 5994 | Montessori Peaks Charter Academy | Regular School | Yes | Elementary | PK | 08 | 2020 | grade_7 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 1 | 1 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 1 | 1 | ||||||||||||||||||||||||||||||||||
1812189 | 1812189 | CO | school | 800019 | 3230 | Liberty J-4 | 80001901744 | 5123 | Liberty School | Career and Technical School | No | Other | PK | 12 | 2020 | grade_7 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | ||||||||||||||||||||||||||||||||||
1897224 | 1897224 | CO | school | 803360 | 880 | DENVER COUNTY 1 | 80336001724 | 40 | RIDGE VIEW ACADEMY CHARTER SCHOOL | Alternative School | Yes | High | 07 | 12 | 2018 | grade_7 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | ||||||||||||||||||||||||||||||||||
1899837 | 1899837 | CO | school | 804080 | 1000 | FOUNTAIN 8 | 80408000096 | 203 | WELTE EDUCATION CENTER | Alternative School | No | High | 06 | 12 | 2018 | grade_7 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 1 | ||||||||||||||||||||||||||||||||||
1903681 | 1903681 | CO | school | 803810 | 1570 | ESTES PARK R-3 | 80381006426 | 2788 | ESTES PARK OPTIONS SCHOOL | Alternative School | No | Other | KG | 12 | 2018 | grade_7 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | ||||||||||||||||||||||||||||||||||
1903856 | 1903856 | CO | school | 1828 | VALLEY RE-1 | 6 | COUNTY JAILS WITH DISTRICT RUN EDUCATION | 2018 | grade_7 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 1 | |||||||||||||||||||||||||||||||||||||||||
1904110 | 1904110 | CO | school | 804350 | 2000 | MESA COUNTY VALLEY 51 | 80435000611 | 3350 | GATEWAY SCHOOL | Regular School | No | Other | PK | 12 | 2018 | grade_7 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 1 | ||||||||||||||||||||||||||||||||||
1931393 | 1931393 | CO | school | 806900 | 20 | ADAMS 12 FIVE STAR SCHOOLS | 80690006550 | 6956 | PATHWAYS FUTURE CENTER | Alternative School | No | Other | KG | 12 | 2019 | grade_7 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | ||||||||||||||||||||||||||||||||||
1932689 | 1932689 | CO | school | 180 | ADAMS-ARAPAHOE 28J | 1 | FACILITIES WITH DISTRICT RUN EDUCATION | 2019 | grade_7 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 1 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 1 | 0 | 1 | |||||||||||||||||||||||||||||||||||||||||
1934012 | 1934012 | CO | school | 802490 | 480 | BOULDER VALLEY RE 2 | 80249002013 | 4496 | JUSTICE HIGH CHARTER SCHOOL | Alternative School | Yes | High | 06 | 12 | 2019 | grade_7 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | ||||||||||||||||||||||||||||||||||
1934326 | 1934326 | CO | school | 805100 | 550 | NORTH CONEJOS RE-1J | 80510006601 | 6339 | NORTH CONEJOS ALTERNATIVE PROGRAM | Alternative School | No | Other | KG | 12 | 2019 | grade_7 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 1 | ||||||||||||||||||||||||||||||||||
1934456 | 1934456 | CO | school | 803330 | 870 | DELTA COUNTY 50(J) | 80333001953 | 2155 | GRAND MESA CHOICE ACADEMY | Alternative School | No | High | 07 | 12 | 2019 | grade_7 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | ||||||||||||||||||||||||||||||||||
1936928 | 1936928 | CO | school | 801980 | 960 | AGATE 300 | 80198000021 | 48 | AGATE JUNIOR SENIOR HIGH SCHOOL | Regular School | No | High | 06 | 12 | 2019 | grade_7 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | ||||||||||||||||||||||||||||||||||
1938075 | 1938075 | CO | school | 804500 | 1070 | HANOVER 28 | 80450006720 | 3941 | HANOVER ONLINE ACADEMY | Regular School | No | High | 06 | 12 | 2019 | grade_7 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | ||||||||||||||||||||||||||||||||||
1941230 | 1941230 | CO | school | 804890 | 1810 | KARVAL RE-23 | 80489000815 | 4506 | KARVAL JUNIOR-SENIOR HIGH SCHOOL | Regular School | No | High | 07 | 12 | 2019 | grade_7 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 1 | ||||||||||||||||||||||||||||||||||
1941953 | 1941953 | CO | school | 805850 | 2190 | WEST END RE-2 | 80585001693 | 6718 | PARADOX VALLEY CHARTER SCHOOL | Regular School | Yes | Other | PK | 12 | 2019 | grade_7 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 1 | ||||||||||||||||||||||||||||||||||
1942239 | 1942239 | CO | school | 804710 | 2620 | HOLYOKE RE-1J | 80471006610 | 2686 | HOLYOKE ALTERNATIVE SCHOOL | Alternative School | No | High | 07 | 12 | 2019 | grade_7 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 1 | 1 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 1 | 1 | ||||||||||||||||||||||||||||||||||
1135451 | 1135451 | CO | school | 802760 | 270 | CAMPO RE-6 | 80276000170 | 1252 | CAMPO UNDIVIDED HIGH SCHOOL | Regular School | No | 4.0 | 06 | 12 | 2015 | grade_7 | 1.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 1.0 | 1.0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 1 | ||||||||||||||||||||||||||||||||||
1140276 | 1140276 | CO | school | 802790 | 1140 | CANON CITY RE-1 | 80279006536 | 419 | CANON ONLINE ACADEMY | Regular School | No | 4.0 | 06 | 12 | 2015 | grade_7 | 1.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 1.0 | 0.0 | 1.0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | ||||||||||||||||||||||||||||||||||
1143785 | 1143785 | CO | school | 805850 | 2190 | WEST END RE-2 | 80585001693 | 6718 | PARADOX VALLEY CHARTER SCHOOL | Regular School | Yes | 4.0 | PK | 12 | 2015 | grade_7 | 0.0 | 1.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 1.0 | 1.0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 1 | ||||||||||||||||||||||||||||||||||
1144066 | 1144066 | CO | school | 804710 | 2620 | HOLYOKE RE-1J | 80471006610 | 2686 | HOLYOKE ALTERNATIVE SCHOOL | Alternative Education School | No | 3.0 | 07 | 12 | 2015 | grade_7 | 1.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 1.0 | 1.0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 1 | ||||||||||||||||||||||||||||||||||
718370 | 718370 | CO | school | 803150 | 2010 | CREEDE SCHOOL DISTRICT | 80315000279 | 1966 | CREEDE SCHOOL | Regular School | No | Other | PK | 12 | 2017 | grade_7 | 7 | 0 | 2 | 0 | 0 | 0 | 1 | 4 | 6 | 10 | 7 | 0 | 2 | 0 | 0 | 0 | 1 | 4 | 6 | 10 | ||||||||||||||||||||||||||||||||||
718790 | 718790 | CO | school | 805520 | 2535 | MANZANOLA 3J | 80552001375 | 5506 | MANZANOLA JUNIOR-SENIOR HIGH SCHOOL | Regular School | No | Other | 06 | 12 | 2017 | grade_7 | 2 | 0 | 8 | 0 | 0 | 0 | 0 | 5 | 5 | 10 | 2 | 0 | 8 | 0 | 0 | 0 | 0 | 5 | 5 | 10 | ||||||||||||||||||||||||||||||||||
719664 | 719664 | CO | school | 805700 | 2800 | MOFFAT 2 | 80570001511 | 2018 | CRESTONE CHARTER SCHOOL | Regular School | Yes | Other | KG | 12 | 2017 | grade_7 | 9 | 0 | 0 | 0 | 0 | 0 | 1 | 5 | 5 | 10 | 9 | 0 | 0 | 0 | 0 | 0 | 1 | 5 | 5 | 10 | ||||||||||||||||||||||||||||||||||
844951 | 844951 | CO | school | 803990 | 1550 | POUDRE R-1 | 80399006431 | 7198 | PSD GLOBAL ACADEMY | Regular School | No | 4.0 | KG | 12 | 2016 | grade_7 | 8 | 0 | 2 | 0 | 0 | 0 | 0 | 3 | 7 | 10 | 8 | 0 | 2 | 0 | 0 | 0 | 0 | 3 | 7 | 10 | ||||||||||||||||||||||||||||||||||
845388 | 845388 | CO | school | 1620 | AGUILAR REORGANIZED 6 | 66 | AGUILAR JUNIOR-SENIOR HIGH SCHOOL | 2016 | grade_7 | 1 | 0 | 9 | 0 | 0 | 0 | 0 | 5 | 5 | 10 | 1 | 0 | 9 | 0 | 0 | 0 | 0 | 5 | 5 | 10 | |||||||||||||||||||||||||||||||||||||||||
847233 | 847233 | CO | school | 805700 | 2800 | MOFFAT 2 | 80570001511 | 2018 | CRESTONE CHARTER SCHOOL | Regular School | Yes | 4.0 | KG | 12 | 2016 | grade_7 | 8 | 0 | 2 | 0 | 0 | 0 | 0 | 3 | 7 | 10 | 8 | 0 | 2 | 0 | 0 | 0 | 0 | 3 | 7 | 10 | ||||||||||||||||||||||||||||||||||
848086 | 848086 | CO | school | 802550 | 3146 | BRIGGSDALE RE-10 | 80255000143 | 1012 | BRIGGSDALE UNDIVIDED HIGH SCHOOL | Regular School | No | 4.0 | 06 | 12 | 2016 | grade_7 | 7 | 0 | 2 | 0 | 1 | 0 | 0 | 5 | 5 | 10 | 7 | 0 | 2 | 0 | 1 | 0 | 0 | 5 | 5 | 10 | ||||||||||||||||||||||||||||||||||
1747317 | 1747317 | CO | school | 803510 | 1430 | Eads RE-1 | 80351001277 | 2332 | Eads Middle School | Regular School | No | Middle | 06 | 08 | 2021 | grade_7 | 8 | 0 | 1 | 0 | 0 | 0 | 1 | 6 | 4 | 10 | 8 | 0 | 1 | 0 | 0 | 0 | 1 | 6 | 4 | 10 | ||||||||||||||||||||||||||||||||||
1747396 | 1747396 | CO | school | 802460 | 1490 | Bethune R-5 | 80246000095 | 842 | Bethune Public Schools | Regular School | No | Other | PK | 12 | 2021 | grade_7 | 4 | 0 | 6 | 0 | 0 | 0 | 0 | 3 | 7 | 10 | 4 | 0 | 6 | 0 | 0 | 0 | 0 | 3 | 7 | 10 | ||||||||||||||||||||||||||||||||||
1748070 | 1748070 | CO | school | 805400 | 1560 | Thompson R2-J | 80540006558 | 5121 | LEAP School | Regular School | No | Other | KG | 12 | 2021 | grade_7 | 9 | 0 | 1 | 0 | 0 | 0 | 0 | 4 | 6 | 10 | 9 | 0 | 1 | 0 | 0 | 0 | 0 | 4 | 6 | 10 | ||||||||||||||||||||||||||||||||||
1750032 | 1750032 | CO | school | 806660 | 2770 | Steamboat Springs RE-2 | 80666001749 | 6363 | North Routt Charter School | Regular School | Yes | Elementary | PK | 08 | 2021 | grade_7 | 9 | 0 | 1 | 0 | 0 | 0 | 0 | 3 | 7 | 10 | 9 | 0 | 1 | 0 | 0 | 0 | 0 | 3 | 7 | 10 | ||||||||||||||||||||||||||||||||||
1751482 | 1751482 | CO | school | 899300 | 9050 | San Juan BOCES | 89930006497 | 8121 | Southwest Colorado eSchool | Regular School | No | High | 06 | 12 | 2021 | grade_7 | 9 | 1 | 0 | 0 | 0 | 0 | 0 | 5 | 5 | 10 | 9 | 1 | 0 | 0 | 0 | 0 | 0 | 5 | 5 | 10 | ||||||||||||||||||||||||||||||||||
1801646 | 1801646 | CO | school | 806990 | 260 | Vilas RE-5 | 80699001207 | 9100 | Vilas Undivided High School | Regular School | No | High | 07 | 12 | 2020 | grade_7 | 9 | 0 | 1 | 0 | 0 | 0 | 0 | 8 | 2 | 10 | 9 | 0 | 1 | 0 | 0 | 0 | 0 | 8 | 2 | 10 | ||||||||||||||||||||||||||||||||||
1804234 | 1804234 | CO | school | 803420 | 890 | Dolores County RE No.2 | 80342000429 | 2216 | Dove Creek High School | Regular School | No | High | 06 | 12 | 2020 | grade_7 | 8 | 0 | 2 | 0 | 0 | 0 | 0 | 4 | 6 | 10 | 8 | 0 | 2 | 0 | 0 | 0 | 0 | 4 | 6 | 10 | ||||||||||||||||||||||||||||||||||
1807157 | 1807157 | CO | school | 807080 | 1390 | Huerfano Re-1 | 80708001211 | 3306 | Gardner Elementary School | Regular School | No | Elementary | PK | 08 | 2020 | grade_7 | 2 | 1 | 7 | 0 | 0 | 0 | 0 | 3 | 7 | 10 | 2 | 1 | 7 | 0 | 0 | 0 | 0 | 3 | 7 | 10 | ||||||||||||||||||||||||||||||||||
1807669 | 1807669 | CO | school | 804800 | 1420 | Jefferson County R-1 | 80480006439 | 4408 | Jeffco Virtual Academy | Alternative School | No | High | 06 | 12 | 2020 | grade_7 | 7 | 0 | 1 | 0 | 0 | 0 | 2 | 5 | 5 | 10 | 7 | 0 | 1 | 0 | 0 | 0 | 2 | 5 | 5 | 10 | ||||||||||||||||||||||||||||||||||
1808432 | 1808432 | CO | school | 803510 | 1430 | Eads RE-1 | 80351001277 | 2332 | Eads Middle School | Regular School | No | Middle | 06 | 08 | 2020 | grade_7 | 9 | 0 | 1 | 0 | 0 | 0 | 0 | 5 | 5 | 10 | 9 | 0 | 1 | 0 | 0 | 0 | 0 | 5 | 5 | 10 | ||||||||||||||||||||||||||||||||||
1808585 | 1808585 | CO | school | 803480 | 1520 | Durango 9-R | 80348006614 | 2097 | District 9-R Shared School | Regular School | No | Other | KG | 12 | 2020 | grade_7 | 8 | 0 | 2 | 0 | 0 | 0 | 0 | 6 | 4 | 10 | 8 | 0 | 2 | 0 | 0 | 0 | 0 | 6 | 4 | 10 | ||||||||||||||||||||||||||||||||||
1811248 | 1811248 | CO | school | 805700 | 2800 | Moffat 2 | 80570000974 | 5958 | Moffat Prek-12 School | Regular School | No | Other | PK | 12 | 2020 | grade_7 | 9 | 0 | 0 | 0 | 0 | 0 | 1 | 6 | 4 | 10 | 9 | 0 | 0 | 0 | 0 | 0 | 1 | 6 | 4 | 10 | ||||||||||||||||||||||||||||||||||
1811289 | 1811289 | CO | school | 806570 | 2820 | Silverton 1 | 80657001985 | 7902 | Silverton Middle School | Regular School | No | Middle | 06 | 08 | 2020 | grade_7 | 5 | 0 | 5 | 0 | 0 | 0 | 0 | 6 | 4 | 10 | 5 | 0 | 5 | 0 | 0 | 0 | 0 | 6 | 4 | 10 | ||||||||||||||||||||||||||||||||||
1811508 | 1811508 | CO | school | 802220 | 3040 | Arickaree R-2 | 80222000042 | 308 | Arickaree Undivided High School | Regular School | No | High | 06 | 12 | 2020 | grade_7 | 7 | 1 | 2 | 0 | 0 | 0 | 0 | 2 | 8 | 10 | 7 | 1 | 2 | 0 | 0 | 0 | 0 | 2 | 8 | 10 | ||||||||||||||||||||||||||||||||||
1897549 | 1897549 | CO | school | 803360 | 880 | DENVER COUNTY 1 | 80336006516 | 2188 | DENVER CENTER FOR 21ST LEARNING AT WYMAN | Alternative School | No | High | 06 | 12 | 2018 | grade_7 | 3 | 0 | 7 | 0 | 0 | 0 | 0 | 4 | 6 | 10 | 3 | 0 | 7 | 0 | 0 | 0 | 0 | 4 | 6 | 10 | ||||||||||||||||||||||||||||||||||
1900968 | 1900968 | CO | school | 803630 | 1120 | EDISON 54 JT | 80363001278 | 2526 | EDISON JUNIOR-SENIOR HIGH SCHOOL | Regular School | No | High | 06 | 12 | 2018 | grade_7 | 10 | 0 | 0 | 0 | 0 | 0 | 0 | 6 | 4 | 10 | 10 | 0 | 0 | 0 | 0 | 0 | 0 | 6 | 4 | 10 | ||||||||||||||||||||||||||||||||||
1902901 | 1902901 | CO | school | 803480 | 1520 | DURANGO 9-R | 80348006614 | 2097 | DISTRICT 9-R SHARED SCHOOL | Regular School | No | Other | KG | 12 | 2018 | grade_7 | 9 | 0 | 0 | 0 | 0 | 0 | 1 | 4 | 6 | 10 | 9 | 0 | 0 | 0 | 0 | 0 | 1 | 4 | 6 | 10 | ||||||||||||||||||||||||||||||||||
1903761 | 1903761 | CO | school | 802010 | 1620 | AGUILAR REORGANIZED 6 | 80201000023 | 66 | AGUILAR JUNIOR-SENIOR HIGH SCHOOL | Regular School | No | High | 07 | 12 | 2018 | grade_7 | 3 | 0 | 7 | 0 | 0 | 0 | 0 | 7 | 3 | 10 | 3 | 0 | 7 | 0 | 0 | 0 | 0 | 7 | 3 | 10 | ||||||||||||||||||||||||||||||||||
1904799 | 1904799 | CO | school | 805970 | 2580 | OURAY R-1 | 80597001662 | 6598 | OURAY MIDDLE SCHOOL | Regular School | No | Middle | 07 | 08 | 2018 | grade_7 | 8 | 0 | 1 | 0 | 1 | 0 | 0 | 2 | 8 | 10 | 8 | 0 | 1 | 0 | 1 | 0 | 0 | 2 | 8 | 10 | ||||||||||||||||||||||||||||||||||
1905540 | 1905540 | CO | school | 806660 | 2770 | STEAMBOAT SPRINGS RE-2 | 80666001749 | 6363 | NORTH ROUTT CHARTER SCHOOL | Regular School | Yes | Elementary | KG | 08 | 2018 | grade_7 | 9 | 0 | 1 | 0 | 0 | 0 | 0 | 6 | 4 | 10 | 9 | 0 | 1 | 0 | 0 | 0 | 0 | 6 | 4 | 10 | ||||||||||||||||||||||||||||||||||
1905902 | 1905902 | CO | school | 805340 | 3060 | LONE STAR 101 | 80534006376 | 5238 | LONE STAR MIDDLE SCHOOL | Regular School | No | Middle | 06 | 08 | 2018 | grade_7 | 9 | 0 | 1 | 0 | 0 | 0 | 0 | 5 | 5 | 10 | 9 | 0 | 1 | 0 | 0 | 0 | 0 | 5 | 5 | 10 | ||||||||||||||||||||||||||||||||||
1934207 | 1934207 | CO | school | 806330 | 500 | SALIDA R-32 | 80633006500 | 1554 | CREST ACADEMY | Regular School | No | Middle | 05 | 08 | 2019 | grade_7 | 7 | 0 | 3 | 0 | 0 | 0 | 0 | 4 | 6 | 10 | 7 | 0 | 3 | 0 | 0 | 0 | 0 | 4 | 6 | 10 | ||||||||||||||||||||||||||||||||||
1939333 | 1939333 | CO | school | 804800 | 1420 | JEFFERSON COUNTY R-1 | 80480006439 | 4408 | JEFFCO VIRTUAL ACADEMY | Alternative School | No | High | 06 | 12 | 2019 | grade_7 | 3 | 1 | 2 | 1 | 1 | 0 | 2 | 7 | 3 | 10 | 3 | 1 | 2 | 1 | 1 | 0 | 2 | 7 | 3 | 10 | ||||||||||||||||||||||||||||||||||
1939840 | 1939840 | CO | school | 804800 | 1420 | JEFFERSON COUNTY R-1 | 80480006307 | 8036 | SOBESKY ACADEMY | Special Education School | No | Other | KG | 12 | 2019 | grade_7 | 4 | 0 | 5 | 1 | 0 | 0 | 0 | 9 | 1 | 10 | 4 | 0 | 5 | 1 | 0 | 0 | 0 | 9 | 1 | 10 | ||||||||||||||||||||||||||||||||||
1944253 | 1944253 | CO | school | 800020 | 8001 | CHARTER SCHOOL INSTITUTE | 80002006651 | 8061 | SALIDA MONTESSORI CHARTER SCHOOL | Regular School | Yes | Elementary | PK | 08 | 2019 | grade_7 | 8 | 0 | 1 | 0 | 0 | 0 | 1 | 6 | 4 | 10 | 8 | 0 | 1 | 0 | 0 | 0 | 1 | 6 | 4 | 10 | ||||||||||||||||||||||||||||||||||
1136550 | 1136550 | CO | school | 803330 | 870 | DELTA COUNTY 50(J) | 80333002001 | 2152 | DELTA ACADEMY OF APPLIED LEARNING | Alternative Education School | No | 2.0 | 05 | 08 | 2015 | grade_7 | 8.0 | 0.0 | 2.0 | 0.0 | 0.0 | 0.0 | 0.0 | 6.0 | 4.0 | 10.0 | 8 | 0 | 2 | 0 | 0 | 0 | 0 | 6 | 4 | 10 | ||||||||||||||||||||||||||||||||||
1146020 | 1146020 | CO | school | 800020 | 8001 | CHARTER SCHOOL INSTITUTE | 80002001612 | 9785 | YOUTH & FAMILY ACADEMY CHARTER | Alternative Education School | Yes | 3.0 | 07 | 12 | 2015 | grade_7 | 1.0 | 0.0 | 9.0 | 0.0 | 0.0 | 0.0 | 0.0 | 5.0 | 5.0 | 10.0 | 1 | 0 | 9 | 0 | 0 | 0 | 0 | 5 | 5 | 10 | ||||||||||||||||||||||||||||||||||
710542 | 710542 | CO | school | 805370 | 470 | ST VRAIN VALLEY RE 1J | 80537001572 | 8927 | TWIN PEAKS CHARTER ACADEMY | Regular School | Yes | Other | KG | 12 | 2017 | grade_7 | 48 | 2 | 42 | 1 | 4 | 0 | 3 | 44 | 56 | 100 | 48 | 2 | 42 | 1 | 4 | 0 | 3 | 44 | 56 | 100 | ||||||||||||||||||||||||||||||||||
717042 | 717042 | CO | school | 802400 | 1530 | BAYFIELD 10 JT-R | 80240000089 | 636 | BAYFIELD MIDDLE SCHOOL | Regular School | No | Middle | 06 | 08 | 2017 | grade_7 | 77 | 0 | 15 | 2 | 0 | 0 | 6 | 52 | 48 | 100 | 77 | 0 | 15 | 2 | 0 | 0 | 6 | 52 | 48 | 100 | ||||||||||||||||||||||||||||||||||
837537 | 837537 | CO | school | 802340 | 180 | ADAMS-ARAPAHOE 28J | 80234006483 | 9083 | VISTA PEAK P-8 EXPLORATORY | Regular School | No | 1.0 | PK | 08 | 2016 | grade_7 | 38 | 5 | 46 | 1 | 2 | 1 | 7 | 50 | 50 | 100 | 38 | 5 | 46 | 1 | 2 | 1 | 7 | 50 | 50 | 100 | ||||||||||||||||||||||||||||||||||
1740226 | 1740226 | CO | school | 802340 | 180 | Adams-Arapahoe 28J | 80234001916 | 5298 | Lotus School for Excellence | Regular School | Yes | Other | KG | 12 | 2021 | grade_7 | 13 | 42 | 42 | 0 | 1 | 0 | 2 | 54 | 46 | 100 | 13 | 42 | 42 | 0 | 1 | 0 | 2 | 54 | 46 | 100 | ||||||||||||||||||||||||||||||||||
1740824 | 1740824 | CO | school | 805370 | 470 | St Vrain Valley RE1J | 80537001890 | 2964 | Flagstaff Charter Academy | Regular School | Yes | Elementary | PK | 08 | 2021 | grade_7 | 80 | 2 | 11 | 1 | 4 | 1 | 1 | 47 | 53 | 100 | 80 | 2 | 11 | 1 | 4 | 1 | 1 | 47 | 53 | 100 | ||||||||||||||||||||||||||||||||||
1742195 | 1742195 | CO | school | 803360 | 880 | Denver County 1 | 80336006528 | 2209 | DCIS at Montbello | Regular School | No | High | 06 | 12 | 2021 | grade_7 | 2 | 13 | 77 | 0 | 0 | 6 | 2 | 57 | 43 | 100 | 2 | 13 | 77 | 0 | 0 | 6 | 2 | 57 | 43 | 100 | ||||||||||||||||||||||||||||||||||
1743994 | 1743994 | CO | school | 803540 | 910 | Eagle County RE 50 | 80354001478 | 5742 | Homestake Peak School | Regular School | No | Elementary | PK | 08 | 2021 | grade_7 | 30 | 0 | 67 | 1 | 0 | 0 | 2 | 46 | 54 | 100 | 30 | 0 | 67 | 1 | 0 | 0 | 2 | 46 | 54 | 100 | ||||||||||||||||||||||||||||||||||
1802614 | 1802614 | CO | school | 805100 | 550 | North Conejos RE-1J | 80510000842 | 1276 | Centauri Middle School | Regular School | No | Middle | 06 | 08 | 2020 | grade_7 | 49 | 0 | 50 | 0 | 1 | 0 | 0 | 50 | 50 | 100 | 49 | 0 | 50 | 0 | 1 | 0 | 0 | 50 | 50 | 100 | ||||||||||||||||||||||||||||||||||
1895626 | 1895626 | CO | school | 802340 | 180 | ADAMS-ARAPAHOE 28J | 80234001916 | 5298 | LOTUS SCHOOL FOR EXCELLENCE | Regular School | Yes | Other | KG | 12 | 2018 | grade_7 | 19 | 31 | 45 | 0 | 3 | 1 | 1 | 49 | 51 | 100 | 19 | 31 | 45 | 0 | 3 | 1 | 1 | 49 | 51 | 100 | ||||||||||||||||||||||||||||||||||
1937645 | 1937645 | CO | school | 803060 | 1010 | COLORADO SPRINGS 11 | 80306000272 | 9404 | WEST MIDDLE SCHOOL | Regular School | No | Middle | 06 | 08 | 2019 | grade_7 | 63 | 7 | 21 | 1 | 0 | 1 | 7 | 49 | 51 | 100 | 63 | 7 | 21 | 1 | 0 | 1 | 7 | 49 | 51 | 100 | ||||||||||||||||||||||||||||||||||
1140352 | 1140352 | CO | school | 803960 | 1150 | FREMONT RE-2 | 80396001595 | 3226 | FREMONT MIDDLE SCHOOL | Regular School | No | 2.0 | 06 | 08 | 2015 | grade_7 | 75.0 | 2.0 | 18.0 | 0.0 | 1.0 | 0.0 | 4.0 | 50.0 | 50.0 | 100.0 | 75 | 2 | 18 | 0 | 1 | 0 | 4 | 50 | 50 | 100 | ||||||||||||||||||||||||||||||||||
1144601 | 1144601 | CO | school | 806150 | 2700 | PUEBLO COUNTY 70 | 80615001085 | 9134 | VINELAND MIDDLE SCHOOL | Regular School | No | 2.0 | 06 | 08 | 2015 | grade_7 | 55.0 | 1.0 | 39.0 | 0.0 | 1.0 | 1.0 | 3.0 | 51.0 | 49.0 | 100.0 | 55 | 1 | 39 | 0 | 1 | 1 | 3 | 51 | 49 | 100 | ||||||||||||||||||||||||||||||||||
708875 | 708875 | CO | school | 806540 | 123 | SHERIDAN 2 | 80654001135 | 7837 | FORT LOGAN NORTHGATE | Regular School | No | Elementary | 03 | 08 | 2017 | grade_7 | 12 | 2 | 83 | 0 | 2 | 1 | 1 | 48 | 53 | 101 | 12 | 2 | 83 | 0 | 2 | 1 | 1 | 48 | 53 | 101 | ||||||||||||||||||||||||||||||||||
713207 | 713207 | CO | school | 803450 | 900 | DOUGLAS COUNTY RE 1 | 80345006690 | 6719 | PARKER PERFORMING ARTS | Regular School | Yes | Elementary | KG | 08 | 2017 | grade_7 | 69 | 3 | 21 | 0 | 1 | 0 | 7 | 25 | 76 | 101 | 69 | 3 | 21 | 0 | 1 | 0 | 7 | 25 | 76 | 101 | ||||||||||||||||||||||||||||||||||
836521 | 836521 | CO | school | 806540 | 123 | SHERIDAN 2 | 80654001135 | 7837 | FORT LOGAN NORTHGATE | Regular School | No | 1.0 | 03 | 08 | 2016 | grade_7 | 14 | 5 | 76 | 2 | 2 | 0 | 2 | 56 | 45 | 101 | 14 | 5 | 76 | 2 | 2 | 0 | 2 | 56 | 45 | 101 | ||||||||||||||||||||||||||||||||||
847820 | 847820 | CO | school | 804410 | 3120 | GREELEY 6 | 80441000637 | 1500 | CHAPPELOW K-8 MAGNET SCHOOL | Regular School | No | 1.0 | PK | 08 | 2016 | grade_7 | 49 | 1 | 47 | 0 | 0 | 0 | 4 | 47 | 54 | 101 | 49 | 1 | 47 | 0 | 0 | 0 | 4 | 47 | 54 | 101 | ||||||||||||||||||||||||||||||||||
1743704 | 1743704 | CO | school | 803450 | 900 | Douglas County Re 1 | 80345006690 | 6719 | Parker Performing Arts | Regular School | Yes | Elementary | KG | 08 | 2021 | grade_7 | 68 | 4 | 17 | 2 | 2 | 0 | 8 | 29 | 72 | 101 | 68 | 4 | 17 | 2 | 2 | 0 | 8 | 29 | 72 | 101 | ||||||||||||||||||||||||||||||||||
1744166 | 1744166 | CO | school | 804530 | 980 | Harrison 2 | 80453000662 | 1306 | Carmel Middle School | Regular School | No | Middle | 06 | 08 | 2021 | grade_7 | 14 | 21 | 54 | 0 | 3 | 0 | 9 | 53 | 48 | 101 | 14 | 21 | 54 | 0 | 3 | 0 | 9 | 53 | 48 | 101 | ||||||||||||||||||||||||||||||||||
1745800 | 1745800 | CO | school | 804260 | 1180 | Roaring Fork RE-1 | 80426000586 | 1296 | Carbondale Middle School | Regular School | No | Middle | 05 | 08 | 2021 | grade_7 | 40 | 2 | 57 | 0 | 0 | 0 | 2 | 55 | 46 | 101 | 40 | 2 | 57 | 0 | 0 | 0 | 2 | 55 | 46 | 101 | ||||||||||||||||||||||||||||||||||
1750820 | 1750820 | CO | school | 804410 | 3120 | Greeley 6 | 80441001483 | 5660 | S. Christa McAuliffe STEM Academy | Regular School | No | Elementary | KG | 08 | 2021 | grade_7 | 35 | 0 | 59 | 0 | 4 | 0 | 3 | 56 | 45 | 101 | 35 | 0 | 59 | 0 | 4 | 0 | 3 | 56 | 45 | 101 | ||||||||||||||||||||||||||||||||||
1801205 | 1801205 | CO | school | 802340 | 180 | Adams-Arapahoe 28J | 80234006318 | 3471 | Global Village Academy Aurora | Regular School | Yes | Elementary | KG | 08 | 2020 | grade_7 | 14 | 18 | 63 | 0 | 1 | 0 | 5 | 55 | 46 | 101 | 14 | 18 | 63 | 0 | 1 | 0 | 5 | 55 | 46 | 101 | ||||||||||||||||||||||||||||||||||
1804154 | 1804154 | CO | school | 803360 | 880 | Denver County 1 | 80336006479 | 9390 | STRIVE Prep - Lake | Regular School | Yes | Middle | 06 | 08 | 2020 | grade_7 | 2 | 4 | 92 | 1 | 2 | 0 | 0 | 50 | 51 | 101 | 2 | 4 | 92 | 1 | 2 | 0 | 0 | 50 | 51 | 101 |
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]);