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 ccd_charter_school limit 101

Query parameters

This data as json, CSV

rowid	state	county	admin_level	district_state_id	district_state_type	district	school_state_id	school	school_state_type	year	grade	white	black	hispanic	native_american	asian	pacific_islander	multiracial	male	female	low_income	disability	total	white_int	black_int	hispanic_int	native_american_int	asian_int	pacific_islander_int	multiracial_int	male_int	female_int	low_income_int	disability_int	total_int
3088665	WI	Clark	school	7	Public Schools-Multidistrict Charters	Abbotsford	9100	Rural Virtual Academy	charter	2018	pk_12_total	3.0							3.0		*	*	3	3							3				3
3088666	WI	Clark	school	7	Public Schools-Multidistrict Charters	Abbotsford	9100	Rural Virtual Academy	charter	2018	grade_10												1												1
3088667	WI	Clark	school	7	Public Schools-Multidistrict Charters	Abbotsford	9100	Rural Virtual Academy	charter	2018	grade_6												1												1
3088668	WI	Clark	school	7	Public Schools-Multidistrict Charters	Abbotsford	9100	Rural Virtual Academy	charter	2018	grade_9												1												1
3088869	WI	Langlade	school	140	Public Schools-Multidistrict Charters	Antigo Unified	9100	Rural Virtual Academy	charter	2018	pk_12_total	26.0		4.0	2.0				17.0	15.0	9	8	32	26		4	2				17	15	9	8	32
3088870	WI	Langlade	school	140	Public Schools-Multidistrict Charters	Antigo Unified	9100	Rural Virtual Academy	charter	2018	grade_11												5												5
3088871	WI	Langlade	school	140	Public Schools-Multidistrict Charters	Antigo Unified	9100	Rural Virtual Academy	charter	2018	grade_12												9												9
3088872	WI	Langlade	school	140	Public Schools-Multidistrict Charters	Antigo Unified	9100	Rural Virtual Academy	charter	2018	grade_2												1												1
3088873	WI	Langlade	school	140	Public Schools-Multidistrict Charters	Antigo Unified	9100	Rural Virtual Academy	charter	2018	grade_3												2												2
3088874	WI	Langlade	school	140	Public Schools-Multidistrict Charters	Antigo Unified	9100	Rural Virtual Academy	charter	2018	grade_4												1												1
3088875	WI	Langlade	school	140	Public Schools-Multidistrict Charters	Antigo Unified	9100	Rural Virtual Academy	charter	2018	grade_5												1												1
3088876	WI	Langlade	school	140	Public Schools-Multidistrict Charters	Antigo Unified	9100	Rural Virtual Academy	charter	2018	grade_6												2												2
3088877	WI	Langlade	school	140	Public Schools-Multidistrict Charters	Antigo Unified	9100	Rural Virtual Academy	charter	2018	grade_7												2												2
3088878	WI	Langlade	school	140	Public Schools-Multidistrict Charters	Antigo Unified	9100	Rural Virtual Academy	charter	2018	grade_8												5												5
3088879	WI	Langlade	school	140	Public Schools-Multidistrict Charters	Antigo Unified	9100	Rural Virtual Academy	charter	2018	grade_9												4												4
3089292	WI	Wood	school	203	Public Schools-Multidistrict Charters	Auburndale	9100	Rural Virtual Academy	charter	2018	pk_12_total	3.0								3.0	*	*	3	3								3			3
3089293	WI	Wood	school	203	Public Schools-Multidistrict Charters	Auburndale	9100	Rural Virtual Academy	charter	2018	grade_3												1												1
3089294	WI	Wood	school	203	Public Schools-Multidistrict Charters	Auburndale	9100	Rural Virtual Academy	charter	2018	grade_4												1												1
3089295	WI	Wood	school	203	Public Schools-Multidistrict Charters	Auburndale	9100	Rural Virtual Academy	charter	2018	grade_8												1												1
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
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
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
3089765	WI	Walworth	school	6013	Public Schools-Multidistrict Charters	Big Foot UHS	9401	Walworth Co Educ Alt High	charter	2018	grade_12												6												6
3089940	WI	Shawano	school	623	Public Schools-Multidistrict Charters	Bowler	9100	Rural Virtual Academy	charter	2018	pk_12_total	4.0			4.0			2.0	8.0	2.0	1	1	10	4			4			2	8	2	1	1	10
3089941	WI	Shawano	school	623	Public Schools-Multidistrict Charters	Bowler	9100	Rural Virtual Academy	charter	2018	grade_10												5												5
3089942	WI	Shawano	school	623	Public Schools-Multidistrict Charters	Bowler	9100	Rural Virtual Academy	charter	2018	grade_12												2												2
3089943	WI	Shawano	school	623	Public Schools-Multidistrict Charters	Bowler	9100	Rural Virtual Academy	charter	2018	grade_5												2												2
3089944	WI	Shawano	school	623	Public Schools-Multidistrict Charters	Bowler	9100	Rural Virtual Academy	charter	2018	grade_7												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
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
3090605	WI	Clark	school	1162	Public Schools-Multidistrict Charters	Colby	9100	Rural Virtual Academy	charter	2018	pk_12_total	3.0							1.0	2.0	*	*	3	3							1	2			3
3090606	WI	Clark	school	1162	Public Schools-Multidistrict Charters	Colby	9100	Rural Virtual Academy	charter	2018	grade_1												1												1
3090607	WI	Clark	school	1162	Public Schools-Multidistrict Charters	Colby	9100	Rural Virtual Academy	charter	2018	grade_12												1												1
3090608	WI	Clark	school	1162	Public Schools-Multidistrict Charters	Colby	9100	Rural Virtual Academy	charter	2018	grade_3												1												1
3091059	WI	Walworth	school	1380	Public Schools-Multidistrict Charters	Delavan-Darien	9401	Walworth Co Educ Alt High	charter	2018	pk_12_total	4.0		3.0					2.0	5.0	*	1	7	4		3					2	5		1	7
3091060	WI	Walworth	school	1380	Public Schools-Multidistrict Charters	Delavan-Darien	9401	Walworth Co Educ Alt High	charter	2018	grade_11												1												1
3091061	WI	Walworth	school	1380	Public Schools-Multidistrict Charters	Delavan-Darien	9401	Walworth Co Educ Alt High	charter	2018	grade_12												6												6
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
3092160	WI	Taylor	school	2135	Public Schools-Multidistrict Charters	Gilman	9100	Rural Virtual Academy	charter	2018	pk_12_total	3.0							1.0	2.0	*	*	3	3							1	2			3
3092161	WI	Taylor	school	2135	Public Schools-Multidistrict Charters	Gilman	9100	Rural Virtual Academy	charter	2018	grade_10												1												1
3092162	WI	Taylor	school	2135	Public Schools-Multidistrict Charters	Gilman	9100	Rural Virtual Academy	charter	2018	grade_2												1												1
3092163	WI	Taylor	school	2135	Public Schools-Multidistrict Charters	Gilman	9100	Rural Virtual Academy	charter	2018	grade_9												1												1
3093232	WI	Waupaca	school	2639	Public Schools-Multidistrict Charters	Iola-Scandinavia	9408	Waupaca County Charter	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
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
3094300	WI	Walworth	school	2884	Public Schools-Multidistrict Charters	Lake Geneva-Genoa City UHS	9401	Walworth Co Educ Alt High	charter	2018	pk_12_total	22.0	3.0	5.0				1.0	22.0	9.0	11	2	31	22	3	5				1	22	9	11	2	31
3094301	WI	Walworth	school	2884	Public Schools-Multidistrict Charters	Lake Geneva-Genoa City UHS	9401	Walworth Co Educ Alt High	charter	2018	grade_11												7												7
3094302	WI	Walworth	school	2884	Public Schools-Multidistrict Charters	Lake Geneva-Genoa City UHS	9401	Walworth Co Educ Alt High	charter	2018	grade_12												24												24
3094900	WI	Waupaca	school	3276	Public Schools-Multidistrict Charters	Manawa	9408	Waupaca County Charter	charter	2018	pk_12_total												0												0
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
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
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
3097427	WI	Marathon	school	3787	Public Schools-Multidistrict Charters	Mosinee	9100	Rural Virtual Academy	charter	2018	pk_12_total	13.0		1.0			2.0	2.0	8.0	10.0	8	2	18	13		1			2	2	8	10	8	2	18
3097428	WI	Marathon	school	3787	Public Schools-Multidistrict Charters	Mosinee	9100	Rural Virtual Academy	charter	2018	grade_1												1												1
3097429	WI	Marathon	school	3787	Public Schools-Multidistrict Charters	Mosinee	9100	Rural Virtual Academy	charter	2018	grade_10												3												3
3097430	WI	Marathon	school	3787	Public Schools-Multidistrict Charters	Mosinee	9100	Rural Virtual Academy	charter	2018	grade_11												2												2
3097431	WI	Marathon	school	3787	Public Schools-Multidistrict Charters	Mosinee	9100	Rural Virtual Academy	charter	2018	grade_12												5												5
3097432	WI	Marathon	school	3787	Public Schools-Multidistrict Charters	Mosinee	9100	Rural Virtual Academy	charter	2018	grade_3												1												1
3097433	WI	Marathon	school	3787	Public Schools-Multidistrict Charters	Mosinee	9100	Rural Virtual Academy	charter	2018	grade_4												1												1
3097434	WI	Marathon	school	3787	Public Schools-Multidistrict Charters	Mosinee	9100	Rural Virtual Academy	charter	2018	grade_8												2												2
3097435	WI	Marathon	school	3787	Public Schools-Multidistrict Charters	Mosinee	9100	Rural Virtual Academy	charter	2018	grade_9												2												2
3097436	WI	Marathon	school	3787	Public Schools-Multidistrict Charters	Mosinee	9100	Rural Virtual Academy	charter	2018	kindergarten_4_year_old												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
3098881	WI	Wood	school	4368	Public Schools-Multidistrict Charters	Pittsville	9100	Rural Virtual Academy	charter	2018	pk_12_total	8.0							4.0	4.0			8	8							4	4			8
3098882	WI	Wood	school	4368	Public Schools-Multidistrict Charters	Pittsville	9100	Rural Virtual Academy	charter	2018	grade_11												1												1