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 pacific_islander_int 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	hispanic	native_american	asian	pacific_islander	multiracial	male	female	total	white_int	black_int	hispanic_int	native_american_int	asian_int	pacific_islander_int	multiracial_int	male_int	female_int	total_int
3006331	SD	school	4602070	6001	Aberdeen 06-1	460207000003	1	Central High School	Regular School	No	High	09	12	2017	grade_8	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0	0	0	0	0	0	0	0	0	0
3006334	SD	school	4602070	6001	Aberdeen 06-1	460207000008	9	May Overby Elementary	Regular School	No	Elementary	KG	05	2017	grade_8	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0	0	0	0	0	0	0	0	0	0
3006335	SD	school	4602070	6001	Aberdeen 06-1	460207001367	7	Mike Miller Elementary	Regular School	No	Elementary	KG	05	2017	grade_8	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0	0	0	0	0	0	0	0	0	0
3006338	SD	school	4602070	6001	Aberdeen 06-1	460207000010	10	Simmons Elementary	Regular School	No	Elementary	KG	05	2017	grade_8	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0	0	0	0	0	0	0	0	0	0
3006339	SD	school	4602070	6001	Aberdeen 06-1	460207000011	3	Simmons Middle School	Regular School	No	Middle	06	08	2017	grade_8	151.0	4.0	8.0	20.0	7.0	0.0	2.0	92.0	100.0	192.0	151	4	8	20	7	0	2	92	100	192
3006542	SD	school	4639540	11001	Andes Central 11-1	463954000359	2	Andes Central Elementary	Regular School	No	Elementary	PK	06	2017	grade_8	0.0		0.0	0.0		0.0	0.0	0.0	0.0	0.0	0		0	0		0	0	0	0	0
3007276	SD	school	4607950	49002	Brandon Valley 49-2	460795000414	3	Brandon Elem	Regular School	No	Elementary	PK	04	2017	grade_8	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0	0	0	0	0	0	0	0	0	0
3007277	SD	school	4607950	49002	Brandon Valley 49-2	460795000071	1	Brandon Valley Hi Sch	Regular School	No	High	09	12	2017	grade_8	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0	0	0	0	0	0	0	0	0	0
3007278	SD	school	4607950	49002	Brandon Valley 49-2	460795001355	7	Brandon Valley Intermediate	Regular School	No	Middle	05	06	2017	grade_8	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0	0	0	0	0	0	0	0	0	0
3007279	SD	school	4607950	49002	Brandon Valley 49-2	460795000072	2	Brandon Valley Middle Sch	Regular School	No	Middle	07	08	2017	grade_8	265.0	10.0	10.0	2.0	3.0	0.0	7.0	156.0	141.0	297.0	265	10	10	2	3	0	7	156	141	297
3007427	SD	school	4600041	45004	Britton-Hecla 45-4	460004101141	1	Britton-Hecla High School	Regular School	No	High	09	12	2017	grade_8	0.0	0.0	0.0	0.0		0.0	0.0	0.0	0.0	0.0	0	0	0	0		0	0	0	0	0
3007522	SD	school	4608520	5001	Brookings 05-1	460852000082	1	Brookings Hi Sch	Regular School	No	High	09	12	2017	grade_8	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0	0	0	0	0	0	0	0	0	0
3007525	SD	school	4608520	5001	Brookings 05-1	460852000083	2	George S Mickelson Middle School	Regular School	No	Middle	06	08	2017	grade_8	220.0	4.0	8.0	3.0	17.0	0.0	7.0	130.0	129.0	259.0	220	4	8	3	17	0	7	130	129	259
3007526	SD	school	4608520	5001	Brookings 05-1	460852000085	4	Hillcrest Elem	Regular School	No	Elementary	KG	03	2017	grade_8	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0	0	0	0	0	0	0	0	0	0
3008273	SD	school	4616950	16001	Custer 16-1	461695000159	4	Hermosa Elem	Regular School	No	Elementary	KG	08	2017	grade_8	10.0		1.0	2.0		0.0	0.0	9.0	4.0	13.0	10		1	2		0	0	9	4	13
3008335	SD	school	4636990	61008	Dakota Valley 61-8	463699000345	1	Dakota Valley High School	Regular School	No	High	09	12	2017	grade_8	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0	0	0	0	0	0	0	0	0	0
3008388	SD	school	4617850	38002	De Smet 38-2	461785000163	1	De Smet High School	Regular School	No	High	09	12	2017	grade_8	0.0		0.0			0.0		0.0	0.0	0.0	0		0			0		0	0	0
3008564	SD	school	4600036	19004	Deuel 19-4	460003601011	2	Clear Lake Elementary	Regular School	No	Elementary	PK	05	2017	grade_8	0.0	0.0	0.0	0.0		0.0		0.0	0.0	0.0	0	0	0	0		0		0	0	0
3008566	SD	school	4600036	19004	Deuel 19-4	460003601010	1	Deuel High School	Regular School	No	High	09	12	2017	grade_8	0.0		0.0			0.0		0.0	0.0	0.0	0		0			0		0	0	0
3008754	SD	school	4619410	51001	Douglas 51-1	461941000453	5	Badger Clark Elem	Regular School	No	Elementary	KG	01	2017	grade_8	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0	0	0	0	0	0	0	0	0	0
3008755	SD	school	4619410	51001	Douglas 51-1	461941000174	3	Douglas High School	Regular School	No	High	09	12	2017	grade_8	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0	0	0	0	0	0	0	0	0	0
3008759	SD	school	4619410	51001	Douglas 51-1	461941000436	2	Vandenberg Elementary	Regular School	No	Elementary	04	05	2017	grade_8	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0	0	0	0	0	0	0	0	0	0
3009113	SD	school	4621390	5003	Elkton 05-3	462139000188	1	Elkton High School	Regular School	No	High	09	12	2017	grade_8	0.0		0.0			0.0	0.0	0.0	0.0	0.0	0		0			0	0	0	0	0
3009502	SD	school	4624390	50003	Flandreau 50-3	462439000207	4	Flandreau Elem	Regular School	No	Elementary	KG	05	2017	grade_8	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0	0	0	0	0	0	0	0	0	0
3009924	SD	school	4629880	26004	Gregory 26-4	462988000238	2	Gregory Elementary School	Regular School	No	Elementary	KG	05	2017	grade_8	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0	0	0	0	0	0	0	0	0	0
3009925	SD	school	4629880	26004	Gregory 26-4	462988000239	1	Gregory High School	Regular School	No	High	09	12	2017	grade_8	0.0		0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0		0	0	0	0	0	0	0	0
3010374	SD	school	4631350	41002	Harrisburg 41-2	463135001375	9	Horizon Elementary	Regular School	No	Elementary	PK	05	2017	grade_8	0.0	0.0	0.0		0.0	0.0	0.0	0.0	0.0	0.0	0	0	0		0	0	0	0	0	0
3010724	SD	school	4634480	23002	Hot Springs 23-2	463448000287	2	Hot Springs Elementary	Regular School	No	Elementary	PK	05	2017	grade_8	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0	0	0	0	0	0	0	0	0	0
3010725	SD	school	4634480	23002	Hot Springs 23-2	463448000288	1	Hot Springs Hi Sch	Regular School	No	High	09	12	2017	grade_8	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0	0	0	0	0	0	0	0	0	0
3010924	SD	school	4635480	2002	Huron 02-2	463548001370	18	Buchanan K-1 Center	Regular School	No	Elementary	KG	01	2017	grade_8	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0	0	0	0	0	0	0	0	0	0
3010927	SD	school	4635480	2002	Huron 02-2	463548000314	2	Huron Middle School	Regular School	No	Middle	06	08	2017	grade_8	95.0	3.0	32.0	4.0	44.0	0.0	2.0	90.0	90.0	180.0	95	3	32	4	44	0	2	90	90	180
3011534	SD	school	4641300	40001	Lead-Deadwood 40-1	464130001145	10	Lead-Deadwood Career & Tech Ed	Alternative School	No	High	09	12	2017	grade_8	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0	0	0	0	0	0	0	0	0	0
3011535	SD	school	4641300	40001	Lead-Deadwood 40-1	464130000372	3	Lead-Deadwood Elementary	Regular School	No	Elementary	KG	05	2017	grade_8	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0	0	0	0	0	0	0	0	0	0
3012208	SD	school	4669930	46001	Meade 46-1	466993000633	1	Sturgis Brown HS	Regular School	No	High	09	12	2017	grade_8	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0	0	0	0	0	0	0	0	0	0
3012373	SD	school	4600002	25004	Milbank 25-4	460000200424	1	Milbank High School	Regular School	No	High	09	12	2017	grade_8	0.0		0.0	0.0		0.0	0.0	0.0	0.0	0.0	0		0	0		0	0	0	0	0
3012430	SD	school	4647942	29004	Miller	464794200429	2	Miller Elementary School	Regular School	No	Elementary	KG	06	2017	grade_8	0.0	0.0	0.0	0.0	0.0	0.0		0.0	0.0	0.0	0	0	0	0	0	0		0	0	0
3012528	SD	school	4648390	17002	Mitchell 17-2	464839000437	2	Mitchell Middle School	Regular School	No	Middle	06	08	2017	grade_8	160.0	3.0	6.0	8.0	2.0	0.0	5.0	91.0	93.0	184.0	160	3	6	8	2	0	5	91	93	184
3012869	SD	school	4651750	56007	Northwestern Area 56-7	465175000475	1	Northwestern High School	Regular School	No	High	09	12	2017	grade_8	0.0					0.0	0.0	0.0	0.0	0.0	0					0	0	0	0	0
3013140	SD	school	4654270	60004	Parker 60-4	465427000487	2	Parker Elementary School	Regular School	No	Elementary	PK	06	2017	grade_8	0.0	0.0	0.0	0.0		0.0	0.0	0.0	0.0	0.0	0	0	0	0		0	0	0	0	0
3013141	SD	school	4654270	60004	Parker 60-4	465427000488	1	Parker High School	Regular School	No	High	09	12	2017	grade_8	0.0	0.0	0.0	0.0		0.0	0.0	0.0	0.0	0.0	0	0	0	0		0	0	0	0	0
3013308	SD	school	4655260	32002	Pierre 32-2	465526000500	1	T F Riggs High School	Regular School	No	High	09	12	2017	grade_8	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0	0	0	0	0	0	0	0	0	0
3013745	SD	school	4659820	51004	Rapid City Area 51-4	465982000540	4	Canyon Lake Elem	Regular School	No	Elementary	PK	05	2017	grade_8	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0	0	0	0	0	0	0	0	0	0
3013750	SD	school	4659820	51004	Rapid City Area 51-4	465982000548	6	Grandview Elem	Regular School	No	Elementary	KG	05	2017	grade_8	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0	0	0	0	0	0	0	0	0	0
3013753	SD	school	4659820	51004	Rapid City Area 51-4	465982000539	8	Knollwood Heights Elem	Regular School	No	Elementary	KG	05	2017	grade_8	0.0		0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0		0	0	0	0	0	0	0	0
3013755	SD	school	4659820	51004	Rapid City Area 51-4	465982000549	10	Meadowbrook Elem	Regular School	No	Elementary	KG	05	2017	grade_8	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0	0	0	0	0	0	0	0	0	0
3013759	SD	school	4659820	51004	Rapid City Area 51-4	465982000823	12	Rapid Valley Elem	Regular School	No	Elementary	PK	05	2017	grade_8	0.0	0.0	0.0	0.0		0.0	0.0	0.0	0.0	0.0	0	0	0	0		0	0	0	0	0
3013760	SD	school	4659820	51004	Rapid City Area 51-4	465982000541	14	Robbinsdale Elem	Regular School	No	Elementary	PK	05	2017	grade_8	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0	0	0	0	0	0	0	0	0	0
3013766	SD	school	4659820	51004	Rapid City Area 51-4	465982000969	13	Valley View Elem	Regular School	No	Elementary	KG	05	2017	grade_8	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0	0	0	0	0	0	0	0	0	0
3014128	SD	school	4603932	55005	Sanborn Central 55-5	460393200102	2	Sanborn Central Middle School	Regular School	No	Middle	06	08	2017	grade_8	7.0		0.0	0.0		0.0	0.0	2.0	5.0	7.0	7		0	0		0	0	2	5	7
3014670	SD	school	4666270	49005	Sioux Falls 49-5	466627000581	14	Cleveland Elementary	Regular School	No	Elementary	PK	05	2017	grade_8	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0	0	0	0	0	0	0	0	0	0
3014677	SD	school	4666270	49005	Sioux Falls 49-5	466627000587	19	Garfield Elementary	Regular School	No	Elementary	PK	05	2017	grade_8	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0	0	0	0	0	0	0	0	0	0
3014683	SD	school	4666270	49005	Sioux Falls 49-5	466627001064	23	John Harris Elementary	Regular School	No	Elementary	PK	05	2017	grade_8	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0	0	0	0	0	0	0	0	0	0
3014691	SD	school	4666270	49005	Sioux Falls 49-5	466627000813	58	Oscar Howe Elementary	Regular School	No	Elementary	KG	05	2017	grade_8	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0	0	0	0	0	0	0	0	0	0
3014693	SD	school	4666270	49005	Sioux Falls 49-5	466627001300	17	R. F. Pettigrew Elementary	Regular School	No	Elementary	PK	05	2017	grade_8	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0	0	0	0	0	0	0	0	0	0
3014694	SD	school	4666270	49005	Sioux Falls 49-5	466627000606	42	Renberg Elementary	Regular School	No	Elementary	KG	05	2017	grade_8	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0	0	0	0	0	0	0	0	0	0
3014695	SD	school	4666270	49005	Sioux Falls 49-5	466627000607	18	Robert Frost Elementary	Regular School	No	Elementary	PK	05	2017	grade_8	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0	0	0	0	0	0	0	0	0	0
3014696	SD	school	4666270	49005	Sioux Falls 49-5	466627001063	3	Roosevelt High School	Regular School	No	High	09	12	2017	grade_8	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0	0	0	0	0	0	0	0	0	0
3014698	SD	school	4666270	49005	Sioux Falls 49-5	466627001344	65	Sonia Sotomayor Elementary	Career and Technical School	No	Elementary	PK	05	2017	grade_8	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0	0	0	0	0	0	0	0	0	0
3014704	SD	school	4666270	49005	Sioux Falls 49-5	466627001351	66	Susan B. Anthony Elementary	Regular School	No	Elementary	KG	05	2017	grade_8	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0	0	0	0	0	0	0	0	0	0
3014706	SD	school	4666270	49005	Sioux Falls 49-5	466627000610	1	Washington High School	Regular School	No	High	09	12	2017	grade_8	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0	0	0	0	0	0	0	0	0	0
3014707	SD	school	4666270	49005	Sioux Falls 49-5	466627000611	8	Whittier Middle School	Regular School	No	Middle	06	08	2017	grade_8	133.0	57.0	53.0	16.0	26.0	0.0	11.0	139.0	157.0	296.0	133	57	53	16	26	0	11	139	157	296
3015092	SD	school	4607670	26005	South Central 26-5	460767000882	3	South Central Elementary	Regular School	No	Elementary	PK	05	2017	grade_8	0.0			0.0		0.0	0.0	0.0	0.0	0.0	0			0		0	0	0	0	0
3015185	SD	school	4666930	40002	Spearfish 40-2	466693000622	5	Spearfish MS	Regular School	No	Middle	06	08	2017	grade_8	133.0	1.0	6.0	0.0	3.0	0.0	4.0	66.0	81.0	147.0	133	1	6	0	3	0	4	66	81	147
3015186	SD	school	4666930	40002	Spearfish 40-2	466693000392	3	West Elementary	Regular School	No	Elementary	01	02	2017	grade_8	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0	0	0	0	0	0	0	0	0	0
3015263	SD	school	4624850	57001	Stanley County 57-1	462485000213	8	Stanley County Elementary	Regular School	No	Elementary	KG	05	2017	grade_8	0.0	0.0	0.0	0.0		0.0	0.0	0.0	0.0	0.0	0	0	0	0		0	0	0	0	0
3015548	SD	school	4672090	66001	Todd County 66-1	467209001349	16	Todd County Elem	Regular School	No	Elementary	KG	05	2017	grade_8	0.0		0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0		0	0	0	0	0	0	0	0
3015775	SD	school	4674370	13001	Vermillion 13-1	467437000301	4	Jolley Elementary School	Regular School	No	Elementary	02	05	2017	grade_8	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0	0	0	0	0	0	0	0	0	0
3015776	SD	school	4674370	13001	Vermillion 13-1	467437000691	1	Vermillion High School	Regular School	No	High	09	12	2017	grade_8	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0	0	0	0	0	0	0	0	0	0
3015839	SD	school	4674520	60006	Viborg-Hurley 60-6	467452000692	2	Viborg-Hurley Elementary	Regular School	No	Elementary	PK	04	2017	grade_8	0.0	0.0	0.0	0.0		0.0	0.0	0.0	0.0	0.0	0	0	0	0		0	0	0	0	0
3016120	SD	school	4676620	14004	Watertown 14-4	467662000713	6	McKinley Elementary School	Regular School	No	Elementary	PK	04	2017	grade_8	0.0		0.0	0.0		0.0	0.0	0.0	0.0	0.0	0		0	0		0	0	0	0	0
3016292	SD	school	4676990	18005	Webster Area	467699000723	3	Webster Area Elementary School	Regular School	No	Elementary	PK	05	2017	grade_8	0.0		0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0		0	0	0	0	0	0	0	0
3016484	SD	school	4678510	1003	White Lake 01-3	467851000745	2	White Lake Elementary	Regular School	No	Elementary	PK	06	2017	grade_8	0.0	0.0	0.0			0.0		0.0	0.0	0.0	0	0	0			0		0	0	0
3016544	SD	school	4678570	47001	White River 47-1	467857000754	1	White River High School	Regular School	No	High	09	12	2017	grade_8	0.0	0.0		0.0	0.0	0.0	0.0	0.0	0.0	0.0	0	0		0	0	0	0	0	0	0
3016741	SD	school	4679710	59002	Winner 59-2	467971000781	1	Winner High School	Regular School	No	High	09	12	2017	grade_8	0.0	0.0	0.0	0.0		0.0	0.0	0.0	0.0	0.0	0	0	0	0		0	0	0	0	0
3016900	SD	school	4680430	63003	Yankton 63-3	468043000795	5	Stewart Elem	Regular School	No	Elementary	KG	05	2017	grade_8	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0	0	0	0	0	0	0	0	0	0
3008756	SD	school	4619410	51001	Douglas 51-1	461941000176	1	Douglas Middle School	Regular School	No	Middle	06	08	2017	grade_8	140.0	6.0	13.0	13.0	2.0	1.0	22.0	101.0	96.0	197.0	140	6	13	13	2	1	22	101	96	197
3009504	SD	school	4624390	50003	Flandreau 50-3	462439000205	3	Flandreau Middle Sch	Regular School	No	Middle	06	08	2017	grade_8	27.0	1.0	6.0	22.0	1.0	1.0		32.0	26.0	58.0	27	1	6	22	1	1		32	26	58
3011274	SD	school	4680437	35002	Kadoka Area 35-2	468043701249	2	Kadoka Elementary School	Regular School	No	Elementary	PK	08	2017	grade_8	9.0	0.0	0.0	5.0		1.0		6.0	9.0	15.0	9	0	0	5		1		6	9	15
3011537	SD	school	4641300	40001	Lead-Deadwood 40-1	464130000373	2	Lead-Deadwood Middle School	Regular School	No	Middle	06	08	2017	grade_8	45.0	0.0	2.0	1.0		1.0	0.0	22.0	27.0	49.0	45	0	2	1		1	0	22	27	49
3012822	SD	school	4650850	9002	Newell 09-2	465085000968	4	Newell Middle Sch	Regular School	No	Middle	06	08	2017	grade_8	29.0	0.0	0.0	1.0	0.0	1.0	0.0	18.0	13.0	31.0	29	0	0	1	0	1	0	18	13	31
3014673	SD	school	4666270	49005	Sioux Falls 49-5	466627000583	6	Edison Middle School	Regular School	No	Middle	06	08	2017	grade_8	222.0	22.0	17.0	18.0	5.0	1.0	10.0	159.0	136.0	295.0	222	22	17	18	5	1	10	159	136	295
3014678	SD	school	4666270	49005	Sioux Falls 49-5	466627001333	9	George McGovern Middle School	Regular School	No	Middle	06	08	2017	grade_8	109.0	44.0	44.0	20.0	11.0	1.0	13.0	120.0	122.0	242.0	109	44	44	20	11	1	13	120	122	242
3015360	SD	school	4600052	41005	Tea Area 41-5	460005200853	2	Tea Area Intermediate/Middle School	Regular School	No	Middle	05	08	2017	grade_8	92.0	3.0	2.0	2.0		1.0	4.0	60.0	44.0	104.0	92	3	2	2		1	4	60	44	104
3006330	SD	school	4602070	6001	Aberdeen 06-1	460207000002	5	C.C. Lee Elementary	Regular School	No	Elementary	KG	05	2017	grade_8	0.0	0.0	0.0	0.0	0.0		0.0	0.0	0.0	0.0	0	0	0	0	0		0	0	0	0
3006332	SD	school	4602070	6001	Aberdeen 06-1	460207000005	2	Holgate Middle School	Regular School	No	Middle	06	08	2017	grade_8	148.0	3.0	1.0	7.0	5.0		3.0	91.0	76.0	167.0	148	3	1	7	5		3	91	76	167
3006333	SD	school	4602070	6001	Aberdeen 06-1	460207000007	8	Lincoln Elementary	Regular School	No	Elementary	PK	05	2017	grade_8	0.0	0.0	0.0	0.0	0.0		0.0	0.0	0.0	0.0	0	0	0	0	0		0	0	0	0
3006336	SD	school	4602070	6001	Aberdeen 06-1	460207001130	89	New Beginnings	Alternative School	No	Other	05	12	2017	grade_8	0.0	0.0	0.0	1.0				0.0	1.0	1.0	0	0	0	1				0	1	1
3006337	SD	school	4602070	6001	Aberdeen 06-1	460207000009	11	O.M. Tiffany Elementary	Regular School	No	Elementary	KG	05	2017	grade_8	0.0	0.0	0.0	0.0	0.0		0.0	0.0	0.0	0.0	0	0	0	0	0		0	0	0	0
3006430	SD	school	4600042	58003	Agar-Blunt-Onida 58-3	460004200855	3	Blunt Elementary	Regular School	No	Elementary	KG	05	2017	grade_8	0.0		0.0	0.0			0.0	0.0	0.0	0.0	0		0	0			0	0	0	0
3006431	SD	school	4600042	58003	Agar-Blunt-Onida 58-3	460004200655	4	Onida Elementary	Regular School	No	Elementary	KG	06	2017	grade_8	0.0		0.0	0.0	0.0		0.0	0.0	0.0	0.0	0		0	0	0		0	0	0	0
3006432	SD	school	4600042	58003	Agar-Blunt-Onida 58-3	460004200656	7	Sully Buttes High School	Regular School	No	High	09	12	2017	grade_8	0.0		0.0	0.0	0.0		0.0	0.0	0.0	0.0	0		0	0	0		0	0	0	0
3006433	SD	school	4600042	58003	Agar-Blunt-Onida 58-3	460004200939	6	Sully Buttes Junior High	Regular School	No	Middle	07	08	2017	grade_8	21.0		1.0	0.0			0.0	18.0	4.0	22.0	21		1	0			0	18	4	22
3006484	SD	school	4600028	61001	Alcester-Hudson 61-1	460002800013	4	Alcester-Hudson Elementary	Regular School	No	Elementary	PK	06	2017	grade_8	0.0		0.0	0.0	0.0		0.0	0.0	0.0	0.0	0		0	0	0		0	0	0	0
3006485	SD	school	4600028	61001	Alcester-Hudson 61-1	460002800014	1	Alcester-Hudson High School	Regular School	No	High	09	12	2017	grade_8	0.0	0.0	0.0		0.0			0.0	0.0	0.0	0	0	0		0			0	0	0
3006486	SD	school	4600028	61001	Alcester-Hudson 61-1	460002800874	3	Alcester-Hudson JH	Regular School	No	Middle	07	08	2017	grade_8	31.0		2.0				0.0	15.0	18.0	33.0	31		2				0	15	18	33
3006543	SD	school	4639540	11001	Andes Central 11-1	463954000360	1	Andes Central High School	Regular School	No	High	09	12	2017	grade_8	0.0			0.0			0.0	0.0	0.0	0.0	0			0			0	0	0	0
3006544	SD	school	4639540	11001	Andes Central 11-1	463954000850	4	Andes Central Jr High	Regular School	No	Middle	07	08	2017	grade_8	2.0		0.0	14.0			2.0	8.0	10.0	18.0	2		0	14			2	8	10	18
3006545	SD	school	4639540	11001	Andes Central 11-1	463954001080	5	Lakeview Colony Elem	Regular School	No	Elementary	KG	08	2017	grade_8	6.0							3.0	3.0	6.0	6							3	3	6
3006606	SD	school	4603720	38001	Arlington 38-1	460372000021	2	Arlington Elementary	Regular School	No	Elementary	PK	06	2017	grade_8	0.0	0.0	0.0	0.0	0.0		0.0	0.0	0.0	0.0	0	0	0	0	0		0	0	0	0
3006607	SD	school	4603720	38001	Arlington 38-1	460372000022	1	Arlington High School	Regular School	No	High	09	12	2017	grade_8	0.0		0.0				0.0	0.0	0.0	0.0	0		0				0	0	0	0
3006608	SD	school	4603720	38001	Arlington 38-1	460372000877	3	Arlington Junior High School	Regular School	No	Middle	07	08	2017	grade_8	20.0		0.0					15.0	5.0	20.0	20		0					15	5	20