03-19-2020
Data source: Big Local News · About: README
292 rows sorted by Country/Region
This data as json, copyable, CSV (advanced)
Suggested facets: Last Update (date)
Link | rowid | Province/State | Country/Region ▼ | Last Update | Confirmed | Deaths | Recovered | Latitude | Longitude |
---|---|---|---|---|---|---|---|---|---|
179 | 179 | Afghanistan | 2020-03-17T11:53:10 | 25 | 0 | 1 | 33.9391 | 67.71 | |
135 | 135 | Albania | 2020-03-19T11:33:30 | 64 | 2 | 0 | 41.1533 | 20.1683 | |
119 | 119 | Algeria | 2020-03-19T16:13:36 | 87 | 9 | 32 | 28.0339 | 1.6596 | |
141 | 141 | Andorra | 2020-03-19T01:03:40 | 53 | 0 | 1 | 42.5063 | 1.5218 | |
258 | 258 | Antigua and Barbuda | 2020-03-15T18:20:19 | 1 | 0 | 0 | 17.0608 | -61.7964 | |
113 | 113 | Argentina | 2020-03-19T10:53:03 | 97 | 3 | 3 | -38.4161 | -63.6167 | |
105 | 105 | Armenia | 2020-03-19T10:53:03 | 115 | 0 | 1 | 40.0691 | 45.0382 | |
229 | 229 | Aruba | 2020-03-18T11:53:04 | 4 | 0 | 0 | 12.5211 | -69.9683 | |
56 | 56 | New South Wales | Australia | 2020-03-19T11:13:54 | 307 | 5 | 4 | -33.8688 | 151.2093 |
91 | 91 | Queensland | Australia | 2020-03-19T11:13:54 | 144 | 0 | 8 | -28.0167 | 153.4 |
99 | 99 | Victoria | Australia | 2020-03-18T12:13:09 | 121 | 0 | 8 | -37.8136 | 144.9631 |
143 | 143 | Western Australia | Australia | 2020-03-19T11:13:54 | 52 | 1 | 0 | -31.9505 | 115.8605 |
158 | 158 | South Australia | Australia | 2020-03-19T11:13:54 | 42 | 0 | 3 | -34.9285 | 138.6007 |
209 | 209 | Tasmania | Australia | 2020-03-19T11:13:54 | 10 | 0 | 3 | -41.4545 | 145.9707 |
230 | 230 | Australian Capital Territory | Australia | 2020-03-19T11:13:54 | 4 | 0 | 0 | -35.4735 | 149.0124 |
259 | 259 | Northern Territory | Australia | 2020-03-14T01:53:03 | 1 | 0 | 0 | -12.4634 | 130.8456 |
280 | 280 | From Diamond Princess | Australia | 2020-03-14T02:33:04 | 0 | 0 | 0 | 35.4437 | 139.638 |
12 | 12 | Austria | 2020-03-19T14:53:05 | 2013 | 6 | 9 | 47.5162 | 14.5501 | |
152 | 152 | Azerbaijan | 2020-03-19T16:13:36 | 44 | 1 | 6 | 40.1431 | 47.5769 | |
232 | 232 | Bahamas, The | 2020-03-19T11:33:39 | 3 | 0 | 0 | 25.0343 | -77.3963 | |
60 | 60 | Bahrain | 2020-03-19T18:13:29 | 278 | 1 | 100 | 26.0667 | 50.5577 | |
185 | 185 | Bangladesh | 2020-03-19T10:53:03 | 17 | 1 | 3 | 23.685 | 90.3563 | |
227 | 227 | Barbados | 2020-03-19T20:43:03 | 5 | 0 | 0 | 13.1939 | -59.5432 | |
145 | 145 | Belarus | 2020-03-18T11:33:04 | 51 | 0 | 5 | 53.7098 | 27.9534 | |
13 | 13 | Belgium | 2020-03-19T11:13:17 | 1795 | 21 | 31 | 50.5039 | 4.4699 | |
244 | 244 | Benin | 2020-03-18T14:13:56 | 2 | 0 | 0 | 9.3077 | 2.3158 | |
260 | 260 | Bhutan | 2020-03-13T22:22:02 | 1 | 0 | 0 | 27.5142 | 90.4336 | |
197 | 197 | Bolivia | 2020-03-18T11:53:04 | 12 | 0 | 0 | -16.2902 | -63.5887 | |
136 | 136 | Bosnia and Herzegovina | 2020-03-19T17:13:24 | 63 | 0 | 2 | 43.9159 | 17.6791 | |
34 | 34 | Brazil | 2020-03-19T20:43:02 | 621 | 6 | 2 | -14.235 | -51.9253 | |
127 | 127 | Brunei | 2020-03-19T11:13:33 | 75 | 0 | 0 | 4.5353 | 114.7277 | |
115 | 115 | Bulgaria | 2020-03-19T10:53:03 | 94 | 3 | 0 | 42.7339 | 25.4858 | |
169 | 169 | Burkina Faso | 2020-03-19T11:33:30 | 33 | 1 | 0 | 12.2383 | -1.5616 | |
163 | 163 | Cambodia | 2020-03-19T10:53:03 | 37 | 0 | 1 | 12.5657 | 104.991 | |
195 | 195 | Cameroon | 2020-03-19T02:53:32 | 13 | 0 | 0 | 3.848 | 11.5021 | |
67 | 67 | Ontario | Canada | 2020-03-19T16:43:04 | 257 | 1 | 5 | 51.2538 | -85.3232 |
73 | 73 | British Columbia | Canada | 2020-03-19T03:13:26 | 231 | 7 | 4 | 53.7267 | -127.6476 |
100 | 100 | Quebec | Canada | 2020-03-19T17:43:04 | 121 | 3 | 0 | 52.9399 | -73.5491 |
101 | 101 | Alberta | Canada | 2020-03-19T03:13:26 | 119 | 0 | 0 | 53.9333 | -116.5765 |
186 | 186 | Manitoba | Canada | 2020-03-19T03:13:26 | 17 | 0 | 0 | 53.7609 | -98.8139 |
188 | 188 | Saskatchewan | Canada | 2020-03-19T01:03:51 | 16 | 0 | 0 | 52.9399 | -106.4509 |
192 | 192 | Nova Scotia | Canada | 2020-03-19T20:43:03 | 14 | 0 | 0 | 44.682 | -63.7443 |
200 | 200 | New Brunswick | Canada | 2020-03-18T18:33:03 | 11 | 0 | 0 | 46.5653 | -66.4619 |
211 | 211 | Grand Princess | Canada | 2020-03-18T11:53:04 | 9 | 0 | 0 | 37.6489 | -122.6655 |
233 | 233 | Newfoundland and Labrador | Canada | 2020-03-17T17:53:03 | 3 | 0 | 0 | 53.1355 | -57.6604 |
245 | 245 | Prince Edward Island | Canada | 2020-03-19T18:43:03 | 2 | 0 | 0 | 46.5107 | -63.4168 |
261 | 261 | Central African Republic | 2020-03-16T03:33:03 | 1 | 0 | 0 | 6.6111 | 20.9394 | |
262 | 262 | Chad | 2020-03-19T16:43:03 | 1 | 0 | 0 | 15.4542 | 18.7322 | |
71 | 71 | Chile | 2020-03-18T13:33:12 | 238 | 0 | 0 | -35.6751 | -71.543 | |
1 | 1 | Hubei | China | 2020-03-19T10:13:14 | 67800 | 3130 | 57682 | 30.9756 | 112.2707 |
16 | 16 | Guangdong | China | 2020-03-19T01:13:06 | 1378 | 8 | 1318 | 23.3417 | 113.4244 |
18 | 18 | Henan | China | 2020-03-14T09:53:08 | 1273 | 22 | 1250 | 33.882 | 113.614 |
19 | 19 | Zhejiang | China | 2020-03-19T10:13:14 | 1233 | 1 | 1217 | 29.1832 | 120.0934 |
21 | 21 | Hunan | China | 2020-03-14T08:33:03 | 1018 | 4 | 1014 | 27.6104 | 111.7088 |
22 | 22 | Anhui | China | 2020-03-11T02:18:14 | 990 | 6 | 984 | 31.8257 | 117.2264 |
24 | 24 | Jiangxi | China | 2020-03-12T02:13:04 | 935 | 1 | 934 | 27.614 | 115.7221 |
28 | 28 | Shandong | China | 2020-03-19T01:02:56 | 761 | 7 | 747 | 36.3427 | 118.1498 |
33 | 33 | Jiangsu | China | 2020-03-15T01:53:02 | 631 | 0 | 631 | 32.9711 | 119.455 |
35 | 35 | Chongqing | China | 2020-03-15T03:53:04 | 576 | 6 | 570 | 30.0572 | 107.874 |
37 | 37 | Sichuan | China | 2020-03-19T10:13:14 | 540 | 3 | 536 | 30.6171 | 102.7103 |
38 | 38 | Heilongjiang | China | 2020-03-19T01:02:56 | 483 | 13 | 460 | 47.862 | 127.7615 |
39 | 39 | Beijing | China | 2020-03-19T05:13:10 | 480 | 8 | 380 | 40.1824 | 116.4142 |
47 | 47 | Shanghai | China | 2020-03-19T01:02:56 | 363 | 3 | 326 | 31.202 | 121.4491 |
54 | 54 | Hebei | China | 2020-03-13T11:09:03 | 318 | 6 | 310 | 38.0428 | 114.5149 |
57 | 57 | Fujian | China | 2020-03-11T02:18:14 | 296 | 1 | 295 | 26.0789 | 117.9874 |
69 | 69 | Guangxi | China | 2020-03-18T00:33:02 | 253 | 2 | 250 | 23.8298 | 108.7881 |
70 | 70 | Shaanxi | China | 2020-03-18T03:53:02 | 246 | 3 | 237 | 35.1917 | 108.8701 |
75 | 75 | Hong Kong | China | 2020-03-19T09:53:20 | 208 | 4 | 95 | 22.3 | 114.2 |
82 | 82 | Yunnan | China | 2020-03-16T23:53:02 | 176 | 2 | 172 | 24.974 | 101.487 |
83 | 83 | Hainan | China | 2020-03-16T14:38:45 | 168 | 6 | 161 | 19.1959 | 109.7453 |
90 | 90 | Guizhou | China | 2020-03-18T01:53:03 | 146 | 2 | 144 | 26.8154 | 106.8748 |
93 | 93 | Tianjin | China | 2020-03-19T23:43:03 | 137 | 3 | 133 | 39.3054 | 117.323 |
94 | 94 | Gansu | China | 2020-03-19T14:33:08 | 134 | 2 | 91 | 36.0611 | 103.8343 |
95 | 95 | Shanxi | China | 2020-03-13T11:09:03 | 133 | 0 | 133 | 37.5777 | 112.2922 |
96 | 96 | Liaoning | China | 2020-03-18T02:13:06 | 125 | 1 | 122 | 41.2956 | 122.6085 |
116 | 116 | Jilin | China | 2020-03-16T00:22:10 | 93 | 1 | 92 | 43.6661 | 126.1923 |
126 | 126 | Xinjiang | China | 2020-03-11T02:18:14 | 76 | 3 | 73 | 41.1129 | 85.2401 |
128 | 128 | Inner Mongolia | China | 2020-03-19T01:03:02 | 75 | 1 | 74 | 44.0935 | 113.9448 |
129 | 129 | Ningxia | China | 2020-03-16T14:38:45 | 75 | 0 | 75 | 37.2692 | 106.1655 |
182 | 182 | Qinghai | China | 2020-03-11T02:18:14 | 18 | 0 | 18 | 35.7452 | 95.9956 |
187 | 187 | Macau | China | 2020-03-19T01:02:56 | 17 | 0 | 10 | 22.1667 | 113.55 |
263 | 263 | Tibet | China | 2020-03-11T02:18:14 | 1 | 0 | 1 | 31.6927 | 88.0924 |
111 | 111 | Colombia | 2020-03-19T10:53:03 | 102 | 0 | 1 | 4.5709 | -74.2973 | |
234 | 234 | Congo (Brazzaville) | 2020-03-19T20:13:56 | 3 | 0 | 0 | -0.228 | 15.8277 | |
193 | 193 | Congo (Kinshasa) | 2020-03-19T10:53:03 | 14 | 0 | 0 | -4.0383 | 21.7587 | |
132 | 132 | Costa Rica | 2020-03-19T02:53:32 | 69 | 1 | 0 | 9.7489 | -83.7534 | |
212 | 212 | Cote d'Ivoire | 2020-03-19T01:03:46 | 9 | 0 | 1 | 7.54 | -5.5471 | |
109 | 109 | Croatia | 2020-03-19T16:43:03 | 105 | 1 | 5 | 45.1 | 15.2 | |
30 | 30 | Diamond Princess | Cruise Ship | 2020-03-18T10:33:04 | 712 | 7 | 325 | 35.4498 | 139.6649 |
201 | 201 | Cuba | 2020-03-19T10:53:03 | 11 | 1 | 0 | 21.5218 | -77.7812 | |
134 | 134 | Cyprus | 2020-03-19T18:13:29 | 67 | 0 | 0 | 35.1264 | 33.4299 | |
31 | 31 | Czechia | 2020-03-19T18:13:20 | 694 | 0 | 3 | 49.8175 | 15.473 | |
20 | 20 | Denmark | Denmark | 2020-03-19T17:13:42 | 1151 | 6 | 1 | 56.2639 | 9.5018 |
131 | 131 | Faroe Islands | Denmark | 2020-03-19T10:53:03 | 72 | 0 | 0 | 61.8926 | -6.9118 |
246 | 246 | Greenland | Denmark | 2020-03-19T08:13:19 | 2 | 0 | 0 | 71.7069 | -42.6043 |
264 | 264 | Djibouti | 2020-03-19T14:53:06 | 1 | 0 | 0 | 11.8251 | 42.5903 | |
167 | 167 | Dominican Republic | 2020-03-19T02:53:32 | 34 | 2 | 0 | 18.7357 | -70.1627 | |
77 | 77 | Ecuador | 2020-03-19T17:13:14 | 199 | 3 | 0 | -1.8312 | -78.1834 | |
68 | 68 | Egypt | 2020-03-19T20:43:02 | 256 | 6 | 32 | 26.8206 | 30.8025 | |
265 | 265 | El Salvador | 2020-03-19T14:53:06 | 1 | 0 | 0 | 13.7942 | -88.8965 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE [03-19-2020] ( [Province/State] TEXT, [Country/Region] TEXT, [Last Update] TEXT, [Confirmed] INTEGER, [Deaths] INTEGER, [Recovered] INTEGER, [Latitude] FLOAT, [Longitude] FLOAT );