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 "year" = :p2 order by white 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
1812731	AK	school	200050	3	Alaska Gateway Schools	20005000026	30030	Mentasta Lake School	Regular School	No	Other	PK	12	2021	grade_6								2.0								2
1812747	AK	school	200050	3	Alaska Gateway Schools	20005000027	30040	Walter Northway School	Regular School	No	Other	PK	12	2021	grade_6							0.0	3.0							0	3
1812763	AK	school	200050	3	Alaska Gateway Schools	20005000424	30050	Tanacross School	Regular School	No	Elementary	PK	8	2021	grade_6							0.0	1.0							0	1
1812795	AK	school	200050	3	Alaska Gateway Schools	20005000528	30070	Tetlin School	Regular School	No	Other	PK	12	2021	grade_6								5.0								5
1812827	AK	school	200010	4	Aleutian Region Schools	20001000005	40020	Yakov E. Netsvetov School	Regular School	No	Other	KG	12	2021	grade_6							0.0	2.0							0	2
1814475	AK	school	200020	7	Bering Strait Schools	20002000499	70050	Diomede School	Regular School	No	Other	PK	12	2021	grade_6								1.0								1
1814507	AK	school	200020	7	Bering Strait Schools	20002000013	70070	Koyuk-Malimiut School	Regular School	No	Other	PK	12	2021	grade_6								5.0								5
1814587	AK	school	200020	7	Bering Strait Schools	20002000016	70130	James C. Isabell School	Regular School	No	Other	PK	12	2021	grade_6								7.0								7
1814603	AK	school	200020	7	Bering Strait Schools	20002000018	70150	Wales School	Regular School	No	Other	PK	12	2021	grade_6					1.0			1.0					1			1
1814619	AK	school	200020	7	Bering Strait Schools	20002000019	70160	White Mountain School	Regular School	No	Other	PK	12	2021	grade_6								4.0								4
1814651	AK	school	200020	7	Bering Strait Schools	20002000014	70200	Hogarth Kingeekuk Sr. Memorial School	Regular School	No	Other	PK	12	2021	grade_6								22.0								22
1815883	AK	school	200520	21	Iditarod Area Schools	20052000240	210010	Blackwell School	Regular School	No	Other	PK	12	2021	grade_6				0.0				2.0				0				2
1815899	AK	school	200520	21	Iditarod Area Schools	20052000242	210030	Jeffery A. Bader Memorial School	Regular School	No	Other	KG	12	2021	grade_6								2.0								2
1815947	AK	school	200520	21	Iditarod Area Schools	20052000245	210080	Top of the Kuskokwim School	Regular School	No	Other	PK	12	2021	grade_6								4.0								4
1815963	AK	school	200520	21	Iditarod Area Schools	20052000246	210090	Innoko River School	Regular School	No	Other	PK	12	2021	grade_6							0.0	2.0							0	2
1815979	AK	school	200520	21	Iditarod Area Schools	20052000241	210120	David Louis Memorial School	Regular School	No	Other	PK	12	2021	grade_6							1.0	7.0							1	7
1816347	AK	school	200390	24	Kenai Peninsula Borough Schools	20039000157	240060	Nanwalek School	Regular School	No	Other	PK	12	2021	grade_6			0.0		0.0		0.0	5.0			0		0		0	5
1816491	AK	school	200390	24	Kenai Peninsula Borough Schools	20039000168	240180	Port Graham School	Regular School	No	Other	PK	12	2021	grade_6			0.0				0.0	2.0			0				0	2
1816619	AK	school	200390	24	Kenai Peninsula Borough Schools	20039000153	240280	Tebughna School	Regular School	No	Other	PK	12	2021	grade_6			0.0				0.0	1.0			0				0	1
1817099	AK	school	200480	28	Kodiak Island Borough Schools	20048000180	280010	Akhiok School	Regular School	No	Other	KG	12	2021	grade_6		0.0					0.0	1.0		0					0	1
1817227	AK	school	200480	28	Kodiak Island Borough Schools	20048000192	280110	Ouzinkie School	Regular School	No	Other	KG	12	2021	grade_6				0.0			0.0	1.0				0			0	1
1817323	AK	school	200760	29	Kuspuk Schools	20076000347	290020	Crow Village Sam School	Regular School	No	Other	PK	12	2021	grade_6								4.0								4
1817339	AK	school	200760	29	Kuspuk Schools	20076000348	290030	Johnnie John Sr. School	Regular School	No	Other	PK	12	2021	grade_6								1.0								1
1817355	AK	school	200760	29	Kuspuk Schools	20076000491	290040	Joseph S. & Olinga Gregory Elementary	Regular School	No	Elementary	PK	2	2021	grade_6							0.0	0.0							0	0
1817371	AK	school	200760	29	Kuspuk Schools	20076000350	290050	Zackar Levi Elementary	Regular School	No	Elementary	03	5	2021	grade_6							0.0	0.0							0	0
1817403	AK	school	200760	29	Kuspuk Schools	20076000353	290080	Gusty Michael School	Regular School	No	Other	PK	12	2021	grade_6								2.0								2
1817419	AK	school	200760	29	Kuspuk Schools	20076000665	290090	George Morgan Sr. H.S.	Regular School	No	High	06	12	2021	grade_6				0.0				15.0				0				15
1817451	AK	school	200485	30	Lake and Peninsula Borough Schools	20048500194	300020	Chignik Lagoon School	Regular School	No	Other	PK	12	2021	grade_6							1.0	1.0							1	1
1817467	AK	school	200485	30	Lake and Peninsula Borough Schools	20048500195	300030	Chignik Lake School	Regular School	No	Other	PK	12	2021	grade_6								1.0								1
1817483	AK	school	200485	30	Lake and Peninsula Borough Schools	20048500197	300050	Igiugig School	Regular School	No	Other	PK	12	2021	grade_6							0.0	3.0							0	3
1817499	AK	school	200485	30	Lake and Peninsula Borough Schools	20048500198	300080	Kokhanok School	Regular School	No	Other	PK	12	2021	grade_6							0.0	6.0							0	6
1817531	AK	school	200485	30	Lake and Peninsula Borough Schools	20048500200	300100	Nondalton School	Regular School	No	Other	PK	12	2021	grade_6							0.0	1.0							0	1
1817563	AK	school	200485	30	Lake and Peninsula Borough Schools	20048500202	300120	Perryville School	Regular School	No	Other	PK	12	2021	grade_6								0.0								0
1817611	AK	school	200485	30	Lake and Peninsula Borough Schools	20048500334	300220	Levelock School	Regular School	No	Other	PK	12	2021	grade_6								0.0								0
1817643	AK	school	200001	31	Lower Kuskokwim Schools	20000100206	310030	Joann A. Alexie Memorial School	Regular School	No	Other	PK	12	2021	grade_6				0.0				3.0				0				3
1817659	AK	school	200001	31	Lower Kuskokwim Schools	20000100474	310040	Negtemiut Elitnaurviat School	Regular School	No	Other	PK	12	2021	grade_6								6.0								6
1817723	AK	school	200001	31	Lower Kuskokwim Schools	20000100209	310080	Chaputnguak School	Regular School	No	Other	PK	12	2021	grade_6								11.0								11
1817739	AK	school	200001	31	Lower Kuskokwim Schools	20000100392	310090	Eek School	Regular School	No	Other	PK	12	2021	grade_6								9.0								9
1817755	AK	school	200001	31	Lower Kuskokwim Schools	20000100476	310100	Rocky Mountain School	Regular School	No	Other	PK	12	2021	grade_6								6.0								6
1817787	AK	school	200001	31	Lower Kuskokwim Schools	20000100210	310120	Chief Paul Memorial School	Regular School	No	Other	PK	12	2021	grade_6								23.0								23
1817803	AK	school	200001	31	Lower Kuskokwim Schools	20000100211	310130	Ayagina'ar Elitnaurvik	Regular School	No	Other	PK	12	2021	grade_6								15.0								15
1817819	AK	school	200001	31	Lower Kuskokwim Schools	20000100438	310140	Ket'acik/Aapalluk Memorial School	Regular School	No	Other	PK	12	2021	grade_6								15.0								15
1817835	AK	school	200001	31	Lower Kuskokwim Schools	20000100212	310150	Kwigillingok School	Regular School	No	Other	PK	12	2021	grade_6								8.0								8
1817851	AK	school	200001	31	Lower Kuskokwim Schools	20000100408	310160	Nuniwarmiut School	Regular School	No	Other	PK	12	2021	grade_6								5.0								5
1817867	AK	school	200001	31	Lower Kuskokwim Schools	20000100409	310170	William Miller Memorial School	Regular School	No	Other	PK	12	2021	grade_6								9.0								9
1817899	AK	school	200001	31	Lower Kuskokwim Schools	20000100440	310190	Ayaprun School	Regular School	No	Other	PK	12	2021	grade_6								6.0								6
1817915	AK	school	200001	31	Lower Kuskokwim Schools	20000100406	310200	Lewis Angapak Memorial School	Regular School	No	Other	PK	12	2021	grade_6								11.0								11
1817931	AK	school	200001	31	Lower Kuskokwim Schools	20000100214	310210	Anna Tobeluk Memorial School	Regular School	No	Other	PK	12	2021	grade_6								16.0								16
1817947	AK	school	200001	31	Lower Kuskokwim Schools	20000100441	310220	Kuinerrarmiut Elitnaurviat	Regular School	No	Other	PK	12	2021	grade_6								15.0								15
1817963	AK	school	200001	31	Lower Kuskokwim Schools	20000100215	310230	Arviq School	Regular School	No	Other	KG	12	2021	grade_6								1.0								1
1817979	AK	school	200001	31	Lower Kuskokwim Schools	20000100619	310240	Akiuk Memorial School	Regular School	No	Other	PK	12	2021	grade_6								4.0								4
1818011	AK	school	200001	31	Lower Kuskokwim Schools	20000100475	310280	Qugcuun Memorial School	Regular School	No	Other	PK	12	2021	grade_6								1.0								1
1818027	AK	school	200001	31	Lower Kuskokwim Schools	20000100765	310290	Mertarvik School	Regular School	No	Other	PK	12	2021	grade_6								4.0								4
1818043	AK	school	200001	31	Lower Kuskokwim Schools	20000100389	310320	Paul T. Albert Memorial School	Regular School	No	Other	PK	12	2021	grade_6								6.0								6
1818075	AK	school	200001	31	Lower Kuskokwim Schools	20000100620	317020	Bethel Youth Facility	Alternative School	No	High	05	12	2021	grade_6				0.0				0.0				0				0
1818171	AK	school	200003	32	Lower Yukon Schools	20000300411	320080	Kotlik School	Regular School	No	Other	PK	12	2021	grade_6								15.0								15
1818219	AK	school	200003	32	Lower Yukon Schools	20000300222	320130	Russian Mission School	Regular School	No	Other	PK	12	2021	grade_6							0.0	6.0							0	6
1818235	AK	school	200003	32	Lower Yukon Schools	20000300412	320140	Scammon Bay School	Regular School	No	Other	PK	12	2021	grade_6		0.0					0.0	16.0		0					0	16
1818251	AK	school	200003	32	Lower Yukon Schools	20000300413	320150	Nunam Iqua School	Regular School	No	Other	PK	12	2021	grade_6								5.0								5
1818267	AK	school	200003	32	Lower Yukon Schools	20000300767	329010	Hooper Bay Charter School	Regular School	Yes	Middle	04	8	2021	grade_6								7.0								7
1819131	AK	school	200610	36	North Slope Borough Schools	20061000283	360010	Nunamiut School	Regular School	No	Other	PK	12	2021	grade_6							1.0	9.0							1	9
1819179	AK	school	200610	36	North Slope Borough Schools	20061000287	360040	Harold Kaveolook School	Regular School	No	Other	PK	12	2021	grade_6								3.0								3
1819259	AK	school	200610	36	North Slope Borough Schools	20061000291	360100	Alak School	Regular School	No	Other	PK	12	2021	grade_6		0.0					0.0	12.0		0					0	12
1819291	AK	school	200610	36	North Slope Borough Schools	20061000470	367010	Kiita Learning Community	Alternative School	No	High	09	12	2021	grade_6						0.0	0.0	0.0						0	0	0
1819307	AK	school	200610	36	North Slope Borough Schools	20061000768	369010	Qargi Academy	Regular School	Yes	High	09	12	2021	grade_6							0.0	0.0							0	0
1819323	AK	school	200625	37	Northwest Arctic Borough Schools	20062500292	370010	Ambler School	Regular School	No	Other	PK	12	2021	grade_6							0.0	8.0							0	8
1819339	AK	school	200625	37	Northwest Arctic Borough Schools	20062500293	370020	Buckland School	Regular School	No	Other	PK	12	2021	grade_6								11.0								11
1819355	AK	school	200625	37	Northwest Arctic Borough Schools	20062500294	370030	Deering School	Regular School	No	Other	PK	12	2021	grade_6								5.0								5
1819387	AK	school	200625	37	Northwest Arctic Borough Schools	20062500300	370060	McQueen School	Regular School	No	Other	PK	12	2021	grade_6							0.0	13.0							0	13
1819403	AK	school	200625	37	Northwest Arctic Borough Schools	20062500297	370070	Kobuk School	Regular School	No	Other	PK	12	2021	grade_6							0.0	4.0							0	4
1819435	AK	school	200625	37	Northwest Arctic Borough Schools	20062500301	370090	Napaaqtugmiut School	Regular School	No	Other	PK	12	2021	grade_6								14.0								14
1819467	AK	school	200625	37	Northwest Arctic Borough Schools	20062500303	370110	Shungnak School	Regular School	No	Other	PK	12	2021	grade_6								7.0								7
1819595	AK	school	200670	40	Pribilof Schools	20067000308	400020	St Paul School	Regular School	No	Other	PK	12	2021	grade_6								3.0								3
1819611	AK	school	200670	40	Pribilof Schools	20067000762	408010	Pribilof Correspondence School	Regular School	No	Other	KG	10	2021	grade_6								0.0								0
1819867	AK	school	200710	45	Southwest Region Schools	20071000331	450030	Clarks Point School	Regular School	No	Other	KG	12	2021	grade_6								2.0								2
1819883	AK	school	200710	45	Southwest Region Schools	20071000465	450040	William "Sonny" Nelson School	Regular School	No	Other	PK	12	2021	grade_6			0.0				1.0	3.0			0				1	3
1819899	AK	school	200710	45	Southwest Region Schools	20071000333	450050	Koliganek School	Regular School	No	Other	PK	12	2021	grade_6							0.0	3.0							0	3
1819931	AK	school	200710	45	Southwest Region Schools	20071000336	450080	Chief Ivan Blunka School	Regular School	No	Other	PK	12	2021	grade_6							0.0	11.0							0	11
1819963	AK	school	200710	45	Southwest Region Schools	20071000573	450120	Twin Hills School	Regular School	No	Other	PK	12	2021	grade_6							0.0	2.0							0	2
1819979	AK	school	200680	46	Saint Mary's Schools	20068000659	460010	Saint Mary's School	Regular School	No	Other	PK	12	2021	grade_6		1.0					0.0	16.0		1					0	16
1820171	AK	school	200775	51	Yukon Flats Schools	20077500358	510010	Arctic Village School	Regular School	No	Other	PK	12	2021	grade_6								4.0								4
1820187	AK	school	200775	51	Yukon Flats Schools	20077500360	510040	Tsuk Taih School	Regular School	No	Other	PK	12	2021	grade_6		0.0						0.0		0						0
1820219	AK	school	200775	51	Yukon Flats Schools	20077500366	510060	John Fredson School	Regular School	No	Other	PK	12	2021	grade_6								4.0								4
1820251	AK	school	200775	51	Yukon Flats Schools	20077500552	510140	Cruikshank School	Regular School	No	Other	PK	12	2021	grade_6								0.0								0
1820267	AK	school	200862	52	Yukon-Koyukuk Schools	20086200377	520010	Allakaket School	Regular School	No	Other	PK	12	2021	grade_6					0.0			2.0					0			2
1820315	AK	school	200862	52	Yukon-Koyukuk Schools	20086200381	520050	Kaltag School	Regular School	No	Other	PK	12	2021	grade_6								4.0								4
1820331	AK	school	200862	52	Yukon-Koyukuk Schools	20086200382	520060	Ella B. Vernetti School	Regular School	No	Elementary	PK	8	2021	grade_6								3.0								3
1820363	AK	school	200862	52	Yukon-Koyukuk Schools	20086200385	520090	Andrew K. Demoski School	Regular School	No	Other	PK	12	2021	grade_6					0.0			5.0					0			5
1820395	AK	school	200862	52	Yukon-Koyukuk Schools	20086200757	520120	Rampart School	Regular School	No	Other	PK	12	2021	grade_6								1.0								1
1820459	AK	school	200004	54	Yupiit Schools	20000400623	540040	Tuluksak School	Regular School	No	Other	KG	12	2021	grade_6		1.0					1.0	18.0		1					1	18
1820475	AK	school	200004	54	Yupiit Schools	20000400769	548010	Akiachak School	Regular School	No	High	07	12	2021	grade_6							0.0	19.0							0	19
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	0						0	0
1812843	AK	school	200010	4	Aleutian Region Schools	20001000080	40080	Adak School	Regular School	No	Other	KG	12	2021	grade_6	0.0		0.0		1.0	1.0		2.0	0		0		1	1		2
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	0	0	0
1812971	AK	school	200180	5	Anchorage Schools	20018000063	50100	Central Middle School of Science	Regular School	No	Middle	07	8	2021	grade_6	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0	0	0	0	0	0	0	0
1812987	AK	school	200180	5	Anchorage Schools	20018000065	50110	Chester Valley Elementary	Regular School	No	Elementary	PK	6	2021	grade_6	0.0	0.0	0.0		0.0	0.0	1.0	2.0	0	0	0		0	0	1	2
1813035	AK	school	200180	5	Anchorage Schools	20018000505	50140	Gruening Middle School	Regular School	No	Middle	06	8	2021	grade_6	0.0	0.0	0.0	0.0	1.0	0.0	1.0	2.0	0	0	0	0	1	0	1	2
1813051	AK	school	200180	5	Anchorage Schools	20018000068	50150	Chugiak Elementary	Regular School	No	Elementary	PK	6	2021	grade_6	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0	0	0	0	0	0	0	0
1813067	AK	school	200180	5	Anchorage Schools	20018000069	50160	Chugiak 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	0	0	0
1813099	AK	school	200180	5	Anchorage Schools	20018000071	50180	Creekside Park Elementary	Regular School	No	Elementary	PK	6	2021	grade_6	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0	0	0	0	0	0	0	0
1813131	AK	school	200180	5	Anchorage Schools	20018000073	50200	Dimond 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	0	0	0