04-18-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,055 rows sorted by Province_State

✎ View and edit SQL

This data as json, copyable, CSV (advanced)

Link rowid FIPS Admin2 Province_State ▼ Country_Region Last_Update Lat Long_ Confirmed Deaths Recovered Active Combined_Key
2975 2975       Madagascar 2020-04-18 22:32:28 -18.766947 46.869107 120 0 35 85 Madagascar
2976 2976       Malawi 2020-04-18 22:32:28 -13.254308 34.301525 17 2 3 12 Malawi
2977 2977       Malaysia 2020-04-18 22:32:28 4.210484 101.975766 5305 88 3102 2115 Malaysia
2978 2978       Maldives 2020-04-18 22:32:28 3.2028 73.2207 35 0 16 19 Maldives
2979 2979       Mali 2020-04-18 22:32:28 17.570692 -3.996166 216 13 41 162 Mali
2980 2980       Malta 2020-04-18 22:32:28 35.9375 14.3754 426 3 99 324 Malta
2981 2981       Mauritania 2020-04-18 22:32:28 21.0079 -10.9408 7 1 2 4 Mauritania
2982 2982       Mauritius 2020-04-18 22:32:28 -20.348404 57.552152 325 9 180 136 Mauritius
2983 2983       Mexico 2020-04-18 22:32:28 23.6345 -102.5528 6875 546 2125 4204 Mexico
2984 2984       Moldova 2020-04-18 22:32:28 47.4116 28.3699 2378 57 391 1930 Moldova
2985 2985       Monaco 2020-04-18 22:32:28 43.7333 7.4167 94 3 22 69 Monaco
2986 2986       Mongolia 2020-04-18 22:32:28 46.8625 103.8467 31 0 5 26 Mongolia
2987 2987       Montenegro 2020-04-18 22:32:28 42.708678 19.37439 307 5 55 247 Montenegro
2988 2988       Morocco 2020-04-18 22:32:28 31.7917 -7.0926 2685 137 314 2234 Morocco
2989 2989       Mozambique 2020-04-18 22:32:28 -18.665695 35.529562 35 0 4 31 Mozambique
2990 2990       Namibia 2020-04-18 22:32:28 -22.9576 18.4904 16 0 6 10 Namibia
2991 2991       Nepal 2020-04-18 22:32:28 28.1667 84.25 31 0 2 29 Nepal
2992 2992       Netherlands 2020-04-18 22:32:28 52.1326 5.2913 31589 3601 250 27738 Netherlands
2993 2993       New Zealand 2020-04-18 22:32:28 -40.9006 174.886 1422 11 867 544 New Zealand
2994 2994       Nicaragua 2020-04-18 22:32:28 12.865416 -85.207229 9 2 6 1 Nicaragua
2995 2995       Niger 2020-04-18 22:32:28 17.607789 8.081666 639 19 113 507 Niger
2996 2996       Nigeria 2020-04-18 22:32:28 9.082 8.6753 542 19 166 357 Nigeria
2997 2997       North Macedonia 2020-04-18 22:32:28 41.6086 21.7453 1170 49 164 957 North Macedonia
2998 2998       Norway 2020-04-18 22:32:28 60.472 8.4689 7036 164 32 6840 Norway
2999 2999       Oman 2020-04-18 22:32:28 21.512583 55.923255 1180 6 176 998 Oman
3000 3000       Pakistan 2020-04-18 22:32:28 30.3753 69.3451 7638 143 1832 5663 Pakistan
3001 3001       Panama 2020-04-18 22:32:28 8.538 -80.7821 4210 116 122 3972 Panama
3002 3002       Papua New Guinea 2020-04-18 22:32:28 -6.314993 143.95555 7 0 0 7 Papua New Guinea
3003 3003       Paraguay 2020-04-18 22:32:28 -23.4425 -58.4438 202 8 35 159 Paraguay
3004 3004       Peru 2020-04-18 22:32:28 -9.19 -75.0152 14420 348 6684 7388 Peru
3005 3005       Philippines 2020-04-18 22:32:28 12.879721 121.774017 6087 397 516 5174 Philippines
3006 3006       Poland 2020-04-18 22:32:28 51.9194 19.1451 8742 347 981 7414 Poland
3007 3007       Portugal 2020-04-18 22:32:28 39.3999 -8.2245 19685 687 610 18388 Portugal
3008 3008       Qatar 2020-04-18 22:32:28 25.3548 51.1839 5008 8 510 4490 Qatar
3009 3009       Romania 2020-04-18 22:32:28 45.9432 24.9668 8418 421 1730 6267 Romania
3010 3010       Russia 2020-04-18 22:32:28 61.52401 105.318756 36793 313 3057 33423 Russia
3011 3011       Rwanda 2020-04-18 22:32:28 -1.9403 29.8739 144 0 69 75 Rwanda
3012 3012       Saint Kitts and Nevis 2020-04-18 22:32:28 17.357822 -62.782998 14 0 0 14 Saint Kitts and Nevis
3013 3013       Saint Lucia 2020-04-18 22:32:28 13.9094 -60.9789 15 0 11 4 Saint Lucia
3014 3014       Saint Vincent and the Grenadines 2020-04-18 22:32:28 12.9843 -61.2872 12 0 1 11 Saint Vincent and the Grenadines
3015 3015       Samoa 2020-04-18 22:40:03 -13.759 -172.1046 0 0 0 0 Samoa
3016 3016       San Marino 2020-04-18 22:32:28 43.9424 12.4578 455 39 60 356 San Marino
3017 3017       Sao Tome and Principe 2020-04-18 22:32:28 0.18636 6.613081 4 0 0 4 Sao Tome and Principe
3018 3018       Saudi Arabia 2020-04-18 22:32:28 23.885942 45.079162 8274 92 1329 6853 Saudi Arabia
3019 3019       Senegal 2020-04-18 22:32:28 14.4974 -14.4524 350 3 211 136 Senegal
3020 3020       Serbia 2020-04-18 22:32:28 44.0165 21.0059 5994 117 637 5240 Serbia
3021 3021       Seychelles 2020-04-18 22:32:28 -4.6796 55.492 11 0 5 6 Seychelles
3022 3022       Sierra Leone 2020-04-18 22:32:28 8.460555 -11.779889 30 0 0 30 Sierra Leone
3023 3023       Singapore 2020-04-18 22:32:28 1.2833 103.8333 5992 11 740 5241 Singapore
3024 3024       Slovakia 2020-04-18 22:32:28 48.669 19.699 1089 11 213 865 Slovakia
3025 3025       Slovenia 2020-04-18 22:32:28 46.1512 14.9955 1317 70 190 1057 Slovenia
3026 3026       Somalia 2020-04-18 22:32:28 5.152149 46.199616 135 7 2 126 Somalia
3027 3027       South Africa 2020-04-18 22:32:28 -30.5595 22.9375 3034 52 903 2079 South Africa
3028 3028       South Sudan 2020-04-18 22:32:28 6.877 31.307 4 0 0 4 South Sudan
3029 3029       Spain 2020-04-18 22:32:28 40.463667 -3.74922 191726 20043 74797 96886 Spain
3030 3030       Sri Lanka 2020-04-18 22:32:28 7.873054 80.771797 254 7 86 161 Sri Lanka
3031 3031       Sudan 2020-04-18 22:32:28 12.8628 30.2176 66 10 6 50 Sudan
3032 3032       Suriname 2020-04-18 22:32:28 3.9193 -56.0278 10 1 6 3 Suriname
3033 3033       Sweden 2020-04-18 22:32:28 60.128161 18.643501 13822 1511 550 11761 Sweden
3034 3034       Switzerland 2020-04-18 22:32:28 46.8182 8.2275 27404 1368 17100 8936 Switzerland
3035 3035       Syria 2020-04-18 22:32:28 34.802075 38.996815 38 2 5 31 Syria
3036 3036       Taiwan* 2020-04-18 11:05:23 23.7 121.0 398 6 178 214 Taiwan*
3037 3037       Tanzania 2020-04-18 22:32:28 -6.369028 34.888822 147 5 11 131 Tanzania
3038 3038       Thailand 2020-04-18 22:32:28 15.870032 100.992541 2733 47 1787 899 Thailand
3039 3039       Timor-Leste 2020-04-18 22:32:28 -8.874217 125.727539 18 0 1 17 Timor-Leste
3040 3040       Togo 2020-04-18 22:32:28 8.6195 0.8248 84 5 49 30 Togo
3041 3041       Trinidad and Tobago 2020-04-18 22:32:28 10.6918 -61.2225 114 8 21 85 Trinidad and Tobago
3042 3042       Tunisia 2020-04-18 22:32:28 33.886917 9.537499 864 37 43 784 Tunisia
3043 3043       Turkey 2020-04-18 22:32:28 38.9637 35.2433 82329 1890 10453 69986 Turkey
3044 3044       Uganda 2020-04-18 22:32:28 1.373333 32.290275 55 0 22 33 Uganda
3045 3045       Ukraine 2020-04-18 22:32:28 48.3794 31.1656 5106 133 275 4698 Ukraine
3046 3046       United Arab Emirates 2020-04-18 22:32:28 23.424076 53.847818 6302 37 1188 5077 United Arab Emirates
3047 3047       United Kingdom 2020-04-18 22:32:28 55.3781 -3.436 114217 15464 0 98753 United Kingdom
3048 3048       Uruguay 2020-04-18 22:32:28 -32.5228 -55.7658 508 9 294 205 Uruguay
3049 3049       Uzbekistan 2020-04-18 22:32:28 41.377491 64.585262 1490 5 194 1291 Uzbekistan
3050 3050       Venezuela 2020-04-18 22:32:28 6.4238 -66.5897 227 9 113 105 Venezuela
3051 3051       Vietnam 2020-04-18 22:32:28 14.058324 108.277199 268 0 201 67 Vietnam
3052 3052       West Bank and Gaza 2020-04-18 22:32:28 31.9522 35.2332 418 2 69 347 West Bank and Gaza
3053 3053       Yemen 2020-04-18 22:32:28 15.552727 48.516388 1 0 0 1 Yemen
3054 3054       Zambia 2020-04-18 22:32:28 -13.133897 27.849332 57 2 33 22 Zambia
3055 3055       Zimbabwe 2020-04-18 22:32:28 -19.015438 29.154857 25 3 2 20 Zimbabwe
102 102 1001 Autauga Alabama US 2020-04-18 22:32:47 32.53952745 -86.64408227 25 2 0 23 Autauga, Alabama, US
108 108 1003 Baldwin Alabama US 2020-04-18 22:32:47 30.72774991 -87.72207058 110 2 0 107 Baldwin, Alabama, US
119 119 1005 Barbour Alabama US 2020-04-18 22:32:47 31.868263 -85.3871286 18 0 0 18 Barbour, Alabama, US
180 180 1007 Bibb Alabama US 2020-04-18 22:32:47 32.99642064 -87.1251146 26 0 0 26 Bibb, Alabama, US
196 196 1009 Blount Alabama US 2020-04-18 22:32:47 33.98210918 -86.56790593 24 0 0 20 Blount, Alabama, US
271 271 1011 Bullock Alabama US 2020-04-18 22:32:47 32.10030533 -85.71265535 9 0 0 9 Bullock, Alabama, US
282 282 1013 Butler Alabama US 2020-04-18 22:32:47 31.75300095 -86.68057478 14 0 0 13 Butler, Alabama, US
305 305 1015 Calhoun Alabama US 2020-04-18 22:32:47 33.77483727 -85.82630386 71 2 0 64 Calhoun, Alabama, US
389 389 1017 Chambers Alabama US 2020-04-18 22:32:47 32.91360079 -85.39072749 242 11 0 229 Chambers, Alabama, US
416 416 1019 Cherokee Alabama US 2020-04-18 22:32:47 34.17805983 -85.60638968 12 0 0 12 Cherokee, Alabama, US
435 435 1021 Chilton Alabama US 2020-04-18 22:32:47 32.85044126 -86.7173256 41 0 0 39 Chilton, Alabama, US
440 440 1023 Choctaw Alabama US 2020-04-18 22:32:47 32.02227341 -88.2656443 16 0 0 14 Choctaw, Alabama, US
468 468 1025 Clarke Alabama US 2020-04-18 22:32:47 31.68099859 -87.83548597 21 0 0 24 Clarke, Alabama, US
474 474 1027 Clay Alabama US 2020-04-18 22:32:47 33.26984193 -85.85836077 16 0 0 17 Clay, Alabama, US
495 495 1029 Cleburne Alabama US 2020-04-18 22:32:47 33.67679204 -85.52005899 12 0 0 12 Cleburne, Alabama, US
518 518 1031 Coffee Alabama US 2020-04-18 22:32:47 31.39932826 -85.98901039 59 0 0 55 Coffee, Alabama, US
522 522 1033 Colbert Alabama US 2020-04-18 22:32:47 34.69847452 -87.80168544 19 1 0 14 Colbert, Alabama, US
549 549 1035 Conecuh Alabama US 2020-04-18 22:32:47 31.43401703 -86.99320044 9 0 0 10 Conecuh, Alabama, US
559 559 1037 Coosa Alabama US 2020-04-18 22:32:47 32.93690146 -86.24847739 25 1 0 21 Coosa, Alabama, US

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

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