04-23-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,122 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
2934 2934       Afghanistan 2020-04-24 03:30:31 33.93911 67.709953 1236 40 179 1058 Afghanistan
2935 2935       Albania 2020-04-24 03:30:31 41.1533 20.1683 663 27 385 251 Albania
2936 2936       Algeria 2020-04-24 03:30:31 28.0339 1.6596 3007 407 1355 1245 Algeria
2937 2937       Andorra 2020-04-24 03:30:31 42.5063 1.5218 723 37 333 353 Andorra
2938 2938       Angola 2020-04-24 03:30:31 -11.2027 17.8739 25 2 6 17 Angola
2939 2939       Antigua and Barbuda 2020-04-24 03:30:31 17.0608 -61.7964 24 3 10 11 Antigua and Barbuda
2940 2940       Argentina 2020-04-24 03:30:31 -38.4161 -63.6167 3435 165 919 2351 Argentina
2941 2941       Armenia 2020-04-24 03:30:31 40.0691 45.0382 1523 24 659 840 Armenia
2942 2942       Austria 2020-04-24 03:30:31 47.5162 14.5501 15002 522 11694 2786 Austria
2943 2943       Azerbaijan 2020-04-24 03:30:31 40.1431 47.5769 1548 20 948 580 Azerbaijan
2944 2944       Bahamas 2020-04-24 03:30:31 25.025885 -78.035889 72 11 14 47 Bahamas
2945 2945       Bahrain 2020-04-24 03:30:31 26.0275 50.55 2217 8 1082 1127 Bahrain
2946 2946       Bangladesh 2020-04-24 03:30:31 23.685 90.3563 4186 127 108 3951 Bangladesh
2947 2947       Barbados 2020-04-24 03:30:31 13.1939 -59.5432 76 6 30 40 Barbados
2948 2948       Belarus 2020-04-24 03:30:31 53.7098 27.9534 8022 60 938 7024 Belarus
2949 2949       Belgium 2020-04-24 03:30:31 50.8333 4.469936 42797 6490 9800 26507 Belgium
2950 2950       Belize 2020-04-24 03:30:31 17.1899 -88.4976 18 2 5 11 Belize
2951 2951       Benin 2020-04-24 03:30:31 9.3077 2.3158 54 1 27 26 Benin
2952 2952       Bhutan 2020-04-24 03:30:31 27.5142 90.4336 7 0 3 4 Bhutan
2953 2953       Bolivia 2020-04-24 03:30:31 -16.2902 -63.5887 703 43 44 616 Bolivia
2954 2954       Bosnia and Herzegovina 2020-04-24 03:30:31 43.9159 17.6791 1413 54 485 874 Bosnia and Herzegovina
2955 2955       Botswana 2020-04-24 03:30:31 -22.3285 24.6849 22 1 0 21 Botswana
2956 2956       Brazil 2020-04-24 03:30:31 -14.235 -51.9253 50036 3331 26573 20132 Brazil
2957 2957       Brunei 2020-04-24 03:30:31 4.5353 114.7277 138 1 119 18 Brunei
2958 2958       Bulgaria 2020-04-24 03:30:31 42.7339 25.4858 1097 52 190 855 Bulgaria
2959 2959       Burkina Faso 2020-04-24 03:30:31 12.2383 -1.5616 616 41 410 165 Burkina Faso
2960 2960       Burma 2020-04-24 03:30:31 21.9162 95.956 139 5 9 125 Burma
2961 2961       Burundi 2020-04-24 03:30:31 -3.3731 29.9189 11 1 4 6 Burundi
2962 2962       Cabo Verde 2020-04-24 03:30:31 16.5388 -23.0418 82 1 1 80 Cabo Verde
2963 2963       Cambodia 2020-04-24 03:30:31 11.55 104.9167 122 0 110 12 Cambodia
2964 2964       Cameroon 2020-04-24 03:30:31 3.8480000000000003 11.5021 1334 43 668 623 Cameroon
2965 2965       Central African Republic 2020-04-24 03:30:31 6.6111 20.9394 16 0 10 6 Central African Republic
2966 2966       Chad 2020-04-24 03:30:31 15.4542 18.7322 33 0 8 25 Chad
2967 2967       Chile 2020-04-24 03:30:31 -35.6751 -71.543 11812 168 5804 5840 Chile
2968 2968       Colombia 2020-04-24 03:30:31 4.5709 -74.2973 4561 215 927 3419 Colombia
2969 2969       Congo (Brazzaville) 2020-04-24 03:30:31 -4.2634 15.2832 186 6 16 164 Congo (Brazzaville)
2970 2970       Congo (Kinshasa) 2020-04-24 03:30:31 -4.322447 15.307045 377 25 47 305 Congo (Kinshasa)
2971 2971       Costa Rica 2020-04-24 03:30:31 9.7489 -83.7534 686 6 196 484 Costa Rica
2972 2972       Cote d'Ivoire 2020-04-24 03:30:31 7.54 -5.5471 1004 14 359 631 Cote d'Ivoire
2973 2973       Croatia 2020-04-24 03:30:31 45.1 15.2 1981 50 883 1048 Croatia
2974 2974       Cuba 2020-04-24 03:30:31 21.521757 -77.78116700000002 1235 43 365 827 Cuba
2975 2975       Cyprus 2020-04-24 03:30:31 35.1264 33.4299 795 13 98 684 Cyprus
2976 2976       Czechia 2020-04-24 03:30:31 49.8175 15.472999999999999 7187 210 2152 4825 Czechia
2977 2977       Denmark 2020-04-24 03:30:31 56.2639 9.5018 8073 394 5384 2295 Denmark
2978 2978       Diamond Princess 2020-04-24 03:30:31     712 13 645 54 Diamond Princess
2979 2979       Djibouti 2020-04-24 03:30:31 11.8251 42.5903 986 2 252 732 Djibouti
2980 2980       Dominica 2020-04-24 03:30:31 15.415 -61.371 16 0 9 7 Dominica
2981 2981       Dominican Republic 2020-04-24 03:30:31 18.7357 -70.1627 5543 265 581 4697 Dominican Republic
2982 2982       Ecuador 2020-04-24 03:30:31 -1.8312 -78.1834 11183 560 1328 9295 Ecuador
2983 2983       Egypt 2020-04-24 03:30:31 26.820553000000004 30.802497999999996 3891 287 1004 2600 Egypt
2984 2984       El Salvador 2020-04-24 03:30:31 13.7942 -88.8965 250 8 67 175 El Salvador
2985 2985       Equatorial Guinea 2020-04-24 03:30:31 1.6508 10.2679 84 1 7 76 Equatorial Guinea
2986 2986       Eritrea 2020-04-24 03:30:31 15.1794 39.7823 39 0 6 33 Eritrea
2987 2987       Estonia 2020-04-24 03:30:31 58.5953 25.0136 1592 45 192 1355 Estonia
2988 2988       Eswatini 2020-04-24 03:30:31 -26.5225 31.4659 31 1 8 22 Eswatini
2989 2989       Ethiopia 2020-04-24 03:30:31 9.145 40.4897 116 3 21 92 Ethiopia
2990 2990       Fiji 2020-04-24 03:30:31 -17.7134 178.065 18 0 8 10 Fiji
2991 2991       Finland 2020-04-24 03:30:31 61.92411 25.748151 4284 172 2000 2112 Finland
2992 2992       France 2020-04-24 03:30:31 46.2276 2.2137 157038 21827 42088 94239 France
2993 2993       Gabon 2020-04-24 03:30:31 -0.8037 11.6094 167 2 24 141 Gabon
2994 2994       Gambia 2020-04-24 03:30:31 13.4432 -15.3101 10 1 2 7 Gambia
2995 2995       Georgia 2020-04-24 03:30:31 42.3154 43.3569 425 5 111 309 Georgia
2996 2996       Germany 2020-04-24 03:30:31 51.165690999999995 10.451526 153129 5575 103300 44254 Germany
2997 2997       Ghana 2020-04-24 03:30:31 7.9465 -1.0232 1154 9 99 1046 Ghana
2998 2998       Greece 2020-04-24 03:30:31 39.0742 21.8243 2463 125 577 1761 Greece
2999 2999       Grenada 2020-04-24 03:30:31 12.1165 -61.678999999999995 15 0 6 9 Grenada
3000 3000       Guatemala 2020-04-24 03:30:31 15.7835 -90.2308 384 11 30 343 Guatemala
3001 3001       Guinea 2020-04-24 03:30:31 9.9456 -9.6966 862 6 170 686 Guinea
3002 3002       Guinea-Bissau 2020-04-24 03:30:31 11.8037 -15.1804 50 0 3 47 Guinea-Bissau
3003 3003       Guyana 2020-04-24 03:30:31 4.860416000000002 -58.93018000000001 70 7 9 54 Guyana
3004 3004       Haiti 2020-04-24 03:30:31 18.9712 -72.2852 58 4 2 65 Haiti
3005 3005       Holy See 2020-04-24 03:30:31 41.9029 12.4534 9 0 2 7 Holy See
3006 3006       Honduras 2020-04-24 03:30:31 15.2 -86.2419 519 47 31 441 Honduras
3007 3007       Hungary 2020-04-24 03:30:31 47.1625 19.5033 2284 239 390 1655 Hungary
3008 3008       Iceland 2020-04-24 03:30:31 64.9631 -19.0208 1789 10 1509 270 Iceland
3009 3009       India 2020-04-24 03:30:31 20.593684 78.96288 23077 721 5012 17344 India
3010 3010       Indonesia 2020-04-24 03:30:31 -0.7893 113.9213 7775 647 960 6168 Indonesia
3011 3011       Iran 2020-04-24 03:30:31 32.427908 53.68804599999999 87026 5481 64843 16702 Iran
3012 3012       Iraq 2020-04-24 03:30:31 33.223191 43.679291 1677 83 1171 423 Iraq
3013 3013       Ireland 2020-04-24 03:30:31 53.1424 -7.6921 17607 794 9233 7580 Ireland
3014 3014       Israel 2020-04-24 03:30:31 31.046051000000002 34.851612 14895 196 5866 9000 Israel
3015 3015       Italy 2020-04-24 03:30:31 41.87194 12.56738 189973 25549 57576 106848 Italy
3016 3016       Jamaica 2020-04-24 03:30:31 18.1096 -77.2975 257 6 28 223 Jamaica
3017 3017       Japan 2020-04-24 03:30:31 36.204824 138.252924 12368 328 1494 10546 Japan
3018 3018       Jordan 2020-04-24 03:30:31 31.24 36.51 437 7 318 112 Jordan
3019 3019       Kazakhstan 2020-04-24 03:30:31 48.0196 66.9237 2289 20 560 1709 Kazakhstan
3020 3020       Kenya 2020-04-24 03:30:31 -0.0236 37.9062 320 14 89 217 Kenya
3021 3021       Korea, South 2020-04-24 03:30:31 35.90775700000001 127.766922 10708 240 8501 1967 Korea, South
3022 3022       Kosovo 2020-04-24 03:30:31 42.602636 20.902977 510 12 93 405 Kosovo
3023 3023       Kuwait 2020-04-24 03:30:31 29.311659999999996 47.481766 2399 14 498 1887 Kuwait
3024 3024       Kyrgyzstan 2020-04-24 03:30:31 41.20438 74.766098 631 8 302 321 Kyrgyzstan
3025 3025       Laos 2020-04-24 03:30:31 19.856270000000002 102.495496 19 0 4 15 Laos
3026 3026       Latvia 2020-04-24 03:30:31 56.8796 24.6032 778 11 133 634 Latvia
3027 3027       Lebanon 2020-04-24 03:30:31 33.8547 35.8623 688 22 140 526 Lebanon
3028 3028       Liberia 2020-04-24 03:30:31 6.4280550000000005 -9.429499 101 8 20 73 Liberia
3029 3029       Libya 2020-04-24 03:30:31 26.3351 17.228331 60 2 15 43 Libya
3030 3030       Liechtenstein 2020-04-24 03:30:31 47.14 9.55 81 1 55 25 Liechtenstein
3031 3031       Lithuania 2020-04-24 03:30:31 55.1694 23.8813 1272 27 236 959 Lithuania
3032 3032       Luxembourg 2020-04-24 03:30:31 49.8153 6.1296 3665 83 728 2854 Luxembourg
3033 3033       MS Zaandam 2020-04-24 03:30:31     9 2 0 7 MS Zaandam

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

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