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 (district_nces_id > :p2 or (district_nces_id = :p2 and rowid > :p1)) 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
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
1351062	UT	school	4900009	87	Charter	City Academy	490000900742	700	City Academy	Regular School	Yes	High	07	12	2021	k_12_total	69.0	2.0	58.0	0.0	2.0	0.0	5.0	68.0	68.0	14.0	0.0	64.0	33.0	136	69	2	58	0	2	0	5	68	68	14	0	64	33	136
1352109	UT	school	4900009	87	Charter	City Academy	490000900742	700	City Academy	Regular School	Yes	High	07	12	2021	kindergarten														0														0
1353156	UT	school	4900009	87	Charter	City Academy	490000900742	700	City Academy	Regular School	Yes	High	07	12	2021	grade_1														0														0
1354203	UT	school	4900009	87	Charter	City Academy	490000900742	700	City Academy	Regular School	Yes	High	07	12	2021	grade_2														0														0
1355250	UT	school	4900009	87	Charter	City Academy	490000900742	700	City Academy	Regular School	Yes	High	07	12	2021	grade_3														0														0
1356297	UT	school	4900009	87	Charter	City Academy	490000900742	700	City Academy	Regular School	Yes	High	07	12	2021	grade_4														0														0
1357344	UT	school	4900009	87	Charter	City Academy	490000900742	700	City Academy	Regular School	Yes	High	07	12	2021	grade_5														0														0
1358391	UT	school	4900009	87	Charter	City Academy	490000900742	700	City Academy	Regular School	Yes	High	07	12	2021	grade_6														0														0
1359438	UT	school	4900009	87	Charter	City Academy	490000900742	700	City Academy	Regular School	Yes	High	07	12	2021	grade_7														18														18
1360485	UT	school	4900009	87	Charter	City Academy	490000900742	700	City Academy	Regular School	Yes	High	07	12	2021	grade_8														17														17
1361532	UT	school	4900009	87	Charter	City Academy	490000900742	700	City Academy	Regular School	Yes	High	07	12	2021	grade_9														33														33
1362579	UT	school	4900009	87	Charter	City Academy	490000900742	700	City Academy	Regular School	Yes	High	07	12	2021	grade_10														20														20
1363626	UT	school	4900009	87	Charter	City Academy	490000900742	700	City Academy	Regular School	Yes	High	07	12	2021	grade_11														30														30
1364673	UT	school	4900009	87	Charter	City Academy	490000900742	700	City Academy	Regular School	Yes	High	07	12	2021	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
1351134	UT	school	4900011	89	Charter	Soldier Hollow Charter School	490001100587	100	Soldier Hollow Charter School	Regular School	Yes	Elementary	PK	08	2021	k_12_total	259.0	0.0	20.0	1.0	1.0	0.0	15.0	165.0	131.0	0.0	0.0	46.0	46.0	296	259	0	20	1	1	0	15	165	131	0	0	46	46	296
1352181	UT	school	4900011	89	Charter	Soldier Hollow Charter School	490001100587	100	Soldier Hollow Charter School	Regular School	Yes	Elementary	PK	08	2021	kindergarten														30														30
1353228	UT	school	4900011	89	Charter	Soldier Hollow Charter School	490001100587	100	Soldier Hollow Charter School	Regular School	Yes	Elementary	PK	08	2021	grade_1														29														29
1354275	UT	school	4900011	89	Charter	Soldier Hollow Charter School	490001100587	100	Soldier Hollow Charter School	Regular School	Yes	Elementary	PK	08	2021	grade_2														40														40
1355322	UT	school	4900011	89	Charter	Soldier Hollow Charter School	490001100587	100	Soldier Hollow Charter School	Regular School	Yes	Elementary	PK	08	2021	grade_3														41														41
1356369	UT	school	4900011	89	Charter	Soldier Hollow Charter School	490001100587	100	Soldier Hollow Charter School	Regular School	Yes	Elementary	PK	08	2021	grade_4														36														36
1357416	UT	school	4900011	89	Charter	Soldier Hollow Charter School	490001100587	100	Soldier Hollow Charter School	Regular School	Yes	Elementary	PK	08	2021	grade_5														43														43
1358463	UT	school	4900011	89	Charter	Soldier Hollow Charter School	490001100587	100	Soldier Hollow Charter School	Regular School	Yes	Elementary	PK	08	2021	grade_6														28														28
1359510	UT	school	4900011	89	Charter	Soldier Hollow Charter School	490001100587	100	Soldier Hollow Charter School	Regular School	Yes	Elementary	PK	08	2021	grade_7														30														30
1360557	UT	school	4900011	89	Charter	Soldier Hollow Charter School	490001100587	100	Soldier Hollow Charter School	Regular School	Yes	Elementary	PK	08	2021	grade_8														19														19
1361604	UT	school	4900011	89	Charter	Soldier Hollow Charter School	490001100587	100	Soldier Hollow Charter School	Regular School	Yes	Elementary	PK	08	2021	grade_9														0														0
1362651	UT	school	4900011	89	Charter	Soldier Hollow Charter School	490001100587	100	Soldier Hollow Charter School	Regular School	Yes	Elementary	PK	08	2021	grade_10														0														0
1363698	UT	school	4900011	89	Charter	Soldier Hollow Charter School	490001100587	100	Soldier Hollow Charter School	Regular School	Yes	Elementary	PK	08	2021	grade_11														0														0
1364745	UT	school	4900011	89	Charter	Soldier Hollow Charter School	490001100587	100	Soldier Hollow Charter School	Regular School	Yes	Elementary	PK	08	2021	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
1351152	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	2021	k_12_total	279.0	7.0	50.0	2.0	2.0	7.0	4.0	140.0	211.0	0.0	1.0	113.0	23.0	351	279	7	50	2	2	7	4	140	211	0	1	113	23	351
1352199	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	2021	kindergarten														0														0
1353246	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	2021	grade_1														0														0
1354293	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	2021	grade_2														0														0
1355340	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	2021	grade_3														0														0
1356387	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	2021	grade_4														0														0
1357434	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	2021	grade_5														0														0
1358481	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	2021	grade_6														0														0
1359528	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	2021	grade_7														0														0
1360575	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	2021	grade_8														0														0
1361622	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	2021	grade_9														60														60
1362669	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	2021	grade_10														103														103
1363716	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	2021	grade_11														112														112
1364763	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	2021	grade_12														76														76
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
1351153	UT	school	4900013	92	Charter	Uintah River High	490001300671	700	Uintah River High	Alternative School	Yes	High	09	12	2021	k_12_total	2.0	0.0	3.0	50.0	0.0	0.0	9.0	32.0	32.0	0.0	10.0	35.0	7.0	64	2	0	3	50	0	0	9	32	32	0	10	35	7	64
1352200	UT	school	4900013	92	Charter	Uintah River High	490001300671	700	Uintah River High	Alternative School	Yes	High	09	12	2021	kindergarten														0														0
1353247	UT	school	4900013	92	Charter	Uintah River High	490001300671	700	Uintah River High	Alternative School	Yes	High	09	12	2021	grade_1														0														0
1354294	UT	school	4900013	92	Charter	Uintah River High	490001300671	700	Uintah River High	Alternative School	Yes	High	09	12	2021	grade_2														0														0
1355341	UT	school	4900013	92	Charter	Uintah River High	490001300671	700	Uintah River High	Alternative School	Yes	High	09	12	2021	grade_3														0														0
1356388	UT	school	4900013	92	Charter	Uintah River High	490001300671	700	Uintah River High	Alternative School	Yes	High	09	12	2021	grade_4														0														0
1357435	UT	school	4900013	92	Charter	Uintah River High	490001300671	700	Uintah River High	Alternative School	Yes	High	09	12	2021	grade_5														0														0