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 county 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	total	total_int
111768	WI	Adams	school	5500060	14	Public school	Adams-Friendship Area	550006000005	40	Adams-Friendship High		Regular School	No	3.0	09	12	2015	grade_11	123	123
281742	WI	Adams	school	5500060	14	Public school	Adams-Friendship Area	550006000005	40	Adams-Friendship High		Regular School	No	3.0	09	12	2016	grade_11	130	130
325638	WI	Adams	school	5500060	14	Public school	Adams-Friendship Area	550006000005	40	Adams-Friendship High		Regular School	No	High	09	12	2017	grade_11	103	103
2318162	WI	Adams	school	5500060	14	Public school	Adams-Friendship Area	550006000005	40	Adams-Friendship High		Regular School	No	High	09	12	2020	grade_11	108	108
2332965	WI	Adams	school	5500060	14	Public school	Adams-Friendship Area	550006000005	40	Adams-Friendship High		Regular School	No	High	09	12	2021	grade_11	117	117
3073931	WI	Adams	school	5500060	14	Public school	Adams-Friendship Area	550006000005	40	Adams-Friendship High		Regular School	No	High	09	12	2019	grade_11	112	112
3088680	WI	Adams	school	5500060	14	Public school	Adams-Friendship Area	550006000005	40	Adams-Friendship High		Regular School	No	High	09	12	2018	grade_11	135	135
112291	WI	Ashland	school	5500510	170	Public school	Ashland	550051000073	20	Ashland High		Regular School	No	3.0	09	12	2015	grade_11	168	168
113187	WI	Ashland	school	5501920	840	Public school	Butternut	550192000246	40	Butternut High		Regular School	No	4.0	06	12	2015	grade_11	14	14
113194	WI	Ashland	school	5501920	840	Public school	Butternut	550192002751	450	Promethean Charter School	charter	Regular School	Yes	3.0	09	12	2015	grade_11	1	1
118361	WI	Ashland	school	5508970	3427	Public school	Mellen	550897002941	800	Mellen Public School		Regular School	No	4.0	PK	12	2015	grade_11	18	18
282261	WI	Ashland	school	5500510	170	Public school	Ashland	550051003017	400	Ashland Charter High School	charter	Regular School	Yes	3.0	09	12	2016	grade_11	15	15
282270	WI	Ashland	school	5500510	170	Public school	Ashland	550051000073	20	Ashland High		Regular School	No	3.0	09	12	2016	grade_11	147	147
283170	WI	Ashland	school	5501920	840	Public school	Butternut	550192000246	40	Butternut High		Regular School	No	4.0	06	12	2016	grade_11	19	19
288357	WI	Ashland	school	5508970	3427	Public school	Mellen	550897002941	800	Mellen Public School		Regular School	No	4.0	PK	12	2016	grade_11	15	15
326160	WI	Ashland	school	5500510	170	Public school	Ashland	550051003017	400	Ashland Charter High School	charter	Regular School	Yes	High	09	12	2017	grade_11	4	4
326169	WI	Ashland	school	5500510	170	Public school	Ashland	550051000073	20	Ashland High		Regular School	No	High	09	12	2017	grade_11	177	177
327068	WI	Ashland	school	5501920	840	Public school	Butternut	550192000246	40	Butternut High		Regular School	No	Other	06	12	2017	grade_11	11	11
332231	WI	Ashland	school	5508970	3427	Public school	Mellen	550897002941	800	Mellen Public School		Regular School	No	Other	PK	12	2017	grade_11	20	20
2318649	WI	Ashland	school	5500510	170	Public school	Ashland	550051000073	20	Ashland High		Regular School	No	High	09	12	2020	grade_11	170	170
2318667	WI	Ashland	school	5500510	170	Public school	Ashland	550051003017	400	Lake Superior High	charter	Regular School	Yes	High	09	12	2020	grade_11	4	4
2318688	WI	Ashland	school		170	Public Schools-Multidistrict Charters	Ashland		9100	Rural Virtual Academy							2020	grade_11	2	2
2319585	WI	Ashland	school	5501920	840	Public school	Butternut	550192000246	40	Butternut High		Regular School	No	High	06	12	2020	grade_11	15	15
2319592	WI	Ashland	school	5501920	840	Public school	Butternut	550192002751	450	Promethean Charter School	charter	Regular School	Yes	High	09	12	2020	grade_11	1	1
2324867	WI	Ashland	school	5508970	3427	Public school	Mellen	550897002941	800	Mellen Public School		Regular School	No	Other	PK	12	2020	grade_11	23	23
2333444	WI	Ashland	school	5500510	170	Public school	Ashland	550051000073	20	Ashland High		Regular School	No	High	09	12	2021	grade_11	140	140
2333470	WI	Ashland	school		170	Public Schools-Multidistrict Charters	Ashland		9100	Rural Virtual Academy							2021	grade_11	1	1
2334366	WI	Ashland	school	5501920	840	Public school	Butternut	550192000246	40	Butternut High		Regular School	No	High	06	12	2021	grade_11	13	13
2339755	WI	Ashland	school	5508970	3427	Public school	Mellen	550897002941	800	Mellen Public School		Regular School	No	Other	KG	12	2021	grade_11	12	12
3074439	WI	Ashland	school	5500510	170	Public school	Ashland	550051000073	20	Ashland High		Regular School	No	High	09	12	2019	grade_11	159	159
3074448	WI	Ashland	school	5500510	170	Public school	Ashland	550051003017	400	Lake Superior High	charter	Regular School	Yes	High	09	12	2019	grade_11	8	8
3075366	WI	Ashland	school	5501920	840	Public school	Butternut	550192000246	40	Butternut High		Regular School	No	High	06	12	2019	grade_11	12	12
3075374	WI	Ashland	school	5501920	840	Public school	Butternut	550192002751	450	Promethean Charter School	charter	Regular School	Yes	High	09	12	2019	grade_11	1	1
3080595	WI	Ashland	school	5508970	3427	Public school	Mellen	550897002941	800	Mellen Public School		Regular School	No	Other	PK	12	2019	grade_11	22	22
3089195	WI	Ashland	school	5500510	170	Public school	Ashland	550051000073	20	Ashland High		Regular School	No	High	09	12	2018	grade_11	149	149
3089204	WI	Ashland	school	5500510	170	Public school	Ashland	550051003017	400	Lake Superior High	charter	Regular School	Yes	High	09	12	2018	grade_11	1	1
3090121	WI	Ashland	school	5501920	840	Public school	Butternut	550192000246	40	Butternut High		Regular School	No	High	06	12	2018	grade_11	19	19
3095311	WI	Ashland	school	5508970	3427	Public school	Mellen	550897002941	800	Mellen Public School		Regular School	No	Other	PK	12	2018	grade_11	18	18
112506	WI	Barron	school	5500870	308	Public school	Barron Area	550087002864	810	Advanced Learning Academy of Wisconsin	charter	Regular School	Yes	4.0	KG	12	2015	grade_11	18	18
112533	WI	Barron	school	5500870	308	Public school	Barron Area	550087000114	30	Barron High		Regular School	No	3.0	09	12	2015	grade_11	85	85
112537	WI	Barron	school	5500870	308	Public school	Barron Area	550087002500	9410	North Star Academy	charter	Alternative Education School	Yes	3.0	09	12	2015	grade_11	1	1
113252	WI	Barron	school	5502130	903	Public school	Cameron	550213002851	800	Cameron Academy of Virtual Education	charter	Alternative Education School	Yes	4.0	KG	12	2015	grade_11	8	8
113273	WI	Barron	school	5502130	903	Public school	Cameron	550213000257	40	Cameron High		Regular School	No	3.0	09	12	2015	grade_11	65	65
113282	WI	Barron	school		903	Public Schools-Multidistrict Charters	Cameron		9410	North Star Academy	charter						2015	grade_11	3	3
113449	WI	Barron	school	5500061	1080	Public school	Chetek-Weyerhaeuser Area	550006102807	400	Chetek-Weyerhaeuser High		Regular School	No	3.0	09	12	2015	grade_11	67	67
113468	WI	Barron	school	5500061	1080	Public school	Chetek-Weyerhaeuser Area	550006102897	800	Link2Learn Virtual Charter School	charter	Regular School	Yes	4.0	PK	12	2015	grade_11	3	3
113481	WI	Barron	school		1080	Public Schools-Multidistrict Charters	Chetek-Weyerhaeuser Area		9410	North Star Academy	charter						2015	grade_11	2	2
113861	WI	Barron	school	5503090	1260	Public school	Cumberland	550309000344	60	Cumberland High		Regular School	No	3.0	09	12	2015	grade_11	62	62
113871	WI	Barron	school	5503090	1260	Public school	Cumberland	550309002962	420	Island City Academy	charter	Vocational Education School	Yes	3.0	07	12	2015	grade_11	1	1
113877	WI	Barron	school	5503090	1260	Public school	Cumberland	550309002871	800	Island City Virtual Academy	charter	Regular School	Yes	4.0	PK	12	2015	grade_11	1	1
122206	WI	Barron	school	5512180	4557	Public school	Prairie Farm Public	551218001586	40	Prairie Farm High		Regular School	No	3.0	09	12	2015	grade_11	27	27
122774	WI	Barron	school	5512810	4802	Public school	Rice Lake Area	551281002932	450	Northern Lakes Regional Academy	charter	Regular School	Yes	3.0	09	12	2015	grade_11	9	9
122782	WI	Barron	school	5512810	4802	Public school	Rice Lake Area	551281001699	180	Rice Lake High		Regular School	No	3.0	09	12	2015	grade_11	161	161
124582	WI	Barron	school	5515060	5810	Public school	Turtle Lake	551506001956	40	Turtle Lake High		Regular School	No	3.0	09	12	2015	grade_11	34	34
282486	WI	Barron	school	5500870	308	Public school	Barron Area	550087002864	810	Advanced Learning Academy of Wisconsin	charter	Regular School	Yes	4.0	KG	12	2016	grade_11	15	15
282513	WI	Barron	school	5500870	308	Public school	Barron Area	550087000114	30	Barron High		Regular School	No	3.0	09	12	2016	grade_11	108	108
282518	WI	Barron	school		308	Public Schools-Multidistrict Charters	Barron Area		9410	North Star Academy	charter						2016	grade_11	2	2
283234	WI	Barron	school	5502130	903	Public school	Cameron	550213002851	800	Cameron Academy of Virtual Education	charter	Alternative Education School	Yes	4.0	KG	12	2016	grade_11	9	9
283255	WI	Barron	school	5502130	903	Public school	Cameron	550213000257	40	Cameron High		Regular School	No	3.0	09	12	2016	grade_11	67	67
283264	WI	Barron	school	5502130	903	Public school	Cameron	550213002500	9410	North Star Academy	charter	Alternative Education School	Yes	3.0	09	12	2016	grade_11	3	3
283428	WI	Barron	school	5500061	1080	Public school	Chetek-Weyerhaeuser Area	550006102807	400	Chetek-Weyerhaeuser High		Regular School	No	3.0	09	12	2016	grade_11	59	59
283459	WI	Barron	school		1080	Public Schools-Multidistrict Charters	Chetek-Weyerhaeuser Area		9410	North Star Academy	charter						2016	grade_11	1	1
283838	WI	Barron	school	5503090	1260	Public school	Cumberland	550309000344	60	Cumberland High		Regular School	No	3.0	09	12	2016	grade_11	66	66
283848	WI	Barron	school	5503090	1260	Public school	Cumberland	550309002962	420	Island City Academy	charter	Vocational Education School	Yes	3.0	07	12	2016	grade_11	3	3
292167	WI	Barron	school	5512180	4557	Public school	Prairie Farm Public	551218001586	40	Prairie Farm High		Regular School	No	3.0	09	12	2016	grade_11	26	26
292739	WI	Barron	school	5512810	4802	Public school	Rice Lake Area	551281002932	450	Northern Lakes Regional Academy	charter	Regular School	Yes	3.0	09	12	2016	grade_11	15	15
292744	WI	Barron	school	5512810	4802	Public school	Rice Lake Area	551281001699	180	Rice Lake High		Regular School	No	3.0	09	12	2016	grade_11	174	174
294500	WI	Barron	school		5810	Public Schools-Multidistrict Charters	Turtle Lake		9410	North Star Academy	charter						2016	grade_11	1	1
294515	WI	Barron	school	5515060	5810	Public school	Turtle Lake	551506001956	40	Turtle Lake High		Regular School	No	3.0	09	12	2016	grade_11	26	26
326385	WI	Barron	school	5500870	308	Public school	Barron Area	550087002864	810	Advanced Learning Academy of Wisconsin	charter	Regular School	Yes	Other	KG	12	2017	grade_11	7	7
326412	WI	Barron	school	5500870	308	Public school	Barron Area	550087000114	30	Barron High		Regular School	No	High	09	12	2017	grade_11	83	83
326416	WI	Barron	school		308	Public Schools-Multidistrict Charters	Barron Area		9410	North Star Academy	charter						2017	grade_11	3	3
327130	WI	Barron	school	5502130	903	Public school	Cameron	550213002851	800	Cameron Academy of Virtual Education	charter	Alternative School	Yes	Other	KG	12	2017	grade_11	4	4
327150	WI	Barron	school	5502130	903	Public school	Cameron	550213000257	40	Cameron High		Regular School	No	High	09	12	2017	grade_11	60	60
327159	WI	Barron	school	5502130	903	Public school	Cameron	550213002500	9410	North Star Academy	charter	Alternative School	Yes	High	09	12	2017	grade_11	4	4
327333	WI	Barron	school	5500061	1080	Public school	Chetek-Weyerhaeuser Area	550006102807	400	Chetek-Weyerhaeuser High		Regular School	No	High	09	12	2017	grade_11	74	74
327352	WI	Barron	school	5500061	1080	Public school	Chetek-Weyerhaeuser Area	550006102897	800	Link2Learn Virtual Charter School	charter	Regular School	Yes	Other	PK	12	2017	grade_11	6	6
327366	WI	Barron	school		1080	Public Schools-Multidistrict Charters	Chetek-Weyerhaeuser Area		9410	North Star Academy	charter						2017	grade_11	2	2
327741	WI	Barron	school	5503090	1260	Public school	Cumberland	550309000344	60	Cumberland High		Regular School	No	High	09	12	2017	grade_11	85	85
327751	WI	Barron	school	5503090	1260	Public school	Cumberland	550309002962	420	Island City Academy	charter	Career and Technical School	Yes	High	07	12	2017	grade_11	7	7
336045	WI	Barron	school	5512180	4557	Public school	Prairie Farm Public	551218001586	40	Prairie Farm High		Regular School	No	High	09	12	2017	grade_11	29	29
336626	WI	Barron	school	5512810	4802	Public school	Rice Lake Area	551281002932	450	Northern Lakes Regional Academy	charter	Regular School	Yes	High	09	12	2017	grade_11	9	9
336631	WI	Barron	school	5512810	4802	Public school	Rice Lake Area	551281001699	180	Rice Lake High		Regular School	No	High	09	12	2017	grade_11	174	174
338403	WI	Barron	school		5810	Public Schools-Multidistrict Charters	Turtle Lake		9410	North Star Academy	charter						2017	grade_11	2	2
338419	WI	Barron	school	5515060	5810	Public school	Turtle Lake	551506001956	40	Turtle Lake High		Regular School	No	High	09	12	2017	grade_11	26	26
2318891	WI	Barron	school	5500870	308	Public school	Barron Area	550087002864	810	Advanced Learning Academy of Wisconsin	charter	Regular School	Yes	Other	KG	12	2020	grade_11	9	9
2318910	WI	Barron	school	5500870	308	Public school	Barron Area	550087000114	30	Barron High		Regular School	No	High	09	12	2020	grade_11	98	98
2318915	WI	Barron	school		308	Public Schools-Multidistrict Charters	Barron Area		9410	North Star Academy	charter						2020	grade_11	4	4
2319657	WI	Barron	school	5502130	903	Public school	Cameron	550213002851	800	Cameron Academy of Virtual Education	charter	Alternative School	Yes	Other	PK	12	2020	grade_11	13	13
2319679	WI	Barron	school	5502130	903	Public school	Cameron	550213000257	40	Cameron High		Regular School	No	High	09	12	2020	grade_11	69	69
2319688	WI	Barron	school	5502130	903	Public school	Cameron	550213002500	9410	North Star Academy	charter	Alternative School	Yes	High	09	12	2020	grade_11	3	3
2319864	WI	Barron	school	5500061	1080	Public school	Chetek-Weyerhaeuser Area	550006102807	400	Chetek-Weyerhaeuser High		Regular School	No	High	09	12	2020	grade_11	65	65
2319883	WI	Barron	school	5500061	1080	Public school	Chetek-Weyerhaeuser Area	550006102897	800	Link2Learn Virtual Charter School	charter	Regular School	Yes	Other	PK	12	2020	grade_11	2	2
2319896	WI	Barron	school		1080	Public Schools-Multidistrict Charters	Chetek-Weyerhaeuser Area		9410	North Star Academy	charter						2020	grade_11	6	6
2320279	WI	Barron	school	5503090	1260	Public school	Cumberland	550309000344	60	Cumberland High		Regular School	No	High	09	12	2020	grade_11	92	92
2320289	WI	Barron	school	5503090	1260	Public school	Cumberland	550309002962	420	Island City Academy	charter	Career and Technical School	Yes	High	07	12	2020	grade_11	2	2
2320295	WI	Barron	school	5503090	1260	Public school	Cumberland	550309002871	800	Island City Virtual Academy	charter	Regular School	Yes	Other	PK	12	2020	grade_11	6	6
2328697	WI	Barron	school	5512180	4557	Public school	Prairie Farm Public	551218001586	40	Prairie Farm High		Regular School	No	High	09	12	2020	grade_11	22	22
2329247	WI	Barron	school	5512810	4802	Public school	Rice Lake Area	551281001699	180	Rice Lake High		Regular School	No	High	09	12	2020	grade_11	205	205
2331086	WI	Barron	school	5515060	5810	Public school	Turtle Lake	551506001956	40	Turtle Lake High		Regular School	No	High	09	12	2020	grade_11	23	23
2333672	WI	Barron	school	5500870	308	Public school	Barron Area	550087002864	810	Advanced Learning Academy of Wisconsin	charter	Regular School	Yes	Other	KG	12	2021	grade_11	17	17