enrollments
Data source: Big Local News · About: Big Local
4,236 rows where grade = "grade_7" and state = "CO" sorted by school
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1905881 | 1905881 | CO | school | 802220 | 3040 | ARICKAREE R-2 | 80222000042 | 308 | ARICKAREE UNDIVIDED HIGH SCHOOL | Regular School | No | High | 06 | 12 | 2018 | grade_7 | 7 | 0 | 2 | 0 | 0 | 0 | 0 | 5 | 4 | 9 | 7 | 0 | 2 | 0 | 0 | 0 | 0 | 5 | 4 | 9 | ||||||||||||||||||||||||||||||||||
1943256 | 1943256 | CO | school | 802220 | 3040 | ARICKAREE R-2 | 80222000042 | 308 | ARICKAREE UNDIVIDED HIGH SCHOOL | Regular School | No | High | 06 | 12 | 2019 | grade_7 | 6 | 0 | 2 | 0 | 0 | 0 | 0 | 4 | 4 | 8 | 6 | 0 | 2 | 0 | 0 | 0 | 0 | 4 | 4 | 8 | ||||||||||||||||||||||||||||||||||
715549 | 715549 | CO | school | 804800 | 1420 | JEFFERSON COUNTY R-1 | 80480006489 | 109 | ARVADA K-8 | Regular School | No | Elementary | KG | 08 | 2017 | grade_7 | 50 | 3 | 67 | 1 | 2 | 0 | 1 | 63 | 61 | 124 | 50 | 3 | 67 | 1 | 2 | 0 | 1 | 63 | 61 | 124 | ||||||||||||||||||||||||||||||||||
843154 | 843154 | CO | school | 1420 | JEFFERSON COUNTY R-1 | 109 | ARVADA K-8 | 2016 | grade_7 | 67 | 3 | 68 | 0 | 5 | 0 | 9 | 82 | 70 | 152 | 67 | 3 | 68 | 0 | 5 | 0 | 9 | 82 | 70 | 152 | |||||||||||||||||||||||||||||||||||||||||
1140758 | 1140758 | CO | school | 804800 | 1420 | JEFFERSON COUNTY R-1 | 80480006489 | 109 | ARVADA K-8 | Regular School | No | 1.0 | KG | 08 | 2015 | grade_7 | 61.0 | 3.0 | 58.0 | 1.0 | 5.0 | 0.0 | 4.0 | 80.0 | 52.0 | 132.0 | 61 | 3 | 58 | 1 | 5 | 0 | 4 | 80 | 52 | 132 | ||||||||||||||||||||||||||||||||||
1901467 | 1901467 | CO | school | 804800 | 1420 | JEFFERSON COUNTY R-1 | 80480006489 | 109 | ARVADA K-8 | Regular School | No | Elementary | KG | 08 | 2018 | grade_7 | 56 | 2 | 76 | 3 | 5 | 0 | 4 | 79 | 67 | 146 | 56 | 2 | 76 | 3 | 5 | 0 | 4 | 79 | 67 | 146 | ||||||||||||||||||||||||||||||||||
1938883 | 1938883 | CO | school | 804800 | 1420 | JEFFERSON COUNTY R-1 | 80480006489 | 109 | ARVADA K-8 | Regular School | No | Elementary | KG | 08 | 2019 | grade_7 | 50 | 2 | 58 | 6 | 3 | 1 | 6 | 77 | 49 | 126 | 50 | 2 | 58 | 6 | 3 | 1 | 6 | 77 | 49 | 126 | ||||||||||||||||||||||||||||||||||
1935961 | 1935961 | CO | school | 803450 | 900 | DOUGLAS COUNTY RE 1 | 80345006760 | 79 | ASCENT CLASSICAL ACADEMY | Regular School | Yes | Other | KG | 10 | 2019 | grade_7 | 30 | 0 | 3 | 0 | 2 | 0 | 3 | 15 | 23 | 38 | 30 | 0 | 3 | 0 | 2 | 0 | 3 | 15 | 23 | 38 | ||||||||||||||||||||||||||||||||||
718975 | 718975 | CO | school | 802280 | 2640 | ASPEN 1 | 80228001703 | 42 | ASPEN COMMUNITY CHARTER SCHOOL | Regular School | Yes | Elementary | PK | 08 | 2017 | grade_7 | 12 | 0 | 0 | 0 | 0 | 0 | 0 | 7 | 5 | 12 | 12 | 0 | 0 | 0 | 0 | 0 | 0 | 7 | 5 | 12 | ||||||||||||||||||||||||||||||||||
846538 | 846538 | CO | school | 2640 | ASPEN 1 | 42 | ASPEN COMMUNITY CHARTER SCHOOL | 2016 | grade_7 | 15 | 0 | 0 | 0 | 0 | 0 | 0 | 8 | 7 | 15 | 15 | 0 | 0 | 0 | 0 | 0 | 0 | 8 | 7 | 15 | |||||||||||||||||||||||||||||||||||||||||
1144107 | 1144107 | CO | school | 802280 | 2640 | ASPEN 1 | 80228001703 | 42 | ASPEN COMMUNITY CHARTER SCHOOL | Regular School | Yes | 1.0 | PK | 08 | 2015 | grade_7 | 13.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 7.0 | 6.0 | 13.0 | 13 | 0 | 0 | 0 | 0 | 0 | 0 | 7 | 6 | 13 | ||||||||||||||||||||||||||||||||||
1904924 | 1904924 | CO | school | 802280 | 2640 | ASPEN 1 | 80228001703 | 42 | ASPEN COMMUNITY CHARTER SCHOOL | Regular School | Yes | Elementary | PK | 08 | 2018 | grade_7 | 14 | 0 | 1 | 0 | 0 | 0 | 0 | 5 | 10 | 15 | 14 | 0 | 1 | 0 | 0 | 0 | 0 | 5 | 10 | 15 | ||||||||||||||||||||||||||||||||||
1942279 | 1942279 | CO | school | 802280 | 2640 | ASPEN 1 | 80228001703 | 42 | ASPEN COMMUNITY CHARTER SCHOOL | Regular School | Yes | Elementary | PK | 08 | 2019 | grade_7 | 14 | 0 | 0 | 0 | 0 | 0 | 0 | 7 | 7 | 14 | 14 | 0 | 0 | 0 | 0 | 0 | 0 | 7 | 7 | 14 | ||||||||||||||||||||||||||||||||||
710563 | 710563 | CO | school | 802490 | 480 | BOULDER VALLEY RE 2 | 80249001758 | 441 | ASPEN CREEK K-8 SCHOOL | Regular School | No | Elementary | PK | 08 | 2017 | grade_7 | 124 | 2 | 16 | 1 | 6 | 0 | 9 | 76 | 82 | 158 | 124 | 2 | 16 | 1 | 6 | 0 | 9 | 76 | 82 | 158 | ||||||||||||||||||||||||||||||||||
838200 | 838200 | CO | school | 480 | BOULDER VALLEY RE 2 | 441 | ASPEN CREEK K-8 SCHOOL | 2016 | grade_7 | 107 | 2 | 16 | 0 | 5 | 0 | 11 | 72 | 69 | 141 | 107 | 2 | 16 | 0 | 5 | 0 | 11 | 72 | 69 | 141 | |||||||||||||||||||||||||||||||||||||||||
1135894 | 1135894 | CO | school | 802490 | 480 | BOULDER VALLEY RE 2 | 80249001758 | 441 | ASPEN CREEK K-8 SCHOOL | Regular School | No | 1.0 | PK | 08 | 2015 | grade_7 | 113.0 | 1.0 | 14.0 | 0.0 | 9.0 | 1.0 | 3.0 | 79.0 | 62.0 | 141.0 | 113 | 1 | 14 | 0 | 9 | 1 | 3 | 79 | 62 | 141 | ||||||||||||||||||||||||||||||||||
1896469 | 1896469 | CO | school | 802490 | 480 | BOULDER VALLEY RE 2 | 80249001758 | 441 | ASPEN CREEK K-8 SCHOOL | Regular School | No | Elementary | PK | 08 | 2018 | grade_7 | 102 | 4 | 21 | 1 | 10 | 0 | 6 | 63 | 81 | 144 | 102 | 4 | 21 | 1 | 10 | 0 | 6 | 63 | 81 | 144 | ||||||||||||||||||||||||||||||||||
1933807 | 1933807 | CO | school | 802490 | 480 | BOULDER VALLEY RE 2 | 80249001758 | 441 | ASPEN CREEK K-8 SCHOOL | Regular School | No | Elementary | PK | 08 | 2019 | grade_7 | 104 | 2 | 21 | 0 | 12 | 0 | 5 | 79 | 65 | 144 | 104 | 2 | 21 | 0 | 12 | 0 | 5 | 79 | 65 | 144 | ||||||||||||||||||||||||||||||||||
718988 | 718988 | CO | school | 802280 | 2640 | ASPEN 1 | 80228000046 | 430 | ASPEN MIDDLE SCHOOL | Regular School | No | Middle | 05 | 08 | 2017 | grade_7 | 96 | 4 | 10 | 0 | 4 | 0 | 1 | 57 | 58 | 115 | 96 | 4 | 10 | 0 | 4 | 0 | 1 | 57 | 58 | 115 | ||||||||||||||||||||||||||||||||||
846550 | 846550 | CO | school | 2640 | ASPEN 1 | 430 | ASPEN MIDDLE SCHOOL | 2016 | grade_7 | 100 | 0 | 8 | 0 | 1 | 0 | 0 | 57 | 52 | 109 | 100 | 0 | 8 | 0 | 1 | 0 | 0 | 57 | 52 | 109 | |||||||||||||||||||||||||||||||||||||||||
1144120 | 1144120 | CO | school | 802280 | 2640 | ASPEN 1 | 80228000046 | 430 | ASPEN MIDDLE SCHOOL | Regular School | No | 2.0 | 05 | 08 | 2015 | grade_7 | 113.0 | 2.0 | 17.0 | 1.0 | 4.0 | 0.0 | 0.0 | 72.0 | 65.0 | 137.0 | 113 | 2 | 17 | 1 | 4 | 0 | 0 | 72 | 65 | 137 | ||||||||||||||||||||||||||||||||||
1904936 | 1904936 | CO | school | 802280 | 2640 | ASPEN 1 | 80228000046 | 430 | ASPEN MIDDLE SCHOOL | Regular School | No | Middle | 05 | 08 | 2018 | grade_7 | 91 | 1 | 19 | 0 | 1 | 0 | 2 | 62 | 52 | 114 | 91 | 1 | 19 | 0 | 1 | 0 | 2 | 62 | 52 | 114 | ||||||||||||||||||||||||||||||||||
1942291 | 1942291 | CO | school | 802280 | 2640 | ASPEN 1 | 80228000046 | 430 | ASPEN MIDDLE SCHOOL | Regular School | No | Middle | 05 | 08 | 2019 | grade_7 | 88 | 2 | 10 | 0 | 3 | 0 | 0 | 50 | 53 | 103 | 88 | 2 | 10 | 0 | 3 | 0 | 0 | 50 | 53 | 103 | ||||||||||||||||||||||||||||||||||
710178 | 710178 | CO | school | 805370 | 470 | ST VRAIN VALLEY RE 1J | 80537006530 | 71 | ASPEN RIDGE PREPARATORY SCHOOL | Regular School | Yes | Elementary | KG | 07 | 2017 | grade_7 | 6 | 1 | 3 | 0 | 0 | 0 | 1 | 7 | 4 | 11 | 6 | 1 | 3 | 0 | 0 | 0 | 1 | 7 | 4 | 11 | ||||||||||||||||||||||||||||||||||
1896089 | 1896089 | CO | school | 805370 | 470 | ST VRAIN VALLEY RE 1J | 80537006530 | 71 | ASPEN RIDGE PREPARATORY SCHOOL | Regular School | Yes | Elementary | KG | 08 | 2018 | grade_7 | 10 | 2 | 3 | 0 | 2 | 0 | 0 | 7 | 10 | 17 | 10 | 2 | 3 | 0 | 2 | 0 | 0 | 7 | 10 | 17 | ||||||||||||||||||||||||||||||||||
1933402 | 1933402 | CO | school | 805370 | 470 | ST VRAIN VALLEY RE 1J | 80537006530 | 71 | ASPEN RIDGE PREPARATORY SCHOOL | Regular School | Yes | Elementary | KG | 08 | 2019 | grade_7 | 23 | 0 | 4 | 0 | 1 | 0 | 1 | 13 | 16 | 29 | 23 | 0 | 4 | 0 | 1 | 0 | 1 | 13 | 16 | 29 | ||||||||||||||||||||||||||||||||||
714505 | 714505 | CO | school | 801920 | 1040 | ACADEMY 20 | 80192000858 | 209 | ASPEN VALLEY CAMPUS | Alternative School | No | High | 07 | 12 | 2017 | grade_7 | 22 | 0 | 2 | 0 | 0 | 0 | 2 | 18 | 8 | 26 | 22 | 0 | 2 | 0 | 0 | 0 | 2 | 18 | 8 | 26 | ||||||||||||||||||||||||||||||||||
842120 | 842120 | CO | school | 1040 | ACADEMY 20 | 209 | ASPEN VALLEY CAMPUS | 2016 | grade_7 | 12 | 1 | 5 | 0 | 0 | 0 | 0 | 12 | 6 | 18 | 12 | 1 | 5 | 0 | 0 | 0 | 0 | 12 | 6 | 18 | |||||||||||||||||||||||||||||||||||||||||
1139734 | 1139734 | CO | school | 801920 | 1040 | ACADEMY 20 | 80192000858 | 209 | ASPEN VALLEY CAMPUS | Alternative Education School | No | 3.0 | 07 | 12 | 2015 | grade_7 | 13.0 | 0.0 | 3.0 | 1.0 | 0.0 | 0.0 | 1.0 | 15.0 | 3.0 | 18.0 | 13 | 0 | 3 | 1 | 0 | 0 | 1 | 15 | 3 | 18 | ||||||||||||||||||||||||||||||||||
1900418 | 1900418 | CO | school | 801920 | 1040 | ACADEMY 20 | 80192000858 | 209 | ASPEN VALLEY CAMPUS | Alternative School | No | High | 07 | 12 | 2018 | grade_7 | 10 | 1 | 2 | 0 | 0 | 0 | 0 | 13 | 0 | 13 | 10 | 1 | 2 | 0 | 0 | 0 | 0 | 13 | 0 | 13 | ||||||||||||||||||||||||||||||||||
1937797 | 1937797 | CO | school | 801920 | 1040 | ACADEMY 20 | 80192000858 | 209 | ASPEN VALLEY CAMPUS | Alternative School | No | High | 07 | 12 | 2019 | grade_7 | 13 | 1 | 3 | 0 | 0 | 0 | 1 | 9 | 9 | 18 | 13 | 1 | 3 | 0 | 0 | 0 | 1 | 9 | 9 | 18 | ||||||||||||||||||||||||||||||||||
713155 | 713155 | CO | school | 803450 | 900 | DOUGLAS COUNTY RE 1 | 80345006588 | 6019 | ASPEN VIEW ACADEMY | Regular School | Yes | Elementary | PK | 08 | 2017 | grade_7 | 79 | 1 | 7 | 0 | 2 | 0 | 5 | 50 | 44 | 94 | 79 | 1 | 7 | 0 | 2 | 0 | 5 | 50 | 44 | 94 | ||||||||||||||||||||||||||||||||||
840784 | 840784 | CO | school | 803450 | 900 | DOUGLAS COUNTY RE 1 | 80345006588 | 6019 | ASPEN VIEW ACADEMY | Regular School | Yes | 1.0 | PK | 08 | 2016 | grade_7 | 64 | 2 | 7 | 0 | 1 | 0 | 2 | 28 | 48 | 76 | 64 | 2 | 7 | 0 | 1 | 0 | 2 | 28 | 48 | 76 | ||||||||||||||||||||||||||||||||||
1138410 | 1138410 | CO | school | 803450 | 900 | DOUGLAS COUNTY RE 1 | 80345006588 | 6019 | ASPEN VIEW ACADEMY | Regular School | Yes | 1.0 | PK | 07 | 2015 | grade_7 | 33.0 | 0.0 | 10.0 | 0.0 | 2.0 | 0.0 | 5.0 | 21.0 | 29.0 | 50.0 | 33 | 0 | 10 | 0 | 2 | 0 | 5 | 21 | 29 | 50 | ||||||||||||||||||||||||||||||||||
1899060 | 1899060 | CO | school | 803450 | 900 | DOUGLAS COUNTY RE 1 | 80345006588 | 6019 | ASPEN VIEW ACADEMY | Regular School | Yes | Elementary | PK | 08 | 2018 | grade_7 | 49 | 1 | 5 | 2 | 1 | 1 | 3 | 29 | 33 | 62 | 49 | 1 | 5 | 2 | 1 | 1 | 3 | 29 | 33 | 62 | ||||||||||||||||||||||||||||||||||
1936423 | 1936423 | CO | school | 803450 | 900 | DOUGLAS COUNTY RE 1 | 80345006588 | 6019 | ASPEN VIEW ACADEMY | Regular School | Yes | Elementary | PK | 08 | 2019 | grade_7 | 72 | 0 | 14 | 1 | 3 | 0 | 3 | 41 | 52 | 93 | 72 | 0 | 14 | 1 | 3 | 0 | 3 | 41 | 52 | 93 | ||||||||||||||||||||||||||||||||||
713663 | 713663 | CO | school | 804530 | 980 | HARRISON 2 | 80453006691 | 369 | ATLAS PREPARATORY MIDDLE SCHOOL | Regular School | Yes | Middle | 05 | 08 | 2017 | grade_7 | 18 | 14 | 123 | 0 | 0 | 2 | 8 | 89 | 76 | 165 | 18 | 14 | 123 | 0 | 0 | 2 | 8 | 89 | 76 | 165 | ||||||||||||||||||||||||||||||||||
1899576 | 1899576 | CO | school | 804530 | 980 | HARRISON 2 | 80453006691 | 369 | ATLAS PREPARATORY MIDDLE SCHOOL | Regular School | Yes | Middle | 05 | 08 | 2018 | grade_7 | 13 | 15 | 106 | 1 | 2 | 1 | 5 | 59 | 84 | 143 | 13 | 15 | 106 | 1 | 2 | 1 | 5 | 59 | 84 | 143 | ||||||||||||||||||||||||||||||||||
1936951 | 1936951 | CO | school | 804530 | 980 | HARRISON 2 | 80453006691 | 369 | ATLAS PREPARATORY MIDDLE SCHOOL | Regular School | Yes | Middle | 05 | 08 | 2019 | grade_7 | 14 | 15 | 122 | 0 | 1 | 0 | 6 | 79 | 79 | 158 | 14 | 15 | 122 | 0 | 1 | 0 | 6 | 79 | 79 | 158 | ||||||||||||||||||||||||||||||||||
841282 | 841282 | CO | school | 980 | HARRISON 2 | 469 | ATLAS PREPARATORY SCHOOL | 2016 | grade_7 | 14 | 22 | 85 | 1 | 0 | 1 | 6 | 67 | 62 | 129 | 14 | 22 | 85 | 1 | 0 | 1 | 6 | 67 | 62 | 129 | |||||||||||||||||||||||||||||||||||||||||
1138898 | 1138898 | CO | school | 804530 | 980 | HARRISON 2 | 80453006425 | 469 | ATLAS PREPARATORY SCHOOL | Regular School | Yes | 4.0 | 05 | 10 | 2015 | grade_7 | 21.0 | 22.0 | 100.0 | 0.0 | 1.0 | 1.0 | 6.0 | 73.0 | 78.0 | 151.0 | 21 | 22 | 100 | 0 | 1 | 1 | 6 | 73 | 78 | 151 | ||||||||||||||||||||||||||||||||||
709534 | 709534 | CO | school | 802340 | 180 | ADAMS-ARAPAHOE 28J | 80234001759 | 458 | AURORA ACADEMY CHARTER SCHOOL | Regular School | Yes | Elementary | KG | 08 | 2017 | grade_7 | 13 | 10 | 19 | 1 | 0 | 0 | 2 | 21 | 24 | 45 | 13 | 10 | 19 | 1 | 0 | 0 | 2 | 21 | 24 | 45 | ||||||||||||||||||||||||||||||||||
837180 | 837180 | CO | school | 180 | ADAMS-ARAPAHOE 28J | 458 | AURORA ACADEMY CHARTER SCHOOL | 2016 | grade_7 | 13 | 13 | 24 | 0 | 1 | 0 | 3 | 28 | 26 | 54 | 13 | 13 | 24 | 0 | 1 | 0 | 3 | 28 | 26 | 54 | |||||||||||||||||||||||||||||||||||||||||
1134897 | 1134897 | CO | school | 802340 | 180 | ADAMS-ARAPAHOE 28J | 80234001759 | 458 | AURORA ACADEMY CHARTER SCHOOL | Regular School | Yes | 1.0 | KG | 08 | 2015 | grade_7 | 15.0 | 8.0 | 15.0 | 0.0 | 1.0 | 0.0 | 2.0 | 27.0 | 14.0 | 41.0 | 15 | 8 | 15 | 0 | 1 | 0 | 2 | 27 | 14 | 41 | ||||||||||||||||||||||||||||||||||
1895434 | 1895434 | CO | school | 802340 | 180 | ADAMS-ARAPAHOE 28J | 80234001759 | 458 | AURORA ACADEMY CHARTER SCHOOL | Regular School | Yes | Elementary | KG | 08 | 2018 | grade_7 | 12 | 15 | 17 | 0 | 1 | 0 | 1 | 18 | 28 | 46 | 12 | 15 | 17 | 0 | 1 | 0 | 1 | 18 | 28 | 46 | ||||||||||||||||||||||||||||||||||
1932738 | 1932738 | CO | school | 802340 | 180 | ADAMS-ARAPAHOE 28J | 80234001759 | 458 | AURORA ACADEMY CHARTER SCHOOL | Regular School | Yes | Elementary | KG | 08 | 2019 | grade_7 | 9 | 14 | 17 | 0 | 1 | 0 | 1 | 21 | 21 | 42 | 9 | 14 | 17 | 0 | 1 | 0 | 1 | 21 | 21 | 42 | ||||||||||||||||||||||||||||||||||
709548 | 709548 | CO | school | 802340 | 180 | ADAMS-ARAPAHOE 28J | 80234002009 | 465 | AURORA FRONTIER K-8 | Regular School | No | Elementary | PK | 08 | 2017 | grade_7 | 22 | 16 | 18 | 0 | 14 | 0 | 4 | 41 | 33 | 74 | 22 | 16 | 18 | 0 | 14 | 0 | 4 | 41 | 33 | 74 | ||||||||||||||||||||||||||||||||||
837194 | 837194 | CO | school | 180 | ADAMS-ARAPAHOE 28J | 465 | AURORA FRONTIER K-8 | 2016 | grade_7 | 32 | 12 | 21 | 0 | 10 | 0 | 8 | 47 | 36 | 83 | 32 | 12 | 21 | 0 | 10 | 0 | 8 | 47 | 36 | 83 | |||||||||||||||||||||||||||||||||||||||||
1134911 | 1134911 | CO | school | 802340 | 180 | ADAMS-ARAPAHOE 28J | 80234002009 | 465 | AURORA FRONTIER K-8 | Regular School | No | 1.0 | PK | 08 | 2015 | grade_7 | 26.0 | 12.0 | 15.0 | 0.0 | 9.0 | 0.0 | 6.0 | 38.0 | 30.0 | 68.0 | 26 | 12 | 15 | 0 | 9 | 0 | 6 | 38 | 30 | 68 | ||||||||||||||||||||||||||||||||||
1895448 | 1895448 | CO | school | 802340 | 180 | ADAMS-ARAPAHOE 28J | 80234002009 | 465 | AURORA FRONTIER K-8 | Regular School | No | Elementary | PK | 08 | 2018 | grade_7 | 20 | 9 | 21 | 0 | 13 | 0 | 7 | 37 | 33 | 70 | 20 | 9 | 21 | 0 | 13 | 0 | 7 | 37 | 33 | 70 | ||||||||||||||||||||||||||||||||||
1932752 | 1932752 | CO | school | 802340 | 180 | ADAMS-ARAPAHOE 28J | 80234002009 | 465 | AURORA FRONTIER K-8 | Regular School | No | Elementary | PK | 08 | 2019 | grade_7 | 20 | 9 | 23 | 1 | 14 | 0 | 6 | 43 | 30 | 73 | 20 | 9 | 23 | 1 | 14 | 0 | 6 | 43 | 30 | 73 | ||||||||||||||||||||||||||||||||||
709539 | 709539 | CO | school | 802340 | 180 | ADAMS-ARAPAHOE 28J | 80234000054 | 464 | AURORA HILLS MIDDLE SCHOOL | Regular School | No | Middle | 06 | 08 | 2017 | grade_7 | 31 | 66 | 168 | 2 | 13 | 2 | 12 | 147 | 147 | 294 | 31 | 66 | 168 | 2 | 13 | 2 | 12 | 147 | 147 | 294 | ||||||||||||||||||||||||||||||||||
837185 | 837185 | CO | school | 180 | ADAMS-ARAPAHOE 28J | 464 | AURORA HILLS MIDDLE SCHOOL | 2016 | grade_7 | 41 | 61 | 189 | 0 | 4 | 3 | 14 | 151 | 161 | 312 | 41 | 61 | 189 | 0 | 4 | 3 | 14 | 151 | 161 | 312 | |||||||||||||||||||||||||||||||||||||||||
1134902 | 1134902 | CO | school | 802340 | 180 | ADAMS-ARAPAHOE 28J | 80234000054 | 464 | AURORA HILLS MIDDLE SCHOOL | Regular School | No | 2.0 | 06 | 08 | 2015 | grade_7 | 26.0 | 83.0 | 182.0 | 1.0 | 12.0 | 1.0 | 10.0 | 193.0 | 122.0 | 315.0 | 26 | 83 | 182 | 1 | 12 | 1 | 10 | 193 | 122 | 315 | ||||||||||||||||||||||||||||||||||
1895439 | 1895439 | CO | school | 802340 | 180 | ADAMS-ARAPAHOE 28J | 80234000054 | 464 | AURORA HILLS MIDDLE SCHOOL | Regular School | No | Middle | 06 | 08 | 2018 | grade_7 | 27 | 70 | 147 | 0 | 10 | 1 | 23 | 151 | 127 | 278 | 27 | 70 | 147 | 0 | 10 | 1 | 23 | 151 | 127 | 278 | ||||||||||||||||||||||||||||||||||
1932743 | 1932743 | CO | school | 802340 | 180 | ADAMS-ARAPAHOE 28J | 80234000054 | 464 | AURORA HILLS MIDDLE SCHOOL | Regular School | No | Middle | 06 | 08 | 2019 | grade_7 | 26 | 59 | 161 | 5 | 9 | 2 | 14 | 135 | 141 | 276 | 26 | 59 | 161 | 5 | 9 | 2 | 14 | 135 | 141 | 276 | ||||||||||||||||||||||||||||||||||
709811 | 709811 | CO | school | 802340 | 180 | ADAMS-ARAPAHOE 28J | 80234001674 | 7232 | AURORA QUEST K-8 | Regular School | No | Elementary | KG | 08 | 2017 | grade_7 | 47 | 8 | 21 | 3 | 11 | 1 | 4 | 43 | 52 | 95 | 47 | 8 | 21 | 3 | 11 | 1 | 4 | 43 | 52 | 95 | ||||||||||||||||||||||||||||||||||
837456 | 837456 | CO | school | 802340 | 180 | ADAMS-ARAPAHOE 28J | 80234001674 | 7232 | AURORA QUEST K-8 | Regular School | No | 1.0 | KG | 08 | 2016 | grade_7 | 36 | 9 | 20 | 0 | 13 | 1 | 8 | 46 | 41 | 87 | 36 | 9 | 20 | 0 | 13 | 1 | 8 | 46 | 41 | 87 | ||||||||||||||||||||||||||||||||||
1135162 | 1135162 | CO | school | 802340 | 180 | ADAMS-ARAPAHOE 28J | 80234001674 | 7232 | AURORA QUEST K-8 | Regular School | No | 1.0 | KG | 08 | 2015 | grade_7 | 40.0 | 10.0 | 12.0 | 0.0 | 13.0 | 1.0 | 7.0 | 40.0 | 43.0 | 83.0 | 40 | 10 | 12 | 0 | 13 | 1 | 7 | 40 | 43 | 83 | ||||||||||||||||||||||||||||||||||
1895712 | 1895712 | CO | school | 802340 | 180 | ADAMS-ARAPAHOE 28J | 80234001674 | 7232 | AURORA QUEST K-8 | Regular School | No | Elementary | KG | 08 | 2018 | grade_7 | 38 | 8 | 24 | 0 | 11 | 0 | 5 | 43 | 43 | 86 | 38 | 8 | 24 | 0 | 11 | 0 | 5 | 43 | 43 | 86 | ||||||||||||||||||||||||||||||||||
1933016 | 1933016 | CO | school | 802340 | 180 | ADAMS-ARAPAHOE 28J | 80234001674 | 7232 | AURORA QUEST K-8 | Regular School | No | Elementary | KG | 08 | 2019 | grade_7 | 36 | 10 | 28 | 0 | 12 | 1 | 3 | 40 | 50 | 90 | 36 | 10 | 28 | 0 | 12 | 1 | 3 | 40 | 50 | 90 | ||||||||||||||||||||||||||||||||||
709930 | 709930 | CO | school | 802340 | 180 | ADAMS-ARAPAHOE 28J | 80234000082 | 9396 | AURORA WEST COLLEGE PREPARATORY ACADEMY | Regular School | No | Other | 06 | 12 | 2017 | grade_7 | 14 | 37 | 205 | 3 | 36 | 0 | 1 | 165 | 131 | 296 | 14 | 37 | 205 | 3 | 36 | 0 | 1 | 165 | 131 | 296 | ||||||||||||||||||||||||||||||||||
837572 | 837572 | CO | school | 802340 | 180 | ADAMS-ARAPAHOE 28J | 80234000082 | 9396 | AURORA WEST COLLEGE PREPARATORY ACADEMY | Regular School | No | 4.0 | 06 | 12 | 2016 | grade_7 | 17 | 26 | 211 | 1 | 38 | 0 | 4 | 140 | 157 | 297 | 17 | 26 | 211 | 1 | 38 | 0 | 4 | 140 | 157 | 297 | ||||||||||||||||||||||||||||||||||
1135277 | 1135277 | CO | school | 802340 | 180 | ADAMS-ARAPAHOE 28J | 80234000082 | 9396 | AURORA WEST COLLEGE PREPARATORY ACADEMY | Regular School | No | 4.0 | 06 | 12 | 2015 | grade_7 | 17.0 | 33.0 | 221.0 | 2.0 | 43.0 | 0.0 | 7.0 | 172.0 | 151.0 | 323.0 | 17 | 33 | 221 | 2 | 43 | 0 | 7 | 172 | 151 | 323 | ||||||||||||||||||||||||||||||||||
1895837 | 1895837 | CO | school | 802340 | 180 | ADAMS-ARAPAHOE 28J | 80234000082 | 9396 | AURORA WEST COLLEGE PREPARATORY ACADEMY | Regular School | No | High | 06 | 12 | 2018 | grade_7 | 11 | 30 | 173 | 1 | 35 | 1 | 5 | 131 | 125 | 256 | 11 | 30 | 173 | 1 | 35 | 1 | 5 | 131 | 125 | 256 | ||||||||||||||||||||||||||||||||||
1933144 | 1933144 | CO | school | 802340 | 180 | ADAMS-ARAPAHOE 28J | 80234000082 | 9396 | AURORA WEST COLLEGE PREPARATORY ACADEMY | Regular School | No | High | 06 | 12 | 2019 | grade_7 | 16 | 31 | 177 | 0 | 23 | 0 | 3 | 134 | 116 | 250 | 16 | 31 | 177 | 0 | 23 | 0 | 3 | 134 | 116 | 250 | ||||||||||||||||||||||||||||||||||
709502 | 709502 | CO | school | 802340 | 180 | ADAMS-ARAPAHOE 28J | 80234006399 | 213 | AXL ACADEMY | Regular School | Yes | Elementary | PK | 08 | 2017 | grade_7 | 12 | 13 | 24 | 0 | 1 | 0 | 0 | 24 | 26 | 50 | 12 | 13 | 24 | 0 | 1 | 0 | 0 | 24 | 26 | 50 | ||||||||||||||||||||||||||||||||||
837148 | 837148 | CO | school | 180 | ADAMS-ARAPAHOE 28J | 213 | AXL ACADEMY | 2016 | grade_7 | 5 | 16 | 17 | 1 | 1 | 0 | 1 | 19 | 22 | 41 | 5 | 16 | 17 | 1 | 1 | 0 | 1 | 19 | 22 | 41 | |||||||||||||||||||||||||||||||||||||||||
1134864 | 1134864 | CO | school | 802340 | 180 | ADAMS-ARAPAHOE 28J | 80234006399 | 213 | AXL ACADEMY | Regular School | Yes | 1.0 | PK | 08 | 2015 | grade_7 | 15.0 | 17.0 | 10.0 | 1.0 | 0.0 | 0.0 | 2.0 | 17.0 | 28.0 | 45.0 | 15 | 17 | 10 | 1 | 0 | 0 | 2 | 17 | 28 | 45 | ||||||||||||||||||||||||||||||||||
1895402 | 1895402 | CO | school | 802340 | 180 | ADAMS-ARAPAHOE 28J | 80234006399 | 213 | AXL ACADEMY | Regular School | Yes | Elementary | PK | 08 | 2018 | grade_7 | 12 | 11 | 24 | 1 | 0 | 0 | 3 | 25 | 26 | 51 | 12 | 11 | 24 | 1 | 0 | 0 | 3 | 25 | 26 | 51 | ||||||||||||||||||||||||||||||||||
1932711 | 1932711 | CO | school | 802340 | 180 | ADAMS-ARAPAHOE 28J | 80234006399 | 213 | AXL ACADEMY | Regular School | Yes | Elementary | PK | 08 | 2019 | grade_7 | 11 | 11 | 19 | 0 | 1 | 0 | 1 | 20 | 23 | 43 | 11 | 11 | 19 | 0 | 1 | 0 | 1 | 20 | 23 | 43 | ||||||||||||||||||||||||||||||||||
1739999 | 1739999 | CO | school | 802340 | 180 | Adams-Arapahoe 28J | 80234006399 | 213 | AXL Academy | Regular School | Yes | Elementary | PK | 08 | 2021 | grade_7 | 9 | 20 | 16 | 0 | 0 | 1 | 4 | 29 | 21 | 50 | 9 | 20 | 16 | 0 | 0 | 1 | 4 | 29 | 21 | 50 | ||||||||||||||||||||||||||||||||||
1801050 | 1801050 | CO | school | 802340 | 180 | Adams-Arapahoe 28J | 80234006399 | 213 | AXL Academy | Regular School | Yes | Elementary | PK | 08 | 2020 | grade_7 | 9 | 14 | 22 | 0 | 1 | 1 | 6 | 31 | 22 | 53 | 9 | 14 | 22 | 0 | 1 | 1 | 6 | 31 | 22 | 53 | ||||||||||||||||||||||||||||||||||
1743224 | 1743224 | CO | school | 803450 | 900 | Douglas County Re 1 | 80345000492 | 11 | Academy Charter School | Regular School | Yes | Elementary | PK | 08 | 2021 | grade_7 | 62 | 3 | 10 | 0 | 2 | 0 | 4 | 32 | 49 | 81 | 62 | 3 | 10 | 0 | 2 | 0 | 4 | 32 | 49 | 81 | ||||||||||||||||||||||||||||||||||
1804252 | 1804252 | CO | school | 803450 | 900 | Douglas County Re 1 | 80345000492 | 11 | Academy Charter School | Regular School | Yes | Elementary | PK | 08 | 2020 | grade_7 | 64 | 1 | 10 | 2 | 3 | 0 | 3 | 48 | 35 | 83 | 64 | 1 | 10 | 2 | 3 | 0 | 3 | 48 | 35 | 83 | ||||||||||||||||||||||||||||||||||
1744528 | 1744528 | CO | school | 803060 | 1010 | Colorado Springs 11 | 80306006456 | 517 | Academy for Advanced and Creative Learning | Regular School | Yes | Elementary | KG | 08 | 2021 | grade_7 | 23 | 1 | 5 | 1 | 0 | 1 | 2 | 16 | 17 | 33 | 23 | 1 | 5 | 1 | 0 | 1 | 2 | 16 | 17 | 33 | ||||||||||||||||||||||||||||||||||
1805608 | 1805608 | CO | school | 803060 | 1010 | Colorado Springs 11 | 80306006456 | 517 | Academy for Advanced and Creative Learning | Regular School | Yes | Elementary | KG | 08 | 2020 | grade_7 | 29 | 0 | 2 | 1 | 0 | 0 | 0 | 23 | 9 | 32 | 29 | 0 | 2 | 1 | 0 | 0 | 0 | 23 | 9 | 32 | ||||||||||||||||||||||||||||||||||
1739984 | 1739984 | CO | school | 802340 | 180 | Adams-Arapahoe 28J | 80234006736 | 126 | Academy of Advanced Learning | Regular School | Yes | Elementary | KG | 08 | 2021 | grade_7 | 7 | 28 | 67 | 0 | 1 | 0 | 6 | 59 | 50 | 109 | 7 | 28 | 67 | 0 | 1 | 0 | 6 | 59 | 50 | 109 | ||||||||||||||||||||||||||||||||||
1801036 | 1801036 | CO | school | 802340 | 180 | Adams-Arapahoe 28J | 80234006736 | 126 | Academy of Advanced Learning | Regular School | Yes | Elementary | KG | 08 | 2020 | grade_7 | 6 | 12 | 59 | 1 | 0 | 1 | 6 | 36 | 49 | 85 | 6 | 12 | 59 | 1 | 0 | 1 | 6 | 36 | 49 | 85 | ||||||||||||||||||||||||||||||||||
1751089 | 1751089 | CO | school | 800020 | 8001 | Charter School Institute | 80002000727 | 15 | Academy of Charter Schools | Regular School | Yes | Other | PK | 12 | 2021 | grade_7 | 96 | 1 | 39 | 0 | 11 | 0 | 4 | 75 | 76 | 151 | 96 | 1 | 39 | 0 | 11 | 0 | 4 | 75 | 76 | 151 | ||||||||||||||||||||||||||||||||||
1812204 | 1812204 | CO | school | 800020 | 8001 | Charter School Institute | 80002000727 | 15 | Academy of Charter Schools | Regular School | Yes | Other | PK | 12 | 2020 | grade_7 | 91 | 1 | 36 | 0 | 11 | 0 | 6 | 67 | 78 | 145 | 91 | 1 | 36 | 0 | 11 | 0 | 6 | 67 | 78 | 145 | ||||||||||||||||||||||||||||||||||
1738323 | 1738323 | CO | school | 805550 | 10 | Mapleton 1 | 80555002004 | 505 | Achieve Academy | Regular School | No | Elementary | PK | 08 | 2021 | grade_7 | 2 | 2 | 58 | 0 | 1 | 0 | 3 | 33 | 33 | 66 | 2 | 2 | 58 | 0 | 1 | 0 | 3 | 33 | 33 | 66 | ||||||||||||||||||||||||||||||||||
1799380 | 1799380 | CO | school | 805550 | 10 | Mapleton 1 | 80555002004 | 505 | Achieve Academy | Regular School | No | Elementary | PK | 08 | 2020 | grade_7 | 5 | 0 | 51 | 1 | 1 | 0 | 3 | 31 | 30 | 61 | 5 | 0 | 51 | 1 | 1 | 0 | 3 | 31 | 30 | 61 | ||||||||||||||||||||||||||||||||||
1744510 | 1744510 | CO | school | 803060 | 1010 | Colorado Springs 11 | 80306006428 | 269 | Achieve Online | Alternative School | No | High | 06 | 12 | 2021 | grade_7 | 16 | 1 | 5 | 0 | 0 | 1 | 2 | 13 | 12 | 25 | 16 | 1 | 5 | 0 | 0 | 1 | 2 | 13 | 12 | 25 | ||||||||||||||||||||||||||||||||||
1805589 | 1805589 | CO | school | 803060 | 1010 | Colorado Springs 11 | 80306006428 | 269 | Achieve Online | Alternative School | No | High | 06 | 12 | 2020 | grade_7 | 10 | 1 | 3 | 0 | 0 | 0 | 0 | 10 | 4 | 14 | 10 | 1 | 3 | 0 | 0 | 0 | 0 | 10 | 4 | 14 | ||||||||||||||||||||||||||||||||||
1738787 | 1738787 | CO | school | 801950 | 30 | Adams County 14 | 80195000009 | 20 | Adams City Middle School | Regular School | No | Middle | 06 | 08 | 2021 | grade_7 | 22 | 3 | 216 | 1 | 0 | 0 | 3 | 134 | 111 | 245 | 22 | 3 | 216 | 1 | 0 | 0 | 3 | 134 | 111 | 245 | ||||||||||||||||||||||||||||||||||
1799846 | 1799846 | CO | school | 801950 | 30 | Adams County 14 | 80195000009 | 20 | Adams City Middle School | Regular School | No | Middle | 06 | 08 | 2020 | grade_7 | 23 | 3 | 221 | 2 | 0 | 1 | 6 | 121 | 135 | 256 | 23 | 3 | 221 | 2 | 0 | 1 | 6 | 121 | 135 | 256 | ||||||||||||||||||||||||||||||||||
1746246 | 1746246 | CO | school | 804800 | 1420 | Jefferson County R-1 | 80480006587 | 1451 | Addenbrooke Classical Academy | Regular School | Yes | High | 06 | 12 | 2021 | grade_7 | 48 | 0 | 29 | 0 | 2 | 0 | 2 | 32 | 49 | 81 | 48 | 0 | 29 | 0 | 2 | 0 | 2 | 32 | 49 | 81 | ||||||||||||||||||||||||||||||||||
1807336 | 1807336 | CO | school | 804800 | 1420 | Jefferson County R-1 | 80480006587 | 1451 | Addenbrooke Classical Academy | Regular School | Yes | High | 06 | 12 | 2020 | grade_7 | 47 | 1 | 13 | 1 | 2 | 0 | 5 | 42 | 27 | 69 | 47 | 1 | 13 | 1 | 2 | 0 | 5 | 42 | 27 | 69 | ||||||||||||||||||||||||||||||||||
1744128 | 1744128 | CO | school | 801980 | 960 | Agate 300 | 80198000021 | 48 | Agate Junior Senior High School | Regular School | No | High | 06 | 12 | 2021 | grade_7 | 5 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 1 | 5 | 5 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 1 | 5 | ||||||||||||||||||||||||||||||||||
1805211 | 1805211 | CO | school | 801980 | 960 | Agate 300 | 80198000021 | 48 | Agate Junior Senior High School | Regular School | No | High | 06 | 12 | 2020 | grade_7 | 1 | 0 | 1 | 0 | 0 | 0 | 0 | 1 | 1 | 2 | 1 | 0 | 1 | 0 | 0 | 0 | 0 | 1 | 1 | 2 | ||||||||||||||||||||||||||||||||||
1748272 | 1748272 | CO | school | 802010 | 1620 | Aguilar Reorganized 6 | 80201000023 | 66 | Aguilar Junior-Senior High School | Regular School | No | High | 06 | 12 | 2021 | grade_7 | 2 | 0 | 7 | 0 | 0 | 0 | 0 | 7 | 2 | 9 | 2 | 0 | 7 | 0 | 0 | 0 | 0 | 7 | 2 | 9 | ||||||||||||||||||||||||||||||||||
1809413 | 1809413 | CO | school | 802010 | 1620 | Aguilar Reorganized 6 | 80201000023 | 66 | Aguilar Junior-Senior High School | Regular School | No | High | 06 | 12 | 2020 | grade_7 | 5 | 0 | 2 | 0 | 0 | 0 | 1 | 3 | 5 | 8 | 5 | 0 | 2 | 0 | 0 | 0 | 1 | 3 | 5 | 8 | ||||||||||||||||||||||||||||||||||
1750359 | 1750359 | CO | school | 802040 | 3030 | Akron R-1 | 80204000024 | 86 | Akron Elementary School | Regular School | No | Elementary | PK | 08 | 2021 | grade_7 | 17 | 0 | 3 | 1 | 0 | 0 | 0 | 12 | 9 | 21 | 17 | 0 | 3 | 1 | 0 | 0 | 0 | 12 | 9 | 21 | ||||||||||||||||||||||||||||||||||
1811486 | 1811486 | CO | school | 802040 | 3030 | Akron R-1 | 80204000024 | 86 | Akron Elementary School | Regular School | No | Elementary | PK | 08 | 2020 | grade_7 | 25 | 0 | 8 | 0 | 0 | 0 | 1 | 21 | 13 | 34 | 25 | 0 | 8 | 0 | 0 | 0 | 1 | 21 | 13 | 34 | ||||||||||||||||||||||||||||||||||
1746132 | 1746132 | CO | school | 804800 | 1420 | Jefferson County R-1 | 80480000691 | 108 | Alameda International Junior/Senior High School | Regular School | No | High | 07 | 12 | 2021 | grade_7 | 26 | 4 | 171 | 3 | 10 | 1 | 7 | 119 | 103 | 222 | 26 | 4 | 171 | 3 | 10 | 1 | 7 | 119 | 103 | 222 | ||||||||||||||||||||||||||||||||||
1807217 | 1807217 | CO | school | 804800 | 1420 | Jefferson County R-1 | 80480000691 | 108 | Alameda International Junior/Senior High School | Regular School | No | High | 07 | 12 | 2020 | grade_7 | 33 | 1 | 178 | 1 | 14 | 0 | 6 | 124 | 109 | 233 | 33 | 1 | 178 | 1 | 14 | 0 | 6 | 124 | 109 | 233 | ||||||||||||||||||||||||||||||||||
1800304 | 1800304 | CO | school | 802070 | 100 | Alamosa RE-11J | 80207006508 | 368 | Alamosa Ombudsman School of Excellence | Alternative School | No | High | 06 | 12 | 2020 | grade_7 | 2 | 0 | 0 | 0 | 0 | 0 | 0 | 2 | 0 | 2 | 2 | 0 | 0 | 0 | 0 | 0 | 0 | 2 | 0 | 2 | ||||||||||||||||||||||||||||||||||
1739249 | 1739249 | CO | school | 802070 | 100 | Alamosa RE-11J | 80207006792 | 270 | Alamosa Online | Regular School | No | Other | KG | 12 | 2021 | grade_7 | 9 | 2 | 34 | 2 | 1 | 0 | 2 | 27 | 23 | 50 | 9 | 2 | 34 | 2 | 1 | 0 | 2 | 27 | 23 | 50 | ||||||||||||||||||||||||||||||||||
1740725 | 1740725 | CO | school | 805370 | 470 | St Vrain Valley RE1J | 80537001886 | 226 | Altona Middle School | Regular School | No | Middle | 06 | 08 | 2021 | grade_7 | 197 | 2 | 46 | 1 | 20 | 0 | 10 | 152 | 124 | 276 | 197 | 2 | 46 | 1 | 20 | 0 | 10 | 152 | 124 | 276 |
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]);