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

3,028 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
3028 3028       Zimbabwe 2020-04-15 22:56:32 -19.015438 29.154857 23 3 1 19 Zimbabwe
3027 3027       Zambia 2020-04-15 22:56:32 -13.133897 27.849332 48 2 30 16 Zambia
3026 3026       Yemen 2020-04-15 22:56:32 15.552726999999999 48.516388 1 0 0 1 Yemen
3025 3025       West Bank and Gaza 2020-04-15 22:56:32 31.9522 35.2332 374 2 63 309 West Bank and Gaza
3024 3024       Vietnam 2020-04-15 22:56:32 14.058323999999999 108.277199 267 0 171 96 Vietnam
3023 3023       Venezuela 2020-04-15 22:56:32 6.4238 -66.5897 197 9 111 77 Venezuela
3022 3022       Uzbekistan 2020-04-15 22:56:32 41.377491 64.585262 1302 4 107 1191 Uzbekistan
3021 3021       Uruguay 2020-04-15 22:56:32 -32.5228 -55.7658 492 8 260 224 Uruguay
3020 3020       United Kingdom 2020-04-15 22:56:32 55.3781 -3.4360000000000004 98476 12868 0 85608 United Kingdom
3019 3019       United Arab Emirates 2020-04-15 22:56:32 23.424076 53.847818000000004 5365 33 1034 4298 United Arab Emirates
3018 3018       Ukraine 2020-04-15 22:56:32 48.3794 31.1656 3764 108 143 3513 Ukraine
3017 3017       Uganda 2020-04-15 22:56:32 1.373333 32.290275 55 0 12 43 Uganda
3016 3016       Turkey 2020-04-15 22:56:32 38.9637 35.2433 69392 1518 5674 62200 Turkey
3015 3015       Tunisia 2020-04-15 22:56:32 33.886917 9.537499 780 35 43 702 Tunisia
3014 3014       Trinidad and Tobago 2020-04-15 22:56:32 10.6918 -61.2225 114 8 19 87 Trinidad and Tobago
3013 3013       Togo 2020-04-15 22:56:32 8.6195 0.8248 81 3 35 43 Togo
3012 3012       Timor-Leste 2020-04-15 22:56:32 -8.874217 125.727539 8 0 1 7 Timor-Leste
3011 3011       Thailand 2020-04-15 22:56:32 15.870032 100.992541 2643 43 1497 1103 Thailand
3010 3010       Tanzania 2020-04-15 22:56:32 -6.369028 34.888822 88 4 11 73 Tanzania
3009 3009       Taiwan* 2020-04-15 14:46:10 23.7 121.0 395 6 124 265 Taiwan*
3008 3008       Syria 2020-04-15 22:56:32 34.802075 38.99681500000001 33 2 5 26 Syria
3007 3007       Switzerland 2020-04-15 22:56:32 46.8182 8.2275 26336 1239 15400 9697 Switzerland
3006 3006       Sweden 2020-04-15 22:56:32 60.128161 18.643501 11927 1203 381 10343 Sweden
3005 3005       Suriname 2020-04-15 22:56:32 3.9193 -56.0278 10 1 6 3 Suriname
3004 3004       Sudan 2020-04-15 22:56:32 12.8628 30.2176 32 5 4 23 Sudan
3003 3003       Sri Lanka 2020-04-15 22:56:32 7.873054 80.77179699999998 238 7 63 168 Sri Lanka
3002 3002       Spain 2020-04-15 22:56:32 40.463667 -3.7492199999999998 177644 18708 70853 88083 Spain
3001 3001       South Sudan 2020-04-15 22:56:32 6.8770000000000024 31.307 4 0 0 4 South Sudan
3000 3000       South Africa 2020-04-15 22:56:32 -30.5595 22.9375 2506 34 410 2062 South Africa
2999 2999       Somalia 2020-04-15 22:56:32 5.152149 46.199616 80 5 2 73 Somalia
2998 2998       Slovenia 2020-04-15 22:56:32 46.1512 14.9955 1248 61 165 1022 Slovenia
2997 2997       Slovakia 2020-04-15 22:56:32 48.669 19.699 863 6 151 706 Slovakia
2996 2996       Singapore 2020-04-15 22:56:32 1.2833 103.8333 3699 10 652 3037 Singapore
2995 2995       Sierra Leone 2020-04-15 22:56:32 8.460555000000001 -11.779889 13 0 0 13 Sierra Leone
2994 2994       Seychelles 2020-04-15 22:56:32 -4.6796 55.492 11 0 0 11 Seychelles
2993 2993       Serbia 2020-04-15 22:56:32 44.0165 21.0059 4873 99 0 4774 Serbia
2992 2992       Senegal 2020-04-15 22:56:32 14.4974 -14.4524 314 2 190 122 Senegal
2991 2991       Saudi Arabia 2020-04-15 22:56:32 23.885942 45.079162 5862 79 931 4852 Saudi Arabia
2990 2990       Sao Tome and Principe 2020-04-15 22:56:32 0.18636 6.613081 4 0 0 4 Sao Tome and Principe
2989 2989       San Marino 2020-04-15 22:56:32 43.9424 12.4578 372 36 53 283 San Marino
2988 2988       Samoa 2020-04-15 23:04:09 -13.759 -172.1046 0 0 0 0 Samoa
2987 2987       Saint Vincent and the Grenadines 2020-04-15 22:56:32 12.9843 -61.2872 12 0 1 11 Saint Vincent and the Grenadines
2986 2986       Saint Lucia 2020-04-15 22:56:32 13.9094 -60.9789 15 0 11 4 Saint Lucia
2985 2985       Saint Kitts and Nevis 2020-04-15 22:56:32 17.357822 -62.782998 14 0 0 14 Saint Kitts and Nevis
2984 2984       Rwanda 2020-04-15 22:56:32 -1.9403 29.8739 136 0 54 82 Rwanda
2983 2983       Russia 2020-04-15 22:56:32 61.52401 105.31875600000001 24490 198 1986 22306 Russia
2982 2982       Romania 2020-04-15 22:56:32 45.9432 24.9668 7216 372 1217 5627 Romania
2981 2981       Qatar 2020-04-15 22:56:32 25.3548 51.1839 3711 7 406 3298 Qatar
2980 2980       Portugal 2020-04-15 22:56:32 39.3999 -8.2245 18091 599 383 17109 Portugal
2979 2979       Poland 2020-04-15 22:56:32 51.9194 19.1451 7582 286 668 6628 Poland
2978 2978       Philippines 2020-04-15 22:56:32 12.879721 121.77401699999999 5453 349 353 4751 Philippines
2977 2977       Peru 2020-04-15 22:56:32 -9.19 -75.0152 11475 254 3108 8113 Peru
2976 2976       Paraguay 2020-04-15 22:56:32 -23.4425 -58.4438 161 8 23 130 Paraguay
2975 2975       Papua New Guinea 2020-04-15 22:56:32 -6.314993 143.95555 2 0 0 2 Papua New Guinea
2974 2974       Panama 2020-04-15 22:56:32 8.538 -80.7821 3574 95 72 3407 Panama
2973 2973       Pakistan 2020-04-15 22:56:32 30.3753 69.3451 6383 111 1446 4826 Pakistan
2972 2972       Oman 2020-04-15 22:56:32 21.512583 55.92325500000001 910 4 131 775 Oman
2971 2971       Norway 2020-04-15 22:56:32 60.472 8.4689 6740 150 32 6558 Norway
2970 2970       North Macedonia 2020-04-15 22:56:32 41.6086 21.7453 974 45 98 831 North Macedonia
2969 2969       Nigeria 2020-04-15 22:56:32 9.082 8.6753 407 12 128 267 Nigeria
2968 2968       Niger 2020-04-15 22:56:32 17.607789 8.081666 584 14 90 480 Niger
2967 2967       Nicaragua 2020-04-15 22:56:32 12.865416 -85.207229 9 1 4 4 Nicaragua
2966 2966       New Zealand 2020-04-15 22:56:32 -40.9006 174.886 1386 9 728 649 New Zealand
2965 2965       Netherlands 2020-04-15 22:56:32 52.1326 5.2913 28153 3134 250 24769 Netherlands
2964 2964       Nepal 2020-04-15 22:56:32 28.1667 84.25 16 0 1 15 Nepal
2963 2963       Namibia 2020-04-15 22:56:32 -22.9576 18.4904 16 0 3 13 Namibia
2962 2962       Mozambique 2020-04-15 22:56:32 -18.665695 35.529562 29 0 2 27 Mozambique
2961 2961       Morocco 2020-04-15 22:56:32 31.7917 -7.0926 2024 127 229 1668 Morocco
2960 2960       Montenegro 2020-04-15 22:56:32 42.708678000000006 19.37439 288 4 55 229 Montenegro
2959 2959       Mongolia 2020-04-15 22:56:32 46.8625 103.8467 30 0 5 25 Mongolia
2958 2958       Monaco 2020-04-15 22:56:32 43.7333 7.4167 93 3 12 78 Monaco
2957 2957       Moldova 2020-04-15 22:56:32 47.4116 28.3699 2049 46 171 1832 Moldova
2956 2956       Mexico 2020-04-15 22:56:32 23.6345 -102.5528 5399 406 2125 2868 Mexico
2955 2955       Mauritius 2020-04-15 22:56:32 -20.348404000000002 57.552152 324 9 65 250 Mauritius
2954 2954       Mauritania 2020-04-15 22:56:32 21.0079 -10.9408 7 1 2 4 Mauritania
2953 2953       Malta 2020-04-15 22:56:32 35.9375 14.3754 399 3 44 352 Malta
2952 2952       Mali 2020-04-15 22:56:32 17.570692 -3.996166000000001 148 13 34 101 Mali
2951 2951       Maldives 2020-04-15 22:56:32 3.2028 73.2207 22 0 16 6 Maldives
2950 2950       Malaysia 2020-04-15 22:56:32 4.210483999999999 101.97576600000001 5072 83 2647 2342 Malaysia
2949 2949       Malawi 2020-04-15 22:56:32 -13.254307999999998 34.301525 16 2 0 14 Malawi
2948 2948       Madagascar 2020-04-15 22:56:32 -18.766947000000002 46.869107 110 0 29 81 Madagascar
2947 2947       MS Zaandam 2020-04-15 22:56:32     9 2 0 7 MS Zaandam
2946 2946       Luxembourg 2020-04-15 22:56:32 49.8153 6.1296 3373 69 526 2778 Luxembourg
2945 2945       Lithuania 2020-04-15 22:56:32 55.1694 23.8813 995 20 9 923 Lithuania
2944 2944       Liechtenstein 2020-04-15 22:56:32 47.14 9.55 79 1 55 23 Liechtenstein
2943 2943       Libya 2020-04-15 22:56:32 26.3351 17.228331 48 1 9 38 Libya
2942 2942       Liberia 2020-04-15 22:56:32 6.4280550000000005 -9.429499 59 6 4 49 Liberia
2941 2941       Lebanon 2020-04-15 22:56:32 33.8547 35.8623 658 21 85 552 Lebanon
2940 2940       Latvia 2020-04-15 22:56:32 56.8796 24.6032 666 5 44 617 Latvia
2939 2939       Laos 2020-04-15 22:56:32 19.856270000000002 102.495496 19 0 1 18 Laos
2938 2938       Kyrgyzstan 2020-04-15 22:56:32 41.20438 74.766098 449 5 78 366 Kyrgyzstan
2937 2937       Kuwait 2020-04-15 22:56:32 29.311659999999996 47.481766 1405 3 206 1196 Kuwait
2936 2936       Kosovo 2020-04-15 22:56:32 42.602636 20.902977 387 8 66 313 Kosovo
2935 2935       Korea, South 2020-04-15 22:56:32 35.90775700000001 127.766922 10591 225 7616 2750 Korea, South
2934 2934       Kenya 2020-04-15 22:56:32 -0.0236 37.9062 225 10 53 162 Kenya
2933 2933       Kazakhstan 2020-04-15 22:56:32 48.0196 66.9237 1295 16 240 1039 Kazakhstan
2932 2932       Jordan 2020-04-15 22:56:32 31.24 36.51 401 7 250 144 Jordan
2931 2931       Japan 2020-04-15 22:56:32 36.204824 138.252924 8100 146 853 7101 Japan
2930 2930       Jamaica 2020-04-15 22:56:32 18.1096 -77.2975 125 5 21 99 Jamaica
2929 2929       Italy 2020-04-15 22:56:32 41.87194 12.56738 165155 21645 38092 105418 Italy

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

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