03-16-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

272 rows sorted by Country/Region

✎ View and edit SQL

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
148 148   Afghanistan 2020-03-16T14:38:45 18 0 1 33.9391 67.71
114 114   Albania 2020-03-16T14:38:45 51 1 0 41.1533 20.1683
105 105   Algeria 2020-03-16T14:38:45 54 4 12 28.0339 1.6596
221 221   Andorra 2020-03-16T02:33:08 2 0 1 42.5063 1.5218
233 233   Antigua and Barbuda 2020-03-15T18:20:19 1 0 0 17.0608 -61.7964
101 101   Argentina 2020-03-16T14:38:45 56 2 1 -38.4161 -63.6167
111 111   Armenia 2020-03-16T21:13:17 52 0 0 40.0691 45.0382
222 222   Aruba 2020-03-13T23:53:03 2 0 0 12.5211 -69.9683
56 56 New South Wales Australia 2020-03-16T14:38:46 171 2 4 -33.8688 151.2093
94 94 Victoria Australia 2020-03-16T14:38:45 71 0 8 -37.8136 144.9631
95 95 Queensland Australia 2020-03-16T14:38:46 68 0 8 -28.0167 153.4
135 135 South Australia Australia 2020-03-16T14:38:46 29 0 3 -34.9285 138.6007
138 138 Western Australia Australia 2020-03-16T14:38:46 28 1 0 -31.9505 115.8605
186 186 Tasmania Australia 2020-03-16T14:38:46 7 0 0 -41.4545 145.9707
223 223 Australian Capital Territory Australia 2020-03-16T14:38:46 2 0 0 -35.4735 149.0124
234 234 Northern Territory Australia 2020-03-14T01:53:03 1 0 0 -12.4634 130.8456
270 270 From Diamond Princess Australia 2020-03-14T02:33:04 0 0 0 35.4437 139.638
17 17   Austria 2020-03-16T15:13:09 1018 3 6 47.5162 14.5501
165 165   Azerbaijan 2020-03-16T14:38:45 15 1 6 40.1431 47.5769
47 47   Bahrain 2020-03-16T20:33:03 214 1 77 26.0667 50.5577
181 181   Bangladesh 2020-03-16T14:38:45 8 0 2 23.685 90.3563
127 127   Belarus 2020-03-16T14:38:45 36 0 3 53.7098 27.9534
16 16   Belgium 2020-03-16T14:38:45 1058 5 1 50.5039 4.4699
235 235   Benin 2020-03-16T14:38:46 1 0 0 9.3077 2.3158
236 236   Bhutan 2020-03-13T22:22:02 1 0 0 27.5142 90.4336
171 171   Bolivia 2020-03-16T14:38:45 11 0 0 -16.2902 -63.5887
140 140   Bosnia and Herzegovina 2020-03-16T21:13:17 25 0 0 43.9159 17.6791
49 49   Brazil 2020-03-16T02:33:08 200 0 1 -14.235 -51.9253
106 106   Brunei 2020-03-16T14:38:45 54 0 0 4.5353 114.7277
112 112   Bulgaria 2020-03-16T14:38:45 52 2 0 42.7339 25.4858
166 166   Burkina Faso 2020-03-16T14:38:45 15 0 0 12.2383 -1.5616
187 187   Cambodia 2020-03-14T12:53:07 7 0 1 12.5657 104.991
207 207   Cameroon 2020-03-16T02:33:08 4 0 0 3.848 11.5021
53 53 Ontario Canada 2020-03-16T16:13:26 177 0 5 51.2538 -85.3232
82 82 British Columbia Canada 2020-03-16T19:13:13 103 4 4 53.7267 -127.6476
102 102 Alberta Canada 2020-03-16T02:33:09 56 0 0 53.9333 -116.5765
115 115 Quebec Canada 2020-03-16T20:13:20 50 0 0 52.9399 -73.5491
188 188 Manitoba Canada 2020-03-16T02:53:12 7 0 0 53.7609 -98.8139
189 189 Saskatchewan Canada 2020-03-16T20:13:20 7 0 0 52.9399 -106.4509
194 194 New Brunswick Canada 2020-03-16T02:53:12 6 0 0 46.5653 -66.4619
201 201 Nova Scotia Canada 2020-03-16T17:53:03 5 0 0 44.682 -63.7443
224 224 Grand Princess Canada 2020-03-16T00:22:11 2 0 0 37.6489 -122.6655
237 237 Newfoundland and Labrador Canada 2020-03-15T02:13:21 1 0 0 53.1355 -57.6604
238 238 Prince Edward Island Canada 2020-03-15T02:13:21 1 0 0 46.5107 -63.4168
239 239   Central African Republic 2020-03-16T03:33:03 1 0 0 6.6111 20.9394
61 61   Chile 2020-03-16T14:38:45 155 0 0 -35.6751 -71.543
1 1 Hubei China 2020-03-16T14:38:45 67798 3099 55142 30.9756 112.2707
11 11 Guangdong China 2020-03-16T01:53:03 1361 8 1306 23.3417 113.4244
13 13 Henan China 2020-03-14T09:53:08 1273 22 1250 33.882 113.614
14 14 Zhejiang China 2020-03-16T14:38:45 1231 1 1216 29.1832 120.0934
18 18 Hunan China 2020-03-14T08:33:03 1018 4 1014 27.6104 111.7088
19 19 Anhui China 2020-03-11T02:18:14 990 6 984 31.8257 117.2264
21 21 Jiangxi China 2020-03-12T02:13:04 935 1 934 27.614 115.7221
25 25 Shandong China 2020-03-16T14:38:45 760 7 746 36.3427 118.1498
27 27 Jiangsu China 2020-03-15T01:53:02 631 0 631 32.9711 119.455
28 28 Chongqing China 2020-03-15T03:53:04 576 6 570 30.0572 107.874
31 31 Sichuan China 2020-03-15T18:20:18 539 3 516 30.6171 102.7103
32 32 Heilongjiang China 2020-03-16T14:38:45 482 13 455 47.862 127.7615
33 33 Beijing China 2020-03-16T14:38:45 452 8 360 40.1824 116.4142
35 35 Shanghai China 2020-03-16T14:38:45 355 3 325 31.202 121.4491
38 38 Hebei China 2020-03-13T11:09:03 318 6 310 38.0428 114.5149
40 40 Fujian China 2020-03-11T02:18:14 296 1 295 26.0789 117.9874
44 44 Guangxi China 2020-03-16T14:38:45 252 2 248 23.8298 108.7881
45 45 Shaanxi China 2020-03-16T14:38:45 245 2 233 35.1917 108.8701
55 55 Yunnan China 2020-03-16T23:53:02 176 2 172 24.974 101.487
58 58 Hainan China 2020-03-16T14:38:45 168 6 161 19.1959 109.7453
62 62 Hong Kong China 2020-03-16T14:38:45 155 4 84 22.3 114.2
66 66 Guizhou China 2020-03-16T14:38:45 146 2 144 26.8154 106.8748
68 68 Tianjin China 2020-03-15T18:20:18 136 3 133 39.3054 117.323
72 72 Gansu China 2020-03-15T18:20:18 133 2 91 36.0611 103.8343
73 73 Shanxi China 2020-03-13T11:09:03 133 0 133 37.5777 112.2922
74 74 Liaoning China 2020-03-16T14:38:45 125 1 115 41.2956 122.6085
85 85 Jilin China 2020-03-16T00:22:10 93 1 92 43.6661 126.1923
91 91 Xinjiang China 2020-03-11T02:18:14 76 3 73 41.1129 85.2401
92 92 Inner Mongolia China 2020-03-16T14:38:45 75 1 73 44.0935 113.9448
93 93 Ningxia China 2020-03-16T14:38:45 75 0 75 37.2692 106.1655
153 153 Qinghai China 2020-03-11T02:18:14 18 0 18 35.7452 95.9956
172 172 Macau China 2020-03-16T00:22:10 11 0 10 22.1667 113.55
240 240 Tibet China 2020-03-11T02:18:14 1 0 1 31.6927 88.0924
107 107   Colombia 2020-03-16T14:38:45 54 0 0 4.5709 -74.2973
241 241   Congo (Brazzaville) 2020-03-16T14:38:45 1 0 0 -0.228 15.8277
225 225   Congo (Kinshasa) 2020-03-13T22:22:02 2 0 0 -4.0383 21.7587
128 128   Costa Rica 2020-03-16T02:33:08 35 0 0 9.7489 -83.7534
242 242   Cote d'Ivoire 2020-03-13T22:22:02 1 0 0 7.54 -5.5471
100 100   Croatia 2020-03-16T14:38:45 57 0 2 45.1 15.2
26 26 Diamond Princess Cruise Ship 2020-03-13T14:13:25 696 7 325 35.4498 139.6649
208 208   Cuba 2020-03-13T23:53:02 4 0 0 21.5218 -77.7812
130 130   Cyprus 2020-03-16T02:33:08 33 0 0 35.1264 33.4299
39 39   Czechia 2020-03-16T23:53:02 298 0 3 49.8175 15.473
22 22 Denmark Denmark 2020-03-16T18:33:03 914 3 1 56.2639 9.5018
154 154 Faroe Islands Denmark 2020-03-16T14:38:45 18 0 0 61.8926 -6.9118
173 173   Dominican Republic 2020-03-14T20:53:02 11 0 0 18.7357 -70.1627
126 126   Ecuador 2020-03-16T02:33:08 37 2 0 -1.8312 -78.1834
64 64   Egypt 2020-03-16T15:53:45 150 2 27 26.8206 30.8025
243 243   Equatorial Guinea 2020-03-15T06:41:54 1 0 0 1.5 10.0
48 48   Estonia 2020-03-16T14:38:45 205 0 1 58.5953 25.0136
244 244   Eswatini 2020-03-15T06:41:54 1 0 0 -26.5225 31.4659
202 202   Ethiopia 2020-03-16T14:38:45 5 0 0 9.145 40.4897
41 41   Finland 2020-03-16T14:38:45 277 0 10 61.9241 25.7482
7 7 France France 2020-03-16T20:13:11 6633 148 12 46.2276 2.2137

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

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