04-15-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,028 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
2848 2848       Afghanistan 2020-04-15 22:56:32 33.93911 67.709953 785 29 43 716 Afghanistan
2849 2849       Albania 2020-04-15 22:56:32 41.1533 20.1683 494 25 251 218 Albania
2850 2850       Algeria 2020-04-15 22:56:32 28.0339 1.6596 2160 336 708 1116 Algeria
2851 2851       Andorra 2020-04-15 22:56:32 42.5063 1.5218 673 33 169 471 Andorra
2852 2852       Angola 2020-04-15 22:56:32 -11.2027 17.8739 19 2 5 12 Angola
2853 2853       Antigua and Barbuda 2020-04-15 22:56:32 17.0608 -61.7964 23 2 3 18 Antigua and Barbuda
2854 2854       Argentina 2020-04-15 22:56:32 -38.4161 -63.6167 2443 111 596 1736 Argentina
2855 2855       Armenia 2020-04-15 22:56:32 40.0691 45.0382 1111 17 297 797 Armenia
2856 2856       Austria 2020-04-15 22:56:32 47.5162 14.5501 14336 393 8098 5845 Austria
2857 2857       Azerbaijan 2020-04-15 22:56:32 40.1431 47.5769 1253 13 404 836 Azerbaijan
2858 2858       Bahamas 2020-04-15 22:56:32 25.025885 -78.035889 49 8 6 35 Bahamas
2859 2859       Bahrain 2020-04-15 22:56:32 26.0275 50.55 1671 7 663 1001 Bahrain
2860 2860       Bangladesh 2020-04-15 22:56:32 23.685 90.3563 1231 50 49 1132 Bangladesh
2861 2861       Barbados 2020-04-15 22:56:32 13.1939 -59.5432 73 5 15 53 Barbados
2862 2862       Belarus 2020-04-15 22:56:32 53.7098 27.9534 3728 36 203 3489 Belarus
2863 2863       Belgium 2020-04-15 22:56:32 50.8333 4.469936 33573 4440 7107 22026 Belgium
2864 2864       Belize 2020-04-15 22:56:32 17.1899 -88.4976 18 2 0 16 Belize
2865 2865       Benin 2020-04-15 22:56:32 9.3077 2.3158 35 1 18 16 Benin
2866 2866       Bhutan 2020-04-15 22:56:32 27.5142 90.4336 5 0 2 3 Bhutan
2867 2867       Bolivia 2020-04-15 22:56:32 -16.2902 -63.5887 397 28 7 362 Bolivia
2868 2868       Bosnia and Herzegovina 2020-04-15 22:56:32 43.9159 17.6791 1110 41 253 816 Bosnia and Herzegovina
2869 2869       Botswana 2020-04-15 22:56:32 -22.3285 24.6849 13 1 0 12 Botswana
2870 2870       Brazil 2020-04-15 22:56:32 -14.235 -51.9253 28320 1736 14026 12558 Brazil
2871 2871       Brunei 2020-04-15 22:56:32 4.5353 114.7277 136 1 108 27 Brunei
2872 2872       Bulgaria 2020-04-15 22:56:32 42.7339 25.4858 747 36 105 606 Bulgaria
2873 2873       Burkina Faso 2020-04-15 22:56:32 12.2383 -1.5616 542 32 226 284 Burkina Faso
2874 2874       Burma 2020-04-15 22:56:32 21.9162 95.956 74 4 2 68 Burma
2875 2875       Burundi 2020-04-15 22:56:32 -3.3731 29.9189 5 1 0 4 Burundi
2876 2876       Cabo Verde 2020-04-15 22:56:32 16.5388 -23.0418 56 1 1 54 Cabo Verde
2877 2877       Cambodia 2020-04-15 22:56:32 11.55 104.9167 122 0 96 26 Cambodia
2878 2878       Cameroon 2020-04-15 22:56:32 3.8480000000000003 11.5021 848 17 165 666 Cameroon
2879 2879       Central African Republic 2020-04-15 22:56:32 6.6111 20.9394 12 0 4 8 Central African Republic
2880 2880       Chad 2020-04-15 22:56:32 15.4542 18.7322 23 0 2 21 Chad
2881 2881       Chile 2020-04-15 22:56:32 -35.6751 -71.543 8273 94 2937 5242 Chile
2882 2882       Colombia 2020-04-15 22:56:32 4.5709 -74.2973 3105 131 452 2522 Colombia
2883 2883       Congo (Brazzaville) 2020-04-15 22:56:32 -4.2634 15.2832 117 5 11 101 Congo (Brazzaville)
2884 2884       Congo (Kinshasa) 2020-04-15 22:56:32 -4.322447 15.307045 254 21 21 212 Congo (Kinshasa)
2885 2885       Costa Rica 2020-04-15 22:56:32 9.7489 -83.7534 626 4 67 555 Costa Rica
2886 2886       Cote d'Ivoire 2020-04-15 22:56:32 7.54 -5.5471 638 6 114 518 Cote d'Ivoire
2887 2887       Croatia 2020-04-15 22:56:32 45.1 15.2 1741 33 473 1235 Croatia
2888 2888       Cuba 2020-04-15 22:56:32 21.521757 -77.78116700000002 814 24 151 639 Cuba
2889 2889       Cyprus 2020-04-15 22:56:32 35.1264 33.4299 715 12 65 638 Cyprus
2890 2890       Czechia 2020-04-15 22:56:32 49.8175 15.472999999999999 6216 166 819 5231 Czechia
2891 2891       Denmark 2020-04-15 22:56:32 56.2639 9.5018 6681 309 2748 3624 Denmark
2892 2892       Diamond Princess 2020-04-15 22:56:32     712 12 639 61 Diamond Princess
2893 2893       Djibouti 2020-04-15 22:56:32 11.8251 42.5903 435 2 71 362 Djibouti
2894 2894       Dominica 2020-04-15 22:56:32 15.415 -61.371 16 0 8 8 Dominica
2895 2895       Dominican Republic 2020-04-15 22:56:32 18.7357 -70.1627 3614 189 208 3217 Dominican Republic
2896 2896       Ecuador 2020-04-15 22:56:32 -1.8312 -78.1834 7858 388 780 6690 Ecuador
2897 2897       Egypt 2020-04-15 22:56:32 26.820553000000004 30.802497999999996 2505 183 589 1733 Egypt
2898 2898       El Salvador 2020-04-15 22:56:32 13.7942 -88.8965 159 6 30 123 El Salvador
2899 2899       Equatorial Guinea 2020-04-15 22:56:32 1.6508 10.2679 51 0 4 47 Equatorial Guinea
2900 2900       Eritrea 2020-04-15 22:56:32 15.1794 39.7823 35 0 0 35 Eritrea
2901 2901       Estonia 2020-04-15 22:56:32 58.5953 25.0136 1400 35 117 1248 Estonia
2902 2902       Eswatini 2020-04-15 22:56:32 -26.5225 31.4659 15 0 8 7 Eswatini
2903 2903       Ethiopia 2020-04-15 22:56:32 9.145 40.4897 85 3 15 67 Ethiopia
2904 2904       Fiji 2020-04-15 22:56:32 -17.7134 178.065 16 0 0 16 Fiji
2905 2905       Finland 2020-04-15 22:56:32 61.92411 25.748151 3237 72 300 2865 Finland
2906 2906 250     France 2020-04-15 22:56:32 46.2276 2.2137 132473 17148 30955 85348 France
2907 2907       Gabon 2020-04-15 22:56:32 -0.8037 11.6094 80 1 4 75 Gabon
2908 2908       Gambia 2020-04-15 22:56:32 13.4432 -15.3101 9 1 2 6 Gambia
2909 2909       Georgia 2020-04-15 22:56:32 42.3154 43.3569 306 3 71 232 Georgia
2910 2910       Germany 2020-04-15 22:56:32 51.165690999999995 10.451526 134753 3804 72600 58349 Germany
2911 2911       Ghana 2020-04-15 22:56:32 7.9465 -1.0232 636 8 17 611 Ghana
2912 2912       Greece 2020-04-15 22:56:32 39.0742 21.8243 2192 102 269 1821 Greece
2913 2913       Grenada 2020-04-15 22:56:32 12.1165 -61.678999999999995 14 0 0 14 Grenada
2914 2914       Guatemala 2020-04-15 22:56:32 15.7835 -90.2308 180 5 19 156 Guatemala
2915 2915       Guinea 2020-04-15 22:56:32 9.9456 -9.6966 404 1 31 372 Guinea
2916 2916       Guinea-Bissau 2020-04-15 22:56:32 11.8037 -15.1804 43 0 0 43 Guinea-Bissau
2917 2917       Guyana 2020-04-15 22:56:32 4.860416000000002 -58.93018000000001 55 6 8 41 Guyana
2918 2918       Haiti 2020-04-15 22:56:32 18.9712 -72.2852 40 3 0 38 Haiti
2919 2919       Holy See 2020-04-15 22:56:32 41.9029 12.4534 8 0 2 6 Holy See
2920 2920       Honduras 2020-04-15 22:56:32 15.2 -86.2419 419 31 9 379 Honduras
2921 2921       Hungary 2020-04-15 22:56:32 47.1625 19.5033 1579 134 192 1253 Hungary
2922 2922       Iceland 2020-04-15 22:56:32 64.9631 -19.0208 1727 8 1077 642 Iceland
2923 2923       India 2020-04-15 22:56:32 20.593684 78.96288 12322 405 1432 10485 India
2924 2924       Indonesia 2020-04-15 22:56:32 -0.7893 113.9213 5136 469 446 4221 Indonesia
2925 2925       Iran 2020-04-15 22:56:32 32.427908 53.68804599999999 76389 4777 49933 21679 Iran
2926 2926       Iraq 2020-04-15 22:56:32 33.223191 43.679291 1415 79 812 524 Iraq
2927 2927       Ireland 2020-04-15 22:56:32 53.1424 -7.6921 12547 444 77 12026 Ireland
2928 2928       Israel 2020-04-15 22:56:32 31.046051000000002 34.851612 12652 139 2823 9808 Israel
2929 2929       Italy 2020-04-15 22:56:32 41.87194 12.56738 165155 21645 38092 105418 Italy
2930 2930       Jamaica 2020-04-15 22:56:32 18.1096 -77.2975 125 5 21 99 Jamaica
2931 2931       Japan 2020-04-15 22:56:32 36.204824 138.252924 8100 146 853 7101 Japan
2932 2932       Jordan 2020-04-15 22:56:32 31.24 36.51 401 7 250 144 Jordan
2933 2933       Kazakhstan 2020-04-15 22:56:32 48.0196 66.9237 1295 16 240 1039 Kazakhstan
2934 2934       Kenya 2020-04-15 22:56:32 -0.0236 37.9062 225 10 53 162 Kenya
2935 2935       Korea, South 2020-04-15 22:56:32 35.90775700000001 127.766922 10591 225 7616 2750 Korea, South
2936 2936       Kosovo 2020-04-15 22:56:32 42.602636 20.902977 387 8 66 313 Kosovo
2937 2937       Kuwait 2020-04-15 22:56:32 29.311659999999996 47.481766 1405 3 206 1196 Kuwait
2938 2938       Kyrgyzstan 2020-04-15 22:56:32 41.20438 74.766098 449 5 78 366 Kyrgyzstan
2939 2939       Laos 2020-04-15 22:56:32 19.856270000000002 102.495496 19 0 1 18 Laos
2940 2940       Latvia 2020-04-15 22:56:32 56.8796 24.6032 666 5 44 617 Latvia
2941 2941       Lebanon 2020-04-15 22:56:32 33.8547 35.8623 658 21 85 552 Lebanon
2942 2942       Liberia 2020-04-15 22:56:32 6.4280550000000005 -9.429499 59 6 4 49 Liberia
2943 2943       Libya 2020-04-15 22:56:32 26.3351 17.228331 48 1 9 38 Libya
2944 2944       Liechtenstein 2020-04-15 22:56:32 47.14 9.55 79 1 55 23 Liechtenstein
2945 2945       Lithuania 2020-04-15 22:56:32 55.1694 23.8813 995 20 9 923 Lithuania
2946 2946       Luxembourg 2020-04-15 22:56:32 49.8153 6.1296 3373 69 526 2778 Luxembourg
2947 2947       MS Zaandam 2020-04-15 22:56:32     9 2 0 7 MS Zaandam

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

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