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
126378	WI	Racine	school	5517220	6748	Public school	Yorkville J2	551722002230	20	Yorkville Elementary		Regular School	No	1.0	PK	08	2015	grade_6	70	70
296315	WI	Racine	school	5517220	6748	Public school	Yorkville J2	551722002230	20	Yorkville Elementary		Regular School	No	1.0	PK	08	2016	grade_6	60	60
340256	WI	Racine	school	5517220	6748	Public school	Yorkville J2	551722002230	20	Yorkville Elementary		Regular School	No	Elementary	PK	08	2017	grade_6	69	69
2332921	WI	Racine	school	5517220	6748	Public school	Yorkville J2	551722002230	20	Yorkville Elementary		Regular School	No	Elementary	PK	08	2020	grade_6	47	47
2347927	WI	Racine	school	5517220	6748	Public school	Yorkville J2	551722002230	20	Yorkville Elementary		Regular School	No	Elementary	PK	08	2021	grade_6	57	57
3088632	WI	Racine	school	5517220	6748	Public school	Yorkville J2	551722002230	20	Yorkville Elementary		Regular School	No	Elementary	PK	08	2019	grade_6	53	53
3103334	WI	Racine	school	5517220	6748	Public school	Yorkville J2	551722002230	20	Yorkville Elementary		Regular School	No	Elementary	PK	08	2018	grade_6	48	48
126369	WI	Brown	school	5517190	6734	Public school	Wrightstown Community	551719000280	30	Wrightstown Middle		Regular School	No	2.0	05	08	2015	grade_6	103	103
296306	WI	Brown	school	5517190	6734	Public school	Wrightstown Community	551719000280	30	Wrightstown Middle		Regular School	No	2.0	05	08	2016	grade_6	83	83
340247	WI	Brown	school	5517190	6734	Public school	Wrightstown Community	551719000280	30	Wrightstown Middle		Regular School	No	Middle	05	08	2017	grade_6	94	94
2332912	WI	Brown	school	5517190	6734	Public school	Wrightstown Community	551719000280	30	Wrightstown Middle		Regular School	No	Middle	05	08	2020	grade_6	89	89
2347918	WI	Brown	school	5517190	6734	Public school	Wrightstown Community	551719000280	30	Wrightstown Middle		Regular School	No	Middle	05	08	2021	grade_6	89	89
3088623	WI	Brown	school	5517190	6734	Public school	Wrightstown Community	551719000280	30	Wrightstown Middle		Regular School	No	Middle	05	08	2019	grade_6	88	88
3103325	WI	Brown	school	5517190	6734	Public school	Wrightstown Community	551719000280	30	Wrightstown Middle		Regular School	No	Middle	05	08	2018	grade_6	95	95
126348	WI	Vilas	school	5517160	6720	Public school	Woodruff J1	551716002227	20	Arbor Vitae-Woodruff Elementary		Regular School	No	1.0	PK	08	2015	grade_6	53	53
296286	WI	Vilas	school	5517160	6720	Public school	Woodruff J1	551716002227	20	Arbor Vitae-Woodruff Elementary		Regular School	No	1.0	PK	08	2016	grade_6	57	57
340226	WI	Vilas	school	5517160	6720	Public school	Woodruff J1	551716002227	20	Arbor Vitae-Woodruff Elementary		Regular School	No	Elementary	PK	08	2017	grade_6	56	56
2332890	WI	Vilas	school	5517160	6720	Public school	Woodruff J1	551716002227	20	Arbor Vitae-Woodruff Elementary		Regular School	No	Elementary	PK	08	2020	grade_6	46	46
2347897	WI	Vilas	school	5517160	6720	Public school	Woodruff J1	551716002227	20	Arbor Vitae-Woodruff Elementary		Regular School	No	Elementary	PK	08	2021	grade_6	58	58
3088601	WI	Vilas	school	5517160	6720	Public school	Woodruff J1	551716002227	20	Arbor Vitae-Woodruff Elementary		Regular School	No	Elementary	PK	08	2019	grade_6	59	59
3103304	WI	Vilas	school	5517160	6720	Public school	Woodruff J1	551716002227	20	Arbor Vitae-Woodruff Elementary		Regular School	No	Elementary	PK	08	2018	grade_6	51	51
3103295	WI	Milwaukee	school	5500070	8132	Non District Charter Schools	Woodlands School East	550007002942	100	Woodlands School East	charter	Regular School	Yes	Elementary	PK	08	2018	grade_6	28	28
2332879	WI	Milwaukee	school	5500070	8132	Non District Charter Schools	Woodlands School - State Street Campus	550007002942	100	Woodlands School - State Street Campus	charter	Regular School	Yes	Elementary	PK	08	2020	grade_6	36	36
2347886	WI	Milwaukee	school	5500070	8132	Non District Charter Schools	Woodlands School - State Street Campus	550007002942	100	Woodlands School - State Street Campus	charter	Regular School	Yes	Elementary	PK	08	2021	grade_6	28	28
3088591	WI	Milwaukee	school	5500070	8132	Non District Charter Schools	Woodlands School - State Street Campus	550007002942	100	Woodlands School - State Street Campus	charter	Regular School	Yes	Elementary	PK	08	2019	grade_6	38	38
126331	WI	Milwaukee	school	5500113	8113	Non District Charter Schools	Woodlands School	550011303353	8728	Woodlands School	charter	Regular School	Yes	1.0	PK	08	2015	grade_6	34	34
296268	WI	Milwaukee	school	5500113	8113	Non District Charter Schools	Woodlands School	550011303353	8728	Woodlands School	charter	Regular School	Yes	1.0	PK	08	2016	grade_6	37	37
340207	WI	Milwaukee	school	5500113	8113	Non District Charter Schools	Woodlands School	550011303353	8728	Woodlands School	charter	Regular School	Yes	Elementary	PK	08	2017	grade_6	35	35
2332868	WI	Milwaukee	school	5500113	8113	Non District Charter Schools	Woodlands School	550011303353	8728	Woodlands School	charter	Regular School	Yes	Elementary	PK	08	2020	grade_6	37	37
2347875	WI	Milwaukee	school	5500113	8113	Non District Charter Schools	Woodlands School	550011303353	8728	Woodlands School	charter	Regular School	Yes	Elementary	PK	08	2021	grade_6	36	36
3088580	WI	Milwaukee	school	5500113	8113	Non District Charter Schools	Woodlands School	550011303353	8728	Woodlands School	charter	Regular School	Yes	Elementary	PK	08	2019	grade_6	34	34
3103284	WI	Milwaukee	school	5500113	8113	Non District Charter Schools	Woodlands School	550011303353	8728	Woodlands School	charter	Regular School	Yes	Elementary	PK	08	2018	grade_6	36	36
126322	WI	Juneau	school	5517130	6713	Public school	Wonewoc-Union Center	551713002226	100	Wonewoc-Center Junior High		Regular School	No	2.0	06	08	2015	grade_6	30	30
296259	WI	Juneau	school	5517130	6713	Public school	Wonewoc-Union Center	551713002226	100	Wonewoc-Center Junior High		Regular School	No	2.0	06	08	2016	grade_6	22	22
340198	WI	Juneau	school	5517130	6713	Public school	Wonewoc-Union Center	551713002226	100	Wonewoc-Center Junior High		Regular School	No	Middle	06	08	2017	grade_6	21	21
2332857	WI	Juneau	school	5517130	6713	Public school	Wonewoc-Union Center	551713002226	100	Wonewoc-Center Junior High		Regular School	No	Middle	06	08	2020	grade_6	17	17
2347852	WI	Juneau	school	5517130	6713	Public school	Wonewoc-Union Center	551713002226	100	Wonewoc-Center Junior High		Regular School	No	Middle	06	08	2021	grade_6	24	24
2347864	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_6	3	3
3088568	WI	Juneau	school	5517130	6713	Public school	Wonewoc-Union Center	551713002226	100	Wonewoc-Center Junior High		Regular School	No	Middle	06	08	2019	grade_6	27	27
3103273	WI	Juneau	school	5517130	6713	Public school	Wonewoc-Union Center	551713002226	100	Wonewoc-Center Junior High		Regular School	No	Middle	06	08	2018	grade_6	33	33
126283	WI	Shawano	school	5517100	6692	Public school	Wittenberg-Birnamwood	551710002218	20	Birnamwood Elementary		Regular School	No	1.0	PK	08	2015	grade_6	42	42
126294	WI	Shawano	school	5517100	6692	Public school	Wittenberg-Birnamwood	551710002223	120	Wittenberg Elementary		Regular School	No	1.0	PK	08	2015	grade_6	43	43
296221	WI	Shawano	school	5517100	6692	Public school	Wittenberg-Birnamwood	551710002218	20	Birnamwood Elementary		Regular School	No	1.0	PK	08	2016	grade_6	43	43
296232	WI	Shawano	school	5517100	6692	Public school	Wittenberg-Birnamwood	551710002223	120	Wittenberg Elementary		Regular School	No	1.0	PK	08	2016	grade_6	49	49
340161	WI	Shawano	school	5517100	6692	Public school	Wittenberg-Birnamwood	551710002218	20	Birnamwood Elementary		Regular School	No	Elementary	PK	08	2017	grade_6	37	37
340172	WI	Shawano	school	5517100	6692	Public school	Wittenberg-Birnamwood	551710002223	120	Wittenberg Elementary		Regular School	No	Elementary	PK	08	2017	grade_6	47	47
2332820	WI	Shawano	school	5517100	6692	Public school	Wittenberg-Birnamwood	551710002218	20	Birnamwood Elementary		Regular School	No	Elementary	PK	08	2020	grade_6	43	43
2332831	WI	Shawano	school	5517100	6692	Public school	Wittenberg-Birnamwood	551710002223	120	Wittenberg Elementary		Regular School	No	Elementary	PK	08	2020	grade_6	42	42
2347810	WI	Shawano	school	5517100	6692	Public school	Wittenberg-Birnamwood	551710002218	20	Birnamwood Elementary		Regular School	No	Elementary	PK	08	2021	grade_6	35	35
2347821	WI	Shawano	school	5517100	6692	Public school	Wittenberg-Birnamwood	551710002223	120	Wittenberg Elementary		Regular School	No	Elementary	PK	08	2021	grade_6	43	43
3088530	WI	Shawano	school	5517100	6692	Public school	Wittenberg-Birnamwood	551710002218	20	Birnamwood Elementary		Regular School	No	Elementary	PK	08	2019	grade_6	49	49
3088541	WI	Shawano	school	5517100	6692	Public school	Wittenberg-Birnamwood	551710002223	120	Wittenberg Elementary		Regular School	No	Elementary	PK	08	2019	grade_6	49	49
3103235	WI	Shawano	school	5517100	6692	Public school	Wittenberg-Birnamwood	551710002218	20	Birnamwood Elementary		Regular School	No	Elementary	PK	08	2018	grade_6	33	33
3103246	WI	Shawano	school	5517100	6692	Public school	Wittenberg-Birnamwood	551710002223	120	Wittenberg Elementary		Regular School	No	Elementary	PK	08	2018	grade_6	44	44
126263	WI	Wood	school	5517070	6685	Public school	Wisconsin Rapids	551707002216	290	Wisconsin Rapids Area Middle		Regular School	No	2.0	06	07	2015	grade_6	336	336
296201	WI	Wood	school	5517070	6685	Public school	Wisconsin Rapids	551707002216	290	Wisconsin Rapids Area Middle		Regular School	No	2.0	06	07	2016	grade_6	370	370
340141	WI	Wood	school	5517070	6685	Public school	Wisconsin Rapids	551707002216	290	Wisconsin Rapids Area Middle		Regular School	No	Middle	06	07	2017	grade_6	346	346
2332735	WI	Wood	school	5517070	6685	Public school	Wisconsin Rapids	551707003088	190	Central Oaks Academy		Regular School	No	Elementary	PK	08	2020	grade_6	14	14
2332799	WI	Wood	school	5517070	6685	Public school	Wisconsin Rapids	551707002216	290	Wisconsin Rapids Area Middle		Regular School	No	Middle	06	08	2020	grade_6	352	352
2347726	WI	Wood	school	5517070	6685	Public school	Wisconsin Rapids	551707003088	190	Central Oaks Academy		Regular School	No	Elementary	PK	08	2021	grade_6	66	66
2347789	WI	Wood	school	5517070	6685	Public school	Wisconsin Rapids	551707002216	290	Wisconsin Rapids Area Middle		Regular School	No	Middle	06	08	2021	grade_6	296	296
3088446	WI	Wood	school	5517070	6685	Public school	Wisconsin Rapids	551707003088	190	Central Oaks Academy		Regular School	No	Elementary	PK	08	2019	grade_6	17	17
3088509	WI	Wood	school	5517070	6685	Public school	Wisconsin Rapids	551707002216	290	Wisconsin Rapids Area Middle		Regular School	No	Middle	06	08	2019	grade_6	366	366
3103215	WI	Wood	school	5517070	6685	Public school	Wisconsin Rapids	551707002216	290	Wisconsin Rapids Area Middle		Regular School	No	Middle	06	07	2018	grade_6	362	362
126191	WI	Dane	school	5501230	469	Public school	Wisconsin Heights	550123000609	80	Wisconsin Heights Middle		Regular School	No	2.0	06	08	2015	grade_6	55	55
296129	WI	Dane	school	5501230	469	Public school	Wisconsin Heights	550123000609	80	Wisconsin Heights Middle		Regular School	No	2.0	06	08	2016	grade_6	45	45
340068	WI	Dane	school	5501230	469	Public school	Wisconsin Heights	550123000609	80	Wisconsin Heights Middle		Regular School	No	Middle	06	08	2017	grade_6	55	55
2332726	WI	Dane	school	5501230	469	Public school	Wisconsin Heights	550123000609	80	Wisconsin Heights Middle		Regular School	No	Middle	06	08	2020	grade_6	56	56
2347717	WI	Dane	school	5501230	469	Public school	Wisconsin Heights	550123000609	80	Wisconsin Heights Middle		Regular School	No	Middle	06	08	2021	grade_6	50	50
3088437	WI	Dane	school	5501230	469	Public school	Wisconsin Heights	550123000609	80	Wisconsin Heights Middle		Regular School	No	Middle	06	08	2019	grade_6	51	51
3103142	WI	Dane	school	5501230	469	Public school	Wisconsin Heights	550123000609	80	Wisconsin Heights Middle		Regular School	No	Middle	06	08	2018	grade_6	47	47
126167	WI	Sauk	school	5517040	6678	Public school	Wisconsin Dells	551704002271	200	Spring Hill Middle		Regular School	No	2.0	06	08	2015	grade_6	133	133
296105	WI	Sauk	school	5517040	6678	Public school	Wisconsin Dells	551704002271	200	Spring Hill Middle		Regular School	No	2.0	06	08	2016	grade_6	124	124
340044	WI	Sauk	school	5517040	6678	Public school	Wisconsin Dells	551704002271	200	Spring Hill Middle		Regular School	No	Middle	06	08	2017	grade_6	140	140
2332702	WI	Sauk	school	5517040	6678	Public school	Wisconsin Dells	551704002271	200	Spring Hill Middle		Regular School	No	Middle	06	08	2020	grade_6	134	134
2347698	WI	Sauk	school	5517040	6678	Public school	Wisconsin Dells	551704002271	200	Wisconsin Dells Middle School		Regular School	No	Middle	06	08	2021	grade_6	120	120
3088413	WI	Sauk	school	5517040	6678	Public school	Wisconsin Dells	551704002271	200	Spring Hill Middle		Regular School	No	Middle	06	08	2019	grade_6	134	134
3103118	WI	Sauk	school	5517040	6678	Public school	Wisconsin Dells	551704002271	200	Spring Hill Middle		Regular School	No	Middle	06	08	2018	grade_6	146	146
126139	WI	Sawyer	school	5516860	6615	Public school	Winter	551686002315	100	Winter Middle		Regular School	No	2.0	06	08	2015	grade_6	18	18
296077	WI	Sawyer	school	5516860	6615	Public school	Winter	551686002315	100	Winter Middle		Regular School	No	2.0	06	08	2016	grade_6	12	12
340016	WI	Sawyer	school	5516860	6615	Public school	Winter	551686002315	100	Winter Middle		Regular School	No	Middle	06	08	2017	grade_6	16	16
2332674	WI	Sawyer	school	5516860	6615	Public school	Winter	551686002315	100	Winter Middle		Regular School	No	Middle	06	08	2020	grade_6	18	18
2347665	WI	Sawyer	school	5516860	6615	Public school	Winter	551686002315	100	Winter Middle		Regular School	No	Middle	06	08	2021	grade_6	20	20
3088385	WI	Sawyer	school	5516860	6615	Public school	Winter	551686002315	100	Winter Middle		Regular School	No	Middle	06	08	2019	grade_6	22	22
3103090	WI	Sawyer	school	5516860	6615	Public school	Winter	551686002315	100	Winter Middle		Regular School	No	Middle	06	08	2018	grade_6	19	19
126121	WI	Winnebago	school	5516830	6608	Public school	Winneconne Community	551683002192	80	Winneconne Middle		Regular School	No	2.0	06	08	2015	grade_6	128	128
296059	WI	Winnebago	school	5516830	6608	Public school	Winneconne Community	551683002192	80	Winneconne Middle		Regular School	No	2.0	06	08	2016	grade_6	113	113
339998	WI	Winnebago	school	5516830	6608	Public school	Winneconne Community	551683002192	80	Winneconne Middle		Regular School	No	Middle	06	08	2017	grade_6	121	121
2332657	WI	Winnebago	school	5516830	6608	Public school	Winneconne Community	551683002192	80	Winneconne Middle		Regular School	No	Middle	06	08	2020	grade_6	154	154
2347647	WI	Winnebago	school	5516830	6608	Public school	Winneconne Community	551683002192	80	Winneconne Middle		Regular School	No	Middle	06	08	2021	grade_6	114	114
3088368	WI	Winnebago	school	5516830	6608	Public school	Winneconne Community	551683002192	80	Winneconne Middle		Regular School	No	Middle	06	08	2019	grade_6	115	115
3103073	WI	Winnebago	school	5516830	6608	Public school	Winneconne Community	551683002192	80	Winneconne Middle		Regular School	No	Middle	06	08	2018	grade_6	123	123
126091	WI	Walworth	school	5516740	6482	Public school	Williams Bay	551674002186	20	Williams Bay Elementary		Regular School	No	1.0	PK	06	2015	grade_6	55	55
296036	WI	Walworth	school	5516740	6482	Public school	Williams Bay	551674000277	30	Williams Bay Middle		Regular School	No	2.0	06	08	2016	grade_6	53	53
339975	WI	Walworth	school	5516740	6482	Public school	Williams Bay	551674000277	30	Williams Bay Middle		Regular School	No	Middle	06	08	2017	grade_6	62	62
2332634	WI	Walworth	school	5516740	6482	Public school	Williams Bay	551674000277	30	Williams Bay Middle		Regular School	No	Middle	06	08	2020	grade_6	63	63
2347624	WI	Walworth	school	5516740	6482	Public school	Williams Bay	551674000277	30	Williams Bay Middle		Regular School	No	Middle	06	08	2021	grade_6	44	44
3088345	WI	Walworth	school	5516740	6482	Public school	Williams Bay	551674000277	30	Williams Bay Middle		Regular School	No	Middle	06	08	2019	grade_6	57	57
3103050	WI	Walworth	school	5516740	6482	Public school	Williams Bay	551674000277	30	Williams Bay Middle		Regular School	No	Middle	06	08	2018	grade_6	50	50
126081	WI	Waushara	school	5516710	6475	Public school	Wild Rose	551671002185	60	Wild Rose High		Regular School	No	4.0	06	12	2015	grade_6	33	33
296016	WI	Waushara	school	5516710	6475	Public school	Wild Rose	551671002185	60	Wild Rose High		Regular School	No	4.0	06	12	2016	grade_6	44	44