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 district_state_id desc 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
256365	SD	school	4650850	9002	Newell 09-2	465085000468	2	Newell Elem	Regular School	No	Elementary	PK	05	2018	grade_1	14.0	0.0	2.0	0.0			1.0	9.0	8.0	17.0	14	0	2	0			1	9	8	17
256366	SD	school	4650850	9002	Newell 09-2	465085000469	1	Newell High School	Regular School	No	High	09	12	2018	grade_1	0.0	0.0	0.0	0.0		0.0	0.0	0.0	0.0	0.0	0	0	0	0		0	0	0	0	0
256367	SD	school	4650850	9002	Newell 09-2	465085000968	4	Newell Middle Sch	Regular School	No	Middle	06	08	2018	grade_1	0.0	0.0	0.0	0.0	0.0		0.0	0.0	0.0	0.0	0	0	0	0	0		0	0	0	0
363608	SD	school	4650850	9002	Newell 09-2	465085000468	2	Newell Elem	Regular School	No	Elementary	PK	05	2019	grade_1	16.0	0.0	1.0	2.0			0.0	7.0	12.0	19.0	16	0	1	2			0	7	12	19
363609	SD	school	4650850	9002	Newell 09-2	465085000469	1	Newell High School	Regular School	No	High	09	12	2019	grade_1	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0	0	0	0	0	0	0	0	0	0
363610	SD	school	4650850	9002	Newell 09-2	465085000968	4	Newell Middle Sch	Regular School	No	Middle	06	08	2019	grade_1	0.0	0.0	0.0	0.0	0.0		0.0	0.0	0.0	0.0	0	0	0	0	0		0	0	0	0
455470	SD	school	4650850	9002	Newell 09-2	465085000468	2	Newell Elem	Regular School	Not applicable	Elementary	PK	05	2021	grade_1	13.0	0.0	1.0	0.0	0.0			3.0	11.0	14.0	13	0	1	0	0			3	11	14
455471	SD	school	4650850	9002	Newell 09-2	465085000469	1	Newell High School	Regular School	Not applicable	High	09	12	2021	grade_1	0.0	0.0		0.0	0.0		0.0	0.0	0.0	0.0	0	0		0	0		0	0	0	0
455472	SD	school	4650850	9002	Newell 09-2	465085000968	4	Newell Middle Sch	Regular School	Not applicable	Middle	06	08	2021	grade_1	0.0	0.0	0.0	0.0			0.0	0.0	0.0	0.0	0	0	0	0			0	0	0	0
493893	SD	school	4650850	9002	Newell 09-2	465085000468	2	Newell Elem	Regular School	Not applicable	Elementary	PK	05	2020	grade_1	16.0		1.0	2.0			0.0	8.0	11.0	19.0	16		1	2			0	8	11	19
493894	SD	school	4650850	9002	Newell 09-2	465085000469	1	Newell High School	Regular School	Not applicable	High	09	12	2020	grade_1	0.0	0.0	0.0	0.0	0.0		0.0	0.0	0.0	0.0	0	0	0	0	0		0	0	0	0
493895	SD	school	4650850	9002	Newell 09-2	465085000968	4	Newell Middle Sch	Regular School	Not applicable	Middle	06	08	2020	grade_1	0.0	0.0	0.0	0.0	0.0		0.0	0.0	0.0	0.0	0	0	0	0	0		0	0	0	0
2968054	SD	school	4650850	9002	Newell 09-2	465085000468	2	Newell Elem	Regular School	No	1	PK	05	2015	grade_1	13.0	1.0	0.0	3.0	0.0		1.0	10.0	8.0	18.0	13	1	0	3	0		1	10	8	18
2968055	SD	school	4650850	9002	Newell 09-2	465085000469	1	Newell High School	Regular School	No	3	09	12	2015	grade_1	0.0	0.0		0.0				0.0	0.0	0.0	0	0		0				0	0	0
2968056	SD	school	4650850	9002	Newell 09-2	465085000968	4	Newell Middle Sch	Regular School	No	2	06	08	2015	grade_1	0.0	0.0	0.0	0.0		0.0	0.0	0.0	0.0	0.0	0	0	0	0		0	0	0	0	0
3012790	SD	school	4650850	9002	Newell 09-2	465085000468	2	Newell Elem	Regular School	No	Elementary	PK	05	2017	grade_1	17.0	1.0	0.0	0.0	0.0		1.0	10.0	9.0	19.0	17	1	0	0	0		1	10	9	19
3012791	SD	school	4650850	9002	Newell 09-2	465085000469	1	Newell High School	Regular School	No	High	09	12	2017	grade_1	0.0	0.0	0.0	0.0			0.0	0.0	0.0	0.0	0	0	0	0			0	0	0	0
3012792	SD	school	4650850	9002	Newell 09-2	465085000968	4	Newell Middle Sch	Regular School	No	Middle	06	08	2017	grade_1	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0	0	0	0	0	0	0	0	0	0
3350654	SD	school	4650850	9002	Newell 09-2	465085000468	2	Newell Elem	Regular School	No	1	PK	05	2016	grade_1	20.0	0.0	0.0	2.0	0.0		0.0	11.0	11.0	22.0	20	0	0	2	0		0	11	11	22
3350655	SD	school	4650850	9002	Newell 09-2	465085000469	1	Newell High School	Regular School	No	3	09	12	2016	grade_1	0.0	0.0	0.0	0.0			0.0	0.0	0.0	0.0	0	0	0	0			0	0	0	0
3350656	SD	school	4650850	9002	Newell 09-2	465085000968	4	Newell Middle Sch	Regular School	No	2	06	08	2016	grade_1	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0	0	0	0	0	0	0	0	0	0
250381	SD	school	4605610	9001	Belle Fourche 09-1	460561001277	9	Belle Fourche Education Connection	Alternative School	No	High	09	12	2018	grade_1	0.0		0.0	0.0			0.0	0.0	0.0	0.0	0		0	0			0	0	0	0
250382	SD	school	4605610	9001	Belle Fourche 09-1	460561000038	1	Belle Fourche HS	Regular School	No	High	09	12	2018	grade_1	0.0		0.0	0.0	0.0		0.0	0.0	0.0	0.0	0		0	0	0		0	0	0	0
250383	SD	school	4605610	9001	Belle Fourche 09-1	460561001117	7	Belle Fourche MS	Regular School	No	Middle	05	08	2018	grade_1	0.0		0.0	0.0			0.0	0.0	0.0	0.0	0		0	0			0	0	0	0
250384	SD	school	4605610	9001	Belle Fourche 09-1	460561000289	8	North Park Elementary	Regular School	No	Elementary	KG	KG	2018	grade_1	0.0		0.0	0.0			0.0	0.0	0.0	0.0	0		0	0			0	0	0	0
250385	SD	school	4605610	9001	Belle Fourche 09-1	460561000269	3	South Park Elementary	Regular School	No	Elementary	01	04	2018	grade_1	97.0		7.0	1.0			5.0	54.0	56.0	110.0	97		7	1			5	54	56	110
357624	SD	school	4605610	9001	Belle Fourche 09-1	460561001277	9	Belle Fourche Education Connection	Alternative School	No	High	09	12	2019	grade_1	0.0		0.0	0.0			0.0	0.0	0.0	0.0	0		0	0			0	0	0	0
357625	SD	school	4605610	9001	Belle Fourche 09-1	460561000038	1	Belle Fourche HS	Regular School	No	High	09	12	2019	grade_1	0.0		0.0	0.0	0.0		0.0	0.0	0.0	0.0	0		0	0	0		0	0	0	0
357626	SD	school	4605610	9001	Belle Fourche 09-1	460561001117	7	Belle Fourche MS	Regular School	No	Middle	05	08	2019	grade_1	0.0		0.0	0.0			0.0	0.0	0.0	0.0	0		0	0			0	0	0	0
357627	SD	school	4605610	9001	Belle Fourche 09-1	460561000289	8	North Park Elementary	Regular School	No	Elementary	KG	KG	2019	grade_1	0.0		0.0	0.0			0.0	0.0	0.0	0.0	0		0	0			0	0	0	0
357628	SD	school	4605610	9001	Belle Fourche 09-1	460561000269	3	South Park Elementary	Regular School	No	Elementary	01	04	2019	grade_1	94.0		2.0	0.0			7.0	54.0	49.0	103.0	94		2	0			7	54	49	103
449470	SD	school	4605610	9001	Belle Fourche 09-1	460561001277	9	Belle Fourche Education Connection	Alternative School	Not applicable	High	09	12	2021	grade_1	0.0		0.0				0.0	0.0	0.0	0.0	0		0				0	0	0	0
449471	SD	school	4605610	9001	Belle Fourche 09-1	460561000038	1	Belle Fourche HS	Regular School	Not applicable	High	09	12	2021	grade_1	0.0		0.0	0.0			0.0	0.0	0.0	0.0	0		0	0			0	0	0	0
449472	SD	school	4605610	9001	Belle Fourche 09-1	460561001117	7	Belle Fourche MS	Regular School	Not applicable	Middle	05	08	2021	grade_1	0.0	0.0	0.0	0.0			0.0	0.0	0.0	0.0	0	0	0	0			0	0	0	0
449473	SD	school	4605610	9001	Belle Fourche 09-1	460561000289	8	North Park Elementary	Regular School	Not applicable	Elementary	KG	KG	2021	grade_1	0.0		0.0	0.0			0.0	0.0	0.0	0.0	0		0	0			0	0	0	0
449474	SD	school	4605610	9001	Belle Fourche 09-1	460561000269	3	South Park Elementary	Regular School	Not applicable	Elementary	01	04	2021	grade_1	87.0		8.0	3.0			4.0	48.0	54.0	102.0	87		8	3			4	48	54	102
487893	SD	school	4605610	9001	Belle Fourche 09-1	460561001277	9	Belle Fourche Education Connection	Alternative School	Not applicable	High	09	12	2020	grade_1	0.0		0.0	0.0				0.0	0.0	0.0	0		0	0				0	0	0
487894	SD	school	4605610	9001	Belle Fourche 09-1	460561000038	1	Belle Fourche HS	Regular School	Not applicable	High	09	12	2020	grade_1	0.0		0.0	0.0	0.0		0.0	0.0	0.0	0.0	0		0	0	0		0	0	0	0
487895	SD	school	4605610	9001	Belle Fourche 09-1	460561001117	7	Belle Fourche MS	Regular School	Not applicable	Middle	05	08	2020	grade_1	0.0		0.0	0.0			0.0	0.0	0.0	0.0	0		0	0			0	0	0	0
487896	SD	school	4605610	9001	Belle Fourche 09-1	460561000289	8	North Park Elementary	Regular School	Not applicable	Elementary	KG	KG	2020	grade_1	0.0		0.0	0.0			0.0	0.0	0.0	0.0	0		0	0			0	0	0	0
487897	SD	school	4605610	9001	Belle Fourche 09-1	460561000269	3	South Park Elementary	Regular School	Not applicable	Elementary	01	04	2020	grade_1	80.0		10.0	6.0			7.0	51.0	52.0	103.0	80		10	6			7	51	52	103
2962150	SD	school	4605610	9001	Belle Fourche 09-1	460561001277	9	Belle Fourche Education Connection	Alternative Education School	No	3	09	12	2015	grade_1	0.0		0.0	0.0			0.0	0.0	0.0	0.0	0		0	0			0	0	0	0
2962151	SD	school	4605610	9001	Belle Fourche 09-1	460561000038	1	Belle Fourche HS	Regular School	No	3	09	12	2015	grade_1	0.0		0.0	0.0	0.0		0.0	0.0	0.0	0.0	0		0	0	0		0	0	0	0
2962152	SD	school	4605610	9001	Belle Fourche 09-1	460561001117	7	Belle Fourche MS	Regular School	No	2	05	08	2015	grade_1	0.0		0.0	0.0	0.0		0.0	0.0	0.0	0.0	0		0	0	0		0	0	0	0
2962153	SD	school	4605610	9001	Belle Fourche 09-1	460561000289	8	North Park Elementary	Regular School	No	1	KG	KG	2015	grade_1	0.0		0.0	0.0	0.0		0.0	0.0	0.0	0.0	0		0	0	0		0	0	0	0
2962154	SD	school	4605610	9001	Belle Fourche 09-1	460561000269	3	South Park Elementary	Regular School	No	1	01	04	2015	grade_1	89.0		7.0	0.0			6.0	59.0	43.0	102.0	89		7	0			6	59	43	102
3006790	SD	school	4605610	9001	Belle Fourche 09-1	460561001277	9	Belle Fourche Education Connection	Alternative School	No	High	09	12	2017	grade_1	0.0		0.0	0.0			0.0	0.0	0.0	0.0	0		0	0			0	0	0	0
3006791	SD	school	4605610	9001	Belle Fourche 09-1	460561000038	1	Belle Fourche HS	Regular School	No	High	09	12	2017	grade_1	0.0		0.0	0.0	0.0		0.0	0.0	0.0	0.0	0		0	0	0		0	0	0	0
3006792	SD	school	4605610	9001	Belle Fourche 09-1	460561001117	7	Belle Fourche MS	Regular School	No	Middle	05	08	2017	grade_1	0.0		0.0	0.0			0.0	0.0	0.0	0.0	0		0	0			0	0	0	0
3006793	SD	school	4605610	9001	Belle Fourche 09-1	460561000289	8	North Park Elementary	Regular School	No	Elementary	KG	KG	2017	grade_1	0.0		0.0	0.0			0.0	0.0	0.0	0.0	0		0	0			0	0	0	0
3006794	SD	school	4605610	9001	Belle Fourche 09-1	460561000269	3	South Park Elementary	Regular School	No	Elementary	01	04	2017	grade_1	80.0	0.0	6.0	1.0			3.0	49.0	41.0	90.0	80	0	6	1			3	49	41	90
3344702	SD	school	4605610	9001	Belle Fourche 09-1	460561001277	9	Belle Fourche Education Connection	Alternative Education School	No	3	09	12	2016	grade_1	0.0		0.0				0.0	0.0	0.0	0.0	0		0				0	0	0	0
3344703	SD	school	4605610	9001	Belle Fourche 09-1	460561000038	1	Belle Fourche HS	Regular School	No	3	09	12	2016	grade_1	0.0		0.0	0.0	0.0		0.0	0.0	0.0	0.0	0		0	0	0		0	0	0	0
3344704	SD	school	4605610	9001	Belle Fourche 09-1	460561001117	7	Belle Fourche MS	Regular School	No	2	05	08	2016	grade_1	0.0		0.0	0.0	0.0		0.0	0.0	0.0	0.0	0		0	0	0		0	0	0	0
3344705	SD	school	4605610	9001	Belle Fourche 09-1	460561000289	8	North Park Elementary	Regular School	No	1	KG	KG	2016	grade_1	0.0		0.0	0.0			0.0	0.0	0.0	0.0	0		0	0			0	0	0	0
3344706	SD	school	4605610	9001	Belle Fourche 09-1	460561000269	3	South Park Elementary	Regular School	No	1	01	04	2016	grade_1	98.0	0.0	7.0	3.0			6.0	62.0	52.0	114.0	98	0	7	3			6	62	52	114
254861	SD	school	4638220	7002	Kimball 07-2	463822000917	13	Grass Ranch Colony Elem	Regular School	No	Elementary	KG	08	2018	grade_1	7.0							5.0	2.0	7.0	7							5	2	7
254862	SD	school	4638220	7002	Kimball 07-2	463822001185	15	Grass Ranch Colony High School	Regular School	No	High	09	12	2018	grade_1	0.0							0.0	0.0	0.0	0							0	0	0
254863	SD	school	4638220	7002	Kimball 07-2	463822000354	2	Kimball Elementary	Regular School	No	Elementary	PK	04	2018	grade_1	14.0		0.0	0.0			0.0	7.0	7.0	14.0	14		0	0			0	7	7	14
254864	SD	school	4638220	7002	Kimball 07-2	463822000355	1	Kimball High School	Regular School	No	High	09	12	2018	grade_1	0.0		0.0	0.0			0.0	0.0	0.0	0.0	0		0	0			0	0	0	0
254865	SD	school	4638220	7002	Kimball 07-2	463822000142	4	Kimball Middle School	Regular School	No	Middle	05	08	2018	grade_1	0.0		0.0	0.0			0.0	0.0	0.0	0.0	0		0	0			0	0	0	0
362088	SD	school	4638220	7002	Kimball 07-2	463822000917	13	Grass Ranch Colony Elem	Regular School	No	Elementary	KG	08	2019	grade_1	3.0							1.0	2.0	3.0	3							1	2	3
362089	SD	school	4638220	7002	Kimball 07-2	463822001185	15	Grass Ranch Colony High School	Regular School	No	High	09	12	2019	grade_1	0.0							0.0	0.0	0.0	0							0	0	0
362090	SD	school	4638220	7002	Kimball 07-2	463822000354	2	Kimball Elementary	Regular School	No	Elementary	PK	04	2019	grade_1	23.0		1.0	0.0			0.0	11.0	13.0	24.0	23		1	0			0	11	13	24
362091	SD	school	4638220	7002	Kimball 07-2	463822000355	1	Kimball High School	Regular School	No	High	09	12	2019	grade_1	0.0		0.0	0.0			0.0	0.0	0.0	0.0	0		0	0			0	0	0	0
362092	SD	school	4638220	7002	Kimball 07-2	463822000142	4	Kimball Middle School	Regular School	No	Middle	05	08	2019	grade_1	0.0		0.0	0.0			0.0	0.0	0.0	0.0	0		0	0			0	0	0	0
453934	SD	school	4638220	7002	Kimball 07-2	463822000917	13	Grass Ranch Colony Elem	Regular School	Not applicable	Elementary	KG	08	2021	grade_1	2.0							2.0	0.0	2.0	2							2	0	2
453935	SD	school	4638220	7002	Kimball 07-2	463822001185	15	Grass Ranch Colony High School	Regular School	Not applicable	High	09	12	2021	grade_1	0.0							0.0	0.0	0.0	0							0	0	0
453936	SD	school	4638220	7002	Kimball 07-2	463822000354	2	Kimball Elementary	Regular School	Not applicable	Elementary	PK	04	2021	grade_1	21.0		1.0	1.0			1.0	10.0	14.0	24.0	21		1	1			1	10	14	24
453937	SD	school	4638220	7002	Kimball 07-2	463822000355	1	Kimball High School	Regular School	Not applicable	High	09	12	2021	grade_1	0.0		0.0				0.0	0.0	0.0	0.0	0		0				0	0	0	0
453938	SD	school	4638220	7002	Kimball 07-2	463822000142	4	Kimball Middle School	Regular School	Not applicable	Middle	05	08	2021	grade_1	0.0		0.0	0.0			0.0	0.0	0.0	0.0	0		0	0			0	0	0	0
492357	SD	school	4638220	7002	Kimball 07-2	463822000917	13	Grass Ranch Colony Elem	Regular School	Not applicable	Elementary	KG	08	2020	grade_1	6.0							4.0	2.0	6.0	6							4	2	6
492358	SD	school	4638220	7002	Kimball 07-2	463822001185	15	Grass Ranch Colony High School	Regular School	Not applicable	High	09	12	2020	grade_1	0.0							0.0	0.0	0.0	0							0	0	0
492359	SD	school	4638220	7002	Kimball 07-2	463822000354	2	Kimball Elementary	Regular School	Not applicable	Elementary	PK	04	2020	grade_1	12.0		0.0	1.0			2.0	11.0	4.0	15.0	12		0	1			2	11	4	15
492360	SD	school	4638220	7002	Kimball 07-2	463822000355	1	Kimball High School	Regular School	Not applicable	High	09	12	2020	grade_1	0.0		0.0	0.0			0.0	0.0	0.0	0.0	0		0	0			0	0	0	0
492361	SD	school	4638220	7002	Kimball 07-2	463822000142	4	Kimball Middle School	Regular School	Not applicable	Middle	05	08	2020	grade_1	0.0		0.0	0.0			0.0	0.0	0.0	0.0	0		0	0			0	0	0	0
2966582	SD	school	4638220	7002	Kimball 07-2	463822000917	13	Grass Ranch Colony Elem	Regular School	No	1	KG	08	2015	grade_1	5.0							2.0	3.0	5.0	5							2	3	5
2966583	SD	school	4638220	7002	Kimball 07-2	463822001185	15	Grass Ranch Colony High School	Regular School	No	3	09	12	2015	grade_1	0.0							0.0	0.0	0.0	0							0	0	0
2966584	SD	school	4638220	7002	Kimball 07-2	463822000354	2	Kimball Elementary	Regular School	No	1	PK	04	2015	grade_1	19.0		1.0	1.0			0.0	15.0	6.0	21.0	19		1	1			0	15	6	21
2966585	SD	school	4638220	7002	Kimball 07-2	463822000355	1	Kimball High School	Regular School	No	3	09	12	2015	grade_1	0.0		0.0	0.0	0.0		0.0	0.0	0.0	0.0	0		0	0	0		0	0	0	0
2966586	SD	school	4638220	7002	Kimball 07-2	463822000142	4	Kimball Middle School	Regular School	No	2	05	08	2015	grade_1	0.0		0.0	0.0			0.0	0.0	0.0	0.0	0		0	0			0	0	0	0
3011302	SD	school	4638220	7002	Kimball 07-2	463822000917	13	Grass Ranch Colony Elem	Regular School	No	Elementary	KG	08	2017	grade_1	5.0							5.0	0.0	5.0	5							5	0	5
3011303	SD	school	4638220	7002	Kimball 07-2	463822001185	15	Grass Ranch Colony High School	Regular School	No	High	09	12	2017	grade_1	0.0							0.0	0.0	0.0	0							0	0	0
3011304	SD	school	4638220	7002	Kimball 07-2	463822000354	2	Kimball Elementary	Regular School	No	Elementary	PK	04	2017	grade_1	21.0		2.0	0.0			0.0	17.0	6.0	23.0	21		2	0			0	17	6	23
3011305	SD	school	4638220	7002	Kimball 07-2	463822000355	1	Kimball High School	Regular School	No	High	09	12	2017	grade_1	0.0		0.0	0.0			0.0	0.0	0.0	0.0	0		0	0			0	0	0	0
3011306	SD	school	4638220	7002	Kimball 07-2	463822000142	4	Kimball Middle School	Regular School	No	Middle	05	08	2017	grade_1	0.0		0.0	0.0			0.0	0.0	0.0	0.0	0		0	0			0	0	0	0
3349166	SD	school	4638220	7002	Kimball 07-2	463822000917	13	Grass Ranch Colony Elem	Regular School	No	1	KG	08	2016	grade_1	3.0							1.0	2.0	3.0	3							1	2	3
3349167	SD	school	4638220	7002	Kimball 07-2	463822001185	15	Grass Ranch Colony High School	Regular School	No	3	09	12	2016	grade_1	0.0							0.0	0.0	0.0	0							0	0	0
3349168	SD	school	4638220	7002	Kimball 07-2	463822000354	2	Kimball Elementary	Regular School	No	1	PK	04	2016	grade_1	10.0		0.0	2.0			0.0	6.0	6.0	12.0	10		0	2			0	6	6	12
3349169	SD	school	4638220	7002	Kimball 07-2	463822000355	1	Kimball High School	Regular School	No	3	09	12	2016	grade_1	0.0		0.0	0.0			0.0	0.0	0.0	0.0	0		0	0			0	0	0	0
3349170	SD	school	4638220	7002	Kimball 07-2	463822000142	4	Kimball Middle School	Regular School	No	2	05	08	2016	grade_1	0.0		0.0	0.0			0.0	0.0	0.0	0.0	0		0	0			0	0	0	0
251405	SD	school	4612000	7001	Chamberlain 07-1	461200000118	3	Chamberlain Elementary School	Regular School	No	Elementary	KG	06	2018	grade_1	33.0		3.0	29.0		0.0	8.0	42.0	31.0	73.0	33		3	29		0	8	42	31	73
251406	SD	school	4612000	7001	Chamberlain 07-1	461200000119	1	Chamberlain High School	Regular School	No	High	09	12	2018	grade_1	0.0	0.0	0.0	0.0	0.0		0.0	0.0	0.0	0.0	0	0	0	0	0		0	0	0	0
251407	SD	school	4612000	7001	Chamberlain 07-1	461200000889	2	Chamberlain Jr. High	Regular School	No	Middle	07	08	2018	grade_1	0.0		0.0	0.0	0.0		0.0	0.0	0.0	0.0	0		0	0	0		0	0	0	0
358664	SD	school	4612000	7001	Chamberlain 07-1	461200000118	3	Chamberlain Elementary School	Regular School	No	Elementary	KG	05	2019	grade_1	36.0	0.0	1.0	30.0			5.0	43.0	29.0	72.0	36	0	1	30			5	43	29	72
358665	SD	school	4612000	7001	Chamberlain 07-1	461200000119	1	Chamberlain High School	Regular School	No	High	09	12	2019	grade_1	0.0	0.0	0.0	0.0	0.0		0.0	0.0	0.0	0.0	0	0	0	0	0		0	0	0	0
358666	SD	school	4612000	7001	Chamberlain 07-1	461200000889	2	Chamberlain Jr. High	Regular School	No	Middle	06	08	2019	grade_1	0.0		0.0	0.0	0.0		0.0	0.0	0.0	0.0	0		0	0	0		0	0	0	0
450510	SD	school	4612000	7001	Chamberlain 07-1	461200000118	3	Chamberlain Elementary School	Regular School	Not applicable	Elementary	KG	05	2021	grade_1	31.0	0.0	0.0	27.0	0.0		10.0	40.0	28.0	68.0	31	0	0	27	0		10	40	28	68
450511	SD	school	4612000	7001	Chamberlain 07-1	461200000119	1	Chamberlain High School	Regular School	Not applicable	High	09	12	2021	grade_1	0.0	0.0	0.0	0.0	0.0		0.0	0.0	0.0	0.0	0	0	0	0	0		0	0	0	0
450512	SD	school	4612000	7001	Chamberlain 07-1	461200000889	2	Chamberlain Jr. High	Regular School	Not applicable	Middle	06	08	2021	grade_1	0.0	0.0	0.0	0.0			0.0	0.0	0.0	0.0	0	0	0	0			0	0	0	0
488933	SD	school	4612000	7001	Chamberlain 07-1	461200000118	3	Chamberlain Elementary School	Regular School	Not applicable	Elementary	KG	05	2020	grade_1	28.0		2.0	24.0		0.0	7.0	27.0	34.0	61.0	28		2	24		0	7	27	34	61