03-05-2020

17 rows where Deaths = 1

View and edit SQL

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

Deaths

Link rowid Province/State Country/Region Last Update Confirmed Deaths Recovered Latitude Longitude
7 Zhejiang Mainland China 2020-03-05T09:43:03 1215 1 1124 29.1832 120.0934
10 Jiangxi Mainland China 2020-03-05T01:16:58 935 1 901 27.614 115.7221
23 Fujian Mainland China 2020-03-05T09:33:03 296 1 277 26.0789 117.9874
26 Shaanxi Mainland China 2020-03-05T06:03:08 245 1 224 35.1917 108.8701
32 Liaoning Mainland China 2020-03-03T14:33:03 125 1 106 41.2956 122.6085
34   UK 2020-03-05T18:03:03 115 1 8 55.0 -3.0
35   Switzerland 2020-03-05T17:43:03 114 1 3 46.8182 8.2275
39 Jilin Mainland China 2020-03-05T14:53:03 93 1 88 43.6661 126.1923
43 Inner Mongolia Mainland China 2020-03-05T23:53:01 75 1 65 44.0935 113.9448
50   Thailand 2020-03-05T06:23:06 47 1 31 15.0 101.0
52 Taiwan Taiwan 2020-03-05T14:53:03 44 1 12 23.7 121.0
59 New South Wales Australia 2020-03-04T20:43:03 22 1 4 -33.8688 151.2093
61   San Marino 2020-03-05T13:53:03 21 1 0 43.9424 12.4578
64 Snohomish County, WA US 2020-03-05T20:23:07 18 1 0 48.033 -121.8339
99 Western Australia Australia 2020-03-05T17:13:35 3 1 0 -31.9505 115.8605
103   Philippines 2020-02-12T07:43:02 3 1 1 13.0 122.0
118 Placer County, CA US 2020-03-04T19:53:02 2 1 0 39.0916 -120.8039

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