enrollments
Data source: Big Local News · About: Big Local
13,413 rows where state = "CO" and year = 2019 sorted by ccd_school_high_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 | |||||||||||||||||||||||||||||||||||||||||
1938668 | 1938668 | CO | school | 804380 | 1220 | GARFIELD 16 | 80438001909 | 3585 | GRAND VALLEY CENTER FOR FAMILY LEARNING | Regular School | No | Elementary | PK | 01 | 2019 | grade_1 | 43 | 1 | 35 | 0 | 0 | 0 | 4 | 41 | 42 | 83 | 43 | 1 | 35 | 0 | 0 | 0 | 4 | 41 | 42 | 83 | ||||||||||||||||||||||||||||||||||
1938669 | 1938669 | CO | school | 804380 | 1220 | GARFIELD 16 | 80438001909 | 3585 | GRAND VALLEY CENTER FOR FAMILY LEARNING | Regular School | No | Elementary | PK | 01 | 2019 | kindergarten_full_day | 68 | 0 | 32 | 1 | 0 | 0 | 4 | 61 | 44 | 105 | 68 | 0 | 32 | 1 | 0 | 0 | 4 | 61 | 44 | 105 | ||||||||||||||||||||||||||||||||||
1938670 | 1938670 | CO | school | 804380 | 1220 | GARFIELD 16 | 80438001909 | 3585 | GRAND VALLEY CENTER FOR FAMILY LEARNING | Regular School | No | Elementary | PK | 01 | 2019 | pk_12_total | 179 | 1 | 102 | 1 | 1 | 0 | 9 | 147 | 146 | 293 | 179 | 1 | 102 | 1 | 1 | 0 | 9 | 147 | 146 | 293 | ||||||||||||||||||||||||||||||||||
1938671 | 1938671 | CO | school | 804380 | 1220 | GARFIELD 16 | 80438001909 | 3585 | GRAND VALLEY CENTER FOR FAMILY LEARNING | Regular School | No | Elementary | PK | 01 | 2019 | pre_kindergarten | 68 | 0 | 35 | 0 | 1 | 0 | 1 | 45 | 60 | 105 | 68 | 0 | 35 | 0 | 1 | 0 | 1 | 45 | 60 | 105 | ||||||||||||||||||||||||||||||||||
1941086 | 1941086 | CO | school | 806960 | 1580 | TRINIDAD 1 | 80696001201 | 2481 | ECKHART ELEMENTARY SCHOOL | Regular School | No | Elementary | KG | 01 | 2019 | grade_1 | 25 | 2 | 49 | 1 | 0 | 0 | 1 | 31 | 47 | 78 | 25 | 2 | 49 | 1 | 0 | 0 | 1 | 31 | 47 | 78 | ||||||||||||||||||||||||||||||||||
1941087 | 1941087 | CO | school | 806960 | 1580 | TRINIDAD 1 | 80696001201 | 2481 | ECKHART ELEMENTARY SCHOOL | Regular School | No | Elementary | KG | 01 | 2019 | kindergarten_full_day | 62 | 0 | 4 | 0 | 0 | 0 | 0 | 39 | 27 | 66 | 62 | 0 | 4 | 0 | 0 | 0 | 0 | 39 | 27 | 66 | ||||||||||||||||||||||||||||||||||
1941088 | 1941088 | CO | school | 806960 | 1580 | TRINIDAD 1 | 80696001201 | 2481 | ECKHART ELEMENTARY SCHOOL | Regular School | No | Elementary | KG | 01 | 2019 | pk_12_total | 87 | 2 | 53 | 1 | 0 | 0 | 1 | 70 | 74 | 144 | 87 | 2 | 53 | 1 | 0 | 0 | 1 | 70 | 74 | 144 | ||||||||||||||||||||||||||||||||||
1932051 | 1932051 | CO | school | 806540 | 123 | SHERIDAN 2 | 80654001132 | 3054 | ALICE TERRY ELEMENTARY SCHOOL | Regular School | No | Elementary | KG | 02 | 2019 | grade_1 | 8 | 3 | 62 | 1 | 2 | 0 | 2 | 37 | 41 | 78 | 8 | 3 | 62 | 1 | 2 | 0 | 2 | 37 | 41 | 78 | ||||||||||||||||||||||||||||||||||
1932052 | 1932052 | CO | school | 806540 | 123 | SHERIDAN 2 | 80654001132 | 3054 | ALICE TERRY ELEMENTARY SCHOOL | Regular School | No | Elementary | KG | 02 | 2019 | grade_2 | 10 | 1 | 56 | 1 | 0 | 0 | 4 | 43 | 29 | 72 | 10 | 1 | 56 | 1 | 0 | 0 | 4 | 43 | 29 | 72 | ||||||||||||||||||||||||||||||||||
1932053 | 1932053 | CO | school | 806540 | 123 | SHERIDAN 2 | 80654001132 | 3054 | ALICE TERRY ELEMENTARY SCHOOL | Regular School | No | Elementary | KG | 02 | 2019 | kindergarten_full_day | 16 | 2 | 48 | 2 | 3 | 0 | 4 | 27 | 48 | 75 | 16 | 2 | 48 | 2 | 3 | 0 | 4 | 27 | 48 | 75 | ||||||||||||||||||||||||||||||||||
1932054 | 1932054 | CO | school | 806540 | 123 | SHERIDAN 2 | 80654001132 | 3054 | ALICE TERRY ELEMENTARY SCHOOL | Regular School | No | Elementary | KG | 02 | 2019 | pk_12_total | 34 | 6 | 166 | 4 | 5 | 0 | 10 | 107 | 118 | 225 | 34 | 6 | 166 | 4 | 5 | 0 | 10 | 107 | 118 | 225 | ||||||||||||||||||||||||||||||||||
1936428 | 1936428 | CO | school | 803450 | 900 | DOUGLAS COUNTY RE 1 | 80345006152 | 6152 | MOUNTAIN VIEW ELEMENTARY SCHOOL | Regular School | No | Elementary | PK | 02 | 2019 | grade_1 | 61 | 0 | 14 | 1 | 1 | 0 | 3 | 49 | 31 | 80 | 61 | 0 | 14 | 1 | 1 | 0 | 3 | 49 | 31 | 80 | ||||||||||||||||||||||||||||||||||
1936429 | 1936429 | CO | school | 803450 | 900 | DOUGLAS COUNTY RE 1 | 80345006152 | 6152 | MOUNTAIN VIEW ELEMENTARY SCHOOL | Regular School | No | Elementary | PK | 02 | 2019 | grade_2 | 73 | 0 | 8 | 3 | 4 | 0 | 5 | 48 | 45 | 93 | 73 | 0 | 8 | 3 | 4 | 0 | 5 | 48 | 45 | 93 | ||||||||||||||||||||||||||||||||||
1936430 | 1936430 | CO | school | 803450 | 900 | DOUGLAS COUNTY RE 1 | 80345006152 | 6152 | MOUNTAIN VIEW ELEMENTARY SCHOOL | Regular School | No | Elementary | PK | 02 | 2019 | kindergarten_full_day | 38 | 0 | 4 | 0 | 0 | 0 | 5 | 24 | 23 | 47 | 38 | 0 | 4 | 0 | 0 | 0 | 5 | 24 | 23 | 47 | ||||||||||||||||||||||||||||||||||
1936431 | 1936431 | CO | school | 803450 | 900 | DOUGLAS COUNTY RE 1 | 80345006152 | 6152 | MOUNTAIN VIEW ELEMENTARY SCHOOL | Regular School | No | Elementary | PK | 02 | 2019 | kindergarten_half_day | 31 | 0 | 5 | 0 | 0 | 0 | 2 | 20 | 18 | 38 | 31 | 0 | 5 | 0 | 0 | 0 | 2 | 20 | 18 | 38 | ||||||||||||||||||||||||||||||||||
1936432 | 1936432 | CO | school | 803450 | 900 | DOUGLAS COUNTY RE 1 | 80345006152 | 6152 | MOUNTAIN VIEW ELEMENTARY SCHOOL | Regular School | No | Elementary | PK | 02 | 2019 | pk_12_total | 253 | 0 | 38 | 4 | 6 | 0 | 17 | 172 | 146 | 318 | 253 | 0 | 38 | 4 | 6 | 0 | 17 | 172 | 146 | 318 | ||||||||||||||||||||||||||||||||||
1936433 | 1936433 | CO | school | 803450 | 900 | DOUGLAS COUNTY RE 1 | 80345006152 | 6152 | MOUNTAIN VIEW ELEMENTARY SCHOOL | Regular School | No | Elementary | PK | 02 | 2019 | pre_kindergarten | 50 | 0 | 7 | 0 | 1 | 0 | 2 | 31 | 29 | 60 | 50 | 0 | 7 | 0 | 1 | 0 | 2 | 31 | 29 | 60 | ||||||||||||||||||||||||||||||||||
1936528 | 1936528 | CO | school | 803450 | 900 | DOUGLAS COUNTY RE 1 | 80345000445 | 7096 | ROXBOROUGH ELEMENTARY SCHOOL | Regular School | No | Elementary | PK | 02 | 2019 | grade_1 | 88 | 0 | 12 | 0 | 2 | 0 | 4 | 54 | 52 | 106 | 88 | 0 | 12 | 0 | 2 | 0 | 4 | 54 | 52 | 106 | ||||||||||||||||||||||||||||||||||
1936529 | 1936529 | CO | school | 803450 | 900 | DOUGLAS COUNTY RE 1 | 80345000445 | 7096 | ROXBOROUGH ELEMENTARY SCHOOL | Regular School | No | Elementary | PK | 02 | 2019 | grade_2 | 74 | 0 | 18 | 0 | 2 | 0 | 4 | 49 | 49 | 98 | 74 | 0 | 18 | 0 | 2 | 0 | 4 | 49 | 49 | 98 | ||||||||||||||||||||||||||||||||||
1936530 | 1936530 | CO | school | 803450 | 900 | DOUGLAS COUNTY RE 1 | 80345000445 | 7096 | ROXBOROUGH ELEMENTARY SCHOOL | Regular School | No | Elementary | PK | 02 | 2019 | kindergarten_full_day | 46 | 0 | 10 | 0 | 1 | 0 | 5 | 31 | 31 | 62 | 46 | 0 | 10 | 0 | 1 | 0 | 5 | 31 | 31 | 62 | ||||||||||||||||||||||||||||||||||
1936531 | 1936531 | CO | school | 803450 | 900 | DOUGLAS COUNTY RE 1 | 80345000445 | 7096 | ROXBOROUGH ELEMENTARY SCHOOL | Regular School | No | Elementary | PK | 02 | 2019 | kindergarten_half_day | 21 | 0 | 6 | 0 | 0 | 0 | 3 | 15 | 15 | 30 | 21 | 0 | 6 | 0 | 0 | 0 | 3 | 15 | 15 | 30 | ||||||||||||||||||||||||||||||||||
1936532 | 1936532 | CO | school | 803450 | 900 | DOUGLAS COUNTY RE 1 | 80345000445 | 7096 | ROXBOROUGH ELEMENTARY SCHOOL | Regular School | No | Elementary | PK | 02 | 2019 | pk_12_total | 282 | 1 | 53 | 0 | 5 | 0 | 24 | 190 | 175 | 365 | 282 | 1 | 53 | 0 | 5 | 0 | 24 | 190 | 175 | 365 | ||||||||||||||||||||||||||||||||||
1936533 | 1936533 | CO | school | 803450 | 900 | DOUGLAS COUNTY RE 1 | 80345000445 | 7096 | ROXBOROUGH ELEMENTARY SCHOOL | Regular School | No | Elementary | PK | 02 | 2019 | pre_kindergarten | 53 | 1 | 7 | 0 | 0 | 0 | 8 | 41 | 28 | 69 | 53 | 1 | 7 | 0 | 0 | 0 | 8 | 41 | 28 | 69 | ||||||||||||||||||||||||||||||||||
1938943 | 1938943 | CO | school | 804800 | 1420 | JEFFERSON COUNTY R-1 | 80480000701 | 776 | BERGEN MEADOW PRIMARY SCHOOL | Regular School | No | Elementary | PK | 02 | 2019 | grade_1 | 66 | 0 | 2 | 0 | 1 | 0 | 5 | 42 | 32 | 74 | 66 | 0 | 2 | 0 | 1 | 0 | 5 | 42 | 32 | 74 | ||||||||||||||||||||||||||||||||||
1938944 | 1938944 | CO | school | 804800 | 1420 | JEFFERSON COUNTY R-1 | 80480000701 | 776 | BERGEN MEADOW PRIMARY SCHOOL | Regular School | No | Elementary | PK | 02 | 2019 | grade_2 | 71 | 0 | 4 | 0 | 0 | 0 | 4 | 39 | 40 | 79 | 71 | 0 | 4 | 0 | 0 | 0 | 4 | 39 | 40 | 79 | ||||||||||||||||||||||||||||||||||
1938945 | 1938945 | CO | school | 804800 | 1420 | JEFFERSON COUNTY R-1 | 80480000701 | 776 | BERGEN MEADOW PRIMARY SCHOOL | Regular School | No | Elementary | PK | 02 | 2019 | kindergarten_full_day | 72 | 0 | 5 | 0 | 2 | 0 | 1 | 39 | 41 | 80 | 72 | 0 | 5 | 0 | 2 | 0 | 1 | 39 | 41 | 80 | ||||||||||||||||||||||||||||||||||
1938946 | 1938946 | CO | school | 804800 | 1420 | JEFFERSON COUNTY R-1 | 80480000701 | 776 | BERGEN MEADOW PRIMARY SCHOOL | Regular School | No | Elementary | PK | 02 | 2019 | kindergarten_half_day | 5 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 1 | 5 | 5 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 1 | 5 | ||||||||||||||||||||||||||||||||||
1938947 | 1938947 | CO | school | 804800 | 1420 | JEFFERSON COUNTY R-1 | 80480000701 | 776 | BERGEN MEADOW PRIMARY SCHOOL | Regular School | No | Elementary | PK | 02 | 2019 | pk_12_total | 292 | 0 | 13 | 0 | 4 | 0 | 17 | 163 | 163 | 326 | 292 | 0 | 13 | 0 | 4 | 0 | 17 | 163 | 163 | 326 | ||||||||||||||||||||||||||||||||||
1938948 | 1938948 | CO | school | 804800 | 1420 | JEFFERSON COUNTY R-1 | 80480000701 | 776 | BERGEN MEADOW PRIMARY SCHOOL | Regular School | No | Elementary | PK | 02 | 2019 | pre_kindergarten | 78 | 0 | 2 | 0 | 1 | 0 | 7 | 39 | 49 | 88 | 78 | 0 | 2 | 0 | 1 | 0 | 7 | 39 | 49 | 88 | ||||||||||||||||||||||||||||||||||
1940238 | 1940238 | CO | school | 805190 | 1510 | LAKE COUNTY R-1 | 80519000859 | 9486 | WESTPARK ELEMENTARY SCHOOL | Regular School | No | Elementary | KG | 02 | 2019 | grade_1 | 24 | 0 | 34 | 0 | 0 | 0 | 0 | 31 | 27 | 58 | 24 | 0 | 34 | 0 | 0 | 0 | 0 | 31 | 27 | 58 | ||||||||||||||||||||||||||||||||||
1940239 | 1940239 | CO | school | 805190 | 1510 | LAKE COUNTY R-1 | 80519000859 | 9486 | WESTPARK ELEMENTARY SCHOOL | Regular School | No | Elementary | KG | 02 | 2019 | grade_2 | 27 | 1 | 37 | 0 | 0 | 0 | 3 | 41 | 27 | 68 | 27 | 1 | 37 | 0 | 0 | 0 | 3 | 41 | 27 | 68 | ||||||||||||||||||||||||||||||||||
1940240 | 1940240 | CO | school | 805190 | 1510 | LAKE COUNTY R-1 | 80519000859 | 9486 | WESTPARK ELEMENTARY SCHOOL | Regular School | No | Elementary | KG | 02 | 2019 | kindergarten_full_day | 29 | 0 | 46 | 0 | 0 | 0 | 0 | 35 | 40 | 75 | 29 | 0 | 46 | 0 | 0 | 0 | 0 | 35 | 40 | 75 | ||||||||||||||||||||||||||||||||||
1940241 | 1940241 | CO | school | 805190 | 1510 | LAKE COUNTY R-1 | 80519000859 | 9486 | WESTPARK ELEMENTARY SCHOOL | Regular School | No | Elementary | KG | 02 | 2019 | pk_12_total | 80 | 1 | 117 | 0 | 0 | 0 | 3 | 107 | 94 | 201 | 80 | 1 | 117 | 0 | 0 | 0 | 3 | 107 | 94 | 201 | ||||||||||||||||||||||||||||||||||
1940363 | 1940363 | CO | school | 802400 | 1530 | BAYFIELD 10 JT-R | 80240006747 | 642 | BAYFIELD PRIMARY SCHOOL | Regular School | No | Elementary | PK | 02 | 2019 | grade_1 | 85 | 0 | 18 | 3 | 0 | 0 | 4 | 51 | 59 | 110 | 85 | 0 | 18 | 3 | 0 | 0 | 4 | 51 | 59 | 110 | ||||||||||||||||||||||||||||||||||
1940364 | 1940364 | CO | school | 802400 | 1530 | BAYFIELD 10 JT-R | 80240006747 | 642 | BAYFIELD PRIMARY SCHOOL | Regular School | No | Elementary | PK | 02 | 2019 | grade_2 | 79 | 0 | 16 | 3 | 1 | 0 | 8 | 64 | 43 | 107 | 79 | 0 | 16 | 3 | 1 | 0 | 8 | 64 | 43 | 107 | ||||||||||||||||||||||||||||||||||
1940365 | 1940365 | CO | school | 802400 | 1530 | BAYFIELD 10 JT-R | 80240006747 | 642 | BAYFIELD PRIMARY SCHOOL | Regular School | No | Elementary | PK | 02 | 2019 | kindergarten_full_day | 83 | 0 | 19 | 2 | 0 | 0 | 3 | 57 | 50 | 107 | 83 | 0 | 19 | 2 | 0 | 0 | 3 | 57 | 50 | 107 | ||||||||||||||||||||||||||||||||||
1940366 | 1940366 | CO | school | 802400 | 1530 | BAYFIELD 10 JT-R | 80240006747 | 642 | BAYFIELD PRIMARY SCHOOL | Regular School | No | Elementary | PK | 02 | 2019 | pk_12_total | 247 | 0 | 53 | 8 | 1 | 0 | 15 | 172 | 152 | 324 | 247 | 0 | 53 | 8 | 1 | 0 | 15 | 172 | 152 | 324 | ||||||||||||||||||||||||||||||||||
1941234 | 1941234 | CO | school | 806690 | 1828 | VALLEY RE-1 | 80669006339 | 515 | AYRES ELEMENTARY SCHOOL | Regular School | No | Elementary | KG | 02 | 2019 | grade_1 | 96 | 5 | 35 | 2 | 2 | 0 | 4 | 86 | 58 | 144 | 96 | 5 | 35 | 2 | 2 | 0 | 4 | 86 | 58 | 144 | ||||||||||||||||||||||||||||||||||
1941235 | 1941235 | CO | school | 806690 | 1828 | VALLEY RE-1 | 80669006339 | 515 | AYRES ELEMENTARY SCHOOL | Regular School | No | Elementary | KG | 02 | 2019 | grade_2 | 85 | 2 | 53 | 1 | 0 | 0 | 3 | 79 | 65 | 144 | 85 | 2 | 53 | 1 | 0 | 0 | 3 | 79 | 65 | 144 | ||||||||||||||||||||||||||||||||||
1941236 | 1941236 | CO | school | 806690 | 1828 | VALLEY RE-1 | 80669006339 | 515 | AYRES ELEMENTARY SCHOOL | Regular School | No | Elementary | KG | 02 | 2019 | kindergarten_full_day | 108 | 5 | 46 | 1 | 0 | 0 | 4 | 78 | 86 | 164 | 108 | 5 | 46 | 1 | 0 | 0 | 4 | 78 | 86 | 164 | ||||||||||||||||||||||||||||||||||
1941237 | 1941237 | CO | school | 806690 | 1828 | VALLEY RE-1 | 80669006339 | 515 | AYRES ELEMENTARY SCHOOL | Regular School | No | Elementary | KG | 02 | 2019 | pk_12_total | 289 | 12 | 134 | 4 | 2 | 0 | 11 | 243 | 209 | 452 | 289 | 12 | 134 | 4 | 2 | 0 | 11 | 243 | 209 | 452 | ||||||||||||||||||||||||||||||||||
1941972 | 1941972 | CO | school | 802610 | 2395 | BRUSH RE-2(J) | 80261000156 | 8832 | THOMSON PRIMARY SCHOOL | Regular School | No | Elementary | PK | 02 | 2019 | grade_1 | 47 | 1 | 46 | 0 | 0 | 0 | 0 | 51 | 43 | 94 | 47 | 1 | 46 | 0 | 0 | 0 | 0 | 51 | 43 | 94 | ||||||||||||||||||||||||||||||||||
1941973 | 1941973 | CO | school | 802610 | 2395 | BRUSH RE-2(J) | 80261000156 | 8832 | THOMSON PRIMARY SCHOOL | Regular School | No | Elementary | PK | 02 | 2019 | grade_2 | 61 | 0 | 59 | 0 | 0 | 0 | 0 | 62 | 58 | 120 | 61 | 0 | 59 | 0 | 0 | 0 | 0 | 62 | 58 | 120 | ||||||||||||||||||||||||||||||||||
1941974 | 1941974 | CO | school | 802610 | 2395 | BRUSH RE-2(J) | 80261000156 | 8832 | THOMSON PRIMARY SCHOOL | Regular School | No | Elementary | PK | 02 | 2019 | kindergarten_full_day | 59 | 0 | 50 | 1 | 0 | 0 | 0 | 56 | 54 | 110 | 59 | 0 | 50 | 1 | 0 | 0 | 0 | 56 | 54 | 110 | ||||||||||||||||||||||||||||||||||
1941975 | 1941975 | CO | school | 802610 | 2395 | BRUSH RE-2(J) | 80261000156 | 8832 | THOMSON PRIMARY SCHOOL | Regular School | No | Elementary | PK | 02 | 2019 | pk_12_total | 208 | 1 | 192 | 1 | 1 | 0 | 0 | 210 | 193 | 403 | 208 | 1 | 192 | 1 | 1 | 0 | 0 | 210 | 193 | 403 | ||||||||||||||||||||||||||||||||||
1941976 | 1941976 | CO | school | 802610 | 2395 | BRUSH RE-2(J) | 80261000156 | 8832 | THOMSON PRIMARY SCHOOL | Regular School | No | Elementary | PK | 02 | 2019 | pre_kindergarten | 41 | 0 | 37 | 0 | 1 | 0 | 0 | 41 | 38 | 79 | 41 | 0 | 37 | 0 | 1 | 0 | 0 | 41 | 38 | 79 | ||||||||||||||||||||||||||||||||||
1942056 | 1942056 | CO | school | 805130 | 2520 | EAST OTERO R-1 | 80513001975 | 4843 | LA JUNTA PRIMARY SCHOOL | Regular School | No | Elementary | KG | 02 | 2019 | grade_1 | 30 | 0 | 73 | 0 | 1 | 1 | 0 | 47 | 58 | 105 | 30 | 0 | 73 | 0 | 1 | 1 | 0 | 47 | 58 | 105 | ||||||||||||||||||||||||||||||||||
1942057 | 1942057 | CO | school | 805130 | 2520 | EAST OTERO R-1 | 80513001975 | 4843 | LA JUNTA PRIMARY SCHOOL | Regular School | No | Elementary | KG | 02 | 2019 | grade_2 | 35 | 1 | 81 | 1 | 1 | 1 | 0 | 52 | 68 | 120 | 35 | 1 | 81 | 1 | 1 | 1 | 0 | 52 | 68 | 120 | ||||||||||||||||||||||||||||||||||
1942058 | 1942058 | CO | school | 805130 | 2520 | EAST OTERO R-1 | 80513001975 | 4843 | LA JUNTA PRIMARY SCHOOL | Regular School | No | Elementary | KG | 02 | 2019 | kindergarten_full_day | 31 | 0 | 69 | 1 | 2 | 1 | 1 | 56 | 49 | 105 | 31 | 0 | 69 | 1 | 2 | 1 | 1 | 56 | 49 | 105 | ||||||||||||||||||||||||||||||||||
1942059 | 1942059 | CO | school | 805130 | 2520 | EAST OTERO R-1 | 80513001975 | 4843 | LA JUNTA PRIMARY SCHOOL | Regular School | No | Elementary | KG | 02 | 2019 | pk_12_total | 96 | 1 | 223 | 2 | 4 | 3 | 1 | 155 | 175 | 330 | 96 | 1 | 223 | 2 | 4 | 3 | 1 | 155 | 175 | 330 | ||||||||||||||||||||||||||||||||||
1942079 | 1942079 | CO | school | 806270 | 2530 | ROCKY FORD R-2 | 80627001104 | 9264 | WASHINGTON PRIMARY SCHOOL | Regular School | No | Elementary | PK | 02 | 2019 | grade_1 | 15 | 0 | 57 | 1 | 0 | 0 | 0 | 41 | 32 | 73 | 15 | 0 | 57 | 1 | 0 | 0 | 0 | 41 | 32 | 73 | ||||||||||||||||||||||||||||||||||
1942080 | 1942080 | CO | school | 806270 | 2530 | ROCKY FORD R-2 | 80627001104 | 9264 | WASHINGTON PRIMARY SCHOOL | Regular School | No | Elementary | PK | 02 | 2019 | grade_2 | 3 | 1 | 63 | 0 | 0 | 0 | 1 | 24 | 44 | 68 | 3 | 1 | 63 | 0 | 0 | 0 | 1 | 24 | 44 | 68 | ||||||||||||||||||||||||||||||||||
1942081 | 1942081 | CO | school | 806270 | 2530 | ROCKY FORD R-2 | 80627001104 | 9264 | WASHINGTON PRIMARY SCHOOL | Regular School | No | Elementary | PK | 02 | 2019 | kindergarten_full_day | 33 | 0 | 20 | 1 | 0 | 0 | 0 | 28 | 26 | 54 | 33 | 0 | 20 | 1 | 0 | 0 | 0 | 28 | 26 | 54 | ||||||||||||||||||||||||||||||||||
1942082 | 1942082 | CO | school | 806270 | 2530 | ROCKY FORD R-2 | 80627001104 | 9264 | WASHINGTON PRIMARY SCHOOL | Regular School | No | Elementary | PK | 02 | 2019 | pk_12_total | 51 | 1 | 140 | 2 | 0 | 0 | 1 | 93 | 102 | 195 | 51 | 1 | 140 | 2 | 0 | 0 | 1 | 93 | 102 | 195 | ||||||||||||||||||||||||||||||||||
1942340 | 1942340 | CO | school | 805220 | 2660 | LAMAR RE-2 | 80522000865 | 9268 | WASHINGTON ELEMENTARY SCHOOL | Regular School | No | Elementary | KG | 02 | 2019 | grade_1 | 37 | 2 | 70 | 0 | 1 | 0 | 5 | 68 | 47 | 115 | 37 | 2 | 70 | 0 | 1 | 0 | 5 | 68 | 47 | 115 | ||||||||||||||||||||||||||||||||||
1942341 | 1942341 | CO | school | 805220 | 2660 | LAMAR RE-2 | 80522000865 | 9268 | WASHINGTON ELEMENTARY SCHOOL | Regular School | No | Elementary | KG | 02 | 2019 | grade_2 | 22 | 0 | 48 | 0 | 0 | 0 | 0 | 38 | 32 | 70 | 22 | 0 | 48 | 0 | 0 | 0 | 0 | 38 | 32 | 70 |
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]);