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
2318315	WI	Langlade	school	5500360	140	Public school	Antigo Unified	550036000039	100	East Elementary		Regular School	No	Elementary	PK	03	2020	grade_1	30	30
2318321	WI	Langlade	school	5500360	140	Public school	Antigo Unified	550036000042	180	North Elementary		Regular School	No	Elementary	PK	03	2020	grade_1	67	67
2318327	WI	Langlade	school		140	Public Schools-Multidistrict Charters	Antigo Unified		9100	Rural Virtual Academy	charter						2020	grade_1	4	4
2318342	WI	Langlade	school	5500360	140	Public school	Antigo Unified	550036000046	280	West Elementary		Regular School	No	Elementary	PK	03	2020	grade_1	37	37
2333110	WI	Langlade	school	5500360	140	Public school	Antigo Unified	550036000039	100	East Elementary		Regular School	No	Elementary	PK	03	2021	grade_1	33	33
2333117	WI	Langlade	school	5500360	140	Public school	Antigo Unified	550036000042	180	North Elementary		Regular School	No	Elementary	PK	03	2021	grade_1	47	47
2333123	WI	Langlade	school		140	Public Schools-Multidistrict Charters	Antigo Unified		9100	Rural Virtual Academy	charter						2021	grade_1	3	3
2333138	WI	Langlade	school	5500360	140	Public school	Antigo Unified	550036000046	280	West Elementary		Regular School	No	Elementary	PK	03	2021	grade_1	31	31
3074080	WI	Langlade	school	5500360	140	Public school	Antigo Unified	550036000038	80	Crestwood Elementary		Regular School	No	Elementary	PK	05	2019	grade_1	24	24
3074088	WI	Langlade	school	5500360	140	Public school	Antigo Unified	550036000039	100	East Elementary		Regular School	No	Elementary	PK	05	2019	grade_1	14	14
3074096	WI	Langlade	school	5500360	140	Public school	Antigo Unified	550036000042	180	North Elementary		Regular School	No	Elementary	PK	05	2019	grade_1	19	19
3074103	WI	Langlade	school	5500360	140	Public school	Antigo Unified	550036000043	200	Pleasant View Elementary		Regular School	No	Elementary	PK	05	2019	grade_1	18	18
3074125	WI	Langlade	school	5500360	140	Public school	Antigo Unified	550036000045	260	Spring Valley Elementary		Regular School	No	Elementary	PK	05	2019	grade_1	17	17
3074132	WI	Langlade	school	5500360	140	Public school	Antigo Unified	550036000046	280	West Elementary		Regular School	No	Elementary	PK	05	2019	grade_1	31	31
3088839	WI	Langlade	school	5500360	140	Public school	Antigo Unified	550036000038	80	Crestwood Elementary		Regular School	No	Elementary	PK	05	2018	grade_1	15	15
3088847	WI	Langlade	school	5500360	140	Public school	Antigo Unified	550036000039	100	East Elementary		Regular School	No	Elementary	PK	05	2018	grade_1	22	22
3088855	WI	Langlade	school	5500360	140	Public school	Antigo Unified	550036000042	180	North Elementary		Regular School	No	Elementary	PK	05	2018	grade_1	20	20
3088862	WI	Langlade	school	5500360	140	Public school	Antigo Unified	550036000043	200	Pleasant View Elementary		Regular School	No	Elementary	PK	05	2018	grade_1	17	17
3088881	WI	Langlade	school	5500360	140	Public school	Antigo Unified	550036000045	260	Spring Valley Elementary		Regular School	No	Elementary	PK	05	2018	grade_1	17	17
3088888	WI	Langlade	school	5500360	140	Public school	Antigo Unified	550036000046	280	West Elementary		Regular School	No	Elementary	PK	05	2018	grade_1	41	41
111983	WI	Outagamie	school	5500390	147	Public school	Appleton Area	550039002880	155	Appleton Bilingual School	charter	Regular School	Yes	1.0	KG	04	2015	grade_1	28	28
112007	WI	Outagamie	school	5500390	147	Public school	Appleton Area	550039002583	145	Appleton Public Montessori	charter	Regular School	Yes	1.0	PK	06	2015	grade_1	20	20
112021	WI	Outagamie	school	5500390	147	Public school	Appleton Area	550039000049	60	Badger Elementary		Regular School	No	1.0	PK	06	2015	grade_1	59	59
112030	WI	Outagamie	school	5500390	147	Public school	Appleton Area	550039002427	220	Berry Elementary		Regular School	No	1.0	PK	06	2015	grade_1	61	61
112038	WI	Outagamie	school	5500390	147	Public school	Appleton Area	550039001619	110	Classical School	charter	Regular School	Yes	1.0	KG	08	2015	grade_1	52	52
112048	WI	Outagamie	school	5500390	147	Public school	Appleton Area	550039000050	80	Columbus Elementary		Regular School	No	1.0	PK	06	2015	grade_1	24	24
112062	WI	Outagamie	school	5500390	147	Public school	Appleton Area	550039000051	100	Edison Elementary		Regular School	No	1.0	PK	06	2015	grade_1	57	57
112074	WI	Outagamie	school	5500390	147	Public school	Appleton Area	550039002426	130	Ferber Elementary		Regular School	No	1.0	PK	06	2015	grade_1	66	66
112082	WI	Outagamie	school	5500390	147	Public school	Appleton Area	550039002582	135	Fox River Academy	charter	Regular School	Yes	1.0	01	08	2015	grade_1	10	10
112091	WI	Outagamie	school	5500390	147	Public school	Appleton Area	550039000054	160	Franklin Elementary		Regular School	No	1.0	PK	06	2015	grade_1	55	55
112100	WI	Outagamie	school	5500390	147	Public school	Appleton Area	550039000055	180	Highlands Elementary		Regular School	No	1.0	PK	06	2015	grade_1	85	85
112109	WI	Outagamie	school	5500390	147	Public school	Appleton Area	550039002350	190	Horizons Elementary		Regular School	No	1.0	PK	06	2015	grade_1	50	50
112117	WI	Outagamie	school	5500390	147	Public school	Appleton Area	550039002366	195	Houdini Elementary		Regular School	No	1.0	PK	06	2015	grade_1	88	88
112126	WI	Outagamie	school	5500390	147	Public school	Appleton Area	550039000056	200	Huntley Elementary		Regular School	No	1.0	PK	06	2015	grade_1	102	102
112134	WI	Outagamie	school	5500390	147	Public school	Appleton Area	550039000057	240	Jefferson Elementary		Regular School	No	1.0	PK	06	2015	grade_1	68	68
112142	WI	Outagamie	school	5500390	147	Public school	Appleton Area	550039000058	260	Johnston Elementary		Regular School	No	1.0	PK	06	2015	grade_1	62	62
112155	WI	Outagamie	school	5500390	147	Public school	Appleton Area	550039000059	280	Lincoln Elementary		Regular School	No	1.0	PK	06	2015	grade_1	53	53
112167	WI	Outagamie	school	5500390	147	Public school	Appleton Area	550039000061	320	McKinley Elementary		Regular School	No	1.0	PK	06	2015	grade_1	78	78
112193	WI	Outagamie	school	5500390	147	Public school	Appleton Area	550039000062	340	Richmond Elementary		Regular School	No	1.0	PK	06	2015	grade_1	54	54
112205	WI	Outagamie	school	5500390	147	Public school	Appleton Area	550039002639	150	Stephen Foster Elementary Charter	charter	Regular School	Yes	1.0	PK	06	2015	grade_1	39	39
112233	WI	Outagamie	school	5500390	147	Public school	Appleton Area	550039002825	850	Wisconsin Connections Academy	charter	Regular School	Yes	4.0	KG	12	2015	grade_1	24	24
281958	WI	Outagamie	school	5500390	147	Public school	Appleton Area	550039002880	155	Appleton Bilingual School	charter	Regular School	Yes	1.0	KG	05	2016	grade_1	28	28
281982	WI	Outagamie	school	5500390	147	Public school	Appleton Area	550039002583	145	Appleton Public Montessori	charter	Regular School	Yes	1.0	PK	06	2016	grade_1	20	20
281999	WI	Outagamie	school	5500390	147	Public school	Appleton Area	550039000049	60	Badger Elementary		Regular School	No	1.0	PK	06	2016	grade_1	49	49
282007	WI	Outagamie	school	5500390	147	Public school	Appleton Area	550039002427	220	Berry Elementary		Regular School	No	1.0	PK	06	2016	grade_1	63	63
282015	WI	Outagamie	school	5500390	147	Public school	Appleton Area	550039001619	110	Classical School	charter	Regular School	Yes	1.0	KG	08	2016	grade_1	52	52
282025	WI	Outagamie	school	5500390	147	Public school	Appleton Area	550039000050	80	Columbus Elementary		Regular School	No	1.0	PK	06	2016	grade_1	25	25
282038	WI	Outagamie	school	5500390	147	Public school	Appleton Area	550039000051	100	Edison Elementary		Regular School	No	1.0	PK	06	2016	grade_1	40	40
282050	WI	Outagamie	school	5500390	147	Public school	Appleton Area	550039002426	130	Ferber Elementary		Regular School	No	1.0	PK	06	2016	grade_1	96	96
282058	WI	Outagamie	school	5500390	147	Public school	Appleton Area	550039002582	135	Fox River Academy	charter	Regular School	Yes	1.0	01	08	2016	grade_1	9	9
282067	WI	Outagamie	school	5500390	147	Public school	Appleton Area	550039000054	160	Franklin Elementary		Regular School	No	1.0	PK	06	2016	grade_1	60	60
282076	WI	Outagamie	school	5500390	147	Public school	Appleton Area	550039000055	180	Highlands Elementary		Regular School	No	1.0	PK	06	2016	grade_1	94	94
282085	WI	Outagamie	school	5500390	147	Public school	Appleton Area	550039002350	190	Horizons Elementary		Regular School	No	1.0	PK	06	2016	grade_1	63	63
282093	WI	Outagamie	school	5500390	147	Public school	Appleton Area	550039002366	195	Houdini Elementary		Regular School	No	1.0	PK	06	2016	grade_1	96	96
282101	WI	Outagamie	school	5500390	147	Public school	Appleton Area	550039000056	200	Huntley Elementary		Regular School	No	1.0	PK	06	2016	grade_1	114	114
282109	WI	Outagamie	school	5500390	147	Public school	Appleton Area	550039000057	240	Jefferson Elementary		Regular School	No	1.0	PK	06	2016	grade_1	39	39
282117	WI	Outagamie	school	5500390	147	Public school	Appleton Area	550039000058	260	Johnston Elementary		Regular School	No	1.0	PK	06	2016	grade_1	67	67
282130	WI	Outagamie	school	5500390	147	Public school	Appleton Area	550039000059	280	Lincoln Elementary		Regular School	No	1.0	PK	06	2016	grade_1	50	50
282142	WI	Outagamie	school	5500390	147	Public school	Appleton Area	550039000061	320	McKinley Elementary		Regular School	No	1.0	PK	06	2016	grade_1	66	66
282168	WI	Outagamie	school	5500390	147	Public school	Appleton Area	550039000062	340	Richmond Elementary		Regular School	No	1.0	PK	06	2016	grade_1	40	40
282179	WI	Outagamie	school	5500390	147	Public school	Appleton Area	550039002639	150	Stephen Foster Elementary Charter	charter	Regular School	Yes	1.0	PK	06	2016	grade_1	53	53
282207	WI	Outagamie	school	5500390	147	Public school	Appleton Area	550039002825	850	Wisconsin Connections Academy	charter	Regular School	Yes	4.0	KG	12	2016	grade_1	20	20
325852	WI	Outagamie	school	5500390	147	Public school	Appleton Area	550039002880	155	Appleton Bilingual School	charter	Regular School	Yes	Elementary	KG	06	2017	grade_1	28	28
325869	WI	Outagamie	school	5500390	147	Public school	Appleton Area	550039002583	145	Appleton Public Montessori	charter	Regular School	Yes	Elementary	PK	06	2017	grade_1	20	20
325893	WI	Outagamie	school	5500390	147	Public school	Appleton Area	550039000049	60	Badger Elementary		Regular School	No	Elementary	PK	06	2017	grade_1	47	47
325901	WI	Outagamie	school	5500390	147	Public school	Appleton Area	550039002427	220	Berry Elementary		Regular School	No	Elementary	PK	06	2017	grade_1	65	65
325909	WI	Outagamie	school	5500390	147	Public school	Appleton Area	550039001619	110	Classical School	charter	Regular School	Yes	Elementary	KG	08	2017	grade_1	52	52
325919	WI	Outagamie	school	5500390	147	Public school	Appleton Area	550039000050	80	Columbus Elementary		Regular School	No	Elementary	PK	06	2017	grade_1	21	21
325933	WI	Outagamie	school	5500390	147	Public school	Appleton Area	550039000051	100	Edison Elementary		Regular School	No	Elementary	PK	06	2017	grade_1	29	29
325945	WI	Outagamie	school	5500390	147	Public school	Appleton Area	550039002426	130	Ferber Elementary		Regular School	No	Elementary	PK	06	2017	grade_1	92	92
325958	WI	Outagamie	school	5500390	147	Public school	Appleton Area	550039002582	135	Fox River Academy	charter	Regular School	Yes	Elementary	KG	08	2017	grade_1	12	12
325968	WI	Outagamie	school	5500390	147	Public school	Appleton Area	550039000054	160	Franklin Elementary		Regular School	No	Elementary	PK	06	2017	grade_1	51	51
325977	WI	Outagamie	school	5500390	147	Public school	Appleton Area	550039000055	180	Highlands Elementary		Regular School	No	Elementary	PK	06	2017	grade_1	89	89
325986	WI	Outagamie	school	5500390	147	Public school	Appleton Area	550039002350	190	Horizons Elementary		Regular School	No	Elementary	PK	06	2017	grade_1	54	54
325994	WI	Outagamie	school	5500390	147	Public school	Appleton Area	550039002366	195	Houdini Elementary		Regular School	No	Elementary	PK	06	2017	grade_1	83	83
326002	WI	Outagamie	school	5500390	147	Public school	Appleton Area	550039000056	200	Huntley Elementary		Regular School	No	Elementary	PK	06	2017	grade_1	124	124
326010	WI	Outagamie	school	5500390	147	Public school	Appleton Area	550039000057	240	Jefferson Elementary		Regular School	No	Elementary	PK	06	2017	grade_1	64	64
326018	WI	Outagamie	school	5500390	147	Public school	Appleton Area	550039000058	260	Johnston Elementary		Regular School	No	Elementary	PK	06	2017	grade_1	60	60
326031	WI	Outagamie	school	5500390	147	Public school	Appleton Area	550039000059	280	Lincoln Elementary		Regular School	No	Elementary	PK	06	2017	grade_1	52	52
326043	WI	Outagamie	school	5500390	147	Public school	Appleton Area	550039000061	320	McKinley Elementary		Regular School	No	Elementary	PK	06	2017	grade_1	72	72
326069	WI	Outagamie	school	5500390	147	Public school	Appleton Area	550039000062	340	Richmond Elementary		Regular School	No	Elementary	PK	06	2017	grade_1	37	37
326077	WI	Outagamie	school	5500390	147	Public school	Appleton Area	550039002639	150	Stephen Foster Elementary Charter	charter	Regular School	Yes	Elementary	PK	06	2017	grade_1	47	47
326105	WI	Outagamie	school	5500390	147	Public school	Appleton Area	550039002825	850	Wisconsin Connections Academy	charter	Regular School	Yes	Other	KG	12	2017	grade_1	26	26
2318348	WI	Outagamie	school	5500390	147	Public school	Appleton Area	550039002880	155	Appleton Bilingual School	charter	Regular School	Yes	Elementary	KG	06	2020	grade_1	28	28
2318366	WI	Outagamie	school	5500390	147	Public school	Appleton Area	550039002583	145	Appleton Public Montessori	charter	Regular School	Yes	Elementary	PK	06	2020	grade_1	20	20
2318382	WI	Outagamie	school	5500390	147	Public school	Appleton Area	550039000049	60	Badger Elementary		Regular School	No	Elementary	PK	06	2020	grade_1	55	55
2318390	WI	Outagamie	school	5500390	147	Public school	Appleton Area	550039002427	220	Berry Elementary		Regular School	No	Elementary	PK	06	2020	grade_1	72	72
2318398	WI	Outagamie	school	5500390	147	Public school	Appleton Area	550039001619	110	Classical School	charter	Regular School	Yes	Elementary	KG	08	2020	grade_1	52	52
2318408	WI	Outagamie	school	5500390	147	Public school	Appleton Area	550039000050	80	Columbus Elementary		Regular School	No	Elementary	PK	06	2020	grade_1	21	21
2318421	WI	Outagamie	school	5500390	147	Public school	Appleton Area	550039000051	100	Edison Elementary		Regular School	No	Elementary	PK	06	2020	grade_1	41	41
2318433	WI	Outagamie	school	5500390	147	Public school	Appleton Area	550039002426	130	Ferber Elementary		Regular School	No	Elementary	PK	06	2020	grade_1	92	92
2318446	WI	Outagamie	school	5500390	147	Public school	Appleton Area	550039002582	135	Fox River Academy	charter	Regular School	Yes	Elementary	KG	08	2020	grade_1	13	13
2318456	WI	Outagamie	school	5500390	147	Public school	Appleton Area	550039000054	160	Franklin Elementary		Regular School	No	Elementary	PK	06	2020	grade_1	53	53
2318465	WI	Outagamie	school	5500390	147	Public school	Appleton Area	550039000055	180	Highlands Elementary		Regular School	No	Elementary	PK	06	2020	grade_1	97	97
2318474	WI	Outagamie	school	5500390	147	Public school	Appleton Area	550039002350	190	Horizons Elementary		Regular School	No	Elementary	PK	06	2020	grade_1	50	50
2318482	WI	Outagamie	school	5500390	147	Public school	Appleton Area	550039002366	195	Houdini Elementary		Regular School	No	Elementary	PK	06	2020	grade_1	95	95
2318490	WI	Outagamie	school	5500390	147	Public school	Appleton Area	550039000056	200	Huntley Elementary		Regular School	No	Elementary	PK	06	2020	grade_1	89	89
2318498	WI	Outagamie	school	5500390	147	Public school	Appleton Area	550039000057	240	Jefferson Elementary		Regular School	No	Elementary	PK	06	2020	grade_1	52	52
2318506	WI	Outagamie	school	5500390	147	Public school	Appleton Area	550039000058	260	Johnston Elementary		Regular School	No	Elementary	PK	06	2020	grade_1	66	66
2318519	WI	Outagamie	school	5500390	147	Public school	Appleton Area	550039000059	280	Lincoln Elementary		Regular School	No	Elementary	PK	06	2020	grade_1	48	48
2318530	WI	Outagamie	school	5500390	147	Public school	Appleton Area	550039000061	320	McKinley Elementary		Regular School	No	Elementary	PK	06	2020	grade_1	68	68