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 "year" = :p2 order by district_state_id 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
3075569	WI	Ozaukee	school	5502460	1015	Public school	Cedarburg	550246000271	70	Parkview Elementary		Regular School	No	Elementary	PK	05	2019	grade_4	77	77
3075577	WI	Ozaukee	school	5502460	1015	Public school	Cedarburg	550246000272	90	Thorson Elementary		Regular School	No	Elementary	PK	05	2019	grade_4	74	74
3075589	WI	Ozaukee	school	5502460	1015	Public school	Cedarburg	550246002403	75	Westlawn Elementary		Regular School	No	Elementary	PK	05	2019	grade_4	52	52
3075544	WI	Sheboygan	school	5502430	1029	Public school	Cedar Grove-Belgium Area	550243000266	20	Cedar Grove-Belgium Elementary		Regular School	No	Elementary	PK	04	2019	grade_4	60	60
3074018	WI	Portage	school	5500240	105	Public school	Almond-Bancroft	550024000023	20	Almond-Bancroft Elementary		Regular School	No	Elementary	PK	05	2019	grade_4	29	29
3075633	WI	Price	school	5500058	1071	Public school	Chequamegon	550005801523	110	Park Falls Elementary		Regular School	No	Elementary	PK	05	2019	grade_4	50	50
3075651	WI	Barron	school	5500061	1080	Public school	Chetek-Weyerhaeuser Area	550006102805	100	Chetek-Weyerhaeuser Roselawn Elementary		Regular School	No	Elementary	PK	05	2019	grade_4	66	66
3075663	WI	Barron	school	5500061	1080	Public school	Chetek-Weyerhaeuser Area	550006102897	800	Link2Learn Virtual Charter School	charter	Regular School	Yes	Other	PK	12	2019	grade_4	6	6
3075678	WI	Calumet	school	5502520	1085	Public school	Chilton	550252000278	20	Chilton Elementary		Regular School	No	Elementary	PK	04	2019	grade_4	79	79
3075705	WI	Chippewa	school	5502550	1092	Public school	Chippewa Falls Area Unified	550255000284	110	Halmstad Elementary		Regular School	No	Elementary	KG	05	2019	grade_4	65	65
3075712	WI	Chippewa	school	5502550	1092	Public school	Chippewa Falls Area Unified	550255000285	120	Hillcrest Elementary		Regular School	No	Elementary	KG	05	2019	grade_4	66	66
3075719	WI	Chippewa	school	5502550	1092	Public school	Chippewa Falls Area Unified	550255000286	140	Jim Falls Elementary		Regular School	No	Elementary	KG	05	2019	grade_4	29	29
3075729	WI	Chippewa	school	5502550	1092	Public school	Chippewa Falls Area Unified	550255000637	220	Parkview Elementary		Regular School	No	Elementary	KG	05	2019	grade_4	73	73
3075736	WI	Chippewa	school	5502550	1092	Public school	Chippewa Falls Area Unified	550255002295	160	Southview Elementary		Regular School	No	Elementary	PK	05	2019	grade_4	52	52
3075743	WI	Chippewa	school	5502550	1092	Public school	Chippewa Falls Area Unified	550255000288	200	Stillson Elementary		Regular School	No	Elementary	KG	05	2019	grade_4	71	71
3074045	WI	Eau Claire	school	5500270	112	Public school	Altoona	550027002925	100	Altoona Intermediate		Regular School	No	Elementary	04	05	2019	grade_4	133	133
3075750	WI	Polk	school	5502580	1120	Public school	Clayton	550258000289	20	Clayton Elementary		Regular School	No	Elementary	PK	05	2019	grade_4	28	28
3075776	WI	Polk	school	5502610	1127	Public school	Clear Lake	550261000291	20	Gaylord A Nelson Educational Center		Regular School	No	Elementary	PK	06	2019	grade_4	53	53
3075786	WI	Rock	school	5502640	1134	Public school	Clinton Community	550264000295	40	Clinton Elementary		Regular School	No	Elementary	PK	04	2019	grade_4	78	78
3075817	WI	Waupaca	school	5502670	1141	Public school	Clintonville	550267000305	100	Longfellow Elementary		Regular School	No	Elementary	PK	04	2019	grade_4	86	86
3075823	WI	Buffalo	school	5502700	1155	Public school	Cochrane-Fountain City	550270000306	20	Cochrane-Fountain City Elementary		Regular School	No	Elementary	PK	06	2019	grade_4	49	49
3075839	WI	Clark	school	5502730	1162	Public school	Colby	550273000308	20	Colby Elementary		Regular School	No	Elementary	KG	05	2019	grade_4	69	69
3075856	WI	Clark	school		1162	Public Schools-Multidistrict Charters	Colby		9100	Rural Virtual Academy	charter						2019	grade_4	2	2
3075863	WI	Marinette	school	5502760	1169	Public school	Coleman	550276000313	40	Coleman Elementary		Regular School	No	Elementary	PK	05	2019	grade_4	55	55
3075880	WI	Dunn	school	5502790	1176	Public school	Colfax	550279000315	20	Colfax Elementary		Regular School	No	Elementary	PK	06	2019	grade_4	61	61
3075906	WI	Columbia	school	5502820	1183	Public school	Columbus	550282003100	150	Columbus Intermediate School		Regular School	No	Elementary	03	05	2019	grade_4	89	89
3074058	WI	Polk	school	5500300	119	Public school	Amery	550030000075	50	Amery Intermediate		Regular School	No	Elementary	03	05	2019	grade_4	101	101
3075921	WI	Chippewa	school	5502880	1204	Public school	Cornell	550288000323	20	Cornell Elementary		Regular School	No	Elementary	PK	05	2019	grade_4	26	26
3075939	WI	Forest	school	5502910	1218	Public school	Crandon	550291000326	40	Crandon Elementary		Regular School	No	Elementary	PK	05	2019	grade_4	74	74
3075957	WI	Marinette	school	5502970	1232	Public school	Crivitz	550297000329	20	Crivitz Elementary		Regular School	No	Elementary	PK	06	2019	grade_4	50	50
3075975	WI	Grant	school	5503030	1246	Public school	Cuba City	550303000332	20	Cuba City Elementary		Regular School	No	Elementary	PK	05	2019	grade_4	49	49
3076002	WI	Milwaukee	school	5503060	1253	Public school	Cudahy	550306000339	60	Jones Elementary		Regular School	No	Elementary	PK	05	2019	grade_4	18	18
3076011	WI	Milwaukee	school	5503060	1253	Public school	Cudahy	550306001228	140	Kosciuszko Elementary		Regular School	No	Elementary	PK	05	2019	grade_4	29	29
3076019	WI	Milwaukee	school	5503060	1253	Public school	Cudahy	550306000340	80	Lincoln Elementary		Regular School	No	Elementary	PK	05	2019	grade_4	40	40
3076027	WI	Milwaukee	school	5503060	1253	Public school	Cudahy	550306000338	50	Mitchell Elementary		Regular School	No	Elementary	PK	05	2019	grade_4	34	34
3076036	WI	Milwaukee	school	5503060	1253	Public school	Cudahy	550306000342	120	Park View Elementary		Regular School	No	Elementary	PK	05	2019	grade_4	40	40
3086704	WI	Portage	school	5500330	126	Public school	Tomorrow River	550033000032	20	Amherst Elementary		Regular School	No	Elementary	PK	04	2019	grade_4	72	72
3086722	WI	Portage	school	5500330	126	Public school	Tomorrow River	550033002968	100	Tomorrow River Community Charter	charter	Regular School	Yes	Elementary	PK	06	2019	grade_4	18	18
3086731	WI	Portage	school	5500330	126	Public school	Tomorrow River	550033003063	140	Tomorrow River Virtual Charter School (TRVCS)	charter	Regular School	Yes	Elementary	PK	08	2019	grade_4	6	6
3076045	WI	Barron	school	5503090	1260	Public school	Cumberland	550309000343	40	Cumberland Elementary		Regular School	No	Elementary	PK	04	2019	grade_4	76	76
3076073	WI	Barron	school	5503090	1260	Public school	Cumberland	550309002871	800	Island City Virtual Academy	charter	Regular School	Yes	Other	PK	12	2019	grade_4	1	1
3076161	WI	Lafayette	school	5503150	1295	Public school	Darlington Community	550315000704	160	Darlington Elementary/Middle		Regular School	No	Elementary	PK	08	2019	grade_4	60	60
3076284	WI	Dane	school	5503270	1309	Public school	Deerfield Community	550327000370	20	Deerfield Elementary		Regular School	No	Elementary	PK	06	2019	grade_4	56	56
3076199	WI	Dane	school	5503180	1316	Public school	De Forest Area	550318000354	20	Eagle Point Elementary		Regular School	No	Elementary	KG	04	2019	grade_4	98	98
3076208	WI	Dane	school	5503180	1316	Public school	De Forest Area	550318000360	140	Windsor Elementary		Regular School	No	Elementary	KG	04	2019	grade_4	97	97
3076214	WI	Dane	school	5503180	1316	Public school	De Forest Area	550318000108	160	Yahara Elementary		Regular School	No	Elementary	KG	04	2019	grade_4	85	85
3079102	WI	Waukesha	school	5503510	1376	Public school	Kettle Moraine	550351000374	40	Cushing Elementary		Regular School	No	Elementary	PK	05	2019	grade_4	77	77
3079111	WI	Waukesha	school	5503510	1376	Public school	Kettle Moraine	550351000375	60	Dousman Elementary		Regular School	No	Elementary	PK	05	2019	grade_4	78	78
3079127	WI	Waukesha	school	5503510	1376	Public school	Kettle Moraine	550351002914	180	Kettle Moraine Explore	charter	Regular School	Yes	Elementary	KG	05	2019	grade_4	25	25
3079148	WI	Waukesha	school	5503510	1376	Public school	Kettle Moraine	550351000378	160	Magee Elementary		Regular School	No	Elementary	PK	05	2019	grade_4	39	39
3079162	WI	Waukesha	school	5503510	1376	Public school	Kettle Moraine	550351000380	240	Wales Elementary		Regular School	No	Elementary	PK	05	2019	grade_4	58	58
3076313	WI	Walworth	school	5503640	1380	Public school	Delavan-Darien	550364000317	45	Turtle Creek Elementary		Regular School	No	Elementary	01	04	2019	grade_4	140	140
3073925	WI	Adams	school	5500060	14	Public school	Adams-Friendship Area	550006001433	130	Adams-Friendship Elementary		Regular School	No	Elementary	PK	04	2019	grade_4	76	76
3073943	WI	Adams	school	5500060	14	Public school	Adams-Friendship Area	550006000010	140	Grand Marsh Elementary		Regular School	No	Elementary	PK	04	2019	grade_4	22	22
3074083	WI	Langlade	school	5500360	140	Public school	Antigo Unified	550036000038	80	Crestwood Elementary		Regular School	No	Elementary	PK	05	2019	grade_4	20	20
3074091	WI	Langlade	school	5500360	140	Public school	Antigo Unified	550036000039	100	East Elementary		Regular School	No	Elementary	PK	05	2019	grade_4	17	17
3074099	WI	Langlade	school	5500360	140	Public school	Antigo Unified	550036000042	180	North Elementary		Regular School	No	Elementary	PK	05	2019	grade_4	26	26
3074106	WI	Langlade	school	5500360	140	Public school	Antigo Unified	550036000043	200	Pleasant View Elementary		Regular School	No	Elementary	PK	05	2019	grade_4	18	18
3074117	WI	Langlade	school		140	Public Schools-Multidistrict Charters	Antigo Unified		9100	Rural Virtual Academy	charter						2019	grade_4	2	2
3074128	WI	Langlade	school	5500360	140	Public school	Antigo Unified	550036000045	260	Spring Valley Elementary		Regular School	No	Elementary	PK	05	2019	grade_4	14	14
3074135	WI	Langlade	school	5500360	140	Public school	Antigo Unified	550036000046	280	West Elementary		Regular School	No	Elementary	PK	05	2019	grade_4	42	42
3076335	WI	Brown	school	5503660	1407	Public school	Denmark	550366000387	60	Denmark Elementary		Regular School	No	Elementary	01	05	2019	grade_4	88	88
3076228	WI	Brown	school	5503210	1414	Public school	De Pere	550321000363	40	Dickinson Elementary		Regular School	No	Elementary	PK	04	2019	grade_4	100	100
3076238	WI	Brown	school	5503210	1414	Public school	De Pere	550321001254	50	Heritage Elementary		Regular School	No	Elementary	PK	04	2019	grade_4	91	91
3076245	WI	Brown	school	5503210	1414	Public school	De Pere	550321002668	100	Susie C Altmayer Elementary		Regular School	No	Elementary	PK	04	2019	grade_4	114	114
3076268	WI	Vernon	school	5503240	1421	Public school	De Soto Area	550324000368	80	Prairie View Elementary		Regular School	No	Elementary	PK	05	2019	grade_4	15	15
3076276	WI	Vernon	school	5503240	1421	Public school	De Soto Area	550324000369	100	Stoddard Elementary		Regular School	No	Elementary	PK	05	2019	grade_4	15	15
3076368	WI	Iowa	school	5503690	1428	Public school	Dodgeville	550369000390	20	Dodgeville Elementary		Regular School	No	Elementary	PK	05	2019	grade_4	75	75
3076386	WI	Iowa	school	5503690	1428	Public school	Dodgeville	550369000393	60	Ridgeway Elementary		Regular School	No	Elementary	KG	05	2019	grade_4	6	6
3076393	WI	Racine	school	5503750	1449	Public school	Dover #1	550375000394	20	Kansasville Elementary		Regular School	No	Elementary	PK	08	2019	grade_4	11	11
3074142	WI	Outagamie	school	5500390	147	Public school	Appleton Area	550039002880	155	Appleton Bilingual School	charter	Regular School	Yes	Elementary	KG	06	2019	grade_4	28	28
3074159	WI	Outagamie	school	5500390	147	Public school	Appleton Area	550039002583	145	Appleton Public Montessori	charter	Regular School	Yes	Elementary	PK	06	2019	grade_4	21	21
3074175	WI	Outagamie	school	5500390	147	Public school	Appleton Area	550039000049	60	Badger Elementary		Regular School	No	Elementary	PK	06	2019	grade_4	46	46
3074183	WI	Outagamie	school	5500390	147	Public school	Appleton Area	550039002427	220	Berry Elementary		Regular School	No	Elementary	PK	06	2019	grade_4	69	69
3074191	WI	Outagamie	school	5500390	147	Public school	Appleton Area	550039001619	110	Classical School	charter	Regular School	Yes	Elementary	KG	08	2019	grade_4	53	53
3074201	WI	Outagamie	school	5500390	147	Public school	Appleton Area	550039000050	80	Columbus Elementary		Regular School	No	Elementary	PK	06	2019	grade_4	25	25
3074214	WI	Outagamie	school	5500390	147	Public school	Appleton Area	550039000051	100	Edison Elementary		Regular School	No	Elementary	PK	06	2019	grade_4	33	33
3074226	WI	Outagamie	school	5500390	147	Public school	Appleton Area	550039002426	130	Ferber Elementary		Regular School	No	Elementary	PK	06	2019	grade_4	106	106
3074239	WI	Outagamie	school	5500390	147	Public school	Appleton Area	550039002582	135	Fox River Academy	charter	Regular School	Yes	Elementary	KG	08	2019	grade_4	11	11
3074249	WI	Outagamie	school	5500390	147	Public school	Appleton Area	550039000054	160	Franklin Elementary		Regular School	No	Elementary	PK	06	2019	grade_4	60	60
3074258	WI	Outagamie	school	5500390	147	Public school	Appleton Area	550039000055	180	Highlands Elementary		Regular School	No	Elementary	PK	06	2019	grade_4	92	92
3074267	WI	Outagamie	school	5500390	147	Public school	Appleton Area	550039002350	190	Horizons Elementary		Regular School	No	Elementary	PK	06	2019	grade_4	58	58
3074275	WI	Outagamie	school	5500390	147	Public school	Appleton Area	550039002366	195	Houdini Elementary		Regular School	No	Elementary	PK	06	2019	grade_4	90	90
3074283	WI	Outagamie	school	5500390	147	Public school	Appleton Area	550039000056	200	Huntley Elementary		Regular School	No	Elementary	PK	06	2019	grade_4	119	119
3074291	WI	Outagamie	school	5500390	147	Public school	Appleton Area	550039000057	240	Jefferson Elementary		Regular School	No	Elementary	PK	06	2019	grade_4	43	43
3074299	WI	Outagamie	school	5500390	147	Public school	Appleton Area	550039000058	260	Johnston Elementary		Regular School	No	Elementary	PK	06	2019	grade_4	71	71
3074312	WI	Outagamie	school	5500390	147	Public school	Appleton Area	550039000059	280	Lincoln Elementary		Regular School	No	Elementary	PK	06	2019	grade_4	49	49
3074324	WI	Outagamie	school	5500390	147	Public school	Appleton Area	550039000061	320	McKinley Elementary		Regular School	No	Elementary	PK	06	2019	grade_4	72	72
3074336	WI	Outagamie	school	5500390	147	Public school	Appleton Area	550039002277	210	Odyssey-Magellan		Regular School	No	Middle	03	08	2019	grade_4	26	26
3074350	WI	Outagamie	school	5500390	147	Public school	Appleton Area	550039000062	340	Richmond Elementary		Regular School	No	Elementary	PK	06	2019	grade_4	41	41
3074358	WI	Outagamie	school	5500390	147	Public school	Appleton Area	550039002639	150	Stephen Foster Elementary Charter	charter	Regular School	Yes	Elementary	PK	06	2019	grade_4	50	50
3074389	WI	Outagamie	school	5500390	147	Public school	Appleton Area	550039002825	850	Wisconsin Connections Academy	charter	Regular School	Yes	Other	PK	12	2019	grade_4	30	30
3076416	WI	Bayfield	school	5503810	1491	Public school	Drummond Area	550381000398	20	Drummond Elementary		Regular School	No	Elementary	PK	06	2019	grade_4	25	25
3076434	WI	Pepin	school	5503840	1499	Public school	Durand-Arkansaw	550384000116	20	Caddie Woodlawn Elementary		Regular School	No	Elementary	PK	05	2019	grade_4	59	59
3083368	WI	Vilas	school	5503860	1526	Public school	Northland Pines	550386000404	40	Northland Pines Elementary-Eagle River		Regular School	No	Elementary	PK	06	2019	grade_4	64	64
3083378	WI	Vilas	school	5503860	1526	Public school	Northland Pines	550386000405	80	Northland Pines Elementary-Land O' Lakes		Regular School	No	Elementary	PK	04	2019	grade_4	13	13
3083386	WI	Vilas	school	5503860	1526	Public school	Northland Pines	550386000408	100	Northland Pines Elementary-St Germain		Regular School	No	Elementary	PK	04	2019	grade_4	15	15
3083401	WI	Vilas	school	5503860	1526	Public school	Northland Pines	550386003008	110	Northland Pines Montessori Learning Center (NPMLC)	charter	Regular School	Yes	Elementary	PK	04	2019	grade_4	9	9
3074400	WI	Trempealeau	school	5500420	154	Public school	Arcadia	550042003040	190	Arcadia Elementary		Regular School	No	Elementary	PK	04	2019	grade_4	100	100
3076464	WI	Walworth	school	5504020	1540	Public school	East Troy Community	550402001640	100	Prairie View Elementary		Regular School	No	Elementary	03	05	2019	grade_4	110	110
3076470	WI	Eau Claire	school	5504050	1554	Public school	Eau Claire Area	550405002544	111	Chippewa Valley Montessori Charter School	charter	Regular School	Yes	Elementary	PK	05	2019	grade_4	38	38