johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
30 rows where "day" is on date 2020-03-29 and province_or_state = "Utah" sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: deaths, active
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2872567 | 2872567 | 2020-03-29 | US | Utah | Beaver | 49001 | 1 | 0 | 0 | 1 | 38.35657051 | -113.2342232 | 3/29/20 23:08 | Beaver, Utah, US |
2872657 | 2872657 | 2020-03-29 | US | Utah | Box Elder | 49003 | 5 | 0 | 0 | 5 | 41.52106798 | -113.0832816 | 3/29/20 23:08 | Box Elder, Utah, US |
2872742 | 2872742 | 2020-03-29 | US | Utah | Cache | 49005 | 5 | 0 | 0 | 5 | 41.72330587 | -111.7443667 | 3/29/20 23:08 | Cache, Utah, US |
2872792 | 2872792 | 2020-03-29 | US | Utah | Carbon | 49007 | 0 | 0 | 0 | 0 | 39.64834818 | -110.5872512 | 3/29/20 23:08 | Carbon, Utah, US |
2873109 | 2873109 | 2020-03-29 | US | Utah | Daggett | 49009 | 0 | 0 | 0 | 0 | 40.88798265 | -109.5121093 | 3/29/20 23:08 | Daggett, Utah, US |
2873133 | 2873133 | 2020-03-29 | US | Utah | Davis | 49011 | 69 | 1 | 0 | 68 | 40.99001837 | -112.1139997 | 3/29/20 23:08 | Davis, Utah, US |
2873229 | 2873229 | 2020-03-29 | US | Utah | Duchesne | 49013 | 0 | 0 | 0 | 0 | 40.29772254 | -110.425237 | 3/29/20 23:08 | Duchesne, Utah, US |
2873281 | 2873281 | 2020-03-29 | US | Utah | Emery | 49015 | 0 | 0 | 0 | 0 | 38.99617072 | -110.7013958 | 3/29/20 23:08 | Emery, Utah, US |
2873422 | 2873422 | 2020-03-29 | US | Utah | Garfield | 49017 | 1 | 0 | 0 | 1 | 37.85447192 | -111.4418764 | 3/29/20 23:08 | Garfield, Utah, US |
2873481 | 2873481 | 2020-03-29 | US | Utah | Grand | 49019 | 4 | 0 | 0 | 4 | 38.98103848 | -109.5704487 | 3/29/20 23:08 | Grand, Utah, US |
2873756 | 2873756 | 2020-03-29 | US | Utah | Iron | 49021 | 2 | 0 | 0 | 2 | 37.8590362 | -113.2897381 | 3/29/20 23:08 | Iron, Utah, US |
2873864 | 2873864 | 2020-03-29 | US | Utah | Juab | 49023 | 0 | 0 | 0 | 0 | 39.70208397 | -112.7809245 | 3/29/20 23:08 | Juab, Utah, US |
2873876 | 2873876 | 2020-03-29 | US | Utah | Kane | 49025 | 0 | 0 | 0 | 0 | 37.28507306 | -111.8861752 | 3/29/20 23:08 | Kane, Utah, US |
2874328 | 2874328 | 2020-03-29 | US | Utah | Millard | 49027 | 0 | 0 | 0 | 0 | 39.0729209 | -113.1020328 | 3/29/20 23:08 | Millard, Utah, US |
2874419 | 2874419 | 2020-03-29 | US | Utah | Morgan | 49029 | 0 | 0 | 0 | 0 | 41.08830262 | -111.5727723 | 3/29/20 23:08 | Morgan, Utah, US |
2874585 | 2874585 | 2020-03-29 | US | Utah | Out of UT | 14 | 0 | 0 | 14 | 0.0 | 0.0 | 3/29/20 23:08 | Out of UT,Utah,US | |
2874692 | 2874692 | 2020-03-29 | US | Utah | Piute | 49031 | 0 | 0 | 0 | 0 | 38.33815254 | -112.1249591 | 3/29/20 23:08 | Piute, Utah, US |
2874823 | 2874823 | 2020-03-29 | US | Utah | Rich | 49033 | 0 | 0 | 0 | 0 | 41.63137678 | -111.2445105 | 3/29/20 23:08 | Rich, Utah, US |
2874907 | 2874907 | 2020-03-29 | US | Utah | Salt Lake | 49035 | 321 | 0 | 0 | 321 | 40.66616532 | -111.9216011 | 3/29/20 23:08 | Salt Lake, Utah, US |
2874919 | 2874919 | 2020-03-29 | US | Utah | San Juan | 49037 | 4 | 0 | 0 | 4 | 37.62762978 | -109.8033714 | 3/29/20 23:08 | San Juan, Utah, US |
2874933 | 2874933 | 2020-03-29 | US | Utah | Sanpete | 49039 | 0 | 0 | 0 | 0 | 39.37231946 | -111.5758676 | 3/29/20 23:08 | Sanpete, Utah, US |
2874986 | 2874986 | 2020-03-29 | US | Utah | Sevier | 49041 | 0 | 0 | 0 | 0 | 38.74837146 | -111.8050275 | 3/29/20 23:08 | Sevier, Utah, US |
2875138 | 2875138 | 2020-03-29 | US | Utah | Summit | 49043 | 151 | 0 | 0 | 151 | 40.86688146 | -110.9535882 | 3/29/20 23:08 | Summit, Utah, US |
2875220 | 2875220 | 2020-03-29 | US | Utah | Tooele | 49045 | 9 | 0 | 0 | 9 | 40.44862644 | -113.1295715 | 3/29/20 23:08 | Tooele, Utah, US |
2875258 | 2875258 | 2020-03-29 | US | Utah | Uintah | 49047 | 0 | 0 | 0 | 0 | 40.12491499 | -109.5174415 | 3/29/20 23:08 | Uintah, Utah, US |
2875310 | 2875310 | 2020-03-29 | US | Utah | Utah | 49049 | 50 | 0 | 0 | 50 | 40.1166722 | -111.6657662 | 3/29/20 23:08 | Utah, Utah, US |
2875382 | 2875382 | 2020-03-29 | US | Utah | Wasatch | 49051 | 39 | 0 | 0 | 39 | 40.33110236 | -111.1691419 | 3/29/20 23:08 | Wasatch, Utah, US |
2875414 | 2875414 | 2020-03-29 | US | Utah | Washington | 49053 | 8 | 1 | 0 | 7 | 37.28003525 | -113.504698 | 3/29/20 23:08 | Washington, Utah, US |
2875440 | 2875440 | 2020-03-29 | US | Utah | Wayne | 49055 | 0 | 0 | 0 | 0 | 38.32335822 | -110.9096801 | 3/29/20 23:08 | Wayne, Utah, US |
2875445 | 2875445 | 2020-03-29 | US | Utah | Weber | 49057 | 37 | 0 | 0 | 37 | 41.27116049 | -111.9145117 | 3/29/20 23:08 | Weber,Utah,US |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE [johns_hopkins_csse_daily_reports] ( [day] TEXT, [country_or_region] TEXT, [province_or_state] TEXT, [admin2] TEXT, [fips] TEXT, [confirmed] INTEGER, [deaths] INTEGER, [recovered] INTEGER, [active] TEXT, [latitude] TEXT, [longitude] TEXT, [last_update] TEXT, [combined_key] TEXT ); CREATE INDEX [idx_johns_hopkins_csse_daily_reports_day] ON [johns_hopkins_csse_daily_reports] ([day]); CREATE INDEX [idx_johns_hopkins_csse_daily_reports_province_or_state] ON [johns_hopkins_csse_daily_reports] ([province_or_state]); CREATE INDEX [idx_johns_hopkins_csse_daily_reports_country_or_region] ON [johns_hopkins_csse_daily_reports] ([country_or_region]); CREATE INDEX [idx_johns_hopkins_csse_daily_reports_combined_key] ON [johns_hopkins_csse_daily_reports] ([combined_key]);