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
277953	HI	school	1500030	1	Hawaii Department of Education	150003000215	114	KAHALA	Regular School	No	1	PK	5	2015	grade_2	66.0	66
2429059	HI	school	1500030	1	Hawaii Department of Education	150003000215	114	Kahala Elem	Regular School	No	Elementary	PK	5	2020	grade_2	79.0	79
2453742	HI	school	1500030	1	Hawaii Department of Education	150003000215	114	Kahala Elem	Regular School	No	Elementary	PK	5	2021	grade_2	64.0	64
2734727	HI	school	1500030	1	Hawaii Department of Education	150003000215	114	Kahala Elem	Regular School	No	Elementary	PK	5	2019	grade_2	63.0	63
2779777	HI	school	1500030	1	Hawaii Department of Education	150003000215	114	Kahala Elem	Regular School	No	Elementary	PK	5	2018	grade_2	64.0	64
107993	HI	school	1500030	1	Hawaii Department of Education	150003000212	115	KAIMUKI HI	Regular School	No	3	09	12	2016	grade_2	0.0	0
126996	HI	school	1500030	1	Hawaii Department of Education	150003000212	115	KAIMUKI HI	Regular School	No	High	09	12	2017	grade_2	0.0	0
277979	HI	school	1500030	1	Hawaii Department of Education	150003000212	115	KAIMUKI HI	Regular School	No	3	09	12	2015	grade_2	0.0	0
2429085	HI	school	1500030	1	Hawaii Department of Education	150003000212	115	Kaimuki High	Regular School	No	High	09	12	2020	grade_2	0.0	0
2453768	HI	school	1500030	1	Hawaii Department of Education	150003000212	115	Kaimuki High	Regular School	No	High	09	12	2021	grade_2	0.0	0
2734753	HI	school	1500030	1	Hawaii Department of Education	150003000212	115	Kaimuki High	Regular School	No	High	09	12	2019	grade_2	0.0	0
2779803	HI	school	1500030	1	Hawaii Department of Education	150003000212	115	Kaimuki High	Regular School	No	High	09	12	2018	grade_2	0.0	0
107968	HI	school	1500030	1	Hawaii Department of Education	150003000211	116	KAIMUKI MID	Regular School	No	2	06	8	2016	grade_2	0.0	0
126971	HI	school	1500030	1	Hawaii Department of Education	150003000211	116	KAIMUKI MID	Regular School	No	Middle	06	8	2017	grade_2	0.0	0
277954	HI	school	1500030	1	Hawaii Department of Education	150003000211	116	KAIMUKI MID	Regular School	No	2	06	8	2015	grade_2	0.0	0
2429060	HI	school	1500030	1	Hawaii Department of Education	150003000211	116	Kaimuki Middle	Regular School	No	Middle	06	8	2020	grade_2	0.0	0
2453743	HI	school	1500030	1	Hawaii Department of Education	150003000211	116	Kaimuki Middle	Regular School	No	Middle	06	8	2021	grade_2	0.0	0
2734728	HI	school	1500030	1	Hawaii Department of Education	150003000211	116	Kaimuki Middle	Regular School	No	Middle	06	8	2019	grade_2	0.0	0
2779778	HI	school	1500030	1	Hawaii Department of Education	150003000211	116	Kaimuki Middle	Regular School	No	Middle	06	8	2018	grade_2	0.0	0
107994	HI	school	1500030	1	Hawaii Department of Education	150003000165	117	KAIULANI	Regular School	No	1	PK	5	2016	grade_2	61.0	61
126997	HI	school	1500030	1	Hawaii Department of Education	150003000165	117	KAIULANI	Regular School	No	Elementary	PK	5	2017	grade_2	56.0	56
277980	HI	school	1500030	1	Hawaii Department of Education	150003000165	117	KAIULANI	Regular School	No	1	PK	5	2015	grade_2	41.0	41
2429086	HI	school	1500030	1	Hawaii Department of Education	150003000165	117	Kaiulani Elem	Regular School	No	Elementary	PK	5	2020	grade_2	52.0	52
2453769	HI	school	1500030	1	Hawaii Department of Education	150003000165	117	Kaiulani Elem	Regular School	No	Elementary	PK	5	2021	grade_2	51.0	51
2734754	HI	school	1500030	1	Hawaii Department of Education	150003000165	117	Kaiulani Elem	Regular School	No	Elementary	PK	5	2019	grade_2	61.0	61
2779804	HI	school	1500030	1	Hawaii Department of Education	150003000165	117	Kaiulani Elem	Regular School	No	Elementary	PK	5	2018	grade_2	59.0	59
107970	HI	school	1500030	1	Hawaii Department of Education	150003000164	118	KALAKAUA MID	Regular School	No	2	06	8	2016	grade_2	0.0	0
126973	HI	school	1500030	1	Hawaii Department of Education	150003000164	118	KALAKAUA MID	Regular School	No	Middle	06	8	2017	grade_2	0.0	0
277956	HI	school	1500030	1	Hawaii Department of Education	150003000164	118	KALAKAUA MID	Regular School	No	2	06	8	2015	grade_2	0.0	0
2429062	HI	school	1500030	1	Hawaii Department of Education	150003000164	118	Kalakaua Middle	Regular School	No	Middle	06	8	2020	grade_2	0.0	0
2453745	HI	school	1500030	1	Hawaii Department of Education	150003000164	118	Kalakaua Middle	Regular School	No	Middle	06	8	2021	grade_2	0.0	0
2734730	HI	school	1500030	1	Hawaii Department of Education	150003000164	118	Kalakaua Middle	Regular School	No	Middle	06	8	2019	grade_2	0.0	0
2779780	HI	school	1500030	1	Hawaii Department of Education	150003000164	118	Kalakaua Middle	Regular School	No	Middle	06	8	2018	grade_2	0.0	0
107971	HI	school	1500030	1	Hawaii Department of Education	150003000163	119	KALANI HI	Regular School	No	3	09	12	2016	grade_2	0.0	0
126974	HI	school	1500030	1	Hawaii Department of Education	150003000163	119	KALANI HI	Regular School	No	High	09	12	2017	grade_2	0.0	0
277957	HI	school	1500030	1	Hawaii Department of Education	150003000163	119	KALANI HI	Regular School	No	3	09	12	2015	grade_2	0.0	0
2429063	HI	school	1500030	1	Hawaii Department of Education	150003000163	119	Kalani High	Regular School	No	High	09	12	2020	grade_2	0.0	0
2453746	HI	school	1500030	1	Hawaii Department of Education	150003000163	119	Kalani High	Regular School	No	High	09	12	2021	grade_2	0.0	0
2734731	HI	school	1500030	1	Hawaii Department of Education	150003000163	119	Kalani High	Regular School	No	High	09	12	2019	grade_2	0.0	0
2779781	HI	school	1500030	1	Hawaii Department of Education	150003000163	119	Kalani High	Regular School	No	High	09	12	2018	grade_2	0.0	0
107972	HI	school	1500030	1	Hawaii Department of Education	150003000162	120	KALIHI	Regular School	No	1	PK	5	2016	grade_2	46.0	46
126975	HI	school	1500030	1	Hawaii Department of Education	150003000162	120	KALIHI	Regular School	No	Elementary	PK	5	2017	grade_2	32.0	32
277958	HI	school	1500030	1	Hawaii Department of Education	150003000162	120	KALIHI	Regular School	No	1	PK	5	2015	grade_2	57.0	57
2429064	HI	school	1500030	1	Hawaii Department of Education	150003000162	120	Kalihi Elem	Regular School	No	Elementary	PK	5	2020	grade_2	39.0	39
2453747	HI	school	1500030	1	Hawaii Department of Education	150003000162	120	Kalihi Elem	Regular School	No	Elementary	PK	5	2021	grade_2	32.0	32
2734732	HI	school	1500030	1	Hawaii Department of Education	150003000162	120	Kalihi Elem	Regular School	No	Elementary	PK	5	2019	grade_2	36.0	36
2779782	HI	school	1500030	1	Hawaii Department of Education	150003000162	120	Kalihi Elem	Regular School	No	Elementary	PK	5	2018	grade_2	39.0	39
107973	HI	school	1500030	1	Hawaii Department of Education	150003000160	121	KALIHI-KAI	Regular School	No	1	PK	5	2016	grade_2	96.0	96
126976	HI	school	1500030	1	Hawaii Department of Education	150003000160	121	KALIHI-KAI	Regular School	No	Elementary	PK	5	2017	grade_2	66.0	66
277959	HI	school	1500030	1	Hawaii Department of Education	150003000160	121	KALIHI-KAI	Regular School	No	1	PK	5	2015	grade_2	91.0	91
2429065	HI	school	1500030	1	Hawaii Department of Education	150003000160	121	Kalihi Kai Elem	Regular School	No	Elementary	PK	5	2020	grade_2	77.0	77
2453748	HI	school	1500030	1	Hawaii Department of Education	150003000160	121	Kalihi Kai Elem	Regular School	No	Elementary	PK	5	2021	grade_2	98.0	98
2734733	HI	school	1500030	1	Hawaii Department of Education	150003000160	121	Kalihi Kai Elem	Regular School	No	Elementary	PK	5	2019	grade_2	84.0	84
2779783	HI	school	1500030	1	Hawaii Department of Education	150003000160	121	Kalihi Kai Elem	Regular School	No	Elementary	PK	5	2018	grade_2	100.0	100
107974	HI	school	1500030	1	Hawaii Department of Education	150003000210	122	KALIHI-UKA	Regular School	No	1	PK	5	2016	grade_2	36.0	36
126977	HI	school	1500030	1	Hawaii Department of Education	150003000210	122	KALIHI-UKA	Regular School	No	Elementary	PK	5	2017	grade_2	35.0	35
277960	HI	school	1500030	1	Hawaii Department of Education	150003000210	122	KALIHI-UKA	Regular School	No	1	PK	5	2015	grade_2	40.0	40
2429066	HI	school	1500030	1	Hawaii Department of Education	150003000210	122	Kalihi Uka Elem	Regular School	No	Elementary	PK	5	2020	grade_2	42.0	42
2453749	HI	school	1500030	1	Hawaii Department of Education	150003000210	122	Kalihi Uka Elem	Regular School	No	Elementary	PK	5	2021	grade_2	55.0	55
2734734	HI	school	1500030	1	Hawaii Department of Education	150003000210	122	Kalihi Uka Elem	Regular School	No	Elementary	PK	5	2019	grade_2	23.0	23
2779784	HI	school	1500030	1	Hawaii Department of Education	150003000210	122	Kalihi Uka Elem	Regular School	No	Elementary	PK	5	2018	grade_2	44.0	44
107975	HI	school	1500030	1	Hawaii Department of Education	150003000209	123	KALIHI-WAENA	Regular School	No	1	PK	5	2016	grade_2	92.0	92
126978	HI	school	1500030	1	Hawaii Department of Education	150003000209	123	KALIHI-WAENA	Regular School	No	Elementary	PK	5	2017	grade_2	57.0	57
277961	HI	school	1500030	1	Hawaii Department of Education	150003000209	123	KALIHI-WAENA	Regular School	No	1	PK	5	2015	grade_2	94.0	94
2429067	HI	school	1500030	1	Hawaii Department of Education	150003000209	123	Kalihi Waena Elem	Regular School	No	Elementary	PK	5	2020	grade_2	91.0	91
2453750	HI	school	1500030	1	Hawaii Department of Education	150003000209	123	Kalihi Waena Elem	Regular School	No	Elementary	PK	5	2021	grade_2	87.0	87
2734735	HI	school	1500030	1	Hawaii Department of Education	150003000209	123	Kalihi Waena Elem	Regular School	No	Elementary	PK	5	2019	grade_2	80.0	80
2779785	HI	school	1500030	1	Hawaii Department of Education	150003000209	123	Kalihi Waena Elem	Regular School	No	Elementary	PK	5	2018	grade_2	97.0	97
107977	HI	school	1500030	1	Hawaii Department of Education	150003000207	124	KAPALAMA	Regular School	No	1	PK	5	2016	grade_2	95.0	95
126980	HI	school	1500030	1	Hawaii Department of Education	150003000207	124	KAPALAMA	Regular School	No	Elementary	PK	5	2017	grade_2	66.0	66
277963	HI	school	1500030	1	Hawaii Department of Education	150003000207	124	KAPALAMA	Regular School	No	1	PK	5	2015	grade_2	98.0	98
2429069	HI	school	1500030	1	Hawaii Department of Education	150003000207	124	Kapalama Elem	Regular School	No	Elementary	PK	5	2020	grade_2	106.0	106
2453752	HI	school	1500030	1	Hawaii Department of Education	150003000207	124	Kapalama Elem	Regular School	No	Elementary	PK	5	2021	grade_2	98.0	98
2734737	HI	school	1500030	1	Hawaii Department of Education	150003000207	124	Kapalama Elem	Regular School	No	Elementary	PK	5	2019	grade_2	94.0	94
2779787	HI	school	1500030	1	Hawaii Department of Education	150003000207	124	Kapalama Elem	Regular School	No	Elementary	PK	5	2018	grade_2	98.0	98
107995	HI	school	1500030	1	Hawaii Department of Education	150003000206	125	KAULUWELA	Regular School	No	1	PK	5	2016	grade_2	57.0	57
126998	HI	school	1500030	1	Hawaii Department of Education	150003000206	125	KAULUWELA	Regular School	No	Elementary	PK	5	2017	grade_2	40.0	40
277981	HI	school	1500030	1	Hawaii Department of Education	150003000206	125	KAULUWELA	Regular School	No	1	PK	5	2015	grade_2	61.0	61
2429087	HI	school	1500030	1	Hawaii Department of Education	150003000206	125	Kauluwela Elem	Regular School	No	Elementary	PK	5	2020	grade_2	79.0	79
2453770	HI	school	1500030	1	Hawaii Department of Education	150003000206	125	Kauluwela Elem	Regular School	No	Elementary	PK	5	2021	grade_2	90.0	90
2734755	HI	school	1500030	1	Hawaii Department of Education	150003000206	125	Kauluwela Elem	Regular School	No	Elementary	PK	5	2019	grade_2	70.0	70
2779805	HI	school	1500030	1	Hawaii Department of Education	150003000206	125	Kauluwela Elem	Regular School	No	Elementary	PK	5	2018	grade_2	70.0	70
107996	HI	school	1500030	1	Hawaii Department of Education	150003000205	126	KAWANANAKOA MID	Regular School	No	2	06	8	2016	grade_2	0.0	0
126999	HI	school	1500030	1	Hawaii Department of Education	150003000205	126	KAWANANAKOA MID	Regular School	No	Middle	06	8	2017	grade_2	0.0	0
277982	HI	school	1500030	1	Hawaii Department of Education	150003000205	126	KAWANANAKOA MID	Regular School	No	2	06	8	2015	grade_2	0.0	0
2429088	HI	school	1500030	1	Hawaii Department of Education	150003000205	126	Kawananakoa Middle	Regular School	No	Middle	06	8	2020	grade_2	0.0	0
2453771	HI	school	1500030	1	Hawaii Department of Education	150003000205	126	Kawananakoa Middle	Regular School	No	Middle	06	8	2021	grade_2	0.0	0
2734756	HI	school	1500030	1	Hawaii Department of Education	150003000205	126	Kawananakoa Middle	Regular School	No	Middle	06	8	2019	grade_2	0.0	0
2779806	HI	school	1500030	1	Hawaii Department of Education	150003000205	126	Kawananakoa Middle	Regular School	No	Middle	06	8	2018	grade_2	0.0	0
107978	HI	school	1500030	1	Hawaii Department of Education	150003000204	127	KOKO HEAD	Regular School	No	1	PK	5	2016	grade_2	49.0	49
126981	HI	school	1500030	1	Hawaii Department of Education	150003000204	127	KOKO HEAD	Regular School	No	Elementary	PK	5	2017	grade_2	32.0	32
277964	HI	school	1500030	1	Hawaii Department of Education	150003000204	127	KOKO HEAD	Regular School	No	1	PK	5	2015	grade_2	55.0	55
2429070	HI	school	1500030	1	Hawaii Department of Education	150003000204	127	Koko Head Elem	Regular School	No	Elementary	PK	5	2020	grade_2	50.0	50
2453753	HI	school	1500030	1	Hawaii Department of Education	150003000204	127	Koko Head Elem	Regular School	No	Elementary	PK	5	2021	grade_2	46.0	46
2734738	HI	school	1500030	1	Hawaii Department of Education	150003000204	127	Koko Head Elem	Regular School	No	Elementary	PK	5	2019	grade_2	39.0	39
2779788	HI	school	1500030	1	Hawaii Department of Education	150003000204	127	Koko Head Elem	Regular School	No	Elementary	PK	5	2018	grade_2	47.0	47
107997	HI	school	1500030	1	Hawaii Department of Education	150003000203	128	KUHIO	Regular School	No	1	PK	5	2016	grade_2	53.0	53
127000	HI	school	1500030	1	Hawaii Department of Education	150003000203	128	KUHIO	Regular School	No	Elementary	PK	5	2017	grade_2	17.0	17
277983	HI	school	1500030	1	Hawaii Department of Education	150003000203	128	KUHIO	Regular School	No	1	PK	5	2015	grade_2	52.0	52
2429089	HI	school	1500030	1	Hawaii Department of Education	150003000203	128	Kuhio Elem	Regular School	No	Elementary	PK	5	2020	grade_2	26.0	26
2453772	HI	school	1500030	1	Hawaii Department of Education	150003000203	128	Kuhio Elem	Regular School	No	Elementary	PK	5	2021	grade_2	26.0	26