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 order by district_state_id desc 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	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
113339	WI	Grant	school	5502400	994	Public school	Cassville	550240000264	20	Cassville Elementary	Regular School	No	1.0	PK	06	2015	pk_12_total	86.0							46.0	40.0	54	11	86	86							46	40	54	11	86
113340	WI	Grant	school	5502400	994	Public school	Cassville	550240000264	20	Cassville Elementary	Regular School	No	1.0	PK	06	2015	grade_1												10												10
113341	WI	Grant	school	5502400	994	Public school	Cassville	550240000264	20	Cassville Elementary	Regular School	No	1.0	PK	06	2015	grade_2												7												7
113342	WI	Grant	school	5502400	994	Public school	Cassville	550240000264	20	Cassville Elementary	Regular School	No	1.0	PK	06	2015	grade_3												10												10
113343	WI	Grant	school	5502400	994	Public school	Cassville	550240000264	20	Cassville Elementary	Regular School	No	1.0	PK	06	2015	grade_4												14												14
113344	WI	Grant	school	5502400	994	Public school	Cassville	550240000264	20	Cassville Elementary	Regular School	No	1.0	PK	06	2015	grade_5												12												12
113345	WI	Grant	school	5502400	994	Public school	Cassville	550240000264	20	Cassville Elementary	Regular School	No	1.0	PK	06	2015	grade_6												13												13
113346	WI	Grant	school	5502400	994	Public school	Cassville	550240000264	20	Cassville Elementary	Regular School	No	1.0	PK	06	2015	kindergarten_4_year_old												12												12
113347	WI	Grant	school	5502400	994	Public school	Cassville	550240000264	20	Cassville Elementary	Regular School	No	1.0	PK	06	2015	kindergarten												8												8
113348	WI	Grant	school	5502400	994	Public school	Cassville	550240000265	40	Cassville High	Regular School	No	3.0	07	12	2015	pk_12_total	106.0			1.0	4.0			63.0	48.0	38	7	111	106			1	4			63	48	38	7	111
113349	WI	Grant	school	5502400	994	Public school	Cassville	550240000265	40	Cassville High	Regular School	No	3.0	07	12	2015	grade_10												14												14
113350	WI	Grant	school	5502400	994	Public school	Cassville	550240000265	40	Cassville High	Regular School	No	3.0	07	12	2015	grade_11												28												28
113351	WI	Grant	school	5502400	994	Public school	Cassville	550240000265	40	Cassville High	Regular School	No	3.0	07	12	2015	grade_12												21												21
113352	WI	Grant	school	5502400	994	Public school	Cassville	550240000265	40	Cassville High	Regular School	No	3.0	07	12	2015	grade_7												19												19
113353	WI	Grant	school	5502400	994	Public school	Cassville	550240000265	40	Cassville High	Regular School	No	3.0	07	12	2015	grade_8												14												14
113354	WI	Grant	school	5502400	994	Public school	Cassville	550240000265	40	Cassville High	Regular School	No	3.0	07	12	2015	grade_9												15												15
283321	WI	Grant	school	5502400	994	Public school	Cassville	550240000264	20	Cassville Elementary	Regular School	No	1.0	PK	06	2016	pk_12_total	88.0						1.0	50.0	39.0	49	9	89	88						1	50	39	49	9	89
283322	WI	Grant	school	5502400	994	Public school	Cassville	550240000264	20	Cassville Elementary	Regular School	No	1.0	PK	06	2016	grade_1												10												10
283323	WI	Grant	school	5502400	994	Public school	Cassville	550240000264	20	Cassville Elementary	Regular School	No	1.0	PK	06	2016	grade_2												11												11
283324	WI	Grant	school	5502400	994	Public school	Cassville	550240000264	20	Cassville Elementary	Regular School	No	1.0	PK	06	2016	grade_3												8												8
283325	WI	Grant	school	5502400	994	Public school	Cassville	550240000264	20	Cassville Elementary	Regular School	No	1.0	PK	06	2016	grade_4												9												9
283326	WI	Grant	school	5502400	994	Public school	Cassville	550240000264	20	Cassville Elementary	Regular School	No	1.0	PK	06	2016	grade_5												14												14
283327	WI	Grant	school	5502400	994	Public school	Cassville	550240000264	20	Cassville Elementary	Regular School	No	1.0	PK	06	2016	grade_6												13												13
283328	WI	Grant	school	5502400	994	Public school	Cassville	550240000264	20	Cassville Elementary	Regular School	No	1.0	PK	06	2016	kindergarten_4_year_old												13												13
283329	WI	Grant	school	5502400	994	Public school	Cassville	550240000264	20	Cassville Elementary	Regular School	No	1.0	PK	06	2016	kindergarten												11												11
283330	WI	Grant	school	5502400	994	Public school	Cassville	550240000265	40	Cassville High	Regular School	No	3.0	07	12	2016	pk_12_total	107.0				1.0		2.0	56.0	54.0	38	8	110	107				1		2	56	54	38	8	110
283331	WI	Grant	school	5502400	994	Public school	Cassville	550240000265	40	Cassville High	Regular School	No	3.0	07	12	2016	grade_10												16												16
283332	WI	Grant	school	5502400	994	Public school	Cassville	550240000265	40	Cassville High	Regular School	No	3.0	07	12	2016	grade_11												12												12
283333	WI	Grant	school	5502400	994	Public school	Cassville	550240000265	40	Cassville High	Regular School	No	3.0	07	12	2016	grade_12												30												30
283334	WI	Grant	school	5502400	994	Public school	Cassville	550240000265	40	Cassville High	Regular School	No	3.0	07	12	2016	grade_7												15												15
283335	WI	Grant	school	5502400	994	Public school	Cassville	550240000265	40	Cassville High	Regular School	No	3.0	07	12	2016	grade_8												20												20
283336	WI	Grant	school	5502400	994	Public school	Cassville	550240000265	40	Cassville High	Regular School	No	3.0	07	12	2016	grade_9												17												17
327216	WI	Grant	school	5502400	994	Public school	Cassville	550240000264	20	Cassville Elementary	Regular School	No	Elementary	PK	06	2017	pk_12_total	96.0							51.0	45.0	54	10	96	96							51	45	54	10	96
327217	WI	Grant	school	5502400	994	Public school	Cassville	550240000264	20	Cassville Elementary	Regular School	No	Elementary	PK	06	2017	grade_1												12												12
327218	WI	Grant	school	5502400	994	Public school	Cassville	550240000264	20	Cassville Elementary	Regular School	No	Elementary	PK	06	2017	grade_2												11												11
327219	WI	Grant	school	5502400	994	Public school	Cassville	550240000264	20	Cassville Elementary	Regular School	No	Elementary	PK	06	2017	grade_3												13												13
327220	WI	Grant	school	5502400	994	Public school	Cassville	550240000264	20	Cassville Elementary	Regular School	No	Elementary	PK	06	2017	grade_4												11												11
327221	WI	Grant	school	5502400	994	Public school	Cassville	550240000264	20	Cassville Elementary	Regular School	No	Elementary	PK	06	2017	grade_5												11												11
327222	WI	Grant	school	5502400	994	Public school	Cassville	550240000264	20	Cassville Elementary	Regular School	No	Elementary	PK	06	2017	grade_6												14												14
327223	WI	Grant	school	5502400	994	Public school	Cassville	550240000264	20	Cassville Elementary	Regular School	No	Elementary	PK	06	2017	kindergarten_4_year_old												10												10
327224	WI	Grant	school	5502400	994	Public school	Cassville	550240000264	20	Cassville Elementary	Regular School	No	Elementary	PK	06	2017	kindergarten												12												12
327225	WI	Grant	school	5502400	994	Public school	Cassville	550240000264	20	Cassville Elementary	Regular School	No	Elementary	PK	06	2017	pre_kindergarten												2												2
327226	WI	Grant	school	5502400	994	Public school	Cassville	550240000265	40	Cassville High	Regular School	No	High	07	12	2017	pk_12_total	93.0							44.0	49.0	40	9	93	93							44	49	40	9	93
327227	WI	Grant	school	5502400	994	Public school	Cassville	550240000265	40	Cassville High	Regular School	No	High	07	12	2017	grade_10												17												17
327228	WI	Grant	school	5502400	994	Public school	Cassville	550240000265	40	Cassville High	Regular School	No	High	07	12	2017	grade_11												16												16
327229	WI	Grant	school	5502400	994	Public school	Cassville	550240000265	40	Cassville High	Regular School	No	High	07	12	2017	grade_12												13												13
327230	WI	Grant	school	5502400	994	Public school	Cassville	550240000265	40	Cassville High	Regular School	No	High	07	12	2017	grade_7												12												12
327231	WI	Grant	school	5502400	994	Public school	Cassville	550240000265	40	Cassville High	Regular School	No	High	07	12	2017	grade_8												14												14
327232	WI	Grant	school	5502400	994	Public school	Cassville	550240000265	40	Cassville High	Regular School	No	High	07	12	2017	grade_9												21												21
3090273	WI	Grant	school	5502400	994	Public school	Cassville	550240000264	20	Cassville Elementary	Regular School	No	Elementary	PK	06	2018	pk_12_total	105.0							50.0	55.0	46	17	105	105							50	55	46	17	105
3090274	WI	Grant	school	5502400	994	Public school	Cassville	550240000264	20	Cassville Elementary	Regular School	No	Elementary	PK	06	2018	grade_1												12												12
3090275	WI	Grant	school	5502400	994	Public school	Cassville	550240000264	20	Cassville Elementary	Regular School	No	Elementary	PK	06	2018	grade_2												13												13
3090276	WI	Grant	school	5502400	994	Public school	Cassville	550240000264	20	Cassville Elementary	Regular School	No	Elementary	PK	06	2018	grade_3												16												16
3090277	WI	Grant	school	5502400	994	Public school	Cassville	550240000264	20	Cassville Elementary	Regular School	No	Elementary	PK	06	2018	grade_4												12												12
3090278	WI	Grant	school	5502400	994	Public school	Cassville	550240000264	20	Cassville Elementary	Regular School	No	Elementary	PK	06	2018	grade_5												13												13
3090279	WI	Grant	school	5502400	994	Public school	Cassville	550240000264	20	Cassville Elementary	Regular School	No	Elementary	PK	06	2018	grade_6												13												13
3090280	WI	Grant	school	5502400	994	Public school	Cassville	550240000264	20	Cassville Elementary	Regular School	No	Elementary	PK	06	2018	kindergarten_4_year_old												16												16
3090281	WI	Grant	school	5502400	994	Public school	Cassville	550240000264	20	Cassville Elementary	Regular School	No	Elementary	PK	06	2018	kindergarten												8												8
3090282	WI	Grant	school	5502400	994	Public school	Cassville	550240000264	20	Cassville Elementary	Regular School	No	Elementary	PK	06	2018	pre_kindergarten												2												2
3090283	WI	Grant	school	5502400	994	Public school	Cassville	550240000265	40	Cassville High	Regular School	No	High	07	12	2018	pk_12_total	97.0	1.0			1.0			50.0	49.0	40	11	99	97	1			1			50	49	40	11	99
3090284	WI	Grant	school	5502400	994	Public school	Cassville	550240000265	40	Cassville High	Regular School	No	High	07	12	2018	grade_10												23												23
3090285	WI	Grant	school	5502400	994	Public school	Cassville	550240000265	40	Cassville High	Regular School	No	High	07	12	2018	grade_11												17												17
3090286	WI	Grant	school	5502400	994	Public school	Cassville	550240000265	40	Cassville High	Regular School	No	High	07	12	2018	grade_12												16												16
3090287	WI	Grant	school	5502400	994	Public school	Cassville	550240000265	40	Cassville High	Regular School	No	High	07	12	2018	grade_7												13												13
3090288	WI	Grant	school	5502400	994	Public school	Cassville	550240000265	40	Cassville High	Regular School	No	High	07	12	2018	grade_8												13												13
3090289	WI	Grant	school	5502400	994	Public school	Cassville	550240000265	40	Cassville High	Regular School	No	High	07	12	2018	grade_9												17												17
3075523	WI	Grant	school	5502400	994	Public school	Cassville	550240000264	20	Cassville Elementary	Regular School	No	Elementary	PK	06	2019	pk_12_total	95.0							43.0	52.0	57	17	95	95							43	52	57	17	95
3075524	WI	Grant	school	5502400	994	Public school	Cassville	550240000264	20	Cassville Elementary	Regular School	No	Elementary	PK	06	2019	grade_1												9												9
3075525	WI	Grant	school	5502400	994	Public school	Cassville	550240000264	20	Cassville Elementary	Regular School	No	Elementary	PK	06	2019	grade_2												11												11
3075526	WI	Grant	school	5502400	994	Public school	Cassville	550240000264	20	Cassville Elementary	Regular School	No	Elementary	PK	06	2019	grade_3												12												12
3075527	WI	Grant	school	5502400	994	Public school	Cassville	550240000264	20	Cassville Elementary	Regular School	No	Elementary	PK	06	2019	grade_4												14												14
3075528	WI	Grant	school	5502400	994	Public school	Cassville	550240000264	20	Cassville Elementary	Regular School	No	Elementary	PK	06	2019	grade_5												11												11
3075529	WI	Grant	school	5502400	994	Public school	Cassville	550240000264	20	Cassville Elementary	Regular School	No	Elementary	PK	06	2019	grade_6												12												12
3075530	WI	Grant	school	5502400	994	Public school	Cassville	550240000264	20	Cassville Elementary	Regular School	No	Elementary	PK	06	2019	kindergarten_4_year_old												11												11
3075531	WI	Grant	school	5502400	994	Public school	Cassville	550240000264	20	Cassville Elementary	Regular School	No	Elementary	PK	06	2019	kindergarten												14												14
3075532	WI	Grant	school	5502400	994	Public school	Cassville	550240000264	20	Cassville Elementary	Regular School	No	Elementary	PK	06	2019	pre_kindergarten												1												1
3075533	WI	Grant	school	5502400	994	Public school	Cassville	550240000265	40	Cassville High	Regular School	No	High	07	12	2019	pk_12_total	98.0	1.0			1.0			52.0	48.0	57	12	100	98	1			1			52	48	57	12	100
3075534	WI	Grant	school	5502400	994	Public school	Cassville	550240000265	40	Cassville High	Regular School	No	High	07	12	2019	grade_10												17												17
3075535	WI	Grant	school	5502400	994	Public school	Cassville	550240000265	40	Cassville High	Regular School	No	High	07	12	2019	grade_11												20												20
3075536	WI	Grant	school	5502400	994	Public school	Cassville	550240000265	40	Cassville High	Regular School	No	High	07	12	2019	grade_12												20												20
3075537	WI	Grant	school	5502400	994	Public school	Cassville	550240000265	40	Cassville High	Regular School	No	High	07	12	2019	grade_7												11												11
3075538	WI	Grant	school	5502400	994	Public school	Cassville	550240000265	40	Cassville High	Regular School	No	High	07	12	2019	grade_8												13												13
3075539	WI	Grant	school	5502400	994	Public school	Cassville	550240000265	40	Cassville High	Regular School	No	High	07	12	2019	grade_9												19												19
2319745	WI	Grant	school	5502400	994	Public school	Cassville	550240000264	20	Cassville Elementary	Regular School	No	Elementary	PK	06	2020	pk_12_total	98.0							46.0	52.0	55	17	98	98							46	52	55	17	98
2319746	WI	Grant	school	5502400	994	Public school	Cassville	550240000264	20	Cassville Elementary	Regular School	No	Elementary	PK	06	2020	grade_1												11												11
2319747	WI	Grant	school	5502400	994	Public school	Cassville	550240000264	20	Cassville Elementary	Regular School	No	Elementary	PK	06	2020	grade_2												9												9
2319748	WI	Grant	school	5502400	994	Public school	Cassville	550240000264	20	Cassville Elementary	Regular School	No	Elementary	PK	06	2020	grade_3												11												11
2319749	WI	Grant	school	5502400	994	Public school	Cassville	550240000264	20	Cassville Elementary	Regular School	No	Elementary	PK	06	2020	grade_4												13												13
2319750	WI	Grant	school	5502400	994	Public school	Cassville	550240000264	20	Cassville Elementary	Regular School	No	Elementary	PK	06	2020	grade_5												14												14
2319751	WI	Grant	school	5502400	994	Public school	Cassville	550240000264	20	Cassville Elementary	Regular School	No	Elementary	PK	06	2020	grade_6												12												12
2319752	WI	Grant	school	5502400	994	Public school	Cassville	550240000264	20	Cassville Elementary	Regular School	No	Elementary	PK	06	2020	kindergarten_4_year_old												16												16
2319753	WI	Grant	school	5502400	994	Public school	Cassville	550240000264	20	Cassville Elementary	Regular School	No	Elementary	PK	06	2020	kindergarten												12												12
2319754	WI	Grant	school	5502400	994	Public school	Cassville	550240000265	40	Cassville High	Regular School	No	High	07	12	2020	pk_12_total	97.0	2.0	2.0	1.0	1.0		3.0	55.0	51.0	66	16	106	97	2	2	1	1		3	55	51	66	16	106
2319755	WI	Grant	school	5502400	994	Public school	Cassville	550240000265	40	Cassville High	Regular School	No	High	07	12	2020	grade_10												19												19
2319756	WI	Grant	school	5502400	994	Public school	Cassville	550240000265	40	Cassville High	Regular School	No	High	07	12	2020	grade_11												19												19
2319757	WI	Grant	school	5502400	994	Public school	Cassville	550240000265	40	Cassville High	Regular School	No	High	07	12	2020	grade_12												24												24
2319758	WI	Grant	school	5502400	994	Public school	Cassville	550240000265	40	Cassville High	Regular School	No	High	07	12	2020	grade_7												14												14
2319759	WI	Grant	school	5502400	994	Public school	Cassville	550240000265	40	Cassville High	Regular School	No	High	07	12	2020	grade_8												14												14
2319760	WI	Grant	school	5502400	994	Public school	Cassville	550240000265	40	Cassville High	Regular School	No	High	07	12	2020	grade_9												16												16
2334527	WI	Grant	school	5502400	994	Public school	Cassville	550240000264	20	Cassville Elementary	Regular School	No	Elementary	PK	06	2021	pk_12_total	96.0					2.0		48.0	50.0	62	16	98	96					2		48	50	62	16	98
2334528	WI	Grant	school	5502400	994	Public school	Cassville	550240000264	20	Cassville Elementary	Regular School	No	Elementary	PK	06	2021	grade_1												10												10