03-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,433 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
3360 3360       Maldives 3/28/20 23:05 3.2028 73.2207 16 0 9 7 Maldives
3361 3361       Mali 3/28/20 23:05 17.570692 -3.996166 18 0 0 18 Mali
3362 3362       Malta 3/28/20 23:05 35.9375 14.3754 149 0 2 147 Malta
3363 3363       Mauritania 3/28/20 23:05 21.0079 -10.9408 5 0 0 5 ,,Mauritania
3364 3364       Mauritius 3/28/20 23:05 -20.348404 57.552152 102 2 0 100 Mauritius
3365 3365       Mexico 3/28/20 23:05 23.6345 -102.5528 717 12 4 701 Mexico
3366 3366       Moldova 3/28/20 23:05 47.4116 28.3699 231 2 2 227 Moldova
3367 3367       Monaco 3/28/20 23:05 43.7333 7.4167 42 0 1 41 Monaco
3368 3368       Mongolia 3/28/20 23:05 46.8625 103.8467 12 0 0 12 Mongolia
3369 3369       Montenegro 3/28/20 23:05 42.708678 19.37439 84 1 0 83 Montenegro
3370 3370       Morocco 3/28/20 23:05 31.7917 -7.0926 402 25 11 366 Morocco
3371 3371       Mozambique 3/28/20 23:05 -18.665695 35.529562 8 0 0 8 Mozambique
3372 3372       Namibia 3/28/20 23:05 -22.9576 18.4904 8 0 2 6 Namibia
3373 3373       Nepal 3/28/20 23:05 28.1667 84.25 5 0 1 4 Nepal
3374 3374       Netherlands 3/28/20 23:05 52.1326 5.2913 9762 639 3 9120 Netherlands
3375 3375       New Zealand 3/28/20 23:05 -40.9006 174.886 451 0 50 401 New Zealand
3376 3376       Nicaragua 3/28/20 23:05 12.865416 -85.207229 4 1 0 3 Nicaragua
3377 3377       Niger 3/28/20 23:05 17.607789 8.081666 10 1 0 9 Niger
3378 3378       Nigeria 3/28/20 23:05 9.082 8.6753 89 1 3 85 Nigeria
3379 3379       North Macedonia 3/28/20 23:05 41.6086 21.7453 241 4 3 234 North Macedonia
3380 3380       Norway 3/28/20 23:05 60.472 8.4689 4015 23 7 3985 Norway
3381 3381       Oman 3/28/20 23:05 21.512583 55.923255 152 0 23 129 Oman
3382 3382       Pakistan 3/28/20 23:05 30.3753 69.3451 1495 12 29 1454 Pakistan
3383 3383       Panama 3/28/20 23:05 8.538 -80.7821 786 14 2 770 Panama
3384 3384       Papua New Guinea 3/28/20 23:05 -6.314993 143.95555 1 0 0 1 Papua New Guinea
3385 3385       Paraguay 3/28/20 23:05 -23.4425 -58.4438 56 3 1 52 Paraguay
3386 3386       Peru 3/28/20 23:05 -9.19 -75.0152 671 16 16 639 Peru
3387 3387       Philippines 3/28/20 23:05 12.879721 121.774017 1075 68 35 972 Philippines
3388 3388       Poland 3/28/20 23:05 51.9194 19.1451 1638 18 7 1613 Poland
3389 3389       Portugal 3/28/20 23:05 39.3999 -8.2245 5170 100 43 5027 Portugal
3390 3390       Qatar 3/28/20 23:05 25.3548 51.1839 590 1 45 544 Qatar
3391 3391       Romania 3/28/20 23:05 45.9432 24.9668 1452 37 139 1276 Romania
3392 3392       Russia 3/28/20 23:05 61.52401 105.318756 1264 4 49 1211 Russia
3393 3393       Rwanda 3/28/20 23:05 -1.9403 29.8739 60 0 0 60 Rwanda
3394 3394       Saint Kitts and Nevis 3/28/20 23:05 17.357822 -62.782998 2 0 0 2 Saint Kitts and Nevis
3395 3395       Saint Lucia 3/28/20 23:05 13.9094 -60.9789 3 0 1 2 Saint Lucia
3396 3396       Saint Vincent and the Grenadines 3/28/20 23:05 12.9843 -61.2872 1 0 1 0 Saint Vincent and the Grenadines
3397 3397       Samoa 3/28/20 23:10 -13.759 -172.1046 0 0 0 0 Samoa
3398 3398       San Marino 3/28/20 23:05 43.9424 12.4578 224 22 6 196 San Marino
3399 3399       Saudi Arabia 3/28/20 23:05 23.885942 45.079162 1203 4 37 1162 Saudi Arabia
3400 3400       Senegal 3/28/20 23:05 14.4974 -14.4524 130 0 18 112 Senegal
3401 3401       Serbia 3/28/20 23:05 44.0165 21.0059 659 10 0 649 Serbia
3402 3402       Seychelles 3/28/20 23:05 -4.6796 55.492 8 0 0 8 Seychelles
3403 3403       Singapore 3/28/20 23:05 1.2833 103.8333 802 2 198 602 Singapore
3404 3404       Slovakia 3/28/20 23:05 48.669 19.699 292 0 2 290 Slovakia
3405 3405       Slovenia 3/28/20 23:05 46.1512 14.9955 684 9 10 665 Slovenia
3406 3406       Somalia 3/28/20 23:05 5.152149 46.199616 3 0 0 3 Somalia
3407 3407       South Africa 3/28/20 23:05 -30.5595 22.9375 1187 1 31 1155 South Africa
3408 3408       Spain 3/28/20 23:05 40.463667 -3.74922 73235 5982 12285 54968 Spain
3409 3409       Sri Lanka 3/28/20 23:05 7.873054 80.771797 113 1 9 103 Sri Lanka
3410 3410       Sudan 3/28/20 23:05 12.8628 30.2176 5 1 0 4 Sudan
3411 3411       Suriname 3/28/20 23:05 3.9193 -56.0278 8 0 0 8 Suriname
3412 3412       Sweden 3/28/20 23:05 60.128161 18.643501 3447 105 16 3326 Sweden
3413 3413       Switzerland 3/28/20 23:05 46.8182 8.2275 14076 264 1530 12282 Switzerland
3414 3414       Syria 3/28/20 23:05 34.802075 38.996815 5 0 0 5 Syria
3415 3415       Taiwan* 3/28/20 6:58 23.7 121.0 283 2 30 251 Taiwan*
3416 3416       Tanzania 3/28/20 23:05 -6.369028 34.888822 14 0 1 13 Tanzania
3417 3417       Thailand 3/28/20 23:05 15.870032 100.992541 1245 6 100 1142 Thailand
3418 3418       Timor-Leste 3/28/20 23:05 -8.874217 125.727539 1 0 0 1 Timor-Leste
3419 3419       Togo 3/28/20 23:05 8.6195 0.8248 25 1 1 23 Togo
3420 3420       Trinidad and Tobago 3/28/20 23:05 10.6918 -61.2225 74 3 1 70 Trinidad and Tobago
3421 3421       Tunisia 3/28/20 23:05 33.886917 9.537499 278 8 2 268 Tunisia
3422 3422       Turkey 3/28/20 23:05 38.9637 35.2433 7402 108 70 7224 Turkey
3423 3423       Uganda 3/28/20 23:05 1.373333 32.290275 30 0 0 30 Uganda
3424 3424       Ukraine 3/28/20 23:05 48.3794 31.1656 356 9 5 342 Ukraine
3425 3425       United Arab Emirates 3/28/20 23:05 23.424076 53.847818 468 2 52 414 United Arab Emirates
3426 3426       United Kingdom 3/28/20 23:05 55.3781 -3.436 17089 1019 135 15935 United Kingdom
3427 3427       Uruguay 3/28/20 23:05 -32.5228 -55.7658 274 0 0 274 Uruguay
3428 3428       Uzbekistan 3/28/20 23:05 41.377491 64.585262 104 2 5 97 Uzbekistan
3429 3429       Venezuela 3/28/20 23:05 6.4238 -66.5897 119 2 39 78 Venezuela
3430 3430       Vietnam 3/28/20 23:05 14.058324 108.277199 174 0 21 153 Vietnam
3431 3431       West Bank and Gaza 3/28/20 23:05 31.9522 35.2332 98 1 18 79 West Bank and Gaza
3432 3432       Zambia 3/28/20 23:05 -13.133897 27.849332 28 0 0 28 Zambia
3433 3433       Zimbabwe 3/28/20 23:05 -19.015438 29.154857 7 1 0 6 Zimbabwe
111 111 1001 Autauga Alabama US 3/28/20 23:05 32.53952745 -86.64408227 6 0 0 0 Autauga, Alabama, US
120 120 1003 Baldwin Alabama US 3/28/20 23:05 30.72774991 -87.72207058 18 0 0 0 Baldwin, Alabama, US
132 132 1005 Barbour Alabama US 3/28/20 23:05 31.868263 -85.3871286 0 0 0 0 Barbour, Alabama, US
202 202 1007 Bibb Alabama US 3/28/20 23:05 32.99642064 -87.1251146 2 0 0 0 Bibb, Alabama, US
222 222 1009 Blount Alabama US 3/28/20 23:05 33.98210918 -86.56790593 6 0 0 0 Blount, Alabama, US
311 311 1011 Bullock Alabama US 3/28/20 23:05 32.10030533 -85.71265535 2 0 0 0 Bullock, Alabama, US
323 323 1013 Butler Alabama US 3/28/20 23:05 31.75300095 -86.68057478 1 0 0 0 Butler, Alabama, US
348 348 1015 Calhoun Alabama US 3/28/20 23:05 33.77483727 -85.82630386 4 0 0 0 Calhoun, Alabama, US
444 444 1017 Chambers Alabama US 3/28/20 23:05 32.91360079 -85.39072749 22 0 0 0 Chambers, Alabama, US
472 472 1019 Cherokee Alabama US 3/28/20 23:05 34.17805983 -85.60638968 1 0 0 0 Cherokee, Alabama, US
495 495 1021 Chilton Alabama US 3/28/20 23:05 32.85044126 -86.7173256 7 0 0 0 Chilton, Alabama, US
501 501 1023 Choctaw Alabama US 3/28/20 23:05 32.02227341 -88.2656443 1 0 0 0 Choctaw, Alabama, US
533 533 1025 Clarke Alabama US 3/28/20 23:05 31.68099859 -87.83548597 0 0 0 0 Clarke, Alabama, US
539 539 1027 Clay Alabama US 3/28/20 23:05 33.26984193 -85.85836077 2 0 0 0 Clay, Alabama, US
563 563 1029 Cleburne Alabama US 3/28/20 23:05 33.67679204 -85.52005899 4 0 0 0 Cleburne, Alabama, US
588 588 1031 Coffee Alabama US 3/28/20 23:05 31.39932826 -85.98901039 0 0 0 0 Coffee, Alabama, US
593 593 1033 Colbert Alabama US 3/28/20 23:05 34.69847452 -87.80168544 2 0 0 0 Colbert, Alabama, US
623 623 1035 Conecuh Alabama US 3/28/20 23:05 31.43401703 -86.99320044 0 0 0 0 Conecuh, Alabama, US
635 635 1037 Coosa Alabama US 3/28/20 23:05 32.93690146 -86.24847739 2 0 0 0 Coosa, Alabama, US
645 645 1039 Covington Alabama US 3/28/20 23:05 31.2477854 -86.45050893 2 0 0 0 Covington, Alabama, US
668 668 1041 Crenshaw Alabama US 3/28/20 23:05 31.72941803 -86.31593104 1 0 0 0 Crenshaw, Alabama, US
681 681 1043 Cullman Alabama US 3/28/20 23:05 34.13020303 -86.86888037 7 0 0 0 Cullman, Alabama, US
707 707 1045 Dale Alabama US 3/28/20 23:05 31.43037123 -85.61095742 0 0 0 0 Dale, Alabama, US
709 709 1047 Dallas Alabama US 3/28/20 23:05 32.32688101 -87.1086671 2 0 0 0 Dallas, Alabama, US
739 739 1049 DeKalb Alabama US 3/28/20 23:05 34.45946862 -85.80782906 4 0 0 0 DeKalb, Alabama, US
873 873 1051 Elmore Alabama US 3/28/20 23:05 32.59785413 -86.14415284 12 0 0 0 Elmore, Alabama, US

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

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