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 (ccd_school_lvl > :p3 or (ccd_school_lvl = :p3 and rowid > :p2)) order by ccd_school_lvl, rowid 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	pacific_islander	multiracial	male	female	low_income	disability	total	white_int	black_int	hispanic_int	pacific_islander_int	multiracial_int	male_int	female_int	low_income_int	disability_int	total_int
2323825	WI	Walworth	school	2884	Public Schools-Multidistrict Charters	Lake Geneva-Genoa City UHS	9401	Walworth Co Educ Alt High	charter	2020	grade_12										23										23
2323826	WI	Chippewa	school	2891	Public Schools-Multidistrict Charters	Lake Holcombe	9419	eSucceed Charter School	charter	2020	pk_12_total	1.0						1.0	*	*	1	1						1			1
2323827	WI	Chippewa	school	2891	Public Schools-Multidistrict Charters	Lake Holcombe	9419	eSucceed Charter School	charter	2020	grade_9										1										1
2324080	WI	Kewaunee	school	3220	Public Schools-Multidistrict Charters	Luxemburg-Casco	9803	JEDI Virtual K-12	charter	2020	pk_12_total	6.0		1.0			2.0	5.0	1		7	6		1			2	5	1		7
2324081	WI	Kewaunee	school	3220	Public Schools-Multidistrict Charters	Luxemburg-Casco	9803	JEDI Virtual K-12	charter	2020	grade_10										1										1
2324082	WI	Kewaunee	school	3220	Public Schools-Multidistrict Charters	Luxemburg-Casco	9803	JEDI Virtual K-12	charter	2020	grade_11										2										2
2324083	WI	Kewaunee	school	3220	Public Schools-Multidistrict Charters	Luxemburg-Casco	9803	JEDI Virtual K-12	charter	2020	grade_12										1										1
2324084	WI	Kewaunee	school	3220	Public Schools-Multidistrict Charters	Luxemburg-Casco	9803	JEDI Virtual K-12	charter	2020	grade_9										3										3
2324631	WI	Dane	school	3332	Public Schools-Multidistrict Charters	Marshall	9803	JEDI Virtual K-12	charter	2020	pk_12_total										0										0
2324694	WI	Wood	school	3339	Public Schools-Multidistrict Charters	Marshfield Unified	9100	Rural Virtual Academy	charter	2020	pk_12_total	47.0	1.0			3.0	26.0	25.0	19	13	51	47	1			3	26	25	19	13	51
2324695	WI	Wood	school	3339	Public Schools-Multidistrict Charters	Marshfield Unified	9100	Rural Virtual Academy	charter	2020	grade_1										6										6
2324696	WI	Wood	school	3339	Public Schools-Multidistrict Charters	Marshfield Unified	9100	Rural Virtual Academy	charter	2020	grade_10										3										3
2324697	WI	Wood	school	3339	Public Schools-Multidistrict Charters	Marshfield Unified	9100	Rural Virtual Academy	charter	2020	grade_11										4										4
2324698	WI	Wood	school	3339	Public Schools-Multidistrict Charters	Marshfield Unified	9100	Rural Virtual Academy	charter	2020	grade_12										6										6
2324699	WI	Wood	school	3339	Public Schools-Multidistrict Charters	Marshfield Unified	9100	Rural Virtual Academy	charter	2020	grade_2										1										1
2324700	WI	Wood	school	3339	Public Schools-Multidistrict Charters	Marshfield Unified	9100	Rural Virtual Academy	charter	2020	grade_3										3										3
2324701	WI	Wood	school	3339	Public Schools-Multidistrict Charters	Marshfield Unified	9100	Rural Virtual Academy	charter	2020	grade_4										5										5
2324702	WI	Wood	school	3339	Public Schools-Multidistrict Charters	Marshfield Unified	9100	Rural Virtual Academy	charter	2020	grade_6										6										6
2324703	WI	Wood	school	3339	Public Schools-Multidistrict Charters	Marshfield Unified	9100	Rural Virtual Academy	charter	2020	grade_7										4										4
2324704	WI	Wood	school	3339	Public Schools-Multidistrict Charters	Marshfield Unified	9100	Rural Virtual Academy	charter	2020	grade_8										4										4
2324705	WI	Wood	school	3339	Public Schools-Multidistrict Charters	Marshfield Unified	9100	Rural Virtual Academy	charter	2020	grade_9										3										3
2324706	WI	Wood	school	3339	Public Schools-Multidistrict Charters	Marshfield Unified	9100	Rural Virtual Academy	charter	2020	kindergarten_4_year_old										3										3
2324707	WI	Wood	school	3339	Public Schools-Multidistrict Charters	Marshfield Unified	9100	Rural Virtual Academy	charter	2020	kindergarten										3										3
2324728	WI	Juneau	school	3360	Public Schools-Multidistrict Charters	Mauston	9803	JEDI Virtual K-12	charter	2020	pk_12_total	3.0				1.0		4.0	*	*	4	3				1		4			4
2324729	WI	Juneau	school	3360	Public Schools-Multidistrict Charters	Mauston	9803	JEDI Virtual K-12	charter	2020	grade_11										2										2
2324730	WI	Juneau	school	3360	Public Schools-Multidistrict Charters	Mauston	9803	JEDI Virtual K-12	charter	2020	grade_12										1										1
2324731	WI	Juneau	school	3360	Public Schools-Multidistrict Charters	Mauston	9803	JEDI Virtual K-12	charter	2020	grade_8										1										1
2325257	WI	Rock	school	3612	Public Schools-Multidistrict Charters	Milton	9803	JEDI Virtual K-12	charter	2020	pk_12_total	8.0		1.0			2.0	7.0	*		9	8		1			2	7			9
2325258	WI	Rock	school	3612	Public Schools-Multidistrict Charters	Milton	9803	JEDI Virtual K-12	charter	2020	grade_10										2										2
2325259	WI	Rock	school	3612	Public Schools-Multidistrict Charters	Milton	9803	JEDI Virtual K-12	charter	2020	grade_11										3										3
2325260	WI	Rock	school	3612	Public Schools-Multidistrict Charters	Milton	9803	JEDI Virtual K-12	charter	2020	grade_9										4										4
2326860	WI	Green	school	3682	Public Schools-Multidistrict Charters	Monroe	9803	JEDI Virtual K-12	charter	2020	pk_12_total	6.0					1.0	5.0	*	*	6	6					1	5			6
2326861	WI	Green	school	3682	Public Schools-Multidistrict Charters	Monroe	9803	JEDI Virtual K-12	charter	2020	grade_11										2										2
2326862	WI	Green	school	3682	Public Schools-Multidistrict Charters	Monroe	9803	JEDI Virtual K-12	charter	2020	grade_12										2										2
2326863	WI	Green	school	3682	Public Schools-Multidistrict Charters	Monroe	9803	JEDI Virtual K-12	charter	2020	grade_4										1										1
2326864	WI	Green	school	3682	Public Schools-Multidistrict Charters	Monroe	9803	JEDI Virtual K-12	charter	2020	grade_6										1										1
2326958	WI	Marathon	school	3787	Public Schools-Multidistrict Charters	Mosinee	9100	Rural Virtual Academy	charter	2020	pk_12_total	34.0		1.0	1.0	2.0	22.0	16.0	6	8	38	34		1	1	2	22	16	6	8	38
2326959	WI	Marathon	school	3787	Public Schools-Multidistrict Charters	Mosinee	9100	Rural Virtual Academy	charter	2020	grade_1										1										1
2326960	WI	Marathon	school	3787	Public Schools-Multidistrict Charters	Mosinee	9100	Rural Virtual Academy	charter	2020	grade_10										2										2
2326961	WI	Marathon	school	3787	Public Schools-Multidistrict Charters	Mosinee	9100	Rural Virtual Academy	charter	2020	grade_11										5										5
2326962	WI	Marathon	school	3787	Public Schools-Multidistrict Charters	Mosinee	9100	Rural Virtual Academy	charter	2020	grade_12										12										12
2326963	WI	Marathon	school	3787	Public Schools-Multidistrict Charters	Mosinee	9100	Rural Virtual Academy	charter	2020	grade_2										3										3
2326964	WI	Marathon	school	3787	Public Schools-Multidistrict Charters	Mosinee	9100	Rural Virtual Academy	charter	2020	grade_3										2										2
2326965	WI	Marathon	school	3787	Public Schools-Multidistrict Charters	Mosinee	9100	Rural Virtual Academy	charter	2020	grade_4										1										1
2326966	WI	Marathon	school	3787	Public Schools-Multidistrict Charters	Mosinee	9100	Rural Virtual Academy	charter	2020	grade_5										3										3
2326967	WI	Marathon	school	3787	Public Schools-Multidistrict Charters	Mosinee	9100	Rural Virtual Academy	charter	2020	grade_7										3										3
2326968	WI	Marathon	school	3787	Public Schools-Multidistrict Charters	Mosinee	9100	Rural Virtual Academy	charter	2020	grade_8										1										1
2326969	WI	Marathon	school	3787	Public Schools-Multidistrict Charters	Mosinee	9100	Rural Virtual Academy	charter	2020	grade_9										3										3
2326970	WI	Marathon	school	3787	Public Schools-Multidistrict Charters	Mosinee	9100	Rural Virtual Academy	charter	2020	kindergarten										2										2
2327269	WI	Chippewa	school	3920	Public Schools-Multidistrict Charters	New Auburn	9419	eSucceed Charter School	charter	2020	pk_12_total	1.0					1.0		*	*	1	1					1				1
2327270	WI	Chippewa	school	3920	Public Schools-Multidistrict Charters	New Auburn	9419	eSucceed Charter School	charter	2020	grade_9										1										1
2327575	WI	Vilas	school	616	Public Schools-Multidistrict Charters	North Lakeland	9418	Lakeland STAR School--Strong Talented Adventurous Remarkable	charter	2020	pk_12_total										0										0
2328223	WI	Clark	school	4207	Public Schools-Multidistrict Charters	Owen-Withee	9100	Rural Virtual Academy	charter	2020	pk_12_total	3.0					1.0	2.0	*	*	3	3					1	2			3
2328224	WI	Clark	school	4207	Public Schools-Multidistrict Charters	Owen-Withee	9100	Rural Virtual Academy	charter	2020	grade_10										1										1
2328225	WI	Clark	school	4207	Public Schools-Multidistrict Charters	Owen-Withee	9100	Rural Virtual Academy	charter	2020	grade_12										1										1
2328226	WI	Clark	school	4207	Public Schools-Multidistrict Charters	Owen-Withee	9100	Rural Virtual Academy	charter	2020	kindergarten_4_year_old										1										1
2328417	WI	Price	school	4347	Public Schools-Multidistrict Charters	Phillips	9100	Rural Virtual Academy		2020	pk_12_total	13.0			1.0		10.0	4.0	8	1	14	13			1		10	4	8	1	14
2328418	WI	Price	school	4347	Public Schools-Multidistrict Charters	Phillips	9100	Rural Virtual Academy		2020	grade_10										1										1
2328419	WI	Price	school	4347	Public Schools-Multidistrict Charters	Phillips	9100	Rural Virtual Academy		2020	grade_11										2										2
2328420	WI	Price	school	4347	Public Schools-Multidistrict Charters	Phillips	9100	Rural Virtual Academy		2020	grade_12										1										1
2328421	WI	Price	school	4347	Public Schools-Multidistrict Charters	Phillips	9100	Rural Virtual Academy		2020	grade_2										2										2
2328422	WI	Price	school	4347	Public Schools-Multidistrict Charters	Phillips	9100	Rural Virtual Academy		2020	grade_4										3										3
2328423	WI	Price	school	4347	Public Schools-Multidistrict Charters	Phillips	9100	Rural Virtual Academy		2020	grade_6										1										1
2328424	WI	Price	school	4347	Public Schools-Multidistrict Charters	Phillips	9100	Rural Virtual Academy		2020	grade_7										1										1
2328425	WI	Price	school	4347	Public Schools-Multidistrict Charters	Phillips	9100	Rural Virtual Academy		2020	kindergarten_4_year_old										1										1
2328426	WI	Price	school	4347	Public Schools-Multidistrict Charters	Phillips	9100	Rural Virtual Academy		2020	kindergarten										2										2
2328444	WI	Wood	school	4368	Public Schools-Multidistrict Charters	Pittsville	9100	Rural Virtual Academy	charter	2020	pk_12_total	15.0					6.0	9.0	4	1	15	15					6	9	4	1	15
2328445	WI	Wood	school	4368	Public Schools-Multidistrict Charters	Pittsville	9100	Rural Virtual Academy	charter	2020	grade_1										1										1
2328446	WI	Wood	school	4368	Public Schools-Multidistrict Charters	Pittsville	9100	Rural Virtual Academy	charter	2020	grade_11										2										2
2328447	WI	Wood	school	4368	Public Schools-Multidistrict Charters	Pittsville	9100	Rural Virtual Academy	charter	2020	grade_12										3										3
2328448	WI	Wood	school	4368	Public Schools-Multidistrict Charters	Pittsville	9100	Rural Virtual Academy	charter	2020	grade_3										1										1
2328449	WI	Wood	school	4368	Public Schools-Multidistrict Charters	Pittsville	9100	Rural Virtual Academy	charter	2020	grade_4										1										1
2328450	WI	Wood	school	4368	Public Schools-Multidistrict Charters	Pittsville	9100	Rural Virtual Academy	charter	2020	grade_6										1										1
2328451	WI	Wood	school	4368	Public Schools-Multidistrict Charters	Pittsville	9100	Rural Virtual Academy	charter	2020	grade_7										1										1
2328452	WI	Wood	school	4368	Public Schools-Multidistrict Charters	Pittsville	9100	Rural Virtual Academy	charter	2020	grade_8										4										4
2328453	WI	Wood	school	4368	Public Schools-Multidistrict Charters	Pittsville	9100	Rural Virtual Academy	charter	2020	grade_9										1										1
2328722	WI	Price	school	4571	Public Schools-Multidistrict Charters	Prentice	9100	Rural Virtual Academy	charter	2020	pk_12_total	21.0					10.0	11.0	5	1	21	21					10	11	5	1	21
2328723	WI	Price	school	4571	Public Schools-Multidistrict Charters	Prentice	9100	Rural Virtual Academy	charter	2020	grade_11										1										1
2328724	WI	Price	school	4571	Public Schools-Multidistrict Charters	Prentice	9100	Rural Virtual Academy	charter	2020	grade_12										3										3
2328725	WI	Price	school	4571	Public Schools-Multidistrict Charters	Prentice	9100	Rural Virtual Academy	charter	2020	grade_2										2										2
2328726	WI	Price	school	4571	Public Schools-Multidistrict Charters	Prentice	9100	Rural Virtual Academy	charter	2020	grade_3										3										3
2328727	WI	Price	school	4571	Public Schools-Multidistrict Charters	Prentice	9100	Rural Virtual Academy	charter	2020	grade_5										4										4
2328728	WI	Price	school	4571	Public Schools-Multidistrict Charters	Prentice	9100	Rural Virtual Academy	charter	2020	grade_6										2										2
2328729	WI	Price	school	4571	Public Schools-Multidistrict Charters	Prentice	9100	Rural Virtual Academy	charter	2020	grade_7										3										3
2328730	WI	Price	school	4571	Public Schools-Multidistrict Charters	Prentice	9100	Rural Virtual Academy	charter	2020	grade_8										1										1
2328731	WI	Price	school	4571	Public Schools-Multidistrict Charters	Prentice	9100	Rural Virtual Academy	charter	2020	kindergarten										2										2
2329216	WI	Taylor	school	4795	Public Schools-Multidistrict Charters	Rib Lake	9100	Rural Virtual Academy	charter	2020	pk_12_total	23.0	1.0				12.0	12.0	5		24	23	1				12	12	5		24
2329217	WI	Taylor	school	4795	Public Schools-Multidistrict Charters	Rib Lake	9100	Rural Virtual Academy	charter	2020	grade_1										2										2
2329218	WI	Taylor	school	4795	Public Schools-Multidistrict Charters	Rib Lake	9100	Rural Virtual Academy	charter	2020	grade_10										1										1
2329219	WI	Taylor	school	4795	Public Schools-Multidistrict Charters	Rib Lake	9100	Rural Virtual Academy	charter	2020	grade_11										1										1
2329220	WI	Taylor	school	4795	Public Schools-Multidistrict Charters	Rib Lake	9100	Rural Virtual Academy	charter	2020	grade_12										1										1
2329221	WI	Taylor	school	4795	Public Schools-Multidistrict Charters	Rib Lake	9100	Rural Virtual Academy	charter	2020	grade_4										1										1
2329222	WI	Taylor	school	4795	Public Schools-Multidistrict Charters	Rib Lake	9100	Rural Virtual Academy	charter	2020	grade_5										2										2
2329223	WI	Taylor	school	4795	Public Schools-Multidistrict Charters	Rib Lake	9100	Rural Virtual Academy	charter	2020	grade_6										1										1
2329224	WI	Taylor	school	4795	Public Schools-Multidistrict Charters	Rib Lake	9100	Rural Virtual Academy	charter	2020	grade_7										5										5
2329225	WI	Taylor	school	4795	Public Schools-Multidistrict Charters	Rib Lake	9100	Rural Virtual Academy	charter	2020	grade_8										2										2
2329226	WI	Taylor	school	4795	Public Schools-Multidistrict Charters	Rib Lake	9100	Rural Virtual Academy	charter	2020	kindergarten_4_year_old										3										3
2329227	WI	Taylor	school	4795	Public Schools-Multidistrict Charters	Rib Lake	9100	Rural Virtual Academy	charter	2020	kindergarten										5										5
2330230	WI	Door	school	5457	Public Schools-Multidistrict Charters	Southern Door County	9100	Rural Virtual Academy	charter	2020	pk_12_total	1.0					1.0		*	*	1	1					1				1
2330231	WI	Door	school	5457	Public Schools-Multidistrict Charters	Southern Door County	9100	Rural Virtual Academy	charter	2020	grade_11										1										1
2330328	WI	Marathon	school	5467	Public Schools-Multidistrict Charters	Spencer	9100	Rural Virtual Academy	charter	2020	pk_12_total	8.0					6.0	2.0	*	2	8	8					6	2		2	8