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 (district_nces_id > :p3 or (district_nces_id = :p3 and rowid > :p2)) order by district_nces_id, rowid 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
3012369	SD	school	4600002	25004	Milbank 25-4	460000200423	3	Koch Elementary	Regular School	No	Elementary	KG	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
3012370	SD	school	4600002	25004	Milbank 25-4	460000200424	1	Milbank High School	Regular School	No	High	09	12	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
3012371	SD	school	4600002	25004	Milbank 25-4	460000200425	2	Milbank Middle School	Regular School	No	Middle	06	08	2017	grade_7	66.0		2.0				1.0	38.0	31.0	69.0	66		2				1	38	31	69
3350233	SD	school	4600002	25004	Milbank 25-4	460000200423	3	Koch Elementary	Regular School	No	1	KG	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
3350234	SD	school	4600002	25004	Milbank 25-4	460000200424	1	Milbank High School	Regular School	No	3	09	12	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
3350235	SD	school	4600002	25004	Milbank 25-4	460000200425	2	Milbank Middle School	Regular School	No	2	06	08	2016	grade_7	77.0		4.0	1.0	0.0		1.0	40.0	43.0	83.0	77		4	1	0		1	40	43	83
260296	SD	school	4600003	54007	Wilmot 54-7	460000300757	2	Wilmot Elem	Regular School	No	Elementary	PK	06	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
260297	SD	school	4600003	54007	Wilmot 54-7	460000300758	1	Wilmot Hi Sch	Regular School	No	High	09	12	2018	grade_7	0.0		0.0	0.0			0.0	0.0	0.0	0.0	0		0	0			0	0	0	0
260298	SD	school	4600003	54007	Wilmot 54-7	460000300872	3	Wilmot Jr. High	Regular School	No	Middle	07	08	2018	grade_7	11.0			6.0				8.0	9.0	17.0	11			6				8	9	17
367555	SD	school	4600003	54007	Wilmot 54-7	460000300757	2	Wilmot Elem	Regular School	No	Elementary	PK	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
367556	SD	school	4600003	54007	Wilmot 54-7	460000300758	1	Wilmot Hi Sch	Regular School	No	High	09	12	2019	grade_7	0.0		0.0	0.0			0.0	0.0	0.0	0.0	0		0	0			0	0	0	0
367557	SD	school	4600003	54007	Wilmot 54-7	460000300872	3	Wilmot Jr. High	Regular School	No	Middle	07	08	2019	grade_7	8.0		2.0	7.0				12.0	5.0	17.0	8		2	7				12	5	17
459465	SD	school	4600003	54007	Wilmot 54-7	460000300757	2	Wilmot Elem	Regular School	Not applicable	Elementary	PK	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
459466	SD	school	4600003	54007	Wilmot 54-7	460000300758	1	Wilmot Hi Sch	Regular School	Not applicable	High	09	12	2021	grade_7	0.0		0.0	0.0			0.0	0.0	0.0	0.0	0		0	0			0	0	0	0
459467	SD	school	4600003	54007	Wilmot 54-7	460000300872	3	Wilmot Middle School	Regular School	Not applicable	Middle	06	08	2021	grade_7	15.0	0.0	0.0	2.0			0.0	9.0	8.0	17.0	15	0	0	2			0	9	8	17
497856	SD	school	4600003	54007	Wilmot 54-7	460000300757	2	Wilmot Elem	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	0	0	0
497857	SD	school	4600003	54007	Wilmot 54-7	460000300758	1	Wilmot 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
497858	SD	school	4600003	54007	Wilmot 54-7	460000300872	3	Wilmot Jr. High	Regular School	Not applicable	Middle	07	08	2020	grade_7	14.0	1.0	0.0	3.0			1.0	12.0	7.0	19.0	14	1	0	3			1	12	7	19
2972081	SD	school	4600003	54007	Wilmot 54-7	460000300757	2	Wilmot Elem	Regular School	No	1	PK	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
2972082	SD	school	4600003	54007	Wilmot 54-7	460000300758	1	Wilmot Hi Sch	Regular School	No	3	09	12	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
2972083	SD	school	4600003	54007	Wilmot 54-7	460000300872	3	Wilmot MS	Regular School	No	2	06	08	2015	grade_7	9.0		1.0	3.0				6.0	7.0	13.0	9		1	3				6	7	13
3016689	SD	school	4600003	54007	Wilmot 54-7	460000300757	2	Wilmot Elem	Regular School	No	Elementary	PK	06	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
3016690	SD	school	4600003	54007	Wilmot 54-7	460000300758	1	Wilmot Hi Sch	Regular School	No	High	09	12	2017	grade_7	0.0		0.0	0.0			0.0	0.0	0.0	0.0	0		0	0			0	0	0	0
3016691	SD	school	4600003	54007	Wilmot 54-7	460000300872	3	Wilmot Jr. High	Regular School	No	Middle	07	08	2017	grade_7	11.0		1.0	3.0				9.0	6.0	15.0	11		1	3				9	6	15
3354585	SD	school	4600003	54007	Wilmot 54-7	460000300757	2	Wilmot Elem	Regular School	No	1	PK	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
3354586	SD	school	4600003	54007	Wilmot 54-7	460000300758	1	Wilmot Hi Sch	Regular School	No	3	09	12	2016	grade_7	0.0		0.0	0.0			0.0	0.0	0.0	0.0	0		0	0			0	0	0	0
3354587	SD	school	4600003	54007	Wilmot 54-7	460000300872	3	Wilmot MS	Regular School	No	2	06	08	2016	grade_7	10.0		0.0	0.0				6.0	4.0	10.0	10		0	0				6	4	10
254369	SD	school	4600025	48003	Howard 48-3	460002500304	2	Howard Elem	Regular School	No	Elementary	KG	06	2018	grade_7	0.0	0.0	0.0	0.0				0.0	0.0	0.0	0	0	0	0				0	0	0
254370	SD	school	4600025	48003	Howard 48-3	460002500305	1	Howard Hi Sch	Regular School	No	High	09	12	2018	grade_7	0.0	0.0	0.0					0.0	0.0	0.0	0	0	0					0	0	0
254371	SD	school	4600025	48003	Howard 48-3	460002500913	5	Howard Jr Hi	Regular School	No	Middle	07	08	2018	grade_7	36.0	3.0	1.0				0.0	23.0	17.0	40.0	36	3	1				0	23	17	40
254372	SD	school	4600025	48003	Howard 48-3	460002501161	8	Shannon Colony	Regular School	No	Elementary	KG	08	2018	grade_7	3.0							2.0	1.0	3.0	3							2	1	3
361596	SD	school	4600025	48003	Howard 48-3	460002500304	2	Howard Elem	Regular School	No	Elementary	KG	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
361597	SD	school	4600025	48003	Howard 48-3	460002500305	1	Howard Hi Sch	Regular School	No	High	09	12	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
361598	SD	school	4600025	48003	Howard 48-3	460002500913	5	Howard Jr Hi	Regular School	No	Middle	07	08	2019	grade_7	21.0	0.0	0.0	1.0				11.0	11.0	22.0	21	0	0	1				11	11	22
361599	SD	school	4600025	48003	Howard 48-3	460002501161	8	Shannon Colony	Regular School	No	Elementary	KG	08	2019	grade_7	1.0							0.0	1.0	1.0	1							0	1	1
453442	SD	school	4600025	48003	Howard 48-3	460002500304	2	Howard Elem	Regular School	Not applicable	Elementary	KG	06	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
453443	SD	school	4600025	48003	Howard 48-3	460002500305	1	Howard Hi Sch	Regular School	Not applicable	High	09	12	2021	grade_7	0.0	0.0	0.0				0.0	0.0	0.0	0.0	0	0	0				0	0	0	0
453444	SD	school	4600025	48003	Howard 48-3	460002500913	5	Howard Jr Hi	Regular School	Not applicable	Middle	07	08	2021	grade_7	24.0		1.0					13.0	12.0	25.0	24		1					13	12	25
453445	SD	school	4600025	48003	Howard 48-3	460002501161	8	Shannon Colony	Regular School	Not applicable	Elementary	KG	08	2021	grade_7	3.0							1.0	2.0	3.0	3							1	2	3
491865	SD	school	4600025	48003	Howard 48-3	460002500304	2	Howard Elem	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
491866	SD	school	4600025	48003	Howard 48-3	460002500305	1	Howard 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
491867	SD	school	4600025	48003	Howard 48-3	460002500913	5	Howard Jr Hi	Regular School	Not applicable	Middle	07	08	2020	grade_7	27.0		1.0	0.0				16.0	12.0	28.0	27		1	0				16	12	28
491868	SD	school	4600025	48003	Howard 48-3	460002501161	8	Shannon Colony	Regular School	Not applicable	Elementary	KG	08	2020	grade_7	3.0							3.0	0.0	3.0	3							3	0	3
2966138	SD	school	4600025	48003	Howard 48-3	460002500304	2	Howard Elem	Regular School	No	1	KG	06	2015	grade_7	0.0	0.0	0.0				0.0	0.0	0.0	0.0	0	0	0				0	0	0	0
2966139	SD	school	4600025	48003	Howard 48-3	460002500305	1	Howard Hi Sch	Regular School	No	3	09	12	2015	grade_7	0.0		0.0					0.0	0.0	0.0	0		0					0	0	0
2966140	SD	school	4600025	48003	Howard 48-3	460002500913	5	Howard Jr Hi	Regular School	No	2	07	08	2015	grade_7	25.0	0.0	0.0					10.0	15.0	25.0	25	0	0					10	15	25
2966141	SD	school	4600025	48003	Howard 48-3	460002501161	8	Shannon Colony	Regular School	No	1	KG	08	2015	grade_7	3.0							1.0	2.0	3.0	3							1	2	3
3010826	SD	school	4600025	48003	Howard 48-3	460002500304	2	Howard Elem	Regular School	No	Elementary	KG	06	2017	grade_7	0.0	0.0	0.0					0.0	0.0	0.0	0	0	0					0	0	0
3010827	SD	school	4600025	48003	Howard 48-3	460002500305	1	Howard Hi Sch	Regular School	No	High	09	12	2017	grade_7	0.0	0.0	0.0					0.0	0.0	0.0	0	0	0					0	0	0
3010828	SD	school	4600025	48003	Howard 48-3	460002500913	5	Howard Jr Hi	Regular School	No	Middle	07	08	2017	grade_7	15.0		0.0				2.0	10.0	7.0	17.0	15		0				2	10	7	17
3010829	SD	school	4600025	48003	Howard 48-3	460002501161	8	Shannon Colony	Regular School	No	Elementary	KG	08	2017	grade_7	2.0							1.0	1.0	2.0	2							1	1	2
3348722	SD	school	4600025	48003	Howard 48-3	460002500304	2	Howard Elem	Regular School	No	1	KG	06	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
3348723	SD	school	4600025	48003	Howard 48-3	460002500305	1	Howard Hi Sch	Regular School	No	3	09	12	2016	grade_7	0.0	0.0	0.0					0.0	0.0	0.0	0	0	0					0	0	0
3348724	SD	school	4600025	48003	Howard 48-3	460002500913	5	Howard Jr Hi	Regular School	No	2	07	08	2016	grade_7	24.0		1.0					15.0	10.0	25.0	24		1					15	10	25
3348725	SD	school	4600025	48003	Howard 48-3	460002501161	8	Shannon Colony	Regular School	No	1	KG	08	2016	grade_7	1.0							0.0	1.0	1.0	1							0	1	1
250056	SD	school	4600028	61001	Alcester-Hudson 61-1	460002800013	4	Alcester-Hudson Elementary	Regular School	No	Elementary	PK	06	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
250057	SD	school	4600028	61001	Alcester-Hudson 61-1	460002800014	1	Alcester-Hudson High School	Regular School	No	High	09	12	2018	grade_7	0.0		0.0					0.0	0.0	0.0	0		0					0	0	0
250058	SD	school	4600028	61001	Alcester-Hudson 61-1	460002800874	3	Alcester-Hudson JH	Regular School	No	Middle	07	08	2018	grade_7	19.0		1.0				1.0	9.0	12.0	21.0	19		1				1	9	12	21
357299	SD	school	4600028	61001	Alcester-Hudson 61-1	460002800013	4	Alcester-Hudson Elementary	Regular School	No	Elementary	PK	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
357300	SD	school	4600028	61001	Alcester-Hudson 61-1	460002800014	1	Alcester-Hudson High School	Regular School	No	High	09	12	2019	grade_7	0.0		0.0				0.0	0.0	0.0	0.0	0		0				0	0	0	0
357301	SD	school	4600028	61001	Alcester-Hudson 61-1	460002800874	3	Alcester-Hudson JH	Regular School	No	Middle	07	08	2019	grade_7	30.0		2.0				1.0	17.0	16.0	33.0	30		2				1	17	16	33
449161	SD	school	4600028	61001	Alcester-Hudson 61-1	460002800013	4	Alcester-Hudson Elementary	Regular School	Not applicable	Elementary	PK	06	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
449162	SD	school	4600028	61001	Alcester-Hudson 61-1	460002800014	1	Alcester-Hudson High School	Regular School	Not applicable	High	09	12	2021	grade_7	0.0		0.0				0.0	0.0	0.0	0.0	0		0				0	0	0	0
449163	SD	school	4600028	61001	Alcester-Hudson 61-1	460002800874	3	Alcester-Hudson JH	Regular School	Not applicable	Middle	07	08	2021	grade_7	20.0		1.0				2.0	13.0	10.0	23.0	20		1				2	13	10	23
487584	SD	school	4600028	61001	Alcester-Hudson 61-1	460002800013	4	Alcester-Hudson 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	0	0	0
487585	SD	school	4600028	61001	Alcester-Hudson 61-1	460002800014	1	Alcester-Hudson 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
487586	SD	school	4600028	61001	Alcester-Hudson 61-1	460002800874	3	Alcester-Hudson JH	Regular School	Not applicable	Middle	07	08	2020	grade_7	24.0		2.0				0.0	12.0	14.0	26.0	24		2				0	12	14	26
2961857	SD	school	4600028	61001	Alcester-Hudson 61-1	460002800013	4	Alcester-Hudson Elementary	Regular School	No	1	PK	06	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
2961858	SD	school	4600028	61001	Alcester-Hudson 61-1	460002800014	1	Alcester-Hudson High School	Regular School	No	3	09	12	2015	grade_7	0.0		0.0				0.0	0.0	0.0	0.0	0		0				0	0	0	0
2961859	SD	school	4600028	61001	Alcester-Hudson 61-1	460002800874	3	Alcester-Hudson JH	Regular School	No	2	07	08	2015	grade_7	9.0		1.0					6.0	4.0	10.0	9		1					6	4	10
3006481	SD	school	4600028	61001	Alcester-Hudson 61-1	460002800013	4	Alcester-Hudson Elementary	Regular School	No	Elementary	PK	06	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
3006482	SD	school	4600028	61001	Alcester-Hudson 61-1	460002800014	1	Alcester-Hudson High School	Regular School	No	High	09	12	2017	grade_7	0.0	0.0	0.0		0.0			0.0	0.0	0.0	0	0	0		0			0	0	0
3006483	SD	school	4600028	61001	Alcester-Hudson 61-1	460002800874	3	Alcester-Hudson JH	Regular School	No	Middle	07	08	2017	grade_7	14.0		1.0				2.0	9.0	8.0	17.0	14		1				2	9	8	17
3344409	SD	school	4600028	61001	Alcester-Hudson 61-1	460002800013	4	Alcester-Hudson Elementary	Regular School	No	1	PK	06	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
3344410	SD	school	4600028	61001	Alcester-Hudson 61-1	460002800014	1	Alcester-Hudson High School	Regular School	No	3	09	12	2016	grade_7	0.0	0.0	0.0					0.0	0.0	0.0	0	0	0					0	0	0
3344411	SD	school	4600028	61001	Alcester-Hudson 61-1	460002800874	3	Alcester-Hudson JH	Regular School	No	2	07	08	2016	grade_7	28.0		1.0	1.0				15.0	15.0	30.0	28		1	1				15	15	30
252152	SD	school	4600036	19004	Deuel 19-4	460003601011	2	Clear Lake Elementary	Regular School	No	Elementary	PK	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
252153	SD	school	4600036	19004	Deuel 19-4	460003601013	4	Clear Lake Middle School	Regular School	No	Middle	06	08	2018	grade_7	35.0	1.0	0.0					20.0	16.0	36.0	35	1	0					20	16	36
252154	SD	school	4600036	19004	Deuel 19-4	460003601010	1	Deuel High School	Regular School	No	High	09	12	2018	grade_7	0.0		0.0			0.0		0.0	0.0	0.0	0		0			0		0	0	0
359411	SD	school	4600036	19004	Deuel 19-4	460003601011	2	Clear Lake Elementary	Regular School	No	Elementary	PK	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
359412	SD	school	4600036	19004	Deuel 19-4	460003601013	4	Clear Lake Middle School	Regular School	No	Middle	06	08	2019	grade_7	41.0	0.0	1.0	1.0				18.0	25.0	43.0	41	0	1	1				18	25	43
359413	SD	school	4600036	19004	Deuel 19-4	460003601010	1	Deuel High School	Regular School	No	High	09	12	2019	grade_7	0.0		0.0	0.0				0.0	0.0	0.0	0		0	0				0	0	0
451257	SD	school	4600036	19004	Deuel 19-4	460003601011	2	Clear Lake Elementary	Regular School	Not applicable	Elementary	PK	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
451258	SD	school	4600036	19004	Deuel 19-4	460003601013	4	Clear Lake Middle School	Regular School	Not applicable	Middle	06	08	2021	grade_7	38.0	0.0	1.0				1.0	19.0	21.0	40.0	38	0	1				1	19	21	40
451259	SD	school	4600036	19004	Deuel 19-4	460003601010	1	Deuel High School	Regular School	Not applicable	High	09	12	2021	grade_7	0.0	0.0	0.0				0.0	0.0	0.0	0.0	0	0	0				0	0	0	0
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
489681	SD	school	4600036	19004	Deuel 19-4	460003601013	4	Clear Lake Middle School	Regular School	Not applicable	Middle	06	08	2020	grade_7	43.0		3.0				0.0	26.0	20.0	46.0	43		3				0	26	20	46
489682	SD	school	4600036	19004	Deuel 19-4	460003601010	1	Deuel 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
2963873	SD	school	4600036	19004	Deuel 19-4	460003601011	2	Clear Lake Elementary	Regular School	No	1	PK	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
2963874	SD	school	4600036	19004	Deuel 19-4	460003601013	4	Clear Lake Middle School	Regular School	No	2	06	08	2015	grade_7	34.0		0.0	0.0				12.0	22.0	34.0	34		0	0				12	22	34
2963875	SD	school	4600036	19004	Deuel 19-4	460003601010	1	Deuel High School	Regular School	No	3	09	12	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
3008561	SD	school	4600036	19004	Deuel 19-4	460003601011	2	Clear Lake Elementary	Regular School	No	Elementary	PK	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
3008562	SD	school	4600036	19004	Deuel 19-4	460003601013	4	Clear Lake Middle School	Regular School	No	Middle	06	08	2017	grade_7	30.0	0.0	1.0	0.0				17.0	14.0	31.0	30	0	1	0				17	14	31
3008563	SD	school	4600036	19004	Deuel 19-4	460003601010	1	Deuel High School	Regular School	No	High	09	12	2017	grade_7	0.0		0.0			0.0		0.0	0.0	0.0	0		0			0		0	0	0
3346473	SD	school	4600036	19004	Deuel 19-4	460003601011	2	Clear Lake Elementary	Regular School	No	1	PK	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
3346474	SD	school	4600036	19004	Deuel 19-4	460003601013	4	Clear Lake Middle School	Regular School	No	2	06	08	2016	grade_7	31.0		3.0					16.0	18.0	34.0	31		3					16	18	34
3346475	SD	school	4600036	19004	Deuel 19-4	460003601010	1	Deuel High School	Regular School	No	3	09	12	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
251011	SD	school	4600041	45004	Britton-Hecla 45-4	460004101140	2	Britton-Hecla Elementary School	Regular School	No	Elementary	KG	06	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
251012	SD	school	4600041	45004	Britton-Hecla 45-4	460004101141	1	Britton-Hecla High School	Regular School	No	High	09	12	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
251013	SD	school	4600041	45004	Britton-Hecla 45-4	460004101142	3	Britton-Hecla Junior High	Regular School	No	Middle	07	08	2018	grade_7	33.0			0.0	1.0			21.0	13.0	34.0	33			0	1			21	13	34
251014	SD	school	4600041	45004	Britton-Hecla 45-4	460004101143	4	Sunset Colony Elementary	Regular School	No	Elementary	KG	08	2018	grade_7	2.0							2.0	0.0	2.0	2							2	0	2