04-26-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,142 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
3142 3142     Western Australia Australia 2020-04-27 02:31:20 -31.9505 115.8605 549 8 486 55 Western Australia, Australia
3141 3141     Victoria Australia 2020-04-27 02:31:20 -37.8136 144.9631 1349 17 1265 67 Victoria, Australia
3140 3140     Tasmania Australia 2020-04-27 02:31:20 -42.8821 147.3272 212 11 123 78 Tasmania, Australia
3139 3139     South Australia Australia 2020-04-27 02:31:20 -34.9285 138.6007 438 4 411 23 South Australia, Australia
3138 3138     Queensland Australia 2020-04-27 02:31:20 -27.4698 153.0251 1030 6 926 98 Queensland, Australia
3137 3137     Northern Territory Australia 2020-04-27 02:31:20 -12.4634 130.8456 28 0 23 5 Northern Territory, Australia
3136 3136     New South Wales Australia 2020-04-27 02:31:20 -33.8688 151.2093 3002 34 2208 760 New South Wales, Australia
3135 3135     Australian Capital Territory Australia 2020-04-27 02:31:20 -35.4735 149.0124 106 3 99 4 Australian Capital Territory, Australia
3134 3134       Zimbabwe 2020-04-27 02:30:33 -19.015438 29.154857 31 4 2 25 Zimbabwe
3133 3133       Zambia 2020-04-27 02:30:33 -13.133897 27.849332 88 3 42 43 Zambia
3132 3132       Yemen 2020-04-27 02:30:33 15.552726999999999 48.516388 1 0 0 0 Yemen
3131 3131       West Bank and Gaza 2020-04-27 02:30:33 31.9522 35.2332 342 2 83 257 West Bank and Gaza
3130 3130       Vietnam 2020-04-27 02:30:33 14.058323999999999 108.277199 270 0 225 45 Vietnam
3129 3129       Venezuela 2020-04-27 02:30:33 6.4238 -66.5897 325 10 137 178 Venezuela
3128 3128       Uzbekistan 2020-04-27 02:30:33 41.377491 64.585262 1869 8 789 1072 Uzbekistan
3127 3127       Uruguay 2020-04-27 02:30:33 -32.5228 -55.7658 606 15 375 216 Uruguay
3126 3126       United Kingdom 2020-04-27 02:30:33 55.3781 -3.4360000000000004 152840 20732 0 132108 United Kingdom
3125 3125       United Arab Emirates 2020-04-27 02:30:33 23.424076 53.847818000000004 10349 76 1978 8295 United Arab Emirates
3124 3124       Ukraine 2020-04-27 02:30:33 48.3794 31.1656 8617 209 840 7568 Ukraine
3123 3123       Uganda 2020-04-27 02:30:33 1.373333 32.290275 79 0 46 33 Uganda
3122 3122       Turkey 2020-04-27 02:30:33 38.9637 35.2433 110130 2805 29140 78185 Turkey
3121 3121       Tunisia 2020-04-27 02:30:33 33.886917 9.537499 949 38 216 695 Tunisia
3120 3120       Trinidad and Tobago 2020-04-27 02:30:33 10.6918 -61.2225 115 8 54 53 Trinidad and Tobago
3119 3119       Togo 2020-04-27 02:30:33 8.6195 0.8248 98 6 62 30 Togo
3118 3118       Timor-Leste 2020-04-27 02:30:33 -8.874217 125.727539 24 0 2 22 Timor-Leste
3117 3117       Thailand 2020-04-27 02:30:33 15.870032 100.992541 2922 51 2594 277 Thailand
3116 3116       Tanzania 2020-04-27 02:30:33 -6.369028 34.888822 299 10 48 241 Tanzania
3115 3115       Taiwan* 2020-04-26 10:31:22 23.7 121.0 429 6 281 142 Taiwan*
3114 3114       Syria 2020-04-27 02:30:33 34.802075 38.99681500000001 43 3 14 26 Syria
3113 3113       Switzerland 2020-04-27 02:30:33 46.8182 8.2275 29061 1610 21800 5651 Switzerland
3112 3112       Sweden 2020-04-27 02:30:33 60.128161 18.643501 18640 2194 1005 15441 Sweden
3111 3111       Suriname 2020-04-27 02:30:33 3.9193 -56.0278 10 1 7 2 Suriname
3110 3110       Sudan 2020-04-27 02:30:33 12.8628 30.2176 237 21 20 196 Sudan
3109 3109       Sri Lanka 2020-04-27 02:30:33 7.873054 80.77179699999998 523 7 120 396 Sri Lanka
3108 3108       Spain 2020-04-27 02:30:33 40.463667 -3.7492199999999998 226629 23190 117727 85712 Spain
3107 3107       South Sudan 2020-04-27 02:30:33 6.8770000000000024 31.307 6 0 0 6 South Sudan
3106 3106       South Africa 2020-04-27 02:30:33 -30.5595 22.9375 4546 87 1473 2986 South Africa
3105 3105       Somalia 2020-04-27 02:30:33 5.152149 46.199616 436 23 10 403 Somalia
3104 3104       Slovenia 2020-04-27 02:30:33 46.1512 14.9955 1396 82 221 1093 Slovenia
3103 3103       Slovakia 2020-04-27 02:30:33 48.669 19.699 1379 18 394 967 Slovakia
3102 3102       Singapore 2020-04-27 02:30:33 1.2833 103.8333 13624 12 1060 12552 Singapore
3101 3101       Sierra Leone 2020-04-27 02:30:33 8.460555000000001 -11.779889 93 4 10 79 Sierra Leone
3100 3100       Seychelles 2020-04-27 02:30:33 -4.6796 55.492 11 0 6 5 Seychelles
3099 3099       Serbia 2020-04-27 02:30:33 44.0165 21.0059 6630 125 870 5635 Serbia
3098 3098       Senegal 2020-04-27 02:30:33 14.4974 -14.4524 671 9 283 379 Senegal
3097 3097       Saudi Arabia 2020-04-27 02:30:33 23.885942 45.079162 17522 139 2357 15026 Saudi Arabia
3096 3096       Sao Tome and Principe 2020-04-27 02:30:33 0.18636 6.613081 4 0 0 4 Sao Tome and Principe
3095 3095       San Marino 2020-04-27 02:30:33 43.9424 12.4578 538 41 64 433 San Marino
3094 3094       Samoa 2020-04-27 02:30:33 -13.759 -172.1046 0 0 0 0 Samoa
3093 3093       Saint Vincent and the Grenadines 2020-04-27 02:30:33 12.9843 -61.2872 14 0 5 9 Saint Vincent and the Grenadines
3092 3092       Saint Lucia 2020-04-27 02:30:33 13.9094 -60.9789 15 0 15 0 Saint Lucia
3091 3091       Saint Kitts and Nevis 2020-04-27 02:30:33 17.357822 -62.782998 15 0 2 13 Saint Kitts and Nevis
3090 3090       Rwanda 2020-04-27 02:30:33 -1.9403 29.8739 191 0 92 99 Rwanda
3089 3089       Russia 2020-04-27 02:30:33 61.52401 105.31875600000001 80949 747 6767 73435 Russia
3088 3088       Romania 2020-04-27 02:30:33 45.9432 24.9668 11036 619 3054 7363 Romania
3087 3087       Qatar 2020-04-27 02:30:33 25.3548 51.1839 10287 10 1012 9265 Qatar
3086 3086       Portugal 2020-04-27 02:30:33 39.3999 -8.2245 23864 903 1329 21632 Portugal
3085 3085       Poland 2020-04-27 02:30:33 51.9194 19.1451 11617 535 2265 8817 Poland
3084 3084       Philippines 2020-04-27 02:30:33 12.879721 121.77401699999999 7579 501 862 6216 Philippines
3083 3083       Peru 2020-04-27 02:30:33 -9.19 -75.0152 27517 728 8088 18701 Peru
3082 3082       Paraguay 2020-04-27 02:30:33 -23.4425 -58.4438 228 9 85 134 Paraguay
3081 3081       Papua New Guinea 2020-04-27 02:30:33 -6.314993 143.95555 8 0 0 8 Papua New Guinea
3080 3080       Panama 2020-04-27 02:30:33 8.538 -80.7821 5779 165 338 5276 Panama
3079 3079       Pakistan 2020-04-27 02:30:33 30.3753 69.3451 13328 281 2936 10111 Pakistan
3078 3078       Oman 2020-04-27 02:30:33 21.512583 55.92325500000001 1998 10 333 1655 Oman
3077 3077       Norway 2020-04-27 02:30:33 60.472 8.4689 7527 201 32 7294 Norway
3076 3076       North Macedonia 2020-04-27 02:30:33 41.6086 21.7453 1386 61 500 825 North Macedonia
3075 3075       Nigeria 2020-04-27 02:30:33 9.082 8.6753 1273 40 239 994 Nigeria
3074 3074       Niger 2020-04-27 02:30:33 17.607789 8.081666 696 29 350 317 Niger
3073 3073       Nicaragua 2020-04-27 02:30:33 12.865416 -85.207229 13 3 7 3 Nicaragua
3072 3072       New Zealand 2020-04-27 02:30:33 -40.9006 174.886 1469 19 1180 270 New Zealand
3071 3071       Netherlands 2020-04-27 02:30:33 52.1326 5.2913 37845 4475 0 33370 Netherlands
3070 3070       Nepal 2020-04-27 02:30:33 28.1667 84.25 52 0 16 36 Nepal
3069 3069       Namibia 2020-04-27 02:30:33 -22.9576 18.4904 16 0 8 8 Namibia
3068 3068       Mozambique 2020-04-27 02:30:33 -18.665695 35.529562 76 0 12 64 Mozambique
3067 3067       Morocco 2020-04-27 02:30:33 31.7917 -7.0926 4065 161 593 3311 Morocco
3066 3066       Montenegro 2020-04-27 02:30:33 42.708678000000006 19.37439 321 7 153 161 Montenegro
3065 3065       Mongolia 2020-04-27 02:30:33 46.8625 103.8467 38 0 9 29 Mongolia
3064 3064       Monaco 2020-04-27 02:30:33 43.7333 7.4167 94 4 42 48 Monaco
3063 3063       Moldova 2020-04-27 02:30:33 47.4116 28.3699 3408 96 895 2417 Moldova
3062 3062       Mexico 2020-04-27 02:30:33 23.6345 -102.5528 14677 1351 8354 4972 Mexico
3061 3061       Mauritius 2020-04-27 02:30:33 -20.348404000000002 57.552152 332 9 299 24 Mauritius
3060 3060       Mauritania 2020-04-27 02:30:33 21.0079 -10.9408 7 1 6 0 Mauritania
3059 3059       Malta 2020-04-27 02:30:33 35.9375 14.3754 448 4 282 162 Malta
3058 3058       Mali 2020-04-27 02:30:33 17.570692 -3.996166000000001 389 23 112 254 Mali
3057 3057       Maldives 2020-04-27 02:30:33 3.2028 73.2207 214 0 17 197 Maldives
3056 3056       Malaysia 2020-04-27 02:30:33 4.210483999999999 101.97576600000001 5780 98 3862 1820 Malaysia
3055 3055       Malawi 2020-04-27 02:30:33 -13.254307999999998 34.301525 34 3 4 27 Malawi
3054 3054       Madagascar 2020-04-27 02:30:33 -18.766947000000002 46.869107 124 0 71 53 Madagascar
3053 3053       MS Zaandam 2020-04-27 02:30:33     9 2 0 7 MS Zaandam
3052 3052       Luxembourg 2020-04-27 02:30:33 49.8153 6.1296 3723 88 3104 531 Luxembourg
3051 3051       Lithuania 2020-04-27 02:30:33 55.1694 23.8813 1316 31 365 930 Lithuania
3050 3050       Liechtenstein 2020-04-27 02:30:33 47.14 9.55 82 1 55 26 Liechtenstein
3049 3049       Libya 2020-04-27 02:30:33 26.3351 17.228331 61 2 18 41 Libya
3048 3048       Liberia 2020-04-27 02:30:33 6.4280550000000005 -9.429499 124 12 25 87 Liberia
3047 3047       Lebanon 2020-04-27 02:30:33 33.8547 35.8623 707 24 145 538 Lebanon
3046 3046       Latvia 2020-04-27 02:30:33 56.8796 24.6032 812 12 267 533 Latvia
3045 3045       Laos 2020-04-27 02:30:33 19.856270000000002 102.495496 19 0 7 12 Laos
3044 3044       Kyrgyzstan 2020-04-27 02:30:33 41.20438 74.766098 682 8 370 304 Kyrgyzstan
3043 3043       Kuwait 2020-04-27 02:30:33 29.311659999999996 47.481766 3075 20 806 2249 Kuwait

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

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