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_int 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
111791	WI	Adams	school	5500060	14	Public school	Adams-Friendship Area	550006000012	200	Roche-A-Cri Elementary		Regular School	No	1.0	PK	05	2015	pre_kindergarten	1	1
111852	WI	Jackson	school	5500210	91	Public school	Alma Center	550021000022	80	Lincoln Elementary		Regular School	No	1.0	PK	06	2015	pre_kindergarten	1	1
111974	WI	Langlade	school	5500360	140	Public school	Antigo Unified	550036000045	260	Spring Valley Elementary		Regular School	No	1.0	PK	05	2015	pre_kindergarten	1	1
112028	WI	Outagamie	school	5500390	147	Public school	Appleton Area	550039000049	60	Badger Elementary		Regular School	No	1.0	PK	06	2015	pre_kindergarten	1	1
112055	WI	Outagamie	school	5500390	147	Public school	Appleton Area	550039000050	80	Columbus Elementary		Regular School	No	1.0	PK	06	2015	pre_kindergarten	1	1
112447	WI	Sauk	school	5500810	280	Public school	Baraboo	550081000109	180	Al Behrman Elementary		Regular School	No	1.0	PK	05	2015	pre_kindergarten	1	1
112494	WI	Iowa	school	5500840	287	Public school	Barneveld	550084000111	20	Barneveld Elementary		Regular School	No	1.0	PK	05	2015	pre_kindergarten	1	1
113330	WI	Monroe	school	5502340	980	Public school	Cashton	550234000262	20	Cashton Elementary		Regular School	No	1.0	PK	05	2015	pre_kindergarten	1	1
113598	WI	Rock	school	5502640	1134	Public school	Clinton Community	550264000295	40	Clinton Elementary		Regular School	No	1.0	PK	04	2015	pre_kindergarten	1	1
113637	WI	Buffalo	school	5502700	1155	Public school	Cochrane-Fountain City	550270000306	20	Cochrane-Fountain City Elementary		Regular School	No	1.0	PK	06	2015	pre_kindergarten	1	1
113822	WI	Milwaukee	school	5503060	1253	Public school	Cudahy	550306001228	140	Kosciuszko Elementary		Regular School	No	1.0	PK	06	2015	pre_kindergarten	1	1
113832	WI	Milwaukee	school	5503060	1253	Public school	Cudahy	550306000340	80	Lincoln Elementary		Regular School	No	1.0	PK	06	2015	pre_kindergarten	1	1
113942	WI	Marathon	school	5513170	4970	Public school	D C Everest Area	551317001739	80	Rothschild Elementary		Regular School	No	1.0	PK	05	2015	pre_kindergarten	1	1
114049	WI	Vernon	school	5503240	1421	Public school	De Soto Area	550324000368	80	Prairie View Elementary		Regular School	No	1.0	PK	05	2015	pre_kindergarten	1	1
114535	WI	Walworth	school	5504290	1638	Public school	Elkhorn Area	550429000461	80	Tibbets Elementary		Regular School	No	1.0	PK	05	2015	pre_kindergarten	1	1
114773	WI	Florence	school	5504650	1855	Public school	Florence County	550465000489	40	Florence Elementary		Regular School	No	1.0	PK	06	2015	pre_kindergarten	1	1
114855	WI	Fond du Lac	school	5504680	1862	Public school	Fond du Lac	550468000502	260	Roberts Elementary		Regular School	No	1.0	PK	05	2015	pre_kindergarten	1	1
114994	WI	Milwaukee	school	5504830	1900	Public school	Franklin Public	550483000524	100	Robinwood Elementary		Regular School	No	1.0	PK	06	2015	pre_kindergarten	1	1
115302	WI	Ozaukee	school	5505610	2217	Public school	Grafton	550561002247	30	Kennedy Elementary		Regular School	No	1.0	PK	05	2015	pre_kindergarten	1	1
115311	WI	Ozaukee	school	5505610	2217	Public school	Grafton	550561002250	100	Woodview Elementary		Regular School	No	1.0	PK	05	2015	pre_kindergarten	1	1
115402	WI	Brown	school	5505820	2289	Public school	Green Bay Area Public	550582000614	100	Chappell Elementary		Regular School	No	1.0	PK	05	2015	pre_kindergarten	1	1
115457	WI	Brown	school	5505820	2289	Public school	Green Bay Area Public	550582000621	220	Elmore Elementary		Regular School	No	1.0	PK	05	2015	pre_kindergarten	1	1
115471	WI	Brown	school	5505820	2289	Public school	Green Bay Area Public	550582002965	170	Friedrich Froebel Garden of Early Learning		Regular School	No	1.0	PK	KG	2015	pre_kindergarten	1	1
115500	WI	Brown	school	5505820	2289	Public school	Green Bay Area Public	550582000626	360	Jefferson Elementary		Regular School	No	1.0	PK	05	2015	pre_kindergarten	1	1
115533	WI	Brown	school	5505820	2289	Public school	Green Bay Area Public	550582000166	390	King Elementary		Regular School	No	1.0	PK	05	2015	pre_kindergarten	1	1
115574	WI	Brown	school	5505820	2289	Public school	Green Bay Area Public	550582000632	430	MacArthur Elementary		Regular School	No	1.0	PK	05	2015	pre_kindergarten	1	1
115742	WI	Milwaukee	school	5505940	2303	Public school	Greenfield	550594000652	100	Glenwood Elementary		Regular School	No	1.0	PK	05	2015	pre_kindergarten	1	1
116105	WI	Brown	school	5506630	2604	Public school	Howard-Suamico	550663002709	120	Bay Harbor Elementary		Regular School	No	1.0	PK	04	2015	pre_kindergarten	1	1
116259	WI	Trempealeau	school	5506810	2632	Public school	Independence	550681000739	20	Independence Elementary		Regular School	No	1.0	PK	05	2015	pre_kindergarten	1	1
116963	WI	Waukesha	school	5503510	1376	Public school	Kettle Moraine	550351000380	240	Wales Elementary		Regular School	No	1.0	PK	05	2015	pre_kindergarten	1	1
117130	WI	Sheboygan	school	5507500	2842	Public school	Kohler	550750000852	20	Kohler Elementary		Regular School	No	1.0	PK	05	2015	pre_kindergarten	1	1
117254	WI	La Crosse	school	5507530	2849	Public school	La Crosse	550753000859	290	Spence Elementary		Regular School	No	1.0	PK	05	2015	pre_kindergarten	1	1
117263	WI	La Crosse	school	5507530	2849	Public school	La Crosse	550753000869	320	State Road Elementary		Regular School	No	1.0	PK	05	2015	pre_kindergarten	1	1
117315	WI	Rusk	school	5507590	2856	Public school	Ladysmith	550759000876	60	Ladysmith Elementary		Regular School	No	1.0	PK	04	2015	pre_kindergarten	1	1
117592	WI	Polk	school	5508280	3213	Public school	Luck	550828000914	40	Luck Elementary		Regular School	No	1.0	PK	06	2015	pre_kindergarten	1	1
117720	WI	Dane	school	5508520	3269	Public school	Madison Metropolitan	550852002410	48	Hawthorne Elementary		Regular School	No	1.0	PK	05	2015	pre_kindergarten	1	1
117924	WI	Dane	school	5508520	3269	Public school	Madison Metropolitan	550852000964	780	Thoreau Elementary		Regular School	No	1.0	PK	05	2015	pre_kindergarten	1	1
118114	WI	Marinette	school	5508700	3311	Public school	Marinette	550870000999	140	Park Elementary		Regular School	No	1.0	PK	04	2015	pre_kindergarten	1	1
118529	WI	Dunn	school	5509090	3444	Public school	Menomonie Area	550909000379	210	Oaklawn Elementary		Regular School	No	1.0	PK	05	2015	pre_kindergarten	1	1
118745	WI	Dane	school	5509510	3549	Public school	Middleton-Cross Plains Area	550951001113	160	West Middleton Elementary		Regular School	No	1.0	PK	04	2015	pre_kindergarten	1	1
119295	WI	Milwaukee	school	5509600	3619	Public school	Milwaukee	550960001175	193	Grant Elementary		Regular School	No	1.0	PK	08	2015	pre_kindergarten	1	1
119397	WI	Milwaukee	school	5509600	3619	Public school	Milwaukee	550960000680	214	Hayes Bilingual School		Regular School	No	1.0	PK	08	2015	pre_kindergarten	1	1
119693	WI	Milwaukee	school	5509600	3619	Public school	Milwaukee	550960001216	268	Maryland Montessori		Regular School	No	1.0	PK	08	2015	pre_kindergarten	1	1
119964	WI	Milwaukee	school	5509600	3619	Public school	Milwaukee	550960001236	313	Riley Elementary		Regular School	No	1.0	PK	05	2015	pre_kindergarten	1	1
120318	WI	Iowa	school	5509660	3633	Public school	Mineral Point Unified	550966001275	60	Mineral Point Elementary		Regular School	No	1.0	PK	05	2015	pre_kindergarten	1	1
120647	WI	Waukesha	school	5510170	3857	Public school	Muskego-Norway	551017001334	140	Muskego Elementary		Regular School	No	1.0	PK	04	2015	pre_kindergarten	1	1
120934	WI	Juneau	school	5510560	3948	Public school	New Lisbon	551056001381	40	New Lisbon Elementary		Regular School	No	1.0	PK	06	2015	pre_kindergarten	1	1
120988	WI	Waupaca	school	5510590	3955	Public school	New London	551059001386	100	Readfield Elementary		Regular School	No	1.0	PK	04	2015	pre_kindergarten	1	1
120996	WI	Waupaca	school	5510590	3955	Public school	New London	551059001387	120	Sugar Bush Elementary		Regular School	No	1.0	PK	04	2015	pre_kindergarten	1	1
121071	WI	Racine	school	5512510	4690	Public school	North Cape	551251001657	20	North Cape Elementary		Regular School	No	1.0	PK	08	2015	pre_kindergarten	1	1
121777	WI	Jefferson	school	5511350	4221	Public school	Palmyra-Eagle Area	551135001513	10	Eagle Elementary		Regular School	No	1.0	PK	06	2015	pre_kindergarten	1	1
121803	WI	Columbia	school	5511370	4228	Public school	Pardeeville Area	551137001517	60	Pardeeville Elementary		Regular School	No	1.0	PK	04	2015	pre_kindergarten	1	1
121851	WI	Lafayette	school	5501310	490	Public school	Pecatonica Area	550131000181	20	Pecatonica Elementary		Regular School	No	1.0	PK	05	2015	pre_kindergarten	1	1
121936	WI	Price	school	5511730	4347	Public school	Phillips	551173001543	100	Phillips Elementary		Regular School	No	1.0	PK	05	2015	pre_kindergarten	1	1
121989	WI	Pierce	school	5511880	4459	Public school	Plum City	551188001556	20	Plum City Elementary		Regular School	No	1.0	PK	05	2015	pre_kindergarten	1	1
122021	WI	Sheboygan	school	5511940	4473	Public school	Plymouth Joint	551194001560	60	Parkview Elementary		Regular School	No	1.0	PK	04	2015	pre_kindergarten	1	1
122219	WI	Price	school	5512210	4571	Public school	Prentice	551221001587	20	Ogema Elementary		Regular School	No	1.0	PK	04	2015	pre_kindergarten	1	1
122282	WI	Brown	school	5512330	4613	Public school	Pulaski Community	551233001596	20	Fairview Elementary		Regular School	No	1.0	PK	05	2015	pre_kindergarten	1	1
122299	WI	Brown	school	5512330	4613	Public school	Pulaski Community	551233001598	50	Hillcrest Elementary		Regular School	No	1.0	PK	05	2015	pre_kindergarten	1	1
122328	WI	Racine	school	5512360	4620	Public school	Racine Unified	551236002657	113	All District 4 Year Old Kindergarten		Regular School	No	1.0	PK	PK	2015	pre_kindergarten	1	1
122358	WI	Racine	school	5512360	4620	Public school	Racine Unified	551236001614	121	Giese Elementary		Regular School	No	1.0	PK	05	2015	pre_kindergarten	1	1
122438	WI	Racine	school	5512360	4620	Public school	Racine Unified	551236003337	720	Julian Thomas Elementary		Regular School	No	1.0	PK	05	2015	pre_kindergarten	1	1
122526	WI	Racine	school	5512360	4620	Public school	Racine Unified	551236001638	166	Schulte Elementary		Regular School	No	1.0	PK	05	2015	pre_kindergarten	1	1
122588	WI	Columbia	school	5512420	4634	Public school	Randolph	551242001650	20	Randolph Elementary		Regular School	No	1.0	PK	08	2015	pre_kindergarten	1	1
122664	WI	Sauk	school	5512660	4753	Public school	Reedsburg	551266001668	160	West Side Elementary		Regular School	No	1.0	PK	03	2015	pre_kindergarten	1	1
123024	WI	Grant	school	5510140	3850	Public school	Riverdale	551014001063	150	Riverdale Elementary		Regular School	No	1.0	PK	04	2015	pre_kindergarten	1	1
123051	WI	Fond du Lac	school	5513100	4956	Public school	Rosendale-Brandon	551310001727	25	Brandon Elementary		Regular School	No	1.0	PK	05	2015	pre_kindergarten	1	1
123078	WI	Fond du Lac	school	5513100	4956	Public school	Rosendale-Brandon	551310001730	60	Rosendale Primary		Regular School	No	1.0	PK	03	2015	pre_kindergarten	1	1
123102	WI	Juneau	school	5504380	1673	Public school	Royall	550438000472	20	Royall Elementary		Regular School	No	1.0	PK	03	2015	pre_kindergarten	1	1
123125	WI	Dodge	school	5513200	4998	Public school	Rubicon J6	551320001742	20	Saylesville Elementary		Regular School	No	1.0	PK	08	2015	pre_kindergarten	1	1
123187	WI	Milwaukee	school	5513260	5026	Public school	Saint Francis	551326001750	80	Willow Glen Primary School		Regular School	No	1.0	PK	03	2015	pre_kindergarten	1	1
123217	WI	Sauk	school	5513410	5100	Public school	Sauk Prairie	551341002663	100	Merrimac Community	charter	Regular School	Yes	1.0	PK	05	2015	pre_kindergarten	1	1
123453	WI	Sheboygan	school	5513650	5271	Public school	Sheboygan Area	551365001789	180	Lincoln-Erdman Elementary		Regular School	No	1.0	PK	05	2015	pre_kindergarten	1	1
123735	WI	Milwaukee	school	5514040	5439	Public school	South Milwaukee	551404001828	40	Lakeview Elementary		Regular School	No	1.0	PK	05	2015	pre_kindergarten	1	1
124148	WI	Marathon	school	5514580	5628	Public school	Stratford	551458000582	25	Stratford Elementary		Regular School	No	1.0	PK	05	2015	pre_kindergarten	1	1
124273	WI	Douglas	school	5514670	5663	Public school	Superior	551467001906	40	Bryant Elementary		Regular School	No	1.0	PK	05	2015	pre_kindergarten	1	1
124299	WI	Douglas	school	5514670	5663	Public school	Superior	551467000687	300	Great Lakes Elementary		Regular School	No	1.0	PK	05	2015	pre_kindergarten	1	1
124339	WI	Oconto	school	5514700	5670	Public school	Suring Public	551470001921	60	Suring Elementary		Regular School	No	1.0	PK	08	2015	pre_kindergarten	1	1
124547	WI	Kenosha	school	5500052	5780	Public school	Trevor-Wilmot Consolidated	550005202644	20	Trevor-Wilmot Grade		Regular School	No	1.0	PK	08	2015	pre_kindergarten	1	1
124579	WI	Barron	school	5515060	5810	Public school	Turtle Lake	551506001955	20	Turtle Lake Elementary		Regular School	No	1.0	PK	08	2015	pre_kindergarten	1	1
124617	WI	Manitowoc	school	5515120	5824	Public school	Two Rivers Public	551512002627	110	Magee Elementary		Regular School	No	1.0	PK	04	2015	pre_kindergarten	1	1
124808	WI	Forest	school	5515390	5992	Public school	Wabeno Area	551539001978	60	Wabeno Elementary		Regular School	No	1.0	PK	06	2015	pre_kindergarten	1	1
125435	WI	Milwaukee	school	5515990	6244	Public school	Wauwatosa	551599002082	120	Lincoln Elementary		Regular School	No	1.0	PK	05	2015	pre_kindergarten	1	1
125474	WI	Milwaukee	school	5515990	6244	Public school	Wauwatosa	551599002087	200	Roosevelt Elementary		Regular School	No	1.0	PK	05	2015	pre_kindergarten	1	1
125534	WI	Milwaukee	school	5515990	6244	Public school	Wauwatosa	551599002093	300	Wilson Elementary		Regular School	No	1.0	PK	05	2015	pre_kindergarten	1	1
125623	WI	Milwaukee	school	5516260	6300	Public school	West Allis-West Milwaukee	551626002108	160	Jefferson Elementary		Regular School	No	1.0	PK	05	2015	pre_kindergarten	1	1
125638	WI	Milwaukee	school	5516260	6300	Public school	West Allis-West Milwaukee	551626002114	280	Longfellow Elementary		Regular School	No	1.0	PK	05	2015	pre_kindergarten	1	1
125669	WI	Milwaukee	school	5516260	6300	Public school	West Allis-West Milwaukee	551626002119	380	Pershing Elementary		Regular School	No	1.0	PK	05	2015	pre_kindergarten	1	1
125701	WI	Milwaukee	school	5516260	6300	Public school	West Allis-West Milwaukee	551626002124	480	Wilson Elementary		Regular School	No	1.0	PK	05	2015	pre_kindergarten	1	1
125986	WI	Trempealeau	school	5516650	6426	Public school	Whitehall	551665002175	80	Whitehall Memorial Elementary		Regular School	No	1.0	PK	06	2015	pre_kindergarten	1	1
126132	WI	Sawyer	school	5516860	6615	Public school	Winter	551686002194	60	Winter Elementary		Regular School	No	1.0	PK	05	2015	pre_kindergarten	1	1
126353	WI	Vilas	school	5517160	6720	Public school	Woodruff J1	551716002227	20	Arbor Vitae-Woodruff Elementary		Regular School	No	1.0	PK	08	2015	pre_kindergarten	1	1
111804	WI	Green	school	5500120	63	Public school	Albany	550012000013	20	Albany Elementary		Regular School	No	1.0	PK	04	2015	pre_kindergarten	2	2
111948	WI	Langlade	school	5500360	140	Public school	Antigo Unified	550036000041	160	Mattoon Elementary		Regular School	No	1.0	PK	05	2015	pre_kindergarten	2	2
112124	WI	Outagamie	school	5500390	147	Public school	Appleton Area	550039002366	195	Houdini Elementary		Regular School	No	1.0	PK	06	2015	pre_kindergarten	2	2
112200	WI	Outagamie	school	5500390	147	Public school	Appleton Area	550039000062	340	Richmond Elementary		Regular School	No	1.0	PK	06	2015	pre_kindergarten	2	2
112271	WI	Lafayette	school	5500450	161	Public school	Argyle	550045000069	20	Argyle Elementary		Regular School	No	1.0	PK	05	2015	pre_kindergarten	2	2
112685	WI	Lafayette	school	5501020	364	Public school	Belmont Community	550102000134	20	Belmont Elementary		Regular School	No	1.0	PK	05	2015	pre_kindergarten	2	2
113006	WI	Shawano	school	5501560	623	Public school	Bowler	550156000199	20	Bowler Elementary		Regular School	No	1.0	PK	06	2015	pre_kindergarten	2	2
113071	WI	Kenosha	school	5501710	665	Public school	Bristol #1	550171000209	20	Bristol Elementary		Regular School	No	1.0	PK	08	2015	pre_kindergarten	2	2
113115	WI	Rusk	school	5501830	735	Public school	Bruce	550183000234	20	Bruce Elementary		Regular School	No	1.0	PK	05	2015	pre_kindergarten	2	2