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 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
3088667	WI	Clark	school		7	Public Schools-Multidistrict Charters	Abbotsford		9100	Rural Virtual Academy	charter						2018	grade_6	1	1
3089805	WI	Washburn	school	5501170	441	Public school	Birchwood	550117003020	800	Bobcat Virtual Academy	charter	Regular School	Yes	Other	PK	12	2018	grade_6	1	1
3090819	WI	Barron	school	5503090	1260	Public school	Cumberland	550309002871	800	Island City Virtual Academy	charter	Regular School	Yes	Other	PK	12	2018	grade_6	1	1
3091641	WI	Rock	school		1694	Public Schools-Multidistrict Charters	Evansville Community		9803	JEDI Virtual K-12	charter						2018	grade_6	1	1
3095170	WI	Juneau	school		3360	Public Schools-Multidistrict Charters	Mauston		9803	JEDI Virtual K-12	charter						2018	grade_6	1	1
3099264	WI	Racine	school	5512360	4620	Public school	Racine Unified	551236001608	106	Fine Arts Elementary		Regular School	No	Elementary	KG	05	2018	grade_6	1	1
3099348	WI	Racine	school	5512360	4620	Public school	Racine Unified	551236001626	136	Johnson Elementary		Regular School	No	Elementary	PK	05	2018	grade_6	1	1
3099365	WI	Racine	school	5512360	4620	Public school	Racine Unified	551236003337	720	Julian Thomas Elementary		Regular School	No	Elementary	PK	05	2018	grade_6	1	1
3099443	WI	Racine	school	5512360	4620	Public school	Racine Unified	551236001637	154	Roosevelt Elementary		Regular School	No	Elementary	PK	05	2018	grade_6	1	1
3099671	WI	Taylor	school		4795	Public Schools-Multidistrict Charters	Rib Lake		9100	Rural Virtual Academy	charter						2018	grade_6	1	1
3099758	WI	Richland	school	5512960	4851	Public school	Richland	551296002998	450	Richland Online Academy	charter	Regular School	Yes	High	06	12	2018	grade_6	1	1
3100780	WI	Marathon	school		5467	Public Schools-Multidistrict Charters	Spencer		9100	Rural Virtual Academy	charter						2018	grade_6	1	1
3101108	WI	Dane	school		5656	Public Schools-Multidistrict Charters	Sun Prairie Area		9803	JEDI Virtual K-12	charter						2018	grade_6	1	1
3101437	WI	Portage	school	5500330	126	Public school	Tomorrow River	550033003063	140	Tomorrow River Virtual Charter School (TRVCS)	charter	Regular School	Yes	Elementary	PK	06	2018	grade_6	1	1
3102710	WI	Brown	school	5516320	6328	Public school	West De Pere	551632002726	150	Hemlock Creek Elementary		Regular School	No	Elementary	PK	05	2018	grade_6	1	1
3102881	WI	Langlade	school		6440	Public Schools-Multidistrict Charters	White Lake		9100	Rural Virtual Academy	charter						2018	grade_6	1	1
3090832	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	2018	grade_6	10	10
3091142	WI	Racine	school	5503750	1449	Public school	Dover #1	550375000394	20	Kansasville Elementary		Regular School	No	Elementary	PK	08	2018	grade_6	10	10
3098110	WI	Vilas	school	5503860	1526	Public school	Northland Pines	550386002938	250	School of Options & Applied Research Middle	charter	Regular School	Yes	Middle	05	08	2018	grade_6	10	10
3102889	WI	Langlade	school	5516590	6440	Public school	White Lake	551659002164	20	White Lake Elementary		Regular School	No	Elementary	PK	06	2018	grade_6	10	10
3096548	WI	Milwaukee	school	5509600	3619	Public school	Milwaukee	550960001209	256	Longfellow Elementary		Regular School	No	Elementary	PK	08	2018	grade_6	100	100
3096944	WI	Milwaukee	school	5509600	3619	Public school	Milwaukee	550960001238	59	Roosevelt Middle		Regular School	No	Middle	06	08	2018	grade_6	100	100
3101402	WI	Lincoln	school	5514940	5754	Public school	Tomahawk	551494001948	220	Tomahawk Middle		Regular School	No	Middle	06	08	2018	grade_6	100	100
3102052	WI	Waukesha	school	5515780	6174	Public school	Waukesha	551578002023	400	Waukesha STEM Academy	charter	Regular School	Yes	Elementary	PK	08	2018	grade_6	100	100
3094473	WI	Columbia	school	5508190	3150	Public school	Lodi	550819000906	100	Lodi Middle		Regular School	No	Middle	06	08	2018	grade_6	101	101
3098600	WI	Winnebago	school	5511190	4179	Public school	Oshkosh Area	551119001497	320	Tipler Middle		Regular School	No	Middle	06	08	2018	grade_6	101	101
3088684	WI	Adams	school	5500060	14	Public school	Adams-Friendship Area	550006001454	210	Adams-Friendship Middle		Regular School	No	Middle	06	08	2018	grade_6	102	102
3099182	WI	Pierce	school	5512240	4578	Public school	Prescott	551224001593	80	Prescott Middle		Regular School	No	Middle	06	08	2018	grade_6	102	102
3094457	WI	Outagamie	school	5508160	3129	Public school	Little Chute Area	550816002858	100	Little Chute Intermediate		Regular School	No	Middle	05	06	2018	grade_6	103	103
3095602	WI	Waukesha	school	5509360	3528	Public school	Merton Community	550936002269	20	Merton Intermediate		Regular School	No	Middle	05	08	2018	grade_6	103	103
3101066	WI	Door	school	5514610	5642	Public school	Sturgeon Bay	551461002322	80	Walker Middle		Regular School	No	Middle	06	08	2018	grade_6	103	103
3091996	WI	Outagamie	school	5504920	1953	Public school	Freedom Area	550492000534	40	Freedom Middle		Regular School	No	Middle	06	08	2018	grade_6	105	105
3095107	WI	Wood	school	5508820	3339	Public school	Marshfield Unified	550882001016	40	Grant Elementary		Regular School	No	Elementary	PK	06	2018	grade_6	105	105
3094133	WI	La Crosse	school	5507530	2849	Public school	La Crosse	550753000863	180	Lincoln Middle		Regular School	No	Middle	06	08	2018	grade_6	106	106
3096809	WI	Milwaukee	school	5509600	3619	Public school	Milwaukee	550960001221	52	Morse Mid		Regular School	No	Middle	06	08	2018	grade_6	109	109
3097988	WI	Fond du Lac	school	5510740	3983	Public school	North Fond du Lac	551074001396	20	Bessie Allen Middle		Regular School	No	Middle	06	08	2018	grade_6	109	109
3100044	WI	Saint Croix	school	5506060	2422	Public school	Saint Croix Central	550606000673	80	Saint Croix Central Middle		Regular School	No	Middle	05	08	2018	grade_6	109	109
3089229	WI	Ashland	school	5500510	170	Public school	Ashland	550051002986	250	Oredocker Project School	charter	Regular School	Yes	Middle	06	08	2018	grade_6	11	11
3089868	WI	Trempealeau	school	5500016	485	Public school	Blair-Taylor	550001603359	120	SoSET Charter School	charter	Regular School	Yes	Elementary	KG	06	2018	grade_6	11	11
3091475	WI	Walworth	school	5504290	1638	Public school	Elkhorn Area	550429003038	800	Elkhorn Options Virtual School	charter	Regular School	Yes	Other	PK	12	2018	grade_6	11	11
3092178	WI	Buffalo	school	5505370	2142	Public school	Gilmanton	550537002907	250	Gilmanton Middle		Regular School	No	Middle	05	08	2018	grade_6	11	11
3098161	WI	Racine	school	5510800	4011	Public school	Norway J7	551080001405	20	Drought Elementary		Regular School	No	Elementary	PK	08	2018	grade_6	11	11
3090062	WI	Milwaukee	school	5500059	8123	Non District Charter Schools	Bruce Guadalupe	550005900772	100	Bruce Guadalupe	charter	Regular School	Yes	Elementary	PK	08	2018	grade_6	110	110
3091089	WI	Brown	school	5503660	1407	Public school	Denmark	550366000389	100	Denmark Middle		Regular School	No	Middle	06	08	2018	grade_6	111	111
3089604	WI	Rock	school	5501050	413	Public school	Beloit	550105000137	20	Aldrich Intermediate		Regular School	No	Middle	04	08	2018	grade_6	112	112
3102630	WI	Milwaukee	school	5516260	6300	Public school	West Allis-West Milwaukee	551626002106	120	West Milwaukee Intermediate		Regular School	No	Middle	06	08	2018	grade_6	112	112
3088807	WI	Eau Claire	school	5500270	112	Public school	Altoona	550027000027	60	Altoona Middle		Regular School	No	Middle	06	08	2018	grade_6	113	113
3092834	WI	Waukesha	school	5506140	2460	Public school	Hartland-Lakeside J3	550614001282	100	North Shore Middle		Regular School	No	Middle	06	08	2018	grade_6	113	113
3100090	WI	Kenosha	school	5513350	5068	Public school	Salem	551335001753	20	Salem Elementary		Regular School	No	Elementary	PK	08	2018	grade_6	113	113
3095196	WI	Juneau	school	5508850	3360	Public school	Mauston	550885001026	20	Olson Middle		Regular School	No	Middle	06	08	2018	grade_6	114	114
3088820	WI	Polk	school	5500300	119	Public school	Amery	550030000031	60	Amery Middle		Regular School	No	Middle	06	08	2018	grade_6	115	115
3100615	WI	Saint Croix	school	5514010	5432	Public school	Somerset	551401001108	60	Somerset Middle		Regular School	No	Middle	05	08	2018	grade_6	115	115
3091199	WI	Walworth	school	5504020	1540	Public school	East Troy Community	550402000411	60	East Troy Middle		Regular School	No	Middle	06	08	2018	grade_6	116	116
3093949	WI	Washington	school	5507380	2800	Public school	Kewaskum	550738000838	90	Kewaskum Middle		Regular School	No	Middle	06	08	2018	grade_6	117	117
3098894	WI	Grant	school	5511850	4389	Public school	Platteville	551185001554	80	Platteville Middle		Regular School	No	Middle	05	08	2018	grade_6	117	117
3091429	WI	Dunn	school	5504230	1645	Public school	Elk Mound Area	550423000452	20	Elk Mound Middle		Regular School	No	Middle	05	08	2018	grade_6	118	118
3100220	WI	Outagamie	school	5513530	5138	Public school	Seymour Community	551353001772	80	Seymour Middle		Regular School	No	Middle	06	08	2018	grade_6	118	118
3095501	WI	Ozaukee	school	5509130	3479	Public school	Mequon-Thiensville	550913001086	80	Lake Shore Middle		Regular School	No	Middle	06	08	2018	grade_6	119	119
3098498	WI	Winnebago	school	5511190	4179	Public school	Oshkosh Area	551119003364	170	Accelerated Advanced Learning Program	charter	Regular School	Yes	Middle	04	08	2018	grade_6	12	12
3101429	WI	Portage	school	5500330	126	Public school	Tomorrow River	550033002968	100	Tomorrow River Community Charter	charter	Regular School	Yes	Elementary	PK	06	2018	grade_6	12	12
3091527	WI	Pierce	school	5504320	1659	Public school	Ellsworth Community	550432000463	20	Ellsworth Middle		Regular School	No	Middle	06	08	2018	grade_6	120	120
3089832	WI	Jackson	school	5501260	476	Public school	Black River Falls	550126000174	60	Black River Falls Middle		Regular School	No	Middle	06	08	2018	grade_6	121	121
3093038	WI	Outagamie	school	5506600	2583	Public school	Hortonville Area	550660002408	30	Hortonville Middle		Regular School	No	Middle	05	08	2018	grade_6	121	121
3096718	WI	Milwaukee	school	5509600	3619	Public school	Milwaukee	550960003036	885	Milwaukee Excellence Charter School	charter	Regular School	Yes	High	06	12	2018	grade_6	121	121
3101506	WI	Manitowoc	school	5515120	5824	Public school	Two Rivers Public	551512001960	50	Clarke Middle		Regular School	No	Middle	05	08	2018	grade_6	121	121
3090027	WI	Milwaukee	school	5501800	721	Public school	Brown Deer	550180000232	80	Brown Deer Elementary		Regular School	No	Elementary	PK	06	2018	grade_6	122	122
3092184	WI	Milwaukee	school	5505460	2184	Public school	Glendale-River Hills	550546000575	10	Glen Hills Middle		Regular School	No	Middle	04	08	2018	grade_6	122	122
3098492	WI	Polk	school	5511160	4165	Public school	Osceola	551116002319	80	Osceola Middle		Regular School	No	Middle	06	08	2018	grade_6	122	122
3102148	WI	Fond du Lac	school	5515870	6216	Public school	Waupun	551587002809	110	Rock River Intermediate		Regular School	No	Elementary	02	06	2018	grade_6	122	122
3089336	WI	Saint Croix	school	5500720	231	Public school	Baldwin-Woodville Area	550072000096	90	Viking Middle		Regular School	No	Middle	06	08	2018	grade_6	123	123
3089718	WI	Rock	school	5501080	422	Public school	Beloit Turner	550108000159	120	Turner Middle		Regular School	No	Middle	06	08	2018	grade_6	123	123
3103073	WI	Winnebago	school	5516830	6608	Public school	Winneconne Community	551683002192	80	Winneconne Middle		Regular School	No	Middle	06	08	2018	grade_6	123	123
3089639	WI	Rock	school	5501050	413	Public school	Beloit	550105000140	80	Cunningham Intermediate		Regular School	No	Middle	04	08	2018	grade_6	125	125
3091378	WI	Rock	school	5504110	1568	Public school	Edgerton	550411000444	60	Edgerton Middle		Regular School	No	Middle	06	08	2018	grade_6	125	125
3094553	WI	Kewaunee	school	5508340	3220	Public school	Luxemburg-Casco	550834000916	100	Luxemburg-Casco Intermediate		Regular School	No	Elementary	03	06	2018	grade_6	125	125
3089665	WI	Rock	school	5501050	413	Public school	Beloit	550105002330	180	McNeel Intermediate		Regular School	No	Middle	04	08	2018	grade_6	127	127
3088744	WI	Buffalo	school	5500180	84	Public school	Alma	550018000017	20	Alma Elementary		Regular School	No	Elementary	PK	08	2018	grade_6	13	13
3089727	WI	Lafayette	school	5501110	427	Public school	Benton	550111000160	20	Benton Elementary		Regular School	No	Elementary	PK	06	2018	grade_6	13	13
3090123	WI	Ashland	school	5501920	840	Public school	Butternut	550192000246	40	Butternut High		Regular School	No	High	06	12	2018	grade_6	13	13
3090279	WI	Grant	school	5502400	994	Public school	Cassville	550240000264	20	Cassville Elementary		Regular School	No	Elementary	PK	06	2018	grade_6	13	13
3101303	WI	Shawano	school	5514880	5740	Public school	Tigerton	551488001932	40	Tigerton High		Regular School	No	High	06	12	2018	grade_6	13	13
3089745	WI	Green Lake	school	5501140	434	Public school	Berlin Area	550114000164	80	Berlin Middle		Regular School	No	Middle	06	08	2018	grade_6	131	131
3098633	WI	Winnebago	school	5511190	4179	Public school	Oshkosh Area	551119001504	500	Webster Stanley Middle		Regular School	No	Middle	06	08	2018	grade_6	131	131
3102135	WI	Waupaca	school	5515840	6195	Public school	Waupaca	551584002036	150	Waupaca Middle		Regular School	No	Middle	05	08	2018	grade_6	131	131
3102978	WI	Walworth	school	5516680	6461	Public school	Whitewater Unified	551668002178	20	Whitewater Middle		Regular School	No	Middle	06	08	2018	grade_6	131	131
3091632	WI	Rock	school	5504440	1694	Public school	Evansville Community	550444000479	60	J C McKenna Middle		Regular School	No	Middle	06	08	2018	grade_6	132	132
3092245	WI	Ozaukee	school	5505610	2217	Public school	Grafton	550561002249	60	John Long Middle		Regular School	No	Middle	06	08	2018	grade_6	132	132
3100435	WI	Sheboygan	school	5513680	5278	Public school	Sheboygan Falls	551368002289	60	Sheboygan Falls Middle		Regular School	No	Middle	05	08	2018	grade_6	132	132
3092868	WI	Sawyer	school	5506270	2478	Public school	Hayward Community	550627000691	60	Hayward Middle		Regular School	No	Middle	06	08	2018	grade_6	133	133
3094345	WI	Jefferson	school	5507710	2898	Public school	Lake Mills Area	550771000888	60	Lake Mills Middle		Regular School	No	Middle	05	08	2018	grade_6	134	134
3098338	WI	Oconto	school	5510950	4074	Public school	Oconto Falls Public	551095001438	260	Washington Middle		Regular School	No	Middle	06	08	2018	grade_6	135	135
3100250	WI	Shawano	school	5513620	5264	Public school	Shawano	551362001775	70	Shawano Community Middle		Regular School	No	Middle	06	08	2018	grade_6	135	135
3094880	WI	Dane	school	5508520	3269	Public school	Madison Metropolitan	550852000934	315	Whitehorse Middle		Regular School	No	Middle	06	08	2018	grade_6	137	137
3091052	WI	Walworth	school	5503640	1380	Public school	Delavan-Darien	550364002241	60	Phoenix Middle		Regular School	No	Middle	06	08	2018	grade_6	138	138
3096624	WI	Milwaukee	school	5509600	3619	Public school	Milwaukee	550960001164	176	Meir School		Regular School	No	Other	03	12	2018	grade_6	138	138
3096286	WI	Milwaukee	school	5509600	3619	Public school	Milwaukee	550960002979	880	HAPA-Hmong American Peace Academy K3-12	charter	Regular School	Yes	Other	PK	12	2018	grade_6	139	139
3098596	WI	Winnebago	school	5511190	4179	Public school	Oshkosh Area	551119001501	440	South Park Middle		Regular School	No	Middle	06	08	2018	grade_6	139	139
3092722	WI	Clark	school	5505970	2394	Public school	Greenwood	550597000656	40	Greenwood Elementary		Regular School	No	Elementary	PK	06	2018	grade_6	14	14
3097964	WI	Racine	school	5512510	4690	Public school	North Cape	551251001657	20	North Cape Elementary		Regular School	No	Elementary	PK	08	2018	grade_6	14	14
3101269	WI	Oneida	school	5514850	5733	Public school	Three Lakes	551485001927	40	Sugar Camp Elementary		Regular School	No	Elementary	PK	06	2018	grade_6	14	14
3102155	WI	Fond du Lac	school	5515870	6216	Public school	Waupun	551587002903	150	School for Agricultural and Environmental Studies	charter	Regular School	Yes	Elementary	PK	06	2018	grade_6	14	14