05-01-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,190 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
2983 2983     Recovered US 2020-05-02 02:32:27     0 0 164015 -135340 Recovered, US
3071 3071       Germany 2020-05-02 02:32:27 51.165690999999995 10.451526 164077 6736 126900 30441 Germany
3163 3163       Spain 2020-05-02 02:32:27 40.463667 -3.74922 213435 24543 112050 76842 Spain
3090 3090       Italy 2020-05-02 02:32:27 41.87194 12.56738 207428 28236 78249 100943 Italy
3086 3086       Iran 2020-05-02 02:32:27 32.427908 53.68804599999999 95646 6091 76318 13237 Iran
2953 2953     Hubei China 2020-05-02 02:32:27 30.9756 112.2707 68128 4512 63616 0 Hubei, China
3178 3178       Turkey 2020-05-02 02:32:27 38.9637 35.2433 122392 3258 53808 65326 Turkey
3067 3067       France 2020-05-02 02:32:27 46.2276 2.2137 167846 24563 50212 90958 France
3030 3030       Brazil 2020-05-02 02:32:27 -14.235 -51.9253 92202 6412 38039 47751 Brazil
3168 3168       Switzerland 2020-05-02 02:32:27 46.8182 8.2275 29705 1754 23900 4051 Switzerland
2982 2982     Recovered Canada 2020-05-02 02:32:27     0 0 22764 -22764 Recovered, Canada
3088 3088       Ireland 2020-05-02 02:32:27 53.1424 -7.6921 20833 1265 13386 6182 Ireland
3144 3144       Russia 2020-05-02 02:32:27 61.52401 105.31875600000001 114431 1169 13220 100042 Russia
3016 3016       Austria 2020-05-02 02:32:27 47.5162 14.5501 15531 589 13110 1832 Austria
3117 3117       Mexico 2020-05-02 02:32:27 23.6345 -102.5528 20739 1972 12377 6390 Mexico
3023 3023       Belgium 2020-05-02 02:32:27 50.8333 4.469936 49032 7703 11892 29437 Belgium
3138 3138       Peru 2020-05-02 02:32:27 -9.19 -75.0152 40459 1124 11129 28206 Peru
3084 3084       India 2020-05-02 02:32:27 20.593684 78.96288 37257 1223 10007 26027 India
3089 3089       Israel 2020-05-02 02:32:27 31.046051000000002 34.851612 16012 229 9393 6720 Israel
3096 3096       Korea, South 2020-05-02 02:32:27 35.90775700000001 127.766922 10780 250 9123 1407 Korea, South
3041 3041       Chile 2020-05-02 02:32:27 -35.6751 -71.543 17008 234 9018 7756 Chile
3052 3052       Denmark 2020-05-02 02:32:27 56.2639 9.5018 9311 460 6729 2122 Denmark
3134 3134       Pakistan 2020-05-02 02:32:27 30.3753 69.3451 18114 417 4715 12982 Pakistan
3143 3143       Romania 2020-05-02 02:32:27 45.9432 24.9668 12567 744 4328 7495 Romania
3111 3111       Malaysia 2020-05-02 02:32:27 4.210483999999999 101.97576600000001 6071 103 4210 1758 Malaysia
3152 3152       Saudi Arabia 2020-05-02 02:32:27 23.885942 45.079162 24097 169 3555 20373 Saudi Arabia
3140 3140       Poland 2020-05-02 02:32:27 51.9194 19.1451 13105 651 3491 8963 Poland
3051 3051       Czechia 2020-05-02 02:32:27 49.8175 15.472999999999999 7737 240 3372 4125 Czechia
3107 3107       Luxembourg 2020-05-02 02:32:27 49.8153 6.1296 3802 92 3213 497 Luxembourg
3066 3066       Finland 2020-05-02 02:32:27 61.92411 25.748151 5051 218 3000 1833 Finland
3092 3092       Japan 2020-05-02 02:32:27 36.204824 138.252924 14305 455 2975 10875 Japan
3022 3022       Belarus 2020-05-02 02:32:27 53.7098 27.9534 14917 93 2918 11906 Belarus
3173 3173       Thailand 2020-05-02 02:32:27 15.870032 100.992541 2960 54 2719 187 Thailand
3181 3181       United Arab Emirates 2020-05-02 02:32:27 23.424076 53.847818000000004 13038 111 2543 10384 United Arab Emirates
3161 3161       South Africa 2020-05-02 02:32:27 -30.5595 22.9375 5951 116 2382 3453 South Africa
2968 2968     New South Wales Australia 2020-05-02 02:32:27 -33.8688 151.2093 3030 41 2293 696 New South Wales, Australia
3057 3057       Ecuador 2020-05-02 02:32:27 -1.8312 -78.1834 26336 1063 1913 23360 Ecuador
3010 3010       Algeria 2020-05-02 02:32:27 28.0339 1.6596 4154 453 1821 1880 Algeria
3083 3083       Iceland 2020-05-02 02:32:27 64.9631 -19.0208 1798 10 1689 99 Iceland
3141 3141       Portugal 2020-05-02 02:32:27 39.3999 -8.2245 25351 1007 1647 22697 Portugal
3098 3098       Kuwait 2020-05-02 02:32:27 29.311659999999996 47.481766 4377 30 1602 2745 Kuwait
3085 3085       Indonesia 2020-05-02 02:32:27 -0.7893 113.9213 10551 800 1591 8160 Indonesia
2945 2945     Guangdong China 2020-05-02 02:32:27 23.3417 113.4244 1588 8 1565 15 Guangdong, China
3019 3019       Bahrain 2020-05-02 02:32:27 26.0275 50.55 3170 8 1555 1607 Bahrain
3042 3042       Colombia 2020-05-02 02:32:27 4.5709 -74.2973 7006 314 1551 5141 Colombia
3058 3058       Egypt 2020-05-02 02:32:27 26.820553000000004 30.802497999999996 5895 406 1460 4029 Egypt
3142 3142       Qatar 2020-05-02 02:32:27 25.3548 51.1839 14096 12 1436 12648 Qatar
3048 3048       Croatia 2020-05-02 02:32:27 45.1 15.2 2085 75 1421 589 Croatia
3087 3087       Iraq 2020-05-02 02:32:27 33.223191 43.679291 2153 94 1414 645 Iraq
3180 3180       Ukraine 2020-05-02 02:32:27 48.3794 31.1656 10861 272 1413 9176 Ukraine
3056 3056       Dominican Republic 2020-05-02 02:32:27 18.7357 -70.1627 7288 313 1387 5588 Dominican Republic
3073 3073       Greece 2020-05-02 02:32:27 39.0742 21.8243 2612 140 1374 1098 Greece
3017 3017       Azerbaijan 2020-05-02 02:32:27 40.1431 47.5769 1854 25 1365 464 Azerbaijan
3154 3154       Serbia 2020-05-02 02:32:27 44.0165 21.0059 9009 179 1343 7487 Serbia
3001 3001     Victoria Australia 2020-05-02 02:32:27 -37.8136 144.9631 1371 18 1300 53 Victoria, Australia
3014 3014       Argentina 2020-05-02 02:32:27 -38.4161 -63.6167 4532 225 1292 3015 Argentina
3118 3118       Moldova 2020-05-02 02:32:27 47.4116 28.3699 3980 122 1272 2586 Moldova
3157 3157       Singapore 2020-05-02 02:32:27 1.2833 103.8333 17101 16 1268 15817 Singapore
3007 3007     Zhejiang China 2020-05-02 02:32:27 29.1832 120.0934 1268 1 1265 2 Zhejiang, China
3127 3127       New Zealand 2020-05-02 02:32:27 -40.9006 174.886 1485 20 1263 202 New Zealand
2951 2951     Henan China 2020-05-02 02:32:27 33.882 113.614 1276 22 1254 0 Henan, China
3184 3184       Uzbekistan 2020-05-02 02:32:27 41.377491 64.585262 2086 9 1212 865 Uzbekistan
3139 3139       Philippines 2020-05-02 02:32:27 12.879721 121.77401699999999 8772 579 1084 7109 Philippines
3122 3122       Morocco 2020-05-02 02:32:27 31.7917 -7.0926 4569 171 1083 3315 Morocco
2954 2954     Hunan China 2020-05-02 02:32:27 27.6104 111.7088 1019 4 1015 0 Hunan, China
3167 3167       Sweden 2020-05-02 02:32:27 60.128161 18.643501 21520 2653 1005 17862 Sweden
2919 2919     Anhui China 2020-05-02 02:32:27 31.8257 117.2264 991 6 985 0 Anhui, China
3015 3015       Armenia 2020-05-02 02:32:27 40.0691 45.0382 2148 33 977 1138 Armenia
2981 2981     Queensland Australia 2020-05-02 02:32:27 -27.4698 153.0251 1034 6 965 63 Queensland, Australia
2958 2958     Jiangxi China 2020-05-02 02:32:27 27.614 115.7221 937 1 936 0 Jiangxi, China
3038 3038       Cameroon 2020-05-02 02:32:27 3.8480000000000003 11.5021 1832 61 934 837 Cameroon
3094 3094       Kazakhstan 2020-05-02 02:32:27 48.0196 66.9237 3597 25 922 2650 Kazakhstan
2952 2952     Hong Kong China 2020-05-02 02:32:27 22.3 114.2 1039 4 859 176 Hong Kong, China
3131 3131       North Macedonia 2020-05-02 02:32:27 41.6086 21.7453 1494 81 807 606 North Macedonia
2990 2990     Shandong China 2020-05-02 02:32:27 36.3427 118.1498 787 7 772 8 Shandong, China
3028 3028       Bosnia and Herzegovina 2020-05-02 02:32:27 43.9159 17.6791 1781 70 755 956 Bosnia and Herzegovina
3049 3049       Cuba 2020-05-02 02:32:27 21.521757 -77.78116700000002 1537 64 714 759 Cuba
3054 3054       Djibouti 2020-05-02 02:32:27 11.8251 42.5903 1097 2 672 423 Djibouti
2957 2957     Jiangsu China 2020-05-02 02:32:27 32.9711 119.455 653 0 650 3 Jiangsu, China
3053 3053       Diamond Princess 2020-05-02 02:32:27     712 13 645 54 Diamond Princess
3135 3135       Panama 2020-05-02 02:32:27 8.538 -80.7821 6720 192 622 5906 Panama
3106 3106       Lithuania 2020-05-02 02:32:27 55.1694 23.8813 1389 32 615 760 Lithuania
2991 2991     Shanghai China 2020-05-02 02:32:27 31.202 121.4491 652 7 612 33 Shanghai, China
3082 3082       Hungary 2020-05-02 02:32:27 47.1625 19.5033 2863 323 609 1931 Hungary
2950 2950     Heilongjiang China 2020-05-02 02:32:27 47.862 127.7615 944 13 605 326 Heilongjiang, China
3047 3047       Cote d'Ivoire 2020-05-02 02:32:27 7.54 -5.5471 1333 15 597 721 Cote d'Ivoire
2929 2929     Chongqing China 2020-05-02 02:32:27 30.0572 107.874 579 6 573 0 Chongqing, China
2993 2993     Sichuan China 2020-05-02 02:32:27 30.6171 102.7103 561 3 558 0 Sichuan, China
3158 3158       Slovakia 2020-05-02 02:32:27 48.669 19.699 1403 23 558 822 Slovakia
2922 2922     Beijing China 2020-05-02 02:32:27 40.1824 116.4142 593 9 547 37 Beijing, China
3033 3033       Burkina Faso 2020-05-02 02:32:27 12.2383 -1.5616 649 44 517 88 Burkina Faso
3003 3003     Western Australia Australia 2020-05-02 02:32:27 -31.9505 115.8605 551 8 511 32 Western Australia, Australia
3099 3099       Kyrgyzstan 2020-05-02 02:32:27 41.20438 74.766098 756 8 504 244 Kyrgyzstan
3133 3133       Oman 2020-05-02 02:32:27 21.512583 55.92325500000001 2447 11 495 1941 Oman
3009 3009       Albania 2020-05-02 02:32:27 41.1533 20.1683 782 31 488 263 Albania
3129 3129       Niger 2020-05-02 02:32:27 17.607789 8.081666 728 33 478 217 Niger
3011 3011       Andorra 2020-05-02 02:32:27 42.5063 1.5218 745 43 468 234 Andorra
3183 3183       Uruguay 2020-05-02 02:32:27 -32.5228 -55.7658 648 17 435 196 Uruguay
2995 2995     South Australia Australia 2020-05-02 02:32:27 -34.9285 138.6007 438 4 422 12 South Australia, Australia
2928 2928     Channel Islands United Kingdom 2020-05-02 02:32:27 49.3723 -2.3644 538 41 406 91 Channel Islands, United Kingdom

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

CREATE TABLE [05-01-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
);