04-23-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,122 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
3122 3122     Western Australia Australia 2020-04-24 03:31:35 -31.9505 115.8605 546 7 340 199 Western Australia, Australia
3121 3121     Victoria Australia 2020-04-24 03:31:35 -37.8136 144.9631 1337 16 1172 149 Victoria, Australia
3120 3120     Tasmania Australia 2020-04-24 03:31:35 -42.8821 147.3272 207 8 67 132 Tasmania, Australia
3119 3119     South Australia Australia 2020-04-24 03:31:35 -34.9285 138.6007 438 4 331 103 South Australia, Australia
3118 3118     Queensland Australia 2020-04-24 03:31:35 -27.4698 153.0251 1026 6 738 282 Queensland, Australia
3117 3117     Northern Territory Australia 2020-04-24 03:31:35 -12.4634 130.8456 27 0 9 18 Northern Territory, Australia
3116 3116     New South Wales Australia 2020-04-24 03:31:35 -33.8688 151.2093 2976 31 1379 1566 New South Wales, Australia
3115 3115     Australian Capital Territory Australia 2020-04-24 03:31:35 -35.4735 149.0124 104 3 88 13 Australian Capital Territory, Australia
3114 3114       Zimbabwe 2020-04-24 03:30:31 -19.015438 29.154857 28 4 2 22 Zimbabwe
3113 3113       Zambia 2020-04-24 03:30:31 -13.133897 27.849332 76 3 37 36 Zambia
3112 3112       Yemen 2020-04-24 03:30:31 15.552726999999999 48.516388 1 0 0 1 Yemen
3111 3111       West Bank and Gaza 2020-04-24 03:30:31 31.9522 35.2332 480 4 92 384 West Bank and Gaza
3110 3110       Vietnam 2020-04-24 03:30:31 14.058323999999999 108.277199 268 0 224 44 Vietnam
3109 3109       Venezuela 2020-04-24 03:30:31 6.4238 -66.5897 311 10 126 175 Venezuela
3108 3108       Uzbekistan 2020-04-24 03:30:31 41.377491 64.585262 1758 7 561 1190 Uzbekistan
3107 3107       Uruguay 2020-04-24 03:30:31 -32.5228 -55.7658 557 12 354 191 Uruguay
3106 3106       United Kingdom 2020-04-24 03:30:31 55.3781 -3.4360000000000004 138078 18738 0 119340 United Kingdom
3105 3105       United Arab Emirates 2020-04-24 03:30:31 23.424076 53.847818000000004 8756 56 1637 7063 United Arab Emirates
3104 3104       Ukraine 2020-04-24 03:30:31 48.3794 31.1656 7170 187 504 6479 Ukraine
3103 3103       Uganda 2020-04-24 03:30:31 1.373333 32.290275 74 0 46 28 Uganda
3102 3102       Turkey 2020-04-24 03:30:31 38.9637 35.2433 101790 2491 18491 80808 Turkey
3101 3101       Tunisia 2020-04-24 03:30:31 33.886917 9.537499 918 38 190 690 Tunisia
3100 3100       Trinidad and Tobago 2020-04-24 03:30:31 10.6918 -61.2225 115 8 48 59 Trinidad and Tobago
3099 3099       Togo 2020-04-24 03:30:31 8.6195 0.8248 88 6 59 23 Togo
3098 3098       Timor-Leste 2020-04-24 03:30:31 -8.874217 125.727539 23 0 1 22 Timor-Leste
3097 3097       Thailand 2020-04-24 03:30:31 15.870032 100.992541 2839 50 2430 359 Thailand
3096 3096       Tanzania 2020-04-24 03:30:31 -6.369028 34.888822 284 10 11 263 Tanzania
3095 3095       Taiwan* 2020-04-23 10:58:50 23.7 121.0 427 6 253 168 Taiwan*
3094 3094       Syria 2020-04-24 03:30:31 34.802075 38.99681500000001 42 3 6 33 Syria
3093 3093       Switzerland 2020-04-24 03:30:31 46.8182 8.2275 28496 1549 20600 6347 Switzerland
3092 3092       Sweden 2020-04-24 03:30:31 60.128161 18.643501 16755 2021 550 14184 Sweden
3091 3091       Suriname 2020-04-24 03:30:31 3.9193 -56.0278 10 1 6 3 Suriname
3090 3090       Sudan 2020-04-24 03:30:31 12.8628 30.2176 162 16 14 144 Sudan
3089 3089       Sri Lanka 2020-04-24 03:30:31 7.873054 80.77179699999998 368 7 107 254 Sri Lanka
3088 3088       Spain 2020-04-24 03:30:31 40.463667 -3.7492199999999998 213024 22157 89250 101617 Spain
3087 3087       South Sudan 2020-04-24 03:30:31 6.8770000000000024 31.307 5 0 0 5 South Sudan
3086 3086       South Africa 2020-04-24 03:30:31 -30.5595 22.9375 3953 75 1473 2405 South Africa
3085 3085       Somalia 2020-04-24 03:30:31 5.152149 46.199616 328 16 8 304 Somalia
3084 3084       Slovenia 2020-04-24 03:30:31 46.1512 14.9955 1366 79 211 1076 Slovenia
3083 3083       Slovakia 2020-04-24 03:30:31 48.669 19.699 1325 15 288 1022 Slovakia
3082 3082       Singapore 2020-04-24 03:30:31 1.2833 103.8333 11178 12 924 10242 Singapore
3081 3081       Sierra Leone 2020-04-24 03:30:31 8.460555000000001 -11.779889 64 1 10 53 Sierra Leone
3080 3080       Seychelles 2020-04-24 03:30:31 -4.6796 55.492 11 0 6 5 Seychelles
3079 3079       Serbia 2020-04-24 03:30:31 44.0165 21.0059 6630 125 870 5635 Serbia
3078 3078       Senegal 2020-04-24 03:30:31 14.4974 -14.4524 479 6 257 216 Senegal
3077 3077       Saudi Arabia 2020-04-24 03:30:31 23.885942 45.079162 13930 121 1925 11884 Saudi Arabia
3076 3076       Sao Tome and Principe 2020-04-24 03:30:31 0.18636 6.613081 4 0 0 4 Sao Tome and Principe
3075 3075       San Marino 2020-04-24 03:30:31 43.9424 12.4578 501 40 63 398 San Marino
3074 3074       Samoa 2020-04-24 03:31:19 -13.759 -172.1046 0 0 0 0 Samoa
3073 3073       Saint Vincent and the Grenadines 2020-04-24 03:30:31 12.9843 -61.2872 13 0 3 10 Saint Vincent and the Grenadines
3072 3072       Saint Lucia 2020-04-24 03:30:31 13.9094 -60.9789 15 0 15 0 Saint Lucia
3071 3071       Saint Kitts and Nevis 2020-04-24 03:30:31 17.357822 -62.782998 15 0 1 14 Saint Kitts and Nevis
3070 3070       Rwanda 2020-04-24 03:30:31 -1.9403 29.8739 154 0 87 67 Rwanda
3069 3069       Russia 2020-04-24 03:30:31 61.52401 105.31875600000001 62773 555 4891 57327 Russia
3068 3068       Romania 2020-04-24 03:30:31 45.9432 24.9668 10096 545 2478 7073 Romania
3067 3067       Qatar 2020-04-24 03:30:31 25.3548 51.1839 7764 10 750 7004 Qatar
3066 3066       Portugal 2020-04-24 03:30:31 39.3999 -8.2245 22353 820 1201 20332 Portugal
3065 3065       Poland 2020-04-24 03:30:31 51.9194 19.1451 10511 454 1740 8317 Poland
3064 3064       Philippines 2020-04-24 03:30:31 12.879721 121.77401699999999 6981 462 722 5797 Philippines
3063 3063       Peru 2020-04-24 03:30:31 -9.19 -75.0152 20914 572 7422 12920 Peru
3062 3062       Paraguay 2020-04-24 03:30:31 -23.4425 -58.4438 213 9 67 137 Paraguay
3061 3061       Papua New Guinea 2020-04-24 03:30:31 -6.314993 143.95555 8 0 0 8 Papua New Guinea
3060 3060       Panama 2020-04-24 03:30:31 8.538 -80.7821 5166 146 271 4749 Panama
3059 3059       Pakistan 2020-04-24 03:30:31 30.3753 69.3451 11155 237 2527 8391 Pakistan
3058 3058       Oman 2020-04-24 03:30:31 21.512583 55.92325500000001 1716 9 307 1400 Oman
3057 3057       Norway 2020-04-24 03:30:31 60.472 8.4689 7401 194 32 7175 Norway
3056 3056       North Macedonia 2020-04-24 03:30:31 41.6086 21.7453 1300 56 301 943 North Macedonia
3055 3055       Nigeria 2020-04-24 03:30:31 9.082 8.6753 981 31 197 753 Nigeria
3054 3054       Niger 2020-04-24 03:30:31 17.607789 8.081666 671 24 256 391 Niger
3053 3053       Nicaragua 2020-04-24 03:30:31 12.865416 -85.207229 11 3 7 1 Nicaragua
3052 3052       New Zealand 2020-04-24 03:30:31 -40.9006 174.886 1456 17 1095 344 New Zealand
3051 3051       Netherlands 2020-04-24 03:30:31 52.1326 5.2913 35729 4177 0 31552 Netherlands
3050 3050       Nepal 2020-04-24 03:30:31 28.1667 84.25 48 0 10 38 Nepal
3049 3049       Namibia 2020-04-24 03:30:31 -22.9576 18.4904 16 0 7 9 Namibia
3048 3048       Mozambique 2020-04-24 03:30:31 -18.665695 35.529562 46 0 9 37 Mozambique
3047 3047       Morocco 2020-04-24 03:30:31 31.7917 -7.0926 3568 155 456 2957 Morocco
3046 3046       Montenegro 2020-04-24 03:30:31 42.708678000000006 19.37439 316 5 123 188 Montenegro
3045 3045       Mongolia 2020-04-24 03:30:31 46.8625 103.8467 36 0 9 27 Mongolia
3044 3044       Monaco 2020-04-24 03:30:31 43.7333 7.4167 94 4 35 55 Monaco
3043 3043       Moldova 2020-04-24 03:30:31 47.4116 28.3699 2926 80 661 2185 Moldova
3042 3042       Mexico 2020-04-24 03:30:31 23.6345 -102.5528 11633 1069 2627 7937 Mexico
3041 3041       Mauritius 2020-04-24 03:30:31 -20.348404000000002 57.552152 331 9 266 56 Mauritius
3040 3040       Mauritania 2020-04-24 03:30:31 21.0079 -10.9408 7 1 6 0 Mauritania
3039 3039       Malta 2020-04-24 03:30:31 35.9375 14.3754 445 3 204 238 Malta
3038 3038       Mali 2020-04-24 03:30:31 17.570692 -3.996166000000001 309 21 77 211 Mali
3037 3037       Maldives 2020-04-24 03:30:31 3.2028 73.2207 108 0 16 92 Maldives
3036 3036       Malaysia 2020-04-24 03:30:31 4.210483999999999 101.97576600000001 5603 95 3542 1966 Malaysia
3035 3035       Malawi 2020-04-24 03:30:31 -13.254307999999998 34.301525 33 3 3 27 Malawi
3034 3034       Madagascar 2020-04-24 03:30:31 -18.766947000000002 46.869107 121 0 58 63 Madagascar
3033 3033       MS Zaandam 2020-04-24 03:30:31     9 2 0 7 MS Zaandam
3032 3032       Luxembourg 2020-04-24 03:30:31 49.8153 6.1296 3665 83 728 2854 Luxembourg
3031 3031       Lithuania 2020-04-24 03:30:31 55.1694 23.8813 1272 27 236 959 Lithuania
3030 3030       Liechtenstein 2020-04-24 03:30:31 47.14 9.55 81 1 55 25 Liechtenstein
3029 3029       Libya 2020-04-24 03:30:31 26.3351 17.228331 60 2 15 43 Libya
3028 3028       Liberia 2020-04-24 03:30:31 6.4280550000000005 -9.429499 101 8 20 73 Liberia
3027 3027       Lebanon 2020-04-24 03:30:31 33.8547 35.8623 688 22 140 526 Lebanon
3026 3026       Latvia 2020-04-24 03:30:31 56.8796 24.6032 778 11 133 634 Latvia
3025 3025       Laos 2020-04-24 03:30:31 19.856270000000002 102.495496 19 0 4 15 Laos
3024 3024       Kyrgyzstan 2020-04-24 03:30:31 41.20438 74.766098 631 8 302 321 Kyrgyzstan
3023 3023       Kuwait 2020-04-24 03:30:31 29.311659999999996 47.481766 2399 14 498 1887 Kuwait

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

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