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 "grade" = :p0 and "state" = :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	total	total_int
112847	WI	Walworth	school	6013	Public Schools-Multidistrict Charters	Big Foot UHS	9401	Walworth Co Educ Alt High	charter	2015	grade_12	13	13
113283	WI	Barron	school	903	Public Schools-Multidistrict Charters	Cameron	9410	North Star Academy	charter	2015	grade_12	8	8
113482	WI	Barron	school	1080	Public Schools-Multidistrict Charters	Chetek-Weyerhaeuser Area	9410	North Star Academy	charter	2015	grade_12	7	7
114105	WI	Walworth	school	1380	Public Schools-Multidistrict Charters	Delavan-Darien	9401	Walworth Co Educ Alt High	charter	2015	grade_12	8	8
117292	WI	Vernon	school	2863	Public Schools-Multidistrict Charters	La Farge	9407	Vernon County Area Better Futures High	charter	2015	grade_12	1	1
117368	WI	Walworth	school	2884	Public Schools-Multidistrict Charters	Lake Geneva-Genoa City UHS	9401	Walworth Co Educ Alt High	charter	2015	grade_12	24	24
118242	WI	Juneau	school	3360	Public Schools-Multidistrict Charters	Mauston	9803	JEDI Virtual K-12	charter	2015	grade_12	2	2
120663	WI	Juneau	school	3871	Public Schools-Multidistrict Charters	Necedah Area	9405	Juneau County Charter School	charter	2015	grade_12	5	5
124107	WI	Dane	school	5621	Public Schools-Multidistrict Charters	Stoughton Area	9803	JEDI Virtual K-12	charter	2015	grade_12	5	5
124216	WI	Dane	school	5656	Public Schools-Multidistrict Charters	Sun Prairie Area	9803	JEDI Virtual K-12	charter	2015	grade_12	4	4
124567	WI	Barron	school	5810	Public Schools-Multidistrict Charters	Turtle Lake	9410	North Star Academy	charter	2015	grade_12	3	3
125821	WI	Vernon	school	6321	Public Schools-Multidistrict Charters	Westby Area	9407	Vernon County Area Better Futures High	charter	2015	grade_12	1	1
126306	WI	Juneau	school	6713	Public Schools-Multidistrict Charters	Wonewoc-Union Center	9405	Juneau County Charter School	charter	2015	grade_12	1	1
282519	WI	Barron	school	308	Public Schools-Multidistrict Charters	Barron Area	9410	North Star Academy	charter	2016	grade_12	7	7
282825	WI	Walworth	school	6013	Public Schools-Multidistrict Charters	Big Foot UHS	9401	Walworth Co Educ Alt High	charter	2016	grade_12	10	10
283460	WI	Barron	school	1080	Public Schools-Multidistrict Charters	Chetek-Weyerhaeuser Area	9410	North Star Academy	charter	2016	grade_12	8	8
284084	WI	Walworth	school	1380	Public Schools-Multidistrict Charters	Delavan-Darien	9401	Walworth Co Educ Alt High	charter	2016	grade_12	2	2
284912	WI	Jefferson	school	1883	Public Schools-Multidistrict Charters	Fort Atkinson	9803	JEDI Virtual K-12	charter	2016	grade_12	1	1
286487	WI	Jefferson	school	2702	Public Schools-Multidistrict Charters	Jefferson	9803	JEDI Virtual K-12	charter	2016	grade_12	1	1
287360	WI	Walworth	school	2884	Public Schools-Multidistrict Charters	Lake Geneva-Genoa City UHS	9401	Walworth Co Educ Alt High	charter	2016	grade_12	14	14
288232	WI	Juneau	school	3360	Public Schools-Multidistrict Charters	Mauston	9803	JEDI Virtual K-12	charter	2016	grade_12	2	2
290624	WI	Juneau	school	3871	Public Schools-Multidistrict Charters	Necedah Area	9405	Juneau County Charter School	charter	2016	grade_12	3	3
294042	WI	Dane	school	5621	Public Schools-Multidistrict Charters	Stoughton Area	9803	JEDI Virtual K-12	charter	2016	grade_12	5	5
294151	WI	Dane	school	5656	Public Schools-Multidistrict Charters	Sun Prairie Area	9803	JEDI Virtual K-12	charter	2016	grade_12	3	3
294291	WI	Milwaukee	school	8115	Non District Charter Schools	Tenor High School	400	Tenor High School	charter	2016	grade_12	63	63
294501	WI	Barron	school	5810	Public Schools-Multidistrict Charters	Turtle Lake	9410	North Star Academy	charter	2016	grade_12	1	1
294624	WI	Milwaukee	school	8124	Non District Charter Schools	Veritas High	400	Veritas High	charter	2016	grade_12	52	52
296021	WI	Walworth	school	6482	Public Schools-Multidistrict Charters	Williams Bay	9401	Walworth Co Educ Alt High	charter	2016	grade_12	3	3
326417	WI	Barron	school	308	Public Schools-Multidistrict Charters	Barron Area	9410	North Star Academy	charter	2017	grade_12	12	12
326728	WI	Walworth	school	6013	Public Schools-Multidistrict Charters	Big Foot UHS	9401	Walworth Co Educ Alt High	charter	2017	grade_12	4	4
327367	WI	Barron	school	1080	Public Schools-Multidistrict Charters	Chetek-Weyerhaeuser Area	9410	North Star Academy	charter	2017	grade_12	7	7
327997	WI	Walworth	school	1380	Public Schools-Multidistrict Charters	Delavan-Darien	9401	Walworth Co Educ Alt High	charter	2017	grade_12	5	5
330369	WI	Jefferson	school	2702	Public Schools-Multidistrict Charters	Jefferson	9803	JEDI Virtual K-12	charter	2017	grade_12	2	2
330921	WI	Vernon	school	5960	Public Schools-Multidistrict Charters	Kickapoo Area	9407	Vernon County Area Better Futures High	charter	2017	grade_12	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
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
332098	WI	Juneau	school	3360	Public Schools-Multidistrict Charters	Mauston	9803	JEDI Virtual K-12		2017	grade_12	1	1
334497	WI	Juneau	school	3871	Public Schools-Multidistrict Charters	Necedah Area	9405	Juneau County Charter School	charter	2017	grade_12	1	1
337945	WI	Dane	school	5621	Public Schools-Multidistrict Charters	Stoughton Area	9803	JEDI Virtual K-12	charter	2017	grade_12	5	5
338054	WI	Dane	school	5656	Public Schools-Multidistrict Charters	Sun Prairie Area	9803	JEDI Virtual K-12	charter	2017	grade_12	1	1
338404	WI	Barron	school	5810	Public Schools-Multidistrict Charters	Turtle Lake	9410	North Star Academy	charter	2017	grade_12	3	3
2318330	WI	Langlade	school	140	Public Schools-Multidistrict Charters	Antigo Unified	9100	Rural Virtual Academy	charter	2020	grade_12	4	4
2318689	WI	Ashland	school	170	Public Schools-Multidistrict Charters	Ashland	9100	Rural Virtual Academy		2020	grade_12	1	1
2318759	WI	Wood	school	203	Public Schools-Multidistrict Charters	Auburndale	9100	Rural Virtual Academy	charter	2020	grade_12	4	4
2318916	WI	Barron	school	308	Public Schools-Multidistrict Charters	Barron Area	9410	North Star Academy	charter	2020	grade_12	4	4
2319223	WI	Walworth	school	6013	Public Schools-Multidistrict Charters	Big Foot UHS	9401	Walworth Co Educ Alt High	charter	2020	grade_12	2	2
2319389	WI	Shawano	school	623	Public Schools-Multidistrict Charters	Bowler	9100	Rural Virtual Academy	charter	2020	grade_12	6	6
2319540	WI	Racine	school	777	Public Schools-Multidistrict Charters	Burlington Area	9803	JEDI Virtual K-12	charter	2020	grade_12	2	2
2319897	WI	Barron	school	1080	Public Schools-Multidistrict Charters	Chetek-Weyerhaeuser Area	9410	North Star Academy	charter	2020	grade_12	4	4
2320080	WI	Clark	school	1162	Public Schools-Multidistrict Charters	Colby	9100	Rural Virtual Academy	charter	2020	grade_12	2	2
2322939	WI	Jefferson	school	2702	Public Schools-Multidistrict Charters	Jefferson	9803	JEDI Virtual K-12	charter	2020	grade_12	1	1
2323737	WI	Vernon	school	2863	Public Schools-Multidistrict Charters	La Farge	9407	Vernon County Area Better Futures High	charter	2020	grade_12	1	1
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
2324083	WI	Kewaunee	school	3220	Public Schools-Multidistrict Charters	Luxemburg-Casco	9803	JEDI Virtual K-12	charter	2020	grade_12	1	1
2324698	WI	Wood	school	3339	Public Schools-Multidistrict Charters	Marshfield Unified	9100	Rural Virtual Academy	charter	2020	grade_12	6	6
2324730	WI	Juneau	school	3360	Public Schools-Multidistrict Charters	Mauston	9803	JEDI Virtual K-12	charter	2020	grade_12	1	1
2326862	WI	Green	school	3682	Public Schools-Multidistrict Charters	Monroe	9803	JEDI Virtual K-12	charter	2020	grade_12	2	2
2326962	WI	Marathon	school	3787	Public Schools-Multidistrict Charters	Mosinee	9100	Rural Virtual Academy	charter	2020	grade_12	12	12
2328225	WI	Clark	school	4207	Public Schools-Multidistrict Charters	Owen-Withee	9100	Rural Virtual Academy	charter	2020	grade_12	1	1
2328420	WI	Price	school	4347	Public Schools-Multidistrict Charters	Phillips	9100	Rural Virtual Academy		2020	grade_12	1	1
2328447	WI	Wood	school	4368	Public Schools-Multidistrict Charters	Pittsville	9100	Rural Virtual Academy	charter	2020	grade_12	3	3
2328724	WI	Price	school	4571	Public Schools-Multidistrict Charters	Prentice	9100	Rural Virtual Academy	charter	2020	grade_12	3	3
2329220	WI	Taylor	school	4795	Public Schools-Multidistrict Charters	Rib Lake	9100	Rural Virtual Academy	charter	2020	grade_12	1	1
2330395	WI	Chippewa	school	5593	Public Schools-Multidistrict Charters	Stanley-Boyd Area	9419	eSucceed Charter School	charter	2020	grade_12	1	1
2330561	WI	Dane	school	5621	Public Schools-Multidistrict Charters	Stoughton Area	9803	JEDI Virtual K-12	charter	2020	grade_12	7	7
2330678	WI	Dane	school	5656	Public Schools-Multidistrict Charters	Sun Prairie Area	9803	JEDI Virtual K-12	charter	2020	grade_12	7	7
2330834	WI	Clark	school	5726	Public Schools-Multidistrict Charters	Thorp	9100	Rural Virtual Academy	charter	2020	grade_12	1	1
2330943	WI	Monroe	school	5747	Public Schools-Multidistrict Charters	Tomah Area	9100	Rural Virtual Academy	charter	2020	grade_12	7	7
2331074	WI	Barron	school	5810	Public Schools-Multidistrict Charters	Turtle Lake	9410	North Star Academy	charter	2020	grade_12	3	3
2332356	WI	Vernon	school	6321	Public Schools-Multidistrict Charters	Westby Area	9407	Vernon County Area Better Futures High	charter	2020	grade_12	2	2
2333126	WI	Langlade	school	140	Public Schools-Multidistrict Charters	Antigo Unified	9100	Rural Virtual Academy	charter	2021	grade_12	19	19
2333471	WI	Ashland	school	170	Public Schools-Multidistrict Charters	Ashland	9100	Rural Virtual Academy		2021	grade_12	1	1
2333541	WI	Wood	school	203	Public Schools-Multidistrict Charters	Auburndale	9100	Rural Virtual Academy	charter	2021	grade_12	3	3
2333700	WI	Barron	school	308	Public Schools-Multidistrict Charters	Barron Area	9410	North Star Academy	charter	2021	grade_12	7	7
2333939	WI	Rock	school	422	Public Schools-Multidistrict Charters	Beloit Turner	9803	JEDI Virtual K-12	charter	2021	grade_12	2	2
2334172	WI	Shawano	school	623	Public Schools-Multidistrict Charters	Bowler	9100	Rural Virtual Academy	charter	2021	grade_12	1	1
2334320	WI	Racine	school	777	Public Schools-Multidistrict Charters	Burlington Area	9803	JEDI Virtual K-12	charter	2021	grade_12	34	34
2334395	WI	Chippewa	school	870	Public Schools-Multidistrict Charters	Cadott Community	9419	eSucceed Charter School	charter	2021	grade_12	5	5
2334645	WI	Price	school	1071	Public Schools-Multidistrict Charters	Chequamegon	9100	Rural Virtual Academy	charter	2021	grade_12	2	2
2334682	WI	Barron	school	1080	Public Schools-Multidistrict Charters	Chetek-Weyerhaeuser Area	9410	North Star Academy	charter	2021	grade_12	7	7
2334864	WI	Clark	school	1162	Public Schools-Multidistrict Charters	Colby	9100	Rural Virtual Academy	charter	2021	grade_12	6	6
2334950	WI	Chippewa	school	1204	Public Schools-Multidistrict Charters	Cornell	9419	eSucceed Charter School	charter	2021	grade_12	3	3
2335676	WI	Rock	school	1568	Public Schools-Multidistrict Charters	Edgerton	9803	JEDI Virtual K-12	charter	2021	grade_12	2	2
2335713	WI	Langlade	school	1582	Public Schools-Multidistrict Charters	Elcho	9100	Rural Virtual Academy	charter	2021	grade_12	2	2
2335958	WI	Rock	school	1694	Public Schools-Multidistrict Charters	Evansville Community	9803	JEDI Virtual K-12	charter	2021	grade_12	1	1
2337334	WI	Dodge	school	2576	Public Schools-Multidistrict Charters	Horicon	405	Kiel eSchool	charter	2021	grade_12	7	7
2337547	WI	Dodge	school	2625	Public Schools-Multidistrict Charters	Hustisford	405	Kiel eSchool	charter	2021	grade_12	3	3
2337803	WI	Jefferson	school	2702	Public Schools-Multidistrict Charters	Jefferson	9803	JEDI Virtual K-12	charter	2021	grade_12	1	1
2338616	WI	Vernon	school	2863	Public Schools-Multidistrict Charters	La Farge	9407	Vernon County Area Better Futures High	charter	2021	grade_12	2	2
2338700	WI	Walworth	school	2884	Public Schools-Multidistrict Charters	Lake Geneva-Genoa City UHS	9401	Career and College Academy	charter	2021	grade_12	8	8
2338724	WI	Jefferson	school	2898	Public Schools-Multidistrict Charters	Lake Mills Area	9803	JEDI Virtual K-12 - Jefferson and Eastern Dane County Interactive	charter	2021	grade_12	2	2
2338951	WI	Kewaunee	school	3220	Public Schools-Multidistrict Charters	Luxemburg-Casco	9803	JEDI Virtual K-12	charter	2021	grade_12	1	1
2339586	WI	Wood	school	3339	Public Schools-Multidistrict Charters	Marshfield Unified	9100	Rural Virtual Academy	charter	2021	grade_12	3	3
2339617	WI	Juneau	school	3360	Public Schools-Multidistrict Charters	Mauston	9803	JEDI Virtual K-12	charter	2021	grade_12	2	2
2340153	WI	Rock	school	3612	Public Schools-Multidistrict Charters	Milton	9803	JEDI Virtual K-12	charter	2021	grade_12	5	5
2341729	WI	Green	school	3682	Public Schools-Multidistrict Charters	Monroe	9803	JEDI Virtual K-12	charter	2021	grade_12	2	2
2341837	WI	Marathon	school	3787	Public Schools-Multidistrict Charters	Mosinee	9100	Rural Virtual Academy	charter	2021	grade_12	5	5
2343120	WI	Clark	school	4207	Public Schools-Multidistrict Charters	Owen-Withee	9100	Rural Virtual Academy	charter	2021	grade_12	1	1
2343312	WI	Price	school	4347	Public Schools-Multidistrict Charters	Phillips	9100	Rural Virtual Academy		2021	grade_12	3	3
2343339	WI	Wood	school	4368	Public Schools-Multidistrict Charters	Pittsville	9100	Rural Virtual Academy	charter	2021	grade_12	2	2
2343615	WI	Price	school	4571	Public Schools-Multidistrict Charters	Prentice	9100	Rural Virtual Academy	charter	2021	grade_12	2	2