04-05-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

2,765 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
2686 2686       Madagascar 2020-04-05 23:06:26 -18.766947000000002 46.869107 72 0 2 70 Madagascar
2687 2687       Malawi 2020-04-05 23:06:26 -13.254307999999998 34.301525 4 0 0 4 Malawi
2688 2688       Malaysia 2020-04-05 23:06:26 4.210483999999999 101.97576600000001 3662 61 1005 2596 Malaysia
2689 2689       Maldives 2020-04-05 23:06:26 3.2028 73.2207 19 0 13 6 Maldives
2690 2690       Mali 2020-04-05 23:06:26 17.570692 -3.996166000000001 45 5 1 39 Mali
2691 2691       Malta 2020-04-05 23:06:26 35.9375 14.3754 227 0 5 222 Malta
2692 2692       Mauritania 2020-04-05 23:06:26 21.0079 -10.9408 6 1 2 3 ,,Mauritania
2693 2693       Mauritius 2020-04-05 23:06:26 -20.348404000000002 57.552152 227 7 7 213 Mauritius
2694 2694       Mexico 2020-04-05 23:06:26 23.6345 -102.5528 1890 79 633 1178 Mexico
2695 2695       Moldova 2020-04-05 23:06:26 47.4116 28.3699 864 15 30 819 Moldova
2696 2696       Monaco 2020-04-05 23:06:26 43.7333 7.4167 73 1 3 69 Monaco
2697 2697       Mongolia 2020-04-05 23:06:26 46.8625 103.8467 14 0 2 12 Mongolia
2698 2698       Montenegro 2020-04-05 23:06:26 42.708678000000006 19.37439 214 2 1 211 Montenegro
2699 2699       Morocco 2020-04-05 23:06:26 31.7917 -7.0926 1021 70 76 875 Morocco
2700 2700       Mozambique 2020-04-05 23:06:26 -18.665695 35.529562 10 0 1 9 Mozambique
2701 2701       Namibia 2020-04-05 23:06:26 -22.9576 18.4904 16 0 3 13 Namibia
2702 2702       Nepal 2020-04-05 23:06:26 28.1667 84.25 9 0 1 8 Nepal
2703 2703       Netherlands 2020-04-05 23:06:26 52.1326 5.2913 17851 1766 250 15835 Netherlands
2704 2704       New Zealand 2020-04-05 23:06:26 -40.9006 174.886 1039 1 156 882 New Zealand
2705 2705       Nicaragua 2020-04-05 23:06:26 12.865416 -85.207229 6 1 0 5 Nicaragua
2706 2706       Niger 2020-04-05 23:06:26 17.607789 8.081666 184 10 13 161 Niger
2707 2707       Nigeria 2020-04-05 23:06:26 9.082 8.6753 232 5 33 194 Nigeria
2708 2708       North Macedonia 2020-04-05 23:06:26 41.6086 21.7453 555 18 23 514 North Macedonia
2709 2709       Norway 2020-04-05 23:06:26 60.472 8.4689 5687 71 32 5584 Norway
2710 2710       Oman 2020-04-05 23:06:26 21.512583 55.92325500000001 298 2 61 235 Oman
2711 2711       Pakistan 2020-04-05 23:06:26 30.3753 69.3451 3157 47 211 2899 Pakistan
2712 2712       Panama 2020-04-05 23:06:26 8.538 -80.7821 1801 46 13 1742 Panama
2713 2713       Papua New Guinea 2020-04-05 23:06:26 -6.314993 143.95555 1 0 0 1 Papua New Guinea
2714 2714       Paraguay 2020-04-05 23:06:26 -23.4425 -58.4438 104 3 12 89 Paraguay
2715 2715       Peru 2020-04-05 23:06:26 -9.19 -75.0152 2281 83 989 1209 Peru
2716 2716       Philippines 2020-04-05 23:06:26 12.879721 121.77401699999999 3246 152 64 3030 Philippines
2717 2717       Poland 2020-04-05 23:06:26 51.9194 19.1451 4102 94 134 3874 Poland
2718 2718       Portugal 2020-04-05 23:06:26 39.3999 -8.2245 11278 295 75 10908 Portugal
2719 2719       Qatar 2020-04-05 23:06:26 25.3548 51.1839 1604 4 123 1477 Qatar
2720 2720       Romania 2020-04-05 23:06:26 45.9432 24.9668 3864 151 374 3339 Romania
2721 2721       Russia 2020-04-05 23:06:26 61.52401 105.31875600000001 5389 45 355 4989 Russia
2722 2722       Rwanda 2020-04-05 23:06:26 -1.9403 29.8739 104 0 4 100 Rwanda
2723 2723       Saint Kitts and Nevis 2020-04-05 23:06:26 17.357822 -62.782998 10 0 0 10 Saint Kitts and Nevis
2724 2724       Saint Lucia 2020-04-05 23:06:26 13.9094 -60.9789 14 0 1 13 Saint Lucia
2725 2725       Saint Vincent and the Grenadines 2020-04-05 23:06:26 12.9843 -61.2872 7 0 1 6 Saint Vincent and the Grenadines
2726 2726       Samoa 2020-04-05 23:13:28 -13.759 -172.1046 0 0 0 0 Samoa
2727 2727       San Marino 2020-04-05 23:06:26 43.9424 12.4578 266 32 35 199 San Marino
2728 2728       Saudi Arabia 2020-04-05 23:06:26 23.885942 45.079162 2402 34 488 1880 Saudi Arabia
2729 2729       Senegal 2020-04-05 23:06:26 14.4974 -14.4524 222 2 82 138 Senegal
2730 2730       Serbia 2020-04-05 23:06:26 44.0165 21.0059 1908 51 0 1857 Serbia
2731 2731       Seychelles 2020-04-05 23:06:26 -4.6796 55.492 10 0 0 10 Seychelles
2732 2732       Sierra Leone 2020-04-05 23:06:26 8.460555000000001 -11.779889 6 0 0 6 Sierra Leone
2733 2733       Singapore 2020-04-05 23:06:26 1.2833 103.8333 1309 6 320 983 Singapore
2734 2734       Slovakia 2020-04-05 23:06:26 48.669 19.699 485 1 10 474 Slovakia
2735 2735       Slovenia 2020-04-05 23:06:26 46.1512 14.9955 997 28 79 890 Slovenia
2736 2736       Somalia 2020-04-05 23:06:26 5.152149 46.199616 7 0 1 6 Somalia
2737 2737       South Africa 2020-04-05 23:06:26 -30.5595 22.9375 1655 11 95 1549 South Africa
2738 2738       South Sudan 2020-04-05 23:06:26 6.8770000000000024 31.307 1 0 0 1 South Sudan
2739 2739       Spain 2020-04-05 23:06:26 40.463667 -3.7492199999999998 131646 12641 38080 80925 Spain
2740 2740       Sri Lanka 2020-04-05 23:06:26 7.873054 80.77179699999998 176 5 33 138 Sri Lanka
2741 2741       Sudan 2020-04-05 23:06:26 12.8628 30.2176 12 2 2 8 Sudan
2742 2742       Suriname 2020-04-05 23:06:26 3.9193 -56.0278 10 1 0 9 Suriname
2743 2743       Sweden 2020-04-05 23:06:26 60.128161 18.643501 6830 401 205 6224 Sweden
2744 2744       Switzerland 2020-04-05 23:06:26 46.8182 8.2275 21100 715 6415 13970 Switzerland
2745 2745       Syria 2020-04-05 23:06:26 34.802075 38.99681500000001 19 2 2 15 Syria
2746 2746       Taiwan* 2020-04-05 10:54:07 23.7 121.0 363 5 50 308 Taiwan*
2747 2747       Tanzania 2020-04-05 23:06:26 -6.369028 34.888822 22 1 3 18 Tanzania
2748 2748       Thailand 2020-04-05 23:06:26 15.870032 100.992541 2169 23 674 1353 Thailand
2749 2749       Timor-Leste 2020-04-05 23:06:26 -8.874217 125.727539 1 0 0 1 Timor-Leste
2750 2750       Togo 2020-04-05 23:06:26 8.6195 0.8248 44 3 20 21 Togo
2751 2751       Trinidad and Tobago 2020-04-05 23:06:26 10.6918 -61.2225 104 7 1 96 Trinidad and Tobago
2752 2752       Tunisia 2020-04-05 23:06:26 33.886917 9.537499 574 22 5 547 Tunisia
2753 2753       Turkey 2020-04-05 23:06:26 38.9637 35.2433 27069 574 1042 25453 Turkey
2754 2754       Uganda 2020-04-05 23:06:26 1.373333 32.290275 52 0 0 52 Uganda
2755 2755       Ukraine 2020-04-05 23:06:26 48.3794 31.1656 1308 37 28 1243 Ukraine
2756 2756       United Arab Emirates 2020-04-05 23:06:26 23.424076 53.847818000000004 1799 10 144 1645 United Arab Emirates
2757 2757       United Kingdom 2020-04-05 23:06:26 55.3781 -3.4360000000000004 47806 4934 135 42737 United Kingdom
2758 2758       Uruguay 2020-04-05 23:06:26 -32.5228 -55.7658 400 5 93 302 Uruguay
2759 2759       Uzbekistan 2020-04-05 23:06:26 41.377491 64.585262 342 2 30 310 Uzbekistan
2760 2760       Venezuela 2020-04-05 23:06:26 6.4238 -66.5897 159 7 52 100 Venezuela
2761 2761       Vietnam 2020-04-05 23:06:26 14.058323999999999 108.277199 241 0 90 151 Vietnam
2762 2762       West Bank and Gaza 2020-04-05 23:06:26 31.9522 35.2332 237 1 25 211 West Bank and Gaza
2763 2763       Zambia 2020-04-05 23:06:26 -13.133897 27.849332 39 1 3 35 Zambia
2764 2764       Zimbabwe 2020-04-05 23:06:26 -19.015438 29.154857 9 1 0 8 Zimbabwe
94 94 1001 Autauga Alabama US 2020-04-05 23:06:45 32.53952745 -86.64408227 12 0 0 0 Autauga, Alabama, US
100 100 1003 Baldwin Alabama US 2020-04-05 23:06:45 30.72774991 -87.72207058 39 1 0 0 Baldwin, Alabama, US
107 107 1005 Barbour Alabama US 2020-04-05 23:06:45 31.868263 -85.3871286 3 0 0 0 Barbour, Alabama, US
164 164 1007 Bibb Alabama US 2020-04-05 23:06:45 32.99642064 -87.12511459999996 7 0 0 0 Bibb, Alabama, US
178 178 1009 Blount Alabama US 2020-04-05 23:06:45 33.98210918 -86.56790593 13 0 0 0 Blount, Alabama, US
243 243 1011 Bullock Alabama US 2020-04-05 23:06:45 32.10030533 -85.71265535 2 0 0 0 Bullock, Alabama, US
253 253 1013 Butler Alabama US 2020-04-05 23:06:45 31.75300095 -86.68057478 1 0 0 0 Butler, Alabama, US
276 276 1015 Calhoun Alabama US 2020-04-05 23:06:45 33.77483727 -85.82630386 26 0 0 0 Calhoun, Alabama, US
356 356 1017 Chambers Alabama US 2020-04-05 23:06:45 32.91360079 -85.39072749 94 6 0 0 Chambers, Alabama, US
382 382 1019 Cherokee Alabama US 2020-04-05 23:06:45 34.17805983 -85.60638968 5 0 0 0 Cherokee, Alabama, US
399 399 1021 Chilton Alabama US 2020-04-05 23:06:45 32.85044126 -86.7173256 18 0 0 0 Chilton, Alabama, US
404 404 1023 Choctaw Alabama US 2020-04-05 23:06:45 32.02227341 -88.26564429999998 6 0 0 0 Choctaw, Alabama, US
431 431 1025 Clarke Alabama US 2020-04-05 23:06:45 31.68099859 -87.83548597 9 0 0 0 Clarke, Alabama, US
437 437 1027 Clay Alabama US 2020-04-05 23:06:45 33.26984193 -85.85836077 9 0 0 0 Clay, Alabama, US
455 455 1029 Cleburne Alabama US 2020-04-05 23:06:45 33.67679204 -85.52005899 7 0 0 0 Cleburne, Alabama, US
478 478 1031 Coffee Alabama US 2020-04-05 23:06:45 31.39932826 -85.98901039 8 0 0 0 Coffee, Alabama, US
482 482 1033 Colbert Alabama US 2020-04-05 23:06:45 34.69847452 -87.80168544 7 0 0 0 Colbert, Alabama, US
506 506 1035 Conecuh Alabama US 2020-04-05 23:06:45 31.43401703 -86.99320044 1 0 0 0 Conecuh, Alabama, US
514 514 1037 Coosa Alabama US 2020-04-05 23:06:45 32.93690146 -86.24847739 6 0 0 0 Coosa, Alabama, US
522 522 1039 Covington Alabama US 2020-04-05 23:06:45 31.247785399999998 -86.45050893 5 0 0 0 Covington, Alabama, US
544 544 1041 Crenshaw Alabama US 2020-04-05 23:06:45 31.72941803 -86.31593104 2 0 0 0 Crenshaw, Alabama, US

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

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