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
3006261	SD	school	4602070	6001	Aberdeen 06-1	460207000003	1	Central High School	Regular School	No	High	09	12	2017	grade_12	259.0	12.0	6.0	25.0	9.0	0.0	4.0	179.0	136.0	315.0	259	12	6	25	9	0	4	179	136	315
3006264	SD	school	4602070	6001	Aberdeen 06-1	460207000008	9	May Overby Elementary	Regular School	No	Elementary	KG	05	2017	grade_12	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0	0	0	0	0	0	0	0	0	0
3006265	SD	school	4602070	6001	Aberdeen 06-1	460207001367	7	Mike Miller Elementary	Regular School	No	Elementary	KG	05	2017	grade_12	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0	0	0	0	0	0	0	0	0	0
3006268	SD	school	4602070	6001	Aberdeen 06-1	460207000010	10	Simmons Elementary	Regular School	No	Elementary	KG	05	2017	grade_12	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0	0	0	0	0	0	0	0	0	0
3006269	SD	school	4602070	6001	Aberdeen 06-1	460207000011	3	Simmons Middle School	Regular School	No	Middle	06	08	2017	grade_12	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0	0	0	0	0	0	0	0	0	0
3006514	SD	school	4639540	11001	Andes Central 11-1	463954000359	2	Andes Central Elementary	Regular School	No	Elementary	PK	06	2017	grade_12	0.0		0.0	0.0		0.0	0.0	0.0	0.0	0.0	0		0	0		0	0	0	0	0
3007227	SD	school	4607950	49002	Brandon Valley 49-2	460795000414	3	Brandon Elem	Regular School	No	Elementary	PK	04	2017	grade_12	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0	0	0	0	0	0	0	0	0	0
3007228	SD	school	4607950	49002	Brandon Valley 49-2	460795000071	1	Brandon Valley Hi Sch	Regular School	No	High	09	12	2017	grade_12	248.0	9.0	5.0	0.0	3.0	0.0	3.0	133.0	135.0	268.0	248	9	5	0	3	0	3	133	135	268
3007229	SD	school	4607950	49002	Brandon Valley 49-2	460795001355	7	Brandon Valley Intermediate	Regular School	No	Middle	05	06	2017	grade_12	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0	0	0	0	0	0	0	0	0	0
3007230	SD	school	4607950	49002	Brandon Valley 49-2	460795000072	2	Brandon Valley Middle Sch	Regular School	No	Middle	07	08	2017	grade_12	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0	0	0	0	0	0	0	0	0	0
3007385	SD	school	4600041	45004	Britton-Hecla 45-4	460004101141	1	Britton-Hecla High School	Regular School	No	High	09	12	2017	grade_12	26.0	0.0	0.0	1.0		0.0	0.0	5.0	22.0	27.0	26	0	0	1		0	0	5	22	27
3007480	SD	school	4608520	5001	Brookings 05-1	460852000082	1	Brookings Hi Sch	Regular School	No	High	09	12	2017	grade_12	166.0	5.0	7.0	1.0	7.0	0.0	2.0	89.0	99.0	188.0	166	5	7	1	7	0	2	89	99	188
3007483	SD	school	4608520	5001	Brookings 05-1	460852000083	2	George S Mickelson Middle School	Regular School	No	Middle	06	08	2017	grade_12	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0	0	0	0	0	0	0	0	0	0
3007484	SD	school	4608520	5001	Brookings 05-1	460852000085	4	Hillcrest Elem	Regular School	No	Elementary	KG	03	2017	grade_12	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0	0	0	0	0	0	0	0	0	0
3008245	SD	school	4616950	16001	Custer 16-1	461695000159	4	Hermosa Elem	Regular School	No	Elementary	KG	08	2017	grade_12	0.0		0.0	0.0		0.0	0.0	0.0	0.0	0.0	0		0	0		0	0	0	0	0
3008307	SD	school	4636990	61008	Dakota Valley 61-8	463699000345	1	Dakota Valley High School	Regular School	No	High	09	12	2017	grade_12	70.0	0.0	3.0	1.0	1.0	0.0	2.0	45.0	32.0	77.0	70	0	3	1	1	0	2	45	32	77
3008367	SD	school	4617850	38002	De Smet 38-2	461785000163	1	De Smet High School	Regular School	No	High	09	12	2017	grade_12	21.0		0.0			0.0		9.0	12.0	21.0	21		0			0		9	12	21
3008543	SD	school	4600036	19004	Deuel 19-4	460003601011	2	Clear Lake Elementary	Regular School	No	Elementary	PK	05	2017	grade_12	0.0	0.0	0.0	0.0		0.0		0.0	0.0	0.0	0	0	0	0		0		0	0	0
3008545	SD	school	4600036	19004	Deuel 19-4	460003601010	1	Deuel High School	Regular School	No	High	09	12	2017	grade_12	35.0		0.0			0.0		15.0	20.0	35.0	35		0			0		15	20	35
3008712	SD	school	4619410	51001	Douglas 51-1	461941000453	5	Badger Clark Elem	Regular School	No	Elementary	KG	01	2017	grade_12	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0	0	0	0	0	0	0	0	0	0
3008713	SD	school	4619410	51001	Douglas 51-1	461941000174	3	Douglas High School	Regular School	No	High	09	12	2017	grade_12	87.0	5.0	12.0	9.0	2.0	0.0	21.0	63.0	73.0	136.0	87	5	12	9	2	0	21	63	73	136
3008714	SD	school	4619410	51001	Douglas 51-1	461941000176	1	Douglas Middle School	Regular School	No	Middle	06	08	2017	grade_12	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0	0	0	0	0	0	0	0	0	0
3008717	SD	school	4619410	51001	Douglas 51-1	461941000436	2	Vandenberg Elementary	Regular School	No	Elementary	04	05	2017	grade_12	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0	0	0	0	0	0	0	0	0	0
3009078	SD	school	4621390	5003	Elkton 05-3	462139000188	1	Elkton High School	Regular School	No	High	09	12	2017	grade_12	12.0		0.0			0.0	0.0	7.0	5.0	12.0	12		0			0	0	7	5	12
3009474	SD	school	4624390	50003	Flandreau 50-3	462439000207	4	Flandreau Elem	Regular School	No	Elementary	KG	05	2017	grade_12	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0	0	0	0	0	0	0	0	0	0
3009476	SD	school	4624390	50003	Flandreau 50-3	462439000205	3	Flandreau Middle Sch	Regular School	No	Middle	06	08	2017	grade_12	0.0	0.0	0.0	0.0	0.0	0.0		0.0	0.0	0.0	0	0	0	0	0	0		0	0	0
3009903	SD	school	4629880	26004	Gregory 26-4	462988000238	2	Gregory Elementary School	Regular School	No	Elementary	KG	05	2017	grade_12	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0	0	0	0	0	0	0	0	0	0
3010311	SD	school	4631350	41002	Harrisburg 41-2	463135001375	9	Horizon Elementary	Regular School	No	Elementary	PK	05	2017	grade_12	0.0	0.0	0.0		0.0	0.0	0.0	0.0	0.0	0.0	0	0	0		0	0	0	0	0	0
3010703	SD	school	4634480	23002	Hot Springs 23-2	463448000287	2	Hot Springs Elementary	Regular School	No	Elementary	PK	05	2017	grade_12	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0	0	0	0	0	0	0	0	0	0
3010704	SD	school	4634480	23002	Hot Springs 23-2	463448000288	1	Hot Springs Hi Sch	Regular School	No	High	09	12	2017	grade_12	50.0	0.0	1.0	9.0	0.0	0.0	2.0	40.0	22.0	62.0	50	0	1	9	0	0	2	40	22	62
3010875	SD	school	4635480	2002	Huron 02-2	463548001370	18	Buchanan K-1 Center	Regular School	No	Elementary	KG	01	2017	grade_12	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0	0	0	0	0	0	0	0	0	0
3010878	SD	school	4635480	2002	Huron 02-2	463548000314	2	Huron Middle School	Regular School	No	Middle	06	08	2017	grade_12	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0	0	0	0	0	0	0	0	0	0
3011239	SD	school	4680437	35002	Kadoka Area 35-2	468043701249	2	Kadoka Elementary School	Regular School	No	Elementary	PK	08	2017	grade_12	0.0	0.0	0.0	0.0		0.0		0.0	0.0	0.0	0	0	0	0		0		0	0	0
3011507	SD	school	4641300	40001	Lead-Deadwood 40-1	464130000372	3	Lead-Deadwood Elementary	Regular School	No	Elementary	KG	05	2017	grade_12	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0	0	0	0	0	0	0	0	0	0
3011509	SD	school	4641300	40001	Lead-Deadwood 40-1	464130000373	2	Lead-Deadwood Middle School	Regular School	No	Middle	06	08	2017	grade_12	0.0	0.0	0.0	0.0		0.0	0.0	0.0	0.0	0.0	0	0	0	0		0	0	0	0	0
3012138	SD	school	4669930	46001	Meade 46-1	466993000633	1	Sturgis Brown HS	Regular School	No	High	09	12	2017	grade_12	147.0	0.0	3.0	6.0	0.0	0.0	1.0	82.0	75.0	157.0	147	0	3	6	0	0	1	82	75	157
3012352	SD	school	4600002	25004	Milbank 25-4	460000200424	1	Milbank High School	Regular School	No	High	09	12	2017	grade_12	83.0		6.0	0.0		0.0	0.0	43.0	46.0	89.0	83		6	0		0	0	43	46	89
3012402	SD	school	4647942	29004	Miller	464794200429	2	Miller Elementary School	Regular School	No	Elementary	KG	06	2017	grade_12	0.0	0.0	0.0	0.0	0.0	0.0		0.0	0.0	0.0	0	0	0	0	0	0		0	0	0
3012479	SD	school	4648390	17002	Mitchell 17-2	464839000437	2	Mitchell Middle School	Regular School	No	Middle	06	08	2017	grade_12	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0	0	0	0	0	0	0	0	0	0
3012801	SD	school	4650850	9002	Newell 09-2	465085000968	4	Newell Middle Sch	Regular School	No	Middle	06	08	2017	grade_12	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0	0	0	0	0	0	0	0	0	0
3012848	SD	school	4651750	56007	Northwestern Area 56-7	465175000475	1	Northwestern High School	Regular School	No	High	09	12	2017	grade_12	12.0					0.0	0.0	6.0	6.0	12.0	12					0	0	6	6	12
3013119	SD	school	4654270	60004	Parker 60-4	465427000487	2	Parker Elementary School	Regular School	No	Elementary	PK	06	2017	grade_12	0.0	0.0	0.0	0.0		0.0	0.0	0.0	0.0	0.0	0	0	0	0		0	0	0	0	0
3013120	SD	school	4654270	60004	Parker 60-4	465427000488	1	Parker High School	Regular School	No	High	09	12	2017	grade_12	21.0	0.0	0.0	0.0		0.0	0.0	7.0	14.0	21.0	21	0	0	0		0	0	7	14	21
3013273	SD	school	4655260	32002	Pierre 32-2	465526000500	1	T F Riggs High School	Regular School	No	High	09	12	2017	grade_12	161.0	3.0	4.0	17.0	1.0	0.0	3.0	103.0	86.0	189.0	161	3	4	17	1	0	3	103	86	189
3013570	SD	school	4659820	51004	Rapid City Area 51-4	465982000540	4	Canyon Lake Elem	Regular School	No	Elementary	PK	05	2017	grade_12	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0	0	0	0	0	0	0	0	0	0
3013575	SD	school	4659820	51004	Rapid City Area 51-4	465982000548	6	Grandview Elem	Regular School	No	Elementary	KG	05	2017	grade_12	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0	0	0	0	0	0	0	0	0	0
3013578	SD	school	4659820	51004	Rapid City Area 51-4	465982000539	8	Knollwood Heights Elem	Regular School	No	Elementary	KG	05	2017	grade_12	0.0		0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0		0	0	0	0	0	0	0	0
3013580	SD	school	4659820	51004	Rapid City Area 51-4	465982000549	10	Meadowbrook Elem	Regular School	No	Elementary	KG	05	2017	grade_12	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0	0	0	0	0	0	0	0	0	0
3013584	SD	school	4659820	51004	Rapid City Area 51-4	465982000823	12	Rapid Valley Elem	Regular School	No	Elementary	PK	05	2017	grade_12	0.0	0.0	0.0	0.0		0.0	0.0	0.0	0.0	0.0	0	0	0	0		0	0	0	0	0
3013585	SD	school	4659820	51004	Rapid City Area 51-4	465982000541	14	Robbinsdale Elem	Regular School	No	Elementary	PK	05	2017	grade_12	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0	0	0	0	0	0	0	0	0	0
3013591	SD	school	4659820	51004	Rapid City Area 51-4	465982000969	13	Valley View Elem	Regular School	No	Elementary	KG	05	2017	grade_12	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0	0	0	0	0	0	0	0	0	0
3014100	SD	school	4603932	55005	Sanborn Central 55-5	460393200102	2	Sanborn Central Middle School	Regular School	No	Middle	06	08	2017	grade_12	0.0		0.0	0.0		0.0	0.0	0.0	0.0	0.0	0		0	0		0	0	0	0	0
3014376	SD	school	4666270	49005	Sioux Falls 49-5	466627000581	14	Cleveland Elementary	Regular School	No	Elementary	PK	05	2017	grade_12	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0	0	0	0	0	0	0	0	0	0
3014379	SD	school	4666270	49005	Sioux Falls 49-5	466627000583	6	Edison Middle School	Regular School	No	Middle	06	08	2017	grade_12	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0	0	0	0	0	0	0	0	0	0
3014383	SD	school	4666270	49005	Sioux Falls 49-5	466627000587	19	Garfield Elementary	Regular School	No	Elementary	PK	05	2017	grade_12	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0	0	0	0	0	0	0	0	0	0
3014384	SD	school	4666270	49005	Sioux Falls 49-5	466627001333	9	George McGovern Middle School	Regular School	No	Middle	06	08	2017	grade_12	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0	0	0	0	0	0	0	0	0	0
3014389	SD	school	4666270	49005	Sioux Falls 49-5	466627001064	23	John Harris Elementary	Regular School	No	Elementary	PK	05	2017	grade_12	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0	0	0	0	0	0	0	0	0	0
3014397	SD	school	4666270	49005	Sioux Falls 49-5	466627000813	58	Oscar Howe Elementary	Regular School	No	Elementary	KG	05	2017	grade_12	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0	0	0	0	0	0	0	0	0	0
3014399	SD	school	4666270	49005	Sioux Falls 49-5	466627001300	17	R. F. Pettigrew Elementary	Regular School	No	Elementary	PK	05	2017	grade_12	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0	0	0	0	0	0	0	0	0	0
3014400	SD	school	4666270	49005	Sioux Falls 49-5	466627000606	42	Renberg Elementary	Regular School	No	Elementary	KG	05	2017	grade_12	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0	0	0	0	0	0	0	0	0	0
3014401	SD	school	4666270	49005	Sioux Falls 49-5	466627000607	18	Robert Frost Elementary	Regular School	No	Elementary	PK	05	2017	grade_12	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0	0	0	0	0	0	0	0	0	0
3014404	SD	school	4666270	49005	Sioux Falls 49-5	466627001344	65	Sonia Sotomayor Elementary	Career and Technical School	No	Elementary	PK	05	2017	grade_12	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0	0	0	0	0	0	0	0	0	0
3014410	SD	school	4666270	49005	Sioux Falls 49-5	466627001351	66	Susan B. Anthony Elementary	Regular School	No	Elementary	KG	05	2017	grade_12	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0	0	0	0	0	0	0	0	0	0
3014412	SD	school	4666270	49005	Sioux Falls 49-5	466627000610	1	Washington High School	Regular School	No	High	09	12	2017	grade_12	278.0	66.0	26.0	14.0	41.0	0.0	12.0	230.0	207.0	437.0	278	66	26	14	41	0	12	230	207	437
3014413	SD	school	4666270	49005	Sioux Falls 49-5	466627000611	8	Whittier Middle School	Regular School	No	Middle	06	08	2017	grade_12	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0	0	0	0	0	0	0	0	0	0
3015071	SD	school	4607670	26005	South Central 26-5	460767000882	3	South Central Elementary	Regular School	No	Elementary	PK	05	2017	grade_12	0.0			0.0		0.0	0.0	0.0	0.0	0.0	0			0		0	0	0	0	0
3015136	SD	school	4666930	40002	Spearfish 40-2	466693000622	5	Spearfish MS	Regular School	No	Middle	06	08	2017	grade_12	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0	0	0	0	0	0	0	0	0	0
3015137	SD	school	4666930	40002	Spearfish 40-2	466693000392	3	West Elementary	Regular School	No	Elementary	01	02	2017	grade_12	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0	0	0	0	0	0	0	0	0	0
3015235	SD	school	4624850	57001	Stanley County 57-1	462485000213	8	Stanley County Elementary	Regular School	No	Elementary	KG	05	2017	grade_12	0.0	0.0	0.0	0.0		0.0	0.0	0.0	0.0	0.0	0	0	0	0		0	0	0	0	0
3015332	SD	school	4600052	41005	Tea Area 41-5	460005200853	2	Tea Area Intermediate/Middle School	Regular School	No	Middle	05	08	2017	grade_12	0.0	0.0	0.0	0.0		0.0	0.0	0.0	0.0	0.0	0	0	0	0		0	0	0	0	0
3015471	SD	school	4672090	66001	Todd County 66-1	467209001349	16	Todd County Elem	Regular School	No	Elementary	KG	05	2017	grade_12	0.0		0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0		0	0	0	0	0	0	0	0
3015747	SD	school	4674370	13001	Vermillion 13-1	467437000301	4	Jolley Elementary School	Regular School	No	Elementary	02	05	2017	grade_12	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0	0	0	0	0	0	0	0	0	0
3015748	SD	school	4674370	13001	Vermillion 13-1	467437000691	1	Vermillion High School	Regular School	No	High	09	12	2017	grade_12	72.0	1.0	2.0	5.0	3.0	0.0	2.0	43.0	42.0	85.0	72	1	2	5	3	0	2	43	42	85
3015811	SD	school	4674520	60006	Viborg-Hurley 60-6	467452000692	2	Viborg-Hurley Elementary	Regular School	No	Elementary	PK	04	2017	grade_12	0.0	0.0	0.0	0.0		0.0	0.0	0.0	0.0	0.0	0	0	0	0		0	0	0	0	0
3016064	SD	school	4676620	14004	Watertown 14-4	467662000713	6	McKinley Elementary School	Regular School	No	Elementary	PK	04	2017	grade_12	0.0		0.0	0.0		0.0	0.0	0.0	0.0	0.0	0		0	0		0	0	0	0	0
3016271	SD	school	4676990	18005	Webster Area	467699000723	3	Webster Area Elementary School	Regular School	No	Elementary	PK	05	2017	grade_12	0.0		0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0		0	0	0	0	0	0	0	0
3016463	SD	school	4678510	1003	White Lake 01-3	467851000745	2	White Lake Elementary	Regular School	No	Elementary	PK	06	2017	grade_12	0.0	0.0	0.0			0.0		0.0	0.0	0.0	0	0	0			0		0	0	0
3016516	SD	school	4678570	47001	White River 47-1	467857000754	1	White River High School	Regular School	No	High	09	12	2017	grade_12	4.0	1.0		24.0	0.0	0.0	0.0	15.0	14.0	29.0	4	1		24	0	0	0	15	14	29
3016720	SD	school	4679710	59002	Winner 59-2	467971000781	1	Winner High School	Regular School	No	High	09	12	2017	grade_12	39.0	0.0	0.0	14.0		0.0	1.0	31.0	23.0	54.0	39	0	0	14		0	1	31	23	54
3016858	SD	school	4680430	63003	Yankton 63-3	468043000795	5	Stewart Elem	Regular School	No	Elementary	KG	05	2017	grade_12	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0	0	0	0	0	0	0	0	0	0
3009904	SD	school	4629880	26004	Gregory 26-4	462988000239	1	Gregory High School	Regular School	No	High	09	12	2017	grade_12	26.0		0.0	2.0	0.0	1.0	0.0	15.0	14.0	29.0	26		0	2	0	1	0	15	14	29
3014402	SD	school	4666270	49005	Sioux Falls 49-5	466627001063	3	Roosevelt High School	Regular School	No	High	09	12	2017	grade_12	359.0	42.0	50.0	19.0	15.0	1.0	12.0	251.0	247.0	498.0	359	42	50	19	15	1	12	251	247	498
3011506	SD	school	4641300	40001	Lead-Deadwood 40-1	464130001145	10	Lead-Deadwood Career & Tech Ed	Alternative School	No	High	09	12	2017	grade_12	6.0	2.0	1.0	3.0	1.0	2.0	0.0	9.0	6.0	15.0	6	2	1	3	1	2	0	9	6	15
3006260	SD	school	4602070	6001	Aberdeen 06-1	460207000002	5	C.C. Lee Elementary	Regular School	No	Elementary	KG	05	2017	grade_12	0.0	0.0	0.0	0.0	0.0		0.0	0.0	0.0	0.0	0	0	0	0	0		0	0	0	0
3006262	SD	school	4602070	6001	Aberdeen 06-1	460207000005	2	Holgate Middle School	Regular School	No	Middle	06	08	2017	grade_12	0.0	0.0	0.0	0.0	0.0		0.0	0.0	0.0	0.0	0	0	0	0	0		0	0	0	0
3006263	SD	school	4602070	6001	Aberdeen 06-1	460207000007	8	Lincoln Elementary	Regular School	No	Elementary	PK	05	2017	grade_12	0.0	0.0	0.0	0.0	0.0		0.0	0.0	0.0	0.0	0	0	0	0	0		0	0	0	0
3006266	SD	school	4602070	6001	Aberdeen 06-1	460207001130	89	New Beginnings	Alternative School	No	Other	05	12	2017	grade_12	0.0	0.0	0.0	0.0				0.0	0.0	0.0	0	0	0	0				0	0	0
3006267	SD	school	4602070	6001	Aberdeen 06-1	460207000009	11	O.M. Tiffany Elementary	Regular School	No	Elementary	KG	05	2017	grade_12	0.0	0.0	0.0	0.0	0.0		0.0	0.0	0.0	0.0	0	0	0	0	0		0	0	0	0
3006402	SD	school	4600042	58003	Agar-Blunt-Onida 58-3	460004200855	3	Blunt Elementary	Regular School	No	Elementary	KG	05	2017	grade_12	0.0		0.0	0.0			0.0	0.0	0.0	0.0	0		0	0			0	0	0	0
3006403	SD	school	4600042	58003	Agar-Blunt-Onida 58-3	460004200655	4	Onida Elementary	Regular School	No	Elementary	KG	06	2017	grade_12	0.0		0.0	0.0	0.0		0.0	0.0	0.0	0.0	0		0	0	0		0	0	0	0
3006404	SD	school	4600042	58003	Agar-Blunt-Onida 58-3	460004200656	7	Sully Buttes High School	Regular School	No	High	09	12	2017	grade_12	23.0		1.0	0.0	0.0		1.0	13.0	12.0	25.0	23		1	0	0		1	13	12	25
3006405	SD	school	4600042	58003	Agar-Blunt-Onida 58-3	460004200939	6	Sully Buttes Junior High	Regular School	No	Middle	07	08	2017	grade_12	0.0		0.0	0.0			0.0	0.0	0.0	0.0	0		0	0			0	0	0	0
3006463	SD	school	4600028	61001	Alcester-Hudson 61-1	460002800013	4	Alcester-Hudson Elementary	Regular School	No	Elementary	PK	06	2017	grade_12	0.0		0.0	0.0	0.0		0.0	0.0	0.0	0.0	0		0	0	0		0	0	0	0
3006464	SD	school	4600028	61001	Alcester-Hudson 61-1	460002800014	1	Alcester-Hudson High School	Regular School	No	High	09	12	2017	grade_12	14.0	0.0	1.0		0.0			9.0	6.0	15.0	14	0	1		0			9	6	15
3006465	SD	school	4600028	61001	Alcester-Hudson 61-1	460002800874	3	Alcester-Hudson JH	Regular School	No	Middle	07	08	2017	grade_12	0.0		0.0				0.0	0.0	0.0	0.0	0		0				0	0	0	0
3006515	SD	school	4639540	11001	Andes Central 11-1	463954000360	1	Andes Central High School	Regular School	No	High	09	12	2017	grade_12	3.0			8.0			0.0	7.0	4.0	11.0	3			8			0	7	4	11
3006516	SD	school	4639540	11001	Andes Central 11-1	463954000850	4	Andes Central Jr High	Regular School	No	Middle	07	08	2017	grade_12	0.0		0.0	0.0			0.0	0.0	0.0	0.0	0		0	0			0	0	0	0
3006517	SD	school	4639540	11001	Andes Central 11-1	463954001080	5	Lakeview Colony Elem	Regular School	No	Elementary	KG	08	2017	grade_12	0.0							0.0	0.0	0.0	0							0	0	0
3006578	SD	school	4603720	38001	Arlington 38-1	460372000021	2	Arlington Elementary	Regular School	No	Elementary	PK	06	2017	grade_12	0.0	0.0	0.0	0.0	0.0		0.0	0.0	0.0	0.0	0	0	0	0	0		0	0	0	0
3006579	SD	school	4603720	38001	Arlington 38-1	460372000022	1	Arlington High School	Regular School	No	High	09	12	2017	grade_12	23.0		0.0				0.0	10.0	13.0	23.0	23		0				0	10	13	23
3006580	SD	school	4603720	38001	Arlington 38-1	460372000877	3	Arlington Junior High School	Regular School	No	Middle	07	08	2017	grade_12	0.0		0.0					0.0	0.0	0.0	0		0					0	0	0