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
111767	WI	Adams	school	5500060	14	Public school	Adams-Friendship Area	550006000005	40	Adams-Friendship High		Regular School	No	3.0	09	12	2015	grade_10	140	140
281741	WI	Adams	school	5500060	14	Public school	Adams-Friendship Area	550006000005	40	Adams-Friendship High		Regular School	No	3.0	09	12	2016	grade_10	107	107
325637	WI	Adams	school	5500060	14	Public school	Adams-Friendship Area	550006000005	40	Adams-Friendship High		Regular School	No	High	09	12	2017	grade_10	139	139
2318161	WI	Adams	school	5500060	14	Public school	Adams-Friendship Area	550006000005	40	Adams-Friendship High		Regular School	No	High	09	12	2020	grade_10	130	130
2332964	WI	Adams	school	5500060	14	Public school	Adams-Friendship Area	550006000005	40	Adams-Friendship High		Regular School	No	High	09	12	2021	grade_10	115	115
3073930	WI	Adams	school	5500060	14	Public school	Adams-Friendship Area	550006000005	40	Adams-Friendship High		Regular School	No	High	09	12	2019	grade_10	111	111
3088679	WI	Adams	school	5500060	14	Public school	Adams-Friendship Area	550006000005	40	Adams-Friendship High		Regular School	No	High	09	12	2018	grade_10	116	116
112290	WI	Ashland	school	5500510	170	Public school	Ashland	550051000073	20	Ashland High		Regular School	No	3.0	09	12	2015	grade_10	172	172
113186	WI	Ashland	school	5501920	840	Public school	Butternut	550192000246	40	Butternut High		Regular School	No	4.0	06	12	2015	grade_10	18	18
118360	WI	Ashland	school	5508970	3427	Public school	Mellen	550897002941	800	Mellen Public School		Regular School	No	4.0	PK	12	2015	grade_10	15	15
282260	WI	Ashland	school	5500510	170	Public school	Ashland	550051003017	400	Ashland Charter High School	charter	Regular School	Yes	3.0	09	12	2016	grade_10	15	15
282269	WI	Ashland	school	5500510	170	Public school	Ashland	550051000073	20	Ashland High		Regular School	No	3.0	09	12	2016	grade_10	162	162
283169	WI	Ashland	school	5501920	840	Public school	Butternut	550192000246	40	Butternut High		Regular School	No	4.0	06	12	2016	grade_10	13	13
288356	WI	Ashland	school	5508970	3427	Public school	Mellen	550897002941	800	Mellen Public School		Regular School	No	4.0	PK	12	2016	grade_10	23	23
326159	WI	Ashland	school	5500510	170	Public school	Ashland	550051003017	400	Ashland Charter High School	charter	Regular School	Yes	High	09	12	2017	grade_10	2	2
326168	WI	Ashland	school	5500510	170	Public school	Ashland	550051000073	20	Ashland High		Regular School	No	High	09	12	2017	grade_10	152	152
327067	WI	Ashland	school	5501920	840	Public school	Butternut	550192000246	40	Butternut High		Regular School	No	Other	06	12	2017	grade_10	16	16
332230	WI	Ashland	school	5508970	3427	Public school	Mellen	550897002941	800	Mellen Public School		Regular School	No	Other	PK	12	2017	grade_10	18	18
2318648	WI	Ashland	school	5500510	170	Public school	Ashland	550051000073	20	Ashland High		Regular School	No	High	09	12	2020	grade_10	139	139
2318666	WI	Ashland	school	5500510	170	Public school	Ashland	550051003017	400	Lake Superior High	charter	Regular School	Yes	High	09	12	2020	grade_10	9	9
2318687	WI	Ashland	school		170	Public Schools-Multidistrict Charters	Ashland		9100	Rural Virtual Academy							2020	grade_10	1	1
2319584	WI	Ashland	school	5501920	840	Public school	Butternut	550192000246	40	Butternut High		Regular School	No	High	06	12	2020	grade_10	14	14
2324866	WI	Ashland	school	5508970	3427	Public school	Mellen	550897002941	800	Mellen Public School		Regular School	No	Other	PK	12	2020	grade_10	11	11
2333443	WI	Ashland	school	5500510	170	Public school	Ashland	550051000073	20	Ashland High		Regular School	No	High	09	12	2021	grade_10	161	161
2333469	WI	Ashland	school		170	Public Schools-Multidistrict Charters	Ashland		9100	Rural Virtual Academy							2021	grade_10	1	1
2334365	WI	Ashland	school	5501920	840	Public school	Butternut	550192000246	40	Butternut High		Regular School	No	High	06	12	2021	grade_10	13	13
2339754	WI	Ashland	school	5508970	3427	Public school	Mellen	550897002941	800	Mellen Public School		Regular School	No	Other	KG	12	2021	grade_10	27	27
3074438	WI	Ashland	school	5500510	170	Public school	Ashland	550051000073	20	Ashland High		Regular School	No	High	09	12	2019	grade_10	173	173
3074447	WI	Ashland	school	5500510	170	Public school	Ashland	550051003017	400	Lake Superior High	charter	Regular School	Yes	High	09	12	2019	grade_10	4	4
3075365	WI	Ashland	school	5501920	840	Public school	Butternut	550192000246	40	Butternut High		Regular School	No	High	06	12	2019	grade_10	15	15
3075373	WI	Ashland	school	5501920	840	Public school	Butternut	550192002751	450	Promethean Charter School	charter	Regular School	Yes	High	09	12	2019	grade_10	1	1
3080594	WI	Ashland	school	5508970	3427	Public school	Mellen	550897002941	800	Mellen Public School		Regular School	No	Other	PK	12	2019	grade_10	24	24
3089194	WI	Ashland	school	5500510	170	Public school	Ashland	550051000073	20	Ashland High		Regular School	No	High	09	12	2018	grade_10	161	161
3089203	WI	Ashland	school	5500510	170	Public school	Ashland	550051003017	400	Lake Superior High	charter	Regular School	Yes	High	09	12	2018	grade_10	8	8
3090120	WI	Ashland	school	5501920	840	Public school	Butternut	550192000246	40	Butternut High		Regular School	No	High	06	12	2018	grade_10	10	10
3090128	WI	Ashland	school	5501920	840	Public school	Butternut	550192002751	450	Promethean Charter School	charter	Regular School	Yes	High	09	12	2018	grade_10	1	1
3095310	WI	Ashland	school	5508970	3427	Public school	Mellen	550897002941	800	Mellen Public School		Regular School	No	Other	PK	12	2018	grade_10	24	24
112505	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_10	16	16
112532	WI	Barron	school	5500870	308	Public school	Barron Area	550087000114	30	Barron High		Regular School	No	3.0	09	12	2015	grade_10	99	99
113251	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_10	10	10
113272	WI	Barron	school	5502130	903	Public school	Cameron	550213000257	40	Cameron High		Regular School	No	3.0	09	12	2015	grade_10	65	65
113448	WI	Barron	school	5500061	1080	Public school	Chetek-Weyerhaeuser Area	550006102807	400	Chetek-Weyerhaeuser High		Regular School	No	3.0	09	12	2015	grade_10	60	60
113467	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_10	1	1
113860	WI	Barron	school	5503090	1260	Public school	Cumberland	550309000344	60	Cumberland High		Regular School	No	3.0	09	12	2015	grade_10	63	63
113870	WI	Barron	school	5503090	1260	Public school	Cumberland	550309002962	420	Island City Academy	charter	Vocational Education School	Yes	3.0	07	12	2015	grade_10	5	5
122205	WI	Barron	school	5512180	4557	Public school	Prairie Farm Public	551218001586	40	Prairie Farm High		Regular School	No	3.0	09	12	2015	grade_10	30	30
122773	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_10	14	14
122781	WI	Barron	school	5512810	4802	Public school	Rice Lake Area	551281001699	180	Rice Lake High		Regular School	No	3.0	09	12	2015	grade_10	171	171
124581	WI	Barron	school	5515060	5810	Public school	Turtle Lake	551506001956	40	Turtle Lake High		Regular School	No	3.0	09	12	2015	grade_10	26	26
282485	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_10	6	6
282512	WI	Barron	school	5500870	308	Public school	Barron Area	550087000114	30	Barron High		Regular School	No	3.0	09	12	2016	grade_10	88	88
282517	WI	Barron	school		308	Public Schools-Multidistrict Charters	Barron Area		9410	North Star Academy	charter						2016	grade_10	3	3
283233	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_10	5	5
283254	WI	Barron	school	5502130	903	Public school	Cameron	550213000257	40	Cameron High		Regular School	No	3.0	09	12	2016	grade_10	67	67
283427	WI	Barron	school	5500061	1080	Public school	Chetek-Weyerhaeuser Area	550006102807	400	Chetek-Weyerhaeuser High		Regular School	No	3.0	09	12	2016	grade_10	74	74
283446	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_10	7	7
283837	WI	Barron	school	5503090	1260	Public school	Cumberland	550309000344	60	Cumberland High		Regular School	No	3.0	09	12	2016	grade_10	82	82
283847	WI	Barron	school	5503090	1260	Public school	Cumberland	550309002962	420	Island City Academy	charter	Vocational Education School	Yes	3.0	07	12	2016	grade_10	10	10
292166	WI	Barron	school	5512180	4557	Public school	Prairie Farm Public	551218001586	40	Prairie Farm High		Regular School	No	3.0	09	12	2016	grade_10	30	30
292738	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_10	8	8
292743	WI	Barron	school	5512810	4802	Public school	Rice Lake Area	551281001699	180	Rice Lake High		Regular School	No	3.0	09	12	2016	grade_10	167	167
294514	WI	Barron	school	5515060	5810	Public school	Turtle Lake	551506001956	40	Turtle Lake High		Regular School	No	3.0	09	12	2016	grade_10	27	27
326384	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_10	8	8
326411	WI	Barron	school	5500870	308	Public school	Barron Area	550087000114	30	Barron High		Regular School	No	High	09	12	2017	grade_10	90	90
327129	WI	Barron	school	5502130	903	Public school	Cameron	550213002851	800	Cameron Academy of Virtual Education	charter	Alternative School	Yes	Other	KG	12	2017	grade_10	4	4
327149	WI	Barron	school	5502130	903	Public school	Cameron	550213000257	40	Cameron High		Regular School	No	High	09	12	2017	grade_10	64	64
327332	WI	Barron	school	5500061	1080	Public school	Chetek-Weyerhaeuser Area	550006102807	400	Chetek-Weyerhaeuser High		Regular School	No	High	09	12	2017	grade_10	58	58
327351	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_10	2	2
327365	WI	Barron	school		1080	Public Schools-Multidistrict Charters	Chetek-Weyerhaeuser Area		9410	North Star Academy	charter						2017	grade_10	1	1
327740	WI	Barron	school	5503090	1260	Public school	Cumberland	550309000344	60	Cumberland High		Regular School	No	High	09	12	2017	grade_10	62	62
327750	WI	Barron	school	5503090	1260	Public school	Cumberland	550309002962	420	Island City Academy	charter	Career and Technical School	Yes	High	07	12	2017	grade_10	3	3
327758	WI	Barron	school	5503090	1260	Public school	Cumberland	550309002871	800	Island City Virtual Academy	charter	Regular School	Yes	Other	PK	12	2017	grade_10	4	4
336044	WI	Barron	school	5512180	4557	Public school	Prairie Farm Public	551218001586	40	Prairie Farm High		Regular School	No	High	09	12	2017	grade_10	23	23
336625	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_10	6	6
336630	WI	Barron	school	5512810	4802	Public school	Rice Lake Area	551281001699	180	Rice Lake High		Regular School	No	High	09	12	2017	grade_10	166	166
338397	WI	Barron	school	5515060	5810	Public school	Turtle Lake	551506003032	810	Laker Online	charter	Regular School	Yes	Other	PK	12	2017	grade_10	1	1
338418	WI	Barron	school	5515060	5810	Public school	Turtle Lake	551506001956	40	Turtle Lake High		Regular School	No	High	09	12	2017	grade_10	25	25
2318890	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_10	9	9
2318909	WI	Barron	school	5500870	308	Public school	Barron Area	550087000114	30	Barron High		Regular School	No	High	09	12	2020	grade_10	81	81
2318914	WI	Barron	school		308	Public Schools-Multidistrict Charters	Barron Area		9410	North Star Academy	charter						2020	grade_10	2	2
2319656	WI	Barron	school	5502130	903	Public school	Cameron	550213002851	800	Cameron Academy of Virtual Education	charter	Alternative School	Yes	Other	PK	12	2020	grade_10	8	8
2319678	WI	Barron	school	5502130	903	Public school	Cameron	550213000257	40	Cameron High		Regular School	No	High	09	12	2020	grade_10	65	65
2319863	WI	Barron	school	5500061	1080	Public school	Chetek-Weyerhaeuser Area	550006102807	400	Chetek-Weyerhaeuser High		Regular School	No	High	09	12	2020	grade_10	62	62
2319882	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_10	2	2
2320278	WI	Barron	school	5503090	1260	Public school	Cumberland	550309000344	60	Cumberland High		Regular School	No	High	09	12	2020	grade_10	70	70
2320288	WI	Barron	school	5503090	1260	Public school	Cumberland	550309002962	420	Island City Academy	charter	Career and Technical School	Yes	High	07	12	2020	grade_10	4	4
2320294	WI	Barron	school	5503090	1260	Public school	Cumberland	550309002871	800	Island City Virtual Academy	charter	Regular School	Yes	Other	PK	12	2020	grade_10	1	1
2328696	WI	Barron	school	5512180	4557	Public school	Prairie Farm Public	551218001586	40	Prairie Farm High		Regular School	No	High	09	12	2020	grade_10	26	26
2329246	WI	Barron	school	5512810	4802	Public school	Rice Lake Area	551281001699	180	Rice Lake High		Regular School	No	High	09	12	2020	grade_10	163	163
2331085	WI	Barron	school	5515060	5810	Public school	Turtle Lake	551506001956	40	Turtle Lake High		Regular School	No	High	09	12	2020	grade_10	31	31
2333671	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_10	22	22
2333694	WI	Barron	school	5500870	308	Public school	Barron Area	550087000114	30	Barron High		Regular School	No	High	09	12	2021	grade_10	80	80
2334449	WI	Barron	school	5502130	903	Public school	Cameron	550213002851	800	Cameron Academy of Virtual Education	charter	Alternative School	Yes	Other	PK	12	2021	grade_10	17	17
2334471	WI	Barron	school	5502130	903	Public school	Cameron	550213000257	40	Cameron High		Regular School	No	High	09	12	2021	grade_10	67	67
2334649	WI	Barron	school	5500061	1080	Public school	Chetek-Weyerhaeuser Area	550006102807	400	Chetek-Weyerhaeuser High		Regular School	No	High	09	12	2021	grade_10	63	63
2334668	WI	Barron	school	5500061	1080	Public school	Chetek-Weyerhaeuser Area	550006102897	800	Link2Learn Virtual Charter School	charter	Regular School	Yes	Other	PK	12	2021	grade_10	1	1
2334681	WI	Barron	school		1080	Public Schools-Multidistrict Charters	Chetek-Weyerhaeuser Area		9410	North Star Academy	charter						2021	grade_10	1	1
2335073	WI	Barron	school	5503090	1260	Public school	Cumberland	550309000344	60	Cumberland High		Regular School	No	High	09	12	2021	grade_10	68	68
2335083	WI	Barron	school	5503090	1260	Public school	Cumberland	550309002962	420	Island City Academy	charter	Career and Technical School	Yes	High	07	12	2021	grade_10	3	3
2335090	WI	Barron	school	5503090	1260	Public school	Cumberland	550309002871	800	Island City Virtual Academy	charter	Regular School	Yes	Other	PK	12	2021	grade_10	4	4
2343586	WI	Barron	school	5512180	4557	Public school	Prairie Farm Public	551218001586	40	Prairie Farm High		Regular School	No	High	09	12	2021	grade_10	25	25