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 multiracial 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	male	female	total	white_int	black_int	hispanic_int	native_american_int	asian_int	pacific_islander_int	male_int	female_int	total_int
487429	SD	school	4602070	6001	Aberdeen 06-1	460207001130	89	New Beginnings	Alternative School	Not applicable	High	05	12	2020	grade_7	0.0	0.0	0.0	1.0			0.0	1.0	1.0	0	0	0	1			0	1	1
487644	SD	school	4639540	11001	Andes Central 11-1	463954001080	5	Lakeview Colony Elem	Regular School	Not applicable	Elementary	KG	08	2020	grade_7	3.0						1.0	2.0	3.0	3						1	2	3
487705	SD	school	4603720	38001	Arlington 38-1	460372000021	2	Arlington Elementary	Regular School	Not applicable	Elementary	KG	06	2020	grade_7	0.0		0.0				0.0	0.0	0.0	0		0				0	0	0
487706	SD	school	4603720	38001	Arlington 38-1	460372000022	1	Arlington High School	Regular School	Not applicable	High	09	12	2020	grade_7	0.0		0.0				0.0	0.0	0.0	0		0				0	0	0
487707	SD	school	4603720	38001	Arlington 38-1	460372000877	3	Arlington Junior High School	Regular School	Not applicable	Middle	07	08	2020	grade_7	19.0		2.0	0.0	1.0		11.0	11.0	22.0	19		2	0	1		11	11	22
487708	SD	school	4603720	38001	Arlington 38-1	460372001381	4	Arlington PreSchool	Regular School	Not applicable	Prekindergarten	PK	PK	2020	grade_7	0.0						0.0	0.0	0.0	0						0	0	0
487761	SD	school	4603780	21001	Armour 21-1	460378000024	1	Armour High School	Regular School	Not applicable	High	09	12	2020	grade_7	0.0		0.0	0.0			0.0	0.0	0.0	0		0	0			0	0	0
487938	SD	school	4605610	9001	Belle Fourche 09-1	460561001277	9	Belle Fourche Education Connection	Alternative School	Not applicable	High	09	12	2020	grade_7	0.0		0.0	0.0			0.0	0.0	0.0	0		0	0			0	0	0
488129	SD	school	4607050	52001	Bison 52-1	460705000055	1	Bison High School	Regular School	Not applicable	High	09	12	2020	grade_7	0.0						0.0	0.0	0.0	0						0	0	0
488223	SD	school	4607400	4002	Bon Homme 04-2	460740001328	8	Bon Homme PK	Regular School	Not applicable	Prekindergarten	PK	PK	2020	grade_7	0.0		0.0	0.0			0.0	0.0	0.0	0		0	0			0	0	0
488224	SD	school	4607400	4002	Bon Homme 04-2	460740001393	20	Dawson Colony School	Regular School	Not applicable	Elementary	KG	08	2020	grade_7	1.0						0.0	1.0	1.0	1						0	1	1
488225	SD	school	4607400	4002	Bon Homme 04-2	460740000060	18	Hutterische Colony Elementary	Regular School	Not applicable	Elementary	KG	08	2020	grade_7	6.0						2.0	4.0	6.0	6						2	4	6
488227	SD	school	4607400	4002	Bon Homme 04-2	460740000063	5	Tabor Elementary	Regular School	Not applicable	Elementary	KG	05	2020	grade_7	0.0			0.0			0.0	0.0	0.0	0			0			0	0	0
488305	SD	school	4607800	22001	Bowdle 22-1	460780000069	1	Bowdle High School	Regular School	Not applicable	High	09	12	2020	grade_7	0.0				0.0		0.0	0.0	0.0	0				0		0	0	0
488306	SD	school	4607800	22001	Bowdle 22-1	460780000883	3	Bowdle Jr High	Regular School	Not applicable	Middle	07	08	2020	grade_7	6.0						1.0	5.0	6.0	6						1	5	6
488464	SD	school	4621420	30003	Bridgewater-Emery 30-3	462142010071	2	Bridgewater-Emery Elementary	Regular School	Not applicable	Elementary	PK	05	2020	grade_7	0.0	0.0	0.0				0.0	0.0	0.0	0	0	0				0	0	0
488465	SD	school	4621420	30003	Bridgewater-Emery 30-3	462142000074	1	Bridgewater-Emery High School	Regular School	Not applicable	High	09	12	2020	grade_7	0.0	0.0	0.0	0.0			0.0	0.0	0.0	0	0	0	0			0	0	0
488540	SD	school	4600041	45004	Britton-Hecla 45-4	460004101141	1	Britton-Hecla High School	Regular School	Not applicable	High	09	12	2020	grade_7	0.0	0.0	0.0	0.0	0.0		0.0	0.0	0.0	0	0	0	0	0		0	0	0
488542	SD	school	4600041	45004	Britton-Hecla 45-4	460004101143	4	Sunset Colony Elementary	Regular School	Not applicable	Elementary	KG	08	2020	grade_7	2.0						1.0	1.0	2.0	2						1	1	2
488543	SD	school	4600041	45004	Britton-Hecla 45-4	460004101364	6	Sunset Colony High School	Regular School	Not applicable	High	09	12	2020	grade_7	0.0						0.0	0.0	0.0	0						0	0	0
488544	SD	school	4600041	45004	Britton-Hecla 45-4	460004101180	5	Westwood Rural Elementary	Regular School	Not applicable	Elementary	KG	08	2020	grade_7	1.0						0.0	1.0	1.0	1						0	1	1
488706	SD	school	4609512	26002	Burke 26-2	460951201043	4	Burke Middle School	Regular School	Not applicable	Middle	06	08	2020	grade_7	21.0		0.0	1.0		0.0	10.0	12.0	22.0	21		0	1		0	10	12	22
488753	SD	school	4610320	43001	Canistota 43-1	461032000105	1	Canistota High School	Regular School	Not applicable	High	09	12	2020	grade_7	0.0	0.0	0.0	0.0			0.0	0.0	0.0	0	0	0	0			0	0	0
488754	SD	school	4610320	43001	Canistota 43-1	461032001016	3	Canistota Middle School	Regular School	Not applicable	Middle	06	08	2020	grade_7	17.0	1.0	0.0				11.0	7.0	18.0	17	1	0				11	7	18
488858	SD	school	4611280	28001	Castlewood 28-1	461128000114	1	Castlewood High School	Regular School	Not applicable	High	09	12	2020	grade_7	0.0		0.0				0.0	0.0	0.0	0		0				0	0	0
488860	SD	school	4611280	28001	Castlewood 28-1	461128001126	4	Claremont Colony Elementary	Regular School	Not applicable	Elementary	KG	08	2020	grade_7	1.0						1.0	0.0	1.0	1						1	0	1
488914	SD	school	4611760	60001	Centerville 60-1	461176001023	3	Centerville Middle School	Regular School	Not applicable	Middle	06	08	2020	grade_7	24.0	0.0	0.0	0.0			14.0	10.0	24.0	24	0	0	0			14	10	24
489044	SD	school	4612300	39001	Chester Area 39-1	461230001269	92	Chester Area Cyber School	Regular School	Not applicable	High	09	12	2020	grade_7	0.0						0.0	0.0	0.0	0						0	0	0
489046	SD	school	4612300	39001	Chester Area 39-1	461230000130	1	Chester Area High School	Regular School	Not applicable	High	09	12	2020	grade_7	0.0		0.0	0.0			0.0	0.0	0.0	0		0	0			0	0	0
489047	SD	school	4612300	39001	Chester Area 39-1	461230000832	3	Chester Area Middle School	Regular School	Not applicable	Middle	06	08	2020	grade_7	23.0						8.0	15.0	23.0	23						8	15	23
489048	SD	school	4612300	39001	Chester Area 39-1	461230001377	7	Gracevale Colony	Regular School	Not applicable	Elementary	KG	08	2020	grade_7	1.0						0.0	1.0	1.0	1						0	1	1
489050	SD	school	4612300	39001	Chester Area 39-1	461230001092	4	Rustic Acres	Regular School	Not applicable	Elementary	KG	08	2020	grade_7	1.0						1.0	0.0	1.0	1						1	0	1
489148	SD	school	4612940	12002	Clark 12-2	461294000133	1	Clark High School	Regular School	Not applicable	High	09	12	2020	grade_7	0.0	0.0	0.0				0.0	0.0	0.0	0	0	0				0	0	0
489150	SD	school	4612940	12002	Clark 12-2	461294001081	4	Fordham Colony Elementary	Regular School	Not applicable	Elementary	KG	08	2020	grade_7	2.0						2.0	0.0	2.0	2						2	0	2
489151	SD	school	4612940	12002	Clark 12-2	461294001082	5	Hillcrest Colony Elementary	Regular School	Not applicable	Elementary	KG	08	2020	grade_7	3.0						2.0	1.0	3.0	3						2	1	3
489152	SD	school	4612940	12002	Clark 12-2	461294001319	7	Silver Creek Colony	Regular School	Not applicable	Elementary	KG	08	2020	grade_7	5.0						3.0	2.0	5.0	5						3	2	5
489217	SD	school	4614100	50005	Colman-Egan 50-5	461410000091	1	Colman-Egan Hi Sch	Regular School	Not applicable	High	09	12	2020	grade_7	0.0	0.0	0.0	0.0	0.0		0.0	0.0	0.0	0	0	0	0	0		0	0	0
489276	SD	school	4614130	59003	Colome Consolidated	461413000787	5	Wood Elementary	Regular School	Not applicable	Elementary	KG	08	2020	grade_7	0.0			0.0			0.0	0.0	0.0	0			0			0	0	0
489328	SD	school	4680445	21003	Corsica-Stickney 21-3	468044501354	2	Corsica-Stickney Elementary	Regular School	Not applicable	Elementary	PK	06	2020	grade_7	0.0		0.0	0.0	0.0		0.0	0.0	0.0	0		0	0	0		0	0	0
489329	SD	school	4680445	21003	Corsica-Stickney 21-3	468044501357	1	Corsica-Stickney High School	Regular School	Not applicable	High	09	12	2020	grade_7	0.0						0.0	0.0	0.0	0						0	0	0
489330	SD	school	4680445	21003	Corsica-Stickney 21-3	468044501352	3	Corsica-Stickney Jr. High	Regular School	Not applicable	Middle	07	08	2020	grade_7	13.0						8.0	5.0	13.0	13						8	5	13
489504	SD	school	4617850	38002	De Smet 38-2	461785000163	1	De Smet High School	Regular School	Not applicable	High	09	12	2020	grade_7	0.0		0.0				0.0	0.0	0.0	0		0				0	0	0
489505	SD	school	4617850	38002	De Smet 38-2	461785000993	3	De Smet Middle School	Regular School	Not applicable	Middle	06	08	2020	grade_7	13.0				0.0		9.0	4.0	13.0	13				0		9	4	13
489619	SD	school	4678300	5006	Deubrook Area 05-6	467830000012	1	Deubrook High School	Regular School	Not applicable	High	09	12	2020	grade_7	0.0	0.0	0.0	0.0	0.0		0.0	0.0	0.0	0	0	0	0	0		0	0	0
489620	SD	school	4678300	5006	Deubrook Area 05-6	467830000016	2	Deubrook Jr High	Regular School	Not applicable	Middle	07	08	2020	grade_7	14.0		0.0				6.0	8.0	14.0	14		0				6	8	14
489621	SD	school	4678300	5006	Deubrook Area 05-6	467830001154	7	Norfeld Colony School	Regular School	Not applicable	Elementary	KG	08	2020	grade_7	3.0						1.0	2.0	3.0	3						1	2	3
489622	SD	school	4678300	5006	Deubrook Area 05-6	467830001320	9	Red Willow Colony School	Regular School	Not applicable	Elementary	KG	08	2020	grade_7	2.0						2.0	0.0	2.0	2						2	0	2
489680	SD	school	4600036	19004	Deuel 19-4	460003601011	2	Clear Lake Elementary	Regular School	Not applicable	Elementary	PK	05	2020	grade_7	0.0	0.0	0.0	0.0		0.0	0.0	0.0	0.0	0	0	0	0		0	0	0	0
489764	SD	school	4619170	56002	Doland 56-2	461917001299	6	Camrose Colony Elementary	Regular School	Not applicable	Elementary	KG	08	2020	grade_7	1.0						1.0	0.0	1.0	1						1	0	1
489765	SD	school	4619170	56002	Doland 56-2	461917001101	5	Clark Colony Elementary	Regular School	Not applicable	Elementary	KG	08	2020	grade_7	0.0						0.0	0.0	0.0	0						0	0	0
489766	SD	school	4619170	56002	Doland 56-2	461917000170	3	Doland Elementary	Regular School	Not applicable	Elementary	PK	06	2020	grade_7	0.0		0.0				0.0	0.0	0.0	0		0				0	0	0
489767	SD	school	4619170	56002	Doland 56-2	461917000171	1	Doland High School	Regular School	Not applicable	High	09	12	2020	grade_7	0.0						0.0	0.0	0.0	0						0	0	0
489768	SD	school	4619170	56002	Doland 56-2	461917000895	2	Doland Junior High	Regular School	Not applicable	Middle	07	08	2020	grade_7	8.0		0.0				4.0	4.0	8.0	8		0				4	4	8
489769	SD	school	4619170	56002	Doland 56-2	461917001100	4	Hillside Colony Elementary	Regular School	Not applicable	Elementary	KG	08	2020	grade_7	5.0						2.0	3.0	5.0	5						2	3	5
489770	SD	school	4619170	56002	Doland 56-2	461917001359	7	Hillside Colony High School	Regular School	Not applicable	High	09	12	2020	grade_7	0.0						0.0	0.0	0.0	0						0	0	0
489977	SD	school	4620100	20001	Eagle Butte 20-1	462010001233	7	C-EB E.A.G.L.E. Center High School	Alternative School	Not applicable	High	09	12	2020	grade_7	0.0			0.0			0.0	0.0	0.0	0			0			0	0	0
489978	SD	school	4620100	20001	Eagle Butte 20-1	462010000956	1	C-EB High School	Regular School	Not applicable	High	09	12	2020	grade_7	0.0		0.0	0.0			0.0	0.0	0.0	0		0	0			0	0	0
489979	SD	school	4620100	20001	Eagle Butte 20-1	462010000897	2	C-EB Primary	Regular School	Not applicable	Elementary	KG	02	2020	grade_7	0.0			0.0			0.0	0.0	0.0	0			0			0	0	0
489980	SD	school	4620100	20001	Eagle Butte 20-1	462010000605	3	C-EB Upper Elementary	Regular School	Not applicable	Elementary	03	06	2020	grade_7	0.0			0.0	0.0	0.0	0.0	0.0	0.0	0			0	0	0	0	0	0
490073	SD	school	4634440	22005	Edmunds Central 22-5	463444001385	6	Boulder Colony School	Regular School	Not applicable	Elementary	KG	08	2020	grade_7	1.0						0.0	1.0	1.0	1						0	1	1
490074	SD	school	4634440	22005	Edmunds Central 22-5	463444001066	5	Edmunds Central Elementary	Regular School	Not applicable	Elementary	PK	05	2020	grade_7	0.0		0.0		0.0		0.0	0.0	0.0	0		0		0		0	0	0
490075	SD	school	4634440	22005	Edmunds Central 22-5	463444000031	1	Edmunds Central Hi Sch	Regular School	Not applicable	High	09	12	2020	grade_7	0.0		0.0	0.0			0.0	0.0	0.0	0		0	0			0	0	0
490076	SD	school	4634440	22005	Edmunds Central 22-5	463444000032	2	Edmunds Central Middle School	Regular School	Not applicable	Middle	06	08	2020	grade_7	7.0		1.0	0.0			4.0	4.0	8.0	7		1	0			4	4	8
490110	SD	school	4621300	16002	Elk Mountain 16-2	462130000899	1	Elk Mountain Elem	Regular School	Not applicable	Elementary	PK	08	2020	grade_7	0.0	0.0					0.0	0.0	0.0	0	0					0	0	0
490213	SD	school	4621390	5003	Elkton 05-3	462139001078	4	Newdale Colony Elem	Regular School	Not applicable	Elementary	KG	08	2020	grade_7	2.0						1.0	1.0	2.0	2						1	1	2
490214	SD	school	4621390	5003	Elkton 05-3	462139001168	5	Rolland Colony Elem	Regular School	Not applicable	Elementary	KG	08	2020	grade_7	1.0						1.0	0.0	1.0	1						1	0	1
490273	SD	school	4622410	28002	Estelline 28-2	462241000192	1	Estelline High School	Regular School	Not applicable	High	09	12	2020	grade_7	0.0		0.0				0.0	0.0	0.0	0		0				0	0	0
490370	SD	school	4622560	44001	Eureka 44-1	462256000958	3	Eureka Jr. High	Regular School	Not applicable	Middle	07	08	2020	grade_7	7.0	0.0		0.0			3.0	4.0	7.0	7	0		0			3	4	7
490425	SD	school	4622940	46002	Faith 46-2	462294000805	2	Faith Elementary School	Regular School	Not applicable	Elementary	KG	06	2020	grade_7	0.0		0.0	0.0	0.0		0.0	0.0	0.0	0		0	0	0		0	0	0
490426	SD	school	4622940	46002	Faith 46-2	462294000806	1	Faith High School	Regular School	Not applicable	High	09	12	2020	grade_7	0.0		0.0	0.0	0.0		0.0	0.0	0.0	0		0	0	0		0	0	0
490427	SD	school	4622940	46002	Faith 46-2	462294000995	6	Faith Jr. High	Regular School	Not applicable	Middle	07	08	2020	grade_7	10.0			3.0	1.0		6.0	8.0	14.0	10			3	1		6	8	14
490428	SD	school	4622940	46002	Faith 46-2	462294000412	4	Maurine Elem.	Regular School	Not applicable	Elementary	KG	08	2020	grade_7	2.0						1.0	1.0	2.0	2						1	1	2
490507	SD	school	4624030	24004	Faulkton Area	462403001158	6	Blumengard Colony Elem	Regular School	Not applicable	Elementary	KG	08	2020	grade_7	2.0						2.0	0.0	2.0	2						2	0	2
490508	SD	school	4624030	24004	Faulkton Area	462403001090	5	Brentwood Colony School	Regular School	Not applicable	Elementary	KG	08	2020	grade_7	1.0						1.0	0.0	1.0	1						1	0	1
490510	SD	school	4624030	24004	Faulkton Area	462403000203	1	Faulkton Hi Sch	Regular School	Not applicable	High	09	12	2020	grade_7	0.0	0.0					0.0	0.0	0.0	0	0					0	0	0
490512	SD	school	4624030	24004	Faulkton Area	462403001160	10	Thunderbird Colony Elem	Regular School	Not applicable	Elementary	KG	08	2020	grade_7	6.0						4.0	2.0	6.0	6						4	2	6
490588	SD	school	4624390	50003	Flandreau 50-3	462439001119	6	Pleasant Valley Colony Elem	Regular School	Not applicable	Elementary	KG	08	2020	grade_7	2.0						2.0	0.0	2.0	2						2	0	2
490754	SD	school	4625500	33001	Freeman 33-1	462550000219	2	Freeman Elem	Regular School	Not applicable	Elementary	KG	06	2020	grade_7	1.0		0.0	0.0	0.0		1.0	0.0	1.0	1		0	0	0		1	0	1
490756	SD	school	4625500	33001	Freeman 33-1	462550000842	5	Freeman Jr High	Regular School	Not applicable	Middle	07	08	2020	grade_7	20.0	1.0	1.0				8.0	14.0	22.0	20	1	1				8	14	22
490757	SD	school	4625500	33001	Freeman 33-1	462550000221	3	Tschetter Colony Elementary	Regular School	Not applicable	Elementary	KG	08	2020	grade_7	1.0						1.0	0.0	1.0	1						1	0	1
490758	SD	school	4625500	33001	Freeman 33-1	462550000222	4	Wolf Creek Colony Elementary	Regular School	Not applicable	Elementary	KG	08	2020	grade_7	3.0						1.0	2.0	3.0	3						1	2	3
490961	SD	school	4629880	26004	Gregory 26-4	462988000239	1	Gregory High School	Regular School	Not applicable	High	09	12	2020	grade_7	0.0			0.0	0.0	0.0	0.0	0.0	0.0	0			0	0	0	0	0	0
491009	SD	school	4600045	6006	Groton Area	460004501155	1	Groton Area High School	Regular School	Not applicable	High	09	12	2020	grade_7	0.0	0.0	0.0	0.0	0.0		0.0	0.0	0.0	0	0	0	0	0		0	0	0
491065	SD	school	4630490	27001	Haakon 27-1	463049000647	8	Milesville Elem	Regular School	Not applicable	Elementary	KG	08	2020	grade_7	0.0						0.0	0.0	0.0	0						0	0	0
491195	SD	school	4602640	30001	Hanson 30-1	460264001272	7	Hanson Alternative Colony High School	Regular School	Not applicable	High	09	12	2020	grade_7	0.0						0.0	0.0	0.0	0						0	0	0
491199	SD	school	4602640	30001	Hanson 30-1	460264000015	4	Millbrook Colony Elementary	Regular School	Not applicable	Elementary	KG	08	2020	grade_7	1.0						0.0	1.0	1.0	1						0	1	1
491200	SD	school	4602640	30001	Hanson 30-1	460264000875	5	Oaklane Colony	Regular School	Not applicable	Elementary	KG	08	2020	grade_7	2.0		0.0				0.0	2.0	2.0	2		0				0	2	2
491283	SD	school	4609300	31001	Harding County 31-1	460930000701	8	Camp Crook Elementary	Regular School	Not applicable	Elementary	KG	08	2020	grade_7	0.0						0.0	0.0	0.0	0						0	0	0
491284	SD	school	4609300	31001	Harding County 31-1	460930000088	1	Harding County High School	Regular School	Not applicable	High	09	12	2020	grade_7	0.0	0.0	0.0	0.0			0.0	0.0	0.0	0	0	0	0			0	0	0
491285	SD	school	4609300	31001	Harding County 31-1	460930000887	3	Harding County MS	Regular School	Not applicable	Middle	06	08	2020	grade_7	17.0			1.0			9.0	9.0	18.0	17			1			9	9	18
491286	SD	school	4609300	31001	Harding County 31-1	460930000667	6	Ludlow Elementary	Regular School	Not applicable	Elementary	KG	08	2020	grade_7	0.0						0.0	0.0	0.0	0						0	0	0
491488	SD	school	4632340	14002	Henry 14-2	463234000275	2	Henry Elementary	Regular School	Not applicable	Elementary	PK	05	2020	grade_7	0.0				0.0		0.0	0.0	0.0	0				0		0	0	0
491489	SD	school	4632340	14002	Henry 14-2	463234000276	1	Henry High School	Regular School	Not applicable	High	09	12	2020	grade_7	0.0		0.0	0.0	0.0		0.0	0.0	0.0	0		0	0	0		0	0	0
491490	SD	school	4632340	14002	Henry 14-2	463234001047	3	Henry MS	Regular School	Not applicable	Middle	06	08	2020	grade_7	16.0						8.0	8.0	16.0	16						8	8	16
491538	SD	school	4632430	10001	Herreid 10-1	463243000910	3	Herreid Middle Sch	Regular School	Not applicable	Middle	06	08	2020	grade_7	10.0		0.0				4.0	6.0	10.0	10		0				4	6	10
491586	SD	school	4680440	34002	Highmore-Harrold	468044001049	3	Highmore-Harrold Junior High	Regular School	Not applicable	Middle	07	08	2020	grade_7	15.0			1.0			9.0	7.0	16.0	15			1			9	7	16
491633	SD	school	4633360	51002	Hill City 51-2	463336000280	1	Hill City High School	Regular School	Not applicable	High	09	12	2020	grade_7	0.0	0.0	0.0	0.0	0.0		0.0	0.0	0.0	0	0	0	0	0		0	0	0
491698	SD	school	4600046	56006	Hitchcock-Tulare	460004601166	4	Glendale Colony Elem	Regular School	Not applicable	Elementary	KG	08	2020	grade_7	3.0						2.0	1.0	3.0	3						2	1	3
491699	SD	school	4600046	56006	Hitchcock-Tulare	460004601167	5	Hitchcock-Tulare Elementary	Regular School	Not applicable	Elementary	KG	06	2020	grade_7	0.0						0.0	0.0	0.0	0						0	0	0
491700	SD	school	4600046	56006	Hitchcock-Tulare	460004601163	1	Hitchcock-Tulare HS	Regular School	Not applicable	High	09	12	2020	grade_7	0.0			0.0			0.0	0.0	0.0	0			0			0	0	0
491701	SD	school	4600046	56006	Hitchcock-Tulare	460004601164	2	Hitchcock-Tulare JH	Regular School	Not applicable	Middle	07	08	2020	grade_7	11.0			1.0			7.0	5.0	12.0	11			1			7	5	12