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
283456	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	kindergarten_4_year_old	1	1
286116	WI	Brown	school	5506630	2604	Public school	Howard-Suamico	550663002409	40	Forest Glen Elementary		Regular School	No	1.0	PK	04	2016	kindergarten_4_year_old	1	1
287239	WI	La Crosse	school	5507530	2849	Public school	La Crosse	550753000195	110	Southern Bluffs Elementary		Regular School	No	1.0	PK	05	2016	kindergarten_4_year_old	1	1
290486	WI	Marathon	school		3787	Public Schools-Multidistrict Charters	Mosinee		9100	Rural Virtual Academy	charter						2016	kindergarten_4_year_old	1	1
292202	WI	Price	school		4571	Public Schools-Multidistrict Charters	Prentice		9100	Rural Virtual Academy	charter						2016	kindergarten_4_year_old	1	1
292451	WI	Racine	school	5512360	4620	Public school	Racine Unified	551236000458	172	P-COC		Regular School	No	1.0	PK	PK	2016	kindergarten_4_year_old	1	1
296190	WI	Wood	school	5517070	6685	Public school	Wisconsin Rapids	551707002791	180	Vesper Community Academy		Regular School	No	1.0	PK	05	2016	kindergarten_4_year_old	1	1
282838	WI	Washburn	school	5501170	441	Public school	Birchwood	550117000168	20	Birchwood Elementary		Regular School	No	1.0	PK	05	2016	kindergarten_4_year_old	10	10
285053	WI	Washington	school	5512880	4843	Public school	Friess Lake	551288001701	20	Friess Lake School		Regular School	No	1.0	PK	08	2016	kindergarten_4_year_old	10	10
285905	WI	Sawyer	school	5506270	2478	Public school	Hayward Community	550627003339	800	Hayward Ctr for Individualized Learning	charter	Regular School	Yes	4.0	PK	12	2016	kindergarten_4_year_old	10	10
291086	WI	Vilas	school	5501530	616	Public school	North Lakeland	550153000198	50	North Lakeland Elementary		Regular School	No	1.0	PK	08	2016	kindergarten_4_year_old	10	10
293722	WI	Bayfield	school	5512030	4522	Public school	South Shore	551203001571	40	South Shore Elementary		Regular School	No	1.0	PK	06	2016	kindergarten_4_year_old	10	10
285720	WI	Milwaukee	school	5505910	2296	Public school	Greendale	550591003347	110	Time 4 Learning Charter School	charter	Regular School	Yes	1.0	PK	PK	2016	kindergarten_4_year_old	100	100
295904	WI	Milwaukee	school	5516620	6419	Public school	Whitefish Bay	551662002169	80	Richards Elementary		Regular School	No	1.0	PK	05	2016	kindergarten_4_year_old	100	100
282930	WI	Chippewa	school	5501350	497	Public school	Bloomer	550135000183	20	Bloomer Elementary		Regular School	No	1.0	PK	04	2016	kindergarten_4_year_old	101	101
292597	WI	Sauk	school	5512660	4753	Public school	Reedsburg	551266002889	150	4K Community-Based		Regular School	No	1.0	PK	PK	2016	kindergarten_4_year_old	101	101
285478	WI	Brown	school	5505820	2289	Public school	Green Bay Area Public	550582002589	110	Green Bay Head Start		Regular School	No	1.0	PK	KG	2016	kindergarten_4_year_old	103	103
287497	WI	Outagamie	school	5508160	3129	Public school	Little Chute Area	550816000900	20	Little Chute Elementary		Regular School	No	1.0	PK	04	2016	kindergarten_4_year_old	103	103
284404	WI	Rock	school	5504110	1568	Public school	Edgerton	550411000442	40	Edgerton Community Elementary		Regular School	No	1.0	PK	05	2016	kindergarten_4_year_old	104	104
289797	WI	Milwaukee	school	5509600	3619	Public school	Milwaukee	550960001161	167	Milwaukee Spanish Immersion		Regular School	No	1.0	PK	05	2016	kindergarten_4_year_old	105	105
289206	WI	Milwaukee	school	5509600	3619	Public school	Milwaukee	550960001163	173	Forest Home Elementary		Regular School	No	1.0	PK	05	2016	kindergarten_4_year_old	106	106
281918	WI	Langlade	school	5500360	140	Public school	Antigo Unified	550036000041	160	Mattoon Elementary		Regular School	No	1.0	PK	05	2016	kindergarten_4_year_old	109	109
282509	WI	Barron	school	5500870	308	Public school	Barron Area	550087002717	100	Barron Area Montessori School	charter	Regular School	Yes	1.0	PK	04	2016	kindergarten_4_year_old	11	11
282792	WI	Lafayette	school	5501110	427	Public school	Benton	550111000160	20	Benton Elementary		Regular School	No	1.0	PK	06	2016	kindergarten_4_year_old	11	11
285219	WI	Buffalo	school	5505370	2142	Public school	Gilmanton	550537000573	40	Gilmanton Elementary		Regular School	No	1.0	PK	04	2016	kindergarten_4_year_old	11	11
286985	WI	Washington	school	5507380	2800	Public school	Kewaskum	550738000839	100	i4Learning Community School	charter	Regular School	Yes	1.0	PK	05	2016	kindergarten_4_year_old	11	11
289432	WI	Milwaukee	school	5509600	3619	Public school	Milwaukee	550960001208	253	Hopkins Lloyd		Regular School	No	1.0	PK	08	2016	kindergarten_4_year_old	11	11
293298	WI	Shawano	school	5513620	5264	Public school	Shawano	551362002908	110	LEADS Primary Charter School	charter	Regular School	Yes	1.0	PK	02	2016	kindergarten_4_year_old	11	11
294316	WI	Oneida	school	5514850	5733	Public school	Three Lakes	551485001927	40	Sugar Camp Elementary		Regular School	No	1.0	PK	06	2016	kindergarten_4_year_old	11	11
295959	WI	Walworth	school	5516680	6461	Public school	Whitewater Unified	551668002834	100	Whitewater 4K		Regular School	No	1.0	PK	PK	2016	kindergarten_4_year_old	11	11
284840	WI	Fond du Lac	school	5504680	1862	Public school	Fond du Lac	550468000497	120	Riverside Elementary		Regular School	No	1.0	PK	05	2016	kindergarten_4_year_old	113	113
282395	WI	Saint Croix	school	5500720	231	Public school	Baldwin-Woodville Area	550072000095	70	Greenfield Elementary		Regular School	No	1.0	PK	04	2016	kindergarten_4_year_old	117	117
289743	WI	Milwaukee	school	5509600	3619	Public school	Milwaukee	550960002340	140	Milwaukee French Immersion		Regular School	No	1.0	PK	05	2016	kindergarten_4_year_old	118	118
286736	WI	Kenosha	school	5507320	2793	Public school	Kenosha	550732002779	105	Kenosha 4 Year Old Kindergarten		Regular School	No	1.0	PK	PK	2016	kindergarten_4_year_old	119	119
291939	WI	Grant	school	5511850	4389	Public school	Platteville	551185001551	20	Wilkins Elementary		Regular School	No	1.0	PK	01	2016	kindergarten_4_year_old	119	119
281808	WI	Buffalo	school	5500180	84	Public school	Alma	550018000017	20	Alma Elementary		Regular School	No	1.0	PK	08	2016	kindergarten_4_year_old	12	12
282525	WI	Barron	school	5500870	308	Public school	Barron Area	550087000117	120	Ridgeland-Dallas Elementary		Regular School	No	1.0	PK	04	2016	kindergarten_4_year_old	12	12
283165	WI	Ashland	school	5501920	840	Public school	Butternut	550192000245	20	Butternut Elementary		Regular School	No	1.0	PK	05	2016	kindergarten_4_year_old	12	12
286542	WI	Green	school	5507230	2737	Public school	Juda	550723000784	20	Juda Elementary		Regular School	No	1.0	PK	08	2016	kindergarten_4_year_old	12	12
287434	WI	Forest	school	5507830	2940	Public school	Laona	550783000894	40	Robinson Elementary		Regular School	No	1.0	PK	06	2016	kindergarten_4_year_old	12	12
287474	WI	Walworth	school	5508070	3094	Public school	Linn J6	550807000899	20	Reek Elementary		Regular School	No	1.0	PK	08	2016	kindergarten_4_year_old	12	12
294384	WI	Monroe	school	5514910	5747	Public school	Tomah Area	551491001937	140	Oakdale Elementary		Regular School	No	1.0	PK	02	2016	kindergarten_4_year_old	12	12
294396	WI	Monroe	school	5514910	5747	Public school	Tomah Area	551491003028	110	Tomah Area Montessori School	charter	Regular School	Yes	1.0	PK	03	2016	kindergarten_4_year_old	12	12
296002	WI	Waushara	school	5516710	6475	Public school	Wild Rose	551671002183	20	Pleasant View Elementary		Regular School	No	1.0	PK	05	2016	kindergarten_4_year_old	12	12
287334	WI	Walworth	school	5507620	2885	Public school	Lake Geneva J1	550762000879	20	Central - Denison Elementary		Regular School	No	1.0	PK	03	2016	kindergarten_4_year_old	120	120
284683	WI	Rock	school	5504440	1694	Public school	Evansville Community	550444000477	20	Levi Leonard Elementary		Regular School	No	1.0	PK	02	2016	kindergarten_4_year_old	122	122
290463	WI	Marathon	school	5509960	3787	Public school	Mosinee	550996001307	80	Mosinee Elementary		Regular School	No	1.0	PK	03	2016	kindergarten_4_year_old	122	122
295971	WI	Milwaukee	school	5506000	6470	Public school	Whitnall	550600002673	130	CORE4	charter	Regular School	Yes	1.0	PK	PK	2016	kindergarten_4_year_old	122	122
286926	WI	Waukesha	school	5503510	1376	Public school	Kettle Moraine	550351002852	100	Kettle Moraine 4K		Regular School	No	1.0	PK	PK	2016	kindergarten_4_year_old	125	125
287182	WI	La Crosse	school	5507530	2849	Public school	La Crosse	550753002467	114	La Crosse Offsite Preschool		Regular School	No	1.0	PK	PK	2016	kindergarten_4_year_old	125	125
288281	WI	Dane	school	5508910	3381	Public school	McFarland	550891002902	150	4K McFarland		Regular School	No	1.0	PK	PK	2016	kindergarten_4_year_old	125	125
284564	WI	Pierce	school	5504320	1659	Public school	Ellsworth Community	550432000466	80	Lindgren Early Learning Center		Regular School	No	1.0	PK	PK	2016	kindergarten_4_year_old	126	126
290491	WI	Dane	school	5509990	3794	Public school	Mount Horeb Area	550999002994	150	Mount Horeb Area Community 4K		Regular School	No	1.0	PK	PK	2016	kindergarten_4_year_old	126	126
295709	WI	Brown	school	5516320	6328	Public school	West De Pere	551632002726	150	Hemlock Creek Elementary		Regular School	No	1.0	PK	05	2016	kindergarten_4_year_old	127	127
283202	WI	Columbia	school	5502070	882	Public school	Cambria-Friesland	550207000253	60	Cambria Friesland Elementary		Regular School	No	1.0	PK	05	2016	kindergarten_4_year_old	13	13
283328	WI	Grant	school	5502400	994	Public school	Cassville	550240000264	20	Cassville Elementary		Regular School	No	1.0	PK	06	2016	kindergarten_4_year_old	13	13
284184	WI	Racine	school	5503750	1449	Public school	Dover #1	550375000394	20	Kansasville Elementary		Regular School	No	1.0	PK	08	2016	kindergarten_4_year_old	13	13
285657	WI	Brown	school	5505820	2289	Public school	Green Bay Area Public	550582000643	700	Wequiock Elementary		Regular School	No	1.0	PK	05	2016	kindergarten_4_year_old	13	13
287149	WI	La Crosse	school	5507530	2849	Public school	La Crosse	550753001463	140	Coulee Montessori Charter School	charter	Regular School	Yes	1.0	PK	08	2016	kindergarten_4_year_old	13	13
288345	WI	Taylor	school	5508940	3409	Public school	Medford Area Public	550894002598	9100	Rural Virtual Academy	charter	Regular School	Yes	4.0	PK	10	2016	kindergarten_4_year_old	13	13
288597	WI	Iron	school	5509150	3484	Public school	Mercer	550915001092	40	Mercer School		Regular School	No	4.0	PK	12	2016	kindergarten_4_year_old	13	13
289564	WI	Milwaukee	school	5509600	3619	Public school	Milwaukee	550960001202	238	LaFollette Elementary		Regular School	No	1.0	PK	08	2016	kindergarten_4_year_old	13	13
291169	WI	Vilas	school	5503860	1526	Public school	Northland Pines	550386003008	110	Northland Pines Montessori Learning Center (NPMLC)	charter	Regular School	Yes	1.0	PK	04	2016	kindergarten_4_year_old	13	13
291229	WI	Racine	school	5510800	4011	Public school	Norway J7	551080001405	20	Drought Elementary		Regular School	No	1.0	PK	08	2016	kindergarten_4_year_old	13	13
291948	WI	Pierce	school	5511880	4459	Public school	Plum City	551188001556	20	Plum City Elementary		Regular School	No	1.0	PK	05	2016	kindergarten_4_year_old	13	13
292047	WI	Columbia	school	5512060	4501	Public school	Portage Community	551206002419	120	Endeavor Elementary		Regular School	No	1.0	PK	05	2016	kindergarten_4_year_old	13	13
292725	WI	Barron	school	5512810	4802	Public school	Rice Lake Area	551281001693	60	Haugen Elementary		Regular School	No	1.0	PK	04	2016	kindergarten_4_year_old	13	13
294009	WI	Calumet	school	5514520	5614	Public school	Stockbridge	551452001882	20	Stockbridge Elementary		Regular School	No	1.0	PK	05	2016	kindergarten_4_year_old	13	13
294413	WI	Monroe	school	5514910	5747	Public school	Tomah Area	551491001940	220	Warrens Elementary		Regular School	No	1.0	PK	05	2016	kindergarten_4_year_old	13	13
295480	WI	Crawford	school	5516020	6251	Public school	Wauzeka-Steuben	551602002094	20	Wauzeka Elementary		Regular School	No	1.0	PK	05	2016	kindergarten_4_year_old	13	13
295881	WI	Langlade	school	5516590	6440	Public school	White Lake	551659002164	20	White Lake Elementary		Regular School	No	1.0	PK	06	2016	kindergarten_4_year_old	13	13
296068	WI	Sawyer	school	5516860	6615	Public school	Winter	551686002194	60	Winter Elementary		Regular School	No	1.0	PK	05	2016	kindergarten_4_year_old	13	13
293159	WI	Sauk	school	5513410	5100	Public school	Sauk Prairie	551341001761	150	Bridges Elementary		Regular School	No	1.0	PK	02	2016	kindergarten_4_year_old	131	131
289334	WI	Milwaukee	school	5509600	3619	Public school	Milwaukee	550960002979	880	HAPA-Hmong Amer Peace Academy K3-12	charter	Regular School	Yes	4.0	PK	12	2016	kindergarten_4_year_old	132	132
292072	WI	Columbia	school	5512060	4501	Public school	Portage Community	551206002945	190	Portage Partnering Preschool		Regular School	No	1.0	PK	04	2016	kindergarten_4_year_old	138	138
284027	WI	Vernon	school	5503240	1421	Public school	De Soto Area	550324000368	80	Prairie View Elementary		Regular School	No	1.0	PK	05	2016	kindergarten_4_year_old	14	14
285678	WI	Green Lake	school	5505880	2310	Public school	Green Lake	550588000646	20	Green Lake Elementary		Regular School	No	1.0	PK	06	2016	kindergarten_4_year_old	14	14
285948	WI	Iowa	school	5506420	2527	Public school	Highland	550642000698	20	Highland Community Elementary	charter	Regular School	Yes	1.0	PK	05	2016	kindergarten_4_year_old	14	14
287784	WI	Dane	school	5508520	3269	Public school	Madison Metropolitan	550852000921	65	Lindbergh Elementary		Regular School	No	1.0	PK	05	2016	kindergarten_4_year_old	14	14
292095	WI	Grant	school	5512090	4529	Public school	Potosi	551209001575	20	Potosi Elementary		Regular School	No	1.0	PK	05	2016	kindergarten_4_year_old	14	14
284899	WI	Jefferson	school	5504740	1883	Public school	Fort Atkinson	550474002749	130	Fort Atkinson 4K		Regular School	No	1.0	PK	PK	2016	kindergarten_4_year_old	141	141
283116	WI	Milwaukee	school	5500059	8123	Non District Charter Schools	Bruce Guadalupe	550005900772	100	Bruce Guadalupe	charter	Regular School	Yes	1.0	PK	08	2016	kindergarten_4_year_old	144	144
295131	WI	Fond du Lac	school	5515870	6216	Public school	Waupun	551587002044	160	Meadow View Primary		Regular School	No	1.0	PK	01	2016	kindergarten_4_year_old	145	145
290383	WI	Green	school	5509840	3682	Public school	Monroe	550984002771	10	Abraham Lincoln Elementary		Regular School	No	1.0	PK	05	2016	kindergarten_4_year_old	146	146
282986	WI	Shawano	school	5501560	623	Public school	Bowler	550156000199	20	Bowler Elementary		Regular School	No	1.0	PK	06	2016	kindergarten_4_year_old	15	15
285324	WI	Clark	school	5505640	2226	Public school	Granton Area	550564000599	20	Granton Elementary		Regular School	No	1.0	PK	05	2016	kindergarten_4_year_old	15	15
286403	WI	Rock	school	5507020	2695	Public school	Janesville	550702000767	220	Madison Elementary		Regular School	No	1.0	PK	05	2016	kindergarten_4_year_old	15	15
290447	WI	Green	school	5509900	3696	Public school	Monticello	550990001304	20	Monticello Elementary		Regular School	No	1.0	PK	05	2016	kindergarten_4_year_old	15	15
282429	WI	Sauk	school	5500810	280	Public school	Baraboo	550081002803	150	Baraboo Early Learning Cooperative		Regular School	No	1.0	PK	PK	2016	kindergarten_4_year_old	152	152
295108	WI	Waupaca	school	5515840	6195	Public school	Waupaca	551584003007	170	Waupaca Community 4-Year Old Kindergarten		Regular School	No	1.0	PK	PK	2016	kindergarten_4_year_old	152	152
291870	WI	Waukesha	school	5511640	4312	Public school	Pewaukee	551164001536	60	Pewaukee Lake Elementary		Regular School	No	1.0	PK	03	2016	kindergarten_4_year_old	155	155
293805	WI	Monroe	school	5514160	5460	Public school	Sparta Area	551416002465	130	Sparta Charter Prekindergarten	charter	Regular School	Yes	1.0	PK	PK	2016	kindergarten_4_year_old	155	155
288644	WI	Lincoln	school	5509210	3500	Public school	Merrill Area	550921000746	240	Pine River School for Young Learners (PRSYL)		Regular School	No	1.0	PK	PK	2016	kindergarten_4_year_old	157	157
283095	WI	Rusk	school	5501830	735	Public school	Bruce	550183000234	20	Bruce Elementary		Regular School	No	1.0	PK	05	2016	kindergarten_4_year_old	16	16
283816	WI	Milwaukee	school	5503060	1253	Public school	Cudahy	550306000338	50	Mitchell Elementary		Regular School	No	1.0	PK	05	2016	kindergarten_4_year_old	16	16
285205	WI	Taylor	school	5505280	2135	Public school	Gilman	550528000567	40	Gilman Elementary		Regular School	No	1.0	PK	06	2016	kindergarten_4_year_old	16	16
287370	WI	Chippewa	school	5507680	2891	Public school	Lake Holcombe	550768000885	20	Holcombe Elementary		Regular School	No	1.0	PK	08	2016	kindergarten_4_year_old	16	16
287652	WI	Dane	school	5508520	3269	Public school	Madison Metropolitan	550852000924	105	Crestwood Elementary		Regular School	No	1.0	PK	05	2016	kindergarten_4_year_old	16	16
289024	WI	Milwaukee	school	5509600	3619	Public school	Milwaukee	550960001140	110	Clarke Street Elementary		Regular School	No	1.0	PK	08	2016	kindergarten_4_year_old	16	16
291154	WI	Vilas	school	5503860	1526	Public school	Northland Pines	550386000408	100	Northland Pines Elementary-St Germain		Regular School	No	1.0	PK	05	2016	kindergarten_4_year_old	16	16
293213	WI	Crawford	school	5513470	5124	Public school	Seneca	551347001764	60	Seneca Elementary		Regular School	No	1.0	PK	05	2016	kindergarten_4_year_old	16	16