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 (ccd_school_low_grade > :p3 or (ccd_school_low_grade = :p3 and rowid > :p2)) order by ccd_school_low_grade, 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	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
3346629	SD	school	4619410	51001	Douglas 51-1	461941000436	2	Vandenberg Elementary	Regular School	No	2	04	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	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
249841	SD	school	4602070	6001	Aberdeen 06-1	460207001130	89	New Beginnings	Alternative School	No	High	05	12	2018	grade_12	0.0			1.0				0.0	1.0	1.0	0			1				0	1	1
250398	SD	school	4605610	9001	Belle Fourche 09-1	460561001117	7	Belle Fourche MS	Regular School	No	Middle	05	08	2018	grade_12	0.0		0.0	0.0			0.0	0.0	0.0	0.0	0		0	0			0	0	0	0
250820	SD	school	4607950	49002	Brandon Valley 49-2	460795001355	7	Brandon Valley Intermediate	Regular School	No	Middle	05	06	2018	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
251585	SD	school	4612940	12002	Clark 12-2	461294000890	3	Clark Middle School	Regular School	No	Middle	05	08	2018	grade_12	0.0	0.0	0.0					0.0	0.0	0.0	0	0	0					0	0	0
252008	SD	school	4618120	49003	Dell Rapids 49-3	461812000837	3	Dell Rapids Middle School	Regular School	No	Middle	05	08	2018	grade_12	0.0		0.0	0.0			0.0	0.0	0.0	0.0	0		0	0			0	0	0	0
253976	SD	school	4632340	14002	Henry 14-2	463234001047	3	Henry MS	Regular School	No	Middle	05	08	2018	grade_12	0.0	0.0	0.0		0.0			0.0	0.0	0.0	0	0	0		0			0	0	0
254728	SD	school	4619580	37003	Jones County 37-3	461958000955	4	Jones County MS	Regular School	No	Middle	05	08	2018	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
254880	SD	school	4638220	7002	Kimball 07-2	463822000142	4	Kimball Middle School	Regular School	No	Middle	05	08	2018	grade_12	0.0		0.0	0.0			0.0	0.0	0.0	0.0	0		0	0			0	0	0	0
255182	SD	school	4641550	41004	Lennox 41-4	464155001363	9	Lennox Intermediate	Regular School	No	Middle	05	06	2018	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
255516	SD	school	4601026	43007	McCook Central 43-7	460102601034	3	McCook Central Middle School	Regular School	No	Middle	05	08	2018	grade_12	0.0		0.0				0.0	0.0	0.0	0.0	0		0				0	0	0	0
255702	SD	school	4669930	46001	Meade 46-1	466993001383	6	Sturgis Intermediate School	Regular School	No	Middle	05	05	2018	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
256737	SD	school	4654300	33003	Parkston 33-3	465430001132	88	Our Home	Alternative School	No	High	05	12	2018	grade_12	2.0	1.0	0.0	0.0				2.0	1.0	3.0	2	1	0	0				2	1	3
258924	SD	school	4600052	41005	Tea Area 41-5	460005200853	2	Tea Area Middle School	Regular School	No	Middle	05	08	2018	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
259420	SD	school	4674520	60006	Viborg-Hurley 60-6	467452000961	3	Viborg-Hurley Middle School	Regular School	No	Middle	05	08	2018	grade_12	0.0	0.0					0.0	0.0	0.0	0.0	0	0					0	0	0	0
259483	SD	school	4675420	11004	Wagner Community 11-4	467542000942	3	Wagner Middle School	Regular School	No	Middle	05	08	2018	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
259675	SD	school	4676620	14004	Watertown 14-4	467662001378	13	Watertown Intermediate	Regular School	No	Middle	05	06	2018	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
260376	SD	school	4680100	2006	Wolsey-Wessington 02-6	468010000546	3	Wolsey-Wessington Middle School	Regular School	No	Middle	05	08	2018	grade_12	0.0	0.0	0.0				0.0	0.0	0.0	0.0	0	0	0				0	0	0	0
357084	SD	school	4602070	6001	Aberdeen 06-1	460207001130	89	New Beginnings	Alternative School	No	High	05	12	2019	grade_12	0.0	0.0		2.0				0.0	2.0	2.0	0	0		2				0	2	2
357641	SD	school	4605610	9001	Belle Fourche 09-1	460561001117	7	Belle Fourche MS	Regular School	No	Middle	05	08	2019	grade_12	0.0		0.0	0.0			0.0	0.0	0.0	0.0	0		0	0			0	0	0	0
358079	SD	school	4607950	49002	Brandon Valley 49-2	460795001355	7	Brandon Valley Intermediate	Regular School	No	Middle	05	06	2019	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
358844	SD	school	4612940	12002	Clark 12-2	461294000890	3	Clark Middle School	Regular School	No	Middle	05	08	2019	grade_12	0.0	0.0	0.0				0.0	0.0	0.0	0.0	0	0	0				0	0	0	0
359267	SD	school	4618120	49003	Dell Rapids 49-3	461812000837	3	Dell Rapids Middle School	Regular School	No	Middle	05	08	2019	grade_12	0.0		0.0	0.0			0.0	0.0	0.0	0.0	0		0	0			0	0	0	0
360294	SD	school	4624390	50003	Flandreau 50-3	462439000205	3	Flandreau Middle Sch	Regular School	No	Middle	05	08	2019	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
361203	SD	school	4632340	14002	Henry 14-2	463234001047	3	Henry MS	Regular School	No	Middle	05	08	2019	grade_12	0.0		0.0	0.0				0.0	0.0	0.0	0		0	0				0	0	0
361955	SD	school	4619580	37003	Jones County 37-3	461958000955	4	Jones County MS	Regular School	No	Middle	05	08	2019	grade_12	0.0	0.0		0.0			0.0	0.0	0.0	0.0	0	0		0			0	0	0	0
362107	SD	school	4638220	7002	Kimball 07-2	463822000142	4	Kimball Middle School	Regular School	No	Middle	05	08	2019	grade_12	0.0		0.0	0.0			0.0	0.0	0.0	0.0	0		0	0			0	0	0	0
362409	SD	school	4641550	41004	Lennox 41-4	464155001363	9	Lennox Intermediate	Regular School	No	Middle	05	06	2019	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
362743	SD	school	4601026	43007	McCook Central 43-7	460102601034	3	McCook Central Middle School	Regular School	No	Middle	05	08	2019	grade_12	0.0	0.0	0.0				0.0	0.0	0.0	0.0	0	0	0				0	0	0	0
362930	SD	school	4669930	46001	Meade 46-1	466993001392	10	Stagebarn Middle School	Regular School	No	Middle	05	08	2019	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
362933	SD	school	4669930	46001	Meade 46-1	466993001383	6	Sturgis Intermediate School	Regular School	No	Middle	05	05	2019	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
363999	SD	school	4654300	33003	Parkston 33-3	465430001132	88	Our Home	Alternative School	No	High	05	12	2019	grade_12	1.0	0.0	0.0	1.0				0.0	2.0	2.0	1	0	0	1				0	2	2
366151	SD	school	4600052	41005	Tea Area 41-5	460005200853	2	Tea Area Middle School	Regular School	No	Middle	05	08	2019	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
366647	SD	school	4674520	60006	Viborg-Hurley 60-6	467452000961	3	Viborg-Hurley Middle School	Regular School	No	Middle	05	08	2019	grade_12	0.0	0.0	0.0				0.0	0.0	0.0	0.0	0	0	0				0	0	0	0
366710	SD	school	4675420	11004	Wagner Community 11-4	467542000942	3	Wagner Middle School	Regular School	No	Middle	05	08	2019	grade_12	0.0		0.0	0.0			0.0	0.0	0.0	0.0	0		0	0			0	0	0	0
366902	SD	school	4676620	14004	Watertown 14-4	467662001378	13	Watertown Intermediate	Regular School	No	Middle	05	06	2019	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
367635	SD	school	4680100	2006	Wolsey-Wessington 02-6	468010000546	3	Wolsey-Wessington Middle School	Regular School	No	Middle	05	08	2019	grade_12	0.0		0.0				0.0	0.0	0.0	0.0	0		0				0	0	0	0
448946	SD	school	4602070	6001	Aberdeen 06-1	460207001130	89	New Beginnings	Alternative School	Not applicable	High	05	12	2021	grade_12	0.0			0.0				0.0	0.0	0.0	0			0				0	0	0
449487	SD	school	4605610	9001	Belle Fourche 09-1	460561001117	7	Belle Fourche MS	Regular School	Not applicable	Middle	05	08	2021	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
449925	SD	school	4607950	49002	Brandon Valley 49-2	460795001355	7	Brandon Valley Intermediate	Regular School	Not applicable	Middle	05	06	2021	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
450690	SD	school	4612940	12002	Clark 12-2	461294000890	3	Clark Middle School	Regular School	Not applicable	Middle	05	08	2021	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
451113	SD	school	4618120	49003	Dell Rapids 49-3	461812000837	3	Dell Rapids Middle School	Regular School	Not applicable	Middle	05	08	2021	grade_12	0.0		0.0	0.0			0.0	0.0	0.0	0.0	0		0	0			0	0	0	0
452140	SD	school	4624390	50003	Flandreau 50-3	462439000205	3	Flandreau Middle Sch	Regular School	Not applicable	Middle	05	08	2021	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
453801	SD	school	4619580	37003	Jones County 37-3	461958000955	4	Jones County MS	Regular School	Not applicable	Middle	05	08	2021	grade_12	0.0			0.0			0.0	0.0	0.0	0.0	0			0			0	0	0	0
453953	SD	school	4638220	7002	Kimball 07-2	463822000142	4	Kimball Middle School	Regular School	Not applicable	Middle	05	08	2021	grade_12	0.0		0.0	0.0			0.0	0.0	0.0	0.0	0		0	0			0	0	0	0
454255	SD	school	4641550	41004	Lennox 41-4	464155001363	9	Lennox Intermediate	Regular School	Not applicable	Middle	05	06	2021	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
454589	SD	school	4601026	43007	McCook Central 43-7	460102601034	3	McCook Central Middle School	Regular School	Not applicable	Middle	05	08	2021	grade_12	0.0		0.0				0.0	0.0	0.0	0.0	0		0				0	0	0	0
454776	SD	school	4669930	46001	Meade 46-1	466993001392	10	Stagebarn Middle School	Regular School	Not applicable	Middle	05	08	2021	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
454779	SD	school	4669930	46001	Meade 46-1	466993001383	6	Sturgis Intermediate School	Regular School	Not applicable	Middle	05	05	2021	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
455877	SD	school	4654300	33003	Parkston 33-3	465430001132	88	Our Home	Alternative School	Not applicable	High	05	12	2021	grade_12	0.0		1.0	1.0				0.0	2.0	2.0	0		1	1				0	2	2
457672	SD	school	4600053	54002	Sisseton 54-2	460005301258	2	Sisseton Middle School	Regular School	Not applicable	Middle	05	08	2021	grade_12	0.0		0.0	0.0			0.0	0.0	0.0	0.0	0		0	0			0	0	0	0
458525	SD	school	4674520	60006	Viborg-Hurley 60-6	467452000961	3	Viborg-Hurley Middle School	Regular School	Not applicable	Middle	05	08	2021	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
458589	SD	school	4675420	11004	Wagner Community 11-4	467542000942	3	Wagner Middle School	Regular School	Not applicable	Middle	05	08	2021	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
458784	SD	school	4676620	14004	Watertown 14-4	467662001378	13	Watertown Intermediate	Regular School	Not applicable	Middle	05	06	2021	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
459165	SD	school	4631710	49007	West Central 49-7	463171001389	8	Falls Academy	Alternative School	Not applicable	High	05	12	2021	grade_12	3.0	0.0	0.0	1.0		0.0		3.0	1.0	4.0	3	0	0	1		0		3	1	4
487369	SD	school	4602070	6001	Aberdeen 06-1	460207001130	89	New Beginnings	Alternative School	Not applicable	High	05	12	2020	grade_12	0.0	0.0	0.0	0.0				0.0	0.0	0.0	0	0	0	0				0	0	0
487910	SD	school	4605610	9001	Belle Fourche 09-1	460561001117	7	Belle Fourche MS	Regular School	Not applicable	Middle	05	08	2020	grade_12	0.0		0.0	0.0			0.0	0.0	0.0	0.0	0		0	0			0	0	0	0
488348	SD	school	4607950	49002	Brandon Valley 49-2	460795001355	7	Brandon Valley Intermediate	Regular School	Not applicable	Middle	05	06	2020	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
489113	SD	school	4612940	12002	Clark 12-2	461294000890	3	Clark Middle School	Regular School	Not applicable	Middle	05	08	2020	grade_12	0.0	0.0	0.0				0.0	0.0	0.0	0.0	0	0	0				0	0	0	0
489536	SD	school	4618120	49003	Dell Rapids 49-3	461812000837	3	Dell Rapids Middle School	Regular School	Not applicable	Middle	05	08	2020	grade_12	0.0		0.0	0.0			0.0	0.0	0.0	0.0	0		0	0			0	0	0	0
490563	SD	school	4624390	50003	Flandreau 50-3	462439000205	3	Flandreau Middle Sch	Regular School	Not applicable	Middle	05	08	2020	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
492224	SD	school	4619580	37003	Jones County 37-3	461958000955	4	Jones County MS	Regular School	Not applicable	Middle	05	08	2020	grade_12	0.0	0.0		0.0			0.0	0.0	0.0	0.0	0	0		0			0	0	0	0
492376	SD	school	4638220	7002	Kimball 07-2	463822000142	4	Kimball Middle School	Regular School	Not applicable	Middle	05	08	2020	grade_12	0.0		0.0	0.0			0.0	0.0	0.0	0.0	0		0	0			0	0	0	0
492678	SD	school	4641550	41004	Lennox 41-4	464155001363	9	Lennox Intermediate	Regular School	Not applicable	Middle	05	06	2020	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
493012	SD	school	4601026	43007	McCook Central 43-7	460102601034	3	McCook Central Middle School	Regular School	Not applicable	Middle	05	08	2020	grade_12	0.0		0.0				0.0	0.0	0.0	0.0	0		0				0	0	0	0
493199	SD	school	4669930	46001	Meade 46-1	466993001392	10	Stagebarn Middle School	Regular School	Not applicable	Middle	05	08	2020	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
493202	SD	school	4669930	46001	Meade 46-1	466993001383	6	Sturgis Intermediate School	Regular School	Not applicable	Middle	05	05	2020	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
494284	SD	school	4654300	33003	Parkston 33-3	465430001132	88	Our Home	Alternative School	Not applicable	High	05	12	2020	grade_12	0.0		0.0	0.0				0.0	0.0	0.0	0		0	0				0	0	0
496948	SD	school	4674520	60006	Viborg-Hurley 60-6	467452000961	3	Viborg-Hurley Middle School	Regular School	Not applicable	Middle	05	08	2020	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
497012	SD	school	4675420	11004	Wagner Community 11-4	467542000942	3	Wagner Middle School	Regular School	Not applicable	Middle	05	08	2020	grade_12	0.0		0.0	0.0			0.0	0.0	0.0	0.0	0		0	0			0	0	0	0
497203	SD	school	4676620	14004	Watertown 14-4	467662001378	13	Watertown Intermediate	Regular School	Not applicable	Middle	05	06	2020	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
497556	SD	school	4631710	49007	West Central 49-7	463171001389	8	Falls Academy	Alternative School	Not applicable	High	05	12	2020	grade_12	0.0	0.0	0.0	2.0		0.0	0.0	1.0	1.0	2.0	0	0	0	2		0	0	1	1	2
497936	SD	school	4680100	2006	Wolsey-Wessington 02-6	468010000546	3	Wolsey-Wessington Middle School	Regular School	Not applicable	Middle	05	08	2020	grade_12	0.0		0.0				0.0	0.0	0.0	0.0	0		0				0	0	0	0
2961642	SD	school	4602070	6001	Aberdeen 06-1	460207001130	89	New Beginnings	Alternative Education School	No	4	05	12	2015	grade_12	0.0		0.0	1.0		0.0		1.0	0.0	1.0	0		0	1		0		1	0	1
2962001	SD	school	4603780	21001	Armour 21-1	460378000878	3	Armour Middle School	Regular School	No	2	05	08	2015	grade_12	0.0			0.0				0.0	0.0	0.0	0			0				0	0	0
2962167	SD	school	4605610	9001	Belle Fourche 09-1	460561001117	7	Belle Fourche MS	Regular School	No	2	05	08	2015	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
2963121	SD	school	4611760	60001	Centerville 60-1	461176001023	3	Centerville Middle School	Regular School	No	2	05	08	2015	grade_12	0.0	0.0	0.0	0.0				0.0	0.0	0.0	0	0	0	0				0	0	0
2963322	SD	school	4612940	12002	Clark 12-2	461294000890	3	Clark Middle School	Regular School	No	2	05	08	2015	grade_12	0.0	0.0	0.0					0.0	0.0	0.0	0	0	0					0	0	0
2963621	SD	school	4636990	61008	Dakota Valley 61-8	463699001075	4	Dakota Valley Upper Elem	Regular School	No	2	05	06	2015	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
2963729	SD	school	4618120	49003	Dell Rapids 49-3	461812000837	3	Dell Rapids Middle School	Regular School	No	2	05	08	2015	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
2964149	SD	school	4620100	20001	Eagle Butte 20-1	462010001233	7	C-EB EAGLE Center	Alternative Education School	No	4	05	12	2015	grade_12	0.0			0.0				0.0	0.0	0.0	0			0				0	0	0
2966465	SD	school	4619580	37003	Jones County 37-3	461958000955	4	Jones County MS	Regular School	No	2	05	08	2015	grade_12	0.0		0.0	0.0			0.0	0.0	0.0	0.0	0		0	0			0	0	0	0
2966601	SD	school	4638220	7002	Kimball 07-2	463822000142	4	Kimball Middle School	Regular School	No	2	05	08	2015	grade_12	0.0		0.0	0.0			0.0	0.0	0.0	0.0	0		0	0			0	0	0	0
2967221	SD	school	4601026	43007	McCook Central 43-7	460102601034	3	McCook Central Middle School	Regular School	No	2	05	08	2015	grade_12	0.0		0.0				0.0	0.0	0.0	0.0	0		0				0	0	0	0
2968330	SD	school	4654300	33003	Parkston 33-3	465430001132	88	Our Home	Alternative Education School	No	4	05	12	2015	grade_12	2.0		0.0	0.0				0.0	2.0	2.0	2		0	0				0	2	2
2968518	SD	school	4655710	1001	Plankinton 01-1	465571001276	4	Aurora Plains Academy Middle School	Alternative Education School	No	2	05	08	2015	grade_12	0.0	0.0		0.0			0.0	0.0	0.0	0.0	0	0		0			0	0	0	0
2969684	SD	school	4666270	49005	Sioux Falls 49-5	466627001121	39	Success Academy	Special Education School	No	4	05	12	2015	grade_12	0.0		0.0	0.0			1.0	1.0	0.0	1.0	0		0	0			1	1	0	1
2971205	SD	school	4674520	60006	Viborg-Hurley 60-6	467452000961	3	Viborg-Hurley Middle School	Regular School	No	2	05	08	2015	grade_12	0.0	0.0	0.0					0.0	0.0	0.0	0	0	0					0	0	0
2971268	SD	school	4675420	11004	Wagner Community 11-4	467542000942	3	Wagner Middle School	Regular School	No	2	05	08	2015	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
3006807	SD	school	4605610	9001	Belle Fourche 09-1	460561001117	7	Belle Fourche MS	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
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
3007994	SD	school	4612940	12002	Clark 12-2	461294000890	3	Clark 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
3008417	SD	school	4618120	49003	Dell Rapids 49-3	461812000837	3	Dell Rapids 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
3010433	SD	school	4632340	14002	Henry 14-2	463234001047	3	Henry MS	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
3011185	SD	school	4619580	37003	Jones County 37-3	461958000955	4	Jones County MS	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
3011321	SD	school	4638220	7002	Kimball 07-2	463822000142	4	Kimball 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
3011623	SD	school	4641550	41004	Lennox 41-4	464155001363	9	Lennox 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
3013178	SD	school	4654300	33003	Parkston 33-3	465430001132	88	Our Home	Alternative School	No	Other	05	12	2017	grade_12	0.0		0.0	2.0			0.0	1.0	1.0	2.0	0		0	2			0	1	1	2
3014407	SD	school	4666270	49005	Sioux Falls 49-5	466627000609	40	Summit Oaks Day Program	Special Education School	No	Other	05	12	2017	grade_12	1.0	0.0	0.0	0.0			0.0	1.0	0.0	1.0	1	0	0	0			0	1	0	1