04-14-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,015 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
2835 2835       Afghanistan 2020-04-14 23:33:12 33.93911 67.709953 715 23 40 651 Afghanistan
2836 2836       Albania 2020-04-14 23:33:12 41.1533 20.1683 475 24 248 203 Albania
2837 2837       Algeria 2020-04-14 23:33:12 28.0339 1.6596 2070 326 691 1053 Algeria
2838 2838       Andorra 2020-04-14 23:33:12 42.5063 1.5218 659 31 128 500 Andorra
2839 2839       Angola 2020-04-14 23:33:12 -11.2027 17.8739 19 2 5 12 Angola
2840 2840       Antigua and Barbuda 2020-04-14 23:33:12 17.0608 -61.7964 23 2 3 18 Antigua and Barbuda
2841 2841       Argentina 2020-04-14 23:33:12 -38.4161 -63.6167 2277 102 559 1616 Argentina
2842 2842       Armenia 2020-04-14 23:33:12 40.0691 45.0382 1067 16 265 786 Armenia
2843 2843       Austria 2020-04-14 23:33:12 47.5162 14.5501 14226 384 7633 6209 Austria
2844 2844       Azerbaijan 2020-04-14 23:33:12 40.1431 47.5769 1197 13 351 833 Azerbaijan
2845 2845       Bahamas 2020-04-14 23:33:12 25.025885 -78.035889 49 8 6 35 Bahamas
2846 2846       Bahrain 2020-04-14 23:33:12 26.0275 50.55 1528 7 645 876 Bahrain
2847 2847       Bangladesh 2020-04-14 23:33:12 23.685 90.3563 1012 46 42 924 Bangladesh
2848 2848       Barbados 2020-04-14 23:33:12 13.1939 -59.5432 72 4 13 55 Barbados
2849 2849       Belarus 2020-04-14 23:33:12 53.7098 27.9534 3281 33 203 3045 Belarus
2850 2850       Belgium 2020-04-14 23:33:12 50.8333 4.469936 31119 4157 6868 20094 Belgium
2851 2851       Belize 2020-04-14 23:33:12 17.1899 -88.4976 18 2 0 16 Belize
2852 2852       Benin 2020-04-14 23:33:12 9.3077 2.3158 35 1 18 16 Benin
2853 2853       Bhutan 2020-04-14 23:33:12 27.5142 90.4336 5 0 2 3 Bhutan
2854 2854       Bolivia 2020-04-14 23:33:12 -16.2902 -63.5887 354 28 6 320 Bolivia
2855 2855       Bosnia and Herzegovina 2020-04-14 23:33:12 43.9159 17.6791 1083 40 236 807 Bosnia and Herzegovina
2856 2856       Botswana 2020-04-14 23:33:12 -22.3285 24.6849 13 1 0 12 Botswana
2857 2857       Brazil 2020-04-14 23:33:12 -14.235 -51.9253 25262 1532 3046 20684 Brazil
2858 2858       Brunei 2020-04-14 23:33:12 4.5353 114.7277 136 1 107 28 Brunei
2859 2859       Bulgaria 2020-04-14 23:33:12 42.7339 25.4858 713 35 81 597 Bulgaria
2860 2860       Burkina Faso 2020-04-14 23:33:12 12.2383 -1.5616 528 30 177 321 Burkina Faso
2861 2861       Burma 2020-04-14 23:33:12 21.9162 95.956 63 4 2 57 Burma
2862 2862       Burundi 2020-04-14 23:33:12 -3.3731 29.9189 5 1 0 4 Burundi
2863 2863       Cabo Verde 2020-04-14 23:33:12 16.5388 -23.0418 11 1 1 9 Cabo Verde
2864 2864       Cambodia 2020-04-14 23:33:12 11.55 104.9167 122 0 91 31 Cambodia
2865 2865       Cameroon 2020-04-14 23:33:12 3.8480000000000003 11.5021 848 14 130 704 Cameroon
2866 2866       Central African Republic 2020-04-14 23:33:12 6.6111 20.9394 11 0 4 7 Central African Republic
2867 2867       Chad 2020-04-14 23:33:12 15.4542 18.7322 23 0 2 21 Chad
2868 2868       Chile 2020-04-14 23:33:12 -35.6751 -71.543 7917 92 2646 5179 Chile
2869 2869       Colombia 2020-04-14 23:33:12 4.5709 -74.2973 2979 127 354 2498 Colombia
2870 2870       Congo (Brazzaville) 2020-04-14 23:33:12 -4.2634 15.2832 60 5 5 50 Congo (Brazzaville)
2871 2871       Congo (Kinshasa) 2020-04-14 23:33:12 -4.322447 15.307045 241 20 20 201 Congo (Kinshasa)
2872 2872       Costa Rica 2020-04-14 23:33:12 9.7489 -83.7534 618 3 66 549 Costa Rica
2873 2873       Cote d'Ivoire 2020-04-14 23:33:12 7.54 -5.5471 638 6 114 518 Cote d'Ivoire
2874 2874       Croatia 2020-04-14 23:33:12 45.1 15.2 1704 31 415 1258 Croatia
2875 2875       Cuba 2020-04-14 23:33:12 21.521757 -77.78116700000002 766 21 132 613 Cuba
2876 2876       Cyprus 2020-04-14 23:33:12 35.1264 33.4299 695 12 65 618 Cyprus
2877 2877       Czechia 2020-04-14 23:33:12 49.8175 15.472999999999999 6111 161 642 5308 Czechia
2878 2878       Denmark 2020-04-14 23:33:12 56.2639 9.5018 6511 299 2515 3697 Denmark
2879 2879       Diamond Princess 2020-04-14 23:33:12     712 12 639 61 Diamond Princess
2880 2880       Djibouti 2020-04-14 23:33:12 11.8251 42.5903 363 2 53 308 Djibouti
2881 2881       Dominica 2020-04-14 23:33:12 15.415 -61.371 16 0 8 8 Dominica
2882 2882       Dominican Republic 2020-04-14 23:33:12 18.7357 -70.1627 3286 183 162 2941 Dominican Republic
2883 2883       Ecuador 2020-04-14 23:33:12 -1.8312 -78.1834 7603 369 696 6538 Ecuador
2884 2884       Egypt 2020-04-14 23:33:12 26.820553000000004 30.802497999999996 2350 178 589 1583 Egypt
2885 2885       El Salvador 2020-04-14 23:33:12 13.7942 -88.8965 149 6 25 118 El Salvador
2886 2886       Equatorial Guinea 2020-04-14 23:33:12 1.6508 10.2679 41 0 4 37 Equatorial Guinea
2887 2887       Eritrea 2020-04-14 23:33:12 15.1794 39.7823 34 0 0 34 Eritrea
2888 2888       Estonia 2020-04-14 23:33:12 58.5953 25.0136 1373 31 115 1227 Estonia
2889 2889       Eswatini 2020-04-14 23:33:12 -26.5225 31.4659 15 0 8 7 Eswatini
2890 2890       Ethiopia 2020-04-14 23:33:12 9.145 40.4897 82 3 14 65 Ethiopia
2891 2891       Fiji 2020-04-14 23:33:12 -17.7134 178.065 16 0 0 16 Fiji
2892 2892       Finland 2020-04-14 23:33:12 61.92411 25.748151 3161 64 300 2797 Finland
2893 2893 250     France 2020-04-14 23:33:12 46.2276 2.2137 129268 15710 28805 85719 France
2894 2894       Gabon 2020-04-14 23:33:12 -0.8037 11.6094 57 1 1 55 Gabon
2895 2895       Gambia 2020-04-14 23:33:12 13.4432 -15.3101 9 1 2 6 Gambia
2896 2896       Georgia 2020-04-14 23:33:12 42.3154 43.3569 300 3 69 228 Georgia
2897 2897       Germany 2020-04-14 23:33:12 51.165690999999995 10.451526 131359 3294 68200 59865 Germany
2898 2898       Ghana 2020-04-14 23:33:12 7.9465 -1.0232 636 8 17 611 Ghana
2899 2899       Greece 2020-04-14 23:33:12 39.0742 21.8243 2170 101 269 1800 Greece
2900 2900       Grenada 2020-04-14 23:33:12 12.1165 -61.678999999999995 14 0 0 14 Grenada
2901 2901       Guatemala 2020-04-14 23:33:12 15.7835 -90.2308 167 5 19 143 Guatemala
2902 2902       Guinea 2020-04-14 23:33:12 9.9456 -9.6966 363 0 31 332 Guinea
2903 2903       Guinea-Bissau 2020-04-14 23:33:12 11.8037 -15.1804 38 0 0 38 Guinea-Bissau
2904 2904       Guyana 2020-04-14 23:33:12 4.860416000000002 -58.93018000000001 47 6 8 33 Guyana
2905 2905       Haiti 2020-04-14 23:33:12 18.9712 -72.2852 40 3 0 37 Haiti
2906 2906       Holy See 2020-04-14 23:33:12 41.9029 12.4534 8 0 2 6 Holy See
2907 2907       Honduras 2020-04-14 23:33:12 15.2 -86.2419 407 26 7 374 Honduras
2908 2908       Hungary 2020-04-14 23:33:12 47.1625 19.5033 1512 122 122 1268 Hungary
2909 2909       Iceland 2020-04-14 23:33:12 64.9631 -19.0208 1720 8 989 723 Iceland
2910 2910       India 2020-04-14 23:33:12 20.593684 78.96288 11487 393 1359 9735 India
2911 2911       Indonesia 2020-04-14 23:33:12 -0.7893 113.9213 4839 459 426 3954 Indonesia
2912 2912       Iran 2020-04-14 23:33:12 32.427908 53.68804599999999 74877 4683 48129 22065 Iran
2913 2913       Iraq 2020-04-14 23:33:12 33.223191 43.679291 1400 78 766 556 Iraq
2914 2914       Ireland 2020-04-14 23:33:12 53.1424 -7.6921 11479 406 25 11048 Ireland
2915 2915       Israel 2020-04-14 23:33:12 31.046051000000002 34.851612 12341 126 2551 9728 Israel
2916 2916       Italy 2020-04-14 23:33:12 41.87194 12.56738 162488 21067 37130 104291 Italy
2917 2917       Jamaica 2020-04-14 23:33:12 18.1096 -77.2975 73 4 19 50 Jamaica
2918 2918       Japan 2020-04-14 23:33:12 36.204824 138.252924 7645 143 799 6703 Japan
2919 2919       Jordan 2020-04-14 23:33:12 31.24 36.51 397 7 235 155 Jordan
2920 2920       Kazakhstan 2020-04-14 23:33:12 48.0196 66.9237 1232 14 203 1015 Kazakhstan
2921 2921       Kenya 2020-04-14 23:33:12 -0.0236 37.9062 216 9 41 166 Kenya
2922 2922       Korea, South 2020-04-14 23:33:12 35.90775700000001 127.766922 10564 222 7534 2808 Korea, South
2923 2923       Kosovo 2020-04-14 23:33:12 42.602636 20.902977 387 8 66 313 Kosovo
2924 2924       Kuwait 2020-04-14 23:33:12 29.311659999999996 47.481766 1355 3 176 1176 Kuwait
2925 2925       Kyrgyzstan 2020-04-14 23:33:12 41.20438 74.766098 430 5 71 354 Kyrgyzstan
2926 2926       Laos 2020-04-14 23:33:12 19.856270000000002 102.495496 19 0 1 18 Laos
2927 2927       Latvia 2020-04-14 23:33:12 56.8796 24.6032 657 5 16 636 Latvia
2928 2928       Lebanon 2020-04-14 23:33:12 33.8547 35.8623 641 21 80 540 Lebanon
2929 2929       Liberia 2020-04-14 23:33:12 6.4280550000000005 -9.429499 59 6 4 49 Liberia
2930 2930       Libya 2020-04-14 23:33:12 26.3351 17.228331 35 1 9 25 Libya
2931 2931       Liechtenstein 2020-04-14 23:33:12 47.14 9.55 79 1 55 23 Liechtenstein
2932 2932       Lithuania 2020-04-14 23:33:12 55.1694 23.8813 977 16 7 940 Lithuania
2933 2933       Luxembourg 2020-04-14 23:33:12 49.8153 6.1296 3307 67 500 2740 Luxembourg
2934 2934       MS Zaandam 2020-04-14 23:33:12     9 2 0 7 MS Zaandam

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

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