04-13-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,003 rows sorted by Province_State

✎ View and edit SQL

This data as json, copyable, CSV (advanced)

Suggested facets: Last_Update, Last_Update (date)

Link rowid FIPS Admin2 Province_State ▼ Country_Region Last_Update Lat Long_ Confirmed Deaths Recovered Active Combined_Key
2823 2823       Afghanistan 2020-04-13 23:07:34 33.93911 67.709953 666 22 32 612 Afghanistan
2824 2824       Albania 2020-04-13 23:07:34 41.1533 20.1683 467 23 232 212 Albania
2825 2825       Algeria 2020-04-13 23:07:34 28.0339 1.6596 1983 313 601 1069 Algeria
2826 2826       Andorra 2020-04-13 23:07:34 42.5063 1.5218 646 29 128 489 Andorra
2827 2827       Angola 2020-04-13 23:07:34 -11.2027 17.8739 19 2 4 13 Angola
2828 2828       Antigua and Barbuda 2020-04-13 23:07:34 17.0608 -61.7964 23 2 0 21 Antigua and Barbuda
2829 2829       Argentina 2020-04-13 23:07:34 -38.4161 -63.6167 2208 97 515 1596 Argentina
2830 2830       Armenia 2020-04-13 23:07:34 40.0691 45.0382 1039 14 211 814 Armenia
2831 2831       Austria 2020-04-13 23:07:34 47.5162 14.5501 14041 368 7343 6330 Austria
2832 2832       Azerbaijan 2020-04-13 23:07:34 40.1431 47.5769 1148 12 289 847 Azerbaijan
2833 2833       Bahamas 2020-04-13 23:07:34 25.025885 -78.035889 47 8 6 33 Bahamas
2834 2834       Bahrain 2020-04-13 23:07:34 26.0275 50.55 1361 6 591 764 Bahrain
2835 2835       Bangladesh 2020-04-13 23:07:34 23.685 90.3563 803 39 42 722 Bangladesh
2836 2836       Barbados 2020-04-13 23:07:34 13.1939 -59.5432 72 4 13 55 Barbados
2837 2837       Belarus 2020-04-13 23:07:34 53.7098 27.9534 2919 29 203 2687 Belarus
2838 2838       Belgium 2020-04-13 23:07:34 50.8333 4.469936 30589 3903 6707 19979 Belgium
2839 2839       Belize 2020-04-13 23:07:34 17.1899 -88.4976 18 2 0 16 Belize
2840 2840       Benin 2020-04-13 23:07:34 9.3077 2.3158 35 1 5 29 Benin
2841 2841       Bhutan 2020-04-13 23:07:34 27.5142 90.4336 5 0 2 3 Bhutan
2842 2842       Bolivia 2020-04-13 23:07:34 -16.2902 -63.5887 330 27 2 301 Bolivia
2843 2843       Bosnia and Herzegovina 2020-04-13 23:07:34 43.9159 17.6791 1037 39 206 792 Bosnia and Herzegovina
2844 2844       Botswana 2020-04-13 23:07:34 -22.3285 24.6849 13 1 0 12 Botswana
2845 2845       Brazil 2020-04-13 23:07:34 -14.235 -51.9253 23430 1328 173 21929 Brazil
2846 2846       Brunei 2020-04-13 23:07:34 4.5353 114.7277 136 1 107 28 Brunei
2847 2847       Bulgaria 2020-04-13 23:07:34 42.7339 25.4858 685 32 71 582 Bulgaria
2848 2848       Burkina Faso 2020-04-13 23:07:34 12.2383 -1.5616 497 27 161 309 Burkina Faso
2849 2849       Burma 2020-04-13 23:07:34 21.9162 95.956 62 4 2 56 Burma
2850 2850       Burundi 2020-04-13 23:07:34 -3.3731 29.9189 5 1 0 4 Burundi
2851 2851       Cabo Verde 2020-04-13 23:07:34 16.5388 -23.0418 10 1 1 8 Cabo Verde
2852 2852       Cambodia 2020-04-13 23:07:34 11.55 104.9167 122 0 77 45 Cambodia
2853 2853       Cameroon 2020-04-13 23:07:34 3.8480000000000003 11.5021 820 12 98 710 Cameroon
2854 2854       Central African Republic 2020-04-13 23:07:34 6.6111 20.9394 11 0 3 8 Central African Republic
2855 2855       Chad 2020-04-13 23:07:34 15.4542 18.7322 23 0 2 21 Chad
2856 2856       Chile 2020-04-13 23:07:34 -35.6751 -71.543 7525 82 2367 5076 Chile
2857 2857       Colombia 2020-04-13 23:07:34 4.5709 -74.2973 2852 112 319 2421 Colombia
2858 2858       Congo (Brazzaville) 2020-04-13 23:07:34 -4.2634 15.2832 60 5 5 50 Congo (Brazzaville)
2859 2859       Congo (Kinshasa) 2020-04-13 23:07:34 -4.322447 15.307045 235 20 17 198 Congo (Kinshasa)
2860 2860       Costa Rica 2020-04-13 23:07:34 9.7489 -83.7534 612 3 62 547 Costa Rica
2861 2861       Cote d'Ivoire 2020-04-13 23:07:34 7.54 -5.5471 626 6 89 531 Cote d'Ivoire
2862 2862       Croatia 2020-04-13 23:07:34 45.1 15.2 1650 25 400 1225 Croatia
2863 2863       Cuba 2020-04-13 23:07:34 21.521757 -77.78116700000002 726 21 121 584 Cuba
2864 2864       Cyprus 2020-04-13 23:07:34 35.1264 33.4299 662 12 65 585 Cyprus
2865 2865       Czechia 2020-04-13 23:07:34 49.8175 15.472999999999999 6059 143 519 5397 Czechia
2866 2866       Denmark 2020-04-13 23:07:34 56.2639 9.5018 6318 285 2235 3798 Denmark
2867 2867       Diamond Princess 2020-04-13 23:07:34     712 11 619 82 Diamond Princess
2868 2868       Djibouti 2020-04-13 23:07:34 11.8251 42.5903 298 2 41 255 Djibouti
2869 2869       Dominica 2020-04-13 23:07:34 15.415 -61.371 16 0 8 8 Dominica
2870 2870       Dominican Republic 2020-04-13 23:07:34 18.7357 -70.1627 3167 177 152 2838 Dominican Republic
2871 2871       Ecuador 2020-04-13 23:07:34 -1.8312 -78.1834 7529 355 597 6577 Ecuador
2872 2872       Egypt 2020-04-13 23:07:34 26.820553000000004 30.802497999999996 2190 164 589 1437 Egypt
2873 2873       El Salvador 2020-04-13 23:07:34 13.7942 -88.8965 137 6 22 109 El Salvador
2874 2874       Equatorial Guinea 2020-04-13 23:07:34 1.6508 10.2679 21 0 4 17 Equatorial Guinea
2875 2875       Eritrea 2020-04-13 23:07:34 15.1794 39.7823 34 0 0 34 Eritrea
2876 2876       Estonia 2020-04-13 23:07:34 58.5953 25.0136 1332 28 102 1202 Estonia
2877 2877       Eswatini 2020-04-13 23:07:34 -26.5225 31.4659 15 0 7 8 Eswatini
2878 2878       Ethiopia 2020-04-13 23:07:34 9.145 40.4897 74 3 14 57 Ethiopia
2879 2879       Fiji 2020-04-13 23:07:34 -17.7134 178.065 16 0 0 16 Fiji
2880 2880       Finland 2020-04-13 23:07:34 61.92411 25.748151 3064 59 300 2705 Finland
2881 2881 250     France 2020-04-13 23:07:34 46.2276 2.2137 123317 14950 27718 94094 France
2882 2882       Gabon 2020-04-13 23:07:34 -0.8037 11.6094 57 1 1 55 Gabon
2883 2883       Gambia 2020-04-13 23:07:34 13.4432 -15.3101 9 1 2 6 Gambia
2884 2884       Georgia 2020-04-13 23:07:34 42.3154 43.3569 272 3 68 201 Georgia
2885 2885       Germany 2020-04-13 23:07:34 51.165690999999995 10.451526 130072 3194 64300 62578 Germany
2886 2886       Ghana 2020-04-13 23:07:34 7.9465 -1.0232 566 8 4 554 Ghana
2887 2887       Greece 2020-04-13 23:07:34 39.0742 21.8243 2145 99 269 1777 Greece
2888 2888       Grenada 2020-04-13 23:07:34 12.1165 -61.678999999999995 14 0 0 14 Grenada
2889 2889       Guatemala 2020-04-13 23:07:34 15.7835 -90.2308 156 5 19 132 Guatemala
2890 2890       Guinea 2020-04-13 23:07:34 9.9456 -9.6966 319 0 17 302 Guinea
2891 2891       Guinea-Bissau 2020-04-13 23:07:34 11.8037 -15.1804 38 0 0 38 Guinea-Bissau
2892 2892       Guyana 2020-04-13 23:07:34 4.860416000000002 -58.93018000000001 45 6 8 31 Guyana
2893 2893       Haiti 2020-04-13 23:07:34 18.9712 -72.2852 31 2 0 37 Haiti
2894 2894       Holy See 2020-04-13 23:07:34 41.9029 12.4534 8 0 2 6 Holy See
2895 2895       Honduras 2020-04-13 23:07:34 15.2 -86.2419 397 25 7 365 Honduras
2896 2896       Hungary 2020-04-13 23:07:34 47.1625 19.5033 1458 109 120 1229 Hungary
2897 2897       Iceland 2020-04-13 23:07:34 64.9631 -19.0208 1711 8 933 770 Iceland
2898 2898       India 2020-04-13 23:07:34 20.593684 78.96288 10453 358 1181 8914 India
2899 2899       Indonesia 2020-04-13 23:07:34 -0.7893 113.9213 4557 399 380 3778 Indonesia
2900 2900       Iran 2020-04-13 23:07:34 32.427908 53.68804599999999 73303 4585 45983 22735 Iran
2901 2901       Iraq 2020-04-13 23:07:34 33.223191 43.679291 1378 78 717 583 Iraq
2902 2902       Ireland 2020-04-13 23:07:34 53.1424 -7.6921 10647 365 25 10257 Ireland
2903 2903       Israel 2020-04-13 23:07:34 31.046051000000002 34.851612 11942 118 2228 9615 Israel
2904 2904       Italy 2020-04-13 23:07:34 41.87194 12.56738 159516 20465 35435 103616 Italy
2905 2905       Jamaica 2020-04-13 23:07:34 18.1096 -77.2975 73 4 19 50 Jamaica
2906 2906       Japan 2020-04-13 23:07:34 36.204824 138.252924 7370 123 784 6463 Japan
2907 2907       Jordan 2020-04-13 23:07:34 31.24 36.51 391 7 215 169 Jordan
2908 2908       Kazakhstan 2020-04-13 23:07:34 48.0196 66.9237 1091 12 138 941 Kazakhstan
2909 2909       Kenya 2020-04-13 23:07:34 -0.0236 37.9062 208 9 40 159 Kenya
2910 2910       Korea, South 2020-04-13 23:07:34 35.90775700000001 127.766922 10537 217 7447 2873 Korea, South
2911 2911       Kosovo 2020-04-13 23:07:34 42.602636 20.902977 283 7 58 218 Kosovo
2912 2912       Kuwait 2020-04-13 23:07:34 29.311659999999996 47.481766 1300 2 150 1148 Kuwait
2913 2913       Kyrgyzstan 2020-04-13 23:07:34 41.20438 74.766098 419 5 67 347 Kyrgyzstan
2914 2914       Laos 2020-04-13 23:07:34 19.856270000000002 102.495496 19 0 0 19 Laos
2915 2915       Latvia 2020-04-13 23:07:34 56.8796 24.6032 655 5 16 634 Latvia
2916 2916       Lebanon 2020-04-13 23:07:34 33.8547 35.8623 632 20 80 532 Lebanon
2917 2917       Liberia 2020-04-13 23:07:34 6.4280550000000005 -9.429499 59 6 4 49 Liberia
2918 2918       Libya 2020-04-13 23:07:34 26.3351 17.228331 26 1 9 16 Libya
2919 2919       Liechtenstein 2020-04-13 23:07:34 47.14 9.55 79 1 55 23 Liechtenstein
2920 2920       Lithuania 2020-04-13 23:07:34 55.1694 23.8813 970 15 5 937 Lithuania
2921 2921       Luxembourg 2020-04-13 23:07:34 49.8153 6.1296 3292 69 500 2723 Luxembourg
2922 2922       MS Zaandam 2020-04-13 23:07:34     9 2 0 7 MS Zaandam

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

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