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 order by school 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	pacific_islander	multiracial	male	female	low_income	disability	total	white_int	black_int	hispanic_int	native_american_int	asian_int	pacific_islander_int	multiracial_int	male_int	female_int	low_income_int	disability_int	total_int
281703	WI	Racine	school	5500045	8110	Non District Charter Schools	21st Century Preparatory School	550004502575	100	21st Century Preparatory School	charter	Regular School	Yes	1.0	PK	08	2016	pk_12_total	71.0	202.0	139.0		2.0		31.0	219.0	226.0	311	54	445	71	202	139		2		31	219	226	311	54	445
281704	WI	Racine	school	5500045	8110	Non District Charter Schools	21st Century Preparatory School	550004502575	100	21st Century Preparatory School	charter	Regular School	Yes	1.0	PK	08	2016	grade_1												50												50
281705	WI	Racine	school	5500045	8110	Non District Charter Schools	21st Century Preparatory School	550004502575	100	21st Century Preparatory School	charter	Regular School	Yes	1.0	PK	08	2016	grade_2												59												59
281706	WI	Racine	school	5500045	8110	Non District Charter Schools	21st Century Preparatory School	550004502575	100	21st Century Preparatory School	charter	Regular School	Yes	1.0	PK	08	2016	grade_3												46												46
281707	WI	Racine	school	5500045	8110	Non District Charter Schools	21st Century Preparatory School	550004502575	100	21st Century Preparatory School	charter	Regular School	Yes	1.0	PK	08	2016	grade_4												45												45
281708	WI	Racine	school	5500045	8110	Non District Charter Schools	21st Century Preparatory School	550004502575	100	21st Century Preparatory School	charter	Regular School	Yes	1.0	PK	08	2016	grade_5												40												40
281709	WI	Racine	school	5500045	8110	Non District Charter Schools	21st Century Preparatory School	550004502575	100	21st Century Preparatory School	charter	Regular School	Yes	1.0	PK	08	2016	grade_6												58												58
281710	WI	Racine	school	5500045	8110	Non District Charter Schools	21st Century Preparatory School	550004502575	100	21st Century Preparatory School	charter	Regular School	Yes	1.0	PK	08	2016	grade_7												30												30
281711	WI	Racine	school	5500045	8110	Non District Charter Schools	21st Century Preparatory School	550004502575	100	21st Century Preparatory School	charter	Regular School	Yes	1.0	PK	08	2016	grade_8												25												25
281712	WI	Racine	school	5500045	8110	Non District Charter Schools	21st Century Preparatory School	550004502575	100	21st Century Preparatory School	charter	Regular School	Yes	1.0	PK	08	2016	kindergarten_4_year_old												41												41
281713	WI	Racine	school	5500045	8110	Non District Charter Schools	21st Century Preparatory School	550004502575	100	21st Century Preparatory School	charter	Regular School	Yes	1.0	PK	08	2016	kindergarten												51												51
288670	WI	Dane	school	5509510	3549	Public school	Middleton-Cross Plains Area	550951002818	800	21st Century eSchool	charter	Regular School	Yes	4.0	KG	12	2016	pk_12_total	44.0	1.0	6.0		1.0		4.0	28.0	28.0	14	9	56	44	1	6		1		4	28	28	14	9	56
288671	WI	Dane	school	5509510	3549	Public school	Middleton-Cross Plains Area	550951002818	800	21st Century eSchool	charter	Regular School	Yes	4.0	KG	12	2016	grade_10												6												6
288672	WI	Dane	school	5509510	3549	Public school	Middleton-Cross Plains Area	550951002818	800	21st Century eSchool	charter	Regular School	Yes	4.0	KG	12	2016	grade_11												4												4
288673	WI	Dane	school	5509510	3549	Public school	Middleton-Cross Plains Area	550951002818	800	21st Century eSchool	charter	Regular School	Yes	4.0	KG	12	2016	grade_12												21												21
288674	WI	Dane	school	5509510	3549	Public school	Middleton-Cross Plains Area	550951002818	800	21st Century eSchool	charter	Regular School	Yes	4.0	KG	12	2016	grade_2												2												2
288675	WI	Dane	school	5509510	3549	Public school	Middleton-Cross Plains Area	550951002818	800	21st Century eSchool	charter	Regular School	Yes	4.0	KG	12	2016	grade_3												3												3
288676	WI	Dane	school	5509510	3549	Public school	Middleton-Cross Plains Area	550951002818	800	21st Century eSchool	charter	Regular School	Yes	4.0	KG	12	2016	grade_4												2												2
288677	WI	Dane	school	5509510	3549	Public school	Middleton-Cross Plains Area	550951002818	800	21st Century eSchool	charter	Regular School	Yes	4.0	KG	12	2016	grade_5												4												4
288678	WI	Dane	school	5509510	3549	Public school	Middleton-Cross Plains Area	550951002818	800	21st Century eSchool	charter	Regular School	Yes	4.0	KG	12	2016	grade_6												3												3
288679	WI	Dane	school	5509510	3549	Public school	Middleton-Cross Plains Area	550951002818	800	21st Century eSchool	charter	Regular School	Yes	4.0	KG	12	2016	grade_7												5												5
288680	WI	Dane	school	5509510	3549	Public school	Middleton-Cross Plains Area	550951002818	800	21st Century eSchool	charter	Regular School	Yes	4.0	KG	12	2016	grade_8												3												3
288681	WI	Dane	school	5509510	3549	Public school	Middleton-Cross Plains Area	550951002818	800	21st Century eSchool	charter	Regular School	Yes	4.0	KG	12	2016	grade_9												3												3
287059	WI	Outagamie	school	5507470	2835	Public school	Kimberly Area	550747003029	150	4K Center for Literacy		Regular School	No	1.0	PK	PK	2016	pk_12_total	290.0	1.0	7.0	1.0	3.0		11.0	149.0	164.0	40	44	313	290	1	7	1	3		11	149	164	40	44	313
287060	WI	Outagamie	school	5507470	2835	Public school	Kimberly Area	550747003029	150	4K Center for Literacy		Regular School	No	1.0	PK	PK	2016	kindergarten_4_year_old												301												301
287061	WI	Outagamie	school	5507470	2835	Public school	Kimberly Area	550747003029	150	4K Center for Literacy		Regular School	No	1.0	PK	PK	2016	pre_kindergarten												12												12
283118	WI	Racine	school	5501890	777	Public school	Burlington Area	550189002987	150	4K Community School		Regular School	No	1.0	PK	PK	2016	pk_12_total	41.0	1.0	7.0				1.0	23.0	27.0	13	1	50	41	1	7				1	23	27	13	1	50
283119	WI	Racine	school	5501890	777	Public school	Burlington Area	550189002987	150	4K Community School		Regular School	No	1.0	PK	PK	2016	kindergarten_4_year_old												50												50
292596	WI	Sauk	school	5512660	4753	Public school	Reedsburg	551266002889	150	4K Community-Based		Regular School	No	1.0	PK	PK	2016	pk_12_total	85.0	1.0	8.0	1.0	3.0		3.0	51.0	50.0	50	12	101	85	1	8	1	3		3	51	50	50	12	101
292597	WI	Sauk	school	5512660	4753	Public school	Reedsburg	551266002889	150	4K Community-Based		Regular School	No	1.0	PK	PK	2016	kindergarten_4_year_old												101												101
288280	WI	Dane	school	5508910	3381	Public school	McFarland	550891002902	150	4K McFarland		Regular School	No	1.0	PK	PK	2016	pk_12_total	109.0		2.0		4.0		10.0	67.0	58.0	6	11	125	109		2		4		10	67	58	6	11	125
288281	WI	Dane	school	5508910	3381	Public school	McFarland	550891002902	150	4K McFarland		Regular School	No	1.0	PK	PK	2016	kindergarten_4_year_old												125												125
287615	WI	Dane	school	5508520	3269	Public school	Madison Metropolitan	550852002475	190	4K PK Off Site		Regular School	No	1.0	PK	PK	2016	pk_12_total	383.0	153.0	176.0		57.0		84.0	443.0	410.0	47	134	853	383	153	176		57		84	443	410	47	134	853
287616	WI	Dane	school	5508520	3269	Public school	Madison Metropolitan	550852002475	190	4K PK Off Site		Regular School	No	1.0	PK	PK	2016	kindergarten_4_year_old												766												766
287617	WI	Dane	school	5508520	3269	Public school	Madison Metropolitan	550852002475	190	4K PK Off Site		Regular School	No	1.0	PK	PK	2016	pre_kindergarten												87												87
287131	WI	La Crosse	school	5507530	2849	Public school	La Crosse	550753002950	440	7 Rivers Community High School	charter	Alternative Education School	Yes	4.0	09	11	2016	pk_12_total	24.0	1.0		1.0	3.0		2.0	12.0	19.0	17	4	31	24	1		1	3		2	12	19	17	4	31
287132	WI	La Crosse	school	5507530	2849	Public school	La Crosse	550753002950	440	7 Rivers Community High School	charter	Alternative Education School	Yes	4.0	09	11	2016	grade_10												11												11
287133	WI	La Crosse	school	5507530	2849	Public school	La Crosse	550753002950	440	7 Rivers Community High School	charter	Alternative Education School	Yes	4.0	09	11	2016	grade_11												9												9
287134	WI	La Crosse	school	5507530	2849	Public school	La Crosse	550753002950	440	7 Rivers Community High School	charter	Alternative Education School	Yes	4.0	09	11	2016	grade_9												11												11
295158	WI	Marathon	school	5515900	6223	Public school	Wausau	551590002455	10	A C Kiefer Educational Center		Regular School	No	1.0	PK	KG	2016	pk_12_total	258.0	17.0	23.0	3.0	47.0		9.0	196.0	161.0	79	91	357	258	17	23	3	47		9	196	161	79	91	357
295159	WI	Marathon	school	5515900	6223	Public school	Wausau	551590002455	10	A C Kiefer Educational Center		Regular School	No	1.0	PK	KG	2016	kindergarten_4_year_old												300												300
295160	WI	Marathon	school	5515900	6223	Public school	Wausau	551590002455	10	A C Kiefer Educational Center		Regular School	No	1.0	PK	KG	2016	pre_kindergarten												57												57
290643	WI	Winnebago	school	5510320	3892	Public school	Neenah Joint	551032003366	125	ACE Charter School	charter	Regular School	Yes	1.0	KG	05	2016	pk_12_total	103.0		4.0		6.0		3.0	74.0	42.0	11	7	116	103		4		6		3	74	42	11	7	116
290644	WI	Winnebago	school	5510320	3892	Public school	Neenah Joint	551032003366	125	ACE Charter School	charter	Regular School	Yes	1.0	KG	05	2016	grade_1												17												17
290645	WI	Winnebago	school	5510320	3892	Public school	Neenah Joint	551032003366	125	ACE Charter School	charter	Regular School	Yes	1.0	KG	05	2016	grade_2												21												21
290646	WI	Winnebago	school	5510320	3892	Public school	Neenah Joint	551032003366	125	ACE Charter School	charter	Regular School	Yes	1.0	KG	05	2016	grade_3												20												20
290647	WI	Winnebago	school	5510320	3892	Public school	Neenah Joint	551032003366	125	ACE Charter School	charter	Regular School	Yes	1.0	KG	05	2016	grade_4												19												19
290648	WI	Winnebago	school	5510320	3892	Public school	Neenah Joint	551032003366	125	ACE Charter School	charter	Regular School	Yes	1.0	KG	05	2016	grade_5												17												17
290649	WI	Winnebago	school	5510320	3892	Public school	Neenah Joint	551032003366	125	ACE Charter School	charter	Regular School	Yes	1.0	KG	05	2016	kindergarten												22												22
288791	WI	Milwaukee	school	5509600	3619	Public school	Milwaukee	550960003371	162	ALBA - Academia de Lenguaje y Bellas Artes	charter	Regular School	Yes	1.0	PK	05	2016	pk_12_total	4.0	3.0	440.0		1.0	1.0		232.0	217.0	24	75	449	4	3	440		1	1		232	217	24	75	449
288792	WI	Milwaukee	school	5509600	3619	Public school	Milwaukee	550960003371	162	ALBA - Academia de Lenguaje y Bellas Artes	charter	Regular School	Yes	1.0	PK	05	2016	grade_1												69												69
288793	WI	Milwaukee	school	5509600	3619	Public school	Milwaukee	550960003371	162	ALBA - Academia de Lenguaje y Bellas Artes	charter	Regular School	Yes	1.0	PK	05	2016	grade_2												51												51
288794	WI	Milwaukee	school	5509600	3619	Public school	Milwaukee	550960003371	162	ALBA - Academia de Lenguaje y Bellas Artes	charter	Regular School	Yes	1.0	PK	05	2016	grade_3												49												49
288795	WI	Milwaukee	school	5509600	3619	Public school	Milwaukee	550960003371	162	ALBA - Academia de Lenguaje y Bellas Artes	charter	Regular School	Yes	1.0	PK	05	2016	grade_4												37												37
288796	WI	Milwaukee	school	5509600	3619	Public school	Milwaukee	550960003371	162	ALBA - Academia de Lenguaje y Bellas Artes	charter	Regular School	Yes	1.0	PK	05	2016	grade_5												34												34
288797	WI	Milwaukee	school	5509600	3619	Public school	Milwaukee	550960003371	162	ALBA - Academia de Lenguaje y Bellas Artes	charter	Regular School	Yes	1.0	PK	05	2016	kindergarten_3_year_old												49												49
288798	WI	Milwaukee	school	5509600	3619	Public school	Milwaukee	550960003371	162	ALBA - Academia de Lenguaje y Bellas Artes	charter	Regular School	Yes	1.0	PK	05	2016	kindergarten_4_year_old												73												73
288799	WI	Milwaukee	school	5509600	3619	Public school	Milwaukee	550960003371	162	ALBA - Academia de Lenguaje y Bellas Artes	charter	Regular School	Yes	1.0	PK	05	2016	kindergarten												87												87
286330	WI	Rock	school	5507020	2695	Public school	Janesville	550702002991	860	ARISE Virtual Academy	charter	Regular School	Yes	4.0	KG	12	2016	pk_12_total	81.0	1.0	5.0	1.0	1.0		4.0	33.0	60.0	42	5	93	81	1	5	1	1		4	33	60	42	5	93
286331	WI	Rock	school	5507020	2695	Public school	Janesville	550702002991	860	ARISE Virtual Academy	charter	Regular School	Yes	4.0	KG	12	2016	grade_10												10												10
286332	WI	Rock	school	5507020	2695	Public school	Janesville	550702002991	860	ARISE Virtual Academy	charter	Regular School	Yes	4.0	KG	12	2016	grade_11												28												28
286333	WI	Rock	school	5507020	2695	Public school	Janesville	550702002991	860	ARISE Virtual Academy	charter	Regular School	Yes	4.0	KG	12	2016	grade_12												30												30
286334	WI	Rock	school	5507020	2695	Public school	Janesville	550702002991	860	ARISE Virtual Academy	charter	Regular School	Yes	4.0	KG	12	2016	grade_2												2												2
286335	WI	Rock	school	5507020	2695	Public school	Janesville	550702002991	860	ARISE Virtual Academy	charter	Regular School	Yes	4.0	KG	12	2016	grade_4												2												2
286336	WI	Rock	school	5507020	2695	Public school	Janesville	550702002991	860	ARISE Virtual Academy	charter	Regular School	Yes	4.0	KG	12	2016	grade_5												3												3
286337	WI	Rock	school	5507020	2695	Public school	Janesville	550702002991	860	ARISE Virtual Academy	charter	Regular School	Yes	4.0	KG	12	2016	grade_6												2												2
286338	WI	Rock	school	5507020	2695	Public school	Janesville	550702002991	860	ARISE Virtual Academy	charter	Regular School	Yes	4.0	KG	12	2016	grade_7												3												3
286339	WI	Rock	school	5507020	2695	Public school	Janesville	550702002991	860	ARISE Virtual Academy	charter	Regular School	Yes	4.0	KG	12	2016	grade_8												5												5
286340	WI	Rock	school	5507020	2695	Public school	Janesville	550702002991	860	ARISE Virtual Academy	charter	Regular School	Yes	4.0	KG	12	2016	grade_9												5												5
286341	WI	Rock	school	5507020	2695	Public school	Janesville	550702002991	860	ARISE Virtual Academy	charter	Regular School	Yes	4.0	KG	12	2016	kindergarten												3												3
288825	WI	Milwaukee	school	5509600	3619	Public school	Milwaukee	550960000792	1063	ASSATA		Alternative Education School	No	3.0	09	12	2016	pk_12_total	2.0	110.0	3.0				5.0	53.0	67.0	102	18	120	2	110	3				5	53	67	102	18	120
288826	WI	Milwaukee	school	5509600	3619	Public school	Milwaukee	550960000792	1063	ASSATA		Alternative Education School	No	3.0	09	12	2016	grade_10												36												36
288827	WI	Milwaukee	school	5509600	3619	Public school	Milwaukee	550960000792	1063	ASSATA		Alternative Education School	No	3.0	09	12	2016	grade_11												34												34
288828	WI	Milwaukee	school	5509600	3619	Public school	Milwaukee	550960000792	1063	ASSATA		Alternative Education School	No	3.0	09	12	2016	grade_12												16												16
288829	WI	Milwaukee	school	5509600	3619	Public school	Milwaukee	550960000792	1063	ASSATA		Alternative Education School	No	3.0	09	12	2016	grade_9												34												34
281714	WI	Clark	school	5500030	7	Public school	Abbotsford	550003000001	20	Abbotsford Elementary		Regular School	No	1.0	PK	05	2016	pk_12_total	182.0	5.0	187.0	1.0	1.0		1.0	198.0	179.0	256	36	377	182	5	187	1	1		1	198	179	256	36	377
281715	WI	Clark	school	5500030	7	Public school	Abbotsford	550003000001	20	Abbotsford Elementary		Regular School	No	1.0	PK	05	2016	grade_1												50												50
281716	WI	Clark	school	5500030	7	Public school	Abbotsford	550003000001	20	Abbotsford Elementary		Regular School	No	1.0	PK	05	2016	grade_2												49												49
281717	WI	Clark	school	5500030	7	Public school	Abbotsford	550003000001	20	Abbotsford Elementary		Regular School	No	1.0	PK	05	2016	grade_3												64												64
281718	WI	Clark	school	5500030	7	Public school	Abbotsford	550003000001	20	Abbotsford Elementary		Regular School	No	1.0	PK	05	2016	grade_4												54												54
281719	WI	Clark	school	5500030	7	Public school	Abbotsford	550003000001	20	Abbotsford Elementary		Regular School	No	1.0	PK	05	2016	grade_5												51												51
281720	WI	Clark	school	5500030	7	Public school	Abbotsford	550003000001	20	Abbotsford Elementary		Regular School	No	1.0	PK	05	2016	kindergarten_4_year_old												55												55
281721	WI	Clark	school	5500030	7	Public school	Abbotsford	550003000001	20	Abbotsford Elementary		Regular School	No	1.0	PK	05	2016	kindergarten												53												53
281722	WI	Clark	school	5500030	7	Public school	Abbotsford	550003000001	20	Abbotsford Elementary		Regular School	No	1.0	PK	05	2016	pre_kindergarten												1												1
281723	WI	Clark	school	5500030	7	Public school	Abbotsford	550003000002	40	Abbotsford Middle/Senior High		Regular School	No	4.0	06	12	2016	pk_12_total	203.0	5.0	121.0		3.0		4.0	176.0	160.0	197	34	336	203	5	121		3		4	176	160	197	34	336
281724	WI	Clark	school	5500030	7	Public school	Abbotsford	550003000002	40	Abbotsford Middle/Senior High		Regular School	No	4.0	06	12	2016	grade_10												47												47
281725	WI	Clark	school	5500030	7	Public school	Abbotsford	550003000002	40	Abbotsford Middle/Senior High		Regular School	No	4.0	06	12	2016	grade_11												43												43
281726	WI	Clark	school	5500030	7	Public school	Abbotsford	550003000002	40	Abbotsford Middle/Senior High		Regular School	No	4.0	06	12	2016	grade_12												51												51
281727	WI	Clark	school	5500030	7	Public school	Abbotsford	550003000002	40	Abbotsford Middle/Senior High		Regular School	No	4.0	06	12	2016	grade_6												49												49
281728	WI	Clark	school	5500030	7	Public school	Abbotsford	550003000002	40	Abbotsford Middle/Senior High		Regular School	No	4.0	06	12	2016	grade_7												50												50
281729	WI	Clark	school	5500030	7	Public school	Abbotsford	550003000002	40	Abbotsford Middle/Senior High		Regular School	No	4.0	06	12	2016	grade_8												41												41
281730	WI	Clark	school	5500030	7	Public school	Abbotsford	550003000002	40	Abbotsford Middle/Senior High		Regular School	No	4.0	06	12	2016	grade_9												55												55
290377	WI	Green	school	5509840	3682	Public school	Monroe	550984002771	10	Abraham Lincoln Elementary		Regular School	No	1.0	PK	05	2016	pk_12_total	344.0	5.0	33.0		1.0		6.0	207.0	182.0	179	56	389	344	5	33		1		6	207	182	179	56	389
290378	WI	Green	school	5509840	3682	Public school	Monroe	550984002771	10	Abraham Lincoln Elementary		Regular School	No	1.0	PK	05	2016	grade_1												38												38
290379	WI	Green	school	5509840	3682	Public school	Monroe	550984002771	10	Abraham Lincoln Elementary		Regular School	No	1.0	PK	05	2016	grade_2												43												43
290380	WI	Green	school	5509840	3682	Public school	Monroe	550984002771	10	Abraham Lincoln Elementary		Regular School	No	1.0	PK	05	2016	grade_3												39												39
290381	WI	Green	school	5509840	3682	Public school	Monroe	550984002771	10	Abraham Lincoln Elementary		Regular School	No	1.0	PK	05	2016	grade_4												42												42
290382	WI	Green	school	5509840	3682	Public school	Monroe	550984002771	10	Abraham Lincoln Elementary		Regular School	No	1.0	PK	05	2016	grade_5												41												41
290383	WI	Green	school	5509840	3682	Public school	Monroe	550984002771	10	Abraham Lincoln Elementary		Regular School	No	1.0	PK	05	2016	kindergarten_4_year_old												146												146
290384	WI	Green	school	5509840	3682	Public school	Monroe	550984002771	10	Abraham Lincoln Elementary		Regular School	No	1.0	PK	05	2016	kindergarten												40												40
291358	WI	Oconto	school	5510950	4074	Public school	Oconto Falls Public	551095001431	20	Abrams Elementary		Regular School	No	1.0	PK	05	2016	pk_12_total	254.0		9.0	1.0			5.0	144.0	125.0	63	33	269	254		9	1			5	144	125	63	33	269