03-29-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,437 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
3364 3364       Maldives 3/29/20 23:08 3.2028 73.2207 17 0 13 4 Maldives
3365 3365       Mali 3/29/20 23:08 17.570692 -3.996166 18 1 0 17 Mali
3366 3366       Malta 3/29/20 23:08 35.9375 14.3754 151 0 2 149 Malta
3367 3367       Mauritania 3/29/20 23:08 21.0079 -10.9408 5 0 2 3 ,,Mauritania
3368 3368       Mauritius 3/29/20 23:08 -20.348404 57.552152 107 3 0 104 Mauritius
3369 3369       Mexico 3/29/20 23:08 23.6345 -102.5528 848 16 4 828 Mexico
3370 3370       Moldova 3/29/20 23:08 47.4116 28.3699 263 2 2 259 Moldova
3371 3371       Monaco 3/29/20 23:08 43.7333 7.4167 46 1 1 44 Monaco
3372 3372       Mongolia 3/29/20 23:08 46.8625 103.8467 12 0 0 12 Mongolia
3373 3373       Montenegro 3/29/20 23:08 42.708678 19.37439 85 1 0 84 Montenegro
3374 3374       Morocco 3/29/20 23:08 31.7917 -7.0926 479 26 13 440 Morocco
3375 3375       Mozambique 3/29/20 23:08 -18.665695 35.529562 8 0 0 8 Mozambique
3376 3376       Namibia 3/29/20 23:08 -22.9576 18.4904 11 0 2 9 Namibia
3377 3377       Nepal 3/29/20 23:08 28.1667 84.25 5 0 1 4 Nepal
3378 3378       Netherlands 3/29/20 23:08 52.1326 5.2913 10866 771 250 9845 Netherlands
3379 3379       New Zealand 3/29/20 23:08 -40.9006 174.886 514 1 56 457 New Zealand
3380 3380       Nicaragua 3/29/20 23:08 12.865416 -85.207229 4 1 0 3 Nicaragua
3381 3381       Niger 3/29/20 23:08 17.607789 8.081666 18 1 0 17 Niger
3382 3382       Nigeria 3/29/20 23:08 9.082 8.6753 111 1 3 107 Nigeria
3383 3383       North Macedonia 3/29/20 23:08 41.6086 21.7453 259 6 3 250 North Macedonia
3384 3384       Norway 3/29/20 23:08 60.472 8.4689 4284 25 7 4252 Norway
3385 3385       Oman 3/29/20 23:08 21.512583 55.923255 167 0 23 144 Oman
3386 3386       Pakistan 3/29/20 23:08 30.3753 69.3451 1597 14 29 1554 Pakistan
3387 3387       Panama 3/29/20 23:08 8.538 -80.7821 901 17 4 880 Panama
3388 3388       Papua New Guinea 3/29/20 23:08 -6.314993 143.95555 1 0 0 1 Papua New Guinea
3389 3389       Paraguay 3/29/20 23:08 -23.4425 -58.4438 59 3 1 55 Paraguay
3390 3390       Peru 3/29/20 23:08 -9.19 -75.0152 852 18 16 818 Peru
3391 3391       Philippines 3/29/20 23:08 12.879721 121.774017 1418 71 42 1305 Philippines
3392 3392       Poland 3/29/20 23:08 51.9194 19.1451 1862 22 7 1833 Poland
3393 3393       Portugal 3/29/20 23:08 39.3999 -8.2245 5962 119 43 5800 Portugal
3394 3394       Qatar 3/29/20 23:08 25.3548 51.1839 634 1 48 585 Qatar
3395 3395       Romania 3/29/20 23:08 45.9432 24.9668 1815 43 206 1566 Romania
3396 3396       Russia 3/29/20 23:08 61.52401 105.318756 1534 8 64 1462 Russia
3397 3397       Rwanda 3/29/20 23:08 -1.9403 29.8739 70 0 0 70 Rwanda
3398 3398       Saint Kitts and Nevis 3/29/20 23:08 17.357822 -62.782998 2 0 0 2 Saint Kitts and Nevis
3399 3399       Saint Lucia 3/29/20 23:08 13.9094 -60.9789 9 0 1 8 Saint Lucia
3400 3400       Saint Vincent and the Grenadines 3/29/20 23:08 12.9843 -61.2872 1 0 1 0 Saint Vincent and the Grenadines
3401 3401       Samoa 3/29/20 23:13 -13.759 -172.1046 0 0 0 0 Samoa
3402 3402       San Marino 3/29/20 23:08 43.9424 12.4578 224 22 6 196 San Marino
3403 3403       Saudi Arabia 3/29/20 23:08 23.885942 45.079162 1299 8 66 1225 Saudi Arabia
3404 3404       Senegal 3/29/20 23:08 14.4974 -14.4524 142 0 27 115 Senegal
3405 3405       Serbia 3/29/20 23:08 44.0165 21.0059 741 13 0 728 Serbia
3406 3406       Seychelles 3/29/20 23:08 -4.6796 55.492 8 0 0 8 Seychelles
3407 3407       Singapore 3/29/20 23:08 1.2833 103.8333 844 3 212 629 Singapore
3408 3408       Slovakia 3/29/20 23:08 48.669 19.699 314 0 2 312 Slovakia
3409 3409       Slovenia 3/29/20 23:08 46.1512 14.9955 730 11 10 709 Slovenia
3410 3410       Somalia 3/29/20 23:08 5.152149 46.199616 3 0 0 3 Somalia
3411 3411       South Africa 3/29/20 23:08 -30.5595 22.9375 1280 2 31 1247 South Africa
3412 3412       Spain 3/29/20 23:08 40.463667 -3.74922 80110 6803 14709 58598 Spain
3413 3413       Sri Lanka 3/29/20 23:08 7.873054 80.771797 117 1 11 105 Sri Lanka
3414 3414       Sudan 3/29/20 23:08 12.8628 30.2176 5 1 0 5 Sudan
3415 3415       Suriname 3/29/20 23:08 3.9193 -56.0278 8 0 0 8 Suriname
3416 3416       Sweden 3/29/20 23:08 60.128161 18.643501 3700 110 16 3574 Sweden
3417 3417       Switzerland 3/29/20 23:08 46.8182 8.2275 14829 300 1595 12934 Switzerland
3418 3418       Syria 3/29/20 23:08 34.802075 38.996815 9 1 0 8 Syria
3419 3419       Taiwan* 3/29/20 8:04 23.7 121.0 298 2 30 266 Taiwan*
3420 3420       Tanzania 3/29/20 23:08 -6.369028 34.888822 14 0 1 13 Tanzania
3421 3421       Thailand 3/29/20 23:08 15.870032 100.992541 1388 7 111 1284 Thailand
3422 3422       Timor-Leste 3/29/20 23:08 -8.874217 125.727539 1 0 0 1 Timor-Leste
3423 3423       Togo 3/29/20 23:08 8.6195 0.8248 25 1 1 23 Togo
3424 3424       Trinidad and Tobago 3/29/20 23:08 10.6918 -61.2225 78 3 1 74 Trinidad and Tobago
3425 3425       Tunisia 3/29/20 23:08 33.886917 9.537499 312 8 2 302 Tunisia
3426 3426       Turkey 3/29/20 23:08 38.9637 35.2433 9217 131 105 8981 Turkey
3427 3427       Uganda 3/29/20 23:08 1.373333 32.290275 33 0 0 33 Uganda
3428 3428       Ukraine 3/29/20 23:08 48.3794 31.1656 475 10 6 459 Ukraine
3429 3429       United Arab Emirates 3/29/20 23:08 23.424076 53.847818 570 3 58 509 United Arab Emirates
3430 3430       United Kingdom 3/29/20 23:08 55.3781 -3.436 19522 1228 135 18159 United Kingdom
3431 3431       Uruguay 3/29/20 23:08 -32.5228 -55.7658 304 1 0 303 Uruguay
3432 3432       Uzbekistan 3/29/20 23:08 41.377491 64.585262 144 2 7 135 Uzbekistan
3433 3433       Venezuela 3/29/20 23:08 6.4238 -66.5897 119 2 39 78 Venezuela
3434 3434       Vietnam 3/29/20 23:08 14.058324 108.277199 188 0 25 163 Vietnam
3435 3435       West Bank and Gaza 3/29/20 23:08 31.9522 35.2332 109 1 18 90 West Bank and Gaza
3436 3436       Zambia 3/29/20 23:08 -13.133897 27.849332 29 0 0 29 Zambia
3437 3437       Zimbabwe 3/29/20 23:08 -19.015438 29.154857 7 1 0 6 Zimbabwe
111 111 1001 Autauga Alabama US 3/29/20 23:08 32.53952745 -86.64408227 6 0 0 0 Autauga, Alabama, US
120 120 1003 Baldwin Alabama US 3/29/20 23:08 30.72774991 -87.72207058 19 1 0 0 Baldwin, Alabama, US
132 132 1005 Barbour Alabama US 3/29/20 23:08 31.868263 -85.3871286 0 0 0 0 Barbour, Alabama, US
202 202 1007 Bibb Alabama US 3/29/20 23:08 32.99642064 -87.1251146 2 0 0 0 Bibb, Alabama, US
222 222 1009 Blount Alabama US 3/29/20 23:08 33.98210918 -86.56790593 7 0 0 0 Blount, Alabama, US
311 311 1011 Bullock Alabama US 3/29/20 23:08 32.10030533 -85.71265535 2 0 0 0 Bullock, Alabama, US
323 323 1013 Butler Alabama US 3/29/20 23:08 31.75300095 -86.68057478 1 0 0 0 Butler, Alabama, US
348 348 1015 Calhoun Alabama US 3/29/20 23:08 33.77483727 -85.82630386 4 0 0 0 Calhoun, Alabama, US
444 444 1017 Chambers Alabama US 3/29/20 23:08 32.91360079 -85.39072749 29 3 0 0 Chambers, Alabama, US
472 472 1019 Cherokee Alabama US 3/29/20 23:08 34.17805983 -85.60638968 1 0 0 0 Cherokee, Alabama, US
495 495 1021 Chilton Alabama US 3/29/20 23:08 32.85044126 -86.7173256 8 0 0 0 Chilton, Alabama, US
501 501 1023 Choctaw Alabama US 3/29/20 23:08 32.02227341 -88.2656443 1 0 0 0 Choctaw, Alabama, US
533 533 1025 Clarke Alabama US 3/29/20 23:08 31.68099859 -87.83548597 0 0 0 0 Clarke, Alabama, US
539 539 1027 Clay Alabama US 3/29/20 23:08 33.26984193 -85.85836077 2 0 0 0 Clay, Alabama, US
563 563 1029 Cleburne Alabama US 3/29/20 23:08 33.67679204 -85.52005899 5 0 0 0 Cleburne, Alabama, US
588 588 1031 Coffee Alabama US 3/29/20 23:08 31.39932826 -85.98901039 0 0 0 0 Coffee, Alabama, US
593 593 1033 Colbert Alabama US 3/29/20 23:08 34.69847452 -87.80168544 2 0 0 0 Colbert, Alabama, US
623 623 1035 Conecuh Alabama US 3/29/20 23:08 31.43401703 -86.99320044 0 0 0 0 Conecuh, Alabama, US
635 635 1037 Coosa Alabama US 3/29/20 23:08 32.93690146 -86.24847739 3 0 0 0 Coosa, Alabama, US
645 645 1039 Covington Alabama US 3/29/20 23:08 31.2477854 -86.45050893 2 0 0 0 Covington, Alabama, US
668 668 1041 Crenshaw Alabama US 3/29/20 23:08 31.72941803 -86.31593104 1 0 0 0 Crenshaw, Alabama, US
681 681 1043 Cullman Alabama US 3/29/20 23:08 34.13020303 -86.86888037 7 0 0 0 Cullman, Alabama, US
707 707 1045 Dale Alabama US 3/29/20 23:08 31.43037123 -85.61095742 0 0 0 0 Dale, Alabama, US
709 709 1047 Dallas Alabama US 3/29/20 23:08 32.32688101 -87.1086671 2 0 0 0 Dallas, Alabama, US
739 739 1049 DeKalb Alabama US 3/29/20 23:08 34.45946862 -85.80782906 4 0 0 0 DeKalb, Alabama, US
873 873 1051 Elmore Alabama US 3/29/20 23:08 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-29-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
);