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 order by total desc 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
116090	WI	Outagamie	school	5506600	2583	Public school	Hortonville Area	550660002408	30	Hortonville Middle		Regular School	No	2.0	05	08	2015	grade_7	99	99
123716	WI	Saint Croix	school	5514010	5432	Public school	Somerset	551401001108	60	Somerset Middle		Regular School	No	2.0	05	08	2015	grade_7	99	99
284943	WI	Milwaukee	school	5504800	1890	Public school	Fox Point J2	550480000517	20	Bayside Middle		Regular School	No	2.0	05	08	2016	grade_7	99	99
287509	WI	Outagamie	school	5508160	3129	Public school	Little Chute Area	550816000902	60	Little Chute Middle		Regular School	No	2.0	07	08	2016	grade_7	99	99
289331	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_7	99	99
289828	WI	Milwaukee	school	5509600	3619	Public school	Milwaukee	550960001221	52	Morse Marshall		Regular School	No	4.0	06	12	2016	grade_7	99	99
296307	WI	Brown	school	5517190	6734	Public school	Wrightstown Community	551719000280	30	Wrightstown Middle		Regular School	No	2.0	05	08	2016	grade_7	99	99
327601	WI	Columbia	school	5502820	1183	Public school	Columbus	550282000319	20	Columbus Middle		Regular School	No	Elementary	04	08	2017	grade_7	99	99
331381	WI	Outagamie	school	5508160	3129	Public school	Little Chute Area	550816000902	60	Little Chute Middle		Regular School	No	Middle	07	08	2017	grade_7	99	99
2334115	WI	Chippewa	school	5501350	497	Public school	Bloomer	550135000185	60	Bloomer Middle		Regular School	No	Middle	05	08	2021	grade_7	99	99
2335953	WI	Rock	school	5504440	1694	Public school	Evansville Community	550444000479	60	J C McKenna Middle		Regular School	No	Middle	06	08	2021	grade_7	99	99
3075235	WI	Kenosha	school	5501710	665	Public school	Bristol #1	550171000209	20	Bristol Elementary		Regular School	No	Elementary	PK	08	2019	grade_7	99	99
3102331	WI	Waushara	school	5515960	6237	Public school	Wautoma Area	551596002071	30	Parkside School		Regular School	No	Middle	04	08	2018	grade_7	99	99
119628	WI	Milwaukee	school	5509600	3619	Public school	Milwaukee	550960001209	256	Longfellow Elementary		Regular School	No	1.0	PK	08	2015	grade_7	98	98
2333886	WI	Rock	school	5501050	413	Public school	Beloit	550105000140	80	Cunningham Intermediate		Regular School	No	Middle	04	08	2021	grade_7	98	98
2346079	WI	Racine	school	5515180	5859	Public school	Union Grove J1	551518001964	20	Union Grove Elementary		Regular School	No	Elementary	PK	08	2021	grade_7	98	98
2347380	WI	Marquette	school	5516440	6335	Public school	Westfield	551644002535	200	Westfield Area Middle		Regular School	No	Middle	07	08	2021	grade_7	98	98
3086698	WI	Lincoln	school	5514940	5754	Public school	Tomahawk	551494001948	220	Tomahawk Middle		Regular School	No	Middle	06	08	2019	grade_7	98	98
3100853	WI	Chippewa	school	5514430	5593	Public school	Stanley-Boyd Area	551443001866	100	Stanley-Boyd Middle		Regular School	No	Middle	06	08	2018	grade_7	98	98
115881	WI	Waukesha	school	5506140	2460	Public school	Hartland-Lakeside J3	550614001282	100	North Shore Middle		Regular School	No	2.0	06	08	2015	grade_7	97	97
282530	WI	Barron	school	5500870	308	Public school	Barron Area	550087000118	140	Riverview Middle		Regular School	No	2.0	05	08	2016	grade_7	97	97
294564	WI	Racine	school	5515180	5859	Public school	Union Grove J1	551518001964	20	Union Grove Elementary		Regular School	No	1.0	PK	08	2016	grade_7	97	97
336858	WI	Sauk	school	5514250	5523	Public school	River Valley	551425001856	100	River Valley Middle		Regular School	No	Middle	06	08	2017	grade_7	97	97
2323637	WI	La Crosse	school	5507530	2849	Public school	La Crosse	550753000863	180	Lincoln Middle		Regular School	No	Middle	06	08	2020	grade_7	97	97
2340220	WI	Milwaukee	school	5509600	3619	Public school	Milwaukee	550960003123	215	Andrew S Douglas Middle		Regular School	No	Middle	06	08	2021	grade_7	97	97
3087359	WI	Waukesha	school	5515780	6174	Public school	Waukesha	551578002023	400	Waukesha STEM Academy	charter	Regular School	Yes	Elementary	PK	08	2019	grade_7	97	97
112549	WI	Barron	school	5500870	308	Public school	Barron Area	550087000118	140	Riverview Middle		Regular School	No	2.0	05	08	2015	grade_7	96	96
124176	WI	Door	school	5514610	5642	Public school	Sturgeon Bay	551461002322	80	Walker Middle		Regular School	No	2.0	06	08	2015	grade_7	96	96
287049	WI	Manitowoc	school	5507440	2828	Public school	Kiel Area	550744000845	60	Kiel Middle		Regular School	No	2.0	05	08	2016	grade_7	96	96
291646	WI	Winnebago	school	5511190	4179	Public school	Oshkosh Area	551119001497	320	Tipler Middle		Regular School	No	2.0	06	08	2016	grade_7	96	96
292797	WI	Richland	school	5512960	4851	Public school	Richland	551296001708	280	Richland Middle		Regular School	No	2.0	06	08	2016	grade_7	96	96
333468	WI	Milwaukee	school	5509600	3619	Public school	Milwaukee	550960001209	256	Longfellow Elementary		Regular School	No	Elementary	PK	08	2017	grade_7	96	96
2319685	WI	Barron	school	5502130	903	Public school	Cameron	550213002286	200	Cameron Middle		Regular School	No	Middle	05	08	2020	grade_7	96	96
3075484	WI	Fond du Lac	school	5502160	910	Public school	Campbellsport	550216002484	300	Campbellsport Middle		Regular School	No	Middle	06	08	2019	grade_7	96	96
3103326	WI	Brown	school	5517190	6734	Public school	Wrightstown Community	551719000280	30	Wrightstown Middle		Regular School	No	Middle	05	08	2018	grade_7	96	96
2329607	WI	Polk	school	5513230	5019	Public school	Saint Croix Falls	551323002314	70	Saint Croix Falls Middle		Regular School	No	Middle	05	08	2020	grade_7	95	95
2333849	WI	Rock	school	5501050	413	Public school	Beloit	550105000137	20	Aldrich Intermediate		Regular School	No	Middle	04	08	2021	grade_7	95	95
2335482	WI	Walworth	school	5504020	1540	Public school	East Troy Community	550402000411	60	East Troy Middle		Regular School	No	Middle	06	08	2021	grade_7	95	95
2343640	WI	Pierce	school	5512240	4578	Public school	Prescott	551224001593	80	Prescott Middle		Regular School	No	Middle	06	08	2021	grade_7	95	95
3079722	WI	Outagamie	school	5508160	3129	Public school	Little Chute Area	550816000902	60	Little Chute Middle		Regular School	No	Middle	07	08	2019	grade_7	95	95
3088624	WI	Brown	school	5517190	6734	Public school	Wrightstown Community	551719000280	30	Wrightstown Middle		Regular School	No	Middle	05	08	2019	grade_7	95	95
3095603	WI	Waukesha	school	5509360	3528	Public school	Merton Community	550936002269	20	Merton Intermediate		Regular School	No	Middle	05	08	2018	grade_7	95	95
113300	WI	Fond du Lac	school	5502160	910	Public school	Campbellsport	550216002484	300	Campbellsport Middle		Regular School	No	2.0	06	08	2015	grade_7	94	94
117196	WI	La Crosse	school	5507530	2849	Public school	La Crosse	550753000863	180	Lincoln Middle		Regular School	No	2.0	06	08	2015	grade_7	94	94
123168	WI	Polk	school	5513230	5019	Public school	Saint Croix Falls	551323002314	70	Saint Croix Falls Middle		Regular School	No	2.0	05	08	2015	grade_7	94	94
295324	WI	Waushara	school	5515960	6237	Public school	Wautoma Area	551596002071	30	Parkside School		Regular School	No	2.0	04	08	2016	grade_7	94	94
326428	WI	Barron	school	5500870	308	Public school	Barron Area	550087000118	140	Riverview Middle		Regular School	No	Middle	05	08	2017	grade_7	94	94
328825	WI	Milwaukee	school	5504800	1890	Public school	Fox Point J2	550480000517	20	Bayside Middle		Regular School	No	Middle	05	08	2017	grade_7	94	94
2323501	WI	Manitowoc	school	5507440	2828	Public school	Kiel Area	550744000845	60	Kiel Middle		Regular School	No	Middle	05	08	2020	grade_7	94	94
2330169	WI	Saint Croix	school	5514010	5432	Public school	Somerset	551401001108	60	Somerset Middle		Regular School	No	Middle	05	08	2020	grade_7	94	94
2340376	WI	Milwaukee	school	5509600	3619	Public school	Milwaukee	550960002980	444	Carmen Middle/High School of Science and Technology Northwest Campus	charter	Regular School	Yes	High	06	12	2021	grade_7	94	94
2345915	WI	Lincoln	school	5514940	5754	Public school	Tomahawk	551494001948	220	Tomahawk Middle		Regular School	No	Middle	06	08	2021	grade_7	94	94
3086084	WI	Washburn	school	5514220	5474	Public school	Spooner Area	551422001849	100	Spooner Middle		Regular School	No	Middle	05	08	2019	grade_7	94	94
3090234	WI	Fond du Lac	school	5502160	910	Public school	Campbellsport	550216002484	300	Campbellsport Middle		Regular School	No	Middle	06	08	2018	grade_7	94	94
3094987	WI	Douglas	school	5508640	3297	Public school	Maple	550864000988	170	Northwestern Middle		Regular School	No	Middle	06	08	2018	grade_7	94	94
3096549	WI	Milwaukee	school	5509600	3619	Public school	Milwaukee	550960001209	256	Longfellow Elementary		Regular School	No	Elementary	PK	08	2018	grade_7	94	94
115074	WI	Trempealeau	school	5504960	2009	Public school	Galesville-Ettrick-Trempealeau	550496000537	50	Galesville-Ettrick-Trempealeau Middle		Regular School	No	2.0	06	08	2015	grade_7	93	93
327384	WI	Calumet	school	5502520	1085	Public school	Chilton	550252002430	30	Chilton Middle		Regular School	No	Middle	05	08	2017	grade_7	93	93
334911	WI	Fond du Lac	school	5510740	3983	Public school	North Fond du Lac	551074001396	20	Bessie Allen Middle		Regular School	No	Middle	06	08	2017	grade_7	93	93
2330370	WI	Washburn	school	5514220	5474	Public school	Spooner Area	551422001849	100	Spooner Middle		Regular School	No	Middle	05	08	2020	grade_7	93	93
2331019	WI	Portage	school	5500330	126	Public school	Tomorrow River	550033000034	80	Amherst Middle		Regular School	No	Middle	05	08	2020	grade_7	93	93
2339640	WI	Juneau	school	5508850	3360	Public school	Mauston	550885001026	20	Olson Middle		Regular School	No	Middle	06	08	2021	grade_7	93	93
3075690	WI	Calumet	school	5502520	1085	Public school	Chilton	550252002430	30	Chilton Middle		Regular School	No	Middle	05	08	2019	grade_7	93	93
3085330	WI	Polk	school	5513230	5019	Public school	Saint Croix Falls	551323002314	70	Saint Croix Falls Middle		Regular School	No	Middle	05	08	2019	grade_7	93	93
3089458	WI	Barron	school	5500870	308	Public school	Barron Area	550087000118	140	Riverview Middle		Regular School	No	Middle	05	08	2018	grade_7	93	93
3095215	WI	Dodge	school	5508880	3367	Public school	Mayville	550888001029	60	Mayville Middle		Regular School	No	Middle	03	08	2018	grade_7	93	93
3096184	WI	Milwaukee	school	5509600	3619	Public school	Milwaukee	550960001169	185	Gaenslen Elementary		Regular School	No	Elementary	PK	08	2018	grade_7	93	93
285884	WI	Waukesha	school	5506140	2460	Public school	Hartland-Lakeside J3	550614001282	100	North Shore Middle		Regular School	No	2.0	06	08	2016	grade_7	92	92
288047	WI	Douglas	school	5508640	3297	Public school	Maple	550864000988	170	Northwestern Middle		Regular School	No	2.0	06	08	2016	grade_7	92	92
289598	WI	Milwaukee	school	5509600	3619	Public school	Milwaukee	550960001209	256	Longfellow Elementary		Regular School	No	1.0	PK	08	2016	grade_7	92	92
293861	WI	Washburn	school	5514220	5474	Public school	Spooner Area	551422001849	100	Spooner Middle		Regular School	No	2.0	05	08	2016	grade_7	92	92
331913	WI	Douglas	school	5508640	3297	Public school	Maple	550864000988	170	Northwestern Middle		Regular School	No	Middle	06	08	2017	grade_7	92	92
2318927	WI	Barron	school	5500870	308	Public school	Barron Area	550087000118	140	Riverview Middle		Regular School	No	Middle	05	08	2020	grade_7	92	92
2320031	WI	Waupaca	school	5502670	1141	Public school	Clintonville	550267000301	20	Clintonville Middle		Regular School	No	Middle	05	08	2020	grade_7	92	92
2327355	WI	Green	school	5510500	3934	Public school	New Glarus	551050002929	250	New Glarus Middle		Regular School	No	Middle	06	08	2020	grade_7	92	92
2332913	WI	Brown	school	5517190	6734	Public school	Wrightstown Community	551719000280	30	Wrightstown Middle		Regular School	No	Middle	05	08	2020	grade_7	92	92
2340981	WI	Milwaukee	school	5509600	3619	Public school	Milwaukee	550960001209	256	Longfellow Elementary		Regular School	No	Elementary	PK	08	2021	grade_7	92	92
3075798	WI	Rock	school	5502640	1134	Public school	Clinton Community	550264000297	80	Clinton Middle		Regular School	No	Middle	05	08	2019	grade_7	92	92
3077275	WI	Trempealeau	school	5504960	2009	Public school	Galesville-Ettrick-Trempealeau	550496000537	50	Galesville-Ettrick-Trempealeau Middle		Regular School	No	Middle	06	08	2019	grade_7	92	92
3085088	WI	Fond du Lac	school	5513020	4872	Public school	Ripon Area	551302001719	140	Ripon Middle		Regular School	No	Middle	06	08	2019	grade_7	92	92
3089885	WI	Chippewa	school	5501350	497	Public school	Bloomer	550135000185	60	Bloomer Middle		Regular School	No	Middle	05	08	2018	grade_7	92	92
3098808	WI	Marinette	school	5511610	4305	Public school	Peshtigo	551161003026	200	Peshtigo Middle		Regular School	No	Middle	07	08	2018	grade_7	92	92
3099914	WI	Sauk	school	5514250	5523	Public school	River Valley	551425001856	100	River Valley Middle		Regular School	No	Middle	06	08	2018	grade_7	92	92
3102781	WI	Vernon	school	5516410	6321	Public school	Westby Area	551641001207	160	Westby Middle		Regular School	No	Middle	05	08	2018	grade_7	92	92
113499	WI	Calumet	school	5502520	1085	Public school	Chilton	550252002430	30	Chilton Middle		Regular School	No	2.0	05	08	2015	grade_7	91	91
121204	WI	Vilas	school	5503860	1526	Public school	Northland Pines	550386000407	95	Northland Pines Middle		Regular School	No	2.0	06	08	2015	grade_7	91	91
284165	WI	Iowa	school	5503690	1428	Public school	Dodgeville	550369000391	50	Dodgeville Middle		Regular School	No	2.0	06	08	2016	grade_7	91	91
292123	WI	Columbia	school	5512120	4536	Public school	Poynette	551212001581	100	Poynette Middle		Regular School	No	2.0	06	08	2016	grade_7	91	91
335813	WI	Grant	school	5511850	4389	Public school	Platteville	551185001554	80	Platteville Middle		Regular School	No	Middle	05	08	2017	grade_7	91	91
2320138	WI	Columbia	school	5502820	1183	Public school	Columbus	550282000319	20	Columbus Middle		Regular School	No	Middle	06	08	2020	grade_7	91	91
2328663	WI	Crawford	school	5512150	4543	Public school	Prairie du Chien Area	551215002844	300	Bluff View Junior High		Regular School	No	Middle	07	08	2020	grade_7	91	91
2329369	WI	Fond du Lac	school	5513020	4872	Public school	Ripon Area	551302001719	140	Ripon Middle		Regular School	No	Middle	06	08	2020	grade_7	91	91
2331001	WI	Lincoln	school	5514940	5754	Public school	Tomahawk	551494001948	220	Tomahawk Middle		Regular School	No	Middle	06	08	2020	grade_7	91	91
2335743	WI	Dunn	school	5504230	1645	Public school	Elk Mound Area	550423000452	20	Elk Mound Middle		Regular School	No	Middle	05	08	2021	grade_7	91	91
3102053	WI	Waukesha	school	5515780	6174	Public school	Waukesha	551578002023	400	Waukesha STEM Academy	charter	Regular School	Yes	Elementary	PK	08	2018	grade_7	91	91
282176	WI	Outagamie	school	5500390	147	Public school	Appleton Area	550039000063	360	Roosevelt Middle		Regular School	No	2.0	07	08	2016	grade_7	90	90
291048	WI	Fond du Lac	school	5510740	3983	Public school	North Fond du Lac	551074001396	20	Bessie Allen Middle		Regular School	No	2.0	06	08	2016	grade_7	90	90
293151	WI	Kenosha	school	5513350	5068	Public school	Salem	551335001753	20	Salem Elementary		Regular School	No	1.0	PK	08	2016	grade_7	90	90
338016	WI	Door	school	5514610	5642	Public school	Sturgeon Bay	551461002322	80	Walker Middle		Regular School	No	Middle	06	08	2017	grade_7	90	90
2319331	WI	Chippewa	school	5501350	497	Public school	Bloomer	550135000185	60	Bloomer Middle		Regular School	No	Middle	05	08	2020	grade_7	90	90
2326710	WI	Milwaukee	school	5500042	8106	Non District Charter Schools	Milwaukee Academy of Science	550004202234	1251	Milwaukee Academy of Science	charter	Regular School	Yes	Other	PK	12	2020	grade_7	90	90