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_int 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
3086354	WI	Dane	school	5514640	5656	Public school	Sun Prairie Area	551464002810	220	Cardinal Heights Upper Middle		Regular School	No	Secondary	08	09	2019	grade_8	631	631
2345558	WI	Dane	school	5514640	5656	Public school	Sun Prairie Area	551464002810	220	Cardinal Heights Upper Middle		Regular School	No	High	08	12	2021	grade_8	621	621
2330648	WI	Dane	school	5514640	5656	Public school	Sun Prairie Area	551464002810	220	Cardinal Heights Upper Middle		Regular School	No	Secondary	08	09	2020	grade_8	602	602
124187	WI	Dane	school	5514640	5656	Public school	Sun Prairie Area	551464002810	220	Cardinal Heights Upper Middle		Regular School	No	4.0	08	09	2015	grade_8	601	601
3101078	WI	Dane	school	5514640	5656	Public school	Sun Prairie Area	551464002810	220	Cardinal Heights Upper Middle		Regular School	No	Secondary	08	09	2018	grade_8	566	566
294121	WI	Dane	school	5514640	5656	Public school	Sun Prairie Area	551464002810	220	Cardinal Heights Upper Middle		Regular School	No	4.0	08	09	2016	grade_8	560	560
338027	WI	Dane	school	5514640	5656	Public school	Sun Prairie Area	551464002810	220	Cardinal Heights Upper Middle		Regular School	No	Other	08	09	2017	grade_8	556	556
295641	WI	Washington	school	5516290	6307	Public school	West Bend	551629002125	10	Badger Middle		Regular School	No	2.0	07	08	2016	grade_8	522	522
120732	WI	Winnebago	school	5510320	3892	Public school	Neenah Joint	551032002308	210	Shattuck Middle		Regular School	No	2.0	07	08	2015	grade_8	510	510
125704	WI	Washington	school	5516290	6307	Public school	West Bend	551629002125	10	Badger Middle		Regular School	No	2.0	07	08	2015	grade_8	502	502
3097644	WI	Winnebago	school	5510320	3892	Public school	Neenah Joint	551032002308	210	Shattuck Middle		Regular School	No	Middle	07	08	2018	grade_8	496	496
3102644	WI	Washington	school	5516290	6307	Public school	West Bend	551629002125	10	Badger Middle		Regular School	No	Middle	07	08	2018	grade_8	493	493
290695	WI	Winnebago	school	5510320	3892	Public school	Neenah Joint	551032002308	210	Shattuck Middle		Regular School	No	2.0	07	08	2016	grade_8	492	492
2342047	WI	Winnebago	school	5510320	3892	Public school	Neenah Joint	551032002308	210	Shattuck Middle		Regular School	No	Middle	07	08	2021	grade_8	485	485
329992	WI	Brown	school	5506630	2604	Public school	Howard-Suamico	550663000717	30	Bay View Middle		Regular School	No	Middle	07	08	2017	grade_8	481	481
3082933	WI	Winnebago	school	5510320	3892	Public school	Neenah Joint	551032002308	210	Shattuck Middle		Regular School	No	Middle	07	08	2019	grade_8	476	476
334568	WI	Winnebago	school	5510320	3892	Public school	Neenah Joint	551032002308	210	Shattuck Middle		Regular School	No	Middle	07	08	2017	grade_8	473	473
2327178	WI	Winnebago	school	5510320	3892	Public school	Neenah Joint	551032002308	210	Shattuck Middle		Regular School	No	Middle	07	08	2020	grade_8	467	467
2337395	WI	Brown	school	5506630	2604	Public school	Howard-Suamico	550663000717	30	Bay View Middle		Regular School	No	Middle	07	08	2021	grade_8	466	466
3087955	WI	Washington	school	5516290	6307	Public school	West Bend	551629002125	10	Badger Middle		Regular School	No	Middle	07	08	2019	grade_8	463	463
2347215	WI	Washington	school	5516290	6307	Public school	West Bend	551629002125	10	Badger Middle		Regular School	No	Middle	07	08	2021	grade_8	461	461
3078369	WI	Saint Croix	school	5506690	2611	Public school	Hudson	550669000728	70	Hudson Middle		Regular School	No	Middle	06	08	2019	grade_8	458	458
339567	WI	Washington	school	5516290	6307	Public school	West Bend	551629002125	10	Badger Middle		Regular School	No	Middle	07	08	2017	grade_8	456	456
2322553	WI	Brown	school	5506630	2604	Public school	Howard-Suamico	550663000717	30	Bay View Middle		Regular School	No	Middle	07	08	2020	grade_8	456	456
2332244	WI	Washington	school	5516290	6307	Public school	West Bend	551629002125	10	Badger Middle		Regular School	No	Middle	07	08	2020	grade_8	454	454
327783	WI	Marathon	school	5513170	4970	Public school	D C Everest Area	551317001735	30	D C Everest Junior High		Regular School	No	Other	08	09	2017	grade_8	453	453
3093062	WI	Brown	school	5506630	2604	Public school	Howard-Suamico	550663000717	30	Bay View Middle		Regular School	No	Middle	07	08	2018	grade_8	451	451
2335118	WI	Marathon	school	5513170	4970	Public school	D C Everest Area	551317001735	30	D C Everest Junior High		Regular School	No	Secondary	08	09	2021	grade_8	444	444
3078303	WI	Brown	school	5506630	2604	Public school	Howard-Suamico	550663000717	30	Bay View Middle		Regular School	No	Middle	07	08	2019	grade_8	441	441
2322618	WI	Saint Croix	school	5506690	2611	Public school	Hudson	550669000728	70	Hudson Middle		Regular School	No	Middle	06	08	2020	grade_8	440	440
3090837	WI	Marathon	school	5513170	4970	Public school	D C Everest Area	551317001735	30	D C Everest Junior High		Regular School	No	Secondary	08	09	2018	grade_8	436	436
286110	WI	Brown	school	5506630	2604	Public school	Howard-Suamico	550663000717	30	Bay View Middle		Regular School	No	2.0	07	08	2016	grade_8	434	434
329321	WI	Brown	school	5505820	2289	Public school	Green Bay Area Public	550582000619	190	Edison Middle		Regular School	No	Middle	06	08	2017	grade_8	429	429
2320321	WI	Marathon	school	5513170	4970	Public school	D C Everest Area	551317001735	30	D C Everest Junior High		Regular School	No	Secondary	08	09	2020	grade_8	429	429
2337460	WI	Saint Croix	school	5506690	2611	Public school	Hudson	550669000728	70	Hudson Middle		Regular School	No	Middle	06	08	2021	grade_8	429	429
286178	WI	Saint Croix	school	5506690	2611	Public school	Hudson	550669000728	70	Hudson Middle		Regular School	No	2.0	06	08	2016	grade_8	428	428
116113	WI	Brown	school	5506630	2604	Public school	Howard-Suamico	550663000717	30	Bay View Middle		Regular School	No	2.0	07	08	2015	grade_8	425	425
113890	WI	Marathon	school	5513170	4970	Public school	D C Everest Area	551317001735	30	D C Everest Junior High		Regular School	No	4.0	08	09	2015	grade_8	422	422
116180	WI	Saint Croix	school	5506690	2611	Public school	Hudson	550669000728	70	Hudson Middle		Regular School	No	2.0	06	08	2015	grade_8	420	420
330056	WI	Saint Croix	school	5506690	2611	Public school	Hudson	550669000728	70	Hudson Middle		Regular School	No	Middle	06	08	2017	grade_8	420	420
3093127	WI	Saint Croix	school	5506690	2611	Public school	Hudson	550669000728	70	Hudson Middle		Regular School	No	Middle	06	08	2018	grade_8	419	419
2337092	WI	Waukesha	school	5506030	2420	Public school	Hamilton	550603000669	130	Templeton Middle		Regular School	No	Middle	07	08	2021	grade_8	413	413
3076096	WI	Marathon	school	5513170	4970	Public school	D C Everest Area	551317001735	30	D C Everest Junior High		Regular School	No	Secondary	08	09	2019	grade_8	411	411
2341901	WI	Waukesha	school	5510060	3822	Public school	Mukwonago	551006001320	65	Park View Middle		Regular School	No	Middle	07	08	2021	grade_8	403	403
3077618	WI	Brown	school	5505820	2289	Public school	Green Bay Area Public	550582000619	190	Edison Middle		Regular School	No	Middle	06	08	2019	grade_8	403	403
3079266	WI	Outagamie	school	5507470	2835	Public school	Kimberly Area	550747000849	40	Gerritts Middle		Regular School	No	Middle	07	08	2019	grade_8	401	401
3094015	WI	Outagamie	school	5507470	2835	Public school	Kimberly Area	550747000849	40	Gerritts Middle		Regular School	No	Middle	07	08	2018	grade_8	397	397
2336704	WI	Brown	school	5505820	2289	Public school	Green Bay Area Public	550582000619	190	Edison Middle		Regular School	No	Middle	06	08	2021	grade_8	396	396
283874	WI	Marathon	school	5513170	4970	Public school	D C Everest Area	551317001735	30	D C Everest Junior High		Regular School	No	4.0	08	09	2016	grade_8	394	394
3092396	WI	Brown	school	5505820	2289	Public school	Green Bay Area Public	550582000619	190	Edison Middle		Regular School	No	Middle	06	08	2018	grade_8	391	391
116770	WI	Kenosha	school	5507320	2793	Public school	Kenosha	550732002538	215	Mahone Middle		Regular School	No	2.0	06	08	2015	grade_8	390	390
285447	WI	Brown	school	5505820	2289	Public school	Green Bay Area Public	550582000619	190	Edison Middle		Regular School	No	2.0	06	08	2016	grade_8	390	390
330947	WI	Outagamie	school	5507470	2835	Public school	Kimberly Area	550747000849	40	Gerritts Middle		Regular School	No	Middle	07	08	2017	grade_8	388	388
2323516	WI	Outagamie	school	5507470	2835	Public school	Kimberly Area	550747000849	40	Gerritts Middle		Regular School	No	Middle	07	08	2020	grade_8	388	388
120580	WI	Waukesha	school	5510060	3822	Public school	Mukwonago	551006001320	65	Park View Middle		Regular School	No	2.0	07	08	2015	grade_8	386	386
115823	WI	Waukesha	school	5506030	2420	Public school	Hamilton	550603000669	130	Templeton Middle		Regular School	No	2.0	06	08	2015	grade_8	385	385
334415	WI	Waukesha	school	5510060	3822	Public school	Mukwonago	551006001320	65	Park View Middle		Regular School	No	Middle	07	08	2017	grade_8	385	385
2336250	WI	Milwaukee	school	5504830	1900	Public school	Franklin Public	550483000521	70	Forest Park Middle		Regular School	No	Middle	06	08	2021	grade_8	385	385
2338400	WI	Outagamie	school	5507470	2835	Public school	Kimberly Area	550747000849	40	Gerritts Middle		Regular School	No	Middle	07	08	2021	grade_8	385	385
287064	WI	Outagamie	school	5507470	2835	Public school	Kimberly Area	550747000849	40	Gerritts Middle		Regular School	No	2.0	07	08	2016	grade_8	384	384
113509	WI	Chippewa	school	5502550	1092	Public school	Chippewa Falls Area Unified	550255000281	40	Chippewa Falls Middle		Regular School	No	2.0	06	08	2015	grade_8	382	382
330657	WI	Kenosha	school	5507320	2793	Public school	Kenosha	550732002538	215	Mahone Middle		Regular School	No	Middle	06	08	2017	grade_8	382	382
2327027	WI	Waukesha	school	5510060	3822	Public school	Mukwonago	551006001320	65	Park View Middle		Regular School	No	Middle	07	08	2020	grade_8	382	382
286777	WI	Kenosha	school	5507320	2793	Public school	Kenosha	550732002538	215	Mahone Middle		Regular School	No	2.0	06	08	2016	grade_8	380	380
3082795	WI	Waukesha	school	5510060	3822	Public school	Mukwonago	551006001320	65	Park View Middle		Regular School	No	Middle	06	08	2019	grade_8	380	380
290542	WI	Waukesha	school	5510060	3822	Public school	Mukwonago	551006001320	65	Park View Middle		Regular School	No	2.0	07	08	2016	grade_8	378	378
3097493	WI	Waukesha	school	5510060	3822	Public school	Mukwonago	551006001320	65	Park View Middle		Regular School	No	Middle	07	08	2018	grade_8	378	378
2334709	WI	Chippewa	school	5502550	1092	Public school	Chippewa Falls Area Unified	550255000281	40	Chippewa Falls Middle		Regular School	No	Middle	06	08	2021	grade_8	375	375
126195	WI	Wood	school	5517070	6685	Public school	Wisconsin Rapids	551707002291	50	East Junior High		Regular School	No	4.0	08	09	2015	grade_8	374	374
115442	WI	Brown	school	5505820	2289	Public school	Green Bay Area Public	550582000619	190	Edison Middle		Regular School	No	2.0	06	08	2015	grade_8	372	372
3090450	WI	Chippewa	school	5502550	1092	Public school	Chippewa Falls Area Unified	550255000281	40	Chippewa Falls Middle		Regular School	No	Middle	06	08	2018	grade_8	370	370
3078002	WI	Waukesha	school	5506030	2420	Public school	Hamilton	550603000669	130	Templeton Middle		Regular School	No	Middle	06	08	2019	grade_8	367	367
2339709	WI	Dane	school	5508910	3381	Public school	McFarland	550891002973	160	Wisconsin Virtual Academy K-8 (WIVA)	charter	Regular School	Yes	Elementary	KG	08	2021	grade_8	366	366
3103146	WI	Wood	school	5517070	6685	Public school	Wisconsin Rapids	551707002291	50	East Junior High		Regular School	No	Secondary	08	09	2018	grade_8	366	366
2346798	WI	Marathon	school	5515900	6223	Public school	Wausau	551590002054	200	John Muir Middle		Regular School	No	Middle	06	08	2021	grade_8	365	365
328854	WI	Milwaukee	school	5504830	1900	Public school	Franklin Public	550483000521	70	Forest Park Middle		Regular School	No	Middle	07	08	2017	grade_8	363	363
114969	WI	Milwaukee	school	5504830	1900	Public school	Franklin Public	550483000521	70	Forest Park Middle		Regular School	No	2.0	07	08	2015	grade_8	362	362
296133	WI	Wood	school	5517070	6685	Public school	Wisconsin Rapids	551707002291	50	East Junior High		Regular School	No	4.0	08	09	2016	grade_8	362	362
327394	WI	Chippewa	school	5502550	1092	Public school	Chippewa Falls Area Unified	550255000281	40	Chippewa Falls Middle		Regular School	No	Middle	06	08	2017	grade_8	361	361
3075700	WI	Chippewa	school	5502550	1092	Public school	Chippewa Falls Area Unified	550255000281	40	Chippewa Falls Middle		Regular School	No	Middle	06	08	2019	grade_8	361	361
3077180	WI	Milwaukee	school	5504830	1900	Public school	Franklin Public	550483000521	70	Forest Park Middle		Regular School	No	Middle	07	08	2019	grade_8	361	361
3091929	WI	Milwaukee	school	5504830	1900	Public school	Franklin Public	550483000521	70	Forest Park Middle		Regular School	No	Middle	07	08	2018	grade_8	361	361
2321862	WI	Brown	school	5505820	2289	Public school	Green Bay Area Public	550582000619	190	Edison Middle		Regular School	No	Middle	06	08	2020	grade_8	360	360
117064	WI	Outagamie	school	5507470	2835	Public school	Kimberly Area	550747000849	40	Gerritts Middle		Regular School	No	2.0	07	08	2015	grade_8	358	358
295518	WI	Milwaukee	school	5516260	6300	Public school	West Allis-West Milwaukee	551626002102	40	Frank Lloyd Wright Intermediate		Regular School	No	2.0	06	08	2016	grade_8	358	358
125578	WI	Milwaukee	school	5516260	6300	Public school	West Allis-West Milwaukee	551626002102	40	Frank Lloyd Wright Intermediate		Regular School	No	2.0	06	08	2015	grade_8	357	357
2335512	WI	Eau Claire	school	5504050	1554	Public school	Eau Claire Area	550405000421	170	DeLong Middle		Regular School	No	Middle	06	08	2021	grade_8	357	357
283487	WI	Chippewa	school	5502550	1092	Public school	Chippewa Falls Area Unified	550255000281	40	Chippewa Falls Middle		Regular School	No	2.0	06	08	2016	grade_8	356	356
2332801	WI	Wood	school	5517070	6685	Public school	Wisconsin Rapids	551707002216	290	Wisconsin Rapids Area Middle		Regular School	No	Middle	06	08	2020	grade_8	355	355
3092778	WI	Waukesha	school	5506030	2420	Public school	Hamilton	550603000669	130	Templeton Middle		Regular School	No	Middle	06	08	2018	grade_8	355	355
3102231	WI	Marathon	school	5515900	6223	Public school	Wausau	551590002054	200	John Muir Middle		Regular School	No	Middle	06	08	2018	grade_8	355	355
116762	WI	Kenosha	school	5507320	2793	Public school	Kenosha	550732000815	320	Lance Middle		Regular School	No	2.0	06	08	2015	grade_8	354	354
2319924	WI	Chippewa	school	5502550	1092	Public school	Chippewa Falls Area Unified	550255000281	40	Chippewa Falls Middle		Regular School	No	Middle	06	08	2020	grade_8	353	353
2323223	WI	Kenosha	school	5507320	2793	Public school	Kenosha	550732002538	215	Mahone Middle		Regular School	No	Middle	06	08	2020	grade_8	353	353
326041	WI	Outagamie	school	5500390	147	Public school	Appleton Area	550039000060	300	Madison Middle		Regular School	No	Middle	07	08	2017	grade_8	351	351
2322252	WI	Waukesha	school	5506030	2420	Public school	Hamilton	550603000669	130	Templeton Middle		Regular School	No	Middle	07	08	2020	grade_8	351	351
3093722	WI	Kenosha	school	5507320	2793	Public school	Kenosha	550732002538	215	Mahone Middle		Regular School	No	Middle	06	08	2018	grade_8	347	347
2321420	WI	Milwaukee	school	5504830	1900	Public school	Franklin Public	550483000521	70	Forest Park Middle		Regular School	No	Middle	06	08	2020	grade_8	345	345
2327782	WI	Milwaukee	school	5510830	4018	Public school	Oak Creek-Franklin Joint	551083001412	120	Oak Creek East Middle		Regular School	No	Middle	06	08	2020	grade_8	345	345
2338097	WI	Kenosha	school	5507320	2793	Public school	Kenosha	550732002538	215	Mahone Middle		Regular School	No	Middle	06	08	2021	grade_8	345	345
2331842	WI	Marathon	school	5515900	6223	Public school	Wausau	551590002054	200	John Muir Middle		Regular School	No	Middle	06	08	2020	grade_8	344	344