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 order by school_state_id 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	white	black	hispanic	asian	pacific_islander	multiracial	male	female	low_income	disability	total	white_int	black_int	hispanic_int	asian_int	pacific_islander_int	multiracial_int	male_int	female_int	low_income_int	disability_int	total_int
3089701	WI	Rock	school		422	Public Schools-Multidistrict Charters	Beloit Turner		9803	JEDI Virtual K-12	charter						2018	pk_12_total	1.0							1.0	*	*	1	1							1			1
3089702	WI	Rock	school		422	Public Schools-Multidistrict Charters	Beloit Turner		9803	JEDI Virtual K-12	charter						2018	grade_9											1											1
3090086	WI	Racine	school		777	Public Schools-Multidistrict Charters	Burlington Area		9803	JEDI Virtual K-12	charter						2018	pk_12_total											0											0
3091635	WI	Rock	school		1694	Public Schools-Multidistrict Charters	Evansville Community		9803	JEDI Virtual K-12	charter						2018	pk_12_total	9.0			2.0			5.0	6.0	3	2	11	9			2			5	6	3	2	11
3091636	WI	Rock	school		1694	Public Schools-Multidistrict Charters	Evansville Community		9803	JEDI Virtual K-12	charter						2018	grade_10											1											1
3091637	WI	Rock	school		1694	Public Schools-Multidistrict Charters	Evansville Community		9803	JEDI Virtual K-12	charter						2018	grade_12											2											2
3091638	WI	Rock	school		1694	Public Schools-Multidistrict Charters	Evansville Community		9803	JEDI Virtual K-12	charter						2018	grade_3											2											2
3091639	WI	Rock	school		1694	Public Schools-Multidistrict Charters	Evansville Community		9803	JEDI Virtual K-12	charter						2018	grade_4											1											1
3091640	WI	Rock	school		1694	Public Schools-Multidistrict Charters	Evansville Community		9803	JEDI Virtual K-12	charter						2018	grade_5											2											2
3091641	WI	Rock	school		1694	Public Schools-Multidistrict Charters	Evansville Community		9803	JEDI Virtual K-12	charter						2018	grade_6											1											1
3091642	WI	Rock	school		1694	Public Schools-Multidistrict Charters	Evansville Community		9803	JEDI Virtual K-12	charter						2018	grade_7											1											1
3091643	WI	Rock	school		1694	Public Schools-Multidistrict Charters	Evansville Community		9803	JEDI Virtual K-12	charter						2018	grade_8											1											1
3091873	WI	Jefferson	school		1883	Public Schools-Multidistrict Charters	Fort Atkinson		9803	JEDI Virtual K-12	charter						2018	pk_12_total											0											0
3093431	WI	Jefferson	school		2702	Public Schools-Multidistrict Charters	Jefferson		9803	JEDI Virtual K-12	charter						2018	pk_12_total	4.0						3.0	1.0	*	*	4	4						3	1			4
3093432	WI	Jefferson	school		2702	Public Schools-Multidistrict Charters	Jefferson		9803	JEDI Virtual K-12	charter						2018	grade_10											1											1
3093433	WI	Jefferson	school		2702	Public Schools-Multidistrict Charters	Jefferson		9803	JEDI Virtual K-12	charter						2018	grade_12											2											2
3093434	WI	Jefferson	school		2702	Public Schools-Multidistrict Charters	Jefferson		9803	JEDI Virtual K-12	charter						2018	grade_8											1											1
3094319	WI	Jefferson	school	5507710	2898	Public school	Lake Mills Area	550771002901	9803	JEDI Virtual K-12 - Jefferson and Eastern Dane County Interactive	charter	Alternative School	Yes	Other	PK	12	2018	pk_12_total	42.0	7.0	4.0		1.0		28.0	26.0		2	54	42	7	4		1		28	26		2	54
3094320	WI	Jefferson	school	5507710	2898	Public school	Lake Mills Area	550771002901	9803	JEDI Virtual K-12 - Jefferson and Eastern Dane County Interactive	charter	Alternative School	Yes	Other	PK	12	2018	grade_1											3											3
3094321	WI	Jefferson	school	5507710	2898	Public school	Lake Mills Area	550771002901	9803	JEDI Virtual K-12 - Jefferson and Eastern Dane County Interactive	charter	Alternative School	Yes	Other	PK	12	2018	grade_10											8											8
3094322	WI	Jefferson	school	5507710	2898	Public school	Lake Mills Area	550771002901	9803	JEDI Virtual K-12 - Jefferson and Eastern Dane County Interactive	charter	Alternative School	Yes	Other	PK	12	2018	grade_11											4											4
3094323	WI	Jefferson	school	5507710	2898	Public school	Lake Mills Area	550771002901	9803	JEDI Virtual K-12 - Jefferson and Eastern Dane County Interactive	charter	Alternative School	Yes	Other	PK	12	2018	grade_12											10											10
3094324	WI	Jefferson	school	5507710	2898	Public school	Lake Mills Area	550771002901	9803	JEDI Virtual K-12 - Jefferson and Eastern Dane County Interactive	charter	Alternative School	Yes	Other	PK	12	2018	grade_5											4											4
3094325	WI	Jefferson	school	5507710	2898	Public school	Lake Mills Area	550771002901	9803	JEDI Virtual K-12 - Jefferson and Eastern Dane County Interactive	charter	Alternative School	Yes	Other	PK	12	2018	grade_6											3											3
3094326	WI	Jefferson	school	5507710	2898	Public school	Lake Mills Area	550771002901	9803	JEDI Virtual K-12 - Jefferson and Eastern Dane County Interactive	charter	Alternative School	Yes	Other	PK	12	2018	grade_7											4											4
3094327	WI	Jefferson	school	5507710	2898	Public school	Lake Mills Area	550771002901	9803	JEDI Virtual K-12 - Jefferson and Eastern Dane County Interactive	charter	Alternative School	Yes	Other	PK	12	2018	grade_8											5											5
3094328	WI	Jefferson	school	5507710	2898	Public school	Lake Mills Area	550771002901	9803	JEDI Virtual K-12 - Jefferson and Eastern Dane County Interactive	charter	Alternative School	Yes	Other	PK	12	2018	grade_9											12											12
3094329	WI	Jefferson	school	5507710	2898	Public school	Lake Mills Area	550771002901	9803	JEDI Virtual K-12 - Jefferson and Eastern Dane County Interactive	charter	Alternative School	Yes	Other	PK	12	2018	kindergarten_4_year_old											1											1
3095077	WI	Dane	school		3332	Public Schools-Multidistrict Charters	Marshall		9803	JEDI Virtual K-12	charter						2018	pk_12_total											0											0
3095163	WI	Juneau	school		3360	Public Schools-Multidistrict Charters	Mauston		9803	JEDI Virtual K-12	charter						2018	pk_12_total	12.0						3.0	9.0	5	2	12	12						3	9	5	2	12
3095164	WI	Juneau	school		3360	Public Schools-Multidistrict Charters	Mauston		9803	JEDI Virtual K-12	charter						2018	grade_1											1											1
3095165	WI	Juneau	school		3360	Public Schools-Multidistrict Charters	Mauston		9803	JEDI Virtual K-12	charter						2018	grade_10											2											2
3095166	WI	Juneau	school		3360	Public Schools-Multidistrict Charters	Mauston		9803	JEDI Virtual K-12	charter						2018	grade_11											1											1
3095167	WI	Juneau	school		3360	Public Schools-Multidistrict Charters	Mauston		9803	JEDI Virtual K-12	charter						2018	grade_12											1											1
3095168	WI	Juneau	school		3360	Public Schools-Multidistrict Charters	Mauston		9803	JEDI Virtual K-12	charter						2018	grade_3											1											1
3095169	WI	Juneau	school		3360	Public Schools-Multidistrict Charters	Mauston		9803	JEDI Virtual K-12	charter						2018	grade_5											1											1
3095170	WI	Juneau	school		3360	Public Schools-Multidistrict Charters	Mauston		9803	JEDI Virtual K-12	charter						2018	grade_6											1											1
3095171	WI	Juneau	school		3360	Public Schools-Multidistrict Charters	Mauston		9803	JEDI Virtual K-12	charter						2018	grade_7											1											1
3095172	WI	Juneau	school		3360	Public Schools-Multidistrict Charters	Mauston		9803	JEDI Virtual K-12	charter						2018	grade_8											2											2
3095173	WI	Juneau	school		3360	Public Schools-Multidistrict Charters	Mauston		9803	JEDI Virtual K-12	charter						2018	grade_9											1											1
3097329	WI	Green	school		3682	Public Schools-Multidistrict Charters	Monroe		9803	JEDI Virtual K-12	charter						2018	pk_12_total	3.0		1.0				3.0	1.0	*	*	4	3		1				3	1			4
3097330	WI	Green	school		3682	Public Schools-Multidistrict Charters	Monroe		9803	JEDI Virtual K-12	charter						2018	grade_10											1											1
3097331	WI	Green	school		3682	Public Schools-Multidistrict Charters	Monroe		9803	JEDI Virtual K-12	charter						2018	grade_11											2											2
3097332	WI	Green	school		3682	Public Schools-Multidistrict Charters	Monroe		9803	JEDI Virtual K-12	charter						2018	grade_8											1											1
3100996	WI	Dane	school		5621	Public Schools-Multidistrict Charters	Stoughton Area		9803	JEDI Virtual K-12	charter						2018	pk_12_total	21.0			1.0			6.0	16.0	6	2	22	21			1			6	16	6	2	22
3100997	WI	Dane	school		5621	Public Schools-Multidistrict Charters	Stoughton Area		9803	JEDI Virtual K-12	charter						2018	grade_10											5											5
3100998	WI	Dane	school		5621	Public Schools-Multidistrict Charters	Stoughton Area		9803	JEDI Virtual K-12	charter						2018	grade_11											3											3
3100999	WI	Dane	school		5621	Public Schools-Multidistrict Charters	Stoughton Area		9803	JEDI Virtual K-12	charter						2018	grade_12											10											10
3101000	WI	Dane	school		5621	Public Schools-Multidistrict Charters	Stoughton Area		9803	JEDI Virtual K-12	charter						2018	grade_8											3											3
3101001	WI	Dane	school		5621	Public Schools-Multidistrict Charters	Stoughton Area		9803	JEDI Virtual K-12	charter						2018	grade_9											1											1
3101102	WI	Dane	school		5656	Public Schools-Multidistrict Charters	Sun Prairie Area		9803	JEDI Virtual K-12	charter						2018	pk_12_total	15.0	1.0		1.0		2.0	10.0	9.0	6	1	19	15	1		1		2	10	9	6	1	19
3101103	WI	Dane	school		5656	Public Schools-Multidistrict Charters	Sun Prairie Area		9803	JEDI Virtual K-12	charter						2018	grade_10											1											1
3101104	WI	Dane	school		5656	Public Schools-Multidistrict Charters	Sun Prairie Area		9803	JEDI Virtual K-12	charter						2018	grade_11											3											3
3101105	WI	Dane	school		5656	Public Schools-Multidistrict Charters	Sun Prairie Area		9803	JEDI Virtual K-12	charter						2018	grade_12											6											6
3101106	WI	Dane	school		5656	Public Schools-Multidistrict Charters	Sun Prairie Area		9803	JEDI Virtual K-12	charter						2018	grade_3											1											1
3101107	WI	Dane	school		5656	Public Schools-Multidistrict Charters	Sun Prairie Area		9803	JEDI Virtual K-12	charter						2018	grade_5											3											3
3101108	WI	Dane	school		5656	Public Schools-Multidistrict Charters	Sun Prairie Area		9803	JEDI Virtual K-12	charter						2018	grade_6											1											1
3101109	WI	Dane	school		5656	Public Schools-Multidistrict Charters	Sun Prairie Area		9803	JEDI Virtual K-12	charter						2018	grade_8											1											1
3101110	WI	Dane	school		5656	Public Schools-Multidistrict Charters	Sun Prairie Area		9803	JEDI Virtual K-12	charter						2018	grade_9											3											3
3101815	WI	Jefferson	school		6118	Public Schools-Multidistrict Charters	Waterloo		9803	JEDI Virtual K-12	charter						2018	pk_12_total											0											0
3102943	WI	Walworth	school		6461	Public Schools-Multidistrict Charters	Whitewater Unified		9803	JEDI Virtual K-12 - Jefferson and Eastern Dane County Interactive	charter						2018	pk_12_total											0											0
3089446	WI	Barron	school		308	Public Schools-Multidistrict Charters	Barron Area		9410	North Star Academy	charter						2018	pk_12_total	10.0					2.0	8.0	4.0	*	1	12	10					2	8	4		1	12
3089447	WI	Barron	school		308	Public Schools-Multidistrict Charters	Barron Area		9410	North Star Academy	charter						2018	grade_12											12											12
3090215	WI	Barron	school	5502130	903	Public school	Cameron	550213002500	9410	North Star Academy	charter	Alternative School	Yes	High	09	12	2018	pk_12_total	11.0	3.0					13.0	1.0	8	2	14	11	3					13	1	8	2	14
3090216	WI	Barron	school	5502130	903	Public school	Cameron	550213002500	9410	North Star Academy	charter	Alternative School	Yes	High	09	12	2018	grade_11											4											4
3090217	WI	Barron	school	5502130	903	Public school	Cameron	550213002500	9410	North Star Academy	charter	Alternative School	Yes	High	09	12	2018	grade_12											10											10
3090421	WI	Barron	school		1080	Public Schools-Multidistrict Charters	Chetek-Weyerhaeuser Area		9410	North Star Academy	charter						2018	pk_12_total	6.0					1.0	2.0	5.0	*	1	7	6					1	2	5		1	7
3090422	WI	Barron	school		1080	Public Schools-Multidistrict Charters	Chetek-Weyerhaeuser Area		9410	North Star Academy	charter						2018	grade_11											5											5
3090423	WI	Barron	school		1080	Public Schools-Multidistrict Charters	Chetek-Weyerhaeuser Area		9410	North Star Academy	charter						2018	grade_12											2											2
3101472	WI	Barron	school		5810	Public Schools-Multidistrict Charters	Turtle Lake		9410	North Star Academy	charter						2018	pk_12_total	6.0					1.0	5.0	2.0	*		7	6					1	5	2			7
3101473	WI	Barron	school		5810	Public Schools-Multidistrict Charters	Turtle Lake		9410	North Star Academy	charter						2018	grade_11											1											1
3101474	WI	Barron	school		5810	Public Schools-Multidistrict Charters	Turtle Lake		9410	North Star Academy	charter						2018	grade_12											6											6
3093232	WI	Waupaca	school		2639	Public Schools-Multidistrict Charters	Iola-Scandinavia		9408	Waupaca County Charter	charter						2018	pk_12_total											0											0
3094900	WI	Waupaca	school		3276	Public Schools-Multidistrict Charters	Manawa		9408	Waupaca County Charter	charter						2018	pk_12_total											0											0
3102118	WI	Waupaca	school		6195	Public Schools-Multidistrict Charters	Waupaca		9408	Waupaca County Charter	charter						2018	pk_12_total	3.0		1.0				3.0	1.0	*	*	4	3		1				3	1			4
3102119	WI	Waupaca	school		6195	Public Schools-Multidistrict Charters	Waupaca		9408	Waupaca County Charter	charter						2018	grade_8											1											1
3102120	WI	Waupaca	school		6195	Public Schools-Multidistrict Charters	Waupaca		9408	Waupaca County Charter	charter						2018	grade_9											3											3
3102846	WI	Waupaca	school	5516500	6384	Public school	Weyauwega-Fremont	551650002523	9408	Waupaca County Charter	charter	Regular School	Yes	High	05	12	2018	pk_12_total	3.0						2.0	1.0	*	*	3	3						2	1			3
3102847	WI	Waupaca	school	5516500	6384	Public school	Weyauwega-Fremont	551650002523	9408	Waupaca County Charter	charter	Regular School	Yes	High	05	12	2018	grade_11											1											1
3102848	WI	Waupaca	school	5516500	6384	Public school	Weyauwega-Fremont	551650002523	9408	Waupaca County Charter	charter	Regular School	Yes	High	05	12	2018	grade_12											1											1
3102849	WI	Waupaca	school	5516500	6384	Public school	Weyauwega-Fremont	551650002523	9408	Waupaca County Charter	charter	Regular School	Yes	High	05	12	2018	grade_5											1											1
3093987	WI	Vernon	school		5960	Public Schools-Multidistrict Charters	Kickapoo Area		9407	Vernon County Area Better Futures High	charter						2018	pk_12_total		1.0						1.0	*	*	1		1						1			1
3093988	WI	Vernon	school		5960	Public Schools-Multidistrict Charters	Kickapoo Area		9407	Vernon County Area Better Futures High	charter						2018	grade_11											1											1
3094230	WI	Vernon	school		2863	Public Schools-Multidistrict Charters	La Farge		9407	Vernon County Area Better Futures High	charter						2018	pk_12_total											0											0
3101678	WI	Vernon	school	5515360	5985	Public school	Viroqua Area	551536002513	9407	Vernon County Area Better Futures High	charter	Regular School	Yes	High	10	12	2018	pk_12_total	4.0						2.0	2.0	*	*	4	4						2	2			4
3101679	WI	Vernon	school	5515360	5985	Public school	Viroqua Area	551536002513	9407	Vernon County Area Better Futures High	charter	Regular School	Yes	High	10	12	2018	grade_11											3											3
3101680	WI	Vernon	school	5515360	5985	Public school	Viroqua Area	551536002513	9407	Vernon County Area Better Futures High	charter	Regular School	Yes	High	10	12	2018	grade_12											1											1
3102763	WI	Vernon	school		6321	Public Schools-Multidistrict Charters	Westby Area		9407	Vernon County Area Better Futures High	charter						2018	pk_12_total	2.0							2.0	*	*	2	2							2			2
3102764	WI	Vernon	school		6321	Public Schools-Multidistrict Charters	Westby Area		9407	Vernon County Area Better Futures High	charter						2018	grade_12											2											2
3095174	WI	Juneau	school		3360	Public Schools-Multidistrict Charters	Mauston		9405	Juneau County Charter School	charter						2018	pk_12_total	1.0					1.0	1.0	1.0	*	*	2	1					1	1	1			2
3095175	WI	Juneau	school		3360	Public Schools-Multidistrict Charters	Mauston		9405	Juneau County Charter School	charter						2018	grade_11											1											1
3095176	WI	Juneau	school		3360	Public Schools-Multidistrict Charters	Mauston		9405	Juneau County Charter School	charter						2018	grade_12											1											1
3097573	WI	Juneau	school		3871	Public Schools-Multidistrict Charters	Necedah Area		9405	Juneau County Charter School	charter						2018	pk_12_total											0											0
3097824	WI	Juneau	school	5510560	3948	Public school	New Lisbon	551056002517	9405	Juneau County Charter School	charter	Regular School	Yes	High	07	12	2018	pk_12_total	2.0		1.0				1.0	2.0	*	*	3	2		1				1	2			3
3097825	WI	Juneau	school	5510560	3948	Public school	New Lisbon	551056002517	9405	Juneau County Charter School	charter	Regular School	Yes	High	07	12	2018	grade_11											1											1
3097826	WI	Juneau	school	5510560	3948	Public school	New Lisbon	551056002517	9405	Juneau County Charter School	charter	Regular School	Yes	High	07	12	2018	grade_12											2											2
3099995	WI	Juneau	school		1673	Public Schools-Multidistrict Charters	Royall		9405	Juneau County Charter Sch	charter						2018	pk_12_total											0											0
3103257	WI	Juneau	school		6713	Public Schools-Multidistrict Charters	Wonewoc-Union Center		9405	Juneau County Charter School	charter						2018	pk_12_total											0											0
3089762	WI	Walworth	school		6013	Public Schools-Multidistrict Charters	Big Foot UHS		9401	Walworth Co Educ Alt High	charter						2018	pk_12_total	8.0						5.0	3.0	*	1	8	8						5	3		1	8
3089763	WI	Walworth	school		6013	Public Schools-Multidistrict Charters	Big Foot UHS		9401	Walworth Co Educ Alt High	charter						2018	grade_10											1											1
3089764	WI	Walworth	school		6013	Public Schools-Multidistrict Charters	Big Foot UHS		9401	Walworth Co Educ Alt High	charter						2018	grade_11											1											1