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 ccd_school_low_grade 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
281941	WI	Langlade	school		140	Public Schools-Multidistrict Charters	Antigo Unified		9100	Rural Virtual Academy	charter						2016	grade_7	3	3
284915	WI	Jefferson	school		1883	Public Schools-Multidistrict Charters	Fort Atkinson		9803	JEDI Virtual K-12	charter						2016	grade_7	1	1
286285	WI	Waupaca	school		2639	Public Schools-Multidistrict Charters	Iola-Scandinavia		9408	Waupaca County Charter	charter						2016	grade_7	1	1
286488	WI	Jefferson	school		2702	Public Schools-Multidistrict Charters	Jefferson		9803	JEDI Virtual K-12	charter						2016	grade_7	1	1
290483	WI	Marathon	school		3787	Public Schools-Multidistrict Charters	Mosinee		9100	Rural Virtual Academy	charter						2016	grade_7	1	1
293203	WI	Milwaukee	school		8121	Non District Charter Schools	Seeds of Health Elementary Program		100	Seeds of Health Elementary Program	charter						2016	grade_7	44	44
294043	WI	Dane	school		5621	Public Schools-Multidistrict Charters	Stoughton Area		9803	JEDI Virtual K-12	charter						2016	grade_7	1	1
294155	WI	Dane	school		5656	Public Schools-Multidistrict Charters	Sun Prairie Area		9803	JEDI Virtual K-12	charter						2016	grade_7	1	1
282064	WI	Outagamie	school	5500390	147	Public school	Appleton Area	550039002582	135	Fox River Academy	charter	Regular School	Yes	1.0	01	08	2016	grade_7	5	5
290016	WI	Milwaukee	school	5509600	3619	Public school	Milwaukee	550960002442	312	Starms Discovery		Regular School	No	1.0	01	08	2016	grade_7	44	44
284608	WI	Waukesha	school	5501770	714	Public school	Elmbrook	550177000221	160	Fairview South		Special Education School	No	4.0	02	12	2016	grade_7	2	2
282160	WI	Outagamie	school	5500390	147	Public school	Appleton Area	550039002277	210	Odyssey-Magellan	charter	Regular School	Yes	1.0	03	08	2016	grade_7	28	28
288060	WI	Milwaukee	school	5504770	1897	Public school	Maple Dale-Indian Hill	550477000516	40	Maple Dale Elementary		Regular School	No	1.0	03	08	2016	grade_7	51	51
288272	WI	Dodge	school	5508880	3367	Public school	Mayville	550888001029	60	Mayville Middle		Regular School	No	1.0	03	08	2016	grade_7	86	86
289668	WI	Milwaukee	school	5509600	3619	Public school	Milwaukee	550960001164	176	Meir School		Regular School	No	4.0	03	10	2016	grade_7	135	135
292771	WI	Washington	school	5512900	4820	Public school	Richfield J1	551290001703	20	Richfield Elementary		Regular School	No	1.0	03	08	2016	grade_7	49	49
282675	WI	Rock	school	5501050	413	Public school	Beloit	550105000137	20	Aldrich Intermediate		Regular School	No	2.0	04	08	2016	grade_7	102	102
282707	WI	Rock	school	5501050	413	Public school	Beloit	550105000140	80	Cunningham Intermediate		Regular School	No	2.0	04	08	2016	grade_7	123	123
282713	WI	Rock	school	5501050	413	Public school	Beloit	550105003011	170	Fran Fruzen Intermediate School		Regular School	No	2.0	04	08	2016	grade_7	120	120
282732	WI	Rock	school	5501050	413	Public school	Beloit	550105002330	180	McNeel Intermediate		Regular School	No	2.0	04	08	2016	grade_7	146	146
283698	WI	Columbia	school	5502820	1183	Public school	Columbus	550282000319	20	Columbus Middle		Regular School	No	2.0	04	08	2016	grade_7	84	84
285111	WI	Walworth	school	5505130	2051	Public school	Genoa City J2	550513002327	200	Brookwood Middle		Regular School	No	2.0	04	08	2016	grade_7	57	57
285236	WI	Milwaukee	school	5505460	2184	Public school	Glendale-River Hills	550546000575	10	Glen Hills Middle		Regular School	No	2.0	04	08	2016	grade_7	118	118
285347	WI	Burnett	school	5505670	2233	Public school	Grantsburg	550567000603	100	Grantsburg Middle		Regular School	No	2.0	04	08	2016	grade_7	52	52
287817	WI	Dane	school	5508520	3269	Public school	Madison Metropolitan	550852002670	820	Metro School		Alternative Education School	No	4.0	04	12	2016	grade_7	1	1
290475	WI	Marathon	school	5509960	3787	Public school	Mosinee	550996001309	120	Mosinee Middle		Regular School	No	2.0	04	08	2016	grade_7	155	155
290747	WI	Wood	school	5510380	3906	Public school	Nekoosa	551038001358	20	Alexander Middle		Regular School	No	2.0	04	08	2016	grade_7	59	59
290753	WI	Wood	school	5510380	3906	Public school	Nekoosa	551038002957	100	Central Wisconsin STEM Academy	charter	Regular School	Yes	2.0	04	08	2016	grade_7	23	23
290771	WI	Wood	school	5510380	3906	Public school	Nekoosa	551038002715	200	Niikuusra Community School	charter	Alternative Education School	Yes	2.0	04	08	2016	grade_7	4	4
291184	WI	Washburn	school	5509720	3654	Public school	Northwood	550972002877	200	NorthStar Community Charter School	charter	Regular School	Yes	2.0	04	08	2016	grade_7	6	6
291546	WI	Winnebago	school	5511190	4179	Public school	Oshkosh Area	551119003364	170	Accelerated Advanced Learning Program	charter	Regular School	Yes	2.0	04	08	2016	grade_7	11	11
291932	WI	Grant	school	5511850	4389	Public school	Platteville	551185001554	80	Platteville Middle		Regular School	No	2.0	04	08	2016	grade_7	110	110
293024	WI	Fond du Lac	school	5513100	4956	Public school	Rosendale-Brandon	551310001731	80	Rosendale Intermediate		Regular School	No	2.0	04	08	2016	grade_7	42	42
293130	WI	Milwaukee	school	5513260	5026	Public school	Saint Francis	551326001747	20	Deer Creek Intermediate School		Regular School	No	2.0	04	08	2016	grade_7	72	72
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
281768	WI	Green	school	5500120	63	Public school	Albany	550012002357	60	Albany Community Middle	charter	Regular School	Yes	2.0	05	08	2016	grade_7	15	15
282401	WI	Saint Croix	school	5500720	231	Public school	Baldwin-Woodville Area	550072000096	90	Viking Middle		Regular School	No	2.0	05	08	2016	grade_7	117	117
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
282941	WI	Chippewa	school	5501350	497	Public school	Bloomer	550135000185	60	Bloomer Middle School		Regular School	No	2.0	05	08	2016	grade_7	84	84
283261	WI	Barron	school	5502130	903	Public school	Cameron	550213002286	200	Cameron Middle		Regular School	No	2.0	05	08	2016	grade_7	66	66
283353	WI	Sheboygan	school	5502430	1029	Public school	Cedar Grove-Belgium Area	550243001629	200	Cedar Grove-Belgium Middle		Regular School	No	2.0	05	08	2016	grade_7	77	77
283477	WI	Calumet	school	5502520	1085	Public school	Chilton	550252002430	30	Chilton Middle		Regular School	No	2.0	05	08	2016	grade_7	85	85
283585	WI	Rock	school	5502640	1134	Public school	Clinton Community	550264000297	80	Clinton Middle		Regular School	No	2.0	05	08	2016	grade_7	86	86
283595	WI	Waupaca	school	5502670	1141	Public school	Clintonville	550267000301	20	Clintonville Middle		Regular School	No	2.0	05	08	2016	grade_7	86	86
283637	WI	Clark	school	5502730	1162	Public school	Colby	550273001226	210	Colby Middle		Regular School	No	2.0	05	08	2016	grade_7	70	70
283844	WI	Barron	school	5503090	1260	Public school	Cumberland	550309000304	50	Cumberland Middle		Regular School	No	2.0	05	08	2016	grade_7	76	76
283954	WI	Dane	school	5503180	1316	Public school	De Forest Area	550318000356	50	De Forest Middle		Regular School	No	2.0	05	08	2016	grade_7	248	248
284466	WI	Dunn	school	5504230	1645	Public school	Elk Mound Area	550423000452	20	Elk Mound Middle		Regular School	No	2.0	05	08	2016	grade_7	103	103
284555	WI	Pierce	school	5504320	1659	Public school	Ellsworth Community	550432000463	20	Ellsworth Middle		Regular School	No	2.0	05	08	2016	grade_7	121	121
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
285230	WI	Buffalo	school	5505370	2142	Public school	Gilmanton	550537002907	250	Gilmanton Middle		Regular School	No	2.0	05	08	2016	grade_7	16	16
285976	WI	Calumet	school	5506450	2534	Public school	Hilbert	550645001458	200	Hilbert Middle		Regular School	No	2.0	05	08	2016	grade_7	32	32
286066	WI	Outagamie	school	5506600	2583	Public school	Hortonville Area	550660002573	210	Greenville Middle		Regular School	No	2.0	05	08	2016	grade_7	133	133
286086	WI	Outagamie	school	5506600	2583	Public school	Hortonville Area	550660002408	30	Hortonville Middle		Regular School	No	2.0	05	08	2016	grade_7	132	132
286153	WI	Sheboygan	school	5506660	2605	Public school	Howards Grove	550666000563	125	Howards Grove Middle		Regular School	No	2.0	05	08	2016	grade_7	74	74
286584	WI	Outagamie	school	5507290	2758	Public school	Kaukauna Area	550729001700	200	River View School		Regular School	No	2.0	05	08	2016	grade_7	262	262
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
287395	WI	Jefferson	school	5507710	2898	Public school	Lake Mills Area	550771000888	60	Lake Mills Middle		Regular School	No	2.0	05	08	2016	grade_7	123	123
288093	WI	Marinette	school	5508700	3311	Public school	Marinette	550870000996	70	Marinette Middle		Regular School	No	2.0	05	08	2016	grade_7	139	139
288332	WI	Taylor	school	5508940	3409	Public school	Medford Area Public	550894001044	240	Medford Middle		Regular School	No	2.0	05	08	2016	grade_7	132	132
288660	WI	Waukesha	school	5509360	3528	Public school	Merton Community	550936002269	20	Merton Intermediate		Regular School	No	2.0	05	08	2016	grade_7	109	109
288697	WI	Dane	school	5509510	3549	Public school	Middleton-Cross Plains Area	550951000754	50	Glacier Creek Middle		Regular School	No	2.0	05	08	2016	grade_7	246	246
288702	WI	Dane	school	5509510	3549	Public school	Middleton-Cross Plains Area	550951001104	30	Kromrey Middle		Regular School	No	2.0	05	08	2016	grade_7	274	274
290349	WI	Dane	school	5509810	3675	Public school	Monona Grove	550981001293	100	Glacial Drumlin School		Regular School	No	2.0	05	08	2016	grade_7	253	253
290572	WI	Waukesha	school	5510170	3857	Public school	Muskego-Norway	551017001330	10	Bay Lane Middle		Regular School	No	2.0	05	08	2016	grade_7	208	208
290585	WI	Waukesha	school	5510170	3857	Public school	Muskego-Norway	551017001850	200	Lake Denoon Middle		Regular School	No	2.0	05	08	2016	grade_7	200	200
290864	WI	Green	school	5510500	3934	Public school	New Glarus	551050002929	250	New Glarus Middle		Regular School	No	2.0	05	08	2016	grade_7	79	79
290924	WI	Waupaca	school	5510590	3955	Public school	New London	551059001388	140	New London Middle		Regular School	No	2.0	05	08	2016	grade_7	163	163
291178	WI	Vilas	school	5503860	1526	Public school	Northland Pines	550386002938	250	School of Options & Applied Research Middle	charter	Regular School	Yes	2.0	05	08	2016	grade_7	18	18
291332	WI	Waukesha	school	5510890	4060	Public school	Oconomowoc Area	551089002795	200	Nature Hill Intermediate		Regular School	No	2.0	05	08	2016	grade_7	219	219
291349	WI	Waukesha	school	5510890	4060	Public school	Oconomowoc Area	551089001422	135	Silver Lake Intermediate		Regular School	No	2.0	05	08	2016	grade_7	175	175
291398	WI	Oconto	school	5510920	4067	Public school	Oconto Unified	551092002977	200	Bayshore Community Academy	charter	Regular School	Yes	2.0	05	08	2016	grade_7	17	17
291416	WI	Oconto	school	5510920	4067	Public school	Oconto Unified	551092001430	180	Oconto Middle		Regular School	No	2.0	05	08	2016	grade_7	63	63
291773	WI	Columbia	school	5511370	4228	Public school	Pardeeville Area	551137001519	100	Pardeeville Middle School		Regular School	No	2.0	05	08	2016	grade_7	55	55
291990	WI	Sheboygan	school	5511940	4473	Public school	Plymouth Joint	551194001563	120	Riverview Middle		Regular School	No	2.0	05	08	2016	grade_7	169	169
292039	WI	Ozaukee	school	5512000	4515	Public school	Port Washington-Saukville	551200001570	140	Thomas Jefferson Middle		Regular School	No	2.0	05	08	2016	grade_7	163	163
292196	WI	Price	school	5512210	4571	Public school	Prentice	551221002767	200	Prentice Middle		Regular School	No	2.0	05	08	2016	grade_7	37	37
292582	WI	Sheboygan	school	5512450	4641	Public school	Random Lake	551245002421	20	Random Lake Middle		Regular School	No	2.0	05	08	2016	grade_7	76	76
292750	WI	Barron	school	5512810	4802	Public school	Rice Lake Area	551281001697	140	Rice Lake Middle		Regular School	No	2.0	05	08	2016	grade_7	172	172
292988	WI	Grant	school	5510140	3850	Public school	Riverdale	551014001064	160	Riverdale Middle		Regular School	No	2.0	05	08	2016	grade_7	35	35
293105	WI	Saint Croix	school	5506060	2422	Public school	Saint Croix Central	550606000673	80	Saint Croix Central Middle		Regular School	No	2.0	05	08	2016	grade_7	108	108
293124	WI	Polk	school	5513230	5019	Public school	Saint Croix Falls	551323002314	70	Saint Croix Falls Middle		Regular School	No	2.0	05	08	2016	grade_7	79	79
293489	WI	Sheboygan	school	5513680	5278	Public school	Sheboygan Falls	551368002289	60	Sheboygan Falls Middle		Regular School	No	2.0	05	08	2016	grade_7	109	109
293671	WI	Saint Croix	school	5514010	5432	Public school	Somerset	551401001108	60	Somerset Middle		Regular School	No	2.0	05	08	2016	grade_7	123	123
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
294456	WI	Portage	school	5500330	126	Public school	Tomorrow River	550033000034	80	Amherst Middle		Regular School	No	2.0	05	08	2016	grade_7	85	85
294495	WI	Waushara	school	5511820	4375	Public school	Tri-County Area	551182002620	80	Tri-County Middle		Regular School	No	2.0	05	08	2016	grade_7	42	42
294533	WI	Manitowoc	school	5515120	5824	Public school	Two Rivers Public	551512001960	50	Clarke Middle		Regular School	No	2.0	05	08	2016	grade_7	111	111
294590	WI	Polk	school	5500750	238	Public school	Unity	550075000099	120	Unity Middle		Regular School	No	2.0	05	08	2016	grade_7	78	78
294619	WI	Manitowoc	school	5515210	5866	Public school	Valders Area	551521001968	80	Valders Middle		Regular School	No	2.0	05	08	2016	grade_7	63	63
294732	WI	Vernon	school	5515360	5985	Public school	Viroqua Area	551536001977	230	Viroqua Middle		Regular School	No	2.0	05	08	2016	grade_7	84	84
295127	WI	Waupaca	school	5515840	6195	Public school	Waupaca	551584002036	150	Waupaca Middle		Regular School	No	2.0	05	08	2016	grade_7	156	156
295508	WI	Burnett	school	5516230	6293	Public school	Webster	551623002100	100	Webster Middle		Regular School	No	2.0	05	08	2016	grade_7	48	48
295778	WI	Vernon	school	5516410	6321	Public school	Westby Area	551641001207	160	Westby Middle		Regular School	No	2.0	05	08	2016	grade_7	81	81
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
281728	WI	Clark	school	5500030	7	Public school	Abbotsford	550003000002	40	Abbotsford Middle/Senior High		Regular School	No	4.0	06	12	2016	grade_7	50	50
281747	WI	Adams	school	5500060	14	Public school	Adams-Friendship Area	550006001454	210	Adams-Friendship Middle		Regular School	No	2.0	06	08	2016	grade_7	110	110
281844	WI	Portage	school	5500240	105	Public school	Almond-Bancroft	550024000024	40	Almond High		Regular School	No	4.0	06	12	2016	grade_7	22	22
281860	WI	Eau Claire	school	5500270	112	Public school	Altoona	550027000027	60	Altoona Middle		Regular School	No	2.0	06	08	2016	grade_7	104	104
281880	WI	Polk	school	5500300	119	Public school	Amery	550030000031	60	Amery Middle		Regular School	No	2.0	06	08	2016	grade_7	110	110
281895	WI	Langlade	school	5500360	140	Public school	Antigo Unified	550036000036	50	Antigo Middle		Regular School	No	2.0	06	08	2016	grade_7	169	169