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

218 rows sorted by Longitude

✎ View and edit SQL

This data as json, copyable, CSV (advanced)

Link rowid Province/State Country/Region Last Update Confirmed Deaths Recovered Latitude Longitude ▼
20 20 Denmark Denmark 2020-03-12T09:53:06 615 0 1 56.2639 9.5018
146 146   Tunisia 2020-03-11T18:52:03 7 0 0 33.8869 9.5375
196 196   Liechtenstein 2020-03-04T01:33:07 1 0 0 47.14 9.55
172 172   Cameroon 2020-03-08T05:23:03 2 0 0 3.848 11.5021
2 2   Italy 2020-03-11T21:33:02 12462 827 1045 43.0 12.0
194 194   Holy See 2020-03-10T19:13:21 1 0 0 41.9029 12.4534
65 65   San Marino 2020-03-12T08:53:02 69 3 0 43.9424 12.4578
148 148   Malta 2020-03-11T11:33:08 6 0 0 35.9375 14.3754
33 33   Austria 2020-03-12T11:13:29 302 1 4 47.5162 14.5501
56 56   Slovenia 2020-03-12T13:33:02 89 0 0 46.1512 14.9955
54 54   Czechia 2020-03-12T01:33:03 94 0 0 49.8175 15.473
103 103   Croatia 2020-03-11T22:13:12 19 0 0 45.1667 15.5
21 21   Sweden 2020-03-12T21:39:09 599 1 1 63.0 16.0
126 126   Bosnia and Herzegovina 2020-03-12T09:13:26 11 0 0 43.9159 17.6791
73 73   Poland 2020-03-12T13:33:02 49 1 0 51.9194 19.1451
119 119   Hungary 2020-03-11T22:13:12 13 0 0 47.1625 19.5033
114 114   Slovakia 2020-03-12T13:33:02 16 0 0 48.669 19.699
93 93   Albania 2020-03-12T21:39:09 23 1 0 41.1533 20.1683
105 105   Serbia 2020-03-12T09:13:24 19 0 0 44.0165 21.0059
145 145   North Macedonia 2020-03-10T10:53:03 7 0 0 41.6086 21.7453
190 190   Congo (Kinshasa) 2020-03-11T21:13:24 1 0 0 -4.0383 21.7587
53 53   Greece 2020-03-11T23:53:02 99 1 0 39.0742 21.8243
111 111   South Africa 2020-03-12T09:13:24 17 0 0 -30.5595 22.9375
167 167   Lithuania 2020-03-11T02:18:26 3 0 0 55.1694 23.8813
130 130   Latvia 2020-03-11T13:53:24 10 0 1 56.8796 24.6032
74 74   Romania 2020-03-12T09:13:24 49 0 6 46.0 25.0
113 113   Estonia 2020-03-11T22:13:12 16 0 0 58.5953 25.0136
144 144   Bulgaria 2020-03-11T22:13:12 7 1 0 42.7339 25.4858
69 69   Finland 2020-03-11T13:33:10 59 0 1 64.0 26.0
121 121   Belarus 2020-03-12T08:53:02 12 0 3 53.7098 27.9534
169 169   Moldova 2020-03-11T18:52:03 3 0 0 47.4116 28.3699
66 66   Egypt 2020-03-12T08:53:02 67 1 27 26.0 30.0
209 209   Ukraine 2020-03-03T15:33:02 1 0 0 48.3794 31.1656
147 147   Cyprus 2020-03-11T18:52:03 6 0 0 35.1264 33.4299
47 47   Israel 2020-03-12T21:39:09 112 0 0 31.0 35.0
218 218   occupied Palestinian territory 2020-03-11T20:53:02 0 0 0 31.9522 35.2332
201 201   Turkey 2020-03-11T03:33:05 1 0 0 38.9637 35.2433
68 68   Lebanon 2020-03-12T09:13:24 61 3 1 33.8547 35.8623
195 195   Jordan 2020-03-03T15:33:02 1 0 0 31.24 36.51
91 91   Georgia 2020-03-11T22:13:12 24 0 0 42.3154 43.3569
63 63   Iraq 2020-03-12T08:33:13 71 8 15 33.0 44.0
78 78   Saudi Arabia 2020-03-12T01:17:58 45 0 1 24.0 45.0
161 161   Armenia 2020-03-12T21:39:09 4 0 0 40.0691 45.0382
125 125   Azerbaijan 2020-03-11T08:13:09 11 0 3 40.1431 47.5769
58 58   Kuwait 2020-03-12T09:13:24 80 0 5 29.5 47.75
39 39   Bahrain 2020-03-11T22:33:03 195 0 35 26.0275 50.55
35 35   Qatar 2020-03-11T18:52:03 262 0 0 25.3548 51.1839
3 3   Iran 2020-03-12T11:13:27 10075 429 2959 32.0 53.0
57 57   United Arab Emirates 2020-03-12T21:39:09 85 0 17 23.4241 53.8478
199 199   Reunion 2020-03-11T23:13:07 1 0 0 -21.1151 55.5364
108 108   Oman 2020-03-10T08:33:02 18 0 9 21.0 57.0
143 143   Afghanistan 2020-03-11T10:13:12 12 0 0 33.0 65.0
100 100   Pakistan 2020-03-12T08:53:02 20 0 2 30.3753 69.3451
140 140   Maldives 2020-03-11T09:33:12 8 0 0 3.2028 73.2207
62 62   India 2020-03-12T08:33:13 73 1 4 21.0 78.0
179 179   Sri Lanka 2020-03-11T09:33:12 2 0 1 7.8731 80.7718
198 198   Nepal 2020-03-10T08:33:03 1 0 1 28.3949 84.124
59 59 Xinjiang China 2020-03-11T02:18:14 76 3 73 41.1129 85.2401
189 189 Tibet China 2020-03-11T02:18:14 1 0 1 31.6927 88.0924
88 88   Russia 2020-03-12T08:53:02 28 0 3 60.0 90.0
164 164   Bangladesh 2020-03-10T06:19:32 3 0 0 23.685 90.3563
187 187   Bhutan 2020-03-06T15:43:02 1 0 0 27.5142 90.4336
107 107 Qinghai China 2020-03-11T02:18:14 18 0 18 35.7452 95.9956
64 64   Thailand 2020-03-12T08:53:02 70 1 35 15.87 100.9925
49 49 Gansu China 2020-03-11T14:33:03 127 2 88 37.8099 101.0583
41 41 Yunnan China 2020-03-11T02:18:14 174 2 170 24.974 101.487
23 23 Sichuan China 2020-03-12T12:13:07 539 3 498 30.6171 102.7103
40 40   Singapore 2020-03-11T13:53:24 178 0 96 1.2833 103.8333
212 212 Gansu Mainland China 2020-03-11T02:18:28 0 0 0 36.0611 103.8343
197 197   Mongolia 2020-03-10T06:13:43 1 0 0 46.8625 103.8467
165 165   Cambodia 2020-03-11T09:33:12 3 0 1 12.5657 104.991
61 61 Ningxia China 2020-03-11T09:33:12 75 0 72 37.2692 106.1655
44 44 Guizhou China 2020-03-12T01:13:06 146 2 137 26.8154 106.8748
22 22 Chongqing China 2020-03-12T23:44:32 576 6 564 30.0572 107.874
82 82   Vietnam 2020-03-12T09:33:03 39 0 16 16.0 108.0
36 36 Guangxi China 2020-03-12T00:33:06 252 2 241 23.8298 108.7881
37 37 Shaanxi China 2020-03-12T01:33:02 245 2 232 35.1917 108.8701
42 42 Hainan China 2020-03-12T03:53:02 168 6 160 19.1959 109.7453
11 11 Hunan China 2020-03-12T09:53:06 1018 4 999 27.6104 111.7088
1 1 Hubei China 2020-03-12T09:53:06 67781 3056 50318 30.9756 112.2707
46 46 Shanxi China 2020-03-12T09:13:24 133 0 132 37.5777 112.2922
43 43   Malaysia 2020-03-11T11:33:08 149 0 26 2.5 112.5
8 8 Guangdong China 2020-03-12T03:53:02 1356 8 1289 23.3417 113.4244
129 129 Macau China 2020-03-11T18:52:03 10 0 10 22.1667 113.55
9 9 Henan China 2020-03-11T08:13:09 1273 22 1249 33.882 113.614
84 84   Indonesia 2020-03-11T11:14:26 34 1 2 -0.7893 113.9213
60 60 Inner Mongolia China 2020-03-11T03:53:03 75 1 71 44.0935 113.9448
48 48 Hong Kong China 2020-03-12T01:53:02 129 3 67 22.3 114.2
213 213 Hebei Mainland China 2020-03-11T02:18:29 0 0 0 38.0428 114.5149
127 127   Brunei 2020-03-11T22:13:12 11 0 0 4.5353 114.7277
13 13 Jiangxi China 2020-03-12T02:13:04 935 1 934 27.614 115.7221
135 135 Western Australia Australia 2020-03-11T18:52:04 9 1 0 -31.9505 115.8605
31 31 Hebei China 2020-03-12T05:33:02 318 6 308 39.549 116.1306
28 28 Beijing China 2020-03-12T01:13:05 435 8 334 40.1824 116.4142
12 12 Anhui China 2020-03-11T02:18:14 990 6 984 31.8257 117.2264
45 45 Tianjin China 2020-03-12T01:53:03 136 3 132 39.3054 117.323
34 34 Fujian China 2020-03-11T02:18:14 296 1 295 26.0789 117.9874
14 14 Shandong China 2020-03-12T07:53:02 760 6 734 36.3427 118.1498
19 19 Jiangsu China 2020-03-12T05:13:02 631 0 629 32.9711 119.455
10 10 Zhejiang China 2020-03-12T01:33:02 1215 1 1197 29.1832 120.0934

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

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