04-28-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,165 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
3139 3139       Spain 2020-04-29 02:32:29 40.463667 -3.7492199999999998 232128 23822 123903 84403 Spain
3047 3047       Germany 2020-04-29 02:32:29 51.165690999999995 10.451526 159912 6314 117400 36198 Germany
2960 2960     Recovered US 2020-04-29 02:32:29     0 0 115936 -115936 Recovered, US
3062 3062       Iran 2020-04-29 02:32:29 32.427908 53.68804599999999 92584 5877 72439 14268 Iran
3066 3066       Italy 2020-04-29 02:32:29 41.87194 12.56738 201505 27359 68941 105205 Italy
2930 2930     Hubei China 2020-04-29 02:32:29 30.9756 112.2707 68128 4512 63616 0 Hubei, China
3043 3043       France 2020-04-29 02:32:29 46.2276 2.2137 167650 23631 46886 97059 France
3153 3153       Turkey 2020-04-29 02:32:29 38.9637 35.2433 114653 2992 38809 72852 Turkey
3007 3007       Brazil 2020-04-29 02:32:29 -14.235 -51.9253 73235 5083 32544 35608 Brazil
3144 3144       Switzerland 2020-04-29 02:32:29 46.8182 8.2275 29264 1699 22600 4965 Switzerland
2959 2959     Recovered Canada 2020-04-29 02:32:29     0 0 19231 -19231 Recovered, Canada
2993 2993       Austria 2020-04-29 02:32:29 47.5162 14.5501 15357 569 12580 2208 Austria
3093 3093       Mexico 2020-04-29 02:32:29 23.6345 -102.5528 16752 1569 11423 3760 Mexico
3000 3000       Belgium 2020-04-29 02:32:29 50.8333 4.469936 47334 7331 10943 29060 Belgium
3064 3064       Ireland 2020-04-29 02:32:29 53.1424 -7.6921 19877 1159 9233 9485 Ireland
3114 3114       Peru 2020-04-29 02:32:29 -9.19 -75.0152 31190 854 9179 21157 Peru
3072 3072       Korea, South 2020-04-29 02:32:29 35.90775700000001 127.766922 10761 246 8922 1593 Korea, South
3120 3120       Russia 2020-04-29 02:32:29 61.52401 105.31875600000001 93558 867 8456 84235 Russia
3065 3065       Israel 2020-04-29 02:32:29 31.046051000000002 34.851612 15672 213 8118 7772 Israel
3060 3060       India 2020-04-29 02:32:29 20.593684 78.96288 31324 1008 7747 22569 India
3018 3018       Chile 2020-04-29 02:32:29 -35.6751 -71.543 14365 207 7710 6448 Chile
3028 3028       Denmark 2020-04-29 02:32:29 56.2639 9.5018 8851 434 6121 2296 Denmark
3087 3087       Malaysia 2020-04-29 02:32:29 4.210483999999999 101.97576600000001 5851 100 4032 1719 Malaysia
3119 3119       Romania 2020-04-29 02:32:29 45.9432 24.9668 11616 663 3404 7549 Romania
3110 3110       Pakistan 2020-04-29 02:32:29 30.3753 69.3451 14612 312 3233 11067 Pakistan
3083 3083       Luxembourg 2020-04-29 02:32:29 49.8153 6.1296 3741 89 3123 529 Luxembourg
3027 3027       Czechia 2020-04-29 02:32:29 49.8175 15.472999999999999 7504 227 2948 4329 Czechia
3042 3042       Finland 2020-04-29 02:32:29 61.92411 25.748151 4740 199 2800 1741 Finland
3128 3128       Saudi Arabia 2020-04-29 02:32:29 23.885942 45.079162 20077 152 2784 17141 Saudi Arabia
3116 3116       Poland 2020-04-29 02:32:29 51.9194 19.1451 12218 596 2655 8967 Poland
3148 3148       Thailand 2020-04-29 02:32:29 15.870032 100.992541 2938 54 2652 232 Thailand
2945 2945     New South Wales Australia 2020-04-29 02:32:29 -33.8688 151.2093 3016 39 2266 711 New South Wales, Australia
3156 3156       United Arab Emirates 2020-04-29 02:32:29 23.424076 53.847818000000004 11380 89 2181 9110 United Arab Emirates
3137 3137       South Africa 2020-04-29 02:32:29 -30.5595 22.9375 4996 93 2073 2830 South Africa
2999 2999       Belarus 2020-04-29 02:32:29 53.7098 27.9534 12208 79 1993 10136 Belarus
3068 3068       Japan 2020-04-29 02:32:29 36.204824 138.252924 13736 394 1899 11443 Japan
2987 2987       Algeria 2020-04-29 02:32:29 28.0339 1.6596 3649 437 1651 1561 Algeria
3059 3059       Iceland 2020-04-29 02:32:29 64.9631 -19.0208 1795 10 1636 149 Iceland
3033 3033       Ecuador 2020-04-29 02:32:29 -1.8312 -78.1834 24258 871 1557 21830 Ecuador
2922 2922     Guangdong China 2020-04-29 02:32:29 23.3417 113.4244 1588 8 1554 26 Guangdong, China
3117 3117       Portugal 2020-04-29 02:32:29 39.3999 -8.2245 24322 948 1389 21985 Portugal
3063 3063       Iraq 2020-04-29 02:32:29 33.223191 43.679291 1928 90 1319 519 Iraq
2996 2996       Bahrain 2020-04-29 02:32:29 26.0275 50.55 2811 8 1310 1493 Bahrain
3034 3034       Egypt 2020-04-29 02:32:29 26.820553000000004 30.802497999999996 5042 359 1304 3379 Egypt
2978 2978     Victoria Australia 2020-04-29 02:32:29 -37.8136 144.9631 1354 18 1287 49 Victoria, Australia
3019 3019       Colombia 2020-04-29 02:32:29 4.5709 -74.2973 5949 269 1268 4412 Colombia
2984 2984     Zhejiang China 2020-04-29 02:32:29 29.1832 120.0934 1268 1 1262 5 Zhejiang, China
2928 2928     Henan China 2020-04-29 02:32:29 33.882 113.61399999999999 1276 22 1254 0 Henan, China
3061 3061       Indonesia 2020-04-29 02:32:29 -0.7893 113.9213 9511 773 1254 7484 Indonesia
3024 3024       Croatia 2020-04-29 02:32:29 45.1 15.2 2047 63 1232 752 Croatia
3103 3103       New Zealand 2020-04-29 02:32:29 -40.9006 174.886 1474 19 1229 226 New Zealand
2994 2994       Azerbaijan 2020-04-29 02:32:29 40.1431 47.5769 1717 22 1221 474 Azerbaijan
3074 3074       Kuwait 2020-04-29 02:32:29 29.311659999999996 47.481766 3440 23 1176 2241 Kuwait
3032 3032       Dominican Republic 2020-04-29 02:32:29 18.7357 -70.1627 6416 286 1165 4965 Dominican Republic
2991 2991       Argentina 2020-04-29 02:32:29 -38.4161 -63.6167 4127 207 1162 2758 Argentina
3118 3118       Qatar 2020-04-29 02:32:29 25.3548 51.1839 11921 10 1134 10777 Qatar
3133 3133       Singapore 2020-04-29 02:32:29 1.2833 103.8333 14951 14 1128 13809 Singapore
2931 2931     Hunan China 2020-04-29 02:32:29 27.6104 111.7088 1019 4 1015 0 Hunan, China
3143 3143       Sweden 2020-04-29 02:32:29 60.128161 18.643501 19621 2355 1005 16261 Sweden
3155 3155       Ukraine 2020-04-29 02:32:29 48.3794 31.1656 9410 239 992 8179 Ukraine
3159 3159       Uzbekistan 2020-04-29 02:32:29 41.377491 64.585262 1939 8 992 939 Uzbekistan
2896 2896     Anhui China 2020-04-29 02:32:29 31.8257 117.2264 991 6 985 0 Anhui, China
3094 3094       Moldova 2020-04-29 02:32:29 47.4116 28.3699 3638 103 975 2560 Moldova
3115 3115       Philippines 2020-04-29 02:32:29 12.879721 121.77401699999999 7958 530 975 6453 Philippines
2935 2935     Jiangxi China 2020-04-29 02:32:29 27.614 115.7221 937 1 936 0 Jiangxi, China
2958 2958     Queensland Australia 2020-04-29 02:32:29 -27.4698 153.0251 1034 6 934 94 Queensland, Australia
3015 3015       Cameroon 2020-04-29 02:32:29 3.8480000000000003 11.5021 1705 58 915 732 Cameroon
3130 3130       Serbia 2020-04-29 02:32:29 44.0165 21.0059 6630 125 870 5635 Serbia
2992 2992       Armenia 2020-04-29 02:32:29 40.0691 45.0382 1867 30 866 971 Armenia
2929 2929     Hong Kong China 2020-04-29 02:32:29 22.3 114.2 1037 4 811 222 Hong Kong, China
3098 3098       Morocco 2020-04-29 02:32:29 31.7917 -7.0926 4252 165 778 3309 Morocco
3070 3070       Kazakhstan 2020-04-29 02:32:29 48.0196 66.9237 3027 25 774 2228 Kazakhstan
2967 2967     Shandong China 2020-04-29 02:32:29 36.3427 118.1498 787 7 771 9 Shandong, China
3005 3005       Bosnia and Herzegovina 2020-04-29 02:32:29 43.9159 17.6791 1585 63 682 840 Bosnia and Herzegovina
2934 2934     Jiangsu China 2020-04-29 02:32:29 32.9711 119.455 653 0 647 6 Jiangsu, China
3029 3029       Diamond Princess 2020-04-29 02:32:29     712 13 645 54 Diamond Princess
3107 3107       North Macedonia 2020-04-29 02:32:29 41.6086 21.7453 1421 71 589 761 North Macedonia
2927 2927     Heilongjiang China 2020-04-29 02:32:29 47.861999999999995 127.7615 939 13 587 339 Heilongjiang, China
2968 2968     Shanghai China 2020-04-29 02:32:29 31.201999999999998 121.4491 645 7 584 54 Shanghai, China
3049 3049       Greece 2020-04-29 02:32:29 39.0742 21.8243 2566 138 577 1851 Greece
3025 3025       Cuba 2020-04-29 02:32:29 21.521757 -77.78116700000002 1437 58 575 804 Cuba
2906 2906     Chongqing China 2020-04-29 02:32:29 30.0572 107.874 579 6 573 0 Chongqing, China
2970 2970     Sichuan China 2020-04-29 02:32:29 30.6171 102.7103 561 3 558 0 Sichuan, China
2899 2899     Beijing China 2020-04-29 02:32:29 40.1824 116.4142 593 9 538 46 Beijing, China
3023 3023       Cote d'Ivoire 2020-04-29 02:32:29 7.54 -5.5471 1183 14 525 644 Cote d'Ivoire
3058 3058       Hungary 2020-04-29 02:32:29 47.1625 19.5033 2649 291 516 1842 Hungary
3030 3030       Djibouti 2020-04-29 02:32:29 11.8251 42.5903 1072 2 498 572 Djibouti
2980 2980     Western Australia Australia 2020-04-29 02:32:29 -31.9505 115.8605 550 8 495 47 Western Australia, Australia
3010 3010       Burkina Faso 2020-04-29 02:32:29 12.2383 -1.5616 638 42 476 120 Burkina Faso
3082 3082       Lithuania 2020-04-29 02:32:29 55.1694 23.8813 1337 32 474 764 Lithuania
3111 3111       Panama 2020-04-29 02:32:29 8.538 -80.7821 6021 167 455 5399 Panama
2986 2986       Albania 2020-04-29 02:32:29 41.1533 20.1683 750 30 431 289 Albania
3134 3134       Slovakia 2020-04-29 02:32:29 48.669 19.699 1384 20 423 941 Slovakia
2972 2972     South Australia Australia 2020-04-29 02:32:29 -34.9285 138.6007 438 4 420 14 South Australia, Australia
3075 3075       Kyrgyzstan 2020-04-29 02:32:29 41.20438 74.766098 708 8 416 284 Kyrgyzstan
3105 3105       Niger 2020-04-29 02:32:29 17.607789 8.081666 709 31 403 275 Niger
2988 2988       Andorra 2020-04-29 02:32:29 42.5063 1.5218 743 41 398 304 Andorra
3158 3158       Uruguay 2020-04-29 02:32:29 -32.5228 -55.7658 625 15 394 216 Uruguay
3109 3109       Oman 2020-04-29 02:32:29 21.512583 55.92325500000001 2131 10 364 1757 Oman
2905 2905     Channel Islands United Kingdom 2020-04-29 02:32:29 49.3723 -2.3644 530 36 352 142 Channel Islands, United Kingdom

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

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