03-07-2020

16 rows where "Last Update" is on date 2020-03-05

View and edit SQL

Suggested facets: Country/Region, Last Update, Confirmed, Deaths, Recovered

Last Update (date)

  • 2020-03-05 · 16
Link rowid Province/State Country/Region Last Update Confirmed Deaths Recovered Latitude Longitude
32 Hainan Mainland China 2020-03-05T06:13:10 168 6 158 19.1959 109.7453
37 Tianjin Mainland China 2020-03-05T03:33:27 136 3 128 39.3054 117.323
38 Shanxi Mainland China 2020-03-05T14:53:03 133 0 126 37.5777 112.2922
77   Oman 2020-03-05T17:53:02 16 0 2 21.0 57.0
81 Queensland Australia 2020-03-05T17:33:06 13 0 8 -28.0167 153.4
83   Ecuador 2020-03-05T17:53:02 13 0 0 -1.8312 -78.1834
105   Saudi Arabia 2020-03-05T17:53:03 5 0 0 24.0 45.0
109   Chile 2020-03-05T18:13:04 4 0 0 -35.6751 -71.543
110   Georgia 2020-03-05T13:53:03 4 0 0 42.3154 43.3569
116 Western Australia Australia 2020-03-05T17:13:35 3 1 0 -31.9505 115.8605
130 San Diego County, CA US 2020-03-05T20:33:03 3 0 1 32.7157 -117.1611
136   Morocco 2020-03-05T13:53:03 2 0 0 31.7917 -7.0926
184 Clark County, NV US 2020-03-05T20:53:03 1 0 0 36.0796 -115.094
192 Grant County, WA US 2020-03-05T20:23:07 1 0 0 47.1981 -119.3732
208 Santa Rosa County, FL US 2020-03-05T20:03:03 1 0 0 30.769 -86.9824
216 Williamson County, TN US 2020-03-05T23:33:03 1 0 0 35.9179 -86.8622

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

CREATE TABLE "03-07-2020" (
"Province/State" TEXT,
  "Country/Region" TEXT,
  "Last Update" TEXT,
  "Confirmed" INTEGER,
  "Deaths" INTEGER,
  "Recovered" INTEGER,
  "Latitude" REAL,
  "Longitude" REAL
);
Powered by Datasette · Query took 19.6ms