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 rowid desc 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
2347914	WI	Brown	school	5517190	6734	Public school	Wrightstown Community	551719002229	40	Wrightstown High		Regular School	No	High	09	12	2021	grade_12	115	115
2347859	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_12	4	4
2347849	WI	Juneau	school	5517130	6713	Public school	Wonewoc-Union Center	551713002225	80	Wonewoc-Center High		Regular School	No	High	09	12	2021	grade_12	29	29
2347830	WI	Shawano	school	5517100	6692	Public school	Wittenberg-Birnamwood	551710002222	140	Wittenberg-Birnamwood High		Regular School	No	High	09	12	2021	grade_12	85	85
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
2347758	WI	Wood	school	5517070	6685	Public school	Wisconsin Rapids	551707002209	160	Lincoln High		Regular School	No	High	09	12	2021	grade_12	336	336
2347714	WI	Dane	school	5501230	469	Public school	Wisconsin Heights	550123000172	60	Wisconsin Heights High		Regular School	No	High	09	12	2021	grade_12	59	59
2347695	WI	Sauk	school	5517040	6678	Public school	Wisconsin Dells	551704002200	100	Wisconsin Dells High		Regular School	No	High	09	12	2021	grade_12	123	123
2347662	WI	Sawyer	school	5516860	6615	Public school	Winter	551686002195	80	Winter High		Regular School	No	High	09	12	2021	grade_12	22	22
2347644	WI	Winnebago	school	5516830	6608	Public school	Winneconne Community	551683002191	60	Winneconne High		Regular School	No	High	09	12	2021	grade_12	143	143
2347630	WI	Kenosha	school	5516770	6545	Public school	Wilmot UHS	551677002188	20	Wilmot High		Regular School	No	High	09	12	2021	grade_12	252	252
2347621	WI	Walworth	school	5516740	6482	Public school	Williams Bay	551674002187	40	Williams Bay High		Regular School	No	High	09	12	2021	grade_12	55	55
2347608	WI	Walworth	school		6482	Public Schools-Multidistrict Charters	Williams Bay		9401	Career and College Academy	charter						2021	grade_12	2	2
2347601	WI	Waushara	school	5516710	6475	Public school	Wild Rose	551671002185	60	Wild Rose High		Regular School	No	High	06	12	2021	grade_12	38	38
2347583	WI	Milwaukee	school	5506000	6470	Public school	Whitnall	550600000661	100	Whitnall High		Regular School	No	High	09	12	2021	grade_12	208	208
2347556	WI	Walworth	school	5516680	6461	Public school	Whitewater Unified	551668002182	140	Whitewater High		Regular School	No	High	09	12	2021	grade_12	144	144
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
2347512	WI	Trempealeau	school	5516650	6426	Public school	Whitehall	551665002176	120	Whitehall Memorial Junior/Senior High		Regular School	No	High	07	12	2021	grade_12	60	60
2347493	WI	Milwaukee	school	5516620	6419	Public school	Whitefish Bay	551662002170	100	Whitefish Bay High		Regular School	No	High	09	12	2021	grade_12	269	269
2347467	WI	Langlade	school	5516590	6440	Public school	White Lake	551659002165	40	White Lake High		Regular School	No	High	09	12	2021	grade_12	10	10
2347428	WI	Waupaca	school	5516500	6384	Public school	Weyauwega-Fremont	551650002159	100	Weyauwega High		Regular School	No	High	09	12	2021	grade_12	61	61
2347407	WI	Sauk	school	5516470	6354	Public school	Weston	551647002155	100	Weston Sr High School		Regular School	No	High	09	12	2021	grade_12	22	22
2347377	WI	Marquette	school	5516440	6335	Public school	Westfield	551644002151	100	Westfield Area High		Regular School	No	High	09	12	2021	grade_12	54	54
2347348	WI	Vernon	school	5516410	6321	Public school	Westby Area	551641002146	200	Westby High		Regular School	No	High	09	12	2021	grade_12	74	74
2347336	WI	Vernon	school		6321	Public Schools-Multidistrict Charters	Westby Area		9407	Vernon County Area Better Futures High	charter						2021	grade_12	5	5
2347328	WI	Vernon	school		6321	Public Schools-Multidistrict Charters	Westby Area		9100	Rural Virtual Academy	charter						2021	grade_12	3	3
2347310	WI	La Crosse	school	5516350	6370	Public school	West Salem	551635002141	80	West Salem High		Regular School	No	High	09	12	2021	grade_12	121	121
2347284	WI	Brown	school	5516320	6328	Public school	West De Pere	551632002138	120	West De Pere High		Regular School	No	High	09	12	2021	grade_12	254	254
2347278	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_12	6	6
2347265	WI	Washington	school	5516290	6307	Public school	West Bend	551629002135	200	West High		Regular School	No	High	09	12	2021	grade_12	278	278
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
2347225	WI	Washington	school	5516290	6307	Public school	West Bend	551629002128	50	East High		Regular School	No	High	09	12	2021	grade_12	256	256
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
2347177	WI	Milwaukee	school	5516260	6300	Public school	West Allis-West Milwaukee	551626002117	340	Nathan Hale High		Regular School	No	High	09	12	2021	grade_12	329	329
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
2347089	WI	Milwaukee	school	5516260	6300	Public school	West Allis-West Milwaukee	551626002101	20	Central High		Regular School	No	High	09	12	2021	grade_12	250	250
2347079	WI	Burnett	school	5516230	6293	Public school	Webster	551623002099	80	Webster High		Regular School	No	High	09	12	2021	grade_12	56	56
2347062	WI	Crawford	school	5516020	6251	Public school	Wauzeka-Steuben	551602002095	40	Wauzeka High		Regular School	No	High	09	12	2021	grade_12	24	24
2347036	WI	Milwaukee	school	5515990	6244	Public school	Wauwatosa	551599002091	280	West High		Regular School	No	High	09	12	2021	grade_12	236	236
2347028	WI	Milwaukee	school	5515990	6244	Public school	Wauwatosa	551599002921	430	Wauwatosa Virtual Academy	charter	Regular School	Yes	High	06	12	2021	grade_12	43	43
2346925	WI	Milwaukee	school	5515990	6244	Public school	Wauwatosa	551599002077	20	East High		Regular School	No	High	09	12	2021	grade_12	319	319
2346920	WI	Waushara	school	5515960	6237	Public school	Wautoma Area	551596002074	140	Wautoma High		Regular School	No	High	09	12	2021	grade_12	98	98
2346890	WI	Marinette	school	5515930	6230	Public school	Wausaukee	551593002068	100	Wausaukee High		Regular School	No	High	09	12	2021	grade_12	24	24
2346876	WI	Marathon	school	5515900	6223	Public school	Wausau	551590002064	380	West High		Regular School	No	High	09	12	2021	grade_12	345	345
2346863	WI	Marathon	school	5515900	6223	Public school	Wausau	551590003027	800	Wausau Area Virtual Education	charter	Regular School	Yes	Other	KG	12	2021	grade_12	29	29
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
2346736	WI	Marathon	school	5515900	6223	Public school	Wausau	551590002063	360	East High		Regular School	No	High	09	12	2021	grade_12	236	236
2346731	WI	Fond du Lac	school	5515870	6216	Public school	Waupun	551587002045	200	Waupun Area Senior High		Regular School	No	High	09	12	2021	grade_12	136	136
2346691	WI	Waupaca	school	5515840	6195	Public school	Waupaca	551584002035	140	Waupaca High		Regular School	No	High	09	12	2021	grade_12	156	156
2346663	WI	Dane	school	5515810	6181	Public school	Waunakee Community	551581002030	40	Waunakee High		Regular School	No	High	09	12	2021	grade_12	352	352
2346620	WI	Waukesha	school	5515780	6174	Public school	Waukesha	551578000528	560	West High		Regular School	No	High	09	12	2021	grade_12	311	311
2346616	WI	Waukesha	school	5515780	6174	Public school	Waukesha	551578002960	415	Waukesha Transition Academy		Special Education School	No	High	12	12	2021	grade_12	33	33
2346603	WI	Waukesha	school	5515780	6174	Public school	Waukesha	551578002688	430	Waukesha Engineering Preparatory Academy	charter	Regular School	Yes	High	09	12	2021	grade_12	42	42
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
2346593	WI	Waukesha	school	5515780	6174	Public school	Waukesha	551578003334	450	Waukesha Academy of Health Professions	charter	Regular School	Yes	High	09	12	2021	grade_12	38	38
2346579	WI	Waukesha	school	5515780	6174	Public school	Waukesha	551578002025	460	South High		Regular School	No	High	09	12	2021	grade_12	219	219
2346565	WI	Waukesha	school	5515780	6174	Public school	Waukesha	551578003070	800	Riverview School		Alternative School	No	High	06	12	2021	grade_12	1	1
2346553	WI	Waukesha	school	5515780	6174	Public school	Waukesha	551578002019	290	North High		Regular School	No	High	09	12	2021	grade_12	256	256
2346476	WI	Waukesha	school	5515780	6174	Public school	Waukesha	551578003380	470	eAchieve Academy - Wisconsin	charter	Regular School	Yes	High	06	12	2021	grade_12	189	189
2346441	WI	Jefferson	school	5515750	6125	Public school	Watertown Unified	551575002002	140	Watertown High		Regular School	No	High	09	12	2021	grade_12	292	292
2346409	WI	Jefferson	school	5515750	6125	Public school	Watertown Unified	551575002981	430	Endeavor Charter School	charter	Regular School	Yes	High	09	12	2021	grade_12	7	7
2346395	WI	Jefferson	school	5515750	6125	Public school	Watertown Unified	551575003127	800	eCampus Academy Charter School	charter	Regular School	Yes	Other	PK	12	2021	grade_12	11	11
2346376	WI	Jefferson	school	5515720	6118	Public school	Waterloo	551572001995	40	Waterloo High		Regular School	No	High	09	12	2021	grade_12	56	56
2346356	WI	Racine	school	5515600	6083	Public school	Waterford UHS	551560001988	20	Waterford High		Regular School	No	High	09	12	2021	grade_12	245	245
2346351	WI	Racine	school		6083	Public Schools-Multidistrict Charters	Waterford UHS		9803	JEDI Virtual K-12	charter						2021	grade_12	25	25
2346295	WI	Door	school	5515570	6069	Public school	Washington	551557001987	40	Washington Island High		Regular School	No	High	09	12	2021	grade_12	7	7
2346276	WI	Bayfield	school	5515540	6027	Public school	Washburn	551554001985	40	Washburn High		Regular School	No	High	09	12	2021	grade_12	39	39
2346247	WI	Forest	school	5515390	5992	Public school	Wabeno Area	551539001979	80	Wabeno High		Regular School	No	High	06	12	2021	grade_12	23	23
2346229	WI	Vernon	school	5515360	5985	Public school	Viroqua Area	551536001976	220	Viroqua High		Regular School	No	High	09	12	2021	grade_12	80	80
2346208	WI	Vernon	school	5515360	5985	Public school	Viroqua Area	551536002513	9407	Vernon County Area Better Futures High	charter	Regular School	Yes	High	10	12	2021	grade_12	3	3
2346189	WI	Dane	school	5515330	5901	Public school	Verona Area	551533001972	100	Verona Area High		Regular School	No	High	09	12	2021	grade_12	390	390
2346153	WI	Dane	school	5515330	5901	Public school	Verona Area	551533002919	410	Exploration Academy	charter	Regular School	Yes	High	09	12	2021	grade_12	6	6
2346122	WI	Manitowoc	school	5515210	5866	Public school	Valders Area	551521001967	60	Valders High		Regular School	No	High	09	12	2021	grade_12	71	71
2346104	WI	Polk	school	5500750	238	Public school	Unity	550075000098	100	Unity High		Regular School	No	High	09	12	2021	grade_12	74	74
2346087	WI	Racine	school	5515150	5852	Public school	Union Grove UHS	551515001963	20	Union Grove High		Regular School	No	High	09	12	2021	grade_12	250	250
2346070	WI	Manitowoc	school	5515120	5824	Public school	Two Rivers Public	551512001962	80	Two Rivers High		Regular School	No	High	09	12	2021	grade_12	106	106
2346049	WI	Manitowoc	school	5515120	5824	Public school	Two Rivers Public	551512003037	810	Lighthouse Learning Academy	charter	Regular School	Yes	Other	PK	12	2021	grade_12	5	5
2346015	WI	Barron	school	5515060	5810	Public school	Turtle Lake	551506001956	40	Turtle Lake High		Regular School	No	High	09	12	2021	grade_12	22	22
2346002	WI	Barron	school		5810	Public Schools-Multidistrict Charters	Turtle Lake		9410	North Star Academy	charter						2021	grade_12	1	1
2345980	WI	Waushara	school	5511820	4375	Public school	Tri-County Area	551182001548	60	Tri-County High		Regular School	No	High	09	12	2021	grade_12	39	39
2345928	WI	Portage	school	5500330	126	Public school	Tomorrow River	550033000033	60	Amherst High		Regular School	No	High	09	12	2021	grade_12	91	91
2345911	WI	Lincoln	school	5514940	5754	Public school	Tomahawk	551494001947	200	Tomahawk High		Regular School	No	High	09	12	2021	grade_12	82	82
2345878	WI	Monroe	school	5514910	5747	Public school	Tomah Area	551491001939	180	Tomah High		Regular School	No	High	09	12	2021	grade_12	195	195
2345857	WI	Monroe	school		5747	Public Schools-Multidistrict Charters	Tomah Area		9100	Rural Virtual Academy	charter						2021	grade_12	4	4
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
2345811	WI	Shawano	school	5514880	5740	Public school	Tigerton	551488001932	40	Tigerton High		Regular School	No	High	06	12	2021	grade_12	14	14
2345794	WI	Oneida	school	5514850	5733	Public school	Three Lakes	551485001929	80	Three Lakes High		Regular School	No	High	09	12	2021	grade_12	33	33
2345770	WI	Clark	school	5514820	5726	Public school	Thorp	551482001926	40	Thorp High		Regular School	No	High	09	12	2021	grade_12	41	41
2345745	WI	Clark	school		5726	Public Schools-Multidistrict Charters	Thorp		9100	Rural Virtual Academy	charter						2021	grade_12	1	1
2345729	WI	Oconto	school	5514700	5670	Public school	Suring Public	551470001922	80	Suring High		Regular School	No	High	09	12	2021	grade_12	29	29
2345708	WI	Douglas	school	5514670	5663	Public school	Superior	551467001918	280	Superior High		Regular School	No	High	09	12	2021	grade_12	311	311
2345632	WI	Dane	school	5514640	5656	Public school	Sun Prairie Area	551464001902	100	Sun Prairie High		Regular School	No	High	10	12	2021	grade_12	585	585
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
2345587	WI	Dane	school		5656	Public Schools-Multidistrict Charters	Sun Prairie Area		9803	JEDI Virtual K-12	charter						2021	grade_12	6	6
2345535	WI	Door	school	5514610	5642	Public school	Sturgeon Bay	551461001894	10	Sturgeon Bay High		Regular School	No	High	09	12	2021	grade_12	96	96
2345523	WI	Marathon	school	5514580	5628	Public school	Stratford	551458001891	40	Stratford High		Regular School	No	High	09	12	2021	grade_12	84	84
2345498	WI	Dane	school	5514550	5621	Public school	Stoughton Area	551455001886	140	Stoughton High		Regular School	No	High	09	12	2021	grade_12	211	211
2345469	WI	Dane	school		5621	Public Schools-Multidistrict Charters	Stoughton Area		9803	JEDI Virtual K-12	charter						2021	grade_12	6	6
2345441	WI	Calumet	school	5514520	5614	Public school	Stockbridge	551452001883	40	Stockbridge High		Regular School	No	High	09	12	2021	grade_12	18	18
2345421	WI	Portage	school	5514490	5607	Public school	Stevens Point Area Public	551449001880	270	Stevens Point Area Senior High		Regular School	No	High	10	12	2021	grade_12	456	456
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