05-06-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,218 rows sorted by Country_Region

✎ 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
3036 3036       Afghanistan 2020-05-07 02:32:28 33.93911 67.709953 3393 104 458 2830 Afghanistan
3037 3037       Albania 2020-05-07 02:32:28 41.1533 20.1683 832 31 595 206 Albania
3038 3038       Algeria 2020-05-07 02:32:28 28.0339 1.6596 4997 476 2197 2324 Algeria
3039 3039       Andorra 2020-05-07 02:32:28 42.5063 1.5218 751 46 521 184 Andorra
3040 3040       Angola 2020-05-07 02:32:28 -11.2027 17.8739 36 2 11 23 Angola
3041 3041       Antigua and Barbuda 2020-05-07 02:32:28 17.0608 -61.7964 25 3 16 6 Antigua and Barbuda
3042 3042       Argentina 2020-05-07 02:32:28 -38.4161 -63.6167 5208 273 1524 3411 Argentina
3043 3043       Armenia 2020-05-07 02:32:28 40.0691 45.0382 2782 40 1135 1607 Armenia
2949 2949     Australian Capital Territory Australia 2020-05-07 02:32:28 -35.4735 149.0124 107 3 103 1 Australian Capital Territory, Australia
2996 2996     New South Wales Australia 2020-05-07 02:32:28 -33.8688 151.2093 3044 44 2463 537 New South Wales, Australia
3000 3000     Northern Territory Australia 2020-05-07 02:32:28 -12.4634 130.8456 29 0 27 2 Northern Territory, Australia
3009 3009     Queensland Australia 2020-05-07 02:32:28 -27.4698 153.0251 1045 6 989 50 Queensland, Australia
3023 3023     South Australia Australia 2020-05-07 02:32:28 -34.9285 138.6007 438 4 432 2 South Australia, Australia
3025 3025     Tasmania Australia 2020-05-07 02:32:28 -42.8821 147.3272 226 13 167 46 Tasmania, Australia
3029 3029     Victoria Australia 2020-05-07 02:32:28 -37.8136 144.9631 1454 18 1322 114 Victoria, Australia
3031 3031     Western Australia Australia 2020-05-07 02:32:28 -31.9505 115.8605 551 9 528 14 Western Australia, Australia
3044 3044       Austria 2020-05-07 02:32:28 47.5162 14.5501 15684 608 13639 1437 Austria
3045 3045       Azerbaijan 2020-05-07 02:32:28 40.1431 47.5769 2127 28 1536 563 Azerbaijan
3046 3046       Bahamas 2020-05-07 02:32:28 25.025885 -78.035889 92 11 26 55 Bahamas
3047 3047       Bahrain 2020-05-07 02:32:28 26.0275 50.55 3934 8 1860 2066 Bahrain
3048 3048       Bangladesh 2020-05-07 02:32:28 23.685 90.3563 11719 186 1403 10130 Bangladesh
3049 3049       Barbados 2020-05-07 02:32:28 13.1939 -59.5432 82 7 47 28 Barbados
3050 3050       Belarus 2020-05-07 02:32:28 53.7098 27.9534 19255 112 4388 14755 Belarus
3051 3051       Belgium 2020-05-07 02:32:28 50.8333 4.469936 50781 8339 12731 29711 Belgium
3052 3052       Belize 2020-05-07 02:32:28 17.1899 -88.4976 18 2 16 0 Belize
3053 3053       Benin 2020-05-07 02:32:28 9.3077 2.3158 96 2 50 44 Benin
3054 3054       Bhutan 2020-05-07 02:32:28 27.5142 90.4336 7 0 5 2 Bhutan
3055 3055       Bolivia 2020-05-07 02:32:28 -16.2902 -63.5887 1886 91 198 1597 Bolivia
3056 3056       Bosnia and Herzegovina 2020-05-07 02:32:28 43.9159 17.6791 1987 86 928 973 Bosnia and Herzegovina
3057 3057       Botswana 2020-05-07 02:32:28 -22.3285 24.6849 23 1 8 14 Botswana
3058 3058       Brazil 2020-05-07 02:32:28 -14.235 -51.9253 126611 8588 51370 66653 Brazil
3059 3059       Brunei 2020-05-07 02:32:28 4.5353 114.7277 139 1 131 7 Brunei
3060 3060       Bulgaria 2020-05-07 02:32:28 42.7339 25.4858 1778 84 360 1334 Bulgaria
3061 3061       Burkina Faso 2020-05-07 02:32:28 12.2383 -1.5616 729 48 555 126 Burkina Faso
3062 3062       Burma 2020-05-07 02:32:28 21.9162 95.956 161 6 50 105 Burma
3063 3063       Burundi 2020-05-07 02:32:28 -3.3731 29.9189 15 1 7 7 Burundi
3064 3064       Cabo Verde 2020-05-07 02:32:28 16.5388 -23.0418 191 2 38 151 Cabo Verde
3065 3065       Cambodia 2020-05-07 02:32:28 11.55 104.9167 122 0 120 2 Cambodia
3066 3066       Cameroon 2020-05-07 02:32:28 3.8480000000000003 11.5021 2265 108 1000 1157 Cameroon
2945 2945     Alberta Canada 2020-05-07 02:32:28 53.9333 -116.5765 5963 112 0 5851 Alberta, Canada
2953 2953     British Columbia Canada 2020-05-07 02:32:28 53.7267 -127.6476 2255 124 0 2131 British Columbia, Canada
2959 2959     Diamond Princess Canada 2020-05-07 02:32:28     1 1 0 0 Diamond Princess, Canada
2968 2968     Grand Princess Canada 2020-05-07 02:32:28     13 0 0 13 Grand Princess, Canada
2990 2990     Manitoba Canada 2020-05-07 02:32:28 53.7609 -98.8139 286 7 0 279 Manitoba, Canada
2994 2994     New Brunswick Canada 2020-05-07 02:32:28 46.5653 -66.4619 120 0 0 120 New Brunswick, Canada
2997 2997     Newfoundland and Labrador Canada 2020-05-07 02:32:28 53.1355 -57.6604 259 3 0 256 Newfoundland and Labrador, Canada
3001 3001     Northwest Territories Canada 2020-05-07 02:32:28 64.8255 -124.8457 5 0 0 5 Northwest Territories, Canada
3002 3002     Nova Scotia Canada 2020-05-07 02:32:28 44.681999999999995 -63.7443 998 41 0 957 Nova Scotia, Canada
3003 3003     Nunavut Canada 2020-05-07 02:32:28 70.2998 -83.1076 0 0 0 0 Nunavut, Canada
3004 3004     Ontario Canada 2020-05-07 02:32:28 51.2538 -85.3232 19910 1560 0 18350 Ontario, Canada
3005 3005     Prince Edward Island Canada 2020-05-07 02:32:28 46.5107 -63.4168 27 0 0 27 Prince Edward Island, Canada
3008 3008     Quebec Canada 2020-05-07 02:32:28 52.9399 -73.5491 34334 3385 0 31823 Quebec, Canada
3010 3010     Recovered Canada 2020-05-07 02:32:28     0 0 28184 -28184 Recovered, Canada
3016 3016     Saskatchewan Canada 2020-05-07 02:32:28 52.9399 -106.4509 512 7 0 505 Saskatchewan, Canada
3033 3033     Yukon Canada 2020-05-07 02:32:28 64.2823 -135.0 11 0 0 11 Yukon, Canada
3067 3067       Central African Republic 2020-05-07 02:32:28 6.6111 20.9394 94 0 10 84 Central African Republic
3068 3068       Chad 2020-05-07 02:32:28 15.4542 18.7322 170 17 43 110 Chad
3069 3069       Chile 2020-05-07 02:32:28 -35.6751 -71.543 23048 281 11189 11578 Chile
2947 2947     Anhui China 2020-05-07 02:32:28 31.8257 117.2264 991 6 985 0 Anhui, China
2950 2950     Beijing China 2020-05-07 02:32:28 40.1824 116.4142 593 9 557 27 Beijing, China
2957 2957     Chongqing China 2020-05-07 02:32:28 30.0572 107.874 579 6 573 0 Chongqing, China
2965 2965     Fujian China 2020-05-07 02:32:28 26.0789 117.9874 356 1 354 1 Fujian, China
2966 2966     Gansu China 2020-05-07 02:32:28 37.8099 101.0583 139 2 137 0 Gansu, China
2973 2973     Guangdong China 2020-05-07 02:32:28 23.3417 113.4244 1589 8 1575 6 Guangdong, China
2974 2974     Guangxi China 2020-05-07 02:32:28 23.8298 108.7881 254 2 252 0 Guangxi, China
2975 2975     Guizhou China 2020-05-07 02:32:28 26.8154 106.8748 147 2 145 0 Guizhou, China
2976 2976     Hainan China 2020-05-07 02:32:28 19.1959 109.7453 168 6 162 0 Hainan, China
2977 2977     Hebei China 2020-05-07 02:32:28 39.549 116.1306 328 6 320 2 Hebei, China
2978 2978     Heilongjiang China 2020-05-07 02:32:28 47.861999999999995 127.7615 944 13 793 138 Heilongjiang, China
2979 2979     Henan China 2020-05-07 02:32:28 33.882 113.61399999999999 1276 22 1254 0 Henan, China
2980 2980     Hong Kong China 2020-05-07 02:32:28 22.3 114.2 1040 4 932 104 Hong Kong, China
2981 2981     Hubei China 2020-05-07 02:32:28 30.9756 112.2707 68128 4512 63616 0 Hubei, China
2982 2982     Hunan China 2020-05-07 02:32:28 27.6104 111.7088 1019 4 1015 0 Hunan, China
2983 2983     Inner Mongolia China 2020-05-07 02:32:28 44.0935 113.9448 201 1 171 29 Inner Mongolia, China
2985 2985     Jiangsu China 2020-05-07 02:32:28 32.9711 119.455 653 0 651 2 Jiangsu, China
2986 2986     Jiangxi China 2020-05-07 02:32:28 27.614 115.7221 937 1 936 0 Jiangxi, China
2987 2987     Jilin China 2020-05-07 02:32:28 43.6661 126.1923 112 1 103 8 Jilin, China
2988 2988     Liaoning China 2020-05-07 02:32:28 41.2956 122.6085 146 2 144 0 Liaoning, China
2989 2989     Macau China 2020-05-07 02:32:28 22.1667 113.55 45 0 40 5 Macau, China
2998 2998     Ningxia China 2020-05-07 02:32:28 37.2692 106.1655 75 0 75 0 Ningxia, China
3007 3007     Qinghai China 2020-05-07 02:32:28 35.7452 95.9956 18 0 18 0 Qinghai, China
3017 3017     Shaanxi China 2020-05-07 02:32:28 35.1917 108.8701 308 3 266 39 Shaanxi, China
3018 3018     Shandong China 2020-05-07 02:32:28 36.3427 118.1498 788 7 775 6 Shandong, China
3019 3019     Shanghai China 2020-05-07 02:32:28 31.201999999999998 121.4491 657 7 620 30 Shanghai, China
3020 3020     Shanxi China 2020-05-07 02:32:28 37.5777 112.2922 198 0 194 4 Shanxi, China
3021 3021     Sichuan China 2020-05-07 02:32:28 30.6171 102.7103 561 3 558 0 Sichuan, China
3026 3026     Tianjin China 2020-05-07 02:32:28 39.3054 117.323 190 3 186 1 Tianjin, China
3027 3027     Tibet China 2020-05-07 02:32:28 31.6927 88.0924 1 0 1 0 Tibet, China
3032 3032     Xinjiang China 2020-05-07 02:32:28 41.1129 85.2401 76 3 73 0 Xinjiang, China
3034 3034     Yunnan China 2020-05-07 02:32:28 24.974 101.48700000000001 185 2 181 2 Yunnan, China
3035 3035     Zhejiang China 2020-05-07 02:32:28 29.1832 120.0934 1268 1 1267 0 Zhejiang, China
3070 3070       Colombia 2020-05-07 02:32:28 4.5709 -74.2973 8959 397 2148 6414 Colombia
3071 3071       Comoros 2020-05-07 02:32:28 -11.6455 43.3333 8 1 0 7 Comoros
3072 3072       Congo (Brazzaville) 2020-05-07 02:32:28 -4.2634 15.2832 264 10 30 224 Congo (Brazzaville)
3073 3073       Congo (Kinshasa) 2020-05-07 02:32:28 -4.322447 15.307045 797 35 92 670 Congo (Kinshasa)
3074 3074       Costa Rica 2020-05-07 02:32:28 9.7489 -83.7534 761 6 428 327 Costa Rica
3075 3075       Cote d'Ivoire 2020-05-07 02:32:28 7.54 -5.5471 1516 18 721 777 Cote d'Ivoire
3076 3076       Croatia 2020-05-07 02:32:28 45.1 15.2 2119 85 1601 433 Croatia
3077 3077       Cuba 2020-05-07 02:32:28 21.521757 -77.78116700000002 1703 69 1001 633 Cuba
3078 3078       Cyprus 2020-05-07 02:32:28 35.1264 33.4299 883 15 296 572 Cyprus

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

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