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 black_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	hispanic	native_american	asian	pacific_islander	multiracial	male	female	total	white_int	hispanic_int	native_american_int	asian_int	pacific_islander_int	multiracial_int	male_int	female_int	total_int
249915	SD	school	4602070	6001	Aberdeen 06-1	460207000002	5	C.C. Lee Elementary	Regular School	No	Elementary	KG	05	2018	grade_9	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0	0	0	0	0	0	0	0	0
249917	SD	school	4602070	6001	Aberdeen 06-1	460207000005	2	Holgate Middle School	Regular School	No	Middle	06	08	2018	grade_9	0.0	0.0	0.0	0.0		0.0	0.0	0.0	0.0	0	0	0	0		0	0	0	0
249918	SD	school	4602070	6001	Aberdeen 06-1	460207000007	8	Lincoln Elementary	Regular School	No	Elementary	PK	05	2018	grade_9	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0	0	0	0	0	0	0	0	0
249919	SD	school	4602070	6001	Aberdeen 06-1	460207000008	9	May Overby Elementary	Regular School	No	Elementary	KG	05	2018	grade_9	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0	0	0	0	0	0	0	0	0
249920	SD	school	4602070	6001	Aberdeen 06-1	460207001367	7	Mike Miller Elementary	Regular School	No	Elementary	KG	05	2018	grade_9	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0	0	0	0	0	0	0	0	0
249922	SD	school	4602070	6001	Aberdeen 06-1	460207000009	11	O.M. Tiffany Elementary	Regular School	No	Elementary	KG	05	2018	grade_9	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0	0	0	0	0	0	0	0	0
249923	SD	school	4602070	6001	Aberdeen 06-1	460207000010	10	Simmons Elementary	Regular School	No	Elementary	KG	05	2018	grade_9	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0	0	0	0	0	0	0	0	0
249924	SD	school	4602070	6001	Aberdeen 06-1	460207000011	3	Simmons Middle School	Regular School	No	Middle	06	08	2018	grade_9	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0	0	0	0	0	0	0	0	0
250201	SD	school	4603720	38001	Arlington 38-1	460372000021	2	Arlington Elementary	Regular School	No	Elementary	PK	06	2018	grade_9	0.0	0.0		0.0			0.0	0.0	0.0	0	0		0			0	0	0
250254	SD	school	4603780	21001	Armour 21-1	460378000023	2	Armour Elementary	Regular School	No	Elementary	KG	05	2018	grade_9	0.0	0.0	0.0			0.0	0.0	0.0	0.0	0	0	0			0	0	0	0
250542	SD	school	4606360	61002	Beresford 61-2	460636000047	2	Beresford Elementary	Regular School	No	Elementary	KG	05	2018	grade_9	0.0	0.0	0.0	0.0		0.0	0.0	0.0	0.0	0	0	0	0		0	0	0	0
250543	SD	school	4606360	61002	Beresford 61-2	460636000048	1	Beresford High School	Regular School	No	High	09	12	2018	grade_9	39.0	3.0		1.0		0.0	22.0	21.0	43.0	39	3		1		0	22	21	43
250544	SD	school	4606360	61002	Beresford 61-2	460636000051	3	Beresford Middle School	Regular School	No	Middle	06	08	2018	grade_9	0.0	0.0		0.0		0.0	0.0	0.0	0.0	0	0		0		0	0	0	0
250579	SD	school	4606960	25001	Big Stone City 25-1	460696000053	1	Big Stone City Elementary	Regular School	No	Elementary	PK	05	2018	grade_9	0.0		0.0	0.0			0.0	0.0	0.0	0		0	0			0	0	0
250580	SD	school	4606960	25001	Big Stone City 25-1	460696000352	3	Big Stone MS	Regular School	No	Middle	06	08	2018	grade_9	0.0						0.0	0.0	0.0	0						0	0	0
250874	SD	school	4607950	49002	Brandon Valley 49-2	460795000414	3	Brandon Elem	Regular School	No	Elementary	PK	04	2018	grade_9	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0	0	0	0	0	0	0	0	0
250876	SD	school	4607950	49002	Brandon Valley 49-2	460795001355	7	Brandon Valley Intermediate	Regular School	No	Middle	05	06	2018	grade_9	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0	0	0	0	0	0	0	0	0
250877	SD	school	4607950	49002	Brandon Valley 49-2	460795000072	2	Brandon Valley Middle Sch	Regular School	No	Middle	07	08	2018	grade_9	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0	0	0	0	0	0	0	0	0
250878	SD	school	4607950	49002	Brandon Valley 49-2	460795001302	6	Fred Assam Elementary	Regular School	No	Elementary	KG	04	2018	grade_9	0.0	0.0	0.0	0.0		0.0	0.0	0.0	0.0	0	0	0	0		0	0	0	0
250879	SD	school	4607950	49002	Brandon Valley 49-2	460795001237	5	Robert Bennis Elementary	Regular School	No	Elementary	KG	04	2018	grade_9	0.0	0.0	0.0	0.0		0.0	0.0	0.0	0.0	0	0	0	0		0	0	0	0
250880	SD	school	4607950	49002	Brandon Valley 49-2	460795000073	4	Valley Springs Elem	Regular School	No	Elementary	KG	04	2018	grade_9	0.0	0.0				0.0	0.0	0.0	0.0	0	0				0	0	0	0
250942	SD	school	4621420	30003	Bridgewater-Emery 30-3	462142010071	2	Bridgewater-Emery Elementary	Regular School	No	Elementary	PK	05	2018	grade_9	0.0	0.0					0.0	0.0	0.0	0	0					0	0	0
250944	SD	school	4621420	30003	Bridgewater-Emery 30-3	462142000902	4	Bridgewater-Emery Middle School	Regular School	No	Middle	06	08	2018	grade_9	0.0	0.0	0.0				0.0	0.0	0.0	0	0	0				0	0	0
251023	SD	school	4600041	45004	Britton-Hecla 45-4	460004101140	2	Britton-Hecla Elementary School	Regular School	No	Elementary	KG	06	2018	grade_9	0.0	0.0	0.0	0.0		0.0	0.0	0.0	0.0	0	0	0	0		0	0	0	0
251024	SD	school	4600041	45004	Britton-Hecla 45-4	460004101141	1	Britton-Hecla High School	Regular School	No	High	09	12	2018	grade_9	21.0	1.0	0.0	1.0	0.0		17.0	6.0	23.0	21	1	0	1	0		17	6	23
251120	SD	school	4608520	5001	Brookings 05-1	460852001298	6	Camelot Intermediate School	Regular School	No	Elementary	04	05	2018	grade_9	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0	0	0	0	0	0	0	0	0
251121	SD	school	4608520	5001	Brookings 05-1	460852001356	7	Dakota Prairie Elementary	Regular School	No	Elementary	KG	03	2018	grade_9	0.0	0.0	0.0	0.0		0.0	0.0	0.0	0.0	0	0	0	0		0	0	0	0
251122	SD	school	4608520	5001	Brookings 05-1	460852000083	2	George S Mickelson Middle School	Regular School	No	Middle	06	08	2018	grade_9	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0	0	0	0	0	0	0	0	0
251123	SD	school	4608520	5001	Brookings 05-1	460852000085	4	Hillcrest Elem	Regular School	No	Elementary	KG	03	2018	grade_9	0.0	0.0	0.0	0.0		0.0	0.0	0.0	0.0	0	0	0	0		0	0	0	0
251124	SD	school	4608520	5001	Brookings 05-1	460852000086	5	Medary Elem	Regular School	No	Elementary	KG	03	2018	grade_9	0.0	0.0	0.0	0.0		0.0	0.0	0.0	0.0	0	0	0	0		0	0	0	0
251184	SD	school	4609512	26002	Burke 26-2	460951201043	4	Burke JH	Regular School	No	Middle	07	08	2018	grade_9	0.0	0.0	0.0				0.0	0.0	0.0	0	0	0				0	0	0
251230	SD	school	4610320	43001	Canistota 43-1	461032000104	2	Canistota Elementary School	Regular School	No	Elementary	PK	05	2018	grade_9	0.0	0.0					0.0	0.0	0.0	0	0					0	0	0
251279	SD	school	4610560	41001	Canton 41-1	461056000831	4	Canton Middle School	Regular School	No	Middle	06	08	2018	grade_9	0.0	0.0	0.0	0.0		0.0	0.0	0.0	0.0	0	0	0	0		0	0	0	0
251280	SD	school	4610560	41001	Canton 41-1	461056000108	2	Lawrence Elementary	Regular School	No	Elementary	KG	05	2018	grade_9	0.0	0.0	0.0	0.0		0.0	0.0	0.0	0.0	0	0	0	0		0	0	0	0
251390	SD	school	4611760	60001	Centerville 60-1	461176000115	2	Centerville Elem	Regular School	No	Elementary	PK	05	2018	grade_9	0.0	0.0	0.0				0.0	0.0	0.0	0	0	0				0	0	0
251392	SD	school	4611760	60001	Centerville 60-1	461176001023	3	Centerville Middle School	Regular School	No	Middle	06	08	2018	grade_9	0.0	0.0	0.0				0.0	0.0	0.0	0	0	0				0	0	0
251533	SD	school	4612300	39001	Chester Area 39-1	461230000832	3	Chester Area Middle School	Regular School	No	Middle	06	08	2018	grade_9	0.0		0.0				0.0	0.0	0.0	0		0				0	0	0
251631	SD	school	4612940	12002	Clark 12-2	461294000132	2	Clark Elementary School	Regular School	No	Elementary	PK	04	2018	grade_9	0.0	0.0				0.0	0.0	0.0	0.0	0	0				0	0	0	0
251633	SD	school	4612940	12002	Clark 12-2	461294000890	3	Clark Middle School	Regular School	No	Middle	05	08	2018	grade_9	0.0	0.0					0.0	0.0	0.0	0	0					0	0	0
251694	SD	school	4614100	50005	Colman-Egan 50-5	461410000093	3	Colman Elem	Regular School	No	Elementary	PK	06	2018	grade_9	0.0	0.0				0.0	0.0	0.0	0.0	0	0				0	0	0	0
251865	SD	school	4616950	16001	Custer 16-1	461695000154	2	Custer Elementary	Regular School	No	Elementary	PK	06	2018	grade_9	0.0	0.0	0.0	0.0		0.0	0.0	0.0	0.0	0	0	0	0		0	0	0	0
251866	SD	school	4616950	16001	Custer 16-1	461695000155	1	Custer High School	Regular School	No	High	09	12	2018	grade_9	57.0	3.0	3.0		0.0	0.0	33.0	30.0	63.0	57	3	3		0	0	33	30	63
251867	SD	school	4616950	16001	Custer 16-1	461695000992	5	Custer JH	Regular School	No	Middle	07	08	2018	grade_9	0.0	0.0	0.0			0.0	0.0	0.0	0.0	0	0	0			0	0	0	0
251929	SD	school	4636990	61008	Dakota Valley 61-8	463699000251	2	Dakota Valley Elementary School	Regular School	No	Elementary	KG	03	2018	grade_9	0.0	0.0	0.0	0.0		0.0	0.0	0.0	0.0	0	0	0	0		0	0	0	0
251931	SD	school	4636990	61008	Dakota Valley 61-8	463699000809	3	Dakota Valley Middle School	Regular School	No	Middle	06	08	2018	grade_9	0.0	0.0	0.0	0.0		0.0	0.0	0.0	0.0	0	0	0	0		0	0	0	0
251932	SD	school	4636990	61008	Dakota Valley 61-8	463699001075	4	Dakota Valley Upper Elem	Regular School	No	Elementary	04	05	2018	grade_9	0.0	0.0	0.0	0.0		0.0	0.0	0.0	0.0	0	0	0	0		0	0	0	0
251984	SD	school	4617850	38002	De Smet 38-2	461785000162	2	Laura Ingalls Wilder Elem	Regular School	No	Elementary	PK	05	2018	grade_9	0.0		0.0			0.0	0.0	0.0	0.0	0		0			0	0	0	0
252030	SD	school	4618120	49003	Dell Rapids 49-3	461812000164	2	Dell Rapids Elementary	Regular School	No	Elementary	KG	04	2018	grade_9	0.0	0.0	0.0			0.0	0.0	0.0	0.0	0	0	0			0	0	0	0
252100	SD	school	4678300	5006	Deubrook Area 05-6	467830000559	3	Deubrook Elementary	Regular School	No	Elementary	PK	06	2018	grade_9	0.0	0.0	0.0				0.0	0.0	0.0	0	0	0				0	0	0
252102	SD	school	4678300	5006	Deubrook Area 05-6	467830000016	2	Deubrook Jr High	Regular School	No	Middle	07	08	2018	grade_9	0.0	0.0	0.0	0.0			0.0	0.0	0.0	0	0	0	0			0	0	0
252158	SD	school	4600036	19004	Deuel 19-4	460003601011	2	Clear Lake Elementary	Regular School	No	Elementary	PK	05	2018	grade_9	0.0	0.0	0.0		0.0		0.0	0.0	0.0	0	0	0		0		0	0	0
252159	SD	school	4600036	19004	Deuel 19-4	460003601013	4	Clear Lake Middle School	Regular School	No	Middle	06	08	2018	grade_9	0.0	0.0					0.0	0.0	0.0	0	0					0	0	0
252252	SD	school	4619170	56002	Doland 56-2	461917000170	3	Doland Elementary	Regular School	No	Elementary	PK	06	2018	grade_9	0.0	0.0					0.0	0.0	0.0	0	0					0	0	0
252254	SD	school	4619170	56002	Doland 56-2	461917000895	2	Doland Junior High	Regular School	No	Middle	07	08	2018	grade_9	0.0						0.0	0.0	0.0	0						0	0	0
252341	SD	school	4619410	51001	Douglas 51-1	461941000176	1	Douglas Middle School	Regular School	No	Middle	06	08	2018	grade_9	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0	0	0	0	0	0	0	0	0
252343	SD	school	4619410	51001	Douglas 51-1	461941001384	6	Patriot Elementary	Regular School	No	Elementary	KG	03	2018	grade_9	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0	0	0	0	0	0	0	0	0
252344	SD	school	4619410	51001	Douglas 51-1	461941000436	2	Vandenberg Elementary	Regular School	No	Elementary	04	05	2018	grade_9	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0	0	0	0	0	0	0	0	0
252639	SD	school	4621340	61007	Elk Point-Jefferson 61-7	462134000186	1	Elk Point Jefferson High School	Regular School	No	High	09	12	2018	grade_9	57.0	1.0		0.0	1.0	1.0	28.0	32.0	60.0	57	1		0	1	1	28	32	60
252640	SD	school	4621340	61007	Elk Point-Jefferson 61-7	462134000900	3	Elk Point Jefferson Middle School	Regular School	No	Middle	06	08	2018	grade_9	0.0	0.0				0.0	0.0	0.0	0.0	0	0				0	0	0	0
252864	SD	school	4622560	44001	Eureka 44-1	462256000958	3	Eureka MS	Regular School	No	Middle	06	08	2018	grade_9	0.0					0.0	0.0	0.0	0.0	0					0	0	0	0
253025	SD	school	4624030	24004	Faulkton Area	462403000202	2	Faulkton Elem	Regular School	No	Elementary	PK	06	2018	grade_9	0.0	0.0	0.0			0.0	0.0	0.0	0.0	0	0	0			0	0	0	0
253026	SD	school	4624030	24004	Faulkton Area	462403000203	1	Faulkton Hi Sch	Regular School	No	High	09	12	2018	grade_9	22.0						10.0	12.0	22.0	22						10	12	22
253027	SD	school	4624030	24004	Faulkton Area	462403000204	8	Faulkton Jr Hi	Regular School	No	Middle	07	08	2018	grade_9	0.0		0.0				0.0	0.0	0.0	0		0				0	0	0
253097	SD	school	4624390	50003	Flandreau 50-3	462439000207	4	Flandreau Elem	Regular School	No	Elementary	KG	05	2018	grade_9	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0	0	0	0	0	0	0	0	0
253098	SD	school	4624390	50003	Flandreau 50-3	462439000206	1	Flandreau High Sch	Regular School	No	High	09	12	2018	grade_9	26.0	5.0	25.0	1.0	1.0	0.0	29.0	29.0	58.0	26	5	25	1	1	0	29	29	58
253099	SD	school	4624390	50003	Flandreau 50-3	462439000205	3	Flandreau Middle Sch	Regular School	No	Middle	06	08	2018	grade_9	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0	0	0	0	0	0	0	0	0
253268	SD	school	4625500	33001	Freeman 33-1	462550000219	2	Freeman Elem	Regular School	No	Elementary	KG	06	2018	grade_9	0.0	0.0	0.0	0.0		0.0	0.0	0.0	0.0	0	0	0	0		0	0	0	0
253423	SD	school	4626970	53001	Gettysburg 53-1	462697000232	1	Gettysburg High School	Regular School	No	High	09	12	2018	grade_9	15.0	0.0	1.0			1.0	11.0	6.0	17.0	15	0	1			1	11	6	17
253424	SD	school	4626970	53001	Gettysburg 53-1	462697000959	3	Gettysburg Junior High	Regular School	No	Middle	07	08	2018	grade_9	0.0	0.0	0.0				0.0	0.0	0.0	0	0	0				0	0	0
253470	SD	school	4629880	26004	Gregory 26-4	462988000238	2	Gregory Elementary School	Regular School	No	Elementary	KG	05	2018	grade_9	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0	0	0	0	0	0	0	0	0
253472	SD	school	4629880	26004	Gregory 26-4	462988001296	4	Gregory Jr High School	Regular School	No	Middle	06	08	2018	grade_9	0.0	0.0	0.0	0.0		0.0	0.0	0.0	0.0	0	0	0	0		0	0	0	0
253519	SD	school	4600045	6006	Groton Area	460004501155	1	Groton Area High School	Regular School	No	High	09	12	2018	grade_9	48.0	0.0	1.0	1.0			26.0	24.0	50.0	48	0	1	1			26	24	50
253580	SD	school	4630490	27001	Haakon 27-1	463049000247	3	Philip Junior High	Regular School	No	Middle	07	08	2018	grade_9	0.0		0.0			0.0	0.0	0.0	0.0	0		0			0	0	0	0
253630	SD	school	4630800	28003	Hamlin 28-3	463080001111	9	Hamlin Elementary	Regular School	No	Elementary	PK	05	2018	grade_9	0.0	0.0	0.0	0.0		0.0	0.0	0.0	0.0	0	0	0	0		0	0	0	0
253713	SD	school	4602640	30001	Hanson 30-1	460264000017	1	Hanson High School	Regular School	No	High	09	12	2018	grade_9	26.0	1.0		0.0		1.0	17.0	11.0	28.0	26	1		0		1	17	11	28
253796	SD	school	4609300	31001	Harding County 31-1	460930000087	2	Buffalo Elementary	Regular School	No	Elementary	KG	05	2018	grade_9	0.0		0.0			0.0	0.0	0.0	0.0	0		0			0	0	0	0
253920	SD	school	4631350	41002	Harrisburg 41-2	463135001335	7	Endeavor Elem	Regular School	No	Elementary	KG	05	2018	grade_9	0.0	0.0	0.0	0.0		0.0	0.0	0.0	0.0	0	0	0	0		0	0	0	0
253921	SD	school	4631350	41002	Harrisburg 41-2	463135001169	4	Explorer Elementary	Regular School	No	Elementary	PK	05	2018	grade_9	0.0	0.0	0.0	0.0		0.0	0.0	0.0	0.0	0	0	0	0		0	0	0	0
253922	SD	school	4631350	41002	Harrisburg 41-2	463135001318	6	Freedom Elementary	Regular School	No	Elementary	KG	05	2018	grade_9	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0	0	0	0	0	0	0	0	0
253924	SD	school	4631350	41002	Harrisburg 41-2	463135001334	8	Harrisburg North MS	Regular School	No	Middle	06	08	2018	grade_9	0.0	0.0	0.0	0.0		0.0	0.0	0.0	0.0	0	0	0	0		0	0	0	0
253925	SD	school	4631350	41002	Harrisburg 41-2	463135000847	3	Harrisburg South MS	Regular School	No	Middle	06	08	2018	grade_9	0.0	0.0		0.0		0.0	0.0	0.0	0.0	0	0		0		0	0	0	0
253926	SD	school	4631350	41002	Harrisburg 41-2	463135001375	9	Horizon Elementary	Regular School	No	Elementary	KG	05	2018	grade_9	0.0	0.0		0.0		0.0	0.0	0.0	0.0	0	0		0		0	0	0	0
253927	SD	school	4631350	41002	Harrisburg 41-2	463135001288	5	Journey Elementary	Regular School	No	Elementary	KG	05	2018	grade_9	0.0	0.0	0.0	0.0		0.0	0.0	0.0	0.0	0	0	0	0		0	0	0	0
253928	SD	school	4631350	41002	Harrisburg 41-2	463135000263	2	Liberty Elementary	Regular School	No	Elementary	PK	05	2018	grade_9	0.0	0.0	0.0	0.0		0.0	0.0	0.0	0.0	0	0	0	0		0	0	0	0
253998	SD	school	4632340	14002	Henry 14-2	463234000275	2	Henry Elementary	Regular School	No	Elementary	PK	04	2018	grade_9	0.0			0.0			0.0	0.0	0.0	0			0			0	0	0
253999	SD	school	4632340	14002	Henry 14-2	463234000276	1	Henry High School	Regular School	No	High	09	12	2018	grade_9	14.0		0.0				11.0	3.0	14.0	14		0				11	3	14
254000	SD	school	4632340	14002	Henry 14-2	463234001047	3	Henry MS	Regular School	No	Middle	05	08	2018	grade_9	0.0	0.0		0.0			0.0	0.0	0.0	0	0		0			0	0	0
254094	SD	school	4680440	34002	Highmore-Harrold	468044000323	2	Highmore Elementary	Regular School	No	Elementary	PK	06	2018	grade_9	0.0	0.0	0.0			0.0	0.0	0.0	0.0	0	0	0			0	0	0	0
254270	SD	school	4634480	23002	Hot Springs 23-2	463448000287	2	Hot Springs Elementary	Regular School	No	Elementary	PK	05	2018	grade_9	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0	0	0	0	0	0	0	0	0
254272	SD	school	4634480	23002	Hot Springs 23-2	463448000911	6	Hot Springs Middle Sch	Regular School	No	Middle	06	08	2018	grade_9	0.0	0.0	0.0	0.0		0.0	0.0	0.0	0.0	0	0	0	0		0	0	0	0
254377	SD	school	4600025	48003	Howard 48-3	460002500304	2	Howard Elem	Regular School	No	Elementary	KG	06	2018	grade_9	0.0	0.0	0.0				0.0	0.0	0.0	0	0	0				0	0	0
254378	SD	school	4600025	48003	Howard 48-3	460002500305	1	Howard Hi Sch	Regular School	No	High	09	12	2018	grade_9	24.0	1.0					15.0	10.0	25.0	24	1					15	10	25
254379	SD	school	4600025	48003	Howard 48-3	460002500913	5	Howard Jr Hi	Regular School	No	Middle	07	08	2018	grade_9	0.0	0.0				0.0	0.0	0.0	0.0	0	0				0	0	0	0
254474	SD	school	4635480	2002	Huron 02-2	463548001370	18	Buchanan K-1 Center	Regular School	No	Elementary	KG	01	2018	grade_9	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0	0	0	0	0	0	0	0	0
254477	SD	school	4635480	2002	Huron 02-2	463548000314	2	Huron Middle School	Regular School	No	Middle	06	08	2018	grade_9	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0	0	0	0	0	0	0	0	0
254478	SD	school	4635480	2002	Huron 02-2	463548001369	19	Madison 2-3 Center	Regular School	No	Elementary	02	03	2018	grade_9	0.0	0.0	0.0	0.0		0.0	0.0	0.0	0.0	0	0	0	0		0	0	0	0
254480	SD	school	4635480	2002	Huron 02-2	463548001373	20	Washington 4-5 Center	Regular School	No	Elementary	04	05	2018	grade_9	0.0	0.0	0.0	0.0		0.0	0.0	0.0	0.0	0	0	0	0		0	0	0	0
254576	SD	school	4636060	22006	Ipswich Public 22-6	463606000332	2	Ipswich Elem	Regular School	No	Elementary	PK	05	2018	grade_9	0.0	0.0	0.0	0.0		0.0	0.0	0.0	0.0	0	0	0	0		0	0	0	0
254578	SD	school	4636060	22006	Ipswich Public 22-6	463606000914	4	Ipswich MS	Regular School	No	Middle	06	08	2018	grade_9	0.0	0.0		0.0		0.0	0.0	0.0	0.0	0	0		0		0	0	0	0
254639	SD	school	4680439	13003	Irene-Wakonda 13-3	468043901254	1	Irene-Wakonda High School	Regular School	No	High	09	12	2018	grade_9	15.0	1.0	2.0				6.0	12.0	18.0	15	1	2				6	12	18
254697	SD	school	4636150	2003	Iroquois 02-3	463615001144	4	Iroquois Elementary	Regular School	No	Elementary	PK	05	2018	grade_9	0.0	0.0	0.0				0.0	0.0	0.0	0	0	0				0	0	0