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 (asian_int > :p3 or (asian_int = :p3 and rowid > :p2)) order by asian_int, rowid 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	pacific_islander	multiracial	male	female	total	white_int	black_int	hispanic_int	native_american_int	pacific_islander_int	multiracial_int	male_int	female_int	total_int
254558	SD	school	4636060	22006	Ipswich Public 22-6	463606000332	2	Ipswich Elem	Regular School	No	Elementary	PK	05	2018	grade_6	0.0	0.0	0.0	0.0		0.0	0.0	0.0	0.0	0	0	0	0		0	0	0	0
254559	SD	school	4636060	22006	Ipswich Public 22-6	463606000333	1	Ipswich Hi Sch	Regular School	No	High	09	12	2018	grade_6	0.0		0.0			0.0	0.0	0.0	0.0	0		0			0	0	0	0
254686	SD	school	4636150	2003	Iroquois 02-3	463615000339	1	Iroquois High School	Regular School	No	High	09	12	2018	grade_6	0.0	0.0	0.0	0.0			0.0	0.0	0.0	0	0	0	0			0	0	0
255085	SD	school	4641300	40001	Lead-Deadwood 40-1	464130001145	10	Lead-Deadwood Career & Tech Ed	Alternative School	No	High	09	12	2018	grade_6	0.0	0.0	0.0	0.0		0.0	0.0	0.0	0.0	0	0	0	0		0	0	0	0
255086	SD	school	4641300	40001	Lead-Deadwood 40-1	464130000372	3	Lead-Deadwood Elementary	Regular School	No	Elementary	KG	05	2018	grade_6	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0	0	0	0	0	0	0	0	0
255087	SD	school	4641300	40001	Lead-Deadwood 40-1	464130000374	1	Lead-Deadwood High School	Regular School	No	High	09	12	2018	grade_6	0.0	0.0	0.0	0.0		0.0	0.0	0.0	0.0	0	0	0	0		0	0	0	0
255088	SD	school	4641300	40001	Lead-Deadwood 40-1	464130000373	2	Lead-Deadwood Middle School	Regular School	No	Middle	06	08	2018	grade_6	58.0	1.0	3.0	3.0		8.0	36.0	37.0	73.0	58	1	3	3		8	36	37	73
255205	SD	school	4641550	41004	Lennox 41-4	464155000386	2	Lennox Elementary	Regular School	No	Elementary	PK	04	2018	grade_6	0.0	0.0	0.0	0.0		0.0	0.0	0.0	0.0	0	0	0	0		0	0	0	0
255206	SD	school	4641550	41004	Lennox 41-4	464155000387	1	Lennox High School	Regular School	No	High	09	12	2018	grade_6	0.0	0.0	0.0	0.0		0.0	0.0	0.0	0.0	0	0	0	0		0	0	0	0
255429	SD	school	4639600	39002	Madison Central 39-2	463960001189	7	Madison Elementary School	Regular School	No	Elementary	KG	05	2018	grade_6	0.0	0.0	0.0	0.0		0.0	0.0	0.0	0.0	0	0	0	0		0	0	0	0
255430	SD	school	4639600	39002	Madison Central 39-2	463960000363	1	Madison High School	Regular School	No	High	09	12	2018	grade_6	0.0	0.0	0.0	0.0		0.0	0.0	0.0	0.0	0	0	0	0		0	0	0	0
255590	SD	school	4646260	15001	McIntosh 15-1	464626000411	1	McIntosh High School	Regular School	No	High	09	12	2018	grade_6	0.0	0.0	0.0	0.0		0.0	0.0	0.0	0.0	0	0	0	0		0	0	0	0
255754	SD	school	4669930	46001	Meade 46-1	466993000644	5	Piedmont Valley Elementary	Regular School	No	Elementary	KG	06	2018	grade_6	72.0	0.0	0.0	1.0		2.0	39.0	36.0	75.0	72	0	0	1		2	39	36	75
255756	SD	school	4669930	46001	Meade 46-1	466993000637	3	Sturgis Elementary	Regular School	No	Elementary	KG	04	2018	grade_6	0.0	0.0	0.0	0.0		0.0	0.0	0.0	0.0	0	0	0	0		0	0	0	0
255757	SD	school	4669930	46001	Meade 46-1	466993001383	6	Sturgis Intermediate School	Regular School	No	Middle	05	05	2018	grade_6	0.0		0.0	0.0		0.0	0.0	0.0	0.0	0		0	0		0	0	0	0
255758	SD	school	4669930	46001	Meade 46-1	466993000653	2	Sturgis Williams MS	Regular School	No	Middle	06	08	2018	grade_6	133.0	1.0	4.0	12.0		8.0	92.0	66.0	158.0	133	1	4	12		8	92	66	158
255998	SD	school	4647942	29004	Miller	464794200430	1	Miller High School	Regular School	No	High	09	12	2018	grade_6	0.0					0.0	0.0	0.0	0.0	0					0	0	0	0
255999	SD	school	4647942	29004	Miller	464794201051	4	Miller Junior High	Regular School	No	Middle	07	08	2018	grade_6	0.0	0.0				0.0	0.0	0.0	0.0	0	0				0	0	0	0
256085	SD	school	4648390	17002	Mitchell 17-2	464839000591	4	Gertie Belle Rogers Elem	Regular School	No	Elementary	KG	05	2018	grade_6	0.0	0.0	0.0	0.0		0.0	0.0	0.0	0.0	0	0	0	0		0	0	0	0
256086	SD	school	4648390	17002	Mitchell 17-2	464839000520	3	L B Williams Elementary	Regular School	No	Elementary	KG	05	2018	grade_6	0.0	0.0	0.0	0.0		0.0	0.0	0.0	0.0	0	0	0	0		0	0	0	0
256088	SD	school	4648390	17002	Mitchell 17-2	464839000442	1	Mitchell High School	Regular School	No	High	09	12	2018	grade_6	0.0	0.0	0.0	0.0		0.0	0.0	0.0	0.0	0	0	0	0		0	0	0	0
256173	SD	school	4680441	62006	Mobridge-Pollock 62-6	468044100486	3	Freeman Davis Elementary	Regular School	No	Elementary	KG	02	2018	grade_6	0.0	0.0	0.0	0.0			0.0	0.0	0.0	0	0	0	0			0	0	0
256176	SD	school	4680441	62006	Mobridge-Pollock 62-6	468044100493	4	Mobridge Upper Elementary	Regular School	No	Elementary	03	05	2018	grade_6	0.0	0.0	0.0	0.0			0.0	0.0	0.0	0	0	0	0			0	0	0
256237	SD	school	4648780	43002	Montrose 43-2	464878000451	2	Montrose Elementary School	Regular School	No	Elementary	PK	05	2018	grade_6	0.0	0.0	0.0				0.0	0.0	0.0	0	0	0				0	0	0
256239	SD	school	4648780	43002	Montrose 43-2	464878000966	3	Montrose Middle School	Regular School	No	Middle	06	08	2018	grade_6	11.0	1.0	0.0				7.0	5.0	12.0	11	1	0				7	5	12
256768	SD	school	4654300	33003	Parkston 33-3	465430000491	2	Parkston Elementary	Regular School	No	Elementary	PK	06	2018	grade_6	28.0		1.0	0.0		1.0	14.0	16.0	30.0	28		1	0		1	14	16	30
256853	SD	school	4655260	32002	Pierre 32-2	465526000494	3	Buchanan Elementary	Regular School	No	Elementary	KG	05	2018	grade_6	0.0	0.0	0.0	0.0		0.0	0.0	0.0	0.0	0	0	0	0		0	0	0	0
256854	SD	school	4655260	32002	Pierre 32-2	465526000501	2	Georgia Morse Middle School	Regular School	No	Middle	06	08	2018	grade_6	155.0	2.0	15.0	33.0		15.0	115.0	105.0	220.0	155	2	15	33		15	115	105	220
256856	SD	school	4655260	32002	Pierre 32-2	465526001353	8	Kennedy Elementary School	Regular School	No	Elementary	KG	05	2018	grade_6	0.0	0.0	0.0	0.0		0.0	0.0	0.0	0.0	0	0	0	0		0	0	0	0
256857	SD	school	4655260	32002	Pierre 32-2	465526000500	1	T F Riggs High School	Regular School	No	High	09	12	2018	grade_6	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0	0	0	0	0	0	0	0	0
257254	SD	school	4659820	51004	Rapid City Area 51-4	465982000540	4	Canyon Lake Elem	Regular School	No	Elementary	PK	05	2018	grade_6	0.0	0.0	0.0	0.0		0.0	0.0	0.0	0.0	0	0	0	0		0	0	0	0
257255	SD	school	4659820	51004	Rapid City Area 51-4	465982000529	41	Central Hi Sch	Regular School	No	High	09	12	2018	grade_6	0.0	0.0	0.0	0.0		0.0	0.0	0.0	0.0	0	0	0	0		0	0	0	0
257256	SD	school	4659820	51004	Rapid City Area 51-4	465982000542	21	Corral Drive Elem	Regular School	No	Elementary	KG	05	2018	grade_6	0.0	0.0	0.0	0.0		0.0	0.0	0.0	0.0	0	0	0	0		0	0	0	0
257258	SD	school	4659820	51004	Rapid City Area 51-4	465982000536	1	General Beadle Elem	Regular School	No	Elementary	PK	05	2018	grade_6	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0	0	0	0	0	0	0	0	0
257259	SD	school	4659820	51004	Rapid City Area 51-4	465982000548	6	Grandview Elem	Regular School	No	Elementary	KG	05	2018	grade_6	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0	0	0	0	0	0	0	0	0
257260	SD	school	4659820	51004	Rapid City Area 51-4	465982000550	7	Horace Mann Elem	Regular School	No	Elementary	KG	05	2018	grade_6	0.0	0.0	0.0	0.0		0.0	0.0	0.0	0.0	0	0	0	0		0	0	0	0
257262	SD	school	4659820	51004	Rapid City Area 51-4	465982000539	8	Knollwood Heights Elem	Regular School	No	Elementary	KG	05	2018	grade_6	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0	0	0	0	0	0	0	0	0
257263	SD	school	4659820	51004	Rapid City Area 51-4	465982001341	44	Lincoln Building	Special Education School	No	High	12	12	2018	grade_6	0.0		0.0	0.0		0.0	0.0	0.0	0.0	0		0	0		0	0	0	0
257264	SD	school	4659820	51004	Rapid City Area 51-4	465982000549	10	Meadowbrook Elem	Regular School	No	Elementary	KG	05	2018	grade_6	0.0	0.0	0.0	0.0		0.0	0.0	0.0	0.0	0	0	0	0		0	0	0	0
257265	SD	school	4659820	51004	Rapid City Area 51-4	465982000532	35	North Middle Sch	Regular School	No	Middle	06	08	2018	grade_6	44.0	2.0	16.0	114.0	0.0	16.0	98.0	94.0	192.0	44	2	16	114	0	16	98	94	192
257266	SD	school	4659820	51004	Rapid City Area 51-4	465982000547	11	Pinedale Elem	Regular School	No	Elementary	KG	05	2018	grade_6	0.0		0.0	0.0		0.0	0.0	0.0	0.0	0		0	0		0	0	0	0
257267	SD	school	4659820	51004	Rapid City Area 51-4	465982001340	45	Rapid City HS	Alternative School	No	High	09	12	2018	grade_6	0.0	0.0	0.0	0.0		0.0	0.0	0.0	0.0	0	0	0	0		0	0	0	0
257268	SD	school	4659820	51004	Rapid City Area 51-4	465982000823	12	Rapid Valley Elem	Regular School	No	Elementary	PK	05	2018	grade_6	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0	0	0	0	0	0	0	0	0
257269	SD	school	4659820	51004	Rapid City Area 51-4	465982000541	14	Robbinsdale Elem	Regular School	No	Elementary	PK	05	2018	grade_6	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0	0	0	0	0	0	0	0	0
257270	SD	school	4659820	51004	Rapid City Area 51-4	465982000527	15	South Canyon Elem	Regular School	No	Elementary	KG	05	2018	grade_6	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0	0	0	0	0	0	0	0	0
257271	SD	school	4659820	51004	Rapid City Area 51-4	465982000533	36	South Middle Sch	Regular School	No	Middle	06	08	2018	grade_6	124.0	1.0	19.0	73.0		17.0	119.0	115.0	234.0	124	1	19	73		17	119	115	234
257272	SD	school	4659820	51004	Rapid City Area 51-4	465982000824	16	South Park Elem	Regular School	No	Elementary	KG	05	2018	grade_6	0.0	0.0	0.0	0.0		0.0	0.0	0.0	0.0	0	0	0	0		0	0	0	0
257274	SD	school	4659820	51004	Rapid City Area 51-4	465982000525	42	Stevens Hi Sch	Regular School	No	High	09	12	2018	grade_6	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0	0	0	0	0	0	0	0	0
257275	SD	school	4659820	51004	Rapid City Area 51-4	465982000969	13	Valley View Elem	Regular School	No	Elementary	KG	05	2018	grade_6	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0	0	0	0	0	0	0	0	0
257276	SD	school	4659820	51004	Rapid City Area 51-4	465982000822	37	West Middle Sch	Regular School	No	Middle	06	08	2018	grade_6	160.0	4.0	20.0	18.0		21.0	115.0	108.0	223.0	160	4	20	18		21	115	108	223
257277	SD	school	4659820	51004	Rapid City Area 51-4	465982000530	17	Woodrow Wilson Elem	Regular School	No	Elementary	KG	05	2018	grade_6	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0	0	0	0	0	0	0	0	0
257486	SD	school	4660450	56004	Redfield 56-4	466045000551	3	Redfield Elementary School	Regular School	No	Elementary	PK	06	2018	grade_6	44.0	2.0	1.0	2.0			30.0	19.0	49.0	44	2	1	2			30	19	49
258151	SD	school	4666270	49005	Sioux Falls 49-5	466627000770	20	Anne Sullivan Elementary	Regular School	No	Elementary	PK	05	2018	grade_6	0.0	0.0	0.0	0.0		0.0	0.0	0.0	0.0	0	0	0	0		0	0	0	0
258154	SD	school	4666270	49005	Sioux Falls 49-5	466627001129	51	Challenge Center	Regular School	No	Elementary	02	05	2018	grade_6	0.0	0.0	0.0	0.0		0.0	0.0	0.0	0.0	0	0	0	0		0	0	0	0
258155	SD	school	4666270	49005	Sioux Falls 49-5	466627000581	14	Cleveland Elementary	Regular School	No	Elementary	PK	05	2018	grade_6	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0	0	0	0	0	0	0	0	0
258156	SD	school	4666270	49005	Sioux Falls 49-5	466627001122	41	Community Campus	Special Education School	No	High	12	12	2018	grade_6	0.0	0.0	0.0	0.0			0.0	0.0	0.0	0	0	0	0			0	0	0
258157	SD	school	4666270	49005	Sioux Falls 49-5	466627001238	26	Discovery Elementary	Regular School	No	Elementary	PK	05	2018	grade_6	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0	0	0	0	0	0	0	0	0
258159	SD	school	4666270	49005	Sioux Falls 49-5	466627001175	43	Elem. Immersion Center	Regular School	No	Elementary	KG	05	2018	grade_6		0.0	0.0				0.0	0.0	0.0		0	0				0	0	0
258160	SD	school	4666270	49005	Sioux Falls 49-5	466627000585	16	Eugene Field A+ Elementary	Regular School	No	Elementary	KG	05	2018	grade_6	0.0	0.0	0.0	0.0		0.0	0.0	0.0	0.0	0	0	0	0		0	0	0	0
258162	SD	school	4666270	49005	Sioux Falls 49-5	466627000587	19	Garfield Elementary	Regular School	No	Elementary	PK	05	2018	grade_6	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0	0	0	0	0	0	0	0	0
258164	SD	school	4666270	49005	Sioux Falls 49-5	466627000588	54	Harvey Dunn Elementary	Regular School	No	Elementary	PK	05	2018	grade_6	0.0	0.0	0.0	0.0		0.0	0.0	0.0	0.0	0	0	0	0		0	0	0	0
258165	SD	school	4666270	49005	Sioux Falls 49-5	466627000936	56	Hawthorne Elementary	Regular School	No	Elementary	PK	05	2018	grade_6	0.0	0.0	0.0	0.0		0.0	0.0	0.0	0.0	0	0	0	0		0	0	0	0
258166	SD	school	4666270	49005	Sioux Falls 49-5	466627000590	38	Hayward Elementary	Regular School	No	Elementary	PK	05	2018	grade_6	0.0	0.0	0.0	0.0		0.0	0.0	0.0	0.0	0	0	0	0		0	0	0	0
258167	SD	school	4666270	49005	Sioux Falls 49-5	466627000976	57	John F Kennedy Elementary	Regular School	No	Elementary	KG	05	2018	grade_6	0.0	0.0	0.0	0.0		0.0	0.0	0.0	0.0	0	0	0	0		0	0	0	0
258168	SD	school	4666270	49005	Sioux Falls 49-5	466627001064	23	John Harris Elementary	Regular School	No	Elementary	PK	05	2018	grade_6	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0	0	0	0	0	0	0	0	0
258169	SD	school	4666270	49005	Sioux Falls 49-5	466627000597	10	Laura B. Anderson Elementary	Regular School	No	Elementary	PK	05	2018	grade_6	0.0	0.0	0.0	0.0		0.0	0.0	0.0	0.0	0	0	0	0		0	0	0	0
258170	SD	school	4666270	49005	Sioux Falls 49-5	466627000598	31	Laura Wilder Elementary	Regular School	No	Elementary	KG	05	2018	grade_6	0.0	0.0	0.0	0.0		0.0	0.0	0.0	0.0	0	0	0	0		0	0	0	0
258171	SD	school	4666270	49005	Sioux Falls 49-5	466627000600	2	Lincoln High School	Regular School	No	High	09	12	2018	grade_6	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0	0	0	0	0	0	0	0	0
258172	SD	school	4666270	49005	Sioux Falls 49-5	466627000602	28	Lowell Elementary	Regular School	No	Elementary	PK	05	2018	grade_6	0.0	0.0	0.0	0.0		0.0	0.0	0.0	0.0	0	0	0	0		0	0	0	0
258175	SD	school	4666270	49005	Sioux Falls 49-5	466627001303	30	New Technology High School	Regular School	No	High	09	12	2018	grade_6	0.0	0.0	0.0	0.0		0.0	0.0	0.0	0.0	0	0	0	0		0	0	0	0
258176	SD	school	4666270	49005	Sioux Falls 49-5	466627000813	58	Oscar Howe Elementary	Regular School	No	Elementary	KG	05	2018	grade_6	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0	0	0	0	0	0	0	0	0
258178	SD	school	4666270	49005	Sioux Falls 49-5	466627001300	17	R. F. Pettigrew Elementary	Regular School	No	Elementary	PK	05	2018	grade_6	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0	0	0	0	0	0	0	0	0
258179	SD	school	4666270	49005	Sioux Falls 49-5	466627000606	42	Renberg Elementary	Regular School	No	Elementary	KG	05	2018	grade_6	0.0	0.0	0.0	0.0		0.0	0.0	0.0	0.0	0	0	0	0		0	0	0	0
258180	SD	school	4666270	49005	Sioux Falls 49-5	466627000607	18	Robert Frost Elementary	Regular School	No	Elementary	PK	05	2018	grade_6	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0	0	0	0	0	0	0	0	0
258181	SD	school	4666270	49005	Sioux Falls 49-5	466627001063	3	Roosevelt High School	Regular School	No	High	09	12	2018	grade_6	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0	0	0	0	0	0	0	0	0
258182	SD	school	4666270	49005	Sioux Falls 49-5	466627001275	15	Rosa Parks Elementary	Regular School	No	Elementary	KG	05	2018	grade_6	0.0	0.0	0.0	0.0		0.0	0.0	0.0	0.0	0	0	0	0		0	0	0	0
258183	SD	school	4666270	49005	Sioux Falls 49-5	466627001344	65	Sonia Sotomayor Elementary	Career and Technical School	No	Elementary	PK	05	2018	grade_6	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0	0	0	0	0	0	0	0	0
258188	SD	school	4666270	49005	Sioux Falls 49-5	466627001351	66	Susan B. Anthony Elementary	Regular School	No	Elementary	KG	05	2018	grade_6	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0	0	0	0	0	0	0	0	0
258189	SD	school	4666270	49005	Sioux Falls 49-5	466627000579	11	Terry Redlin Elementary	Regular School	No	Elementary	PK	05	2018	grade_6	0.0	0.0	0.0	0.0		0.0	0.0	0.0	0.0	0	0	0	0		0	0	0	0
258190	SD	school	4666270	49005	Sioux Falls 49-5	466627000610	1	Washington High School	Regular School	No	High	09	12	2018	grade_6	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0	0	0	0	0	0	0	0	0
258518	SD	school	4666300	5005	Sioux Valley 05-5	466630000612	1	Sioux Valley High School	Regular School	No	High	09	12	2018	grade_6	0.0		0.0	0.0		0.0	0.0	0.0	0.0	0		0	0		0	0	0	0
258565	SD	school	4600053	54002	Sisseton 54-2	460005301239	1	Sisseton High School	Regular School	No	High	09	12	2018	grade_6	0.0	0.0	0.0	0.0		0.0	0.0	0.0	0.0	0	0	0	0		0	0	0	0
258566	SD	school	4600053	54002	Sisseton 54-2	460005301258	2	Sisseton Middle School	Regular School	No	Middle	06	08	2018	grade_6	13.0	1.0	3.0	56.0		5.0	44.0	34.0	78.0	13	1	3	56		5	44	34	78
258750	SD	school	4666930	40002	Spearfish 40-2	466693000401	7	Creekside Elem	Regular School	No	Elementary	03	05	2018	grade_6	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0	0	0	0	0	0	0	0	0
258754	SD	school	4666930	40002	Spearfish 40-2	466693000623	1	Spearfish High School	Regular School	No	High	09	12	2018	grade_6	0.0	0.0	0.0	0.0		0.0	0.0	0.0	0.0	0	0	0	0		0	0	0	0
258756	SD	school	4666930	40002	Spearfish 40-2	466693000392	3	West Elementary	Regular School	No	Elementary	01	02	2018	grade_6	0.0	0.0	0.0	0.0		0.0	0.0	0.0	0.0	0	0	0	0		0	0	0	0
258941	SD	school	4600052	41005	Tea Area 41-5	460005201358	5	Tea Area Frontier Elementary	Regular School	No	Elementary	KG	04	2018	grade_6	0.0	0.0	0.0	0.0		0.0	0.0	0.0	0.0	0	0	0	0		0	0	0	0
258943	SD	school	4600052	41005	Tea Area 41-5	460005200388	1	Tea Area Legacy Elementary	Regular School	No	Elementary	KG	04	2018	grade_6	0.0	0.0	0.0	0.0		0.0	0.0	0.0	0.0	0	0	0	0		0	0	0	0
259118	SD	school	4672090	66001	Todd County 66-1	467209000503	8	Klein Elementary	Regular School	No	Elementary	KG	08	2018	grade_6	0.0		0.0	1.0			0.0	1.0	1.0	0		0	1			0	1	1
259127	SD	school	4672090	66001	Todd County 66-1	467209000678	1	Todd County HS	Regular School	No	High	09	12	2018	grade_6	0.0		0.0	0.0		0.0	0.0	0.0	0.0	0		0	0		0	0	0	0
259238	SD	school	4644940	49006	Tri-Valley 49-6	464494000405	1	Tri-Valley High School	Regular School	No	High	09	12	2018	grade_6	0.0	0.0	0.0	0.0		0.0	0.0	0.0	0.0	0	0	0	0		0	0	0	0
259303	SD	school	4672450	33005	Tripp-Delmont 33-5	467245000062	3	Tripp-Delmont Elementary K-6	Regular School	No	Elementary	PK	06	2018	grade_6	8.0	0.0	0.0	2.0		1.0	6.0	5.0	11.0	8	0	0	2		1	6	5	11
259305	SD	school	4672450	33005	Tripp-Delmont 33-5	467245000059	2	Tripp-Delmont JH	Regular School	No	Middle	07	08	2018	grade_6	0.0			0.0			0.0	0.0	0.0	0			0			0	0	0
259373	SD	school	4674370	13001	Vermillion 13-1	467437000300	3	Austin Elementary School	Regular School	No	Elementary	PK	01	2018	grade_6	0.0	0.0	0.0	0.0		0.0	0.0	0.0	0.0	0	0	0	0		0	0	0	0
259374	SD	school	4674370	13001	Vermillion 13-1	467437000301	4	Jolley Elementary School	Regular School	No	Elementary	02	05	2018	grade_6	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0	0	0	0	0	0	0	0	0
259375	SD	school	4674370	13001	Vermillion 13-1	467437000691	1	Vermillion High School	Regular School	No	High	09	12	2018	grade_6	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0	0	0	0	0	0	0	0	0
259503	SD	school	4675420	11004	Wagner Community 11-4	467542000942	3	Wagner Middle School	Regular School	No	Middle	05	08	2018	grade_6	19.0		2.0	40.0		9.0	39.0	31.0	70.0	19		2	40		9	39	31	70
259566	SD	school	4675660	51005	Wall 51-5	467566000704	2	Wall Elementary School	Regular School	No	Elementary	KG	05	2018	grade_6	0.0	0.0	0.0	0.0		0.0	0.0	0.0	0.0	0	0	0	0		0	0	0	0
259622	SD	school	4676020	6005	Warner 06-5	467602000709	1	Warner Hi Sch	Regular School	No	High	09	12	2018	grade_6	0.0	0.0	0.0	0.0			0.0	0.0	0.0	0	0	0	0			0	0	0
259709	SD	school	4676620	14004	Watertown 14-4	467662001083	9	Jefferson Elementary	Regular School	No	Elementary	KG	04	2018	grade_6	0.0	0.0	0.0	0.0		0.0	0.0	0.0	0.0	0	0	0	0		0	0	0	0
259710	SD	school	4676620	14004	Watertown 14-4	467662000944	5	Lincoln Elementary School	Regular School	No	Elementary	KG	04	2018	grade_6	0.0	0.0	0.0	0.0		0.0	0.0	0.0	0.0	0	0	0	0		0	0	0	0