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 (ccd_school_high_grade > :p3 or (ccd_school_high_grade = :p3 and rowid > :p2)) order by ccd_school_high_grade, 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	black	hispanic	native_american	asian	pacific_islander	multiracial	black_int	hispanic_int	native_american_int	asian_int	pacific_islander_int	multiracial_int
259414	SD	school	4674520	60006	Viborg-Hurley 60-6	467452000692	2	Viborg-Hurley Elementary	Regular School	No	Elementary	PK	04	2018	grade_11	0.0	0.0	0.0		0.0	0.0	0	0	0		0	0
259477	SD	school	4675420	11004	Wagner Community 11-4	467542000694	2	Wagner Elementary School	Regular School	No	Elementary	01	04	2018	grade_11		0.0	0.0			0.0		0	0			0
259661	SD	school	4676620	14004	Watertown 14-4	467662001083	9	Jefferson Elementary	Regular School	No	Elementary	KG	04	2018	grade_11	0.0	0.0	0.0	0.0		0.0	0	0	0	0		0
259662	SD	school	4676620	14004	Watertown 14-4	467662000944	5	Lincoln Elementary School	Regular School	No	Elementary	KG	04	2018	grade_11	0.0	0.0	0.0	0.0		0.0	0	0	0	0		0
259663	SD	school	4676620	14004	Watertown 14-4	467662000713	6	McKinley Elementary School	Regular School	No	Elementary	PK	04	2018	grade_11		0.0	0.0			0.0		0	0			0
259664	SD	school	4676620	14004	Watertown 14-4	467662000714	7	Mellette Elementary School	Regular School	No	Elementary	KG	04	2018	grade_11	0.0	0.0	0.0	0.0		0.0	0	0	0	0		0
259665	SD	school	4676620	14004	Watertown 14-4	467662000716	8	Roosevelt Elementary	Regular School	No	Elementary	PK	04	2018	grade_11	0.0	0.0	0.0	0.0	0.0	0.0	0	0	0	0	0	0
260371	SD	school	4680100	2006	Wolsey-Wessington 02-6	468010000783	2	Wolsey-Wessington Elementary	Regular School	No	Elementary	PK	04	2018	grade_11	0.0	0.0				0.0	0	0				0
357638	SD	school	4605610	9001	Belle Fourche 09-1	460561000269	3	South Park Elementary	Regular School	No	Elementary	01	04	2019	grade_11		0.0	0.0			0.0		0	0			0
358070	SD	school	4607950	49002	Brandon Valley 49-2	460795000414	3	Brandon Elem	Regular School	No	Elementary	PK	04	2019	grade_11	0.0	0.0	0.0	0.0	0.0	0.0	0	0	0	0	0	0
358074	SD	school	4607950	49002	Brandon Valley 49-2	460795001302	6	Fred Assam Elementary	Regular School	No	Elementary	KG	04	2019	grade_11	0.0	0.0		0.0		0.0	0	0		0		0
358075	SD	school	4607950	49002	Brandon Valley 49-2	460795001237	5	Robert Bennis Elementary	Regular School	No	Elementary	KG	04	2019	grade_11	0.0	0.0	0.0	0.0		0.0	0	0	0	0		0
358076	SD	school	4607950	49002	Brandon Valley 49-2	460795000073	4	Valley Springs Elem	Regular School	No	Elementary	KG	04	2019	grade_11		0.0				0.0		0				0
358836	SD	school	4612940	12002	Clark 12-2	461294000132	2	Clark Elementary School	Regular School	No	Elementary	PK	04	2019	grade_11	0.0	0.0				0.0	0	0				0
359262	SD	school	4618120	49003	Dell Rapids 49-3	461812000164	2	Dell Rapids Elementary	Regular School	No	Elementary	KG	04	2019	grade_11	0.0	0.0	0.0		0.0	0.0	0	0	0		0	0
360288	SD	school	4624390	50003	Flandreau 50-3	462439000207	4	Flandreau Elem	Regular School	No	Elementary	KG	04	2019	grade_11		0.0	0.0	0.0	0.0	0.0		0	0	0	0	0
361198	SD	school	4632340	14002	Henry 14-2	463234000275	2	Henry Elementary	Regular School	No	Elementary	PK	04	2019	grade_11				0.0						0
361950	SD	school	4619580	37003	Jones County 37-3	461958000358	2	Jones County Elem	Regular School	No	Elementary	KG	04	2019	grade_11		0.0	0.0			0.0		0	0			0
362100	SD	school	4638220	7002	Kimball 07-2	463822000354	2	Kimball Elementary	Regular School	No	Elementary	PK	04	2019	grade_11		0.0	0.0			0.0		0	0			0
362402	SD	school	4641550	41004	Lennox 41-4	464155000386	2	Lennox Elementary	Regular School	No	Elementary	PK	04	2019	grade_11	0.0	0.0	0.0	0.0		0.0	0	0	0	0		0
362406	SD	school	4641550	41004	Lennox 41-4	464155000389	5	Worthing Elem	Regular School	No	Elementary	PK	04	2019	grade_11		0.0	0.0			0.0		0	0			0
362737	SD	school	4601026	43007	McCook Central 43-7	460102600404	2	McCook Central Elementary	Regular School	No	Elementary	PK	04	2019	grade_11		0.0				0.0		0				0
362917	SD	school	4669930	46001	Meade 46-1	466993000644	5	Piedmont Valley Elementary	Regular School	No	Elementary	KG	04	2019	grade_11	0.0	0.0	0.0	0.0		0.0	0	0	0	0		0
362920	SD	school	4669930	46001	Meade 46-1	466993000637	3	Sturgis Elementary	Regular School	No	Elementary	KG	04	2019	grade_11	0.0	0.0	0.0	0.0	0.0	0.0	0	0	0	0	0	0
366144	SD	school	4600052	41005	Tea Area 41-5	460005201358	5	Tea Area Frontier Elementary	Regular School	No	Elementary	KG	04	2019	grade_11	0.0	0.0		0.0		0.0	0	0		0		0
366146	SD	school	4600052	41005	Tea Area 41-5	460005200388	1	Tea Area Legacy Elementary	Regular School	No	Elementary	KG	04	2019	grade_11	0.0	0.0	0.0			0.0	0	0	0			0
366641	SD	school	4674520	60006	Viborg-Hurley 60-6	467452000692	2	Viborg-Hurley Elementary	Regular School	No	Elementary	PK	04	2019	grade_11	0.0	0.0	0.0			0.0	0	0	0			0
366704	SD	school	4675420	11004	Wagner Community 11-4	467542000694	2	Wagner Elementary School	Regular School	No	Elementary	01	04	2019	grade_11		0.0	0.0			0.0		0	0			0
366888	SD	school	4676620	14004	Watertown 14-4	467662001083	9	Jefferson Elementary	Regular School	No	Elementary	KG	04	2019	grade_11	0.0	0.0	0.0	0.0		0.0	0	0	0	0		0
366889	SD	school	4676620	14004	Watertown 14-4	467662000944	5	Lincoln Elementary School	Regular School	No	Elementary	KG	04	2019	grade_11	0.0	0.0	0.0	0.0		0.0	0	0	0	0		0
366890	SD	school	4676620	14004	Watertown 14-4	467662000713	6	McKinley Elementary School	Regular School	No	Elementary	PK	04	2019	grade_11	0.0	0.0	0.0	0.0		0.0	0	0	0	0		0
366891	SD	school	4676620	14004	Watertown 14-4	467662000714	7	Mellette Elementary School	Regular School	No	Elementary	KG	04	2019	grade_11		0.0	0.0	0.0		0.0		0	0	0		0
366892	SD	school	4676620	14004	Watertown 14-4	467662000716	8	Roosevelt Elementary	Regular School	No	Elementary	PK	04	2019	grade_11	0.0	0.0	0.0	0.0		0.0	0	0	0	0		0
367630	SD	school	4680100	2006	Wolsey-Wessington 02-6	468010000783	2	Wolsey-Wessington Elementary	Regular School	No	Elementary	PK	04	2019	grade_11	0.0	0.0	0.0			0.0	0	0	0			0
449078	SD	school	4600042	58003	Agar-Blunt-Onida 58-3	460004200855	3	Blunt Elementary	Regular School	Not applicable	Elementary	PK	04	2021	grade_11		0.0	0.0			0.0		0	0			0
449484	SD	school	4605610	9001	Belle Fourche 09-1	460561000269	3	South Park Elementary	Regular School	Not applicable	Elementary	01	04	2021	grade_11		0.0	0.0			0.0		0	0			0
449916	SD	school	4607950	49002	Brandon Valley 49-2	460795000414	3	Brandon Elem	Regular School	Not applicable	Elementary	PK	04	2021	grade_11	0.0	0.0	0.0	0.0	0.0	0.0	0	0	0	0	0	0
449920	SD	school	4607950	49002	Brandon Valley 49-2	460795001302	6	Fred Assam Elementary	Regular School	Not applicable	Elementary	KG	04	2021	grade_11	0.0	0.0	0.0	0.0	0.0	0.0	0	0	0	0	0	0
449921	SD	school	4607950	49002	Brandon Valley 49-2	460795001237	5	Robert Bennis Elementary	Regular School	Not applicable	Elementary	KG	04	2021	grade_11	0.0	0.0	0.0	0.0		0.0	0	0	0	0		0
449922	SD	school	4607950	49002	Brandon Valley 49-2	460795000073	4	Valley Springs Elem	Regular School	Not applicable	Elementary	KG	04	2021	grade_11		0.0	0.0			0.0		0	0			0
450682	SD	school	4612940	12002	Clark 12-2	461294000132	2	Clark Elementary School	Regular School	Not applicable	Elementary	PK	04	2021	grade_11	0.0	0.0				0.0	0	0				0
451108	SD	school	4618120	49003	Dell Rapids 49-3	461812000164	2	Dell Rapids Elementary	Regular School	Not applicable	Elementary	KG	04	2021	grade_11	0.0	0.0	0.0		0.0	0.0	0	0	0		0	0
452134	SD	school	4624390	50003	Flandreau 50-3	462439000207	4	Flandreau Elem	Regular School	Not applicable	Elementary	KG	04	2021	grade_11		0.0	0.0	0.0	0.0	0.0		0	0	0	0	0
453796	SD	school	4619580	37003	Jones County 37-3	461958000358	2	Jones County Elem	Regular School	Not applicable	Elementary	KG	04	2021	grade_11		0.0	0.0			0.0		0	0			0
453946	SD	school	4638220	7002	Kimball 07-2	463822000354	2	Kimball Elementary	Regular School	Not applicable	Elementary	PK	04	2021	grade_11		0.0	0.0			0.0		0	0			0
454248	SD	school	4641550	41004	Lennox 41-4	464155000386	2	Lennox Elementary	Regular School	Not applicable	Elementary	PK	04	2021	grade_11	0.0	0.0	0.0	0.0		0.0	0	0	0	0		0
454252	SD	school	4641550	41004	Lennox 41-4	464155000389	5	Worthing Elem	Regular School	Not applicable	Elementary	PK	04	2021	grade_11		0.0	0.0	0.0				0	0	0
454583	SD	school	4601026	43007	McCook Central 43-7	460102600404	2	McCook Central Elementary	Regular School	Not applicable	Elementary	PK	04	2021	grade_11		0.0				0.0		0				0
454763	SD	school	4669930	46001	Meade 46-1	466993000644	5	Piedmont Valley Elementary	Regular School	Not applicable	Elementary	KG	04	2021	grade_11	0.0	0.0	0.0	0.0		0.0	0	0	0	0		0
454766	SD	school	4669930	46001	Meade 46-1	466993000637	3	Sturgis Elementary	Regular School	Not applicable	Elementary	KG	04	2021	grade_11	0.0	0.0	0.0	0.0		0.0	0	0	0	0		0
457670	SD	school	4600053	54002	Sisseton 54-2	460005301241	3	Westside Elementary School	Regular School	Not applicable	Elementary	PK	04	2021	grade_11	0.0	0.0	0.0	0.0		0.0	0	0	0	0		0
458519	SD	school	4674520	60006	Viborg-Hurley 60-6	467452000692	2	Viborg-Hurley Elementary	Regular School	Not applicable	Elementary	PK	04	2021	grade_11	0.0	0.0	0.0			0.0	0	0	0			0
458583	SD	school	4675420	11004	Wagner Community 11-4	467542000694	2	Wagner Elementary School	Regular School	Not applicable	Elementary	KG	04	2021	grade_11	0.0	0.0	0.0		0.0	0.0	0	0	0		0	0
458769	SD	school	4676620	14004	Watertown 14-4	467662001083	9	Jefferson Elementary	Regular School	Not applicable	Elementary	KG	04	2021	grade_11	0.0	0.0	0.0	0.0		0.0	0	0	0	0		0
458770	SD	school	4676620	14004	Watertown 14-4	467662000944	5	Lincoln Elementary School	Regular School	Not applicable	Elementary	KG	04	2021	grade_11	0.0	0.0	0.0	0.0		0.0	0	0	0	0		0
458771	SD	school	4676620	14004	Watertown 14-4	467662000713	6	McKinley Elementary School	Regular School	Not applicable	Elementary	PK	04	2021	grade_11		0.0	0.0			0.0		0	0			0
458772	SD	school	4676620	14004	Watertown 14-4	467662000714	7	Mellette Elementary School	Regular School	Not applicable	Elementary	KG	04	2021	grade_11		0.0	0.0	0.0		0.0		0	0	0		0
458773	SD	school	4676620	14004	Watertown 14-4	467662000716	8	Roosevelt Elementary	Regular School	Not applicable	Elementary	PK	04	2021	grade_11		0.0	0.0			0.0		0	0			0
487907	SD	school	4605610	9001	Belle Fourche 09-1	460561000269	3	South Park Elementary	Regular School	Not applicable	Elementary	01	04	2020	grade_11		0.0	0.0			0.0		0	0			0
488339	SD	school	4607950	49002	Brandon Valley 49-2	460795000414	3	Brandon Elem	Regular School	Not applicable	Elementary	PK	04	2020	grade_11	0.0	0.0	0.0	0.0	0.0	0.0	0	0	0	0	0	0
488343	SD	school	4607950	49002	Brandon Valley 49-2	460795001302	6	Fred Assam Elementary	Regular School	Not applicable	Elementary	KG	04	2020	grade_11	0.0	0.0		0.0	0.0	0.0	0	0		0	0	0
488344	SD	school	4607950	49002	Brandon Valley 49-2	460795001237	5	Robert Bennis Elementary	Regular School	Not applicable	Elementary	KG	04	2020	grade_11	0.0	0.0	0.0	0.0		0.0	0	0	0	0		0
488345	SD	school	4607950	49002	Brandon Valley 49-2	460795000073	4	Valley Springs Elem	Regular School	Not applicable	Elementary	KG	04	2020	grade_11		0.0	0.0			0.0		0	0			0
489105	SD	school	4612940	12002	Clark 12-2	461294000132	2	Clark Elementary School	Regular School	Not applicable	Elementary	PK	04	2020	grade_11	0.0	0.0				0.0	0	0				0
489531	SD	school	4618120	49003	Dell Rapids 49-3	461812000164	2	Dell Rapids Elementary	Regular School	Not applicable	Elementary	KG	04	2020	grade_11	0.0	0.0	0.0		0.0	0.0	0	0	0		0	0
490557	SD	school	4624390	50003	Flandreau 50-3	462439000207	4	Flandreau Elem	Regular School	Not applicable	Elementary	KG	04	2020	grade_11		0.0	0.0	0.0	0.0	0.0		0	0	0	0	0
492219	SD	school	4619580	37003	Jones County 37-3	461958000358	2	Jones County Elem	Regular School	Not applicable	Elementary	KG	04	2020	grade_11		0.0	0.0			0.0		0	0			0
492369	SD	school	4638220	7002	Kimball 07-2	463822000354	2	Kimball Elementary	Regular School	Not applicable	Elementary	PK	04	2020	grade_11		0.0	0.0			0.0		0	0			0
492671	SD	school	4641550	41004	Lennox 41-4	464155000386	2	Lennox Elementary	Regular School	Not applicable	Elementary	PK	04	2020	grade_11	0.0	0.0	0.0	0.0		0.0	0	0	0	0		0
492675	SD	school	4641550	41004	Lennox 41-4	464155000389	5	Worthing Elem	Regular School	Not applicable	Elementary	PK	04	2020	grade_11		0.0	0.0	0.0		0.0		0	0	0		0
493006	SD	school	4601026	43007	McCook Central 43-7	460102600404	2	McCook Central Elementary	Regular School	Not applicable	Elementary	PK	04	2020	grade_11		0.0				0.0		0				0
493186	SD	school	4669930	46001	Meade 46-1	466993000644	5	Piedmont Valley Elementary	Regular School	Not applicable	Elementary	KG	04	2020	grade_11	0.0	0.0	0.0	0.0		0.0	0	0	0	0		0
493189	SD	school	4669930	46001	Meade 46-1	466993000637	3	Sturgis Elementary	Regular School	Not applicable	Elementary	KG	04	2020	grade_11	0.0	0.0	0.0	0.0		0.0	0	0	0	0		0
496942	SD	school	4674520	60006	Viborg-Hurley 60-6	467452000692	2	Viborg-Hurley Elementary	Regular School	Not applicable	Elementary	PK	04	2020	grade_11	0.0	0.0	0.0			0.0	0	0	0			0
497006	SD	school	4675420	11004	Wagner Community 11-4	467542000694	2	Wagner Elementary School	Regular School	Not applicable	Elementary	KG	04	2020	grade_11		0.0	0.0		0.0	0.0		0	0		0	0
497189	SD	school	4676620	14004	Watertown 14-4	467662001083	9	Jefferson Elementary	Regular School	Not applicable	Elementary	KG	04	2020	grade_11	0.0	0.0	0.0	0.0		0.0	0	0	0	0		0
497190	SD	school	4676620	14004	Watertown 14-4	467662000944	5	Lincoln Elementary School	Regular School	Not applicable	Elementary	KG	04	2020	grade_11		0.0	0.0	0.0		0.0		0	0	0		0
497191	SD	school	4676620	14004	Watertown 14-4	467662000713	6	McKinley Elementary School	Regular School	Not applicable	Elementary	PK	04	2020	grade_11	0.0	0.0	0.0	0.0		0.0	0	0	0	0		0
497192	SD	school	4676620	14004	Watertown 14-4	467662000714	7	Mellette Elementary School	Regular School	Not applicable	Elementary	KG	04	2020	grade_11		0.0	0.0	0.0		0.0		0	0	0		0
497193	SD	school	4676620	14004	Watertown 14-4	467662000716	8	Roosevelt Elementary	Regular School	Not applicable	Elementary	PK	04	2020	grade_11		0.0	0.0			0.0		0	0			0
497931	SD	school	4680100	2006	Wolsey-Wessington 02-6	468010000783	2	Wolsey-Wessington Elementary	Regular School	Not applicable	Elementary	PK	04	2020	grade_11	0.0	0.0				0.0	0	0				0
2961996	SD	school	4603780	21001	Armour 21-1	460378000023	2	Armour Elementary	Regular School	No	1	PK	04	2015	grade_11	0.0		0.0			0.0	0		0			0
2962164	SD	school	4605610	9001	Belle Fourche 09-1	460561000269	3	South Park Elementary	Regular School	No	1	01	04	2015	grade_11		0.0	0.0			0.0		0	0			0
2963116	SD	school	4611760	60001	Centerville 60-1	461176000115	2	Centerville Elem	Regular School	No	1	PK	04	2015	grade_11	0.0	0.0				0.0	0	0				0
2963314	SD	school	4612940	12002	Clark 12-2	461294000132	2	Clark Elementary School	Regular School	No	1	PK	04	2015	grade_11	0.0	0.0			0.0		0	0			0
2963614	SD	school	4636990	61008	Dakota Valley 61-8	463699000251	2	Dakota Valley Elementary School	Regular School	No	1	KG	04	2015	grade_11	0.0	0.0	0.0	0.0	0.0	0.0	0	0	0	0	0	0
2963724	SD	school	4618120	49003	Dell Rapids 49-3	461812000164	2	Dell Rapids Elementary	Regular School	No	1	KG	04	2015	grade_11		0.0	0.0			0.0		0	0			0
2966460	SD	school	4619580	37003	Jones County 37-3	461958000358	2	Jones County Elem	Regular School	No	1	KG	04	2015	grade_11	0.0	0.0	0.0			0.0	0	0	0			0
2966594	SD	school	4638220	7002	Kimball 07-2	463822000354	2	Kimball Elementary	Regular School	No	1	PK	04	2015	grade_11		0.0	0.0			0.0		0	0			0
2967215	SD	school	4601026	43007	McCook Central 43-7	460102600404	2	McCook Central Elementary	Regular School	No	1	PK	04	2015	grade_11	0.0	0.0				0.0	0	0				0
2971199	SD	school	4674520	60006	Viborg-Hurley 60-6	467452000692	2	Viborg-Hurley Elementary	Regular School	No	1	PK	04	2015	grade_11	0.0	0.0		0.0	0.0	0.0	0	0		0	0	0
2971262	SD	school	4675420	11004	Wagner Community 11-4	467542000694	2	Wagner Elementary School	Regular School	No	1	01	04	2015	grade_11		0.0	0.0			0.0		0	0			0
3006804	SD	school	4605610	9001	Belle Fourche 09-1	460561000269	3	South Park Elementary	Regular School	No	Elementary	01	04	2017	grade_11	0.0	0.0	0.0			0.0	0	0	0			0
3007220	SD	school	4607950	49002	Brandon Valley 49-2	460795000414	3	Brandon Elem	Regular School	No	Elementary	PK	04	2017	grade_11	0.0	0.0	0.0	0.0	0.0	0.0	0	0	0	0	0	0
3007224	SD	school	4607950	49002	Brandon Valley 49-2	460795001302	6	Fred Assam Elementary	Regular School	No	Elementary	KG	04	2017	grade_11	0.0	0.0	0.0	0.0		0.0	0	0	0	0		0
3007225	SD	school	4607950	49002	Brandon Valley 49-2	460795001237	5	Robert Bennis Elementary	Regular School	No	Elementary	KG	04	2017	grade_11	0.0	0.0		0.0		0.0	0	0		0		0
3007226	SD	school	4607950	49002	Brandon Valley 49-2	460795000073	4	Valley Springs Elem	Regular School	No	Elementary	KG	04	2017	grade_11	0.0	0.0				0.0	0	0				0
3007986	SD	school	4612940	12002	Clark 12-2	461294000132	2	Clark Elementary School	Regular School	No	Elementary	PK	04	2017	grade_11	0.0	0.0	0.0			0.0	0	0	0			0
3008412	SD	school	4618120	49003	Dell Rapids 49-3	461812000164	2	Dell Rapids Elementary	Regular School	No	Elementary	KG	04	2017	grade_11		0.0	0.0			0.0		0	0			0
3010428	SD	school	4632340	14002	Henry 14-2	463234000275	2	Henry Elementary	Regular School	No	Elementary	PK	04	2017	grade_11				0.0						0
3011180	SD	school	4619580	37003	Jones County 37-3	461958000358	2	Jones County Elem	Regular School	No	Elementary	KG	04	2017	grade_11		0.0	0.0			0.0		0	0			0