enrollments
Data source: Big Local News · About: Big Local
4,856 rows where state = "ID" and year = 2020 sorted by ccd_school_type
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
850054 | 850054 | ID | school | 92 | SWAN VALLEY ELEMENTARY DISTRICT | 1014 | BORDER DISTRICT - STAR VALLEY ELEMENTARY SCHOOL | 2020 | grade_1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | * | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 1 | ||||||||||||||||||||||||||||||||||||||||
850055 | 850055 | ID | school | 92 | SWAN VALLEY ELEMENTARY DISTRICT | 1014 | BORDER DISTRICT - STAR VALLEY ELEMENTARY SCHOOL | 2020 | grade_2 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | * | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 1 | ||||||||||||||||||||||||||||||||||||||||
850056 | 850056 | ID | school | 92 | SWAN VALLEY ELEMENTARY DISTRICT | 1014 | BORDER DISTRICT - STAR VALLEY ELEMENTARY SCHOOL | 2020 | grade_3 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | * | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | ||||||||||||||||||||||||||||||||||||||||
850057 | 850057 | ID | school | 92 | SWAN VALLEY ELEMENTARY DISTRICT | 1014 | BORDER DISTRICT - STAR VALLEY ELEMENTARY SCHOOL | 2020 | k_12_total | 4 | 0 | 0 | 0 | 0 | 0 | 0 | 2 | 2 | * | 4 | 4 | 0 | 0 | 0 | 0 | 0 | 0 | 2 | 2 | 4 | ||||||||||||||||||||||||||||||||||||||||
850058 | 850058 | ID | school | 92 | SWAN VALLEY ELEMENTARY DISTRICT | 1014 | BORDER DISTRICT - STAR VALLEY ELEMENTARY SCHOOL | 2020 | kindergarten | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | * | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | ||||||||||||||||||||||||||||||||||||||||
850059 | 850059 | ID | school | 92 | SWAN VALLEY ELEMENTARY DISTRICT | 1015 | BORDER DISTRICT - STAR VALLEY JR-SR HIGH SCHOOL | 2020 | grade_10 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | * | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 1 | ||||||||||||||||||||||||||||||||||||||||
850060 | 850060 | ID | school | 92 | SWAN VALLEY ELEMENTARY DISTRICT | 1015 | BORDER DISTRICT - STAR VALLEY JR-SR HIGH SCHOOL | 2020 | grade_12 | 2 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 1 | * | 2 | 2 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 1 | 2 | ||||||||||||||||||||||||||||||||||||||||
850061 | 850061 | ID | school | 92 | SWAN VALLEY ELEMENTARY DISTRICT | 1015 | BORDER DISTRICT - STAR VALLEY JR-SR HIGH SCHOOL | 2020 | k_12_total | 3 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 2 | * | 3 | 3 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 2 | 3 | ||||||||||||||||||||||||||||||||||||||||
850720 | 850720 | ID | school | 150 | SODA SPRINGS JOINT DISTRICT | 1025 | BORDER DISTRICT - FREEDOM ELEMENTARY | 2020 | grade_1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | * | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | ||||||||||||||||||||||||||||||||||||||||
850721 | 850721 | ID | school | 150 | SODA SPRINGS JOINT DISTRICT | 1025 | BORDER DISTRICT - FREEDOM ELEMENTARY | 2020 | grade_2 | 6 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 5 | * | 6 | 6 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 5 | 6 | ||||||||||||||||||||||||||||||||||||||||
850722 | 850722 | ID | school | 150 | SODA SPRINGS JOINT DISTRICT | 1025 | BORDER DISTRICT - FREEDOM ELEMENTARY | 2020 | grade_3 | 3 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 3 | * | 3 | 3 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 3 | 3 | ||||||||||||||||||||||||||||||||||||||||
850723 | 850723 | ID | school | 150 | SODA SPRINGS JOINT DISTRICT | 1025 | BORDER DISTRICT - FREEDOM ELEMENTARY | 2020 | grade_4 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | * | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | ||||||||||||||||||||||||||||||||||||||||
850724 | 850724 | ID | school | 150 | SODA SPRINGS JOINT DISTRICT | 1025 | BORDER DISTRICT - FREEDOM ELEMENTARY | 2020 | grade_5 | 2 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 2 | * | 2 | 2 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 2 | 2 | ||||||||||||||||||||||||||||||||||||||||
850725 | 850725 | ID | school | 150 | SODA SPRINGS JOINT DISTRICT | 1025 | BORDER DISTRICT - FREEDOM ELEMENTARY | 2020 | grade_6 | 2 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 3 | * | 3 | 2 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 3 | 3 | ||||||||||||||||||||||||||||||||||||||||
850726 | 850726 | ID | school | 150 | SODA SPRINGS JOINT DISTRICT | 1025 | BORDER DISTRICT - FREEDOM ELEMENTARY | 2020 | k_12_total | 17 | 0 | 1 | 0 | 0 | 0 | 0 | 5 | 13 | * | 18 | 17 | 0 | 1 | 0 | 0 | 0 | 0 | 5 | 13 | 18 | ||||||||||||||||||||||||||||||||||||||||
850727 | 850727 | ID | school | 150 | SODA SPRINGS JOINT DISTRICT | 1025 | BORDER DISTRICT - FREEDOM ELEMENTARY | 2020 | kindergarten | 2 | 0 | 0 | 0 | 0 | 0 | 0 | 2 | 0 | * | 2 | 2 | 0 | 0 | 0 | 0 | 0 | 0 | 2 | 0 | 2 | ||||||||||||||||||||||||||||||||||||||||
850728 | 850728 | ID | school | 150 | SODA SPRINGS JOINT DISTRICT | 1026 | BORDER DISTRICT FREEDOM - SECONDARY | 2020 | grade_10 | 1 | 0 | 2 | 0 | 0 | 0 | 0 | 3 | 0 | * | 3 | 1 | 0 | 2 | 0 | 0 | 0 | 0 | 3 | 0 | 3 | ||||||||||||||||||||||||||||||||||||||||
850729 | 850729 | ID | school | 150 | SODA SPRINGS JOINT DISTRICT | 1026 | BORDER DISTRICT FREEDOM - SECONDARY | 2020 | grade_11 | 3 | 0 | 1 | 0 | 0 | 0 | 0 | 4 | 0 | * | 4 | 3 | 0 | 1 | 0 | 0 | 0 | 0 | 4 | 0 | 4 | ||||||||||||||||||||||||||||||||||||||||
850730 | 850730 | ID | school | 150 | SODA SPRINGS JOINT DISTRICT | 1026 | BORDER DISTRICT FREEDOM - SECONDARY | 2020 | grade_12 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | * | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | ||||||||||||||||||||||||||||||||||||||||
850731 | 850731 | ID | school | 150 | SODA SPRINGS JOINT DISTRICT | 1026 | BORDER DISTRICT FREEDOM - SECONDARY | 2020 | grade_7 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | * | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | ||||||||||||||||||||||||||||||||||||||||
850732 | 850732 | ID | school | 150 | SODA SPRINGS JOINT DISTRICT | 1026 | BORDER DISTRICT FREEDOM - SECONDARY | 2020 | grade_8 | 3 | 0 | 0 | 0 | 0 | 0 | 0 | 2 | 1 | * | 3 | 3 | 0 | 0 | 0 | 0 | 0 | 0 | 2 | 1 | 3 | ||||||||||||||||||||||||||||||||||||||||
850733 | 850733 | ID | school | 150 | SODA SPRINGS JOINT DISTRICT | 1026 | BORDER DISTRICT FREEDOM - SECONDARY | 2020 | grade_9 | 3 | 1 | 1 | 0 | 0 | 0 | 0 | 2 | 3 | * | 5 | 3 | 1 | 1 | 0 | 0 | 0 | 0 | 2 | 3 | 5 | ||||||||||||||||||||||||||||||||||||||||
850734 | 850734 | ID | school | 150 | SODA SPRINGS JOINT DISTRICT | 1026 | BORDER DISTRICT FREEDOM - SECONDARY | 2020 | k_12_total | 12 | 1 | 4 | 0 | 0 | 0 | 0 | 13 | 4 | * | 17 | 12 | 1 | 4 | 0 | 0 | 0 | 0 | 13 | 4 | 17 | ||||||||||||||||||||||||||||||||||||||||
852041 | 852041 | ID | school | 340 | LEWISTON INDEPENDENT DISTRICT | 611 | NORTHWEST CHILDRENS HOME | 2020 | grade_10 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | * | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | ||||||||||||||||||||||||||||||||||||||||
852042 | 852042 | ID | school | 340 | LEWISTON INDEPENDENT DISTRICT | 611 | NORTHWEST CHILDRENS HOME | 2020 | grade_12 | 2 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 1 | * | 2 | 2 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 1 | 2 | ||||||||||||||||||||||||||||||||||||||||
852043 | 852043 | ID | school | 340 | LEWISTON INDEPENDENT DISTRICT | 611 | NORTHWEST CHILDRENS HOME | 2020 | grade_3 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | * | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | ||||||||||||||||||||||||||||||||||||||||
852044 | 852044 | ID | school | 340 | LEWISTON INDEPENDENT DISTRICT | 611 | NORTHWEST CHILDRENS HOME | 2020 | grade_4 | 5 | 0 | 0 | 0 | 0 | 0 | 0 | 5 | 0 | * | 5 | 5 | 0 | 0 | 0 | 0 | 0 | 0 | 5 | 0 | 5 | ||||||||||||||||||||||||||||||||||||||||
852045 | 852045 | ID | school | 340 | LEWISTON INDEPENDENT DISTRICT | 611 | NORTHWEST CHILDRENS HOME | 2020 | grade_5 | 2 | 0 | 0 | 0 | 0 | 0 | 0 | 2 | 0 | * | 2 | 2 | 0 | 0 | 0 | 0 | 0 | 0 | 2 | 0 | 2 | ||||||||||||||||||||||||||||||||||||||||
852046 | 852046 | ID | school | 340 | LEWISTON INDEPENDENT DISTRICT | 611 | NORTHWEST CHILDRENS HOME | 2020 | grade_6 | 2 | 0 | 0 | 0 | 0 | 0 | 0 | 2 | 0 | * | 2 | 2 | 0 | 0 | 0 | 0 | 0 | 0 | 2 | 0 | 2 | ||||||||||||||||||||||||||||||||||||||||
852047 | 852047 | ID | school | 340 | LEWISTON INDEPENDENT DISTRICT | 611 | NORTHWEST CHILDRENS HOME | 2020 | grade_7 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | * | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | ||||||||||||||||||||||||||||||||||||||||
852048 | 852048 | ID | school | 340 | LEWISTON INDEPENDENT DISTRICT | 611 | NORTHWEST CHILDRENS HOME | 2020 | grade_8 | 2 | 0 | 0 | 0 | 0 | 0 | 0 | 2 | 0 | * | 2 | 2 | 0 | 0 | 0 | 0 | 0 | 0 | 2 | 0 | 2 | ||||||||||||||||||||||||||||||||||||||||
852049 | 852049 | ID | school | 340 | LEWISTON INDEPENDENT DISTRICT | 611 | NORTHWEST CHILDRENS HOME | 2020 | grade_9 | 2 | 0 | 1 | 0 | 0 | 0 | 0 | 3 | 0 | * | 3 | 2 | 0 | 1 | 0 | 0 | 0 | 0 | 3 | 0 | 3 | ||||||||||||||||||||||||||||||||||||||||
852050 | 852050 | ID | school | 340 | LEWISTON INDEPENDENT DISTRICT | 611 | NORTHWEST CHILDRENS HOME | 2020 | k_12_total | 18 | 0 | 1 | 0 | 0 | 0 | 0 | 18 | 1 | * | 19 | 18 | 0 | 1 | 0 | 0 | 0 | 0 | 18 | 1 | 19 | ||||||||||||||||||||||||||||||||||||||||
852133 | 852133 | ID | school | 341 | LAPWAI DISTRICT | 1050 | NORTHWEST CHILDREN'S HOME | 2020 | grade_10 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | * | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | ||||||||||||||||||||||||||||||||||||||||
852134 | 852134 | ID | school | 341 | LAPWAI DISTRICT | 1050 | NORTHWEST CHILDREN'S HOME | 2020 | k_12_total | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | * | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | ||||||||||||||||||||||||||||||||||||||||
852149 | 852149 | ID | school | 342 | CULDESAC JOINT DISTRICT | 1373 | NORTHWEST CHILDREN'S HOME | 2020 | grade_5 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 1 | 0 | * | 1 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 1 | 0 | 1 | ||||||||||||||||||||||||||||||||||||||||
852150 | 852150 | ID | school | 342 | CULDESAC JOINT DISTRICT | 1373 | NORTHWEST CHILDREN'S HOME | 2020 | k_12_total | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 1 | 0 | * | 1 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 1 | 0 | 1 | ||||||||||||||||||||||||||||||||||||||||
852207 | 852207 | ID | school | 364 | PLEASANT VALLEY ELEMENTARY DISTRICT | 1056 | BORDER DISTRICT - JORDAN VALLEY SECONDARY | 2020 | grade_10 | 2 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 2 | * | 2 | 2 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 2 | 2 | ||||||||||||||||||||||||||||||||||||||||
852208 | 852208 | ID | school | 364 | PLEASANT VALLEY ELEMENTARY DISTRICT | 1056 | BORDER DISTRICT - JORDAN VALLEY SECONDARY | 2020 | grade_9 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | * | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 1 | ||||||||||||||||||||||||||||||||||||||||
852209 | 852209 | ID | school | 364 | PLEASANT VALLEY ELEMENTARY DISTRICT | 1056 | BORDER DISTRICT - JORDAN VALLEY SECONDARY | 2020 | k_12_total | 3 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 3 | * | 3 | 3 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 3 | 3 | ||||||||||||||||||||||||||||||||||||||||
853322 | 853322 | ID | school | 555 | CANYON-OWYHEE SCHOOL SERVICE AGENCY (COSSA) | 1292 | COSSA ACADEMY ALTERNATIVE SUMMER SCHOOL | 2020 | grade_12 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | * | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 1 | ||||||||||||||||||||||||||||||||||||||||
853323 | 853323 | ID | school | 555 | CANYON-OWYHEE SCHOOL SERVICE AGENCY (COSSA) | 1292 | COSSA ACADEMY ALTERNATIVE SUMMER SCHOOL | 2020 | k_12_total | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | * | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 1 | ||||||||||||||||||||||||||||||||||||||||
848860 | 848860 | ID | school | 1600360 | 1 | BOISE INDEPENDENT DISTRICT | 160036000984 | 675 | FRANK CHURCH HIGH SCHOOL | Alternative School | No | High | 06 | 12 | 2020 | grade_10 | 81 | 3 | 25 | 3 | 1 | 0 | 0 | 52 | 61 | 58 | 113 | 81 | 3 | 25 | 3 | 1 | 0 | 0 | 52 | 61 | 58 | 113 | ||||||||||||||||||||||||||||||||
848861 | 848861 | ID | school | 1600360 | 1 | BOISE INDEPENDENT DISTRICT | 160036000984 | 675 | FRANK CHURCH HIGH SCHOOL | Alternative School | No | High | 06 | 12 | 2020 | grade_11 | 63 | 5 | 18 | 2 | 0 | 1 | 3 | 52 | 40 | * | 92 | 63 | 5 | 18 | 2 | 0 | 1 | 3 | 52 | 40 | 92 | |||||||||||||||||||||||||||||||||
848862 | 848862 | ID | school | 1600360 | 1 | BOISE INDEPENDENT DISTRICT | 160036000984 | 675 | FRANK CHURCH HIGH SCHOOL | Alternative School | No | High | 06 | 12 | 2020 | grade_12 | 146 | 9 | 31 | 0 | 3 | 0 | 8 | 112 | 85 | 70 | 197 | 146 | 9 | 31 | 0 | 3 | 0 | 8 | 112 | 85 | 70 | 197 | ||||||||||||||||||||||||||||||||
848863 | 848863 | ID | school | 1600360 | 1 | BOISE INDEPENDENT DISTRICT | 160036000984 | 675 | FRANK CHURCH HIGH SCHOOL | Alternative School | No | High | 06 | 12 | 2020 | grade_7 | 2 | 0 | 0 | 0 | 0 | 0 | 0 | 2 | 0 | * | 2 | 2 | 0 | 0 | 0 | 0 | 0 | 0 | 2 | 0 | 2 | |||||||||||||||||||||||||||||||||
848864 | 848864 | ID | school | 1600360 | 1 | BOISE INDEPENDENT DISTRICT | 160036000984 | 675 | FRANK CHURCH HIGH SCHOOL | Alternative School | No | High | 06 | 12 | 2020 | grade_8 | 6 | 0 | 1 | 0 | 0 | 0 | 0 | 5 | 2 | * | 7 | 6 | 0 | 1 | 0 | 0 | 0 | 0 | 5 | 2 | 7 | |||||||||||||||||||||||||||||||||
848865 | 848865 | ID | school | 1600360 | 1 | BOISE INDEPENDENT DISTRICT | 160036000984 | 675 | FRANK CHURCH HIGH SCHOOL | Alternative School | No | High | 06 | 12 | 2020 | grade_9 | 49 | 5 | 9 | 2 | 0 | 0 | 6 | 35 | 36 | 49 | 71 | 49 | 5 | 9 | 2 | 0 | 0 | 6 | 35 | 36 | 49 | 71 | ||||||||||||||||||||||||||||||||
848866 | 848866 | ID | school | 1600360 | 1 | BOISE INDEPENDENT DISTRICT | 160036000984 | 675 | FRANK CHURCH HIGH SCHOOL | Alternative School | No | High | 06 | 12 | 2020 | k_12_total | 347 | 22 | 84 | 7 | 4 | 1 | 17 | 258 | 224 | 216 | 482 | 347 | 22 | 84 | 7 | 4 | 1 | 17 | 258 | 224 | 216 | 482 | ||||||||||||||||||||||||||||||||
848883 | 848883 | ID | school | 1600360 | 1 | BOISE INDEPENDENT DISTRICT | 160036000708 | 9002 | ADA COUNTY JUVENILE CENTER | Alternative School | No | High | 05 | 12 | 2020 | grade_10 | 5 | 0 | 0 | 0 | 0 | 0 | 0 | 5 | 0 | * | 5 | 5 | 0 | 0 | 0 | 0 | 0 | 0 | 5 | 0 | 5 | |||||||||||||||||||||||||||||||||
848884 | 848884 | ID | school | 1600360 | 1 | BOISE INDEPENDENT DISTRICT | 160036000708 | 9002 | ADA COUNTY JUVENILE CENTER | Alternative School | No | High | 05 | 12 | 2020 | grade_11 | 4 | 0 | 1 | 0 | 0 | 0 | 0 | 4 | 1 | * | 5 | 4 | 0 | 1 | 0 | 0 | 0 | 0 | 4 | 1 | 5 | |||||||||||||||||||||||||||||||||
848885 | 848885 | ID | school | 1600360 | 1 | BOISE INDEPENDENT DISTRICT | 160036000708 | 9002 | ADA COUNTY JUVENILE CENTER | Alternative School | No | High | 05 | 12 | 2020 | grade_12 | 2 | 0 | 0 | 0 | 0 | 0 | 0 | 2 | 0 | * | 2 | 2 | 0 | 0 | 0 | 0 | 0 | 0 | 2 | 0 | 2 | |||||||||||||||||||||||||||||||||
848886 | 848886 | ID | school | 1600360 | 1 | BOISE INDEPENDENT DISTRICT | 160036000708 | 9002 | ADA COUNTY JUVENILE CENTER | Alternative School | No | High | 05 | 12 | 2020 | grade_6 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | * | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | |||||||||||||||||||||||||||||||||
848887 | 848887 | ID | school | 1600360 | 1 | BOISE INDEPENDENT DISTRICT | 160036000708 | 9002 | ADA COUNTY JUVENILE CENTER | Alternative School | No | High | 05 | 12 | 2020 | grade_8 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | * | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | |||||||||||||||||||||||||||||||||
848888 | 848888 | ID | school | 1600360 | 1 | BOISE INDEPENDENT DISTRICT | 160036000708 | 9002 | ADA COUNTY JUVENILE CENTER | Alternative School | No | High | 05 | 12 | 2020 | grade_9 | 7 | 0 | 0 | 0 | 0 | 0 | 0 | 6 | 1 | * | 7 | 7 | 0 | 0 | 0 | 0 | 0 | 0 | 6 | 1 | 7 | |||||||||||||||||||||||||||||||||
848889 | 848889 | ID | school | 1600360 | 1 | BOISE INDEPENDENT DISTRICT | 160036000708 | 9002 | ADA COUNTY JUVENILE CENTER | Alternative School | No | High | 05 | 12 | 2020 | k_12_total | 20 | 0 | 1 | 0 | 0 | 0 | 0 | 19 | 2 | * | 21 | 20 | 0 | 1 | 0 | 0 | 0 | 0 | 19 | 2 | 21 | |||||||||||||||||||||||||||||||||
849131 | 849131 | ID | school | 1602100 | 2 | JOINT SCHOOL DISTRICT NO. 2 | 160210000931 | 594 | PATHWAYS MIDDLE SCHOOL | Alternative School | No | Middle | 06 | 08 | 2020 | grade_6 | 39 | 1 | 2 | 2 | 0 | 0 | 3 | 26 | 21 | 18 | 47 | 39 | 1 | 2 | 2 | 0 | 0 | 3 | 26 | 21 | 18 | 47 | ||||||||||||||||||||||||||||||||
849132 | 849132 | ID | school | 1602100 | 2 | JOINT SCHOOL DISTRICT NO. 2 | 160210000931 | 594 | PATHWAYS MIDDLE SCHOOL | Alternative School | No | Middle | 06 | 08 | 2020 | grade_7 | 43 | 2 | 4 | 0 | 0 | 0 | 4 | 40 | 13 | 20 | 53 | 43 | 2 | 4 | 0 | 0 | 0 | 4 | 40 | 13 | 20 | 53 | ||||||||||||||||||||||||||||||||
849133 | 849133 | ID | school | 1602100 | 2 | JOINT SCHOOL DISTRICT NO. 2 | 160210000931 | 594 | PATHWAYS MIDDLE SCHOOL | Alternative School | No | Middle | 06 | 08 | 2020 | grade_8 | 49 | 0 | 2 | 0 | 0 | 0 | 0 | 33 | 18 | 22 | 51 | 49 | 0 | 2 | 0 | 0 | 0 | 0 | 33 | 18 | 22 | 51 | ||||||||||||||||||||||||||||||||
849134 | 849134 | ID | school | 1602100 | 2 | JOINT SCHOOL DISTRICT NO. 2 | 160210000931 | 594 | PATHWAYS MIDDLE SCHOOL | Alternative School | No | Middle | 06 | 08 | 2020 | k_12_total | 131 | 3 | 8 | 2 | 0 | 0 | 7 | 99 | 52 | 60 | 151 | 131 | 3 | 8 | 2 | 0 | 0 | 7 | 99 | 52 | 60 | 151 | ||||||||||||||||||||||||||||||||
849135 | 849135 | ID | school | 1602100 | 2 | JOINT SCHOOL DISTRICT NO. 2 | 160210000903 | 597 | CENTRAL ACADEMY HIGH SCHOOL | Alternative School | No | High | 09 | 12 | 2020 | grade_10 | 20 | 1 | 4 | 3 | 0 | 0 | 2 | 15 | 15 | 12 | 30 | 20 | 1 | 4 | 3 | 0 | 0 | 2 | 15 | 15 | 12 | 30 | ||||||||||||||||||||||||||||||||
849136 | 849136 | ID | school | 1602100 | 2 | JOINT SCHOOL DISTRICT NO. 2 | 160210000903 | 597 | CENTRAL ACADEMY HIGH SCHOOL | Alternative School | No | High | 09 | 12 | 2020 | grade_11 | 33 | 1 | 1 | 0 | 0 | 0 | 2 | 24 | 13 | 13 | 37 | 33 | 1 | 1 | 0 | 0 | 0 | 2 | 24 | 13 | 13 | 37 | ||||||||||||||||||||||||||||||||
849137 | 849137 | ID | school | 1602100 | 2 | JOINT SCHOOL DISTRICT NO. 2 | 160210000903 | 597 | CENTRAL ACADEMY HIGH SCHOOL | Alternative School | No | High | 09 | 12 | 2020 | grade_12 | 42 | 1 | 10 | 2 | 0 | 0 | 2 | 31 | 26 | 18 | 57 | 42 | 1 | 10 | 2 | 0 | 0 | 2 | 31 | 26 | 18 | 57 | ||||||||||||||||||||||||||||||||
849138 | 849138 | ID | school | 1602100 | 2 | JOINT SCHOOL DISTRICT NO. 2 | 160210000903 | 597 | CENTRAL ACADEMY HIGH SCHOOL | Alternative School | No | High | 09 | 12 | 2020 | grade_9 | 22 | 0 | 2 | 2 | 0 | 0 | 2 | 16 | 12 | 10 | 28 | 22 | 0 | 2 | 2 | 0 | 0 | 2 | 16 | 12 | 10 | 28 | ||||||||||||||||||||||||||||||||
849139 | 849139 | ID | school | 1602100 | 2 | JOINT SCHOOL DISTRICT NO. 2 | 160210000903 | 597 | CENTRAL ACADEMY HIGH SCHOOL | Alternative School | No | High | 09 | 12 | 2020 | k_12_total | 117 | 3 | 17 | 7 | 0 | 0 | 8 | 86 | 66 | 53 | 152 | 117 | 3 | 17 | 7 | 0 | 0 | 8 | 86 | 66 | 53 | 152 | ||||||||||||||||||||||||||||||||
849152 | 849152 | ID | school | 1602100 | 2 | JOINT SCHOOL DISTRICT NO. 2 | 160210000466 | 982 | EAGLE ACADEMY | Alternative School | No | High | 09 | 12 | 2020 | grade_10 | 44 | 1 | 2 | 0 | 0 | 0 | 1 | 31 | 17 | * | 48 | 44 | 1 | 2 | 0 | 0 | 0 | 1 | 31 | 17 | 48 | |||||||||||||||||||||||||||||||||
849153 | 849153 | ID | school | 1602100 | 2 | JOINT SCHOOL DISTRICT NO. 2 | 160210000466 | 982 | EAGLE ACADEMY | Alternative School | No | High | 09 | 12 | 2020 | grade_11 | 51 | 0 | 6 | 0 | 0 | 0 | 4 | 39 | 22 | 18 | 61 | 51 | 0 | 6 | 0 | 0 | 0 | 4 | 39 | 22 | 18 | 61 | ||||||||||||||||||||||||||||||||
849154 | 849154 | ID | school | 1602100 | 2 | JOINT SCHOOL DISTRICT NO. 2 | 160210000466 | 982 | EAGLE ACADEMY | Alternative School | No | High | 09 | 12 | 2020 | grade_12 | 61 | 2 | 5 | 1 | 0 | 0 | 2 | 48 | 23 | 17 | 71 | 61 | 2 | 5 | 1 | 0 | 0 | 2 | 48 | 23 | 17 | 71 | ||||||||||||||||||||||||||||||||
849155 | 849155 | ID | school | 1602100 | 2 | JOINT SCHOOL DISTRICT NO. 2 | 160210000466 | 982 | EAGLE ACADEMY | Alternative School | No | High | 09 | 12 | 2020 | grade_9 | 11 | 0 | 0 | 0 | 0 | 0 | 1 | 6 | 6 | * | 12 | 11 | 0 | 0 | 0 | 0 | 0 | 1 | 6 | 6 | 12 | |||||||||||||||||||||||||||||||||
849156 | 849156 | ID | school | 1602100 | 2 | JOINT SCHOOL DISTRICT NO. 2 | 160210000466 | 982 | EAGLE ACADEMY | Alternative School | No | High | 09 | 12 | 2020 | k_12_total | 167 | 3 | 13 | 1 | 0 | 0 | 8 | 124 | 68 | 60 | 192 | 167 | 3 | 13 | 1 | 0 | 0 | 8 | 124 | 68 | 60 | 192 | ||||||||||||||||||||||||||||||||
849157 | 849157 | ID | school | 1602100 | 2 | JOINT SCHOOL DISTRICT NO. 2 | 160210000602 | 1145 | CROSSROADS MIDDLE SCHOOL | Alternative School | No | Middle | 06 | 08 | 2020 | grade_6 | 41 | 0 | 4 | 0 | 0 | 0 | 4 | 29 | 20 | 23 | 49 | 41 | 0 | 4 | 0 | 0 | 0 | 4 | 29 | 20 | 23 | 49 | ||||||||||||||||||||||||||||||||
849158 | 849158 | ID | school | 1602100 | 2 | JOINT SCHOOL DISTRICT NO. 2 | 160210000602 | 1145 | CROSSROADS MIDDLE SCHOOL | Alternative School | No | Middle | 06 | 08 | 2020 | grade_7 | 40 | 0 | 5 | 0 | 0 | 0 | 3 | 30 | 18 | 28 | 48 | 40 | 0 | 5 | 0 | 0 | 0 | 3 | 30 | 18 | 28 | 48 | ||||||||||||||||||||||||||||||||
849159 | 849159 | ID | school | 1602100 | 2 | JOINT SCHOOL DISTRICT NO. 2 | 160210000602 | 1145 | CROSSROADS MIDDLE SCHOOL | Alternative School | No | Middle | 06 | 08 | 2020 | grade_8 | 44 | 0 | 5 | 0 | 0 | 0 | 1 | 26 | 24 | 25 | 50 | 44 | 0 | 5 | 0 | 0 | 0 | 1 | 26 | 24 | 25 | 50 | ||||||||||||||||||||||||||||||||
849160 | 849160 | ID | school | 1602100 | 2 | JOINT SCHOOL DISTRICT NO. 2 | 160210000602 | 1145 | CROSSROADS MIDDLE SCHOOL | Alternative School | No | Middle | 06 | 08 | 2020 | k_12_total | 125 | 0 | 14 | 0 | 0 | 0 | 8 | 85 | 62 | 76 | 147 | 125 | 0 | 14 | 0 | 0 | 0 | 8 | 85 | 62 | 76 | 147 | ||||||||||||||||||||||||||||||||
849161 | 849161 | ID | school | 1602100 | 2 | JOINT SCHOOL DISTRICT NO. 2 | 160210000714 | 1228 | MERIDIAN ACADEMY | Alternative School | No | High | 09 | 12 | 2020 | grade_10 | 42 | 0 | 4 | 1 | 1 | 0 | 0 | 32 | 16 | 24 | 48 | 42 | 0 | 4 | 1 | 1 | 0 | 0 | 32 | 16 | 24 | 48 | ||||||||||||||||||||||||||||||||
849162 | 849162 | ID | school | 1602100 | 2 | JOINT SCHOOL DISTRICT NO. 2 | 160210000714 | 1228 | MERIDIAN ACADEMY | Alternative School | No | High | 09 | 12 | 2020 | grade_11 | 43 | 0 | 2 | 0 | 1 | 0 | 0 | 21 | 25 | 18 | 46 | 43 | 0 | 2 | 0 | 1 | 0 | 0 | 21 | 25 | 18 | 46 | ||||||||||||||||||||||||||||||||
849163 | 849163 | ID | school | 1602100 | 2 | JOINT SCHOOL DISTRICT NO. 2 | 160210000714 | 1228 | MERIDIAN ACADEMY | Alternative School | No | High | 09 | 12 | 2020 | grade_12 | 44 | 0 | 6 | 0 | 0 | 0 | 2 | 32 | 20 | * | 52 | 44 | 0 | 6 | 0 | 0 | 0 | 2 | 32 | 20 | 52 | |||||||||||||||||||||||||||||||||
849164 | 849164 | ID | school | 1602100 | 2 | JOINT SCHOOL DISTRICT NO. 2 | 160210000714 | 1228 | MERIDIAN ACADEMY | Alternative School | No | High | 09 | 12 | 2020 | grade_9 | 25 | 1 | 2 | 1 | 0 | 0 | 2 | 20 | 11 | * | 31 | 25 | 1 | 2 | 1 | 0 | 0 | 2 | 20 | 11 | 31 | |||||||||||||||||||||||||||||||||
849165 | 849165 | ID | school | 1602100 | 2 | JOINT SCHOOL DISTRICT NO. 2 | 160210000714 | 1228 | MERIDIAN ACADEMY | Alternative School | No | High | 09 | 12 | 2020 | k_12_total | 154 | 1 | 14 | 2 | 2 | 0 | 4 | 105 | 72 | 63 | 177 | 154 | 1 | 14 | 2 | 2 | 0 | 4 | 105 | 72 | 63 | 177 | ||||||||||||||||||||||||||||||||
849178 | 849178 | ID | school | 1602100 | 2 | JOINT SCHOOL DISTRICT NO. 2 | 160210001025 | 1297 | REBOUND SCHOOL OF OPPORTUNITY | Alternative School | No | High | 06 | 12 | 2020 | grade_10 | 14 | 1 | 4 | 0 | 0 | 0 | 1 | 8 | 12 | * | 20 | 14 | 1 | 4 | 0 | 0 | 0 | 1 | 8 | 12 | 20 | |||||||||||||||||||||||||||||||||
849179 | 849179 | ID | school | 1602100 | 2 | JOINT SCHOOL DISTRICT NO. 2 | 160210001025 | 1297 | REBOUND SCHOOL OF OPPORTUNITY | Alternative School | No | High | 06 | 12 | 2020 | grade_11 | 30 | 1 | 9 | 1 | 3 | 0 | 2 | 28 | 18 | * | 46 | 30 | 1 | 9 | 1 | 3 | 0 | 2 | 28 | 18 | 46 | |||||||||||||||||||||||||||||||||
849180 | 849180 | ID | school | 1602100 | 2 | JOINT SCHOOL DISTRICT NO. 2 | 160210001025 | 1297 | REBOUND SCHOOL OF OPPORTUNITY | Alternative School | No | High | 06 | 12 | 2020 | grade_12 | 67 | 4 | 18 | 0 | 1 | 1 | 3 | 57 | 37 | 31 | 94 | 67 | 4 | 18 | 0 | 1 | 1 | 3 | 57 | 37 | 31 | 94 | ||||||||||||||||||||||||||||||||
849181 | 849181 | ID | school | 1602100 | 2 | JOINT SCHOOL DISTRICT NO. 2 | 160210001025 | 1297 | REBOUND SCHOOL OF OPPORTUNITY | Alternative School | No | High | 06 | 12 | 2020 | grade_7 | 2 | 0 | 0 | 0 | 0 | 0 | 0 | 2 | 0 | * | 2 | 2 | 0 | 0 | 0 | 0 | 0 | 0 | 2 | 0 | 2 | |||||||||||||||||||||||||||||||||
849182 | 849182 | ID | school | 1602100 | 2 | JOINT SCHOOL DISTRICT NO. 2 | 160210001025 | 1297 | REBOUND SCHOOL OF OPPORTUNITY | Alternative School | No | High | 06 | 12 | 2020 | grade_9 | 1 | 0 | 1 | 0 | 0 | 0 | 0 | 1 | 1 | * | 2 | 1 | 0 | 1 | 0 | 0 | 0 | 0 | 1 | 1 | 2 | |||||||||||||||||||||||||||||||||
849183 | 849183 | ID | school | 1602100 | 2 | JOINT SCHOOL DISTRICT NO. 2 | 160210001025 | 1297 | REBOUND SCHOOL OF OPPORTUNITY | Alternative School | No | High | 06 | 12 | 2020 | k_12_total | 114 | 6 | 32 | 1 | 4 | 1 | 6 | 96 | 68 | 51 | 164 | 114 | 6 | 32 | 1 | 4 | 1 | 6 | 96 | 68 | 51 | 164 | ||||||||||||||||||||||||||||||||
849268 | 849268 | ID | school | 1601770 | 3 | KUNA JOINT DISTRICT | 160177000962 | 1115 | INITIAL POINT HIGH SCHOOL | Alternative School | No | High | 09 | 12 | 2020 | grade_10 | 14 | 0 | 1 | 0 | 0 | 0 | 0 | 9 | 6 | 7 | 15 | 14 | 0 | 1 | 0 | 0 | 0 | 0 | 9 | 6 | 7 | 15 | ||||||||||||||||||||||||||||||||
849269 | 849269 | ID | school | 1601770 | 3 | KUNA JOINT DISTRICT | 160177000962 | 1115 | INITIAL POINT HIGH SCHOOL | Alternative School | No | High | 09 | 12 | 2020 | grade_11 | 20 | 0 | 7 | 0 | 0 | 0 | 2 | 10 | 19 | 10 | 29 | 20 | 0 | 7 | 0 | 0 | 0 | 2 | 10 | 19 | 10 | 29 | ||||||||||||||||||||||||||||||||
849270 | 849270 | ID | school | 1601770 | 3 | KUNA JOINT DISTRICT | 160177000962 | 1115 | INITIAL POINT HIGH SCHOOL | Alternative School | No | High | 09 | 12 | 2020 | grade_12 | 34 | 1 | 4 | 1 | 0 | 0 | 1 | 24 | 17 | 19 | 41 | 34 | 1 | 4 | 1 | 0 | 0 | 1 | 24 | 17 | 19 | 41 | ||||||||||||||||||||||||||||||||
849271 | 849271 | ID | school | 1601770 | 3 | KUNA JOINT DISTRICT | 160177000962 | 1115 | INITIAL POINT HIGH SCHOOL | Alternative School | No | High | 09 | 12 | 2020 | grade_9 | 7 | 0 | 3 | 0 | 0 | 0 | 1 | 5 | 6 | 5 | 11 | 7 | 0 | 3 | 0 | 0 | 0 | 1 | 5 | 6 | 5 | 11 | ||||||||||||||||||||||||||||||||
849272 | 849272 | ID | school | 1601770 | 3 | KUNA JOINT DISTRICT | 160177000962 | 1115 | INITIAL POINT HIGH SCHOOL | Alternative School | No | High | 09 | 12 | 2020 | k_12_total | 75 | 1 | 15 | 1 | 0 | 0 | 4 | 48 | 48 | 41 | 96 | 75 | 1 | 15 | 1 | 0 | 0 | 4 | 48 | 48 | 41 | 96 | ||||||||||||||||||||||||||||||||
849471 | 849471 | ID | school | 1602640 | 25 | POCATELLO DISTRICT | 160264000686 | 1002 | KINPORT MIDDLE SCHOOL | Alternative School | No | Middle | 06 | 08 | 2020 | grade_7 | 4 | 0 | 3 | 1 | 0 | 0 | 0 | 8 | 0 | * | 8 | 4 | 0 | 3 | 1 | 0 | 0 | 0 | 8 | 0 | 8 | |||||||||||||||||||||||||||||||||
849472 | 849472 | ID | school | 1602640 | 25 | POCATELLO DISTRICT | 160264000686 | 1002 | KINPORT MIDDLE SCHOOL | Alternative School | No | Middle | 06 | 08 | 2020 | grade_8 | 6 | 0 | 1 | 1 | 0 | 0 | 1 | 7 | 2 | * | 9 | 6 | 0 | 1 | 1 | 0 | 0 | 1 | 7 | 2 | 9 | |||||||||||||||||||||||||||||||||
849473 | 849473 | ID | school | 1602640 | 25 | POCATELLO DISTRICT | 160264000686 | 1002 | KINPORT MIDDLE SCHOOL | Alternative School | No | Middle | 06 | 08 | 2020 | k_12_total | 10 | 0 | 4 | 2 | 0 | 0 | 1 | 15 | 2 | * | 17 | 10 | 0 | 4 | 2 | 0 | 0 | 1 | 15 | 2 | 17 | |||||||||||||||||||||||||||||||||
849474 | 849474 | ID | school | 1602640 | 25 | POCATELLO DISTRICT | 160264000468 | 1141 | NEW HORIZON HIGH SCHOOL | Alternative School | No | High | 09 | 12 | 2020 | grade_10 | 20 | 1 | 3 | 2 | 0 | 0 | 0 | 17 | 9 | * | 26 | 20 | 1 | 3 | 2 | 0 | 0 | 0 | 17 | 9 | 26 | |||||||||||||||||||||||||||||||||
849475 | 849475 | ID | school | 1602640 | 25 | POCATELLO DISTRICT | 160264000468 | 1141 | NEW HORIZON HIGH SCHOOL | Alternative School | No | High | 09 | 12 | 2020 | grade_11 | 48 | 1 | 17 | 4 | 0 | 0 | 0 | 48 | 22 | * | 70 | 48 | 1 | 17 | 4 | 0 | 0 | 0 | 48 | 22 | 70 | |||||||||||||||||||||||||||||||||
849476 | 849476 | ID | school | 1602640 | 25 | POCATELLO DISTRICT | 160264000468 | 1141 | NEW HORIZON HIGH SCHOOL | Alternative School | No | High | 09 | 12 | 2020 | grade_12 | 36 | 1 | 13 | 6 | 0 | 1 | 1 | 25 | 33 | * | 58 | 36 | 1 | 13 | 6 | 0 | 1 | 1 | 25 | 33 | 58 | |||||||||||||||||||||||||||||||||
849477 | 849477 | ID | school | 1602640 | 25 | POCATELLO DISTRICT | 160264000468 | 1141 | NEW HORIZON HIGH SCHOOL | Alternative School | No | High | 09 | 12 | 2020 | grade_9 | 4 | 0 | 4 | 0 | 0 | 0 | 0 | 5 | 3 | * | 8 | 4 | 0 | 4 | 0 | 0 | 0 | 0 | 5 | 3 | 8 | |||||||||||||||||||||||||||||||||
849478 | 849478 | ID | school | 1602640 | 25 | POCATELLO DISTRICT | 160264000468 | 1141 | NEW HORIZON HIGH SCHOOL | Alternative School | No | High | 09 | 12 | 2020 | k_12_total | 108 | 3 | 37 | 12 | 0 | 1 | 1 | 95 | 67 | 117 | 162 | 108 | 3 | 37 | 12 | 0 | 1 | 1 | 95 | 67 | 117 | 162 | ||||||||||||||||||||||||||||||||
849479 | 849479 | ID | school | 1602640 | 25 | POCATELLO DISTRICT | 160264000186 | 9034 | POCATELLO JUVENILE DETENTION | Alternative School | No | Other | 01 | 12 | 2020 | grade_10 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | * | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | |||||||||||||||||||||||||||||||||
849480 | 849480 | ID | school | 1602640 | 25 | POCATELLO DISTRICT | 160264000186 | 9034 | POCATELLO JUVENILE DETENTION | Alternative School | No | Other | 01 | 12 | 2020 | grade_11 | 2 | 0 | 0 | 1 | 0 | 0 | 0 | 1 | 2 | * | 3 | 2 | 0 | 0 | 1 | 0 | 0 | 0 | 1 | 2 | 3 |
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]);