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
2334870	WI	Clark	school		1162	Public Schools-Multidistrict Charters	Colby		9100	Rural Virtual Academy	charter						2021	grade_9	1	1
2335087	WI	Barron	school	5503090	1260	Public school	Cumberland	550309002962	420	Island City Academy	charter	Career and Technical School	Yes	High	07	12	2021	grade_9	1	1
2335525	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_9	1	1
2335624	WI	Eau Claire	school	5504050	1554	Public school	Eau Claire Area	550405002658	800	Second Avenue School		Alternative School	No	Other	04	12	2021	grade_9	1	1
2335683	WI	Rock	school		1568	Public Schools-Multidistrict Charters	Edgerton		9803	JEDI Virtual K-12	charter						2021	grade_9	1	1
2335774	WI	Walworth	school	5504290	1638	Public school	Elkhorn Area	550429002520	9401	Career and College Academy	charter	Regular School	Yes	High	09	12	2021	grade_9	1	1
2337739	WI	Rock	school	5507020	2695	Public school	Janesville	550702001698	400	Rock River Charter School	charter	Regular School	Yes	High	06	12	2021	grade_9	1	1
2337808	WI	Jefferson	school		2702	Public Schools-Multidistrict Charters	Jefferson		9803	JEDI Virtual K-12	charter						2021	grade_9	1	1
2337871	WI	Green	school		2737	Public Schools-Multidistrict Charters	Juda		405	Kiel eSchool	charter						2021	grade_9	1	1
2338727	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_9	1	1
2339618	WI	Juneau	school		3360	Public Schools-Multidistrict Charters	Mauston		9803	JEDI Virtual K-12	charter						2021	grade_9	1	1
2341120	WI	Milwaukee	school	5509600	3619	Public school	Milwaukee	550960001306	315	Milwaukee County Youth Education Center		Alternative School	No	High	06	12	2021	grade_9	1	1
2341732	WI	Green	school		3682	Public Schools-Multidistrict Charters	Monroe		9803	JEDI Virtual K-12	charter						2021	grade_9	1	1
2341844	WI	Marathon	school		3787	Public Schools-Multidistrict Charters	Mosinee		9100	Rural Virtual Academy	charter						2021	grade_9	1	1
2342267	WI	Waupaca	school	5510590	3955	Public school	New London	551059002996	430	Catalyst Academy	charter	Alternative School	Yes	High	09	12	2021	grade_9	1	1
2342372	WI	Waukesha	school	5510710	3976	Public school	Norris	551071001395	20	Norris Academy		Regular School	No	Other	KG	12	2021	grade_9	1	1
2344356	WI	Grant	school	5510140	3850	Public school	Riverdale	551014003084	430	Riverdale Academy		Alternative School	No	High	06	12	2021	grade_9	1	1
2344931	WI	Milwaukee	school	5513800	5355	Public school	Shorewood	551380002623	400	New Horizons for Learning	charter	Alternative School	Yes	High	09	12	2021	grade_9	1	1
2345040	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_9	1	1
2345141	WI	Door	school		5457	Public Schools-Multidistrict Charters	Southern Door County		9100	Rural Virtual Academy	charter						2021	grade_9	1	1
2345343	WI	Portage	school	5514490	5607	Public school	Stevens Point Area Public	551449001125	320	Juvenile Detention		Alternative School	No	Other	KG	12	2021	grade_9	1	1
2345510	WI	Marathon	school		5628	Public Schools-Multidistrict Charters	Stratford		9100	Rural Virtual Academy	charter						2021	grade_9	1	1
2345753	WI	Clark	school		5726	Public Schools-Multidistrict Charters	Thorp		9100	Rural Virtual Academy	charter						2021	grade_9	1	1
2346599	WI	Waukesha	school	5515780	6174	Public school	Waukesha	551578002502	490	Waukesha East Alternative School	charter	Alternative School	Yes	High	06	12	2021	grade_9	1	1
2347333	WI	Vernon	school		6321	Public Schools-Multidistrict Charters	Westby Area		9100	Rural Virtual Academy	charter						2021	grade_9	1	1
2333475	WI	Ashland	school		170	Public Schools-Multidistrict Charters	Ashland		9100	Rural Virtual Academy							2021	grade_9	2	2
2334004	WI	Washburn	school	5501170	441	Public school	Birchwood	550117002800	450	Birchwood Blue Hills Charter School	charter	Regular School	Yes	High	07	12	2021	grade_9	2	2
2334628	WI	Price	school	5500058	1071	Public school	Chequamegon	550005802780	450	Class ACT Charter	charter	Career and Technical School	Yes	High	09	12	2021	grade_9	2	2
2339091	WI	Dane	school	5508520	3269	Public school	Madison Metropolitan	550852003349	460	Innovative & Alternative High		Alternative School	No	High	09	12	2021	grade_9	2	2
2339177	WI	Dane	school	5508520	3269	Public school	Madison Metropolitan	550852002670	820	Metro School		Alternative School	No	Other	04	12	2021	grade_9	2	2
2342380	WI	Waukesha	school	5510710	3976	Public school	Norris	551071003072	800	Norris Academy Virtual School	charter	Alternative School	Yes	Other	KG	12	2021	grade_9	2	2
2343344	WI	Wood	school		4368	Public Schools-Multidistrict Charters	Pittsville		9100	Rural Virtual Academy	charter						2021	grade_9	2	2
2345212	WI	Monroe	school	5514160	5460	Public school	Sparta Area	551416002542	410	Sparta High Point School	charter	Regular School	Yes	High	07	12	2021	grade_9	2	2
2345592	WI	Dane	school		5656	Public Schools-Multidistrict Charters	Sun Prairie Area		9803	JEDI Virtual K-12	charter						2021	grade_9	2	2
2346364	WI	Jefferson	school		6118	Public Schools-Multidistrict Charters	Waterloo		9803	JEDI Virtual K-12	charter						2021	grade_9	2	2
2346566	WI	Waukesha	school	5515780	6174	Public school	Waukesha	551578003070	800	Riverview School		Alternative School	No	High	06	12	2021	grade_9	2	2
2333548	WI	Wood	school		203	Public Schools-Multidistrict Charters	Auburndale		9100	Rural Virtual Academy	charter						2021	grade_9	3	3
2337183	WI	Sawyer	school	5506270	2478	Public school	Hayward Community	550627002867	250	Northern Waters Environmental School	charter	Regular School	Yes	High	06	12	2021	grade_9	3	3
2338066	WI	Kenosha	school	5507320	2793	Public school	Kenosha	550732002910	800	Kenosha eSchool K-12	charter	Regular School	Yes	Other	KG	12	2021	grade_9	3	3
2339519	WI	Dane	school	5508790	3332	Public school	Marshall	550879002901	9803	JEDI Virtual K-12	charter	Alternative School	Yes	Other	PK	12	2021	grade_9	3	3
2339594	WI	Wood	school		3339	Public Schools-Multidistrict Charters	Marshfield Unified		9100	Rural Virtual Academy	charter						2021	grade_9	3	3
2340131	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_9	3	3
2342545	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_9	3	3
2342584	WI	Washburn	school	5509720	3654	Public school	Northwood	550972003018	800	Northwood Virtual Charter School	charter	Regular School	Yes	Other	PK	12	2021	grade_9	3	3
2344102	WI	Oneida	school		4781	Public Schools-Multidistrict Charters	Rhinelander		9100	Rural Virtual Academy	charter						2021	grade_9	3	3
2345998	WI	Barron	school	5515060	5810	Public school	Turtle Lake	551506003032	810	Laker Online	charter	Regular School	Yes	Other	PK	12	2021	grade_9	3	3
2347280	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_9	3	3
2347836	WI	Sawyer	school	5500086	8146	Non District Charter Schools	WOLI/Akii'gikinoo'amaading Environmental	550008603137	8146	WOLI/Akii'gikinoo'amaading Environmental School	charter	Regular School	Yes	High	06	12	2021	grade_9	3	3
2334403	WI	Chippewa	school		870	Public Schools-Multidistrict Charters	Cadott Community		9419	eSucceed Charter School	charter						2021	grade_9	4	4
2334958	WI	Chippewa	school		1204	Public Schools-Multidistrict Charters	Cornell		9419	eSucceed Charter School	charter						2021	grade_9	4	4
2335566	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_9	4	4
2336466	WI	Taylor	school	5505280	2135	Public school	Gilman	550528003114	9419	eSucceed Charter School	charter	Regular School	Yes	Other	KG	12	2021	grade_9	4	4
2336538	WI	Marinette	school	5505580	2212	Public school	Goodman-Armstrong Creek	550558000592	40	Goodman High		Regular School	No	High	07	12	2021	grade_9	4	4
2337790	WI	Rock	school	5507020	2695	Public school	Janesville	550702002948	850	Youth Services Center		Alternative School	No	Other	04	12	2021	grade_9	4	4
2338033	WI	Kenosha	school	5507320	2793	Public school	Kenosha	550732002317	280	Hillcrest School		Alternative School	No	High	06	12	2021	grade_9	4	4
2344190	WI	Richland	school	5512960	4851	Public school	Richland	551296002998	450	Richland Online Academy	charter	Regular School	Yes	High	06	12	2021	grade_9	4	4
2345473	WI	Dane	school		5621	Public Schools-Multidistrict Charters	Stoughton Area		9803	JEDI Virtual K-12	charter						2021	grade_9	4	4
2347135	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_9	4	4
2347867	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_9	4	4
2334442	WI	Dane	school	5502100	896	Public school	Cambridge	550210003093	400	Koshkonong Trails School	charter	Regular School	Yes	High	07	12	2021	grade_9	5	5
2334678	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_9	5	5
2341773	WI	Marquette	school	5509870	3689	Public school	Montello	550987002821	420	High Marq Environmental Charter School	charter	Regular School	Yes	High	06	12	2021	grade_9	5	5
2343570	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_9	5	5
2345864	WI	Monroe	school		5747	Public Schools-Multidistrict Charters	Tomah Area		9100	Rural Virtual Academy	charter						2021	grade_9	5	5
2335349	WI	Brown	school	5503660	1407	Public school	Denmark	550366002936	450	Denmark Community School	charter	Regular School	Yes	High	06	12	2021	grade_9	6	6
2335928	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_9	6	6
2338376	WI	Manitowoc	school	5507440	2828	Public school	Kiel Area	550744002554	405	Kiel eSchool	charter	Regular School	Yes	High	07	12	2021	grade_9	6	6
2339354	WI	Manitowoc	school	5508610	3290	Public school	Manitowoc	550861002701	400	McKinley Academy	charter	Alternative School	Yes	High	09	12	2021	grade_9	6	6
2341502	WI	Milwaukee	school	5509600	3619	Public school	Milwaukee	550960003055	448	Vincent Accelerated Academy		Alternative School	No	High	09	12	2021	grade_9	6	6
2341794	WI	Marquette	school	5509870	3689	Public school	Montello	550987003016	800	Montello Virtual Charter School	charter	Regular School	Yes	Other	PK	12	2021	grade_9	6	6
2345415	WI	Portage	school		5607	Public Schools-Multidistrict Charters	Stevens Point Area Public		9100	Rural Virtual Academy	charter						2021	grade_9	6	6
2334043	WI	Washburn	school	5501170	441	Public school	Birchwood	550117003020	800	Bobcat Virtual Academy	charter	Regular School	Yes	Other	KG	12	2021	grade_9	7	7
2334459	WI	Barron	school	5502130	903	Public school	Cameron	550213002851	800	Cameron Academy of Virtual Education	charter	Alternative School	Yes	Other	PK	12	2021	grade_9	7	7
2337611	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_9	7	7
2337759	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_9	7	7
2338755	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_9	7	7
2339980	WI	Iron	school	5509150	3484	Public school	Mercer	550915001092	40	Mercer School		Regular School	No	Other	PK	12	2021	grade_9	7	7
2347524	WI	Walworth	school		6461	Public Schools-Multidistrict Charters	Whitewater Unified		9803	JEDI Virtual K-12 - Jefferson and Eastern Dane County Interactive	charter						2021	grade_9	7	7
2333860	WI	Rock	school	5501050	413	Public school	Beloit	550105002974	421	Beloit Learning Academy		Alternative School	No	High	06	12	2021	grade_9	8	8
2343289	WI	Vilas	school	5511710	4330	Public school	Phelps	551171001540	20	Phelps High		Regular School	No	High	09	12	2021	grade_9	8	8
2346410	WI	Jefferson	school	5515750	6125	Public school	Watertown Unified	551575002981	430	Endeavor Charter School	charter	Regular School	Yes	High	09	12	2021	grade_9	8	8
2333377	WI	Outagamie	school	5500390	147	Public school	Appleton Area	550039003341	460	Valley New School	charter	Regular School	Yes	High	07	12	2021	grade_9	9	9
2333873	WI	Rock	school	5501050	413	Public school	Beloit	550105002799	850	Beloit Virtual School		Regular School	No	Other	PK	12	2021	grade_9	9	9
2339246	WI	Dane	school	5508520	3269	Public school	Madison Metropolitan	550852002265	400	Shabazz-City High		Alternative School	No	High	09	12	2021	grade_9	9	9
2339615	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_9	9	9
2344702	WI	Sheboygan	school	5513650	5271	Public school	Sheboygan Area	551365002879	450	Central High	charter	Regular School	Yes	High	09	12	2021	grade_9	9	9
2346744	WI	Marathon	school	5515900	6223	Public school	Wausau	551590002747	400	Enrich Excel Achieve Learning Academy	charter	Alternative School	Yes	High	06	12	2021	grade_9	9	9
2335100	WI	Barron	school	5503090	1260	Public school	Cumberland	550309002871	800	Island City Virtual Academy	charter	Regular School	Yes	Other	PK	12	2021	grade_9	10	10
2340937	WI	Milwaukee	school	5509600	3619	Public school	Milwaukee	550960002567	296	Lad Lake Synergy School		Alternative School	No	High	06	12	2021	grade_9	10	10
2341293	WI	Milwaukee	school	5509600	3619	Public school	Milwaukee	550960001007	458	Project STAY-Supporting Teachers and Youth		Alternative School	No	High	09	12	2021	grade_9	10	10
2346403	WI	Jefferson	school	5515750	6125	Public school	Watertown Unified	551575003127	800	eCampus Academy Charter School	charter	Regular School	Yes	Other	PK	12	2021	grade_9	10	10
2333158	WI	Outagamie	school	5500390	147	Public school	Appleton Area	550039002549	440	Appleton eSchool	charter	Regular School	Yes	High	07	12	2021	grade_9	11	11
2336495	WI	Buffalo	school	5505370	2142	Public school	Gilmanton	550537000574	60	Gilmanton High		Regular School	No	High	09	12	2021	grade_9	11	11
2337335	WI	Dodge	school		2576	Public Schools-Multidistrict Charters	Horicon		405	Kiel eSchool	charter						2021	grade_9	11	11
2340704	WI	Milwaukee	school	5509600	3619	Public school	Milwaukee	550960000963	236	Groppi High		Alternative School	No	High	09	12	2021	grade_9	11	11
2345815	WI	Shawano	school	5514880	5740	Public school	Tigerton	551488001932	40	Tigerton High		Regular School	No	High	06	12	2021	grade_9	11	11
2346057	WI	Manitowoc	school	5515120	5824	Public school	Two Rivers Public	551512003037	810	Lighthouse Learning Academy	charter	Regular School	Yes	Other	PK	12	2021	grade_9	11	11
2346202	WI	Vernon	school	5515360	5985	Public school	Viroqua Area	551536001936	410	Laurel High	charter	Regular School	Yes	High	09	12	2021	grade_9	11	11
2333023	WI	Buffalo	school	5500180	84	Public school	Alma	550018000018	40	Alma High		Regular School	No	High	09	12	2021	grade_9	12	12
2335116	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_9	12	12
2336092	WI	Fond du Lac	school	5504680	1862	Public school	Fond du Lac	550468002966	210	Fond du Lac STEM Institute	charter	Regular School	Yes	High	06	12	2021	grade_9	12	12