daily_reports (view)
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
14,434 rows where province_or_state = "Utah" sorted by day
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: admin2, day (date), last_update (date)
day ▼ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|
2020-03-10 | US | Utah | 2 | 0 | 0 | 40.15 | -111.8624 | 2020-03-10T16:53:13 | ||||
2020-03-11 | US | Utah | 3 | 0 | 0 | 40.15 | -111.8624 | 2020-03-11T23:13:06 | ||||
2020-03-12 | US | Utah | 5 | 0 | 0 | 40.15 | -111.8624 | 2020-03-12T23:44:33 | ||||
2020-03-13 | US | Utah | 9 | 0 | 0 | 40.150032 | -111.862434 | 2020-03-11T20:00:00 | ||||
2020-03-14 | US | Utah | 10 | 0 | 0 | 40.15 | -111.8624 | 2020-03-14T18:53:03 | ||||
2020-03-15 | US | Utah | 28 | 0 | 0 | 40.15 | -111.8624 | 2020-03-15T18:20:19 | ||||
2020-03-16 | US | Utah | 39 | 0 | 0 | 40.15 | -111.8624 | 2020-03-16T22:33:03 | ||||
2020-03-17 | US | Utah | 51 | 0 | 0 | 40.15 | -111.8624 | 2020-03-17T20:53:02 | ||||
2020-03-18 | US | Utah | 51 | 0 | 0 | 40.15 | -111.8624 | 2020-03-17T20:53:02 | ||||
2020-03-19 | US | Utah | 80 | 0 | 0 | 40.15 | -111.8624 | 2020-03-19T23:43:04 | ||||
2020-03-20 | US | Utah | 78 | 0 | 0 | 40.15 | -111.8624 | 2020-03-20T16:13:23 | ||||
2020-03-21 | US | Utah | 136 | 0 | 0 | 40.15 | -111.8624 | 2020-03-21T23:13:17 | ||||
2020-03-22 | US | Utah | Salt Lake | 49035 | 80 | 0 | 0 | 80 | 40.66616532 | -111.9216011 | 3/22/20 23:45 | Salt Lake, Utah, US |
2020-03-22 | US | Utah | Summit | 49043 | 43 | 0 | 0 | 43 | 40.86688146 | -110.9535882 | 3/22/20 23:45 | Summit, Utah, US |
2020-03-22 | US | Utah | Davis | 49011 | 19 | 1 | 0 | 18 | 40.99001837 | -112.1139997 | 3/22/20 23:45 | Davis, Utah, US |
2020-03-22 | US | Utah | Wasatch | 49051 | 8 | 0 | 0 | 8 | 40.33110236 | -111.1691419 | 3/22/20 23:45 | Wasatch, Utah, US |
2020-03-22 | US | Utah | Utah | 49049 | 6 | 0 | 0 | 6 | 40.1166722 | -111.6657662 | 3/22/20 23:45 | Utah, Utah, US |
2020-03-22 | US | Utah | Tooele | 49045 | 3 | 0 | 0 | 3 | 40.44862644 | -113.1295715 | 3/22/20 23:45 | Tooele, Utah, US |
2020-03-22 | US | Utah | Cache | 49005 | 2 | 0 | 0 | 2 | 41.72330587 | -111.7443667 | 3/22/20 23:45 | Cache, Utah, US |
2020-03-22 | US | Utah | Box Elder | 49003 | 1 | 0 | 0 | 1 | 41.52106798 | -113.0832816 | 3/22/20 23:45 | Box Elder, Utah, US |
2020-03-22 | US | Utah | Beaver | 49001 | 0 | 0 | 0 | 0 | 38.35657051 | -113.2342232 | 3/22/20 23:45 | Beaver, Utah, US |
2020-03-22 | US | Utah | Carbon | 49007 | 0 | 0 | 0 | 0 | 39.64834818 | -110.5872512 | 3/22/20 23:45 | Carbon, Utah, US |
2020-03-22 | US | Utah | Daggett | 49009 | 0 | 0 | 0 | 0 | 40.88798265 | -109.5121093 | 3/22/20 23:45 | Daggett, Utah, US |
2020-03-22 | US | Utah | Duchesne | 49013 | 0 | 0 | 0 | 0 | 40.29772254 | -110.425237 | 3/22/20 23:45 | Duchesne, Utah, US |
2020-03-22 | US | Utah | Emery | 49015 | 0 | 0 | 0 | 0 | 38.99617072 | -110.7013958 | 3/22/20 23:45 | Emery, Utah, US |
2020-03-22 | US | Utah | Garfield | 49017 | 0 | 0 | 0 | 0 | 37.85447192 | -111.4418764 | 3/22/20 23:45 | Garfield, Utah, US |
2020-03-22 | US | Utah | Grand | 49019 | 0 | 0 | 0 | 0 | 38.98103848 | -109.5704487 | 3/22/20 23:45 | Grand, Utah, US |
2020-03-22 | US | Utah | Iron | 49021 | 0 | 0 | 0 | 0 | 37.8590362 | -113.2897381 | 3/22/20 23:45 | Iron, Utah, US |
2020-03-22 | US | Utah | Juab | 49023 | 0 | 0 | 0 | 0 | 39.70208397 | -112.7809245 | 3/22/20 23:45 | Juab, Utah, US |
2020-03-22 | US | Utah | Kane | 49025 | 0 | 0 | 0 | 0 | 37.28507306 | -111.8861752 | 3/22/20 23:45 | Kane, Utah, US |
2020-03-22 | US | Utah | Millard | 49027 | 0 | 0 | 0 | 0 | 39.0729209 | -113.1020328 | 3/22/20 23:45 | Millard, Utah, US |
2020-03-22 | US | Utah | Morgan | 49029 | 0 | 0 | 0 | 0 | 41.08830262 | -111.5727723 | 3/22/20 23:45 | Morgan, Utah, US |
2020-03-22 | US | Utah | Piute | 49031 | 0 | 0 | 0 | 0 | 38.33815254 | -112.1249591 | 3/22/20 23:45 | Piute, Utah, US |
2020-03-22 | US | Utah | Rich | 49033 | 0 | 0 | 0 | 0 | 41.63137678 | -111.2445105 | 3/22/20 23:45 | Rich, Utah, US |
2020-03-22 | US | Utah | San Juan | 49037 | 0 | 0 | 0 | 0 | 37.62762978 | -109.8033714 | 3/22/20 23:45 | San Juan, Utah, US |
2020-03-22 | US | Utah | Sanpete | 49039 | 0 | 0 | 0 | 0 | 39.37231946 | -111.5758676 | 3/22/20 23:45 | Sanpete, Utah, US |
2020-03-22 | US | Utah | Sevier | 49041 | 0 | 0 | 0 | 0 | 38.74837146 | -111.8050275 | 3/22/20 23:45 | Sevier, Utah, US |
2020-03-22 | US | Utah | Uintah | 49047 | 0 | 0 | 0 | 0 | 40.12491499 | -109.5174415 | 3/22/20 23:45 | Uintah, Utah, US |
2020-03-22 | US | Utah | Washington | 49053 | 0 | 0 | 0 | 0 | 37.28003525 | -113.504698 | 3/22/20 23:45 | Washington, Utah, US |
2020-03-22 | US | Utah | Wayne | 49055 | 0 | 0 | 0 | 0 | 38.32335822 | -110.9096801 | 3/22/20 23:45 | Wayne, Utah, US |
2020-03-22 | US | Utah | Weber | 49057 | 0 | 0 | 0 | 0 | 41.27116049 | -111.9145117 | 3/22/20 23:45 | Weber, Utah, US |
2020-03-23 | US | Utah | Beaver | 49001 | 0 | 0 | 0 | 0 | 38.35657051 | -113.2342232 | 2020-03-23 23:19:34 | Beaver, Utah, US |
2020-03-23 | US | Utah | Box Elder | 49003 | 1 | 0 | 0 | 1 | 41.52106798 | -113.08328159999999 | 2020-03-23 23:19:34 | Box Elder, Utah, US |
2020-03-23 | US | Utah | Cache | 49005 | 3 | 0 | 0 | 3 | 41.72330587 | -111.74436670000001 | 2020-03-23 23:19:34 | Cache, Utah, US |
2020-03-23 | US | Utah | Carbon | 49007 | 0 | 0 | 0 | 0 | 39.64834818 | -110.58725120000001 | 2020-03-23 23:19:34 | Carbon, Utah, US |
2020-03-23 | US | Utah | Daggett | 49009 | 0 | 0 | 0 | 0 | 40.88798265 | -109.51210929999999 | 2020-03-23 23:19:34 | Daggett, Utah, US |
2020-03-23 | US | Utah | Davis | 49011 | 29 | 1 | 0 | 28 | 40.99001837 | -112.1139997 | 2020-03-23 23:19:34 | Davis, Utah, US |
2020-03-23 | US | Utah | Duchesne | 49013 | 0 | 0 | 0 | 0 | 40.29772254 | -110.42523700000001 | 2020-03-23 23:19:34 | Duchesne, Utah, US |
2020-03-23 | US | Utah | Emery | 49015 | 0 | 0 | 0 | 0 | 38.99617072 | -110.70139579999999 | 2020-03-23 23:19:34 | Emery, Utah, US |
2020-03-23 | US | Utah | Garfield | 49017 | 0 | 0 | 0 | 0 | 37.85447192 | -111.4418764 | 2020-03-23 23:19:34 | Garfield, Utah, US |
2020-03-23 | US | Utah | Grand | 49019 | 0 | 0 | 0 | 0 | 38.98103848 | -109.5704487 | 2020-03-23 23:19:34 | Grand, Utah, US |
2020-03-23 | US | Utah | Iron | 49021 | 0 | 0 | 0 | 0 | 37.85903620000001 | -113.28973810000001 | 2020-03-23 23:19:34 | Iron, Utah, US |
2020-03-23 | US | Utah | Juab | 49023 | 0 | 0 | 0 | 0 | 39.70208397 | -112.78092450000001 | 2020-03-23 23:19:34 | Juab, Utah, US |
2020-03-23 | US | Utah | Kane | 49025 | 0 | 0 | 0 | 0 | 37.28507306 | -111.88617520000001 | 2020-03-23 23:19:34 | Kane, Utah, US |
2020-03-23 | US | Utah | Millard | 49027 | 0 | 0 | 0 | 0 | 39.0729209 | -113.1020328 | 2020-03-23 23:19:34 | Millard, Utah, US |
2020-03-23 | US | Utah | Morgan | 49029 | 0 | 0 | 0 | 0 | 41.08830262 | -111.5727723 | 2020-03-23 23:19:34 | Morgan, Utah, US |
2020-03-23 | US | Utah | Out of UT | 13 | 0 | 0 | 13 | 0.0 | 0.0 | 2020-03-23 23:19:34 | Out of UT,Utah,US | |
2020-03-23 | US | Utah | Piute | 49031 | 0 | 0 | 0 | 0 | 38.33815254 | -112.1249591 | 2020-03-23 23:19:34 | Piute, Utah, US |
2020-03-23 | US | Utah | Rich | 49033 | 0 | 0 | 0 | 0 | 41.63137678 | -111.2445105 | 2020-03-23 23:19:34 | Rich, Utah, US |
2020-03-23 | US | Utah | Salt Lake | 49035 | 109 | 0 | 0 | 109 | 40.66616532 | -111.92160109999999 | 2020-03-23 23:19:34 | Salt Lake, Utah, US |
2020-03-23 | US | Utah | San Juan | 49037 | 0 | 0 | 0 | 0 | 37.62762978 | -109.80337140000002 | 2020-03-23 23:19:34 | San Juan, Utah, US |
2020-03-23 | US | Utah | Sanpete | 49039 | 0 | 0 | 0 | 0 | 39.37231946 | -111.5758676 | 2020-03-23 23:19:34 | Sanpete, Utah, US |
2020-03-23 | US | Utah | Sevier | 49041 | 0 | 0 | 0 | 0 | 38.74837146 | -111.8050275 | 2020-03-23 23:19:34 | Sevier, Utah, US |
2020-03-23 | US | Utah | Summit | 49043 | 65 | 0 | 0 | 65 | 40.86688146 | -110.9535882 | 2020-03-23 23:19:34 | Summit, Utah, US |
2020-03-23 | US | Utah | Tooele | 49045 | 2 | 0 | 0 | 2 | 40.44862644 | -113.12957150000001 | 2020-03-23 23:19:34 | Tooele, Utah, US |
2020-03-23 | US | Utah | Uintah | 49047 | 0 | 0 | 0 | 0 | 40.12491499 | -109.5174415 | 2020-03-23 23:19:34 | Uintah, Utah, US |
2020-03-23 | US | Utah | Utah | 49049 | 11 | 0 | 0 | 11 | 40.116672200000004 | -111.66576620000001 | 2020-03-23 23:19:34 | Utah, Utah, US |
2020-03-23 | US | Utah | Wasatch | 49051 | 11 | 0 | 0 | 11 | 40.33110236 | -111.1691419 | 2020-03-23 23:19:34 | Wasatch, Utah, US |
2020-03-23 | US | Utah | Washington | 49053 | 5 | 0 | 0 | 5 | 37.28003525 | -113.504698 | 2020-03-23 23:19:34 | Washington,Utah,US |
2020-03-23 | US | Utah | Wayne | 49055 | 0 | 0 | 0 | 0 | 38.32335822 | -110.9096801 | 2020-03-23 23:19:34 | Wayne, Utah, US |
2020-03-23 | US | Utah | Weber | 49057 | 8 | 0 | 0 | 8 | 41.27116049 | -111.9145117 | 2020-03-23 23:19:34 | Weber,Utah,US |
2020-03-24 | US | Utah | Beaver | 49001 | 0 | 0 | 0 | 0 | 38.35657051 | -113.2342232 | 2020-03-24 23:37:31 | Beaver, Utah, US |
2020-03-24 | US | Utah | Box Elder | 49003 | 1 | 0 | 0 | 1 | 41.52106798 | -113.08328159999999 | 2020-03-24 23:37:31 | Box Elder, Utah, US |
2020-03-24 | US | Utah | Cache | 49005 | 3 | 0 | 0 | 3 | 41.72330587 | -111.74436670000001 | 2020-03-24 23:37:31 | Cache, Utah, US |
2020-03-24 | US | Utah | Carbon | 49007 | 0 | 0 | 0 | 0 | 39.64834818 | -110.58725120000001 | 2020-03-24 23:37:31 | Carbon, Utah, US |
2020-03-24 | US | Utah | Daggett | 49009 | 0 | 0 | 0 | 0 | 40.88798265 | -109.51210929999999 | 2020-03-24 23:37:31 | Daggett, Utah, US |
2020-03-24 | US | Utah | Davis | 49011 | 31 | 1 | 0 | 30 | 40.99001837 | -112.1139997 | 2020-03-24 23:37:31 | Davis, Utah, US |
2020-03-24 | US | Utah | Duchesne | 49013 | 0 | 0 | 0 | 0 | 40.29772254 | -110.42523700000001 | 2020-03-24 23:37:31 | Duchesne, Utah, US |
2020-03-24 | US | Utah | Emery | 49015 | 0 | 0 | 0 | 0 | 38.99617072 | -110.70139579999999 | 2020-03-24 23:37:31 | Emery, Utah, US |
2020-03-24 | US | Utah | Garfield | 49017 | 0 | 0 | 0 | 0 | 37.85447192 | -111.4418764 | 2020-03-24 23:37:31 | Garfield, Utah, US |
2020-03-24 | US | Utah | Grand | 49019 | 0 | 0 | 0 | 0 | 38.98103848 | -109.5704487 | 2020-03-24 23:37:31 | Grand, Utah, US |
2020-03-24 | US | Utah | Iron | 49021 | 0 | 0 | 0 | 0 | 37.85903620000001 | -113.28973810000001 | 2020-03-24 23:37:31 | Iron, Utah, US |
2020-03-24 | US | Utah | Juab | 49023 | 0 | 0 | 0 | 0 | 39.70208397 | -112.78092450000001 | 2020-03-24 23:37:31 | Juab, Utah, US |
2020-03-24 | US | Utah | Kane | 49025 | 0 | 0 | 0 | 0 | 37.28507306 | -111.88617520000001 | 2020-03-24 23:37:31 | Kane, Utah, US |
2020-03-24 | US | Utah | Millard | 49027 | 0 | 0 | 0 | 0 | 39.0729209 | -113.1020328 | 2020-03-24 23:37:31 | Millard, Utah, US |
2020-03-24 | US | Utah | Morgan | 49029 | 0 | 0 | 0 | 0 | 41.08830262 | -111.5727723 | 2020-03-24 23:37:31 | Morgan, Utah, US |
2020-03-24 | US | Utah | Out of UT | 13 | 0 | 0 | 13 | 0.0 | 0.0 | 2020-03-24 23:37:31 | Out of UT,Utah,US | |
2020-03-24 | US | Utah | Piute | 49031 | 0 | 0 | 0 | 0 | 38.33815254 | -112.1249591 | 2020-03-24 23:37:31 | Piute, Utah, US |
2020-03-24 | US | Utah | Rich | 49033 | 0 | 0 | 0 | 0 | 41.63137678 | -111.2445105 | 2020-03-24 23:37:31 | Rich, Utah, US |
2020-03-24 | US | Utah | Salt Lake | 49035 | 124 | 0 | 0 | 124 | 40.66616532 | -111.92160109999999 | 2020-03-24 23:37:31 | Salt Lake, Utah, US |
2020-03-24 | US | Utah | San Juan | 49037 | 0 | 0 | 0 | 0 | 37.62762978 | -109.80337140000002 | 2020-03-24 23:37:31 | San Juan, Utah, US |
2020-03-24 | US | Utah | Sanpete | 49039 | 0 | 0 | 0 | 0 | 39.37231946 | -111.5758676 | 2020-03-24 23:37:31 | Sanpete, Utah, US |
2020-03-24 | US | Utah | Sevier | 49041 | 0 | 0 | 0 | 0 | 38.74837146 | -111.8050275 | 2020-03-24 23:37:31 | Sevier, Utah, US |
2020-03-24 | US | Utah | Summit | 49043 | 82 | 0 | 0 | 82 | 40.86688146 | -110.9535882 | 2020-03-24 23:37:31 | Summit, Utah, US |
2020-03-24 | US | Utah | Tooele | 49045 | 2 | 0 | 0 | 2 | 40.44862644 | -113.12957150000001 | 2020-03-24 23:37:31 | Tooele, Utah, US |
2020-03-24 | US | Utah | Uintah | 49047 | 0 | 0 | 0 | 0 | 40.12491499 | -109.5174415 | 2020-03-24 23:37:31 | Uintah, Utah, US |
2020-03-24 | US | Utah | Utah | 49049 | 13 | 0 | 0 | 13 | 40.116672200000004 | -111.66576620000001 | 2020-03-24 23:37:31 | Utah, Utah, US |
2020-03-24 | US | Utah | Wasatch | 49051 | 15 | 0 | 0 | 15 | 40.33110236 | -111.1691419 | 2020-03-24 23:37:31 | Wasatch, Utah, US |
2020-03-24 | US | Utah | Washington | 49053 | 5 | 0 | 0 | 5 | 37.28003525 | -113.504698 | 2020-03-24 23:37:31 | Washington,Utah,US |
2020-03-24 | US | Utah | Wayne | 49055 | 0 | 0 | 0 | 0 | 38.32335822 | -110.9096801 | 2020-03-24 23:37:31 | Wayne, Utah, US |
Advanced export
JSON shape: default, array, newline-delimited
CREATE VIEW daily_reports AS select * from johns_hopkins_csse_daily_reports;