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
2781521	HI	school	1500030	1	Hawaii Department of Education	150003000265	399	West Hawaii Explorations PCS	charter	Regular School	Yes	High	06	12	2018	grade_7	36.0	36
2781520	HI	school	1500030	1	Hawaii Department of Education	150003000268	394	Waimea Middle PCCS	charter	Regular School	Yes	Middle	06	8	2018	grade_7	82.0	82
2781519	HI	school	1500030	1	Hawaii Department of Education	150003000183	149	Waialae Elem PCS	charter	Regular School	Yes	Elementary	PK	5	2018	grade_7	0.0	0
2781518	HI	school	1500030	1	Hawaii Department of Education	150003000271	541	Voyager PCS	charter	Regular School	Yes	Elementary	KG	8	2018	grade_7	26.0	26
2781517	HI	school	1500030	1	Hawaii Department of Education	150003000281	560	Volcano of Arts & Sci	charter	Regular School	Yes	Elementary	PK	8	2018	grade_7	19.0	19
2781516	HI	school	1500030	1	Hawaii Department of Education	150003000273	543	University Laboratory School	charter	Regular School	Yes	Other	KG	12	2018	grade_7	54.0	54
2781515	HI	school	1500030	1	Hawaii Department of Education	150003000298	567	SEEQS PCS	charter	Regular School	Yes	Middle	06	8	2018	grade_7	49.0	49
2781514	HI	school	1500030	1	Hawaii Department of Education	150003000264	398	Na Wai Ola NCPCS	charter	Regular School	Yes	Elementary	PK	6	2018	grade_7	0.0	0
2781513	HI	school	1500030	1	Hawaii Department of Education	150003000274	544	Myron Thompson Acad NCPCS	charter	Regular School	Yes	Other	KG	12	2018	grade_7	36.0	36
2781512	HI	school	1500030	1	Hawaii Department of Education	150003000299	550	Malama Honua	charter	Regular School	Yes	Elementary	KG	5	2018	grade_7	0.0	0
2781511	HI	school	1500030	1	Hawaii Department of Education	150003000046	377	Laupahoehoe Community PCS	charter	Regular School	Yes	Other	PK	12	2018	grade_7	20.0	20
2781510	HI	school	1500030	1	Hawaii Department of Education	150003000066	411	Kualapuu El NCPCCS	charter	Regular School	Yes	Elementary	PK	6	2018	grade_7	0.0	0
2781509	HI	school	1500030	1	Hawaii Department of Education	150003000288	557	Kua O Ka La PCS	charter	Regular School	Yes	Other	PK	12	2018	grade_7	16.0	16
2781508	HI	school	1500030	1	Hawaii Department of Education	150003000293	566	Kona Pacific PCS	charter	Regular School	Yes	Elementary	KG	8	2018	grade_7	19.0	19
2781507	HI	school	1500030	1	Hawaii Department of Education	150003000279	554	Kihei Charter School	charter	Regular School	Yes	Other	KG	12	2018	grade_7	63.0	63
2781506	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_7	2.0	2
2781505	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_7	10.0	10
2781504	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_7	39.0	39
2781503	HI	school	1500030	1	Hawaii Department of Education	150003000278	549	Ke Ana Laahana PCS	charter	Regular School	Yes	High	07	12	2018	grade_7	2.0	2
2781502	HI	school	1500030	1	Hawaii Department of Education	150003000294	565	Kawaikini NCPCS	charter	Regular School	Yes	Other	KG	12	2018	grade_7	5.0	5
2781501	HI	school	1500030	1	Hawaii Department of Education	150003000301	552	Kau Learning Academy	charter	Regular School	Yes	Middle	03	7	2018	grade_7	19.0	19
2781500	HI	school	1500030	1	Hawaii Department of Education	150003000302	555	Kapolei Charter School	charter	Regular School	Yes	Secondary	09	9	2018	grade_7	0.0	0
2781499	HI	school	1500030	1	Hawaii Department of Education	150003000018	320	Kaohao PCS	charter	Regular School	Yes	Elementary	PK	6	2018	grade_7	0.0	0
2781498	HI	school	1500030	1	Hawaii Department of Education	150003000289	564	Kanuikapono PCS	charter	Regular School	Yes	Other	KG	12	2018	grade_7	16.0	16
2781497	HI	school	1500030	1	Hawaii Department of Education	150003000263	397	Kanu O Ka Aina NCPCS	charter	Regular School	Yes	Other	KG	12	2018	grade_7	58.0	58
2781496	HI	school	1500030	1	Hawaii Department of Education	150003000269	466	Kanaka PCS	charter	Regular School	Yes	Other	PK	12	2018	grade_7	4.0	4
2781495	HI	school	1500030	1	Hawaii Department of Education	150003000303	553	Kamalani Academy	charter	Regular School	Yes	Elementary	PK	8	2018	grade_7	25.0	25
2781494	HI	school	1500030	1	Hawaii Department of Education	150003000240	275	Kamaile Academy PCS	charter	Regular School	Yes	Other	PK	12	2018	grade_7	36.0	36
2781493	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_7	66.0	66
2781492	HI	school	1500030	1	Hawaii Department of Education	150003000283	562	Ka Umeke Kaeo PCS	charter	Regular School	Yes	Other	PK	9	2018	grade_7	14.0	14
2781491	HI	school	1500030	1	Hawaii Department of Education	150003000277	548	Innovations PCS	charter	Regular School	Yes	Elementary	KG	8	2018	grade_7	31.0	31
2781490	HI	school	1500030	1	Hawaii Department of Education	150003000295	551	Hawaii Tech Acad PCS	charter	Regular School	Yes	Other	KG	12	2018	grade_7	92.0	92
2781489	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_7	61.0	61
2781488	HI	school	1500030	1	Hawaii Department of Education	150003000270	540	Halau Ku Mana NCPCS	charter	Regular School	Yes	Other	04	12	2018	grade_7	20.0	20
2781487	HI	school	1500030	1	Hawaii Department of Education	150003000275	546	Hakipuu Learning Ctr PCS	charter	Regular School	Yes	Other	04	12	2018	grade_7	3.0	3
2781486	HI	school	1500030	1	Hawaii Department of Education	150003000262	396	Connections NCPCS	charter	Regular School	Yes	Other	KG	12	2018	grade_7	34.0	34
2781485	HI	school	1500030	1	Hawaii Department of Education	150003000094	463	Wilcox Elem		Regular School	No	Elementary	PK	5	2018	grade_7	0.0	0
2781484	HI	school	1500030	1	Hawaii Department of Education	150003000093	462	Waimea High		Regular School	No	High	09	12	2018	grade_7	0.0	0
2781483	HI	school	1500030	1	Hawaii Department of Education	150003000092	464	Waimea Canyon Middle		Regular School	No	Middle	06	8	2018	grade_7	133.0	133
2781482	HI	school	1500030	1	Hawaii Department of Education	150003000091	461	Niihau High & Elem		Regular School	No	Other	PK	12	2018	grade_7	0.0	0
2781481	HI	school	1500030	1	Hawaii Department of Education	150003000090	460	Koloa Elem		Regular School	No	Elementary	PK	5	2018	grade_7	0.0	0
2781480	HI	school	1500030	1	Hawaii Department of Education	150003000089	459	Kilauea Elem		Regular School	No	Elementary	PK	6	2018	grade_7	0.0	0
2781479	HI	school	1500030	1	Hawaii Department of Education	150003000088	458	Kekaha Elem		Regular School	No	Elementary	PK	5	2018	grade_7	0.0	0
2781478	HI	school	1500030	1	Hawaii Department of Education	150003000242	457	Kaumualii Elem		Regular School	No	Elementary	PK	5	2018	grade_7	0.0	0
2781477	HI	school	1500030	1	Hawaii Department of Education	150003000086	456	Kauai High		Regular School	No	High	09	12	2018	grade_7	0.0	0
2781476	HI	school	1500030	1	Hawaii Department of Education	150003000255	447	Kapaa Middle		Regular School	No	Middle	06	8	2018	grade_7	176.0	176
2781475	HI	school	1500030	1	Hawaii Department of Education	150003000085	455	Kapaa High		Regular School	No	High	09	12	2018	grade_7	0.0	0
2781474	HI	school	1500030	1	Hawaii Department of Education	150003000084	454	Kapaa Elem		Regular School	No	Elementary	PK	5	2018	grade_7	0.0	0
2781473	HI	school	1500030	1	Hawaii Department of Education	150003000266	448	Kamakahelei Middle		Regular School	No	Middle	06	8	2018	grade_7	309.0	309
2781472	HI	school	1500030	1	Hawaii Department of Education	150003000083	453	Kalaheo Elem		Regular School	No	Elementary	PK	5	2018	grade_7	0.0	0
2781471	HI	school	1500030	1	Hawaii Department of Education	150003000082	452	Hanalei Elem		Regular School	No	Elementary	PK	6	2018	grade_7	0.0	0
2781470	HI	school	1500030	1	Hawaii Department of Education	150003000081	451	Eleele Elem		Regular School	No	Elementary	PK	5	2018	grade_7	0.0	0
2781469	HI	school	1500030	1	Hawaii Department of Education	150003000237	429	Nahienaena Elem		Regular School	No	Elementary	PK	5	2018	grade_7	0.0	0
2781468	HI	school	1500030	1	Hawaii Department of Education	150003000290	434	Molokai Middle		Regular School	No	Middle	07	8	2018	grade_7	89.0	89
2781467	HI	school	1500030	1	Hawaii Department of Education	150003000075	421	Molokai High		Regular School	No	High	09	12	2018	grade_7	0.0	0
2781466	HI	school	1500030	1	Hawaii Department of Education	150003000074	419	Maunaloa Elem		Regular School	No	Elementary	PK	6	2018	grade_7	0.0	0
2781465	HI	school	1500030	1	Hawaii Department of Education	150003000070	415	Lanai High & Elem		Regular School	No	Other	PK	12	2018	grade_7	43.0	43
2781464	HI	school	1500030	1	Hawaii Department of Education	150003000069	414	Lahainaluna High		Regular School	No	High	09	12	2018	grade_7	0.0	0
2781463	HI	school	1500030	1	Hawaii Department of Education	150003000068	413	Lahaina Int		Regular School	No	Middle	06	8	2018	grade_7	232.0	232
2781462	HI	school	1500030	1	Hawaii Department of Education	150003000065	410	Kilohana Elem		Regular School	No	Elementary	PK	6	2018	grade_7	0.0	0
2781461	HI	school	1500030	1	Hawaii Department of Education	150003000062	407	Kaunakakai Elem		Regular School	No	Elementary	PK	6	2018	grade_7	0.0	0
2781460	HI	school	1500030	1	Hawaii Department of Education	150003000061	406	Kamehameha III Elem		Regular School	No	Elementary	PK	5	2018	grade_7	0.0	0
2781459	HI	school	1500030	1	Hawaii Department of Education	150003000058	402	Hana High & Elem		Regular School	No	Other	PK	12	2018	grade_7	21.0	21
2781458	HI	school	1500030	1	Hawaii Department of Education	150003000080	425	Wailuku Elem		Regular School	No	Elementary	PK	5	2018	grade_7	0.0	0
2781457	HI	school	1500030	1	Hawaii Department of Education	150003000079	424	Waihee Elem		Regular School	No	Elementary	PK	5	2018	grade_7	0.0	0
2781456	HI	school	1500030	1	Hawaii Department of Education	150003000297	436	Puu Kukui Elem		Regular School	No	Elementary	PK	5	2018	grade_7	0.0	0
2781455	HI	school	1500030	1	Hawaii Department of Education	150003000077	426	Pukalani Elem		Regular School	No	Elementary	PK	5	2018	grade_7	0.0	0
2781454	HI	school	1500030	1	Hawaii Department of Education	150003000292	433	Pomaikai Elem		Regular School	No	Elementary	PK	5	2018	grade_7	0.0	0
2781453	HI	school	1500030	1	Hawaii Department of Education	150003000076	422	Paia Elem		Regular School	No	Elementary	PK	5	2018	grade_7	0.0	0
2781452	HI	school	1500030	1	Hawaii Department of Education	150003000241	428	Maui Waena Int		Regular School	No	Middle	06	8	2018	grade_7	367.0	367
2781451	HI	school	1500030	1	Hawaii Department of Education	150003000073	418	Maui High		Regular School	No	High	09	12	2018	grade_7	0.0	0
2781450	HI	school	1500030	1	Hawaii Department of Education	150003000072	417	Makawao Elem		Regular School	No	Elementary	PK	5	2018	grade_7	0.0	0
2781449	HI	school	1500030	1	Hawaii Department of Education	150003000238	430	Lokelani Int		Regular School	No	Middle	06	8	2018	grade_7	163.0	163
2781448	HI	school	1500030	1	Hawaii Department of Education	150003000071	416	Lihikai Elem		Regular School	No	Elementary	PK	5	2018	grade_7	0.0	0
2781447	HI	school	1500030	1	Hawaii Department of Education	150003000067	412	Kula Elem		Regular School	No	Elementary	PK	5	2018	grade_7	0.0	0
2781446	HI	school	1500030	1	Hawaii Department of Education	150003000064	409	Kihei Elem		Regular School	No	Elementary	PK	5	2018	grade_7	0.0	0
2781445	HI	school	1500030	1	Hawaii Department of Education	150003000251	435	Kekaulike High		Regular School	No	High	09	12	2018	grade_7	0.0	0
2781444	HI	school	1500030	1	Hawaii Department of Education	150003000253	431	Kamalii Elem		Regular School	No	Elementary	PK	5	2018	grade_7	0.0	0
2781443	HI	school	1500030	1	Hawaii Department of Education	150003000233	420	Kalama Int		Regular School	No	Middle	06	8	2018	grade_7	238.0	238
2781442	HI	school	1500030	1	Hawaii Department of Education	150003000060	405	Kahului Elem		Regular School	No	Elementary	PK	5	2018	grade_7	0.0	0
2781441	HI	school	1500030	1	Hawaii Department of Education	150003000059	404	Iao Int		Regular School	No	Middle	06	8	2018	grade_7	273.0	273
2781440	HI	school	1500030	1	Hawaii Department of Education	150003000057	401	Haiku Elem		Regular School	No	Elementary	PK	5	2018	grade_7	0.0	0
2781439	HI	school	1500030	1	Hawaii Department of Education	150003000056	400	Baldwin High		Regular School	No	High	09	12	2018	grade_7	0.0	0
2781438	HI	school	1500030	1	Hawaii Department of Education	150003000050	383	Pahoa High & Int		Regular School	No	High	07	12	2018	grade_7	104.0	104
2781437	HI	school	1500030	1	Hawaii Department of Education	150003000234	381	Pahoa Elem		Regular School	No	Elementary	PK	6	2018	grade_7	0.0	0
2781436	HI	school	1500030	1	Hawaii Department of Education	150003000048	380	Naalehu Elem		Regular School	No	Elementary	PK	6	2018	grade_7	0.0	0
2781435	HI	school	1500030	1	Hawaii Department of Education	150003000047	379	Mountain View Elem		Regular School	No	Elementary	PK	5	2018	grade_7	0.0	0
2781434	HI	school	1500030	1	Hawaii Department of Education	150003000244	391	Keonepoko Elem		Regular School	No	Elementary	PK	6	2018	grade_7	0.0	0
2781433	HI	school	1500030	1	Hawaii Department of Education	150003000040	370	Keaau Middle		Regular School	No	Middle	06	8	2018	grade_7	189.0	189
2781432	HI	school	1500030	1	Hawaii Department of Education	150003000260	354	Keaau High		Regular School	No	High	09	12	2018	grade_7	0.0	0
2781431	HI	school	1500030	1	Hawaii Department of Education	150003000258	353	Keaau Elem		Regular School	No	Elementary	PK	5	2018	grade_7	0.0	0
2781430	HI	school	1500030	1	Hawaii Department of Education	150003000038	368	Kau High & Pahala Elem		Regular School	No	Other	PK	12	2018	grade_7	71.0	71
2781429	HI	school	1500030	1	Hawaii Department of Education	150003000055	387	Waimea Elem		Regular School	No	Elementary	PK	5	2018	grade_7	0.0	0
2781428	HI	school	1500030	1	Hawaii Department of Education	150003000247	393	Waikoloa El & Middle		Regular School	No	Elementary	PK	8	2018	grade_7	69.0	69
2781427	HI	school	1500030	1	Hawaii Department of Education	150003000049	382	Paauilo El & Int		Regular School	No	Other	PK	9	2018	grade_7	14.0	14
2781426	HI	school	1500030	1	Hawaii Department of Education	150003000252	376	Konawaena Middle		Regular School	No	Middle	06	8	2018	grade_7	190.0	190
2781425	HI	school	1500030	1	Hawaii Department of Education	150003000045	374	Konawaena High		Regular School	No	High	09	12	2018	grade_7	0.0	0
2781424	HI	school	1500030	1	Hawaii Department of Education	150003000044	375	Konawaena Elem		Regular School	No	Elementary	PK	5	2018	grade_7	0.0	0
2781423	HI	school	1500030	1	Hawaii Department of Education	150003000267	366	Kohala Middle		Regular School	No	Middle	06	8	2018	grade_7	49.0	49
2781422	HI	school	1500030	1	Hawaii Department of Education	150003000043	373	Kohala High		Regular School	No	High	09	12	2018	grade_7	0.0	0
2781421	HI	school	1500030	1	Hawaii Department of Education	150003000250	395	Kohala Elem		Regular School	No	Elementary	PK	5	2018	grade_7	0.0	0