05-04-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,203 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
3021 3021       Afghanistan 2020-05-05 02:32:34 33.93911 67.709953 2895 90 397 2407 Afghanistan
3022 3022       Albania 2020-05-05 02:32:34 41.1533 20.1683 803 31 543 229 Albania
3023 3023       Algeria 2020-05-05 02:32:34 28.0339 1.6596 4648 465 1998 2185 Algeria
3024 3024       Andorra 2020-05-05 02:32:34 42.5063 1.5218 750 45 499 206 Andorra
3025 3025       Angola 2020-05-05 02:32:34 -11.2027 17.8739 35 2 11 22 Angola
3026 3026       Antigua and Barbuda 2020-05-05 02:32:34 17.0608 -61.7964 25 3 15 7 Antigua and Barbuda
3027 3027       Argentina 2020-05-05 02:32:34 -38.4161 -63.6167 4887 260 1442 3185 Argentina
3028 3028       Armenia 2020-05-05 02:32:34 40.0691 45.0382 2507 39 1071 1397 Armenia
3029 3029       Austria 2020-05-05 02:32:34 47.5162 14.5501 15621 600 13316 1705 Austria
3030 3030       Azerbaijan 2020-05-05 02:32:34 40.1431 47.5769 1984 26 1480 478 Azerbaijan
3031 3031       Bahamas 2020-05-05 02:32:34 25.025885 -78.035889 83 11 25 47 Bahamas
3032 3032       Bahrain 2020-05-05 02:32:34 26.0275 50.55 3533 8 1744 1781 Bahrain
3033 3033       Bangladesh 2020-05-05 02:32:34 23.685 90.3563 10143 182 1209 8752 Bangladesh
3034 3034       Barbados 2020-05-05 02:32:34 13.1939 -59.5432 82 7 46 29 Barbados
3035 3035       Belarus 2020-05-05 02:32:34 53.7098 27.9534 17489 103 3259 14127 Belarus
3036 3036       Belgium 2020-05-05 02:32:34 50.8333 4.469936 50267 7924 12378 29965 Belgium
3037 3037       Belize 2020-05-05 02:32:34 17.1899 -88.4976 18 2 14 2 Belize
3038 3038       Benin 2020-05-05 02:32:34 9.3077 2.3158 96 2 50 44 Benin
3039 3039       Bhutan 2020-05-05 02:32:34 27.5142 90.4336 7 0 5 2 Bhutan
3040 3040       Bolivia 2020-05-05 02:32:34 -16.2902 -63.5887 1681 82 174 1425 Bolivia
3041 3041       Bosnia and Herzegovina 2020-05-05 02:32:34 43.9159 17.6791 1926 78 855 993 Bosnia and Herzegovina
3042 3042       Botswana 2020-05-05 02:32:34 -22.3285 24.6849 23 1 8 14 Botswana
3043 3043       Brazil 2020-05-05 02:32:34 -14.235 -51.9253 108620 7367 45815 55438 Brazil
3044 3044       Brunei 2020-05-05 02:32:34 4.5353 114.7277 138 1 130 7 Brunei
3045 3045       Bulgaria 2020-05-05 02:32:34 42.7339 25.4858 1652 78 321 1253 Bulgaria
3046 3046       Burkina Faso 2020-05-05 02:32:34 12.2383 -1.5616 672 46 545 81 Burkina Faso
3047 3047       Burma 2020-05-05 02:32:34 21.9162 95.956 161 6 49 106 Burma
3048 3048       Burundi 2020-05-05 02:32:34 -3.3731 29.9189 15 1 7 7 Burundi
3049 3049       Cabo Verde 2020-05-05 02:32:34 16.5388 -23.0418 175 2 37 136 Cabo Verde
3050 3050       Cambodia 2020-05-05 02:32:34 11.55 104.9167 122 0 120 2 Cambodia
3051 3051       Cameroon 2020-05-05 02:32:34 3.8480000000000003 11.5021 2104 64 953 1087 Cameroon
3052 3052       Central African Republic 2020-05-05 02:32:34 6.6111 20.9394 85 0 10 75 Central African Republic
3053 3053       Chad 2020-05-05 02:32:34 15.4542 18.7322 117 10 39 68 Chad
3054 3054       Chile 2020-05-05 02:32:34 -35.6751 -71.543 20643 270 10415 9958 Chile
3055 3055       Colombia 2020-05-05 02:32:34 4.5709 -74.2973 7973 358 1807 5808 Colombia
3056 3056       Comoros 2020-05-05 02:32:34 -11.6455 43.3333 3 0 0 3 Comoros
3057 3057       Congo (Brazzaville) 2020-05-05 02:32:34 -4.2634 15.2832 236 10 26 200 Congo (Brazzaville)
3058 3058       Congo (Kinshasa) 2020-05-05 02:32:34 -4.322447 15.307045 682 34 80 568 Congo (Kinshasa)
3059 3059       Costa Rica 2020-05-05 02:32:34 9.7489 -83.7534 742 6 399 337 Costa Rica
3060 3060       Cote d'Ivoire 2020-05-05 02:32:34 7.54 -5.5471 1432 17 693 722 Cote d'Ivoire
3061 3061       Croatia 2020-05-05 02:32:34 45.1 15.2 2101 80 1522 499 Croatia
3062 3062       Cuba 2020-05-05 02:32:34 21.521757 -77.78116700000002 1668 69 876 723 Cuba
3063 3063       Cyprus 2020-05-05 02:32:34 35.1264 33.4299 874 15 296 563 Cyprus
3064 3064       Czechia 2020-05-05 02:32:34 49.8175 15.472999999999999 7819 252 3807 3760 Czechia
3065 3065       Denmark 2020-05-05 02:32:34 56.2639 9.5018 9670 493 7088 2089 Denmark
3066 3066       Diamond Princess 2020-05-05 02:32:34     712 13 645 54 Diamond Princess
3067 3067       Djibouti 2020-05-05 02:32:34 11.8251 42.5903 1116 2 713 401 Djibouti
3068 3068       Dominica 2020-05-05 02:32:34 15.415 -61.371 16 0 13 3 Dominica
3069 3069       Dominican Republic 2020-05-05 02:32:34 18.7357 -70.1627 8235 346 1771 6118 Dominican Republic
3070 3070       Ecuador 2020-05-05 02:32:34 -1.8312 -78.1834 31881 1569 3433 26879 Ecuador
3071 3071       Egypt 2020-05-05 02:32:34 26.820553000000004 30.802497999999996 6813 436 1632 4745 Egypt
3072 3072       El Salvador 2020-05-05 02:32:34 13.7942 -88.8965 555 13 180 362 El Salvador
3073 3073       Equatorial Guinea 2020-05-05 02:32:34 1.6508 10.2679 315 3 13 299 Equatorial Guinea
3074 3074       Eritrea 2020-05-05 02:32:34 15.1794 39.7823 39 0 26 13 Eritrea
3075 3075       Estonia 2020-05-05 02:32:34 58.5953 25.0136 1703 55 259 1389 Estonia
3076 3076       Eswatini 2020-05-05 02:32:34 -26.5225 31.4659 116 1 12 103 Eswatini
3077 3077       Ethiopia 2020-05-05 02:32:34 9.145 40.4897 140 3 75 62 Ethiopia
3078 3078       Fiji 2020-05-05 02:32:34 -17.7134 178.065 18 0 14 4 Fiji
3079 3079       Finland 2020-05-05 02:32:34 61.92411 25.748151 5327 240 3500 1587 Finland
3080 3080       France 2020-05-05 02:32:34 46.2276 2.2137 169405 25168 50438 92280 France
3081 3081       Gabon 2020-05-05 02:32:34 -0.8037 11.6094 367 6 93 268 Gabon
3082 3082       Gambia 2020-05-05 02:32:34 13.4432 -15.3101 17 1 9 7 Gambia
3083 3083       Georgia 2020-05-05 02:32:34 42.3154 43.3569 593 9 223 361 Georgia
3084 3084       Germany 2020-05-05 02:32:34 51.165690999999995 10.451526 166152 6993 132700 26459 Germany
3085 3085       Ghana 2020-05-05 02:32:34 7.9465 -1.0232 2719 18 294 2407 Ghana
3086 3086       Greece 2020-05-05 02:32:34 39.0742 21.8243 2632 146 1374 1112 Greece
3087 3087       Grenada 2020-05-05 02:32:34 12.1165 -61.678999999999995 21 0 13 8 Grenada
3088 3088       Guatemala 2020-05-05 02:32:34 15.7835 -90.2308 730 19 79 632 Guatemala
3089 3089       Guinea 2020-05-05 02:32:34 9.9456 -9.6966 1710 9 450 1251 Guinea
3090 3090       Guinea-Bissau 2020-05-05 02:32:34 11.8037 -15.1804 413 1 19 393 Guinea-Bissau
3091 3091       Guyana 2020-05-05 02:32:34 4.860416000000002 -58.93018000000001 92 9 27 56 Guyana
3092 3092       Haiti 2020-05-05 02:32:34 18.9712 -72.2852 85 8 10 79 Haiti
3093 3093       Holy See 2020-05-05 02:32:34 41.9029 12.4534 11 0 2 9 Holy See
3094 3094       Honduras 2020-05-05 02:32:34 15.2 -86.2419 1178 83 122 973 Honduras
3095 3095       Hungary 2020-05-05 02:32:34 47.1625 19.5033 3035 351 630 2054 Hungary
3096 3096       Iceland 2020-05-05 02:32:34 64.9631 -19.0208 1799 10 1723 66 Iceland
3097 3097       India 2020-05-05 02:32:34 20.593684 78.96288 46437 1566 12847 32024 India
3098 3098       Indonesia 2020-05-05 02:32:34 -0.7893 113.9213 11587 864 1954 8769 Indonesia
3099 3099       Iran 2020-05-05 02:32:34 32.427908 53.68804599999999 98647 6277 79379 12991 Iran
3100 3100       Iraq 2020-05-05 02:32:34 33.223191 43.679291 2346 98 1544 704 Iraq
3101 3101       Ireland 2020-05-05 02:32:34 53.1424 -7.6921 21772 1319 13386 7067 Ireland
3102 3102       Israel 2020-05-05 02:32:34 31.046051000000002 34.851612 16149 238 10233 5947 Israel
3103 3103       Italy 2020-05-05 02:32:34 41.87194 12.56738 211938 29079 82879 99980 Italy
3104 3104       Jamaica 2020-05-05 02:32:34 18.1096 -77.2975 471 9 38 424 Jamaica
3105 3105       Japan 2020-05-05 02:32:34 36.204824 138.252924 15078 536 4156 10386 Japan
3106 3106       Jordan 2020-05-05 02:32:34 31.24 36.51 465 9 370 86 Jordan
3107 3107       Kazakhstan 2020-05-05 02:32:34 48.0196 66.9237 4049 29 1173 2847 Kazakhstan
3108 3108       Kenya 2020-05-05 02:32:34 -0.0236 37.9062 490 24 173 293 Kenya
3109 3109       Korea, South 2020-05-05 02:32:34 35.90775700000001 127.766922 10804 254 9283 1267 Korea, South
3110 3110       Kosovo 2020-05-05 02:32:34 42.602636 20.902977 855 26 403 426 Kosovo
3111 3111       Kuwait 2020-05-05 02:32:34 29.311659999999996 47.481766 5278 40 1947 3291 Kuwait
3112 3112       Kyrgyzstan 2020-05-05 02:32:34 41.20438 74.766098 830 10 575 245 Kyrgyzstan
3113 3113       Laos 2020-05-05 02:32:34 19.856270000000002 102.495496 19 0 9 10 Laos
3114 3114       Latvia 2020-05-05 02:32:34 56.8796 24.6032 896 16 348 532 Latvia
3115 3115       Lebanon 2020-05-05 02:32:34 33.8547 35.8623 740 25 200 515 Lebanon
3116 3116       Liberia 2020-05-05 02:32:34 6.4280550000000005 -9.429499 166 18 58 90 Liberia
3117 3117       Libya 2020-05-05 02:32:34 26.3351 17.228331 63 3 23 37 Libya
3118 3118       Liechtenstein 2020-05-05 02:32:34 47.14 9.55 82 1 55 26 Liechtenstein
3119 3119       Lithuania 2020-05-05 02:32:34 55.1694 23.8813 1407 33 715 735 Lithuania
3120 3120       Luxembourg 2020-05-05 02:32:34 49.8153 6.1296 3828 96 3405 327 Luxembourg

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

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