03-07-2020

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

View and edit SQL

Suggested facets: Last Update, Confirmed, Deaths, Recovered

Last Update (date)

  • 2020-03-06 · 53
Link rowid Province/State Country/Region Last Update Confirmed Deaths Recovered Latitude Longitude
9 Anhui Mainland China 2020-03-06T03:23:06 990 6 979 31.8257 117.2264
14 Diamond Princess cruise ship Others 2020-03-06T01:29:39 696 6 40 35.4437 139.638
27 Shaanxi Mainland China 2020-03-06T10:23:03 245 1 226 35.1917 108.8701
30 Yunnan Mainland China 2020-03-06T03:23:06 174 2 170 24.974 101.487
42 Jilin Mainland China 2020-03-06T10:23:03 93 1 90 43.6661 126.1923
48 Ningxia Mainland China 2020-03-06T12:53:03 75 0 71 37.2692 106.1655
56 Taiwan Taiwan 2020-03-06T12:43:03 45 1 12 23.7 121.0
64   Denmark 2020-03-06T13:03:12 23 0 1 56.2639 9.5018
66   Lebanon 2020-03-06T20:33:03 22 0 1 33.8547 35.8623
69   Israel 2020-03-06T20:33:03 21 0 2 31.0 35.0
73   Ireland 2020-03-06T20:43:03 18 0 0 53.1424 -7.6921
76   Algeria 2020-03-06T01:29:39 17 0 0 28.0339 1.6596
78   Egypt 2020-03-06T13:03:13 15 0 1 26.0 30.0
79   Finland 2020-03-06T13:03:12 15 0 1 64.0 26.0
82   Brazil 2020-03-06T20:33:03 13 0 0 -14.235 -51.9253
84   Russia 2020-03-06T20:43:03 13 0 2 60.0 90.0
88   Estonia 2020-03-06T13:03:13 10 0 0 58.5953 25.0136
89 Macau Macau 2020-03-06T10:23:03 10 0 10 22.1667 113.55
95 South Australia Australia 2020-03-06T04:23:08 7 0 2 -34.9285 138.6007
96   Slovenia 2020-03-06T15:33:03 7 0 0 46.1512 14.9955
98   Mexico 2020-03-06T16:43:04 6 0 1 23.0 -102.0
99   Pakistan 2020-03-06T13:03:12 6 0 0 30.3753 69.3451
104   Poland 2020-03-06T16:43:04 5 0 0 51.9194 19.1451
107 Placer County, CA US 2020-03-06T23:13:07 5 1 0 39.0916 -120.8039
108 Unassigned Location, WA US 2020-03-06T00:33:03 5 0 0 47.7511 -120.7401
112   Indonesia 2020-03-06T12:33:03 4 0 0 -0.7893 113.9213
120   North Macedonia 2020-03-06T20:23:11 3 0 0 41.6086 21.7453
122 Contra Costa County, CA US 2020-03-06T19:43:02 3 0 0 37.8534 -121.9018
127 Montgomery County, MD US 2020-03-06T04:03:17 3 0 0 39.1547 -77.2405
131 Suffolk County, MA US 2020-03-06T18:33:03 3 0 1 42.3601 -71.0589
133   Dominican Republic 2020-03-06T15:33:03 2 0 0 18.7357 -70.1627
134   Luxembourg 2020-03-06T01:29:39 2 0 0 49.8144 6.1317
137 Norfolk County, MA US 2020-03-06T18:33:03 2 0 0 42.1767 -71.1449
140 Denver County, CO US 2020-03-06T23:33:02 2 0 0 39.7392 -104.9903
152 Summit County, CO US 2020-03-06T01:29:39 2 0 0 39.5912 -106.064
157   Bhutan 2020-03-06T15:43:02 1 0 0 27.5142 90.4336
159   Cameroon 2020-03-06T15:43:02 1 0 0 3.848 11.5021
160 Calgary, Alberta Canada 2020-03-06T13:13:34 1 0 0 51.0447 -114.0719
175   Peru 2020-03-06T15:43:02 1 0 0 -9.19 -75.0152
176   Serbia 2020-03-06T15:43:02 1 0 0 44.0165 21.0059
177   Slovakia 2020-03-06T13:03:14 1 0 0 48.669 19.699
178   South Africa 2020-03-06T15:43:02 1 0 0 -30.5595 22.9375
183 Chatham County, NC US 2020-03-06T16:13:15 1 0 0 35.7211 -79.1781
188 Delaware County, PA US 2020-03-06T15:33:03 1 0 0 39.9078 -75.3879
189 Douglas County, NE US 2020-03-06T23:33:02 1 0 0 41.3148 -96.1951
191 Fayette County, KY US 2020-03-06T23:23:03 1 0 0 38.0606 -84.4803
201 Marion County, IN US 2020-03-06T17:13:12 1 0 0 39.8362 -86.1752
205 Ramsey County, MN US 2020-03-06T23:23:03 1 0 0 44.9964 -93.0616
214 Washoe County, NV US 2020-03-06T19:43:02 1 0 0 40.5608 -119.6035
215 Wayne County, PA US 2020-03-06T16:13:15 1 0 0 41.6739 -75.2479
217 Yolo County, CA US 2020-03-06T20:13:14 1 0 0 38.7646 -121.9018
219   Vatican City 2020-03-06T15:43:02 1 0 0 41.9029 12.4534
221 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-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 18.572ms