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	multiracial	male	female	low_income	disability	total	white_int	black_int	hispanic_int	native_american_int	asian_int	multiracial_int	male_int	female_int	low_income_int	disability_int	total_int
3073916	WI	Clark	school	7	Public Schools-Multidistrict Charters	Abbotsford	9100	Rural Virtual Academy	charter	2019	pk_12_total	3.0					1.0	1.0	3.0	*	*	4	3					1	1	3			4
3073917	WI	Clark	school	7	Public Schools-Multidistrict Charters	Abbotsford	9100	Rural Virtual Academy	charter	2019	grade_10											1											1
3073918	WI	Clark	school	7	Public Schools-Multidistrict Charters	Abbotsford	9100	Rural Virtual Academy	charter	2019	grade_11											1											1
3073919	WI	Clark	school	7	Public Schools-Multidistrict Charters	Abbotsford	9100	Rural Virtual Academy	charter	2019	grade_12											1											1
3073920	WI	Clark	school	7	Public Schools-Multidistrict Charters	Abbotsford	9100	Rural Virtual Academy	charter	2019	grade_7											1											1
3074111	WI	Langlade	school	140	Public Schools-Multidistrict Charters	Antigo Unified	9100	Rural Virtual Academy	charter	2019	pk_12_total	23.0	1.0	3.0	1.0			9.0	19.0	13	5	28	23	1	3	1			9	19	13	5	28
3074112	WI	Langlade	school	140	Public Schools-Multidistrict Charters	Antigo Unified	9100	Rural Virtual Academy	charter	2019	grade_10											6											6
3074113	WI	Langlade	school	140	Public Schools-Multidistrict Charters	Antigo Unified	9100	Rural Virtual Academy	charter	2019	grade_11											2											2
3074114	WI	Langlade	school	140	Public Schools-Multidistrict Charters	Antigo Unified	9100	Rural Virtual Academy	charter	2019	grade_12											3											3
3074115	WI	Langlade	school	140	Public Schools-Multidistrict Charters	Antigo Unified	9100	Rural Virtual Academy	charter	2019	grade_2											1											1
3074116	WI	Langlade	school	140	Public Schools-Multidistrict Charters	Antigo Unified	9100	Rural Virtual Academy	charter	2019	grade_3											2											2
3074117	WI	Langlade	school	140	Public Schools-Multidistrict Charters	Antigo Unified	9100	Rural Virtual Academy	charter	2019	grade_4											2											2
3074118	WI	Langlade	school	140	Public Schools-Multidistrict Charters	Antigo Unified	9100	Rural Virtual Academy	charter	2019	grade_5											2											2
3074119	WI	Langlade	school	140	Public Schools-Multidistrict Charters	Antigo Unified	9100	Rural Virtual Academy	charter	2019	grade_6											2											2
3074120	WI	Langlade	school	140	Public Schools-Multidistrict Charters	Antigo Unified	9100	Rural Virtual Academy	charter	2019	grade_7											3											3
3074121	WI	Langlade	school	140	Public Schools-Multidistrict Charters	Antigo Unified	9100	Rural Virtual Academy	charter	2019	grade_8											1											1
3074122	WI	Langlade	school	140	Public Schools-Multidistrict Charters	Antigo Unified	9100	Rural Virtual Academy	charter	2019	grade_9											3											3
3074123	WI	Langlade	school	140	Public Schools-Multidistrict Charters	Antigo Unified	9100	Rural Virtual Academy	charter	2019	kindergarten_4_year_old											1											1
3074537	WI	Wood	school	203	Public Schools-Multidistrict Charters	Auburndale	9100	Rural Virtual Academy	charter	2019	pk_12_total	4.0						1.0	3.0	*	*	4	4						1	3			4
3074538	WI	Wood	school	203	Public Schools-Multidistrict Charters	Auburndale	9100	Rural Virtual Academy	charter	2019	grade_7											1											1
3074539	WI	Wood	school	203	Public Schools-Multidistrict Charters	Auburndale	9100	Rural Virtual Academy	charter	2019	grade_8											1											1
3074540	WI	Wood	school	203	Public Schools-Multidistrict Charters	Auburndale	9100	Rural Virtual Academy	charter	2019	grade_9											2											2
3074690	WI	Barron	school	308	Public Schools-Multidistrict Charters	Barron Area	9410	North Star Academy	charter	2019	pk_12_total	11.0	1.0			1.0	1.0	8.0	6.0	7	1	14	11	1			1	1	8	6	7	1	14
3074691	WI	Barron	school	308	Public Schools-Multidistrict Charters	Barron Area	9410	North Star Academy	charter	2019	grade_11											1											1
3074692	WI	Barron	school	308	Public Schools-Multidistrict Charters	Barron Area	9410	North Star Academy	charter	2019	grade_12											13											13
3074945	WI	Rock	school	422	Public Schools-Multidistrict Charters	Beloit Turner	9803	JEDI Virtual K-12	charter	2019	pk_12_total											0											0
3075005	WI	Walworth	school	6013	Public Schools-Multidistrict Charters	Big Foot UHS	9401	Walworth Co Educ Alt High	charter	2019	pk_12_total	1.0						1.0		*	*	1	1						1				1
3075006	WI	Walworth	school	6013	Public Schools-Multidistrict Charters	Big Foot UHS	9401	Walworth Co Educ Alt High	charter	2019	grade_12											1											1
3075172	WI	Shawano	school	623	Public Schools-Multidistrict Charters	Bowler	9100	Rural Virtual Academy	charter	2019	pk_12_total	4.0			12.0		1.0	14.0	3.0	10	3	17	4			12		1	14	3	10	3	17
3075173	WI	Shawano	school	623	Public Schools-Multidistrict Charters	Bowler	9100	Rural Virtual Academy	charter	2019	grade_11											4											4
3075174	WI	Shawano	school	623	Public Schools-Multidistrict Charters	Bowler	9100	Rural Virtual Academy	charter	2019	grade_12											1											1
3075175	WI	Shawano	school	623	Public Schools-Multidistrict Charters	Bowler	9100	Rural Virtual Academy	charter	2019	grade_2											1											1
3075176	WI	Shawano	school	623	Public Schools-Multidistrict Charters	Bowler	9100	Rural Virtual Academy	charter	2019	grade_5											1											1
3075177	WI	Shawano	school	623	Public Schools-Multidistrict Charters	Bowler	9100	Rural Virtual Academy	charter	2019	grade_6											3											3
3075178	WI	Shawano	school	623	Public Schools-Multidistrict Charters	Bowler	9100	Rural Virtual Academy	charter	2019	grade_7											1											1
3075179	WI	Shawano	school	623	Public Schools-Multidistrict Charters	Bowler	9100	Rural Virtual Academy	charter	2019	grade_8											4											4
3075180	WI	Shawano	school	623	Public Schools-Multidistrict Charters	Bowler	9100	Rural Virtual Academy	charter	2019	grade_9											2											2
3075322	WI	Racine	school	777	Public Schools-Multidistrict Charters	Burlington Area	9803	JEDI Virtual K-12	charter	2019	pk_12_total	8.0		1.0			1.0	2.0	8.0	3	1	10	8		1			1	2	8	3	1	10
3075323	WI	Racine	school	777	Public Schools-Multidistrict Charters	Burlington Area	9803	JEDI Virtual K-12	charter	2019	grade_10											2											2
3075324	WI	Racine	school	777	Public Schools-Multidistrict Charters	Burlington Area	9803	JEDI Virtual K-12	charter	2019	grade_11											2											2
3075325	WI	Racine	school	777	Public Schools-Multidistrict Charters	Burlington Area	9803	JEDI Virtual K-12	charter	2019	grade_12											2											2
3075326	WI	Racine	school	777	Public Schools-Multidistrict Charters	Burlington Area	9803	JEDI Virtual K-12	charter	2019	grade_4											1											1
3075327	WI	Racine	school	777	Public Schools-Multidistrict Charters	Burlington Area	9803	JEDI Virtual K-12	charter	2019	grade_7											1											1
3075328	WI	Racine	school	777	Public Schools-Multidistrict Charters	Burlington Area	9803	JEDI Virtual K-12	charter	2019	grade_8											1											1
3075329	WI	Racine	school	777	Public Schools-Multidistrict Charters	Burlington Area	9803	JEDI Virtual K-12	charter	2019	grade_9											1											1
3075671	WI	Barron	school	1080	Public Schools-Multidistrict Charters	Chetek-Weyerhaeuser Area	9410	North Star Academy	charter	2019	pk_12_total	7.0						5.0	2.0	*	*	7	7						5	2			7
3075672	WI	Barron	school	1080	Public Schools-Multidistrict Charters	Chetek-Weyerhaeuser Area	9410	North Star Academy	charter	2019	grade_11											1											1
3075673	WI	Barron	school	1080	Public Schools-Multidistrict Charters	Chetek-Weyerhaeuser Area	9410	North Star Academy	charter	2019	grade_12											6											6
3075853	WI	Clark	school	1162	Public Schools-Multidistrict Charters	Colby	9100	Rural Virtual Academy	charter	2019	pk_12_total	9.0		1.0				2.0	8.0	*		10	9		1				2	8			10
3075854	WI	Clark	school	1162	Public Schools-Multidistrict Charters	Colby	9100	Rural Virtual Academy	charter	2019	grade_10											3											3
3075855	WI	Clark	school	1162	Public Schools-Multidistrict Charters	Colby	9100	Rural Virtual Academy	charter	2019	grade_2											2											2
3075856	WI	Clark	school	1162	Public Schools-Multidistrict Charters	Colby	9100	Rural Virtual Academy	charter	2019	grade_4											2											2
3075857	WI	Clark	school	1162	Public Schools-Multidistrict Charters	Colby	9100	Rural Virtual Academy	charter	2019	grade_6											2											2
3075858	WI	Clark	school	1162	Public Schools-Multidistrict Charters	Colby	9100	Rural Virtual Academy	charter	2019	grade_9											1											1
3076314	WI	Walworth	school	1380	Public Schools-Multidistrict Charters	Delavan-Darien	9401	Walworth Co Educ Alt High	charter	2019	pk_12_total			2.0				1.0	1.0	*	*	2			2				1	1			2
3076315	WI	Walworth	school	1380	Public Schools-Multidistrict Charters	Delavan-Darien	9401	Walworth Co Educ Alt High	charter	2019	grade_12											2											2
3076658	WI	Langlade	school	1582	Public Schools-Multidistrict Charters	Elcho	9100	Rural Virtual Academy	charter	2019	pk_12_total											0											0
3076887	WI	Rock	school	1694	Public Schools-Multidistrict Charters	Evansville Community	9803	JEDI Virtual K-12	charter	2019	pk_12_total	5.0						2.0	3.0	*	*	5	5						2	3			5
3076888	WI	Rock	school	1694	Public Schools-Multidistrict Charters	Evansville Community	9803	JEDI Virtual K-12	charter	2019	grade_4											2											2
3076889	WI	Rock	school	1694	Public Schools-Multidistrict Charters	Evansville Community	9803	JEDI Virtual K-12	charter	2019	grade_6											1											1
3076890	WI	Rock	school	1694	Public Schools-Multidistrict Charters	Evansville Community	9803	JEDI Virtual K-12	charter	2019	grade_8											2											2
3077124	WI	Jefferson	school	1883	Public Schools-Multidistrict Charters	Fort Atkinson	9803	JEDI Virtual K-12	charter	2019	pk_12_total											0											0
3077400	WI	Taylor	school	2135	Public Schools-Multidistrict Charters	Gilman	9100	Rural Virtual Academy	charter	2019	pk_12_total											0											0
3078686	WI	Jefferson	school	2702	Public Schools-Multidistrict Charters	Jefferson	9803	JEDI Virtual K-12	charter	2019	pk_12_total	6.0						3.0	3.0	*		6	6						3	3			6
3078687	WI	Jefferson	school	2702	Public Schools-Multidistrict Charters	Jefferson	9803	JEDI Virtual K-12	charter	2019	grade_11											2											2
3078688	WI	Jefferson	school	2702	Public Schools-Multidistrict Charters	Jefferson	9803	JEDI Virtual K-12	charter	2019	grade_12											2											2
3078689	WI	Jefferson	school	2702	Public Schools-Multidistrict Charters	Jefferson	9803	JEDI Virtual K-12	charter	2019	grade_6											1											1
3078690	WI	Jefferson	school	2702	Public Schools-Multidistrict Charters	Jefferson	9803	JEDI Virtual K-12	charter	2019	grade_8											1											1
3079238	WI	Vernon	school	5960	Public Schools-Multidistrict Charters	Kickapoo Area	9407	Vernon County Area Better Futures High	charter	2019	pk_12_total											0											0
3079482	WI	Vernon	school	2863	Public Schools-Multidistrict Charters	La Farge	9407	Vernon County Area Better Futures High	charter	2019	pk_12_total	1.0						1.0		*	*	1	1						1				1
3079483	WI	Vernon	school	2863	Public Schools-Multidistrict Charters	La Farge	9407	Vernon County Area Better Futures High	charter	2019	grade_12											1											1
3079496	WI	Vilas	school	1848	Public Schools-Multidistrict Charters	Lac du Flambeau #1	9418	Lakeland STAR School--Strong Talented Adventurous Remarkable	charter	2019	pk_12_total											0											0
3079555	WI	Walworth	school	2884	Public Schools-Multidistrict Charters	Lake Geneva-Genoa City UHS	9401	Walworth Co Educ Alt High	charter	2019	pk_12_total	29.0	1.0	7.0				22.0	15.0	20	2	37	29	1	7				22	15	20	2	37
3079556	WI	Walworth	school	2884	Public Schools-Multidistrict Charters	Lake Geneva-Genoa City UHS	9401	Walworth Co Educ Alt High	charter	2019	grade_10											1											1
3079557	WI	Walworth	school	2884	Public Schools-Multidistrict Charters	Lake Geneva-Genoa City UHS	9401	Walworth Co Educ Alt High	charter	2019	grade_11											9											9
3079558	WI	Walworth	school	2884	Public Schools-Multidistrict Charters	Lake Geneva-Genoa City UHS	9401	Walworth Co Educ Alt High	charter	2019	grade_12											27											27
3080354	WI	Dane	school	3332	Public Schools-Multidistrict Charters	Marshall	9803	JEDI Virtual K-12	charter	2019	pk_12_total											0											0
3080420	WI	Wood	school	3339	Public Schools-Multidistrict Charters	Marshfield Unified	9100	Rural Virtual Academy	charter	2019	pk_12_total	37.0	1.0			1.0		22.0	17.0	6	6	39	37	1			1		22	17	6	6	39
3080421	WI	Wood	school	3339	Public Schools-Multidistrict Charters	Marshfield Unified	9100	Rural Virtual Academy	charter	2019	grade_1											2											2
3080422	WI	Wood	school	3339	Public Schools-Multidistrict Charters	Marshfield Unified	9100	Rural Virtual Academy	charter	2019	grade_10											1											1
3080423	WI	Wood	school	3339	Public Schools-Multidistrict Charters	Marshfield Unified	9100	Rural Virtual Academy	charter	2019	grade_11											3											3
3080424	WI	Wood	school	3339	Public Schools-Multidistrict Charters	Marshfield Unified	9100	Rural Virtual Academy	charter	2019	grade_12											2											2
3080425	WI	Wood	school	3339	Public Schools-Multidistrict Charters	Marshfield Unified	9100	Rural Virtual Academy	charter	2019	grade_2											4											4
3080426	WI	Wood	school	3339	Public Schools-Multidistrict Charters	Marshfield Unified	9100	Rural Virtual Academy	charter	2019	grade_3											6											6
3080427	WI	Wood	school	3339	Public Schools-Multidistrict Charters	Marshfield Unified	9100	Rural Virtual Academy	charter	2019	grade_4											1											1
3080428	WI	Wood	school	3339	Public Schools-Multidistrict Charters	Marshfield Unified	9100	Rural Virtual Academy	charter	2019	grade_5											5											5
3080429	WI	Wood	school	3339	Public Schools-Multidistrict Charters	Marshfield Unified	9100	Rural Virtual Academy	charter	2019	grade_6											4											4
3080430	WI	Wood	school	3339	Public Schools-Multidistrict Charters	Marshfield Unified	9100	Rural Virtual Academy	charter	2019	grade_7											2											2
3080431	WI	Wood	school	3339	Public Schools-Multidistrict Charters	Marshfield Unified	9100	Rural Virtual Academy	charter	2019	grade_8											2											2
3080432	WI	Wood	school	3339	Public Schools-Multidistrict Charters	Marshfield Unified	9100	Rural Virtual Academy	charter	2019	grade_9											2											2
3080433	WI	Wood	school	3339	Public Schools-Multidistrict Charters	Marshfield Unified	9100	Rural Virtual Academy	charter	2019	kindergarten_4_year_old											1											1
3080434	WI	Wood	school	3339	Public Schools-Multidistrict Charters	Marshfield Unified	9100	Rural Virtual Academy	charter	2019	kindergarten											4											4
3080456	WI	Juneau	school	3360	Public Schools-Multidistrict Charters	Mauston	9803	JEDI Virtual K-12	charter	2019	pk_12_total	3.0							3.0	*	*	3	3							3			3
3080457	WI	Juneau	school	3360	Public Schools-Multidistrict Charters	Mauston	9803	JEDI Virtual K-12	charter	2019	grade_10											1											1
3080458	WI	Juneau	school	3360	Public Schools-Multidistrict Charters	Mauston	9803	JEDI Virtual K-12	charter	2019	grade_7											1											1
3080459	WI	Juneau	school	3360	Public Schools-Multidistrict Charters	Mauston	9803	JEDI Virtual K-12	charter	2019	grade_8											1											1
3080460	WI	Juneau	school	3360	Public Schools-Multidistrict Charters	Mauston	9405	Juneau County Charter School	charter	2019	pk_12_total											0											0
3082626	WI	Green	school	3682	Public Schools-Multidistrict Charters	Monroe	9803	JEDI Virtual K-12	charter	2019	pk_12_total	10.0		1.0				3.0	8.0	3	2	11	10		1				3	8	3	2	11
3082627	WI	Green	school	3682	Public Schools-Multidistrict Charters	Monroe	9803	JEDI Virtual K-12	charter	2019	grade_10											2											2
3082628	WI	Green	school	3682	Public Schools-Multidistrict Charters	Monroe	9803	JEDI Virtual K-12	charter	2019	grade_11											2											2
3082629	WI	Green	school	3682	Public Schools-Multidistrict Charters	Monroe	9803	JEDI Virtual K-12	charter	2019	grade_12											3											3