schools

Data source: Big Local News · About: Big Local

Custom SQL query returning 101 rows (hide)

select 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 from enrollments where "state" = :p0 and "year" = :p1 order by white_int limit 101

Query parameters

This data as json, CSV

rowid	state	admin_level	district_nces_id	district_state_id	district	school_nces_id	school_state_id	school	ccd_school_type	ccd_charter_school	ccd_school_lvl	ccd_school_low_grade	ccd_school_high_grade	year	grade	black	hispanic	native_american	asian	native_hawaiian_pacific_islander	multiracial	total	black_int	hispanic_int	native_american_int	asian_int	native_hawaiian_pacific_islander_int	multiracial_int	total_int
1812632	AK	school	200770	2	Denali Borough Schools	20077000354	20010	Anderson School	Regular School	No	Other	PK	12	2021	grade_3		0.0	0.0	0.0		0.0	0.0		0	0	0		0	0
1812642	AK	school	200770	2	Denali Borough Schools	20077000354	20010	Anderson School	Regular School	No	Other	PK	12	2021	pre_kindergarten		0.0	0.0	0.0		0.0	0.0		0	0	0		0	0
1812643	AK	school	200770	2	Denali Borough Schools	20077000356	20030	Cantwell School	Regular School	No	Other	PK	12	2021	grade_1						1.0	1.0						1	1
1812644	AK	school	200770	2	Denali Borough Schools	20077000356	20030	Cantwell School	Regular School	No	Other	PK	12	2021	grade_10						0.0	0.0						0	0
1812645	AK	school	200770	2	Denali Borough Schools	20077000356	20030	Cantwell School	Regular School	No	Other	PK	12	2021	grade_11						1.0	1.0						1	1
1812646	AK	school	200770	2	Denali Borough Schools	20077000356	20030	Cantwell School	Regular School	No	Other	PK	12	2021	grade_12						0.0	0.0						0	0
1812648	AK	school	200770	2	Denali Borough Schools	20077000356	20030	Cantwell School	Regular School	No	Other	PK	12	2021	grade_3						0.0	0.0						0	0
1812649	AK	school	200770	2	Denali Borough Schools	20077000356	20030	Cantwell School	Regular School	No	Other	PK	12	2021	grade_4						0.0	0.0						0	0
1812650	AK	school	200770	2	Denali Borough Schools	20077000356	20030	Cantwell School	Regular School	No	Other	PK	12	2021	grade_5						0.0	0.0						0	0
1812652	AK	school	200770	2	Denali Borough Schools	20077000356	20030	Cantwell School	Regular School	No	Other	PK	12	2021	grade_7						0.0	1.0						0	1
1812653	AK	school	200770	2	Denali Borough Schools	20077000356	20030	Cantwell School	Regular School	No	Other	PK	12	2021	grade_8						0.0	0.0						0	0
1812654	AK	school	200770	2	Denali Borough Schools	20077000356	20030	Cantwell School	Regular School	No	Other	PK	12	2021	grade_9						0.0	1.0						0	1
1812656	AK	school	200770	2	Denali Borough Schools	20077000356	20030	Cantwell School	Regular School	No	Other	PK	12	2021	kindergarten						0.0	1.0						0	1
1812658	AK	school	200770	2	Denali Borough Schools	20077000356	20030	Cantwell School	Regular School	No	Other	PK	12	2021	pre_kindergarten						0.0	0.0						0	0
1812691	AK	school	200050	3	Alaska Gateway Schools	20005000024	30010	Dot Lake School	Regular School	No	Other	PK	12	2021	grade_1						0.0	1.0						0	1
1812693	AK	school	200050	3	Alaska Gateway Schools	20005000024	30010	Dot Lake School	Regular School	No	Other	PK	12	2021	grade_11						0.0	0.0						0	0
1812694	AK	school	200050	3	Alaska Gateway Schools	20005000024	30010	Dot Lake School	Regular School	No	Other	PK	12	2021	grade_12						0.0	1.0						0	1
1812695	AK	school	200050	3	Alaska Gateway Schools	20005000024	30010	Dot Lake School	Regular School	No	Other	PK	12	2021	grade_2						0.0	0.0						0	0
1812696	AK	school	200050	3	Alaska Gateway Schools	20005000024	30010	Dot Lake School	Regular School	No	Other	PK	12	2021	grade_3						0.0	2.0						0	2
1812697	AK	school	200050	3	Alaska Gateway Schools	20005000024	30010	Dot Lake School	Regular School	No	Other	PK	12	2021	grade_4						0.0	1.0						0	1
1812698	AK	school	200050	3	Alaska Gateway Schools	20005000024	30010	Dot Lake School	Regular School	No	Other	PK	12	2021	grade_5						0.0	0.0						0	0
1812699	AK	school	200050	3	Alaska Gateway Schools	20005000024	30010	Dot Lake School	Regular School	No	Other	PK	12	2021	grade_6						0.0	0.0						0	0
1812700	AK	school	200050	3	Alaska Gateway Schools	20005000024	30010	Dot Lake School	Regular School	No	Other	PK	12	2021	grade_7						1.0	2.0						1	2
1812701	AK	school	200050	3	Alaska Gateway Schools	20005000024	30010	Dot Lake School	Regular School	No	Other	PK	12	2021	grade_8						0.0	0.0						0	0
1812702	AK	school	200050	3	Alaska Gateway Schools	20005000024	30010	Dot Lake School	Regular School	No	Other	PK	12	2021	grade_9						1.0	1.0						1	1
1812706	AK	school	200050	3	Alaska Gateway Schools	20005000024	30010	Dot Lake School	Regular School	No	Other	PK	12	2021	pre_kindergarten						0.0	0.0						0	0
1812707	AK	school	200050	3	Alaska Gateway Schools	20005000025	30020	Eagle Community School	Regular School	No	Other	PK	12	2021	grade_1						0.0	1.0						0	1
1812708	AK	school	200050	3	Alaska Gateway Schools	20005000025	30020	Eagle Community School	Regular School	No	Other	PK	12	2021	grade_10						0.0	1.0						0	1
1812712	AK	school	200050	3	Alaska Gateway Schools	20005000025	30020	Eagle Community School	Regular School	No	Other	PK	12	2021	grade_3						0.0	0.0						0	0
1812716	AK	school	200050	3	Alaska Gateway Schools	20005000025	30020	Eagle Community School	Regular School	No	Other	PK	12	2021	grade_7						0.0	0.0						0	0
1812722	AK	school	200050	3	Alaska Gateway Schools	20005000025	30020	Eagle Community School	Regular School	No	Other	PK	12	2021	pre_kindergarten						0.0	0.0						0	0
1812835	AK	school	200010	4	Aleutian Region Schools	20001000080	40080	Adak School	Regular School	No	Other	KG	12	2021	grade_1		1.0		0.0	1.0		2.0		1		0	1		2
1812836	AK	school	200010	4	Aleutian Region Schools	20001000080	40080	Adak School	Regular School	No	Other	KG	12	2021	grade_10		0.0		0.0	0.0		0.0		0		0	0		0
1812837	AK	school	200010	4	Aleutian Region Schools	20001000080	40080	Adak School	Regular School	No	Other	KG	12	2021	grade_11		0.0		0.0	0.0		0.0		0		0	0		0
1812838	AK	school	200010	4	Aleutian Region Schools	20001000080	40080	Adak School	Regular School	No	Other	KG	12	2021	grade_12		0.0		0.0	0.0		1.0		0		0	0		1
1812839	AK	school	200010	4	Aleutian Region Schools	20001000080	40080	Adak School	Regular School	No	Other	KG	12	2021	grade_2		0.0		0.0	0.0		0.0		0		0	0		0
1812840	AK	school	200010	4	Aleutian Region Schools	20001000080	40080	Adak School	Regular School	No	Other	KG	12	2021	grade_3		2.0		0.0	1.0		4.0		2		0	1		4
1812841	AK	school	200010	4	Aleutian Region Schools	20001000080	40080	Adak School	Regular School	No	Other	KG	12	2021	grade_4		0.0		0.0	0.0		0.0		0		0	0		0
1812842	AK	school	200010	4	Aleutian Region Schools	20001000080	40080	Adak School	Regular School	No	Other	KG	12	2021	grade_5		1.0		0.0	0.0		2.0		1		0	0		2
1812843	AK	school	200010	4	Aleutian Region Schools	20001000080	40080	Adak School	Regular School	No	Other	KG	12	2021	grade_6		0.0		1.0	1.0		2.0		0		1	1		2
1812844	AK	school	200010	4	Aleutian Region Schools	20001000080	40080	Adak School	Regular School	No	Other	KG	12	2021	grade_7		0.0		0.0	0.0		1.0		0		0	0		1
1812845	AK	school	200010	4	Aleutian Region Schools	20001000080	40080	Adak School	Regular School	No	Other	KG	12	2021	grade_8		1.0		0.0	1.0		2.0		1		0	1		2
1812846	AK	school	200010	4	Aleutian Region Schools	20001000080	40080	Adak School	Regular School	No	Other	KG	12	2021	grade_9		0.0		0.0	0.0		0.0		0		0	0		0
1812850	AK	school	200010	4	Aleutian Region Schools	20001000080	40080	Adak School	Regular School	No	Other	KG	12	2021	pre_kindergarten		0.0		0.0	0.0		0.0		0		0	0		0
1812852	AK	school	200180	5	Anchorage Schools	20018000053	50010	Abbott Loop Elementary	Regular School	No	Elementary	PK	6	2021	grade_10	0.0	0.0		0.0	0.0	0.0	0.0	0	0		0	0	0	0
1812853	AK	school	200180	5	Anchorage Schools	20018000053	50010	Abbott Loop Elementary	Regular School	No	Elementary	PK	6	2021	grade_11	0.0	0.0		0.0	0.0	0.0	0.0	0	0		0	0	0	0
1812854	AK	school	200180	5	Anchorage Schools	20018000053	50010	Abbott Loop Elementary	Regular School	No	Elementary	PK	6	2021	grade_12	0.0	0.0		0.0	0.0	0.0	0.0	0	0		0	0	0	0
1812860	AK	school	200180	5	Anchorage Schools	20018000053	50010	Abbott Loop Elementary	Regular School	No	Elementary	PK	6	2021	grade_7	0.0	0.0		0.0	0.0	0.0	0.0	0	0		0	0	0	0
1812861	AK	school	200180	5	Anchorage Schools	20018000053	50010	Abbott Loop Elementary	Regular School	No	Elementary	PK	6	2021	grade_8	0.0	0.0		0.0	0.0	0.0	0.0	0	0		0	0	0	0
1812862	AK	school	200180	5	Anchorage Schools	20018000053	50010	Abbott Loop Elementary	Regular School	No	Elementary	PK	6	2021	grade_9	0.0	0.0		0.0	0.0	0.0	0.0	0	0		0	0	0	0
1812868	AK	school	200180	5	Anchorage Schools	20018000054	50020	Airport Heights Elementary	Regular School	No	Elementary	PK	6	2021	grade_10	0.0	0.0		0.0	0.0	0.0	0.0	0	0		0	0	0	0
1812869	AK	school	200180	5	Anchorage Schools	20018000054	50020	Airport Heights Elementary	Regular School	No	Elementary	PK	6	2021	grade_11	0.0	0.0		0.0	0.0	0.0	0.0	0	0		0	0	0	0
1812870	AK	school	200180	5	Anchorage Schools	20018000054	50020	Airport Heights Elementary	Regular School	No	Elementary	PK	6	2021	grade_12	0.0	0.0		0.0	0.0	0.0	0.0	0	0		0	0	0	0
1812876	AK	school	200180	5	Anchorage Schools	20018000054	50020	Airport Heights Elementary	Regular School	No	Elementary	PK	6	2021	grade_7	0.0	0.0		0.0	0.0	0.0	0.0	0	0		0	0	0	0
1812877	AK	school	200180	5	Anchorage Schools	20018000054	50020	Airport Heights Elementary	Regular School	No	Elementary	PK	6	2021	grade_8	0.0	0.0		0.0	0.0	0.0	0.0	0	0		0	0	0	0
1812878	AK	school	200180	5	Anchorage Schools	20018000054	50020	Airport Heights Elementary	Regular School	No	Elementary	PK	6	2021	grade_9	0.0	0.0		0.0	0.0	0.0	0.0	0	0		0	0	0	0
1812882	AK	school	200180	5	Anchorage Schools	20018000054	50020	Airport Heights Elementary	Regular School	No	Elementary	PK	6	2021	pre_kindergarten	0.0	1.0		1.0	1.0	0.0	4.0	0	1		1	1	0	4
1812884	AK	school	200180	5	Anchorage Schools	20018000506	50030	Klatt Elementary	Regular School	No	Elementary	PK	6	2021	grade_10	0.0	0.0		0.0	0.0	0.0	0.0	0	0		0	0	0	0
1812885	AK	school	200180	5	Anchorage Schools	20018000506	50030	Klatt Elementary	Regular School	No	Elementary	PK	6	2021	grade_11	0.0	0.0		0.0	0.0	0.0	0.0	0	0		0	0	0	0
1812886	AK	school	200180	5	Anchorage Schools	20018000506	50030	Klatt Elementary	Regular School	No	Elementary	PK	6	2021	grade_12	0.0	0.0		0.0	0.0	0.0	0.0	0	0		0	0	0	0
1812892	AK	school	200180	5	Anchorage Schools	20018000506	50030	Klatt Elementary	Regular School	No	Elementary	PK	6	2021	grade_7	0.0	0.0		0.0	0.0	0.0	0.0	0	0		0	0	0	0
1812893	AK	school	200180	5	Anchorage Schools	20018000506	50030	Klatt Elementary	Regular School	No	Elementary	PK	6	2021	grade_8	0.0	0.0		0.0	0.0	0.0	0.0	0	0		0	0	0	0
1812894	AK	school	200180	5	Anchorage Schools	20018000506	50030	Klatt Elementary	Regular School	No	Elementary	PK	6	2021	grade_9	0.0	0.0		0.0	0.0	0.0	0.0	0	0		0	0	0	0
1812898	AK	school	200180	5	Anchorage Schools	20018000506	50030	Klatt Elementary	Regular School	No	Elementary	PK	6	2021	pre_kindergarten	0.0	0.0		0.0	0.0	0.0	0.0	0	0		0	0	0	0
1812899	AK	school	200180	5	Anchorage Schools	20018000057	50050	Bartlett High School	Regular School	No	High	09	12	2021	grade_1	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0	0	0	0	0	0	0
1812903	AK	school	200180	5	Anchorage Schools	20018000057	50050	Bartlett High School	Regular School	No	High	09	12	2021	grade_2	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0	0	0	0	0	0	0
1812904	AK	school	200180	5	Anchorage Schools	20018000057	50050	Bartlett High School	Regular School	No	High	09	12	2021	grade_3	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0	0	0	0	0	0	0
1812905	AK	school	200180	5	Anchorage Schools	20018000057	50050	Bartlett High School	Regular School	No	High	09	12	2021	grade_4	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0	0	0	0	0	0	0
1812906	AK	school	200180	5	Anchorage Schools	20018000057	50050	Bartlett High School	Regular School	No	High	09	12	2021	grade_5	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0	0	0	0	0	0	0
1812907	AK	school	200180	5	Anchorage Schools	20018000057	50050	Bartlett High School	Regular School	No	High	09	12	2021	grade_6	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0	0	0	0	0	0	0
1812908	AK	school	200180	5	Anchorage Schools	20018000057	50050	Bartlett High School	Regular School	No	High	09	12	2021	grade_7	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0	0	0	0	0	0	0
1812909	AK	school	200180	5	Anchorage Schools	20018000057	50050	Bartlett High School	Regular School	No	High	09	12	2021	grade_8	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0	0	0	0	0	0	0
1812912	AK	school	200180	5	Anchorage Schools	20018000057	50050	Bartlett High School	Regular School	No	High	09	12	2021	kindergarten	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0	0	0	0	0	0	0
1812914	AK	school	200180	5	Anchorage Schools	20018000057	50050	Bartlett High School	Regular School	No	High	09	12	2021	pre_kindergarten	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0	0	0	0	0	0	0
1812916	AK	school	200180	5	Anchorage Schools	20018000058	50060	Baxter Elementary	Regular School	No	Elementary	PK	6	2021	grade_10	0.0	0.0		0.0	0.0	0.0	0.0	0	0		0	0	0	0
1812917	AK	school	200180	5	Anchorage Schools	20018000058	50060	Baxter Elementary	Regular School	No	Elementary	PK	6	2021	grade_11	0.0	0.0		0.0	0.0	0.0	0.0	0	0		0	0	0	0
1812918	AK	school	200180	5	Anchorage Schools	20018000058	50060	Baxter Elementary	Regular School	No	Elementary	PK	6	2021	grade_12	0.0	0.0		0.0	0.0	0.0	0.0	0	0		0	0	0	0
1812924	AK	school	200180	5	Anchorage Schools	20018000058	50060	Baxter Elementary	Regular School	No	Elementary	PK	6	2021	grade_7	0.0	0.0		0.0	0.0	0.0	0.0	0	0		0	0	0	0
1812925	AK	school	200180	5	Anchorage Schools	20018000058	50060	Baxter Elementary	Regular School	No	Elementary	PK	6	2021	grade_8	0.0	0.0		0.0	0.0	0.0	0.0	0	0		0	0	0	0
1812926	AK	school	200180	5	Anchorage Schools	20018000058	50060	Baxter Elementary	Regular School	No	Elementary	PK	6	2021	grade_9	0.0	0.0		0.0	0.0	0.0	0.0	0	0		0	0	0	0
1812930	AK	school	200180	5	Anchorage Schools	20018000058	50060	Baxter Elementary	Regular School	No	Elementary	PK	6	2021	pre_kindergarten	0.0	0.0		0.0	0.0	0.0	0.0	0	0		0	0	0	0
1812932	AK	school	200180	5	Anchorage Schools	20018000060	50070	Birchwood ABC Elementary	Regular School	No	Elementary	PK	6	2021	grade_10	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0	0	0	0	0	0	0
1812933	AK	school	200180	5	Anchorage Schools	20018000060	50070	Birchwood ABC Elementary	Regular School	No	Elementary	PK	6	2021	grade_11	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0	0	0	0	0	0	0
1812934	AK	school	200180	5	Anchorage Schools	20018000060	50070	Birchwood ABC Elementary	Regular School	No	Elementary	PK	6	2021	grade_12	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0	0	0	0	0	0	0
1812940	AK	school	200180	5	Anchorage Schools	20018000060	50070	Birchwood ABC Elementary	Regular School	No	Elementary	PK	6	2021	grade_7	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0	0	0	0	0	0	0
1812941	AK	school	200180	5	Anchorage Schools	20018000060	50070	Birchwood ABC Elementary	Regular School	No	Elementary	PK	6	2021	grade_8	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0	0	0	0	0	0	0
1812942	AK	school	200180	5	Anchorage Schools	20018000060	50070	Birchwood ABC Elementary	Regular School	No	Elementary	PK	6	2021	grade_9	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0	0	0	0	0	0	0
1812946	AK	school	200180	5	Anchorage Schools	20018000060	50070	Birchwood ABC Elementary	Regular School	No	Elementary	PK	6	2021	pre_kindergarten	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0	0	0	0	0	0	0
1812948	AK	school	200180	5	Anchorage Schools	20018000062	50080	Campbell STEM Elementary	Regular School	No	Elementary	PK	6	2021	grade_10	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0	0	0	0	0	0	0
1812949	AK	school	200180	5	Anchorage Schools	20018000062	50080	Campbell STEM Elementary	Regular School	No	Elementary	PK	6	2021	grade_11	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0	0	0	0	0	0	0
1812950	AK	school	200180	5	Anchorage Schools	20018000062	50080	Campbell STEM Elementary	Regular School	No	Elementary	PK	6	2021	grade_12	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0	0	0	0	0	0	0
1812956	AK	school	200180	5	Anchorage Schools	20018000062	50080	Campbell STEM Elementary	Regular School	No	Elementary	PK	6	2021	grade_7	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0	0	0	0	0	0	0
1812957	AK	school	200180	5	Anchorage Schools	20018000062	50080	Campbell STEM Elementary	Regular School	No	Elementary	PK	6	2021	grade_8	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0	0	0	0	0	0	0
1812958	AK	school	200180	5	Anchorage Schools	20018000062	50080	Campbell STEM Elementary	Regular School	No	Elementary	PK	6	2021	grade_9	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0	0	0	0	0	0	0
1812963	AK	school	200180	5	Anchorage Schools	20018000063	50100	Central Middle School of Science	Regular School	No	Middle	07	8	2021	grade_1	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0	0	0	0	0	0	0
1812964	AK	school	200180	5	Anchorage Schools	20018000063	50100	Central Middle School of Science	Regular School	No	Middle	07	8	2021	grade_10	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0	0	0	0	0	0	0
1812965	AK	school	200180	5	Anchorage Schools	20018000063	50100	Central Middle School of Science	Regular School	No	Middle	07	8	2021	grade_11	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0	0	0	0	0	0	0
1812966	AK	school	200180	5	Anchorage Schools	20018000063	50100	Central Middle School of Science	Regular School	No	Middle	07	8	2021	grade_12	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0	0	0	0	0	0	0
1812967	AK	school	200180	5	Anchorage Schools	20018000063	50100	Central Middle School of Science	Regular School	No	Middle	07	8	2021	grade_2	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0	0	0	0	0	0	0
1812968	AK	school	200180	5	Anchorage Schools	20018000063	50100	Central Middle School of Science	Regular School	No	Middle	07	8	2021	grade_3	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0	0	0	0	0	0	0
1812969	AK	school	200180	5	Anchorage Schools	20018000063	50100	Central Middle School of Science	Regular School	No	Middle	07	8	2021	grade_4	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0	0	0	0	0	0	0