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_high_grade desc limit 101

Query parameters

This data as json, CSV

rowid	state	admin_level	district_nces_id	district_state_id	district_state_type	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	total	total_int
1199280	UT	school	4900060	02	District	Beaver District	490006001257	100	Beaver Preschool	Special Education School	No	Prekindergarten	PK	PK	2020	grade_6	0	0
1199313	UT	school	4900120	04	District	Cache District	490012001251	600	Cache Preschool	Special Education School	No	Prekindergarten	PK	PK	2020	grade_6	0	0
1199380	UT	school	4900142	42	District	Canyons District	490014201309	800	Special Ed Preschool	Special Education School	No	Prekindergarten	PK	PK	2020	grade_6	0	0
1199425	UT	school	4900210	07	District	Davis District	490021000727	802	Family Enrichment Center	Special Education School	No	Prekindergarten	PK	PK	2020	grade_6	0	0
1199522	UT	school	4900330	11	District	Grand District	490033001236	801	C R Sundwall Preschool	Special Education School	No	Prekindergarten	PK	PK	2020	grade_6	0	0
1199626	UT	school	4900390	13	District	Iron District	490039001240	150	Iron County Preschool	Special Education School	No	Prekindergarten	PK	PK	2020	grade_6	0	0
1199631	UT	school	4900390	13	District	Iron District	490039001238	160	Three Peaks Pre School	Special Education School	No	Prekindergarten	PK	PK	2020	grade_6	0	0
1199703	UT	school	4900480	16	District	Kane District	490048001258	100	Kane Preschool	Special Education School	No	Prekindergarten	PK	PK	2020	grade_6	0	0
1199712	UT	school	4900510	39	District	Logan City District	490051001530	114	Logan Early Childhood Center	Regular School	No	Prekindergarten	PK	PK	2020	grade_6	0	0
1199715	UT	school	4900510	39	District	Logan City District	490051001234	113	Riverside Preschool	Special Education School	No	Prekindergarten	PK	PK	2020	grade_6	0	0
1199729	UT	school	4900570	18	District	Morgan District	490057001260	100	Morgan Preschool	Special Education School	No	Prekindergarten	PK	PK	2020	grade_6	0	0
1199733	UT	school	4900600	40	District	Murray District	490060001248	140	Early Childhood Center	Special Education School	No	Prekindergarten	PK	PK	2020	grade_6	0	0
1199799	UT	school	4900690	21	District	North Summit District	490069001254	100	North Summit Preschool	Special Education School	No	Prekindergarten	PK	PK	2020	grade_6	0	0
1199816	UT	school	4900720	37	District	Ogden City District	490072001232	100	Ogden Preschool	Special Education School	No	Prekindergarten	PK	PK	2020	grade_6	0	0
1199822	UT	school	4900750	22	District	Park City District	490075001423	158	Jeremy Ranch Preschool	Special Education School	No	Prekindergarten	PK	PK	2020	grade_6	0	0
1199825	UT	school	4900750	22	District	Park City District	490075001255	150	MPES Preschool	Special Education School	No	Prekindergarten	PK	PK	2020	grade_6	0	0
1199827	UT	school	4900750	22	District	Park City District	490075001409	154	Parley's Park Preschool	Special Education School	No	Prekindergarten	PK	PK	2020	grade_6	0	0
1199829	UT	school	4900750	22	District	Park City District	490075001410	156	Trailside Preschool	Special Education School	No	Prekindergarten	PK	PK	2020	grade_6	0	0
1199832	UT	school	4900780	23	District	Piute District	490078001261	101	Circleville Preschool	Special Education School	No	Prekindergarten	PK	PK	2020	grade_6	0	0
1199834	UT	school	4900780	23	District	Piute District	490078001262	102	Oscarson Preschool	Special Education School	No	Prekindergarten	PK	PK	2020	grade_6	0	0
1199853	UT	school	4900810	38	District	Provo District	490081001233	641	Sunrise Preschool	Special Education School	No	Prekindergarten	PK	PK	2020	grade_6	0	0
1199862	UT	school	4900840	24	District	Rich District	490084001264	150	Rich Preschool	Special Education School	No	Prekindergarten	PK	PK	2020	grade_6	0	0
1199898	UT	school	4900870	36	District	Salt Lake District	490087001230	292	Salt Lake Head Start	Regular School	No	Prekindergarten	PK	PK	2020	grade_6	0	0
1199925	UT	school	4900930	26	District	Sevier District	490093000495	820	Richfield Preschool	Special Education School	No	Prekindergarten	PK	PK	2020	grade_6	0	0
1199953	UT	school	4901050	30	District	Tooele District	490105001246	101	Early Learning Center	Special Education School	No	Prekindergarten	PK	PK	2020	grade_6	0	0
1199984	UT	school	4901080	31	District	Uintah District	490108001247	810	Uintah Specialized Preschool	Special Education School	No	Prekindergarten	PK	PK	2020	grade_6	0	0
1200041	UT	school	4901140	33	District	Washington District	490114000778	220	Washington Preschool	Special Education School	No	Prekindergarten	PK	PK	2020	grade_6	0	0
1200052	UT	school	4901200	35	District	Weber District	490120001249	179	Canyon View Preschool	Special Education School	No	Prekindergarten	PK	PK	2020	grade_6	0	0
1357545	UT	school	4900060	02	District	Beaver District	490006001257	100	Beaver Preschool	Special Education School	No	Prekindergarten	PK	PK	2021	grade_6	0	0
1357575	UT	school	4900120	04	District	Cache District	490012001251	600	Cache Preschool	Special Education School	No	Prekindergarten	PK	PK	2021	grade_6	0	0
1357642	UT	school	4900142	42	District	Canyons District	490014201309	800	Special Ed Preschool	Special Education School	No	Prekindergarten	PK	PK	2021	grade_6	0	0
1357689	UT	school	4900210	07	District	Davis District	490021000727	802	Family Enrichment Center	Special Education School	No	Prekindergarten	PK	PK	2021	grade_6	0	0
1357786	UT	school	4900330	11	District	Grand District	490033001236	801	C R Sundwall Preschool	Special Education School	No	Prekindergarten	PK	PK	2021	grade_6	0	0
1357888	UT	school	4900390	13	District	Iron District	490039001240	150	Iron County Preschool	Special Education School	No	Prekindergarten	PK	PK	2021	grade_6	0	0
1357894	UT	school	4900390	13	District	Iron District	490039001238	160	Three Peaks Pre School	Special Education School	No	Prekindergarten	PK	PK	2021	grade_6	0	0
1357934	UT	school	4900420	14	District	Jordan District	490042001243	800	Preschool	Special Education School	No	Prekindergarten	PK	PK	2021	grade_6	0	0
1357968	UT	school	4900480	16	District	Kane District	490048001258	100	Kane Preschool	Special Education School	No	Prekindergarten	PK	PK	2021	grade_6	0	0
1357978	UT	school	4900510	39	District	Logan City District	490051001530	114	Logan Early Childhood Center	Regular School	No	Prekindergarten	PK	PK	2021	grade_6	0	0
1357981	UT	school	4900510	39	District	Logan City District	490051001234	113	Riverside Preschool	Special Education School	No	Prekindergarten	PK	PK	2021	grade_6	0	0
1357995	UT	school	4900570	18	District	Morgan District	490057001260	100	Morgan Preschool	Special Education School	No	Prekindergarten	PK	PK	2021	grade_6	0	0
1357998	UT	school	4900570	18	District	Morgan District	490057001567	101	Mountain Green Preschool	Regular School	No	Prekindergarten	PK	PK	2021	grade_6	0	0
1358000	UT	school	4900600	40	District	Murray District	490060001248	140	Early Childhood Center	Special Education School	No	Prekindergarten	PK	PK	2021	grade_6	0	0
1358067	UT	school	4900690	21	District	North Summit District	490069001254	100	North Summit Preschool	Special Education School	No	Prekindergarten	PK	PK	2021	grade_6	0	0
1358093	UT	school	4900750	22	District	Park City District	490075001423	158	Jeremy Ranch Preschool	Special Education School	No	Prekindergarten	PK	PK	2021	grade_6	0	0
1358096	UT	school	4900750	22	District	Park City District	490075001255	150	MPES Preschool	Special Education School	No	Prekindergarten	PK	PK	2021	grade_6	0	0
1358098	UT	school	4900750	22	District	Park City District	490075001409	154	Parley's Park Preschool	Special Education School	No	Prekindergarten	PK	PK	2021	grade_6	0	0
1358100	UT	school	4900750	22	District	Park City District	490075001410	156	Trailside Preschool	Special Education School	No	Prekindergarten	PK	PK	2021	grade_6	0	0
1358103	UT	school	4900780	23	District	Piute District	490078001261	101	Circleville Preschool	Special Education School	No	Prekindergarten	PK	PK	2021	grade_6	0	0
1358105	UT	school	4900780	23	District	Piute District	490078001262	102	Oscarson Preschool	Special Education School	No	Prekindergarten	PK	PK	2021	grade_6	0	0
1358124	UT	school	4900810	38	District	Provo District	490081001233	641	Sunrise Preschool	Special Education School	No	Prekindergarten	PK	PK	2021	grade_6	0	0
1358133	UT	school	4900840	24	District	Rich District	490084001264	150	Rich Preschool	Special Education School	No	Prekindergarten	PK	PK	2021	grade_6	0	0
1358169	UT	school	4900870	36	District	Salt Lake District	490087001230	292	Salt Lake Head Start	Regular School	No	Prekindergarten	PK	PK	2021	grade_6	0	0
1358196	UT	school	4900930	26	District	Sevier District	490093000495	820	Richfield Preschool	Special Education School	No	Prekindergarten	PK	PK	2021	grade_6	0	0
1358222	UT	school	4901050	30	District	Tooele District	490105001246	101	Early Learning Center	Special Education School	No	Prekindergarten	PK	PK	2021	grade_6	0	0
1358253	UT	school	4901080	31	District	Uintah District	490108001247	810	Uintah Specialized Preschool	Special Education School	No	Prekindergarten	PK	PK	2021	grade_6	0	0
1358312	UT	school	4901140	33	District	Washington District	490114000778	220	Washington Preschool	Special Education School	No	Prekindergarten	PK	PK	2021	grade_6	0	0
1358323	UT	school	4901200	35	District	Weber District	490120001249	179	Canyon View Preschool	Special Education School	No	Prekindergarten	PK	PK	2021	grade_6	0	0
1199765	UT	school	4900630	19	District	Nebo District	490063001563	345	Mt. Nebo Middle	Regular School	No	Not reported	M	M	2020	grade_6	0	0
1199556	UT	school	4900360	12	District	Granite District	490036001237	610	Headstart Preschool Special Education	Special Education School	No	Elementary	PK	KG	2020	grade_6	0	0
1200225	UT	school	4900167	7I	Charter	Weber State University Charter Academy	490016701447	100	Weber State University Charter Academy	Regular School	Yes	Elementary	KG	KG	2020	grade_6	0	0
1357819	UT	school	4900360	12	District	Granite District	490036001237	610	Headstart Preschool Special Education	Special Education School	No	Elementary	PK	KG	2021	grade_6	0	0
1358086	UT	school	4900720	37	District	Ogden City District	490072001232	100	Ogden Preschool	Special Education School	No	Elementary	PK	KG	2021	grade_6	0	0
1358499	UT	school	4900167	7I	Charter	Weber State University Charter Academy	490016701447	100	Weber State University Charter Academy	Regular School	Yes	Elementary	KG	KG	2021	grade_6	0	0
1199193	UT	school	4900030	01	District	Alpine District	490003000002	704	American Fork High	Regular School	No	High	10	12	2020	grade_6	0	0
1199204	UT	school	4900030	01	District	Alpine District	490003001538	721	Cedar Valley High	Regular School	No	High	09	12	2020	grade_6	0	0
1199209	UT	school	4900030	01	District	Alpine District	490003000014	840	Dan W. Peterson	Special Education School	No	Other	PK	12	2020	grade_6	3	3
1199225	UT	school	4900030	01	District	Alpine District	490003001419	808	Horizon School	Special Education School	No	Other	PK	12	2020	grade_6	1	1
1199229	UT	school	4900030	01	District	Alpine District	490003000017	708	Lehi High	Regular School	No	High	10	12	2020	grade_6	0	0
1199234	UT	school	4900030	01	District	Alpine District	490003000445	709	Lone Peak High	Regular School	No	High	10	12	2020	grade_6	0	0
1199240	UT	school	4900030	01	District	Alpine District	490003000706	711	Mountain View High	Regular School	No	High	10	12	2020	grade_6	0	0
1199245	UT	school	4900030	01	District	Alpine District	490003000021	712	Orem High	Regular School	No	High	10	12	2020	grade_6	0	0
1199248	UT	school	4900030	01	District	Alpine District	490003000024	716	Pleasant Grove High	Regular School	No	High	10	12	2020	grade_6	0	0
1199250	UT	school	4900030	01	District	Alpine District	490003001435	782	Polaris High School	Alternative School	No	High	09	12	2020	grade_6	0	0
1199251	UT	school	4900030	01	District	Alpine District	490003001553	783	Polaris West High	Regular School	No	High	10	12	2020	grade_6	0	0
1199262	UT	school	4900030	01	District	Alpine District	490003001486	785	Skyridge High School	Regular School	No	High	09	12	2020	grade_6	0	0
1199265	UT	school	4900030	01	District	Alpine District	490003000366	730	Summit High	Alternative School	No	High	08	12	2020	grade_6	0	0
1199269	UT	school	4900030	01	District	Alpine District	490003000362	718	Timpanogos High	Regular School	No	High	10	12	2020	grade_6	0	0
1199275	UT	school	4900030	01	District	Alpine District	490003001293	789	Westlake High	Regular School	No	High	10	12	2020	grade_6	0	0
1199279	UT	school	4900060	02	District	Beaver District	490006000036	704	Beaver High	Regular School	No	High	07	12	2020	grade_6	0	0
1199282	UT	school	4900060	02	District	Beaver District	490006000038	708	Milford High	Regular School	No	High	07	12	2020	grade_6	0	0
1199286	UT	school	4900090	03	District	Box Elder District	490009000043	704	Bear River High	Regular School	No	High	10	12	2020	grade_6	0	0
1199288	UT	school	4900090	03	District	Box Elder District	490009000046	708	Box Elder High	Regular School	No	High	10	12	2020	grade_6	0	0
1199291	UT	school	4900090	03	District	Box Elder District	490009000707	778	Sunrise High School	Alternative School	No	High	07	12	2020	grade_6	0	0
1199312	UT	school	4900120	04	District	Cache District	490012000041	710	Cache Alternative High	Alternative School	No	High	08	12	2020	grade_6	0	0
1199316	UT	school	4900120	04	District	Cache District	490012001512	703	Green Canyon High School	Regular School	No	High	09	12	2020	grade_6	0	0
1199322	UT	school	4900120	04	District	Cache District	490012000792	702	Mountain Crest High	Regular School	No	High	09	12	2020	grade_6	0	0
1199328	UT	school	4900120	04	District	Cache District	490012001487	705	Ridgeline High School	Regular School	No	High	09	12	2020	grade_6	0	0
1199330	UT	school	4900120	04	District	Cache District	490012000083	706	Sky View High	Regular School	No	High	09	12	2020	grade_6	0	0
1199338	UT	school	4900142	42	District	Canyons District	490014200659	702	Alta High	Regular School	No	High	09	12	2020	grade_6	0	0
1199343	UT	school	4900142	42	District	Canyons District	490014200291	705	Brighton High	Regular School	No	High	09	12	2020	grade_6	0	0
1199348	UT	school	4900142	42	District	Canyons District	490014201384	840	Canyons Transition Academy	Special Education School	No	High	12	12	2020	grade_6	0	0
1199350	UT	school	4900142	42	District	Canyons District	490014201428	711	Corner Canyon High	Regular School	No	High	09	12	2020	grade_6	0	0
1199352	UT	school	4900142	42	District	Canyons District	490014201504	750	Diamond Ridge High School	Alternative School	No	High	10	12	2020	grade_6	0	0
1199359	UT	school	4900142	42	District	Canyons District	490014201368	950	Entrada	Regular School	No	Other	03	12	2020	grade_6	1	1
1199362	UT	school	4900142	42	District	Canyons District	490014200305	706	Hillcrest High	Regular School	No	High	09	12	2020	grade_6	0	0
1199364	UT	school	4900142	42	District	Canyons District	490014200307	708	Jordan High	Regular School	No	High	09	12	2020	grade_6	0	0
1199365	UT	school	4900142	42	District	Canyons District	490014200309	810	Jordan Valley School	Special Education School	No	Other	KG	12	2020	grade_6	4	4
1199379	UT	school	4900142	42	District	Canyons District	490014200950	712	South Park Academy	Special Education School	No	High	11	12	2020	grade_6	0	0
1199387	UT	school	4900150	05	District	Carbon District	490015000089	704	Carbon High	Regular School	No	High	09	12	2020	grade_6	0	0
1199389	UT	school	4900150	05	District	Carbon District	490015000088	801	Castle Valley Center	Special Education School	No	Other	PK	12	2020	grade_6	2	2
1199396	UT	school	4900180	06	District	Daggett District	490018000101	704	Manila High	Regular School	No	High	07	12	2020	grade_6	0	0