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 (school_state_id > :p3 or (school_state_id = :p3 and rowid > :p2)) order by school_state_id, 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
2736472	HI	school	1500030	1	Hawaii Department of Education	150003000227	100	Aina Haina Elem	Regular School	No	Elementary	PK	5	2019	grade_8	0.0	0
2781522	HI	school	1500030	1	Hawaii Department of Education	150003000227	100	Aina Haina Elem	Regular School	No	Elementary	PK	5	2018	grade_8	0.0	0
109725	HI	school	1500030	1	Hawaii Department of Education	150003000226	101	ALA WAI	Regular School	No	1	PK	5	2016	grade_8	0.0	0
128728	HI	school	1500030	1	Hawaii Department of Education	150003000226	101	ALA WAI	Regular School	No	Elementary	PK	5	2017	grade_8	0.0	0
279705	HI	school	1500030	1	Hawaii Department of Education	150003000226	101	ALA WAI	Regular School	No	1	PK	5	2015	grade_8	0.0	0
2430835	HI	school	1500030	1	Hawaii Department of Education	150003000226	101	Ala Wai Elem	Regular School	No	Elementary	PK	5	2020	grade_8	0.0	0
2455524	HI	school	1500030	1	Hawaii Department of Education	150003000226	101	Ala Wai Elem	Regular School	No	Elementary	PK	5	2021	grade_8	0.0	0
2736497	HI	school	1500030	1	Hawaii Department of Education	150003000226	101	Ala Wai Elem	Regular School	No	Elementary	PK	5	2019	grade_8	0.0	0
2781547	HI	school	1500030	1	Hawaii Department of Education	150003000226	101	Ala Wai Elem	Regular School	No	Elementary	PK	5	2018	grade_8	0.0	0
109726	HI	school	1500030	1	Hawaii Department of Education	150003000225	102	ALIIOLANI	Regular School	No	1	PK	5	2016	grade_8	0.0	0
128729	HI	school	1500030	1	Hawaii Department of Education	150003000225	102	ALIIOLANI	Regular School	No	Elementary	PK	5	2017	grade_8	0.0	0
279706	HI	school	1500030	1	Hawaii Department of Education	150003000225	102	ALIIOLANI	Regular School	No	1	PK	5	2015	grade_8	0.0	0
2430836	HI	school	1500030	1	Hawaii Department of Education	150003000225	102	Aliiolani Elem	Regular School	No	Elementary	PK	5	2020	grade_8	0.0	0
2455525	HI	school	1500030	1	Hawaii Department of Education	150003000225	102	Aliiolani Elem	Regular School	No	Elementary	PK	5	2021	grade_8	0.0	0
2736498	HI	school	1500030	1	Hawaii Department of Education	150003000225	102	Aliiolani Elem	Regular School	No	Elementary	PK	5	2019	grade_8	0.0	0
2781548	HI	school	1500030	1	Hawaii Department of Education	150003000225	102	Aliiolani Elem	Regular School	No	Elementary	PK	5	2018	grade_8	0.0	0
109727	HI	school	1500030	1	Hawaii Department of Education	150003000246	103	ANUENUE	Regular School	No	4	PK	12	2016	grade_8	31.0	31
128730	HI	school	1500030	1	Hawaii Department of Education	150003000246	103	ANUENUE	Regular School	No	Other	PK	12	2017	grade_8	30.0	30
279707	HI	school	1500030	1	Hawaii Department of Education	150003000246	103	ANUENUE	Regular School	No	4	PK	12	2015	grade_8	22.0	22
2430837	HI	school	1500030	1	Hawaii Department of Education	150003000246	103	Anuenue	Regular School	No	Other	PK	12	2020	grade_8	38.0	38
2455526	HI	school	1500030	1	Hawaii Department of Education	150003000246	103	Anuenue	Regular School	No	Other	PK	12	2021	grade_8	32.0	32
2736499	HI	school	1500030	1	Hawaii Department of Education	150003000246	103	Anuenue	Regular School	No	Other	PK	12	2019	grade_8	24.0	24
2781549	HI	school	1500030	1	Hawaii Department of Education	150003000246	103	Anuenue	Regular School	No	Other	PK	12	2018	grade_8	25.0	25
109728	HI	school	1500030	1	Hawaii Department of Education	150003000223	104	CENTRAL MID	Regular School	No	2	06	8	2016	grade_8	106.0	106
128731	HI	school	1500030	1	Hawaii Department of Education	150003000223	104	CENTRAL MID	Regular School	No	Middle	06	8	2017	grade_8	118.0	118
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
2430838	HI	school	1500030	1	Hawaii Department of Education	150003000223	104	Central Middle	Regular School	No	Middle	06	8	2020	grade_8	118.0	118
2455527	HI	school	1500030	1	Hawaii Department of Education	150003000223	104	Central Middle	Regular School	No	Middle	06	8	2021	grade_8	105.0	105
2736500	HI	school	1500030	1	Hawaii Department of Education	150003000223	104	Central Middle	Regular School	No	Middle	06	8	2019	grade_8	118.0	118
2781550	HI	school	1500030	1	Hawaii Department of Education	150003000223	104	Central Middle	Regular School	No	Middle	06	8	2018	grade_8	102.0	102
109701	HI	school	1500030	1	Hawaii Department of Education	150003000222	105	DOLE MID	Regular School	No	2	06	8	2016	grade_8	225.0	225
128704	HI	school	1500030	1	Hawaii Department of Education	150003000222	105	DOLE MID	Regular School	No	Middle	06	8	2017	grade_8	201.0	201
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
2430811	HI	school	1500030	1	Hawaii Department of Education	150003000222	105	Dole Middle	Regular School	No	Middle	06	8	2020	grade_8	191.0	191
2455500	HI	school	1500030	1	Hawaii Department of Education	150003000222	105	Dole Middle	Regular School	No	Middle	06	8	2021	grade_8	183.0	183
2736473	HI	school	1500030	1	Hawaii Department of Education	150003000222	105	Dole Middle	Regular School	No	Middle	06	8	2019	grade_8	202.0	202
2781523	HI	school	1500030	1	Hawaii Department of Education	150003000222	105	Dole Middle	Regular School	No	Middle	06	8	2018	grade_8	210.0	210
109702	HI	school	1500030	1	Hawaii Department of Education	150003000221	106	FARRINGTON HI	Regular School	No	3	09	12	2016	grade_8	0.0	0
128705	HI	school	1500030	1	Hawaii Department of Education	150003000221	106	FARRINGTON HI	Regular School	No	High	09	12	2017	grade_8	0.0	0
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
2430812	HI	school	1500030	1	Hawaii Department of Education	150003000221	106	Farrington High	Regular School	No	High	09	12	2020	grade_8	0.0	0
2455501	HI	school	1500030	1	Hawaii Department of Education	150003000221	106	Farrington High	Regular School	No	High	09	12	2021	grade_8	0.0	0
2736474	HI	school	1500030	1	Hawaii Department of Education	150003000221	106	Farrington High	Regular School	No	High	09	12	2019	grade_8	0.0	0
2781524	HI	school	1500030	1	Hawaii Department of Education	150003000221	106	Farrington High	Regular School	No	High	09	12	2018	grade_8	0.0	0
109703	HI	school	1500030	1	Hawaii Department of Education	150003000220	107	FERN	Regular School	No	1	PK	5	2016	grade_8	0.0	0
128706	HI	school	1500030	1	Hawaii Department of Education	150003000220	107	FERN	Regular School	No	Elementary	PK	5	2017	grade_8	0.0	0
279683	HI	school	1500030	1	Hawaii Department of Education	150003000220	107	FERN	Regular School	No	1	PK	5	2015	grade_8	0.0	0
2430813	HI	school	1500030	1	Hawaii Department of Education	150003000220	107	Fern Elem	Regular School	No	Elementary	PK	5	2020	grade_8	0.0	0
2455502	HI	school	1500030	1	Hawaii Department of Education	150003000220	107	Fern Elem	Regular School	No	Elementary	PK	5	2021	grade_8	0.0	0
2736475	HI	school	1500030	1	Hawaii Department of Education	150003000220	107	Fern Elem	Regular School	No	Elementary	PK	5	2019	grade_8	0.0	0
2781525	HI	school	1500030	1	Hawaii Department of Education	150003000220	107	Fern Elem	Regular School	No	Elementary	PK	5	2018	grade_8	0.0	0
109704	HI	school	1500030	1	Hawaii Department of Education	150003000219	108	HAHAIONE	Regular School	No	1	PK	5	2016	grade_8	0.0	0
128707	HI	school	1500030	1	Hawaii Department of Education	150003000219	108	HAHAIONE	Regular School	No	Elementary	PK	5	2017	grade_8	0.0	0
279684	HI	school	1500030	1	Hawaii Department of Education	150003000219	108	HAHAIONE	Regular School	No	1	PK	5	2015	grade_8	0.0	0
2430814	HI	school	1500030	1	Hawaii Department of Education	150003000219	108	Hahaione Elem	Regular School	No	Elementary	PK	5	2020	grade_8	0.0	0
2455503	HI	school	1500030	1	Hawaii Department of Education	150003000219	108	Hahaione Elem	Regular School	No	Elementary	PK	5	2021	grade_8	0.0	0
2736476	HI	school	1500030	1	Hawaii Department of Education	150003000219	108	Hahaione Elem	Regular School	No	Elementary	PK	5	2019	grade_8	0.0	0
2781526	HI	school	1500030	1	Hawaii Department of Education	150003000219	108	Hahaione Elem	Regular School	No	Elementary	PK	5	2018	grade_8	0.0	0
109729	HI	school	1500030	1	Hawaii Department of Education	150003000214	109	HOKULANI	Regular School	No	1	PK	5	2016	grade_8	0.0	0
128732	HI	school	1500030	1	Hawaii Department of Education	150003000214	109	HOKULANI	Regular School	No	Elementary	PK	5	2017	grade_8	0.0	0
279709	HI	school	1500030	1	Hawaii Department of Education	150003000214	109	HOKULANI	Regular School	No	1	PK	5	2015	grade_8	0.0	0
2430839	HI	school	1500030	1	Hawaii Department of Education	150003000214	109	Hokulani Elem	Regular School	No	Elementary	PK	5	2020	grade_8	0.0	0
2455528	HI	school	1500030	1	Hawaii Department of Education	150003000214	109	Hokulani Elem	Regular School	No	Elementary	PK	5	2021	grade_8	0.0	0
2736501	HI	school	1500030	1	Hawaii Department of Education	150003000214	109	Hokulani Elem	Regular School	No	Elementary	PK	5	2019	grade_8	0.0	0
2781551	HI	school	1500030	1	Hawaii Department of Education	150003000214	109	Hokulani Elem	Regular School	No	Elementary	PK	5	2018	grade_8	0.0	0
109730	HI	school	1500030	1	Hawaii Department of Education	150003000218	110	JARRETT MID	Regular School	No	2	06	8	2016	grade_8	64.0	64
128733	HI	school	1500030	1	Hawaii Department of Education	150003000218	110	JARRETT MID	Regular School	No	Middle	06	8	2017	grade_8	71.0	71
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
2430840	HI	school	1500030	1	Hawaii Department of Education	150003000218	110	Jarrett Middle	Regular School	No	Middle	06	8	2020	grade_8	72.0	72
2455529	HI	school	1500030	1	Hawaii Department of Education	150003000218	110	Jarrett Middle	Regular School	No	Middle	06	8	2021	grade_8	83.0	83
2736502	HI	school	1500030	1	Hawaii Department of Education	150003000218	110	Jarrett Middle	Regular School	No	Middle	06	8	2019	grade_8	64.0	64
2781552	HI	school	1500030	1	Hawaii Department of Education	150003000218	110	Jarrett Middle	Regular School	No	Middle	06	8	2018	grade_8	74.0	74
109731	HI	school	1500030	1	Hawaii Department of Education	150003000213	111	JEFFERSON	Regular School	No	1	PK	5	2016	grade_8	0.0	0
128734	HI	school	1500030	1	Hawaii Department of Education	150003000213	111	JEFFERSON	Regular School	No	Elementary	PK	5	2017	grade_8	0.0	0
279711	HI	school	1500030	1	Hawaii Department of Education	150003000213	111	JEFFERSON	Regular School	No	1	PK	5	2015	grade_8	0.0	0
2430841	HI	school	1500030	1	Hawaii Department of Education	150003000213	111	Jefferson Elem	Regular School	No	Elementary	PK	5	2020	grade_8	0.0	0
2455530	HI	school	1500030	1	Hawaii Department of Education	150003000213	111	Jefferson Elem	Regular School	No	Elementary	PK	5	2021	grade_8	0.0	0
2736503	HI	school	1500030	1	Hawaii Department of Education	150003000213	111	Jefferson Elem	Regular School	No	Elementary	PK	5	2019	grade_8	0.0	0
2781553	HI	school	1500030	1	Hawaii Department of Education	150003000213	111	Jefferson Elem	Regular School	No	Elementary	PK	5	2018	grade_8	0.0	0
109732	HI	school	1500030	1	Hawaii Department of Education	150003000217	112	KAAHUMANU	Regular School	No	1	PK	5	2016	grade_8	0.0	0
128735	HI	school	1500030	1	Hawaii Department of Education	150003000217	112	KAAHUMANU	Regular School	No	Elementary	PK	5	2017	grade_8	0.0	0
279712	HI	school	1500030	1	Hawaii Department of Education	150003000217	112	KAAHUMANU	Regular School	No	1	PK	5	2015	grade_8	0.0	0
2430842	HI	school	1500030	1	Hawaii Department of Education	150003000217	112	Kaahumanu Elem	Regular School	No	Elementary	PK	5	2020	grade_8	0.0	0
2455531	HI	school	1500030	1	Hawaii Department of Education	150003000217	112	Kaahumanu Elem	Regular School	No	Elementary	PK	5	2021	grade_8	0.0	0
2736504	HI	school	1500030	1	Hawaii Department of Education	150003000217	112	Kaahumanu Elem	Regular School	No	Elementary	PK	5	2019	grade_8	0.0	0
2781554	HI	school	1500030	1	Hawaii Department of Education	150003000217	112	Kaahumanu Elem	Regular School	No	Elementary	PK	5	2018	grade_8	0.0	0
109706	HI	school	1500030	1	Hawaii Department of Education	150003000216	113	KAEWAI	Regular School	No	1	PK	5	2016	grade_8	0.0	0
128709	HI	school	1500030	1	Hawaii Department of Education	150003000216	113	KAEWAI	Regular School	No	Elementary	PK	5	2017	grade_8	0.0	0
279686	HI	school	1500030	1	Hawaii Department of Education	150003000216	113	KAEWAI	Regular School	No	1	PK	5	2015	grade_8	0.0	0
2430816	HI	school	1500030	1	Hawaii Department of Education	150003000216	113	Kaewai Elem	Regular School	No	Elementary	PK	5	2020	grade_8	0.0	0
2455505	HI	school	1500030	1	Hawaii Department of Education	150003000216	113	Kaewai Elem	Regular School	No	Elementary	PK	5	2021	grade_8	0.0	0
2736478	HI	school	1500030	1	Hawaii Department of Education	150003000216	113	Kaewai Elem	Regular School	No	Elementary	PK	5	2019	grade_8	0.0	0
2781528	HI	school	1500030	1	Hawaii Department of Education	150003000216	113	Kaewai Elem	Regular School	No	Elementary	PK	5	2018	grade_8	0.0	0
109707	HI	school	1500030	1	Hawaii Department of Education	150003000215	114	KAHALA	Regular School	No	1	PK	5	2016	grade_8	0.0	0
128710	HI	school	1500030	1	Hawaii Department of Education	150003000215	114	KAHALA	Regular School	No	Elementary	PK	5	2017	grade_8	0.0	0
279687	HI	school	1500030	1	Hawaii Department of Education	150003000215	114	KAHALA	Regular School	No	1	PK	5	2015	grade_8	0.0	0
2430817	HI	school	1500030	1	Hawaii Department of Education	150003000215	114	Kahala Elem	Regular School	No	Elementary	PK	5	2020	grade_8	0.0	0
2455506	HI	school	1500030	1	Hawaii Department of Education	150003000215	114	Kahala Elem	Regular School	No	Elementary	PK	5	2021	grade_8	0.0	0
2736479	HI	school	1500030	1	Hawaii Department of Education	150003000215	114	Kahala Elem	Regular School	No	Elementary	PK	5	2019	grade_8	0.0	0
2781529	HI	school	1500030	1	Hawaii Department of Education	150003000215	114	Kahala Elem	Regular School	No	Elementary	PK	5	2018	grade_8	0.0	0
109733	HI	school	1500030	1	Hawaii Department of Education	150003000212	115	KAIMUKI HI	Regular School	No	3	09	12	2016	grade_8	0.0	0