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 native_hawaiian_pacific_islander_int 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
3073888	WI	Racine	school	5500045	8110	Non District Charter Schools	21st Century Preparatory School	550004502575	100	21st Century Preparatory School	charter	Regular School	Yes	Elementary	PK	08	2019	pk_12_total	58.0	272.0	169.0				44.0	250.0	293.0	443	61	543	58	272	169				44	250	293	443	61	543
3073889	WI	Racine	school	5500045	8110	Non District Charter Schools	21st Century Preparatory School	550004502575	100	21st Century Preparatory School	charter	Regular School	Yes	Elementary	PK	08	2019	grade_1												59												59
3073890	WI	Racine	school	5500045	8110	Non District Charter Schools	21st Century Preparatory School	550004502575	100	21st Century Preparatory School	charter	Regular School	Yes	Elementary	PK	08	2019	grade_2												60												60
3073891	WI	Racine	school	5500045	8110	Non District Charter Schools	21st Century Preparatory School	550004502575	100	21st Century Preparatory School	charter	Regular School	Yes	Elementary	PK	08	2019	grade_3												58												58
3073892	WI	Racine	school	5500045	8110	Non District Charter Schools	21st Century Preparatory School	550004502575	100	21st Century Preparatory School	charter	Regular School	Yes	Elementary	PK	08	2019	grade_4												55												55
3073893	WI	Racine	school	5500045	8110	Non District Charter Schools	21st Century Preparatory School	550004502575	100	21st Century Preparatory School	charter	Regular School	Yes	Elementary	PK	08	2019	grade_5												58												58
3073894	WI	Racine	school	5500045	8110	Non District Charter Schools	21st Century Preparatory School	550004502575	100	21st Century Preparatory School	charter	Regular School	Yes	Elementary	PK	08	2019	grade_6												51												51
3073895	WI	Racine	school	5500045	8110	Non District Charter Schools	21st Century Preparatory School	550004502575	100	21st Century Preparatory School	charter	Regular School	Yes	Elementary	PK	08	2019	grade_7												60												60
3073896	WI	Racine	school	5500045	8110	Non District Charter Schools	21st Century Preparatory School	550004502575	100	21st Century Preparatory School	charter	Regular School	Yes	Elementary	PK	08	2019	grade_8												36												36
3073897	WI	Racine	school	5500045	8110	Non District Charter Schools	21st Century Preparatory School	550004502575	100	21st Century Preparatory School	charter	Regular School	Yes	Elementary	PK	08	2019	kindergarten_4_year_old												58												58
3073898	WI	Racine	school	5500045	8110	Non District Charter Schools	21st Century Preparatory School	550004502575	100	21st Century Preparatory School	charter	Regular School	Yes	Elementary	PK	08	2019	kindergarten												48												48
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
3073921	WI	Adams	school	5500060	14	Public school	Adams-Friendship Area	550006001433	130	Adams-Friendship Elementary		Regular School	No	Elementary	PK	04	2019	pk_12_total	397.0	7.0	36.0	1.0	1.0		14.0	204.0	252.0	314	111	456	397	7	36	1	1		14	204	252	314	111	456
3073922	WI	Adams	school	5500060	14	Public school	Adams-Friendship Area	550006001433	130	Adams-Friendship Elementary		Regular School	No	Elementary	PK	04	2019	grade_1												69												69
3073923	WI	Adams	school	5500060	14	Public school	Adams-Friendship Area	550006001433	130	Adams-Friendship Elementary		Regular School	No	Elementary	PK	04	2019	grade_2												61												61
3073924	WI	Adams	school	5500060	14	Public school	Adams-Friendship Area	550006001433	130	Adams-Friendship Elementary		Regular School	No	Elementary	PK	04	2019	grade_3												94												94
3073925	WI	Adams	school	5500060	14	Public school	Adams-Friendship Area	550006001433	130	Adams-Friendship Elementary		Regular School	No	Elementary	PK	04	2019	grade_4												76												76
3073926	WI	Adams	school	5500060	14	Public school	Adams-Friendship Area	550006001433	130	Adams-Friendship Elementary		Regular School	No	Elementary	PK	04	2019	kindergarten_4_year_old												73												73
3073927	WI	Adams	school	5500060	14	Public school	Adams-Friendship Area	550006001433	130	Adams-Friendship Elementary		Regular School	No	Elementary	PK	04	2019	kindergarten												73												73
3073928	WI	Adams	school	5500060	14	Public school	Adams-Friendship Area	550006001433	130	Adams-Friendship Elementary		Regular School	No	Elementary	PK	04	2019	pre_kindergarten												10												10
3073929	WI	Adams	school	5500060	14	Public school	Adams-Friendship Area	550006000005	40	Adams-Friendship High		Regular School	No	High	09	12	2019	pk_12_total	440.0	5.0	23.0	5.0	2.0	1.0	10.0	252.0	234.0	309	112	486	440	5	23	5	2	1	10	252	234	309	112	486
3073930	WI	Adams	school	5500060	14	Public school	Adams-Friendship Area	550006000005	40	Adams-Friendship High		Regular School	No	High	09	12	2019	grade_10												111												111
3073931	WI	Adams	school	5500060	14	Public school	Adams-Friendship Area	550006000005	40	Adams-Friendship High		Regular School	No	High	09	12	2019	grade_11												112												112
3073932	WI	Adams	school	5500060	14	Public school	Adams-Friendship Area	550006000005	40	Adams-Friendship High		Regular School	No	High	09	12	2019	grade_12												132												132
3073933	WI	Adams	school	5500060	14	Public school	Adams-Friendship Area	550006000005	40	Adams-Friendship High		Regular School	No	High	09	12	2019	grade_9												131												131
3073934	WI	Adams	school	5500060	14	Public school	Adams-Friendship Area	550006001454	210	Adams-Friendship Middle		Regular School	No	Middle	05	08	2019	pk_12_total	384.0	6.0	44.0	5.0	1.0		10.0	229.0	221.0	302	103	450	384	6	44	5	1		10	229	221	302	103	450
3073935	WI	Adams	school	5500060	14	Public school	Adams-Friendship Area	550006001454	210	Adams-Friendship Middle		Regular School	No	Middle	05	08	2019	grade_5												120												120
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
3073937	WI	Adams	school	5500060	14	Public school	Adams-Friendship Area	550006001454	210	Adams-Friendship Middle		Regular School	No	Middle	05	08	2019	grade_7												104												104
3073938	WI	Adams	school	5500060	14	Public school	Adams-Friendship Area	550006001454	210	Adams-Friendship Middle		Regular School	No	Middle	05	08	2019	grade_8												111												111
3073939	WI	Adams	school	5500060	14	Public school	Adams-Friendship Area	550006000010	140	Grand Marsh Elementary		Regular School	No	Elementary	PK	04	2019	pk_12_total	85.0	3.0	7.0	2.0			5.0	64.0	38.0	89	27	102	85	3	7	2			5	64	38	89	27	102
3073940	WI	Adams	school	5500060	14	Public school	Adams-Friendship Area	550006000010	140	Grand Marsh Elementary		Regular School	No	Elementary	PK	04	2019	grade_1												25												25
3073941	WI	Adams	school	5500060	14	Public school	Adams-Friendship Area	550006000010	140	Grand Marsh Elementary		Regular School	No	Elementary	PK	04	2019	grade_2												14												14
3073942	WI	Adams	school	5500060	14	Public school	Adams-Friendship Area	550006000010	140	Grand Marsh Elementary		Regular School	No	Elementary	PK	04	2019	grade_3												20												20
3073943	WI	Adams	school	5500060	14	Public school	Adams-Friendship Area	550006000010	140	Grand Marsh Elementary		Regular School	No	Elementary	PK	04	2019	grade_4												22												22
3073944	WI	Adams	school	5500060	14	Public school	Adams-Friendship Area	550006000010	140	Grand Marsh Elementary		Regular School	No	Elementary	PK	04	2019	kindergarten_4_year_old												1												1
3073945	WI	Adams	school	5500060	14	Public school	Adams-Friendship Area	550006000010	140	Grand Marsh Elementary		Regular School	No	Elementary	PK	04	2019	kindergarten												20												20
3073946	WI	Green	school	5500120	63	Public school	Albany	550012002357	60	Albany Community Middle		Regular School	No	Middle	06	08	2019	pk_12_total	62.0	1.0	6.0	1.0	1.0		2.0	41.0	32.0	24	13	73	62	1	6	1	1		2	41	32	24	13	73
3073947	WI	Green	school	5500120	63	Public school	Albany	550012002357	60	Albany Community Middle		Regular School	No	Middle	06	08	2019	grade_6												24												24
3073948	WI	Green	school	5500120	63	Public school	Albany	550012002357	60	Albany Community Middle		Regular School	No	Middle	06	08	2019	grade_7												27												27
3073949	WI	Green	school	5500120	63	Public school	Albany	550012002357	60	Albany Community Middle		Regular School	No	Middle	06	08	2019	grade_8												22												22
3073950	WI	Green	school	5500120	63	Public school	Albany	550012000013	20	Albany Elementary		Regular School	No	Elementary	PK	05	2019	pk_12_total	155.0	1.0	8.0				6.0	85.0	85.0	74	22	170	155	1	8				6	85	85	74	22	170
3073951	WI	Green	school	5500120	63	Public school	Albany	550012000013	20	Albany Elementary		Regular School	No	Elementary	PK	05	2019	grade_1												32												32
3073952	WI	Green	school	5500120	63	Public school	Albany	550012000013	20	Albany Elementary		Regular School	No	Elementary	PK	05	2019	grade_2												18												18
3073953	WI	Green	school	5500120	63	Public school	Albany	550012000013	20	Albany Elementary		Regular School	No	Elementary	PK	05	2019	grade_3												26												26
3073954	WI	Green	school	5500120	63	Public school	Albany	550012000013	20	Albany Elementary		Regular School	No	Elementary	PK	05	2019	grade_4												18												18
3073955	WI	Green	school	5500120	63	Public school	Albany	550012000013	20	Albany Elementary		Regular School	No	Elementary	PK	05	2019	grade_5												21												21
3073956	WI	Green	school	5500120	63	Public school	Albany	550012000013	20	Albany Elementary		Regular School	No	Elementary	PK	05	2019	kindergarten_4_year_old												30												30
3073957	WI	Green	school	5500120	63	Public school	Albany	550012000013	20	Albany Elementary		Regular School	No	Elementary	PK	05	2019	kindergarten												25												25
3073958	WI	Green	school	5500120	63	Public school	Albany	550012000014	40	Albany High		Regular School	No	High	09	12	2019	pk_12_total	92.0	2.0	1.0				1.0	39.0	57.0	32	19	96	92	2	1				1	39	57	32	19	96
3073959	WI	Green	school	5500120	63	Public school	Albany	550012000014	40	Albany High		Regular School	No	High	09	12	2019	grade_10												27												27
3073960	WI	Green	school	5500120	63	Public school	Albany	550012000014	40	Albany High		Regular School	No	High	09	12	2019	grade_11												19												19
3073961	WI	Green	school	5500120	63	Public school	Albany	550012000014	40	Albany High		Regular School	No	High	09	12	2019	grade_12												24												24
3073962	WI	Green	school	5500120	63	Public school	Albany	550012000014	40	Albany High		Regular School	No	High	09	12	2019	grade_9												26												26
3073963	WI	Kewaunee	school	5500150	70	Public school	Algoma	550015000015	20	Algoma Elementary		Regular School	No	Elementary	PK	06	2019	pk_12_total	339.0	6.0	23.0		3.0		10.0	206.0	175.0	188	71	381	339	6	23		3		10	206	175	188	71	381
3073964	WI	Kewaunee	school	5500150	70	Public school	Algoma	550015000015	20	Algoma Elementary		Regular School	No	Elementary	PK	06	2019	grade_1												41												41
3073965	WI	Kewaunee	school	5500150	70	Public school	Algoma	550015000015	20	Algoma Elementary		Regular School	No	Elementary	PK	06	2019	grade_2												47												47
3073966	WI	Kewaunee	school	5500150	70	Public school	Algoma	550015000015	20	Algoma Elementary		Regular School	No	Elementary	PK	06	2019	grade_3												55												55
3073967	WI	Kewaunee	school	5500150	70	Public school	Algoma	550015000015	20	Algoma Elementary		Regular School	No	Elementary	PK	06	2019	grade_4												47												47
3073968	WI	Kewaunee	school	5500150	70	Public school	Algoma	550015000015	20	Algoma Elementary		Regular School	No	Elementary	PK	06	2019	grade_5												57												57
3073969	WI	Kewaunee	school	5500150	70	Public school	Algoma	550015000015	20	Algoma Elementary		Regular School	No	Elementary	PK	06	2019	grade_6												52												52
3073970	WI	Kewaunee	school	5500150	70	Public school	Algoma	550015000015	20	Algoma Elementary		Regular School	No	Elementary	PK	06	2019	kindergarten_4_year_old												31												31
3073971	WI	Kewaunee	school	5500150	70	Public school	Algoma	550015000015	20	Algoma Elementary		Regular School	No	Elementary	PK	06	2019	kindergarten												44												44
3073972	WI	Kewaunee	school	5500150	70	Public school	Algoma	550015000015	20	Algoma Elementary		Regular School	No	Elementary	PK	06	2019	pre_kindergarten												7												7
3073973	WI	Kewaunee	school	5500150	70	Public school	Algoma	550015000016	40	Algoma High		Regular School	No	High	07	12	2019	pk_12_total	293.0	4.0	20.0	3.0		1.0	4.0	152.0	173.0	132	49	325	293	4	20	3		1	4	152	173	132	49	325
3073974	WI	Kewaunee	school	5500150	70	Public school	Algoma	550015000016	40	Algoma High		Regular School	No	High	07	12	2019	grade_10												44												44
3073975	WI	Kewaunee	school	5500150	70	Public school	Algoma	550015000016	40	Algoma High		Regular School	No	High	07	12	2019	grade_11												63												63
3073976	WI	Kewaunee	school	5500150	70	Public school	Algoma	550015000016	40	Algoma High		Regular School	No	High	07	12	2019	grade_12												59												59
3073977	WI	Kewaunee	school	5500150	70	Public school	Algoma	550015000016	40	Algoma High		Regular School	No	High	07	12	2019	grade_7												48												48
3073978	WI	Kewaunee	school	5500150	70	Public school	Algoma	550015000016	40	Algoma High		Regular School	No	High	07	12	2019	grade_8												52												52
3073979	WI	Kewaunee	school	5500150	70	Public school	Algoma	550015000016	40	Algoma High		Regular School	No	High	07	12	2019	grade_9												59												59
3073980	WI	Buffalo	school	5500180	84	Public school	Alma	550018000017	20	Alma Elementary		Regular School	No	Elementary	PK	08	2019	pk_12_total	154.0		12.0		1.0		2.0	81.0	88.0	71	26	169	154		12		1		2	81	88	71	26	169
3073981	WI	Buffalo	school	5500180	84	Public school	Alma	550018000017	20	Alma Elementary		Regular School	No	Elementary	PK	08	2019	grade_1												18												18
3073982	WI	Buffalo	school	5500180	84	Public school	Alma	550018000017	20	Alma Elementary		Regular School	No	Elementary	PK	08	2019	grade_2												18												18
3073983	WI	Buffalo	school	5500180	84	Public school	Alma	550018000017	20	Alma Elementary		Regular School	No	Elementary	PK	08	2019	grade_3												14												14
3073984	WI	Buffalo	school	5500180	84	Public school	Alma	550018000017	20	Alma Elementary		Regular School	No	Elementary	PK	08	2019	grade_4												22												22
3073985	WI	Buffalo	school	5500180	84	Public school	Alma	550018000017	20	Alma Elementary		Regular School	No	Elementary	PK	08	2019	grade_5												18												18
3073986	WI	Buffalo	school	5500180	84	Public school	Alma	550018000017	20	Alma Elementary		Regular School	No	Elementary	PK	08	2019	grade_6												17												17
3073987	WI	Buffalo	school	5500180	84	Public school	Alma	550018000017	20	Alma Elementary		Regular School	No	Elementary	PK	08	2019	grade_7												13												13
3073988	WI	Buffalo	school	5500180	84	Public school	Alma	550018000017	20	Alma Elementary		Regular School	No	Elementary	PK	08	2019	grade_8												17												17