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 school_state_id 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	ccd_school_type	ccd_charter_school	ccd_school_lvl	ccd_school_low_grade	ccd_school_high_grade	year	grade	total	total_int
2326140	WI	Milwaukee	school	5509600	3619	Public school	Milwaukee	550960001215	8	Marshall High	Regular School	No	High	09	12	2020	grade_11	240	240
2330624	WI	Door	school	5514610	5642	Public school	Sturgeon Bay	551461001894	10	Sturgeon Bay High	Regular School	No	High	09	12	2020	grade_11	96	96
2319310	WI	Trempealeau	school	5500016	485	Public school	Blair-Taylor	550001602378	11	Blair-Taylor Middle/High	Regular School	No	High	07	12	2020	grade_11	54	54
2325377	WI	Milwaukee	school	5509600	3619	Public school	Milwaukee	550960001127	12	Bay View High	Regular School	No	High	09	12	2020	grade_11	177	177
2325404	WI	Milwaukee	school	5509600	3619	Public school	Milwaukee	550960001218	14	Bradley Technology High	Regular School	No	High	09	12	2020	grade_11	214	214
2328248	WI	Jefferson	school	5511350	4221	Public school	Palmyra-Eagle Area	551135002274	15	Palmyra-Eagle High	Regular School	No	High	09	12	2020	grade_11	65	65
2325811	WI	Milwaukee	school	5509600	3619	Public school	Milwaukee	550960001180	18	Hamilton High	Regular School	No	High	09	12	2020	grade_11	284	284
2318417	WI	Outagamie	school	5500390	147	Public school	Appleton Area	550039000047	20	East High	Regular School	No	High	09	12	2020	grade_11	352	352
2318644	WI	Waukesha	school	5506180	2450	Public school	Arrowhead UHS	550618000678	20	Arrowhead High	Regular School	No	High	09	12	2020	grade_11	525	525
2318649	WI	Ashland	school	5500510	170	Public school	Ashland	550051000073	20	Ashland High	Regular School	No	High	09	12	2020	grade_11	170	170
2318696	WI	Brown	school	5500540	182	Public school	Ashwaubenon	550054000081	20	Ashwaubenon High	Regular School	No	High	09	12	2020	grade_11	225	225
2319174	WI	Rock	school	5501080	422	Public school	Beloit Turner	550108000156	20	Turner High	Regular School	No	High	09	12	2020	grade_11	104	104
2319219	WI	Walworth	school	5515480	6013	Public school	Big Foot UHS	551548001982	20	Big Foot High	Regular School	No	High	09	12	2020	grade_11	112	112
2319272	WI	Lafayette	school	5505730	2240	Public school	Black Hawk	550573000605	20	Black Hawk High	Regular School	No	High	09	12	2020	grade_11	23	23
2319522	WI	Racine	school	5501890	777	Public school	Burlington Area	550189000237	20	Burlington High	Regular School	No	High	09	12	2020	grade_11	266	266
2319781	WI	Ozaukee	school	5502460	1015	Public school	Cedarburg	550246000270	20	Cedarburg High	Regular School	No	High	09	12	2020	grade_11	255	255
2319830	WI	Kenosha	school	5513290	5054	Public school	Central/Westosha UHS	551329001751	20	Central High	Regular School	No	High	09	12	2020	grade_11	243	243
2320442	WI	Brown	school	5503210	1414	Public school	De Pere	550321000361	20	De Pere High	Regular School	No	High	09	12	2020	grade_11	332	332
2320528	WI	Walworth	school	5503640	1380	Public school	Delavan-Darien	550364000386	20	Delavan-Darien High	Regular School	No	High	09	12	2020	grade_11	180	180
2321040	WI	Waukesha	school	5501770	714	Public school	Elmbrook	550177000214	20	Central High	Regular School	No	High	09	12	2020	grade_11	291	291
2321616	WI	Oconto	school	5505250	2128	Public school	Gillett	550525000564	20	Gillett High	Regular School	No	High	09	12	2020	grade_11	49	49
2322286	WI	Washington	school	5506120	2436	Public school	Hartford UHS	550612000677	20	Hartford High	Regular School	No	High	09	12	2020	grade_11	343	343
2322548	WI	Brown	school	5506630	2604	Public school	Howard-Suamico	550663000716	20	Bay Port High	Regular School	No	High	09	12	2020	grade_11	505	505
2323482	WI	Vernon	school	5512540	5960	Public school	Kickapoo Area	551254001658	20	Kickapoo High	Regular School	No	High	06	12	2020	grade_11	39	39
2323583	WI	La Crosse	school	5507530	2849	Public school	La Crosse	550753000854	20	Central High	Regular School	No	High	09	12	2020	grade_11	265	265
2323818	WI	Walworth	school	5507650	2884	Public school	Lake Geneva-Genoa City UHS	550765000884	20	Badger High	Regular School	No	High	09	12	2020	grade_11	345	345
2323877	WI	Oneida	school	5509630	3647	Public school	Lakeland UHS	550963001274	20	Lakeland High	Regular School	No	High	09	12	2020	grade_11	161	161
2323887	WI	Grant	school	5507770	2912	Public school	Lancaster Community	550777000891	20	Lancaster High	Regular School	No	High	09	12	2020	grade_11	72	72
2323905	WI	Forest	school	5507830	2940	Public school	Laona	550783000893	20	Laona High	Regular School	No	High	07	12	2020	grade_11	19	19
2325998	WI	Milwaukee	school	5509600	3619	Public school	Milwaukee	550960001199	20	King International	Regular School	No	High	09	12	2020	grade_11	386	386
2327489	WI	Milwaukee	school	5505490	2177	Public school	Nicolet UHS	550549000584	20	Nicolet High	Regular School	No	High	09	12	2020	grade_11	267	267
2327494	WI	Waukesha	school	5510710	3976	Public school	Norris	551071001395	20	Norris Academy	Regular School	No	Other	KG	12	2020	grade_11	3	3
2327702	WI	Monroe	school	5510770	3990	Public school	Norwalk-Ontario-Wilton	551077001402	20	Brookwood High	Regular School	No	High	07	12	2020	grade_11	47	47
2328396	WI	Vilas	school	5511710	4330	Public school	Phelps	551171001540	20	Phelps High	Regular School	No	High	09	12	2020	grade_11	10	10
2331159	WI	Racine	school	5515150	5852	Public school	Union Grove UHS	551515001963	20	Union Grove High	Regular School	No	High	09	12	2020	grade_11	251	251
2331417	WI	Racine	school	5515600	6083	Public school	Waterford UHS	551560001988	20	Waterford High	Regular School	No	High	09	12	2020	grade_11	267	267
2331956	WI	Milwaukee	school	5515990	6244	Public school	Wauwatosa	551599002077	20	East High	Regular School	No	High	09	12	2020	grade_11	317	317
2332118	WI	Milwaukee	school	5516260	6300	Public school	West Allis-West Milwaukee	551626002101	20	Central High	Regular School	No	High	09	12	2020	grade_11	248	248
2332639	WI	Kenosha	school	5516770	6545	Public school	Wilmot UHS	551677002188	20	Wilmot High	Regular School	No	High	09	12	2020	grade_11	245	245
2320579	WI	Dodge	school	5507260	2744	Public school	Dodgeland	550726000787	22	Dodgeland High	Regular School	No	High	09	12	2020	grade_11	49	49
2326421	WI	Milwaukee	school	5509600	3619	Public school	Milwaukee	550960001235	26	Pulaski High	Regular School	No	High	09	12	2020	grade_11	200	200
2326452	WI	Milwaukee	school	5509600	3619	Public school	Milwaukee	550960001237	29	Riverside High	Regular School	No	High	09	12	2020	grade_11	339	339
2318540	WI	Outagamie	school	5500390	147	Public school	Appleton Area	550039000597	30	North High	Regular School	No	High	09	12	2020	grade_11	385	385
2318910	WI	Barron	school	5500870	308	Public school	Barron Area	550087000114	30	Barron High	Regular School	No	High	09	12	2020	grade_11	98	98
2326513	WI	Milwaukee	school	5509600	3619	Public school	Milwaukee	550960001247	32	South Division High	Regular School	No	High	09	12	2020	grade_11	174	174
2326634	WI	Milwaukee	school	5509600	3619	Public school	Milwaukee	550960002272	33	Vincent High	Regular School	No	High	09	12	2020	grade_11	151	151
2320310	WI	Marathon	school	5513170	4970	Public school	D C Everest Area	551317001734	35	D C Everest High	Regular School	No	High	10	12	2020	grade_11	453	453
2326278	WI	Milwaukee	school	5509600	3619	Public school	Milwaukee	550960002339	38	Milwaukee High School of the Arts	Regular School	No	High	09	12	2020	grade_11	183	183
2318142	WI	Clark	school	5500030	7	Public school	Abbotsford	550003000002	40	Abbotsford Middle/Senior High	Regular School	No	High	06	12	2020	grade_11	50	50
2318162	WI	Adams	school	5500060	14	Public school	Adams-Friendship Area	550006000005	40	Adams-Friendship High	Regular School	No	High	09	12	2020	grade_11	108	108
2318190	WI	Green	school	5500120	63	Public school	Albany	550012000014	40	Albany High	Regular School	No	High	09	12	2020	grade_11	26	26
2318205	WI	Kewaunee	school	5500150	70	Public school	Algoma	550015000016	40	Algoma High	Regular School	No	High	07	12	2020	grade_11	43	43
2318224	WI	Buffalo	school	5500180	84	Public school	Alma	550018000018	40	Alma High	Regular School	No	High	09	12	2020	grade_11	18	18
2318256	WI	Portage	school	5500240	105	Public school	Almond-Bancroft	550024000024	40	Almond-Bancroft High	Regular School	No	High	09	12	2020	grade_11	20	20
2318272	WI	Eau Claire	school	5500270	112	Public school	Altoona	550027000026	40	Altoona High	Regular School	No	High	09	12	2020	grade_11	112	112
2318284	WI	Polk	school	5500300	119	Public school	Amery	550030000030	40	Amery High	Regular School	No	High	09	12	2020	grade_11	113	113
2318586	WI	Outagamie	school	5500390	147	Public school	Appleton Area	550039000048	40	West High	Regular School	No	High	09	12	2020	grade_11	282	282
2318617	WI	Trempealeau	school	5500420	154	Public school	Arcadia	550042000068	40	Arcadia High	Regular School	No	High	09	12	2020	grade_11	87	87
2318635	WI	Lafayette	school	5500450	161	Public school	Argyle	550045000070	40	Argyle High	Regular School	No	High	09	12	2020	grade_11	18	18
2318731	WI	Marathon	school	5500570	196	Public school	Athens	550057000087	40	Athens High	Regular School	No	High	09	12	2020	grade_11	44	44
2318778	WI	Eau Claire	school	5500630	217	Public school	Augusta	550063000093	40	Augusta High	Regular School	No	High	09	12	2020	grade_11	36	36
2318794	WI	Saint Croix	school	5500720	231	Public school	Baldwin-Woodville Area	550072000094	40	Baldwin-Woodville High	Regular School	No	High	09	12	2020	grade_11	112	112
2318822	WI	La Crosse	school	5500780	245	Public school	Bangor	550078000101	40	Bangor Middle/High	Regular School	No	High	06	12	2020	grade_11	40	40
2318841	WI	Sauk	school	5500810	280	Public school	Baraboo	550081000103	40	Baraboo High	Regular School	No	High	09	12	2020	grade_11	205	205
2318883	WI	Iowa	school	5500840	287	Public school	Barneveld	550084000112	40	Barneveld High	Regular School	No	High	06	12	2020	grade_11	34	34
2318947	WI	Bayfield	school	5500900	315	Public school	Bayfield	550090000121	40	Bayfield High	Regular School	No	High	09	12	2020	grade_11	22	22
2318965	WI	Dodge	school	5500960	336	Public school	Beaver Dam Unified	550096000123	40	Beaver Dam High	Regular School	No	High	09	12	2020	grade_11	269	269
2319048	WI	Dane	school	5500990	350	Public school	Belleville	550099000132	40	Belleville High	Regular School	No	High	09	12	2020	grade_11	77	77
2319066	WI	Lafayette	school	5501020	364	Public school	Belmont Community	550102000135	40	Belmont High	Regular School	No	High	07	12	2020	grade_11	20	20
2319193	WI	Lafayette	school	5501110	427	Public school	Benton	550111000161	40	Benton High	Regular School	No	High	09	12	2020	grade_11	13	13
2319201	WI	Green Lake	school	5501140	434	Public school	Berlin Area	550114000162	40	Berlin High	Regular School	No	High	09	12	2020	grade_11	129	129
2319241	WI	Washburn	school	5501170	441	Public school	Birchwood	550117000169	40	Birchwood High	Regular School	No	High	09	12	2020	grade_11	21	21
2319281	WI	Jackson	school	5501260	476	Public school	Black River Falls	550126000175	40	Black River Falls High	Regular School	No	High	09	12	2020	grade_11	130	130
2319325	WI	Chippewa	school	5501350	497	Public school	Bloomer	550135000184	40	Bloomer High	Regular School	No	High	09	12	2020	grade_11	98	98
2319345	WI	Shawano	school	5501470	602	Public school	Bonduel	550147000189	40	Bonduel High	Regular School	No	High	09	12	2020	grade_11	73	73
2319363	WI	Grant	school	5501500	609	Public school	Boscobel Area	550150000193	40	Boscobel High	Regular School	No	High	09	12	2020	grade_11	60	60
2319381	WI	Shawano	school	5501560	623	Public school	Bowler	550156000200	40	Bowler High	Regular School	No	High	07	12	2020	grade_11	21	21
2319397	WI	Dunn	school	5501590	637	Public school	Boyceville Community	550159000202	40	Boyceville High	Regular School	No	High	09	12	2020	grade_11	52	52
2319435	WI	Calumet	school	5501680	658	Public school	Brillion	550168000207	40	Brillion High	Regular School	No	High	09	12	2020	grade_11	83	83
2319456	WI	Green	school	5501740	700	Public school	Brodhead	550174000212	40	Brodhead High	Regular School	No	High	09	12	2020	grade_11	82	82
2319482	WI	Milwaukee	school	5501800	721	Public school	Brown Deer	550180000230	40	Brown Deer Middle/High	Regular School	No	High	06	12	2020	grade_11	115	115
2319499	WI	Rusk	school	5501830	735	Public school	Bruce	550183000235	40	Bruce High	Regular School	No	High	09	12	2020	grade_11	34	34
2319585	WI	Ashland	school	5501920	840	Public school	Butternut	550192000246	40	Butternut High	Regular School	No	High	06	12	2020	grade_11	15	15
2319606	WI	Chippewa	school	5502040	870	Public school	Cadott Community	550204000248	40	Cadott High	Regular School	No	High	09	12	2020	grade_11	53	53
2319624	WI	Columbia	school	5502070	882	Public school	Cambria-Friesland	550207000250	40	Cambria Friesland Middle/High	Regular School	No	High	06	12	2020	grade_11	33	33
2319641	WI	Dane	school	5502100	896	Public school	Cambridge	550210000255	40	Cambridge High	Regular School	No	High	09	12	2020	grade_11	62	62
2319679	WI	Barron	school	5502130	903	Public school	Cameron	550213000257	40	Cameron High	Regular School	No	High	09	12	2020	grade_11	69	69
2319701	WI	Fond du Lac	school	5502160	910	Public school	Campbellsport	550216000259	40	Campbellsport High	Regular School	No	High	09	12	2020	grade_11	93	93
2319739	WI	Monroe	school	5502340	980	Public school	Cashton	550234000263	40	Cashton Middle/High	Regular School	No	High	06	12	2020	grade_11	68	68
2319756	WI	Grant	school	5502400	994	Public school	Cassville	550240000265	40	Cassville High	Regular School	No	High	07	12	2020	grade_11	19	19
2319771	WI	Sheboygan	school	5502430	1029	Public school	Cedar Grove-Belgium Area	550243000267	40	Cedar Grove-Belgium High	Regular School	No	High	09	12	2020	grade_11	77	77
2319908	WI	Calumet	school	5502520	1085	Public school	Chilton	550252000279	40	Chilton High	Regular School	No	High	09	12	2020	grade_11	92	92
2319980	WI	Polk	school	5502580	1120	Public school	Clayton	550258000290	40	Clayton High	Regular School	No	High	09	12	2020	grade_11	23	23
2319989	WI	Polk	school	5502610	1127	Public school	Clear Lake	550261000292	40	Clear Lake High	Regular School	No	High	09	12	2020	grade_11	42	42
2320025	WI	Waupaca	school	5502670	1141	Public school	Clintonville	550267000302	40	Clintonville High	Regular School	No	High	09	12	2020	grade_11	108	108
2320054	WI	Buffalo	school	5502700	1155	Public school	Cochrane-Fountain City	550270000307	40	Cochrane-Fountain City High	Regular School	No	High	07	12	2020	grade_11	51	51
2320068	WI	Clark	school	5502730	1162	Public school	Colby	550273000309	40	Colby High	Regular School	No	High	09	12	2020	grade_11	77	77
2320116	WI	Dunn	school	5502790	1176	Public school	Colfax	550279000316	40	Colfax High	Regular School	No	High	07	12	2020	grade_11	58	58
2320129	WI	Columbia	school	5502820	1183	Public school	Columbus	550282000318	40	Columbus High	Regular School	No	High	09	12	2020	grade_11	104	104
2320156	WI	Chippewa	school	5502880	1204	Public school	Cornell	550288000324	40	Cornell High	Regular School	No	High	09	12	2020	grade_11	34	34
2320193	WI	Marinette	school	5502970	1232	Public school	Crivitz	550297000330	40	Crivitz High	Regular School	No	High	09	12	2020	grade_11	44	44