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
283645	WI	Clark	school		1162	Public Schools-Multidistrict Charters	Colby		9100	Rural Virtual Academy	charter						2016	grade_4	1	1
283855	WI	Barron	school	5503090	1260	Public school	Cumberland	550309002871	800	Island City Virtual Academy	charter	Regular School	Yes	4.0	PK	12	2016	grade_4	1	1
284913	WI	Jefferson	school		1883	Public Schools-Multidistrict Charters	Fort Atkinson		9803	JEDI Virtual K-12	charter						2016	grade_4	1	1
285172	WI	Oconto	school	5505250	2128	Public school	Gillett	550525002892	100	CRE8 Charter School	charter	Regular School	Yes	1.0	PK	05	2016	grade_4	1	1
287378	WI	Jefferson	school		2898	Public Schools-Multidistrict Charters	Lake Mills Area		9803	JEDI Virtual K-12	charter						2016	grade_4	1	1
288242	WI	Juneau	school	5508850	3360	Public school	Mauston	550885001024	40	Lyndon Station Elementary		Regular School	No	1.0	KG	05	2016	grade_4	1	1
292146	WI	Crawford	school	5512150	4543	Public school	Prairie du Chien Area	551215002944	800	Mighty River Academy of Virtual Education	charter	Regular School	Yes	4.0	KG	12	2016	grade_4	1	1
292717	WI	Taylor	school		4795	Public Schools-Multidistrict Charters	Rib Lake		9100	Rural Virtual Academy	charter						2016	grade_4	1	1
294071	WI	Marathon	school		5628	Public Schools-Multidistrict Charters	Stratford		9100	Rural Virtual Academy	charter						2016	grade_4	1	1
294153	WI	Dane	school		5656	Public Schools-Multidistrict Charters	Sun Prairie Area		9803	JEDI Virtual K-12	charter						2016	grade_4	1	1
282921	WI	Trempealeau	school	5500016	485	Public school	Blair-Taylor	550001603359	120	SoSET Charter School	charter	Regular School	Yes	1.0	KG	06	2016	grade_4	10	10
287458	WI	Walworth	school	5508040	3087	Public school	Linn J4	550804000898	20	Traver Elementary		Regular School	No	1.0	PK	08	2016	grade_4	10	10
287481	WI	Outagamie	school	5508160	3129	Public school	Little Chute Area	550816002959	130	Flex Academy	charter	Regular School	Yes	1.0	KG	08	2016	grade_4	10	10
293073	WI	Dodge	school	5513200	4998	Public school	Rubicon J6	551320001742	20	Saylesville Elementary		Regular School	No	1.0	PK	08	2016	grade_4	10	10
295878	WI	Langlade	school	5516590	6440	Public school	White Lake	551659002164	20	White Lake Elementary		Regular School	No	1.0	PK	06	2016	grade_4	10	10
284542	WI	Walworth	school	5504290	1638	Public school	Elkhorn Area	550429000462	100	West Side Elementary		Regular School	No	1.0	PK	05	2016	grade_4	100	100
287083	WI	Outagamie	school	5507470	2835	Public school	Kimberly Area	550747000732	60	Sunrise Elementary		Regular School	No	1.0	KG	04	2016	grade_4	100	100
288580	WI	Ozaukee	school	5509130	3479	Public school	Mequon-Thiensville	550913001090	160	Wilson Elementary		Regular School	No	1.0	PK	05	2016	grade_4	100	100
290099	WI	Milwaukee	school	5509600	3619	Public school	Milwaukee	550960002967	875	Universal Academy for the College Bound	charter	Regular School	Yes	4.0	PK	12	2016	grade_4	100	100
291516	WI	Dane	school	5511100	4144	Public school	Oregon	551110001472	50	Prairie View Elementary		Regular School	No	1.0	PK	04	2016	grade_4	100	100
295646	WI	Washington	school	5516290	6307	Public school	West Bend	551629002127	40	Decorah Elementary		Regular School	No	1.0	PK	04	2016	grade_4	100	100
283989	WI	Brown	school	5503210	1414	Public school	De Pere	550321000363	40	Dickinson Elementary		Regular School	No	1.0	PK	04	2016	grade_4	101	101
285820	WI	Waukesha	school	5506030	2420	Public school	Hamilton	550603000667	120	Marcy Elementary		Regular School	No	1.0	KG	05	2016	grade_4	102	102
286074	WI	Outagamie	school	5506600	2583	Public school	Hortonville Area	550660000714	20	Hortonville Elementary		Regular School	No	1.0	PK	04	2016	grade_4	102	102
288170	WI	Wood	school	5508820	3339	Public school	Marshfield Unified	550882001016	40	Grant Elementary		Regular School	No	1.0	KG	06	2016	grade_4	102	102
291652	WI	Winnebago	school	5511190	4179	Public school	Oshkosh Area	551119001359	150	Traeger Elementary		Regular School	No	1.0	PK	05	2016	grade_4	102	102
295664	WI	Washington	school	5516290	6307	Public school	West Bend	551629002130	70	Green Tree Elementary		Regular School	No	1.0	PK	04	2016	grade_4	102	102
296048	WI	Winnebago	school	5516830	6608	Public school	Winneconne Community	551683002190	40	Winneconne Elementary		Regular School	No	1.0	PK	05	2016	grade_4	102	102
282279	WI	Ashland	school	5500510	170	Public school	Ashland	550051000076	60	Lake Superior Intermediate		Regular School	No	1.0	03	05	2016	grade_4	103	103
286115	WI	Brown	school	5506630	2604	Public school	Howard-Suamico	550663002409	40	Forest Glen Elementary		Regular School	No	1.0	PK	04	2016	grade_4	103	103
289595	WI	Milwaukee	school	5509600	3619	Public school	Milwaukee	550960001209	256	Longfellow Elementary		Regular School	No	1.0	PK	08	2016	grade_4	103	103
290966	WI	Saint Croix	school	5510620	3962	Public school	New Richmond	551062002789	170	New Richmond Hillside Elementary		Regular School	No	1.0	KG	05	2016	grade_4	103	103
286754	WI	Kenosha	school	5507320	2793	Public school	Kenosha	550732002758	190	Kenosha School of Technology Enhanced Curriculum	charter	Regular School	Yes	1.0	PK	08	2016	grade_4	104	104
292363	WI	Racine	school	5512360	4620	Public school	Racine Unified	551236001623	132	Jefferson Lighthouse Elementary		Regular School	No	1.0	KG	05	2016	grade_4	104	104
294244	WI	Douglas	school	5514670	5663	Public school	Superior	551467002539	115	Northern Lights Elementary		Regular School	No	1.0	PK	05	2016	grade_4	104	104
284576	WI	Waukesha	school	5501770	714	Public school	Elmbrook	550177000216	40	Brookfield Elementary		Regular School	No	1.0	PK	05	2016	grade_4	105	105
287770	WI	Dane	school	5508520	3269	Public school	Madison Metropolitan	550852000944	475	Leopold Elementary		Regular School	No	1.0	PK	05	2016	grade_4	105	105
281856	WI	Eau Claire	school	5500270	112	Public school	Altoona	550027002925	100	Altoona Intermediate		Regular School	No	2.0	04	05	2016	grade_4	106	106
285888	WI	Waukesha	school	5506140	2460	Public school	Hartland-Lakeside J3	550614002258	40	South Elementary		Regular School	No	1.0	03	05	2016	grade_4	106	106
293148	WI	Kenosha	school	5513350	5068	Public school	Salem	551335001753	20	Salem Elementary		Regular School	No	1.0	PK	08	2016	grade_4	106	106
284249	WI	Walworth	school	5504020	1540	Public school	East Troy Community	550402001640	100	Prairie View Elementary		Regular School	No	1.0	02	05	2016	grade_4	107	107
283076	WI	Milwaukee	school	5501800	721	Public school	Brown Deer	550180000232	80	Brown Deer Elementary		Regular School	No	1.0	PK	06	2016	grade_4	109	109
283969	WI	Dane	school	5503180	1316	Public school	De Forest Area	550318000360	140	Windsor Elementary		Regular School	No	1.0	KG	04	2016	grade_4	109	109
289203	WI	Milwaukee	school	5509600	3619	Public school	Milwaukee	550960001163	173	Forest Home Elementary		Regular School	No	1.0	PK	05	2016	grade_4	109	109
282061	WI	Outagamie	school	5500390	147	Public school	Appleton Area	550039002582	135	Fox River Academy	charter	Regular School	Yes	1.0	01	08	2016	grade_4	11	11
293719	WI	Bayfield	school	5512030	4522	Public school	South Shore	551203001571	40	South Shore Elementary		Regular School	No	1.0	PK	06	2016	grade_4	11	11
295794	WI	Marquette	school	5516440	6335	Public school	Westfield	551644002149	60	Oxford Elementary		Regular School	No	1.0	PK	06	2016	grade_4	11	11
296188	WI	Wood	school	5517070	6685	Public school	Wisconsin Rapids	551707002791	180	Vesper Community Academy		Regular School	No	1.0	PK	05	2016	grade_4	11	11
282394	WI	Saint Croix	school	5500720	231	Public school	Baldwin-Woodville Area	550072000095	70	Greenfield Elementary		Regular School	No	1.0	PK	04	2016	grade_4	110	110
293093	WI	Saint Croix	school	5506060	2422	Public school	Saint Croix Central	550606000671	40	Saint Croix Central Elementary		Regular School	No	1.0	PK	04	2016	grade_4	110	110
285233	WI	Milwaukee	school	5505460	2184	Public school	Glendale-River Hills	550546000575	10	Glen Hills Middle		Regular School	No	2.0	04	08	2016	grade_4	111	111
293259	WI	Outagamie	school	5513530	5138	Public school	Seymour Community	551353001771	60	Rock Ledge Elementary		Regular School	No	1.0	PK	05	2016	grade_4	111	111
283111	WI	Milwaukee	school	5500059	8123	Non District Charter Schools	Bruce Guadalupe	550005900772	100	Bruce Guadalupe	charter	Regular School	Yes	1.0	PK	08	2016	grade_4	112	112
293659	WI	Saint Croix	school	5514010	5432	Public school	Somerset	551401001824	20	Somerset Elementary		Regular School	No	1.0	PK	04	2016	grade_4	112	112
288220	WI	Juneau	school	5508850	3360	Public school	Mauston	550885002574	100	Grayside Elementary		Regular School	No	1.0	03	05	2016	grade_4	113	113
295677	WI	Washington	school	5516290	6307	Public school	West Bend	551629002132	100	McLane Elementary		Regular School	No	1.0	PK	04	2016	grade_4	113	113
282774	WI	Rock	school	5501080	422	Public school	Beloit Turner	550108000158	100	Townview Elementary		Regular School	No	1.0	03	05	2016	grade_4	114	114
284472	WI	Dunn	school	5504230	1645	Public school	Elk Mound Area	550423000454	60	Mound View Elementary		Regular School	No	1.0	PK	04	2016	grade_4	114	114
281876	WI	Polk	school	5500300	119	Public school	Amery	550030000075	50	Amery Intermediate		Regular School	No	1.0	03	05	2016	grade_4	115	115
284583	WI	Waukesha	school	5501770	714	Public school	Elmbrook	550177000218	80	Burleigh Elementary		Regular School	No	1.0	PK	05	2016	grade_4	115	115
286791	WI	Kenosha	school	5507320	2793	Public school	Kenosha	550732002653	170	Nash Elementary		Regular School	No	1.0	PK	05	2016	grade_4	116	116
295137	WI	Fond du Lac	school	5515870	6216	Public school	Waupun	551587002809	110	Rock River Intermediate		Regular School	No	1.0	02	06	2016	grade_4	116	116
282814	WI	Green Lake	school	5501140	434	Public school	Berlin Area	550114000163	60	Clay Lamberton Elementary		Regular School	No	1.0	PK	05	2016	grade_4	117	117
291929	WI	Grant	school	5511850	4389	Public school	Platteville	551185001554	80	Platteville Middle		Regular School	No	2.0	04	08	2016	grade_4	117	117
282672	WI	Rock	school	5501050	413	Public school	Beloit	550105000137	20	Aldrich Intermediate		Regular School	No	2.0	04	08	2016	grade_4	118	118
286061	WI	Outagamie	school	5506600	2583	Public school	Hortonville Area	550660002407	10	Greenville Elementary		Regular School	No	1.0	PK	04	2016	grade_4	119	119
287603	WI	Kewaunee	school	5508340	3220	Public school	Luxemburg-Casco	550834000916	100	Luxemburg-Casco Intermediate		Regular School	No	1.0	03	06	2016	grade_4	119	119
289328	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	grade_4	119	119
285218	WI	Buffalo	school	5505370	2142	Public school	Gilmanton	550537000573	40	Gilmanton Elementary		Regular School	No	1.0	PK	04	2016	grade_4	12	12
294313	WI	Oneida	school	5514850	5733	Public school	Three Lakes	551485001927	40	Sugar Camp Elementary		Regular School	No	1.0	PK	06	2016	grade_4	12	12
284688	WI	Rock	school	5504440	1694	Public school	Evansville Community	550444002552	100	Theodore Robinson Intermediate School		Regular School	No	1.0	03	05	2016	grade_4	120	120
295902	WI	Milwaukee	school	5516620	6419	Public school	Whitefish Bay	551662002169	80	Richards Elementary		Regular School	No	1.0	PK	05	2016	grade_4	120	120
282322	WI	Brown	school	5500540	182	Public school	Ashwaubenon	550054000085	60	Valley View Elementary		Regular School	No	1.0	01	05	2016	grade_4	122	122
295730	WI	Brown	school	5516320	6328	Public school	West De Pere	551632002139	140	Westwood Elementary		Regular School	No	1.0	PK	05	2016	grade_4	122	122
288320	WI	Taylor	school	5508940	3409	Public school	Medford Area Public	550894002361	180	Medford Elementary		Regular School	No	1.0	PK	04	2016	grade_4	123	123
282710	WI	Rock	school	5501050	413	Public school	Beloit	550105003011	170	Fran Fruzen Intermediate School		Regular School	No	2.0	04	08	2016	grade_4	124	124
291536	WI	Polk	school	5511160	4165	Public school	Osceola	551116001073	50	Osceola Intermediate		Regular School	No	1.0	03	05	2016	grade_4	124	124
292328	WI	Racine	school	5512360	4620	Public school	Racine Unified	551236002311	119	Gifford Elementary		Regular School	No	1.0	PK	05	2016	grade_4	124	124
282895	WI	Jackson	school	5501260	476	Public school	Black River Falls	550126000177	100	Gebhardt Elementary		Regular School	No	2.0	04	05	2016	grade_4	125	125
284619	WI	Waukesha	school	5501770	714	Public school	Elmbrook	550177001217	190	Swanson Elementary		Regular School	No	1.0	PK	05	2016	grade_4	126	126
287383	WI	Jefferson	school	5507710	2898	Public school	Lake Mills Area	550771000889	100	Lake Mills Elementary		Regular School	No	1.0	PK	04	2016	grade_4	126	126
282729	WI	Rock	school	5501050	413	Public school	Beloit	550105002330	180	McNeel Intermediate		Regular School	No	2.0	04	08	2016	grade_4	127	127
286580	WI	Outagamie	school	5507290	2758	Public school	Kaukauna Area	550729000796	100	Quinney Elementary		Regular School	No	1.0	02	04	2016	grade_4	128	128
286135	WI	Brown	school	5506630	2604	Public school	Howard-Suamico	550663000718	50	Meadowbrook Elementary		Regular School	No	1.0	PK	04	2016	grade_4	129	129
281932	WI	Langlade	school	5500360	140	Public school	Antigo Unified	550036000043	200	Pleasant View Elementary		Regular School	No	1.0	PK	05	2016	grade_4	13	13
283134	WI	Racine	school	5501890	777	Public school	Burlington Area	550189002462	110	Dr Edward G Dyer School		Regular School	No	2.0	04	06	2016	grade_4	13	13
283163	WI	Ashland	school	5501920	840	Public school	Butternut	550192000245	20	Butternut Elementary		Regular School	No	1.0	PK	05	2016	grade_4	13	13
285059	WI	Trempealeau	school	5504960	2009	Public school	Galesville-Ettrick-Trempealeau	550496000535	20	Ettrick Elementary		Regular School	No	1.0	PK	05	2016	grade_4	13	13
289456	WI	Milwaukee	school	5509600	3619	Public school	Milwaukee	550960002493	165	IDEAL	charter	Regular School	Yes	1.0	PK	08	2016	grade_4	13	13
291152	WI	Vilas	school	5503860	1526	Public school	Northland Pines	550386000408	100	Northland Pines Elementary-St Germain		Regular School	No	1.0	PK	05	2016	grade_4	13	13
291224	WI	Racine	school	5510800	4011	Public school	Norway J7	551080001405	20	Drought Elementary		Regular School	No	1.0	PK	08	2016	grade_4	13	13
291877	WI	Vilas	school	5511710	4330	Public school	Phelps	551171001539	10	Phelps Elementary		Regular School	No	1.0	PK	08	2016	grade_4	13	13
294946	WI	Waukesha	school	5515780	6174	Public school	Waukesha	551578003003	150	eAchieve Elementary	charter	Regular School	Yes	1.0	KG	05	2016	grade_4	13	13
295838	WI	Waupaca	school	5516500	6384	Public school	Weyauwega-Fremont	551650002157	40	Fremont Elementary		Regular School	No	1.0	PK	05	2016	grade_4	13	13
293477	WI	Sheboygan	school	5513680	5278	Public school	Sheboygan Falls	551368001801	20	Sheboygan Falls Elementary		Regular School	No	1.0	PK	04	2016	grade_4	132	132
295100	WI	Dane	school	5515810	6181	Public school	Waunakee Community	551581001198	100	Waunakee Prairie Elementary		Regular School	No	1.0	PK	04	2016	grade_4	132	132
287775	WI	Dane	school	5508520	3269	Public school	Madison Metropolitan	550852002263	15	Lincoln Elementary		Regular School	No	1.0	PK	05	2016	grade_4	133	133
294864	WI	Jefferson	school	5515750	6125	Public school	Watertown Unified	551575001997	40	Douglas Elementary		Regular School	No	1.0	KG	05	2016	grade_4	133	133
295739	WI	La Crosse	school	5516350	6370	Public school	West Salem	551635002140	60	West Salem Elementary		Regular School	No	1.0	PK	05	2016	grade_4	133	133
287862	WI	Dane	school	5508520	3269	Public school	Madison Metropolitan	550852000954	645	Randall Elementary		Regular School	No	1.0	03	05	2016	grade_4	134	134
295121	WI	Waupaca	school	5515840	6195	Public school	Waupaca	551584001203	70	Waupaca Learning Center Elementary		Regular School	No	1.0	PK	04	2016	grade_4	134	134