enrollments
Data source: Big Local News · About: Big Local
13,413 rows where state = "CO" and year = 2019 sorted by ccd_school_type
This data as json, CSV (advanced)
grade ✖
- pk_12_total 1,910
- grade_5 1,105
- grade_2 1,104
- grade_4 1,104
- grade_1 1,103
- grade_3 1,103
- kindergarten_full_day 991
- grade_6 686
- pre_kindergarten 673
- grade_7 615
- grade_8 612
- grade_12 501
- grade_11 499
- grade_10 497
- grade_9 488
- kindergarten_half_day 422
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1931103 | 1931103 | CO | school | 20 | ADAMS 12 FIVE STAR SCHOOLS | 0 | Not a school | 2019 | grade_11 | 7 | 0 | 4 | 0 | 0 | 0 | 1 | 2 | 10 | 12 | 7 | 0 | 4 | 0 | 0 | 0 | 1 | 2 | 10 | 12 | |||||||||||||||||||||||||||||||||||||||||
1931104 | 1931104 | CO | school | 20 | ADAMS 12 FIVE STAR SCHOOLS | 0 | Not a school | 2019 | grade_12 | 19 | 2 | 19 | 0 | 2 | 1 | 0 | 12 | 31 | 43 | 19 | 2 | 19 | 0 | 2 | 1 | 0 | 12 | 31 | 43 | |||||||||||||||||||||||||||||||||||||||||
1931105 | 1931105 | CO | school | 20 | ADAMS 12 FIVE STAR SCHOOLS | 0 | Not a school | 2019 | pk_12_total | 26 | 2 | 23 | 0 | 2 | 1 | 1 | 14 | 41 | 55 | 26 | 2 | 23 | 0 | 2 | 1 | 1 | 14 | 41 | 55 | |||||||||||||||||||||||||||||||||||||||||
1931587 | 1931587 | CO | school | 40 | SCHOOL DISTRICT 27J | 6 | COUNTY JAILS WITH DISTRICT RUN EDUCATION | 2019 | grade_9 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | |||||||||||||||||||||||||||||||||||||||||
1931588 | 1931588 | CO | school | 40 | SCHOOL DISTRICT 27J | 6 | COUNTY JAILS WITH DISTRICT RUN EDUCATION | 2019 | pk_12_total | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | |||||||||||||||||||||||||||||||||||||||||
1931823 | 1931823 | CO | school | 70 | WESTMINSTER PUBLIC SCHOOLS | 0 | Not a school | 2019 | grade_12 | 2 | 0 | 0 | 1 | 0 | 0 | 0 | 2 | 1 | 3 | 2 | 0 | 0 | 1 | 0 | 0 | 0 | 2 | 1 | 3 | |||||||||||||||||||||||||||||||||||||||||
1931824 | 1931824 | CO | school | 70 | WESTMINSTER PUBLIC SCHOOLS | 0 | Not a school | 2019 | pk_12_total | 2 | 0 | 0 | 1 | 0 | 0 | 0 | 2 | 1 | 3 | 2 | 0 | 0 | 1 | 0 | 0 | 0 | 2 | 1 | 3 | |||||||||||||||||||||||||||||||||||||||||
1932681 | 1932681 | CO | school | 180 | ADAMS-ARAPAHOE 28J | 1 | FACILITIES WITH DISTRICT RUN EDUCATION | 2019 | grade_1 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | |||||||||||||||||||||||||||||||||||||||||
1932682 | 1932682 | CO | school | 180 | ADAMS-ARAPAHOE 28J | 1 | FACILITIES WITH DISTRICT RUN EDUCATION | 2019 | grade_10 | 1 | 0 | 0 | 0 | 0 | 0 | 1 | 1 | 1 | 2 | 1 | 0 | 0 | 0 | 0 | 0 | 1 | 1 | 1 | 2 | |||||||||||||||||||||||||||||||||||||||||
1932683 | 1932683 | CO | school | 180 | ADAMS-ARAPAHOE 28J | 1 | FACILITIES WITH DISTRICT RUN EDUCATION | 2019 | grade_11 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 1 | 1 | 2 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 1 | 1 | 2 | |||||||||||||||||||||||||||||||||||||||||
1932684 | 1932684 | CO | school | 180 | ADAMS-ARAPAHOE 28J | 1 | FACILITIES WITH DISTRICT RUN EDUCATION | 2019 | grade_12 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 1 | 1 | 2 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 1 | 1 | 2 | |||||||||||||||||||||||||||||||||||||||||
1932685 | 1932685 | CO | school | 180 | ADAMS-ARAPAHOE 28J | 1 | FACILITIES WITH DISTRICT RUN EDUCATION | 2019 | grade_2 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 1 | 1 | |||||||||||||||||||||||||||||||||||||||||
1932686 | 1932686 | CO | school | 180 | ADAMS-ARAPAHOE 28J | 1 | FACILITIES WITH DISTRICT RUN EDUCATION | 2019 | grade_4 | 1 | 0 | 1 | 0 | 0 | 0 | 0 | 2 | 0 | 2 | 1 | 0 | 1 | 0 | 0 | 0 | 0 | 2 | 0 | 2 | |||||||||||||||||||||||||||||||||||||||||
1932687 | 1932687 | CO | school | 180 | ADAMS-ARAPAHOE 28J | 1 | FACILITIES WITH DISTRICT RUN EDUCATION | 2019 | grade_5 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | |||||||||||||||||||||||||||||||||||||||||
1932688 | 1932688 | CO | school | 180 | ADAMS-ARAPAHOE 28J | 1 | FACILITIES WITH DISTRICT RUN EDUCATION | 2019 | grade_6 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 1 | 1 | |||||||||||||||||||||||||||||||||||||||||
1932689 | 1932689 | CO | school | 180 | ADAMS-ARAPAHOE 28J | 1 | FACILITIES WITH DISTRICT RUN EDUCATION | 2019 | grade_7 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 1 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 1 | 0 | 1 | |||||||||||||||||||||||||||||||||||||||||
1932690 | 1932690 | CO | school | 180 | ADAMS-ARAPAHOE 28J | 1 | FACILITIES WITH DISTRICT RUN EDUCATION | 2019 | grade_8 | 2 | 0 | 1 | 0 | 0 | 0 | 0 | 2 | 1 | 3 | 2 | 0 | 1 | 0 | 0 | 0 | 0 | 2 | 1 | 3 | |||||||||||||||||||||||||||||||||||||||||
1932691 | 1932691 | CO | school | 180 | ADAMS-ARAPAHOE 28J | 1 | FACILITIES WITH DISTRICT RUN EDUCATION | 2019 | grade_9 | 1 | 1 | 2 | 0 | 0 | 0 | 0 | 2 | 2 | 4 | 1 | 1 | 2 | 0 | 0 | 0 | 0 | 2 | 2 | 4 | |||||||||||||||||||||||||||||||||||||||||
1932692 | 1932692 | CO | school | 180 | ADAMS-ARAPAHOE 28J | 1 | FACILITIES WITH DISTRICT RUN EDUCATION | 2019 | pk_12_total | 6 | 3 | 7 | 0 | 2 | 0 | 2 | 12 | 8 | 20 | 6 | 3 | 7 | 0 | 2 | 0 | 2 | 12 | 8 | 20 | |||||||||||||||||||||||||||||||||||||||||
1938400 | 1938400 | CO | school | 1140 | CANON CITY RE-1 | 0 | Not a school | 2019 | grade_11 | 3 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 2 | 3 | 3 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 2 | 3 | |||||||||||||||||||||||||||||||||||||||||
1938401 | 1938401 | CO | school | 1140 | CANON CITY RE-1 | 0 | Not a school | 2019 | grade_12 | 21 | 0 | 6 | 0 | 0 | 0 | 1 | 14 | 14 | 28 | 21 | 0 | 6 | 0 | 0 | 0 | 1 | 14 | 14 | 28 | |||||||||||||||||||||||||||||||||||||||||
1938402 | 1938402 | CO | school | 1140 | CANON CITY RE-1 | 0 | Not a school | 2019 | pk_12_total | 24 | 0 | 6 | 0 | 0 | 0 | 1 | 15 | 16 | 31 | 24 | 0 | 6 | 0 | 0 | 0 | 1 | 15 | 16 | 31 | |||||||||||||||||||||||||||||||||||||||||
1938853 | 1938853 | CO | school | 1420 | JEFFERSON COUNTY R-1 | 0 | Not a school | 2019 | grade_11 | 2 | 0 | 0 | 0 | 0 | 0 | 1 | 3 | 0 | 3 | 2 | 0 | 0 | 0 | 0 | 0 | 1 | 3 | 0 | 3 | |||||||||||||||||||||||||||||||||||||||||
1938854 | 1938854 | CO | school | 1420 | JEFFERSON COUNTY R-1 | 0 | Not a school | 2019 | grade_12 | 7 | 0 | 4 | 0 | 1 | 0 | 0 | 6 | 6 | 12 | 7 | 0 | 4 | 0 | 1 | 0 | 0 | 6 | 6 | 12 | |||||||||||||||||||||||||||||||||||||||||
1938855 | 1938855 | CO | school | 1420 | JEFFERSON COUNTY R-1 | 0 | Not a school | 2019 | pk_12_total | 9 | 0 | 4 | 0 | 1 | 0 | 1 | 9 | 6 | 15 | 9 | 0 | 4 | 0 | 1 | 0 | 1 | 9 | 6 | 15 | |||||||||||||||||||||||||||||||||||||||||
1940242 | 1940242 | CO | school | 1520 | DURANGO 9-R | 0 | Not a school | 2019 | grade_12 | 6 | 0 | 3 | 3 | 0 | 0 | 1 | 7 | 6 | 13 | 6 | 0 | 3 | 3 | 0 | 0 | 1 | 7 | 6 | 13 | |||||||||||||||||||||||||||||||||||||||||
1940243 | 1940243 | CO | school | 1520 | DURANGO 9-R | 0 | Not a school | 2019 | pk_12_total | 6 | 0 | 3 | 3 | 0 | 0 | 1 | 7 | 6 | 13 | 6 | 0 | 3 | 3 | 0 | 0 | 1 | 7 | 6 | 13 | |||||||||||||||||||||||||||||||||||||||||
1940383 | 1940383 | CO | school | 1550 | POUDRE R-1 | 0 | Not a school | 2019 | grade_10 | 1 | 0 | 1 | 0 | 0 | 0 | 1 | 2 | 1 | 3 | 1 | 0 | 1 | 0 | 0 | 0 | 1 | 2 | 1 | 3 | |||||||||||||||||||||||||||||||||||||||||
1940384 | 1940384 | CO | school | 1550 | POUDRE R-1 | 0 | Not a school | 2019 | grade_11 | 0 | 0 | 2 | 0 | 0 | 0 | 0 | 2 | 0 | 2 | 0 | 0 | 2 | 0 | 0 | 0 | 0 | 2 | 0 | 2 | |||||||||||||||||||||||||||||||||||||||||
1940385 | 1940385 | CO | school | 1550 | POUDRE R-1 | 0 | Not a school | 2019 | grade_7 | 0 | 0 | 3 | 0 | 0 | 0 | 0 | 1 | 2 | 3 | 0 | 0 | 3 | 0 | 0 | 0 | 0 | 1 | 2 | 3 | |||||||||||||||||||||||||||||||||||||||||
1940386 | 1940386 | CO | school | 1550 | POUDRE R-1 | 0 | Not a school | 2019 | grade_8 | 0 | 1 | 2 | 0 | 0 | 0 | 1 | 3 | 1 | 4 | 0 | 1 | 2 | 0 | 0 | 0 | 1 | 3 | 1 | 4 | |||||||||||||||||||||||||||||||||||||||||
1940387 | 1940387 | CO | school | 1550 | POUDRE R-1 | 0 | Not a school | 2019 | grade_9 | 2 | 0 | 1 | 0 | 0 | 0 | 1 | 2 | 2 | 4 | 2 | 0 | 1 | 0 | 0 | 0 | 1 | 2 | 2 | 4 | |||||||||||||||||||||||||||||||||||||||||
1940388 | 1940388 | CO | school | 1550 | POUDRE R-1 | 0 | Not a school | 2019 | pk_12_total | 3 | 1 | 9 | 0 | 0 | 0 | 3 | 10 | 6 | 16 | 3 | 1 | 9 | 0 | 0 | 0 | 3 | 10 | 6 | 16 | |||||||||||||||||||||||||||||||||||||||||
1942377 | 1942377 | CO | school | 2690 | PUEBLO CITY 60 | 0 | Not a school | 2019 | grade_12 | 9 | 1 | 17 | 2 | 0 | 0 | 0 | 20 | 9 | 29 | 9 | 1 | 17 | 2 | 0 | 0 | 0 | 20 | 9 | 29 | |||||||||||||||||||||||||||||||||||||||||
1942378 | 1942378 | CO | school | 2690 | PUEBLO CITY 60 | 0 | Not a school | 2019 | pk_12_total | 9 | 1 | 17 | 2 | 0 | 0 | 0 | 20 | 9 | 29 | 9 | 1 | 17 | 2 | 0 | 0 | 0 | 20 | 9 | 29 | |||||||||||||||||||||||||||||||||||||||||
1944359 | 1944359 | CO | school | 9999 | COLORADO DETENTION CENTER TOTAL | No school | COLORADO DETENTION CENTER TOTAL | 2019 | grade_10 | 20 | 13 | 34 | 1 | 3 | 0 | 2 | 54 | 19 | 73 | 20 | 13 | 34 | 1 | 3 | 0 | 2 | 54 | 19 | 73 | |||||||||||||||||||||||||||||||||||||||||
1944360 | 1944360 | CO | school | 9999 | COLORADO DETENTION CENTER TOTAL | No school | COLORADO DETENTION CENTER TOTAL | 2019 | grade_11 | 27 | 9 | 30 | 0 | 0 | 0 | 3 | 51 | 18 | 69 | 27 | 9 | 30 | 0 | 0 | 0 | 3 | 51 | 18 | 69 | |||||||||||||||||||||||||||||||||||||||||
1944361 | 1944361 | CO | school | 9999 | COLORADO DETENTION CENTER TOTAL | No school | COLORADO DETENTION CENTER TOTAL | 2019 | grade_12 | 32 | 12 | 31 | 0 | 0 | 0 | 3 | 58 | 20 | 78 | 32 | 12 | 31 | 0 | 0 | 0 | 3 | 58 | 20 | 78 | |||||||||||||||||||||||||||||||||||||||||
1944362 | 1944362 | CO | school | 9999 | COLORADO DETENTION CENTER TOTAL | No school | COLORADO DETENTION CENTER TOTAL | 2019 | grade_5 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | |||||||||||||||||||||||||||||||||||||||||
1944363 | 1944363 | CO | school | 9999 | COLORADO DETENTION CENTER TOTAL | No school | COLORADO DETENTION CENTER TOTAL | 2019 | grade_6 | 1 | 0 | 1 | 0 | 0 | 0 | 0 | 2 | 0 | 2 | 1 | 0 | 1 | 0 | 0 | 0 | 0 | 2 | 0 | 2 | |||||||||||||||||||||||||||||||||||||||||
1944364 | 1944364 | CO | school | 9999 | COLORADO DETENTION CENTER TOTAL | No school | COLORADO DETENTION CENTER TOTAL | 2019 | grade_7 | 2 | 0 | 3 | 0 | 0 | 0 | 0 | 4 | 1 | 5 | 2 | 0 | 3 | 0 | 0 | 0 | 0 | 4 | 1 | 5 | |||||||||||||||||||||||||||||||||||||||||
1944365 | 1944365 | CO | school | 9999 | COLORADO DETENTION CENTER TOTAL | No school | COLORADO DETENTION CENTER TOTAL | 2019 | grade_8 | 8 | 2 | 11 | 0 | 0 | 0 | 0 | 16 | 5 | 21 | 8 | 2 | 11 | 0 | 0 | 0 | 0 | 16 | 5 | 21 | |||||||||||||||||||||||||||||||||||||||||
1944366 | 1944366 | CO | school | 9999 | COLORADO DETENTION CENTER TOTAL | No school | COLORADO DETENTION CENTER TOTAL | 2019 | grade_9 | 6 | 13 | 19 | 1 | 0 | 0 | 0 | 25 | 14 | 39 | 6 | 13 | 19 | 1 | 0 | 0 | 0 | 25 | 14 | 39 | |||||||||||||||||||||||||||||||||||||||||
1944367 | 1944367 | CO | school | 9999 | COLORADO DETENTION CENTER TOTAL | No school | COLORADO DETENTION CENTER TOTAL | 2019 | pk_12_total | 97 | 49 | 129 | 2 | 3 | 0 | 8 | 211 | 77 | 288 | 97 | 49 | 129 | 2 | 3 | 0 | 8 | 211 | 77 | 288 | |||||||||||||||||||||||||||||||||||||||||
1931091 | 1931091 | CO | school | 805550 | 10 | MAPLETON 1 | 80555006433 | 6315 | NORTH VALLEY SCHOOL FOR YOUNG ADULTS | Alternative School | No | High | 09 | 12 | 2019 | grade_12 | 20 | 0 | 57 | 1 | 1 | 0 | 2 | 47 | 34 | 81 | 20 | 0 | 57 | 1 | 1 | 0 | 2 | 47 | 34 | 81 | ||||||||||||||||||||||||||||||||||
1931092 | 1931092 | CO | school | 805550 | 10 | MAPLETON 1 | 80555006433 | 6315 | NORTH VALLEY SCHOOL FOR YOUNG ADULTS | Alternative School | No | High | 09 | 12 | 2019 | pk_12_total | 20 | 0 | 57 | 1 | 1 | 0 | 2 | 47 | 34 | 81 | 20 | 0 | 57 | 1 | 1 | 0 | 2 | 47 | 34 | 81 | ||||||||||||||||||||||||||||||||||
1931128 | 1931128 | CO | school | 806900 | 20 | ADAMS 12 FIVE STAR SCHOOLS | 80690001172 | 210 | VANTAGE POINT | Alternative School | No | High | 06 | 12 | 2019 | grade_10 | 14 | 2 | 33 | 0 | 0 | 0 | 1 | 31 | 19 | 50 | 14 | 2 | 33 | 0 | 0 | 0 | 1 | 31 | 19 | 50 | ||||||||||||||||||||||||||||||||||
1931129 | 1931129 | CO | school | 806900 | 20 | ADAMS 12 FIVE STAR SCHOOLS | 80690001172 | 210 | VANTAGE POINT | Alternative School | No | High | 06 | 12 | 2019 | grade_11 | 36 | 1 | 95 | 2 | 1 | 0 | 2 | 81 | 56 | 137 | 36 | 1 | 95 | 2 | 1 | 0 | 2 | 81 | 56 | 137 | ||||||||||||||||||||||||||||||||||
1931130 | 1931130 | CO | school | 806900 | 20 | ADAMS 12 FIVE STAR SCHOOLS | 80690001172 | 210 | VANTAGE POINT | Alternative School | No | High | 06 | 12 | 2019 | grade_12 | 45 | 2 | 61 | 1 | 4 | 0 | 3 | 67 | 49 | 116 | 45 | 2 | 61 | 1 | 4 | 0 | 3 | 67 | 49 | 116 | ||||||||||||||||||||||||||||||||||
1931131 | 1931131 | CO | school | 806900 | 20 | ADAMS 12 FIVE STAR SCHOOLS | 80690001172 | 210 | VANTAGE POINT | Alternative School | No | High | 06 | 12 | 2019 | grade_7 | 3 | 0 | 8 | 0 | 0 | 1 | 0 | 11 | 1 | 12 | 3 | 0 | 8 | 0 | 0 | 1 | 0 | 11 | 1 | 12 | ||||||||||||||||||||||||||||||||||
1931132 | 1931132 | CO | school | 806900 | 20 | ADAMS 12 FIVE STAR SCHOOLS | 80690001172 | 210 | VANTAGE POINT | Alternative School | No | High | 06 | 12 | 2019 | grade_8 | 9 | 2 | 20 | 0 | 0 | 0 | 0 | 17 | 14 | 31 | 9 | 2 | 20 | 0 | 0 | 0 | 0 | 17 | 14 | 31 | ||||||||||||||||||||||||||||||||||
1931133 | 1931133 | CO | school | 806900 | 20 | ADAMS 12 FIVE STAR SCHOOLS | 80690001172 | 210 | VANTAGE POINT | Alternative School | No | High | 06 | 12 | 2019 | grade_9 | 2 | 0 | 1 | 0 | 0 | 0 | 0 | 3 | 0 | 3 | 2 | 0 | 1 | 0 | 0 | 0 | 0 | 3 | 0 | 3 | ||||||||||||||||||||||||||||||||||
1931134 | 1931134 | CO | school | 806900 | 20 | ADAMS 12 FIVE STAR SCHOOLS | 80690001172 | 210 | VANTAGE POINT | Alternative School | No | High | 06 | 12 | 2019 | pk_12_total | 109 | 7 | 218 | 3 | 5 | 1 | 6 | 210 | 139 | 349 | 109 | 7 | 218 | 3 | 5 | 1 | 6 | 210 | 139 | 349 | ||||||||||||||||||||||||||||||||||
1931289 | 1931289 | CO | school | 806900 | 20 | ADAMS 12 FIVE STAR SCHOOLS | 80690006480 | 4699 | NEW AMERICA SCHOOL - THORNTON | Alternative School | Yes | High | 09 | 12 | 2019 | grade_10 | 2 | 0 | 40 | 0 | 0 | 0 | 0 | 20 | 22 | 42 | 2 | 0 | 40 | 0 | 0 | 0 | 0 | 20 | 22 | 42 | ||||||||||||||||||||||||||||||||||
1931290 | 1931290 | CO | school | 806900 | 20 | ADAMS 12 FIVE STAR SCHOOLS | 80690006480 | 4699 | NEW AMERICA SCHOOL - THORNTON | Alternative School | Yes | High | 09 | 12 | 2019 | grade_11 | 6 | 1 | 73 | 0 | 0 | 0 | 0 | 36 | 44 | 80 | 6 | 1 | 73 | 0 | 0 | 0 | 0 | 36 | 44 | 80 | ||||||||||||||||||||||||||||||||||
1931291 | 1931291 | CO | school | 806900 | 20 | ADAMS 12 FIVE STAR SCHOOLS | 80690006480 | 4699 | NEW AMERICA SCHOOL - THORNTON | Alternative School | Yes | High | 09 | 12 | 2019 | grade_12 | 14 | 2 | 151 | 0 | 2 | 0 | 1 | 75 | 95 | 170 | 14 | 2 | 151 | 0 | 2 | 0 | 1 | 75 | 95 | 170 | ||||||||||||||||||||||||||||||||||
1931292 | 1931292 | CO | school | 806900 | 20 | ADAMS 12 FIVE STAR SCHOOLS | 80690006480 | 4699 | NEW AMERICA SCHOOL - THORNTON | Alternative School | Yes | High | 09 | 12 | 2019 | grade_9 | 2 | 0 | 15 | 0 | 0 | 0 | 0 | 10 | 7 | 17 | 2 | 0 | 15 | 0 | 0 | 0 | 0 | 10 | 7 | 17 | ||||||||||||||||||||||||||||||||||
1931293 | 1931293 | CO | school | 806900 | 20 | ADAMS 12 FIVE STAR SCHOOLS | 80690006480 | 4699 | NEW AMERICA SCHOOL - THORNTON | Alternative School | Yes | High | 09 | 12 | 2019 | pk_12_total | 24 | 3 | 279 | 0 | 2 | 0 | 1 | 141 | 168 | 309 | 24 | 3 | 279 | 0 | 2 | 0 | 1 | 141 | 168 | 309 | ||||||||||||||||||||||||||||||||||
1931389 | 1931389 | CO | school | 806900 | 20 | ADAMS 12 FIVE STAR SCHOOLS | 80690006550 | 6956 | PATHWAYS FUTURE CENTER | Alternative School | No | Other | KG | 12 | 2019 | grade_10 | 3 | 0 | 1 | 0 | 0 | 0 | 0 | 2 | 2 | 4 | 3 | 0 | 1 | 0 | 0 | 0 | 0 | 2 | 2 | 4 | ||||||||||||||||||||||||||||||||||
1931390 | 1931390 | CO | school | 806900 | 20 | ADAMS 12 FIVE STAR SCHOOLS | 80690006550 | 6956 | PATHWAYS FUTURE CENTER | Alternative School | No | Other | KG | 12 | 2019 | grade_11 | 8 | 1 | 6 | 0 | 0 | 0 | 1 | 10 | 6 | 16 | 8 | 1 | 6 | 0 | 0 | 0 | 1 | 10 | 6 | 16 | ||||||||||||||||||||||||||||||||||
1931391 | 1931391 | CO | school | 806900 | 20 | ADAMS 12 FIVE STAR SCHOOLS | 80690006550 | 6956 | PATHWAYS FUTURE CENTER | Alternative School | No | Other | KG | 12 | 2019 | grade_12 | 100 | 13 | 177 | 4 | 5 | 0 | 3 | 190 | 112 | 302 | 100 | 13 | 177 | 4 | 5 | 0 | 3 | 190 | 112 | 302 | ||||||||||||||||||||||||||||||||||
1931392 | 1931392 | CO | school | 806900 | 20 | ADAMS 12 FIVE STAR SCHOOLS | 80690006550 | 6956 | PATHWAYS FUTURE CENTER | Alternative School | No | Other | KG | 12 | 2019 | grade_6 | 1 | 1 | 1 | 0 | 0 | 0 | 0 | 3 | 0 | 3 | 1 | 1 | 1 | 0 | 0 | 0 | 0 | 3 | 0 | 3 | ||||||||||||||||||||||||||||||||||
1931393 | 1931393 | CO | school | 806900 | 20 | ADAMS 12 FIVE STAR SCHOOLS | 80690006550 | 6956 | PATHWAYS FUTURE CENTER | Alternative School | No | Other | KG | 12 | 2019 | grade_7 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | ||||||||||||||||||||||||||||||||||
1931394 | 1931394 | CO | school | 806900 | 20 | ADAMS 12 FIVE STAR SCHOOLS | 80690006550 | 6956 | PATHWAYS FUTURE CENTER | Alternative School | No | Other | KG | 12 | 2019 | grade_8 | 2 | 2 | 1 | 0 | 0 | 0 | 0 | 5 | 0 | 5 | 2 | 2 | 1 | 0 | 0 | 0 | 0 | 5 | 0 | 5 | ||||||||||||||||||||||||||||||||||
1931395 | 1931395 | CO | school | 806900 | 20 | ADAMS 12 FIVE STAR SCHOOLS | 80690006550 | 6956 | PATHWAYS FUTURE CENTER | Alternative School | No | Other | KG | 12 | 2019 | grade_9 | 2 | 0 | 3 | 0 | 0 | 0 | 0 | 3 | 2 | 5 | 2 | 0 | 3 | 0 | 0 | 0 | 0 | 3 | 2 | 5 | ||||||||||||||||||||||||||||||||||
1931396 | 1931396 | CO | school | 806900 | 20 | ADAMS 12 FIVE STAR SCHOOLS | 80690006550 | 6956 | PATHWAYS FUTURE CENTER | Alternative School | No | Other | KG | 12 | 2019 | pk_12_total | 117 | 17 | 189 | 4 | 5 | 0 | 4 | 214 | 122 | 336 | 117 | 17 | 189 | 4 | 5 | 0 | 4 | 214 | 122 | 336 | ||||||||||||||||||||||||||||||||||
1931516 | 1931516 | CO | school | 801950 | 30 | ADAMS COUNTY 14 | 80195001307 | 22 | LESTER R ARNOLD HIGH SCHOOL | Alternative School | No | High | 09 | 12 | 2019 | grade_10 | 8 | 2 | 42 | 0 | 0 | 0 | 2 | 35 | 19 | 54 | 8 | 2 | 42 | 0 | 0 | 0 | 2 | 35 | 19 | 54 | ||||||||||||||||||||||||||||||||||
1931517 | 1931517 | CO | school | 801950 | 30 | ADAMS COUNTY 14 | 80195001307 | 22 | LESTER R ARNOLD HIGH SCHOOL | Alternative School | No | High | 09 | 12 | 2019 | grade_11 | 9 | 2 | 58 | 0 | 0 | 0 | 0 | 34 | 35 | 69 | 9 | 2 | 58 | 0 | 0 | 0 | 0 | 34 | 35 | 69 | ||||||||||||||||||||||||||||||||||
1931518 | 1931518 | CO | school | 801950 | 30 | ADAMS COUNTY 14 | 80195001307 | 22 | LESTER R ARNOLD HIGH SCHOOL | Alternative School | No | High | 09 | 12 | 2019 | grade_12 | 10 | 4 | 130 | 1 | 0 | 0 | 2 | 66 | 81 | 147 | 10 | 4 | 130 | 1 | 0 | 0 | 2 | 66 | 81 | 147 | ||||||||||||||||||||||||||||||||||
1931519 | 1931519 | CO | school | 801950 | 30 | ADAMS COUNTY 14 | 80195001307 | 22 | LESTER R ARNOLD HIGH SCHOOL | Alternative School | No | High | 09 | 12 | 2019 | grade_9 | 1 | 0 | 1 | 0 | 0 | 0 | 0 | 2 | 0 | 2 | 1 | 0 | 1 | 0 | 0 | 0 | 0 | 2 | 0 | 2 | ||||||||||||||||||||||||||||||||||
1931520 | 1931520 | CO | school | 801950 | 30 | ADAMS COUNTY 14 | 80195001307 | 22 | LESTER R ARNOLD HIGH SCHOOL | Alternative School | No | High | 09 | 12 | 2019 | pk_12_total | 28 | 8 | 231 | 1 | 0 | 0 | 4 | 137 | 135 | 272 | 28 | 8 | 231 | 1 | 0 | 0 | 4 | 137 | 135 | 272 | ||||||||||||||||||||||||||||||||||
1931608 | 1931608 | CO | school | 802580 | 40 | SCHOOL DISTRICT 27J | 80258000729 | 1021 | BRIGHTON HERITAGE ACADEMY | Alternative School | No | High | 06 | 12 | 2019 | grade_10 | 10 | 1 | 12 | 1 | 0 | 0 | 0 | 13 | 11 | 24 | 10 | 1 | 12 | 1 | 0 | 0 | 0 | 13 | 11 | 24 | ||||||||||||||||||||||||||||||||||
1931609 | 1931609 | CO | school | 802580 | 40 | SCHOOL DISTRICT 27J | 80258000729 | 1021 | BRIGHTON HERITAGE ACADEMY | Alternative School | No | High | 06 | 12 | 2019 | grade_11 | 18 | 0 | 31 | 0 | 0 | 0 | 2 | 34 | 17 | 51 | 18 | 0 | 31 | 0 | 0 | 0 | 2 | 34 | 17 | 51 | ||||||||||||||||||||||||||||||||||
1931610 | 1931610 | CO | school | 802580 | 40 | SCHOOL DISTRICT 27J | 80258000729 | 1021 | BRIGHTON HERITAGE ACADEMY | Alternative School | No | High | 06 | 12 | 2019 | grade_12 | 52 | 4 | 64 | 1 | 0 | 0 | 2 | 75 | 48 | 123 | 52 | 4 | 64 | 1 | 0 | 0 | 2 | 75 | 48 | 123 | ||||||||||||||||||||||||||||||||||
1931611 | 1931611 | CO | school | 802580 | 40 | SCHOOL DISTRICT 27J | 80258000729 | 1021 | BRIGHTON HERITAGE ACADEMY | Alternative School | No | High | 06 | 12 | 2019 | grade_8 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | ||||||||||||||||||||||||||||||||||
1931612 | 1931612 | CO | school | 802580 | 40 | SCHOOL DISTRICT 27J | 80258000729 | 1021 | BRIGHTON HERITAGE ACADEMY | Alternative School | No | High | 06 | 12 | 2019 | grade_9 | 1 | 0 | 9 | 0 | 0 | 0 | 0 | 9 | 1 | 10 | 1 | 0 | 9 | 0 | 0 | 0 | 0 | 9 | 1 | 10 | ||||||||||||||||||||||||||||||||||
1931613 | 1931613 | CO | school | 802580 | 40 | SCHOOL DISTRICT 27J | 80258000729 | 1021 | BRIGHTON HERITAGE ACADEMY | Alternative School | No | High | 06 | 12 | 2019 | pk_12_total | 82 | 5 | 116 | 2 | 0 | 0 | 4 | 132 | 77 | 209 | 82 | 5 | 116 | 2 | 0 | 0 | 4 | 132 | 77 | 209 | ||||||||||||||||||||||||||||||||||
1931802 | 1931802 | CO | school | 806750 | 60 | STRASBURG 31J | 80675001669 | 7133 | PRAIRIE CREEK HIGH SCHOOL | Alternative School | No | High | 09 | 12 | 2019 | grade_11 | 5 | 0 | 1 | 0 | 0 | 0 | 0 | 5 | 1 | 6 | 5 | 0 | 1 | 0 | 0 | 0 | 0 | 5 | 1 | 6 | ||||||||||||||||||||||||||||||||||
1931803 | 1931803 | CO | school | 806750 | 60 | STRASBURG 31J | 80675001669 | 7133 | PRAIRIE CREEK HIGH SCHOOL | Alternative School | No | High | 09 | 12 | 2019 | grade_12 | 4 | 0 | 1 | 0 | 0 | 0 | 0 | 4 | 1 | 5 | 4 | 0 | 1 | 0 | 0 | 0 | 0 | 4 | 1 | 5 | ||||||||||||||||||||||||||||||||||
1931804 | 1931804 | CO | school | 806750 | 60 | STRASBURG 31J | 80675001669 | 7133 | PRAIRIE CREEK HIGH SCHOOL | Alternative School | No | High | 09 | 12 | 2019 | grade_9 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | ||||||||||||||||||||||||||||||||||
1931805 | 1931805 | CO | school | 806750 | 60 | STRASBURG 31J | 80675001669 | 7133 | PRAIRIE CREEK HIGH SCHOOL | Alternative School | No | High | 09 | 12 | 2019 | pk_12_total | 10 | 0 | 2 | 0 | 0 | 0 | 0 | 10 | 2 | 12 | 10 | 0 | 2 | 0 | 0 | 0 | 0 | 10 | 2 | 12 | ||||||||||||||||||||||||||||||||||
1931976 | 1931976 | CO | school | 802070 | 100 | ALAMOSA RE-11J | 80207006508 | 368 | ALAMOSA OMBUDSMAN SCHOOL OF EXCELLENCE | Alternative School | No | High | 06 | 12 | 2019 | grade_10 | 0 | 0 | 8 | 0 | 0 | 0 | 0 | 6 | 2 | 8 | 0 | 0 | 8 | 0 | 0 | 0 | 0 | 6 | 2 | 8 | ||||||||||||||||||||||||||||||||||
1931977 | 1931977 | CO | school | 802070 | 100 | ALAMOSA RE-11J | 80207006508 | 368 | ALAMOSA OMBUDSMAN SCHOOL OF EXCELLENCE | Alternative School | No | High | 06 | 12 | 2019 | grade_11 | 0 | 0 | 5 | 0 | 0 | 0 | 0 | 4 | 1 | 5 | 0 | 0 | 5 | 0 | 0 | 0 | 0 | 4 | 1 | 5 | ||||||||||||||||||||||||||||||||||
1931978 | 1931978 | CO | school | 802070 | 100 | ALAMOSA RE-11J | 80207006508 | 368 | ALAMOSA OMBUDSMAN SCHOOL OF EXCELLENCE | Alternative School | No | High | 06 | 12 | 2019 | grade_12 | 1 | 0 | 5 | 0 | 0 | 0 | 2 | 5 | 3 | 8 | 1 | 0 | 5 | 0 | 0 | 0 | 2 | 5 | 3 | 8 | ||||||||||||||||||||||||||||||||||
1931979 | 1931979 | CO | school | 802070 | 100 | ALAMOSA RE-11J | 80207006508 | 368 | ALAMOSA OMBUDSMAN SCHOOL OF EXCELLENCE | Alternative School | No | High | 06 | 12 | 2019 | grade_6 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | ||||||||||||||||||||||||||||||||||
1931980 | 1931980 | CO | school | 802070 | 100 | ALAMOSA RE-11J | 80207006508 | 368 | ALAMOSA OMBUDSMAN SCHOOL OF EXCELLENCE | Alternative School | No | High | 06 | 12 | 2019 | grade_7 | 2 | 0 | 1 | 0 | 0 | 0 | 0 | 2 | 1 | 3 | 2 | 0 | 1 | 0 | 0 | 0 | 0 | 2 | 1 | 3 | ||||||||||||||||||||||||||||||||||
1931981 | 1931981 | CO | school | 802070 | 100 | ALAMOSA RE-11J | 80207006508 | 368 | ALAMOSA OMBUDSMAN SCHOOL OF EXCELLENCE | Alternative School | No | High | 06 | 12 | 2019 | grade_8 | 2 | 0 | 8 | 0 | 0 | 0 | 0 | 7 | 3 | 10 | 2 | 0 | 8 | 0 | 0 | 0 | 0 | 7 | 3 | 10 | ||||||||||||||||||||||||||||||||||
1931982 | 1931982 | CO | school | 802070 | 100 | ALAMOSA RE-11J | 80207006508 | 368 | ALAMOSA OMBUDSMAN SCHOOL OF EXCELLENCE | Alternative School | No | High | 06 | 12 | 2019 | grade_9 | 2 | 0 | 10 | 1 | 0 | 0 | 0 | 7 | 6 | 13 | 2 | 0 | 10 | 1 | 0 | 0 | 0 | 7 | 6 | 13 | ||||||||||||||||||||||||||||||||||
1931983 | 1931983 | CO | school | 802070 | 100 | ALAMOSA RE-11J | 80207006508 | 368 | ALAMOSA OMBUDSMAN SCHOOL OF EXCELLENCE | Alternative School | No | High | 06 | 12 | 2019 | pk_12_total | 8 | 0 | 37 | 1 | 0 | 0 | 2 | 32 | 16 | 48 | 8 | 0 | 37 | 1 | 0 | 0 | 2 | 32 | 16 | 48 | ||||||||||||||||||||||||||||||||||
1932000 | 1932000 | CO | school | 803780 | 120 | ENGLEWOOD 1 | 80378001310 | 206 | COLORADO'S FINEST HIGH SCHOOL OF CHOICE | Alternative School | No | High | 09 | 12 | 2019 | grade_10 | 51 | 0 | 22 | 0 | 0 | 0 | 3 | 41 | 35 | 76 | 51 | 0 | 22 | 0 | 0 | 0 | 3 | 41 | 35 | 76 | ||||||||||||||||||||||||||||||||||
1932001 | 1932001 | CO | school | 803780 | 120 | ENGLEWOOD 1 | 80378001310 | 206 | COLORADO'S FINEST HIGH SCHOOL OF CHOICE | Alternative School | No | High | 09 | 12 | 2019 | grade_11 | 57 | 3 | 34 | 1 | 1 | 0 | 6 | 59 | 43 | 102 | 57 | 3 | 34 | 1 | 1 | 0 | 6 | 59 | 43 | 102 | ||||||||||||||||||||||||||||||||||
1932002 | 1932002 | CO | school | 803780 | 120 | ENGLEWOOD 1 | 80378001310 | 206 | COLORADO'S FINEST HIGH SCHOOL OF CHOICE | Alternative School | No | High | 09 | 12 | 2019 | grade_12 | 65 | 4 | 23 | 1 | 0 | 0 | 2 | 48 | 47 | 95 | 65 | 4 | 23 | 1 | 0 | 0 | 2 | 48 | 47 | 95 | ||||||||||||||||||||||||||||||||||
1932003 | 1932003 | CO | school | 803780 | 120 | ENGLEWOOD 1 | 80378001310 | 206 | COLORADO'S FINEST HIGH SCHOOL OF CHOICE | Alternative School | No | High | 09 | 12 | 2019 | grade_9 | 14 | 1 | 12 | 0 | 0 | 0 | 1 | 16 | 12 | 28 | 14 | 1 | 12 | 0 | 0 | 0 | 1 | 16 | 12 | 28 | ||||||||||||||||||||||||||||||||||
1932004 | 1932004 | CO | school | 803780 | 120 | ENGLEWOOD 1 | 80378001310 | 206 | COLORADO'S FINEST HIGH SCHOOL OF CHOICE | Alternative School | No | High | 09 | 12 | 2019 | pk_12_total | 187 | 8 | 91 | 2 | 1 | 0 | 12 | 164 | 137 | 301 | 187 | 8 | 91 | 2 | 1 | 0 | 12 | 164 | 137 | 301 | ||||||||||||||||||||||||||||||||||
1932069 | 1932069 | CO | school | 806540 | 123 | SHERIDAN 2 | 80654006565 | 8123 | SOAR ACADEMY | Alternative School | No | High | 06 | 12 | 2019 | grade_10 | 3 | 1 | 12 | 1 | 0 | 0 | 0 | 13 | 4 | 17 | 3 | 1 | 12 | 1 | 0 | 0 | 0 | 13 | 4 | 17 | ||||||||||||||||||||||||||||||||||
1932070 | 1932070 | CO | school | 806540 | 123 | SHERIDAN 2 | 80654006565 | 8123 | SOAR ACADEMY | Alternative School | No | High | 06 | 12 | 2019 | grade_11 | 2 | 0 | 21 | 3 | 0 | 0 | 0 | 15 | 11 | 26 | 2 | 0 | 21 | 3 | 0 | 0 | 0 | 15 | 11 | 26 | ||||||||||||||||||||||||||||||||||
1932071 | 1932071 | CO | school | 806540 | 123 | SHERIDAN 2 | 80654006565 | 8123 | SOAR ACADEMY | Alternative School | No | High | 06 | 12 | 2019 | grade_12 | 9 | 1 | 40 | 1 | 0 | 0 | 2 | 33 | 20 | 53 | 9 | 1 | 40 | 1 | 0 | 0 | 2 | 33 | 20 | 53 | ||||||||||||||||||||||||||||||||||
1932072 | 1932072 | CO | school | 806540 | 123 | SHERIDAN 2 | 80654006565 | 8123 | SOAR ACADEMY | Alternative School | No | High | 06 | 12 | 2019 | grade_9 | 0 | 0 | 6 | 0 | 0 | 0 | 0 | 3 | 3 | 6 | 0 | 0 | 6 | 0 | 0 | 0 | 0 | 3 | 3 | 6 | ||||||||||||||||||||||||||||||||||
1932073 | 1932073 | CO | school | 806540 | 123 | SHERIDAN 2 | 80654006565 | 8123 | SOAR ACADEMY | Alternative School | No | High | 06 | 12 | 2019 | pk_12_total | 14 | 2 | 79 | 5 | 0 | 0 | 2 | 64 | 38 | 102 | 14 | 2 | 79 | 5 | 0 | 0 | 2 | 64 | 38 | 102 | ||||||||||||||||||||||||||||||||||
1932250 | 1932250 | CO | school | 802910 | 130 | CHERRY CREEK 5 | 80291006649 | 2653 | ENDEAVOR ACADEMY | Alternative School | No | High | 09 | 12 | 2019 | grade_10 | 5 | 0 | 5 | 0 | 0 | 0 | 1 | 3 | 8 | 11 | 5 | 0 | 5 | 0 | 0 | 0 | 1 | 3 | 8 | 11 |
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]);