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 total 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	school_state_type	ccd_school_type	ccd_charter_school	ccd_school_lvl	ccd_school_low_grade	ccd_school_high_grade	year	grade	total	total_int
127544	HI	school	1500030	1	Hawaii Department of Education	150003000222	105	DOLE MID		Regular School	No	Middle	06	8	2017	grade_4	0.0	0
127545	HI	school	1500030	1	Hawaii Department of Education	150003000221	106	FARRINGTON HI		Regular School	No	High	09	12	2017	grade_4	0.0	0
127548	HI	school	1500030	1	Hawaii Department of Education	150003000096	470	HSDB		Special Education School	No	Other	PK	12	2017	grade_4	0.0	0
127551	HI	school	1500030	1	Hawaii Department of Education	150003000211	116	KAIMUKI MID		Regular School	No	Middle	06	8	2017	grade_4	0.0	0
127552	HI	school	1500030	1	Hawaii Department of Education	150003000228	154	KAISER HI		Regular School	No	High	09	12	2017	grade_4	0.0	0
127553	HI	school	1500030	1	Hawaii Department of Education	150003000164	118	KALAKAUA MID		Regular School	No	Middle	06	8	2017	grade_4	0.0	0
127554	HI	school	1500030	1	Hawaii Department of Education	150003000163	119	KALANI HI		Regular School	No	High	09	12	2017	grade_4	0.0	0
127563	HI	school	1500030	1	Hawaii Department of Education	150003000198	133	LINAPUNI		Regular School	No	Elementary	PK	1	2017	grade_4	0.0	0
127564	HI	school	1500030	1	Hawaii Department of Education	150003000192	139	NIU VALLEY MID		Regular School	No	Middle	06	8	2017	grade_4	0.0	0
127571	HI	school	1500030	1	Hawaii Department of Education	150003000223	104	CENTRAL MID		Regular School	No	Middle	06	8	2017	grade_4	0.0	0
127573	HI	school	1500030	1	Hawaii Department of Education	150003000218	110	JARRETT MID		Regular School	No	Middle	06	8	2017	grade_4	0.0	0
127576	HI	school	1500030	1	Hawaii Department of Education	150003000212	115	KAIMUKI HI		Regular School	No	High	09	12	2017	grade_4	0.0	0
127579	HI	school	1500030	1	Hawaii Department of Education	150003000205	126	KAWANANAKOA MID		Regular School	No	Middle	06	8	2017	grade_4	0.0	0
127587	HI	school	1500030	1	Hawaii Department of Education	150003000193	138	MCKINLEY HI		Regular School	No	High	09	12	2017	grade_4	0.0	0
127592	HI	school	1500030	1	Hawaii Department of Education	150003000186	146	ROOSEVELT HI		Regular School	No	High	09	12	2017	grade_4	0.0	0
127594	HI	school	1500030	1	Hawaii Department of Education	150003000184	148	STEVENSON MID		Regular School	No	Middle	06	8	2017	grade_4	0.0	0
127595	HI	school	1500030	1	Hawaii Department of Education	150003000180	152	WASHINGTON MID		Regular School	No	Middle	06	8	2017	grade_4	0.0	0
127597	HI	school	1500030	1	Hawaii Department of Education	150003000177	202	AIEA HI		Regular School	No	High	09	12	2017	grade_4	0.0	0
127598	HI	school	1500030	1	Hawaii Department of Education	150003000176	201	AIEA INT		Regular School	No	Middle	07	8	2017	grade_4	0.0	0
127600	HI	school	1500030	1	Hawaii Department of Education	150003000174	204	ALIAMANU INT		Regular School	No	Middle	07	8	2017	grade_4	0.0	0
127604	HI	school	1500030	1	Hawaii Department of Education	150003000103	218	MOANALUA HI		Regular School	No	High	09	12	2017	grade_4	0.0	0
127605	HI	school	1500030	1	Hawaii Department of Education	150003000156	219	MOANALUA MID		Regular School	No	Middle	07	8	2017	grade_4	0.0	0
127611	HI	school	1500030	1	Hawaii Department of Education	150003000150	224	RADFORD HI		Regular School	No	High	09	12	2017	grade_4	0.0	0
127624	HI	school	1500030	1	Hawaii Department of Education	150003000108	214	LEILEHUA HI		Regular School	No	High	09	12	2017	grade_4	0.0	0
127625	HI	school	1500030	1	Hawaii Department of Education	150003000102	216	MILILANI HI		Regular School	No	High	09	12	2017	grade_4	0.0	0
127628	HI	school	1500030	1	Hawaii Department of Education	150003000256	238	MILILANI MID		Regular School	No	Middle	06	8	2017	grade_4	0.0	0
127633	HI	school	1500030	1	Hawaii Department of Education	150003000143	230	WAHIAWA MID		Regular School	No	Middle	06	8	2017	grade_4	0.0	0
127635	HI	school	1500030	1	Hawaii Department of Education	150003000141	232	WAIALUA HI & INT		Regular School	No	High	07	12	2017	grade_4	0.0	0
127637	HI	school	1500030	1	Hawaii Department of Education	150003000137	237	WHEELER MID		Regular School	No	Middle	06	8	2017	grade_4	0.0	0
127639	HI	school	1500030	1	Hawaii Department of Education	150003000134	252	CAMPBELL HI		Regular School	No	High	09	12	2017	grade_4	0.0	0
127642	HI	school	1500030	1	Hawaii Department of Education	150003000296	296	EWA MAKAI MID		Regular School	No	Middle	07	8	2017	grade_4	0.0	0
127645	HI	school	1500030	1	Hawaii Department of Education	150003000129	279	ILIMA INT		Regular School	No	Middle	07	8	2017	grade_4	0.0	0
127649	HI	school	1500030	1	Hawaii Department of Education	150003000261	292	KAPOLEI HI		Regular School	No	High	09	12	2017	grade_4	0.0	0
127650	HI	school	1500030	1	Hawaii Department of Education	150003000259	291	KAPOLEI MID		Regular School	No	Middle	06	8	2017	grade_4	0.0	0
127660	HI	school	1500030	1	Hawaii Department of Education	150003000117	263	NANAKULI HI & INT		Regular School	No	High	07	12	2017	grade_4	0.0	0
127662	HI	school	1500030	1	Hawaii Department of Education	150003000110	272	WAIANAE HI		Regular School	No	High	09	12	2017	grade_4	0.0	0
127663	HI	school	1500030	1	Hawaii Department of Education	150003000229	273	WAIANAE INT		Regular School	No	Middle	07	8	2017	grade_4	0.0	0
127665	HI	school	1500030	1	Hawaii Department of Education	150003000131	255	HIGHLANDS INT		Regular School	No	Middle	07	8	2017	grade_4	0.0	0
127675	HI	school	1500030	1	Hawaii Department of Education	150003000114	266	PEARL CITY HI		Regular School	No	High	09	12	2017	grade_4	0.0	0
127679	HI	school	1500030	1	Hawaii Department of Education	150003000161	277	WAIPAHU HI		Regular School	No	High	09	12	2017	grade_4	0.0	0
127680	HI	school	1500030	1	Hawaii Department of Education	150003000158	278	WAIPAHU INT		Regular School	No	Middle	07	8	2017	grade_4	0.0	0
127682	HI	school	1500030	1	Hawaii Department of Education	150003000100	301	CASTLE HI		Regular School	No	High	09	12	2017	grade_4	0.0	0
127688	HI	school	1500030	1	Hawaii Department of Education	150003000007	307	KAHUKU HI		Regular School	No	High	07	12	2017	grade_4	0.0	0
127691	HI	school	1500030	1	Hawaii Department of Education	150003000016	318	KING INT		Regular School	No	Middle	07	8	2017	grade_4	0.0	0
127701	HI	school	1500030	1	Hawaii Department of Education	150003000009	309	KAILUA HI		Regular School	No	High	09	12	2017	grade_4	0.0	0
127702	HI	school	1500030	1	Hawaii Department of Education	150003000010	310	KAILUA INT		Regular School	No	Middle	07	8	2017	grade_4	0.0	0
127704	HI	school	1500030	1	Hawaii Department of Education	150003000012	312	KALAHEO HI		Regular School	No	High	09	12	2017	grade_4	0.0	0
127708	HI	school	1500030	1	Hawaii Department of Education	150003000098	475	OLOMANA		Alternative School	No	High	07	12	2017	grade_4	0.0	0
127713	HI	school	1500030	1	Hawaii Department of Education	150003000029	355	HILO HI		Regular School	No	High	09	12	2017	grade_4	0.0	0
127714	HI	school	1500030	1	Hawaii Department of Education	150003000030	356	HILO INT		Regular School	No	Middle	07	8	2017	grade_4	0.0	0
127721	HI	school	1500030	1	Hawaii Department of Education	150003000052	389	WAIAKEA HI		Regular School	No	High	09	12	2017	grade_4	0.0	0
127722	HI	school	1500030	1	Hawaii Department of Education	150003000053	385	WAIAKEA INT		Regular School	No	Middle	06	8	2017	grade_4	0.0	0
127727	HI	school	1500030	1	Hawaii Department of Education	150003000034	360	HONOKAA HI & INT		Regular School	No	High	07	12	2017	grade_4	0.0	0
127732	HI	school	1500030	1	Hawaii Department of Education	150003000254	392	KEALAKEHE HI		Regular School	No	High	09	12	2017	grade_4	0.0	0
127733	HI	school	1500030	1	Hawaii Department of Education	150003000235	390	KEALAKEHE INT		Regular School	No	Middle	06	8	2017	grade_4	0.0	0
127735	HI	school	1500030	1	Hawaii Department of Education	150003000043	373	KOHALA HI		Regular School	No	High	09	12	2017	grade_4	0.0	0
127736	HI	school	1500030	1	Hawaii Department of Education	150003000267	366	KOHALA MID		Regular School	No	Middle	06	8	2017	grade_4	0.0	0
127738	HI	school	1500030	1	Hawaii Department of Education	150003000045	374	KONAWAENA HI		Regular School	No	High	09	12	2017	grade_4	0.0	0
127739	HI	school	1500030	1	Hawaii Department of Education	150003000252	376	KONAWAENA MID		Regular School	No	Middle	06	8	2017	grade_4	0.0	0
127745	HI	school	1500030	1	Hawaii Department of Education	150003000260	354	KEAAU HI		Regular School	No	High	09	12	2017	grade_4	0.0	0
127746	HI	school	1500030	1	Hawaii Department of Education	150003000040	370	KEAAU MID		Regular School	No	Middle	06	8	2017	grade_4	0.0	0
127751	HI	school	1500030	1	Hawaii Department of Education	150003000050	383	PAHOA HI & INT		Regular School	No	High	07	12	2017	grade_4	0.0	0
127752	HI	school	1500030	1	Hawaii Department of Education	150003000056	400	BALDWIN HI		Regular School	No	High	09	12	2017	grade_4	0.0	0
127754	HI	school	1500030	1	Hawaii Department of Education	150003000059	404	IAO INT		Regular School	No	Middle	06	8	2017	grade_4	0.0	0
127756	HI	school	1500030	1	Hawaii Department of Education	150003000233	420	KALAMA INT		Regular School	No	Middle	06	8	2017	grade_4	0.0	0
127758	HI	school	1500030	1	Hawaii Department of Education	150003000251	435	KEKAULIKE HI		Regular School	No	High	09	12	2017	grade_4	0.0	0
127762	HI	school	1500030	1	Hawaii Department of Education	150003000238	430	LOKELANI INT		Regular School	No	Middle	06	8	2017	grade_4	0.0	0
127764	HI	school	1500030	1	Hawaii Department of Education	150003000073	418	MAUI HI		Regular School	No	High	09	12	2017	grade_4	0.0	0
127765	HI	school	1500030	1	Hawaii Department of Education	150003000241	428	MAUI WAENA INT		Regular School	No	Middle	06	8	2017	grade_4	0.0	0
127776	HI	school	1500030	1	Hawaii Department of Education	150003000068	413	LAHAINA INT		Regular School	No	Middle	06	8	2017	grade_4	0.0	0
127777	HI	school	1500030	1	Hawaii Department of Education	150003000069	414	LAHAINALUNA HI		Regular School	No	High	09	12	2017	grade_4	0.0	0
127780	HI	school	1500030	1	Hawaii Department of Education	150003000075	421	MOLOKAI HI		Regular School	No	High	09	12	2017	grade_4	0.0	0
127781	HI	school	1500030	1	Hawaii Department of Education	150003000290	434	MOLOKAI MID		Regular School	No	Middle	07	8	2017	grade_4	0.0	0
127786	HI	school	1500030	1	Hawaii Department of Education	150003000266	448	KAMAKAHELEI MID		Regular School	No	Middle	06	8	2017	grade_4	0.0	0
127788	HI	school	1500030	1	Hawaii Department of Education	150003000085	455	KAPAA HI		Regular School	No	High	09	12	2017	grade_4	0.0	0
127789	HI	school	1500030	1	Hawaii Department of Education	150003000255	447	KAPAA MID		Regular School	No	Middle	06	8	2017	grade_4	0.0	0
127790	HI	school	1500030	1	Hawaii Department of Education	150003000086	456	KAUAI HI		Regular School	No	High	09	12	2017	grade_4	0.0	0
127796	HI	school	1500030	1	Hawaii Department of Education	150003000092	464	WAIMEA CANYON		Regular School	No	Middle	06	8	2017	grade_4	0.0	0
127797	HI	school	1500030	1	Hawaii Department of Education	150003000093	462	WAIMEA HI		Regular School	No	High	09	12	2017	grade_4	0.0	0
127814	HI	school	1500030	1	Hawaii Department of Education	150003000278	549	KE ANA LA'AHANA-PCS	charter	Regular School	Yes	High	07	12	2017	grade_4	0.0	0
127827	HI	school	1500030	1	Hawaii Department of Education	150003000298	567	SEEQS	charter	Regular School	Yes	Middle	06	8	2017	grade_4	0.0	0
127831	HI	school	1500030	1	Hawaii Department of Education	150003000268	394	WAIMEA MID-PCCS	charter	Regular School	Yes	Middle	06	8	2017	grade_4	0.0	0
127832	HI	school	1500030	1	Hawaii Department of Education	150003000265	399	WEST HI EXPLOR ACAD-PCS	charter	Regular School	Yes	Other	06	12	2017	grade_4	0.0	0
127800	HI	school	1500030	1	Hawaii Department of Education	150003000273	543	EDUC LAB: A HAWAII NC-PCS	charter	Regular School	Yes	Other	KG	12	2017	grade_4	10.0	10
127586	HI	school	1500030	1	Hawaii Department of Education	150003000194	137	MANOA		Regular School	No	Elementary	PK	5	2017	grade_4	100.0	100
127556	HI	school	1500030	1	Hawaii Department of Education	150003000160	121	KALIHI-KAI		Regular School	No	Elementary	PK	5	2017	grade_4	101.0	101
127646	HI	school	1500030	1	Hawaii Department of Education	150003000128	256	IROQUOIS POINT		Regular School	No	Elementary	PK	6	2017	grade_4	101.0	101
127782	HI	school	1500030	1	Hawaii Department of Education	150003000237	429	NAHIENAENA		Regular School	No	Elementary	PK	5	2017	grade_4	101.0	101
127636	HI	school	1500030	1	Hawaii Department of Education	150003000138	236	WHEELER EL		Regular School	No	Elementary	PK	5	2017	grade_4	102.0	102
127658	HI	school	1500030	1	Hawaii Department of Education	150003000119	261	NANAIKAPONO		Regular School	No	Elementary	PK	6	2017	grade_4	102.0	102
127767	HI	school	1500030	1	Hawaii Department of Education	150003000292	433	POMAIKAI		Regular School	No	Elementary	PK	5	2017	grade_4	102.0	102
127603	HI	school	1500030	1	Hawaii Department of Education	150003000104	217	MOANALUA EL		Regular School	No	Elementary	PK	6	2017	grade_4	103.0	103
127640	HI	school	1500030	1	Hawaii Department of Education	150003000132	254	EWA BEACH EL		Regular School	No	Elementary	PK	6	2017	grade_4	104.0	104
127723	HI	school	1500030	1	Hawaii Department of Education	150003000054	386	WAIAKEAWAENA		Regular School	No	Elementary	PK	5	2017	grade_4	104.0	104
127618	HI	school	1500030	1	Hawaii Department of Education	150003000173	207	INOUYE		Regular School	No	Elementary	PK	5	2017	grade_4	105.0	105
127623	HI	school	1500030	1	Hawaii Department of Education	150003000167	212	KIPAPA		Regular School	No	Elementary	PK	5	2017	grade_4	105.0	105
127629	HI	school	1500030	1	Hawaii Department of Education	150003000106	242	MILILANI UKA		Regular School	No	Elementary	PK	5	2017	grade_4	106.0	106
127666	HI	school	1500030	1	Hawaii Department of Education	150003000130	276	HONOWAI		Regular School	No	Elementary	PK	6	2017	grade_4	106.0	106
127707	HI	school	1500030	1	Hawaii Department of Education	150003000020	322	MOKAPU		Regular School	No	Elementary	PK	6	2017	grade_4	106.0	106
127729	HI	school	1500030	1	Hawaii Department of Education	150003000232	371	KAHAKAI		Regular School	No	Elementary	PK	5	2017	grade_4	106.0	106
127547	HI	school	1500030	1	Hawaii Department of Education	150003000219	108	HAHAIONE		Regular School	No	Elementary	PK	5	2017	grade_4	108.0	108