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
259410	SD	school	4674520	60006	Viborg-Hurley 60-6	467452000692	2	Viborg-Hurley Elementary	Regular School	No	Elementary	PK	04	2018	grade_10	0.0	0.0	0.0		0.0	0.0	0	0	0		0	0
259473	SD	school	4675420	11004	Wagner Community 11-4	467542000694	2	Wagner Elementary School	Regular School	No	Elementary	01	04	2018	grade_10		0.0	0.0			0.0		0	0			0
259653	SD	school	4676620	14004	Watertown 14-4	467662001083	9	Jefferson Elementary	Regular School	No	Elementary	KG	04	2018	grade_10	0.0	0.0	0.0	0.0		0.0	0	0	0	0		0
259654	SD	school	4676620	14004	Watertown 14-4	467662000944	5	Lincoln Elementary School	Regular School	No	Elementary	KG	04	2018	grade_10	0.0	0.0	0.0	0.0		0.0	0	0	0	0		0
259655	SD	school	4676620	14004	Watertown 14-4	467662000713	6	McKinley Elementary School	Regular School	No	Elementary	PK	04	2018	grade_10		0.0	0.0			0.0		0	0			0
259656	SD	school	4676620	14004	Watertown 14-4	467662000714	7	Mellette Elementary School	Regular School	No	Elementary	KG	04	2018	grade_10	0.0	0.0	0.0	0.0		0.0	0	0	0	0		0
259657	SD	school	4676620	14004	Watertown 14-4	467662000716	8	Roosevelt Elementary	Regular School	No	Elementary	PK	04	2018	grade_10	0.0	0.0	0.0	0.0	0.0	0.0	0	0	0	0	0	0
260368	SD	school	4680100	2006	Wolsey-Wessington 02-6	468010000783	2	Wolsey-Wessington Elementary	Regular School	No	Elementary	PK	04	2018	grade_10	0.0	0.0				0.0	0	0				0
357633	SD	school	4605610	9001	Belle Fourche 09-1	460561000269	3	South Park Elementary	Regular School	No	Elementary	01	04	2019	grade_10		0.0	0.0			0.0		0	0			0
358063	SD	school	4607950	49002	Brandon Valley 49-2	460795000414	3	Brandon Elem	Regular School	No	Elementary	PK	04	2019	grade_10	0.0	0.0	0.0	0.0	0.0	0.0	0	0	0	0	0	0
358067	SD	school	4607950	49002	Brandon Valley 49-2	460795001302	6	Fred Assam Elementary	Regular School	No	Elementary	KG	04	2019	grade_10	0.0	0.0		0.0		0.0	0	0		0		0
358068	SD	school	4607950	49002	Brandon Valley 49-2	460795001237	5	Robert Bennis Elementary	Regular School	No	Elementary	KG	04	2019	grade_10	0.0	0.0	0.0	0.0		0.0	0	0	0	0		0
358069	SD	school	4607950	49002	Brandon Valley 49-2	460795000073	4	Valley Springs Elem	Regular School	No	Elementary	KG	04	2019	grade_10		0.0				0.0		0				0
358830	SD	school	4612940	12002	Clark 12-2	461294000132	2	Clark Elementary School	Regular School	No	Elementary	PK	04	2019	grade_10	0.0	0.0				0.0	0	0				0
359259	SD	school	4618120	49003	Dell Rapids 49-3	461812000164	2	Dell Rapids Elementary	Regular School	No	Elementary	KG	04	2019	grade_10	0.0	0.0	0.0		0.0	0.0	0	0	0		0	0
360284	SD	school	4624390	50003	Flandreau 50-3	462439000207	4	Flandreau Elem	Regular School	No	Elementary	KG	04	2019	grade_10		0.0	0.0	0.0	0.0	0.0		0	0	0	0	0
361195	SD	school	4632340	14002	Henry 14-2	463234000275	2	Henry Elementary	Regular School	No	Elementary	PK	04	2019	grade_10				0.0						0
361947	SD	school	4619580	37003	Jones County 37-3	461958000358	2	Jones County Elem	Regular School	No	Elementary	KG	04	2019	grade_10		0.0	0.0			0.0		0	0			0
362095	SD	school	4638220	7002	Kimball 07-2	463822000354	2	Kimball Elementary	Regular School	No	Elementary	PK	04	2019	grade_10		0.0	0.0			0.0		0	0			0
362397	SD	school	4641550	41004	Lennox 41-4	464155000386	2	Lennox Elementary	Regular School	No	Elementary	PK	04	2019	grade_10	0.0	0.0	0.0	0.0		0.0	0	0	0	0		0
362401	SD	school	4641550	41004	Lennox 41-4	464155000389	5	Worthing Elem	Regular School	No	Elementary	PK	04	2019	grade_10		0.0	0.0			0.0		0	0			0
362733	SD	school	4601026	43007	McCook Central 43-7	460102600404	2	McCook Central Elementary	Regular School	No	Elementary	PK	04	2019	grade_10		0.0				0.0		0				0
362905	SD	school	4669930	46001	Meade 46-1	466993000644	5	Piedmont Valley Elementary	Regular School	No	Elementary	KG	04	2019	grade_10	0.0	0.0	0.0	0.0		0.0	0	0	0	0		0
362908	SD	school	4669930	46001	Meade 46-1	466993000637	3	Sturgis Elementary	Regular School	No	Elementary	KG	04	2019	grade_10	0.0	0.0	0.0	0.0	0.0	0.0	0	0	0	0	0	0
366140	SD	school	4600052	41005	Tea Area 41-5	460005201358	5	Tea Area Frontier Elementary	Regular School	No	Elementary	KG	04	2019	grade_10	0.0	0.0		0.0		0.0	0	0		0		0
366142	SD	school	4600052	41005	Tea Area 41-5	460005200388	1	Tea Area Legacy Elementary	Regular School	No	Elementary	KG	04	2019	grade_10	0.0	0.0	0.0			0.0	0	0	0			0
366637	SD	school	4674520	60006	Viborg-Hurley 60-6	467452000692	2	Viborg-Hurley Elementary	Regular School	No	Elementary	PK	04	2019	grade_10	0.0	0.0	0.0			0.0	0	0	0			0
366700	SD	school	4675420	11004	Wagner Community 11-4	467542000694	2	Wagner Elementary School	Regular School	No	Elementary	01	04	2019	grade_10		0.0	0.0			0.0		0	0			0
366880	SD	school	4676620	14004	Watertown 14-4	467662001083	9	Jefferson Elementary	Regular School	No	Elementary	KG	04	2019	grade_10	0.0	0.0	0.0	0.0		0.0	0	0	0	0		0
366881	SD	school	4676620	14004	Watertown 14-4	467662000944	5	Lincoln Elementary School	Regular School	No	Elementary	KG	04	2019	grade_10	0.0	0.0	0.0	0.0		0.0	0	0	0	0		0
366882	SD	school	4676620	14004	Watertown 14-4	467662000713	6	McKinley Elementary School	Regular School	No	Elementary	PK	04	2019	grade_10	0.0	0.0	0.0	0.0		0.0	0	0	0	0		0
366883	SD	school	4676620	14004	Watertown 14-4	467662000714	7	Mellette Elementary School	Regular School	No	Elementary	KG	04	2019	grade_10		0.0	0.0	0.0		0.0		0	0	0		0
366884	SD	school	4676620	14004	Watertown 14-4	467662000716	8	Roosevelt Elementary	Regular School	No	Elementary	PK	04	2019	grade_10	0.0	0.0	0.0	0.0		0.0	0	0	0	0		0
367627	SD	school	4680100	2006	Wolsey-Wessington 02-6	468010000783	2	Wolsey-Wessington Elementary	Regular School	No	Elementary	PK	04	2019	grade_10	0.0	0.0	0.0			0.0	0	0	0			0
449074	SD	school	4600042	58003	Agar-Blunt-Onida 58-3	460004200855	3	Blunt Elementary	Regular School	Not applicable	Elementary	PK	04	2021	grade_10		0.0	0.0			0.0		0	0			0
449479	SD	school	4605610	9001	Belle Fourche 09-1	460561000269	3	South Park Elementary	Regular School	Not applicable	Elementary	01	04	2021	grade_10		0.0	0.0			0.0		0	0			0
449909	SD	school	4607950	49002	Brandon Valley 49-2	460795000414	3	Brandon Elem	Regular School	Not applicable	Elementary	PK	04	2021	grade_10	0.0	0.0	0.0	0.0	0.0	0.0	0	0	0	0	0	0
449913	SD	school	4607950	49002	Brandon Valley 49-2	460795001302	6	Fred Assam Elementary	Regular School	Not applicable	Elementary	KG	04	2021	grade_10	0.0	0.0	0.0	0.0	0.0	0.0	0	0	0	0	0	0
449914	SD	school	4607950	49002	Brandon Valley 49-2	460795001237	5	Robert Bennis Elementary	Regular School	Not applicable	Elementary	KG	04	2021	grade_10	0.0	0.0	0.0	0.0		0.0	0	0	0	0		0
449915	SD	school	4607950	49002	Brandon Valley 49-2	460795000073	4	Valley Springs Elem	Regular School	Not applicable	Elementary	KG	04	2021	grade_10		0.0	0.0			0.0		0	0			0
450676	SD	school	4612940	12002	Clark 12-2	461294000132	2	Clark Elementary School	Regular School	Not applicable	Elementary	PK	04	2021	grade_10	0.0	0.0				0.0	0	0				0
451105	SD	school	4618120	49003	Dell Rapids 49-3	461812000164	2	Dell Rapids Elementary	Regular School	Not applicable	Elementary	KG	04	2021	grade_10	0.0	0.0	0.0		0.0	0.0	0	0	0		0	0
452130	SD	school	4624390	50003	Flandreau 50-3	462439000207	4	Flandreau Elem	Regular School	Not applicable	Elementary	KG	04	2021	grade_10		0.0	0.0	0.0	0.0	0.0		0	0	0	0	0
453793	SD	school	4619580	37003	Jones County 37-3	461958000358	2	Jones County Elem	Regular School	Not applicable	Elementary	KG	04	2021	grade_10		0.0	0.0			0.0		0	0			0
453941	SD	school	4638220	7002	Kimball 07-2	463822000354	2	Kimball Elementary	Regular School	Not applicable	Elementary	PK	04	2021	grade_10		0.0	0.0			0.0		0	0			0
454243	SD	school	4641550	41004	Lennox 41-4	464155000386	2	Lennox Elementary	Regular School	Not applicable	Elementary	PK	04	2021	grade_10	0.0	0.0	0.0	0.0		0.0	0	0	0	0		0
454247	SD	school	4641550	41004	Lennox 41-4	464155000389	5	Worthing Elem	Regular School	Not applicable	Elementary	PK	04	2021	grade_10		0.0	0.0	0.0				0	0	0
454579	SD	school	4601026	43007	McCook Central 43-7	460102600404	2	McCook Central Elementary	Regular School	Not applicable	Elementary	PK	04	2021	grade_10		0.0				0.0		0				0
454751	SD	school	4669930	46001	Meade 46-1	466993000644	5	Piedmont Valley Elementary	Regular School	Not applicable	Elementary	KG	04	2021	grade_10	0.0	0.0	0.0	0.0		0.0	0	0	0	0		0
454754	SD	school	4669930	46001	Meade 46-1	466993000637	3	Sturgis Elementary	Regular School	Not applicable	Elementary	KG	04	2021	grade_10	0.0	0.0	0.0	0.0		0.0	0	0	0	0		0
457667	SD	school	4600053	54002	Sisseton 54-2	460005301241	3	Westside Elementary School	Regular School	Not applicable	Elementary	PK	04	2021	grade_10	0.0	0.0	0.0	0.0		0.0	0	0	0	0		0
458515	SD	school	4674520	60006	Viborg-Hurley 60-6	467452000692	2	Viborg-Hurley Elementary	Regular School	Not applicable	Elementary	PK	04	2021	grade_10	0.0	0.0	0.0			0.0	0	0	0			0
458579	SD	school	4675420	11004	Wagner Community 11-4	467542000694	2	Wagner Elementary School	Regular School	Not applicable	Elementary	KG	04	2021	grade_10	0.0	0.0	0.0		0.0	0.0	0	0	0		0	0
458760	SD	school	4676620	14004	Watertown 14-4	467662001083	9	Jefferson Elementary	Regular School	Not applicable	Elementary	KG	04	2021	grade_10	0.0	0.0	0.0	0.0		0.0	0	0	0	0		0
458761	SD	school	4676620	14004	Watertown 14-4	467662000944	5	Lincoln Elementary School	Regular School	Not applicable	Elementary	KG	04	2021	grade_10	0.0	0.0	0.0	0.0		0.0	0	0	0	0		0
458762	SD	school	4676620	14004	Watertown 14-4	467662000713	6	McKinley Elementary School	Regular School	Not applicable	Elementary	PK	04	2021	grade_10		0.0	0.0			0.0		0	0			0
458763	SD	school	4676620	14004	Watertown 14-4	467662000714	7	Mellette Elementary School	Regular School	Not applicable	Elementary	KG	04	2021	grade_10		0.0	0.0	0.0		0.0		0	0	0		0
458764	SD	school	4676620	14004	Watertown 14-4	467662000716	8	Roosevelt Elementary	Regular School	Not applicable	Elementary	PK	04	2021	grade_10		0.0	0.0			0.0		0	0			0
487902	SD	school	4605610	9001	Belle Fourche 09-1	460561000269	3	South Park Elementary	Regular School	Not applicable	Elementary	01	04	2020	grade_10		0.0	0.0			0.0		0	0			0
488332	SD	school	4607950	49002	Brandon Valley 49-2	460795000414	3	Brandon Elem	Regular School	Not applicable	Elementary	PK	04	2020	grade_10	0.0	0.0	0.0	0.0	0.0	0.0	0	0	0	0	0	0
488336	SD	school	4607950	49002	Brandon Valley 49-2	460795001302	6	Fred Assam Elementary	Regular School	Not applicable	Elementary	KG	04	2020	grade_10	0.0	0.0		0.0	0.0	0.0	0	0		0	0	0
488337	SD	school	4607950	49002	Brandon Valley 49-2	460795001237	5	Robert Bennis Elementary	Regular School	Not applicable	Elementary	KG	04	2020	grade_10	0.0	0.0	0.0	0.0		0.0	0	0	0	0		0
488338	SD	school	4607950	49002	Brandon Valley 49-2	460795000073	4	Valley Springs Elem	Regular School	Not applicable	Elementary	KG	04	2020	grade_10		0.0	0.0			0.0		0	0			0
489099	SD	school	4612940	12002	Clark 12-2	461294000132	2	Clark Elementary School	Regular School	Not applicable	Elementary	PK	04	2020	grade_10	0.0	0.0				0.0	0	0				0
489528	SD	school	4618120	49003	Dell Rapids 49-3	461812000164	2	Dell Rapids Elementary	Regular School	Not applicable	Elementary	KG	04	2020	grade_10	0.0	0.0	0.0		0.0	0.0	0	0	0		0	0
490553	SD	school	4624390	50003	Flandreau 50-3	462439000207	4	Flandreau Elem	Regular School	Not applicable	Elementary	KG	04	2020	grade_10		0.0	0.0	0.0	0.0	0.0		0	0	0	0	0
492216	SD	school	4619580	37003	Jones County 37-3	461958000358	2	Jones County Elem	Regular School	Not applicable	Elementary	KG	04	2020	grade_10		0.0	0.0			0.0		0	0			0
492364	SD	school	4638220	7002	Kimball 07-2	463822000354	2	Kimball Elementary	Regular School	Not applicable	Elementary	PK	04	2020	grade_10		0.0	0.0			0.0		0	0			0
492666	SD	school	4641550	41004	Lennox 41-4	464155000386	2	Lennox Elementary	Regular School	Not applicable	Elementary	PK	04	2020	grade_10	0.0	0.0	0.0	0.0		0.0	0	0	0	0		0
492670	SD	school	4641550	41004	Lennox 41-4	464155000389	5	Worthing Elem	Regular School	Not applicable	Elementary	PK	04	2020	grade_10		0.0	0.0	0.0		0.0		0	0	0		0
493002	SD	school	4601026	43007	McCook Central 43-7	460102600404	2	McCook Central Elementary	Regular School	Not applicable	Elementary	PK	04	2020	grade_10		0.0				0.0		0				0
493174	SD	school	4669930	46001	Meade 46-1	466993000644	5	Piedmont Valley Elementary	Regular School	Not applicable	Elementary	KG	04	2020	grade_10	0.0	0.0	0.0	0.0		0.0	0	0	0	0		0
493177	SD	school	4669930	46001	Meade 46-1	466993000637	3	Sturgis Elementary	Regular School	Not applicable	Elementary	KG	04	2020	grade_10	0.0	0.0	0.0	0.0		0.0	0	0	0	0		0
496938	SD	school	4674520	60006	Viborg-Hurley 60-6	467452000692	2	Viborg-Hurley Elementary	Regular School	Not applicable	Elementary	PK	04	2020	grade_10	0.0	0.0	0.0			0.0	0	0	0			0
497002	SD	school	4675420	11004	Wagner Community 11-4	467542000694	2	Wagner Elementary School	Regular School	Not applicable	Elementary	KG	04	2020	grade_10		0.0	0.0		0.0	0.0		0	0		0	0
497181	SD	school	4676620	14004	Watertown 14-4	467662001083	9	Jefferson Elementary	Regular School	Not applicable	Elementary	KG	04	2020	grade_10	0.0	0.0	0.0	0.0		0.0	0	0	0	0		0
497182	SD	school	4676620	14004	Watertown 14-4	467662000944	5	Lincoln Elementary School	Regular School	Not applicable	Elementary	KG	04	2020	grade_10		0.0	0.0	0.0		0.0		0	0	0		0
497183	SD	school	4676620	14004	Watertown 14-4	467662000713	6	McKinley Elementary School	Regular School	Not applicable	Elementary	PK	04	2020	grade_10	0.0	0.0	0.0	0.0		0.0	0	0	0	0		0
497184	SD	school	4676620	14004	Watertown 14-4	467662000714	7	Mellette Elementary School	Regular School	Not applicable	Elementary	KG	04	2020	grade_10		0.0	0.0	0.0		0.0		0	0	0		0
497185	SD	school	4676620	14004	Watertown 14-4	467662000716	8	Roosevelt Elementary	Regular School	Not applicable	Elementary	PK	04	2020	grade_10		0.0	0.0			0.0		0	0			0
497928	SD	school	4680100	2006	Wolsey-Wessington 02-6	468010000783	2	Wolsey-Wessington Elementary	Regular School	Not applicable	Elementary	PK	04	2020	grade_10	0.0	0.0				0.0	0	0				0
2961993	SD	school	4603780	21001	Armour 21-1	460378000023	2	Armour Elementary	Regular School	No	1	PK	04	2015	grade_10	0.0		0.0			0.0	0		0			0
2962159	SD	school	4605610	9001	Belle Fourche 09-1	460561000269	3	South Park Elementary	Regular School	No	1	01	04	2015	grade_10		0.0	0.0			0.0		0	0			0
2963113	SD	school	4611760	60001	Centerville 60-1	461176000115	2	Centerville Elem	Regular School	No	1	PK	04	2015	grade_10	0.0	0.0				0.0	0	0				0
2963308	SD	school	4612940	12002	Clark 12-2	461294000132	2	Clark Elementary School	Regular School	No	1	PK	04	2015	grade_10	0.0	0.0			0.0		0	0			0
2963610	SD	school	4636990	61008	Dakota Valley 61-8	463699000251	2	Dakota Valley Elementary School	Regular School	No	1	KG	04	2015	grade_10	0.0	0.0	0.0	0.0	0.0	0.0	0	0	0	0	0	0
2963721	SD	school	4618120	49003	Dell Rapids 49-3	461812000164	2	Dell Rapids Elementary	Regular School	No	1	KG	04	2015	grade_10		0.0	0.0			0.0		0	0			0
2966457	SD	school	4619580	37003	Jones County 37-3	461958000358	2	Jones County Elem	Regular School	No	1	KG	04	2015	grade_10	0.0	0.0	0.0			0.0	0	0	0			0
2966589	SD	school	4638220	7002	Kimball 07-2	463822000354	2	Kimball Elementary	Regular School	No	1	PK	04	2015	grade_10		0.0	0.0			0.0		0	0			0
2967211	SD	school	4601026	43007	McCook Central 43-7	460102600404	2	McCook Central Elementary	Regular School	No	1	PK	04	2015	grade_10	0.0	0.0				0.0	0	0				0
2971195	SD	school	4674520	60006	Viborg-Hurley 60-6	467452000692	2	Viborg-Hurley Elementary	Regular School	No	1	PK	04	2015	grade_10	0.0	0.0		0.0	0.0	0.0	0	0		0	0	0
2971258	SD	school	4675420	11004	Wagner Community 11-4	467542000694	2	Wagner Elementary School	Regular School	No	1	01	04	2015	grade_10		0.0	0.0			0.0		0	0			0
3006799	SD	school	4605610	9001	Belle Fourche 09-1	460561000269	3	South Park Elementary	Regular School	No	Elementary	01	04	2017	grade_10	0.0	0.0	0.0			0.0	0	0	0			0
3007213	SD	school	4607950	49002	Brandon Valley 49-2	460795000414	3	Brandon Elem	Regular School	No	Elementary	PK	04	2017	grade_10	0.0	0.0	0.0	0.0	0.0	0.0	0	0	0	0	0	0
3007217	SD	school	4607950	49002	Brandon Valley 49-2	460795001302	6	Fred Assam Elementary	Regular School	No	Elementary	KG	04	2017	grade_10	0.0	0.0	0.0	0.0		0.0	0	0	0	0		0
3007218	SD	school	4607950	49002	Brandon Valley 49-2	460795001237	5	Robert Bennis Elementary	Regular School	No	Elementary	KG	04	2017	grade_10	0.0	0.0		0.0		0.0	0	0		0		0
3007219	SD	school	4607950	49002	Brandon Valley 49-2	460795000073	4	Valley Springs Elem	Regular School	No	Elementary	KG	04	2017	grade_10	0.0	0.0				0.0	0	0				0
3007980	SD	school	4612940	12002	Clark 12-2	461294000132	2	Clark Elementary School	Regular School	No	Elementary	PK	04	2017	grade_10	0.0	0.0	0.0			0.0	0	0	0			0
3008409	SD	school	4618120	49003	Dell Rapids 49-3	461812000164	2	Dell Rapids Elementary	Regular School	No	Elementary	KG	04	2017	grade_10		0.0	0.0			0.0		0	0			0
3010425	SD	school	4632340	14002	Henry 14-2	463234000275	2	Henry Elementary	Regular School	No	Elementary	PK	04	2017	grade_10				0.0						0
3011177	SD	school	4619580	37003	Jones County 37-3	461958000358	2	Jones County Elem	Regular School	No	Elementary	KG	04	2017	grade_10		0.0	0.0			0.0		0	0			0