03-08-2020

25 rows where "Last Update" is on date 2020-03-06

View and edit SQL

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

Last Update (date)

  • 2020-03-06 · 25
Link rowid Province/State Country/Region Last Update Confirmed Deaths Recovered Latitude Longitude
14 Diamond Princess cruise ship Others 2020-03-06T01:29:39 696 6 40 35.4437 139.638
33 Yunnan Mainland China 2020-03-06T03:23:06 174 2 170 24.974 101.487
44 Jilin Mainland China 2020-03-06T10:23:03 93 1 90 43.6661 126.1923
50 Ningxia Mainland China 2020-03-06T12:53:03 75 0 71 37.2692 106.1655
97   Estonia 2020-03-06T13:03:13 10 0 0 58.5953 25.0136
98 Macau Macau 2020-03-06T10:23:03 10 0 10 22.1667 113.55
105 South Australia Australia 2020-03-06T04:23:08 7 0 2 -34.9285 138.6007
122 Placer County, CA US 2020-03-06T23:13:07 5 1 0 39.0916 -120.8039
123 Unassigned Location, WA US 2020-03-06T00:33:03 5 0 0 47.7511 -120.7401
140   North Macedonia 2020-03-06T20:23:11 3 0 0 41.6086 21.7453
161 Denver County, CO US 2020-03-06T23:33:02 2 0 0 39.7392 -104.9903
173 Summit County, CO US 2020-03-06T01:29:39 2 0 0 39.5912 -106.064
178   Bhutan 2020-03-06T15:43:02 1 0 0 27.5142 90.4336
179 Calgary, Alberta Canada 2020-03-06T13:13:34 1 0 0 51.0447 -114.0719
192   Serbia 2020-03-06T15:43:02 1 0 0 44.0165 21.0059
197 Chatham County, NC US 2020-03-06T16:13:15 1 0 0 35.7211 -79.1781
202 Delaware County, PA US 2020-03-06T15:33:03 1 0 0 39.9078 -75.3879
203 Douglas County, NE US 2020-03-06T23:33:02 1 0 0 41.3148 -96.1951
207 Fayette County, KY US 2020-03-06T23:23:03 1 0 0 38.0606 -84.4803
223 Marion County, IN US 2020-03-06T17:13:12 1 0 0 39.8362 -86.1752
228 Ramsey County, MN US 2020-03-06T23:23:03 1 0 0 44.9964 -93.0616
245 Wayne County, PA US 2020-03-06T16:13:15 1 0 0 41.6739 -75.2479
247 Yolo County, CA US 2020-03-06T20:13:14 1 0 0 38.7646 -121.9018
249   Vatican City 2020-03-06T15:43:02 1 0 0 41.9029 12.4534
251 Northern Territory Australia 2020-03-06T04:33:03 0 0 0 -12.4634 130.8456

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