enrollments
Data source: Big Local News · About: Big Local
13,413 rows where state = "CO" and year = 2019 sorted by ccd_school_low_grade
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 | |||||||||||||||||||||||||||||||||||||||||
1934755 | 1934755 | CO | school | 803360 | 880 | DENVER COUNTY 1 | 80336000331 | 1908 | CORY ELEMENTARY SCHOOL | Regular School | No | Elementary | 01 | 05 | 2019 | grade_1 | 57 | 4 | 9 | 0 | 3 | 0 | 10 | 42 | 41 | 83 | 57 | 4 | 9 | 0 | 3 | 0 | 10 | 42 | 41 | 83 | ||||||||||||||||||||||||||||||||||
1934756 | 1934756 | CO | school | 803360 | 880 | DENVER COUNTY 1 | 80336000331 | 1908 | CORY ELEMENTARY SCHOOL | Regular School | No | Elementary | 01 | 05 | 2019 | grade_2 | 65 | 0 | 12 | 0 | 2 | 0 | 6 | 39 | 46 | 85 | 65 | 0 | 12 | 0 | 2 | 0 | 6 | 39 | 46 | 85 | ||||||||||||||||||||||||||||||||||
1934757 | 1934757 | CO | school | 803360 | 880 | DENVER COUNTY 1 | 80336000331 | 1908 | CORY ELEMENTARY SCHOOL | Regular School | No | Elementary | 01 | 05 | 2019 | grade_3 | 59 | 2 | 5 | 0 | 4 | 0 | 12 | 45 | 37 | 82 | 59 | 2 | 5 | 0 | 4 | 0 | 12 | 45 | 37 | 82 | ||||||||||||||||||||||||||||||||||
1934758 | 1934758 | CO | school | 803360 | 880 | DENVER COUNTY 1 | 80336000331 | 1908 | CORY ELEMENTARY SCHOOL | Regular School | No | Elementary | 01 | 05 | 2019 | grade_4 | 56 | 2 | 8 | 0 | 7 | 0 | 8 | 36 | 45 | 81 | 56 | 2 | 8 | 0 | 7 | 0 | 8 | 36 | 45 | 81 | ||||||||||||||||||||||||||||||||||
1934759 | 1934759 | CO | school | 803360 | 880 | DENVER COUNTY 1 | 80336000331 | 1908 | CORY ELEMENTARY SCHOOL | Regular School | No | Elementary | 01 | 05 | 2019 | grade_5 | 69 | 1 | 4 | 1 | 4 | 0 | 4 | 47 | 36 | 83 | 69 | 1 | 4 | 1 | 4 | 0 | 4 | 47 | 36 | 83 | ||||||||||||||||||||||||||||||||||
1934760 | 1934760 | CO | school | 803360 | 880 | DENVER COUNTY 1 | 80336000331 | 1908 | CORY ELEMENTARY SCHOOL | Regular School | No | Elementary | 01 | 05 | 2019 | pk_12_total | 306 | 9 | 38 | 1 | 20 | 0 | 40 | 209 | 205 | 414 | 306 | 9 | 38 | 1 | 20 | 0 | 40 | 209 | 205 | 414 | ||||||||||||||||||||||||||||||||||
1934773 | 1934773 | CO | school | 803360 | 880 | DENVER COUNTY 1 | 80336001767 | 2027 | POLARIS ELEMENTARY SCHOOL | Regular School | No | Elementary | 01 | 05 | 2019 | grade_1 | 25 | 0 | 7 | 2 | 2 | 0 | 8 | 22 | 22 | 44 | 25 | 0 | 7 | 2 | 2 | 0 | 8 | 22 | 22 | 44 | ||||||||||||||||||||||||||||||||||
1934774 | 1934774 | CO | school | 803360 | 880 | DENVER COUNTY 1 | 80336001767 | 2027 | POLARIS ELEMENTARY SCHOOL | Regular School | No | Elementary | 01 | 05 | 2019 | grade_2 | 32 | 4 | 7 | 0 | 1 | 0 | 5 | 26 | 23 | 49 | 32 | 4 | 7 | 0 | 1 | 0 | 5 | 26 | 23 | 49 | ||||||||||||||||||||||||||||||||||
1934775 | 1934775 | CO | school | 803360 | 880 | DENVER COUNTY 1 | 80336001767 | 2027 | POLARIS ELEMENTARY SCHOOL | Regular School | No | Elementary | 01 | 05 | 2019 | grade_3 | 60 | 2 | 6 | 0 | 6 | 0 | 4 | 36 | 42 | 78 | 60 | 2 | 6 | 0 | 6 | 0 | 4 | 36 | 42 | 78 | ||||||||||||||||||||||||||||||||||
1934776 | 1934776 | CO | school | 803360 | 880 | DENVER COUNTY 1 | 80336001767 | 2027 | POLARIS ELEMENTARY SCHOOL | Regular School | No | Elementary | 01 | 05 | 2019 | grade_4 | 61 | 5 | 7 | 0 | 1 | 0 | 6 | 43 | 37 | 80 | 61 | 5 | 7 | 0 | 1 | 0 | 6 | 43 | 37 | 80 | ||||||||||||||||||||||||||||||||||
1934777 | 1934777 | CO | school | 803360 | 880 | DENVER COUNTY 1 | 80336001767 | 2027 | POLARIS ELEMENTARY SCHOOL | Regular School | No | Elementary | 01 | 05 | 2019 | grade_5 | 62 | 1 | 6 | 0 | 2 | 0 | 10 | 50 | 31 | 81 | 62 | 1 | 6 | 0 | 2 | 0 | 10 | 50 | 31 | 81 | ||||||||||||||||||||||||||||||||||
1934778 | 1934778 | CO | school | 803360 | 880 | DENVER COUNTY 1 | 80336001767 | 2027 | POLARIS ELEMENTARY SCHOOL | Regular School | No | Elementary | 01 | 05 | 2019 | pk_12_total | 240 | 12 | 33 | 2 | 12 | 0 | 33 | 177 | 155 | 332 | 240 | 12 | 33 | 2 | 12 | 0 | 33 | 177 | 155 | 332 | ||||||||||||||||||||||||||||||||||
1935022 | 1935022 | CO | school | 803360 | 880 | DENVER COUNTY 1 | 80336001864 | 3340 | LENA ARCHULETA ELEMENTARY SCHOOL | Regular School | No | Elementary | 01 | 05 | 2019 | grade_1 | 7 | 8 | 76 | 0 | 4 | 0 | 2 | 46 | 51 | 97 | 7 | 8 | 76 | 0 | 4 | 0 | 2 | 46 | 51 | 97 | ||||||||||||||||||||||||||||||||||
1935023 | 1935023 | CO | school | 803360 | 880 | DENVER COUNTY 1 | 80336001864 | 3340 | LENA ARCHULETA ELEMENTARY SCHOOL | Regular School | No | Elementary | 01 | 05 | 2019 | grade_2 | 5 | 8 | 75 | 0 | 1 | 0 | 2 | 50 | 41 | 91 | 5 | 8 | 75 | 0 | 1 | 0 | 2 | 50 | 41 | 91 | ||||||||||||||||||||||||||||||||||
1935024 | 1935024 | CO | school | 803360 | 880 | DENVER COUNTY 1 | 80336001864 | 3340 | LENA ARCHULETA ELEMENTARY SCHOOL | Regular School | No | Elementary | 01 | 05 | 2019 | grade_3 | 4 | 9 | 82 | 0 | 3 | 0 | 0 | 53 | 45 | 98 | 4 | 9 | 82 | 0 | 3 | 0 | 0 | 53 | 45 | 98 | ||||||||||||||||||||||||||||||||||
1935025 | 1935025 | CO | school | 803360 | 880 | DENVER COUNTY 1 | 80336001864 | 3340 | LENA ARCHULETA ELEMENTARY SCHOOL | Regular School | No | Elementary | 01 | 05 | 2019 | grade_4 | 2 | 14 | 88 | 0 | 1 | 0 | 1 | 50 | 56 | 106 | 2 | 14 | 88 | 0 | 1 | 0 | 1 | 50 | 56 | 106 | ||||||||||||||||||||||||||||||||||
1935026 | 1935026 | CO | school | 803360 | 880 | DENVER COUNTY 1 | 80336001864 | 3340 | LENA ARCHULETA ELEMENTARY SCHOOL | Regular School | No | Elementary | 01 | 05 | 2019 | grade_5 | 5 | 11 | 89 | 0 | 3 | 5 | 4 | 72 | 45 | 117 | 5 | 11 | 89 | 0 | 3 | 5 | 4 | 72 | 45 | 117 | ||||||||||||||||||||||||||||||||||
1935027 | 1935027 | CO | school | 803360 | 880 | DENVER COUNTY 1 | 80336001864 | 3340 | LENA ARCHULETA ELEMENTARY SCHOOL | Regular School | No | Elementary | 01 | 05 | 2019 | pk_12_total | 23 | 50 | 410 | 0 | 12 | 5 | 9 | 271 | 238 | 509 | 23 | 50 | 410 | 0 | 12 | 5 | 9 | 271 | 238 | 509 | ||||||||||||||||||||||||||||||||||
1941977 | 1941977 | CO | school | 804050 | 2405 | FORT MORGAN RE-3 | 80405006698 | 1009 | BAKER ELEMENTARY SCHOOL | Regular School | No | Elementary | 01 | 05 | 2019 | grade_1 | 13 | 2 | 36 | 0 | 0 | 0 | 1 | 26 | 26 | 52 | 13 | 2 | 36 | 0 | 0 | 0 | 1 | 26 | 26 | 52 | ||||||||||||||||||||||||||||||||||
1941978 | 1941978 | CO | school | 804050 | 2405 | FORT MORGAN RE-3 | 80405006698 | 1009 | BAKER ELEMENTARY SCHOOL | Regular School | No | Elementary | 01 | 05 | 2019 | grade_2 | 13 | 1 | 41 | 0 | 1 | 0 | 0 | 29 | 27 | 56 | 13 | 1 | 41 | 0 | 1 | 0 | 0 | 29 | 27 | 56 | ||||||||||||||||||||||||||||||||||
1941979 | 1941979 | CO | school | 804050 | 2405 | FORT MORGAN RE-3 | 80405006698 | 1009 | BAKER ELEMENTARY SCHOOL | Regular School | No | Elementary | 01 | 05 | 2019 | grade_3 | 12 | 2 | 50 | 0 | 0 | 0 | 1 | 34 | 31 | 65 | 12 | 2 | 50 | 0 | 0 | 0 | 1 | 34 | 31 | 65 | ||||||||||||||||||||||||||||||||||
1941980 | 1941980 | CO | school | 804050 | 2405 | FORT MORGAN RE-3 | 80405006698 | 1009 | BAKER ELEMENTARY SCHOOL | Regular School | No | Elementary | 01 | 05 | 2019 | grade_4 | 19 | 3 | 48 | 0 | 0 | 0 | 1 | 37 | 34 | 71 | 19 | 3 | 48 | 0 | 0 | 0 | 1 | 37 | 34 | 71 | ||||||||||||||||||||||||||||||||||
1941981 | 1941981 | CO | school | 804050 | 2405 | FORT MORGAN RE-3 | 80405006698 | 1009 | BAKER ELEMENTARY SCHOOL | Regular School | No | Elementary | 01 | 05 | 2019 | grade_5 | 17 | 1 | 31 | 1 | 0 | 0 | 0 | 24 | 26 | 50 | 17 | 1 | 31 | 1 | 0 | 0 | 0 | 24 | 26 | 50 | ||||||||||||||||||||||||||||||||||
1941982 | 1941982 | CO | school | 804050 | 2405 | FORT MORGAN RE-3 | 80405006698 | 1009 | BAKER ELEMENTARY SCHOOL | Regular School | No | Elementary | 01 | 05 | 2019 | pk_12_total | 74 | 9 | 206 | 1 | 1 | 0 | 3 | 150 | 144 | 294 | 74 | 9 | 206 | 1 | 1 | 0 | 3 | 150 | 144 | 294 | ||||||||||||||||||||||||||||||||||
1941983 | 1941983 | CO | school | 804050 | 2405 | FORT MORGAN RE-3 | 80405000556 | 1850 | COLUMBINE ELEMENTARY SCHOOL | Regular School | No | Elementary | 01 | 05 | 2019 | grade_1 | 31 | 2 | 46 | 1 | 1 | 0 | 1 | 44 | 38 | 82 | 31 | 2 | 46 | 1 | 1 | 0 | 1 | 44 | 38 | 82 | ||||||||||||||||||||||||||||||||||
1941984 | 1941984 | CO | school | 804050 | 2405 | FORT MORGAN RE-3 | 80405000556 | 1850 | COLUMBINE ELEMENTARY SCHOOL | Regular School | No | Elementary | 01 | 05 | 2019 | grade_2 | 31 | 3 | 52 | 0 | 3 | 0 | 1 | 42 | 48 | 90 | 31 | 3 | 52 | 0 | 3 | 0 | 1 | 42 | 48 | 90 | ||||||||||||||||||||||||||||||||||
1941985 | 1941985 | CO | school | 804050 | 2405 | FORT MORGAN RE-3 | 80405000556 | 1850 | COLUMBINE ELEMENTARY SCHOOL | Regular School | No | Elementary | 01 | 05 | 2019 | grade_3 | 14 | 2 | 36 | 0 | 0 | 0 | 2 | 28 | 26 | 54 | 14 | 2 | 36 | 0 | 0 | 0 | 2 | 28 | 26 | 54 | ||||||||||||||||||||||||||||||||||
1941986 | 1941986 | CO | school | 804050 | 2405 | FORT MORGAN RE-3 | 80405000556 | 1850 | COLUMBINE ELEMENTARY SCHOOL | Regular School | No | Elementary | 01 | 05 | 2019 | grade_4 | 21 | 2 | 44 | 0 | 0 | 0 | 1 | 43 | 25 | 68 | 21 | 2 | 44 | 0 | 0 | 0 | 1 | 43 | 25 | 68 | ||||||||||||||||||||||||||||||||||
1941987 | 1941987 | CO | school | 804050 | 2405 | FORT MORGAN RE-3 | 80405000556 | 1850 | COLUMBINE ELEMENTARY SCHOOL | Regular School | No | Elementary | 01 | 05 | 2019 | grade_5 | 14 | 1 | 38 | 0 | 0 | 0 | 1 | 28 | 26 | 54 | 14 | 1 | 38 | 0 | 0 | 0 | 1 | 28 | 26 | 54 | ||||||||||||||||||||||||||||||||||
1941988 | 1941988 | CO | school | 804050 | 2405 | FORT MORGAN RE-3 | 80405000556 | 1850 | COLUMBINE ELEMENTARY SCHOOL | Regular School | No | Elementary | 01 | 05 | 2019 | pk_12_total | 111 | 10 | 216 | 1 | 4 | 0 | 6 | 185 | 163 | 348 | 111 | 10 | 216 | 1 | 4 | 0 | 6 | 185 | 163 | 348 | ||||||||||||||||||||||||||||||||||
1941998 | 1941998 | CO | school | 804050 | 2405 | FORT MORGAN RE-3 | 80405000558 | 3620 | GREEN ACRES ELEMENTARY SCHOOL | Regular School | No | Elementary | 01 | 05 | 2019 | grade_1 | 25 | 3 | 29 | 0 | 0 | 0 | 4 | 24 | 37 | 61 | 25 | 3 | 29 | 0 | 0 | 0 | 4 | 24 | 37 | 61 | ||||||||||||||||||||||||||||||||||
1941999 | 1941999 | CO | school | 804050 | 2405 | FORT MORGAN RE-3 | 80405000558 | 3620 | GREEN ACRES ELEMENTARY SCHOOL | Regular School | No | Elementary | 01 | 05 | 2019 | grade_2 | 25 | 2 | 43 | 1 | 0 | 0 | 2 | 35 | 38 | 73 | 25 | 2 | 43 | 1 | 0 | 0 | 2 | 35 | 38 | 73 | ||||||||||||||||||||||||||||||||||
1942000 | 1942000 | CO | school | 804050 | 2405 | FORT MORGAN RE-3 | 80405000558 | 3620 | GREEN ACRES ELEMENTARY SCHOOL | Regular School | No | Elementary | 01 | 05 | 2019 | grade_3 | 23 | 1 | 29 | 0 | 0 | 0 | 1 | 24 | 30 | 54 | 23 | 1 | 29 | 0 | 0 | 0 | 1 | 24 | 30 | 54 | ||||||||||||||||||||||||||||||||||
1942001 | 1942001 | CO | school | 804050 | 2405 | FORT MORGAN RE-3 | 80405000558 | 3620 | GREEN ACRES ELEMENTARY SCHOOL | Regular School | No | Elementary | 01 | 05 | 2019 | grade_4 | 29 | 2 | 39 | 0 | 1 | 0 | 0 | 35 | 36 | 71 | 29 | 2 | 39 | 0 | 1 | 0 | 0 | 35 | 36 | 71 | ||||||||||||||||||||||||||||||||||
1942002 | 1942002 | CO | school | 804050 | 2405 | FORT MORGAN RE-3 | 80405000558 | 3620 | GREEN ACRES ELEMENTARY SCHOOL | Regular School | No | Elementary | 01 | 05 | 2019 | grade_5 | 32 | 2 | 39 | 1 | 1 | 0 | 1 | 40 | 36 | 76 | 32 | 2 | 39 | 1 | 1 | 0 | 1 | 40 | 36 | 76 | ||||||||||||||||||||||||||||||||||
1942003 | 1942003 | CO | school | 804050 | 2405 | FORT MORGAN RE-3 | 80405000558 | 3620 | GREEN ACRES ELEMENTARY SCHOOL | Regular School | No | Elementary | 01 | 05 | 2019 | pk_12_total | 134 | 10 | 179 | 2 | 2 | 0 | 8 | 158 | 177 | 335 | 134 | 10 | 179 | 2 | 2 | 0 | 8 | 158 | 177 | 335 | ||||||||||||||||||||||||||||||||||
1942009 | 1942009 | CO | school | 804050 | 2405 | FORT MORGAN RE-3 | 80405006298 | 6954 | PIONEER ELEMENTARY SCHOOL | Regular School | No | Elementary | 01 | 05 | 2019 | grade_1 | 11 | 13 | 39 | 0 | 0 | 0 | 1 | 32 | 32 | 64 | 11 | 13 | 39 | 0 | 0 | 0 | 1 | 32 | 32 | 64 | ||||||||||||||||||||||||||||||||||
1942010 | 1942010 | CO | school | 804050 | 2405 | FORT MORGAN RE-3 | 80405006298 | 6954 | PIONEER ELEMENTARY SCHOOL | Regular School | No | Elementary | 01 | 05 | 2019 | grade_2 | 14 | 6 | 45 | 1 | 0 | 0 | 0 | 33 | 33 | 66 | 14 | 6 | 45 | 1 | 0 | 0 | 0 | 33 | 33 | 66 | ||||||||||||||||||||||||||||||||||
1942011 | 1942011 | CO | school | 804050 | 2405 | FORT MORGAN RE-3 | 80405006298 | 6954 | PIONEER ELEMENTARY SCHOOL | Regular School | No | Elementary | 01 | 05 | 2019 | grade_3 | 13 | 7 | 50 | 1 | 0 | 0 | 2 | 41 | 32 | 73 | 13 | 7 | 50 | 1 | 0 | 0 | 2 | 41 | 32 | 73 | ||||||||||||||||||||||||||||||||||
1942012 | 1942012 | CO | school | 804050 | 2405 | FORT MORGAN RE-3 | 80405006298 | 6954 | PIONEER ELEMENTARY SCHOOL | Regular School | No | Elementary | 01 | 05 | 2019 | grade_4 | 14 | 4 | 41 | 0 | 0 | 0 | 0 | 23 | 36 | 59 | 14 | 4 | 41 | 0 | 0 | 0 | 0 | 23 | 36 | 59 | ||||||||||||||||||||||||||||||||||
1942013 | 1942013 | CO | school | 804050 | 2405 | FORT MORGAN RE-3 | 80405006298 | 6954 | PIONEER ELEMENTARY SCHOOL | Regular School | No | Elementary | 01 | 05 | 2019 | grade_5 | 11 | 9 | 38 | 1 | 0 | 0 | 0 | 27 | 32 | 59 | 11 | 9 | 38 | 1 | 0 | 0 | 0 | 27 | 32 | 59 | ||||||||||||||||||||||||||||||||||
1942014 | 1942014 | CO | school | 804050 | 2405 | FORT MORGAN RE-3 | 80405006298 | 6954 | PIONEER ELEMENTARY SCHOOL | Regular School | No | Elementary | 01 | 05 | 2019 | pk_12_total | 63 | 39 | 213 | 3 | 0 | 0 | 3 | 156 | 165 | 321 | 63 | 39 | 213 | 3 | 0 | 0 | 3 | 156 | 165 | 321 | ||||||||||||||||||||||||||||||||||
1942843 | 1942843 | CO | school | 805760 | 2740 | MONTE VISTA C-8 | 80576000985 | 6036 | BILL METZ ELEMENTARY SCHOOL | Regular School | No | Elementary | 01 | 05 | 2019 | grade_1 | 20 | 1 | 37 | 1 | 0 | 0 | 0 | 34 | 25 | 59 | 20 | 1 | 37 | 1 | 0 | 0 | 0 | 34 | 25 | 59 | ||||||||||||||||||||||||||||||||||
1942844 | 1942844 | CO | school | 805760 | 2740 | MONTE VISTA C-8 | 80576000985 | 6036 | BILL METZ ELEMENTARY SCHOOL | Regular School | No | Elementary | 01 | 05 | 2019 | grade_2 | 9 | 0 | 51 | 1 | 0 | 0 | 0 | 34 | 27 | 61 | 9 | 0 | 51 | 1 | 0 | 0 | 0 | 34 | 27 | 61 | ||||||||||||||||||||||||||||||||||
1942845 | 1942845 | CO | school | 805760 | 2740 | MONTE VISTA C-8 | 80576000985 | 6036 | BILL METZ ELEMENTARY SCHOOL | Regular School | No | Elementary | 01 | 05 | 2019 | grade_3 | 24 | 0 | 57 | 0 | 0 | 0 | 2 | 36 | 47 | 83 | 24 | 0 | 57 | 0 | 0 | 0 | 2 | 36 | 47 | 83 | ||||||||||||||||||||||||||||||||||
1942846 | 1942846 | CO | school | 805760 | 2740 | MONTE VISTA C-8 | 80576000985 | 6036 | BILL METZ ELEMENTARY SCHOOL | Regular School | No | Elementary | 01 | 05 | 2019 | grade_4 | 19 | 0 | 56 | 0 | 0 | 0 | 0 | 40 | 35 | 75 | 19 | 0 | 56 | 0 | 0 | 0 | 0 | 40 | 35 | 75 | ||||||||||||||||||||||||||||||||||
1942847 | 1942847 | CO | school | 805760 | 2740 | MONTE VISTA C-8 | 80576000985 | 6036 | BILL METZ ELEMENTARY SCHOOL | Regular School | No | Elementary | 01 | 05 | 2019 | grade_5 | 20 | 0 | 52 | 2 | 0 | 0 | 1 | 37 | 38 | 75 | 20 | 0 | 52 | 2 | 0 | 0 | 1 | 37 | 38 | 75 | ||||||||||||||||||||||||||||||||||
1942848 | 1942848 | CO | school | 805760 | 2740 | MONTE VISTA C-8 | 80576000985 | 6036 | BILL METZ ELEMENTARY SCHOOL | Regular School | No | Elementary | 01 | 05 | 2019 | pk_12_total | 92 | 1 | 253 | 4 | 0 | 0 | 3 | 181 | 172 | 353 | 92 | 1 | 253 | 4 | 0 | 0 | 3 | 181 | 172 | 353 | ||||||||||||||||||||||||||||||||||
1938160 | 1938160 | CO | school | 803870 | 1110 | DISTRICT 49 | 80387006725 | 101 | ALLIES | Alternative School | No | Elementary | 02 | 05 | 2019 | grade_2 | 10 | 0 | 2 | 0 | 0 | 0 | 0 | 8 | 4 | 12 | 10 | 0 | 2 | 0 | 0 | 0 | 0 | 8 | 4 | 12 | ||||||||||||||||||||||||||||||||||
1938161 | 1938161 | CO | school | 803870 | 1110 | DISTRICT 49 | 80387006725 | 101 | ALLIES | Alternative School | No | Elementary | 02 | 05 | 2019 | grade_3 | 29 | 1 | 6 | 0 | 0 | 1 | 3 | 18 | 22 | 40 | 29 | 1 | 6 | 0 | 0 | 1 | 3 | 18 | 22 | 40 | ||||||||||||||||||||||||||||||||||
1938162 | 1938162 | CO | school | 803870 | 1110 | DISTRICT 49 | 80387006725 | 101 | ALLIES | Alternative School | No | Elementary | 02 | 05 | 2019 | grade_4 | 21 | 3 | 8 | 1 | 0 | 0 | 6 | 16 | 23 | 39 | 21 | 3 | 8 | 1 | 0 | 0 | 6 | 16 | 23 | 39 | ||||||||||||||||||||||||||||||||||
1938163 | 1938163 | CO | school | 803870 | 1110 | DISTRICT 49 | 80387006725 | 101 | ALLIES | Alternative School | No | Elementary | 02 | 05 | 2019 | grade_5 | 17 | 2 | 2 | 0 | 0 | 0 | 2 | 12 | 11 | 23 | 17 | 2 | 2 | 0 | 0 | 0 | 2 | 12 | 11 | 23 | ||||||||||||||||||||||||||||||||||
1938164 | 1938164 | CO | school | 803870 | 1110 | DISTRICT 49 | 80387006725 | 101 | ALLIES | Alternative School | No | Elementary | 02 | 05 | 2019 | pk_12_total | 77 | 6 | 18 | 1 | 0 | 1 | 11 | 54 | 60 | 114 | 77 | 6 | 18 | 1 | 0 | 1 | 11 | 54 | 60 | 114 | ||||||||||||||||||||||||||||||||||
1938663 | 1938663 | CO | school | 804380 | 1220 | GARFIELD 16 | 80438000630 | 3578 | BEA UNDERWOOD ELEMENTARY SCHOOL | Regular School | No | Elementary | 02 | 05 | 2019 | grade_2 | 49 | 0 | 31 | 0 | 0 | 0 | 3 | 49 | 34 | 83 | 49 | 0 | 31 | 0 | 0 | 0 | 3 | 49 | 34 | 83 | ||||||||||||||||||||||||||||||||||
1938664 | 1938664 | CO | school | 804380 | 1220 | GARFIELD 16 | 80438000630 | 3578 | BEA UNDERWOOD ELEMENTARY SCHOOL | Regular School | No | Elementary | 02 | 05 | 2019 | grade_3 | 58 | 0 | 33 | 0 | 0 | 0 | 3 | 58 | 36 | 94 | 58 | 0 | 33 | 0 | 0 | 0 | 3 | 58 | 36 | 94 | ||||||||||||||||||||||||||||||||||
1938665 | 1938665 | CO | school | 804380 | 1220 | GARFIELD 16 | 80438000630 | 3578 | BEA UNDERWOOD ELEMENTARY SCHOOL | Regular School | No | Elementary | 02 | 05 | 2019 | grade_4 | 56 | 0 | 29 | 0 | 0 | 0 | 2 | 41 | 46 | 87 | 56 | 0 | 29 | 0 | 0 | 0 | 2 | 41 | 46 | 87 |
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]);