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_low_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
279946	HI	school	1500030	1	Hawaii Department of Education	150003000270	540	HALAU KU MANA-PCS	charter	Regular School	Yes	4	04	12	2015	grade_8	16.0	16
279952	HI	school	1500030	1	Hawaii Department of Education	150003000275	546	HAKIPU'U LEARNING CTR-PCS	charter	Regular School	Yes	4	04	12	2015	grade_8	4.0	4
279681	HI	school	1500030	1	Hawaii Department of Education	150003000222	105	DOLE MID		Regular School	No	2	06	8	2015	grade_8	215.0	215
279688	HI	school	1500030	1	Hawaii Department of Education	150003000211	116	KAIMUKI MID		Regular School	No	2	06	8	2015	grade_8	287.0	287
279690	HI	school	1500030	1	Hawaii Department of Education	150003000164	118	KALAKAUA MID		Regular School	No	2	06	8	2015	grade_8	256.0	256
279701	HI	school	1500030	1	Hawaii Department of Education	150003000192	139	NIU VALLEY MID		Regular School	No	2	06	8	2015	grade_8	258.0	258
279708	HI	school	1500030	1	Hawaii Department of Education	150003000223	104	CENTRAL MID		Regular School	No	2	06	8	2015	grade_8	97.0	97
279710	HI	school	1500030	1	Hawaii Department of Education	150003000218	110	JARRETT MID		Regular School	No	2	06	8	2015	grade_8	46.0	46
279716	HI	school	1500030	1	Hawaii Department of Education	150003000205	126	KAWANANAKOA MID		Regular School	No	2	06	8	2015	grade_8	250.0	250
279731	HI	school	1500030	1	Hawaii Department of Education	150003000184	148	STEVENSON MID		Regular School	No	2	06	8	2015	grade_8	182.0	182
279732	HI	school	1500030	1	Hawaii Department of Education	150003000180	152	WASHINGTON MID		Regular School	No	2	06	8	2015	grade_8	221.0	221
279765	HI	school	1500030	1	Hawaii Department of Education	150003000256	238	MILILANI MID		Regular School	No	2	06	8	2015	grade_8	507.0	507
279770	HI	school	1500030	1	Hawaii Department of Education	150003000143	230	WAHIAWA MID		Regular School	No	2	06	8	2015	grade_8	220.0	220
279774	HI	school	1500030	1	Hawaii Department of Education	150003000137	237	WHEELER MID		Regular School	No	2	06	8	2015	grade_8	232.0	232
279786	HI	school	1500030	1	Hawaii Department of Education	150003000259	291	KAPOLEI MID		Regular School	No	2	06	8	2015	grade_8	434.0	434
279858	HI	school	1500030	1	Hawaii Department of Education	150003000053	385	WAIAKEA INT		Regular School	No	2	06	8	2015	grade_8	231.0	231
279869	HI	school	1500030	1	Hawaii Department of Education	150003000235	390	KEALAKEHE INT		Regular School	No	2	06	8	2015	grade_8	195.0	195
279872	HI	school	1500030	1	Hawaii Department of Education	150003000267	366	KOHALA MID		Regular School	No	2	06	8	2015	grade_8	47.0	47
279875	HI	school	1500030	1	Hawaii Department of Education	150003000252	376	KONAWAENA MID		Regular School	No	2	06	8	2015	grade_8	157.0	157
279882	HI	school	1500030	1	Hawaii Department of Education	150003000040	370	KEAAU MID		Regular School	No	2	06	8	2015	grade_8	182.0	182
279890	HI	school	1500030	1	Hawaii Department of Education	150003000059	404	IAO INT		Regular School	No	2	06	8	2015	grade_8	240.0	240
279892	HI	school	1500030	1	Hawaii Department of Education	150003000233	420	KALAMA INT		Regular School	No	2	06	8	2015	grade_8	220.0	220
279898	HI	school	1500030	1	Hawaii Department of Education	150003000238	430	LOKELANI INT		Regular School	No	2	06	8	2015	grade_8	147.0	147
279901	HI	school	1500030	1	Hawaii Department of Education	150003000241	428	MAUI WAENA INT		Regular School	No	2	06	8	2015	grade_8	318.0	318
279912	HI	school	1500030	1	Hawaii Department of Education	150003000068	413	LAHAINA INT		Regular School	No	2	06	8	2015	grade_8	163.0	163
279922	HI	school	1500030	1	Hawaii Department of Education	150003000266	448	KAMAKAHELEI MID		Regular School	No	2	06	8	2015	grade_8	283.0	283
279925	HI	school	1500030	1	Hawaii Department of Education	150003000255	447	KAPAA MID		Regular School	No	2	06	8	2015	grade_8	157.0	157
279932	HI	school	1500030	1	Hawaii Department of Education	150003000092	464	WAIMEA CANYON		Regular School	No	2	06	8	2015	grade_8	99.0	99
279939	HI	school	1500030	1	Hawaii Department of Education	150003000268	394	WAIMEA MID-PCCS	charter	Regular School	Yes	2	06	8	2015	grade_8	84.0	84
279943	HI	school	1500030	1	Hawaii Department of Education	150003000265	399	WEST HI EXPLOR ACAD-PCS	charter	Regular School	Yes	4	06	12	2015	grade_8	32.0	32
279968	HI	school	1500030	1	Hawaii Department of Education	150003000298	567	SEEQS	charter	Regular School	Yes	2	06	8	2015	grade_8	23.0	23
279735	HI	school	1500030	1	Hawaii Department of Education	150003000176	201	AIEA INT		Regular School	No	2	07	8	2015	grade_8	270.0	270
279737	HI	school	1500030	1	Hawaii Department of Education	150003000174	204	ALIAMANU INT		Regular School	No	2	07	8	2015	grade_8	297.0	297
279742	HI	school	1500030	1	Hawaii Department of Education	150003000156	219	MOANALUA MID		Regular School	No	2	07	8	2015	grade_8	383.0	383
279772	HI	school	1500030	1	Hawaii Department of Education	150003000141	232	WAIALUA HI & INT		Regular School	No	3	07	12	2015	grade_8	85.0	85
279779	HI	school	1500030	1	Hawaii Department of Education	150003000296	296	EWA MAKAI MID		Regular School	No	2	07	8	2015	grade_8	388.0	388
279781	HI	school	1500030	1	Hawaii Department of Education	150003000129	279	ILIMA INT		Regular School	No	2	07	8	2015	grade_8	375.0	375
279796	HI	school	1500030	1	Hawaii Department of Education	150003000117	263	NANAKULI HI & INT		Regular School	No	3	07	12	2015	grade_8	140.0	140
279799	HI	school	1500030	1	Hawaii Department of Education	150003000229	273	WAIANAE INT		Regular School	No	2	07	8	2015	grade_8	355.0	355
279801	HI	school	1500030	1	Hawaii Department of Education	150003000131	255	HIGHLANDS INT		Regular School	No	2	07	8	2015	grade_8	393.0	393
279816	HI	school	1500030	1	Hawaii Department of Education	150003000158	278	WAIPAHU INT		Regular School	No	2	07	8	2015	grade_8	546.0	546
279824	HI	school	1500030	1	Hawaii Department of Education	150003000007	307	KAHUKU HI		Regular School	No	3	07	12	2015	grade_8	205.0	205
279827	HI	school	1500030	1	Hawaii Department of Education	150003000016	318	KING INT		Regular School	No	2	07	8	2015	grade_8	270.0	270
279838	HI	school	1500030	1	Hawaii Department of Education	150003000010	310	KAILUA INT		Regular School	No	2	07	8	2015	grade_8	278.0	278
279844	HI	school	1500030	1	Hawaii Department of Education	150003000098	475	OLOMANA		Alternative Education School	No	3	07	12	2015	grade_8	3.0	3
279850	HI	school	1500030	1	Hawaii Department of Education	150003000030	356	HILO INT		Regular School	No	2	07	8	2015	grade_8	196.0	196
279863	HI	school	1500030	1	Hawaii Department of Education	150003000034	360	HONOKAA HI & INT		Regular School	No	3	07	12	2015	grade_8	60.0	60
279887	HI	school	1500030	1	Hawaii Department of Education	150003000050	383	PAHOA HI & INT		Regular School	No	3	07	12	2015	grade_8	94.0	94
279917	HI	school	1500030	1	Hawaii Department of Education	150003000290	434	MOLOKAI MID		Regular School	No	2	07	8	2015	grade_8	79.0	79
279955	HI	school	1500030	1	Hawaii Department of Education	150003000278	549	KE ANA LA'AHANA-PCS	charter	Regular School	Yes	3	07	12	2015	grade_8	10.0	10
279682	HI	school	1500030	1	Hawaii Department of Education	150003000221	106	FARRINGTON HI		Regular School	No	3	09	12	2015	grade_8	0.0	0
279689	HI	school	1500030	1	Hawaii Department of Education	150003000228	154	KAISER HI		Regular School	No	3	09	12	2015	grade_8	0.0	0
279691	HI	school	1500030	1	Hawaii Department of Education	150003000163	119	KALANI HI		Regular School	No	3	09	12	2015	grade_8	0.0	0
279713	HI	school	1500030	1	Hawaii Department of Education	150003000212	115	KAIMUKI HI		Regular School	No	3	09	12	2015	grade_8	0.0	0
279724	HI	school	1500030	1	Hawaii Department of Education	150003000193	138	MCKINLEY HI		Regular School	No	3	09	12	2015	grade_8	0.0	0
279729	HI	school	1500030	1	Hawaii Department of Education	150003000186	146	ROOSEVELT HI		Regular School	No	3	09	12	2015	grade_8	0.0	0
279734	HI	school	1500030	1	Hawaii Department of Education	150003000177	202	AIEA HI		Regular School	No	3	09	12	2015	grade_8	0.0	0
279741	HI	school	1500030	1	Hawaii Department of Education	150003000103	218	MOANALUA HI		Regular School	No	3	09	12	2015	grade_8	0.0	0
279748	HI	school	1500030	1	Hawaii Department of Education	150003000150	224	RADFORD HI		Regular School	No	3	09	12	2015	grade_8	0.0	0
279761	HI	school	1500030	1	Hawaii Department of Education	150003000108	214	LEILEHUA HI		Regular School	No	3	09	12	2015	grade_8	0.0	0
279762	HI	school	1500030	1	Hawaii Department of Education	150003000102	216	MILILANI HI		Regular School	No	3	09	12	2015	grade_8	0.0	0
279776	HI	school	1500030	1	Hawaii Department of Education	150003000134	252	CAMPBELL HI		Regular School	No	3	09	12	2015	grade_8	0.0	0
279785	HI	school	1500030	1	Hawaii Department of Education	150003000261	292	KAPOLEI HI		Regular School	No	3	09	12	2015	grade_8	0.0	0
279798	HI	school	1500030	1	Hawaii Department of Education	150003000110	272	WAIANAE HI		Regular School	No	3	09	12	2015	grade_8	0.0	0
279811	HI	school	1500030	1	Hawaii Department of Education	150003000114	266	PEARL CITY HI		Regular School	No	3	09	12	2015	grade_8	0.0	0
279815	HI	school	1500030	1	Hawaii Department of Education	150003000161	277	WAIPAHU HI		Regular School	No	3	09	12	2015	grade_8	0.0	0
279818	HI	school	1500030	1	Hawaii Department of Education	150003000100	301	CASTLE HI		Regular School	No	3	09	12	2015	grade_8	0.0	0
279837	HI	school	1500030	1	Hawaii Department of Education	150003000009	309	KAILUA HI		Regular School	No	3	09	12	2015	grade_8	0.0	0
279840	HI	school	1500030	1	Hawaii Department of Education	150003000012	312	KALAHEO HI		Regular School	No	3	09	12	2015	grade_8	0.0	0
279849	HI	school	1500030	1	Hawaii Department of Education	150003000029	355	HILO HI		Regular School	No	3	09	12	2015	grade_8	0.0	0
279857	HI	school	1500030	1	Hawaii Department of Education	150003000052	389	WAIAKEA HI		Regular School	No	3	09	12	2015	grade_8	0.0	0
279868	HI	school	1500030	1	Hawaii Department of Education	150003000254	392	KEALAKEHE HI		Regular School	No	3	09	12	2015	grade_8	0.0	0
279871	HI	school	1500030	1	Hawaii Department of Education	150003000043	373	KOHALA HI		Regular School	No	3	09	12	2015	grade_8	0.0	0
279874	HI	school	1500030	1	Hawaii Department of Education	150003000045	374	KONAWAENA HI		Regular School	No	3	09	12	2015	grade_8	0.0	0
279881	HI	school	1500030	1	Hawaii Department of Education	150003000260	354	KEAAU HI		Regular School	No	3	09	12	2015	grade_8	0.0	0
279888	HI	school	1500030	1	Hawaii Department of Education	150003000056	400	BALDWIN HI		Regular School	No	3	09	12	2015	grade_8	0.0	0
279894	HI	school	1500030	1	Hawaii Department of Education	150003000251	435	KEKAULIKE HI		Regular School	No	3	09	12	2015	grade_8	0.0	0
279900	HI	school	1500030	1	Hawaii Department of Education	150003000073	418	MAUI HI		Regular School	No	3	09	12	2015	grade_8	0.0	0
279913	HI	school	1500030	1	Hawaii Department of Education	150003000069	414	LAHAINALUNA HI		Regular School	No	3	09	12	2015	grade_8	0.0	0
279916	HI	school	1500030	1	Hawaii Department of Education	150003000075	421	MOLOKAI HI		Regular School	No	3	09	12	2015	grade_8	0.0	0
279924	HI	school	1500030	1	Hawaii Department of Education	150003000085	455	KAPAA HI		Regular School	No	3	09	12	2015	grade_8	0.0	0
279926	HI	school	1500030	1	Hawaii Department of Education	150003000086	456	KAUAI HI		Regular School	No	3	09	12	2015	grade_8	0.0	0
279933	HI	school	1500030	1	Hawaii Department of Education	150003000093	462	WAIMEA HI		Regular School	No	3	09	12	2015	grade_8	0.0	0
279937	HI	school	1500030	1	Hawaii Department of Education	150003000018	320	LANIKAI-PCS	charter	Regular School	Yes	1	KG	6	2015	grade_8	0.0	0
279940	HI	school	1500030	1	Hawaii Department of Education	150003000262	396	CONNECTIONS-PCS	charter	Regular School	Yes	4	KG	12	2015	grade_8	27.0	27
279941	HI	school	1500030	1	Hawaii Department of Education	150003000263	397	KANU O KA'AINA-PCS	charter	Regular School	Yes	4	KG	12	2015	grade_8	16.0	16
279942	HI	school	1500030	1	Hawaii Department of Education	150003000264	398	WATERS OF LIFE-PCS	charter	Regular School	Yes	1	KG	6	2015	grade_8	0.0	0
279945	HI	school	1500030	1	Hawaii Department of Education	150003000269	466	KANAKA-PCS	charter	Regular School	Yes	4	KG	12	2015	grade_8	3.0	3
279947	HI	school	1500030	1	Hawaii Department of Education	150003000271	541	VOYAGER-PCS	charter	Regular School	Yes	1	KG	8	2015	grade_8	12.0	12
279948	HI	school	1500030	1	Hawaii Department of Education	150003000272	542	HALAU LOKAHI NC-PCS	charter	Regular School	Yes	4	KG	12	2015	grade_8	15.0	15
279949	HI	school	1500030	1	Hawaii Department of Education	150003000273	543	EDUC LAB: A HAWAII NC-PCS	charter	Regular School	Yes	4	KG	12	2015	grade_8	50.0	50
279950	HI	school	1500030	1	Hawaii Department of Education	150003000274	544	MYRON THOMPSON ACAD-PCS	charter	Regular School	Yes	4	KG	12	2015	grade_8	24.0	24
279951	HI	school	1500030	1	Hawaii Department of Education	150003000286	545	KA WAIHONA O KA NAAUAO-PCS	charter	Regular School	Yes	1	KG	8	2015	grade_8	60.0	60
279954	HI	school	1500030	1	Hawaii Department of Education	150003000277	548	INNOVATIONS-PCS	charter	Regular School	Yes	1	KG	8	2015	grade_8	34.0	34
279956	HI	school	1500030	1	Hawaii Department of Education	150003000299	550	MALAMA HONUA PCS	charter	Regular School	Yes	1	KG	2	2015	grade_8	0.0	0
279957	HI	school	1500030	1	Hawaii Department of Education	150003000295	551	HAWAII TECHNOLOGY ACADEMY	charter	Regular School	Yes	4	KG	12	2015	grade_8	133.0	133
279958	HI	school	1500030	1	Hawaii Department of Education	150003000279	554	KIHEI PC SCHOOL-PCS	charter	Regular School	Yes	4	KG	12	2015	grade_8	65.0	65
279959	HI	school	1500030	1	Hawaii Department of Education	150003000280	556	KE KULA NIIHAU KEKAHA-PCS	charter	Regular School	Yes	4	KG	12	2015	grade_8	5.0	5
279960	HI	school	1500030	1	Hawaii Department of Education	150003000288	557	KUA O KA LA-PCS	charter	Regular School	Yes	4	KG	12	2015	grade_8	16.0	16
279961	HI	school	1500030	1	Hawaii Department of Education	150003000281	560	VOLCANO SCH OF A&S-PCS	charter	Regular School	Yes	1	KG	8	2015	grade_8	14.0	14
279962	HI	school	1500030	1	Hawaii Department of Education	150003000282	561	HI ACADEMY OF A&S-PCS	charter	Regular School	Yes	4	KG	12	2015	grade_8	45.0	45