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
3012354	SD	school	4600002	25004	Milbank 25-4	460000200423	3	Koch Elementary	Regular School	No	Elementary	KG	05	2017	grade_2	56.0	2.0	3.0				2.0	35.0	28.0	63.0	56	2	3				2	35	28	63
3012355	SD	school	4600002	25004	Milbank 25-4	460000200424	1	Milbank High School	Regular School	No	High	09	12	2017	grade_2	0.0		0.0	0.0		0.0	0.0	0.0	0.0	0.0	0		0	0		0	0	0	0	0
3012356	SD	school	4600002	25004	Milbank 25-4	460000200425	2	Milbank Middle School	Regular School	No	Middle	06	08	2017	grade_2	0.0		0.0				0.0	0.0	0.0	0.0	0		0				0	0	0	0
3350218	SD	school	4600002	25004	Milbank 25-4	460000200423	3	Koch Elementary	Regular School	No	1	KG	05	2016	grade_2	57.0	2.0	6.0				2.0	37.0	30.0	67.0	57	2	6				2	37	30	67
3350219	SD	school	4600002	25004	Milbank 25-4	460000200424	1	Milbank High School	Regular School	No	3	09	12	2016	grade_2	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0	0	0	0	0	0	0	0	0	0
3350220	SD	school	4600002	25004	Milbank 25-4	460000200425	2	Milbank Middle School	Regular School	No	2	06	08	2016	grade_2	0.0		0.0	0.0	0.0		0.0	0.0	0.0	0.0	0		0	0	0		0	0	0	0
260281	SD	school	4600003	54007	Wilmot 54-7	460000300757	2	Wilmot Elem	Regular School	No	Elementary	PK	06	2018	grade_2	5.0	0.0	0.0	5.0			0.0	1.0	9.0	10.0	5	0	0	5			0	1	9	10
260282	SD	school	4600003	54007	Wilmot 54-7	460000300758	1	Wilmot Hi Sch	Regular School	No	High	09	12	2018	grade_2	0.0		0.0	0.0			0.0	0.0	0.0	0.0	0		0	0			0	0	0	0
260283	SD	school	4600003	54007	Wilmot 54-7	460000300872	3	Wilmot Jr. High	Regular School	No	Middle	07	08	2018	grade_2	0.0			0.0				0.0	0.0	0.0	0			0				0	0	0
367540	SD	school	4600003	54007	Wilmot 54-7	460000300757	2	Wilmot Elem	Regular School	No	Elementary	PK	06	2019	grade_2	5.0	1.0	1.0	5.0			0.0	7.0	5.0	12.0	5	1	1	5			0	7	5	12
367541	SD	school	4600003	54007	Wilmot 54-7	460000300758	1	Wilmot Hi Sch	Regular School	No	High	09	12	2019	grade_2	0.0		0.0	0.0			0.0	0.0	0.0	0.0	0		0	0			0	0	0	0
367542	SD	school	4600003	54007	Wilmot 54-7	460000300872	3	Wilmot Jr. High	Regular School	No	Middle	07	08	2019	grade_2	0.0		0.0	0.0				0.0	0.0	0.0	0		0	0				0	0	0
459450	SD	school	4600003	54007	Wilmot 54-7	460000300757	2	Wilmot Elem	Regular School	Not applicable	Elementary	PK	05	2021	grade_2	12.0	1.0	0.0	1.0			0.0	10.0	4.0	14.0	12	1	0	1			0	10	4	14
459451	SD	school	4600003	54007	Wilmot 54-7	460000300758	1	Wilmot Hi Sch	Regular School	Not applicable	High	09	12	2021	grade_2	0.0		0.0	0.0			0.0	0.0	0.0	0.0	0		0	0			0	0	0	0
459452	SD	school	4600003	54007	Wilmot 54-7	460000300872	3	Wilmot Middle School	Regular School	Not applicable	Middle	06	08	2021	grade_2	0.0	0.0	0.0	0.0			0.0	0.0	0.0	0.0	0	0	0	0			0	0	0	0
497841	SD	school	4600003	54007	Wilmot 54-7	460000300757	2	Wilmot Elem	Regular School	Not applicable	Elementary	PK	06	2020	grade_2	23.0	0.0	2.0	6.0			0.0	16.0	15.0	31.0	23	0	2	6			0	16	15	31
497842	SD	school	4600003	54007	Wilmot 54-7	460000300758	1	Wilmot Hi Sch	Regular School	Not applicable	High	09	12	2020	grade_2	0.0		0.0	0.0			0.0	0.0	0.0	0.0	0		0	0			0	0	0	0
497843	SD	school	4600003	54007	Wilmot 54-7	460000300872	3	Wilmot Jr. High	Regular School	Not applicable	Middle	07	08	2020	grade_2	0.0	0.0	0.0	0.0			0.0	0.0	0.0	0.0	0	0	0	0			0	0	0	0
2972066	SD	school	4600003	54007	Wilmot 54-7	460000300757	2	Wilmot Elem	Regular School	No	1	PK	05	2015	grade_2	11.0	0.0	0.0	3.0		0.0	1.0	11.0	4.0	15.0	11	0	0	3		0	1	11	4	15
2972067	SD	school	4600003	54007	Wilmot 54-7	460000300758	1	Wilmot Hi Sch	Regular School	No	3	09	12	2015	grade_2	0.0	0.0	0.0	0.0			0.0	0.0	0.0	0.0	0	0	0	0			0	0	0	0
2972068	SD	school	4600003	54007	Wilmot 54-7	460000300872	3	Wilmot MS	Regular School	No	2	06	08	2015	grade_2	0.0		0.0	0.0				0.0	0.0	0.0	0		0	0				0	0	0
3016674	SD	school	4600003	54007	Wilmot 54-7	460000300757	2	Wilmot Elem	Regular School	No	Elementary	PK	06	2017	grade_2	9.0	0.0	1.0	4.0			1.0	9.0	6.0	15.0	9	0	1	4			1	9	6	15
3016675	SD	school	4600003	54007	Wilmot 54-7	460000300758	1	Wilmot Hi Sch	Regular School	No	High	09	12	2017	grade_2	0.0		0.0	0.0			0.0	0.0	0.0	0.0	0		0	0			0	0	0	0
3016676	SD	school	4600003	54007	Wilmot 54-7	460000300872	3	Wilmot Jr. High	Regular School	No	Middle	07	08	2017	grade_2	0.0		0.0	0.0				0.0	0.0	0.0	0		0	0				0	0	0
3354570	SD	school	4600003	54007	Wilmot 54-7	460000300757	2	Wilmot Elem	Regular School	No	1	PK	05	2016	grade_2	14.0	0.0	0.0	0.0		0.0	0.0	5.0	9.0	14.0	14	0	0	0		0	0	5	9	14
3354571	SD	school	4600003	54007	Wilmot 54-7	460000300758	1	Wilmot Hi Sch	Regular School	No	3	09	12	2016	grade_2	0.0		0.0	0.0			0.0	0.0	0.0	0.0	0		0	0			0	0	0	0
3354572	SD	school	4600003	54007	Wilmot 54-7	460000300872	3	Wilmot MS	Regular School	No	2	06	08	2016	grade_2	0.0		0.0	0.0				0.0	0.0	0.0	0		0	0				0	0	0
254349	SD	school	4600025	48003	Howard 48-3	460002500304	2	Howard Elem	Regular School	No	Elementary	KG	06	2018	grade_2	24.0	1.0	0.0	1.0				21.0	5.0	26.0	24	1	0	1				21	5	26
254350	SD	school	4600025	48003	Howard 48-3	460002500305	1	Howard Hi Sch	Regular School	No	High	09	12	2018	grade_2	0.0	0.0	0.0					0.0	0.0	0.0	0	0	0					0	0	0
254351	SD	school	4600025	48003	Howard 48-3	460002500913	5	Howard Jr Hi	Regular School	No	Middle	07	08	2018	grade_2	0.0	0.0	0.0				0.0	0.0	0.0	0.0	0	0	0				0	0	0	0
254352	SD	school	4600025	48003	Howard 48-3	460002501161	8	Shannon Colony	Regular School	No	Elementary	KG	08	2018	grade_2	4.0							1.0	3.0	4.0	4							1	3	4
361576	SD	school	4600025	48003	Howard 48-3	460002500304	2	Howard Elem	Regular School	No	Elementary	KG	06	2019	grade_2	24.0	1.0	2.0	0.0				13.0	14.0	27.0	24	1	2	0				13	14	27
361577	SD	school	4600025	48003	Howard 48-3	460002500305	1	Howard Hi Sch	Regular School	No	High	09	12	2019	grade_2	0.0	0.0	0.0		0.0		0.0	0.0	0.0	0.0	0	0	0		0		0	0	0	0
361578	SD	school	4600025	48003	Howard 48-3	460002500913	5	Howard Jr Hi	Regular School	No	Middle	07	08	2019	grade_2	0.0	0.0	0.0	0.0				0.0	0.0	0.0	0	0	0	0				0	0	0
361579	SD	school	4600025	48003	Howard 48-3	460002501161	8	Shannon Colony	Regular School	No	Elementary	KG	08	2019	grade_2	3.0							2.0	1.0	3.0	3							2	1	3
453422	SD	school	4600025	48003	Howard 48-3	460002500304	2	Howard Elem	Regular School	Not applicable	Elementary	KG	06	2021	grade_2	22.0	0.0	1.0	0.0			0.0	13.0	10.0	23.0	22	0	1	0			0	13	10	23
453423	SD	school	4600025	48003	Howard 48-3	460002500305	1	Howard Hi Sch	Regular School	Not applicable	High	09	12	2021	grade_2	0.0	0.0	0.0				0.0	0.0	0.0	0.0	0	0	0				0	0	0	0
453424	SD	school	4600025	48003	Howard 48-3	460002500913	5	Howard Jr Hi	Regular School	Not applicable	Middle	07	08	2021	grade_2	0.0		0.0					0.0	0.0	0.0	0		0					0	0	0
453425	SD	school	4600025	48003	Howard 48-3	460002501161	8	Shannon Colony	Regular School	Not applicable	Elementary	KG	08	2021	grade_2	3.0							0.0	3.0	3.0	3							0	3	3
491845	SD	school	4600025	48003	Howard 48-3	460002500304	2	Howard Elem	Regular School	Not applicable	Elementary	KG	06	2020	grade_2	18.0	0.0	1.0	0.0				11.0	8.0	19.0	18	0	1	0				11	8	19
491846	SD	school	4600025	48003	Howard 48-3	460002500305	1	Howard Hi Sch	Regular School	Not applicable	High	09	12	2020	grade_2	0.0	0.0	0.0				0.0	0.0	0.0	0.0	0	0	0				0	0	0	0
491847	SD	school	4600025	48003	Howard 48-3	460002500913	5	Howard Jr Hi	Regular School	Not applicable	Middle	07	08	2020	grade_2	0.0		0.0	0.0				0.0	0.0	0.0	0		0	0				0	0	0
491848	SD	school	4600025	48003	Howard 48-3	460002501161	8	Shannon Colony	Regular School	Not applicable	Elementary	KG	08	2020	grade_2	4.0							2.0	2.0	4.0	4							2	2	4
2966118	SD	school	4600025	48003	Howard 48-3	460002500304	2	Howard Elem	Regular School	No	1	KG	06	2015	grade_2	26.0	0.0	1.0				0.0	16.0	11.0	27.0	26	0	1				0	16	11	27
2966119	SD	school	4600025	48003	Howard 48-3	460002500305	1	Howard Hi Sch	Regular School	No	3	09	12	2015	grade_2	0.0		0.0					0.0	0.0	0.0	0		0					0	0	0
2966120	SD	school	4600025	48003	Howard 48-3	460002500913	5	Howard Jr Hi	Regular School	No	2	07	08	2015	grade_2	0.0	0.0	0.0					0.0	0.0	0.0	0	0	0					0	0	0
2966121	SD	school	4600025	48003	Howard 48-3	460002501161	8	Shannon Colony	Regular School	No	1	KG	08	2015	grade_2	2.0							1.0	1.0	2.0	2							1	1	2
3010806	SD	school	4600025	48003	Howard 48-3	460002500304	2	Howard Elem	Regular School	No	Elementary	KG	06	2017	grade_2	25.0	0.0	2.0					14.0	13.0	27.0	25	0	2					14	13	27
3010807	SD	school	4600025	48003	Howard 48-3	460002500305	1	Howard Hi Sch	Regular School	No	High	09	12	2017	grade_2	0.0	0.0	0.0					0.0	0.0	0.0	0	0	0					0	0	0
3010808	SD	school	4600025	48003	Howard 48-3	460002500913	5	Howard Jr Hi	Regular School	No	Middle	07	08	2017	grade_2	0.0		0.0				0.0	0.0	0.0	0.0	0		0				0	0	0	0
3010809	SD	school	4600025	48003	Howard 48-3	460002501161	8	Shannon Colony	Regular School	No	Elementary	KG	08	2017	grade_2	5.0							1.0	4.0	5.0	5							1	4	5
3348702	SD	school	4600025	48003	Howard 48-3	460002500304	2	Howard Elem	Regular School	No	1	KG	06	2016	grade_2	25.0	0.0	1.0	0.0			0.0	14.0	12.0	26.0	25	0	1	0			0	14	12	26
3348703	SD	school	4600025	48003	Howard 48-3	460002500305	1	Howard Hi Sch	Regular School	No	3	09	12	2016	grade_2	0.0	0.0	0.0					0.0	0.0	0.0	0	0	0					0	0	0
3348704	SD	school	4600025	48003	Howard 48-3	460002500913	5	Howard Jr Hi	Regular School	No	2	07	08	2016	grade_2	0.0		0.0					0.0	0.0	0.0	0		0					0	0	0
3348705	SD	school	4600025	48003	Howard 48-3	460002501161	8	Shannon Colony	Regular School	No	1	KG	08	2016	grade_2	3.0							1.0	2.0	3.0	3							1	2	3
250041	SD	school	4600028	61001	Alcester-Hudson 61-1	460002800013	4	Alcester-Hudson Elementary	Regular School	No	Elementary	PK	06	2018	grade_2	17.0		0.0		0.0	0.0	1.0	10.0	8.0	18.0	17		0		0	0	1	10	8	18
250042	SD	school	4600028	61001	Alcester-Hudson 61-1	460002800014	1	Alcester-Hudson High School	Regular School	No	High	09	12	2018	grade_2	0.0		0.0					0.0	0.0	0.0	0		0					0	0	0
250043	SD	school	4600028	61001	Alcester-Hudson 61-1	460002800874	3	Alcester-Hudson JH	Regular School	No	Middle	07	08	2018	grade_2	0.0		0.0				0.0	0.0	0.0	0.0	0		0				0	0	0	0
357284	SD	school	4600028	61001	Alcester-Hudson 61-1	460002800013	4	Alcester-Hudson Elementary	Regular School	No	Elementary	PK	06	2019	grade_2	30.0		2.0	0.0	1.0		3.0	21.0	15.0	36.0	30		2	0	1		3	21	15	36
357285	SD	school	4600028	61001	Alcester-Hudson 61-1	460002800014	1	Alcester-Hudson High School	Regular School	No	High	09	12	2019	grade_2	0.0		0.0				0.0	0.0	0.0	0.0	0		0				0	0	0	0
357286	SD	school	4600028	61001	Alcester-Hudson 61-1	460002800874	3	Alcester-Hudson JH	Regular School	No	Middle	07	08	2019	grade_2	0.0		0.0				0.0	0.0	0.0	0.0	0		0				0	0	0	0
449146	SD	school	4600028	61001	Alcester-Hudson 61-1	460002800013	4	Alcester-Hudson Elementary	Regular School	Not applicable	Elementary	PK	06	2021	grade_2	29.0		1.0	1.0	0.0		0.0	15.0	16.0	31.0	29		1	1	0		0	15	16	31
449147	SD	school	4600028	61001	Alcester-Hudson 61-1	460002800014	1	Alcester-Hudson High School	Regular School	Not applicable	High	09	12	2021	grade_2	0.0		0.0				0.0	0.0	0.0	0.0	0		0				0	0	0	0
449148	SD	school	4600028	61001	Alcester-Hudson 61-1	460002800874	3	Alcester-Hudson JH	Regular School	Not applicable	Middle	07	08	2021	grade_2	0.0		0.0				0.0	0.0	0.0	0.0	0		0				0	0	0	0
487569	SD	school	4600028	61001	Alcester-Hudson 61-1	460002800013	4	Alcester-Hudson Elementary	Regular School	Not applicable	Elementary	PK	06	2020	grade_2	23.0		2.0	1.0	0.0		0.0	9.0	17.0	26.0	23		2	1	0		0	9	17	26
487570	SD	school	4600028	61001	Alcester-Hudson 61-1	460002800014	1	Alcester-Hudson High School	Regular School	Not applicable	High	09	12	2020	grade_2	0.0		0.0				0.0	0.0	0.0	0.0	0		0				0	0	0	0
487571	SD	school	4600028	61001	Alcester-Hudson 61-1	460002800874	3	Alcester-Hudson JH	Regular School	Not applicable	Middle	07	08	2020	grade_2	0.0		0.0				0.0	0.0	0.0	0.0	0		0				0	0	0	0
2961842	SD	school	4600028	61001	Alcester-Hudson 61-1	460002800013	4	Alcester-Hudson Elementary	Regular School	No	1	PK	06	2015	grade_2	21.0	0.0	1.0	0.0		1.0	1.0	12.0	12.0	24.0	21	0	1	0		1	1	12	12	24
2961843	SD	school	4600028	61001	Alcester-Hudson 61-1	460002800014	1	Alcester-Hudson High School	Regular School	No	3	09	12	2015	grade_2	0.0		0.0				0.0	0.0	0.0	0.0	0		0				0	0	0	0
2961844	SD	school	4600028	61001	Alcester-Hudson 61-1	460002800874	3	Alcester-Hudson JH	Regular School	No	2	07	08	2015	grade_2	0.0		0.0					0.0	0.0	0.0	0		0					0	0	0
3006466	SD	school	4600028	61001	Alcester-Hudson 61-1	460002800013	4	Alcester-Hudson Elementary	Regular School	No	Elementary	PK	06	2017	grade_2	25.0		1.0	0.0	0.0		1.0	11.0	16.0	27.0	25		1	0	0		1	11	16	27
3006467	SD	school	4600028	61001	Alcester-Hudson 61-1	460002800014	1	Alcester-Hudson High School	Regular School	No	High	09	12	2017	grade_2	0.0	0.0	0.0		0.0			0.0	0.0	0.0	0	0	0		0			0	0	0
3006468	SD	school	4600028	61001	Alcester-Hudson 61-1	460002800874	3	Alcester-Hudson JH	Regular School	No	Middle	07	08	2017	grade_2	0.0		0.0				0.0	0.0	0.0	0.0	0		0				0	0	0	0
3344394	SD	school	4600028	61001	Alcester-Hudson 61-1	460002800013	4	Alcester-Hudson Elementary	Regular School	No	1	PK	06	2016	grade_2	18.0	0.0	0.0	0.0			0.0	10.0	8.0	18.0	18	0	0	0			0	10	8	18
3344395	SD	school	4600028	61001	Alcester-Hudson 61-1	460002800014	1	Alcester-Hudson High School	Regular School	No	3	09	12	2016	grade_2	0.0	0.0	0.0					0.0	0.0	0.0	0	0	0					0	0	0
3344396	SD	school	4600028	61001	Alcester-Hudson 61-1	460002800874	3	Alcester-Hudson JH	Regular School	No	2	07	08	2016	grade_2	0.0		0.0	0.0				0.0	0.0	0.0	0		0	0				0	0	0
252137	SD	school	4600036	19004	Deuel 19-4	460003601011	2	Clear Lake Elementary	Regular School	No	Elementary	PK	05	2018	grade_2	33.0	0.0	2.0	1.0		0.0		20.0	16.0	36.0	33	0	2	1		0		20	16	36
252138	SD	school	4600036	19004	Deuel 19-4	460003601013	4	Clear Lake Middle School	Regular School	No	Middle	06	08	2018	grade_2	0.0	0.0	0.0					0.0	0.0	0.0	0	0	0					0	0	0
252139	SD	school	4600036	19004	Deuel 19-4	460003601010	1	Deuel High School	Regular School	No	High	09	12	2018	grade_2	0.0		0.0			0.0		0.0	0.0	0.0	0		0			0		0	0	0
359396	SD	school	4600036	19004	Deuel 19-4	460003601011	2	Clear Lake Elementary	Regular School	No	Elementary	PK	05	2019	grade_2	29.0	0.0	3.0	2.0		0.0		17.0	17.0	34.0	29	0	3	2		0		17	17	34
359397	SD	school	4600036	19004	Deuel 19-4	460003601013	4	Clear Lake Middle School	Regular School	No	Middle	06	08	2019	grade_2	0.0	0.0	0.0	0.0				0.0	0.0	0.0	0	0	0	0				0	0	0
359398	SD	school	4600036	19004	Deuel 19-4	460003601010	1	Deuel High School	Regular School	No	High	09	12	2019	grade_2	0.0		0.0	0.0				0.0	0.0	0.0	0		0	0				0	0	0
451242	SD	school	4600036	19004	Deuel 19-4	460003601011	2	Clear Lake Elementary	Regular School	Not applicable	Elementary	PK	05	2021	grade_2	40.0	0.0	3.0	1.0			0.0	26.0	18.0	44.0	40	0	3	1			0	26	18	44
451243	SD	school	4600036	19004	Deuel 19-4	460003601013	4	Clear Lake Middle School	Regular School	Not applicable	Middle	06	08	2021	grade_2	0.0	0.0	0.0				0.0	0.0	0.0	0.0	0	0	0				0	0	0	0
451244	SD	school	4600036	19004	Deuel 19-4	460003601010	1	Deuel High School	Regular School	Not applicable	High	09	12	2021	grade_2	0.0	0.0	0.0				0.0	0.0	0.0	0.0	0	0	0				0	0	0	0
489665	SD	school	4600036	19004	Deuel 19-4	460003601011	2	Clear Lake Elementary	Regular School	Not applicable	Elementary	PK	05	2020	grade_2	27.0	0.0	4.0	1.0		0.0		18.0	14.0	32.0	27	0	4	1		0		18	14	32
489666	SD	school	4600036	19004	Deuel 19-4	460003601013	4	Clear Lake Middle School	Regular School	Not applicable	Middle	06	08	2020	grade_2	0.0		0.0				0.0	0.0	0.0	0.0	0		0				0	0	0	0
489667	SD	school	4600036	19004	Deuel 19-4	460003601010	1	Deuel High School	Regular School	Not applicable	High	09	12	2020	grade_2	0.0		0.0				0.0	0.0	0.0	0.0	0		0				0	0	0	0
2963858	SD	school	4600036	19004	Deuel 19-4	460003601011	2	Clear Lake Elementary	Regular School	No	1	PK	05	2015	grade_2	42.0	0.0	3.0	0.0				24.0	21.0	45.0	42	0	3	0				24	21	45
2963859	SD	school	4600036	19004	Deuel 19-4	460003601013	4	Clear Lake Middle School	Regular School	No	2	06	08	2015	grade_2	0.0		0.0	0.0				0.0	0.0	0.0	0		0	0				0	0	0
2963860	SD	school	4600036	19004	Deuel 19-4	460003601010	1	Deuel High School	Regular School	No	3	09	12	2015	grade_2	0.0	0.0	0.0	0.0	0.0	0.0		0.0	0.0	0.0	0	0	0	0	0	0		0	0	0
3008546	SD	school	4600036	19004	Deuel 19-4	460003601011	2	Clear Lake Elementary	Regular School	No	Elementary	PK	05	2017	grade_2	49.0	1.0	3.0	0.0		1.0		30.0	24.0	54.0	49	1	3	0		1		30	24	54
3008547	SD	school	4600036	19004	Deuel 19-4	460003601013	4	Clear Lake Middle School	Regular School	No	Middle	06	08	2017	grade_2	0.0	0.0	0.0	0.0				0.0	0.0	0.0	0	0	0	0				0	0	0
3008548	SD	school	4600036	19004	Deuel 19-4	460003601010	1	Deuel High School	Regular School	No	High	09	12	2017	grade_2	0.0		0.0			0.0		0.0	0.0	0.0	0		0			0		0	0	0
3346458	SD	school	4600036	19004	Deuel 19-4	460003601011	2	Clear Lake Elementary	Regular School	No	1	PK	05	2016	grade_2	37.0	0.0	3.0	0.0		0.0		17.0	23.0	40.0	37	0	3	0		0		17	23	40
3346459	SD	school	4600036	19004	Deuel 19-4	460003601013	4	Clear Lake Middle School	Regular School	No	2	06	08	2016	grade_2	0.0		0.0					0.0	0.0	0.0	0		0					0	0	0
3346460	SD	school	4600036	19004	Deuel 19-4	460003601010	1	Deuel High School	Regular School	No	3	09	12	2016	grade_2	0.0	0.0	0.0	0.0		0.0		0.0	0.0	0.0	0	0	0	0		0		0	0	0
250981	SD	school	4600041	45004	Britton-Hecla 45-4	460004101140	2	Britton-Hecla Elementary School	Regular School	No	Elementary	KG	06	2018	grade_2	25.0	1.0	1.0	0.0	0.0		1.0	15.0	13.0	28.0	25	1	1	0	0		1	15	13	28
250982	SD	school	4600041	45004	Britton-Hecla 45-4	460004101141	1	Britton-Hecla High School	Regular School	No	High	09	12	2018	grade_2	0.0	0.0	0.0	0.0	0.0	0.0		0.0	0.0	0.0	0	0	0	0	0	0		0	0	0
250983	SD	school	4600041	45004	Britton-Hecla 45-4	460004101142	3	Britton-Hecla Junior High	Regular School	No	Middle	07	08	2018	grade_2	0.0			0.0	0.0			0.0	0.0	0.0	0			0	0			0	0	0
250984	SD	school	4600041	45004	Britton-Hecla 45-4	460004101143	4	Sunset Colony Elementary	Regular School	No	Elementary	KG	08	2018	grade_2	1.0							1.0	0.0	1.0	1							1	0	1