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

Data source: Big Local News · About: Big Local

2,084 rows where grade = "grade_1" 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
1194911	1194911	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_1	0	0
1194912	1194912	UT	school	4900186	8K	Charter	American Academy of Innovation	490018601483	700	American Academy of Innovation	Regular School	Yes	High	06	12	2020	grade_1	0	0
1194913	1194913	UT	school	4900033	8B	Charter	American Leadership Academy	490003301056	100	American Leadership Academy	Regular School	Yes	Other	KG	12	2020	grade_1	138	138
1194914	1194914	UT	school	4900005	74	Charter	American Preparatory Academy	490000501404	110	American Preparatory Academy - Accelerated School	Regular School	Yes	Other	KG	12	2020	grade_1	90	90
1194915	1194915	UT	school	4900005	74	Charter	American Preparatory Academy	490000500801	100	American Preparatory Academy	Regular School	Yes	Elementary	KG	06	2020	grade_1	117	117
1194916	1194916	UT	school	4900005	74	Charter	American Preparatory Academy	490000501446	130	American Preparatory Academy - Draper #2	Regular School	Yes	Elementary	KG	06	2020	grade_1	168	168
1194917	1194917	UT	school	4900005	74	Charter	American Preparatory Academy	490000501471	700	American Preparatory Academy - Draper #3	Regular School	Yes	High	07	12	2020	grade_1	0	0
1194918	1194918	UT	school	4900005	74	Charter	American Preparatory Academy	490000501520	140	American Preparatory Academy - Salem	Regular School	Yes	Other	KG	09	2020	grade_1	71	71
1194919	1194919	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_1	83	83
1194920	1194920	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_1	102	102
1194921	1194921	UT	school	4900174	2J	Charter	Ascent Academies of Utah	490017401453	300	Ascent Academies of Utah Farmington	Regular School	Yes	Other	KG	09	2020	grade_1	43	43
1194922	1194922	UT	school	4900174	2J	Charter	Ascent Academies of Utah	490017401490	320	Ascent Academies of Utah Lehi	Regular School	Yes	Other	KG	09	2020	grade_1	63	63
1194923	1194923	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_1	84	84
1194924	1194924	UT	school	4900181	4K	Charter	Athenian eAcademy	490018101473	300	Athenian eAcademy	Regular School	Yes	Other	KG	12	2020	grade_1	72	72
1194925	1194925	UT	school	4900189	1L	Charter	Athlos Academy of Utah	490018901503	300	Athlos Academy of Utah	Regular School	Yes	Elementary	KG	08	2020	grade_1	129	129
1194926	1194926	UT	school	4900146	3G	Charter	Bear River Charter School	490014601375	100	Bear River Charter School	Regular School	Yes	Elementary	KG	08	2020	grade_1	20	20
1194927	1194927	UT	school	4900023	3B	Charter	Beehive Science & Technology Academy	490002301060	700	Beehive Science & Technology Academy	Regular School	Yes	High	06	12	2020	grade_1	0	0
1194928	1194928	UT	school	4900195	6L	Charter	Bonneville Academy	490019501507	300	Bonneville Academy	Regular School	Yes	Elementary	KG	08	2020	grade_1	58	58
1194929	1194929	UT	school	4900074	3E	Charter	C.S. Lewis Academy	490007401190	100	C.S. Lewis Academy	Regular School	Yes	Elementary	KG	06	2020	grade_1	48	48
1194930	1194930	UT	school	4900143	5G	Charter	Canyon Grove Academy	490014301376	100	Canyon Grove Academy	Regular School	Yes	Elementary	KG	08	2020	grade_1	95	95
1194931	1194931	UT	school	4900071	9D	Charter	Canyon Rim Academy	490007101178	100	Canyon Rim Academy	Regular School	Yes	Elementary	KG	06	2020	grade_1	78	78
1194932	1194932	UT	school	4900199	9L	Charter	Capstone Classical Academy	490019901527	300	Capstone Classical Academy	Regular School	Yes	High	06	12	2020	grade_1	0	0
1194933	1194933	UT	school	4900040	2D	Charter	Channing Hall	490004001130	100	Channing Hall	Regular School	Yes	Elementary	KG	08	2020	grade_1	77	77
1194934	1194934	UT	school	4900009	87	Charter	City Academy	490000900742	700	City Academy	Regular School	Yes	High	07	12	2020	grade_1	0	0
1194935	1194935	UT	school	4900065	A3	Charter	Davinci Academy	490006500995	700	Davinci Academy	Regular School	Yes	Other	KG	12	2020	grade_1	126	126
1194936	1194936	UT	school	4900169	3J	Charter	Dixie Montessori Academy	490016901452	100	Dixie Montessori Academy	Regular School	Yes	Elementary	KG	07	2020	grade_1	45	45
1194937	1194937	UT	school	4900073	4E	Charter	Dual Immersion Academy	490007301187	100	Dual Immersion Academy	Regular School	Yes	Elementary	KG	08	2020	grade_1	53	53
1194938	1194938	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_1	99	99
1194939	1194939	UT	school	4900036	A8	Charter	East Hollywood High	490003601072	700	East Hollywood High	Regular School	Yes	High	09	12	2020	grade_1	0	0
1194940	1194940	UT	school	4900070	5E	Charter	Edith Bowen Laboratory School	490007001176	108	Edith Bowen Laboratory School	Regular School	Yes	Elementary	KG	06	2020	grade_1	48	48
1194941	1194941	UT	school	4900155	3H	Charter	Endeavor Hall	490015501407	100	Endeavor Hall	Regular School	Yes	Elementary	KG	06	2020	grade_1	56	56
1194942	1194942	UT	school	4900041	3C	Charter	Entheos Academy	490004101136	100	Entheos Academy	Regular School	Yes	Elementary	KG	08	2020	grade_1	73	73
1194943	1194943	UT	school	4900041	3C	Charter	Entheos Academy	490004101437	110	Entheos Academy Magna	Regular School	Yes	Elementary	KG	08	2020	grade_1	56	56
1194944	1194944	UT	school	4900161	2I	Charter	Esperanza School	490016101440	100	Esperanza School	Regular School	Yes	Elementary	KG	06	2020	grade_1	80	80
1194945	1194945	UT	school	4900136	7F	Charter	Excelsior Academy	490013601272	100	Excelsior Academy	Regular School	Yes	Elementary	KG	08	2020	grade_1	145	145
1194946	1194946	UT	school	4900019	98	Charter	Fast Forward High	490001900906	700	Fast Forward High	Alternative School	Yes	High	09	12	2020	grade_1	0	0
1194947	1194947	UT	school	4900187	6K	Charter	Franklin Discovery Academy	490018701488	100	Franklin Discovery Academy	Regular School	Yes	Elementary	KG	06	2020	grade_1	110	110
1194948	1194948	UT	school	4900062	82	Charter	Freedom Preparatory Academy	490006200992	100	Freedom Preparatory Academy	Regular School	Yes	Other	KG	12	2020	grade_1	121	121
1194949	1194949	UT	school	4900062	82	Charter	Freedom Preparatory Academy	490006201492	105	Freedom Preparatory Academy - Vineyard	Regular School	Yes	Elementary	KG	05	2020	grade_1	120	120
1194950	1194950	UT	school	4900122	7E	Charter	Gateway Preparatory Academy	490012201214	100	Gateway Preparatory Academy	Regular School	Yes	Elementary	KG	08	2020	grade_1	69	69
1194951	1194951	UT	school	4900046	5D	Charter	George Washington Academy	490004601147	100	George Washington Academy	Regular School	Yes	Elementary	KG	07	2020	grade_1	132	132
1194952	1194952	UT	school	4900147	8G	Charter	Good Foundations Academy	490014701389	100	Good Foundations Academy	Regular School	Yes	Elementary	KG	06	2020	grade_1	89	89
1194953	1194953	UT	school	4900177	7J	Charter	Greenwood Charter School	490017701468	100	Greenwood Charter School	Regular School	Yes	Elementary	KG	08	2020	grade_1	54	54
1194954	1194954	UT	school	4900072	1E	Charter	Guadalupe School	490007201174	100	Guadalupe School	Regular School	Yes	Elementary	PK	06	2020	grade_1	43	43
1194955	1194955	UT	school	4900137	8F	Charter	Hawthorn Academy	490013701493	110	Hawthorn Academy South Jordan	Regular School	Yes	Elementary	KG	06	2020	grade_1	92	92
1194956	1194956	UT	school	4900137	8F	Charter	Hawthorn Academy	490013701298	100	Hawthorn Academy	Regular School	Yes	Other	KG	09	2020	grade_1	78	78
1194957	1194957	UT	school	4900156	5H	Charter	Highmark Charter School	490015601415	100	Highmark Charter School	Regular School	Yes	Other	KG	09	2020	grade_1	52	52
1194958	1194958	UT	school	4900194	5L	Charter	Ignite Entrepreneurship Academy	490019401509	300	Ignite Entrepreneurship Academy	Regular School	Yes	Elementary	KG	08	2020	grade_1	85	85
1194959	1194959	UT	school	4900039	2C	Charter	Intech Collegiate Academy	490003901129	600	Intech Collegiate Academy	Regular School	Yes	High	09	12	2020	grade_1	0	0
1194960	1194960	UT	school	4900067	A5	Charter	Itineris Early College High	490006700997	700	Itineris Early College High	Regular School	Yes	High	10	12	2020	grade_1	0	0
1194961	1194961	UT	school	4900139	1G	Charter	Jefferson Academy	490013901289	100	Jefferson Academy	Regular School	Yes	Elementary	KG	06	2020	grade_1	85	85
1194962	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
1194963	1194963	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_1	0	0
1194964	1194964	UT	school	4900043	4C	Charter	Lakeview Academy	490004301144	100	Lakeview Academy	Regular School	Yes	Other	KG	09	2020	grade_1	104	104
1194965	1194965	UT	school	4900196	3L	Charter	Leadership Academy of Utah	490019601516	700	Leadership Academy of Utah	Regular School	Yes	High	06	12	2020	grade_1	0	0
1194966	1194966	UT	school	4900162	3I	Charter	Leadership Learning Academy	490016201438	100	Leadership Learning Academy	Regular School	Yes	Elementary	KG	06	2020	grade_1	84	84
1194967	1194967	UT	school	4900162	3I	Charter	Leadership Learning Academy	490016201522	110	Leadership Learning Academy - Ogden	Regular School	Yes	Elementary	KG	06	2020	grade_1	78	78
1194968	1194968	UT	school	4900045	5C	Charter	Legacy Preparatory Academy	490004501146	100	Legacy Preparatory Academy	Regular School	Yes	Other	KG	09	2020	grade_1	113	113
1194969	1194969	UT	school	4900022	2B	Charter	Lincoln Academy	490002201082	100	Lincoln Academy	Regular School	Yes	Other	KG	09	2020	grade_1	75	75
1194970	1194970	UT	school	4900182	9J	Charter	Lumen Scholar Institute	490018201467	300	Lumen Scholar Institute	Regular School	Yes	Other	KG	12	2020	grade_1	7	7
1194971	1194971	UT	school	4900165	4I	Charter	Mana Academy Charter School	490016501439	700	Mana Academy Charter School	Regular School	Yes	Other	KG	11	2020	grade_1	31	31
1194972	1194972	UT	school	4900144	4G	Charter	Maria Montessori Academy	490014401374	100	Maria Montessori Academy	Regular School	Yes	Other	KG	09	2020	grade_1	55	55
1194973	1194973	UT	school	4900131	8E	Charter	Merit College Preparatory Academy	490013101220	700	Merit College Preparatory Academy	Regular School	Yes	High	07	12	2020	grade_1	0	0
1194974	1194974	UT	school	4900035	A7	Charter	Moab Charter School	490003501085	100	Moab Charter School	Regular School	Yes	Elementary	KG	06	2020	grade_1	14	14
1194975	1194975	UT	school	4900049	7C	Charter	Monticello Academy	490004901150	100	Monticello Academy	Regular School	Yes	Elementary	KG	08	2020	grade_1	77	77
1194976	1194976	UT	school	4900138	9F	Charter	Mountain Heights Academy	490013801285	600	Mountain Heights Academy	Regular School	Yes	High	07	12	2020	grade_1	0	0
1194977	1194977	UT	school	4900175	5J	Charter	Mountain West Montessori Academy	490017501455	300	Mountain West Montessori Academy	Regular School	Yes	Other	KG	09	2020	grade_1	54	54
1194978	1194978	UT	school	4900051	8C	Charter	Mountainville Academy	490005101152	100	Mountainville Academy	Regular School	Yes	Other	KG	09	2020	grade_1	71	71
1194979	1194979	UT	school	4900034	9B	Charter	Navigator Pointe Academy	490003401088	100	Navigator Pointe Academy	Regular School	Yes	Other	KG	09	2020	grade_1	56	56
1194980	1194980	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_1	0	0
1194981	1194981	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_1	0	0
1194982	1194982	UT	school	4900048	6D	Charter	Noah Webster Academy	490004801149	100	Noah Webster Academy	Regular School	Yes	Elementary	KG	06	2020	grade_1	84	84
1194983	1194983	UT	school	4900068	A6	Charter	North Davis Preparatory Academy	490006800998	100	North Davis Preparatory Academy	Regular School	Yes	Other	KG	09	2020	grade_1	113	113
1194984	1194984	UT	school	4900025	5B	Charter	North Star Academy	490002501089	100	North Star Academy	Regular School	Yes	Other	KG	09	2020	grade_1	50	50
1194985	1194985	UT	school	4900021	1C	Charter	Odyssey Charter School	490002101092	100	Odyssey Charter School	Regular School	Yes	Elementary	KG	06	2020	grade_1	65	65
1194986	1194986	UT	school	4900058	68	Charter	Ogden Preparatory Academy	490005800989	100	Ogden Preparatory Academy	Regular School	Yes	Other	KG	09	2020	grade_1	104	104
1194987	1194987	UT	school	4900118	8D	Charter	Open Classroom	490011801135	240	Open Classroom	Regular School	Yes	Elementary	KG	08	2020	grade_1	42	42
1194988	1194988	UT	school	4900159	7H	Charter	Pacific Heritage Academy	490015901406	100	Pacific Heritage Academy	Regular School	Yes	Elementary	KG	08	2020	grade_1	43	43
1194989	1194989	UT	school	4900052	9C	Charter	Paradigm High School	490005201153	700	Paradigm High School	Regular School	Yes	High	07	12	2020	grade_1	0	0
1194990	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
1194991	1194991	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_1	54	54
1194992	1194992	UT	school	4900124	9E	Charter	Providence Hall	490012401202	100	Providence Hall	Regular School	Yes	Other	KG	12	2020	grade_1	125	125
1194993	1194993	UT	school	4900132	1F	Charter	Quest Academy	490013201218	100	Quest Academy	Regular School	Yes	Other	KG	09	2020	grade_1	122	122
1194994	1194994	UT	school	4900064	A2	Charter	Ranches Academy	490006400994	100	Ranches Academy	Regular School	Yes	Elementary	KG	06	2020	grade_1	52	52
1194995	1194995	UT	school	4900032	7B	Charter	Reagan Academy	490003201095	100	Reagan Academy	Regular School	Yes	Elementary	KG	08	2020	grade_1	76	76
1194996	1194996	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_1	0	0
1194997	1194997	UT	school	4900038	1D	Charter	Renaissance Academy	490003801128	100	Renaissance Academy	Regular School	Yes	Elementary	KG	08	2020	grade_1	113	113
1194998	1194998	UT	school	4900125	2F	Charter	Rockwell Charter High School	490012501199	700	Rockwell Charter High School	Regular School	Yes	High	07	12	2020	grade_1	0	0
1194999	1194999	UT	school	4900178	3K	Charter	Roots Charter High School	490017801477	700	Roots Charter High School	Regular School	Yes	High	09	12	2020	grade_1	0	0
1195000	1195000	UT	school	4900018	97	Charter	Salt Lake Arts Academy	490001800905	300	Salt Lake Arts Academy	Regular School	Yes	Middle	05	08	2020	grade_1	0	0
1195001	1195001	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_1	0	0
1195002	1195002	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_1	0	0
1195003	1195003	UT	school	4900170	6J	Charter	Scholar Academy	490017001456	100	Scholar Academy	Regular School	Yes	Elementary	KG	08	2020	grade_1	72	72
1195004	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
1195005	1195005	UT	school	4900042	3D	Charter	Spectrum Academy	490004201137	100	Spectrum Academy	Regular School	Yes	Other	KG	12	2020	grade_1	63	63
1195006	1195006	UT	school	4900042	3D	Charter	Spectrum Academy	490004201464	300	Spectrum Academy - Pleasant Grove	Regular School	Yes	Other	KG	12	2020	grade_1	44	44
1195007	1195007	UT	school	4900188	9K	Charter	St. George Academy	490018801485	700	St. George Academy	Regular School	Yes	High	08	12	2020	grade_1	0	0
1195008	1195008	UT	school	4900037	A9	Charter	Success Academy	490003701470	710	Success DSU	Regular School	Yes	High	10	12	2020	grade_1	0	0
1195009	1195009	UT	school	4900037	A9	Charter	Success Academy	490003701101	700	Success Academy	Regular School	Yes	High	09	12	2020	grade_1	0	0
1195010	1195010	UT	school	4900066	A4	Charter	Summit Academy	490006601499	310	Summit Academy - Bluffdale	Regular School	Yes	Elementary	KG	06	2020	grade_1	74	74

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