03-08-2020

3 rows where "Last Update" is on date 2020-02-12

View and edit SQL

Last Update (date)

  • 2020-02-12 · 3
Link rowid Province/State Country/Region Last Update Confirmed Deaths Recovered Latitude Longitude
180 London, ON Canada 2020-02-12T18:53:03 1 0 1 42.9849 -81.2453
186 Tibet Mainland China 2020-02-12T06:43:02 1 0 1 31.6927 88.0924
189   Nepal 2020-02-12T14:43:03 1 0 1 28.1667 84.25

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

CREATE TABLE "03-08-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 21.954ms