04-18-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,055 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
3055 3055       Zimbabwe 2020-04-18 22:32:28 -19.015438 29.154857 25 3 2 20 Zimbabwe
3054 3054       Zambia 2020-04-18 22:32:28 -13.133897 27.849332 57 2 33 22 Zambia
3053 3053       Yemen 2020-04-18 22:32:28 15.552727 48.516388 1 0 0 1 Yemen
3052 3052       West Bank and Gaza 2020-04-18 22:32:28 31.9522 35.2332 418 2 69 347 West Bank and Gaza
3051 3051       Vietnam 2020-04-18 22:32:28 14.058324 108.277199 268 0 201 67 Vietnam
3050 3050       Venezuela 2020-04-18 22:32:28 6.4238 -66.5897 227 9 113 105 Venezuela
3049 3049       Uzbekistan 2020-04-18 22:32:28 41.377491 64.585262 1490 5 194 1291 Uzbekistan
3048 3048       Uruguay 2020-04-18 22:32:28 -32.5228 -55.7658 508 9 294 205 Uruguay
3047 3047       United Kingdom 2020-04-18 22:32:28 55.3781 -3.436 114217 15464 0 98753 United Kingdom
3046 3046       United Arab Emirates 2020-04-18 22:32:28 23.424076 53.847818 6302 37 1188 5077 United Arab Emirates
3045 3045       Ukraine 2020-04-18 22:32:28 48.3794 31.1656 5106 133 275 4698 Ukraine
3044 3044       Uganda 2020-04-18 22:32:28 1.373333 32.290275 55 0 22 33 Uganda
3043 3043       Turkey 2020-04-18 22:32:28 38.9637 35.2433 82329 1890 10453 69986 Turkey
3042 3042       Tunisia 2020-04-18 22:32:28 33.886917 9.537499 864 37 43 784 Tunisia
3041 3041       Trinidad and Tobago 2020-04-18 22:32:28 10.6918 -61.2225 114 8 21 85 Trinidad and Tobago
3040 3040       Togo 2020-04-18 22:32:28 8.6195 0.8248 84 5 49 30 Togo
3039 3039       Timor-Leste 2020-04-18 22:32:28 -8.874217 125.727539 18 0 1 17 Timor-Leste
3038 3038       Thailand 2020-04-18 22:32:28 15.870032 100.992541 2733 47 1787 899 Thailand
3037 3037       Tanzania 2020-04-18 22:32:28 -6.369028 34.888822 147 5 11 131 Tanzania
3036 3036       Taiwan* 2020-04-18 11:05:23 23.7 121.0 398 6 178 214 Taiwan*
3035 3035       Syria 2020-04-18 22:32:28 34.802075 38.996815 38 2 5 31 Syria
3034 3034       Switzerland 2020-04-18 22:32:28 46.8182 8.2275 27404 1368 17100 8936 Switzerland
3033 3033       Sweden 2020-04-18 22:32:28 60.128161 18.643501 13822 1511 550 11761 Sweden
3032 3032       Suriname 2020-04-18 22:32:28 3.9193 -56.0278 10 1 6 3 Suriname
3031 3031       Sudan 2020-04-18 22:32:28 12.8628 30.2176 66 10 6 50 Sudan
3030 3030       Sri Lanka 2020-04-18 22:32:28 7.873054 80.771797 254 7 86 161 Sri Lanka
3029 3029       Spain 2020-04-18 22:32:28 40.463667 -3.74922 191726 20043 74797 96886 Spain
3028 3028       South Sudan 2020-04-18 22:32:28 6.877 31.307 4 0 0 4 South Sudan
3027 3027       South Africa 2020-04-18 22:32:28 -30.5595 22.9375 3034 52 903 2079 South Africa
3026 3026       Somalia 2020-04-18 22:32:28 5.152149 46.199616 135 7 2 126 Somalia
3025 3025       Slovenia 2020-04-18 22:32:28 46.1512 14.9955 1317 70 190 1057 Slovenia
3024 3024       Slovakia 2020-04-18 22:32:28 48.669 19.699 1089 11 213 865 Slovakia
3023 3023       Singapore 2020-04-18 22:32:28 1.2833 103.8333 5992 11 740 5241 Singapore
3022 3022       Sierra Leone 2020-04-18 22:32:28 8.460555 -11.779889 30 0 0 30 Sierra Leone
3021 3021       Seychelles 2020-04-18 22:32:28 -4.6796 55.492 11 0 5 6 Seychelles
3020 3020       Serbia 2020-04-18 22:32:28 44.0165 21.0059 5994 117 637 5240 Serbia
3019 3019       Senegal 2020-04-18 22:32:28 14.4974 -14.4524 350 3 211 136 Senegal
3018 3018       Saudi Arabia 2020-04-18 22:32:28 23.885942 45.079162 8274 92 1329 6853 Saudi Arabia
3017 3017       Sao Tome and Principe 2020-04-18 22:32:28 0.18636 6.613081 4 0 0 4 Sao Tome and Principe
3016 3016       San Marino 2020-04-18 22:32:28 43.9424 12.4578 455 39 60 356 San Marino
3015 3015       Samoa 2020-04-18 22:40:03 -13.759 -172.1046 0 0 0 0 Samoa
3014 3014       Saint Vincent and the Grenadines 2020-04-18 22:32:28 12.9843 -61.2872 12 0 1 11 Saint Vincent and the Grenadines
3013 3013       Saint Lucia 2020-04-18 22:32:28 13.9094 -60.9789 15 0 11 4 Saint Lucia
3012 3012       Saint Kitts and Nevis 2020-04-18 22:32:28 17.357822 -62.782998 14 0 0 14 Saint Kitts and Nevis
3011 3011       Rwanda 2020-04-18 22:32:28 -1.9403 29.8739 144 0 69 75 Rwanda
3010 3010       Russia 2020-04-18 22:32:28 61.52401 105.318756 36793 313 3057 33423 Russia
3009 3009       Romania 2020-04-18 22:32:28 45.9432 24.9668 8418 421 1730 6267 Romania
3008 3008       Qatar 2020-04-18 22:32:28 25.3548 51.1839 5008 8 510 4490 Qatar
3007 3007       Portugal 2020-04-18 22:32:28 39.3999 -8.2245 19685 687 610 18388 Portugal
3006 3006       Poland 2020-04-18 22:32:28 51.9194 19.1451 8742 347 981 7414 Poland
3005 3005       Philippines 2020-04-18 22:32:28 12.879721 121.774017 6087 397 516 5174 Philippines
3004 3004       Peru 2020-04-18 22:32:28 -9.19 -75.0152 14420 348 6684 7388 Peru
3003 3003       Paraguay 2020-04-18 22:32:28 -23.4425 -58.4438 202 8 35 159 Paraguay
3002 3002       Papua New Guinea 2020-04-18 22:32:28 -6.314993 143.95555 7 0 0 7 Papua New Guinea
3001 3001       Panama 2020-04-18 22:32:28 8.538 -80.7821 4210 116 122 3972 Panama
3000 3000       Pakistan 2020-04-18 22:32:28 30.3753 69.3451 7638 143 1832 5663 Pakistan
2999 2999       Oman 2020-04-18 22:32:28 21.512583 55.923255 1180 6 176 998 Oman
2998 2998       Norway 2020-04-18 22:32:28 60.472 8.4689 7036 164 32 6840 Norway
2997 2997       North Macedonia 2020-04-18 22:32:28 41.6086 21.7453 1170 49 164 957 North Macedonia
2996 2996       Nigeria 2020-04-18 22:32:28 9.082 8.6753 542 19 166 357 Nigeria
2995 2995       Niger 2020-04-18 22:32:28 17.607789 8.081666 639 19 113 507 Niger
2994 2994       Nicaragua 2020-04-18 22:32:28 12.865416 -85.207229 9 2 6 1 Nicaragua
2993 2993       New Zealand 2020-04-18 22:32:28 -40.9006 174.886 1422 11 867 544 New Zealand
2992 2992       Netherlands 2020-04-18 22:32:28 52.1326 5.2913 31589 3601 250 27738 Netherlands
2991 2991       Nepal 2020-04-18 22:32:28 28.1667 84.25 31 0 2 29 Nepal
2990 2990       Namibia 2020-04-18 22:32:28 -22.9576 18.4904 16 0 6 10 Namibia
2989 2989       Mozambique 2020-04-18 22:32:28 -18.665695 35.529562 35 0 4 31 Mozambique
2988 2988       Morocco 2020-04-18 22:32:28 31.7917 -7.0926 2685 137 314 2234 Morocco
2987 2987       Montenegro 2020-04-18 22:32:28 42.708678 19.37439 307 5 55 247 Montenegro
2986 2986       Mongolia 2020-04-18 22:32:28 46.8625 103.8467 31 0 5 26 Mongolia
2985 2985       Monaco 2020-04-18 22:32:28 43.7333 7.4167 94 3 22 69 Monaco
2984 2984       Moldova 2020-04-18 22:32:28 47.4116 28.3699 2378 57 391 1930 Moldova
2983 2983       Mexico 2020-04-18 22:32:28 23.6345 -102.5528 6875 546 2125 4204 Mexico
2982 2982       Mauritius 2020-04-18 22:32:28 -20.348404 57.552152 325 9 180 136 Mauritius
2981 2981       Mauritania 2020-04-18 22:32:28 21.0079 -10.9408 7 1 2 4 Mauritania
2980 2980       Malta 2020-04-18 22:32:28 35.9375 14.3754 426 3 99 324 Malta
2979 2979       Mali 2020-04-18 22:32:28 17.570692 -3.996166 216 13 41 162 Mali
2978 2978       Maldives 2020-04-18 22:32:28 3.2028 73.2207 35 0 16 19 Maldives
2977 2977       Malaysia 2020-04-18 22:32:28 4.210484 101.975766 5305 88 3102 2115 Malaysia
2976 2976       Malawi 2020-04-18 22:32:28 -13.254308 34.301525 17 2 3 12 Malawi
2975 2975       Madagascar 2020-04-18 22:32:28 -18.766947 46.869107 120 0 35 85 Madagascar
2974 2974       MS Zaandam 2020-04-18 22:32:28     9 2 0 7 MS Zaandam
2973 2973       Luxembourg 2020-04-18 22:32:28 49.8153 6.1296 3537 72 601 2864 Luxembourg
2972 2972       Lithuania 2020-04-18 22:32:28 55.1694 23.8813 1091 22 66 978 Lithuania
2971 2971       Liechtenstein 2020-04-18 22:32:28 47.14 9.55 79 1 55 23 Liechtenstein
2970 2970       Libya 2020-04-18 22:32:28 26.3351 17.228331 49 1 11 37 Libya
2969 2969       Liberia 2020-04-18 22:32:28 6.428055 -9.429499 76 7 7 62 Liberia
2968 2968       Lebanon 2020-04-18 22:32:28 33.8547 35.8623 672 21 99 552 Lebanon
2967 2967       Latvia 2020-04-18 22:32:28 56.8796 24.6032 712 5 88 619 Latvia
2966 2966       Laos 2020-04-18 22:32:28 19.85627 102.495496 19 0 2 17 Laos
2965 2965       Kyrgyzstan 2020-04-18 22:32:28 41.20438 74.766098 506 5 130 371 Kyrgyzstan
2964 2964       Kuwait 2020-04-18 22:32:28 29.31166 47.481766 1751 6 280 1465 Kuwait
2963 2963       Kosovo 2020-04-18 22:32:28 42.602636 20.902977 510 12 93 405 Kosovo
2962 2962       Korea, South 2020-04-18 22:32:28 35.907757 127.766922 10653 232 7937 2484 Korea, South
2961 2961       Kenya 2020-04-18 22:32:28 -0.0236 37.9062 262 12 60 190 Kenya
2960 2960       Kazakhstan 2020-04-18 22:32:28 48.0196 66.9237 1615 17 377 1221 Kazakhstan
2959 2959       Jordan 2020-04-18 22:32:28 31.24 36.51 413 7 269 137 Jordan
2958 2958       Japan 2020-04-18 22:32:28 36.204824 138.252924 10296 222 1069 9005 Japan
2957 2957       Jamaica 2020-04-18 22:32:28 18.1096 -77.2975 163 5 25 133 Jamaica
2956 2956       Italy 2020-04-18 22:32:28 41.87194 12.56738 175925 23227 44927 107771 Italy

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

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