04-19-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,074 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
2894 2894       Afghanistan 2020-04-19 23:40:41 33.93911 67.709953 997 33 131 832 Afghanistan
2895 2895       Albania 2020-04-19 23:40:41 41.1533 20.1683 562 26 314 222 Albania
2896 2896       Algeria 2020-04-19 23:40:41 28.0339 1.6596 2629 375 1047 1207 Algeria
2897 2897       Andorra 2020-04-19 23:40:41 42.5063 1.5218 713 36 235 442 Andorra
2898 2898       Angola 2020-04-19 23:40:41 -11.2027 17.8739 24 2 6 16 Angola
2899 2899       Antigua and Barbuda 2020-04-19 23:40:41 17.0608 -61.7964 23 3 3 17 Antigua and Barbuda
2900 2900       Argentina 2020-04-19 23:40:41 -38.4161 -63.6167 2839 132 709 1998 Argentina
2901 2901       Armenia 2020-04-19 23:40:41 40.0691 45.0382 1291 20 545 726 Armenia
2902 2902       Austria 2020-04-19 23:40:41 47.5162 14.5501 14749 452 10501 3796 Austria
2903 2903       Azerbaijan 2020-04-19 23:40:41 40.1431 47.5769 1398 19 712 667 Azerbaijan
2904 2904       Bahamas 2020-04-19 23:40:41 25.025885 -78.035889 55 9 10 36 Bahamas
2905 2905       Bahrain 2020-04-19 23:40:41 26.0275 50.55 1881 7 759 1115 Bahrain
2906 2906       Bangladesh 2020-04-19 23:40:41 23.685 90.3563 2456 91 75 2290 Bangladesh
2907 2907       Barbados 2020-04-19 23:40:41 13.1939 -59.5432 75 5 17 53 Barbados
2908 2908       Belarus 2020-04-19 23:40:41 53.7098 27.9534 4779 47 494 4238 Belarus
2909 2909       Belgium 2020-04-19 23:40:41 50.8333 4.469936 38496 5683 8757 24056 Belgium
2910 2910       Belize 2020-04-19 23:40:41 17.1899 -88.4976 18 2 2 14 Belize
2911 2911       Benin 2020-04-19 23:40:41 9.3077 2.3158 35 1 18 16 Benin
2912 2912       Bhutan 2020-04-19 23:40:41 27.5142 90.4336 5 0 2 3 Bhutan
2913 2913       Bolivia 2020-04-19 23:40:41 -16.2902 -63.5887 520 32 31 457 Bolivia
2914 2914       Bosnia and Herzegovina 2020-04-19 23:40:41 43.9159 17.6791 1285 48 347 890 Bosnia and Herzegovina
2915 2915       Botswana 2020-04-19 23:40:41 -22.3285 24.6849 20 1 0 19 Botswana
2916 2916       Brazil 2020-04-19 23:40:41 -14.235 -51.9253 38654 2462 22130 14062 Brazil
2917 2917       Brunei 2020-04-19 23:40:41 4.5353 114.7277 138 1 115 22 Brunei
2918 2918       Bulgaria 2020-04-19 23:40:41 42.7339 25.4858 894 42 161 691 Bulgaria
2919 2919       Burkina Faso 2020-04-19 23:40:41 12.2383 -1.5616 576 36 338 202 Burkina Faso
2920 2920       Burma 2020-04-19 23:40:41 21.9162 95.956 111 5 7 99 Burma
2921 2921       Burundi 2020-04-19 23:40:41 -3.3731 29.9189 5 1 0 4 Burundi
2922 2922       Cabo Verde 2020-04-19 23:40:41 16.5388 -23.0418 61 1 1 59 Cabo Verde
2923 2923       Cambodia 2020-04-19 23:40:41 11.55 104.9167 122 0 105 17 Cambodia
2924 2924       Cameroon 2020-04-19 23:40:41 3.848 11.5021 1017 42 305 670 Cameroon
2925 2925       Central African Republic 2020-04-19 23:40:41 6.6111 20.9394 12 0 4 8 Central African Republic
2926 2926       Chad 2020-04-19 23:40:41 15.4542 18.7322 33 0 8 25 Chad
2927 2927       Chile 2020-04-19 23:40:41 -35.6751 -71.543 10088 133 4338 5617 Chile
2928 2928       Colombia 2020-04-19 23:40:41 4.5709 -74.2973 3792 179 711 2902 Colombia
2929 2929       Congo (Brazzaville) 2020-04-19 23:40:41 -4.2634 15.2832 143 6 11 126 Congo (Brazzaville)
2930 2930       Congo (Kinshasa) 2020-04-19 23:40:41 -4.322447 15.307045 327 25 26 276 Congo (Kinshasa)
2931 2931       Costa Rica 2020-04-19 23:40:41 9.7489 -83.7534 660 5 112 543 Costa Rica
2932 2932       Cote d'Ivoire 2020-04-19 23:40:41 7.54 -5.5471 847 9 260 578 Cote d'Ivoire
2933 2933       Croatia 2020-04-19 23:40:41 45.1 15.2 1871 47 709 1115 Croatia
2934 2934       Cuba 2020-04-19 23:40:41 21.521757 -77.781167 1035 34 255 746 Cuba
2935 2935       Cyprus 2020-04-19 23:40:41 35.1264 33.4299 767 12 81 674 Cyprus
2936 2936       Czechia 2020-04-19 23:40:41 49.8175 15.473 6746 186 1298 5262 Czechia
2937 2937       Denmark 2020-04-19 23:40:41 56.2639 9.5018 7384 355 4141 2888 Denmark
2938 2938       Diamond Princess 2020-04-19 23:40:41     712 13 644 55 Diamond Princess
2939 2939       Djibouti 2020-04-19 23:40:41 11.8251 42.5903 846 2 102 742 Djibouti
2940 2940       Dominica 2020-04-19 23:40:41 15.415 -61.371 16 0 8 8 Dominica
2941 2941       Dominican Republic 2020-04-19 23:40:41 18.7357 -70.1627 4680 226 363 4091 Dominican Republic
2942 2942       Ecuador 2020-04-19 23:40:41 -1.8312 -78.1834 9468 474 1061 7933 Ecuador
2943 2943       Egypt 2020-04-19 23:40:41 26.820553 30.802498 3144 239 732 2173 Egypt
2944 2944       El Salvador 2020-04-19 23:40:41 13.7942 -88.8965 201 7 44 150 El Salvador
2945 2945       Equatorial Guinea 2020-04-19 23:40:41 1.6508 10.2679 79 0 4 75 Equatorial Guinea
2946 2946       Eritrea 2020-04-19 23:40:41 15.1794 39.7823 39 0 3 36 Eritrea
2947 2947       Estonia 2020-04-19 23:40:41 58.5953 25.0136 1528 40 164 1324 Estonia
2948 2948       Eswatini 2020-04-19 23:40:41 -26.5225 31.4659 22 1 8 13 Eswatini
2949 2949       Ethiopia 2020-04-19 23:40:41 9.145 40.4897 108 3 16 89 Ethiopia
2950 2950       Fiji 2020-04-19 23:40:41 -17.7134 178.065 17 0 0 17 Fiji
2951 2951       Finland 2020-04-19 23:40:41 61.92411 25.748151 3783 94 1700 1989 Finland
2952 2952       France 2020-04-19 23:40:41 46.2276 2.2137 151838 19692 36578 96598 France
2953 2953       Gabon 2020-04-19 23:40:41 -0.8037 11.6094 109 1 7 101 Gabon
2954 2954       Gambia 2020-04-19 23:40:41 13.4432 -15.3101 10 1 2 7 Gambia
2955 2955       Georgia 2020-04-19 23:40:41 42.3154 43.3569 394 4 93 297 Georgia
2956 2956       Germany 2020-04-19 23:40:41 51.165691 10.451526 145184 4586 88000 52598 Germany
2957 2957       Ghana 2020-04-19 23:40:41 7.9465 -1.0232 1042 9 99 934 Ghana
2958 2958       Greece 2020-04-19 23:40:41 39.0742 21.8243 2235 113 269 1853 Greece
2959 2959       Grenada 2020-04-19 23:40:41 12.1165 -61.679 14 0 6 8 Grenada
2960 2960       Guatemala 2020-04-19 23:40:41 15.7835 -90.2308 257 7 21 229 Guatemala
2961 2961       Guinea 2020-04-19 23:40:41 9.9456 -9.6966 579 5 87 487 Guinea
2962 2962       Guinea-Bissau 2020-04-19 23:40:41 11.8037 -15.1804 50 0 3 47 Guinea-Bissau
2963 2963       Guyana 2020-04-19 23:40:41 4.860416 -58.93018 65 7 9 49 Guyana
2964 2964       Haiti 2020-04-19 23:40:41 18.9712 -72.2852 44 3 0 44 Haiti
2965 2965       Holy See 2020-04-19 23:40:41 41.9029 12.4534 8 0 2 6 Holy See
2966 2966       Honduras 2020-04-19 23:40:41 15.2 -86.2419 472 46 15 411 Honduras
2967 2967       Hungary 2020-04-19 23:40:41 47.1625 19.5033 1916 189 250 1477 Hungary
2968 2968       Iceland 2020-04-19 23:40:41 64.9631 -19.0208 1771 9 1291 471 Iceland
2969 2969       India 2020-04-19 23:40:41 20.593684 78.96288 17615 559 2854 14202 India
2970 2970       Indonesia 2020-04-19 23:40:41 -0.7893 113.9213 6575 582 686 5307 Indonesia
2971 2971       Iran 2020-04-19 23:40:41 32.427908 53.688046 82211 5118 57023 20070 Iran
2972 2972       Iraq 2020-04-19 23:40:41 33.223191 43.679291 1539 82 1009 448 Iraq
2973 2973       Ireland 2020-04-19 23:40:41 53.1424 -7.6921 15251 610 77 14564 Ireland
2974 2974       Israel 2020-04-19 23:40:41 31.046051 34.851612 13813 174 4228 9565 Israel
2975 2975       Italy 2020-04-19 23:40:41 41.87194 12.56738 178972 23660 47055 108257 Italy
2976 2976       Jamaica 2020-04-19 23:40:41 18.1096 -77.2975 173 5 27 141 Jamaica
2977 2977       Japan 2020-04-19 23:40:41 36.204824 138.252924 10797 236 1159 9402 Japan
2978 2978       Jordan 2020-04-19 23:40:41 31.24 36.51 417 7 276 134 Jordan
2979 2979       Kazakhstan 2020-04-19 23:40:41 48.0196 66.9237 1676 17 400 1259 Kazakhstan
2980 2980       Kenya 2020-04-19 23:40:41 -0.0236 37.9062 270 14 67 189 Kenya
2981 2981       Korea, South 2020-04-19 23:40:41 35.907757 127.766922 10661 234 8042 2385 Korea, South
2982 2982       Kosovo 2020-04-19 23:40:41 42.602636 20.902977 510 12 93 405 Kosovo
2983 2983       Kuwait 2020-04-19 23:40:41 29.31166 47.481766 1915 7 305 1603 Kuwait
2984 2984       Kyrgyzstan 2020-04-19 23:40:41 41.20438 74.766098 554 5 133 416 Kyrgyzstan
2985 2985       Laos 2020-04-19 23:40:41 19.85627 102.495496 19 0 2 17 Laos
2986 2986       Latvia 2020-04-19 23:40:41 56.8796 24.6032 727 5 88 634 Latvia
2987 2987       Lebanon 2020-04-19 23:40:41 33.8547 35.8623 673 21 102 550 Lebanon
2988 2988       Liberia 2020-04-19 23:40:41 6.428055 -9.429499 91 8 7 76 Liberia
2989 2989       Libya 2020-04-19 23:40:41 26.3351 17.228331 51 1 11 39 Libya
2990 2990       Liechtenstein 2020-04-19 23:40:41 47.14 9.55 81 1 55 25 Liechtenstein
2991 2991       Lithuania 2020-04-19 23:40:41 55.1694 23.8813 1153 23 98 1021 Lithuania
2992 2992       Luxembourg 2020-04-19 23:40:41 49.8153 6.1296 3550 73 627 2850 Luxembourg
2993 2993       MS Zaandam 2020-04-19 23:40:41     9 2 0 7 MS Zaandam

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

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