03-30-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,442 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
3368 3368       Malaysia 3/30/20 22:52 4.210484 101.975766 2626 37 479 2110 Malaysia
3369 3369       Maldives 3/30/20 22:52 3.2028 73.2207 17 0 13 4 Maldives
3370 3370       Mali 3/30/20 22:52 17.570692 -3.996166 25 2 0 23 Mali
3371 3371       Malta 3/30/20 22:52 35.9375 14.3754 156 0 2 154 Malta
3372 3372       Mauritania 3/30/20 22:52 21.0079 -10.9408 5 1 2 2 ,,Mauritania
3373 3373       Mauritius 3/30/20 22:52 -20.348404 57.552152 128 3 0 125 Mauritius
3374 3374       Mexico 3/30/20 22:52 23.6345 -102.5528 993 20 35 938 Mexico
3375 3375       Moldova 3/30/20 22:52 47.4116 28.3699 298 2 15 281 Moldova
3376 3376       Monaco 3/30/20 22:52 43.7333 7.4167 49 1 1 47 Monaco
3377 3377       Mongolia 3/30/20 22:52 46.8625 103.8467 12 0 2 10 Mongolia
3378 3378       Montenegro 3/30/20 22:52 42.708678 19.37439 91 1 0 90 Montenegro
3379 3379       Morocco 3/30/20 22:52 31.7917 -7.0926 556 33 15 508 Morocco
3380 3380       Mozambique 3/30/20 22:52 -18.665695 35.529562 8 0 0 8 Mozambique
3381 3381       Namibia 3/30/20 22:52 -22.9576 18.4904 11 0 2 9 Namibia
3382 3382       Nepal 3/30/20 22:52 28.1667 84.25 5 0 1 4 Nepal
3383 3383       Netherlands 3/30/20 22:52 52.1326 5.2913 11750 864 250 10636 Netherlands
3384 3384       New Zealand 3/30/20 22:52 -40.9006 174.886 589 1 63 525 New Zealand
3385 3385       Nicaragua 3/30/20 22:52 12.865416 -85.207229 4 1 0 3 Nicaragua
3386 3386       Niger 3/30/20 22:52 17.607789 8.081666 27 3 0 24 Niger
3387 3387       Nigeria 3/30/20 22:52 9.082 8.6753 131 2 8 121 Nigeria
3388 3388       North Macedonia 3/30/20 22:52 41.6086 21.7453 285 7 12 266 North Macedonia
3389 3389       Norway 3/30/20 22:52 60.472 8.4689 4445 32 12 4401 Norway
3390 3390       Oman 3/30/20 22:52 21.512583 55.923255 179 0 29 150 Oman
3391 3391       Pakistan 3/30/20 22:52 30.3753 69.3451 1717 21 76 1620 Pakistan
3392 3392       Panama 3/30/20 22:52 8.538 -80.7821 989 24 4 961 Panama
3393 3393       Papua New Guinea 3/30/20 22:52 -6.314993 143.95555 1 0 0 1 Papua New Guinea
3394 3394       Paraguay 3/30/20 22:52 -23.4425 -58.4438 64 3 1 60 Paraguay
3395 3395       Peru 3/30/20 22:52 -9.19 -75.0152 950 24 53 873 Peru
3396 3396       Philippines 3/30/20 22:52 12.879721 121.774017 1546 78 42 1426 Philippines
3397 3397       Poland 3/30/20 22:52 51.9194 19.1451 2055 31 7 2017 Poland
3398 3398       Portugal 3/30/20 22:52 39.3999 -8.2245 6408 140 43 6225 Portugal
3399 3399       Qatar 3/30/20 22:52 25.3548 51.1839 693 1 51 641 Qatar
3400 3400       Romania 3/30/20 22:52 45.9432 24.9668 2109 65 209 1835 Romania
3401 3401       Russia 3/30/20 22:52 61.52401 105.318756 1836 9 66 1761 Russia
3402 3402       Rwanda 3/30/20 22:52 -1.9403 29.8739 70 0 0 70 Rwanda
3403 3403       Saint Kitts and Nevis 3/30/20 22:52 17.357822 -62.782998 7 0 0 7 Saint Kitts and Nevis
3404 3404       Saint Lucia 3/30/20 22:52 13.9094 -60.9789 9 0 1 8 Saint Lucia
3405 3405       Saint Vincent and the Grenadines 3/30/20 22:52 12.9843 -61.2872 1 0 1 0 Saint Vincent and the Grenadines
3406 3406       Samoa 3/30/20 22:58 -13.759 -172.1046 0 0 0 0 Samoa
3407 3407       San Marino 3/30/20 22:52 43.9424 12.4578 230 25 13 192 San Marino
3408 3408       Saudi Arabia 3/30/20 22:52 23.885942 45.079162 1453 8 115 1330 Saudi Arabia
3409 3409       Senegal 3/30/20 22:52 14.4974 -14.4524 162 0 27 135 Senegal
3410 3410       Serbia 3/30/20 22:52 44.0165 21.0059 785 16 0 769 Serbia
3411 3411       Seychelles 3/30/20 22:52 -4.6796 55.492 8 0 0 8 Seychelles
3412 3412       Singapore 3/30/20 22:52 1.2833 103.8333 879 3 228 648 Singapore
3413 3413       Slovakia 3/30/20 22:52 48.669 19.699 336 0 7 329 Slovakia
3414 3414       Slovenia 3/30/20 22:52 46.1512 14.9955 756 11 10 735 Slovenia
3415 3415       Somalia 3/30/20 22:52 5.152149 46.199616 3 0 0 3 Somalia
3416 3416       South Africa 3/30/20 22:52 -30.5595 22.9375 1326 3 31 1292 South Africa
3417 3417       Spain 3/30/20 22:52 40.463667 -3.74922 87956 7716 16780 63460 Spain
3418 3418       Sri Lanka 3/30/20 22:52 7.873054 80.771797 122 2 15 105 Sri Lanka
3419 3419       Sudan 3/30/20 22:52 12.8628 30.2176 6 2 0 4 Sudan
3420 3420       Suriname 3/30/20 22:52 3.9193 -56.0278 8 0 0 8 Suriname
3421 3421       Sweden 3/30/20 22:52 60.128161 18.643501 4028 146 16 3866 Sweden
3422 3422       Switzerland 3/30/20 22:52 46.8182 8.2275 15922 359 1823 13740 Switzerland
3423 3423       Syria 3/30/20 22:52 34.802075 38.996815 10 2 0 8 Syria
3424 3424       Taiwan* 3/30/20 7:11 23.7 121.0 306 5 39 262 Taiwan*
3425 3425       Tanzania 3/30/20 22:52 -6.369028 34.888822 19 0 1 18 Tanzania
3426 3426       Thailand 3/30/20 22:52 15.870032 100.992541 1524 9 127 1286 Thailand
3427 3427       Timor-Leste 3/30/20 22:52 -8.874217 125.727539 1 0 0 1 Timor-Leste
3428 3428       Togo 3/30/20 22:52 8.6195 0.8248 30 1 1 28 Togo
3429 3429       Trinidad and Tobago 3/30/20 22:52 10.6918 -61.2225 82 3 1 78 Trinidad and Tobago
3430 3430       Tunisia 3/30/20 22:52 33.886917 9.537499 312 8 3 301 Tunisia
3431 3431       Turkey 3/30/20 22:52 38.9637 35.2433 10827 168 162 10497 Turkey
3432 3432       Uganda 3/30/20 22:52 1.373333 32.290275 33 0 0 33 Uganda
3433 3433       Ukraine 3/30/20 22:52 48.3794 31.1656 548 13 8 527 Ukraine
3434 3434       United Arab Emirates 3/30/20 22:52 23.424076 53.847818 611 5 61 545 United Arab Emirates
3435 3435       United Kingdom 3/30/20 22:52 55.3781 -3.436 22141 1408 135 20598 United Kingdom
3436 3436       Uruguay 3/30/20 22:52 -32.5228 -55.7658 310 1 0 309 Uruguay
3437 3437       Uzbekistan 3/30/20 22:52 41.377491 64.585262 149 2 7 140 Uzbekistan
3438 3438       Venezuela 3/30/20 22:52 6.4238 -66.5897 135 3 39 93 Venezuela
3439 3439       Vietnam 3/30/20 22:52 14.058324 108.277199 203 0 55 148 Vietnam
3440 3440       West Bank and Gaza 3/30/20 22:52 31.9522 35.2332 116 1 18 97 West Bank and Gaza
3441 3441       Zambia 3/30/20 22:52 -13.133897 27.849332 35 0 0 35 Zambia
3442 3442       Zimbabwe 3/30/20 22:52 -19.015438 29.154857 7 1 0 6 Zimbabwe
111 111 1001 Autauga Alabama US 3/30/20 22:52 32.53952745 -86.64408227 8 0 0 0 Autauga, Alabama, US
120 120 1003 Baldwin Alabama US 3/30/20 22:52 30.72774991 -87.72207058 22 1 0 0 Baldwin, Alabama, US
132 132 1005 Barbour Alabama US 3/30/20 22:52 31.868263 -85.3871286 0 0 0 0 Barbour, Alabama, US
202 202 1007 Bibb Alabama US 3/30/20 22:52 32.99642064 -87.1251146 3 0 0 0 Bibb, Alabama, US
222 222 1009 Blount Alabama US 3/30/20 22:52 33.98210918 -86.56790593 7 0 0 0 Blount, Alabama, US
311 311 1011 Bullock Alabama US 3/30/20 22:52 32.10030533 -85.71265535 2 0 0 0 Bullock, Alabama, US
323 323 1013 Butler Alabama US 3/30/20 22:52 31.75300095 -86.68057478 1 0 0 0 Butler, Alabama, US
348 348 1015 Calhoun Alabama US 3/30/20 22:52 33.77483727 -85.82630386 9 0 0 0 Calhoun, Alabama, US
444 444 1017 Chambers Alabama US 3/30/20 22:52 32.91360079 -85.39072749 39 3 0 0 Chambers, Alabama, US
472 472 1019 Cherokee Alabama US 3/30/20 22:52 34.17805983 -85.60638968 1 0 0 0 Cherokee, Alabama, US
495 495 1021 Chilton Alabama US 3/30/20 22:52 32.85044126 -86.7173256 10 0 0 0 Chilton, Alabama, US
501 501 1023 Choctaw Alabama US 3/30/20 22:52 32.02227341 -88.2656443 2 0 0 0 Choctaw, Alabama, US
533 533 1025 Clarke Alabama US 3/30/20 22:52 31.68099859 -87.83548597 0 0 0 0 Clarke, Alabama, US
539 539 1027 Clay Alabama US 3/30/20 22:52 33.26984193 -85.85836077 2 0 0 0 Clay, Alabama, US
563 563 1029 Cleburne Alabama US 3/30/20 22:52 33.67679204 -85.52005899 5 0 0 0 Cleburne, Alabama, US
588 588 1031 Coffee Alabama US 3/30/20 22:52 31.39932826 -85.98901039 0 0 0 0 Coffee, Alabama, US
593 593 1033 Colbert Alabama US 3/30/20 22:52 34.69847452 -87.80168544 4 0 0 0 Colbert, Alabama, US
623 623 1035 Conecuh Alabama US 3/30/20 22:52 31.43401703 -86.99320044 0 0 0 0 Conecuh, Alabama, US
635 635 1037 Coosa Alabama US 3/30/20 22:52 32.93690146 -86.24847739 3 0 0 0 Coosa, Alabama, US
645 645 1039 Covington Alabama US 3/30/20 22:52 31.2477854 -86.45050893 2 0 0 0 Covington, Alabama, US
668 668 1041 Crenshaw Alabama US 3/30/20 22:52 31.72941803 -86.31593104 1 0 0 0 Crenshaw, Alabama, US
681 681 1043 Cullman Alabama US 3/30/20 22:52 34.13020303 -86.86888037 8 0 0 0 Cullman, Alabama, US
707 707 1045 Dale Alabama US 3/30/20 22:52 31.43037123 -85.61095742 0 0 0 0 Dale, Alabama, US
709 709 1047 Dallas Alabama US 3/30/20 22:52 32.32688101 -87.1086671 2 0 0 0 Dallas, Alabama, US
739 739 1049 DeKalb Alabama US 3/30/20 22:52 34.45946862 -85.80782906 4 0 0 0 DeKalb, Alabama, US

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

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