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

3,437 rows sorted by Province_State

✎ View and edit SQL

This data as json, copyable, CSV (advanced)

Link rowid FIPS Admin2 Province_State ▼ Country_Region Last_Update Lat Long_ Confirmed Deaths Recovered Active Combined_Key
3264 3264       Afghanistan 3/29/20 23:08 33.93911 67.709953 118 4 2 114 Afghanistan
3265 3265       Albania 3/29/20 23:08 41.1533 20.1683 212 10 33 169 Albania
3266 3266       Algeria 3/29/20 23:08 28.0339 1.6596 511 31 31 449 Algeria
3267 3267       Andorra 3/29/20 23:08 42.5063 1.5218 334 6 1 327 Andorra
3268 3268       Angola 3/29/20 23:08 -11.2027 17.8739 7 2 0 5 Angola
3269 3269       Antigua and Barbuda 3/29/20 23:08 17.0608 -61.7964 7 0 0 7 Antigua and Barbuda
3270 3270       Argentina 3/29/20 23:08 -38.4161 -63.6167 745 19 72 654 Argentina
3271 3271       Armenia 3/29/20 23:08 40.0691 45.0382 424 3 30 391 Armenia
3272 3272       Austria 3/29/20 23:08 47.5162 14.5501 8788 86 479 8223 Austria
3273 3273       Azerbaijan 3/29/20 23:08 40.1431 47.5769 209 4 15 190 Azerbaijan
3274 3274       Bahamas 3/29/20 23:08 25.025885 -78.035889 11 0 1 10 Bahamas
3275 3275       Bahrain 3/29/20 23:08 26.0275 50.55 499 4 272 223 Bahrain
3276 3276       Bangladesh 3/29/20 23:08 23.685 90.3563 48 5 15 28 Bangladesh
3277 3277       Barbados 3/29/20 23:08 13.1939 -59.5432 33 0 0 33 Barbados
3278 3278       Belarus 3/29/20 23:08 53.7098 27.9534 94 0 32 62 Belarus
3279 3279       Belgium 3/29/20 23:08 50.8333 4.469936 10836 431 1359 9046 Belgium
3280 3280       Belize 3/29/20 23:08 17.1899 -88.4976 2 0 0 2 ,,Belize
3281 3281       Benin 3/29/20 23:08 9.3077 2.3158 6 0 0 6 Benin
3282 3282       Bhutan 3/29/20 23:08 27.5142 90.4336 4 0 0 4 Bhutan
3283 3283       Bolivia 3/29/20 23:08 -16.2902 -63.5887 81 1 0 80 Bolivia
3284 3284       Bosnia and Herzegovina 3/29/20 23:08 43.9159 17.6791 323 6 8 309 Bosnia and Herzegovina
3285 3285       Brazil 3/29/20 23:08 -14.235 -51.9253 4256 136 6 4114 Brazil
3286 3286       Brunei 3/29/20 23:08 4.5353 114.7277 126 1 34 91 Brunei
3287 3287       Bulgaria 3/29/20 23:08 42.7339 25.4858 346 8 14 324 Bulgaria
3288 3288       Burkina Faso 3/29/20 23:08 12.2383 -1.5616 222 12 23 187 Burkina Faso
3289 3289       Burma 3/29/20 23:08 21.9162 95.956 10 0 0 10 Burma
3290 3290       Cabo Verde 3/29/20 23:08 16.5388 -23.0418 6 1 0 5 Cabo Verde
3291 3291       Cambodia 3/29/20 23:08 11.55 104.9167 103 0 21 82 Cambodia
3292 3292       Cameroon 3/29/20 23:08 3.848 11.5021 139 6 5 128 Cameroon
3293 3293       Central African Republic 3/29/20 23:08 6.6111 20.9394 3 0 0 3 Central African Republic
3294 3294       Chad 3/29/20 23:08 15.4542 18.7322 3 0 0 3 Chad
3295 3295       Chile 3/29/20 23:08 -35.6751 -71.543 2139 7 75 2057 Chile
3296 3296       Colombia 3/29/20 23:08 4.5709 -74.2973 702 10 10 682 Colombia
3297 3297       Congo (Brazzaville) 3/29/20 23:08 -4.2634 15.2832 19 0 0 19 Congo (Brazzaville)
3298 3298       Congo (Kinshasa) 3/29/20 23:08 -4.322447 15.307045 65 6 2 57 Congo (Kinshasa)
3299 3299       Costa Rica 3/29/20 23:08 9.7489 -83.7534 314 2 3 309 Costa Rica
3300 3300       Cote d'Ivoire 3/29/20 23:08 7.54 -5.5471 165 1 4 160 Cote d'Ivoire
3301 3301       Croatia 3/29/20 23:08 45.1 15.2 713 6 52 655 Croatia
3302 3302       Cuba 3/29/20 23:08 21.521757 -77.781167 139 3 4 132 Cuba
3303 3303       Cyprus 3/29/20 23:08 35.1264 33.4299 214 5 15 194 Cyprus
3304 3304       Czechia 3/29/20 23:08 49.8175 15.473 2817 16 11 2790 Czechia
3305 3305       Denmark 3/29/20 23:08 56.2639 9.5018 2395 72 1 2322 Denmark
3306 3306       Diamond Princess 3/29/20 23:08 0.0 0.0 712 10 603 99 Diamond Princess
3307 3307       Djibouti 3/29/20 23:08 11.8251 42.5903 18 0 0 18 Djibouti
3308 3308       Dominica 3/29/20 23:08 15.415 -61.371 11 0 0 11 Dominica
3309 3309       Dominican Republic 3/29/20 23:08 18.7357 -70.1627 859 39 3 817 Dominican Republic
3310 3310       Ecuador 3/29/20 23:08 -1.8312 -78.1834 1924 58 3 1863 Ecuador
3311 3311       Egypt 3/29/20 23:08 26.820553 30.802498 609 40 132 437 Egypt
3312 3312       El Salvador 3/29/20 23:08 13.7942 -88.8965 24 0 0 24 El Salvador
3313 3313       Equatorial Guinea 3/29/20 23:08 1.6508 10.2679 12 0 0 12 Equatorial Guinea
3314 3314       Eritrea 3/29/20 23:08 15.1794 39.7823 12 0 0 12 Eritrea
3315 3315       Estonia 3/29/20 23:08 58.5953 25.0136 679 3 20 656 Estonia
3316 3316       Eswatini 3/29/20 23:08 -26.5225 31.4659 9 0 0 9 Eswatini
3317 3317       Ethiopia 3/29/20 23:08 9.145 40.4897 21 0 1 20 Ethiopia
3318 3318       Fiji 3/29/20 23:08 -17.7134 178.065 5 0 0 5 Fiji
3319 3319       Finland 3/29/20 23:08 61.92411 25.748151 1240 11 10 1219 Finland
3320 3320       France 3/29/20 23:08 46.2276 2.2137 39761 2603 7202 30366 France
3321 3321       Gabon 3/29/20 23:08 -0.8037 11.6094 7 1 0 6 Gabon
3322 3322       Gambia 3/29/20 23:08 13.4432 -15.3101 4 1 0 3 Gambia
3323 3323       Georgia 3/29/20 23:08 42.3154 43.3569 91 0 18 73 Georgia
3324 3324       Germany 3/29/20 23:08 51.165691 10.451526 62095 533 9211 52351 Germany
3325 3325       Ghana 3/29/20 23:08 7.9465 -1.0232 152 5 2 145 Ghana
3326 3326       Greece 3/29/20 23:08 39.0742 21.8243 1156 38 52 1066 Greece
3327 3327       Grenada 3/29/20 23:08 12.1165 -61.679 9 0 0 9 Grenada
3328 3328       Guatemala 3/29/20 23:08 15.7835 -90.2308 34 1 10 23 Guatemala
3329 3329       Guinea 3/29/20 23:08 9.9456 -9.6966 16 0 0 16 Guinea
3330 3330       Guinea-Bissau 3/29/20 23:08 11.8037 -15.1804 2 0 0 2 Guinea-Bissau
3331 3331       Guyana 3/29/20 23:08 4.860416 -58.93018 8 1 0 7 Guyana
3332 3332       Haiti 3/29/20 23:08 18.9712 -72.2852 8 0 1 14 Haiti
3333 3333       Holy See 3/29/20 23:08 41.9029 12.4534 6 0 0 6 Holy See
3334 3334       Honduras 3/29/20 23:08 15.2 -86.2419 110 3 3 104 Honduras
3335 3335       Hungary 3/29/20 23:08 47.1625 19.5033 408 13 34 361 Hungary
3336 3336       Iceland 3/29/20 23:08 64.9631 -19.0208 1020 2 135 883 Iceland
3337 3337       India 3/29/20 23:08 20.593684 78.96288 1024 27 95 902 India
3338 3338       Indonesia 3/29/20 23:08 -0.7893 113.9213 1285 114 64 1107 Indonesia
3339 3339       Iran 3/29/20 23:08 32.427908 53.688046 38309 2640 12391 23278 Iran
3340 3340       Iraq 3/29/20 23:08 33.223191 43.679291 547 42 143 362 Iraq
3341 3341       Ireland 3/29/20 23:08 53.1424 -7.6921 2615 46 5 2564 Ireland
3342 3342       Israel 3/29/20 23:08 31.046051 34.851612 4433 16 105 4100 Israel
3343 3343       Italy 3/29/20 23:08 41.87194 12.56738 97689 10779 13030 73880 Italy
3344 3344       Jamaica 3/29/20 23:08 18.1096 -77.2975 32 1 2 29 Jamaica
3345 3345       Japan 3/29/20 23:08 36.204824 138.252924 1866 54 424 1388 Japan
3346 3346       Jordan 3/29/20 23:08 31.24 36.51 259 3 18 238 Jordan
3347 3347       Kazakhstan 3/29/20 23:08 48.0196 66.9237 284 1 20 263 Kazakhstan
3348 3348       Kenya 3/29/20 23:08 -0.0236 37.9062 42 1 1 40 Kenya
3349 3349       Korea, South 3/29/20 23:08 35.907757 127.766922 9583 152 5033 4398 Korea, South
3350 3350       Kosovo 3/29/20 23:08 42.602636 20.902977 94 1 1 92 Kosovo
3351 3351       Kuwait 3/29/20 23:08 29.31166 47.481766 255 0 67 188 Kuwait
3352 3352       Kyrgyzstan 3/29/20 23:08 41.20438 74.766098 84 0 0 84 Kyrgyzstan
3353 3353       Laos 3/29/20 23:08 19.85627 102.495496 8 0 0 8 Laos
3354 3354       Latvia 3/29/20 23:08 56.8796 24.6032 347 0 1 346 Latvia
3355 3355       Lebanon 3/29/20 23:08 33.8547 35.8623 438 10 30 398 Lebanon
3356 3356       Liberia 3/29/20 23:08 6.428055 -9.429499 3 0 0 3 Liberia
3357 3357       Libya 3/29/20 23:08 26.3351 17.228331 8 0 0 8 Libya
3358 3358       Liechtenstein 3/29/20 23:08 47.14 9.55 56 0 0 56 Liechtenstein
3359 3359       Lithuania 3/29/20 23:08 55.1694 23.8813 378 4 0 452 Lithuania
3360 3360       Luxembourg 3/29/20 23:08 49.8153 6.1296 1950 21 40 1889 Luxembourg
3361 3361       MS Zaandam 3/29/20 23:08 0.0 0.0 2 0 0 2 ,,MS Zaandam
3362 3362       Madagascar 3/29/20 23:08 -18.766947 46.869107 39 0 0 39 Madagascar
3363 3363       Malaysia 3/29/20 23:08 4.210484 101.975766 2470 35 388 2047 Malaysia

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

CREATE TABLE [03-29-2020] (
   [FIPS] INTEGER,
   [Admin2] TEXT,
   [Province_State] TEXT,
   [Country_Region] TEXT,
   [Last_Update] TEXT,
   [Lat] FLOAT,
   [Long_] FLOAT,
   [Confirmed] INTEGER,
   [Deaths] INTEGER,
   [Recovered] INTEGER,
   [Active] INTEGER,
   [Combined_Key] TEXT
);