05-05-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,211 rows sorted by Province_State

✎ View and edit SQL

This data as json, copyable, CSV (advanced)

Suggested facets: Last_Update (date)

Link rowid FIPS Admin2 Province_State ▼ Country_Region Last_Update Lat Long_ Confirmed Deaths Recovered Active Combined_Key
3029 3029       Afghanistan 2020-05-06 02:32:31 33.93911 67.709953 3225 95 421 2708 Afghanistan
3030 3030       Albania 2020-05-06 02:32:31 41.1533 20.1683 820 31 570 219 Albania
3031 3031       Algeria 2020-05-06 02:32:31 28.0339 1.6596 4838 470 2067 2301 Algeria
3032 3032       Andorra 2020-05-06 02:32:31 42.5063 1.5218 751 46 514 191 Andorra
3033 3033       Angola 2020-05-06 02:32:31 -11.2027 17.8739 36 2 11 23 Angola
3034 3034       Antigua and Barbuda 2020-05-06 02:32:31 17.0608 -61.7964 25 3 16 6 Antigua and Barbuda
3035 3035       Argentina 2020-05-06 02:32:31 -38.4161 -63.6167 5020 264 1472 3284 Argentina
3036 3036       Armenia 2020-05-06 02:32:31 40.0691 45.0382 2619 40 1111 1468 Armenia
3037 3037       Austria 2020-05-06 02:32:31 47.5162 14.5501 15650 606 13462 1582 Austria
3038 3038       Azerbaijan 2020-05-06 02:32:31 40.1431 47.5769 2060 26 1508 526 Azerbaijan
3039 3039       Bahamas 2020-05-06 02:32:31 25.025885 -78.035889 89 11 26 52 Bahamas
3040 3040       Bahrain 2020-05-06 02:32:31 26.0275 50.55 3720 8 1762 1950 Bahrain
3041 3041       Bangladesh 2020-05-06 02:32:31 23.685 90.3563 10929 183 1403 9343 Bangladesh
3042 3042       Barbados 2020-05-06 02:32:31 13.1939 -59.5432 82 7 47 28 Barbados
3043 3043       Belarus 2020-05-06 02:32:31 53.7098 27.9534 18350 107 3771 14472 Belarus
3044 3044       Belgium 2020-05-06 02:32:31 50.8333 4.469936 50509 8016 12441 30052 Belgium
3045 3045       Belize 2020-05-06 02:32:31 17.1899 -88.4976 18 2 16 0 Belize
3046 3046       Benin 2020-05-06 02:32:31 9.3077 2.3158 96 2 50 44 Benin
3047 3047       Bhutan 2020-05-06 02:32:31 27.5142 90.4336 7 0 5 2 Bhutan
3048 3048       Bolivia 2020-05-06 02:32:31 -16.2902 -63.5887 1802 86 187 1529 Bolivia
3049 3049       Bosnia and Herzegovina 2020-05-06 02:32:31 43.9159 17.6791 1946 79 911 956 Bosnia and Herzegovina
3050 3050       Botswana 2020-05-06 02:32:31 -22.3285 24.6849 23 1 8 14 Botswana
3051 3051       Brazil 2020-05-06 02:32:31 -14.235 -51.9253 115455 7938 48221 59296 Brazil
3052 3052       Brunei 2020-05-06 02:32:31 4.5353 114.7277 138 1 131 6 Brunei
3053 3053       Bulgaria 2020-05-06 02:32:31 42.7339 25.4858 1704 80 342 1282 Bulgaria
3054 3054       Burkina Faso 2020-05-06 02:32:31 12.2383 -1.5616 688 48 548 92 Burkina Faso
3055 3055       Burma 2020-05-06 02:32:31 21.9162 95.956 161 6 49 106 Burma
3056 3056       Burundi 2020-05-06 02:32:31 -3.3731 29.9189 15 1 7 7 Burundi
3057 3057       Cabo Verde 2020-05-06 02:32:31 16.5388 -23.0418 186 2 37 147 Cabo Verde
3058 3058       Cambodia 2020-05-06 02:32:31 11.55 104.9167 122 0 120 2 Cambodia
3059 3059       Cameroon 2020-05-06 02:32:31 3.8480000000000003 11.5021 2104 64 953 1087 Cameroon
3060 3060       Central African Republic 2020-05-06 02:32:31 6.6111 20.9394 85 0 10 75 Central African Republic
3061 3061       Chad 2020-05-06 02:32:31 15.4542 18.7322 170 17 43 110 Chad
3062 3062       Chile 2020-05-06 02:32:31 -35.6751 -71.543 22016 275 10710 11031 Chile
3063 3063       Colombia 2020-05-06 02:32:31 4.5709 -74.2973 8613 378 2013 6222 Colombia
3064 3064       Comoros 2020-05-06 02:32:31 -11.6455 43.3333 3 0 0 3 Comoros
3065 3065       Congo (Brazzaville) 2020-05-06 02:32:31 -4.2634 15.2832 236 10 26 200 Congo (Brazzaville)
3066 3066       Congo (Kinshasa) 2020-05-06 02:32:31 -4.322447 15.307045 705 34 90 581 Congo (Kinshasa)
3067 3067       Costa Rica 2020-05-06 02:32:31 9.7489 -83.7534 755 6 413 336 Costa Rica
3068 3068       Cote d'Ivoire 2020-05-06 02:32:31 7.54 -5.5471 1464 18 701 745 Cote d'Ivoire
3069 3069       Croatia 2020-05-06 02:32:31 45.1 15.2 2112 83 1560 469 Croatia
3070 3070       Cuba 2020-05-06 02:32:31 21.521757 -77.78116700000002 1685 69 954 662 Cuba
3071 3071       Cyprus 2020-05-06 02:32:31 35.1264 33.4299 878 15 296 567 Cyprus
3072 3072       Czechia 2020-05-06 02:32:31 49.8175 15.472999999999999 7896 257 4006 3633 Czechia
3073 3073       Denmark 2020-05-06 02:32:31 56.2639 9.5018 9821 503 7296 2022 Denmark
3074 3074       Diamond Princess 2020-05-06 02:32:31     712 13 645 54 Diamond Princess
3075 3075       Djibouti 2020-05-06 02:32:31 11.8251 42.5903 1120 2 745 373 Djibouti
3076 3076       Dominica 2020-05-06 02:32:31 15.415 -61.371 16 0 14 2 Dominica
3077 3077       Dominican Republic 2020-05-06 02:32:31 18.7357 -70.1627 8480 354 1905 6221 Dominican Republic
3078 3078       Ecuador 2020-05-06 02:32:31 -1.8312 -78.1834 31881 1569 3433 26879 Ecuador
3079 3079       Egypt 2020-05-06 02:32:31 26.820553000000004 30.802497999999996 7201 452 1730 5019 Egypt
3080 3080       El Salvador 2020-05-06 02:32:31 13.7942 -88.8965 587 14 205 368 El Salvador
3081 3081       Equatorial Guinea 2020-05-06 02:32:31 1.6508 10.2679 315 3 13 299 Equatorial Guinea
3082 3082       Eritrea 2020-05-06 02:32:31 15.1794 39.7823 39 0 30 9 Eritrea
3083 3083       Estonia 2020-05-06 02:32:31 58.5953 25.0136 1711 55 261 1395 Estonia
3084 3084       Eswatini 2020-05-06 02:32:31 -26.5225 31.4659 119 1 12 106 Eswatini
3085 3085       Ethiopia 2020-05-06 02:32:31 9.145 40.4897 145 4 91 50 Ethiopia
3086 3086       Fiji 2020-05-06 02:32:31 -17.7134 178.065 18 0 14 4 Fiji
3087 3087       Finland 2020-05-06 02:32:31 61.92411 25.748151 5412 246 3500 1666 Finland
3088 3088       France 2020-05-06 02:32:31 46.2276 2.2137 170467 25498 51803 91634 France
3089 3089       Gabon 2020-05-06 02:32:31 -0.8037 11.6094 397 6 93 298 Gabon
3090 3090       Gambia 2020-05-06 02:32:31 13.4432 -15.3101 17 1 9 7 Gambia
3091 3091       Georgia 2020-05-06 02:32:31 42.3154 43.3569 604 9 240 355 Georgia
3092 3092       Germany 2020-05-06 02:32:31 51.165690999999995 10.451526 167007 6993 135100 24914 Germany
3093 3093       Ghana 2020-05-06 02:32:31 7.9465 -1.0232 2719 18 294 2407 Ghana
3094 3094       Greece 2020-05-06 02:32:31 39.0742 21.8243 2642 146 1374 1122 Greece
3095 3095       Grenada 2020-05-06 02:32:31 12.1165 -61.678999999999995 21 0 13 8 Grenada
3096 3096       Guatemala 2020-05-06 02:32:31 15.7835 -90.2308 763 19 79 665 Guatemala
3097 3097       Guinea 2020-05-06 02:32:31 9.9456 -9.6966 1811 10 498 1303 Guinea
3098 3098       Guinea-Bissau 2020-05-06 02:32:31 11.8037 -15.1804 413 1 19 393 Guinea-Bissau
3099 3099       Guyana 2020-05-06 02:32:31 4.860416000000002 -58.93018000000001 93 10 27 56 Guyana
3100 3100       Haiti 2020-05-06 02:32:31 18.9712 -72.2852 88 9 10 79 Haiti
3101 3101       Holy See 2020-05-06 02:32:31 41.9029 12.4534 11 0 2 9 Holy See
3102 3102       Honduras 2020-05-06 02:32:31 15.2 -86.2419 1270 93 122 1055 Honduras
3103 3103       Hungary 2020-05-06 02:32:31 47.1625 19.5033 3065 363 709 1993 Hungary
3104 3104       Iceland 2020-05-06 02:32:31 64.9631 -19.0208 1799 10 1733 56 Iceland
3105 3105       India 2020-05-06 02:32:31 20.593684 78.96288 49400 1693 14142 33565 India
3106 3106       Indonesia 2020-05-06 02:32:31 -0.7893 113.9213 12071 872 2197 9002 Indonesia
3107 3107       Iran 2020-05-06 02:32:31 32.427908 53.68804599999999 99970 6340 80475 13155 Iran
3108 3108       Iraq 2020-05-06 02:32:31 33.223191 43.679291 2431 102 1571 758 Iraq
3109 3109       Ireland 2020-05-06 02:32:31 53.1424 -7.6921 21983 1339 13386 7258 Ireland
3110 3110       Israel 2020-05-06 02:32:31 31.046051000000002 34.851612 16181 240 10561 5586 Israel
3111 3111       Italy 2020-05-06 02:32:31 41.87194 12.56738 213013 29315 85231 98467 Italy
3112 3112       Jamaica 2020-05-06 02:32:31 18.1096 -77.2975 473 9 56 408 Jamaica
3113 3113       Japan 2020-05-06 02:32:31 36.204824 138.252924 15253 556 4496 10201 Japan
3114 3114       Jordan 2020-05-06 02:32:31 31.24 36.51 471 9 375 87 Jordan
3115 3115       Kazakhstan 2020-05-06 02:32:31 48.0196 66.9237 4205 29 1279 2897 Kazakhstan
3116 3116       Kenya 2020-05-06 02:32:31 -0.0236 37.9062 535 24 182 329 Kenya
3117 3117       Korea, South 2020-05-06 02:32:31 35.90775700000001 127.766922 10806 255 9333 1218 Korea, South
3118 3118       Kosovo 2020-05-06 02:32:31 42.602636 20.902977 856 26 490 340 Kosovo
3119 3119       Kuwait 2020-05-06 02:32:31 29.311659999999996 47.481766 5804 40 2032 3732 Kuwait
3120 3120       Kyrgyzstan 2020-05-06 02:32:31 41.20438 74.766098 843 11 600 232 Kyrgyzstan
3121 3121       Laos 2020-05-06 02:32:31 19.856270000000002 102.495496 19 0 9 10 Laos
3122 3122       Latvia 2020-05-06 02:32:31 56.8796 24.6032 896 17 348 531 Latvia
3123 3123       Lebanon 2020-05-06 02:32:31 33.8547 35.8623 741 25 206 510 Lebanon
3124 3124       Liberia 2020-05-06 02:32:31 6.4280550000000005 -9.429499 170 20 58 92 Liberia
3125 3125       Libya 2020-05-06 02:32:31 26.3351 17.228331 63 3 23 37 Libya
3126 3126       Liechtenstein 2020-05-06 02:32:31 47.14 9.55 82 1 55 26 Liechtenstein
3127 3127       Lithuania 2020-05-06 02:32:31 55.1694 23.8813 1410 33 761 699 Lithuania
3128 3128       Luxembourg 2020-05-06 02:32:31 49.8153 6.1296 3840 96 3412 332 Luxembourg

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

CREATE TABLE [05-05-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
);