03-05-2020

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

View and edit SQL

Last Update (date)

  • 2020-02-12 · 5
Link rowid Province/State Country/Region Last Update Confirmed Deaths Recovered Latitude Longitude
103   Philippines 2020-02-12T07:43:02 3 1 1 13.0 122.0
131   Cambodia 2020-02-12T07:43:02 1 0 1 11.55 104.9167
132 London, ON Canada 2020-02-12T18:53:03 1 0 1 42.9849 -81.2453
141 Tibet Mainland China 2020-02-12T06:43:02 1 0 1 31.6927 88.0924
143   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-05-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 6.403ms