03-06-2020

199 rows sorted by Latitude

View and edit SQL

Link rowid Province/State Country/Region Last Update Confirmed Deaths Recovered Latitude ▼ Longitude
133 San Benito, CA US 2020-02-03T03:53:02 2 0 0 36.5761 -120.9876
46 Ningxia Mainland China 2020-03-06T12:53:03 75 0 71 37.2692 106.1655
66 Santa Clara, CA US 2020-03-05T22:53:03 20 0 1 37.3541 -121.9552
135 San Mateo, CA US 2020-03-03T00:43:02 2 0 0 37.563 -122.3255
33 Shanxi Mainland China 2020-03-05T14:53:03 133 0 126 37.5777 112.2922
134 San Francisco County, CA US 2020-03-05T20:33:03 2 0 0 37.7749 -122.4194
111 Contra Costa County, CA US 2020-03-06T19:43:02 3 0 0 37.8534 -121.9018
166 Berkeley, CA US 2020-03-03T23:53:03 1 0 0 37.8715 -122.273
23 Hebei Mainland China 2020-03-06T03:23:06 318 6 305 38.0428 114.5149
171 Fayette County, KY US 2020-03-06T23:23:03 1 0 0 38.0606 -84.4803
199 Travis, CA (From Diamond Princess) US 2020-02-24T23:33:02 0 0 0 38.2721 -121.9399
132 Sacramento County, CA US 2020-02-27T20:33:02 2 0 0 38.4747 -121.3542
185 Sonoma County, CA US 2020-03-02T20:53:02 1 0 0 38.578 -122.9888
192 Yolo County, CA US 2020-03-06T20:13:14 1 0 0 38.7646 -121.9018
52   Greece 2020-03-06T13:03:12 45 0 0 39.0742 21.8243
101 Placer County, CA US 2020-03-06T23:13:07 5 1 0 39.0916 -120.8039
113 Montgomery County, MD US 2020-03-06T04:03:17 3 0 0 39.1547 -77.2405
32 Tianjin Mainland China 2020-03-05T03:33:27 136 3 128 39.3054 117.323
82   Portugal 2020-03-06T20:33:03 13 0 0 39.3999 -8.2245
136 Summit County, CO US 2020-03-06T01:29:39 2 0 0 39.5912 -106.064
126 Denver County, CO US 2020-03-06T23:33:02 2 0 0 39.7392 -104.9903
177 Marion County, IN US 2020-03-06T17:13:12 1 0 0 39.8362 -86.1752
169 Delaware County, PA US 2020-03-06T15:33:03 1 0 0 39.9078 -75.3879
21   Spain 2020-03-06T20:13:13 400 5 2 40.0 -4.0
140   Armenia 2020-03-01T19:53:02 1 0 0 40.0691 45.0382
93   Azerbaijan 2020-03-05T13:53:03 6 0 0 40.1431 47.5769
19 Beijing Mainland China 2020-03-06T12:53:03 422 8 299 40.1824 116.4142
189 Washoe County, NV US 2020-03-06T19:43:02 1 0 0 40.5608 -119.6035
179 Nassau County, NY US 2020-03-06T14:43:15 1 0 0 40.6546 -73.5594
75 New York County, NY US 2020-03-06T19:13:40 16 0 0 40.7128 -74.006
175 Humboldt County, CA US 2020-02-21T05:13:09 1 0 0 40.745 -123.8695
125 Bergen County, NJ US 2020-03-05T21:03:12 2 0 0 40.9263 -74.077
44 Xinjiang Mainland China 2020-03-06T05:53:03 76 3 71 41.1129 85.2401
68 Westchester County, NY US 2020-03-06T15:43:03 19 0 0 41.122 -73.7949
198 Omaha, NE (From Diamond Princess) US 2020-02-24T23:33:02 0 0 0 41.2545 -95.9758
36 Liaoning Mainland China 2020-03-03T14:33:03 125 1 106 41.2956 122.6085
170 Douglas County, NE US 2020-03-06T23:33:02 1 0 0 41.3148 -96.1951
109   North Macedonia 2020-03-06T20:23:11 3 0 0 41.6086 21.7453
190 Wayne County, PA US 2020-03-06T16:13:15 1 0 0 41.6739 -75.2479
100 Cook County, IL US 2020-03-05T18:33:03 5 0 2 41.7377 -87.6976
131 Providence, RI US 2020-03-02T03:43:02 2 0 0 41.824 -71.4128
194   Vatican City 2020-03-06T15:43:02 1 0 0 41.9029 12.4534
180 Norwell County, MA US 2020-03-06T02:33:03 1 0 0 42.1615 -70.7928
124 Norfolk County, MA US 2020-03-06T18:33:03 2 0 0 42.1767 -71.1449
104   Georgia 2020-03-05T13:53:03 4 0 0 42.3154 43.3569
116 Suffolk County, MA US 2020-03-06T18:33:03 3 0 1 42.3601 -71.0589
178 Middlesex County, MA US 2020-03-06T01:29:39 1 0 0 42.4672 -71.2874
139   Andorra 2020-03-02T20:23:16 1 0 0 42.5063 1.5218
146 London, ON Canada 2020-02-12T18:53:03 1 0 1 42.9849 -81.2453
4   Italy 2020-03-06T17:33:03 4636 197 523 43.0 12.0
176 Madison, WI US 2020-03-03T15:53:03 1 0 1 43.0731 -89.4012
60 Toronto, ON Canada 2020-03-06T20:53:02 24 0 2 43.6532 -79.3832
42 Jilin Mainland China 2020-03-06T10:23:03 93 1 90 43.6661 126.1923
156   Monaco 2020-02-29T00:33:01 1 0 0 43.7333 7.4167
128 Grafton County, NH US 2020-03-03T23:33:03 2 0 0 43.9088 -71.826
118   Bosnia and Herzegovina 2020-03-05T17:13:30 2 0 0 43.9159 17.6791
65   San Marino 2020-03-05T13:53:03 21 1 0 43.9424 12.4578
160   Serbia 2020-03-06T15:43:02 1 0 0 44.0165 21.0059
45 Inner Mongolia Mainland China 2020-03-05T23:53:01 75 1 65 44.0935 113.9448
181 Ramsey County, MN US 2020-03-06T23:23:03 1 0 0 44.9964 -93.0616
85   Croatia 2020-03-06T08:33:03 11 0 0 45.1667 15.5
119 Montreal, QC Canada 2020-03-05T14:03:04 2 0 0 45.5017 -73.5673
137 Washington County, OR US 2020-03-03T03:03:02 2 0 0 45.547 -123.1386
187 Umatilla, OR US 2020-03-02T20:23:16 1 0 0 45.775 -118.7606
89   Romania 2020-03-06T16:43:04 9 0 1 46.0 25.0
92   Slovenia 2020-03-06T15:33:03 7 0 0 46.1512 14.9955
27   Switzerland 2020-03-06T15:23:19 214 1 3 46.8182 8.2275
14   France 2020-03-06T20:13:13 653 9 12 47.0 2.0
153   Liechtenstein 2020-03-04T01:33:07 1 0 0 47.14 9.55
121   Hungary 2020-03-05T17:13:27 2 0 0 47.1625 19.5033
174 Grant County, WA US 2020-03-05T20:23:07 1 0 0 47.1981 -119.3732
50   Austria 2020-03-06T16:33:04 55 0 0 47.5162 14.5501
49 King County, WA US 2020-03-06T23:13:07 58 12 1 47.548 -121.9836
102 Unassigned Location, WA US 2020-03-06T00:33:03 5 0 0 47.7511 -120.7401
18 Heilongjiang Mainland China 2020-03-06T14:23:04 481 13 396 47.862 127.7615
67 Snohomish County, WA US 2020-03-06T23:13:07 19 1 0 48.033 -121.8339
193   Ukraine 2020-03-03T15:33:02 1 0 0 48.3794 31.1656
161   Slovakia 2020-03-06T13:03:14 1 0 0 48.669 19.699
63 British Columbia Canada 2020-03-06T04:43:03 21 0 3 49.2827 -123.1207
122   Luxembourg 2020-03-06T01:29:39 2 0 0 49.8144 6.1317
69   Czech Republic 2020-03-06T16:33:04 18 0 0 49.8175 15.473
38   Belgium 2020-03-06T12:33:03 109 0 1 50.8333 4.0
13   Germany 2020-03-06T17:53:03 670 0 17 51.0 9.0
145 Calgary, Alberta Canada 2020-03-06T13:13:34 1 0 0 51.0447 -114.0719
98   Poland 2020-03-06T16:43:04 5 0 0 51.9194 19.1451
35   Netherlands 2020-03-06T13:23:06 128 1 0 52.1326 5.2913
70   Ireland 2020-03-06T20:43:03 18 0 0 53.1424 -7.6921
94   Belarus 2020-03-04T12:43:03 6 0 0 53.7098 27.9534
30   UK 2020-03-06T15:33:03 163 2 8 55.0 -3.0
154   Lithuania 2020-02-28T16:23:03 1 0 0 55.1694 23.8813
61   Denmark 2020-03-06T13:03:12 23 0 1 56.2639 9.5018
152   Latvia 2020-03-04T01:33:07 1 0 0 56.8796 24.6032
87   Estonia 2020-03-06T13:03:13 10 0 0 58.5953 25.0136
83   Russia 2020-03-06T20:43:03 13 0 2 60.0 90.0
39   Norway 2020-03-06T16:33:04 108 0 0 60.472 8.4689
149   Faroe Islands 2020-03-04T12:53:03 1 0 0 61.8926 -6.9118
41   Sweden 2020-03-06T13:03:12 101 0 0 63.0 16.0
78   Finland 2020-03-06T13:03:12 15 0 1 64.0 26.0
55   Iceland 2020-03-06T15:33:03 43 0 0 64.9631 -19.0208

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

CREATE TABLE "03-06-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.865ms