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 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
333521	WI	Milwaukee	school	5509600	3619	Public school	Milwaukee	550960001215	8	Marshall High	Regular School	No	High	09	12	2017	grade_11	188	188
2326140	WI	Milwaukee	school	5509600	3619	Public school	Milwaukee	550960001215	8	Marshall High	Regular School	No	High	09	12	2020	grade_11	240	240
2341033	WI	Milwaukee	school	5509600	3619	Public school	Milwaukee	550960001215	8	Marshall High	Regular School	No	High	09	12	2021	grade_11	297	297
3081895	WI	Milwaukee	school	5509600	3619	Public school	Milwaukee	550960001215	8	Marshall High	Regular School	No	High	09	12	2019	grade_11	195	195
3096602	WI	Milwaukee	school	5509600	3619	Public school	Milwaukee	550960001215	8	Marshall High	Regular School	No	High	09	12	2018	grade_11	158	158
124163	WI	Door	school	5514610	5642	Public school	Sturgeon Bay	551461001894	10	Sturgeon Bay High	Regular School	No	3.0	09	12	2015	grade_11	93	93
294097	WI	Door	school	5514610	5642	Public school	Sturgeon Bay	551461001894	10	Sturgeon Bay High	Regular School	No	3.0	09	12	2016	grade_11	103	103
338003	WI	Door	school	5514610	5642	Public school	Sturgeon Bay	551461001894	10	Sturgeon Bay High	Regular School	No	High	09	12	2017	grade_11	93	93
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
2345534	WI	Door	school	5514610	5642	Public school	Sturgeon Bay	551461001894	10	Sturgeon Bay High	Regular School	No	High	09	12	2021	grade_11	102	102
3086330	WI	Door	school	5514610	5642	Public school	Sturgeon Bay	551461001894	10	Sturgeon Bay High	Regular School	No	High	09	12	2019	grade_11	99	99
3101054	WI	Door	school	5514610	5642	Public school	Sturgeon Bay	551461001894	10	Sturgeon Bay High	Regular School	No	High	09	12	2018	grade_11	98	98
112931	WI	Trempealeau	school	5500016	485	Public school	Blair-Taylor	550001602378	11	Blair-Taylor Middle/High	Regular School	No	3.0	07	12	2015	grade_11	55	55
282912	WI	Trempealeau	school	5500016	485	Public school	Blair-Taylor	550001602378	11	Blair-Taylor Middle/High	Regular School	No	3.0	07	12	2016	grade_11	41	41
326812	WI	Trempealeau	school	5500016	485	Public school	Blair-Taylor	550001602378	11	Blair-Taylor Middle/High	Regular School	No	High	07	12	2017	grade_11	31	31
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
2334094	WI	Trempealeau	school	5500016	485	Public school	Blair-Taylor	550001602378	11	Blair-Taylor Middle/High	Regular School	No	High	07	12	2021	grade_11	41	41
3075097	WI	Trempealeau	school	5500016	485	Public school	Blair-Taylor	550001602378	11	Blair-Taylor Middle/High	Regular School	No	High	07	12	2019	grade_11	44	44
3089857	WI	Trempealeau	school	5500016	485	Public school	Blair-Taylor	550001602378	11	Blair-Taylor Middle/High	Regular School	No	High	07	12	2018	grade_11	49	49
118890	WI	Milwaukee	school	5509600	3619	Public school	Milwaukee	550960001127	12	Bay View Middle and High	Regular School	No	3.0	08	12	2015	grade_11	162	162
288877	WI	Milwaukee	school	5509600	3619	Public school	Milwaukee	550960001127	12	Bay View High	Regular School	No	3.0	09	12	2016	grade_11	158	158
332749	WI	Milwaukee	school	5509600	3619	Public school	Milwaukee	550960001127	12	Bay View High	Regular School	No	High	09	12	2017	grade_11	174	174
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
2340270	WI	Milwaukee	school	5509600	3619	Public school	Milwaukee	550960001127	12	Bay View High	Regular School	No	High	09	12	2021	grade_11	230	230
3081116	WI	Milwaukee	school	5509600	3619	Public school	Milwaukee	550960001127	12	Bay View High	Regular School	No	High	09	12	2019	grade_11	189	189
3095831	WI	Milwaukee	school	5509600	3619	Public school	Milwaukee	550960001127	12	Bay View High	Regular School	No	High	09	12	2018	grade_11	209	209
118909	WI	Milwaukee	school	5509600	3619	Public school	Milwaukee	550960001218	14	Bradley Technology High	Regular School	No	3.0	09	12	2015	grade_11	214	214
288894	WI	Milwaukee	school	5509600	3619	Public school	Milwaukee	550960001218	14	Bradley Technology High	Regular School	No	3.0	09	12	2016	grade_11	190	190
332766	WI	Milwaukee	school	5509600	3619	Public school	Milwaukee	550960001218	14	Bradley Technology High	Regular School	No	High	09	12	2017	grade_11	182	182
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
2340298	WI	Milwaukee	school	5509600	3619	Public school	Milwaukee	550960001218	14	Bradley Technology High	Regular School	No	High	09	12	2021	grade_11	210	210
3081142	WI	Milwaukee	school	5509600	3619	Public school	Milwaukee	550960001218	14	Bradley Technology High	Regular School	No	High	09	12	2019	grade_11	231	231
3095856	WI	Milwaukee	school	5509600	3619	Public school	Milwaukee	550960001218	14	Bradley Technology High	Regular School	No	High	09	12	2018	grade_11	184	184
121790	WI	Jefferson	school	5511350	4221	Public school	Palmyra-Eagle Area	551135002274	15	Palmyra-Eagle High	Regular School	No	3.0	09	12	2015	grade_11	86	86
291751	WI	Jefferson	school	5511350	4221	Public school	Palmyra-Eagle Area	551135002274	15	Palmyra-Eagle High	Regular School	No	3.0	09	12	2016	grade_11	69	69
335620	WI	Jefferson	school	5511350	4221	Public school	Palmyra-Eagle Area	551135002274	15	Palmyra-Eagle High	Regular School	No	High	09	12	2017	grade_11	84	84
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
2343136	WI	Jefferson	school	5511350	4221	Public school	Palmyra-Eagle Area	551135002274	15	Palmyra-Eagle High	Regular School	No	High	09	12	2021	grade_11	40	40
3084000	WI	Jefferson	school	5511350	4221	Public school	Palmyra-Eagle Area	551135002274	15	Palmyra-Eagle High	Regular School	No	High	09	12	2019	grade_11	66	66
3098698	WI	Jefferson	school	5511350	4221	Public school	Palmyra-Eagle Area	551135002274	15	Palmyra-Eagle High	Regular School	No	High	09	12	2018	grade_11	73	73
119327	WI	Milwaukee	school	5509600	3619	Public school	Milwaukee	550960001180	18	Hamilton High	Regular School	No	3.0	09	12	2015	grade_11	400	400
289310	WI	Milwaukee	school	5509600	3619	Public school	Milwaukee	550960001180	18	Hamilton High	Regular School	No	3.0	09	12	2016	grade_11	384	384
333180	WI	Milwaukee	school	5509600	3619	Public school	Milwaukee	550960001180	18	Hamilton High	Regular School	No	High	09	12	2017	grade_11	385	385
2325811	WI	Milwaukee	school	5509600	3619	Public school	Milwaukee	550960001180	18	Hamilton High	Regular School	No	High	09	12	2020	grade_11	284	284
2340707	WI	Milwaukee	school	5509600	3619	Public school	Milwaukee	550960001180	18	Hamilton High	Regular School	No	High	09	12	2021	grade_11	302	302
3081556	WI	Milwaukee	school	5509600	3619	Public school	Milwaukee	550960001180	18	Hamilton High	Regular School	No	High	09	12	2019	grade_11	380	380
3096265	WI	Milwaukee	school	5509600	3619	Public school	Milwaukee	550960001180	18	Hamilton High	Regular School	No	High	09	12	2018	grade_11	380	380
112058	WI	Outagamie	school	5500390	147	Public school	Appleton Area	550039000047	20	East High	Regular School	No	3.0	09	12	2015	grade_11	291	291
112282	WI	Waukesha	school	5506180	2450	Public school	Arrowhead UHS	550618000678	20	Arrowhead High	Regular School	No	3.0	09	12	2015	grade_11	580	580
112291	WI	Ashland	school	5500510	170	Public school	Ashland	550051000073	20	Ashland High	Regular School	No	3.0	09	12	2015	grade_11	168	168
112320	WI	Brown	school	5500540	182	Public school	Ashwaubenon	550054000081	20	Ashwaubenon High	Regular School	No	3.0	09	12	2015	grade_11	271	271
112799	WI	Rock	school	5501080	422	Public school	Beloit Turner	550108000156	20	Turner High	Regular School	No	3.0	09	12	2015	grade_11	113	113
112842	WI	Walworth	school	5515480	6013	Public school	Big Foot UHS	551548001982	20	Big Foot High	Regular School	No	3.0	09	12	2015	grade_11	128	128
112892	WI	Lafayette	school	5505730	2240	Public school	Black Hawk	550573000605	20	Black Hawk High	Regular School	No	3.0	09	12	2015	grade_11	30	30
113140	WI	Racine	school	5501890	777	Public school	Burlington Area	550189000237	20	Burlington High	Regular School	No	3.0	09	12	2015	grade_11	287	287
113375	WI	Ozaukee	school	5502460	1015	Public school	Cedarburg	550246000270	20	Cedarburg High	Regular School	No	3.0	09	12	2015	grade_11	290	290
113418	WI	Kenosha	school	5513290	5054	Public school	Central/Westosha UHS	551329001751	20	Central High	Regular School	No	3.0	09	12	2015	grade_11	293	293
114001	WI	Brown	school	5503210	1414	Public school	De Pere	550321000361	20	De Pere High	Regular School	No	3.0	09	12	2015	grade_11	311	311
114088	WI	Walworth	school	5503640	1380	Public school	Delavan-Darien	550364000386	20	Delavan-Darien High	Regular School	No	3.0	09	12	2015	grade_11	206	206
114590	WI	Waukesha	school	5501770	714	Public school	Elmbrook	550177000214	20	Central High	Regular School	No	3.0	09	12	2015	grade_11	358	358
115177	WI	Oconto	school	5505250	2128	Public school	Gillett	550525000564	20	Gillett High	Regular School	No	3.0	09	12	2015	grade_11	38	38
115858	WI	Washington	school	5506120	2436	Public school	Hartford UHS	550612000677	20	Hartford High	Regular School	No	3.0	09	12	2015	grade_11	361	361
116108	WI	Brown	school	5506630	2604	Public school	Howard-Suamico	550663000716	20	Bay Port High	Regular School	No	3.0	09	12	2015	grade_11	437	437
117029	WI	Vernon	school	5512540	5960	Public school	Kickapoo Area	551254001658	20	Kickapoo High	Regular School	No	4.0	06	12	2015	grade_11	35	35
117145	WI	La Crosse	school	5507530	2849	Public school	La Crosse	550753000854	20	Central High	Regular School	No	3.0	09	12	2015	grade_11	251	251
117363	WI	Walworth	school	5507650	2884	Public school	Lake Geneva-Genoa City UHS	550765000884	20	Badger High	Regular School	No	3.0	09	12	2015	grade_11	337	337
117405	WI	Oneida	school	5509630	3647	Public school	Lakeland UHS	550963001274	20	Lakeland High	Regular School	No	3.0	09	12	2015	grade_11	178	178
117410	WI	Grant	school	5507770	2912	Public school	Lancaster Community	550777000891	20	Lancaster High	Regular School	No	3.0	09	12	2015	grade_11	87	87
117428	WI	Forest	school	5507830	2940	Public school	Laona	550783000893	20	Laona High	Regular School	No	3.0	07	12	2015	grade_11	16	16
119537	WI	Milwaukee	school	5509600	3619	Public school	Milwaukee	550960001199	20	King International	Regular School	No	3.0	09	12	2015	grade_11	325	325
121049	WI	Milwaukee	school	5505490	2177	Public school	Nicolet UHS	550549000584	20	Nicolet High	Regular School	No	3.0	09	12	2015	grade_11	297	297
121054	WI	Waukesha	school	5510710	3976	Public school	Norris	551071001395	20	Norris High	Regular School	No	4.0	06	12	2015	grade_11	5	5
121236	WI	Monroe	school	5510770	3990	Public school	Norwalk-Ontario-Wilton	551077001402	20	Brookwood High	Regular School	No	3.0	07	12	2015	grade_11	53	53
121925	WI	Vilas	school	5511710	4330	Public school	Phelps	551171001540	20	Phelps High	Regular School	No	3.0	09	12	2015	grade_11	4	4
124638	WI	Racine	school	5515150	5852	Public school	Union Grove UHS	551515001963	20	Union Grove High	Regular School	No	3.0	09	12	2015	grade_11	250	250
124902	WI	Racine	school	5515600	6083	Public school	Waterford UHS	551560001988	20	Waterford High	Regular School	No	3.0	09	12	2015	grade_11	292	292
125406	WI	Milwaukee	school	5515990	6244	Public school	Wauwatosa	551599002077	20	East High	Regular School	No	3.0	09	12	2015	grade_11	312	312
125572	WI	Milwaukee	school	5516260	6300	Public school	West Allis-West Milwaukee	551626002101	20	Central High	Regular School	No	3.0	09	12	2015	grade_11	346	346
126104	WI	Kenosha	school	5516770	6545	Public school	Wilmot UHS	551677002188	20	Wilmot High	Regular School	No	3.0	09	12	2015	grade_11	286	286
282034	WI	Outagamie	school	5500390	147	Public school	Appleton Area	550039000047	20	East High	Regular School	No	3.0	09	12	2016	grade_11	372	372
282256	WI	Waukesha	school	5506180	2450	Public school	Arrowhead UHS	550618000678	20	Arrowhead High	Regular School	No	3.0	09	12	2016	grade_11	542	542
282270	WI	Ashland	school	5500510	170	Public school	Ashland	550051000073	20	Ashland High	Regular School	No	3.0	09	12	2016	grade_11	147	147
282300	WI	Brown	school	5500540	182	Public school	Ashwaubenon	550054000081	20	Ashwaubenon High	Regular School	No	3.0	09	12	2016	grade_11	261	261
282778	WI	Rock	school	5501080	422	Public school	Beloit Turner	550108000156	20	Turner High	Regular School	No	3.0	09	12	2016	grade_11	128	128
282821	WI	Walworth	school	5515480	6013	Public school	Big Foot UHS	551548001982	20	Big Foot High	Regular School	No	3.0	09	12	2016	grade_11	124	124
282873	WI	Lafayette	school	5505730	2240	Public school	Black Hawk	550573000605	20	Black Hawk High	Regular School	No	3.0	09	12	2016	grade_11	28	28
283122	WI	Racine	school	5501890	777	Public school	Burlington Area	550189000237	20	Burlington High	Regular School	No	3.0	09	12	2016	grade_11	323	323
283357	WI	Ozaukee	school	5502460	1015	Public school	Cedarburg	550246000270	20	Cedarburg High	Regular School	No	3.0	09	12	2016	grade_11	291	291
283400	WI	Kenosha	school	5513290	5054	Public school	Central/Westosha UHS	551329001751	20	Central High	Regular School	No	3.0	09	12	2016	grade_11	304	304
283979	WI	Brown	school	5503210	1414	Public school	De Pere	550321000361	20	De Pere High	Regular School	No	3.0	09	12	2016	grade_11	376	376
284066	WI	Walworth	school	5503640	1380	Public school	Delavan-Darien	550364000386	20	Delavan-Darien High	Regular School	No	3.0	09	12	2016	grade_11	198	198
284589	WI	Waukesha	school	5501770	714	Public school	Elmbrook	550177000214	20	Central High	Regular School	No	3.0	09	12	2016	grade_11	302	302
285185	WI	Oconto	school	5505250	2128	Public school	Gillett	550525000564	20	Gillett High	Regular School	No	3.0	09	12	2016	grade_11	35	35
285861	WI	Washington	school	5506120	2436	Public school	Hartford UHS	550612000677	20	Hartford High	Regular School	No	3.0	09	12	2016	grade_11	347	347
286105	WI	Brown	school	5506630	2604	Public school	Howard-Suamico	550663000716	20	Bay Port High	Regular School	No	3.0	09	12	2016	grade_11	481	481
287035	WI	Vernon	school	5512540	5960	Public school	Kickapoo Area	551254001658	20	Kickapoo High	Regular School	No	4.0	06	12	2016	grade_11	45	45
287137	WI	La Crosse	school	5507530	2849	Public school	La Crosse	550753000854	20	Central High	Regular School	No	3.0	09	12	2016	grade_11	286	286
287355	WI	Walworth	school	5507650	2884	Public school	Lake Geneva-Genoa City UHS	550765000884	20	Badger High	Regular School	No	3.0	09	12	2016	grade_11	341	341
287399	WI	Oneida	school	5509630	3647	Public school	Lakeland UHS	550963001274	20	Lakeland High	Regular School	No	3.0	09	12	2016	grade_11	175	175
287404	WI	Grant	school	5507770	2912	Public school	Lancaster Community	550777000891	20	Lancaster High	Regular School	No	3.0	09	12	2016	grade_11	73	73
287422	WI	Forest	school	5507830	2940	Public school	Laona	550783000893	20	Laona High	Regular School	No	3.0	07	12	2016	grade_11	16	16