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 and "year" = :p1 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	asian	native_hawaiian_pacific_islander	multiracial	total	white_int	black_int	hispanic_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
1687641	OR	school	4100016	2251	Yamhill Carlton SD 1	410001601266	1213	Yamhill Carlton Elementary School	Regular School	No	Elementary	KG	04	2017	kindergarten							68.0							68
1687642	OR	school	4100016	2251	Yamhill Carlton SD 1	410001601288	1238	Yamhill Carlton High School	Regular School	No	High	09	12	2017	kindergarten							0.0							0
1687643	OR	school	4100016	2251	Yamhill Carlton SD 1	410001601730	4564	Yamhill Carlton Intermediate School	Regular School	No	Middle	05	08	2017	kindergarten							0.0							0
1687644	OR	school	4100016	2251	Yamhill Carlton SD 1		2251	Yamhill Carlton SD 1						2017	kindergarten							0.0							0
1689111	OR	school	4100016	2251	Yamhill Carlton SD 1	410001601266	1213	Yamhill Carlton Elementary School	Regular School	No	Elementary	KG	04	2017	grade_1							61.0							61
1689112	OR	school	4100016	2251	Yamhill Carlton SD 1	410001601288	1238	Yamhill Carlton High School	Regular School	No	High	09	12	2017	grade_1							0.0							0
1689113	OR	school	4100016	2251	Yamhill Carlton SD 1	410001601730	4564	Yamhill Carlton Intermediate School	Regular School	No	Middle	05	08	2017	grade_1							0.0							0
1689114	OR	school	4100016	2251	Yamhill Carlton SD 1		2251	Yamhill Carlton SD 1						2017	grade_1							4.0							4
1690581	OR	school	4100016	2251	Yamhill Carlton SD 1	410001601266	1213	Yamhill Carlton Elementary School	Regular School	No	Elementary	KG	04	2017	grade_2							73.0							73
1690582	OR	school	4100016	2251	Yamhill Carlton SD 1	410001601288	1238	Yamhill Carlton High School	Regular School	No	High	09	12	2017	grade_2							0.0							0
1690583	OR	school	4100016	2251	Yamhill Carlton SD 1	410001601730	4564	Yamhill Carlton Intermediate School	Regular School	No	Middle	05	08	2017	grade_2							0.0							0
1690584	OR	school	4100016	2251	Yamhill Carlton SD 1		2251	Yamhill Carlton SD 1						2017	grade_2							1.0							1
1692051	OR	school	4100016	2251	Yamhill Carlton SD 1	410001601266	1213	Yamhill Carlton Elementary School	Regular School	No	Elementary	KG	04	2017	grade_3							93.0							93
1692052	OR	school	4100016	2251	Yamhill Carlton SD 1	410001601288	1238	Yamhill Carlton High School	Regular School	No	High	09	12	2017	grade_3							0.0							0
1692053	OR	school	4100016	2251	Yamhill Carlton SD 1	410001601730	4564	Yamhill Carlton Intermediate School	Regular School	No	Middle	05	08	2017	grade_3							0.0							0
1692054	OR	school	4100016	2251	Yamhill Carlton SD 1		2251	Yamhill Carlton SD 1						2017	grade_3							3.0							3
1693521	OR	school	4100016	2251	Yamhill Carlton SD 1	410001601266	1213	Yamhill Carlton Elementary School	Regular School	No	Elementary	KG	04	2017	grade_4							84.0							84
1693522	OR	school	4100016	2251	Yamhill Carlton SD 1	410001601288	1238	Yamhill Carlton High School	Regular School	No	High	09	12	2017	grade_4							0.0							0
1693523	OR	school	4100016	2251	Yamhill Carlton SD 1	410001601730	4564	Yamhill Carlton Intermediate School	Regular School	No	Middle	05	08	2017	grade_4							0.0							0
1693524	OR	school	4100016	2251	Yamhill Carlton SD 1		2251	Yamhill Carlton SD 1						2017	grade_4							2.0							2
1694991	OR	school	4100016	2251	Yamhill Carlton SD 1	410001601266	1213	Yamhill Carlton Elementary School	Regular School	No	Elementary	KG	04	2017	grade_5							0.0							0
1694992	OR	school	4100016	2251	Yamhill Carlton SD 1	410001601288	1238	Yamhill Carlton High School	Regular School	No	High	09	12	2017	grade_5							0.0							0
1694993	OR	school	4100016	2251	Yamhill Carlton SD 1	410001601730	4564	Yamhill Carlton Intermediate School	Regular School	No	Middle	05	08	2017	grade_5							91.0							91
1694994	OR	school	4100016	2251	Yamhill Carlton SD 1		2251	Yamhill Carlton SD 1						2017	grade_5							3.0							3
1696461	OR	school	4100016	2251	Yamhill Carlton SD 1	410001601266	1213	Yamhill Carlton Elementary School	Regular School	No	Elementary	KG	04	2017	grade_6							0.0							0
1696462	OR	school	4100016	2251	Yamhill Carlton SD 1	410001601288	1238	Yamhill Carlton High School	Regular School	No	High	09	12	2017	grade_6							0.0							0
1696463	OR	school	4100016	2251	Yamhill Carlton SD 1	410001601730	4564	Yamhill Carlton Intermediate School	Regular School	No	Middle	05	08	2017	grade_6							83.0							83
1696464	OR	school	4100016	2251	Yamhill Carlton SD 1		2251	Yamhill Carlton SD 1						2017	grade_6							5.0							5
1697931	OR	school	4100016	2251	Yamhill Carlton SD 1	410001601266	1213	Yamhill Carlton Elementary School	Regular School	No	Elementary	KG	04	2017	grade_7							0.0							0
1697932	OR	school	4100016	2251	Yamhill Carlton SD 1	410001601288	1238	Yamhill Carlton High School	Regular School	No	High	09	12	2017	grade_7							0.0							0
1697933	OR	school	4100016	2251	Yamhill Carlton SD 1	410001601730	4564	Yamhill Carlton Intermediate School	Regular School	No	Middle	05	08	2017	grade_7							75.0							75
1697934	OR	school	4100016	2251	Yamhill Carlton SD 1		2251	Yamhill Carlton SD 1						2017	grade_7							4.0							4
1699401	OR	school	4100016	2251	Yamhill Carlton SD 1	410001601266	1213	Yamhill Carlton Elementary School	Regular School	No	Elementary	KG	04	2017	grade_8							0.0							0
1699402	OR	school	4100016	2251	Yamhill Carlton SD 1	410001601288	1238	Yamhill Carlton High School	Regular School	No	High	09	12	2017	grade_8							0.0							0
1699403	OR	school	4100016	2251	Yamhill Carlton SD 1	410001601730	4564	Yamhill Carlton Intermediate School	Regular School	No	Middle	05	08	2017	grade_8							80.0							80
1699404	OR	school	4100016	2251	Yamhill Carlton SD 1		2251	Yamhill Carlton SD 1						2017	grade_8							2.0							2
1700871	OR	school	4100016	2251	Yamhill Carlton SD 1	410001601266	1213	Yamhill Carlton Elementary School	Regular School	No	Elementary	KG	04	2017	grade_9							0.0							0
1700872	OR	school	4100016	2251	Yamhill Carlton SD 1	410001601288	1238	Yamhill Carlton High School	Regular School	No	High	09	12	2017	grade_9							72.0							72
1700873	OR	school	4100016	2251	Yamhill Carlton SD 1	410001601730	4564	Yamhill Carlton Intermediate School	Regular School	No	Middle	05	08	2017	grade_9							0.0							0
1700874	OR	school	4100016	2251	Yamhill Carlton SD 1		2251	Yamhill Carlton SD 1						2017	grade_9							1.0							1
1702341	OR	school	4100016	2251	Yamhill Carlton SD 1	410001601266	1213	Yamhill Carlton Elementary School	Regular School	No	Elementary	KG	04	2017	grade_10							0.0							0
1702342	OR	school	4100016	2251	Yamhill Carlton SD 1	410001601288	1238	Yamhill Carlton High School	Regular School	No	High	09	12	2017	grade_10							80.0							80
1702343	OR	school	4100016	2251	Yamhill Carlton SD 1	410001601730	4564	Yamhill Carlton Intermediate School	Regular School	No	Middle	05	08	2017	grade_10							0.0							0
1702344	OR	school	4100016	2251	Yamhill Carlton SD 1		2251	Yamhill Carlton SD 1						2017	grade_10							2.0							2
1703811	OR	school	4100016	2251	Yamhill Carlton SD 1	410001601266	1213	Yamhill Carlton Elementary School	Regular School	No	Elementary	KG	04	2017	grade_11							0.0							0
1703812	OR	school	4100016	2251	Yamhill Carlton SD 1	410001601288	1238	Yamhill Carlton High School	Regular School	No	High	09	12	2017	grade_11							85.0							85
1703813	OR	school	4100016	2251	Yamhill Carlton SD 1	410001601730	4564	Yamhill Carlton Intermediate School	Regular School	No	Middle	05	08	2017	grade_11							0.0							0
1703814	OR	school	4100016	2251	Yamhill Carlton SD 1		2251	Yamhill Carlton SD 1						2017	grade_11							3.0							3
1705281	OR	school	4100016	2251	Yamhill Carlton SD 1	410001601266	1213	Yamhill Carlton Elementary School	Regular School	No	Elementary	KG	04	2017	grade_12							0.0							0
1705282	OR	school	4100016	2251	Yamhill Carlton SD 1	410001601288	1238	Yamhill Carlton High School	Regular School	No	High	09	12	2017	grade_12							82.0							82
1705283	OR	school	4100016	2251	Yamhill Carlton SD 1	410001601730	4564	Yamhill Carlton Intermediate School	Regular School	No	Middle	05	08	2017	grade_12							0.0							0
1705284	OR	school	4100016	2251	Yamhill Carlton SD 1		2251	Yamhill Carlton SD 1						2017	grade_12							0.0							0
1706751	OR	school	4100016	2251	Yamhill Carlton SD 1	410001601266	1213	Yamhill Carlton Elementary School	Regular School	No	Elementary	KG	04	2017	k_12_total	329.0	2.0	30.0	1.0	0.0	16.0		329	2	30	1	0	16
1706752	OR	school	4100016	2251	Yamhill Carlton SD 1	410001601288	1238	Yamhill Carlton High School	Regular School	No	High	09	12	2017	k_12_total	273.0	1.0	28.0	5.0	1.0	11.0		273	1	28	5	1	11
1706753	OR	school	4100016	2251	Yamhill Carlton SD 1	410001601730	4564	Yamhill Carlton Intermediate School	Regular School	No	Middle	05	08	2017	k_12_total	278.0	2.0	35.0	4.0	0.0	10.0		278	2	35	4	0	10
1706754	OR	school	4100016	2251	Yamhill Carlton SD 1		2251	Yamhill Carlton SD 1						2017	k_12_total	22.0	0.0	6.0	1.0	0.0	1.0		22	0	6	1	0	1
1687628	OR	school	4113530	2146	Woodburn SD 103	411353001714	4540	Academy of International Studies (at Woodburn)	Regular School	No	High	09	12	2017	kindergarten							0.0							0
1687629	OR	school	4113530	2146	Woodburn SD 103	411353000844	1268	French Prairie Middle School	Regular School	No	Middle	06	08	2017	kindergarten							0.0							0
1687630	OR	school	4113530	2146	Woodburn SD 103	411353001051	1359	Heritage Elementary	Regular School	No	Elementary	KG	05	2017	kindergarten							157.0							157