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 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	asian	multiracial	male	female	low_income	disability	total	white_int	black_int	hispanic_int	native_american_int	asian_int	multiracial_int	male_int	female_int	low_income_int	disability_int	total_int
111963	WI	Langlade	school	140	Public Schools-Multidistrict Charters	Antigo Unified	9100	Rural Virtual Academy	charter	2015	pk_12_total	2.0		1.0				2.0	1.0	*	*	3	2		1				2	1			3
111964	WI	Langlade	school	140	Public Schools-Multidistrict Charters	Antigo Unified	9100	Rural Virtual Academy	charter	2015	grade_2											1											1
111965	WI	Langlade	school	140	Public Schools-Multidistrict Charters	Antigo Unified	9100	Rural Virtual Academy	charter	2015	grade_5											1											1
111966	WI	Langlade	school	140	Public Schools-Multidistrict Charters	Antigo Unified	9100	Rural Virtual Academy	charter	2015	grade_9											1											1
112378	WI	Wood	school	203	Public Schools-Multidistrict Charters	Auburndale	9100	Rural Virtual Academy	charter	2015	pk_12_total	1.0							1.0	*	*	1	1							1			1
112379	WI	Wood	school	203	Public Schools-Multidistrict Charters	Auburndale	9100	Rural Virtual Academy	charter	2015	grade_5											1											1
112845	WI	Walworth	school	6013	Public Schools-Multidistrict Charters	Big Foot UHS	9401	Walworth Co Educ Alt High	charter	2015	pk_12_total	13.0		3.0				11.0	5.0	*	4	16	13		3				11	5		4	16
112846	WI	Walworth	school	6013	Public Schools-Multidistrict Charters	Big Foot UHS	9401	Walworth Co Educ Alt High	charter	2015	grade_11											3											3
112847	WI	Walworth	school	6013	Public Schools-Multidistrict Charters	Big Foot UHS	9401	Walworth Co Educ Alt High	charter	2015	grade_12											13											13
113281	WI	Barron	school	903	Public Schools-Multidistrict Charters	Cameron	9410	North Star Academy	charter	2015	pk_12_total	11.0						8.0	3.0	*	3	11	11						8	3		3	11
113282	WI	Barron	school	903	Public Schools-Multidistrict Charters	Cameron	9410	North Star Academy	charter	2015	grade_11											3											3
113283	WI	Barron	school	903	Public Schools-Multidistrict Charters	Cameron	9410	North Star Academy	charter	2015	grade_12											8											8
113480	WI	Barron	school	1080	Public Schools-Multidistrict Charters	Chetek-Weyerhaeuser Area	9410	North Star Academy	charter	2015	pk_12_total	8.0					1.0	5.0	4.0	*	1	9	8					1	5	4		1	9
113481	WI	Barron	school	1080	Public Schools-Multidistrict Charters	Chetek-Weyerhaeuser Area	9410	North Star Academy	charter	2015	grade_11											2											2
113482	WI	Barron	school	1080	Public Schools-Multidistrict Charters	Chetek-Weyerhaeuser Area	9410	North Star Academy	charter	2015	grade_12											7											7
113664	WI	Clark	school	1162	Public Schools-Multidistrict Charters	Colby	9100	Rural Virtual Academy	charter	2015	pk_12_total	2.0			1.0			3.0		*	*	3	2			1			3				3
113665	WI	Clark	school	1162	Public Schools-Multidistrict Charters	Colby	9100	Rural Virtual Academy	charter	2015	grade_3											1											1
113666	WI	Clark	school	1162	Public Schools-Multidistrict Charters	Colby	9100	Rural Virtual Academy	charter	2015	grade_6											1											1
113667	WI	Clark	school	1162	Public Schools-Multidistrict Charters	Colby	9100	Rural Virtual Academy	charter	2015	kindergarten											1											1
114104	WI	Walworth	school	1380	Public Schools-Multidistrict Charters	Delavan-Darien	9401	Walworth Co Educ Alt High	charter	2015	pk_12_total	6.0		1.0		1.0		7.0	1.0	*	1	8	6		1		1		7	1		1	8
114105	WI	Walworth	school	1380	Public Schools-Multidistrict Charters	Delavan-Darien	9401	Walworth Co Educ Alt High	charter	2015	grade_12											8											8
116286	WI	Waupaca	school	2639	Public Schools-Multidistrict Charters	Iola-Scandinavia	9408	Waupaca County Charter	charter	2015	pk_12_total	1.0						1.0		*	*	1	1						1				1
116287	WI	Waupaca	school	2639	Public Schools-Multidistrict Charters	Iola-Scandinavia	9408	Waupaca County Charter	charter	2015	grade_10											1											1
116482	WI	Jefferson	school	2702	Public Schools-Multidistrict Charters	Jefferson	9803	JEDI Virtual K-12	charter	2015	pk_12_total	3.0						1.0	2.0	*	*	3	3						1	2			3
116483	WI	Jefferson	school	2702	Public Schools-Multidistrict Charters	Jefferson	9803	JEDI Virtual K-12	charter	2015	grade_10											1											1
116484	WI	Jefferson	school	2702	Public Schools-Multidistrict Charters	Jefferson	9803	JEDI Virtual K-12	charter	2015	grade_11											1											1
116485	WI	Jefferson	school	2702	Public Schools-Multidistrict Charters	Jefferson	9803	JEDI Virtual K-12	charter	2015	grade_9											1											1
117291	WI	Vernon	school	2863	Public Schools-Multidistrict Charters	La Farge	9407	Vernon County Area Better Futures High	charter	2015	pk_12_total	1.0						1.0		*	*	1	1						1				1
117292	WI	Vernon	school	2863	Public Schools-Multidistrict Charters	La Farge	9407	Vernon County Area Better Futures High	charter	2015	grade_12											1											1
117366	WI	Walworth	school	2884	Public Schools-Multidistrict Charters	Lake Geneva-Genoa City UHS	9401	Walworth Co Educ Alt High	charter	2015	pk_12_total	26.0		2.0				15.0	13.0			28	26		2				15	13			28
117367	WI	Walworth	school	2884	Public Schools-Multidistrict Charters	Lake Geneva-Genoa City UHS	9401	Walworth Co Educ Alt High	charter	2015	grade_11											4											4
117368	WI	Walworth	school	2884	Public Schools-Multidistrict Charters	Lake Geneva-Genoa City UHS	9401	Walworth Co Educ Alt High	charter	2015	grade_12											24											24
118239	WI	Juneau	school	3360	Public Schools-Multidistrict Charters	Mauston	9803	JEDI Virtual K-12	charter	2015	pk_12_total	8.0					1.0		9.0	3		9	8					1		9	3		9
118240	WI	Juneau	school	3360	Public Schools-Multidistrict Charters	Mauston	9803	JEDI Virtual K-12	charter	2015	grade_10											1											1
118241	WI	Juneau	school	3360	Public Schools-Multidistrict Charters	Mauston	9803	JEDI Virtual K-12	charter	2015	grade_11											3											3
118242	WI	Juneau	school	3360	Public Schools-Multidistrict Charters	Mauston	9803	JEDI Virtual K-12	charter	2015	grade_12											2											2
118243	WI	Juneau	school	3360	Public Schools-Multidistrict Charters	Mauston	9803	JEDI Virtual K-12	charter	2015	grade_3											1											1
118244	WI	Juneau	school	3360	Public Schools-Multidistrict Charters	Mauston	9803	JEDI Virtual K-12	charter	2015	grade_8											1											1
118245	WI	Juneau	school	3360	Public Schools-Multidistrict Charters	Mauston	9803	JEDI Virtual K-12	charter	2015	grade_9											1											1
120519	WI	Marathon	school	3787	Public Schools-Multidistrict Charters	Mosinee	9100	Rural Virtual Academy	charter	2015	pk_12_total	8.0		2.0				4.0	6.0	4	2	10	8		2				4	6	4	2	10
120520	WI	Marathon	school	3787	Public Schools-Multidistrict Charters	Mosinee	9100	Rural Virtual Academy	charter	2015	grade_1											1											1
120521	WI	Marathon	school	3787	Public Schools-Multidistrict Charters	Mosinee	9100	Rural Virtual Academy	charter	2015	grade_3											1											1
120522	WI	Marathon	school	3787	Public Schools-Multidistrict Charters	Mosinee	9100	Rural Virtual Academy	charter	2015	grade_4											1											1
120523	WI	Marathon	school	3787	Public Schools-Multidistrict Charters	Mosinee	9100	Rural Virtual Academy	charter	2015	grade_5											1											1
120524	WI	Marathon	school	3787	Public Schools-Multidistrict Charters	Mosinee	9100	Rural Virtual Academy	charter	2015	grade_7											2											2
120525	WI	Marathon	school	3787	Public Schools-Multidistrict Charters	Mosinee	9100	Rural Virtual Academy	charter	2015	grade_8											1											1
120526	WI	Marathon	school	3787	Public Schools-Multidistrict Charters	Mosinee	9100	Rural Virtual Academy	charter	2015	grade_9											3											3
120660	WI	Juneau	school	3871	Public Schools-Multidistrict Charters	Necedah Area	9405	Juneau County Charter School	charter	2015	pk_12_total	8.0		1.0				6.0	3.0	*		9	8		1				6	3			9
120661	WI	Juneau	school	3871	Public Schools-Multidistrict Charters	Necedah Area	9405	Juneau County Charter School	charter	2015	grade_10											2											2
120662	WI	Juneau	school	3871	Public Schools-Multidistrict Charters	Necedah Area	9405	Juneau County Charter School	charter	2015	grade_11											2											2
120663	WI	Juneau	school	3871	Public Schools-Multidistrict Charters	Necedah Area	9405	Juneau County Charter School	charter	2015	grade_12											5											5
122236	WI	Price	school	4571	Public Schools-Multidistrict Charters	Prentice	9100	Rural Virtual Academy	charter	2015	pk_12_total	3.0						1.0	2.0	*	*	3	3						1	2			3
122237	WI	Price	school	4571	Public Schools-Multidistrict Charters	Prentice	9100	Rural Virtual Academy	charter	2015	grade_2											1											1
122238	WI	Price	school	4571	Public Schools-Multidistrict Charters	Prentice	9100	Rural Virtual Academy	charter	2015	grade_5											1											1
122239	WI	Price	school	4571	Public Schools-Multidistrict Charters	Prentice	9100	Rural Virtual Academy	charter	2015	kindergarten											1											1
122741	WI	Taylor	school	4795	Public Schools-Multidistrict Charters	Rib Lake	9100	Rural Virtual Academy	charter	2015	pk_12_total	6.0	1.0					3.0	4.0	*		7	6	1					3	4			7
122742	WI	Taylor	school	4795	Public Schools-Multidistrict Charters	Rib Lake	9100	Rural Virtual Academy	charter	2015	grade_1											1											1
122743	WI	Taylor	school	4795	Public Schools-Multidistrict Charters	Rib Lake	9100	Rural Virtual Academy	charter	2015	grade_2											1											1
122744	WI	Taylor	school	4795	Public Schools-Multidistrict Charters	Rib Lake	9100	Rural Virtual Academy	charter	2015	grade_3											2											2
122745	WI	Taylor	school	4795	Public Schools-Multidistrict Charters	Rib Lake	9100	Rural Virtual Academy	charter	2015	grade_8											1											1
122746	WI	Taylor	school	4795	Public Schools-Multidistrict Charters	Rib Lake	9100	Rural Virtual Academy	charter	2015	kindergarten_4_year_old											2											2
123873	WI	Marathon	school	5467	Public Schools-Multidistrict Charters	Spencer	9100	Rural Virtual Academy	charter	2015	pk_12_total	9.0		1.0				5.0	5.0	*		10	9		1				5	5			10
123874	WI	Marathon	school	5467	Public Schools-Multidistrict Charters	Spencer	9100	Rural Virtual Academy	charter	2015	grade_1											1											1
123875	WI	Marathon	school	5467	Public Schools-Multidistrict Charters	Spencer	9100	Rural Virtual Academy	charter	2015	grade_2											3											3
123876	WI	Marathon	school	5467	Public Schools-Multidistrict Charters	Spencer	9100	Rural Virtual Academy	charter	2015	grade_4											1											1
123877	WI	Marathon	school	5467	Public Schools-Multidistrict Charters	Spencer	9100	Rural Virtual Academy	charter	2015	grade_5											1											1
123878	WI	Marathon	school	5467	Public Schools-Multidistrict Charters	Spencer	9100	Rural Virtual Academy	charter	2015	grade_8											2											2
123879	WI	Marathon	school	5467	Public Schools-Multidistrict Charters	Spencer	9100	Rural Virtual Academy	charter	2015	grade_9											1											1
123880	WI	Marathon	school	5467	Public Schools-Multidistrict Charters	Spencer	9100	Rural Virtual Academy	charter	2015	kindergarten_4_year_old											1											1
124103	WI	Dane	school	5621	Public Schools-Multidistrict Charters	Stoughton Area	9803	JEDI Virtual K-12	charter	2015	pk_12_total	20.0		2.0			1.0	6.0	17.0	5	2	23	20		2			1	6	17	5	2	23
124104	WI	Dane	school	5621	Public Schools-Multidistrict Charters	Stoughton Area	9803	JEDI Virtual K-12	charter	2015	grade_1											1											1
124105	WI	Dane	school	5621	Public Schools-Multidistrict Charters	Stoughton Area	9803	JEDI Virtual K-12	charter	2015	grade_10											4											4
124106	WI	Dane	school	5621	Public Schools-Multidistrict Charters	Stoughton Area	9803	JEDI Virtual K-12	charter	2015	grade_11											7											7
124107	WI	Dane	school	5621	Public Schools-Multidistrict Charters	Stoughton Area	9803	JEDI Virtual K-12	charter	2015	grade_12											5											5
124108	WI	Dane	school	5621	Public Schools-Multidistrict Charters	Stoughton Area	9803	JEDI Virtual K-12	charter	2015	grade_8											2											2
124109	WI	Dane	school	5621	Public Schools-Multidistrict Charters	Stoughton Area	9803	JEDI Virtual K-12	charter	2015	grade_9											3											3
124110	WI	Dane	school	5621	Public Schools-Multidistrict Charters	Stoughton Area	9803	JEDI Virtual K-12	charter	2015	kindergarten											1											1
124136	WI	Marathon	school	5628	Public Schools-Multidistrict Charters	Stratford	9100	Rural Virtual Academy	charter	2015	pk_12_total	3.0							3.0	*	*	3	3							3			3
124137	WI	Marathon	school	5628	Public Schools-Multidistrict Charters	Stratford	9100	Rural Virtual Academy	charter	2015	grade_3											1											1
124138	WI	Marathon	school	5628	Public Schools-Multidistrict Charters	Stratford	9100	Rural Virtual Academy	charter	2015	grade_7											1											1
124139	WI	Marathon	school	5628	Public Schools-Multidistrict Charters	Stratford	9100	Rural Virtual Academy	charter	2015	grade_8											1											1
124213	WI	Dane	school	5656	Public Schools-Multidistrict Charters	Sun Prairie Area	9803	JEDI Virtual K-12	charter	2015	pk_12_total	14.0		1.0		1.0		10.0	6.0		1	16	14		1		1		10	6		1	16
124214	WI	Dane	school	5656	Public Schools-Multidistrict Charters	Sun Prairie Area	9803	JEDI Virtual K-12	charter	2015	grade_10											1											1
124215	WI	Dane	school	5656	Public Schools-Multidistrict Charters	Sun Prairie Area	9803	JEDI Virtual K-12	charter	2015	grade_11											2											2
124216	WI	Dane	school	5656	Public Schools-Multidistrict Charters	Sun Prairie Area	9803	JEDI Virtual K-12	charter	2015	grade_12											4											4
124217	WI	Dane	school	5656	Public Schools-Multidistrict Charters	Sun Prairie Area	9803	JEDI Virtual K-12	charter	2015	grade_2											1											1
124218	WI	Dane	school	5656	Public Schools-Multidistrict Charters	Sun Prairie Area	9803	JEDI Virtual K-12	charter	2015	grade_3											1											1
124219	WI	Dane	school	5656	Public Schools-Multidistrict Charters	Sun Prairie Area	9803	JEDI Virtual K-12	charter	2015	grade_5											1											1
124220	WI	Dane	school	5656	Public Schools-Multidistrict Charters	Sun Prairie Area	9803	JEDI Virtual K-12	charter	2015	grade_6											2											2
124221	WI	Dane	school	5656	Public Schools-Multidistrict Charters	Sun Prairie Area	9803	JEDI Virtual K-12	charter	2015	grade_7											1											1
124222	WI	Dane	school	5656	Public Schools-Multidistrict Charters	Sun Prairie Area	9803	JEDI Virtual K-12	charter	2015	grade_8											1											1
124223	WI	Dane	school	5656	Public Schools-Multidistrict Charters	Sun Prairie Area	9803	JEDI Virtual K-12	charter	2015	grade_9											1											1
124224	WI	Dane	school	5656	Public Schools-Multidistrict Charters	Sun Prairie Area	9803	JEDI Virtual K-12	charter	2015	kindergarten											1											1
124566	WI	Barron	school	5810	Public Schools-Multidistrict Charters	Turtle Lake	9410	North Star Academy	charter	2015	pk_12_total	3.0							3.0	*	*	3	3							3			3
124567	WI	Barron	school	5810	Public Schools-Multidistrict Charters	Turtle Lake	9410	North Star Academy	charter	2015	grade_12											3											3
124618	WI	Manitowoc	school	5824	Public Schools-Multidistrict Charters	Two Rivers Public	9120	Manitowoc County Comprehensive Charter School	charter	2015	pk_12_total			1.0	1.0			2.0		*	*	2			1	1			2				2
124619	WI	Manitowoc	school	5824	Public Schools-Multidistrict Charters	Two Rivers Public	9120	Manitowoc County Comprehensive Charter School	charter	2015	grade_8											2											2
125173	WI	Waupaca	school	6195	Public Schools-Multidistrict Charters	Waupaca	9408	Waupaca County Charter	charter	2015	pk_12_total	2.0						2.0		*	*	2	2						2				2
125174	WI	Waupaca	school	6195	Public Schools-Multidistrict Charters	Waupaca	9408	Waupaca County Charter	charter	2015	grade_5											1											1
125175	WI	Waupaca	school	6195	Public Schools-Multidistrict Charters	Waupaca	9408	Waupaca County Charter	charter	2015	grade_7											1											1
125820	WI	Vernon	school	6321	Public Schools-Multidistrict Charters	Westby Area	9407	Vernon County Area Better Futures High	charter	2015	pk_12_total	1.0						1.0		*	*	1	1						1				1