schools: enrollments: 2,084 rows where where grade = "grade_7" and state = "UT" sorted by district_state

Data source: Big Local News · About: Big Local

2,084 rows where grade = "grade_7" and state = "UT" sorted by district_state_type

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
1201133	1201133	UT	school	4900017	83	Charter	Academy for Math Engineering & Science	490001700904	700	Academy for Math Engineering & Science	Regular School	Yes	High	09	12	2020	grade_7	0	0
1201134	1201134	UT	school	4900186	8K	Charter	American Academy of Innovation	490018601483	700	American Academy of Innovation	Regular School	Yes	High	06	12	2020	grade_7	52	52
1201135	1201135	UT	school	4900033	8B	Charter	American Leadership Academy	490003301056	100	American Leadership Academy	Regular School	Yes	Other	KG	12	2020	grade_7	143	143
1201136	1201136	UT	school	4900005	74	Charter	American Preparatory Academy	490000501404	110	American Preparatory Academy - Accelerated School	Regular School	Yes	Other	KG	12	2020	grade_7	216	216
1201137	1201137	UT	school	4900005	74	Charter	American Preparatory Academy	490000500801	100	American Preparatory Academy	Regular School	Yes	Elementary	KG	06	2020	grade_7	0	0
1201138	1201138	UT	school	4900005	74	Charter	American Preparatory Academy	490000501446	130	American Preparatory Academy - Draper #2	Regular School	Yes	Elementary	KG	06	2020	grade_7	0	0
1201139	1201139	UT	school	4900005	74	Charter	American Preparatory Academy	490000501471	700	American Preparatory Academy - Draper #3	Regular School	Yes	High	07	12	2020	grade_7	226	226
1201140	1201140	UT	school	4900005	74	Charter	American Preparatory Academy	490000501520	140	American Preparatory Academy - Salem	Regular School	Yes	Other	KG	09	2020	grade_7	50	50
1201141	1201141	UT	school	4900005	74	Charter	American Preparatory Academy	490000501372	120	American Preparatory Academy - The School for New Americans	Regular School	Yes	Elementary	KG	06	2020	grade_7	0	0
1201142	1201142	UT	school	4900174	2J	Charter	Ascent Academies of Utah	490017401523	330	Ascent Academies of Utah - West Valley	Regular School	Yes	Elementary	KG	06	2020	grade_7	0	0
1201143	1201143	UT	school	4900174	2J	Charter	Ascent Academies of Utah	490017401453	300	Ascent Academies of Utah Farmington	Regular School	Yes	Other	KG	09	2020	grade_7	36	36
1201144	1201144	UT	school	4900174	2J	Charter	Ascent Academies of Utah	490017401490	320	Ascent Academies of Utah Lehi	Regular School	Yes	Other	KG	09	2020	grade_7	62	62
1201145	1201145	UT	school	4900174	2J	Charter	Ascent Academies of Utah	490017401472	310	Ascent Academies of Utah West Jordan	Regular School	Yes	Other	KG	09	2020	grade_7	89	89
1201146	1201146	UT	school	4900181	4K	Charter	Athenian eAcademy	490018101473	300	Athenian eAcademy	Regular School	Yes	Other	KG	12	2020	grade_7	67	67
1201147	1201147	UT	school	4900189	1L	Charter	Athlos Academy of Utah	490018901503	300	Athlos Academy of Utah	Regular School	Yes	Elementary	KG	08	2020	grade_7	26	26
1201148	1201148	UT	school	4900146	3G	Charter	Bear River Charter School	490014601375	100	Bear River Charter School	Regular School	Yes	Elementary	KG	08	2020	grade_7	19	19
1201149	1201149	UT	school	4900023	3B	Charter	Beehive Science & Technology Academy	490002301060	700	Beehive Science & Technology Academy	Regular School	Yes	High	06	12	2020	grade_7	66	66
1201150	1201150	UT	school	4900195	6L	Charter	Bonneville Academy	490019501507	300	Bonneville Academy	Regular School	Yes	Elementary	KG	08	2020	grade_7	69	69
1201151	1201151	UT	school	4900074	3E	Charter	C.S. Lewis Academy	490007401190	100	C.S. Lewis Academy	Regular School	Yes	Elementary	KG	06	2020	grade_7	0	0
1201152	1201152	UT	school	4900143	5G	Charter	Canyon Grove Academy	490014301376	100	Canyon Grove Academy	Regular School	Yes	Elementary	KG	08	2020	grade_7	13	13
1201153	1201153	UT	school	4900071	9D	Charter	Canyon Rim Academy	490007101178	100	Canyon Rim Academy	Regular School	Yes	Elementary	KG	06	2020	grade_7	0	0
1201154	1201154	UT	school	4900199	9L	Charter	Capstone Classical Academy	490019901527	300	Capstone Classical Academy	Regular School	Yes	High	06	12	2020	grade_7	38	38
1201155	1201155	UT	school	4900040	2D	Charter	Channing Hall	490004001130	100	Channing Hall	Regular School	Yes	Elementary	KG	08	2020	grade_7	48	48
1201156	1201156	UT	school	4900009	87	Charter	City Academy	490000900742	700	City Academy	Regular School	Yes	High	07	12	2020	grade_7	16	16
1201157	1201157	UT	school	4900065	A3	Charter	Davinci Academy	490006500995	700	Davinci Academy	Regular School	Yes	Other	KG	12	2020	grade_7	97	97
1201158	1201158	UT	school	4900169	3J	Charter	Dixie Montessori Academy	490016901452	100	Dixie Montessori Academy	Regular School	Yes	Elementary	KG	07	2020	grade_7	23	23
1201159	1201159	UT	school	4900073	4E	Charter	Dual Immersion Academy	490007301187	100	Dual Immersion Academy	Regular School	Yes	Elementary	KG	08	2020	grade_7	44	44
1201160	1201160	UT	school	4900140	6F	Charter	Early Light Academy at Daybreak	490014001268	300	Early Light Academy at Daybreak	Regular School	Yes	Other	KG	09	2020	grade_7	109	109
1201161	1201161	UT	school	4900036	A8	Charter	East Hollywood High	490003601072	700	East Hollywood High	Regular School	Yes	High	09	12	2020	grade_7	0	0
1201162	1201162	UT	school	4900070	5E	Charter	Edith Bowen Laboratory School	490007001176	108	Edith Bowen Laboratory School	Regular School	Yes	Elementary	KG	06	2020	grade_7	0	0
1201163	1201163	UT	school	4900155	3H	Charter	Endeavor Hall	490015501407	100	Endeavor Hall	Regular School	Yes	Elementary	KG	06	2020	grade_7	0	0
1201164	1201164	UT	school	4900041	3C	Charter	Entheos Academy	490004101136	100	Entheos Academy	Regular School	Yes	Elementary	KG	08	2020	grade_7	49	49
1201165	1201165	UT	school	4900041	3C	Charter	Entheos Academy	490004101437	110	Entheos Academy Magna	Regular School	Yes	Elementary	KG	08	2020	grade_7	54	54
1201166	1201166	UT	school	4900161	2I	Charter	Esperanza School	490016101440	100	Esperanza School	Regular School	Yes	Elementary	KG	06	2020	grade_7	0	0
1201167	1201167	UT	school	4900136	7F	Charter	Excelsior Academy	490013601272	100	Excelsior Academy	Regular School	Yes	Elementary	KG	08	2020	grade_7	179	179
1201168	1201168	UT	school	4900019	98	Charter	Fast Forward High	490001900906	700	Fast Forward High	Alternative School	Yes	High	09	12	2020	grade_7	0	0
1201169	1201169	UT	school	4900187	6K	Charter	Franklin Discovery Academy	490018701488	100	Franklin Discovery Academy	Regular School	Yes	Elementary	KG	06	2020	grade_7	0	0
1201170	1201170	UT	school	4900062	82	Charter	Freedom Preparatory Academy	490006200992	100	Freedom Preparatory Academy	Regular School	Yes	Other	KG	12	2020	grade_7	160	160
1201171	1201171	UT	school	4900062	82	Charter	Freedom Preparatory Academy	490006201492	105	Freedom Preparatory Academy - Vineyard	Regular School	Yes	Elementary	KG	05	2020	grade_7	0	0
1201172	1201172	UT	school	4900122	7E	Charter	Gateway Preparatory Academy	490012201214	100	Gateway Preparatory Academy	Regular School	Yes	Elementary	KG	08	2020	grade_7	79	79
1201173	1201173	UT	school	4900046	5D	Charter	George Washington Academy	490004601147	100	George Washington Academy	Regular School	Yes	Elementary	KG	07	2020	grade_7	106	106
1201174	1201174	UT	school	4900147	8G	Charter	Good Foundations Academy	490014701389	100	Good Foundations Academy	Regular School	Yes	Elementary	KG	06	2020	grade_7	0	0
1201175	1201175	UT	school	4900177	7J	Charter	Greenwood Charter School	490017701468	100	Greenwood Charter School	Regular School	Yes	Elementary	KG	08	2020	grade_7	27	27
1201176	1201176	UT	school	4900072	1E	Charter	Guadalupe School	490007201174	100	Guadalupe School	Regular School	Yes	Elementary	PK	06	2020	grade_7	0	0
1201177	1201177	UT	school	4900137	8F	Charter	Hawthorn Academy	490013701493	110	Hawthorn Academy South Jordan	Regular School	Yes	Elementary	KG	06	2020	grade_7	0	0
1201178	1201178	UT	school	4900137	8F	Charter	Hawthorn Academy	490013701298	100	Hawthorn Academy	Regular School	Yes	Other	KG	09	2020	grade_7	99	99
1201179	1201179	UT	school	4900156	5H	Charter	Highmark Charter School	490015601415	100	Highmark Charter School	Regular School	Yes	Other	KG	09	2020	grade_7	71	71
1201180	1201180	UT	school	4900194	5L	Charter	Ignite Entrepreneurship Academy	490019401509	300	Ignite Entrepreneurship Academy	Regular School	Yes	Elementary	KG	08	2020	grade_7	35	35
1201181	1201181	UT	school	4900039	2C	Charter	Intech Collegiate Academy	490003901129	600	Intech Collegiate Academy	Regular School	Yes	High	09	12	2020	grade_7	0	0
1201182	1201182	UT	school	4900067	A5	Charter	Itineris Early College High	490006700997	700	Itineris Early College High	Regular School	Yes	High	10	12	2020	grade_7	0	0
1201183	1201183	UT	school	4900139	1G	Charter	Jefferson Academy	490013901289	100	Jefferson Academy	Regular School	Yes	Elementary	KG	06	2020	grade_7	0	0
1201184	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
1201185	1201185	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_7	102	102
1201186	1201186	UT	school	4900043	4C	Charter	Lakeview Academy	490004301144	100	Lakeview Academy	Regular School	Yes	Other	KG	09	2020	grade_7	104	104
1201187	1201187	UT	school	4900196	3L	Charter	Leadership Academy of Utah	490019601516	700	Leadership Academy of Utah	Regular School	Yes	High	06	12	2020	grade_7	84	84
1201188	1201188	UT	school	4900162	3I	Charter	Leadership Learning Academy	490016201438	100	Leadership Learning Academy	Regular School	Yes	Elementary	KG	06	2020	grade_7	0	0
1201189	1201189	UT	school	4900162	3I	Charter	Leadership Learning Academy	490016201522	110	Leadership Learning Academy - Ogden	Regular School	Yes	Elementary	KG	06	2020	grade_7	0	0
1201190	1201190	UT	school	4900045	5C	Charter	Legacy Preparatory Academy	490004501146	100	Legacy Preparatory Academy	Regular School	Yes	Other	KG	09	2020	grade_7	112	112
1201191	1201191	UT	school	4900022	2B	Charter	Lincoln Academy	490002201082	100	Lincoln Academy	Regular School	Yes	Other	KG	09	2020	grade_7	115	115
1201192	1201192	UT	school	4900182	9J	Charter	Lumen Scholar Institute	490018201467	300	Lumen Scholar Institute	Regular School	Yes	Other	KG	12	2020	grade_7	27	27
1201193	1201193	UT	school	4900165	4I	Charter	Mana Academy Charter School	490016501439	700	Mana Academy Charter School	Regular School	Yes	Other	KG	11	2020	grade_7	28	28
1201194	1201194	UT	school	4900144	4G	Charter	Maria Montessori Academy	490014401374	100	Maria Montessori Academy	Regular School	Yes	Other	KG	09	2020	grade_7	34	34
1201195	1201195	UT	school	4900131	8E	Charter	Merit College Preparatory Academy	490013101220	700	Merit College Preparatory Academy	Regular School	Yes	High	07	12	2020	grade_7	67	67
1201196	1201196	UT	school	4900035	A7	Charter	Moab Charter School	490003501085	100	Moab Charter School	Regular School	Yes	Elementary	KG	06	2020	grade_7	0	0
1201197	1201197	UT	school	4900049	7C	Charter	Monticello Academy	490004901150	100	Monticello Academy	Regular School	Yes	Elementary	KG	08	2020	grade_7	74	74
1201198	1201198	UT	school	4900138	9F	Charter	Mountain Heights Academy	490013801285	600	Mountain Heights Academy	Regular School	Yes	High	07	12	2020	grade_7	64	64
1201199	1201199	UT	school	4900175	5J	Charter	Mountain West Montessori Academy	490017501455	300	Mountain West Montessori Academy	Regular School	Yes	Other	KG	09	2020	grade_7	46	46
1201200	1201200	UT	school	4900051	8C	Charter	Mountainville Academy	490005101152	100	Mountainville Academy	Regular School	Yes	Other	KG	09	2020	grade_7	39	39
1201201	1201201	UT	school	4900034	9B	Charter	Navigator Pointe Academy	490003401088	100	Navigator Pointe Academy	Regular School	Yes	Other	KG	09	2020	grade_7	39	39
1201202	1201202	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_7	0	0
1201203	1201203	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_7	0	0
1201204	1201204	UT	school	4900048	6D	Charter	Noah Webster Academy	490004801149	100	Noah Webster Academy	Regular School	Yes	Elementary	KG	06	2020	grade_7	0	0
1201205	1201205	UT	school	4900068	A6	Charter	North Davis Preparatory Academy	490006800998	100	North Davis Preparatory Academy	Regular School	Yes	Other	KG	09	2020	grade_7	96	96
1201206	1201206	UT	school	4900025	5B	Charter	North Star Academy	490002501089	100	North Star Academy	Regular School	Yes	Other	KG	09	2020	grade_7	54	54
1201207	1201207	UT	school	4900021	1C	Charter	Odyssey Charter School	490002101092	100	Odyssey Charter School	Regular School	Yes	Elementary	KG	06	2020	grade_7	0	0
1201208	1201208	UT	school	4900058	68	Charter	Ogden Preparatory Academy	490005800989	100	Ogden Preparatory Academy	Regular School	Yes	Other	KG	09	2020	grade_7	107	107
1201209	1201209	UT	school	4900118	8D	Charter	Open Classroom	490011801135	240	Open Classroom	Regular School	Yes	Elementary	KG	08	2020	grade_7	26	26
1201210	1201210	UT	school	4900159	7H	Charter	Pacific Heritage Academy	490015901406	100	Pacific Heritage Academy	Regular School	Yes	Elementary	KG	08	2020	grade_7	45	45
1201211	1201211	UT	school	4900052	9C	Charter	Paradigm High School	490005201153	700	Paradigm High School	Regular School	Yes	High	07	12	2020	grade_7	44	44
1201212	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
1201213	1201213	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_7	54	54
1201214	1201214	UT	school	4900124	9E	Charter	Providence Hall	490012401202	100	Providence Hall	Regular School	Yes	Other	KG	12	2020	grade_7	212	212
1201215	1201215	UT	school	4900132	1F	Charter	Quest Academy	490013201218	100	Quest Academy	Regular School	Yes	Other	KG	09	2020	grade_7	98	98
1201216	1201216	UT	school	4900064	A2	Charter	Ranches Academy	490006400994	100	Ranches Academy	Regular School	Yes	Elementary	KG	06	2020	grade_7	0	0
1201217	1201217	UT	school	4900032	7B	Charter	Reagan Academy	490003201095	100	Reagan Academy	Regular School	Yes	Elementary	KG	08	2020	grade_7	66	66
1201218	1201218	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_7	0	0
1201219	1201219	UT	school	4900038	1D	Charter	Renaissance Academy	490003801128	100	Renaissance Academy	Regular School	Yes	Elementary	KG	08	2020	grade_7	46	46
1201220	1201220	UT	school	4900125	2F	Charter	Rockwell Charter High School	490012501199	700	Rockwell Charter High School	Regular School	Yes	High	07	12	2020	grade_7	22	22
1201221	1201221	UT	school	4900178	3K	Charter	Roots Charter High School	490017801477	700	Roots Charter High School	Regular School	Yes	High	09	12	2020	grade_7	0	0
1201222	1201222	UT	school	4900018	97	Charter	Salt Lake Arts Academy	490001800905	300	Salt Lake Arts Academy	Regular School	Yes	Middle	05	08	2020	grade_7	101	101
1201223	1201223	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_7	61	61
1201224	1201224	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_7	0	0
1201225	1201225	UT	school	4900170	6J	Charter	Scholar Academy	490017001456	100	Scholar Academy	Regular School	Yes	Elementary	KG	08	2020	grade_7	71	71
1201226	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
1201227	1201227	UT	school	4900042	3D	Charter	Spectrum Academy	490004201137	100	Spectrum Academy	Regular School	Yes	Other	KG	12	2020	grade_7	69	69
1201228	1201228	UT	school	4900042	3D	Charter	Spectrum Academy	490004201464	300	Spectrum Academy - Pleasant Grove	Regular School	Yes	Other	KG	12	2020	grade_7	56	56
1201229	1201229	UT	school	4900188	9K	Charter	St. George Academy	490018801485	700	St. George Academy	Regular School	Yes	High	08	12	2020	grade_7	0	0
1201230	1201230	UT	school	4900037	A9	Charter	Success Academy	490003701470	710	Success DSU	Regular School	Yes	High	10	12	2020	grade_7	0	0
1201231	1201231	UT	school	4900037	A9	Charter	Success Academy	490003701101	700	Success Academy	Regular School	Yes	High	09	12	2020	grade_7	0	0
1201232	1201232	UT	school	4900066	A4	Charter	Summit Academy	490006601499	310	Summit Academy - Bluffdale	Regular School	Yes	Elementary	KG	06	2020	grade_7	0	0

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]);