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 "grade" = :p0 and "state" = :p1 order by district_state_id desc 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	white	black	hispanic	native_american	asian	native_hawaiian_pacific_islander	multiracial	total	white_int	black_int	hispanic_int	native_american_int	asian_int	native_hawaiian_pacific_islander_int	multiracial_int	total_int
1738245	AK	school	200006	98	Mount Edgecumbe	20000600558	980000	Mt. Edgecumbe High School	Regular School	No	High	09	12.0	2020	grade_10	11.0			2.0	0.0	2.0	2.0	113	11			2	0	2	2	113
1820564	AK	school	200006	98	Mount Edgecumbe	20000600558	980000	Mt. Edgecumbe High School	Regular School	No	High	09	12	2021	grade_10	10.0		0.0	0.0	1.0	0.0	5.0	108.0	10		0	0	1	0	5	108
1732405	AK	school	200730	9	Chatham Schools	20073000342	90010	Angoon School	Regular School	No	Other	PK	12.0	2020	grade_10	0.0						0.0	3	0						0	3
1732421	AK	school	200730	9	Chatham Schools	20073000344	90030	Gustavus School	Regular School	No	Other	KG	12.0	2020	grade_10	5.0							5	5							5
1732437	AK	school	200730	9	Chatham Schools	20073000490	90090	Klukwan School	Regular School	No	Other	KG	12.0	2020	grade_10	0.0						0.0	0	0						0	0
1732453	AK	school	200730	9	Chatham Schools	20073000477	98010	Chatham Correspondence	Regular School	No	Other	KG	12.0	2020	grade_10	0.0	0.0						0	0	0						0
1814724	AK	school	200730	9	Chatham Schools	20073000342	90010	Angoon School	Regular School	No	Other	PK	12	2021	grade_10	0.0						0.0	7.0	0						0	7
1814740	AK	school	200730	9	Chatham Schools	20073000344	90030	Gustavus School	Regular School	No	Other	KG	12	2021	grade_10	2.0	0.0						2.0	2	0						2
1814756	AK	school	200730	9	Chatham Schools	20073000490	90090	Klukwan School	Regular School	No	Other	KG	12	2021	grade_10	0.0						0.0	0.0	0						0	0
1732357	AK	school	200030	8	Bristol Bay Borough Schools	20003000020	80010	Bristol Bay Middle/High School	Regular School	No	High	07	12.0	2020	grade_10	1.0	1.0	0.0		1.0		1.0	13	1	1	0		1		1	13
1732373	AK	school	200030	8	Bristol Bay Borough Schools	20003000626	80020	Naknek 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
1732389	AK	school	200030	8	Bristol Bay Borough Schools	20003000751	88010	Bristol Bay Correspondence	Regular School	No	Other	KG	12.0	2020	grade_10	0.0							0	0							0
1814676	AK	school	200030	8	Bristol Bay Borough Schools	20003000020	80010	Bristol Bay Middle/High School	Regular School	No	High	07	12	2021	grade_10	2.0				0.0	1.0	0.0	7.0	2				0	1	0	7
1814692	AK	school	200030	8	Bristol Bay Borough Schools	20003000626	80020	Naknek 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
1814708	AK	school	200030	8	Bristol Bay Borough Schools	20003000751	88010	Bristol Bay Correspondence	Regular School	No	Other	KG	12	2021	grade_10	2.0							2.0	2							2
1732117	AK	school	200020	7	Bering Strait Schools	20002000423	70010	Brevig Mission School	Regular School	No	Other	PK	12.0	2020	grade_10								8								8
1732133	AK	school	200020	7	Bering Strait Schools	20002000421	70040	Aniguiin School	Regular School	No	Other	PK	12.0	2020	grade_10	0.0	0.0						4	0	0						4
1732149	AK	school	200020	7	Bering Strait Schools	20002000499	70050	Diomede School	Regular School	No	Other	PK	12.0	2020	grade_10								2								2
1732165	AK	school	200020	7	Bering Strait Schools	20002000422	70060	Martin L. Olson School	Regular School	No	Other	PK	12.0	2020	grade_10	0.0							3	0							3
1732181	AK	school	200020	7	Bering Strait Schools	20002000013	70070	Koyuk-Malimiut School	Regular School	No	Other	PK	12.0	2020	grade_10								5								5
1732197	AK	school	200020	7	Bering Strait Schools	20002000467	70080	Anthony A. Andrews School	Regular School	No	Other	PK	12.0	2020	grade_10	0.0							11	0							11
1732213	AK	school	200020	7	Bering Strait Schools	20002000466	70100	Shaktoolik School	Regular School	No	Other	PK	12.0	2020	grade_10	0.0							6	0							6
1732229	AK	school	200020	7	Bering Strait Schools	20002000015	70110	Shishmaref School	Regular School	No	Other	PK	12.0	2020	grade_10								16								16
1732245	AK	school	200020	7	Bering Strait Schools	20002000468	70120	Tukurngailnguq School	Regular School	No	Other	PK	12.0	2020	grade_10	0.0	0.0						11	0	0						11
1732261	AK	school	200020	7	Bering Strait Schools	20002000016	70130	James C. Isabell School	Regular School	No	Other	PK	12.0	2020	grade_10								3								3
1732277	AK	school	200020	7	Bering Strait Schools	20002000018	70150	Wales School	Regular School	No	Other	PK	12.0	2020	grade_10					0.0			3					0			3
1732293	AK	school	200020	7	Bering Strait Schools	20002000019	70160	White Mountain School	Regular School	No	Other	PK	12.0	2020	grade_10								2								2
1732309	AK	school	200020	7	Bering Strait Schools	20002000012	70180	Gambell School	Regular School	No	Other	PK	12.0	2020	grade_10	0.0							11	0							11
1732325	AK	school	200020	7	Bering Strait Schools	20002000014	70200	Hogarth Kingeekuk Sr. Memorial School	Regular School	No	Other	PK	12.0	2020	grade_10								10								10
1732341	AK	school	200020	7	Bering Strait Schools	20002000017	70260	Unalakleet School	Regular School	No	Other	PK	12.0	2020	grade_10	0.0				0.0		0.0	12	0				0		0	12
1814436	AK	school	200020	7	Bering Strait Schools	20002000423	70010	Brevig Mission School	Regular School	No	Other	PK	12	2021	grade_10	0.0							9.0	0							9
1814452	AK	school	200020	7	Bering Strait Schools	20002000421	70040	Aniguiin School	Regular School	No	Other	PK	12	2021	grade_10	0.0	0.0						8.0	0	0						8
1814468	AK	school	200020	7	Bering Strait Schools	20002000499	70050	Diomede School	Regular School	No	Other	PK	12	2021	grade_10								1.0								1
1814484	AK	school	200020	7	Bering Strait Schools	20002000422	70060	Martin L. Olson School	Regular School	No	Other	PK	12	2021	grade_10	0.0							3.0	0							3
1814500	AK	school	200020	7	Bering Strait Schools	20002000013	70070	Koyuk-Malimiut School	Regular School	No	Other	PK	12	2021	grade_10								7.0								7
1814516	AK	school	200020	7	Bering Strait Schools	20002000467	70080	Anthony A. Andrews School	Regular School	No	Other	PK	12	2021	grade_10	0.0	0.0	0.0					13.0	0	0	0					13
1814532	AK	school	200020	7	Bering Strait Schools	20002000466	70100	Shaktoolik School	Regular School	No	Other	PK	12	2021	grade_10	1.0							6.0	1							6
1814548	AK	school	200020	7	Bering Strait Schools	20002000015	70110	Shishmaref School	Regular School	No	Other	PK	12	2021	grade_10	0.0							14.0	0							14
1814564	AK	school	200020	7	Bering Strait Schools	20002000468	70120	Tukurngailnguq School	Regular School	No	Other	PK	12	2021	grade_10	0.0	0.0						16.0	0	0						16
1814580	AK	school	200020	7	Bering Strait Schools	20002000016	70130	James C. Isabell School	Regular School	No	Other	PK	12	2021	grade_10								6.0								6
1814596	AK	school	200020	7	Bering Strait Schools	20002000018	70150	Wales School	Regular School	No	Other	PK	12	2021	grade_10					0.0			2.0					0			2
1814612	AK	school	200020	7	Bering Strait Schools	20002000019	70160	White Mountain School	Regular School	No	Other	PK	12	2021	grade_10								0.0								0
1814628	AK	school	200020	7	Bering Strait Schools	20002000012	70180	Gambell School	Regular School	No	Other	PK	12	2021	grade_10	0.0							19.0	0							19
1814644	AK	school	200020	7	Bering Strait Schools	20002000014	70200	Hogarth Kingeekuk Sr. Memorial School	Regular School	No	Other	PK	12	2021	grade_10								10.0								10
1814660	AK	school	200020	7	Bering Strait Schools	20002000017	70260	Unalakleet School	Regular School	No	Other	PK	12	2021	grade_10	0.0		0.0				0.0	8.0	0		0				0	8
1732069	AK	school	200525	6	Annette Island Schools	20052500111	60020	Charles R. Leask Sr. Middle School	Regular School	No	Middle	06	8.0	2020	grade_10	0.0			0.0			0.0	0	0			0			0	0
1732085	AK	school	200525	6	Annette Island Schools	20052500250	60030	Richard Johnson Elementary	Regular School	No	Elementary	PK	5.0	2020	grade_10	0.0							0	0							0
1732101	AK	school	200525	6	Annette Island Schools	20052500648	60040	Metlakatla High School	Regular School	No	High	09	12.0	2020	grade_10	0.0						0.0	14	0						0	14
1814388	AK	school	200525	6	Annette Island Schools	20052500111	60020	Charles R. Leask Sr. Middle School	Regular School	No	Middle	06	8	2021	grade_10	0.0						0.0	0.0	0						0	0
1814404	AK	school	200525	6	Annette Island Schools	20052500250	60030	Richard Johnson Elementary	Regular School	No	Elementary	PK	5	2021	grade_10	0.0			0.0				0.0	0			0				0
1814420	AK	school	200525	6	Annette Island Schools	20052500648	60040	Metlakatla High School	Regular School	No	High	09	12	2021	grade_10	0.0						1.0	23.0	0						1	23
1738181	AK	school	200007	56	Aleutians East Borough Schools	20000700177	560010	King Cove School	Regular School	No	Other	PK	12.0	2020	grade_10	0.0		0.0	0.0	0.0			3	0		0	0	0			3
1738197	AK	school	200007	56	Aleutians East Borough Schools	20000700461	560020	Sand Point School	Regular School	No	Other	PK	12.0	2020	grade_10	1.0		1.0		1.0	0.0	0.0	5	1		1		1	0	0	5
1738213	AK	school	200007	56	Aleutians East Borough Schools	20000700004	560030	Akutan School	Regular School	No	Other	PK	12.0	2020	grade_10	0.0						0.0	0	0						0	0
1738229	AK	school	200007	56	Aleutians East Borough Schools	20000700007	560050	False Pass School	Regular School	No	Other	PK	12.0	2020	grade_10	0.0							0	0							0
1820500	AK	school	200007	56	Aleutians East Borough Schools	20000700177	560010	King Cove School	Regular School	No	Other	PK	12	2021	grade_10	0.0				0.0			8.0	0				0			8
1820516	AK	school	200007	56	Aleutians East Borough Schools	20000700461	560020	Sand Point School	Regular School	No	Other	PK	12	2021	grade_10	3.0		1.0		0.0	1.0	0.0	10.0	3		1		0	1	0	10
1820532	AK	school	200007	56	Aleutians East Borough Schools	20000700004	560030	Akutan School	Regular School	No	Other	PK	12	2021	grade_10	0.0						0.0	0.0	0						0	0
1820548	AK	school	200007	56	Aleutians East Borough Schools	20000700007	560050	False Pass School	Regular School	No	Other	PK	12	2021	grade_10	0.0						0.0	0.0	0						0	0
1738165	AK	school	200005	55	Kashunamiut Schools	20000500582	550010	Chevak School	Regular School	No	Other	PK	12.0	2020	grade_10	0.0				0.0			12	0				0			12
1820484	AK	school	200005	55	Kashunamiut Schools	20000500582	550010	Chevak School	Regular School	No	Other	PK	12	2021	grade_10	0.0							29.0	0							29
1738117	AK	school	200004	54	Yupiit Schools	20000400624	540030	Akiak School	Regular School	No	Other	KG	12.0	2020	grade_10	0.0							9	0							9
1738133	AK	school	200004	54	Yupiit Schools	20000400623	540040	Tuluksak School	Regular School	No	Other	KG	12.0	2020	grade_10								12								12
1738149	AK	school		54	Yupiit Schools		548010	Akiachak School						2020	grade_10	0.0						0.0	14	0						0	14
1820436	AK	school	200004	54	Yupiit Schools	20000400624	540030	Akiak School	Regular School	No	Other	KG	12	2021	grade_10	0.0							10.0	0							10
1820452	AK	school	200004	54	Yupiit Schools	20000400623	540040	Tuluksak School	Regular School	No	Other	KG	12	2021	grade_10		0.0					0.0	11.0		0					0	11
1820468	AK	school	200004	54	Yupiit Schools	20000400769	548010	Akiachak School	Regular School	No	High	07	12	2021	grade_10							0.0	17.0							0	17
1738101	AK	school	200715	53	Tanana Schools	20071500488	530010	Maudrey J. Sommer School	Regular School	No	Other	KG	12.0	2020	grade_10	0.0						0.0	4	0						0	4
1820420	AK	school	200715	53	Tanana Schools	20071500488	530010	Maudrey J. Sommer School	Regular School	No	Other	KG	12	2021	grade_10	0.0						0.0	4.0	0						0	4
1737941	AK	school	200862	52	Yukon-Koyukuk Schools	20086200377	520010	Allakaket School	Regular School	No	Other	PK	12.0	2020	grade_10	0.0							0	0							0
1737957	AK	school	200862	52	Yukon-Koyukuk Schools	20086200379	520030	Johnny Oldman School	Regular School	No	Other	PK	12.0	2020	grade_10	0.0							0	0							0
1737973	AK	school	200862	52	Yukon-Koyukuk Schools	20086200380	520040	Jimmy Huntington School	Regular School	No	Other	PK	12.0	2020	grade_10	0.0			0.0			0.0	6	0			0			0	6
1737989	AK	school	200862	52	Yukon-Koyukuk Schools	20086200381	520050	Kaltag School	Regular School	No	Other	PK	12.0	2020	grade_10								0								0
1738005	AK	school	200862	52	Yukon-Koyukuk Schools	20086200382	520060	Ella B. Vernetti School	Regular School	No	Elementary	PK	8.0	2020	grade_10								0								0
1738021	AK	school	200862	52	Yukon-Koyukuk Schools	20086200384	520080	Minto School	Regular School	No	Other	PK	12.0	2020	grade_10	1.0							2	1							2
1738037	AK	school	200862	52	Yukon-Koyukuk Schools	20086200385	520090	Andrew K. Demoski School	Regular School	No	Other	PK	12.0	2020	grade_10	0.0			0.0	0.0			1	0			0	0			1
1738053	AK	school	200862	52	Yukon-Koyukuk Schools	20086200386	520110	Merreline A Kangas School	Regular School	No	Other	PK	12.0	2020	grade_10	0.0			0.0				1	0			0				1
1738069	AK	school	200862	52	Yukon-Koyukuk Schools	20086200757	520120	Rampart School	Regular School	No	Other	PK	12.0	2020	grade_10								1								1
1738085	AK	school	200862	52	Yukon-Koyukuk Schools	20086200453	528010	Raven School	Regular School	No	Other	PK	12.0	2020	grade_10	90.0	2.0	6.0	2.0	3.0	3.0	12.0	143	90	2	6	2	3	3	12	143
1820260	AK	school	200862	52	Yukon-Koyukuk Schools	20086200377	520010	Allakaket School	Regular School	No	Other	PK	12	2021	grade_10					0.0			0.0					0			0
1820276	AK	school	200862	52	Yukon-Koyukuk Schools	20086200379	520030	Johnny Oldman School	Regular School	No	Other	PK	12	2021	grade_10	0.0							0.0	0							0
1820292	AK	school	200862	52	Yukon-Koyukuk Schools	20086200380	520040	Jimmy Huntington School	Regular School	No	Other	PK	12	2021	grade_10	0.0			0.0				2.0	0			0				2
1820308	AK	school	200862	52	Yukon-Koyukuk Schools	20086200381	520050	Kaltag School	Regular School	No	Other	PK	12	2021	grade_10								0.0								0
1820324	AK	school	200862	52	Yukon-Koyukuk Schools	20086200382	520060	Ella B. Vernetti School	Regular School	No	Elementary	PK	8	2021	grade_10								0.0								0
1820340	AK	school	200862	52	Yukon-Koyukuk Schools	20086200384	520080	Minto School	Regular School	No	Other	PK	12	2021	grade_10	0.0			0.0			0.0	3.0	0			0			0	3
1820356	AK	school	200862	52	Yukon-Koyukuk Schools	20086200385	520090	Andrew K. Demoski School	Regular School	No	Other	PK	12	2021	grade_10					0.0			4.0					0			4
1820372	AK	school	200862	52	Yukon-Koyukuk Schools	20086200386	520110	Merreline A Kangas School	Regular School	No	Other	PK	12	2021	grade_10	0.0			0.0				1.0	0			0				1
1820388	AK	school	200862	52	Yukon-Koyukuk Schools	20086200757	520120	Rampart School	Regular School	No	Other	PK	12	2021	grade_10								1.0								1
1820404	AK	school	200862	52	Yukon-Koyukuk Schools	20086200453	528010	Raven School	Regular School	No	Other	PK	12	2021	grade_10	149.0	9.0	11.0	6.0	7.0	6.0	26.0	252.0	149	9	11	6	7	6	26	252
1737845	AK	school	200775	51	Yukon Flats Schools	20077500358	510010	Arctic Village School	Regular School	No	Other	PK	12.0	2020	grade_10								1								1
1737861	AK	school	200775	51	Yukon Flats Schools	20077500360	510040	Tsuk Taih School	Regular School	No	Other	PK	12.0	2020	grade_10		0.0						0		0						0
1737877	AK	school	200775	51	Yukon Flats Schools	20077500361	510050	Circle School	Regular School	No	Other	PK	12.0	2020	grade_10	0.0							0	0							0
1737893	AK	school	200775	51	Yukon Flats Schools	20077500366	510060	John Fredson School	Regular School	No	Other	PK	12.0	2020	grade_10	0.0							2	0							2
1737909	AK	school	200775	51	Yukon Flats Schools	20077500362	510070	Fort Yukon School	Regular School	No	Other	PK	12.0	2020	grade_10	0.0							4	0							4
1737925	AK	school	200775	51	Yukon Flats Schools	20077500552	510140	Cruikshank School	Regular School	No	Other	PK	12.0	2020	grade_10								1								1
1820164	AK	school	200775	51	Yukon Flats Schools	20077500358	510010	Arctic Village School	Regular School	No	Other	PK	12	2021	grade_10								2.0								2
1820180	AK	school	200775	51	Yukon Flats Schools	20077500360	510040	Tsuk Taih School	Regular School	No	Other	PK	12	2021	grade_10		0.0						0.0		0						0
1820196	AK	school	200775	51	Yukon Flats Schools	20077500361	510050	Circle School	Regular School	No	Other	PK	12	2021	grade_10	0.0							2.0	0							2
1820212	AK	school	200775	51	Yukon Flats Schools	20077500366	510060	John Fredson School	Regular School	No	Other	PK	12	2021	grade_10								4.0								4
1820228	AK	school	200775	51	Yukon Flats Schools	20077500362	510070	Fort Yukon School	Regular School	No	Other	PK	12	2021	grade_10	1.0							6.0	1							6
1820244	AK	school	200775	51	Yukon Flats Schools	20077500552	510140	Cruikshank School	Regular School	No	Other	PK	12	2021	grade_10								1.0								1