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 "state" = :p0 and "year" = :p1 and (district_nces_id > :p3 or (district_nces_id = :p3 and rowid > :p2)) order by district_nces_id, rowid 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	white	black	hispanic	native_american	asian	pacific_islander	multiracial	male	female	ell	homeless	low_income	disability	total	white_int	black_int	hispanic_int	native_american_int	asian_int	pacific_islander_int	multiracial_int	male_int	female_int	ell_int	homeless_int	low_income_int	disability_int	total_int
1192916	UT	school	4900008	86	Charter	Pinnacle Canyon Academy	490000800629	100	Pinnacle Canyon Academy	Regular School	Yes	Other	KG	12	2020	k_12_total	348.0	1.0	89.0	10.0	0.0	0.0	8.0	241.0	215.0	0.0	0.0	318.0	135.0	456	348	1	89	10	0	0	8	241	215	0	0	318	135	456
1193953	UT	school	4900008	86	Charter	Pinnacle Canyon Academy	490000800629	100	Pinnacle Canyon Academy	Regular School	Yes	Other	KG	12	2020	kindergarten														23														23
1194990	UT	school	4900008	86	Charter	Pinnacle Canyon Academy	490000800629	100	Pinnacle Canyon Academy	Regular School	Yes	Other	KG	12	2020	grade_1														26														26
1196027	UT	school	4900008	86	Charter	Pinnacle Canyon Academy	490000800629	100	Pinnacle Canyon Academy	Regular School	Yes	Other	KG	12	2020	grade_2														39														39
1197064	UT	school	4900008	86	Charter	Pinnacle Canyon Academy	490000800629	100	Pinnacle Canyon Academy	Regular School	Yes	Other	KG	12	2020	grade_3														27														27
1198101	UT	school	4900008	86	Charter	Pinnacle Canyon Academy	490000800629	100	Pinnacle Canyon Academy	Regular School	Yes	Other	KG	12	2020	grade_4														28														28
1199138	UT	school	4900008	86	Charter	Pinnacle Canyon Academy	490000800629	100	Pinnacle Canyon Academy	Regular School	Yes	Other	KG	12	2020	grade_5														38														38
1200175	UT	school	4900008	86	Charter	Pinnacle Canyon Academy	490000800629	100	Pinnacle Canyon Academy	Regular School	Yes	Other	KG	12	2020	grade_6														40														40
1201212	UT	school	4900008	86	Charter	Pinnacle Canyon Academy	490000800629	100	Pinnacle Canyon Academy	Regular School	Yes	Other	KG	12	2020	grade_7														46														46
1202249	UT	school	4900008	86	Charter	Pinnacle Canyon Academy	490000800629	100	Pinnacle Canyon Academy	Regular School	Yes	Other	KG	12	2020	grade_8														30														30
1203286	UT	school	4900008	86	Charter	Pinnacle Canyon Academy	490000800629	100	Pinnacle Canyon Academy	Regular School	Yes	Other	KG	12	2020	grade_9														45														45
1204323	UT	school	4900008	86	Charter	Pinnacle Canyon Academy	490000800629	100	Pinnacle Canyon Academy	Regular School	Yes	Other	KG	12	2020	grade_10														39														39
1205360	UT	school	4900008	86	Charter	Pinnacle Canyon Academy	490000800629	100	Pinnacle Canyon Academy	Regular School	Yes	Other	KG	12	2020	grade_11														37														37
1206397	UT	school	4900008	86	Charter	Pinnacle Canyon Academy	490000800629	100	Pinnacle Canyon Academy	Regular School	Yes	Other	KG	12	2020	grade_12														38														38
1192860	UT	school	4900009	87	Charter	City Academy	490000900742	700	City Academy	Regular School	Yes	High	07	12	2020	k_12_total	73.0	5.0	56.0	1.0	4.0	0.0	9.0	76.0	72.0	22.0	0.0	68.0	30.0	148	73	5	56	1	4	0	9	76	72	22	0	68	30	148
1193897	UT	school	4900009	87	Charter	City Academy	490000900742	700	City Academy	Regular School	Yes	High	07	12	2020	kindergarten														0														0
1194934	UT	school	4900009	87	Charter	City Academy	490000900742	700	City Academy	Regular School	Yes	High	07	12	2020	grade_1														0														0
1195971	UT	school	4900009	87	Charter	City Academy	490000900742	700	City Academy	Regular School	Yes	High	07	12	2020	grade_2														0														0
1197008	UT	school	4900009	87	Charter	City Academy	490000900742	700	City Academy	Regular School	Yes	High	07	12	2020	grade_3														0														0
1198045	UT	school	4900009	87	Charter	City Academy	490000900742	700	City Academy	Regular School	Yes	High	07	12	2020	grade_4														0														0
1199082	UT	school	4900009	87	Charter	City Academy	490000900742	700	City Academy	Regular School	Yes	High	07	12	2020	grade_5														0														0
1200119	UT	school	4900009	87	Charter	City Academy	490000900742	700	City Academy	Regular School	Yes	High	07	12	2020	grade_6														0														0
1201156	UT	school	4900009	87	Charter	City Academy	490000900742	700	City Academy	Regular School	Yes	High	07	12	2020	grade_7														16														16
1202193	UT	school	4900009	87	Charter	City Academy	490000900742	700	City Academy	Regular School	Yes	High	07	12	2020	grade_8														29														29
1203230	UT	school	4900009	87	Charter	City Academy	490000900742	700	City Academy	Regular School	Yes	High	07	12	2020	grade_9														30														30
1204267	UT	school	4900009	87	Charter	City Academy	490000900742	700	City Academy	Regular School	Yes	High	07	12	2020	grade_10														34														34
1205304	UT	school	4900009	87	Charter	City Academy	490000900742	700	City Academy	Regular School	Yes	High	07	12	2020	grade_11														21														21
1206341	UT	school	4900009	87	Charter	City Academy	490000900742	700	City Academy	Regular School	Yes	High	07	12	2020	grade_12														18														18
1192930	UT	school	4900011	89	Charter	Soldier Hollow Charter School	490001100587	100	Soldier Hollow Charter School	Regular School	Yes	Elementary	KG	08	2020	k_12_total	286.0	0.0	16.0	1.0	4.0	1.0	16.0	197.0	127.0	0.0	0.0	27.0	56.0	324	286	0	16	1	4	1	16	197	127	0	0	27	56	324
1193967	UT	school	4900011	89	Charter	Soldier Hollow Charter School	490001100587	100	Soldier Hollow Charter School	Regular School	Yes	Elementary	KG	08	2020	kindergarten														31														31
1195004	UT	school	4900011	89	Charter	Soldier Hollow Charter School	490001100587	100	Soldier Hollow Charter School	Regular School	Yes	Elementary	KG	08	2020	grade_1														44														44
1196041	UT	school	4900011	89	Charter	Soldier Hollow Charter School	490001100587	100	Soldier Hollow Charter School	Regular School	Yes	Elementary	KG	08	2020	grade_2														46														46
1197078	UT	school	4900011	89	Charter	Soldier Hollow Charter School	490001100587	100	Soldier Hollow Charter School	Regular School	Yes	Elementary	KG	08	2020	grade_3														40														40
1198115	UT	school	4900011	89	Charter	Soldier Hollow Charter School	490001100587	100	Soldier Hollow Charter School	Regular School	Yes	Elementary	KG	08	2020	grade_4														43														43
1199152	UT	school	4900011	89	Charter	Soldier Hollow Charter School	490001100587	100	Soldier Hollow Charter School	Regular School	Yes	Elementary	KG	08	2020	grade_5														36														36
1200189	UT	school	4900011	89	Charter	Soldier Hollow Charter School	490001100587	100	Soldier Hollow Charter School	Regular School	Yes	Elementary	KG	08	2020	grade_6														37														37
1201226	UT	school	4900011	89	Charter	Soldier Hollow Charter School	490001100587	100	Soldier Hollow Charter School	Regular School	Yes	Elementary	KG	08	2020	grade_7														27														27
1202263	UT	school	4900011	89	Charter	Soldier Hollow Charter School	490001100587	100	Soldier Hollow Charter School	Regular School	Yes	Elementary	KG	08	2020	grade_8														20														20
1203300	UT	school	4900011	89	Charter	Soldier Hollow Charter School	490001100587	100	Soldier Hollow Charter School	Regular School	Yes	Elementary	KG	08	2020	grade_9														0														0
1204337	UT	school	4900011	89	Charter	Soldier Hollow Charter School	490001100587	100	Soldier Hollow Charter School	Regular School	Yes	Elementary	KG	08	2020	grade_10														0														0
1205374	UT	school	4900011	89	Charter	Soldier Hollow Charter School	490001100587	100	Soldier Hollow Charter School	Regular School	Yes	Elementary	KG	08	2020	grade_11														0														0
1206411	UT	school	4900011	89	Charter	Soldier Hollow Charter School	490001100587	100	Soldier Hollow Charter School	Regular School	Yes	Elementary	KG	08	2020	grade_12														0														0
1192948	UT	school	4900012	90	Charter	Tuacahn High School for the Performing Arts	490001200673	700	Tuacahn High School for the Performing Arts	Regular School	Yes	High	09	12	2020	k_12_total	336.0	8.0	44.0	3.0	2.0	3.0	3.0	146.0	253.0	0.0	0.0	147.0	35.0	399	336	8	44	3	2	3	3	146	253	0	0	147	35	399
1193985	UT	school	4900012	90	Charter	Tuacahn High School for the Performing Arts	490001200673	700	Tuacahn High School for the Performing Arts	Regular School	Yes	High	09	12	2020	kindergarten														0														0
1195022	UT	school	4900012	90	Charter	Tuacahn High School for the Performing Arts	490001200673	700	Tuacahn High School for the Performing Arts	Regular School	Yes	High	09	12	2020	grade_1														0														0
1196059	UT	school	4900012	90	Charter	Tuacahn High School for the Performing Arts	490001200673	700	Tuacahn High School for the Performing Arts	Regular School	Yes	High	09	12	2020	grade_2														0														0
1197096	UT	school	4900012	90	Charter	Tuacahn High School for the Performing Arts	490001200673	700	Tuacahn High School for the Performing Arts	Regular School	Yes	High	09	12	2020	grade_3														0														0
1198133	UT	school	4900012	90	Charter	Tuacahn High School for the Performing Arts	490001200673	700	Tuacahn High School for the Performing Arts	Regular School	Yes	High	09	12	2020	grade_4														0														0
1199170	UT	school	4900012	90	Charter	Tuacahn High School for the Performing Arts	490001200673	700	Tuacahn High School for the Performing Arts	Regular School	Yes	High	09	12	2020	grade_5														0														0
1200207	UT	school	4900012	90	Charter	Tuacahn High School for the Performing Arts	490001200673	700	Tuacahn High School for the Performing Arts	Regular School	Yes	High	09	12	2020	grade_6														0														0
1201244	UT	school	4900012	90	Charter	Tuacahn High School for the Performing Arts	490001200673	700	Tuacahn High School for the Performing Arts	Regular School	Yes	High	09	12	2020	grade_7														0														0
1202281	UT	school	4900012	90	Charter	Tuacahn High School for the Performing Arts	490001200673	700	Tuacahn High School for the Performing Arts	Regular School	Yes	High	09	12	2020	grade_8														0														0
1203318	UT	school	4900012	90	Charter	Tuacahn High School for the Performing Arts	490001200673	700	Tuacahn High School for the Performing Arts	Regular School	Yes	High	09	12	2020	grade_9														114														114
1204355	UT	school	4900012	90	Charter	Tuacahn High School for the Performing Arts	490001200673	700	Tuacahn High School for the Performing Arts	Regular School	Yes	High	09	12	2020	grade_10														113														113
1205392	UT	school	4900012	90	Charter	Tuacahn High School for the Performing Arts	490001200673	700	Tuacahn High School for the Performing Arts	Regular School	Yes	High	09	12	2020	grade_11														78														78
1206429	UT	school	4900012	90	Charter	Tuacahn High School for the Performing Arts	490001200673	700	Tuacahn High School for the Performing Arts	Regular School	Yes	High	09	12	2020	grade_12														94														94
1192949	UT	school	4900013	92	Charter	Uintah River High	490001300671	700	Uintah River High	Alternative School	Yes	High	09	12	2020	k_12_total	7.0	0.0	5.0	55.0	0.0	0.0	8.0	38.0	37.0	0.0	0.0	37.0	8.0	75	7	0	5	55	0	0	8	38	37	0	0	37	8	75
1193986	UT	school	4900013	92	Charter	Uintah River High	490001300671	700	Uintah River High	Alternative School	Yes	High	09	12	2020	kindergarten														0														0
1195023	UT	school	4900013	92	Charter	Uintah River High	490001300671	700	Uintah River High	Alternative School	Yes	High	09	12	2020	grade_1														0														0
1196060	UT	school	4900013	92	Charter	Uintah River High	490001300671	700	Uintah River High	Alternative School	Yes	High	09	12	2020	grade_2														0														0
1197097	UT	school	4900013	92	Charter	Uintah River High	490001300671	700	Uintah River High	Alternative School	Yes	High	09	12	2020	grade_3														0														0
1198134	UT	school	4900013	92	Charter	Uintah River High	490001300671	700	Uintah River High	Alternative School	Yes	High	09	12	2020	grade_4														0														0
1199171	UT	school	4900013	92	Charter	Uintah River High	490001300671	700	Uintah River High	Alternative School	Yes	High	09	12	2020	grade_5														0														0
1200208	UT	school	4900013	92	Charter	Uintah River High	490001300671	700	Uintah River High	Alternative School	Yes	High	09	12	2020	grade_6														0														0
1201245	UT	school	4900013	92	Charter	Uintah River High	490001300671	700	Uintah River High	Alternative School	Yes	High	09	12	2020	grade_7														0														0
1202282	UT	school	4900013	92	Charter	Uintah River High	490001300671	700	Uintah River High	Alternative School	Yes	High	09	12	2020	grade_8														0														0
1203319	UT	school	4900013	92	Charter	Uintah River High	490001300671	700	Uintah River High	Alternative School	Yes	High	09	12	2020	grade_9														15														15
1204356	UT	school	4900013	92	Charter	Uintah River High	490001300671	700	Uintah River High	Alternative School	Yes	High	09	12	2020	grade_10														20														20
1205393	UT	school	4900013	92	Charter	Uintah River High	490001300671	700	Uintah River High	Alternative School	Yes	High	09	12	2020	grade_11														20														20
1206430	UT	school	4900013	92	Charter	Uintah River High	490001300671	700	Uintah River High	Alternative School	Yes	High	09	12	2020	grade_12														20														20
1192888	UT	school	4900014	93	Charter	John Hancock Charter School	490001400811	105	John Hancock Charter School	Regular School	Yes	Elementary	KG	06	2020	k_12_total	135.0	0.0	11.0	0.0	0.0	0.0	13.0	78.0	81.0	0.0	0.0	79.0	32.0	159	135	0	11	0	0	0	13	78	81	0	0	79	32	159
1193925	UT	school	4900014	93	Charter	John Hancock Charter School	490001400811	105	John Hancock Charter School	Regular School	Yes	Elementary	KG	06	2020	kindergarten														21														21
1194962	UT	school	4900014	93	Charter	John Hancock Charter School	490001400811	105	John Hancock Charter School	Regular School	Yes	Elementary	KG	06	2020	grade_1														23														23
1195999	UT	school	4900014	93	Charter	John Hancock Charter School	490001400811	105	John Hancock Charter School	Regular School	Yes	Elementary	KG	06	2020	grade_2														24														24
1197036	UT	school	4900014	93	Charter	John Hancock Charter School	490001400811	105	John Hancock Charter School	Regular School	Yes	Elementary	KG	06	2020	grade_3														23														23
1198073	UT	school	4900014	93	Charter	John Hancock Charter School	490001400811	105	John Hancock Charter School	Regular School	Yes	Elementary	KG	06	2020	grade_4														23														23
1199110	UT	school	4900014	93	Charter	John Hancock Charter School	490001400811	105	John Hancock Charter School	Regular School	Yes	Elementary	KG	06	2020	grade_5														22														22
1200147	UT	school	4900014	93	Charter	John Hancock Charter School	490001400811	105	John Hancock Charter School	Regular School	Yes	Elementary	KG	06	2020	grade_6														23														23
1201184	UT	school	4900014	93	Charter	John Hancock Charter School	490001400811	105	John Hancock Charter School	Regular School	Yes	Elementary	KG	06	2020	grade_7														0														0
1202221	UT	school	4900014	93	Charter	John Hancock Charter School	490001400811	105	John Hancock Charter School	Regular School	Yes	Elementary	KG	06	2020	grade_8														0														0
1203258	UT	school	4900014	93	Charter	John Hancock Charter School	490001400811	105	John Hancock Charter School	Regular School	Yes	Elementary	KG	06	2020	grade_9														0														0
1204295	UT	school	4900014	93	Charter	John Hancock Charter School	490001400811	105	John Hancock Charter School	Regular School	Yes	Elementary	KG	06	2020	grade_10														0														0
1205332	UT	school	4900014	93	Charter	John Hancock Charter School	490001400811	105	John Hancock Charter School	Regular School	Yes	Elementary	KG	06	2020	grade_11														0														0
1206369	UT	school	4900014	93	Charter	John Hancock Charter School	490001400811	105	John Hancock Charter School	Regular School	Yes	Elementary	KG	06	2020	grade_12														0														0
1192944	UT	school	4900015	94	Charter	Thomas Edison	490001500820	100	Thomas Edison	Regular School	Yes	Elementary	KG	08	2020	k_12_total	356.0	9.0	114.0	6.0	18.0	14.0	9.0	247.0	279.0	19.0	0.0	118.0	98.0	526	356	9	114	6	18	14	9	247	279	19	0	118	98	526
1192945	UT	school	4900015	94	Charter	Thomas Edison	490001501284	110	Thomas Edison - South	Regular School	Yes	Elementary	KG	08	2020	k_12_total	476.0	7.0	107.0	0.0	15.0	4.0	7.0	295.0	321.0	19.0	0.0	194.0	114.0	616	476	7	107	0	15	4	7	295	321	19	0	194	114	616
1193981	UT	school	4900015	94	Charter	Thomas Edison	490001500820	100	Thomas Edison	Regular School	Yes	Elementary	KG	08	2020	kindergarten														58														58
1193982	UT	school	4900015	94	Charter	Thomas Edison	490001501284	110	Thomas Edison - South	Regular School	Yes	Elementary	KG	08	2020	kindergarten														62														62
1195018	UT	school	4900015	94	Charter	Thomas Edison	490001500820	100	Thomas Edison	Regular School	Yes	Elementary	KG	08	2020	grade_1														60														60
1195019	UT	school	4900015	94	Charter	Thomas Edison	490001501284	110	Thomas Edison - South	Regular School	Yes	Elementary	KG	08	2020	grade_1														72														72
1196055	UT	school	4900015	94	Charter	Thomas Edison	490001500820	100	Thomas Edison	Regular School	Yes	Elementary	KG	08	2020	grade_2														60														60
1196056	UT	school	4900015	94	Charter	Thomas Edison	490001501284	110	Thomas Edison - South	Regular School	Yes	Elementary	KG	08	2020	grade_2														65														65
1197092	UT	school	4900015	94	Charter	Thomas Edison	490001500820	100	Thomas Edison	Regular School	Yes	Elementary	KG	08	2020	grade_3														54														54
1197093	UT	school	4900015	94	Charter	Thomas Edison	490001501284	110	Thomas Edison - South	Regular School	Yes	Elementary	KG	08	2020	grade_3														65														65
1198129	UT	school	4900015	94	Charter	Thomas Edison	490001500820	100	Thomas Edison	Regular School	Yes	Elementary	KG	08	2020	grade_4														59														59
1198130	UT	school	4900015	94	Charter	Thomas Edison	490001501284	110	Thomas Edison - South	Regular School	Yes	Elementary	KG	08	2020	grade_4														71														71
1199166	UT	school	4900015	94	Charter	Thomas Edison	490001500820	100	Thomas Edison	Regular School	Yes	Elementary	KG	08	2020	grade_5														60														60
1199167	UT	school	4900015	94	Charter	Thomas Edison	490001501284	110	Thomas Edison - South	Regular School	Yes	Elementary	KG	08	2020	grade_5														70														70
1200203	UT	school	4900015	94	Charter	Thomas Edison	490001500820	100	Thomas Edison	Regular School	Yes	Elementary	KG	08	2020	grade_6														59														59
1200204	UT	school	4900015	94	Charter	Thomas Edison	490001501284	110	Thomas Edison - South	Regular School	Yes	Elementary	KG	08	2020	grade_6														75														75
1201240	UT	school	4900015	94	Charter	Thomas Edison	490001500820	100	Thomas Edison	Regular School	Yes	Elementary	KG	08	2020	grade_7														61														61