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 ccd_school_type 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
2333126	WI	Langlade	school		140	Public Schools-Multidistrict Charters	Antigo Unified		9100	Rural Virtual Academy	charter						2021	grade_12	19	19
2333471	WI	Ashland	school		170	Public Schools-Multidistrict Charters	Ashland		9100	Rural Virtual Academy							2021	grade_12	1	1
2333541	WI	Wood	school		203	Public Schools-Multidistrict Charters	Auburndale		9100	Rural Virtual Academy	charter						2021	grade_12	3	3
2333700	WI	Barron	school		308	Public Schools-Multidistrict Charters	Barron Area		9410	North Star Academy	charter						2021	grade_12	7	7
2333939	WI	Rock	school		422	Public Schools-Multidistrict Charters	Beloit Turner		9803	JEDI Virtual K-12	charter						2021	grade_12	2	2
2334172	WI	Shawano	school		623	Public Schools-Multidistrict Charters	Bowler		9100	Rural Virtual Academy	charter						2021	grade_12	1	1
2334320	WI	Racine	school		777	Public Schools-Multidistrict Charters	Burlington Area		9803	JEDI Virtual K-12	charter						2021	grade_12	34	34
2334395	WI	Chippewa	school		870	Public Schools-Multidistrict Charters	Cadott Community		9419	eSucceed Charter School	charter						2021	grade_12	5	5
2334645	WI	Price	school		1071	Public Schools-Multidistrict Charters	Chequamegon		9100	Rural Virtual Academy	charter						2021	grade_12	2	2
2334682	WI	Barron	school		1080	Public Schools-Multidistrict Charters	Chetek-Weyerhaeuser Area		9410	North Star Academy	charter						2021	grade_12	7	7
2334864	WI	Clark	school		1162	Public Schools-Multidistrict Charters	Colby		9100	Rural Virtual Academy	charter						2021	grade_12	6	6
2334950	WI	Chippewa	school		1204	Public Schools-Multidistrict Charters	Cornell		9419	eSucceed Charter School	charter						2021	grade_12	3	3
2335676	WI	Rock	school		1568	Public Schools-Multidistrict Charters	Edgerton		9803	JEDI Virtual K-12	charter						2021	grade_12	2	2
2335713	WI	Langlade	school		1582	Public Schools-Multidistrict Charters	Elcho		9100	Rural Virtual Academy	charter						2021	grade_12	2	2
2335958	WI	Rock	school		1694	Public Schools-Multidistrict Charters	Evansville Community		9803	JEDI Virtual K-12	charter						2021	grade_12	1	1
2337334	WI	Dodge	school		2576	Public Schools-Multidistrict Charters	Horicon		405	Kiel eSchool	charter						2021	grade_12	7	7
2337547	WI	Dodge	school		2625	Public Schools-Multidistrict Charters	Hustisford		405	Kiel eSchool	charter						2021	grade_12	3	3
2337803	WI	Jefferson	school		2702	Public Schools-Multidistrict Charters	Jefferson		9803	JEDI Virtual K-12	charter						2021	grade_12	1	1
2338616	WI	Vernon	school		2863	Public Schools-Multidistrict Charters	La Farge		9407	Vernon County Area Better Futures High	charter						2021	grade_12	2	2
2338700	WI	Walworth	school		2884	Public Schools-Multidistrict Charters	Lake Geneva-Genoa City UHS		9401	Career and College Academy	charter						2021	grade_12	8	8
2338724	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_12	2	2
2338951	WI	Kewaunee	school		3220	Public Schools-Multidistrict Charters	Luxemburg-Casco		9803	JEDI Virtual K-12	charter						2021	grade_12	1	1
2339586	WI	Wood	school		3339	Public Schools-Multidistrict Charters	Marshfield Unified		9100	Rural Virtual Academy	charter						2021	grade_12	3	3
2339617	WI	Juneau	school		3360	Public Schools-Multidistrict Charters	Mauston		9803	JEDI Virtual K-12	charter						2021	grade_12	2	2
2340153	WI	Rock	school		3612	Public Schools-Multidistrict Charters	Milton		9803	JEDI Virtual K-12	charter						2021	grade_12	5	5
2341729	WI	Green	school		3682	Public Schools-Multidistrict Charters	Monroe		9803	JEDI Virtual K-12	charter						2021	grade_12	2	2
2341837	WI	Marathon	school		3787	Public Schools-Multidistrict Charters	Mosinee		9100	Rural Virtual Academy	charter						2021	grade_12	5	5
2343120	WI	Clark	school		4207	Public Schools-Multidistrict Charters	Owen-Withee		9100	Rural Virtual Academy	charter						2021	grade_12	1	1
2343312	WI	Price	school		4347	Public Schools-Multidistrict Charters	Phillips		9100	Rural Virtual Academy							2021	grade_12	3	3
2343339	WI	Wood	school		4368	Public Schools-Multidistrict Charters	Pittsville		9100	Rural Virtual Academy	charter						2021	grade_12	2	2
2343615	WI	Price	school		4571	Public Schools-Multidistrict Charters	Prentice		9100	Rural Virtual Academy	charter						2021	grade_12	2	2
2345135	WI	Door	school		5457	Public Schools-Multidistrict Charters	Southern Door County		9100	Rural Virtual Academy	charter						2021	grade_12	1	1
2345229	WI	Marathon	school		5467	Public Schools-Multidistrict Charters	Spencer		9100	Rural Virtual Academy	charter						2021	grade_12	1	1
2345469	WI	Dane	school		5621	Public Schools-Multidistrict Charters	Stoughton Area		9803	JEDI Virtual K-12	charter						2021	grade_12	6	6
2345587	WI	Dane	school		5656	Public Schools-Multidistrict Charters	Sun Prairie Area		9803	JEDI Virtual K-12	charter						2021	grade_12	6	6
2345745	WI	Clark	school		5726	Public Schools-Multidistrict Charters	Thorp		9100	Rural Virtual Academy	charter						2021	grade_12	1	1
2345857	WI	Monroe	school		5747	Public Schools-Multidistrict Charters	Tomah Area		9100	Rural Virtual Academy	charter						2021	grade_12	4	4
2346002	WI	Barron	school		5810	Public Schools-Multidistrict Charters	Turtle Lake		9410	North Star Academy	charter						2021	grade_12	1	1
2346351	WI	Racine	school		6083	Public Schools-Multidistrict Charters	Waterford UHS		9803	JEDI Virtual K-12	charter						2021	grade_12	25	25
2347328	WI	Vernon	school		6321	Public Schools-Multidistrict Charters	Westby Area		9100	Rural Virtual Academy	charter						2021	grade_12	3	3
2347336	WI	Vernon	school		6321	Public Schools-Multidistrict Charters	Westby Area		9407	Vernon County Area Better Futures High	charter						2021	grade_12	5	5
2347519	WI	Walworth	school		6461	Public Schools-Multidistrict Charters	Whitewater Unified		9803	JEDI Virtual K-12 - Jefferson and Eastern Dane County Interactive	charter						2021	grade_12	7	7
2347608	WI	Walworth	school		6482	Public Schools-Multidistrict Charters	Williams Bay		9401	Career and College Academy	charter						2021	grade_12	2	2
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
2333757	WI	Dodge	school	5500960	336	Public school	Beaver Dam Unified	550096002815	850	Don Smith Learning Academy		Alternative School	No	High	09	12	2021	grade_12	54	54
2333857	WI	Rock	school	5501050	413	Public school	Beloit	550105002974	421	Beloit Learning Academy		Alternative School	No	High	06	12	2021	grade_12	110	110
2334451	WI	Barron	school	5502130	903	Public school	Cameron	550213002851	800	Cameron Academy of Virtual Education	charter	Alternative School	Yes	Other	PK	12	2021	grade_12	26	26
2334482	WI	Barron	school	5502130	903	Public school	Cameron	550213002500	9410	North Star Academy	charter	Alternative School	Yes	High	09	12	2021	grade_12	4	4
2335564	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_12	134	134
2335622	WI	Eau Claire	school	5504050	1554	Public school	Eau Claire Area	550405002658	800	Second Avenue School		Alternative School	No	Other	04	12	2021	grade_12	3	3
2336258	WI	Milwaukee	school	5504830	1900	Public school	Franklin Public	550483002685	400	Milwaukee County Correctional Facility South		Alternative School	No	High	09	12	2021	grade_12	14	14
2336647	WI	Brown	school	5505820	2289	Public school	Green Bay Area Public	550582000612	40	Bay View		Alternative School	No	Other	PK	12	2021	grade_12	11	11
2336688	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_12	11	11
2337789	WI	Rock	school	5507020	2695	Public school	Janesville	550702002948	850	Youth Services Center		Alternative School	No	Other	04	12	2021	grade_12	3	3
2338030	WI	Kenosha	school	5507320	2793	Public school	Kenosha	550732002317	280	Hillcrest School		Alternative School	No	High	06	12	2021	grade_12	17	17
2338117	WI	Kenosha	school	5507320	2793	Public school	Kenosha	550732001714	405	Phoenix Project		Alternative School	No	High	09	12	2021	grade_12	9	9
2338139	WI	Kenosha	school	5507320	2793	Public school	Kenosha	550732000822	450	Reuther Central High		Alternative School	No	High	09	12	2021	grade_12	137	137
2338994	WI	Dane	school	5508520	3269	Public school	Madison Metropolitan	550852003095	410	Capital High		Alternative School	No	High	09	12	2021	grade_12	59	59
2339090	WI	Dane	school	5508520	3269	Public school	Madison Metropolitan	550852003349	460	Innovative & Alternative High		Alternative School	No	High	09	12	2021	grade_12	96	96
2339176	WI	Dane	school	5508520	3269	Public school	Madison Metropolitan	550852002670	820	Metro School		Alternative School	No	Other	04	12	2021	grade_12	12	12
2339245	WI	Dane	school	5508520	3269	Public school	Madison Metropolitan	550852002265	400	Shabazz-City High		Alternative School	No	High	09	12	2021	grade_12	36	36
2339353	WI	Manitowoc	school	5508610	3290	Public school	Manitowoc	550861002701	400	McKinley Academy	charter	Alternative School	Yes	High	09	12	2021	grade_12	7	7
2339511	WI	Dane	school	5508790	3332	Public school	Marshall	550879002901	9803	JEDI Virtual K-12	charter	Alternative School	Yes	Other	PK	12	2021	grade_12	6	6
2339686	WI	Dane	school	5508910	3381	Public school	McFarland	550891003067	470	Insight School of Wisconsin High	charter	Alternative School	Yes	High	09	12	2021	grade_12	140	140
2340022	WI	Lincoln	school	5509210	3500	Public school	Merrill Area	550921002743	400	Merrill Adult Diploma Academy	charter	Alternative School	Yes	High	10	12	2021	grade_12	15	15
2340225	WI	Milwaukee	school	5509600	3619	Public school	Milwaukee	550960000792	1063	ASSATA High		Alternative School	No	High	09	12	2021	grade_12	23	23
2340248	WI	Milwaukee	school	5509600	3619	Public school	Milwaukee	550960002707	432	Banner Preparatory School of Milwaukee		Alternative School	No	High	09	12	2021	grade_12	5	5
2340655	WI	Milwaukee	school	5509600	3619	Public school	Milwaukee	550960002577	410	Grandview High		Alternative School	No	High	09	12	2021	grade_12	51	51
2340703	WI	Milwaukee	school	5509600	3619	Public school	Milwaukee	550960000963	236	Groppi High		Alternative School	No	High	09	12	2021	grade_12	28	28
2340934	WI	Milwaukee	school	5509600	3619	Public school	Milwaukee	550960002567	296	Lad Lake Synergy School		Alternative School	No	High	06	12	2021	grade_12	13	13
2341119	WI	Milwaukee	school	5509600	3619	Public school	Milwaukee	550960001306	315	Milwaukee County Youth Education Center		Alternative School	No	High	06	12	2021	grade_12	1	1
2341254	WI	Milwaukee	school	5509600	3619	Public school	Milwaukee	550960000843	1072	NOVA-Northwest Opportunities Vocational Academy		Alternative School	No	High	09	12	2021	grade_12	12	12
2341292	WI	Milwaukee	school	5509600	3619	Public school	Milwaukee	550960001007	458	Project STAY-Supporting Teachers and Youth		Alternative School	No	High	09	12	2021	grade_12	44	44
2341357	WI	Milwaukee	school	5509600	3619	Public school	Milwaukee	550960000856	1074	Shalom High		Alternative School	No	High	09	12	2021	grade_12	27	27
2341463	WI	Milwaukee	school	5509600	3619	Public school	Milwaukee	550960002760	433	Transition High		Alternative School	No	High	09	12	2021	grade_12	21	21
2341501	WI	Milwaukee	school	5509600	3619	Public school	Milwaukee	550960003055	448	Vincent Accelerated Academy		Alternative School	No	High	09	12	2021	grade_12	15	15
2342117	WI	Wood	school	5510380	3906	Public school	Nekoosa	551038002617	400	Nekoosa Academy		Alternative School	No	High	09	12	2021	grade_12	14	14
2342266	WI	Waupaca	school	5510590	3955	Public school	New London	551059002996	430	Catalyst Academy	charter	Alternative School	Yes	High	09	12	2021	grade_12	26	26
2342376	WI	Waukesha	school	5510710	3976	Public school	Norris	551071003072	800	Norris Academy Virtual School	charter	Alternative School	Yes	Other	KG	12	2021	grade_12	5	5
2342795	WI	Oconto	school	5510920	4067	Public school	Oconto Unified	551092003060	800	Northeast Wisconsin Learning Academy		Alternative School	No	High	05	12	2021	grade_12	12	12
2343485	WI	Columbia	school	5512060	4501	Public school	Portage Community	551206002174	400	Portage Academy of Achievement		Alternative School	No	High	09	12	2021	grade_12	15	15
2343858	WI	Racine	school	5512360	4620	Public school	Racine Unified	551236003045	801	Racine Alternative Learning		Alternative School	No	Other	KG	12	2021	grade_12	184	184
2343922	WI	Racine	school	5512360	4620	Public school	Racine Unified	551236001644	499	Walden III High		Alternative School	No	High	06	12	2021	grade_12	63	63
2344353	WI	Grant	school	5510140	3850	Public school	Riverdale	551014003084	430	Riverdale Academy		Alternative School	No	High	06	12	2021	grade_12	10	10
2344930	WI	Milwaukee	school	5513800	5355	Public school	Shorewood	551380002623	400	New Horizons for Learning	charter	Alternative School	Yes	High	09	12	2021	grade_12	10	10
2345200	WI	Monroe	school	5514160	5460	Public school	Sparta Area	551416002486	800	Sparta Alternative Independent Learning School	charter	Alternative School	Yes	High	09	12	2021	grade_12	16	16
2345329	WI	Portage	school	5514490	5607	Public school	Stevens Point Area Public	551449001116	310	Charles F Fernandez Center Alt Learning		Alternative School	No	High	09	12	2021	grade_12	60	60
2345615	WI	Dane	school	5514640	5656	Public school	Sun Prairie Area	551464002625	410	Prairie Phoenix Academy		Alternative School	No	High	10	12	2021	grade_12	38	38
2345852	WI	Monroe	school	5514910	5747	Public school	Tomah Area	551491002543	800	Robert Kupper Learning Center		Alternative School	No	Other	PK	12	2021	grade_12	34	34
2346565	WI	Waukesha	school	5515780	6174	Public school	Waukesha	551578003070	800	Riverview School		Alternative School	No	High	06	12	2021	grade_12	1	1
2346597	WI	Waukesha	school	5515780	6174	Public school	Waukesha	551578002502	490	Waukesha East Alternative School	charter	Alternative School	Yes	High	06	12	2021	grade_12	33	33
2346741	WI	Marathon	school	5515900	6223	Public school	Wausau	551590002747	400	Enrich Excel Achieve Learning Academy	charter	Alternative School	Yes	High	06	12	2021	grade_12	13	13
2347134	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_12	63	63
2347190	WI	Milwaukee	school	5516260	6300	Public school	West Allis-West Milwaukee	551626002918	410	Shared Journeys	charter	Alternative School	Yes	High	07	12	2021	grade_12	1	1
2347259	WI	Washington	school	5516290	6307	Public school	West Bend	551629002666	400	Washington Street School		Alternative School	No	High	06	12	2021	grade_12	1	1
2347772	WI	Wood	school	5517070	6685	Public school	Wisconsin Rapids	551707003365	430	River Cities High		Alternative School	No	High	09	12	2021	grade_12	49	49
2333171	WI	Outagamie	school	5500390	147	Public school	Appleton Area	550039002964	490	Appleton Technical Academy	charter	Career and Technical School	Yes	High	09	12	2021	grade_12	13	13
2334627	WI	Price	school	5500058	1071	Public school	Chequamegon	550005802780	450	Class ACT Charter	charter	Career and Technical School	Yes	High	09	12	2021	grade_12	6	6
2335085	WI	Barron	school	5503090	1260	Public school	Cumberland	550309002962	420	Island City Academy	charter	Career and Technical School	Yes	High	07	12	2021	grade_12	2	2
2338084	WI	Kenosha	school	5507320	2793	Public school	Kenosha	550732001462	480	Lakeview Technology Academy		Career and Technical School	No	High	09	12	2021	grade_12	79	79
2339678	WI	Dane	school	5508910	3381	Public school	McFarland	550891003039	450	Destinations Career Academy of Wisconsin High	charter	Career and Technical School	Yes	High	09	12	2021	grade_12	39	39