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 ccd_school_lvl 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	black	hispanic	native_american	asian	pacific_islander	multiracial	black_int	hispanic_int	native_american_int	asian_int	pacific_islander_int	multiracial_int
250180	SD	school	4603720	38001	Arlington 38-1	460372001381	4	Arlington PreSchool	Regular School	No	Prekindergarten	PK	PK	2018	grade_3		0.0						0
250292	SD	school	4604270	4001	Avon 04-1	460427001325	6	Avon PK	Regular School	No	Prekindergarten	PK	PK	2018	grade_3						0.0						0
250674	SD	school	4607400	4002	Bon Homme 04-2	460740001328	8	Bon Homme PK	Regular School	No	Prekindergarten	PK	PK	2018	grade_3
252312	SD	school	4619410	51001	Douglas 51-1	461941001125	8	Douglas Preschool	Regular School	No	Prekindergarten	PK	PK	2018	grade_3		0.0	0.0			0.0		0	0			0
252905	SD	school	4622940	46002	Faith 46-2	462294001306	10	Faith PreSchool	Regular School	No	Prekindergarten	PK	PK	2018	grade_3			0.0						0
357423	SD	school	4603720	38001	Arlington 38-1	460372001381	4	Arlington PreSchool	Regular School	No	Prekindergarten	PK	PK	2019	grade_3	0.0						0
357535	SD	school	4604270	4001	Avon 04-1	460427001325	6	Avon PK	Regular School	No	Prekindergarten	PK	PK	2019	grade_3
357922	SD	school	4607400	4002	Bon Homme 04-2	460740001328	8	Bon Homme PK	Regular School	No	Prekindergarten	PK	PK	2019	grade_3			0.0						0
359571	SD	school	4619410	51001	Douglas 51-1	461941001125	8	Douglas Preschool	Regular School	No	Prekindergarten	PK	PK	2019	grade_3					0.0	0.0					0	0
449269	SD	school	4603720	38001	Arlington 38-1	460372001381	4	Arlington PreSchool	Regular School	Not applicable	Prekindergarten	PK	PK	2021	grade_3
449381	SD	school	4604270	4001	Avon 04-1	460427001325	6	Avon PK	Regular School	Not applicable	Prekindergarten	PK	PK	2021	grade_3			0.0						0
449768	SD	school	4607400	4002	Bon Homme 04-2	460740001328	8	Bon Homme PK	Regular School	Not applicable	Prekindergarten	PK	PK	2021	grade_3			0.0						0
458594	SD	school	4675420	11004	Wagner Community 11-4	467542001278	4	Early Learning Center	Regular School	Not applicable	Prekindergarten	PK	PK	2021	grade_3	0.0	0.0	0.0			0.0	0	0	0			0
487692	SD	school	4603720	38001	Arlington 38-1	460372001381	4	Arlington PreSchool	Regular School	Not applicable	Prekindergarten	PK	PK	2020	grade_3
487804	SD	school	4604270	4001	Avon 04-1	460427001325	6	Avon PK	Regular School	Not applicable	Prekindergarten	PK	PK	2020	grade_3		0.0				0.0		0				0
488191	SD	school	4607400	4002	Bon Homme 04-2	460740001328	8	Bon Homme PK	Regular School	Not applicable	Prekindergarten	PK	PK	2020	grade_3		0.0	0.0					0	0
489840	SD	school	4619410	51001	Douglas 51-1	461941001125	8	Douglas Preschool	Regular School	Not applicable	Prekindergarten	PK	PK	2020	grade_3		0.0	0.0			0.0		0	0			0
497017	SD	school	4675420	11004	Wagner Community 11-4	467542001278	4	Early Learning Center	Regular School	Not applicable	Prekindergarten	PK	PK	2020	grade_3		0.0	0.0			0.0		0	0			0
257186	SD	school	4659820	51004	Rapid City Area 51-4	465982001072	64	Jefferson Building	Special Education School	No	Other	PK	12	2018	grade_3
258020	SD	school	4666270	49005	Sioux Falls 49-5	466627001368	71	ARISE Shelter Care	Alternative School	No	Other	KG	12	2018	grade_3		0.0	0.0					0	0
258057	SD	school	4666270	49005	Sioux Falls 49-5	466627000609	40	Summit Oaks Day Program	Special Education School	No	Other	KG	12	2018	grade_3	0.0	0.0					0	0
258058	SD	school	4666270	49005	Sioux Falls 49-5	466627001133	48	Summit Oaks Residential Program	Alternative School	No	Other	KG	12	2018	grade_3	0.0		0.0			0.0	0		0			0
364461	SD	school	4659820	51004	Rapid City Area 51-4	465982001072	64	Jefferson Building	Special Education School	No	Other	PK	12	2019	grade_3		0.0	0.0			0.0		0	0			0
365290	SD	school	4666270	49005	Sioux Falls 49-5	466627001368	71	ARISE Shelter Care	Alternative School	No	Other	KG	12	2019	grade_3		0.0	0.0			0.0		0	0			0
365326	SD	school	4666270	49005	Sioux Falls 49-5	466627000609	40	Summit Oaks Day Program	Special Education School	No	Other	KG	12	2019	grade_3	0.0	0.0	0.0				0	0	0
365327	SD	school	4666270	49005	Sioux Falls 49-5	466627001133	48	Summit Oaks Residential Program	Alternative School	No	Other	KG	12	2019	grade_3		0.0	0.0					0	0
456339	SD	school	4659820	51004	Rapid City Area 51-4	465982001072	64	Jefferson Building	Special Education School	Not applicable	Other	PK	12	2021	grade_3		0.0	0.0	0.0		0.0		0	0	0		0
457152	SD	school	4666270	49005	Sioux Falls 49-5	466627001368	71	ARISE Shelter Care	Alternative School	Not applicable	Other	KG	12	2021	grade_3			0.0						0
457188	SD	school	4666270	49005	Sioux Falls 49-5	466627000609	40	Summit Oaks Day Program	Alternative School	Not applicable	Other	KG	12	2021	grade_3		0.0	0.0					0	0
457189	SD	school	4666270	49005	Sioux Falls 49-5	466627001133	48	Summit Oaks Residential Program	Special Education School	Not applicable	Other	KG	12	2021	grade_3			0.0			0.0			0			0
494746	SD	school	4659820	51004	Rapid City Area 51-4	465982001072	64	Jefferson Building	Special Education School	Not applicable	Other	PK	12	2020	grade_3		0.0	0.0			0.0		0	0			0
495575	SD	school	4666270	49005	Sioux Falls 49-5	466627001368	71	ARISE Shelter Care	Alternative School	Not applicable	Other	KG	12	2020	grade_3						0.0						0
495611	SD	school	4666270	49005	Sioux Falls 49-5	466627000609	40	Summit Oaks Day Program	Special Education School	Not applicable	Other	KG	12	2020	grade_3	0.0	0.0	0.0				0	0	0
495612	SD	school	4666270	49005	Sioux Falls 49-5	466627001133	48	Summit Oaks Residential Program	Alternative School	Not applicable	Other	KG	12	2020	grade_3			0.0			0.0			0			0
3006286	SD	school	4602070	6001	Aberdeen 06-1	460207001130	89	New Beginnings	Alternative School	No	Other	05	12	2017	grade_3	0.0	0.0	0.0				0	0	0
3013190	SD	school	4654300	33003	Parkston 33-3	465430001132	88	Our Home	Alternative School	No	Other	05	12	2017	grade_3		0.0	0.0			0.0		0	0			0
3013627	SD	school	4659820	51004	Rapid City Area 51-4	465982001072	64	Jefferson Building	Special Education School	No	Other	PK	12	2017	grade_3	0.0	0.0	0.0			0.0	0	0	0			0
3014466	SD	school	4666270	49005	Sioux Falls 49-5	466627001123	45	FLEX	Special Education School	No	Other	06	12	2017	grade_3	0.0	0.0	0.0				0	0	0
3014489	SD	school	4666270	49005	Sioux Falls 49-5	466627001138	12	Structured Teaching Program	Special Education School	No	Other	06	12	2017	grade_3	0.0	0.0	0.0			0.0	0	0	0			0
3014490	SD	school	4666270	49005	Sioux Falls 49-5	466627001121	39	Success Academy	Special Education School	No	Other	06	12	2017	grade_3	0.0	0.0	0.0			0.0	0	0	0			0
3014491	SD	school	4666270	49005	Sioux Falls 49-5	466627000609	40	Summit Oaks Day Program	Special Education School	No	Other	05	12	2017	grade_3	0.0	0.0	0.0			0.0	0	0	0			0
3014492	SD	school	4666270	49005	Sioux Falls 49-5	466627001133	48	Summit Oaks Residential Program	Alternative School	No	Other	05	12	2017	grade_3	0.0	0.0	0.0				0	0	0
3014493	SD	school	4666270	49005	Sioux Falls 49-5	466627001368	71	Summit Oaks Shelter Care	Alternative School	No	Other	05	12	2017	grade_3	0.0		0.0				0		0
249857	SD	school	4602070	6001	Aberdeen 06-1	460207000005	2	Holgate Middle School	Regular School	No	Middle	06	08	2018	grade_3	0.0	0.0	0.0	0.0		0.0	0	0	0	0		0
249864	SD	school	4602070	6001	Aberdeen 06-1	460207000011	3	Simmons Middle School	Regular School	No	Middle	06	08	2018	grade_3	0.0	0.0	0.0	0.0	0.0	0.0	0	0	0	0	0	0
249988	SD	school	4600042	58003	Agar-Blunt-Onida 58-3	460004200939	6	Sully Buttes Junior High	Regular School	No	Middle	07	08	2018	grade_3			0.0			0.0			0			0
250046	SD	school	4600028	61001	Alcester-Hudson 61-1	460002800874	3	Alcester-Hudson JH	Regular School	No	Middle	07	08	2018	grade_3		0.0				0.0		0				0
250104	SD	school	4639540	11001	Andes Central 11-1	463954000850	4	Andes Central Jr High	Regular School	No	Middle	07	08	2018	grade_3		0.0	0.0			0.0		0	0			0
250179	SD	school	4603720	38001	Arlington 38-1	460372000877	3	Arlington Junior High School	Regular School	No	Middle	07	08	2018	grade_3		0.0						0
250238	SD	school	4603780	21001	Armour 21-1	460378000878	3	Armour Middle School	Regular School	No	Middle	06	08	2018	grade_3		0.0	0.0			0.0		0	0			0
250291	SD	school	4604270	4001	Avon 04-1	460427000829	5	Avon Jr High School	Regular School	No	Middle	07	08	2018	grade_3		0.0	0.0			0.0		0	0			0
250350	SD	school	4604680	49001	Baltic 49-1	460468000986	3	Baltic Middle School	Regular School	No	Middle	06	08	2018	grade_3		0.0	0.0			0.0		0	0			0
250408	SD	school	4605610	9001	Belle Fourche 09-1	460561001117	7	Belle Fourche MS	Regular School	No	Middle	05	08	2018	grade_3		0.0	0.0			0.0		0	0			0
250477	SD	school	4606240	3001	Bennett County 03-1	460624001015	6	Bennett County Jr High	Regular School	No	Middle	07	08	2018	grade_3		0.0	0.0	0.0		0.0		0	0	0		0
250526	SD	school	4606360	61002	Beresford 61-2	460636000051	3	Beresford Middle School	Regular School	No	Middle	06	08	2018	grade_3	0.0	0.0		0.0		0.0	0	0		0		0
250568	SD	school	4606960	25001	Big Stone City 25-1	460696000352	3	Big Stone MS	Regular School	No	Middle	06	08	2018	grade_3	0.0						0
250606	SD	school	4607050	52001	Bison 52-1	460705000879	4	Bison JH	Regular School	No	Middle	07	08	2018	grade_3		0.0	0.0					0	0
250673	SD	school	4607400	4002	Bon Homme 04-2	460740000987	2	Bon Homme Middle School	Regular School	No	Middle	06	08	2018	grade_3		0.0	0.0			0.0		0	0			0
250766	SD	school	4607800	22001	Bowdle 22-1	460780000883	3	Bowdle Jr High	Regular School	No	Middle	07	08	2018	grade_3
250834	SD	school	4607950	49002	Brandon Valley 49-2	460795001355	7	Brandon Valley Intermediate	Regular School	No	Middle	05	06	2018	grade_3	0.0	0.0	0.0	0.0	0.0	0.0	0	0	0	0	0	0
250835	SD	school	4607950	49002	Brandon Valley 49-2	460795000072	2	Brandon Valley Middle Sch	Regular School	No	Middle	07	08	2018	grade_3	0.0	0.0	0.0	0.0	0.0	0.0	0	0	0	0	0	0
250926	SD	school	4621420	30003	Bridgewater-Emery 30-3	462142000902	4	Bridgewater-Emery Middle School	Regular School	No	Middle	06	08	2018	grade_3	0.0	0.0	0.0				0	0	0
250989	SD	school	4600041	45004	Britton-Hecla 45-4	460004101142	3	Britton-Hecla Junior High	Regular School	No	Middle	07	08	2018	grade_3			0.0	0.0					0	0
251086	SD	school	4608520	5001	Brookings 05-1	460852000083	2	George S Mickelson Middle School	Regular School	No	Middle	06	08	2018	grade_3	0.0	0.0	0.0	0.0	0.0	0.0	0	0	0	0	0	0
251166	SD	school	4609512	26002	Burke 26-2	460951201043	4	Burke JH	Regular School	No	Middle	07	08	2018	grade_3	0.0	0.0	0.0				0	0	0
251214	SD	school	4610320	43001	Canistota 43-1	461032001016	3	Canistota Middle School	Regular School	No	Middle	06	08	2018	grade_3		0.0						0
251261	SD	school	4610560	41001	Canton 41-1	461056000831	4	Canton Middle School	Regular School	No	Middle	06	08	2018	grade_3	0.0	0.0	0.0	0.0		0.0	0	0	0	0		0
251315	SD	school	4611280	28001	Castlewood 28-1	461128000954	3	Castlewood Jr High School	Regular School	No	Middle	07	08	2018	grade_3		0.0						0
251374	SD	school	4611760	60001	Centerville 60-1	461176001023	3	Centerville Middle School	Regular School	No	Middle	06	08	2018	grade_3	0.0	0.0	0.0				0	0	0
251422	SD	school	4612000	7001	Chamberlain 07-1	461200000889	2	Chamberlain Jr. High	Regular School	No	Middle	07	08	2018	grade_3		0.0	0.0	0.0		0.0		0	0	0		0
251491	SD	school	4612300	39001	Chester Area 39-1	461230000832	3	Chester Area Middle School	Regular School	No	Middle	06	08	2018	grade_3	0.0		0.0				0		0
251597	SD	school	4612940	12002	Clark 12-2	461294000890	3	Clark Middle School	Regular School	No	Middle	05	08	2018	grade_3	0.0	0.0					0	0
251678	SD	school	4614100	50005	Colman-Egan 50-5	461410000092	2	Colman-Egan Jr Hi	Regular School	No	Middle	07	08	2018	grade_3			0.0						0
251731	SD	school	4614130	59003	Colome Consolidated	461413000893	3	Colome Middle School	Regular School	No	Middle	06	08	2018	grade_3			0.0			0.0			0			0
251790	SD	school	4680445	21003	Corsica-Stickney 21-3	468044501352	3	Corsica-Stickney Jr. High	Regular School	No	Middle	07	08	2018	grade_3
251843	SD	school	4616950	16001	Custer 16-1	461695000992	5	Custer JH	Regular School	No	Middle	07	08	2018	grade_3	0.0	0.0	0.0			0.0	0	0	0			0
251907	SD	school	4636990	61008	Dakota Valley 61-8	463699000809	3	Dakota Valley Middle School	Regular School	No	Middle	06	08	2018	grade_3	0.0	0.0	0.0	0.0		0.0	0	0	0	0		0
251965	SD	school	4617850	38002	De Smet 38-2	461785000993	3	De Smet Middle School	Regular School	No	Middle	06	08	2018	grade_3		0.0		0.0				0		0
252014	SD	school	4618120	49003	Dell Rapids 49-3	461812000837	3	Dell Rapids Middle School	Regular School	No	Middle	05	08	2018	grade_3		0.0	0.0			0.0		0	0			0
252072	SD	school	4678300	5006	Deubrook Area 05-6	467830000016	2	Deubrook Jr High	Regular School	No	Middle	07	08	2018	grade_3	0.0	0.0	0.0	0.0			0	0	0	0
252141	SD	school	4600036	19004	Deuel 19-4	460003601013	4	Clear Lake Middle School	Regular School	No	Middle	06	08	2018	grade_3	0.0	0.0					0	0
252212	SD	school	4619170	56002	Doland 56-2	461917000895	2	Doland Junior High	Regular School	No	Middle	07	08	2018	grade_3	0.0						0
252311	SD	school	4619410	51001	Douglas 51-1	461941000176	1	Douglas Middle School	Regular School	No	Middle	06	08	2018	grade_3	0.0	0.0	0.0	0.0	0.0	0.0	0	0	0	0	0	0
252382	SD	school	4619450	64002	Dupree 64-2	461945000896	4	Dupree Jr Hi	Regular School	No	Middle	07	08	2018	grade_3		0.0	0.0					0	0
252434	SD	school	4620100	20001	Eagle Butte 20-1	462010000898	6	C-EB Junior High	Regular School	No	Middle	07	08	2018	grade_3		0.0	0.0					0	0
252532	SD	school	4634440	22005	Edmunds Central 22-5	463444000032	2	Edmunds Central Middle School	Regular School	No	Middle	07	08	2018	grade_3		0.0	0.0					0	0
252622	SD	school	4621340	61007	Elk Point-Jefferson 61-7	462134000900	3	Elk Point Jefferson Middle School	Regular School	No	Middle	06	08	2018	grade_3	0.0	0.0				0.0	0	0				0
252680	SD	school	4621390	5003	Elkton 05-3	462139000901	3	Elkton Junior High	Regular School	No	Middle	07	08	2018	grade_3		0.0				0.0		0				0
252750	SD	school	4622410	28002	Estelline 28-2	462241001045	3	Estelline Junior High	Regular School	No	Middle	07	08	2018	grade_3		0.0						0
252798	SD	school	4622500	17001	Ethan 17-1	462250000903	3	Ethan Jr. High	Regular School	No	Middle	07	08	2018	grade_3		0.0				0.0		0				0
252846	SD	school	4622560	44001	Eureka 44-1	462256000958	3	Eureka MS	Regular School	No	Middle	06	08	2018	grade_3	0.0					0.0	0					0
252904	SD	school	4622940	46002	Faith 46-2	462294000995	6	Faith Jr. High	Regular School	No	Middle	07	08	2018	grade_3		0.0	0.0	0.0				0	0	0
252991	SD	school	4624030	24004	Faulkton Area	462403000204	8	Faulkton Jr Hi	Regular School	No	Middle	07	08	2018	grade_3	0.0		0.0				0		0
253075	SD	school	4624390	50003	Flandreau 50-3	462439000205	3	Flandreau Middle Sch	Regular School	No	Middle	06	08	2018	grade_3	0.0	0.0	0.0	0.0	0.0	0.0	0	0	0	0	0	0
253134	SD	school	4624540	14001	Florence 14-1	462454000589	3	Florence Middle School	Regular School	No	Middle	06	08	2018	grade_3						0.0						0
253182	SD	school	4621400	6002	Frederick Area 06-2	462140000957	3	Frederick Jr High	Regular School	No	Middle	07	08	2018	grade_3
253240	SD	school	4625500	33001	Freeman 33-1	462550000842	5	Freeman Jr High	Regular School	No	Middle	07	08	2018	grade_3		0.0				0.0		0				0
253310	SD	school	4626370	49004	Garretson 49-4	462637000843	3	Garretson Middle School	Regular School	No	Middle	06	08	2018	grade_3		0.0	0.0	0.0		0.0		0	0	0		0
253358	SD	school	4626490	63001	Gayville-Volin 63-1	462649000844	3	Gayville-Volin JH	Regular School	No	Middle	07	08	2018	grade_3		0.0				0.0		0				0
253406	SD	school	4626970	53001	Gettysburg 53-1	462697000959	3	Gettysburg Junior High	Regular School	No	Middle	07	08	2018	grade_3	0.0	0.0	0.0				0	0	0
253454	SD	school	4629880	26004	Gregory 26-4	462988001296	4	Gregory Jr High School	Regular School	No	Middle	06	08	2018	grade_3	0.0	0.0	0.0	0.0		0.0	0	0	0	0		0