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 ccd_school_high_grade 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
283646	WI	Clark	school		1162	Public Schools-Multidistrict Charters	Colby		9100	Rural Virtual Academy	charter						2016	pre_kindergarten	1	1
288237	WI	Juneau	school		3360	Public Schools-Multidistrict Charters	Mauston		9803	JEDI Virtual K-12	charter						2016	pre_kindergarten	1	1
112662	WI	Dane	school	5500990	350	Public school	Belleville	550099000131	20	Belleville Elementary		Regular School	No	1.0	PK	01	2015	pre_kindergarten	6	6
112912	WI	Jackson	school	5501260	476	Public school	Black River Falls	550126000176	80	Forrest Street Early Learning Center		Regular School	No	1.0	PK	01	2015	pre_kindergarten	6	6
114254	WI	Walworth	school	5504020	1540	Public school	East Troy Community	550402000409	20	Doubek Elementary		Regular School	No	1.0	PK	01	2015	pre_kindergarten	13	13
116548	WI	Outagamie	school	5507290	2758	Public school	Kaukauna Area	550729002433	50	Dr H B Tanner Elementary		Regular School	No	1.0	PK	01	2015	pre_kindergarten	33	33
118396	WI	Winnebago	school	5509030	3430	Public school	Menasha Joint	550903000659	160	Banta School		Regular School	No	1.0	PK	01	2015	pre_kindergarten	17	17
120407	WI	Dane	school	5509810	3675	Public school	Monona Grove	550981000682	120	Taylor Prairie Elementary		Regular School	No	1.0	PK	01	2015	pre_kindergarten	5	5
121473	WI	Winnebago	school	5510980	4088	Public school	Omro	551098001440	40	Patch Elementary		Regular School	No	1.0	PK	01	2015	pre_kindergarten	4	4
121980	WI	Grant	school	5511850	4389	Public school	Platteville	551185001551	20	Wilkins Elementary		Regular School	No	1.0	PK	01	2015	pre_kindergarten	9	9
122168	WI	Crawford	school	5512150	4543	Public school	Prairie du Chien Area	551215002508	10	BA Kennedy School		Regular School	No	1.0	PK	01	2015	pre_kindergarten	8	8
125197	WI	Fond du Lac	school	5515870	6216	Public school	Waupun	551587002044	160	Meadow View Primary		Regular School	No	1.0	PK	01	2015	pre_kindergarten	20	20
282639	WI	Dane	school	5500990	350	Public school	Belleville	550099000131	20	Belleville Elementary		Regular School	No	1.0	PK	01	2016	pre_kindergarten	2	2
282893	WI	Jackson	school	5501260	476	Public school	Black River Falls	550126000176	80	Forrest Street Early Learning Center		Regular School	No	1.0	PK	01	2016	pre_kindergarten	4	4
284236	WI	Walworth	school	5504020	1540	Public school	East Troy Community	550402000409	20	Doubek Elementary		Regular School	No	1.0	PK	01	2016	pre_kindergarten	12	12
286553	WI	Outagamie	school	5507290	2758	Public school	Kaukauna Area	550729002433	50	Dr H B Tanner Elementary		Regular School	No	1.0	PK	01	2016	pre_kindergarten	17	17
290365	WI	Dane	school	5509810	3675	Public school	Monona Grove	550981000682	120	Taylor Prairie Elementary		Regular School	No	1.0	PK	01	2016	pre_kindergarten	7	7
291436	WI	Winnebago	school	5510980	4088	Public school	Omro	551098001440	40	Patch Elementary		Regular School	No	1.0	PK	01	2016	pre_kindergarten	3	3
291941	WI	Grant	school	5511850	4389	Public school	Platteville	551185001551	20	Wilkins Elementary		Regular School	No	1.0	PK	01	2016	pre_kindergarten	7	7
292129	WI	Crawford	school	5512150	4543	Public school	Prairie du Chien Area	551215002508	10	BA Kennedy School		Regular School	No	1.0	PK	01	2016	pre_kindergarten	44	44
295133	WI	Fond du Lac	school	5515870	6216	Public school	Waupun	551587002044	160	Meadow View Primary		Regular School	No	1.0	PK	01	2016	pre_kindergarten	9	9
326540	WI	Dane	school	5500990	350	Public school	Belleville	550099000131	20	Belleville Elementary		Regular School	No	Elementary	PK	01	2017	pre_kindergarten	1	1
326794	WI	Jackson	school	5501260	476	Public school	Black River Falls	550126000176	80	Forrest Street Early Learning Center		Regular School	No	Elementary	PK	01	2017	pre_kindergarten	9	9
328134	WI	Walworth	school	5504020	1540	Public school	East Troy Community	550402000409	20	Doubek Elementary		Regular School	No	Elementary	PK	01	2017	pre_kindergarten	9	9
330432	WI	Outagamie	school	5507290	2758	Public school	Kaukauna Area	550729002433	50	Dr H B Tanner Elementary		Regular School	No	Elementary	PK	01	2017	pre_kindergarten	33	33
334236	WI	Dane	school	5509810	3675	Public school	Monona Grove	550981000682	120	Taylor Prairie Elementary		Regular School	No	Elementary	PK	01	2017	pre_kindergarten	6	6
335299	WI	Winnebago	school	5510980	4088	Public school	Omro	551098001440	40	Patch Elementary		Regular School	No	Elementary	PK	01	2017	pre_kindergarten	5	5
336008	WI	Crawford	school	5512150	4543	Public school	Prairie du Chien Area	551215002508	10	BA Kennedy School		Regular School	No	Elementary	PK	01	2017	pre_kindergarten	11	11
338989	WI	Waukesha	school	5515780	6174	Public school	Waukesha	551578002926	110	White Rock Campus		Regular School	No	Elementary	PK	01	2017	pre_kindergarten	36	36
339060	WI	Fond du Lac	school	5515870	6216	Public school	Waupun	551587002044	160	Meadow View Primary		Regular School	No	Elementary	PK	01	2017	pre_kindergarten	17	17
2319292	WI	Jackson	school	5501260	476	Public school	Black River Falls	550126000176	80	Forrest Street Early Learning Center		Regular School	No	Elementary	PK	01	2020	pre_kindergarten	10	10
2323005	WI	Outagamie	school	5507290	2758	Public school	Kaukauna Area	550729002433	50	Dr H B Tanner Elementary		Regular School	No	Elementary	PK	01	2020	pre_kindergarten	29	29
2326840	WI	Dane	school	5509810	3675	Public school	Monona Grove	550981000682	120	Taylor Prairie Elementary		Regular School	No	Elementary	PK	01	2020	pre_kindergarten	8	8
2327946	WI	Winnebago	school	5510980	4088	Public school	Omro	551098001440	40	Patch Elementary		Regular School	No	Elementary	PK	01	2020	pre_kindergarten	5	5
2328657	WI	Crawford	school	5512150	4543	Public school	Prairie du Chien Area	551215002508	10	BA Kennedy School		Regular School	No	Elementary	PK	01	2020	pre_kindergarten	17	17
2330933	WI	Monroe	school	5514910	5747	Public school	Tomah Area	551491001937	140	Oakdale Elementary		Regular School	No	Elementary	PK	01	2020	pre_kindergarten	31	31
2331753	WI	Fond du Lac	school	5515870	6216	Public school	Waupun	551587002044	160	Meadow View Primary		Regular School	No	Elementary	PK	01	2020	pre_kindergarten	12	12
2334076	WI	Jackson	school	5501260	476	Public school	Black River Falls	550126000176	80	Forrest Street Early Learning Center		Regular School	No	Elementary	PK	01	2021	pre_kindergarten	7	7
2337876	WI	Outagamie	school	5507290	2758	Public school	Kaukauna Area	550729002433	50	Dr H B Tanner Elementary		Regular School	No	Elementary	PK	01	2021	pre_kindergarten	18	18
2341707	WI	Dane	school	5509810	3675	Public school	Monona Grove	550981000682	120	Taylor Prairie Elementary		Regular School	No	Elementary	PK	01	2021	pre_kindergarten	5	5
2342831	WI	Winnebago	school	5510980	4088	Public school	Omro	551098001440	40	Patch Elementary		Regular School	No	Elementary	PK	01	2021	pre_kindergarten	6	6
2343547	WI	Crawford	school	5512150	4543	Public school	Prairie du Chien Area	551215002508	10	BA Kennedy School		Regular School	No	Elementary	PK	01	2021	pre_kindergarten	7	7
2345848	WI	Monroe	school	5514910	5747	Public school	Tomah Area	551491001937	140	Oakdale Elementary		Regular School	No	Elementary	PK	01	2021	pre_kindergarten	16	16
2346709	WI	Fond du Lac	school	5515870	6216	Public school	Waupun	551587002044	160	Meadow View Primary		Regular School	No	Elementary	PK	01	2021	pre_kindergarten	12	12
3075079	WI	Jackson	school	5501260	476	Public school	Black River Falls	550126000176	80	Forrest Street Early Learning Center		Regular School	No	Elementary	PK	01	2019	pre_kindergarten	9	9
3078754	WI	Outagamie	school	5507290	2758	Public school	Kaukauna Area	550729002433	50	Dr H B Tanner Elementary		Regular School	No	Elementary	PK	01	2019	pre_kindergarten	29	29
3082606	WI	Dane	school	5509810	3675	Public school	Monona Grove	550981000682	120	Taylor Prairie Elementary		Regular School	No	Elementary	PK	01	2019	pre_kindergarten	10	10
3083684	WI	Winnebago	school	5510980	4088	Public school	Omro	551098001440	40	Patch Elementary		Regular School	No	Elementary	PK	01	2019	pre_kindergarten	9	9
3084395	WI	Crawford	school	5512150	4543	Public school	Prairie du Chien Area	551215002508	10	BA Kennedy School		Regular School	No	Elementary	PK	01	2019	pre_kindergarten	6	6
3086631	WI	Monroe	school	5514910	5747	Public school	Tomah Area	551491001937	140	Oakdale Elementary		Regular School	No	Elementary	PK	01	2019	pre_kindergarten	21	21
3087449	WI	Fond du Lac	school	5515870	6216	Public school	Waupun	551587002044	160	Meadow View Primary		Regular School	No	Elementary	PK	01	2019	pre_kindergarten	14	14
3089570	WI	Dane	school	5500990	350	Public school	Belleville	550099000131	20	Belleville Elementary		Regular School	No	Elementary	PK	01	2018	pre_kindergarten	5	5
3089839	WI	Jackson	school	5501260	476	Public school	Black River Falls	550126000176	80	Forrest Street Early Learning Center		Regular School	No	Elementary	PK	01	2018	pre_kindergarten	11	11
3093497	WI	Outagamie	school	5507290	2758	Public school	Kaukauna Area	550729002433	50	Dr H B Tanner Elementary		Regular School	No	Elementary	PK	01	2018	pre_kindergarten	25	25
3097309	WI	Dane	school	5509810	3675	Public school	Monona Grove	550981000682	120	Taylor Prairie Elementary		Regular School	No	Elementary	PK	01	2018	pre_kindergarten	8	8
3098386	WI	Winnebago	school	5510980	4088	Public school	Omro	551098001440	40	Patch Elementary		Regular School	No	Elementary	PK	01	2018	pre_kindergarten	7	7
3099089	WI	Crawford	school	5512150	4543	Public school	Prairie du Chien Area	551215002508	10	BA Kennedy School		Regular School	No	Elementary	PK	01	2018	pre_kindergarten	5	5
3102142	WI	Fond du Lac	school	5515870	6216	Public school	Waupun	551587002044	160	Meadow View Primary		Regular School	No	Elementary	PK	01	2018	pre_kindergarten	14	14
111915	WI	Polk	school	5500300	119	Public school	Amery	550030000029	20	Lien Elementary		Regular School	No	1.0	PK	02	2015	pre_kindergarten	4	4
112306	WI	Ashland	school	5500510	170	Public school	Ashland	550051000077	80	Lake Superior Primary		Regular School	No	1.0	PK	02	2015	pre_kindergarten	26	26
112792	WI	Rock	school	5501080	422	Public school	Beloit Turner	550108000157	60	Powers Elementary		Regular School	No	1.0	PK	02	2015	pre_kindergarten	13	13
114687	WI	Rock	school	5504440	1694	Public school	Evansville Community	550444000477	20	Levi Leonard Elementary		Regular School	No	1.0	PK	02	2015	pre_kindergarten	10	10
115878	WI	Waukesha	school	5506140	2460	Public school	Hartland-Lakeside J3	550614002257	20	North Elementary		Regular School	No	1.0	PK	02	2015	pre_kindergarten	2	2
115921	WI	Sawyer	school	5506270	2478	Public school	Hayward Community	550627000689	20	Hayward Primary		Regular School	No	1.0	PK	02	2015	pre_kindergarten	20	20
117617	WI	Kewaunee	school	5508340	3220	Public school	Luxemburg-Casco	550834002525	110	Luxemburg-Casco Primary		Regular School	No	1.0	PK	02	2015	pre_kindergarten	20	20
117769	WI	Dane	school	5508520	3269	Public school	Madison Metropolitan	550852002412	53	Lapham Elementary		Regular School	No	1.0	PK	02	2015	pre_kindergarten	11	11
118062	WI	Milwaukee	school	5504770	1897	Public school	Maple Dale-Indian Hill	550477000515	20	Indian Hill Elementary		Regular School	No	1.0	PK	02	2015	pre_kindergarten	2	2
118162	WI	Dane	school	5508790	3332	Public school	Marshall	550879000569	80	Marshall Early Learning Center		Regular School	No	1.0	PK	02	2015	pre_kindergarten	4	4
118266	WI	Juneau	school	5508850	3360	Public school	Mauston	550885001027	80	West Side Elementary		Regular School	No	1.0	PK	02	2015	pre_kindergarten	4	4
118284	WI	Dodge	school	5508880	3367	Public school	Mayville	550888001031	90	Parkview Elementary		Regular School	No	1.0	PK	02	2015	pre_kindergarten	10	10
121565	WI	Polk	school	5511160	4165	Public school	Osceola	551116001479	40	Osceola Elementary		Regular School	No	1.0	PK	02	2015	pre_kindergarten	9	9
121842	WI	Rock	school	5511130	4151	Public school	Parkview	551113001473	20	Parkview Primary		Regular School	No	1.0	PK	02	2015	pre_kindergarten	5	5
122802	WI	Washington	school	5512900	4820	Public school	Richfield J1	551290000467	40	Plat Elementary		Regular School	No	1.0	PK	02	2015	pre_kindergarten	5	5
122874	WI	Fond du Lac	school	5513020	4872	Public school	Ripon Area	551302001893	110	Barlow Park Elementary		Regular School	No	1.0	PK	02	2015	pre_kindergarten	3	3
123232	WI	Sauk	school	5513410	5100	Public school	Sauk Prairie	551341001761	150	Spruce Street Elementary		Regular School	No	1.0	PK	02	2015	pre_kindergarten	9	9
123339	WI	Shawano	school	5513620	5264	Public school	Shawano	551362002819	150	Hillcrest Primary School		Regular School	No	1.0	PK	02	2015	pre_kindergarten	23	23
123554	WI	Washburn	school	5513710	5306	Public school	Shell Lake	551371000507	10	Shell Lake Primary (K-2)		Regular School	No	1.0	PK	02	2015	pre_kindergarten	4	4
124450	WI	Monroe	school	5514910	5747	Public school	Tomah Area	551491001937	140	Oakdale Elementary		Regular School	No	1.0	PK	02	2015	pre_kindergarten	7	7
126180	WI	Dane	school	5501230	469	Public school	Wisconsin Heights	550123000170	20	Black Earth Elementary		Regular School	No	1.0	PK	02	2015	pre_kindergarten	5	5
281887	WI	Polk	school	5500300	119	Public school	Amery	550030000029	20	Lien Elementary		Regular School	No	1.0	PK	02	2016	pre_kindergarten	2	2
282285	WI	Ashland	school	5500510	170	Public school	Ashland	550051000077	80	Lake Superior Primary		Regular School	No	1.0	PK	02	2016	pre_kindergarten	27	27
282771	WI	Rock	school	5501080	422	Public school	Beloit Turner	550108000157	60	Powers Elementary		Regular School	No	1.0	PK	02	2016	pre_kindergarten	11	11
284685	WI	Rock	school	5504440	1694	Public school	Evansville Community	550444000477	20	Levi Leonard Elementary		Regular School	No	1.0	PK	02	2016	pre_kindergarten	9	9
285881	WI	Waukesha	school	5506140	2460	Public school	Hartland-Lakeside J3	550614002257	20	North Elementary		Regular School	No	1.0	PK	02	2016	pre_kindergarten	7	7
285924	WI	Sawyer	school	5506270	2478	Public school	Hayward Community	550627000689	20	Hayward Primary		Regular School	No	1.0	PK	02	2016	pre_kindergarten	26	26
287614	WI	Kewaunee	school	5508340	3220	Public school	Luxemburg-Casco	550834002525	110	Luxemburg-Casco Primary		Regular School	No	1.0	PK	02	2016	pre_kindergarten	17	17
287765	WI	Dane	school	5508520	3269	Public school	Madison Metropolitan	550852002412	53	Lapham Elementary		Regular School	No	1.0	PK	02	2016	pre_kindergarten	12	12
288054	WI	Milwaukee	school	5504770	1897	Public school	Maple Dale-Indian Hill	550477000515	20	Indian Hill Elementary		Regular School	No	1.0	PK	02	2016	pre_kindergarten	5	5
288152	WI	Dane	school	5508790	3332	Public school	Marshall	550879000569	80	Marshall Early Learning Center		Regular School	No	1.0	PK	02	2016	pre_kindergarten	3	3
288261	WI	Juneau	school	5508850	3360	Public school	Mauston	550885001027	80	West Side Elementary		Regular School	No	1.0	PK	02	2016	pre_kindergarten	10	10
288279	WI	Dodge	school	5508880	3367	Public school	Mayville	550888001031	90	Parkview Elementary		Regular School	No	1.0	PK	02	2016	pre_kindergarten	7	7
291528	WI	Polk	school	5511160	4165	Public school	Osceola	551116001479	40	Osceola Elementary		Regular School	No	1.0	PK	02	2016	pre_kindergarten	7	7
292765	WI	Washington	school	5512900	4820	Public school	Richfield J1	551290000467	40	Plat Elementary		Regular School	No	1.0	PK	02	2016	pre_kindergarten	1	1
292838	WI	Fond du Lac	school	5513020	4872	Public school	Ripon Area	551302001893	110	Barlow Park Elementary		Regular School	No	1.0	PK	02	2016	pre_kindergarten	2	2
293161	WI	Sauk	school	5513410	5100	Public school	Sauk Prairie	551341001761	150	Bridges Elementary		Regular School	No	1.0	PK	02	2016	pre_kindergarten	4	4
293294	WI	Shawano	school	5513620	5264	Public school	Shawano	551362002819	150	Hillcrest Primary School		Regular School	No	1.0	PK	02	2016	pre_kindergarten	27	27
293300	WI	Shawano	school	5513620	5264	Public school	Shawano	551362002908	110	LEADS Primary Charter School	charter	Regular School	Yes	1.0	PK	02	2016	pre_kindergarten	12	12
293508	WI	Washburn	school	5513710	5306	Public school	Shell Lake	551371000507	10	Shell Lake Primary (K-2)		Regular School	No	1.0	PK	02	2016	pre_kindergarten	2	2
294386	WI	Monroe	school	5514910	5747	Public school	Tomah Area	551491001937	140	Oakdale Elementary		Regular School	No	1.0	PK	02	2016	pre_kindergarten	4	4
296118	WI	Dane	school	5501230	469	Public school	Wisconsin Heights	550123000170	20	Black Earth Elementary		Regular School	No	1.0	PK	02	2016	pre_kindergarten	8	8
325789	WI	Polk	school	5500300	119	Public school	Amery	550030000029	20	Lien Elementary		Regular School	No	Elementary	PK	02	2017	pre_kindergarten	4	4