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 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
1730297	AK	school	200770	2	Denali Borough Schools	20077000354	20010	Anderson School	Regular School	No	Other	KG	12.0	2020	grade_3	0.0	0.0	0.0				0	0	0	0				0
1730307	AK	school	200770	2	Denali Borough Schools	20077000354	20010	Anderson School	Regular School	No	Other	KG	12.0	2020	pre_kindergarten	0.0	0.0	0.0				0	0	0	0				0
1730309	AK	school	200770	2	Denali Borough Schools	20077000356	20030	Cantwell School	Regular School	No	Other	KG	12.0	2020	grade_10						1.0	1						1	1
1730310	AK	school	200770	2	Denali Borough Schools	20077000356	20030	Cantwell School	Regular School	No	Other	KG	12.0	2020	grade_11						0.0	0						0	0
1730312	AK	school	200770	2	Denali Borough Schools	20077000356	20030	Cantwell School	Regular School	No	Other	KG	12.0	2020	grade_2						0.0	0						0	0
1730313	AK	school	200770	2	Denali Borough Schools	20077000356	20030	Cantwell School	Regular School	No	Other	KG	12.0	2020	grade_3						0.0	0						0	0
1730315	AK	school	200770	2	Denali Borough Schools	20077000356	20030	Cantwell School	Regular School	No	Other	KG	12.0	2020	grade_5						0.0	0						0	0
1730316	AK	school	200770	2	Denali Borough Schools	20077000356	20030	Cantwell School	Regular School	No	Other	KG	12.0	2020	grade_6						0.0	1						0	1
1730317	AK	school	200770	2	Denali Borough Schools	20077000356	20030	Cantwell School	Regular School	No	Other	KG	12.0	2020	grade_7						0.0	0						0	0
1730318	AK	school	200770	2	Denali Borough Schools	20077000356	20030	Cantwell School	Regular School	No	Other	KG	12.0	2020	grade_8						0.0	1						0	1
1730319	AK	school	200770	2	Denali Borough Schools	20077000356	20030	Cantwell School	Regular School	No	Other	KG	12.0	2020	grade_9						0.0	0						0	0
1730321	AK	school	200770	2	Denali Borough Schools	20077000356	20030	Cantwell School	Regular School	No	Other	KG	12.0	2020	kindergarten						0.0	0						0	0
1730323	AK	school	200770	2	Denali Borough Schools	20077000356	20030	Cantwell School	Regular School	No	Other	KG	12.0	2020	pre_kindergarten						0.0	0						0	0
1730356	AK	school	200050	3	Alaska Gateway Schools	20005000024	30010	Dot Lake School	Regular School	No	Other	PK	12.0	2020	grade_1							0							0
1730357	AK	school	200050	3	Alaska Gateway Schools	20005000024	30010	Dot Lake School	Regular School	No	Other	PK	12.0	2020	grade_10							0							0
1730358	AK	school	200050	3	Alaska Gateway Schools	20005000024	30010	Dot Lake School	Regular School	No	Other	PK	12.0	2020	grade_11							0							0
1730359	AK	school	200050	3	Alaska Gateway Schools	20005000024	30010	Dot Lake School	Regular School	No	Other	PK	12.0	2020	grade_12							0							0
1730360	AK	school	200050	3	Alaska Gateway Schools	20005000024	30010	Dot Lake School	Regular School	No	Other	PK	12.0	2020	grade_2							4							4
1730361	AK	school	200050	3	Alaska Gateway Schools	20005000024	30010	Dot Lake School	Regular School	No	Other	PK	12.0	2020	grade_3							1							1
1730362	AK	school	200050	3	Alaska Gateway Schools	20005000024	30010	Dot Lake School	Regular School	No	Other	PK	12.0	2020	grade_4							0							0
1730363	AK	school	200050	3	Alaska Gateway Schools	20005000024	30010	Dot Lake School	Regular School	No	Other	PK	12.0	2020	grade_5							0							0
1730364	AK	school	200050	3	Alaska Gateway Schools	20005000024	30010	Dot Lake School	Regular School	No	Other	PK	12.0	2020	grade_6							2							2
1730365	AK	school	200050	3	Alaska Gateway Schools	20005000024	30010	Dot Lake School	Regular School	No	Other	PK	12.0	2020	grade_7							0							0
1730366	AK	school	200050	3	Alaska Gateway Schools	20005000024	30010	Dot Lake School	Regular School	No	Other	PK	12.0	2020	grade_8							0							0
1730369	AK	school	200050	3	Alaska Gateway Schools	20005000024	30010	Dot Lake School	Regular School	No	Other	PK	12.0	2020	kindergarten							1							1
1730371	AK	school	200050	3	Alaska Gateway Schools	20005000024	30010	Dot Lake School	Regular School	No	Other	PK	12.0	2020	pre_kindergarten							0							0
1730376	AK	school	200050	3	Alaska Gateway Schools	20005000025	30020	Eagle Community School	Regular School	No	Other	PK	12.0	2020	grade_2						0.0	0						0	0
1730380	AK	school	200050	3	Alaska Gateway Schools	20005000025	30020	Eagle Community School	Regular School	No	Other	PK	12.0	2020	grade_6						0.0	0						0	0
1730383	AK	school	200050	3	Alaska Gateway Schools	20005000025	30020	Eagle Community School	Regular School	No	Other	PK	12.0	2020	grade_9						0.0	0						0	0
1730385	AK	school	200050	3	Alaska Gateway Schools	20005000025	30020	Eagle Community School	Regular School	No	Other	PK	12.0	2020	kindergarten						0.0	0						0	0
1730452	AK	school	200050	3	Alaska Gateway Schools	20005000528	30070	Tetlin School	Regular School	No	Other	PK	12.0	2020	grade_1							4							4
1730453	AK	school	200050	3	Alaska Gateway Schools	20005000528	30070	Tetlin School	Regular School	No	Other	PK	12.0	2020	grade_10							4							4
1730454	AK	school	200050	3	Alaska Gateway Schools	20005000528	30070	Tetlin School	Regular School	No	Other	PK	12.0	2020	grade_11							2							2
1730455	AK	school	200050	3	Alaska Gateway Schools	20005000528	30070	Tetlin School	Regular School	No	Other	PK	12.0	2020	grade_12							1							1
1730456	AK	school	200050	3	Alaska Gateway Schools	20005000528	30070	Tetlin School	Regular School	No	Other	PK	12.0	2020	grade_2							2							2
1730457	AK	school	200050	3	Alaska Gateway Schools	20005000528	30070	Tetlin School	Regular School	No	Other	PK	12.0	2020	grade_3							3							3
1730458	AK	school	200050	3	Alaska Gateway Schools	20005000528	30070	Tetlin School	Regular School	No	Other	PK	12.0	2020	grade_4							4							4
1730459	AK	school	200050	3	Alaska Gateway Schools	20005000528	30070	Tetlin School	Regular School	No	Other	PK	12.0	2020	grade_5							3							3
1730460	AK	school	200050	3	Alaska Gateway Schools	20005000528	30070	Tetlin School	Regular School	No	Other	PK	12.0	2020	grade_6							4							4
1730461	AK	school	200050	3	Alaska Gateway Schools	20005000528	30070	Tetlin School	Regular School	No	Other	PK	12.0	2020	grade_7							2							2
1730462	AK	school	200050	3	Alaska Gateway Schools	20005000528	30070	Tetlin School	Regular School	No	Other	PK	12.0	2020	grade_8							3							3
1730465	AK	school	200050	3	Alaska Gateway Schools	20005000528	30070	Tetlin School	Regular School	No	Other	PK	12.0	2020	kindergarten							4							4
1730467	AK	school	200050	3	Alaska Gateway Schools	20005000528	30070	Tetlin School	Regular School	No	Other	PK	12.0	2020	pre_kindergarten							0							0
1730483	AK	school	200050	3	Alaska Gateway Schools	20005000023	38010	Alaska REACH Academy	Regular School	No	Other	PK	12.0	2020	pre_kindergarten		0.0		0.0		0.0	0		0		0		0	0
1730500	AK	school	200010	4	Aleutian Region Schools	20001000080	40080	Adak School	Regular School	No	Other	PK	12.0	2020	grade_1		3.0		0.0	0.0		3		3		0	0		3
1730501	AK	school	200010	4	Aleutian Region Schools	20001000080	40080	Adak School	Regular School	No	Other	PK	12.0	2020	grade_10		0.0		0.0	0.0		0		0		0	0		0
1730502	AK	school	200010	4	Aleutian Region Schools	20001000080	40080	Adak School	Regular School	No	Other	PK	12.0	2020	grade_11		0.0		0.0	0.0		0		0		0	0		0
1730503	AK	school	200010	4	Aleutian Region Schools	20001000080	40080	Adak School	Regular School	No	Other	PK	12.0	2020	grade_12		0.0		0.0	0.0		1		0		0	0		1
1730504	AK	school	200010	4	Aleutian Region Schools	20001000080	40080	Adak School	Regular School	No	Other	PK	12.0	2020	grade_2		2.0		0.0	1.0		4		2		0	1		4
1730505	AK	school	200010	4	Aleutian Region Schools	20001000080	40080	Adak School	Regular School	No	Other	PK	12.0	2020	grade_3		0.0		0.0	0.0		0		0		0	0		0
1730506	AK	school	200010	4	Aleutian Region Schools	20001000080	40080	Adak School	Regular School	No	Other	PK	12.0	2020	grade_4		1.0		0.0	0.0		2		1		0	0		2
1730507	AK	school	200010	4	Aleutian Region Schools	20001000080	40080	Adak School	Regular School	No	Other	PK	12.0	2020	grade_5		0.0		1.0	1.0		2		0		1	1		2
1730509	AK	school	200010	4	Aleutian Region Schools	20001000080	40080	Adak School	Regular School	No	Other	PK	12.0	2020	grade_7		1.0		0.0	1.0		2		1		0	1		2
1730510	AK	school	200010	4	Aleutian Region Schools	20001000080	40080	Adak School	Regular School	No	Other	PK	12.0	2020	grade_8		0.0		0.0	0.0		0		0		0	0		0
1730511	AK	school	200010	4	Aleutian Region Schools	20001000080	40080	Adak School	Regular School	No	Other	PK	12.0	2020	grade_9		0.0		0.0	0.0		0		0		0	0		0
1730513	AK	school	200010	4	Aleutian Region Schools	20001000080	40080	Adak School	Regular School	No	Other	PK	12.0	2020	kindergarten		0.0		0.0	1.0		1		0		0	1		1
1730517	AK	school	200180	5	Anchorage Schools	20018000053	50010	Abbott Loop Elementary	Regular School	No	Elementary	PK	6.0	2020	grade_10	0.0	0.0		0.0	0.0	0.0	0	0	0		0	0	0	0
1730518	AK	school	200180	5	Anchorage Schools	20018000053	50010	Abbott Loop Elementary	Regular School	No	Elementary	PK	6.0	2020	grade_11	0.0	0.0		0.0	0.0	0.0	0	0	0		0	0	0	0
1730519	AK	school	200180	5	Anchorage Schools	20018000053	50010	Abbott Loop Elementary	Regular School	No	Elementary	PK	6.0	2020	grade_12	0.0	0.0		0.0	0.0	0.0	0	0	0		0	0	0	0
1730525	AK	school	200180	5	Anchorage Schools	20018000053	50010	Abbott Loop Elementary	Regular School	No	Elementary	PK	6.0	2020	grade_7	0.0	0.0		0.0	0.0	0.0	0	0	0		0	0	0	0
1730526	AK	school	200180	5	Anchorage Schools	20018000053	50010	Abbott Loop Elementary	Regular School	No	Elementary	PK	6.0	2020	grade_8	0.0	0.0		0.0	0.0	0.0	0	0	0		0	0	0	0
1730527	AK	school	200180	5	Anchorage Schools	20018000053	50010	Abbott Loop Elementary	Regular School	No	Elementary	PK	6.0	2020	grade_9	0.0	0.0		0.0	0.0	0.0	0	0	0		0	0	0	0
1730533	AK	school	200180	5	Anchorage Schools	20018000054	50020	Airport Heights Elementary	Regular School	No	Elementary	PK	6.0	2020	grade_10	0.0	0.0	0.0	0.0	0.0	0.0	0	0	0	0	0	0	0	0
1730534	AK	school	200180	5	Anchorage Schools	20018000054	50020	Airport Heights Elementary	Regular School	No	Elementary	PK	6.0	2020	grade_11	0.0	0.0	0.0	0.0	0.0	0.0	0	0	0	0	0	0	0	0
1730535	AK	school	200180	5	Anchorage Schools	20018000054	50020	Airport Heights Elementary	Regular School	No	Elementary	PK	6.0	2020	grade_12	0.0	0.0	0.0	0.0	0.0	0.0	0	0	0	0	0	0	0	0
1730541	AK	school	200180	5	Anchorage Schools	20018000054	50020	Airport Heights Elementary	Regular School	No	Elementary	PK	6.0	2020	grade_7	0.0	0.0	0.0	0.0	0.0	0.0	0	0	0	0	0	0	0	0
1730542	AK	school	200180	5	Anchorage Schools	20018000054	50020	Airport Heights Elementary	Regular School	No	Elementary	PK	6.0	2020	grade_8	0.0	0.0	0.0	0.0	0.0	0.0	0	0	0	0	0	0	0	0
1730543	AK	school	200180	5	Anchorage Schools	20018000054	50020	Airport Heights Elementary	Regular School	No	Elementary	PK	6.0	2020	grade_9	0.0	0.0	0.0	0.0	0.0	0.0	0	0	0	0	0	0	0	0
1730547	AK	school	200180	5	Anchorage Schools	20018000054	50020	Airport Heights Elementary	Regular School	No	Elementary	PK	6.0	2020	pre_kindergarten	2.0	7.0	0.0	4.0	3.0	0.0	16	2	7	0	4	3	0	16
1730549	AK	school	200180	5	Anchorage Schools	20018000506	50030	Klatt Elementary	Regular School	No	Elementary	PK	6.0	2020	grade_10	0.0	0.0	0.0	0.0	0.0	0.0	0	0	0	0	0	0	0	0
1730550	AK	school	200180	5	Anchorage Schools	20018000506	50030	Klatt Elementary	Regular School	No	Elementary	PK	6.0	2020	grade_11	0.0	0.0	0.0	0.0	0.0	0.0	0	0	0	0	0	0	0	0
1730551	AK	school	200180	5	Anchorage Schools	20018000506	50030	Klatt Elementary	Regular School	No	Elementary	PK	6.0	2020	grade_12	0.0	0.0	0.0	0.0	0.0	0.0	0	0	0	0	0	0	0	0
1730557	AK	school	200180	5	Anchorage Schools	20018000506	50030	Klatt Elementary	Regular School	No	Elementary	PK	6.0	2020	grade_7	0.0	0.0	0.0	0.0	0.0	0.0	0	0	0	0	0	0	0	0
1730558	AK	school	200180	5	Anchorage Schools	20018000506	50030	Klatt Elementary	Regular School	No	Elementary	PK	6.0	2020	grade_8	0.0	0.0	0.0	0.0	0.0	0.0	0	0	0	0	0	0	0	0
1730559	AK	school	200180	5	Anchorage Schools	20018000506	50030	Klatt Elementary	Regular School	No	Elementary	PK	6.0	2020	grade_9	0.0	0.0	0.0	0.0	0.0	0.0	0	0	0	0	0	0	0	0
1730563	AK	school	200180	5	Anchorage Schools	20018000506	50030	Klatt Elementary	Regular School	No	Elementary	PK	6.0	2020	pre_kindergarten	0.0	0.0	0.0	0.0	0.0	0.0	0	0	0	0	0	0	0	0
1730564	AK	school	200180	5	Anchorage Schools	20018000057	50050	Bartlett High School	Regular School	No	High	09	12.0	2020	grade_1	0.0	0.0	0.0	0.0	0.0	0.0	0	0	0	0	0	0	0	0
1730568	AK	school	200180	5	Anchorage Schools	20018000057	50050	Bartlett High School	Regular School	No	High	09	12.0	2020	grade_2	0.0	0.0	0.0	0.0	0.0	0.0	0	0	0	0	0	0	0	0
1730569	AK	school	200180	5	Anchorage Schools	20018000057	50050	Bartlett High School	Regular School	No	High	09	12.0	2020	grade_3	0.0	0.0	0.0	0.0	0.0	0.0	0	0	0	0	0	0	0	0
1730570	AK	school	200180	5	Anchorage Schools	20018000057	50050	Bartlett High School	Regular School	No	High	09	12.0	2020	grade_4	0.0	0.0	0.0	0.0	0.0	0.0	0	0	0	0	0	0	0	0
1730571	AK	school	200180	5	Anchorage Schools	20018000057	50050	Bartlett High School	Regular School	No	High	09	12.0	2020	grade_5	0.0	0.0	0.0	0.0	0.0	0.0	0	0	0	0	0	0	0	0
1730572	AK	school	200180	5	Anchorage Schools	20018000057	50050	Bartlett High School	Regular School	No	High	09	12.0	2020	grade_6	0.0	0.0	0.0	0.0	0.0	0.0	0	0	0	0	0	0	0	0
1730573	AK	school	200180	5	Anchorage Schools	20018000057	50050	Bartlett High School	Regular School	No	High	09	12.0	2020	grade_7	0.0	0.0	0.0	0.0	0.0	0.0	0	0	0	0	0	0	0	0
1730574	AK	school	200180	5	Anchorage Schools	20018000057	50050	Bartlett High School	Regular School	No	High	09	12.0	2020	grade_8	0.0	0.0	0.0	0.0	0.0	0.0	0	0	0	0	0	0	0	0
1730577	AK	school	200180	5	Anchorage Schools	20018000057	50050	Bartlett High School	Regular School	No	High	09	12.0	2020	kindergarten	0.0	0.0	0.0	0.0	0.0	0.0	0	0	0	0	0	0	0	0
1730579	AK	school	200180	5	Anchorage Schools	20018000057	50050	Bartlett High School	Regular School	No	High	09	12.0	2020	pre_kindergarten	0.0	0.0	0.0	0.0	0.0	0.0	0	0	0	0	0	0	0	0
1730581	AK	school	200180	5	Anchorage Schools	20018000058	50060	Baxter Elementary	Regular School	No	Elementary	PK	6.0	2020	grade_10	0.0	0.0	0.0	0.0	0.0	0.0	0	0	0	0	0	0	0	0
1730582	AK	school	200180	5	Anchorage Schools	20018000058	50060	Baxter Elementary	Regular School	No	Elementary	PK	6.0	2020	grade_11	0.0	0.0	0.0	0.0	0.0	0.0	0	0	0	0	0	0	0	0
1730583	AK	school	200180	5	Anchorage Schools	20018000058	50060	Baxter Elementary	Regular School	No	Elementary	PK	6.0	2020	grade_12	0.0	0.0	0.0	0.0	0.0	0.0	0	0	0	0	0	0	0	0
1730589	AK	school	200180	5	Anchorage Schools	20018000058	50060	Baxter Elementary	Regular School	No	Elementary	PK	6.0	2020	grade_7	0.0	0.0	0.0	0.0	0.0	0.0	0	0	0	0	0	0	0	0
1730590	AK	school	200180	5	Anchorage Schools	20018000058	50060	Baxter Elementary	Regular School	No	Elementary	PK	6.0	2020	grade_8	0.0	0.0	0.0	0.0	0.0	0.0	0	0	0	0	0	0	0	0
1730591	AK	school	200180	5	Anchorage Schools	20018000058	50060	Baxter Elementary	Regular School	No	Elementary	PK	6.0	2020	grade_9	0.0	0.0	0.0	0.0	0.0	0.0	0	0	0	0	0	0	0	0
1730595	AK	school	200180	5	Anchorage Schools	20018000058	50060	Baxter Elementary	Regular School	No	Elementary	PK	6.0	2020	pre_kindergarten	0.0	0.0	0.0	0.0	0.0	0.0	0	0	0	0	0	0	0	0
1730597	AK	school	200180	5	Anchorage Schools	20018000060	50070	Birchwood ABC Elementary	Regular School	No	Elementary	PK	6.0	2020	grade_10	0.0	0.0	0.0	0.0	0.0	0.0	0	0	0	0	0	0	0	0
1730598	AK	school	200180	5	Anchorage Schools	20018000060	50070	Birchwood ABC Elementary	Regular School	No	Elementary	PK	6.0	2020	grade_11	0.0	0.0	0.0	0.0	0.0	0.0	0	0	0	0	0	0	0	0
1730599	AK	school	200180	5	Anchorage Schools	20018000060	50070	Birchwood ABC Elementary	Regular School	No	Elementary	PK	6.0	2020	grade_12	0.0	0.0	0.0	0.0	0.0	0.0	0	0	0	0	0	0	0	0
1730605	AK	school	200180	5	Anchorage Schools	20018000060	50070	Birchwood ABC Elementary	Regular School	No	Elementary	PK	6.0	2020	grade_7	0.0	0.0	0.0	0.0	0.0	0.0	0	0	0	0	0	0	0	0
1730606	AK	school	200180	5	Anchorage Schools	20018000060	50070	Birchwood ABC Elementary	Regular School	No	Elementary	PK	6.0	2020	grade_8	0.0	0.0	0.0	0.0	0.0	0.0	0	0	0	0	0	0	0	0
1730607	AK	school	200180	5	Anchorage Schools	20018000060	50070	Birchwood ABC Elementary	Regular School	No	Elementary	PK	6.0	2020	grade_9	0.0	0.0	0.0	0.0	0.0	0.0	0	0	0	0	0	0	0	0
1730613	AK	school	200180	5	Anchorage Schools	20018000062	50080	Campbell STEM Elementary	Regular School	No	Elementary	PK	6.0	2020	grade_10	0.0	0.0	0.0	0.0	0.0	0.0	0	0	0	0	0	0	0	0
1730614	AK	school	200180	5	Anchorage Schools	20018000062	50080	Campbell STEM Elementary	Regular School	No	Elementary	PK	6.0	2020	grade_11	0.0	0.0	0.0	0.0	0.0	0.0	0	0	0	0	0	0	0	0