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 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
110259	HI	school	1500030	1	Hawaii Department of Education	150003000301	552	KAU LEARNING ACAD-PCS	charter	Regular School	Yes	1	03	6	2016	grade_9	0.0	0
129262	HI	school	1500030	1	Hawaii Department of Education	150003000301	552	KAU LEARNING ACAD-PCS	charter	Regular School	Yes	Elementary	03	7	2017	grade_9	0.0	0
2782085	HI	school	1500030	1	Hawaii Department of Education	150003000301	552	Kau Learning Academy	charter	Regular School	Yes	Middle	03	7	2018	grade_9	0.0	0
110248	HI	school	1500030	1	Hawaii Department of Education	150003000275	546	HAKIPU'U LEARNING CTR-PCS	charter	Regular School	Yes	4	04	12	2016	grade_9	5.0	5
110249	HI	school	1500030	1	Hawaii Department of Education	150003000270	540	HALAU KU MANA-PCS	charter	Regular School	Yes	4	04	12	2016	grade_9	14.0	14
129251	HI	school	1500030	1	Hawaii Department of Education	150003000275	546	HAKIPU'U LEARNING CTR-PCS	charter	Regular School	Yes	Other	04	12	2017	grade_9	9.0	9
129252	HI	school	1500030	1	Hawaii Department of Education	150003000270	540	HALAU KU MANA-PCS	charter	Regular School	Yes	Other	04	12	2017	grade_9	18.0	18
280235	HI	school	1500030	1	Hawaii Department of Education	150003000270	540	HALAU KU MANA-PCS	charter	Regular School	Yes	4	04	12	2015	grade_9	15.0	15
280241	HI	school	1500030	1	Hawaii Department of Education	150003000275	546	HAKIPU'U LEARNING CTR-PCS	charter	Regular School	Yes	4	04	12	2015	grade_9	14.0	14
2431362	HI	school	1500030	1	Hawaii Department of Education	150003000275	546	Hakipuu Learning Ctr PCS	charter	Regular School	Yes	Other	04	12	2020	grade_9	4.0	4
2431363	HI	school	1500030	1	Hawaii Department of Education	150003000270	540	Halau Ku Mana NCPCS	charter	Regular School	Yes	Other	04	12	2020	grade_9	16.0	16
2456054	HI	school	1500030	1	Hawaii Department of Education	150003000270	540	Halau Ku Mana NCPCS	charter	Regular School	Yes	Other	04	12	2021	grade_9	14.0	14
2737031	HI	school	1500030	1	Hawaii Department of Education	150003000270	540	Halau Ku Mana NCPCS	charter	Regular School	Yes	Other	04	12	2019	grade_9	14.0	14
2737036	HI	school	1500030	1	Hawaii Department of Education	150003000275	546	Hakipuu Learning Ctr PCS	charter	Regular School	Yes	Other	04	12	2019	grade_9	10.0	10
2782071	HI	school	1500030	1	Hawaii Department of Education	150003000275	546	Hakipuu Learning Ctr PCS	charter	Regular School	Yes	Other	04	12	2018	grade_9	8.0	8
2782072	HI	school	1500030	1	Hawaii Department of Education	150003000270	540	Halau Ku Mana NCPCS	charter	Regular School	Yes	Other	04	12	2018	grade_9	12.0	12
2456053	HI	school	1500030	1	Hawaii Department of Education	150003000275	546	Hakipuu Academy PCS	charter	Regular School	Yes	High	05	12	2021	grade_9	12.0	12
109991	HI	school	1500030	1	Hawaii Department of Education	150003000222	105	DOLE MID		Regular School	No	2	06	8	2016	grade_9	0.0	0
109998	HI	school	1500030	1	Hawaii Department of Education	150003000211	116	KAIMUKI MID		Regular School	No	2	06	8	2016	grade_9	0.0	0
110000	HI	school	1500030	1	Hawaii Department of Education	150003000164	118	KALAKAUA MID		Regular School	No	2	06	8	2016	grade_9	0.0	0
110011	HI	school	1500030	1	Hawaii Department of Education	150003000192	139	NIU VALLEY MID		Regular School	No	2	06	8	2016	grade_9	0.0	0
110018	HI	school	1500030	1	Hawaii Department of Education	150003000223	104	CENTRAL MID		Regular School	No	2	06	8	2016	grade_9	0.0	0
110020	HI	school	1500030	1	Hawaii Department of Education	150003000218	110	JARRETT MID		Regular School	No	2	06	8	2016	grade_9	0.0	0
110026	HI	school	1500030	1	Hawaii Department of Education	150003000205	126	KAWANANAKOA MID		Regular School	No	2	06	8	2016	grade_9	0.0	0
110041	HI	school	1500030	1	Hawaii Department of Education	150003000184	148	STEVENSON MID		Regular School	No	2	06	8	2016	grade_9	0.0	0
110042	HI	school	1500030	1	Hawaii Department of Education	150003000180	152	WASHINGTON MID		Regular School	No	2	06	8	2016	grade_9	0.0	0
110075	HI	school	1500030	1	Hawaii Department of Education	150003000256	238	MILILANI MID		Regular School	No	2	06	8	2016	grade_9	0.0	0
110080	HI	school	1500030	1	Hawaii Department of Education	150003000143	230	WAHIAWA MID		Regular School	No	2	06	8	2016	grade_9	0.0	0
110084	HI	school	1500030	1	Hawaii Department of Education	150003000137	237	WHEELER MID		Regular School	No	2	06	8	2016	grade_9	0.0	0
110097	HI	school	1500030	1	Hawaii Department of Education	150003000259	291	KAPOLEI MID		Regular School	No	2	06	8	2016	grade_9	0.0	0
110169	HI	school	1500030	1	Hawaii Department of Education	150003000053	385	WAIAKEA INT		Regular School	No	2	06	8	2016	grade_9	0.0	0
110180	HI	school	1500030	1	Hawaii Department of Education	150003000235	390	KEALAKEHE INT		Regular School	No	2	06	8	2016	grade_9	0.0	0
110183	HI	school	1500030	1	Hawaii Department of Education	150003000267	366	KOHALA MID		Regular School	No	2	06	8	2016	grade_9	0.0	0
110186	HI	school	1500030	1	Hawaii Department of Education	150003000252	376	KONAWAENA MID		Regular School	No	2	06	8	2016	grade_9	0.0	0
110193	HI	school	1500030	1	Hawaii Department of Education	150003000040	370	KEAAU MID		Regular School	No	2	06	8	2016	grade_9	0.0	0
110201	HI	school	1500030	1	Hawaii Department of Education	150003000059	404	IAO INT		Regular School	No	2	06	8	2016	grade_9	0.0	0
110203	HI	school	1500030	1	Hawaii Department of Education	150003000233	420	KALAMA INT		Regular School	No	2	06	8	2016	grade_9	0.0	0
110209	HI	school	1500030	1	Hawaii Department of Education	150003000238	430	LOKELANI INT		Regular School	No	2	06	8	2016	grade_9	0.0	0
110212	HI	school	1500030	1	Hawaii Department of Education	150003000241	428	MAUI WAENA INT		Regular School	No	2	06	8	2016	grade_9	0.0	0
110223	HI	school	1500030	1	Hawaii Department of Education	150003000068	413	LAHAINA INT		Regular School	No	2	06	8	2016	grade_9	0.0	0
110233	HI	school	1500030	1	Hawaii Department of Education	150003000266	448	KAMAKAHELEI MID		Regular School	No	2	06	8	2016	grade_9	0.0	0
110236	HI	school	1500030	1	Hawaii Department of Education	150003000255	447	KAPAA MID		Regular School	No	2	06	8	2016	grade_9	0.0	0
110243	HI	school	1500030	1	Hawaii Department of Education	150003000092	464	WAIMEA CANYON		Regular School	No	2	06	8	2016	grade_9	0.0	0
110274	HI	school	1500030	1	Hawaii Department of Education	150003000298	567	SEEQS	charter	Regular School	Yes	2	06	8	2016	grade_9	0.0	0
110278	HI	school	1500030	1	Hawaii Department of Education	150003000268	394	WAIMEA MID-PCCS	charter	Regular School	Yes	2	06	8	2016	grade_9	0.0	0
110279	HI	school	1500030	1	Hawaii Department of Education	150003000265	399	WEST HI EXPLOR ACAD-PCS	charter	Regular School	Yes	4	06	12	2016	grade_9	49.0	49
128994	HI	school	1500030	1	Hawaii Department of Education	150003000222	105	DOLE MID		Regular School	No	Middle	06	8	2017	grade_9	0.0	0
129001	HI	school	1500030	1	Hawaii Department of Education	150003000211	116	KAIMUKI MID		Regular School	No	Middle	06	8	2017	grade_9	0.0	0
129003	HI	school	1500030	1	Hawaii Department of Education	150003000164	118	KALAKAUA MID		Regular School	No	Middle	06	8	2017	grade_9	0.0	0
129014	HI	school	1500030	1	Hawaii Department of Education	150003000192	139	NIU VALLEY MID		Regular School	No	Middle	06	8	2017	grade_9	0.0	0
129021	HI	school	1500030	1	Hawaii Department of Education	150003000223	104	CENTRAL MID		Regular School	No	Middle	06	8	2017	grade_9	0.0	0
129023	HI	school	1500030	1	Hawaii Department of Education	150003000218	110	JARRETT MID		Regular School	No	Middle	06	8	2017	grade_9	0.0	0
129029	HI	school	1500030	1	Hawaii Department of Education	150003000205	126	KAWANANAKOA MID		Regular School	No	Middle	06	8	2017	grade_9	0.0	0
129044	HI	school	1500030	1	Hawaii Department of Education	150003000184	148	STEVENSON MID		Regular School	No	Middle	06	8	2017	grade_9	0.0	0
129045	HI	school	1500030	1	Hawaii Department of Education	150003000180	152	WASHINGTON MID		Regular School	No	Middle	06	8	2017	grade_9	0.0	0
129078	HI	school	1500030	1	Hawaii Department of Education	150003000256	238	MILILANI MID		Regular School	No	Middle	06	8	2017	grade_9	0.0	0
129083	HI	school	1500030	1	Hawaii Department of Education	150003000143	230	WAHIAWA MID		Regular School	No	Middle	06	8	2017	grade_9	0.0	0
129087	HI	school	1500030	1	Hawaii Department of Education	150003000137	237	WHEELER MID		Regular School	No	Middle	06	8	2017	grade_9	0.0	0
129100	HI	school	1500030	1	Hawaii Department of Education	150003000259	291	KAPOLEI MID		Regular School	No	Middle	06	8	2017	grade_9	0.0	0
129172	HI	school	1500030	1	Hawaii Department of Education	150003000053	385	WAIAKEA INT		Regular School	No	Middle	06	8	2017	grade_9	0.0	0
129183	HI	school	1500030	1	Hawaii Department of Education	150003000235	390	KEALAKEHE INT		Regular School	No	Middle	06	8	2017	grade_9	0.0	0
129186	HI	school	1500030	1	Hawaii Department of Education	150003000267	366	KOHALA MID		Regular School	No	Middle	06	8	2017	grade_9	0.0	0
129189	HI	school	1500030	1	Hawaii Department of Education	150003000252	376	KONAWAENA MID		Regular School	No	Middle	06	8	2017	grade_9	0.0	0
129196	HI	school	1500030	1	Hawaii Department of Education	150003000040	370	KEAAU MID		Regular School	No	Middle	06	8	2017	grade_9	0.0	0
129204	HI	school	1500030	1	Hawaii Department of Education	150003000059	404	IAO INT		Regular School	No	Middle	06	8	2017	grade_9	0.0	0
129206	HI	school	1500030	1	Hawaii Department of Education	150003000233	420	KALAMA INT		Regular School	No	Middle	06	8	2017	grade_9	0.0	0
129212	HI	school	1500030	1	Hawaii Department of Education	150003000238	430	LOKELANI INT		Regular School	No	Middle	06	8	2017	grade_9	0.0	0
129215	HI	school	1500030	1	Hawaii Department of Education	150003000241	428	MAUI WAENA INT		Regular School	No	Middle	06	8	2017	grade_9	0.0	0
129226	HI	school	1500030	1	Hawaii Department of Education	150003000068	413	LAHAINA INT		Regular School	No	Middle	06	8	2017	grade_9	0.0	0
129236	HI	school	1500030	1	Hawaii Department of Education	150003000266	448	KAMAKAHELEI MID		Regular School	No	Middle	06	8	2017	grade_9	0.0	0
129239	HI	school	1500030	1	Hawaii Department of Education	150003000255	447	KAPAA MID		Regular School	No	Middle	06	8	2017	grade_9	0.0	0
129246	HI	school	1500030	1	Hawaii Department of Education	150003000092	464	WAIMEA CANYON		Regular School	No	Middle	06	8	2017	grade_9	0.0	0
129277	HI	school	1500030	1	Hawaii Department of Education	150003000298	567	SEEQS	charter	Regular School	Yes	Middle	06	8	2017	grade_9	0.0	0
129281	HI	school	1500030	1	Hawaii Department of Education	150003000268	394	WAIMEA MID-PCCS	charter	Regular School	Yes	Middle	06	8	2017	grade_9	0.0	0
129282	HI	school	1500030	1	Hawaii Department of Education	150003000265	399	WEST HI EXPLOR ACAD-PCS	charter	Regular School	Yes	Other	06	12	2017	grade_9	49.0	49
279970	HI	school	1500030	1	Hawaii Department of Education	150003000222	105	DOLE MID		Regular School	No	2	06	8	2015	grade_9	0.0	0
279977	HI	school	1500030	1	Hawaii Department of Education	150003000211	116	KAIMUKI MID		Regular School	No	2	06	8	2015	grade_9	0.0	0
279979	HI	school	1500030	1	Hawaii Department of Education	150003000164	118	KALAKAUA MID		Regular School	No	2	06	8	2015	grade_9	0.0	0
279990	HI	school	1500030	1	Hawaii Department of Education	150003000192	139	NIU VALLEY MID		Regular School	No	2	06	8	2015	grade_9	0.0	0
279997	HI	school	1500030	1	Hawaii Department of Education	150003000223	104	CENTRAL MID		Regular School	No	2	06	8	2015	grade_9	0.0	0
279999	HI	school	1500030	1	Hawaii Department of Education	150003000218	110	JARRETT MID		Regular School	No	2	06	8	2015	grade_9	0.0	0
280005	HI	school	1500030	1	Hawaii Department of Education	150003000205	126	KAWANANAKOA MID		Regular School	No	2	06	8	2015	grade_9	0.0	0
280020	HI	school	1500030	1	Hawaii Department of Education	150003000184	148	STEVENSON MID		Regular School	No	2	06	8	2015	grade_9	0.0	0
280021	HI	school	1500030	1	Hawaii Department of Education	150003000180	152	WASHINGTON MID		Regular School	No	2	06	8	2015	grade_9	0.0	0
280054	HI	school	1500030	1	Hawaii Department of Education	150003000256	238	MILILANI MID		Regular School	No	2	06	8	2015	grade_9	0.0	0
280059	HI	school	1500030	1	Hawaii Department of Education	150003000143	230	WAHIAWA MID		Regular School	No	2	06	8	2015	grade_9	0.0	0
280063	HI	school	1500030	1	Hawaii Department of Education	150003000137	237	WHEELER MID		Regular School	No	2	06	8	2015	grade_9	0.0	0
280075	HI	school	1500030	1	Hawaii Department of Education	150003000259	291	KAPOLEI MID		Regular School	No	2	06	8	2015	grade_9	0.0	0
280147	HI	school	1500030	1	Hawaii Department of Education	150003000053	385	WAIAKEA INT		Regular School	No	2	06	8	2015	grade_9	0.0	0
280158	HI	school	1500030	1	Hawaii Department of Education	150003000235	390	KEALAKEHE INT		Regular School	No	2	06	8	2015	grade_9	0.0	0
280161	HI	school	1500030	1	Hawaii Department of Education	150003000267	366	KOHALA MID		Regular School	No	2	06	8	2015	grade_9	0.0	0
280164	HI	school	1500030	1	Hawaii Department of Education	150003000252	376	KONAWAENA MID		Regular School	No	2	06	8	2015	grade_9	0.0	0
280171	HI	school	1500030	1	Hawaii Department of Education	150003000040	370	KEAAU MID		Regular School	No	2	06	8	2015	grade_9	0.0	0
280179	HI	school	1500030	1	Hawaii Department of Education	150003000059	404	IAO INT		Regular School	No	2	06	8	2015	grade_9	0.0	0
280181	HI	school	1500030	1	Hawaii Department of Education	150003000233	420	KALAMA INT		Regular School	No	2	06	8	2015	grade_9	0.0	0
280187	HI	school	1500030	1	Hawaii Department of Education	150003000238	430	LOKELANI INT		Regular School	No	2	06	8	2015	grade_9	0.0	0
280190	HI	school	1500030	1	Hawaii Department of Education	150003000241	428	MAUI WAENA INT		Regular School	No	2	06	8	2015	grade_9	0.0	0
280201	HI	school	1500030	1	Hawaii Department of Education	150003000068	413	LAHAINA INT		Regular School	No	2	06	8	2015	grade_9	0.0	0
280211	HI	school	1500030	1	Hawaii Department of Education	150003000266	448	KAMAKAHELEI MID		Regular School	No	2	06	8	2015	grade_9	0.0	0
280214	HI	school	1500030	1	Hawaii Department of Education	150003000255	447	KAPAA MID		Regular School	No	2	06	8	2015	grade_9	0.0	0
280221	HI	school	1500030	1	Hawaii Department of Education	150003000092	464	WAIMEA CANYON		Regular School	No	2	06	8	2015	grade_9	0.0	0