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 and (white > :p3 or (white = :p3 and rowid > :p2)) order by white, rowid 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
1815955	AK	school	200520	21	Iditarod Area Schools	20052000246	210090	Innoko River School	Regular School	No	Other	PK	12	2021	grade_1							0.0	0.0							0	0
1815971	AK	school	200520	21	Iditarod Area Schools	20052000241	210120	David Louis Memorial School	Regular School	No	Other	PK	12	2021	grade_1							0.0	3.0							0	3
1816339	AK	school	200390	24	Kenai Peninsula Borough Schools	20039000157	240060	Nanwalek School	Regular School	No	Other	PK	12	2021	grade_1			0.0		0.0		0.0	4.0			0		0		0	4
1816483	AK	school	200390	24	Kenai Peninsula Borough Schools	20039000168	240180	Port Graham School	Regular School	No	Other	PK	12	2021	grade_1			0.0				0.0	1.0			0				0	1
1816611	AK	school	200390	24	Kenai Peninsula Borough Schools	20039000153	240280	Tebughna School	Regular School	No	Other	PK	12	2021	grade_1			1.0				1.0	2.0			1				1	2
1817091	AK	school	200480	28	Kodiak Island Borough Schools	20048000180	280010	Akhiok School	Regular School	No	Other	KG	12	2021	grade_1		0.0					0.0	2.0		0					0	2
1817219	AK	school	200480	28	Kodiak Island Borough Schools	20048000192	280110	Ouzinkie School	Regular School	No	Other	KG	12	2021	grade_1				0.0			1.0	1.0				0			1	1
1817315	AK	school	200760	29	Kuspuk Schools	20076000347	290020	Crow Village Sam School	Regular School	No	Other	PK	12	2021	grade_1								1.0								1
1817331	AK	school	200760	29	Kuspuk Schools	20076000348	290030	Johnnie John Sr. School	Regular School	No	Other	PK	12	2021	grade_1								4.0								4
1817347	AK	school	200760	29	Kuspuk Schools	20076000491	290040	Joseph S. & Olinga Gregory Elementary	Regular School	No	Elementary	PK	2	2021	grade_1							1.0	12.0							1	12
1817363	AK	school	200760	29	Kuspuk Schools	20076000350	290050	Zackar Levi Elementary	Regular School	No	Elementary	03	5	2021	grade_1							0.0	0.0							0	0
1817395	AK	school	200760	29	Kuspuk Schools	20076000353	290080	Gusty Michael School	Regular School	No	Other	PK	12	2021	grade_1								1.0								1
1817411	AK	school	200760	29	Kuspuk Schools	20076000665	290090	George Morgan Sr. H.S.	Regular School	No	High	06	12	2021	grade_1				0.0				0.0				0				0
1817443	AK	school	200485	30	Lake and Peninsula Borough Schools	20048500194	300020	Chignik Lagoon School	Regular School	No	Other	PK	12	2021	grade_1							1.0	1.0							1	1
1817459	AK	school	200485	30	Lake and Peninsula Borough Schools	20048500195	300030	Chignik Lake School	Regular School	No	Other	PK	12	2021	grade_1								1.0								1
1817475	AK	school	200485	30	Lake and Peninsula Borough Schools	20048500197	300050	Igiugig School	Regular School	No	Other	PK	12	2021	grade_1							0.0	1.0							0	1
1817491	AK	school	200485	30	Lake and Peninsula Borough Schools	20048500198	300080	Kokhanok School	Regular School	No	Other	PK	12	2021	grade_1							0.0	2.0							0	2
1817523	AK	school	200485	30	Lake and Peninsula Borough Schools	20048500200	300100	Nondalton School	Regular School	No	Other	PK	12	2021	grade_1							1.0	3.0							1	3
1817555	AK	school	200485	30	Lake and Peninsula Borough Schools	20048500202	300120	Perryville School	Regular School	No	Other	PK	12	2021	grade_1								2.0								2
1817603	AK	school	200485	30	Lake and Peninsula Borough Schools	20048500334	300220	Levelock School	Regular School	No	Other	PK	12	2021	grade_1								1.0								1
1817635	AK	school	200001	31	Lower Kuskokwim Schools	20000100206	310030	Joann A. Alexie Memorial School	Regular School	No	Other	PK	12	2021	grade_1				0.0				9.0				0				9
1817651	AK	school	200001	31	Lower Kuskokwim Schools	20000100474	310040	Negtemiut Elitnaurviat School	Regular School	No	Other	PK	12	2021	grade_1								9.0								9
1817715	AK	school	200001	31	Lower Kuskokwim Schools	20000100209	310080	Chaputnguak School	Regular School	No	Other	PK	12	2021	grade_1								12.0								12
1817731	AK	school	200001	31	Lower Kuskokwim Schools	20000100392	310090	Eek School	Regular School	No	Other	PK	12	2021	grade_1								6.0								6
1817747	AK	school	200001	31	Lower Kuskokwim Schools	20000100476	310100	Rocky Mountain School	Regular School	No	Other	PK	12	2021	grade_1								12.0								12
1817779	AK	school	200001	31	Lower Kuskokwim Schools	20000100210	310120	Chief Paul Memorial School	Regular School	No	Other	PK	12	2021	grade_1								21.0								21
1817795	AK	school	200001	31	Lower Kuskokwim Schools	20000100211	310130	Ayagina'ar Elitnaurvik	Regular School	No	Other	PK	12	2021	grade_1								9.0								9
1817811	AK	school	200001	31	Lower Kuskokwim Schools	20000100438	310140	Ket'acik/Aapalluk Memorial School	Regular School	No	Other	PK	12	2021	grade_1								26.0								26
1817827	AK	school	200001	31	Lower Kuskokwim Schools	20000100212	310150	Kwigillingok School	Regular School	No	Other	PK	12	2021	grade_1								13.0								13
1817843	AK	school	200001	31	Lower Kuskokwim Schools	20000100408	310160	Nuniwarmiut School	Regular School	No	Other	PK	12	2021	grade_1								3.0								3
1817859	AK	school	200001	31	Lower Kuskokwim Schools	20000100409	310170	William Miller Memorial School	Regular School	No	Other	PK	12	2021	grade_1								8.0								8
1817891	AK	school	200001	31	Lower Kuskokwim Schools	20000100440	310190	Ayaprun School	Regular School	No	Other	PK	12	2021	grade_1								8.0								8
1817907	AK	school	200001	31	Lower Kuskokwim Schools	20000100406	310200	Lewis Angapak Memorial School	Regular School	No	Other	PK	12	2021	grade_1								10.0								10
1817923	AK	school	200001	31	Lower Kuskokwim Schools	20000100214	310210	Anna Tobeluk Memorial School	Regular School	No	Other	PK	12	2021	grade_1								15.0								15
1817939	AK	school	200001	31	Lower Kuskokwim Schools	20000100441	310220	Kuinerrarmiut Elitnaurviat	Regular School	No	Other	PK	12	2021	grade_1								13.0								13
1817955	AK	school	200001	31	Lower Kuskokwim Schools	20000100215	310230	Arviq School	Regular School	No	Other	KG	12	2021	grade_1								2.0								2
1817971	AK	school	200001	31	Lower Kuskokwim Schools	20000100619	310240	Akiuk Memorial School	Regular School	No	Other	PK	12	2021	grade_1								10.0								10
1818003	AK	school	200001	31	Lower Kuskokwim Schools	20000100475	310280	Qugcuun Memorial School	Regular School	No	Other	PK	12	2021	grade_1								2.0								2
1818019	AK	school	200001	31	Lower Kuskokwim Schools	20000100765	310290	Mertarvik School	Regular School	No	Other	PK	12	2021	grade_1								0.0								0
1818035	AK	school	200001	31	Lower Kuskokwim Schools	20000100389	310320	Paul T. Albert Memorial School	Regular School	No	Other	PK	12	2021	grade_1								9.0								9
1818067	AK	school	200001	31	Lower Kuskokwim Schools	20000100620	317020	Bethel Youth Facility	Alternative School	No	High	05	12	2021	grade_1				0.0				0.0				0				0
1818163	AK	school	200003	32	Lower Yukon Schools	20000300411	320080	Kotlik School	Regular School	No	Other	PK	12	2021	grade_1								14.0								14
1818211	AK	school	200003	32	Lower Yukon Schools	20000300222	320130	Russian Mission School	Regular School	No	Other	PK	12	2021	grade_1							1.0	9.0							1	9
1818227	AK	school	200003	32	Lower Yukon Schools	20000300412	320140	Scammon Bay School	Regular School	No	Other	PK	12	2021	grade_1		0.0					0.0	11.0		0					0	11
1818243	AK	school	200003	32	Lower Yukon Schools	20000300413	320150	Nunam Iqua School	Regular School	No	Other	PK	12	2021	grade_1								5.0								5
1818259	AK	school	200003	32	Lower Yukon Schools	20000300767	329010	Hooper Bay Charter School	Regular School	Yes	Middle	04	8	2021	grade_1								0.0								0
1819123	AK	school	200610	36	North Slope Borough Schools	20061000283	360010	Nunamiut School	Regular School	No	Other	PK	12	2021	grade_1							2.0	9.0							2	9
1819171	AK	school	200610	36	North Slope Borough Schools	20061000287	360040	Harold Kaveolook School	Regular School	No	Other	PK	12	2021	grade_1								8.0								8
1819251	AK	school	200610	36	North Slope Borough Schools	20061000291	360100	Alak School	Regular School	No	Other	PK	12	2021	grade_1		0.0					0.0	13.0		0					0	13
1819283	AK	school	200610	36	North Slope Borough Schools	20061000470	367010	Kiita Learning Community	Alternative School	No	High	09	12	2021	grade_1						0.0	0.0	0.0						0	0	0
1819299	AK	school	200610	36	North Slope Borough Schools	20061000768	369010	Qargi Academy	Regular School	Yes	High	09	12	2021	grade_1							0.0	0.0							0	0
1819315	AK	school	200625	37	Northwest Arctic Borough Schools	20062500292	370010	Ambler School	Regular School	No	Other	PK	12	2021	grade_1							1.0	5.0							1	5
1819331	AK	school	200625	37	Northwest Arctic Borough Schools	20062500293	370020	Buckland School	Regular School	No	Other	PK	12	2021	grade_1								13.0								13
1819347	AK	school	200625	37	Northwest Arctic Borough Schools	20062500294	370030	Deering School	Regular School	No	Other	PK	12	2021	grade_1								8.0								8
1819379	AK	school	200625	37	Northwest Arctic Borough Schools	20062500300	370060	McQueen School	Regular School	No	Other	PK	12	2021	grade_1							1.0	19.0							1	19
1819395	AK	school	200625	37	Northwest Arctic Borough Schools	20062500297	370070	Kobuk School	Regular School	No	Other	PK	12	2021	grade_1							1.0	4.0							1	4
1819427	AK	school	200625	37	Northwest Arctic Borough Schools	20062500301	370090	Napaaqtugmiut School	Regular School	No	Other	PK	12	2021	grade_1								12.0								12
1819459	AK	school	200625	37	Northwest Arctic Borough Schools	20062500303	370110	Shungnak School	Regular School	No	Other	PK	12	2021	grade_1								4.0								4
1819587	AK	school	200670	40	Pribilof Schools	20067000308	400020	St Paul School	Regular School	No	Other	PK	12	2021	grade_1								7.0								7
1819603	AK	school	200670	40	Pribilof Schools	20067000762	408010	Pribilof Correspondence School	Regular School	No	Other	KG	10	2021	grade_1								1.0								1
1819859	AK	school	200710	45	Southwest Region Schools	20071000331	450030	Clarks Point School	Regular School	No	Other	KG	12	2021	grade_1								2.0								2
1819875	AK	school	200710	45	Southwest Region Schools	20071000465	450040	William "Sonny" Nelson School	Regular School	No	Other	PK	12	2021	grade_1			0.0				0.0	0.0			0				0	0
1819891	AK	school	200710	45	Southwest Region Schools	20071000333	450050	Koliganek School	Regular School	No	Other	PK	12	2021	grade_1							0.0	3.0							0	3
1819923	AK	school	200710	45	Southwest Region Schools	20071000336	450080	Chief Ivan Blunka School	Regular School	No	Other	PK	12	2021	grade_1							1.0	14.0							1	14
1819955	AK	school	200710	45	Southwest Region Schools	20071000573	450120	Twin Hills School	Regular School	No	Other	PK	12	2021	grade_1							1.0	4.0							1	4
1819971	AK	school	200680	46	Saint Mary's Schools	20068000659	460010	Saint Mary's School	Regular School	No	Other	PK	12	2021	grade_1		0.0					0.0	12.0		0					0	12
1820163	AK	school	200775	51	Yukon Flats Schools	20077500358	510010	Arctic Village School	Regular School	No	Other	PK	12	2021	grade_1								2.0								2
1820179	AK	school	200775	51	Yukon Flats Schools	20077500360	510040	Tsuk Taih School	Regular School	No	Other	PK	12	2021	grade_1		1.0						2.0		1						2
1820211	AK	school	200775	51	Yukon Flats Schools	20077500366	510060	John Fredson School	Regular School	No	Other	PK	12	2021	grade_1								6.0								6
1820243	AK	school	200775	51	Yukon Flats Schools	20077500552	510140	Cruikshank School	Regular School	No	Other	PK	12	2021	grade_1								2.0								2
1820259	AK	school	200862	52	Yukon-Koyukuk Schools	20086200377	520010	Allakaket School	Regular School	No	Other	PK	12	2021	grade_1					0.0			1.0					0			1
1820307	AK	school	200862	52	Yukon-Koyukuk Schools	20086200381	520050	Kaltag School	Regular School	No	Other	PK	12	2021	grade_1								1.0								1
1820323	AK	school	200862	52	Yukon-Koyukuk Schools	20086200382	520060	Ella B. Vernetti School	Regular School	No	Elementary	PK	8	2021	grade_1								1.0								1
1820355	AK	school	200862	52	Yukon-Koyukuk Schools	20086200385	520090	Andrew K. Demoski School	Regular School	No	Other	PK	12	2021	grade_1					0.0			4.0					0			4
1820387	AK	school	200862	52	Yukon-Koyukuk Schools	20086200757	520120	Rampart School	Regular School	No	Other	PK	12	2021	grade_1								0.0								0
1820451	AK	school	200004	54	Yupiit Schools	20000400623	540040	Tuluksak School	Regular School	No	Other	KG	12	2021	grade_1		0.0					0.0	13.0		0					0	13
1820467	AK	school	200004	54	Yupiit Schools	20000400769	548010	Akiachak School	Regular School	No	High	07	12	2021	grade_1							1.0	27.0							1	27
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							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	0.0							4	0							4
1730500	AK	school	200010	4	Aleutian Region Schools	20001000080	40080	Adak School	Regular School	No	Other	PK	12.0	2020	grade_1	0.0		3.0		0.0	0.0		3	0		3		0	0		3
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	0	0	0
1730628	AK	school	200180	5	Anchorage Schools	20018000063	50100	Central Middle School of Science	Regular School	No	Middle	07	8.0	2020	grade_1	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0	0	0	0	0	0	0	0	0
1730692	AK	school	200180	5	Anchorage Schools	20018000505	50140	Gruening Middle School	Regular School	No	Middle	06	8.0	2020	grade_1	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0	0	0	0	0	0	0	0	0
1730724	AK	school	200180	5	Anchorage Schools	20018000069	50160	Chugiak 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	0	0	0
1730788	AK	school	200180	5	Anchorage Schools	20018000073	50200	Dimond 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	0	0	0
1730804	AK	school	200180	5	Anchorage Schools	20018000075	50220	East 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	0	0	0
1731140	AK	school	200180	5	Anchorage Schools	20018000064	50560	Clark Middle School	Regular School	No	Middle	06	8.0	2020	grade_1	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0	0	0	0	0	0	0	0	0
1731204	AK	school	200180	5	Anchorage Schools	20018000106	50610	Romig Middle School	Regular School	No	Middle	07	8.0	2020	grade_1	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0	0	0	0	0	0	0	0	0
1731268	AK	school	200180	5	Anchorage Schools	20018000531	50660	Service 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	0	0	0
1731284	AK	school	200180	5	Anchorage Schools	20018000115	50670	Steller Secondary School	Regular School	No	High	07	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	0	0	0
1731364	AK	school	200180	5	Anchorage Schools	20018000119	50720	Wendler Middle School	Regular School	No	Middle	07	8.0	2020	grade_1	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0	0	0	0	0	0	0	0	0
1731380	AK	school	200180	5	Anchorage Schools	20018000120	50730	West 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	0	0	0
1731492	AK	school	200180	5	Anchorage Schools	20018000534	50870	Hanshew Middle School	Regular School	No	Middle	07	8.0	2020	grade_1	0.0	0.0	0.0		0.0	0.0	0.0	0	0	0	0		0	0	0	0
1731540	AK	school	200180	5	Anchorage Schools	20018000562	50940	Mears Middle School	Regular School	No	Middle	07	8.0	2020	grade_1	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0	0	0	0	0	0	0	0	0
1731572	AK	school	200180	5	Anchorage Schools	20018000714	50980	AVAIL School	Alternative School	No	High	06	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	0	0	0
1731684	AK	school	200180	5	Anchorage Schools	20018010162	51050	Goldenview Middle School	Regular School	No	Middle	07	8.0	2020	grade_1	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0	0	0	0	0	0	0	0	0
1731700	AK	school	200180	5	Anchorage Schools	20018000229	51060	Mirror Lake Middle School	Regular School	No	Middle	06	8.0	2020	grade_1	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0	0	0	0	0	0	0	0	0
1731732	AK	school	200180	5	Anchorage Schools	20018000454	51120	South Anchorage 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	0	0	0
1731748	AK	school	200180	5	Anchorage Schools	20018000458	51130	Eagle River 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	0	0	0
1731764	AK	school	200180	5	Anchorage Schools	20018000729	51150	Nicholas J. Begich Middle School	Regular School	No	Middle	06	8.0	2020	grade_1	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0	0	0	0	0	0	0	0	0
1731796	AK	school	200180	5	Anchorage Schools	20018000341	57010	Alaska State School for Deaf and Hard of Hearing	Special Education School	No	Other	PK	12.0	2020	grade_1	0.0	0.0	0.0		0.0		1.0	1	0	0	0		0		1	1