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 (school_state_id > :p3 or (school_state_id = :p3 and rowid > :p2)) order by school_state_id, rowid 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
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
289514	WI	Milwaukee	school	5509600	3619	Public school	Milwaukee	550960001199	20	King International	Regular School	No	3.0	09	12	2016	grade_11	384	384
291009	WI	Milwaukee	school	5505490	2177	Public school	Nicolet UHS	550549000584	20	Nicolet High	Regular School	No	3.0	09	12	2016	grade_11	248	248
291014	WI	Waukesha	school	5510710	3976	Public school	Norris	551071001395	20	Norris High	Regular School	No	4.0	06	12	2016	grade_11	9	9
291205	WI	Monroe	school	5510770	3990	Public school	Norwalk-Ontario-Wilton	551077001402	20	Brookwood High	Regular School	No	3.0	07	12	2016	grade_11	55	55
291886	WI	Vilas	school	5511710	4330	Public school	Phelps	551171001540	20	Phelps High	Regular School	No	3.0	09	12	2016	grade_11	10	10
294571	WI	Racine	school	5515150	5852	Public school	Union Grove UHS	551515001963	20	Union Grove High	Regular School	No	3.0	09	12	2016	grade_11	266	266
294838	WI	Racine	school	5515600	6083	Public school	Waterford UHS	551560001988	20	Waterford High	Regular School	No	3.0	09	12	2016	grade_11	243	243
295347	WI	Milwaukee	school	5515990	6244	Public school	Wauwatosa	551599002077	20	East High	Regular School	No	3.0	09	12	2016	grade_11	277	277
295512	WI	Milwaukee	school	5516260	6300	Public school	West Allis-West Milwaukee	551626002101	20	Central High	Regular School	No	3.0	09	12	2016	grade_11	381	381
296041	WI	Kenosha	school	5516770	6545	Public school	Wilmot UHS	551677002188	20	Wilmot High	Regular School	No	3.0	09	12	2016	grade_11	274	274
325929	WI	Outagamie	school	5500390	147	Public school	Appleton Area	550039000047	20	East High	Regular School	No	High	09	12	2017	grade_11	352	352
326155	WI	Waukesha	school	5506180	2450	Public school	Arrowhead UHS	550618000678	20	Arrowhead High	Regular School	No	High	09	12	2017	grade_11	554	554
326169	WI	Ashland	school	5500510	170	Public school	Ashland	550051000073	20	Ashland High	Regular School	No	High	09	12	2017	grade_11	177	177
326198	WI	Brown	school	5500540	182	Public school	Ashwaubenon	550054000081	20	Ashwaubenon High	Regular School	No	High	09	12	2017	grade_11	259	259
326679	WI	Rock	school	5501080	422	Public school	Beloit Turner	550108000156	20	Turner High	Regular School	No	High	09	12	2017	grade_11	105	105
326723	WI	Walworth	school	5515480	6013	Public school	Big Foot UHS	551548001982	20	Big Foot High	Regular School	No	High	09	12	2017	grade_11	125	125
326774	WI	Lafayette	school	5505730	2240	Public school	Black Hawk	550573000605	20	Black Hawk High	Regular School	No	High	09	12	2017	grade_11	25	25
327019	WI	Racine	school	5501890	777	Public school	Burlington Area	550189000237	20	Burlington High	Regular School	No	High	09	12	2017	grade_11	268	268
327253	WI	Ozaukee	school	5502460	1015	Public school	Cedarburg	550246000270	20	Cedarburg High	Regular School	No	High	09	12	2017	grade_11	284	284
327299	WI	Kenosha	school	5513290	5054	Public school	Central/Westosha UHS	551329001751	20	Central High	Regular School	No	High	09	12	2017	grade_11	274	274
327898	WI	Brown	school	5503210	1414	Public school	De Pere	550321000361	20	De Pere High	Regular School	No	High	09	12	2017	grade_11	348	348
327984	WI	Walworth	school	5503640	1380	Public school	Delavan-Darien	550364000386	20	Delavan-Darien High	Regular School	No	High	09	12	2017	grade_11	174	174
328488	WI	Waukesha	school	5501770	714	Public school	Elmbrook	550177000214	20	Central High	Regular School	No	High	09	12	2017	grade_11	344	344
329063	WI	Oconto	school	5505250	2128	Public school	Gillett	550525000564	20	Gillett High	Regular School	No	High	09	12	2017	grade_11	49	49
329740	WI	Washington	school	5506120	2436	Public school	Hartford UHS	550612000677	20	Hartford High	Regular School	No	High	09	12	2017	grade_11	344	344
329987	WI	Brown	school	5506630	2604	Public school	Howard-Suamico	550663000716	20	Bay Port High	Regular School	No	High	09	12	2017	grade_11	466	466
330914	WI	Vernon	school	5512540	5960	Public school	Kickapoo Area	551254001658	20	Kickapoo High	Regular School	No	Other	06	12	2017	grade_11	41	41
331012	WI	La Crosse	school	5507530	2849	Public school	La Crosse	550753000854	20	Central High	Regular School	No	High	09	12	2017	grade_11	243	243
331228	WI	Walworth	school	5507650	2884	Public school	Lake Geneva-Genoa City UHS	550765000884	20	Badger High	Regular School	No	High	09	12	2017	grade_11	355	355
331273	WI	Oneida	school	5509630	3647	Public school	Lakeland UHS	550963001274	20	Lakeland High	Regular School	No	High	09	12	2017	grade_11	157	157
331278	WI	Grant	school	5507770	2912	Public school	Lancaster Community	550777000891	20	Lancaster High	Regular School	No	High	09	12	2017	grade_11	79	79
331296	WI	Forest	school	5507830	2940	Public school	Laona	550783000893	20	Laona High	Regular School	No	High	07	12	2017	grade_11	21	21
333380	WI	Milwaukee	school	5509600	3619	Public school	Milwaukee	550960001199	20	King International	Regular School	No	High	09	12	2017	grade_11	370	370
334872	WI	Milwaukee	school	5505490	2177	Public school	Nicolet UHS	550549000584	20	Nicolet High	Regular School	No	High	09	12	2017	grade_11	279	279
334877	WI	Waukesha	school	5510710	3976	Public school	Norris	551071001395	20	Norris High	Regular School	No	Other	06	12	2017	grade_11	3	3
335059	WI	Monroe	school	5510770	3990	Public school	Norwalk-Ontario-Wilton	551077001402	20	Brookwood High	Regular School	No	High	07	12	2017	grade_11	60	60
335760	WI	Vilas	school	5511710	4330	Public school	Phelps	551171001540	20	Phelps High	Regular School	No	High	09	12	2017	grade_11	15	15
338487	WI	Racine	school	5515150	5852	Public school	Union Grove UHS	551515001963	20	Union Grove High	Regular School	No	High	09	12	2017	grade_11	245	245
338740	WI	Racine	school	5515600	6083	Public school	Waterford UHS	551560001988	20	Waterford High	Regular School	No	High	09	12	2017	grade_11	278	278
339273	WI	Milwaukee	school	5515990	6244	Public school	Wauwatosa	551599002077	20	East High	Regular School	No	High	09	12	2017	grade_11	286	286
339439	WI	Milwaukee	school	5516260	6300	Public school	West Allis-West Milwaukee	551626002101	20	Central High	Regular School	No	High	09	12	2017	grade_11	319	319
339980	WI	Kenosha	school	5516770	6545	Public school	Wilmot UHS	551677002188	20	Wilmot High	Regular School	No	High	09	12	2017	grade_11	262	262
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
2333211	WI	Outagamie	school	5500390	147	Public school	Appleton Area	550039000047	20	East High	Regular School	No	High	09	12	2021	grade_11	346	346
2333439	WI	Waukesha	school	5506180	2450	Public school	Arrowhead UHS	550618000678	20	Arrowhead High	Regular School	No	High	09	12	2021	grade_11	528	528
2333444	WI	Ashland	school	5500510	170	Public school	Ashland	550051000073	20	Ashland High	Regular School	No	High	09	12	2021	grade_11	140	140
2333479	WI	Brown	school	5500540	182	Public school	Ashwaubenon	550054000081	20	Ashwaubenon High	Regular School	No	High	09	12	2021	grade_11	269	269
2333952	WI	Rock	school	5501080	422	Public school	Beloit Turner	550108000156	20	Turner High	Regular School	No	High	09	12	2021	grade_11	123	123
2333996	WI	Walworth	school	5515480	6013	Public school	Big Foot UHS	551548001982	20	Big Foot High	Regular School	No	High	09	12	2021	grade_11	137	137
2334056	WI	Lafayette	school	5505730	2240	Public school	Black Hawk	550573000605	20	Black Hawk High	Regular School	No	High	09	12	2021	grade_11	20	20
2334301	WI	Racine	school	5501890	777	Public school	Burlington Area	550189000237	20	Burlington High	Regular School	No	High	09	12	2021	grade_11	238	238
2334563	WI	Ozaukee	school	5502460	1015	Public school	Cedarburg	550246000270	20	Cedarburg High	Regular School	No	High	09	12	2021	grade_11	285	285
2334612	WI	Kenosha	school	5513290	5054	Public school	Central/Westosha UHS	551329001751	20	Central High	Regular School	No	High	09	12	2021	grade_11	297	297
2335239	WI	Brown	school	5503210	1414	Public school	De Pere	550321000361	20	De Pere High	Regular School	No	High	09	12	2021	grade_11	353	353
2335328	WI	Walworth	school	5503640	1380	Public school	Delavan-Darien	550364000386	20	Delavan-Darien High	Regular School	No	High	09	12	2021	grade_11	186	186
2335860	WI	Waukesha	school	5501770	714	Public school	Elmbrook	550177000214	20	Central High	Regular School	No	High	09	12	2021	grade_11	320	320
2336447	WI	Oconto	school	5505250	2128	Public school	Gillett	550525000564	20	Gillett High	Regular School	No	High	09	12	2021	grade_11	37	37
2337125	WI	Washington	school	5506120	2436	Public school	Hartford UHS	550612000677	20	Hartford High	Regular School	No	High	09	12	2021	grade_11	333	333
2337390	WI	Brown	school	5506630	2604	Public school	Howard-Suamico	550663000716	20	Bay Port High	Regular School	No	High	09	12	2021	grade_11	456	456
2338355	WI	Vernon	school	5512540	5960	Public school	Kickapoo Area	551254001658	20	Kickapoo High	Regular School	No	High	06	12	2021	grade_11	44	44
2338465	WI	La Crosse	school	5507530	2849	Public school	La Crosse	550753000854	20	Central High	Regular School	No	High	09	12	2021	grade_11	261	261
2338695	WI	Walworth	school	5507650	2884	Public school	Lake Geneva-Genoa City UHS	550765000884	20	Badger High	Regular School	No	High	09	12	2021	grade_11	317	317
2338748	WI	Oneida	school	5509630	3647	Public school	Lakeland UHS	550963001274	20	Lakeland High	Regular School	No	High	09	12	2021	grade_11	173	173
2338758	WI	Grant	school	5507770	2912	Public school	Lancaster Community	550777000891	20	Lancaster High	Regular School	No	High	09	12	2021	grade_11	69	69
2338776	WI	Forest	school	5507830	2940	Public school	Laona	550783000893	20	Laona High	Regular School	No	High	07	12	2021	grade_11	17	17
2340892	WI	Milwaukee	school	5509600	3619	Public school	Milwaukee	550960001199	20	King International	Regular School	No	High	09	12	2021	grade_11	372	372
2342363	WI	Milwaukee	school	5505490	2177	Public school	Nicolet UHS	550549000584	20	Nicolet High	Regular School	No	High	09	12	2021	grade_11	279	279
2342368	WI	Waukesha	school	5510710	3976	Public school	Norris	551071001395	20	Norris Academy	Regular School	No	Other	KG	12	2021	grade_11	6	6
2342587	WI	Monroe	school	5510770	3990	Public school	Norwalk-Ontario-Wilton	551077001402	20	Brookwood High	Regular School	No	High	07	12	2021	grade_11	43	43