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 order by male limit 101

Query parameters

This data as json, CSV

rowid	state	county	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	grade	white	black	hispanic	native_american	asian	multiracial	female	low_income	disability	total	white_int	black_int	hispanic_int	native_american_int	asian_int	multiracial_int	female_int	low_income_int	total_int
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
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
122923	WI	Pierce	school	5513050	4893	Public school	River Falls	551305002999	430	River Falls eSchool	charter	Regular School	Yes	4.0	06	12	2015	pk_12_total	1.0						1.0	*	*	1	1						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
124524	WI	Portage	school	5500330	126	Public school	Tomorrow River	550033002984	850	Central Wisconsin Virtual School	charter	Regular School	Yes	4.0	06	12	2015	pk_12_total	2.0						2.0	*	*	2	2						2		2
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
284019	WI	Vernon	school	5503240	1421	Public school	De Soto Area	550324003022	810	De Soto Virtual School	charter	Regular School	Yes	4.0	PK	12	2016	pk_12_total	1.0						1.0	*	*	1	1						1		1
287377	WI	Jefferson	school		2898	Public Schools-Multidistrict Charters	Lake Mills Area		9803	JEDI Virtual K-12	charter						2016	pk_12_total	1.0						1.0	*	*	1	1						1		1
294070	WI	Marathon	school		5628	Public Schools-Multidistrict Charters	Stratford		9100	Rural Virtual Academy	charter						2016	pk_12_total	3.0						3.0	*	*	3	3						3		3
294497	WI	Barron	school	5515060	5810	Public school	Turtle Lake	551506003032	810	Laker Online	charter	Regular School	Yes	4.0	PK	12	2016	pk_12_total	1.0						1.0	*	*	1	1						1		1
295760	WI	Vernon	school		6321	Public Schools-Multidistrict Charters	Westby Area		9407	Vernon County Area Better Futures High	charter						2016	pk_12_total	2.0						2.0	*	*	2	2						2		2
296243	WI	Juneau	school		6713	Public Schools-Multidistrict Charters	Wonewoc-Union Center		9405	Juneau County Charter School	charter						2016	pk_12_total	1.0						1.0	*	*	1	1						1		1
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
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
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
331601	WI	Dane	school	5508520	3269	Public school	Madison Metropolitan	550852002909	220	Innovative & Alternative Middle		Alternative School	No	Middle	06	08	2017	pk_12_total		1.0					1.0	*	*	1		1					1		1
339536	WI	Milwaukee	school	5516260	6300	Public school	West Allis-West Milwaukee	551626002918	410	Shared Journeys	charter	Alternative School	Yes	High	07	12	2017	pk_12_total	8.0	1.0	4.0		1.0	1.0	15.0	*		15	8	1	4		1	1	15		15
339619	WI	Washington	school	5516290	6307	Public school	West Bend	551629002666	400	Washington Street School		Alternative School	No	Other	06	12	2017	pk_12_total	1.0						1.0	*	*	1	1						1		1
2319506	WI	Rusk	school		735	Public Schools-Multidistrict Charters	Bruce		9419	eSucceed Charter School	charter						2020	pk_12_total										0									0
2319612	WI	Chippewa	school		870	Public Schools-Multidistrict Charters	Cadott Community		9419	eSucceed Charter School	charter						2020	pk_12_total	1.0						1.0	*	*	1	1						1		1
2319861	WI	Price	school		1071	Public Schools-Multidistrict Charters	Chequamegon		9100	Rural Virtual Academy	charter						2020	pk_12_total										0									0
2320163	WI	Chippewa	school		1204	Public Schools-Multidistrict Charters	Cornell		9419	eSucceed Charter School	charter						2020	pk_12_total										0									0
2320794	WI	Eau Claire	school	5504050	1554	Public school	Eau Claire Area	550405002675	430	Oxford Avenue School		Alternative School	No	High	10	12	2020	pk_12_total										0									0
2321100	WI	Pierce	school	5504350	1666	Public school	Elmwood	550435003121	800	Western Wisconsin Virtual Charter School (WWVC)	charter	Regular School	Yes	Other	PK	12	2020	pk_12_total										0									0
2321363	WI	Jefferson	school		1883	Public Schools-Multidistrict Charters	Fort Atkinson		9803	JEDI Virtual K-12	charter						2020	pk_12_total										0									0
2321623	WI	Taylor	school	5505280	2135	Public school	Gilman	550528003114	9419	eSucceed Charter School	charter	Regular School	Yes	High	09	12	2020	pk_12_total	1.0						1.0	*	*	1	1						1		1
2323488	WI	Vernon	school		5960	Public Schools-Multidistrict Charters	Kickapoo Area		9407	Vernon County Area Better Futures High	charter						2020	pk_12_total										0									0
2323749	WI	Vilas	school		1848	Public Schools-Multidistrict Charters	Lac du Flambeau #1		9418	Lakeland STAR School--Strong Talented Adventurous Remarkable	charter						2020	pk_12_total										0									0
2323821	WI	Walworth	school	5507650	2884	Public school	Lake Geneva-Genoa City UHS	550765003109	410	New Visions Charter School	charter	Regular School	Yes	High	09	12	2020	pk_12_total			1.0				1.0	*	*	1			1				1		1
2323826	WI	Chippewa	school		2891	Public Schools-Multidistrict Charters	Lake Holcombe		9419	eSucceed Charter School	charter						2020	pk_12_total	1.0						1.0	*	*	1	1						1		1
2324223	WI	Dane	school	5508520	3269	Public school	Madison Metropolitan	550852002909	220	Innovative & Alternative Middle		Alternative School	No	Middle	06	08	2020	pk_12_total										0									0
2324631	WI	Dane	school		3332	Public Schools-Multidistrict Charters	Marshall		9803	JEDI Virtual K-12	charter						2020	pk_12_total										0									0
2324728	WI	Juneau	school		3360	Public Schools-Multidistrict Charters	Mauston		9803	JEDI Virtual K-12	charter						2020	pk_12_total	3.0					1.0	4.0	*	*	4	3					1	4		4
2327575	WI	Vilas	school		616	Public Schools-Multidistrict Charters	North Lakeland		9418	Lakeland STAR School--Strong Talented Adventurous Remarkable	charter						2020	pk_12_total										0									0
2327699	WI	Washburn	school	5509720	3654	Public school	Northwood	550972003018	800	Northwood Virtual Charter School	charter	Regular School	Yes	Other	PK	12	2020	pk_12_total										0									0
2331903	WI	Marathon	school	5515900	6223	Public school	Wausau	551590003027	800	Wausau Area Virtual Education	charter	Regular School	Yes	High	06	12	2020	pk_12_total	3.0		1.0				4.0	*	*	4	3		1				4		4
2332217	WI	Milwaukee	school	5516260	6300	Public school	West Allis-West Milwaukee	551626002918	410	Shared Journeys	charter	Alternative School	Yes	High	07	12	2020	pk_12_total	3.0		2.0				5.0	*	*	5	3		2				5		5
2332353	WI	Vernon	school		6321	Public Schools-Multidistrict Charters	Westby Area		9100	Rural Virtual Academy	charter						2020	pk_12_total										0									0
2332618	WI	Walworth	school		6482	Public Schools-Multidistrict Charters	Williams Bay		9401	Walworth Co Educ Alt High	charter						2020	pk_12_total										0									0
2332860	WI	Juneau	school	5517130	6713	Public school	Wonewoc-Union Center	551713003059	850	Wonewoc-Center Virtual Academy	charter	Regular School	Yes	Other	KG	12	2020	pk_12_total	1.0						1.0	*	*	1	1						1		1
2332896	WI	Vilas	school		6720	Public Schools-Multidistrict Charters	Woodruff J1		9418	Lakeland STAR School--Strong Talented Adventurous Remarkable	charter						2020	pk_12_total										0									0
2332954	WI	Clark	school		7	Public Schools-Multidistrict Charters	Abbotsford		9100	Rural Virtual Academy	charter						2021	pk_12_total										0									0
2333938	WI	Rock	school		422	Public Schools-Multidistrict Charters	Beloit Turner		9803	JEDI Virtual K-12	charter						2021	pk_12_total	2.0						2.0	*	*	2	2						2		2
2333999	WI	Walworth	school		6013	Public Schools-Multidistrict Charters	Big Foot UHS		9401	Career and College Academy	charter						2021	pk_12_total										0									0
2334285	WI	Rusk	school		735	Public Schools-Multidistrict Charters	Bruce		9419	eSucceed Charter School	charter						2021	pk_12_total										0									0
2334372	WI	Ashland	school	5501920	840	Public school	Butternut	550192002751	450	Promethean Charter School	charter	Regular School	Yes	High	09	12	2021	pk_12_total										0									0
2334826	WI	Waupaca	school		1141	Public Schools-Multidistrict Charters	Clintonville		9100	Rural Virtual Academy	charter						2021	pk_12_total										0									0
2335394	WI	Dodge	school		2744	Public Schools-Multidistrict Charters	Dodgeland		405	Kiel eSchool	charter						2021	pk_12_total										0									0
2335595	WI	Eau Claire	school	5504050	1554	Public school	Eau Claire Area	550405002675	430	Oxford Avenue School		Alternative School	No	High	10	12	2021	pk_12_total										0									0
2335955	WI	Rock	school		1694	Public Schools-Multidistrict Charters	Evansville Community		9803	JEDI Virtual K-12	charter						2021	pk_12_total	6.0						6.0	*		6	6						6		6
2336192	WI	Jefferson	school		1883	Public Schools-Multidistrict Charters	Fort Atkinson		9803	JEDI Virtual K-12	charter						2021	pk_12_total										0									0
2336733	WI	Brown	school	5505820	2289	Public school	Green Bay Area Public	550582002965	170	Friedrich Froebel Garden of Early Learning		Regular School	No	Elementary	PK	KG	2021	pk_12_total										0									0
2336756	WI	Brown	school	5505820	2289	Public school	Green Bay Area Public	550582000626	360	Jefferson Elementary		Regular School	No	Elementary	PK	05	2021	pk_12_total										0									0
2336757	WI	Brown	school	5505820	2289	Public school	Green Bay Area Public	550582003138	50	Jefferson Head Start Learning Center		Regular School	No	Prekindergarten	PK	PK	2021	pk_12_total										0									0
2337468	WI	Saint Croix	school	5506690	2611	Public school	Hudson	550669003129	400	Hudson Virtual Charter School	charter	Regular School	Yes	High	09	12	2021	pk_12_total	2.0						2.0	*	*	2	2						2		2
2337870	WI	Green	school		2737	Public Schools-Multidistrict Charters	Juda		405	Kiel eSchool	charter						2021	pk_12_total	1.0						1.0	*	*	1	1						1		1
2338324	WI	Kewaunee	school		2814	Public Schools-Multidistrict Charters	Kewaunee		800	Between the Lakes Virtual Academy	charter						2021	pk_12_total										0									0
2338343	WI	Kewaunee	school		2814	Public Schools-Multidistrict Charters	Kewaunee		405	Kiel eSchool	charter						2021	pk_12_total										0									0
2338361	WI	Vernon	school		5960	Public Schools-Multidistrict Charters	Kickapoo Area		9407	Vernon County Area Better Futures High	charter						2021	pk_12_total										0									0
2338629	WI	Vilas	school		1848	Public Schools-Multidistrict Charters	Lac du Flambeau #1		9418	Lakeland STAR School--Strong Talented Adventurous Remarkable	charter						2021	pk_12_total										0									0
2338701	WI	Walworth	school	5507650	2884	Public school	Lake Geneva-Genoa City UHS	550765003109	410	New Visions Charter School	charter	Regular School	Yes	High	09	12	2021	pk_12_total	2.0						2.0	*	*	2	2						2		2
2338703	WI	Chippewa	school		2891	Public Schools-Multidistrict Charters	Lake Holcombe		9419	eSucceed Charter School	charter						2021	pk_12_total										0									0
2339092	WI	Dane	school	5508520	3269	Public school	Madison Metropolitan	550852002909	220	Innovative & Alternative Middle		Alternative School	No	Middle	06	08	2021	pk_12_total										0									0
2339616	WI	Juneau	school		3360	Public Schools-Multidistrict Charters	Mauston		9803	JEDI Virtual K-12	charter						2021	pk_12_total	3.0						3.0	*	*	3	3						3		3
2339648	WI	Dodge	school		3367	Public Schools-Multidistrict Charters	Mayville		800	Between the Lakes Virtual Academy	charter						2021	pk_12_total										0									0
2339649	WI	Dodge	school		3367	Public Schools-Multidistrict Charters	Mayville		405	Kiel eSchool	charter						2021	pk_12_total										0									0
2342096	WI	Clark	school		3899	Public Schools-Multidistrict Charters	Neillsville		9100	Rural Virtual Academy	charter						2021	pk_12_total										0									0
2342448	WI	Vilas	school		616	Public Schools-Multidistrict Charters	North Lakeland		9418	Lakeland STAR School--Strong Talented Adventurous Remarkable	charter						2021	pk_12_total										0									0
2342690	WI	Fond du Lac	school		4025	Public Schools-Multidistrict Charters	Oakfield		405	Kiel eSchool	charter						2021	pk_12_total										0									0
2343133	WI	Jefferson	school	5511350	4221	Public school	Palmyra-Eagle Area	551135001514	20	Palmyra Elementary		Regular School	No	Elementary	PK	06	2021	pk_12_total										0									0
2343950	WI	Dodge	school		4634	Public Schools-Multidistrict Charters	Randolph		405	Kiel eSchool	charter						2021	pk_12_total										0									0
2344122	WI	Taylor	school		4795	Public Schools-Multidistrict Charters	Rib Lake		9100	Rural Virtual Academy	charter						2021	pk_12_total										0									0
2345290	WI	Chippewa	school		5593	Public Schools-Multidistrict Charters	Stanley-Boyd Area		9419	eSucceed Charter School	charter						2021	pk_12_total										0									0
2346000	WI	Barron	school		5810	Public Schools-Multidistrict Charters	Turtle Lake		9410	North Star Academy	charter						2021	pk_12_total	1.0			1.0			2.0	*	*	2	1			1			2		2
2347188	WI	Milwaukee	school	5516260	6300	Public school	West Allis-West Milwaukee	551626002918	410	Shared Journeys	charter	Alternative School	Yes	High	07	12	2021	pk_12_total	1.0		1.0				2.0	*	*	2	1		1				2		2
2347902	WI	Vilas	school		6720	Public Schools-Multidistrict Charters	Woodruff J1		9418	Lakeland STAR School--Strong Talented Adventurous Remarkable	charter						2021	pk_12_total										0									0
3074945	WI	Rock	school		422	Public Schools-Multidistrict Charters	Beloit Turner		9803	JEDI Virtual K-12	charter						2019	pk_12_total										0									0
3076558	WI	Eau Claire	school	5504050	1554	Public school	Eau Claire Area	550405002675	430	Oxford Avenue School		Alternative School	No	High	10	12	2019	pk_12_total										0									0
3076658	WI	Langlade	school		1582	Public Schools-Multidistrict Charters	Elcho		9100	Rural Virtual Academy	charter						2019	pk_12_total										0									0
3077124	WI	Jefferson	school		1883	Public Schools-Multidistrict Charters	Fort Atkinson		9803	JEDI Virtual K-12	charter						2019	pk_12_total										0									0
3077400	WI	Taylor	school		2135	Public Schools-Multidistrict Charters	Gilman		9100	Rural Virtual Academy	charter						2019	pk_12_total										0									0
3078944	WI	Kenosha	school	5507320	2793	Public school	Kenosha	550732003051	810	Kenosha Pike School		Special Education School	No	Other	PK	12	2019	pk_12_total										0									0
3079238	WI	Vernon	school		5960	Public Schools-Multidistrict Charters	Kickapoo Area		9407	Vernon County Area Better Futures High	charter						2019	pk_12_total										0									0
3079496	WI	Vilas	school		1848	Public Schools-Multidistrict Charters	Lac du Flambeau #1		9418	Lakeland STAR School--Strong Talented Adventurous Remarkable	charter						2019	pk_12_total										0									0
3079945	WI	Dane	school	5508520	3269	Public school	Madison Metropolitan	550852002909	220	Innovative & Alternative Middle		Alternative School	No	Middle	06	08	2019	pk_12_total										0									0
3080354	WI	Dane	school		3332	Public Schools-Multidistrict Charters	Marshall		9803	JEDI Virtual K-12	charter						2019	pk_12_total										0									0
3080456	WI	Juneau	school		3360	Public Schools-Multidistrict Charters	Mauston		9803	JEDI Virtual K-12	charter						2019	pk_12_total	3.0						3.0	*	*	3	3						3		3
3080460	WI	Juneau	school		3360	Public Schools-Multidistrict Charters	Mauston		9405	Juneau County Charter School	charter						2019	pk_12_total										0									0
3082862	WI	Juneau	school		3871	Public Schools-Multidistrict Charters	Necedah Area		9405	Juneau County Charter School	charter						2019	pk_12_total										0									0
3083319	WI	Vilas	school		616	Public Schools-Multidistrict Charters	North Lakeland		9418	Lakeland STAR School--Strong Talented Adventurous Remarkable	charter						2019	pk_12_total										0									0
3083437	WI	Washburn	school	5509720	3654	Public school	Northwood	550972003018	800	Northwood Virtual Charter School	charter	Regular School	Yes	Other	PK	12	2019	pk_12_total										0									0
3083975	WI	Clark	school		4207	Public Schools-Multidistrict Charters	Owen-Withee		9100	Rural Virtual Academy	charter						2019	pk_12_total	2.0						2.0	*	*	2	2						2		2
3084459	WI	Price	school		4571	Public Schools-Multidistrict Charters	Prentice		9100	Rural Virtual Academy	charter						2019	pk_12_total										0									0
3085262	WI	Juneau	school		1673	Public Schools-Multidistrict Charters	Royall		9405	Juneau County Charter Sch	charter						2019	pk_12_total										0									0
3085856	WI	Douglas	school	5513980	5397	Public school	Solon Springs	551398003092	850	Eagles' Wings Virtual Charter School	charter	Regular School	Yes	Other	PK	12	2019	pk_12_total										0									0
3088248	WI	Walworth	school		6461	Public Schools-Multidistrict Charters	Whitewater Unified		9803	JEDI Virtual K-12 - Jefferson and Eastern Dane County Interactive	charter						2019	pk_12_total										0									0
3088329	WI	Walworth	school		6482	Public Schools-Multidistrict Charters	Williams Bay		9401	Walworth Co Educ Alt High	charter						2019	pk_12_total										0									0
3088552	WI	Juneau	school		6713	Public Schools-Multidistrict Charters	Wonewoc-Union Center		9405	Juneau County Charter School	charter						2019	pk_12_total										0									0
3088571	WI	Juneau	school	5517130	6713	Public school	Wonewoc-Union Center	551713003059	850	Wonewoc-Center Virtual Academy	charter	Regular School	Yes	Other	KG	12	2019	pk_12_total	2.0						2.0	*	*	2	2						2		2
3088607	WI	Vilas	school		6720	Public Schools-Multidistrict Charters	Woodruff J1		9418	Lakeland STAR School--Strong Talented Adventurous Remarkable	charter						2019	pk_12_total										0									0
3089292	WI	Wood	school		203	Public Schools-Multidistrict Charters	Auburndale		9100	Rural Virtual Academy	charter						2018	pk_12_total	3.0						3.0	*	*	3	3						3		3