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 (ccd_school_high_grade > :p2 or (ccd_school_high_grade = :p2 and rowid > :p1)) order by ccd_school_high_grade, 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	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
293827	WI	Marathon	school	5467	Public Schools-Multidistrict Charters	Spencer	9100	Rural Virtual Academy	charter	2016	grade_6												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
294070	WI	Marathon	school	5628	Public Schools-Multidistrict Charters	Stratford	9100	Rural Virtual Academy	charter	2016	pk_12_total	3.0								3.0	*	*	3	3								3			3
294071	WI	Marathon	school	5628	Public Schools-Multidistrict Charters	Stratford	9100	Rural Virtual Academy	charter	2016	grade_4												1												1
294072	WI	Marathon	school	5628	Public Schools-Multidistrict Charters	Stratford	9100	Rural Virtual Academy	charter	2016	grade_5												1												1
294073	WI	Marathon	school	5628	Public Schools-Multidistrict Charters	Stratford	9100	Rural Virtual Academy	charter	2016	grade_8												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
294288	WI	Milwaukee	school	8115	Non District Charter Schools	Tenor High School	400	Tenor High School	charter	2016	pk_12_total	26.0	82.0	135.0	3.0	2.0			118.0	130.0	211	28	248	26	82	135	3	2			118	130	211	28	248
294289	WI	Milwaukee	school	8115	Non District Charter Schools	Tenor High School	400	Tenor High School	charter	2016	grade_10												59												59
294290	WI	Milwaukee	school	8115	Non District Charter Schools	Tenor High School	400	Tenor High School	charter	2016	grade_11												52												52
294291	WI	Milwaukee	school	8115	Non District Charter Schools	Tenor High School	400	Tenor High School	charter	2016	grade_12												63												63
294292	WI	Milwaukee	school	8115	Non District Charter Schools	Tenor High School	400	Tenor High School	charter	2016	grade_9												74												74
294499	WI	Barron	school	5810	Public Schools-Multidistrict Charters	Turtle Lake	9410	North Star Academy	charter	2016	pk_12_total	1.0						1.0	2.0		*	*	2	1						1	2				2
294500	WI	Barron	school	5810	Public Schools-Multidistrict Charters	Turtle Lake	9410	North Star Academy	charter	2016	grade_11												1												1
294501	WI	Barron	school	5810	Public Schools-Multidistrict Charters	Turtle Lake	9410	North Star Academy	charter	2016	grade_12												1												1
294550	WI	Manitowoc	school	5824	Public Schools-Multidistrict Charters	Two Rivers Public	9120	Manitowoc County Comprehensive Charter School	charter	2016	pk_12_total	1.0							1.0		*	*	1	1							1				1
294551	WI	Manitowoc	school	5824	Public Schools-Multidistrict Charters	Two Rivers Public	9120	Manitowoc County Comprehensive Charter School	charter	2016	grade_8												1												1
294621	WI	Milwaukee	school	8124	Non District Charter Schools	Veritas High	400	Veritas High	charter	2016	pk_12_total	21.0	8.0	218.0	2.0	4.0			98.0	155.0	209	17	253	21	8	218	2	4			98	155	209	17	253
294622	WI	Milwaukee	school	8124	Non District Charter Schools	Veritas High	400	Veritas High	charter	2016	grade_10												75												75
294623	WI	Milwaukee	school	8124	Non District Charter Schools	Veritas High	400	Veritas High	charter	2016	grade_11												73												73
294624	WI	Milwaukee	school	8124	Non District Charter Schools	Veritas High	400	Veritas High	charter	2016	grade_12												52												52
294625	WI	Milwaukee	school	8124	Non District Charter Schools	Veritas High	400	Veritas High	charter	2016	grade_9												53												53
295109	WI	Waupaca	school	6195	Public Schools-Multidistrict Charters	Waupaca	9408	Waupaca County Charter	charter	2016	pk_12_total	3.0		1.0					4.0		*	*	4	3		1					4				4
295110	WI	Waupaca	school	6195	Public Schools-Multidistrict Charters	Waupaca	9408	Waupaca County Charter	charter	2016	grade_6												1												1
295111	WI	Waupaca	school	6195	Public Schools-Multidistrict Charters	Waupaca	9408	Waupaca County Charter	charter	2016	grade_8												3												3
295760	WI	Vernon	school	6321	Public Schools-Multidistrict Charters	Westby Area	9407	Vernon County Area Better Futures High	charter	2016	pk_12_total	2.0								2.0	*	*	2	2								2			2
295761	WI	Vernon	school	6321	Public Schools-Multidistrict Charters	Westby Area	9407	Vernon County Area Better Futures High	charter	2016	grade_10												1												1
295762	WI	Vernon	school	6321	Public Schools-Multidistrict Charters	Westby Area	9407	Vernon County Area Better Futures High	charter	2016	grade_11												1												1
296020	WI	Walworth	school	6482	Public Schools-Multidistrict Charters	Williams Bay	9401	Walworth Co Educ Alt High	charter	2016	pk_12_total	2.0					1.0		3.0		*	*	3	2					1		3				3
296021	WI	Walworth	school	6482	Public Schools-Multidistrict Charters	Williams Bay	9401	Walworth Co Educ Alt High	charter	2016	grade_12												3												3
296243	WI	Juneau	school	6713	Public Schools-Multidistrict Charters	Wonewoc-Union Center	9405	Juneau County Charter School	charter	2016	pk_12_total	1.0								1.0	*	*	1	1								1			1
296244	WI	Juneau	school	6713	Public Schools-Multidistrict Charters	Wonewoc-Union Center	9405	Juneau County Charter School	charter	2016	grade_10												1												1
325625	WI	Clark	school	7	Public Schools-Multidistrict Charters	Abbotsford	9100	Rural Virtual Academy	charter	2017	pk_12_total	1.0								1.0	*	*	1	1								1			1
325626	WI	Clark	school	7	Public Schools-Multidistrict Charters	Abbotsford	9100	Rural Virtual Academy	charter	2017	grade_4												1												1
325829	WI	Langlade	school	140	Public Schools-Multidistrict Charters	Antigo Unified	9100	Rural Virtual Academy	charter	2017	pk_12_total	13.0	1.0						8.0	6.0	6	3	14	13	1						8	6	6	3	14
325830	WI	Langlade	school	140	Public Schools-Multidistrict Charters	Antigo Unified	9100	Rural Virtual Academy	charter	2017	grade_10												1												1
325831	WI	Langlade	school	140	Public Schools-Multidistrict Charters	Antigo Unified	9100	Rural Virtual Academy	charter	2017	grade_11												5												5
325832	WI	Langlade	school	140	Public Schools-Multidistrict Charters	Antigo Unified	9100	Rural Virtual Academy	charter	2017	grade_4												1												1
325833	WI	Langlade	school	140	Public Schools-Multidistrict Charters	Antigo Unified	9100	Rural Virtual Academy	charter	2017	grade_6												2												2
325834	WI	Langlade	school	140	Public Schools-Multidistrict Charters	Antigo Unified	9100	Rural Virtual Academy	charter	2017	grade_8												3												3
325835	WI	Langlade	school	140	Public Schools-Multidistrict Charters	Antigo Unified	9100	Rural Virtual Academy	charter	2017	kindergarten_4_year_old												1												1
325836	WI	Langlade	school	140	Public Schools-Multidistrict Charters	Antigo Unified	9100	Rural Virtual Academy	charter	2017	kindergarten												1												1
326256	WI	Wood	school	203	Public Schools-Multidistrict Charters	Auburndale	9100	Rural Virtual Academy	charter	2017	pk_12_total	5.0							2.0	3.0	*	*	5	5							2	3			5
326257	WI	Wood	school	203	Public Schools-Multidistrict Charters	Auburndale	9100	Rural Virtual Academy	charter	2017	grade_3												1												1
326258	WI	Wood	school	203	Public Schools-Multidistrict Charters	Auburndale	9100	Rural Virtual Academy	charter	2017	grade_4												1												1
326259	WI	Wood	school	203	Public Schools-Multidistrict Charters	Auburndale	9100	Rural Virtual Academy	charter	2017	grade_7												1												1
326260	WI	Wood	school	203	Public Schools-Multidistrict Charters	Auburndale	9100	Rural Virtual Academy	charter	2017	grade_9												1												1
326261	WI	Wood	school	203	Public Schools-Multidistrict Charters	Auburndale	9100	Rural Virtual Academy	charter	2017	kindergarten												1												1
326415	WI	Barron	school	308	Public Schools-Multidistrict Charters	Barron Area	9410	North Star Academy	charter	2017	pk_12_total	14.0		1.0					10.0	5.0	2	2	15	14		1					10	5	2	2	15
326416	WI	Barron	school	308	Public Schools-Multidistrict Charters	Barron Area	9410	North Star Academy	charter	2017	grade_11												3												3
326417	WI	Barron	school	308	Public Schools-Multidistrict Charters	Barron Area	9410	North Star Academy	charter	2017	grade_12												12												12
326726	WI	Walworth	school	6013	Public Schools-Multidistrict Charters	Big Foot UHS	9401	Walworth Co Educ Alt High	charter	2017	pk_12_total	4.0		2.0					2.0	4.0	*	*	6	4		2					2	4			6
326727	WI	Walworth	school	6013	Public Schools-Multidistrict Charters	Big Foot UHS	9401	Walworth Co Educ Alt High	charter	2017	grade_11												2												2
326728	WI	Walworth	school	6013	Public Schools-Multidistrict Charters	Big Foot UHS	9401	Walworth Co Educ Alt High	charter	2017	grade_12												4												4
327364	WI	Barron	school	1080	Public Schools-Multidistrict Charters	Chetek-Weyerhaeuser Area	9410	North Star Academy	charter	2017	pk_12_total	10.0							6.0	4.0	*	1	10	10							6	4		1	10
327365	WI	Barron	school	1080	Public Schools-Multidistrict Charters	Chetek-Weyerhaeuser Area	9410	North Star Academy	charter	2017	grade_10												1												1
327366	WI	Barron	school	1080	Public Schools-Multidistrict Charters	Chetek-Weyerhaeuser Area	9410	North Star Academy	charter	2017	grade_11												2												2
327367	WI	Barron	school	1080	Public Schools-Multidistrict Charters	Chetek-Weyerhaeuser Area	9410	North Star Academy	charter	2017	grade_12												7												7
327548	WI	Clark	school	1162	Public Schools-Multidistrict Charters	Colby	9100	Rural Virtual Academy	charter	2017	pk_12_total	2.0								2.0	*	*	2	2								2			2
327549	WI	Clark	school	1162	Public Schools-Multidistrict Charters	Colby	9100	Rural Virtual Academy	charter	2017	grade_11												1												1
327550	WI	Clark	school	1162	Public Schools-Multidistrict Charters	Colby	9100	Rural Virtual Academy	charter	2017	grade_7												1												1
327995	WI	Walworth	school	1380	Public Schools-Multidistrict Charters	Delavan-Darien	9401	Walworth Co Educ Alt High	charter	2017	pk_12_total	4.0		2.0					2.0	4.0	*	*	6	4		2					2	4			6
327996	WI	Walworth	school	1380	Public Schools-Multidistrict Charters	Delavan-Darien	9401	Walworth Co Educ Alt High	charter	2017	grade_11												1												1
327997	WI	Walworth	school	1380	Public Schools-Multidistrict Charters	Delavan-Darien	9401	Walworth Co Educ Alt High	charter	2017	grade_12												5												5
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
330920	WI	Vernon	school	5960	Public Schools-Multidistrict Charters	Kickapoo Area	9407	Vernon County Area Better Futures High	charter	2017	pk_12_total	1.0								1.0	*	*	1	1								1			1
330921	WI	Vernon	school	5960	Public Schools-Multidistrict Charters	Kickapoo Area	9407	Vernon County Area Better Futures High	charter	2017	grade_12												1												1
331160	WI	Vernon	school	2863	Public Schools-Multidistrict Charters	La Farge	9407	Vernon County Area Better Futures High	charter	2017	pk_12_total	1.0							1.0		*	*	1	1							1				1
331161	WI	Vernon	school	2863	Public Schools-Multidistrict Charters	La Farge	9407	Vernon County Area Better Futures High	charter	2017	grade_12												1												1
331231	WI	Walworth	school	2884	Public Schools-Multidistrict Charters	Lake Geneva-Genoa City UHS	9401	Walworth Co Educ Alt High	charter	2017	pk_12_total	20.0		2.0				2.0	12.0	12.0	5	1	24	20		2				2	12	12	5	1	24
331232	WI	Walworth	school	2884	Public Schools-Multidistrict Charters	Lake Geneva-Genoa City UHS	9401	Walworth Co Educ Alt High	charter	2017	grade_11												5												5
331233	WI	Walworth	school	2884	Public Schools-Multidistrict Charters	Lake Geneva-Genoa City UHS	9401	Walworth Co Educ Alt High	charter	2017	grade_12												19												19
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
331824	WI	Waupaca	school	3276	Public Schools-Multidistrict Charters	Manawa	9408	Waupaca County Charter	charter	2017	pk_12_total	1.0							1.0		*	*	1	1							1				1
331825	WI	Waupaca	school	3276	Public Schools-Multidistrict Charters	Manawa	9408	Waupaca County Charter	charter	2017	grade_10												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