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 "state" = :p0 and "year" = :p1 and (ccd_charter_school < :p3 or ccd_charter_school is null or (ccd_charter_school = :p3 and rowid > :p2)) order by ccd_charter_school desc, 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	white	black	hispanic	native_american	asian	multiracial	male	female	low_income	disability	total	white_int	black_int	hispanic_int	native_american_int	asian_int	multiracial_int	male_int	female_int	low_income_int	disability_int	total_int
3074390	WI	Outagamie	school	5500390	147	Public school	Appleton Area	550039002825	850	Wisconsin Connections Academy	charter	Regular School	Yes	Other	PK	12	2019	grade_5											30											30
3074391	WI	Outagamie	school	5500390	147	Public school	Appleton Area	550039002825	850	Wisconsin Connections Academy	charter	Regular School	Yes	Other	PK	12	2019	grade_6											34											34
3074392	WI	Outagamie	school	5500390	147	Public school	Appleton Area	550039002825	850	Wisconsin Connections Academy	charter	Regular School	Yes	Other	PK	12	2019	grade_7											44											44
3074393	WI	Outagamie	school	5500390	147	Public school	Appleton Area	550039002825	850	Wisconsin Connections Academy	charter	Regular School	Yes	Other	PK	12	2019	grade_8											62											62
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
3074395	WI	Outagamie	school	5500390	147	Public school	Appleton Area	550039002825	850	Wisconsin Connections Academy	charter	Regular School	Yes	Other	PK	12	2019	kindergarten											15											15
3074446	WI	Ashland	school	5500510	170	Public school	Ashland	550051003017	400	Lake Superior High	charter	Regular School	Yes	High	09	12	2019	pk_12_total	13.0		1.0	10.0			12.0	12.0	*	6	24	13		1	10			12	12		6	24
3074447	WI	Ashland	school	5500510	170	Public school	Ashland	550051003017	400	Lake Superior High	charter	Regular School	Yes	High	09	12	2019	grade_10											4											4
3074448	WI	Ashland	school	5500510	170	Public school	Ashland	550051003017	400	Lake Superior High	charter	Regular School	Yes	High	09	12	2019	grade_11											8											8
3074449	WI	Ashland	school	5500510	170	Public school	Ashland	550051003017	400	Lake Superior High	charter	Regular School	Yes	High	09	12	2019	grade_12											2											2
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
3074455	WI	Ashland	school	5500510	170	Public school	Ashland	550051002928	130	Lake Superior Learning Community	charter	Regular School	Yes	Elementary	03	06	2019	pk_12_total	48.0	1.0	2.0	12.0	2.0	7.0	32.0	40.0	46	8	72	48	1	2	12	2	7	32	40	46	8	72
3074456	WI	Ashland	school	5500510	170	Public school	Ashland	550051002928	130	Lake Superior Learning Community	charter	Regular School	Yes	Elementary	03	06	2019	grade_3											21											21
3074457	WI	Ashland	school	5500510	170	Public school	Ashland	550051002928	130	Lake Superior Learning Community	charter	Regular School	Yes	Elementary	03	06	2019	grade_4											14											14
3074458	WI	Ashland	school	5500510	170	Public school	Ashland	550051002928	130	Lake Superior Learning Community	charter	Regular School	Yes	Elementary	03	06	2019	grade_5											26											26
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
3074473	WI	Ashland	school	5500510	170	Public school	Ashland	550051002986	250	Oredocker Project School	charter	Regular School	Yes	Middle	06	08	2019	pk_12_total	14.0			6.0		3.0	14.0	9.0	*	8	23	14			6		3	14	9		8	23
3074474	WI	Ashland	school	5500510	170	Public school	Ashland	550051002986	250	Oredocker Project School	charter	Regular School	Yes	Middle	06	08	2019	grade_7											7											7
3074475	WI	Ashland	school	5500510	170	Public school	Ashland	550051002986	250	Oredocker Project School	charter	Regular School	Yes	Middle	06	08	2019	grade_8											16											16
3074559	WI	Eau Claire	school	5500630	217	Public school	Augusta	550063002586	410	Wildlands Charter School	charter	Regular School	Yes	High	07	12	2019	pk_12_total	70.0					1.0	34.0	37.0	22	3	71	70					1	34	37	22	3	71
3074560	WI	Eau Claire	school	5500630	217	Public school	Augusta	550063002586	410	Wildlands Charter School	charter	Regular School	Yes	High	07	12	2019	grade_10											13											13
3074561	WI	Eau Claire	school	5500630	217	Public school	Augusta	550063002586	410	Wildlands Charter School	charter	Regular School	Yes	High	07	12	2019	grade_11											15											15
3074562	WI	Eau Claire	school	5500630	217	Public school	Augusta	550063002586	410	Wildlands Charter School	charter	Regular School	Yes	High	07	12	2019	grade_12											3											3
3074563	WI	Eau Claire	school	5500630	217	Public school	Augusta	550063002586	410	Wildlands Charter School	charter	Regular School	Yes	High	07	12	2019	grade_7											13											13
3074564	WI	Eau Claire	school	5500630	217	Public school	Augusta	550063002586	410	Wildlands Charter School	charter	Regular School	Yes	High	07	12	2019	grade_8											13											13
3074565	WI	Eau Claire	school	5500630	217	Public school	Augusta	550063002586	410	Wildlands Charter School	charter	Regular School	Yes	High	07	12	2019	grade_9											14											14
3074662	WI	Barron	school	5500870	308	Public school	Barron Area	550087002864	810	Advanced Learning Academy of Wisconsin	charter	Regular School	Yes	Other	KG	12	2019	pk_12_total	35.0	2.0	6.0			4.0	22.0	25.0	25	6	47	35	2	6			4	22	25	25	6	47
3074663	WI	Barron	school	5500870	308	Public school	Barron Area	550087002864	810	Advanced Learning Academy of Wisconsin	charter	Regular School	Yes	Other	KG	12	2019	grade_10											7											7
3074664	WI	Barron	school	5500870	308	Public school	Barron Area	550087002864	810	Advanced Learning Academy of Wisconsin	charter	Regular School	Yes	Other	KG	12	2019	grade_11											7											7
3074665	WI	Barron	school	5500870	308	Public school	Barron Area	550087002864	810	Advanced Learning Academy of Wisconsin	charter	Regular School	Yes	Other	KG	12	2019	grade_12											17											17
3074666	WI	Barron	school	5500870	308	Public school	Barron Area	550087002864	810	Advanced Learning Academy of Wisconsin	charter	Regular School	Yes	Other	KG	12	2019	grade_2											1											1
3074667	WI	Barron	school	5500870	308	Public school	Barron Area	550087002864	810	Advanced Learning Academy of Wisconsin	charter	Regular School	Yes	Other	KG	12	2019	grade_4											1											1
3074668	WI	Barron	school	5500870	308	Public school	Barron Area	550087002864	810	Advanced Learning Academy of Wisconsin	charter	Regular School	Yes	Other	KG	12	2019	grade_5											1											1
3074669	WI	Barron	school	5500870	308	Public school	Barron Area	550087002864	810	Advanced Learning Academy of Wisconsin	charter	Regular School	Yes	Other	KG	12	2019	grade_6											1											1
3074670	WI	Barron	school	5500870	308	Public school	Barron Area	550087002864	810	Advanced Learning Academy of Wisconsin	charter	Regular School	Yes	Other	KG	12	2019	grade_7											1											1
3074671	WI	Barron	school	5500870	308	Public school	Barron Area	550087002864	810	Advanced Learning Academy of Wisconsin	charter	Regular School	Yes	Other	KG	12	2019	grade_8											6											6
3074672	WI	Barron	school	5500870	308	Public school	Barron Area	550087002864	810	Advanced Learning Academy of Wisconsin	charter	Regular School	Yes	Other	KG	12	2019	grade_9											5											5
3074678	WI	Barron	school	5500870	308	Public school	Barron Area	550087002717	100	Barron Area Montessori School	charter	Regular School	Yes	Elementary	PK	03	2019	pk_12_total	42.0	10.0	6.0	1.0		1.0	30.0	30.0	37	3	60	42	10	6	1		1	30	30	37	3	60
3074679	WI	Barron	school	5500870	308	Public school	Barron Area	550087002717	100	Barron Area Montessori School	charter	Regular School	Yes	Elementary	PK	03	2019	grade_1											14											14
3074680	WI	Barron	school	5500870	308	Public school	Barron Area	550087002717	100	Barron Area Montessori School	charter	Regular School	Yes	Elementary	PK	03	2019	grade_2											6											6
3074681	WI	Barron	school	5500870	308	Public school	Barron Area	550087002717	100	Barron Area Montessori School	charter	Regular School	Yes	Elementary	PK	03	2019	grade_3											6											6
3074682	WI	Barron	school	5500870	308	Public school	Barron Area	550087002717	100	Barron Area Montessori School	charter	Regular School	Yes	Elementary	PK	03	2019	kindergarten_4_year_old											15											15
3074683	WI	Barron	school	5500870	308	Public school	Barron Area	550087002717	100	Barron Area Montessori School	charter	Regular School	Yes	Elementary	PK	03	2019	kindergarten											7											7
3074684	WI	Barron	school	5500870	308	Public school	Barron Area	550087002717	100	Barron Area Montessori School	charter	Regular School	Yes	Elementary	PK	03	2019	pre_kindergarten											12											12
3074930	WI	Rock	school	5501050	413	Public school	Beloit	550105002705	410	Roy Chapman Andrews Academy	charter	Regular School	Yes	High	06	12	2019	pk_12_total	30.0	5.0	3.0				19.0	19.0	26	5	38	30	5	3				19	19	26	5	38
3074931	WI	Rock	school	5501050	413	Public school	Beloit	550105002705	410	Roy Chapman Andrews Academy	charter	Regular School	Yes	High	06	12	2019	grade_10											6											6
3074932	WI	Rock	school	5501050	413	Public school	Beloit	550105002705	410	Roy Chapman Andrews Academy	charter	Regular School	Yes	High	06	12	2019	grade_11											8											8
3074933	WI	Rock	school	5501050	413	Public school	Beloit	550105002705	410	Roy Chapman Andrews Academy	charter	Regular School	Yes	High	06	12	2019	grade_12											6											6
3074934	WI	Rock	school	5501050	413	Public school	Beloit	550105002705	410	Roy Chapman Andrews Academy	charter	Regular School	Yes	High	06	12	2019	grade_6											1											1
3074935	WI	Rock	school	5501050	413	Public school	Beloit	550105002705	410	Roy Chapman Andrews Academy	charter	Regular School	Yes	High	06	12	2019	grade_7											4											4
3074936	WI	Rock	school	5501050	413	Public school	Beloit	550105002705	410	Roy Chapman Andrews Academy	charter	Regular School	Yes	High	06	12	2019	grade_8											6											6
3074937	WI	Rock	school	5501050	413	Public school	Beloit	550105002705	410	Roy Chapman Andrews Academy	charter	Regular School	Yes	High	06	12	2019	grade_9											7											7
3075007	WI	Washburn	school	5501170	441	Public school	Birchwood	550117002800	450	Birchwood Blue Hills Charter School	charter	Regular School	Yes	High	07	12	2019	pk_12_total	8.0	1.0				2.0	5.0	6.0	*	3	11	8	1				2	5	6		3	11
3075008	WI	Washburn	school	5501170	441	Public school	Birchwood	550117002800	450	Birchwood Blue Hills Charter School	charter	Regular School	Yes	High	07	12	2019	grade_10											1											1
3075009	WI	Washburn	school	5501170	441	Public school	Birchwood	550117002800	450	Birchwood Blue Hills Charter School	charter	Regular School	Yes	High	07	12	2019	grade_11											1											1
3075010	WI	Washburn	school	5501170	441	Public school	Birchwood	550117002800	450	Birchwood Blue Hills Charter School	charter	Regular School	Yes	High	07	12	2019	grade_12											2											2
3075011	WI	Washburn	school	5501170	441	Public school	Birchwood	550117002800	450	Birchwood Blue Hills Charter School	charter	Regular School	Yes	High	07	12	2019	grade_7											3											3
3075012	WI	Washburn	school	5501170	441	Public school	Birchwood	550117002800	450	Birchwood Blue Hills Charter School	charter	Regular School	Yes	High	07	12	2019	grade_8											1											1
3075013	WI	Washburn	school	5501170	441	Public school	Birchwood	550117002800	450	Birchwood Blue Hills Charter School	charter	Regular School	Yes	High	07	12	2019	grade_9											3											3
3075031	WI	Washburn	school	5501170	441	Public school	Birchwood	550117002937	130	Birchwood Public Montessori	charter	Regular School	Yes	Elementary	PK	06	2019	pk_12_total	33.0		2.0				18.0	17.0	15	4	35	33		2				18	17	15	4	35
3075032	WI	Washburn	school	5501170	441	Public school	Birchwood	550117002937	130	Birchwood Public Montessori	charter	Regular School	Yes	Elementary	PK	06	2019	grade_1											9											9
3075033	WI	Washburn	school	5501170	441	Public school	Birchwood	550117002937	130	Birchwood Public Montessori	charter	Regular School	Yes	Elementary	PK	06	2019	grade_2											3											3
3075034	WI	Washburn	school	5501170	441	Public school	Birchwood	550117002937	130	Birchwood Public Montessori	charter	Regular School	Yes	Elementary	PK	06	2019	grade_3											5											5
3075035	WI	Washburn	school	5501170	441	Public school	Birchwood	550117002937	130	Birchwood Public Montessori	charter	Regular School	Yes	Elementary	PK	06	2019	grade_4											7											7
3075036	WI	Washburn	school	5501170	441	Public school	Birchwood	550117002937	130	Birchwood Public Montessori	charter	Regular School	Yes	Elementary	PK	06	2019	grade_5											1											1
3075037	WI	Washburn	school	5501170	441	Public school	Birchwood	550117002937	130	Birchwood Public Montessori	charter	Regular School	Yes	Elementary	PK	06	2019	grade_6											2											2
3075038	WI	Washburn	school	5501170	441	Public school	Birchwood	550117002937	130	Birchwood Public Montessori	charter	Regular School	Yes	Elementary	PK	06	2019	kindergarten_4_year_old											3											3
3075039	WI	Washburn	school	5501170	441	Public school	Birchwood	550117002937	130	Birchwood Public Montessori	charter	Regular School	Yes	Elementary	PK	06	2019	kindergarten											5											5
3075040	WI	Washburn	school	5501170	441	Public school	Birchwood	550117003020	800	Bobcat Virtual Academy	charter	Regular School	Yes	Other	PK	12	2019	pk_12_total	11.0						5.0	6.0	*	3	11	11						5	6		3	11
3075041	WI	Washburn	school	5501170	441	Public school	Birchwood	550117003020	800	Bobcat Virtual Academy	charter	Regular School	Yes	Other	PK	12	2019	grade_10											1											1
3075042	WI	Washburn	school	5501170	441	Public school	Birchwood	550117003020	800	Bobcat Virtual Academy	charter	Regular School	Yes	Other	PK	12	2019	grade_11											2											2
3075043	WI	Washburn	school	5501170	441	Public school	Birchwood	550117003020	800	Bobcat Virtual Academy	charter	Regular School	Yes	Other	PK	12	2019	grade_12											2											2
3075044	WI	Washburn	school	5501170	441	Public school	Birchwood	550117003020	800	Bobcat Virtual Academy	charter	Regular School	Yes	Other	PK	12	2019	grade_3											2											2
3075045	WI	Washburn	school	5501170	441	Public school	Birchwood	550117003020	800	Bobcat Virtual Academy	charter	Regular School	Yes	Other	PK	12	2019	grade_6											1											1
3075046	WI	Washburn	school	5501170	441	Public school	Birchwood	550117003020	800	Bobcat Virtual Academy	charter	Regular School	Yes	Other	PK	12	2019	grade_7											1											1
3075047	WI	Washburn	school	5501170	441	Public school	Birchwood	550117003020	800	Bobcat Virtual Academy	charter	Regular School	Yes	Other	PK	12	2019	grade_9											2											2
3075292	WI	Milwaukee	school	5500059	8123	Non District Charter Schools	Bruce Guadalupe	550005900772	100	Bruce Guadalupe	charter	Regular School	Yes	Elementary	PK	08	2019	pk_12_total	23.0	2.0	1281.0		1.0	3.0	626.0	684.0	347	85	1310	23	2	1281		1	3	626	684	347	85	1310
3075293	WI	Milwaukee	school	5500059	8123	Non District Charter Schools	Bruce Guadalupe	550005900772	100	Bruce Guadalupe	charter	Regular School	Yes	Elementary	PK	08	2019	grade_1											131											131
3075294	WI	Milwaukee	school	5500059	8123	Non District Charter Schools	Bruce Guadalupe	550005900772	100	Bruce Guadalupe	charter	Regular School	Yes	Elementary	PK	08	2019	grade_2											135											135
3075295	WI	Milwaukee	school	5500059	8123	Non District Charter Schools	Bruce Guadalupe	550005900772	100	Bruce Guadalupe	charter	Regular School	Yes	Elementary	PK	08	2019	grade_3											141											141
3075296	WI	Milwaukee	school	5500059	8123	Non District Charter Schools	Bruce Guadalupe	550005900772	100	Bruce Guadalupe	charter	Regular School	Yes	Elementary	PK	08	2019	grade_4											140											140
3075297	WI	Milwaukee	school	5500059	8123	Non District Charter Schools	Bruce Guadalupe	550005900772	100	Bruce Guadalupe	charter	Regular School	Yes	Elementary	PK	08	2019	grade_5											140											140
3075298	WI	Milwaukee	school	5500059	8123	Non District Charter Schools	Bruce Guadalupe	550005900772	100	Bruce Guadalupe	charter	Regular School	Yes	Elementary	PK	08	2019	grade_6											129											129
3075299	WI	Milwaukee	school	5500059	8123	Non District Charter Schools	Bruce Guadalupe	550005900772	100	Bruce Guadalupe	charter	Regular School	Yes	Elementary	PK	08	2019	grade_7											105											105
3075300	WI	Milwaukee	school	5500059	8123	Non District Charter Schools	Bruce Guadalupe	550005900772	100	Bruce Guadalupe	charter	Regular School	Yes	Elementary	PK	08	2019	grade_8											102											102
3075301	WI	Milwaukee	school	5500059	8123	Non District Charter Schools	Bruce Guadalupe	550005900772	100	Bruce Guadalupe	charter	Regular School	Yes	Elementary	PK	08	2019	kindergarten_4_year_old											144											144
3075302	WI	Milwaukee	school	5500059	8123	Non District Charter Schools	Bruce Guadalupe	550005900772	100	Bruce Guadalupe	charter	Regular School	Yes	Elementary	PK	08	2019	kindergarten											143											143
3075372	WI	Ashland	school	5501920	840	Public school	Butternut	550192002751	450	Promethean Charter School	charter	Regular School	Yes	High	09	12	2019	pk_12_total	1.0				1.0		2.0		*	*	2	1				1		2				2
3075373	WI	Ashland	school	5501920	840	Public school	Butternut	550192002751	450	Promethean Charter School	charter	Regular School	Yes	High	09	12	2019	grade_10											1											1
3075374	WI	Ashland	school	5501920	840	Public school	Butternut	550192002751	450	Promethean Charter School	charter	Regular School	Yes	High	09	12	2019	grade_11											1											1
3075424	WI	Dane	school	5502100	896	Public school	Cambridge	550210003093	400	Koshkonong Trails School	charter	Regular School	Yes	Secondary	07	10	2019	pk_12_total	12.0						7.0	5.0	4	3	12	12						7	5	4	3	12
3075425	WI	Dane	school	5502100	896	Public school	Cambridge	550210003093	400	Koshkonong Trails School	charter	Regular School	Yes	Secondary	07	10	2019	grade_10											2											2
3075426	WI	Dane	school	5502100	896	Public school	Cambridge	550210003093	400	Koshkonong Trails School	charter	Regular School	Yes	Secondary	07	10	2019	grade_7											3											3
3075427	WI	Dane	school	5502100	896	Public school	Cambridge	550210003093	400	Koshkonong Trails School	charter	Regular School	Yes	Secondary	07	10	2019	grade_8											7											7
3075432	WI	Barron	school	5502130	903	Public school	Cameron	550213002851	800	Cameron Academy of Virtual Education	charter	Alternative School	Yes	Other	PK	12	2019	pk_12_total	83.0		1.0			8.0	35.0	57.0	32	2	92	83		1			8	35	57	32	2	92
3075433	WI	Barron	school	5502130	903	Public school	Cameron	550213002851	800	Cameron Academy of Virtual Education	charter	Alternative School	Yes	Other	PK	12	2019	grade_1											6											6
3075434	WI	Barron	school	5502130	903	Public school	Cameron	550213002851	800	Cameron Academy of Virtual Education	charter	Alternative School	Yes	Other	PK	12	2019	grade_10											12											12
3075435	WI	Barron	school	5502130	903	Public school	Cameron	550213002851	800	Cameron Academy of Virtual Education	charter	Alternative School	Yes	Other	PK	12	2019	grade_11											9											9
3075436	WI	Barron	school	5502130	903	Public school	Cameron	550213002851	800	Cameron Academy of Virtual Education	charter	Alternative School	Yes	Other	PK	12	2019	grade_12											8											8
3075437	WI	Barron	school	5502130	903	Public school	Cameron	550213002851	800	Cameron Academy of Virtual Education	charter	Alternative School	Yes	Other	PK	12	2019	grade_2											7											7
3075438	WI	Barron	school	5502130	903	Public school	Cameron	550213002851	800	Cameron Academy of Virtual Education	charter	Alternative School	Yes	Other	PK	12	2019	grade_3											7											7