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 (native_hawaiian_pacific_islander > :p3 or (native_hawaiian_pacific_islander = :p3 and rowid > :p2)) order by native_hawaiian_pacific_islander, 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	multiracial	total	white_int	black_int	hispanic_int	native_american_int	asian_int	multiracial_int	total_int
1734189	AK	school	200390	24	Kenai Peninsula Borough Schools	20039000165	240150	Ninilchik School	Regular School	No	Other	PK	12.0	2020	grade_7	6.0	0.0	0.0	0.0	0.0	2.0	8	6	0	0	0	0	2	8
1734205	AK	school	200390	24	Kenai Peninsula Borough Schools	20039000168	240180	Port Graham School	Regular School	No	Other	PK	12.0	2020	grade_7			0.0			2.0	3			0			2	3
1734237	AK	school	200390	24	Kenai Peninsula Borough Schools	20039000540	240200	Seward High School	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	0	0	0
1734301	AK	school	200390	24	Kenai Peninsula Borough Schools	20039000175	240250	Susan B English School	Regular School	No	Other	PK	12.0	2020	grade_7	0.0	0.0	0.0		0.0	0.0	0	0	0	0		0	0	0
1734317	AK	school	200390	24	Kenai Peninsula Borough Schools	20039000176	240270	Tustumena Elementary	Regular School	No	Elementary	PK	6.0	2020	grade_7	0.0		0.0	0.0	0.0	0.0	0	0		0	0	0	0	0
1734333	AK	school	200390	24	Kenai Peninsula Borough Schools	20039000153	240280	Tebughna School	Regular School	No	Other	PK	12.0	2020	grade_7			0.0			0.0	4			0			0	4
1734413	AK	school	200390	24	Kenai Peninsula Borough Schools	20039000601	240370	Mt. View Elementary	Regular School	No	Elementary	PK	5.0	2020	grade_7	0.0	0.0	0.0	0.0	0.0	0.0	0	0	0	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
1734445	AK	school	200390	24	Kenai Peninsula Borough Schools	20039000645	240390	Nikiski Middle/Senior High School	Regular School	No	High	06	12.0	2020	grade_7	38.0		0.0	0.0	0.0	4.0	50	38		0	0	0	4	50
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
1734477	AK	school	200390	24	Kenai Peninsula Borough Schools	20039000299	240490	West Homer Elementary	Regular School	No	Elementary	03	6.0	2020	grade_7	0.0		0.0	0.0	0.0	0.0	0	0		0	0	0	0	0
1734493	AK	school	200390	24	Kenai Peninsula Borough Schools	20039000437	240500	Seward Middle School	Regular School	No	Middle	06	8.0	2020	grade_7	41.0	0.0	4.0	1.0	1.0	6.0	57	41	0	4	1	1	6	57
1734509	AK	school	200390	24	Kenai Peninsula Borough Schools	20039000397	247010	Connections	Regular School	No	Other	KG	12.0	2020	grade_7	65.0	0.0	1.0	0.0	0.0	9.0	78	65	0	1	0	0	9	78
1734525	AK	school	200390	24	Kenai Peninsula Borough Schools	20039000081	247020	Homer Flex School	Alternative School	No	High	09	12.0	2020	grade_7	0.0		0.0			0.0	0	0		0			0	0
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
1734573	AK	school	200390	24	Kenai Peninsula Borough Schools	20039000735	247060	River City Academy	Regular School	No	High	07	12.0	2020	grade_7	13.0		0.0			1.0	15	13		0			1	15
1734621	AK	school	200390	24	Kenai Peninsula Borough Schools	20039000448	249040	Soldotna Montessori Charter School	Regular School	Yes	Elementary	KG	6.0	2020	grade_7	0.0		0.0	0.0	0.0	0.0	0	0		0	0	0	0	0
1734701	AK	school	200150	25	Ketchikan Gateway Borough Schools	20015000052	250050	Fawn Mountain Elementary	Regular School	No	Elementary	PK	6.0	2020	grade_7	0.0	0.0	0.0	0.0	0.0	0.0	0	0	0	0	0	0	0	0
1734749	AK	school	200150	25	Ketchikan Gateway Borough Schools	20015000427	258010	Fast Track	Regular School	No	Other	KG	12.0	2020	grade_7	0.0		0.0		0.0	0.0	1	0		0		0	0	1
1734797	AK	school	200450	27	Klawock City Schools	20045000179	270010	Klawock City School	Regular School	No	Other	PK	12.0	2020	grade_7	0.0		1.0	0.0		0.0	6	0		1	0		0	6
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
1734829	AK	school	200480	28	Kodiak Island Borough Schools	20048000181	280020	Chiniak School	Regular School	No	Other	KG	12.0	2020	grade_7	0.0		0.0				1	0		0				1
1734877	AK	school	200480	28	Kodiak Island Borough Schools	20048000190	280060	Peterson Elementary	Regular School	No	Elementary	PK	5.0	2020	grade_7	0.0	0.0	0.0	0.0	0.0	0.0	0	0	0	0	0	0	0	0
1734925	AK	school	200480	28	Kodiak Island Borough Schools	20048000189	280100	Old Harbor School	Regular School	No	Other	KG	12.0	2020	grade_7	0.0		0.0				1	0		0				1
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
1735229	AK	school	200485	30	Lake and Peninsula Borough Schools	20048500199	300090	Newhalen School	Regular School	No	Other	PK	12.0	2020	grade_7	0.0		0.0	0.0		0.0	3	0		0	0		0	3
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
1735389	AK	school	200001	31	Lower Kuskokwim Schools	20000100436	310050	Mikelnguut Elitnaurviat	Regular School	No	Elementary	PK	2.0	2020	grade_7	0.0	0.0	0.0	0.0	0.0	0.0	0	0	0	0	0	0	0	0
1735405	AK	school	200001	31	Lower Kuskokwim Schools	20000100207	310060	Gladys Jung Elementary	Regular School	No	Elementary	03	6.0	2020	grade_7	0.0	0.0	0.0	0.0	0.0	0.0	0	0	0	0	0	0	0	0
1735421	AK	school	200001	31	Lower Kuskokwim Schools	20000100208	310070	Bethel Regional High School	Regular School	No	High	07	12.0	2020	grade_7	9.0	0.0	1.0	1.0	1.0	0.0	99	9	0	1	1	1	0	99
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
1735661	AK	school	200001	31	Lower Kuskokwim Schools	20000100441	310220	Kuinerrarmiut Elitnaurviat	Regular School	No	Other	PK	12.0	2020	grade_7							18							18
1735677	AK	school	200001	31	Lower Kuskokwim Schools	20000100215	310230	Arviq School	Regular School	No	Other	KG	12.0	2020	grade_7		0.0				1.0	1		0				1	1
1735693	AK	school	200001	31	Lower Kuskokwim Schools	20000100619	310240	Akiuk Memorial School	Regular School	No	Other	PK	12.0	2020	grade_7	0.0						13	0						13
1735709	AK	school	200001	31	Lower Kuskokwim Schools	20000100213	310250	Nelson Island Area School	Regular School	No	Other	PK	12.0	2020	grade_7	0.0						9	0						9
1735725	AK	school	200001	31	Lower Kuskokwim Schools	20000100475	310280	Qugcuun Memorial School	Regular School	No	Other	PK	12.0	2020	grade_7							0							0
1735741	AK	school	200001	31	Lower Kuskokwim Schools	20000100389	310320	Paul T. Albert Memorial School	Regular School	No	Other	PK	12.0	2020	grade_7							7							7
1735757	AK	school	200001	31	Lower Kuskokwim Schools	20000100318	317010	Kuskokwim Learning Academy	Alternative School	No	High	09	12.0	2020	grade_7	0.0		0.0				0	0		0				0
1735773	AK	school	200001	31	Lower Kuskokwim Schools	20000100620	317020	Bethel Youth Facility	Alternative School	No	High	05	12.0	2020	grade_7							1							1
1735789	AK	school	200001	31	Lower Kuskokwim Schools	20000100329	319010	Ayaprun Elitnaurvik	Regular School	Yes	Elementary	PK	6.0	2020	grade_7	0.0						0	0						0
1735805	AK	school	200003	32	Lower Yukon Schools	20000300216	320010	Alakanuk School	Regular School	No	Other	PK	12.0	2020	grade_7	0.0						28	0						28
1735821	AK	school	200003	32	Lower Yukon Schools	20000300217	320040	Emmonak School	Regular School	No	Other	PK	12.0	2020	grade_7	0.0					0.0	17	0					0	17
1735837	AK	school	200003	32	Lower Yukon Schools	20000300218	320050	Marshall School	Regular School	No	Other	PK	12.0	2020	grade_7						0.0	9						0	9
1735853	AK	school	200003	32	Lower Yukon Schools	20000300219	320070	Hooper Bay School	Regular School	No	Other	PK	12.0	2020	grade_7	0.0	1.0				0.0	39	0	1				0	39
1735869	AK	school	200003	32	Lower Yukon Schools	20000300411	320080	Kotlik School	Regular School	No	Other	PK	12.0	2020	grade_7		0.0					16		0					16
1735885	AK	school	200003	32	Lower Yukon Schools	20000300220	320090	Mountain Village School	Regular School	No	Other	PK	12.0	2020	grade_7	2.0						20	2						20
1735901	AK	school	200003	32	Lower Yukon Schools	20000300410	320110	Pilot Station School	Regular School	No	Other	PK	12.0	2020	grade_7	0.0						10	0						10
1735917	AK	school	200003	32	Lower Yukon Schools	20000300222	320130	Russian Mission School	Regular School	No	Other	PK	12.0	2020	grade_7						0.0	6						0	6
1735933	AK	school	200003	32	Lower Yukon Schools	20000300412	320140	Scammon Bay School	Regular School	No	Other	PK	12.0	2020	grade_7		0.0					13		0					13
1735949	AK	school	200003	32	Lower Yukon Schools	20000300413	320150	Nunam Iqua School	Regular School	No	Other	PK	12.0	2020	grade_7							5							5
1735981	AK	school	200510	33	Mat-Su Borough Schools	20051000225	330030	Glacier View School	Regular School	No	Other	KG	12.0	2020	grade_7	5.0		1.0			1.0	7	5		1			1	7
1736109	AK	school	200510	33	Mat-Su Borough Schools	20051000547	330180	Tanaina Elementary	Regular School	No	Elementary	PK	5.0	2020	grade_7	0.0	0.0	0.0	0.0	0.0	0.0	0	0	0	0	0	0	0	0
1736237	AK	school	200510	33	Mat-Su Borough Schools	20051000721	330320	Willow Elementary	Regular School	No	Elementary	PK	5.0	2020	grade_7	0.0		0.0			0.0	0	0		0			0	0
1736253	AK	school	200510	33	Mat-Su Borough Schools	20051000722	330330	Trapper Creek Elementary	Regular School	No	Elementary	PK	5.0	2020	grade_7	0.0				0.0	0.0	0	0				0	0	0
1736285	AK	school	200510	33	Mat-Su Borough Schools	20051000724	330350	Butte Elementary	Regular School	No	Elementary	PK	5.0	2020	grade_7	0.0	0.0	0.0	0.0	0.0	0.0	0	0	0	0	0	0	0	0
1736301	AK	school	200510	33	Mat-Su Borough Schools	20051000725	330360	Sutton Elementary	Regular School	No	Elementary	PK	5.0	2020	grade_7	0.0		0.0		0.0	0.0	0	0		0		0	0	0
1736317	AK	school	200510	33	Mat-Su Borough Schools	20051000726	330370	Beryozova School	Regular School	No	Other	KG	12.0	2020	grade_7	1.0			1.0			2	1			1			2
1736381	AK	school	200510	33	Mat-Su Borough Schools	20051000443	330430	Larson Elementary	Regular School	No	Elementary	PK	5.0	2020	grade_7	0.0	0.0	0.0	0.0	0.0	0.0	0	0	0	0	0	0	0	0
1736589	AK	school	200510	33	Mat-Su Borough Schools	20051000734	337060	Mat-Su Day School	Special Education School	No	Other	KG	12.0	2020	grade_7	3.0		1.0	0.0	0.0	0.0	5	3		1	0	0	0	5
1736653	AK	school	200510	33	Mat-Su Borough Schools	20051000312	339020	Midnight Sun Family Learning Center	Regular School	Yes	Elementary	KG	8.0	2020	grade_7	8.0	0.0	4.0	1.0	1.0	2.0	18	8	0	4	1	1	2	18
1736701	AK	school	200510	33	Mat-Su Borough Schools	20051000744	339050	Birchtree Charter School	Regular School	Yes	Elementary	KG	8.0	2020	grade_7	15.0	0.0	4.0	0.0	1.0	6.0	30	15	0	4	0	1	6	30
1736717	AK	school	200540	34	Nenana City Schools	20054000251	340010	Nenana City School	Regular School	No	Other	KG	12.0	2020	grade_7	6.0	0.0	0.0		1.0	0.0	10	6	0	0		1	0	10
1736781	AK	school	200570	35	Nome Public Schools	20057000426	358010	Extensions Correspondence	Regular School	No	Other	KG	12.0	2020	grade_7	1.0		0.0				1	1		0				1
1736797	AK	school	200570	35	Nome Public Schools	20057000323	359010	Anvil City Science Academy	Regular School	Yes	Middle	05	8.0	2020	grade_7	1.0				0.0	7.0	15	1				0	7	15
1736813	AK	school	200610	36	North Slope Borough Schools	20061000283	360010	Nunamiut School	Regular School	No	Other	PK	12.0	2020	grade_7	0.0					1.0	4	0					1	4