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 asian_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	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
3006250	SD	school	4602070	6001	Aberdeen 06-1	460207000002	5	C.C. Lee Elementary	Regular School	No	Elementary	KG	05	2017	grade_11	0.0	0.0	0.0	0.0		0.0	0.0	0.0	0.0	0	0	0	0		0	0	0	0
3006252	SD	school	4602070	6001	Aberdeen 06-1	460207000005	2	Holgate Middle School	Regular School	No	Middle	06	08	2017	grade_11	0.0	0.0	0.0	0.0		0.0	0.0	0.0	0.0	0	0	0	0		0	0	0	0
3006253	SD	school	4602070	6001	Aberdeen 06-1	460207000007	8	Lincoln Elementary	Regular School	No	Elementary	PK	05	2017	grade_11	0.0	0.0	0.0	0.0		0.0	0.0	0.0	0.0	0	0	0	0		0	0	0	0
3006254	SD	school	4602070	6001	Aberdeen 06-1	460207000008	9	May Overby Elementary	Regular School	No	Elementary	KG	05	2017	grade_11	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0	0	0	0	0	0	0	0	0
3006255	SD	school	4602070	6001	Aberdeen 06-1	460207001367	7	Mike Miller Elementary	Regular School	No	Elementary	KG	05	2017	grade_11	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0	0	0	0	0	0	0	0	0
3006257	SD	school	4602070	6001	Aberdeen 06-1	460207000009	11	O.M. Tiffany Elementary	Regular School	No	Elementary	KG	05	2017	grade_11	0.0	0.0	0.0	0.0		0.0	0.0	0.0	0.0	0	0	0	0		0	0	0	0
3006258	SD	school	4602070	6001	Aberdeen 06-1	460207000010	10	Simmons Elementary	Regular School	No	Elementary	KG	05	2017	grade_11	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0	0	0	0	0	0	0	0	0
3006259	SD	school	4602070	6001	Aberdeen 06-1	460207000011	3	Simmons Middle School	Regular School	No	Middle	06	08	2017	grade_11	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0	0	0	0	0	0	0	0	0
3006399	SD	school	4600042	58003	Agar-Blunt-Onida 58-3	460004200655	4	Onida Elementary	Regular School	No	Elementary	KG	06	2017	grade_11	0.0		0.0	0.0		0.0	0.0	0.0	0.0	0		0	0		0	0	0	0
3006460	SD	school	4600028	61001	Alcester-Hudson 61-1	460002800013	4	Alcester-Hudson Elementary	Regular School	No	Elementary	PK	06	2017	grade_11	0.0		0.0	0.0		0.0	0.0	0.0	0.0	0		0	0		0	0	0	0
3006574	SD	school	4603720	38001	Arlington 38-1	460372000021	2	Arlington Elementary	Regular School	No	Elementary	PK	06	2017	grade_11	0.0	0.0	0.0	0.0		0.0	0.0	0.0	0.0	0	0	0	0		0	0	0	0
3006748	SD	school	4604680	49001	Baltic 49-1	460468000035	2	Baltic Elem	Regular School	No	Elementary	PK	05	2017	grade_11	0.0		0.0	0.0		0.0	0.0	0.0	0.0	0		0	0		0	0	0	0
3006750	SD	school	4604680	49001	Baltic 49-1	460468000986	3	Baltic Middle School	Regular School	No	Middle	06	08	2017	grade_11	0.0	0.0	0.0				0.0	0.0	0.0	0	0	0				0	0	0
3006876	SD	school	4606240	3001	Bennett County 03-1	460624000042	1	Bennett County High School	Regular School	No	High	09	12	2017	grade_11	11.0		1.0	17.0		9.0	21.0	17.0	38.0	11		1	17		9	21	17	38
3006877	SD	school	4606240	3001	Bennett County 03-1	460624001015	6	Bennett County Jr High	Regular School	No	Middle	07	08	2017	grade_11	0.0		0.0	0.0		0.0	0.0	0.0	0.0	0		0	0		0	0	0	0
3006924	SD	school	4606360	61002	Beresford 61-2	460636000047	2	Beresford Elementary	Regular School	No	Elementary	KG	05	2017	grade_11	0.0	0.0	0.0			0.0	0.0	0.0	0.0	0	0	0			0	0	0	0
3006925	SD	school	4606360	61002	Beresford 61-2	460636000048	1	Beresford High School	Regular School	No	High	09	12	2017	grade_11	41.0	0.0	3.0			1.0	22.0	23.0	45.0	41	0	3			1	22	23	45
3006926	SD	school	4606360	61002	Beresford 61-2	460636000051	3	Beresford Middle School	Regular School	No	Middle	06	08	2017	grade_11	0.0	0.0	0.0			0.0	0.0	0.0	0.0	0	0	0			0	0	0	0
3006970	SD	school	4606960	25001	Big Stone City 25-1	460696000053	1	Big Stone City Elementary	Regular School	No	Elementary	PK	05	2017	grade_11	0.0		0.0	0.0			0.0	0.0	0.0	0		0	0			0	0	0
3007004	SD	school	4607050	52001	Bison 52-1	460705000054	2	Bison Elementary	Regular School	No	Elementary	KG	06	2017	grade_11	0.0		0.0	0.0		0.0	0.0	0.0	0.0	0		0	0		0	0	0	0
3007165	SD	school	4607800	22001	Bowdle 22-1	460780000069	1	Bowdle High School	Regular School	No	High	09	12	2017	grade_11	7.0						2.0	5.0	7.0	7						2	5	7
3007220	SD	school	4607950	49002	Brandon Valley 49-2	460795000414	3	Brandon Elem	Regular School	No	Elementary	PK	04	2017	grade_11	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0	0	0	0	0	0	0	0	0
3007222	SD	school	4607950	49002	Brandon Valley 49-2	460795001355	7	Brandon Valley Intermediate	Regular School	No	Middle	05	06	2017	grade_11	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0	0	0	0	0	0	0	0	0
3007223	SD	school	4607950	49002	Brandon Valley 49-2	460795000072	2	Brandon Valley Middle Sch	Regular School	No	Middle	07	08	2017	grade_11	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0	0	0	0	0	0	0	0	0
3007224	SD	school	4607950	49002	Brandon Valley 49-2	460795001302	6	Fred Assam Elementary	Regular School	No	Elementary	KG	04	2017	grade_11	0.0	0.0	0.0	0.0		0.0	0.0	0.0	0.0	0	0	0	0		0	0	0	0
3007225	SD	school	4607950	49002	Brandon Valley 49-2	460795001237	5	Robert Bennis Elementary	Regular School	No	Elementary	KG	04	2017	grade_11	0.0	0.0	0.0			0.0	0.0	0.0	0.0	0	0	0			0	0	0	0
3007378	SD	school	4600041	45004	Britton-Hecla 45-4	460004101140	2	Britton-Hecla Elementary School	Regular School	No	Elementary	KG	06	2017	grade_11	0.0	0.0	0.0	0.0		0.0	0.0	0.0	0.0	0	0	0	0		0	0	0	0
3007380	SD	school	4600041	45004	Britton-Hecla 45-4	460004101142	3	Britton-Hecla Junior High	Regular School	No	Middle	07	08	2017	grade_11	0.0	0.0		0.0		0.0	0.0	0.0	0.0	0	0		0		0	0	0	0
3007475	SD	school	4608520	5001	Brookings 05-1	460852001298	6	Camelot Intermediate School	Regular School	No	Elementary	04	05	2017	grade_11	0.0	0.0	0.0	0.0		0.0	0.0	0.0	0.0	0	0	0	0		0	0	0	0
3007476	SD	school	4608520	5001	Brookings 05-1	460852001356	7	Dakota Prairie Elementary	Regular School	No	Elementary	KG	03	2017	grade_11	0.0	0.0	0.0	0.0		0.0	0.0	0.0	0.0	0	0	0	0		0	0	0	0
3007477	SD	school	4608520	5001	Brookings 05-1	460852000083	2	George S Mickelson Middle School	Regular School	No	Middle	06	08	2017	grade_11	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0	0	0	0	0	0	0	0	0
3007478	SD	school	4608520	5001	Brookings 05-1	460852000085	4	Hillcrest Elem	Regular School	No	Elementary	KG	03	2017	grade_11	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0	0	0	0	0	0	0	0	0
3007479	SD	school	4608520	5001	Brookings 05-1	460852000086	5	Medary Elem	Regular School	No	Elementary	KG	03	2017	grade_11	0.0	0.0	0.0	0.0		0.0	0.0	0.0	0.0	0	0	0	0		0	0	0	0
3007661	SD	school	4610560	41001	Canton 41-1	461056000831	4	Canton Middle School	Regular School	No	Middle	06	08	2017	grade_11	0.0	0.0	0.0	0.0		0.0	0.0	0.0	0.0	0	0	0	0		0	0	0	0
3007662	SD	school	4610560	41001	Canton 41-1	461056000108	2	Lawrence Elementary	Regular School	No	Elementary	KG	05	2017	grade_11	0.0	0.0	0.0	0.0		0.0	0.0	0.0	0.0	0	0	0	0		0	0	0	0
3007820	SD	school	4612000	7001	Chamberlain 07-1	461200000118	3	Chamberlain Elementary School	Regular School	No	Elementary	KG	06	2017	grade_11	0.0	0.0	0.0	0.0		0.0	0.0	0.0	0.0	0	0	0	0		0	0	0	0
3008077	SD	school	4614100	50005	Colman-Egan 50-5	461410000091	1	Colman-Egan Hi Sch	Regular School	No	High	09	12	2017	grade_11	15.0	3.0		1.0			11.0	8.0	19.0	15	3		1			11	8	19
3008126	SD	school	4614130	59003	Colome Consolidated	461413000140	2	Colome Elementary School	Regular School	No	Elementary	PK	05	2017	grade_11	0.0			0.0		0.0	0.0	0.0	0.0	0			0		0	0	0	0
3008127	SD	school	4614130	59003	Colome Consolidated	461413000141	1	Colome High School	Regular School	No	High	09	12	2017	grade_11	15.0		0.0	1.0			11.0	5.0	16.0	15		0	1			11	5	16
3008128	SD	school	4614130	59003	Colome Consolidated	461413000893	3	Colome Middle School	Regular School	No	Middle	06	08	2017	grade_11	0.0		0.0	0.0		0.0	0.0	0.0	0.0	0		0	0		0	0	0	0
3008188	SD	school	4680445	21003	Corsica-Stickney 21-3	468044501354	2	Corsica-Stickney Elementary	Regular School	No	Elementary	PK	06	2017	grade_11	0.0			0.0			0.0	0.0	0.0	0			0			0	0	0
3008239	SD	school	4616950	16001	Custer 16-1	461695000155	1	Custer High School	Regular School	No	High	09	12	2017	grade_11	55.0	1.0	3.0	1.0		0.0	30.0	30.0	60.0	55	1	3	1		0	30	30	60
3008302	SD	school	4636990	61008	Dakota Valley 61-8	463699000251	2	Dakota Valley Elementary School	Regular School	No	Elementary	KG	03	2017	grade_11	0.0	0.0	0.0	0.0		0.0	0.0	0.0	0.0	0	0	0	0		0	0	0	0
3008304	SD	school	4636990	61008	Dakota Valley 61-8	463699000809	3	Dakota Valley Middle School	Regular School	No	Middle	06	08	2017	grade_11	0.0	0.0	0.0	0.0		0.0	0.0	0.0	0.0	0	0	0	0		0	0	0	0
3008305	SD	school	4636990	61008	Dakota Valley 61-8	463699001075	4	Dakota Valley Upper Elem	Regular School	No	Elementary	04	05	2017	grade_11	0.0	0.0	0.0	0.0		0.0	0.0	0.0	0.0	0	0	0	0		0	0	0	0
3008366	SD	school	4617850	38002	De Smet 38-2	461785000162	2	Laura Ingalls Wilder Elem	Regular School	No	Elementary	KG	05	2017	grade_11	0.0	0.0	0.0			0.0	0.0	0.0	0.0	0	0	0			0	0	0	0
3008464	SD	school	4678300	5006	Deubrook Area 05-6	467830000559	3	Deubrook Elementary	Regular School	No	Elementary	PK	06	2017	grade_11	0.0	0.0	0.0	0.0		0.0	0.0	0.0	0.0	0	0	0	0		0	0	0	0
3008706	SD	school	4619410	51001	Douglas 51-1	461941000453	5	Badger Clark Elem	Regular School	No	Elementary	KG	01	2017	grade_11	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0	0	0	0	0	0	0	0	0
3008708	SD	school	4619410	51001	Douglas 51-1	461941000176	1	Douglas Middle School	Regular School	No	Middle	06	08	2017	grade_11	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0	0	0	0	0	0	0	0	0
3008710	SD	school	4619410	51001	Douglas 51-1	461941000439	4	Francis Case Elementary	Regular School	No	Elementary	02	03	2017	grade_11	0.0	0.0	0.0	0.0		0.0	0.0	0.0	0.0	0	0	0	0		0	0	0	0
3008711	SD	school	4619410	51001	Douglas 51-1	461941000436	2	Vandenberg Elementary	Regular School	No	Elementary	04	05	2017	grade_11	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0	0	0	0	0	0	0	0	0
3008848	SD	school	4620100	20001	Eagle Butte 20-1	462010000897	2	C-EB Primary	Regular School	No	Elementary	KG	02	2017	grade_11	0.0			0.0			0.0	0.0	0.0	0			0			0	0	0
3008940	SD	school	4634440	22005	Edmunds Central 22-5	463444001066	5	Edmunds Central Elementary	Regular School	No	Elementary	PK	06	2017	grade_11	0.0		0.0	0.0			0.0	0.0	0.0	0		0	0			0	0	0
3009020	SD	school	4621340	61007	Elk Point-Jefferson 61-7	462134000185	2	Elk Point Jefferson Elementary	Regular School	No	Elementary	KG	05	2017	grade_11	0.0		0.0	0.0		0.0	0.0	0.0	0.0	0		0	0		0	0	0	0
3009245	SD	school	4622560	44001	Eureka 44-1	462256000196	1	Eureka High School	Regular School	No	High	09	12	2017	grade_11	16.0	0.0	0.0				11.0	5.0	16.0	16	0	0				11	5	16
3009296	SD	school	4622940	46002	Faith 46-2	462294000805	2	Faith Elementary School	Regular School	No	Elementary	KG	06	2017	grade_11	0.0		0.0	0.0			0.0	0.0	0.0	0		0	0			0	0	0
3009470	SD	school	4624390	50003	Flandreau 50-3	462439000207	4	Flandreau Elem	Regular School	No	Elementary	KG	05	2017	grade_11	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0	0	0	0	0	0	0	0	0
3009471	SD	school	4624390	50003	Flandreau 50-3	462439000206	1	Flandreau High Sch	Regular School	No	High	09	12	2017	grade_11	27.0		1.0	16.0			27.0	17.0	44.0	27		1	16			27	17	44
3009472	SD	school	4624390	50003	Flandreau 50-3	462439000205	3	Flandreau Middle Sch	Regular School	No	Middle	06	08	2017	grade_11	0.0	0.0	0.0	0.0	0.0		0.0	0.0	0.0	0	0	0	0	0		0	0	0
3009632	SD	school	4625500	33001	Freeman 33-1	462550000219	2	Freeman Elem	Regular School	No	Elementary	KG	06	2017	grade_11	0.0	0.0	0.0			0.0	0.0	0.0	0.0	0	0	0			0	0	0	0
3009708	SD	school	4626370	49004	Garretson 49-4	462637000223	2	Garretson Elementary	Regular School	No	Elementary	PK	05	2017	grade_11	0.0		0.0	0.0		0.0	0.0	0.0	0.0	0		0	0		0	0	0	0
3009710	SD	school	4626370	49004	Garretson 49-4	462637000843	3	Garretson Middle School	Regular School	No	Middle	06	08	2017	grade_11	0.0	0.0	0.0	0.0		0.0	0.0	0.0	0.0	0	0	0	0		0	0	0	0
3009757	SD	school	4626490	63001	Gayville-Volin 63-1	462649000227	1	Gayville-Volin Hi Sch	Regular School	No	High	09	12	2017	grade_11	19.0		0.0	0.0		3.0	11.0	11.0	22.0	19		0	0		3	11	11	22
3009900	SD	school	4629880	26004	Gregory 26-4	462988000238	2	Gregory Elementary School	Regular School	No	Elementary	KG	05	2017	grade_11	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0	0	0	0	0	0	0	0	0
3009902	SD	school	4629880	26004	Gregory 26-4	462988001296	4	Gregory Jr High School	Regular School	No	Middle	06	08	2017	grade_11	0.0			0.0			0.0	0.0	0.0	0			0			0	0	0
3009948	SD	school	4600045	6006	Groton Area	460004501156	2	Groton Area Elementary School	Regular School	No	Elementary	PK	05	2017	grade_11	0.0	0.0	0.0	0.0		0.0	0.0	0.0	0.0	0	0	0	0		0	0	0	0
3009950	SD	school	4600045	6006	Groton Area	460004501157	4	Groton Area MS	Regular School	No	Middle	06	08	2017	grade_11	0.0	0.0	0.0	0.0			0.0	0.0	0.0	0	0	0	0			0	0	0
3010000	SD	school	4630490	27001	Haakon 27-1	463049000256	1	Philip High School	Regular School	No	High	09	12	2017	grade_11	25.0		0.0	1.0		1.0	11.0	16.0	27.0	25		0	1		1	11	16	27
3010060	SD	school	4630800	28003	Hamlin 28-3	463080001111	9	Hamlin Elementary	Regular School	No	Elementary	PK	05	2017	grade_11	0.0	0.0	0.0	0.0		0.0	0.0	0.0	0.0	0	0	0	0		0	0	0	0
3010116	SD	school	4602640	30001	Hanson 30-1	460264000017	1	Hanson High School	Regular School	No	High	09	12	2017	grade_11	24.0	1.0	0.0			1.0	11.0	15.0	26.0	24	1	0			1	11	15	26
3010296	SD	school	4631350	41002	Harrisburg 41-2	463135001335	7	Endeavor Elem	Regular School	No	Elementary	KG	05	2017	grade_11	0.0	0.0	0.0	0.0		0.0	0.0	0.0	0.0	0	0	0	0		0	0	0	0
3010297	SD	school	4631350	41002	Harrisburg 41-2	463135001169	4	Explorer Elementary	Regular School	No	Elementary	PK	05	2017	grade_11	0.0	0.0	0.0	0.0		0.0	0.0	0.0	0.0	0	0	0	0		0	0	0	0
3010298	SD	school	4631350	41002	Harrisburg 41-2	463135001318	6	Freedom Elementary	Regular School	No	Elementary	KG	05	2017	grade_11	0.0	0.0	0.0	0.0		0.0	0.0	0.0	0.0	0	0	0	0		0	0	0	0
3010300	SD	school	4631350	41002	Harrisburg 41-2	463135001334	8	Harrisburg North MS	Regular School	No	Middle	06	08	2017	grade_11	0.0	0.0	0.0	0.0		0.0	0.0	0.0	0.0	0	0	0	0		0	0	0	0
3010301	SD	school	4631350	41002	Harrisburg 41-2	463135000847	3	Harrisburg South MS	Regular School	No	Middle	06	08	2017	grade_11	0.0	0.0	0.0			0.0	0.0	0.0	0.0	0	0	0			0	0	0	0
3010302	SD	school	4631350	41002	Harrisburg 41-2	463135001375	9	Horizon Elementary	Regular School	No	Elementary	PK	05	2017	grade_11	0.0	0.0	0.0		0.0	0.0	0.0	0.0	0.0	0	0	0		0	0	0	0	0
3010303	SD	school	4631350	41002	Harrisburg 41-2	463135001288	5	Journey Elementary	Regular School	No	Elementary	KG	05	2017	grade_11	0.0	0.0	0.0	0.0		0.0	0.0	0.0	0.0	0	0	0	0		0	0	0	0
3010304	SD	school	4631350	41002	Harrisburg 41-2	463135000263	2	Liberty Elementary	Regular School	No	Elementary	PK	05	2017	grade_11	0.0	0.0	0.0	0.0		0.0	0.0	0.0	0.0	0	0	0	0		0	0	0	0
3010428	SD	school	4632340	14002	Henry 14-2	463234000275	2	Henry Elementary	Regular School	No	Elementary	PK	04	2017	grade_11	0.0						0.0	0.0	0.0	0						0	0	0
3010430	SD	school	4632340	14002	Henry 14-2	463234001047	3	Henry MS	Regular School	No	Middle	05	08	2017	grade_11	0.0	0.0	0.0				0.0	0.0	0.0	0	0	0				0	0	0
3010573	SD	school	4633360	51002	Hill City 51-2	463336000280	1	Hill City High School	Regular School	No	High	09	12	2017	grade_11	25.0		3.0	1.0			18.0	11.0	29.0	25		3	1			18	11	29
3010700	SD	school	4634480	23002	Hot Springs 23-2	463448000287	2	Hot Springs Elementary	Regular School	No	Elementary	PK	05	2017	grade_11	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0	0	0	0	0	0	0	0	0
3010702	SD	school	4634480	23002	Hot Springs 23-2	463448000911	6	Hot Springs Middle Sch	Regular School	No	Middle	06	08	2017	grade_11	0.0	0.0	0.0	0.0		0.0	0.0	0.0	0.0	0	0	0	0		0	0	0	0
3010868	SD	school	4635480	2002	Huron 02-2	463548001370	18	Buchanan K-1 Center	Regular School	No	Elementary	KG	01	2017	grade_11	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0	0	0	0	0	0	0	0	0
3010871	SD	school	4635480	2002	Huron 02-2	463548000314	2	Huron Middle School	Regular School	No	Middle	06	08	2017	grade_11	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0	0	0	0	0	0	0	0	0
3010872	SD	school	4635480	2002	Huron 02-2	463548001369	19	Madison 2-3 Center	Regular School	No	Elementary	02	03	2017	grade_11	0.0	0.0	0.0	0.0		0.0	0.0	0.0	0.0	0	0	0	0		0	0	0	0
3010874	SD	school	4635480	2002	Huron 02-2	463548001373	20	Washington 4-5 Center	Regular School	No	Elementary	04	05	2017	grade_11	0.0	0.0	0.0	0.0		0.0	0.0	0.0	0.0	0	0	0	0		0	0	0	0
3010979	SD	school	4636060	22006	Ipswich Public 22-6	463606000332	2	Ipswich Elem	Regular School	No	Elementary	PK	05	2017	grade_11	0.0		0.0	0.0		0.0	0.0	0.0	0.0	0		0	0		0	0	0	0
3010981	SD	school	4636060	22006	Ipswich Public 22-6	463606000914	4	Ipswich MS	Regular School	No	Middle	06	08	2017	grade_11	0.0	0.0	0.0	0.0		0.0	0.0	0.0	0.0	0	0	0	0		0	0	0	0
3011502	SD	school	4641300	40001	Lead-Deadwood 40-1	464130001145	10	Lead-Deadwood Career & Tech Ed	Alternative School	No	High	09	12	2017	grade_11	5.0	0.0	0.0	3.0	0.0	1.0	4.0	5.0	9.0	5	0	0	3	0	1	4	5	9
3011503	SD	school	4641300	40001	Lead-Deadwood 40-1	464130000372	3	Lead-Deadwood Elementary	Regular School	No	Elementary	KG	05	2017	grade_11	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0	0	0	0	0	0	0	0	0
3011565	SD	school	4641520	52004	Lemmon 52-4	464152000382	1	Lemmon High School	Regular School	No	High	09	12	2017	grade_11	19.0		1.0	0.0		0.0	11.0	9.0	20.0	19		1	0		0	11	9	20
3011616	SD	school	4641550	41004	Lennox 41-4	464155000386	2	Lennox Elementary	Regular School	No	Elementary	PK	04	2017	grade_11	0.0		0.0	0.0		0.0	0.0	0.0	0.0	0		0	0		0	0	0	0
3011617	SD	school	4641550	41004	Lennox 41-4	464155000387	1	Lennox High School	Regular School	No	High	09	12	2017	grade_11	62.0	1.0	1.0	0.0		4.0	41.0	27.0	68.0	62	1	1	0		4	41	27	68
3011852	SD	school	4639600	39002	Madison Central 39-2	463960001189	7	Madison Elementary School	Regular School	No	Elementary	KG	05	2017	grade_11	0.0	0.0	0.0	0.0		0.0	0.0	0.0	0.0	0	0	0	0		0	0	0	0
3011854	SD	school	4639600	39002	Madison Central 39-2	463960000364	2	Madison Middle School	Regular School	No	Middle	06	08	2017	grade_11	0.0	0.0	0.0	0.0		0.0	0.0	0.0	0.0	0	0	0	0		0	0	0	0
3012127	SD	school	4669930	46001	Meade 46-1	466993000644	5	Piedmont Valley Elementary	Regular School	No	Elementary	KG	06	2017	grade_11	0.0	0.0	0.0	0.0		0.0	0.0	0.0	0.0	0	0	0	0		0	0	0	0
3012129	SD	school	4669930	46001	Meade 46-1	466993000637	3	Sturgis Elementary	Regular School	No	Elementary	KG	05	2017	grade_11	0.0	0.0	0.0	0.0		0.0	0.0	0.0	0.0	0	0	0	0		0	0	0	0
3012398	SD	school	4647942	29004	Miller	464794200429	2	Miller Elementary School	Regular School	No	Elementary	KG	06	2017	grade_11	0.0	0.0	0.0	0.0	0.0		0.0	0.0	0.0	0	0	0	0	0		0	0	0
3012399	SD	school	4647942	29004	Miller	464794200430	1	Miller High School	Regular School	No	High	09	12	2017	grade_11	24.0					1.0	17.0	8.0	25.0	24					1	17	8	25
3012468	SD	school	4648390	17002	Mitchell 17-2	464839000591	4	Gertie Belle Rogers Elem	Regular School	No	Elementary	KG	05	2017	grade_11	0.0	0.0	0.0	0.0		0.0	0.0	0.0	0.0	0	0	0	0		0	0	0	0