04-16-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,043 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
2863 2863       Afghanistan 2020-04-16 23:30:31 33.93911 67.709953 841 30 54 756 Afghanistan
2864 2864       Albania 2020-04-16 23:30:31 41.1533 20.1683 518 26 277 215 Albania
2865 2865       Algeria 2020-04-16 23:30:31 28.0339 1.6596 2268 348 783 1137 Algeria
2866 2866       Andorra 2020-04-16 23:30:31 42.5063 1.5218 673 33 169 471 Andorra
2867 2867       Angola 2020-04-16 23:30:31 -11.2027 17.8739 19 2 5 12 Angola
2868 2868       Antigua and Barbuda 2020-04-16 23:30:31 17.0608 -61.7964 23 3 3 17 Antigua and Barbuda
2869 2869       Argentina 2020-04-16 23:30:31 -38.4161 -63.6167 2571 115 631 1825 Argentina
2870 2870       Armenia 2020-04-16 23:30:31 40.0691 45.0382 1159 18 358 783 Armenia
2871 2871       Austria 2020-04-16 23:30:31 47.5162 14.5501 14476 410 8986 5080 Austria
2872 2872       Azerbaijan 2020-04-16 23:30:31 40.1431 47.5769 1283 15 460 808 Azerbaijan
2873 2873       Bahamas 2020-04-16 23:30:31 25.025885 -78.035889 53 8 6 39 Bahamas
2874 2874       Bahrain 2020-04-16 23:30:31 26.0275 50.55 1700 7 703 990 Bahrain
2875 2875       Bangladesh 2020-04-16 23:30:31 23.685 90.3563 1572 60 49 1463 Bangladesh
2876 2876       Barbados 2020-04-16 23:30:31 13.1939 -59.5432 75 5 15 55 Barbados
2877 2877       Belarus 2020-04-16 23:30:31 53.7098 27.9534 4204 40 203 3961 Belarus
2878 2878       Belgium 2020-04-16 23:30:31 50.8333 4.469936 34809 4857 7562 22390 Belgium
2879 2879       Belize 2020-04-16 23:30:31 17.1899 -88.4976 18 2 0 16 Belize
2880 2880       Benin 2020-04-16 23:30:31 9.3077 2.3158 35 1 18 16 Benin
2881 2881       Bhutan 2020-04-16 23:30:31 27.5142 90.4336 5 0 2 3 Bhutan
2882 2882       Bolivia 2020-04-16 23:30:31 -16.2902 -63.5887 441 29 14 398 Bolivia
2883 2883       Bosnia and Herzegovina 2020-04-16 23:30:31 43.9159 17.6791 1167 43 277 847 Bosnia and Herzegovina
2884 2884       Botswana 2020-04-16 23:30:31 -22.3285 24.6849 15 1 0 14 Botswana
2885 2885       Brazil 2020-04-16 23:30:31 -14.235 -51.9253 30425 1924 14026 14475 Brazil
2886 2886       Brunei 2020-04-16 23:30:31 4.5353 114.7277 136 1 108 27 Brunei
2887 2887       Bulgaria 2020-04-16 23:30:31 42.7339 25.4858 800 38 122 640 Bulgaria
2888 2888       Burkina Faso 2020-04-16 23:30:31 12.2383 -1.5616 546 32 257 257 Burkina Faso
2889 2889       Burma 2020-04-16 23:30:31 21.9162 95.956 85 4 2 79 Burma
2890 2890       Burundi 2020-04-16 23:30:31 -3.3731 29.9189 5 1 0 4 Burundi
2891 2891       Cabo Verde 2020-04-16 23:30:31 16.5388 -23.0418 56 1 1 54 Cabo Verde
2892 2892       Cambodia 2020-04-16 23:30:31 11.55 104.9167 122 0 98 24 Cambodia
2893 2893       Cameroon 2020-04-16 23:30:31 3.8480000000000003 11.5021 996 22 164 810 Cameroon
2894 2894       Central African Republic 2020-04-16 23:30:31 6.6111 20.9394 12 0 4 8 Central African Republic
2895 2895       Chad 2020-04-16 23:30:31 15.4542 18.7322 27 0 5 22 Chad
2896 2896       Chile 2020-04-16 23:30:31 -35.6751 -71.543 8807 105 3299 5403 Chile
2897 2897       Colombia 2020-04-16 23:30:31 4.5709 -74.2973 3233 144 550 2539 Colombia
2898 2898       Congo (Brazzaville) 2020-04-16 23:30:31 -4.2634 15.2832 117 5 11 101 Congo (Brazzaville)
2899 2899       Congo (Kinshasa) 2020-04-16 23:30:31 -4.322447 15.307045 267 22 23 222 Congo (Kinshasa)
2900 2900       Costa Rica 2020-04-16 23:30:31 9.7489 -83.7534 642 4 74 564 Costa Rica
2901 2901       Cote d'Ivoire 2020-04-16 23:30:31 7.54 -5.5471 654 6 146 502 Cote d'Ivoire
2902 2902       Croatia 2020-04-16 23:30:31 45.1 15.2 1791 35 529 1227 Croatia
2903 2903       Cuba 2020-04-16 23:30:31 21.521757 -77.78116700000002 862 27 171 664 Cuba
2904 2904       Cyprus 2020-04-16 23:30:31 35.1264 33.4299 735 12 77 646 Cyprus
2905 2905       Czechia 2020-04-16 23:30:31 49.8175 15.472999999999999 6433 169 972 5292 Czechia
2906 2906       Denmark 2020-04-16 23:30:31 56.2639 9.5018 6879 321 3023 3535 Denmark
2907 2907       Diamond Princess 2020-04-16 23:30:31     712 12 644 56 Diamond Princess
2908 2908       Djibouti 2020-04-16 23:30:31 11.8251 42.5903 591 2 73 516 Djibouti
2909 2909       Dominica 2020-04-16 23:30:31 15.415 -61.371 16 0 8 8 Dominica
2910 2910       Dominican Republic 2020-04-16 23:30:31 18.7357 -70.1627 3755 196 215 3344 Dominican Republic
2911 2911       Ecuador 2020-04-16 23:30:31 -1.8312 -78.1834 8225 403 838 6984 Ecuador
2912 2912       Egypt 2020-04-16 23:30:31 26.820553000000004 30.802497999999996 2673 196 596 1881 Egypt
2913 2913       El Salvador 2020-04-16 23:30:31 13.7942 -88.8965 164 6 33 125 El Salvador
2914 2914       Equatorial Guinea 2020-04-16 23:30:31 1.6508 10.2679 51 0 4 47 Equatorial Guinea
2915 2915       Eritrea 2020-04-16 23:30:31 15.1794 39.7823 35 0 0 35 Eritrea
2916 2916       Estonia 2020-04-16 23:30:31 58.5953 25.0136 1434 36 133 1265 Estonia
2917 2917       Eswatini 2020-04-16 23:30:31 -26.5225 31.4659 16 1 8 7 Eswatini
2918 2918       Ethiopia 2020-04-16 23:30:31 9.145 40.4897 92 3 15 74 Ethiopia
2919 2919       Fiji 2020-04-16 23:30:31 -17.7134 178.065 17 0 0 17 Fiji
2920 2920       Finland 2020-04-16 23:30:31 61.92411 25.748151 3369 75 1700 1594 Finland
2921 2921       France 2020-04-16 23:30:31 46.2276 2.2137 145051 17901 32812 95228 France
2922 2922       Gabon 2020-04-16 23:30:31 -0.8037 11.6094 80 1 4 75 Gabon
2923 2923       Gambia 2020-04-16 23:30:31 13.4432 -15.3101 9 1 2 6 Gambia
2924 2924       Georgia 2020-04-16 23:30:31 42.3154 43.3569 348 3 76 269 Georgia
2925 2925       Germany 2020-04-16 23:30:31 51.165690999999995 10.451526 137698 4052 77000 56646 Germany
2926 2926       Ghana 2020-04-16 23:30:31 7.9465 -1.0232 641 8 83 550 Ghana
2927 2927       Greece 2020-04-16 23:30:31 39.0742 21.8243 2207 105 269 1833 Greece
2928 2928       Grenada 2020-04-16 23:30:31 12.1165 -61.678999999999995 14 0 0 14 Grenada
2929 2929       Guatemala 2020-04-16 23:30:31 15.7835 -90.2308 196 5 19 172 Guatemala
2930 2930       Guinea 2020-04-16 23:30:31 9.9456 -9.6966 438 1 49 388 Guinea
2931 2931       Guinea-Bissau 2020-04-16 23:30:31 11.8037 -15.1804 43 0 0 43 Guinea-Bissau
2932 2932       Guyana 2020-04-16 23:30:31 4.860416000000002 -58.93018000000001 55 6 8 41 Guyana
2933 2933       Haiti 2020-04-16 23:30:31 18.9712 -72.2852 41 3 0 38 Haiti
2934 2934       Holy See 2020-04-16 23:30:31 41.9029 12.4534 8 0 2 6 Holy See
2935 2935       Honduras 2020-04-16 23:30:31 15.2 -86.2419 426 35 9 382 Honduras
2936 2936       Hungary 2020-04-16 23:30:31 47.1625 19.5033 1652 142 199 1311 Hungary
2937 2937       Iceland 2020-04-16 23:30:31 64.9631 -19.0208 1739 8 1144 587 Iceland
2938 2938       India 2020-04-16 23:30:31 20.593684 78.96288 13430 448 1768 11214 India
2939 2939       Indonesia 2020-04-16 23:30:31 -0.7893 113.9213 5516 496 548 4472 Indonesia
2940 2940       Iran 2020-04-16 23:30:31 32.427908 53.68804599999999 77995 4869 52229 20897 Iran
2941 2941       Iraq 2020-04-16 23:30:31 33.223191 43.679291 1434 80 856 498 Iraq
2942 2942       Ireland 2020-04-16 23:30:31 53.1424 -7.6921 13271 486 77 12708 Ireland
2943 2943       Israel 2020-04-16 23:30:31 31.046051000000002 34.851612 12948 146 3174 9798 Israel
2944 2944       Italy 2020-04-16 23:30:31 41.87194 12.56738 168941 22170 40164 106607 Italy
2945 2945       Jamaica 2020-04-16 23:30:31 18.1096 -77.2975 143 5 21 117 Jamaica
2946 2946       Japan 2020-04-16 23:30:31 36.204824 138.252924 8626 178 901 7547 Japan
2947 2947       Jordan 2020-04-16 23:30:31 31.24 36.51 402 7 259 136 Jordan
2948 2948       Kazakhstan 2020-04-16 23:30:31 48.0196 66.9237 1402 17 277 1108 Kazakhstan
2949 2949       Kenya 2020-04-16 23:30:31 -0.0236 37.9062 234 11 53 170 Kenya
2950 2950       Korea, South 2020-04-16 23:30:31 35.90775700000001 127.766922 10613 229 7757 2627 Korea, South
2951 2951       Kosovo 2020-04-16 23:30:31 42.602636 20.902977 449 11 79 359 Kosovo
2952 2952       Kuwait 2020-04-16 23:30:31 29.311659999999996 47.481766 1524 3 225 1296 Kuwait
2953 2953       Kyrgyzstan 2020-04-16 23:30:31 41.20438 74.766098 466 5 91 370 Kyrgyzstan
2954 2954       Laos 2020-04-16 23:30:31 19.856270000000002 102.495496 19 0 2 17 Laos
2955 2955       Latvia 2020-04-16 23:30:31 56.8796 24.6032 675 5 57 613 Latvia
2956 2956       Lebanon 2020-04-16 23:30:31 33.8547 35.8623 663 21 86 556 Lebanon
2957 2957       Liberia 2020-04-16 23:30:31 6.4280550000000005 -9.429499 59 6 4 49 Liberia
2958 2958       Libya 2020-04-16 23:30:31 26.3351 17.228331 49 1 11 37 Libya
2959 2959       Liechtenstein 2020-04-16 23:30:31 47.14 9.55 79 1 55 23 Liechtenstein
2960 2960       Lithuania 2020-04-16 23:30:31 55.1694 23.8813 1022 20 16 918 Lithuania
2961 2961       Luxembourg 2020-04-16 23:30:31 49.8153 6.1296 3444 69 552 2823 Luxembourg
2962 2962       MS Zaandam 2020-04-16 23:30:31     9 2 0 7 MS Zaandam

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

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