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 school_nces_id 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
1817642	AK	school	200001	31	Lower Kuskokwim Schools	20000100206	310030	Joann A. Alexie Memorial School	Regular School	No	Other	PK	12	2021	grade_5				1.0				6.0				1				6
1817690	AK	school	200001	31	Lower Kuskokwim Schools	20000100207	310060	Gladys Jung Elementary	Regular School	No	Elementary	03	6	2021	grade_5	7.0	1.0	1.0	1.0	1.0		1.0	85.0	7	1	1	1	1		1	85
1817706	AK	school	200001	31	Lower Kuskokwim Schools	20000100208	310070	Bethel Regional High School	Regular School	No	High	07	12	2021	grade_5	0.0	0.0	0.0	0.0	0.0		0.0	0.0	0	0	0	0	0		0	0
1817722	AK	school	200001	31	Lower Kuskokwim Schools	20000100209	310080	Chaputnguak School	Regular School	No	Other	PK	12	2021	grade_5								11.0								11
1817786	AK	school	200001	31	Lower Kuskokwim Schools	20000100210	310120	Chief Paul Memorial School	Regular School	No	Other	PK	12	2021	grade_5								11.0								11
1817802	AK	school	200001	31	Lower Kuskokwim Schools	20000100211	310130	Ayagina'ar Elitnaurvik	Regular School	No	Other	PK	12	2021	grade_5								11.0								11
1817834	AK	school	200001	31	Lower Kuskokwim Schools	20000100212	310150	Kwigillingok School	Regular School	No	Other	PK	12	2021	grade_5								10.0								10
1817994	AK	school	200001	31	Lower Kuskokwim Schools	20000100213	310250	Nelson Island Area School	Regular School	No	Other	PK	12	2021	grade_5	0.0				0.0			7.0	0				0			7
1817930	AK	school	200001	31	Lower Kuskokwim Schools	20000100214	310210	Anna Tobeluk Memorial School	Regular School	No	Other	PK	12	2021	grade_5								18.0								18
1817962	AK	school	200001	31	Lower Kuskokwim Schools	20000100215	310230	Arviq School	Regular School	No	Other	KG	12	2021	grade_5								0.0								0
1818058	AK	school	200001	31	Lower Kuskokwim Schools	20000100318	317010	Kuskokwim Learning Academy	Alternative School	No	High	09	12	2021	grade_5	0.0		0.0					0.0	0		0					0
1818090	AK	school	200001	31	Lower Kuskokwim Schools	20000100329	319010	Ayaprun Elitnaurvik	Regular School	Yes	Elementary	PK	6	2021	grade_5	2.0							19.0	2							19
1818042	AK	school	200001	31	Lower Kuskokwim Schools	20000100389	310320	Paul T. Albert Memorial School	Regular School	No	Other	PK	12	2021	grade_5								14.0								14
1817770	AK	school	200001	31	Lower Kuskokwim Schools	20000100391	310110	Akula Elitnaurvik School	Regular School	No	Other	PK	12	2021	grade_5	0.0							7.0	0							7
1817738	AK	school	200001	31	Lower Kuskokwim Schools	20000100392	310090	Eek School	Regular School	No	Other	PK	12	2021	grade_5								9.0								9
1817914	AK	school	200001	31	Lower Kuskokwim Schools	20000100406	310200	Lewis Angapak Memorial School	Regular School	No	Other	PK	12	2021	grade_5								13.0								13
1817850	AK	school	200001	31	Lower Kuskokwim Schools	20000100408	310160	Nuniwarmiut School	Regular School	No	Other	PK	12	2021	grade_5								8.0								8
1817866	AK	school	200001	31	Lower Kuskokwim Schools	20000100409	310170	William Miller Memorial School	Regular School	No	Other	PK	12	2021	grade_5								6.0								6
1817674	AK	school	200001	31	Lower Kuskokwim Schools	20000100436	310050	Mikelnguut Elitnaurviat	Regular School	No	Elementary	PK	2	2021	grade_5	0.0		0.0	0.0	0.0		0.0	0.0	0		0	0	0		0	0
1817818	AK	school	200001	31	Lower Kuskokwim Schools	20000100438	310140	Ket'acik/Aapalluk Memorial School	Regular School	No	Other	PK	12	2021	grade_5								16.0								16
1817882	AK	school	200001	31	Lower Kuskokwim Schools	20000100439	310180	Z. John Williams Memorial School	Regular School	No	Other	PK	12	2021	grade_5	0.0							13.0	0							13
1817898	AK	school	200001	31	Lower Kuskokwim Schools	20000100440	310190	Ayaprun School	Regular School	No	Other	PK	12	2021	grade_5								3.0								3
1817946	AK	school	200001	31	Lower Kuskokwim Schools	20000100441	310220	Kuinerrarmiut Elitnaurviat	Regular School	No	Other	PK	12	2021	grade_5								19.0								19
1817658	AK	school	200001	31	Lower Kuskokwim Schools	20000100474	310040	Negtemiut Elitnaurviat School	Regular School	No	Other	PK	12	2021	grade_5								7.0								7
1818010	AK	school	200001	31	Lower Kuskokwim Schools	20000100475	310280	Qugcuun Memorial School	Regular School	No	Other	PK	12	2021	grade_5								0.0								0
1817754	AK	school	200001	31	Lower Kuskokwim Schools	20000100476	310100	Rocky Mountain School	Regular School	No	Other	PK	12	2021	grade_5								5.0								5
1817978	AK	school	200001	31	Lower Kuskokwim Schools	20000100619	310240	Akiuk Memorial School	Regular School	No	Other	PK	12	2021	grade_5								6.0								6
1818074	AK	school	200001	31	Lower Kuskokwim Schools	20000100620	317020	Bethel Youth Facility	Alternative School	No	High	05	12	2021	grade_5				0.0				0.0				0				0
1818026	AK	school	200001	31	Lower Kuskokwim Schools	20000100765	310290	Mertarvik School	Regular School	No	Other	PK	12	2021	grade_5								7.0								7
1818106	AK	school	200003	32	Lower Yukon Schools	20000300216	320010	Alakanuk School	Regular School	No	Other	PK	12	2021	grade_5	1.0						0.0	12.0	1						0	12
1818122	AK	school	200003	32	Lower Yukon Schools	20000300217	320040	Emmonak School	Regular School	No	Other	PK	12	2021	grade_5	0.0						0.0	16.0	0						0	16
1818138	AK	school	200003	32	Lower Yukon Schools	20000300218	320050	Marshall School	Regular School	No	Other	PK	12	2021	grade_5	0.0						0.0	12.0	0						0	12
1818154	AK	school	200003	32	Lower Yukon Schools	20000300219	320070	Hooper Bay School	Regular School	No	Other	PK	12	2021	grade_5	0.0						1.0	29.0	0						1	29
1818186	AK	school	200003	32	Lower Yukon Schools	20000300220	320090	Mountain Village School	Regular School	No	Other	PK	12	2021	grade_5	0.0			0.0			0.0	11.0	0			0			0	11
1818218	AK	school	200003	32	Lower Yukon Schools	20000300222	320130	Russian Mission School	Regular School	No	Other	PK	12	2021	grade_5							0.0	11.0							0	11
1818202	AK	school	200003	32	Lower Yukon Schools	20000300410	320110	Pilot Station School	Regular School	No	Other	PK	12	2021	grade_5	0.0							18.0	0							18
1818170	AK	school	200003	32	Lower Yukon Schools	20000300411	320080	Kotlik School	Regular School	No	Other	PK	12	2021	grade_5								21.0								21
1818234	AK	school	200003	32	Lower Yukon Schools	20000300412	320140	Scammon Bay School	Regular School	No	Other	PK	12	2021	grade_5		0.0					0.0	17.0		0					0	17
1818250	AK	school	200003	32	Lower Yukon Schools	20000300413	320150	Nunam Iqua School	Regular School	No	Other	PK	12	2021	grade_5								3.0								3
1818266	AK	school	200003	32	Lower Yukon Schools	20000300767	329010	Hooper Bay Charter School	Regular School	Yes	Middle	04	8	2021	grade_5								12.0								12
1820458	AK	school	200004	54	Yupiit Schools	20000400623	540040	Tuluksak School	Regular School	No	Other	KG	12	2021	grade_5		0.0					0.0	6.0		0					0	6
1820442	AK	school	200004	54	Yupiit Schools	20000400624	540030	Akiak School	Regular School	No	Other	KG	12	2021	grade_5	0.0							12.0	0							12
1820474	AK	school	200004	54	Yupiit Schools	20000400769	548010	Akiachak School	Regular School	No	High	07	12	2021	grade_5							1.0	22.0							1	22
1820490	AK	school	200005	55	Kashunamiut Schools	20000500582	550010	Chevak School	Regular School	No	Other	PK	12	2021	grade_5	0.0							36.0	0							36
1820570	AK	school	200006	98	Mount Edgecumbe	20000600558	980000	Mt. Edgecumbe High School	Regular School	No	High	09	12	2021	grade_5	0.0		0.0	0.0	0.0	0.0	0.0	0.0	0		0	0	0	0	0	0
1820538	AK	school	200007	56	Aleutians East Borough Schools	20000700004	560030	Akutan School	Regular School	No	Other	PK	12	2021	grade_5	0.0						0.0	3.0	0						0	3
1820554	AK	school	200007	56	Aleutians East Borough Schools	20000700007	560050	False Pass School	Regular School	No	Other	PK	12	2021	grade_5	0.0						0.0	1.0	0						0	1
1820506	AK	school	200007	56	Aleutians East Borough Schools	20000700177	560010	King Cove School	Regular School	No	Other	PK	12	2021	grade_5	0.0				0.0			7.0	0				0			7
1820522	AK	school	200007	56	Aleutians East Borough Schools	20000700461	560020	Sand Point School	Regular School	No	Other	PK	12	2021	grade_5	3.0		0.0		1.0	0.0	1.0	10.0	3		0		1	0	1	10
1812826	AK	school	200010	4	Aleutian Region Schools	20001000005	40020	Yakov E. Netsvetov School	Regular School	No	Other	KG	12	2021	grade_5							1.0	1.0							1	1
1812842	AK	school	200010	4	Aleutian Region Schools	20001000080	40080	Adak School	Regular School	No	Other	KG	12	2021	grade_5	0.0		1.0		0.0	0.0		2.0	0		1		0	0		2
1814634	AK	school	200020	7	Bering Strait Schools	20002000012	70180	Gambell School	Regular School	No	Other	PK	12	2021	grade_5	0.0							12.0	0							12
1814506	AK	school	200020	7	Bering Strait Schools	20002000013	70070	Koyuk-Malimiut School	Regular School	No	Other	PK	12	2021	grade_5								10.0								10
1814650	AK	school	200020	7	Bering Strait Schools	20002000014	70200	Hogarth Kingeekuk Sr. Memorial School	Regular School	No	Other	PK	12	2021	grade_5								25.0								25
1814554	AK	school	200020	7	Bering Strait Schools	20002000015	70110	Shishmaref School	Regular School	No	Other	PK	12	2021	grade_5	0.0							22.0	0							22
1814586	AK	school	200020	7	Bering Strait Schools	20002000016	70130	James C. Isabell School	Regular School	No	Other	PK	12	2021	grade_5								4.0								4
1814666	AK	school	200020	7	Bering Strait Schools	20002000017	70260	Unalakleet School	Regular School	No	Other	PK	12	2021	grade_5	0.0		1.0				0.0	13.0	0		1				0	13
1814602	AK	school	200020	7	Bering Strait Schools	20002000018	70150	Wales School	Regular School	No	Other	PK	12	2021	grade_5					0.0			4.0					0			4
1814618	AK	school	200020	7	Bering Strait Schools	20002000019	70160	White Mountain School	Regular School	No	Other	PK	12	2021	grade_5								2.0								2
1814458	AK	school	200020	7	Bering Strait Schools	20002000421	70040	Aniguiin School	Regular School	No	Other	PK	12	2021	grade_5	0.0	0.0						8.0	0	0						8
1814490	AK	school	200020	7	Bering Strait Schools	20002000422	70060	Martin L. Olson School	Regular School	No	Other	PK	12	2021	grade_5	0.0							2.0	0							2
1814442	AK	school	200020	7	Bering Strait Schools	20002000423	70010	Brevig Mission School	Regular School	No	Other	PK	12	2021	grade_5	0.0							22.0	0							22
1814538	AK	school	200020	7	Bering Strait Schools	20002000466	70100	Shaktoolik School	Regular School	No	Other	PK	12	2021	grade_5	0.0							10.0	0							10
1814522	AK	school	200020	7	Bering Strait Schools	20002000467	70080	Anthony A. Andrews School	Regular School	No	Other	PK	12	2021	grade_5	0.0	0.0	0.0					11.0	0	0	0					11
1814570	AK	school	200020	7	Bering Strait Schools	20002000468	70120	Tukurngailnguq School	Regular School	No	Other	PK	12	2021	grade_5	0.0	0.0						17.0	0	0						17
1814474	AK	school	200020	7	Bering Strait Schools	20002000499	70050	Diomede School	Regular School	No	Other	PK	12	2021	grade_5								2.0								2
1814682	AK	school	200030	8	Bristol Bay Borough Schools	20003000020	80010	Bristol Bay Middle/High School	Regular School	No	High	07	12	2021	grade_5	0.0				0.0	0.0	0.0	0.0	0				0	0	0	0
1814698	AK	school	200030	8	Bristol Bay Borough Schools	20003000626	80020	Naknek Elementary	Regular School	No	Elementary	PK	6	2021	grade_5	1.0	0.0	0.0		0.0		1.0	6.0	1	0	0		0		1	6
1814714	AK	school	200030	8	Bristol Bay Borough Schools	20003000751	88010	Bristol Bay Correspondence	Regular School	No	Other	KG	12	2021	grade_5	1.0							2.0	1							2
1812810	AK	school	200050	3	Alaska Gateway Schools	20005000023	38010	Alaska REACH Academy	Regular School	No	Other	PK	12	2021	grade_5	1.0		0.0		0.0		0.0	1.0	1		0		0		0	1
1812698	AK	school	200050	3	Alaska Gateway Schools	20005000024	30010	Dot Lake School	Regular School	No	Other	PK	12	2021	grade_5	0.0						0.0	0.0	0						0	0
1812714	AK	school	200050	3	Alaska Gateway Schools	20005000025	30020	Eagle Community School	Regular School	No	Other	PK	12	2021	grade_5	1.0						0.0	1.0	1						0	1
1812730	AK	school	200050	3	Alaska Gateway Schools	20005000026	30030	Mentasta Lake School	Regular School	No	Other	PK	12	2021	grade_5								3.0								3
1812746	AK	school	200050	3	Alaska Gateway Schools	20005000027	30040	Walter Northway School	Regular School	No	Other	PK	12	2021	grade_5							0.0	5.0							0	5
1812778	AK	school	200050	3	Alaska Gateway Schools	20005000028	30060	Tok School	Regular School	No	Other	PK	12	2021	grade_5	1.0			0.0	0.0		1.0	10.0	1			0	0		1	10
1812762	AK	school	200050	3	Alaska Gateway Schools	20005000424	30050	Tanacross School	Regular School	No	Elementary	PK	8	2021	grade_5							0.0	1.0							0	1
1812794	AK	school	200050	3	Alaska Gateway Schools	20005000528	30070	Tetlin School	Regular School	No	Other	PK	12	2021	grade_5								4.0								4
1814922	AK	school	200060	12	Cordova City Schools	20006000029	120010	Cordova Jr/Sr High School	Regular School	No	High	07	12	2021	grade_5	0.0		0.0	0.0	0.0	0.0	0.0	0.0	0		0	0	0	0	0	0
1814938	AK	school	200060	12	Cordova City Schools	20006000627	120020	Mt. Eccles Elementary	Regular School	No	Elementary	PK	6	2021	grade_5	6.0		1.0	0.0	0.0		2.0	13.0	6		1	0	0		2	13
1814954	AK	school	200060	12	Cordova City Schools	20006000750	128010	Cordova School District Innovative Learning	Regular School	No	Other	KG	12	2021	grade_5	1.0				0.0		0.0	1.0	1				0		0	1
1814842	AK	school	200070	11	Copper River Schools	20007000034	110060	Glennallen Elementary	Regular School	No	Elementary	PK	6	2021	grade_5	8.0		0.0	1.0		0.0	1.0	14.0	8		0	1		0	1	14
1814874	AK	school	200070	11	Copper River Schools	20007000036	110100	Kenny Lake School	Regular School	No	Other	PK	12	2021	grade_5	2.0	0.0					0.0	5.0	2	0					0	5
1814858	AK	school	200070	11	Copper River Schools	20007000039	110070	Glennallen Jr/Sr High School	Regular School	No	High	07	12	2021	grade_5	0.0		0.0			0.0	0.0	0.0	0		0			0	0	0
1814906	AK	school	200070	11	Copper River Schools	20007000398	118010	Upstream Learning Correspondence	Regular School	No	Other	PK	12	2021	grade_5	11.0		0.0	1.0			1.0	15.0	11		0	1			1	15
1814890	AK	school	200070	11	Copper River Schools	20007000583	110110	Slana School	Regular School	No	Other	PK	12	2021	grade_5	0.0							0.0	0							0
1814970	AK	school	200090	13	Craig City Schools	20009000038	130010	Craig High School	Regular School	No	High	09	12	2021	grade_5	0.0						0.0	0.0	0						0	0
1815018	AK	school	200090	13	Craig City Schools	20009000160	138010	PACE Correspondence	Regular School	No	Other	KG	12	2021	grade_5	39.0	2.0	0.0	0.0	3.0	0.0	13.0	68.0	39	2	0	0	3	0	13	68
1815002	AK	school	200090	13	Craig City Schools	20009000433	130030	Craig Middle School	Regular School	No	Middle	06	8	2021	grade_5	0.0						0.0	0.0	0						0	0
1814986	AK	school	200090	13	Craig City Schools	20009000629	130020	Craig Elementary	Regular School	No	Elementary	PK	5	2021	grade_5	6.0				0.0		4.0	11.0	6				0		4	11
1815066	AK	school	200100	14	Delta/Greely Schools	20010000510	140090	Gerstle River School	Regular School	No	Other	KG	12	2021	grade_5	1.0							1.0	1							1
1815034	AK	school	200100	14	Delta/Greely Schools	20010000559	140020	Delta Junction Elementary	Regular School	No	Elementary	PK	5	2021	grade_5	36.0	1.0	6.0	0.0	1.0	0.0	2.0	50.0	36	1	6	0	1	0	2	50
1815098	AK	school	200100	14	Delta/Greely Schools	20010000599	148010	Alaska Homeschool	Regular School	No	Other	PK	12	2021	grade_5	13.0	0.0	0.0	1.0			2.0	16.0	13	0	0	1			2	16
1815050	AK	school	200100	14	Delta/Greely Schools	20010000630	140030	Delta Junction Senior High School	Regular School	No	High	09	12	2021	grade_5	0.0	0.0	0.0		0.0	0.0	0.0	0.0	0	0	0		0	0	0	0
1815082	AK	school	200100	14	Delta/Greely Schools	20010000764	140100	Delta Junction Junior High School	Regular School	No	Middle	06	8	2021	grade_5	0.0		0.0			0.0	0.0	0.0	0		0			0	0	0
1815114	AK	school	200120	15	Dillingham City Schools	20012000042	150010	Dillingham Elementary	Regular School	No	Elementary	PK	5	2021	grade_5	5.0		2.0				4.0	29.0	5		2				4	29
1815130	AK	school	200120	15	Dillingham City Schools	20012000634	150020	Dillingham Middle/High School	Regular School	No	High	06	12	2021	grade_5	0.0		0.0				0.0	0.0	0		0				0	0
1815722	AK	school	200130	17	Galena City Schools	20013000044	170010	Sidney C. Huntington Elementary	Regular School	No	Elementary	PK	6	2021	grade_5	0.0			0.0	0.0		0.0	5.0	0			0	0		0	5
1815770	AK	school	200130	17	Galena City Schools	20013000252	179010	Galena Interior Learning Academy (GILA)	Regular School	No	High	09	12	2021	grade_5	0.0				0.0		0.0	0.0	0				0		0	0
1815754	AK	school	200130	17	Galena City Schools	20013000253	178010	Interior Distance Education of Alaska (IDEA)	Regular School	No	Other	PK	12	2021	grade_5	508.0	12.0	41.0	11.0	7.0	7.0	70.0	723.0	508	12	41	11	7	7	70	723
1815738	AK	school	200130	17	Galena City Schools	20013000635	170020	Sidney C. Huntington Jr/Sr High School	Regular School	No	High	07	12	2021	grade_5	0.0			0.0				0.0	0			0				0
1816938	AK	school	200150	25	Ketchikan Gateway Borough Schools	20015000046	250010	Houghtaling Elementary	Regular School	No	Elementary	PK	6	2021	grade_5	11.0	0.0	1.0	0.0	14.0	1.0	5.0	41.0	11	0	1	0	14	1	5	41