03-01-2020

125 rows

View and edit SQL

Link rowid Province/State Country/Region Last Update Confirmed Deaths Recovered Latitude Longitude
101   Estonia 2020-02-27T16:23:03 1 0 0 58.5953 25.0136
102   Ireland 2020-03-01T07:13:07 1 0 0 53.1424 -7.6921
103   Lithuania 2020-02-28T16:23:03 1 0 0 55.1694 23.8813
104   Luxembourg 2020-03-01T07:13:07 1 0 0 49.8153 6.1296
105 Tibet Mainland China 2020-02-12T06:43:02 1 0 1 31.6927 88.0924
106   Monaco 2020-02-29T00:33:01 1 0 0 43.7333 7.4167
107   Nepal 2020-02-12T14:43:03 1 0 1 28.1667 84.25
108   New Zealand 2020-02-28T16:23:03 1 0 0 -40.9006 174.886
109   Nigeria 2020-02-28T16:23:03 1 0 0 9.082 8.6753
110   North Macedonia 2020-02-27T16:23:03 1 0 0 41.6086 21.7453
111   San Marino 2020-03-01T07:13:07 1 0 0 43.9424 12.4578
112   Sri Lanka 2020-02-08T03:43:03 1 0 1 7.0 81.0
113 Boston, MA US 2020-02-28T21:13:12 1 0 1 42.3601 -71.0589
114 Humboldt County, CA US 2020-02-21T05:13:09 1 0 0 40.745 -123.8695
115 Los Angeles, CA US 2020-02-01T19:53:03 1 0 0 34.0522 -118.2437
116 Madison, WI US 2020-02-05T21:53:02 1 0 0 43.0731 -89.4012
117 Orange, CA US 2020-02-01T19:53:03 1 0 0 33.7879 -117.8531
118 Portland, OR US 2020-02-29T02:23:11 1 0 0 45.5051 -122.675
119 Providence, RI US 2020-03-01T15:33:03 1 0 0 41.824 -71.4128
120 San Antonio, TX US 2020-02-13T18:53:02 1 0 0 29.4241 -98.4936
121 Tempe, AZ US 2020-02-25T21:23:03 1 0 1 33.4255 -111.94
122 From Diamond Princess Australia 2020-02-29T02:03:10 0 0 0 35.4437 139.638
123 Lackland, TX (From Diamond Princess) US 2020-02-24T23:33:02 0 0 0 29.3829 -98.6134
124 Omaha, NE (From Diamond Princess) US 2020-02-24T23:33:02 0 0 0 41.2545 -95.9758
125 Travis, CA (From Diamond Princess) US 2020-02-24T23:33:02 0 0 0 38.2721 -121.9399

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

CREATE TABLE "03-01-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 5.326ms