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
280510	HI	school	1500030	1	Hawaii Department of Education	150003000092	464	WAIMEA CANYON		Regular School	No	2	06	8	2015	grade_10	0.0	0
280517	HI	school	1500030	1	Hawaii Department of Education	150003000268	394	WAIMEA MID-PCCS	charter	Regular School	Yes	2	06	8	2015	grade_10	0.0	0
280521	HI	school	1500030	1	Hawaii Department of Education	150003000265	399	WEST HI EXPLOR ACAD-PCS	charter	Regular School	Yes	4	06	12	2015	grade_10	49.0	49
280546	HI	school	1500030	1	Hawaii Department of Education	150003000298	567	SEEQS	charter	Regular School	Yes	2	06	8	2015	grade_10	0.0	0
2431397	HI	school	1500030	1	Hawaii Department of Education	150003000222	105	Dole Middle		Regular School	No	Middle	06	8	2020	grade_10	0.0	0
2431404	HI	school	1500030	1	Hawaii Department of Education	150003000211	116	Kaimuki Middle		Regular School	No	Middle	06	8	2020	grade_10	0.0	0
2431406	HI	school	1500030	1	Hawaii Department of Education	150003000164	118	Kalakaua Middle		Regular School	No	Middle	06	8	2020	grade_10	0.0	0
2431417	HI	school	1500030	1	Hawaii Department of Education	150003000192	139	Niu Valley Middle		Regular School	No	Middle	06	8	2020	grade_10	0.0	0
2431424	HI	school	1500030	1	Hawaii Department of Education	150003000223	104	Central Middle		Regular School	No	Middle	06	8	2020	grade_10	0.0	0
2431426	HI	school	1500030	1	Hawaii Department of Education	150003000218	110	Jarrett Middle		Regular School	No	Middle	06	8	2020	grade_10	0.0	0
2431432	HI	school	1500030	1	Hawaii Department of Education	150003000205	126	Kawananakoa Middle		Regular School	No	Middle	06	8	2020	grade_10	0.0	0
2431447	HI	school	1500030	1	Hawaii Department of Education	150003000184	148	Stevenson Middle		Regular School	No	Middle	06	8	2020	grade_10	0.0	0
2431448	HI	school	1500030	1	Hawaii Department of Education	150003000180	152	Washington Middle		Regular School	No	Middle	06	8	2020	grade_10	0.0	0
2431481	HI	school	1500030	1	Hawaii Department of Education	150003000256	238	Mililani Middle		Regular School	No	Middle	06	8	2020	grade_10	0.0	0
2431486	HI	school	1500030	1	Hawaii Department of Education	150003000143	230	Wahiawa Middle		Regular School	No	Middle	06	8	2020	grade_10	0.0	0
2431490	HI	school	1500030	1	Hawaii Department of Education	150003000137	237	Wheeler Middle		Regular School	No	Middle	06	8	2020	grade_10	0.0	0
2431495	HI	school	1500030	1	Hawaii Department of Education	150003000296	296	Ewa Makai Middle		Regular School	No	Middle	06	8	2020	grade_10	0.0	0
2431503	HI	school	1500030	1	Hawaii Department of Education	150003000259	291	Kapolei Middle		Regular School	No	Middle	06	8	2020	grade_10	0.0	0
2431575	HI	school	1500030	1	Hawaii Department of Education	150003000053	385	Waiakea Int		Regular School	No	Middle	06	8	2020	grade_10	0.0	0
2431586	HI	school	1500030	1	Hawaii Department of Education	150003000235	390	Kealakehe Int		Regular School	No	Middle	06	8	2020	grade_10	0.0	0
2431589	HI	school	1500030	1	Hawaii Department of Education	150003000267	366	Kohala Middle		Regular School	No	Middle	06	8	2020	grade_10	0.0	0
2431592	HI	school	1500030	1	Hawaii Department of Education	150003000252	376	Konawaena Middle		Regular School	No	Middle	06	8	2020	grade_10	0.0	0
2431599	HI	school	1500030	1	Hawaii Department of Education	150003000040	370	Keaau Middle		Regular School	No	Middle	06	8	2020	grade_10	0.0	0
2431607	HI	school	1500030	1	Hawaii Department of Education	150003000059	404	Iao Int		Regular School	No	Middle	06	8	2020	grade_10	0.0	0
2431609	HI	school	1500030	1	Hawaii Department of Education	150003000233	420	Kalama Int		Regular School	No	Middle	06	8	2020	grade_10	0.0	0
2431615	HI	school	1500030	1	Hawaii Department of Education	150003000238	430	Lokelani Int		Regular School	No	Middle	06	8	2020	grade_10	0.0	0
2431618	HI	school	1500030	1	Hawaii Department of Education	150003000241	428	Maui Waena Int		Regular School	No	Middle	06	8	2020	grade_10	0.0	0
2431629	HI	school	1500030	1	Hawaii Department of Education	150003000068	413	Lahaina Int		Regular School	No	Middle	06	8	2020	grade_10	0.0	0
2431639	HI	school	1500030	1	Hawaii Department of Education	150003000266	448	Kamakahelei Middle		Regular School	No	Middle	06	8	2020	grade_10	0.0	0
2431642	HI	school	1500030	1	Hawaii Department of Education	150003000255	447	Kapaa Middle		Regular School	No	Middle	06	8	2020	grade_10	0.0	0
2431649	HI	school	1500030	1	Hawaii Department of Education	150003000092	464	Waimea Canyon Middle		Regular School	No	Middle	06	8	2020	grade_10	0.0	0
2431654	HI	school	1500030	1	Hawaii Department of Education	150003000305	568	DreamHouse Ewa Beach	charter	Regular School	Yes	Middle	06	6	2020	grade_10	0.0	0
2431682	HI	school	1500030	1	Hawaii Department of Education	150003000298	567	SEEQS PCS	charter	Regular School	Yes	Middle	06	8	2020	grade_10	0.0	0
2431687	HI	school	1500030	1	Hawaii Department of Education	150003000268	394	Waimea Middle PCCS	charter	Regular School	Yes	Middle	06	8	2020	grade_10	0.0	0
2431688	HI	school	1500030	1	Hawaii Department of Education	150003000265	399	West Hawaii Explorations PCS	charter	Regular School	Yes	High	06	12	2020	grade_10	43.0	43
2456088	HI	school	1500030	1	Hawaii Department of Education	150003000222	105	Dole Middle		Regular School	No	Middle	06	8	2021	grade_10	0.0	0
2456095	HI	school	1500030	1	Hawaii Department of Education	150003000211	116	Kaimuki Middle		Regular School	No	Middle	06	8	2021	grade_10	0.0	0
2456097	HI	school	1500030	1	Hawaii Department of Education	150003000164	118	Kalakaua Middle		Regular School	No	Middle	06	8	2021	grade_10	0.0	0
2456108	HI	school	1500030	1	Hawaii Department of Education	150003000192	139	Niu Valley Middle		Regular School	No	Middle	06	8	2021	grade_10	0.0	0
2456115	HI	school	1500030	1	Hawaii Department of Education	150003000223	104	Central Middle		Regular School	No	Middle	06	8	2021	grade_10	0.0	0
2456117	HI	school	1500030	1	Hawaii Department of Education	150003000218	110	Jarrett Middle		Regular School	No	Middle	06	8	2021	grade_10	0.0	0
2456123	HI	school	1500030	1	Hawaii Department of Education	150003000205	126	Kawananakoa Middle		Regular School	No	Middle	06	8	2021	grade_10	0.0	0
2456138	HI	school	1500030	1	Hawaii Department of Education	150003000184	148	Stevenson Middle		Regular School	No	Middle	06	8	2021	grade_10	0.0	0
2456139	HI	school	1500030	1	Hawaii Department of Education	150003000180	152	Washington Middle		Regular School	No	Middle	06	8	2021	grade_10	0.0	0
2456172	HI	school	1500030	1	Hawaii Department of Education	150003000256	238	Mililani Middle		Regular School	No	Middle	06	8	2021	grade_10	0.0	0
2456177	HI	school	1500030	1	Hawaii Department of Education	150003000143	230	Wahiawa Middle		Regular School	No	Middle	06	8	2021	grade_10	0.0	0
2456181	HI	school	1500030	1	Hawaii Department of Education	150003000137	237	Wheeler Middle		Regular School	No	Middle	06	8	2021	grade_10	0.0	0
2456186	HI	school	1500030	1	Hawaii Department of Education	150003000296	296	Ewa Makai Middle		Regular School	No	Middle	06	8	2021	grade_10	0.0	0
2456188	HI	school	1500030	1	Hawaii Department of Education	150003000306	297	Honouliuli Middle		Regular School	No	Middle	06	6	2021	grade_10	0.0	0
2456195	HI	school	1500030	1	Hawaii Department of Education	150003000259	291	Kapolei Middle		Regular School	No	Middle	06	8	2021	grade_10	0.0	0
2456267	HI	school	1500030	1	Hawaii Department of Education	150003000053	385	Waiakea Int		Regular School	No	Middle	06	8	2021	grade_10	0.0	0
2456278	HI	school	1500030	1	Hawaii Department of Education	150003000235	390	Kealakehe Int		Regular School	No	Middle	06	8	2021	grade_10	0.0	0
2456281	HI	school	1500030	1	Hawaii Department of Education	150003000267	366	Kohala Middle		Regular School	No	Middle	06	8	2021	grade_10	0.0	0
2456284	HI	school	1500030	1	Hawaii Department of Education	150003000252	376	Konawaena Middle		Regular School	No	Middle	06	8	2021	grade_10	0.0	0
2456291	HI	school	1500030	1	Hawaii Department of Education	150003000040	370	Keaau Middle		Regular School	No	Middle	06	8	2021	grade_10	0.0	0
2456299	HI	school	1500030	1	Hawaii Department of Education	150003000059	404	Iao Int		Regular School	No	Middle	06	8	2021	grade_10	0.0	0
2456301	HI	school	1500030	1	Hawaii Department of Education	150003000233	420	Kalama Int		Regular School	No	Middle	06	8	2021	grade_10	0.0	0
2456307	HI	school	1500030	1	Hawaii Department of Education	150003000238	430	Lokelani Int		Regular School	No	Middle	06	8	2021	grade_10	0.0	0
2456310	HI	school	1500030	1	Hawaii Department of Education	150003000241	428	Maui Waena Int		Regular School	No	Middle	06	8	2021	grade_10	0.0	0
2456321	HI	school	1500030	1	Hawaii Department of Education	150003000068	413	Lahaina Int		Regular School	No	Middle	06	8	2021	grade_10	0.0	0
2456331	HI	school	1500030	1	Hawaii Department of Education	150003000266	448	Kamakahelei Middle		Regular School	No	Middle	06	8	2021	grade_10	0.0	0
2456334	HI	school	1500030	1	Hawaii Department of Education	150003000255	447	Kapaa Middle		Regular School	No	Middle	06	8	2021	grade_10	0.0	0
2456341	HI	school	1500030	1	Hawaii Department of Education	150003000092	464	Waimea Canyon Middle		Regular School	No	Middle	06	8	2021	grade_10	0.0	0
2456346	HI	school	1500030	1	Hawaii Department of Education	150003000305	568	DreamHouse Ewa Beach	charter	Regular School	Yes	Middle	06	7	2021	grade_10	0.0	0
2456374	HI	school	1500030	1	Hawaii Department of Education	150003000298	567	SEEQS PCS	charter	Regular School	Yes	Middle	06	8	2021	grade_10	0.0	0
2456379	HI	school	1500030	1	Hawaii Department of Education	150003000268	394	Waimea Middle PCCS	charter	Regular School	Yes	Middle	06	8	2021	grade_10	0.0	0
2456380	HI	school	1500030	1	Hawaii Department of Education	150003000265	399	West Hawaii Explorations PCS	charter	Regular School	Yes	High	06	12	2021	grade_10	39.0	39
2737057	HI	school	1500030	1	Hawaii Department of Education	150003000222	105	Dole Middle		Regular School	No	Middle	06	8	2019	grade_10	0.0	0
2737064	HI	school	1500030	1	Hawaii Department of Education	150003000211	116	Kaimuki Middle		Regular School	No	Middle	06	8	2019	grade_10	0.0	0
2737066	HI	school	1500030	1	Hawaii Department of Education	150003000164	118	Kalakaua Middle		Regular School	No	Middle	06	8	2019	grade_10	0.0	0
2737077	HI	school	1500030	1	Hawaii Department of Education	150003000192	139	Niu Valley Middle		Regular School	No	Middle	06	8	2019	grade_10	0.0	0
2737084	HI	school	1500030	1	Hawaii Department of Education	150003000223	104	Central Middle		Regular School	No	Middle	06	8	2019	grade_10	0.0	0
2737086	HI	school	1500030	1	Hawaii Department of Education	150003000218	110	Jarrett Middle		Regular School	No	Middle	06	8	2019	grade_10	0.0	0
2737092	HI	school	1500030	1	Hawaii Department of Education	150003000205	126	Kawananakoa Middle		Regular School	No	Middle	06	8	2019	grade_10	0.0	0
2737107	HI	school	1500030	1	Hawaii Department of Education	150003000184	148	Stevenson Middle		Regular School	No	Middle	06	8	2019	grade_10	0.0	0
2737108	HI	school	1500030	1	Hawaii Department of Education	150003000180	152	Washington Middle		Regular School	No	Middle	06	8	2019	grade_10	0.0	0
2737141	HI	school	1500030	1	Hawaii Department of Education	150003000256	238	Mililani Middle		Regular School	No	Middle	06	8	2019	grade_10	0.0	0
2737146	HI	school	1500030	1	Hawaii Department of Education	150003000143	230	Wahiawa Middle		Regular School	No	Middle	06	8	2019	grade_10	0.0	0
2737150	HI	school	1500030	1	Hawaii Department of Education	150003000137	237	Wheeler Middle		Regular School	No	Middle	06	8	2019	grade_10	0.0	0
2737163	HI	school	1500030	1	Hawaii Department of Education	150003000259	291	Kapolei Middle		Regular School	No	Middle	06	8	2019	grade_10	0.0	0
2737235	HI	school	1500030	1	Hawaii Department of Education	150003000053	385	Waiakea Int		Regular School	No	Middle	06	8	2019	grade_10	0.0	0
2737246	HI	school	1500030	1	Hawaii Department of Education	150003000235	390	Kealakehe Int		Regular School	No	Middle	06	8	2019	grade_10	0.0	0
2737249	HI	school	1500030	1	Hawaii Department of Education	150003000267	366	Kohala Middle		Regular School	No	Middle	06	8	2019	grade_10	0.0	0
2737252	HI	school	1500030	1	Hawaii Department of Education	150003000252	376	Konawaena Middle		Regular School	No	Middle	06	8	2019	grade_10	0.0	0
2737259	HI	school	1500030	1	Hawaii Department of Education	150003000040	370	Keaau Middle		Regular School	No	Middle	06	8	2019	grade_10	0.0	0
2737267	HI	school	1500030	1	Hawaii Department of Education	150003000059	404	Iao Int		Regular School	No	Middle	06	8	2019	grade_10	0.0	0
2737269	HI	school	1500030	1	Hawaii Department of Education	150003000233	420	Kalama Int		Regular School	No	Middle	06	8	2019	grade_10	0.0	0
2737275	HI	school	1500030	1	Hawaii Department of Education	150003000238	430	Lokelani Int		Regular School	No	Middle	06	8	2019	grade_10	0.0	0
2737278	HI	school	1500030	1	Hawaii Department of Education	150003000241	428	Maui Waena Int		Regular School	No	Middle	06	8	2019	grade_10	0.0	0
2737289	HI	school	1500030	1	Hawaii Department of Education	150003000068	413	Lahaina Int		Regular School	No	Middle	06	8	2019	grade_10	0.0	0
2737299	HI	school	1500030	1	Hawaii Department of Education	150003000266	448	Kamakahelei Middle		Regular School	No	Middle	06	8	2019	grade_10	0.0	0
2737302	HI	school	1500030	1	Hawaii Department of Education	150003000255	447	Kapaa Middle		Regular School	No	Middle	06	8	2019	grade_10	0.0	0
2737309	HI	school	1500030	1	Hawaii Department of Education	150003000092	464	Waimea Canyon Middle		Regular School	No	Middle	06	8	2019	grade_10	0.0	0
2737316	HI	school	1500030	1	Hawaii Department of Education	150003000268	394	Waimea Middle PCCS	charter	Regular School	Yes	Middle	06	8	2019	grade_10	0.0	0
2737320	HI	school	1500030	1	Hawaii Department of Education	150003000265	399	West Hawaii Explorations PCS	charter	Regular School	Yes	High	06	12	2019	grade_10	44.0	44
2737347	HI	school	1500030	1	Hawaii Department of Education	150003000298	567	SEEQS PCS	charter	Regular School	Yes	Middle	06	8	2019	grade_10	0.0	0
2782107	HI	school	1500030	1	Hawaii Department of Education	150003000222	105	Dole Middle		Regular School	No	Middle	06	8	2018	grade_10	0.0	0
2782114	HI	school	1500030	1	Hawaii Department of Education	150003000211	116	Kaimuki Middle		Regular School	No	Middle	06	8	2018	grade_10	0.0	0
2782116	HI	school	1500030	1	Hawaii Department of Education	150003000164	118	Kalakaua Middle		Regular School	No	Middle	06	8	2018	grade_10	0.0	0
2782127	HI	school	1500030	1	Hawaii Department of Education	150003000192	139	Niu Valley Middle		Regular School	No	Middle	06	8	2018	grade_10	0.0	0
2782134	HI	school	1500030	1	Hawaii Department of Education	150003000223	104	Central Middle		Regular School	No	Middle	06	8	2018	grade_10	0.0	0