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
111760	WI	Adams	school	5500060	14	Public school	Adams-Friendship Area	550006001433	130	Adams-Friendship Elementary		Regular School	No	1.0	PK	05	2015	grade_3	67	67
111778	WI	Adams	school	5500060	14	Public school	Adams-Friendship Area	550006000010	140	Grand Marsh Elementary		Regular School	No	1.0	PK	05	2015	grade_3	22	22
111786	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_3	15	15
281734	WI	Adams	school	5500060	14	Public school	Adams-Friendship Area	550006001433	130	Adams-Friendship Elementary		Regular School	No	1.0	PK	05	2016	grade_3	72	72
281752	WI	Adams	school	5500060	14	Public school	Adams-Friendship Area	550006000010	140	Grand Marsh Elementary		Regular School	No	1.0	PK	05	2016	grade_3	20	20
281760	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_3	16	16
325630	WI	Adams	school	5500060	14	Public school	Adams-Friendship Area	550006001433	130	Adams-Friendship Elementary		Regular School	No	Elementary	PK	05	2017	grade_3	76	76
325649	WI	Adams	school	5500060	14	Public school	Adams-Friendship Area	550006000010	140	Grand Marsh Elementary		Regular School	No	Elementary	PK	05	2017	grade_3	28	28
325658	WI	Adams	school	5500060	14	Public school	Adams-Friendship Area	550006000012	200	Roche-A-Cri Elementary		Regular School	No	Elementary	PK	05	2017	grade_3	26	26
2318154	WI	Adams	school	5500060	14	Public school	Adams-Friendship Area	550006001433	130	Adams-Friendship Elementary		Regular School	No	Elementary	PK	04	2020	grade_3	66	66
2318173	WI	Adams	school	5500060	14	Public school	Adams-Friendship Area	550006000010	140	Grand Marsh Elementary		Regular School	No	Elementary	PK	04	2020	grade_3	11	11
2332958	WI	Adams	school	5500060	14	Public school	Adams-Friendship Area	550006001433	130	Adams-Friendship Elementary		Regular School	No	Elementary	PK	04	2021	grade_3	81	81
3073924	WI	Adams	school	5500060	14	Public school	Adams-Friendship Area	550006001433	130	Adams-Friendship Elementary		Regular School	No	Elementary	PK	04	2019	grade_3	94	94
3073942	WI	Adams	school	5500060	14	Public school	Adams-Friendship Area	550006000010	140	Grand Marsh Elementary		Regular School	No	Elementary	PK	04	2019	grade_3	20	20
3088672	WI	Adams	school	5500060	14	Public school	Adams-Friendship Area	550006001433	130	Adams-Friendship Elementary		Regular School	No	Elementary	PK	05	2018	grade_3	56	56
3088690	WI	Adams	school	5500060	14	Public school	Adams-Friendship Area	550006000010	140	Grand Marsh Elementary		Regular School	No	Elementary	PK	05	2018	grade_3	24	24
3088698	WI	Adams	school	5500060	14	Public school	Adams-Friendship Area	550006000012	200	Roche-A-Cri Elementary		Regular School	No	Elementary	PK	05	2018	grade_3	21	21
112286	WI	Ashland	school	5500510	170	Public school	Ashland	550051002928	130	Ashland Elementary Charter School	charter	Regular School	Yes	1.0	03	05	2015	grade_3	28	28
112299	WI	Ashland	school	5500510	170	Public school	Ashland	550051000076	60	Lake Superior Intermediate		Regular School	No	1.0	03	05	2015	grade_3	108	108
112310	WI	Ashland	school	5500510	170	Public school	Ashland	550051000079	120	Marengo Valley Elementary		Regular School	No	1.0	PK	05	2015	grade_3	26	26
113180	WI	Ashland	school	5501920	840	Public school	Butternut	550192000245	20	Butternut Elementary		Regular School	No	1.0	PK	05	2015	grade_3	14	14
118364	WI	Ashland	school	5508970	3427	Public school	Mellen	550897002941	800	Mellen Public School		Regular School	No	4.0	PK	12	2015	grade_3	18	18
282265	WI	Ashland	school	5500510	170	Public school	Ashland	550051002928	130	Ashland Elementary Charter School	charter	Regular School	Yes	1.0	03	05	2016	grade_3	23	23
282278	WI	Ashland	school	5500510	170	Public school	Ashland	550051000076	60	Lake Superior Intermediate		Regular School	No	1.0	03	05	2016	grade_3	114	114
282289	WI	Ashland	school	5500510	170	Public school	Ashland	550051000079	120	Marengo Valley Elementary		Regular School	No	1.0	PK	05	2016	grade_3	34	34
283162	WI	Ashland	school	5501920	840	Public school	Butternut	550192000245	20	Butternut Elementary		Regular School	No	1.0	PK	05	2016	grade_3	15	15
288360	WI	Ashland	school	5508970	3427	Public school	Mellen	550897002941	800	Mellen Public School		Regular School	No	4.0	PK	12	2016	grade_3	18	18
326164	WI	Ashland	school	5500510	170	Public school	Ashland	550051002928	130	Ashland Elementary Charter School	charter	Regular School	Yes	Elementary	03	05	2017	grade_3	23	23
326177	WI	Ashland	school	5500510	170	Public school	Ashland	550051000076	60	Lake Superior Intermediate		Regular School	No	Elementary	03	05	2017	grade_3	118	118
326188	WI	Ashland	school	5500510	170	Public school	Ashland	550051000079	120	Marengo Valley Elementary		Regular School	No	Elementary	PK	05	2017	grade_3	34	34
327060	WI	Ashland	school	5501920	840	Public school	Butternut	550192000245	20	Butternut Elementary		Regular School	No	Elementary	PK	05	2017	grade_3	16	16
332234	WI	Ashland	school	5508970	3427	Public school	Mellen	550897002941	800	Mellen Public School		Regular School	No	Other	PK	12	2017	grade_3	18	18
2318659	WI	Ashland	school	5500510	170	Public school	Ashland	550051000077	80	Lake Superior Elementary		Regular School	No	Elementary	PK	05	2020	grade_3	94	94
2318671	WI	Ashland	school	5500510	170	Public school	Ashland	550051002928	130	Lake Superior Learning Community	charter	Regular School	Yes	Elementary	03	06	2020	grade_3	15	15
2318678	WI	Ashland	school	5500510	170	Public school	Ashland	550051000079	120	Marengo Valley Elementary		Regular School	No	Elementary	PK	05	2020	grade_3	23	23
2319577	WI	Ashland	school	5501920	840	Public school	Butternut	550192000245	20	Butternut Elementary		Regular School	No	Elementary	PK	05	2020	grade_3	9	9
2324870	WI	Ashland	school	5508970	3427	Public school	Mellen	550897002941	800	Mellen Public School		Regular School	No	Other	PK	12	2020	grade_3	19	19
2333454	WI	Ashland	school	5500510	170	Public school	Ashland	550051000077	80	Lake Superior Elementary		Regular School	No	Elementary	PK	05	2021	grade_3	103	103
2333463	WI	Ashland	school	5500510	170	Public school	Ashland	550051000079	120	Marengo Valley Elementary		Regular School	No	Elementary	PK	05	2021	grade_3	23	23
2334358	WI	Ashland	school	5501920	840	Public school	Butternut	550192000245	20	Butternut Elementary		Regular School	No	Elementary	PK	05	2021	grade_3	14	14
2339758	WI	Ashland	school	5508970	3427	Public school	Mellen	550897002941	800	Mellen Public School		Regular School	No	Other	KG	12	2021	grade_3	19	19
3074452	WI	Ashland	school	5500510	170	Public school	Ashland	550051000076	60	Lake Superior Intermediate		Regular School	No	Elementary	03	05	2019	grade_3	89	89
3074456	WI	Ashland	school	5500510	170	Public school	Ashland	550051002928	130	Lake Superior Learning Community	charter	Regular School	Yes	Elementary	03	06	2019	grade_3	21	21
3074469	WI	Ashland	school	5500510	170	Public school	Ashland	550051000079	120	Marengo Valley Elementary		Regular School	No	Elementary	PK	05	2019	grade_3	28	28
3075358	WI	Ashland	school	5501920	840	Public school	Butternut	550192000245	20	Butternut Elementary		Regular School	No	Elementary	PK	05	2019	grade_3	11	11
3080598	WI	Ashland	school	5508970	3427	Public school	Mellen	550897002941	800	Mellen Public School		Regular School	No	Other	PK	12	2019	grade_3	13	13
3089208	WI	Ashland	school	5500510	170	Public school	Ashland	550051000076	60	Lake Superior Intermediate		Regular School	No	Elementary	03	05	2018	grade_3	111	111
3089212	WI	Ashland	school	5500510	170	Public school	Ashland	550051002928	130	Lake Superior Learning Community	charter	Regular School	Yes	Elementary	03	05	2018	grade_3	15	15
3089224	WI	Ashland	school	5500510	170	Public school	Ashland	550051000079	120	Marengo Valley Elementary		Regular School	No	Elementary	PK	05	2018	grade_3	34	34
3090113	WI	Ashland	school	5501920	840	Public school	Butternut	550192000245	20	Butternut Elementary		Regular School	No	Elementary	PK	05	2018	grade_3	8	8
3095314	WI	Ashland	school	5508970	3427	Public school	Mellen	550897002941	800	Mellen Public School		Regular School	No	Other	PK	12	2018	grade_3	29	29
112509	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_3	5	5
112520	WI	Barron	school	5500870	308	Public school	Barron Area	550087000113	20	Almena Elementary		Regular School	No	1.0	PK	04	2015	grade_3	16	16
112527	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_3	4	4
112542	WI	Barron	school	5500870	308	Public school	Barron Area	550087000117	120	Ridgeland-Dallas Elementary		Regular School	No	1.0	PK	04	2015	grade_3	18	18
112554	WI	Barron	school	5500870	308	Public school	Barron Area	550087000119	160	Woodland Elementary		Regular School	No	1.0	PK	04	2015	grade_3	54	54
113255	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_3	8	8
113266	WI	Barron	school	5502130	903	Public school	Cameron	550213000256	20	Cameron Elementary		Regular School	No	1.0	PK	04	2015	grade_3	61	61
113459	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_3	63	63
113471	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_3	8	8
113854	WI	Barron	school	5503090	1260	Public school	Cumberland	550309000343	40	Cumberland Elementary		Regular School	No	1.0	PK	04	2015	grade_3	67	67
113880	WI	Barron	school	5503090	1260	Public school	Cumberland	550309002871	800	Island City Virtual Academy	charter	Regular School	Yes	4.0	PK	12	2015	grade_3	1	1
122199	WI	Barron	school	5512180	4557	Public school	Prairie Farm Public	551218001585	20	Prairie Farm Elementary		Regular School	No	1.0	PK	05	2015	grade_3	30	30
122750	WI	Barron	school	5512810	4802	Public school	Rice Lake Area	551281001693	60	Haugen Elementary		Regular School	No	1.0	PK	04	2015	grade_3	18	18
122761	WI	Barron	school	5512810	4802	Public school	Rice Lake Area	551281001694	80	Hilltop Elementary		Regular School	No	1.0	PK	04	2015	grade_3	72	72
122768	WI	Barron	school	5512810	4802	Public school	Rice Lake Area	551281001695	100	Jefferson Elementary		Regular School	No	1.0	PK	04	2015	grade_3	34	34
122793	WI	Barron	school	5512810	4802	Public school	Rice Lake Area	551281000581	25	Tainter Elementary		Regular School	No	1.0	PK	04	2015	grade_3	49	49
124571	WI	Barron	school	5515060	5810	Public school	Turtle Lake	551506001955	20	Turtle Lake Elementary		Regular School	No	1.0	PK	08	2015	grade_3	33	33
282489	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_3	4	4
282500	WI	Barron	school	5500870	308	Public school	Barron Area	550087000113	20	Almena Elementary		Regular School	No	1.0	PK	04	2016	grade_3	16	16
282507	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_3	5	5
282523	WI	Barron	school	5500870	308	Public school	Barron Area	550087000117	120	Ridgeland-Dallas Elementary		Regular School	No	1.0	PK	04	2016	grade_3	10	10
282535	WI	Barron	school	5500870	308	Public school	Barron Area	550087000119	160	Woodland Elementary		Regular School	No	1.0	PK	04	2016	grade_3	72	72
283237	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_3	6	6
283248	WI	Barron	school	5502130	903	Public school	Cameron	550213000256	20	Cameron Elementary		Regular School	No	1.0	PK	04	2016	grade_3	91	91
283438	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_3	71	71
283449	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_3	6	6
283831	WI	Barron	school	5503090	1260	Public school	Cumberland	550309000343	40	Cumberland Elementary		Regular School	No	1.0	PK	04	2016	grade_3	65	65
283854	WI	Barron	school	5503090	1260	Public school	Cumberland	550309002871	800	Island City Virtual Academy	charter	Regular School	Yes	4.0	PK	12	2016	grade_3	2	2
292159	WI	Barron	school	5512180	4557	Public school	Prairie Farm Public	551218001585	20	Prairie Farm Elementary		Regular School	No	1.0	PK	05	2016	grade_3	39	39
292723	WI	Barron	school	5512810	4802	Public school	Rice Lake Area	551281001693	60	Haugen Elementary		Regular School	No	1.0	PK	04	2016	grade_3	15	15
292734	WI	Barron	school	5512810	4802	Public school	Rice Lake Area	551281001694	80	Hilltop Elementary		Regular School	No	1.0	KG	04	2016	grade_3	53	53
292755	WI	Barron	school	5512810	4802	Public school	Rice Lake Area	551281000581	25	Tainter Elementary		Regular School	No	1.0	PK	04	2016	grade_3	96	96
294505	WI	Barron	school	5515060	5810	Public school	Turtle Lake	551506001955	20	Turtle Lake Elementary		Regular School	No	1.0	PK	08	2016	grade_3	25	25
326388	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_3	1	1
326399	WI	Barron	school	5500870	308	Public school	Barron Area	550087000113	20	Almena Elementary		Regular School	No	Elementary	PK	04	2017	grade_3	11	11
326407	WI	Barron	school	5500870	308	Public school	Barron Area	550087002717	100	Barron Area Montessori School	charter	Regular School	Yes	Elementary	PK	03	2017	grade_3	3	3
326421	WI	Barron	school	5500870	308	Public school	Barron Area	550087000117	120	Ridgeland-Dallas Elementary		Regular School	No	Elementary	PK	04	2017	grade_3	13	13
326433	WI	Barron	school	5500870	308	Public school	Barron Area	550087000119	160	Woodland Elementary		Regular School	No	Elementary	PK	04	2017	grade_3	53	53
327133	WI	Barron	school	5502130	903	Public school	Cameron	550213002851	800	Cameron Academy of Virtual Education	charter	Alternative School	Yes	Other	KG	12	2017	grade_3	7	7
327144	WI	Barron	school	5502130	903	Public school	Cameron	550213000256	20	Cameron Elementary		Regular School	No	Elementary	PK	04	2017	grade_3	82	82
327343	WI	Barron	school	5500061	1080	Public school	Chetek-Weyerhaeuser Area	550006102805	100	Chetek-Weyerhaeuser Roselawn Elementary		Regular School	No	Elementary	PK	05	2017	grade_3	70	70
327355	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_3	6	6
327734	WI	Barron	school	5503090	1260	Public school	Cumberland	550309000343	40	Cumberland Elementary		Regular School	No	Elementary	PK	04	2017	grade_3	66	66
336037	WI	Barron	school	5512180	4557	Public school	Prairie Farm Public	551218001585	20	Prairie Farm Elementary		Regular School	No	Elementary	PK	05	2017	grade_3	26	26
336610	WI	Barron	school	5512810	4802	Public school	Rice Lake Area	551281001693	60	Haugen Elementary		Regular School	No	Elementary	PK	04	2017	grade_3	11	11
336621	WI	Barron	school	5512810	4802	Public school	Rice Lake Area	551281001694	80	Hilltop Elementary		Regular School	No	Elementary	KG	04	2017	grade_3	51	51
336642	WI	Barron	school	5512810	4802	Public school	Rice Lake Area	551281000581	25	Tainter Elementary		Regular School	No	Elementary	PK	04	2017	grade_3	79	79
338398	WI	Barron	school	5515060	5810	Public school	Turtle Lake	551506003032	810	Laker Online	charter	Regular School	Yes	Other	PK	12	2017	grade_3	1	1
338408	WI	Barron	school	5515060	5810	Public school	Turtle Lake	551506001955	20	Turtle Lake Elementary		Regular School	No	Elementary	PK	08	2017	grade_3	36	36
2318900	WI	Barron	school	5500870	308	Public school	Barron Area	550087000113	20	Almena Elementary		Regular School	No	Elementary	02	04	2020	grade_3	12	12