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 hispanic 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	native_american	asian	native_hawaiian_pacific_islander	multiracial	total	white_int	black_int	native_american_int	asian_int	native_hawaiian_pacific_islander_int	multiracial_int	total_int
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	0					0	0
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						0	0						0
1730381	AK	school	200050	3	Alaska Gateway Schools	20005000025	30020	Eagle Community School	Regular School	No	Other	PK	12.0	2020	grade_7	1.0					1.0	2	1					1	2
1730397	AK	school	200050	3	Alaska Gateway Schools	20005000026	30030	Mentasta Lake School	Regular School	No	Other	PK	12.0	2020	grade_7							1							1
1730413	AK	school	200050	3	Alaska Gateway Schools	20005000027	30040	Walter Northway School	Regular School	No	Other	PK	12.0	2020	grade_7						0.0	5						0	5
1730429	AK	school	200050	3	Alaska Gateway Schools	20005000424	30050	Tanacross School	Regular School	No	Elementary	PK	8.0	2020	grade_7		0.0				0.0	0		0				0	0
1730445	AK	school	200050	3	Alaska Gateway Schools	20005000028	30060	Tok School	Regular School	No	Other	PK	12.0	2020	grade_7	4.0		0.0	1.0		1.0	13	4		0	1		1	13
1730461	AK	school	200050	3	Alaska Gateway Schools	20005000528	30070	Tetlin School	Regular School	No	Other	PK	12.0	2020	grade_7	0.0						2	0						2
1730493	AK	school	200010	4	Aleutian Region Schools	20001000005	40020	Yakov E. Netsvetov School	Regular School	No	Other	KG	12.0	2020	grade_7							2							2
1732077	AK	school	200525	6	Annette Island Schools	20052500111	60020	Charles R. Leask Sr. Middle School	Regular School	No	Middle	06	8.0	2020	grade_7	2.0		1.0			2.0	28	2		1			2	28
1732093	AK	school	200525	6	Annette Island Schools	20052500250	60030	Richard Johnson Elementary	Regular School	No	Elementary	PK	5.0	2020	grade_7	0.0						0	0						0
1732109	AK	school	200525	6	Annette Island Schools	20052500648	60040	Metlakatla High School	Regular School	No	High	09	12.0	2020	grade_7	0.0					0.0	0	0					0	0
1732125	AK	school	200020	7	Bering Strait Schools	20002000423	70010	Brevig Mission School	Regular School	No	Other	PK	12.0	2020	grade_7							6							6
1732141	AK	school	200020	7	Bering Strait Schools	20002000421	70040	Aniguiin School	Regular School	No	Other	PK	12.0	2020	grade_7	0.0	0.0					11	0	0					11
1732157	AK	school	200020	7	Bering Strait Schools	20002000499	70050	Diomede School	Regular School	No	Other	PK	12.0	2020	grade_7							4							4
1732173	AK	school	200020	7	Bering Strait Schools	20002000422	70060	Martin L. Olson School	Regular School	No	Other	PK	12.0	2020	grade_7	1.0						4	1						4
1732189	AK	school	200020	7	Bering Strait Schools	20002000013	70070	Koyuk-Malimiut School	Regular School	No	Other	PK	12.0	2020	grade_7							6							6
1732205	AK	school	200020	7	Bering Strait Schools	20002000467	70080	Anthony A. Andrews School	Regular School	No	Other	PK	12.0	2020	grade_7	0.0						16	0						16
1732221	AK	school	200020	7	Bering Strait Schools	20002000466	70100	Shaktoolik School	Regular School	No	Other	PK	12.0	2020	grade_7	1.0						6	1						6
1732237	AK	school	200020	7	Bering Strait Schools	20002000015	70110	Shishmaref School	Regular School	No	Other	PK	12.0	2020	grade_7							11							11
1732253	AK	school	200020	7	Bering Strait Schools	20002000468	70120	Tukurngailnguq School	Regular School	No	Other	PK	12.0	2020	grade_7	0.0	0.0					13	0	0					13
1732269	AK	school	200020	7	Bering Strait Schools	20002000016	70130	James C. Isabell School	Regular School	No	Other	PK	12.0	2020	grade_7							4							4
1732285	AK	school	200020	7	Bering Strait Schools	20002000018	70150	Wales School	Regular School	No	Other	PK	12.0	2020	grade_7				0.0			1				0			1
1732301	AK	school	200020	7	Bering Strait Schools	20002000019	70160	White Mountain School	Regular School	No	Other	PK	12.0	2020	grade_7							6							6
1732317	AK	school	200020	7	Bering Strait Schools	20002000012	70180	Gambell School	Regular School	No	Other	PK	12.0	2020	grade_7	0.0						11	0						11
1732333	AK	school	200020	7	Bering Strait Schools	20002000014	70200	Hogarth Kingeekuk Sr. Memorial School	Regular School	No	Other	PK	12.0	2020	grade_7							13							13
1732349	AK	school	200020	7	Bering Strait Schools	20002000017	70260	Unalakleet School	Regular School	No	Other	PK	12.0	2020	grade_7	0.0			0.0		0.0	17	0			0		0	17
1732397	AK	school	200030	8	Bristol Bay Borough Schools	20003000751	88010	Bristol Bay Correspondence	Regular School	No	Other	KG	12.0	2020	grade_7	0.0						0	0						0
1732413	AK	school	200730	9	Chatham Schools	20073000342	90010	Angoon School	Regular School	No	Other	PK	12.0	2020	grade_7	0.0					0.0	4	0					0	4
1732429	AK	school	200730	9	Chatham Schools	20073000344	90030	Gustavus School	Regular School	No	Other	KG	12.0	2020	grade_7	4.0						5	4						5
1732445	AK	school	200730	9	Chatham Schools	20073000490	90090	Klukwan School	Regular School	No	Other	KG	12.0	2020	grade_7	0.0					0.0	0	0					0	0
1732461	AK	school	200730	9	Chatham Schools	20073000477	98010	Chatham Correspondence	Regular School	No	Other	KG	12.0	2020	grade_7	0.0	0.0					0	0	0					0
1732509	AK	school	200800	10	Chugach Schools	20080000553	100030	Chenega School	Regular School	No	Other	PK	12.0	2020	grade_7	0.0					0.0	0	0					0	0
1732573	AK	school	200070	11	Copper River Schools	20007000036	110100	Kenny Lake School	Regular School	No	Other	PK	12.0	2020	grade_7	2.0					2.0	5	2					2	5
1732589	AK	school	200070	11	Copper River Schools	20007000583	110110	Slana School	Regular School	No	Other	PK	12.0	2020	grade_7	1.0						2	1						2
1732653	AK	school	200060	12	Cordova City Schools	20006000750	128010	Cordova School District Innovative Learning	Regular School	No	Other	KG	12.0	2020	grade_7	0.0			0.0			0	0			0			0
1732669	AK	school	200090	13	Craig City Schools	20009000038	130010	Craig High School	Regular School	No	High	09	12.0	2020	grade_7	0.0			0.0		0.0	0	0			0		0	0
1732685	AK	school	200090	13	Craig City Schools	20009000629	130020	Craig Elementary	Regular School	No	Elementary	PK	5.0	2020	grade_7	0.0			0.0		0.0	0	0			0		0	0
1732701	AK	school	200090	13	Craig City Schools	20009000433	130030	Craig Middle School	Regular School	No	Middle	06	8.0	2020	grade_7	12.0					5.0	21	12					5	21
1732765	AK	school	200100	14	Delta/Greely Schools	20010000510	140090	Gerstle River School	Regular School	No	Other	KG	12.0	2020	grade_7	4.0						4	4						4
1733293	AK	school	200600	16	Fairbanks North Star Borough Schools	20060000049	167020	Golden Heart Academy	Alternative School	No	High	05	12.0	2020	grade_7	0.0					0.0	0	0					0	0
1733437	AK	school	200130	17	Galena City Schools	20013000044	170010	Sidney C. Huntington Elementary	Regular School	No	Elementary	PK	6.0	2020	grade_7	0.0			0.0		0.0	0	0			0		0	0
1733453	AK	school	200130	17	Galena City Schools	20013000635	170020	Sidney C. Huntington Jr/Sr High School	Regular School	No	High	07	12.0	2020	grade_7	0.0						0	0						0
1733485	AK	school	200130	17	Galena City Schools	20013000252	179010	Galena Interior Learning Academy (GILA)	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
1733533	AK	school	200270	18	Haines Borough Schools	20027000670	188010	Haines Home School	Regular School	No	Other	KG	12.0	2020	grade_7	1.0						1	1						1
1733565	AK	school	200330	20	Hydaburg City Schools	20033000148	200010	Hydaburg School	Regular School	No	Other	PK	12.0	2020	grade_7	1.0				1.0	1.0	8	1				1	1	8
1733581	AK	school	200330	20	Hydaburg City Schools	20033000746	208010	Totem Correspondence School	Regular School	No	Other	PK	12.0	2020	grade_7	0.0		0.0	0.0		0.0	1	0		0	0		0	1
1733597	AK	school	200520	21	Iditarod Area Schools	20052000240	210010	Blackwell School	Regular School	No	Other	PK	12.0	2020	grade_7							1							1
1733613	AK	school	200520	21	Iditarod Area Schools	20052000242	210030	Jeffery A. Bader Memorial School	Regular School	No	Other	KG	12.0	2020	grade_7							0							0
1733661	AK	school	200520	21	Iditarod Area Schools	20052000245	210080	Top of the Kuskokwim School	Regular School	No	Other	PK	12.0	2020	grade_7							0							0
1733677	AK	school	200520	21	Iditarod Area Schools	20052000246	210090	Innoko River School	Regular School	No	Other	PK	12.0	2020	grade_7						0.0	2						0	2
1733693	AK	school	200520	21	Iditarod Area Schools	20052000241	210120	David Louis Memorial School	Regular School	No	Other	PK	12.0	2020	grade_7						0.0	7						0	7
1733901	AK	school	200210	22	Juneau Borough Schools	20021000396	227020	Johnson Youth Center	Alternative School	No	High	05	12.0	2020	grade_7	0.0					0.0	0	0					0	0
1733965	AK	school	200360	23	Kake City Schools	20036000150	230010	Kake Elementary & High School	Regular School	No	Other	PK	12.0	2020	grade_7	1.0		0.0	0.0		0.0	6	1		0	0		0	6
1734013	AK	school	200390	24	Kenai Peninsula Borough Schools	20039000512	240030	McNeil Canyon Elementary	Regular School	No	Elementary	KG	6.0	2020	grade_7	0.0		0.0	0.0		0.0	0	0		0	0		0	0
1734029	AK	school	200390	24	Kenai Peninsula Borough Schools	20039000155	240040	Cooper Landing School	Regular School	No	Other	KG	12.0	2020	grade_7	0.0					0.0	0	0					0	0
1734077	AK	school	200390	24	Kenai Peninsula Borough Schools	20039000536	240070	Razdolna School	Regular School	No	Other	PK	12.0	2020	grade_7	13.0						13	13						13
1734141	AK	school	200390	24	Kenai Peninsula Borough Schools	20039000163	240120	Moose Pass School	Regular School	No	Elementary	KG	8.0	2020	grade_7	0.0						0	0						0
1734429	AK	school	200390	24	Kenai Peninsula Borough Schools	20039000612	240380	Voznesenka School	Regular School	No	Other	PK	12.0	2020	grade_7	7.0						7	7						7
1734461	AK	school	200390	24	Kenai Peninsula Borough Schools	20039000718	240420	Kachemak Selo School	Regular School	No	Other	PK	12.0	2020	grade_7	1.0						1	1						1
1734557	AK	school	200390	24	Kenai Peninsula Borough Schools	20039000513	247050	Marathon School	Alternative School	No	High	07	12.0	2020	grade_7		0.0				0.0	0		0				0	0
1734813	AK	school	200480	28	Kodiak Island Borough Schools	20048000180	280010	Akhiok School	Regular School	No	Other	KG	12.0	2020	grade_7		0.0				0.0	0		0				0	0
1734941	AK	school	200480	28	Kodiak Island Borough Schools	20048000192	280110	Ouzinkie School	Regular School	No	Other	KG	12.0	2020	grade_7						0.0	1						0	1
1734957	AK	school	200480	28	Kodiak Island Borough Schools	20048000191	280120	Port Lions School	Regular School	No	Other	KG	12.0	2020	grade_7	0.0						1	0						1
1735005	AK	school	200760	29	Kuspuk Schools	20076000346	290010	Auntie Mary Nicoli Elementary	Regular School	No	Elementary	PK	5.0	2020	grade_7	0.0			0.0			0	0			0			0
1735021	AK	school	200760	29	Kuspuk Schools	20076000663	290011	Aniak Jr/Sr High School	Regular School	No	High	06	12.0	2020	grade_7	2.0						14	2						14
1735037	AK	school	200760	29	Kuspuk Schools	20076000347	290020	Crow Village Sam School	Regular School	No	Other	PK	12.0	2020	grade_7							0							0
1735053	AK	school	200760	29	Kuspuk Schools	20076000348	290030	Johnnie John Sr. School	Regular School	No	Other	PK	12.0	2020	grade_7							2							2
1735069	AK	school	200760	29	Kuspuk Schools	20076000491	290040	Joseph S. & Olinga Gregory Elementary	Regular School	No	Elementary	PK	2.0	2020	grade_7						0.0	0						0	0
1735085	AK	school	200760	29	Kuspuk Schools	20076000350	290050	Zackar Levi Elementary	Regular School	No	Elementary	03	5.0	2020	grade_7						0.0	0						0	0
1735101	AK	school	200760	29	Kuspuk Schools	20076000352	290070	Jack Egnaty Sr. School	Regular School	No	Other	PK	12.0	2020	grade_7	0.0						0	0						0
1735117	AK	school	200760	29	Kuspuk Schools	20076000353	290080	Gusty Michael School	Regular School	No	Other	PK	12.0	2020	grade_7							0							0
1735133	AK	school	200760	29	Kuspuk Schools	20076000665	290090	George Morgan Sr. H.S.	Regular School	No	High	06	12.0	2020	grade_7			0.0				12			0				12
1735149	AK	school	200485	30	Lake and Peninsula Borough Schools	20048500193	300010	Chignik Bay School	Regular School	No	Other	PK	12.0	2020	grade_7							0							0
1735165	AK	school	200485	30	Lake and Peninsula Borough Schools	20048500194	300020	Chignik Lagoon School	Regular School	No	Other	PK	12.0	2020	grade_7						1.0	3						1	3
1735181	AK	school	200485	30	Lake and Peninsula Borough Schools	20048500195	300030	Chignik Lake School	Regular School	No	Other	PK	12.0	2020	grade_7							1							1
1735197	AK	school	200485	30	Lake and Peninsula Borough Schools	20048500197	300050	Igiugig School	Regular School	No	Other	PK	12.0	2020	grade_7	0.0					0.0	1	0					0	1
1735213	AK	school	200485	30	Lake and Peninsula Borough Schools	20048500198	300080	Kokhanok School	Regular School	No	Other	PK	12.0	2020	grade_7							2							2
1735245	AK	school	200485	30	Lake and Peninsula Borough Schools	20048500200	300100	Nondalton School	Regular School	No	Other	PK	12.0	2020	grade_7						0.0	2						0	2
1735261	AK	school	200485	30	Lake and Peninsula Borough Schools	20048500204	300110	Tanalian School	Regular School	No	Other	PK	12.0	2020	grade_7	2.0	0.0	0.0			0.0	4	2	0	0			0	4
1735277	AK	school	200485	30	Lake and Peninsula Borough Schools	20048500202	300120	Perryville School	Regular School	No	Other	PK	12.0	2020	grade_7							3							3
1735293	AK	school	200485	30	Lake and Peninsula Borough Schools	20048500203	300130	Pilot Point School	Regular School	No	Other	PK	12.0	2020	grade_7						0.0	1						0	1
1735309	AK	school	200485	30	Lake and Peninsula Borough Schools	20048500205	300140	Meshik School	Regular School	No	Other	PK	12.0	2020	grade_7	0.0						1	0						1
1735325	AK	school	200485	30	Lake and Peninsula Borough Schools	20048500334	300220	Levelock School	Regular School	No	Other	PK	12.0	2020	grade_7							1							1
1735341	AK	school	200485	30	Lake and Peninsula Borough Schools	20048500473	308010	Lakeview Home School	Regular School	No	Other	PK	12.0	2020	grade_7			0.0				0			0				0
1735357	AK	school	200001	31	Lower Kuskokwim Schools	20000100206	310030	Joann A. Alexie Memorial School	Regular School	No	Other	PK	12.0	2020	grade_7			0.0				10			0				10
1735373	AK	school	200001	31	Lower Kuskokwim Schools	20000100474	310040	Negtemiut Elitnaurviat School	Regular School	No	Other	PK	12.0	2020	grade_7							8							8
1735437	AK	school	200001	31	Lower Kuskokwim Schools	20000100209	310080	Chaputnguak School	Regular School	No	Other	PK	12.0	2020	grade_7	0.0						12	0						12
1735453	AK	school	200001	31	Lower Kuskokwim Schools	20000100392	310090	Eek School	Regular School	No	Other	PK	12.0	2020	grade_7							6							6
1735469	AK	school	200001	31	Lower Kuskokwim Schools	20000100476	310100	Rocky Mountain School	Regular School	No	Other	PK	12.0	2020	grade_7							8							8
1735485	AK	school	200001	31	Lower Kuskokwim Schools	20000100391	310110	Akula Elitnaurvik School	Regular School	No	Other	PK	12.0	2020	grade_7	0.0						9	0						9
1735501	AK	school	200001	31	Lower Kuskokwim Schools	20000100210	310120	Chief Paul Memorial School	Regular School	No	Other	PK	12.0	2020	grade_7							16							16
1735517	AK	school	200001	31	Lower Kuskokwim Schools	20000100211	310130	Ayagina'ar Elitnaurvik	Regular School	No	Other	PK	12.0	2020	grade_7							10							10
1735533	AK	school	200001	31	Lower Kuskokwim Schools	20000100438	310140	Ket'acik/Aapalluk Memorial School	Regular School	No	Other	PK	12.0	2020	grade_7							20							20
1735549	AK	school	200001	31	Lower Kuskokwim Schools	20000100212	310150	Kwigillingok School	Regular School	No	Other	PK	12.0	2020	grade_7						0.0	6						0	6
1735565	AK	school	200001	31	Lower Kuskokwim Schools	20000100408	310160	Nuniwarmiut School	Regular School	No	Other	PK	12.0	2020	grade_7						0.0	1						0	1
1735581	AK	school	200001	31	Lower Kuskokwim Schools	20000100409	310170	William Miller Memorial School	Regular School	No	Other	PK	12.0	2020	grade_7	0.0						8	0						8
1735597	AK	school	200001	31	Lower Kuskokwim Schools	20000100439	310180	Z. John Williams Memorial School	Regular School	No	Other	PK	12.0	2020	grade_7	0.0						11	0						11
1735613	AK	school	200001	31	Lower Kuskokwim Schools	20000100440	310190	Ayaprun School	Regular School	No	Other	PK	12.0	2020	grade_7							11							11
1735629	AK	school	200001	31	Lower Kuskokwim Schools	20000100406	310200	Lewis Angapak Memorial School	Regular School	No	Other	PK	12.0	2020	grade_7							13							13
1735645	AK	school	200001	31	Lower Kuskokwim Schools	20000100214	310210	Anna Tobeluk Memorial School	Regular School	No	Other	PK	12.0	2020	grade_7	0.0						18	0						18