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 (total_int > :p3 or (total_int = :p3 and rowid > :p2)) order by total_int, rowid 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
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
3088027	WI	Brown	school	5516320	6328	Public school	West De Pere	551632002752	400	Phantom Knight School of Opportunity	charter	Regular School	Yes	High	07	12	2019	grade_8	1	1
3089295	WI	Wood	school		203	Public Schools-Multidistrict Charters	Auburndale		9100	Rural Virtual Academy	charter						2018	grade_8	1	1
3090418	WI	Barron	school	5500061	1080	Public school	Chetek-Weyerhaeuser Area	550006102897	800	Link2Learn Virtual Charter School	charter	Regular School	Yes	Other	PK	12	2018	grade_8	1	1
3091006	WI	Vernon	school	5503240	1421	Public school	De Soto Area	550324003022	810	De Soto Virtual School	charter	Regular School	Yes	Other	KG	12	2018	grade_8	1	1
3091333	WI	Eau Claire	school	5504050	1554	Public school	Eau Claire Area	550405002658	800	Second Avenue School		Alternative School	No	Other	04	12	2018	grade_8	1	1
3091643	WI	Rock	school		1694	Public Schools-Multidistrict Charters	Evansville Community		9803	JEDI Virtual K-12	charter						2018	grade_8	1	1
3093434	WI	Jefferson	school		2702	Public Schools-Multidistrict Charters	Jefferson		9803	JEDI Virtual K-12	charter						2018	grade_8	1	1
3093694	WI	Kenosha	school	5507320	2793	Public school	Kenosha	550732003051	810	Kenosha Pike School		Special Education School	No	Other	PK	12	2018	grade_8	1	1
3096502	WI	Milwaukee	school	5509600	3619	Public school	Milwaukee	550960002567	296	Lad Lake Synergy School		Alternative School	No	High	06	12	2018	grade_8	1	1
3097332	WI	Green	school		3682	Public Schools-Multidistrict Charters	Monroe		9803	JEDI Virtual K-12	charter						2018	grade_8	1	1
3097390	WI	Marquette	school	5509870	3689	Public school	Montello	550987003016	800	Montello Virtual Charter School	charter	Regular School	Yes	Other	KG	12	2018	grade_8	1	1
3098106	WI	Vilas	school	5503860	1526	Public school	Northland Pines	550386003013	410	School of Options & Applied Research High	charter	Regular School	Yes	High	08	12	2018	grade_8	1	1
3099165	WI	Price	school		4571	Public Schools-Multidistrict Charters	Prentice		9100	Rural Virtual Academy	charter						2018	grade_8	1	1
3100013	WI	Juneau	school	5504380	1673	Public school	Royall	550438000473	40	Royall Intermediate		Regular School	No	Middle	04	06	2018	grade_8	1	1
3101109	WI	Dane	school		5656	Public Schools-Multidistrict Charters	Sun Prairie Area		9803	JEDI Virtual K-12	charter						2018	grade_8	1	1
3102119	WI	Waupaca	school		6195	Public Schools-Multidistrict Charters	Waupaca		9408	Waupaca County Charter	charter						2018	grade_8	1	1
3102410	WI	Milwaukee	school	5515990	6244	Public school	Wauwatosa	551599002349	190	Plank Road Complex		Alternative School	No	Other	KG	12	2018	grade_8	1	1
3102718	WI	Brown	school	5516320	6328	Public school	West De Pere	551632002752	400	Phantom Knight School of Opportunity	charter	Regular School	Yes	High	07	12	2018	grade_8	1	1
112715	WI	Rock	school	5501050	413	Public school	Beloit	550105002799	850	Beloit Virtual School		Regular School	No	4.0	PK	12	2015	grade_8	2	2
114384	WI	Eau Claire	school	5504050	1554	Public school	Eau Claire Area	550405002658	800	Second Avenue School		Alternative Education School	No	4.0	04	12	2015	grade_8	2	2
118000	WI	Manitowoc	school	5508610	3290	Public school	Manitowoc	550861002714	9120	Manitowoc County Comprehensive Charter School	charter	Special Education School	Yes	1.0	01	08	2015	grade_8	2	2
118680	WI	Dane	school	5509510	3549	Public school	Middleton-Cross Plains Area	550951002818	800	21st Century eSchool	charter	Regular School	Yes	4.0	KG	12	2015	grade_8	2	2
118795	WI	Milwaukee	school	5509600	3619	Public school	Milwaukee	550960002935	447	Achievement Center		Alternative Education School	No	4.0	06	12	2015	grade_8	2	2
119577	WI	Milwaukee	school	5509600	3619	Public school	Milwaukee	550960002567	296	Lad Lake Synergy School		Alternative Education School	No	4.0	06	12	2015	grade_8	2	2
120807	WI	Wood	school	5510380	3906	Public school	Nekoosa	551038002715	200	Niikuusra Community School	charter	Alternative Education School	Yes	2.0	04	08	2015	grade_8	2	2
123878	WI	Marathon	school		5467	Public Schools-Multidistrict Charters	Spencer		9100	Rural Virtual Academy	charter						2015	grade_8	2	2
124108	WI	Dane	school		5621	Public Schools-Multidistrict Charters	Stoughton Area		9803	JEDI Virtual K-12	charter						2015	grade_8	2	2
124619	WI	Manitowoc	school		5824	Public Schools-Multidistrict Charters	Two Rivers Public		9120	Manitowoc County Comprehensive Charter School	charter						2015	grade_8	2	2
284609	WI	Waukesha	school	5501770	714	Public school	Elmbrook	550177000221	160	Fairview South		Special Education School	No	4.0	02	12	2016	grade_8	2	2
285197	WI	Oconto	school	5505250	2128	Public school	Gillett	550525002906	450	Gillett's Occupation and Leadership Academy	charter	Regular School	Yes	4.0	06	12	2016	grade_8	2	2
288234	WI	Juneau	school		3360	Public Schools-Multidistrict Charters	Mauston		9803	JEDI Virtual K-12	charter						2016	grade_8	2	2
290931	WI	Waupaca	school	5510590	3955	Public school	New London	551059002943	410	Next Generation Academy	charter	Regular School	Yes	3.0	07	12	2016	grade_8	2	2
291228	WI	Racine	school	5510800	4011	Public school	Norway J7	551080001405	20	Drought Elementary		Regular School	No	1.0	PK	08	2016	grade_8	2	2
291375	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_8	2	2
293087	WI	Saint Croix	school	5506060	2422	Public school	Saint Croix Central	550606002989	850	Saint Croix Academy of Virtual Education	charter	Regular School	Yes	4.0	KG	12	2016	grade_8	2	2
294786	WI	Door	school	5515570	6069	Public school	Washington	551557001986	20	Washington Island Elementary		Regular School	No	1.0	PK	08	2016	grade_8	2	2
327764	WI	Barron	school	5503090	1260	Public school	Cumberland	550309002871	800	Island City Virtual Academy	charter	Regular School	Yes	Other	PK	12	2017	grade_8	2	2
329259	WI	Brown	school	5505820	2289	Public school	Green Bay Area Public	550582000612	40	Bay View		Alternative School	No	Other	PK	12	2017	grade_8	2	2
332549	WI	Dane	school	5509510	3549	Public school	Middleton-Cross Plains Area	550951002818	800	21st Century eSchool	charter	Regular School	Yes	Other	KG	12	2017	grade_8	2	2
337725	WI	Marathon	school		5467	Public Schools-Multidistrict Charters	Spencer		9100	Rural Virtual Academy	charter						2017	grade_8	2	2
2319260	WI	Washburn	school	5501170	441	Public school	Birchwood	550117003020	800	Bobcat Virtual Academy	charter	Regular School	Yes	Other	PK	12	2020	grade_8	2	2
2320302	WI	Barron	school	5503090	1260	Public school	Cumberland	550309002871	800	Island City Virtual Academy	charter	Regular School	Yes	Other	PK	12	2020	grade_8	2	2
2320722	WI	Eau Claire	school	5504050	1554	Public school	Eau Claire Area	550405003115	810	Eau Claire Virtual School	charter	Regular School	Yes	High	06	12	2020	grade_8	2	2
2323192	WI	Kenosha	school	5507320	2793	Public school	Kenosha	550732002910	800	Kenosha eSchool K-12	charter	Regular School	Yes	Other	KG	12	2020	grade_8	2	2
2326761	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	2020	grade_8	2	2
2327504	WI	Waukesha	school	5510710	3976	Public school	Norris	551071003072	800	Norris Academy Virtual School	charter	Alternative School	Yes	Other	KG	12	2020	grade_8	2	2
2327682	WI	Washburn	school	5509720	3654	Public school	Northwood	550972002877	200	NorthStar Community Charter School	charter	Regular School	Yes	Middle	04	08	2020	grade_8	2	2
2329225	WI	Taylor	school		4795	Public Schools-Multidistrict Charters	Rib Lake		9100	Rural Virtual Academy	charter						2020	grade_8	2	2
2329293	WI	Richland	school	5512960	4851	Public school	Richland	551296002998	450	Richland Online Academy	charter	Regular School	Yes	High	06	12	2020	grade_8	2	2
2329459	WI	Grant	school	5510140	3850	Public school	Riverdale	551014003084	430	Riverdale Academy		Alternative School	No	High	06	12	2020	grade_8	2	2
2330838	WI	Clark	school		5726	Public Schools-Multidistrict Charters	Thorp		9100	Rural Virtual Academy	charter						2020	grade_8	2	2
2332026	WI	Milwaukee	school	5515990	6244	Public school	Wauwatosa	551599002349	190	Vel R Phillips School		Alternative School	No	Other	KG	12	2020	grade_8	2	2
2335286	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_8	2	2
2335348	WI	Brown	school	5503660	1407	Public school	Denmark	550366002936	450	Denmark Community School	charter	Regular School	Yes	High	06	12	2021	grade_8	2	2
2335880	WI	Waukesha	school	5501770	714	Public school	Elmbrook	550177000221	160	Fairview South		Special Education School	No	High	05	12	2021	grade_8	2	2
2339487	WI	Waupaca	school		3318	Public Schools-Multidistrict Charters	Marion		9100	Rural Virtual Academy	charter						2021	grade_8	2	2
2340936	WI	Milwaukee	school	5509600	3619	Public school	Milwaukee	550960002567	296	Lad Lake Synergy School		Alternative School	No	High	06	12	2021	grade_8	2	2
2341772	WI	Marquette	school	5509870	3689	Public school	Montello	550987002821	420	High Marq Environmental Charter School	charter	Regular School	Yes	High	06	12	2021	grade_8	2	2
2342379	WI	Waukesha	school	5510710	3976	Public school	Norris	551071003072	800	Norris Academy Virtual School	charter	Alternative School	Yes	Other	KG	12	2021	grade_8	2	2
2345039	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_8	2	2
2345752	WI	Clark	school		5726	Public Schools-Multidistrict Charters	Thorp		9100	Rural Virtual Academy	charter						2021	grade_8	2	2
2346598	WI	Waukesha	school	5515780	6174	Public school	Waukesha	551578002502	490	Waukesha East Alternative School	charter	Alternative School	Yes	High	06	12	2021	grade_8	2	2
2346997	WI	Milwaukee	school	5515990	6244	Public school	Wauwatosa	551599002349	190	Vel R Phillips School		Alternative School	No	Other	KG	12	2021	grade_8	2	2
2347523	WI	Walworth	school		6461	Public Schools-Multidistrict Charters	Whitewater Unified		9803	JEDI Virtual K-12 - Jefferson and Eastern Dane County Interactive	charter						2021	grade_8	2	2
3075667	WI	Barron	school	5500061	1080	Public school	Chetek-Weyerhaeuser Area	550006102897	800	Link2Learn Virtual Charter School	charter	Regular School	Yes	Other	PK	12	2019	grade_8	2	2
3076528	WI	Eau Claire	school	5504050	1554	Public school	Eau Claire Area	550405000705	580	McKinley Charter School	charter	Alternative School	Yes	High	06	12	2019	grade_8	2	2
3076890	WI	Rock	school		1694	Public Schools-Multidistrict Charters	Evansville Community		9803	JEDI Virtual K-12	charter						2019	grade_8	2	2
3080431	WI	Wood	school		3339	Public Schools-Multidistrict Charters	Marshfield Unified		9100	Rural Virtual Academy	charter						2019	grade_8	2	2
3089771	WI	Washburn	school	5501170	441	Public school	Birchwood	550117002800	450	Birchwood Blue Hills Charter School	charter	Regular School	Yes	High	07	12	2018	grade_8	2	2
3089806	WI	Washburn	school	5501170	441	Public school	Birchwood	550117003020	800	Bobcat Virtual Academy	charter	Regular School	Yes	Other	PK	12	2018	grade_8	2	2
3091566	WI	Waukesha	school	5501770	714	Public school	Elmbrook	550177000221	160	Fairview South		Special Education School	No	High	06	12	2018	grade_8	2	2
3095172	WI	Juneau	school		3360	Public Schools-Multidistrict Charters	Mauston		9803	JEDI Virtual K-12	charter						2018	grade_8	2	2
3097434	WI	Marathon	school		3787	Public Schools-Multidistrict Charters	Mosinee		9100	Rural Virtual Academy	charter						2018	grade_8	2	2
3098118	WI	Washburn	school	5509720	3654	Public school	Northwood	550972002877	200	NorthStar Community Charter School	charter	Regular School	Yes	Middle	04	08	2018	grade_8	2	2
3098886	WI	Wood	school		4368	Public Schools-Multidistrict Charters	Pittsville		9100	Rural Virtual Academy	charter						2018	grade_8	2	2
3100781	WI	Marathon	school		5467	Public Schools-Multidistrict Charters	Spencer		9100	Rural Virtual Academy	charter						2018	grade_8	2	2
114329	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	2015	grade_8	3	3
116341	WI	Rock	school	5507020	2695	Public school	Janesville	550702002991	860	ARISE Virtual Academy	charter	Regular School	Yes	4.0	KG	12	2015	grade_8	3	3
117821	WI	Dane	school	5508520	3269	Public school	Madison Metropolitan	550852002670	820	Metro School		Alternative Education School	No	4.0	04	12	2015	grade_8	3	3
123910	WI	Washburn	school	5514220	5474	Public school	Spooner Area	551422002971	850	Spooner Area Virtual Education Academy	charter	Regular School	Yes	4.0	PK	12	2015	grade_8	3	3
282695	WI	Rock	school	5501050	413	Public school	Beloit	550105002799	850	Beloit Virtual School		Regular School	No	4.0	PK	12	2016	grade_8	3	3
282830	WI	Washburn	school	5501170	441	Public school	Birchwood	550117002800	450	Birchwood Blue Hills Charter School	charter	Regular School	Yes	3.0	07	12	2016	grade_8	3	3
284513	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_8	3	3
284669	WI	Milwaukee	school	5500069	8131	Non District Charter Schools	Escuela Verde	550006902920	400	Escuela Verde	charter	Regular School	Yes	3.0	07	12	2016	grade_8	3	3
288680	WI	Dane	school	5509510	3549	Public school	Middleton-Cross Plains Area	550951002818	800	21st Century eSchool	charter	Regular School	Yes	4.0	KG	12	2016	grade_8	3	3
295111	WI	Waupaca	school		6195	Public Schools-Multidistrict Charters	Waupaca		9408	Waupaca County Charter	charter						2016	grade_8	3	3
295148	WI	Fond du Lac	school	5515870	6216	Public school	Waupun	551587002903	150	School for Agricultural and Environmental Studies	charter	Regular School	Yes	1.0	PK	08	2016	grade_8	3	3
295697	WI	Washington	school	5516290	6307	Public school	West Bend	551629002666	400	Washington Street School		Alternative Education School	No	4.0	06	12	2016	grade_8	3	3
295715	WI	Brown	school	5516320	6328	Public school	West De Pere	551632002752	400	Phantom Knight School of Opportunity	charter	Regular School	Yes	3.0	07	12	2016	grade_8	3	3
325834	WI	Langlade	school		140	Public Schools-Multidistrict Charters	Antigo Unified		9100	Rural Virtual Academy	charter						2017	grade_8	3	3
325889	WI	Outagamie	school	5500390	147	Public school	Appleton Area	550039003021	820	Appleview		Special Education School	No	Other	PK	12	2017	grade_8	3	3
326587	WI	Rock	school	5501050	413	Public school	Beloit	550105002974	421	Beloit Learning Academy		Alternative School	No	Other	06	12	2017	grade_8	3	3
326596	WI	Rock	school	5501050	413	Public school	Beloit	550105002799	850	Beloit Virtual School		Regular School	No	Other	PK	12	2017	grade_8	3	3
326734	WI	Washburn	school	5501170	441	Public school	Birchwood	550117002800	450	Birchwood Blue Hills Charter School	charter	Regular School	Yes	High	07	12	2017	grade_8	3	3
327360	WI	Barron	school	5500061	1080	Public school	Chetek-Weyerhaeuser Area	550006102897	800	Link2Learn Virtual Charter School	charter	Regular School	Yes	Other	PK	12	2017	grade_8	3	3
328007	WI	Brown	school	5503660	1407	Public school	Denmark	550366002936	450	Denmark Community School	charter	Regular School	Yes	High	07	12	2017	grade_8	3	3
334794	WI	Waupaca	school	5510590	3955	Public school	New London	551059002943	410	Next Generation Academy	charter	Regular School	Yes	High	07	12	2017	grade_8	3	3
336966	WI	Saint Croix	school	5506060	2422	Public school	Saint Croix Central	550606002989	850	Saint Croix Academy of Virtual Education	charter	Regular School	Yes	Other	KG	12	2017	grade_8	3	3
337709	WI	Monroe	school	5514160	5460	Public school	Sparta Area	551416002542	410	Sparta High Point School	charter	Regular School	Yes	High	07	12	2017	grade_8	3	3
339075	WI	Fond du Lac	school	5515870	6216	Public school	Waupun	551587002903	150	School for Agricultural and Environmental Studies	charter	Regular School	Yes	Elementary	PK	08	2017	grade_8	3	3