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 "state" = :p0 and "year" = :p1 and (total_int > :p3 or (total_int = :p3 and rowid > :p2)) order by total_int, 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	white	male	low_income	disability	total	white_int	male_int	total_int
3073917	WI	Clark	school		7	Public Schools-Multidistrict Charters	Abbotsford		9100	Rural Virtual Academy	charter						2019	grade_10					1			1
3073918	WI	Clark	school		7	Public Schools-Multidistrict Charters	Abbotsford		9100	Rural Virtual Academy	charter						2019	grade_11					1			1
3073919	WI	Clark	school		7	Public Schools-Multidistrict Charters	Abbotsford		9100	Rural Virtual Academy	charter						2019	grade_12					1			1
3073920	WI	Clark	school		7	Public Schools-Multidistrict Charters	Abbotsford		9100	Rural Virtual Academy	charter						2019	grade_7					1			1
3073944	WI	Adams	school	5500060	14	Public school	Adams-Friendship Area	550006000010	140	Grand Marsh Elementary		Regular School	No	Elementary	PK	04	2019	kindergarten_4_year_old					1			1
3074086	WI	Langlade	school	5500360	140	Public school	Antigo Unified	550036000038	80	Crestwood Elementary		Regular School	No	Elementary	PK	05	2019	pre_kindergarten					1			1
3074115	WI	Langlade	school		140	Public Schools-Multidistrict Charters	Antigo Unified		9100	Rural Virtual Academy	charter						2019	grade_2					1			1
3074121	WI	Langlade	school		140	Public Schools-Multidistrict Charters	Antigo Unified		9100	Rural Virtual Academy	charter						2019	grade_8					1			1
3074123	WI	Langlade	school		140	Public Schools-Multidistrict Charters	Antigo Unified		9100	Rural Virtual Academy	charter						2019	kindergarten_4_year_old					1			1
3074148	WI	Outagamie	school	5500390	147	Public school	Appleton Area	550039002679	800	Appleton Cooperative Educational Center		Alternative School	No	Other	04	12	2019	pk_12_total	1.0	1.0	*	*	1	1	1	1
3074149	WI	Outagamie	school	5500390	147	Public school	Appleton Area	550039002679	800	Appleton Cooperative Educational Center		Alternative School	No	Other	04	12	2019	grade_12					1			1
3074151	WI	Outagamie	school	5500390	147	Public school	Appleton Area	550039002549	440	Appleton eSchool	charter	Regular School	Yes	High	07	12	2019	grade_10					1			1
3074422	WI	Lafayette	school	5500450	161	Public school	Argyle	550045000069	20	Argyle Elementary		Regular School	No	Elementary	PK	05	2019	pre_kindergarten					1			1
3074538	WI	Wood	school		203	Public Schools-Multidistrict Charters	Auburndale		9100	Rural Virtual Academy	charter						2019	grade_7					1			1
3074539	WI	Wood	school		203	Public Schools-Multidistrict Charters	Auburndale		9100	Rural Virtual Academy	charter						2019	grade_8					1			1
3074549	WI	Eau Claire	school	5500630	217	Public school	Augusta	550063000092	20	Augusta Elementary		Regular School	No	Elementary	PK	05	2019	pre_kindergarten					1			1
3074653	WI	Iowa	school	5500840	287	Public school	Barneveld	550084000111	20	Barneveld Elementary		Regular School	No	Elementary	PK	05	2019	pre_kindergarten					1			1
3074666	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_2					1			1
3074667	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_4					1			1
3074668	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_5					1			1
3074669	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_6					1			1
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
3074691	WI	Barron	school		308	Public Schools-Multidistrict Charters	Barron Area		9410	North Star Academy	charter						2019	grade_11					1			1
3074839	WI	Lafayette	school	5501020	364	Public school	Belmont Community	550102000134	20	Belmont Elementary		Regular School	No	Elementary	PK	05	2019	pre_kindergarten					1			1
3074861	WI	Rock	school	5501050	413	Public school	Beloit	550105002974	421	Beloit Learning Academy		Alternative School	No	High	06	12	2019	grade_6					1			1
3074870	WI	Rock	school	5501050	413	Public school	Beloit	550105002799	850	Beloit Virtual School		Regular School	No	Other	PK	12	2019	grade_3					1			1
3074872	WI	Rock	school	5501050	413	Public school	Beloit	550105002799	850	Beloit Virtual School		Regular School	No	Other	PK	12	2019	grade_6					1			1
3074873	WI	Rock	school	5501050	413	Public school	Beloit	550105002799	850	Beloit Virtual School		Regular School	No	Other	PK	12	2019	grade_8					1			1
3074934	WI	Rock	school	5501050	413	Public school	Beloit	550105002705	410	Roy Chapman Andrews Academy	charter	Regular School	Yes	High	06	12	2019	grade_6					1			1
3074973	WI	Lafayette	school	5501110	427	Public school	Benton	550111000160	20	Benton Elementary		Regular School	No	Elementary	PK	06	2019	pre_kindergarten					1			1
3075005	WI	Walworth	school		6013	Public Schools-Multidistrict Charters	Big Foot UHS		9401	Walworth Co Educ Alt High	charter						2019	pk_12_total	1.0	1.0	*	*	1	1	1	1
3075006	WI	Walworth	school		6013	Public Schools-Multidistrict Charters	Big Foot UHS		9401	Walworth Co Educ Alt High	charter						2019	grade_12					1			1
3075008	WI	Washburn	school	5501170	441	Public school	Birchwood	550117002800	450	Birchwood Blue Hills Charter School	charter	Regular School	Yes	High	07	12	2019	grade_10					1			1
3075009	WI	Washburn	school	5501170	441	Public school	Birchwood	550117002800	450	Birchwood Blue Hills Charter School	charter	Regular School	Yes	High	07	12	2019	grade_11					1			1
3075012	WI	Washburn	school	5501170	441	Public school	Birchwood	550117002800	450	Birchwood Blue Hills Charter School	charter	Regular School	Yes	High	07	12	2019	grade_8					1			1
3075036	WI	Washburn	school	5501170	441	Public school	Birchwood	550117002937	130	Birchwood Public Montessori	charter	Regular School	Yes	Elementary	PK	06	2019	grade_5					1			1
3075041	WI	Washburn	school	5501170	441	Public school	Birchwood	550117003020	800	Bobcat Virtual Academy	charter	Regular School	Yes	Other	PK	12	2019	grade_10					1			1
3075045	WI	Washburn	school	5501170	441	Public school	Birchwood	550117003020	800	Bobcat Virtual Academy	charter	Regular School	Yes	Other	PK	12	2019	grade_6					1			1
3075046	WI	Washburn	school	5501170	441	Public school	Birchwood	550117003020	800	Bobcat Virtual Academy	charter	Regular School	Yes	Other	PK	12	2019	grade_7					1			1
3075174	WI	Shawano	school		623	Public Schools-Multidistrict Charters	Bowler		9100	Rural Virtual Academy	charter						2019	grade_12					1			1
3075175	WI	Shawano	school		623	Public Schools-Multidistrict Charters	Bowler		9100	Rural Virtual Academy	charter						2019	grade_2					1			1
3075176	WI	Shawano	school		623	Public Schools-Multidistrict Charters	Bowler		9100	Rural Virtual Academy	charter						2019	grade_5					1			1
3075178	WI	Shawano	school		623	Public Schools-Multidistrict Charters	Bowler		9100	Rural Virtual Academy	charter						2019	grade_7					1			1
3075326	WI	Racine	school		777	Public Schools-Multidistrict Charters	Burlington Area		9803	JEDI Virtual K-12	charter						2019	grade_4					1			1
3075327	WI	Racine	school		777	Public Schools-Multidistrict Charters	Burlington Area		9803	JEDI Virtual K-12	charter						2019	grade_7					1			1
3075328	WI	Racine	school		777	Public Schools-Multidistrict Charters	Burlington Area		9803	JEDI Virtual K-12	charter						2019	grade_8					1			1
3075329	WI	Racine	school		777	Public Schools-Multidistrict Charters	Burlington Area		9803	JEDI Virtual K-12	charter						2019	grade_9					1			1
3075335	WI	Racine	school	5501890	777	Public school	Burlington Area	550189000635	120	Lyons Center		Regular School	No	Elementary	PK	04	2019	pre_kindergarten					1			1
3075354	WI	Racine	school	5501890	777	Public school	Burlington Area	550189000244	160	Winkler Elementary		Regular School	No	Elementary	PK	04	2019	pre_kindergarten					1			1
3075373	WI	Ashland	school	5501920	840	Public school	Butternut	550192002751	450	Promethean Charter School	charter	Regular School	Yes	High	09	12	2019	grade_10					1			1
3075374	WI	Ashland	school	5501920	840	Public school	Butternut	550192002751	450	Promethean Charter School	charter	Regular School	Yes	High	09	12	2019	grade_11					1			1
3075466	WI	Barron	school	5502130	903	Public school	Cameron	550213002500	9410	North Star Academy	charter	Alternative School	Yes	High	09	12	2019	grade_11					1			1
3075476	WI	Fond du Lac	school	5502160	910	Public school	Campbellsport	550216000258	20	Campbellsport Elementary		Regular School	No	Elementary	PK	05	2019	pre_kindergarten					1			1
3075532	WI	Grant	school	5502400	994	Public school	Cassville	550240000264	20	Cassville Elementary		Regular School	No	Elementary	PK	06	2019	pre_kindergarten					1			1
3075668	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_9					1			1
3075672	WI	Barron	school		1080	Public Schools-Multidistrict Charters	Chetek-Weyerhaeuser Area		9410	North Star Academy	charter						2019	grade_11					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
3075858	WI	Clark	school		1162	Public Schools-Multidistrict Charters	Colby		9100	Rural Virtual Academy	charter						2019	grade_9					1			1
3075943	WI	Forest	school	5502910	1218	Public school	Crandon	550291000326	40	Crandon Elementary		Regular School	No	Elementary	PK	05	2019	pre_kindergarten					1			1
3076067	WI	Barron	school	5503090	1260	Public school	Cumberland	550309002871	800	Island City Virtual Academy	charter	Regular School	Yes	Other	PK	12	2019	grade_1					1			1
3076069	WI	Barron	school	5503090	1260	Public school	Cumberland	550309002871	800	Island City Virtual Academy	charter	Regular School	Yes	Other	PK	12	2019	grade_11					1			1
3076073	WI	Barron	school	5503090	1260	Public school	Cumberland	550309002871	800	Island City Virtual Academy	charter	Regular School	Yes	Other	PK	12	2019	grade_4					1			1
3076074	WI	Barron	school	5503090	1260	Public school	Cumberland	550309002871	800	Island City Virtual Academy	charter	Regular School	Yes	Other	PK	12	2019	grade_5					1			1
3076076	WI	Barron	school	5503090	1260	Public school	Cumberland	550309002871	800	Island City Virtual Academy	charter	Regular School	Yes	Other	PK	12	2019	grade_7					1			1
3076077	WI	Barron	school	5503090	1260	Public school	Cumberland	550309002871	800	Island City Virtual Academy	charter	Regular School	Yes	Other	PK	12	2019	grade_8					1			1
3076078	WI	Barron	school	5503090	1260	Public school	Cumberland	550309002871	800	Island City Virtual Academy	charter	Regular School	Yes	Other	PK	12	2019	grade_9					1			1
3076079	WI	Barron	school	5503090	1260	Public school	Cumberland	550309002871	800	Island City Virtual Academy	charter	Regular School	Yes	Other	PK	12	2019	kindergarten_4_year_old					1			1
3076116	WI	Marathon	school	5513170	4970	Public school	D C Everest Area	551317001738	60	Hatley Elementary		Regular School	No	Elementary	PK	05	2019	pre_kindergarten					1			1
3076259	WI	Vernon	school	5503240	1421	Public school	De Soto Area	550324003022	810	De Soto Virtual School	charter	Regular School	Yes	Other	KG	12	2019	grade_10					1			1
3076261	WI	Vernon	school	5503240	1421	Public school	De Soto Area	550324003022	810	De Soto Virtual School	charter	Regular School	Yes	Other	KG	12	2019	grade_12					1			1
3076262	WI	Vernon	school	5503240	1421	Public school	De Soto Area	550324003022	810	De Soto Virtual School	charter	Regular School	Yes	Other	KG	12	2019	grade_9					1			1
3076263	WI	Vernon	school	5503240	1421	Public school	De Soto Area	550324003022	810	De Soto Virtual School	charter	Regular School	Yes	Other	KG	12	2019	kindergarten					1			1
3076298	WI	Dane	school	5503270	1309	Public school	Deerfield Community	550327000372	60	Deerfield Middle		Regular School	No	Middle	07	08	2019	grade_9					1			1
3076421	WI	Bayfield	school	5503810	1491	Public school	Drummond Area	550381000398	20	Drummond Elementary		Regular School	No	Elementary	PK	06	2019	pre_kindergarten					1			1
3076587	WI	Eau Claire	school	5504050	1554	Public school	Eau Claire Area	550405002658	800	Second Avenue School		Alternative School	No	Other	04	12	2019	grade_9					1			1
3076705	WI	Sheboygan	school	5504260	1631	Public school	Elkhart Lake-Glenbeulah	550426000455	20	Elkhart Lake Elementary/Middle		Regular School	No	Elementary	PK	08	2019	pre_kindergarten					1			1
3076754	WI	Walworth	school	5504290	1638	Public school	Elkhorn Area	550429002520	9401	Walworth Co Educ Alt High	charter	Regular School	Yes	High	09	12	2019	grade_10					1			1
3076820	WI	Waukesha	school	5501770	714	Public school	Elmbrook	550177000221	160	Fairview South		Special Education School	No	High	05	12	2019	grade_6					1			1
3076872	WI	Washington	school	5504410	1687	Public school	Erin	550441000476	20	Erin Elementary		Regular School	No	Elementary	PK	08	2019	pre_kindergarten					1			1
3076889	WI	Rock	school		1694	Public Schools-Multidistrict Charters	Evansville Community		9803	JEDI Virtual K-12	charter						2019	grade_6					1			1
3077090	WI	Fond du Lac	school	5504680	1862	Public school	Fond du Lac	550468000506	360	Waters Elementary		Regular School	No	Elementary	PK	05	2019	pre_kindergarten					1			1
3077187	WI	Milwaukee	school	5504830	1900	Public school	Franklin Public	550483002685	400	Milwaukee County Correctional Facility South		Alternative School	No	High	09	12	2019	grade_10					1			1
3077302	WI	Walworth	school	5505130	2051	Public school	Genoa City J2	550513000547	20	Brookwood Elementary		Regular School	No	Elementary	PK	03	2019	pre_kindergarten					1			1
3077483	WI	Ozaukee	school	5505610	2217	Public school	Grafton	550561002247	30	Kennedy Elementary		Regular School	No	Elementary	PK	05	2019	pre_kindergarten					1			1
3077501	WI	Clark	school	5505640	2226	Public school	Granton Area	550564000599	20	Granton Elementary		Regular School	No	Elementary	PK	05	2019	pre_kindergarten					1			1
3077536	WI	Burnett	school	5505670	2233	Public school	Grantsburg	550567000604	120	Nelson Elementary		Regular School	No	Elementary	PK	KG	2019	pre_kindergarten					1			1
3077558	WI	Brown	school	5505820	2289	Public school	Green Bay Area Public	550582000612	40	Bay View		Alternative School	No	Other	PK	12	2019	grade_11					1			1
3077578	WI	Brown	school	5505820	2289	Public school	Green Bay Area Public	550582000614	100	Chappell Elementary		Regular School	No	Elementary	PK	05	2019	pre_kindergarten					1			1
3077645	WI	Brown	school	5505820	2289	Public school	Green Bay Area Public	550582000623	300	Franklin Middle		Regular School	No	Middle	06	08	2019	grade_9					1			1
3077677	WI	Brown	school	5505820	2289	Public school	Green Bay Area Public	550582000626	360	Jefferson Elementary		Regular School	No	Elementary	PK	05	2019	pre_kindergarten					1			1
3077683	WI	Brown	school	5505820	2289	Public school	Green Bay Area Public	550582002857	445	John Dewey Academy of Learning	charter	Regular School	Yes	High	06	12	2019	grade_7					1			1
3077752	WI	Brown	school	5505820	2289	Public school	Green Bay Area Public	550582000632	430	MacArthur Elementary		Regular School	No	Elementary	PK	05	2019	pre_kindergarten					1			1
3077806	WI	Brown	school	5505820	2289	Public school	Green Bay Area Public	550582000639	590	Sullivan Elementary		Regular School	No	Elementary	PK	05	2019	pre_kindergarten					1			1
3077847	WI	Brown	school	5505820	2289	Public school	Green Bay Area Public	550582002406	730	Wilder Elementary		Regular School	No	Elementary	PK	05	2019	pre_kindergarten					1			1
3077857	WI	Green Lake	school	5505880	2310	Public school	Green Lake	550588000646	20	Green Lake Elementary		Regular School	No	Elementary	PK	06	2019	pre_kindergarten					1			1
3077914	WI	Milwaukee	school	5505940	2303	Public school	Greenfield	550594000651	80	Elm Dale Elementary		Regular School	No	Elementary	PK	05	2019	pre_kindergarten					1			1
3078130	WI	Iowa	school	5506420	2527	Public school	Highland	550642000698	20	Highland Community Elementary	charter	Regular School	Yes	Elementary	PK	05	2019	pre_kindergarten					1			1
3078317	WI	Brown	school	5506630	2604	Public school	Howard-Suamico	550663000719	60	Howard Elementary		Regular School	No	Elementary	PK	04	2019	grade_5					1			1
3078535	WI	Rock	school	5507020	2695	Public school	Janesville	550702002991	860	ARISE Virtual Academy	charter	Regular School	Yes	Other	KG	12	2019	grade_4					1			1
3078676	WI	Rock	school	5507020	2695	Public school	Janesville	550702002948	850	Youth Services Center		Alternative School	No	Other	04	12	2019	grade_7					1			1
3078689	WI	Jefferson	school		2702	Public Schools-Multidistrict Charters	Jefferson		9803	JEDI Virtual K-12	charter						2019	grade_6					1			1