enrollments
Data source: Big Local News · About: Big Local
1,066 rows where grade = "grade_5", state = "CO" and year = 2016 sorted by total_int descending
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 ▲ |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
842147 | 842147 | CO | school | 801920 | 1040 | ACADEMY 20 | 80192001592 | 1627 | THE CLASSICAL ACADEMY CHARTER | Regular School | Yes | 1.0 | KG | 06 | 2016 | grade_5 | 217 | 9 | 17 | 2 | 7 | 1 | 10 | 134 | 129 | 263 | 217 | 9 | 17 | 2 | 7 | 1 | 10 | 134 | 129 | 263 | ||||||||||||||||||||||||||||||||||
842889 | 842889 | CO | school | 806240 | 1195 | GARFIELD RE-2 | 80624001096 | 7356 | RIFLE MIDDLE SCHOOL | Regular School | No | 2.0 | 05 | 08 | 2016 | grade_5 | 103 | 1 | 127 | 0 | 1 | 0 | 4 | 115 | 121 | 236 | 103 | 1 | 127 | 0 | 1 | 0 | 4 | 115 | 121 | 236 | ||||||||||||||||||||||||||||||||||
846243 | 846243 | CO | school | 2405 | FORT MORGAN RE-3 | 492 | BAKER CENTRAL SCHOOL | 2016 | grade_5 | 68 | 6 | 132 | 1 | 2 | 0 | 1 | 117 | 93 | 210 | 68 | 6 | 132 | 1 | 2 | 0 | 1 | 117 | 93 | 210 | |||||||||||||||||||||||||||||||||||||||||
840356 | 840356 | CO | school | 900 | DOUGLAS COUNTY RE 1 | 215 | AMERICAN ACADEMY | 2016 | grade_5 | 151 | 1 | 20 | 0 | 21 | 0 | 9 | 86 | 116 | 202 | 151 | 1 | 20 | 0 | 21 | 0 | 9 | 86 | 116 | 202 | |||||||||||||||||||||||||||||||||||||||||
836431 | 836431 | CO | school | 100 | ALAMOSA RE-11J | 115 | ALAMOSA ELEMENTARY SCHOOL | 2016 | grade_5 | 64 | 1 | 119 | 1 | 3 | 0 | 1 | 96 | 93 | 189 | 64 | 1 | 119 | 1 | 3 | 0 | 1 | 96 | 93 | 189 | |||||||||||||||||||||||||||||||||||||||||
840659 | 840659 | CO | school | 803450 | 900 | DOUGLAS COUNTY RE 1 | 80345006577 | 3863 | HOPE ONLINE LEARNING ACADEMY ELEMENTARY | Regular School | Yes | 1.0 | KG | 05 | 2016 | grade_5 | 32 | 9 | 131 | 0 | 2 | 0 | 3 | 84 | 93 | 177 | 32 | 9 | 131 | 0 | 2 | 0 | 3 | 84 | 93 | 177 | ||||||||||||||||||||||||||||||||||
848233 | 848233 | CO | school | 8001 | CHARTER SCHOOL INSTITUTE | 654 | THE PINNACLE CHARTER SCHOOL ELEMENTARY | 2016 | grade_5 | 33 | 0 | 128 | 2 | 8 | 0 | 0 | 84 | 87 | 171 | 33 | 0 | 128 | 2 | 8 | 0 | 0 | 84 | 87 | 171 | |||||||||||||||||||||||||||||||||||||||||
842899 | 842899 | CO | school | 806240 | 1195 | GARFIELD RE-2 | 80624001098 | 7388 | RIVERSIDE SCHOOL | Regular School | No | 2.0 | 05 | 08 | 2016 | grade_5 | 91 | 0 | 74 | 1 | 0 | 0 | 3 | 85 | 84 | 169 | 91 | 0 | 74 | 1 | 0 | 0 | 3 | 85 | 84 | 169 | ||||||||||||||||||||||||||||||||||
845505 | 845505 | CO | school | 806690 | 1828 | VALLEY RE-1 | 80669006323 | 1321 | CAMPBELL ELEMENTARY SCHOOL | Regular School | No | 1.0 | 03 | 05 | 2016 | grade_5 | 100 | 0 | 46 | 1 | 2 | 0 | 5 | 76 | 78 | 154 | 100 | 0 | 46 | 1 | 2 | 0 | 5 | 76 | 78 | 154 | ||||||||||||||||||||||||||||||||||
842577 | 842577 | CO | school | 803870 | 1110 | FALCON 49 | 80387001898 | 7339 | RIDGEVIEW ELEMENTARY SCHOOL | Regular School | No | 1.0 | PK | 05 | 2016 | grade_5 | 103 | 4 | 30 | 1 | 5 | 1 | 5 | 83 | 66 | 149 | 103 | 4 | 30 | 1 | 5 | 1 | 5 | 83 | 66 | 149 | ||||||||||||||||||||||||||||||||||
842391 | 842391 | CO | school | 805820 | 1080 | LEWIS-PALMER 38 | 80582001371 | 3539 | BEAR CREEK ELEMENTARY SCHOOL | Regular School | No | 1.0 | PK | 06 | 2016 | grade_5 | 118 | 4 | 13 | 2 | 4 | 0 | 7 | 82 | 66 | 148 | 118 | 4 | 13 | 2 | 4 | 0 | 7 | 82 | 66 | 148 | ||||||||||||||||||||||||||||||||||
840819 | 840819 | CO | school | 803450 | 900 | DOUGLAS COUNTY RE 1 | 80345000442 | 6396 | NORTHEAST ELEMENTARY SCHOOL | Regular School | No | 1.0 | 03 | 05 | 2016 | grade_5 | 124 | 0 | 13 | 0 | 2 | 0 | 8 | 80 | 67 | 147 | 124 | 0 | 13 | 0 | 2 | 0 | 8 | 80 | 67 | 147 | ||||||||||||||||||||||||||||||||||
842585 | 842585 | CO | school | 803870 | 1110 | FALCON 49 | 80387002000 | 7463 | ROCKY MOUNTAIN CLASSICAL ACADEMY | Regular School | Yes | 1.0 | KG | 08 | 2016 | grade_5 | 96 | 8 | 23 | 0 | 5 | 0 | 14 | 59 | 87 | 146 | 96 | 8 | 23 | 0 | 5 | 0 | 14 | 59 | 87 | 146 | ||||||||||||||||||||||||||||||||||
835647 | 835647 | CO | school | 20 | ADAMS 12 FIVE STAR SCHOOLS | 59 | MERIDIAN ELEMENTARY SCHOOL | 2016 | grade_5 | 107 | 3 | 17 | 1 | 7 | 0 | 10 | 69 | 76 | 145 | 107 | 3 | 17 | 1 | 7 | 0 | 10 | 69 | 76 | 145 | |||||||||||||||||||||||||||||||||||||||||
848195 | 848195 | CO | school | 8001 | CHARTER SCHOOL INSTITUTE | 15 | ACADEMY OF CHARTER SCHOOLS | 2016 | grade_5 | 85 | 3 | 33 | 1 | 15 | 1 | 2 | 69 | 71 | 140 | 85 | 3 | 33 | 1 | 15 | 1 | 2 | 69 | 71 | 140 | |||||||||||||||||||||||||||||||||||||||||
836855 | 836855 | CO | school | 802910 | 130 | CHERRY CREEK 5 | 80291006452 | 6955 | PINE RIDGE ELEMENTARY SCHOOL | Regular School | No | 1.0 | PK | 05 | 2016 | grade_5 | 97 | 7 | 16 | 2 | 13 | 0 | 4 | 70 | 69 | 139 | 97 | 7 | 16 | 2 | 13 | 0 | 4 | 70 | 69 | 139 | ||||||||||||||||||||||||||||||||||
836871 | 836871 | CO | school | 802910 | 130 | CHERRY CREEK 5 | 80291000200 | 7116 | PONDEROSA ELEMENTARY SCHOOL | Regular School | No | 1.0 | PK | 05 | 2016 | grade_5 | 32 | 44 | 43 | 3 | 7 | 3 | 7 | 77 | 62 | 139 | 32 | 44 | 43 | 3 | 7 | 3 | 7 | 77 | 62 | 139 | ||||||||||||||||||||||||||||||||||
842139 | 842139 | CO | school | 801920 | 1040 | ACADEMY 20 | 80192006329 | 1615 | CHINOOK TRAIL ELEMENTARY SCHOOL | Regular School | No | 1.0 | KG | 05 | 2016 | grade_5 | 96 | 8 | 13 | 1 | 10 | 0 | 11 | 62 | 77 | 139 | 96 | 8 | 13 | 1 | 10 | 0 | 11 | 62 | 77 | 139 | ||||||||||||||||||||||||||||||||||
842534 | 842534 | CO | school | 803870 | 1110 | FALCON 49 | 80387001843 | 5779 | MERIDIAN RANCH INTERNATIONAL SCHOOL | Regular School | No | 1.0 | PK | 05 | 2016 | grade_5 | 105 | 8 | 17 | 1 | 0 | 0 | 7 | 68 | 70 | 138 | 105 | 8 | 17 | 1 | 0 | 0 | 7 | 68 | 70 | 138 | ||||||||||||||||||||||||||||||||||
847597 | 847597 | CO | school | 3085 | EATON RE-2 | 754 | BENJAMIN EATON ELEMENTARY SCHOOL | 2016 | grade_5 | 99 | 1 | 34 | 0 | 1 | 0 | 3 | 67 | 71 | 138 | 99 | 1 | 34 | 0 | 1 | 0 | 3 | 67 | 71 | 138 | |||||||||||||||||||||||||||||||||||||||||
840603 | 840603 | CO | school | 803450 | 900 | DOUGLAS COUNTY RE 1 | 80345006299 | 2954 | ROXBOROUGH INTERMEDIATE | Regular School | No | 1.0 | 03 | 06 | 2016 | grade_5 | 108 | 2 | 19 | 0 | 3 | 0 | 5 | 75 | 62 | 137 | 108 | 2 | 19 | 0 | 3 | 0 | 5 | 75 | 62 | 137 | ||||||||||||||||||||||||||||||||||
847832 | 847832 | CO | school | 804410 | 3120 | GREELEY 6 | 80441001614 | 1875 | FRONTIER CHARTER ACADEMY | Regular School | Yes | 4.0 | KG | 12 | 2016 | grade_5 | 101 | 2 | 28 | 2 | 1 | 0 | 2 | 67 | 69 | 136 | 101 | 2 | 28 | 2 | 1 | 0 | 2 | 67 | 69 | 136 | ||||||||||||||||||||||||||||||||||
836540 | 836540 | CO | school | 130 | CHERRY CREEK 5 | 16 | FOX HOLLOW ELEMENTARY SCHOOL | 2016 | grade_5 | 80 | 6 | 15 | 2 | 24 | 0 | 8 | 68 | 67 | 135 | 80 | 6 | 15 | 2 | 24 | 0 | 8 | 68 | 67 | 135 | |||||||||||||||||||||||||||||||||||||||||
836890 | 836890 | CO | school | 802910 | 130 | CHERRY CREEK 5 | 80291001514 | 7476 | ROLLING HILLS ELEMENTARY SCHOOL | Regular School | No | 1.0 | PK | 05 | 2016 | grade_5 | 96 | 5 | 10 | 1 | 18 | 0 | 4 | 64 | 70 | 134 | 96 | 5 | 10 | 1 | 18 | 0 | 4 | 64 | 70 | 134 | ||||||||||||||||||||||||||||||||||
836222 | 836222 | CO | school | 802580 | 40 | SCHOOL DISTRICT 27J | 80258001822 | 8032 | JOHN W THIMMIG ELEMENTARY SCHOOL | Regular School | No | 1.0 | PK | 05 | 2016 | grade_5 | 51 | 2 | 68 | 0 | 7 | 0 | 2 | 67 | 63 | 130 | 51 | 2 | 68 | 0 | 7 | 0 | 2 | 67 | 63 | 130 | ||||||||||||||||||||||||||||||||||
841518 | 841518 | CO | school | 806480 | 990 | WIDEFIELD 3 | 80648001127 | 9334 | WEBSTER ELEMENTARY SCHOOL | Regular School | No | 1.0 | KG | 05 | 2016 | grade_5 | 69 | 14 | 31 | 1 | 2 | 2 | 11 | 68 | 62 | 130 | 69 | 14 | 31 | 1 | 2 | 2 | 11 | 68 | 62 | 130 | ||||||||||||||||||||||||||||||||||
836117 | 836117 | CO | school | 802580 | 40 | SCHOOL DISTRICT 27J | 80258001729 | 1052 | BROMLEY EAST CHARTER SCHOOL | Regular School | Yes | 1.0 | PK | 08 | 2016 | grade_5 | 80 | 2 | 42 | 0 | 0 | 1 | 4 | 66 | 63 | 129 | 80 | 2 | 42 | 0 | 0 | 1 | 4 | 66 | 63 | 129 | ||||||||||||||||||||||||||||||||||
840371 | 840371 | CO | school | 900 | DOUGLAS COUNTY RE 1 | 265 | CLEAR SKY ELEMENTARY | 2016 | grade_5 | 94 | 0 | 26 | 0 | 3 | 0 | 6 | 71 | 58 | 129 | 94 | 0 | 26 | 0 | 3 | 0 | 6 | 71 | 58 | 129 | |||||||||||||||||||||||||||||||||||||||||
840639 | 840639 | CO | school | 803450 | 900 | DOUGLAS COUNTY RE 1 | 80345001875 | 3241 | FRONTIER VALLEY ELEMENTARY SCHOOL | Regular School | No | 1.0 | PK | 05 | 2016 | grade_5 | 106 | 0 | 13 | 0 | 4 | 1 | 5 | 71 | 58 | 129 | 106 | 0 | 13 | 0 | 4 | 1 | 5 | 71 | 58 | 129 | ||||||||||||||||||||||||||||||||||
843188 | 843188 | CO | school | 1420 | JEFFERSON COUNTY R-1 | 660 | BEAR CREEK K-8 SCHOOL | 2016 | grade_5 | 67 | 0 | 47 | 0 | 10 | 1 | 3 | 72 | 56 | 128 | 67 | 0 | 47 | 0 | 10 | 1 | 3 | 72 | 56 | 128 | |||||||||||||||||||||||||||||||||||||||||
844673 | 844673 | CO | school | 1550 | POUDRE R-1 | 477 | ZACH ELEMENTARY SCHOOL | 2016 | grade_5 | 116 | 0 | 4 | 0 | 4 | 0 | 3 | 64 | 63 | 127 | 116 | 0 | 4 | 0 | 4 | 0 | 3 | 64 | 63 | 127 | |||||||||||||||||||||||||||||||||||||||||
847797 | 847797 | CO | school | 3120 | GREELEY 6 | 54 | BELLA ROMERO ACADEMY OF APPLIED TECHNOLOGY | 2016 | grade_5 | 14 | 7 | 102 | 0 | 3 | 0 | 1 | 74 | 53 | 127 | 14 | 7 | 102 | 0 | 3 | 0 | 1 | 74 | 53 | 127 | |||||||||||||||||||||||||||||||||||||||||
839932 | 839932 | CO | school | 803360 | 880 | DENVER COUNTY 1 | 80336006398 | 7045 | PLACE BRIDGE ACADEMY | Regular School | No | 1.0 | PK | 08 | 2016 | grade_5 | 17 | 28 | 43 | 0 | 34 | 2 | 2 | 57 | 69 | 126 | 17 | 28 | 43 | 0 | 34 | 2 | 2 | 57 | 69 | 126 | ||||||||||||||||||||||||||||||||||
847778 | 847778 | CO | school | 3120 | GREELEY 6 | 52 | HEIMAN ELEMENTARY SCHOOL | 2016 | grade_5 | 55 | 2 | 64 | 1 | 1 | 1 | 2 | 65 | 61 | 126 | 55 | 2 | 64 | 1 | 1 | 1 | 2 | 65 | 61 | 126 | |||||||||||||||||||||||||||||||||||||||||
836808 | 836808 | CO | school | 802910 | 130 | CHERRY CREEK 5 | 80291000198 | 5934 | MISSION VIEJO ELEMENTARY SCHOOL | Regular School | No | 1.0 | PK | 05 | 2016 | grade_5 | 66 | 17 | 29 | 0 | 7 | 0 | 6 | 51 | 74 | 125 | 66 | 17 | 29 | 0 | 7 | 0 | 6 | 51 | 74 | 125 | ||||||||||||||||||||||||||||||||||
840825 | 840825 | CO | school | 803450 | 900 | DOUGLAS COUNTY RE 1 | 80345001339 | 6406 | NORTHRIDGE ELEMENTARY SCHOOL | Regular School | No | 1.0 | PK | 06 | 2016 | grade_5 | 88 | 2 | 14 | 0 | 14 | 0 | 7 | 64 | 61 | 125 | 88 | 2 | 14 | 0 | 14 | 0 | 7 | 64 | 61 | 125 | ||||||||||||||||||||||||||||||||||
836211 | 836211 | CO | school | 802580 | 40 | SCHOOL DISTRICT 27J | 80258001950 | 7714 | SECOND CREEK ELEMENTARY SCHOOL | Regular School | No | 1.0 | PK | 05 | 2016 | grade_5 | 53 | 6 | 51 | 1 | 7 | 0 | 5 | 57 | 66 | 123 | 53 | 6 | 51 | 1 | 7 | 0 | 5 | 57 | 66 | 123 | ||||||||||||||||||||||||||||||||||
839422 | 839422 | CO | school | 803360 | 880 | DENVER COUNTY 1 | 80336001864 | 3340 | LENA ARCHULETA ELEMENTARY SCHOOL | Regular School | No | 1.0 | KG | 05 | 2016 | grade_5 | 5 | 19 | 91 | 0 | 4 | 0 | 4 | 62 | 61 | 123 | 5 | 19 | 91 | 0 | 4 | 0 | 4 | 62 | 61 | 123 | ||||||||||||||||||||||||||||||||||
842792 | 842792 | CO | school | 1180 | ROARING FORK RE-1 | 561 | BASALT MIDDLE SCHOOL | 2016 | grade_5 | 59 | 0 | 59 | 0 | 1 | 0 | 4 | 54 | 69 | 123 | 59 | 0 | 59 | 0 | 1 | 0 | 4 | 54 | 69 | 123 | |||||||||||||||||||||||||||||||||||||||||
835922 | 835922 | CO | school | 806900 | 20 | ADAMS 12 FIVE STAR SCHOOLS | 80690002028 | 7795 | SILVER CREEK ELEMENTARY | Regular School | No | 1.0 | KG | 05 | 2016 | grade_5 | 90 | 5 | 18 | 1 | 4 | 0 | 4 | 54 | 68 | 122 | 90 | 5 | 18 | 1 | 4 | 0 | 4 | 54 | 68 | 122 | ||||||||||||||||||||||||||||||||||
848534 | 848534 | CO | school | 800282 | 9170 | COLORADO DIGITAL BOCES | 80028206600 | 1550 | COLORADO PREP ACADEMY | Regular School | No | 4.0 | KG | 12 | 2016 | grade_5 | 79 | 6 | 30 | 1 | 4 | 1 | 1 | 69 | 53 | 122 | 79 | 6 | 30 | 1 | 4 | 1 | 1 | 69 | 53 | 122 | ||||||||||||||||||||||||||||||||||
838313 | 838313 | CO | school | 802490 | 480 | BOULDER VALLEY RE 2 | 80249000110 | 1996 | CREST VIEW ELEMENTARY SCHOOL | Regular School | No | 1.0 | KG | 05 | 2016 | grade_5 | 79 | 1 | 23 | 1 | 5 | 0 | 12 | 60 | 61 | 121 | 79 | 1 | 23 | 1 | 5 | 0 | 12 | 60 | 61 | 121 | ||||||||||||||||||||||||||||||||||
840851 | 840851 | CO | school | 803450 | 900 | DOUGLAS COUNTY RE 1 | 80345000444 | 6940 | PINE LANE ELEMENTARY | Regular School | No | 1.0 | PK | 06 | 2016 | grade_5 | 88 | 3 | 20 | 1 | 1 | 0 | 8 | 66 | 55 | 121 | 88 | 3 | 20 | 1 | 1 | 0 | 8 | 66 | 55 | 121 | ||||||||||||||||||||||||||||||||||
835612 | 835612 | CO | school | 805550 | 10 | MAPLETON 1 | 80555006488 | 1796 | COLORADO CONNECTIONS ACADEMY | Regular School | No | 4.0 | KG | 12 | 2016 | grade_5 | 84 | 7 | 16 | 1 | 7 | 0 | 5 | 57 | 63 | 120 | 84 | 7 | 16 | 1 | 7 | 0 | 5 | 57 | 63 | 120 | ||||||||||||||||||||||||||||||||||
847676 | 847676 | CO | school | 807350 | 3100 | WINDSOR RE-4 | 80735001262 | 6750 | MOUNTAIN VIEW ELEMENTARY SCHOOL | Regular School | No | 1.0 | 03 | 05 | 2016 | grade_5 | 91 | 0 | 23 | 2 | 1 | 0 | 3 | 61 | 59 | 120 | 91 | 0 | 23 | 2 | 1 | 0 | 3 | 61 | 59 | 120 | ||||||||||||||||||||||||||||||||||
847766 | 847766 | CO | school | 804830 | 3110 | JOHNSTOWN-MILLIKEN RE-5J | 80483001911 | 6963 | PIONEER RIDGE ELEMENTARY SCHOOL | Regular School | No | 1.0 | KG | 05 | 2016 | grade_5 | 101 | 0 | 17 | 0 | 1 | 0 | 1 | 71 | 49 | 120 | 101 | 0 | 17 | 0 | 1 | 0 | 1 | 71 | 49 | 120 | ||||||||||||||||||||||||||||||||||
847866 | 847866 | CO | school | 804410 | 3120 | GREELEY 6 | 80441001696 | 2850 | UNIVERSITY SCHOOLS | Regular School | Yes | 4.0 | KG | 12 | 2016 | grade_5 | 84 | 0 | 31 | 0 | 1 | 1 | 3 | 59 | 61 | 120 | 84 | 0 | 31 | 0 | 1 | 1 | 3 | 59 | 61 | 120 | ||||||||||||||||||||||||||||||||||
836668 | 836668 | CO | school | 802910 | 130 | CHERRY CREEK 5 | 80291000188 | 1916 | COTTONWOOD CREEK ELEMENTARY SCHOOL | Regular School | No | 1.0 | PK | 05 | 2016 | grade_5 | 82 | 0 | 7 | 0 | 25 | 0 | 5 | 64 | 55 | 119 | 82 | 0 | 7 | 0 | 25 | 0 | 5 | 64 | 55 | 119 | ||||||||||||||||||||||||||||||||||
836946 | 836946 | CO | school | 802910 | 130 | CHERRY CREEK 5 | 80291000204 | 9108 | VILLAGE EAST COMMUNITY ELEMENTARY SCHOOL | Regular School | No | 1.0 | PK | 05 | 2016 | grade_5 | 33 | 30 | 37 | 1 | 10 | 0 | 8 | 65 | 54 | 119 | 33 | 30 | 37 | 1 | 10 | 0 | 8 | 65 | 54 | 119 | ||||||||||||||||||||||||||||||||||
836044 | 836044 | CO | school | 801950 | 30 | ADAMS COUNTY 14 | 80195000013 | 2308 | DUPONT ELEMENTARY SCHOOL | Regular School | No | 1.0 | KG | 05 | 2016 | grade_5 | 17 | 4 | 92 | 1 | 0 | 0 | 4 | 61 | 57 | 118 | 17 | 4 | 92 | 1 | 0 | 0 | 4 | 61 | 57 | 118 | ||||||||||||||||||||||||||||||||||
843221 | 843221 | CO | school | 1420 | JEFFERSON COUNTY R-1 | 779 | BERGEN VALLEY INTERMEDIATE SCHOOL | 2016 | grade_5 | 106 | 0 | 5 | 0 | 2 | 0 | 5 | 61 | 57 | 118 | 106 | 0 | 5 | 0 | 2 | 0 | 5 | 61 | 57 | 118 | |||||||||||||||||||||||||||||||||||||||||
846313 | 846313 | CO | school | 805130 | 2520 | EAST OTERO R-1 | 80513001974 | 4841 | LA JUNTA INTERMEDIATE SCHOOL | Regular School | No | 1.0 | 03 | 06 | 2016 | grade_5 | 30 | 5 | 80 | 1 | 0 | 1 | 1 | 62 | 56 | 118 | 30 | 5 | 80 | 1 | 0 | 1 | 1 | 62 | 56 | 118 | ||||||||||||||||||||||||||||||||||
836918 | 836918 | CO | school | 802910 | 130 | CHERRY CREEK 5 | 80291001378 | 8394 | SUNRISE ELEMENTARY SCHOOL | Regular School | No | 1.0 | PK | 05 | 2016 | grade_5 | 52 | 22 | 30 | 2 | 4 | 0 | 7 | 57 | 60 | 117 | 52 | 22 | 30 | 2 | 4 | 0 | 7 | 57 | 60 | 117 | ||||||||||||||||||||||||||||||||||
839751 | 839751 | CO | school | 803360 | 880 | DENVER COUNTY 1 | 80336001276 | 5685 | MCGLONE ELEMENTARY SCHOOL | Regular School | No | 1.0 | PK | 05 | 2016 | grade_5 | 2 | 20 | 94 | 0 | 0 | 0 | 1 | 56 | 61 | 117 | 2 | 20 | 94 | 0 | 0 | 0 | 1 | 56 | 61 | 117 | ||||||||||||||||||||||||||||||||||
840381 | 840381 | CO | school | 900 | DOUGLAS COUNTY RE 1 | 266 | GOLD RUSH ELEMENTARY | 2016 | grade_5 | 98 | 1 | 11 | 1 | 3 | 1 | 2 | 59 | 58 | 117 | 98 | 1 | 11 | 1 | 3 | 1 | 2 | 59 | 58 | 117 | |||||||||||||||||||||||||||||||||||||||||
835705 | 835705 | CO | school | 806900 | 20 | ADAMS 12 FIVE STAR SCHOOLS | 80690001305 | 1914 | COTTON CREEK ELEMENTARY SCHOOL | Regular School | No | 1.0 | KG | 05 | 2016 | grade_5 | 76 | 4 | 21 | 0 | 5 | 0 | 10 | 65 | 51 | 116 | 76 | 4 | 21 | 0 | 5 | 0 | 10 | 65 | 51 | 116 | ||||||||||||||||||||||||||||||||||
836653 | 836653 | CO | school | 802910 | 130 | CHERRY CREEK 5 | 80291000187 | 1574 | CHERRY HILLS VILLAGE ELEMENTARY SCHOOL | Regular School | No | 1.0 | PK | 05 | 2016 | grade_5 | 99 | 0 | 8 | 1 | 7 | 0 | 1 | 65 | 51 | 116 | 99 | 0 | 8 | 1 | 7 | 0 | 1 | 65 | 51 | 116 | ||||||||||||||||||||||||||||||||||
836675 | 836675 | CO | school | 802910 | 130 | CHERRY CREEK 5 | 80291001404 | 1970 | CREEKSIDE ELEMENTARY SCHOOL | Regular School | No | 1.0 | PK | 05 | 2016 | grade_5 | 77 | 12 | 11 | 1 | 9 | 0 | 6 | 64 | 52 | 116 | 77 | 12 | 11 | 1 | 9 | 0 | 6 | 64 | 52 | 116 | ||||||||||||||||||||||||||||||||||
839481 | 839481 | CO | school | 803360 | 880 | DENVER COUNTY 1 | 80336001776 | 3641 | GREEN VALLEY ELEMENTARY SCHOOL | Regular School | No | 1.0 | PK | 05 | 2016 | grade_5 | 6 | 34 | 60 | 0 | 8 | 2 | 5 | 61 | 54 | 115 | 6 | 34 | 60 | 0 | 8 | 2 | 5 | 61 | 54 | 115 | ||||||||||||||||||||||||||||||||||
839514 | 839514 | CO | school | 803360 | 880 | DENVER COUNTY 1 | 80336000359 | 3704 | GUST ELEMENTARY SCHOOL | Regular School | No | 1.0 | PK | 05 | 2016 | grade_5 | 12 | 5 | 94 | 0 | 4 | 0 | 0 | 60 | 55 | 115 | 12 | 5 | 94 | 0 | 4 | 0 | 0 | 60 | 55 | 115 | ||||||||||||||||||||||||||||||||||
837110 | 837110 | CO | school | 805310 | 140 | LITTLETON 6 | 80531000893 | 9600 | WILDER ELEMENTARY SCHOOL | Regular School | No | 1.0 | PK | 05 | 2016 | grade_5 | 97 | 0 | 12 | 0 | 2 | 0 | 2 | 60 | 53 | 113 | 97 | 0 | 12 | 0 | 2 | 0 | 2 | 60 | 53 | 113 | ||||||||||||||||||||||||||||||||||
838002 | 838002 | CO | school | 805370 | 470 | ST VRAIN VALLEY RE 1J | 80537006531 | 5181 | RED HAWK ELEMENTARY | Regular School | No | 1.0 | PK | 05 | 2016 | grade_5 | 101 | 0 | 8 | 0 | 1 | 0 | 3 | 58 | 55 | 113 | 101 | 0 | 8 | 0 | 1 | 0 | 3 | 58 | 55 | 113 | ||||||||||||||||||||||||||||||||||
846732 | 846732 | CO | school | 806120 | 2690 | PUEBLO CITY 60 | 80612006361 | 2096 | CORWIN INTERNATIONAL MAGNET SCHOOL | Regular School | No | 2.0 | 04 | 08 | 2016 | grade_5 | 46 | 0 | 62 | 1 | 3 | 0 | 1 | 60 | 53 | 113 | 46 | 0 | 62 | 1 | 3 | 0 | 1 | 60 | 53 | 113 | ||||||||||||||||||||||||||||||||||
835859 | 835859 | CO | school | 806900 | 20 | ADAMS 12 FIVE STAR SCHOOLS | 80690001362 | 6150 | MOUNTAIN VIEW ELEMENTARY SCHOOL | Regular School | No | 1.0 | PK | 05 | 2016 | grade_5 | 80 | 2 | 19 | 2 | 4 | 0 | 5 | 56 | 56 | 112 | 80 | 2 | 19 | 2 | 4 | 0 | 5 | 56 | 56 | 112 | ||||||||||||||||||||||||||||||||||
840561 | 840561 | CO | school | 803450 | 900 | DOUGLAS COUNTY RE 1 | 80345001476 | 2234 | EAGLE RIDGE ELEMENTARY SCHOOL | Regular School | No | 1.0 | PK | 06 | 2016 | grade_5 | 88 | 3 | 15 | 0 | 4 | 0 | 2 | 60 | 52 | 112 | 88 | 3 | 15 | 0 | 4 | 0 | 2 | 60 | 52 | 112 | ||||||||||||||||||||||||||||||||||
840719 | 840719 | CO | school | 803450 | 900 | DOUGLAS COUNTY RE 1 | 80345006493 | 5259 | STEM MIDDLE & HIGH SCHOOL | Regular School | Yes | 4.0 | 05 | 12 | 2016 | grade_5 | 83 | 0 | 9 | 0 | 12 | 0 | 8 | 77 | 35 | 112 | 83 | 0 | 9 | 0 | 12 | 0 | 8 | 77 | 35 | 112 | ||||||||||||||||||||||||||||||||||
841561 | 841561 | CO | school | 804080 | 1000 | FOUNTAIN 8 | 80408006330 | 3027 | EAGLESIDE ELEMENTARY SCHOOL | Regular School | No | 1.0 | PK | 05 | 2016 | grade_5 | 53 | 8 | 33 | 1 | 3 | 1 | 13 | 59 | 53 | 112 | 53 | 8 | 33 | 1 | 3 | 1 | 13 | 59 | 53 | 112 | ||||||||||||||||||||||||||||||||||
836169 | 836169 | CO | school | 802580 | 40 | SCHOOL DISTRICT 27J | 80258001949 | 5615 | MARY E PENNOCK ELEMENTARY SCHOOL | Regular School | No | 1.0 | KG | 05 | 2016 | grade_5 | 54 | 0 | 52 | 0 | 2 | 0 | 3 | 50 | 61 | 111 | 54 | 0 | 52 | 0 | 2 | 0 | 3 | 50 | 61 | 111 | ||||||||||||||||||||||||||||||||||
836563 | 836563 | CO | school | 130 | CHERRY CREEK 5 | 243 | COYOTE HILLS ELEMENTARY SCHOOL | 2016 | grade_5 | 84 | 6 | 11 | 0 | 6 | 0 | 4 | 60 | 51 | 111 | 84 | 6 | 11 | 0 | 6 | 0 | 4 | 60 | 51 | 111 | |||||||||||||||||||||||||||||||||||||||||
836702 | 836702 | CO | school | 802910 | 130 | CHERRY CREEK 5 | 80291000191 | 2428 | EASTRIDGE COMMUNITY ELEMENTARY SCHOOL | Regular School | No | 1.0 | PK | 05 | 2016 | grade_5 | 30 | 27 | 42 | 1 | 5 | 1 | 5 | 60 | 51 | 111 | 30 | 27 | 42 | 1 | 5 | 1 | 5 | 60 | 51 | 111 | ||||||||||||||||||||||||||||||||||
836882 | 836882 | CO | school | 802910 | 130 | CHERRY CREEK 5 | 80291001880 | 7277 | RED HAWK RIDGE ELEMENTARY SCHOOL | Regular School | No | 1.0 | PK | 05 | 2016 | grade_5 | 51 | 14 | 33 | 0 | 5 | 0 | 8 | 60 | 51 | 111 | 51 | 14 | 33 | 0 | 5 | 0 | 8 | 60 | 51 | 111 | ||||||||||||||||||||||||||||||||||
839986 | 839986 | CO | school | 803360 | 880 | DENVER COUNTY 1 | 80336000398 | 7554 | SABIN WORLD SCHOOL | Regular School | No | 1.0 | PK | 05 | 2016 | grade_5 | 25 | 2 | 78 | 0 | 5 | 0 | 1 | 52 | 59 | 111 | 25 | 2 | 78 | 0 | 5 | 0 | 1 | 52 | 59 | 111 | ||||||||||||||||||||||||||||||||||
841998 | 841998 | CO | school | 802940 | 1020 | CHEYENNE MOUNTAIN 12 | 80294001326 | 1582 | THE VANGUARD SCHOOL (ELEMENTARY) | Regular School | Yes | 1.0 | KG | 06 | 2016 | grade_5 | 74 | 3 | 25 | 1 | 6 | 0 | 2 | 46 | 65 | 111 | 74 | 3 | 25 | 1 | 6 | 0 | 2 | 46 | 65 | 111 | ||||||||||||||||||||||||||||||||||
836683 | 836683 | CO | school | 802910 | 130 | CHERRY CREEK 5 | 80291001671 | 2094 | DAKOTA VALLEY ELEMENTARY SCHOOL | Regular School | No | 1.0 | PK | 05 | 2016 | grade_5 | 65 | 7 | 18 | 0 | 13 | 0 | 7 | 61 | 49 | 110 | 65 | 7 | 18 | 0 | 13 | 0 | 7 | 61 | 49 | 110 | ||||||||||||||||||||||||||||||||||
842177 | 842177 | CO | school | 801920 | 1040 | ACADEMY 20 | 80192006631 | 1929 | DISCOVERY CANYON CAMPUS ELEMENTARY SCHOOL | Regular School | No | 1.0 | PK | 05 | 2016 | grade_5 | 79 | 3 | 11 | 0 | 8 | 0 | 9 | 65 | 45 | 110 | 79 | 3 | 11 | 0 | 8 | 0 | 9 | 65 | 45 | 110 | ||||||||||||||||||||||||||||||||||
839921 | 839921 | CO | school | 803360 | 880 | DENVER COUNTY 1 | 80336001933 | 6970 | FLORIDA PITT-WALLER ECE-8 SCHOOL | Regular School | No | 1.0 | PK | 08 | 2016 | grade_5 | 5 | 30 | 61 | 2 | 3 | 0 | 8 | 55 | 54 | 109 | 5 | 30 | 61 | 2 | 3 | 0 | 8 | 55 | 54 | 109 | ||||||||||||||||||||||||||||||||||
840907 | 840907 | CO | school | 803450 | 900 | DOUGLAS COUNTY RE 1 | 80345001900 | 7297 | REDSTONE ELEMENTARY SCHOOL | Regular School | No | 1.0 | PK | 06 | 2016 | grade_5 | 86 | 1 | 12 | 0 | 5 | 0 | 5 | 62 | 47 | 109 | 86 | 1 | 12 | 0 | 5 | 0 | 5 | 62 | 47 | 109 | ||||||||||||||||||||||||||||||||||
842091 | 842091 | CO | school | 1040 | ACADEMY 20 | 17 | ACADEMY ENDEAVOUR ELEMENTARY SCHOOL | 2016 | grade_5 | 73 | 2 | 21 | 1 | 5 | 1 | 6 | 52 | 57 | 109 | 73 | 2 | 21 | 1 | 5 | 1 | 6 | 52 | 57 | 109 | |||||||||||||||||||||||||||||||||||||||||
842626 | 842626 | CO | school | 803870 | 1110 | FALCON 49 | 80387001686 | 9706 | WOODMEN HILLS ELEMENTARY SCHOOL | Regular School | No | 1.0 | PK | 05 | 2016 | grade_5 | 74 | 5 | 19 | 1 | 1 | 0 | 9 | 52 | 57 | 109 | 74 | 5 | 19 | 1 | 1 | 0 | 9 | 52 | 57 | 109 | ||||||||||||||||||||||||||||||||||
843986 | 843986 | CO | school | 804800 | 1420 | JEFFERSON COUNTY R-1 | 80480001006 | 7128 | POWDERHORN ELEMENTARY SCHOOL | Regular School | No | 1.0 | KG | 06 | 2016 | grade_5 | 73 | 2 | 23 | 0 | 5 | 1 | 5 | 51 | 58 | 109 | 73 | 2 | 23 | 0 | 5 | 1 | 5 | 51 | 58 | 109 | ||||||||||||||||||||||||||||||||||
847811 | 847811 | CO | school | 804410 | 3120 | GREELEY 6 | 80441000636 | 1384 | CENTENNIAL ELEMENTARY SCHOOL | Regular School | No | 1.0 | KG | 05 | 2016 | grade_5 | 14 | 7 | 79 | 1 | 8 | 0 | 0 | 66 | 43 | 109 | 14 | 7 | 79 | 1 | 8 | 0 | 0 | 66 | 43 | 109 | ||||||||||||||||||||||||||||||||||
835721 | 835721 | CO | school | 806900 | 20 | ADAMS 12 FIVE STAR SCHOOLS | 80690001622 | 2361 | EAGLEVIEW ELEMENTARY SCHOOL | Regular School | No | 1.0 | KG | 05 | 2016 | grade_5 | 67 | 3 | 29 | 0 | 6 | 0 | 3 | 55 | 53 | 108 | 67 | 3 | 29 | 0 | 6 | 0 | 3 | 55 | 53 | 108 | ||||||||||||||||||||||||||||||||||
836258 | 836258 | CO | school | 802580 | 40 | SCHOOL DISTRICT 27J | 80258006326 | 9426 | WEST RIDGE ELEMENTARY | Regular School | No | 1.0 | PK | 05 | 2016 | grade_5 | 60 | 2 | 29 | 1 | 11 | 0 | 5 | 58 | 50 | 108 | 60 | 2 | 29 | 1 | 11 | 0 | 5 | 58 | 50 | 108 | ||||||||||||||||||||||||||||||||||
836601 | 836601 | CO | school | 802910 | 130 | CHERRY CREEK 5 | 80291001831 | 1273 | CANYON CREEK ELEMENTARY SCHOOL | Regular School | No | 1.0 | PK | 05 | 2016 | grade_5 | 53 | 18 | 19 | 2 | 14 | 0 | 2 | 58 | 50 | 108 | 53 | 18 | 19 | 2 | 14 | 0 | 2 | 58 | 50 | 108 | ||||||||||||||||||||||||||||||||||
836594 | 836594 | CO | school | 802910 | 130 | CHERRY CREEK 5 | 80291006301 | 1155 | BUFFALO TRAIL ELEMENTARY SCHOOL | Regular School | No | 1.0 | PK | 06 | 2016 | grade_5 | 76 | 9 | 6 | 0 | 9 | 0 | 7 | 53 | 54 | 107 | 76 | 9 | 6 | 0 | 9 | 0 | 7 | 53 | 54 | 107 | ||||||||||||||||||||||||||||||||||
837056 | 837056 | CO | school | 805310 | 140 | LITTLETON 6 | 80531001300 | 5236 | LOIS LENSKI ELEMENTARY SCHOOL | Regular School | No | 1.0 | KG | 05 | 2016 | grade_5 | 89 | 1 | 4 | 0 | 5 | 0 | 8 | 57 | 50 | 107 | 89 | 1 | 4 | 0 | 5 | 0 | 8 | 57 | 50 | 107 | ||||||||||||||||||||||||||||||||||
837620 | 837620 | CO | school | 802700 | 190 | BYERS 32J | 80270006605 | 2356 | ELEVATE ACADEMY | Regular School | Yes | 4.0 | KG | 12 | 2016 | grade_5 | 6 | 4 | 97 | 0 | 0 | 0 | 0 | 60 | 47 | 107 | 6 | 4 | 97 | 0 | 0 | 0 | 0 | 60 | 47 | 107 | ||||||||||||||||||||||||||||||||||
837660 | 837660 | CO | school | 802190 | 220 | ARCHULETA COUNTY 50 JT | 80219000040 | 6657 | PAGOSA SPRINGS MIDDLE SCHOOL | Regular School | No | 2.0 | 05 | 08 | 2016 | grade_5 | 8 | 1 | 96 | 2 | 0 | 0 | 0 | 55 | 52 | 107 | 8 | 1 | 96 | 2 | 0 | 0 | 0 | 55 | 52 | 107 | ||||||||||||||||||||||||||||||||||
837797 | 837797 | CO | school | 470 | ST VRAIN VALLEY RE 1J | 60 | LEGACY ELEMENTARY SCHOOL | 2016 | grade_5 | 81 | 0 | 21 | 0 | 1 | 0 | 3 | 61 | 45 | 106 | 81 | 0 | 21 | 0 | 1 | 0 | 3 | 61 | 45 | 106 | |||||||||||||||||||||||||||||||||||||||||
840219 | 840219 | CO | school | 803360 | 880 | DENVER COUNTY 1 | 80336001957 | 9425 | WESTERLY CREEK ELEMENTARY | Regular School | No | 1.0 | PK | 05 | 2016 | grade_5 | 70 | 15 | 13 | 0 | 4 | 0 | 4 | 53 | 53 | 106 | 70 | 15 | 13 | 0 | 4 | 0 | 4 | 53 | 53 | 106 | ||||||||||||||||||||||||||||||||||
840501 | 840501 | CO | school | 803450 | 900 | DOUGLAS COUNTY RE 1 | 80345001897 | 1899 | COPPER MESA ELEMENTARY SCHOOL | Regular School | No | 1.0 | PK | 06 | 2016 | grade_5 | 86 | 0 | 10 | 0 | 6 | 0 | 4 | 55 | 51 | 106 | 86 | 0 | 10 | 0 | 6 | 0 | 4 | 55 | 51 | 106 | ||||||||||||||||||||||||||||||||||
841022 | 841022 | CO | school | 803450 | 900 | DOUGLAS COUNTY RE 1 | 80345001639 | 9592 | WILDCAT MOUNTAIN ELEMENTARY SCHOOL | Regular School | No | 1.0 | PK | 05 | 2016 | grade_5 | 88 | 0 | 9 | 0 | 7 | 0 | 2 | 56 | 50 | 106 | 88 | 0 | 9 | 0 | 7 | 0 | 2 | 56 | 50 | 106 | ||||||||||||||||||||||||||||||||||
841909 | 841909 | CO | school | 803060 | 1010 | COLORADO SPRINGS 11 | 80306000262 | 7482 | ROOSEVELT EDISON CHARTER SCHOOL | Regular School | Yes | 1.0 | KG | 05 | 2016 | grade_5 | 21 | 7 | 74 | 0 | 0 | 0 | 4 | 57 | 49 | 106 | 21 | 7 | 74 | 0 | 0 | 0 | 4 | 57 | 49 | 106 | ||||||||||||||||||||||||||||||||||
846235 | 846235 | CO | school | 802610 | 2395 | BRUSH RE-2(J) | 80261000155 | 1438 | BEAVER VALLEY ELEMENTARY SCHOOL | Regular School | No | 1.0 | 03 | 06 | 2016 | grade_5 | 60 | 0 | 44 | 0 | 0 | 0 | 2 | 53 | 53 | 106 | 60 | 0 | 44 | 0 | 0 | 0 | 2 | 53 | 53 | 106 | ||||||||||||||||||||||||||||||||||
840585 | 840585 | CO | school | 803450 | 900 | DOUGLAS COUNTY RE 1 | 80345006337 | 2952 | MAMMOTH HEIGHTS ELEMENTARY | Regular School | No | 1.0 | PK | 06 | 2016 | grade_5 | 85 | 0 | 13 | 1 | 2 | 2 | 2 | 48 | 57 | 105 | 85 | 0 | 13 | 1 | 2 | 2 | 2 | 48 | 57 | 105 | ||||||||||||||||||||||||||||||||||
844806 | 844806 | CO | school | 803990 | 1550 | POUDRE R-1 | 80399000147 | 4793 | KRUSE ELEMENTARY SCHOOL | Regular School | No | 1.0 | PK | 05 | 2016 | grade_5 | 80 | 4 | 18 | 0 | 1 | 0 | 2 | 49 | 56 | 105 | 80 | 4 | 18 | 0 | 1 | 0 | 2 | 49 | 56 | 105 | ||||||||||||||||||||||||||||||||||
837241 | 837241 | CO | school | 802340 | 180 | ADAMS-ARAPAHOE 28J | 80234000058 | 1948 | CRAWFORD ELEMENTARY SCHOOL | Regular School | No | 1.0 | PK | 05 | 2016 | grade_5 | 3 | 13 | 60 | 0 | 27 | 0 | 1 | 56 | 48 | 104 | 3 | 13 | 60 | 0 | 27 | 0 | 1 | 56 | 48 | 104 | ||||||||||||||||||||||||||||||||||
838177 | 838177 | CO | school | 805370 | 470 | ST VRAIN VALLEY RE 1J | 80537001572 | 8927 | TWIN PEAKS CHARTER ACADEMY | Regular School | Yes | 4.0 | KG | 12 | 2016 | grade_5 | 50 | 2 | 39 | 0 | 7 | 0 | 6 | 52 | 52 | 104 | 50 | 2 | 39 | 0 | 7 | 0 | 6 | 52 | 52 | 104 | ||||||||||||||||||||||||||||||||||
840743 | 840743 | CO | school | 803450 | 900 | DOUGLAS COUNTY RE 1 | 80345006472 | 5607 | SAGE CANYON ELEMENTARY | Regular School | No | 1.0 | PK | 06 | 2016 | grade_5 | 80 | 0 | 13 | 3 | 4 | 0 | 4 | 63 | 41 | 104 | 80 | 0 | 13 | 3 | 4 | 0 | 4 | 63 | 41 | 104 | ||||||||||||||||||||||||||||||||||
840782 | 840782 | CO | school | 803450 | 900 | DOUGLAS COUNTY RE 1 | 80345006588 | 6019 | ASPEN VIEW ACADEMY | Regular School | Yes | 1.0 | PK | 08 | 2016 | grade_5 | 77 | 3 | 13 | 2 | 1 | 1 | 7 | 46 | 58 | 104 | 77 | 3 | 13 | 2 | 1 | 1 | 7 | 46 | 58 | 104 |
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]);