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_nces_id > :p3 or (school_nces_id = :p3 and rowid > :p2)) order by school_nces_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	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
278107	HI	school	1500030	1	Hawaii Department of Education	150003000015	317	KEOLU		Regular School	No	1	PK	6	2015	grade_2	23.0	23
2429214	HI	school	1500030	1	Hawaii Department of Education	150003000015	317	Keolu Elem		Regular School	No	Elementary	PK	6	2020	grade_2	18.0	18
2453898	HI	school	1500030	1	Hawaii Department of Education	150003000015	317	Keolu Elem		Regular School	No	Elementary	PK	6	2021	grade_2	11.0	11
2734882	HI	school	1500030	1	Hawaii Department of Education	150003000015	317	Keolu Elem		Regular School	No	Elementary	PK	6	2019	grade_2	14.0	14
2779932	HI	school	1500030	1	Hawaii Department of Education	150003000015	317	Keolu Elem		Regular School	No	Elementary	PK	6	2018	grade_2	14.0	14
108108	HI	school	1500030	1	Hawaii Department of Education	150003000016	318	KING INT		Regular School	No	2	07	8	2016	grade_2	0.0	0
127111	HI	school	1500030	1	Hawaii Department of Education	150003000016	318	KING INT		Regular School	No	Middle	07	8	2017	grade_2	0.0	0
278093	HI	school	1500030	1	Hawaii Department of Education	150003000016	318	KING INT		Regular School	No	2	07	8	2015	grade_2	0.0	0
2429200	HI	school	1500030	1	Hawaii Department of Education	150003000016	318	King Int		Regular School	No	Middle	07	8	2020	grade_2	0.0	0
2453884	HI	school	1500030	1	Hawaii Department of Education	150003000016	318	King Int		Regular School	No	Middle	07	8	2021	grade_2	0.0	0
2734868	HI	school	1500030	1	Hawaii Department of Education	150003000016	318	King Int		Regular School	No	Middle	07	8	2019	grade_2	0.0	0
2779918	HI	school	1500030	1	Hawaii Department of Education	150003000016	318	King Int		Regular School	No	Middle	07	8	2018	grade_2	0.0	0
108109	HI	school	1500030	1	Hawaii Department of Education	150003000017	319	LAIE		Regular School	No	1	PK	6	2016	grade_2	90.0	90
127112	HI	school	1500030	1	Hawaii Department of Education	150003000017	319	LAIE		Regular School	No	Elementary	PK	6	2017	grade_2	88.0	88
278094	HI	school	1500030	1	Hawaii Department of Education	150003000017	319	LAIE		Regular School	No	1	PK	6	2015	grade_2	86.0	86
2429201	HI	school	1500030	1	Hawaii Department of Education	150003000017	319	Laie Elem		Regular School	No	Elementary	PK	6	2020	grade_2	91.0	91
2453885	HI	school	1500030	1	Hawaii Department of Education	150003000017	319	Laie Elem		Regular School	No	Elementary	PK	6	2021	grade_2	83.0	83
2734869	HI	school	1500030	1	Hawaii Department of Education	150003000017	319	Laie Elem		Regular School	No	Elementary	PK	6	2019	grade_2	79.0	79
2779919	HI	school	1500030	1	Hawaii Department of Education	150003000017	319	Laie Elem		Regular School	No	Elementary	PK	6	2018	grade_2	86.0	86
108238	HI	school	1500030	1	Hawaii Department of Education	150003000018	320	LANIKAI-PCS	charter	Regular School	Yes	1	KG	6	2016	grade_2	50.0	50
127241	HI	school	1500030	1	Hawaii Department of Education	150003000018	320	LANIKAI-PCS	charter	Regular School	Yes	Elementary	KG	6	2017	grade_2	45.0	45
278203	HI	school	1500030	1	Hawaii Department of Education	150003000018	320	LANIKAI-PCS	charter	Regular School	Yes	1	KG	6	2015	grade_2	48.0	48
2429323	HI	school	1500030	1	Hawaii Department of Education	150003000018	320	Kaohao PCS	charter	Regular School	Yes	Elementary	PK	6	2020	grade_2	47.0	47
2454007	HI	school	1500030	1	Hawaii Department of Education	150003000018	320	Kaohao PCS	charter	Regular School	Yes	Elementary	PK	6	2021	grade_2	40.0	40
2734978	HI	school	1500030	1	Hawaii Department of Education	150003000018	320	Kaohao PCS	charter	Regular School	Yes	Elementary	PK	6	2019	grade_2	43.0	43
2780039	HI	school	1500030	1	Hawaii Department of Education	150003000018	320	Kaohao PCS	charter	Regular School	Yes	Elementary	PK	6	2018	grade_2	44.0	44
108123	HI	school	1500030	1	Hawaii Department of Education	150003000019	321	MAUNAWILI		Regular School	No	1	PK	6	2016	grade_2	53.0	53
127126	HI	school	1500030	1	Hawaii Department of Education	150003000019	321	MAUNAWILI		Regular School	No	Elementary	PK	6	2017	grade_2	36.0	36
278108	HI	school	1500030	1	Hawaii Department of Education	150003000019	321	MAUNAWILI		Regular School	No	1	PK	6	2015	grade_2	53.0	53
2429215	HI	school	1500030	1	Hawaii Department of Education	150003000019	321	Maunawili Elem		Regular School	No	Elementary	PK	6	2020	grade_2	53.0	53
2453899	HI	school	1500030	1	Hawaii Department of Education	150003000019	321	Maunawili Elem		Regular School	No	Elementary	PK	6	2021	grade_2	42.0	42
2734883	HI	school	1500030	1	Hawaii Department of Education	150003000019	321	Maunawili Elem		Regular School	No	Elementary	PK	6	2019	grade_2	50.0	50
2779933	HI	school	1500030	1	Hawaii Department of Education	150003000019	321	Maunawili Elem		Regular School	No	Elementary	PK	6	2018	grade_2	43.0	43
108124	HI	school	1500030	1	Hawaii Department of Education	150003000020	322	MOKAPU		Regular School	No	1	PK	6	2016	grade_2	126.0	126
127127	HI	school	1500030	1	Hawaii Department of Education	150003000020	322	MOKAPU		Regular School	No	Elementary	PK	6	2017	grade_2	122.0	122
278109	HI	school	1500030	1	Hawaii Department of Education	150003000020	322	MOKAPU		Regular School	No	1	PK	6	2015	grade_2	134.0	134
2429216	HI	school	1500030	1	Hawaii Department of Education	150003000020	322	Mokapu Elem		Regular School	No	Elementary	PK	6	2020	grade_2	134.0	134
2453900	HI	school	1500030	1	Hawaii Department of Education	150003000020	322	Mokapu Elem		Regular School	No	Elementary	PK	6	2021	grade_2	102.0	102
2734884	HI	school	1500030	1	Hawaii Department of Education	150003000020	322	Mokapu Elem		Regular School	No	Elementary	PK	6	2019	grade_2	132.0	132
2779934	HI	school	1500030	1	Hawaii Department of Education	150003000020	322	Mokapu Elem		Regular School	No	Elementary	PK	6	2018	grade_2	112.0	112
108110	HI	school	1500030	1	Hawaii Department of Education	150003000021	323	PARKER		Regular School	No	1	PK	6	2016	grade_2	43.0	43
127113	HI	school	1500030	1	Hawaii Department of Education	150003000021	323	PARKER		Regular School	No	Elementary	PK	6	2017	grade_2	41.0	41
278095	HI	school	1500030	1	Hawaii Department of Education	150003000021	323	PARKER		Regular School	No	1	PK	6	2015	grade_2	33.0	33
2429202	HI	school	1500030	1	Hawaii Department of Education	150003000021	323	Parker Elem		Regular School	No	Elementary	PK	6	2020	grade_2	40.0	40
2453886	HI	school	1500030	1	Hawaii Department of Education	150003000021	323	Parker Elem		Regular School	No	Elementary	PK	6	2021	grade_2	39.0	39
2734870	HI	school	1500030	1	Hawaii Department of Education	150003000021	323	Parker Elem		Regular School	No	Elementary	PK	6	2019	grade_2	31.0	31
2779920	HI	school	1500030	1	Hawaii Department of Education	150003000021	323	Parker Elem		Regular School	No	Elementary	PK	6	2018	grade_2	43.0	43
108126	HI	school	1500030	1	Hawaii Department of Education	150003000022	324	POPE		Regular School	No	1	PK	6	2016	grade_2	21.0	21
127129	HI	school	1500030	1	Hawaii Department of Education	150003000022	324	POPE		Regular School	No	Elementary	PK	6	2017	grade_2	35.0	35
278111	HI	school	1500030	1	Hawaii Department of Education	150003000022	324	POPE		Regular School	No	1	PK	6	2015	grade_2	26.0	26
2429218	HI	school	1500030	1	Hawaii Department of Education	150003000022	324	Pope Elem		Regular School	No	Elementary	PK	6	2020	grade_2	30.0	30
2453902	HI	school	1500030	1	Hawaii Department of Education	150003000022	324	Pope Elem		Regular School	No	Elementary	PK	6	2021	grade_2	23.0	23
2734886	HI	school	1500030	1	Hawaii Department of Education	150003000022	324	Pope Elem		Regular School	No	Elementary	PK	6	2019	grade_2	27.0	27
2779936	HI	school	1500030	1	Hawaii Department of Education	150003000022	324	Pope Elem		Regular School	No	Elementary	PK	6	2018	grade_2	31.0	31
108111	HI	school	1500030	1	Hawaii Department of Education	150003000023	314	PUOHALA		Regular School	No	1	PK	6	2016	grade_2	47.0	47
127114	HI	school	1500030	1	Hawaii Department of Education	150003000023	314	PUOHALA		Regular School	No	Elementary	PK	6	2017	grade_2	23.0	23
278096	HI	school	1500030	1	Hawaii Department of Education	150003000023	314	PUOHALA		Regular School	No	1	PK	6	2015	grade_2	42.0	42
2429203	HI	school	1500030	1	Hawaii Department of Education	150003000023	314	Puohala Elem		Regular School	No	Elementary	PK	8	2020	grade_2	35.0	35
2453887	HI	school	1500030	1	Hawaii Department of Education	150003000023	314	Puohala Elem		Regular School	No	Elementary	PK	8	2021	grade_2	40.0	40
2734871	HI	school	1500030	1	Hawaii Department of Education	150003000023	314	Puohala Elem		Regular School	No	Elementary	PK	7	2019	grade_2	35.0	35
2779921	HI	school	1500030	1	Hawaii Department of Education	150003000023	314	Puohala Elem		Regular School	No	Elementary	PK	6	2018	grade_2	40.0	40
108112	HI	school	1500030	1	Hawaii Department of Education	150003000024	325	SUNSET BEACH		Regular School	No	1	PK	6	2016	grade_2	61.0	61
127115	HI	school	1500030	1	Hawaii Department of Education	150003000024	325	SUNSET BEACH		Regular School	No	Elementary	PK	6	2017	grade_2	67.0	67
278097	HI	school	1500030	1	Hawaii Department of Education	150003000024	325	SUNSET BEACH		Regular School	No	1	PK	6	2015	grade_2	62.0	62
2429204	HI	school	1500030	1	Hawaii Department of Education	150003000024	325	Sunset Beach Elem		Regular School	No	Elementary	PK	6	2020	grade_2	62.0	62
2453888	HI	school	1500030	1	Hawaii Department of Education	150003000024	325	Sunset Beach Elem		Regular School	No	Elementary	PK	6	2021	grade_2	48.0	48
2734872	HI	school	1500030	1	Hawaii Department of Education	150003000024	325	Sunset Beach Elem		Regular School	No	Elementary	PK	6	2019	grade_2	41.0	41
2779922	HI	school	1500030	1	Hawaii Department of Education	150003000024	325	Sunset Beach Elem		Regular School	No	Elementary	PK	6	2018	grade_2	58.0	58
108113	HI	school	1500030	1	Hawaii Department of Education	150003000025	326	WAIAHOLE		Regular School	No	1	PK	6	2016	grade_2	5.0	5
127116	HI	school	1500030	1	Hawaii Department of Education	150003000025	326	WAIAHOLE		Regular School	No	Elementary	PK	6	2017	grade_2	8.0	8
278098	HI	school	1500030	1	Hawaii Department of Education	150003000025	326	WAIAHOLE		Regular School	No	1	PK	6	2015	grade_2	15.0	15
2429205	HI	school	1500030	1	Hawaii Department of Education	150003000025	326	Waiahole Elem		Regular School	No	Elementary	PK	6	2020	grade_2	18.0	18
2453889	HI	school	1500030	1	Hawaii Department of Education	150003000025	326	Waiahole Elem		Regular School	No	Elementary	PK	6	2021	grade_2	16.0	16
2734873	HI	school	1500030	1	Hawaii Department of Education	150003000025	326	Waiahole Elem		Regular School	No	Elementary	PK	6	2019	grade_2	9.0	9
2779923	HI	school	1500030	1	Hawaii Department of Education	150003000025	326	Waiahole Elem		Regular School	No	Elementary	PK	6	2018	grade_2	16.0	16
108127	HI	school	1500030	1	Hawaii Department of Education	150003000026	327	WAIMANALO EL & INT		Regular School	No	1	PK	8	2016	grade_2	36.0	36
127130	HI	school	1500030	1	Hawaii Department of Education	150003000026	327	WAIMANALO EL & INT		Regular School	No	Elementary	PK	8	2017	grade_2	34.0	34
278112	HI	school	1500030	1	Hawaii Department of Education	150003000026	327	WAIMANALO EL & INT		Regular School	No	1	PK	8	2015	grade_2	52.0	52
2429219	HI	school	1500030	1	Hawaii Department of Education	150003000026	327	Waimanalo El & Int		Regular School	No	Elementary	PK	8	2020	grade_2	43.0	43
2453903	HI	school	1500030	1	Hawaii Department of Education	150003000026	327	Waimanalo El & Int		Regular School	No	Elementary	PK	8	2021	grade_2	26.0	26
2734887	HI	school	1500030	1	Hawaii Department of Education	150003000026	327	Waimanalo El & Int		Regular School	No	Elementary	PK	8	2019	grade_2	28.0	28
2779937	HI	school	1500030	1	Hawaii Department of Education	150003000026	327	Waimanalo El & Int		Regular School	No	Elementary	PK	8	2018	grade_2	30.0	30
108128	HI	school	1500030	1	Hawaii Department of Education	150003000027	351	DE SILVA		Regular School	No	1	PK	6	2016	grade_2	75.0	75
127131	HI	school	1500030	1	Hawaii Department of Education	150003000027	351	DE SILVA		Regular School	No	Elementary	PK	6	2017	grade_2	56.0	56
278113	HI	school	1500030	1	Hawaii Department of Education	150003000027	351	DE SILVA		Regular School	No	1	PK	6	2015	grade_2	57.0	57
2429220	HI	school	1500030	1	Hawaii Department of Education	150003000027	351	de Silva Elem		Regular School	No	Elementary	PK	6	2020	grade_2	72.0	72
2453904	HI	school	1500030	1	Hawaii Department of Education	150003000027	351	de Silva Elem		Regular School	No	Elementary	PK	6	2021	grade_2	56.0	56
2734888	HI	school	1500030	1	Hawaii Department of Education	150003000027	351	de Silva Elem		Regular School	No	Elementary	PK	6	2019	grade_2	68.0	68
2779938	HI	school	1500030	1	Hawaii Department of Education	150003000027	351	de Silva Elem		Regular School	No	Elementary	PK	6	2018	grade_2	64.0	64
108129	HI	school	1500030	1	Hawaii Department of Education	150003000028	352	HAAHEO		Regular School	No	1	PK	6	2016	grade_2	25.0	25
127132	HI	school	1500030	1	Hawaii Department of Education	150003000028	352	HAAHEO		Regular School	No	Elementary	PK	6	2017	grade_2	27.0	27
278114	HI	school	1500030	1	Hawaii Department of Education	150003000028	352	HAAHEO		Regular School	No	1	PK	6	2015	grade_2	23.0	23
2429221	HI	school	1500030	1	Hawaii Department of Education	150003000028	352	Haaheo Elem		Regular School	No	Elementary	PK	6	2020	grade_2	25.0	25
2453905	HI	school	1500030	1	Hawaii Department of Education	150003000028	352	Haaheo Elem		Regular School	No	Elementary	PK	6	2021	grade_2	22.0	22
2734889	HI	school	1500030	1	Hawaii Department of Education	150003000028	352	Haaheo Elem		Regular School	No	Elementary	PK	6	2019	grade_2	25.0	25
2779939	HI	school	1500030	1	Hawaii Department of Education	150003000028	352	Haaheo Elem		Regular School	No	Elementary	PK	6	2018	grade_2	26.0	26
108130	HI	school	1500030	1	Hawaii Department of Education	150003000029	355	HILO HI		Regular School	No	3	09	12	2016	grade_2	0.0	0
127133	HI	school	1500030	1	Hawaii Department of Education	150003000029	355	HILO HI		Regular School	No	High	09	12	2017	grade_2	0.0	0
278115	HI	school	1500030	1	Hawaii Department of Education	150003000029	355	HILO HI		Regular School	No	3	09	12	2015	grade_2	0.0	0
2429222	HI	school	1500030	1	Hawaii Department of Education	150003000029	355	Hilo High		Regular School	No	High	09	12	2020	grade_2	0.0	0
2453906	HI	school	1500030	1	Hawaii Department of Education	150003000029	355	Hilo High		Regular School	No	High	09	12	2021	grade_2	0.0	0