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 ccd_school_high_grade 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
128723	HI	school	1500030	1	Hawaii Department of Education	150003000198	133	LINAPUNI		Regular School	No	Elementary	PK	1	2017	grade_8	0.0	0
128705	HI	school	1500030	1	Hawaii Department of Education	150003000221	106	FARRINGTON HI		Regular School	No	High	09	12	2017	grade_8	0.0	0
128708	HI	school	1500030	1	Hawaii Department of Education	150003000096	470	HSDB		Special Education School	No	Other	PK	12	2017	grade_8	0.0	0
128712	HI	school	1500030	1	Hawaii Department of Education	150003000228	154	KAISER HI		Regular School	No	High	09	12	2017	grade_8	0.0	0
128714	HI	school	1500030	1	Hawaii Department of Education	150003000163	119	KALANI HI		Regular School	No	High	09	12	2017	grade_8	0.0	0
128730	HI	school	1500030	1	Hawaii Department of Education	150003000246	103	ANUENUE		Regular School	No	Other	PK	12	2017	grade_8	30.0	30
128736	HI	school	1500030	1	Hawaii Department of Education	150003000212	115	KAIMUKI HI		Regular School	No	High	09	12	2017	grade_8	0.0	0
128747	HI	school	1500030	1	Hawaii Department of Education	150003000193	138	MCKINLEY HI		Regular School	No	High	09	12	2017	grade_8	0.0	0
128752	HI	school	1500030	1	Hawaii Department of Education	150003000186	146	ROOSEVELT HI		Regular School	No	High	09	12	2017	grade_8	0.0	0
128757	HI	school	1500030	1	Hawaii Department of Education	150003000177	202	AIEA HI		Regular School	No	High	09	12	2017	grade_8	0.0	0
128764	HI	school	1500030	1	Hawaii Department of Education	150003000103	218	MOANALUA HI		Regular School	No	High	09	12	2017	grade_8	0.0	0
128771	HI	school	1500030	1	Hawaii Department of Education	150003000150	224	RADFORD HI		Regular School	No	High	09	12	2017	grade_8	0.0	0
128784	HI	school	1500030	1	Hawaii Department of Education	150003000108	214	LEILEHUA HI		Regular School	No	High	09	12	2017	grade_8	0.0	0
128785	HI	school	1500030	1	Hawaii Department of Education	150003000102	216	MILILANI HI		Regular School	No	High	09	12	2017	grade_8	0.0	0
128795	HI	school	1500030	1	Hawaii Department of Education	150003000141	232	WAIALUA HI & INT		Regular School	No	High	07	12	2017	grade_8	110.0	110
128799	HI	school	1500030	1	Hawaii Department of Education	150003000134	252	CAMPBELL HI		Regular School	No	High	09	12	2017	grade_8	0.0	0
128809	HI	school	1500030	1	Hawaii Department of Education	150003000261	292	KAPOLEI HI		Regular School	No	High	09	12	2017	grade_8	0.0	0
128820	HI	school	1500030	1	Hawaii Department of Education	150003000117	263	NANAKULI HI & INT		Regular School	No	High	07	12	2017	grade_8	126.0	126
128822	HI	school	1500030	1	Hawaii Department of Education	150003000110	272	WAIANAE HI		Regular School	No	High	09	12	2017	grade_8	0.0	0
128835	HI	school	1500030	1	Hawaii Department of Education	150003000114	266	PEARL CITY HI		Regular School	No	High	09	12	2017	grade_8	0.0	0
128839	HI	school	1500030	1	Hawaii Department of Education	150003000161	277	WAIPAHU HI		Regular School	No	High	09	12	2017	grade_8	0.0	0
128842	HI	school	1500030	1	Hawaii Department of Education	150003000100	301	CASTLE HI		Regular School	No	High	09	12	2017	grade_8	0.0	0
128848	HI	school	1500030	1	Hawaii Department of Education	150003000007	307	KAHUKU HI		Regular School	No	High	07	12	2017	grade_8	202.0	202
128861	HI	school	1500030	1	Hawaii Department of Education	150003000009	309	KAILUA HI		Regular School	No	High	09	12	2017	grade_8	0.0	0
128864	HI	school	1500030	1	Hawaii Department of Education	150003000012	312	KALAHEO HI		Regular School	No	High	09	12	2017	grade_8	0.0	0
128868	HI	school	1500030	1	Hawaii Department of Education	150003000098	475	OLOMANA		Alternative School	No	High	07	12	2017	grade_8	7.0	7
128873	HI	school	1500030	1	Hawaii Department of Education	150003000029	355	HILO HI		Regular School	No	High	09	12	2017	grade_8	0.0	0
128881	HI	school	1500030	1	Hawaii Department of Education	150003000052	389	WAIAKEA HI		Regular School	No	High	09	12	2017	grade_8	0.0	0
128887	HI	school	1500030	1	Hawaii Department of Education	150003000034	360	HONOKAA HI & INT		Regular School	No	High	07	12	2017	grade_8	44.0	44
128890	HI	school	1500030	1	Hawaii Department of Education	150003000287	378	KE KULA O EHUNUIKAIMALINO		Regular School	No	Other	PK	12	2017	grade_8	21.0	21
128892	HI	school	1500030	1	Hawaii Department of Education	150003000254	392	KEALAKEHE HI		Regular School	No	High	09	12	2017	grade_8	0.0	0
128895	HI	school	1500030	1	Hawaii Department of Education	150003000043	373	KOHALA HI		Regular School	No	High	09	12	2017	grade_8	0.0	0
128898	HI	school	1500030	1	Hawaii Department of Education	150003000045	374	KONAWAENA HI		Regular School	No	High	09	12	2017	grade_8	0.0	0
128903	HI	school	1500030	1	Hawaii Department of Education	150003000038	368	KAU HI/PAHALA EL		Regular School	No	Other	PK	12	2017	grade_8	60.0	60
128905	HI	school	1500030	1	Hawaii Department of Education	150003000260	354	KEAAU HI		Regular School	No	High	09	12	2017	grade_8	0.0	0
128911	HI	school	1500030	1	Hawaii Department of Education	150003000050	383	PAHOA HI & INT		Regular School	No	High	07	12	2017	grade_8	66.0	66
128912	HI	school	1500030	1	Hawaii Department of Education	150003000056	400	BALDWIN HI		Regular School	No	High	09	12	2017	grade_8	0.0	0
128918	HI	school	1500030	1	Hawaii Department of Education	150003000251	435	KEKAULIKE HI		Regular School	No	High	09	12	2017	grade_8	0.0	0
128924	HI	school	1500030	1	Hawaii Department of Education	150003000073	418	MAUI HI		Regular School	No	High	09	12	2017	grade_8	0.0	0
128932	HI	school	1500030	1	Hawaii Department of Education	150003000058	402	HANA HI & EL		Regular School	No	Other	PK	12	2017	grade_8	21.0	21
128937	HI	school	1500030	1	Hawaii Department of Education	150003000069	414	LAHAINALUNA HI		Regular School	No	High	09	12	2017	grade_8	0.0	0
128938	HI	school	1500030	1	Hawaii Department of Education	150003000070	415	LANAI HI & EL		Regular School	No	Other	PK	12	2017	grade_8	36.0	36
128940	HI	school	1500030	1	Hawaii Department of Education	150003000075	421	MOLOKAI HI		Regular School	No	High	09	12	2017	grade_8	0.0	0
128948	HI	school	1500030	1	Hawaii Department of Education	150003000085	455	KAPAA HI		Regular School	No	High	09	12	2017	grade_8	0.0	0
128950	HI	school	1500030	1	Hawaii Department of Education	150003000086	456	KAUAI HI		Regular School	No	High	09	12	2017	grade_8	0.0	0
128955	HI	school	1500030	1	Hawaii Department of Education	150003000091	461	NIIHAU		Regular School	No	Other	PK	12	2017	grade_8	0.0	0
128957	HI	school	1500030	1	Hawaii Department of Education	150003000093	462	WAIMEA HI		Regular School	No	High	09	12	2017	grade_8	0.0	0
128959	HI	school	1500030	1	Hawaii Department of Education	150003000262	396	CONNECTIONS-PCS	charter	Regular School	Yes	Other	KG	12	2017	grade_8	42.0	42
128960	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_8	52.0	52
128961	HI	school	1500030	1	Hawaii Department of Education	150003000275	546	HAKIPU'U LEARNING CTR-PCS	charter	Regular School	Yes	Other	04	12	2017	grade_8	3.0	3
128962	HI	school	1500030	1	Hawaii Department of Education	150003000270	540	HALAU KU MANA-PCS	charter	Regular School	Yes	Other	04	12	2017	grade_8	15.0	15
128963	HI	school	1500030	1	Hawaii Department of Education	150003000295	551	HAWAII TECHNOLOGY ACADEMY	charter	Regular School	Yes	Other	KG	12	2017	grade_8	106.0	106
128964	HI	school	1500030	1	Hawaii Department of Education	150003000282	561	HI ACADEMY OF A&S-PCS	charter	Regular School	Yes	Other	KG	12	2017	grade_8	62.0	62
128968	HI	school	1500030	1	Hawaii Department of Education	150003000240	275	KAMAILE ACADEMY	charter	Regular School	Yes	Other	PK	12	2017	grade_8	30.0	30
128969	HI	school	1500030	1	Hawaii Department of Education	150003000269	466	KANAKA-PCS	charter	Regular School	Yes	Other	KG	12	2017	grade_8	2.0	2
128970	HI	school	1500030	1	Hawaii Department of Education	150003000263	397	KANU O KA'AINA-PCS	charter	Regular School	Yes	Other	KG	12	2017	grade_8	23.0	23
128971	HI	school	1500030	1	Hawaii Department of Education	150003000289	564	KANUIKAPONO-PCS	charter	Regular School	Yes	Other	KG	12	2017	grade_8	17.0	17
128973	HI	school	1500030	1	Hawaii Department of Education	150003000294	565	KAWAIKINI-PCS	charter	Regular School	Yes	Other	KG	12	2017	grade_8	10.0	10
128974	HI	school	1500030	1	Hawaii Department of Education	150003000278	549	KE ANA LA'AHANA-PCS	charter	Regular School	Yes	High	07	12	2017	grade_8	9.0	9
128975	HI	school	1500030	1	Hawaii Department of Education	150003000280	556	KE KULA NIIHAU KEKAHA-PCS	charter	Regular School	Yes	Other	KG	12	2017	grade_8	3.0	3
128976	HI	school	1500030	1	Hawaii Department of Education	150003000276	547	KE KULA O KAMAKAU LAB-PCS	charter	Regular School	Yes	Other	PK	12	2017	grade_8	7.0	7
128977	HI	school	1500030	1	Hawaii Department of Education	150003000279	554	KIHEI PC SCHOOL-PCS	charter	Regular School	Yes	Other	KG	12	2017	grade_8	66.0	66
128979	HI	school	1500030	1	Hawaii Department of Education	150003000288	557	KUA O KA LA-PCS	charter	Regular School	Yes	Other	KG	12	2017	grade_8	9.0	9
128982	HI	school	1500030	1	Hawaii Department of Education	150003000046	377	LAUPAHOEHOE COMMUNITY - PCS	charter	Regular School	Yes	Other	PK	12	2017	grade_8	21.0	21
128984	HI	school	1500030	1	Hawaii Department of Education	150003000274	544	MYRON THOMPSON ACAD-PCS	charter	Regular School	Yes	Other	KG	12	2017	grade_8	37.0	37
128992	HI	school	1500030	1	Hawaii Department of Education	150003000265	399	WEST HI EXPLOR ACAD-PCS	charter	Regular School	Yes	Other	06	12	2017	grade_8	39.0	39
128983	HI	school	1500030	1	Hawaii Department of Education	150003000299	550	MALAMA HONUA PCS	charter	Regular School	Yes	Elementary	KG	4	2017	grade_8	0.0	0
128703	HI	school	1500030	1	Hawaii Department of Education	150003000227	100	AINA HAINA		Regular School	No	Elementary	PK	5	2017	grade_8	0.0	0
128706	HI	school	1500030	1	Hawaii Department of Education	150003000220	107	FERN		Regular School	No	Elementary	PK	5	2017	grade_8	0.0	0
128707	HI	school	1500030	1	Hawaii Department of Education	150003000219	108	HAHAIONE		Regular School	No	Elementary	PK	5	2017	grade_8	0.0	0
128709	HI	school	1500030	1	Hawaii Department of Education	150003000216	113	KAEWAI		Regular School	No	Elementary	PK	5	2017	grade_8	0.0	0
128710	HI	school	1500030	1	Hawaii Department of Education	150003000215	114	KAHALA		Regular School	No	Elementary	PK	5	2017	grade_8	0.0	0
128715	HI	school	1500030	1	Hawaii Department of Education	150003000162	120	KALIHI		Regular School	No	Elementary	PK	5	2017	grade_8	0.0	0
128716	HI	school	1500030	1	Hawaii Department of Education	150003000160	121	KALIHI-KAI		Regular School	No	Elementary	PK	5	2017	grade_8	0.0	0
128717	HI	school	1500030	1	Hawaii Department of Education	150003000210	122	KALIHI-UKA		Regular School	No	Elementary	PK	5	2017	grade_8	0.0	0
128718	HI	school	1500030	1	Hawaii Department of Education	150003000209	123	KALIHI-WAENA		Regular School	No	Elementary	PK	5	2017	grade_8	0.0	0
128719	HI	school	1500030	1	Hawaii Department of Education	150003000208	155	KAMILOIKI		Regular School	No	Elementary	PK	5	2017	grade_8	0.0	0
128720	HI	school	1500030	1	Hawaii Department of Education	150003000207	124	KAPALAMA		Regular School	No	Elementary	PK	5	2017	grade_8	0.0	0
128721	HI	school	1500030	1	Hawaii Department of Education	150003000204	127	KOKO HEAD		Regular School	No	Elementary	PK	5	2017	grade_8	0.0	0
128722	HI	school	1500030	1	Hawaii Department of Education	150003000201	130	LIHOLIHO		Regular School	No	Elementary	PK	5	2017	grade_8	0.0	0
128725	HI	school	1500030	1	Hawaii Department of Education	150003000187	145	PUUHALE		Regular School	No	Elementary	PK	5	2017	grade_8	0.0	0
128726	HI	school	1500030	1	Hawaii Department of Education	150003000182	150	WAIKIKI		Regular School	No	Elementary	PK	5	2017	grade_8	0.0	0
128727	HI	school	1500030	1	Hawaii Department of Education	150003000179	153	WILSON		Regular School	No	Elementary	PK	5	2017	grade_8	0.0	0
128728	HI	school	1500030	1	Hawaii Department of Education	150003000226	101	ALA WAI		Regular School	No	Elementary	PK	5	2017	grade_8	0.0	0
128729	HI	school	1500030	1	Hawaii Department of Education	150003000225	102	ALIIOLANI		Regular School	No	Elementary	PK	5	2017	grade_8	0.0	0
128732	HI	school	1500030	1	Hawaii Department of Education	150003000214	109	HOKULANI		Regular School	No	Elementary	PK	5	2017	grade_8	0.0	0
128734	HI	school	1500030	1	Hawaii Department of Education	150003000213	111	JEFFERSON		Regular School	No	Elementary	PK	5	2017	grade_8	0.0	0
128735	HI	school	1500030	1	Hawaii Department of Education	150003000217	112	KAAHUMANU		Regular School	No	Elementary	PK	5	2017	grade_8	0.0	0
128737	HI	school	1500030	1	Hawaii Department of Education	150003000165	117	KAIULANI		Regular School	No	Elementary	PK	5	2017	grade_8	0.0	0
128738	HI	school	1500030	1	Hawaii Department of Education	150003000206	125	KAULUWELA		Regular School	No	Elementary	PK	5	2017	grade_8	0.0	0
128740	HI	school	1500030	1	Hawaii Department of Education	150003000203	128	KUHIO		Regular School	No	Elementary	PK	5	2017	grade_8	0.0	0
128741	HI	school	1500030	1	Hawaii Department of Education	150003000202	129	LANAKILA		Regular School	No	Elementary	PK	5	2017	grade_8	0.0	0
128742	HI	school	1500030	1	Hawaii Department of Education	150003000200	131	LIKELIKE		Regular School	No	Elementary	PK	5	2017	grade_8	0.0	0
128743	HI	school	1500030	1	Hawaii Department of Education	150003000197	134	LINCOLN		Regular School	No	Elementary	PK	5	2017	grade_8	0.0	0
128744	HI	school	1500030	1	Hawaii Department of Education	150003000195	135	LUNALILO		Regular School	No	Elementary	PK	5	2017	grade_8	0.0	0
128746	HI	school	1500030	1	Hawaii Department of Education	150003000194	137	MANOA		Regular School	No	Elementary	PK	5	2017	grade_8	0.0	0
128748	HI	school	1500030	1	Hawaii Department of Education	150003000191	140	NOELANI		Regular School	No	Elementary	PK	5	2017	grade_8	0.0	0
128749	HI	school	1500030	1	Hawaii Department of Education	150003000190	141	NUUANU		Regular School	No	Elementary	PK	5	2017	grade_8	0.0	0
128750	HI	school	1500030	1	Hawaii Department of Education	150003000189	142	PALOLO		Regular School	No	Elementary	PK	5	2017	grade_8	0.0	0
128751	HI	school	1500030	1	Hawaii Department of Education	150003000188	143	PAUOA		Regular School	No	Elementary	PK	5	2017	grade_8	0.0	0
128753	HI	school	1500030	1	Hawaii Department of Education	150003000185	147	ROYAL		Regular School	No	Elementary	PK	5	2017	grade_8	0.0	0