03-05-2020

10 rows where "Last Update" is on date 2020-03-02 sorted by Longitude

View and edit SQL

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

Last Update (date)

  • 2020-03-02 · 10
Link rowid Province/State Country/Region Last Update Confirmed Deaths Recovered Latitude Longitude ▼
164 Sonoma County, CA US 2020-03-02T20:53:02 1 0 0 38.578 -122.9888
166 Umatilla, OR US 2020-03-02T20:23:16 1 0 0 45.775 -118.7606
163 Sarasota, FL US 2020-03-02T03:23:06 1 0 0 27.3364 -82.5307
119 Providence, RI US 2020-03-02T03:43:02 2 0 0 41.824 -71.4128
133   Dominican Republic 2020-03-02T16:33:02 1 0 0 18.7357 -70.1627
126   Andorra 2020-03-02T20:23:16 1 0 0 42.5063 1.5218
29 Guizhou Mainland China 2020-03-02T01:13:06 146 2 114 26.8154 106.8748
110   Indonesia 2020-03-02T18:03:04 2 0 0 -0.7893 113.9213
51 Unassigned Location (From Diamond Princess) US 2020-03-02T19:53:03 45 0 0 35.4437 139.638
130 Tasmania Australia 2020-03-02T20:53:02 1 0 0 -41.4545 145.9707

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