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 and (total_int > :p3 or (total_int = :p3 and rowid > :p2)) order by total_int, rowid 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	white	hispanic	male	female	low_income	disability	total	white_int	hispanic_int	male_int	female_int	total_int
286388	WI	Rock	school	5507020	2695	Public school	Janesville	550702001686	180	Kennedy Elementary		Regular School	No	1.0	PK	05	2016	pre_kindergarten							1					1
286405	WI	Rock	school	5507020	2695	Public school	Janesville	550702000767	220	Madison Elementary		Regular School	No	1.0	PK	05	2016	pre_kindergarten							1					1
286472	WI	Rock	school	5507020	2695	Public school	Janesville	550702000776	360	Wilson Elementary		Regular School	No	1.0	PK	05	2016	pre_kindergarten							1					1
286473	WI	Rock	school	5507020	2695	Public school	Janesville	550702002948	850	Youth Services Center		Alternative Education School	No	4.0	04	12	2016	pk_12_total		1.0	1.0		*	*	1		1	1		1
286474	WI	Rock	school	5507020	2695	Public school	Janesville	550702002948	850	Youth Services Center		Alternative Education School	No	4.0	04	12	2016	grade_10							1					1
286485	WI	Jefferson	school		2702	Public Schools-Multidistrict Charters	Jefferson		9803	JEDI Virtual K-12	charter						2016	grade_10							1					1
286487	WI	Jefferson	school		2702	Public Schools-Multidistrict Charters	Jefferson		9803	JEDI Virtual K-12	charter						2016	grade_12							1					1
286488	WI	Jefferson	school		2702	Public Schools-Multidistrict Charters	Jefferson		9803	JEDI Virtual K-12	charter						2016	grade_7							1					1
286489	WI	Jefferson	school		2702	Public Schools-Multidistrict Charters	Jefferson		9803	JEDI Virtual K-12	charter						2016	grade_8							1					1
286490	WI	Jefferson	school		2702	Public Schools-Multidistrict Charters	Jefferson		9803	JEDI Virtual K-12	charter						2016	grade_9							1					1
286515	WI	Jefferson	school	5507050	2702	Public school	Jefferson	550705000780	85	West Elementary		Regular School	No	1.0	PK	05	2016	pre_kindergarten							1					1
286744	WI	Kenosha	school	5507320	2793	Public school	Kenosha	550732002910	800	Kenosha eSchool K-12	charter	Regular School	Yes	4.0	KG	12	2016	grade_5							1					1
286745	WI	Kenosha	school	5507320	2793	Public school	Kenosha	550732002910	800	Kenosha eSchool K-12	charter	Regular School	Yes	4.0	KG	12	2016	grade_6							1					1
286797	WI	Kenosha	school	5507320	2793	Public school	Kenosha	550732001714	405	Phoenix Project		Alternative Education School	No	3.0	09	12	2016	grade_11							1					1
287023	WI	Kewaunee	school	5507410	2814	Public school	Kewaunee	550741002768	490	Lakeshore Alternative School		Regular School	No	3.0	10	12	2016	pk_12_total		1.0	1.0		*	*	1		1	1		1
287024	WI	Kewaunee	school	5507410	2814	Public school	Kewaunee	550741002768	490	Lakeshore Alternative School		Regular School	No	3.0	10	12	2016	grade_12							1					1
287159	WI	La Crosse	school	5507530	2849	Public school	La Crosse	550753000855	60	Emerson Elementary		Regular School	No	1.0	PK	05	2016	pre_kindergarten							1					1
287239	WI	La Crosse	school	5507530	2849	Public school	La Crosse	550753000195	110	Southern Bluffs Elementary		Regular School	No	1.0	PK	05	2016	kindergarten_4_year_old							1					1
287329	WI	Waukesha	school	5500013	3862	Public school	Lake Country	550001300578	30	Lake Country School		Regular School	No	1.0	PK	08	2016	pre_kindergarten							1					1
287377	WI	Jefferson	school		2898	Public Schools-Multidistrict Charters	Lake Mills Area		9803	JEDI Virtual K-12	charter						2016	pk_12_total	1.0			1.0	*	*	1	1			1	1
287378	WI	Jefferson	school		2898	Public Schools-Multidistrict Charters	Lake Mills Area		9803	JEDI Virtual K-12	charter						2016	grade_4							1					1
287542	WI	Dodge	school	5508220	3171	Public school	Lomira	550822000907	40	Lomira Elementary		Regular School	No	1.0	PK	05	2016	pre_kindergarten							1					1
287588	WI	Polk	school	5508280	3213	Public school	Luck	550828000914	40	Luck Elementary		Regular School	No	1.0	PK	06	2016	pre_kindergarten							1					1
287731	WI	Dane	school	5508520	3269	Public school	Madison Metropolitan	550852002909	220	Innovative & Alternative Middle		Alternative Education School	No	2.0	06	08	2016	grade_7							1					1
287786	WI	Dane	school	5508520	3269	Public school	Madison Metropolitan	550852000921	65	Lindbergh Elementary		Regular School	No	1.0	PK	05	2016	pre_kindergarten							1					1
287817	WI	Dane	school	5508520	3269	Public school	Madison Metropolitan	550852002670	820	Metro School		Alternative Education School	No	4.0	04	12	2016	grade_7							1					1
287818	WI	Dane	school	5508520	3269	Public school	Madison Metropolitan	550852002670	820	Metro School		Alternative Education School	No	4.0	04	12	2016	grade_9							1					1
287990	WI	Manitowoc	school	5508610	3290	Public school	Manitowoc	550861002714	9120	Manitowoc County Comprehensive Charter School	charter	Special Education School	Yes	1.0	01	08	2016	grade_3							1					1
288105	WI	Marinette	school	5508700	3311	Public school	Marinette	550870000999	140	Park Elementary		Regular School	No	1.0	PK	04	2016	kindergarten							1					1
288146	WI	Dane	school	5508790	3332	Public school	Marshall	550879001791	400	Marshall Charter	charter	Regular School	Yes	3.0	10	12	2016	grade_12							1					1
288230	WI	Juneau	school		3360	Public Schools-Multidistrict Charters	Mauston		9803	JEDI Virtual K-12	charter						2016	grade_1							1					1
288236	WI	Juneau	school		3360	Public Schools-Multidistrict Charters	Mauston		9803	JEDI Virtual K-12	charter						2016	kindergarten							1					1
288237	WI	Juneau	school		3360	Public Schools-Multidistrict Charters	Mauston		9803	JEDI Virtual K-12	charter						2016	pre_kindergarten							1					1
288242	WI	Juneau	school	5508850	3360	Public school	Mauston	550885001024	40	Lyndon Station Elementary		Regular School	No	1.0	KG	05	2016	grade_4							1					1
288636	WI	Lincoln	school	5509210	3500	Public school	Merrill Area	550921002743	400	Merrill Adult Diploma Academy	charter	Alternative Education School	Yes	3.0	10	12	2016	grade_11							1					1
288669	WI	Waukesha	school	5509360	3528	Public school	Merton Community	550936000750	40	Merton Primary		Regular School	No	1.0	PK	04	2016	pre_kindergarten							1					1
288921	WI	Milwaukee	school	5509600	3619	Public school	Milwaukee	550960001133	93	Bruce Elementary		Regular School	No	1.0	PK	05	2016	kindergarten_3_year_old							1					1
289032	WI	Milwaukee	school	5509600	3619	Public school	Milwaukee	550960001141	114	Clemens Elementary		Regular School	No	1.0	PK	05	2016	kindergarten_3_year_old							1					1
289098	WI	Milwaukee	school	5509600	3619	Public school	Milwaukee	550960001146	122	Curtin Elementary		Regular School	No	1.0	PK	08	2016	kindergarten_3_year_old							1					1
289131	WI	Milwaukee	school	5509600	3619	Public school	Milwaukee	550960001154	143	Eighty-First Street Elementary		Regular School	No	1.0	PK	08	2016	grade_7							1					1
289136	WI	Milwaukee	school	5509600	3619	Public school	Milwaukee	550960001154	143	Eighty-First Street Elementary		Regular School	No	1.0	PK	08	2016	pre_kindergarten							1					1
289196	WI	Milwaukee	school	5509600	3619	Public school	Milwaukee	550960001162	170	Fifty-Third Street Elementary		Regular School	No	1.0	PK	08	2016	kindergarten_3_year_old							1					1
289386	WI	Milwaukee	school	5509600	3619	Public school	Milwaukee	550960001187	217	Hi-Mount Elementary		Regular School	No	1.0	PK	08	2016	kindergarten_3_year_old							1					1
289486	WI	Milwaukee	school	5509600	3619	Public school	Milwaukee	550960001195	232	Kagel Elementary		Regular School	No	1.0	PK	05	2016	pre_kindergarten							1					1
289575	WI	Milwaukee	school	5509600	3619	Public school	Milwaukee	550960001204	241	Lancaster Elementary		Regular School	No	1.0	PK	08	2016	kindergarten_3_year_old							1					1
289661	WI	Milwaukee	school	5509600	3619	Public school	Milwaukee	550960001216	268	Maryland Montessori		Regular School	No	1.0	PK	08	2016	pre_kindergarten							1					1
289853	WI	Milwaukee	school	5509600	3619	Public school	Milwaukee	550960001225	289	Ninety-Fifth Street Elementary		Regular School	No	1.0	PK	05	2016	kindergarten_3_year_old							1					1
290007	WI	Milwaukee	school	5509600	3619	Public school	Milwaukee	550960002555	825	St Charles Behav Reassign Success Acad		Alternative Education School	No	4.0	06	12	2016	grade_11							1					1
290040	WI	Milwaukee	school	5509600	3619	Public school	Milwaukee	550960001250	344	Stuart Elementary		Regular School	No	1.0	PK	05	2016	kindergarten_3_year_old							1					1
290092	WI	Milwaukee	school	5509600	3619	Public school	Milwaukee	550960001259	368	Trowbridge Street Elementary		Regular School	No	1.0	PK	08	2016	kindergarten_3_year_old							1					1
290385	WI	Green	school		3682	Public Schools-Multidistrict Charters	Monroe		9803	JEDI Virtual K-12	charter						2016	pk_12_total		1.0	1.0		*	*	1		1	1		1
290386	WI	Green	school		3682	Public Schools-Multidistrict Charters	Monroe		9803	JEDI Virtual K-12	charter						2016	grade_10							1					1
290438	WI	Marquette	school	5509870	3689	Public school	Montello	550987003016	800	Montello Virtual Charter School	charter	Regular School	Yes	4.0	KG	12	2016	grade_7							1					1
290439	WI	Marquette	school	5509870	3689	Public school	Montello	550987003016	800	Montello Virtual Charter School	charter	Regular School	Yes	4.0	KG	12	2016	grade_8							1					1
290478	WI	Marathon	school		3787	Public Schools-Multidistrict Charters	Mosinee		9100	Rural Virtual Academy	charter						2016	grade_1							1					1
290479	WI	Marathon	school		3787	Public Schools-Multidistrict Charters	Mosinee		9100	Rural Virtual Academy	charter						2016	grade_10							1					1
290482	WI	Marathon	school		3787	Public Schools-Multidistrict Charters	Mosinee		9100	Rural Virtual Academy	charter						2016	grade_6							1					1
290483	WI	Marathon	school		3787	Public Schools-Multidistrict Charters	Mosinee		9100	Rural Virtual Academy	charter						2016	grade_7							1					1
290484	WI	Marathon	school		3787	Public Schools-Multidistrict Charters	Mosinee		9100	Rural Virtual Academy	charter						2016	grade_8							1					1
290485	WI	Marathon	school		3787	Public Schools-Multidistrict Charters	Mosinee		9100	Rural Virtual Academy	charter						2016	grade_9							1					1
290486	WI	Marathon	school		3787	Public Schools-Multidistrict Charters	Mosinee		9100	Rural Virtual Academy	charter						2016	kindergarten_4_year_old							1					1
290609	WI	Waukesha	school	5510170	3857	Public school	Muskego-Norway	551017001334	140	Muskego Elementary		Regular School	No	1.0	PK	04	2016	pre_kindergarten							1					1
290623	WI	Juneau	school		3871	Public Schools-Multidistrict Charters	Necedah Area		9405	Juneau County Charter School	charter						2016	grade_10							1					1
290886	WI	Juneau	school	5510560	3948	Public school	New Lisbon	551056002517	9405	Juneau County Charter School	charter	Regular School	Yes	3.0	07	12	2016	grade_12							1					1
290896	WI	Juneau	school	5510560	3948	Public school	New Lisbon	551056001381	40	New Lisbon Elementary		Regular School	No	1.0	PK	06	2016	pre_kindergarten							1					1
290948	WI	Waupaca	school	5510590	3955	Public school	New London	551059001386	100	Readfield Elementary		Regular School	No	1.0	PK	04	2016	pre_kindergarten							1					1
291015	WI	Waukesha	school	5510710	3976	Public school	Norris	551071001395	20	Norris High		Regular School	No	4.0	06	12	2016	grade_7							1					1
291076	WI	Waukesha	school	5509300	3514	Public school	North Lake	550930002268	20	North Lake Elementary		Regular School	No	1.0	PK	08	2016	pre_kindergarten							1					1
291172	WI	Vilas	school	5503860	1526	Public school	Northland Pines	550386003013	410	School of Options & Applied Research High	charter	Regular School	Yes	3.0	08	12	2016	grade_10							1					1
291372	WI	Oconto	school	5510950	4074	Public school	Oconto Falls Public	551095002736	410	New Path	charter	Alternative Education School	Yes	4.0	06	12	2016	grade_10							1					1
291376	WI	Oconto	school	5510950	4074	Public school	Oconto Falls Public	551095002736	410	New Path	charter	Alternative Education School	Yes	4.0	06	12	2016	grade_9							1					1
291501	WI	Dane	school	5511100	4144	Public school	Oregon	551110001469	40	Netherwood Knoll Elementary		Regular School	No	1.0	PK	04	2016	pre_kindergarten							1					1
291811	WI	Lafayette	school	5501310	490	Public school	Pecatonica Area	550131000181	20	Pecatonica Elementary		Regular School	No	1.0	PK	05	2016	pre_kindergarten							1					1
291965	WI	Sheboygan	school	5511940	4473	Public school	Plymouth Joint	551194001559	40	Fairview Elementary		Regular School	No	1.0	PK	04	2016	pre_kindergarten							1					1
291981	WI	Sheboygan	school	5511940	4473	Public school	Plymouth Joint	551194001560	60	Parkview Elementary		Regular School	No	1.0	PK	04	2016	pre_kindergarten							1					1
292049	WI	Columbia	school	5512060	4501	Public school	Portage Community	551206002419	120	Endeavor Elementary		Regular School	No	1.0	PK	05	2016	pre_kindergarten							1					1
292071	WI	Columbia	school	5512060	4501	Public school	Portage Community	551206002945	190	Portage Partnering Preschool		Regular School	No	1.0	PK	04	2016	grade_1							1					1
292141	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	2016	grade_1							1					1
292142	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	2016	grade_10							1					1
292144	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	2016	grade_12							1					1
292145	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	2016	grade_2							1					1
292146	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	2016	grade_4							1					1
292147	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	2016	grade_5							1					1
292149	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	2016	grade_9							1					1
292150	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	2016	kindergarten							1					1
292164	WI	Barron	school	5512180	4557	Public school	Prairie Farm Public	551218001585	20	Prairie Farm Elementary		Regular School	No	1.0	PK	05	2016	pre_kindergarten							1					1
292199	WI	Price	school		4571	Public Schools-Multidistrict Charters	Prentice		9100	Rural Virtual Academy	charter						2016	grade_1							1					1
292201	WI	Price	school		4571	Public Schools-Multidistrict Charters	Prentice		9100	Rural Virtual Academy	charter						2016	grade_6							1					1
292202	WI	Price	school		4571	Public Schools-Multidistrict Charters	Prentice		9100	Rural Virtual Academy	charter						2016	kindergarten_4_year_old							1					1
292237	WI	Green Lake	school	5512300	4606	Public school	Princeton	551230001595	40	Princeton School		Regular School	No	4.0	PK	12	2016	pre_kindergarten							1					1
292263	WI	Brown	school	5512330	4613	Public school	Pulaski Community	551233001598	50	Hillcrest Elementary		Regular School	No	1.0	PK	05	2016	pre_kindergarten							1					1
292290	WI	Brown	school	5512330	4613	Public school	Pulaski Community	551233001601	120	Sunnyside Elementary		Regular School	No	1.0	PK	05	2016	pre_kindergarten							1					1
292323	WI	Racine	school	5512360	4620	Public school	Racine Unified	551236001614	121	Giese Elementary		Regular School	No	1.0	PK	05	2016	pre_kindergarten							1					1
292374	WI	Racine	school	5512360	4620	Public school	Racine Unified	551236001624	134	Jerstad-Agerholm Elementary		Regular School	No	1.0	PK	05	2016	pre_kindergarten							1					1
292414	WI	Racine	school	5512360	4620	Public school	Racine Unified	551236001628	138	Knapp Elementary		Regular School	No	1.0	PK	05	2016	pre_kindergarten							1					1
292451	WI	Racine	school	5512360	4620	Public school	Racine Unified	551236000458	172	P-COC		Regular School	No	1.0	PK	PK	2016	kindergarten_4_year_old							1					1
292467	WI	Racine	school	5512360	4620	Public school	Racine Unified	551236002997	100	Racine Civil Leaders Academy	charter	Regular School	Yes	1.0	PK	06	2016	pre_kindergarten							1					1
292497	WI	Racine	school	5512360	4620	Public school	Racine Unified	551236001638	166	Schulte Elementary		Regular School	No	1.0	PK	05	2016	pre_kindergarten							1					1
292595	WI	Racine	school	5512480	4686	Public school	Raymond #14	551248001656	20	Raymond Elementary		Regular School	No	1.0	PK	08	2016	pre_kindergarten							1					1
292715	WI	Taylor	school		4795	Public Schools-Multidistrict Charters	Rib Lake		9100	Rural Virtual Academy	charter						2016	grade_2							1					1
292716	WI	Taylor	school		4795	Public Schools-Multidistrict Charters	Rib Lake		9100	Rural Virtual Academy	charter						2016	grade_3							1					1