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
113374	WI	Ozaukee	school	5502460	1015	Public school	Cedarburg	550246000270	20	Cedarburg High		Regular School	No	3.0	09	12	2015	grade_10	290	290
283356	WI	Ozaukee	school	5502460	1015	Public school	Cedarburg	550246000270	20	Cedarburg High		Regular School	No	3.0	09	12	2016	grade_10	280	280
327252	WI	Ozaukee	school	5502460	1015	Public school	Cedarburg	550246000270	20	Cedarburg High		Regular School	No	High	09	12	2017	grade_10	278	278
2319780	WI	Ozaukee	school	5502460	1015	Public school	Cedarburg	550246000270	20	Cedarburg High		Regular School	No	High	09	12	2020	grade_10	294	294
2334562	WI	Ozaukee	school	5502460	1015	Public school	Cedarburg	550246000270	20	Cedarburg High		Regular School	No	High	09	12	2021	grade_10	273	273
3075559	WI	Ozaukee	school	5502460	1015	Public school	Cedarburg	550246000270	20	Cedarburg High		Regular School	No	High	09	12	2019	grade_10	256	256
3090309	WI	Ozaukee	school	5502460	1015	Public school	Cedarburg	550246000270	20	Cedarburg High		Regular School	No	High	09	12	2018	grade_10	275	275
113364	WI	Sheboygan	school	5502430	1029	Public school	Cedar Grove-Belgium Area	550243000267	40	Cedar Grove-Belgium High		Regular School	No	3.0	09	12	2015	grade_10	97	97
283346	WI	Sheboygan	school	5502430	1029	Public school	Cedar Grove-Belgium Area	550243000267	40	Cedar Grove-Belgium High		Regular School	No	3.0	09	12	2016	grade_10	92	92
327242	WI	Sheboygan	school	5502430	1029	Public school	Cedar Grove-Belgium Area	550243000267	40	Cedar Grove-Belgium High		Regular School	No	High	09	12	2017	grade_10	88	88
2319770	WI	Sheboygan	school	5502430	1029	Public school	Cedar Grove-Belgium Area	550243000267	40	Cedar Grove-Belgium High		Regular School	No	High	09	12	2020	grade_10	72	72
2334552	WI	Sheboygan	school	5502430	1029	Public school	Cedar Grove-Belgium Area	550243000267	40	Cedar Grove-Belgium High		Regular School	No	High	09	12	2021	grade_10	76	76
3075549	WI	Sheboygan	school	5502430	1029	Public school	Cedar Grove-Belgium Area	550243000267	40	Cedar Grove-Belgium High		Regular School	No	High	09	12	2019	grade_10	77	77
3090299	WI	Sheboygan	school	5502430	1029	Public school	Cedar Grove-Belgium Area	550243000267	40	Cedar Grove-Belgium High		Regular School	No	High	09	12	2018	grade_10	76	76
111868	WI	Portage	school	5500240	105	Public school	Almond-Bancroft	550024000024	40	Almond High		Regular School	No	4.0	06	12	2015	grade_10	25	25
281840	WI	Portage	school	5500240	105	Public school	Almond-Bancroft	550024000024	40	Almond High		Regular School	No	4.0	06	12	2016	grade_10	30	30
325741	WI	Portage	school	5500240	105	Public school	Almond-Bancroft	550024000024	40	Almond High		Regular School	No	Other	06	12	2017	grade_10	36	36
2318255	WI	Portage	school	5500240	105	Public school	Almond-Bancroft	550024000024	40	Almond-Bancroft High		Regular School	No	High	09	12	2020	grade_10	39	39
2333051	WI	Portage	school	5500240	105	Public school	Almond-Bancroft	550024000024	40	Almond-Bancroft High		Regular School	No	High	09	12	2021	grade_10	27	27
3074024	WI	Portage	school	5500240	105	Public school	Almond-Bancroft	550024000024	40	Almond-Bancroft High		Regular School	No	High	09	12	2019	grade_10	18	18
3088783	WI	Portage	school	5500240	105	Public school	Almond-Bancroft	550024000024	40	Almond-Bancroft High		Regular School	No	High	09	12	2018	grade_10	38	38
113422	WI	Price	school	5500058	1071	Public school	Chequamegon	550005802763	400	Chequamegon High		Regular School	No	3.0	09	12	2015	grade_10	62	62
113431	WI	Price	school	5500058	1071	Public school	Chequamegon	550005802780	450	Class ACT Charter	charter	Vocational Education School	Yes	3.0	09	12	2015	grade_10	1	1
283404	WI	Price	school	5500058	1071	Public school	Chequamegon	550005802763	400	Chequamegon High		Regular School	No	3.0	09	12	2016	grade_10	61	61
327303	WI	Price	school	5500058	1071	Public school	Chequamegon	550005802763	400	Chequamegon High		Regular School	No	High	09	12	2017	grade_10	41	41
327312	WI	Price	school	5500058	1071	Public school	Chequamegon	550005802780	450	Class ACT Charter	charter	Career and Technical School	Yes	High	09	12	2017	grade_10	2	2
2319834	WI	Price	school	5500058	1071	Public school	Chequamegon	550005802763	400	Chequamegon High		Regular School	No	High	09	12	2020	grade_10	52	52
2319843	WI	Price	school	5500058	1071	Public school	Chequamegon	550005802780	450	Class ACT Charter	charter	Career and Technical School	Yes	High	09	12	2020	grade_10	8	8
2334616	WI	Price	school	5500058	1071	Public school	Chequamegon	550005802763	400	Chequamegon High		Regular School	No	High	09	12	2021	grade_10	53	53
2334625	WI	Price	school	5500058	1071	Public school	Chequamegon	550005802780	450	Class ACT Charter	charter	Career and Technical School	Yes	High	09	12	2021	grade_10	4	4
3075610	WI	Price	school	5500058	1071	Public school	Chequamegon	550005802763	400	Chequamegon High		Regular School	No	High	09	12	2019	grade_10	58	58
3075619	WI	Price	school	5500058	1071	Public school	Chequamegon	550005802780	450	Class ACT Charter	charter	Career and Technical School	Yes	High	09	12	2019	grade_10	6	6
3090361	WI	Price	school	5500058	1071	Public school	Chequamegon	550005802763	400	Chequamegon High		Regular School	No	High	09	12	2018	grade_10	75	75
3090370	WI	Price	school	5500058	1071	Public school	Chequamegon	550005802780	450	Class ACT Charter	charter	Career and Technical School	Yes	High	09	12	2018	grade_10	4	4
113448	WI	Barron	school	5500061	1080	Public school	Chetek-Weyerhaeuser Area	550006102807	400	Chetek-Weyerhaeuser High		Regular School	No	3.0	09	12	2015	grade_10	60	60
113467	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_10	1	1
283427	WI	Barron	school	5500061	1080	Public school	Chetek-Weyerhaeuser Area	550006102807	400	Chetek-Weyerhaeuser High		Regular School	No	3.0	09	12	2016	grade_10	74	74
283446	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_10	7	7
327332	WI	Barron	school	5500061	1080	Public school	Chetek-Weyerhaeuser Area	550006102807	400	Chetek-Weyerhaeuser High		Regular School	No	High	09	12	2017	grade_10	58	58
327351	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_10	2	2
327365	WI	Barron	school		1080	Public Schools-Multidistrict Charters	Chetek-Weyerhaeuser Area		9410	North Star Academy	charter						2017	grade_10	1	1
2319863	WI	Barron	school	5500061	1080	Public school	Chetek-Weyerhaeuser Area	550006102807	400	Chetek-Weyerhaeuser High		Regular School	No	High	09	12	2020	grade_10	62	62
2319882	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_10	2	2
2334649	WI	Barron	school	5500061	1080	Public school	Chetek-Weyerhaeuser Area	550006102807	400	Chetek-Weyerhaeuser High		Regular School	No	High	09	12	2021	grade_10	63	63
2334668	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_10	1	1
2334681	WI	Barron	school		1080	Public Schools-Multidistrict Charters	Chetek-Weyerhaeuser Area		9410	North Star Academy	charter						2021	grade_10	1	1
3075639	WI	Barron	school	5500061	1080	Public school	Chetek-Weyerhaeuser Area	550006102807	400	Chetek-Weyerhaeuser High		Regular School	No	High	09	12	2019	grade_10	67	67
3075658	WI	Barron	school	5500061	1080	Public school	Chetek-Weyerhaeuser Area	550006102897	800	Link2Learn Virtual Charter School	charter	Regular School	Yes	Other	PK	12	2019	grade_10	2	2
3090390	WI	Barron	school	5500061	1080	Public school	Chetek-Weyerhaeuser Area	550006102807	400	Chetek-Weyerhaeuser High		Regular School	No	High	09	12	2018	grade_10	51	51
3090409	WI	Barron	school	5500061	1080	Public school	Chetek-Weyerhaeuser Area	550006102897	800	Link2Learn Virtual Charter School	charter	Regular School	Yes	Other	PK	12	2018	grade_10	3	3
113492	WI	Calumet	school	5502520	1085	Public school	Chilton	550252000279	40	Chilton High		Regular School	No	3.0	09	12	2015	grade_10	77	77
283470	WI	Calumet	school	5502520	1085	Public school	Chilton	550252000279	40	Chilton High		Regular School	No	3.0	09	12	2016	grade_10	101	101
327377	WI	Calumet	school	5502520	1085	Public school	Chilton	550252000279	40	Chilton High		Regular School	No	High	09	12	2017	grade_10	104	104
2319907	WI	Calumet	school	5502520	1085	Public school	Chilton	550252000279	40	Chilton High		Regular School	No	High	09	12	2020	grade_10	91	91
2334692	WI	Calumet	school	5502520	1085	Public school	Chilton	550252000279	40	Chilton High		Regular School	No	High	09	12	2021	grade_10	97	97
3075683	WI	Calumet	school	5502520	1085	Public school	Chilton	550252000279	40	Chilton High		Regular School	No	High	09	12	2019	grade_10	90	90
3090433	WI	Calumet	school	5502520	1085	Public school	Chilton	550252000279	40	Chilton High		Regular School	No	High	09	12	2018	grade_10	95	95
113502	WI	Chippewa	school	5502550	1092	Public school	Chippewa Falls Area Unified	550255000282	60	Chippewa Falls High		Regular School	No	3.0	09	12	2015	grade_10	383	383
283480	WI	Chippewa	school	5502550	1092	Public school	Chippewa Falls Area Unified	550255000282	60	Chippewa Falls High		Regular School	No	3.0	09	12	2016	grade_10	353	353
327387	WI	Chippewa	school	5502550	1092	Public school	Chippewa Falls Area Unified	550255000282	60	Chippewa Falls High		Regular School	No	High	09	12	2017	grade_10	408	408
2319917	WI	Chippewa	school	5502550	1092	Public school	Chippewa Falls Area Unified	550255000282	60	Chippewa Falls High		Regular School	No	High	09	12	2020	grade_10	374	374
2334702	WI	Chippewa	school	5502550	1092	Public school	Chippewa Falls Area Unified	550255000282	60	Chippewa Falls High		Regular School	No	High	09	12	2021	grade_10	366	366
3075693	WI	Chippewa	school	5502550	1092	Public school	Chippewa Falls Area Unified	550255000282	60	Chippewa Falls High		Regular School	No	High	09	12	2019	grade_10	351	351
3090443	WI	Chippewa	school	5502550	1092	Public school	Chippewa Falls Area Unified	550255000282	60	Chippewa Falls High		Regular School	No	High	09	12	2018	grade_10	356	356
111879	WI	Eau Claire	school	5500270	112	Public school	Altoona	550027000026	40	Altoona High		Regular School	No	3.0	09	12	2015	grade_10	119	119
281851	WI	Eau Claire	school	5500270	112	Public school	Altoona	550027000026	40	Altoona High		Regular School	No	3.0	09	12	2016	grade_10	106	106
325760	WI	Eau Claire	school	5500270	112	Public school	Altoona	550027000026	40	Altoona High		Regular School	No	High	09	12	2017	grade_10	106	106
2318271	WI	Eau Claire	school	5500270	112	Public school	Altoona	550027000026	40	Altoona High		Regular School	No	High	09	12	2020	grade_10	119	119
2333067	WI	Eau Claire	school	5500270	112	Public school	Altoona	550027000026	40	Altoona High		Regular School	No	High	09	12	2021	grade_10	132	132
3074040	WI	Eau Claire	school	5500270	112	Public school	Altoona	550027000026	40	Altoona High		Regular School	No	High	09	12	2019	grade_10	108	108
3088799	WI	Eau Claire	school	5500270	112	Public school	Altoona	550027000026	40	Altoona High		Regular School	No	High	09	12	2018	grade_10	108	108
113565	WI	Polk	school	5502580	1120	Public school	Clayton	550258000290	40	Clayton High		Regular School	No	3.0	09	12	2015	grade_10	30	30
283543	WI	Polk	school	5502580	1120	Public school	Clayton	550258000290	40	Clayton High		Regular School	No	3.0	09	12	2016	grade_10	34	34
327450	WI	Polk	school	5502580	1120	Public school	Clayton	550258000290	40	Clayton High		Regular School	No	High	09	12	2017	grade_10	30	30
2319979	WI	Polk	school	5502580	1120	Public school	Clayton	550258000290	40	Clayton High		Regular School	No	High	09	12	2020	grade_10	28	28
2334764	WI	Polk	school	5502580	1120	Public school	Clayton	550258000290	40	Clayton High		Regular School	No	High	09	12	2021	grade_10	23	23
3075756	WI	Polk	school	5502580	1120	Public school	Clayton	550258000290	40	Clayton High		Regular School	No	High	09	12	2019	grade_10	23	23
3090506	WI	Polk	school	5502580	1120	Public school	Clayton	550258000290	40	Clayton High		Regular School	No	High	09	12	2018	grade_10	24	24
113574	WI	Polk	school	5502610	1127	Public school	Clear Lake	550261000292	40	Clear Lake High		Regular School	No	3.0	09	12	2015	grade_10	38	38
283552	WI	Polk	school	5502610	1127	Public school	Clear Lake	550261000292	40	Clear Lake High		Regular School	No	3.0	09	12	2016	grade_10	56	56
327459	WI	Polk	school	5502610	1127	Public school	Clear Lake	550261000292	40	Clear Lake High		Regular School	No	High	09	12	2017	grade_10	42	42
2319988	WI	Polk	school	5502610	1127	Public school	Clear Lake	550261000292	40	Clear Lake High		Regular School	No	High	09	12	2020	grade_10	48	48
2334773	WI	Polk	school	5502610	1127	Public school	Clear Lake	550261000292	40	Clear Lake High		Regular School	No	High	09	12	2021	grade_10	34	34
3075765	WI	Polk	school	5502610	1127	Public school	Clear Lake	550261000292	40	Clear Lake High		Regular School	No	High	09	12	2019	grade_10	39	39
3090515	WI	Polk	school	5502610	1127	Public school	Clear Lake	550261000292	40	Clear Lake High		Regular School	No	High	09	12	2018	grade_10	50	50
113600	WI	Rock	school	5502640	1134	Public school	Clinton Community	550264000296	60	Clinton High		Regular School	No	3.0	09	12	2015	grade_10	97	97
283578	WI	Rock	school	5502640	1134	Public school	Clinton Community	550264000296	60	Clinton High		Regular School	No	3.0	09	12	2016	grade_10	89	89
327485	WI	Rock	school	5502640	1134	Public school	Clinton Community	550264000296	60	Clinton High		Regular School	No	High	09	12	2017	grade_10	93	93
2320014	WI	Rock	school	5502640	1134	Public school	Clinton Community	550264000296	60	Clinton High		Regular School	No	High	09	12	2020	grade_10	109	109
2334799	WI	Rock	school	5502640	1134	Public school	Clinton Community	550264000296	60	Clinton High		Regular School	No	High	09	12	2021	grade_10	95	95
3075791	WI	Rock	school	5502640	1134	Public school	Clinton Community	550264000296	60	Clinton High		Regular School	No	High	09	12	2019	grade_10	84	84
3090541	WI	Rock	school	5502640	1134	Public school	Clinton Community	550264000296	60	Clinton High		Regular School	No	High	09	12	2018	grade_10	81	81
113610	WI	Waupaca	school	5502670	1141	Public school	Clintonville	550267000302	40	Clintonville High		Regular School	No	3.0	09	12	2015	grade_10	116	116
283588	WI	Waupaca	school	5502670	1141	Public school	Clintonville	550267000302	40	Clintonville High		Regular School	No	3.0	09	12	2016	grade_10	132	132
327495	WI	Waupaca	school	5502670	1141	Public school	Clintonville	550267000302	40	Clintonville High		Regular School	No	High	09	12	2017	grade_10	129	129
2320024	WI	Waupaca	school	5502670	1141	Public school	Clintonville	550267000302	40	Clintonville High		Regular School	No	High	09	12	2020	grade_10	107	107
2334809	WI	Waupaca	school	5502670	1141	Public school	Clintonville	550267000302	40	Clintonville High		Regular School	No	High	09	12	2021	grade_10	103	103
3075801	WI	Waupaca	school	5502670	1141	Public school	Clintonville	550267000302	40	Clintonville High		Regular School	No	High	09	12	2019	grade_10	108	108
3090551	WI	Waupaca	school	5502670	1141	Public school	Clintonville	550267000302	40	Clintonville High		Regular School	No	High	09	12	2018	grade_10	119	119
113639	WI	Buffalo	school	5502700	1155	Public school	Cochrane-Fountain City	550270000307	40	Cochrane-Fountain City High		Regular School	No	3.0	07	12	2015	grade_10	50	50
283617	WI	Buffalo	school	5502700	1155	Public school	Cochrane-Fountain City	550270000307	40	Cochrane-Fountain City High		Regular School	No	3.0	07	12	2016	grade_10	55	55