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 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	hispanic	asian	multiracial	male	female	low_income	disability	total	white_int	hispanic_int	asian_int	multiracial_int	male_int	female_int	low_income_int	disability_int	total_int
116482	WI	Jefferson	school		2702	Public Schools-Multidistrict Charters	Jefferson		9803	JEDI Virtual K-12	charter						2015	pk_12_total	3.0				1.0	2.0	*	*	3	3				1	2			3
116483	WI	Jefferson	school		2702	Public Schools-Multidistrict Charters	Jefferson		9803	JEDI Virtual K-12	charter						2015	grade_10									1									1
116484	WI	Jefferson	school		2702	Public Schools-Multidistrict Charters	Jefferson		9803	JEDI Virtual K-12	charter						2015	grade_11									1									1
116485	WI	Jefferson	school		2702	Public Schools-Multidistrict Charters	Jefferson		9803	JEDI Virtual K-12	charter						2015	grade_9									1									1
118239	WI	Juneau	school		3360	Public Schools-Multidistrict Charters	Mauston		9803	JEDI Virtual K-12	charter						2015	pk_12_total	8.0			1.0		9.0	3		9	8			1		9	3		9
118240	WI	Juneau	school		3360	Public Schools-Multidistrict Charters	Mauston		9803	JEDI Virtual K-12	charter						2015	grade_10									1									1
118241	WI	Juneau	school		3360	Public Schools-Multidistrict Charters	Mauston		9803	JEDI Virtual K-12	charter						2015	grade_11									3									3
118242	WI	Juneau	school		3360	Public Schools-Multidistrict Charters	Mauston		9803	JEDI Virtual K-12	charter						2015	grade_12									2									2
118243	WI	Juneau	school		3360	Public Schools-Multidistrict Charters	Mauston		9803	JEDI Virtual K-12	charter						2015	grade_3									1									1
118244	WI	Juneau	school		3360	Public Schools-Multidistrict Charters	Mauston		9803	JEDI Virtual K-12	charter						2015	grade_8									1									1
118245	WI	Juneau	school		3360	Public Schools-Multidistrict Charters	Mauston		9803	JEDI Virtual K-12	charter						2015	grade_9									1									1
124103	WI	Dane	school		5621	Public Schools-Multidistrict Charters	Stoughton Area		9803	JEDI Virtual K-12	charter						2015	pk_12_total	20.0	2.0		1.0	6.0	17.0	5	2	23	20	2		1	6	17	5	2	23
124104	WI	Dane	school		5621	Public Schools-Multidistrict Charters	Stoughton Area		9803	JEDI Virtual K-12	charter						2015	grade_1									1									1
124105	WI	Dane	school		5621	Public Schools-Multidistrict Charters	Stoughton Area		9803	JEDI Virtual K-12	charter						2015	grade_10									4									4
124106	WI	Dane	school		5621	Public Schools-Multidistrict Charters	Stoughton Area		9803	JEDI Virtual K-12	charter						2015	grade_11									7									7
124107	WI	Dane	school		5621	Public Schools-Multidistrict Charters	Stoughton Area		9803	JEDI Virtual K-12	charter						2015	grade_12									5									5
124108	WI	Dane	school		5621	Public Schools-Multidistrict Charters	Stoughton Area		9803	JEDI Virtual K-12	charter						2015	grade_8									2									2
124109	WI	Dane	school		5621	Public Schools-Multidistrict Charters	Stoughton Area		9803	JEDI Virtual K-12	charter						2015	grade_9									3									3
124110	WI	Dane	school		5621	Public Schools-Multidistrict Charters	Stoughton Area		9803	JEDI Virtual K-12	charter						2015	kindergarten									1									1
124213	WI	Dane	school		5656	Public Schools-Multidistrict Charters	Sun Prairie Area		9803	JEDI Virtual K-12	charter						2015	pk_12_total	14.0	1.0	1.0		10.0	6.0		1	16	14	1	1		10	6		1	16
124214	WI	Dane	school		5656	Public Schools-Multidistrict Charters	Sun Prairie Area		9803	JEDI Virtual K-12	charter						2015	grade_10									1									1
124215	WI	Dane	school		5656	Public Schools-Multidistrict Charters	Sun Prairie Area		9803	JEDI Virtual K-12	charter						2015	grade_11									2									2
124216	WI	Dane	school		5656	Public Schools-Multidistrict Charters	Sun Prairie Area		9803	JEDI Virtual K-12	charter						2015	grade_12									4									4
124217	WI	Dane	school		5656	Public Schools-Multidistrict Charters	Sun Prairie Area		9803	JEDI Virtual K-12	charter						2015	grade_2									1									1
124218	WI	Dane	school		5656	Public Schools-Multidistrict Charters	Sun Prairie Area		9803	JEDI Virtual K-12	charter						2015	grade_3									1									1
124219	WI	Dane	school		5656	Public Schools-Multidistrict Charters	Sun Prairie Area		9803	JEDI Virtual K-12	charter						2015	grade_5									1									1
124220	WI	Dane	school		5656	Public Schools-Multidistrict Charters	Sun Prairie Area		9803	JEDI Virtual K-12	charter						2015	grade_6									2									2
124221	WI	Dane	school		5656	Public Schools-Multidistrict Charters	Sun Prairie Area		9803	JEDI Virtual K-12	charter						2015	grade_7									1									1
124222	WI	Dane	school		5656	Public Schools-Multidistrict Charters	Sun Prairie Area		9803	JEDI Virtual K-12	charter						2015	grade_8									1									1
124223	WI	Dane	school		5656	Public Schools-Multidistrict Charters	Sun Prairie Area		9803	JEDI Virtual K-12	charter						2015	grade_9									1									1
124224	WI	Dane	school		5656	Public Schools-Multidistrict Charters	Sun Prairie Area		9803	JEDI Virtual K-12	charter						2015	kindergarten									1									1
125994	WI	Walworth	school	5516680	6461	Public school	Whitewater Unified	551668002901	9803	JEDI Virtual K-12	charter	Alternative Education School	Yes	4.0	KG	12	2015	pk_12_total	23.0	2.0		1.0	12.0	14.0	5		26	23	2		1	12	14	5		26
125995	WI	Walworth	school	5516680	6461	Public school	Whitewater Unified	551668002901	9803	JEDI Virtual K-12	charter	Alternative Education School	Yes	4.0	KG	12	2015	grade_10									6									6
125996	WI	Walworth	school	5516680	6461	Public school	Whitewater Unified	551668002901	9803	JEDI Virtual K-12	charter	Alternative Education School	Yes	4.0	KG	12	2015	grade_11									6									6
125997	WI	Walworth	school	5516680	6461	Public school	Whitewater Unified	551668002901	9803	JEDI Virtual K-12	charter	Alternative Education School	Yes	4.0	KG	12	2015	grade_12									6									6
125998	WI	Walworth	school	5516680	6461	Public school	Whitewater Unified	551668002901	9803	JEDI Virtual K-12	charter	Alternative Education School	Yes	4.0	KG	12	2015	grade_4									2									2
125999	WI	Walworth	school	5516680	6461	Public school	Whitewater Unified	551668002901	9803	JEDI Virtual K-12	charter	Alternative Education School	Yes	4.0	KG	12	2015	grade_5									2									2
126000	WI	Walworth	school	5516680	6461	Public school	Whitewater Unified	551668002901	9803	JEDI Virtual K-12	charter	Alternative Education School	Yes	4.0	KG	12	2015	grade_9									4									4
284909	WI	Jefferson	school		1883	Public Schools-Multidistrict Charters	Fort Atkinson		9803	JEDI Virtual K-12	charter						2016	pk_12_total	9.0				4.0	5.0	2	*	9	9				4	5	2		9
284910	WI	Jefferson	school		1883	Public Schools-Multidistrict Charters	Fort Atkinson		9803	JEDI Virtual K-12	charter						2016	grade_1									1									1
284911	WI	Jefferson	school		1883	Public Schools-Multidistrict Charters	Fort Atkinson		9803	JEDI Virtual K-12	charter						2016	grade_10									3									3
284912	WI	Jefferson	school		1883	Public Schools-Multidistrict Charters	Fort Atkinson		9803	JEDI Virtual K-12	charter						2016	grade_12									1									1
284913	WI	Jefferson	school		1883	Public Schools-Multidistrict Charters	Fort Atkinson		9803	JEDI Virtual K-12	charter						2016	grade_4									1									1
284914	WI	Jefferson	school		1883	Public Schools-Multidistrict Charters	Fort Atkinson		9803	JEDI Virtual K-12	charter						2016	grade_6									1									1
284915	WI	Jefferson	school		1883	Public Schools-Multidistrict Charters	Fort Atkinson		9803	JEDI Virtual K-12	charter						2016	grade_7									1									1
284916	WI	Jefferson	school		1883	Public Schools-Multidistrict Charters	Fort Atkinson		9803	JEDI Virtual K-12	charter						2016	grade_8									1									1
286484	WI	Jefferson	school		2702	Public Schools-Multidistrict Charters	Jefferson		9803	JEDI Virtual K-12	charter						2016	pk_12_total	6.0	1.0			4.0	3.0			7	6	1			4	3			7
286485	WI	Jefferson	school		2702	Public Schools-Multidistrict Charters	Jefferson		9803	JEDI Virtual K-12	charter						2016	grade_10									1									1
286486	WI	Jefferson	school		2702	Public Schools-Multidistrict Charters	Jefferson		9803	JEDI Virtual K-12	charter						2016	grade_11									2									2
286487	WI	Jefferson	school		2702	Public Schools-Multidistrict Charters	Jefferson		9803	JEDI Virtual K-12	charter						2016	grade_12									1									1
286488	WI	Jefferson	school		2702	Public Schools-Multidistrict Charters	Jefferson		9803	JEDI Virtual K-12	charter						2016	grade_7									1									1
286489	WI	Jefferson	school		2702	Public Schools-Multidistrict Charters	Jefferson		9803	JEDI Virtual K-12	charter						2016	grade_8									1									1
286490	WI	Jefferson	school		2702	Public Schools-Multidistrict Charters	Jefferson		9803	JEDI Virtual K-12	charter						2016	grade_9									1									1
287377	WI	Jefferson	school		2898	Public Schools-Multidistrict Charters	Lake Mills Area		9803	JEDI Virtual K-12	charter						2016	pk_12_total	1.0					1.0	*	*	1	1					1			1
287378	WI	Jefferson	school		2898	Public Schools-Multidistrict Charters	Lake Mills Area		9803	JEDI Virtual K-12	charter						2016	grade_4									1									1
288229	WI	Juneau	school		3360	Public Schools-Multidistrict Charters	Mauston		9803	JEDI Virtual K-12	charter						2016	pk_12_total	12.0	1.0			5.0	8.0	6	1	13	12	1			5	8	6	1	13
288230	WI	Juneau	school		3360	Public Schools-Multidistrict Charters	Mauston		9803	JEDI Virtual K-12	charter						2016	grade_1									1									1
288231	WI	Juneau	school		3360	Public Schools-Multidistrict Charters	Mauston		9803	JEDI Virtual K-12	charter						2016	grade_10									2									2
288232	WI	Juneau	school		3360	Public Schools-Multidistrict Charters	Mauston		9803	JEDI Virtual K-12	charter						2016	grade_12									2									2
288233	WI	Juneau	school		3360	Public Schools-Multidistrict Charters	Mauston		9803	JEDI Virtual K-12	charter						2016	grade_4									2									2
288234	WI	Juneau	school		3360	Public Schools-Multidistrict Charters	Mauston		9803	JEDI Virtual K-12	charter						2016	grade_8									2									2
288235	WI	Juneau	school		3360	Public Schools-Multidistrict Charters	Mauston		9803	JEDI Virtual K-12	charter						2016	grade_9									2									2
288236	WI	Juneau	school		3360	Public Schools-Multidistrict Charters	Mauston		9803	JEDI Virtual K-12	charter						2016	kindergarten									1									1
288237	WI	Juneau	school		3360	Public Schools-Multidistrict Charters	Mauston		9803	JEDI Virtual K-12	charter						2016	pre_kindergarten									1									1
290385	WI	Green	school		3682	Public Schools-Multidistrict Charters	Monroe		9803	JEDI Virtual K-12	charter						2016	pk_12_total		1.0			1.0		*	*	1		1			1				1
290386	WI	Green	school		3682	Public Schools-Multidistrict Charters	Monroe		9803	JEDI Virtual K-12	charter						2016	grade_10									1									1
294038	WI	Dane	school		5621	Public Schools-Multidistrict Charters	Stoughton Area		9803	JEDI Virtual K-12	charter						2016	pk_12_total	12.0		1.0	1.0	2.0	12.0	5	1	14	12		1	1	2	12	5	1	14
294039	WI	Dane	school		5621	Public Schools-Multidistrict Charters	Stoughton Area		9803	JEDI Virtual K-12	charter						2016	grade_1									1									1
294040	WI	Dane	school		5621	Public Schools-Multidistrict Charters	Stoughton Area		9803	JEDI Virtual K-12	charter						2016	grade_10									1									1
294041	WI	Dane	school		5621	Public Schools-Multidistrict Charters	Stoughton Area		9803	JEDI Virtual K-12	charter						2016	grade_11									5									5
294042	WI	Dane	school		5621	Public Schools-Multidistrict Charters	Stoughton Area		9803	JEDI Virtual K-12	charter						2016	grade_12									5									5
294043	WI	Dane	school		5621	Public Schools-Multidistrict Charters	Stoughton Area		9803	JEDI Virtual K-12	charter						2016	grade_7									1									1
294044	WI	Dane	school		5621	Public Schools-Multidistrict Charters	Stoughton Area		9803	JEDI Virtual K-12	charter						2016	grade_9									1									1
294147	WI	Dane	school		5656	Public Schools-Multidistrict Charters	Sun Prairie Area		9803	JEDI Virtual K-12	charter						2016	pk_12_total	11.0		1.0	1.0	7.0	6.0	1		13	11		1	1	7	6	1		13
294148	WI	Dane	school		5656	Public Schools-Multidistrict Charters	Sun Prairie Area		9803	JEDI Virtual K-12	charter						2016	grade_1									1									1
294149	WI	Dane	school		5656	Public Schools-Multidistrict Charters	Sun Prairie Area		9803	JEDI Virtual K-12	charter						2016	grade_10									3									3
294150	WI	Dane	school		5656	Public Schools-Multidistrict Charters	Sun Prairie Area		9803	JEDI Virtual K-12	charter						2016	grade_11									1									1
294151	WI	Dane	school		5656	Public Schools-Multidistrict Charters	Sun Prairie Area		9803	JEDI Virtual K-12	charter						2016	grade_12									3									3
294152	WI	Dane	school		5656	Public Schools-Multidistrict Charters	Sun Prairie Area		9803	JEDI Virtual K-12	charter						2016	grade_3									1									1
294153	WI	Dane	school		5656	Public Schools-Multidistrict Charters	Sun Prairie Area		9803	JEDI Virtual K-12	charter						2016	grade_4									1									1
294154	WI	Dane	school		5656	Public Schools-Multidistrict Charters	Sun Prairie Area		9803	JEDI Virtual K-12	charter						2016	grade_6									1									1
294155	WI	Dane	school		5656	Public Schools-Multidistrict Charters	Sun Prairie Area		9803	JEDI Virtual K-12	charter						2016	grade_7									1									1
294156	WI	Dane	school		5656	Public Schools-Multidistrict Charters	Sun Prairie Area		9803	JEDI Virtual K-12	charter						2016	grade_9									1									1
330367	WI	Jefferson	school		2702	Public Schools-Multidistrict Charters	Jefferson		9803	JEDI Virtual K-12	charter						2017	pk_12_total	5.0				2.0	3.0	*	*	5	5				2	3			5
330368	WI	Jefferson	school		2702	Public Schools-Multidistrict Charters	Jefferson		9803	JEDI Virtual K-12	charter						2017	grade_11									3									3
330369	WI	Jefferson	school		2702	Public Schools-Multidistrict Charters	Jefferson		9803	JEDI Virtual K-12	charter						2017	grade_12									2									2
331251	WI	Jefferson	school		2898	Public Schools-Multidistrict Charters	Lake Mills Area		9803	JEDI Virtual K-12	charter						2017	pk_12_total	1.0				1.0		*	*	1	1				1				1
331252	WI	Jefferson	school		2898	Public Schools-Multidistrict Charters	Lake Mills Area		9803	JEDI Virtual K-12	charter						2017	grade_8									1									1
332095	WI	Juneau	school		3360	Public Schools-Multidistrict Charters	Mauston		9803	JEDI Virtual K-12							2017	pk_12_total	8.0				2.0	6.0	1	1	8	8				2	6	1	1	8
332096	WI	Juneau	school		3360	Public Schools-Multidistrict Charters	Mauston		9803	JEDI Virtual K-12							2017	grade_10									1									1
332097	WI	Juneau	school		3360	Public Schools-Multidistrict Charters	Mauston		9803	JEDI Virtual K-12							2017	grade_11									1									1
332098	WI	Juneau	school		3360	Public Schools-Multidistrict Charters	Mauston		9803	JEDI Virtual K-12							2017	grade_12									1									1
332099	WI	Juneau	school		3360	Public Schools-Multidistrict Charters	Mauston		9803	JEDI Virtual K-12							2017	grade_2									1									1
332100	WI	Juneau	school		3360	Public Schools-Multidistrict Charters	Mauston		9803	JEDI Virtual K-12							2017	grade_5									3									3
332101	WI	Juneau	school		3360	Public Schools-Multidistrict Charters	Mauston		9803	JEDI Virtual K-12							2017	kindergarten_4_year_old									1									1
334256	WI	Green	school		3682	Public Schools-Multidistrict Charters	Monroe		9803	JEDI Virtual K-12	charter						2017	pk_12_total	3.0	1.0			1.0	3.0	*	*	4	3	1			1	3			4
334257	WI	Green	school		3682	Public Schools-Multidistrict Charters	Monroe		9803	JEDI Virtual K-12	charter						2017	grade_10									2									2
334258	WI	Green	school		3682	Public Schools-Multidistrict Charters	Monroe		9803	JEDI Virtual K-12	charter						2017	grade_11									1									1
334259	WI	Green	school		3682	Public Schools-Multidistrict Charters	Monroe		9803	JEDI Virtual K-12	charter						2017	grade_8									1									1
337942	WI	Dane	school		5621	Public Schools-Multidistrict Charters	Stoughton Area		9803	JEDI Virtual K-12	charter						2017	pk_12_total	12.0	2.0		2.0	6.0	10.0	2	4	16	12	2		2	6	10	2	4	16
337943	WI	Dane	school		5621	Public Schools-Multidistrict Charters	Stoughton Area		9803	JEDI Virtual K-12	charter						2017	grade_10									2									2