04-25-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,134 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
3134 3134     Western Australia Australia 2020-04-26 02:31:18 -31.9505 115.8605 549 8 478 63 Western Australia, Australia
3133 3133     Victoria Australia 2020-04-26 02:31:18 -37.8136 144.9631 1346 16 133 1197 Victoria, Australia
3132 3132     Tasmania Australia 2020-04-26 02:31:18 -42.8821 147.3272 207 10 117 80 Tasmania, Australia
3131 3131     South Australia Australia 2020-04-26 02:31:18 -34.9285 138.6007 438 4 401 33 South Australia, Australia
3130 3130     Queensland Australia 2020-04-26 02:31:18 -27.4698 153.0251 1026 6 803 217 Queensland, Australia
3129 3129     Northern Territory Australia 2020-04-26 02:31:18 -12.4634 130.8456 28 0 0 28 Northern Territory, Australia
3128 3128     New South Wales Australia 2020-04-26 02:31:18 -33.8688 151.2093 2994 33 2193 768 New South Wales, Australia
3127 3127     Australian Capital Territory Australia 2020-04-26 02:31:18 -35.4735 149.0124 106 3 98 5 Australian Capital Territory, Australia
3126 3126       Zimbabwe 2020-04-26 02:30:31 -19.015438 29.154857 31 4 2 25 Zimbabwe
3125 3125       Zambia 2020-04-26 02:30:31 -13.133897 27.849332 84 3 37 44 Zambia
3124 3124       Yemen 2020-04-26 02:30:31 15.552726999999999 48.516388 1 0 0 0 Yemen
3123 3123       West Bank and Gaza 2020-04-26 02:30:31 31.9522 35.2332 342 2 92 248 West Bank and Gaza
3122 3122       Vietnam 2020-04-26 02:30:31 14.058323999999999 108.277199 270 0 225 45 Vietnam
3121 3121       Venezuela 2020-04-26 02:30:31 6.4238 -66.5897 323 10 132 181 Venezuela
3120 3120       Uzbekistan 2020-04-26 02:30:31 41.377491 64.585262 1862 8 707 1147 Uzbekistan
3119 3119       Uruguay 2020-04-26 02:30:31 -32.5228 -55.7658 596 14 370 212 Uruguay
3118 3118       United Kingdom 2020-04-26 02:30:31 55.3781 -3.4360000000000004 148377 20319 0 128058 United Kingdom
3117 3117       United Arab Emirates 2020-04-26 02:30:31 23.424076 53.847818000000004 9813 71 1887 7855 United Arab Emirates
3116 3116       Ukraine 2020-04-26 02:30:31 48.3794 31.1656 8125 201 782 7142 Ukraine
3115 3115       Uganda 2020-04-26 02:30:31 1.373333 32.290275 75 0 46 29 Uganda
3114 3114       Turkey 2020-04-26 02:30:31 38.9637 35.2433 107773 2706 25582 79485 Turkey
3113 3113       Tunisia 2020-04-26 02:30:31 33.886917 9.537499 939 38 207 694 Tunisia
3112 3112       Trinidad and Tobago 2020-04-26 02:30:31 10.6918 -61.2225 115 8 53 54 Trinidad and Tobago
3111 3111       Togo 2020-04-26 02:30:31 8.6195 0.8248 96 6 62 28 Togo
3110 3110       Timor-Leste 2020-04-26 02:30:31 -8.874217 125.727539 24 0 2 22 Timor-Leste
3109 3109       Thailand 2020-04-26 02:30:31 15.870032 100.992541 2907 51 2547 309 Thailand
3108 3108       Tanzania 2020-04-26 02:30:31 -6.369028 34.888822 299 10 48 241 Tanzania
3107 3107       Taiwan* 2020-04-26 00:38:32 23.7 121.0 429 6 275 148 Taiwan*
3106 3106       Syria 2020-04-26 02:30:31 34.802075 38.99681500000001 42 3 11 28 Syria
3105 3105       Switzerland 2020-04-26 02:30:31 46.8182 8.2275 28894 1599 21300 5995 Switzerland
3104 3104       Sweden 2020-04-26 02:30:31 60.128161 18.643501 18177 2192 1005 14980 Sweden
3103 3103       Suriname 2020-04-26 02:30:31 3.9193 -56.0278 10 1 7 2 Suriname
3102 3102       Sudan 2020-04-26 02:30:31 12.8628 30.2176 213 17 19 177 Sudan
3101 3101       Sri Lanka 2020-04-26 02:30:31 7.873054 80.77179699999998 460 7 118 335 Sri Lanka
3100 3100       Spain 2020-04-26 02:30:31 40.463667 -3.7492199999999998 223759 22902 95708 105149 Spain
3099 3099       South Sudan 2020-04-26 02:30:31 6.8770000000000024 31.307 5 0 0 5 South Sudan
3098 3098       South Africa 2020-04-26 02:30:31 -30.5595 22.9375 4361 86 1473 2802 South Africa
3097 3097       Somalia 2020-04-26 02:30:31 5.152149 46.199616 390 18 8 364 Somalia
3096 3096       Slovenia 2020-04-26 02:30:31 46.1512 14.9955 1388 81 219 1088 Slovenia
3095 3095       Slovakia 2020-04-26 02:30:31 48.669 19.699 1373 17 386 970 Slovakia
3094 3094       Singapore 2020-04-26 02:30:31 1.2833 103.8333 12693 12 1002 11679 Singapore
3093 3093       Sierra Leone 2020-04-26 02:30:31 8.460555000000001 -11.779889 82 2 10 70 Sierra Leone
3092 3092       Seychelles 2020-04-26 02:30:31 -4.6796 55.492 11 0 6 5 Seychelles
3091 3091       Serbia 2020-04-26 02:30:31 44.0165 21.0059 6630 125 870 5635 Serbia
3090 3090       Senegal 2020-04-26 02:30:31 14.4974 -14.4524 614 7 276 331 Senegal
3089 3089       Saudi Arabia 2020-04-26 02:30:31 23.885942 45.079162 16299 136 2215 13948 Saudi Arabia
3088 3088       Sao Tome and Principe 2020-04-26 02:30:31 0.18636 6.613081 4 0 0 4 Sao Tome and Principe
3087 3087       San Marino 2020-04-26 02:30:31 43.9424 12.4578 513 40 64 409 San Marino
3086 3086       Samoa 2020-04-26 02:30:31 -13.759 -172.1046 0 0 0 0 Samoa
3085 3085       Saint Vincent and the Grenadines 2020-04-26 02:30:31 12.9843 -61.2872 14 0 5 9 Saint Vincent and the Grenadines
3084 3084       Saint Lucia 2020-04-26 02:30:31 13.9094 -60.9789 15 0 15 0 Saint Lucia
3083 3083       Saint Kitts and Nevis 2020-04-26 02:30:31 17.357822 -62.782998 15 0 2 13 Saint Kitts and Nevis
3082 3082       Rwanda 2020-04-26 02:30:31 -1.9403 29.8739 183 0 88 95 Rwanda
3081 3081       Russia 2020-04-26 02:30:31 61.52401 105.31875600000001 74588 681 6250 67657 Russia
3080 3080       Romania 2020-04-26 02:30:31 45.9432 24.9668 10635 601 2890 7144 Romania
3079 3079       Qatar 2020-04-26 02:30:31 25.3548 51.1839 9358 10 929 8419 Qatar
3078 3078       Portugal 2020-04-26 02:30:31 39.3999 -8.2245 23392 880 1277 21235 Portugal
3077 3077       Poland 2020-04-26 02:30:31 51.9194 19.1451 11273 524 2126 8623 Poland
3076 3076       Philippines 2020-04-26 02:30:31 12.879721 121.77401699999999 7294 494 792 6008 Philippines
3075 3075       Peru 2020-04-26 02:30:31 -9.19 -75.0152 25331 700 7797 16834 Peru
3074 3074       Paraguay 2020-04-26 02:30:31 -23.4425 -58.4438 228 9 85 134 Paraguay
3073 3073       Papua New Guinea 2020-04-26 02:30:31 -6.314993 143.95555 8 0 0 8 Papua New Guinea
3072 3072       Panama 2020-04-26 02:30:31 8.538 -80.7821 5538 159 338 5041 Panama
3071 3071       Pakistan 2020-04-26 02:30:31 30.3753 69.3451 12723 269 2866 9588 Pakistan
3070 3070       Oman 2020-04-26 02:30:31 21.512583 55.92325500000001 1905 10 329 1566 Oman
3069 3069       Norway 2020-04-26 02:30:31 60.472 8.4689 7499 201 32 7266 Norway
3068 3068       North Macedonia 2020-04-26 02:30:31 41.6086 21.7453 1367 59 374 934 North Macedonia
3067 3067       Nigeria 2020-04-26 02:30:31 9.082 8.6753 1182 35 222 925 Nigeria
3066 3066       Niger 2020-04-26 02:30:31 17.607789 8.081666 684 27 325 332 Niger
3065 3065       Nicaragua 2020-04-26 02:30:31 12.865416 -85.207229 12 3 7 2 Nicaragua
3064 3064       New Zealand 2020-04-26 02:30:31 -40.9006 174.886 1470 18 1142 310 New Zealand
3063 3063       Netherlands 2020-04-26 02:30:31 52.1326 5.2913 37190 4409 0 32781 Netherlands
3062 3062       Nepal 2020-04-26 02:30:31 28.1667 84.25 49 0 12 37 Nepal
3061 3061       Namibia 2020-04-26 02:30:31 -22.9576 18.4904 16 0 7 9 Namibia
3060 3060       Mozambique 2020-04-26 02:30:31 -18.665695 35.529562 70 0 12 58 Mozambique
3059 3059       Morocco 2020-04-26 02:30:31 31.7917 -7.0926 3897 159 537 3201 Morocco
3058 3058       Montenegro 2020-04-26 02:30:31 42.708678000000006 19.37439 320 6 153 161 Montenegro
3057 3057       Mongolia 2020-04-26 02:30:31 46.8625 103.8467 37 0 9 28 Mongolia
3056 3056       Monaco 2020-04-26 02:30:31 43.7333 7.4167 94 4 42 48 Monaco
3055 3055       Moldova 2020-04-26 02:30:31 47.4116 28.3699 3304 94 825 2385 Moldova
3054 3054       Mexico 2020-04-26 02:30:31 23.6345 -102.5528 13842 1305 7149 5388 Mexico
3053 3053       Mauritius 2020-04-26 02:30:31 -20.348404000000002 57.552152 331 9 295 27 Mauritius
3052 3052       Mauritania 2020-04-26 02:30:31 21.0079 -10.9408 7 1 6 0 Mauritania
3051 3051       Malta 2020-04-26 02:30:31 35.9375 14.3754 448 4 249 195 Malta
3050 3050       Mali 2020-04-26 02:30:31 17.570692 -3.996166000000001 370 21 91 258 Mali
3049 3049       Maldives 2020-04-26 02:30:31 3.2028 73.2207 177 0 17 160 Maldives
3048 3048       Malaysia 2020-04-26 02:30:31 4.210483999999999 101.97576600000001 5742 98 3762 1882 Malaysia
3047 3047       Malawi 2020-04-26 02:30:31 -13.254307999999998 34.301525 33 3 4 26 Malawi
3046 3046       Madagascar 2020-04-26 02:30:31 -18.766947000000002 46.869107 123 0 62 61 Madagascar
3045 3045       MS Zaandam 2020-04-26 02:30:31     9 2 0 7 MS Zaandam
3044 3044       Luxembourg 2020-04-26 02:30:31 49.8153 6.1296 3711 85 3088 538 Luxembourg
3043 3043       Lithuania 2020-04-26 02:30:31 55.1694 23.8813 1301 29 287 925 Lithuania
3042 3042       Liechtenstein 2020-04-26 02:30:31 47.14 9.55 81 1 55 25 Liechtenstein
3041 3041       Libya 2020-04-26 02:30:31 26.3351 17.228331 61 2 18 41 Libya
3040 3040       Liberia 2020-04-26 02:30:31 6.4280550000000005 -9.429499 120 11 25 84 Liberia
3039 3039       Lebanon 2020-04-26 02:30:31 33.8547 35.8623 704 24 143 537 Lebanon
3038 3038       Latvia 2020-04-26 02:30:31 56.8796 24.6032 804 12 267 525 Latvia
3037 3037       Laos 2020-04-26 02:30:31 19.856270000000002 102.495496 19 0 7 12 Laos
3036 3036       Kyrgyzstan 2020-04-26 02:30:31 41.20438 74.766098 665 8 345 312 Kyrgyzstan
3035 3035       Kuwait 2020-04-26 02:30:31 29.311659999999996 47.481766 2892 19 656 2217 Kuwait

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

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