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
111769	WI	Adams	school	5500060	14	Public school	Adams-Friendship Area	550006000005	40	Adams-Friendship High		Regular School	No	3.0	09	12	2015	grade_12	117	117
281743	WI	Adams	school	5500060	14	Public school	Adams-Friendship Area	550006000005	40	Adams-Friendship High		Regular School	No	3.0	09	12	2016	grade_12	117	117
325639	WI	Adams	school	5500060	14	Public school	Adams-Friendship Area	550006000005	40	Adams-Friendship High		Regular School	No	High	09	12	2017	grade_12	133	133
2318163	WI	Adams	school	5500060	14	Public school	Adams-Friendship Area	550006000005	40	Adams-Friendship High		Regular School	No	High	09	12	2020	grade_12	110	110
2332966	WI	Adams	school	5500060	14	Public school	Adams-Friendship Area	550006000005	40	Adams-Friendship High		Regular School	No	High	09	12	2021	grade_12	108	108
3073932	WI	Adams	school	5500060	14	Public school	Adams-Friendship Area	550006000005	40	Adams-Friendship High		Regular School	No	High	09	12	2019	grade_12	132	132
3088681	WI	Adams	school	5500060	14	Public school	Adams-Friendship Area	550006000005	40	Adams-Friendship High		Regular School	No	High	09	12	2018	grade_12	101	101
112292	WI	Ashland	school	5500510	170	Public school	Ashland	550051000073	20	Ashland High		Regular School	No	3.0	09	12	2015	grade_12	178	178
113188	WI	Ashland	school	5501920	840	Public school	Butternut	550192000246	40	Butternut High		Regular School	No	4.0	06	12	2015	grade_12	8	8
113195	WI	Ashland	school	5501920	840	Public school	Butternut	550192002751	450	Promethean Charter School	charter	Regular School	Yes	3.0	09	12	2015	grade_12	3	3
118362	WI	Ashland	school	5508970	3427	Public school	Mellen	550897002941	800	Mellen Public School		Regular School	No	4.0	PK	12	2015	grade_12	17	17
282262	WI	Ashland	school	5500510	170	Public school	Ashland	550051003017	400	Ashland Charter High School	charter	Regular School	Yes	3.0	09	12	2016	grade_12	8	8
282271	WI	Ashland	school	5500510	170	Public school	Ashland	550051000073	20	Ashland High		Regular School	No	3.0	09	12	2016	grade_12	165	165
283171	WI	Ashland	school	5501920	840	Public school	Butternut	550192000246	40	Butternut High		Regular School	No	4.0	06	12	2016	grade_12	12	12
283177	WI	Ashland	school	5501920	840	Public school	Butternut	550192002751	450	Promethean Charter School	charter	Regular School	Yes	3.0	09	12	2016	grade_12	1	1
288358	WI	Ashland	school	5508970	3427	Public school	Mellen	550897002941	800	Mellen Public School		Regular School	No	4.0	PK	12	2016	grade_12	19	19
326161	WI	Ashland	school	5500510	170	Public school	Ashland	550051003017	400	Ashland Charter High School	charter	Regular School	Yes	High	09	12	2017	grade_12	3	3
326170	WI	Ashland	school	5500510	170	Public school	Ashland	550051000073	20	Ashland High		Regular School	No	High	09	12	2017	grade_12	156	156
327069	WI	Ashland	school	5501920	840	Public school	Butternut	550192000246	40	Butternut High		Regular School	No	Other	06	12	2017	grade_12	17	17
332232	WI	Ashland	school	5508970	3427	Public school	Mellen	550897002941	800	Mellen Public School		Regular School	No	Other	PK	12	2017	grade_12	21	21
2318650	WI	Ashland	school	5500510	170	Public school	Ashland	550051000073	20	Ashland High		Regular School	No	High	09	12	2020	grade_12	169	169
2318668	WI	Ashland	school	5500510	170	Public school	Ashland	550051003017	400	Lake Superior High	charter	Regular School	Yes	High	09	12	2020	grade_12	8	8
2318689	WI	Ashland	school		170	Public Schools-Multidistrict Charters	Ashland		9100	Rural Virtual Academy							2020	grade_12	1	1
2319586	WI	Ashland	school	5501920	840	Public school	Butternut	550192000246	40	Butternut High		Regular School	No	High	06	12	2020	grade_12	11	11
2319593	WI	Ashland	school	5501920	840	Public school	Butternut	550192002751	450	Promethean Charter School	charter	Regular School	Yes	High	09	12	2020	grade_12	1	1
2324868	WI	Ashland	school	5508970	3427	Public school	Mellen	550897002941	800	Mellen Public School		Regular School	No	Other	PK	12	2020	grade_12	24	24
2333445	WI	Ashland	school	5500510	170	Public school	Ashland	550051000073	20	Ashland High		Regular School	No	High	09	12	2021	grade_12	175	175
2333471	WI	Ashland	school		170	Public Schools-Multidistrict Charters	Ashland		9100	Rural Virtual Academy							2021	grade_12	1	1
2334367	WI	Ashland	school	5501920	840	Public school	Butternut	550192000246	40	Butternut High		Regular School	No	High	06	12	2021	grade_12	15	15
2339756	WI	Ashland	school	5508970	3427	Public school	Mellen	550897002941	800	Mellen Public School		Regular School	No	Other	KG	12	2021	grade_12	24	24
3074440	WI	Ashland	school	5500510	170	Public school	Ashland	550051000073	20	Ashland High		Regular School	No	High	09	12	2019	grade_12	158	158
3074449	WI	Ashland	school	5500510	170	Public school	Ashland	550051003017	400	Lake Superior High	charter	Regular School	Yes	High	09	12	2019	grade_12	2	2
3075367	WI	Ashland	school	5501920	840	Public school	Butternut	550192000246	40	Butternut High		Regular School	No	High	06	12	2019	grade_12	20	20
3080596	WI	Ashland	school	5508970	3427	Public school	Mellen	550897002941	800	Mellen Public School		Regular School	No	Other	PK	12	2019	grade_12	18	18
3089196	WI	Ashland	school	5500510	170	Public school	Ashland	550051000073	20	Ashland High		Regular School	No	High	09	12	2018	grade_12	185	185
3089205	WI	Ashland	school	5500510	170	Public school	Ashland	550051003017	400	Lake Superior High	charter	Regular School	Yes	High	09	12	2018	grade_12	2	2
3090122	WI	Ashland	school	5501920	840	Public school	Butternut	550192000246	40	Butternut High		Regular School	No	High	06	12	2018	grade_12	11	11
3090129	WI	Ashland	school	5501920	840	Public school	Butternut	550192002751	450	Promethean Charter School	charter	Regular School	Yes	High	09	12	2018	grade_12	1	1
3095312	WI	Ashland	school	5508970	3427	Public school	Mellen	550897002941	800	Mellen Public School		Regular School	No	Other	PK	12	2018	grade_12	24	24
112507	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_12	14	14
112534	WI	Barron	school	5500870	308	Public school	Barron Area	550087000114	30	Barron High		Regular School	No	3.0	09	12	2015	grade_12	88	88
112538	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_12	12	12
113253	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_12	7	7
113274	WI	Barron	school	5502130	903	Public school	Cameron	550213000257	40	Cameron High		Regular School	No	3.0	09	12	2015	grade_12	60	60
113283	WI	Barron	school		903	Public Schools-Multidistrict Charters	Cameron		9410	North Star Academy	charter						2015	grade_12	8	8
113450	WI	Barron	school	5500061	1080	Public school	Chetek-Weyerhaeuser Area	550006102807	400	Chetek-Weyerhaeuser High		Regular School	No	3.0	09	12	2015	grade_12	66	66
113469	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_12	1	1
113482	WI	Barron	school		1080	Public Schools-Multidistrict Charters	Chetek-Weyerhaeuser Area		9410	North Star Academy	charter						2015	grade_12	7	7
113862	WI	Barron	school	5503090	1260	Public school	Cumberland	550309000344	60	Cumberland High		Regular School	No	3.0	09	12	2015	grade_12	76	76
113872	WI	Barron	school	5503090	1260	Public school	Cumberland	550309002962	420	Island City Academy	charter	Vocational Education School	Yes	3.0	07	12	2015	grade_12	2	2
113878	WI	Barron	school	5503090	1260	Public school	Cumberland	550309002871	800	Island City Virtual Academy	charter	Regular School	Yes	4.0	PK	12	2015	grade_12	1	1
122207	WI	Barron	school	5512180	4557	Public school	Prairie Farm Public	551218001586	40	Prairie Farm High		Regular School	No	3.0	09	12	2015	grade_12	22	22
122775	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_12	12	12
122783	WI	Barron	school	5512810	4802	Public school	Rice Lake Area	551281001699	180	Rice Lake High		Regular School	No	3.0	09	12	2015	grade_12	190	190
124567	WI	Barron	school		5810	Public Schools-Multidistrict Charters	Turtle Lake		9410	North Star Academy	charter						2015	grade_12	3	3
124583	WI	Barron	school	5515060	5810	Public school	Turtle Lake	551506001956	40	Turtle Lake High		Regular School	No	3.0	09	12	2015	grade_12	33	33
282487	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_12	19	19
282514	WI	Barron	school	5500870	308	Public school	Barron Area	550087000114	30	Barron High		Regular School	No	3.0	09	12	2016	grade_12	82	82
282519	WI	Barron	school		308	Public Schools-Multidistrict Charters	Barron Area		9410	North Star Academy	charter						2016	grade_12	7	7
283235	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_12	10	10
283256	WI	Barron	school	5502130	903	Public school	Cameron	550213000257	40	Cameron High		Regular School	No	3.0	09	12	2016	grade_12	60	60
283265	WI	Barron	school	5502130	903	Public school	Cameron	550213002500	9410	North Star Academy	charter	Alternative Education School	Yes	3.0	09	12	2016	grade_12	11	11
283429	WI	Barron	school	5500061	1080	Public school	Chetek-Weyerhaeuser Area	550006102807	400	Chetek-Weyerhaeuser High		Regular School	No	3.0	09	12	2016	grade_12	61	61
283447	WI	Barron	school	5500061	1080	Public school	Chetek-Weyerhaeuser Area	550006102897	800	Link2Learn Virtual Charter School	charter	Regular School	Yes	4.0	PK	12	2016	grade_12	3	3
283460	WI	Barron	school		1080	Public Schools-Multidistrict Charters	Chetek-Weyerhaeuser Area		9410	North Star Academy	charter						2016	grade_12	8	8
283839	WI	Barron	school	5503090	1260	Public school	Cumberland	550309000344	60	Cumberland High		Regular School	No	3.0	09	12	2016	grade_12	63	63
283849	WI	Barron	school	5503090	1260	Public school	Cumberland	550309002962	420	Island City Academy	charter	Vocational Education School	Yes	3.0	07	12	2016	grade_12	1	1
292168	WI	Barron	school	5512180	4557	Public school	Prairie Farm Public	551218001586	40	Prairie Farm High		Regular School	No	3.0	09	12	2016	grade_12	25	25
292740	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_12	11	11
292745	WI	Barron	school	5512810	4802	Public school	Rice Lake Area	551281001699	180	Rice Lake High		Regular School	No	3.0	09	12	2016	grade_12	181	181
294501	WI	Barron	school		5810	Public Schools-Multidistrict Charters	Turtle Lake		9410	North Star Academy	charter						2016	grade_12	1	1
294516	WI	Barron	school	5515060	5810	Public school	Turtle Lake	551506001956	40	Turtle Lake High		Regular School	No	3.0	09	12	2016	grade_12	33	33
326386	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_12	11	11
326413	WI	Barron	school	5500870	308	Public school	Barron Area	550087000114	30	Barron High		Regular School	No	High	09	12	2017	grade_12	101	101
326417	WI	Barron	school		308	Public Schools-Multidistrict Charters	Barron Area		9410	North Star Academy	charter						2017	grade_12	12	12
327131	WI	Barron	school	5502130	903	Public school	Cameron	550213002851	800	Cameron Academy of Virtual Education	charter	Alternative School	Yes	Other	KG	12	2017	grade_12	9	9
327151	WI	Barron	school	5502130	903	Public school	Cameron	550213000257	40	Cameron High		Regular School	No	High	09	12	2017	grade_12	58	58
327160	WI	Barron	school	5502130	903	Public school	Cameron	550213002500	9410	North Star Academy	charter	Alternative School	Yes	High	09	12	2017	grade_12	8	8
327334	WI	Barron	school	5500061	1080	Public school	Chetek-Weyerhaeuser Area	550006102807	400	Chetek-Weyerhaeuser High		Regular School	No	High	09	12	2017	grade_12	60	60
327353	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_12	1	1
327367	WI	Barron	school		1080	Public Schools-Multidistrict Charters	Chetek-Weyerhaeuser Area		9410	North Star Academy	charter						2017	grade_12	7	7
327742	WI	Barron	school	5503090	1260	Public school	Cumberland	550309000344	60	Cumberland High		Regular School	No	High	09	12	2017	grade_12	67	67
327752	WI	Barron	school	5503090	1260	Public school	Cumberland	550309002962	420	Island City Academy	charter	Career and Technical School	Yes	High	07	12	2017	grade_12	2	2
327759	WI	Barron	school	5503090	1260	Public school	Cumberland	550309002871	800	Island City Virtual Academy	charter	Regular School	Yes	Other	PK	12	2017	grade_12	2	2
336046	WI	Barron	school	5512180	4557	Public school	Prairie Farm Public	551218001586	40	Prairie Farm High		Regular School	No	High	09	12	2017	grade_12	31	31
336627	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_12	11	11
336632	WI	Barron	school	5512810	4802	Public school	Rice Lake Area	551281001699	180	Rice Lake High		Regular School	No	High	09	12	2017	grade_12	183	183
338404	WI	Barron	school		5810	Public Schools-Multidistrict Charters	Turtle Lake		9410	North Star Academy	charter						2017	grade_12	3	3
338420	WI	Barron	school	5515060	5810	Public school	Turtle Lake	551506001956	40	Turtle Lake High		Regular School	No	High	09	12	2017	grade_12	29	29
2318892	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_12	11	11
2318911	WI	Barron	school	5500870	308	Public school	Barron Area	550087000114	30	Barron High		Regular School	No	High	09	12	2020	grade_12	89	89
2318916	WI	Barron	school		308	Public Schools-Multidistrict Charters	Barron Area		9410	North Star Academy	charter						2020	grade_12	4	4
2319658	WI	Barron	school	5502130	903	Public school	Cameron	550213002851	800	Cameron Academy of Virtual Education	charter	Alternative School	Yes	Other	PK	12	2020	grade_12	22	22
2319680	WI	Barron	school	5502130	903	Public school	Cameron	550213000257	40	Cameron High		Regular School	No	High	09	12	2020	grade_12	71	71
2319689	WI	Barron	school	5502130	903	Public school	Cameron	550213002500	9410	North Star Academy	charter	Alternative School	Yes	High	09	12	2020	grade_12	5	5
2319865	WI	Barron	school	5500061	1080	Public school	Chetek-Weyerhaeuser Area	550006102807	400	Chetek-Weyerhaeuser High		Regular School	No	High	09	12	2020	grade_12	51	51
2319884	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_12	7	7
2319897	WI	Barron	school		1080	Public Schools-Multidistrict Charters	Chetek-Weyerhaeuser Area		9410	North Star Academy	charter						2020	grade_12	4	4
2320280	WI	Barron	school	5503090	1260	Public school	Cumberland	550309000344	60	Cumberland High		Regular School	No	High	09	12	2020	grade_12	65	65
2320296	WI	Barron	school	5503090	1260	Public school	Cumberland	550309002871	800	Island City Virtual Academy	charter	Regular School	Yes	Other	PK	12	2020	grade_12	3	3
2328698	WI	Barron	school	5512180	4557	Public school	Prairie Farm Public	551218001586	40	Prairie Farm High		Regular School	No	High	09	12	2020	grade_12	15	15