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
333523	WI	Milwaukee	school	5509600	3619	Public school	Milwaukee	550960001215	8	Marshall High	Regular School	No	High	09	12	2017	grade_9	323	323
2326142	WI	Milwaukee	school	5509600	3619	Public school	Milwaukee	550960001215	8	Marshall High	Regular School	No	High	09	12	2020	grade_9	317	317
2341035	WI	Milwaukee	school	5509600	3619	Public school	Milwaukee	550960001215	8	Marshall High	Regular School	No	High	09	12	2021	grade_9	344	344
3081897	WI	Milwaukee	school	5509600	3619	Public school	Milwaukee	550960001215	8	Marshall High	Regular School	No	High	09	12	2019	grade_9	278	278
3096604	WI	Milwaukee	school	5509600	3619	Public school	Milwaukee	550960001215	8	Marshall High	Regular School	No	High	09	12	2018	grade_9	268	268
123979	WI	Portage	school	5514490	5607	Public school	Stevens Point Area Public	551449001868	10	Benjamin Franklin Junior High	Regular School	No	2.0	07	09	2015	grade_9	257	257
124165	WI	Door	school	5514610	5642	Public school	Sturgeon Bay	551461001894	10	Sturgeon Bay High	Regular School	No	3.0	09	12	2015	grade_9	93	93
293912	WI	Portage	school	5514490	5607	Public school	Stevens Point Area Public	551449001868	10	Benjamin Franklin Junior High	Regular School	No	2.0	07	09	2016	grade_9	281	281
294099	WI	Door	school	5514610	5642	Public school	Sturgeon Bay	551461001894	10	Sturgeon Bay High	Regular School	No	3.0	09	12	2016	grade_9	96	96
337814	WI	Portage	school	5514490	5607	Public school	Stevens Point Area Public	551449001868	10	Benjamin Franklin Junior High	Regular School	No	Other	07	09	2017	grade_9	283	283
338005	WI	Door	school	5514610	5642	Public school	Sturgeon Bay	551461001894	10	Sturgeon Bay High	Regular School	No	High	09	12	2017	grade_9	102	102
2330430	WI	Portage	school	5514490	5607	Public school	Stevens Point Area Public	551449001868	10	Benjamin Franklin Junior High	Regular School	No	Middle	07	09	2020	grade_9	268	268
2330626	WI	Door	school	5514610	5642	Public school	Sturgeon Bay	551461001894	10	Sturgeon Bay High	Regular School	No	High	09	12	2020	grade_9	81	81
2345326	WI	Portage	school	5514490	5607	Public school	Stevens Point Area Public	551449001868	10	Benjamin Franklin Junior High	Regular School	No	Middle	07	09	2021	grade_9	274	274
2345536	WI	Door	school	5514610	5642	Public school	Sturgeon Bay	551461001894	10	Sturgeon Bay High	Regular School	No	High	09	12	2021	grade_9	119	119
3086140	WI	Portage	school	5514490	5607	Public school	Stevens Point Area Public	551449001868	10	Benjamin Franklin Junior High	Regular School	No	Middle	07	09	2019	grade_9	283	283
3086332	WI	Door	school	5514610	5642	Public school	Sturgeon Bay	551461001894	10	Sturgeon Bay High	Regular School	No	High	09	12	2019	grade_9	105	105
3100870	WI	Portage	school	5514490	5607	Public school	Stevens Point Area Public	551449001868	10	Benjamin Franklin Junior High	Regular School	No	Middle	07	09	2018	grade_9	258	258
3101056	WI	Door	school	5514610	5642	Public school	Sturgeon Bay	551461001894	10	Sturgeon Bay High	Regular School	No	High	09	12	2018	grade_9	100	100
112935	WI	Trempealeau	school	5500016	485	Public school	Blair-Taylor	550001602378	11	Blair-Taylor Middle/High	Regular School	No	3.0	07	12	2015	grade_9	33	33
282916	WI	Trempealeau	school	5500016	485	Public school	Blair-Taylor	550001602378	11	Blair-Taylor Middle/High	Regular School	No	3.0	07	12	2016	grade_9	49	49
326816	WI	Trempealeau	school	5500016	485	Public school	Blair-Taylor	550001602378	11	Blair-Taylor Middle/High	Regular School	No	High	07	12	2017	grade_9	46	46
2319314	WI	Trempealeau	school	5500016	485	Public school	Blair-Taylor	550001602378	11	Blair-Taylor Middle/High	Regular School	No	High	07	12	2020	grade_9	47	47
2334098	WI	Trempealeau	school	5500016	485	Public school	Blair-Taylor	550001602378	11	Blair-Taylor Middle/High	Regular School	No	High	07	12	2021	grade_9	44	44
3075101	WI	Trempealeau	school	5500016	485	Public school	Blair-Taylor	550001602378	11	Blair-Taylor Middle/High	Regular School	No	High	07	12	2019	grade_9	40	40
3089861	WI	Trempealeau	school	5500016	485	Public school	Blair-Taylor	550001602378	11	Blair-Taylor Middle/High	Regular School	No	High	07	12	2018	grade_9	46	46
118893	WI	Milwaukee	school	5509600	3619	Public school	Milwaukee	550960001127	12	Bay View Middle and High	Regular School	No	3.0	08	12	2015	grade_9	405	405
288879	WI	Milwaukee	school	5509600	3619	Public school	Milwaukee	550960001127	12	Bay View High	Regular School	No	3.0	09	12	2016	grade_9	380	380
332751	WI	Milwaukee	school	5509600	3619	Public school	Milwaukee	550960001127	12	Bay View High	Regular School	No	High	09	12	2017	grade_9	309	309
2325379	WI	Milwaukee	school	5509600	3619	Public school	Milwaukee	550960001127	12	Bay View High	Regular School	No	High	09	12	2020	grade_9	352	352
2340272	WI	Milwaukee	school	5509600	3619	Public school	Milwaukee	550960001127	12	Bay View High	Regular School	No	High	09	12	2021	grade_9	291	291
3081118	WI	Milwaukee	school	5509600	3619	Public school	Milwaukee	550960001127	12	Bay View High	Regular School	No	High	09	12	2019	grade_9	342	342
3095833	WI	Milwaukee	school	5509600	3619	Public school	Milwaukee	550960001127	12	Bay View High	Regular School	No	High	09	12	2018	grade_9	341	341
118911	WI	Milwaukee	school	5509600	3619	Public school	Milwaukee	550960001218	14	Bradley Technology High	Regular School	No	3.0	09	12	2015	grade_9	331	331
288896	WI	Milwaukee	school	5509600	3619	Public school	Milwaukee	550960001218	14	Bradley Technology High	Regular School	No	3.0	09	12	2016	grade_9	330	330
332769	WI	Milwaukee	school	5509600	3619	Public school	Milwaukee	550960001218	14	Bradley Technology High	Regular School	No	High	09	12	2017	grade_9	335	335
2325406	WI	Milwaukee	school	5509600	3619	Public school	Milwaukee	550960001218	14	Bradley Technology High	Regular School	No	High	09	12	2020	grade_9	358	358
2340300	WI	Milwaukee	school	5509600	3619	Public school	Milwaukee	550960001218	14	Bradley Technology High	Regular School	No	High	09	12	2021	grade_9	344	344
3081145	WI	Milwaukee	school	5509600	3619	Public school	Milwaukee	550960001218	14	Bradley Technology High	Regular School	No	High	09	12	2019	grade_9	351	351
3095858	WI	Milwaukee	school	5509600	3619	Public school	Milwaukee	550960001218	14	Bradley Technology High	Regular School	No	High	09	12	2018	grade_9	356	356
121792	WI	Jefferson	school	5511350	4221	Public school	Palmyra-Eagle Area	551135002274	15	Palmyra-Eagle High	Regular School	No	3.0	09	12	2015	grade_9	86	86
291753	WI	Jefferson	school	5511350	4221	Public school	Palmyra-Eagle Area	551135002274	15	Palmyra-Eagle High	Regular School	No	3.0	09	12	2016	grade_9	71	71
335622	WI	Jefferson	school	5511350	4221	Public school	Palmyra-Eagle Area	551135002274	15	Palmyra-Eagle High	Regular School	No	High	09	12	2017	grade_9	62	62
2328250	WI	Jefferson	school	5511350	4221	Public school	Palmyra-Eagle Area	551135002274	15	Palmyra-Eagle High	Regular School	No	High	09	12	2020	grade_9	50	50
2343138	WI	Jefferson	school	5511350	4221	Public school	Palmyra-Eagle Area	551135002274	15	Palmyra-Eagle High	Regular School	No	High	09	12	2021	grade_9	50	50
3084002	WI	Jefferson	school	5511350	4221	Public school	Palmyra-Eagle Area	551135002274	15	Palmyra-Eagle High	Regular School	No	High	09	12	2019	grade_9	49	49
3098700	WI	Jefferson	school	5511350	4221	Public school	Palmyra-Eagle Area	551135002274	15	Palmyra-Eagle High	Regular School	No	High	09	12	2018	grade_9	65	65
119329	WI	Milwaukee	school	5509600	3619	Public school	Milwaukee	550960001180	18	Hamilton High	Regular School	No	3.0	09	12	2015	grade_9	609	609
289312	WI	Milwaukee	school	5509600	3619	Public school	Milwaukee	550960001180	18	Hamilton High	Regular School	No	3.0	09	12	2016	grade_9	633	633
333182	WI	Milwaukee	school	5509600	3619	Public school	Milwaukee	550960001180	18	Hamilton High	Regular School	No	High	09	12	2017	grade_9	661	661
2325813	WI	Milwaukee	school	5509600	3619	Public school	Milwaukee	550960001180	18	Hamilton High	Regular School	No	High	09	12	2020	grade_9	464	464
2340709	WI	Milwaukee	school	5509600	3619	Public school	Milwaukee	550960001180	18	Hamilton High	Regular School	No	High	09	12	2021	grade_9	425	425
3081558	WI	Milwaukee	school	5509600	3619	Public school	Milwaukee	550960001180	18	Hamilton High	Regular School	No	High	09	12	2019	grade_9	475	475
3096267	WI	Milwaukee	school	5509600	3619	Public school	Milwaukee	550960001180	18	Hamilton High	Regular School	No	High	09	12	2018	grade_9	440	440
112060	WI	Outagamie	school	5500390	147	Public school	Appleton Area	550039000047	20	East High	Regular School	No	3.0	09	12	2015	grade_9	352	352
112284	WI	Waukesha	school	5506180	2450	Public school	Arrowhead UHS	550618000678	20	Arrowhead High	Regular School	No	3.0	09	12	2015	grade_9	560	560
112293	WI	Ashland	school	5500510	170	Public school	Ashland	550051000073	20	Ashland High	Regular School	No	3.0	09	12	2015	grade_9	185	185
112322	WI	Brown	school	5500540	182	Public school	Ashwaubenon	550054000081	20	Ashwaubenon High	Regular School	No	3.0	09	12	2015	grade_9	261	261
112801	WI	Rock	school	5501080	422	Public school	Beloit Turner	550108000156	20	Turner High	Regular School	No	3.0	09	12	2015	grade_9	119	119
112844	WI	Walworth	school	5515480	6013	Public school	Big Foot UHS	551548001982	20	Big Foot High	Regular School	No	3.0	09	12	2015	grade_9	138	138
112894	WI	Lafayette	school	5505730	2240	Public school	Black Hawk	550573000605	20	Black Hawk High	Regular School	No	3.0	09	12	2015	grade_9	24	24
113142	WI	Racine	school	5501890	777	Public school	Burlington Area	550189000237	20	Burlington High	Regular School	No	3.0	09	12	2015	grade_9	267	267
113377	WI	Ozaukee	school	5502460	1015	Public school	Cedarburg	550246000270	20	Cedarburg High	Regular School	No	3.0	09	12	2015	grade_9	288	288
113420	WI	Kenosha	school	5513290	5054	Public school	Central/Westosha UHS	551329001751	20	Central High	Regular School	No	3.0	09	12	2015	grade_9	268	268
114003	WI	Brown	school	5503210	1414	Public school	De Pere	550321000361	20	De Pere High	Regular School	No	3.0	09	12	2015	grade_9	353	353
114090	WI	Walworth	school	5503640	1380	Public school	Delavan-Darien	550364000386	20	Delavan-Darien High	Regular School	No	3.0	09	12	2015	grade_9	181	181
114592	WI	Waukesha	school	5501770	714	Public school	Elmbrook	550177000214	20	Central High	Regular School	No	3.0	09	12	2015	grade_9	345	345
115179	WI	Oconto	school	5505250	2128	Public school	Gillett	550525000564	20	Gillett High	Regular School	No	3.0	09	12	2015	grade_9	40	40
115860	WI	Washington	school	5506120	2436	Public school	Hartford UHS	550612000677	20	Hartford High	Regular School	No	3.0	09	12	2015	grade_9	333	333
116110	WI	Brown	school	5506630	2604	Public school	Howard-Suamico	550663000716	20	Bay Port High	Regular School	No	3.0	09	12	2015	grade_9	453	453
117034	WI	Vernon	school	5512540	5960	Public school	Kickapoo Area	551254001658	20	Kickapoo High	Regular School	No	4.0	06	12	2015	grade_9	40	40
117147	WI	La Crosse	school	5507530	2849	Public school	La Crosse	550753000854	20	Central High	Regular School	No	3.0	09	12	2015	grade_9	232	232
117365	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_9	354	354
117407	WI	Oneida	school	5509630	3647	Public school	Lakeland UHS	550963001274	20	Lakeland High	Regular School	No	3.0	09	12	2015	grade_9	176	176
117412	WI	Grant	school	5507770	2912	Public school	Lancaster Community	550777000891	20	Lancaster High	Regular School	No	3.0	09	12	2015	grade_9	87	87
117432	WI	Forest	school	5507830	2940	Public school	Laona	550783000893	20	Laona High	Regular School	No	3.0	07	12	2015	grade_9	24	24
119539	WI	Milwaukee	school	5509600	3619	Public school	Milwaukee	550960001199	20	King International	Regular School	No	3.0	09	12	2015	grade_9	422	422
121051	WI	Milwaukee	school	5505490	2177	Public school	Nicolet UHS	550549000584	20	Nicolet High	Regular School	No	3.0	09	12	2015	grade_9	286	286
121059	WI	Waukesha	school	5510710	3976	Public school	Norris	551071001395	20	Norris High	Regular School	No	4.0	06	12	2015	grade_9	17	17
121240	WI	Monroe	school	5510770	3990	Public school	Norwalk-Ontario-Wilton	551077001402	20	Brookwood High	Regular School	No	3.0	07	12	2015	grade_9	58	58
121927	WI	Vilas	school	5511710	4330	Public school	Phelps	551171001540	20	Phelps High	Regular School	No	3.0	09	12	2015	grade_9	15	15
124640	WI	Racine	school	5515150	5852	Public school	Union Grove UHS	551515001963	20	Union Grove High	Regular School	No	3.0	09	12	2015	grade_9	247	247
124904	WI	Racine	school	5515600	6083	Public school	Waterford UHS	551560001988	20	Waterford High	Regular School	No	3.0	09	12	2015	grade_9	277	277
125408	WI	Milwaukee	school	5515990	6244	Public school	Wauwatosa	551599002077	20	East High	Regular School	No	3.0	09	12	2015	grade_9	294	294
125574	WI	Milwaukee	school	5516260	6300	Public school	West Allis-West Milwaukee	551626002101	20	Central High	Regular School	No	3.0	09	12	2015	grade_9	378	378
126106	WI	Kenosha	school	5516770	6545	Public school	Wilmot UHS	551677002188	20	Wilmot High	Regular School	No	3.0	09	12	2015	grade_9	275	275
282036	WI	Outagamie	school	5500390	147	Public school	Appleton Area	550039000047	20	East High	Regular School	No	3.0	09	12	2016	grade_9	310	310
282258	WI	Waukesha	school	5506180	2450	Public school	Arrowhead UHS	550618000678	20	Arrowhead High	Regular School	No	3.0	09	12	2016	grade_9	520	520
282272	WI	Ashland	school	5500510	170	Public school	Ashland	550051000073	20	Ashland High	Regular School	No	3.0	09	12	2016	grade_9	156	156
282302	WI	Brown	school	5500540	182	Public school	Ashwaubenon	550054000081	20	Ashwaubenon High	Regular School	No	3.0	09	12	2016	grade_9	257	257
282780	WI	Rock	school	5501080	422	Public school	Beloit Turner	550108000156	20	Turner High	Regular School	No	3.0	09	12	2016	grade_9	121	121
282823	WI	Walworth	school	5515480	6013	Public school	Big Foot UHS	551548001982	20	Big Foot High	Regular School	No	3.0	09	12	2016	grade_9	114	114
282875	WI	Lafayette	school	5505730	2240	Public school	Black Hawk	550573000605	20	Black Hawk High	Regular School	No	3.0	09	12	2016	grade_9	31	31
283124	WI	Racine	school	5501890	777	Public school	Burlington Area	550189000237	20	Burlington High	Regular School	No	3.0	09	12	2016	grade_9	274	274
283359	WI	Ozaukee	school	5502460	1015	Public school	Cedarburg	550246000270	20	Cedarburg High	Regular School	No	3.0	09	12	2016	grade_9	268	268
283402	WI	Kenosha	school	5513290	5054	Public school	Central/Westosha UHS	551329001751	20	Central High	Regular School	No	3.0	09	12	2016	grade_9	291	291
283981	WI	Brown	school	5503210	1414	Public school	De Pere	550321000361	20	De Pere High	Regular School	No	3.0	09	12	2016	grade_9	332	332
284068	WI	Walworth	school	5503640	1380	Public school	Delavan-Darien	550364000386	20	Delavan-Darien High	Regular School	No	3.0	09	12	2016	grade_9	199	199
284591	WI	Waukesha	school	5501770	714	Public school	Elmbrook	550177000214	20	Central High	Regular School	No	3.0	09	12	2016	grade_9	310	310
285187	WI	Oconto	school	5505250	2128	Public school	Gillett	550525000564	20	Gillett High	Regular School	No	3.0	09	12	2016	grade_9	30	30
285863	WI	Washington	school	5506120	2436	Public school	Hartford UHS	550612000677	20	Hartford High	Regular School	No	3.0	09	12	2016	grade_9	344	344