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 (district > :p3 or (district = :p3 and rowid > :p2)) order by district, 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	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
325931	WI	Outagamie	school	5500390	147	Public school	Appleton Area	550039000047	20	East High		Regular School	No	High	09	12	2017	grade_9	327	327
325956	WI	Outagamie	school	5500390	147	Public school	Appleton Area	550039002724	450	Fox Cities Leadership Academy	charter	Regular School	Yes	High	09	12	2017	grade_9	23	23
326055	WI	Outagamie	school	5500390	147	Public school	Appleton Area	550039000597	30	North High		Regular School	No	High	09	12	2017	grade_9	429	429
326067	WI	Outagamie	school	5500390	147	Public school	Appleton Area	550039002282	420	Renaissance School	charter	Regular School	Yes	High	09	12	2017	grade_9	56	56
326088	WI	Outagamie	school	5500390	147	Public school	Appleton Area	550039002547	430	Tesla Engineering Charter School	charter	Regular School	Yes	High	09	12	2017	grade_9	37	37
326095	WI	Outagamie	school	5500390	147	Public school	Appleton Area	550039003341	460	Valley New School	charter	Regular School	Yes	High	07	12	2017	grade_9	10	10
326100	WI	Outagamie	school	5500390	147	Public school	Appleton Area	550039000048	40	West High		Regular School	No	High	09	12	2017	grade_9	289	289
326116	WI	Outagamie	school	5500390	147	Public school	Appleton Area	550039002825	850	Wisconsin Connections Academy	charter	Regular School	Yes	Other	KG	12	2017	grade_9	58	58
2318364	WI	Outagamie	school	5500390	147	Public school	Appleton Area	550039002549	440	Appleton eSchool	charter	Regular School	Yes	High	07	12	2020	grade_9	1	1
2318378	WI	Outagamie	school	5500390	147	Public school	Appleton Area	550039002964	490	Appleton Technical Academy	charter	Career and Technical School	Yes	High	09	12	2020	grade_9	20	20
2318419	WI	Outagamie	school	5500390	147	Public school	Appleton Area	550039000047	20	East High		Regular School	No	High	09	12	2020	grade_9	339	339
2318444	WI	Outagamie	school	5500390	147	Public school	Appleton Area	550039002724	450	Fox Cities Leadership Academy	charter	Regular School	Yes	High	09	12	2020	grade_9	11	11
2318542	WI	Outagamie	school	5500390	147	Public school	Appleton Area	550039000597	30	North High		Regular School	No	High	09	12	2020	grade_9	389	389
2318555	WI	Outagamie	school	5500390	147	Public school	Appleton Area	550039002282	420	Renaissance School	charter	Regular School	Yes	High	09	12	2020	grade_9	30	30
2318576	WI	Outagamie	school	5500390	147	Public school	Appleton Area	550039002547	430	Tesla Engineering Charter School	charter	Regular School	Yes	High	09	12	2020	grade_9	50	50
2318583	WI	Outagamie	school	5500390	147	Public school	Appleton Area	550039003341	460	Valley New School	charter	Regular School	Yes	High	07	12	2020	grade_9	9	9
2318588	WI	Outagamie	school	5500390	147	Public school	Appleton Area	550039000048	40	West High		Regular School	No	High	09	12	2020	grade_9	289	289
2318604	WI	Outagamie	school	5500390	147	Public school	Appleton Area	550039002825	850	Wisconsin Connections Academy	charter	Regular School	Yes	Other	PK	12	2020	grade_9	52	52
2333158	WI	Outagamie	school	5500390	147	Public school	Appleton Area	550039002549	440	Appleton eSchool	charter	Regular School	Yes	High	07	12	2021	grade_9	11	11
2333172	WI	Outagamie	school	5500390	147	Public school	Appleton Area	550039002964	490	Appleton Technical Academy	charter	Career and Technical School	Yes	High	09	12	2021	grade_9	21	21
2333213	WI	Outagamie	school	5500390	147	Public school	Appleton Area	550039000047	20	East High		Regular School	No	High	09	12	2021	grade_9	300	300
2333238	WI	Outagamie	school	5500390	147	Public school	Appleton Area	550039002724	450	Fox Cities Leadership Academy	charter	Regular School	Yes	High	09	12	2021	grade_9	20	20
2333336	WI	Outagamie	school	5500390	147	Public school	Appleton Area	550039000597	30	North High		Regular School	No	High	09	12	2021	grade_9	399	399
2333349	WI	Outagamie	school	5500390	147	Public school	Appleton Area	550039002282	420	Renaissance School	charter	Regular School	Yes	High	09	12	2021	grade_9	50	50
2333370	WI	Outagamie	school	5500390	147	Public school	Appleton Area	550039002547	430	Tesla Engineering Charter School	charter	Regular School	Yes	High	09	12	2021	grade_9	44	44
2333377	WI	Outagamie	school	5500390	147	Public school	Appleton Area	550039003341	460	Valley New School	charter	Regular School	Yes	High	07	12	2021	grade_9	9	9
2333382	WI	Outagamie	school	5500390	147	Public school	Appleton Area	550039000048	40	West High		Regular School	No	High	09	12	2021	grade_9	249	249
2333398	WI	Outagamie	school	5500390	147	Public school	Appleton Area	550039002825	850	Wisconsin Connections Academy	charter	Regular School	Yes	Other	PK	12	2021	grade_9	57	57
3074154	WI	Outagamie	school	5500390	147	Public school	Appleton Area	550039002549	440	Appleton eSchool	charter	Regular School	Yes	High	07	12	2019	grade_9	2	2
3074168	WI	Outagamie	school	5500390	147	Public school	Appleton Area	550039002964	490	Appleton Technical Academy	charter	Career and Technical School	Yes	High	09	12	2019	grade_9	23	23
3074209	WI	Outagamie	school	5500390	147	Public school	Appleton Area	550039000047	20	East High		Regular School	No	High	09	12	2019	grade_9	326	326
3074234	WI	Outagamie	school	5500390	147	Public school	Appleton Area	550039002724	450	Fox Cities Leadership Academy	charter	Regular School	Yes	High	09	12	2019	grade_9	23	23
3074333	WI	Outagamie	school	5500390	147	Public school	Appleton Area	550039000597	30	North High		Regular School	No	High	09	12	2019	grade_9	419	419
3074345	WI	Outagamie	school	5500390	147	Public school	Appleton Area	550039002282	420	Renaissance School	charter	Regular School	Yes	High	09	12	2019	grade_9	50	50
3074366	WI	Outagamie	school	5500390	147	Public school	Appleton Area	550039002547	430	Tesla Engineering Charter School	charter	Regular School	Yes	High	09	12	2019	grade_9	42	42
3074373	WI	Outagamie	school	5500390	147	Public school	Appleton Area	550039003341	460	Valley New School	charter	Regular School	Yes	High	07	12	2019	grade_9	11	11
3074378	WI	Outagamie	school	5500390	147	Public school	Appleton Area	550039000048	40	West High		Regular School	No	High	09	12	2019	grade_9	275	275
3074394	WI	Outagamie	school	5500390	147	Public school	Appleton Area	550039002825	850	Wisconsin Connections Academy	charter	Regular School	Yes	Other	PK	12	2019	grade_9	63	63
3088910	WI	Outagamie	school	5500390	147	Public school	Appleton Area	550039002549	440	Appleton eSchool	charter	Regular School	Yes	High	07	12	2018	grade_9	2	2
3088924	WI	Outagamie	school	5500390	147	Public school	Appleton Area	550039002964	490	Appleton Technical Academy	charter	Career and Technical School	Yes	High	09	12	2018	grade_9	19	19
3088965	WI	Outagamie	school	5500390	147	Public school	Appleton Area	550039000047	20	East High		Regular School	No	High	09	12	2018	grade_9	344	344
3088990	WI	Outagamie	school	5500390	147	Public school	Appleton Area	550039002724	450	Fox Cities Leadership Academy	charter	Regular School	Yes	High	09	12	2018	grade_9	21	21
3089089	WI	Outagamie	school	5500390	147	Public school	Appleton Area	550039000597	30	North High		Regular School	No	High	09	12	2018	grade_9	381	381
3089101	WI	Outagamie	school	5500390	147	Public school	Appleton Area	550039002282	420	Renaissance School	charter	Regular School	Yes	High	09	12	2018	grade_9	40	40
3089122	WI	Outagamie	school	5500390	147	Public school	Appleton Area	550039002547	430	Tesla Engineering Charter School	charter	Regular School	Yes	High	09	12	2018	grade_9	41	41
3089129	WI	Outagamie	school	5500390	147	Public school	Appleton Area	550039003341	460	Valley New School	charter	Regular School	Yes	High	07	12	2018	grade_9	18	18
3089134	WI	Outagamie	school	5500390	147	Public school	Appleton Area	550039000048	40	West High		Regular School	No	High	09	12	2018	grade_9	268	268
3089150	WI	Outagamie	school	5500390	147	Public school	Appleton Area	550039002825	850	Wisconsin Connections Academy	charter	Regular School	Yes	Other	KG	12	2018	grade_9	65	65
112262	WI	Trempealeau	school	5500420	154	Public school	Arcadia	550042000068	40	Arcadia High		Regular School	No	3.0	09	12	2015	grade_9	83	83
282236	WI	Trempealeau	school	5500420	154	Public school	Arcadia	550042000068	40	Arcadia High		Regular School	No	3.0	09	12	2016	grade_9	92	92
326130	WI	Trempealeau	school	5500420	154	Public school	Arcadia	550042000068	40	Arcadia High		Regular School	No	High	09	12	2017	grade_9	97	97
2318619	WI	Trempealeau	school	5500420	154	Public school	Arcadia	550042000068	40	Arcadia High		Regular School	No	High	09	12	2020	grade_9	100	100
2333413	WI	Trempealeau	school	5500420	154	Public school	Arcadia	550042000068	40	Arcadia High		Regular School	No	High	09	12	2021	grade_9	103	103
3074408	WI	Trempealeau	school	5500420	154	Public school	Arcadia	550042000068	40	Arcadia High		Regular School	No	High	09	12	2019	grade_9	97	97
3089164	WI	Trempealeau	school	5500420	154	Public school	Arcadia	550042000068	40	Arcadia High		Regular School	No	High	09	12	2018	grade_9	89	89
112279	WI	Lafayette	school	5500450	161	Public school	Argyle	550045000070	40	Argyle High		Regular School	No	4.0	06	12	2015	grade_9	27	27
282253	WI	Lafayette	school	5500450	161	Public school	Argyle	550045000070	40	Argyle High		Regular School	No	4.0	06	12	2016	grade_9	27	27
326152	WI	Lafayette	school	5500450	161	Public school	Argyle	550045000070	40	Argyle High		Regular School	No	Other	06	12	2017	grade_9	26	26
2318637	WI	Lafayette	school	5500450	161	Public school	Argyle	550045000070	40	Argyle High		Regular School	No	High	09	12	2020	grade_9	20	20
2333432	WI	Lafayette	school	5500450	161	Public school	Argyle	550045000070	40	Argyle High		Regular School	No	High	09	12	2021	grade_9	16	16
3074427	WI	Lafayette	school	5500450	161	Public school	Argyle	550045000070	40	Argyle High		Regular School	No	High	09	12	2019	grade_9	25	25
3089183	WI	Lafayette	school	5500450	161	Public school	Argyle	550045000070	40	Argyle High		Regular School	No	High	09	12	2018	grade_9	20	20
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
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
326157	WI	Waukesha	school	5506180	2450	Public school	Arrowhead UHS	550618000678	20	Arrowhead High		Regular School	No	High	09	12	2017	grade_9	568	568
2318646	WI	Waukesha	school	5506180	2450	Public school	Arrowhead UHS	550618000678	20	Arrowhead High		Regular School	No	High	09	12	2020	grade_9	492	492
2333441	WI	Waukesha	school	5506180	2450	Public school	Arrowhead UHS	550618000678	20	Arrowhead High		Regular School	No	High	09	12	2021	grade_9	534	534
3074436	WI	Waukesha	school	5506180	2450	Public school	Arrowhead UHS	550618000678	20	Arrowhead High		Regular School	No	High	09	12	2019	grade_9	536	536
3089192	WI	Waukesha	school	5506180	2450	Public school	Arrowhead UHS	550618000678	20	Arrowhead High		Regular School	No	High	09	12	2018	grade_9	525	525
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
282263	WI	Ashland	school	5500510	170	Public school	Ashland	550051003017	400	Ashland Charter High School	charter	Regular School	Yes	3.0	09	12	2016	grade_9	5	5
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
326162	WI	Ashland	school	5500510	170	Public school	Ashland	550051003017	400	Ashland Charter High School	charter	Regular School	Yes	High	09	12	2017	grade_9	15	15
326171	WI	Ashland	school	5500510	170	Public school	Ashland	550051000073	20	Ashland High		Regular School	No	High	09	12	2017	grade_9	150	150
2318651	WI	Ashland	school	5500510	170	Public school	Ashland	550051000073	20	Ashland High		Regular School	No	High	09	12	2020	grade_9	152	152
2318669	WI	Ashland	school	5500510	170	Public school	Ashland	550051003017	400	Lake Superior High	charter	Regular School	Yes	High	09	12	2020	grade_9	11	11
2318692	WI	Ashland	school		170	Public Schools-Multidistrict Charters	Ashland		9100	Rural Virtual Academy							2020	grade_9	1	1
2333446	WI	Ashland	school	5500510	170	Public school	Ashland	550051000073	20	Ashland High		Regular School	No	High	09	12	2021	grade_9	160	160
2333475	WI	Ashland	school		170	Public Schools-Multidistrict Charters	Ashland		9100	Rural Virtual Academy							2021	grade_9	2	2
3074441	WI	Ashland	school	5500510	170	Public school	Ashland	550051000073	20	Ashland High		Regular School	No	High	09	12	2019	grade_9	141	141
3074450	WI	Ashland	school	5500510	170	Public school	Ashland	550051003017	400	Lake Superior High	charter	Regular School	Yes	High	09	12	2019	grade_9	10	10
3089197	WI	Ashland	school	5500510	170	Public school	Ashland	550051000073	20	Ashland High		Regular School	No	High	09	12	2018	grade_9	165	165
3089206	WI	Ashland	school	5500510	170	Public school	Ashland	550051003017	400	Lake Superior High	charter	Regular School	Yes	High	09	12	2018	grade_9	3	3
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
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
326200	WI	Brown	school	5500540	182	Public school	Ashwaubenon	550054000081	20	Ashwaubenon High		Regular School	No	High	09	12	2017	grade_9	249	249
2318698	WI	Brown	school	5500540	182	Public school	Ashwaubenon	550054000081	20	Ashwaubenon High		Regular School	No	High	09	12	2020	grade_9	245	245
2333481	WI	Brown	school	5500540	182	Public school	Ashwaubenon	550054000081	20	Ashwaubenon High		Regular School	No	High	09	12	2021	grade_9	243	243
3074480	WI	Brown	school	5500540	182	Public school	Ashwaubenon	550054000081	20	Ashwaubenon High		Regular School	No	High	09	12	2019	grade_9	269	269
3089236	WI	Brown	school	5500540	182	Public school	Ashwaubenon	550054000081	20	Ashwaubenon High		Regular School	No	High	09	12	2018	grade_9	236	236
112357	WI	Marathon	school	5500570	196	Public school	Athens	550057000087	40	Athens High		Regular School	No	3.0	09	12	2015	grade_9	47	47
282337	WI	Marathon	school	5500570	196	Public school	Athens	550057000087	40	Athens High		Regular School	No	3.0	09	12	2016	grade_9	41	41
326235	WI	Marathon	school	5500570	196	Public school	Athens	550057000087	40	Athens High		Regular School	No	High	09	12	2017	grade_9	46	46
2318733	WI	Marathon	school	5500570	196	Public school	Athens	550057000087	40	Athens High		Regular School	No	High	09	12	2020	grade_9	31	31
2333516	WI	Marathon	school	5500570	196	Public school	Athens	550057000087	40	Athens High		Regular School	No	High	09	12	2021	grade_9	40	40
3074515	WI	Marathon	school	5500570	196	Public school	Athens	550057000087	40	Athens High		Regular School	No	High	09	12	2019	grade_9	28	28
3089271	WI	Marathon	school	5500570	196	Public school	Athens	550057000087	40	Athens High		Regular School	No	High	09	12	2018	grade_9	44	44
112377	WI	Wood	school	5500600	203	Public school	Auburndale	550060000091	60	Auburndale High		Regular School	No	4.0	06	12	2015	grade_9	64	64
282357	WI	Wood	school	5500600	203	Public school	Auburndale	550060000091	60	Auburndale High		Regular School	No	4.0	06	12	2016	grade_9	62	62
326255	WI	Wood	school	5500600	203	Public school	Auburndale	550060000091	60	Auburndale High		Regular School	No	Other	06	12	2017	grade_9	62	62
326260	WI	Wood	school		203	Public Schools-Multidistrict Charters	Auburndale		9100	Rural Virtual Academy	charter						2017	grade_9	1	1