04-28-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,165 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
3165 3165       Zimbabwe 2020-04-29 02:32:29 -19.015438 29.154857 32 4 5 23 Zimbabwe
3164 3164       Zambia 2020-04-29 02:32:29 -13.133897 27.849332 95 3 42 50 Zambia
3163 3163       Yemen 2020-04-29 02:32:29 15.552726999999999 48.516388 1 0 0 0 Yemen
3162 3162       West Bank and Gaza 2020-04-29 02:32:29 31.9522 35.2332 343 2 71 270 West Bank and Gaza
3161 3161       Vietnam 2020-04-29 02:32:29 14.058323999999999 108.277199 270 0 222 48 Vietnam
3160 3160       Venezuela 2020-04-29 02:32:29 6.4238 -66.5897 329 10 142 177 Venezuela
3159 3159       Uzbekistan 2020-04-29 02:32:29 41.377491 64.585262 1939 8 992 939 Uzbekistan
3158 3158       Uruguay 2020-04-29 02:32:29 -32.5228 -55.7658 625 15 394 216 Uruguay
3157 3157       United Kingdom 2020-04-29 02:32:29 55.3781 -3.4360000000000004 161145 21678 0 139467 United Kingdom
3156 3156       United Arab Emirates 2020-04-29 02:32:29 23.424076 53.847818000000004 11380 89 2181 9110 United Arab Emirates
3155 3155       Ukraine 2020-04-29 02:32:29 48.3794 31.1656 9410 239 992 8179 Ukraine
3154 3154       Uganda 2020-04-29 02:32:29 1.373333 32.290275 79 0 52 27 Uganda
3153 3153       Turkey 2020-04-29 02:32:29 38.9637 35.2433 114653 2992 38809 72852 Turkey
3152 3152       Tunisia 2020-04-29 02:32:29 33.886917 9.537499 975 40 279 656 Tunisia
3151 3151       Trinidad and Tobago 2020-04-29 02:32:29 10.6918 -61.2225 116 8 59 49 Trinidad and Tobago
3150 3150       Togo 2020-04-29 02:32:29 8.6195 0.8248 99 6 63 30 Togo
3149 3149       Timor-Leste 2020-04-29 02:32:29 -8.874217 125.727539 24 0 6 18 Timor-Leste
3148 3148       Thailand 2020-04-29 02:32:29 15.870032 100.992541 2938 54 2652 232 Thailand
3147 3147       Tanzania 2020-04-29 02:32:29 -6.369028 34.888822 299 10 48 241 Tanzania
3146 3146       Taiwan* 2020-04-29 02:32:29 23.7 121.0 429 6 307 116 Taiwan*
3145 3145       Syria 2020-04-29 02:32:29 34.802075 38.99681500000001 43 3 21 19 Syria
3144 3144       Switzerland 2020-04-29 02:32:29 46.8182 8.2275 29264 1699 22600 4965 Switzerland
3143 3143       Sweden 2020-04-29 02:32:29 60.128161 18.643501 19621 2355 1005 16261 Sweden
3142 3142       Suriname 2020-04-29 02:32:29 3.9193 -56.0278 10 1 7 2 Suriname
3141 3141       Sudan 2020-04-29 02:32:29 12.8628 30.2176 318 25 31 262 Sudan
3140 3140       Sri Lanka 2020-04-29 02:32:29 7.873054 80.77179699999998 619 7 134 478 Sri Lanka
3139 3139       Spain 2020-04-29 02:32:29 40.463667 -3.7492199999999998 232128 23822 123903 84403 Spain
3138 3138       South Sudan 2020-04-29 02:32:29 6.8770000000000024 31.307 34 0 0 34 South Sudan
3137 3137       South Africa 2020-04-29 02:32:29 -30.5595 22.9375 4996 93 2073 2830 South Africa
3136 3136       Somalia 2020-04-29 02:32:29 5.152149 46.199616 528 28 19 481 Somalia
3135 3135       Slovenia 2020-04-29 02:32:29 46.1512 14.9955 1408 86 223 1099 Slovenia
3134 3134       Slovakia 2020-04-29 02:32:29 48.669 19.699 1384 20 423 941 Slovakia
3133 3133       Singapore 2020-04-29 02:32:29 1.2833 103.8333 14951 14 1128 13809 Singapore
3132 3132       Sierra Leone 2020-04-29 02:32:29 8.460555000000001 -11.779889 104 4 12 88 Sierra Leone
3131 3131       Seychelles 2020-04-29 02:32:29 -4.6796 55.492 11 0 6 5 Seychelles
3130 3130       Serbia 2020-04-29 02:32:29 44.0165 21.0059 6630 125 870 5635 Serbia
3129 3129       Senegal 2020-04-29 02:32:29 14.4974 -14.4524 823 9 296 518 Senegal
3128 3128       Saudi Arabia 2020-04-29 02:32:29 23.885942 45.079162 20077 152 2784 17141 Saudi Arabia
3127 3127       Sao Tome and Principe 2020-04-29 02:32:29 0.18636 6.613081 8 0 4 4 Sao Tome and Principe
3126 3126       San Marino 2020-04-29 02:32:29 43.9424 12.4578 553 41 64 448 San Marino
3125 3125       Samoa 2020-04-29 02:32:29 -13.759 -172.1046 0 0 0 0 Samoa
3124 3124       Saint Vincent and the Grenadines 2020-04-29 02:32:29 12.9843 -61.2872 15 0 8 7 Saint Vincent and the Grenadines
3123 3123       Saint Lucia 2020-04-29 02:32:29 13.9094 -60.9789 15 0 15 0 Saint Lucia
3122 3122       Saint Kitts and Nevis 2020-04-29 02:32:29 17.357822 -62.782998 15 0 4 11 Saint Kitts and Nevis
3121 3121       Rwanda 2020-04-29 02:32:29 -1.9403 29.8739 212 0 95 117 Rwanda
3120 3120       Russia 2020-04-29 02:32:29 61.52401 105.31875600000001 93558 867 8456 84235 Russia
3119 3119       Romania 2020-04-29 02:32:29 45.9432 24.9668 11616 663 3404 7549 Romania
3118 3118       Qatar 2020-04-29 02:32:29 25.3548 51.1839 11921 10 1134 10777 Qatar
3117 3117       Portugal 2020-04-29 02:32:29 39.3999 -8.2245 24322 948 1389 21985 Portugal
3116 3116       Poland 2020-04-29 02:32:29 51.9194 19.1451 12218 596 2655 8967 Poland
3115 3115       Philippines 2020-04-29 02:32:29 12.879721 121.77401699999999 7958 530 975 6453 Philippines
3114 3114       Peru 2020-04-29 02:32:29 -9.19 -75.0152 31190 854 9179 21157 Peru
3113 3113       Paraguay 2020-04-29 02:32:29 -23.4425 -58.4438 239 9 102 128 Paraguay
3112 3112       Papua New Guinea 2020-04-29 02:32:29 -6.314993 143.95555 8 0 0 8 Papua New Guinea
3111 3111       Panama 2020-04-29 02:32:29 8.538 -80.7821 6021 167 455 5399 Panama
3110 3110       Pakistan 2020-04-29 02:32:29 30.3753 69.3451 14612 312 3233 11067 Pakistan
3109 3109       Oman 2020-04-29 02:32:29 21.512583 55.92325500000001 2131 10 364 1757 Oman
3108 3108       Norway 2020-04-29 02:32:29 60.472 8.4689 7660 206 32 7422 Norway
3107 3107       North Macedonia 2020-04-29 02:32:29 41.6086 21.7453 1421 71 589 761 North Macedonia
3106 3106       Nigeria 2020-04-29 02:32:29 9.082 8.6753 1532 44 255 1233 Nigeria
3105 3105       Niger 2020-04-29 02:32:29 17.607789 8.081666 709 31 403 275 Niger
3104 3104       Nicaragua 2020-04-29 02:32:29 12.865416 -85.207229 13 3 7 3 Nicaragua
3103 3103       New Zealand 2020-04-29 02:32:29 -40.9006 174.886 1474 19 1229 226 New Zealand
3102 3102       Netherlands 2020-04-29 02:32:29 52.1326 5.2913 38416 4566 0 33850 Netherlands
3101 3101       Nepal 2020-04-29 02:32:29 28.1667 84.25 54 0 16 38 Nepal
3100 3100       Namibia 2020-04-29 02:32:29 -22.9576 18.4904 16 0 8 8 Namibia
3099 3099       Mozambique 2020-04-29 02:32:29 -18.665695 35.529562 76 0 12 64 Mozambique
3098 3098       Morocco 2020-04-29 02:32:29 31.7917 -7.0926 4252 165 778 3309 Morocco
3097 3097       Montenegro 2020-04-29 02:32:29 42.708678000000006 19.37439 321 7 199 115 Montenegro
3096 3096       Mongolia 2020-04-29 02:32:29 46.8625 103.8467 38 0 10 28 Mongolia
3095 3095       Monaco 2020-04-29 02:32:29 43.7333 7.4167 95 4 50 41 Monaco
3094 3094       Moldova 2020-04-29 02:32:29 47.4116 28.3699 3638 103 975 2560 Moldova
3093 3093       Mexico 2020-04-29 02:32:29 23.6345 -102.5528 16752 1569 11423 3760 Mexico
3092 3092       Mauritius 2020-04-29 02:32:29 -20.348404000000002 57.552152 334 10 303 21 Mauritius
3091 3091       Mauritania 2020-04-29 02:32:29 21.0079 -10.9408 7 1 6 0 Mauritania
3090 3090       Malta 2020-04-29 02:32:29 35.9375 14.3754 458 4 303 151 Malta
3089 3089       Mali 2020-04-29 02:32:29 17.570692 -3.996166000000001 424 24 122 278 Mali
3088 3088       Maldives 2020-04-29 02:32:29 3.2028 73.2207 250 0 17 233 Maldives
3087 3087       Malaysia 2020-04-29 02:32:29 4.210483999999999 101.97576600000001 5851 100 4032 1719 Malaysia
3086 3086       Malawi 2020-04-29 02:32:29 -13.254307999999998 34.301525 36 3 5 28 Malawi
3085 3085       Madagascar 2020-04-29 02:32:29 -18.766947000000002 46.869107 128 0 82 46 Madagascar
3084 3084       MS Zaandam 2020-04-29 02:32:29     9 2 0 7 MS Zaandam
3083 3083       Luxembourg 2020-04-29 02:32:29 49.8153 6.1296 3741 89 3123 529 Luxembourg
3082 3082       Lithuania 2020-04-29 02:32:29 55.1694 23.8813 1337 32 474 764 Lithuania
3081 3081       Liechtenstein 2020-04-29 02:32:29 47.14 9.55 82 1 55 26 Liechtenstein
3080 3080       Libya 2020-04-29 02:32:29 26.3351 17.228331 61 2 18 41 Libya
3079 3079       Liberia 2020-04-29 02:32:29 6.4280550000000005 -9.429499 141 16 45 80 Liberia
3078 3078       Lebanon 2020-04-29 02:32:29 33.8547 35.8623 717 24 145 548 Lebanon
3077 3077       Latvia 2020-04-29 02:32:29 56.8796 24.6032 836 13 267 556 Latvia
3076 3076       Laos 2020-04-29 02:32:29 19.856270000000002 102.495496 19 0 7 12 Laos
3075 3075       Kyrgyzstan 2020-04-29 02:32:29 41.20438 74.766098 708 8 416 284 Kyrgyzstan
3074 3074       Kuwait 2020-04-29 02:32:29 29.311659999999996 47.481766 3440 23 1176 2241 Kuwait
3073 3073       Kosovo 2020-04-29 02:32:29 42.602636 20.902977 510 12 93 405 Kosovo
3072 3072       Korea, South 2020-04-29 02:32:29 35.90775700000001 127.766922 10761 246 8922 1593 Korea, South
3071 3071       Kenya 2020-04-29 02:32:29 -0.0236 37.9062 374 14 124 236 Kenya
3070 3070       Kazakhstan 2020-04-29 02:32:29 48.0196 66.9237 3027 25 774 2228 Kazakhstan
3069 3069       Jordan 2020-04-29 02:32:29 31.24 36.51 449 8 348 93 Jordan
3068 3068       Japan 2020-04-29 02:32:29 36.204824 138.252924 13736 394 1899 11443 Japan
3067 3067       Jamaica 2020-04-29 02:32:29 18.1096 -77.2975 364 7 29 328 Jamaica
3066 3066       Italy 2020-04-29 02:32:29 41.87194 12.56738 201505 27359 68941 105205 Italy

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

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