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
2320081	WI	Clark	school		1162	Public Schools-Multidistrict Charters	Colby		9100	Rural Virtual Academy	charter						2020	grade_2	1	1
2320297	WI	Barron	school	5503090	1260	Public school	Cumberland	550309002871	800	Island City Virtual Academy	charter	Regular School	Yes	Other	PK	12	2020	grade_2	1	1
2320896	WI	Langlade	school		1582	Public Schools-Multidistrict Charters	Elcho		9100	Rural Virtual Academy	charter						2020	grade_2	1	1
2321846	WI	Brown	school	5505820	2289	Public school	Green Bay Area Public	550582003009	800	Dr Rosa Minoka-Hill School		Alternative School	No	Other	KG	12	2020	grade_2	1	1
2322785	WI	Rock	school	5507020	2695	Public school	Janesville	550702002991	860	ARISE Virtual Academy	charter	Regular School	Yes	Other	KG	12	2020	grade_2	1	1
2322940	WI	Jefferson	school		2702	Public Schools-Multidistrict Charters	Jefferson		9803	JEDI Virtual K-12	charter						2020	grade_2	1	1
2323799	WI	Walworth	school	5507620	2885	Public school	Lake Geneva J1	550762003107	150	Maple Park Charter School	charter	Regular School	Yes	Elementary	PK	08	2020	grade_2	1	1
2323849	WI	Jefferson	school	5507710	2898	Public school	Lake Mills Area	550771002901	9803	JEDI Virtual K-12 - Jefferson and Eastern Dane County Interactive	charter	Alternative School	Yes	Other	PK	12	2020	grade_2	1	1
2324699	WI	Wood	school		3339	Public Schools-Multidistrict Charters	Marshfield Unified		9100	Rural Virtual Academy	charter						2020	grade_2	1	1
2328673	WI	Crawford	school	5512150	4543	Public school	Prairie du Chien Area	551215002944	800	Mighty River Academy of Virtual Education	charter	Regular School	Yes	Other	KG	12	2020	grade_2	1	1
2328968	WI	Racine	school	5512360	4620	Public school	Racine Unified	551236003045	801	Racine Alternative Learning		Alternative School	No	Other	KG	12	2020	grade_2	1	1
2330835	WI	Clark	school		5726	Public Schools-Multidistrict Charters	Thorp		9100	Rural Virtual Academy	charter						2020	grade_2	1	1
2318447	WI	Outagamie	school	5500390	147	Public school	Appleton Area	550039002582	135	Fox River Academy	charter	Regular School	Yes	Elementary	KG	08	2020	grade_2	10	10
2327639	WI	Vilas	school	5503860	1526	Public school	Northland Pines	550386000405	80	Northland Pines Elementary-Land O' Lakes		Regular School	No	Elementary	PK	04	2020	grade_2	10	10
2328229	WI	Jefferson	school	5511350	4221	Public school	Palmyra-Eagle Area	551135001513	10	Eagle Elementary		Regular School	No	Elementary	PK	06	2020	grade_2	10	10
2332431	WI	Waupaca	school	5516500	6384	Public school	Weyauwega-Fremont	551650002157	40	Fremont Elementary		Regular School	No	Elementary	KG	05	2020	grade_2	10	10
2322051	WI	Brown	school	5505820	2289	Public school	Green Bay Area Public	550582000639	590	Sullivan Elementary		Regular School	No	Elementary	PK	05	2020	grade_2	100	100
2327543	WI	Fond du Lac	school	5510740	3983	Public school	North Fond du Lac	551074001398	55	Friendship Learning Elementary		Regular School	No	Elementary	PK	05	2020	grade_2	100	100
2330785	WI	Douglas	school	5514670	5663	Public school	Superior	551467002539	115	Northern Lights Elementary		Regular School	No	Elementary	PK	05	2020	grade_2	100	100
2318491	WI	Outagamie	school	5500390	147	Public school	Appleton Area	550039000056	200	Huntley Elementary		Regular School	No	Elementary	PK	06	2020	grade_2	101	101
2319210	WI	Green Lake	school	5501140	434	Public school	Berlin Area	550114000163	60	Clay Lamberton Elementary		Regular School	No	Elementary	PK	05	2020	grade_2	103	103
2320421	WI	Dane	school	5503180	1316	Public school	De Forest Area	550318000354	20	Eagle Point Elementary		Regular School	No	Elementary	KG	04	2020	grade_2	103	103
2321045	WI	Waukesha	school	5501770	714	Public school	Elmbrook	550177002367	100	Dixon Elementary		Regular School	No	Elementary	PK	05	2020	grade_2	103	103
2323859	WI	Jefferson	school	5507710	2898	Public school	Lake Mills Area	550771000889	100	Lake Mills Elementary		Regular School	No	Elementary	PK	04	2020	grade_2	103	103
2325228	WI	Dane	school	5509510	3549	Public school	Middleton-Cross Plains Area	550951000755	150	Sunset Ridge Elementary		Regular School	No	Elementary	PK	04	2020	grade_2	103	103
2329257	WI	Barron	school	5512810	4802	Public school	Rice Lake Area	551281000581	25	Tainter Elementary		Regular School	No	Elementary	PK	04	2020	grade_2	103	103
2332321	WI	Brown	school	5516320	6328	Public school	West De Pere	551632002139	140	Westwood Elementary		Regular School	No	Elementary	PK	05	2020	grade_2	103	103
2322556	WI	Brown	school	5506630	2604	Public school	Howard-Suamico	550663002409	40	Forest Glen Elementary		Regular School	No	Elementary	KG	04	2020	grade_2	105	105
2324825	WI	Taylor	school	5508940	3409	Public school	Medford Area Public	550894002361	180	Medford Elementary		Regular School	No	Elementary	PK	04	2020	grade_2	105	105
2318297	WI	Polk	school	5500300	119	Public school	Amery	550030000029	20	Lien Elementary		Regular School	No	Elementary	PK	03	2020	grade_2	106	106
2329961	WI	Sheboygan	school	5513680	5278	Public school	Sheboygan Falls	551368001801	20	Sheboygan Falls Elementary		Regular School	No	Elementary	PK	04	2020	grade_2	107	107
2332276	WI	Washington	school	5516290	6307	Public school	West Bend	551629002132	100	McLane Elementary		Regular School	No	Elementary	KG	04	2020	grade_2	107	107
2328040	WI	Polk	school	5511160	4165	Public school	Osceola	551116001479	40	Osceola Elementary		Regular School	No	Elementary	PK	02	2020	grade_2	108	108
2318658	WI	Ashland	school	5500510	170	Public school	Ashland	550051000077	80	Lake Superior Elementary		Regular School	No	Elementary	PK	05	2020	grade_2	109	109
2321666	WI	Milwaukee	school	5505460	2184	Public school	Glendale-River Hills	550546000577	60	Parkway Elementary		Regular School	No	Elementary	PK	03	2020	grade_2	109	109
2328466	WI	Grant	school	5511850	4389	Public school	Platteville	551185001555	120	Westview Elementary		Regular School	No	Elementary	01	04	2020	grade_2	109	109
2320351	WI	Marathon	school	5513170	4970	Public school	D C Everest Area	551317003065	140	Odyssey Elementary		Regular School	No	Elementary	KG	05	2020	grade_2	11	11
2321643	WI	Buffalo	school	5505370	2142	Public school	Gilmanton	550537000573	40	Gilmanton Elementary		Regular School	No	Elementary	PK	04	2020	grade_2	11	11
2323940	WI	Walworth	school	5508040	3087	Public school	Linn J4	550804000898	20	Traver Elementary		Regular School	No	Elementary	PK	08	2020	grade_2	11	11
2327647	WI	Vilas	school	5503860	1526	Public school	Northland Pines	550386000408	100	Northland Pines Elementary-St Germain		Regular School	No	Elementary	PK	04	2020	grade_2	11	11
2319294	WI	Jackson	school	5501260	476	Public school	Black River Falls	550126002428	130	Red Creek Elementary		Regular School	No	Elementary	02	05	2020	grade_2	110	110
2320555	WI	Brown	school	5503660	1407	Public school	Denmark	550366000387	60	Denmark Elementary		Regular School	No	Elementary	01	05	2020	grade_2	110	110
2323198	WI	Kenosha	school	5507320	2793	Public school	Kenosha	550732002758	190	Kenosha School of Technology Enhanced Curriculum	charter	Regular School	Yes	Elementary	PK	08	2020	grade_2	110	110
2328013	WI	Dane	school	5511100	4144	Public school	Oregon	551110001469	40	Netherwood Knoll Elementary		Regular School	No	Elementary	PK	04	2020	grade_2	110	110
2331717	WI	Dane	school	5515810	6181	Public school	Waunakee Community	551581001198	100	Waunakee Prairie Elementary		Regular School	No	Elementary	PK	04	2020	grade_2	110	110
2331755	WI	Fond du Lac	school	5515870	6216	Public school	Waupun	551587002809	110	Rock River Intermediate		Regular School	No	Elementary	02	06	2020	grade_2	110	110
2324260	WI	Dane	school	5508520	3269	Public school	Madison Metropolitan	550852000944	475	Leopold Elementary		Regular School	No	Elementary	PK	05	2020	grade_2	111	111
2331739	WI	Waupaca	school	5515840	6195	Public school	Waupaca	551584001203	70	Waupaca Learning Center Elementary		Regular School	No	Elementary	PK	04	2020	grade_2	111	111
2318799	WI	Saint Croix	school	5500720	231	Public school	Baldwin-Woodville Area	550072000095	70	Greenfield Elementary		Regular School	No	Elementary	PK	05	2020	grade_2	112	112
2322243	WI	Waukesha	school	5506030	2420	Public school	Hamilton	550603000667	120	Marcy Elementary		Regular School	No	Elementary	KG	04	2020	grade_2	112	112
2323548	WI	Outagamie	school	5507470	2835	Public school	Kimberly Area	550747002641	130	Woodland School		Regular School	No	Elementary	KG	04	2020	grade_2	112	112
2324179	WI	Dane	school	5508520	3269	Public school	Madison Metropolitan	550852000930	240	Franklin Elementary		Regular School	No	Elementary	PK	02	2020	grade_2	112	112
2319473	WI	Milwaukee	school	5501800	721	Public school	Brown Deer	550180000232	80	Brown Deer Elementary		Regular School	No	Elementary	PK	05	2020	grade_2	115	115
2321132	WI	Rock	school	5504440	1694	Public school	Evansville Community	550444000477	20	Levi Leonard Elementary		Regular School	No	Elementary	PK	02	2020	grade_2	116	116
2323782	WI	Walworth	school	5507620	2885	Public school	Lake Geneva J1	550762000879	20	Central - Denison Elementary		Regular School	No	Elementary	PK	03	2020	grade_2	116	116
2326315	WI	Milwaukee	school	5509600	3619	Public school	Milwaukee	550960001161	167	Milwaukee Spanish Immersion		Regular School	No	Elementary	PK	05	2020	grade_2	116	116
2332489	WI	Milwaukee	school	5516620	6419	Public school	Whitefish Bay	551662002166	20	Cumberland Elementary		Regular School	No	Elementary	PK	05	2020	grade_2	116	116
2322258	WI	Waukesha	school	5506030	2420	Public school	Hamilton	550603001676	150	Woodside Elementary		Regular School	No	Elementary	KG	04	2020	grade_2	117	117
2320430	WI	Dane	school	5503180	1316	Public school	De Forest Area	550318000360	140	Windsor Elementary		Regular School	No	Elementary	KG	04	2020	grade_2	118	118
2323030	WI	Outagamie	school	5507290	2758	Public school	Kaukauna Area	550729000796	100	Quinney Elementary		Regular School	No	Elementary	02	04	2020	grade_2	119	119
2329560	WI	Saint Croix	school	5506060	2422	Public school	Saint Croix Central	550606000671	40	Saint Croix Central Elementary		Regular School	No	Elementary	PK	04	2020	grade_2	119	119
2319000	WI	Dodge	school	5500960	336	Public school	Beaver Dam Unified	550096000127	120	South Beaver Dam Elementary		Regular School	No	Elementary	KG	05	2020	grade_2	12	12
2320606	WI	Iowa	school	5503690	1428	Public school	Dodgeville	550369000393	60	Ridgeway Elementary		Regular School	No	Elementary	PK	05	2020	grade_2	12	12
2320964	WI	Walworth	school	5504290	1638	Public school	Elkhorn Area	550429003038	800	Elkhorn Options Virtual School	charter	Regular School	Yes	Other	PK	12	2020	grade_2	12	12
2321734	WI	Clark	school	5505640	2226	Public school	Granton Area	550564000599	20	Granton Elementary		Regular School	No	Elementary	PK	05	2020	grade_2	12	12
2327662	WI	Vilas	school	5503860	1526	Public school	Northland Pines	550386003008	110	Northland Pines Montessori Learning Center (NPMLC)	charter	Regular School	Yes	Elementary	PK	04	2020	grade_2	12	12
2329105	WI	Sauk	school	5512660	4753	Public school	Reedsburg	551266001662	20	Ironton-La Valle Elementary		Regular School	No	Elementary	KG	03	2020	grade_2	12	12
2329179	WI	Oneida	school	5512720	4781	Public school	Rhinelander	551272001673	20	Northwoods Community Elementary		Regular School	No	Elementary	PK	05	2020	grade_2	12	12
2330859	WI	Oneida	school	5514850	5733	Public school	Three Lakes	551485001927	40	Sugar Camp Elementary		Regular School	No	Elementary	PK	06	2020	grade_2	12	12
2331458	WI	Jefferson	school	5515750	6125	Public school	Watertown Unified	551575001998	60	Lebanon Elementary		Regular School	No	Elementary	KG	05	2020	grade_2	12	12
2331897	WI	Marathon	school	5515900	6223	Public school	Wausau	551590002629	150	Wausau Area Montessori Charter School	charter	Regular School	Yes	Elementary	KG	06	2020	grade_2	12	12
2332377	WI	Marquette	school	5516440	6335	Public school	Westfield	551644002147	20	Coloma Elementary		Regular School	No	Elementary	PK	06	2020	grade_2	12	12
2332687	WI	Sauk	school	5517040	6678	Public school	Wisconsin Dells	551704000551	50	Neenah Creek Elementary		Regular School	No	Elementary	KG	05	2020	grade_2	12	12
2321067	WI	Waukesha	school	5501770	714	Public school	Elmbrook	550177001217	190	Swanson Elementary		Regular School	No	Elementary	PK	05	2020	grade_2	120	120
2320856	WI	Rock	school	5504110	1568	Public school	Edgerton	550411000442	40	Edgerton Community Elementary		Regular School	No	Elementary	PK	05	2020	grade_2	121	121
2318265	WI	Eau Claire	school	5500270	112	Public school	Altoona	550027000028	80	Altoona Elementary		Regular School	No	Elementary	PK	03	2020	grade_2	123	123
2322500	WI	Outagamie	school	5506600	2583	Public school	Hortonville Area	550660002407	10	Greenville Elementary		Regular School	No	Elementary	PK	04	2020	grade_2	124	124
2321032	WI	Waukesha	school	5501770	714	Public school	Elmbrook	550177000218	80	Burleigh Elementary		Regular School	No	Elementary	PK	05	2020	grade_2	128	128
2320538	WI	Walworth	school	5503640	1380	Public school	Delavan-Darien	550364000317	45	Turtle Creek Elementary		Regular School	No	Elementary	PK	02	2020	grade_2	129	129
2319232	WI	Washburn	school	5501170	441	Public school	Birchwood	550117000168	20	Birchwood Elementary		Regular School	No	Elementary	PK	05	2020	grade_2	13	13
2322320	WI	Sawyer	school	5506270	2478	Public school	Hayward Community	550627003339	800	Hayward Ctr for Individualized Learning	charter	Regular School	Yes	Other	PK	12	2020	grade_2	13	13
2324746	WI	Juneau	school	5508850	3360	Public school	Mauston	550885003030	110	Mauston Montessori Charter School	charter	Regular School	Yes	Elementary	PK	04	2020	grade_2	13	13
2327273	WI	Chippewa	school	5510440	3920	Public school	New Auburn	551044001362	20	New Auburn Elementary		Regular School	No	Elementary	PK	05	2020	grade_2	13	13
2328475	WI	Pierce	school	5511880	4459	Public school	Plum City	551188001556	20	Plum City Elementary		Regular School	No	Elementary	PK	05	2020	grade_2	13	13
2328573	WI	Columbia	school	5512060	4501	Public school	Portage Community	551206002419	120	Endeavor Elementary		Regular School	No	Elementary	PK	05	2020	grade_2	13	13
2322345	WI	Sawyer	school	5506270	2478	Public school	Hayward Community	550627000689	20	Hayward Primary		Regular School	No	Elementary	PK	02	2020	grade_2	130	130
2329641	WI	Sauk	school	5513410	5100	Public school	Sauk Prairie	551341001761	150	Bridges Elementary		Regular School	No	Elementary	PK	02	2020	grade_2	130	130
2332644	WI	Winnebago	school	5516830	6608	Public school	Winneconne Community	551683002190	40	Winneconne Elementary		Regular School	No	Elementary	PK	05	2020	grade_2	130	130
2320468	WI	Brown	school	5503210	1414	Public school	De Pere	550321002668	100	Susie C Altmayer Elementary		Regular School	No	Elementary	PK	04	2020	grade_2	131	131
2324310	WI	Dane	school	5508520	3269	Public school	Madison Metropolitan	550852000951	570	Midvale Elementary		Regular School	No	Elementary	PK	02	2020	grade_2	131	131
2324966	WI	Waukesha	school	5509060	3437	Public school	Menomonee Falls	550906001061	40	Benjamin Franklin Elementary and Early Learning Center		Regular School	No	Elementary	PK	02	2020	grade_2	131	131
2332330	WI	La Crosse	school	5516350	6370	Public school	West Salem	551635002140	60	West Salem Elementary		Regular School	No	Elementary	PK	04	2020	grade_2	131	131
2319509	WI	Milwaukee	school	5500059	8123	Non District Charter Schools	Bruce Guadalupe	550005900772	100	Bruce Guadalupe	charter	Regular School	Yes	Elementary	PK	08	2020	grade_2	136	136
2326942	WI	Marathon	school	5509960	3787	Public school	Mosinee	550996001307	80	Mosinee Elementary		Regular School	No	Elementary	PK	03	2020	grade_2	138	138
2332299	WI	Brown	school	5516320	6328	Public school	West De Pere	551632002726	150	Hemlock Creek Elementary		Regular School	No	Elementary	PK	05	2020	grade_2	138	138
2318716	WI	Brown	school	5500540	182	Public school	Ashwaubenon	550054000085	60	Valley View Elementary		Regular School	No	Elementary	KG	05	2020	grade_2	139	139
2318899	WI	Barron	school	5500870	308	Public school	Barron Area	550087000113	20	Almena Elementary		Regular School	No	Elementary	02	04	2020	grade_2	14	14
2319021	WI	Marinette	school	5511550	4263	Public school	Beecher-Dunbar-Pembine	551155001529	40	Pembine Elementary		Regular School	No	Elementary	PK	06	2020	grade_2	14	14
2319183	WI	Lafayette	school	5501110	427	Public school	Benton	550111000160	20	Benton Elementary		Regular School	No	Elementary	PK	06	2020	grade_2	14	14
2319576	WI	Ashland	school	5501920	840	Public school	Butternut	550192000245	20	Butternut Elementary		Regular School	No	Elementary	PK	05	2020	grade_2	14	14
2322986	WI	Green	school	5507230	2737	Public school	Juda	550723000784	20	Juda Elementary		Regular School	No	Elementary	PK	08	2020	grade_2	14	14