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 district desc 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
126363	WI	Brown	school	5517190	6734	Public school	Wrightstown Community	551719002229	40	Wrightstown High		Regular School	No	3.0	09	12	2015	grade_10	114	114
296300	WI	Brown	school	5517190	6734	Public school	Wrightstown Community	551719002229	40	Wrightstown High		Regular School	No	3.0	09	12	2016	grade_10	123	123
340241	WI	Brown	school	5517190	6734	Public school	Wrightstown Community	551719002229	40	Wrightstown High		Regular School	No	High	09	12	2017	grade_10	123	123
2332906	WI	Brown	school	5517190	6734	Public school	Wrightstown Community	551719002229	40	Wrightstown High		Regular School	No	High	09	12	2020	grade_10	118	118
2347912	WI	Brown	school	5517190	6734	Public school	Wrightstown Community	551719002229	40	Wrightstown High		Regular School	No	High	09	12	2021	grade_10	111	111
3088617	WI	Brown	school	5517190	6734	Public school	Wrightstown Community	551719002229	40	Wrightstown High		Regular School	No	High	09	12	2019	grade_10	106	106
3103319	WI	Brown	school	5517190	6734	Public school	Wrightstown Community	551719002229	40	Wrightstown High		Regular School	No	High	09	12	2018	grade_10	129	129
126317	WI	Juneau	school	5517130	6713	Public school	Wonewoc-Union Center	551713002225	80	Wonewoc-Center High		Regular School	No	3.0	09	12	2015	grade_10	24	24
296244	WI	Juneau	school		6713	Public Schools-Multidistrict Charters	Wonewoc-Union Center		9405	Juneau County Charter School	charter						2016	grade_10	1	1
296254	WI	Juneau	school	5517130	6713	Public school	Wonewoc-Union Center	551713002225	80	Wonewoc-Center High		Regular School	No	3.0	09	12	2016	grade_10	20	20
340193	WI	Juneau	school	5517130	6713	Public school	Wonewoc-Union Center	551713002225	80	Wonewoc-Center High		Regular School	No	High	09	12	2017	grade_10	32	32
2332852	WI	Juneau	school	5517130	6713	Public school	Wonewoc-Union Center	551713002225	80	Wonewoc-Center High		Regular School	No	High	09	12	2020	grade_10	27	27
2347847	WI	Juneau	school	5517130	6713	Public school	Wonewoc-Union Center	551713002225	80	Wonewoc-Center High		Regular School	No	High	09	12	2021	grade_10	15	15
2347857	WI	Juneau	school	5517130	6713	Public school	Wonewoc-Union Center	551713003059	850	Wonewoc-Center Virtual Academy	charter	Regular School	Yes	Other	KG	12	2021	grade_10	3	3
3088563	WI	Juneau	school	5517130	6713	Public school	Wonewoc-Union Center	551713002225	80	Wonewoc-Center High		Regular School	No	High	09	12	2019	grade_10	35	35
3103268	WI	Juneau	school	5517130	6713	Public school	Wonewoc-Union Center	551713002225	80	Wonewoc-Center High		Regular School	No	High	09	12	2018	grade_10	22	22
126301	WI	Shawano	school	5517100	6692	Public school	Wittenberg-Birnamwood	551710002222	140	Wittenberg-Birnamwood High		Regular School	No	3.0	09	12	2015	grade_10	83	83
296239	WI	Shawano	school	5517100	6692	Public school	Wittenberg-Birnamwood	551710002222	140	Wittenberg-Birnamwood High		Regular School	No	3.0	09	12	2016	grade_10	86	86
340179	WI	Shawano	school	5517100	6692	Public school	Wittenberg-Birnamwood	551710002222	140	Wittenberg-Birnamwood High		Regular School	No	High	09	12	2017	grade_10	72	72
2332838	WI	Shawano	school	5517100	6692	Public school	Wittenberg-Birnamwood	551710002222	140	Wittenberg-Birnamwood High		Regular School	No	High	09	12	2020	grade_10	85	85
2347828	WI	Shawano	school	5517100	6692	Public school	Wittenberg-Birnamwood	551710002222	140	Wittenberg-Birnamwood High		Regular School	No	High	09	12	2021	grade_10	72	72
3088548	WI	Shawano	school	5517100	6692	Public school	Wittenberg-Birnamwood	551710002222	140	Wittenberg-Birnamwood High		Regular School	No	High	09	12	2019	grade_10	88	88
3103253	WI	Shawano	school	5517100	6692	Public school	Wittenberg-Birnamwood	551710002222	140	Wittenberg-Birnamwood High		Regular School	No	High	09	12	2018	grade_10	77	77
126221	WI	Wood	school	5517070	6685	Public school	Wisconsin Rapids	551707002209	160	Lincoln High		Regular School	No	3.0	10	12	2015	grade_10	372	372
126234	WI	Wood	school	5517070	6685	Public school	Wisconsin Rapids	551707003365	430	River Cities High		Alternative Education School	No	3.0	09	12	2015	grade_10	9	9
296159	WI	Wood	school	5517070	6685	Public school	Wisconsin Rapids	551707002209	160	Lincoln High		Regular School	No	3.0	10	12	2016	grade_10	398	398
296172	WI	Wood	school	5517070	6685	Public school	Wisconsin Rapids	551707003365	430	River Cities High		Alternative Education School	No	3.0	09	12	2016	grade_10	5	5
340099	WI	Wood	school	5517070	6685	Public school	Wisconsin Rapids	551707002209	160	Lincoln High		Regular School	No	High	10	12	2017	grade_10	388	388
340112	WI	Wood	school	5517070	6685	Public school	Wisconsin Rapids	551707003365	430	River Cities High		Alternative School	No	High	09	12	2017	grade_10	3	3
2332766	WI	Wood	school	5517070	6685	Public school	Wisconsin Rapids	551707002209	160	Lincoln High		Regular School	No	High	09	12	2020	grade_10	386	386
2332780	WI	Wood	school	5517070	6685	Public school	Wisconsin Rapids	551707003365	430	River Cities High		Alternative School	No	High	09	12	2020	grade_10	3	3
2347756	WI	Wood	school	5517070	6685	Public school	Wisconsin Rapids	551707002209	160	Lincoln High		Regular School	No	High	09	12	2021	grade_10	344	344
2347770	WI	Wood	school	5517070	6685	Public school	Wisconsin Rapids	551707003365	430	River Cities High		Alternative School	No	High	09	12	2021	grade_10	2	2
3088476	WI	Wood	school	5517070	6685	Public school	Wisconsin Rapids	551707002209	160	Lincoln High		Regular School	No	High	09	12	2019	grade_10	365	365
3088490	WI	Wood	school	5517070	6685	Public school	Wisconsin Rapids	551707003365	430	River Cities High		Alternative School	No	High	09	12	2019	grade_10	1	1
3103173	WI	Wood	school	5517070	6685	Public school	Wisconsin Rapids	551707002209	160	Lincoln High		Regular School	No	High	10	12	2018	grade_10	355	355
3103186	WI	Wood	school	5517070	6685	Public school	Wisconsin Rapids	551707003365	430	River Cities High		Alternative School	No	High	09	12	2018	grade_10	3	3
126186	WI	Dane	school	5501230	469	Public school	Wisconsin Heights	550123000172	60	Wisconsin Heights High		Regular School	No	3.0	09	12	2015	grade_10	56	56
296124	WI	Dane	school	5501230	469	Public school	Wisconsin Heights	550123000172	60	Wisconsin Heights High		Regular School	No	3.0	09	12	2016	grade_10	51	51
340063	WI	Dane	school	5501230	469	Public school	Wisconsin Heights	550123000172	60	Wisconsin Heights High		Regular School	No	High	09	12	2017	grade_10	67	67
2332721	WI	Dane	school	5501230	469	Public school	Wisconsin Heights	550123000172	60	Wisconsin Heights High		Regular School	No	High	09	12	2020	grade_10	50	50
2347712	WI	Dane	school	5501230	469	Public school	Wisconsin Heights	550123000172	60	Wisconsin Heights High		Regular School	No	High	09	12	2021	grade_10	52	52
3088432	WI	Dane	school	5501230	469	Public school	Wisconsin Heights	550123000172	60	Wisconsin Heights High		Regular School	No	High	09	12	2019	grade_10	58	58
3103137	WI	Dane	school	5501230	469	Public school	Wisconsin Heights	550123000172	60	Wisconsin Heights High		Regular School	No	High	09	12	2018	grade_10	58	58
126171	WI	Sauk	school	5517040	6678	Public school	Wisconsin Dells	551704002200	100	Wisconsin Dells High		Regular School	No	3.0	09	12	2015	grade_10	101	101
296109	WI	Sauk	school	5517040	6678	Public school	Wisconsin Dells	551704002200	100	Wisconsin Dells High		Regular School	No	3.0	09	12	2016	grade_10	102	102
340048	WI	Sauk	school	5517040	6678	Public school	Wisconsin Dells	551704002200	100	Wisconsin Dells High		Regular School	No	High	09	12	2017	grade_10	94	94
2332706	WI	Sauk	school	5517040	6678	Public school	Wisconsin Dells	551704002200	100	Wisconsin Dells High		Regular School	No	High	09	12	2020	grade_10	134	134
2347693	WI	Sauk	school	5517040	6678	Public school	Wisconsin Dells	551704002200	100	Wisconsin Dells High		Regular School	No	High	09	12	2021	grade_10	150	150
3088417	WI	Sauk	school	5517040	6678	Public school	Wisconsin Dells	551704002200	100	Wisconsin Dells High		Regular School	No	High	09	12	2019	grade_10	128	128
3103122	WI	Sauk	school	5517040	6678	Public school	Wisconsin Dells	551704002200	100	Wisconsin Dells High		Regular School	No	High	09	12	2018	grade_10	123	123
126134	WI	Sawyer	school	5516860	6615	Public school	Winter	551686002195	80	Winter High		Regular School	No	3.0	09	12	2015	grade_10	17	17
296072	WI	Sawyer	school	5516860	6615	Public school	Winter	551686002195	80	Winter High		Regular School	No	3.0	09	12	2016	grade_10	16	16
340011	WI	Sawyer	school	5516860	6615	Public school	Winter	551686002195	80	Winter High		Regular School	No	High	09	12	2017	grade_10	20	20
2332669	WI	Sawyer	school	5516860	6615	Public school	Winter	551686002195	80	Winter High		Regular School	No	High	09	12	2020	grade_10	10	10
2347660	WI	Sawyer	school	5516860	6615	Public school	Winter	551686002195	80	Winter High		Regular School	No	High	09	12	2021	grade_10	18	18
3088380	WI	Sawyer	school	5516860	6615	Public school	Winter	551686002195	80	Winter High		Regular School	No	High	09	12	2019	grade_10	21	21
3103085	WI	Sawyer	school	5516860	6615	Public school	Winter	551686002195	80	Winter High		Regular School	No	High	09	12	2018	grade_10	20	20
126116	WI	Winnebago	school	5516830	6608	Public school	Winneconne Community	551683002191	60	Winneconne High		Regular School	No	3.0	09	12	2015	grade_10	123	123
296054	WI	Winnebago	school	5516830	6608	Public school	Winneconne Community	551683002191	60	Winneconne High		Regular School	No	3.0	09	12	2016	grade_10	125	125
339993	WI	Winnebago	school	5516830	6608	Public school	Winneconne Community	551683002191	60	Winneconne High		Regular School	No	High	09	12	2017	grade_10	122	122
2332652	WI	Winnebago	school	5516830	6608	Public school	Winneconne Community	551683002191	60	Winneconne High		Regular School	No	High	09	12	2020	grade_10	125	125
2347642	WI	Winnebago	school	5516830	6608	Public school	Winneconne Community	551683002191	60	Winneconne High		Regular School	No	High	09	12	2021	grade_10	135	135
3088363	WI	Winnebago	school	5516830	6608	Public school	Winneconne Community	551683002191	60	Winneconne High		Regular School	No	High	09	12	2019	grade_10	135	135
3103068	WI	Winnebago	school	5516830	6608	Public school	Winneconne Community	551683002191	60	Winneconne High		Regular School	No	High	09	12	2018	grade_10	130	130
126103	WI	Kenosha	school	5516770	6545	Public school	Wilmot UHS	551677002188	20	Wilmot High		Regular School	No	3.0	09	12	2015	grade_10	275	275
296040	WI	Kenosha	school	5516770	6545	Public school	Wilmot UHS	551677002188	20	Wilmot High		Regular School	No	3.0	09	12	2016	grade_10	265	265
339979	WI	Kenosha	school	5516770	6545	Public school	Wilmot UHS	551677002188	20	Wilmot High		Regular School	No	High	09	12	2017	grade_10	285	285
2332638	WI	Kenosha	school	5516770	6545	Public school	Wilmot UHS	551677002188	20	Wilmot High		Regular School	No	High	09	12	2020	grade_10	223	223
2347628	WI	Kenosha	school	5516770	6545	Public school	Wilmot UHS	551677002188	20	Wilmot High		Regular School	No	High	09	12	2021	grade_10	241	241
3088349	WI	Kenosha	school	5516770	6545	Public school	Wilmot UHS	551677002188	20	Wilmot High		Regular School	No	High	09	12	2019	grade_10	257	257
3103054	WI	Kenosha	school	5516770	6545	Public school	Wilmot UHS	551677002188	20	Wilmot High		Regular School	No	High	09	12	2018	grade_10	255	255
126095	WI	Walworth	school	5516740	6482	Public school	Williams Bay	551674002187	40	Williams Bay High		Regular School	No	3.0	09	12	2015	grade_10	42	42
296031	WI	Walworth	school	5516740	6482	Public school	Williams Bay	551674002187	40	Williams Bay High		Regular School	No	3.0	09	12	2016	grade_10	55	55
339970	WI	Walworth	school	5516740	6482	Public school	Williams Bay	551674002187	40	Williams Bay High		Regular School	No	High	09	12	2017	grade_10	51	51
2332629	WI	Walworth	school	5516740	6482	Public school	Williams Bay	551674002187	40	Williams Bay High		Regular School	No	High	09	12	2020	grade_10	60	60
2347619	WI	Walworth	school	5516740	6482	Public school	Williams Bay	551674002187	40	Williams Bay High		Regular School	No	High	09	12	2021	grade_10	62	62
3088340	WI	Walworth	school	5516740	6482	Public school	Williams Bay	551674002187	40	Williams Bay High		Regular School	No	High	09	12	2019	grade_10	53	53
3103045	WI	Walworth	school	5516740	6482	Public school	Williams Bay	551674002187	40	Williams Bay High		Regular School	No	High	09	12	2018	grade_10	53	53
126078	WI	Waushara	school	5516710	6475	Public school	Wild Rose	551671002185	60	Wild Rose High		Regular School	No	4.0	06	12	2015	grade_10	45	45
296013	WI	Waushara	school	5516710	6475	Public school	Wild Rose	551671002185	60	Wild Rose High		Regular School	No	4.0	06	12	2016	grade_10	37	37
339953	WI	Waushara	school	5516710	6475	Public school	Wild Rose	551671002185	60	Wild Rose High		Regular School	No	Other	06	12	2017	grade_10	37	37
2332611	WI	Waushara	school	5516710	6475	Public school	Wild Rose	551671002185	60	Wild Rose High		Regular School	No	High	06	12	2020	grade_10	52	52
2347599	WI	Waushara	school	5516710	6475	Public school	Wild Rose	551671002185	60	Wild Rose High		Regular School	No	High	06	12	2021	grade_10	37	37
3088322	WI	Waushara	school	5516710	6475	Public school	Wild Rose	551671002185	60	Wild Rose High		Regular School	No	High	06	12	2019	grade_10	42	42
3103025	WI	Waushara	school	5516710	6475	Public school	Wild Rose	551671002185	60	Wild Rose High		Regular School	No	High	06	12	2018	grade_10	58	58
126053	WI	Milwaukee	school	5506000	6470	Public school	Whitnall	550600000661	100	Whitnall High		Regular School	No	3.0	09	12	2015	grade_10	193	193
295989	WI	Milwaukee	school	5506000	6470	Public school	Whitnall	550600000661	100	Whitnall High		Regular School	No	3.0	09	12	2016	grade_10	207	207
339928	WI	Milwaukee	school	5506000	6470	Public school	Whitnall	550600000661	100	Whitnall High		Regular School	No	High	09	12	2017	grade_10	216	216
2332593	WI	Milwaukee	school	5506000	6470	Public school	Whitnall	550600000661	100	Whitnall High		Regular School	No	High	09	12	2020	grade_10	204	204
2347581	WI	Milwaukee	school	5506000	6470	Public school	Whitnall	550600000661	100	Whitnall High		Regular School	No	High	09	12	2021	grade_10	214	214
3088304	WI	Milwaukee	school	5506000	6470	Public school	Whitnall	550600000661	100	Whitnall High		Regular School	No	High	09	12	2019	grade_10	215	215
3103000	WI	Milwaukee	school	5506000	6470	Public school	Whitnall	550600000661	100	Whitnall High		Regular School	No	High	09	12	2018	grade_10	203	203
125995	WI	Walworth	school	5516680	6461	Public school	Whitewater Unified	551668002901	9803	JEDI Virtual K-12	charter	Alternative Education School	Yes	4.0	KG	12	2015	grade_10	6	6
126027	WI	Walworth	school	5516680	6461	Public school	Whitewater Unified	551668002182	140	Whitewater High		Regular School	No	3.0	09	12	2015	grade_10	121	121
295962	WI	Walworth	school	5516680	6461	Public school	Whitewater Unified	551668002182	140	Whitewater High		Regular School	No	3.0	09	12	2016	grade_10	151	151
339860	WI	Walworth	school	5516680	6461	Public school	Whitewater Unified	551668002901	9803	JEDI Virtual K-12 - Jefferson and Eastern Dane County Interactive	charter	Alternative School	Yes	Other	PK	12	2017	grade_10	4	4
339900	WI	Walworth	school	5516680	6461	Public school	Whitewater Unified	551668002182	140	Whitewater High		Regular School	No	High	09	12	2017	grade_10	151	151
2332532	WI	Walworth	school		6461	Public Schools-Multidistrict Charters	Whitewater Unified		9803	JEDI Virtual K-12 - Jefferson and Eastern Dane County Interactive	charter						2020	grade_10	1	1
2332566	WI	Walworth	school	5516680	6461	Public school	Whitewater Unified	551668002182	140	Whitewater High		Regular School	No	High	09	12	2020	grade_10	153	153
2347517	WI	Walworth	school		6461	Public Schools-Multidistrict Charters	Whitewater Unified		9803	JEDI Virtual K-12 - Jefferson and Eastern Dane County Interactive	charter						2021	grade_10	4	4