schools: enrollments: 1,047 rows where where grade = "grade_7", state = "UT" and year = 2021 sorted by district_state

Data source: Big Local News · About: Big Local

1,047 rows where grade = "grade_7", state = "UT" and year = 2021 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
1359414	1359414	UT	school	4900017	83	Charter	Academy for Math Engineering & Science	490001700904	700	Academy for Math Engineering & Science	Regular School	Yes	High	09	12	2021	grade_7	0	0
1359415	1359415	UT	school	4900198	1M	Charter	Advantage Arts Academy	490019801524	100	Advantage Arts Academy	Regular School	Yes	Elementary	KG	06	2021	grade_7	0	0
1359416	1359416	UT	school	4900186	8K	Charter	American Academy of Innovation	490018601483	700	American Academy of Innovation	Regular School	Yes	High	06	12	2021	grade_7	67	67
1359417	1359417	UT	school	4900033	8B	Charter	American Leadership Academy	490003301056	100	American Leadership Academy	Regular School	Yes	Other	KG	12	2021	grade_7	136	136
1359418	1359418	UT	school	4900005	74	Charter	American Preparatory Academy	490000501404	110	American Preparatory Academy - Accelerated School	Regular School	Yes	Other	KG	12	2021	grade_7	216	216
1359419	1359419	UT	school	4900005	74	Charter	American Preparatory Academy	490000500801	100	American Preparatory Academy	Regular School	Yes	Elementary	KG	06	2021	grade_7	0	0
1359420	1359420	UT	school	4900005	74	Charter	American Preparatory Academy	490000501446	130	American Preparatory Academy - Draper #2	Regular School	Yes	Elementary	KG	06	2021	grade_7	0	0
1359421	1359421	UT	school	4900005	74	Charter	American Preparatory Academy	490000501471	700	American Preparatory Academy - Draper #3	Regular School	Yes	High	07	12	2021	grade_7	238	238
1359422	1359422	UT	school	4900005	74	Charter	American Preparatory Academy	490000501520	140	American Preparatory Academy - Salem	Regular School	Yes	Other	KG	10	2021	grade_7	44	44
1359423	1359423	UT	school	4900005	74	Charter	American Preparatory Academy	490000501372	120	American Preparatory Academy - The School for New Americans	Regular School	Yes	Other	KG	09	2021	grade_7	0	0
1359424	1359424	UT	school	4900174	2J	Charter	Ascent Academies of Utah	490017401523	330	Ascent Academies of Utah - West Valley	Regular School	Yes	Other	KG	12	2021	grade_7	0	0
1359425	1359425	UT	school	4900174	2J	Charter	Ascent Academies of Utah	490017401453	300	Ascent Academies of Utah Farmington	Regular School	Yes	Other	KG	09	2021	grade_7	42	42
1359426	1359426	UT	school	4900174	2J	Charter	Ascent Academies of Utah	490017401490	320	Ascent Academies of Utah Lehi	Regular School	Yes	Other	KG	09	2021	grade_7	45	45
1359427	1359427	UT	school	4900174	2J	Charter	Ascent Academies of Utah	490017401472	310	Ascent Academies of Utah West Jordan	Regular School	Yes	Other	KG	09	2021	grade_7	86	86
1359428	1359428	UT	school	4900181	4K	Charter	Athenian eAcademy	490018101473	300	Athenian eAcademy	Regular School	Yes	Other	KG	12	2021	grade_7	45	45
1359429	1359429	UT	school	4900189	1L	Charter	Athlos Academy of Utah	490018901503	300	Athlos Academy of Utah	Regular School	Yes	Elementary	KG	08	2021	grade_7	34	34
1359430	1359430	UT	school	4900146	3G	Charter	Bear River Charter School	490014601375	100	Bear River Charter School	Regular School	Yes	Elementary	KG	08	2021	grade_7	13	13
1359431	1359431	UT	school	4900023	3B	Charter	Beehive Science & Technology Academy	490002301060	700	Beehive Science & Technology Academy	Regular School	Yes	High	06	12	2021	grade_7	53	53
1359432	1359432	UT	school	4900195	6L	Charter	Bonneville Academy	490019501507	300	Bonneville Academy	Regular School	Yes	Elementary	KG	08	2021	grade_7	62	62
1359433	1359433	UT	school	4900202	3M	Charter	Bridge Elementary School	490020201566	100	Bridge Elementary School	Regular School	Yes	Elementary	KG	06	2021	grade_7	0	0
1359434	1359434	UT	school	4900074	3E	Charter	C.S. Lewis Academy	490007401190	100	C.S. Lewis Academy	Regular School	Yes	Elementary	KG	06	2021	grade_7	0	0
1359435	1359435	UT	school	4900143	5G	Charter	Canyon Grove Academy	490014301376	100	Canyon Grove Academy	Regular School	Yes	Elementary	KG	08	2021	grade_7	11	11
1359436	1359436	UT	school	4900071	9D	Charter	Canyon Rim Academy	490007101178	100	Canyon Rim Academy	Regular School	Yes	Elementary	KG	06	2021	grade_7	0	0
1359437	1359437	UT	school	4900040	2D	Charter	Channing Hall	490004001130	100	Channing Hall	Regular School	Yes	Elementary	KG	08	2021	grade_7	42	42
1359438	1359438	UT	school	4900009	87	Charter	City Academy	490000900742	700	City Academy	Regular School	Yes	High	07	12	2021	grade_7	18	18
1359439	1359439	UT	school	4900065	A3	Charter	Davinci Academy	490006500995	700	Davinci Academy	Regular School	Yes	Other	KG	12	2021	grade_7	124	124
1359440	1359440	UT	school	4900169	3J	Charter	Dixie Montessori Academy	490016901452	100	Dixie Montessori Academy	Regular School	Yes	Elementary	KG	07	2021	grade_7	12	12
1359441	1359441	UT	school	4900073	4E	Charter	Dual Immersion Academy	490007301187	100	Dual Immersion Academy	Regular School	Yes	Elementary	KG	08	2021	grade_7	41	41
1359442	1359442	UT	school	4900140	6F	Charter	Early Light Academy at Daybreak	490014001268	300	Early Light Academy at Daybreak	Regular School	Yes	Other	KG	09	2021	grade_7	99	99
1359443	1359443	UT	school	4900036	A8	Charter	East Hollywood High	490003601072	700	East Hollywood High	Regular School	Yes	High	09	12	2021	grade_7	0	0
1359444	1359444	UT	school	4900070	5E	Charter	Edith Bowen Laboratory School	490007001176	108	Edith Bowen Laboratory School	Regular School	Yes	Elementary	KG	06	2021	grade_7	0	0
1359445	1359445	UT	school	4900155	3H	Charter	Endeavor Hall	490015501407	100	Endeavor Hall	Regular School	Yes	Elementary	KG	08	2021	grade_7	0	0
1359446	1359446	UT	school	4900041	3C	Charter	Entheos Academy	490004101136	100	Entheos Academy	Regular School	Yes	Other	KG	09	2021	grade_7	49	49
1359447	1359447	UT	school	4900041	3C	Charter	Entheos Academy	490004101437	110	Entheos Academy Magna	Regular School	Yes	Other	KG	09	2021	grade_7	50	50
1359448	1359448	UT	school	4900161	2I	Charter	Esperanza School	490016101440	100	Esperanza School	Regular School	Yes	Elementary	KG	06	2021	grade_7	0	0
1359449	1359449	UT	school	4900136	7F	Charter	Excelsior Academy	490013601272	100	Excelsior Academy	Regular School	Yes	Elementary	KG	08	2021	grade_7	153	153
1359450	1359450	UT	school	4900019	98	Charter	Fast Forward High	490001900906	700	Fast Forward High	Alternative School	Yes	High	09	12	2021	grade_7	0	0
1359451	1359451	UT	school	4900187	6K	Charter	Franklin Discovery Academy	490018701488	100	Franklin Discovery Academy	Regular School	Yes	Elementary	KG	06	2021	grade_7	0	0
1359452	1359452	UT	school	4900062	82	Charter	Freedom Preparatory Academy	490006200992	100	Freedom Preparatory Academy	Regular School	Yes	Other	PK	12	2021	grade_7	182	182
1359453	1359453	UT	school	4900062	82	Charter	Freedom Preparatory Academy	490006201492	105	Freedom Preparatory Academy - Vineyard	Regular School	Yes	Elementary	PK	05	2021	grade_7	0	0
1359454	1359454	UT	school	4900122	7E	Charter	Gateway Preparatory Academy	490012201214	100	Gateway Preparatory Academy	Regular School	Yes	Elementary	KG	08	2021	grade_7	62	62
1359455	1359455	UT	school	4900046	5D	Charter	George Washington Academy	490004601147	100	George Washington Academy	Regular School	Yes	Elementary	KG	08	2021	grade_7	87	87
1359456	1359456	UT	school	4900147	8G	Charter	Good Foundations Academy	490014701389	100	Good Foundations Academy	Regular School	Yes	Elementary	KG	06	2021	grade_7	0	0
1359457	1359457	UT	school	4900177	7J	Charter	Greenwood Charter School	490017701468	100	Greenwood Charter School	Regular School	Yes	Elementary	KG	08	2021	grade_7	37	37
1359458	1359458	UT	school	4900072	1E	Charter	Guadalupe School	490007201174	100	Guadalupe School	Regular School	Yes	Elementary	PK	06	2021	grade_7	0	0
1359459	1359459	UT	school	4900137	8F	Charter	Hawthorn Academy	490013701493	110	Hawthorn Academy South Jordan	Regular School	Yes	Elementary	KG	06	2021	grade_7	0	0
1359460	1359460	UT	school	4900137	8F	Charter	Hawthorn Academy	490013701298	100	Hawthorn Academy	Regular School	Yes	Other	KG	09	2021	grade_7	103	103
1359461	1359461	UT	school	4900156	5H	Charter	Highmark Charter School	490015601415	100	Highmark Charter School	Regular School	Yes	Other	KG	09	2021	grade_7	107	107
1359462	1359462	UT	school	4900194	5L	Charter	Ignite Entrepreneurship Academy	490019401509	300	Ignite Entrepreneurship Academy	Regular School	Yes	Elementary	KG	08	2021	grade_7	37	37
1359463	1359463	UT	school	4900039	2C	Charter	Intech Collegiate Academy	490003901129	600	Intech Collegiate Academy	Regular School	Yes	High	07	12	2021	grade_7	31	31
1359464	1359464	UT	school	4900067	A5	Charter	Itineris Early College High	490006700997	700	Itineris Early College High	Regular School	Yes	High	10	12	2021	grade_7	0	0
1359465	1359465	UT	school	4900139	1G	Charter	Jefferson Academy	490013901289	100	Jefferson Academy	Regular School	Yes	Elementary	KG	06	2021	grade_7	0	0
1359466	1359466	UT	school	4900014	93	Charter	John Hancock Charter School	490001400811	105	John Hancock Charter School	Regular School	Yes	Elementary	KG	08	2021	grade_7	12	12
1359467	1359467	UT	school	4900056	2E	Charter	Karl G. Maeser Preparatory Academy	490005601175	700	Karl G. Maeser Preparatory Academy	Regular School	Yes	High	07	12	2021	grade_7	103	103
1359468	1359468	UT	school	4900043	4C	Charter	Lakeview Academy	490004301144	100	Lakeview Academy	Regular School	Yes	Other	KG	09	2021	grade_7	98	98
1359469	1359469	UT	school	4900196	3L	Charter	Leadership Academy of Utah	490019601516	700	Leadership Academy of Utah	Regular School	Yes	High	06	12	2021	grade_7	87	87
1359470	1359470	UT	school	4900162	3I	Charter	Leadership Learning Academy	490016201438	100	Leadership Learning Academy	Regular School	Yes	Elementary	KG	06	2021	grade_7	0	0
1359471	1359471	UT	school	4900162	3I	Charter	Leadership Learning Academy	490016201522	110	Leadership Learning Academy - Ogden	Regular School	Yes	Elementary	KG	06	2021	grade_7	0	0
1359472	1359472	UT	school	4900045	5C	Charter	Legacy Preparatory Academy	490004501146	100	Legacy Preparatory Academy	Regular School	Yes	Other	KG	09	2021	grade_7	108	108
1359473	1359473	UT	school	4900022	2B	Charter	Lincoln Academy	490002201082	100	Lincoln Academy	Regular School	Yes	Other	KG	09	2021	grade_7	133	133
1359474	1359474	UT	school	4900182	9J	Charter	Lumen Scholar Institute	490018201467	300	Lumen Scholar Institute	Regular School	Yes	Other	KG	12	2021	grade_7	53	53
1359475	1359475	UT	school	4900165	4I	Charter	Mana Academy Charter School	490016501439	700	Mana Academy Charter School	Regular School	Yes	Other	KG	12	2021	grade_7	30	30
1359476	1359476	UT	school	4900144	4G	Charter	Maria Montessori Academy	490014401374	100	Maria Montessori Academy	Regular School	Yes	Other	KG	09	2021	grade_7	23	23
1359477	1359477	UT	school	4900131	8E	Charter	Merit College Preparatory Academy	490013101220	700	Merit College Preparatory Academy	Regular School	Yes	High	07	12	2021	grade_7	58	58
1359478	1359478	UT	school	4900035	A7	Charter	Moab Charter School	490003501085	100	Moab Charter School	Regular School	Yes	Elementary	KG	06	2021	grade_7	0	0
1359479	1359479	UT	school	4900049	7C	Charter	Monticello Academy	490004901150	100	Monticello Academy	Regular School	Yes	Elementary	KG	08	2021	grade_7	72	72
1359480	1359480	UT	school	4900049	7C	Charter	Monticello Academy	490004901556	105	Monticello Academy West Point	Regular School	Yes	Elementary	KG	06	2021	grade_7	0	0
1359481	1359481	UT	school	4900138	9F	Charter	Mountain Heights Academy	490013801285	600	Mountain Heights Academy	Regular School	Yes	High	07	12	2021	grade_7	155	155
1359482	1359482	UT	school	4900203	4M	Charter	Mountain Sunrise Academy	490020301565	100	Mountain Sunrise Academy	Regular School	Yes	Elementary	KG	08	2021	grade_7	0	0
1359483	1359483	UT	school	4900175	5J	Charter	Mountain West Montessori Academy	490017501455	300	Mountain West Montessori Academy	Regular School	Yes	Other	KG	09	2021	grade_7	34	34
1359484	1359484	UT	school	4900051	8C	Charter	Mountainville Academy	490005101152	100	Mountainville Academy	Regular School	Yes	Other	KG	09	2021	grade_7	38	38
1359485	1359485	UT	school	4900034	9B	Charter	Navigator Pointe Academy	490003401088	100	Navigator Pointe Academy	Regular School	Yes	Other	KG	09	2021	grade_7	26	26
1359486	1359486	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	2021	grade_7	0	0
1359487	1359487	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	2021	grade_7	0	0
1359488	1359488	UT	school	4900048	6D	Charter	Noah Webster Academy	490004801149	100	Noah Webster Academy	Regular School	Yes	Elementary	KG	06	2021	grade_7	0	0
1359489	1359489	UT	school	4900068	A6	Charter	North Davis Preparatory Academy	490006800998	100	North Davis Preparatory Academy	Regular School	Yes	Other	KG	09	2021	grade_7	92	92
1359490	1359490	UT	school	4900025	5B	Charter	North Star Academy	490002501089	100	North Star Academy	Regular School	Yes	Other	KG	09	2021	grade_7	55	55
1359491	1359491	UT	school	4900021	1C	Charter	Odyssey Charter School	490002101092	100	Odyssey Charter School	Regular School	Yes	Elementary	KG	06	2021	grade_7	0	0
1359492	1359492	UT	school	4900058	68	Charter	Ogden Preparatory Academy	490005800989	100	Ogden Preparatory Academy	Regular School	Yes	Other	KG	09	2021	grade_7	112	112
1359493	1359493	UT	school	4900118	8D	Charter	Open Classroom	490011801135	240	Open Classroom	Regular School	Yes	Elementary	KG	08	2021	grade_7	35	35
1359494	1359494	UT	school	4900159	7H	Charter	Pacific Heritage Academy	490015901406	100	Pacific Heritage Academy	Regular School	Yes	Elementary	KG	08	2021	grade_7	29	29
1359495	1359495	UT	school	4900052	9C	Charter	Paradigm High School	490005201153	700	Paradigm High School	Regular School	Yes	High	07	12	2021	grade_7	28	28
1359496	1359496	UT	school	4900008	86	Charter	Pinnacle Canyon Academy	490000800629	100	Pinnacle Canyon Academy	Regular School	Yes	Other	PK	12	2021	grade_7	37	37
1359497	1359497	UT	school	4900157	6H	Charter	Promontory School of Expeditionary Learning	490015701416	100	Promontory School of Expeditionary Learning	Regular School	Yes	Elementary	KG	08	2021	grade_7	49	49
1359498	1359498	UT	school	4900124	9E	Charter	Providence Hall	490012401202	100	Providence Hall	Regular School	Yes	Other	KG	12	2021	grade_7	195	195
1359499	1359499	UT	school	4900132	1F	Charter	Quest Academy	490013201218	100	Quest Academy	Regular School	Yes	Other	KG	09	2021	grade_7	102	102
1359500	1359500	UT	school	4900064	A2	Charter	Ranches Academy	490006400994	100	Ranches Academy	Regular School	Yes	Elementary	KG	06	2021	grade_7	0	0
1359501	1359501	UT	school	4900032	7B	Charter	Reagan Academy	490003201095	100	Reagan Academy	Regular School	Yes	Elementary	KG	08	2021	grade_7	59	59
1359502	1359502	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	2021	grade_7	0	0
1359503	1359503	UT	school	4900038	1D	Charter	Renaissance Academy	490003801128	100	Renaissance Academy	Regular School	Yes	Other	KG	09	2021	grade_7	44	44
1359504	1359504	UT	school	4900125	2F	Charter	Rockwell Charter High School	490012501199	700	Rockwell Charter High School	Regular School	Yes	High	07	12	2021	grade_7	19	19
1359505	1359505	UT	school	4900178	3K	Charter	Roots Charter High School	490017801477	700	Roots Charter High School	Regular School	Yes	High	09	12	2021	grade_7	0	0
1359506	1359506	UT	school	4900018	97	Charter	Salt Lake Arts Academy	490001800905	300	Salt Lake Arts Academy	Regular School	Yes	Middle	05	08	2021	grade_7	102	102
1359507	1359507	UT	school	4900123	4F	Charter	Salt Lake Center for Science Education	490012301208	300	Salt Lake Center for Science Education	Regular School	Yes	High	06	12	2021	grade_7	0	0
1359508	1359508	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	2021	grade_7	0	0
1359509	1359509	UT	school	4900170	6J	Charter	Scholar Academy	490017001456	100	Scholar Academy	Regular School	Yes	Elementary	KG	08	2021	grade_7	75	75
1359510	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
1359511	1359511	UT	school	4900042	3D	Charter	Spectrum Academy	490004201137	100	Spectrum Academy	Regular School	Yes	Other	KG	12	2021	grade_7	72	72
1359512	1359512	UT	school	4900042	3D	Charter	Spectrum Academy	490004201464	300	Spectrum Academy - Pleasant Grove	Regular School	Yes	Other	KG	12	2021	grade_7	48	48
1359513	1359513	UT	school	4900188	9K	Charter	St. George Academy	490018801485	700	St. George Academy	Regular School	Yes	High	08	12	2021	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]);