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 "state" = :p0 order by district 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	ccd_school_type	ccd_charter_school	ccd_school_lvl	ccd_school_low_grade	ccd_school_high_grade	year	grade	white	black	hispanic	native_american_alaskan_native	asian	native_hawaiian_pacific_islander	multiracial	total	white_int	black_int	hispanic_int	native_american_alaskan_native_int	asian_int	native_hawaiian_pacific_islander_int	multiracial_int	total_int
1687645	OR	school	4113650	1997	Yoncalla SD 32	411365000319	299	Yoncalla Elementary School	Regular School	No	Elementary	KG	08	2017	kindergarten								22.0								22
1687646	OR	school	4113650	1997	Yoncalla SD 32	411365000320	300	Yoncalla High School	Regular School	No	High	09	12	2017	kindergarten								0.0								0
1687647	OR	school	4113650	1997	Yoncalla SD 32		1997	Yoncalla SD 32						2017	kindergarten								0.0								0
1689115	OR	school	4113650	1997	Yoncalla SD 32	411365000319	299	Yoncalla Elementary School	Regular School	No	Elementary	KG	08	2017	grade_1								12.0								12
1689116	OR	school	4113650	1997	Yoncalla SD 32	411365000320	300	Yoncalla High School	Regular School	No	High	09	12	2017	grade_1								0.0								0
1689117	OR	school	4113650	1997	Yoncalla SD 32		1997	Yoncalla SD 32						2017	grade_1								0.0								0
1690585	OR	school	4113650	1997	Yoncalla SD 32	411365000319	299	Yoncalla Elementary School	Regular School	No	Elementary	KG	08	2017	grade_2								13.0								13
1690586	OR	school	4113650	1997	Yoncalla SD 32	411365000320	300	Yoncalla High School	Regular School	No	High	09	12	2017	grade_2								0.0								0
1690587	OR	school	4113650	1997	Yoncalla SD 32		1997	Yoncalla SD 32						2017	grade_2								0.0								0
1692055	OR	school	4113650	1997	Yoncalla SD 32	411365000319	299	Yoncalla Elementary School	Regular School	No	Elementary	KG	08	2017	grade_3								13.0								13
1692056	OR	school	4113650	1997	Yoncalla SD 32	411365000320	300	Yoncalla High School	Regular School	No	High	09	12	2017	grade_3								0.0								0
1692057	OR	school	4113650	1997	Yoncalla SD 32		1997	Yoncalla SD 32						2017	grade_3								0.0								0
1693525	OR	school	4113650	1997	Yoncalla SD 32	411365000319	299	Yoncalla Elementary School	Regular School	No	Elementary	KG	08	2017	grade_4								11.0								11
1693526	OR	school	4113650	1997	Yoncalla SD 32	411365000320	300	Yoncalla High School	Regular School	No	High	09	12	2017	grade_4								0.0								0
1693527	OR	school	4113650	1997	Yoncalla SD 32		1997	Yoncalla SD 32						2017	grade_4								0.0								0
1694995	OR	school	4113650	1997	Yoncalla SD 32	411365000319	299	Yoncalla Elementary School	Regular School	No	Elementary	KG	08	2017	grade_5								18.0								18
1694996	OR	school	4113650	1997	Yoncalla SD 32	411365000320	300	Yoncalla High School	Regular School	No	High	09	12	2017	grade_5								0.0								0
1694997	OR	school	4113650	1997	Yoncalla SD 32		1997	Yoncalla SD 32						2017	grade_5								0.0								0
1696465	OR	school	4113650	1997	Yoncalla SD 32	411365000319	299	Yoncalla Elementary School	Regular School	No	Elementary	KG	08	2017	grade_6								19.0								19
1696466	OR	school	4113650	1997	Yoncalla SD 32	411365000320	300	Yoncalla High School	Regular School	No	High	09	12	2017	grade_6								0.0								0
1696467	OR	school	4113650	1997	Yoncalla SD 32		1997	Yoncalla SD 32						2017	grade_6								0.0								0
1697935	OR	school	4113650	1997	Yoncalla SD 32	411365000319	299	Yoncalla Elementary School	Regular School	No	Elementary	KG	08	2017	grade_7								20.0								20
1697936	OR	school	4113650	1997	Yoncalla SD 32	411365000320	300	Yoncalla High School	Regular School	No	High	09	12	2017	grade_7								0.0								0
1697937	OR	school	4113650	1997	Yoncalla SD 32		1997	Yoncalla SD 32						2017	grade_7								0.0								0
1699405	OR	school	4113650	1997	Yoncalla SD 32	411365000319	299	Yoncalla Elementary School	Regular School	No	Elementary	KG	08	2017	grade_8								25.0								25
1699406	OR	school	4113650	1997	Yoncalla SD 32	411365000320	300	Yoncalla High School	Regular School	No	High	09	12	2017	grade_8								0.0								0
1699407	OR	school	4113650	1997	Yoncalla SD 32		1997	Yoncalla SD 32						2017	grade_8								0.0								0
1700875	OR	school	4113650	1997	Yoncalla SD 32	411365000319	299	Yoncalla Elementary School	Regular School	No	Elementary	KG	08	2017	grade_9								0.0								0
1700876	OR	school	4113650	1997	Yoncalla SD 32	411365000320	300	Yoncalla High School	Regular School	No	High	09	12	2017	grade_9								22.0								22
1700877	OR	school	4113650	1997	Yoncalla SD 32		1997	Yoncalla SD 32						2017	grade_9								0.0								0
1702345	OR	school	4113650	1997	Yoncalla SD 32	411365000319	299	Yoncalla Elementary School	Regular School	No	Elementary	KG	08	2017	grade_10								0.0								0
1702346	OR	school	4113650	1997	Yoncalla SD 32	411365000320	300	Yoncalla High School	Regular School	No	High	09	12	2017	grade_10								21.0								21
1702347	OR	school	4113650	1997	Yoncalla SD 32		1997	Yoncalla SD 32						2017	grade_10								0.0								0
1703815	OR	school	4113650	1997	Yoncalla SD 32	411365000319	299	Yoncalla Elementary School	Regular School	No	Elementary	KG	08	2017	grade_11								0.0								0
1703816	OR	school	4113650	1997	Yoncalla SD 32	411365000320	300	Yoncalla High School	Regular School	No	High	09	12	2017	grade_11								27.0								27
1703817	OR	school	4113650	1997	Yoncalla SD 32		1997	Yoncalla SD 32						2017	grade_11								0.0								0
1705285	OR	school	4113650	1997	Yoncalla SD 32	411365000319	299	Yoncalla Elementary School	Regular School	No	Elementary	KG	08	2017	grade_12								0.0								0
1705286	OR	school	4113650	1997	Yoncalla SD 32	411365000320	300	Yoncalla High School	Regular School	No	High	09	12	2017	grade_12								19.0								19
1705287	OR	school	4113650	1997	Yoncalla SD 32		1997	Yoncalla SD 32						2017	grade_12								0.0								0
1706755	OR	school	4113650	1997	Yoncalla SD 32	411365000319	299	Yoncalla Elementary School	Regular School	No	Elementary	KG	08	2017	k_12_total	110.0	0.0	20.0		1.0	0.0	14.0		110	0	20		1	0	14
1706756	OR	school	4113650	1997	Yoncalla SD 32	411365000320	300	Yoncalla High School	Regular School	No	High	09	12	2017	k_12_total	61.0	1.0	13.0		0.0	1.0	10.0		61	1	13		0	1	10
1706757	OR	school	4113650	1997	Yoncalla SD 32		1997	Yoncalla SD 32						2017	k_12_total	0.0	0.0	0.0		0.0	0.0	0.0		0	0	0		0	0	0
1172963	OR	school	4113650	1997	Yoncalla SD 32	411365000319	299	Yoncalla Elementary School	Regular School	No	Elementary	KG	08	2018	kindergarten								15.0								15
1172964	OR	school	4113650	1997	Yoncalla SD 32	411365000320	300	Yoncalla High School	Regular School	No	High	09	12	2018	kindergarten								0.0								0
1174422	OR	school	4113650	1997	Yoncalla SD 32	411365000319	299	Yoncalla Elementary School	Regular School	No	Elementary	KG	08	2018	grade_1								19.0								19
1174423	OR	school	4113650	1997	Yoncalla SD 32	411365000320	300	Yoncalla High School	Regular School	No	High	09	12	2018	grade_1								0.0								0
1175881	OR	school	4113650	1997	Yoncalla SD 32	411365000319	299	Yoncalla Elementary School	Regular School	No	Elementary	KG	08	2018	grade_2								10.0								10
1175882	OR	school	4113650	1997	Yoncalla SD 32	411365000320	300	Yoncalla High School	Regular School	No	High	09	12	2018	grade_2								0.0								0
1177340	OR	school	4113650	1997	Yoncalla SD 32	411365000319	299	Yoncalla Elementary School	Regular School	No	Elementary	KG	08	2018	grade_3								11.0								11
1177341	OR	school	4113650	1997	Yoncalla SD 32	411365000320	300	Yoncalla High School	Regular School	No	High	09	12	2018	grade_3								0.0								0
1178799	OR	school	4113650	1997	Yoncalla SD 32	411365000319	299	Yoncalla Elementary School	Regular School	No	Elementary	KG	08	2018	grade_4								16.0								16
1178800	OR	school	4113650	1997	Yoncalla SD 32	411365000320	300	Yoncalla High School	Regular School	No	High	09	12	2018	grade_4								0.0								0
1180258	OR	school	4113650	1997	Yoncalla SD 32	411365000319	299	Yoncalla Elementary School	Regular School	No	Elementary	KG	08	2018	grade_5								13.0								13
1180259	OR	school	4113650	1997	Yoncalla SD 32	411365000320	300	Yoncalla High School	Regular School	No	High	09	12	2018	grade_5								0.0								0
1181717	OR	school	4113650	1997	Yoncalla SD 32	411365000319	299	Yoncalla Elementary School	Regular School	No	Elementary	KG	08	2018	grade_6								13.0								13
1181718	OR	school	4113650	1997	Yoncalla SD 32	411365000320	300	Yoncalla High School	Regular School	No	High	09	12	2018	grade_6								0.0								0
1183176	OR	school	4113650	1997	Yoncalla SD 32	411365000319	299	Yoncalla Elementary School	Regular School	No	Elementary	KG	08	2018	grade_7								19.0								19
1183177	OR	school	4113650	1997	Yoncalla SD 32	411365000320	300	Yoncalla High School	Regular School	No	High	09	12	2018	grade_7								0.0								0
1184635	OR	school	4113650	1997	Yoncalla SD 32	411365000319	299	Yoncalla Elementary School	Regular School	No	Elementary	KG	08	2018	grade_8								20.0								20
1184636	OR	school	4113650	1997	Yoncalla SD 32	411365000320	300	Yoncalla High School	Regular School	No	High	09	12	2018	grade_8								0.0								0
1186094	OR	school	4113650	1997	Yoncalla SD 32	411365000319	299	Yoncalla Elementary School	Regular School	No	Elementary	KG	08	2018	grade_9								0.0								0
1186095	OR	school	4113650	1997	Yoncalla SD 32	411365000320	300	Yoncalla High School	Regular School	No	High	09	12	2018	grade_9								23.0								23
1187553	OR	school	4113650	1997	Yoncalla SD 32	411365000319	299	Yoncalla Elementary School	Regular School	No	Elementary	KG	08	2018	grade_10								0.0								0
1187554	OR	school	4113650	1997	Yoncalla SD 32	411365000320	300	Yoncalla High School	Regular School	No	High	09	12	2018	grade_10								22.0								22
1189012	OR	school	4113650	1997	Yoncalla SD 32	411365000319	299	Yoncalla Elementary School	Regular School	No	Elementary	KG	08	2018	grade_11								0.0								0
1189013	OR	school	4113650	1997	Yoncalla SD 32	411365000320	300	Yoncalla High School	Regular School	No	High	09	12	2018	grade_11								26.0								26
1190471	OR	school	4113650	1997	Yoncalla SD 32	411365000319	299	Yoncalla Elementary School	Regular School	No	Elementary	KG	08	2018	grade_12								0.0								0
1190472	OR	school	4113650	1997	Yoncalla SD 32	411365000320	300	Yoncalla High School	Regular School	No	High	09	12	2018	grade_12								29.0								29
1191930	OR	school	4113650	1997	Yoncalla SD 32	411365000319	299	Yoncalla Elementary School	Regular School	No	Elementary	KG	08	2018	k_12_total	102.0	0.0	15.0	6.0	0.0	0.0	13.0		102	0	15	6	0	0	13
1191931	OR	school	4113650	1997	Yoncalla SD 32	411365000320	300	Yoncalla High School	Regular School	No	High	09	12	2018	k_12_total	68.0	1.0	17.0	1.0	1.0	1.0	11.0		68	1	17	1	1	1	11
899128	OR	school	4113650	1997	Yoncalla SD 32	411365000319	299	Yoncalla Elementary School	Regular School	No	Elementary	KG	08	2020	kindergarten								20								20
899129	OR	school	4113650	1997	Yoncalla SD 32	411365000320	300	Yoncalla High School	Regular School	No	High	09	12	2020	kindergarten								0								0
900587	OR	school	4113650	1997	Yoncalla SD 32	411365000319	299	Yoncalla Elementary School	Regular School	No	Elementary	KG	08	2020	grade_1								13								13
900588	OR	school	4113650	1997	Yoncalla SD 32	411365000320	300	Yoncalla High School	Regular School	No	High	09	12	2020	grade_1								0								0
902046	OR	school	4113650	1997	Yoncalla SD 32	411365000319	299	Yoncalla Elementary School	Regular School	No	Elementary	KG	08	2020	grade_2								13								13
902047	OR	school	4113650	1997	Yoncalla SD 32	411365000320	300	Yoncalla High School	Regular School	No	High	09	12	2020	grade_2								0								0
903505	OR	school	4113650	1997	Yoncalla SD 32	411365000319	299	Yoncalla Elementary School	Regular School	No	Elementary	KG	08	2020	grade_3								13								13
903506	OR	school	4113650	1997	Yoncalla SD 32	411365000320	300	Yoncalla High School	Regular School	No	High	09	12	2020	grade_3								0								0
904964	OR	school	4113650	1997	Yoncalla SD 32	411365000319	299	Yoncalla Elementary School	Regular School	No	Elementary	KG	08	2020	grade_4								13								13
904965	OR	school	4113650	1997	Yoncalla SD 32	411365000320	300	Yoncalla High School	Regular School	No	High	09	12	2020	grade_4								0								0
906423	OR	school	4113650	1997	Yoncalla SD 32	411365000319	299	Yoncalla Elementary School	Regular School	No	Elementary	KG	08	2020	grade_5								7								7
906424	OR	school	4113650	1997	Yoncalla SD 32	411365000320	300	Yoncalla High School	Regular School	No	High	09	12	2020	grade_5								0								0
907882	OR	school	4113650	1997	Yoncalla SD 32	411365000319	299	Yoncalla Elementary School	Regular School	No	Elementary	KG	08	2020	grade_6								19								19
907883	OR	school	4113650	1997	Yoncalla SD 32	411365000320	300	Yoncalla High School	Regular School	No	High	09	12	2020	grade_6								0								0
909341	OR	school	4113650	1997	Yoncalla SD 32	411365000319	299	Yoncalla Elementary School	Regular School	No	Elementary	KG	08	2020	grade_7								16								16
909342	OR	school	4113650	1997	Yoncalla SD 32	411365000320	300	Yoncalla High School	Regular School	No	High	09	12	2020	grade_7								0								0
910800	OR	school	4113650	1997	Yoncalla SD 32	411365000319	299	Yoncalla Elementary School	Regular School	No	Elementary	KG	08	2020	grade_8								25								25
910801	OR	school	4113650	1997	Yoncalla SD 32	411365000320	300	Yoncalla High School	Regular School	No	High	09	12	2020	grade_8								0								0
912259	OR	school	4113650	1997	Yoncalla SD 32	411365000319	299	Yoncalla Elementary School	Regular School	No	Elementary	KG	08	2020	grade_9								0								0
912260	OR	school	4113650	1997	Yoncalla SD 32	411365000320	300	Yoncalla High School	Regular School	No	High	09	12	2020	grade_9								19								19
913718	OR	school	4113650	1997	Yoncalla SD 32	411365000319	299	Yoncalla Elementary School	Regular School	No	Elementary	KG	08	2020	grade_10								0								0
913719	OR	school	4113650	1997	Yoncalla SD 32	411365000320	300	Yoncalla High School	Regular School	No	High	09	12	2020	grade_10								26								26
915177	OR	school	4113650	1997	Yoncalla SD 32	411365000319	299	Yoncalla Elementary School	Regular School	No	Elementary	KG	08	2020	grade_11								0								0
915178	OR	school	4113650	1997	Yoncalla SD 32	411365000320	300	Yoncalla High School	Regular School	No	High	09	12	2020	grade_11								37								37
916636	OR	school	4113650	1997	Yoncalla SD 32	411365000319	299	Yoncalla Elementary School	Regular School	No	Elementary	KG	08	2020	grade_12								0								0
916637	OR	school	4113650	1997	Yoncalla SD 32	411365000320	300	Yoncalla High School	Regular School	No	High	09	12	2020	grade_12								44								44
918095	OR	school	4113650	1997	Yoncalla SD 32	411365000319	299	Yoncalla Elementary School	Regular School	No	Elementary	KG	08	2020	k_12_total	110	1	17	1	0	0	10		110	1	17	1	0	0	10
918096	OR	school	4113650	1997	Yoncalla SD 32	411365000320	300	Yoncalla High School	Regular School	No	High	09	12	2020	k_12_total	91	0	16	3	2	0	14		91	0	16	3	2	0	14
639126	OR	school	4113650	1997	Yoncalla SD 32	411365000319	299	Yoncalla Elementary School	Regular School	No	Elementary	KG	08	2021	kindergarten								26								26
639127	OR	school	4113650	1997	Yoncalla SD 32	411365000320	300	Yoncalla High School	Regular School	No	High	09	12	2021	kindergarten								0								0
640597	OR	school	4113650	1997	Yoncalla SD 32	411365000319	299	Yoncalla Elementary School	Regular School	No	Elementary	KG	08	2021	grade_1								15								15