04-22-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,101 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
2921 2921       Afghanistan 2020-04-22 23:30:32 33.93911 67.709953 1177 40 166 970 Afghanistan
2922 2922       Albania 2020-04-22 23:30:32 41.1533 20.1683 634 27 356 251 Albania
2923 2923       Algeria 2020-04-22 23:30:32 28.0339 1.6596 2910 402 1204 1304 Algeria
2924 2924       Andorra 2020-04-22 23:30:32 42.5063 1.5218 723 37 309 377 Andorra
2925 2925       Angola 2020-04-22 23:30:32 -11.2027 17.8739 25 2 6 17 Angola
2926 2926       Antigua and Barbuda 2020-04-22 23:30:32 17.0608 -61.7964 24 3 10 11 Antigua and Barbuda
2927 2927       Argentina 2020-04-22 23:30:32 -38.4161 -63.6167 3144 152 872 2120 Argentina
2928 2928       Armenia 2020-04-22 23:30:32 40.0691 45.0382 1473 24 633 816 Armenia
2929 2929       Austria 2020-04-22 23:30:32 47.5162 14.5501 14925 510 11328 3087 Austria
2930 2930       Azerbaijan 2020-04-22 23:30:32 40.1431 47.5769 1518 20 907 591 Azerbaijan
2931 2931       Bahamas 2020-04-22 23:30:32 25.025885 -78.035889 65 9 12 44 Bahamas
2932 2932       Bahrain 2020-04-22 23:30:32 26.0275 50.55 2027 7 1026 994 Bahrain
2933 2933       Bangladesh 2020-04-22 23:30:32 23.685 90.3563 3772 120 92 3560 Bangladesh
2934 2934       Barbados 2020-04-22 23:30:32 13.1939 -59.5432 75 5 25 45 Barbados
2935 2935       Belarus 2020-04-22 23:30:32 53.7098 27.9534 7281 58 769 6454 Belarus
2936 2936       Belgium 2020-04-22 23:30:32 50.8333 4.469936 41889 6262 9433 26194 Belgium
2937 2937       Belize 2020-04-22 23:30:32 17.1899 -88.4976 18 2 2 14 Belize
2938 2938       Benin 2020-04-22 23:30:32 9.3077 2.3158 54 1 27 26 Benin
2939 2939       Bhutan 2020-04-22 23:30:32 27.5142 90.4336 6 0 2 4 Bhutan
2940 2940       Bolivia 2020-04-22 23:30:32 -16.2902 -63.5887 609 37 44 528 Bolivia
2941 2941       Bosnia and Herzegovina 2020-04-22 23:30:32 43.9159 17.6791 1368 53 460 855 Bosnia and Herzegovina
2942 2942       Botswana 2020-04-22 23:30:32 -22.3285 24.6849 22 1 0 21 Botswana
2943 2943       Brazil 2020-04-22 23:30:32 -14.235 -51.9253 45757 2906 25318 17533 Brazil
2944 2944       Brunei 2020-04-22 23:30:32 4.5353 114.7277 138 1 117 20 Brunei
2945 2945       Bulgaria 2020-04-22 23:30:32 42.7339 25.4858 1024 49 174 801 Bulgaria
2946 2946       Burkina Faso 2020-04-22 23:30:32 12.2383 -1.5616 609 39 389 181 Burkina Faso
2947 2947       Burma 2020-04-22 23:30:32 21.9162 95.956 123 5 7 111 Burma
2948 2948       Burundi 2020-04-22 23:30:32 -3.3731 29.9189 11 1 4 6 Burundi
2949 2949       Cabo Verde 2020-04-22 23:30:32 16.5388 -23.0418 73 1 1 71 Cabo Verde
2950 2950       Cambodia 2020-04-22 23:30:32 11.55 104.9167 122 0 110 12 Cambodia
2951 2951       Cameroon 2020-04-22 23:30:32 3.8480000000000003 11.5021 1163 43 397 723 Cameroon
2952 2952       Central African Republic 2020-04-22 23:30:32 6.6111 20.9394 14 0 10 4 Central African Republic
2953 2953       Chad 2020-04-22 23:30:32 15.4542 18.7322 33 0 8 25 Chad
2954 2954       Chile 2020-04-22 23:30:32 -35.6751 -71.543 11296 160 5386 5750 Chile
2955 2955       Colombia 2020-04-22 23:30:32 4.5709 -74.2973 4356 206 870 3280 Colombia
2956 2956       Congo (Brazzaville) 2020-04-22 23:30:32 -4.2634 15.2832 186 6 16 164 Congo (Brazzaville)
2957 2957       Congo (Kinshasa) 2020-04-22 23:30:32 -4.322447 15.307045 359 25 45 289 Congo (Kinshasa)
2958 2958       Costa Rica 2020-04-22 23:30:32 9.7489 -83.7534 681 6 180 495 Costa Rica
2959 2959       Cote d'Ivoire 2020-04-22 23:30:32 7.54 -5.5471 952 14 310 628 Cote d'Ivoire
2960 2960       Croatia 2020-04-22 23:30:32 45.1 15.2 1950 48 869 1033 Croatia
2961 2961       Cuba 2020-04-22 23:30:32 21.521757 -77.78116700000002 1189 40 341 808 Cuba
2962 2962       Cyprus 2020-04-22 23:30:32 35.1264 33.4299 790 13 98 679 Cyprus
2963 2963       Czechia 2020-04-22 23:30:32 49.8175 15.472999999999999 7132 208 1989 4935 Czechia
2964 2964       Denmark 2020-04-22 23:30:32 56.2639 9.5018 7912 384 5087 2441 Denmark
2965 2965       Diamond Princess 2020-04-22 23:30:32     712 13 644 55 Diamond Princess
2966 2966       Djibouti 2020-04-22 23:30:32 11.8251 42.5903 974 2 183 789 Djibouti
2967 2967       Dominica 2020-04-22 23:30:32 15.415 -61.371 16 0 9 7 Dominica
2968 2968       Dominican Republic 2020-04-22 23:30:32 18.7357 -70.1627 5300 260 581 4459 Dominican Republic
2969 2969       Ecuador 2020-04-22 23:30:32 -1.8312 -78.1834 10850 537 1262 9051 Ecuador
2970 2970       Egypt 2020-04-22 23:30:32 26.820553000000004 30.802497999999996 3659 276 935 2448 Egypt
2971 2971       El Salvador 2020-04-22 23:30:32 13.7942 -88.8965 237 7 63 167 El Salvador
2972 2972       Equatorial Guinea 2020-04-22 23:30:32 1.6508 10.2679 84 1 7 76 Equatorial Guinea
2973 2973       Eritrea 2020-04-22 23:30:32 15.1794 39.7823 39 0 6 33 Eritrea
2974 2974       Estonia 2020-04-22 23:30:32 58.5953 25.0136 1559 44 184 1331 Estonia
2975 2975       Eswatini 2020-04-22 23:30:32 -26.5225 31.4659 31 1 8 22 Eswatini
2976 2976       Ethiopia 2020-04-22 23:30:32 9.145 40.4897 116 3 21 92 Ethiopia
2977 2977       Fiji 2020-04-22 23:30:32 -17.7134 178.065 18 0 8 10 Fiji
2978 2978       Finland 2020-04-22 23:30:32 61.92411 25.748151 4129 149 2000 1980 Finland
2979 2979       France 2020-04-22 23:30:32 46.2276 2.2137 158748 21311 40657 93863 France
2980 2980       Gabon 2020-04-22 23:30:32 -0.8037 11.6094 166 1 24 141 Gabon
2981 2981       Gambia 2020-04-22 23:30:32 13.4432 -15.3101 10 1 2 7 Gambia
2982 2982       Georgia 2020-04-22 23:30:32 42.3154 43.3569 416 5 107 304 Georgia
2983 2983       Germany 2020-04-22 23:30:32 51.165690999999995 10.451526 150648 5279 99400 45969 Germany
2984 2984       Ghana 2020-04-22 23:30:32 7.9465 -1.0232 1154 9 99 1046 Ghana
2985 2985       Greece 2020-04-22 23:30:32 39.0742 21.8243 2408 121 577 1710 Greece
2986 2986       Grenada 2020-04-22 23:30:32 12.1165 -61.678999999999995 15 0 6 9 Grenada
2987 2987       Guatemala 2020-04-22 23:30:32 15.7835 -90.2308 316 8 24 284 Guatemala
2988 2988       Guinea 2020-04-22 23:30:32 9.9456 -9.6966 761 6 164 591 Guinea
2989 2989       Guinea-Bissau 2020-04-22 23:30:32 11.8037 -15.1804 50 0 3 47 Guinea-Bissau
2990 2990       Guyana 2020-04-22 23:30:32 4.860416000000002 -58.93018000000001 67 7 9 51 Guyana
2991 2991       Haiti 2020-04-22 23:30:32 18.9712 -72.2852 57 3 2 56 Haiti
2992 2992       Holy See 2020-04-22 23:30:32 41.9029 12.4534 9 0 2 7 Holy See
2993 2993       Honduras 2020-04-22 23:30:32 15.2 -86.2419 510 46 30 434 Honduras
2994 2994       Hungary 2020-04-22 23:30:32 47.1625 19.5033 2168 225 295 1648 Hungary
2995 2995       Iceland 2020-04-22 23:30:32 64.9631 -19.0208 1785 10 1462 313 Iceland
2996 2996       India 2020-04-22 23:30:32 20.593684 78.96288 21370 681 4370 16319 India
2997 2997       Indonesia 2020-04-22 23:30:32 -0.7893 113.9213 7418 635 913 5870 Indonesia
2998 2998       Iran 2020-04-22 23:30:32 32.427908 53.68804599999999 85996 5391 63113 17492 Iran
2999 2999       Iraq 2020-04-22 23:30:32 33.223191 43.679291 1631 83 1146 402 Iraq
3000 3000       Ireland 2020-04-22 23:30:32 53.1424 -7.6921 16671 769 9233 6669 Ireland
3001 3001       Israel 2020-04-22 23:30:32 31.046051000000002 34.851612 14619 192 5514 9094 Israel
3002 3002       Italy 2020-04-22 23:30:32 41.87194 12.56738 187327 25085 54543 107699 Italy
3003 3003       Jamaica 2020-04-22 23:30:32 18.1096 -77.2975 233 6 27 200 Jamaica
3004 3004       Japan 2020-04-22 23:30:32 36.204824 138.252924 11512 281 1356 9875 Japan
3005 3005       Jordan 2020-04-22 23:30:32 31.24 36.51 435 7 315 113 Jordan
3006 3006       Kazakhstan 2020-04-22 23:30:32 48.0196 66.9237 2135 19 515 1601 Kazakhstan
3007 3007       Kenya 2020-04-22 23:30:32 -0.0236 37.9062 303 14 74 215 Kenya
3008 3008       Korea, South 2020-04-22 23:30:32 35.90775700000001 127.766922 10694 238 8277 2179 Korea, South
3009 3009       Kosovo 2020-04-22 23:30:32 42.602636 20.902977 510 12 93 405 Kosovo
3010 3010       Kuwait 2020-04-22 23:30:32 29.311659999999996 47.481766 2248 13 443 1792 Kuwait
3011 3011       Kyrgyzstan 2020-04-22 23:30:32 41.20438 74.766098 612 7 254 351 Kyrgyzstan
3012 3012       Laos 2020-04-22 23:30:32 19.856270000000002 102.495496 19 0 4 15 Laos
3013 3013       Latvia 2020-04-22 23:30:32 56.8796 24.6032 761 11 133 617 Latvia
3014 3014       Lebanon 2020-04-22 23:30:32 33.8547 35.8623 682 22 113 547 Lebanon
3015 3015       Liberia 2020-04-22 23:30:32 6.4280550000000005 -9.429499 101 8 20 73 Liberia
3016 3016       Libya 2020-04-22 23:30:32 26.3351 17.228331 59 1 15 43 Libya
3017 3017       Liechtenstein 2020-04-22 23:30:32 47.14 9.55 81 1 55 25 Liechtenstein
3018 3018       Lithuania 2020-04-22 23:30:32 55.1694 23.8813 1250 27 195 975 Lithuania
3019 3019       Luxembourg 2020-04-22 23:30:32 49.8153 6.1296 3654 80 711 2863 Luxembourg
3020 3020       MS Zaandam 2020-04-22 23:30:32     9 2 0 7 MS Zaandam

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

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