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 (ccd_school_low_grade > :p3 or (ccd_school_low_grade = :p3 and rowid > :p2)) order by ccd_school_low_grade, 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	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
281088	HI	school	1500030	1	Hawaii Department of Education	150003000092	464	WAIMEA CANYON		Regular School	No	2	06	8	2015	grade_12	0.0	0
281095	HI	school	1500030	1	Hawaii Department of Education	150003000268	394	WAIMEA MID-PCCS	charter	Regular School	Yes	2	06	8	2015	grade_12	0.0	0
281099	HI	school	1500030	1	Hawaii Department of Education	150003000265	399	WEST HI EXPLOR ACAD-PCS	charter	Regular School	Yes	4	06	12	2015	grade_12	24.0	24
281124	HI	school	1500030	1	Hawaii Department of Education	150003000298	567	SEEQS	charter	Regular School	Yes	2	06	8	2015	grade_12	0.0	0
2431983	HI	school	1500030	1	Hawaii Department of Education	150003000222	105	Dole Middle		Regular School	No	Middle	06	8	2020	grade_12	0.0	0
2431990	HI	school	1500030	1	Hawaii Department of Education	150003000211	116	Kaimuki Middle		Regular School	No	Middle	06	8	2020	grade_12	0.0	0
2431992	HI	school	1500030	1	Hawaii Department of Education	150003000164	118	Kalakaua Middle		Regular School	No	Middle	06	8	2020	grade_12	0.0	0
2432003	HI	school	1500030	1	Hawaii Department of Education	150003000192	139	Niu Valley Middle		Regular School	No	Middle	06	8	2020	grade_12	0.0	0
2432010	HI	school	1500030	1	Hawaii Department of Education	150003000223	104	Central Middle		Regular School	No	Middle	06	8	2020	grade_12	0.0	0
2432012	HI	school	1500030	1	Hawaii Department of Education	150003000218	110	Jarrett Middle		Regular School	No	Middle	06	8	2020	grade_12	0.0	0
2432018	HI	school	1500030	1	Hawaii Department of Education	150003000205	126	Kawananakoa Middle		Regular School	No	Middle	06	8	2020	grade_12	0.0	0
2432033	HI	school	1500030	1	Hawaii Department of Education	150003000184	148	Stevenson Middle		Regular School	No	Middle	06	8	2020	grade_12	0.0	0
2432034	HI	school	1500030	1	Hawaii Department of Education	150003000180	152	Washington Middle		Regular School	No	Middle	06	8	2020	grade_12	0.0	0
2432067	HI	school	1500030	1	Hawaii Department of Education	150003000256	238	Mililani Middle		Regular School	No	Middle	06	8	2020	grade_12	0.0	0
2432072	HI	school	1500030	1	Hawaii Department of Education	150003000143	230	Wahiawa Middle		Regular School	No	Middle	06	8	2020	grade_12	0.0	0
2432076	HI	school	1500030	1	Hawaii Department of Education	150003000137	237	Wheeler Middle		Regular School	No	Middle	06	8	2020	grade_12	0.0	0
2432081	HI	school	1500030	1	Hawaii Department of Education	150003000296	296	Ewa Makai Middle		Regular School	No	Middle	06	8	2020	grade_12	0.0	0
2432089	HI	school	1500030	1	Hawaii Department of Education	150003000259	291	Kapolei Middle		Regular School	No	Middle	06	8	2020	grade_12	0.0	0
2432161	HI	school	1500030	1	Hawaii Department of Education	150003000053	385	Waiakea Int		Regular School	No	Middle	06	8	2020	grade_12	0.0	0
2432172	HI	school	1500030	1	Hawaii Department of Education	150003000235	390	Kealakehe Int		Regular School	No	Middle	06	8	2020	grade_12	0.0	0
2432175	HI	school	1500030	1	Hawaii Department of Education	150003000267	366	Kohala Middle		Regular School	No	Middle	06	8	2020	grade_12	0.0	0
2432178	HI	school	1500030	1	Hawaii Department of Education	150003000252	376	Konawaena Middle		Regular School	No	Middle	06	8	2020	grade_12	0.0	0
2432185	HI	school	1500030	1	Hawaii Department of Education	150003000040	370	Keaau Middle		Regular School	No	Middle	06	8	2020	grade_12	0.0	0
2432193	HI	school	1500030	1	Hawaii Department of Education	150003000059	404	Iao Int		Regular School	No	Middle	06	8	2020	grade_12	0.0	0
2432195	HI	school	1500030	1	Hawaii Department of Education	150003000233	420	Kalama Int		Regular School	No	Middle	06	8	2020	grade_12	0.0	0
2432201	HI	school	1500030	1	Hawaii Department of Education	150003000238	430	Lokelani Int		Regular School	No	Middle	06	8	2020	grade_12	0.0	0
2432204	HI	school	1500030	1	Hawaii Department of Education	150003000241	428	Maui Waena Int		Regular School	No	Middle	06	8	2020	grade_12	0.0	0
2432215	HI	school	1500030	1	Hawaii Department of Education	150003000068	413	Lahaina Int		Regular School	No	Middle	06	8	2020	grade_12	0.0	0
2432225	HI	school	1500030	1	Hawaii Department of Education	150003000266	448	Kamakahelei Middle		Regular School	No	Middle	06	8	2020	grade_12	0.0	0
2432228	HI	school	1500030	1	Hawaii Department of Education	150003000255	447	Kapaa Middle		Regular School	No	Middle	06	8	2020	grade_12	0.0	0
2432235	HI	school	1500030	1	Hawaii Department of Education	150003000092	464	Waimea Canyon Middle		Regular School	No	Middle	06	8	2020	grade_12	0.0	0
2432240	HI	school	1500030	1	Hawaii Department of Education	150003000305	568	DreamHouse Ewa Beach	charter	Regular School	Yes	Middle	06	6	2020	grade_12	0.0	0
2432268	HI	school	1500030	1	Hawaii Department of Education	150003000298	567	SEEQS PCS	charter	Regular School	Yes	Middle	06	8	2020	grade_12	0.0	0
2432273	HI	school	1500030	1	Hawaii Department of Education	150003000268	394	Waimea Middle PCCS	charter	Regular School	Yes	Middle	06	8	2020	grade_12	0.0	0
2432274	HI	school	1500030	1	Hawaii Department of Education	150003000265	399	West Hawaii Explorations PCS	charter	Regular School	Yes	High	06	12	2020	grade_12	32.0	32
2456676	HI	school	1500030	1	Hawaii Department of Education	150003000222	105	Dole Middle		Regular School	No	Middle	06	8	2021	grade_12	0.0	0
2456683	HI	school	1500030	1	Hawaii Department of Education	150003000211	116	Kaimuki Middle		Regular School	No	Middle	06	8	2021	grade_12	0.0	0
2456685	HI	school	1500030	1	Hawaii Department of Education	150003000164	118	Kalakaua Middle		Regular School	No	Middle	06	8	2021	grade_12	0.0	0
2456696	HI	school	1500030	1	Hawaii Department of Education	150003000192	139	Niu Valley Middle		Regular School	No	Middle	06	8	2021	grade_12	0.0	0
2456703	HI	school	1500030	1	Hawaii Department of Education	150003000223	104	Central Middle		Regular School	No	Middle	06	8	2021	grade_12	0.0	0
2456705	HI	school	1500030	1	Hawaii Department of Education	150003000218	110	Jarrett Middle		Regular School	No	Middle	06	8	2021	grade_12	0.0	0
2456711	HI	school	1500030	1	Hawaii Department of Education	150003000205	126	Kawananakoa Middle		Regular School	No	Middle	06	8	2021	grade_12	0.0	0
2456726	HI	school	1500030	1	Hawaii Department of Education	150003000184	148	Stevenson Middle		Regular School	No	Middle	06	8	2021	grade_12	0.0	0
2456727	HI	school	1500030	1	Hawaii Department of Education	150003000180	152	Washington Middle		Regular School	No	Middle	06	8	2021	grade_12	0.0	0
2456760	HI	school	1500030	1	Hawaii Department of Education	150003000256	238	Mililani Middle		Regular School	No	Middle	06	8	2021	grade_12	0.0	0
2456765	HI	school	1500030	1	Hawaii Department of Education	150003000143	230	Wahiawa Middle		Regular School	No	Middle	06	8	2021	grade_12	0.0	0
2456769	HI	school	1500030	1	Hawaii Department of Education	150003000137	237	Wheeler Middle		Regular School	No	Middle	06	8	2021	grade_12	0.0	0
2456774	HI	school	1500030	1	Hawaii Department of Education	150003000296	296	Ewa Makai Middle		Regular School	No	Middle	06	8	2021	grade_12	0.0	0
2456776	HI	school	1500030	1	Hawaii Department of Education	150003000306	297	Honouliuli Middle		Regular School	No	Middle	06	6	2021	grade_12	0.0	0
2456783	HI	school	1500030	1	Hawaii Department of Education	150003000259	291	Kapolei Middle		Regular School	No	Middle	06	8	2021	grade_12	0.0	0
2456855	HI	school	1500030	1	Hawaii Department of Education	150003000053	385	Waiakea Int		Regular School	No	Middle	06	8	2021	grade_12	0.0	0
2456866	HI	school	1500030	1	Hawaii Department of Education	150003000235	390	Kealakehe Int		Regular School	No	Middle	06	8	2021	grade_12	0.0	0
2456869	HI	school	1500030	1	Hawaii Department of Education	150003000267	366	Kohala Middle		Regular School	No	Middle	06	8	2021	grade_12	0.0	0
2456872	HI	school	1500030	1	Hawaii Department of Education	150003000252	376	Konawaena Middle		Regular School	No	Middle	06	8	2021	grade_12	0.0	0
2456879	HI	school	1500030	1	Hawaii Department of Education	150003000040	370	Keaau Middle		Regular School	No	Middle	06	8	2021	grade_12	0.0	0
2456887	HI	school	1500030	1	Hawaii Department of Education	150003000059	404	Iao Int		Regular School	No	Middle	06	8	2021	grade_12	0.0	0
2456889	HI	school	1500030	1	Hawaii Department of Education	150003000233	420	Kalama Int		Regular School	No	Middle	06	8	2021	grade_12	0.0	0
2456895	HI	school	1500030	1	Hawaii Department of Education	150003000238	430	Lokelani Int		Regular School	No	Middle	06	8	2021	grade_12	0.0	0
2456898	HI	school	1500030	1	Hawaii Department of Education	150003000241	428	Maui Waena Int		Regular School	No	Middle	06	8	2021	grade_12	0.0	0
2456909	HI	school	1500030	1	Hawaii Department of Education	150003000068	413	Lahaina Int		Regular School	No	Middle	06	8	2021	grade_12	0.0	0
2456919	HI	school	1500030	1	Hawaii Department of Education	150003000266	448	Kamakahelei Middle		Regular School	No	Middle	06	8	2021	grade_12	0.0	0
2456922	HI	school	1500030	1	Hawaii Department of Education	150003000255	447	Kapaa Middle		Regular School	No	Middle	06	8	2021	grade_12	0.0	0
2456929	HI	school	1500030	1	Hawaii Department of Education	150003000092	464	Waimea Canyon Middle		Regular School	No	Middle	06	8	2021	grade_12	0.0	0
2456934	HI	school	1500030	1	Hawaii Department of Education	150003000305	568	DreamHouse Ewa Beach	charter	Regular School	Yes	Middle	06	7	2021	grade_12	0.0	0
2456962	HI	school	1500030	1	Hawaii Department of Education	150003000298	567	SEEQS PCS	charter	Regular School	Yes	Middle	06	8	2021	grade_12	0.0	0
2456967	HI	school	1500030	1	Hawaii Department of Education	150003000268	394	Waimea Middle PCCS	charter	Regular School	Yes	Middle	06	8	2021	grade_12	0.0	0
2456968	HI	school	1500030	1	Hawaii Department of Education	150003000265	399	West Hawaii Explorations PCS	charter	Regular School	Yes	High	06	12	2021	grade_12	34.0	34
2737641	HI	school	1500030	1	Hawaii Department of Education	150003000222	105	Dole Middle		Regular School	No	Middle	06	8	2019	grade_12	0.0	0
2737648	HI	school	1500030	1	Hawaii Department of Education	150003000211	116	Kaimuki Middle		Regular School	No	Middle	06	8	2019	grade_12	0.0	0
2737650	HI	school	1500030	1	Hawaii Department of Education	150003000164	118	Kalakaua Middle		Regular School	No	Middle	06	8	2019	grade_12	0.0	0
2737661	HI	school	1500030	1	Hawaii Department of Education	150003000192	139	Niu Valley Middle		Regular School	No	Middle	06	8	2019	grade_12	0.0	0
2737668	HI	school	1500030	1	Hawaii Department of Education	150003000223	104	Central Middle		Regular School	No	Middle	06	8	2019	grade_12	0.0	0
2737670	HI	school	1500030	1	Hawaii Department of Education	150003000218	110	Jarrett Middle		Regular School	No	Middle	06	8	2019	grade_12	0.0	0
2737676	HI	school	1500030	1	Hawaii Department of Education	150003000205	126	Kawananakoa Middle		Regular School	No	Middle	06	8	2019	grade_12	0.0	0
2737691	HI	school	1500030	1	Hawaii Department of Education	150003000184	148	Stevenson Middle		Regular School	No	Middle	06	8	2019	grade_12	0.0	0
2737692	HI	school	1500030	1	Hawaii Department of Education	150003000180	152	Washington Middle		Regular School	No	Middle	06	8	2019	grade_12	0.0	0
2737725	HI	school	1500030	1	Hawaii Department of Education	150003000256	238	Mililani Middle		Regular School	No	Middle	06	8	2019	grade_12	0.0	0
2737730	HI	school	1500030	1	Hawaii Department of Education	150003000143	230	Wahiawa Middle		Regular School	No	Middle	06	8	2019	grade_12	0.0	0
2737734	HI	school	1500030	1	Hawaii Department of Education	150003000137	237	Wheeler Middle		Regular School	No	Middle	06	8	2019	grade_12	0.0	0
2737747	HI	school	1500030	1	Hawaii Department of Education	150003000259	291	Kapolei Middle		Regular School	No	Middle	06	8	2019	grade_12	0.0	0
2737819	HI	school	1500030	1	Hawaii Department of Education	150003000053	385	Waiakea Int		Regular School	No	Middle	06	8	2019	grade_12	0.0	0
2737830	HI	school	1500030	1	Hawaii Department of Education	150003000235	390	Kealakehe Int		Regular School	No	Middle	06	8	2019	grade_12	0.0	0
2737833	HI	school	1500030	1	Hawaii Department of Education	150003000267	366	Kohala Middle		Regular School	No	Middle	06	8	2019	grade_12	0.0	0
2737836	HI	school	1500030	1	Hawaii Department of Education	150003000252	376	Konawaena Middle		Regular School	No	Middle	06	8	2019	grade_12	0.0	0
2737843	HI	school	1500030	1	Hawaii Department of Education	150003000040	370	Keaau Middle		Regular School	No	Middle	06	8	2019	grade_12	0.0	0
2737851	HI	school	1500030	1	Hawaii Department of Education	150003000059	404	Iao Int		Regular School	No	Middle	06	8	2019	grade_12	0.0	0
2737853	HI	school	1500030	1	Hawaii Department of Education	150003000233	420	Kalama Int		Regular School	No	Middle	06	8	2019	grade_12	0.0	0
2737859	HI	school	1500030	1	Hawaii Department of Education	150003000238	430	Lokelani Int		Regular School	No	Middle	06	8	2019	grade_12	0.0	0
2737862	HI	school	1500030	1	Hawaii Department of Education	150003000241	428	Maui Waena Int		Regular School	No	Middle	06	8	2019	grade_12	0.0	0
2737873	HI	school	1500030	1	Hawaii Department of Education	150003000068	413	Lahaina Int		Regular School	No	Middle	06	8	2019	grade_12	0.0	0
2737883	HI	school	1500030	1	Hawaii Department of Education	150003000266	448	Kamakahelei Middle		Regular School	No	Middle	06	8	2019	grade_12	0.0	0
2737886	HI	school	1500030	1	Hawaii Department of Education	150003000255	447	Kapaa Middle		Regular School	No	Middle	06	8	2019	grade_12	0.0	0
2737893	HI	school	1500030	1	Hawaii Department of Education	150003000092	464	Waimea Canyon Middle		Regular School	No	Middle	06	8	2019	grade_12	0.0	0
2737900	HI	school	1500030	1	Hawaii Department of Education	150003000268	394	Waimea Middle PCCS	charter	Regular School	Yes	Middle	06	8	2019	grade_12	0.0	0
2737904	HI	school	1500030	1	Hawaii Department of Education	150003000265	399	West Hawaii Explorations PCS	charter	Regular School	Yes	High	06	12	2019	grade_12	24.0	24
2737931	HI	school	1500030	1	Hawaii Department of Education	150003000298	567	SEEQS PCS	charter	Regular School	Yes	Middle	06	8	2019	grade_12	0.0	0
2782691	HI	school	1500030	1	Hawaii Department of Education	150003000222	105	Dole Middle		Regular School	No	Middle	06	8	2018	grade_12	0.0	0
2782698	HI	school	1500030	1	Hawaii Department of Education	150003000211	116	Kaimuki Middle		Regular School	No	Middle	06	8	2018	grade_12	0.0	0
2782700	HI	school	1500030	1	Hawaii Department of Education	150003000164	118	Kalakaua Middle		Regular School	No	Middle	06	8	2018	grade_12	0.0	0
2782711	HI	school	1500030	1	Hawaii Department of Education	150003000192	139	Niu Valley Middle		Regular School	No	Middle	06	8	2018	grade_12	0.0	0
2782718	HI	school	1500030	1	Hawaii Department of Education	150003000223	104	Central Middle		Regular School	No	Middle	06	8	2018	grade_12	0.0	0