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
111759	WI	Adams	school	5500060	14	Public school	Adams-Friendship Area	550006001433	130	Adams-Friendship Elementary		Regular School	No	1.0	PK	05	2015	grade_2	72	72
111777	WI	Adams	school	5500060	14	Public school	Adams-Friendship Area	550006000010	140	Grand Marsh Elementary		Regular School	No	1.0	PK	05	2015	grade_2	16	16
111785	WI	Adams	school	5500060	14	Public school	Adams-Friendship Area	550006000012	200	Roche-A-Cri Elementary		Regular School	No	1.0	PK	05	2015	grade_2	16	16
281733	WI	Adams	school	5500060	14	Public school	Adams-Friendship Area	550006001433	130	Adams-Friendship Elementary		Regular School	No	1.0	PK	05	2016	grade_2	75	75
281751	WI	Adams	school	5500060	14	Public school	Adams-Friendship Area	550006000010	140	Grand Marsh Elementary		Regular School	No	1.0	PK	05	2016	grade_2	26	26
281759	WI	Adams	school	5500060	14	Public school	Adams-Friendship Area	550006000012	200	Roche-A-Cri Elementary		Regular School	No	1.0	PK	05	2016	grade_2	23	23
325629	WI	Adams	school	5500060	14	Public school	Adams-Friendship Area	550006001433	130	Adams-Friendship Elementary		Regular School	No	Elementary	PK	05	2017	grade_2	53	53
325648	WI	Adams	school	5500060	14	Public school	Adams-Friendship Area	550006000010	140	Grand Marsh Elementary		Regular School	No	Elementary	PK	05	2017	grade_2	24	24
325657	WI	Adams	school	5500060	14	Public school	Adams-Friendship Area	550006000012	200	Roche-A-Cri Elementary		Regular School	No	Elementary	PK	05	2017	grade_2	22	22
2318153	WI	Adams	school	5500060	14	Public school	Adams-Friendship Area	550006001433	130	Adams-Friendship Elementary		Regular School	No	Elementary	PK	04	2020	grade_2	74	74
2318172	WI	Adams	school	5500060	14	Public school	Adams-Friendship Area	550006000010	140	Grand Marsh Elementary		Regular School	No	Elementary	PK	04	2020	grade_2	16	16
2332957	WI	Adams	school	5500060	14	Public school	Adams-Friendship Area	550006001433	130	Adams-Friendship Elementary		Regular School	No	Elementary	PK	04	2021	grade_2	91	91
3073923	WI	Adams	school	5500060	14	Public school	Adams-Friendship Area	550006001433	130	Adams-Friendship Elementary		Regular School	No	Elementary	PK	04	2019	grade_2	61	61
3073941	WI	Adams	school	5500060	14	Public school	Adams-Friendship Area	550006000010	140	Grand Marsh Elementary		Regular School	No	Elementary	PK	04	2019	grade_2	14	14
3088671	WI	Adams	school	5500060	14	Public school	Adams-Friendship Area	550006001433	130	Adams-Friendship Elementary		Regular School	No	Elementary	PK	05	2018	grade_2	63	63
3088689	WI	Adams	school	5500060	14	Public school	Adams-Friendship Area	550006000010	140	Grand Marsh Elementary		Regular School	No	Elementary	PK	05	2018	grade_2	24	24
3088697	WI	Adams	school	5500060	14	Public school	Adams-Friendship Area	550006000012	200	Roche-A-Cri Elementary		Regular School	No	Elementary	PK	05	2018	grade_2	26	26
112304	WI	Ashland	school	5500510	170	Public school	Ashland	550051000077	80	Lake Superior Primary		Regular School	No	1.0	PK	02	2015	grade_2	133	133
112309	WI	Ashland	school	5500510	170	Public school	Ashland	550051000079	120	Marengo Valley Elementary		Regular School	No	1.0	PK	05	2015	grade_2	33	33
113179	WI	Ashland	school	5501920	840	Public school	Butternut	550192000245	20	Butternut Elementary		Regular School	No	1.0	PK	05	2015	grade_2	14	14
118363	WI	Ashland	school	5508970	3427	Public school	Mellen	550897002941	800	Mellen Public School		Regular School	No	4.0	PK	12	2015	grade_2	20	20
282283	WI	Ashland	school	5500510	170	Public school	Ashland	550051000077	80	Lake Superior Primary		Regular School	No	1.0	PK	02	2016	grade_2	141	141
282288	WI	Ashland	school	5500510	170	Public school	Ashland	550051000079	120	Marengo Valley Elementary		Regular School	No	1.0	PK	05	2016	grade_2	35	35
283161	WI	Ashland	school	5501920	840	Public school	Butternut	550192000245	20	Butternut Elementary		Regular School	No	1.0	PK	05	2016	grade_2	14	14
288359	WI	Ashland	school	5508970	3427	Public school	Mellen	550897002941	800	Mellen Public School		Regular School	No	4.0	PK	12	2016	grade_2	19	19
326182	WI	Ashland	school	5500510	170	Public school	Ashland	550051000077	80	Lake Superior Primary		Regular School	No	Elementary	PK	02	2017	grade_2	130	130
326187	WI	Ashland	school	5500510	170	Public school	Ashland	550051000079	120	Marengo Valley Elementary		Regular School	No	Elementary	PK	05	2017	grade_2	33	33
327059	WI	Ashland	school	5501920	840	Public school	Butternut	550192000245	20	Butternut Elementary		Regular School	No	Elementary	PK	05	2017	grade_2	9	9
332233	WI	Ashland	school	5508970	3427	Public school	Mellen	550897002941	800	Mellen Public School		Regular School	No	Other	PK	12	2017	grade_2	30	30
2318658	WI	Ashland	school	5500510	170	Public school	Ashland	550051000077	80	Lake Superior Elementary		Regular School	No	Elementary	PK	05	2020	grade_2	109	109
2318677	WI	Ashland	school	5500510	170	Public school	Ashland	550051000079	120	Marengo Valley Elementary		Regular School	No	Elementary	PK	05	2020	grade_2	26	26
2319576	WI	Ashland	school	5501920	840	Public school	Butternut	550192000245	20	Butternut Elementary		Regular School	No	Elementary	PK	05	2020	grade_2	14	14
2324869	WI	Ashland	school	5508970	3427	Public school	Mellen	550897002941	800	Mellen Public School		Regular School	No	Other	PK	12	2020	grade_2	22	22
2333453	WI	Ashland	school	5500510	170	Public school	Ashland	550051000077	80	Lake Superior Elementary		Regular School	No	Elementary	PK	05	2021	grade_2	96	96
2333462	WI	Ashland	school	5500510	170	Public school	Ashland	550051000079	120	Marengo Valley Elementary		Regular School	No	Elementary	PK	05	2021	grade_2	34	34
2333472	WI	Ashland	school		170	Public Schools-Multidistrict Charters	Ashland		9100	Rural Virtual Academy							2021	grade_2	1	1
2334357	WI	Ashland	school	5501920	840	Public school	Butternut	550192000245	20	Butternut Elementary		Regular School	No	Elementary	PK	05	2021	grade_2	9	9
2339757	WI	Ashland	school	5508970	3427	Public school	Mellen	550897002941	800	Mellen Public School		Regular School	No	Other	KG	12	2021	grade_2	21	21
3074462	WI	Ashland	school	5500510	170	Public school	Ashland	550051000077	80	Lake Superior Primary		Regular School	No	Elementary	PK	02	2019	grade_2	100	100
3074468	WI	Ashland	school	5500510	170	Public school	Ashland	550051000079	120	Marengo Valley Elementary		Regular School	No	Elementary	PK	05	2019	grade_2	25	25
3075357	WI	Ashland	school	5501920	840	Public school	Butternut	550192000245	20	Butternut Elementary		Regular School	No	Elementary	PK	05	2019	grade_2	11	11
3080597	WI	Ashland	school	5508970	3427	Public school	Mellen	550897002941	800	Mellen Public School		Regular School	No	Other	PK	12	2019	grade_2	17	17
3089217	WI	Ashland	school	5500510	170	Public school	Ashland	550051000077	80	Lake Superior Primary		Regular School	No	Elementary	PK	02	2018	grade_2	107	107
3089223	WI	Ashland	school	5500510	170	Public school	Ashland	550051000079	120	Marengo Valley Elementary		Regular School	No	Elementary	PK	05	2018	grade_2	27	27
3090112	WI	Ashland	school	5501920	840	Public school	Butternut	550192000245	20	Butternut Elementary		Regular School	No	Elementary	PK	05	2018	grade_2	11	11
3095313	WI	Ashland	school	5508970	3427	Public school	Mellen	550897002941	800	Mellen Public School		Regular School	No	Other	PK	12	2018	grade_2	15	15
112508	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_2	1	1
112519	WI	Barron	school	5500870	308	Public school	Barron Area	550087000113	20	Almena Elementary		Regular School	No	1.0	PK	04	2015	grade_2	13	13
112526	WI	Barron	school	5500870	308	Public school	Barron Area	550087002717	100	Barron Area Montessori School	charter	Regular School	Yes	1.0	PK	04	2015	grade_2	6	6
112541	WI	Barron	school	5500870	308	Public school	Barron Area	550087000117	120	Ridgeland-Dallas Elementary		Regular School	No	1.0	PK	04	2015	grade_2	12	12
112553	WI	Barron	school	5500870	308	Public school	Barron Area	550087000119	160	Woodland Elementary		Regular School	No	1.0	PK	04	2015	grade_2	66	66
113254	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_2	6	6
113265	WI	Barron	school	5502130	903	Public school	Cameron	550213000256	20	Cameron Elementary		Regular School	No	1.0	PK	04	2015	grade_2	87	87
113458	WI	Barron	school	5500061	1080	Public school	Chetek-Weyerhaeuser Area	550006102805	100	Chetek-Weyerhaeuser Roselawn Elementary		Regular School	No	1.0	PK	05	2015	grade_2	68	68
113470	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_2	4	4
113853	WI	Barron	school	5503090	1260	Public school	Cumberland	550309000343	40	Cumberland Elementary		Regular School	No	1.0	PK	04	2015	grade_2	62	62
113879	WI	Barron	school	5503090	1260	Public school	Cumberland	550309002871	800	Island City Virtual Academy	charter	Regular School	Yes	4.0	PK	12	2015	grade_2	2	2
122198	WI	Barron	school	5512180	4557	Public school	Prairie Farm Public	551218001585	20	Prairie Farm Elementary		Regular School	No	1.0	PK	05	2015	grade_2	43	43
122749	WI	Barron	school	5512810	4802	Public school	Rice Lake Area	551281001693	60	Haugen Elementary		Regular School	No	1.0	PK	04	2015	grade_2	16	16
122760	WI	Barron	school	5512810	4802	Public school	Rice Lake Area	551281001694	80	Hilltop Elementary		Regular School	No	1.0	PK	04	2015	grade_2	70	70
122767	WI	Barron	school	5512810	4802	Public school	Rice Lake Area	551281001695	100	Jefferson Elementary		Regular School	No	1.0	PK	04	2015	grade_2	34	34
122792	WI	Barron	school	5512810	4802	Public school	Rice Lake Area	551281000581	25	Tainter Elementary		Regular School	No	1.0	PK	04	2015	grade_2	48	48
124570	WI	Barron	school	5515060	5810	Public school	Turtle Lake	551506001955	20	Turtle Lake Elementary		Regular School	No	1.0	PK	08	2015	grade_2	27	27
282488	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_2	1	1
282499	WI	Barron	school	5500870	308	Public school	Barron Area	550087000113	20	Almena Elementary		Regular School	No	1.0	PK	04	2016	grade_2	13	13
282506	WI	Barron	school	5500870	308	Public school	Barron Area	550087002717	100	Barron Area Montessori School	charter	Regular School	Yes	1.0	PK	04	2016	grade_2	7	7
282522	WI	Barron	school	5500870	308	Public school	Barron Area	550087000117	120	Ridgeland-Dallas Elementary		Regular School	No	1.0	PK	04	2016	grade_2	10	10
282534	WI	Barron	school	5500870	308	Public school	Barron Area	550087000119	160	Woodland Elementary		Regular School	No	1.0	PK	04	2016	grade_2	55	55
283236	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_2	8	8
283247	WI	Barron	school	5502130	903	Public school	Cameron	550213000256	20	Cameron Elementary		Regular School	No	1.0	PK	04	2016	grade_2	83	83
283437	WI	Barron	school	5500061	1080	Public school	Chetek-Weyerhaeuser Area	550006102805	100	Chetek-Weyerhaeuser Roselawn Elementary		Regular School	No	1.0	PK	05	2016	grade_2	71	71
283448	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_2	9	9
283830	WI	Barron	school	5503090	1260	Public school	Cumberland	550309000343	40	Cumberland Elementary		Regular School	No	1.0	PK	04	2016	grade_2	67	67
292158	WI	Barron	school	5512180	4557	Public school	Prairie Farm Public	551218001585	20	Prairie Farm Elementary		Regular School	No	1.0	PK	05	2016	grade_2	28	28
292722	WI	Barron	school	5512810	4802	Public school	Rice Lake Area	551281001693	60	Haugen Elementary		Regular School	No	1.0	PK	04	2016	grade_2	16	16
292733	WI	Barron	school	5512810	4802	Public school	Rice Lake Area	551281001694	80	Hilltop Elementary		Regular School	No	1.0	KG	04	2016	grade_2	45	45
292754	WI	Barron	school	5512810	4802	Public school	Rice Lake Area	551281000581	25	Tainter Elementary		Regular School	No	1.0	PK	04	2016	grade_2	82	82
294504	WI	Barron	school	5515060	5810	Public school	Turtle Lake	551506001955	20	Turtle Lake Elementary		Regular School	No	1.0	PK	08	2016	grade_2	36	36
326387	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_2	1	1
326398	WI	Barron	school	5500870	308	Public school	Barron Area	550087000113	20	Almena Elementary		Regular School	No	Elementary	PK	04	2017	grade_2	12	12
326406	WI	Barron	school	5500870	308	Public school	Barron Area	550087002717	100	Barron Area Montessori School	charter	Regular School	Yes	Elementary	PK	03	2017	grade_2	10	10
326420	WI	Barron	school	5500870	308	Public school	Barron Area	550087000117	120	Ridgeland-Dallas Elementary		Regular School	No	Elementary	PK	04	2017	grade_2	11	11
326432	WI	Barron	school	5500870	308	Public school	Barron Area	550087000119	160	Woodland Elementary		Regular School	No	Elementary	PK	04	2017	grade_2	54	54
327132	WI	Barron	school	5502130	903	Public school	Cameron	550213002851	800	Cameron Academy of Virtual Education	charter	Alternative School	Yes	Other	KG	12	2017	grade_2	5	5
327143	WI	Barron	school	5502130	903	Public school	Cameron	550213000256	20	Cameron Elementary		Regular School	No	Elementary	PK	04	2017	grade_2	82	82
327342	WI	Barron	school	5500061	1080	Public school	Chetek-Weyerhaeuser Area	550006102805	100	Chetek-Weyerhaeuser Roselawn Elementary		Regular School	No	Elementary	PK	05	2017	grade_2	66	66
327354	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_2	4	4
327733	WI	Barron	school	5503090	1260	Public school	Cumberland	550309000343	40	Cumberland Elementary		Regular School	No	Elementary	PK	04	2017	grade_2	73	73
336036	WI	Barron	school	5512180	4557	Public school	Prairie Farm Public	551218001585	20	Prairie Farm Elementary		Regular School	No	Elementary	PK	05	2017	grade_2	37	37
336609	WI	Barron	school	5512810	4802	Public school	Rice Lake Area	551281001693	60	Haugen Elementary		Regular School	No	Elementary	PK	04	2017	grade_2	14	14
336620	WI	Barron	school	5512810	4802	Public school	Rice Lake Area	551281001694	80	Hilltop Elementary		Regular School	No	Elementary	KG	04	2017	grade_2	54	54
336641	WI	Barron	school	5512810	4802	Public school	Rice Lake Area	551281000581	25	Tainter Elementary		Regular School	No	Elementary	PK	04	2017	grade_2	73	73
338407	WI	Barron	school	5515060	5810	Public school	Turtle Lake	551506001955	20	Turtle Lake Elementary		Regular School	No	Elementary	PK	08	2017	grade_2	38	38
2318899	WI	Barron	school	5500870	308	Public school	Barron Area	550087000113	20	Almena Elementary		Regular School	No	Elementary	02	04	2020	grade_2	14	14
2318904	WI	Barron	school	5500870	308	Public school	Barron Area	550087002717	100	Barron Area Montessori School	charter	Regular School	Yes	Elementary	PK	03	2020	grade_2	9	9
2318919	WI	Barron	school	5500870	308	Public school	Barron Area	550087000117	120	Ridgeland-Dallas Elementary		Regular School	No	Elementary	PK	04	2020	grade_2	15	15
2318931	WI	Barron	school	5500870	308	Public school	Barron Area	550087000119	160	Woodland Elementary		Regular School	No	Elementary	PK	04	2020	grade_2	51	51
2319659	WI	Barron	school	5502130	903	Public school	Cameron	550213002851	800	Cameron Academy of Virtual Education	charter	Alternative School	Yes	Other	PK	12	2020	grade_2	7	7
2319671	WI	Barron	school	5502130	903	Public school	Cameron	550213000256	20	Cameron Elementary		Regular School	No	Elementary	PK	04	2020	grade_2	79	79
2319873	WI	Barron	school	5500061	1080	Public school	Chetek-Weyerhaeuser Area	550006102805	100	Chetek-Weyerhaeuser Roselawn Elementary		Regular School	No	Elementary	PK	05	2020	grade_2	76	76
2319885	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_2	3	3