enrollments

Data source: Big Local News · About: Big Local

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

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

grade ✖

  • grade_4 · 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
1198122 1198122 UT     school 4900066 A4 Charter Summit Academy 490006600996 100 Summit Academy   Regular School Yes Elementary KG 08 2020   grade_4                                                   116                                             116
1198123 1198123 UT     school 4900066 A4 Charter Summit Academy 490006601469 300 Summit Academy - Independence   Regular School Yes Elementary KG 08 2020   grade_4                                                   108                                             108
1198124 1198124 UT     school 4900148 7G Charter Summit Academy High School 490014801396 700 Summit Academy High School   Regular School Yes High 09 12 2020   grade_4                                                   0                                             0
1198125 1198125 UT     school 4900044 4D Charter Syracuse Arts Academy 490004401145 100 Syracuse Arts Academy   Regular School Yes Other KG 09 2020   grade_4                                                   84                                             84
1198126 1198126 UT     school 4900044 4D Charter Syracuse Arts Academy 490004401494 110 Syracuse Arts Academy - North   Regular School Yes Elementary KG 06 2020   grade_4                                                   106                                             106
1198127 1198127 UT     school 4900179 8J Charter Terra Academy 490017901476 300 Terra Academy   Regular School Yes Other KG 12 2020   grade_4                                                   50                                             50
1198128 1198128 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_4                                                   58                                             58
1198129 1198129 UT     school 4900015 94 Charter Thomas Edison 490001500820 100 Thomas Edison   Regular School Yes Elementary KG 08 2020   grade_4                                                   59                                             59
1198130 1198130 UT     school 4900015 94 Charter Thomas Edison 490001501284 110 Thomas Edison - South   Regular School Yes Elementary KG 08 2020   grade_4                                                   71                                             71
1198131 1198131 UT     school 4900016 95 Charter Timpanogos Academy 490001600830 110 Timpanogos Academy   Regular School Yes Elementary KG 06 2020   grade_4                                                   68                                             68
1198132 1198132 UT     school 4900192 7L Charter Treeside Charter School 490019201514 110 Treeside Charter School   Regular School Yes Elementary KG 06 2020   grade_4                                                   65                                             65
1198133 1198133 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_4                                                   0                                             0
1198134 1198134 UT     school 4900013 92 Charter Uintah River High 490001300671 700 Uintah River High   Alternative School Yes High 09 12 2020   grade_4                                                   0                                             0
1198135 1198135 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_4                                                   0                                             0
1198136 1198136 UT     school 4900151 2H Charter Utah Connections Academy 490015101386 101 Utah Connections Academy   Regular School Yes Other KG 12 2020   grade_4                                                   37                                             37
1198137 1198137 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_4                                                   0                                             0
1198138 1198138 UT     school 4900166 1I Charter Utah International Charter School 490016601433 700 Utah International Charter School   Regular School Yes High 07 12 2020   grade_4                                                   0                                             0
1198139 1198139 UT     school 4900176 2K Charter Utah Military Academy 490017601463 700 Utah Military Academy   Regular School Yes High 07 12 2020   grade_4                                                   0                                             0
1198140 1198140 UT     school 4900176 2K Charter Utah Military Academy 490017601501 710 Utah Military Academy - Camp Williams   Regular School Yes High 07 12 2020   grade_4                                                   0                                             0
1198141 1198141 UT     school 4900130 5F Charter Utah Virtual Academy 490013001196 700 Utah Virtual Academy   Regular School Yes Other KG 12 2020   grade_4                                                   104                                             104
1198142 1198142 UT     school 4900158 8H Charter Valley Academy 490015801421 100 Valley Academy   Regular School Yes Elementary KG 08 2020   grade_4                                                   60                                             60
1198143 1198143 UT     school 4900183 1K Charter Vanguard Academy 490018301475 700 Vanguard Academy   Regular School Yes High 07 12 2020   grade_4                                                   0                                             0
1198144 1198144 UT     school 4900133 3F Charter Venture Academy 490013301216 100 Venture Academy   Regular School Yes Other KG 12 2020   grade_4                                                   54                                             54
1198145 1198145 UT     school 4900141 2G Charter Vista School 490014101296 100 Vista School   Regular School Yes Elementary KG 08 2020   grade_4                                                   108                                             108
1198146 1198146 UT     school 4900160 5I Charter Voyage Academy 490016001442 100 Voyage Academy   Regular School Yes Elementary KG 06 2020   grade_4                                                   78                                             78
1198147 1198147 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_4                                                   33                                             33
1198148 1198148 UT     school 4900184 7K Charter Wallace Stegner Academy 490018401489 300 Wallace Stegner Academy   Regular School Yes Elementary KG 08 2020   grade_4                                                   67                                             67
1198149 1198149 UT     school 4900024 4B Charter Wasatch Peak Academy 490002401107 100 Wasatch Peak Academy   Regular School Yes Elementary KG 06 2020   grade_4                                                   50                                             50
1198150 1198150 UT     school 4900185 5K Charter Wasatch Waldorf Charter School 490018501491 300 Wasatch Waldorf Charter School   Regular School Yes Elementary KG 08 2020   grade_4                                                   97                                             97
1198151 1198151 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_4                                                   0                                             0
1198152 1198152 UT     school 4900145 6G Charter Weilenmann School of Discovery 490014501378 100 Weilenmann School of Discovery   Regular School Yes Elementary KG 08 2020   grade_4                                                   49                                             49
1198153 1198153 UT     school 4900168 8I Charter Winter Sports School 490016801444 700 Winter Sports School   Regular School Yes High 09 12 2020   grade_4                                                   0                                             0
1356273 1356273 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_4                                                   0                                             0
1356274 1356274 UT     school 4900198 1M Charter Advantage Arts Academy 490019801524 100 Advantage Arts Academy   Regular School Yes Elementary KG 06 2021   grade_4                                                   45                                             45
1356275 1356275 UT     school 4900186 8K Charter American Academy of Innovation 490018601483 700 American Academy of Innovation   Regular School Yes High 06 12 2021   grade_4                                                   0                                             0
1356276 1356276 UT     school 4900033 8B Charter American Leadership Academy 490003301056 100 American Leadership Academy   Regular School Yes Other KG 12 2021   grade_4                                                   115                                             115
1356277 1356277 UT     school 4900005 74 Charter American Preparatory Academy 490000501404 110 American Preparatory Academy - Accelerated School   Regular School Yes Other KG 12 2021   grade_4                                                   133                                             133
1356278 1356278 UT     school 4900005 74 Charter American Preparatory Academy 490000500801 100 American Preparatory Academy   Regular School Yes Elementary KG 06 2021   grade_4                                                   93                                             93
1356279 1356279 UT     school 4900005 74 Charter American Preparatory Academy 490000501446 130 American Preparatory Academy - Draper #2   Regular School Yes Elementary KG 06 2021   grade_4                                                   165                                             165
1356280 1356280 UT     school 4900005 74 Charter American Preparatory Academy 490000501471 700 American Preparatory Academy - Draper #3   Regular School Yes High 07 12 2021   grade_4                                                   0                                             0
1356281 1356281 UT     school 4900005 74 Charter American Preparatory Academy 490000501520 140 American Preparatory Academy - Salem   Regular School Yes Other KG 10 2021   grade_4                                                   52                                             52
1356282 1356282 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_4                                                   76                                             76
1356283 1356283 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_4                                                   64                                             64
1356284 1356284 UT     school 4900174 2J Charter Ascent Academies of Utah 490017401453 300 Ascent Academies of Utah Farmington   Regular School Yes Other KG 09 2021   grade_4                                                   49                                             49
1356285 1356285 UT     school 4900174 2J Charter Ascent Academies of Utah 490017401490 320 Ascent Academies of Utah Lehi   Regular School Yes Other KG 09 2021   grade_4                                                   62                                             62
1356286 1356286 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_4                                                   77                                             77
1356287 1356287 UT     school 4900181 4K Charter Athenian eAcademy 490018101473 300 Athenian eAcademy   Regular School Yes Other KG 12 2021   grade_4                                                   54                                             54
1356288 1356288 UT     school 4900189 1L Charter Athlos Academy of Utah 490018901503 300 Athlos Academy of Utah   Regular School Yes Elementary KG 08 2021   grade_4                                                   87                                             87
1356289 1356289 UT     school 4900146 3G Charter Bear River Charter School 490014601375 100 Bear River Charter School   Regular School Yes Elementary KG 08 2021   grade_4                                                   17                                             17
1356290 1356290 UT     school 4900023 3B Charter Beehive Science & Technology Academy 490002301060 700 Beehive Science & Technology Academy   Regular School Yes High 06 12 2021   grade_4                                                   0                                             0
1356291 1356291 UT     school 4900195 6L Charter Bonneville Academy 490019501507 300 Bonneville Academy   Regular School Yes Elementary KG 08 2021   grade_4                                                   54                                             54
1356292 1356292 UT     school 4900202 3M Charter Bridge Elementary School 490020201566 100 Bridge Elementary School   Regular School Yes Elementary KG 06 2021   grade_4                                                   57                                             57
1356293 1356293 UT     school 4900074 3E Charter C.S. Lewis Academy 490007401190 100 C.S. Lewis Academy   Regular School Yes Elementary KG 06 2021   grade_4                                                   34                                             34
1356294 1356294 UT     school 4900143 5G Charter Canyon Grove Academy 490014301376 100 Canyon Grove Academy   Regular School Yes Elementary KG 08 2021   grade_4                                                   81                                             81
1356295 1356295 UT     school 4900071 9D Charter Canyon Rim Academy 490007101178 100 Canyon Rim Academy   Regular School Yes Elementary KG 06 2021   grade_4                                                   77                                             77
1356296 1356296 UT     school 4900040 2D Charter Channing Hall 490004001130 100 Channing Hall   Regular School Yes Elementary KG 08 2021   grade_4                                                   74                                             74
1356297 1356297 UT     school 4900009 87 Charter City Academy 490000900742 700 City Academy   Regular School Yes High 07 12 2021   grade_4                                                   0                                             0
1356298 1356298 UT     school 4900065 A3 Charter Davinci Academy 490006500995 700 Davinci Academy   Regular School Yes Other KG 12 2021   grade_4                                                   106                                             106
1356299 1356299 UT     school 4900169 3J Charter Dixie Montessori Academy 490016901452 100 Dixie Montessori Academy   Regular School Yes Elementary KG 07 2021   grade_4                                                   27                                             27
1356300 1356300 UT     school 4900073 4E Charter Dual Immersion Academy 490007301187 100 Dual Immersion Academy   Regular School Yes Elementary KG 08 2021   grade_4                                                   57                                             57
1356301 1356301 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_4                                                   99                                             99
1356302 1356302 UT     school 4900036 A8 Charter East Hollywood High 490003601072 700 East Hollywood High   Regular School Yes High 09 12 2021   grade_4                                                   0                                             0
1356303 1356303 UT     school 4900070 5E Charter Edith Bowen Laboratory School 490007001176 108 Edith Bowen Laboratory School   Regular School Yes Elementary KG 06 2021   grade_4                                                   52                                             52
1356304 1356304 UT     school 4900155 3H Charter Endeavor Hall 490015501407 100 Endeavor Hall   Regular School Yes Elementary KG 08 2021   grade_4                                                   47                                             47
1356305 1356305 UT     school 4900041 3C Charter Entheos Academy 490004101136 100 Entheos Academy   Regular School Yes Other KG 09 2021   grade_4                                                   65                                             65
1356306 1356306 UT     school 4900041 3C Charter Entheos Academy 490004101437 110 Entheos Academy Magna   Regular School Yes Other KG 09 2021   grade_4                                                   50                                             50
1356307 1356307 UT     school 4900161 2I Charter Esperanza School 490016101440 100 Esperanza School   Regular School Yes Elementary KG 06 2021   grade_4                                                   77                                             77
1356308 1356308 UT     school 4900136 7F Charter Excelsior Academy 490013601272 100 Excelsior Academy   Regular School Yes Elementary KG 08 2021   grade_4                                                   138                                             138
1356309 1356309 UT     school 4900019 98 Charter Fast Forward High 490001900906 700 Fast Forward High   Alternative School Yes High 09 12 2021   grade_4                                                   0                                             0
1356310 1356310 UT     school 4900187 6K Charter Franklin Discovery Academy 490018701488 100 Franklin Discovery Academy   Regular School Yes Elementary KG 06 2021   grade_4                                                   76                                             76
1356311 1356311 UT     school 4900062 82 Charter Freedom Preparatory Academy 490006200992 100 Freedom Preparatory Academy   Regular School Yes Other PK 12 2021   grade_4                                                   118                                             118
1356312 1356312 UT     school 4900062 82 Charter Freedom Preparatory Academy 490006201492 105 Freedom Preparatory Academy - Vineyard   Regular School Yes Elementary PK 05 2021   grade_4                                                   75                                             75
1356313 1356313 UT     school 4900122 7E Charter Gateway Preparatory Academy 490012201214 100 Gateway Preparatory Academy   Regular School Yes Elementary KG 08 2021   grade_4                                                   86                                             86
1356314 1356314 UT     school 4900046 5D Charter George Washington Academy 490004601147 100 George Washington Academy   Regular School Yes Elementary KG 08 2021   grade_4                                                   133                                             133
1356315 1356315 UT     school 4900147 8G Charter Good Foundations Academy 490014701389 100 Good Foundations Academy   Regular School Yes Elementary KG 06 2021   grade_4                                                   62                                             62
1356316 1356316 UT     school 4900177 7J Charter Greenwood Charter School 490017701468 100 Greenwood Charter School   Regular School Yes Elementary KG 08 2021   grade_4                                                   45                                             45
1356317 1356317 UT     school 4900072 1E Charter Guadalupe School 490007201174 100 Guadalupe School   Regular School Yes Elementary PK 06 2021   grade_4                                                   34                                             34
1356318 1356318 UT     school 4900137 8F Charter Hawthorn Academy 490013701493 110 Hawthorn Academy South Jordan   Regular School Yes Elementary KG 06 2021   grade_4                                                   82                                             82
1356319 1356319 UT     school 4900137 8F Charter Hawthorn Academy 490013701298 100 Hawthorn Academy   Regular School Yes Other KG 09 2021   grade_4                                                   75                                             75
1356320 1356320 UT     school 4900156 5H Charter Highmark Charter School 490015601415 100 Highmark Charter School   Regular School Yes Other KG 09 2021   grade_4                                                   55                                             55
1356321 1356321 UT     school 4900194 5L Charter Ignite Entrepreneurship Academy 490019401509 300 Ignite Entrepreneurship Academy   Regular School Yes Elementary KG 08 2021   grade_4                                                   67                                             67
1356322 1356322 UT     school 4900039 2C Charter Intech Collegiate Academy 490003901129 600 Intech Collegiate Academy   Regular School Yes High 07 12 2021   grade_4                                                   0                                             0
1356323 1356323 UT     school 4900067 A5 Charter Itineris Early College High 490006700997 700 Itineris Early College High   Regular School Yes High 10 12 2021   grade_4                                                   0                                             0
1356324 1356324 UT     school 4900139 1G Charter Jefferson Academy 490013901289 100 Jefferson Academy   Regular School Yes Elementary KG 06 2021   grade_4                                                   84                                             84
1356325 1356325 UT     school 4900014 93 Charter John Hancock Charter School 490001400811 105 John Hancock Charter School   Regular School Yes Elementary KG 08 2021   grade_4                                                   21                                             21
1356326 1356326 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_4                                                   0                                             0
1356327 1356327 UT     school 4900043 4C Charter Lakeview Academy 490004301144 100 Lakeview Academy   Regular School Yes Other KG 09 2021   grade_4                                                   102                                             102
1356328 1356328 UT     school 4900196 3L Charter Leadership Academy of Utah 490019601516 700 Leadership Academy of Utah   Regular School Yes High 06 12 2021   grade_4                                                   0                                             0
1356329 1356329 UT     school 4900162 3I Charter Leadership Learning Academy 490016201438 100 Leadership Learning Academy   Regular School Yes Elementary KG 06 2021   grade_4                                                   64                                             64
1356330 1356330 UT     school 4900162 3I Charter Leadership Learning Academy 490016201522 110 Leadership Learning Academy - Ogden   Regular School Yes Elementary KG 06 2021   grade_4                                                   50                                             50
1356331 1356331 UT     school 4900045 5C Charter Legacy Preparatory Academy 490004501146 100 Legacy Preparatory Academy   Regular School Yes Other KG 09 2021   grade_4                                                   102                                             102
1356332 1356332 UT     school 4900022 2B Charter Lincoln Academy 490002201082 100 Lincoln Academy   Regular School Yes Other KG 09 2021   grade_4                                                   81                                             81
1356333 1356333 UT     school 4900182 9J Charter Lumen Scholar Institute 490018201467 300 Lumen Scholar Institute   Regular School Yes Other KG 12 2021   grade_4                                                   40                                             40
1356334 1356334 UT     school 4900165 4I Charter Mana Academy Charter School 490016501439 700 Mana Academy Charter School   Regular School Yes Other KG 12 2021   grade_4                                                   37                                             37
1356335 1356335 UT     school 4900144 4G Charter Maria Montessori Academy 490014401374 100 Maria Montessori Academy   Regular School Yes Other KG 09 2021   grade_4                                                   49                                             49
1356336 1356336 UT     school 4900131 8E Charter Merit College Preparatory Academy 490013101220 700 Merit College Preparatory Academy   Regular School Yes High 07 12 2021   grade_4                                                   0                                             0
1356337 1356337 UT     school 4900035 A7 Charter Moab Charter School 490003501085 100 Moab Charter School   Regular School Yes Elementary KG 06 2021   grade_4                                                   12                                             12
1356338 1356338 UT     school 4900049 7C Charter Monticello Academy 490004901150 100 Monticello Academy   Regular School Yes Elementary KG 08 2021   grade_4                                                   78                                             78
1356339 1356339 UT     school 4900049 7C Charter Monticello Academy 490004901556 105 Monticello Academy West Point   Regular School Yes Elementary KG 06 2021   grade_4                                                   20                                             20
1356340 1356340 UT     school 4900138 9F Charter Mountain Heights Academy 490013801285 600 Mountain Heights Academy   Regular School Yes High 07 12 2021   grade_4                                                   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]);