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 "state" = :p0 and "year" = :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	hispanic	male	low_income	disability	total	hispanic_int	male_int	total_int
2332954	WI	Clark	school		7	Public Schools-Multidistrict Charters	Abbotsford		9100	Rural Virtual Academy	charter						2021	pk_12_total					0			0
2333999	WI	Walworth	school		6013	Public Schools-Multidistrict Charters	Big Foot UHS		9401	Career and College Academy	charter						2021	pk_12_total					0			0
2334285	WI	Rusk	school		735	Public Schools-Multidistrict Charters	Bruce		9419	eSucceed Charter School	charter						2021	pk_12_total					0			0
2334372	WI	Ashland	school	5501920	840	Public school	Butternut	550192002751	450	Promethean Charter School	charter	Regular School	Yes	High	09	12	2021	pk_12_total					0			0
2334826	WI	Waupaca	school		1141	Public Schools-Multidistrict Charters	Clintonville		9100	Rural Virtual Academy	charter						2021	pk_12_total					0			0
2335394	WI	Dodge	school		2744	Public Schools-Multidistrict Charters	Dodgeland		405	Kiel eSchool	charter						2021	pk_12_total					0			0
2335595	WI	Eau Claire	school	5504050	1554	Public school	Eau Claire Area	550405002675	430	Oxford Avenue School		Alternative School	No	High	10	12	2021	pk_12_total					0			0
2336192	WI	Jefferson	school		1883	Public Schools-Multidistrict Charters	Fort Atkinson		9803	JEDI Virtual K-12	charter						2021	pk_12_total					0			0
2336733	WI	Brown	school	5505820	2289	Public school	Green Bay Area Public	550582002965	170	Friedrich Froebel Garden of Early Learning		Regular School	No	Elementary	PK	KG	2021	pk_12_total					0			0
2336756	WI	Brown	school	5505820	2289	Public school	Green Bay Area Public	550582000626	360	Jefferson Elementary		Regular School	No	Elementary	PK	05	2021	pk_12_total					0			0
2336757	WI	Brown	school	5505820	2289	Public school	Green Bay Area Public	550582003138	50	Jefferson Head Start Learning Center		Regular School	No	Prekindergarten	PK	PK	2021	pk_12_total					0			0
2338324	WI	Kewaunee	school		2814	Public Schools-Multidistrict Charters	Kewaunee		800	Between the Lakes Virtual Academy	charter						2021	pk_12_total					0			0
2338343	WI	Kewaunee	school		2814	Public Schools-Multidistrict Charters	Kewaunee		405	Kiel eSchool	charter						2021	pk_12_total					0			0
2338361	WI	Vernon	school		5960	Public Schools-Multidistrict Charters	Kickapoo Area		9407	Vernon County Area Better Futures High	charter						2021	pk_12_total					0			0
2338629	WI	Vilas	school		1848	Public Schools-Multidistrict Charters	Lac du Flambeau #1		9418	Lakeland STAR School--Strong Talented Adventurous Remarkable	charter						2021	pk_12_total					0			0
2338703	WI	Chippewa	school		2891	Public Schools-Multidistrict Charters	Lake Holcombe		9419	eSucceed Charter School	charter						2021	pk_12_total					0			0
2339092	WI	Dane	school	5508520	3269	Public school	Madison Metropolitan	550852002909	220	Innovative & Alternative Middle		Alternative School	No	Middle	06	08	2021	pk_12_total					0			0
2339648	WI	Dodge	school		3367	Public Schools-Multidistrict Charters	Mayville		800	Between the Lakes Virtual Academy	charter						2021	pk_12_total					0			0
2339649	WI	Dodge	school		3367	Public Schools-Multidistrict Charters	Mayville		405	Kiel eSchool	charter						2021	pk_12_total					0			0
2342096	WI	Clark	school		3899	Public Schools-Multidistrict Charters	Neillsville		9100	Rural Virtual Academy	charter						2021	pk_12_total					0			0
2342448	WI	Vilas	school		616	Public Schools-Multidistrict Charters	North Lakeland		9418	Lakeland STAR School--Strong Talented Adventurous Remarkable	charter						2021	pk_12_total					0			0
2342690	WI	Fond du Lac	school		4025	Public Schools-Multidistrict Charters	Oakfield		405	Kiel eSchool	charter						2021	pk_12_total					0			0
2343133	WI	Jefferson	school	5511350	4221	Public school	Palmyra-Eagle Area	551135001514	20	Palmyra Elementary		Regular School	No	Elementary	PK	06	2021	pk_12_total					0			0
2343950	WI	Dodge	school		4634	Public Schools-Multidistrict Charters	Randolph		405	Kiel eSchool	charter						2021	pk_12_total					0			0
2344122	WI	Taylor	school		4795	Public Schools-Multidistrict Charters	Rib Lake		9100	Rural Virtual Academy	charter						2021	pk_12_total					0			0
2345290	WI	Chippewa	school		5593	Public Schools-Multidistrict Charters	Stanley-Boyd Area		9419	eSucceed Charter School	charter						2021	pk_12_total					0			0
2347902	WI	Vilas	school		6720	Public Schools-Multidistrict Charters	Woodruff J1		9418	Lakeland STAR School--Strong Talented Adventurous Remarkable	charter						2021	pk_12_total					0			0
2332985	WI	Green	school	5500120	63	Public school	Albany	550012000013	20	Albany Elementary		Regular School	No	Elementary	PK	04	2021	pre_kindergarten					1			1
2333033	WI	Jackson	school	5500210	91	Public school	Alma Center	550021000022	80	Lincoln Elementary		Regular School	No	Elementary	PK	06	2021	pre_kindergarten					1			1
2333049	WI	Portage	school	5500240	105	Public school	Almond-Bancroft	550024000023	20	Almond-Bancroft Elementary		Regular School	No	Elementary	PK	05	2021	pre_kindergarten					1			1
2333152	WI	Outagamie	school	5500390	147	Public school	Appleton Area	550039002679	800	Appleton Cooperative Educational Center		Alternative School	No	Other	04	12	2021	pk_12_total	1.0	1.0	*	*	1	1	1	1
2333153	WI	Outagamie	school	5500390	147	Public school	Appleton Area	550039002679	800	Appleton Cooperative Educational Center		Alternative School	No	Other	04	12	2021	grade_12					1			1
2333427	WI	Lafayette	school	5500450	161	Public school	Argyle	550045000069	20	Argyle Elementary		Regular School	No	Elementary	PK	05	2021	pre_kindergarten					1			1
2333469	WI	Ashland	school		170	Public Schools-Multidistrict Charters	Ashland		9100	Rural Virtual Academy							2021	grade_10					1			1
2333470	WI	Ashland	school		170	Public Schools-Multidistrict Charters	Ashland		9100	Rural Virtual Academy							2021	grade_11					1			1
2333471	WI	Ashland	school		170	Public Schools-Multidistrict Charters	Ashland		9100	Rural Virtual Academy							2021	grade_12					1			1
2333472	WI	Ashland	school		170	Public Schools-Multidistrict Charters	Ashland		9100	Rural Virtual Academy							2021	grade_2					1			1
2333473	WI	Ashland	school		170	Public Schools-Multidistrict Charters	Ashland		9100	Rural Virtual Academy							2021	grade_5					1			1
2333474	WI	Ashland	school		170	Public Schools-Multidistrict Charters	Ashland		9100	Rural Virtual Academy							2021	grade_7					1			1
2333476	WI	Ashland	school		170	Public Schools-Multidistrict Charters	Ashland		9100	Rural Virtual Academy							2021	kindergarten					1			1
2333542	WI	Wood	school		203	Public Schools-Multidistrict Charters	Auburndale		9100	Rural Virtual Academy	charter						2021	grade_2					1			1
2333544	WI	Wood	school		203	Public Schools-Multidistrict Charters	Auburndale		9100	Rural Virtual Academy	charter						2021	grade_5					1			1
2333545	WI	Wood	school		203	Public Schools-Multidistrict Charters	Auburndale		9100	Rural Virtual Academy	charter						2021	grade_6					1			1
2333546	WI	Wood	school		203	Public Schools-Multidistrict Charters	Auburndale		9100	Rural Virtual Academy	charter						2021	grade_7					1			1
2333547	WI	Wood	school		203	Public Schools-Multidistrict Charters	Auburndale		9100	Rural Virtual Academy	charter						2021	grade_8					1			1
2333600	WI	La Crosse	school	5500780	245	Public school	Bangor	550078000100	20	Bangor Elementary		Regular School	No	Elementary	PK	05	2021	pre_kindergarten					1			1
2333688	WI	Barron	school	5500870	308	Public school	Barron Area	550087002717	100	Barron Area Montessori School	charter	Regular School	Yes	Elementary	PK	04	2021	grade_2					1			1
2333743	WI	Bayfield	school	5500900	315	Public school	Bayfield	550090002358	60	La Pointe Elementary		Regular School	No	Elementary	PK	06	2021	grade_5					1			1
2333803	WI	Marinette	school	5511550	4263	Public school	Beecher-Dunbar-Pembine	551155001529	40	Pembine Elementary		Regular School	No	Elementary	PK	06	2021	pre_kindergarten					1			1
2334001	WI	Washburn	school	5501170	441	Public school	Birchwood	550117002800	450	Birchwood Blue Hills Charter School	charter	Regular School	Yes	High	07	12	2021	grade_12					1			1
2334002	WI	Washburn	school	5501170	441	Public school	Birchwood	550117002800	450	Birchwood Blue Hills Charter School	charter	Regular School	Yes	High	07	12	2021	grade_7					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
2334026	WI	Washburn	school	5501170	441	Public school	Birchwood	550117002937	130	Birchwood Public Montessori	charter	Regular School	Yes	Elementary	PK	06	2021	grade_4					1			1
2334037	WI	Washburn	school	5501170	441	Public school	Birchwood	550117003020	800	Bobcat Virtual Academy	charter	Regular School	Yes	Other	KG	12	2021	grade_3					1			1
2334040	WI	Washburn	school	5501170	441	Public school	Birchwood	550117003020	800	Bobcat Virtual Academy	charter	Regular School	Yes	Other	KG	12	2021	grade_6					1			1
2334041	WI	Washburn	school	5501170	441	Public school	Birchwood	550117003020	800	Bobcat Virtual Academy	charter	Regular School	Yes	Other	KG	12	2021	grade_7					1			1
2334171	WI	Shawano	school		623	Public Schools-Multidistrict Charters	Bowler		9100	Rural Virtual Academy	charter						2021	grade_11					1			1
2334172	WI	Shawano	school		623	Public Schools-Multidistrict Charters	Bowler		9100	Rural Virtual Academy	charter						2021	grade_12					1			1
2334173	WI	Shawano	school		623	Public Schools-Multidistrict Charters	Bowler		9100	Rural Virtual Academy	charter						2021	grade_4					1			1
2334174	WI	Shawano	school		623	Public Schools-Multidistrict Charters	Bowler		9100	Rural Virtual Academy	charter						2021	grade_7					1			1
2334260	WI	Milwaukee	school	5501800	721	Public school	Brown Deer	550180000232	80	Brown Deer Elementary		Regular School	No	Elementary	PK	05	2021	pre_kindergarten					1			1
2334469	WI	Barron	school	5502130	903	Public school	Cameron	550213000256	20	Cameron Elementary		Regular School	No	Elementary	PK	04	2021	pre_kindergarten					1			1
2334518	WI	Monroe	school	5502340	980	Public school	Cashton	550234000262	20	Cashton Elementary		Regular School	No	Elementary	PK	05	2021	pre_kindergarten					1			1
2334646	WI	Price	school		1071	Public Schools-Multidistrict Charters	Chequamegon		9100	Rural Virtual Academy	charter						2021	grade_5					1			1
2334647	WI	Price	school		1071	Public Schools-Multidistrict Charters	Chequamegon		9100	Rural Virtual Academy	charter						2021	kindergarten					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
2334672	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_3					1			1
2334673	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_4					1			1
2334681	WI	Barron	school		1080	Public Schools-Multidistrict Charters	Chetek-Weyerhaeuser Area		9410	North Star Academy	charter						2021	grade_10					1			1
2334789	WI	Polk	school	5502610	1127	Public school	Clear Lake	550261000291	20	Gaylord A Nelson Educational Center		Regular School	No	Elementary	PK	06	2021	pre_kindergarten					1			1
2334863	WI	Clark	school		1162	Public Schools-Multidistrict Charters	Colby		9100	Rural Virtual Academy	charter						2021	grade_11					1			1
2334865	WI	Clark	school		1162	Public Schools-Multidistrict Charters	Colby		9100	Rural Virtual Academy	charter						2021	grade_3					1			1
2334868	WI	Clark	school		1162	Public Schools-Multidistrict Charters	Colby		9100	Rural Virtual Academy	charter						2021	grade_7					1			1
2334870	WI	Clark	school		1162	Public Schools-Multidistrict Charters	Colby		9100	Rural Virtual Academy	charter						2021	grade_9					1			1
2334955	WI	Chippewa	school		1204	Public Schools-Multidistrict Charters	Cornell		9419	eSucceed Charter School	charter						2021	grade_6					1			1
2335056	WI	Milwaukee	school	5503060	1253	Public school	Cudahy	550306000338	50	Mitchell Elementary		Regular School	No	Elementary	PK	05	2021	pre_kindergarten					1			1
2335084	WI	Barron	school	5503090	1260	Public school	Cumberland	550309002962	420	Island City Academy	charter	Career and Technical School	Yes	High	07	12	2021	grade_11					1			1
2335086	WI	Barron	school	5503090	1260	Public school	Cumberland	550309002962	420	Island City Academy	charter	Career and Technical School	Yes	High	07	12	2021	grade_7					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
2335138	WI	Marathon	school	5513170	4970	Public school	D C Everest Area	551317001738	60	Hatley Elementary		Regular School	No	Elementary	PK	05	2021	pre_kindergarten					1			1
2335284	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_5					1			1
2335296	WI	Vernon	school	5503240	1421	Public school	De Soto Area	550324000368	80	Prairie View Elementary		Regular School	No	Elementary	PK	05	2021	pre_kindergarten					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
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
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
2335681	WI	Rock	school		1568	Public Schools-Multidistrict Charters	Edgerton		9803	JEDI Virtual K-12	charter						2021	grade_7					1			1
2335683	WI	Rock	school		1568	Public Schools-Multidistrict Charters	Edgerton		9803	JEDI Virtual K-12	charter						2021	grade_9					1			1
2335684	WI	Rock	school		1568	Public Schools-Multidistrict Charters	Edgerton		9803	JEDI Virtual K-12	charter						2021	kindergarten_4_year_old					1			1
2335700	WI	Langlade	school	5504170	1582	Public school	Elcho	550417000447	20	Elcho Elementary		Regular School	No	Elementary	PK	05	2021	pre_kindergarten					1			1
2335712	WI	Langlade	school		1582	Public Schools-Multidistrict Charters	Elcho		9100	Rural Virtual Academy	charter						2021	grade_11					1			1
2335714	WI	Langlade	school		1582	Public Schools-Multidistrict Charters	Elcho		9100	Rural Virtual Academy	charter						2021	grade_3					1			1
2335715	WI	Langlade	school		1582	Public Schools-Multidistrict Charters	Elcho		9100	Rural Virtual Academy	charter						2021	grade_4					1			1
2335716	WI	Langlade	school		1582	Public Schools-Multidistrict Charters	Elcho		9100	Rural Virtual Academy	charter						2021	grade_7					1			1
2335764	WI	Sheboygan	school	5504260	1631	Public school	Elkhart Lake-Glenbeulah	550426000455	20	Elkhart Lake Elementary/Middle		Regular School	No	Elementary	PK	08	2021	pre_kindergarten					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
2335878	WI	Waukesha	school	5501770	714	Public school	Elmbrook	550177000221	160	Fairview South		Special Education School	No	High	05	12	2021	grade_6					1			1
2335879	WI	Waukesha	school	5501770	714	Public school	Elmbrook	550177000221	160	Fairview South		Special Education School	No	High	05	12	2021	grade_7					1			1
2335923	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_2					1			1
2335924	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_3					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
2335940	WI	Washington	school	5504410	1687	Public school	Erin	550441000476	20	Erin Elementary		Regular School	No	Elementary	PK	08	2021	pre_kindergarten					1			1