enrollments

Data source: Big Local News · About: Big Local

2,084 rows where grade = "grade_1" and state = "UT" sorted by district_state_id descending

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

grade ✖

  • grade_1 · 2,084 ✖
Link 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
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
1353232 1353232 UT     school 4900037 A9 Charter Success Academy 490003701470 710 Success DSU   Regular School Yes High 10 12 2021   grade_1                                                   0                                             0
1353233 1353233 UT     school 4900037 A9 Charter Success Academy 490003701101 700 Success Academy   Regular School Yes High 09 12 2021   grade_1                                                   0                                             0
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
1353161 1353161 UT     school 4900036 A8 Charter East Hollywood High 490003601072 700 East Hollywood High   Regular School Yes High 09 12 2021   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
1353196 1353196 UT     school 4900035 A7 Charter Moab Charter School 490003501085 100 Moab Charter School   Regular School Yes Elementary KG 06 2021   grade_1                                                   13                                             13
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
1353207 1353207 UT     school 4900068 A6 Charter North Davis Preparatory Academy 490006800998 100 North Davis Preparatory Academy   Regular School Yes Other KG 09 2021   grade_1                                                   110                                             110
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
1353182 1353182 UT     school 4900067 A5 Charter Itineris Early College High 490006700997 700 Itineris Early College High   Regular School Yes High 10 12 2021   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
1195011 1195011 UT     school 4900066 A4 Charter Summit Academy 490006600996 100 Summit Academy   Regular School Yes Elementary KG 08 2020   grade_1                                                   97                                             97
1195012 1195012 UT     school 4900066 A4 Charter Summit Academy 490006601469 300 Summit Academy - Independence   Regular School Yes Elementary KG 08 2020   grade_1                                                   107                                             107
1353234 1353234 UT     school 4900066 A4 Charter Summit Academy 490006601499 310 Summit Academy - Bluffdale   Regular School Yes Elementary KG 06 2021   grade_1                                                   55                                             55
1353235 1353235 UT     school 4900066 A4 Charter Summit Academy 490006600996 100 Summit Academy   Regular School Yes Elementary KG 08 2021   grade_1                                                   72                                             72
1353236 1353236 UT     school 4900066 A4 Charter Summit Academy 490006601469 300 Summit Academy - Independence   Regular School Yes Elementary KG 08 2021   grade_1                                                   87                                             87
1194935 1194935 UT     school 4900065 A3 Charter Davinci Academy 490006500995 700 Davinci Academy   Regular School Yes Other KG 12 2020   grade_1                                                   126                                             126
1353157 1353157 UT     school 4900065 A3 Charter Davinci Academy 490006500995 700 Davinci Academy   Regular School Yes Other KG 12 2021   grade_1                                                   101                                             101
1194994 1194994 UT     school 4900064 A2 Charter Ranches Academy 490006400994 100 Ranches Academy   Regular School Yes Elementary KG 06 2020   grade_1                                                   52                                             52
1353218 1353218 UT     school 4900064 A2 Charter Ranches Academy 490006400994 100 Ranches Academy   Regular School Yes Elementary KG 06 2021   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
1353204 1353204 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_1                                                   0                                             0
1353205 1353205 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_1                                                   0                                             0
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
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
1353231 1353231 UT     school 4900188 9K Charter St. George Academy 490018801485 700 St. George Academy   Regular School Yes High 08 12 2021   grade_1                                                   0                                             0
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
1353192 1353192 UT     school 4900182 9J Charter Lumen Scholar Institute 490018201467 300 Lumen Scholar Institute   Regular School Yes Other KG 12 2021   grade_1                                                   29                                             29
1195024 1195024 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_1                                                   0                                             0
1353248 1353248 UT     school 4900171 9I Charter Utah Career Path High School 490017101460 600 Utah Career Path High School   Regular School Yes High 09 12 2021   grade_1                                                   0                                             0
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
1353199 1353199 UT     school 4900138 9F Charter Mountain Heights Academy 490013801285 600 Mountain Heights Academy   Regular School Yes High 07 12 2021   grade_1                                                   0                                             0
1194992 1194992 UT     school 4900124 9E Charter Providence Hall 490012401202 100 Providence Hall   Regular School Yes Other KG 12 2020   grade_1                                                   125                                             125
1353216 1353216 UT     school 4900124 9E Charter Providence Hall 490012401202 100 Providence Hall   Regular School Yes Other KG 12 2021   grade_1                                                   121                                             121
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
1353154 1353154 UT     school 4900071 9D Charter Canyon Rim Academy 490007101178 100 Canyon Rim Academy   Regular School Yes Elementary KG 06 2021   grade_1                                                   78                                             78
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
1353213 1353213 UT     school 4900052 9C Charter Paradigm High School 490005201153 700 Paradigm High School   Regular School Yes High 07 12 2021   grade_1                                                   0                                             0
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
1353203 1353203 UT     school 4900034 9B Charter Navigator Pointe Academy 490003401088 100 Navigator Pointe Academy   Regular School Yes Other KG 09 2021   grade_1                                                   73                                             73
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
1353168 1353168 UT     school 4900019 98 Charter Fast Forward High 490001900906 700 Fast Forward High   Alternative School Yes High 09 12 2021   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
1353224 1353224 UT     school 4900018 97 Charter Salt Lake Arts Academy 490001800905 300 Salt Lake Arts Academy   Regular School Yes Middle 05 08 2021   grade_1                                                   0                                             0
1195020 1195020 UT     school 4900016 95 Charter Timpanogos Academy 490001600830 110 Timpanogos Academy   Regular School Yes Elementary KG 06 2020   grade_1                                                   80                                             80
1353244 1353244 UT     school 4900016 95 Charter Timpanogos Academy 490001600830 110 Timpanogos Academy   Regular School Yes Elementary KG 06 2021   grade_1                                                   72                                             72
1195018 1195018 UT     school 4900015 94 Charter Thomas Edison 490001500820 100 Thomas Edison   Regular School Yes Elementary KG 08 2020   grade_1                                                   60                                             60
1195019 1195019 UT     school 4900015 94 Charter Thomas Edison 490001501284 110 Thomas Edison - South   Regular School Yes Elementary KG 08 2020   grade_1                                                   72                                             72
1353242 1353242 UT     school 4900015 94 Charter Thomas Edison 490001500820 100 Thomas Edison   Regular School Yes Elementary KG 08 2021   grade_1                                                   54                                             54
1353243 1353243 UT     school 4900015 94 Charter Thomas Edison 490001501284 110 Thomas Edison - South   Regular School Yes Elementary KG 08 2021   grade_1                                                   57                                             57
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
1353184 1353184 UT     school 4900014 93 Charter John Hancock Charter School 490001400811 105 John Hancock Charter School   Regular School Yes Elementary KG 08 2021   grade_1                                                   23                                             23
1195023 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
1353247 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
1195022 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
1353246 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
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
1353220 1353220 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_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
1353134 1353134 UT     school 4900186 8K Charter American Academy of Innovation 490018601483 700 American Academy of Innovation   Regular School Yes High 06 12 2021   grade_1                                                   0                                             0
1195016 1195016 UT     school 4900179 8J Charter Terra Academy 490017901476 300 Terra Academy   Regular School Yes Other KG 12 2020   grade_1                                                   50                                             50
1353240 1353240 UT     school 4900179 8J Charter Terra Academy 490017901476 300 Terra Academy   Regular School Yes Other KG 12 2021   grade_1                                                   50                                             50
1195042 1195042 UT     school 4900168 8I Charter Winter Sports School 490016801444 700 Winter Sports School   Regular School Yes High 09 12 2020   grade_1                                                   0                                             0
1353266 1353266 UT     school 4900168 8I Charter Winter Sports School 490016801444 700 Winter Sports School   Regular School Yes High 09 12 2021   grade_1                                                   0                                             0
1195031 1195031 UT     school 4900158 8H Charter Valley Academy 490015801421 100 Valley Academy   Regular School Yes Elementary KG 08 2020   grade_1                                                   62                                             62
1353255 1353255 UT     school 4900158 8H Charter Valley Academy 490015801421 100 Valley Academy   Regular School Yes Elementary KG 08 2021   grade_1                                                   59                                             59
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
1353174 1353174 UT     school 4900147 8G Charter Good Foundations Academy 490014701389 100 Good Foundations Academy   Regular School Yes Elementary KG 06 2021   grade_1                                                   69                                             69
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
1353177 1353177 UT     school 4900137 8F Charter Hawthorn Academy 490013701493 110 Hawthorn Academy South Jordan   Regular School Yes Elementary KG 06 2021   grade_1                                                   82                                             82
1353178 1353178 UT     school 4900137 8F Charter Hawthorn Academy 490013701298 100 Hawthorn Academy   Regular School Yes Other KG 09 2021   grade_1                                                   65                                             65
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
1353195 1353195 UT     school 4900131 8E Charter Merit College Preparatory Academy 490013101220 700 Merit College Preparatory Academy   Regular School Yes High 07 12 2021   grade_1                                                   0                                             0
1194987 1194987 UT     school 4900118 8D Charter Open Classroom 490011801135 240 Open Classroom   Regular School Yes Elementary KG 08 2020   grade_1                                                   42                                             42
1353211 1353211 UT     school 4900118 8D Charter Open Classroom 490011801135 240 Open Classroom   Regular School Yes Elementary KG 08 2021   grade_1                                                   43                                             43
1194978 1194978 UT     school 4900051 8C Charter Mountainville Academy 490005101152 100 Mountainville Academy   Regular School Yes Other KG 09 2020   grade_1                                                   71                                             71
1353202 1353202 UT     school 4900051 8C Charter Mountainville Academy 490005101152 100 Mountainville Academy   Regular School Yes Other KG 09 2021   grade_1                                                   79                                             79
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
1353135 1353135 UT     school 4900033 8B Charter American Leadership Academy 490003301056 100 American Leadership Academy   Regular School Yes Other KG 12 2021   grade_1                                                   131                                             131
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
1353228 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
1194934 1194934 UT     school 4900009 87 Charter City Academy 490000900742 700 City Academy   Regular School Yes High 07 12 2020   grade_1                                                   0                                             0
1353156 1353156 UT     school 4900009 87 Charter City Academy 490000900742 700 City Academy   Regular School Yes High 07 12 2021   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
1353214 1353214 UT     school 4900008 86 Charter Pinnacle Canyon Academy 490000800629 100 Pinnacle Canyon Academy   Regular School Yes Other PK 12 2021   grade_1                                                   23                                             23
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
1353132 1353132 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_1                                                   0                                             0
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
1353170 1353170 UT     school 4900062 82 Charter Freedom Preparatory Academy 490006200992 100 Freedom Preparatory Academy   Regular School Yes Other PK 12 2021   grade_1                                                   129                                             129
1353171 1353171 UT     school 4900062 82 Charter Freedom Preparatory Academy 490006201492 105 Freedom Preparatory Academy - Vineyard   Regular School Yes Elementary PK 05 2021   grade_1                                                   111                                             111
1195036 1195036 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_1                                                   33                                             33
1353260 1353260 UT     school 4900061 81 Charter Walden School of Liberal Arts 490006100991 300 Walden School of Liberal Arts   Regular School Yes Other KG 12 2021   grade_1                                                   31                                             31
1195021 1195021 UT     school 4900192 7L Charter Treeside Charter School 490019201514 110 Treeside Charter School   Regular School Yes Elementary KG 06 2020   grade_1                                                   85                                             85
1353245 1353245 UT     school 4900192 7L Charter Treeside Charter School 490019201514 110 Treeside Charter School   Regular School Yes Elementary KG 06 2021   grade_1                                                   85                                             85
1195037 1195037 UT     school 4900184 7K Charter Wallace Stegner Academy 490018401489 300 Wallace Stegner Academy   Regular School Yes Elementary KG 08 2020   grade_1                                                   90                                             90

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

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