04-11-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

2,967 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
2786 2786       Afghanistan 2020-04-11 22:45:13 33.93911 67.709953 556 18 32 505 Afghanistan
2787 2787       Albania 2020-04-11 22:45:13 41.1533 20.1683 433 23 197 213 Albania
2788 2788       Algeria 2020-04-11 22:45:13 28.0339 1.6596 1825 275 460 1090 Algeria
2789 2789       Andorra 2020-04-11 22:45:13 42.5063 1.5218 601 26 71 504 Andorra
2790 2790       Angola 2020-04-11 22:45:13 -11.2027 17.8739 19 2 4 13 Angola
2791 2791       Antigua and Barbuda 2020-04-11 22:45:13 17.0608 -61.7964 21 2 0 19 Antigua and Barbuda
2792 2792       Argentina 2020-04-11 22:45:13 -38.4161 -63.6167 1975 83 440 1452 Argentina
2793 2793       Armenia 2020-04-11 22:45:13 40.0691 45.0382 967 13 173 781 Armenia
2794 2794       Austria 2020-04-11 22:45:13 47.5162 14.5501 13806 337 6604 6865 Austria
2795 2795       Azerbaijan 2020-04-11 22:45:13 40.1431 47.5769 1058 11 200 847 Azerbaijan
2796 2796       Bahamas 2020-04-11 22:45:13 25.025885 -78.035889 46 8 5 33 Bahamas
2797 2797       Bahrain 2020-04-11 22:45:13 26.0275 50.55 1040 6 555 479 Bahrain
2798 2798       Bangladesh 2020-04-11 22:45:13 23.685 90.3563 482 30 36 416 Bangladesh
2799 2799       Barbados 2020-04-11 22:45:13 13.1939 -59.5432 68 4 11 53 Barbados
2800 2800       Belarus 2020-04-11 22:45:13 53.7098 27.9534 2226 23 172 2031 Belarus
2801 2801       Belgium 2020-04-11 22:45:13 50.8333 4.469936 28018 3346 5986 18686 Belgium
2802 2802       Belize 2020-04-11 22:45:13 17.1899 -88.4976 13 2 0 11 ,,Belize
2803 2803       Benin 2020-04-11 22:45:13 9.3077 2.3158 35 1 5 29 Benin
2804 2804       Bhutan 2020-04-11 22:45:13 27.5142 90.4336 5 0 2 3 Bhutan
2805 2805       Bolivia 2020-04-11 22:45:13 -16.2902 -63.5887 275 20 2 253 Bolivia
2806 2806       Bosnia and Herzegovina 2020-04-11 22:45:13 43.9159 17.6791 946 37 139 770 Bosnia and Herzegovina
2807 2807       Botswana 2020-04-11 22:45:13 -22.3285 24.6849 13 1 0 12 Botswana
2808 2808       Brazil 2020-04-11 22:45:13 -14.235 -51.9253 20727 1124 173 19430 Brazil
2809 2809       Brunei 2020-04-11 22:45:13 4.5353 114.7277 136 1 104 31 Brunei
2810 2810       Bulgaria 2020-04-11 22:45:13 42.7339 25.4858 661 28 62 571 Bulgaria
2811 2811       Burkina Faso 2020-04-11 22:45:13 12.2383 -1.5616 484 27 155 302 Burkina Faso
2812 2812       Burma 2020-04-11 22:45:13 21.9162 95.956 38 3 2 33 Burma
2813 2813       Burundi 2020-04-11 22:45:13 -3.3731 29.9189 5 0 0 5 Burundi
2814 2814       Cabo Verde 2020-04-11 22:45:13 16.5388 -23.0418 8 1 1 6 Cabo Verde
2815 2815       Cambodia 2020-04-11 22:45:13 11.55 104.9167 120 0 75 45 Cambodia
2816 2816       Cameroon 2020-04-11 22:45:13 3.8480000000000003 11.5021 820 12 98 710 Cameroon
2817 2817       Central African Republic 2020-04-11 22:45:13 6.6111 20.9394 8 0 0 8 Central African Republic
2818 2818       Chad 2020-04-11 22:45:13 15.4542 18.7322 11 0 2 9 Chad
2819 2819       Chile 2020-04-11 22:45:13 -35.6751 -71.543 6927 73 1864 4990 Chile
2820 2820       Colombia 2020-04-11 22:45:13 4.5709 -74.2973 2709 100 214 2395 Colombia
2821 2821       Congo (Brazzaville) 2020-04-11 22:45:13 -4.2634 15.2832 60 5 5 50 Congo (Brazzaville)
2822 2822       Congo (Kinshasa) 2020-04-11 22:45:13 -4.322447 15.307045 223 20 16 187 Congo (Kinshasa)
2823 2823       Costa Rica 2020-04-11 22:45:13 9.7489 -83.7534 577 3 49 525 Costa Rica
2824 2824       Cote d'Ivoire 2020-04-11 22:45:13 7.54 -5.5471 533 4 58 471 Cote d'Ivoire
2825 2825       Croatia 2020-04-11 22:45:13 45.1 15.2 1534 21 323 1190 Croatia
2826 2826       Cuba 2020-04-11 22:45:13 21.521757 -77.78116700000002 620 16 77 527 Cuba
2827 2827       Cyprus 2020-04-11 22:45:13 35.1264 33.4299 616 10 61 545 Cyprus
2828 2828       Czechia 2020-04-11 22:45:13 49.8175 15.472999999999999 5831 129 411 5291 Czechia
2829 2829       Denmark 2020-04-11 22:45:13 56.2639 9.5018 5996 260 1955 3781 Denmark
2830 2830       Diamond Princess 2020-04-11 22:45:13     712 11 619 82 Diamond Princess
2831 2831       Djibouti 2020-04-11 22:45:13 11.8251 42.5903 187 2 36 149 Djibouti
2832 2832       Dominica 2020-04-11 22:45:13 15.415 -61.371 16 0 5 11 Dominica
2833 2833       Dominican Republic 2020-04-11 22:45:13 18.7357 -70.1627 2759 135 108 2516 Dominican Republic
2834 2834       Ecuador 2020-04-11 22:45:13 -1.8312 -78.1834 7257 315 411 6531 Ecuador
2835 2835       Egypt 2020-04-11 22:45:13 26.820553000000004 30.802497999999996 1939 146 426 1367 Egypt
2836 2836       El Salvador 2020-04-11 22:45:13 13.7942 -88.8965 118 6 19 93 El Salvador
2837 2837       Equatorial Guinea 2020-04-11 22:45:13 1.6508 10.2679 18 0 3 15 Equatorial Guinea
2838 2838       Eritrea 2020-04-11 22:45:13 15.1794 39.7823 34 0 0 34 Eritrea
2839 2839       Estonia 2020-04-11 22:45:13 58.5953 25.0136 1304 24 93 1187 Estonia
2840 2840       Eswatini 2020-04-11 22:45:13 -26.5225 31.4659 12 0 7 5 Eswatini
2841 2841       Ethiopia 2020-04-11 22:45:13 9.145 40.4897 69 3 10 56 Ethiopia
2842 2842       Fiji 2020-04-11 22:45:13 -17.7134 178.065 16 0 0 16 Fiji
2843 2843       Finland 2020-04-11 22:45:13 61.92411 25.748151 2905 49 300 2556 Finland
2844 2844 250     France 2020-04-11 22:45:13 46.2276 2.2137 92836 13816 26391 89431 ,,France
2845 2845       Gabon 2020-04-11 22:45:13 -0.8037 11.6094 46 1 1 44 Gabon
2846 2846       Gambia 2020-04-11 22:45:13 13.4432 -15.3101 9 1 2 6 Gambia
2847 2847       Georgia 2020-04-11 22:45:13 42.3154 43.3569 242 3 60 179 Georgia
2848 2848       Germany 2020-04-11 22:45:13 51.165690999999995 10.451526 124908 2736 57400 64772 Germany
2849 2849       Ghana 2020-04-11 22:45:13 7.9465 -1.0232 408 8 4 396 Ghana
2850 2850       Greece 2020-04-11 22:45:13 39.0742 21.8243 2081 93 269 1719 Greece
2851 2851       Grenada 2020-04-11 22:45:13 12.1165 -61.678999999999995 14 0 0 14 Grenada
2852 2852       Guatemala 2020-04-11 22:45:13 15.7835 -90.2308 137 3 19 115 Guatemala
2853 2853       Guinea 2020-04-11 22:45:13 9.9456 -9.6966 250 0 17 233 Guinea
2854 2854       Guinea-Bissau 2020-04-11 22:45:13 11.8037 -15.1804 38 0 0 38 Guinea-Bissau
2855 2855       Guyana 2020-04-11 22:45:13 4.860416000000002 -58.93018000000001 45 6 8 31 Guyana
2856 2856       Haiti 2020-04-11 22:45:13 18.9712 -72.2852 30 2 0 31 Haiti
2857 2857       Holy See 2020-04-11 22:45:13 41.9029 12.4534 8 0 2 6 Holy See
2858 2858       Honduras 2020-04-11 22:45:13 15.2 -86.2419 392 24 7 361 Honduras
2859 2859       Hungary 2020-04-11 22:45:13 47.1625 19.5033 1310 85 115 1110 Hungary
2860 2860       Iceland 2020-04-11 22:45:13 64.9631 -19.0208 1689 8 841 840 Iceland
2861 2861       India 2020-04-11 22:45:13 20.593684 78.96288 8446 288 969 7189 India
2862 2862       Indonesia 2020-04-11 22:45:13 -0.7893 113.9213 3842 327 286 3229 Indonesia
2863 2863       Iran 2020-04-11 22:45:13 32.427908 53.68804599999999 70029 4357 41947 23725 Iran
2864 2864       Iraq 2020-04-11 22:45:13 33.223191 43.679291 1318 72 601 645 Iraq
2865 2865       Ireland 2020-04-11 22:45:13 53.1424 -7.6921 8928 320 25 8583 Ireland
2866 2866       Israel 2020-04-11 22:45:13 31.046051000000002 34.851612 10952 103 1611 9301 Israel
2867 2867       Italy 2020-04-11 22:45:13 41.87194 12.56738 152271 19468 32534 100269 Italy
2868 2868       Jamaica 2020-04-11 22:45:13 18.1096 -77.2975 65 4 13 48 Jamaica
2869 2869       Japan 2020-04-11 22:45:13 36.204824 138.252924 6005 99 762 5144 Japan
2870 2870       Jordan 2020-04-11 22:45:13 31.24 36.51 381 7 177 197 Jordan
2871 2871       Kazakhstan 2020-04-11 22:45:13 48.0196 66.9237 865 10 81 774 Kazakhstan
2872 2872       Kenya 2020-04-11 22:45:13 -0.0236 37.9062 191 7 24 160 Kenya
2873 2873       Korea, South 2020-04-11 22:45:13 35.90775700000001 127.766922 10480 211 7243 3026 Korea, South
2874 2874       Kosovo 2020-04-11 22:45:13 42.602636 20.902977 283 7 58 218 Kosovo
2875 2875       Kuwait 2020-04-11 22:45:13 29.311659999999996 47.481766 1154 1 133 1020 Kuwait
2876 2876       Kyrgyzstan 2020-04-11 22:45:13 41.20438 74.766098 339 5 44 290 Kyrgyzstan
2877 2877       Laos 2020-04-11 22:45:13 19.856270000000002 102.495496 18 0 0 18 Laos
2878 2878       Latvia 2020-04-11 22:45:13 56.8796 24.6032 630 3 16 611 Latvia
2879 2879       Lebanon 2020-04-11 22:45:13 33.8547 35.8623 619 20 77 522 Lebanon
2880 2880       Liberia 2020-04-11 22:45:13 6.4280550000000005 -9.429499 48 5 3 40 Liberia
2881 2881       Libya 2020-04-11 22:45:13 26.3351 17.228331 24 1 8 15 Libya
2882 2882       Liechtenstein 2020-04-11 22:45:13 47.14 9.55 79 1 55 23 Liechtenstein
2883 2883       Lithuania 2020-04-11 22:45:13 55.1694 23.8813 926 13 2 949 Lithuania
2884 2884       Luxembourg 2020-04-11 22:45:13 49.8153 6.1296 3270 62 500 2708 Luxembourg
2885 2885       MS Zaandam 2020-04-11 22:45:13     9 2 0 7 ,,MS Zaandam

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

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