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 (district > :p2 or (district = :p2 and rowid > :p1)) order by district, 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	ell	low_income	disability	total	white_int	black_int	hispanic_int	native_american_int	asian_int	multiracial_int	male_int	female_int	ell_int	low_income_int	disability_int	total_int
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
325608	WI	Clark	school	5500030	7	Public school	Abbotsford	550003000001	20	Abbotsford Elementary		Regular School	No	Elementary	PK	05	2017	pk_12_total	170.0	7.0	197.0	1.0		2.0	201.0	176.0		197	44	377	170	7	197	1		2	201	176		197	44	377
325609	WI	Clark	school	5500030	7	Public school	Abbotsford	550003000001	20	Abbotsford Elementary		Regular School	No	Elementary	PK	05	2017	grade_1												50												50
325610	WI	Clark	school	5500030	7	Public school	Abbotsford	550003000001	20	Abbotsford Elementary		Regular School	No	Elementary	PK	05	2017	grade_2												55												55
325611	WI	Clark	school	5500030	7	Public school	Abbotsford	550003000001	20	Abbotsford Elementary		Regular School	No	Elementary	PK	05	2017	grade_3												49												49
325612	WI	Clark	school	5500030	7	Public school	Abbotsford	550003000001	20	Abbotsford Elementary		Regular School	No	Elementary	PK	05	2017	grade_4												66												66
325613	WI	Clark	school	5500030	7	Public school	Abbotsford	550003000001	20	Abbotsford Elementary		Regular School	No	Elementary	PK	05	2017	grade_5												53												53
325614	WI	Clark	school	5500030	7	Public school	Abbotsford	550003000001	20	Abbotsford Elementary		Regular School	No	Elementary	PK	05	2017	kindergarten_4_year_old												43												43
325615	WI	Clark	school	5500030	7	Public school	Abbotsford	550003000001	20	Abbotsford Elementary		Regular School	No	Elementary	PK	05	2017	kindergarten												58												58
325616	WI	Clark	school	5500030	7	Public school	Abbotsford	550003000001	20	Abbotsford Elementary		Regular School	No	Elementary	PK	05	2017	pre_kindergarten												3												3
325617	WI	Clark	school	5500030	7	Public school	Abbotsford	550003000002	40	Abbotsford Middle/Senior High		Regular School	No	Other	06	12	2017	pk_12_total	192.0	5.0	142.0		3.0	3.0	171.0	174.0		220	37	345	192	5	142		3	3	171	174		220	37	345
325618	WI	Clark	school	5500030	7	Public school	Abbotsford	550003000002	40	Abbotsford Middle/Senior High		Regular School	No	Other	06	12	2017	grade_10												55												55
325619	WI	Clark	school	5500030	7	Public school	Abbotsford	550003000002	40	Abbotsford Middle/Senior High		Regular School	No	Other	06	12	2017	grade_11												52												52
325620	WI	Clark	school	5500030	7	Public school	Abbotsford	550003000002	40	Abbotsford Middle/Senior High		Regular School	No	Other	06	12	2017	grade_12												45												45
325621	WI	Clark	school	5500030	7	Public school	Abbotsford	550003000002	40	Abbotsford Middle/Senior High		Regular School	No	Other	06	12	2017	grade_6												55												55
325622	WI	Clark	school	5500030	7	Public school	Abbotsford	550003000002	40	Abbotsford Middle/Senior High		Regular School	No	Other	06	12	2017	grade_7												44												44
325623	WI	Clark	school	5500030	7	Public school	Abbotsford	550003000002	40	Abbotsford Middle/Senior High		Regular School	No	Other	06	12	2017	grade_8												53												53
325624	WI	Clark	school	5500030	7	Public school	Abbotsford	550003000002	40	Abbotsford Middle/Senior High		Regular School	No	Other	06	12	2017	grade_9												41												41
325625	WI	Clark	school		7	Public Schools-Multidistrict Charters	Abbotsford		9100	Rural Virtual Academy	charter						2017	pk_12_total	1.0							1.0		*	*	1	1							1				1
325626	WI	Clark	school		7	Public Schools-Multidistrict Charters	Abbotsford		9100	Rural Virtual Academy	charter						2017	grade_4												1												1
2318131	WI	Clark	school	5500030	7	Public school	Abbotsford	550003000001	20	Abbotsford Elementary		Regular School	No	Elementary	PK	05	2020	pk_12_total	139.0	3.0	217.0		1.0	3.0	195.0	168.0		285	51	363	139	3	217		1	3	195	168		285	51	363
2318132	WI	Clark	school	5500030	7	Public school	Abbotsford	550003000001	20	Abbotsford Elementary		Regular School	No	Elementary	PK	05	2020	grade_1												55												55
2318133	WI	Clark	school	5500030	7	Public school	Abbotsford	550003000001	20	Abbotsford Elementary		Regular School	No	Elementary	PK	05	2020	grade_2												58												58
2318134	WI	Clark	school	5500030	7	Public school	Abbotsford	550003000001	20	Abbotsford Elementary		Regular School	No	Elementary	PK	05	2020	grade_3												55												55
2318135	WI	Clark	school	5500030	7	Public school	Abbotsford	550003000001	20	Abbotsford Elementary		Regular School	No	Elementary	PK	05	2020	grade_4												50												50
2318136	WI	Clark	school	5500030	7	Public school	Abbotsford	550003000001	20	Abbotsford Elementary		Regular School	No	Elementary	PK	05	2020	grade_5												58												58
2318137	WI	Clark	school	5500030	7	Public school	Abbotsford	550003000001	20	Abbotsford Elementary		Regular School	No	Elementary	PK	05	2020	kindergarten_4_year_old												46												46
2318138	WI	Clark	school	5500030	7	Public school	Abbotsford	550003000001	20	Abbotsford Elementary		Regular School	No	Elementary	PK	05	2020	kindergarten												40												40
2318139	WI	Clark	school	5500030	7	Public school	Abbotsford	550003000001	20	Abbotsford Elementary		Regular School	No	Elementary	PK	05	2020	pre_kindergarten												1												1
2318140	WI	Clark	school	5500030	7	Public school	Abbotsford	550003000002	40	Abbotsford Middle/Senior High		Regular School	No	High	06	12	2020	pk_12_total	186.0	4.0	189.0		1.0	2.0	194.0	188.0		246	49	382	186	4	189		1	2	194	188		246	49	382
2318141	WI	Clark	school	5500030	7	Public school	Abbotsford	550003000002	40	Abbotsford Middle/Senior High		Regular School	No	High	06	12	2020	grade_10												49												49
2318142	WI	Clark	school	5500030	7	Public school	Abbotsford	550003000002	40	Abbotsford Middle/Senior High		Regular School	No	High	06	12	2020	grade_11												50												50
2318143	WI	Clark	school	5500030	7	Public school	Abbotsford	550003000002	40	Abbotsford Middle/Senior High		Regular School	No	High	06	12	2020	grade_12												44												44
2318144	WI	Clark	school	5500030	7	Public school	Abbotsford	550003000002	40	Abbotsford Middle/Senior High		Regular School	No	High	06	12	2020	grade_6												54												54
2318145	WI	Clark	school	5500030	7	Public school	Abbotsford	550003000002	40	Abbotsford Middle/Senior High		Regular School	No	High	06	12	2020	grade_7												67												67
2318146	WI	Clark	school	5500030	7	Public school	Abbotsford	550003000002	40	Abbotsford Middle/Senior High		Regular School	No	High	06	12	2020	grade_8												59												59
2318147	WI	Clark	school	5500030	7	Public school	Abbotsford	550003000002	40	Abbotsford Middle/Senior High		Regular School	No	High	06	12	2020	grade_9												59												59
2318148	WI	Clark	school		7	Public Schools-Multidistrict Charters	Abbotsford		9100	Rural Virtual Academy	charter						2020	pk_12_total	2.0						1.0	1.0		*	*	2	2						1	1				2
2318149	WI	Clark	school		7	Public Schools-Multidistrict Charters	Abbotsford		9100	Rural Virtual Academy	charter						2020	grade_8												1												1
2318150	WI	Clark	school		7	Public Schools-Multidistrict Charters	Abbotsford		9100	Rural Virtual Academy	charter						2020	kindergarten_4_year_old												1												1
2332937	WI	Clark	school	5500030	7	Public school	Abbotsford	550003000001	20	Abbotsford Elementary		Regular School	No	Elementary	PK	05	2021	pk_12_total	115.0	4.0	230.0		1.0	4.0	179.0	175.0	186.0	268	56	354	115	4	230		1	4	179	175	186	268	56	354
2332938	WI	Clark	school	5500030	7	Public school	Abbotsford	550003000001	20	Abbotsford Elementary		Regular School	No	Elementary	PK	05	2021	grade_1												42												42
2332939	WI	Clark	school	5500030	7	Public school	Abbotsford	550003000001	20	Abbotsford Elementary		Regular School	No	Elementary	PK	05	2021	grade_2												59												59
2332940	WI	Clark	school	5500030	7	Public school	Abbotsford	550003000001	20	Abbotsford Elementary		Regular School	No	Elementary	PK	05	2021	grade_3												60												60
2332941	WI	Clark	school	5500030	7	Public school	Abbotsford	550003000001	20	Abbotsford Elementary		Regular School	No	Elementary	PK	05	2021	grade_4												53												53
2332942	WI	Clark	school	5500030	7	Public school	Abbotsford	550003000001	20	Abbotsford Elementary		Regular School	No	Elementary	PK	05	2021	grade_5												50												50
2332943	WI	Clark	school	5500030	7	Public school	Abbotsford	550003000001	20	Abbotsford Elementary		Regular School	No	Elementary	PK	05	2021	kindergarten_4_year_old												37												37
2332944	WI	Clark	school	5500030	7	Public school	Abbotsford	550003000001	20	Abbotsford Elementary		Regular School	No	Elementary	PK	05	2021	kindergarten												50												50
2332945	WI	Clark	school	5500030	7	Public school	Abbotsford	550003000001	20	Abbotsford Elementary		Regular School	No	Elementary	PK	05	2021	pre_kindergarten												3												3
2332946	WI	Clark	school	5500030	7	Public school	Abbotsford	550003000002	40	Abbotsford Middle/Senior High		Regular School	No	High	06	12	2021	pk_12_total	190.0	6.0	206.0			4.0	213.0	193.0	119.0	250	62	406	190	6	206			4	213	193	119	250	62	406
2332947	WI	Clark	school	5500030	7	Public school	Abbotsford	550003000002	40	Abbotsford Middle/Senior High		Regular School	No	High	06	12	2021	grade_10												57												57
2332948	WI	Clark	school	5500030	7	Public school	Abbotsford	550003000002	40	Abbotsford Middle/Senior High		Regular School	No	High	06	12	2021	grade_11												49												49
2332949	WI	Clark	school	5500030	7	Public school	Abbotsford	550003000002	40	Abbotsford Middle/Senior High		Regular School	No	High	06	12	2021	grade_12												54												54
2332950	WI	Clark	school	5500030	7	Public school	Abbotsford	550003000002	40	Abbotsford Middle/Senior High		Regular School	No	High	06	12	2021	grade_6												61												61
2332951	WI	Clark	school	5500030	7	Public school	Abbotsford	550003000002	40	Abbotsford Middle/Senior High		Regular School	No	High	06	12	2021	grade_7												54												54
2332952	WI	Clark	school	5500030	7	Public school	Abbotsford	550003000002	40	Abbotsford Middle/Senior High		Regular School	No	High	06	12	2021	grade_8												70												70
2332953	WI	Clark	school	5500030	7	Public school	Abbotsford	550003000002	40	Abbotsford Middle/Senior High		Regular School	No	High	06	12	2021	grade_9												61												61
2332954	WI	Clark	school		7	Public Schools-Multidistrict Charters	Abbotsford		9100	Rural Virtual Academy	charter						2021	pk_12_total												0												0
3073899	WI	Clark	school	5500030	7	Public school	Abbotsford	550003000001	20	Abbotsford Elementary		Regular School	No	Elementary	PK	05	2019	pk_12_total	155.0	4.0	206.0		1.0	3.0	199.0	170.0		280	57	369	155	4	206		1	3	199	170		280	57	369
3073900	WI	Clark	school	5500030	7	Public school	Abbotsford	550003000001	20	Abbotsford Elementary		Regular School	No	Elementary	PK	05	2019	grade_1												55												55
3073901	WI	Clark	school	5500030	7	Public school	Abbotsford	550003000001	20	Abbotsford Elementary		Regular School	No	Elementary	PK	05	2019	grade_2												60												60
3073902	WI	Clark	school	5500030	7	Public school	Abbotsford	550003000001	20	Abbotsford Elementary		Regular School	No	Elementary	PK	05	2019	grade_3												54												54
3073903	WI	Clark	school	5500030	7	Public school	Abbotsford	550003000001	20	Abbotsford Elementary		Regular School	No	Elementary	PK	05	2019	grade_4												57												57
3073904	WI	Clark	school	5500030	7	Public school	Abbotsford	550003000001	20	Abbotsford Elementary		Regular School	No	Elementary	PK	05	2019	grade_5												53												53
3073905	WI	Clark	school	5500030	7	Public school	Abbotsford	550003000001	20	Abbotsford Elementary		Regular School	No	Elementary	PK	05	2019	kindergarten_4_year_old												34												34
3073906	WI	Clark	school	5500030	7	Public school	Abbotsford	550003000001	20	Abbotsford Elementary		Regular School	No	Elementary	PK	05	2019	kindergarten												54												54
3073907	WI	Clark	school	5500030	7	Public school	Abbotsford	550003000001	20	Abbotsford Elementary		Regular School	No	Elementary	PK	05	2019	pre_kindergarten												2												2
3073908	WI	Clark	school	5500030	7	Public school	Abbotsford	550003000002	40	Abbotsford Middle/Senior High		Regular School	No	High	06	12	2019	pk_12_total	200.0	7.0	181.0		1.0	2.0	197.0	194.0		275	42	391	200	7	181		1	2	197	194		275	42	391
3073909	WI	Clark	school	5500030	7	Public school	Abbotsford	550003000002	40	Abbotsford Middle/Senior High		Regular School	No	High	06	12	2019	grade_10												54												54
3073910	WI	Clark	school	5500030	7	Public school	Abbotsford	550003000002	40	Abbotsford Middle/Senior High		Regular School	No	High	06	12	2019	grade_11												47												47
3073911	WI	Clark	school	5500030	7	Public school	Abbotsford	550003000002	40	Abbotsford Middle/Senior High		Regular School	No	High	06	12	2019	grade_12												60												60
3073912	WI	Clark	school	5500030	7	Public school	Abbotsford	550003000002	40	Abbotsford Middle/Senior High		Regular School	No	High	06	12	2019	grade_6												68												68
3073913	WI	Clark	school	5500030	7	Public school	Abbotsford	550003000002	40	Abbotsford Middle/Senior High		Regular School	No	High	06	12	2019	grade_7												55												55
3073914	WI	Clark	school	5500030	7	Public school	Abbotsford	550003000002	40	Abbotsford Middle/Senior High		Regular School	No	High	06	12	2019	grade_8												57												57
3073915	WI	Clark	school	5500030	7	Public school	Abbotsford	550003000002	40	Abbotsford Middle/Senior High		Regular School	No	High	06	12	2019	grade_9												50												50
3073916	WI	Clark	school		7	Public Schools-Multidistrict Charters	Abbotsford		9100	Rural Virtual Academy	charter						2019	pk_12_total	3.0					1.0	1.0	3.0		*	*	4	3					1	1	3				4
3073917	WI	Clark	school		7	Public Schools-Multidistrict Charters	Abbotsford		9100	Rural Virtual Academy	charter						2019	grade_10												1												1
3073918	WI	Clark	school		7	Public Schools-Multidistrict Charters	Abbotsford		9100	Rural Virtual Academy	charter						2019	grade_11												1												1
3073919	WI	Clark	school		7	Public Schools-Multidistrict Charters	Abbotsford		9100	Rural Virtual Academy	charter						2019	grade_12												1												1
3073920	WI	Clark	school		7	Public Schools-Multidistrict Charters	Abbotsford		9100	Rural Virtual Academy	charter						2019	grade_7												1												1
3088648	WI	Clark	school	5500030	7	Public school	Abbotsford	550003000001	20	Abbotsford Elementary		Regular School	No	Elementary	PK	05	2018	pk_12_total	162.0	3.0	209.0		1.0	2.0	204.0	173.0		275	51	377	162	3	209		1	2	204	173		275	51	377
3088649	WI	Clark	school	5500030	7	Public school	Abbotsford	550003000001	20	Abbotsford Elementary		Regular School	No	Elementary	PK	05	2018	grade_1												58												58
3088650	WI	Clark	school	5500030	7	Public school	Abbotsford	550003000001	20	Abbotsford Elementary		Regular School	No	Elementary	PK	05	2018	grade_2												54												54
3088651	WI	Clark	school	5500030	7	Public school	Abbotsford	550003000001	20	Abbotsford Elementary		Regular School	No	Elementary	PK	05	2018	grade_3												53												53
3088652	WI	Clark	school	5500030	7	Public school	Abbotsford	550003000001	20	Abbotsford Elementary		Regular School	No	Elementary	PK	05	2018	grade_4												52												52
3088653	WI	Clark	school	5500030	7	Public school	Abbotsford	550003000001	20	Abbotsford Elementary		Regular School	No	Elementary	PK	05	2018	grade_5												65												65
3088654	WI	Clark	school	5500030	7	Public school	Abbotsford	550003000001	20	Abbotsford Elementary		Regular School	No	Elementary	PK	05	2018	kindergarten_4_year_old												42												42
3088655	WI	Clark	school	5500030	7	Public school	Abbotsford	550003000001	20	Abbotsford Elementary		Regular School	No	Elementary	PK	05	2018	kindergarten												51												51
3088656	WI	Clark	school	5500030	7	Public school	Abbotsford	550003000001	20	Abbotsford Elementary		Regular School	No	Elementary	PK	05	2018	pre_kindergarten												2												2
3088657	WI	Clark	school	5500030	7	Public school	Abbotsford	550003000002	40	Abbotsford Middle/Senior High		Regular School	No	High	06	12	2018	pk_12_total	206.0	4.0	154.0		2.0	4.0	191.0	179.0		237	46	370	206	4	154		2	4	191	179		237	46	370
3088658	WI	Clark	school	5500030	7	Public school	Abbotsford	550003000002	40	Abbotsford Middle/Senior High		Regular School	No	High	06	12	2018	grade_10												44												44
3088659	WI	Clark	school	5500030	7	Public school	Abbotsford	550003000002	40	Abbotsford Middle/Senior High		Regular School	No	High	06	12	2018	grade_11												58												58