03-07-2020

225 rows

View and edit SQL

Link rowid Province/State Country/Region Last Update Confirmed Deaths Recovered Latitude Longitude
201 Marion County, IN US 2020-03-06T17:13:12 1 0 0 39.8362 -86.1752
202 Middlesex County, MA US 2020-03-07T03:53:03 1 0 0 41.912 -70.7168
203 Pierce County, WA US 2020-03-07T03:13:44 1 0 0 47.0676 -122.1295
204 Plymouth County, MA US 2020-03-07T03:53:03 1 0 0 42.1615 -70.7928
205 Ramsey County, MN US 2020-03-06T23:23:03 1 0 0 44.9964 -93.0616
206 San Antonio, TX US 2020-02-13T18:53:02 1 0 0 29.4241 -98.4936
207 Santa Cruz County, CA US 2020-03-07T23:43:03 1 0 0 36.9741 -122.0308
208 Santa Rosa County, FL US 2020-03-05T20:03:03 1 0 0 30.769 -86.9824
209 Sarasota, FL US 2020-03-02T03:23:06 1 0 0 27.3364 -82.5307
210 Sonoma County, CA US 2020-03-02T20:53:02 1 0 0 38.578 -122.9888
211 Tulsa County, OK US 2020-03-07T04:43:02 1 0 0 36.1593 -95.941
212 Umatilla, OR US 2020-03-02T20:23:16 1 0 0 45.775 -118.7606
213 Wake County, NC US 2020-03-03T20:53:02 1 0 0 35.8032 -78.5661
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
216 Williamson County, TN US 2020-03-05T23:33:03 1 0 0 35.9179 -86.8622
217 Yolo County, CA US 2020-03-06T20:13:14 1 0 0 38.7646 -121.9018
218   Ukraine 2020-03-03T15:33:02 1 0 0 48.3794 31.1656
219   Vatican City 2020-03-06T15:43:02 1 0 0 41.9029 12.4534
220 From Diamond Princess Australia 2020-02-29T02:03:10 0 0 0 35.4437 139.638
221 Northern Territory Australia 2020-03-06T04:33:03 0 0 0 -12.4634 130.8456
222 Lackland, TX (From Diamond Princess) US 2020-02-24T23:33:02 0 0 0 29.3829 -98.6134
223 Montgomery County, TX US 2020-03-07T19:53:02 0 0 0 30.3213 -95.4778
224 Omaha, NE (From Diamond Princess) US 2020-02-24T23:33:02 0 0 0 41.2545 -95.9758
225 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-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 4.43ms