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
113431	WI	Price	school	5500058	1071	Public school	Chequamegon	550005802780	450	Class ACT Charter	charter	Vocational Education School	Yes	3.0	09	12	2015	grade_10	1	1
113467	WI	Barron	school	5500061	1080	Public school	Chetek-Weyerhaeuser Area	550006102897	800	Link2Learn Virtual Charter School	charter	Regular School	Yes	4.0	PK	12	2015	grade_10	1	1
114607	WI	Waukesha	school	5501770	714	Public school	Elmbrook	550177000221	160	Fairview South		Special Education School	No	4.0	02	12	2015	grade_10	1	1
116287	WI	Waupaca	school		2639	Public Schools-Multidistrict Charters	Iola-Scandinavia		9408	Waupaca County Charter	charter						2015	grade_10	1	1
116483	WI	Jefferson	school		2702	Public Schools-Multidistrict Charters	Jefferson		9803	JEDI Virtual K-12	charter						2015	grade_10	1	1
117017	WI	Kewaunee	school	5507410	2814	Public school	Kewaunee	550741002768	490	Lakeshore Alternative School		Regular School	No	3.0	10	12	2015	grade_10	1	1
117036	WI	Manitowoc	school	5507440	2828	Public school	Kiel Area	550744002554	405	Kiel eSchool	charter	Regular School	Yes	3.0	07	12	2015	grade_10	1	1
117818	WI	Dane	school	5508520	3269	Public school	Madison Metropolitan	550852002670	820	Metro School		Alternative Education School	No	4.0	04	12	2015	grade_10	1	1
118240	WI	Juneau	school		3360	Public Schools-Multidistrict Charters	Mauston		9803	JEDI Virtual K-12	charter						2015	grade_10	1	1
119580	WI	Milwaukee	school	5509600	3619	Public school	Milwaukee	550960000874	1078	Lad Lake Ultra		Alternative Education School	No	4.0	06	12	2015	grade_10	1	1
120923	WI	Juneau	school	5510560	3948	Public school	New Lisbon	551056002517	9405	Juneau County Charter School	charter	Regular School	Yes	3.0	07	12	2015	grade_10	1	1
121407	WI	Oconto	school	5510950	4074	Public school	Oconto Falls Public	551095002736	410	New Path	charter	Alternative Education School	Yes	4.0	06	12	2015	grade_10	1	1
124214	WI	Dane	school		5656	Public Schools-Multidistrict Charters	Sun Prairie Area		9803	JEDI Virtual K-12	charter						2015	grade_10	1	1
125671	WI	Milwaukee	school	5516260	6300	Public school	West Allis-West Milwaukee	551626002918	410	Shared Journeys	charter	Alternative Education School	Yes	3.0	07	12	2015	grade_10	1	1
125904	WI	Waupaca	school	5516500	6384	Public school	Weyauwega-Fremont	551650002523	9408	Waupaca County Charter	charter	Regular School	Yes	4.0	06	12	2015	grade_10	1	1
281937	WI	Langlade	school		140	Public Schools-Multidistrict Charters	Antigo Unified		9100	Rural Virtual Academy	charter						2016	grade_10	1	1
281970	WI	Outagamie	school	5500390	147	Public school	Appleton Area	550039000692	400	Appleton Central High	charter	Regular School	Yes	4.0	06	12	2016	grade_10	1	1
281976	WI	Outagamie	school	5500390	147	Public school	Appleton Area	550039002549	440	Appleton eSchool	charter	Regular School	Yes	3.0	07	12	2016	grade_10	1	1
283644	WI	Clark	school		1162	Public Schools-Multidistrict Charters	Colby		9100	Rural Virtual Academy	charter						2016	grade_10	1	1
284308	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_10	1	1
284365	WI	Eau Claire	school	5504050	1554	Public school	Eau Claire Area	550405002658	800	Second Avenue School		Alternative Education School	No	4.0	04	12	2016	grade_10	1	1
284504	WI	Walworth	school	5504290	1638	Public school	Elkhorn Area	550429003038	800	Elkhorn Options Virtual School	charter	Regular School	Yes	4.0	PK	12	2016	grade_10	1	1
286474	WI	Rock	school	5507020	2695	Public school	Janesville	550702002948	850	Youth Services Center		Alternative Education School	No	4.0	04	12	2016	grade_10	1	1
286485	WI	Jefferson	school		2702	Public Schools-Multidistrict Charters	Jefferson		9803	JEDI Virtual K-12	charter						2016	grade_10	1	1
290386	WI	Green	school		3682	Public Schools-Multidistrict Charters	Monroe		9803	JEDI Virtual K-12	charter						2016	grade_10	1	1
290479	WI	Marathon	school		3787	Public Schools-Multidistrict Charters	Mosinee		9100	Rural Virtual Academy	charter						2016	grade_10	1	1
290623	WI	Juneau	school		3871	Public Schools-Multidistrict Charters	Necedah Area		9405	Juneau County Charter School	charter						2016	grade_10	1	1
291172	WI	Vilas	school	5503860	1526	Public school	Northland Pines	550386003013	410	School of Options & Applied Research High	charter	Regular School	Yes	3.0	08	12	2016	grade_10	1	1
291372	WI	Oconto	school	5510950	4074	Public school	Oconto Falls Public	551095002736	410	New Path	charter	Alternative Education School	Yes	4.0	06	12	2016	grade_10	1	1
292142	WI	Crawford	school	5512150	4543	Public school	Prairie du Chien Area	551215002944	800	Mighty River Academy of Virtual Education	charter	Regular School	Yes	4.0	KG	12	2016	grade_10	1	1
292800	WI	Richland	school	5512960	4851	Public school	Richland	551296002998	450	Richland Online Academy	charter	Regular School	Yes	4.0	06	12	2016	grade_10	1	1
293930	WI	Portage	school	5514490	5607	Public school	Stevens Point Area Public	551449001125	320	Juvenile Detention		Alternative Education School	No	4.0	KG	12	2016	grade_10	1	1
294040	WI	Dane	school		5621	Public Schools-Multidistrict Charters	Stoughton Area		9803	JEDI Virtual K-12	charter						2016	grade_10	1	1
294706	WI	Vernon	school	5515360	5985	Public school	Viroqua Area	551536002513	9407	Vernon County Area Better Futures High	charter	Regular School	Yes	3.0	10	12	2016	grade_10	1	1
295288	WI	Marathon	school	5515900	6223	Public school	Wausau	551590003027	800	Wausau Area Virtual Education		Regular School	No	4.0	06	12	2016	grade_10	1	1
295761	WI	Vernon	school		6321	Public Schools-Multidistrict Charters	Westby Area		9407	Vernon County Area Better Futures High	charter						2016	grade_10	1	1
295844	WI	Waupaca	school	5516500	6384	Public school	Weyauwega-Fremont	551650002523	9408	Waupaca County Charter	charter	Regular School	Yes	4.0	06	12	2016	grade_10	1	1
296244	WI	Juneau	school		6713	Public Schools-Multidistrict Charters	Wonewoc-Union Center		9405	Juneau County Charter School	charter						2016	grade_10	1	1
325830	WI	Langlade	school		140	Public Schools-Multidistrict Charters	Antigo Unified		9100	Rural Virtual Academy	charter						2017	grade_10	1	1
327365	WI	Barron	school		1080	Public Schools-Multidistrict Charters	Chetek-Weyerhaeuser Area		9410	North Star Academy	charter						2017	grade_10	1	1
327940	WI	Vernon	school	5503240	1421	Public school	De Soto Area	550324003022	810	De Soto Virtual School	charter	Regular School	Yes	Other	KG	12	2017	grade_10	1	1
328861	WI	Milwaukee	school	5504830	1900	Public school	Franklin Public	550483002685	400	Milwaukee County Correctional Facility South		Alternative School	No	High	09	12	2017	grade_10	1	1
331825	WI	Waupaca	school		3276	Public Schools-Multidistrict Charters	Manawa		9408	Waupaca County Charter	charter						2017	grade_10	1	1
332096	WI	Juneau	school		3360	Public Schools-Multidistrict Charters	Mauston		9803	JEDI Virtual K-12							2017	grade_10	1	1
335237	WI	Oconto	school	5510950	4074	Public school	Oconto Falls Public	551095002736	410	New Path	charter	Alternative School	Yes	Other	06	12	2017	grade_10	1	1
335800	WI	Wood	school		4368	Public Schools-Multidistrict Charters	Pittsville		9100	Rural Virtual Academy	charter						2017	grade_10	1	1
337820	WI	Portage	school	5514490	5607	Public school	Stevens Point Area Public	551449001116	310	Charles F Fernandez Center Alt Learning		Alternative School	No	High	07	12	2017	grade_10	1	1
337832	WI	Portage	school	5514490	5607	Public school	Stevens Point Area Public	551449001125	320	Juvenile Detention		Alternative School	No	Other	KG	12	2017	grade_10	1	1
337976	WI	Marathon	school		5628	Public Schools-Multidistrict Charters	Stratford		9100	Rural Virtual Academy	charter						2017	grade_10	1	1
338397	WI	Barron	school	5515060	5810	Public school	Turtle Lake	551506003032	810	Laker Online	charter	Regular School	Yes	Other	PK	12	2017	grade_10	1	1
338608	WI	Vernon	school	5515360	5985	Public school	Viroqua Area	551536002513	9407	Vernon County Area Better Futures High	charter	Regular School	Yes	High	10	12	2017	grade_10	1	1
339537	WI	Milwaukee	school	5516260	6300	Public school	West Allis-West Milwaukee	551626002918	410	Shared Journeys	charter	Alternative School	Yes	High	07	12	2017	grade_10	1	1
2318687	WI	Ashland	school		170	Public Schools-Multidistrict Charters	Ashland		9100	Rural Virtual Academy							2020	grade_10	1	1
2318757	WI	Wood	school		203	Public Schools-Multidistrict Charters	Auburndale		9100	Rural Virtual Academy	charter						2020	grade_10	1	1
2319645	WI	Dane	school	5502100	896	Public school	Cambridge	550210003093	400	Koshkonong Trails School	charter	Regular School	Yes	High	07	12	2020	grade_10	1	1
2320294	WI	Barron	school	5503090	1260	Public school	Cumberland	550309002871	800	Island City Virtual Academy	charter	Regular School	Yes	Other	PK	12	2020	grade_10	1	1
2320993	WI	Walworth	school	5504290	1638	Public school	Elkhorn Area	550429002520	9401	Walworth Co Educ Alt High	charter	Regular School	Yes	High	09	12	2020	grade_10	1	1
2322938	WI	Jefferson	school		2702	Public Schools-Multidistrict Charters	Jefferson		9803	JEDI Virtual K-12	charter						2020	grade_10	1	1
2324081	WI	Kewaunee	school		3220	Public Schools-Multidistrict Charters	Luxemburg-Casco		9803	JEDI Virtual K-12	charter						2020	grade_10	1	1
2325136	WI	Lincoln	school	5509210	3500	Public school	Merrill Area	550921002743	400	Merrill Adult Diploma Academy	charter	Alternative School	Yes	High	10	12	2020	grade_10	1	1
2328224	WI	Clark	school		4207	Public Schools-Multidistrict Charters	Owen-Withee		9100	Rural Virtual Academy	charter						2020	grade_10	1	1
2328418	WI	Price	school		4347	Public Schools-Multidistrict Charters	Phillips		9100	Rural Virtual Academy							2020	grade_10	1	1
2328592	WI	Columbia	school	5512060	4501	Public school	Portage Community	551206002174	400	Portage Academy of Achievement		Alternative School	No	High	09	12	2020	grade_10	1	1
2329218	WI	Taylor	school		4795	Public Schools-Multidistrict Charters	Rib Lake		9100	Rural Virtual Academy	charter						2020	grade_10	1	1
2330134	WI	Douglas	school	5513980	5397	Public school	Solon Springs	551398003092	850	Eagles' Wings Virtual Charter School	charter	Regular School	Yes	Other	PK	12	2020	grade_10	1	1
2330329	WI	Marathon	school		5467	Public Schools-Multidistrict Charters	Spencer		9100	Rural Virtual Academy	charter						2020	grade_10	1	1
2330394	WI	Chippewa	school		5593	Public Schools-Multidistrict Charters	Stanley-Boyd Area		9419	eSucceed Charter School	charter						2020	grade_10	1	1
2330935	WI	Monroe	school	5514910	5747	Public school	Tomah Area	551491002543	800	Robert Kupper Learning Center		Alternative School	No	Other	PK	12	2020	grade_10	1	1
2331283	WI	Vernon	school	5515360	5985	Public school	Viroqua Area	551536002513	9407	Vernon County Area Better Futures High	charter	Regular School	Yes	High	10	12	2020	grade_10	1	1
2331904	WI	Marathon	school	5515900	6223	Public school	Wausau	551590003027	800	Wausau Area Virtual Education	charter	Regular School	Yes	High	06	12	2020	grade_10	1	1
2332532	WI	Walworth	school		6461	Public Schools-Multidistrict Charters	Whitewater Unified		9803	JEDI Virtual K-12 - Jefferson and Eastern Dane County Interactive	charter						2020	grade_10	1	1
2333469	WI	Ashland	school		170	Public Schools-Multidistrict Charters	Ashland		9100	Rural Virtual Academy							2021	grade_10	1	1
2334668	WI	Barron	school	5500061	1080	Public school	Chetek-Weyerhaeuser Area	550006102897	800	Link2Learn Virtual Charter School	charter	Regular School	Yes	Other	PK	12	2021	grade_10	1	1
2334681	WI	Barron	school		1080	Public Schools-Multidistrict Charters	Chetek-Weyerhaeuser Area		9410	North Star Academy	charter						2021	grade_10	1	1
2335956	WI	Rock	school		1694	Public Schools-Multidistrict Charters	Evansville Community		9803	JEDI Virtual K-12	charter						2021	grade_10	1	1
2336645	WI	Brown	school	5505820	2289	Public school	Green Bay Area Public	550582000612	40	Bay View		Alternative School	No	Other	PK	12	2021	grade_10	1	1
2337469	WI	Saint Croix	school	5506690	2611	Public school	Hudson	550669003129	400	Hudson Virtual Charter School	charter	Regular School	Yes	High	09	12	2021	grade_10	1	1
2337546	WI	Dodge	school		2625	Public Schools-Multidistrict Charters	Hustisford		405	Kiel eSchool	charter						2021	grade_10	1	1
2337801	WI	Jefferson	school		2702	Public Schools-Multidistrict Charters	Jefferson		9803	JEDI Virtual K-12	charter						2021	grade_10	1	1
2339174	WI	Dane	school	5508520	3269	Public school	Madison Metropolitan	550852002670	820	Metro School		Alternative School	No	Other	04	12	2021	grade_10	1	1
2339483	WI	Waupaca	school		3318	Public Schools-Multidistrict Charters	Marion		9100	Rural Virtual Academy	charter						2021	grade_10	1	1
2341117	WI	Milwaukee	school	5509600	3619	Public school	Milwaukee	550960001306	315	Milwaukee County Youth Education Center		Alternative School	No	High	06	12	2021	grade_10	1	1
2341381	WI	Milwaukee	school	5509600	3619	Public school	Milwaukee	550960003057	442	South Accelerated Academy		Alternative School	No	High	09	12	2021	grade_10	1	1
2342138	WI	Chippewa	school		3920	Public Schools-Multidistrict Charters	New Auburn		9419	eSucceed Charter School	charter						2021	grade_10	1	1
2342374	WI	Waukesha	school	5510710	3976	Public school	Norris	551071003072	800	Norris Academy Virtual School	charter	Alternative School	Yes	Other	KG	12	2021	grade_10	1	1
2343119	WI	Clark	school		4207	Public Schools-Multidistrict Charters	Owen-Withee		9100	Rural Virtual Academy	charter						2021	grade_10	1	1
2343337	WI	Wood	school		4368	Public Schools-Multidistrict Charters	Pittsville		9100	Rural Virtual Academy	charter						2021	grade_10	1	1
2344093	WI	Oneida	school		4781	Public Schools-Multidistrict Charters	Rhinelander		9100	Rural Virtual Academy	charter						2021	grade_10	1	1
2344184	WI	Richland	school	5512960	4851	Public school	Richland	551296002998	450	Richland Online Academy	charter	Regular School	Yes	High	06	12	2021	grade_10	1	1
2345744	WI	Clark	school		5726	Public Schools-Multidistrict Charters	Thorp		9100	Rural Virtual Academy	charter						2021	grade_10	1	1
2345989	WI	Barron	school	5515060	5810	Public school	Turtle Lake	551506003032	810	Laker Online	charter	Regular School	Yes	Other	PK	12	2021	grade_10	1	1
2346201	WI	Vernon	school	5515360	5985	Public school	Viroqua Area	551536001936	410	Laurel High	charter	Regular School	Yes	High	09	12	2021	grade_10	1	1
2347189	WI	Milwaukee	school	5516260	6300	Public school	West Allis-West Milwaukee	551626002918	410	Shared Journeys	charter	Alternative School	Yes	High	07	12	2021	grade_10	1	1
2347326	WI	Vernon	school		6321	Public Schools-Multidistrict Charters	Westby Area		9100	Rural Virtual Academy	charter						2021	grade_10	1	1
3073917	WI	Clark	school		7	Public Schools-Multidistrict Charters	Abbotsford		9100	Rural Virtual Academy	charter						2019	grade_10	1	1
3074151	WI	Outagamie	school	5500390	147	Public school	Appleton Area	550039002549	440	Appleton eSchool	charter	Regular School	Yes	High	07	12	2019	grade_10	1	1
3075008	WI	Washburn	school	5501170	441	Public school	Birchwood	550117002800	450	Birchwood Blue Hills Charter School	charter	Regular School	Yes	High	07	12	2019	grade_10	1	1
3075041	WI	Washburn	school	5501170	441	Public school	Birchwood	550117003020	800	Bobcat Virtual Academy	charter	Regular School	Yes	Other	PK	12	2019	grade_10	1	1
3075373	WI	Ashland	school	5501920	840	Public school	Butternut	550192002751	450	Promethean Charter School	charter	Regular School	Yes	High	09	12	2019	grade_10	1	1
3076259	WI	Vernon	school	5503240	1421	Public school	De Soto Area	550324003022	810	De Soto Virtual School	charter	Regular School	Yes	Other	KG	12	2019	grade_10	1	1
3076754	WI	Walworth	school	5504290	1638	Public school	Elkhorn Area	550429002520	9401	Walworth Co Educ Alt High	charter	Regular School	Yes	High	09	12	2019	grade_10	1	1