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
116287	WI	Waupaca	school	2639	Public Schools-Multidistrict Charters	Iola-Scandinavia	9408	Waupaca County Charter	charter	2015	grade_10	1	1
116483	WI	Jefferson	school	2702	Public Schools-Multidistrict Charters	Jefferson	9803	JEDI Virtual K-12	charter	2015	grade_10	1	1
118240	WI	Juneau	school	3360	Public Schools-Multidistrict Charters	Mauston	9803	JEDI Virtual K-12	charter	2015	grade_10	1	1
120661	WI	Juneau	school	3871	Public Schools-Multidistrict Charters	Necedah Area	9405	Juneau County Charter School	charter	2015	grade_10	2	2
124105	WI	Dane	school	5621	Public Schools-Multidistrict Charters	Stoughton Area	9803	JEDI Virtual K-12	charter	2015	grade_10	4	4
124214	WI	Dane	school	5656	Public Schools-Multidistrict Charters	Sun Prairie Area	9803	JEDI Virtual K-12	charter	2015	grade_10	1	1
281937	WI	Langlade	school	140	Public Schools-Multidistrict Charters	Antigo Unified	9100	Rural Virtual Academy	charter	2016	grade_10	1	1
282517	WI	Barron	school	308	Public Schools-Multidistrict Charters	Barron Area	9410	North Star Academy	charter	2016	grade_10	3	3
283644	WI	Clark	school	1162	Public Schools-Multidistrict Charters	Colby	9100	Rural Virtual Academy	charter	2016	grade_10	1	1
284911	WI	Jefferson	school	1883	Public Schools-Multidistrict Charters	Fort Atkinson	9803	JEDI Virtual K-12	charter	2016	grade_10	3	3
286485	WI	Jefferson	school	2702	Public Schools-Multidistrict Charters	Jefferson	9803	JEDI Virtual K-12	charter	2016	grade_10	1	1
288231	WI	Juneau	school	3360	Public Schools-Multidistrict Charters	Mauston	9803	JEDI Virtual K-12	charter	2016	grade_10	2	2
290386	WI	Green	school	3682	Public Schools-Multidistrict Charters	Monroe	9803	JEDI Virtual K-12	charter	2016	grade_10	1	1
290479	WI	Marathon	school	3787	Public Schools-Multidistrict Charters	Mosinee	9100	Rural Virtual Academy	charter	2016	grade_10	1	1
290623	WI	Juneau	school	3871	Public Schools-Multidistrict Charters	Necedah Area	9405	Juneau County Charter School	charter	2016	grade_10	1	1
294040	WI	Dane	school	5621	Public Schools-Multidistrict Charters	Stoughton Area	9803	JEDI Virtual K-12	charter	2016	grade_10	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
294289	WI	Milwaukee	school	8115	Non District Charter Schools	Tenor High School	400	Tenor High School	charter	2016	grade_10	59	59
294622	WI	Milwaukee	school	8124	Non District Charter Schools	Veritas High	400	Veritas High	charter	2016	grade_10	75	75
295761	WI	Vernon	school	6321	Public Schools-Multidistrict Charters	Westby Area	9407	Vernon County Area Better Futures High	charter	2016	grade_10	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
325830	WI	Langlade	school	140	Public Schools-Multidistrict Charters	Antigo Unified	9100	Rural Virtual Academy	charter	2017	grade_10	1	1
327365	WI	Barron	school	1080	Public Schools-Multidistrict Charters	Chetek-Weyerhaeuser Area	9410	North Star Academy	charter	2017	grade_10	1	1
331825	WI	Waupaca	school	3276	Public Schools-Multidistrict Charters	Manawa	9408	Waupaca County Charter	charter	2017	grade_10	1	1
332096	WI	Juneau	school	3360	Public Schools-Multidistrict Charters	Mauston	9803	JEDI Virtual K-12		2017	grade_10	1	1
334257	WI	Green	school	3682	Public Schools-Multidistrict Charters	Monroe	9803	JEDI Virtual K-12	charter	2017	grade_10	2	2
334352	WI	Marathon	school	3787	Public Schools-Multidistrict Charters	Mosinee	9100	Rural Virtual Academy	charter	2017	grade_10	4	4
335800	WI	Wood	school	4368	Public Schools-Multidistrict Charters	Pittsville	9100	Rural Virtual Academy	charter	2017	grade_10	1	1
336600	WI	Taylor	school	4795	Public Schools-Multidistrict Charters	Rib Lake	9100	Rural Virtual Academy	charter	2017	grade_10	2	2
337720	WI	Marathon	school	5467	Public Schools-Multidistrict Charters	Spencer	9100	Rural Virtual Academy	charter	2017	grade_10	2	2
337943	WI	Dane	school	5621	Public Schools-Multidistrict Charters	Stoughton Area	9803	JEDI Virtual K-12	charter	2017	grade_10	2	2
337976	WI	Marathon	school	5628	Public Schools-Multidistrict Charters	Stratford	9100	Rural Virtual Academy	charter	2017	grade_10	1	1
338052	WI	Dane	school	5656	Public Schools-Multidistrict Charters	Sun Prairie Area	9803	JEDI Virtual K-12	charter	2017	grade_10	2	2
2318328	WI	Langlade	school	140	Public Schools-Multidistrict Charters	Antigo Unified	9100	Rural Virtual Academy	charter	2020	grade_10	5	5
2318687	WI	Ashland	school	170	Public Schools-Multidistrict Charters	Ashland	9100	Rural Virtual Academy		2020	grade_10	1	1
2318757	WI	Wood	school	203	Public Schools-Multidistrict Charters	Auburndale	9100	Rural Virtual Academy	charter	2020	grade_10	1	1
2318914	WI	Barron	school	308	Public Schools-Multidistrict Charters	Barron Area	9410	North Star Academy	charter	2020	grade_10	2	2
2319387	WI	Shawano	school	623	Public Schools-Multidistrict Charters	Bowler	9100	Rural Virtual Academy	charter	2020	grade_10	2	2
2319538	WI	Racine	school	777	Public Schools-Multidistrict Charters	Burlington Area	9803	JEDI Virtual K-12	charter	2020	grade_10	5	5
2322938	WI	Jefferson	school	2702	Public Schools-Multidistrict Charters	Jefferson	9803	JEDI Virtual K-12	charter	2020	grade_10	1	1
2324081	WI	Kewaunee	school	3220	Public Schools-Multidistrict Charters	Luxemburg-Casco	9803	JEDI Virtual K-12	charter	2020	grade_10	1	1
2324696	WI	Wood	school	3339	Public Schools-Multidistrict Charters	Marshfield Unified	9100	Rural Virtual Academy	charter	2020	grade_10	3	3
2325258	WI	Rock	school	3612	Public Schools-Multidistrict Charters	Milton	9803	JEDI Virtual K-12	charter	2020	grade_10	2	2
2326960	WI	Marathon	school	3787	Public Schools-Multidistrict Charters	Mosinee	9100	Rural Virtual Academy	charter	2020	grade_10	2	2
2328224	WI	Clark	school	4207	Public Schools-Multidistrict Charters	Owen-Withee	9100	Rural Virtual Academy	charter	2020	grade_10	1	1
2328418	WI	Price	school	4347	Public Schools-Multidistrict Charters	Phillips	9100	Rural Virtual Academy		2020	grade_10	1	1
2329218	WI	Taylor	school	4795	Public Schools-Multidistrict Charters	Rib Lake	9100	Rural Virtual Academy	charter	2020	grade_10	1	1
2330329	WI	Marathon	school	5467	Public Schools-Multidistrict Charters	Spencer	9100	Rural Virtual Academy	charter	2020	grade_10	1	1
2330394	WI	Chippewa	school	5593	Public Schools-Multidistrict Charters	Stanley-Boyd Area	9419	eSucceed Charter School	charter	2020	grade_10	1	1
2330559	WI	Dane	school	5621	Public Schools-Multidistrict Charters	Stoughton Area	9803	JEDI Virtual K-12	charter	2020	grade_10	5	5
2330676	WI	Dane	school	5656	Public Schools-Multidistrict Charters	Sun Prairie Area	9803	JEDI Virtual K-12	charter	2020	grade_10	2	2
2330941	WI	Monroe	school	5747	Public Schools-Multidistrict Charters	Tomah Area	9100	Rural Virtual Academy	charter	2020	grade_10	4	4
2332532	WI	Walworth	school	6461	Public Schools-Multidistrict Charters	Whitewater Unified	9803	JEDI Virtual K-12 - Jefferson and Eastern Dane County Interactive	charter	2020	grade_10	1	1
2333124	WI	Langlade	school	140	Public Schools-Multidistrict Charters	Antigo Unified	9100	Rural Virtual Academy	charter	2021	grade_10	14	14
2333469	WI	Ashland	school	170	Public Schools-Multidistrict Charters	Ashland	9100	Rural Virtual Academy		2021	grade_10	1	1
2333539	WI	Wood	school	203	Public Schools-Multidistrict Charters	Auburndale	9100	Rural Virtual Academy	charter	2021	grade_10	4	4
2334170	WI	Shawano	school	623	Public Schools-Multidistrict Charters	Bowler	9100	Rural Virtual Academy	charter	2021	grade_10	2	2
2334318	WI	Racine	school	777	Public Schools-Multidistrict Charters	Burlington Area	9803	JEDI Virtual K-12	charter	2021	grade_10	23	23
2334393	WI	Chippewa	school	870	Public Schools-Multidistrict Charters	Cadott Community	9419	eSucceed Charter School	charter	2021	grade_10	7	7
2334681	WI	Barron	school	1080	Public Schools-Multidistrict Charters	Chetek-Weyerhaeuser Area	9410	North Star Academy	charter	2021	grade_10	1	1
2334948	WI	Chippewa	school	1204	Public Schools-Multidistrict Charters	Cornell	9419	eSucceed Charter School	charter	2021	grade_10	3	3
2335674	WI	Rock	school	1568	Public Schools-Multidistrict Charters	Edgerton	9803	JEDI Virtual K-12	charter	2021	grade_10	5	5
2335711	WI	Langlade	school	1582	Public Schools-Multidistrict Charters	Elcho	9100	Rural Virtual Academy	charter	2021	grade_10	2	2
2335956	WI	Rock	school	1694	Public Schools-Multidistrict Charters	Evansville Community	9803	JEDI Virtual K-12	charter	2021	grade_10	1	1
2337332	WI	Dodge	school	2576	Public Schools-Multidistrict Charters	Horicon	405	Kiel eSchool	charter	2021	grade_10	8	8
2337546	WI	Dodge	school	2625	Public Schools-Multidistrict Charters	Hustisford	405	Kiel eSchool	charter	2021	grade_10	1	1
2337801	WI	Jefferson	school	2702	Public Schools-Multidistrict Charters	Jefferson	9803	JEDI Virtual K-12	charter	2021	grade_10	1	1
2338722	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_10	2	2
2338949	WI	Kewaunee	school	3220	Public Schools-Multidistrict Charters	Luxemburg-Casco	9803	JEDI Virtual K-12	charter	2021	grade_10	2	2
2339483	WI	Waupaca	school	3318	Public Schools-Multidistrict Charters	Marion	9100	Rural Virtual Academy	charter	2021	grade_10	1	1
2339584	WI	Wood	school	3339	Public Schools-Multidistrict Charters	Marshfield Unified	9100	Rural Virtual Academy	charter	2021	grade_10	7	7
2340151	WI	Rock	school	3612	Public Schools-Multidistrict Charters	Milton	9803	JEDI Virtual K-12	charter	2021	grade_10	3	3
2341835	WI	Marathon	school	3787	Public Schools-Multidistrict Charters	Mosinee	9100	Rural Virtual Academy	charter	2021	grade_10	3	3
2342138	WI	Chippewa	school	3920	Public Schools-Multidistrict Charters	New Auburn	9419	eSucceed Charter School	charter	2021	grade_10	1	1
2343119	WI	Clark	school	4207	Public Schools-Multidistrict Charters	Owen-Withee	9100	Rural Virtual Academy	charter	2021	grade_10	1	1
2343310	WI	Price	school	4347	Public Schools-Multidistrict Charters	Phillips	9100	Rural Virtual Academy		2021	grade_10	7	7
2343337	WI	Wood	school	4368	Public Schools-Multidistrict Charters	Pittsville	9100	Rural Virtual Academy	charter	2021	grade_10	1	1
2344093	WI	Oneida	school	4781	Public Schools-Multidistrict Charters	Rhinelander	9100	Rural Virtual Academy	charter	2021	grade_10	1	1
2345407	WI	Portage	school	5607	Public Schools-Multidistrict Charters	Stevens Point Area Public	9100	Rural Virtual Academy	charter	2021	grade_10	7	7
2345467	WI	Dane	school	5621	Public Schools-Multidistrict Charters	Stoughton Area	9803	JEDI Virtual K-12	charter	2021	grade_10	3	3
2345502	WI	Marathon	school	5628	Public Schools-Multidistrict Charters	Stratford	9100	Rural Virtual Academy	charter	2021	grade_10	2	2
2345585	WI	Dane	school	5656	Public Schools-Multidistrict Charters	Sun Prairie Area	9803	JEDI Virtual K-12	charter	2021	grade_10	5	5
2345744	WI	Clark	school	5726	Public Schools-Multidistrict Charters	Thorp	9100	Rural Virtual Academy	charter	2021	grade_10	1	1
2345855	WI	Monroe	school	5747	Public Schools-Multidistrict Charters	Tomah Area	9100	Rural Virtual Academy	charter	2021	grade_10	5	5
2346349	WI	Racine	school	6083	Public Schools-Multidistrict Charters	Waterford UHS	9803	JEDI Virtual K-12	charter	2021	grade_10	13	13
2347326	WI	Vernon	school	6321	Public Schools-Multidistrict Charters	Westby Area	9100	Rural Virtual Academy	charter	2021	grade_10	1	1
2347517	WI	Walworth	school	6461	Public Schools-Multidistrict Charters	Whitewater Unified	9803	JEDI Virtual K-12 - Jefferson and Eastern Dane County Interactive	charter	2021	grade_10	4	4
3073917	WI	Clark	school	7	Public Schools-Multidistrict Charters	Abbotsford	9100	Rural Virtual Academy	charter	2019	grade_10	1	1
3074112	WI	Langlade	school	140	Public Schools-Multidistrict Charters	Antigo Unified	9100	Rural Virtual Academy	charter	2019	grade_10	6	6
3075323	WI	Racine	school	777	Public Schools-Multidistrict Charters	Burlington Area	9803	JEDI Virtual K-12	charter	2019	grade_10	2	2
3075854	WI	Clark	school	1162	Public Schools-Multidistrict Charters	Colby	9100	Rural Virtual Academy	charter	2019	grade_10	3	3
3079556	WI	Walworth	school	2884	Public Schools-Multidistrict Charters	Lake Geneva-Genoa City UHS	9401	Walworth Co Educ Alt High	charter	2019	grade_10	1	1
3080422	WI	Wood	school	3339	Public Schools-Multidistrict Charters	Marshfield Unified	9100	Rural Virtual Academy	charter	2019	grade_10	1	1
3080457	WI	Juneau	school	3360	Public Schools-Multidistrict Charters	Mauston	9803	JEDI Virtual K-12	charter	2019	grade_10	1	1
3082627	WI	Green	school	3682	Public Schools-Multidistrict Charters	Monroe	9803	JEDI Virtual K-12	charter	2019	grade_10	2	2
3082727	WI	Marathon	school	3787	Public Schools-Multidistrict Charters	Mosinee	9100	Rural Virtual Academy	charter	2019	grade_10	4	4
3086268	WI	Dane	school	5621	Public Schools-Multidistrict Charters	Stoughton Area	9803	JEDI Virtual K-12	charter	2019	grade_10	4	4
3086381	WI	Dane	school	5656	Public Schools-Multidistrict Charters	Sun Prairie Area	9803	JEDI Virtual K-12	charter	2019	grade_10	1	1
3086637	WI	Monroe	school	5747	Public Schools-Multidistrict Charters	Tomah Area	9100	Rural Virtual Academy	charter	2019	grade_10	4	4
3087118	WI	Jefferson	school	6118	Public Schools-Multidistrict Charters	Waterloo	9803	JEDI Virtual K-12	charter	2019	grade_10	1	1
3088073	WI	Vernon	school	6321	Public Schools-Multidistrict Charters	Westby Area	9407	Vernon County Area Better Futures High	charter	2019	grade_10	1	1