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

292 rows sorted by Latitude

View and edit SQL

Suggested facets: Last Update (date)

Link rowid Province/State Country/Region Last Update Confirmed Deaths Recovered Latitude ▼ Longitude
209 Tasmania Australia 2020-03-19T11:13:54 10 0 3 -41.4545 145.9707
176   New Zealand 2020-03-19T02:33:08 28 0 0 -40.9006 174.886
113   Argentina 2020-03-19T10:53:03 97 3 3 -38.4161 -63.6167
99 Victoria Australia 2020-03-18T12:13:09 121 0 8 -37.8136 144.9631
71   Chile 2020-03-18T13:33:12 238 0 0 -35.6751 -71.543
230 Australian Capital Territory Australia 2020-03-19T11:13:54 4 0 0 -35.4735 149.0124
158 South Australia Australia 2020-03-19T11:13:54 42 0 3 -34.9285 138.6007
56 New South Wales Australia 2020-03-19T11:13:54 307 5 4 -33.8688 151.2093
124   Uruguay 2020-03-19T02:13:17 79 0 0 -32.5228 -55.7658
143 Western Australia Australia 2020-03-19T11:13:54 52 1 0 -31.9505 115.8605
88   South Africa 2020-03-19T16:43:03 150 0 0 -30.5595 22.9375
91 Queensland Australia 2020-03-19T11:13:54 144 0 8 -28.0167 153.4
266   Eswatini 2020-03-15T06:41:54 1 0 0 -26.5225 31.4659
204   Paraguay 2020-03-18T11:53:04 11 0 0 -23.4425 -58.4438
240   Namibia 2020-03-19T20:13:52 3 0 0 -22.9576 18.4904
284 Reunion France 2020-03-18T14:33:15 0 0 0 -21.1351 55.2471
194   Reunion 2020-03-19T09:33:04 14 0 0 -21.1151 55.5364
247 New Caledonia France 2020-03-19T02:33:09 2 0 0 -20.9043 165.618
237   Mauritius 2020-03-19T02:33:08 3 0 0 -20.3484 57.5522
267   Fiji 2020-03-19T14:53:06 1 0 0 -17.7134 178.065
223 French Polynesia France 2020-03-19T11:33:36 6 0 0 -17.6797 -149.4068
197   Bolivia 2020-03-18T11:53:04 12 0 0 -16.2902 -63.5887
34   Brazil 2020-03-19T20:43:02 621 6 2 -14.235 -51.9253
257   Zambia 2020-03-19T01:53:06 2 0 0 -13.1339 27.8493
283 Mayotte France 2020-03-18T14:33:15 0 0 0 -12.8431 45.1383
238   Mayotte 2020-03-18T02:53:03 3 0 0 -12.8275 45.1662
259 Northern Territory Australia 2020-03-14T01:53:03 1 0 0 -12.4634 130.8456
72   Peru 2020-03-19T18:13:29 234 0 1 -9.19 -75.0152
226   Tanzania 2020-03-19T11:33:36 6 0 0 -6.369 34.8888
225   Seychelles 2020-03-19T02:13:17 6 0 0 -4.6796 55.492
193   Congo (Kinshasa) 2020-03-19T10:53:03 14 0 0 -4.0383 21.7587
217   Rwanda 2020-03-18T11:33:04 8 0 0 -1.9403 29.8739
77   Ecuador 2020-03-19T17:13:14 199 3 0 -1.8312 -78.1834
290   Republic of the Congo 2020-03-17T21:33:03 0 0 0 -1.44 15.556
268   Gabon 2020-03-14T13:33:04 1 0 0 -0.8037 11.6094
55   Indonesia 2020-03-19T10:13:16 311 25 11 -0.7893 113.9213
234   Congo (Brazzaville) 2020-03-19T20:13:56 3 0 0 -0.228 15.8277
219   Kenya 2020-03-19T02:33:08 7 0 0 -0.0236 37.9062
49   Singapore 2020-03-19T16:13:36 345 0 114 1.3521 103.8198
221   Equatorial Guinea 2020-03-19T20:43:03 6 0 0 1.6508 10.2679
196   Maldives 2020-03-15T18:20:18 13 0 0 3.2028 73.2207
195   Cameroon 2020-03-19T02:53:32 13 0 0 3.848 11.5021
276   Suriname 2020-03-14T16:33:03 1 0 0 3.9193 -56.0278
202   French Guiana 2020-03-16T14:38:46 11 0 0 3.9339 -53.1258
281 French Guiana France 2020-03-18T14:33:15 0 0 0 4.0 -53.0
26   Malaysia 2020-03-19T10:13:15 900 2 75 4.2105 101.9758
127   Brunei 2020-03-19T11:13:33 75 0 0 4.5353 114.7277
111   Colombia 2020-03-19T10:53:03 102 0 1 4.5709 -74.2973
218   Guyana 2020-03-17T10:53:03 7 1 0 4.8604 -58.9302
275   Somalia 2020-03-18T00:53:03 1 0 0 5.1521 46.1996
159   Venezuela 2020-03-19T20:13:34 42 0 0 6.4238 -66.5897
249   Liberia 2020-03-18T03:13:22 2 0 0 6.4281 -9.4295
261   Central African Republic 2020-03-16T03:33:03 1 0 0 6.6111 20.9394
212   Cote d'Ivoire 2020-03-19T01:03:46 9 0 1 7.54 -5.5471
139   Sri Lanka 2020-03-19T16:13:36 60 0 3 7.8731 80.7718
203   Ghana 2020-03-19T17:13:24 11 0 0 7.9465 -1.0232
106   Panama 2020-03-19T02:33:08 109 1 0 8.538 -80.7821
277   Togo 2020-03-13T22:22:02 1 0 0 8.6195 0.8248
216   Nigeria 2020-03-18T12:33:03 8 0 1 9.082 8.6753
222   Ethiopia 2020-03-18T11:33:04 6 0 0 9.145 40.4897
244   Benin 2020-03-18T14:13:56 2 0 0 9.3077 2.3158
132   Costa Rica 2020-03-19T02:53:32 69 1 0 9.7489 -83.7534
270   Guinea 2020-03-15T06:41:54 1 0 0 9.9456 -9.6966
214   Trinidad and Tobago 2020-03-19T10:53:03 9 0 0 10.6918 -61.2225
264   Djibouti 2020-03-19T14:53:06 1 0 0 11.8251 42.5903
241 Curacao Netherlands 2020-03-19T08:53:03 3 1 0 12.1696 -68.99
169   Burkina Faso 2020-03-19T11:33:30 33 1 0 12.2383 -1.5616
251 Aruba Netherlands 2020-03-18T00:53:02 2 0 0 12.5186 -70.0358
229   Aruba 2020-03-18T11:53:04 4 0 0 12.5211 -69.9683
163   Cambodia 2020-03-19T10:53:03 37 0 1 12.5657 104.991
253   Sudan 2020-03-18T12:13:09 1 1 0 12.8628 30.2176
273   Nicaragua 2020-03-19T08:33:08 1 0 0 12.8654 -85.2072
74   Philippines 2020-03-19T11:13:24 217 17 8 12.8797 121.774
274   Saint Vincent and the Grenadines 2020-03-14T16:33:03 1 0 0 12.9843 -61.2872
227   Barbados 2020-03-19T20:43:03 5 0 0 13.1939 -59.5432
269   Gambia, The 2020-03-18T14:13:56 1 0 0 13.4432 -15.3101
199 Guam US 2020-03-19T16:13:38 12 0 0 13.4443 144.7937
286   Guam 2020-03-18T19:14:33 0 0 0 13.4443 144.7937
292   The Gambia 2020-03-18T14:13:56 0 0 0 13.4667 -16.6
265   El Salvador 2020-03-19T14:53:06 1 0 0 13.7942 -88.8965
252   Saint Lucia 2020-03-17T04:32:19 2 0 0 13.9094 -60.9789
121   Vietnam 2020-03-19T20:13:34 85 0 16 14.0583 108.2772
171   Senegal 2020-03-18T11:33:04 31 0 2 14.4974 -14.4524
177   Martinique 2020-03-19T02:33:08 23 1 0 14.6415 -61.0242
198   Honduras 2020-03-19T10:53:03 12 0 0 15.2 -86.2419
262   Chad 2020-03-19T16:43:03 1 0 0 15.4542 18.7322
213   Guatemala 2020-03-19T17:13:24 9 1 0 15.7835 -90.2308
64   Thailand 2020-03-19T10:13:16 272 1 42 15.87 100.9925
282 Guadeloupe France 2020-03-18T14:33:15 0 0 0 16.25 -61.5833
170   Guadeloupe 2020-03-19T09:33:04 33 0 0 16.265 -61.551
279 Montserrat United Kingdom 2020-03-18T11:53:04 1 0 0 16.7425 -62.1874
258   Antigua and Barbuda 2020-03-15T18:20:19 1 0 0 17.0608 -61.7964
235 Saint Barthelemy France 2020-03-16T14:38:45 3 0 0 17.9 -62.8333
231 St Martin France 2020-03-19T09:33:04 4 0 0 18.0708 -63.0501
191   Jamaica 2020-03-19T02:33:08 15 1 2 18.1096 -77.2975
289   Puerto Rico 2020-03-17T16:13:14 0 0 0 18.2 -66.5
228 Puerto Rico US 2020-03-16T00:22:11 5 0 0 18.2208 -66.5901
242 Virgin Islands US 2020-03-19T16:13:38 3 0 0 18.3358 -64.8963
254 United States Virgin Islands US 2020-03-18T00:13:13 2 0 0 18.35 -64.933
167   Dominican Republic 2020-03-19T02:53:32 34 2 0 18.7357 -70.1627

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

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