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 total 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	total	total_int
111997	WI	Outagamie	school	5500390	147	Public school	Appleton Area	550039000692	400	Appleton Central High	charter	Regular School	Yes	4.0	06	12	2015	grade_8	1	1
112594	WI	Dodge	school	5500960	336	Public school	Beaver Dam Unified	550096002815	850	Don Smith Learning Academy		Alternative Education School	No	4.0	06	12	2015	grade_8	1	1
113884	WI	Barron	school	5503090	1260	Public school	Cumberland	550309002871	800	Island City Virtual Academy	charter	Regular School	Yes	4.0	PK	12	2015	grade_8	1	1
114612	WI	Waukesha	school	5501770	714	Public school	Elmbrook	550177000221	160	Fairview South		Special Education School	No	4.0	02	12	2015	grade_8	1	1
115190	WI	Oconto	school	5505250	2128	Public school	Gillett	550525002906	450	Gillett's Occupation and Leadership Academy	charter	Regular School	Yes	4.0	06	12	2015	grade_8	1	1
115551	WI	Brown	school	5505820	2289	Public school	Green Bay Area Public	550582002955	150	Leonardo da Vinci School for Gifted Learners		Regular School	No	1.0	KG	08	2015	grade_8	1	1
118244	WI	Juneau	school		3360	Public Schools-Multidistrict Charters	Mauston		9803	JEDI Virtual K-12	charter						2015	grade_8	1	1
119581	WI	Milwaukee	school	5509600	3619	Public school	Milwaukee	550960000874	1078	Lad Lake Ultra		Alternative Education School	No	4.0	06	12	2015	grade_8	1	1
120431	WI	Green	school	5509840	3682	Public school	Monroe	550984001298	120	Monroe High		Regular School	No	4.0	06	12	2015	grade_8	1	1
120525	WI	Marathon	school		3787	Public Schools-Multidistrict Charters	Mosinee		9100	Rural Virtual Academy	charter						2015	grade_8	1	1
120946	WI	Waupaca	school	5510590	3955	Public school	New London	551059002996	430	Catalyst Academy	charter	Alternative Education School	Yes	3.0	07	12	2015	grade_8	1	1
122745	WI	Taylor	school		4795	Public Schools-Multidistrict Charters	Rib Lake		9100	Rural Virtual Academy	charter						2015	grade_8	1	1
124139	WI	Marathon	school		5628	Public Schools-Multidistrict Charters	Stratford		9100	Rural Virtual Academy	charter						2015	grade_8	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
124459	WI	Monroe	school	5514910	5747	Public school	Tomah Area	551491002543	800	Robert Kupper Learning Center		Alternative Education School	No	4.0	PK	12	2015	grade_8	1	1
124525	WI	Portage	school	5500330	126	Public school	Tomorrow River	550033002984	850	Central Wisconsin Virtual School	charter	Regular School	Yes	4.0	06	12	2015	grade_8	1	1
125756	WI	Washington	school	5516290	6307	Public school	West Bend	551629002666	400	Washington Street School		Alternative Education School	No	4.0	06	12	2015	grade_8	1	1
281979	WI	Outagamie	school	5500390	147	Public school	Appleton Area	550039002549	440	Appleton eSchool	charter	Regular School	Yes	3.0	07	12	2016	grade_8	1	1
282359	WI	Wood	school		203	Public Schools-Multidistrict Charters	Auburndale		9100	Rural Virtual Academy	charter						2016	grade_8	1	1
282494	WI	Barron	school	5500870	308	Public school	Barron Area	550087002864	810	Advanced Learning Academy of Wisconsin	charter	Regular School	Yes	4.0	KG	12	2016	grade_8	1	1
283858	WI	Barron	school	5503090	1260	Public school	Cumberland	550309002871	800	Island City Virtual Academy	charter	Regular School	Yes	4.0	PK	12	2016	grade_8	1	1
284020	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	grade_8	1	1
284311	WI	Eau Claire	school	5504050	1554	Public school	Eau Claire Area	550405000705	580	McKinley Charter School	charter	Alternative Education School	Yes	4.0	06	12	2016	grade_8	1	1
284916	WI	Jefferson	school		1883	Public Schools-Multidistrict Charters	Fort Atkinson		9803	JEDI Virtual K-12	charter						2016	grade_8	1	1
286489	WI	Jefferson	school		2702	Public Schools-Multidistrict Charters	Jefferson		9803	JEDI Virtual K-12	charter						2016	grade_8	1	1
290439	WI	Marquette	school	5509870	3689	Public school	Montello	550987003016	800	Montello Virtual Charter School	charter	Regular School	Yes	4.0	KG	12	2016	grade_8	1	1
290484	WI	Marathon	school		3787	Public Schools-Multidistrict Charters	Mosinee		9100	Rural Virtual Academy	charter						2016	grade_8	1	1
294073	WI	Marathon	school		5628	Public Schools-Multidistrict Charters	Stratford		9100	Rural Virtual Academy	charter						2016	grade_8	1	1
294551	WI	Manitowoc	school		5824	Public Schools-Multidistrict Charters	Two Rivers Public		9120	Manitowoc County Comprehensive Charter School	charter						2016	grade_8	1	1
295290	WI	Marathon	school	5515900	6223	Public school	Wausau	551590003027	800	Wausau Area Virtual Education		Regular School	No	4.0	06	12	2016	grade_8	1	1
328268	WI	Eau Claire	school	5504050	1554	Public school	Eau Claire Area	550405002658	800	Second Avenue School		Alternative School	No	Other	04	12	2017	grade_8	1	1
330306	WI	Rock	school	5507020	2695	Public school	Janesville	550702001698	400	Rock River Charter School	charter	Regular School	Yes	Other	06	12	2017	grade_8	1	1
330356	WI	Rock	school	5507020	2695	Public school	Janesville	550702002948	850	Youth Services Center		Alternative School	No	Other	04	12	2017	grade_8	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
332768	WI	Milwaukee	school	5509600	3619	Public school	Milwaukee	550960001218	14	Bradley Technology High		Regular School	No	High	09	12	2017	grade_8	1	1
332926	WI	Milwaukee	school	5509600	3619	Public school	Milwaukee	550960003370	416	Community High School		Regular School	No	High	09	12	2017	grade_8	1	1
334259	WI	Green	school		3682	Public Schools-Multidistrict Charters	Monroe		9803	JEDI Virtual K-12	charter						2017	grade_8	1	1
334356	WI	Marathon	school		3787	Public Schools-Multidistrict Charters	Mosinee		9100	Rural Virtual Academy	charter						2017	grade_8	1	1
334644	WI	Wood	school	5510380	3906	Public school	Nekoosa	551038002715	200	Niikuusra Community School	charter	Alternative School	Yes	Elementary	04	08	2017	grade_8	1	1
335797	WI	Wood	school	5511790	4368	Public school	Pittsville	551179001547	40	Pittsville High		Regular School	No	High	09	12	2017	grade_8	1	1
335804	WI	Wood	school		4368	Public Schools-Multidistrict Charters	Pittsville		9100	Rural Virtual Academy	charter						2017	grade_8	1	1
336028	WI	Crawford	school	5512150	4543	Public school	Prairie du Chien Area	551215002944	800	Mighty River Academy of Virtual Education	charter	Regular School	Yes	Other	KG	12	2017	grade_8	1	1
336691	WI	Richland	school	5512960	4851	Public school	Richland	551296002998	450	Richland Online Academy	charter	Regular School	Yes	Other	06	12	2017	grade_8	1	1
337947	WI	Dane	school		5621	Public Schools-Multidistrict Charters	Stoughton Area		9803	JEDI Virtual K-12	charter						2017	grade_8	1	1
338399	WI	Barron	school	5515060	5810	Public school	Turtle Lake	551506003032	810	Laker Online	charter	Regular School	Yes	Other	PK	12	2017	grade_8	1	1
339640	WI	Brown	school	5516320	6328	Public school	West De Pere	551632002752	400	Phantom Knight School of Opportunity	charter	Regular School	Yes	High	07	12	2017	grade_8	1	1
2318149	WI	Clark	school		7	Public Schools-Multidistrict Charters	Abbotsford		9100	Rural Virtual Academy	charter						2020	grade_8	1	1
2318156	WI	Adams	school	5500060	14	Public school	Adams-Friendship Area	550006001433	130	Adams-Friendship Elementary		Regular School	No	Elementary	PK	04	2020	grade_8	1	1
2318764	WI	Wood	school		203	Public Schools-Multidistrict Charters	Auburndale		9100	Rural Virtual Academy	charter						2020	grade_8	1	1
2319093	WI	Rock	school	5501050	413	Public school	Beloit	550105002799	850	Beloit Virtual School		Regular School	No	Other	PK	12	2020	grade_8	1	1
2319393	WI	Shawano	school		623	Public Schools-Multidistrict Charters	Bowler		9100	Rural Virtual Academy	charter						2020	grade_8	1	1
2319543	WI	Racine	school		777	Public Schools-Multidistrict Charters	Burlington Area		9803	JEDI Virtual K-12	charter						2020	grade_8	1	1
2320085	WI	Clark	school		1162	Public Schools-Multidistrict Charters	Colby		9100	Rural Virtual Academy	charter						2020	grade_8	1	1
2324731	WI	Juneau	school		3360	Public Schools-Multidistrict Charters	Mauston		9803	JEDI Virtual K-12	charter						2020	grade_8	1	1
2325175	WI	Dane	school	5509510	3549	Public school	Middleton-Cross Plains Area	550951002818	800	21st Century eSchool	charter	Regular School	Yes	Other	KG	12	2020	grade_8	1	1
2326920	WI	Marquette	school	5509870	3689	Public school	Montello	550987003016	800	Montello Virtual Charter School	charter	Regular School	Yes	Other	KG	12	2020	grade_8	1	1
2326968	WI	Marathon	school		3787	Public Schools-Multidistrict Charters	Mosinee		9100	Rural Virtual Academy	charter						2020	grade_8	1	1
2327497	WI	Waukesha	school	5510710	3976	Public school	Norris	551071001395	20	Norris Academy		Regular School	No	Other	KG	12	2020	grade_8	1	1
2328730	WI	Price	school		4571	Public Schools-Multidistrict Charters	Prentice		9100	Rural Virtual Academy	charter						2020	grade_8	1	1
2330334	WI	Marathon	school		5467	Public Schools-Multidistrict Charters	Spencer		9100	Rural Virtual Academy	charter						2020	grade_8	1	1
2330566	WI	Dane	school		5621	Public Schools-Multidistrict Charters	Stoughton Area		9803	JEDI Virtual K-12	charter						2020	grade_8	1	1
2330598	WI	Marathon	school		5628	Public Schools-Multidistrict Charters	Stratford		9100	Rural Virtual Academy	charter						2020	grade_8	1	1
2330681	WI	Dane	school		5656	Public Schools-Multidistrict Charters	Sun Prairie Area		9803	JEDI Virtual K-12	charter						2020	grade_8	1	1
2331449	WI	Jefferson	school	5515750	6125	Public school	Watertown Unified	551575001997	40	Douglas Elementary		Regular School	No	Elementary	PK	05	2020	grade_8	1	1
2332469	WI	Langlade	school		6440	Public Schools-Multidistrict Charters	White Lake		9100	Rural Virtual Academy	charter						2020	grade_8	1	1
2333547	WI	Wood	school		203	Public Schools-Multidistrict Charters	Auburndale		9100	Rural Virtual Academy	charter						2021	grade_8	1	1
2334003	WI	Washburn	school	5501170	441	Public school	Birchwood	550117002800	450	Birchwood Blue Hills Charter School	charter	Regular School	Yes	High	07	12	2021	grade_8	1	1
2335623	WI	Eau Claire	school	5504050	1554	Public school	Eau Claire Area	550405002658	800	Second Avenue School		Alternative School	No	Other	04	12	2021	grade_8	1	1
2335927	WI	Pierce	school	5504350	1666	Public school	Elmwood	550435003121	800	Western Wisconsin Virtual Charter School (WWVC)	charter	Regular School	Yes	Other	PK	12	2021	grade_8	1	1
2335959	WI	Rock	school		1694	Public Schools-Multidistrict Charters	Evansville Community		9803	JEDI Virtual K-12	charter						2021	grade_8	1	1
2336648	WI	Brown	school	5505820	2289	Public school	Green Bay Area Public	550582000612	40	Bay View		Alternative School	No	Other	PK	12	2021	grade_8	1	1
2337807	WI	Jefferson	school		2702	Public Schools-Multidistrict Charters	Jefferson		9803	JEDI Virtual K-12	charter						2021	grade_8	1	1
2338065	WI	Kenosha	school	5507320	2793	Public school	Kenosha	550732002910	800	Kenosha eSchool K-12	charter	Regular School	Yes	Other	KG	12	2021	grade_8	1	1
2341629	WI	Oneida	school	5509690	3640	Public school	Minocqua J1	550969003083	9418	Lakeland STAR School--Strong Talented Adventurous Remarkable	charter	Regular School	Yes	Middle	07	08	2021	grade_8	1	1
2342139	WI	Chippewa	school		3920	Public Schools-Multidistrict Charters	New Auburn		9419	eSucceed Charter School	charter						2021	grade_8	1	1
2342371	WI	Waukesha	school	5510710	3976	Public school	Norris	551071001395	20	Norris Academy		Regular School	No	Other	KG	12	2021	grade_8	1	1
2342544	WI	Vilas	school	5503860	1526	Public school	Northland Pines	550386003013	410	School of Options & Applied Research High	charter	Regular School	Yes	High	08	12	2021	grade_8	1	1
2343317	WI	Price	school		4347	Public Schools-Multidistrict Charters	Phillips		9100	Rural Virtual Academy							2021	grade_8	1	1
2343343	WI	Wood	school		4368	Public Schools-Multidistrict Charters	Pittsville		9100	Rural Virtual Academy	charter						2021	grade_8	1	1
2344101	WI	Oneida	school		4781	Public Schools-Multidistrict Charters	Rhinelander		9100	Rural Virtual Academy	charter						2021	grade_8	1	1
2344355	WI	Grant	school	5510140	3850	Public school	Riverdale	551014003084	430	Riverdale Academy		Alternative School	No	High	06	12	2021	grade_8	1	1
2345140	WI	Door	school		5457	Public Schools-Multidistrict Charters	Southern Door County		9100	Rural Virtual Academy	charter						2021	grade_8	1	1
2345232	WI	Marathon	school		5467	Public Schools-Multidistrict Charters	Spencer		9100	Rural Virtual Academy	charter						2021	grade_8	1	1
2345342	WI	Portage	school	5514490	5607	Public school	Stevens Point Area Public	551449001125	320	Juvenile Detention		Alternative School	No	Other	KG	12	2021	grade_8	1	1
2345946	WI	Portage	school	5500330	126	Public school	Tomorrow River	550033003119	200	Tomorrow River Community Middle (TRCMS)	charter	Regular School	Yes	Middle	05	08	2021	grade_8	1	1
2346743	WI	Marathon	school	5515900	6223	Public school	Wausau	551590002747	400	Enrich Excel Achieve Learning Academy	charter	Alternative School	Yes	High	06	12	2021	grade_8	1	1
3074121	WI	Langlade	school		140	Public Schools-Multidistrict Charters	Antigo Unified		9100	Rural Virtual Academy	charter						2019	grade_8	1	1
3074539	WI	Wood	school		203	Public Schools-Multidistrict Charters	Auburndale		9100	Rural Virtual Academy	charter						2019	grade_8	1	1
3074873	WI	Rock	school	5501050	413	Public school	Beloit	550105002799	850	Beloit Virtual School		Regular School	No	Other	PK	12	2019	grade_8	1	1
3075012	WI	Washburn	school	5501170	441	Public school	Birchwood	550117002800	450	Birchwood Blue Hills Charter School	charter	Regular School	Yes	High	07	12	2019	grade_8	1	1
3075328	WI	Racine	school		777	Public Schools-Multidistrict Charters	Burlington Area		9803	JEDI Virtual K-12	charter						2019	grade_8	1	1
3076077	WI	Barron	school	5503090	1260	Public school	Cumberland	550309002871	800	Island City Virtual Academy	charter	Regular School	Yes	Other	PK	12	2019	grade_8	1	1
3078690	WI	Jefferson	school		2702	Public Schools-Multidistrict Charters	Jefferson		9803	JEDI Virtual K-12	charter						2019	grade_8	1	1
3080459	WI	Juneau	school		3360	Public Schools-Multidistrict Charters	Mauston		9803	JEDI Virtual K-12	charter						2019	grade_8	1	1
3082632	WI	Green	school		3682	Public Schools-Multidistrict Charters	Monroe		9803	JEDI Virtual K-12	charter						2019	grade_8	1	1
3083648	WI	Oconto	school	5510920	4067	Public school	Oconto Unified	551092003060	800	Northeast Wisconsin Learning Academy		Alternative School	No	High	05	12	2019	grade_8	1	1
3083977	WI	Clark	school		4207	Public Schools-Multidistrict Charters	Owen-Withee		9100	Rural Virtual Academy	charter						2019	grade_8	1	1
3085023	WI	Richland	school	5512960	4851	Public school	Richland	551296002998	450	Richland Online Academy	charter	Regular School	Yes	High	06	12	2019	grade_8	1	1
3086272	WI	Dane	school		5621	Public Schools-Multidistrict Charters	Stoughton Area		9803	JEDI Virtual K-12	charter						2019	grade_8	1	1
3086305	WI	Marathon	school		5628	Public Schools-Multidistrict Charters	Stratford		9100	Rural Virtual Academy	charter						2019	grade_8	1	1
3088006	WI	Washington	school	5516290	6307	Public school	West Bend	551629002666	400	Washington Street School		Alternative School	No	High	06	12	2019	grade_8	1	1