03-02-2020

141 rows

View and edit SQL

Link rowid Province/State Country/Region Last Update Confirmed Deaths Recovered Latitude Longitude
101   Armenia 2020-03-01T19:53:02 1 0 0 40.0691 45.0382
102 Tasmania Australia 2020-03-02T20:53:02 1 0 0 -41.4545 145.9707
103   Belarus 2020-02-28T16:23:03 1 0 0 53.7098 27.9534
104   Cambodia 2020-02-12T07:43:02 1 0 1 11.55 104.9167
105 Montreal, QC Canada 2020-02-28T05:23:07 1 0 0 45.5017 -73.5673
106 London, ON Canada 2020-02-12T18:53:03 1 0 1 42.9849 -81.2453
107   Dominican Republic 2020-03-02T16:33:02 1 0 0 18.7357 -70.1627
108   Estonia 2020-02-27T16:23:03 1 0 0 58.5953 25.0136
109   Ireland 2020-03-01T07:13:07 1 0 0 53.1424 -7.6921
110   Latvia 2020-03-02T20:13:49 1 0 0 56.8796 24.6032
111   Lithuania 2020-02-28T16:23:03 1 0 0 55.1694 23.8813
112   Luxembourg 2020-03-01T07:13:07 1 0 0 49.8153 6.1296
113 Tibet Mainland China 2020-02-12T06:43:02 1 0 1 31.6927 88.0924
114   Monaco 2020-02-29T00:33:01 1 0 0 43.7333 7.4167
115   Morocco 2020-03-02T22:33:09 1 0 0 31.7917 -7.0926
116   Nepal 2020-02-12T14:43:03 1 0 1 28.1667 84.25
117   New Zealand 2020-02-28T16:23:03 1 0 0 -40.9006 174.886
118   Nigeria 2020-02-28T16:23:03 1 0 0 9.082 8.6753
119   North Macedonia 2020-02-27T16:23:03 1 0 0 41.6086 21.7453
120   Saudi Arabia 2020-03-02T23:53:02 1 0 0 24.0 45.0
121   Senegal 2020-03-02T20:23:16 1 0 0 14.4974 -14.4524
122   Sri Lanka 2020-02-08T03:43:03 1 0 1 7.0 81.0
123 Boston, MA US 2020-02-28T21:13:12 1 0 1 42.3601 -71.0589
124 Grafton County, NH US 2020-03-02T20:33:02 1 0 0 43.9088 -71.826
125 Hillsborough, FL US 2020-03-02T03:13:25 1 0 0 27.9904 -82.3018
126 Humboldt County, CA US 2020-02-21T05:13:09 1 0 0 40.745 -123.8695
127 Los Angeles, CA US 2020-02-01T19:53:03 1 0 0 34.0522 -118.2437
128 Madison, WI US 2020-02-05T21:53:02 1 0 0 43.0731 -89.4012
129 New York City, NY US 2020-03-02T01:53:03 1 0 0 40.7128 -74.006
130 Orange, CA US 2020-02-01T19:53:03 1 0 0 33.7879 -117.8531
131 Placer County, CA US 2020-03-02T23:53:02 1 0 0 39.0916 -120.8039
132 San Antonio, TX US 2020-02-13T18:53:02 1 0 0 29.4241 -98.4936
133 San Mateo, CA US 2020-03-02T20:43:02 1 0 0 37.563 -122.3255
134 Sarasota, FL US 2020-03-02T03:23:06 1 0 0 27.3364 -82.5307
135 Sonoma County, CA US 2020-03-02T20:53:02 1 0 0 38.578 -122.9888
136 Tempe, AZ US 2020-02-25T21:23:03 1 0 1 33.4255 -111.94
137 Umatilla, OR US 2020-03-02T20:23:16 1 0 0 45.775 -118.7606
138 From Diamond Princess Australia 2020-02-29T02:03:10 0 0 0 35.4437 139.638
139 Lackland, TX (From Diamond Princess) US 2020-02-24T23:33:02 0 0 0 29.3829 -98.6134
140 Omaha, NE (From Diamond Princess) US 2020-02-24T23:33:02 0 0 0 41.2545 -95.9758
141 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-02-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.984ms