03-02-2020
Data source: Big Local News · About: README
141 rows sorted by Last Update
This data as json, copyable, CSV (advanced)
Suggested facets: Deaths, Last Update (date)
Link | rowid | Province/State | Country/Region | Last Update ▼ | Confirmed | Deaths | Recovered | Latitude | Longitude |
---|---|---|---|---|---|---|---|---|---|
127 | 127 | Los Angeles, CA | US | 2020-02-01T19:53:03 | 1 | 0 | 0 | 34.0522 | -118.2437 |
130 | 130 | Orange, CA | US | 2020-02-01T19:53:03 | 1 | 0 | 0 | 33.7879 | -117.8531 |
97 | 97 | San Benito, CA | US | 2020-02-03T03:53:02 | 2 | 0 | 0 | 36.5761 | -120.9876 |
128 | 128 | Madison, WI | US | 2020-02-05T21:53:02 | 1 | 0 | 0 | 43.0731 | -89.4012 |
122 | 122 | Sri Lanka | 2020-02-08T03:43:03 | 1 | 0 | 1 | 7.0 | 81.0 | |
113 | 113 | Tibet | Mainland China | 2020-02-12T06:43:02 | 1 | 0 | 1 | 31.6927 | 88.0924 |
85 | 85 | Philippines | 2020-02-12T07:43:02 | 3 | 1 | 1 | 13.0 | 122.0 | |
104 | 104 | Cambodia | 2020-02-12T07:43:02 | 1 | 0 | 1 | 11.55 | 104.9167 | |
116 | 116 | Nepal | 2020-02-12T14:43:03 | 1 | 0 | 1 | 28.1667 | 84.25 | |
106 | 106 | London, ON | Canada | 2020-02-12T18:53:03 | 1 | 0 | 1 | 42.9849 | -81.2453 |
132 | 132 | San Antonio, TX | US | 2020-02-13T18:53:02 | 1 | 0 | 0 | 29.4241 | -98.4936 |
52 | 52 | Qinghai | Mainland China | 2020-02-21T04:43:02 | 18 | 0 | 18 | 35.7452 | 95.9956 |
126 | 126 | Humboldt County, CA | US | 2020-02-21T05:13:09 | 1 | 0 | 0 | 40.745 | -123.8695 |
98 | 98 | San Diego County, CA | US | 2020-02-21T05:43:02 | 2 | 0 | 1 | 32.7157 | -117.1611 |
99 | 99 | Afghanistan | 2020-02-24T23:33:02 | 1 | 0 | 0 | 33.0 | 65.0 | |
139 | 139 | Lackland, TX (From Diamond Princess) | US | 2020-02-24T23:33:02 | 0 | 0 | 0 | 29.3829 | -98.6134 |
140 | 140 | Omaha, NE (From Diamond Princess) | US | 2020-02-24T23:33:02 | 0 | 0 | 0 | 41.2545 | -95.9758 |
141 | 141 | Travis, CA (From Diamond Princess) | US | 2020-02-24T23:33:02 | 0 | 0 | 0 | 38.2721 | -121.9399 |
55 | 55 | Vietnam | 2020-02-25T08:53:02 | 16 | 0 | 16 | 16.0 | 108.0 | |
136 | 136 | Tempe, AZ | US | 2020-02-25T21:23:03 | 1 | 0 | 1 | 33.4255 | -111.94 |
60 | 60 | Macau | Macau | 2020-02-27T12:43:02 | 10 | 0 | 8 | 22.1667 | 113.55 |
108 | 108 | Estonia | 2020-02-27T16:23:03 | 1 | 0 | 0 | 58.5953 | 25.0136 | |
119 | 119 | North Macedonia | 2020-02-27T16:23:03 | 1 | 0 | 0 | 41.6086 | 21.7453 | |
96 | 96 | Sacramento County, CA | US | 2020-02-27T20:33:02 | 2 | 0 | 0 | 38.4747 | -121.3542 |
105 | 105 | Montreal, QC | Canada | 2020-02-28T05:23:07 | 1 | 0 | 0 | 45.5017 | -73.5673 |
87 | 87 | Romania | 2020-02-28T15:33:03 | 3 | 0 | 0 | 45.9432 | 24.9668 | |
103 | 103 | Belarus | 2020-02-28T16:23:03 | 1 | 0 | 0 | 53.7098 | 27.9534 | |
111 | 111 | Lithuania | 2020-02-28T16:23:03 | 1 | 0 | 0 | 55.1694 | 23.8813 | |
117 | 117 | New Zealand | 2020-02-28T16:23:03 | 1 | 0 | 0 | -40.9006 | 174.886 | |
118 | 118 | Nigeria | 2020-02-28T16:23:03 | 1 | 0 | 0 | 9.082 | 8.6753 | |
123 | 123 | Boston, MA | US | 2020-02-28T21:13:12 | 1 | 0 | 1 | 42.3601 | -71.0589 |
114 | 114 | Monaco | 2020-02-29T00:33:01 | 1 | 0 | 0 | 43.7333 | 7.4167 | |
61 | 61 | Queensland | Australia | 2020-02-29T02:03:10 | 9 | 0 | 1 | -28.0167 | 153.4 |
81 | 81 | South Australia | Australia | 2020-02-29T02:03:10 | 3 | 0 | 2 | -34.9285 | 138.6007 |
138 | 138 | From Diamond Princess | Australia | 2020-02-29T02:03:10 | 0 | 0 | 0 | 35.4437 | 139.638 |
50 | 50 | United Arab Emirates | 2020-02-29T12:33:03 | 21 | 0 | 5 | 24.0 | 54.0 | |
73 | 73 | Oman | 2020-02-29T12:33:03 | 6 | 0 | 1 | 21.0 | 57.0 | |
77 | 77 | Pakistan | 2020-02-29T18:03:05 | 4 | 0 | 0 | 30.3753 | 69.3451 | |
90 | 90 | Brazil | 2020-02-29T21:03:05 | 2 | 0 | 0 | -14.235 | -51.9253 | |
65 | 65 | British Columbia | Canada | 2020-02-29T23:23:13 | 8 | 0 | 3 | 49.2827 | -123.1207 |
82 | 82 | Azerbaijan | 2020-03-01T02:43:03 | 3 | 0 | 0 | 40.1431 | 47.5769 | |
89 | 89 | Western Australia | Australia | 2020-03-01T02:43:03 | 2 | 1 | 0 | -31.9505 | 115.8605 |
109 | 109 | Ireland | 2020-03-01T07:13:07 | 1 | 0 | 0 | 53.1424 | -7.6921 | |
112 | 112 | Luxembourg | 2020-03-01T07:13:07 | 1 | 0 | 0 | 49.8153 | 6.1296 | |
31 | 31 | Liaoning | Mainland China | 2020-03-01T12:23:06 | 122 | 1 | 103 | 41.2956 | 122.6085 |
29 | 29 | Tianjin | Mainland China | 2020-03-01T12:43:02 | 136 | 3 | 111 | 39.3054 | 117.323 |
47 | 47 | Malaysia | 2020-03-01T12:53:02 | 29 | 0 | 18 | 2.5 | 112.5 | |
84 | 84 | Georgia | 2020-03-01T15:43:03 | 3 | 0 | 0 | 42.3154 | 43.3569 | |
101 | 101 | Armenia | 2020-03-01T19:53:02 | 1 | 0 | 0 | 40.0691 | 45.0382 | |
59 | 59 | Israel | 2020-03-01T23:23:02 | 12 | 0 | 0 | 31.0 | 35.0 | |
68 | 68 | Greece | 2020-03-01T23:23:02 | 7 | 0 | 0 | 39.0742 | 21.8243 | |
71 | 71 | Finland | 2020-03-01T23:23:02 | 6 | 0 | 1 | 64.0 | 26.0 | |
67 | 67 | Croatia | 2020-03-01T23:33:03 | 7 | 0 | 0 | 45.1 | 15.2 | |
69 | 69 | New South Wales | Australia | 2020-03-01T23:33:03 | 6 | 0 | 4 | -33.8688 | 151.2093 |
70 | 70 | Ecuador | 2020-03-01T23:33:03 | 6 | 0 | 0 | -1.8312 | -78.1834 | |
75 | 75 | Mexico | 2020-03-01T23:33:03 | 5 | 0 | 0 | 23.0 | -102.0 | |
76 | 76 | Denmark | 2020-03-01T23:33:03 | 4 | 0 | 0 | 56.2639 | 9.5018 | |
86 | 86 | Qatar | 2020-03-01T23:33:03 | 3 | 0 | 0 | 25.3548 | 51.1839 | |
91 | 91 | Egypt | 2020-03-01T23:33:03 | 2 | 0 | 1 | 26.0 | 30.0 | |
62 | 62 | Victoria | Australia | 2020-03-02T00:53:03 | 9 | 0 | 4 | -37.8136 | 144.9631 |
80 | 80 | Algeria | 2020-03-02T00:53:03 | 3 | 0 | 0 | 28.0339 | 1.6596 | |
66 | 66 | San Marino | 2020-03-02T01:03:12 | 8 | 0 | 0 | 43.9424 | 12.4578 | |
28 | 28 | Guizhou | Mainland China | 2020-03-02T01:13:06 | 146 | 2 | 114 | 26.8154 | 106.8748 |
10 | 10 | Jiangxi | Mainland China | 2020-03-02T01:33:02 | 935 | 1 | 850 | 27.614 | 115.7221 |
39 | 39 | Ningxia | Mainland China | 2020-03-02T01:33:02 | 74 | 0 | 69 | 37.2692 | 106.1655 |
129 | 129 | New York City, NY | US | 2020-03-02T01:53:03 | 1 | 0 | 0 | 40.7128 | -74.006 |
26 | 26 | Hainan | Mainland China | 2020-03-02T02:03:18 | 168 | 5 | 151 | 19.1959 | 109.7453 |
17 | 17 | Beijing | Mainland China | 2020-03-02T02:13:16 | 414 | 8 | 282 | 40.1824 | 116.4142 |
125 | 125 | Hillsborough, FL | US | 2020-03-02T03:13:25 | 1 | 0 | 0 | 27.9904 | -82.3018 |
134 | 134 | Sarasota, FL | US | 2020-03-02T03:23:06 | 1 | 0 | 0 | 27.3364 | -82.5307 |
94 | 94 | Portland, OR | US | 2020-03-02T03:33:08 | 2 | 0 | 0 | 45.5051 | -122.675 |
95 | 95 | Providence, RI | US | 2020-03-02T03:43:02 | 2 | 0 | 0 | 41.824 | -71.4128 |
18 | 18 | Shanghai | Mainland China | 2020-03-02T04:03:13 | 337 | 3 | 292 | 31.202 | 121.4491 |
25 | 25 | Yunnan | Mainland China | 2020-03-02T06:23:04 | 174 | 2 | 168 | 24.974 | 101.487 |
43 | 43 | Thailand | 2020-03-02T06:23:04 | 43 | 1 | 31 | 15.0 | 101.0 | |
11 | 11 | Shandong | Mainland China | 2020-03-02T08:03:12 | 758 | 6 | 460 | 36.3427 | 118.1498 |
23 | 23 | Shaanxi | Mainland China | 2020-03-02T08:03:12 | 245 | 1 | 216 | 35.1917 | 108.8701 |
45 | 45 | Taiwan | Taiwan | 2020-03-02T08:03:12 | 41 | 1 | 12 | 23.7 | 121.0 |
19 | 19 | Hebei | Mainland China | 2020-03-02T09:43:05 | 318 | 6 | 296 | 38.0428 | 114.5149 |
38 | 38 | Inner Mongolia | Mainland China | 2020-03-02T10:23:04 | 75 | 0 | 54 | 44.0935 | 113.9448 |
6 | 6 | Henan | Mainland China | 2020-03-02T11:43:03 | 1272 | 22 | 1205 | 33.882 | 113.614 |
7 | 7 | Zhejiang | Mainland China | 2020-03-02T11:43:03 | 1206 | 1 | 1069 | 29.1832 | 120.0934 |
8 | 8 | Hunan | Mainland China | 2020-03-02T11:43:03 | 1018 | 4 | 887 | 27.6104 | 111.7088 |
13 | 13 | Jiangsu | Mainland China | 2020-03-02T12:53:02 | 631 | 0 | 543 | 32.9711 | 119.455 |
16 | 16 | Heilongjiang | Mainland China | 2020-03-02T12:53:02 | 480 | 13 | 356 | 47.862 | 127.7615 |
20 | 20 | Fujian | Mainland China | 2020-03-02T12:53:02 | 296 | 1 | 255 | 26.0789 | 117.9874 |
22 | 22 | Guangxi | Mainland China | 2020-03-02T12:53:02 | 252 | 2 | 192 | 23.8298 | 108.7881 |
12 | 12 | Diamond Princess cruise ship | Others | 2020-03-02T14:33:03 | 705 | 6 | 10 | 35.4437 | 139.638 |
32 | 32 | Spain | 2020-03-02T14:43:05 | 120 | 0 | 2 | 40.0 | -4.0 | |
1 | 1 | Hubei | Mainland China | 2020-03-02T15:03:23 | 67103 | 2803 | 33934 | 30.9756 | 112.2707 |
5 | 5 | Guangdong | Mainland China | 2020-03-02T15:03:23 | 1350 | 7 | 1059 | 23.3417 | 113.4244 |
9 | 9 | Anhui | Mainland China | 2020-03-02T15:03:23 | 990 | 6 | 917 | 31.8257 | 117.2264 |
15 | 15 | Sichuan | Mainland China | 2020-03-02T15:03:23 | 538 | 3 | 386 | 30.6171 | 102.7103 |
35 | 35 | Jilin | Mainland China | 2020-03-02T15:03:23 | 93 | 1 | 83 | 43.6661 | 126.1923 |
36 | 36 | Gansu | Mainland China | 2020-03-02T15:03:23 | 91 | 2 | 85 | 36.0611 | 103.8343 |
37 | 37 | Xinjiang | Mainland China | 2020-03-02T15:43:31 | 76 | 3 | 66 | 41.1129 | 85.2401 |
83 | 83 | Czech Republic | 2020-03-02T16:33:02 | 3 | 0 | 0 | 49.8175 | 15.473 | |
107 | 107 | Dominican Republic | 2020-03-02T16:33:02 | 1 | 0 | 0 | 18.7357 | -70.1627 | |
92 | 92 | Indonesia | 2020-03-02T18:03:04 | 2 | 0 | 0 | -0.7893 | 113.9213 | |
42 | 42 | Unassigned Location (From Diamond Princess) | US | 2020-03-02T19:53:03 | 45 | 0 | 0 | 35.4437 | 139.638 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE [03-02-2020] ( [Province/State] TEXT, [Country/Region] TEXT, [Last Update] TEXT, [Confirmed] INTEGER, [Deaths] INTEGER, [Recovered] INTEGER, [Latitude] FLOAT, [Longitude] FLOAT );