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
111761	WI	Adams	school	5500060	14	Public school	Adams-Friendship Area	550006001433	130	Adams-Friendship Elementary		Regular School	No	1.0	PK	05	2015	grade_4	78	78
111779	WI	Adams	school	5500060	14	Public school	Adams-Friendship Area	550006000010	140	Grand Marsh Elementary		Regular School	No	1.0	PK	05	2015	grade_4	14	14
111787	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_4	18	18
281735	WI	Adams	school	5500060	14	Public school	Adams-Friendship Area	550006001433	130	Adams-Friendship Elementary		Regular School	No	1.0	PK	05	2016	grade_4	67	67
281753	WI	Adams	school	5500060	14	Public school	Adams-Friendship Area	550006000010	140	Grand Marsh Elementary		Regular School	No	1.0	PK	05	2016	grade_4	21	21
281761	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_4	16	16
325631	WI	Adams	school	5500060	14	Public school	Adams-Friendship Area	550006001433	130	Adams-Friendship Elementary		Regular School	No	Elementary	PK	05	2017	grade_4	81	81
325642	WI	Adams	school	5500060	14	Public school	Adams-Friendship Area	550006001454	210	Adams-Friendship Middle		Regular School	No	Middle	06	08	2017	grade_4	1	1
325650	WI	Adams	school	5500060	14	Public school	Adams-Friendship Area	550006000010	140	Grand Marsh Elementary		Regular School	No	Elementary	PK	05	2017	grade_4	18	18
325659	WI	Adams	school	5500060	14	Public school	Adams-Friendship Area	550006000012	200	Roche-A-Cri Elementary		Regular School	No	Elementary	PK	05	2017	grade_4	17	17
2318155	WI	Adams	school	5500060	14	Public school	Adams-Friendship Area	550006001433	130	Adams-Friendship Elementary		Regular School	No	Elementary	PK	04	2020	grade_4	91	91
2318174	WI	Adams	school	5500060	14	Public school	Adams-Friendship Area	550006000010	140	Grand Marsh Elementary		Regular School	No	Elementary	PK	04	2020	grade_4	13	13
2332959	WI	Adams	school	5500060	14	Public school	Adams-Friendship Area	550006001433	130	Adams-Friendship Elementary		Regular School	No	Elementary	PK	04	2021	grade_4	80	80
3073925	WI	Adams	school	5500060	14	Public school	Adams-Friendship Area	550006001433	130	Adams-Friendship Elementary		Regular School	No	Elementary	PK	04	2019	grade_4	76	76
3073943	WI	Adams	school	5500060	14	Public school	Adams-Friendship Area	550006000010	140	Grand Marsh Elementary		Regular School	No	Elementary	PK	04	2019	grade_4	22	22
3088673	WI	Adams	school	5500060	14	Public school	Adams-Friendship Area	550006001433	130	Adams-Friendship Elementary		Regular School	No	Elementary	PK	05	2018	grade_4	74	74
3088691	WI	Adams	school	5500060	14	Public school	Adams-Friendship Area	550006000010	140	Grand Marsh Elementary		Regular School	No	Elementary	PK	05	2018	grade_4	24	24
3088699	WI	Adams	school	5500060	14	Public school	Adams-Friendship Area	550006000012	200	Roche-A-Cri Elementary		Regular School	No	Elementary	PK	05	2018	grade_4	31	31
112287	WI	Ashland	school	5500510	170	Public school	Ashland	550051002928	130	Ashland Elementary Charter School	charter	Regular School	Yes	1.0	03	05	2015	grade_4	36	36
112300	WI	Ashland	school	5500510	170	Public school	Ashland	550051000076	60	Lake Superior Intermediate		Regular School	No	1.0	03	05	2015	grade_4	89	89
112311	WI	Ashland	school	5500510	170	Public school	Ashland	550051000079	120	Marengo Valley Elementary		Regular School	No	1.0	PK	05	2015	grade_4	31	31
113181	WI	Ashland	school	5501920	840	Public school	Butternut	550192000245	20	Butternut Elementary		Regular School	No	1.0	PK	05	2015	grade_4	17	17
118365	WI	Ashland	school	5508970	3427	Public school	Mellen	550897002941	800	Mellen Public School		Regular School	No	4.0	PK	12	2015	grade_4	28	28
282266	WI	Ashland	school	5500510	170	Public school	Ashland	550051002928	130	Ashland Elementary Charter School	charter	Regular School	Yes	1.0	03	05	2016	grade_4	24	24
282279	WI	Ashland	school	5500510	170	Public school	Ashland	550051000076	60	Lake Superior Intermediate		Regular School	No	1.0	03	05	2016	grade_4	103	103
282290	WI	Ashland	school	5500510	170	Public school	Ashland	550051000079	120	Marengo Valley Elementary		Regular School	No	1.0	PK	05	2016	grade_4	25	25
283163	WI	Ashland	school	5501920	840	Public school	Butternut	550192000245	20	Butternut Elementary		Regular School	No	1.0	PK	05	2016	grade_4	13	13
288361	WI	Ashland	school	5508970	3427	Public school	Mellen	550897002941	800	Mellen Public School		Regular School	No	4.0	PK	12	2016	grade_4	17	17
326165	WI	Ashland	school	5500510	170	Public school	Ashland	550051002928	130	Ashland Elementary Charter School	charter	Regular School	Yes	Elementary	03	05	2017	grade_4	26	26
326178	WI	Ashland	school	5500510	170	Public school	Ashland	550051000076	60	Lake Superior Intermediate		Regular School	No	Elementary	03	05	2017	grade_4	105	105
326189	WI	Ashland	school	5500510	170	Public school	Ashland	550051000079	120	Marengo Valley Elementary		Regular School	No	Elementary	PK	05	2017	grade_4	34	34
327061	WI	Ashland	school	5501920	840	Public school	Butternut	550192000245	20	Butternut Elementary		Regular School	No	Elementary	PK	05	2017	grade_4	12	12
332235	WI	Ashland	school	5508970	3427	Public school	Mellen	550897002941	800	Mellen Public School		Regular School	No	Other	PK	12	2017	grade_4	19	19
2318660	WI	Ashland	school	5500510	170	Public school	Ashland	550051000077	80	Lake Superior Elementary		Regular School	No	Elementary	PK	05	2020	grade_4	97	97
2318672	WI	Ashland	school	5500510	170	Public school	Ashland	550051002928	130	Lake Superior Learning Community	charter	Regular School	Yes	Elementary	03	06	2020	grade_4	15	15
2318679	WI	Ashland	school	5500510	170	Public school	Ashland	550051000079	120	Marengo Valley Elementary		Regular School	No	Elementary	PK	05	2020	grade_4	25	25
2319578	WI	Ashland	school	5501920	840	Public school	Butternut	550192000245	20	Butternut Elementary		Regular School	No	Elementary	PK	05	2020	grade_4	11	11
2324871	WI	Ashland	school	5508970	3427	Public school	Mellen	550897002941	800	Mellen Public School		Regular School	No	Other	PK	12	2020	grade_4	14	14
2333455	WI	Ashland	school	5500510	170	Public school	Ashland	550051000077	80	Lake Superior Elementary		Regular School	No	Elementary	PK	05	2021	grade_4	99	99
2333464	WI	Ashland	school	5500510	170	Public school	Ashland	550051000079	120	Marengo Valley Elementary		Regular School	No	Elementary	PK	05	2021	grade_4	23	23
2334359	WI	Ashland	school	5501920	840	Public school	Butternut	550192000245	20	Butternut Elementary		Regular School	No	Elementary	PK	05	2021	grade_4	10	10
2339759	WI	Ashland	school	5508970	3427	Public school	Mellen	550897002941	800	Mellen Public School		Regular School	No	Other	KG	12	2021	grade_4	16	16
3074453	WI	Ashland	school	5500510	170	Public school	Ashland	550051000076	60	Lake Superior Intermediate		Regular School	No	Elementary	03	05	2019	grade_4	118	118
3074457	WI	Ashland	school	5500510	170	Public school	Ashland	550051002928	130	Lake Superior Learning Community	charter	Regular School	Yes	Elementary	03	06	2019	grade_4	14	14
3074470	WI	Ashland	school	5500510	170	Public school	Ashland	550051000079	120	Marengo Valley Elementary		Regular School	No	Elementary	PK	05	2019	grade_4	37	37
3075359	WI	Ashland	school	5501920	840	Public school	Butternut	550192000245	20	Butternut Elementary		Regular School	No	Elementary	PK	05	2019	grade_4	11	11
3080599	WI	Ashland	school	5508970	3427	Public school	Mellen	550897002941	800	Mellen Public School		Regular School	No	Other	PK	12	2019	grade_4	27	27
3089209	WI	Ashland	school	5500510	170	Public school	Ashland	550051000076	60	Lake Superior Intermediate		Regular School	No	Elementary	03	05	2018	grade_4	113	113
3089213	WI	Ashland	school	5500510	170	Public school	Ashland	550051002928	130	Lake Superior Learning Community	charter	Regular School	Yes	Elementary	03	05	2018	grade_4	24	24
3089225	WI	Ashland	school	5500510	170	Public school	Ashland	550051000079	120	Marengo Valley Elementary		Regular School	No	Elementary	PK	05	2018	grade_4	34	34
3090114	WI	Ashland	school	5501920	840	Public school	Butternut	550192000245	20	Butternut Elementary		Regular School	No	Elementary	PK	05	2018	grade_4	17	17
3095315	WI	Ashland	school	5508970	3427	Public school	Mellen	550897002941	800	Mellen Public School		Regular School	No	Other	PK	12	2018	grade_4	19	19
112510	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_4	3	3
112521	WI	Barron	school	5500870	308	Public school	Barron Area	550087000113	20	Almena Elementary		Regular School	No	1.0	PK	04	2015	grade_4	14	14
112528	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_4	4	4
112543	WI	Barron	school	5500870	308	Public school	Barron Area	550087000117	120	Ridgeland-Dallas Elementary		Regular School	No	1.0	PK	04	2015	grade_4	10	10
112555	WI	Barron	school	5500870	308	Public school	Barron Area	550087000119	160	Woodland Elementary		Regular School	No	1.0	PK	04	2015	grade_4	58	58
113256	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_4	5	5
113267	WI	Barron	school	5502130	903	Public school	Cameron	550213000256	20	Cameron Elementary		Regular School	No	1.0	PK	04	2015	grade_4	76	76
113460	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_4	61	61
113472	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_4	8	8
113855	WI	Barron	school	5503090	1260	Public school	Cumberland	550309000343	40	Cumberland Elementary		Regular School	No	1.0	PK	04	2015	grade_4	60	60
122200	WI	Barron	school	5512180	4557	Public school	Prairie Farm Public	551218001585	20	Prairie Farm Elementary		Regular School	No	1.0	PK	05	2015	grade_4	26	26
122751	WI	Barron	school	5512810	4802	Public school	Rice Lake Area	551281001693	60	Haugen Elementary		Regular School	No	1.0	PK	04	2015	grade_4	18	18
122762	WI	Barron	school	5512810	4802	Public school	Rice Lake Area	551281001694	80	Hilltop Elementary		Regular School	No	1.0	PK	04	2015	grade_4	51	51
122769	WI	Barron	school	5512810	4802	Public school	Rice Lake Area	551281001695	100	Jefferson Elementary		Regular School	No	1.0	PK	04	2015	grade_4	22	22
122794	WI	Barron	school	5512810	4802	Public school	Rice Lake Area	551281000581	25	Tainter Elementary		Regular School	No	1.0	PK	04	2015	grade_4	42	42
124572	WI	Barron	school	5515060	5810	Public school	Turtle Lake	551506001955	20	Turtle Lake Elementary		Regular School	No	1.0	PK	08	2015	grade_4	31	31
282490	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_4	2	2
282501	WI	Barron	school	5500870	308	Public school	Barron Area	550087000113	20	Almena Elementary		Regular School	No	1.0	PK	04	2016	grade_4	16	16
282508	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_4	3	3
282524	WI	Barron	school	5500870	308	Public school	Barron Area	550087000117	120	Ridgeland-Dallas Elementary		Regular School	No	1.0	PK	04	2016	grade_4	17	17
282536	WI	Barron	school	5500870	308	Public school	Barron Area	550087000119	160	Woodland Elementary		Regular School	No	1.0	PK	04	2016	grade_4	60	60
283238	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_4	4	4
283249	WI	Barron	school	5502130	903	Public school	Cameron	550213000256	20	Cameron Elementary		Regular School	No	1.0	PK	04	2016	grade_4	63	63
283439	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_4	68	68
283450	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_4	6	6
283832	WI	Barron	school	5503090	1260	Public school	Cumberland	550309000343	40	Cumberland Elementary		Regular School	No	1.0	PK	04	2016	grade_4	66	66
283855	WI	Barron	school	5503090	1260	Public school	Cumberland	550309002871	800	Island City Virtual Academy	charter	Regular School	Yes	4.0	PK	12	2016	grade_4	1	1
292160	WI	Barron	school	5512180	4557	Public school	Prairie Farm Public	551218001585	20	Prairie Farm Elementary		Regular School	No	1.0	PK	05	2016	grade_4	34	34
292724	WI	Barron	school	5512810	4802	Public school	Rice Lake Area	551281001693	60	Haugen Elementary		Regular School	No	1.0	PK	04	2016	grade_4	19	19
292735	WI	Barron	school	5512810	4802	Public school	Rice Lake Area	551281001694	80	Hilltop Elementary		Regular School	No	1.0	KG	04	2016	grade_4	72	72
292756	WI	Barron	school	5512810	4802	Public school	Rice Lake Area	551281000581	25	Tainter Elementary		Regular School	No	1.0	PK	04	2016	grade_4	90	90
294506	WI	Barron	school	5515060	5810	Public school	Turtle Lake	551506001955	20	Turtle Lake Elementary		Regular School	No	1.0	PK	08	2016	grade_4	27	27
326389	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_4	3	3
326400	WI	Barron	school	5500870	308	Public school	Barron Area	550087000113	20	Almena Elementary		Regular School	No	Elementary	PK	04	2017	grade_4	17	17
326422	WI	Barron	school	5500870	308	Public school	Barron Area	550087000117	120	Ridgeland-Dallas Elementary		Regular School	No	Elementary	PK	04	2017	grade_4	12	12
326434	WI	Barron	school	5500870	308	Public school	Barron Area	550087000119	160	Woodland Elementary		Regular School	No	Elementary	PK	04	2017	grade_4	67	67
327134	WI	Barron	school	5502130	903	Public school	Cameron	550213002851	800	Cameron Academy of Virtual Education	charter	Alternative School	Yes	Other	KG	12	2017	grade_4	6	6
327145	WI	Barron	school	5502130	903	Public school	Cameron	550213000256	20	Cameron Elementary		Regular School	No	Elementary	PK	04	2017	grade_4	91	91
327344	WI	Barron	school	5500061	1080	Public school	Chetek-Weyerhaeuser Area	550006102805	100	Chetek-Weyerhaeuser Roselawn Elementary		Regular School	No	Elementary	PK	05	2017	grade_4	73	73
327356	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_4	4	4
327735	WI	Barron	school	5503090	1260	Public school	Cumberland	550309000343	40	Cumberland Elementary		Regular School	No	Elementary	PK	04	2017	grade_4	67	67
327760	WI	Barron	school	5503090	1260	Public school	Cumberland	550309002871	800	Island City Virtual Academy	charter	Regular School	Yes	Other	PK	12	2017	grade_4	2	2
336038	WI	Barron	school	5512180	4557	Public school	Prairie Farm Public	551218001585	20	Prairie Farm Elementary		Regular School	No	Elementary	PK	05	2017	grade_4	42	42
336611	WI	Barron	school	5512810	4802	Public school	Rice Lake Area	551281001693	60	Haugen Elementary		Regular School	No	Elementary	PK	04	2017	grade_4	17	17
336622	WI	Barron	school	5512810	4802	Public school	Rice Lake Area	551281001694	80	Hilltop Elementary		Regular School	No	Elementary	KG	04	2017	grade_4	58	58
336643	WI	Barron	school	5512810	4802	Public school	Rice Lake Area	551281000581	25	Tainter Elementary		Regular School	No	Elementary	PK	04	2017	grade_4	87	87
338409	WI	Barron	school	5515060	5810	Public school	Turtle Lake	551506001955	20	Turtle Lake Elementary		Regular School	No	Elementary	PK	08	2017	grade_4	27	27
2318901	WI	Barron	school	5500870	308	Public school	Barron Area	550087000113	20	Almena Elementary		Regular School	No	Elementary	02	04	2020	grade_4	13	13
2318921	WI	Barron	school	5500870	308	Public school	Barron Area	550087000117	120	Ridgeland-Dallas Elementary		Regular School	No	Elementary	PK	04	2020	grade_4	13	13