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
448951	SD	school	4602070	6001	Aberdeen 06-1	460207000003	1	Central High School	Regular School	Not applicable	High	09	12	2021	grade_2	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0	0	0	0	0	0	0	0	0
448952	SD	school	4602070	6001	Aberdeen 06-1	460207000005	2	Holgate Middle School	Regular School	Not applicable	Middle	06	08	2021	grade_2	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0	0	0	0	0	0	0	0	0
448959	SD	school	4602070	6001	Aberdeen 06-1	460207000011	3	Simmons Middle School	Regular School	Not applicable	Middle	06	08	2021	grade_2	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0	0	0	0	0	0	0	0	0
449146	SD	school	4600028	61001	Alcester-Hudson 61-1	460002800013	4	Alcester-Hudson Elementary	Regular School	Not applicable	Elementary	PK	06	2021	grade_2	29.0		1.0	1.0		0.0	15.0	16.0	31.0	29		1	1		0	15	16	31
449434	SD	school	4604680	49001	Baltic 49-1	460468000035	2	Baltic Elem	Regular School	Not applicable	Elementary	PK	05	2021	grade_2	27.0	0.0	2.0	1.0		2.0	10.0	22.0	32.0	27	0	2	1		2	10	22	32
449435	SD	school	4604680	49001	Baltic 49-1	460468000036	1	Baltic High School	Regular School	Not applicable	High	09	12	2021	grade_2	0.0		0.0	0.0		0.0	0.0	0.0	0.0	0		0	0		0	0	0	0
449436	SD	school	4604680	49001	Baltic 49-1	460468000986	3	Baltic Middle School	Regular School	Not applicable	Middle	06	08	2021	grade_2	0.0		0.0	0.0		0.0	0.0	0.0	0.0	0		0	0		0	0	0	0
449562	SD	school	4606240	3001	Bennett County 03-1	460624000042	1	Bennett County High School	Regular School	Not applicable	High	09	12	2021	grade_2	0.0		0.0	0.0		0.0	0.0	0.0	0.0	0		0	0		0	0	0	0
449610	SD	school	4606360	61002	Beresford 61-2	460636000047	2	Beresford Elementary	Regular School	Not applicable	Elementary	KG	05	2021	grade_2	49.0	0.0	6.0	0.0		0.0	24.0	31.0	55.0	49	0	6	0		0	24	31	55
449611	SD	school	4606360	61002	Beresford 61-2	460636000048	1	Beresford High School	Regular School	Not applicable	High	09	12	2021	grade_2	0.0		0.0	0.0		0.0	0.0	0.0	0.0	0		0	0		0	0	0	0
449690	SD	school	4607050	52001	Bison 52-1	460705000054	2	Bison Elementary	Regular School	Not applicable	Elementary	KG	06	2021	grade_2	13.0			0.0		0.0	7.0	6.0	13.0	13			0		0	7	6	13
449692	SD	school	4607050	52001	Bison 52-1	460705000879	4	Bison JH	Regular School	Not applicable	Middle	07	08	2021	grade_2	0.0		0.0				0.0	0.0	0.0	0		0				0	0	0
449866	SD	school	4607800	22001	Bowdle 22-1	460780000068	2	Bowdle Elementary	Regular School	Not applicable	Elementary	PK	06	2021	grade_2	9.0		0.0	0.0		1.0	4.0	6.0	10.0	9		0	0		1	4	6	10
449930	SD	school	4607950	49002	Brandon Valley 49-2	460795000414	3	Brandon Elem	Regular School	Not applicable	Elementary	PK	04	2021	grade_2	96.0	4.0	5.0	4.0	0.0	11.0	68.0	52.0	120.0	96	4	5	4	0	11	68	52	120
449931	SD	school	4607950	49002	Brandon Valley 49-2	460795000071	1	Brandon Valley Hi Sch	Regular School	Not applicable	High	09	12	2021	grade_2	0.0	0.0	0.0	0.0		0.0	0.0	0.0	0.0	0	0	0	0		0	0	0	0
449932	SD	school	4607950	49002	Brandon Valley 49-2	460795001355	7	Brandon Valley Intermediate	Regular School	Not applicable	Middle	05	06	2021	grade_2	0.0	0.0	0.0	0.0		0.0	0.0	0.0	0.0	0	0	0	0		0	0	0	0
449933	SD	school	4607950	49002	Brandon Valley 49-2	460795000072	2	Brandon Valley Middle Sch	Regular School	Not applicable	Middle	07	08	2021	grade_2	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0	0	0	0	0	0	0	0	0
450087	SD	school	4600041	45004	Britton-Hecla 45-4	460004101141	1	Britton-Hecla High School	Regular School	Not applicable	High	09	12	2021	grade_2	0.0	0.0	0.0	0.0		0.0	0.0	0.0	0.0	0	0	0	0		0	0	0	0
450088	SD	school	4600041	45004	Britton-Hecla 45-4	460004101142	3	Britton-Hecla Middle School	Regular School	Not applicable	Middle	06	08	2021	grade_2	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0	0	0	0	0	0	0	0	0
450182	SD	school	4608520	5001	Brookings 05-1	460852000082	1	Brookings Hi Sch	Regular School	Not applicable	High	09	12	2021	grade_2	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0	0	0	0	0	0	0	0	0
450183	SD	school	4608520	5001	Brookings 05-1	460852001298	6	Camelot Intermediate School	Regular School	Not applicable	Elementary	04	05	2021	grade_2	0.0	0.0	0.0	0.0		0.0	0.0	0.0	0.0	0	0	0	0		0	0	0	0
450185	SD	school	4608520	5001	Brookings 05-1	460852000083	2	George S Mickelson Middle School	Regular School	Not applicable	Middle	06	08	2021	grade_2	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0	0	0	0	0	0	0	0	0
450186	SD	school	4608520	5001	Brookings 05-1	460852000085	4	Hillcrest Elem	Regular School	Not applicable	Elementary	KG	03	2021	grade_2	47.0	1.0	4.0	1.0		5.0	29.0	29.0	58.0	47	1	4	1		5	29	29	58
450362	SD	school	4610560	41001	Canton 41-1	461056000109	1	Canton High School	Regular School	Not applicable	High	09	12	2021	grade_2	0.0	0.0	0.0	0.0		0.0	0.0	0.0	0.0	0	0	0	0		0	0	0	0
450363	SD	school	4610560	41001	Canton 41-1	461056000831	4	Canton Middle School	Regular School	Not applicable	Middle	06	08	2021	grade_2	0.0	0.0	0.0	0.0		0.0	0.0	0.0	0.0	0	0	0	0		0	0	0	0
450364	SD	school	4610560	41001	Canton 41-1	461056000108	2	Lawrence Elementary	Regular School	Not applicable	Elementary	KG	05	2021	grade_2	59.0	1.0	1.0	0.0		0.0	32.0	29.0	61.0	59	1	1	0		0	32	29	61
450522	SD	school	4612000	7001	Chamberlain 07-1	461200000118	3	Chamberlain Elementary School	Regular School	Not applicable	Elementary	KG	05	2021	grade_2	28.0	1.0	4.0	27.0		6.0	34.0	32.0	66.0	28	1	4	27		6	34	32	66
450523	SD	school	4612000	7001	Chamberlain 07-1	461200000119	1	Chamberlain High School	Regular School	Not applicable	High	09	12	2021	grade_2	0.0	0.0	0.0	0.0		0.0	0.0	0.0	0.0	0	0	0	0		0	0	0	0
450779	SD	school	4614100	50005	Colman-Egan 50-5	461410000091	1	Colman-Egan Hi Sch	Regular School	Not applicable	High	09	12	2021	grade_2	0.0	0.0	0.0	0.0		0.0	0.0	0.0	0.0	0	0	0	0		0	0	0	0
450831	SD	school	4614130	59003	Colome Consolidated	461413000141	1	Colome High School	Regular School	Not applicable	High	09	12	2021	grade_2	0.0			0.0		0.0	0.0	0.0	0.0	0			0		0	0	0	0
450832	SD	school	4614130	59003	Colome Consolidated	461413000893	3	Colome Middle School	Regular School	Not applicable	Middle	06	08	2021	grade_2	0.0		0.0	0.0		0.0	0.0	0.0	0.0	0		0	0		0	0	0	0
450890	SD	school	4680445	21003	Corsica-Stickney 21-3	468044501354	2	Corsica-Stickney Elementary	Regular School	Not applicable	Elementary	PK	06	2021	grade_2	12.0		0.0	0.0		1.0	3.0	10.0	13.0	12		0	0		1	3	10	13
450943	SD	school	4616950	16001	Custer 16-1	461695000155	1	Custer High School	Regular School	Not applicable	High	09	12	2021	grade_2	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0	0	0	0	0	0	0	0	0
451007	SD	school	4636990	61008	Dakota Valley 61-8	463699000345	1	Dakota Valley High School	Regular School	Not applicable	High	09	12	2021	grade_2	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0	0	0	0	0	0	0	0	0
451008	SD	school	4636990	61008	Dakota Valley 61-8	463699000809	3	Dakota Valley Middle School	Regular School	Not applicable	Middle	06	08	2021	grade_2	0.0	0.0	0.0	0.0		0.0	0.0	0.0	0.0	0	0	0	0		0	0	0	0
451009	SD	school	4636990	61008	Dakota Valley 61-8	463699001075	4	Dakota Valley Upper Elem	Regular School	Not applicable	Elementary	04	05	2021	grade_2	0.0	0.0	0.0		0.0	0.0	0.0	0.0	0.0	0	0	0		0	0	0	0	0
451066	SD	school	4617850	38002	De Smet 38-2	461785000163	1	De Smet High School	Regular School	Not applicable	High	09	12	2021	grade_2	0.0		0.0			0.0	0.0	0.0	0.0	0		0			0	0	0	0
451171	SD	school	4678300	5006	Deubrook Area 05-6	467830000012	1	Deubrook High School	Regular School	Not applicable	High	09	12	2021	grade_2	0.0	0.0	0.0	0.0		0.0	0.0	0.0	0.0	0	0	0	0		0	0	0	0
451406	SD	school	4619410	51001	Douglas 51-1	461941000174	3	Douglas High School	Regular School	Not applicable	High	09	12	2021	grade_2	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0	0	0	0	0	0	0	0	0
451407	SD	school	4619410	51001	Douglas 51-1	461941000176	1	Douglas Middle School	Regular School	Not applicable	Middle	06	08	2021	grade_2	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0	0	0	0	0	0	0	0	0
451409	SD	school	4619410	51001	Douglas 51-1	461941000436	2	Vandenberg Elementary	Regular School	Not applicable	Elementary	04	05	2021	grade_2	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0	0	0	0	0	0	0	0	0
451521	SD	school	4620100	20001	Eagle Butte 20-1	462010000605	3	C-EB Upper Elementary	Regular School	Not applicable	Elementary	03	06	2021	grade_2	0.0			0.0			0.0	0.0	0.0	0			0			0	0	0
451615	SD	school	4634440	22005	Edmunds Central 22-5	463444001066	5	Edmunds Central Elementary	Regular School	Not applicable	Elementary	PK	05	2021	grade_2	10.0		4.0	0.0			6.0	8.0	14.0	10		4	0			6	8	14
451691	SD	school	4621340	61007	Elk Point-Jefferson 61-7	462134000186	1	Elk Point Jefferson High School	Regular School	Not applicable	High	09	12	2021	grade_2	0.0	0.0	0.0	0.0		0.0	0.0	0.0	0.0	0	0	0	0		0	0	0	0
451966	SD	school	4622940	46002	Faith 46-2	462294000805	2	Faith Elementary School	Regular School	Not applicable	Elementary	KG	06	2021	grade_2	4.0		0.0	1.0	0.0	0.0	3.0	2.0	5.0	4		0	1	0	0	3	2	5
451967	SD	school	4622940	46002	Faith 46-2	462294000806	1	Faith High School	Regular School	Not applicable	High	09	12	2021	grade_2	0.0		0.0	0.0			0.0	0.0	0.0	0		0	0			0	0	0
451968	SD	school	4622940	46002	Faith 46-2	462294000995	6	Faith Jr. High	Regular School	Not applicable	Middle	07	08	2021	grade_2	0.0		0.0	0.0			0.0	0.0	0.0	0		0	0			0	0	0
452142	SD	school	4624390	50003	Flandreau 50-3	462439000207	4	Flandreau Elem	Regular School	Not applicable	Elementary	KG	04	2021	grade_2	22.0		8.0	13.0	0.0	6.0	25.0	24.0	49.0	22		8	13	0	6	25	24	49
452143	SD	school	4624390	50003	Flandreau 50-3	462439000206	1	Flandreau High Sch	Regular School	Not applicable	High	09	12	2021	grade_2	0.0		0.0	0.0	0.0	0.0	0.0	0.0	0.0	0		0	0	0	0	0	0	0
452144	SD	school	4624390	50003	Flandreau 50-3	462439000205	3	Flandreau Middle Sch	Regular School	Not applicable	Middle	05	08	2021	grade_2	0.0		0.0	0.0	0.0	0.0	0.0	0.0	0.0	0		0	0	0	0	0	0	0
452379	SD	school	4626370	49004	Garretson 49-4	462637000224	1	Garretson High School	Regular School	Not applicable	High	09	12	2021	grade_2	0.0		0.0	0.0		0.0	0.0	0.0	0.0	0		0	0		0	0	0	0
452380	SD	school	4626370	49004	Garretson 49-4	462637000843	3	Garretson Middle School	Regular School	Not applicable	Middle	06	08	2021	grade_2	0.0		0.0			0.0	0.0	0.0	0.0	0		0			0	0	0	0
452522	SD	school	4629880	26004	Gregory 26-4	462988000238	2	Gregory Elementary School	Regular School	Not applicable	Elementary	PK	05	2021	grade_2	20.0		2.0	3.0	0.0	0.0	13.0	12.0	25.0	20		2	3	0	0	13	12	25
452523	SD	school	4629880	26004	Gregory 26-4	462988000239	1	Gregory High School	Regular School	Not applicable	High	09	12	2021	grade_2	0.0	0.0	0.0	0.0		0.0	0.0	0.0	0.0	0	0	0	0		0	0	0	0
452524	SD	school	4629880	26004	Gregory 26-4	462988001296	4	Gregory Jr High School	Regular School	Not applicable	Middle	06	08	2021	grade_2	0.0		0.0	0.0	0.0		0.0	0.0	0.0	0		0	0	0		0	0	0
452570	SD	school	4600045	6006	Groton Area	460004501156	2	Groton Area Elementary School	Regular School	Not applicable	Elementary	PK	05	2021	grade_2	45.0		2.0	0.0		0.0	25.0	22.0	47.0	45		2	0		0	25	22	47
452571	SD	school	4600045	6006	Groton Area	460004501155	1	Groton Area High School	Regular School	Not applicable	High	09	12	2021	grade_2	0.0		0.0	0.0			0.0	0.0	0.0	0		0	0			0	0	0
452572	SD	school	4600045	6006	Groton Area	460004501157	4	Groton Area MS	Regular School	Not applicable	Middle	06	08	2021	grade_2	0.0		0.0	0.0		0.0	0.0	0.0	0.0	0		0	0		0	0	0	0
452625	SD	school	4630490	27001	Haakon 27-1	463049000247	3	Philip Junior High	Regular School	Not applicable	Middle	07	08	2021	grade_2	0.0		0.0	0.0		0.0	0.0	0.0	0.0	0		0	0		0	0	0	0
452684	SD	school	4630800	28003	Hamlin 28-3	463080000259	2	Hamlin Middle School	Regular School	Not applicable	Middle	06	08	2021	grade_2	0.0	0.0	0.0	0.0		0.0	0.0	0.0	0.0	0	0	0	0		0	0	0	0
452933	SD	school	4631350	41002	Harrisburg 41-2	463135000264	1	Harrisburg High School	Regular School	Not applicable	High	09	12	2021	grade_2	0.0	0.0	0.0	0.0		0.0	0.0	0.0	0.0	0	0	0	0		0	0	0	0
452934	SD	school	4631350	41002	Harrisburg 41-2	463135001334	8	Harrisburg North MS	Regular School	Not applicable	Middle	06	08	2021	grade_2	0.0	0.0	0.0	0.0		0.0	0.0	0.0	0.0	0	0	0	0		0	0	0	0
452935	SD	school	4631350	41002	Harrisburg 41-2	463135000847	3	Harrisburg South MS	Regular School	Not applicable	Middle	06	08	2021	grade_2	0.0	0.0	0.0			0.0	0.0	0.0	0.0	0	0	0			0	0	0	0
452938	SD	school	4631350	41002	Harrisburg 41-2	463135000263	2	Liberty Elementary	Regular School	Not applicable	Elementary	PK	05	2021	grade_2	96.0	1.0	3.0	0.0		3.0	55.0	48.0	103.0	96	1	3	0		3	55	48	103
453051	SD	school	4632340	14002	Henry 14-2	463234000276	1	Henry High School	Regular School	Not applicable	High	09	12	2021	grade_2	0.0		0.0				0.0	0.0	0.0	0		0				0	0	0
453052	SD	school	4632340	14002	Henry 14-2	463234001047	3	Henry MS	Regular School	Not applicable	Middle	06	08	2021	grade_2	0.0						0.0	0.0	0.0	0						0	0	0
453195	SD	school	4633360	51002	Hill City 51-2	463336000280	1	Hill City High School	Regular School	Not applicable	High	09	12	2021	grade_2	0.0	0.0	0.0	0.0			0.0	0.0	0.0	0	0	0	0			0	0	0
453196	SD	school	4633360	51002	Hill City 51-2	463336000848	4	Hill City Middle Sch	Regular School	Not applicable	Middle	06	08	2021	grade_2	0.0		0.0	0.0		0.0	0.0	0.0	0.0	0		0	0		0	0	0	0
453322	SD	school	4634480	23002	Hot Springs 23-2	463448000287	2	Hot Springs Elementary	Regular School	Not applicable	Elementary	PK	05	2021	grade_2	42.0	0.0	1.0	4.0	0.0	9.0	28.0	28.0	56.0	42	0	1	4	0	9	28	28	56
453323	SD	school	4634480	23002	Hot Springs 23-2	463448000288	1	Hot Springs Hi Sch	Regular School	Not applicable	High	09	12	2021	grade_2	0.0	0.0	0.0	0.0		0.0	0.0	0.0	0.0	0	0	0	0		0	0	0	0
453324	SD	school	4634480	23002	Hot Springs 23-2	463448000911	6	Hot Springs Middle Sch	Regular School	Not applicable	Middle	06	08	2021	grade_2	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0	0	0	0	0	0	0	0	0
453498	SD	school	4635480	2002	Huron 02-2	463548001370	18	Buchanan K-1 Center	Regular School	Not applicable	Elementary	KG	01	2021	grade_2	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0	0	0	0	0	0	0	0	0
453500	SD	school	4635480	2002	Huron 02-2	463548000313	1	Huron High School	Regular School	Not applicable	High	09	12	2021	grade_2	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0	0	0	0	0	0	0	0	0
453501	SD	school	4635480	2002	Huron 02-2	463548000314	2	Huron Middle School	Regular School	Not applicable	Middle	06	08	2021	grade_2	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0	0	0	0	0	0	0	0	0
453504	SD	school	4635480	2002	Huron 02-2	463548001373	20	Washington 4-5 Center	Regular School	Not applicable	Elementary	04	05	2021	grade_2	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0	0	0	0	0	0	0	0	0
453607	SD	school	4636060	22006	Ipswich Public 22-6	463606000332	2	Ipswich Elem	Regular School	Not applicable	Elementary	PK	05	2021	grade_2	25.0	1.0	0.0	0.0		0.0	10.0	16.0	26.0	25	1	0	0		0	10	16	26
453608	SD	school	4636060	22006	Ipswich Public 22-6	463606000333	1	Ipswich Hi Sch	Regular School	Not applicable	High	09	12	2021	grade_2	0.0	0.0	0.0			0.0	0.0	0.0	0.0	0	0	0			0	0	0	0
453863	SD	school	4680437	35002	Kadoka Area 35-2	468043701247	1	Kadoka Area HS	Regular School	Not applicable	High	09	12	2021	grade_2	0.0		0.0	0.0			0.0	0.0	0.0	0		0	0			0	0	0
454143	SD	school	4641300	40001	Lead-Deadwood 40-1	464130000372	3	Lead-Deadwood Elementary	Regular School	Not applicable	Elementary	KG	05	2021	grade_2	32.0		3.0	2.0		4.0	22.0	19.0	41.0	32		3	2		4	22	19	41
454144	SD	school	4641300	40001	Lead-Deadwood 40-1	464130000374	1	Lead-Deadwood High School	Regular School	Not applicable	High	09	12	2021	grade_2	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0	0	0	0	0	0	0	0	0
454145	SD	school	4641300	40001	Lead-Deadwood 40-1	464130000373	2	Lead-Deadwood Middle School	Regular School	Not applicable	Middle	06	08	2021	grade_2	0.0	0.0	0.0	0.0		0.0	0.0	0.0	0.0	0	0	0	0		0	0	0	0
454258	SD	school	4641550	41004	Lennox 41-4	464155000386	2	Lennox Elementary	Regular School	Not applicable	Elementary	PK	04	2021	grade_2	68.0	1.0	0.0	1.0		3.0	43.0	30.0	73.0	68	1	0	1		3	43	30	73
454260	SD	school	4641550	41004	Lennox 41-4	464155001363	9	Lennox Intermediate	Regular School	Not applicable	Middle	05	06	2021	grade_2	0.0	0.0	0.0	0.0		0.0	0.0	0.0	0.0	0	0	0	0		0	0	0	0
454490	SD	school	4639600	39002	Madison Central 39-2	463960001189	7	Madison Elementary School	Regular School	Not applicable	Elementary	KG	05	2021	grade_2	64.0	2.0	3.0	3.0		1.0	42.0	31.0	73.0	64	2	3	3		1	42	31	73
454491	SD	school	4639600	39002	Madison Central 39-2	463960000363	1	Madison High School	Regular School	Not applicable	High	09	12	2021	grade_2	0.0	0.0	0.0	0.0		0.0	0.0	0.0	0.0	0	0	0	0		0	0	0	0
454492	SD	school	4639600	39002	Madison Central 39-2	463960000364	2	Madison Middle School	Regular School	Not applicable	Middle	06	08	2021	grade_2	0.0	0.0	0.0	0.0		0.0	0.0	0.0	0.0	0	0	0	0		0	0	0	0
454788	SD	school	4669930	46001	Meade 46-1	466993001392	10	Stagebarn Middle School	Regular School	Not applicable	Middle	05	08	2021	grade_2	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0	0	0	0	0	0	0	0	0
454789	SD	school	4669930	46001	Meade 46-1	466993000633	1	Sturgis Brown HS	Regular School	Not applicable	High	09	12	2021	grade_2	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0	0	0	0	0	0	0	0	0
454791	SD	school	4669930	46001	Meade 46-1	466993001383	6	Sturgis Intermediate School	Regular School	Not applicable	Middle	05	05	2021	grade_2	0.0	0.0	0.0	0.0		0.0	0.0	0.0	0.0	0	0	0	0		0	0	0	0
454792	SD	school	4669930	46001	Meade 46-1	466993000653	2	Sturgis Williams MS	Regular School	Not applicable	Middle	06	08	2021	grade_2	0.0	0.0	0.0	0.0		0.0	0.0	0.0	0.0	0	0	0	0		0	0	0	0
455163	SD	school	4648390	17002	Mitchell 17-2	464839000520	3	L B Williams Elementary	Regular School	Not applicable	Elementary	KG	05	2021	grade_2	53.0	0.0	7.0	3.0		2.0	33.0	32.0	65.0	53	0	7	3		2	33	32	65
455165	SD	school	4648390	17002	Mitchell 17-2	464839000442	1	Mitchell High School	Regular School	Not applicable	High	09	12	2021	grade_2	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0	0	0	0	0	0	0	0	0
455166	SD	school	4648390	17002	Mitchell 17-2	464839000437	2	Mitchell Middle School	Regular School	Not applicable	Middle	06	08	2021	grade_2	0.0	0.0	0.0	0.0		0.0	0.0	0.0	0.0	0	0	0	0		0	0	0	0
455264	SD	school	4680441	62006	Mobridge-Pollock 62-6	468044100450	2	Mobridge Middle School	Regular School	Not applicable	Middle	06	08	2021	grade_2	0.0	0.0	0.0	0.0		0.0	0.0	0.0	0.0	0	0	0	0		0	0	0	0
455265	SD	school	4680441	62006	Mobridge-Pollock 62-6	468044100493	4	Mobridge Upper Elementary	Regular School	Not applicable	Elementary	03	05	2021	grade_2	0.0	0.0	0.0	0.0		0.0	0.0	0.0	0.0	0	0	0	0		0	0	0	0
455482	SD	school	4650850	9002	Newell 09-2	465085000468	2	Newell Elem	Regular School	Not applicable	Elementary	PK	05	2021	grade_2	19.0	0.0	1.0	0.0			8.0	12.0	20.0	19	0	1	0			8	12	20
455483	SD	school	4650850	9002	Newell 09-2	465085000469	1	Newell High School	Regular School	Not applicable	High	09	12	2021	grade_2	0.0	0.0		0.0		0.0	0.0	0.0	0.0	0	0		0		0	0	0	0
455986	SD	school	4655260	32002	Pierre 32-2	465526000494	3	Buchanan Elementary	Regular School	Not applicable	Elementary	KG	05	2021	grade_2	44.0	0.0	4.0	12.0		7.0	37.0	30.0	67.0	44	0	4	12		7	37	30	67
455987	SD	school	4655260	32002	Pierre 32-2	465526000501	2	Georgia Morse Middle School	Regular School	Not applicable	Middle	06	08	2021	grade_2	0.0	0.0	0.0	0.0		0.0	0.0	0.0	0.0	0	0	0	0		0	0	0	0
455988	SD	school	4655260	32002	Pierre 32-2	465526000495	6	Jefferson Elementary	Regular School	Not applicable	Elementary	KG	05	2021	grade_2	48.0	0.0	4.0	13.0		4.0	31.0	38.0	69.0	48	0	4	13		4	31	38	69
455989	SD	school	4655260	32002	Pierre 32-2	465526001353	8	Kennedy Elementary School	Regular School	Not applicable	Elementary	KG	05	2021	grade_2	37.0	1.0	3.0	10.0		8.0	24.0	35.0	59.0	37	1	3	10		8	24	35	59