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
112504	WI	Barron	school	5500870	308	Public school	Barron Area	550087002864	810	Advanced Learning Academy of Wisconsin	charter	Regular School	Yes	4.0	KG	12	2015	grade_1	1	1
112577	WI	Bayfield	school	5500900	315	Public school	Bayfield	550090002358	60	La Pointe Elementary		Regular School	No	1.0	PK	06	2015	grade_1	1	1
112710	WI	Rock	school	5501050	413	Public school	Beloit	550105002799	850	Beloit Virtual School		Regular School	No	4.0	PK	12	2015	grade_1	1	1
115420	WI	Brown	school	5505820	2289	Public school	Green Bay Area Public	550582003009	800	Dr Rosa Minoka-Hill School		Alternative Education School	No	4.0	PK	12	2015	grade_1	1	1
116332	WI	Rock	school	5507020	2695	Public school	Janesville	550702002991	860	ARISE Virtual Academy	charter	Regular School	Yes	4.0	KG	12	2015	grade_1	1	1
118670	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_1	1	1
120477	WI	Marquette	school	5509870	3689	Public school	Montello	550987003016	800	Montello Virtual Charter School	charter	Regular School	Yes	4.0	KG	12	2015	grade_1	1	1
120520	WI	Marathon	school		3787	Public Schools-Multidistrict Charters	Mosinee		9100	Rural Virtual Academy	charter						2015	grade_1	1	1
122180	WI	Crawford	school	5512150	4543	Public school	Prairie du Chien Area	551215002944	800	Mighty River Academy of Virtual Education	charter	Regular School	Yes	4.0	KG	12	2015	grade_1	1	1
122742	WI	Taylor	school		4795	Public Schools-Multidistrict Charters	Rib Lake		9100	Rural Virtual Academy	charter						2015	grade_1	1	1
123874	WI	Marathon	school		5467	Public Schools-Multidistrict Charters	Spencer		9100	Rural Virtual Academy	charter						2015	grade_1	1	1
124104	WI	Dane	school		5621	Public Schools-Multidistrict Charters	Stoughton Area		9803	JEDI Virtual K-12	charter						2015	grade_1	1	1
112082	WI	Outagamie	school	5500390	147	Public school	Appleton Area	550039002582	135	Fox River Academy	charter	Regular School	Yes	1.0	01	08	2015	grade_1	10	10
112525	WI	Barron	school	5500870	308	Public school	Barron Area	550087002717	100	Barron Area Montessori School	charter	Regular School	Yes	1.0	PK	04	2015	grade_1	10	10
112540	WI	Barron	school	5500870	308	Public school	Barron Area	550087000117	120	Ridgeland-Dallas Elementary		Regular School	No	1.0	PK	04	2015	grade_1	10	10
113250	WI	Barron	school	5502130	903	Public school	Cameron	550213002851	800	Cameron Academy of Virtual Education	charter	Alternative Education School	Yes	4.0	KG	12	2015	grade_1	10	10
113340	WI	Grant	school	5502400	994	Public school	Cassville	550240000264	20	Cassville Elementary		Regular School	No	1.0	PK	06	2015	grade_1	10	10
117050	WI	Manitowoc	school	5507440	2828	Public school	Kiel Area	550744002593	110	Meeme LEADS Charter	charter	Regular School	Yes	1.0	PK	02	2015	grade_1	10	10
118585	WI	Iron	school	5509150	3484	Public school	Mercer	550915001092	40	Mercer School		Regular School	No	4.0	PK	12	2015	grade_1	10	10
124846	WI	Door	school	5515570	6069	Public school	Washington	551557001986	20	Washington Island Elementary		Regular School	No	1.0	PK	08	2015	grade_1	10	10
125935	WI	Langlade	school	5516590	6440	Public school	White Lake	551659002164	20	White Lake Elementary		Regular School	No	1.0	PK	06	2015	grade_1	10	10
112945	WI	Chippewa	school	5501350	497	Public school	Bloomer	550135000183	20	Bloomer Elementary		Regular School	No	1.0	PK	04	2015	grade_1	100	100
117087	WI	Outagamie	school	5507470	2835	Public school	Kimberly Area	550747000732	60	Sunrise Elementary		Regular School	No	1.0	PK	04	2015	grade_1	100	100
119956	WI	Milwaukee	school	5509600	3619	Public school	Milwaukee	550960001236	313	Riley Elementary		Regular School	No	1.0	PK	05	2015	grade_1	100	100
120654	WI	Waukesha	school	5510170	3857	Public school	Muskego-Norway	551017001336	220	Tess Corners Elementary		Regular School	No	1.0	PK	04	2015	grade_1	100	100
122540	WI	Racine	school	5512360	4620	Public school	Racine Unified	551236001642	162	Wadewitz Elementary		Regular School	No	1.0	PK	05	2015	grade_1	100	100
125616	WI	Milwaukee	school	5516260	6300	Public school	West Allis-West Milwaukee	551626002108	160	Jefferson Elementary		Regular School	No	1.0	PK	05	2015	grade_1	100	100
117516	WI	Columbia	school	5508190	3150	Public school	Lodi	550819000904	40	Lodi Elementary		Regular School	No	1.0	01	05	2015	grade_1	101	101
118177	WI	Wood	school	5508820	3339	Public school	Marshfield Unified	550882001016	40	Grant Elementary		Regular School	No	1.0	KG	06	2015	grade_1	101	101
119766	WI	Milwaukee	school	5509600	3619	Public school	Milwaukee	550960002340	140	Milwaukee French Immersion		Regular School	No	1.0	PK	05	2015	grade_1	101	101
124198	WI	Dane	school	5514640	5656	Public school	Sun Prairie Area	551464001899	40	Eastside Elementary		Regular School	No	1.0	PK	05	2015	grade_1	101	101
112126	WI	Outagamie	school	5500390	147	Public school	Appleton Area	550039000056	200	Huntley Elementary		Regular School	No	1.0	PK	06	2015	grade_1	102	102
116781	WI	Kenosha	school	5507320	2793	Public school	Kenosha	550732002653	170	Nash Elementary		Regular School	No	1.0	PK	05	2015	grade_1	102	102
121003	WI	Saint Croix	school	5510620	3962	Public school	New Richmond	551062002789	170	New Richmond Hillside Elementary		Regular School	No	1.0	KG	05	2015	grade_1	102	102
122395	WI	Racine	school	5512360	4620	Public school	Racine Unified	551236001623	132	Jefferson Lighthouse Elementary		Regular School	No	1.0	KG	05	2015	grade_1	102	102
114018	WI	Brown	school	5503210	1414	Public school	De Pere	550321001254	50	Heritage Elementary		Regular School	No	1.0	PK	04	2015	grade_1	103	103
115584	WI	Brown	school	5505820	2289	Public school	Green Bay Area Public	550582002431	437	McAuliffe Elementary		Regular School	No	1.0	PK	05	2015	grade_1	103	103
115814	WI	Waukesha	school	5506030	2420	Public school	Hamilton	550603000667	120	Marcy Elementary		Regular School	No	1.0	KG	05	2015	grade_1	103	103
125735	WI	Washington	school	5516290	6307	Public school	West Bend	551629002132	100	McLane Elementary		Regular School	No	1.0	PK	04	2015	grade_1	103	103
126108	WI	Winnebago	school	5516830	6608	Public school	Winneconne Community	551683002190	40	Winneconne Elementary		Regular School	No	1.0	PK	05	2015	grade_1	103	103
124206	WI	Dane	school	5514640	5656	Public school	Sun Prairie Area	551464002624	150	Horizon Elementary School		Regular School	No	1.0	PK	05	2015	grade_1	104	104
112832	WI	Green Lake	school	5501140	434	Public school	Berlin Area	550114000163	60	Clay Lamberton Elementary		Regular School	No	1.0	PK	05	2015	grade_1	105	105
125951	WI	Milwaukee	school	5516620	6419	Public school	Whitefish Bay	551662002166	20	Cumberland Elementary		Regular School	No	1.0	PK	05	2015	grade_1	105	105
115828	WI	Waukesha	school	5506030	2420	Public school	Hamilton	550603001676	150	Woodside Elementary		Regular School	No	1.0	KG	05	2015	grade_1	106	106
113988	WI	Dane	school	5503180	1316	Public school	De Forest Area	550318000360	140	Windsor Elementary		Regular School	No	1.0	KG	04	2015	grade_1	107	107
123513	WI	Sheboygan	school	5513650	5271	Public school	Sheboygan Area	551365001800	400	Wilson Elementary		Regular School	No	1.0	PK	05	2015	grade_1	107	107
114126	WI	Brown	school	5503660	1407	Public school	Denmark	550366000387	60	Denmark Elementary		Regular School	No	1.0	01	05	2015	grade_1	108	108
114581	WI	Waukesha	school	5501770	714	Public school	Elmbrook	550177000218	80	Burleigh Elementary		Regular School	No	1.0	PK	05	2015	grade_1	108	108
118820	WI	Milwaukee	school	5509600	3619	Public school	Milwaukee	550960001122	73	Allen-Field Elementary		Regular School	No	1.0	PK	05	2015	grade_1	109	109
120502	WI	Marathon	school	5509960	3787	Public school	Mosinee	550996001307	80	Mosinee Elementary		Regular School	No	1.0	PK	03	2015	grade_1	109	109
125796	WI	La Crosse	school	5516350	6370	Public school	West Salem	551635002140	60	West Salem Elementary		Regular School	No	1.0	PK	05	2015	grade_1	109	109
112518	WI	Barron	school	5500870	308	Public school	Barron Area	550087000113	20	Almena Elementary		Regular School	No	1.0	PK	04	2015	grade_1	11	11
115209	WI	Buffalo	school	5505370	2142	Public school	Gilmanton	550537000573	40	Gilmanton Elementary		Regular School	No	1.0	PK	04	2015	grade_1	11	11
117461	WI	Walworth	school	5508040	3087	Public school	Linn J4	550804000898	20	Traver Elementary		Regular School	No	1.0	PK	08	2015	grade_1	11	11
121913	WI	Vilas	school	5511710	4330	Public school	Phelps	551171001539	10	Phelps Elementary		Regular School	No	1.0	PK	08	2015	grade_1	11	11
123189	WI	Kenosha	school	5513350	5068	Public school	Salem	551335001753	20	Salem Elementary		Regular School	No	1.0	PK	08	2015	grade_1	110	110
115444	WI	Brown	school	5505820	2289	Public school	Green Bay Area Public	550582000620	200	Eisenhower Elementary		Regular School	No	1.0	PK	05	2015	grade_1	111	111
117688	WI	Dane	school	5508520	3269	Public school	Madison Metropolitan	550852000930	240	Franklin Elementary		Regular School	No	1.0	PK	02	2015	grade_1	111	111
112781	WI	Rock	school	5501050	413	Public school	Beloit	550105000153	320	Todd Elementary		Regular School	No	1.0	PK	03	2015	grade_1	112	112
114416	WI	Rock	school	5504110	1568	Public school	Edgerton	550411000442	40	Edgerton Community Elementary		Regular School	No	1.0	PK	05	2015	grade_1	112	112
116134	WI	Brown	school	5506630	2604	Public school	Howard-Suamico	550663000718	50	Meadowbrook Elementary		Regular School	No	1.0	PK	04	2015	grade_1	113	113
117386	WI	Jefferson	school	5507710	2898	Public school	Lake Mills Area	550771000889	100	Lake Mills Elementary		Regular School	No	1.0	PK	04	2015	grade_1	113	113
116545	WI	Outagamie	school	5507290	2758	Public school	Kaukauna Area	550729002433	50	Dr H B Tanner Elementary		Regular School	No	1.0	PK	01	2015	grade_1	114	114
121550	WI	Dane	school	5511100	4144	Public school	Oregon	551110001472	50	Prairie View Elementary		Regular School	No	1.0	PK	04	2015	grade_1	114	114
125161	WI	Dane	school	5515810	6181	Public school	Waunakee Community	551581001198	100	Waunakee Prairie Elementary		Regular School	No	1.0	PK	04	2015	grade_1	114	114
125787	WI	Brown	school	5516320	6328	Public school	West De Pere	551632002139	140	Westwood Elementary		Regular School	No	1.0	PK	05	2015	grade_1	114	114
121878	WI	Marinette	school	5511610	4305	Public school	Peshtigo	551161001533	80	Peshtigo Elementary		Regular School	No	1.0	PK	06	2015	grade_1	115	115
123134	WI	Saint Croix	school	5506060	2422	Public school	Saint Croix Central	550606000671	40	Saint Croix Central Elementary		Regular School	No	1.0	PK	04	2015	grade_1	115	115
119341	WI	Milwaukee	school	5509600	3619	Public school	Milwaukee	550960002979	880	HAPA-Hmong Amer Peace Academy K3-12	charter	Regular School	Yes	4.0	PK	12	2015	grade_1	116	116
115620	WI	Brown	school	5505820	2289	Public school	Green Bay Area Public	550582000639	590	Sullivan Elementary		Regular School	No	1.0	PK	05	2015	grade_1	117	117
118733	WI	Dane	school	5509510	3549	Public school	Middleton-Cross Plains Area	550951000755	150	Sunset Ridge Elementary		Regular School	No	1.0	PK	04	2015	grade_1	117	117
125194	WI	Fond du Lac	school	5515870	6216	Public school	Waupun	551587002044	160	Meadow View Primary		Regular School	No	1.0	PK	01	2015	grade_1	118	118
123520	WI	Sheboygan	school	5513680	5278	Public school	Sheboygan Falls	551368001801	20	Sheboygan Falls Elementary		Regular School	No	1.0	PK	04	2015	grade_1	119	119
113435	WI	Price	school	5500058	1071	Public school	Chequamegon	550005800590	100	Glidden Elementary		Regular School	No	1.0	PK	02	2015	grade_1	12	12
115890	WI	Sawyer	school	5506270	2478	Public school	Hayward Community	550627003339	800	Hayward Ctr for Individualized Learning	charter	Regular School	Yes	4.0	PK	12	2015	grade_1	12	12
117472	WI	Walworth	school	5508070	3094	Public school	Linn J6	550807000899	20	Reek Elementary		Regular School	No	1.0	PK	08	2015	grade_1	12	12
118247	WI	Juneau	school	5508850	3360	Public school	Mauston	550885001024	40	Lyndon Station Elementary		Regular School	No	1.0	KG	05	2015	grade_1	12	12
118629	WI	Lincoln	school	5509210	3500	Public school	Merrill Area	550921002917	110	Maple Grove School	charter	Regular School	Yes	1.0	KG	05	2015	grade_1	12	12
122214	WI	Price	school	5512210	4571	Public school	Prentice	551221001587	20	Ogema Elementary		Regular School	No	1.0	PK	04	2015	grade_1	12	12
123002	WI	Sauk	school	5514250	5523	Public school	River Valley	551425002868	150	River Valley Elementary Studio School	charter	Regular School	Yes	1.0	KG	05	2015	grade_1	12	12
124937	WI	Jefferson	school	5515750	6125	Public school	Watertown Unified	551575001998	60	Lebanon Elementary		Regular School	No	1.0	KG	05	2015	grade_1	12	12
121977	WI	Grant	school	5511850	4389	Public school	Platteville	551185001551	20	Wilkins Elementary		Regular School	No	1.0	PK	01	2015	grade_1	120	120
123701	WI	Saint Croix	school	5514010	5432	Public school	Somerset	551401001824	20	Somerset Elementary		Regular School	No	1.0	PK	04	2015	grade_1	120	120
124309	WI	Douglas	school	5514670	5663	Public school	Superior	551467002539	115	Northern Lights Elementary		Regular School	No	1.0	PK	05	2015	grade_1	120	120
117614	WI	Kewaunee	school	5508340	3220	Public school	Luxemburg-Casco	550834002525	110	Luxemburg-Casco Primary		Regular School	No	1.0	PK	02	2015	grade_1	121	121
117638	WI	Dane	school	5508520	3269	Public school	Madison Metropolitan	550852002483	110	Cesar Chavez Elementary		Regular School	No	1.0	PK	05	2015	grade_1	121	121
119215	WI	Milwaukee	school	5509600	3619	Public school	Milwaukee	550960001163	173	Forest Home Elementary		Regular School	No	1.0	PK	05	2015	grade_1	121	121
123302	WI	Outagamie	school	5513530	5138	Public school	Seymour Community	551353001771	60	Rock Ledge Elementary		Regular School	No	1.0	PK	05	2015	grade_1	122	122
112909	WI	Jackson	school	5501260	476	Public school	Black River Falls	550126000176	80	Forrest Street Early Learning Center		Regular School	No	1.0	PK	01	2015	grade_1	128	128
125182	WI	Waupaca	school	5515840	6195	Public school	Waupaca	551584001203	70	Waupaca Learning Center Elementary		Regular School	No	1.0	PK	04	2015	grade_1	128	128
117771	WI	Dane	school	5508520	3269	Public school	Madison Metropolitan	550852000944	475	Leopold Elementary		Regular School	No	1.0	PK	05	2015	grade_1	129	129
111941	WI	Langlade	school	5500360	140	Public school	Antigo Unified	550036000041	160	Mattoon Elementary		Regular School	No	1.0	PK	05	2015	grade_1	13	13
112264	WI	Lafayette	school	5500450	161	Public school	Argyle	550045000069	20	Argyle Elementary		Regular School	No	1.0	PK	05	2015	grade_1	13	13
113178	WI	Ashland	school	5501920	840	Public school	Butternut	550192000245	20	Butternut Elementary		Regular School	No	1.0	PK	05	2015	grade_1	13	13
115928	WI	Sawyer	school	5506270	2478	Public school	Hayward Community	550627002491	120	Waadookodaading	charter	Regular School	Yes	1.0	PK	05	2015	grade_1	13	13
119118	WI	Milwaukee	school	5509600	3619	Public school	Milwaukee	550960002870	820	Daniels University Preparatory Academy	charter	Regular School	Yes	1.0	PK	08	2015	grade_1	13	13
121121	WI	Vilas	school	5501530	616	Public school	North Lakeland	550153000198	50	North Lakeland Elementary		Regular School	No	1.0	PK	08	2015	grade_1	13	13
122091	WI	Columbia	school	5512060	4501	Public school	Portage Community	551206002280	100	Lewiston Elementary		Regular School	No	1.0	KG	05	2015	grade_1	13	13
122697	WI	Oneida	school	5512720	4781	Public school	Rhinelander	551272001673	20	Northwoods Community Elementary	charter	Regular School	Yes	1.0	PK	05	2015	grade_1	13	13
122986	WI	Sauk	school	5514250	5523	Public school	River Valley	551425001858	140	River Valley Elementary Plain		Regular School	No	1.0	PK	05	2015	grade_1	13	13
126246	WI	Wood	school	5517070	6685	Public school	Wisconsin Rapids	551707002791	180	Vesper Community Academy		Regular School	No	1.0	PK	05	2015	grade_1	13	13