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_low_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
2430190	HI	school	1500030	1	Hawaii Department of Education	150003000275	546	Hakipuu Learning Ctr PCS	charter	Regular School	Yes	Other	04	12	2020	grade_5	3.0	3
2430191	HI	school	1500030	1	Hawaii Department of Education	150003000270	540	Halau Ku Mana NCPCS	charter	Regular School	Yes	Other	04	12	2020	grade_5	7.0	7
2429932	HI	school	1500030	1	Hawaii Department of Education	150003000222	105	Dole Middle		Regular School	No	Middle	06	8	2020	grade_5	0.0	0
2429939	HI	school	1500030	1	Hawaii Department of Education	150003000211	116	Kaimuki Middle		Regular School	No	Middle	06	8	2020	grade_5	0.0	0
2429941	HI	school	1500030	1	Hawaii Department of Education	150003000164	118	Kalakaua Middle		Regular School	No	Middle	06	8	2020	grade_5	0.0	0
2429952	HI	school	1500030	1	Hawaii Department of Education	150003000192	139	Niu Valley Middle		Regular School	No	Middle	06	8	2020	grade_5	0.0	0
2429959	HI	school	1500030	1	Hawaii Department of Education	150003000223	104	Central Middle		Regular School	No	Middle	06	8	2020	grade_5	0.0	0
2429961	HI	school	1500030	1	Hawaii Department of Education	150003000218	110	Jarrett Middle		Regular School	No	Middle	06	8	2020	grade_5	0.0	0
2429967	HI	school	1500030	1	Hawaii Department of Education	150003000205	126	Kawananakoa Middle		Regular School	No	Middle	06	8	2020	grade_5	0.0	0
2429982	HI	school	1500030	1	Hawaii Department of Education	150003000184	148	Stevenson Middle		Regular School	No	Middle	06	8	2020	grade_5	0.0	0
2429983	HI	school	1500030	1	Hawaii Department of Education	150003000180	152	Washington Middle		Regular School	No	Middle	06	8	2020	grade_5	0.0	0
2430016	HI	school	1500030	1	Hawaii Department of Education	150003000256	238	Mililani Middle		Regular School	No	Middle	06	8	2020	grade_5	0.0	0
2430021	HI	school	1500030	1	Hawaii Department of Education	150003000143	230	Wahiawa Middle		Regular School	No	Middle	06	8	2020	grade_5	0.0	0
2430025	HI	school	1500030	1	Hawaii Department of Education	150003000137	237	Wheeler Middle		Regular School	No	Middle	06	8	2020	grade_5	0.0	0
2430030	HI	school	1500030	1	Hawaii Department of Education	150003000296	296	Ewa Makai Middle		Regular School	No	Middle	06	8	2020	grade_5	0.0	0
2430038	HI	school	1500030	1	Hawaii Department of Education	150003000259	291	Kapolei Middle		Regular School	No	Middle	06	8	2020	grade_5	0.0	0
2430110	HI	school	1500030	1	Hawaii Department of Education	150003000053	385	Waiakea Int		Regular School	No	Middle	06	8	2020	grade_5	0.0	0
2430121	HI	school	1500030	1	Hawaii Department of Education	150003000235	390	Kealakehe Int		Regular School	No	Middle	06	8	2020	grade_5	0.0	0
2430124	HI	school	1500030	1	Hawaii Department of Education	150003000267	366	Kohala Middle		Regular School	No	Middle	06	8	2020	grade_5	0.0	0
2430127	HI	school	1500030	1	Hawaii Department of Education	150003000252	376	Konawaena Middle		Regular School	No	Middle	06	8	2020	grade_5	0.0	0
2430134	HI	school	1500030	1	Hawaii Department of Education	150003000040	370	Keaau Middle		Regular School	No	Middle	06	8	2020	grade_5	0.0	0
2430142	HI	school	1500030	1	Hawaii Department of Education	150003000059	404	Iao Int		Regular School	No	Middle	06	8	2020	grade_5	0.0	0
2430144	HI	school	1500030	1	Hawaii Department of Education	150003000233	420	Kalama Int		Regular School	No	Middle	06	8	2020	grade_5	0.0	0
2430150	HI	school	1500030	1	Hawaii Department of Education	150003000238	430	Lokelani Int		Regular School	No	Middle	06	8	2020	grade_5	0.0	0
2430153	HI	school	1500030	1	Hawaii Department of Education	150003000241	428	Maui Waena Int		Regular School	No	Middle	06	8	2020	grade_5	0.0	0
2430164	HI	school	1500030	1	Hawaii Department of Education	150003000068	413	Lahaina Int		Regular School	No	Middle	06	8	2020	grade_5	0.0	0
2430174	HI	school	1500030	1	Hawaii Department of Education	150003000266	448	Kamakahelei Middle		Regular School	No	Middle	06	8	2020	grade_5	0.0	0
2430177	HI	school	1500030	1	Hawaii Department of Education	150003000255	447	Kapaa Middle		Regular School	No	Middle	06	8	2020	grade_5	0.0	0
2430184	HI	school	1500030	1	Hawaii Department of Education	150003000092	464	Waimea Canyon Middle		Regular School	No	Middle	06	8	2020	grade_5	0.0	0
2430189	HI	school	1500030	1	Hawaii Department of Education	150003000305	568	DreamHouse Ewa Beach	charter	Regular School	Yes	Middle	06	6	2020	grade_5	0.0	0
2430217	HI	school	1500030	1	Hawaii Department of Education	150003000298	567	SEEQS PCS	charter	Regular School	Yes	Middle	06	8	2020	grade_5	0.0	0
2430222	HI	school	1500030	1	Hawaii Department of Education	150003000268	394	Waimea Middle PCCS	charter	Regular School	Yes	Middle	06	8	2020	grade_5	0.0	0
2430223	HI	school	1500030	1	Hawaii Department of Education	150003000265	399	West Hawaii Explorations PCS	charter	Regular School	Yes	High	06	12	2020	grade_5	0.0	0
2429986	HI	school	1500030	1	Hawaii Department of Education	150003000176	201	Aiea Int		Regular School	No	Middle	07	8	2020	grade_5	0.0	0
2429988	HI	school	1500030	1	Hawaii Department of Education	150003000174	204	Aliamanu Middle		Regular School	No	Middle	07	8	2020	grade_5	0.0	0
2429993	HI	school	1500030	1	Hawaii Department of Education	150003000156	219	Moanalua Middle		Regular School	No	Middle	07	8	2020	grade_5	0.0	0
2430023	HI	school	1500030	1	Hawaii Department of Education	150003000141	232	Waialua High & Int		Regular School	No	High	07	12	2020	grade_5	0.0	0
2430033	HI	school	1500030	1	Hawaii Department of Education	150003000129	279	Ilima Int		Regular School	No	Middle	07	8	2020	grade_5	0.0	0
2430048	HI	school	1500030	1	Hawaii Department of Education	150003000117	263	Nanakuli High & Int		Regular School	No	High	07	12	2020	grade_5	0.0	0
2430051	HI	school	1500030	1	Hawaii Department of Education	150003000229	273	Waianae Int		Regular School	No	Middle	07	8	2020	grade_5	0.0	0
2430053	HI	school	1500030	1	Hawaii Department of Education	150003000131	255	Highlands Int		Regular School	No	Middle	07	8	2020	grade_5	0.0	0
2430068	HI	school	1500030	1	Hawaii Department of Education	150003000158	278	Waipahu Int		Regular School	No	Middle	07	8	2020	grade_5	0.0	0
2430076	HI	school	1500030	1	Hawaii Department of Education	150003000007	307	Kahuku High & Int		Regular School	No	High	07	12	2020	grade_5	0.0	0
2430079	HI	school	1500030	1	Hawaii Department of Education	150003000016	318	King Int		Regular School	No	Middle	07	8	2020	grade_5	0.0	0
2430090	HI	school	1500030	1	Hawaii Department of Education	150003000010	310	Kailua Int		Regular School	No	Middle	07	8	2020	grade_5	0.0	0
2430096	HI	school	1500030	1	Hawaii Department of Education	150003000098	475	Olomana		Alternative School	No	High	07	12	2020	grade_5	0.0	0
2430102	HI	school	1500030	1	Hawaii Department of Education	150003000030	356	Hilo Int		Regular School	No	Middle	07	8	2020	grade_5	0.0	0
2430115	HI	school	1500030	1	Hawaii Department of Education	150003000034	360	Honokaa High & Int		Regular School	No	High	07	12	2020	grade_5	0.0	0
2430139	HI	school	1500030	1	Hawaii Department of Education	150003000050	383	Pahoa High & Int		Regular School	No	High	07	12	2020	grade_5	0.0	0
2430169	HI	school	1500030	1	Hawaii Department of Education	150003000290	434	Molokai Middle		Regular School	No	Middle	07	8	2020	grade_5	0.0	0
2430205	HI	school	1500030	1	Hawaii Department of Education	150003000278	549	Ke Ana Laahana PCS	charter	Regular School	Yes	High	07	12	2020	grade_5	0.0	0
2429933	HI	school	1500030	1	Hawaii Department of Education	150003000221	106	Farrington High		Regular School	No	High	09	12	2020	grade_5	0.0	0
2429940	HI	school	1500030	1	Hawaii Department of Education	150003000228	154	Kaiser High		Regular School	No	High	09	12	2020	grade_5	0.0	0
2429942	HI	school	1500030	1	Hawaii Department of Education	150003000163	119	Kalani High		Regular School	No	High	09	12	2020	grade_5	0.0	0
2429964	HI	school	1500030	1	Hawaii Department of Education	150003000212	115	Kaimuki High		Regular School	No	High	09	12	2020	grade_5	0.0	0
2429975	HI	school	1500030	1	Hawaii Department of Education	150003000193	138	McKinley High		Regular School	No	High	09	12	2020	grade_5	0.0	0
2429980	HI	school	1500030	1	Hawaii Department of Education	150003000186	146	Roosevelt High		Regular School	No	High	09	12	2020	grade_5	0.0	0
2429985	HI	school	1500030	1	Hawaii Department of Education	150003000177	202	Aiea High		Regular School	No	High	09	12	2020	grade_5	0.0	0
2429992	HI	school	1500030	1	Hawaii Department of Education	150003000103	218	Moanalua High		Regular School	No	High	09	12	2020	grade_5	0.0	0
2429999	HI	school	1500030	1	Hawaii Department of Education	150003000150	224	Radford High		Regular School	No	High	09	12	2020	grade_5	0.0	0
2430012	HI	school	1500030	1	Hawaii Department of Education	150003000108	214	Leilehua High		Regular School	No	High	09	12	2020	grade_5	0.0	0
2430013	HI	school	1500030	1	Hawaii Department of Education	150003000102	216	Mililani High		Regular School	No	High	09	12	2020	grade_5	0.0	0
2430027	HI	school	1500030	1	Hawaii Department of Education	150003000134	252	Campbell High		Regular School	No	High	09	12	2020	grade_5	0.0	0
2430037	HI	school	1500030	1	Hawaii Department of Education	150003000261	292	Kapolei High		Regular School	No	High	09	12	2020	grade_5	0.0	0
2430050	HI	school	1500030	1	Hawaii Department of Education	150003000110	272	Waianae High		Regular School	No	High	09	12	2020	grade_5	0.0	0
2430062	HI	school	1500030	1	Hawaii Department of Education	150003000114	266	Pearl City High		Regular School	No	High	09	12	2020	grade_5	0.0	0
2430067	HI	school	1500030	1	Hawaii Department of Education	150003000161	277	Waipahu High		Regular School	No	High	09	12	2020	grade_5	0.0	0
2430070	HI	school	1500030	1	Hawaii Department of Education	150003000100	301	Castle High		Regular School	No	High	09	12	2020	grade_5	0.0	0
2430089	HI	school	1500030	1	Hawaii Department of Education	150003000009	309	Kailua High		Regular School	No	High	09	12	2020	grade_5	0.0	0
2430092	HI	school	1500030	1	Hawaii Department of Education	150003000012	312	Kalaheo High		Regular School	No	High	09	12	2020	grade_5	0.0	0
2430101	HI	school	1500030	1	Hawaii Department of Education	150003000029	355	Hilo High		Regular School	No	High	09	12	2020	grade_5	0.0	0
2430109	HI	school	1500030	1	Hawaii Department of Education	150003000052	389	Waiakea High		Regular School	No	High	09	12	2020	grade_5	0.0	0
2430120	HI	school	1500030	1	Hawaii Department of Education	150003000254	392	Kealakehe High		Regular School	No	High	09	12	2020	grade_5	0.0	0
2430123	HI	school	1500030	1	Hawaii Department of Education	150003000043	373	Kohala High		Regular School	No	High	09	12	2020	grade_5	0.0	0
2430126	HI	school	1500030	1	Hawaii Department of Education	150003000045	374	Konawaena High		Regular School	No	High	09	12	2020	grade_5	0.0	0
2430133	HI	school	1500030	1	Hawaii Department of Education	150003000260	354	Keaau High		Regular School	No	High	09	12	2020	grade_5	0.0	0
2430140	HI	school	1500030	1	Hawaii Department of Education	150003000056	400	Baldwin High		Regular School	No	High	09	12	2020	grade_5	0.0	0
2430146	HI	school	1500030	1	Hawaii Department of Education	150003000251	435	Kekaulike High		Regular School	No	High	09	12	2020	grade_5	0.0	0
2430152	HI	school	1500030	1	Hawaii Department of Education	150003000073	418	Maui High		Regular School	No	High	09	12	2020	grade_5	0.0	0
2430165	HI	school	1500030	1	Hawaii Department of Education	150003000069	414	Lahainaluna High		Regular School	No	High	09	12	2020	grade_5	0.0	0
2430168	HI	school	1500030	1	Hawaii Department of Education	150003000075	421	Molokai High		Regular School	No	High	09	12	2020	grade_5	0.0	0
2430176	HI	school	1500030	1	Hawaii Department of Education	150003000085	455	Kapaa High		Regular School	No	High	09	12	2020	grade_5	0.0	0
2430178	HI	school	1500030	1	Hawaii Department of Education	150003000086	456	Kauai High		Regular School	No	High	09	12	2020	grade_5	0.0	0
2430185	HI	school	1500030	1	Hawaii Department of Education	150003000093	462	Waimea High		Regular School	No	High	09	12	2020	grade_5	0.0	0
2430203	HI	school	1500030	1	Hawaii Department of Education	150003000302	555	Kapolei Charter School	charter	Regular School	Yes	Secondary	09	11	2020	grade_5	0.0	0
2430187	HI	school	1500030	1	Hawaii Department of Education	150003000304	558	Alakai O Kauai PCS	charter	Regular School	Yes	Elementary	KG	6	2020	grade_5	16.0	16
2430188	HI	school	1500030	1	Hawaii Department of Education	150003000262	396	Connections NCPCS	charter	Regular School	Yes	Other	KG	12	2020	grade_5	21.0	21
2430192	HI	school	1500030	1	Hawaii Department of Education	150003000282	561	Hawaii Academy of Arts & Science PCS	charter	Regular School	Yes	Other	KG	12	2020	grade_5	35.0	35
2430193	HI	school	1500030	1	Hawaii Department of Education	150003000295	551	Hawaii Tech Acad PCS	charter	Regular School	Yes	Other	KG	12	2020	grade_5	53.0	53
2430194	HI	school	1500030	1	Hawaii Department of Education	150003000277	548	Innovations PCS	charter	Regular School	Yes	Elementary	KG	8	2020	grade_5	22.0	22
2430196	HI	school	1500030	1	Hawaii Department of Education	150003000286	545	Ka Waihona o ka Naauao NCPCS	charter	Regular School	Yes	Elementary	KG	8	2020	grade_5	71.0	71
2430200	HI	school	1500030	1	Hawaii Department of Education	150003000263	397	Kanu O Ka Aina NCPCS	charter	Regular School	Yes	Other	KG	12	2020	grade_5	46.0	46
2430201	HI	school	1500030	1	Hawaii Department of Education	150003000289	564	Kanuikapono PCS	charter	Regular School	Yes	Other	KG	12	2020	grade_5	20.0	20
2430204	HI	school	1500030	1	Hawaii Department of Education	150003000294	565	Kawaikini NCPCS	charter	Regular School	Yes	Other	KG	12	2020	grade_5	17.0	17
2430209	HI	school	1500030	1	Hawaii Department of Education	150003000279	554	Kihei Charter School	charter	Regular School	Yes	Other	KG	12	2020	grade_5	39.0	39
2430210	HI	school	1500030	1	Hawaii Department of Education	150003000293	566	Kona Pacific PCS	charter	Regular School	Yes	Elementary	KG	8	2020	grade_5	25.0	25
2430214	HI	school	1500030	1	Hawaii Department of Education	150003000299	550	Malama Honua	charter	Regular School	Yes	Elementary	KG	7	2020	grade_5	18.0	18
2430215	HI	school	1500030	1	Hawaii Department of Education	150003000274	544	Myron Thompson Acad NCPCS	charter	Regular School	Yes	Other	KG	12	2020	grade_5	42.0	42
2430218	HI	school	1500030	1	Hawaii Department of Education	150003000273	543	University Laboratory School	charter	Regular School	Yes	Other	KG	12	2020	grade_5	10.0	10
2430220	HI	school	1500030	1	Hawaii Department of Education	150003000271	541	Voyager PCS	charter	Regular School	Yes	Elementary	KG	8	2020	grade_5	21.0	21
2429931	HI	school	1500030	1	Hawaii Department of Education	150003000227	100	Aina Haina Elem		Regular School	No	Elementary	PK	5	2020	grade_5	60.0	60