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 ccd_charter_school limit 101

Query parameters

This data as json, CSV

rowid	state	county	admin_level	district_state_id	district_state_type	district	school_state_id	school	school_state_type	year	grade	white	black	hispanic	native_american	multiracial	male	female	low_income	disability	total	white_int	black_int	hispanic_int	native_american_int	multiracial_int	male_int	female_int	low_income_int	disability_int	total_int
325625	WI	Clark	school	7	Public Schools-Multidistrict Charters	Abbotsford	9100	Rural Virtual Academy	charter	2017	pk_12_total	1.0						1.0	*	*	1	1						1			1
325626	WI	Clark	school	7	Public Schools-Multidistrict Charters	Abbotsford	9100	Rural Virtual Academy	charter	2017	grade_4										1										1
325829	WI	Langlade	school	140	Public Schools-Multidistrict Charters	Antigo Unified	9100	Rural Virtual Academy	charter	2017	pk_12_total	13.0	1.0				8.0	6.0	6	3	14	13	1				8	6	6	3	14
325830	WI	Langlade	school	140	Public Schools-Multidistrict Charters	Antigo Unified	9100	Rural Virtual Academy	charter	2017	grade_10										1										1
325831	WI	Langlade	school	140	Public Schools-Multidistrict Charters	Antigo Unified	9100	Rural Virtual Academy	charter	2017	grade_11										5										5
325832	WI	Langlade	school	140	Public Schools-Multidistrict Charters	Antigo Unified	9100	Rural Virtual Academy	charter	2017	grade_4										1										1
325833	WI	Langlade	school	140	Public Schools-Multidistrict Charters	Antigo Unified	9100	Rural Virtual Academy	charter	2017	grade_6										2										2
325834	WI	Langlade	school	140	Public Schools-Multidistrict Charters	Antigo Unified	9100	Rural Virtual Academy	charter	2017	grade_8										3										3
325835	WI	Langlade	school	140	Public Schools-Multidistrict Charters	Antigo Unified	9100	Rural Virtual Academy	charter	2017	kindergarten_4_year_old										1										1
325836	WI	Langlade	school	140	Public Schools-Multidistrict Charters	Antigo Unified	9100	Rural Virtual Academy	charter	2017	kindergarten										1										1
326256	WI	Wood	school	203	Public Schools-Multidistrict Charters	Auburndale	9100	Rural Virtual Academy	charter	2017	pk_12_total	5.0					2.0	3.0	*	*	5	5					2	3			5
326257	WI	Wood	school	203	Public Schools-Multidistrict Charters	Auburndale	9100	Rural Virtual Academy	charter	2017	grade_3										1										1
326258	WI	Wood	school	203	Public Schools-Multidistrict Charters	Auburndale	9100	Rural Virtual Academy	charter	2017	grade_4										1										1
326259	WI	Wood	school	203	Public Schools-Multidistrict Charters	Auburndale	9100	Rural Virtual Academy	charter	2017	grade_7										1										1
326260	WI	Wood	school	203	Public Schools-Multidistrict Charters	Auburndale	9100	Rural Virtual Academy	charter	2017	grade_9										1										1
326261	WI	Wood	school	203	Public Schools-Multidistrict Charters	Auburndale	9100	Rural Virtual Academy	charter	2017	kindergarten										1										1
326415	WI	Barron	school	308	Public Schools-Multidistrict Charters	Barron Area	9410	North Star Academy	charter	2017	pk_12_total	14.0		1.0			10.0	5.0	2	2	15	14		1			10	5	2	2	15
326416	WI	Barron	school	308	Public Schools-Multidistrict Charters	Barron Area	9410	North Star Academy	charter	2017	grade_11										3										3
326417	WI	Barron	school	308	Public Schools-Multidistrict Charters	Barron Area	9410	North Star Academy	charter	2017	grade_12										12										12
326726	WI	Walworth	school	6013	Public Schools-Multidistrict Charters	Big Foot UHS	9401	Walworth Co Educ Alt High	charter	2017	pk_12_total	4.0		2.0			2.0	4.0	*	*	6	4		2			2	4			6
326727	WI	Walworth	school	6013	Public Schools-Multidistrict Charters	Big Foot UHS	9401	Walworth Co Educ Alt High	charter	2017	grade_11										2										2
326728	WI	Walworth	school	6013	Public Schools-Multidistrict Charters	Big Foot UHS	9401	Walworth Co Educ Alt High	charter	2017	grade_12										4										4
327364	WI	Barron	school	1080	Public Schools-Multidistrict Charters	Chetek-Weyerhaeuser Area	9410	North Star Academy	charter	2017	pk_12_total	10.0					6.0	4.0	*	1	10	10					6	4		1	10
327365	WI	Barron	school	1080	Public Schools-Multidistrict Charters	Chetek-Weyerhaeuser Area	9410	North Star Academy	charter	2017	grade_10										1										1
327366	WI	Barron	school	1080	Public Schools-Multidistrict Charters	Chetek-Weyerhaeuser Area	9410	North Star Academy	charter	2017	grade_11										2										2
327367	WI	Barron	school	1080	Public Schools-Multidistrict Charters	Chetek-Weyerhaeuser Area	9410	North Star Academy	charter	2017	grade_12										7										7
327548	WI	Clark	school	1162	Public Schools-Multidistrict Charters	Colby	9100	Rural Virtual Academy	charter	2017	pk_12_total	2.0						2.0	*	*	2	2						2			2
327549	WI	Clark	school	1162	Public Schools-Multidistrict Charters	Colby	9100	Rural Virtual Academy	charter	2017	grade_11										1										1
327550	WI	Clark	school	1162	Public Schools-Multidistrict Charters	Colby	9100	Rural Virtual Academy	charter	2017	grade_7										1										1
327995	WI	Walworth	school	1380	Public Schools-Multidistrict Charters	Delavan-Darien	9401	Walworth Co Educ Alt High	charter	2017	pk_12_total	4.0		2.0			2.0	4.0	*	*	6	4		2			2	4			6
327996	WI	Walworth	school	1380	Public Schools-Multidistrict Charters	Delavan-Darien	9401	Walworth Co Educ Alt High	charter	2017	grade_11										1										1
327997	WI	Walworth	school	1380	Public Schools-Multidistrict Charters	Delavan-Darien	9401	Walworth Co Educ Alt High	charter	2017	grade_12										5										5
330367	WI	Jefferson	school	2702	Public Schools-Multidistrict Charters	Jefferson	9803	JEDI Virtual K-12	charter	2017	pk_12_total	5.0					2.0	3.0	*	*	5	5					2	3			5
330368	WI	Jefferson	school	2702	Public Schools-Multidistrict Charters	Jefferson	9803	JEDI Virtual K-12	charter	2017	grade_11										3										3
330369	WI	Jefferson	school	2702	Public Schools-Multidistrict Charters	Jefferson	9803	JEDI Virtual K-12	charter	2017	grade_12										2										2
330920	WI	Vernon	school	5960	Public Schools-Multidistrict Charters	Kickapoo Area	9407	Vernon County Area Better Futures High	charter	2017	pk_12_total	1.0						1.0	*	*	1	1						1			1
330921	WI	Vernon	school	5960	Public Schools-Multidistrict Charters	Kickapoo Area	9407	Vernon County Area Better Futures High	charter	2017	grade_12										1										1
331160	WI	Vernon	school	2863	Public Schools-Multidistrict Charters	La Farge	9407	Vernon County Area Better Futures High	charter	2017	pk_12_total	1.0					1.0		*	*	1	1					1				1
331161	WI	Vernon	school	2863	Public Schools-Multidistrict Charters	La Farge	9407	Vernon County Area Better Futures High	charter	2017	grade_12										1										1
331231	WI	Walworth	school	2884	Public Schools-Multidistrict Charters	Lake Geneva-Genoa City UHS	9401	Walworth Co Educ Alt High	charter	2017	pk_12_total	20.0		2.0		2.0	12.0	12.0	5	1	24	20		2		2	12	12	5	1	24
331232	WI	Walworth	school	2884	Public Schools-Multidistrict Charters	Lake Geneva-Genoa City UHS	9401	Walworth Co Educ Alt High	charter	2017	grade_11										5										5
331233	WI	Walworth	school	2884	Public Schools-Multidistrict Charters	Lake Geneva-Genoa City UHS	9401	Walworth Co Educ Alt High	charter	2017	grade_12										19										19
331251	WI	Jefferson	school	2898	Public Schools-Multidistrict Charters	Lake Mills Area	9803	JEDI Virtual K-12	charter	2017	pk_12_total	1.0					1.0		*	*	1	1					1				1
331252	WI	Jefferson	school	2898	Public Schools-Multidistrict Charters	Lake Mills Area	9803	JEDI Virtual K-12	charter	2017	grade_8										1										1
331824	WI	Waupaca	school	3276	Public Schools-Multidistrict Charters	Manawa	9408	Waupaca County Charter	charter	2017	pk_12_total	1.0					1.0		*	*	1	1					1				1
331825	WI	Waupaca	school	3276	Public Schools-Multidistrict Charters	Manawa	9408	Waupaca County Charter	charter	2017	grade_10										1										1
332095	WI	Juneau	school	3360	Public Schools-Multidistrict Charters	Mauston	9803	JEDI Virtual K-12		2017	pk_12_total	8.0					2.0	6.0	1	1	8	8					2	6	1	1	8
332096	WI	Juneau	school	3360	Public Schools-Multidistrict Charters	Mauston	9803	JEDI Virtual K-12		2017	grade_10										1										1
332097	WI	Juneau	school	3360	Public Schools-Multidistrict Charters	Mauston	9803	JEDI Virtual K-12		2017	grade_11										1										1
332098	WI	Juneau	school	3360	Public Schools-Multidistrict Charters	Mauston	9803	JEDI Virtual K-12		2017	grade_12										1										1
332099	WI	Juneau	school	3360	Public Schools-Multidistrict Charters	Mauston	9803	JEDI Virtual K-12		2017	grade_2										1										1
332100	WI	Juneau	school	3360	Public Schools-Multidistrict Charters	Mauston	9803	JEDI Virtual K-12		2017	grade_5										3										3
332101	WI	Juneau	school	3360	Public Schools-Multidistrict Charters	Mauston	9803	JEDI Virtual K-12		2017	kindergarten_4_year_old										1										1
334256	WI	Green	school	3682	Public Schools-Multidistrict Charters	Monroe	9803	JEDI Virtual K-12	charter	2017	pk_12_total	3.0		1.0			1.0	3.0	*	*	4	3		1			1	3			4
334257	WI	Green	school	3682	Public Schools-Multidistrict Charters	Monroe	9803	JEDI Virtual K-12	charter	2017	grade_10										2										2
334258	WI	Green	school	3682	Public Schools-Multidistrict Charters	Monroe	9803	JEDI Virtual K-12	charter	2017	grade_11										1										1
334259	WI	Green	school	3682	Public Schools-Multidistrict Charters	Monroe	9803	JEDI Virtual K-12	charter	2017	grade_8										1										1
334351	WI	Marathon	school	3787	Public Schools-Multidistrict Charters	Mosinee	9100	Rural Virtual Academy	charter	2017	pk_12_total	10.0		1.0	2.0	1.0	5.0	9.0	2	1	14	10		1	2	1	5	9	2	1	14
334352	WI	Marathon	school	3787	Public Schools-Multidistrict Charters	Mosinee	9100	Rural Virtual Academy	charter	2017	grade_10										4										4
334353	WI	Marathon	school	3787	Public Schools-Multidistrict Charters	Mosinee	9100	Rural Virtual Academy	charter	2017	grade_11										3										3
334354	WI	Marathon	school	3787	Public Schools-Multidistrict Charters	Mosinee	9100	Rural Virtual Academy	charter	2017	grade_2										1										1
334355	WI	Marathon	school	3787	Public Schools-Multidistrict Charters	Mosinee	9100	Rural Virtual Academy	charter	2017	grade_7										2										2
334356	WI	Marathon	school	3787	Public Schools-Multidistrict Charters	Mosinee	9100	Rural Virtual Academy	charter	2017	grade_8										1										1
334357	WI	Marathon	school	3787	Public Schools-Multidistrict Charters	Mosinee	9100	Rural Virtual Academy	charter	2017	grade_9										1										1
334358	WI	Marathon	school	3787	Public Schools-Multidistrict Charters	Mosinee	9100	Rural Virtual Academy	charter	2017	kindergarten										2										2
334495	WI	Juneau	school	3871	Public Schools-Multidistrict Charters	Necedah Area	9405	Juneau County Charter School	charter	2017	pk_12_total	6.0					3.0	3.0	*	*	6	6					3	3			6
334496	WI	Juneau	school	3871	Public Schools-Multidistrict Charters	Necedah Area	9405	Juneau County Charter School	charter	2017	grade_11										5										5
334497	WI	Juneau	school	3871	Public Schools-Multidistrict Charters	Necedah Area	9405	Juneau County Charter School	charter	2017	grade_12										1										1
335799	WI	Wood	school	4368	Public Schools-Multidistrict Charters	Pittsville	9100	Rural Virtual Academy	charter	2017	pk_12_total	5.0					2.0	3.0	*	*	5	5					2	3			5
335800	WI	Wood	school	4368	Public Schools-Multidistrict Charters	Pittsville	9100	Rural Virtual Academy	charter	2017	grade_10										1										1
335801	WI	Wood	school	4368	Public Schools-Multidistrict Charters	Pittsville	9100	Rural Virtual Academy	charter	2017	grade_4										1										1
335802	WI	Wood	school	4368	Public Schools-Multidistrict Charters	Pittsville	9100	Rural Virtual Academy	charter	2017	grade_5										1										1
335803	WI	Wood	school	4368	Public Schools-Multidistrict Charters	Pittsville	9100	Rural Virtual Academy	charter	2017	grade_7										1										1
335804	WI	Wood	school	4368	Public Schools-Multidistrict Charters	Pittsville	9100	Rural Virtual Academy	charter	2017	grade_8										1										1
336075	WI	Price	school	4571	Public Schools-Multidistrict Charters	Prentice	9100	Rural Virtual Academy	charter	2017	pk_12_total	12.0					4.0	8.0			12	12					4	8			12
336076	WI	Price	school	4571	Public Schools-Multidistrict Charters	Prentice	9100	Rural Virtual Academy	charter	2017	grade_2										2										2
336077	WI	Price	school	4571	Public Schools-Multidistrict Charters	Prentice	9100	Rural Virtual Academy	charter	2017	grade_4										3										3
336078	WI	Price	school	4571	Public Schools-Multidistrict Charters	Prentice	9100	Rural Virtual Academy	charter	2017	grade_6										1										1
336079	WI	Price	school	4571	Public Schools-Multidistrict Charters	Prentice	9100	Rural Virtual Academy	charter	2017	grade_7										1										1
336080	WI	Price	school	4571	Public Schools-Multidistrict Charters	Prentice	9100	Rural Virtual Academy	charter	2017	grade_9										3										3
336081	WI	Price	school	4571	Public Schools-Multidistrict Charters	Prentice	9100	Rural Virtual Academy	charter	2017	kindergarten										2										2
336599	WI	Taylor	school	4795	Public Schools-Multidistrict Charters	Rib Lake	9100	Rural Virtual Academy	charter	2017	pk_12_total	8.0	1.0				5.0	4.0		1	9	8	1				5	4		1	9
336600	WI	Taylor	school	4795	Public Schools-Multidistrict Charters	Rib Lake	9100	Rural Virtual Academy	charter	2017	grade_10										2										2
336601	WI	Taylor	school	4795	Public Schools-Multidistrict Charters	Rib Lake	9100	Rural Virtual Academy	charter	2017	grade_11										1										1
336602	WI	Taylor	school	4795	Public Schools-Multidistrict Charters	Rib Lake	9100	Rural Virtual Academy	charter	2017	grade_3										1										1
336603	WI	Taylor	school	4795	Public Schools-Multidistrict Charters	Rib Lake	9100	Rural Virtual Academy	charter	2017	grade_4										1										1
336604	WI	Taylor	school	4795	Public Schools-Multidistrict Charters	Rib Lake	9100	Rural Virtual Academy	charter	2017	grade_5										1										1
336605	WI	Taylor	school	4795	Public Schools-Multidistrict Charters	Rib Lake	9100	Rural Virtual Academy	charter	2017	grade_9										1										1
336606	WI	Taylor	school	4795	Public Schools-Multidistrict Charters	Rib Lake	9100	Rural Virtual Academy	charter	2017	kindergarten_4_year_old										2										2
337718	WI	Marathon	school	5467	Public Schools-Multidistrict Charters	Spencer	9100	Rural Virtual Academy	charter	2017	pk_12_total	11.0		1.0			8.0	4.0		1	12	11		1			8	4		1	12
337719	WI	Marathon	school	5467	Public Schools-Multidistrict Charters	Spencer	9100	Rural Virtual Academy	charter	2017	grade_1										2										2
337720	WI	Marathon	school	5467	Public Schools-Multidistrict Charters	Spencer	9100	Rural Virtual Academy	charter	2017	grade_10										2										2
337721	WI	Marathon	school	5467	Public Schools-Multidistrict Charters	Spencer	9100	Rural Virtual Academy	charter	2017	grade_11										1										1
337722	WI	Marathon	school	5467	Public Schools-Multidistrict Charters	Spencer	9100	Rural Virtual Academy	charter	2017	grade_3										2										2
337723	WI	Marathon	school	5467	Public Schools-Multidistrict Charters	Spencer	9100	Rural Virtual Academy	charter	2017	grade_4										2										2
337724	WI	Marathon	school	5467	Public Schools-Multidistrict Charters	Spencer	9100	Rural Virtual Academy	charter	2017	grade_7										1										1
337725	WI	Marathon	school	5467	Public Schools-Multidistrict Charters	Spencer	9100	Rural Virtual Academy	charter	2017	grade_8										2										2
337942	WI	Dane	school	5621	Public Schools-Multidistrict Charters	Stoughton Area	9803	JEDI Virtual K-12	charter	2017	pk_12_total	12.0		2.0		2.0	6.0	10.0	2	4	16	12		2		2	6	10	2	4	16
337943	WI	Dane	school	5621	Public Schools-Multidistrict Charters	Stoughton Area	9803	JEDI Virtual K-12	charter	2017	grade_10										2										2
337944	WI	Dane	school	5621	Public Schools-Multidistrict Charters	Stoughton Area	9803	JEDI Virtual K-12	charter	2017	grade_11										4										4
337945	WI	Dane	school	5621	Public Schools-Multidistrict Charters	Stoughton Area	9803	JEDI Virtual K-12	charter	2017	grade_12										5										5