04-07-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,858 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
2858 2858       Zimbabwe 2020-04-07 23:04:29 -19.015438 29.154857 11 2 0 9 Zimbabwe
2857 2857       Zambia 2020-04-07 23:04:29 -13.133897 27.849332 39 1 7 31 Zambia
2856 2856       West Bank and Gaza 2020-04-07 23:04:29 31.9522 35.2332 261 1 42 218 West Bank and Gaza
2855 2855       Vietnam 2020-04-07 23:04:29 14.058323999999999 108.277199 249 0 123 126 Vietnam
2854 2854       Venezuela 2020-04-07 23:04:29 6.4238 -66.5897 165 7 65 93 Venezuela
2853 2853       Uzbekistan 2020-04-07 23:04:29 41.377491 64.585262 520 2 30 488 Uzbekistan
2852 2852       Uruguay 2020-04-07 23:04:29 -32.5228 -55.7658 424 7 150 267 Uruguay
2851 2851       United Kingdom 2020-04-07 23:04:29 55.3781 -3.4360000000000004 55242 6159 135 48948 United Kingdom
2850 2850       United Arab Emirates 2020-04-07 23:04:29 23.424076 53.847818000000004 2359 12 186 2161 United Arab Emirates
2849 2849       Ukraine 2020-04-07 23:04:29 48.3794 31.1656 1462 45 28 1389 Ukraine
2848 2848       Uganda 2020-04-07 23:04:29 1.373333 32.290275 52 0 0 52 Uganda
2847 2847       Turkey 2020-04-07 23:04:29 38.9637 35.2433 34109 725 1582 31802 Turkey
2846 2846       Tunisia 2020-04-07 23:04:29 33.886917 9.537499 623 23 25 575 Tunisia
2845 2845       Trinidad and Tobago 2020-04-07 23:04:29 10.6918 -61.2225 107 8 1 98 Trinidad and Tobago
2844 2844       Togo 2020-04-07 23:04:29 8.6195 0.8248 65 3 23 39 Togo
2843 2843       Timor-Leste 2020-04-07 23:04:29 -8.874217 125.727539 1 0 0 1 Timor-Leste
2842 2842       Thailand 2020-04-07 23:04:29 15.870032 100.992541 2258 27 824 1343 Thailand
2841 2841       Tanzania 2020-04-07 23:04:29 -6.369028 34.888822 24 1 5 18 Tanzania
2840 2840       Taiwan* 2020-04-07 09:19:20 23.7 121.0 376 5 57 314 Taiwan*
2839 2839       Syria 2020-04-07 23:04:29 34.802075 38.99681500000001 19 2 3 14 Syria
2838 2838       Switzerland 2020-04-07 23:04:29 46.8182 8.2275 22253 821 8704 12728 Switzerland
2837 2837       Sweden 2020-04-07 23:04:29 60.128161 18.643501 7693 591 205 6897 Sweden
2836 2836       Suriname 2020-04-07 23:04:29 3.9193 -56.0278 10 1 0 9 Suriname
2835 2835       Sudan 2020-04-07 23:04:29 12.8628 30.2176 14 2 2 10 Sudan
2834 2834       Sri Lanka 2020-04-07 23:04:29 7.873054 80.77179699999998 185 6 42 137 Sri Lanka
2833 2833       Spain 2020-04-07 23:04:29 40.463667 -3.7492199999999998 141942 14045 43208 84689 Spain
2832 2832       South Sudan 2020-04-07 23:04:29 6.8770000000000024 31.307 2 0 0 2 South Sudan
2831 2831       South Africa 2020-04-07 23:04:29 -30.5595 22.9375 1749 13 95 1641 South Africa
2830 2830       Somalia 2020-04-07 23:04:29 5.152149 46.199616 8 0 1 7 Somalia
2829 2829       Slovenia 2020-04-07 23:04:29 46.1512 14.9955 1059 36 102 921 Slovenia
2828 2828       Slovakia 2020-04-07 23:04:29 48.669 19.699 581 2 13 566 Slovakia
2827 2827       Singapore 2020-04-07 23:04:29 1.2833 103.8333 1481 6 377 1098 Singapore
2826 2826       Sierra Leone 2020-04-07 23:04:29 8.460555000000001 -11.779889 6 0 0 6 Sierra Leone
2825 2825       Seychelles 2020-04-07 23:04:29 -4.6796 55.492 11 0 0 11 Seychelles
2824 2824       Serbia 2020-04-07 23:04:29 44.0165 21.0059 2447 61 0 2386 Serbia
2823 2823       Senegal 2020-04-07 23:04:29 14.4974 -14.4524 237 2 105 130 Senegal
2822 2822       Saudi Arabia 2020-04-07 23:04:29 23.885942 45.079162 2795 41 615 2139 Saudi Arabia
2821 2821       Sao Tome and Principe 2020-04-07 23:04:29 0.18636 6.613081 4 0 0 4 Sao Tome and Principe
2820 2820       San Marino 2020-04-07 23:04:29 43.9424 12.4578 279 34 40 205 San Marino
2819 2819       Samoa 2020-04-07 23:11:15 -13.759 -172.1046 0 0 0 0 Samoa
2818 2818       Saint Vincent and the Grenadines 2020-04-07 23:04:29 12.9843 -61.2872 8 0 1 7 Saint Vincent and the Grenadines
2817 2817       Saint Lucia 2020-04-07 23:04:29 13.9094 -60.9789 14 0 1 13 Saint Lucia
2816 2816       Saint Kitts and Nevis 2020-04-07 23:04:29 17.357822 -62.782998 11 0 0 11 Saint Kitts and Nevis
2815 2815       Rwanda 2020-04-07 23:04:29 -1.9403 29.8739 105 0 7 98 Rwanda
2814 2814       Russia 2020-04-07 23:04:29 61.52401 105.31875600000001 7497 58 494 6945 Russia
2813 2813       Romania 2020-04-07 23:04:29 45.9432 24.9668 4417 197 460 3760 Romania
2812 2812       Qatar 2020-04-07 23:04:29 25.3548 51.1839 2057 6 150 1901 Qatar
2811 2811       Portugal 2020-04-07 23:04:29 39.3999 -8.2245 12442 345 184 11913 Portugal
2810 2810       Poland 2020-04-07 23:04:29 51.9194 19.1451 4848 129 191 4528 Poland
2809 2809       Philippines 2020-04-07 23:04:29 12.879721 121.77401699999999 3764 177 84 3503 Philippines
2808 2808       Peru 2020-04-07 23:04:29 -9.19 -75.0152 2954 107 1301 1546 Peru
2807 2807       Paraguay 2020-04-07 23:04:29 -23.4425 -58.4438 115 5 15 95 Paraguay
2806 2806       Papua New Guinea 2020-04-07 23:04:29 -6.314993 143.95555 2 0 0 2 Papua New Guinea
2805 2805       Panama 2020-04-07 23:04:29 8.538 -80.7821 2100 55 14 2031 Panama
2804 2804       Pakistan 2020-04-07 23:04:29 30.3753 69.3451 4035 57 429 3549 Pakistan
2803 2803       Oman 2020-04-07 23:04:29 21.512583 55.92325500000001 371 2 67 302 Oman
2802 2802       Norway 2020-04-07 23:04:29 60.472 8.4689 6086 89 32 5965 Norway
2801 2801       North Macedonia 2020-04-07 23:04:29 41.6086 21.7453 599 26 30 543 North Macedonia
2800 2800       Nigeria 2020-04-07 23:04:29 9.082 8.6753 254 6 44 204 Nigeria
2799 2799       Niger 2020-04-07 23:04:29 17.607789 8.081666 278 11 26 241 Niger
2798 2798       Nicaragua 2020-04-07 23:04:29 12.865416 -85.207229 6 1 0 5 Nicaragua
2797 2797       New Zealand 2020-04-07 23:04:29 -40.9006 174.886 1160 1 241 918 New Zealand
2796 2796       Netherlands 2020-04-07 23:04:29 52.1326 5.2913 19580 2101 250 17229 Netherlands
2795 2795       Nepal 2020-04-07 23:04:29 28.1667 84.25 9 0 1 8 Nepal
2794 2794       Namibia 2020-04-07 23:04:29 -22.9576 18.4904 16 0 3 13 Namibia
2793 2793       Mozambique 2020-04-07 23:04:29 -18.665695 35.529562 10 0 1 9 Mozambique
2792 2792       Morocco 2020-04-07 23:04:29 31.7917 -7.0926 1184 90 93 1001 Morocco
2791 2791       Montenegro 2020-04-07 23:04:29 42.708678000000006 19.37439 241 2 4 235 Montenegro
2790 2790       Mongolia 2020-04-07 23:04:29 46.8625 103.8467 15 0 4 11 Mongolia
2789 2789       Monaco 2020-04-07 23:04:29 43.7333 7.4167 79 1 4 74 Monaco
2788 2788       Moldova 2020-04-07 23:04:29 47.4116 28.3699 1056 22 40 994 Moldova
2787 2787       Mexico 2020-04-07 23:04:29 23.6345 -102.5528 2439 125 633 1681 Mexico
2786 2786       Mauritius 2020-04-07 23:04:29 -20.348404000000002 57.552152 268 7 8 253 Mauritius
2785 2785       Mauritania 2020-04-07 23:04:29 21.0079 -10.9408 6 1 2 3 ,,Mauritania
2784 2784       Malta 2020-04-07 23:04:29 35.9375 14.3754 293 0 5 288 Malta
2783 2783       Mali 2020-04-07 23:04:29 17.570692 -3.996166000000001 56 5 12 39 Mali
2782 2782       Maldives 2020-04-07 23:04:29 3.2028 73.2207 19 0 13 6 Maldives
2781 2781       Malaysia 2020-04-07 23:04:29 4.210483999999999 101.97576600000001 3963 63 1321 2579 Malaysia
2780 2780       Malawi 2020-04-07 23:04:29 -13.254307999999998 34.301525 8 1 0 7 Malawi
2779 2779       Madagascar 2020-04-07 23:04:29 -18.766947000000002 46.869107 88 0 7 81 Madagascar
2778 2778       MS Zaandam 2020-04-07 23:04:29     9 2 0 7 ,,MS Zaandam
2777 2777       Luxembourg 2020-04-07 23:04:29 49.8153 6.1296 2970 44 500 2426 Luxembourg
2776 2776       Lithuania 2020-04-07 23:04:29 55.1694 23.8813 783 11 0 857 Lithuania
2775 2775       Liechtenstein 2020-04-07 23:04:29 47.14 9.55 78 1 55 22 Liechtenstein
2774 2774       Libya 2020-04-07 23:04:29 26.3351 17.228331 20 1 1 18 Libya
2773 2773       Liberia 2020-04-07 23:04:29 6.4280550000000005 -9.429499 14 3 3 8 Liberia
2772 2772       Lebanon 2020-04-07 23:04:29 33.8547 35.8623 548 19 62 467 Lebanon
2771 2771       Latvia 2020-04-07 23:04:29 56.8796 24.6032 548 2 16 530 Latvia
2770 2770       Laos 2020-04-07 23:04:29 19.856270000000002 102.495496 14 0 0 14 Laos
2769 2769       Kyrgyzstan 2020-04-07 23:04:29 41.20438 74.766098 228 4 33 191 Kyrgyzstan
2768 2768       Kuwait 2020-04-07 23:04:29 29.311659999999996 47.481766 743 1 105 637 Kuwait
2767 2767       Kosovo 2020-04-07 23:04:29 42.602636 20.902977 170 4 24 142 Kosovo
2766 2766       Korea, South 2020-04-07 23:04:29 35.90775700000001 127.766922 10331 192 6694 3445 Korea, South
2765 2765       Kenya 2020-04-07 23:04:29 -0.0236 37.9062 172 6 7 159 Kenya
2764 2764       Kazakhstan 2020-04-07 23:04:29 48.0196 66.9237 697 6 51 640 Kazakhstan
2763 2763       Jordan 2020-04-07 23:04:29 31.24 36.51 353 6 138 209 Jordan
2762 2762       Japan 2020-04-07 23:04:29 36.204824 138.252924 3906 92 592 3222 Japan
2761 2761       Jamaica 2020-04-07 23:04:29 18.1096 -77.2975 63 3 8 52 Jamaica
2760 2760       Italy 2020-04-07 23:04:29 41.87194 12.56738 135586 17127 24392 94067 Italy
2759 2759       Israel 2020-04-07 23:04:29 31.046051000000002 34.851612 9568 72 1059 8413 Israel

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

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