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 order by ccd_school_low_grade 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
250425	SD	school	4605610	9001	Belle Fourche 09-1	460561000269	3	South Park Elementary	Regular School	No	Elementary	01	04	2018	grade_6	0.0		0.0	0.0			0.0	0.0	0.0	0.0	0		0	0			0	0	0	0
258756	SD	school	4666930	40002	Spearfish 40-2	466693000392	3	West Elementary	Regular School	No	Elementary	01	02	2018	grade_6	0.0	0.0	0.0	0.0	0.0		0.0	0.0	0.0	0.0	0	0	0	0	0		0	0	0	0
259501	SD	school	4675420	11004	Wagner Community 11-4	467542000694	2	Wagner Elementary School	Regular School	No	Elementary	01	04	2018	grade_6	0.0		0.0	0.0			0.0	0.0	0.0	0.0	0		0	0			0	0	0	0
357668	SD	school	4605610	9001	Belle Fourche 09-1	460561000269	3	South Park Elementary	Regular School	No	Elementary	01	04	2019	grade_6	0.0		0.0	0.0			0.0	0.0	0.0	0.0	0		0	0			0	0	0	0
365983	SD	school	4666930	40002	Spearfish 40-2	466693000392	3	West Elementary	Regular School	No	Elementary	01	02	2019	grade_6	0.0	0.0	0.0	0.0	0.0		0.0	0.0	0.0	0.0	0	0	0	0	0		0	0	0	0
366728	SD	school	4675420	11004	Wagner Community 11-4	467542000694	2	Wagner Elementary School	Regular School	No	Elementary	01	04	2019	grade_6	0.0		0.0	0.0			0.0	0.0	0.0	0.0	0		0	0			0	0	0	0
449514	SD	school	4605610	9001	Belle Fourche 09-1	460561000269	3	South Park Elementary	Regular School	Not applicable	Elementary	01	04	2021	grade_6	0.0		0.0	0.0			0.0	0.0	0.0	0.0	0		0	0			0	0	0	0
457845	SD	school	4666930	40002	Spearfish 40-2	466693000392	3	West Elementary	Regular School	Not applicable	Elementary	01	02	2021	grade_6	0.0	0.0	0.0	0.0	0.0		0.0	0.0	0.0	0.0	0	0	0	0	0		0	0	0	0
487937	SD	school	4605610	9001	Belle Fourche 09-1	460561000269	3	South Park Elementary	Regular School	Not applicable	Elementary	01	04	2020	grade_6	0.0		0.0	0.0			0.0	0.0	0.0	0.0	0		0	0			0	0	0	0
496268	SD	school	4666930	40002	Spearfish 40-2	466693000392	3	West Elementary	Regular School	Not applicable	Elementary	01	02	2020	grade_6	0.0	0.0	0.0	0.0	0.0		0.0	0.0	0.0	0.0	0	0	0	0	0		0	0	0	0
2962194	SD	school	4605610	9001	Belle Fourche 09-1	460561000269	3	South Park Elementary	Regular School	No	1	01	04	2015	grade_6	0.0		0.0	0.0			0.0	0.0	0.0	0.0	0		0	0			0	0	0	0
2970509	SD	school	4666930	40002	Spearfish 40-2	466693000392	3	West Elementary	Regular School	No	1	01	02	2015	grade_6	0.0	0.0	0.0	0.0	0.0		0.0	0.0	0.0	0.0	0	0	0	0	0		0	0	0	0
2971286	SD	school	4675420	11004	Wagner Community 11-4	467542000694	2	Wagner Elementary School	Regular School	No	1	01	04	2015	grade_6	0.0		0.0	0.0			0.0	0.0	0.0	0.0	0		0	0			0	0	0	0
3006834	SD	school	4605610	9001	Belle Fourche 09-1	460561000269	3	South Park Elementary	Regular School	No	Elementary	01	04	2017	grade_6	0.0	0.0	0.0	0.0			0.0	0.0	0.0	0.0	0	0	0	0			0	0	0	0
3015172	SD	school	4666930	40002	Spearfish 40-2	466693000392	3	West Elementary	Regular School	No	Elementary	01	02	2017	grade_6	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0	0	0	0	0	0	0	0	0	0
3015894	SD	school	4675420	11004	Wagner Community 11-4	467542000694	2	Wagner Elementary School	Regular School	No	Elementary	01	04	2017	grade_6	0.0		0.0	0.0			0.0	0.0	0.0	0.0	0		0	0			0	0	0	0
3344746	SD	school	4605610	9001	Belle Fourche 09-1	460561000269	3	South Park Elementary	Regular School	No	1	01	04	2016	grade_6	0.0	0.0	0.0	0.0			0.0	0.0	0.0	0.0	0	0	0	0			0	0	0	0
3353077	SD	school	4666930	40002	Spearfish 40-2	466693000392	3	West Elementary	Regular School	No	1	01	02	2016	grade_6	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0	0	0	0	0	0	0	0	0	0
3353806	SD	school	4675420	11004	Wagner Community 11-4	467542000694	2	Wagner Elementary School	Regular School	No	1	01	04	2016	grade_6	0.0		0.0	0.0			0.0	0.0	0.0	0.0	0		0	0			0	0	0	0
254457	SD	school	4635480	2002	Huron 02-2	463548001369	19	Madison 2-3 Center	Regular School	No	Elementary	02	03	2018	grade_6	0.0	0.0	0.0	0.0	0.0		0.0	0.0	0.0	0.0	0	0	0	0	0		0	0	0	0
258154	SD	school	4666270	49005	Sioux Falls 49-5	466627001129	51	Challenge Center	Regular School	No	Elementary	02	05	2018	grade_6	0.0	0.0	0.0	0.0	0.0		0.0	0.0	0.0	0.0	0	0	0	0	0		0	0	0	0
259374	SD	school	4674370	13001	Vermillion 13-1	467437000301	4	Jolley Elementary School	Regular School	No	Elementary	02	05	2018	grade_6	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0	0	0	0	0	0	0	0	0	0
361684	SD	school	4635480	2002	Huron 02-2	463548001369	19	Madison 2-3 Center	Regular School	No	Elementary	02	03	2019	grade_6	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0	0	0	0	0	0	0	0	0	0
365421	SD	school	4666270	49005	Sioux Falls 49-5	466627001129	51	Challenge Center	Regular School	No	Elementary	02	05	2019	grade_6	0.0	0.0	0.0	0.0	0.0		0.0	0.0	0.0	0.0	0	0	0	0	0		0	0	0	0
366601	SD	school	4674370	13001	Vermillion 13-1	467437000301	4	Jolley Elementary School	Regular School	No	Elementary	02	05	2019	grade_6	0.0	0.0	0.0	0.0	0.0		0.0	0.0	0.0	0.0	0	0	0	0	0		0	0	0	0
453530	SD	school	4635480	2002	Huron 02-2	463548001369	19	Madison 2-3 Center	Regular School	Not applicable	Elementary	02	03	2021	grade_6	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0	0	0	0	0	0	0	0	0	0
457282	SD	school	4666270	49005	Sioux Falls 49-5	466627001129	51	Challenge Center	Regular School	Not applicable	Elementary	02	05	2021	grade_6	0.0	0.0	0.0	0.0	0.0		0.0	0.0	0.0	0.0	0	0	0	0	0		0	0	0	0
458479	SD	school	4674370	13001	Vermillion 13-1	467437000301	4	Jolley Elementary School	Regular School	Not applicable	Elementary	02	05	2021	grade_6	0.0	0.0	0.0	0.0	0.0		0.0	0.0	0.0	0.0	0	0	0	0	0		0	0	0	0
491953	SD	school	4635480	2002	Huron 02-2	463548001369	19	Madison 2-3 Center	Regular School	Not applicable	Elementary	02	03	2020	grade_6	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0	0	0	0	0	0	0	0	0	0
495705	SD	school	4666270	49005	Sioux Falls 49-5	466627001129	51	Challenge Center	Regular School	Not applicable	Elementary	02	05	2020	grade_6	0.0	0.0	0.0	0.0	0.0		0.0	0.0	0.0	0.0	0	0	0	0	0		0	0	0	0
496902	SD	school	4674370	13001	Vermillion 13-1	467437000301	4	Jolley Elementary School	Regular School	Not applicable	Elementary	02	05	2020	grade_6	0.0	0.0	0.0	0.0	0.0		0.0	0.0	0.0	0.0	0	0	0	0	0		0	0	0	0
2964042	SD	school	4619410	51001	Douglas 51-1	461941000439	4	Francis Case Elementary	Regular School	No	1	02	03	2015	grade_6	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0	0	0	0	0	0	0	0	0	0
2969094	SD	school	4660450	56004	Redfield 56-4	466045001102	4	George S Mickelson Alternative	Alternative Education School	No	4	02	12	2015	grade_6	1.0	0.0		0.0				1.0	0.0	1.0	1	0		0				1	0	1
2971159	SD	school	4674370	13001	Vermillion 13-1	467437000301	4	Jolley Elementary School	Regular School	No	1	02	05	2015	grade_6	0.0	0.0	0.0	0.0	0.0		0.0	0.0	0.0	0.0	0	0	0	0	0		0	0	0	0
3008746	SD	school	4619410	51001	Douglas 51-1	461941000439	4	Francis Case Elementary	Regular School	No	Elementary	02	03	2017	grade_6	0.0	0.0	0.0	0.0	0.0		0.0	0.0	0.0	0.0	0	0	0	0	0		0	0	0	0
3010914	SD	school	4635480	2002	Huron 02-2	463548001369	19	Madison 2-3 Center	Regular School	No	Elementary	02	03	2017	grade_6	0.0	0.0	0.0	0.0	0.0		0.0	0.0	0.0	0.0	0	0	0	0	0		0	0	0	0
3014585	SD	school	4666270	49005	Sioux Falls 49-5	466627001129	51	Challenge Center	Regular School	No	Elementary	02	05	2017	grade_6	0.0	0.0	0.0	0.0	0.0		0.0	0.0	0.0	0.0	0	0	0	0	0		0	0	0	0
3015767	SD	school	4674370	13001	Vermillion 13-1	467437000301	4	Jolley Elementary School	Regular School	No	Elementary	02	05	2017	grade_6	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0	0	0	0	0	0	0	0	0	0
3346658	SD	school	4619410	51001	Douglas 51-1	461941000439	4	Francis Case Elementary	Regular School	No	1	02	03	2016	grade_6	0.0	0.0	0.0	0.0	0.0		0.0	0.0	0.0	0.0	0	0	0	0	0		0	0	0	0
3353679	SD	school	4674370	13001	Vermillion 13-1	467437000301	4	Jolley Elementary School	Regular School	No	1	02	05	2016	grade_6	0.0	0.0	0.0	0.0	0.0		0.0	0.0	0.0	0.0	0	0	0	0	0		0	0	0	0
252448	SD	school	4620100	20001	Eagle Butte 20-1	462010000605	3	C-EB Upper Elementary	Regular School	No	Elementary	03	06	2018	grade_6	1.0			74.0	0.0			36.0	39.0	75.0	1			74	0			36	39	75
256176	SD	school	4680441	62006	Mobridge-Pollock 62-6	468044100493	4	Mobridge Upper Elementary	Regular School	No	Elementary	03	05	2018	grade_6	0.0	0.0	0.0	0.0	0.0			0.0	0.0	0.0	0	0	0	0	0			0	0	0
258750	SD	school	4666930	40002	Spearfish 40-2	466693000401	7	Creekside Elem	Regular School	No	Elementary	03	05	2018	grade_6	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0	0	0	0	0	0	0	0	0	0
359698	SD	school	4620100	20001	Eagle Butte 20-1	462010000605	3	C-EB Upper Elementary	Regular School	No	Elementary	03	06	2019	grade_6	0.0		0.0	59.0	0.0	0.0	0.0	23.0	36.0	59.0	0		0	59	0	0	0	23	36	59
363419	SD	school	4680441	62006	Mobridge-Pollock 62-6	468044100493	4	Mobridge Upper Elementary	Regular School	No	Elementary	03	05	2019	grade_6	0.0	0.0	0.0	0.0			0.0	0.0	0.0	0.0	0	0	0	0			0	0	0	0
365977	SD	school	4666930	40002	Spearfish 40-2	466693000401	7	Creekside Elem	Regular School	No	Elementary	03	05	2019	grade_6	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0	0	0	0	0	0	0	0	0	0
451537	SD	school	4620100	20001	Eagle Butte 20-1	462010000605	3	C-EB Upper Elementary	Regular School	Not applicable	Elementary	03	06	2021	grade_6	0.0			72.0	1.0			38.0	35.0	73.0	0			72	1			38	35	73
455281	SD	school	4680441	62006	Mobridge-Pollock 62-6	468044100493	4	Mobridge Upper Elementary	Regular School	Not applicable	Elementary	03	05	2021	grade_6	0.0	0.0	0.0	0.0	0.0		0.0	0.0	0.0	0.0	0	0	0	0	0		0	0	0	0
457839	SD	school	4666930	40002	Spearfish 40-2	466693000401	7	Creekside Elem	Regular School	Not applicable	Elementary	03	05	2021	grade_6	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0	0	0	0	0	0	0	0	0	0
489976	SD	school	4620100	20001	Eagle Butte 20-1	462010000605	3	C-EB Upper Elementary	Regular School	Not applicable	Elementary	03	06	2020	grade_6	0.0			54.0	0.0	0.0		35.0	19.0	54.0	0			54	0	0		35	19	54
493704	SD	school	4680441	62006	Mobridge-Pollock 62-6	468044100493	4	Mobridge Upper Elementary	Regular School	Not applicable	Elementary	03	05	2020	grade_6	0.0	0.0	0.0	0.0				0.0	0.0	0.0	0	0	0	0				0	0	0
496262	SD	school	4666930	40002	Spearfish 40-2	466693000401	7	Creekside Elem	Regular School	Not applicable	Elementary	03	05	2020	grade_6	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0	0	0	0	0	0	0	0	0	0
2962847	SD	school	4608520	5001	Brookings 05-1	460852001298	6	Camelot Intermediate School	Regular School	No	1	03	05	2015	grade_6	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0	0	0	0	0	0	0	0	0	0
2964178	SD	school	4620100	20001	Eagle Butte 20-1	462010000605	3	C-EB Upper Elementary	Regular School	No	1	03	06	2015	grade_6	2.0		0.0	56.0				32.0	26.0	58.0	2		0	56				32	26	58
2967865	SD	school	4680441	62006	Mobridge-Pollock 62-6	468044100493	4	Mobridge Upper Elementary	Regular School	No	1	03	05	2015	grade_6	0.0		0.0	0.0	0.0		0.0	0.0	0.0	0.0	0		0	0	0		0	0	0	0
2970505	SD	school	4666930	40002	Spearfish 40-2	466693000401	7	Creekside Elem	Regular School	No	1	03	05	2015	grade_6	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0	0	0	0	0	0	0	0	0	0
2970760	SD	school	4600052	41005	Tea Area 41-5	460005201331	4	Tea Area Intermediate	Regular School	No	1	03	05	2015	grade_6	0.0	0.0	0.0	0.0			0.0	0.0	0.0	0.0	0	0	0	0			0	0	0	0
3008873	SD	school	4620100	20001	Eagle Butte 20-1	462010000605	3	C-EB Upper Elementary	Regular School	No	Elementary	03	06	2017	grade_6	1.0		1.0	61.0				38.0	25.0	63.0	1		1	61				38	25	63
3012601	SD	school	4680441	62006	Mobridge-Pollock 62-6	468044100493	4	Mobridge Upper Elementary	Regular School	No	Elementary	03	05	2017	grade_6	0.0	0.0	0.0	0.0	0.0		0.0	0.0	0.0	0.0	0	0	0	0	0		0	0	0	0
3015168	SD	school	4666930	40002	Spearfish 40-2	466693000401	7	Creekside Elem	Regular School	No	Elementary	03	05	2017	grade_6	0.0	0.0	0.0	0.0	0.0		0.0	0.0	0.0	0.0	0	0	0	0	0		0	0	0	0
3346785	SD	school	4620100	20001	Eagle Butte 20-1	462010000605	3	C-EB Upper Elementary	Regular School	No	1	03	06	2016	grade_6	1.0		1.0	69.0				31.0	40.0	71.0	1		1	69				31	40	71
3350465	SD	school	4680441	62006	Mobridge-Pollock 62-6	468044100493	4	Mobridge Upper Elementary	Regular School	No	1	03	05	2016	grade_6	0.0		0.0	0.0	0.0		0.0	0.0	0.0	0.0	0		0	0	0		0	0	0	0
3353073	SD	school	4666930	40002	Spearfish 40-2	466693000401	7	Creekside Elem	Regular School	No	1	03	05	2016	grade_6	0.0		0.0	0.0	0.0		0.0	0.0	0.0	0.0	0		0	0	0		0	0	0	0
3353273	SD	school	4600052	41005	Tea Area 41-5	460005201331	4	Tea Area Intermediate	Regular School	No	1	03	05	2016	grade_6	0.0	0.0	0.0	0.0			0.0	0.0	0.0	0.0	0	0	0	0			0	0	0	0
251102	SD	school	4608520	5001	Brookings 05-1	460852001298	6	Camelot Intermediate School	Regular School	No	Elementary	04	05	2018	grade_6	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0	0	0	0	0	0	0	0	0	0
251920	SD	school	4636990	61008	Dakota Valley 61-8	463699001075	4	Dakota Valley Upper Elem	Regular School	No	Elementary	04	05	2018	grade_6	0.0	0.0	0.0	0.0	0.0		0.0	0.0	0.0	0.0	0	0	0	0	0		0	0	0	0
252329	SD	school	4619410	51001	Douglas 51-1	461941000436	2	Vandenberg Elementary	Regular School	No	Elementary	04	05	2018	grade_6	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0	0	0	0	0	0	0	0	0	0
254459	SD	school	4635480	2002	Huron 02-2	463548001373	20	Washington 4-5 Center	Regular School	No	Elementary	04	05	2018	grade_6	0.0	0.0	0.0	0.0	0.0		0.0	0.0	0.0	0.0	0	0	0	0	0		0	0	0	0
254688	SD	school	4636150	2003	Iroquois 02-3	463615000340	5	Pearl Creek Colony Elem	Regular School	No	Middle	04	08	2018	grade_6	3.0							2.0	1.0	3.0	3							2	1	3
256934	SD	school	4655710	1001	Plankinton 01-1	465571001276	4	Aurora Plains Academy Middle School	Alternative School	No	Middle	04	08	2018	grade_6	4.0	0.0	1.0	1.0				6.0	0.0	6.0	4	0	1	1				6	0	6
358361	SD	school	4608520	5001	Brookings 05-1	460852001298	6	Camelot Intermediate School	Regular School	No	Elementary	04	05	2019	grade_6	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0	0	0	0	0	0	0	0	0	0
359179	SD	school	4636990	61008	Dakota Valley 61-8	463699001075	4	Dakota Valley Upper Elem	Regular School	No	Elementary	04	05	2019	grade_6	0.0	0.0	0.0	0.0	0.0		0.0	0.0	0.0	0.0	0	0	0	0	0		0	0	0	0
359588	SD	school	4619410	51001	Douglas 51-1	461941000436	2	Vandenberg Elementary	Regular School	No	Elementary	04	05	2019	grade_6	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0	0	0	0	0	0	0	0	0	0
361686	SD	school	4635480	2002	Huron 02-2	463548001373	20	Washington 4-5 Center	Regular School	No	Elementary	04	05	2019	grade_6	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0	0	0	0	0	0	0	0	0	0
361915	SD	school	4636150	2003	Iroquois 02-3	463615000340	5	Pearl Creek Colony Elem	Regular School	No	Middle	04	08	2019	grade_6	2.0							1.0	1.0	2.0	2							1	1	2
364209	SD	school	4655710	1001	Plankinton 01-1	465571001276	4	Aurora Plains Academy Middle School	Alternative School	No	Middle	04	08	2019	grade_6	0.0	0.0	0.0	3.0			0.0	4.0	0.0	4.0	0	0	0	3			0	4	0	4
365979	SD	school	4666930	40002	Spearfish 40-2	466693001346	9	Spearfish Academy at Canyon Hills Elemen	Alternative School	No	Middle	04	08	2019	grade_6	0.0		1.0	3.0			0.0	4.0	0.0	4.0	0		1	3			0	4	0	4
450207	SD	school	4608520	5001	Brookings 05-1	460852001298	6	Camelot Intermediate School	Regular School	Not applicable	Elementary	04	05	2021	grade_6	0.0	0.0	0.0	0.0	0.0		0.0	0.0	0.0	0.0	0	0	0	0	0		0	0	0	0
451025	SD	school	4636990	61008	Dakota Valley 61-8	463699001075	4	Dakota Valley Upper Elem	Regular School	Not applicable	Elementary	04	05	2021	grade_6	0.0	0.0	0.0		0.0	0.0	0.0	0.0	0.0	0.0	0	0	0		0	0	0	0	0	0
451425	SD	school	4619410	51001	Douglas 51-1	461941000436	2	Vandenberg Elementary	Regular School	Not applicable	Elementary	04	05	2021	grade_6	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0	0	0	0	0	0	0	0	0	0
453532	SD	school	4635480	2002	Huron 02-2	463548001373	20	Washington 4-5 Center	Regular School	Not applicable	Elementary	04	05	2021	grade_6	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0	0	0	0	0	0	0	0	0	0
453761	SD	school	4636150	2003	Iroquois 02-3	463615000340	5	Pearl Creek Colony Elem	Regular School	Not applicable	Middle	04	08	2021	grade_6	3.0							1.0	2.0	3.0	3							1	2	3
456087	SD	school	4655710	1001	Plankinton 01-1	465571001276	4	Aurora Plains Academy Middle School	Alternative School	Not applicable	Middle	04	08	2021	grade_6	0.0	0.0		0.0			0.0	0.0	0.0	0.0	0	0		0			0	0	0	0
457841	SD	school	4666930	40002	Spearfish 40-2	466693001346	9	Spearfish Academy at Canyon Hills Elementary	Alternative School	Not applicable	Middle	04	08	2021	grade_6	0.0		0.0	0.0		0.0		0.0	0.0	0.0	0		0	0		0		0	0	0
488630	SD	school	4608520	5001	Brookings 05-1	460852001298	6	Camelot Intermediate School	Regular School	Not applicable	Elementary	04	05	2020	grade_6	0.0	0.0	0.0	0.0	0.0		0.0	0.0	0.0	0.0	0	0	0	0	0		0	0	0	0
489448	SD	school	4636990	61008	Dakota Valley 61-8	463699001075	4	Dakota Valley Upper Elem	Regular School	Not applicable	Elementary	04	05	2020	grade_6	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0	0	0	0	0	0	0	0	0	0
489857	SD	school	4619410	51001	Douglas 51-1	461941000436	2	Vandenberg Elementary	Regular School	Not applicable	Elementary	04	05	2020	grade_6	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0	0	0	0	0	0	0	0	0	0
491955	SD	school	4635480	2002	Huron 02-2	463548001373	20	Washington 4-5 Center	Regular School	Not applicable	Elementary	04	05	2020	grade_6	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0	0	0	0	0	0	0	0	0	0
492184	SD	school	4636150	2003	Iroquois 02-3	463615000340	5	Pearl Creek Colony Elem	Regular School	Not applicable	Middle	04	08	2020	grade_6	1.0							1.0	0.0	1.0	1							1	0	1
494494	SD	school	4655710	1001	Plankinton 01-1	465571001276	4	Aurora Plains Academy Middle School	Alternative School	Not applicable	Middle	04	08	2020	grade_6	0.0	0.0	0.0	2.0				2.0	0.0	2.0	0	0	0	2				2	0	2
496264	SD	school	4666930	40002	Spearfish 40-2	466693001346	9	Spearfish Academy at Canyon Hills Elemen	Alternative School	Not applicable	Middle	04	08	2020	grade_6	1.0			0.0			0.0	0.0	1.0	1.0	1			0			0	0	1	1
2964043	SD	school	4619410	51001	Douglas 51-1	461941000436	2	Vandenberg Elementary	Regular School	No	2	04	05	2015	grade_6	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0	0	0	0	0	0	0	0	0	0
2966425	SD	school	4636150	2003	Iroquois 02-3	463615000340	5	Pearl Creek Colony Elem	Regular School	No	2	04	08	2015	grade_6	2.0							1.0	1.0	2.0	2							1	1	2
3007511	SD	school	4608520	5001	Brookings 05-1	460852001298	6	Camelot Intermediate School	Regular School	No	Elementary	04	05	2017	grade_6	0.0	0.0	0.0	0.0	0.0		0.0	0.0	0.0	0.0	0	0	0	0	0		0	0	0	0
3008329	SD	school	4636990	61008	Dakota Valley 61-8	463699001075	4	Dakota Valley Upper Elem	Regular School	No	Elementary	04	05	2017	grade_6	0.0	0.0	0.0	0.0	0.0		0.0	0.0	0.0	0.0	0	0	0	0	0		0	0	0	0
3008747	SD	school	4619410	51001	Douglas 51-1	461941000436	2	Vandenberg Elementary	Regular School	No	Elementary	04	05	2017	grade_6	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0	0	0	0	0	0	0	0	0	0
3010916	SD	school	4635480	2002	Huron 02-2	463548001373	20	Washington 4-5 Center	Regular School	No	Elementary	04	05	2017	grade_6	0.0	0.0	0.0	0.0	0.0		0.0	0.0	0.0	0.0	0	0	0	0	0		0	0	0	0
3011145	SD	school	4636150	2003	Iroquois 02-3	463615000340	5	Pearl Creek Colony Elem	Regular School	No	Elementary	04	08	2017	grade_6	1.0							1.0	0.0	1.0	1							1	0	1
3013375	SD	school	4655710	1001	Plankinton 01-1	465571001276	4	Aurora Plains Academy Middle School	Alternative School	No	Elementary	04	08	2017	grade_6	2.0	0.0	0.0	1.0				3.0	0.0	3.0	2	0	0	1				3	0	3
3345455	SD	school	4608520	5001	Brookings 05-1	460852001298	6	Camelot Intermediate School	Regular School	No	2	04	05	2016	grade_6	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0	0	0	0	0	0	0	0	0	0
3346659	SD	school	4619410	51001	Douglas 51-1	461941000436	2	Vandenberg Elementary	Regular School	No	2	04	05	2016	grade_6	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0	0	0	0	0	0	0	0	0	0