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
280265	HI	school	1500030	1	Hawaii Department of Education	150003000215	114	KAHALA	Regular School	No	1	PK	5	2015	grade_10	0.0	0
2431403	HI	school	1500030	1	Hawaii Department of Education	150003000215	114	Kahala Elem	Regular School	No	Elementary	PK	5	2020	grade_10	0.0	0
2456094	HI	school	1500030	1	Hawaii Department of Education	150003000215	114	Kahala Elem	Regular School	No	Elementary	PK	5	2021	grade_10	0.0	0
2737063	HI	school	1500030	1	Hawaii Department of Education	150003000215	114	Kahala Elem	Regular School	No	Elementary	PK	5	2019	grade_10	0.0	0
2782113	HI	school	1500030	1	Hawaii Department of Education	150003000215	114	Kahala Elem	Regular School	No	Elementary	PK	5	2018	grade_10	0.0	0
110313	HI	school	1500030	1	Hawaii Department of Education	150003000212	115	KAIMUKI HI	Regular School	No	3	09	12	2016	grade_10	178.0	178
129316	HI	school	1500030	1	Hawaii Department of Education	150003000212	115	KAIMUKI HI	Regular School	No	High	09	12	2017	grade_10	162.0	162
280291	HI	school	1500030	1	Hawaii Department of Education	150003000212	115	KAIMUKI HI	Regular School	No	3	09	12	2015	grade_10	172.0	172
2431429	HI	school	1500030	1	Hawaii Department of Education	150003000212	115	Kaimuki High	Regular School	No	High	09	12	2020	grade_10	151.0	151
2456120	HI	school	1500030	1	Hawaii Department of Education	150003000212	115	Kaimuki High	Regular School	No	High	09	12	2021	grade_10	143.0	143
2737089	HI	school	1500030	1	Hawaii Department of Education	150003000212	115	Kaimuki High	Regular School	No	High	09	12	2019	grade_10	158.0	158
2782139	HI	school	1500030	1	Hawaii Department of Education	150003000212	115	Kaimuki High	Regular School	No	High	09	12	2018	grade_10	158.0	158
110288	HI	school	1500030	1	Hawaii Department of Education	150003000211	116	KAIMUKI MID	Regular School	No	2	06	8	2016	grade_10	0.0	0
129291	HI	school	1500030	1	Hawaii Department of Education	150003000211	116	KAIMUKI MID	Regular School	No	Middle	06	8	2017	grade_10	0.0	0
280266	HI	school	1500030	1	Hawaii Department of Education	150003000211	116	KAIMUKI MID	Regular School	No	2	06	8	2015	grade_10	0.0	0
2431404	HI	school	1500030	1	Hawaii Department of Education	150003000211	116	Kaimuki Middle	Regular School	No	Middle	06	8	2020	grade_10	0.0	0
2456095	HI	school	1500030	1	Hawaii Department of Education	150003000211	116	Kaimuki Middle	Regular School	No	Middle	06	8	2021	grade_10	0.0	0
2737064	HI	school	1500030	1	Hawaii Department of Education	150003000211	116	Kaimuki Middle	Regular School	No	Middle	06	8	2019	grade_10	0.0	0
2782114	HI	school	1500030	1	Hawaii Department of Education	150003000211	116	Kaimuki Middle	Regular School	No	Middle	06	8	2018	grade_10	0.0	0
110314	HI	school	1500030	1	Hawaii Department of Education	150003000165	117	KAIULANI	Regular School	No	1	PK	5	2016	grade_10	0.0	0
129317	HI	school	1500030	1	Hawaii Department of Education	150003000165	117	KAIULANI	Regular School	No	Elementary	PK	5	2017	grade_10	0.0	0
280292	HI	school	1500030	1	Hawaii Department of Education	150003000165	117	KAIULANI	Regular School	No	1	PK	5	2015	grade_10	0.0	0
2431430	HI	school	1500030	1	Hawaii Department of Education	150003000165	117	Kaiulani Elem	Regular School	No	Elementary	PK	5	2020	grade_10	0.0	0
2456121	HI	school	1500030	1	Hawaii Department of Education	150003000165	117	Kaiulani Elem	Regular School	No	Elementary	PK	5	2021	grade_10	0.0	0
2737090	HI	school	1500030	1	Hawaii Department of Education	150003000165	117	Kaiulani Elem	Regular School	No	Elementary	PK	5	2019	grade_10	0.0	0
2782140	HI	school	1500030	1	Hawaii Department of Education	150003000165	117	Kaiulani Elem	Regular School	No	Elementary	PK	5	2018	grade_10	0.0	0
110290	HI	school	1500030	1	Hawaii Department of Education	150003000164	118	KALAKAUA MID	Regular School	No	2	06	8	2016	grade_10	0.0	0
129293	HI	school	1500030	1	Hawaii Department of Education	150003000164	118	KALAKAUA MID	Regular School	No	Middle	06	8	2017	grade_10	0.0	0
280268	HI	school	1500030	1	Hawaii Department of Education	150003000164	118	KALAKAUA MID	Regular School	No	2	06	8	2015	grade_10	0.0	0
2431406	HI	school	1500030	1	Hawaii Department of Education	150003000164	118	Kalakaua Middle	Regular School	No	Middle	06	8	2020	grade_10	0.0	0
2456097	HI	school	1500030	1	Hawaii Department of Education	150003000164	118	Kalakaua Middle	Regular School	No	Middle	06	8	2021	grade_10	0.0	0
2737066	HI	school	1500030	1	Hawaii Department of Education	150003000164	118	Kalakaua Middle	Regular School	No	Middle	06	8	2019	grade_10	0.0	0
2782116	HI	school	1500030	1	Hawaii Department of Education	150003000164	118	Kalakaua Middle	Regular School	No	Middle	06	8	2018	grade_10	0.0	0
110291	HI	school	1500030	1	Hawaii Department of Education	150003000163	119	KALANI HI	Regular School	No	3	09	12	2016	grade_10	300.0	300
129294	HI	school	1500030	1	Hawaii Department of Education	150003000163	119	KALANI HI	Regular School	No	High	09	12	2017	grade_10	310.0	310
280269	HI	school	1500030	1	Hawaii Department of Education	150003000163	119	KALANI HI	Regular School	No	3	09	12	2015	grade_10	300.0	300
2431407	HI	school	1500030	1	Hawaii Department of Education	150003000163	119	Kalani High	Regular School	No	High	09	12	2020	grade_10	362.0	362
2456098	HI	school	1500030	1	Hawaii Department of Education	150003000163	119	Kalani High	Regular School	No	High	09	12	2021	grade_10	339.0	339
2737067	HI	school	1500030	1	Hawaii Department of Education	150003000163	119	Kalani High	Regular School	No	High	09	12	2019	grade_10	331.0	331
2782117	HI	school	1500030	1	Hawaii Department of Education	150003000163	119	Kalani High	Regular School	No	High	09	12	2018	grade_10	297.0	297
110292	HI	school	1500030	1	Hawaii Department of Education	150003000162	120	KALIHI	Regular School	No	1	PK	5	2016	grade_10	0.0	0
129295	HI	school	1500030	1	Hawaii Department of Education	150003000162	120	KALIHI	Regular School	No	Elementary	PK	5	2017	grade_10	0.0	0
280270	HI	school	1500030	1	Hawaii Department of Education	150003000162	120	KALIHI	Regular School	No	1	PK	5	2015	grade_10	0.0	0
2431408	HI	school	1500030	1	Hawaii Department of Education	150003000162	120	Kalihi Elem	Regular School	No	Elementary	PK	5	2020	grade_10	0.0	0
2456099	HI	school	1500030	1	Hawaii Department of Education	150003000162	120	Kalihi Elem	Regular School	No	Elementary	PK	5	2021	grade_10	0.0	0
2737068	HI	school	1500030	1	Hawaii Department of Education	150003000162	120	Kalihi Elem	Regular School	No	Elementary	PK	5	2019	grade_10	0.0	0
2782118	HI	school	1500030	1	Hawaii Department of Education	150003000162	120	Kalihi Elem	Regular School	No	Elementary	PK	5	2018	grade_10	0.0	0
110293	HI	school	1500030	1	Hawaii Department of Education	150003000160	121	KALIHI-KAI	Regular School	No	1	PK	5	2016	grade_10	0.0	0
129296	HI	school	1500030	1	Hawaii Department of Education	150003000160	121	KALIHI-KAI	Regular School	No	Elementary	PK	5	2017	grade_10	0.0	0
280271	HI	school	1500030	1	Hawaii Department of Education	150003000160	121	KALIHI-KAI	Regular School	No	1	PK	5	2015	grade_10	0.0	0
2431409	HI	school	1500030	1	Hawaii Department of Education	150003000160	121	Kalihi Kai Elem	Regular School	No	Elementary	PK	5	2020	grade_10	0.0	0
2456100	HI	school	1500030	1	Hawaii Department of Education	150003000160	121	Kalihi Kai Elem	Regular School	No	Elementary	PK	5	2021	grade_10	0.0	0
2737069	HI	school	1500030	1	Hawaii Department of Education	150003000160	121	Kalihi Kai Elem	Regular School	No	Elementary	PK	5	2019	grade_10	0.0	0
2782119	HI	school	1500030	1	Hawaii Department of Education	150003000160	121	Kalihi Kai Elem	Regular School	No	Elementary	PK	5	2018	grade_10	0.0	0
110294	HI	school	1500030	1	Hawaii Department of Education	150003000210	122	KALIHI-UKA	Regular School	No	1	PK	5	2016	grade_10	0.0	0
129297	HI	school	1500030	1	Hawaii Department of Education	150003000210	122	KALIHI-UKA	Regular School	No	Elementary	PK	5	2017	grade_10	0.0	0
280272	HI	school	1500030	1	Hawaii Department of Education	150003000210	122	KALIHI-UKA	Regular School	No	1	PK	5	2015	grade_10	0.0	0
2431410	HI	school	1500030	1	Hawaii Department of Education	150003000210	122	Kalihi Uka Elem	Regular School	No	Elementary	PK	5	2020	grade_10	0.0	0
2456101	HI	school	1500030	1	Hawaii Department of Education	150003000210	122	Kalihi Uka Elem	Regular School	No	Elementary	PK	5	2021	grade_10	0.0	0
2737070	HI	school	1500030	1	Hawaii Department of Education	150003000210	122	Kalihi Uka Elem	Regular School	No	Elementary	PK	5	2019	grade_10	0.0	0
2782120	HI	school	1500030	1	Hawaii Department of Education	150003000210	122	Kalihi Uka Elem	Regular School	No	Elementary	PK	5	2018	grade_10	0.0	0
110295	HI	school	1500030	1	Hawaii Department of Education	150003000209	123	KALIHI-WAENA	Regular School	No	1	PK	5	2016	grade_10	0.0	0
129298	HI	school	1500030	1	Hawaii Department of Education	150003000209	123	KALIHI-WAENA	Regular School	No	Elementary	PK	5	2017	grade_10	0.0	0
280273	HI	school	1500030	1	Hawaii Department of Education	150003000209	123	KALIHI-WAENA	Regular School	No	1	PK	5	2015	grade_10	0.0	0
2431411	HI	school	1500030	1	Hawaii Department of Education	150003000209	123	Kalihi Waena Elem	Regular School	No	Elementary	PK	5	2020	grade_10	0.0	0
2456102	HI	school	1500030	1	Hawaii Department of Education	150003000209	123	Kalihi Waena Elem	Regular School	No	Elementary	PK	5	2021	grade_10	0.0	0
2737071	HI	school	1500030	1	Hawaii Department of Education	150003000209	123	Kalihi Waena Elem	Regular School	No	Elementary	PK	5	2019	grade_10	0.0	0
2782121	HI	school	1500030	1	Hawaii Department of Education	150003000209	123	Kalihi Waena Elem	Regular School	No	Elementary	PK	5	2018	grade_10	0.0	0
110297	HI	school	1500030	1	Hawaii Department of Education	150003000207	124	KAPALAMA	Regular School	No	1	PK	5	2016	grade_10	0.0	0
129300	HI	school	1500030	1	Hawaii Department of Education	150003000207	124	KAPALAMA	Regular School	No	Elementary	PK	5	2017	grade_10	0.0	0
280275	HI	school	1500030	1	Hawaii Department of Education	150003000207	124	KAPALAMA	Regular School	No	1	PK	5	2015	grade_10	0.0	0
2431413	HI	school	1500030	1	Hawaii Department of Education	150003000207	124	Kapalama Elem	Regular School	No	Elementary	PK	5	2020	grade_10	0.0	0
2456104	HI	school	1500030	1	Hawaii Department of Education	150003000207	124	Kapalama Elem	Regular School	No	Elementary	PK	5	2021	grade_10	0.0	0
2737073	HI	school	1500030	1	Hawaii Department of Education	150003000207	124	Kapalama Elem	Regular School	No	Elementary	PK	5	2019	grade_10	0.0	0
2782123	HI	school	1500030	1	Hawaii Department of Education	150003000207	124	Kapalama Elem	Regular School	No	Elementary	PK	5	2018	grade_10	0.0	0
110315	HI	school	1500030	1	Hawaii Department of Education	150003000206	125	KAULUWELA	Regular School	No	1	PK	5	2016	grade_10	0.0	0
129318	HI	school	1500030	1	Hawaii Department of Education	150003000206	125	KAULUWELA	Regular School	No	Elementary	PK	5	2017	grade_10	0.0	0
280293	HI	school	1500030	1	Hawaii Department of Education	150003000206	125	KAULUWELA	Regular School	No	1	PK	5	2015	grade_10	0.0	0
2431431	HI	school	1500030	1	Hawaii Department of Education	150003000206	125	Kauluwela Elem	Regular School	No	Elementary	PK	5	2020	grade_10	0.0	0
2456122	HI	school	1500030	1	Hawaii Department of Education	150003000206	125	Kauluwela Elem	Regular School	No	Elementary	PK	5	2021	grade_10	0.0	0
2737091	HI	school	1500030	1	Hawaii Department of Education	150003000206	125	Kauluwela Elem	Regular School	No	Elementary	PK	5	2019	grade_10	0.0	0
2782141	HI	school	1500030	1	Hawaii Department of Education	150003000206	125	Kauluwela Elem	Regular School	No	Elementary	PK	5	2018	grade_10	0.0	0
110316	HI	school	1500030	1	Hawaii Department of Education	150003000205	126	KAWANANAKOA MID	Regular School	No	2	06	8	2016	grade_10	0.0	0
129319	HI	school	1500030	1	Hawaii Department of Education	150003000205	126	KAWANANAKOA MID	Regular School	No	Middle	06	8	2017	grade_10	0.0	0
280294	HI	school	1500030	1	Hawaii Department of Education	150003000205	126	KAWANANAKOA MID	Regular School	No	2	06	8	2015	grade_10	0.0	0
2431432	HI	school	1500030	1	Hawaii Department of Education	150003000205	126	Kawananakoa Middle	Regular School	No	Middle	06	8	2020	grade_10	0.0	0
2456123	HI	school	1500030	1	Hawaii Department of Education	150003000205	126	Kawananakoa Middle	Regular School	No	Middle	06	8	2021	grade_10	0.0	0
2737092	HI	school	1500030	1	Hawaii Department of Education	150003000205	126	Kawananakoa Middle	Regular School	No	Middle	06	8	2019	grade_10	0.0	0
2782142	HI	school	1500030	1	Hawaii Department of Education	150003000205	126	Kawananakoa Middle	Regular School	No	Middle	06	8	2018	grade_10	0.0	0
110298	HI	school	1500030	1	Hawaii Department of Education	150003000204	127	KOKO HEAD	Regular School	No	1	PK	5	2016	grade_10	0.0	0
129301	HI	school	1500030	1	Hawaii Department of Education	150003000204	127	KOKO HEAD	Regular School	No	Elementary	PK	5	2017	grade_10	0.0	0
280276	HI	school	1500030	1	Hawaii Department of Education	150003000204	127	KOKO HEAD	Regular School	No	1	PK	5	2015	grade_10	0.0	0
2431414	HI	school	1500030	1	Hawaii Department of Education	150003000204	127	Koko Head Elem	Regular School	No	Elementary	PK	5	2020	grade_10	0.0	0
2456105	HI	school	1500030	1	Hawaii Department of Education	150003000204	127	Koko Head Elem	Regular School	No	Elementary	PK	5	2021	grade_10	0.0	0
2737074	HI	school	1500030	1	Hawaii Department of Education	150003000204	127	Koko Head Elem	Regular School	No	Elementary	PK	5	2019	grade_10	0.0	0
2782124	HI	school	1500030	1	Hawaii Department of Education	150003000204	127	Koko Head Elem	Regular School	No	Elementary	PK	5	2018	grade_10	0.0	0
110317	HI	school	1500030	1	Hawaii Department of Education	150003000203	128	KUHIO	Regular School	No	1	PK	5	2016	grade_10	0.0	0
129320	HI	school	1500030	1	Hawaii Department of Education	150003000203	128	KUHIO	Regular School	No	Elementary	PK	5	2017	grade_10	0.0	0
280295	HI	school	1500030	1	Hawaii Department of Education	150003000203	128	KUHIO	Regular School	No	1	PK	5	2015	grade_10	0.0	0
2431433	HI	school	1500030	1	Hawaii Department of Education	150003000203	128	Kuhio Elem	Regular School	No	Elementary	PK	5	2020	grade_10	0.0	0
2456124	HI	school	1500030	1	Hawaii Department of Education	150003000203	128	Kuhio Elem	Regular School	No	Elementary	PK	5	2021	grade_10	0.0	0