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 (school_state_id < :p2 or school_state_id is null or (school_state_id = :p2 and rowid > :p1)) order by school_state_id desc, 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	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
337943	WI	Dane	school		5621	Public Schools-Multidistrict Charters	Stoughton Area		9803	JEDI Virtual K-12	charter						2017	grade_10											2											2
337944	WI	Dane	school		5621	Public Schools-Multidistrict Charters	Stoughton Area		9803	JEDI Virtual K-12	charter						2017	grade_11											4											4
337945	WI	Dane	school		5621	Public Schools-Multidistrict Charters	Stoughton Area		9803	JEDI Virtual K-12	charter						2017	grade_12											5											5
337946	WI	Dane	school		5621	Public Schools-Multidistrict Charters	Stoughton Area		9803	JEDI Virtual K-12	charter						2017	grade_7											1											1
337947	WI	Dane	school		5621	Public Schools-Multidistrict Charters	Stoughton Area		9803	JEDI Virtual K-12	charter						2017	grade_8											1											1
337948	WI	Dane	school		5621	Public Schools-Multidistrict Charters	Stoughton Area		9803	JEDI Virtual K-12	charter						2017	grade_9											2											2
337949	WI	Dane	school		5621	Public Schools-Multidistrict Charters	Stoughton Area		9803	JEDI Virtual K-12	charter						2017	kindergarten											1											1
338051	WI	Dane	school		5656	Public Schools-Multidistrict Charters	Sun Prairie Area		9803	JEDI Virtual K-12	charter						2017	pk_12_total	9.0	1.0					6.0	4.0	3		10	9	1					6	4	3		10
338052	WI	Dane	school		5656	Public Schools-Multidistrict Charters	Sun Prairie Area		9803	JEDI Virtual K-12	charter						2017	grade_10											2											2
338053	WI	Dane	school		5656	Public Schools-Multidistrict Charters	Sun Prairie Area		9803	JEDI Virtual K-12	charter						2017	grade_11											4											4
338054	WI	Dane	school		5656	Public Schools-Multidistrict Charters	Sun Prairie Area		9803	JEDI Virtual K-12	charter						2017	grade_12											1											1
338055	WI	Dane	school		5656	Public Schools-Multidistrict Charters	Sun Prairie Area		9803	JEDI Virtual K-12	charter						2017	grade_2											1											1
338056	WI	Dane	school		5656	Public Schools-Multidistrict Charters	Sun Prairie Area		9803	JEDI Virtual K-12	charter						2017	grade_4											1											1
338057	WI	Dane	school		5656	Public Schools-Multidistrict Charters	Sun Prairie Area		9803	JEDI Virtual K-12	charter						2017	grade_5											1											1
339859	WI	Walworth	school	5516680	6461	Public school	Whitewater Unified	551668002901	9803	JEDI Virtual K-12 - Jefferson and Eastern Dane County Interactive	charter	Alternative School	Yes	Other	PK	12	2017	pk_12_total	44.0	1.0	3.0		1.0	1.0	21.0	29.0	1		50	44	1	3		1	1	21	29	1		50
339860	WI	Walworth	school	5516680	6461	Public school	Whitewater Unified	551668002901	9803	JEDI Virtual K-12 - Jefferson and Eastern Dane County Interactive	charter	Alternative School	Yes	Other	PK	12	2017	grade_10											4											4
339861	WI	Walworth	school	5516680	6461	Public school	Whitewater Unified	551668002901	9803	JEDI Virtual K-12 - Jefferson and Eastern Dane County Interactive	charter	Alternative School	Yes	Other	PK	12	2017	grade_11											13											13
339862	WI	Walworth	school	5516680	6461	Public school	Whitewater Unified	551668002901	9803	JEDI Virtual K-12 - Jefferson and Eastern Dane County Interactive	charter	Alternative School	Yes	Other	PK	12	2017	grade_12											12											12
339863	WI	Walworth	school	5516680	6461	Public school	Whitewater Unified	551668002901	9803	JEDI Virtual K-12 - Jefferson and Eastern Dane County Interactive	charter	Alternative School	Yes	Other	PK	12	2017	grade_3											1											1
339864	WI	Walworth	school	5516680	6461	Public school	Whitewater Unified	551668002901	9803	JEDI Virtual K-12 - Jefferson and Eastern Dane County Interactive	charter	Alternative School	Yes	Other	PK	12	2017	grade_4											1											1
339865	WI	Walworth	school	5516680	6461	Public school	Whitewater Unified	551668002901	9803	JEDI Virtual K-12 - Jefferson and Eastern Dane County Interactive	charter	Alternative School	Yes	Other	PK	12	2017	grade_5											3											3
339866	WI	Walworth	school	5516680	6461	Public school	Whitewater Unified	551668002901	9803	JEDI Virtual K-12 - Jefferson and Eastern Dane County Interactive	charter	Alternative School	Yes	Other	PK	12	2017	grade_6											4											4
339867	WI	Walworth	school	5516680	6461	Public school	Whitewater Unified	551668002901	9803	JEDI Virtual K-12 - Jefferson and Eastern Dane County Interactive	charter	Alternative School	Yes	Other	PK	12	2017	grade_7											3											3
339868	WI	Walworth	school	5516680	6461	Public school	Whitewater Unified	551668002901	9803	JEDI Virtual K-12 - Jefferson and Eastern Dane County Interactive	charter	Alternative School	Yes	Other	PK	12	2017	grade_8											5											5
339869	WI	Walworth	school	5516680	6461	Public school	Whitewater Unified	551668002901	9803	JEDI Virtual K-12 - Jefferson and Eastern Dane County Interactive	charter	Alternative School	Yes	Other	PK	12	2017	grade_9											3											3
339870	WI	Walworth	school	5516680	6461	Public school	Whitewater Unified	551668002901	9803	JEDI Virtual K-12 - Jefferson and Eastern Dane County Interactive	charter	Alternative School	Yes	Other	PK	12	2017	kindergarten											1											1
2319159	WI	Rock	school		422	Public Schools-Multidistrict Charters	Beloit Turner		9803	JEDI Virtual K-12	charter						2020	pk_12_total	2.0		1.0				1.0	2.0	*	*	3	2		1				1	2			3
2319160	WI	Rock	school		422	Public Schools-Multidistrict Charters	Beloit Turner		9803	JEDI Virtual K-12	charter						2020	grade_11											2											2
2319161	WI	Rock	school		422	Public Schools-Multidistrict Charters	Beloit Turner		9803	JEDI Virtual K-12	charter						2020	grade_9											1											1
2319537	WI	Racine	school		777	Public Schools-Multidistrict Charters	Burlington Area		9803	JEDI Virtual K-12	charter						2020	pk_12_total	10.0	1.0	5.0			1.0	6.0	11.0	9	2	17	10	1	5			1	6	11	9	2	17
2319538	WI	Racine	school		777	Public Schools-Multidistrict Charters	Burlington Area		9803	JEDI Virtual K-12	charter						2020	grade_10											5											5
2319539	WI	Racine	school		777	Public Schools-Multidistrict Charters	Burlington Area		9803	JEDI Virtual K-12	charter						2020	grade_11											5											5
2319540	WI	Racine	school		777	Public Schools-Multidistrict Charters	Burlington Area		9803	JEDI Virtual K-12	charter						2020	grade_12											2											2
2319541	WI	Racine	school		777	Public Schools-Multidistrict Charters	Burlington Area		9803	JEDI Virtual K-12	charter						2020	grade_5											2											2
2319542	WI	Racine	school		777	Public Schools-Multidistrict Charters	Burlington Area		9803	JEDI Virtual K-12	charter						2020	grade_7											1											1
2319543	WI	Racine	school		777	Public Schools-Multidistrict Charters	Burlington Area		9803	JEDI Virtual K-12	charter						2020	grade_8											1											1
2319544	WI	Racine	school		777	Public Schools-Multidistrict Charters	Burlington Area		9803	JEDI Virtual K-12	charter						2020	grade_9											1											1
2321127	WI	Rock	school		1694	Public Schools-Multidistrict Charters	Evansville Community		9803	JEDI Virtual K-12	charter						2020	pk_12_total	3.0						1.0	2.0	*	*	3	3						1	2			3
2321128	WI	Rock	school		1694	Public Schools-Multidistrict Charters	Evansville Community		9803	JEDI Virtual K-12	charter						2020	grade_5											2											2
2321129	WI	Rock	school		1694	Public Schools-Multidistrict Charters	Evansville Community		9803	JEDI Virtual K-12	charter						2020	grade_7											1											1
2321363	WI	Jefferson	school		1883	Public Schools-Multidistrict Charters	Fort Atkinson		9803	JEDI Virtual K-12	charter						2020	pk_12_total											0											0
2322937	WI	Jefferson	school		2702	Public Schools-Multidistrict Charters	Jefferson		9803	JEDI Virtual K-12	charter						2020	pk_12_total	4.0						4.0		*	*	4	4						4				4
2322938	WI	Jefferson	school		2702	Public Schools-Multidistrict Charters	Jefferson		9803	JEDI Virtual K-12	charter						2020	grade_10											1											1
2322939	WI	Jefferson	school		2702	Public Schools-Multidistrict Charters	Jefferson		9803	JEDI Virtual K-12	charter						2020	grade_12											1											1
2322940	WI	Jefferson	school		2702	Public Schools-Multidistrict Charters	Jefferson		9803	JEDI Virtual K-12	charter						2020	grade_2											1											1
2322941	WI	Jefferson	school		2702	Public Schools-Multidistrict Charters	Jefferson		9803	JEDI Virtual K-12	charter						2020	grade_9											1											1
2323845	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	2020	pk_12_total	42.0	2.0	4.0	1.0	1.0	2.0	20.0	32.0	4	1	52	42	2	4	1	1	2	20	32	4	1	52
2323846	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	2020	grade_10											7											7
2323847	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	2020	grade_11											7											7
2323848	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	2020	grade_12											10											10
2323849	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	2020	grade_2											1											1
2323850	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	2020	grade_3											2											2
2323851	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	2020	grade_4											1											1
2323852	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	2020	grade_6											2											2
2323853	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	2020	grade_7											6											6
2323854	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	2020	grade_8											5											5
2323855	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	2020	grade_9											8											8
2323856	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	2020	kindergarten											3											3
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
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
2330558	WI	Dane	school		5621	Public Schools-Multidistrict Charters	Stoughton Area		9803	JEDI Virtual K-12	charter						2020	pk_12_total	24.0	1.0	1.0			1.0	10.0	17.0	12	2	27	24	1	1			1	10	17	12	2	27
2330559	WI	Dane	school		5621	Public Schools-Multidistrict Charters	Stoughton Area		9803	JEDI Virtual K-12	charter						2020	grade_10											5											5
2330560	WI	Dane	school		5621	Public Schools-Multidistrict Charters	Stoughton Area		9803	JEDI Virtual K-12	charter						2020	grade_11											5											5
2330561	WI	Dane	school		5621	Public Schools-Multidistrict Charters	Stoughton Area		9803	JEDI Virtual K-12	charter						2020	grade_12											7											7
2330562	WI	Dane	school		5621	Public Schools-Multidistrict Charters	Stoughton Area		9803	JEDI Virtual K-12	charter						2020	grade_3											1											1
2330563	WI	Dane	school		5621	Public Schools-Multidistrict Charters	Stoughton Area		9803	JEDI Virtual K-12	charter						2020	grade_4											1											1
2330564	WI	Dane	school		5621	Public Schools-Multidistrict Charters	Stoughton Area		9803	JEDI Virtual K-12	charter						2020	grade_6											1											1
2330565	WI	Dane	school		5621	Public Schools-Multidistrict Charters	Stoughton Area		9803	JEDI Virtual K-12	charter						2020	grade_7											3											3
2330566	WI	Dane	school		5621	Public Schools-Multidistrict Charters	Stoughton Area		9803	JEDI Virtual K-12	charter						2020	grade_8											1											1
2330567	WI	Dane	school		5621	Public Schools-Multidistrict Charters	Stoughton Area		9803	JEDI Virtual K-12	charter						2020	grade_9											3											3
2330674	WI	Dane	school		5656	Public Schools-Multidistrict Charters	Sun Prairie Area		9803	JEDI Virtual K-12	charter						2020	pk_12_total	24.0	4.0	1.0	1.0			15.0	15.0	9	3	30	24	4	1	1			15	15	9	3	30
2330675	WI	Dane	school		5656	Public Schools-Multidistrict Charters	Sun Prairie Area		9803	JEDI Virtual K-12	charter						2020	grade_1											2											2
2330676	WI	Dane	school		5656	Public Schools-Multidistrict Charters	Sun Prairie Area		9803	JEDI Virtual K-12	charter						2020	grade_10											2											2
2330677	WI	Dane	school		5656	Public Schools-Multidistrict Charters	Sun Prairie Area		9803	JEDI Virtual K-12	charter						2020	grade_11											8											8
2330678	WI	Dane	school		5656	Public Schools-Multidistrict Charters	Sun Prairie Area		9803	JEDI Virtual K-12	charter						2020	grade_12											7											7
2330679	WI	Dane	school		5656	Public Schools-Multidistrict Charters	Sun Prairie Area		9803	JEDI Virtual K-12	charter						2020	grade_5											2											2
2330680	WI	Dane	school		5656	Public Schools-Multidistrict Charters	Sun Prairie Area		9803	JEDI Virtual K-12	charter						2020	grade_7											4											4
2330681	WI	Dane	school		5656	Public Schools-Multidistrict Charters	Sun Prairie Area		9803	JEDI Virtual K-12	charter						2020	grade_8											1											1
2330682	WI	Dane	school		5656	Public Schools-Multidistrict Charters	Sun Prairie Area		9803	JEDI Virtual K-12	charter						2020	grade_9											4											4
2331420	WI	Jefferson	school		6118	Public Schools-Multidistrict Charters	Waterloo		9803	JEDI Virtual K-12	charter						2020	pk_12_total	2.0					1.0	3.0		*	*	3	2					1	3				3
2331421	WI	Jefferson	school		6118	Public Schools-Multidistrict Charters	Waterloo		9803	JEDI Virtual K-12	charter						2020	grade_1											1											1
2331422	WI	Jefferson	school		6118	Public Schools-Multidistrict Charters	Waterloo		9803	JEDI Virtual K-12	charter						2020	grade_7											1											1
2331423	WI	Jefferson	school		6118	Public Schools-Multidistrict Charters	Waterloo		9803	JEDI Virtual K-12	charter						2020	grade_9											1											1
2332531	WI	Walworth	school		6461	Public Schools-Multidistrict Charters	Whitewater Unified		9803	JEDI Virtual K-12 - Jefferson and Eastern Dane County Interactive	charter						2020	pk_12_total	8.0					1.0	3.0	6.0	*		9	8					1	3	6			9