04-29-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,170 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
3170 3170       Zimbabwe 2020-04-30 02:32:27 -19.015438 29.154857 32 4 5 23 Zimbabwe
3169 3169       Zambia 2020-04-30 02:32:27 -13.133897 27.849332 97 3 54 40 Zambia
3168 3168       Yemen 2020-04-30 02:32:27 15.552726999999999 48.516388 6 0 0 5 Yemen
3167 3167       West Bank and Gaza 2020-04-30 02:32:27 31.9522 35.2332 344 2 71 271 West Bank and Gaza
3166 3166       Vietnam 2020-04-30 02:32:27 14.058323999999999 108.277199 270 0 222 48 Vietnam
3165 3165       Venezuela 2020-04-30 02:32:27 6.4238 -66.5897 331 10 142 179 Venezuela
3164 3164       Uzbekistan 2020-04-30 02:32:27 41.377491 64.585262 2002 9 1096 897 Uzbekistan
3163 3163       Uruguay 2020-04-30 02:32:27 -32.5228 -55.7658 630 15 412 203 Uruguay
3162 3162       United Kingdom 2020-04-30 02:32:27 55.3781 -3.4360000000000004 165221 26097 0 139124 United Kingdom
3161 3161       United Arab Emirates 2020-04-30 02:32:27 23.424076 53.847818000000004 11929 98 2329 9502 United Arab Emirates
3160 3160       Ukraine 2020-04-30 02:32:27 48.3794 31.1656 9866 250 1103 8513 Ukraine
3159 3159       Uganda 2020-04-30 02:32:27 1.373333 32.290275 81 0 52 29 Uganda
3158 3158       Turkey 2020-04-30 02:32:27 38.9637 35.2433 117589 3081 44040 70468 Turkey
3157 3157       Tunisia 2020-04-30 02:32:27 33.886917 9.537499 980 40 294 646 Tunisia
3156 3156       Trinidad and Tobago 2020-04-30 02:32:27 10.6918 -61.2225 116 8 71 37 Trinidad and Tobago
3155 3155       Togo 2020-04-30 02:32:27 8.6195 0.8248 109 7 64 38 Togo
3154 3154       Timor-Leste 2020-04-30 02:32:27 -8.874217 125.727539 24 0 6 18 Timor-Leste
3153 3153       Thailand 2020-04-30 02:32:27 15.870032 100.992541 2947 54 2665 228 Thailand
3152 3152       Tanzania 2020-04-30 02:32:27 -6.369028 34.888822 480 16 167 297 Tanzania
3151 3151       Taiwan* 2020-04-30 02:32:27 23.7 121.0 429 6 311 112 Taiwan*
3150 3150       Syria 2020-04-30 02:32:27 34.802075 38.99681500000001 43 3 21 19 Syria
3149 3149       Switzerland 2020-04-30 02:32:27 46.8182 8.2275 29407 1716 22600 5091 Switzerland
3148 3148       Sweden 2020-04-30 02:32:27 60.128161 18.643501 20302 2462 1005 16835 Sweden
3147 3147       Suriname 2020-04-30 02:32:27 3.9193 -56.0278 10 1 8 1 Suriname
3146 3146       Sudan 2020-04-30 02:32:27 12.8628 30.2176 375 28 32 315 Sudan
3145 3145       Sri Lanka 2020-04-30 02:32:27 7.873054 80.77179699999998 649 7 136 506 Sri Lanka
3144 3144       Spain 2020-04-30 02:32:27 40.463667 -3.7492199999999998 236899 24275 132929 79695 Spain
3143 3143       South Sudan 2020-04-30 02:32:27 6.8770000000000024 31.307 34 0 0 34 South Sudan
3142 3142       South Africa 2020-04-30 02:32:27 -30.5595 22.9375 5350 103 2073 3174 South Africa
3141 3141       Somalia 2020-04-30 02:32:27 5.152149 46.199616 582 28 20 534 Somalia
3140 3140       Slovenia 2020-04-30 02:32:27 46.1512 14.9955 1418 89 230 1099 Slovenia
3139 3139       Slovakia 2020-04-30 02:32:27 48.669 19.699 1391 22 484 885 Slovakia
3138 3138       Singapore 2020-04-30 02:32:27 1.2833 103.8333 15641 14 1188 14439 Singapore
3137 3137       Sierra Leone 2020-04-30 02:32:27 8.460555000000001 -11.779889 104 4 12 88 Sierra Leone
3136 3136       Seychelles 2020-04-30 02:32:27 -4.6796 55.492 11 0 6 5 Seychelles
3135 3135       Serbia 2020-04-30 02:32:27 44.0165 21.0059 6630 125 870 5635 Serbia
3134 3134       Senegal 2020-04-30 02:32:27 14.4974 -14.4524 882 9 315 558 Senegal
3133 3133       Saudi Arabia 2020-04-30 02:32:27 23.885942 45.079162 21402 157 2953 18292 Saudi Arabia
3132 3132       Sao Tome and Principe 2020-04-30 02:32:27 0.18636 6.613081 8 0 4 4 Sao Tome and Principe
3131 3131       San Marino 2020-04-30 02:32:27 43.9424 12.4578 563 41 69 453 San Marino
3130 3130       Samoa 2020-04-30 02:32:27 -13.759 -172.1046 0 0 0 0 Samoa
3129 3129       Saint Vincent and the Grenadines 2020-04-30 02:32:27 12.9843 -61.2872 16 0 8 8 Saint Vincent and the Grenadines
3128 3128       Saint Lucia 2020-04-30 02:32:27 13.9094 -60.9789 17 0 15 2 Saint Lucia
3127 3127       Saint Kitts and Nevis 2020-04-30 02:32:27 17.357822 -62.782998 15 0 4 11 Saint Kitts and Nevis
3126 3126       Rwanda 2020-04-30 02:32:27 -1.9403 29.8739 225 0 98 127 Rwanda
3125 3125       Russia 2020-04-30 02:32:27 61.52401 105.31875600000001 99399 972 10286 88141 Russia
3124 3124       Romania 2020-04-30 02:32:27 45.9432 24.9668 11978 693 3569 7716 Romania
3123 3123       Qatar 2020-04-30 02:32:27 25.3548 51.1839 12564 10 1243 11311 Qatar
3122 3122       Portugal 2020-04-30 02:32:27 39.3999 -8.2245 24505 973 1470 22062 Portugal
3121 3121       Poland 2020-04-30 02:32:27 51.9194 19.1451 12640 624 3025 8991 Poland
3120 3120       Philippines 2020-04-30 02:32:27 12.879721 121.77401699999999 8212 558 1023 6631 Philippines
3119 3119       Peru 2020-04-30 02:32:27 -9.19 -75.0152 33931 943 10037 22951 Peru
3118 3118       Paraguay 2020-04-30 02:32:27 -23.4425 -58.4438 239 9 102 128 Paraguay
3117 3117       Papua New Guinea 2020-04-30 02:32:27 -6.314993 143.95555 8 0 0 8 Papua New Guinea
3116 3116       Panama 2020-04-30 02:32:27 8.538 -80.7821 6378 178 527 5673 Panama
3115 3115       Pakistan 2020-04-30 02:32:27 30.3753 69.3451 15525 343 3425 11757 Pakistan
3114 3114       Oman 2020-04-30 02:32:27 21.512583 55.92325500000001 2274 10 364 1900 Oman
3113 3113       Norway 2020-04-30 02:32:27 60.472 8.4689 7710 207 32 7471 Norway
3112 3112       North Macedonia 2020-04-30 02:32:27 41.6086 21.7453 1442 73 627 742 North Macedonia
3111 3111       Nigeria 2020-04-30 02:32:27 9.082 8.6753 1728 51 307 1370 Nigeria
3110 3110       Niger 2020-04-30 02:32:27 17.607789 8.081666 713 32 435 246 Niger
3109 3109       Nicaragua 2020-04-30 02:32:27 12.865416 -85.207229 13 3 7 3 Nicaragua
3108 3108       New Zealand 2020-04-30 02:32:27 -40.9006 174.886 1476 19 1241 216 New Zealand
3107 3107       Netherlands 2020-04-30 02:32:27 52.1326 5.2913 38802 4711 0 34091 Netherlands
3106 3106       Nepal 2020-04-30 02:32:27 28.1667 84.25 57 0 16 41 Nepal
3105 3105       Namibia 2020-04-30 02:32:27 -22.9576 18.4904 16 0 8 8 Namibia
3104 3104       Mozambique 2020-04-30 02:32:27 -18.665695 35.529562 76 0 12 64 Mozambique
3103 3103       Morocco 2020-04-30 02:32:27 31.7917 -7.0926 4321 168 928 3225 Morocco
3102 3102       Montenegro 2020-04-30 02:32:27 42.708678000000006 19.37439 322 7 203 112 Montenegro
3101 3101       Mongolia 2020-04-30 02:32:27 46.8625 103.8467 38 0 10 28 Mongolia
3100 3100       Monaco 2020-04-30 02:32:27 43.7333 7.4167 95 4 58 33 Monaco
3099 3099       Moldova 2020-04-30 02:32:27 47.4116 28.3699 3771 111 1114 2546 Moldova
3098 3098       Mexico 2020-04-30 02:32:27 23.6345 -102.5528 17799 1732 11423 4644 Mexico
3097 3097       Mauritius 2020-04-30 02:32:27 -20.348404000000002 57.552152 332 10 306 16 Mauritius
3096 3096       Mauritania 2020-04-30 02:32:27 21.0079 -10.9408 8 1 6 1 Mauritania
3095 3095       Malta 2020-04-30 02:32:27 35.9375 14.3754 463 4 339 120 Malta
3094 3094       Mali 2020-04-30 02:32:27 17.570692 -3.996166000000001 482 25 129 328 Mali
3093 3093       Maldives 2020-04-30 02:32:27 3.2028 73.2207 278 1 17 260 Maldives
3092 3092       Malaysia 2020-04-30 02:32:27 4.210483999999999 101.97576600000001 5945 100 4087 1758 Malaysia
3091 3091       Malawi 2020-04-30 02:32:27 -13.254307999999998 34.301525 36 3 7 26 Malawi
3090 3090       Madagascar 2020-04-30 02:32:27 -18.766947000000002 46.869107 128 0 90 38 Madagascar
3089 3089       MS Zaandam 2020-04-30 02:32:27     9 2 0 7 MS Zaandam
3088 3088       Luxembourg 2020-04-30 02:32:27 49.8153 6.1296 3769 89 3134 546 Luxembourg
3087 3087       Lithuania 2020-04-30 02:32:27 55.1694 23.8813 1364 32 530 767 Lithuania
3086 3086       Liechtenstein 2020-04-30 02:32:27 47.14 9.55 82 1 55 26 Liechtenstein
3085 3085       Libya 2020-04-30 02:32:27 26.3351 17.228331 61 2 18 41 Libya
3084 3084       Liberia 2020-04-30 02:32:27 6.4280550000000005 -9.429499 141 16 45 80 Liberia
3083 3083       Lebanon 2020-04-30 02:32:27 33.8547 35.8623 721 24 150 547 Lebanon
3082 3082       Latvia 2020-04-30 02:32:27 56.8796 24.6032 849 15 348 486 Latvia
3081 3081       Laos 2020-04-30 02:32:27 19.856270000000002 102.495496 19 0 7 12 Laos
3080 3080       Kyrgyzstan 2020-04-30 02:32:27 41.20438 74.766098 729 8 437 284 Kyrgyzstan
3079 3079       Kuwait 2020-04-30 02:32:27 29.311659999999996 47.481766 3740 24 1389 2327 Kuwait
3078 3078       Kosovo 2020-04-30 02:32:27 42.602636 20.902977 510 12 93 405 Kosovo
3077 3077       Korea, South 2020-04-30 02:32:27 35.90775700000001 127.766922 10765 247 9059 1459 Korea, South
3076 3076       Kenya 2020-04-30 02:32:27 -0.0236 37.9062 384 15 129 240 Kenya
3075 3075       Kazakhstan 2020-04-30 02:32:27 48.0196 66.9237 3138 25 819 2294 Kazakhstan
3074 3074       Jordan 2020-04-30 02:32:27 31.24 36.51 451 8 356 87 Jordan
3073 3073       Japan 2020-04-30 02:32:27 36.204824 138.252924 13895 413 2368 11114 Japan
3072 3072       Jamaica 2020-04-30 02:32:27 18.1096 -77.2975 396 7 29 360 Jamaica
3071 3071       Italy 2020-04-30 02:32:27 41.87194 12.56738 203591 27682 71252 104657 Italy

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

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