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 and "year" = :p2 order by total_int 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
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
2334170	WI	Shawano	school		623	Public Schools-Multidistrict Charters	Bowler		9100	Rural Virtual Academy	charter						2021	grade_10	2	2
2335711	WI	Langlade	school		1582	Public Schools-Multidistrict Charters	Elcho		9100	Rural Virtual Academy	charter						2021	grade_10	2	2
2338722	WI	Jefferson	school		2898	Public Schools-Multidistrict Charters	Lake Mills Area		9803	JEDI Virtual K-12 - Jefferson and Eastern Dane County Interactive	charter						2021	grade_10	2	2
2338949	WI	Kewaunee	school		3220	Public Schools-Multidistrict Charters	Luxemburg-Casco		9803	JEDI Virtual K-12	charter						2021	grade_10	2	2
2342115	WI	Wood	school	5510380	3906	Public school	Nekoosa	551038002617	400	Nekoosa Academy		Alternative School	No	High	09	12	2021	grade_10	2	2
2342264	WI	Waupaca	school	5510590	3955	Public school	New London	551059002996	430	Catalyst Academy	charter	Alternative School	Yes	High	09	12	2021	grade_10	2	2
2343560	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	2021	grade_10	2	2
2344928	WI	Milwaukee	school	5513800	5355	Public school	Shorewood	551380002623	400	New Horizons for Learning	charter	Alternative School	Yes	High	09	12	2021	grade_10	2	2
2345339	WI	Portage	school	5514490	5607	Public school	Stevens Point Area Public	551449001125	320	Juvenile Detention		Alternative School	No	Other	KG	12	2021	grade_10	2	2
2345502	WI	Marathon	school		5628	Public Schools-Multidistrict Charters	Stratford		9100	Rural Virtual Academy	charter						2021	grade_10	2	2
2347770	WI	Wood	school	5517070	6685	Public school	Wisconsin Rapids	551707003365	430	River Cities High		Alternative School	No	High	09	12	2021	grade_10	2	2
2334948	WI	Chippewa	school		1204	Public Schools-Multidistrict Charters	Cornell		9419	eSucceed Charter School	charter						2021	grade_10	3	3
2335083	WI	Barron	school	5503090	1260	Public school	Cumberland	550309002962	420	Island City Academy	charter	Career and Technical School	Yes	High	07	12	2021	grade_10	3	3
2336456	WI	Taylor	school	5505280	2135	Public school	Gilman	550528003114	9419	eSucceed Charter School	charter	Regular School	Yes	Other	KG	12	2021	grade_10	3	3
2337787	WI	Rock	school	5507020	2695	Public school	Janesville	550702002948	850	Youth Services Center		Alternative School	No	Other	04	12	2021	grade_10	3	3
2340126	WI	Dane	school	5500085	8145	Non District Charter Schools	Milestone Democratic School	550008503136	8145	Milestone Democratic School	charter	Regular School	Yes	High	07	12	2021	grade_10	3	3
2340151	WI	Rock	school		3612	Public Schools-Multidistrict Charters	Milton		9803	JEDI Virtual K-12	charter						2021	grade_10	3	3
2341835	WI	Marathon	school		3787	Public Schools-Multidistrict Charters	Mosinee		9100	Rural Virtual Academy	charter						2021	grade_10	3	3
2344281	WI	Pierce	school	5513050	4893	Public school	River Falls	551305001910	410	Renaissance Charter Academy	charter	Regular School	Yes	High	09	12	2021	grade_10	3	3
2345033	WI	Douglas	school	5513980	5397	Public school	Solon Springs	551398003092	850	Eagles' Wings Virtual Charter School	charter	Regular School	Yes	Other	PK	12	2021	grade_10	3	3
2345467	WI	Dane	school		5621	Public Schools-Multidistrict Charters	Stoughton Area		9803	JEDI Virtual K-12	charter						2021	grade_10	3	3
2345850	WI	Monroe	school	5514910	5747	Public school	Tomah Area	551491002543	800	Robert Kupper Learning Center		Alternative School	No	Other	PK	12	2021	grade_10	3	3
2347857	WI	Juneau	school	5517130	6713	Public school	Wonewoc-Union Center	551713003059	850	Wonewoc-Center Virtual Academy	charter	Regular School	Yes	Other	KG	12	2021	grade_10	3	3
2333539	WI	Wood	school		203	Public Schools-Multidistrict Charters	Auburndale		9100	Rural Virtual Academy	charter						2021	grade_10	4	4
2334625	WI	Price	school	5500058	1071	Public school	Chequamegon	550005802780	450	Class ACT Charter	charter	Career and Technical School	Yes	High	09	12	2021	grade_10	4	4
2335090	WI	Barron	school	5503090	1260	Public school	Cumberland	550309002871	800	Island City Virtual Academy	charter	Regular School	Yes	Other	PK	12	2021	grade_10	4	4
2337177	WI	Sawyer	school	5506270	2478	Public school	Hayward Community	550627002867	250	Northern Waters Environmental School	charter	Regular School	Yes	High	06	12	2021	grade_10	4	4
2341767	WI	Marquette	school	5509870	3689	Public school	Montello	550987002821	420	High Marq Environmental Charter School	charter	Regular School	Yes	High	06	12	2021	grade_10	4	4
2341964	WI	Juneau	school	5510230	3871	Public school	Necedah Area	551023003116	410	N-Gage Academy	charter	Regular School	Yes	High	06	12	2021	grade_10	4	4
2342793	WI	Oconto	school	5510920	4067	Public school	Oconto Unified	551092003060	800	Northeast Wisconsin Learning Academy		Alternative School	No	High	05	12	2021	grade_10	4	4
2347258	WI	Washington	school	5516290	6307	Public school	West Bend	551629002666	400	Washington Street School		Alternative School	No	High	06	12	2021	grade_10	4	4
2347276	WI	Brown	school	5516320	6328	Public school	West De Pere	551632002752	400	Phantom Knight School of Opportunity	charter	Regular School	Yes	High	07	12	2021	grade_10	4	4
2347517	WI	Walworth	school		6461	Public Schools-Multidistrict Charters	Whitewater Unified		9803	JEDI Virtual K-12 - Jefferson and Eastern Dane County Interactive	charter						2021	grade_10	4	4
2334033	WI	Washburn	school	5501170	441	Public school	Birchwood	550117003020	800	Bobcat Virtual Academy	charter	Regular School	Yes	Other	KG	12	2021	grade_10	5	5
2334437	WI	Dane	school	5502100	896	Public school	Cambridge	550210003093	400	Koshkonong Trails School	charter	Regular School	Yes	High	07	12	2021	grade_10	5	5
2335280	WI	Vernon	school	5503240	1421	Public school	De Soto Area	550324003022	810	De Soto Virtual School	charter	Regular School	Yes	Other	KG	12	2021	grade_10	5	5
2335343	WI	Brown	school	5503660	1407	Public school	Denmark	550366002936	450	Denmark Community School	charter	Regular School	Yes	High	06	12	2021	grade_10	5	5
2335562	WI	Eau Claire	school	5504050	1554	Public school	Eau Claire Area	550405000705	580	McKinley Charter School	charter	Alternative School	Yes	High	06	12	2021	grade_10	5	5
2335674	WI	Rock	school		1568	Public Schools-Multidistrict Charters	Edgerton		9803	JEDI Virtual K-12	charter						2021	grade_10	5	5
2335771	WI	Walworth	school	5504290	1638	Public school	Elkhorn Area	550429002520	9401	Career and College Academy	charter	Regular School	Yes	High	09	12	2021	grade_10	5	5
2342574	WI	Washburn	school	5509720	3654	Public school	Northwood	550972003018	800	Northwood Virtual Charter School	charter	Regular School	Yes	Other	PK	12	2021	grade_10	5	5
2345585	WI	Dane	school		5656	Public Schools-Multidistrict Charters	Sun Prairie Area		9803	JEDI Virtual K-12	charter						2021	grade_10	5	5
2345855	WI	Monroe	school		5747	Public Schools-Multidistrict Charters	Tomah Area		9100	Rural Virtual Academy	charter						2021	grade_10	5	5
2346047	WI	Manitowoc	school	5515120	5824	Public school	Two Rivers Public	551512003037	810	Lighthouse Learning Academy	charter	Regular School	Yes	Other	PK	12	2021	grade_10	5	5
2346293	WI	Door	school	5515570	6069	Public school	Washington	551557001987	40	Washington Island High		Regular School	No	High	09	12	2021	grade_10	5	5
2347132	WI	Milwaukee	school	5516260	6300	Public school	West Allis-West Milwaukee	551626002490	490	James E Dottke Alternative School		Alternative School	No	High	09	12	2021	grade_10	5	5
2333863	WI	Rock	school	5501050	413	Public school	Beloit	550105002799	850	Beloit Virtual School		Regular School	No	Other	PK	12	2021	grade_10	6	6
2335517	WI	Eau Claire	school	5504050	1554	Public school	Eau Claire Area	550405003115	810	Eau Claire Virtual School	charter	Regular School	Yes	Other	04	12	2021	grade_10	6	6
2339610	WI	Juneau	school	5508850	3360	Public school	Mauston	550885002863	410	iLEAD Individualized Leadership and Entrepreneurship Academic Discovery	charter	Regular School	Yes	High	07	12	2021	grade_10	6	6
2342125	WI	Wood	school	5510380	3906	Public school	Nekoosa	551038003089	800	WISE Academy	charter	Regular School	Yes	Other	PK	12	2021	grade_10	6	6
2342367	WI	Waukesha	school	5510710	3976	Public school	Norris	551071001395	20	Norris Academy		Regular School	No	Other	KG	12	2021	grade_10	6	6
2345613	WI	Dane	school	5514640	5656	Public school	Sun Prairie Area	551464002625	410	Prairie Phoenix Academy		Alternative School	No	High	10	12	2021	grade_10	6	6
2334393	WI	Chippewa	school		870	Public Schools-Multidistrict Charters	Cadott Community		9419	eSucceed Charter School	charter						2021	grade_10	7	7
2338752	WI	Oneida	school	5509630	3647	Public school	Lakeland UHS	550963003090	400	Lakeland STAR Academy--Strong Talented Adventurous Remarkable	charter	Regular School	Yes	High	09	12	2021	grade_10	7	7
2339584	WI	Wood	school		3339	Public Schools-Multidistrict Charters	Marshfield Unified		9100	Rural Virtual Academy	charter						2021	grade_10	7	7
2340246	WI	Milwaukee	school	5509600	3619	Public school	Milwaukee	550960002707	432	Banner Preparatory School of Milwaukee		Alternative School	No	High	09	12	2021	grade_10	7	7
2340932	WI	Milwaukee	school	5509600	3619	Public school	Milwaukee	550960002567	296	Lad Lake Synergy School		Alternative School	No	High	06	12	2021	grade_10	7	7
2341784	WI	Marquette	school	5509870	3689	Public school	Montello	550987003016	800	Montello Virtual Charter School	charter	Regular School	Yes	Other	PK	12	2021	grade_10	7	7
2343286	WI	Vilas	school	5511710	4330	Public school	Phelps	551171001540	20	Phelps High		Regular School	No	High	09	12	2021	grade_10	7	7
2343310	WI	Price	school		4347	Public Schools-Multidistrict Charters	Phillips		9100	Rural Virtual Academy							2021	grade_10	7	7
2345407	WI	Portage	school		5607	Public Schools-Multidistrict Charters	Stevens Point Area Public		9100	Rural Virtual Academy	charter						2021	grade_10	7	7
2346407	WI	Jefferson	school	5515750	6125	Public school	Watertown Unified	551575002981	430	Endeavor Charter School	charter	Regular School	Yes	High	09	12	2021	grade_10	7	7
2347465	WI	Langlade	school	5516590	6440	Public school	White Lake	551659002165	40	White Lake High		Regular School	No	High	09	12	2021	grade_10	7	7
2337332	WI	Dodge	school		2576	Public Schools-Multidistrict Charters	Horicon		405	Kiel eSchool	charter						2021	grade_10	8	8
2337754	WI	Rock	school	5507020	2695	Public school	Janesville	550702002691	430	TAGOS Leadership Academy-Tailoring Academics to Guide our Students	charter	Regular School	Yes	High	07	12	2021	grade_10	8	8
2338060	WI	Kenosha	school	5507320	2793	Public school	Kenosha	550732002910	800	Kenosha eSchool K-12	charter	Regular School	Yes	Other	KG	12	2021	grade_10	8	8
2345207	WI	Monroe	school	5514160	5460	Public school	Sparta Area	551416002542	410	Sparta High Point School	charter	Regular School	Yes	High	07	12	2021	grade_10	8	8
2333155	WI	Outagamie	school	5500390	147	Public school	Appleton Area	550039002549	440	Appleton eSchool	charter	Regular School	Yes	High	07	12	2021	grade_10	9	9
2336533	WI	Marinette	school	5505580	2212	Public school	Goodman-Armstrong Creek	550558000592	40	Goodman High		Regular School	No	High	07	12	2021	grade_10	9	9
2336686	WI	Brown	school	5505820	2289	Public school	Green Bay Area Public	550582003009	800	Dr Rosa Minoka-Hill School		Alternative School	No	Other	KG	12	2021	grade_10	9	9
2337602	WI	Dane	school	5500082	8141	Non District Charter Schools	Isthmus Montessori Academy Public	550008203085	8141	Isthmus Montessori Academy Public	charter	Regular School	Yes	Other	PK	11	2021	grade_10	9	9
2339509	WI	Dane	school	5508790	3332	Public school	Marshall	550879002901	9803	JEDI Virtual K-12	charter	Alternative School	Yes	Other	PK	12	2021	grade_10	9	9
2339970	WI	Iron	school	5509150	3484	Public school	Mercer	550915001092	40	Mercer School		Regular School	No	Other	PK	12	2021	grade_10	9	9
2333372	WI	Outagamie	school	5500390	147	Public school	Appleton Area	550039003341	460	Valley New School	charter	Regular School	Yes	High	07	12	2021	grade_10	10	10
2335110	WI	Marathon	school	5513170	4970	Public school	D C Everest Area	551317002885	400	D C Everest Idea School	charter	Regular School	Yes	High	06	12	2021	grade_10	10	10
2338028	WI	Kenosha	school	5507320	2793	Public school	Kenosha	550732002317	280	Hillcrest School		Alternative School	No	High	06	12	2021	grade_10	10	10
2339351	WI	Manitowoc	school	5508610	3290	Public school	Manitowoc	550861002701	400	McKinley Academy	charter	Alternative School	Yes	High	09	12	2021	grade_10	10	10
2341499	WI	Milwaukee	school	5509600	3619	Public school	Milwaukee	550960003055	448	Vincent Accelerated Academy		Alternative School	No	High	09	12	2021	grade_10	10	10