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
128992	HI	school	1500030	1	Hawaii Department of Education	150003000265	399	WEST HI EXPLOR ACAD-PCS	charter	Regular School	Yes	Other	06	12	2017	grade_8	39.0	39
128991	HI	school	1500030	1	Hawaii Department of Education	150003000268	394	WAIMEA MID-PCCS	charter	Regular School	Yes	Middle	06	8	2017	grade_8	75.0	75
128990	HI	school	1500030	1	Hawaii Department of Education	150003000183	149	WAIALAE-PCS	charter	Regular School	Yes	Elementary	PK	5	2017	grade_8	0.0	0
128989	HI	school	1500030	1	Hawaii Department of Education	150003000271	541	VOYAGER-PCS	charter	Regular School	Yes	Elementary	KG	8	2017	grade_8	8.0	8
128988	HI	school	1500030	1	Hawaii Department of Education	150003000281	560	VOLCANO SCH OF A&S-PCS	charter	Regular School	Yes	Elementary	KG	8	2017	grade_8	17.0	17
128987	HI	school	1500030	1	Hawaii Department of Education	150003000298	567	SEEQS	charter	Regular School	Yes	Middle	06	8	2017	grade_8	45.0	45
128986	HI	school	1500030	1	Hawaii Department of Education	150003000284	563	NAWAHI IKI LAB-PCS	charter	Regular School	Yes	Elementary	PK	8	2017	grade_8	17.0	17
128985	HI	school	1500030	1	Hawaii Department of Education	150003000264	398	NA WAI OLA PCS	charter	Regular School	Yes	Elementary	PK	6	2017	grade_8	0.0	0
128984	HI	school	1500030	1	Hawaii Department of Education	150003000274	544	MYRON THOMPSON ACAD-PCS	charter	Regular School	Yes	Other	KG	12	2017	grade_8	37.0	37
128983	HI	school	1500030	1	Hawaii Department of Education	150003000299	550	MALAMA HONUA PCS	charter	Regular School	Yes	Elementary	KG	4	2017	grade_8	0.0	0
128982	HI	school	1500030	1	Hawaii Department of Education	150003000046	377	LAUPAHOEHOE COMMUNITY - PCS	charter	Regular School	Yes	Other	PK	12	2017	grade_8	21.0	21
128981	HI	school	1500030	1	Hawaii Department of Education	150003000018	320	LANIKAI-PCS	charter	Regular School	Yes	Elementary	KG	6	2017	grade_8	0.0	0
128980	HI	school	1500030	1	Hawaii Department of Education	150003000066	411	KUALAPUU	charter	Regular School	Yes	Elementary	PK	6	2017	grade_8	0.0	0
128979	HI	school	1500030	1	Hawaii Department of Education	150003000288	557	KUA O KA LA-PCS	charter	Regular School	Yes	Other	KG	12	2017	grade_8	9.0	9
128978	HI	school	1500030	1	Hawaii Department of Education	150003000293	566	KONA PACIFIC-PCS	charter	Regular School	Yes	Elementary	KG	8	2017	grade_8	21.0	21
128977	HI	school	1500030	1	Hawaii Department of Education	150003000279	554	KIHEI PC SCHOOL-PCS	charter	Regular School	Yes	Other	KG	12	2017	grade_8	66.0	66
128976	HI	school	1500030	1	Hawaii Department of Education	150003000276	547	KE KULA O KAMAKAU LAB-PCS	charter	Regular School	Yes	Other	PK	12	2017	grade_8	7.0	7
128975	HI	school	1500030	1	Hawaii Department of Education	150003000280	556	KE KULA NIIHAU KEKAHA-PCS	charter	Regular School	Yes	Other	KG	12	2017	grade_8	3.0	3
128974	HI	school	1500030	1	Hawaii Department of Education	150003000278	549	KE ANA LA'AHANA-PCS	charter	Regular School	Yes	High	07	12	2017	grade_8	9.0	9
128973	HI	school	1500030	1	Hawaii Department of Education	150003000294	565	KAWAIKINI-PCS	charter	Regular School	Yes	Other	KG	12	2017	grade_8	10.0	10
128972	HI	school	1500030	1	Hawaii Department of Education	150003000301	552	KAU LEARNING ACAD-PCS	charter	Regular School	Yes	Elementary	03	7	2017	grade_8	0.0	0
128971	HI	school	1500030	1	Hawaii Department of Education	150003000289	564	KANUIKAPONO-PCS	charter	Regular School	Yes	Other	KG	12	2017	grade_8	17.0	17
128970	HI	school	1500030	1	Hawaii Department of Education	150003000263	397	KANU O KA'AINA-PCS	charter	Regular School	Yes	Other	KG	12	2017	grade_8	23.0	23
128969	HI	school	1500030	1	Hawaii Department of Education	150003000269	466	KANAKA-PCS	charter	Regular School	Yes	Other	KG	12	2017	grade_8	2.0	2
128968	HI	school	1500030	1	Hawaii Department of Education	150003000240	275	KAMAILE ACADEMY	charter	Regular School	Yes	Other	PK	12	2017	grade_8	30.0	30
128967	HI	school	1500030	1	Hawaii Department of Education	150003000286	545	KA WAIHONA O KA NAAUAO-PCS	charter	Regular School	Yes	Elementary	KG	8	2017	grade_8	57.0	57
128966	HI	school	1500030	1	Hawaii Department of Education	150003000283	562	KA 'UMEKE KA'EO-PCS	charter	Regular School	Yes	Elementary	PK	8	2017	grade_8	7.0	7
128965	HI	school	1500030	1	Hawaii Department of Education	150003000277	548	INNOVATIONS-PCS	charter	Regular School	Yes	Elementary	KG	8	2017	grade_8	30.0	30
128964	HI	school	1500030	1	Hawaii Department of Education	150003000282	561	HI ACADEMY OF A&S-PCS	charter	Regular School	Yes	Other	KG	12	2017	grade_8	62.0	62
128963	HI	school	1500030	1	Hawaii Department of Education	150003000295	551	HAWAII TECHNOLOGY ACADEMY	charter	Regular School	Yes	Other	KG	12	2017	grade_8	106.0	106
128962	HI	school	1500030	1	Hawaii Department of Education	150003000270	540	HALAU KU MANA-PCS	charter	Regular School	Yes	Other	04	12	2017	grade_8	15.0	15
128961	HI	school	1500030	1	Hawaii Department of Education	150003000275	546	HAKIPU'U LEARNING CTR-PCS	charter	Regular School	Yes	Other	04	12	2017	grade_8	3.0	3
128960	HI	school	1500030	1	Hawaii Department of Education	150003000273	543	EDUC LAB: A HAWAII NC-PCS	charter	Regular School	Yes	Other	KG	12	2017	grade_8	52.0	52
128959	HI	school	1500030	1	Hawaii Department of Education	150003000262	396	CONNECTIONS-PCS	charter	Regular School	Yes	Other	KG	12	2017	grade_8	42.0	42
128958	HI	school	1500030	1	Hawaii Department of Education	150003000094	463	WILCOX		Regular School	No	Elementary	PK	5	2017	grade_8	0.0	0
128957	HI	school	1500030	1	Hawaii Department of Education	150003000093	462	WAIMEA HI		Regular School	No	High	09	12	2017	grade_8	0.0	0
128956	HI	school	1500030	1	Hawaii Department of Education	150003000092	464	WAIMEA CANYON		Regular School	No	Middle	06	8	2017	grade_8	107.0	107
128955	HI	school	1500030	1	Hawaii Department of Education	150003000091	461	NIIHAU		Regular School	No	Other	PK	12	2017	grade_8	0.0	0
128954	HI	school	1500030	1	Hawaii Department of Education	150003000090	460	KOLOA		Regular School	No	Elementary	PK	5	2017	grade_8	0.0	0
128953	HI	school	1500030	1	Hawaii Department of Education	150003000089	459	KILAUEA		Regular School	No	Elementary	PK	6	2017	grade_8	0.0	0
128952	HI	school	1500030	1	Hawaii Department of Education	150003000088	458	KEKAHA		Regular School	No	Elementary	PK	5	2017	grade_8	0.0	0
128951	HI	school	1500030	1	Hawaii Department of Education	150003000242	457	KAUMUALII		Regular School	No	Elementary	PK	5	2017	grade_8	0.0	0
128950	HI	school	1500030	1	Hawaii Department of Education	150003000086	456	KAUAI HI		Regular School	No	High	09	12	2017	grade_8	0.0	0
128949	HI	school	1500030	1	Hawaii Department of Education	150003000255	447	KAPAA MID		Regular School	No	Middle	06	8	2017	grade_8	224.0	224
128948	HI	school	1500030	1	Hawaii Department of Education	150003000085	455	KAPAA HI		Regular School	No	High	09	12	2017	grade_8	0.0	0
128947	HI	school	1500030	1	Hawaii Department of Education	150003000084	454	KAPAA EL		Regular School	No	Elementary	PK	5	2017	grade_8	0.0	0
128946	HI	school	1500030	1	Hawaii Department of Education	150003000266	448	KAMAKAHELEI MID		Regular School	No	Middle	06	8	2017	grade_8	272.0	272
128945	HI	school	1500030	1	Hawaii Department of Education	150003000083	453	KALAHEO		Regular School	No	Elementary	PK	5	2017	grade_8	0.0	0
128944	HI	school	1500030	1	Hawaii Department of Education	150003000082	452	HANALEI		Regular School	No	Elementary	PK	6	2017	grade_8	0.0	0
128943	HI	school	1500030	1	Hawaii Department of Education	150003000081	451	ELEELE		Regular School	No	Elementary	PK	5	2017	grade_8	0.0	0
128942	HI	school	1500030	1	Hawaii Department of Education	150003000237	429	NAHIENAENA		Regular School	No	Elementary	PK	5	2017	grade_8	0.0	0
128941	HI	school	1500030	1	Hawaii Department of Education	150003000290	434	MOLOKAI MID		Regular School	No	Middle	07	8	2017	grade_8	63.0	63
128940	HI	school	1500030	1	Hawaii Department of Education	150003000075	421	MOLOKAI HI		Regular School	No	High	09	12	2017	grade_8	0.0	0
128939	HI	school	1500030	1	Hawaii Department of Education	150003000074	419	MAUNALOA		Regular School	No	Elementary	PK	6	2017	grade_8	0.0	0
128938	HI	school	1500030	1	Hawaii Department of Education	150003000070	415	LANAI HI & EL		Regular School	No	Other	PK	12	2017	grade_8	36.0	36
128937	HI	school	1500030	1	Hawaii Department of Education	150003000069	414	LAHAINALUNA HI		Regular School	No	High	09	12	2017	grade_8	0.0	0
128936	HI	school	1500030	1	Hawaii Department of Education	150003000068	413	LAHAINA INT		Regular School	No	Middle	06	8	2017	grade_8	200.0	200
128935	HI	school	1500030	1	Hawaii Department of Education	150003000065	410	KILOHANA		Regular School	No	Elementary	PK	6	2017	grade_8	0.0	0
128934	HI	school	1500030	1	Hawaii Department of Education	150003000062	407	KAUNAKAKAI		Regular School	No	Elementary	PK	6	2017	grade_8	0.0	0
128933	HI	school	1500030	1	Hawaii Department of Education	150003000061	406	KAMEHAMEHA III		Regular School	No	Elementary	PK	5	2017	grade_8	0.0	0
128932	HI	school	1500030	1	Hawaii Department of Education	150003000058	402	HANA HI & EL		Regular School	No	Other	PK	12	2017	grade_8	21.0	21
128931	HI	school	1500030	1	Hawaii Department of Education	150003000080	425	WAILUKU		Regular School	No	Elementary	PK	5	2017	grade_8	0.0	0
128930	HI	school	1500030	1	Hawaii Department of Education	150003000079	424	WAIHEE		Regular School	No	Elementary	PK	5	2017	grade_8	0.0	0
128929	HI	school	1500030	1	Hawaii Department of Education	150003000297	436	PUU KUKUI		Regular School	No	Elementary	PK	5	2017	grade_8	0.0	0
128928	HI	school	1500030	1	Hawaii Department of Education	150003000077	426	PUKALANI		Regular School	No	Elementary	PK	5	2017	grade_8	0.0	0
128927	HI	school	1500030	1	Hawaii Department of Education	150003000292	433	POMAIKAI		Regular School	No	Elementary	PK	5	2017	grade_8	0.0	0
128926	HI	school	1500030	1	Hawaii Department of Education	150003000076	422	PAIA		Regular School	No	Elementary	PK	5	2017	grade_8	0.0	0
128925	HI	school	1500030	1	Hawaii Department of Education	150003000241	428	MAUI WAENA INT		Regular School	No	Middle	06	8	2017	grade_8	349.0	349
128924	HI	school	1500030	1	Hawaii Department of Education	150003000073	418	MAUI HI		Regular School	No	High	09	12	2017	grade_8	0.0	0
128923	HI	school	1500030	1	Hawaii Department of Education	150003000072	417	MAKAWAO		Regular School	No	Elementary	PK	5	2017	grade_8	0.0	0
128922	HI	school	1500030	1	Hawaii Department of Education	150003000238	430	LOKELANI INT		Regular School	No	Middle	06	8	2017	grade_8	168.0	168
128921	HI	school	1500030	1	Hawaii Department of Education	150003000071	416	LIHIKAI		Regular School	No	Elementary	PK	5	2017	grade_8	0.0	0
128920	HI	school	1500030	1	Hawaii Department of Education	150003000067	412	KULA		Regular School	No	Elementary	PK	5	2017	grade_8	0.0	0
128919	HI	school	1500030	1	Hawaii Department of Education	150003000064	409	KIHEI		Regular School	No	Elementary	PK	5	2017	grade_8	0.0	0
128918	HI	school	1500030	1	Hawaii Department of Education	150003000251	435	KEKAULIKE HI		Regular School	No	High	09	12	2017	grade_8	0.0	0
128917	HI	school	1500030	1	Hawaii Department of Education	150003000253	431	KAMALII		Regular School	No	Elementary	PK	5	2017	grade_8	0.0	0
128916	HI	school	1500030	1	Hawaii Department of Education	150003000233	420	KALAMA INT		Regular School	No	Middle	06	8	2017	grade_8	245.0	245
128915	HI	school	1500030	1	Hawaii Department of Education	150003000060	405	KAHULUI		Regular School	No	Elementary	PK	5	2017	grade_8	0.0	0
128914	HI	school	1500030	1	Hawaii Department of Education	150003000059	404	IAO INT		Regular School	No	Middle	06	8	2017	grade_8	239.0	239
128913	HI	school	1500030	1	Hawaii Department of Education	150003000057	401	HAIKU		Regular School	No	Elementary	PK	5	2017	grade_8	0.0	0
128912	HI	school	1500030	1	Hawaii Department of Education	150003000056	400	BALDWIN HI		Regular School	No	High	09	12	2017	grade_8	0.0	0
128911	HI	school	1500030	1	Hawaii Department of Education	150003000050	383	PAHOA HI & INT		Regular School	No	High	07	12	2017	grade_8	66.0	66
128910	HI	school	1500030	1	Hawaii Department of Education	150003000234	381	PAHOA EL		Regular School	No	Elementary	PK	6	2017	grade_8	0.0	0
128909	HI	school	1500030	1	Hawaii Department of Education	150003000048	380	NAALEHU		Regular School	No	Elementary	PK	6	2017	grade_8	0.0	0
128908	HI	school	1500030	1	Hawaii Department of Education	150003000047	379	MT VIEW EL		Regular School	No	Elementary	PK	5	2017	grade_8	0.0	0
128907	HI	school	1500030	1	Hawaii Department of Education	150003000244	391	KEONEPOKO		Regular School	No	Elementary	PK	6	2017	grade_8	0.0	0
128906	HI	school	1500030	1	Hawaii Department of Education	150003000040	370	KEAAU MID		Regular School	No	Middle	06	8	2017	grade_8	207.0	207
128905	HI	school	1500030	1	Hawaii Department of Education	150003000260	354	KEAAU HI		Regular School	No	High	09	12	2017	grade_8	0.0	0
128904	HI	school	1500030	1	Hawaii Department of Education	150003000258	353	KEAAU EL		Regular School	No	Elementary	PK	5	2017	grade_8	0.0	0
128903	HI	school	1500030	1	Hawaii Department of Education	150003000038	368	KAU HI/PAHALA EL		Regular School	No	Other	PK	12	2017	grade_8	60.0	60
128902	HI	school	1500030	1	Hawaii Department of Education	150003000055	387	WAIMEA EL		Regular School	No	Elementary	PK	5	2017	grade_8	0.0	0
128901	HI	school	1500030	1	Hawaii Department of Education	150003000247	393	WAIKOLOA		Regular School	No	Elementary	PK	8	2017	grade_8	63.0	63
128900	HI	school	1500030	1	Hawaii Department of Education	150003000049	382	PAAUILO EL & INT		Regular School	No	Other	PK	9	2017	grade_8	19.0	19
128899	HI	school	1500030	1	Hawaii Department of Education	150003000252	376	KONAWAENA MID		Regular School	No	Middle	06	8	2017	grade_8	148.0	148
128898	HI	school	1500030	1	Hawaii Department of Education	150003000045	374	KONAWAENA HI		Regular School	No	High	09	12	2017	grade_8	0.0	0
128897	HI	school	1500030	1	Hawaii Department of Education	150003000044	375	KONAWAENA EL		Regular School	No	Elementary	PK	5	2017	grade_8	0.0	0
128896	HI	school	1500030	1	Hawaii Department of Education	150003000267	366	KOHALA MID		Regular School	No	Middle	06	8	2017	grade_8	52.0	52
128895	HI	school	1500030	1	Hawaii Department of Education	150003000043	373	KOHALA HI		Regular School	No	High	09	12	2017	grade_8	0.0	0
128894	HI	school	1500030	1	Hawaii Department of Education	150003000250	395	KOHALA EL		Regular School	No	Elementary	PK	5	2017	grade_8	0.0	0
128893	HI	school	1500030	1	Hawaii Department of Education	150003000235	390	KEALAKEHE INT		Regular School	No	Middle	06	8	2017	grade_8	234.0	234
128892	HI	school	1500030	1	Hawaii Department of Education	150003000254	392	KEALAKEHE HI		Regular School	No	High	09	12	2017	grade_8	0.0	0