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 "grade" = :p0 and "state" = :p1 and "year" = :p2 order by hispanic limit 101

Query parameters

This data as json, CSV

rowid	state	admin_level	district_nces_id	district_state_id	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	native_american	asian	pacific_islander	multiracial	male	female	total	white_int	black_int	native_american_int	asian_int	pacific_islander_int	multiracial_int	male_int	female_int	total_int
3344206	SD	school	4602070	6001	Aberdeen 06-1	460207001130	89	New Beginnings	Alternative Education School	No	4	05	12	2016	grade_12	2.0		0.0				1.0	1.0	2.0	2		0				1	1	2
3344445	SD	school	4639540	11001	Andes Central 11-1	463954001080	5	Lakeview Colony Elem	Regular School	No	1	PK	08	2016	grade_12	0.0						0.0	0.0	0.0	0						0	0	0
3344505	SD	school	4603720	38001	Arlington 38-1	460372000877	3	Arlington Junior High School	Regular School	No	2	07	08	2016	grade_12	0.0						0.0	0.0	0.0	0						0	0	0
3344553	SD	school	4603780	21001	Armour 21-1	460378000878	3	Armour Middle School	Regular School	No	2	06	08	2016	grade_12	0.0		0.0				0.0	0.0	0.0	0		0				0	0	0
3344920	SD	school	4607050	52001	Bison 52-1	460705000055	1	Bison High School	Regular School	No	3	09	12	2016	grade_12	8.0		0.0				6.0	2.0	8.0	8		0				6	2	8
3344921	SD	school	4607050	52001	Bison 52-1	460705000879	4	Bison JH	Regular School	No	2	07	08	2016	grade_12	0.0						0.0	0.0	0.0	0						0	0	0
3344985	SD	school	4607400	4002	Bon Homme 04-2	460740000060	18	Hutterische Colony Elementary	Regular School	No	1	KG	08	2016	grade_12	0.0						0.0	0.0	0.0	0						0	0	0
3344986	SD	school	4607400	4002	Bon Homme 04-2	460740000061	3	Springfield Elementary	Regular School	No	1	KG	05	2016	grade_12	0.0	0.0					0.0	0.0	0.0	0	0					0	0	0
3344987	SD	school	4607400	4002	Bon Homme 04-2	460740001350	9	Springfield Preschool	Regular School	No	1	PK	PK	2016	grade_12	0.0		0.0				0.0	0.0	0.0	0		0				0	0	0
3345095	SD	school	4607800	22001	Bowdle 22-1	460780000068	2	Bowdle Elementary	Regular School	No	1	PK	06	2016	grade_12	0.0						0.0	0.0	0.0	0						0	0	0
3345096	SD	school	4607800	22001	Bowdle 22-1	460780000069	1	Bowdle High School	Regular School	No	3	09	12	2016	grade_12	9.0						5.0	4.0	9.0	9						5	4	9
3345097	SD	school	4607800	22001	Bowdle 22-1	460780000883	3	Bowdle Jr High	Regular School	No	2	07	08	2016	grade_12	0.0			0.0			0.0	0.0	0.0	0			0			0	0	0
3345161	SD	school	4607950	49002	Brandon Valley 49-2	460795000073	4	Valley Springs Elem	Regular School	No	1	KG	04	2016	grade_12	0.0	0.0				0.0	0.0	0.0	0.0	0	0				0	0	0	0
3345260	SD	school	4621420	30003	Bridgewater-Emery 30-3	462142000902	4	Bridgewater-Emery Middle School	Regular School	No	2	06	08	2016	grade_12	0.0	0.0					0.0	0.0	0.0	0	0					0	0	0
3345331	SD	school	4600041	45004	Britton-Hecla 45-4	460004101143	4	Sunset Colony	Regular School	No	1	KG	08	2016	grade_12	0.0						0.0	0.0	0.0	0						0	0	0
3345332	SD	school	4600041	45004	Britton-Hecla 45-4	460004101364	6	Sunset Colony High School	Regular School	No	3	09	12	2016	grade_12	5.0						2.0	3.0	5.0	5						2	3	5
3345333	SD	school	4600041	45004	Britton-Hecla 45-4	460004101180	5	Westwood Colony	Regular School	No	1	KG	08	2016	grade_12	0.0						0.0	0.0	0.0	0						0	0	0
3345511	SD	school	4609512	26002	Burke 26-2	460951200100	2	Burke Elementary School	Regular School	No	1	PK	06	2016	grade_12	0.0		0.0				0.0	0.0	0.0	0		0				0	0	0
3345512	SD	school	4609512	26002	Burke 26-2	460951200101	1	Burke High School	Regular School	No	3	09	12	2016	grade_12	16.0		2.0				7.0	11.0	18.0	16		2				7	11	18
3345560	SD	school	4610320	43001	Canistota 43-1	461032000105	1	Canistota High School	Regular School	No	3	09	12	2016	grade_12	22.0	0.0	0.0				12.0	10.0	22.0	22	0	0				12	10	22
3345659	SD	school	4611280	28001	Castlewood 28-1	461128000114	1	Castlewood High School	Regular School	No	3	09	12	2016	grade_12	14.0		1.0				5.0	10.0	15.0	14		1				5	10	15
3345661	SD	school	4611280	28001	Castlewood 28-1	461128001126	4	Claremont Colony Elementary	Regular School	No	1	KG	08	2016	grade_12	0.0						0.0	0.0	0.0	0						0	0	0
3345721	SD	school	4611760	60001	Centerville 60-1	461176001023	3	Centerville Middle School	Regular School	No	2	05	08	2016	grade_12	0.0	0.0	0.0				0.0	0.0	0.0	0	0	0				0	0	0
3345825	SD	school	4612300	39001	Chester Area 39-1	461230001269	39	Chester Area Cyber School	Alternative Education School	No	3	09	12	2016	grade_12	23.0						13.0	10.0	23.0	23						13	10	23
3345826	SD	school	4612300	39001	Chester Area 39-1	461230000131	2	Chester Area Elementary School	Regular School	No	1	PK	05	2016	grade_12	0.0	0.0	0.0			0.0	0.0	0.0	0.0	0	0	0			0	0	0	0
3345827	SD	school	4612300	39001	Chester Area 39-1	461230000130	1	Chester Area High School	Regular School	No	3	09	12	2016	grade_12	22.0			1.0			9.0	14.0	23.0	22			1			9	14	23
3345828	SD	school	4612300	39001	Chester Area 39-1	461230000832	3	Chester Area Middle School	Regular School	No	2	06	08	2016	grade_12	0.0	0.0	0.0				0.0	0.0	0.0	0	0	0				0	0	0
3345829	SD	school	4612300	39001	Chester Area 39-1	461230001092	4	Rustic Acres	Regular School	No	1	KG	08	2016	grade_12	0.0						0.0	0.0	0.0	0						0	0	0
3345923	SD	school	4612940	12002	Clark 12-2	461294001081	4	Fordham Colony Elementary	Regular School	No	1	KG	08	2016	grade_12	0.0						0.0	0.0	0.0	0						0	0	0
3345924	SD	school	4612940	12002	Clark 12-2	461294001082	5	Hillcrest Colony Elementary	Regular School	No	1	KG	08	2016	grade_12	0.0						0.0	0.0	0.0	0						0	0	0
3345925	SD	school	4612940	12002	Clark 12-2	461294001319	7	Silver Creek Colony	Regular School	No	1	KG	08	2016	grade_12	0.0						0.0	0.0	0.0	0						0	0	0
3346004	SD	school	4614100	50005	Colman-Egan 50-5	461410000091	1	Colman-Egan Hi Sch	Regular School	No	3	09	12	2016	grade_12	17.0	1.0	2.0				13.0	7.0	20.0	17	1	2				13	7	20
3346005	SD	school	4614100	50005	Colman-Egan 50-5	461410000092	2	Colman-Egan Jr Hi	Regular School	No	2	07	08	2016	grade_12	0.0	0.0	0.0				0.0	0.0	0.0	0	0	0				0	0	0
3346042	SD	school	4614130	59003	Colome Consolidated	461413000140	2	Colome Elementary School	Regular School	No	1	PK	06	2016	grade_12	0.0		0.0	0.0		0.0	0.0	0.0	0.0	0		0	0		0	0	0	0
3346044	SD	school	4614130	59003	Colome Consolidated	461413000893	3	Colome Jr High	Regular School	No	2	07	08	2016	grade_12	0.0		0.0	0.0			0.0	0.0	0.0	0		0	0			0	0	0
3346045	SD	school	4614130	59003	Colome Consolidated	461413000787	5	Wood Elementary	Regular School	No	1	KG	08	2016	grade_12	0.0		0.0				0.0	0.0	0.0	0		0				0	0	0
3346103	SD	school	4680445	21003	Corsica-Stickney 21-3	468044501354	2	Corsica-Stickney Elementary	Regular School	No	1	PK	06	2016	grade_12	0.0						0.0	0.0	0.0	0						0	0	0
3346104	SD	school	4680445	21003	Corsica-Stickney 21-3	468044501357	1	Corsica-Stickney High School	Regular School	No	3	09	12	2016	grade_12	12.0						5.0	7.0	12.0	12						5	7	12
3346105	SD	school	4680445	21003	Corsica-Stickney 21-3	468044501352	3	Corsica-Stickney Jr. High	Regular School	No	2	07	08	2016	grade_12	0.0						0.0	0.0	0.0	0						0	0	0
3346280	SD	school	4617850	38002	De Smet 38-2	461785000993	3	De Smet Middle School	Regular School	No	2	06	08	2016	grade_12	0.0		0.0				0.0	0.0	0.0	0		0				0	0	0
3346384	SD	school	4678300	5006	Deubrook Area 05-6	467830001154	7	Norfeld Colony School	Regular School	No	1	KG	08	2016	grade_12	0.0						0.0	0.0	0.0	0						0	0	0
3346385	SD	school	4678300	5006	Deubrook Area 05-6	467830001320	9	Red Willow Colony School	Regular School	No	1	KG	08	2016	grade_12	0.0						0.0	0.0	0.0	0						0	0	0
3346515	SD	school	4619170	56002	Doland 56-2	461917001299	6	Camrose Colony Elementary	Regular School	No	1	KG	08	2016	grade_12	0.0						0.0	0.0	0.0	0						0	0	0
3346516	SD	school	4619170	56002	Doland 56-2	461917001101	5	Clark Colony Elementary	Regular School	No	1	KG	08	2016	grade_12	0.0						0.0	0.0	0.0	0						0	0	0
3346519	SD	school	4619170	56002	Doland 56-2	461917000895	2	Doland Junior High	Regular School	No	2	07	08	2016	grade_12	0.0						0.0	0.0	0.0	0						0	0	0
3346520	SD	school	4619170	56002	Doland 56-2	461917001100	4	Hillside Colony Elementary	Regular School	No	1	KG	08	2016	grade_12	0.0						0.0	0.0	0.0	0						0	0	0
3346521	SD	school	4619170	56002	Doland 56-2	461917001359	7	Hillside Colony High School	Regular School	No	3	09	12	2016	grade_12	0.0						0.0	0.0	0.0	0						0	0	0
3346712	SD	school	4619450	64002	Dupree 64-2	461945000800	1	Dupree Hi Sch	Regular School	No	3	09	12	2016	grade_12	3.0		5.0				4.0	4.0	8.0	3		5				4	4	8
3346976	SD	school	4621390	5003	Elkton 05-3	462139001078	4	Newdale Colony Elem	Regular School	No	1	KG	08	2016	grade_12	0.0						0.0	0.0	0.0	0						0	0	0
3346977	SD	school	4621390	5003	Elkton 05-3	462139001168	5	Rolland Colony Elem	Regular School	No	1	KG	08	2016	grade_12	0.0						0.0	0.0	0.0	0						0	0	0
3347144	SD	school	4622560	44001	Eureka 44-1	462256000196	1	Eureka High School	Regular School	No	3	09	12	2016	grade_12	13.0			0.0			11.0	2.0	13.0	13			0			11	2	13
3347145	SD	school	4622560	44001	Eureka 44-1	462256000958	3	Eureka MS	Regular School	No	2	06	08	2016	grade_12	0.0						0.0	0.0	0.0	0						0	0	0
3347200	SD	school	4622940	46002	Faith 46-2	462294001306	10	Faith PreSchool	Regular School	No	1	PK	PK	2016	grade_12	0.0						0.0	0.0	0.0	0						0	0	0
3347201	SD	school	4622940	46002	Faith 46-2	462294000412	4	Maurine Elem.	Regular School	No	1	KG	08	2016	grade_12	0.0						0.0	0.0	0.0	0						0	0	0
3347280	SD	school	4624030	24004	Faulkton Area	462403001158	6	Blumengard Colony Elem	Regular School	No	1	KG	08	2016	grade_12	0.0						0.0	0.0	0.0	0						0	0	0
3347281	SD	school	4624030	24004	Faulkton Area	462403001090	5	Brentwood Colony School	Regular School	No	1	KG	08	2016	grade_12	0.0						0.0	0.0	0.0	0						0	0	0
3347282	SD	school	4624030	24004	Faulkton Area	462403000202	2	Faulkton Elem	Regular School	No	1	PK	06	2016	grade_12	0.0	0.0	0.0				0.0	0.0	0.0	0	0	0				0	0	0
3347283	SD	school	4624030	24004	Faulkton Area	462403000203	1	Faulkton Hi Sch	Regular School	No	3	09	12	2016	grade_12	18.0	1.0	0.0				14.0	5.0	19.0	18	1	0				14	5	19
3347284	SD	school	4624030	24004	Faulkton Area	462403000204	8	Faulkton Jr Hi	Regular School	No	2	07	08	2016	grade_12	0.0		0.0				0.0	0.0	0.0	0		0				0	0	0
3347285	SD	school	4624030	24004	Faulkton Area	462403001160	10	Thunderbird Colony Elem	Regular School	No	1	KG	08	2016	grade_12	0.0						0.0	0.0	0.0	0						0	0	0
3347373	SD	school	4624390	50003	Flandreau 50-3	462439001119	6	Pleasant Valley Colony Elem	Regular School	No	1	KG	08	2016	grade_12	0.0						0.0	0.0	0.0	0						0	0	0
3347431	SD	school	4624540	14001	Florence 14-1	462454000208	2	Florence Elementary School	Regular School	No	1	PK	06	2016	grade_12	0.0		0.0			0.0	0.0	0.0	0.0	0		0			0	0	0	0
3347433	SD	school	4624540	14001	Florence 14-1	462454000589	3	Florence Jr High	Regular School	No	2	07	08	2016	grade_12	0.0		0.0			0.0	0.0	0.0	0.0	0		0			0	0	0	0
3347479	SD	school	4621400	6002	Frederick Area 06-2	462140000189	2	Frederick Elementary	Regular School	No	1	KG	06	2016	grade_12	0.0					0.0	0.0	0.0	0.0	0					0	0	0	0
3347480	SD	school	4621400	6002	Frederick Area 06-2	462140000190	1	Frederick High School	Regular School	No	3	09	12	2016	grade_12	10.0		1.0				4.0	7.0	11.0	10		1				4	7	11
3347481	SD	school	4621400	6002	Frederick Area 06-2	462140000957	3	Frederick Jr High	Regular School	No	2	07	08	2016	grade_12	0.0					0.0	0.0	0.0	0.0	0					0	0	0	0
3347535	SD	school	4625500	33001	Freeman 33-1	462550000842	5	Freeman Jr High	Regular School	No	2	07	08	2016	grade_12	0.0	0.0					0.0	0.0	0.0	0	0					0	0	0
3347536	SD	school	4625500	33001	Freeman 33-1	462550000221	3	Tschetter Colony Elementary	Regular School	No	1	KG	08	2016	grade_12	0.0						0.0	0.0	0.0	0						0	0	0
3347537	SD	school	4625500	33001	Freeman 33-1	462550000222	4	Wolf Creek Colony Elementary	Regular School	No	1	KG	08	2016	grade_12	0.0						0.0	0.0	0.0	0						0	0	0
3347751	SD	school	4629340	25003	Grant-Deuel 25-3	462934000235	2	Grant-Deuel Elementary	Regular School	No	1	PK	06	2016	grade_12	0.0		0.0				0.0	0.0	0.0	0		0				0	0	0
3347752	SD	school	4629340	25003	Grant-Deuel 25-3	462934000236	1	Grant-Deuel High School	Regular School	No	3	09	12	2016	grade_12	2.0						1.0	1.0	2.0	2						1	1	2
3347753	SD	school	4629340	25003	Grant-Deuel 25-3	462934000905	3	Grant-Deuel Jr Hi	Regular School	No	2	07	08	2016	grade_12	0.0						0.0	0.0	0.0	0						0	0	0
3347801	SD	school	4629880	26004	Gregory 26-4	462988001296	4	Gregory Jr High School	Regular School	No	2	07	08	2016	grade_12	0.0		0.0		0.0		0.0	0.0	0.0	0		0		0		0	0	0
3347901	SD	school	4630490	27001	Haakon 27-1	463049000634	6	Deep Creek Rural School	Regular School	No	1	KG	08	2016	grade_12	0.0						0.0	0.0	0.0	0						0	0	0
3347904	SD	school	4630490	27001	Haakon 27-1	463049000256	1	Philip High School	Regular School	No	3	09	12	2016	grade_12	14.0		3.0	0.0	1.0	1.0	14.0	5.0	19.0	14		3	0	1	1	14	5	19
3348032	SD	school	4602640	30001	Hanson 30-1	460264001272	7	Hanson Alternative Colony High School	Regular School	No	3	09	12	2016	grade_12	0.0						0.0	0.0	0.0	0						0	0	0
3348034	SD	school	4602640	30001	Hanson 30-1	460264000017	1	Hanson High School	Regular School	No	3	09	12	2016	grade_12	29.0	0.0	1.0	0.0		1.0	13.0	18.0	31.0	29	0	1	0		1	13	18	31
3348036	SD	school	4602640	30001	Hanson 30-1	460264000015	4	Millbrook Colony Elementary	Regular School	No	1	KG	08	2016	grade_12	0.0						0.0	0.0	0.0	0						0	0	0
3348125	SD	school	4609300	31001	Harding County 31-1	460930000087	2	Buffalo Elementary	Regular School	No	1	KG	05	2016	grade_12	0.0	0.0					0.0	0.0	0.0	0	0					0	0	0
3348126	SD	school	4609300	31001	Harding County 31-1	460930000701	8	Camp Crook Elementary	Regular School	No	1	KG	08	2016	grade_12	0.0						0.0	0.0	0.0	0						0	0	0
3348127	SD	school	4609300	31001	Harding County 31-1	460930000088	1	Harding County High School	Regular School	No	3	09	12	2016	grade_12	12.0						8.0	4.0	12.0	12						8	4	12
3348128	SD	school	4609300	31001	Harding County 31-1	460930000887	3	Harding County MS	Regular School	No	2	06	08	2016	grade_12	0.0	0.0	0.0				0.0	0.0	0.0	0	0	0				0	0	0
3348129	SD	school	4609300	31001	Harding County 31-1	460930000667	6	Ludlow Elementary	Regular School	No	1	KG	08	2016	grade_12	0.0						0.0	0.0	0.0	0						0	0	0
3348327	SD	school	4632340	14002	Henry 14-2	463234000275	2	Henry Elementary	Regular School	No	1	PK	04	2016	grade_12	0.0			0.0			0.0	0.0	0.0	0			0			0	0	0
3348375	SD	school	4632430	10001	Herreid 10-1	463243000277	2	Herreid Elem	Regular School	No	1	KG	05	2016	grade_12	0.0				0.0	0.0	0.0	0.0	0.0	0				0	0	0	0	0
3348376	SD	school	4632430	10001	Herreid 10-1	463243000278	1	Herreid Hi Sch	Regular School	No	3	09	12	2016	grade_12	11.0						8.0	3.0	11.0	11						8	3	11
3348425	SD	school	4680440	34002	Highmore-Harrold	468044001049	3	Highmore-Harrold Junior High	Regular School	No	2	07	08	2016	grade_12	0.0		0.0				0.0	0.0	0.0	0		0				0	0	0
3348525	SD	school	4600046	56006	Hitchcock-Tulare	460004601166	4	Glendale Colony Elem	Regular School	No	1	KG	08	2016	grade_12	0.0						0.0	0.0	0.0	0						0	0	0
3348526	SD	school	4600046	56006	Hitchcock-Tulare	460004601167	5	Hitchcock-Tulare Elementary	Regular School	No	1	KG	06	2016	grade_12	0.0		0.0				0.0	0.0	0.0	0		0				0	0	0
3348528	SD	school	4600046	56006	Hitchcock-Tulare	460004601164	2	Hitchcock-Tulare JH	Regular School	No	2	07	08	2016	grade_12	0.0						0.0	0.0	0.0	0						0	0	0
3348529	SD	school	4600046	56006	Hitchcock-Tulare	460004601165	3	Spink Colony Elem	Regular School	No	1	KG	08	2016	grade_12	0.0						0.0	0.0	0.0	0						0	0	0
3348647	SD	school	4634600	53002	Hoven 53-2	463460000297	2	Hoven Elementary	Regular School	No	1	PK	06	2016	grade_12	0.0		0.0				0.0	0.0	0.0	0		0				0	0	0
3348648	SD	school	4634600	53002	Hoven 53-2	463460000298	1	Hoven High School	Regular School	No	3	09	12	2016	grade_12	6.0						2.0	4.0	6.0	6						2	4	6
3348649	SD	school	4634600	53002	Hoven 53-2	463460000912	3	Hoven Jr High School	Regular School	No	2	07	08	2016	grade_12	0.0		0.0				0.0	0.0	0.0	0		0				0	0	0
3348701	SD	school	4600025	48003	Howard 48-3	460002501161	8	Shannon Colony	Regular School	No	1	KG	08	2016	grade_12	0.0						0.0	0.0	0.0	0						0	0	0
3348765	SD	school	4635480	2002	Huron 02-2	463548000312	13	Huron Colony Elementary	Regular School	No	1	KG	08	2016	grade_12	0.0						0.0	0.0	0.0	0						0	0	0
3348769	SD	school	4635480	2002	Huron 02-2	463548000318	15	Riverside Colony Elementary	Regular School	No	1	KG	08	2016	grade_12	0.0						0.0	0.0	0.0	0						0	0	0
3348848	SD	school	4636060	22006	Ipswich Public 22-6	463606001085	5	Deerfield Colony Elem	Regular School	No	1	PK	08	2016	grade_12	0.0						0.0	0.0	0.0	0						0	0	0
3348852	SD	school	4636060	22006	Ipswich Public 22-6	463606001086	6	Pembrook Colony Elem	Regular School	No	1	PK	08	2016	grade_12	0.0						0.0	0.0	0.0	0						0	0	0
3348853	SD	school	4636060	22006	Ipswich Public 22-6	463606000334	3	Rosette Colony Elem	Regular School	No	1	PK	08	2016	grade_12	0.0						0.0	0.0	0.0	0						0	0	0
3348989	SD	school	4636150	2003	Iroquois 02-3	463615000340	5	Pearl Creek Colony Elem	Regular School	No	2	04	08	2016	grade_12	0.0						0.0	0.0	0.0	0						0	0	0