04-06-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,810 rows sorted by rowid descending

✎ View and edit SQL

This data as json, copyable, CSV (advanced)

Suggested facets: Last_Update

Link rowid ▲ FIPS Admin2 Province_State Country_Region Last_Update Lat Long_ Confirmed Deaths Recovered Active Combined_Key
2810 2810   unassigned Wyoming US 4/6/20 23:22     0 0 0 0 unassigned, Wyoming, US
2809 2809       Zimbabwe 4/6/20 23:21 -19.015438 29.154857 10 1 0 9 Zimbabwe
2808 2808       Zambia 4/6/20 23:21 -13.133897 27.849332 39 1 5 33 Zambia
2807 2807       West Bank and Gaza 4/6/20 23:21 31.9522 35.2332 254 1 24 229 West Bank and Gaza
2806 2806       Vietnam 4/6/20 23:21 14.058324 108.277199 245 0 95 150 Vietnam
2805 2805       Venezuela 4/6/20 23:21 6.4238 -66.5897 165 7 65 93 Venezuela
2804 2804       Uzbekistan 4/6/20 23:21 41.377491 64.585262 457 2 30 425 Uzbekistan
2803 2803       Uruguay 4/6/20 23:21 -32.5228 -55.7658 406 6 104 296 Uruguay
2802 2802       United Kingdom 4/6/20 23:21 55.3781 -3.436 51608 5373 135 46100 United Kingdom
2801 2801       United Arab Emirates 4/6/20 23:21 23.424076 53.847818 2076 11 167 1898 United Arab Emirates
2800 2800       Ukraine 4/6/20 23:21 48.3794 31.1656 1319 38 28 1253 Ukraine
2799 2799       Uganda 4/6/20 23:21 1.373333 32.290275 52 0 0 52 Uganda
2798 2798       Turkey 4/6/20 23:21 38.9637 35.2433 30217 649 1326 28242 Turkey
2797 2797       Tunisia 4/6/20 23:21 33.886917 9.537499 596 22 5 569 Tunisia
2796 2796       Trinidad and Tobago 4/6/20 23:21 10.6918 -61.2225 105 8 1 96 Trinidad and Tobago
2795 2795       Togo 4/6/20 23:21 8.6195 0.8248 58 3 23 32 Togo
2794 2794       Timor-Leste 4/6/20 23:21 -8.874217 125.727539 1 0 0 1 Timor-Leste
2793 2793       Thailand 4/6/20 23:21 15.870032 100.992541 2220 26 793 1401 Thailand
2792 2792       Tanzania 4/6/20 23:21 -6.369028 34.888822 24 1 3 20 Tanzania
2791 2791       Taiwan* 4/6/20 6:20 23.7 121.0 373 5 57 311 Taiwan*
2790 2790       Syria 4/6/20 23:21 34.802075 38.996815 19 2 2 15 Syria
2789 2789       Switzerland 4/6/20 23:21 46.8182 8.2275 21657 765 8056 12836 Switzerland
2788 2788       Sweden 4/6/20 23:21 60.128161 18.643501 7206 477 205 6524 Sweden
2787 2787       Suriname 4/6/20 23:21 3.9193 -56.0278 10 1 0 9 Suriname
2786 2786       Sudan 4/6/20 23:21 12.8628 30.2176 12 2 2 8 Sudan
2785 2785       Sri Lanka 4/6/20 23:21 7.873054 80.771797 178 5 38 135 Sri Lanka
2784 2784       Spain 4/6/20 23:21 40.463667 -3.74922 136675 13341 40437 82897 Spain
2783 2783       South Sudan 4/6/20 23:21 6.877 31.307 1 0 0 1 South Sudan
2782 2782       South Africa 4/6/20 23:21 -30.5595 22.9375 1686 12 95 1579 South Africa
2781 2781       Somalia 4/6/20 23:21 5.152149 46.199616 7 0 1 6 Somalia
2780 2780       Slovenia 4/6/20 23:21 46.1512 14.9955 1021 30 102 889 Slovenia
2779 2779       Slovakia 4/6/20 23:21 48.669 19.699 534 2 8 524 Slovakia
2778 2778       Singapore 4/6/20 23:21 1.2833 103.8333 1375 6 344 1025 Singapore
2777 2777       Sierra Leone 4/6/20 23:21 8.460555 -11.779889 6 0 0 6 Sierra Leone
2776 2776       Seychelles 4/6/20 23:21 -4.6796 55.492 11 0 0 11 Seychelles
2775 2775       Serbia 4/6/20 23:21 44.0165 21.0059 2200 58 0 2142 Serbia
2774 2774       Senegal 4/6/20 23:21 14.4974 -14.4524 226 2 92 132 Senegal
2773 2773       Saudi Arabia 4/6/20 23:21 23.885942 45.079162 2605 38 551 2016 Saudi Arabia
2772 2772       Sao Tome and Principe 4/6/20 23:21 0.18636 6.613081 4 0 0 4 Sao Tome and Principe
2771 2771       San Marino 4/6/20 23:21 43.9424 12.4578 266 32 35 199 San Marino
2770 2770       Samoa 4/6/20 23:28 -13.759 -172.1046 0 0 0 0 Samoa
2769 2769       Saint Vincent and the Grenadines 4/6/20 23:21 12.9843 -61.2872 7 0 1 6 Saint Vincent and the Grenadines
2768 2768       Saint Lucia 4/6/20 23:21 13.9094 -60.9789 14 0 1 13 Saint Lucia
2767 2767       Saint Kitts and Nevis 4/6/20 23:21 17.357822 -62.782998 10 0 0 10 Saint Kitts and Nevis
2766 2766       Rwanda 4/6/20 23:21 -1.9403 29.8739 105 0 4 101 Rwanda
2765 2765       Russia 4/6/20 23:21 61.52401 105.318756 6343 47 406 5890 Russia
2764 2764       Romania 4/6/20 23:21 45.9432 24.9668 4057 176 406 3475 Romania
2763 2763       Qatar 4/6/20 23:21 25.3548 51.1839 1832 4 131 1697 Qatar
2762 2762       Portugal 4/6/20 23:21 39.3999 -8.2245 11730 311 140 11279 Portugal
2761 2761       Poland 4/6/20 23:21 51.9194 19.1451 4413 107 162 4144 Poland
2760 2760       Philippines 4/6/20 23:21 12.879721 121.774017 3660 163 73 3424 Philippines
2759 2759       Peru 4/6/20 23:21 -9.19 -75.0152 2561 92 997 1472 Peru
2758 2758       Paraguay 4/6/20 23:21 -23.4425 -58.4438 113 5 12 96 Paraguay
2757 2757       Papua New Guinea 4/6/20 23:21 -6.314993 143.95555 2 0 0 2 Papua New Guinea
2756 2756       Panama 4/6/20 23:21 8.538 -80.7821 1988 54 13 1921 Panama
2755 2755       Pakistan 4/6/20 23:21 30.3753 69.3451 3766 53 259 3454 Pakistan
2754 2754       Oman 4/6/20 23:21 21.512583 55.923255 331 2 61 268 Oman
2753 2753       Norway 4/6/20 23:21 60.472 8.4689 5865 76 32 5757 Norway
2752 2752       North Macedonia 4/6/20 23:21 41.6086 21.7453 570 23 30 517 North Macedonia
2751 2751       Nigeria 4/6/20 23:21 9.082 8.6753 238 5 35 198 Nigeria
2750 2750       Niger 4/6/20 23:21 17.607789 8.081666 253 10 26 217 Niger
2749 2749       Nicaragua 4/6/20 23:21 12.865416 -85.207229 6 1 0 5 Nicaragua
2748 2748       New Zealand 4/6/20 23:21 -40.9006 174.886 1106 1 176 929 New Zealand
2747 2747       Netherlands 4/6/20 23:21 52.1326 5.2913 18803 1867 250 16686 Netherlands
2746 2746       Nepal 4/6/20 23:21 28.1667 84.25 9 0 1 8 Nepal
2745 2745       Namibia 4/6/20 23:21 -22.9576 18.4904 16 0 3 13 Namibia
2744 2744       Mozambique 4/6/20 23:21 -18.665695 35.529562 10 0 1 9 Mozambique
2743 2743       Morocco 4/6/20 23:21 31.7917 -7.0926 1120 80 81 959 Morocco
2742 2742       Montenegro 4/6/20 23:21 42.708678 19.37439 233 2 1 230 Montenegro
2741 2741       Mongolia 4/6/20 23:21 46.8625 103.8467 15 0 2 13 Mongolia
2740 2740       Monaco 4/6/20 23:21 43.7333 7.4167 77 1 4 72 Monaco
2739 2739       Moldova 4/6/20 23:21 47.4116 28.3699 965 19 37 909 Moldova
2738 2738       Mexico 4/6/20 23:21 23.6345 -102.5528 2143 94 633 1416 Mexico
2737 2737       Mauritius 4/6/20 23:21 -20.348404 57.552152 244 7 7 230 Mauritius
2736 2736       Mauritania 4/6/20 23:21 21.0079 -10.9408 6 1 2 3 ,,Mauritania
2735 2735       Malta 4/6/20 23:21 35.9375 14.3754 241 0 5 236 Malta
2734 2734       Mali 4/6/20 23:21 17.570692 -3.996166 47 5 9 33 Mali
2733 2733       Maldives 4/6/20 23:21 3.2028 73.2207 19 0 13 6 Maldives
2732 2732       Malaysia 4/6/20 23:21 4.210484 101.975766 3793 62 1241 2490 Malaysia
2731 2731       Malawi 4/6/20 23:21 -13.254308 34.301525 5 0 0 5 Malawi
2730 2730       Madagascar 4/6/20 23:21 -18.766947 46.869107 82 0 2 80 Madagascar
2729 2729       MS Zaandam 4/6/20 23:21     9 2 0 7 ,,MS Zaandam
2728 2728       Luxembourg 4/6/20 23:21 49.8153 6.1296 2843 41 500 2302 Luxembourg
2727 2727       Lithuania 4/6/20 23:21 55.1694 23.8813 750 10 0 820 Lithuania
2726 2726       Liechtenstein 4/6/20 23:21 47.14 9.55 77 1 55 21 Liechtenstein
2725 2725       Libya 4/6/20 23:21 26.3351 17.228331 19 1 1 17 Libya
2724 2724       Liberia 4/6/20 23:21 6.428055 -9.429499 14 3 3 8 Liberia
2723 2723       Lebanon 4/6/20 23:21 33.8547 35.8623 541 19 60 462 Lebanon
2722 2722       Latvia 4/6/20 23:21 56.8796 24.6032 542 1 16 525 Latvia
2721 2721       Laos 4/6/20 23:21 19.85627 102.495496 12 0 0 12 Laos
2720 2720       Kyrgyzstan 4/6/20 23:21 41.20438 74.766098 216 4 33 179 Kyrgyzstan
2719 2719       Kuwait 4/6/20 23:21 29.31166 47.481766 665 1 103 561 Kuwait
2718 2718       Kosovo 4/6/20 23:21 42.602636 20.902977 145 1 23 121 Kosovo
2717 2717       Korea, South 4/6/20 23:21 35.907757 127.766922 10284 186 6598 3500 Korea, South
2716 2716       Kenya 4/6/20 23:21 -0.0236 37.9062 158 6 4 148 Kenya
2715 2715       Kazakhstan 4/6/20 23:21 48.0196 66.9237 662 6 46 610 Kazakhstan
2714 2714       Jordan 4/6/20 23:21 31.24 36.51 349 6 126 217 Jordan
2713 2713       Japan 4/6/20 23:21 36.204824 138.252924 3654 85 575 2994 Japan
2712 2712       Jamaica 4/6/20 23:21 18.1096 -77.2975 58 3 8 47 Jamaica
2711 2711       Italy 4/6/20 23:21 41.87194 12.56738 132547 16523 22837 93187 Italy

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

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