03-07-2020

6 rows where "Last Update" is on date 2020-03-02

View and edit SQL

Suggested facets: Country/Region, Last Update, Confirmed

Last Update (date)

  • 2020-03-02 · 6
Link rowid Province/State Country/Region Last Update Confirmed Deaths Recovered Latitude Longitude
57 Unassigned Location (From Diamond Princess) US 2020-03-02T19:53:03 45 0 0 35.4437 139.638
154   Andorra 2020-03-02T20:23:16 1 0 0 42.5063 1.5218
156 Tasmania Australia 2020-03-02T20:53:02 1 0 0 -41.4545 145.9707
209 Sarasota, FL US 2020-03-02T03:23:06 1 0 0 27.3364 -82.5307
210 Sonoma County, CA US 2020-03-02T20:53:02 1 0 0 38.578 -122.9888
212 Umatilla, OR US 2020-03-02T20:23:16 1 0 0 45.775 -118.7606

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 22.719ms