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 and (district_state_id > :p3 or (district_state_id = :p3 and rowid > :p2)) order by district_state_id, rowid 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
3090322	WI	Ozaukee	school	5502460	1015	Public school	Cedarburg	550246000271	70	Parkview Elementary		Regular School	No	Elementary	PK	05	2018	kindergarten_4_year_old	52	52
3090330	WI	Ozaukee	school	5502460	1015	Public school	Cedarburg	550246000272	90	Thorson Elementary		Regular School	No	Elementary	PK	05	2018	kindergarten_4_year_old	54	54
3090342	WI	Ozaukee	school	5502460	1015	Public school	Cedarburg	550246002403	75	Westlawn Elementary		Regular School	No	Elementary	PK	05	2018	kindergarten_4_year_old	37	37
113360	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	kindergarten_4_year_old	63	63
283342	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	kindergarten_4_year_old	50	50
327238	WI	Sheboygan	school	5502430	1029	Public school	Cedar Grove-Belgium Area	550243000266	20	Cedar Grove-Belgium Elementary		Regular School	No	Elementary	PK	04	2017	kindergarten_4_year_old	54	54
2319766	WI	Sheboygan	school	5502430	1029	Public school	Cedar Grove-Belgium Area	550243000266	20	Cedar Grove-Belgium Elementary		Regular School	No	Elementary	PK	04	2020	kindergarten_4_year_old	69	69
2334548	WI	Sheboygan	school	5502430	1029	Public school	Cedar Grove-Belgium Area	550243000266	20	Cedar Grove-Belgium Elementary		Regular School	No	Elementary	PK	04	2021	kindergarten_4_year_old	43	43
3075545	WI	Sheboygan	school	5502430	1029	Public school	Cedar Grove-Belgium Area	550243000266	20	Cedar Grove-Belgium Elementary		Regular School	No	Elementary	PK	04	2019	kindergarten_4_year_old	66	66
3090295	WI	Sheboygan	school	5502430	1029	Public school	Cedar Grove-Belgium Area	550243000266	20	Cedar Grove-Belgium Elementary		Regular School	No	Elementary	PK	04	2018	kindergarten_4_year_old	49	49
111876	WI	Portage	school	5500240	105	Public school	Almond-Bancroft	550024000025	60	Bancroft Elementary		Regular School	No	1.0	PK	KG	2015	kindergarten_4_year_old	25	25
281848	WI	Portage	school	5500240	105	Public school	Almond-Bancroft	550024000025	60	Bancroft Elementary		Regular School	No	1.0	PK	KG	2016	kindergarten_4_year_old	39	39
325749	WI	Portage	school	5500240	105	Public school	Almond-Bancroft	550024000025	60	Bancroft Elementary		Regular School	No	Elementary	PK	KG	2017	kindergarten_4_year_old	28	28
2318251	WI	Portage	school	5500240	105	Public school	Almond-Bancroft	550024000023	20	Almond-Bancroft Elementary		Regular School	No	Elementary	PK	05	2020	kindergarten_4_year_old	23	23
2333047	WI	Portage	school	5500240	105	Public school	Almond-Bancroft	550024000023	20	Almond-Bancroft Elementary		Regular School	No	Elementary	PK	05	2021	kindergarten_4_year_old	31	31
3074020	WI	Portage	school	5500240	105	Public school	Almond-Bancroft	550024000023	20	Almond-Bancroft Elementary		Regular School	No	Elementary	PK	05	2019	kindergarten_4_year_old	28	28
3088779	WI	Portage	school	5500240	105	Public school	Almond-Bancroft	550024000023	20	Almond-Bancroft Elementary		Regular School	No	Elementary	PK	05	2018	kindergarten_4_year_old	22	22
113437	WI	Price	school	5500058	1071	Public school	Chequamegon	550005800590	100	Glidden Elementary		Regular School	No	1.0	PK	02	2015	kindergarten_4_year_old	8	8
113445	WI	Price	school	5500058	1071	Public school	Chequamegon	550005801523	110	Park Falls Elementary		Regular School	No	1.0	PK	05	2015	kindergarten_4_year_old	31	31
283416	WI	Price	school	5500058	1071	Public school	Chequamegon	550005800590	100	Glidden Elementary		Regular School	No	1.0	PK	03	2016	kindergarten_4_year_old	9	9
283424	WI	Price	school	5500058	1071	Public school	Chequamegon	550005801523	110	Park Falls Elementary		Regular School	No	1.0	PK	05	2016	kindergarten_4_year_old	26	26
327320	WI	Price	school	5500058	1071	Public school	Chequamegon	550005800590	100	Glidden Elementary		Regular School	No	Elementary	PK	03	2017	kindergarten_4_year_old	5	5
327328	WI	Price	school	5500058	1071	Public school	Chequamegon	550005801523	110	Park Falls Elementary		Regular School	No	Elementary	PK	05	2017	kindergarten_4_year_old	18	18
2319851	WI	Price	school	5500058	1071	Public school	Chequamegon	550005800590	100	Glidden Elementary		Regular School	No	Elementary	PK	03	2020	kindergarten_4_year_old	1	1
2319859	WI	Price	school	5500058	1071	Public school	Chequamegon	550005801523	110	Park Falls Elementary		Regular School	No	Elementary	PK	05	2020	kindergarten_4_year_old	26	26
2334633	WI	Price	school	5500058	1071	Public school	Chequamegon	550005800590	100	Glidden Elementary		Regular School	No	Elementary	PK	03	2021	kindergarten_4_year_old	9	9
2334641	WI	Price	school	5500058	1071	Public school	Chequamegon	550005801523	110	Park Falls Elementary		Regular School	No	Elementary	PK	05	2021	kindergarten_4_year_old	31	31
3075627	WI	Price	school	5500058	1071	Public school	Chequamegon	550005800590	100	Glidden Elementary		Regular School	No	Elementary	PK	03	2019	kindergarten_4_year_old	7	7
3075635	WI	Price	school	5500058	1071	Public school	Chequamegon	550005801523	110	Park Falls Elementary		Regular School	No	Elementary	PK	05	2019	kindergarten_4_year_old	40	40
3090378	WI	Price	school	5500058	1071	Public school	Chequamegon	550005800590	100	Glidden Elementary		Regular School	No	Elementary	PK	03	2018	kindergarten_4_year_old	8	8
3090386	WI	Price	school	5500058	1071	Public school	Chequamegon	550005801523	110	Park Falls Elementary		Regular School	No	Elementary	PK	05	2018	kindergarten_4_year_old	34	34
113462	WI	Barron	school	5500061	1080	Public school	Chetek-Weyerhaeuser Area	550006102805	100	Chetek-Weyerhaeuser Roselawn Elementary		Regular School	No	1.0	PK	05	2015	kindergarten_4_year_old	63	63
113478	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	kindergarten_4_year_old	2	2
283441	WI	Barron	school	5500061	1080	Public school	Chetek-Weyerhaeuser Area	550006102805	100	Chetek-Weyerhaeuser Roselawn Elementary		Regular School	No	1.0	PK	05	2016	kindergarten_4_year_old	79	79
283456	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	kindergarten_4_year_old	1	1
327346	WI	Barron	school	5500061	1080	Public school	Chetek-Weyerhaeuser Area	550006102805	100	Chetek-Weyerhaeuser Roselawn Elementary		Regular School	No	Elementary	PK	05	2017	kindergarten_4_year_old	72	72
327362	WI	Barron	school	5500061	1080	Public school	Chetek-Weyerhaeuser Area	550006102897	800	Link2Learn Virtual Charter School	charter	Regular School	Yes	Other	PK	12	2017	kindergarten_4_year_old	2	2
2319877	WI	Barron	school	5500061	1080	Public school	Chetek-Weyerhaeuser Area	550006102805	100	Chetek-Weyerhaeuser Roselawn Elementary		Regular School	No	Elementary	PK	05	2020	kindergarten_4_year_old	58	58
2319893	WI	Barron	school	5500061	1080	Public school	Chetek-Weyerhaeuser Area	550006102897	800	Link2Learn Virtual Charter School	charter	Regular School	Yes	Other	PK	12	2020	kindergarten_4_year_old	2	2
2334663	WI	Barron	school	5500061	1080	Public school	Chetek-Weyerhaeuser Area	550006102805	100	Chetek-Weyerhaeuser Roselawn Elementary		Regular School	No	Elementary	PK	05	2021	kindergarten_4_year_old	68	68
3075653	WI	Barron	school	5500061	1080	Public school	Chetek-Weyerhaeuser Area	550006102805	100	Chetek-Weyerhaeuser Roselawn Elementary		Regular School	No	Elementary	PK	05	2019	kindergarten_4_year_old	68	68
3075669	WI	Barron	school	5500061	1080	Public school	Chetek-Weyerhaeuser Area	550006102897	800	Link2Learn Virtual Charter School	charter	Regular School	Yes	Other	PK	12	2019	kindergarten_4_year_old	2	2
3090404	WI	Barron	school	5500061	1080	Public school	Chetek-Weyerhaeuser Area	550006102805	100	Chetek-Weyerhaeuser Roselawn Elementary		Regular School	No	Elementary	PK	05	2018	kindergarten_4_year_old	76	76
113488	WI	Calumet	school	5502520	1085	Public school	Chilton	550252000278	20	Chilton Elementary		Regular School	No	1.0	PK	04	2015	kindergarten_4_year_old	67	67
283466	WI	Calumet	school	5502520	1085	Public school	Chilton	550252000278	20	Chilton Elementary		Regular School	No	1.0	PK	04	2016	kindergarten_4_year_old	57	57
327373	WI	Calumet	school	5502520	1085	Public school	Chilton	550252000278	20	Chilton Elementary		Regular School	No	Elementary	PK	04	2017	kindergarten_4_year_old	60	60
2319903	WI	Calumet	school	5502520	1085	Public school	Chilton	550252000278	20	Chilton Elementary		Regular School	No	Elementary	PK	04	2020	kindergarten_4_year_old	48	48
2334688	WI	Calumet	school	5502520	1085	Public school	Chilton	550252000278	20	Chilton Elementary		Regular School	No	Elementary	PK	04	2021	kindergarten_4_year_old	70	70
3075679	WI	Calumet	school	5502520	1085	Public school	Chilton	550252000278	20	Chilton Elementary		Regular School	No	Elementary	PK	04	2019	kindergarten_4_year_old	41	41
3090429	WI	Calumet	school	5502520	1085	Public school	Chilton	550252000278	20	Chilton Elementary		Regular School	No	Elementary	PK	04	2018	kindergarten_4_year_old	51	51
113532	WI	Chippewa	school	5502550	1092	Public school	Chippewa Falls Area Unified	550255002784	100	Korger-Chestnut		Regular School	No	1.0	PK	PK	2015	kindergarten_4_year_old	365	365
283510	WI	Chippewa	school	5502550	1092	Public school	Chippewa Falls Area Unified	550255002784	100	Korger-Chestnut		Regular School	No	1.0	PK	PK	2016	kindergarten_4_year_old	363	363
327417	WI	Chippewa	school	5502550	1092	Public school	Chippewa Falls Area Unified	550255002784	100	Korger-Chestnut		Regular School	No	Elementary	PK	PK	2017	kindergarten_4_year_old	375	375
2319947	WI	Chippewa	school	5502550	1092	Public school	Chippewa Falls Area Unified	550255002784	100	Korger-Chestnut		Regular School	No	Prekindergarten	PK	PK	2020	kindergarten_4_year_old	350	350
2334732	WI	Chippewa	school	5502550	1092	Public school	Chippewa Falls Area Unified	550255002784	100	Korger-Chestnut		Regular School	No	Prekindergarten	PK	PK	2021	kindergarten_4_year_old	307	307
3075723	WI	Chippewa	school	5502550	1092	Public school	Chippewa Falls Area Unified	550255002784	100	Korger-Chestnut		Regular School	No	Prekindergarten	PK	PK	2019	kindergarten_4_year_old	356	356
3090473	WI	Chippewa	school	5502550	1092	Public school	Chippewa Falls Area Unified	550255002784	100	Korger-Chestnut		Regular School	No	Prekindergarten	PK	PK	2018	kindergarten_4_year_old	333	333
111894	WI	Eau Claire	school	5500270	112	Public school	Altoona	550027000028	80	Pedersen Elementary		Regular School	No	1.0	PK	03	2015	kindergarten_4_year_old	86	86
281866	WI	Eau Claire	school	5500270	112	Public school	Altoona	550027000028	80	Pedersen Elementary		Regular School	No	1.0	PK	03	2016	kindergarten_4_year_old	99	99
325756	WI	Eau Claire	school	5500270	112	Public school	Altoona	550027000028	80	Altoona Elementary		Regular School	No	Elementary	PK	03	2017	kindergarten_4_year_old	102	102
2318267	WI	Eau Claire	school	5500270	112	Public school	Altoona	550027000028	80	Altoona Elementary		Regular School	No	Elementary	PK	03	2020	kindergarten_4_year_old	105	105
2333063	WI	Eau Claire	school	5500270	112	Public school	Altoona	550027000028	80	Altoona Elementary		Regular School	No	Elementary	PK	03	2021	kindergarten_4_year_old	70	70
3074036	WI	Eau Claire	school	5500270	112	Public school	Altoona	550027000028	80	Altoona Elementary		Regular School	No	Elementary	PK	03	2019	kindergarten_4_year_old	70	70
3088795	WI	Eau Claire	school	5500270	112	Public school	Altoona	550027000028	80	Altoona Elementary		Regular School	No	Elementary	PK	03	2018	kindergarten_4_year_old	104	104
113561	WI	Polk	school	5502580	1120	Public school	Clayton	550258000289	20	Clayton Elementary		Regular School	No	1.0	PK	05	2015	kindergarten_4_year_old	21	21
283539	WI	Polk	school	5502580	1120	Public school	Clayton	550258000289	20	Clayton Elementary		Regular School	No	1.0	PK	05	2016	kindergarten_4_year_old	23	23
327446	WI	Polk	school	5502580	1120	Public school	Clayton	550258000289	20	Clayton Elementary		Regular School	No	Elementary	PK	05	2017	kindergarten_4_year_old	21	21
2319976	WI	Polk	school	5502580	1120	Public school	Clayton	550258000289	20	Clayton Elementary		Regular School	No	Elementary	PK	05	2020	kindergarten_4_year_old	19	19
2334761	WI	Polk	school	5502580	1120	Public school	Clayton	550258000289	20	Clayton Elementary		Regular School	No	Elementary	PK	05	2021	kindergarten_4_year_old	21	21
3075752	WI	Polk	school	5502580	1120	Public school	Clayton	550258000289	20	Clayton Elementary		Regular School	No	Elementary	PK	05	2019	kindergarten_4_year_old	24	24
3090502	WI	Polk	school	5502580	1120	Public school	Clayton	550258000289	20	Clayton Elementary		Regular School	No	Elementary	PK	05	2018	kindergarten_4_year_old	14	14
113588	WI	Polk	school	5502610	1127	Public school	Clear Lake	550261000291	20	Gaylord A Nelson Educ Center		Regular School	No	1.0	PK	06	2015	kindergarten_4_year_old	28	28
283566	WI	Polk	school	5502610	1127	Public school	Clear Lake	550261000291	20	Gaylord A Nelson Educ Center		Regular School	No	1.0	PK	06	2016	kindergarten_4_year_old	38	38
327473	WI	Polk	school	5502610	1127	Public school	Clear Lake	550261000291	20	Gaylord A Nelson Educational Center		Regular School	No	Elementary	PK	06	2017	kindergarten_4_year_old	34	34
2320002	WI	Polk	school	5502610	1127	Public school	Clear Lake	550261000291	20	Gaylord A Nelson Educational Center		Regular School	No	Elementary	PK	06	2020	kindergarten_4_year_old	45	45
2334787	WI	Polk	school	5502610	1127	Public school	Clear Lake	550261000291	20	Gaylord A Nelson Educational Center		Regular School	No	Elementary	PK	06	2021	kindergarten_4_year_old	37	37
3075779	WI	Polk	school	5502610	1127	Public school	Clear Lake	550261000291	20	Gaylord A Nelson Educational Center		Regular School	No	Elementary	PK	06	2019	kindergarten_4_year_old	42	42
3090529	WI	Polk	school	5502610	1127	Public school	Clear Lake	550261000291	20	Gaylord A Nelson Educational Center		Regular School	No	Elementary	PK	06	2018	kindergarten_4_year_old	39	39
113596	WI	Rock	school	5502640	1134	Public school	Clinton Community	550264000295	40	Clinton Elementary		Regular School	No	1.0	PK	04	2015	kindergarten_4_year_old	66	66
283574	WI	Rock	school	5502640	1134	Public school	Clinton Community	550264000295	40	Clinton Elementary		Regular School	No	1.0	PK	04	2016	kindergarten_4_year_old	57	57
327481	WI	Rock	school	5502640	1134	Public school	Clinton Community	550264000295	40	Clinton Elementary		Regular School	No	Elementary	PK	04	2017	kindergarten_4_year_old	49	49
2320010	WI	Rock	school	5502640	1134	Public school	Clinton Community	550264000295	40	Clinton Elementary		Regular School	No	Elementary	PK	04	2020	kindergarten_4_year_old	81	81
2334795	WI	Rock	school	5502640	1134	Public school	Clinton Community	550264000295	40	Clinton Elementary		Regular School	No	Elementary	PK	04	2021	kindergarten_4_year_old	63	63
3075787	WI	Rock	school	5502640	1134	Public school	Clinton Community	550264000295	40	Clinton Elementary		Regular School	No	Elementary	PK	04	2019	kindergarten_4_year_old	67	67
3090537	WI	Rock	school	5502640	1134	Public school	Clinton Community	550264000295	40	Clinton Elementary		Regular School	No	Elementary	PK	04	2018	kindergarten_4_year_old	53	53
113620	WI	Waupaca	school	5502670	1141	Public school	Clintonville	550267000303	60	Dellwood Early Learning Center		Regular School	No	1.0	PK	PK	2015	kindergarten_4_year_old	73	73
283598	WI	Waupaca	school	5502670	1141	Public school	Clintonville	550267000303	60	Dellwood Early Learning Center		Regular School	No	1.0	PK	PK	2016	kindergarten_4_year_old	81	81
327505	WI	Waupaca	school	5502670	1141	Public school	Clintonville	550267000303	60	Dellwood Early Learning Center		Regular School	No	Elementary	PK	PK	2017	kindergarten_4_year_old	69	69
2320034	WI	Waupaca	school	5502670	1141	Public school	Clintonville	550267000303	60	Dellwood Early Learning Center		Regular School	No	Prekindergarten	PK	PK	2020	kindergarten_4_year_old	80	80
2334823	WI	Waupaca	school	5502670	1141	Public school	Clintonville	550267000305	100	Longfellow Elementary		Regular School	No	Elementary	PK	04	2021	kindergarten_4_year_old	61	61
3075811	WI	Waupaca	school	5502670	1141	Public school	Clintonville	550267000303	60	Dellwood Early Learning Center		Regular School	No	Prekindergarten	PK	PK	2019	kindergarten_4_year_old	55	55
3090561	WI	Waupaca	school	5502670	1141	Public school	Clintonville	550267000303	60	Dellwood Early Learning Center		Regular School	No	Prekindergarten	PK	PK	2018	kindergarten_4_year_old	67	67
113635	WI	Buffalo	school	5502700	1155	Public school	Cochrane-Fountain City	550270000306	20	Cochrane-Fountain City Elementary		Regular School	No	1.0	PK	06	2015	kindergarten_4_year_old	40	40
283613	WI	Buffalo	school	5502700	1155	Public school	Cochrane-Fountain City	550270000306	20	Cochrane-Fountain City Elementary		Regular School	No	1.0	PK	06	2016	kindergarten_4_year_old	32	32
327520	WI	Buffalo	school	5502700	1155	Public school	Cochrane-Fountain City	550270000306	20	Cochrane-Fountain City Elementary		Regular School	No	Elementary	PK	06	2017	kindergarten_4_year_old	40	40
2320049	WI	Buffalo	school	5502700	1155	Public school	Cochrane-Fountain City	550270000306	20	Cochrane-Fountain City Elementary		Regular School	No	Elementary	PK	06	2020	kindergarten_4_year_old	42	42
2334834	WI	Buffalo	school	5502700	1155	Public school	Cochrane-Fountain City	550270000306	20	Cochrane-Fountain City Elementary		Regular School	No	Elementary	PK	06	2021	kindergarten_4_year_old	31	31
3075826	WI	Buffalo	school	5502700	1155	Public school	Cochrane-Fountain City	550270000306	20	Cochrane-Fountain City Elementary		Regular School	No	Elementary	PK	06	2019	kindergarten_4_year_old	38	38
3090576	WI	Buffalo	school	5502700	1155	Public school	Cochrane-Fountain City	550270000306	20	Cochrane-Fountain City Elementary		Regular School	No	Elementary	PK	06	2018	kindergarten_4_year_old	39	39
113662	WI	Clark	school	5502730	1162	Public school	Colby	550273000312	120	Little Stars Pre-School		Regular School	No	1.0	PK	PK	2015	kindergarten_4_year_old	44	44
283640	WI	Clark	school	5502730	1162	Public school	Colby	550273000312	120	Little Stars Pre-School		Regular School	No	1.0	PK	PK	2016	kindergarten_4_year_old	49	49