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
250430	SD	school	4605610	9001	Belle Fourche 09-1	460561000269	3	South Park Elementary	Regular School	No	Elementary	01	04	2018	grade_7	0.0		0.0	0.0			0.0	0.0	0.0	0.0	0		0	0			0	0	0	0
258764	SD	school	4666930	40002	Spearfish 40-2	466693000392	3	West Elementary	Regular School	No	Elementary	01	02	2018	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	0	0	0
259505	SD	school	4675420	11004	Wagner Community 11-4	467542000694	2	Wagner Elementary School	Regular School	No	Elementary	01	04	2018	grade_7	0.0		0.0	0.0			0.0	0.0	0.0	0.0	0		0	0			0	0	0	0
357673	SD	school	4605610	9001	Belle Fourche 09-1	460561000269	3	South Park Elementary	Regular School	No	Elementary	01	04	2019	grade_7	0.0		0.0	0.0			0.0	0.0	0.0	0.0	0		0	0			0	0	0	0
365991	SD	school	4666930	40002	Spearfish 40-2	466693000392	3	West Elementary	Regular School	No	Elementary	01	02	2019	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	0	0	0
366732	SD	school	4675420	11004	Wagner Community 11-4	467542000694	2	Wagner Elementary School	Regular School	No	Elementary	01	04	2019	grade_7	0.0		0.0	0.0			0.0	0.0	0.0	0.0	0		0	0			0	0	0	0
449519	SD	school	4605610	9001	Belle Fourche 09-1	460561000269	3	South Park Elementary	Regular School	Not applicable	Elementary	01	04	2021	grade_7	0.0		0.0	0.0			0.0	0.0	0.0	0.0	0		0	0			0	0	0	0
457853	SD	school	4666930	40002	Spearfish 40-2	466693000392	3	West Elementary	Regular School	Not applicable	Elementary	01	02	2021	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	0	0	0
487942	SD	school	4605610	9001	Belle Fourche 09-1	460561000269	3	South Park Elementary	Regular School	Not applicable	Elementary	01	04	2020	grade_7	0.0		0.0	0.0			0.0	0.0	0.0	0.0	0		0	0			0	0	0	0
496276	SD	school	4666930	40002	Spearfish 40-2	466693000392	3	West Elementary	Regular School	Not applicable	Elementary	01	02	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	0	0	0
2962199	SD	school	4605610	9001	Belle Fourche 09-1	460561000269	3	South Park Elementary	Regular School	No	1	01	04	2015	grade_7	0.0		0.0	0.0			0.0	0.0	0.0	0.0	0		0	0			0	0	0	0
2970517	SD	school	4666930	40002	Spearfish 40-2	466693000392	3	West Elementary	Regular School	No	1	01	02	2015	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	0	0	0
2971290	SD	school	4675420	11004	Wagner Community 11-4	467542000694	2	Wagner Elementary School	Regular School	No	1	01	04	2015	grade_7	0.0		0.0	0.0			0.0	0.0	0.0	0.0	0		0	0			0	0	0	0
3006839	SD	school	4605610	9001	Belle Fourche 09-1	460561000269	3	South Park Elementary	Regular School	No	Elementary	01	04	2017	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
3015179	SD	school	4666930	40002	Spearfish 40-2	466693000392	3	West Elementary	Regular School	No	Elementary	01	02	2017	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	0	0	0	0	0	0
3015898	SD	school	4675420	11004	Wagner Community 11-4	467542000694	2	Wagner Elementary School	Regular School	No	Elementary	01	04	2017	grade_7	0.0		0.0	0.0			0.0	0.0	0.0	0.0	0		0	0			0	0	0	0
3344751	SD	school	4605610	9001	Belle Fourche 09-1	460561000269	3	South Park Elementary	Regular School	No	1	01	04	2016	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
3353085	SD	school	4666930	40002	Spearfish 40-2	466693000392	3	West Elementary	Regular School	No	1	01	02	2016	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	0	0	0	0	0	0
3353810	SD	school	4675420	11004	Wagner Community 11-4	467542000694	2	Wagner Elementary School	Regular School	No	1	01	04	2016	grade_7	0.0		0.0	0.0			0.0	0.0	0.0	0.0	0		0	0			0	0	0	0
254464	SD	school	4635480	2002	Huron 02-2	463548001369	19	Madison 2-3 Center	Regular School	No	Elementary	02	03	2018	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	0	0	0
258197	SD	school	4666270	49005	Sioux Falls 49-5	466627001129	51	Challenge Center	Regular School	No	Elementary	02	05	2018	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	0	0	0
259378	SD	school	4674370	13001	Vermillion 13-1	467437000301	4	Jolley Elementary School	Regular School	No	Elementary	02	05	2018	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	0	0	0	0	0	0
361691	SD	school	4635480	2002	Huron 02-2	463548001369	19	Madison 2-3 Center	Regular School	No	Elementary	02	03	2019	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	0	0	0	0	0	0
365463	SD	school	4666270	49005	Sioux Falls 49-5	466627001129	51	Challenge Center	Regular School	No	Elementary	02	05	2019	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	0	0	0
366605	SD	school	4674370	13001	Vermillion 13-1	467437000301	4	Jolley Elementary School	Regular School	No	Elementary	02	05	2019	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	0	0	0
453537	SD	school	4635480	2002	Huron 02-2	463548001369	19	Madison 2-3 Center	Regular School	Not applicable	Elementary	02	03	2021	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	0	0	0	0	0	0
457324	SD	school	4666270	49005	Sioux Falls 49-5	466627001129	51	Challenge Center	Regular School	Not applicable	Elementary	02	05	2021	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	0	0	0
458483	SD	school	4674370	13001	Vermillion 13-1	467437000301	4	Jolley Elementary School	Regular School	Not applicable	Elementary	02	05	2021	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	0	0	0
491960	SD	school	4635480	2002	Huron 02-2	463548001369	19	Madison 2-3 Center	Regular School	Not applicable	Elementary	02	03	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	0	0	0	0	0	0
495747	SD	school	4666270	49005	Sioux Falls 49-5	466627001129	51	Challenge Center	Regular School	Not applicable	Elementary	02	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	0	0	0
496906	SD	school	4674370	13001	Vermillion 13-1	467437000301	4	Jolley Elementary School	Regular School	Not applicable	Elementary	02	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	0	0	0
2964048	SD	school	4619410	51001	Douglas 51-1	461941000439	4	Francis Case Elementary	Regular School	No	1	02	03	2015	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	0	0	0	0	0	0
2969098	SD	school	4660450	56004	Redfield 56-4	466045001102	4	George S Mickelson Alternative	Alternative Education School	No	4	02	12	2015	grade_7	1.0	0.0		0.0				1.0	0.0	1.0	1	0		0				1	0	1
2971163	SD	school	4674370	13001	Vermillion 13-1	467437000301	4	Jolley Elementary School	Regular School	No	1	02	05	2015	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	0	0	0
3008752	SD	school	4619410	51001	Douglas 51-1	461941000439	4	Francis Case Elementary	Regular School	No	Elementary	02	03	2017	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	0	0	0
3010921	SD	school	4635480	2002	Huron 02-2	463548001369	19	Madison 2-3 Center	Regular School	No	Elementary	02	03	2017	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	0	0	0
3014627	SD	school	4666270	49005	Sioux Falls 49-5	466627001129	51	Challenge Center	Regular School	No	Elementary	02	05	2017	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	0	0	0
3015771	SD	school	4674370	13001	Vermillion 13-1	467437000301	4	Jolley Elementary School	Regular School	No	Elementary	02	05	2017	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	0	0	0	0	0	0
3346664	SD	school	4619410	51001	Douglas 51-1	461941000439	4	Francis Case Elementary	Regular School	No	1	02	03	2016	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	0	0	0
3353683	SD	school	4674370	13001	Vermillion 13-1	467437000301	4	Jolley Elementary School	Regular School	No	1	02	05	2016	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	0	0	0
252452	SD	school	4620100	20001	Eagle Butte 20-1	462010000605	3	C-EB Upper Elementary	Regular School	No	Elementary	03	06	2018	grade_7	0.0			0.0	0.0			0.0	0.0	0.0	0			0	0			0	0	0
256180	SD	school	4680441	62006	Mobridge-Pollock 62-6	468044100493	4	Mobridge Upper Elementary	Regular School	No	Elementary	03	05	2018	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
258758	SD	school	4666930	40002	Spearfish 40-2	466693000401	7	Creekside Elem	Regular School	No	Elementary	03	05	2018	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	0	0	0	0	0	0
359701	SD	school	4620100	20001	Eagle Butte 20-1	462010000605	3	C-EB Upper Elementary	Regular School	No	Elementary	03	06	2019	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	0	0	0
363423	SD	school	4680441	62006	Mobridge-Pollock 62-6	468044100493	4	Mobridge Upper Elementary	Regular School	No	Elementary	03	05	2019	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
365985	SD	school	4666930	40002	Spearfish 40-2	466693000401	7	Creekside Elem	Regular School	No	Elementary	03	05	2019	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	0	0	0	0	0	0
451541	SD	school	4620100	20001	Eagle Butte 20-1	462010000605	3	C-EB Upper Elementary	Regular School	Not applicable	Elementary	03	06	2021	grade_7	0.0			0.0	0.0			0.0	0.0	0.0	0			0	0			0	0	0
455285	SD	school	4680441	62006	Mobridge-Pollock 62-6	468044100493	4	Mobridge Upper Elementary	Regular School	Not applicable	Elementary	03	05	2021	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	0	0	0
457847	SD	school	4666930	40002	Spearfish 40-2	466693000401	7	Creekside Elem	Regular School	Not applicable	Elementary	03	05	2021	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	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
493708	SD	school	4680441	62006	Mobridge-Pollock 62-6	468044100493	4	Mobridge Upper Elementary	Regular School	Not applicable	Elementary	03	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
496270	SD	school	4666930	40002	Spearfish 40-2	466693000401	7	Creekside Elem	Regular School	Not applicable	Elementary	03	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	0	0	0	0	0	0
2962852	SD	school	4608520	5001	Brookings 05-1	460852001298	6	Camelot Intermediate School	Regular School	No	1	03	05	2015	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	0	0	0	0	0	0
2964183	SD	school	4620100	20001	Eagle Butte 20-1	462010000605	3	C-EB Upper Elementary	Regular School	No	1	03	06	2015	grade_7	0.0		0.0	0.0				0.0	0.0	0.0	0		0	0				0	0	0
2967869	SD	school	4680441	62006	Mobridge-Pollock 62-6	468044100493	4	Mobridge Upper Elementary	Regular School	No	1	03	05	2015	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
2970513	SD	school	4666930	40002	Spearfish 40-2	466693000401	7	Creekside Elem	Regular School	No	1	03	05	2015	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	0	0	0	0	0	0
2970764	SD	school	4600052	41005	Tea Area 41-5	460005201331	4	Tea Area Intermediate	Regular School	No	1	03	05	2015	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
3008877	SD	school	4620100	20001	Eagle Butte 20-1	462010000605	3	C-EB Upper Elementary	Regular School	No	Elementary	03	06	2017	grade_7	0.0		0.0	0.0				0.0	0.0	0.0	0		0	0				0	0	0
3012605	SD	school	4680441	62006	Mobridge-Pollock 62-6	468044100493	4	Mobridge Upper Elementary	Regular School	No	Elementary	03	05	2017	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	0	0	0
3015175	SD	school	4666930	40002	Spearfish 40-2	466693000401	7	Creekside Elem	Regular School	No	Elementary	03	05	2017	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	0	0	0
3346789	SD	school	4620100	20001	Eagle Butte 20-1	462010000605	3	C-EB Upper Elementary	Regular School	No	1	03	06	2016	grade_7	0.0		0.0	0.0				0.0	0.0	0.0	0		0	0				0	0	0
3350469	SD	school	4680441	62006	Mobridge-Pollock 62-6	468044100493	4	Mobridge Upper Elementary	Regular School	No	1	03	05	2016	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
3353081	SD	school	4666930	40002	Spearfish 40-2	466693000401	7	Creekside Elem	Regular School	No	1	03	05	2016	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
3353278	SD	school	4600052	41005	Tea Area 41-5	460005201331	4	Tea Area Intermediate	Regular School	No	1	03	05	2016	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
251108	SD	school	4608520	5001	Brookings 05-1	460852001298	6	Camelot Intermediate School	Regular School	No	Elementary	04	05	2018	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	0	0	0	0	0	0
251924	SD	school	4636990	61008	Dakota Valley 61-8	463699001075	4	Dakota Valley Upper Elem	Regular School	No	Elementary	04	05	2018	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	0	0	0
252334	SD	school	4619410	51001	Douglas 51-1	461941000436	2	Vandenberg Elementary	Regular School	No	Elementary	04	05	2018	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	0	0	0	0	0	0
254466	SD	school	4635480	2002	Huron 02-2	463548001373	20	Washington 4-5 Center	Regular School	No	Elementary	04	05	2018	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	0	0	0
254692	SD	school	4636150	2003	Iroquois 02-3	463615000340	5	Pearl Creek Colony Elem	Regular School	No	Middle	04	08	2018	grade_7	1.0							1.0	0.0	1.0	1							1	0	1
256939	SD	school	4655710	1001	Plankinton 01-1	465571001276	4	Aurora Plains Academy Middle School	Alternative School	No	Middle	04	08	2018	grade_7	3.0	2.0	0.0	1.0				6.0	0.0	6.0	3	2	0	1				6	0	6
358367	SD	school	4608520	5001	Brookings 05-1	460852001298	6	Camelot Intermediate School	Regular School	No	Elementary	04	05	2019	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	0	0	0	0	0	0
359183	SD	school	4636990	61008	Dakota Valley 61-8	463699001075	4	Dakota Valley Upper Elem	Regular School	No	Elementary	04	05	2019	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	0	0	0
359593	SD	school	4619410	51001	Douglas 51-1	461941000436	2	Vandenberg Elementary	Regular School	No	Elementary	04	05	2019	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	0	0	0	0	0	0
361693	SD	school	4635480	2002	Huron 02-2	463548001373	20	Washington 4-5 Center	Regular School	No	Elementary	04	05	2019	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	0	0	0	0	0	0
361919	SD	school	4636150	2003	Iroquois 02-3	463615000340	5	Pearl Creek Colony Elem	Regular School	No	Middle	04	08	2019	grade_7	3.0							2.0	1.0	3.0	3							2	1	3
364214	SD	school	4655710	1001	Plankinton 01-1	465571001276	4	Aurora Plains Academy Middle School	Alternative School	No	Middle	04	08	2019	grade_7	4.0	1.0	1.0	2.0			0.0	7.0	1.0	8.0	4	1	1	2			0	7	1	8
365987	SD	school	4666930	40002	Spearfish 40-2	466693001346	9	Spearfish Academy at Canyon Hills Elemen	Alternative School	No	Middle	04	08	2019	grade_7	1.0		0.0	0.0			1.0	2.0	0.0	2.0	1		0	0			1	2	0	2
450213	SD	school	4608520	5001	Brookings 05-1	460852001298	6	Camelot Intermediate School	Regular School	Not applicable	Elementary	04	05	2021	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	0	0	0
451029	SD	school	4636990	61008	Dakota Valley 61-8	463699001075	4	Dakota Valley Upper Elem	Regular School	Not applicable	Elementary	04	05	2021	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	0	0	0
451429	SD	school	4619410	51001	Douglas 51-1	461941000436	2	Vandenberg Elementary	Regular School	Not applicable	Elementary	04	05	2021	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	0	0	0	0	0	0
453539	SD	school	4635480	2002	Huron 02-2	463548001373	20	Washington 4-5 Center	Regular School	Not applicable	Elementary	04	05	2021	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	0	0	0	0	0	0
453765	SD	school	4636150	2003	Iroquois 02-3	463615000340	5	Pearl Creek Colony Elem	Regular School	Not applicable	Middle	04	08	2021	grade_7	1.0							1.0	0.0	1.0	1							1	0	1
456092	SD	school	4655710	1001	Plankinton 01-1	465571001276	4	Aurora Plains Academy Middle School	Alternative School	Not applicable	Middle	04	08	2021	grade_7	0.0	0.0		2.0			0.0	0.0	2.0	2.0	0	0		2			0	0	2	2
457849	SD	school	4666930	40002	Spearfish 40-2	466693001346	9	Spearfish Academy at Canyon Hills Elementary	Alternative School	Not applicable	Middle	04	08	2021	grade_7	0.0		0.0	1.0		0.0		0.0	1.0	1.0	0		0	1		0		0	1	1
488636	SD	school	4608520	5001	Brookings 05-1	460852001298	6	Camelot Intermediate School	Regular School	Not applicable	Elementary	04	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	0	0	0
489452	SD	school	4636990	61008	Dakota Valley 61-8	463699001075	4	Dakota Valley Upper Elem	Regular School	Not applicable	Elementary	04	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	0	0	0	0	0	0
489862	SD	school	4619410	51001	Douglas 51-1	461941000436	2	Vandenberg Elementary	Regular School	Not applicable	Elementary	04	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	0	0	0	0	0	0
491962	SD	school	4635480	2002	Huron 02-2	463548001373	20	Washington 4-5 Center	Regular School	Not applicable	Elementary	04	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	0	0	0	0	0	0
492188	SD	school	4636150	2003	Iroquois 02-3	463615000340	5	Pearl Creek Colony Elem	Regular School	Not applicable	Middle	04	08	2020	grade_7	2.0							1.0	1.0	2.0	2							1	1	2
494499	SD	school	4655710	1001	Plankinton 01-1	465571001276	4	Aurora Plains Academy Middle School	Alternative School	Not applicable	Middle	04	08	2020	grade_7	2.0	1.0	0.0	6.0				7.0	2.0	9.0	2	1	0	6				7	2	9
496272	SD	school	4666930	40002	Spearfish 40-2	466693001346	9	Spearfish Academy at Canyon Hills Elemen	Alternative School	Not applicable	Middle	04	08	2020	grade_7	5.0			1.0			0.0	4.0	2.0	6.0	5			1			0	4	2	6
2964049	SD	school	4619410	51001	Douglas 51-1	461941000436	2	Vandenberg Elementary	Regular School	No	2	04	05	2015	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	0	0	0	0	0	0
2966429	SD	school	4636150	2003	Iroquois 02-3	463615000340	5	Pearl Creek Colony Elem	Regular School	No	2	04	08	2015	grade_7	1.0							1.0	0.0	1.0	1							1	0	1
3007517	SD	school	4608520	5001	Brookings 05-1	460852001298	6	Camelot Intermediate School	Regular School	No	Elementary	04	05	2017	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	0	0	0
3008333	SD	school	4636990	61008	Dakota Valley 61-8	463699001075	4	Dakota Valley Upper Elem	Regular School	No	Elementary	04	05	2017	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	0	0	0
3008753	SD	school	4619410	51001	Douglas 51-1	461941000436	2	Vandenberg Elementary	Regular School	No	Elementary	04	05	2017	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	0	0	0	0	0	0
3010923	SD	school	4635480	2002	Huron 02-2	463548001373	20	Washington 4-5 Center	Regular School	No	Elementary	04	05	2017	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	0	0	0
3011149	SD	school	4636150	2003	Iroquois 02-3	463615000340	5	Pearl Creek Colony Elem	Regular School	No	Elementary	04	08	2017	grade_7	2.0							1.0	1.0	2.0	2							1	1	2
3013380	SD	school	4655710	1001	Plankinton 01-1	465571001276	4	Aurora Plains Academy Middle School	Alternative School	No	Elementary	04	08	2017	grade_7	7.0	1.0	0.0	2.0				7.0	3.0	10.0	7	1	0	2				7	3	10
3345461	SD	school	4608520	5001	Brookings 05-1	460852001298	6	Camelot Intermediate School	Regular School	No	2	04	05	2016	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	0	0	0	0	0	0
3346665	SD	school	4619410	51001	Douglas 51-1	461941000436	2	Vandenberg Elementary	Regular School	No	2	04	05	2016	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	0	0	0	0	0	0