04-17-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,047 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
2867 2867       Afghanistan 2020-04-17 23:30:32 33.93911 67.709953 907 30 99 777 Afghanistan
2868 2868       Albania 2020-04-17 23:30:32 41.1533 20.1683 539 26 283 230 Albania
2869 2869       Algeria 2020-04-17 23:30:32 28.0339 1.6596 2418 364 846 1208 Algeria
2870 2870       Andorra 2020-04-17 23:30:32 42.5063 1.5218 696 35 191 470 Andorra
2871 2871       Angola 2020-04-17 23:30:32 -11.2027 17.8739 19 2 5 12 Angola
2872 2872       Antigua and Barbuda 2020-04-17 23:30:32 17.0608 -61.7964 23 3 3 17 Antigua and Barbuda
2873 2873       Argentina 2020-04-17 23:30:32 -38.4161 -63.6167 2669 123 666 1880 Argentina
2874 2874       Armenia 2020-04-17 23:30:32 40.0691 45.0382 1201 19 402 780 Armenia
2875 2875       Austria 2020-04-17 23:30:32 47.5162 14.5501 14595 431 9704 4460 Austria
2876 2876       Azerbaijan 2020-04-17 23:30:32 40.1431 47.5769 1340 15 528 797 Azerbaijan
2877 2877       Bahamas 2020-04-17 23:30:32 25.025885 -78.035889 54 9 6 39 Bahamas
2878 2878       Bahrain 2020-04-17 23:30:32 26.0275 50.55 1740 7 725 1008 Bahrain
2879 2879       Bangladesh 2020-04-17 23:30:32 23.685 90.3563 1838 75 58 1705 Bangladesh
2880 2880       Barbados 2020-04-17 23:30:32 13.1939 -59.5432 75 5 15 55 Barbados
2881 2881       Belarus 2020-04-17 23:30:32 53.7098 27.9534 4779 42 342 4395 Belarus
2882 2882       Belgium 2020-04-17 23:30:32 50.8333 4.469936 36138 5163 7961 23014 Belgium
2883 2883       Belize 2020-04-17 23:30:32 17.1899 -88.4976 18 2 0 16 Belize
2884 2884       Benin 2020-04-17 23:30:32 9.3077 2.3158 35 1 18 16 Benin
2885 2885       Bhutan 2020-04-17 23:30:32 27.5142 90.4336 5 0 2 3 Bhutan
2886 2886       Bolivia 2020-04-17 23:30:32 -16.2902 -63.5887 465 31 26 408 Bolivia
2887 2887       Bosnia and Herzegovina 2020-04-17 23:30:32 43.9159 17.6791 1214 46 320 848 Bosnia and Herzegovina
2888 2888       Botswana 2020-04-17 23:30:32 -22.3285 24.6849 15 1 0 14 Botswana
2889 2889       Brazil 2020-04-17 23:30:32 -14.235 -51.9253 33682 2141 14026 17515 Brazil
2890 2890       Brunei 2020-04-17 23:30:32 4.5353 114.7277 136 1 112 23 Brunei
2891 2891       Bulgaria 2020-04-17 23:30:32 42.7339 25.4858 846 41 141 664 Bulgaria
2892 2892       Burkina Faso 2020-04-17 23:30:32 12.2383 -1.5616 557 35 294 228 Burkina Faso
2893 2893       Burma 2020-04-17 23:30:32 21.9162 95.956 88 4 5 79 Burma
2894 2894       Burundi 2020-04-17 23:30:32 -3.3731 29.9189 5 1 0 4 Burundi
2895 2895       Cabo Verde 2020-04-17 23:30:32 16.5388 -23.0418 56 1 1 54 Cabo Verde
2896 2896       Cambodia 2020-04-17 23:30:32 11.55 104.9167 122 0 98 24 Cambodia
2897 2897       Cameroon 2020-04-17 23:30:32 3.8480000000000003 11.5021 996 22 164 810 Cameroon
2898 2898       Central African Republic 2020-04-17 23:30:32 6.6111 20.9394 12 0 4 8 Central African Republic
2899 2899       Chad 2020-04-17 23:30:32 15.4542 18.7322 27 0 5 22 Chad
2900 2900       Chile 2020-04-17 23:30:32 -35.6751 -71.543 9252 116 3621 5515 Chile
2901 2901       Colombia 2020-04-17 23:30:32 4.5709 -74.2973 3439 153 634 2652 Colombia
2902 2902       Congo (Brazzaville) 2020-04-17 23:30:32 -4.2634 15.2832 143 6 11 126 Congo (Brazzaville)
2903 2903       Congo (Kinshasa) 2020-04-17 23:30:32 -4.322447 15.307045 287 23 25 239 Congo (Kinshasa)
2904 2904       Costa Rica 2020-04-17 23:30:32 9.7489 -83.7534 649 4 88 557 Costa Rica
2905 2905       Cote d'Ivoire 2020-04-17 23:30:32 7.54 -5.5471 688 6 193 489 Cote d'Ivoire
2906 2906       Croatia 2020-04-17 23:30:32 45.1 15.2 1814 36 600 1178 Croatia
2907 2907       Cuba 2020-04-17 23:30:32 21.521757 -77.78116700000002 923 31 192 700 Cuba
2908 2908       Cyprus 2020-04-17 23:30:32 35.1264 33.4299 750 12 77 661 Cyprus
2909 2909       Czechia 2020-04-17 23:30:32 49.8175 15.472999999999999 6549 173 1174 5202 Czechia
2910 2910       Denmark 2020-04-17 23:30:32 56.2639 9.5018 7073 336 3389 3348 Denmark
2911 2911       Diamond Princess 2020-04-17 23:30:32     712 13 644 55 Diamond Princess
2912 2912       Djibouti 2020-04-17 23:30:32 11.8251 42.5903 732 2 76 654 Djibouti
2913 2913       Dominica 2020-04-17 23:30:32 15.415 -61.371 16 0 8 8 Dominica
2914 2914       Dominican Republic 2020-04-17 23:30:32 18.7357 -70.1627 4126 200 268 3658 Dominican Republic
2915 2915       Ecuador 2020-04-17 23:30:32 -1.8312 -78.1834 8450 421 838 7191 Ecuador
2916 2916       Egypt 2020-04-17 23:30:32 26.820553000000004 30.802497999999996 2844 205 646 1993 Egypt
2917 2917       El Salvador 2020-04-17 23:30:32 13.7942 -88.8965 177 7 38 132 El Salvador
2918 2918       Equatorial Guinea 2020-04-17 23:30:32 1.6508 10.2679 79 0 4 75 Equatorial Guinea
2919 2919       Eritrea 2020-04-17 23:30:32 15.1794 39.7823 35 0 0 35 Eritrea
2920 2920       Estonia 2020-04-17 23:30:32 58.5953 25.0136 1459 38 145 1276 Estonia
2921 2921       Eswatini 2020-04-17 23:30:32 -26.5225 31.4659 16 1 8 7 Eswatini
2922 2922       Ethiopia 2020-04-17 23:30:32 9.145 40.4897 96 3 15 78 Ethiopia
2923 2923       Fiji 2020-04-17 23:30:32 -17.7134 178.065 17 0 0 17 Fiji
2924 2924       Finland 2020-04-17 23:30:32 61.92411 25.748151 3489 82 1700 1707 Finland
2925 2925       France 2020-04-17 23:30:32 46.2276 2.2137 146942 18662 34420 94868 France
2926 2926       Gabon 2020-04-17 23:30:32 -0.8037 11.6094 108 1 7 100 Gabon
2927 2927       Gambia 2020-04-17 23:30:32 13.4432 -15.3101 9 1 2 6 Gambia
2928 2928       Georgia 2020-04-17 23:30:32 42.3154 43.3569 370 3 79 288 Georgia
2929 2929       Germany 2020-04-17 23:30:32 51.165690999999995 10.451526 141397 4352 83114 53931 Germany
2930 2930       Ghana 2020-04-17 23:30:32 7.9465 -1.0232 641 8 83 550 Ghana
2931 2931       Greece 2020-04-17 23:30:32 39.0742 21.8243 2224 108 269 1847 Greece
2932 2932       Grenada 2020-04-17 23:30:32 12.1165 -61.678999999999995 14 0 6 8 Grenada
2933 2933       Guatemala 2020-04-17 23:30:32 15.7835 -90.2308 214 7 21 186 Guatemala
2934 2934       Guinea 2020-04-17 23:30:32 9.9456 -9.6966 477 3 59 415 Guinea
2935 2935       Guinea-Bissau 2020-04-17 23:30:32 11.8037 -15.1804 43 0 0 43 Guinea-Bissau
2936 2936       Guyana 2020-04-17 23:30:32 4.860416000000002 -58.93018000000001 63 6 9 48 Guyana
2937 2937       Haiti 2020-04-17 23:30:32 18.9712 -72.2852 41 3 0 40 Haiti
2938 2938       Holy See 2020-04-17 23:30:32 41.9029 12.4534 8 0 2 6 Holy See
2939 2939       Honduras 2020-04-17 23:30:32 15.2 -86.2419 442 41 10 391 Honduras
2940 2940       Hungary 2020-04-17 23:30:32 47.1625 19.5033 1763 156 207 1400 Hungary
2941 2941       Iceland 2020-04-17 23:30:32 64.9631 -19.0208 1754 9 1224 521 Iceland
2942 2942       India 2020-04-17 23:30:32 20.593684 78.96288 14352 486 2041 11825 India
2943 2943       Indonesia 2020-04-17 23:30:32 -0.7893 113.9213 5923 520 607 4796 Indonesia
2944 2944       Iran 2020-04-17 23:30:32 32.427908 53.68804599999999 79494 4958 54064 20472 Iran
2945 2945       Iraq 2020-04-17 23:30:32 33.223191 43.679291 1482 81 906 495 Iraq
2946 2946       Ireland 2020-04-17 23:30:32 53.1424 -7.6921 13980 530 77 13373 Ireland
2947 2947       Israel 2020-04-17 23:30:32 31.046051000000002 34.851612 13246 155 3550 9705 Israel
2948 2948       Italy 2020-04-17 23:30:32 41.87194 12.56738 172434 22745 42727 106962 Italy
2949 2949       Jamaica 2020-04-17 23:30:32 18.1096 -77.2975 143 5 25 113 Jamaica
2950 2950       Japan 2020-04-17 23:30:32 36.204824 138.252924 9787 190 935 8662 Japan
2951 2951       Jordan 2020-04-17 23:30:32 31.24 36.51 407 7 265 135 Jordan
2952 2952       Kazakhstan 2020-04-17 23:30:32 48.0196 66.9237 1546 17 347 1182 Kazakhstan
2953 2953       Kenya 2020-04-17 23:30:32 -0.0236 37.9062 246 11 53 182 Kenya
2954 2954       Korea, South 2020-04-17 23:30:32 35.90775700000001 127.766922 10635 230 7829 2576 Korea, South
2955 2955       Kosovo 2020-04-17 23:30:32 42.602636 20.902977 480 12 84 384 Kosovo
2956 2956       Kuwait 2020-04-17 23:30:32 29.311659999999996 47.481766 1658 5 258 1395 Kuwait
2957 2957       Kyrgyzstan 2020-04-17 23:30:32 41.20438 74.766098 489 5 114 370 Kyrgyzstan
2958 2958       Laos 2020-04-17 23:30:32 19.856270000000002 102.495496 19 0 2 17 Laos
2959 2959       Latvia 2020-04-17 23:30:32 56.8796 24.6032 682 5 88 589 Latvia
2960 2960       Lebanon 2020-04-17 23:30:32 33.8547 35.8623 668 21 86 561 Lebanon
2961 2961       Liberia 2020-04-17 23:30:32 6.4280550000000005 -9.429499 76 7 7 62 Liberia
2962 2962       Libya 2020-04-17 23:30:32 26.3351 17.228331 49 1 11 37 Libya
2963 2963       Liechtenstein 2020-04-17 23:30:32 47.14 9.55 79 1 55 23 Liechtenstein
2964 2964       Lithuania 2020-04-17 23:30:32 55.1694 23.8813 1050 21 41 906 Lithuania
2965 2965       Luxembourg 2020-04-17 23:30:32 49.8153 6.1296 3480 72 579 2829 Luxembourg
2966 2966       MS Zaandam 2020-04-17 23:30:32     9 2 0 7 MS Zaandam

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

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