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 rowid desc 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
2431102	HI	school	1500030	1	Hawaii Department of Education	150003000265	399	West Hawaii Explorations PCS	charter	Regular School	Yes	High	06	12	2020	grade_8	38.0	38
2431101	HI	school	1500030	1	Hawaii Department of Education	150003000268	394	Waimea Middle PCCS	charter	Regular School	Yes	Middle	06	8	2020	grade_8	73.0	73
2431100	HI	school	1500030	1	Hawaii Department of Education	150003000183	149	Waialae Elem PCS	charter	Regular School	Yes	Elementary	PK	5	2020	grade_8	0.0	0
2431099	HI	school	1500030	1	Hawaii Department of Education	150003000271	541	Voyager PCS	charter	Regular School	Yes	Elementary	KG	8	2020	grade_8	22.0	22
2431098	HI	school	1500030	1	Hawaii Department of Education	150003000281	560	Volcano of Arts & Sci	charter	Regular School	Yes	Elementary	PK	8	2020	grade_8	23.0	23
2431097	HI	school	1500030	1	Hawaii Department of Education	150003000273	543	University Laboratory School	charter	Regular School	Yes	Other	KG	12	2020	grade_8	54.0	54
2431096	HI	school	1500030	1	Hawaii Department of Education	150003000298	567	SEEQS PCS	charter	Regular School	Yes	Middle	06	8	2020	grade_8	56.0	56
2431095	HI	school	1500030	1	Hawaii Department of Education	150003000264	398	Na Wai Ola NCPCS	charter	Regular School	Yes	Elementary	PK	6	2020	grade_8	0.0	0
2431094	HI	school	1500030	1	Hawaii Department of Education	150003000274	544	Myron Thompson Acad NCPCS	charter	Regular School	Yes	Other	KG	12	2020	grade_8	33.0	33
2431093	HI	school	1500030	1	Hawaii Department of Education	150003000299	550	Malama Honua	charter	Regular School	Yes	Elementary	KG	7	2020	grade_8	0.0	0
2431092	HI	school	1500030	1	Hawaii Department of Education	150003000046	377	Laupahoehoe Community PCS	charter	Regular School	Yes	Other	PK	12	2020	grade_8	21.0	21
2431091	HI	school	1500030	1	Hawaii Department of Education	150003000066	411	Kualapuu El NCPCCS	charter	Regular School	Yes	Elementary	PK	6	2020	grade_8	0.0	0
2431090	HI	school	1500030	1	Hawaii Department of Education	150003000288	557	Kua O Ka La PCS	charter	Regular School	Yes	Other	PK	12	2020	grade_8	16.0	16
2431089	HI	school	1500030	1	Hawaii Department of Education	150003000293	566	Kona Pacific PCS	charter	Regular School	Yes	Elementary	KG	8	2020	grade_8	11.0	11
2431088	HI	school	1500030	1	Hawaii Department of Education	150003000279	554	Kihei Charter School	charter	Regular School	Yes	Other	KG	12	2020	grade_8	62.0	62
2431087	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_8	3.0	3
2431086	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_8	5.0	5
2431085	HI	school	1500030	1	Hawaii Department of Education	150003000284	563	Ke Kula Nawahiokalaniopuu Iki Lab PCS	charter	Regular School	Yes	Elementary	PK	8	2020	grade_8	51.0	51
2431084	HI	school	1500030	1	Hawaii Department of Education	150003000278	549	Ke Ana Laahana PCS	charter	Regular School	Yes	High	07	12	2020	grade_8	7.0	7
2431083	HI	school	1500030	1	Hawaii Department of Education	150003000294	565	Kawaikini NCPCS	charter	Regular School	Yes	Other	KG	12	2020	grade_8	11.0	11
2431082	HI	school	1500030	1	Hawaii Department of Education	150003000302	555	Kapolei Charter School	charter	Regular School	Yes	Secondary	09	11	2020	grade_8	0.0	0
2431081	HI	school	1500030	1	Hawaii Department of Education	150003000018	320	Kaohao PCS	charter	Regular School	Yes	Elementary	PK	6	2020	grade_8	0.0	0
2431080	HI	school	1500030	1	Hawaii Department of Education	150003000289	564	Kanuikapono PCS	charter	Regular School	Yes	Other	KG	12	2020	grade_8	15.0	15
2431079	HI	school	1500030	1	Hawaii Department of Education	150003000263	397	Kanu O Ka Aina NCPCS	charter	Regular School	Yes	Other	KG	12	2020	grade_8	35.0	35
2431078	HI	school	1500030	1	Hawaii Department of Education	150003000269	466	Kanaka PCS	charter	Regular School	Yes	Other	PK	12	2020	grade_8	3.0	3
2431077	HI	school	1500030	1	Hawaii Department of Education	150003000303	553	Kamalani Academy	charter	Regular School	Yes	Elementary	PK	8	2020	grade_8	27.0	27
2431076	HI	school	1500030	1	Hawaii Department of Education	150003000240	275	Kamaile Academy PCS	charter	Regular School	Yes	Other	PK	12	2020	grade_8	44.0	44
2431075	HI	school	1500030	1	Hawaii Department of Education	150003000286	545	Ka Waihona o ka Naauao NCPCS	charter	Regular School	Yes	Elementary	KG	8	2020	grade_8	66.0	66
2431074	HI	school	1500030	1	Hawaii Department of Education	150003000283	562	Ka Umeke Kaeo PCS	charter	Regular School	Yes	Other	PK	11	2020	grade_8	8.0	8
2431073	HI	school	1500030	1	Hawaii Department of Education	150003000277	548	Innovations PCS	charter	Regular School	Yes	Elementary	KG	8	2020	grade_8	31.0	31
2431072	HI	school	1500030	1	Hawaii Department of Education	150003000295	551	Hawaii Tech Acad PCS	charter	Regular School	Yes	Other	KG	12	2020	grade_8	141.0	141
2431071	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_8	67.0	67
2431070	HI	school	1500030	1	Hawaii Department of Education	150003000270	540	Halau Ku Mana NCPCS	charter	Regular School	Yes	Other	04	12	2020	grade_8	13.0	13
2431069	HI	school	1500030	1	Hawaii Department of Education	150003000275	546	Hakipuu Learning Ctr PCS	charter	Regular School	Yes	Other	04	12	2020	grade_8	9.0	9
2431068	HI	school	1500030	1	Hawaii Department of Education	150003000305	568	DreamHouse Ewa Beach	charter	Regular School	Yes	Middle	06	6	2020	grade_8	0.0	0
2431067	HI	school	1500030	1	Hawaii Department of Education	150003000262	396	Connections NCPCS	charter	Regular School	Yes	Other	KG	12	2020	grade_8	27.0	27
2431066	HI	school	1500030	1	Hawaii Department of Education	150003000304	558	Alakai O Kauai PCS	charter	Regular School	Yes	Elementary	KG	6	2020	grade_8	0.0	0
2431065	HI	school	1500030	1	Hawaii Department of Education	150003000094	463	Wilcox Elem		Regular School	No	Elementary	PK	5	2020	grade_8	0.0	0
2431064	HI	school	1500030	1	Hawaii Department of Education	150003000093	462	Waimea High		Regular School	No	High	09	12	2020	grade_8	0.0	0
2431063	HI	school	1500030	1	Hawaii Department of Education	150003000092	464	Waimea Canyon Middle		Regular School	No	Middle	06	8	2020	grade_8	139.0	139
2431062	HI	school	1500030	1	Hawaii Department of Education	150003000091	461	Niihau High & Elem		Regular School	No	Other	PK	12	2020	grade_8	2.0	2
2431061	HI	school	1500030	1	Hawaii Department of Education	150003000090	460	Koloa Elem		Regular School	No	Elementary	PK	5	2020	grade_8	0.0	0
2431060	HI	school	1500030	1	Hawaii Department of Education	150003000089	459	Kilauea Elem		Regular School	No	Elementary	PK	6	2020	grade_8	0.0	0
2431059	HI	school	1500030	1	Hawaii Department of Education	150003000088	458	Kekaha Elem		Regular School	No	Elementary	PK	5	2020	grade_8	0.0	0
2431058	HI	school	1500030	1	Hawaii Department of Education	150003000242	457	Kaumualii Elem		Regular School	No	Elementary	PK	5	2020	grade_8	0.0	0
2431057	HI	school	1500030	1	Hawaii Department of Education	150003000086	456	Kauai High		Regular School	No	High	09	12	2020	grade_8	0.0	0
2431056	HI	school	1500030	1	Hawaii Department of Education	150003000255	447	Kapaa Middle		Regular School	No	Middle	06	8	2020	grade_8	211.0	211
2431055	HI	school	1500030	1	Hawaii Department of Education	150003000085	455	Kapaa High		Regular School	No	High	09	12	2020	grade_8	0.0	0
2431054	HI	school	1500030	1	Hawaii Department of Education	150003000084	454	Kapaa Elem		Regular School	No	Elementary	PK	5	2020	grade_8	0.0	0
2431053	HI	school	1500030	1	Hawaii Department of Education	150003000266	448	Kamakahelei Middle		Regular School	No	Middle	06	8	2020	grade_8	291.0	291
2431052	HI	school	1500030	1	Hawaii Department of Education	150003000083	453	Kalaheo Elem		Regular School	No	Elementary	PK	5	2020	grade_8	0.0	0
2431051	HI	school	1500030	1	Hawaii Department of Education	150003000082	452	Hanalei Elem		Regular School	No	Elementary	PK	6	2020	grade_8	0.0	0
2431050	HI	school	1500030	1	Hawaii Department of Education	150003000081	451	Eleele Elem		Regular School	No	Elementary	PK	5	2020	grade_8	0.0	0
2431049	HI	school	1500030	1	Hawaii Department of Education	150003000237	429	Nahienaena Elem		Regular School	No	Elementary	PK	5	2020	grade_8	0.0	0
2431048	HI	school	1500030	1	Hawaii Department of Education	150003000290	434	Molokai Middle		Regular School	No	Middle	07	8	2020	grade_8	78.0	78
2431047	HI	school	1500030	1	Hawaii Department of Education	150003000075	421	Molokai High		Regular School	No	High	09	12	2020	grade_8	0.0	0
2431046	HI	school	1500030	1	Hawaii Department of Education	150003000074	419	Maunaloa Elem		Regular School	No	Elementary	PK	6	2020	grade_8	0.0	0
2431045	HI	school	1500030	1	Hawaii Department of Education	150003000070	415	Lanai High & Elem		Regular School	No	Other	PK	12	2020	grade_8	36.0	36
2431044	HI	school	1500030	1	Hawaii Department of Education	150003000069	414	Lahainaluna High		Regular School	No	High	09	12	2020	grade_8	0.0	0
2431043	HI	school	1500030	1	Hawaii Department of Education	150003000068	413	Lahaina Int		Regular School	No	Middle	06	8	2020	grade_8	247.0	247
2431042	HI	school	1500030	1	Hawaii Department of Education	150003000065	410	Kilohana Elem		Regular School	No	Elementary	PK	6	2020	grade_8	0.0	0
2431041	HI	school	1500030	1	Hawaii Department of Education	150003000062	407	Kaunakakai Elem		Regular School	No	Elementary	PK	6	2020	grade_8	0.0	0
2431040	HI	school	1500030	1	Hawaii Department of Education	150003000061	406	Kamehameha III Elem		Regular School	No	Elementary	PK	5	2020	grade_8	0.0	0
2431039	HI	school	1500030	1	Hawaii Department of Education	150003000058	402	Hana High & Elem		Regular School	No	Other	PK	12	2020	grade_8	34.0	34
2431038	HI	school	1500030	1	Hawaii Department of Education	150003000080	425	Wailuku Elem		Regular School	No	Elementary	PK	5	2020	grade_8	0.0	0
2431037	HI	school	1500030	1	Hawaii Department of Education	150003000079	424	Waihee Elem		Regular School	No	Elementary	PK	5	2020	grade_8	0.0	0
2431036	HI	school	1500030	1	Hawaii Department of Education	150003000297	436	Puu Kukui Elem		Regular School	No	Elementary	PK	5	2020	grade_8	0.0	0
2431035	HI	school	1500030	1	Hawaii Department of Education	150003000077	426	Pukalani Elem		Regular School	No	Elementary	PK	5	2020	grade_8	0.0	0
2431034	HI	school	1500030	1	Hawaii Department of Education	150003000292	433	Pomaikai Elem		Regular School	No	Elementary	PK	5	2020	grade_8	0.0	0
2431033	HI	school	1500030	1	Hawaii Department of Education	150003000076	422	Paia Elem		Regular School	No	Elementary	PK	5	2020	grade_8	0.0	0
2431032	HI	school	1500030	1	Hawaii Department of Education	150003000241	428	Maui Waena Int		Regular School	No	Middle	06	8	2020	grade_8	345.0	345
2431031	HI	school	1500030	1	Hawaii Department of Education	150003000073	418	Maui High		Regular School	No	High	09	12	2020	grade_8	0.0	0
2431030	HI	school	1500030	1	Hawaii Department of Education	150003000072	417	Makawao Elem		Regular School	No	Elementary	PK	5	2020	grade_8	0.0	0
2431029	HI	school	1500030	1	Hawaii Department of Education	150003000238	430	Lokelani Int		Regular School	No	Middle	06	8	2020	grade_8	154.0	154
2431028	HI	school	1500030	1	Hawaii Department of Education	150003000071	416	Lihikai Elem		Regular School	No	Elementary	PK	5	2020	grade_8	0.0	0
2431027	HI	school	1500030	1	Hawaii Department of Education	150003000067	412	Kula Elem		Regular School	No	Elementary	PK	5	2020	grade_8	0.0	0
2431026	HI	school	1500030	1	Hawaii Department of Education	150003000064	409	Kihei Elem		Regular School	No	Elementary	PK	5	2020	grade_8	0.0	0
2431025	HI	school	1500030	1	Hawaii Department of Education	150003000251	435	Kekaulike High		Regular School	No	High	09	12	2020	grade_8	0.0	0
2431024	HI	school	1500030	1	Hawaii Department of Education	150003000253	431	Kamalii Elem		Regular School	No	Elementary	PK	5	2020	grade_8	0.0	0
2431023	HI	school	1500030	1	Hawaii Department of Education	150003000233	420	Kalama Int		Regular School	No	Middle	06	8	2020	grade_8	247.0	247
2431022	HI	school	1500030	1	Hawaii Department of Education	150003000060	405	Kahului Elem		Regular School	No	Elementary	PK	5	2020	grade_8	0.0	0
2431021	HI	school	1500030	1	Hawaii Department of Education	150003000059	404	Iao Int		Regular School	No	Middle	06	8	2020	grade_8	265.0	265
2431020	HI	school	1500030	1	Hawaii Department of Education	150003000057	401	Haiku Elem		Regular School	No	Elementary	PK	5	2020	grade_8	0.0	0
2431019	HI	school	1500030	1	Hawaii Department of Education	150003000056	400	Baldwin High		Regular School	No	High	09	12	2020	grade_8	0.0	0
2431018	HI	school	1500030	1	Hawaii Department of Education	150003000050	383	Pahoa High & Int		Regular School	No	High	07	12	2020	grade_8	72.0	72
2431017	HI	school	1500030	1	Hawaii Department of Education	150003000234	381	Pahoa Elem		Regular School	No	Elementary	PK	6	2020	grade_8	0.0	0
2431016	HI	school	1500030	1	Hawaii Department of Education	150003000048	380	Naalehu Elem		Regular School	No	Elementary	PK	6	2020	grade_8	0.0	0
2431015	HI	school	1500030	1	Hawaii Department of Education	150003000047	379	Mountain View Elem		Regular School	No	Elementary	PK	5	2020	grade_8	0.0	0
2431014	HI	school	1500030	1	Hawaii Department of Education	150003000244	391	Keonepoko Elem		Regular School	No	Elementary	PK	6	2020	grade_8	0.0	0
2431013	HI	school	1500030	1	Hawaii Department of Education	150003000040	370	Keaau Middle		Regular School	No	Middle	06	8	2020	grade_8	219.0	219
2431012	HI	school	1500030	1	Hawaii Department of Education	150003000260	354	Keaau High		Regular School	No	High	09	12	2020	grade_8	0.0	0
2431011	HI	school	1500030	1	Hawaii Department of Education	150003000258	353	Keaau Elem		Regular School	No	Elementary	PK	5	2020	grade_8	0.0	0
2431010	HI	school	1500030	1	Hawaii Department of Education	150003000038	368	Kau High & Pahala Elem		Regular School	No	Other	PK	12	2020	grade_8	67.0	67
2431009	HI	school	1500030	1	Hawaii Department of Education	150003000055	387	Waimea Elem		Regular School	No	Elementary	PK	5	2020	grade_8	0.0	0
2431008	HI	school	1500030	1	Hawaii Department of Education	150003000247	393	Waikoloa El & Middle		Regular School	No	Elementary	PK	8	2020	grade_8	71.0	71
2431007	HI	school	1500030	1	Hawaii Department of Education	150003000049	382	Paauilo El & Int		Regular School	No	Other	PK	9	2020	grade_8	10.0	10
2431006	HI	school	1500030	1	Hawaii Department of Education	150003000252	376	Konawaena Middle		Regular School	No	Middle	06	8	2020	grade_8	200.0	200
2431005	HI	school	1500030	1	Hawaii Department of Education	150003000045	374	Konawaena High		Regular School	No	High	09	12	2020	grade_8	0.0	0
2431004	HI	school	1500030	1	Hawaii Department of Education	150003000044	375	Konawaena Elem		Regular School	No	Elementary	PK	5	2020	grade_8	0.0	0
2431003	HI	school	1500030	1	Hawaii Department of Education	150003000267	366	Kohala Middle		Regular School	No	Middle	06	8	2020	grade_8	60.0	60
2431002	HI	school	1500030	1	Hawaii Department of Education	150003000043	373	Kohala High		Regular School	No	High	09	12	2020	grade_8	0.0	0