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
111773	WI	Adams	school	5500060	14	Public school	Adams-Friendship Area	550006001454	210	Adams-Friendship Middle		Regular School	No	2.0	06	08	2015	grade_7	119	119
281747	WI	Adams	school	5500060	14	Public school	Adams-Friendship Area	550006001454	210	Adams-Friendship Middle		Regular School	No	2.0	06	08	2016	grade_7	110	110
325644	WI	Adams	school	5500060	14	Public school	Adams-Friendship Area	550006001454	210	Adams-Friendship Middle		Regular School	No	Middle	06	08	2017	grade_7	123	123
2318168	WI	Adams	school	5500060	14	Public school	Adams-Friendship Area	550006001454	210	Adams-Friendship Middle		Regular School	No	Middle	05	08	2020	grade_7	112	112
2332971	WI	Adams	school	5500060	14	Public school	Adams-Friendship Area	550006001454	210	Adams-Friendship Middle		Regular School	No	Middle	05	08	2021	grade_7	117	117
3073937	WI	Adams	school	5500060	14	Public school	Adams-Friendship Area	550006001454	210	Adams-Friendship Middle		Regular School	No	Middle	05	08	2019	grade_7	104	104
3088685	WI	Adams	school	5500060	14	Public school	Adams-Friendship Area	550006001454	210	Adams-Friendship Middle		Regular School	No	Middle	06	08	2018	grade_7	106	106
112296	WI	Ashland	school	5500510	170	Public school	Ashland	550051000074	30	Ashland Middle		Regular School	No	2.0	06	08	2015	grade_7	128	128
112316	WI	Ashland	school	5500510	170	Public school	Ashland	550051002986	250	Oredocker Project School	charter	Regular School	Yes	2.0	06	08	2015	grade_7	23	23
113190	WI	Ashland	school	5501920	840	Public school	Butternut	550192000246	40	Butternut High		Regular School	No	4.0	06	12	2015	grade_7	12	12
118368	WI	Ashland	school	5508970	3427	Public school	Mellen	550897002941	800	Mellen Public School		Regular School	No	4.0	PK	12	2015	grade_7	22	22
282275	WI	Ashland	school	5500510	170	Public school	Ashland	550051000074	30	Ashland Middle		Regular School	No	2.0	06	08	2016	grade_7	146	146
282296	WI	Ashland	school	5500510	170	Public school	Ashland	550051002986	250	Oredocker Project School	charter	Regular School	Yes	2.0	06	08	2016	grade_7	20	20
283173	WI	Ashland	school	5501920	840	Public school	Butternut	550192000246	40	Butternut High		Regular School	No	4.0	06	12	2016	grade_7	13	13
288364	WI	Ashland	school	5508970	3427	Public school	Mellen	550897002941	800	Mellen Public School		Regular School	No	4.0	PK	12	2016	grade_7	25	25
326174	WI	Ashland	school	5500510	170	Public school	Ashland	550051000074	30	Ashland Middle		Regular School	No	Middle	06	08	2017	grade_7	122	122
326194	WI	Ashland	school	5500510	170	Public school	Ashland	550051002986	250	Oredocker Project School	charter	Regular School	Yes	Middle	06	08	2017	grade_7	20	20
327071	WI	Ashland	school	5501920	840	Public school	Butternut	550192000246	40	Butternut High		Regular School	No	Other	06	12	2017	grade_7	15	15
332238	WI	Ashland	school	5508970	3427	Public school	Mellen	550897002941	800	Mellen Public School		Regular School	No	Other	PK	12	2017	grade_7	8	8
2318654	WI	Ashland	school	5500510	170	Public school	Ashland	550051000074	30	Ashland Middle		Regular School	No	Middle	06	08	2020	grade_7	154	154
2318683	WI	Ashland	school	5500510	170	Public school	Ashland	550051002986	250	Oredocker Project School	charter	Regular School	Yes	Middle	06	08	2020	grade_7	6	6
2318690	WI	Ashland	school		170	Public Schools-Multidistrict Charters	Ashland		9100	Rural Virtual Academy							2020	grade_7	2	2
2319588	WI	Ashland	school	5501920	840	Public school	Butternut	550192000246	40	Butternut High		Regular School	No	High	06	12	2020	grade_7	10	10
2324874	WI	Ashland	school	5508970	3427	Public school	Mellen	550897002941	800	Mellen Public School		Regular School	No	Other	PK	12	2020	grade_7	19	19
2333449	WI	Ashland	school	5500510	170	Public school	Ashland	550051000074	30	Ashland Middle		Regular School	No	Middle	06	08	2021	grade_7	161	161
2333474	WI	Ashland	school		170	Public Schools-Multidistrict Charters	Ashland		9100	Rural Virtual Academy							2021	grade_7	1	1
2334369	WI	Ashland	school	5501920	840	Public school	Butternut	550192000246	40	Butternut High		Regular School	No	High	06	12	2021	grade_7	18	18
2339762	WI	Ashland	school	5508970	3427	Public school	Mellen	550897002941	800	Mellen Public School		Regular School	No	Other	KG	12	2021	grade_7	19	19
3074444	WI	Ashland	school	5500510	170	Public school	Ashland	550051000074	30	Ashland Middle		Regular School	No	Middle	06	08	2019	grade_7	152	152
3074474	WI	Ashland	school	5500510	170	Public school	Ashland	550051002986	250	Oredocker Project School	charter	Regular School	Yes	Middle	06	08	2019	grade_7	7	7
3075369	WI	Ashland	school	5501920	840	Public school	Butternut	550192000246	40	Butternut High		Regular School	No	High	06	12	2019	grade_7	15	15
3080602	WI	Ashland	school	5508970	3427	Public school	Mellen	550897002941	800	Mellen Public School		Regular School	No	Other	PK	12	2019	grade_7	16	16
3089200	WI	Ashland	school	5500510	170	Public school	Ashland	550051000074	30	Ashland Middle		Regular School	No	Middle	06	08	2018	grade_7	128	128
3089230	WI	Ashland	school	5500510	170	Public school	Ashland	550051002986	250	Oredocker Project School	charter	Regular School	Yes	Middle	06	08	2018	grade_7	20	20
3090124	WI	Ashland	school	5501920	840	Public school	Butternut	550192000246	40	Butternut High		Regular School	No	High	06	12	2018	grade_7	13	13
3095318	WI	Ashland	school	5508970	3427	Public school	Mellen	550897002941	800	Mellen Public School		Regular School	No	Other	PK	12	2018	grade_7	29	29
112513	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_7	1	1
112549	WI	Barron	school	5500870	308	Public school	Barron Area	550087000118	140	Riverview Middle		Regular School	No	2.0	05	08	2015	grade_7	96	96
113259	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_7	8	8
113279	WI	Barron	school	5502130	903	Public school	Cameron	550213002286	200	Cameron Middle		Regular School	No	2.0	05	08	2015	grade_7	80	80
113454	WI	Barron	school	5500061	1080	Public school	Chetek-Weyerhaeuser Area	550006102806	200	Chetek-Weyerhaeuser Middle		Regular School	No	2.0	06	08	2015	grade_7	48	48
113475	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_7	10	10
113867	WI	Barron	school	5503090	1260	Public school	Cumberland	550309000304	50	Cumberland Middle		Regular School	No	2.0	05	08	2015	grade_7	49	49
113873	WI	Barron	school	5503090	1260	Public school	Cumberland	550309002962	420	Island City Academy	charter	Vocational Education School	Yes	3.0	07	12	2015	grade_7	9	9
113883	WI	Barron	school	5503090	1260	Public school	Cumberland	550309002871	800	Island City Virtual Academy	charter	Regular School	Yes	4.0	PK	12	2015	grade_7	1	1
122211	WI	Barron	school	5512180	4557	Public school	Prairie Farm Public	551218000445	30	Prairie Farm Middle		Regular School	No	2.0	06	08	2015	grade_7	18	18
122788	WI	Barron	school	5512810	4802	Public school	Rice Lake Area	551281001697	140	Rice Lake Middle		Regular School	No	2.0	05	08	2015	grade_7	134	134
124575	WI	Barron	school	5515060	5810	Public school	Turtle Lake	551506001955	20	Turtle Lake Elementary		Regular School	No	1.0	PK	08	2015	grade_7	34	34
282493	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_7	4	4
282530	WI	Barron	school	5500870	308	Public school	Barron Area	550087000118	140	Riverview Middle		Regular School	No	2.0	05	08	2016	grade_7	97	97
283241	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_7	3	3
283261	WI	Barron	school	5502130	903	Public school	Cameron	550213002286	200	Cameron Middle		Regular School	No	2.0	05	08	2016	grade_7	66	66
283433	WI	Barron	school	5500061	1080	Public school	Chetek-Weyerhaeuser Area	550006102806	200	Chetek-Weyerhaeuser Middle		Regular School	No	2.0	06	08	2016	grade_7	75	75
283453	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_7	3	3
283844	WI	Barron	school	5503090	1260	Public school	Cumberland	550309000304	50	Cumberland Middle		Regular School	No	2.0	05	08	2016	grade_7	76	76
283850	WI	Barron	school	5503090	1260	Public school	Cumberland	550309002962	420	Island City Academy	charter	Vocational Education School	Yes	3.0	07	12	2016	grade_7	12	12
283857	WI	Barron	school	5503090	1260	Public school	Cumberland	550309002871	800	Island City Virtual Academy	charter	Regular School	Yes	4.0	PK	12	2016	grade_7	1	1
292172	WI	Barron	school	5512180	4557	Public school	Prairie Farm Public	551218000445	30	Prairie Farm Middle		Regular School	No	2.0	06	08	2016	grade_7	20	20
292750	WI	Barron	school	5512810	4802	Public school	Rice Lake Area	551281001697	140	Rice Lake Middle		Regular School	No	2.0	05	08	2016	grade_7	172	172
294509	WI	Barron	school	5515060	5810	Public school	Turtle Lake	551506001955	20	Turtle Lake Elementary		Regular School	No	1.0	PK	08	2016	grade_7	27	27
326392	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_7	4	4
326428	WI	Barron	school	5500870	308	Public school	Barron Area	550087000118	140	Riverview Middle		Regular School	No	Middle	05	08	2017	grade_7	94	94
327137	WI	Barron	school	5502130	903	Public school	Cameron	550213002851	800	Cameron Academy of Virtual Education	charter	Alternative School	Yes	Other	KG	12	2017	grade_7	5	5
327156	WI	Barron	school	5502130	903	Public school	Cameron	550213002286	200	Cameron Middle		Regular School	No	Middle	05	08	2017	grade_7	72	72
327338	WI	Barron	school	5500061	1080	Public school	Chetek-Weyerhaeuser Area	550006102806	200	Chetek-Weyerhaeuser Middle		Regular School	No	Middle	06	08	2017	grade_7	61	61
327359	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_7	1	1
327747	WI	Barron	school	5503090	1260	Public school	Cumberland	550309000304	50	Cumberland Middle		Regular School	No	Middle	05	08	2017	grade_7	63	63
327753	WI	Barron	school	5503090	1260	Public school	Cumberland	550309002962	420	Island City Academy	charter	Career and Technical School	Yes	High	07	12	2017	grade_7	13	13
327763	WI	Barron	school	5503090	1260	Public school	Cumberland	550309002871	800	Island City Virtual Academy	charter	Regular School	Yes	Other	PK	12	2017	grade_7	3	3
336050	WI	Barron	school	5512180	4557	Public school	Prairie Farm Public	551218000445	30	Prairie Farm Middle		Regular School	No	Middle	06	08	2017	grade_7	29	29
336637	WI	Barron	school	5512810	4802	Public school	Rice Lake Area	551281001697	140	Rice Lake Middle		Regular School	No	Middle	05	08	2017	grade_7	149	149
338412	WI	Barron	school	5515060	5810	Public school	Turtle Lake	551506001955	20	Turtle Lake Elementary		Regular School	No	Elementary	PK	08	2017	grade_7	31	31
2318895	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_7	2	2
2318927	WI	Barron	school	5500870	308	Public school	Barron Area	550087000118	140	Riverview Middle		Regular School	No	Middle	05	08	2020	grade_7	92	92
2319664	WI	Barron	school	5502130	903	Public school	Cameron	550213002851	800	Cameron Academy of Virtual Education	charter	Alternative School	Yes	Other	PK	12	2020	grade_7	2	2
2319685	WI	Barron	school	5502130	903	Public school	Cameron	550213002286	200	Cameron Middle		Regular School	No	Middle	05	08	2020	grade_7	96	96
2319869	WI	Barron	school	5500061	1080	Public school	Chetek-Weyerhaeuser Area	550006102806	200	Chetek-Weyerhaeuser Middle		Regular School	No	Middle	06	08	2020	grade_7	73	73
2319890	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_7	3	3
2320285	WI	Barron	school	5503090	1260	Public school	Cumberland	550309000304	50	Cumberland Middle		Regular School	No	Middle	05	08	2020	grade_7	70	70
2320301	WI	Barron	school	5503090	1260	Public school	Cumberland	550309002871	800	Island City Virtual Academy	charter	Regular School	Yes	Other	PK	12	2020	grade_7	3	3
2328702	WI	Barron	school	5512180	4557	Public school	Prairie Farm Public	551218000445	30	Prairie Farm Middle		Regular School	No	Middle	06	08	2020	grade_7	44	44
2329253	WI	Barron	school	5512810	4802	Public school	Rice Lake Area	551281001697	140	Rice Lake Middle		Regular School	No	Middle	05	08	2020	grade_7	176	176
2331091	WI	Barron	school	5515060	5810	Public school	Turtle Lake	551506003068	30	Turtle Lake Middle		Regular School	No	Middle	06	08	2020	grade_7	30	30
2333679	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_7	10	10
2333711	WI	Barron	school	5500870	308	Public school	Barron Area	550087000118	140	Riverview Middle		Regular School	No	Middle	05	08	2021	grade_7	72	72
2334457	WI	Barron	school	5502130	903	Public school	Cameron	550213002851	800	Cameron Academy of Virtual Education	charter	Alternative School	Yes	Other	PK	12	2021	grade_7	16	16
2334478	WI	Barron	school	5502130	903	Public school	Cameron	550213002286	200	Cameron Middle		Regular School	No	Middle	05	08	2021	grade_7	74	74
2334655	WI	Barron	school	5500061	1080	Public school	Chetek-Weyerhaeuser Area	550006102806	200	Chetek-Weyerhaeuser Middle		Regular School	No	Middle	06	08	2021	grade_7	63	63
2334676	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_7	3	3
2335080	WI	Barron	school	5503090	1260	Public school	Cumberland	550309000304	50	Cumberland Middle		Regular School	No	Middle	05	08	2021	grade_7	58	58
2335086	WI	Barron	school	5503090	1260	Public school	Cumberland	550309002962	420	Island City Academy	charter	Career and Technical School	Yes	High	07	12	2021	grade_7	1	1
2335098	WI	Barron	school	5503090	1260	Public school	Cumberland	550309002871	800	Island City Virtual Academy	charter	Regular School	Yes	Other	PK	12	2021	grade_7	7	7
2343592	WI	Barron	school	5512180	4557	Public school	Prairie Farm Public	551218000445	30	Prairie Farm Middle		Regular School	No	Middle	06	08	2021	grade_7	28	28
2344148	WI	Barron	school	5512810	4802	Public school	Rice Lake Area	551281001697	140	Rice Lake Middle		Regular School	No	Middle	05	08	2021	grade_7	143	143
2345996	WI	Barron	school	5515060	5810	Public school	Turtle Lake	551506003032	810	Laker Online	charter	Regular School	Yes	Other	PK	12	2021	grade_7	5	5
2346019	WI	Barron	school	5515060	5810	Public school	Turtle Lake	551506003068	30	Turtle Lake Middle		Regular School	No	Middle	06	08	2021	grade_7	40	40
3074670	WI	Barron	school	5500870	308	Public school	Barron Area	550087002864	810	Advanced Learning Academy of Wisconsin	charter	Regular School	Yes	Other	KG	12	2019	grade_7	1	1
3074703	WI	Barron	school	5500870	308	Public school	Barron Area	550087000118	140	Riverview Middle		Regular School	No	Middle	05	08	2019	grade_7	82	82
3075442	WI	Barron	school	5502130	903	Public school	Cameron	550213002851	800	Cameron Academy of Virtual Education	charter	Alternative School	Yes	Other	PK	12	2019	grade_7	3	3
3075463	WI	Barron	school	5502130	903	Public school	Cameron	550213002286	200	Cameron Middle		Regular School	No	Middle	05	08	2019	grade_7	68	68
3075645	WI	Barron	school	5500061	1080	Public school	Chetek-Weyerhaeuser Area	550006102806	200	Chetek-Weyerhaeuser Middle		Regular School	No	Middle	06	08	2019	grade_7	72	72