04-08-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,884 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
2884 2884       Zimbabwe 2020-04-08 22:51:39 -19.015438 29.154857 11 3 0 8 Zimbabwe
2883 2883       Zambia 2020-04-08 22:51:39 -13.133897 27.849332 39 1 7 31 Zambia
2882 2882       West Bank and Gaza 2020-04-08 22:51:39 31.9522 35.2332 263 1 44 218 West Bank and Gaza
2881 2881       Vietnam 2020-04-08 22:51:39 14.058323999999999 108.277199 251 0 126 125 Vietnam
2880 2880       Venezuela 2020-04-08 22:51:39 6.4238 -66.5897 167 9 65 93 Venezuela
2879 2879       Uzbekistan 2020-04-08 22:51:39 41.377491 64.585262 545 3 30 512 Uzbekistan
2878 2878       Uruguay 2020-04-08 22:51:39 -32.5228 -55.7658 424 7 150 267 Uruguay
2877 2877       United Kingdom 2020-04-08 22:51:39 55.3781 -3.4360000000000004 60733 7097 135 53501 United Kingdom
2876 2876       United Arab Emirates 2020-04-08 22:51:39 23.424076 53.847818000000004 2659 12 239 2408 United Arab Emirates
2875 2875       Ukraine 2020-04-08 22:51:39 48.3794 31.1656 1668 52 35 1581 Ukraine
2874 2874       Uganda 2020-04-08 22:51:39 1.373333 32.290275 53 0 0 53 Uganda
2873 2873       Turkey 2020-04-08 22:51:39 38.9637 35.2433 38226 812 1846 35568 Turkey
2872 2872       Tunisia 2020-04-08 22:51:39 33.886917 9.537499 628 24 25 579 Tunisia
2871 2871       Trinidad and Tobago 2020-04-08 22:51:39 10.6918 -61.2225 107 8 1 98 Trinidad and Tobago
2870 2870       Togo 2020-04-08 22:51:39 8.6195 0.8248 70 3 23 44 Togo
2869 2869       Timor-Leste 2020-04-08 22:51:39 -8.874217 125.727539 1 0 0 1 Timor-Leste
2868 2868       Thailand 2020-04-08 22:51:39 15.870032 100.992541 2369 30 888 1451 Thailand
2867 2867       Tanzania 2020-04-08 22:51:39 -6.369028 34.888822 25 1 5 19 Tanzania
2866 2866       Taiwan* 2020-04-08 07:57:59 23.7 121.0 379 5 61 313 Taiwan*
2865 2865       Syria 2020-04-08 22:51:39 34.802075 38.99681500000001 19 2 4 13 Syria
2864 2864       Switzerland 2020-04-08 22:51:39 46.8182 8.2275 23280 895 9800 12585 Switzerland
2863 2863       Sweden 2020-04-08 22:51:39 60.128161 18.643501 8419 687 205 7527 Sweden
2862 2862       Suriname 2020-04-08 22:51:39 3.9193 -56.0278 10 1 3 6 Suriname
2861 2861       Sudan 2020-04-08 22:51:39 12.8628 30.2176 14 2 2 10 Sudan
2860 2860       Sri Lanka 2020-04-08 22:51:39 7.873054 80.77179699999998 189 7 44 138 Sri Lanka
2859 2859       Spain 2020-04-08 22:51:39 40.463667 -3.7492199999999998 148220 14792 48021 85407 Spain
2858 2858       South Sudan 2020-04-08 22:51:39 6.8770000000000024 31.307 2 0 0 2 South Sudan
2857 2857       South Africa 2020-04-08 22:51:39 -30.5595 22.9375 1845 18 95 1732 South Africa
2856 2856       Somalia 2020-04-08 22:51:39 5.152149 46.199616 12 1 1 10 Somalia
2855 2855       Slovenia 2020-04-08 22:51:39 46.1512 14.9955 1091 40 120 931 Slovenia
2854 2854       Slovakia 2020-04-08 22:51:39 48.669 19.699 682 2 16 664 Slovakia
2853 2853       Singapore 2020-04-08 22:51:39 1.2833 103.8333 1623 6 406 1211 Singapore
2852 2852       Sierra Leone 2020-04-08 22:51:39 8.460555000000001 -11.779889 7 0 0 7 Sierra Leone
2851 2851       Seychelles 2020-04-08 22:51:39 -4.6796 55.492 11 0 0 11 Seychelles
2850 2850       Serbia 2020-04-08 22:51:39 44.0165 21.0059 2666 65 0 2601 Serbia
2849 2849       Senegal 2020-04-08 22:51:39 14.4974 -14.4524 244 2 113 129 Senegal
2848 2848       Saudi Arabia 2020-04-08 22:51:39 23.885942 45.079162 2932 41 631 2260 Saudi Arabia
2847 2847       Sao Tome and Principe 2020-04-08 22:51:39 0.18636 6.613081 4 0 0 4 Sao Tome and Principe
2846 2846       San Marino 2020-04-08 22:51:39 43.9424 12.4578 279 34 40 205 San Marino
2845 2845       Samoa 2020-04-08 22:58:44 -13.759 -172.1046 0 0 0 0 Samoa
2844 2844       Saint Vincent and the Grenadines 2020-04-08 22:51:39 12.9843 -61.2872 8 0 1 7 Saint Vincent and the Grenadines
2843 2843       Saint Lucia 2020-04-08 22:51:39 13.9094 -60.9789 14 0 1 13 Saint Lucia
2842 2842       Saint Kitts and Nevis 2020-04-08 22:51:39 17.357822 -62.782998 11 0 0 11 Saint Kitts and Nevis
2841 2841       Rwanda 2020-04-08 22:51:39 -1.9403 29.8739 110 0 7 103 Rwanda
2840 2840       Russia 2020-04-08 22:51:39 61.52401 105.31875600000001 8672 63 580 8029 Russia
2839 2839       Romania 2020-04-08 22:51:39 45.9432 24.9668 4761 220 528 4013 Romania
2838 2838       Qatar 2020-04-08 22:51:39 25.3548 51.1839 2210 6 178 2026 Qatar
2837 2837       Portugal 2020-04-08 22:51:39 39.3999 -8.2245 13141 380 196 12565 Portugal
2836 2836       Poland 2020-04-08 22:51:39 51.9194 19.1451 5205 159 222 4824 Poland
2835 2835       Philippines 2020-04-08 22:51:39 12.879721 121.77401699999999 3870 182 96 3592 Philippines
2834 2834       Peru 2020-04-08 22:51:39 -9.19 -75.0152 4342 121 1333 2888 Peru
2833 2833       Paraguay 2020-04-08 22:51:39 -23.4425 -58.4438 119 5 15 99 Paraguay
2832 2832       Papua New Guinea 2020-04-08 22:51:39 -6.314993 143.95555 2 0 0 2 Papua New Guinea
2831 2831       Panama 2020-04-08 22:51:39 8.538 -80.7821 2249 59 16 2174 Panama
2830 2830       Pakistan 2020-04-08 22:51:39 30.3753 69.3451 4263 61 467 3735 Pakistan
2829 2829       Oman 2020-04-08 22:51:39 21.512583 55.92325500000001 419 2 72 345 Oman
2828 2828       Norway 2020-04-08 22:51:39 60.472 8.4689 6086 101 32 5953 Norway
2827 2827       North Macedonia 2020-04-08 22:51:39 41.6086 21.7453 617 29 35 553 North Macedonia
2826 2826       Nigeria 2020-04-08 22:51:39 9.082 8.6753 276 6 44 226 Nigeria
2825 2825       Niger 2020-04-08 22:51:39 17.607789 8.081666 342 11 28 303 Niger
2824 2824       Nicaragua 2020-04-08 22:51:39 12.865416 -85.207229 6 1 0 5 Nicaragua
2823 2823       New Zealand 2020-04-08 22:51:39 -40.9006 174.886 1210 1 282 927 New Zealand
2822 2822       Netherlands 2020-04-08 22:51:39 52.1326 5.2913 20549 2248 250 18051 Netherlands
2821 2821       Nepal 2020-04-08 22:51:39 28.1667 84.25 9 0 1 8 Nepal
2820 2820       Namibia 2020-04-08 22:51:39 -22.9576 18.4904 16 0 3 13 Namibia
2819 2819       Mozambique 2020-04-08 22:51:39 -18.665695 35.529562 17 0 1 16 Mozambique
2818 2818       Morocco 2020-04-08 22:51:39 31.7917 -7.0926 1275 93 97 1085 Morocco
2817 2817       Montenegro 2020-04-08 22:51:39 42.708678000000006 19.37439 248 2 4 242 Montenegro
2816 2816       Mongolia 2020-04-08 22:51:39 46.8625 103.8467 16 0 4 12 Mongolia
2815 2815       Monaco 2020-04-08 22:51:39 43.7333 7.4167 81 1 4 76 Monaco
2814 2814       Moldova 2020-04-08 22:51:39 47.4116 28.3699 1174 27 40 1107 Moldova
2813 2813       Mexico 2020-04-08 22:51:39 23.6345 -102.5528 2785 141 633 2011 Mexico
2812 2812       Mauritius 2020-04-08 22:51:39 -20.348404000000002 57.552152 273 7 19 247 Mauritius
2811 2811       Mauritania 2020-04-08 22:51:39 21.0079 -10.9408 6 1 2 3 ,,Mauritania
2810 2810       Malta 2020-04-08 22:51:39 35.9375 14.3754 299 1 16 282 Malta
2809 2809       Mali 2020-04-08 22:51:39 17.570692 -3.996166000000001 59 7 16 36 Mali
2808 2808       Maldives 2020-04-08 22:51:39 3.2028 73.2207 19 0 13 6 Maldives
2807 2807       Malaysia 2020-04-08 22:51:39 4.210483999999999 101.97576600000001 4119 65 1487 2567 Malaysia
2806 2806       Malawi 2020-04-08 22:51:39 -13.254307999999998 34.301525 8 1 0 7 Malawi
2805 2805       Madagascar 2020-04-08 22:51:39 -18.766947000000002 46.869107 93 0 11 82 Madagascar
2804 2804       MS Zaandam 2020-04-08 22:51:39     9 2 0 7 ,,MS Zaandam
2803 2803       Luxembourg 2020-04-08 22:51:39 49.8153 6.1296 3034 46 500 2488 Luxembourg
2802 2802       Lithuania 2020-04-08 22:51:39 55.1694 23.8813 821 11 1 889 Lithuania
2801 2801       Liechtenstein 2020-04-08 22:51:39 47.14 9.55 78 1 55 22 Liechtenstein
2800 2800       Libya 2020-04-08 22:51:39 26.3351 17.228331 21 1 8 12 Libya
2799 2799       Liberia 2020-04-08 22:51:39 6.4280550000000005 -9.429499 31 4 3 24 Liberia
2798 2798       Lebanon 2020-04-08 22:51:39 33.8547 35.8623 576 19 62 495 Lebanon
2797 2797       Latvia 2020-04-08 22:51:39 56.8796 24.6032 577 2 16 559 Latvia
2796 2796       Laos 2020-04-08 22:51:39 19.856270000000002 102.495496 15 0 0 15 Laos
2795 2795       Kyrgyzstan 2020-04-08 22:51:39 41.20438 74.766098 270 4 33 233 Kyrgyzstan
2794 2794       Kuwait 2020-04-08 22:51:39 29.311659999999996 47.481766 855 1 111 743 Kuwait
2793 2793       Kosovo 2020-04-08 22:51:39 42.602636 20.902977 184 5 30 149 Kosovo
2792 2792       Korea, South 2020-04-08 22:51:39 35.90775700000001 127.766922 10384 200 6776 3408 Korea, South
2791 2791       Kenya 2020-04-08 22:51:39 -0.0236 37.9062 179 6 9 164 Kenya
2790 2790       Kazakhstan 2020-04-08 22:51:39 48.0196 66.9237 727 7 54 666 Kazakhstan
2789 2789       Jordan 2020-04-08 22:51:39 31.24 36.51 358 6 150 202 Jordan
2788 2788       Japan 2020-04-08 22:51:39 36.204824 138.252924 4257 93 622 3542 Japan
2787 2787       Jamaica 2020-04-08 22:51:39 18.1096 -77.2975 63 4 10 49 Jamaica
2786 2786       Italy 2020-04-08 22:51:39 41.87194 12.56738 139422 17669 26491 95262 Italy
2785 2785       Israel 2020-04-08 22:51:39 31.046051000000002 34.851612 9906 80 1191 8530 Israel

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

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