enrollments
Data source: Big Local News · About: Big Local
13,321 rows where state = "CO" and year = 2020 sorted by asian descending
This data as json, CSV (advanced)
grade ✖
- pk_12_total 1,916
- grade_5 1,108
- grade_2 1,104
- grade_1 1,102
- grade_4 1,102
- grade_3 1,101
- kindergarten_full_day 1,087
- grade_6 690
- pre_kindergarten 684
- grade_7 626
- grade_8 620
- grade_12 506
- grade_10 503
- grade_11 503
- grade_9 489
- kindergarten_half_day 180
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1804606 | 1804606 | CO | school | 803450 | 900 | Douglas County Re 1 | 80345001437 | 3980 | Highlands Ranch High School | Regular School | No | High | 09 | 12 | 2020 | pk_12_total | 1193 | 36 | 260 | 6 | 98 | 3 | 84 | 891 | 789 | 1680 | 1193 | 36 | 260 | 6 | 98 | 3 | 84 | 891 | 789 | 1680 | ||||||||||||||||||||||||||||||||||
1804936 | 1804936 | CO | school | 803450 | 900 | Douglas County Re 1 | 80345001529 | 8847 | Thunderridge High School | Regular School | No | High | 09 | 12 | 2020 | pk_12_total | 1560 | 17 | 243 | 7 | 97 | 4 | 114 | 1036 | 1006 | 2042 | 1560 | 17 | 243 | 7 | 97 | 4 | 114 | 1036 | 1006 | 2042 | ||||||||||||||||||||||||||||||||||
1802063 | 1802063 | CO | school | 805370 | 470 | St Vrain Valley RE1J | 80537001814 | 7789 | Silver Creek High School | Regular School | No | High | 09 | 12 | 2020 | pk_12_total | 1021 | 12 | 177 | 2 | 95 | 1 | 41 | 658 | 691 | 1349 | 1021 | 12 | 177 | 2 | 95 | 1 | 41 | 658 | 691 | 1349 | ||||||||||||||||||||||||||||||||||
1804264 | 1804264 | CO | school | 803450 | 900 | Douglas County Re 1 | 80345000436 | 12 | Acres Green Elementary School | Regular School | No | Elementary | PK | 06 | 2020 | pk_12_total | 242 | 2 | 112 | 3 | 93 | 2 | 39 | 242 | 251 | 493 | 242 | 2 | 112 | 3 | 93 | 2 | 39 | 242 | 251 | 493 | ||||||||||||||||||||||||||||||||||
1800404 | 1800404 | CO | school | 802910 | 130 | Cherry Creek 5 | 80291001710 | 16 | Fox Hollow Elementary School | Regular School | No | Elementary | PK | 05 | 2020 | pk_12_total | 375 | 46 | 96 | 4 | 91 | 0 | 45 | 341 | 316 | 657 | 375 | 46 | 96 | 4 | 91 | 0 | 45 | 341 | 316 | 657 | ||||||||||||||||||||||||||||||||||
1800596 | 1800596 | CO | school | 802910 | 130 | Cherry Creek 5 | 80291001625 | 3589 | Grandview High School | Regular School | No | High | 09 | 12 | 2020 | grade_10 | 431 | 60 | 110 | 6 | 91 | 4 | 45 | 393 | 354 | 747 | 431 | 60 | 110 | 6 | 91 | 4 | 45 | 393 | 354 | 747 | ||||||||||||||||||||||||||||||||||
1799465 | 1799465 | CO | school | 806900 | 20 | Adams 12 Five Star Schools | 80690001709 | 14 | Glacier Peak Elementary School | Regular School | No | Elementary | KG | 05 | 2020 | grade_5 | 35 | 2 | 34 | 0 | 9 | 0 | 5 | 47 | 38 | 85 | 35 | 2 | 34 | 0 | 9 | 0 | 5 | 47 | 38 | 85 | ||||||||||||||||||||||||||||||||||
1799476 | 1799476 | CO | school | 806900 | 20 | Adams 12 Five Star Schools | 80690001733 | 59 | Meridian Elementary School | Regular School | No | Elementary | KG | 05 | 2020 | grade_5 | 78 | 2 | 19 | 1 | 9 | 2 | 6 | 72 | 45 | 117 | 78 | 2 | 19 | 1 | 9 | 2 | 6 | 72 | 45 | 117 | ||||||||||||||||||||||||||||||||||
1799489 | 1799489 | CO | school | 806900 | 20 | Adams 12 Five Star Schools | 80690001619 | 301 | Arapahoe Ridge Elementary School | Regular School | No | Elementary | PK | 05 | 2020 | grade_2 | 32 | 1 | 36 | 0 | 9 | 0 | 1 | 48 | 31 | 79 | 32 | 1 | 36 | 0 | 9 | 0 | 1 | 48 | 31 | 79 | ||||||||||||||||||||||||||||||||||
1799528 | 1799528 | CO | school | 806900 | 20 | Adams 12 Five Star Schools | 80690001174 | 1878 | Coronado Hills Elementary School | Regular School | No | Elementary | PK | 05 | 2020 | pk_12_total | 81 | 13 | 466 | 2 | 9 | 0 | 7 | 314 | 264 | 578 | 81 | 13 | 466 | 2 | 9 | 0 | 7 | 314 | 264 | 578 | ||||||||||||||||||||||||||||||||||
1799546 | 1799546 | CO | school | 806900 | 20 | Adams 12 Five Star Schools | 80690001622 | 2361 | Eagleview Elementary School | Regular School | No | Elementary | KG | 05 | 2020 | grade_3 | 50 | 1 | 27 | 1 | 9 | 0 | 5 | 57 | 36 | 93 | 50 | 1 | 27 | 1 | 9 | 0 | 5 | 57 | 36 | 93 | ||||||||||||||||||||||||||||||||||
1799547 | 1799547 | CO | school | 806900 | 20 | Adams 12 Five Star Schools | 80690001622 | 2361 | Eagleview Elementary School | Regular School | No | Elementary | KG | 05 | 2020 | grade_4 | 54 | 1 | 21 | 0 | 9 | 2 | 2 | 50 | 39 | 89 | 54 | 1 | 21 | 0 | 9 | 2 | 2 | 50 | 39 | 89 | ||||||||||||||||||||||||||||||||||
1799623 | 1799623 | CO | school | 806900 | 20 | Adams 12 Five Star Schools | 80690001178 | 4172 | Hulstrom Options K-8 School | Regular School | No | Elementary | KG | 08 | 2020 | grade_7 | 42 | 0 | 10 | 0 | 9 | 0 | 9 | 29 | 41 | 70 | 42 | 0 | 10 | 0 | 9 | 0 | 9 | 29 | 41 | 70 | ||||||||||||||||||||||||||||||||||
1799716 | 1799716 | CO | school | 806900 | 20 | Adams 12 Five Star Schools | 80690006507 | 6802 | Prospect Ridge Academy | Regular School | Yes | Other | KG | 12 | 2020 | grade_11 | 77 | 1 | 6 | 1 | 9 | 0 | 3 | 50 | 47 | 97 | 77 | 1 | 6 | 1 | 9 | 0 | 3 | 50 | 47 | 97 | ||||||||||||||||||||||||||||||||||
1799724 | 1799724 | CO | school | 806900 | 20 | Adams 12 Five Star Schools | 80690006507 | 6802 | Prospect Ridge Academy | Regular School | Yes | Other | KG | 12 | 2020 | grade_8 | 90 | 0 | 21 | 1 | 9 | 0 | 9 | 57 | 73 | 130 | 90 | 0 | 21 | 1 | 9 | 0 | 9 | 57 | 73 | 130 | ||||||||||||||||||||||||||||||||||
1799725 | 1799725 | CO | school | 806900 | 20 | Adams 12 Five Star Schools | 80690006507 | 6802 | Prospect Ridge Academy | Regular School | Yes | Other | KG | 12 | 2020 | grade_9 | 88 | 1 | 17 | 1 | 9 | 0 | 7 | 60 | 63 | 123 | 88 | 1 | 17 | 1 | 9 | 0 | 7 | 60 | 63 | 123 | ||||||||||||||||||||||||||||||||||
1799748 | 1799748 | CO | school | 806900 | 20 | Adams 12 Five Star Schools | 80690002028 | 7795 | Silver Creek Elementary | Regular School | No | Elementary | KG | 05 | 2020 | kindergarten_full_day | 71 | 0 | 7 | 0 | 9 | 0 | 2 | 48 | 41 | 89 | 71 | 0 | 7 | 0 | 9 | 0 | 2 | 48 | 41 | 89 | ||||||||||||||||||||||||||||||||||
1799784 | 1799784 | CO | school | 806900 | 20 | Adams 12 Five Star Schools | 80690006561 | 8310 | STEM Launch | Regular School | No | Elementary | KG | 08 | 2020 | pk_12_total | 148 | 6 | 614 | 3 | 9 | 0 | 11 | 425 | 366 | 791 | 148 | 6 | 614 | 3 | 9 | 0 | 11 | 425 | 366 | 791 | ||||||||||||||||||||||||||||||||||
1799932 | 1799932 | CO | school | 802580 | 40 | School District 27J | 80258006549 | 1013 | Brantner Elementary School | Regular School | No | Elementary | PK | 05 | 2020 | grade_4 | 57 | 2 | 31 | 0 | 9 | 0 | 3 | 52 | 50 | 102 | 57 | 2 | 31 | 0 | 9 | 0 | 3 | 52 | 50 | 102 | ||||||||||||||||||||||||||||||||||
1799958 | 1799958 | CO | school | 802580 | 40 | School District 27J | 80258001729 | 1052 | Bromley East Charter School | Regular School | Yes | Elementary | PK | 08 | 2020 | pk_12_total | 730 | 8 | 395 | 3 | 9 | 2 | 34 | 600 | 581 | 1181 | 730 | 8 | 395 | 3 | 9 | 2 | 34 | 600 | 581 | 1181 | ||||||||||||||||||||||||||||||||||
1799963 | 1799963 | CO | school | 802580 | 40 | School District 27J | 80258006474 | 2399 | Eagle Ridge Academy | Regular School | Yes | High | 09 | 12 | 2020 | pk_12_total | 254 | 10 | 235 | 0 | 9 | 1 | 13 | 251 | 271 | 522 | 254 | 10 | 235 | 0 | 9 | 1 | 13 | 251 | 271 | 522 | ||||||||||||||||||||||||||||||||||
1800021 | 1800021 | CO | school | 802580 | 40 | School District 27J | 80258006420 | 6702 | Otho E Stuart Middle School | Regular School | No | Middle | 06 | 08 | 2020 | grade_7 | 105 | 20 | 115 | 0 | 9 | 0 | 17 | 141 | 125 | 266 | 105 | 20 | 115 | 0 | 9 | 0 | 17 | 141 | 125 | 266 | ||||||||||||||||||||||||||||||||||
1800088 | 1800088 | CO | school | 802580 | 40 | School District 27J | 80258006401 | 8820 | Turnberry Elementary | Regular School | No | Elementary | PK | 05 | 2020 | kindergarten_full_day | 43 | 5 | 56 | 0 | 9 | 0 | 1 | 64 | 50 | 114 | 43 | 5 | 56 | 0 | 9 | 0 | 1 | 64 | 50 | 114 | ||||||||||||||||||||||||||||||||||
1800098 | 1800098 | CO | school | 802580 | 40 | School District 27J | 80258006326 | 9426 | West Ridge Elementary | Regular School | No | Elementary | PK | 05 | 2020 | grade_4 | 76 | 0 | 27 | 0 | 9 | 0 | 3 | 57 | 58 | 115 | 76 | 0 | 27 | 0 | 9 | 0 | 3 | 57 | 58 | 115 | ||||||||||||||||||||||||||||||||||
1800102 | 1800102 | CO | school | 802580 | 40 | School District 27J | 80258006326 | 9426 | West Ridge Elementary | Regular School | No | Elementary | PK | 05 | 2020 | pre_kindergarten | 22 | 1 | 19 | 0 | 9 | 0 | 1 | 28 | 24 | 52 | 22 | 1 | 19 | 0 | 9 | 0 | 1 | 28 | 24 | 52 | ||||||||||||||||||||||||||||||||||
1800152 | 1800152 | CO | school | 807230 | 70 | Westminster Public Schools | 80723001232 | 1622 | Metropolitan Arts Academy | Regular School | No | Elementary | PK | 06 | 2020 | pk_12_total | 46 | 5 | 261 | 2 | 9 | 2 | 7 | 167 | 165 | 332 | 46 | 5 | 261 | 2 | 9 | 2 | 7 | 167 | 165 | 332 | ||||||||||||||||||||||||||||||||||
1800259 | 1800259 | CO | school | 807230 | 70 | Westminster Public Schools | 80723001249 | 8798 | Tennyson Knolls Elementary School | Regular School | No | Elementary | PK | 05 | 2020 | grade_2 | 8 | 0 | 41 | 1 | 9 | 0 | 0 | 31 | 28 | 59 | 8 | 0 | 41 | 1 | 9 | 0 | 0 | 31 | 28 | 59 | ||||||||||||||||||||||||||||||||||
1800365 | 1800365 | CO | school | 803780 | 120 | Englewood 1 | 80378000029 | 5318 | Englewood Early Childhood Education Center at Maddox | Regular School | No | Prekindergarten | PK | PK | 2020 | pk_12_total | 114 | 7 | 90 | 0 | 9 | 0 | 10 | 117 | 113 | 230 | 114 | 7 | 90 | 0 | 9 | 0 | 10 | 117 | 113 | 230 | ||||||||||||||||||||||||||||||||||
1800366 | 1800366 | CO | school | 803780 | 120 | Englewood 1 | 80378000029 | 5318 | Englewood Early Childhood Education Center at Maddox | Regular School | No | Prekindergarten | PK | PK | 2020 | pre_kindergarten | 114 | 7 | 90 | 0 | 9 | 0 | 10 | 117 | 113 | 230 | 114 | 7 | 90 | 0 | 9 | 0 | 10 | 117 | 113 | 230 | ||||||||||||||||||||||||||||||||||
1800405 | 1800405 | CO | school | 802910 | 130 | Cherry Creek 5 | 80291001710 | 16 | Fox Hollow Elementary School | Regular School | No | Elementary | PK | 05 | 2020 | pre_kindergarten | 38 | 4 | 10 | 0 | 9 | 0 | 4 | 35 | 30 | 65 | 38 | 4 | 10 | 0 | 9 | 0 | 4 | 35 | 30 | 65 | ||||||||||||||||||||||||||||||||||
1800429 | 1800429 | CO | school | 802910 | 130 | Cherry Creek 5 | 80291001670 | 242 | Antelope Ridge Elementary School | Regular School | No | Elementary | PK | 05 | 2020 | grade_4 | 61 | 11 | 27 | 0 | 9 | 0 | 10 | 66 | 52 | 118 | 61 | 11 | 27 | 0 | 9 | 0 | 10 | 66 | 52 | 118 | ||||||||||||||||||||||||||||||||||
1800464 | 1800464 | CO | school | 802910 | 130 | Cherry Creek 5 | 80291006301 | 1155 | Buffalo Trail Elementary School | Regular School | No | Elementary | PK | 06 | 2020 | grade_2 | 51 | 10 | 19 | 0 | 9 | 0 | 14 | 56 | 47 | 103 | 51 | 10 | 19 | 0 | 9 | 0 | 14 | 56 | 47 | 103 | ||||||||||||||||||||||||||||||||||
1800559 | 1800559 | CO | school | 802910 | 130 | Cherry Creek 5 | 80291001671 | 2094 | Dakota Valley Elementary School | Regular School | No | Elementary | PK | 05 | 2020 | grade_4 | 57 | 5 | 25 | 2 | 9 | 0 | 8 | 51 | 55 | 106 | 57 | 5 | 25 | 2 | 9 | 0 | 8 | 51 | 55 | 106 | ||||||||||||||||||||||||||||||||||
1800610 | 1800610 | CO | school | 802910 | 130 | Cherry Creek 5 | 80291000193 | 3926 | Heritage Elementary School | Regular School | No | Elementary | PK | 05 | 2020 | grade_3 | 38 | 1 | 8 | 0 | 9 | 1 | 1 | 26 | 32 | 58 | 38 | 1 | 8 | 0 | 9 | 1 | 1 | 26 | 32 | 58 | ||||||||||||||||||||||||||||||||||
1800697 | 1800697 | CO | school | 802910 | 130 | Cherry Creek 5 | 80291006607 | 6225 | Mountain Vista Elementary School | Regular School | No | Elementary | PK | 05 | 2020 | grade_1 | 61 | 17 | 16 | 1 | 9 | 0 | 10 | 62 | 52 | 114 | 61 | 17 | 16 | 1 | 9 | 0 | 10 | 62 | 52 | 114 | ||||||||||||||||||||||||||||||||||
1800719 | 1800719 | CO | school | 802910 | 130 | Cherry Creek 5 | 80291006617 | 6475 | Outback Preschool | Regular School | No | Prekindergarten | PK | PK | 2020 | pk_12_total | 33 | 12 | 22 | 0 | 9 | 0 | 3 | 41 | 38 | 79 | 33 | 12 | 22 | 0 | 9 | 0 | 3 | 41 | 38 | 79 | ||||||||||||||||||||||||||||||||||
1800720 | 1800720 | CO | school | 802910 | 130 | Cherry Creek 5 | 80291006617 | 6475 | Outback Preschool | Regular School | No | Prekindergarten | PK | PK | 2020 | pre_kindergarten | 33 | 12 | 22 | 0 | 9 | 0 | 3 | 41 | 38 | 79 | 33 | 12 | 22 | 0 | 9 | 0 | 3 | 41 | 38 | 79 | ||||||||||||||||||||||||||||||||||
1800738 | 1800738 | CO | school | 802910 | 130 | Cherry Creek 5 | 80291006452 | 6955 | Pine Ridge Elementary School | Regular School | No | Elementary | PK | 05 | 2020 | grade_5 | 95 | 4 | 19 | 1 | 9 | 0 | 10 | 71 | 67 | 138 | 95 | 4 | 19 | 1 | 9 | 0 | 10 | 71 | 67 | 138 | ||||||||||||||||||||||||||||||||||
1800750 | 1800750 | CO | school | 802910 | 130 | Cherry Creek 5 | 80291000200 | 7116 | Ponderosa Elementary School | Regular School | No | Elementary | PK | 05 | 2020 | grade_2 | 22 | 31 | 38 | 2 | 9 | 0 | 5 | 60 | 47 | 107 | 22 | 31 | 38 | 2 | 9 | 0 | 5 | 60 | 47 | 107 | ||||||||||||||||||||||||||||||||||
1800829 | 1800829 | CO | school | 802910 | 130 | Cherry Creek 5 | 80291000204 | 9108 | Village East Community Elementary School | Regular School | No | Elementary | PK | 05 | 2020 | grade_2 | 27 | 39 | 48 | 0 | 9 | 0 | 6 | 64 | 65 | 129 | 27 | 39 | 48 | 0 | 9 | 0 | 6 | 64 | 65 | 129 | ||||||||||||||||||||||||||||||||||
1800915 | 1800915 | CO | school | 805310 | 140 | Littleton 6 | 80531000884 | 5224 | Littleton High School | Regular School | No | High | 09 | 12 | 2020 | grade_9 | 189 | 9 | 93 | 0 | 9 | 1 | 17 | 154 | 164 | 318 | 189 | 9 | 93 | 0 | 9 | 1 | 17 | 154 | 164 | 318 | ||||||||||||||||||||||||||||||||||
1800968 | 1800968 | CO | school | 805310 | 140 | Littleton 6 | 80531000887 | 6814 | Peabody Elementary School | Regular School | No | Elementary | PK | 05 | 2020 | pk_12_total | 305 | 4 | 38 | 0 | 9 | 1 | 22 | 206 | 173 | 379 | 305 | 4 | 38 | 0 | 9 | 1 | 22 | 206 | 173 | 379 | ||||||||||||||||||||||||||||||||||
1800982 | 1800982 | CO | school | 805310 | 140 | Littleton 6 | 80531000889 | 7606 | Sandburg Elementary School | Regular School | No | Elementary | KG | 05 | 2020 | pk_12_total | 394 | 0 | 21 | 2 | 9 | 0 | 15 | 235 | 206 | 441 | 394 | 0 | 21 | 2 | 9 | 0 | 15 | 235 | 206 | 441 | ||||||||||||||||||||||||||||||||||
1801142 | 1801142 | CO | school | 802340 | 180 | Adams-Arapahoe 28J | 80234000058 | 1948 | Crawford Elementary School | Regular School | No | Elementary | PK | 05 | 2020 | pre_kindergarten | 3 | 4 | 18 | 0 | 9 | 0 | 1 | 19 | 16 | 35 | 3 | 4 | 18 | 0 | 9 | 0 | 1 | 19 | 16 | 35 | ||||||||||||||||||||||||||||||||||
1801234 | 1801234 | CO | school | 802340 | 180 | Adams-Arapahoe 28J | 80234000067 | 4646 | Kenton Elementary School | Regular School | No | Elementary | PK | 05 | 2020 | grade_3 | 4 | 8 | 61 | 0 | 9 | 0 | 4 | 50 | 36 | 86 | 4 | 8 | 61 | 0 | 9 | 0 | 4 | 50 | 36 | 86 | ||||||||||||||||||||||||||||||||||
1801349 | 1801349 | CO | school | 802340 | 180 | Adams-Arapahoe 28J | 80234001674 | 7232 | Aurora Quest K-8 | Regular School | No | Elementary | KG | 08 | 2020 | grade_5 | 35 | 6 | 6 | 0 | 9 | 1 | 3 | 24 | 36 | 60 | 35 | 6 | 6 | 0 | 9 | 1 | 3 | 24 | 36 | 60 | ||||||||||||||||||||||||||||||||||
1801353 | 1801353 | CO | school | 802340 | 180 | Adams-Arapahoe 28J | 80234001674 | 7232 | Aurora Quest K-8 | Regular School | No | Elementary | KG | 08 | 2020 | kindergarten_full_day | 21 | 5 | 7 | 0 | 9 | 0 | 8 | 18 | 32 | 50 | 21 | 5 | 7 | 0 | 9 | 0 | 8 | 18 | 32 | 50 | ||||||||||||||||||||||||||||||||||
1801376 | 1801376 | CO | school | 802340 | 180 | Adams-Arapahoe 28J | 80234001432 | 7865 | Side Creek Elementary School | Regular School | No | Elementary | PK | 05 | 2020 | grade_1 | 16 | 18 | 19 | 1 | 9 | 1 | 9 | 38 | 35 | 73 | 16 | 18 | 19 | 1 | 9 | 1 | 9 | 38 | 35 | 73 | ||||||||||||||||||||||||||||||||||
1801394 | 1801394 | CO | school | 802340 | 180 | Adams-Arapahoe 28J | 80234000079 | 8078 | South Middle School | Regular School | No | Middle | 06 | 08 | 2020 | grade_8 | 16 | 49 | 186 | 4 | 9 | 4 | 16 | 156 | 128 | 284 | 16 | 49 | 186 | 4 | 9 | 4 | 16 | 156 | 128 | 284 | ||||||||||||||||||||||||||||||||||
1801485 | 1801485 | CO | school | 802340 | 180 | Adams-Arapahoe 28J | 80234000082 | 9396 | Aurora West College Preparatory Academy | Regular School | No | High | 06 | 12 | 2020 | grade_9 | 5 | 11 | 102 | 0 | 9 | 0 | 3 | 58 | 72 | 130 | 5 | 11 | 102 | 0 | 9 | 0 | 3 | 58 | 72 | 130 | ||||||||||||||||||||||||||||||||||
1801769 | 1801769 | CO | school | 805370 | 470 | St Vrain Valley RE1J | 80537006381 | 878 | Blue Mountain Elementary | Regular School | No | Elementary | PK | 05 | 2020 | grade_3 | 85 | 0 | 4 | 0 | 9 | 0 | 6 | 58 | 46 | 104 | 85 | 0 | 4 | 0 | 9 | 0 | 6 | 58 | 46 | 104 | ||||||||||||||||||||||||||||||||||
1801770 | 1801770 | CO | school | 805370 | 470 | St Vrain Valley RE1J | 80537006381 | 878 | Blue Mountain Elementary | Regular School | No | Elementary | PK | 05 | 2020 | grade_4 | 87 | 1 | 10 | 0 | 9 | 0 | 9 | 68 | 48 | 116 | 87 | 1 | 10 | 0 | 9 | 0 | 9 | 68 | 48 | 116 | ||||||||||||||||||||||||||||||||||
1801853 | 1801853 | CO | school | 805370 | 470 | St Vrain Valley RE1J | 80537001890 | 2964 | Flagstaff Charter Academy | Regular School | Yes | Elementary | PK | 08 | 2020 | grade_4 | 72 | 1 | 16 | 0 | 9 | 0 | 5 | 44 | 59 | 103 | 72 | 1 | 16 | 0 | 9 | 0 | 5 | 44 | 59 | 103 | ||||||||||||||||||||||||||||||||||
1801903 | 1801903 | CO | school | 805370 | 470 | St Vrain Valley RE1J | 80537000904 | 4278 | Indian Peaks Elementary School | Regular School | No | Elementary | PK | 05 | 2020 | pk_12_total | 30 | 0 | 270 | 0 | 9 | 2 | 0 | 168 | 143 | 311 | 30 | 0 | 270 | 0 | 9 | 2 | 0 | 168 | 143 | 311 | ||||||||||||||||||||||||||||||||||
1801935 | 1801935 | CO | school | 805370 | 470 | St Vrain Valley RE1J | 80537000907 | 5284 | Longmont Estates Elementary School | Regular School | No | Elementary | PK | 05 | 2020 | pk_12_total | 255 | 4 | 83 | 2 | 9 | 0 | 5 | 187 | 171 | 358 | 255 | 4 | 83 | 2 | 9 | 0 | 5 | 187 | 171 | 358 | ||||||||||||||||||||||||||||||||||
1801963 | 1801963 | CO | school | 805370 | 470 | St Vrain Valley RE1J | 80537006423 | 5722 | Mead High School | Regular School | No | High | 09 | 12 | 2020 | grade_11 | 210 | 2 | 70 | 0 | 9 | 1 | 2 | 144 | 150 | 294 | 210 | 2 | 70 | 0 | 9 | 1 | 2 | 144 | 150 | 294 | ||||||||||||||||||||||||||||||||||
1802088 | 1802088 | CO | school | 805370 | 470 | St Vrain Valley RE1J | 80537001891 | 8903 | Trail Ridge Middle School | Regular School | No | Middle | 06 | 08 | 2020 | pk_12_total | 243 | 9 | 392 | 4 | 9 | 2 | 21 | 375 | 305 | 680 | 243 | 9 | 392 | 4 | 9 | 2 | 21 | 375 | 305 | 680 | ||||||||||||||||||||||||||||||||||
1802118 | 1802118 | CO | school | 802490 | 480 | Boulder Valley Re 2 | 80249001758 | 441 | Aspen Creek K-8 School | Regular School | No | Elementary | PK | 08 | 2020 | grade_7 | 103 | 3 | 18 | 1 | 9 | 0 | 4 | 85 | 53 | 138 | 103 | 3 | 18 | 1 | 9 | 0 | 4 | 85 | 53 | 138 | ||||||||||||||||||||||||||||||||||
1802175 | 1802175 | CO | school | 802490 | 480 | Boulder Valley Re 2 | 80249000104 | 1136 | Manhattan Middle School of the Arts and Academics | Regular School | No | Middle | 06 | 08 | 2020 | grade_8 | 120 | 0 | 46 | 1 | 9 | 1 | 10 | 89 | 98 | 187 | 120 | 0 | 46 | 1 | 9 | 1 | 10 | 89 | 98 | 187 | ||||||||||||||||||||||||||||||||||
1802179 | 1802179 | CO | school | 802490 | 480 | Boulder Valley Re 2 | 80249000106 | 1352 | Casey Middle School | Regular School | No | Middle | 06 | 08 | 2020 | grade_8 | 132 | 0 | 96 | 1 | 9 | 0 | 10 | 122 | 126 | 248 | 132 | 0 | 96 | 1 | 9 | 0 | 10 | 122 | 126 | 248 | ||||||||||||||||||||||||||||||||||
1802187 | 1802187 | CO | school | 802490 | 480 | Boulder Valley Re 2 | 80249000108 | 1390 | Centennial Middle School | Regular School | No | Middle | 06 | 08 | 2020 | grade_7 | 135 | 1 | 44 | 1 | 9 | 0 | 10 | 107 | 93 | 200 | 135 | 1 | 44 | 1 | 9 | 0 | 10 | 107 | 93 | 200 | ||||||||||||||||||||||||||||||||||
1802188 | 1802188 | CO | school | 802490 | 480 | Boulder Valley Re 2 | 80249000108 | 1390 | Centennial Middle School | Regular School | No | Middle | 06 | 08 | 2020 | grade_8 | 151 | 0 | 47 | 1 | 9 | 0 | 13 | 116 | 105 | 221 | 151 | 0 | 47 | 1 | 9 | 0 | 13 | 116 | 105 | 221 | ||||||||||||||||||||||||||||||||||
1802304 | 1802304 | CO | school | 802490 | 480 | Boulder Valley Re 2 | 80249000118 | 3882 | Heatherwood Elementary School | Regular School | No | Elementary | PK | 05 | 2020 | pk_12_total | 242 | 5 | 25 | 0 | 9 | 0 | 13 | 164 | 130 | 294 | 242 | 5 | 25 | 0 | 9 | 0 | 13 | 164 | 130 | 294 | ||||||||||||||||||||||||||||||||||
1802306 | 1802306 | CO | school | 802490 | 480 | Boulder Valley Re 2 | 80249001243 | 3940 | High Peaks Elementary School | Regular School | No | Elementary | KG | 05 | 2020 | grade_1 | 27 | 2 | 3 | 0 | 9 | 0 | 7 | 22 | 26 | 48 | 27 | 2 | 3 | 0 | 9 | 0 | 7 | 22 | 26 | 48 | ||||||||||||||||||||||||||||||||||
1802334 | 1802334 | CO | school | 802490 | 480 | Boulder Valley Re 2 | 80249000120 | 4792 | Kohl Elementary School | Regular School | No | Elementary | PK | 05 | 2020 | pk_12_total | 267 | 5 | 71 | 0 | 9 | 2 | 30 | 193 | 191 | 384 | 267 | 5 | 71 | 0 | 9 | 2 | 30 | 193 | 191 | 384 | ||||||||||||||||||||||||||||||||||
1802375 | 1802375 | CO | school | 802490 | 480 | Boulder Valley Re 2 | 80249000129 | 5838 | Mesa Elementary School | Regular School | No | Elementary | KG | 05 | 2020 | pk_12_total | 222 | 0 | 15 | 1 | 9 | 0 | 14 | 118 | 143 | 261 | 222 | 0 | 15 | 1 | 9 | 0 | 14 | 118 | 143 | 261 | ||||||||||||||||||||||||||||||||||
1802384 | 1802384 | CO | school | 802490 | 480 | Boulder Valley Re 2 | 80249001573 | 6000 | Monarch K-8 School | Regular School | No | Elementary | PK | 08 | 2020 | grade_4 | 34 | 1 | 10 | 0 | 9 | 0 | 5 | 33 | 26 | 59 | 34 | 1 | 10 | 0 | 9 | 0 | 5 | 33 | 26 | 59 | ||||||||||||||||||||||||||||||||||
1802385 | 1802385 | CO | school | 802490 | 480 | Boulder Valley Re 2 | 80249001573 | 6000 | Monarch K-8 School | Regular School | No | Elementary | PK | 08 | 2020 | grade_5 | 48 | 1 | 4 | 0 | 9 | 0 | 3 | 28 | 37 | 65 | 48 | 1 | 4 | 0 | 9 | 0 | 3 | 28 | 37 | 65 | ||||||||||||||||||||||||||||||||||
1802432 | 1802432 | CO | school | 802490 | 480 | Boulder Valley Re 2 | 80249001792 | 6816 | Peak to Peak Charter School | Regular School | Yes | Other | KG | 12 | 2020 | grade_3 | 56 | 0 | 6 | 0 | 9 | 0 | 7 | 36 | 42 | 78 | 56 | 0 | 6 | 0 | 9 | 0 | 7 | 36 | 42 | 78 | ||||||||||||||||||||||||||||||||||
1802433 | 1802433 | CO | school | 802490 | 480 | Boulder Valley Re 2 | 80249001792 | 6816 | Peak to Peak Charter School | Regular School | Yes | Other | KG | 12 | 2020 | grade_4 | 62 | 0 | 3 | 0 | 9 | 0 | 5 | 39 | 40 | 79 | 62 | 0 | 3 | 0 | 9 | 0 | 5 | 39 | 40 | 79 | ||||||||||||||||||||||||||||||||||
1802434 | 1802434 | CO | school | 802490 | 480 | Boulder Valley Re 2 | 80249001792 | 6816 | Peak to Peak Charter School | Regular School | Yes | Other | KG | 12 | 2020 | grade_5 | 56 | 1 | 10 | 0 | 9 | 0 | 2 | 44 | 34 | 78 | 56 | 1 | 10 | 0 | 9 | 0 | 2 | 44 | 34 | 78 | ||||||||||||||||||||||||||||||||||
1802467 | 1802467 | CO | school | 802490 | 480 | Boulder Valley Re 2 | 80249000134 | 8135 | Southern Hills Middle School | Regular School | No | Middle | 06 | 08 | 2020 | grade_8 | 160 | 1 | 10 | 0 | 9 | 0 | 12 | 97 | 95 | 192 | 160 | 1 | 10 | 0 | 9 | 0 | 12 | 97 | 95 | 192 | ||||||||||||||||||||||||||||||||||
1802474 | 1802474 | CO | school | 802490 | 480 | Boulder Valley Re 2 | 80249001518 | 8418 | Superior Elementary School | Regular School | No | Elementary | KG | 05 | 2020 | grade_2 | 52 | 0 | 4 | 0 | 9 | 0 | 4 | 33 | 36 | 69 | 52 | 0 | 4 | 0 | 9 | 0 | 4 | 33 | 36 | 69 | ||||||||||||||||||||||||||||||||||
1802940 | 1802940 | CO | school | 803360 | 880 | Denver County 1 | 80336000318 | 1056 | Bromwell Elementary School | Regular School | No | Elementary | PK | 05 | 2020 | pk_12_total | 243 | 10 | 39 | 1 | 9 | 0 | 30 | 170 | 162 | 332 | 243 | 10 | 39 | 1 | 9 | 0 | 30 | 170 | 162 | 332 | ||||||||||||||||||||||||||||||||||
1802950 | 1802950 | CO | school | 803360 | 880 | Denver County 1 | 80336006682 | 1077 | Bear Valley International School | Regular School | No | Middle | 06 | 08 | 2020 | grade_6 | 15 | 3 | 119 | 1 | 9 | 0 | 5 | 85 | 67 | 152 | 15 | 3 | 119 | 1 | 9 | 0 | 5 | 85 | 67 | 152 | ||||||||||||||||||||||||||||||||||
1803390 | 1803390 | CO | school | 803360 | 880 | Denver County 1 | 80336001776 | 3641 | Green Valley Elementary School | Regular School | No | Elementary | PK | 05 | 2020 | grade_1 | 13 | 22 | 43 | 1 | 9 | 1 | 3 | 56 | 36 | 92 | 13 | 22 | 43 | 1 | 9 | 1 | 3 | 56 | 36 | 92 | ||||||||||||||||||||||||||||||||||
1803395 | 1803395 | CO | school | 803360 | 880 | Denver County 1 | 80336001776 | 3641 | Green Valley Elementary School | Regular School | No | Elementary | PK | 05 | 2020 | kindergarten_full_day | 7 | 19 | 60 | 1 | 9 | 3 | 4 | 56 | 47 | 103 | 7 | 19 | 60 | 1 | 9 | 3 | 4 | 56 | 47 | 103 | ||||||||||||||||||||||||||||||||||
1803397 | 1803397 | CO | school | 803360 | 880 | Denver County 1 | 80336001776 | 3641 | Green Valley Elementary School | Regular School | No | Elementary | PK | 05 | 2020 | pre_kindergarten | 7 | 11 | 41 | 1 | 9 | 0 | 2 | 33 | 38 | 71 | 7 | 11 | 41 | 1 | 9 | 0 | 2 | 33 | 38 | 71 | ||||||||||||||||||||||||||||||||||
1803472 | 1803472 | CO | school | 803360 | 880 | Denver County 1 | 80336006609 | 4049 | Highline Academy Northeast | Regular School | Yes | Elementary | PK | 05 | 2020 | grade_3 | 14 | 26 | 30 | 0 | 9 | 0 | 5 | 47 | 37 | 84 | 14 | 26 | 30 | 0 | 9 | 0 | 5 | 47 | 37 | 84 | ||||||||||||||||||||||||||||||||||
1803502 | 1803502 | CO | school | 803360 | 880 | Denver County 1 | 80336006570 | 4213 | Isabella Bird Community School | Regular School | No | Elementary | PK | 05 | 2020 | kindergarten_full_day | 42 | 9 | 9 | 2 | 9 | 0 | 7 | 40 | 38 | 78 | 42 | 9 | 9 | 2 | 9 | 0 | 7 | 40 | 38 | 78 | ||||||||||||||||||||||||||||||||||
1803512 | 1803512 | CO | school | 803360 | 880 | Denver County 1 | 80336006554 | 4381 | DSST: College View Middle School | Regular School | Yes | Middle | 06 | 08 | 2020 | grade_6 | 5 | 3 | 139 | 1 | 9 | 0 | 2 | 80 | 79 | 159 | 5 | 3 | 139 | 1 | 9 | 0 | 2 | 80 | 79 | 159 | ||||||||||||||||||||||||||||||||||
1803570 | 1803570 | CO | school | 803360 | 880 | Denver County 1 | 80336006686 | 4513 | Kepner Beacon Middle School | Regular School | No | Middle | 06 | 08 | 2020 | pk_12_total | 22 | 22 | 341 | 3 | 9 | 0 | 1 | 210 | 188 | 398 | 22 | 22 | 341 | 3 | 9 | 0 | 1 | 210 | 188 | 398 | ||||||||||||||||||||||||||||||||||
1803648 | 1803648 | CO | school | 803360 | 880 | Denver County 1 | 80336001380 | 5578 | Marrama Elementary School | Regular School | No | Elementary | PK | 05 | 2020 | grade_3 | 6 | 19 | 46 | 0 | 9 | 0 | 2 | 37 | 45 | 82 | 6 | 19 | 46 | 0 | 9 | 0 | 2 | 37 | 45 | 82 | ||||||||||||||||||||||||||||||||||
1803658 | 1803658 | CO | school | 803360 | 880 | Denver County 1 | 80336001406 | 5605 | Dr. Martin Luther King Jr. Early College | Regular School | No | High | 06 | 12 | 2020 | grade_7 | 6 | 39 | 95 | 0 | 9 | 0 | 4 | 77 | 76 | 153 | 6 | 39 | 95 | 0 | 9 | 0 | 4 | 77 | 76 | 153 | ||||||||||||||||||||||||||||||||||
1803722 | 1803722 | CO | school | 803360 | 880 | Denver County 1 | 80336006562 | 5897 | McAuliffe International School | Regular School | No | Middle | 06 | 08 | 2020 | grade_8 | 340 | 63 | 63 | 3 | 9 | 1 | 44 | 289 | 234 | 523 | 340 | 63 | 63 | 3 | 9 | 1 | 44 | 289 | 234 | 523 | ||||||||||||||||||||||||||||||||||
1803745 | 1803745 | CO | school | 803360 | 880 | Denver County 1 | 80336000385 | 6088 | Dora Moore ECE-8 School | Regular School | No | Elementary | PK | 08 | 2020 | pk_12_total | 103 | 63 | 144 | 6 | 9 | 1 | 26 | 171 | 181 | 352 | 103 | 63 | 144 | 6 | 9 | 1 | 26 | 171 | 181 | 352 | ||||||||||||||||||||||||||||||||||
1803805 | 1803805 | CO | school | 803360 | 880 | Denver County 1 | 80336001750 | 6397 | Academia Ana Marie Sandoval | Regular School | No | Elementary | PK | 06 | 2020 | pk_12_total | 140 | 1 | 259 | 2 | 9 | 0 | 12 | 204 | 219 | 423 | 140 | 1 | 259 | 2 | 9 | 0 | 12 | 204 | 219 | 423 | ||||||||||||||||||||||||||||||||||
1803821 | 1803821 | CO | school | 803360 | 880 | Denver County 1 | 80336001838 | 6508 | Omar D Blair Charter School | Regular School | Yes | Elementary | KG | 08 | 2020 | grade_5 | 5 | 49 | 27 | 0 | 9 | 4 | 5 | 46 | 53 | 99 | 5 | 49 | 27 | 0 | 9 | 4 | 5 | 46 | 53 | 99 | ||||||||||||||||||||||||||||||||||
1803831 | 1803831 | CO | school | 803360 | 880 | Denver County 1 | 80336001955 | 6509 | Denver Online High School | Regular School | No | High | 09 | 12 | 2020 | pk_12_total | 139 | 21 | 98 | 2 | 9 | 1 | 17 | 115 | 172 | 287 | 139 | 21 | 98 | 2 | 9 | 1 | 17 | 115 | 172 | 287 | ||||||||||||||||||||||||||||||||||
1804088 | 1804088 | CO | school | 803360 | 880 | Denver County 1 | 80336000415 | 8776 | Teller Elementary School | Regular School | No | Elementary | PK | 05 | 2020 | pk_12_total | 374 | 49 | 54 | 2 | 9 | 2 | 39 | 279 | 250 | 529 | 374 | 49 | 54 | 2 | 9 | 2 | 39 | 279 | 250 | 529 | ||||||||||||||||||||||||||||||||||
1804258 | 1804258 | CO | school | 803450 | 900 | Douglas County Re 1 | 80345000436 | 12 | Acres Green Elementary School | Regular School | No | Elementary | PK | 06 | 2020 | grade_2 | 27 | 1 | 16 | 0 | 9 | 0 | 3 | 28 | 28 | 56 | 27 | 1 | 16 | 0 | 9 | 0 | 3 | 28 | 28 | 56 | ||||||||||||||||||||||||||||||||||
1804259 | 1804259 | CO | school | 803450 | 900 | Douglas County Re 1 | 80345000436 | 12 | Acres Green Elementary School | Regular School | No | Elementary | PK | 06 | 2020 | grade_3 | 35 | 1 | 14 | 1 | 9 | 0 | 6 | 31 | 35 | 66 | 35 | 1 | 14 | 1 | 9 | 0 | 6 | 31 | 35 | 66 | ||||||||||||||||||||||||||||||||||
1804328 | 1804328 | CO | school | 803450 | 900 | Douglas County Re 1 | 80345006371 | 267 | Mesa Middle School | Regular School | No | Middle | 07 | 08 | 2020 | grade_8 | 305 | 2 | 69 | 2 | 9 | 2 | 35 | 215 | 209 | 424 | 305 | 2 | 69 | 2 | 9 | 2 | 35 | 215 | 209 | 424 | ||||||||||||||||||||||||||||||||||
1804369 | 1804369 | CO | school | 803450 | 900 | Douglas County Re 1 | 80345001918 | 1367 | Castle View High School | Regular School | No | High | 09 | 12 | 2020 | grade_11 | 429 | 8 | 85 | 4 | 9 | 0 | 24 | 295 | 264 | 559 | 429 | 8 | 85 | 4 | 9 | 0 | 24 | 295 | 264 | 559 | ||||||||||||||||||||||||||||||||||
1804465 | 1804465 | CO | school | 803450 | 900 | Douglas County Re 1 | 80345000438 | 2226 | Castle Rock Middle School | Regular School | No | Middle | 07 | 08 | 2020 | grade_8 | 326 | 5 | 75 | 1 | 9 | 0 | 21 | 241 | 196 | 437 | 326 | 5 | 75 | 1 | 9 | 0 | 21 | 241 | 196 | 437 | ||||||||||||||||||||||||||||||||||
1804642 | 1804642 | CO | school | 803450 | 900 | Douglas County Re 1 | 80345001960 | 5045 | Legacy Point Elementary School | Regular School | No | Elementary | PK | 05 | 2020 | pre_kindergarten | 48 | 0 | 5 | 0 | 9 | 0 | 1 | 36 | 27 | 63 | 48 | 0 | 5 | 0 | 9 | 0 | 1 | 36 | 27 | 63 | ||||||||||||||||||||||||||||||||||
1804760 | 1804760 | CO | school | 803450 | 900 | Douglas County Re 1 | 80345001339 | 6406 | Northridge Elementary School | Regular School | No | Elementary | PK | 06 | 2020 | kindergarten_full_day | 45 | 0 | 8 | 0 | 9 | 0 | 2 | 44 | 20 | 64 | 45 | 0 | 8 | 0 | 9 | 0 | 2 | 44 | 20 | 64 | ||||||||||||||||||||||||||||||||||
1804808 | 1804808 | CO | school | 803450 | 900 | Douglas County Re 1 | 80345001584 | 7047 | Platte River Charter Academy | Regular School | Yes | Elementary | KG | 08 | 2020 | grade_1 | 42 | 1 | 3 | 0 | 9 | 0 | 3 | 30 | 28 | 58 | 42 | 1 | 3 | 0 | 9 | 0 | 3 | 30 | 28 | 58 | ||||||||||||||||||||||||||||||||||
1804831 | 1804831 | CO | school | 803450 | 900 | Douglas County Re 1 | 80345001809 | 7134 | Prairie Crossing Elementary School | Regular School | No | Elementary | PK | 06 | 2020 | grade_3 | 70 | 0 | 12 | 0 | 9 | 0 | 6 | 51 | 46 | 97 | 70 | 0 | 12 | 0 | 9 | 0 | 6 | 51 | 46 | 97 | ||||||||||||||||||||||||||||||||||
1804852 | 1804852 | CO | school | 803450 | 900 | Douglas County Re 1 | 80345001900 | 7297 | Redstone Elementary School | Regular School | No | Elementary | PK | 06 | 2020 | grade_4 | 69 | 2 | 10 | 0 | 9 | 0 | 3 | 52 | 41 | 93 | 69 | 2 | 10 | 0 | 9 | 0 | 3 | 52 | 41 | 93 |
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]);