03-08-2020

18 rows where Deaths = 1

View and edit SQL

Suggested facets: Country/Region, Last Update, Recovered, Last Update (date)

Deaths

Link rowid Province/State Country/Region Last Update Confirmed Deaths Recovered Latitude Longitude
7 Zhejiang Mainland China 2020-03-08T09:03:04 1215 1 1161 29.1832 120.0934
12 Jiangxi Mainland China 2020-03-08T06:53:04 935 1 919 27.614 115.7221
25 Fujian Mainland China 2020-03-07T13:03:05 296 1 295 26.0789 117.9874
29 Shaanxi Mainland China 2020-03-08T14:43:03 245 1 227 35.1917 108.8701
39 Liaoning Mainland China 2020-03-08T05:13:06 125 1 109 41.2956 122.6085
44 Jilin Mainland China 2020-03-06T10:23:03 93 1 90 43.6661 126.1923
49 Inner Mongolia Mainland China 2020-03-08T05:13:06 75 1 70 44.0935 113.9448
55   Thailand 2020-03-07T10:13:23 50 1 31 15.0 101.0
56   Egypt 2020-03-08T19:03:11 49 1 1 26.0 30.0
57 Taiwan Taiwan 2020-03-08T03:13:13 45 1 13 23.7 121.0
64   San Marino 2020-03-08T14:23:10 36 1 0 43.9424 12.4578
68 Snohomish County, WA US 2020-03-08T21:43:03 31 1 0 48.033 -121.8339
90   Argentina 2020-03-08T22:03:11 12 1 0 -38.4161 -63.6167
99   Philippines 2020-03-08T17:13:06 10 1 1 13.0 122.0
122 Placer County, CA US 2020-03-06T23:13:07 5 1 0 39.0916 -120.8039
134 Western Australia Australia 2020-03-05T17:13:35 3 1 0 -31.9505 115.8605
165 Lee County, FL US 2020-03-08T15:33:04 2 1 0 26.663 -81.9535
231 Santa Rosa County, FL US 2020-03-08T15:33:04 1 1 0 30.769 -86.9824

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