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 county 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
112371	WI	Wood	school	5500600	203	Public school	Auburndale	550060000091	60	Auburndale High		Regular School	No	4.0	06	12	2015	grade_10	52	52
118201	WI	Wood	school	5508820	3339	Public school	Marshfield Unified	550882001021	120	Marshfield High		Regular School	No	3.0	09	12	2015	grade_10	316	316
120799	WI	Wood	school	5510380	3906	Public school	Nekoosa	551038001360	60	Nekoosa High		Regular School	No	3.0	09	12	2015	grade_10	103	103
121958	WI	Wood	school	5511790	4368	Public school	Pittsville	551179001547	40	Pittsville High		Regular School	No	3.0	09	12	2015	grade_10	40	40
122033	WI	Wood	school	5511970	4508	Public school	Port Edwards	551197001564	40	John Edwards High		Regular School	No	3.0	09	12	2015	grade_10	16	16
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
282351	WI	Wood	school	5500600	203	Public school	Auburndale	550060000091	60	Auburndale High		Regular School	No	4.0	06	12	2016	grade_10	63	63
288191	WI	Wood	school	5508820	3339	Public school	Marshfield Unified	550882001021	120	Marshfield High		Regular School	No	3.0	09	12	2016	grade_10	305	305
290764	WI	Wood	school	5510380	3906	Public school	Nekoosa	551038001360	60	Nekoosa High		Regular School	No	3.0	09	12	2016	grade_10	102	102
291919	WI	Wood	school	5511790	4368	Public school	Pittsville	551179001547	40	Pittsville High		Regular School	No	3.0	09	12	2016	grade_10	50	50
291993	WI	Wood	school	5511970	4508	Public school	Port Edwards	551197001564	40	John Edwards High		Regular School	No	3.0	09	12	2016	grade_10	42	42
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
326249	WI	Wood	school	5500600	203	Public school	Auburndale	550060000091	60	Auburndale High		Regular School	No	Other	06	12	2017	grade_10	63	63
332057	WI	Wood	school	5508820	3339	Public school	Marshfield Unified	550882001021	120	Marshfield High		Regular School	No	High	09	12	2017	grade_10	297	297
334638	WI	Wood	school	5510380	3906	Public school	Nekoosa	551038001360	60	Nekoosa High		Regular School	No	High	09	12	2017	grade_10	95	95
335794	WI	Wood	school	5511790	4368	Public school	Pittsville	551179001547	40	Pittsville High		Regular School	No	High	09	12	2017	grade_10	44	44
335800	WI	Wood	school		4368	Public Schools-Multidistrict Charters	Pittsville		9100	Rural Virtual Academy	charter						2017	grade_10	1	1
335874	WI	Wood	school	5511970	4508	Public school	Port Edwards	551197001564	40	John Edwards High		Regular School	No	High	09	12	2017	grade_10	22	22
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
2318748	WI	Wood	school	5500600	203	Public school	Auburndale	550060000091	60	Auburndale High		Regular School	No	High	06	12	2020	grade_10	59	59
2318757	WI	Wood	school		203	Public Schools-Multidistrict Charters	Auburndale		9100	Rural Virtual Academy	charter						2020	grade_10	1	1
2324677	WI	Wood	school	5508820	3339	Public school	Marshfield Unified	550882001021	120	Marshfield High		Regular School	No	High	09	12	2020	grade_10	321	321
2324696	WI	Wood	school		3339	Public Schools-Multidistrict Charters	Marshfield Unified		9100	Rural Virtual Academy	charter						2020	grade_10	3	3
2327246	WI	Wood	school	5510380	3906	Public school	Nekoosa	551038002617	400	Nekoosa Academy		Alternative School	No	High	09	12	2020	grade_10	2	2
2327250	WI	Wood	school	5510380	3906	Public school	Nekoosa	551038001360	60	Nekoosa High		Regular School	No	High	09	12	2020	grade_10	82	82
2327256	WI	Wood	school	5510380	3906	Public school	Nekoosa	551038003089	800	WISE Academy	charter	Regular School	Yes	Other	PK	12	2020	grade_10	7	7
2328440	WI	Wood	school	5511790	4368	Public school	Pittsville	551179001547	40	Pittsville High		Regular School	No	High	09	12	2020	grade_10	47	47
2328521	WI	Wood	school	5511970	4508	Public school	Port Edwards	551197001564	40	John Edwards High		Regular School	No	High	09	12	2020	grade_10	34	34
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
2333531	WI	Wood	school	5500600	203	Public school	Auburndale	550060000091	60	Auburndale High		Regular School	No	High	06	12	2021	grade_10	52	52
2333539	WI	Wood	school		203	Public Schools-Multidistrict Charters	Auburndale		9100	Rural Virtual Academy	charter						2021	grade_10	4	4
2339565	WI	Wood	school	5508820	3339	Public school	Marshfield Unified	550882001021	120	Marshfield High		Regular School	No	High	09	12	2021	grade_10	274	274
2339584	WI	Wood	school		3339	Public Schools-Multidistrict Charters	Marshfield Unified		9100	Rural Virtual Academy	charter						2021	grade_10	7	7
2342115	WI	Wood	school	5510380	3906	Public school	Nekoosa	551038002617	400	Nekoosa Academy		Alternative School	No	High	09	12	2021	grade_10	2	2
2342119	WI	Wood	school	5510380	3906	Public school	Nekoosa	551038001360	60	Nekoosa High		Regular School	No	High	09	12	2021	grade_10	72	72
2342125	WI	Wood	school	5510380	3906	Public school	Nekoosa	551038003089	800	WISE Academy	charter	Regular School	Yes	Other	PK	12	2021	grade_10	6	6
2343332	WI	Wood	school	5511790	4368	Public school	Pittsville	551179001547	40	Pittsville High		Regular School	No	High	09	12	2021	grade_10	49	49
2343337	WI	Wood	school		4368	Public Schools-Multidistrict Charters	Pittsville		9100	Rural Virtual Academy	charter						2021	grade_10	1	1
2343414	WI	Wood	school	5511970	4508	Public school	Port Edwards	551197001564	40	John Edwards High		Regular School	No	High	09	12	2021	grade_10	29	29
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
3074530	WI	Wood	school	5500600	203	Public school	Auburndale	550060000091	60	Auburndale High		Regular School	No	High	06	12	2019	grade_10	68	68
3080403	WI	Wood	school	5508820	3339	Public school	Marshfield Unified	550882001021	120	Marshfield High		Regular School	No	High	09	12	2019	grade_10	315	315
3080422	WI	Wood	school		3339	Public Schools-Multidistrict Charters	Marshfield Unified		9100	Rural Virtual Academy	charter						2019	grade_10	1	1
3083001	WI	Wood	school	5510380	3906	Public school	Nekoosa	551038002617	400	Nekoosa Academy		Alternative School	No	High	09	12	2019	grade_10	1	1
3083005	WI	Wood	school	5510380	3906	Public school	Nekoosa	551038001360	60	Nekoosa High		Regular School	No	High	09	12	2019	grade_10	77	77
3083011	WI	Wood	school	5510380	3906	Public school	Nekoosa	551038003089	800	WISE Academy	charter	Regular School	Yes	Other	PK	12	2019	grade_10	2	2
3084179	WI	Wood	school	5511790	4368	Public school	Pittsville	551179001547	40	Pittsville High		Regular School	No	High	09	12	2019	grade_10	47	47
3084260	WI	Wood	school	5511970	4508	Public school	Port Edwards	551197001564	40	John Edwards High		Regular School	No	High	09	12	2019	grade_10	27	27
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
3089285	WI	Wood	school	5500600	203	Public school	Auburndale	550060000091	60	Auburndale High		Regular School	No	High	06	12	2018	grade_10	64	64
3095127	WI	Wood	school	5508820	3339	Public school	Marshfield Unified	550882001021	120	Marshfield High		Regular School	No	High	09	12	2018	grade_10	273	273
3097713	WI	Wood	school	5510380	3906	Public school	Nekoosa	551038002617	400	Nekoosa Academy		Alternative School	No	High	09	12	2018	grade_10	1	1
3097717	WI	Wood	school	5510380	3906	Public school	Nekoosa	551038001360	60	Nekoosa High		Regular School	No	High	09	12	2018	grade_10	94	94
3098877	WI	Wood	school	5511790	4368	Public school	Pittsville	551179001547	40	Pittsville High		Regular School	No	High	09	12	2018	grade_10	50	50
3098956	WI	Wood	school	5511970	4508	Public school	Port Edwards	551197001564	40	John Edwards High		Regular School	No	High	09	12	2018	grade_10	29	29
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
118431	WI	Winnebago	school	5509030	3430	Public school	Menasha Joint	550903001059	100	Menasha High		Regular School	No	3.0	09	12	2015	grade_10	232	232
120719	WI	Winnebago	school	5510320	3892	Public school	Neenah Joint	551032001348	180	Neenah High		Regular School	No	3.0	09	12	2015	grade_10	459	459
121461	WI	Winnebago	school	5510980	4088	Public school	Omro	551098001441	60	Omro High		Regular School	No	3.0	09	12	2015	grade_10	110	110
121634	WI	Winnebago	school	5511190	4179	Public school	Oshkosh Area	551119001495	290	North High		Regular School	No	3.0	09	12	2015	grade_10	334	334
121720	WI	Winnebago	school	5511190	4179	Public school	Oshkosh Area	551119001496	300	West High		Regular School	No	3.0	09	12	2015	grade_10	371	371
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
288428	WI	Winnebago	school	5509030	3430	Public school	Menasha Joint	550903001059	100	Menasha High		Regular School	No	3.0	09	12	2016	grade_10	260	260
290682	WI	Winnebago	school	5510320	3892	Public school	Neenah Joint	551032001348	180	Neenah High		Regular School	No	3.0	09	12	2016	grade_10	479	479
291424	WI	Winnebago	school	5510980	4088	Public school	Omro	551098001441	60	Omro High		Regular School	No	3.0	09	12	2016	grade_10	98	98
291596	WI	Winnebago	school	5511190	4179	Public school	Oshkosh Area	551119001495	290	North High		Regular School	No	3.0	09	12	2016	grade_10	276	276
291682	WI	Winnebago	school	5511190	4179	Public school	Oshkosh Area	551119001496	300	West High		Regular School	No	3.0	09	12	2016	grade_10	432	432
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
332302	WI	Winnebago	school	5509030	3430	Public school	Menasha Joint	550903001059	100	Menasha High		Regular School	No	High	09	12	2017	grade_10	257	257
334555	WI	Winnebago	school	5510320	3892	Public school	Neenah Joint	551032001348	180	Neenah High		Regular School	No	High	09	12	2017	grade_10	537	537
335287	WI	Winnebago	school	5510980	4088	Public school	Omro	551098001441	60	Omro High		Regular School	No	High	09	12	2017	grade_10	90	90
335464	WI	Winnebago	school	5511190	4179	Public school	Oshkosh Area	551119001495	290	North High		Regular School	No	High	09	12	2017	grade_10	340	340
335551	WI	Winnebago	school	5511190	4179	Public school	Oshkosh Area	551119001496	300	West High		Regular School	No	High	09	12	2017	grade_10	428	428
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
2324938	WI	Winnebago	school	5509030	3430	Public school	Menasha Joint	550903001059	100	Menasha High		Regular School	No	High	09	12	2020	grade_10	232	232
2327165	WI	Winnebago	school	5510320	3892	Public school	Neenah Joint	551032001348	180	Neenah High		Regular School	No	High	09	12	2020	grade_10	517	517
2327934	WI	Winnebago	school	5510980	4088	Public school	Omro	551098001441	60	Omro High		Regular School	No	High	09	12	2020	grade_10	84	84
2328103	WI	Winnebago	school	5511190	4179	Public school	Oshkosh Area	551119001495	290	North High		Regular School	No	High	09	12	2020	grade_10	275	275
2328183	WI	Winnebago	school	5511190	4179	Public school	Oshkosh Area	551119001496	300	West High		Regular School	No	High	09	12	2020	grade_10	444	444
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
2339825	WI	Winnebago	school	5509030	3430	Public school	Menasha Joint	550903001059	100	Menasha High		Regular School	No	High	09	12	2021	grade_10	248	248
2342034	WI	Winnebago	school	5510320	3892	Public school	Neenah Joint	551032001348	180	Neenah High		Regular School	No	High	09	12	2021	grade_10	506	506
2342819	WI	Winnebago	school	5510980	4088	Public school	Omro	551098001441	60	Omro High		Regular School	No	High	09	12	2021	grade_10	83	83
2342998	WI	Winnebago	school	5511190	4179	Public school	Oshkosh Area	551119001495	290	North High		Regular School	No	High	09	12	2021	grade_10	279	279
2343078	WI	Winnebago	school	5511190	4179	Public school	Oshkosh Area	551119001496	300	West High		Regular School	No	High	09	12	2021	grade_10	408	408
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
3080667	WI	Winnebago	school	5509030	3430	Public school	Menasha Joint	550903001059	100	Menasha High		Regular School	No	High	09	12	2019	grade_10	210	210
3082920	WI	Winnebago	school	5510320	3892	Public school	Neenah Joint	551032001348	180	Neenah High		Regular School	No	High	09	12	2019	grade_10	509	509
3083672	WI	Winnebago	school	5510980	4088	Public school	Omro	551098001441	60	Omro High		Regular School	No	High	09	12	2019	grade_10	83	83
3083841	WI	Winnebago	school	5511190	4179	Public school	Oshkosh Area	551119001495	290	North High		Regular School	No	High	09	12	2019	grade_10	337	337
3083935	WI	Winnebago	school	5511190	4179	Public school	Oshkosh Area	551119001496	300	West High		Regular School	No	High	09	12	2019	grade_10	379	379
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
3095384	WI	Winnebago	school	5509030	3430	Public school	Menasha Joint	550903001059	100	Menasha High		Regular School	No	High	09	12	2018	grade_10	240	240
3097631	WI	Winnebago	school	5510320	3892	Public school	Neenah Joint	551032001348	180	Neenah High		Regular School	No	High	09	12	2018	grade_10	500	500