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 "year" = :p2 order by ccd_school_high_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
2429658	HI	school	1500030	1	Hawaii Department of Education	150003000198	133	Linapuni Elem		Regular School	No	Elementary	PK	1	2020	grade_4	0.0	0
2429902	HI	school	1500030	1	Hawaii Department of Education	150003000283	562	Ka Umeke Kaeo PCS	charter	Regular School	Yes	Other	PK	11	2020	grade_4	26.0	26
2429910	HI	school	1500030	1	Hawaii Department of Education	150003000302	555	Kapolei Charter School	charter	Regular School	Yes	Secondary	09	11	2020	grade_4	0.0	0
2429640	HI	school	1500030	1	Hawaii Department of Education	150003000221	106	Farrington High		Regular School	No	High	09	12	2020	grade_4	0.0	0
2429643	HI	school	1500030	1	Hawaii Department of Education	150003000096	470	Hawaii School for the Deaf and Blind		Special Education School	No	Other	PK	12	2020	grade_4	0.0	0
2429647	HI	school	1500030	1	Hawaii Department of Education	150003000228	154	Kaiser High		Regular School	No	High	09	12	2020	grade_4	0.0	0
2429649	HI	school	1500030	1	Hawaii Department of Education	150003000163	119	Kalani High		Regular School	No	High	09	12	2020	grade_4	0.0	0
2429665	HI	school	1500030	1	Hawaii Department of Education	150003000246	103	Anuenue		Regular School	No	Other	PK	12	2020	grade_4	51.0	51
2429671	HI	school	1500030	1	Hawaii Department of Education	150003000212	115	Kaimuki High		Regular School	No	High	09	12	2020	grade_4	0.0	0
2429682	HI	school	1500030	1	Hawaii Department of Education	150003000193	138	McKinley High		Regular School	No	High	09	12	2020	grade_4	0.0	0
2429687	HI	school	1500030	1	Hawaii Department of Education	150003000186	146	Roosevelt High		Regular School	No	High	09	12	2020	grade_4	0.0	0
2429692	HI	school	1500030	1	Hawaii Department of Education	150003000177	202	Aiea High		Regular School	No	High	09	12	2020	grade_4	0.0	0
2429699	HI	school	1500030	1	Hawaii Department of Education	150003000103	218	Moanalua High		Regular School	No	High	09	12	2020	grade_4	0.0	0
2429706	HI	school	1500030	1	Hawaii Department of Education	150003000150	224	Radford High		Regular School	No	High	09	12	2020	grade_4	0.0	0
2429719	HI	school	1500030	1	Hawaii Department of Education	150003000108	214	Leilehua High		Regular School	No	High	09	12	2020	grade_4	0.0	0
2429720	HI	school	1500030	1	Hawaii Department of Education	150003000102	216	Mililani High		Regular School	No	High	09	12	2020	grade_4	0.0	0
2429730	HI	school	1500030	1	Hawaii Department of Education	150003000141	232	Waialua High & Int		Regular School	No	High	07	12	2020	grade_4	0.0	0
2429734	HI	school	1500030	1	Hawaii Department of Education	150003000134	252	Campbell High		Regular School	No	High	09	12	2020	grade_4	0.0	0
2429744	HI	school	1500030	1	Hawaii Department of Education	150003000261	292	Kapolei High		Regular School	No	High	09	12	2020	grade_4	0.0	0
2429755	HI	school	1500030	1	Hawaii Department of Education	150003000117	263	Nanakuli High & Int		Regular School	No	High	07	12	2020	grade_4	0.0	0
2429757	HI	school	1500030	1	Hawaii Department of Education	150003000110	272	Waianae High		Regular School	No	High	09	12	2020	grade_4	0.0	0
2429769	HI	school	1500030	1	Hawaii Department of Education	150003000114	266	Pearl City High		Regular School	No	High	09	12	2020	grade_4	0.0	0
2429774	HI	school	1500030	1	Hawaii Department of Education	150003000161	277	Waipahu High		Regular School	No	High	09	12	2020	grade_4	0.0	0
2429777	HI	school	1500030	1	Hawaii Department of Education	150003000100	301	Castle High		Regular School	No	High	09	12	2020	grade_4	0.0	0
2429783	HI	school	1500030	1	Hawaii Department of Education	150003000007	307	Kahuku High & Int		Regular School	No	High	07	12	2020	grade_4	0.0	0
2429796	HI	school	1500030	1	Hawaii Department of Education	150003000009	309	Kailua High		Regular School	No	High	09	12	2020	grade_4	0.0	0
2429799	HI	school	1500030	1	Hawaii Department of Education	150003000012	312	Kalaheo High		Regular School	No	High	09	12	2020	grade_4	0.0	0
2429803	HI	school	1500030	1	Hawaii Department of Education	150003000098	475	Olomana		Alternative School	No	High	07	12	2020	grade_4	0.0	0
2429808	HI	school	1500030	1	Hawaii Department of Education	150003000029	355	Hilo High		Regular School	No	High	09	12	2020	grade_4	0.0	0
2429816	HI	school	1500030	1	Hawaii Department of Education	150003000052	389	Waiakea High		Regular School	No	High	09	12	2020	grade_4	0.0	0
2429822	HI	school	1500030	1	Hawaii Department of Education	150003000034	360	Honokaa High & Int		Regular School	No	High	07	12	2020	grade_4	0.0	0
2429825	HI	school	1500030	1	Hawaii Department of Education	150003000287	378	Ke Kula o Ehunuikaimalino		Regular School	No	Other	PK	12	2020	grade_4	24.0	24
2429827	HI	school	1500030	1	Hawaii Department of Education	150003000254	392	Kealakehe High		Regular School	No	High	09	12	2020	grade_4	0.0	0
2429830	HI	school	1500030	1	Hawaii Department of Education	150003000043	373	Kohala High		Regular School	No	High	09	12	2020	grade_4	0.0	0
2429833	HI	school	1500030	1	Hawaii Department of Education	150003000045	374	Konawaena High		Regular School	No	High	09	12	2020	grade_4	0.0	0
2429838	HI	school	1500030	1	Hawaii Department of Education	150003000038	368	Kau High & Pahala Elem		Regular School	No	Other	PK	12	2020	grade_4	15.0	15
2429840	HI	school	1500030	1	Hawaii Department of Education	150003000260	354	Keaau High		Regular School	No	High	09	12	2020	grade_4	0.0	0
2429846	HI	school	1500030	1	Hawaii Department of Education	150003000050	383	Pahoa High & Int		Regular School	No	High	07	12	2020	grade_4	0.0	0
2429847	HI	school	1500030	1	Hawaii Department of Education	150003000056	400	Baldwin High		Regular School	No	High	09	12	2020	grade_4	0.0	0
2429853	HI	school	1500030	1	Hawaii Department of Education	150003000251	435	Kekaulike High		Regular School	No	High	09	12	2020	grade_4	0.0	0
2429859	HI	school	1500030	1	Hawaii Department of Education	150003000073	418	Maui High		Regular School	No	High	09	12	2020	grade_4	0.0	0
2429867	HI	school	1500030	1	Hawaii Department of Education	150003000058	402	Hana High & Elem		Regular School	No	Other	PK	12	2020	grade_4	28.0	28
2429872	HI	school	1500030	1	Hawaii Department of Education	150003000069	414	Lahainaluna High		Regular School	No	High	09	12	2020	grade_4	0.0	0
2429873	HI	school	1500030	1	Hawaii Department of Education	150003000070	415	Lanai High & Elem		Regular School	No	Other	PK	12	2020	grade_4	45.0	45
2429875	HI	school	1500030	1	Hawaii Department of Education	150003000075	421	Molokai High		Regular School	No	High	09	12	2020	grade_4	0.0	0
2429883	HI	school	1500030	1	Hawaii Department of Education	150003000085	455	Kapaa High		Regular School	No	High	09	12	2020	grade_4	0.0	0
2429885	HI	school	1500030	1	Hawaii Department of Education	150003000086	456	Kauai High		Regular School	No	High	09	12	2020	grade_4	0.0	0
2429890	HI	school	1500030	1	Hawaii Department of Education	150003000091	461	Niihau High & Elem		Regular School	No	Other	PK	12	2020	grade_4	2.0	2
2429892	HI	school	1500030	1	Hawaii Department of Education	150003000093	462	Waimea High		Regular School	No	High	09	12	2020	grade_4	0.0	0
2429895	HI	school	1500030	1	Hawaii Department of Education	150003000262	396	Connections NCPCS	charter	Regular School	Yes	Other	KG	12	2020	grade_4	23.0	23
2429897	HI	school	1500030	1	Hawaii Department of Education	150003000275	546	Hakipuu Learning Ctr PCS	charter	Regular School	Yes	Other	04	12	2020	grade_4	2.0	2
2429898	HI	school	1500030	1	Hawaii Department of Education	150003000270	540	Halau Ku Mana NCPCS	charter	Regular School	Yes	Other	04	12	2020	grade_4	5.0	5
2429899	HI	school	1500030	1	Hawaii Department of Education	150003000282	561	Hawaii Academy of Arts & Science PCS	charter	Regular School	Yes	Other	KG	12	2020	grade_4	37.0	37
2429900	HI	school	1500030	1	Hawaii Department of Education	150003000295	551	Hawaii Tech Acad PCS	charter	Regular School	Yes	Other	KG	12	2020	grade_4	50.0	50
2429904	HI	school	1500030	1	Hawaii Department of Education	150003000240	275	Kamaile Academy PCS	charter	Regular School	Yes	Other	PK	12	2020	grade_4	68.0	68
2429906	HI	school	1500030	1	Hawaii Department of Education	150003000269	466	Kanaka PCS	charter	Regular School	Yes	Other	PK	12	2020	grade_4	2.0	2
2429907	HI	school	1500030	1	Hawaii Department of Education	150003000263	397	Kanu O Ka Aina NCPCS	charter	Regular School	Yes	Other	KG	12	2020	grade_4	42.0	42
2429908	HI	school	1500030	1	Hawaii Department of Education	150003000289	564	Kanuikapono PCS	charter	Regular School	Yes	Other	KG	12	2020	grade_4	19.0	19
2429911	HI	school	1500030	1	Hawaii Department of Education	150003000294	565	Kawaikini NCPCS	charter	Regular School	Yes	Other	KG	12	2020	grade_4	16.0	16
2429912	HI	school	1500030	1	Hawaii Department of Education	150003000278	549	Ke Ana Laahana PCS	charter	Regular School	Yes	High	07	12	2020	grade_4	0.0	0
2429914	HI	school	1500030	1	Hawaii Department of Education	150003000276	547	Ke Kula O Kamakau Lab PCS	charter	Regular School	Yes	Other	PK	12	2020	grade_4	8.0	8
2429915	HI	school	1500030	1	Hawaii Department of Education	150003000280	556	Ke Kula O Niihau Kekaha LPCS	charter	Regular School	Yes	Other	PK	12	2020	grade_4	5.0	5
2429916	HI	school	1500030	1	Hawaii Department of Education	150003000279	554	Kihei Charter School	charter	Regular School	Yes	Other	KG	12	2020	grade_4	41.0	41
2429918	HI	school	1500030	1	Hawaii Department of Education	150003000288	557	Kua O Ka La PCS	charter	Regular School	Yes	Other	PK	12	2020	grade_4	21.0	21
2429920	HI	school	1500030	1	Hawaii Department of Education	150003000046	377	Laupahoehoe Community PCS	charter	Regular School	Yes	Other	PK	12	2020	grade_4	32.0	32
2429922	HI	school	1500030	1	Hawaii Department of Education	150003000274	544	Myron Thompson Acad NCPCS	charter	Regular School	Yes	Other	KG	12	2020	grade_4	61.0	61
2429925	HI	school	1500030	1	Hawaii Department of Education	150003000273	543	University Laboratory School	charter	Regular School	Yes	Other	KG	12	2020	grade_4	9.0	9
2429930	HI	school	1500030	1	Hawaii Department of Education	150003000265	399	West Hawaii Explorations PCS	charter	Regular School	Yes	High	06	12	2020	grade_4	0.0	0
2429638	HI	school	1500030	1	Hawaii Department of Education	150003000227	100	Aina Haina Elem		Regular School	No	Elementary	PK	5	2020	grade_4	72.0	72
2429641	HI	school	1500030	1	Hawaii Department of Education	150003000220	107	Fern Elem		Regular School	No	Elementary	PK	5	2020	grade_4	81.0	81
2429642	HI	school	1500030	1	Hawaii Department of Education	150003000219	108	Hahaione Elem		Regular School	No	Elementary	PK	5	2020	grade_4	85.0	85
2429644	HI	school	1500030	1	Hawaii Department of Education	150003000216	113	Kaewai Elem		Regular School	No	Elementary	PK	5	2020	grade_4	55.0	55
2429645	HI	school	1500030	1	Hawaii Department of Education	150003000215	114	Kahala Elem		Regular School	No	Elementary	PK	5	2020	grade_4	70.0	70
2429650	HI	school	1500030	1	Hawaii Department of Education	150003000162	120	Kalihi Elem		Regular School	No	Elementary	PK	5	2020	grade_4	40.0	40
2429651	HI	school	1500030	1	Hawaii Department of Education	150003000160	121	Kalihi Kai Elem		Regular School	No	Elementary	PK	5	2020	grade_4	92.0	92
2429652	HI	school	1500030	1	Hawaii Department of Education	150003000210	122	Kalihi Uka Elem		Regular School	No	Elementary	PK	5	2020	grade_4	43.0	43
2429653	HI	school	1500030	1	Hawaii Department of Education	150003000209	123	Kalihi Waena Elem		Regular School	No	Elementary	PK	5	2020	grade_4	98.0	98
2429654	HI	school	1500030	1	Hawaii Department of Education	150003000208	155	Kamiloiki Elem		Regular School	No	Elementary	PK	5	2020	grade_4	59.0	59
2429655	HI	school	1500030	1	Hawaii Department of Education	150003000207	124	Kapalama Elem		Regular School	No	Elementary	PK	5	2020	grade_4	103.0	103
2429656	HI	school	1500030	1	Hawaii Department of Education	150003000204	127	Koko Head Elem		Regular School	No	Elementary	PK	5	2020	grade_4	55.0	55
2429657	HI	school	1500030	1	Hawaii Department of Education	150003000201	130	Liholiho Elem		Regular School	No	Elementary	PK	5	2020	grade_4	80.0	80
2429660	HI	school	1500030	1	Hawaii Department of Education	150003000187	145	Puuhale Elem		Regular School	No	Elementary	PK	5	2020	grade_4	35.0	35
2429661	HI	school	1500030	1	Hawaii Department of Education	150003000182	150	Waikiki Elem		Regular School	No	Elementary	PK	5	2020	grade_4	92.0	92
2429662	HI	school	1500030	1	Hawaii Department of Education	150003000179	153	Wilson Elem		Regular School	No	Elementary	PK	5	2020	grade_4	86.0	86
2429663	HI	school	1500030	1	Hawaii Department of Education	150003000226	101	Ala Wai Elem		Regular School	No	Elementary	PK	5	2020	grade_4	50.0	50
2429664	HI	school	1500030	1	Hawaii Department of Education	150003000225	102	Aliiolani Elem		Regular School	No	Elementary	PK	5	2020	grade_4	43.0	43
2429667	HI	school	1500030	1	Hawaii Department of Education	150003000214	109	Hokulani Elem		Regular School	No	Elementary	PK	5	2020	grade_4	56.0	56
2429669	HI	school	1500030	1	Hawaii Department of Education	150003000213	111	Jefferson Elem		Regular School	No	Elementary	PK	5	2020	grade_4	60.0	60
2429670	HI	school	1500030	1	Hawaii Department of Education	150003000217	112	Kaahumanu Elem		Regular School	No	Elementary	PK	5	2020	grade_4	92.0	92
2429672	HI	school	1500030	1	Hawaii Department of Education	150003000165	117	Kaiulani Elem		Regular School	No	Elementary	PK	5	2020	grade_4	54.0	54
2429673	HI	school	1500030	1	Hawaii Department of Education	150003000206	125	Kauluwela Elem		Regular School	No	Elementary	PK	5	2020	grade_4	63.0	63
2429675	HI	school	1500030	1	Hawaii Department of Education	150003000203	128	Kuhio Elem		Regular School	No	Elementary	PK	5	2020	grade_4	29.0	29
2429676	HI	school	1500030	1	Hawaii Department of Education	150003000202	129	Lanakila Elem		Regular School	No	Elementary	PK	5	2020	grade_4	63.0	63
2429677	HI	school	1500030	1	Hawaii Department of Education	150003000200	131	Likelike Elem		Regular School	No	Elementary	PK	5	2020	grade_4	51.0	51
2429678	HI	school	1500030	1	Hawaii Department of Education	150003000197	134	Lincoln Elem		Regular School	No	Elementary	PK	5	2020	grade_4	39.0	39
2429679	HI	school	1500030	1	Hawaii Department of Education	150003000195	135	Lunalilo Elem		Regular School	No	Elementary	PK	5	2020	grade_4	61.0	61
2429681	HI	school	1500030	1	Hawaii Department of Education	150003000194	137	Manoa Elem		Regular School	No	Elementary	PK	5	2020	grade_4	90.0	90
2429683	HI	school	1500030	1	Hawaii Department of Education	150003000191	140	Noelani Elem		Regular School	No	Elementary	PK	5	2020	grade_4	68.0	68
2429684	HI	school	1500030	1	Hawaii Department of Education	150003000190	141	Nuuanu Elem		Regular School	No	Elementary	PK	5	2020	grade_4	60.0	60
2429685	HI	school	1500030	1	Hawaii Department of Education	150003000189	142	Palolo Elem		Regular School	No	Elementary	PK	5	2020	grade_4	45.0	45
2429686	HI	school	1500030	1	Hawaii Department of Education	150003000188	143	Pauoa Elem		Regular School	No	Elementary	PK	5	2020	grade_4	46.0	46