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
111758	WI	Adams	school	5500060	14	Public school	Adams-Friendship Area	550006001433	130	Adams-Friendship Elementary		Regular School	No	1.0	PK	05	2015	grade_1	72	72
111776	WI	Adams	school	5500060	14	Public school	Adams-Friendship Area	550006000010	140	Grand Marsh Elementary		Regular School	No	1.0	PK	05	2015	grade_1	24	24
111784	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_1	26	26
281732	WI	Adams	school	5500060	14	Public school	Adams-Friendship Area	550006001433	130	Adams-Friendship Elementary		Regular School	No	1.0	PK	05	2016	grade_1	50	50
281750	WI	Adams	school	5500060	14	Public school	Adams-Friendship Area	550006000010	140	Grand Marsh Elementary		Regular School	No	1.0	PK	05	2016	grade_1	22	22
281758	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_1	20	20
325628	WI	Adams	school	5500060	14	Public school	Adams-Friendship Area	550006001433	130	Adams-Friendship Elementary		Regular School	No	Elementary	PK	05	2017	grade_1	63	63
325647	WI	Adams	school	5500060	14	Public school	Adams-Friendship Area	550006000010	140	Grand Marsh Elementary		Regular School	No	Elementary	PK	05	2017	grade_1	30	30
325656	WI	Adams	school	5500060	14	Public school	Adams-Friendship Area	550006000012	200	Roche-A-Cri Elementary		Regular School	No	Elementary	PK	05	2017	grade_1	25	25
2318152	WI	Adams	school	5500060	14	Public school	Adams-Friendship Area	550006001433	130	Adams-Friendship Elementary		Regular School	No	Elementary	PK	04	2020	grade_1	75	75
2318171	WI	Adams	school	5500060	14	Public school	Adams-Friendship Area	550006000010	140	Grand Marsh Elementary		Regular School	No	Elementary	PK	04	2020	grade_1	17	17
2332956	WI	Adams	school	5500060	14	Public school	Adams-Friendship Area	550006001433	130	Adams-Friendship Elementary		Regular School	No	Elementary	PK	04	2021	grade_1	79	79
3073922	WI	Adams	school	5500060	14	Public school	Adams-Friendship Area	550006001433	130	Adams-Friendship Elementary		Regular School	No	Elementary	PK	04	2019	grade_1	69	69
3073940	WI	Adams	school	5500060	14	Public school	Adams-Friendship Area	550006000010	140	Grand Marsh Elementary		Regular School	No	Elementary	PK	04	2019	grade_1	25	25
3088670	WI	Adams	school	5500060	14	Public school	Adams-Friendship Area	550006001433	130	Adams-Friendship Elementary		Regular School	No	Elementary	PK	05	2018	grade_1	46	46
3088688	WI	Adams	school	5500060	14	Public school	Adams-Friendship Area	550006000010	140	Grand Marsh Elementary		Regular School	No	Elementary	PK	05	2018	grade_1	18	18
3088696	WI	Adams	school	5500060	14	Public school	Adams-Friendship Area	550006000012	200	Roche-A-Cri Elementary		Regular School	No	Elementary	PK	05	2018	grade_1	14	14
112303	WI	Ashland	school	5500510	170	Public school	Ashland	550051000077	80	Lake Superior Primary		Regular School	No	1.0	PK	02	2015	grade_1	140	140
112308	WI	Ashland	school	5500510	170	Public school	Ashland	550051000079	120	Marengo Valley Elementary		Regular School	No	1.0	PK	05	2015	grade_1	33	33
113178	WI	Ashland	school	5501920	840	Public school	Butternut	550192000245	20	Butternut Elementary		Regular School	No	1.0	PK	05	2015	grade_1	13	13
118359	WI	Ashland	school	5508970	3427	Public school	Mellen	550897002941	800	Mellen Public School		Regular School	No	4.0	PK	12	2015	grade_1	21	21
282282	WI	Ashland	school	5500510	170	Public school	Ashland	550051000077	80	Lake Superior Primary		Regular School	No	1.0	PK	02	2016	grade_1	127	127
282287	WI	Ashland	school	5500510	170	Public school	Ashland	550051000079	120	Marengo Valley Elementary		Regular School	No	1.0	PK	05	2016	grade_1	35	35
283160	WI	Ashland	school	5501920	840	Public school	Butternut	550192000245	20	Butternut Elementary		Regular School	No	1.0	PK	05	2016	grade_1	10	10
288355	WI	Ashland	school	5508970	3427	Public school	Mellen	550897002941	800	Mellen Public School		Regular School	No	4.0	PK	12	2016	grade_1	29	29
326181	WI	Ashland	school	5500510	170	Public school	Ashland	550051000077	80	Lake Superior Primary		Regular School	No	Elementary	PK	02	2017	grade_1	106	106
326186	WI	Ashland	school	5500510	170	Public school	Ashland	550051000079	120	Marengo Valley Elementary		Regular School	No	Elementary	PK	05	2017	grade_1	26	26
327058	WI	Ashland	school	5501920	840	Public school	Butternut	550192000245	20	Butternut Elementary		Regular School	No	Elementary	PK	05	2017	grade_1	13	13
332229	WI	Ashland	school	5508970	3427	Public school	Mellen	550897002941	800	Mellen Public School		Regular School	No	Other	PK	12	2017	grade_1	14	14
2318657	WI	Ashland	school	5500510	170	Public school	Ashland	550051000077	80	Lake Superior Elementary		Regular School	No	Elementary	PK	05	2020	grade_1	108	108
2318676	WI	Ashland	school	5500510	170	Public school	Ashland	550051000079	120	Marengo Valley Elementary		Regular School	No	Elementary	PK	05	2020	grade_1	31	31
2318686	WI	Ashland	school		170	Public Schools-Multidistrict Charters	Ashland		9100	Rural Virtual Academy							2020	grade_1	1	1
2319575	WI	Ashland	school	5501920	840	Public school	Butternut	550192000245	20	Butternut Elementary		Regular School	No	Elementary	PK	05	2020	grade_1	9	9
2324865	WI	Ashland	school	5508970	3427	Public school	Mellen	550897002941	800	Mellen Public School		Regular School	No	Other	PK	12	2020	grade_1	23	23
2333452	WI	Ashland	school	5500510	170	Public school	Ashland	550051000077	80	Lake Superior Elementary		Regular School	No	Elementary	PK	05	2021	grade_1	87	87
2333461	WI	Ashland	school	5500510	170	Public school	Ashland	550051000079	120	Marengo Valley Elementary		Regular School	No	Elementary	PK	05	2021	grade_1	29	29
2334356	WI	Ashland	school	5501920	840	Public school	Butternut	550192000245	20	Butternut Elementary		Regular School	No	Elementary	PK	05	2021	grade_1	12	12
2339753	WI	Ashland	school	5508970	3427	Public school	Mellen	550897002941	800	Mellen Public School		Regular School	No	Other	KG	12	2021	grade_1	18	18
3074461	WI	Ashland	school	5500510	170	Public school	Ashland	550051000077	80	Lake Superior Primary		Regular School	No	Elementary	PK	02	2019	grade_1	116	116
3074467	WI	Ashland	school	5500510	170	Public school	Ashland	550051000079	120	Marengo Valley Elementary		Regular School	No	Elementary	PK	05	2019	grade_1	27	27
3075356	WI	Ashland	school	5501920	840	Public school	Butternut	550192000245	20	Butternut Elementary		Regular School	No	Elementary	PK	05	2019	grade_1	15	15
3080593	WI	Ashland	school	5508970	3427	Public school	Mellen	550897002941	800	Mellen Public School		Regular School	No	Other	PK	12	2019	grade_1	22	22
3089216	WI	Ashland	school	5500510	170	Public school	Ashland	550051000077	80	Lake Superior Primary		Regular School	No	Elementary	PK	02	2018	grade_1	103	103
3089222	WI	Ashland	school	5500510	170	Public school	Ashland	550051000079	120	Marengo Valley Elementary		Regular School	No	Elementary	PK	05	2018	grade_1	25	25
3090111	WI	Ashland	school	5501920	840	Public school	Butternut	550192000245	20	Butternut Elementary		Regular School	No	Elementary	PK	05	2018	grade_1	10	10
3095309	WI	Ashland	school	5508970	3427	Public school	Mellen	550897002941	800	Mellen Public School		Regular School	No	Other	PK	12	2018	grade_1	20	20
112504	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_1	1	1
112518	WI	Barron	school	5500870	308	Public school	Barron Area	550087000113	20	Almena Elementary		Regular School	No	1.0	PK	04	2015	grade_1	11	11
112525	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_1	10	10
112540	WI	Barron	school	5500870	308	Public school	Barron Area	550087000117	120	Ridgeland-Dallas Elementary		Regular School	No	1.0	PK	04	2015	grade_1	10	10
112552	WI	Barron	school	5500870	308	Public school	Barron Area	550087000119	160	Woodland Elementary		Regular School	No	1.0	PK	04	2015	grade_1	53	53
113250	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_1	10	10
113264	WI	Barron	school	5502130	903	Public school	Cameron	550213000256	20	Cameron Elementary		Regular School	No	1.0	PK	04	2015	grade_1	82	82
113457	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_1	69	69
113466	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_1	9	9
113852	WI	Barron	school	5503090	1260	Public school	Cumberland	550309000343	40	Cumberland Elementary		Regular School	No	1.0	PK	04	2015	grade_1	62	62
122197	WI	Barron	school	5512180	4557	Public school	Prairie Farm Public	551218001585	20	Prairie Farm Elementary		Regular School	No	1.0	PK	05	2015	grade_1	23	23
122748	WI	Barron	school	5512810	4802	Public school	Rice Lake Area	551281001693	60	Haugen Elementary		Regular School	No	1.0	PK	04	2015	grade_1	15	15
122759	WI	Barron	school	5512810	4802	Public school	Rice Lake Area	551281001694	80	Hilltop Elementary		Regular School	No	1.0	PK	04	2015	grade_1	53	53
122766	WI	Barron	school	5512810	4802	Public school	Rice Lake Area	551281001695	100	Jefferson Elementary		Regular School	No	1.0	PK	04	2015	grade_1	32	32
122791	WI	Barron	school	5512810	4802	Public school	Rice Lake Area	551281000581	25	Tainter Elementary		Regular School	No	1.0	PK	04	2015	grade_1	40	40
124569	WI	Barron	school	5515060	5810	Public school	Turtle Lake	551506001955	20	Turtle Lake Elementary		Regular School	No	1.0	PK	08	2015	grade_1	36	36
282484	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_1	1	1
282498	WI	Barron	school	5500870	308	Public school	Barron Area	550087000113	20	Almena Elementary		Regular School	No	1.0	PK	04	2016	grade_1	12	12
282505	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_1	11	11
282521	WI	Barron	school	5500870	308	Public school	Barron Area	550087000117	120	Ridgeland-Dallas Elementary		Regular School	No	1.0	PK	04	2016	grade_1	10	10
282533	WI	Barron	school	5500870	308	Public school	Barron Area	550087000119	160	Woodland Elementary		Regular School	No	1.0	PK	04	2016	grade_1	53	53
283232	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_1	6	6
283246	WI	Barron	school	5502130	903	Public school	Cameron	550213000256	20	Cameron Elementary		Regular School	No	1.0	PK	04	2016	grade_1	81	81
283436	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_1	61	61
283445	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_1	4	4
283829	WI	Barron	school	5503090	1260	Public school	Cumberland	550309000343	40	Cumberland Elementary		Regular School	No	1.0	PK	04	2016	grade_1	71	71
292157	WI	Barron	school	5512180	4557	Public school	Prairie Farm Public	551218001585	20	Prairie Farm Elementary		Regular School	No	1.0	PK	05	2016	grade_1	35	35
292721	WI	Barron	school	5512810	4802	Public school	Rice Lake Area	551281001693	60	Haugen Elementary		Regular School	No	1.0	PK	04	2016	grade_1	15	15
292732	WI	Barron	school	5512810	4802	Public school	Rice Lake Area	551281001694	80	Hilltop Elementary		Regular School	No	1.0	KG	04	2016	grade_1	49	49
292753	WI	Barron	school	5512810	4802	Public school	Rice Lake Area	551281000581	25	Tainter Elementary		Regular School	No	1.0	PK	04	2016	grade_1	71	71
294503	WI	Barron	school	5515060	5810	Public school	Turtle Lake	551506001955	20	Turtle Lake Elementary		Regular School	No	1.0	PK	08	2016	grade_1	37	37
326383	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_1	1	1
326397	WI	Barron	school	5500870	308	Public school	Barron Area	550087000113	20	Almena Elementary		Regular School	No	Elementary	PK	04	2017	grade_1	14	14
326405	WI	Barron	school	5500870	308	Public school	Barron Area	550087002717	100	Barron Area Montessori School	charter	Regular School	Yes	Elementary	PK	03	2017	grade_1	11	11
326419	WI	Barron	school	5500870	308	Public school	Barron Area	550087000117	120	Ridgeland-Dallas Elementary		Regular School	No	Elementary	PK	04	2017	grade_1	8	8
326431	WI	Barron	school	5500870	308	Public school	Barron Area	550087000119	160	Woodland Elementary		Regular School	No	Elementary	PK	04	2017	grade_1	49	49
327128	WI	Barron	school	5502130	903	Public school	Cameron	550213002851	800	Cameron Academy of Virtual Education	charter	Alternative School	Yes	Other	KG	12	2017	grade_1	6	6
327142	WI	Barron	school	5502130	903	Public school	Cameron	550213000256	20	Cameron Elementary		Regular School	No	Elementary	PK	04	2017	grade_1	70	70
327341	WI	Barron	school	5500061	1080	Public school	Chetek-Weyerhaeuser Area	550006102805	100	Chetek-Weyerhaeuser Roselawn Elementary		Regular School	No	Elementary	PK	05	2017	grade_1	61	61
327350	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_1	4	4
327732	WI	Barron	school	5503090	1260	Public school	Cumberland	550309000343	40	Cumberland Elementary		Regular School	No	Elementary	PK	04	2017	grade_1	55	55
327757	WI	Barron	school	5503090	1260	Public school	Cumberland	550309002871	800	Island City Virtual Academy	charter	Regular School	Yes	Other	PK	12	2017	grade_1	2	2
336035	WI	Barron	school	5512180	4557	Public school	Prairie Farm Public	551218001585	20	Prairie Farm Elementary		Regular School	No	Elementary	PK	05	2017	grade_1	25	25
336608	WI	Barron	school	5512810	4802	Public school	Rice Lake Area	551281001693	60	Haugen Elementary		Regular School	No	Elementary	PK	04	2017	grade_1	14	14
336619	WI	Barron	school	5512810	4802	Public school	Rice Lake Area	551281001694	80	Hilltop Elementary		Regular School	No	Elementary	KG	04	2017	grade_1	53	53
336640	WI	Barron	school	5512810	4802	Public school	Rice Lake Area	551281000581	25	Tainter Elementary		Regular School	No	Elementary	PK	04	2017	grade_1	71	71
338396	WI	Barron	school	5515060	5810	Public school	Turtle Lake	551506003032	810	Laker Online	charter	Regular School	Yes	Other	PK	12	2017	grade_1	1	1
338406	WI	Barron	school	5515060	5810	Public school	Turtle Lake	551506001955	20	Turtle Lake Elementary		Regular School	No	Elementary	PK	08	2017	grade_1	31	31
2318903	WI	Barron	school	5500870	308	Public school	Barron Area	550087002717	100	Barron Area Montessori School	charter	Regular School	Yes	Elementary	PK	03	2020	grade_1	2	2
2318918	WI	Barron	school	5500870	308	Public school	Barron Area	550087000117	120	Ridgeland-Dallas Elementary		Regular School	No	Elementary	PK	04	2020	grade_1	9	9
2318930	WI	Barron	school	5500870	308	Public school	Barron Area	550087000119	160	Woodland Elementary		Regular School	No	Elementary	PK	04	2020	grade_1	51	51
2319655	WI	Barron	school	5502130	903	Public school	Cameron	550213002851	800	Cameron Academy of Virtual Education	charter	Alternative School	Yes	Other	PK	12	2020	grade_1	2	2
2319670	WI	Barron	school	5502130	903	Public school	Cameron	550213000256	20	Cameron Elementary		Regular School	No	Elementary	PK	04	2020	grade_1	56	56
2319872	WI	Barron	school	5500061	1080	Public school	Chetek-Weyerhaeuser Area	550006102805	100	Chetek-Weyerhaeuser Roselawn Elementary		Regular School	No	Elementary	PK	05	2020	grade_1	76	76
2319881	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_1	2	2