enrollments
Data source: Big Local News · About: Big Local
7,616 rows where grade = "grade_4" and state = "CO" sorted by ccd_school_lvl
This data as json, CSV (advanced)
Link | rowid | state | county | county_state_id | admin_level | district_nces_id | district_state_id | district_state_type | district | school_nces_id | school_state_id | school | school_state_type | ccd_school_type | ccd_charter_school | ccd_school_lvl ▼ | ccd_school_low_grade | ccd_school_high_grade | year | term | grade | white | black | hispanic | native_american | native_american_alaskan_native | asian | native_hawaiian | asian_pacific_islander | native_hawaiian_pacific_islander | pacific_islander | multiracial | unknown_race | male | female | non_binary | unknown_gender | ell | ell_percent | homeless | homeless_percent | low_income | free_and_reduced | free_and_reduced_percent | disability | section_504 | total | white_int | black_int | hispanic_int | native_american_int | native_american_alaskan_native_int | asian_int | native_hawaiian_int | asian_pacific_islander_int | native_hawaiian_pacific_islander_int | pacific_islander_int | multiracial_int | unknown_race_int | male_int | female_int | non_binary_int | unknown_gender_int | ell_int | homeless_int | low_income_int | free_and_reduced_int | disability_int | section_504_int | total_int |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
845606 | 845606 | CO | school | 2000 | MESA COUNTY VALLEY 51 | 262 | APPLETON ELEMENTARY SCHOOL | 2016 | grade_4 | 54 | 1 | 13 | 1 | 2 | 1 | 0 | 32 | 40 | 72 | 54 | 1 | 13 | 1 | 2 | 1 | 0 | 32 | 40 | 72 | |||||||||||||||||||||||||||||||||||||||||
845618 | 845618 | CO | school | 2000 | MESA COUNTY VALLEY 51 | 362 | RIM ROCK ELEMENTARY SCHOOL | 2016 | grade_4 | 83 | 1 | 17 | 0 | 0 | 0 | 3 | 55 | 49 | 104 | 83 | 1 | 17 | 0 | 0 | 0 | 3 | 55 | 49 | 104 | |||||||||||||||||||||||||||||||||||||||||
845627 | 845627 | CO | school | 2000 | MESA COUNTY VALLEY 51 | 363 | PEAR PARK ELEMENTARY SCHOOL | 2016 | grade_4 | 51 | 0 | 20 | 1 | 0 | 0 | 9 | 45 | 36 | 81 | 51 | 0 | 20 | 1 | 0 | 0 | 9 | 45 | 36 | 81 | |||||||||||||||||||||||||||||||||||||||||
845998 | 845998 | CO | school | 2035 | MONTEZUMA-CORTEZ RE-1 | 609 | BATTLE ROCK CHARTER SCHOOL | 2016 | grade_4 | 0 | 0 | 2 | 0 | 0 | 1 | 0 | 1 | 2 | 3 | 0 | 0 | 2 | 0 | 0 | 1 | 0 | 1 | 2 | 3 | |||||||||||||||||||||||||||||||||||||||||
846363 | 846363 | CO | school | 2540 | FOWLER R-4J | 56 | FOWLER ELEMENTARY SCHOOL | 2016 | grade_4 | 26 | 0 | 2 | 0 | 0 | 0 | 0 | 16 | 12 | 28 | 26 | 0 | 2 | 0 | 0 | 0 | 0 | 16 | 12 | 28 | |||||||||||||||||||||||||||||||||||||||||
846535 | 846535 | CO | school | 2640 | ASPEN 1 | 42 | ASPEN COMMUNITY CHARTER SCHOOL | 2016 | grade_4 | 15 | 0 | 0 | 0 | 0 | 0 | 0 | 8 | 7 | 15 | 15 | 0 | 0 | 0 | 0 | 0 | 0 | 8 | 7 | 15 | |||||||||||||||||||||||||||||||||||||||||
846545 | 846545 | CO | school | 2640 | ASPEN 1 | 428 | ASPEN ELEMENTARY SCHOOL | 2016 | grade_4 | 88 | 2 | 11 | 0 | 2 | 0 | 1 | 47 | 57 | 104 | 88 | 2 | 11 | 0 | 2 | 0 | 1 | 47 | 57 | 104 | |||||||||||||||||||||||||||||||||||||||||
846579 | 846579 | CO | school | 2660 | LAMAR RE-2 | 200 | ALTA VISTA CHARTER SCHOOL | 2016 | grade_4 | 16 | 0 | 3 | 0 | 0 | 0 | 0 | 10 | 9 | 19 | 16 | 0 | 3 | 0 | 0 | 0 | 0 | 10 | 9 | 19 | |||||||||||||||||||||||||||||||||||||||||
846639 | 846639 | CO | school | 2690 | PUEBLO CITY 60 | 738 | BELMONT ELEMENTARY SCHOOL | 2016 | grade_4 | 15 | 3 | 44 | 1 | 0 | 0 | 2 | 34 | 31 | 65 | 15 | 3 | 44 | 1 | 0 | 0 | 2 | 34 | 31 | 65 | |||||||||||||||||||||||||||||||||||||||||
846647 | 846647 | CO | school | 2690 | PUEBLO CITY 60 | 756 | BENJAMIN FRANKLIN ELEMENTARY SCHOOL | 2016 | grade_4 | 9 | 0 | 42 | 0 | 1 | 0 | 0 | 30 | 22 | 52 | 9 | 0 | 42 | 0 | 1 | 0 | 0 | 30 | 22 | 52 | |||||||||||||||||||||||||||||||||||||||||
846655 | 846655 | CO | school | 2690 | PUEBLO CITY 60 | 822 | BESSEMER ELEMENTARY SCHOOL | 2016 | grade_4 | 10 | 2 | 33 | 1 | 0 | 0 | 0 | 24 | 22 | 46 | 10 | 2 | 33 | 1 | 0 | 0 | 0 | 24 | 22 | 46 | |||||||||||||||||||||||||||||||||||||||||
846666 | 846666 | CO | school | 2690 | PUEBLO CITY 60 | 860 | BEULAH HEIGHTS ELEMENTARY SCHOOL | 2016 | grade_4 | 10 | 4 | 40 | 0 | 0 | 0 | 1 | 24 | 31 | 55 | 10 | 4 | 40 | 0 | 0 | 0 | 1 | 24 | 31 | 55 | |||||||||||||||||||||||||||||||||||||||||
846674 | 846674 | CO | school | 2690 | PUEBLO CITY 60 | 954 | BRADFORD ELEMENTARY SCHOOL | 2016 | grade_4 | 5 | 0 | 36 | 0 | 0 | 0 | 0 | 18 | 23 | 41 | 5 | 0 | 36 | 0 | 0 | 0 | 0 | 18 | 23 | 41 | |||||||||||||||||||||||||||||||||||||||||
846883 | 846883 | CO | school | 2700 | PUEBLO COUNTY 70 | 26 | DESERT SAGE ELEMENTARY SCHOOL | 2016 | grade_4 | 28 | 0 | 23 | 0 | 2 | 0 | 2 | 38 | 17 | 55 | 28 | 0 | 23 | 0 | 2 | 0 | 2 | 38 | 17 | 55 | |||||||||||||||||||||||||||||||||||||||||
846891 | 846891 | CO | school | 2700 | PUEBLO COUNTY 70 | 472 | AVONDALE ELEMENTARY SCHOOL | 2016 | grade_4 | 11 | 0 | 26 | 0 | 0 | 0 | 0 | 19 | 18 | 37 | 11 | 0 | 26 | 0 | 0 | 0 | 0 | 19 | 18 | 37 | |||||||||||||||||||||||||||||||||||||||||
846899 | 846899 | CO | school | 2700 | PUEBLO COUNTY 70 | 852 | BEULAH ELEMENTARY SCHOOL | 2016 | grade_4 | 18 | 0 | 5 | 0 | 0 | 0 | 0 | 12 | 11 | 23 | 18 | 0 | 5 | 0 | 0 | 0 | 0 | 12 | 11 | 23 | |||||||||||||||||||||||||||||||||||||||||
847481 | 847481 | CO | school | 3030 | AKRON R-1 | 86 | AKRON ELEMENTARY SCHOOL | 2016 | grade_4 | 19 | 0 | 4 | 0 | 0 | 0 | 1 | 9 | 15 | 24 | 19 | 0 | 4 | 0 | 0 | 0 | 1 | 9 | 15 | 24 | |||||||||||||||||||||||||||||||||||||||||
847497 | 847497 | CO | school | 3040 | ARICKAREE R-2 | 304 | ARICKAREE ELEMENTARY SCHOOL | 2016 | grade_4 | 7 | 0 | 4 | 0 | 0 | 0 | 0 | 4 | 7 | 11 | 7 | 0 | 4 | 0 | 0 | 0 | 0 | 4 | 7 | 11 | |||||||||||||||||||||||||||||||||||||||||
847596 | 847596 | CO | school | 3085 | EATON RE-2 | 754 | BENJAMIN EATON ELEMENTARY SCHOOL | 2016 | grade_4 | 89 | 0 | 28 | 0 | 0 | 0 | 4 | 66 | 55 | 121 | 89 | 0 | 28 | 0 | 0 | 0 | 4 | 66 | 55 | 121 | |||||||||||||||||||||||||||||||||||||||||
847668 | 847668 | CO | school | 3100 | WINDSOR RE-4 | 55 | GRANDVIEW ELEMENTARY SCHOOL | 2016 | grade_4 | 64 | 0 | 4 | 0 | 0 | 0 | 1 | 37 | 32 | 69 | 64 | 0 | 4 | 0 | 0 | 0 | 1 | 37 | 32 | 69 | |||||||||||||||||||||||||||||||||||||||||
847777 | 847777 | CO | school | 3120 | GREELEY 6 | 52 | HEIMAN ELEMENTARY SCHOOL | 2016 | grade_4 | 57 | 1 | 56 | 1 | 1 | 0 | 4 | 59 | 61 | 120 | 57 | 1 | 56 | 1 | 1 | 0 | 4 | 59 | 61 | 120 | |||||||||||||||||||||||||||||||||||||||||
847785 | 847785 | CO | school | 3120 | GREELEY 6 | 53 | WINOGRAD K-8 ELEMENTARY SCHOOL | 2016 | grade_4 | 23 | 0 | 55 | 0 | 2 | 0 | 0 | 43 | 37 | 80 | 23 | 0 | 55 | 0 | 2 | 0 | 0 | 43 | 37 | 80 | |||||||||||||||||||||||||||||||||||||||||
847796 | 847796 | CO | school | 3120 | GREELEY 6 | 54 | BELLA ROMERO ACADEMY OF APPLIED TECHNOLOGY | 2016 | grade_4 | 14 | 5 | 115 | 0 | 1 | 0 | 0 | 69 | 66 | 135 | 14 | 5 | 115 | 0 | 1 | 0 | 0 | 69 | 66 | 135 | |||||||||||||||||||||||||||||||||||||||||
848194 | 848194 | CO | school | 8001 | CHARTER SCHOOL INSTITUTE | 15 | ACADEMY OF CHARTER SCHOOLS | 2016 | grade_4 | 93 | 2 | 35 | 1 | 9 | 0 | 6 | 68 | 78 | 146 | 93 | 2 | 35 | 1 | 9 | 0 | 6 | 68 | 78 | 146 | |||||||||||||||||||||||||||||||||||||||||
848206 | 848206 | CO | school | 8001 | CHARTER SCHOOL INSTITUTE | 35 | FRONTIER CHARTER ACADEMY | 2016 | grade_4 | 3 | 0 | 2 | 0 | 0 | 0 | 0 | 2 | 3 | 5 | 3 | 0 | 2 | 0 | 0 | 0 | 0 | 2 | 3 | 5 | |||||||||||||||||||||||||||||||||||||||||
848221 | 848221 | CO | school | 8001 | CHARTER SCHOOL INSTITUTE | 653 | STONE CREEK SCHOOL | 2016 | grade_4 | 25 | 0 | 6 | 0 | 0 | 0 | 2 | 22 | 11 | 33 | 25 | 0 | 6 | 0 | 0 | 0 | 2 | 22 | 11 | 33 | |||||||||||||||||||||||||||||||||||||||||
848232 | 848232 | CO | school | 8001 | CHARTER SCHOOL INSTITUTE | 654 | THE PINNACLE CHARTER SCHOOL ELEMENTARY | 2016 | grade_4 | 39 | 0 | 124 | 0 | 6 | 0 | 0 | 85 | 84 | 169 | 39 | 0 | 124 | 0 | 6 | 0 | 0 | 85 | 84 | 169 | |||||||||||||||||||||||||||||||||||||||||
848239 | 848239 | CO | school | 8001 | CHARTER SCHOOL INSTITUTE | 655 | HIGH POINT ACADEMY | 2016 | grade_4 | 16 | 23 | 27 | 1 | 3 | 1 | 7 | 37 | 41 | 78 | 16 | 23 | 27 | 1 | 3 | 1 | 7 | 37 | 41 | 78 | |||||||||||||||||||||||||||||||||||||||||
848250 | 848250 | CO | school | 8001 | CHARTER SCHOOL INSTITUTE | 657 | T.R. PAUL ACADEMY OF ARTS & KNOWLEDGE | 2016 | grade_4 | 27 | 0 | 6 | 2 | 1 | 0 | 1 | 22 | 15 | 37 | 27 | 0 | 6 | 2 | 1 | 0 | 1 | 22 | 15 | 37 | |||||||||||||||||||||||||||||||||||||||||
1134849 | 1134849 | CO | school | 180 | ADAMS-ARAPAHOE 28J | 1 | FACILITIES WITH DISTRICT RUN EDUCATION | 2015 | grade_4 | 0.0 | 0.0 | 1.0 | 0.0 | 0.0 | 0.0 | 0.0 | 1.0 | 0.0 | 1.0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | |||||||||||||||||||||||||||||||||||||||||
1739972 | 1739972 | CO | school | 180 | Adams-Arapahoe 28J | 1 | Facilities with District Run Education | 2021 | grade_4 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 1 | 1 | |||||||||||||||||||||||||||||||||||||||||
1895379 | 1895379 | CO | school | 180 | ADAMS-ARAPAHOE 28J | 1 | FACILITIES WITH DISTRICT RUN EDUCATION | 2018 | grade_4 | 1 | 0 | 1 | 0 | 0 | 0 | 0 | 2 | 0 | 2 | 1 | 0 | 1 | 0 | 0 | 0 | 0 | 2 | 0 | 2 | |||||||||||||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||||||||||||
835624 | 835624 | CO | school | 805550 | 10 | MAPLETON 1 | 80555000959 | 9036 | VALLEY VIEW K-8 | Regular School | No | 1.0 | KG | 08 | 2016 | grade_4 | 4 | 0 | 44 | 1 | 0 | 0 | 1 | 28 | 22 | 50 | 4 | 0 | 44 | 1 | 0 | 0 | 1 | 28 | 22 | 50 | ||||||||||||||||||||||||||||||||||
835674 | 835674 | CO | school | 806900 | 20 | ADAMS 12 FIVE STAR SCHOOLS | 80690001173 | 1388 | CENTENNIAL ELEMENTARY SCHOOL | Regular School | No | 1.0 | PK | 05 | 2016 | grade_4 | 32 | 1 | 36 | 0 | 3 | 0 | 0 | 38 | 34 | 72 | 32 | 1 | 36 | 0 | 3 | 0 | 0 | 38 | 34 | 72 | ||||||||||||||||||||||||||||||||||
835697 | 835697 | CO | school | 806900 | 20 | ADAMS 12 FIVE STAR SCHOOLS | 80690001174 | 1878 | CORONADO HILLS ELEMENTARY SCHOOL | Regular School | No | 1.0 | PK | 05 | 2016 | grade_4 | 11 | 1 | 70 | 0 | 0 | 0 | 1 | 46 | 37 | 83 | 11 | 1 | 70 | 0 | 0 | 0 | 1 | 46 | 37 | 83 | ||||||||||||||||||||||||||||||||||
835704 | 835704 | CO | school | 806900 | 20 | ADAMS 12 FIVE STAR SCHOOLS | 80690001305 | 1914 | COTTON CREEK ELEMENTARY SCHOOL | Regular School | No | 1.0 | KG | 05 | 2016 | grade_4 | 71 | 3 | 16 | 2 | 6 | 0 | 2 | 42 | 58 | 100 | 71 | 3 | 16 | 2 | 6 | 0 | 2 | 42 | 58 | 100 | ||||||||||||||||||||||||||||||||||
835712 | 835712 | CO | school | 806900 | 20 | ADAMS 12 FIVE STAR SCHOOLS | 80690001668 | 1937 | COYOTE RIDGE ELEMENTARY SCHOOL | Regular School | No | 1.0 | KG | 05 | 2016 | grade_4 | 74 | 0 | 7 | 0 | 6 | 0 | 7 | 50 | 44 | 94 | 74 | 0 | 7 | 0 | 6 | 0 | 7 | 50 | 44 | 94 | ||||||||||||||||||||||||||||||||||
835720 | 835720 | CO | school | 806900 | 20 | ADAMS 12 FIVE STAR SCHOOLS | 80690001622 | 2361 | EAGLEVIEW ELEMENTARY SCHOOL | Regular School | No | 1.0 | KG | 05 | 2016 | grade_4 | 65 | 1 | 29 | 1 | 7 | 0 | 8 | 58 | 53 | 111 | 65 | 1 | 29 | 1 | 7 | 0 | 8 | 58 | 53 | 111 | ||||||||||||||||||||||||||||||||||
835728 | 835728 | CO | school | 806900 | 20 | ADAMS 12 FIVE STAR SCHOOLS | 80690001175 | 2410 | TARVER ELEMENTARY SCHOOL | Regular School | No | 1.0 | PK | 05 | 2016 | grade_4 | 52 | 2 | 22 | 1 | 1 | 0 | 0 | 38 | 40 | 78 | 52 | 2 | 22 | 1 | 1 | 0 | 0 | 38 | 40 | 78 | ||||||||||||||||||||||||||||||||||
835736 | 835736 | CO | school | 806900 | 20 | ADAMS 12 FIVE STAR SCHOOLS | 80690001290 | 2576 | CHERRY DRIVE ELEMENTARY SCHOOL | Regular School | No | 1.0 | KG | 05 | 2016 | grade_4 | 53 | 0 | 17 | 0 | 5 | 1 | 2 | 41 | 37 | 78 | 53 | 0 | 17 | 0 | 5 | 1 | 2 | 41 | 37 | 78 | ||||||||||||||||||||||||||||||||||
835744 | 835744 | CO | school | 806900 | 20 | ADAMS 12 FIVE STAR SCHOOLS | 80690001401 | 2578 | SKYVIEW ELEMENTARY SCHOOL | Regular School | No | 1.0 | KG | 05 | 2016 | grade_4 | 40 | 0 | 32 | 1 | 1 | 0 | 1 | 45 | 30 | 75 | 40 | 0 | 32 | 1 | 1 | 0 | 1 | 45 | 30 | 75 | ||||||||||||||||||||||||||||||||||
835752 | 835752 | CO | school | 806900 | 20 | ADAMS 12 FIVE STAR SCHOOLS | 80690001419 | 2580 | HUNTERS GLEN ELEMENTARY SCHOOL | Regular School | No | 1.0 | KG | 05 | 2016 | grade_4 | 51 | 6 | 13 | 1 | 8 | 0 | 1 | 42 | 38 | 80 | 51 | 6 | 13 | 1 | 8 | 0 | 1 | 42 | 38 | 80 | ||||||||||||||||||||||||||||||||||
835760 | 835760 | CO | school | 806900 | 20 | ADAMS 12 FIVE STAR SCHOOLS | 80690001460 | 2582 | ROCKY MOUNTAIN ELEMENTARY SCHOOL | Regular School | No | 1.0 | KG | 05 | 2016 | grade_4 | 18 | 1 | 71 | 0 | 4 | 0 | 0 | 48 | 46 | 94 | 18 | 1 | 71 | 0 | 4 | 0 | 0 | 48 | 46 | 94 | ||||||||||||||||||||||||||||||||||
835767 | 835767 | CO | school | 806900 | 20 | ADAMS 12 FIVE STAR SCHOOLS | 80690001461 | 2584 | RIVERDALE ELEMENTARY SCHOOL | Regular School | No | 1.0 | PK | 05 | 2016 | grade_4 | 32 | 0 | 31 | 0 | 2 | 0 | 1 | 40 | 26 | 66 | 32 | 0 | 31 | 0 | 2 | 0 | 1 | 40 | 26 | 66 | ||||||||||||||||||||||||||||||||||
835774 | 835774 | CO | school | 806900 | 20 | ADAMS 12 FIVE STAR SCHOOLS | 80690001176 | 2918 | FEDERAL HEIGHTS ELEMENTARY SCHOOL | Regular School | No | 1.0 | KG | 05 | 2016 | grade_4 | 6 | 0 | 66 | 0 | 0 | 0 | 0 | 37 | 35 | 72 | 6 | 0 | 66 | 0 | 0 | 0 | 0 | 37 | 35 | 72 | ||||||||||||||||||||||||||||||||||
835781 | 835781 | CO | school | 806900 | 20 | ADAMS 12 FIVE STAR SCHOOLS | 80690006503 | 3439 | GLOBAL VILLAGE ACADEMY | Regular School | Yes | 1.0 | KG | 08 | 2016 | grade_4 | 42 | 2 | 48 | 0 | 8 | 0 | 4 | 47 | 57 | 104 | 42 | 2 | 48 | 0 | 8 | 0 | 4 | 47 | 57 | 104 | ||||||||||||||||||||||||||||||||||
835792 | 835792 | CO | school | 806900 | 20 | ADAMS 12 FIVE STAR SCHOOLS | 80690001177 | 4000 | HILLCREST ELEMENTARY SCHOOL | Regular School | No | 1.0 | KG | 05 | 2016 | grade_4 | 16 | 2 | 57 | 0 | 5 | 0 | 1 | 45 | 36 | 81 | 16 | 2 | 57 | 0 | 5 | 0 | 1 | 45 | 36 | 81 | ||||||||||||||||||||||||||||||||||
835804 | 835804 | CO | school | 806900 | 20 | ADAMS 12 FIVE STAR SCHOOLS | 80690001178 | 4172 | HULSTROM OPTIONS K-8 SCHOOL | Regular School | No | 1.0 | KG | 08 | 2016 | grade_4 | 41 | 1 | 13 | 0 | 15 | 0 | 4 | 36 | 38 | 74 | 41 | 1 | 13 | 0 | 15 | 0 | 4 | 36 | 38 | 74 | ||||||||||||||||||||||||||||||||||
835823 | 835823 | CO | school | 806900 | 20 | ADAMS 12 FIVE STAR SCHOOLS | 80690001306 | 5058 | LEROY DRIVE ELEMENTARY SCHOOL | Regular School | No | 1.0 | KG | 05 | 2016 | grade_4 | 29 | 5 | 34 | 0 | 3 | 0 | 1 | 39 | 33 | 72 | 29 | 5 | 34 | 0 | 3 | 0 | 1 | 39 | 33 | 72 | ||||||||||||||||||||||||||||||||||
835830 | 835830 | CO | school | 806900 | 20 | ADAMS 12 FIVE STAR SCHOOLS | 80690001181 | 5418 | MALLEY DRIVE ELEMENTARY SCHOOL | Regular School | No | 1.0 | PK | 05 | 2016 | grade_4 | 31 | 1 | 31 | 1 | 1 | 0 | 2 | 34 | 33 | 67 | 31 | 1 | 31 | 1 | 1 | 0 | 2 | 34 | 33 | 67 | ||||||||||||||||||||||||||||||||||
835837 | 835837 | CO | school | 806900 | 20 | ADAMS 12 FIVE STAR SCHOOLS | 80690001182 | 5706 | MC ELWAIN ELEMENTARY SCHOOL | Regular School | No | 1.0 | KG | 05 | 2016 | grade_4 | 7 | 5 | 60 | 1 | 0 | 0 | 2 | 33 | 42 | 75 | 7 | 5 | 60 | 1 | 0 | 0 | 2 | 33 | 42 | 75 | ||||||||||||||||||||||||||||||||||
835858 | 835858 | CO | school | 806900 | 20 | ADAMS 12 FIVE STAR SCHOOLS | 80690001362 | 6150 | MOUNTAIN VIEW ELEMENTARY SCHOOL | Regular School | No | 1.0 | PK | 05 | 2016 | grade_4 | 85 | 2 | 25 | 1 | 3 | 0 | 2 | 59 | 59 | 118 | 85 | 2 | 25 | 1 | 3 | 0 | 2 | 59 | 59 | 118 | ||||||||||||||||||||||||||||||||||
835870 | 835870 | CO | school | 806900 | 20 | ADAMS 12 FIVE STAR SCHOOLS | 80690001184 | 6355 | NORTH MOR ELEMENTARY SCHOOL | Regular School | No | 1.0 | PK | 05 | 2016 | grade_4 | 21 | 5 | 35 | 0 | 1 | 0 | 1 | 26 | 37 | 63 | 21 | 5 | 35 | 0 | 1 | 0 | 1 | 26 | 37 | 63 | ||||||||||||||||||||||||||||||||||
835877 | 835877 | CO | school | 806900 | 20 | ADAMS 12 FIVE STAR SCHOOLS | 80690001185 | 6376 | NORTH STAR ELEMENTARY SCHOOL | Regular School | No | 1.0 | KG | 05 | 2016 | grade_4 | 4 | 4 | 66 | 1 | 0 | 0 | 3 | 39 | 39 | 78 | 4 | 4 | 66 | 1 | 0 | 0 | 3 | 39 | 39 | 78 | ||||||||||||||||||||||||||||||||||
835913 | 835913 | CO | school | 806900 | 20 | ADAMS 12 FIVE STAR SCHOOLS | 80690001945 | 7155 | PRAIRIE HILLS ELEMENTARY SCHOOL | Regular School | No | 1.0 | KG | 05 | 2016 | grade_4 | 71 | 2 | 19 | 0 | 5 | 0 | 2 | 53 | 46 | 99 | 71 | 2 | 19 | 0 | 5 | 0 | 2 | 53 | 46 | 99 | ||||||||||||||||||||||||||||||||||
835921 | 835921 | CO | school | 806900 | 20 | ADAMS 12 FIVE STAR SCHOOLS | 80690002028 | 7795 | SILVER CREEK ELEMENTARY | Regular School | No | 1.0 | KG | 05 | 2016 | grade_4 | 88 | 2 | 11 | 0 | 7 | 0 | 5 | 57 | 56 | 113 | 88 | 2 | 11 | 0 | 7 | 0 | 5 | 57 | 56 | 113 | ||||||||||||||||||||||||||||||||||
835929 | 835929 | CO | school | 806900 | 20 | ADAMS 12 FIVE STAR SCHOOLS | 80690006375 | 8211 | THE STUDIO SCHOOL | Regular School | No | 1.0 | KG | 05 | 2016 | grade_4 | 34 | 3 | 6 | 0 | 3 | 1 | 3 | 18 | 32 | 50 | 34 | 3 | 6 | 0 | 3 | 1 | 3 | 18 | 32 | 50 | ||||||||||||||||||||||||||||||||||
835936 | 835936 | CO | school | 806900 | 20 | ADAMS 12 FIVE STAR SCHOOLS | 80690006303 | 8225 | STELLAR ELEMENTARY SCHOOL | Regular School | No | 1.0 | KG | 05 | 2016 | grade_4 | 50 | 3 | 34 | 3 | 8 | 1 | 2 | 52 | 49 | 101 | 50 | 3 | 34 | 3 | 8 | 1 | 2 | 52 | 49 | 101 | ||||||||||||||||||||||||||||||||||
835944 | 835944 | CO | school | 806900 | 20 | ADAMS 12 FIVE STAR SCHOOLS | 80690006468 | 8275 | STEM LAB | Regular School | No | 1.0 | KG | 08 | 2016 | grade_4 | 40 | 1 | 6 | 0 | 3 | 0 | 3 | 27 | 26 | 53 | 40 | 1 | 6 | 0 | 3 | 0 | 3 | 27 | 26 | 53 | ||||||||||||||||||||||||||||||||||
835954 | 835954 | CO | school | 806900 | 20 | ADAMS 12 FIVE STAR SCHOOLS | 80690006561 | 8310 | STEM LAUNCH | Regular School | No | 1.0 | KG | 08 | 2016 | grade_4 | 19 | 0 | 51 | 2 | 3 | 0 | 0 | 42 | 33 | 75 | 19 | 0 | 51 | 2 | 3 | 0 | 0 | 42 | 33 | 75 | ||||||||||||||||||||||||||||||||||
835965 | 835965 | CO | school | 806900 | 20 | ADAMS 12 FIVE STAR SCHOOLS | 80690001190 | 8361 | STUKEY ELEMENTARY SCHOOL | Regular School | No | 1.0 | KG | 05 | 2016 | grade_4 | 12 | 2 | 36 | 0 | 1 | 0 | 3 | 28 | 26 | 54 | 12 | 2 | 36 | 0 | 1 | 0 | 3 | 28 | 26 | 54 | ||||||||||||||||||||||||||||||||||
835972 | 835972 | CO | school | 806900 | 20 | ADAMS 12 FIVE STAR SCHOOLS | 80690001191 | 8842 | THORNTON ELEMENTARY SCHOOL | Regular School | No | 1.0 | PK | 05 | 2016 | grade_4 | 20 | 1 | 37 | 0 | 5 | 0 | 1 | 38 | 26 | 64 | 20 | 1 | 37 | 0 | 5 | 0 | 1 | 38 | 26 | 64 | ||||||||||||||||||||||||||||||||||
835998 | 835998 | CO | school | 806900 | 20 | ADAMS 12 FIVE STAR SCHOOLS | 80690001195 | 9494 | WESTVIEW ELEMENTARY SCHOOL | Regular School | No | 1.0 | KG | 05 | 2016 | grade_4 | 20 | 1 | 44 | 2 | 2 | 0 | 1 | 32 | 38 | 70 | 20 | 1 | 44 | 2 | 2 | 0 | 1 | 32 | 38 | 70 | ||||||||||||||||||||||||||||||||||
836005 | 836005 | CO | school | 806900 | 20 | ADAMS 12 FIVE STAR SCHOOLS | 80690001196 | 9682 | WOODGLEN ELEMENTARY SCHOOL | Regular School | No | 1.0 | PK | 05 | 2016 | grade_4 | 25 | 1 | 29 | 2 | 1 | 1 | 2 | 33 | 28 | 61 | 25 | 1 | 29 | 2 | 1 | 1 | 2 | 33 | 28 | 61 | ||||||||||||||||||||||||||||||||||
836035 | 836035 | CO | school | 801950 | 30 | ADAMS COUNTY 14 | 80195000012 | 1426 | CENTRAL ELEMENTARY SCHOOL | Regular School | No | 1.0 | PK | 05 | 2016 | grade_4 | 8 | 7 | 61 | 0 | 0 | 0 | 0 | 42 | 34 | 76 | 8 | 7 | 61 | 0 | 0 | 0 | 0 | 42 | 34 | 76 | ||||||||||||||||||||||||||||||||||
836043 | 836043 | CO | school | 801950 | 30 | ADAMS COUNTY 14 | 80195000013 | 2308 | DUPONT ELEMENTARY SCHOOL | Regular School | No | 1.0 | KG | 05 | 2016 | grade_4 | 12 | 0 | 88 | 2 | 2 | 0 | 1 | 52 | 53 | 105 | 12 | 0 | 88 | 2 | 2 | 0 | 1 | 52 | 53 | 105 | ||||||||||||||||||||||||||||||||||
836054 | 836054 | CO | school | 801950 | 30 | ADAMS COUNTY 14 | 80195000016 | 4536 | KEMP ELEMENTARY SCHOOL | Regular School | No | 1.0 | PK | 05 | 2016 | grade_4 | 17 | 1 | 73 | 1 | 0 | 0 | 0 | 62 | 30 | 92 | 17 | 1 | 73 | 1 | 0 | 0 | 0 | 62 | 30 | 92 | ||||||||||||||||||||||||||||||||||
836064 | 836064 | CO | school | 801950 | 30 | ADAMS COUNTY 14 | 80195000017 | 5982 | MONACO ELEMENTARY SCHOOL | Regular School | No | 1.0 | KG | 05 | 2016 | grade_4 | 11 | 4 | 70 | 2 | 0 | 0 | 3 | 47 | 43 | 90 | 11 | 4 | 70 | 2 | 0 | 0 | 3 | 47 | 43 | 90 | ||||||||||||||||||||||||||||||||||
836071 | 836071 | CO | school | 801950 | 30 | ADAMS COUNTY 14 | 80195000018 | 6534 | HANSON ELEMENTARY SCHOOL | Regular School | No | 1.0 | PK | 05 | 2016 | grade_4 | 3 | 0 | 33 | 0 | 0 | 0 | 0 | 9 | 27 | 36 | 3 | 0 | 33 | 0 | 0 | 0 | 0 | 9 | 27 | 36 | ||||||||||||||||||||||||||||||||||
836079 | 836079 | CO | school | 801950 | 30 | ADAMS COUNTY 14 | 80195000019 | 7500 | ROSE HILL ELEMENTARY SCHOOL | Regular School | No | 1.0 | PK | 05 | 2016 | grade_4 | 13 | 3 | 69 | 1 | 2 | 0 | 0 | 46 | 42 | 88 | 13 | 3 | 69 | 1 | 2 | 0 | 0 | 46 | 42 | 88 | ||||||||||||||||||||||||||||||||||
836097 | 836097 | CO | school | 802580 | 40 | SCHOOL DISTRICT 27J | 80258006549 | 1013 | BRANTNER ELEMENTARY SCHOOL | Regular School | No | 1.0 | KG | 05 | 2016 | grade_4 | 42 | 0 | 12 | 0 | 5 | 0 | 3 | 37 | 25 | 62 | 42 | 0 | 12 | 0 | 5 | 0 | 3 | 37 | 25 | 62 | ||||||||||||||||||||||||||||||||||
836116 | 836116 | CO | school | 802580 | 40 | SCHOOL DISTRICT 27J | 80258001729 | 1052 | BROMLEY EAST CHARTER SCHOOL | Regular School | Yes | 1.0 | PK | 08 | 2016 | grade_4 | 68 | 0 | 29 | 0 | 1 | 0 | 3 | 53 | 48 | 101 | 68 | 0 | 29 | 0 | 1 | 0 | 3 | 53 | 48 | 101 | ||||||||||||||||||||||||||||||||||
836137 | 836137 | CO | school | 802580 | 40 | SCHOOL DISTRICT 27J | 80258006465 | 2945 | FOUNDATIONS ACADEMY | Regular School | Yes | 1.0 | KG | 08 | 2016 | grade_4 | 59 | 2 | 24 | 0 | 0 | 0 | 1 | 33 | 53 | 86 | 59 | 2 | 24 | 0 | 0 | 0 | 1 | 33 | 53 | 86 | ||||||||||||||||||||||||||||||||||
836148 | 836148 | CO | school | 802580 | 40 | SCHOOL DISTRICT 27J | 80258000146 | 3900 | HENDERSON ELEMENTARY SCHOOL | Regular School | No | 1.0 | PK | 05 | 2016 | grade_4 | 46 | 1 | 37 | 0 | 3 | 0 | 0 | 45 | 42 | 87 | 46 | 1 | 37 | 0 | 3 | 0 | 0 | 45 | 42 | 87 | ||||||||||||||||||||||||||||||||||
836157 | 836157 | CO | school | 802580 | 40 | SCHOOL DISTRICT 27J | 80258006325 | 4950 | LANDMARK ACADEMY AT REUNION | Regular School | Yes | 1.0 | KG | 08 | 2016 | grade_4 | 66 | 2 | 16 | 0 | 1 | 0 | 3 | 38 | 50 | 88 | 66 | 2 | 16 | 0 | 1 | 0 | 3 | 38 | 50 | 88 | ||||||||||||||||||||||||||||||||||
836168 | 836168 | CO | school | 802580 | 40 | SCHOOL DISTRICT 27J | 80258001949 | 5615 | MARY E PENNOCK ELEMENTARY SCHOOL | Regular School | No | 1.0 | KG | 05 | 2016 | grade_4 | 61 | 2 | 59 | 0 | 1 | 1 | 7 | 73 | 58 | 131 | 61 | 2 | 59 | 0 | 1 | 1 | 7 | 73 | 58 | 131 | ||||||||||||||||||||||||||||||||||
836176 | 836176 | CO | school | 802580 | 40 | SCHOOL DISTRICT 27J | 80258000148 | 6294 | NORTH ELEMENTARY SCHOOL | Regular School | No | 1.0 | PK | 05 | 2016 | grade_4 | 6 | 0 | 45 | 0 | 1 | 0 | 0 | 19 | 33 | 52 | 6 | 0 | 45 | 0 | 1 | 0 | 0 | 19 | 33 | 52 | ||||||||||||||||||||||||||||||||||
836185 | 836185 | CO | school | 802580 | 40 | SCHOOL DISTRICT 27J | 80258000149 | 6395 | NORTHEAST ELEMENTARY SCHOOL | Regular School | No | 1.0 | PK | 06 | 2016 | grade_4 | 33 | 1 | 60 | 2 | 1 | 0 | 2 | 47 | 52 | 99 | 33 | 1 | 60 | 2 | 1 | 0 | 2 | 47 | 52 | 99 | ||||||||||||||||||||||||||||||||||
836210 | 836210 | CO | school | 802580 | 40 | SCHOOL DISTRICT 27J | 80258001950 | 7714 | SECOND CREEK ELEMENTARY SCHOOL | Regular School | No | 1.0 | PK | 05 | 2016 | grade_4 | 47 | 5 | 36 | 0 | 6 | 0 | 8 | 58 | 44 | 102 | 47 | 5 | 36 | 0 | 6 | 0 | 8 | 58 | 44 | 102 | ||||||||||||||||||||||||||||||||||
836221 | 836221 | CO | school | 802580 | 40 | SCHOOL DISTRICT 27J | 80258001822 | 8032 | JOHN W THIMMIG ELEMENTARY SCHOOL | Regular School | No | 1.0 | PK | 05 | 2016 | grade_4 | 36 | 0 | 60 | 0 | 4 | 0 | 3 | 49 | 54 | 103 | 36 | 0 | 60 | 0 | 4 | 0 | 3 | 49 | 54 | 103 | ||||||||||||||||||||||||||||||||||
836230 | 836230 | CO | school | 802580 | 40 | SCHOOL DISTRICT 27J | 80258000150 | 8060 | SOUTH ELEMENTARY SCHOOL | Regular School | No | 1.0 | KG | 05 | 2016 | grade_4 | 11 | 2 | 53 | 0 | 0 | 0 | 2 | 38 | 30 | 68 | 11 | 2 | 53 | 0 | 0 | 0 | 2 | 38 | 30 | 68 | ||||||||||||||||||||||||||||||||||
836237 | 836237 | CO | school | 802580 | 40 | SCHOOL DISTRICT 27J | 80258000151 | 8130 | SOUTHEAST ELEMENTARY SCHOOL | Regular School | No | 1.0 | KG | 05 | 2016 | grade_4 | 33 | 0 | 66 | 0 | 0 | 0 | 3 | 54 | 48 | 102 | 33 | 0 | 66 | 0 | 0 | 0 | 3 | 54 | 48 | 102 | ||||||||||||||||||||||||||||||||||
836245 | 836245 | CO | school | 802580 | 40 | SCHOOL DISTRICT 27J | 80258006401 | 8820 | TURNBERRY ELEMENTARY | Regular School | No | 1.0 | PK | 05 | 2016 | grade_4 | 70 | 5 | 49 | 0 | 7 | 0 | 4 | 67 | 68 | 135 | 70 | 5 | 49 | 0 | 7 | 0 | 4 | 67 | 68 | 135 | ||||||||||||||||||||||||||||||||||
836257 | 836257 | CO | school | 802580 | 40 | SCHOOL DISTRICT 27J | 80258006326 | 9426 | WEST RIDGE ELEMENTARY | Regular School | No | 1.0 | PK | 05 | 2016 | grade_4 | 61 | 0 | 23 | 0 | 13 | 0 | 7 | 51 | 53 | 104 | 61 | 0 | 23 | 0 | 13 | 0 | 7 | 51 | 53 | 104 | ||||||||||||||||||||||||||||||||||
836287 | 836287 | CO | school | 806750 | 60 | STRASBURG 31J | 80675001159 | 8328 | STRASBURG ELEMENTARY SCHOOL | Regular School | No | 1.0 | PK | 05 | 2016 | grade_4 | 54 | 0 | 6 | 1 | 0 | 0 | 1 | 31 | 31 | 62 | 54 | 0 | 6 | 1 | 0 | 0 | 1 | 31 | 31 | 62 | ||||||||||||||||||||||||||||||||||
836306 | 836306 | CO | school | 807230 | 70 | WESTMINSTER PUBLIC SCHOOLS | 80723001232 | 1622 | CLARA E. METZ ELEMENTARY SCHOOL | Regular School | No | 1.0 | KG | 05 | 2016 | grade_4 | 8 | 1 | 42 | 1 | 4 | 0 | 2 | 26 | 32 | 58 | 8 | 1 | 42 | 1 | 4 | 0 | 2 | 26 | 32 | 58 | ||||||||||||||||||||||||||||||||||
836313 | 836313 | CO | school | 807230 | 70 | WESTMINSTER PUBLIC SCHOOLS | 80723001235 | 2876 | FAIRVIEW ELEMENTARY SCHOOL | Regular School | No | 1.0 | PK | 05 | 2016 | grade_4 | 4 | 0 | 44 | 0 | 3 | 0 | 0 | 23 | 28 | 51 | 4 | 0 | 44 | 0 | 3 | 0 | 0 | 23 | 28 | 51 | ||||||||||||||||||||||||||||||||||
836320 | 836320 | CO | school | 807230 | 70 | WESTMINSTER PUBLIC SCHOOLS | 80723001236 | 3144 | FRANCIS M. DAY ELEMENTARY SCHOOL | Regular School | No | 1.0 | PK | 05 | 2016 | grade_4 | 5 | 0 | 47 | 0 | 0 | 0 | 0 | 23 | 29 | 52 | 5 | 0 | 47 | 0 | 0 | 0 | 0 | 23 | 29 | 52 | ||||||||||||||||||||||||||||||||||
836330 | 836330 | CO | school | 807230 | 70 | WESTMINSTER PUBLIC SCHOOLS | 80723001238 | 3792 | HARRIS PARK ELEMENTARY SCHOOL | Regular School | No | 1.0 | PK | 05 | 2016 | grade_4 | 14 | 1 | 36 | 0 | 2 | 0 | 3 | 26 | 30 | 56 | 14 | 1 | 36 | 0 | 2 | 0 | 3 | 26 | 30 | 56 | ||||||||||||||||||||||||||||||||||
836340 | 836340 | CO | school | 807230 | 70 | WESTMINSTER PUBLIC SCHOOLS | 80723006567 | 4334 | COLORADO STEM ACADEMY | Regular School | No | 1.0 | 03 | 08 | 2016 | grade_4 | 26 | 1 | 15 | 0 | 1 | 0 | 1 | 26 | 18 | 44 | 26 | 1 | 15 | 0 | 1 | 0 | 1 | 26 | 18 | 44 | ||||||||||||||||||||||||||||||||||
836349 | 836349 | CO | school | 807230 | 70 | WESTMINSTER PUBLIC SCHOOLS | 80723006373 | 4465 | JOSEPHINE HODGKINS ELEMENTARY SCHOOL | Regular School | No | 1.0 | PK | 05 | 2016 | grade_4 | 6 | 1 | 81 | 0 | 2 | 0 | 2 | 47 | 45 | 92 | 6 | 1 | 81 | 0 | 2 | 0 | 2 | 47 | 45 | 92 | ||||||||||||||||||||||||||||||||||
836361 | 836361 | CO | school | 807230 | 70 | WESTMINSTER PUBLIC SCHOOLS | 80723001242 | 5834 | MESA ELEMENTARY SCHOOL | Regular School | No | 1.0 | PK | 05 | 2016 | grade_4 | 12 | 2 | 26 | 0 | 3 | 0 | 2 | 18 | 27 | 45 | 12 | 2 | 26 | 0 | 3 | 0 | 2 | 18 | 27 | 45 | ||||||||||||||||||||||||||||||||||
836372 | 836372 | CO | school | 807230 | 70 | WESTMINSTER PUBLIC SCHOOLS | 80723001363 | 7810 | FLYNN ELEMENTARY SCHOOL | Regular School | No | 1.0 | PK | 05 | 2016 | grade_4 | 7 | 0 | 27 | 0 | 1 | 0 | 1 | 22 | 14 | 36 | 7 | 0 | 27 | 0 | 1 | 0 | 1 | 22 | 14 | 36 | ||||||||||||||||||||||||||||||||||
836384 | 836384 | CO | school | 807230 | 70 | WESTMINSTER PUBLIC SCHOOLS | 80723001246 | 7860 | SHERRELWOOD ELEMENTARY SCHOOL | Regular School | No | 1.0 | KG | 05 | 2016 | grade_4 | 8 | 1 | 40 | 0 | 1 | 0 | 2 | 22 | 30 | 52 | 8 | 1 | 40 | 0 | 1 | 0 | 2 | 22 | 30 | 52 | ||||||||||||||||||||||||||||||||||
836391 | 836391 | CO | school | 807230 | 70 | WESTMINSTER PUBLIC SCHOOLS | 80723001247 | 7952 | SKYLINE VISTA ELEMENTARY SCHOOL | Regular School | No | 1.0 | PK | 05 | 2016 | grade_4 | 5 | 1 | 42 | 0 | 3 | 0 | 1 | 21 | 31 | 52 | 5 | 1 | 42 | 0 | 3 | 0 | 1 | 21 | 31 | 52 | ||||||||||||||||||||||||||||||||||
836399 | 836399 | CO | school | 807230 | 70 | WESTMINSTER PUBLIC SCHOOLS | 80723001248 | 8406 | SUNSET RIDGE ELEMENTARY SCHOOL | Regular School | No | 1.0 | KG | 05 | 2016 | grade_4 | 6 | 0 | 50 | 1 | 1 | 0 | 1 | 32 | 27 | 59 | 6 | 0 | 50 | 1 | 1 | 0 | 1 | 32 | 27 | 59 | ||||||||||||||||||||||||||||||||||
836406 | 836406 | CO | school | 807230 | 70 | WESTMINSTER PUBLIC SCHOOLS | 80723001249 | 8798 | TENNYSON KNOLLS ELEMENTARY SCHOOL | Regular School | No | 1.0 | KG | 05 | 2016 | grade_4 | 10 | 1 | 46 | 1 | 7 | 0 | 1 | 34 | 32 | 66 | 10 | 1 | 46 | 1 | 7 | 0 | 1 | 34 | 32 | 66 | ||||||||||||||||||||||||||||||||||
836413 | 836413 | CO | school | 807230 | 70 | WESTMINSTER PUBLIC SCHOOLS | 80723001252 | 9462 | WESTMINSTER ELEMENTARY SCHOOL | Regular School | No | 1.0 | PK | 05 | 2016 | grade_4 | 7 | 1 | 19 | 0 | 0 | 0 | 2 | 18 | 11 | 29 | 7 | 1 | 19 | 0 | 0 | 0 | 2 | 18 | 11 | 29 | ||||||||||||||||||||||||||||||||||
836449 | 836449 | CO | school | 806420 | 110 | SANGRE DE CRISTO RE-22J | 80642001115 | 7626 | SANGRE DE CRISTO ELEMENTARY SCHOOL | Regular School | No | 1.0 | PK | 05 | 2016 | grade_4 | 10 | 0 | 11 | 1 | 1 | 0 | 1 | 8 | 16 | 24 | 10 | 0 | 11 | 1 | 1 | 0 | 1 | 8 | 16 | 24 |
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]);