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

249 rows sorted by Latitude

✎ 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
177 177 Tasmania Australia 2020-03-14T01:53:03 5 0 0 -41.4545 145.9707
171 171   New Zealand 2020-03-14T20:53:02 6 0 0 -40.9006 174.886
108 108   Argentina 2020-03-14T20:33:03 34 2 1 -38.4161 -63.6167
93 93 Victoria Australia 2020-03-14T13:33:04 49 0 8 -37.8136 144.9631
87 87   Chile 2020-03-14T20:33:03 61 0 0 -35.6751 -71.543
215 215 Australian Capital Territory Australia 2020-03-14T01:53:03 1 0 0 -35.4735 149.0124
132 132 South Australia Australia 2020-03-14T13:33:04 19 0 3 -34.9285 138.6007
62 62 New South Wales Australia 2020-03-14T13:33:04 112 2 4 -33.8688 151.2093
189 189   Uruguay 2020-03-14T16:33:03 4 0 0 -32.5228 -55.7658
140 140 Western Australia Australia 2020-03-14T13:33:04 17 1 0 -31.9505 115.8605
105 105   South Africa 2020-03-14T16:14:56 38 0 0 -30.5595 22.9375
95 95 Queensland Australia 2020-03-14T13:33:04 46 0 8 -28.0167 153.4
223 223   Eswatini 2020-03-14T13:13:25 1 0 0 -26.5225 31.4659
172 172   Paraguay 2020-03-13T23:33:06 6 0 0 -23.4425 -58.4438
205 205   Namibia 2020-03-14T16:33:03 2 0 0 -22.9576 18.4904
173 173   Reunion 2020-03-14T20:53:02 6 0 0 -21.1151 55.5364
191 191 French Polynesia France 2020-03-14T16:53:03 3 0 0 -17.6797 149.4068
154 154   Bolivia 2020-03-14T12:53:07 10 0 0 -16.2902 -63.5887
51 51   Brazil 2020-03-13T22:21:58 151 0 0 -14.235 -51.9253
216 216 Northern Territory Australia 2020-03-14T01:53:03 1 0 0 -12.4634 130.8456
104 104   Peru 2020-03-14T12:33:03 38 0 0 -9.19 -75.0152
207 207   Seychelles 2020-03-14T23:13:06 2 0 0 -4.6796 55.492
200 200   Congo (Kinshasa) 2020-03-13T22:22:02 2 0 0 -4.0383 21.7587
238 238   Rwanda 2020-03-14T12:53:07 1 0 0 -1.9403 29.8739
115 115   Ecuador 2020-03-14T22:53:02 28 2 0 -1.8312 -78.1834
226 226   Gabon 2020-03-14T13:33:04 1 0 0 -0.8037 11.6094
71 71   Indonesia 2020-03-14T22:53:02 96 5 8 -0.7893 113.9213
234 234   Kenya 2020-03-13T22:22:03 1 0 0 -0.0236 37.9062
42 42   Singapore 2020-03-14T16:14:30 212 0 105 1.3521 103.8198
156 156   Maldives 2020-03-14T16:14:58 10 0 0 3.2028 73.2207
198 198   Cameroon 2020-03-13T22:22:02 2 0 0 3.848 11.5021
242 242   Suriname 2020-03-14T16:33:03 1 0 0 3.9193 -56.0278
179 179   French Guiana 2020-03-07T03:23:05 5 0 0 3.9339 -53.1258
178 178 Fench Guiana France 2020-03-14T16:53:03 5 0 0 4.0 -53.0
39 39   Malaysia 2020-03-14T16:13:55 238 0 35 4.2105 101.9758
101 101   Brunei 2020-03-14T20:33:03 40 0 0 4.5353 114.7277
126 126   Colombia 2020-03-14T20:53:02 22 0 0 4.5709 -74.2973
231 231   Guyana 2020-03-14T23:33:02 1 1 0 4.8604 -58.9302
212 212   Venezuela 2020-03-14T12:53:07 2 0 0 6.4238 -66.5897
221 221   Cote d'Ivoire 2020-03-13T22:22:02 1 0 0 7.54 -5.5471
158 158   Sri Lanka 2020-03-14T16:14:58 10 0 1 7.8731 80.7718
192 192   Ghana 2020-03-14T23:13:05 3 0 0 7.9465 -1.0232
107 107   Panama 2020-03-14T12:33:03 36 1 0 8.538 -80.7821
243 243   Togo 2020-03-13T22:22:02 1 0 0 8.6195 0.8248
206 206   Nigeria 2020-03-13T22:22:02 2 0 0 9.082 8.6753
224 224   Ethiopia 2020-03-13T23:33:06 1 0 0 9.145 40.4897
118 118   Costa Rica 2020-03-14T12:33:03 26 0 0 9.7489 -83.7534
230 230   Guinea 2020-03-13T15:33:33 1 0 0 9.9456 -9.6966
208 208   Trinidad and Tobago 2020-03-14T16:15:01 2 0 0 10.6918 -61.2225
222 222   Curacao 2020-03-14T16:15:18 1 0 0 12.1696 -68.99
197 197   Burkina Faso 2020-03-13T22:22:02 2 0 0 12.2383 -1.5616
196 196   Aruba 2020-03-13T23:53:03 2 0 0 12.5211 -69.9683
168 168   Cambodia 2020-03-14T12:53:07 7 0 1 12.5657 104.991
241 241   Sudan 2020-03-14T01:13:32 1 1 0 12.8628 30.2176
63 63   Philippines 2020-03-14T20:33:03 111 8 2 12.8797 121.774
240 240   Saint Vincent and the Grenadines 2020-03-14T16:33:03 1 0 0 12.9843 -61.2872
239 239   Saint Lucia 2020-03-14T16:15:18 1 0 0 13.9094 -60.9789
91 91   Vietnam 2020-03-14T12:13:12 53 0 16 14.0583 108.2772
157 157   Senegal 2020-03-13T23:33:05 10 0 1 14.4974 -14.4524
163 163   Martinique 2020-03-14T14:53:04 9 0 0 14.6415 -61.0242
202 202   Honduras 2020-03-13T22:22:02 2 0 0 15.2 -86.2419
228 228   Guatemala 2020-03-14T01:33:03 1 0 0 15.7835 -90.2308
75 75   Thailand 2020-03-14T12:13:12 82 1 35 15.87 100.9925
227 227   Guadeloupe 2020-03-13T12:33:03 1 0 0 16.265 -61.551
214 214   Antigua and Barbuda 2020-03-13T22:22:06 1 0 0 17.0608 -61.7964
225 225 Saint Barthelemy France 2020-03-14T16:33:03 1 0 0 17.9 -62.8333
201 201 St Martin France 2020-03-14T16:33:03 2 0 0 18.0708 -63.0501
165 165   Jamaica 2020-03-13T22:22:02 8 0 0 18.1096 -77.2975
194 194 Puerto Rico US 2020-03-14T18:33:03 3 0 0 18.2208 -66.5901
245 245 Virgin Islands, U.S. US 2020-03-14T16:15:18 1 0 0 18.3358 -64.8963
153 153   Dominican Republic 2020-03-14T20:53:02 11 0 0 18.7357 -70.1627
49 49 Hainan China 2020-03-12T03:53:02 168 6 160 19.1959 109.7453
219 219   Cayman Islands 2020-03-13T12:33:03 1 0 0 19.3133 -81.2546
69 69   India 2020-03-14T20:33:03 102 2 4 20.5937 78.9629
235 235   Mauritania 2020-03-14T12:53:07 1 0 0 21.0079 10.9408
186 186 Hawaii US 2020-03-14T19:53:03 4 0 0 21.0943 -157.4983
133 133   Oman 2020-03-13T23:33:05 19 0 9 21.4735 55.9754
184 184   Cuba 2020-03-13T23:53:02 4 0 0 21.5218 -77.7812
155 155 Macau China 2020-03-11T18:52:03 10 0 10 22.1667 113.55
53 53 Hong Kong China 2020-03-14T12:53:06 140 4 78 22.3 114.2
9 9 Guangdong China 2020-03-14T01:13:11 1356 8 1299 23.3417 113.4244
74 74   United Arab Emirates 2020-03-13T22:21:58 85 0 17 23.4241 53.8478
121 121   Mexico 2020-03-14T20:53:02 26 0 4 23.6345 -102.5528
190 190   Bangladesh 2020-03-13T22:22:02 3 0 0 23.685 90.3563
90 90   Taiwan* 2020-03-14T07:13:11 53 1 20 23.7 121.0
37 37 Guangxi China 2020-03-13T11:09:03 252 2 243 23.8298 108.7881
68 68   Saudi Arabia 2020-03-14T20:33:03 103 0 1 23.8859 45.0792
47 47 Yunnan China 2020-03-14T23:33:02 174 2 172 24.974 101.487
34 34   Qatar 2020-03-14T22:33:03 337 0 4 25.3548 51.1839
43 43   Bahrain 2020-03-14T11:53:29 210 0 44 26.0667 50.5577
36 36 Fujian China 2020-03-11T02:18:14 296 1 295 26.0789 117.9874
52 52 Guizhou China 2020-03-14T00:53:03 146 2 143 26.8154 106.8748
65 65   Egypt 2020-03-14T22:33:03 109 2 27 26.8206 30.8025
217 217   Bhutan 2020-03-13T22:22:02 1 0 0 27.5142 90.4336
14 14 Hunan China 2020-03-14T08:33:03 1018 4 1014 27.6104 111.7088
18 18 Jiangxi China 2020-03-12T02:13:04 935 1 934 27.614 115.7221
80 80 Florida US 2020-03-14T18:53:03 76 3 0 27.7663 -81.6868
106 106   Algeria 2020-03-14T12:33:03 37 3 12 28.0339 1.6596
237 237   Nepal 2020-03-13T22:22:03 1 0 1 28.3949 84.124
11 11 Zhejiang China 2020-03-14T02:14:15 1227 1 1211 29.1832 120.0934

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

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