schools: enrollments: 1,037 rows where where grade = "grade_8", state = "UT" and year = 2020 sorted by rowid descending

Data source: Big Local News · About: Big Local

1,037 rows where grade = "grade_8", state = "UT" and year = 2020 sorted by rowid descending

Search:

descending

Link	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
1202301	1202301	UT	school	4900168	8I	Charter	Winter Sports School	490016801444	700	Winter Sports School	Regular School	Yes	High	09	12	2020	grade_8	0	0
1202300	1202300	UT	school	4900145	6G	Charter	Weilenmann School of Discovery	490014501378	100	Weilenmann School of Discovery	Regular School	Yes	Elementary	KG	08	2020	grade_8	51	51
1202299	1202299	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_8	0	0
1202298	1202298	UT	school	4900185	5K	Charter	Wasatch Waldorf Charter School	490018501491	300	Wasatch Waldorf Charter School	Regular School	Yes	Elementary	KG	08	2020	grade_8	53	53
1202297	1202297	UT	school	4900024	4B	Charter	Wasatch Peak Academy	490002401107	100	Wasatch Peak Academy	Regular School	Yes	Elementary	KG	06	2020	grade_8	0	0
1202296	1202296	UT	school	4900184	7K	Charter	Wallace Stegner Academy	490018401489	300	Wallace Stegner Academy	Regular School	Yes	Elementary	KG	08	2020	grade_8	61	61
1202295	1202295	UT	school	4900061	81	Charter	Walden School of Liberal Arts	490006100991	300	Walden School of Liberal Arts	Regular School	Yes	Other	KG	12	2020	grade_8	37	37
1202294	1202294	UT	school	4900160	5I	Charter	Voyage Academy	490016001442	100	Voyage Academy	Regular School	Yes	Elementary	KG	06	2020	grade_8	0	0
1202293	1202293	UT	school	4900141	2G	Charter	Vista School	490014101296	100	Vista School	Regular School	Yes	Elementary	KG	08	2020	grade_8	107	107
1202292	1202292	UT	school	4900133	3F	Charter	Venture Academy	490013301216	100	Venture Academy	Regular School	Yes	Other	KG	12	2020	grade_8	50	50
1202291	1202291	UT	school	4900183	1K	Charter	Vanguard Academy	490018301475	700	Vanguard Academy	Regular School	Yes	High	07	12	2020	grade_8	81	81
1202290	1202290	UT	school	4900158	8H	Charter	Valley Academy	490015801421	100	Valley Academy	Regular School	Yes	Elementary	KG	08	2020	grade_8	36	36
1202289	1202289	UT	school	4900130	5F	Charter	Utah Virtual Academy	490013001196	700	Utah Virtual Academy	Regular School	Yes	Other	KG	12	2020	grade_8	269	269
1202288	1202288	UT	school	4900176	2K	Charter	Utah Military Academy	490017601501	710	Utah Military Academy - Camp Williams	Regular School	Yes	High	07	12	2020	grade_8	107	107
1202287	1202287	UT	school	4900176	2K	Charter	Utah Military Academy	490017601463	700	Utah Military Academy	Regular School	Yes	High	07	12	2020	grade_8	117	117
1202286	1202286	UT	school	4900166	1I	Charter	Utah International Charter School	490016601433	700	Utah International Charter School	Regular School	Yes	High	07	12	2020	grade_8	25	25
1202285	1202285	UT	school	4900020	1B	Charter	Utah County Academy of Science	490002001106	700	Utah County Academy of Science	Regular School	Yes	High	09	12	2020	grade_8	0	0
1202284	1202284	UT	school	4900151	2H	Charter	Utah Connections Academy	490015101386	101	Utah Connections Academy	Regular School	Yes	Other	KG	12	2020	grade_8	119	119
1202283	1202283	UT	school	4900171	9I	Charter	Utah Career Path High School	490017101460	600	Utah Career Path High School	Regular School	Yes	High	09	12	2020	grade_8	0	0
1202282	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
1202281	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
1202280	1202280	UT	school	4900192	7L	Charter	Treeside Charter School	490019201514	110	Treeside Charter School	Regular School	Yes	Elementary	KG	06	2020	grade_8	0	0
1202279	1202279	UT	school	4900016	95	Charter	Timpanogos Academy	490001600830	110	Timpanogos Academy	Regular School	Yes	Elementary	KG	06	2020	grade_8	0	0
1202278	1202278	UT	school	4900015	94	Charter	Thomas Edison	490001501284	110	Thomas Edison - South	Regular School	Yes	Elementary	KG	08	2020	grade_8	61	61
1202277	1202277	UT	school	4900015	94	Charter	Thomas Edison	490001500820	100	Thomas Edison	Regular School	Yes	Elementary	KG	08	2020	grade_8	55	55
1202276	1202276	UT	school	4900193	2L	Charter	The Center for Creativity Innovation and Discovery	490019301513	300	The Center for Creativity Innovation and Discovery	Regular School	Yes	Elementary	KG	08	2020	grade_8	54	54
1202275	1202275	UT	school	4900179	8J	Charter	Terra Academy	490017901476	300	Terra Academy	Regular School	Yes	Other	KG	12	2020	grade_8	50	50
1202274	1202274	UT	school	4900044	4D	Charter	Syracuse Arts Academy	490004401494	110	Syracuse Arts Academy - North	Regular School	Yes	Elementary	KG	06	2020	grade_8	0	0
1202273	1202273	UT	school	4900044	4D	Charter	Syracuse Arts Academy	490004401145	100	Syracuse Arts Academy	Regular School	Yes	Other	KG	09	2020	grade_8	157	157
1202272	1202272	UT	school	4900148	7G	Charter	Summit Academy High School	490014801396	700	Summit Academy High School	Regular School	Yes	High	09	12	2020	grade_8	0	0
1202271	1202271	UT	school	4900066	A4	Charter	Summit Academy	490006601469	300	Summit Academy - Independence	Regular School	Yes	Elementary	KG	08	2020	grade_8	122	122
1202270	1202270	UT	school	4900066	A4	Charter	Summit Academy	490006600996	100	Summit Academy	Regular School	Yes	Elementary	KG	08	2020	grade_8	118	118
1202269	1202269	UT	school	4900066	A4	Charter	Summit Academy	490006601499	310	Summit Academy - Bluffdale	Regular School	Yes	Elementary	KG	06	2020	grade_8	0	0
1202268	1202268	UT	school	4900037	A9	Charter	Success Academy	490003701101	700	Success Academy	Regular School	Yes	High	09	12	2020	grade_8	0	0
1202267	1202267	UT	school	4900037	A9	Charter	Success Academy	490003701470	710	Success DSU	Regular School	Yes	High	10	12	2020	grade_8	0	0
1202266	1202266	UT	school	4900188	9K	Charter	St. George Academy	490018801485	700	St. George Academy	Regular School	Yes	High	08	12	2020	grade_8	47	47
1202265	1202265	UT	school	4900042	3D	Charter	Spectrum Academy	490004201464	300	Spectrum Academy - Pleasant Grove	Regular School	Yes	Other	KG	12	2020	grade_8	57	57
1202264	1202264	UT	school	4900042	3D	Charter	Spectrum Academy	490004201137	100	Spectrum Academy	Regular School	Yes	Other	KG	12	2020	grade_8	66	66
1202263	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
1202262	1202262	UT	school	4900170	6J	Charter	Scholar Academy	490017001456	100	Scholar Academy	Regular School	Yes	Elementary	KG	08	2020	grade_8	48	48
1202261	1202261	UT	school	4900050	7D	Charter	Salt Lake School for the Performing Arts	490005001151	700	Salt Lake School for the Performing Arts	Regular School	Yes	High	09	12	2020	grade_8	0	0
1202260	1202260	UT	school	4900123	4F	Charter	Salt Lake Center for Science Education	490012301208	300	Salt Lake Center for Science Education	Regular School	Yes	High	07	12	2020	grade_8	60	60
1202259	1202259	UT	school	4900018	97	Charter	Salt Lake Arts Academy	490001800905	300	Salt Lake Arts Academy	Regular School	Yes	Middle	05	08	2020	grade_8	103	103
1202258	1202258	UT	school	4900178	3K	Charter	Roots Charter High School	490017801477	700	Roots Charter High School	Regular School	Yes	High	09	12	2020	grade_8	0	0
1202257	1202257	UT	school	4900125	2F	Charter	Rockwell Charter High School	490012501199	700	Rockwell Charter High School	Regular School	Yes	High	07	12	2020	grade_8	31	31
1202256	1202256	UT	school	4900038	1D	Charter	Renaissance Academy	490003801128	100	Renaissance Academy	Regular School	Yes	Elementary	KG	08	2020	grade_8	32	32
1202255	1202255	UT	school	4900197	8L	Charter	Real Salt Lake Academy High School	490019701517	700	Real Salt Lake Academy High School	Regular School	Yes	High	09	12	2020	grade_8	0	0
1202254	1202254	UT	school	4900032	7B	Charter	Reagan Academy	490003201095	100	Reagan Academy	Regular School	Yes	Elementary	KG	08	2020	grade_8	57	57
1202253	1202253	UT	school	4900064	A2	Charter	Ranches Academy	490006400994	100	Ranches Academy	Regular School	Yes	Elementary	KG	06	2020	grade_8	0	0
1202252	1202252	UT	school	4900132	1F	Charter	Quest Academy	490013201218	100	Quest Academy	Regular School	Yes	Other	KG	09	2020	grade_8	60	60
1202251	1202251	UT	school	4900124	9E	Charter	Providence Hall	490012401202	100	Providence Hall	Regular School	Yes	Other	KG	12	2020	grade_8	224	224
1202250	1202250	UT	school	4900157	6H	Charter	Promontory School of Expeditionary Learning	490015701416	100	Promontory School of Expeditionary Learning	Regular School	Yes	Elementary	KG	08	2020	grade_8	31	31
1202249	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
1202248	1202248	UT	school	4900052	9C	Charter	Paradigm High School	490005201153	700	Paradigm High School	Regular School	Yes	High	07	12	2020	grade_8	50	50
1202247	1202247	UT	school	4900159	7H	Charter	Pacific Heritage Academy	490015901406	100	Pacific Heritage Academy	Regular School	Yes	Elementary	KG	08	2020	grade_8	46	46
1202246	1202246	UT	school	4900118	8D	Charter	Open Classroom	490011801135	240	Open Classroom	Regular School	Yes	Elementary	KG	08	2020	grade_8	21	21
1202245	1202245	UT	school	4900058	68	Charter	Ogden Preparatory Academy	490005800989	100	Ogden Preparatory Academy	Regular School	Yes	Other	KG	09	2020	grade_8	115	115
1202244	1202244	UT	school	4900021	1C	Charter	Odyssey Charter School	490002101092	100	Odyssey Charter School	Regular School	Yes	Elementary	KG	06	2020	grade_8	0	0
1202243	1202243	UT	school	4900025	5B	Charter	North Star Academy	490002501089	100	North Star Academy	Regular School	Yes	Other	KG	09	2020	grade_8	64	64
1202242	1202242	UT	school	4900068	A6	Charter	North Davis Preparatory Academy	490006800998	100	North Davis Preparatory Academy	Regular School	Yes	Other	KG	09	2020	grade_8	87	87
1202241	1202241	UT	school	4900048	6D	Charter	Noah Webster Academy	490004801149	100	Noah Webster Academy	Regular School	Yes	Elementary	KG	06	2020	grade_8	0	0
1202240	1202240	UT	school	4900063	A1	Charter	No. UT. Acad. for Math Engineering & Science	490006301528	705	No. UT. Acad. of Math Engineering & Science - Ogden	Regular School	Yes	High	10	12	2020	grade_8	0	0
1202239	1202239	UT	school	4900063	A1	Charter	No. UT. Acad. for Math Engineering & Science	490006300993	700	No. UT. Acad. for Math Engineering & Science	Regular School	Yes	High	10	12	2020	grade_8	0	0
1202238	1202238	UT	school	4900034	9B	Charter	Navigator Pointe Academy	490003401088	100	Navigator Pointe Academy	Regular School	Yes	Other	KG	09	2020	grade_8	27	27
1202237	1202237	UT	school	4900051	8C	Charter	Mountainville Academy	490005101152	100	Mountainville Academy	Regular School	Yes	Other	KG	09	2020	grade_8	33	33
1202236	1202236	UT	school	4900175	5J	Charter	Mountain West Montessori Academy	490017501455	300	Mountain West Montessori Academy	Regular School	Yes	Other	KG	09	2020	grade_8	43	43
1202235	1202235	UT	school	4900138	9F	Charter	Mountain Heights Academy	490013801285	600	Mountain Heights Academy	Regular School	Yes	High	07	12	2020	grade_8	107	107
1202234	1202234	UT	school	4900049	7C	Charter	Monticello Academy	490004901150	100	Monticello Academy	Regular School	Yes	Elementary	KG	08	2020	grade_8	57	57
1202233	1202233	UT	school	4900035	A7	Charter	Moab Charter School	490003501085	100	Moab Charter School	Regular School	Yes	Elementary	KG	06	2020	grade_8	0	0
1202232	1202232	UT	school	4900131	8E	Charter	Merit College Preparatory Academy	490013101220	700	Merit College Preparatory Academy	Regular School	Yes	High	07	12	2020	grade_8	76	76
1202231	1202231	UT	school	4900144	4G	Charter	Maria Montessori Academy	490014401374	100	Maria Montessori Academy	Regular School	Yes	Other	KG	09	2020	grade_8	12	12
1202230	1202230	UT	school	4900165	4I	Charter	Mana Academy Charter School	490016501439	700	Mana Academy Charter School	Regular School	Yes	Other	KG	11	2020	grade_8	29	29
1202229	1202229	UT	school	4900182	9J	Charter	Lumen Scholar Institute	490018201467	300	Lumen Scholar Institute	Regular School	Yes	Other	KG	12	2020	grade_8	28	28
1202228	1202228	UT	school	4900022	2B	Charter	Lincoln Academy	490002201082	100	Lincoln Academy	Regular School	Yes	Other	KG	09	2020	grade_8	118	118
1202227	1202227	UT	school	4900045	5C	Charter	Legacy Preparatory Academy	490004501146	100	Legacy Preparatory Academy	Regular School	Yes	Other	KG	09	2020	grade_8	102	102
1202226	1202226	UT	school	4900162	3I	Charter	Leadership Learning Academy	490016201522	110	Leadership Learning Academy - Ogden	Regular School	Yes	Elementary	KG	06	2020	grade_8	0	0
1202225	1202225	UT	school	4900162	3I	Charter	Leadership Learning Academy	490016201438	100	Leadership Learning Academy	Regular School	Yes	Elementary	KG	06	2020	grade_8	0	0
1202224	1202224	UT	school	4900196	3L	Charter	Leadership Academy of Utah	490019601516	700	Leadership Academy of Utah	Regular School	Yes	High	06	12	2020	grade_8	99	99
1202223	1202223	UT	school	4900043	4C	Charter	Lakeview Academy	490004301144	100	Lakeview Academy	Regular School	Yes	Other	KG	09	2020	grade_8	104	104
1202222	1202222	UT	school	4900056	2E	Charter	Karl G. Maeser Preparatory Academy	490005601175	700	Karl G. Maeser Preparatory Academy	Regular School	Yes	High	07	12	2020	grade_8	102	102
1202221	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
1202220	1202220	UT	school	4900139	1G	Charter	Jefferson Academy	490013901289	100	Jefferson Academy	Regular School	Yes	Elementary	KG	06	2020	grade_8	0	0
1202219	1202219	UT	school	4900067	A5	Charter	Itineris Early College High	490006700997	700	Itineris Early College High	Regular School	Yes	High	10	12	2020	grade_8	0	0
1202218	1202218	UT	school	4900039	2C	Charter	Intech Collegiate Academy	490003901129	600	Intech Collegiate Academy	Regular School	Yes	High	09	12	2020	grade_8	0	0
1202217	1202217	UT	school	4900194	5L	Charter	Ignite Entrepreneurship Academy	490019401509	300	Ignite Entrepreneurship Academy	Regular School	Yes	Elementary	KG	08	2020	grade_8	22	22
1202216	1202216	UT	school	4900156	5H	Charter	Highmark Charter School	490015601415	100	Highmark Charter School	Regular School	Yes	Other	KG	09	2020	grade_8	100	100
1202215	1202215	UT	school	4900137	8F	Charter	Hawthorn Academy	490013701298	100	Hawthorn Academy	Regular School	Yes	Other	KG	09	2020	grade_8	97	97
1202214	1202214	UT	school	4900137	8F	Charter	Hawthorn Academy	490013701493	110	Hawthorn Academy South Jordan	Regular School	Yes	Elementary	KG	06	2020	grade_8	0	0
1202213	1202213	UT	school	4900072	1E	Charter	Guadalupe School	490007201174	100	Guadalupe School	Regular School	Yes	Elementary	PK	06	2020	grade_8	0	0
1202212	1202212	UT	school	4900177	7J	Charter	Greenwood Charter School	490017701468	100	Greenwood Charter School	Regular School	Yes	Elementary	KG	08	2020	grade_8	23	23
1202211	1202211	UT	school	4900147	8G	Charter	Good Foundations Academy	490014701389	100	Good Foundations Academy	Regular School	Yes	Elementary	KG	06	2020	grade_8	0	0
1202210	1202210	UT	school	4900046	5D	Charter	George Washington Academy	490004601147	100	George Washington Academy	Regular School	Yes	Elementary	KG	07	2020	grade_8	0	0
1202209	1202209	UT	school	4900122	7E	Charter	Gateway Preparatory Academy	490012201214	100	Gateway Preparatory Academy	Regular School	Yes	Elementary	KG	08	2020	grade_8	80	80
1202208	1202208	UT	school	4900062	82	Charter	Freedom Preparatory Academy	490006201492	105	Freedom Preparatory Academy - Vineyard	Regular School	Yes	Elementary	KG	05	2020	grade_8	0	0
1202207	1202207	UT	school	4900062	82	Charter	Freedom Preparatory Academy	490006200992	100	Freedom Preparatory Academy	Regular School	Yes	Other	KG	12	2020	grade_8	137	137
1202206	1202206	UT	school	4900187	6K	Charter	Franklin Discovery Academy	490018701488	100	Franklin Discovery Academy	Regular School	Yes	Elementary	KG	06	2020	grade_8	0	0
1202205	1202205	UT	school	4900019	98	Charter	Fast Forward High	490001900906	700	Fast Forward High	Alternative School	Yes	High	09	12	2020	grade_8	0	0
1202204	1202204	UT	school	4900136	7F	Charter	Excelsior Academy	490013601272	100	Excelsior Academy	Regular School	Yes	Elementary	KG	08	2020	grade_8	140	140
1202203	1202203	UT	school	4900161	2I	Charter	Esperanza School	490016101440	100	Esperanza School	Regular School	Yes	Elementary	KG	06	2020	grade_8	0	0
1202202	1202202	UT	school	4900041	3C	Charter	Entheos Academy	490004101437	110	Entheos Academy Magna	Regular School	Yes	Elementary	KG	08	2020	grade_8	48	48

Advanced export

JSON shape: default, array, newline-delimited

CREATE TABLE "enrollments" (
   [state] TEXT,
   [county] TEXT,
   [county_state_id] INTEGER,
   [admin_level] TEXT,
   [district_nces_id] INTEGER,
   [district_state_id] TEXT,
   [district_state_type] TEXT,
   [district] TEXT,
   [school_nces_id] INTEGER,
   [school_state_id] INTEGER,
   [school] TEXT,
   [school_state_type] TEXT,
   [ccd_school_type] TEXT,
   [ccd_charter_school] TEXT,
   [ccd_school_lvl] TEXT,
   [ccd_school_low_grade] TEXT,
   [ccd_school_high_grade] TEXT,
   [year] INTEGER,
   [term] TEXT,
   [grade] TEXT,
   [white] TEXT,
   [black] TEXT,
   [hispanic] TEXT,
   [native_american] TEXT,
   [native_american_alaskan_native] TEXT,
   [asian] TEXT,
   [native_hawaiian] TEXT,
   [asian_pacific_islander] TEXT,
   [native_hawaiian_pacific_islander] TEXT,
   [pacific_islander] TEXT,
   [multiracial] TEXT,
   [unknown_race] TEXT,
   [male] TEXT,
   [female] TEXT,
   [non_binary] TEXT,
   [unknown_gender] TEXT,
   [ell] TEXT,
   [ell_percent] TEXT,
   [homeless] TEXT,
   [homeless_percent] TEXT,
   [low_income] TEXT,
   [free_and_reduced] TEXT,
   [free_and_reduced_percent] TEXT,
   [disability] TEXT,
   [section_504] TEXT,
   [total] TEXT
, [white_int] INTEGER, [black_int] INTEGER, [hispanic_int] INTEGER, [native_american_int] INTEGER, [native_american_alaskan_native_int] INTEGER, [asian_int] INTEGER, [native_hawaiian_int] INTEGER, [asian_pacific_islander_int] INTEGER, [native_hawaiian_pacific_islander_int] INTEGER, [pacific_islander_int] INTEGER, [multiracial_int] INTEGER, [unknown_race_int] INTEGER, [male_int] INTEGER, [female_int] INTEGER, [non_binary_int] INTEGER, [unknown_gender_int] INTEGER, [ell_int] INTEGER, [homeless_int] INTEGER, [low_income_int] INTEGER, [free_and_reduced_int] INTEGER, [disability_int] INTEGER, [section_504_int] INTEGER, [total_int] INTEGER);
CREATE INDEX [idx_enrollments_state_grade]
    ON [enrollments] ([state], [grade]);
CREATE INDEX [idx_enrollments_grade]
    ON [enrollments] ([grade]);
CREATE INDEX [idx_enrollments_year]
    ON [enrollments] ([year]);
CREATE INDEX [idx_enrollments_state_year]
    ON [enrollments] ([state], [year]);
CREATE INDEX [idx_enrollments_school_nces_id]
    ON [enrollments] ([school_nces_id]);
CREATE INDEX [idx_enrollments_district_nces_id]
    ON [enrollments] ([district_nces_id]);