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 rowid descending

✎ 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
2967 2967   unassigned Utah US 2020-04-11 22:45:33     0 5 0 0 unassigned, Utah, US
2966 2966       Zimbabwe 2020-04-11 22:45:13 -19.015438 29.154857 14 3 0 11 Zimbabwe
2965 2965       Zambia 2020-04-11 22:45:13 -13.133897 27.849332 40 2 28 10 Zambia
2964 2964       Yemen 2020-04-11 22:45:13 15.552726999999999 48.516388 1 0 0 1 Yemen
2963 2963       West Bank and Gaza 2020-04-11 22:45:13 31.9522 35.2332 268 2 57 209 West Bank and Gaza
2962 2962       Vietnam 2020-04-11 22:45:13 14.058323999999999 108.277199 258 0 144 114 Vietnam
2961 2961       Venezuela 2020-04-11 22:45:13 6.4238 -66.5897 175 9 93 73 Venezuela
2960 2960       Uzbekistan 2020-04-11 22:45:13 41.377491 64.585262 767 4 42 721 Uzbekistan
2959 2959       Uruguay 2020-04-11 22:45:13 -32.5228 -55.7658 494 7 214 273 Uruguay
2958 2958       United Kingdom 2020-04-11 22:45:13 55.3781 -3.4360000000000004 78991 9875 344 68772 United Kingdom
2957 2957       United Arab Emirates 2020-04-11 22:45:13 23.424076 53.847818000000004 3736 20 588 3128 United Arab Emirates
2956 2956       Ukraine 2020-04-11 22:45:13 48.3794 31.1656 2511 73 79 2359 Ukraine
2955 2955       Uganda 2020-04-11 22:45:13 1.373333 32.290275 53 0 4 49 Uganda
2954 2954       Turkey 2020-04-11 22:45:13 38.9637 35.2433 52167 1101 2965 48101 Turkey
2953 2953       Tunisia 2020-04-11 22:45:13 33.886917 9.537499 685 28 43 614 Tunisia
2952 2952       Trinidad and Tobago 2020-04-11 22:45:13 10.6918 -61.2225 112 8 12 92 Trinidad and Tobago
2951 2951       Togo 2020-04-11 22:45:13 8.6195 0.8248 76 3 25 48 Togo
2950 2950       Timor-Leste 2020-04-11 22:45:13 -8.874217 125.727539 2 0 1 1 Timor-Leste
2949 2949       Thailand 2020-04-11 22:45:13 15.870032 100.992541 2518 35 1135 1348 Thailand
2948 2948       Tanzania 2020-04-11 22:45:13 -6.369028 34.888822 32 3 5 24 Tanzania
2947 2947       Taiwan* 2020-04-11 08:05:21 23.7 121.0 385 6 99 280 Taiwan*
2946 2946       Syria 2020-04-11 22:45:13 34.802075 38.99681500000001 25 2 5 18 Syria
2945 2945       Switzerland 2020-04-11 22:45:13 46.8182 8.2275 25107 1036 12100 11971 Switzerland
2944 2944       Sweden 2020-04-11 22:45:13 60.128161 18.643501 10151 887 381 8883 Sweden
2943 2943       Suriname 2020-04-11 22:45:13 3.9193 -56.0278 10 1 4 5 Suriname
2942 2942       Sudan 2020-04-11 22:45:13 12.8628 30.2176 19 2 2 15 Sudan
2941 2941       Sri Lanka 2020-04-11 22:45:13 7.873054 80.77179699999998 198 7 54 137 Sri Lanka
2940 2940       Spain 2020-04-11 22:45:13 40.463667 -3.7492199999999998 163027 16606 59109 87312 Spain
2939 2939       South Sudan 2020-04-11 22:45:13 6.8770000000000024 31.307 4 0 0 4 South Sudan
2938 2938       South Africa 2020-04-11 22:45:13 -30.5595 22.9375 2028 25 410 1593 South Africa
2937 2937       Somalia 2020-04-11 22:45:13 5.152149 46.199616 21 1 1 19 Somalia
2936 2936       Slovenia 2020-04-11 22:45:13 46.1512 14.9955 1188 50 148 990 Slovenia
2935 2935       Slovakia 2020-04-11 22:45:13 48.669 19.699 728 2 23 703 Slovakia
2934 2934       Singapore 2020-04-11 22:45:13 1.2833 103.8333 2299 8 528 1763 Singapore
2933 2933       Sierra Leone 2020-04-11 22:45:13 8.460555000000001 -11.779889 8 0 0 8 Sierra Leone
2932 2932       Seychelles 2020-04-11 22:45:13 -4.6796 55.492 11 0 0 11 Seychelles
2931 2931       Serbia 2020-04-11 22:45:13 44.0165 21.0059 3380 74 0 3306 Serbia
2930 2930       Senegal 2020-04-11 22:45:13 14.4974 -14.4524 278 2 152 124 Senegal
2929 2929       Saudi Arabia 2020-04-11 22:45:13 23.885942 45.079162 4033 52 720 3261 Saudi Arabia
2928 2928       Sao Tome and Principe 2020-04-11 22:45:13 0.18636 6.613081 4 0 0 4 Sao Tome and Principe
2927 2927       San Marino 2020-04-11 22:45:13 43.9424 12.4578 356 35 53 268 San Marino
2926 2926       Samoa 2020-04-11 22:52:28 -13.759 -172.1046 0 0 0 0 Samoa
2925 2925       Saint Vincent and the Grenadines 2020-04-11 22:45:13 12.9843 -61.2872 12 0 1 11 Saint Vincent and the Grenadines
2924 2924       Saint Lucia 2020-04-11 22:45:13 13.9094 -60.9789 15 0 1 14 Saint Lucia
2923 2923       Saint Kitts and Nevis 2020-04-11 22:45:13 17.357822 -62.782998 12 0 0 12 Saint Kitts and Nevis
2922 2922       Rwanda 2020-04-11 22:45:13 -1.9403 29.8739 120 0 18 102 Rwanda
2921 2921       Russia 2020-04-11 22:45:13 61.52401 105.31875600000001 13584 106 1045 12433 Russia
2920 2920       Romania 2020-04-11 22:45:13 45.9432 24.9668 5990 291 758 4941 Romania
2919 2919       Qatar 2020-04-11 22:45:13 25.3548 51.1839 2728 6 247 2475 Qatar
2918 2918       Portugal 2020-04-11 22:45:13 39.3999 -8.2245 15987 470 266 15251 Portugal
2917 2917       Poland 2020-04-11 22:45:13 51.9194 19.1451 6356 208 375 5773 Poland
2916 2916       Philippines 2020-04-11 22:45:13 12.879721 121.77401699999999 4428 247 157 4024 Philippines
2915 2915       Peru 2020-04-11 22:45:13 -9.19 -75.0152 6848 181 1739 4928 Peru
2914 2914       Paraguay 2020-04-11 22:45:13 -23.4425 -58.4438 133 6 18 109 Paraguay
2913 2913       Papua New Guinea 2020-04-11 22:45:13 -6.314993 143.95555 2 0 0 2 Papua New Guinea
2912 2912       Panama 2020-04-11 22:45:13 8.538 -80.7821 2974 74 17 2883 Panama
2911 2911       Pakistan 2020-04-11 22:45:13 30.3753 69.3451 5011 86 762 4163 Pakistan
2910 2910       Oman 2020-04-11 22:45:13 21.512583 55.92325500000001 546 3 109 434 Oman
2909 2909       Norway 2020-04-11 22:45:13 60.472 8.4689 6409 119 32 6258 Norway
2908 2908       North Macedonia 2020-04-11 22:45:13 41.6086 21.7453 760 34 41 685 North Macedonia
2907 2907       Nigeria 2020-04-11 22:45:13 9.082 8.6753 318 10 70 238 Nigeria
2906 2906       Niger 2020-04-11 22:45:13 17.607789 8.081666 491 11 41 439 Niger
2905 2905       Nicaragua 2020-04-11 22:45:13 12.865416 -85.207229 8 1 0 7 Nicaragua
2904 2904       New Zealand 2020-04-11 22:45:13 -40.9006 174.886 1312 4 422 886 New Zealand
2903 2903       Netherlands 2020-04-11 22:45:13 52.1326 5.2913 24413 2643 250 21520 Netherlands
2902 2902       Nepal 2020-04-11 22:45:13 28.1667 84.25 9 0 1 8 Nepal
2901 2901       Namibia 2020-04-11 22:45:13 -22.9576 18.4904 16 0 3 13 Namibia
2900 2900       Mozambique 2020-04-11 22:45:13 -18.665695 35.529562 20 0 2 18 Mozambique
2899 2899       Morocco 2020-04-11 22:45:13 31.7917 -7.0926 1545 111 146 1288 Morocco
2898 2898       Montenegro 2020-04-11 22:45:13 42.708678000000006 19.37439 263 2 5 256 Montenegro
2897 2897       Mongolia 2020-04-11 22:45:13 46.8625 103.8467 16 0 4 12 Mongolia
2896 2896       Monaco 2020-04-11 22:45:13 43.7333 7.4167 92 1 5 86 Monaco
2895 2895       Moldova 2020-04-11 22:45:13 47.4116 28.3699 1560 30 75 1455 Moldova
2894 2894       Mexico 2020-04-11 22:45:13 23.6345 -102.5528 3844 233 633 2978 Mexico
2893 2893       Mauritius 2020-04-11 22:45:13 -20.348404000000002 57.552152 319 9 28 282 Mauritius
2892 2892       Mauritania 2020-04-11 22:45:13 21.0079 -10.9408 7 1 2 4 ,,Mauritania
2891 2891       Malta 2020-04-11 22:45:13 35.9375 14.3754 370 3 16 351 Malta
2890 2890       Mali 2020-04-11 22:45:13 17.570692 -3.996166000000001 87 7 22 58 Mali
2889 2889       Maldives 2020-04-11 22:45:13 3.2028 73.2207 19 0 13 6 Maldives
2888 2888       Malaysia 2020-04-11 22:45:13 4.210483999999999 101.97576600000001 4530 73 1995 2462 Malaysia
2887 2887       Malawi 2020-04-11 22:45:13 -13.254307999999998 34.301525 12 2 0 10 Malawi
2886 2886       Madagascar 2020-04-11 22:45:13 -18.766947000000002 46.869107 102 0 11 91 Madagascar
2885 2885       MS Zaandam 2020-04-11 22:45:13     9 2 0 7 ,,MS Zaandam
2884 2884       Luxembourg 2020-04-11 22:45:13 49.8153 6.1296 3270 62 500 2708 Luxembourg
2883 2883       Lithuania 2020-04-11 22:45:13 55.1694 23.8813 926 13 2 949 Lithuania
2882 2882       Liechtenstein 2020-04-11 22:45:13 47.14 9.55 79 1 55 23 Liechtenstein
2881 2881       Libya 2020-04-11 22:45:13 26.3351 17.228331 24 1 8 15 Libya
2880 2880       Liberia 2020-04-11 22:45:13 6.4280550000000005 -9.429499 48 5 3 40 Liberia
2879 2879       Lebanon 2020-04-11 22:45:13 33.8547 35.8623 619 20 77 522 Lebanon
2878 2878       Latvia 2020-04-11 22:45:13 56.8796 24.6032 630 3 16 611 Latvia
2877 2877       Laos 2020-04-11 22:45:13 19.856270000000002 102.495496 18 0 0 18 Laos
2876 2876       Kyrgyzstan 2020-04-11 22:45:13 41.20438 74.766098 339 5 44 290 Kyrgyzstan
2875 2875       Kuwait 2020-04-11 22:45:13 29.311659999999996 47.481766 1154 1 133 1020 Kuwait
2874 2874       Kosovo 2020-04-11 22:45:13 42.602636 20.902977 283 7 58 218 Kosovo
2873 2873       Korea, South 2020-04-11 22:45:13 35.90775700000001 127.766922 10480 211 7243 3026 Korea, South
2872 2872       Kenya 2020-04-11 22:45:13 -0.0236 37.9062 191 7 24 160 Kenya
2871 2871       Kazakhstan 2020-04-11 22:45:13 48.0196 66.9237 865 10 81 774 Kazakhstan
2870 2870       Jordan 2020-04-11 22:45:13 31.24 36.51 381 7 177 197 Jordan
2869 2869       Japan 2020-04-11 22:45:13 36.204824 138.252924 6005 99 762 5144 Japan
2868 2868       Jamaica 2020-04-11 22:45:13 18.1096 -77.2975 65 4 13 48 Jamaica

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
);