04-19-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,074 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
3074 3074       Zimbabwe 2020-04-19 23:40:41 -19.015438 29.154857 25 3 2 20 Zimbabwe
3073 3073       Zambia 2020-04-19 23:40:41 -13.133897 27.849332 61 3 33 25 Zambia
3072 3072       Yemen 2020-04-19 23:40:41 15.552727 48.516388 1 0 0 1 Yemen
3071 3071       West Bank and Gaza 2020-04-19 23:40:41 31.9522 35.2332 437 3 71 363 West Bank and Gaza
3070 3070       Vietnam 2020-04-19 23:40:41 14.058324 108.277199 268 0 202 66 Vietnam
3069 3069       Venezuela 2020-04-19 23:40:41 6.4238 -66.5897 256 9 117 130 Venezuela
3068 3068       Uzbekistan 2020-04-19 23:40:41 41.377491 64.585262 1565 5 225 1335 Uzbekistan
3067 3067       Uruguay 2020-04-19 23:40:41 -32.5228 -55.7658 517 10 298 209 Uruguay
3066 3066       United Kingdom 2020-04-19 23:40:41 55.3781 -3.436 120067 16060 0 104007 United Kingdom
3065 3065       United Arab Emirates 2020-04-19 23:40:41 23.424076 53.847818 6781 41 1286 5454 United Arab Emirates
3064 3064       Ukraine 2020-04-19 23:40:41 48.3794 31.1656 5449 141 347 4961 Ukraine
3063 3063       Uganda 2020-04-19 23:40:41 1.373333 32.290275 55 0 28 27 Uganda
3062 3062       Turkey 2020-04-19 23:40:41 38.9637 35.2433 86306 2017 11976 72313 Turkey
3061 3061       Tunisia 2020-04-19 23:40:41 33.886917 9.537499 879 38 43 798 Tunisia
3060 3060       Trinidad and Tobago 2020-04-19 23:40:41 10.6918 -61.2225 114 8 21 85 Trinidad and Tobago
3059 3059       Togo 2020-04-19 23:40:41 8.6195 0.8248 84 5 52 27 Togo
3058 3058       Timor-Leste 2020-04-19 23:40:41 -8.874217 125.727539 19 0 1 18 Timor-Leste
3057 3057       Thailand 2020-04-19 23:40:41 15.870032 100.992541 2765 47 1928 790 Thailand
3056 3056       Tanzania 2020-04-19 23:40:41 -6.369028 34.888822 170 7 11 152 Tanzania
3055 3055       Taiwan* 2020-04-19 09:13:57 23.7 121.0 420 6 189 225 Taiwan*
3054 3054       Syria 2020-04-19 23:40:41 34.802075 38.996815 39 3 5 31 Syria
3053 3053       Switzerland 2020-04-19 23:40:41 46.8182 8.2275 27740 1393 17800 8547 Switzerland
3052 3052       Sweden 2020-04-19 23:40:41 60.128161 18.643501 14385 1540 550 12295 Sweden
3051 3051       Suriname 2020-04-19 23:40:41 3.9193 -56.0278 10 1 6 3 Suriname
3050 3050       Sudan 2020-04-19 23:40:41 12.8628 30.2176 66 10 6 50 Sudan
3049 3049       Sri Lanka 2020-04-19 23:40:41 7.873054 80.771797 271 7 96 168 Sri Lanka
3048 3048       Spain 2020-04-19 23:40:41 40.463667 -3.74922 198674 20453 77357 100864 Spain
3047 3047       South Sudan 2020-04-19 23:40:41 6.877 31.307 4 0 0 4 South Sudan
3046 3046       South Africa 2020-04-19 23:40:41 -30.5595 22.9375 3158 54 903 2201 South Africa
3045 3045       Somalia 2020-04-19 23:40:41 5.152149 46.199616 164 7 3 154 Somalia
3044 3044       Slovenia 2020-04-19 23:40:41 46.1512 14.9955 1330 74 192 1064 Slovenia
3043 3043       Slovakia 2020-04-19 23:40:41 48.669 19.699 1161 12 229 920 Slovakia
3042 3042       Singapore 2020-04-19 23:40:41 1.2833 103.8333 6588 11 768 5809 Singapore
3041 3041       Sierra Leone 2020-04-19 23:40:41 8.460555 -11.779889 35 0 6 29 Sierra Leone
3040 3040       Seychelles 2020-04-19 23:40:41 -4.6796 55.492 11 0 5 6 Seychelles
3039 3039       Serbia 2020-04-19 23:40:41 44.0165 21.0059 6318 122 753 5443 Serbia
3038 3038       Senegal 2020-04-19 23:40:41 14.4974 -14.4524 367 3 220 144 Senegal
3037 3037       Saudi Arabia 2020-04-19 23:40:41 23.885942 45.079162 9362 97 1398 7867 Saudi Arabia
3036 3036       Sao Tome and Principe 2020-04-19 23:40:41 0.18636 6.613081 4 0 0 4 Sao Tome and Principe
3035 3035       San Marino 2020-04-19 23:40:41 43.9424 12.4578 461 39 60 362 San Marino
3034 3034       Samoa 2020-04-19 23:48:49 -13.759 -172.1046 0 0 0 0 Samoa
3033 3033       Saint Vincent and the Grenadines 2020-04-19 23:40:41 12.9843 -61.2872 12 0 1 11 Saint Vincent and the Grenadines
3032 3032       Saint Lucia 2020-04-19 23:40:41 13.9094 -60.9789 15 0 11 4 Saint Lucia
3031 3031       Saint Kitts and Nevis 2020-04-19 23:40:41 17.357822 -62.782998 14 0 0 14 Saint Kitts and Nevis
3030 3030       Rwanda 2020-04-19 23:40:41 -1.9403 29.8739 147 0 76 71 Rwanda
3029 3029       Russia 2020-04-19 23:40:41 61.52401 105.318756 42853 361 3291 39201 Russia
3028 3028       Romania 2020-04-19 23:40:41 45.9432 24.9668 8746 451 1892 6403 Romania
3027 3027       Qatar 2020-04-19 23:40:41 25.3548 51.1839 5448 8 518 4922 Qatar
3026 3026       Portugal 2020-04-19 23:40:41 39.3999 -8.2245 20206 714 610 18882 Portugal
3025 3025       Poland 2020-04-19 23:40:41 51.9194 19.1451 9287 360 1040 7887 Poland
3024 3024       Philippines 2020-04-19 23:40:41 12.879721 121.774017 6259 409 572 5278 Philippines
3023 3023       Peru 2020-04-19 23:40:41 -9.19 -75.0152 15628 400 6811 8417 Peru
3022 3022       Paraguay 2020-04-19 23:40:41 -23.4425 -58.4438 206 8 41 157 Paraguay
3021 3021       Papua New Guinea 2020-04-19 23:40:41 -6.314993 143.95555 7 0 0 7 Papua New Guinea
3020 3020       Panama 2020-04-19 23:40:41 8.538 -80.7821 4273 120 140 4013 Panama
3019 3019       Pakistan 2020-04-19 23:40:41 30.3753 69.3451 8348 168 1868 6312 Pakistan
3018 3018       Oman 2020-04-19 23:40:41 21.512583 55.923255 1266 7 233 1026 Oman
3017 3017       Norway 2020-04-19 23:40:41 60.472 8.4689 7078 165 32 6881 Norway
3016 3016       North Macedonia 2020-04-19 23:40:41 41.6086 21.7453 1207 51 179 977 North Macedonia
3015 3015       Nigeria 2020-04-19 23:40:41 9.082 8.6753 627 21 170 436 Nigeria
3014 3014       Niger 2020-04-19 23:40:41 17.607789 8.081666 648 20 117 511 Niger
3013 3013       Nicaragua 2020-04-19 23:40:41 12.865416 -85.207229 10 2 6 2 Nicaragua
3012 3012       New Zealand 2020-04-19 23:40:41 -40.9006 174.886 1431 12 912 507 New Zealand
3011 3011       Netherlands 2020-04-19 23:40:41 52.1326 5.2913 32655 3684 250 28721 Netherlands
3010 3010       Nepal 2020-04-19 23:40:41 28.1667 84.25 31 0 4 27 Nepal
3009 3009       Namibia 2020-04-19 23:40:41 -22.9576 18.4904 16 0 6 10 Namibia
3008 3008       Mozambique 2020-04-19 23:40:41 -18.665695 35.529562 39 0 8 31 Mozambique
3007 3007       Morocco 2020-04-19 23:40:41 31.7917 -7.0926 2855 141 327 2387 Morocco
3006 3006       Montenegro 2020-04-19 23:40:41 42.708678 19.37439 308 5 55 248 Montenegro
3005 3005       Mongolia 2020-04-19 23:40:41 46.8625 103.8467 32 0 7 25 Mongolia
3004 3004       Monaco 2020-04-19 23:40:41 43.7333 7.4167 94 3 22 69 Monaco
3003 3003       Moldova 2020-04-19 23:40:41 47.4116 28.3699 2472 67 457 1948 Moldova
3002 3002       Mexico 2020-04-19 23:40:41 23.6345 -102.5528 7497 650 2627 4220 Mexico
3001 3001       Mauritius 2020-04-19 23:40:41 -20.348404 57.552152 328 9 208 111 Mauritius
3000 3000       Mauritania 2020-04-19 23:40:41 21.0079 -10.9408 7 1 6 0 Mauritania
2999 2999       Malta 2020-04-19 23:40:41 35.9375 14.3754 427 3 118 306 Malta
2998 2998       Mali 2020-04-19 23:40:41 17.570692 -3.996166 224 14 42 168 Mali
2997 2997       Maldives 2020-04-19 23:40:41 3.2028 73.2207 52 0 16 36 Maldives
2996 2996       Malaysia 2020-04-19 23:40:41 4.210484 101.975766 5389 89 3197 2103 Malaysia
2995 2995       Malawi 2020-04-19 23:40:41 -13.254308 34.301525 17 2 3 12 Malawi
2994 2994       Madagascar 2020-04-19 23:40:41 -18.766947 46.869107 121 0 39 82 Madagascar
2993 2993       MS Zaandam 2020-04-19 23:40:41     9 2 0 7 MS Zaandam
2992 2992       Luxembourg 2020-04-19 23:40:41 49.8153 6.1296 3550 73 627 2850 Luxembourg
2991 2991       Lithuania 2020-04-19 23:40:41 55.1694 23.8813 1153 23 98 1021 Lithuania
2990 2990       Liechtenstein 2020-04-19 23:40:41 47.14 9.55 81 1 55 25 Liechtenstein
2989 2989       Libya 2020-04-19 23:40:41 26.3351 17.228331 51 1 11 39 Libya
2988 2988       Liberia 2020-04-19 23:40:41 6.428055 -9.429499 91 8 7 76 Liberia
2987 2987       Lebanon 2020-04-19 23:40:41 33.8547 35.8623 673 21 102 550 Lebanon
2986 2986       Latvia 2020-04-19 23:40:41 56.8796 24.6032 727 5 88 634 Latvia
2985 2985       Laos 2020-04-19 23:40:41 19.85627 102.495496 19 0 2 17 Laos
2984 2984       Kyrgyzstan 2020-04-19 23:40:41 41.20438 74.766098 554 5 133 416 Kyrgyzstan
2983 2983       Kuwait 2020-04-19 23:40:41 29.31166 47.481766 1915 7 305 1603 Kuwait
2982 2982       Kosovo 2020-04-19 23:40:41 42.602636 20.902977 510 12 93 405 Kosovo
2981 2981       Korea, South 2020-04-19 23:40:41 35.907757 127.766922 10661 234 8042 2385 Korea, South
2980 2980       Kenya 2020-04-19 23:40:41 -0.0236 37.9062 270 14 67 189 Kenya
2979 2979       Kazakhstan 2020-04-19 23:40:41 48.0196 66.9237 1676 17 400 1259 Kazakhstan
2978 2978       Jordan 2020-04-19 23:40:41 31.24 36.51 417 7 276 134 Jordan
2977 2977       Japan 2020-04-19 23:40:41 36.204824 138.252924 10797 236 1159 9402 Japan
2976 2976       Jamaica 2020-04-19 23:40:41 18.1096 -77.2975 173 5 27 141 Jamaica
2975 2975       Italy 2020-04-19 23:40:41 41.87194 12.56738 178972 23660 47055 108257 Italy

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

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