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

79 rows where "Last Update" is on date 2020-03-11

✎ View and edit SQL

This data as json, copyable, CSV (advanced)

Suggested facets: Deaths, Recovered

Last Update (date) ✖

  • 2020-03-11 · 79 ✖
Link rowid ▼ Province/State Country/Region Last Update Confirmed Deaths Recovered Latitude Longitude
2 2   Italy 2020-03-11T21:33:02 12462 827 1045 43.0 12.0
5 5 France France 2020-03-11T22:53:03 2281 48 12 46.2276 2.2137
9 9 Henan China 2020-03-11T08:13:09 1273 22 1249 33.882 113.614
12 12 Anhui China 2020-03-11T02:18:14 990 6 984 31.8257 117.2264
16 16 Diamond Princess Cruise Ship 2020-03-11T22:13:12 696 7 325 35.4437 139.638
17 17   Switzerland 2020-03-11T20:53:02 652 4 4 46.8182 8.2275
24 24   Netherlands 2020-03-11T14:13:11 503 5 0 52.1326 5.2913
26 26 UK United Kingdom 2020-03-11T21:33:03 456 8 18 55.3781 -3.436
32 32   Belgium 2020-03-11T18:52:03 314 3 1 50.8333 4.0
34 34 Fujian China 2020-03-11T02:18:14 296 1 295 26.0789 117.9874
35 35   Qatar 2020-03-11T18:52:03 262 0 0 25.3548 51.1839
39 39   Bahrain 2020-03-11T22:33:03 195 0 35 26.0275 50.55
40 40   Singapore 2020-03-11T13:53:24 178 0 96 1.2833 103.8333
41 41 Yunnan China 2020-03-11T02:18:14 174 2 170 24.974 101.487
43 43   Malaysia 2020-03-11T11:33:08 149 0 26 2.5 112.5
49 49 Gansu China 2020-03-11T14:33:03 127 2 88 37.8099 101.0583
53 53   Greece 2020-03-11T23:53:02 99 1 0 39.0742 21.8243
59 59 Xinjiang China 2020-03-11T02:18:14 76 3 73 41.1129 85.2401
60 60 Inner Mongolia China 2020-03-11T03:53:03 75 1 71 44.0935 113.9448
61 61 Ningxia China 2020-03-11T09:33:12 75 0 72 37.2692 106.1655
67 67 New South Wales Australia 2020-03-11T18:52:04 65 2 4 -33.8688 151.2093
69 69   Finland 2020-03-11T13:33:10 59 0 1 64.0 26.0
70 70   Portugal 2020-03-11T13:33:11 59 0 0 39.3999 -8.2245
80 80   Ireland 2020-03-11T21:33:03 43 1 0 53.1424 -7.6921
84 84   Indonesia 2020-03-11T11:14:26 34 1 2 -0.7893 113.9213
91 91   Georgia 2020-03-11T22:13:12 24 0 0 42.3154 43.3569
94 94   Chile 2020-03-11T22:13:12 23 0 0 -35.6751 -71.543
97 97 Victoria Australia 2020-03-11T18:52:04 21 0 7 -37.8136 144.9631
99 99 Queensland Australia 2020-03-11T18:52:04 20 0 8 -28.0167 153.4
101 101   Argentina 2020-03-11T02:18:16 19 1 0 -38.4161 -63.6167
102 102 Alberta Canada 2020-03-11T23:13:07 19 0 0 53.9333 -116.5765
103 103   Croatia 2020-03-11T22:13:12 19 0 0 45.1667 15.5
107 107 Qinghai China 2020-03-11T02:18:14 18 0 18 35.7452 95.9956
110 110   Ecuador 2020-03-11T09:33:12 17 0 0 -1.8312 -78.1834
113 113   Estonia 2020-03-11T22:13:12 16 0 0 58.5953 25.0136
119 119   Hungary 2020-03-11T22:13:12 13 0 0 47.1625 19.5033
125 125   Azerbaijan 2020-03-11T08:13:09 11 0 3 40.1431 47.5769
127 127   Brunei 2020-03-11T22:13:12 11 0 0 4.5353 114.7277
129 129 Macau China 2020-03-11T18:52:03 10 0 10 22.1667 113.55
130 130   Latvia 2020-03-11T13:53:24 10 0 1 56.8796 24.6032
131 131 District of Columbia US 2020-03-11T22:53:03 10 0 0 38.8974 -77.0268
134 134 South Australia Australia 2020-03-11T18:52:04 9 0 2 -34.9285 138.6007
135 135 Western Australia Australia 2020-03-11T18:52:04 9 1 0 -31.9505 115.8605
137 137   Colombia 2020-03-11T14:33:04 9 0 0 4.5709 -74.2973
138 138 Arizona US 2020-03-11T18:52:04 9 0 1 33.7298 -111.4312
140 140   Maldives 2020-03-11T09:33:12 8 0 0 3.2028 73.2207
141 141 South Dakota US 2020-03-11T22:53:03 8 1 0 44.2998 -99.4388
143 143   Afghanistan 2020-03-11T10:13:12 12 0 0 33.0 65.0
144 144   Bulgaria 2020-03-11T22:13:12 7 1 0 42.7339 25.4858
146 146   Tunisia 2020-03-11T18:52:03 7 0 0 33.8869 9.5375
147 147   Cyprus 2020-03-11T18:52:03 6 0 0 35.1264 33.4299
148 148   Malta 2020-03-11T11:33:08 6 0 0 35.9375 14.3754
155 155   Paraguay 2020-03-11T04:33:03 5 0 0 -23.4425 -58.4438
159 159 Rhode Island US 2020-03-11T03:13:08 5 0 0 41.6809 -71.5118
163 163 Tasmania Australia 2020-03-11T18:52:04 3 0 0 -41.4545 145.9707
165 165   Cambodia 2020-03-11T09:33:12 3 0 1 12.5657 104.991
167 167   Lithuania 2020-03-11T02:18:26 3 0 0 55.1694 23.8813
168 168   Martinique 2020-03-11T02:18:29 3 0 0 14.6415 -61.0242
169 169   Moldova 2020-03-11T18:52:03 3 0 0 47.4116 28.3699
170 170   Bolivia 2020-03-11T18:52:03 2 0 0 -16.2902 -63.5887
171 171   Burkina Faso 2020-03-11T09:33:12 2 0 0 12.2383 -1.5616
173 173 Faroe Islands Denmark 2020-03-11T20:53:02 2 0 0 61.8926 -6.9118
174 174 St Martin France 2020-03-11T20:53:02 2 0 0 18.0708 -63.0501
175 175   Honduras 2020-03-11T18:52:03 2 0 0 15.2 -86.2419
179 179   Sri Lanka 2020-03-11T09:33:12 2 0 1 7.8731 80.7718
181 181 Michigan US 2020-03-11T03:33:05 2 0 0 43.3266 -84.5361
184 184 Channel Islands United Kingdom 2020-03-11T20:53:02 2 0 0 49.3723 -2.3644
188 188 New Brunswick Canada 2020-03-11T23:13:06 1 0 0 46.5653 -66.4619
189 189 Tibet China 2020-03-11T02:18:14 1 0 1 31.6927 88.0924
190 190   Congo (Kinshasa) 2020-03-11T21:13:24 1 0 0 -4.0383 21.7587
192 192 Saint Barthelemy France 2020-03-11T20:53:02 1 0 0 17.9 -62.8333
199 199   Reunion 2020-03-11T23:13:07 1 0 0 -21.1151 55.5364
201 201   Turkey 2020-03-11T03:33:05 1 0 0 38.9637 35.2433
202 202 Delaware US 2020-03-11T23:13:06 1 0 0 39.3185 -75.5071
206 206 Montana US 2020-03-11T23:13:06 1 0 0 46.9219 -110.4544
210 210 Gibraltar United Kingdom 2020-03-11T20:53:02 1 0 1 36.1408 -5.3536
212 212 Gansu Mainland China 2020-03-11T02:18:28 0 0 0 36.0611 103.8343
213 213 Hebei Mainland China 2020-03-11T02:18:29 0 0 0 38.0428 114.5149
218 218   occupied Palestinian territory 2020-03-11T20:53:02 0 0 0 31.9522 35.2332

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
);