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
118244	WI	Juneau	school	3360	Public Schools-Multidistrict Charters	Mauston	9803	JEDI Virtual K-12	charter	2015	grade_8	1	1
120525	WI	Marathon	school	3787	Public Schools-Multidistrict Charters	Mosinee	9100	Rural Virtual Academy	charter	2015	grade_8	1	1
122745	WI	Taylor	school	4795	Public Schools-Multidistrict Charters	Rib Lake	9100	Rural Virtual Academy	charter	2015	grade_8	1	1
123878	WI	Marathon	school	5467	Public Schools-Multidistrict Charters	Spencer	9100	Rural Virtual Academy	charter	2015	grade_8	2	2
124108	WI	Dane	school	5621	Public Schools-Multidistrict Charters	Stoughton Area	9803	JEDI Virtual K-12	charter	2015	grade_8	2	2
124139	WI	Marathon	school	5628	Public Schools-Multidistrict Charters	Stratford	9100	Rural Virtual Academy	charter	2015	grade_8	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
124619	WI	Manitowoc	school	5824	Public Schools-Multidistrict Charters	Two Rivers Public	9120	Manitowoc County Comprehensive Charter School	charter	2015	grade_8	2	2
282359	WI	Wood	school	203	Public Schools-Multidistrict Charters	Auburndale	9100	Rural Virtual Academy	charter	2016	grade_8	1	1
284916	WI	Jefferson	school	1883	Public Schools-Multidistrict Charters	Fort Atkinson	9803	JEDI Virtual K-12	charter	2016	grade_8	1	1
286489	WI	Jefferson	school	2702	Public Schools-Multidistrict Charters	Jefferson	9803	JEDI Virtual K-12	charter	2016	grade_8	1	1
288234	WI	Juneau	school	3360	Public Schools-Multidistrict Charters	Mauston	9803	JEDI Virtual K-12	charter	2016	grade_8	2	2
290484	WI	Marathon	school	3787	Public Schools-Multidistrict Charters	Mosinee	9100	Rural Virtual Academy	charter	2016	grade_8	1	1
293204	WI	Milwaukee	school	8121	Non District Charter Schools	Seeds of Health Elementary Program	100	Seeds of Health Elementary Program	charter	2016	grade_8	40	40
294073	WI	Marathon	school	5628	Public Schools-Multidistrict Charters	Stratford	9100	Rural Virtual Academy	charter	2016	grade_8	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
295111	WI	Waupaca	school	6195	Public Schools-Multidistrict Charters	Waupaca	9408	Waupaca County Charter	charter	2016	grade_8	3	3
325834	WI	Langlade	school	140	Public Schools-Multidistrict Charters	Antigo Unified	9100	Rural Virtual Academy	charter	2017	grade_8	3	3
331252	WI	Jefferson	school	2898	Public Schools-Multidistrict Charters	Lake Mills Area	9803	JEDI Virtual K-12	charter	2017	grade_8	1	1
334259	WI	Green	school	3682	Public Schools-Multidistrict Charters	Monroe	9803	JEDI Virtual K-12	charter	2017	grade_8	1	1
334356	WI	Marathon	school	3787	Public Schools-Multidistrict Charters	Mosinee	9100	Rural Virtual Academy	charter	2017	grade_8	1	1
335804	WI	Wood	school	4368	Public Schools-Multidistrict Charters	Pittsville	9100	Rural Virtual Academy	charter	2017	grade_8	1	1
337725	WI	Marathon	school	5467	Public Schools-Multidistrict Charters	Spencer	9100	Rural Virtual Academy	charter	2017	grade_8	2	2
337947	WI	Dane	school	5621	Public Schools-Multidistrict Charters	Stoughton Area	9803	JEDI Virtual K-12	charter	2017	grade_8	1	1
2318149	WI	Clark	school	7	Public Schools-Multidistrict Charters	Abbotsford	9100	Rural Virtual Academy	charter	2020	grade_8	1	1
2318337	WI	Langlade	school	140	Public Schools-Multidistrict Charters	Antigo Unified	9100	Rural Virtual Academy	charter	2020	grade_8	10	10
2318691	WI	Ashland	school	170	Public Schools-Multidistrict Charters	Ashland	9100	Rural Virtual Academy		2020	grade_8	3	3
2318764	WI	Wood	school	203	Public Schools-Multidistrict Charters	Auburndale	9100	Rural Virtual Academy	charter	2020	grade_8	1	1
2319393	WI	Shawano	school	623	Public Schools-Multidistrict Charters	Bowler	9100	Rural Virtual Academy	charter	2020	grade_8	1	1
2319543	WI	Racine	school	777	Public Schools-Multidistrict Charters	Burlington Area	9803	JEDI Virtual K-12	charter	2020	grade_8	1	1
2320085	WI	Clark	school	1162	Public Schools-Multidistrict Charters	Colby	9100	Rural Virtual Academy	charter	2020	grade_8	1	1
2324704	WI	Wood	school	3339	Public Schools-Multidistrict Charters	Marshfield Unified	9100	Rural Virtual Academy	charter	2020	grade_8	4	4
2324731	WI	Juneau	school	3360	Public Schools-Multidistrict Charters	Mauston	9803	JEDI Virtual K-12	charter	2020	grade_8	1	1
2326968	WI	Marathon	school	3787	Public Schools-Multidistrict Charters	Mosinee	9100	Rural Virtual Academy	charter	2020	grade_8	1	1
2328452	WI	Wood	school	4368	Public Schools-Multidistrict Charters	Pittsville	9100	Rural Virtual Academy	charter	2020	grade_8	4	4
2328730	WI	Price	school	4571	Public Schools-Multidistrict Charters	Prentice	9100	Rural Virtual Academy	charter	2020	grade_8	1	1
2329225	WI	Taylor	school	4795	Public Schools-Multidistrict Charters	Rib Lake	9100	Rural Virtual Academy	charter	2020	grade_8	2	2
2330334	WI	Marathon	school	5467	Public Schools-Multidistrict Charters	Spencer	9100	Rural Virtual Academy	charter	2020	grade_8	1	1
2330566	WI	Dane	school	5621	Public Schools-Multidistrict Charters	Stoughton Area	9803	JEDI Virtual K-12	charter	2020	grade_8	1	1
2330598	WI	Marathon	school	5628	Public Schools-Multidistrict Charters	Stratford	9100	Rural Virtual Academy	charter	2020	grade_8	1	1
2330681	WI	Dane	school	5656	Public Schools-Multidistrict Charters	Sun Prairie Area	9803	JEDI Virtual K-12	charter	2020	grade_8	1	1
2330838	WI	Clark	school	5726	Public Schools-Multidistrict Charters	Thorp	9100	Rural Virtual Academy	charter	2020	grade_8	2	2
2330949	WI	Monroe	school	5747	Public Schools-Multidistrict Charters	Tomah Area	9100	Rural Virtual Academy	charter	2020	grade_8	9	9
2332469	WI	Langlade	school	6440	Public Schools-Multidistrict Charters	White Lake	9100	Rural Virtual Academy	charter	2020	grade_8	1	1
2332535	WI	Walworth	school	6461	Public Schools-Multidistrict Charters	Whitewater Unified	9803	JEDI Virtual K-12 - Jefferson and Eastern Dane County Interactive	charter	2020	grade_8	3	3
2333133	WI	Langlade	school	140	Public Schools-Multidistrict Charters	Antigo Unified	9100	Rural Virtual Academy	charter	2021	grade_8	12	12
2333547	WI	Wood	school	203	Public Schools-Multidistrict Charters	Auburndale	9100	Rural Virtual Academy	charter	2021	grade_8	1	1
2334175	WI	Shawano	school	623	Public Schools-Multidistrict Charters	Bowler	9100	Rural Virtual Academy	charter	2021	grade_8	3	3
2334327	WI	Racine	school	777	Public Schools-Multidistrict Charters	Burlington Area	9803	JEDI Virtual K-12	charter	2021	grade_8	33	33
2334402	WI	Chippewa	school	870	Public Schools-Multidistrict Charters	Cadott Community	9419	eSucceed Charter School	charter	2021	grade_8	8	8
2334869	WI	Clark	school	1162	Public Schools-Multidistrict Charters	Colby	9100	Rural Virtual Academy	charter	2021	grade_8	3	3
2334957	WI	Chippewa	school	1204	Public Schools-Multidistrict Charters	Cornell	9419	eSucceed Charter School	charter	2021	grade_8	3	3
2335682	WI	Rock	school	1568	Public Schools-Multidistrict Charters	Edgerton	9803	JEDI Virtual K-12	charter	2021	grade_8	7	7
2335959	WI	Rock	school	1694	Public Schools-Multidistrict Charters	Evansville Community	9803	JEDI Virtual K-12	charter	2021	grade_8	1	1
2337311	WI	Dodge	school	2576	Public Schools-Multidistrict Charters	Horicon	800	Between the Lakes Virtual Academy	charter	2021	grade_8	10	10
2337526	WI	Dodge	school	2625	Public Schools-Multidistrict Charters	Hustisford	800	Between the Lakes Virtual Academy	charter	2021	grade_8	4	4
2337807	WI	Jefferson	school	2702	Public Schools-Multidistrict Charters	Jefferson	9803	JEDI Virtual K-12	charter	2021	grade_8	1	1
2339487	WI	Waupaca	school	3318	Public Schools-Multidistrict Charters	Marion	9100	Rural Virtual Academy	charter	2021	grade_8	2	2
2339593	WI	Wood	school	3339	Public Schools-Multidistrict Charters	Marshfield Unified	9100	Rural Virtual Academy	charter	2021	grade_8	7	7
2341843	WI	Marathon	school	3787	Public Schools-Multidistrict Charters	Mosinee	9100	Rural Virtual Academy	charter	2021	grade_8	5	5
2342139	WI	Chippewa	school	3920	Public Schools-Multidistrict Charters	New Auburn	9419	eSucceed Charter School	charter	2021	grade_8	1	1
2343317	WI	Price	school	4347	Public Schools-Multidistrict Charters	Phillips	9100	Rural Virtual Academy		2021	grade_8	1	1
2343343	WI	Wood	school	4368	Public Schools-Multidistrict Charters	Pittsville	9100	Rural Virtual Academy	charter	2021	grade_8	1	1
2343621	WI	Price	school	4571	Public Schools-Multidistrict Charters	Prentice	9100	Rural Virtual Academy	charter	2021	grade_8	4	4
2344101	WI	Oneida	school	4781	Public Schools-Multidistrict Charters	Rhinelander	9100	Rural Virtual Academy	charter	2021	grade_8	1	1
2345140	WI	Door	school	5457	Public Schools-Multidistrict Charters	Southern Door County	9100	Rural Virtual Academy	charter	2021	grade_8	1	1
2345232	WI	Marathon	school	5467	Public Schools-Multidistrict Charters	Spencer	9100	Rural Virtual Academy	charter	2021	grade_8	1	1
2345414	WI	Portage	school	5607	Public Schools-Multidistrict Charters	Stevens Point Area Public	9100	Rural Virtual Academy	charter	2021	grade_8	6	6
2345472	WI	Dane	school	5621	Public Schools-Multidistrict Charters	Stoughton Area	9803	JEDI Virtual K-12	charter	2021	grade_8	9	9
2345509	WI	Marathon	school	5628	Public Schools-Multidistrict Charters	Stratford	9100	Rural Virtual Academy	charter	2021	grade_8	3	3
2345591	WI	Dane	school	5656	Public Schools-Multidistrict Charters	Sun Prairie Area	9803	JEDI Virtual K-12	charter	2021	grade_8	4	4
2345752	WI	Clark	school	5726	Public Schools-Multidistrict Charters	Thorp	9100	Rural Virtual Academy	charter	2021	grade_8	2	2
2345863	WI	Monroe	school	5747	Public Schools-Multidistrict Charters	Tomah Area	9100	Rural Virtual Academy	charter	2021	grade_8	7	7
2346328	WI	Racine	school	6113	Public Schools-Multidistrict Charters	Waterford Graded J1	9803	JEDI Virtual K-12	charter	2021	grade_8	4	4
2347332	WI	Vernon	school	6321	Public Schools-Multidistrict Charters	Westby Area	9100	Rural Virtual Academy	charter	2021	grade_8	4	4
2347523	WI	Walworth	school	6461	Public Schools-Multidistrict Charters	Whitewater Unified	9803	JEDI Virtual K-12 - Jefferson and Eastern Dane County Interactive	charter	2021	grade_8	2	2
3074121	WI	Langlade	school	140	Public Schools-Multidistrict Charters	Antigo Unified	9100	Rural Virtual Academy	charter	2019	grade_8	1	1
3074539	WI	Wood	school	203	Public Schools-Multidistrict Charters	Auburndale	9100	Rural Virtual Academy	charter	2019	grade_8	1	1
3075179	WI	Shawano	school	623	Public Schools-Multidistrict Charters	Bowler	9100	Rural Virtual Academy	charter	2019	grade_8	4	4
3075328	WI	Racine	school	777	Public Schools-Multidistrict Charters	Burlington Area	9803	JEDI Virtual K-12	charter	2019	grade_8	1	1
3076890	WI	Rock	school	1694	Public Schools-Multidistrict Charters	Evansville Community	9803	JEDI Virtual K-12	charter	2019	grade_8	2	2
3078690	WI	Jefferson	school	2702	Public Schools-Multidistrict Charters	Jefferson	9803	JEDI Virtual K-12	charter	2019	grade_8	1	1
3080431	WI	Wood	school	3339	Public Schools-Multidistrict Charters	Marshfield Unified	9100	Rural Virtual Academy	charter	2019	grade_8	2	2
3080459	WI	Juneau	school	3360	Public Schools-Multidistrict Charters	Mauston	9803	JEDI Virtual K-12	charter	2019	grade_8	1	1
3082632	WI	Green	school	3682	Public Schools-Multidistrict Charters	Monroe	9803	JEDI Virtual K-12	charter	2019	grade_8	1	1
3082735	WI	Marathon	school	3787	Public Schools-Multidistrict Charters	Mosinee	9100	Rural Virtual Academy	charter	2019	grade_8	3	3
3083977	WI	Clark	school	4207	Public Schools-Multidistrict Charters	Owen-Withee	9100	Rural Virtual Academy	charter	2019	grade_8	1	1
3086272	WI	Dane	school	5621	Public Schools-Multidistrict Charters	Stoughton Area	9803	JEDI Virtual K-12	charter	2019	grade_8	1	1
3086305	WI	Marathon	school	5628	Public Schools-Multidistrict Charters	Stratford	9100	Rural Virtual Academy	charter	2019	grade_8	1	1
3086387	WI	Dane	school	5656	Public Schools-Multidistrict Charters	Sun Prairie Area	9803	JEDI Virtual K-12	charter	2019	grade_8	3	3
3086646	WI	Monroe	school	5747	Public Schools-Multidistrict Charters	Tomah Area	9100	Rural Virtual Academy	charter	2019	grade_8	3	3
3088878	WI	Langlade	school	140	Public Schools-Multidistrict Charters	Antigo Unified	9100	Rural Virtual Academy	charter	2018	grade_8	5	5
3089295	WI	Wood	school	203	Public Schools-Multidistrict Charters	Auburndale	9100	Rural Virtual Academy	charter	2018	grade_8	1	1
3091643	WI	Rock	school	1694	Public Schools-Multidistrict Charters	Evansville Community	9803	JEDI Virtual K-12	charter	2018	grade_8	1	1
3093434	WI	Jefferson	school	2702	Public Schools-Multidistrict Charters	Jefferson	9803	JEDI Virtual K-12	charter	2018	grade_8	1	1
3095172	WI	Juneau	school	3360	Public Schools-Multidistrict Charters	Mauston	9803	JEDI Virtual K-12	charter	2018	grade_8	2	2
3097332	WI	Green	school	3682	Public Schools-Multidistrict Charters	Monroe	9803	JEDI Virtual K-12	charter	2018	grade_8	1	1
3097434	WI	Marathon	school	3787	Public Schools-Multidistrict Charters	Mosinee	9100	Rural Virtual Academy	charter	2018	grade_8	2	2
3098886	WI	Wood	school	4368	Public Schools-Multidistrict Charters	Pittsville	9100	Rural Virtual Academy	charter	2018	grade_8	2	2
3099165	WI	Price	school	4571	Public Schools-Multidistrict Charters	Prentice	9100	Rural Virtual Academy	charter	2018	grade_8	1	1
3100781	WI	Marathon	school	5467	Public Schools-Multidistrict Charters	Spencer	9100	Rural Virtual Academy	charter	2018	grade_8	2	2