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 "year" = :p2 order by white_int 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	female	total	black_int	hispanic_int	native_american_int	asian_int	pacific_islander_int	multiracial_int	female_int	total_int
2961646	SD	school	4602070	6001	Aberdeen 06-1	460207001230	12	Aberdeen Alternative Learning Center	Alternative Education School	No	4	06	12	2015	grade_2							0.0	0.0							0	0
2961648	SD	school	4602070	6001	Aberdeen 06-1	460207000003	1	Central 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
2961649	SD	school	4602070	6001	Aberdeen 06-1	460207000005	2	Holgate 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		0	0	0
2961652	SD	school	4602070	6001	Aberdeen 06-1	460207001130	89	New Beginnings	Alternative Education School	No	4	05	12	2015	grade_2		0.0	0.0		0.0		0.0	0.0		0	0		0		0	0
2961655	SD	school	4602070	6001	Aberdeen 06-1	460207000011	3	Simmons 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	0	0	0	0	0	0
2961784	SD	school	4600042	58003	Agar-Blunt-Onida 58-3	460004200656	7	Sully Buttes 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
2961785	SD	school	4600042	58003	Agar-Blunt-Onida 58-3	460004200939	6	Sully Buttes Junior High	Regular School	No	2	07	08	2015	grade_2			0.0			0.0	0.0	0.0			0			0	0	0
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
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
2961895	SD	school	4639540	11001	Andes Central 11-1	463954000360	1	Andes Central 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
2961896	SD	school	4639540	11001	Andes Central 11-1	463954000850	4	Andes Central Jr High	Regular School	No	2	07	08	2015	grade_2		0.0	0.0				0.0	0.0		0	0				0	0
2961955	SD	school	4603720	38001	Arlington 38-1	460372000022	1	Arlington High School	Regular School	No	3	09	12	2015	grade_2		0.0	0.0				0.0	0.0		0	0				0	0
2961956	SD	school	4603720	38001	Arlington 38-1	460372000877	3	Arlington Junior High School	Regular School	No	2	07	08	2015	grade_2		0.0					0.0	0.0		0					0	0
2962003	SD	school	4603780	21001	Armour 21-1	460378000024	1	Armour High School	Regular School	No	3	09	12	2015	grade_2	0.0		0.0				0.0	0.0	0		0				0	0
2962004	SD	school	4603780	21001	Armour 21-1	460378000878	3	Armour Middle School	Regular School	No	2	05	08	2015	grade_2			0.0				0.0	0.0			0				0	0
2962055	SD	school	4604270	4001	Avon 04-1	460427000029	1	Avon 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
2962056	SD	school	4604270	4001	Avon 04-1	460427000829	5	Avon Jr High School	Regular School	No	2	07	08	2015	grade_2		0.0	0.0				0.0	0.0		0	0				0	0
2962057	SD	school	4604270	4001	Avon 04-1	460427001325	6	Avon PK	Regular School	No	1	PK	PK	2015	grade_2						0.0	0.0	0.0						0	0	0
2962115	SD	school	4604680	49001	Baltic 49-1	460468000036	1	Baltic 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
2962116	SD	school	4604680	49001	Baltic 49-1	460468000986	3	Baltic 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
2962170	SD	school	4605610	9001	Belle Fourche 09-1	460561001277	9	Belle Fourche Education Connection	Alternative Education School	No	3	09	12	2015	grade_2		0.0	0.0			0.0	0.0	0.0		0	0			0	0	0
2962171	SD	school	4605610	9001	Belle Fourche 09-1	460561000038	1	Belle Fourche HS	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
2962172	SD	school	4605610	9001	Belle Fourche 09-1	460561001117	7	Belle Fourche MS	Regular School	No	2	05	08	2015	grade_2		0.0	0.0	0.0		0.0	0.0	0.0		0	0	0		0	0	0
2962173	SD	school	4605610	9001	Belle Fourche 09-1	460561000289	8	North Park Elementary	Regular School	No	1	KG	KG	2015	grade_2		0.0	0.0	0.0		0.0	0.0	0.0		0	0	0		0	0	0
2962242	SD	school	4606240	3001	Bennett County 03-1	460624000042	1	Bennett County 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
2962243	SD	school	4606240	3001	Bennett County 03-1	460624001015	6	Bennett County Jr High	Regular School	No	2	07	08	2015	grade_2		0.0	0.0			0.0	0.0	0.0		0	0			0	0	0
2962291	SD	school	4606360	61002	Beresford 61-2	460636000048	1	Beresford 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
2962292	SD	school	4606360	61002	Beresford 61-2	460636000051	3	Beresford 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
2962335	SD	school	4606960	25001	Big Stone City 25-1	460696000352	3	Big Stone MS	Regular School	No	2	06	08	2015	grade_2	0.0	0.0					0.0	0.0	0	0					0	0
2962371	SD	school	4607050	52001	Bison 52-1	460705000055	1	Bison High School	Regular School	No	3	09	12	2015	grade_2			0.0				0.0	0.0			0				0	0
2962372	SD	school	4607050	52001	Bison 52-1	460705000879	4	Bison JH	Regular School	No	2	07	08	2015	grade_2							0.0	0.0							0	0
2962434	SD	school	4607400	4002	Bon Homme 04-2	460740000065	1	Bon Homme 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
2962435	SD	school	4607400	4002	Bon Homme 04-2	460740000987	2	Bon Homme 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
2962436	SD	school	4607400	4002	Bon Homme 04-2	460740001328	8	Bon Homme PK	Regular School	No	1	PK	PK	2015	grade_2						0.0	0.0	0.0						0	0	0
2962531	SD	school	4607800	22001	Bowdle 22-1	460780000069	1	Bowdle High School	Regular School	No	3	09	12	2015	grade_2							0.0	0.0							0	0
2962532	SD	school	4607800	22001	Bowdle 22-1	460780000883	3	Bowdle Jr High	Regular School	No	2	07	08	2015	grade_2				0.0			0.0	0.0				0			0	0
2962591	SD	school	4607950	49002	Brandon Valley 49-2	460795000071	1	Brandon Valley 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
2962592	SD	school	4607950	49002	Brandon Valley 49-2	460795000072	2	Brandon Valley Middle Sch	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	0	0	0	0	0	0
2962679	SD	school	4621420	30003	Bridgewater-Emery 30-3	462142000074	1	Bridgewater-Emery 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
2962680	SD	school	4621420	30003	Bridgewater-Emery 30-3	462142000902	4	Bridgewater-Emery Middle School	Regular School	No	2	06	08	2015	grade_2	0.0						0.0	0.0	0						0	0
2962747	SD	school	4600041	45004	Britton-Hecla 45-4	460004101141	1	Britton-Hecla 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
2962748	SD	school	4600041	45004	Britton-Hecla 45-4	460004101142	3	Britton-Hecla Junior High	Regular School	No	2	07	08	2015	grade_2	0.0	0.0	0.0				0.0	0.0	0	0	0				0	0
2962826	SD	school	4608520	5001	Brookings 05-1	460852000082	1	Brookings 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
2962827	SD	school	4608520	5001	Brookings 05-1	460852001298	6	Camelot Intermediate School	Regular School	No	1	03	05	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
2962828	SD	school	4608520	5001	Brookings 05-1	460852000083	2	George S Mickelson 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	0	0	0	0	0	0
2962899	SD	school	4609512	26002	Burke 26-2	460951200101	1	Burke High School	Regular School	No	3	09	12	2015	grade_2			0.0				0.0	0.0			0				0	0
2962900	SD	school	4609512	26002	Burke 26-2	460951201043	4	Burke JH	Regular School	No	2	07	08	2015	grade_2		0.0	0.0				0.0	0.0		0	0				0	0
2962947	SD	school	4610320	43001	Canistota 43-1	461032000105	1	Canistota High School	Regular School	No	3	09	12	2015	grade_2	0.0		0.0				0.0	0.0	0		0				0	0
2962948	SD	school	4610320	43001	Canistota 43-1	461032001016	3	Canistota Middle School	Regular School	No	2	06	08	2015	grade_2	0.0		0.0				0.0	0.0	0		0				0	0
2962998	SD	school	4610560	41001	Canton 41-1	461056000109	1	Canton 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
2962999	SD	school	4610560	41001	Canton 41-1	461056000831	4	Canton 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
2963000	SD	school	4610560	41001	Canton 41-1	461056001345	6	Canton Virtual HS	Regular School	No	3	09	12	2015	grade_2	0.0		0.0				0.0	0.0	0		0				0	0
2963063	SD	school	4611280	28001	Castlewood 28-1	461128000114	1	Castlewood High School	Regular School	No	3	09	12	2015	grade_2			0.0				0.0	0.0			0				0	0
2963064	SD	school	4611280	28001	Castlewood 28-1	461128000954	3	Castlewood Jr High School	Regular School	No	2	07	08	2015	grade_2		0.0	0.0				0.0	0.0		0	0				0	0
2963123	SD	school	4611760	60001	Centerville 60-1	461176000116	1	Centerville 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
2963124	SD	school	4611760	60001	Centerville 60-1	461176001023	3	Centerville Middle School	Regular School	No	2	05	08	2015	grade_2	0.0	0.0	0.0				0.0	0.0	0	0	0				0	0
2963171	SD	school	4612000	7001	Chamberlain 07-1	461200000119	1	Chamberlain 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
2963172	SD	school	4612000	7001	Chamberlain 07-1	461200000889	2	Chamberlain Jr. High	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		0	0	0
2963230	SD	school	4612300	39001	Chester Area 39-1	461230001295	6	Alternative School	Alternative Education School	No	3	09	12	2015	grade_2		0.0	0.0			0.0	0.0	0.0		0	0			0	0	0
2963231	SD	school	4612300	39001	Chester Area 39-1	461230001269	39	Chester Area Cyber School	Alternative Education School	No	3	09	12	2015	grade_2			0.0				0.0	0.0			0				0	0
2963233	SD	school	4612300	39001	Chester Area 39-1	461230000130	1	Chester Area High School	Regular School	No	3	09	12	2015	grade_2							0.0	0.0							0	0
2963234	SD	school	4612300	39001	Chester Area 39-1	461230000832	3	Chester Area Middle School	Regular School	No	2	06	08	2015	grade_2			0.0			0.0	0.0	0.0			0			0	0	0
2963327	SD	school	4612940	12002	Clark 12-2	461294000133	1	Clark High School	Regular School	No	3	09	12	2015	grade_2	0.0	0.0					0.0	0.0	0	0					0	0
2963328	SD	school	4612940	12002	Clark 12-2	461294000890	3	Clark Middle School	Regular School	No	2	05	08	2015	grade_2	0.0	0.0					0.0	0.0	0	0					0	0
2963406	SD	school	4614100	50005	Colman-Egan 50-5	461410000091	1	Colman-Egan 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
2963407	SD	school	4614100	50005	Colman-Egan 50-5	461410000092	2	Colman-Egan Jr Hi	Regular School	No	2	07	08	2015	grade_2	0.0		0.0				0.0	0.0	0		0				0	0
2963447	SD	school	4614130	59003	Colome Consolidated	461413000141	1	Colome 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
2963448	SD	school	4614130	59003	Colome Consolidated	461413000893	3	Colome Jr High	Regular School	No	2	07	08	2015	grade_2	0.0		0.0	0.0			0.0	0.0	0		0	0			0	0
2963449	SD	school	4614130	59003	Colome Consolidated	461413000787	5	Wood Elementary	Regular School	No	1	KG	08	2015	grade_2			0.0				0.0	0.0			0				0	0
2963507	SD	school	4616230	21002	Corsica 21-2	461623000149	1	Corsica High School	Regular School	No	3	09	12	2015	grade_2							0.0	0.0							0	0
2963508	SD	school	4616230	21002	Corsica 21-2	461623000991	3	Corsica Middle School	Regular School	No	2	06	08	2015	grade_2							0.0	0.0							0	0
2963559	SD	school	4616950	16001	Custer 16-1	461695000155	1	Custer 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
2963560	SD	school	4616950	16001	Custer 16-1	461695000992	5	Custer 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			0	0	0
2963623	SD	school	4636990	61008	Dakota Valley 61-8	463699000345	1	Dakota Valley 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
2963624	SD	school	4636990	61008	Dakota Valley 61-8	463699000809	3	Dakota Valley Middle School	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		0	0	0
2963625	SD	school	4636990	61008	Dakota Valley 61-8	463699001075	4	Dakota Valley Upper Elem	Regular School	No	2	05	06	2015	grade_2	0.0	0.0	0.0	0.0		0.0	0.0	0.0	0	0	0	0		0	0	0
2963682	SD	school	4617850	38002	De Smet 38-2	461785000163	1	De Smet High School	Regular School	No	3	09	12	2015	grade_2	0.0	0.0					0.0	0.0	0	0					0	0
2963683	SD	school	4617850	38002	De Smet 38-2	461785000993	3	De Smet Middle School	Regular School	No	2	06	08	2015	grade_2			0.0				0.0	0.0			0				0	0
2963731	SD	school	4618120	49003	Dell Rapids 49-3	461812000165	1	Dell Rapids 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
2963732	SD	school	4618120	49003	Dell Rapids 49-3	461812000837	3	Dell Rapids Middle School	Regular School	No	2	05	08	2015	grade_2	0.0	0.0	0.0			0.0	0.0	0.0	0	0	0			0	0	0
2963787	SD	school	4678300	5006	Deubrook Area 05-6	467830000012	1	Deubrook High School	Regular School	No	3	09	12	2015	grade_2		0.0	0.0				0.0	0.0		0	0				0	0
2963788	SD	school	4678300	5006	Deubrook Area 05-6	467830000016	2	Deubrook Jr High	Regular School	No	2	07	08	2015	grade_2		0.0					0.0	0.0		0					0	0
2963790	SD	school	4678300	5006	Deubrook Area 05-6	467830001320	9	Red Willow Colony School	Regular School	No	1	KG	08	2015	grade_2							0.0	0.0							0	0
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
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
2963919	SD	school	4619170	56002	Doland 56-2	461917001101	5	Clark Colony Elementary	Regular School	No	1	PK	08	2015	grade_2							0.0	0.0							0	0
2963921	SD	school	4619170	56002	Doland 56-2	461917000171	1	Doland High School	Regular School	No	3	09	12	2015	grade_2		0.0					0.0	0.0		0					0	0
2963922	SD	school	4619170	56002	Doland 56-2	461917000895	2	Doland Junior High	Regular School	No	2	07	08	2015	grade_2							0.0	0.0							0	0
2964014	SD	school	4619410	51001	Douglas 51-1	461941000453	5	Badger Clark Elem	Regular School	No	1	KG	01	2015	grade_2	0.0	0.0	0.0	0.0		0.0	0.0	0.0	0	0	0	0		0	0	0
2964015	SD	school	4619410	51001	Douglas 51-1	461941000174	3	Douglas 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
2964016	SD	school	4619410	51001	Douglas 51-1	461941000176	1	Douglas 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	0	0	0	0	0	0
2964017	SD	school	4619410	51001	Douglas 51-1	461941001125	8	Douglas Preschool	Regular School	No	1	PK	PK	2015	grade_2	0.0	0.0	0.0			0.0	0.0	0.0	0	0	0			0	0	0
2964019	SD	school	4619410	51001	Douglas 51-1	461941000436	2	Vandenberg Elementary	Regular School	No	2	04	05	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
2964099	SD	school	4619450	64002	Dupree 64-2	461945000800	1	Dupree Hi Sch	Regular School	No	3	09	12	2015	grade_2		0.0	0.0				0.0	0.0		0	0				0	0
2964100	SD	school	4619450	64002	Dupree 64-2	461945000896	4	Dupree Jr Hi	Regular School	No	2	07	08	2015	grade_2			0.0				0.0	0.0			0				0	0
2964154	SD	school	4620100	20001	Eagle Butte 20-1	462010001233	7	C-EB EAGLE Center	Alternative Education School	No	4	05	12	2015	grade_2			0.0				0.0	0.0			0				0	0
2964155	SD	school	4620100	20001	Eagle Butte 20-1	462010000956	1	C-EB High School	Regular School	No	3	09	12	2015	grade_2			0.0				0.0	0.0			0				0	0
2964156	SD	school	4620100	20001	Eagle Butte 20-1	462010000898	6	C-EB Junior High	Regular School	No	2	07	08	2015	grade_2			0.0				0.0	0.0			0				0	0
2964157	SD	school	4620100	20001	Eagle Butte 20-1	462010000897	2	C-EB Primary	Regular School	No	1	KG	02	2015	grade_2		0.0	2.0				2.0	2.0		0	2				2	2
2964158	SD	school	4620100	20001	Eagle Butte 20-1	462010000605	3	C-EB Upper Elementary	Regular School	No	1	03	06	2015	grade_2		0.0	0.0				0.0	0.0		0	0				0	0
2964223	SD	school	4620850	23001	Edgemont 23-1	462085000182	1	Edgemont High School	Regular School	No	3	09	12	2015	grade_2		0.0	0.0				0.0	0.0		0	0				0	0