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_high_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
254439	SD	school	4635480	2002	Huron 02-2	463548001370	18	Buchanan K-1 Center	Regular School	No	Elementary	KG	01	2018	grade_4	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0	0	0	0	0	0	0	0	0	0
259365	SD	school	4674370	13001	Vermillion 13-1	467437000300	3	Austin Elementary School	Regular School	No	Elementary	PK	01	2018	grade_4	0.0	0.0	0.0	0.0	0.0		0.0	0.0	0.0	0.0	0	0	0	0	0		0	0	0	0
361666	SD	school	4635480	2002	Huron 02-2	463548001370	18	Buchanan K-1 Center	Regular School	No	Elementary	KG	01	2019	grade_4	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0	0	0	0	0	0	0	0	0	0
366592	SD	school	4674370	13001	Vermillion 13-1	467437000300	3	Austin Elementary School	Regular School	No	Elementary	PK	01	2019	grade_4	0.0	0.0	0.0	0.0	0.0		0.0	0.0	0.0	0.0	0	0	0	0	0		0	0	0	0
453512	SD	school	4635480	2002	Huron 02-2	463548001370	18	Buchanan K-1 Center	Regular School	Not applicable	Elementary	KG	01	2021	grade_4	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0	0	0	0	0	0	0	0	0	0
458470	SD	school	4674370	13001	Vermillion 13-1	467437000300	3	Austin Elementary School	Regular School	Not applicable	Elementary	PK	01	2021	grade_4	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0	0	0	0	0	0	0	0	0	0
491935	SD	school	4635480	2002	Huron 02-2	463548001370	18	Buchanan K-1 Center	Regular School	Not applicable	Elementary	KG	01	2020	grade_4	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0	0	0	0	0	0	0	0	0	0
496893	SD	school	4674370	13001	Vermillion 13-1	467437000300	3	Austin Elementary School	Regular School	Not applicable	Elementary	PK	01	2020	grade_4	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0	0	0	0	0	0	0	0	0	0
2964026	SD	school	4619410	51001	Douglas 51-1	461941000453	5	Badger Clark Elem	Regular School	No	1	KG	01	2015	grade_4	0.0	0.0	0.0	0.0	0.0		0.0	0.0	0.0	0.0	0	0	0	0	0		0	0	0	0
2971150	SD	school	4674370	13001	Vermillion 13-1	467437000300	3	Austin Elementary School	Regular School	No	1	PK	01	2015	grade_4	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0	0	0	0	0	0	0	0	0	0
3008730	SD	school	4619410	51001	Douglas 51-1	461941000453	5	Badger Clark Elem	Regular School	No	Elementary	KG	01	2017	grade_4	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0	0	0	0	0	0	0	0	0	0
3010896	SD	school	4635480	2002	Huron 02-2	463548001370	18	Buchanan K-1 Center	Regular School	No	Elementary	KG	01	2017	grade_4	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0	0	0	0	0	0	0	0	0	0
3015758	SD	school	4674370	13001	Vermillion 13-1	467437000300	3	Austin Elementary School	Regular School	No	Elementary	PK	01	2017	grade_4	0.0	0.0	0.0	0.0	0.0		0.0	0.0	0.0	0.0	0	0	0	0	0		0	0	0	0
3346642	SD	school	4619410	51001	Douglas 51-1	461941000453	5	Badger Clark Elem	Regular School	No	1	KG	01	2016	grade_4	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0	0	0	0	0	0	0	0	0	0
3353670	SD	school	4674370	13001	Vermillion 13-1	467437000300	3	Austin Elementary School	Regular School	No	1	PK	01	2016	grade_4	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0	0	0	0	0	0	0	0	0	0
252439	SD	school	4620100	20001	Eagle Butte 20-1	462010000897	2	C-EB Primary	Regular School	No	Elementary	KG	02	2018	grade_4	0.0			0.0	0.0	0.0		0.0	0.0	0.0	0			0	0	0		0	0	0
256165	SD	school	4680441	62006	Mobridge-Pollock 62-6	468044100486	3	Freeman Davis Elementary	Regular School	No	Elementary	KG	02	2018	grade_4	0.0	0.0	0.0	0.0	0.0			0.0	0.0	0.0	0	0	0	0	0			0	0	0
258740	SD	school	4666930	40002	Spearfish 40-2	466693000392	3	West Elementary	Regular School	No	Elementary	01	02	2018	grade_4	0.0	0.0	0.0	0.0	0.0		0.0	0.0	0.0	0.0	0	0	0	0	0		0	0	0	0
260021	SD	school	4631710	49007	West Central 49-7	463171000777	5	West Central Hartford Elem	Regular School	No	Elementary	KG	02	2018	grade_4	0.0	0.0	0.0	0.0			0.0	0.0	0.0	0.0	0	0	0	0			0	0	0	0
359691	SD	school	4620100	20001	Eagle Butte 20-1	462010000897	2	C-EB Primary	Regular School	No	Elementary	KG	02	2019	grade_4	0.0			0.0	0.0			0.0	0.0	0.0	0			0	0			0	0	0
363408	SD	school	4680441	62006	Mobridge-Pollock 62-6	468044100486	3	Freeman Davis Elementary	Regular School	No	Elementary	KG	02	2019	grade_4	0.0	0.0	0.0	0.0	0.0			0.0	0.0	0.0	0	0	0	0	0			0	0	0
365967	SD	school	4666930	40002	Spearfish 40-2	466693000392	3	West Elementary	Regular School	No	Elementary	01	02	2019	grade_4	0.0	0.0	0.0	0.0	0.0		0.0	0.0	0.0	0.0	0	0	0	0	0		0	0	0	0
367271	SD	school	4631710	49007	West Central 49-7	463171000777	5	West Central Hartford Elem	Regular School	No	Elementary	KG	02	2019	grade_4	0.0	0.0	0.0	0.0			0.0	0.0	0.0	0.0	0	0	0	0			0	0	0	0
451528	SD	school	4620100	20001	Eagle Butte 20-1	462010000897	2	C-EB Primary	Regular School	Not applicable	Elementary	KG	02	2021	grade_4	0.0		0.0	0.0				0.0	0.0	0.0	0		0	0				0	0	0
455270	SD	school	4680441	62006	Mobridge-Pollock 62-6	468044100486	3	Freeman Davis Elementary	Regular School	Not applicable	Elementary	KG	02	2021	grade_4	0.0	0.0	0.0	0.0			0.0	0.0	0.0	0.0	0	0	0	0			0	0	0	0
457829	SD	school	4666930	40002	Spearfish 40-2	466693000392	3	West Elementary	Regular School	Not applicable	Elementary	01	02	2021	grade_4	0.0	0.0	0.0	0.0	0.0		0.0	0.0	0.0	0.0	0	0	0	0	0		0	0	0	0
459181	SD	school	4631710	49007	West Central 49-7	463171000777	5	West Central Hartford Elem	Regular School	Not applicable	Elementary	KG	02	2021	grade_4	0.0		0.0	0.0			0.0	0.0	0.0	0.0	0		0	0			0	0	0	0
489967	SD	school	4620100	20001	Eagle Butte 20-1	462010000897	2	C-EB Primary	Regular School	Not applicable	Elementary	KG	02	2020	grade_4	0.0			0.0				0.0	0.0	0.0	0			0				0	0	0
493693	SD	school	4680441	62006	Mobridge-Pollock 62-6	468044100486	3	Freeman Davis Elementary	Regular School	Not applicable	Elementary	KG	02	2020	grade_4	0.0		0.0	0.0	0.0			0.0	0.0	0.0	0		0	0	0			0	0	0
496252	SD	school	4666930	40002	Spearfish 40-2	466693000392	3	West Elementary	Regular School	Not applicable	Elementary	01	02	2020	grade_4	0.0	0.0	0.0	0.0	0.0		0.0	0.0	0.0	0.0	0	0	0	0	0		0	0	0	0
497572	SD	school	4631710	49007	West Central 49-7	463171000777	5	West Central Hartford Elem	Regular School	Not applicable	Elementary	KG	02	2020	grade_4	0.0	0.0	0.0	0.0			0.0	0.0	0.0	0.0	0	0	0	0			0	0	0	0
2964167	SD	school	4620100	20001	Eagle Butte 20-1	462010000897	2	C-EB Primary	Regular School	No	1	KG	02	2015	grade_4	0.0		0.0	0.0				0.0	0.0	0.0	0		0	0				0	0	0
2967854	SD	school	4680441	62006	Mobridge-Pollock 62-6	468044100486	3	Freeman Davis Elementary	Regular School	No	1	PK	02	2015	grade_4	0.0		0.0	0.0	0.0	0.0		0.0	0.0	0.0	0		0	0	0	0		0	0	0
2970493	SD	school	4666930	40002	Spearfish 40-2	466693000392	3	West Elementary	Regular School	No	1	01	02	2015	grade_4	0.0	0.0	0.0	0.0	0.0		0.0	0.0	0.0	0.0	0	0	0	0	0		0	0	0	0
2970750	SD	school	4600052	41005	Tea Area 41-5	460005200388	1	Tea Area Elementary School	Regular School	No	1	KG	02	2015	grade_4	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0	0	0	0	0	0	0	0	0	0
2971790	SD	school	4631710	49007	West Central 49-7	463171000777	5	West Central Hartford Elem	Regular School	No	1	KG	02	2015	grade_4	0.0	0.0	0.0	0.0			0.0	0.0	0.0	0.0	0	0	0	0			0	0	0	0
3008864	SD	school	4620100	20001	Eagle Butte 20-1	462010000897	2	C-EB Primary	Regular School	No	Elementary	KG	02	2017	grade_4	0.0			0.0	0.0			0.0	0.0	0.0	0			0	0			0	0	0
3012590	SD	school	4680441	62006	Mobridge-Pollock 62-6	468044100486	3	Freeman Davis Elementary	Regular School	No	Elementary	KG	02	2017	grade_4	0.0	0.0	0.0	0.0				0.0	0.0	0.0	0	0	0	0				0	0	0
3015158	SD	school	4666930	40002	Spearfish 40-2	466693000392	3	West Elementary	Regular School	No	Elementary	01	02	2017	grade_4	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0	0	0	0	0	0	0	0	0	0
3016414	SD	school	4631710	49007	West Central 49-7	463171000777	5	West Central Hartford Elem	Regular School	No	Elementary	KG	02	2017	grade_4	0.0		0.0	0.0			0.0	0.0	0.0	0.0	0		0	0			0	0	0	0
3346776	SD	school	4620100	20001	Eagle Butte 20-1	462010000897	2	C-EB Primary	Regular School	No	1	KG	02	2016	grade_4	0.0		0.0	0.0				0.0	0.0	0.0	0		0	0				0	0	0
3350454	SD	school	4680441	62006	Mobridge-Pollock 62-6	468044100486	3	Freeman Davis Elementary	Regular School	No	1	PK	02	2016	grade_4	0.0	0.0	0.0	0.0				0.0	0.0	0.0	0	0	0	0				0	0	0
3353061	SD	school	4666930	40002	Spearfish 40-2	466693000392	3	West Elementary	Regular School	No	1	01	02	2016	grade_4	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0	0	0	0	0	0	0	0	0	0
3353260	SD	school	4600052	41005	Tea Area 41-5	460005200388	1	Tea Area Elementary School	Regular School	No	1	PK	02	2016	grade_4	0.0	0.0	0.0	0.0			0.0	0.0	0.0	0.0	0	0	0	0			0	0	0	0
3354294	SD	school	4631710	49007	West Central 49-7	463171000777	5	West Central Hartford Elem	Regular School	No	1	KG	02	2016	grade_4	0.0	0.0	0.0	0.0			0.0	0.0	0.0	0.0	0	0	0	0			0	0	0	0
251091	SD	school	4608520	5001	Brookings 05-1	460852001356	7	Dakota Prairie Elementary	Regular School	No	Elementary	KG	03	2018	grade_4	0.0	0.0	0.0	0.0	0.0		0.0	0.0	0.0	0.0	0	0	0	0	0		0	0	0	0
251093	SD	school	4608520	5001	Brookings 05-1	460852000085	4	Hillcrest Elem	Regular School	No	Elementary	KG	03	2018	grade_4	0.0	0.0	0.0	0.0	0.0		0.0	0.0	0.0	0.0	0	0	0	0	0		0	0	0	0
251094	SD	school	4608520	5001	Brookings 05-1	460852000086	5	Medary Elem	Regular School	No	Elementary	KG	03	2018	grade_4	0.0	0.0	0.0	0.0	0.0		0.0	0.0	0.0	0.0	0	0	0	0	0		0	0	0	0
251909	SD	school	4636990	61008	Dakota Valley 61-8	463699000251	2	Dakota Valley Elementary School	Regular School	No	Elementary	KG	03	2018	grade_4	0.0	0.0	0.0	0.0	0.0		0.0	0.0	0.0	0.0	0	0	0	0	0		0	0	0	0
252318	SD	school	4619410	51001	Douglas 51-1	461941001384	6	Patriot Elementary	Regular School	No	Elementary	KG	03	2018	grade_4	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0	0	0	0	0	0	0	0	0	0
254443	SD	school	4635480	2002	Huron 02-2	463548001369	19	Madison 2-3 Center	Regular School	No	Elementary	02	03	2018	grade_4	0.0	0.0	0.0	0.0	0.0		0.0	0.0	0.0	0.0	0	0	0	0	0		0	0	0	0
358350	SD	school	4608520	5001	Brookings 05-1	460852001356	7	Dakota Prairie Elementary	Regular School	No	Elementary	KG	03	2019	grade_4	0.0	0.0	0.0	0.0	0.0		0.0	0.0	0.0	0.0	0	0	0	0	0		0	0	0	0
358352	SD	school	4608520	5001	Brookings 05-1	460852000085	4	Hillcrest Elem	Regular School	No	Elementary	KG	03	2019	grade_4	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0	0	0	0	0	0	0	0	0	0
358353	SD	school	4608520	5001	Brookings 05-1	460852000086	5	Medary Elem	Regular School	No	Elementary	KG	03	2019	grade_4	0.0	0.0	0.0	0.0	0.0		0.0	0.0	0.0	0.0	0	0	0	0	0		0	0	0	0
359168	SD	school	4636990	61008	Dakota Valley 61-8	463699000251	2	Dakota Valley Elementary School	Regular School	No	Elementary	KG	03	2019	grade_4	0.0	0.0	0.0	0.0	0.0		0.0	0.0	0.0	0.0	0	0	0	0	0		0	0	0	0
359577	SD	school	4619410	51001	Douglas 51-1	461941001384	6	Patriot Elementary	Regular School	No	Elementary	KG	03	2019	grade_4	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0	0	0	0	0	0	0	0	0	0
361670	SD	school	4635480	2002	Huron 02-2	463548001369	19	Madison 2-3 Center	Regular School	No	Elementary	02	03	2019	grade_4	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0	0	0	0	0	0	0	0	0	0
450196	SD	school	4608520	5001	Brookings 05-1	460852001356	7	Dakota Prairie Elementary	Regular School	Not applicable	Elementary	KG	03	2021	grade_4	0.0	0.0	0.0	0.0	0.0		0.0	0.0	0.0	0.0	0	0	0	0	0		0	0	0	0
450198	SD	school	4608520	5001	Brookings 05-1	460852000085	4	Hillcrest Elem	Regular School	Not applicable	Elementary	KG	03	2021	grade_4	0.0	0.0	0.0	0.0	0.0		0.0	0.0	0.0	0.0	0	0	0	0	0		0	0	0	0
450199	SD	school	4608520	5001	Brookings 05-1	460852000086	5	Medary Elem	Regular School	Not applicable	Elementary	KG	03	2021	grade_4	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0	0	0	0	0	0	0	0	0	0
451014	SD	school	4636990	61008	Dakota Valley 61-8	463699000251	2	Dakota Valley Elementary School	Regular School	Not applicable	Elementary	KG	03	2021	grade_4	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0	0	0	0	0	0	0	0	0	0
451416	SD	school	4619410	51001	Douglas 51-1	461941001384	6	Patriot Elementary	Regular School	Not applicable	Elementary	KG	03	2021	grade_4	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0	0	0	0	0	0	0	0	0	0
453516	SD	school	4635480	2002	Huron 02-2	463548001369	19	Madison 2-3 Center	Regular School	Not applicable	Elementary	02	03	2021	grade_4	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0	0	0	0	0	0	0	0	0	0
488619	SD	school	4608520	5001	Brookings 05-1	460852001356	7	Dakota Prairie Elementary	Regular School	Not applicable	Elementary	KG	03	2020	grade_4	0.0	0.0	0.0	0.0	0.0		0.0	0.0	0.0	0.0	0	0	0	0	0		0	0	0	0
488621	SD	school	4608520	5001	Brookings 05-1	460852000085	4	Hillcrest Elem	Regular School	Not applicable	Elementary	KG	03	2020	grade_4	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0	0	0	0	0	0	0	0	0	0
488622	SD	school	4608520	5001	Brookings 05-1	460852000086	5	Medary Elem	Regular School	Not applicable	Elementary	KG	03	2020	grade_4	0.0	0.0	0.0	0.0	0.0		0.0	0.0	0.0	0.0	0	0	0	0	0		0	0	0	0
489437	SD	school	4636990	61008	Dakota Valley 61-8	463699000251	2	Dakota Valley Elementary School	Regular School	Not applicable	Elementary	KG	03	2020	grade_4	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0	0	0	0	0	0	0	0	0	0
489846	SD	school	4619410	51001	Douglas 51-1	461941001384	6	Patriot Elementary	Regular School	Not applicable	Elementary	KG	03	2020	grade_4	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0	0	0	0	0	0	0	0	0	0
491939	SD	school	4635480	2002	Huron 02-2	463548001369	19	Madison 2-3 Center	Regular School	Not applicable	Elementary	02	03	2020	grade_4	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0	0	0	0	0	0	0	0	0	0
2962689	SD	school	4621420	30003	Bridgewater-Emery 30-3	462142000073	3	Emery Elementary	Regular School	No	1	KG	03	2015	grade_4	0.0		0.0					0.0	0.0	0.0	0		0					0	0	0
2962839	SD	school	4608520	5001	Brookings 05-1	460852000085	4	Hillcrest Elem	Regular School	No	1	KG	03	2015	grade_4	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0	0	0	0	0	0	0	0	0	0
2962840	SD	school	4608520	5001	Brookings 05-1	460852000086	5	Medary Elem	Regular School	No	1	KG	03	2015	grade_4	0.0	0.0	0.0	0.0	0.0		0.0	0.0	0.0	0.0	0	0	0	0	0		0	0	0	0
2964030	SD	school	4619410	51001	Douglas 51-1	461941000439	4	Francis Case Elementary	Regular School	No	1	02	03	2015	grade_4	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0	0	0	0	0	0	0	0	0	0
3007500	SD	school	4608520	5001	Brookings 05-1	460852001356	7	Dakota Prairie Elementary	Regular School	No	Elementary	KG	03	2017	grade_4	0.0	0.0	0.0	0.0	0.0		0.0	0.0	0.0	0.0	0	0	0	0	0		0	0	0	0
3007502	SD	school	4608520	5001	Brookings 05-1	460852000085	4	Hillcrest Elem	Regular School	No	Elementary	KG	03	2017	grade_4	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0	0	0	0	0	0	0	0	0	0
3007503	SD	school	4608520	5001	Brookings 05-1	460852000086	5	Medary Elem	Regular School	No	Elementary	KG	03	2017	grade_4	0.0	0.0	0.0	0.0	0.0		0.0	0.0	0.0	0.0	0	0	0	0	0		0	0	0	0
3008318	SD	school	4636990	61008	Dakota Valley 61-8	463699000251	2	Dakota Valley Elementary School	Regular School	No	Elementary	KG	03	2017	grade_4	0.0	0.0	0.0	0.0	0.0		0.0	0.0	0.0	0.0	0	0	0	0	0		0	0	0	0
3008734	SD	school	4619410	51001	Douglas 51-1	461941000439	4	Francis Case Elementary	Regular School	No	Elementary	02	03	2017	grade_4	0.0	0.0	0.0	0.0	0.0		0.0	0.0	0.0	0.0	0	0	0	0	0		0	0	0	0
3010900	SD	school	4635480	2002	Huron 02-2	463548001369	19	Madison 2-3 Center	Regular School	No	Elementary	02	03	2017	grade_4	0.0	0.0	0.0	0.0	0.0		0.0	0.0	0.0	0.0	0	0	0	0	0		0	0	0	0
3345273	SD	school	4621420	30003	Bridgewater-Emery 30-3	462142010073	3	Emery Elementary	Regular School	No	1	PK	03	2016	grade_4	0.0		0.0					0.0	0.0	0.0	0		0					0	0	0
3345444	SD	school	4608520	5001	Brookings 05-1	460852001356	7	Dakota Prairie Elementary	Regular School	No	1	KG	03	2016	grade_4	0.0	0.0	0.0	0.0	0.0		0.0	0.0	0.0	0.0	0	0	0	0	0		0	0	0	0
3345446	SD	school	4608520	5001	Brookings 05-1	460852000085	4	Hillcrest Elem	Regular School	No	1	KG	03	2016	grade_4	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0	0	0	0	0	0	0	0	0	0
3345447	SD	school	4608520	5001	Brookings 05-1	460852000086	5	Medary Elem	Regular School	No	1	KG	03	2016	grade_4	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0	0	0	0	0	0	0	0	0	0
3346646	SD	school	4619410	51001	Douglas 51-1	461941000439	4	Francis Case Elementary	Regular School	No	1	02	03	2016	grade_4	0.0	0.0	0.0	0.0	0.0		0.0	0.0	0.0	0.0	0	0	0	0	0		0	0	0	0
250415	SD	school	4605610	9001	Belle Fourche 09-1	460561000269	3	South Park Elementary	Regular School	No	Elementary	01	04	2018	grade_4	86.0		7.0	1.0			6.0	61.0	39.0	100.0	86		7	1			6	61	39	100
250839	SD	school	4607950	49002	Brandon Valley 49-2	460795000414	3	Brandon Elem	Regular School	No	Elementary	PK	04	2018	grade_4	86.0	3.0	0.0	0.0	1.0	1.0	2.0	46.0	47.0	93.0	86	3	0	0	1	1	2	46	47	93
250843	SD	school	4607950	49002	Brandon Valley 49-2	460795001302	6	Fred Assam Elementary	Regular School	No	Elementary	KG	04	2018	grade_4	67.0	10.0	4.0	1.0	4.0		4.0	50.0	40.0	90.0	67	10	4	1	4		4	50	40	90
250844	SD	school	4607950	49002	Brandon Valley 49-2	460795001237	5	Robert Bennis Elementary	Regular School	No	Elementary	KG	04	2018	grade_4	98.0	4.0	1.0	0.0	0.0		0.0	54.0	49.0	103.0	98	4	1	0	0		0	54	49	103
250845	SD	school	4607950	49002	Brandon Valley 49-2	460795000073	4	Valley Springs Elem	Regular School	No	Elementary	KG	04	2018	grade_4	17.0	0.0	1.0				1.0	11.0	8.0	19.0	17	0	1				1	11	8	19
251601	SD	school	4612940	12002	Clark 12-2	461294000132	2	Clark Elementary School	Regular School	No	Elementary	PK	04	2018	grade_4	23.0	0.0	2.0				1.0	19.0	7.0	26.0	23	0	2				1	19	7	26
252015	SD	school	4618120	49003	Dell Rapids 49-3	461812000164	2	Dell Rapids Elementary	Regular School	No	Elementary	KG	04	2018	grade_4	68.0	0.0	0.0	1.0			1.0	34.0	36.0	70.0	68	0	0	1			1	34	36	70
253983	SD	school	4632340	14002	Henry 14-2	463234000275	2	Henry Elementary	Regular School	No	Elementary	PK	04	2018	grade_4	5.0	0.0			0.0			1.0	4.0	5.0	5	0			0			1	4	5
254735	SD	school	4619580	37003	Jones County 37-3	461958000358	2	Jones County Elem	Regular School	No	Elementary	KG	04	2018	grade_4	11.0		0.0	3.0			5.0	13.0	6.0	19.0	11		0	3			5	13	6	19
254893	SD	school	4638220	7002	Kimball 07-2	463822000354	2	Kimball Elementary	Regular School	No	Elementary	PK	04	2018	grade_4	19.0		1.0	0.0			0.0	13.0	7.0	20.0	19		1	0			0	13	7	20
255195	SD	school	4641550	41004	Lennox 41-4	464155000386	2	Lennox Elementary	Regular School	No	Elementary	PK	04	2018	grade_4	65.0	0.0	1.0	1.0	0.0		2.0	35.0	34.0	69.0	65	0	1	1	0		2	35	34	69
255199	SD	school	4641550	41004	Lennox 41-4	464155000389	5	Worthing Elem	Regular School	No	Elementary	PK	04	2018	grade_4	10.0		0.0	1.0				5.0	6.0	11.0	10		0	1				5	6	11
255526	SD	school	4601026	43007	McCook Central 43-7	460102600404	2	McCook Central Elementary	Regular School	No	Elementary	PK	04	2018	grade_4	29.0	1.0	1.0				2.0	14.0	19.0	33.0	29	1	1				2	14	19	33
255734	SD	school	4669930	46001	Meade 46-1	466993000637	3	Sturgis Elementary	Regular School	No	Elementary	KG	04	2018	grade_4	117.0	2.0	6.0	4.0	1.0		5.0	72.0	63.0	135.0	117	2	6	4	1		5	72	63	135
258933	SD	school	4600052	41005	Tea Area 41-5	460005201358	5	Tea Area Frontier Elementary	Regular School	No	Elementary	KG	04	2018	grade_4	11.0	2.0	1.0	1.0	1.0		0.0	10.0	6.0	16.0	11	2	1	1	1		0	10	6	16
258935	SD	school	4600052	41005	Tea Area 41-5	460005200388	1	Tea Area Legacy Elementary	Regular School	No	Elementary	KG	04	2018	grade_4	113.0	3.0	2.0	1.0	1.0		6.0	59.0	67.0	126.0	113	3	2	1	1		6	59	67	126
259430	SD	school	4674520	60006	Viborg-Hurley 60-6	467452000692	2	Viborg-Hurley Elementary	Regular School	No	Elementary	PK	04	2018	grade_4	25.0	0.0	2.0	0.0		0.0	0.0	16.0	11.0	27.0	25	0	2	0		0	0	16	11	27