enrollments

Data source: Big Local News · About: Big Local

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

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

grade ✖

  • grade_2 · 1,984 ✖
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
1196048 1196048 UT     school 4900066 A4 Charter Summit Academy 490006600996 100 Summit Academy   Regular School Yes Elementary KG 08 2020   grade_2                                                   105                                             105
1196049 1196049 UT     school 4900066 A4 Charter Summit Academy 490006601469 300 Summit Academy - Independence   Regular School Yes Elementary KG 08 2020   grade_2                                                   110                                             110
1196050 1196050 UT     school 4900148 7G Charter Summit Academy High School 490014801396 700 Summit Academy High School   Regular School Yes High 09 12 2020   grade_2                                                   0                                             0
1196051 1196051 UT     school 4900044 4D Charter Syracuse Arts Academy 490004401145 100 Syracuse Arts Academy   Regular School Yes Other KG 09 2020   grade_2                                                   81                                             81
1196052 1196052 UT     school 4900044 4D Charter Syracuse Arts Academy 490004401494 110 Syracuse Arts Academy - North   Regular School Yes Elementary KG 06 2020   grade_2                                                   108                                             108
1196053 1196053 UT     school 4900179 8J Charter Terra Academy 490017901476 300 Terra Academy   Regular School Yes Other KG 12 2020   grade_2                                                   50                                             50
1196054 1196054 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_2                                                   58                                             58
1196055 1196055 UT     school 4900015 94 Charter Thomas Edison 490001500820 100 Thomas Edison   Regular School Yes Elementary KG 08 2020   grade_2                                                   60                                             60
1196056 1196056 UT     school 4900015 94 Charter Thomas Edison 490001501284 110 Thomas Edison - South   Regular School Yes Elementary KG 08 2020   grade_2                                                   65                                             65
1196057 1196057 UT     school 4900016 95 Charter Timpanogos Academy 490001600830 110 Timpanogos Academy   Regular School Yes Elementary KG 06 2020   grade_2                                                   70                                             70
1196058 1196058 UT     school 4900192 7L Charter Treeside Charter School 490019201514 110 Treeside Charter School   Regular School Yes Elementary KG 06 2020   grade_2                                                   72                                             72
1196059 1196059 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_2                                                   0                                             0
1196060 1196060 UT     school 4900013 92 Charter Uintah River High 490001300671 700 Uintah River High   Alternative School Yes High 09 12 2020   grade_2                                                   0                                             0
1196061 1196061 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_2                                                   0                                             0
1196062 1196062 UT     school 4900151 2H Charter Utah Connections Academy 490015101386 101 Utah Connections Academy   Regular School Yes Other KG 12 2020   grade_2                                                   23                                             23
1196063 1196063 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_2                                                   0                                             0
1196064 1196064 UT     school 4900166 1I Charter Utah International Charter School 490016601433 700 Utah International Charter School   Regular School Yes High 07 12 2020   grade_2                                                   0                                             0
1196065 1196065 UT     school 4900176 2K Charter Utah Military Academy 490017601463 700 Utah Military Academy   Regular School Yes High 07 12 2020   grade_2                                                   0                                             0
1196066 1196066 UT     school 4900176 2K Charter Utah Military Academy 490017601501 710 Utah Military Academy - Camp Williams   Regular School Yes High 07 12 2020   grade_2                                                   0                                             0
1196067 1196067 UT     school 4900130 5F Charter Utah Virtual Academy 490013001196 700 Utah Virtual Academy   Regular School Yes Other KG 12 2020   grade_2                                                   83                                             83
1196068 1196068 UT     school 4900158 8H Charter Valley Academy 490015801421 100 Valley Academy   Regular School Yes Elementary KG 08 2020   grade_2                                                   50                                             50
1196069 1196069 UT     school 4900183 1K Charter Vanguard Academy 490018301475 700 Vanguard Academy   Regular School Yes High 07 12 2020   grade_2                                                   0                                             0
1196070 1196070 UT     school 4900133 3F Charter Venture Academy 490013301216 100 Venture Academy   Regular School Yes Other KG 12 2020   grade_2                                                   48                                             48
1196071 1196071 UT     school 4900141 2G Charter Vista School 490014101296 100 Vista School   Regular School Yes Elementary KG 08 2020   grade_2                                                   96                                             96
1196072 1196072 UT     school 4900160 5I Charter Voyage Academy 490016001442 100 Voyage Academy   Regular School Yes Elementary KG 06 2020   grade_2                                                   72                                             72
1196073 1196073 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_2                                                   35                                             35
1196074 1196074 UT     school 4900184 7K Charter Wallace Stegner Academy 490018401489 300 Wallace Stegner Academy   Regular School Yes Elementary KG 08 2020   grade_2                                                   85                                             85
1196075 1196075 UT     school 4900024 4B Charter Wasatch Peak Academy 490002401107 100 Wasatch Peak Academy   Regular School Yes Elementary KG 06 2020   grade_2                                                   74                                             74
1196076 1196076 UT     school 4900185 5K Charter Wasatch Waldorf Charter School 490018501491 300 Wasatch Waldorf Charter School   Regular School Yes Elementary KG 08 2020   grade_2                                                   64                                             64
1196077 1196077 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_2                                                   0                                             0
1196078 1196078 UT     school 4900145 6G Charter Weilenmann School of Discovery 490014501378 100 Weilenmann School of Discovery   Regular School Yes Elementary KG 08 2020   grade_2                                                   69                                             69
1196079 1196079 UT     school 4900168 8I Charter Winter Sports School 490016801444 700 Winter Sports School   Regular School Yes High 09 12 2020   grade_2                                                   0                                             0
1354179 1354179 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_2                                                   0                                             0
1354180 1354180 UT     school 4900198 1M Charter Advantage Arts Academy 490019801524 100 Advantage Arts Academy   Regular School Yes Elementary KG 06 2021   grade_2                                                   57                                             57
1354181 1354181 UT     school 4900186 8K Charter American Academy of Innovation 490018601483 700 American Academy of Innovation   Regular School Yes High 06 12 2021   grade_2                                                   0                                             0
1354182 1354182 UT     school 4900033 8B Charter American Leadership Academy 490003301056 100 American Leadership Academy   Regular School Yes Other KG 12 2021   grade_2                                                   110                                             110
1354183 1354183 UT     school 4900005 74 Charter American Preparatory Academy 490000501404 110 American Preparatory Academy - Accelerated School   Regular School Yes Other KG 12 2021   grade_2                                                   84                                             84
1354184 1354184 UT     school 4900005 74 Charter American Preparatory Academy 490000500801 100 American Preparatory Academy   Regular School Yes Elementary KG 06 2021   grade_2                                                   114                                             114
1354185 1354185 UT     school 4900005 74 Charter American Preparatory Academy 490000501446 130 American Preparatory Academy - Draper #2   Regular School Yes Elementary KG 06 2021   grade_2                                                   176                                             176
1354186 1354186 UT     school 4900005 74 Charter American Preparatory Academy 490000501471 700 American Preparatory Academy - Draper #3   Regular School Yes High 07 12 2021   grade_2                                                   0                                             0
1354187 1354187 UT     school 4900005 74 Charter American Preparatory Academy 490000501520 140 American Preparatory Academy - Salem   Regular School Yes Other KG 10 2021   grade_2                                                   61                                             61
1354188 1354188 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_2                                                   89                                             89
1354189 1354189 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_2                                                   86                                             86
1354190 1354190 UT     school 4900174 2J Charter Ascent Academies of Utah 490017401453 300 Ascent Academies of Utah Farmington   Regular School Yes Other KG 09 2021   grade_2                                                   56                                             56
1354191 1354191 UT     school 4900174 2J Charter Ascent Academies of Utah 490017401490 320 Ascent Academies of Utah Lehi   Regular School Yes Other KG 09 2021   grade_2                                                   68                                             68
1354192 1354192 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_2                                                   81                                             81
1354193 1354193 UT     school 4900181 4K Charter Athenian eAcademy 490018101473 300 Athenian eAcademy   Regular School Yes Other KG 12 2021   grade_2                                                   55                                             55
1354194 1354194 UT     school 4900189 1L Charter Athlos Academy of Utah 490018901503 300 Athlos Academy of Utah   Regular School Yes Elementary KG 08 2021   grade_2                                                   92                                             92
1354195 1354195 UT     school 4900146 3G Charter Bear River Charter School 490014601375 100 Bear River Charter School   Regular School Yes Elementary KG 08 2021   grade_2                                                   20                                             20
1354196 1354196 UT     school 4900023 3B Charter Beehive Science & Technology Academy 490002301060 700 Beehive Science & Technology Academy   Regular School Yes High 06 12 2021   grade_2                                                   0                                             0
1354197 1354197 UT     school 4900195 6L Charter Bonneville Academy 490019501507 300 Bonneville Academy   Regular School Yes Elementary KG 08 2021   grade_2                                                   58                                             58
1354198 1354198 UT     school 4900202 3M Charter Bridge Elementary School 490020201566 100 Bridge Elementary School   Regular School Yes Elementary KG 06 2021   grade_2                                                   89                                             89
1354199 1354199 UT     school 4900074 3E Charter C.S. Lewis Academy 490007401190 100 C.S. Lewis Academy   Regular School Yes Elementary KG 06 2021   grade_2                                                   41                                             41
1354200 1354200 UT     school 4900143 5G Charter Canyon Grove Academy 490014301376 100 Canyon Grove Academy   Regular School Yes Elementary KG 08 2021   grade_2                                                   104                                             104
1354201 1354201 UT     school 4900071 9D Charter Canyon Rim Academy 490007101178 100 Canyon Rim Academy   Regular School Yes Elementary KG 06 2021   grade_2                                                   78                                             78
1354202 1354202 UT     school 4900040 2D Charter Channing Hall 490004001130 100 Channing Hall   Regular School Yes Elementary KG 08 2021   grade_2                                                   66                                             66
1354203 1354203 UT     school 4900009 87 Charter City Academy 490000900742 700 City Academy   Regular School Yes High 07 12 2021   grade_2                                                   0                                             0
1354204 1354204 UT     school 4900065 A3 Charter Davinci Academy 490006500995 700 Davinci Academy   Regular School Yes Other KG 12 2021   grade_2                                                   107                                             107
1354205 1354205 UT     school 4900169 3J Charter Dixie Montessori Academy 490016901452 100 Dixie Montessori Academy   Regular School Yes Elementary KG 07 2021   grade_2                                                   27                                             27
1354206 1354206 UT     school 4900073 4E Charter Dual Immersion Academy 490007301187 100 Dual Immersion Academy   Regular School Yes Elementary KG 08 2021   grade_2                                                   44                                             44
1354207 1354207 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_2                                                   89                                             89
1354208 1354208 UT     school 4900036 A8 Charter East Hollywood High 490003601072 700 East Hollywood High   Regular School Yes High 09 12 2021   grade_2                                                   0                                             0
1354209 1354209 UT     school 4900070 5E Charter Edith Bowen Laboratory School 490007001176 108 Edith Bowen Laboratory School   Regular School Yes Elementary KG 06 2021   grade_2                                                   49                                             49
1354210 1354210 UT     school 4900155 3H Charter Endeavor Hall 490015501407 100 Endeavor Hall   Regular School Yes Elementary KG 08 2021   grade_2                                                   52                                             52
1354211 1354211 UT     school 4900041 3C Charter Entheos Academy 490004101136 100 Entheos Academy   Regular School Yes Other KG 09 2021   grade_2                                                   70                                             70
1354212 1354212 UT     school 4900041 3C Charter Entheos Academy 490004101437 110 Entheos Academy Magna   Regular School Yes Other KG 09 2021   grade_2                                                   56                                             56
1354213 1354213 UT     school 4900161 2I Charter Esperanza School 490016101440 100 Esperanza School   Regular School Yes Elementary KG 06 2021   grade_2                                                   79                                             79
1354214 1354214 UT     school 4900136 7F Charter Excelsior Academy 490013601272 100 Excelsior Academy   Regular School Yes Elementary KG 08 2021   grade_2                                                   148                                             148
1354215 1354215 UT     school 4900019 98 Charter Fast Forward High 490001900906 700 Fast Forward High   Alternative School Yes High 09 12 2021   grade_2                                                   0                                             0
1354216 1354216 UT     school 4900187 6K Charter Franklin Discovery Academy 490018701488 100 Franklin Discovery Academy   Regular School Yes Elementary KG 06 2021   grade_2                                                   107                                             107
1354217 1354217 UT     school 4900062 82 Charter Freedom Preparatory Academy 490006200992 100 Freedom Preparatory Academy   Regular School Yes Other PK 12 2021   grade_2                                                   122                                             122
1354218 1354218 UT     school 4900062 82 Charter Freedom Preparatory Academy 490006201492 105 Freedom Preparatory Academy - Vineyard   Regular School Yes Elementary PK 05 2021   grade_2                                                   102                                             102
1354219 1354219 UT     school 4900122 7E Charter Gateway Preparatory Academy 490012201214 100 Gateway Preparatory Academy   Regular School Yes Elementary KG 08 2021   grade_2                                                   76                                             76
1354220 1354220 UT     school 4900046 5D Charter George Washington Academy 490004601147 100 George Washington Academy   Regular School Yes Elementary KG 08 2021   grade_2                                                   140                                             140
1354221 1354221 UT     school 4900147 8G Charter Good Foundations Academy 490014701389 100 Good Foundations Academy   Regular School Yes Elementary KG 06 2021   grade_2                                                   65                                             65
1354222 1354222 UT     school 4900177 7J Charter Greenwood Charter School 490017701468 100 Greenwood Charter School   Regular School Yes Elementary KG 08 2021   grade_2                                                   49                                             49
1354223 1354223 UT     school 4900072 1E Charter Guadalupe School 490007201174 100 Guadalupe School   Regular School Yes Elementary PK 06 2021   grade_2                                                   40                                             40
1354224 1354224 UT     school 4900137 8F Charter Hawthorn Academy 490013701493 110 Hawthorn Academy South Jordan   Regular School Yes Elementary KG 06 2021   grade_2                                                   85                                             85
1354225 1354225 UT     school 4900137 8F Charter Hawthorn Academy 490013701298 100 Hawthorn Academy   Regular School Yes Other KG 09 2021   grade_2                                                   75                                             75
1354226 1354226 UT     school 4900156 5H Charter Highmark Charter School 490015601415 100 Highmark Charter School   Regular School Yes Other KG 09 2021   grade_2                                                   51                                             51
1354227 1354227 UT     school 4900194 5L Charter Ignite Entrepreneurship Academy 490019401509 300 Ignite Entrepreneurship Academy   Regular School Yes Elementary KG 08 2021   grade_2                                                   78                                             78
1354228 1354228 UT     school 4900039 2C Charter Intech Collegiate Academy 490003901129 600 Intech Collegiate Academy   Regular School Yes High 07 12 2021   grade_2                                                   0                                             0
1354229 1354229 UT     school 4900067 A5 Charter Itineris Early College High 490006700997 700 Itineris Early College High   Regular School Yes High 10 12 2021   grade_2                                                   0                                             0
1354230 1354230 UT     school 4900139 1G Charter Jefferson Academy 490013901289 100 Jefferson Academy   Regular School Yes Elementary KG 06 2021   grade_2                                                   101                                             101
1354231 1354231 UT     school 4900014 93 Charter John Hancock Charter School 490001400811 105 John Hancock Charter School   Regular School Yes Elementary KG 08 2021   grade_2                                                   24                                             24
1354232 1354232 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_2                                                   0                                             0
1354233 1354233 UT     school 4900043 4C Charter Lakeview Academy 490004301144 100 Lakeview Academy   Regular School Yes Other KG 09 2021   grade_2                                                   101                                             101
1354234 1354234 UT     school 4900196 3L Charter Leadership Academy of Utah 490019601516 700 Leadership Academy of Utah   Regular School Yes High 06 12 2021   grade_2                                                   0                                             0
1354235 1354235 UT     school 4900162 3I Charter Leadership Learning Academy 490016201438 100 Leadership Learning Academy   Regular School Yes Elementary KG 06 2021   grade_2                                                   87                                             87
1354236 1354236 UT     school 4900162 3I Charter Leadership Learning Academy 490016201522 110 Leadership Learning Academy - Ogden   Regular School Yes Elementary KG 06 2021   grade_2                                                   63                                             63
1354237 1354237 UT     school 4900045 5C Charter Legacy Preparatory Academy 490004501146 100 Legacy Preparatory Academy   Regular School Yes Other KG 09 2021   grade_2                                                   105                                             105
1354238 1354238 UT     school 4900022 2B Charter Lincoln Academy 490002201082 100 Lincoln Academy   Regular School Yes Other KG 09 2021   grade_2                                                   75                                             75
1354239 1354239 UT     school 4900182 9J Charter Lumen Scholar Institute 490018201467 300 Lumen Scholar Institute   Regular School Yes Other KG 12 2021   grade_2                                                   20                                             20
1354240 1354240 UT     school 4900165 4I Charter Mana Academy Charter School 490016501439 700 Mana Academy Charter School   Regular School Yes Other KG 12 2021   grade_2                                                   26                                             26
1354241 1354241 UT     school 4900144 4G Charter Maria Montessori Academy 490014401374 100 Maria Montessori Academy   Regular School Yes Other KG 09 2021   grade_2                                                   39                                             39
1354242 1354242 UT     school 4900131 8E Charter Merit College Preparatory Academy 490013101220 700 Merit College Preparatory Academy   Regular School Yes High 07 12 2021   grade_2                                                   0                                             0
1354243 1354243 UT     school 4900035 A7 Charter Moab Charter School 490003501085 100 Moab Charter School   Regular School Yes Elementary KG 06 2021   grade_2                                                   13                                             13
1354244 1354244 UT     school 4900049 7C Charter Monticello Academy 490004901150 100 Monticello Academy   Regular School Yes Elementary KG 08 2021   grade_2                                                   77                                             77
1354245 1354245 UT     school 4900049 7C Charter Monticello Academy 490004901556 105 Monticello Academy West Point   Regular School Yes Elementary KG 06 2021   grade_2                                                   25                                             25
1354246 1354246 UT     school 4900138 9F Charter Mountain Heights Academy 490013801285 600 Mountain Heights Academy   Regular School Yes High 07 12 2021   grade_2                                                   0                                             0

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