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 (rowid < :p3 or rowid is null or (rowid = :p3 and rowid > :p2)) order by rowid desc, 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
2782105	HI	school	1500030	1	Hawaii Department of Education	150003000265	399	West Hawaii Explorations PCS	charter	Regular School	Yes	High	06	12	2018	grade_9	51.0	51
2782104	HI	school	1500030	1	Hawaii Department of Education	150003000268	394	Waimea Middle PCCS	charter	Regular School	Yes	Middle	06	8	2018	grade_9	0.0	0
2782103	HI	school	1500030	1	Hawaii Department of Education	150003000183	149	Waialae Elem PCS	charter	Regular School	Yes	Elementary	PK	5	2018	grade_9	0.0	0
2782102	HI	school	1500030	1	Hawaii Department of Education	150003000271	541	Voyager PCS	charter	Regular School	Yes	Elementary	KG	8	2018	grade_9	0.0	0
2782101	HI	school	1500030	1	Hawaii Department of Education	150003000281	560	Volcano of Arts & Sci	charter	Regular School	Yes	Elementary	PK	8	2018	grade_9	0.0	0
2782100	HI	school	1500030	1	Hawaii Department of Education	150003000273	543	University Laboratory School	charter	Regular School	Yes	Other	KG	12	2018	grade_9	51.0	51
2782099	HI	school	1500030	1	Hawaii Department of Education	150003000298	567	SEEQS PCS	charter	Regular School	Yes	Middle	06	8	2018	grade_9	0.0	0
2782098	HI	school	1500030	1	Hawaii Department of Education	150003000264	398	Na Wai Ola NCPCS	charter	Regular School	Yes	Elementary	PK	6	2018	grade_9	0.0	0
2782097	HI	school	1500030	1	Hawaii Department of Education	150003000274	544	Myron Thompson Acad NCPCS	charter	Regular School	Yes	Other	KG	12	2018	grade_9	26.0	26
2782096	HI	school	1500030	1	Hawaii Department of Education	150003000299	550	Malama Honua	charter	Regular School	Yes	Elementary	KG	5	2018	grade_9	0.0	0
2782095	HI	school	1500030	1	Hawaii Department of Education	150003000046	377	Laupahoehoe Community PCS	charter	Regular School	Yes	Other	PK	12	2018	grade_9	20.0	20
2782094	HI	school	1500030	1	Hawaii Department of Education	150003000066	411	Kualapuu El NCPCCS	charter	Regular School	Yes	Elementary	PK	6	2018	grade_9	0.0	0
2782093	HI	school	1500030	1	Hawaii Department of Education	150003000288	557	Kua O Ka La PCS	charter	Regular School	Yes	Other	PK	12	2018	grade_9	18.0	18
2782092	HI	school	1500030	1	Hawaii Department of Education	150003000293	566	Kona Pacific PCS	charter	Regular School	Yes	Elementary	KG	8	2018	grade_9	0.0	0
2782091	HI	school	1500030	1	Hawaii Department of Education	150003000279	554	Kihei Charter School	charter	Regular School	Yes	Other	KG	12	2018	grade_9	62.0	62
2782090	HI	school	1500030	1	Hawaii Department of Education	150003000280	556	Ke Kula O Niihau Kekaha LPCS	charter	Regular School	Yes	Other	PK	12	2018	grade_9	3.0	3
2782089	HI	school	1500030	1	Hawaii Department of Education	150003000276	547	Ke Kula O Kamakau Lab PCS	charter	Regular School	Yes	Other	PK	12	2018	grade_9	5.0	5
2782088	HI	school	1500030	1	Hawaii Department of Education	150003000284	563	Ke Kula Nawahiokalaniopuu Iki Lab PCS	charter	Regular School	Yes	Elementary	PK	8	2018	grade_9	0.0	0
2782087	HI	school	1500030	1	Hawaii Department of Education	150003000278	549	Ke Ana Laahana PCS	charter	Regular School	Yes	High	07	12	2018	grade_9	7.0	7
2782086	HI	school	1500030	1	Hawaii Department of Education	150003000294	565	Kawaikini NCPCS	charter	Regular School	Yes	Other	KG	12	2018	grade_9	6.0	6
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
2782084	HI	school	1500030	1	Hawaii Department of Education	150003000302	555	Kapolei Charter School	charter	Regular School	Yes	Secondary	09	9	2018	grade_9	43.0	43
2782083	HI	school	1500030	1	Hawaii Department of Education	150003000018	320	Kaohao PCS	charter	Regular School	Yes	Elementary	PK	6	2018	grade_9	0.0	0
2782082	HI	school	1500030	1	Hawaii Department of Education	150003000289	564	Kanuikapono PCS	charter	Regular School	Yes	Other	KG	12	2018	grade_9	5.0	5
2782081	HI	school	1500030	1	Hawaii Department of Education	150003000263	397	Kanu O Ka Aina NCPCS	charter	Regular School	Yes	Other	KG	12	2018	grade_9	20.0	20
2782080	HI	school	1500030	1	Hawaii Department of Education	150003000269	466	Kanaka PCS	charter	Regular School	Yes	Other	PK	12	2018	grade_9	1.0	1
2782079	HI	school	1500030	1	Hawaii Department of Education	150003000303	553	Kamalani Academy	charter	Regular School	Yes	Elementary	PK	8	2018	grade_9	0.0	0
2782078	HI	school	1500030	1	Hawaii Department of Education	150003000240	275	Kamaile Academy PCS	charter	Regular School	Yes	Other	PK	12	2018	grade_9	29.0	29
2782077	HI	school	1500030	1	Hawaii Department of Education	150003000286	545	Ka Waihona o ka Naauao NCPCS	charter	Regular School	Yes	Elementary	KG	8	2018	grade_9	0.0	0
2782076	HI	school	1500030	1	Hawaii Department of Education	150003000283	562	Ka Umeke Kaeo PCS	charter	Regular School	Yes	Other	PK	9	2018	grade_9	5.0	5
2782075	HI	school	1500030	1	Hawaii Department of Education	150003000277	548	Innovations PCS	charter	Regular School	Yes	Elementary	KG	8	2018	grade_9	0.0	0
2782074	HI	school	1500030	1	Hawaii Department of Education	150003000295	551	Hawaii Tech Acad PCS	charter	Regular School	Yes	Other	KG	12	2018	grade_9	137.0	137
2782073	HI	school	1500030	1	Hawaii Department of Education	150003000282	561	Hawaii Academy of Arts & Science PCS	charter	Regular School	Yes	Other	KG	12	2018	grade_9	75.0	75
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
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
2782070	HI	school	1500030	1	Hawaii Department of Education	150003000262	396	Connections NCPCS	charter	Regular School	Yes	Other	KG	12	2018	grade_9	30.0	30
2782069	HI	school	1500030	1	Hawaii Department of Education	150003000094	463	Wilcox Elem		Regular School	No	Elementary	PK	5	2018	grade_9	0.0	0
2782068	HI	school	1500030	1	Hawaii Department of Education	150003000093	462	Waimea High		Regular School	No	High	09	12	2018	grade_9	131.0	131
2782067	HI	school	1500030	1	Hawaii Department of Education	150003000092	464	Waimea Canyon Middle		Regular School	No	Middle	06	8	2018	grade_9	0.0	0
2782066	HI	school	1500030	1	Hawaii Department of Education	150003000091	461	Niihau High & Elem		Regular School	No	Other	PK	12	2018	grade_9	1.0	1
2782065	HI	school	1500030	1	Hawaii Department of Education	150003000090	460	Koloa Elem		Regular School	No	Elementary	PK	5	2018	grade_9	0.0	0
2782064	HI	school	1500030	1	Hawaii Department of Education	150003000089	459	Kilauea Elem		Regular School	No	Elementary	PK	6	2018	grade_9	0.0	0
2782063	HI	school	1500030	1	Hawaii Department of Education	150003000088	458	Kekaha Elem		Regular School	No	Elementary	PK	5	2018	grade_9	0.0	0
2782062	HI	school	1500030	1	Hawaii Department of Education	150003000242	457	Kaumualii Elem		Regular School	No	Elementary	PK	5	2018	grade_9	0.0	0
2782061	HI	school	1500030	1	Hawaii Department of Education	150003000086	456	Kauai High		Regular School	No	High	09	12	2018	grade_9	270.0	270
2782060	HI	school	1500030	1	Hawaii Department of Education	150003000255	447	Kapaa Middle		Regular School	No	Middle	06	8	2018	grade_9	0.0	0
2782059	HI	school	1500030	1	Hawaii Department of Education	150003000085	455	Kapaa High		Regular School	No	High	09	12	2018	grade_9	249.0	249
2782058	HI	school	1500030	1	Hawaii Department of Education	150003000084	454	Kapaa Elem		Regular School	No	Elementary	PK	5	2018	grade_9	0.0	0
2782057	HI	school	1500030	1	Hawaii Department of Education	150003000266	448	Kamakahelei Middle		Regular School	No	Middle	06	8	2018	grade_9	0.0	0
2782056	HI	school	1500030	1	Hawaii Department of Education	150003000083	453	Kalaheo Elem		Regular School	No	Elementary	PK	5	2018	grade_9	0.0	0
2782055	HI	school	1500030	1	Hawaii Department of Education	150003000082	452	Hanalei Elem		Regular School	No	Elementary	PK	6	2018	grade_9	0.0	0
2782054	HI	school	1500030	1	Hawaii Department of Education	150003000081	451	Eleele Elem		Regular School	No	Elementary	PK	5	2018	grade_9	0.0	0
2782053	HI	school	1500030	1	Hawaii Department of Education	150003000237	429	Nahienaena Elem		Regular School	No	Elementary	PK	5	2018	grade_9	0.0	0
2782052	HI	school	1500030	1	Hawaii Department of Education	150003000290	434	Molokai Middle		Regular School	No	Middle	07	8	2018	grade_9	0.0	0
2782051	HI	school	1500030	1	Hawaii Department of Education	150003000075	421	Molokai High		Regular School	No	High	09	12	2018	grade_9	77.0	77
2782050	HI	school	1500030	1	Hawaii Department of Education	150003000074	419	Maunaloa Elem		Regular School	No	Elementary	PK	6	2018	grade_9	0.0	0
2782049	HI	school	1500030	1	Hawaii Department of Education	150003000070	415	Lanai High & Elem		Regular School	No	Other	PK	12	2018	grade_9	40.0	40
2782048	HI	school	1500030	1	Hawaii Department of Education	150003000069	414	Lahainaluna High		Regular School	No	High	09	12	2018	grade_9	255.0	255
2782047	HI	school	1500030	1	Hawaii Department of Education	150003000068	413	Lahaina Int		Regular School	No	Middle	06	8	2018	grade_9	0.0	0
2782046	HI	school	1500030	1	Hawaii Department of Education	150003000065	410	Kilohana Elem		Regular School	No	Elementary	PK	6	2018	grade_9	0.0	0
2782045	HI	school	1500030	1	Hawaii Department of Education	150003000062	407	Kaunakakai Elem		Regular School	No	Elementary	PK	6	2018	grade_9	0.0	0
2782044	HI	school	1500030	1	Hawaii Department of Education	150003000061	406	Kamehameha III Elem		Regular School	No	Elementary	PK	5	2018	grade_9	0.0	0
2782043	HI	school	1500030	1	Hawaii Department of Education	150003000058	402	Hana High & Elem		Regular School	No	Other	PK	12	2018	grade_9	20.0	20
2782042	HI	school	1500030	1	Hawaii Department of Education	150003000080	425	Wailuku Elem		Regular School	No	Elementary	PK	5	2018	grade_9	0.0	0
2782041	HI	school	1500030	1	Hawaii Department of Education	150003000079	424	Waihee Elem		Regular School	No	Elementary	PK	5	2018	grade_9	0.0	0
2782040	HI	school	1500030	1	Hawaii Department of Education	150003000297	436	Puu Kukui Elem		Regular School	No	Elementary	PK	5	2018	grade_9	0.0	0
2782039	HI	school	1500030	1	Hawaii Department of Education	150003000077	426	Pukalani Elem		Regular School	No	Elementary	PK	5	2018	grade_9	0.0	0
2782038	HI	school	1500030	1	Hawaii Department of Education	150003000292	433	Pomaikai Elem		Regular School	No	Elementary	PK	5	2018	grade_9	0.0	0
2782037	HI	school	1500030	1	Hawaii Department of Education	150003000076	422	Paia Elem		Regular School	No	Elementary	PK	5	2018	grade_9	0.0	0
2782036	HI	school	1500030	1	Hawaii Department of Education	150003000241	428	Maui Waena Int		Regular School	No	Middle	06	8	2018	grade_9	0.0	0
2782035	HI	school	1500030	1	Hawaii Department of Education	150003000073	418	Maui High		Regular School	No	High	09	12	2018	grade_9	530.0	530
2782034	HI	school	1500030	1	Hawaii Department of Education	150003000072	417	Makawao Elem		Regular School	No	Elementary	PK	5	2018	grade_9	0.0	0
2782033	HI	school	1500030	1	Hawaii Department of Education	150003000238	430	Lokelani Int		Regular School	No	Middle	06	8	2018	grade_9	0.0	0
2782032	HI	school	1500030	1	Hawaii Department of Education	150003000071	416	Lihikai Elem		Regular School	No	Elementary	PK	5	2018	grade_9	0.0	0
2782031	HI	school	1500030	1	Hawaii Department of Education	150003000067	412	Kula Elem		Regular School	No	Elementary	PK	5	2018	grade_9	0.0	0
2782030	HI	school	1500030	1	Hawaii Department of Education	150003000064	409	Kihei Elem		Regular School	No	Elementary	PK	5	2018	grade_9	0.0	0
2782029	HI	school	1500030	1	Hawaii Department of Education	150003000251	435	Kekaulike High		Regular School	No	High	09	12	2018	grade_9	268.0	268
2782028	HI	school	1500030	1	Hawaii Department of Education	150003000253	431	Kamalii Elem		Regular School	No	Elementary	PK	5	2018	grade_9	0.0	0
2782027	HI	school	1500030	1	Hawaii Department of Education	150003000233	420	Kalama Int		Regular School	No	Middle	06	8	2018	grade_9	0.0	0
2782026	HI	school	1500030	1	Hawaii Department of Education	150003000060	405	Kahului Elem		Regular School	No	Elementary	PK	5	2018	grade_9	0.0	0
2782025	HI	school	1500030	1	Hawaii Department of Education	150003000059	404	Iao Int		Regular School	No	Middle	06	8	2018	grade_9	0.0	0
2782024	HI	school	1500030	1	Hawaii Department of Education	150003000057	401	Haiku Elem		Regular School	No	Elementary	PK	5	2018	grade_9	0.0	0
2782023	HI	school	1500030	1	Hawaii Department of Education	150003000056	400	Baldwin High		Regular School	No	High	09	12	2018	grade_9	333.0	333
2782022	HI	school	1500030	1	Hawaii Department of Education	150003000050	383	Pahoa High & Int		Regular School	No	High	07	12	2018	grade_9	70.0	70
2782021	HI	school	1500030	1	Hawaii Department of Education	150003000234	381	Pahoa Elem		Regular School	No	Elementary	PK	6	2018	grade_9	0.0	0
2782020	HI	school	1500030	1	Hawaii Department of Education	150003000048	380	Naalehu Elem		Regular School	No	Elementary	PK	6	2018	grade_9	0.0	0
2782019	HI	school	1500030	1	Hawaii Department of Education	150003000047	379	Mountain View Elem		Regular School	No	Elementary	PK	5	2018	grade_9	0.0	0
2782018	HI	school	1500030	1	Hawaii Department of Education	150003000244	391	Keonepoko Elem		Regular School	No	Elementary	PK	6	2018	grade_9	0.0	0
2782017	HI	school	1500030	1	Hawaii Department of Education	150003000040	370	Keaau Middle		Regular School	No	Middle	06	8	2018	grade_9	0.0	0
2782016	HI	school	1500030	1	Hawaii Department of Education	150003000260	354	Keaau High		Regular School	No	High	09	12	2018	grade_9	247.0	247
2782015	HI	school	1500030	1	Hawaii Department of Education	150003000258	353	Keaau Elem		Regular School	No	Elementary	PK	5	2018	grade_9	0.0	0
2782014	HI	school	1500030	1	Hawaii Department of Education	150003000038	368	Kau High & Pahala Elem		Regular School	No	Other	PK	12	2018	grade_9	63.0	63
2782013	HI	school	1500030	1	Hawaii Department of Education	150003000055	387	Waimea Elem		Regular School	No	Elementary	PK	5	2018	grade_9	0.0	0
2782012	HI	school	1500030	1	Hawaii Department of Education	150003000247	393	Waikoloa El & Middle		Regular School	No	Elementary	PK	8	2018	grade_9	0.0	0
2782011	HI	school	1500030	1	Hawaii Department of Education	150003000049	382	Paauilo El & Int		Regular School	No	Other	PK	9	2018	grade_9	8.0	8
2782010	HI	school	1500030	1	Hawaii Department of Education	150003000252	376	Konawaena Middle		Regular School	No	Middle	06	8	2018	grade_9	0.0	0
2782009	HI	school	1500030	1	Hawaii Department of Education	150003000045	374	Konawaena High		Regular School	No	High	09	12	2018	grade_9	208.0	208
2782008	HI	school	1500030	1	Hawaii Department of Education	150003000044	375	Konawaena Elem		Regular School	No	Elementary	PK	5	2018	grade_9	0.0	0
2782007	HI	school	1500030	1	Hawaii Department of Education	150003000267	366	Kohala Middle		Regular School	No	Middle	06	8	2018	grade_9	0.0	0
2782006	HI	school	1500030	1	Hawaii Department of Education	150003000043	373	Kohala High		Regular School	No	High	09	12	2018	grade_9	60.0	60
2782005	HI	school	1500030	1	Hawaii Department of Education	150003000250	395	Kohala Elem		Regular School	No	Elementary	PK	5	2018	grade_9	0.0	0