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 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
3015 3015       Zimbabwe 2020-04-14 23:33:12 -19.015438 29.154857 17 3 0 14 Zimbabwe
3014 3014       Zambia 2020-04-14 23:33:12 -13.133897 27.849332 45 2 30 13 Zambia
3013 3013       Yemen 2020-04-14 23:33:12 15.552726999999999 48.516388 1 0 0 1 Yemen
3012 3012       West Bank and Gaza 2020-04-14 23:33:12 31.9522 35.2332 308 2 62 244 West Bank and Gaza
3011 3011       Vietnam 2020-04-14 23:33:12 14.058323999999999 108.277199 266 0 169 97 Vietnam
3010 3010       Venezuela 2020-04-14 23:33:12 6.4238 -66.5897 189 9 110 70 Venezuela
3009 3009       Uzbekistan 2020-04-14 23:33:12 41.377491 64.585262 1165 4 99 1062 Uzbekistan
3008 3008       Uruguay 2020-04-14 23:33:12 -32.5228 -55.7658 483 8 248 227 Uruguay
3007 3007       United Kingdom 2020-04-14 23:33:12 55.3781 -3.4360000000000004 93873 12107 0 81766 United Kingdom
3006 3006       United Arab Emirates 2020-04-14 23:33:12 23.424076 53.847818000000004 4933 28 933 3972 United Arab Emirates
3005 3005       Ukraine 2020-04-14 23:33:12 48.3794 31.1656 3372 98 119 3155 Ukraine
3004 3004       Uganda 2020-04-14 23:33:12 1.373333 32.290275 55 0 8 47 Uganda
3003 3003       Turkey 2020-04-14 23:33:12 38.9637 35.2433 65111 1403 4799 58909 Turkey
3002 3002       Tunisia 2020-04-14 23:33:12 33.886917 9.537499 747 34 43 670 Tunisia
3001 3001       Trinidad and Tobago 2020-04-14 23:33:12 10.6918 -61.2225 113 8 17 88 Trinidad and Tobago
3000 3000       Togo 2020-04-14 23:33:12 8.6195 0.8248 77 3 32 42 Togo
2999 2999       Timor-Leste 2020-04-14 23:33:12 -8.874217 125.727539 6 0 1 5 Timor-Leste
2998 2998       Thailand 2020-04-14 23:33:12 15.870032 100.992541 2613 41 1405 1167 Thailand
2997 2997       Tanzania 2020-04-14 23:33:12 -6.369028 34.888822 53 3 7 43 Tanzania
2996 2996       Taiwan* 2020-04-14 12:51:41 23.7 121.0 393 6 124 263 Taiwan*
2995 2995       Syria 2020-04-14 23:33:12 34.802075 38.99681500000001 29 2 5 22 Syria
2994 2994       Switzerland 2020-04-14 23:33:12 46.8182 8.2275 25936 1174 13700 11062 Switzerland
2993 2993       Sweden 2020-04-14 23:33:12 60.128161 18.643501 11445 1033 381 10031 Sweden
2992 2992       Suriname 2020-04-14 23:33:12 3.9193 -56.0278 10 1 6 3 Suriname
2991 2991       Sudan 2020-04-14 23:33:12 12.8628 30.2176 29 5 4 23 Sudan
2990 2990       Sri Lanka 2020-04-14 23:33:12 7.873054 80.77179699999998 233 7 61 165 Sri Lanka
2989 2989       Spain 2020-04-14 23:33:12 40.463667 -3.7492199999999998 172541 18056 67504 86981 Spain
2988 2988       South Sudan 2020-04-14 23:33:12 6.8770000000000024 31.307 4 0 0 4 South Sudan
2987 2987       South Africa 2020-04-14 23:33:12 -30.5595 22.9375 2415 27 410 1978 South Africa
2986 2986       Somalia 2020-04-14 23:33:12 5.152149 46.199616 60 2 2 56 Somalia
2985 2985       Slovenia 2020-04-14 23:33:12 46.1512 14.9955 1220 56 152 1012 Slovenia
2984 2984       Slovakia 2020-04-14 23:33:12 48.669 19.699 835 2 113 720 Slovakia
2983 2983       Singapore 2020-04-14 23:33:12 1.2833 103.8333 3252 10 611 2631 Singapore
2982 2982       Sierra Leone 2020-04-14 23:33:12 8.460555000000001 -11.779889 11 0 0 11 Sierra Leone
2981 2981       Seychelles 2020-04-14 23:33:12 -4.6796 55.492 11 0 0 11 Seychelles
2980 2980       Serbia 2020-04-14 23:33:12 44.0165 21.0059 4465 94 0 4371 Serbia
2979 2979       Senegal 2020-04-14 23:33:12 14.4974 -14.4524 299 2 183 114 Senegal
2978 2978       Saudi Arabia 2020-04-14 23:33:12 23.885942 45.079162 5369 73 889 4407 Saudi Arabia
2977 2977       Sao Tome and Principe 2020-04-14 23:33:12 0.18636 6.613081 4 0 0 4 Sao Tome and Principe
2976 2976       San Marino 2020-04-14 23:33:12 43.9424 12.4578 371 36 53 282 San Marino
2975 2975       Samoa 2020-04-14 23:40:54 -13.759 -172.1046 0 0 0 0 Samoa
2974 2974       Saint Vincent and the Grenadines 2020-04-14 23:33:12 12.9843 -61.2872 12 0 1 11 Saint Vincent and the Grenadines
2973 2973       Saint Lucia 2020-04-14 23:33:12 13.9094 -60.9789 15 0 11 4 Saint Lucia
2972 2972       Saint Kitts and Nevis 2020-04-14 23:33:12 17.357822 -62.782998 14 0 0 14 Saint Kitts and Nevis
2971 2971       Rwanda 2020-04-14 23:33:12 -1.9403 29.8739 134 0 49 85 Rwanda
2970 2970       Russia 2020-04-14 23:33:12 61.52401 105.31875600000001 21102 170 1694 19238 Russia
2969 2969       Romania 2020-04-14 23:33:12 45.9432 24.9668 6879 351 1051 5477 Romania
2968 2968       Qatar 2020-04-14 23:33:12 25.3548 51.1839 3428 7 373 3048 Qatar
2967 2967       Portugal 2020-04-14 23:33:12 39.3999 -8.2245 17448 567 347 16534 Portugal
2966 2966       Poland 2020-04-14 23:33:12 51.9194 19.1451 7202 263 618 6321 Poland
2965 2965       Philippines 2020-04-14 23:33:12 12.879721 121.77401699999999 5223 335 295 4593 Philippines
2964 2964       Peru 2020-04-14 23:33:12 -9.19 -75.0152 10303 230 2869 7204 Peru
2963 2963       Paraguay 2020-04-14 23:33:12 -23.4425 -58.4438 159 7 22 130 Paraguay
2962 2962       Papua New Guinea 2020-04-14 23:33:12 -6.314993 143.95555 2 0 0 2 Papua New Guinea
2961 2961       Panama 2020-04-14 23:33:12 8.538 -80.7821 3472 94 61 3317 Panama
2960 2960       Pakistan 2020-04-14 23:33:12 30.3753 69.3451 5837 96 1378 4363 Pakistan
2959 2959       Oman 2020-04-14 23:33:12 21.512583 55.92325500000001 813 4 130 679 Oman
2958 2958       Norway 2020-04-14 23:33:12 60.472 8.4689 6623 139 32 6452 Norway
2957 2957       North Macedonia 2020-04-14 23:33:12 41.6086 21.7453 908 44 86 778 North Macedonia
2956 2956       Nigeria 2020-04-14 23:33:12 9.082 8.6753 373 11 99 263 Nigeria
2955 2955       Niger 2020-04-14 23:33:12 17.607789 8.081666 570 14 90 466 Niger
2954 2954       Nicaragua 2020-04-14 23:33:12 12.865416 -85.207229 9 1 4 4 Nicaragua
2953 2953       New Zealand 2020-04-14 23:33:12 -40.9006 174.886 1366 9 628 729 New Zealand
2952 2952       Netherlands 2020-04-14 23:33:12 52.1326 5.2913 27419 2945 250 24224 Netherlands
2951 2951       Nepal 2020-04-14 23:33:12 28.1667 84.25 16 0 1 15 Nepal
2950 2950       Namibia 2020-04-14 23:33:12 -22.9576 18.4904 16 0 3 13 Namibia
2949 2949       Mozambique 2020-04-14 23:33:12 -18.665695 35.529562 28 0 2 26 Mozambique
2948 2948       Morocco 2020-04-14 23:33:12 31.7917 -7.0926 1888 126 217 1545 Morocco
2947 2947       Montenegro 2020-04-14 23:33:12 42.708678000000006 19.37439 283 4 46 233 Montenegro
2946 2946       Mongolia 2020-04-14 23:33:12 46.8625 103.8467 30 0 5 25 Mongolia
2945 2945       Monaco 2020-04-14 23:33:12 43.7333 7.4167 93 1 6 86 Monaco
2944 2944       Moldova 2020-04-14 23:33:12 47.4116 28.3699 1934 40 134 1760 Moldova
2943 2943       Mexico 2020-04-14 23:33:12 23.6345 -102.5528 5014 332 1964 2718 Mexico
2942 2942       Mauritius 2020-04-14 23:33:12 -20.348404000000002 57.552152 324 9 51 264 Mauritius
2941 2941       Mauritania 2020-04-14 23:33:12 21.0079 -10.9408 7 1 2 4 Mauritania
2940 2940       Malta 2020-04-14 23:33:12 35.9375 14.3754 393 3 44 346 Malta
2939 2939       Mali 2020-04-14 23:33:12 17.570692 -3.996166000000001 144 13 34 97 Mali
2938 2938       Maldives 2020-04-14 23:33:12 3.2028 73.2207 20 0 16 4 Maldives
2937 2937       Malaysia 2020-04-14 23:33:12 4.210483999999999 101.97576600000001 4987 82 2478 2427 Malaysia
2936 2936       Malawi 2020-04-14 23:33:12 -13.254307999999998 34.301525 16 2 0 14 Malawi
2935 2935       Madagascar 2020-04-14 23:33:12 -18.766947000000002 46.869107 108 0 23 85 Madagascar
2934 2934       MS Zaandam 2020-04-14 23:33:12     9 2 0 7 MS Zaandam
2933 2933       Luxembourg 2020-04-14 23:33:12 49.8153 6.1296 3307 67 500 2740 Luxembourg
2932 2932       Lithuania 2020-04-14 23:33:12 55.1694 23.8813 977 16 7 940 Lithuania
2931 2931       Liechtenstein 2020-04-14 23:33:12 47.14 9.55 79 1 55 23 Liechtenstein
2930 2930       Libya 2020-04-14 23:33:12 26.3351 17.228331 35 1 9 25 Libya
2929 2929       Liberia 2020-04-14 23:33:12 6.4280550000000005 -9.429499 59 6 4 49 Liberia
2928 2928       Lebanon 2020-04-14 23:33:12 33.8547 35.8623 641 21 80 540 Lebanon
2927 2927       Latvia 2020-04-14 23:33:12 56.8796 24.6032 657 5 16 636 Latvia
2926 2926       Laos 2020-04-14 23:33:12 19.856270000000002 102.495496 19 0 1 18 Laos
2925 2925       Kyrgyzstan 2020-04-14 23:33:12 41.20438 74.766098 430 5 71 354 Kyrgyzstan
2924 2924       Kuwait 2020-04-14 23:33:12 29.311659999999996 47.481766 1355 3 176 1176 Kuwait
2923 2923       Kosovo 2020-04-14 23:33:12 42.602636 20.902977 387 8 66 313 Kosovo
2922 2922       Korea, South 2020-04-14 23:33:12 35.90775700000001 127.766922 10564 222 7534 2808 Korea, South
2921 2921       Kenya 2020-04-14 23:33:12 -0.0236 37.9062 216 9 41 166 Kenya
2920 2920       Kazakhstan 2020-04-14 23:33:12 48.0196 66.9237 1232 14 203 1015 Kazakhstan
2919 2919       Jordan 2020-04-14 23:33:12 31.24 36.51 397 7 235 155 Jordan
2918 2918       Japan 2020-04-14 23:33:12 36.204824 138.252924 7645 143 799 6703 Japan
2917 2917       Jamaica 2020-04-14 23:33:12 18.1096 -77.2975 73 4 19 50 Jamaica
2916 2916       Italy 2020-04-14 23:33:12 41.87194 12.56738 162488 21067 37130 104291 Italy

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