03-20-2020

Table actions
Big Local News snapshots this data once a day from The Johns Hopkins University Center for Systems Science and Engineering. These are daily reports which provide cases, deaths and recovered for all global locations as wells as United States counties. There is one CSV file for each day's report. The entire set of CSV files are refreshed daily. The zipped archives contain previous daily reports and are date stamped when they were uplaoded by Big Local News. Please cite Johns Hopkins University as described in the README.

Data source: Big Local News · About: README

299 rows sorted by Longitude descending

✎ View and edit SQL

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 ▲
272 272   Fiji 2020-03-19T14:53:06 1 0 0 -17.7134 178.065
172 172   New Zealand 2020-03-20T02:13:50 39 0 0 -40.9006 174.886
255 255 New Caledonia France 2020-03-19T02:33:09 2 0 0 -20.9043 165.618
86 86 Queensland Australia 2020-03-20T21:13:30 184 0 8 -28.0167 153.4
61 61 New South Wales Australia 2020-03-20T21:13:30 353 6 4 -33.8688 151.2093
229 229 Australian Capital Territory Australia 2020-03-20T21:13:30 6 0 0 -35.4735 149.0124
218 218 Tasmania Australia 2020-03-19T11:13:54 10 0 3 -41.4545 145.9707
115 115 Victoria Australia 2020-03-18T12:13:09 121 0 8 -37.8136 144.9631
205 205 Guam US 2020-03-20T16:43:10 14 0 0 13.4443 144.7937
293 293   Guam 2020-03-18T19:14:33 0 0 0 13.4443 144.7937
280 280   Papua New Guinea 2020-03-20T18:13:12 1 0 0 -6.315 143.9555
32 32 Diamond Princess Cruise Ship 2020-03-18T10:33:04 712 7 325 35.4498 139.6649
159 159 Diamond Princess US 2020-03-20T19:43:03 49 0 0 35.4437 139.638
287 287 From Diamond Princess Australia 2020-03-14T02:33:04 0 0 0 35.4437 139.638
156 156 South Australia Australia 2020-03-20T21:13:30 50 0 3 -34.9285 138.6007
26 26   Japan 2020-03-20T14:13:08 963 33 191 36.2048 138.2529
240 240 Northern Territory Australia 2020-03-20T21:13:29 3 0 0 -12.4634 130.8456
7 7   Korea, South 2020-03-20T02:13:46 8652 94 1540 35.9078 127.7669
45 45 Heilongjiang China 2020-03-20T02:13:46 484 13 463 47.862 127.7615
122 122 Jilin China 2020-03-16T00:22:10 93 1 92 43.6661 126.1923
112 112 Liaoning China 2020-03-20T01:43:03 126 2 122 41.2956 122.6085
81 81   Philippines 2020-03-20T14:43:04 230 18 8 12.8797 121.774
56 56 Shanghai China 2020-03-20T00:43:02 371 3 326 31.202 121.4491
105 105   Taiwan* 2020-03-20T09:43:03 135 2 26 23.7 121.0
20 20 Zhejiang China 2020-03-20T02:43:09 1234 1 1219 29.1832 120.0934
35 35 Jiangsu China 2020-03-15T01:53:02 631 0 631 32.9711 119.455
31 31 Shandong China 2020-03-20T01:13:16 762 7 748 36.3427 118.1498
69 69 Fujian China 2020-03-20T02:43:09 299 1 295 26.0789 117.9874
100 100 Tianjin China 2020-03-19T23:43:03 137 3 133 39.3054 117.323
25 25 Anhui China 2020-03-11T02:18:14 990 6 984 31.8257 117.2264
44 44 Beijing China 2020-03-20T06:43:05 491 8 390 40.1824 116.4142
149 149 Western Australia Australia 2020-03-20T21:13:30 64 1 0 -31.9505 115.8605
27 27 Jiangxi China 2020-03-12T02:13:04 935 1 934 27.614 115.7221
133 133   Brunei 2020-03-20T15:43:24 78 0 1 4.5353 114.7277
65 65 Hebei China 2020-03-13T11:09:03 318 6 310 38.0428 114.5149
74 74 Hong Kong China 2020-03-20T09:43:03 256 4 98 22.3 114.2
139 139 Inner Mongolia China 2020-03-19T01:03:02 75 1 74 44.0935 113.9448
57 57   Indonesia 2020-03-20T14:43:04 369 32 15 -0.7893 113.9213
18 18 Henan China 2020-03-14T09:53:08 1273 22 1250 33.882 113.614
195 195 Macau China 2020-03-19T01:02:56 17 0 10 22.1667 113.55
17 17 Guangdong China 2020-03-20T09:13:30 1395 8 1323 23.3417 113.4244
107 107 Shanxi China 2020-03-13T11:09:03 133 0 133 37.5777 112.2922
1 1 Hubei China 2020-03-20T07:43:02 67800 3133 58382 30.9756 112.2707
24 24 Hunan China 2020-03-14T08:33:03 1018 4 1014 27.6104 111.7088
90 90 Hainan China 2020-03-16T14:38:45 168 6 161 19.1959 109.7453
77 77 Shaanxi China 2020-03-20T01:13:16 247 3 237 35.1917 108.8701
75 75 Guangxi China 2020-03-20T00:43:02 254 2 250 23.8298 108.7881
123 123   Vietnam 2020-03-20T20:43:02 91 0 16 14.0583 108.2772
37 37 Chongqing China 2020-03-15T03:53:04 576 6 570 30.0572 107.874
96 96 Guizhou China 2020-03-18T01:53:03 146 2 144 26.8154 106.8748
140 140 Ningxia China 2020-03-16T14:38:45 75 0 75 37.2692 106.1655
76 76   Russia 2020-03-20T15:43:24 253 1 9 61.524 105.3188
155 155   Cambodia 2020-03-20T15:43:24 51 0 1 12.5657 104.991
233 233   Mongolia 2020-03-18T11:53:04 6 0 0 46.8625 103.8467
106 106 Gansu China 2020-03-20T00:13:24 134 2 98 36.0611 103.8343
55 55   Singapore 2020-03-20T15:43:24 385 0 124 1.3521 103.8198
40 40 Sichuan China 2020-03-20T01:43:03 541 3 536 30.6171 102.7103
22 22   Malaysia 2020-03-20T18:13:09 1030 3 87 4.2105 101.9758
87 87 Yunnan China 2020-03-16T23:53:02 176 2 172 24.974 101.487
64 64   Thailand 2020-03-20T14:13:08 322 1 43 15.87 100.9925
192 192 Qinghai China 2020-03-11T02:18:14 18 0 18 35.7452 95.9956
252 252   Bhutan 2020-03-20T14:13:37 2 0 0 27.5142 90.4336
187 187   Bangladesh 2020-03-20T15:13:21 20 1 3 23.685 90.3563
268 268 Tibet China 2020-03-11T02:18:14 1 0 1 31.6927 88.0924
137 137 Xinjiang China 2020-03-11T02:18:14 76 3 73 41.1129 85.2401
276 276   Nepal 2020-03-13T22:22:03 1 0 1 28.3949 84.124
141 141   Sri Lanka 2020-03-20T16:13:11 73 0 3 7.8731 80.7718
78 78   India 2020-03-20T15:13:21 244 5 20 20.5937 78.9629
231 231   Kyrgyzstan 2020-03-20T14:13:36 6 0 0 41.2044 74.7661
209 209   Maldives 2020-03-15T18:20:18 13 0 0 3.2028 73.2207
42 42   Pakistan 2020-03-20T20:13:16 501 3 13 30.3753 69.3451
183 183   Afghanistan 2020-03-20T14:43:04 29 0 1 33.9391 67.71
157 157   Kazakhstan 2020-03-20T14:13:08 49 0 0 48.0196 66.9237
176 176   Uzbekistan 2020-03-20T14:43:04 33 0 0 41.3775 64.5853
212 212   Mauritius 2020-03-20T15:13:21 12 0 0 -20.3484 57.5522
161 161   Oman 2020-03-19T20:13:34 48 0 12 21.4735 55.9754
181 181   Reunion 2020-03-20T02:13:59 28 0 0 -21.1151 55.5364
227 227   Seychelles 2020-03-20T15:43:24 7 0 0 -4.6796 55.492
291 291 Reunion France 2020-03-18T14:33:15 0 0 0 -21.1351 55.2471
98 98   United Arab Emirates 2020-03-20T23:13:09 140 2 31 23.4241 53.8478
5 5   Iran 2020-03-20T15:13:21 19644 1433 6745 32.4279 53.688
47 47   Qatar 2020-03-20T20:13:16 470 0 10 25.3548 51.1839
70 70   Bahrain 2020-03-20T14:43:04 285 1 100 26.0667 50.5577
165 165   Azerbaijan 2020-03-19T16:13:36 44 1 6 40.1431 47.5769
93 93   Kuwait 2020-03-20T14:43:04 159 0 18 29.3117 47.4818
246 246   Madagascar 2020-03-20T22:13:53 3 0 0 -18.7669 46.8691
282 282   Somalia 2020-03-18T00:53:03 1 0 0 5.1521 46.1996
232 232   Mayotte 2020-03-20T10:13:38 6 0 0 -12.8275 45.1662
290 290 Mayotte France 2020-03-18T14:33:15 0 0 0 -12.8431 45.1383
62 62   Saudi Arabia 2020-03-20T20:43:02 344 0 8 23.8859 45.0792
103 103   Armenia 2020-03-20T14:43:04 136 0 1 40.0691 45.0382
82 82   Iraq 2020-03-20T20:43:02 208 17 49 33.2232 43.6793
168 168   Georgia 2020-03-20T14:43:04 43 0 1 42.3154 43.3569
269 269   Djibouti 2020-03-19T14:53:06 1 0 0 11.8251 42.5903
222 222   Ethiopia 2020-03-20T14:13:11 9 0 0 9.145 40.4897
226 226   Kenya 2020-03-19T02:33:08 7 0 0 -0.0236 37.9062
129 129   Jordan 2020-03-20T20:43:02 85 0 1 30.5852 36.2384
92 92   Lebanon 2020-03-20T14:43:04 163 4 4 33.8547 35.8623
60 60   Turkey 2020-03-20T01:43:03 359 4 0 38.9637 35.2433
234 234   Tanzania 2020-03-19T11:33:36 6 0 0 -6.369 34.8888

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

CREATE TABLE [03-20-2020] (
   [Province/State] TEXT,
   [Country/Region] TEXT,
   [Last Update] TEXT,
   [Confirmed] INTEGER,
   [Deaths] INTEGER,
   [Recovered] INTEGER,
   [Latitude] FLOAT,
   [Longitude] FLOAT
);