04-26-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,142 rows sorted by Recovered 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
3108 3108       Spain 2020-04-27 02:30:33 40.463667 -3.7492199999999998 226629 23190 117727 85712 Spain
3016 3016       Germany 2020-04-27 02:30:33 51.165690999999995 10.451526 157770 5976 112000 39794 Germany
2934 2934     Recovered US 2020-04-27 02:30:52     0 0 106988 -106988 Recovered, US
3031 3031       Iran 2020-04-27 02:30:33 32.427908 53.68804599999999 90481 5710 69657 15114 Iran
3035 3035       Italy 2020-04-27 02:30:33 41.87194 12.56738 197675 26644 64928 106103 Italy
2909 2909     Hubei China 2020-04-27 01:18:19 30.9756 112.2707 68128 4512 63616 0 Hubei, China
3012 3012       France 2020-04-27 02:30:33 46.2276 2.2137 160907 22827 44903 93088 France
2976 2976       Brazil 2020-04-27 02:30:33 -14.235 -51.9253 63100 4286 30152 28662 Brazil
3122 3122       Turkey 2020-04-27 02:30:33 38.9637 35.2433 110130 2805 29140 78185 Turkey
3113 3113       Switzerland 2020-04-27 02:30:33 46.8182 8.2275 29061 1610 21800 5651 Switzerland
2933 2933     Recovered Canada 2020-04-27 02:30:55     0 0 16883 -16883 Recovered, Canada
2962 2962       Austria 2020-04-27 02:30:33 47.5162 14.5501 15225 542 12282 2401 Austria
2969 2969       Belgium 2020-04-27 02:30:33 50.8333 4.469936 46134 7094 10785 28255 Belgium
3033 3033       Ireland 2020-04-27 02:30:33 53.1424 -7.6921 19262 1087 9233 8942 Ireland
3041 3041       Korea, South 2020-04-27 02:30:33 35.90775700000001 127.766922 10738 243 8764 1731 Korea, South
3062 3062       Mexico 2020-04-27 02:30:33 23.6345 -102.5528 14677 1351 8354 4972 Mexico
3083 3083       Peru 2020-04-27 02:30:33 -9.19 -75.0152 27517 728 8088 18701 Peru
3034 3034       Israel 2020-04-27 02:30:33 31.046051000000002 34.851612 15385 204 7087 8511 Israel
2987 2987       Chile 2020-04-27 02:30:33 -35.6751 -71.543 13331 189 7024 6118 Chile
3089 3089       Russia 2020-04-27 02:30:33 61.52401 105.31875600000001 80949 747 6767 73435 Russia
3029 3029       India 2020-04-27 02:30:33 20.593684 78.96288 27890 881 6523 20486 India
2997 2997       Denmark 2020-04-27 02:30:33 56.2639 9.5018 8575 422 5805 2348 Denmark
3056 3056       Malaysia 2020-04-27 02:30:33 4.210483999999999 101.97576600000001 5780 98 3862 1820 Malaysia
3052 3052       Luxembourg 2020-04-27 02:30:33 49.8153 6.1296 3723 88 3104 531 Luxembourg
3088 3088       Romania 2020-04-27 02:30:33 45.9432 24.9668 11036 619 3054 7363 Romania
3079 3079       Pakistan 2020-04-27 02:30:33 30.3753 69.3451 13328 281 2936 10111 Pakistan
3117 3117       Thailand 2020-04-27 02:30:33 15.870032 100.992541 2922 51 2594 277 Thailand
2996 2996       Czechia 2020-04-27 02:30:33 49.8175 15.472999999999999 7404 220 2545 4639 Czechia
3011 3011       Finland 2020-04-27 02:30:33 61.92411 25.748151 4576 190 2500 1886 Finland
3097 3097       Saudi Arabia 2020-04-27 02:30:33 23.885942 45.079162 17522 139 2357 15026 Saudi Arabia
3085 3085       Poland 2020-04-27 02:30:33 51.9194 19.1451 11617 535 2265 8817 Poland
3136 3136     New South Wales Australia 2020-04-27 02:31:20 -33.8688 151.2093 3002 34 2208 760 New South Wales, Australia
3125 3125       United Arab Emirates 2020-04-27 02:30:33 23.424076 53.847818000000004 10349 76 1978 8295 United Arab Emirates
3037 3037       Japan 2020-04-27 02:30:33 36.204824 138.252924 13441 372 1809 11260 Japan
2968 2968       Belarus 2020-04-27 02:30:33 53.7098 27.9534 10463 72 1695 8696 Belarus
3028 3028       Iceland 2020-04-27 02:30:33 64.9631 -19.0208 1792 10 1608 174 Iceland
2901 2901     Guangdong China 2020-04-27 01:21:22 23.3417 113.4244 1587 8 1542 37 Guangdong, China
2956 2956       Algeria 2020-04-27 02:30:33 28.0339 1.6596 3382 425 1508 1449 Algeria
3106 3106       South Africa 2020-04-27 02:30:33 -30.5595 22.9375 4546 87 1473 2986 South Africa
3002 3002       Ecuador 2020-04-27 02:30:33 -1.8312 -78.1834 22719 576 1366 20777 Ecuador
3086 3086       Portugal 2020-04-27 02:30:33 39.3999 -8.2245 23864 903 1329 21632 Portugal
3141 3141     Victoria Australia 2020-04-27 02:31:20 -37.8136 144.9631 1349 17 1265 67 Victoria, Australia
3032 3032       Iraq 2020-04-27 02:30:33 33.223191 43.679291 1820 87 1263 470 Iraq
2953 2953     Zhejiang China 2020-04-27 01:17:18 29.1832 120.0934 1268 1 1258 9 Zhejiang, China
2907 2907     Henan China 2020-04-14 00:43:57 33.882 113.61399999999999 1276 22 1254 0 Henan, China
2965 2965       Bahrain 2020-04-27 02:30:33 26.0275 50.55 2647 8 1189 1450 Bahrain
3072 3072       New Zealand 2020-04-27 02:30:33 -40.9006 174.886 1469 19 1180 270 New Zealand
3003 3003       Egypt 2020-04-27 02:30:33 26.820553000000004 30.802497999999996 4534 317 1176 3041 Egypt
2963 2963       Azerbaijan 2020-04-27 02:30:33 40.1431 47.5769 1645 21 1139 485 Azerbaijan
2988 2988       Colombia 2020-04-27 02:30:33 4.5709 -74.2973 5379 244 1133 4002 Colombia
2960 2960       Argentina 2020-04-27 02:30:33 -38.4161 -63.6167 3892 192 1107 2593 Argentina
3030 3030       Indonesia 2020-04-27 02:30:33 -0.7893 113.9213 8882 743 1107 7032 Indonesia
2993 2993       Croatia 2020-04-27 02:30:33 45.1 15.2 2030 55 1103 872 Croatia
3102 3102       Singapore 2020-04-27 02:30:33 1.2833 103.8333 13624 12 1060 12552 Singapore
2910 2910     Hunan China 2020-04-18 01:15:10 27.6104 111.7088 1019 4 1015 0 Hunan, China
3087 3087       Qatar 2020-04-27 02:30:33 25.3548 51.1839 10287 10 1012 9265 Qatar
3112 3112       Sweden 2020-04-27 02:30:33 60.128161 18.643501 18640 2194 1005 15441 Sweden
2877 2877     Anhui China 2020-04-24 12:04:47 31.8257 117.2264 991 6 985 0 Anhui, China
2914 2914     Jiangxi China 2020-04-10 01:22:42 27.614 115.7221 937 1 936 0 Jiangxi, China
3138 3138     Queensland Australia 2020-04-27 02:31:20 -27.4698 153.0251 1030 6 926 98 Queensland, Australia
3001 3001       Dominican Republic 2020-04-27 02:30:33 18.7357 -70.1627 6135 278 910 4947 Dominican Republic
3063 3063       Moldova 2020-04-27 02:30:33 47.4116 28.3699 3408 96 895 2417 Moldova
3099 3099       Serbia 2020-04-27 02:30:33 44.0165 21.0059 6630 125 870 5635 Serbia
3084 3084       Philippines 2020-04-27 02:30:33 12.879721 121.77401699999999 7579 501 862 6216 Philippines
3124 3124       Ukraine 2020-04-27 02:30:33 48.3794 31.1656 8617 209 840 7568 Ukraine
2961 2961       Armenia 2020-04-27 02:30:33 40.0691 45.0382 1746 28 833 885 Armenia
3043 3043       Kuwait 2020-04-27 02:30:33 29.311659999999996 47.481766 3075 20 806 2249 Kuwait
3128 3128       Uzbekistan 2020-04-27 02:30:33 41.377491 64.585262 1869 8 789 1072 Uzbekistan
2984 2984       Cameroon 2020-04-27 02:30:33 3.8480000000000003 11.5021 1621 56 786 779 Cameroon
2908 2908     Hong Kong China 2020-04-27 00:51:44 22.3 114.2 1037 4 772 261 Hong Kong, China
2940 2940     Shandong China 2020-04-27 00:47:41 36.3427 118.1498 787 7 768 12 Shandong, China
3039 3039       Kazakhstan 2020-04-27 02:30:33 48.0196 66.9237 2717 25 682 2010 Kazakhstan
2913 2913     Jiangsu China 2020-04-24 01:27:14 32.9711 119.455 653 0 646 7 Jiangsu, China
2998 2998       Diamond Princess 2020-04-27 02:30:33     712 13 645 54 Diamond Princess
2974 2974       Bosnia and Herzegovina 2020-04-27 02:30:33 43.9159 17.6791 1516 59 624 833 Bosnia and Herzegovina
3067 3067       Morocco 2020-04-27 02:30:33 31.7917 -7.0926 4065 161 593 3311 Morocco
3018 3018       Greece 2020-04-27 02:30:33 39.0742 21.8243 2517 134 577 1806 Greece
2886 2886     Chongqing China 2020-04-24 00:43:27 30.0572 107.874 579 6 573 0 Chongqing, China
2941 2941     Shanghai China 2020-04-26 06:29:18 31.201999999999998 121.4491 642 7 568 67 Shanghai, China
2943 2943     Sichuan China 2020-04-24 01:27:14 30.6171 102.7103 561 3 558 0 Sichuan, China
2906 2906     Heilongjiang China 2020-04-27 00:29:26 47.861999999999995 127.7615 936 13 556 367 Heilongjiang, China
2879 2879     Beijing China 2020-04-27 01:12:14 40.1824 116.4142 593 9 525 59 Beijing, China
2994 2994       Cuba 2020-04-27 02:30:33 21.521757 -77.78116700000002 1369 54 501 814 Cuba
3076 3076       North Macedonia 2020-04-27 02:30:33 41.6086 21.7453 1386 61 500 825 North Macedonia
3142 3142     Western Australia Australia 2020-04-27 02:31:20 -31.9505 115.8605 549 8 486 55 Western Australia, Australia
3027 3027       Hungary 2020-04-27 02:30:33 47.1625 19.5033 2500 272 485 1743 Hungary
2992 2992       Cote d'Ivoire 2020-04-27 02:30:33 7.54 -5.5471 1150 14 468 668 Cote d'Ivoire
2979 2979       Burkina Faso 2020-04-27 02:30:33 12.2383 -1.5616 632 42 453 137 Burkina Faso
2999 2999       Djibouti 2020-04-27 02:30:33 11.8251 42.5903 1023 2 411 610 Djibouti
3139 3139     South Australia Australia 2020-04-27 02:31:20 -34.9285 138.6007 438 4 411 23 South Australia, Australia
2955 2955       Albania 2020-04-27 02:30:33 41.1533 20.1683 726 28 410 288 Albania
3103 3103       Slovakia 2020-04-27 02:30:33 48.669 19.699 1379 18 394 967 Slovakia
3127 3127       Uruguay 2020-04-27 02:30:33 -32.5228 -55.7658 606 15 375 216 Uruguay
3044 3044       Kyrgyzstan 2020-04-27 02:30:33 41.20438 74.766098 682 8 370 304 Kyrgyzstan
3051 3051       Lithuania 2020-04-27 02:30:33 55.1694 23.8813 1316 31 365 930 Lithuania
3074 3074       Niger 2020-04-27 02:30:33 17.607789 8.081666 696 29 350 317 Niger
2894 2894     Fujian China 2020-04-25 01:01:53 26.0789 117.9874 355 1 349 5 Fujian, China
2957 2957       Andorra 2020-04-27 02:30:33 42.5063 1.5218 738 40 344 354 Andorra
3080 3080       Panama 2020-04-27 02:30:33 8.538 -80.7821 5779 165 338 5276 Panama
3038 3038       Jordan 2020-04-27 02:30:33 31.24 36.51 447 7 337 103 Jordan

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

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