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 rowid descending

✎ View and edit SQL

This data as json, copyable, CSV (advanced)

Suggested facets: Last_Update (date)

Link rowid ▲ FIPS Admin2 Province_State Country_Region Last_Update Lat Long_ Confirmed Deaths Recovered Active Combined_Key
2765 2765   unassigned Wyoming US 2020-04-05 23:06:45     0 0 0 0 unassigned, Wyoming, US
2764 2764       Zimbabwe 2020-04-05 23:06:26 -19.015438 29.154857 9 1 0 8 Zimbabwe
2763 2763       Zambia 2020-04-05 23:06:26 -13.133897 27.849332 39 1 3 35 Zambia
2762 2762       West Bank and Gaza 2020-04-05 23:06:26 31.9522 35.2332 237 1 25 211 West Bank and Gaza
2761 2761       Vietnam 2020-04-05 23:06:26 14.058323999999999 108.277199 241 0 90 151 Vietnam
2760 2760       Venezuela 2020-04-05 23:06:26 6.4238 -66.5897 159 7 52 100 Venezuela
2759 2759       Uzbekistan 2020-04-05 23:06:26 41.377491 64.585262 342 2 30 310 Uzbekistan
2758 2758       Uruguay 2020-04-05 23:06:26 -32.5228 -55.7658 400 5 93 302 Uruguay
2757 2757       United Kingdom 2020-04-05 23:06:26 55.3781 -3.4360000000000004 47806 4934 135 42737 United Kingdom
2756 2756       United Arab Emirates 2020-04-05 23:06:26 23.424076 53.847818000000004 1799 10 144 1645 United Arab Emirates
2755 2755       Ukraine 2020-04-05 23:06:26 48.3794 31.1656 1308 37 28 1243 Ukraine
2754 2754       Uganda 2020-04-05 23:06:26 1.373333 32.290275 52 0 0 52 Uganda
2753 2753       Turkey 2020-04-05 23:06:26 38.9637 35.2433 27069 574 1042 25453 Turkey
2752 2752       Tunisia 2020-04-05 23:06:26 33.886917 9.537499 574 22 5 547 Tunisia
2751 2751       Trinidad and Tobago 2020-04-05 23:06:26 10.6918 -61.2225 104 7 1 96 Trinidad and Tobago
2750 2750       Togo 2020-04-05 23:06:26 8.6195 0.8248 44 3 20 21 Togo
2749 2749       Timor-Leste 2020-04-05 23:06:26 -8.874217 125.727539 1 0 0 1 Timor-Leste
2748 2748       Thailand 2020-04-05 23:06:26 15.870032 100.992541 2169 23 674 1353 Thailand
2747 2747       Tanzania 2020-04-05 23:06:26 -6.369028 34.888822 22 1 3 18 Tanzania
2746 2746       Taiwan* 2020-04-05 10:54:07 23.7 121.0 363 5 50 308 Taiwan*
2745 2745       Syria 2020-04-05 23:06:26 34.802075 38.99681500000001 19 2 2 15 Syria
2744 2744       Switzerland 2020-04-05 23:06:26 46.8182 8.2275 21100 715 6415 13970 Switzerland
2743 2743       Sweden 2020-04-05 23:06:26 60.128161 18.643501 6830 401 205 6224 Sweden
2742 2742       Suriname 2020-04-05 23:06:26 3.9193 -56.0278 10 1 0 9 Suriname
2741 2741       Sudan 2020-04-05 23:06:26 12.8628 30.2176 12 2 2 8 Sudan
2740 2740       Sri Lanka 2020-04-05 23:06:26 7.873054 80.77179699999998 176 5 33 138 Sri Lanka
2739 2739       Spain 2020-04-05 23:06:26 40.463667 -3.7492199999999998 131646 12641 38080 80925 Spain
2738 2738       South Sudan 2020-04-05 23:06:26 6.8770000000000024 31.307 1 0 0 1 South Sudan
2737 2737       South Africa 2020-04-05 23:06:26 -30.5595 22.9375 1655 11 95 1549 South Africa
2736 2736       Somalia 2020-04-05 23:06:26 5.152149 46.199616 7 0 1 6 Somalia
2735 2735       Slovenia 2020-04-05 23:06:26 46.1512 14.9955 997 28 79 890 Slovenia
2734 2734       Slovakia 2020-04-05 23:06:26 48.669 19.699 485 1 10 474 Slovakia
2733 2733       Singapore 2020-04-05 23:06:26 1.2833 103.8333 1309 6 320 983 Singapore
2732 2732       Sierra Leone 2020-04-05 23:06:26 8.460555000000001 -11.779889 6 0 0 6 Sierra Leone
2731 2731       Seychelles 2020-04-05 23:06:26 -4.6796 55.492 10 0 0 10 Seychelles
2730 2730       Serbia 2020-04-05 23:06:26 44.0165 21.0059 1908 51 0 1857 Serbia
2729 2729       Senegal 2020-04-05 23:06:26 14.4974 -14.4524 222 2 82 138 Senegal
2728 2728       Saudi Arabia 2020-04-05 23:06:26 23.885942 45.079162 2402 34 488 1880 Saudi Arabia
2727 2727       San Marino 2020-04-05 23:06:26 43.9424 12.4578 266 32 35 199 San Marino
2726 2726       Samoa 2020-04-05 23:13:28 -13.759 -172.1046 0 0 0 0 Samoa
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
2724 2724       Saint Lucia 2020-04-05 23:06:26 13.9094 -60.9789 14 0 1 13 Saint Lucia
2723 2723       Saint Kitts and Nevis 2020-04-05 23:06:26 17.357822 -62.782998 10 0 0 10 Saint Kitts and Nevis
2722 2722       Rwanda 2020-04-05 23:06:26 -1.9403 29.8739 104 0 4 100 Rwanda
2721 2721       Russia 2020-04-05 23:06:26 61.52401 105.31875600000001 5389 45 355 4989 Russia
2720 2720       Romania 2020-04-05 23:06:26 45.9432 24.9668 3864 151 374 3339 Romania
2719 2719       Qatar 2020-04-05 23:06:26 25.3548 51.1839 1604 4 123 1477 Qatar
2718 2718       Portugal 2020-04-05 23:06:26 39.3999 -8.2245 11278 295 75 10908 Portugal
2717 2717       Poland 2020-04-05 23:06:26 51.9194 19.1451 4102 94 134 3874 Poland
2716 2716       Philippines 2020-04-05 23:06:26 12.879721 121.77401699999999 3246 152 64 3030 Philippines
2715 2715       Peru 2020-04-05 23:06:26 -9.19 -75.0152 2281 83 989 1209 Peru
2714 2714       Paraguay 2020-04-05 23:06:26 -23.4425 -58.4438 104 3 12 89 Paraguay
2713 2713       Papua New Guinea 2020-04-05 23:06:26 -6.314993 143.95555 1 0 0 1 Papua New Guinea
2712 2712       Panama 2020-04-05 23:06:26 8.538 -80.7821 1801 46 13 1742 Panama
2711 2711       Pakistan 2020-04-05 23:06:26 30.3753 69.3451 3157 47 211 2899 Pakistan
2710 2710       Oman 2020-04-05 23:06:26 21.512583 55.92325500000001 298 2 61 235 Oman
2709 2709       Norway 2020-04-05 23:06:26 60.472 8.4689 5687 71 32 5584 Norway
2708 2708       North Macedonia 2020-04-05 23:06:26 41.6086 21.7453 555 18 23 514 North Macedonia
2707 2707       Nigeria 2020-04-05 23:06:26 9.082 8.6753 232 5 33 194 Nigeria
2706 2706       Niger 2020-04-05 23:06:26 17.607789 8.081666 184 10 13 161 Niger
2705 2705       Nicaragua 2020-04-05 23:06:26 12.865416 -85.207229 6 1 0 5 Nicaragua
2704 2704       New Zealand 2020-04-05 23:06:26 -40.9006 174.886 1039 1 156 882 New Zealand
2703 2703       Netherlands 2020-04-05 23:06:26 52.1326 5.2913 17851 1766 250 15835 Netherlands
2702 2702       Nepal 2020-04-05 23:06:26 28.1667 84.25 9 0 1 8 Nepal
2701 2701       Namibia 2020-04-05 23:06:26 -22.9576 18.4904 16 0 3 13 Namibia
2700 2700       Mozambique 2020-04-05 23:06:26 -18.665695 35.529562 10 0 1 9 Mozambique
2699 2699       Morocco 2020-04-05 23:06:26 31.7917 -7.0926 1021 70 76 875 Morocco
2698 2698       Montenegro 2020-04-05 23:06:26 42.708678000000006 19.37439 214 2 1 211 Montenegro
2697 2697       Mongolia 2020-04-05 23:06:26 46.8625 103.8467 14 0 2 12 Mongolia
2696 2696       Monaco 2020-04-05 23:06:26 43.7333 7.4167 73 1 3 69 Monaco
2695 2695       Moldova 2020-04-05 23:06:26 47.4116 28.3699 864 15 30 819 Moldova
2694 2694       Mexico 2020-04-05 23:06:26 23.6345 -102.5528 1890 79 633 1178 Mexico
2693 2693       Mauritius 2020-04-05 23:06:26 -20.348404000000002 57.552152 227 7 7 213 Mauritius
2692 2692       Mauritania 2020-04-05 23:06:26 21.0079 -10.9408 6 1 2 3 ,,Mauritania
2691 2691       Malta 2020-04-05 23:06:26 35.9375 14.3754 227 0 5 222 Malta
2690 2690       Mali 2020-04-05 23:06:26 17.570692 -3.996166000000001 45 5 1 39 Mali
2689 2689       Maldives 2020-04-05 23:06:26 3.2028 73.2207 19 0 13 6 Maldives
2688 2688       Malaysia 2020-04-05 23:06:26 4.210483999999999 101.97576600000001 3662 61 1005 2596 Malaysia
2687 2687       Malawi 2020-04-05 23:06:26 -13.254307999999998 34.301525 4 0 0 4 Malawi
2686 2686       Madagascar 2020-04-05 23:06:26 -18.766947000000002 46.869107 72 0 2 70 Madagascar
2685 2685       MS Zaandam 2020-04-05 23:06:26     9 2 0 7 ,,MS Zaandam
2684 2684       Luxembourg 2020-04-05 23:06:26 49.8153 6.1296 2804 36 500 2268 Luxembourg
2683 2683       Lithuania 2020-04-05 23:06:26 55.1694 23.8813 716 8 0 791 Lithuania
2682 2682       Liechtenstein 2020-04-05 23:06:26 47.14 9.55 77 1 0 76 Liechtenstein
2681 2681       Libya 2020-04-05 23:06:26 26.3351 17.228331 18 1 0 17 Libya
2680 2680       Liberia 2020-04-05 23:06:26 6.4280550000000005 -9.429499 13 3 3 7 Liberia
2679 2679       Lebanon 2020-04-05 23:06:26 33.8547 35.8623 527 18 54 455 Lebanon
2678 2678       Latvia 2020-04-05 23:06:26 56.8796 24.6032 533 1 1 531 Latvia
2677 2677       Laos 2020-04-05 23:06:26 19.856270000000002 102.495496 11 0 0 11 Laos
2676 2676       Kyrgyzstan 2020-04-05 23:06:26 41.20438 74.766098 147 1 9 137 Kyrgyzstan
2675 2675       Kuwait 2020-04-05 23:06:26 29.311659999999996 47.481766 556 1 99 456 Kuwait
2674 2674       Kosovo 2020-04-05 23:06:26 42.602636 20.902977 145 1 23 121 Kosovo
2673 2673       Korea, South 2020-04-05 23:06:26 35.90775700000001 127.766922 10237 183 6463 3591 Korea, South
2672 2672       Kenya 2020-04-05 23:06:26 -0.0236 37.9062 142 4 4 134 Kenya
2671 2671       Kazakhstan 2020-04-05 23:06:26 48.0196 66.9237 584 6 42 536 Kazakhstan
2670 2670       Jordan 2020-04-05 23:06:26 31.24 36.51 345 5 110 230 Jordan
2669 2669       Japan 2020-04-05 23:06:26 36.204824 138.252924 3139 77 514 2548 Japan
2668 2668       Jamaica 2020-04-05 23:06:26 18.1096 -77.2975 58 3 8 47 Jamaica
2667 2667       Italy 2020-04-05 23:06:26 41.87194 12.56738 128948 15887 21815 91246 Italy
2666 2666       Israel 2020-04-05 23:06:26 31.046051000000002 34.851612 8740 56 820 7904 Israel

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
);