03-07-2020

4 rows where "Last Update" is on date 2020-02-24

View and edit SQL

Suggested facets: Country/Region, Confirmed

Last Update (date)

  • 2020-02-24 · 4
Link rowid Province/State Country/Region Last Update Confirmed Deaths Recovered Latitude Longitude
153   Afghanistan 2020-02-24T23:33:02 1 0 0 33.0 65.0
222 Lackland, TX (From Diamond Princess) US 2020-02-24T23:33:02 0 0 0 29.3829 -98.6134
224 Omaha, NE (From Diamond Princess) US 2020-02-24T23:33:02 0 0 0 41.2545 -95.9758
225 Travis, CA (From Diamond Princess) US 2020-02-24T23:33:02 0 0 0 38.2721 -121.9399

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