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 and (unknown_race_int > :p4 or (unknown_race_int = :p4 and rowid > :p3)) order by unknown_race_int, 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	ccd_school_type	ccd_charter_school	ccd_school_lvl	ccd_school_low_grade	ccd_school_high_grade	year	grade	total	total_int
2736280	HI	school	1500030	1	Hawaii Department of Education	150003000248	280	Holomua Elem	Regular School	No	Elementary	PK	6	2019	grade_7	0.0	0
2736281	HI	school	1500030	1	Hawaii Department of Education	150003000300	293	Hookele Elem	Regular School	No	Elementary	PK	5	2019	grade_7	0.0	0
2736282	HI	school	1500030	1	Hawaii Department of Education	150003000129	279	Ilima Int	Regular School	No	Middle	07	8	2019	grade_7	431.0	431
2736283	HI	school	1500030	1	Hawaii Department of Education	150003000128	256	Iroquois Point Elem	Regular School	No	Elementary	PK	6	2019	grade_7	0.0	0
2736284	HI	school	1500030	1	Hawaii Department of Education	150003000127	281	Kaimiloa Elem	Regular School	No	Elementary	PK	6	2019	grade_7	0.0	0
2736285	HI	school	1500030	1	Hawaii Department of Education	150003000166	282	Kapolei Elem	Regular School	No	Elementary	PK	5	2019	grade_7	0.0	0
2736286	HI	school	1500030	1	Hawaii Department of Education	150003000261	292	Kapolei High	Regular School	No	High	09	12	2019	grade_7	0.0	0
2736287	HI	school	1500030	1	Hawaii Department of Education	150003000259	291	Kapolei Middle	Regular School	No	Middle	06	8	2019	grade_7	499.0	499
2736288	HI	school	1500030	1	Hawaii Department of Education	150003000291	294	Keoneula Elem	Regular School	No	Elementary	PK	6	2019	grade_7	0.0	0
2736289	HI	school	1500030	1	Hawaii Department of Education	150003000123	259	Makakilo Elem	Regular School	No	Elementary	PK	5	2019	grade_7	0.0	0
2736290	HI	school	1500030	1	Hawaii Department of Education	150003000121	286	Mauka Lani Elem	Regular School	No	Elementary	PK	5	2019	grade_7	0.0	0
2736291	HI	school	1500030	1	Hawaii Department of Education	150003000112	269	Pohakea Elem	Regular School	No	Elementary	PK	6	2019	grade_7	0.0	0
2736292	HI	school	1500030	1	Hawaii Department of Education	150003000230	271	Leihoku Elem	Regular School	No	Elementary	PK	6	2019	grade_7	0.0	0
2736293	HI	school	1500030	1	Hawaii Department of Education	150003000125	257	Maili Elem	Regular School	No	Elementary	PK	6	2019	grade_7	0.0	0
2736294	HI	school	1500030	1	Hawaii Department of Education	150003000124	258	Makaha Elem	Regular School	No	Elementary	PK	6	2019	grade_7	0.0	0
2736295	HI	school	1500030	1	Hawaii Department of Education	150003000119	261	Nanaikapono Elem	Regular School	No	Elementary	PK	6	2019	grade_7	0.0	0
2736296	HI	school	1500030	1	Hawaii Department of Education	150003000118	262	Nanakuli Elem	Regular School	No	Elementary	PK	6	2019	grade_7	0.0	0
2736297	HI	school	1500030	1	Hawaii Department of Education	150003000117	263	Nanakuli High & Int	Regular School	No	High	07	12	2019	grade_7	185.0	185
2736298	HI	school	1500030	1	Hawaii Department of Education	150003000111	270	Waianae Elem	Regular School	No	Elementary	PK	6	2019	grade_7	0.0	0
2736299	HI	school	1500030	1	Hawaii Department of Education	150003000110	272	Waianae High	Regular School	No	High	09	12	2019	grade_7	0.0	0
2736300	HI	school	1500030	1	Hawaii Department of Education	150003000229	273	Waianae Int	Regular School	No	Middle	07	8	2019	grade_7	411.0	411
2736301	HI	school	1500030	1	Hawaii Department of Education	150003000136	250	August Ahrens Elem	Regular School	No	Elementary	PK	6	2019	grade_7	0.0	0
2736302	HI	school	1500030	1	Hawaii Department of Education	150003000131	255	Highlands Int	Regular School	No	Middle	07	8	2019	grade_7	414.0	414
2736303	HI	school	1500030	1	Hawaii Department of Education	150003000130	276	Honowai Elem	Regular School	No	Elementary	PK	6	2019	grade_7	0.0	0
2736304	HI	school	1500030	1	Hawaii Department of Education	150003000239	287	Kaleiopuu Elem	Regular School	No	Elementary	PK	6	2019	grade_7	0.0	0
2736305	HI	school	1500030	1	Hawaii Department of Education	150003000231	283	Kanoelani Elem	Regular School	No	Elementary	PK	6	2019	grade_7	0.0	0
2736306	HI	school	1500030	1	Hawaii Department of Education	150003000126	268	Lehua Elem	Regular School	No	Elementary	PK	6	2019	grade_7	0.0	0
2736307	HI	school	1500030	1	Hawaii Department of Education	150003000122	260	Manana Elem	Regular School	No	Elementary	PK	6	2019	grade_7	0.0	0
2736308	HI	school	1500030	1	Hawaii Department of Education	150003000120	285	Momilani Elem	Regular School	No	Elementary	PK	6	2019	grade_7	0.0	0
2736309	HI	school	1500030	1	Hawaii Department of Education	150003000116	264	Palisades Elem	Regular School	No	Elementary	PK	6	2019	grade_7	0.0	0
2736310	HI	school	1500030	1	Hawaii Department of Education	150003000115	265	Pearl City Elem	Regular School	No	Elementary	PK	6	2019	grade_7	0.0	0
2736311	HI	school	1500030	1	Hawaii Department of Education	150003000114	266	Pearl City High	Regular School	No	High	09	12	2019	grade_7	0.0	0
2736312	HI	school	1500030	1	Hawaii Department of Education	150003000113	267	Pearl City Highlands Elem	Regular School	No	Elementary	PK	6	2019	grade_7	0.0	0
2736313	HI	school	1500030	1	Hawaii Department of Education	150003000109	288	Waiau Elem	Regular School	No	Elementary	PK	6	2019	grade_7	0.0	0
2736314	HI	school	1500030	1	Hawaii Department of Education	150003000257	290	Waikele Elem	Regular School	No	Elementary	PK	6	2019	grade_7	0.0	0
2736315	HI	school	1500030	1	Hawaii Department of Education	150003000159	274	Waipahu Elem	Regular School	No	Elementary	PK	6	2019	grade_7	0.0	0
2736316	HI	school	1500030	1	Hawaii Department of Education	150003000161	277	Waipahu High	Regular School	No	High	09	12	2019	grade_7	0.0	0
2736317	HI	school	1500030	1	Hawaii Department of Education	150003000158	278	Waipahu Int	Regular School	No	Middle	07	8	2019	grade_7	610.0	610
2736318	HI	school	1500030	1	Hawaii Department of Education	150003000157	335	Ahuimanu Elem	Regular School	No	Elementary	PK	6	2019	grade_7	0.0	0
2736319	HI	school	1500030	1	Hawaii Department of Education	150003000100	301	Castle High	Regular School	No	High	09	12	2019	grade_7	0.0	0
2736320	HI	school	1500030	1	Hawaii Department of Education	150003000002	303	Hauula Elem	Regular School	No	Elementary	PK	6	2019	grade_7	0.0	0
2736321	HI	school	1500030	1	Hawaii Department of Education	150003000003	304	Heeia Elem	Regular School	No	Elementary	PK	6	2019	grade_7	0.0	0
2736322	HI	school	1500030	1	Hawaii Department of Education	150003000004	305	Kaaawa Elem	Regular School	No	Elementary	PK	6	2019	grade_7	0.0	0
2736323	HI	school	1500030	1	Hawaii Department of Education	150003000006	306	Kahaluu Elem	Regular School	No	Elementary	PK	6	2019	grade_7	0.0	0
2736324	HI	school	1500030	1	Hawaii Department of Education	150003000236	331	Kahuku Elem	Regular School	No	Elementary	PK	6	2019	grade_7	0.0	0
2736325	HI	school	1500030	1	Hawaii Department of Education	150003000007	307	Kahuku High & Int	Regular School	No	High	07	12	2019	grade_7	214.0	214
2736326	HI	school	1500030	1	Hawaii Department of Education	150003000013	313	Kaneohe Elem	Regular School	No	Elementary	PK	6	2019	grade_7	0.0	0
2736327	HI	school	1500030	1	Hawaii Department of Education	150003000014	315	Kapunahala Elem	Regular School	No	Elementary	PK	6	2019	grade_7	0.0	0
2736328	HI	school	1500030	1	Hawaii Department of Education	150003000016	318	King Int	Regular School	No	Middle	07	8	2019	grade_7	289.0	289
2736329	HI	school	1500030	1	Hawaii Department of Education	150003000017	319	Laie Elem	Regular School	No	Elementary	PK	6	2019	grade_7	0.0	0
2736330	HI	school	1500030	1	Hawaii Department of Education	150003000021	323	Parker Elem	Regular School	No	Elementary	PK	6	2019	grade_7	0.0	0
2736331	HI	school	1500030	1	Hawaii Department of Education	150003000023	314	Puohala Elem	Regular School	No	Elementary	PK	7	2019	grade_7	5.0	5
2736332	HI	school	1500030	1	Hawaii Department of Education	150003000024	325	Sunset Beach Elem	Regular School	No	Elementary	PK	6	2019	grade_7	0.0	0
2736333	HI	school	1500030	1	Hawaii Department of Education	150003000025	326	Waiahole Elem	Regular School	No	Elementary	PK	6	2019	grade_7	0.0	0
2736334	HI	school	1500030	1	Hawaii Department of Education	150003000101	300	Aikahi Elem	Regular School	No	Elementary	PK	6	2019	grade_7	0.0	0
2736335	HI	school	1500030	1	Hawaii Department of Education	150003000001	302	Enchanted Lake Elem	Regular School	No	Elementary	PK	6	2019	grade_7	0.0	0
2736336	HI	school	1500030	1	Hawaii Department of Education	150003000005	330	Kaelepulu Elem	Regular School	No	Elementary	PK	6	2019	grade_7	0.0	0
2736337	HI	school	1500030	1	Hawaii Department of Education	150003000008	308	Kailua Elem	Regular School	No	Elementary	PK	6	2019	grade_7	0.0	0
2736338	HI	school	1500030	1	Hawaii Department of Education	150003000009	309	Kailua High	Regular School	No	High	09	12	2019	grade_7	0.0	0
2736339	HI	school	1500030	1	Hawaii Department of Education	150003000010	310	Kailua Int	Regular School	No	Middle	07	8	2019	grade_7	357.0	357
2736340	HI	school	1500030	1	Hawaii Department of Education	150003000011	311	Kainalu Elem	Regular School	No	Elementary	PK	6	2019	grade_7	0.0	0
2736341	HI	school	1500030	1	Hawaii Department of Education	150003000012	312	Kalaheo High	Regular School	No	High	09	12	2019	grade_7	0.0	0
2736342	HI	school	1500030	1	Hawaii Department of Education	150003000015	317	Keolu Elem	Regular School	No	Elementary	PK	6	2019	grade_7	0.0	0
2736343	HI	school	1500030	1	Hawaii Department of Education	150003000019	321	Maunawili Elem	Regular School	No	Elementary	PK	6	2019	grade_7	0.0	0
2736344	HI	school	1500030	1	Hawaii Department of Education	150003000020	322	Mokapu Elem	Regular School	No	Elementary	PK	6	2019	grade_7	0.0	0
2736345	HI	school	1500030	1	Hawaii Department of Education	150003000098	475	Olomana	Alternative School	No	High	07	12	2019	grade_7	2.0	2
2736346	HI	school	1500030	1	Hawaii Department of Education	150003000022	324	Pope Elem	Regular School	No	Elementary	PK	6	2019	grade_7	0.0	0
2736347	HI	school	1500030	1	Hawaii Department of Education	150003000026	327	Waimanalo El & Int	Regular School	No	Elementary	PK	8	2019	grade_7	70.0	70
2736348	HI	school	1500030	1	Hawaii Department of Education	150003000027	351	de Silva Elem	Regular School	No	Elementary	PK	6	2019	grade_7	0.0	0
2736349	HI	school	1500030	1	Hawaii Department of Education	150003000028	352	Haaheo Elem	Regular School	No	Elementary	PK	6	2019	grade_7	0.0	0
2736350	HI	school	1500030	1	Hawaii Department of Education	150003000029	355	Hilo High	Regular School	No	High	09	12	2019	grade_7	0.0	0
2736351	HI	school	1500030	1	Hawaii Department of Education	150003000030	356	Hilo Int	Regular School	No	Middle	07	8	2019	grade_7	246.0	246
2736352	HI	school	1500030	1	Hawaii Department of Education	150003000031	357	Hilo Union Elem	Regular School	No	Elementary	PK	6	2019	grade_7	0.0	0
2736353	HI	school	1500030	1	Hawaii Department of Education	150003000036	365	Kalanianaole El & Int	Regular School	No	Elementary	PK	8	2019	grade_7	32.0	32
2736354	HI	school	1500030	1	Hawaii Department of Education	150003000037	367	Kapiolani Elem	Regular School	No	Elementary	PK	6	2019	grade_7	0.0	0
2736355	HI	school	1500030	1	Hawaii Department of Education	150003000039	369	Kaumana Elem	Regular School	No	Elementary	PK	6	2019	grade_7	0.0	0
2736356	HI	school	1500030	1	Hawaii Department of Education	150003000042	372	Keaukaha Elem	Regular School	No	Elementary	PK	6	2019	grade_7	0.0	0
2736357	HI	school	1500030	1	Hawaii Department of Education	150003000051	384	Waiakea Elem	Regular School	No	Elementary	PK	5	2019	grade_7	0.0	0
2736358	HI	school	1500030	1	Hawaii Department of Education	150003000052	389	Waiakea High	Regular School	No	High	09	12	2019	grade_7	0.0	0
2736359	HI	school	1500030	1	Hawaii Department of Education	150003000053	385	Waiakea Int	Regular School	No	Middle	06	8	2019	grade_7	263.0	263
2736360	HI	school	1500030	1	Hawaii Department of Education	150003000054	386	Waiakeawaena Elem	Regular School	No	Elementary	PK	5	2019	grade_7	0.0	0
2736361	HI	school	1500030	1	Hawaii Department of Education	150003000032	358	Holualoa Elem	Regular School	No	Elementary	PK	5	2019	grade_7	0.0	0
2736362	HI	school	1500030	1	Hawaii Department of Education	150003000033	359	Honaunau Elem	Regular School	No	Elementary	PK	5	2019	grade_7	0.0	0
2736363	HI	school	1500030	1	Hawaii Department of Education	150003000249	361	Honokaa Elem	Regular School	No	Elementary	PK	6	2019	grade_7	0.0	0
2736364	HI	school	1500030	1	Hawaii Department of Education	150003000034	360	Honokaa High & Int	Regular School	No	High	07	12	2019	grade_7	34.0	34
2736365	HI	school	1500030	1	Hawaii Department of Education	150003000035	363	Hookena Elem	Regular School	No	Elementary	PK	5	2019	grade_7	0.0	0
2736366	HI	school	1500030	1	Hawaii Department of Education	150003000232	371	Kahakai Elem	Regular School	No	Elementary	PK	5	2019	grade_7	0.0	0
2736367	HI	school	1500030	1	Hawaii Department of Education	150003000287	378	Ke Kula o Ehunuikaimalino	Regular School	No	Other	PK	12	2019	grade_7	8.0	8
2736368	HI	school	1500030	1	Hawaii Department of Education	150003000041	388	Kealakehe Elem	Regular School	No	Elementary	PK	5	2019	grade_7	0.0	0
2736369	HI	school	1500030	1	Hawaii Department of Education	150003000254	392	Kealakehe High	Regular School	No	High	09	12	2019	grade_7	0.0	0
2736370	HI	school	1500030	1	Hawaii Department of Education	150003000235	390	Kealakehe Int	Regular School	No	Middle	06	8	2019	grade_7	196.0	196
2736371	HI	school	1500030	1	Hawaii Department of Education	150003000250	395	Kohala Elem	Regular School	No	Elementary	PK	5	2019	grade_7	0.0	0
2736372	HI	school	1500030	1	Hawaii Department of Education	150003000043	373	Kohala High	Regular School	No	High	09	12	2019	grade_7	0.0	0
2736373	HI	school	1500030	1	Hawaii Department of Education	150003000267	366	Kohala Middle	Regular School	No	Middle	06	8	2019	grade_7	55.0	55
2736374	HI	school	1500030	1	Hawaii Department of Education	150003000044	375	Konawaena Elem	Regular School	No	Elementary	PK	5	2019	grade_7	0.0	0
2736375	HI	school	1500030	1	Hawaii Department of Education	150003000045	374	Konawaena High	Regular School	No	High	09	12	2019	grade_7	0.0	0
2736376	HI	school	1500030	1	Hawaii Department of Education	150003000252	376	Konawaena Middle	Regular School	No	Middle	06	8	2019	grade_7	218.0	218
2736377	HI	school	1500030	1	Hawaii Department of Education	150003000049	382	Paauilo El & Int	Regular School	No	Other	PK	9	2019	grade_7	15.0	15
2736378	HI	school	1500030	1	Hawaii Department of Education	150003000247	393	Waikoloa El & Middle	Regular School	No	Elementary	PK	8	2019	grade_7	73.0	73
2736379	HI	school	1500030	1	Hawaii Department of Education	150003000055	387	Waimea Elem	Regular School	No	Elementary	PK	5	2019	grade_7	0.0	0
2736380	HI	school	1500030	1	Hawaii Department of Education	150003000038	368	Kau High & Pahala Elem	Regular School	No	Other	PK	12	2019	grade_7	66.0	66