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 "year" = :p2 order by total 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
2335684	WI	Rock	school		1568	Public Schools-Multidistrict Charters	Edgerton		9803	JEDI Virtual K-12	charter						2021	kindergarten_4_year_old	1	1
2337345	WI	Outagamie	school	5506600	2583	Public school	Hortonville Area	550660002407	10	Greenville Elementary		Regular School	No	Elementary	PK	04	2021	kindergarten_4_year_old	1	1
2338304	WI	Washington	school	5507380	2800	Public school	Kewaskum	550738000839	100	i4Learning Community School		Regular School	No	Elementary	PK	05	2021	kindergarten_4_year_old	1	1
2341795	WI	Marquette	school	5509870	3689	Public school	Montello	550987003016	800	Montello Virtual Charter School	charter	Regular School	Yes	Other	PK	12	2021	kindergarten_4_year_old	1	1
2342085	WI	Clark	school	5510350	3899	Public school	Neillsville	551035001356	20	Neillsville Elementary		Regular School	No	Elementary	PK	05	2021	kindergarten_4_year_old	1	1
2343123	WI	Clark	school		4207	Public Schools-Multidistrict Charters	Owen-Withee		9100	Rural Virtual Academy	charter						2021	kindergarten_4_year_old	1	1
2343318	WI	Price	school		4347	Public Schools-Multidistrict Charters	Phillips		9100	Rural Virtual Academy							2021	kindergarten_4_year_old	1	1
2344103	WI	Oneida	school		4781	Public Schools-Multidistrict Charters	Rhinelander		9100	Rural Virtual Academy	charter						2021	kindergarten_4_year_old	1	1
2346289	WI	Door	school	5515570	6069	Public school	Washington	551557001986	20	Washington Island Elementary		Regular School	No	Elementary	PK	08	2021	kindergarten_4_year_old	1	1
2347453	WI	Langlade	school		6440	Public Schools-Multidistrict Charters	White Lake		9100	Rural Virtual Academy	charter						2021	kindergarten_4_year_old	1	1
2335101	WI	Barron	school	5503090	1260	Public school	Cumberland	550309002871	800	Island City Virtual Academy	charter	Regular School	Yes	Other	PK	12	2021	kindergarten_4_year_old	10	10
2336172	WI	Walworth	school	5504720	1870	Public school	Fontana J8	550472000508	20	Fontana Elementary		Regular School	No	Elementary	PK	08	2021	kindergarten_4_year_old	10	10
2337999	WI	Kenosha	school	5507320	2793	Public school	Kenosha	550732000808	180	Grant Elementary		Regular School	No	Elementary	PK	05	2021	kindergarten_4_year_old	10	10
2338045	WI	Kenosha	school	5507320	2793	Public school	Kenosha	550732000813	300	Jefferson Elementary		Regular School	No	Elementary	PK	05	2021	kindergarten_4_year_old	10	10
2340498	WI	Milwaukee	school	5509600	3619	Public school	Milwaukee	550960002870	820	Daniels University Preparatory Academy	charter	Regular School	Yes	Elementary	PK	08	2021	kindergarten_4_year_old	10	10
2342307	WI	Waupaca	school	5510590	3955	Public school	New London	551059001387	120	Sugar Bush Elementary		Regular School	No	Elementary	PK	04	2021	kindergarten_4_year_old	10	10
2342523	WI	Vilas	school	5503860	1526	Public school	Northland Pines	550386000408	100	Northland Pines Elementary-St Germain		Regular School	No	Elementary	PK	04	2021	kindergarten_4_year_old	10	10
2343655	WI	Green Lake	school	5512300	4606	Public school	Princeton	551230001595	40	Princeton School		Regular School	No	Other	PK	12	2021	kindergarten_4_year_old	10	10
2344602	WI	Crawford	school	5513470	5124	Public school	Seneca Area	551347001764	60	Seneca Elementary		Regular School	No	Elementary	PK	05	2021	kindergarten_4_year_old	10	10
2344687	WI	Shawano	school	5513620	5264	Public school	Shawano	551362002908	110	LEADS Primary Charter School	charter	Regular School	Yes	Elementary	PK	02	2021	kindergarten_4_year_old	10	10
2345690	WI	Douglas	school	5514670	5663	Public school	Superior	551467002348	120	Lake Superior Elementary		Regular School	No	Elementary	PK	05	2021	kindergarten_4_year_old	10	10
2347372	WI	Marquette	school	5516440	6335	Public school	Westfield	551644002149	60	Oxford Elementary		Regular School	No	Elementary	PK	06	2021	kindergarten_4_year_old	10	10
2347551	WI	Walworth	school	5516680	6461	Public school	Whitewater Unified	551668002834	100	Whitewater 4K		Regular School	No	Prekindergarten	PK	PK	2021	kindergarten_4_year_old	10	10
2347638	WI	Winnebago	school	5516830	6608	Public school	Winneconne Community	551683002190	40	Winneconne Elementary		Regular School	No	Elementary	PK	05	2021	kindergarten_4_year_old	101	101
2338508	WI	La Crosse	school	5507530	2849	Public school	La Crosse	550753002467	114	La Crosse Offsite Preschool		Regular School	No	Prekindergarten	PK	PK	2021	kindergarten_4_year_old	102	102
2347296	WI	Brown	school	5516320	6328	Public school	West De Pere	551632002139	140	Westwood Elementary		Regular School	No	Elementary	PK	05	2021	kindergarten_4_year_old	102	102
2339669	WI	Dane	school	5508910	3381	Public school	McFarland	550891002902	150	4K McFarland		Regular School	No	Prekindergarten	PK	PK	2021	kindergarten_4_year_old	104	104
2346707	WI	Fond du Lac	school	5515870	6216	Public school	Waupun	551587002044	160	Meadow View Primary		Regular School	No	Elementary	PK	01	2021	kindergarten_4_year_old	106	106
2341152	WI	Milwaukee	school	5509600	3619	Public school	Milwaukee	550960001155	146	Milwaukee German Immersion		Regular School	No	Elementary	PK	05	2021	kindergarten_4_year_old	107	107
2344542	WI	Sauk	school	5513410	5100	Public school	Sauk Prairie	551341001761	150	Bridges Elementary		Regular School	No	Elementary	PK	02	2021	kindergarten_4_year_old	107	107
2343362	WI	Grant	school	5511850	4389	Public school	Platteville	551185001551	20	Wilkins Elementary		Regular School	No	Elementary	PK	KG	2021	kindergarten_4_year_old	109	109
2334534	WI	Grant	school	5502400	994	Public school	Cassville	550240000264	20	Cassville Elementary		Regular School	No	Elementary	PK	06	2021	kindergarten_4_year_old	11	11
2335294	WI	Vernon	school	5503240	1421	Public school	De Soto Area	550324000368	80	Prairie View Elementary		Regular School	No	Elementary	PK	05	2021	kindergarten_4_year_old	11	11
2336326	WI	Trempealeau	school	5504960	2009	Public school	Galesville-Ettrick-Trempealeau	550496000535	20	Ettrick Elementary		Regular School	No	Elementary	PK	05	2021	kindergarten_4_year_old	11	11
2336489	WI	Buffalo	school	5505370	2142	Public school	Gilmanton	550537000573	40	Gilmanton Elementary		Regular School	No	Elementary	PK	04	2021	kindergarten_4_year_old	11	11
2337053	WI	Shawano	school	5500056	2415	Public school	Gresham	550005602748	100	Gresham Elementary		Regular School	No	Elementary	PK	05	2021	kindergarten_4_year_old	11	11
2338218	WI	Kenosha	school	5507320	2793	Public school	Kenosha	550732000833	700	Wilson Elementary		Regular School	No	Elementary	PK	05	2021	kindergarten_4_year_old	11	11
2338477	WI	La Crosse	school	5507530	2849	Public school	La Crosse	550753001463	140	Coulee Montessori Charter School	charter	Regular School	Yes	Elementary	PK	08	2021	kindergarten_4_year_old	11	11
2340578	WI	Milwaukee	school	5509600	3619	Public school	Milwaukee	550960001162	170	Fifty-Third Street Elementary		Regular School	No	Elementary	PK	08	2021	kindergarten_4_year_old	11	11
2341803	WI	Green	school	5509900	3696	Public school	Monticello	550990001304	20	Monticello Elementary		Regular School	No	Elementary	PK	05	2021	kindergarten_4_year_old	11	11
2343803	WI	Racine	school	5512360	4620	Public school	Racine Unified	551236001627	111	Jones Elementary		Regular School	No	Elementary	PK	05	2021	kindergarten_4_year_old	11	11
2343880	WI	Racine	school	5512360	4620	Public school	Racine Unified	551236001637	154	Roosevelt Elementary		Regular School	No	Elementary	PK	05	2021	kindergarten_4_year_old	11	11
2345703	WI	Douglas	school	5514670	5663	Public school	Superior	551467002811	130	Superior Community Preschool		Regular School	No	Prekindergarten	PK	PK	2021	kindergarten_4_year_old	114	114
2335831	WI	Pierce	school	5504320	1659	Public school	Ellsworth Community	550432000465	60	Ellsworth Elementary		Regular School	No	Elementary	PK	05	2021	kindergarten_4_year_old	117	117
2336182	WI	Jefferson	school	5504740	1883	Public school	Fort Atkinson	550474002749	130	Fort Atkinson 4K		Regular School	No	Prekindergarten	PK	PK	2021	kindergarten_4_year_old	117	117
2335660	WI	Rock	school	5504110	1568	Public school	Edgerton	550411000442	40	Edgerton Community Elementary		Regular School	No	Elementary	PK	05	2021	kindergarten_4_year_old	119	119
2335448	WI	Bayfield	school	5503810	1491	Public school	Drummond Area	550381000398	20	Drummond Elementary		Regular School	No	Elementary	PK	06	2021	kindergarten_4_year_old	12	12
2340422	WI	Milwaukee	school	5509600	3619	Public school	Milwaukee	550960001140	110	Clarke Street Elementary		Regular School	No	Elementary	PK	08	2021	kindergarten_4_year_old	12	12
2340808	WI	Milwaukee	school	5509600	3619	Public school	Milwaukee	550960001188	218	Holmes Elementary		Regular School	No	Elementary	PK	08	2021	kindergarten_4_year_old	12	12
2341322	WI	Milwaukee	school	5509600	3619	Public school	Milwaukee	550960001174	194	River Trail Elementary		Regular School	No	Elementary	PK	08	2021	kindergarten_4_year_old	12	12
2342538	WI	Vilas	school	5503860	1526	Public school	Northland Pines	550386003008	110	Northland Pines Montessori Learning Center (NPMLC)	charter	Regular School	Yes	Elementary	PK	04	2021	kindergarten_4_year_old	12	12
2345124	WI	Bayfield	school	5512030	4522	Public school	South Shore	551203001571	40	South Shore Elementary		Regular School	No	Elementary	PK	06	2021	kindergarten_4_year_old	12	12
2345436	WI	Calumet	school	5514520	5614	Public school	Stockbridge	551452001882	20	Stockbridge Elementary		Regular School	No	Elementary	PK	05	2021	kindergarten_4_year_old	12	12
2346642	WI	Waukesha	school	5515780	6174	Public school	Waukesha	551578002028	540	Whittier Elementary		Regular School	No	Elementary	PK	05	2021	kindergarten_4_year_old	12	12
2347889	WI	Milwaukee	school	5500070	8132	Non District Charter Schools	Woodlands School - State Street Campus	550007002942	100	Woodlands School - State Street Campus	charter	Regular School	Yes	Elementary	PK	08	2021	kindergarten_4_year_old	12	12
2339854	WI	Waukesha	school	5509060	3437	Public school	Menomonee Falls	550906001061	40	Benjamin Franklin Elementary and Early Learning Center		Regular School	No	Elementary	PK	02	2021	kindergarten_4_year_old	120	120
2347802	WI	Wood	school	5517070	6685	Public school	Wisconsin Rapids	551707003357	140	WRPS Four-year-old Kindergarten and PK Early Childhood		Regular School	No	Prekindergarten	PK	PK	2021	kindergarten_4_year_old	120	120
2340732	WI	Milwaukee	school	5509600	3619	Public school	Milwaukee	550960002979	880	HAPA-Hmong American Peace Academy K3-12	charter	Regular School	Yes	Other	PK	12	2021	kindergarten_4_year_old	122	122
2346687	WI	Waupaca	school	5515840	6195	Public school	Waupaca	551584003007	170	Waupaca Community 4-Year Old Kindergarten		Regular School	No	Prekindergarten	PK	PK	2021	kindergarten_4_year_old	122	122
2340029	WI	Lincoln	school	5509210	3500	Public school	Merrill Area	550921000746	240	Pine River School for Young Learners (PRSYL)		Regular School	No	Prekindergarten	PK	PK	2021	kindergarten_4_year_old	123	123
2343450	WI	Ozaukee	school	5512000	4515	Public school	Port Washington-Saukville	551200003049	180	Port Washington-Saukville School District Preschool		Regular School	No	Prekindergarten	PK	PK	2021	kindergarten_4_year_old	123	123
2343712	WI	Racine	school	5512360	4620	Public school	Racine Unified	551236002708	114	Bull Early Education Center		Regular School	No	Prekindergarten	PK	PK	2021	kindergarten_4_year_old	123	123
2341819	WI	Marathon	school	5509960	3787	Public school	Mosinee	550996001307	80	Mosinee Elementary		Regular School	No	Elementary	PK	03	2021	kindergarten_4_year_old	124	124
2341236	WI	Milwaukee	school	5509600	3619	Public school	Milwaukee	550960001341	1141	Next Door Charter	charter	Regular School	Yes	Elementary	PK	KG	2021	kindergarten_4_year_old	125	125
2343710	WI	Racine	school	5512360	4620	Public school	Racine Unified	551236002657	113	All District 4 Year Old Kindergarten		Regular School	No	Prekindergarten	PK	PK	2021	kindergarten_4_year_old	126	126
2346437	WI	Jefferson	school	5515750	6125	Public school	Watertown Unified	551575002661	110	Watertown 4 Kids		Regular School	No	Prekindergarten	PK	PK	2021	kindergarten_4_year_old	126	126
2341197	WI	Milwaukee	school	5509600	3619	Public school	Milwaukee	550960001161	167	Milwaukee Spanish Immersion		Regular School	No	Elementary	PK	05	2021	kindergarten_4_year_old	129	129
2334361	WI	Ashland	school	5501920	840	Public school	Butternut	550192000245	20	Butternut Elementary		Regular School	No	Elementary	PK	05	2021	kindergarten_4_year_old	13	13
2335303	WI	Vernon	school	5503240	1421	Public school	De Soto Area	550324000369	100	Stoddard Elementary		Regular School	No	Elementary	PK	05	2021	kindergarten_4_year_old	13	13
2338713	WI	Chippewa	school	5507680	2891	Public school	Lake Holcombe	550768000885	20	Holcombe Elementary		Regular School	No	Elementary	PK	08	2021	kindergarten_4_year_old	13	13
2339014	WI	Dane	school	5508520	3269	Public school	Madison Metropolitan	550852000924	105	Crestwood Elementary		Regular School	No	Elementary	PK	05	2021	kindergarten_4_year_old	13	13
2339139	WI	Dane	school	5508520	3269	Public school	Madison Metropolitan	550852002263	15	Lincoln Elementary		Regular School	No	Elementary	PK	05	2021	kindergarten_4_year_old	13	13
2340959	WI	Milwaukee	school	5509600	3619	Public school	Milwaukee	550960001204	241	Lancaster Elementary		Regular School	No	Elementary	PK	08	2021	kindergarten_4_year_old	13	13
2340992	WI	Milwaukee	school	5509600	3619	Public school	Milwaukee	550960001210	257	Lowell International Elementary		Regular School	No	Elementary	PK	05	2021	kindergarten_4_year_old	13	13
2341369	WI	Milwaukee	school	5509600	3619	Public school	Milwaukee	550960001240	319	Sherman Elementary		Regular School	No	Elementary	PK	08	2021	kindergarten_4_year_old	13	13
2341458	WI	Milwaukee	school	5509600	3619	Public school	Milwaukee	550960001258	365	Townsend Street Elementary		Regular School	No	Elementary	PK	08	2021	kindergarten_4_year_old	13	13
2343370	WI	Pierce	school	5511880	4459	Public school	Plum City	551188001556	20	Plum City Elementary		Regular School	No	Elementary	PK	05	2021	kindergarten_4_year_old	13	13
2343839	WI	Racine	school	5512360	4620	Public school	Racine Unified	551236001634	150	North Park Elementary		Regular School	No	Elementary	PK	05	2021	kindergarten_4_year_old	13	13
2344397	WI	Fond du Lac	school	5513100	4956	Public school	Rosendale-Brandon	551310001727	25	Brandon Elementary		Regular School	No	Elementary	PK	05	2021	kindergarten_4_year_old	13	13
2345029	WI	Douglas	school	5513980	5397	Public school	Solon Springs	551398003113	100	Eagles' Wings Public Montessori Charter	charter	Regular School	Yes	Elementary	PK	06	2021	kindergarten_4_year_old	13	13
2346216	WI	Vernon	school	5515360	5985	Public school	Viroqua Area	551536002972	140	Viroqua Area Montessori School	charter	Regular School	Yes	Elementary	PK	06	2021	kindergarten_4_year_old	13	13
2346908	WI	Waushara	school	5515960	6237	Public school	Wautoma Area	551596002072	60	Redgranite Elementary		Regular School	No	Elementary	PK	05	2021	kindergarten_4_year_old	13	13
2347057	WI	Crawford	school	5516020	6251	Public school	Wauzeka-Steuben	551602002094	20	Wauzeka Elementary		Regular School	No	Elementary	PK	05	2021	kindergarten_4_year_old	13	13
2341725	WI	Green	school	5509840	3682	Public school	Monroe	550984002771	10	Abraham Lincoln Elementary		Regular School	No	Elementary	PK	05	2021	kindergarten_4_year_old	130	130
2333017	WI	Buffalo	school	5500180	84	Public school	Alma	550018000017	20	Alma Elementary		Regular School	No	Elementary	PK	08	2021	kindergarten_4_year_old	14	14
2334329	WI	Racine	school		777	Public Schools-Multidistrict Charters	Burlington Area		9803	JEDI Virtual K-12	charter						2021	kindergarten_4_year_old	14	14
2334352	WI	Racine	school	5501890	777	Public school	Burlington Area	550189000244	160	Winkler Elementary		Regular School	No	Elementary	PK	04	2021	kindergarten_4_year_old	14	14
2335995	WI	Columbia	school	5504530	1736	Public school	Fall River	550453000483	20	Fall River Elementary		Regular School	No	Elementary	PK	05	2021	kindergarten_4_year_old	14	14
2336683	WI	Brown	school	5505820	2289	Public school	Green Bay Area Public	550582000617	175	Doty Elementary		Regular School	No	Elementary	PK	05	2021	kindergarten_4_year_old	14	14
2337542	WI	Dodge	school	5506780	2625	Public school	Hustisford	550678000737	20	John Hustis Elementary		Regular School	No	Elementary	PK	05	2021	kindergarten_4_year_old	14	14
2338054	WI	Kenosha	school	5507320	2793	Public school	Kenosha	550732000814	310	Jeffery Elementary		Regular School	No	Elementary	PK	05	2021	kindergarten_4_year_old	14	14
2339636	WI	Juneau	school	5508850	3360	Public school	Mauston	550885003030	110	Mauston Montessori Charter School	charter	Regular School	Yes	Elementary	PK	04	2021	kindergarten_4_year_old	14	14
2340848	WI	Milwaukee	school	5509600	3619	Public school	Milwaukee	550960002493	165	IDEAL Individualized Developmental Educational Approaches to Learning	charter	Regular School	Yes	Elementary	PK	08	2021	kindergarten_4_year_old	14	14
2342146	WI	Chippewa	school	5510440	3920	Public school	New Auburn	551044001362	20	New Auburn Elementary		Regular School	No	Elementary	PK	04	2021	kindergarten_4_year_old	14	14
2345225	WI	Monroe	school	5514160	5460	Public school	Sparta Area	551416003358	170	Sparta Montessori School	charter	Regular School	Yes	Elementary	PK	06	2021	kindergarten_4_year_old	14	14
2345672	WI	Douglas	school	5514670	5663	Public school	Superior	551467002347	110	Four Corners Elementary		Regular School	No	Elementary	PK	05	2021	kindergarten_4_year_old	14	14
2345779	WI	Oneida	school	5514850	5733	Public school	Three Lakes	551485001927	40	Sugar Camp Elementary		Regular School	No	Elementary	PK	06	2021	kindergarten_4_year_old	14	14
2346547	WI	Waukesha	school	5515780	6174	Public school	Waukesha	551578002018	280	Meadowbrook Elementary		Regular School	No	Elementary	PK	05	2021	kindergarten_4_year_old	14	14
2347656	WI	Sawyer	school	5516860	6615	Public school	Winter	551686002194	60	Winter Elementary		Regular School	No	Elementary	PK	05	2021	kindergarten_4_year_old	14	14
2343270	WI	Waukesha	school	5511640	4312	Public school	Pewaukee	551164001536	60	Pewaukee Lake Elementary		Regular School	No	Elementary	PK	02	2021	kindergarten_4_year_old	140	140
2345195	WI	Monroe	school	5514160	5460	Public school	Sparta Area	551416001841	120	Southside Early Learning Center		Regular School	No	Elementary	PK	KG	2021	kindergarten_4_year_old	143	143