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 district_state_id 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
113379	WI	Ozaukee	school	5502460	1015	Public school	Cedarburg	550246002772	110	Early Learning Center		Special Education School	No	1.0	PK	KG	2015	pre_kindergarten	21	21
283361	WI	Ozaukee	school	5502460	1015	Public school	Cedarburg	550246002772	110	Early Learning Center		Special Education School	No	1.0	PK	KG	2016	pre_kindergarten	26	26
327257	WI	Ozaukee	school	5502460	1015	Public school	Cedarburg	550246002772	110	Early Learning Center		Special Education School	No	Elementary	PK	PK	2017	pre_kindergarten	11	11
2319785	WI	Ozaukee	school	5502460	1015	Public school	Cedarburg	550246002772	110	Early Learning Center		Special Education School	No	Prekindergarten	PK	PK	2020	pre_kindergarten	20	20
2334567	WI	Ozaukee	school	5502460	1015	Public school	Cedarburg	550246002772	110	Early Learning Center		Special Education School	No	Prekindergarten	PK	PK	2021	pre_kindergarten	12	12
3075564	WI	Ozaukee	school	5502460	1015	Public school	Cedarburg	550246002772	110	Early Learning Center		Special Education School	No	Prekindergarten	PK	PK	2019	pre_kindergarten	8	8
3090314	WI	Ozaukee	school	5502460	1015	Public school	Cedarburg	550246002772	110	Early Learning Center		Special Education School	No	Prekindergarten	PK	PK	2018	pre_kindergarten	13	13
113362	WI	Sheboygan	school	5502430	1029	Public school	Cedar Grove-Belgium Area	550243000266	20	Cedar Grove-Belgium Elementary		Regular School	No	1.0	PK	04	2015	pre_kindergarten	9	9
283344	WI	Sheboygan	school	5502430	1029	Public school	Cedar Grove-Belgium Area	550243000266	20	Cedar Grove-Belgium Elementary		Regular School	No	1.0	PK	04	2016	pre_kindergarten	7	7
327240	WI	Sheboygan	school	5502430	1029	Public school	Cedar Grove-Belgium Area	550243000266	20	Cedar Grove-Belgium Elementary		Regular School	No	Elementary	PK	04	2017	pre_kindergarten	8	8
2319768	WI	Sheboygan	school	5502430	1029	Public school	Cedar Grove-Belgium Area	550243000266	20	Cedar Grove-Belgium Elementary		Regular School	No	Elementary	PK	04	2020	pre_kindergarten	8	8
2334550	WI	Sheboygan	school	5502430	1029	Public school	Cedar Grove-Belgium Area	550243000266	20	Cedar Grove-Belgium Elementary		Regular School	No	Elementary	PK	04	2021	pre_kindergarten	5	5
3075547	WI	Sheboygan	school	5502430	1029	Public school	Cedar Grove-Belgium Area	550243000266	20	Cedar Grove-Belgium Elementary		Regular School	No	Elementary	PK	04	2019	pre_kindergarten	11	11
3090297	WI	Sheboygan	school	5502430	1029	Public school	Cedar Grove-Belgium Area	550243000266	20	Cedar Grove-Belgium Elementary		Regular School	No	Elementary	PK	04	2018	pre_kindergarten	9	9
325751	WI	Portage	school	5500240	105	Public school	Almond-Bancroft	550024000025	60	Bancroft Elementary		Regular School	No	Elementary	PK	KG	2017	pre_kindergarten	1	1
2318253	WI	Portage	school	5500240	105	Public school	Almond-Bancroft	550024000023	20	Almond-Bancroft Elementary		Regular School	No	Elementary	PK	05	2020	pre_kindergarten	1	1
2333049	WI	Portage	school	5500240	105	Public school	Almond-Bancroft	550024000023	20	Almond-Bancroft Elementary		Regular School	No	Elementary	PK	05	2021	pre_kindergarten	1	1
3074022	WI	Portage	school	5500240	105	Public school	Almond-Bancroft	550024000023	20	Almond-Bancroft Elementary		Regular School	No	Elementary	PK	05	2019	pre_kindergarten	3	3
3088781	WI	Portage	school	5500240	105	Public school	Almond-Bancroft	550024000023	20	Almond-Bancroft Elementary		Regular School	No	Elementary	PK	05	2018	pre_kindergarten	1	1
327330	WI	Price	school	5500058	1071	Public school	Chequamegon	550005801523	110	Park Falls Elementary		Regular School	No	Elementary	PK	05	2017	pre_kindergarten	4	4
2334643	WI	Price	school	5500058	1071	Public school	Chequamegon	550005801523	110	Park Falls Elementary		Regular School	No	Elementary	PK	05	2021	pre_kindergarten	2	2
3075637	WI	Price	school	5500058	1071	Public school	Chequamegon	550005801523	110	Park Falls Elementary		Regular School	No	Elementary	PK	05	2019	pre_kindergarten	3	3
3090388	WI	Price	school	5500058	1071	Public school	Chequamegon	550005801523	110	Park Falls Elementary		Regular School	No	Elementary	PK	05	2018	pre_kindergarten	2	2
113464	WI	Barron	school	5500061	1080	Public school	Chetek-Weyerhaeuser Area	550006102805	100	Chetek-Weyerhaeuser Roselawn Elementary		Regular School	No	1.0	PK	05	2015	pre_kindergarten	6	6
283443	WI	Barron	school	5500061	1080	Public school	Chetek-Weyerhaeuser Area	550006102805	100	Chetek-Weyerhaeuser Roselawn Elementary		Regular School	No	1.0	PK	05	2016	pre_kindergarten	3	3
327348	WI	Barron	school	5500061	1080	Public school	Chetek-Weyerhaeuser Area	550006102805	100	Chetek-Weyerhaeuser Roselawn Elementary		Regular School	No	Elementary	PK	05	2017	pre_kindergarten	5	5
2319879	WI	Barron	school	5500061	1080	Public school	Chetek-Weyerhaeuser Area	550006102805	100	Chetek-Weyerhaeuser Roselawn Elementary		Regular School	No	Elementary	PK	05	2020	pre_kindergarten	7	7
2334665	WI	Barron	school	5500061	1080	Public school	Chetek-Weyerhaeuser Area	550006102805	100	Chetek-Weyerhaeuser Roselawn Elementary		Regular School	No	Elementary	PK	05	2021	pre_kindergarten	3	3
3075655	WI	Barron	school	5500061	1080	Public school	Chetek-Weyerhaeuser Area	550006102805	100	Chetek-Weyerhaeuser Roselawn Elementary		Regular School	No	Elementary	PK	05	2019	pre_kindergarten	5	5
3090406	WI	Barron	school	5500061	1080	Public school	Chetek-Weyerhaeuser Area	550006102805	100	Chetek-Weyerhaeuser Roselawn Elementary		Regular School	No	Elementary	PK	05	2018	pre_kindergarten	4	4
113490	WI	Calumet	school	5502520	1085	Public school	Chilton	550252000278	20	Chilton Elementary		Regular School	No	1.0	PK	04	2015	pre_kindergarten	2	2
283468	WI	Calumet	school	5502520	1085	Public school	Chilton	550252000278	20	Chilton Elementary		Regular School	No	1.0	PK	04	2016	pre_kindergarten	4	4
327375	WI	Calumet	school	5502520	1085	Public school	Chilton	550252000278	20	Chilton Elementary		Regular School	No	Elementary	PK	04	2017	pre_kindergarten	4	4
2319905	WI	Calumet	school	5502520	1085	Public school	Chilton	550252000278	20	Chilton Elementary		Regular School	No	Elementary	PK	04	2020	pre_kindergarten	9	9
2334690	WI	Calumet	school	5502520	1085	Public school	Chilton	550252000278	20	Chilton Elementary		Regular School	No	Elementary	PK	04	2021	pre_kindergarten	2	2
3075681	WI	Calumet	school	5502520	1085	Public school	Chilton	550252000278	20	Chilton Elementary		Regular School	No	Elementary	PK	04	2019	pre_kindergarten	8	8
3090431	WI	Calumet	school	5502520	1085	Public school	Chilton	550252000278	20	Chilton Elementary		Regular School	No	Elementary	PK	04	2018	pre_kindergarten	3	3
113533	WI	Chippewa	school	5502550	1092	Public school	Chippewa Falls Area Unified	550255002784	100	Korger-Chestnut		Regular School	No	1.0	PK	PK	2015	pre_kindergarten	33	33
283511	WI	Chippewa	school	5502550	1092	Public school	Chippewa Falls Area Unified	550255002784	100	Korger-Chestnut		Regular School	No	1.0	PK	PK	2016	pre_kindergarten	38	38
327418	WI	Chippewa	school	5502550	1092	Public school	Chippewa Falls Area Unified	550255002784	100	Korger-Chestnut		Regular School	No	Elementary	PK	PK	2017	pre_kindergarten	29	29
2319948	WI	Chippewa	school	5502550	1092	Public school	Chippewa Falls Area Unified	550255002784	100	Korger-Chestnut		Regular School	No	Prekindergarten	PK	PK	2020	pre_kindergarten	6	6
2334733	WI	Chippewa	school	5502550	1092	Public school	Chippewa Falls Area Unified	550255002784	100	Korger-Chestnut		Regular School	No	Prekindergarten	PK	PK	2021	pre_kindergarten	12	12
3075724	WI	Chippewa	school	5502550	1092	Public school	Chippewa Falls Area Unified	550255002784	100	Korger-Chestnut		Regular School	No	Prekindergarten	PK	PK	2019	pre_kindergarten	10	10
3090474	WI	Chippewa	school	5502550	1092	Public school	Chippewa Falls Area Unified	550255002784	100	Korger-Chestnut		Regular School	No	Prekindergarten	PK	PK	2018	pre_kindergarten	9	9
111896	WI	Eau Claire	school	5500270	112	Public school	Altoona	550027000028	80	Pedersen Elementary		Regular School	No	1.0	PK	03	2015	pre_kindergarten	14	14
281868	WI	Eau Claire	school	5500270	112	Public school	Altoona	550027000028	80	Pedersen Elementary		Regular School	No	1.0	PK	03	2016	pre_kindergarten	11	11
325758	WI	Eau Claire	school	5500270	112	Public school	Altoona	550027000028	80	Altoona Elementary		Regular School	No	Elementary	PK	03	2017	pre_kindergarten	13	13
2318269	WI	Eau Claire	school	5500270	112	Public school	Altoona	550027000028	80	Altoona Elementary		Regular School	No	Elementary	PK	03	2020	pre_kindergarten	10	10
2333065	WI	Eau Claire	school	5500270	112	Public school	Altoona	550027000028	80	Altoona Elementary		Regular School	No	Elementary	PK	03	2021	pre_kindergarten	9	9
3074038	WI	Eau Claire	school	5500270	112	Public school	Altoona	550027000028	80	Altoona Elementary		Regular School	No	Elementary	PK	03	2019	pre_kindergarten	14	14
3088797	WI	Eau Claire	school	5500270	112	Public school	Altoona	550027000028	80	Altoona Elementary		Regular School	No	Elementary	PK	03	2018	pre_kindergarten	11	11
113563	WI	Polk	school	5502580	1120	Public school	Clayton	550258000289	20	Clayton Elementary		Regular School	No	1.0	PK	05	2015	pre_kindergarten	5	5
283541	WI	Polk	school	5502580	1120	Public school	Clayton	550258000289	20	Clayton Elementary		Regular School	No	1.0	PK	05	2016	pre_kindergarten	2	2
327448	WI	Polk	school	5502580	1120	Public school	Clayton	550258000289	20	Clayton Elementary		Regular School	No	Elementary	PK	05	2017	pre_kindergarten	1	1
3075754	WI	Polk	school	5502580	1120	Public school	Clayton	550258000289	20	Clayton Elementary		Regular School	No	Elementary	PK	05	2019	pre_kindergarten	1	1
3090504	WI	Polk	school	5502580	1120	Public school	Clayton	550258000289	20	Clayton Elementary		Regular School	No	Elementary	PK	05	2018	pre_kindergarten	2	2
113590	WI	Polk	school	5502610	1127	Public school	Clear Lake	550261000291	20	Gaylord A Nelson Educ Center		Regular School	No	1.0	PK	06	2015	pre_kindergarten	6	6
283568	WI	Polk	school	5502610	1127	Public school	Clear Lake	550261000291	20	Gaylord A Nelson Educ Center		Regular School	No	1.0	PK	06	2016	pre_kindergarten	7	7
327475	WI	Polk	school	5502610	1127	Public school	Clear Lake	550261000291	20	Gaylord A Nelson Educational Center		Regular School	No	Elementary	PK	06	2017	pre_kindergarten	3	3
2320004	WI	Polk	school	5502610	1127	Public school	Clear Lake	550261000291	20	Gaylord A Nelson Educational Center		Regular School	No	Elementary	PK	06	2020	pre_kindergarten	2	2
2334789	WI	Polk	school	5502610	1127	Public school	Clear Lake	550261000291	20	Gaylord A Nelson Educational Center		Regular School	No	Elementary	PK	06	2021	pre_kindergarten	1	1
3075781	WI	Polk	school	5502610	1127	Public school	Clear Lake	550261000291	20	Gaylord A Nelson Educational Center		Regular School	No	Elementary	PK	06	2019	pre_kindergarten	3	3
3090531	WI	Polk	school	5502610	1127	Public school	Clear Lake	550261000291	20	Gaylord A Nelson Educational Center		Regular School	No	Elementary	PK	06	2018	pre_kindergarten	1	1
113598	WI	Rock	school	5502640	1134	Public school	Clinton Community	550264000295	40	Clinton Elementary		Regular School	No	1.0	PK	04	2015	pre_kindergarten	1	1
283576	WI	Rock	school	5502640	1134	Public school	Clinton Community	550264000295	40	Clinton Elementary		Regular School	No	1.0	PK	04	2016	pre_kindergarten	2	2
327483	WI	Rock	school	5502640	1134	Public school	Clinton Community	550264000295	40	Clinton Elementary		Regular School	No	Elementary	PK	04	2017	pre_kindergarten	5	5
2320012	WI	Rock	school	5502640	1134	Public school	Clinton Community	550264000295	40	Clinton Elementary		Regular School	No	Elementary	PK	04	2020	pre_kindergarten	5	5
2334797	WI	Rock	school	5502640	1134	Public school	Clinton Community	550264000295	40	Clinton Elementary		Regular School	No	Elementary	PK	04	2021	pre_kindergarten	4	4
3075789	WI	Rock	school	5502640	1134	Public school	Clinton Community	550264000295	40	Clinton Elementary		Regular School	No	Elementary	PK	04	2019	pre_kindergarten	5	5
3090539	WI	Rock	school	5502640	1134	Public school	Clinton Community	550264000295	40	Clinton Elementary		Regular School	No	Elementary	PK	04	2018	pre_kindergarten	2	2
113621	WI	Waupaca	school	5502670	1141	Public school	Clintonville	550267000303	60	Dellwood Early Learning Center		Regular School	No	1.0	PK	PK	2015	pre_kindergarten	6	6
283599	WI	Waupaca	school	5502670	1141	Public school	Clintonville	550267000303	60	Dellwood Early Learning Center		Regular School	No	1.0	PK	PK	2016	pre_kindergarten	8	8
327506	WI	Waupaca	school	5502670	1141	Public school	Clintonville	550267000303	60	Dellwood Early Learning Center		Regular School	No	Elementary	PK	PK	2017	pre_kindergarten	7	7
2320035	WI	Waupaca	school	5502670	1141	Public school	Clintonville	550267000303	60	Dellwood Early Learning Center		Regular School	No	Prekindergarten	PK	PK	2020	pre_kindergarten	7	7
2334825	WI	Waupaca	school	5502670	1141	Public school	Clintonville	550267000305	100	Longfellow Elementary		Regular School	No	Elementary	PK	04	2021	pre_kindergarten	6	6
3075812	WI	Waupaca	school	5502670	1141	Public school	Clintonville	550267000303	60	Dellwood Early Learning Center		Regular School	No	Prekindergarten	PK	PK	2019	pre_kindergarten	12	12
3090562	WI	Waupaca	school	5502670	1141	Public school	Clintonville	550267000303	60	Dellwood Early Learning Center		Regular School	No	Prekindergarten	PK	PK	2018	pre_kindergarten	5	5
113637	WI	Buffalo	school	5502700	1155	Public school	Cochrane-Fountain City	550270000306	20	Cochrane-Fountain City Elementary		Regular School	No	1.0	PK	06	2015	pre_kindergarten	1	1
283615	WI	Buffalo	school	5502700	1155	Public school	Cochrane-Fountain City	550270000306	20	Cochrane-Fountain City Elementary		Regular School	No	1.0	PK	06	2016	pre_kindergarten	2	2
2320051	WI	Buffalo	school	5502700	1155	Public school	Cochrane-Fountain City	550270000306	20	Cochrane-Fountain City Elementary		Regular School	No	Elementary	PK	06	2020	pre_kindergarten	2	2
2334836	WI	Buffalo	school	5502700	1155	Public school	Cochrane-Fountain City	550270000306	20	Cochrane-Fountain City Elementary		Regular School	No	Elementary	PK	06	2021	pre_kindergarten	2	2
3090578	WI	Buffalo	school	5502700	1155	Public school	Cochrane-Fountain City	550270000306	20	Cochrane-Fountain City Elementary		Regular School	No	Elementary	PK	06	2018	pre_kindergarten	1	1
113663	WI	Clark	school	5502730	1162	Public school	Colby	550273000312	120	Little Stars Pre-School		Regular School	No	1.0	PK	PK	2015	pre_kindergarten	43	43
283641	WI	Clark	school	5502730	1162	Public school	Colby	550273000312	120	Little Stars Pre-School		Regular School	No	1.0	PK	PK	2016	pre_kindergarten	19	19
283646	WI	Clark	school		1162	Public Schools-Multidistrict Charters	Colby		9100	Rural Virtual Academy	charter						2016	pre_kindergarten	1	1
327547	WI	Clark	school	5502730	1162	Public school	Colby	550273000312	120	Little Stars Pre-School		Regular School	No	Elementary	PK	PK	2017	pre_kindergarten	12	12
2320077	WI	Clark	school	5502730	1162	Public school	Colby	550273000312	120	Little Stars Pre-School		Regular School	No	Prekindergarten	PK	PK	2020	pre_kindergarten	6	6
2334861	WI	Clark	school	5502730	1162	Public school	Colby	550273000312	120	Little Stars Pre-School		Regular School	No	Prekindergarten	PK	PK	2021	pre_kindergarten	59	59
3090604	WI	Clark	school	5502730	1162	Public school	Colby	550273000312	120	Little Stars Pre-School		Regular School	No	Prekindergarten	PK	PK	2018	pre_kindergarten	8	8
113675	WI	Marinette	school	5502760	1169	Public school	Coleman	550276000313	40	Coleman Elementary		Regular School	No	1.0	PK	05	2015	pre_kindergarten	45	45
283655	WI	Marinette	school	5502760	1169	Public school	Coleman	550276000313	40	Coleman Elementary		Regular School	No	1.0	PK	05	2016	pre_kindergarten	9	9
327558	WI	Marinette	school	5502760	1169	Public school	Coleman	550276000313	40	Coleman Elementary		Regular School	No	Elementary	PK	05	2017	pre_kindergarten	63	63
2320094	WI	Marinette	school	5502760	1169	Public school	Coleman	550276000313	40	Coleman Elementary		Regular School	No	Elementary	PK	05	2020	pre_kindergarten	64	64
2334878	WI	Marinette	school	5502760	1169	Public school	Coleman	550276000313	40	Coleman Elementary		Regular School	No	Elementary	PK	05	2021	pre_kindergarten	46	46
3075866	WI	Marinette	school	5502760	1169	Public school	Coleman	550276000313	40	Coleman Elementary		Regular School	No	Elementary	PK	05	2019	pre_kindergarten	52	52
3090616	WI	Marinette	school	5502760	1169	Public school	Coleman	550276000313	40	Coleman Elementary		Regular School	No	Elementary	PK	05	2018	pre_kindergarten	51	51
113694	WI	Dunn	school	5502790	1176	Public school	Colfax	550279000315	20	Colfax Elementary		Regular School	No	1.0	PK	06	2015	pre_kindergarten	6	6
283674	WI	Dunn	school	5502790	1176	Public school	Colfax	550279000315	20	Colfax Elementary		Regular School	No	1.0	PK	06	2016	pre_kindergarten	6	6
327577	WI	Dunn	school	5502790	1176	Public school	Colfax	550279000315	20	Colfax Elementary		Regular School	No	Elementary	PK	06	2017	pre_kindergarten	5	5
2320113	WI	Dunn	school	5502790	1176	Public school	Colfax	550279000315	20	Colfax Elementary		Regular School	No	Elementary	PK	06	2020	pre_kindergarten	4	4
2334897	WI	Dunn	school	5502790	1176	Public school	Colfax	550279000315	20	Colfax Elementary		Regular School	No	Elementary	PK	06	2021	pre_kindergarten	9	9