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 ccd_school_low_grade 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
3074119	WI	Langlade	school		140	Public Schools-Multidistrict Charters	Antigo Unified		9100	Rural Virtual Academy	charter						2019	grade_6	2	2
3075177	WI	Shawano	school		623	Public Schools-Multidistrict Charters	Bowler		9100	Rural Virtual Academy	charter						2019	grade_6	3	3
3075857	WI	Clark	school		1162	Public Schools-Multidistrict Charters	Colby		9100	Rural Virtual Academy	charter						2019	grade_6	2	2
3076889	WI	Rock	school		1694	Public Schools-Multidistrict Charters	Evansville Community		9803	JEDI Virtual K-12	charter						2019	grade_6	1	1
3078689	WI	Jefferson	school		2702	Public Schools-Multidistrict Charters	Jefferson		9803	JEDI Virtual K-12	charter						2019	grade_6	1	1
3080429	WI	Wood	school		3339	Public Schools-Multidistrict Charters	Marshfield Unified		9100	Rural Virtual Academy	charter						2019	grade_6	4	4
3082733	WI	Marathon	school		3787	Public Schools-Multidistrict Charters	Mosinee		9100	Rural Virtual Academy	charter						2019	grade_6	1	1
3084187	WI	Wood	school		4368	Public Schools-Multidistrict Charters	Pittsville		9100	Rural Virtual Academy	charter						2019	grade_6	2	2
3084950	WI	Taylor	school		4795	Public Schools-Multidistrict Charters	Rib Lake		9100	Rural Virtual Academy	charter						2019	grade_6	5	5
3086048	WI	Marathon	school		5467	Public Schools-Multidistrict Charters	Spencer		9100	Rural Virtual Academy	charter						2019	grade_6	1	1
3086303	WI	Marathon	school		5628	Public Schools-Multidistrict Charters	Stratford		9100	Rural Virtual Academy	charter						2019	grade_6	1	1
3086385	WI	Dane	school		5656	Public Schools-Multidistrict Charters	Sun Prairie Area		9803	JEDI Virtual K-12	charter						2019	grade_6	3	3
3086644	WI	Monroe	school		5747	Public Schools-Multidistrict Charters	Tomah Area		9100	Rural Virtual Academy	charter						2019	grade_6	3	3
3080175	WI	Manitowoc	school	5508610	3290	Public school	Manitowoc	550861000973	60	Franklin Elementary		Regular School	No	Elementary	01	06	2019	grade_6	68	68
3080182	WI	Manitowoc	school	5508610	3290	Public school	Manitowoc	550861000974	100	Jackson Elementary		Regular School	No	Elementary	01	06	2019	grade_6	49	49
3080189	WI	Manitowoc	school	5508610	3290	Public school	Manitowoc	550861000975	120	Jefferson Elementary		Regular School	No	Elementary	01	06	2019	grade_6	73	73
3080200	WI	Manitowoc	school	5508610	3290	Public school	Manitowoc	550861000977	160	Madison Elementary		Regular School	No	Elementary	01	06	2019	grade_6	41	41
3080212	WI	Manitowoc	school	5508610	3290	Public school	Manitowoc	550861000978	220	Monroe Elementary		Regular School	No	Elementary	01	06	2019	grade_6	71	71
3080223	WI	Manitowoc	school	5508610	3290	Public school	Manitowoc	550861000979	260	Stangel Elementary		Regular School	No	Elementary	01	06	2019	grade_6	64	64
3082287	WI	Milwaukee	school	5509600	3619	Public school	Milwaukee	550960002442	312	Starms Discovery		Regular School	No	Elementary	01	08	2019	grade_6	37	37
3087455	WI	Fond du Lac	school	5515870	6216	Public school	Waupun	551587002809	110	Rock River Intermediate		Regular School	No	Elementary	02	06	2019	grade_6	134	134
3074338	WI	Outagamie	school	5500390	147	Public school	Appleton Area	550039002277	210	Odyssey-Magellan		Regular School	No	Middle	03	08	2019	grade_6	31	31
3074459	WI	Ashland	school	5500510	170	Public school	Ashland	550051002928	130	Lake Superior Learning Community	charter	Regular School	Yes	Elementary	03	06	2019	grade_6	11	11
3079816	WI	Kewaunee	school	5508340	3220	Public school	Luxemburg-Casco	550834000916	100	Luxemburg-Casco Intermediate		Regular School	No	Elementary	03	06	2019	grade_6	129	129
3080268	WI	Milwaukee	school	5504770	1897	Public school	Maple Dale-Indian Hill	550477000516	40	Maple Dale Elementary		Regular School	No	Middle	03	08	2019	grade_6	53	53
3080366	WI	Dane	school	5508790	3332	Public school	Marshall	550879001012	20	Marshall Elementary		Regular School	No	Elementary	03	06	2019	grade_6	74	74
3080498	WI	Dodge	school	5508880	3367	Public school	Mayville	550888001029	60	Mayville Middle		Regular School	No	Middle	03	08	2019	grade_6	76	76
3081917	WI	Milwaukee	school	5509600	3619	Public school	Milwaukee	550960001164	176	Meir School		Regular School	No	Other	03	12	2019	grade_6	129	129
3083253	WI	Waukesha	school	5510710	3976	Public school	Norris	551071001395	20	Norris Academy		Regular School	No	Other	03	12	2019	grade_6	1	1
3085711	WI	Washburn	school	5513710	5306	Public school	Shell Lake	551371001804	20	Shell Lake Elementary (3-6)		Regular School	No	Elementary	03	06	2019	grade_6	51	51
3074851	WI	Rock	school	5501050	413	Public school	Beloit	550105000137	20	Aldrich Intermediate		Regular School	No	Middle	04	08	2019	grade_6	86	86
3074884	WI	Rock	school	5501050	413	Public school	Beloit	550105000140	80	Cunningham Intermediate		Regular School	No	Middle	04	08	2019	grade_6	126	126
3074890	WI	Rock	school	5501050	413	Public school	Beloit	550105003011	170	Fran Fruzen Intermediate		Regular School	No	Middle	04	08	2019	grade_6	126	126
3074910	WI	Rock	school	5501050	413	Public school	Beloit	550105002330	180	McNeel Intermediate		Regular School	No	Middle	04	08	2019	grade_6	143	143
3075321	WI	Racine	school	5501890	777	Public school	Burlington Area	550189002462	110	Dr Edward G Dyer School		Regular School	No	Middle	04	06	2019	grade_6	226	226
3077306	WI	Walworth	school	5505130	2051	Public school	Genoa City J2	550513002327	200	Brookwood Middle		Regular School	No	Middle	04	08	2019	grade_6	55	55
3077422	WI	Milwaukee	school	5505460	2184	Public school	Glendale-River Hills	550546000575	10	Glen Hills Middle		Regular School	No	Middle	04	08	2019	grade_6	92	92
3077522	WI	Burnett	school	5505670	2233	Public school	Grantsburg	550567000603	100	Grantsburg Middle		Regular School	No	Middle	04	08	2019	grade_6	55	55
3081001	WI	Rock	school	5509570	3612	Public school	Milton	550957000382	130	Northside Intermediate		Regular School	No	Middle	04	06	2019	grade_6	257	257
3082723	WI	Marathon	school	5509960	3787	Public school	Mosinee	550996001309	120	Mosinee Middle		Regular School	No	Middle	04	08	2019	grade_6	155	155
3082911	WI	Winnebago	school	5510320	3892	Public school	Neenah Joint	551032000579	215	Horace Mann Middle		Regular School	No	Middle	04	06	2019	grade_6	501	501
3082985	WI	Wood	school	5510380	3906	Public school	Nekoosa	551038001358	20	Alexander Middle		Regular School	No	Middle	04	08	2019	grade_6	69	69
3083417	WI	Washburn	school	5509720	3654	Public school	Northwood	550972002877	200	NorthStar Community Charter School	charter	Regular School	Yes	Middle	04	08	2019	grade_6	3	3
3083796	WI	Winnebago	school	5511190	4179	Public school	Oshkosh Area	551119003364	170	Accelerated Advanced Learning Program	charter	Regular School	Yes	Middle	04	08	2019	grade_6	16	16
3084120	WI	Waukesha	school	5511640	4312	Public school	Pewaukee	551164000226	40	Horizon School		Regular School	No	Middle	04	06	2019	grade_6	217	217
3085234	WI	Fond du Lac	school	5513100	4956	Public school	Rosendale-Brandon	551310001731	80	Rosendale Intermediate		Regular School	No	Middle	04	08	2019	grade_6	55	55
3085280	WI	Juneau	school	5504380	1673	Public school	Royall	550438000473	40	Royall Intermediate		Regular School	No	Middle	04	06	2019	grade_6	42	42
3085335	WI	Milwaukee	school	5513260	5026	Public school	Saint Francis	551326001747	20	Deer Creek Intermediate		Regular School	No	Middle	04	08	2019	grade_6	75	75
3087638	WI	Waushara	school	5515960	6237	Public school	Wautoma Area	551596002071	30	Parkside School		Regular School	No	Middle	04	08	2019	grade_6	103	103
3073936	WI	Adams	school	5500060	14	Public school	Adams-Friendship Area	550006001454	210	Adams-Friendship Middle		Regular School	No	Middle	05	08	2019	grade_6	115	115
3074411	WI	Trempealeau	school	5500420	154	Public school	Arcadia	550042003041	290	Arcadia Middle		Regular School	No	Middle	05	08	2019	grade_6	105	105
3074702	WI	Barron	school	5500870	308	Public school	Barron Area	550087000118	140	Riverview Middle		Regular School	No	Middle	05	08	2019	grade_6	93	93
3075117	WI	Chippewa	school	5501350	497	Public school	Bloomer	550135000185	60	Bloomer Middle		Regular School	No	Middle	05	08	2019	grade_6	99	99
3075462	WI	Barron	school	5502130	903	Public school	Cameron	550213002286	200	Cameron Middle		Regular School	No	Middle	05	08	2019	grade_6	97	97
3075555	WI	Sheboygan	school	5502430	1029	Public school	Cedar Grove-Belgium Area	550243001629	200	Cedar Grove-Belgium Middle		Regular School	No	Middle	05	08	2019	grade_6	81	81
3075689	WI	Calumet	school	5502520	1085	Public school	Chilton	550252002430	30	Chilton Middle		Regular School	No	Middle	05	08	2019	grade_6	97	97
3075797	WI	Rock	school	5502640	1134	Public school	Clinton Community	550264000297	80	Clinton Middle		Regular School	No	Middle	05	08	2019	grade_6	85	85
3075807	WI	Waupaca	school	5502670	1141	Public school	Clintonville	550267000301	20	Clintonville Middle		Regular School	No	Middle	05	08	2019	grade_6	87	87
3076056	WI	Barron	school	5503090	1260	Public school	Cumberland	550309000304	50	Cumberland Middle		Regular School	No	Middle	05	08	2019	grade_6	74	74
3076192	WI	Dane	school	5503180	1316	Public school	De Forest Area	550318000356	50	De Forest Middle		Regular School	No	Middle	05	08	2019	grade_6	280	280
3076233	WI	Brown	school	5503210	1414	Public school	De Pere	550321002488	200	Foxview Intermediate		Regular School	No	Middle	05	06	2019	grade_6	327	327
3076306	WI	Walworth	school	5503640	1380	Public school	Delavan-Darien	550364002241	60	Phoenix Middle		Regular School	No	Middle	05	08	2019	grade_6	130	130
3076683	WI	Dunn	school	5504230	1645	Public school	Elk Mound Area	550423000452	20	Elk Mound Middle		Regular School	No	Middle	05	08	2019	grade_6	77	77
3076820	WI	Waukesha	school	5501770	714	Public school	Elmbrook	550177000221	160	Fairview South		Special Education School	No	High	05	12	2019	grade_6	1	1
3076858	WI	Pierce	school	5504350	1666	Public school	Elmwood	550435000347	30	Elmwood Middle		Regular School	No	Middle	05	08	2019	grade_6	22	22
3077150	WI	Milwaukee	school	5504800	1890	Public school	Fox Point J2	550480000517	20	Bayside Middle		Regular School	No	Middle	05	08	2019	grade_6	90	90
3077416	WI	Buffalo	school	5505370	2142	Public school	Gilmanton	550537002907	250	Gilmanton Middle		Regular School	No	Middle	05	08	2019	grade_6	6	6
3078119	WI	Dodge	school	5500075	2525	Public school	Herman-Neosho-Rubicon	550007503034	150	Honor Intermediate		Regular School	No	Middle	05	08	2019	grade_6	35	35
3078154	WI	Calumet	school	5506450	2534	Public school	Hilbert	550645001458	200	Hilbert Middle		Regular School	No	Middle	05	08	2019	grade_6	29	29
3078224	WI	Washington	school	5500080	2570	Public school	Holy Hill Area	550008003078	290	Richfield Middle		Regular School	No	Middle	05	08	2019	grade_6	67	67
3078258	WI	Outagamie	school	5506600	2583	Public school	Hortonville Area	550660002573	210	Greenville Middle		Regular School	No	Middle	05	08	2019	grade_6	162	162
3078278	WI	Outagamie	school	5506600	2583	Public school	Hortonville Area	550660002408	30	Hortonville Middle		Regular School	No	Middle	05	08	2019	grade_6	132	132
3078321	WI	Brown	school	5506630	2604	Public school	Howard-Suamico	550663002456	110	Lineville Intermediate		Regular School	No	Middle	05	06	2019	grade_6	469	469
3078341	WI	Sheboygan	school	5506660	2605	Public school	Howards Grove	550666000563	125	Howards Grove Middle		Regular School	No	Middle	05	08	2019	grade_6	62	62
3078729	WI	Jefferson	school	5507170	2730	Public school	Johnson Creek	550717000783	40	Johnson Creek Middle and High		Regular School	No	High	05	12	2019	grade_6	45	45
3078784	WI	Outagamie	school	5507290	2758	Public school	Kaukauna Area	550729001700	200	River View School		Regular School	No	Middle	05	08	2019	grade_6	302	302
3079250	WI	Manitowoc	school	5507440	2828	Public school	Kiel Area	550744000845	60	Kiel Middle		Regular School	No	Middle	05	08	2019	grade_6	94	94
3079280	WI	Outagamie	school	5507470	2835	Public school	Kimberly Area	550747002642	140	Mapleview Intermediate		Regular School	No	Middle	05	06	2019	grade_6	189	189
3079295	WI	Outagamie	school	5507470	2835	Public school	Kimberly Area	550747002824	100	Woodland Intermediate		Regular School	No	Middle	05	06	2019	grade_6	192	192
3079603	WI	Jefferson	school	5507710	2898	Public school	Lake Mills Area	550771000888	60	Lake Mills Middle		Regular School	No	Middle	05	08	2019	grade_6	121	121
3079720	WI	Outagamie	school	5508160	3129	Public school	Little Chute Area	550816002858	100	Little Chute Intermediate		Regular School	No	Middle	05	06	2019	grade_6	115	115
3080301	WI	Marinette	school	5508700	3311	Public school	Marinette	550870000996	70	Marinette Middle		Regular School	No	Middle	05	08	2019	grade_6	170	170
3080567	WI	Taylor	school	5508940	3409	Public school	Medford Area Public	550894001044	240	Medford Middle		Regular School	No	Middle	05	08	2019	grade_6	161	161
3080888	WI	Waukesha	school	5509360	3528	Public school	Merton Community	550936002269	20	Merton Intermediate		Regular School	No	Middle	05	08	2019	grade_6	106	106
3080922	WI	Dane	school	5509510	3549	Public school	Middleton-Cross Plains Area	550951000754	50	Glacier Creek Middle		Regular School	No	Middle	05	08	2019	grade_6	257	257
3080927	WI	Dane	school	5509510	3549	Public school	Middleton-Cross Plains Area	550951001104	30	Kromrey Middle		Regular School	No	Middle	05	08	2019	grade_6	308	308
3082589	WI	Dane	school	5509810	3675	Public school	Monona Grove	550981001293	100	Glacial Drumlin School		Regular School	No	Middle	05	08	2019	grade_6	242	242
3082833	WI	Waukesha	school	5510170	3857	Public school	Muskego-Norway	551017001850	200	Lake Denoon Middle		Regular School	No	Middle	05	08	2019	grade_6	180	180
3082859	WI	Waukesha	school	5510170	3857	Public school	Muskego-Norway	551017001330	10	Muskego Lakes Middle		Regular School	No	Middle	05	08	2019	grade_6	164	164
3082989	WI	Wood	school	5510380	3906	Public school	Nekoosa	551038002957	100	Central Wisconsin STEM Academy	charter	Regular School	Yes	Middle	05	08	2019	grade_6	11	11
3083166	WI	Waupaca	school	5510590	3955	Public school	New London	551059001388	140	New London Middle		Regular School	No	Middle	05	08	2019	grade_6	181	181
3083411	WI	Vilas	school	5503860	1526	Public school	Northland Pines	550386002938	250	School of Options & Applied Research Middle	charter	Regular School	Yes	Middle	05	08	2019	grade_6	17	17
3083579	WI	Waukesha	school	5510890	4060	Public school	Oconomowoc Area	551089002795	200	Nature Hill Intermediate		Regular School	No	Middle	05	08	2019	grade_6	232	232
3083596	WI	Waukesha	school	5510890	4060	Public school	Oconomowoc Area	551089001422	135	Silver Lake Intermediate		Regular School	No	Middle	05	08	2019	grade_6	153	153
3083641	WI	Oconto	school	5510920	4067	Public school	Oconto Unified	551092002977	200	Bayshore Community Academy	charter	Regular School	Yes	Middle	05	08	2019	grade_6	19	19
3083663	WI	Oconto	school	5510920	4067	Public school	Oconto Unified	551092001430	180	Oconto Middle		Regular School	No	Middle	05	08	2019	grade_6	57	57
3083773	WI	Dane	school	5511100	4144	Public school	Oregon	551110002524	200	Rome Corners Intermediate		Regular School	No	Middle	05	06	2019	grade_6	300	300
3084020	WI	Columbia	school	5511370	4228	Public school	Pardeeville Area	551137001519	100	Pardeeville Middle		Regular School	No	Middle	05	08	2019	grade_6	78	78
3084197	WI	Grant	school	5511850	4389	Public school	Platteville	551185001554	80	Platteville Middle		Regular School	No	Middle	05	08	2019	grade_6	112	112
3084256	WI	Sheboygan	school	5511940	4473	Public school	Plymouth Joint	551194001563	120	Riverview Middle		Regular School	No	Middle	05	08	2019	grade_6	156	156
3084266	WI	Wood	school	5511970	4508	Public school	Port Edwards	551197000580	80	John Edwards Middle		Regular School	No	Middle	05	08	2019	grade_6	32	32