05-05-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,211 rows sorted by FIPS

✎ 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
144 144   Bear River Utah US 2020-05-06 02:32:31 41.52106798 -113.08328159999999 62 1 0 61 Bear River, Utah, US
403 403   Central Utah Utah US 2020-05-06 02:32:31 39.37231946 -111.5758676 25 0 0 25 Central Utah, Utah, US
759 759   Dukes and Nantucket Massachusetts US 2020-05-06 02:32:31 41.40674725 -70.68763497 32 1 0 31 Dukes and Nantucket, Massachusetts, US
847 847   Federal Correctional Institution (FCI) Michigan US 2020-05-06 02:32:31     98 2 0 96 Federal Correctional Institution (FCI), Michigan, US
1344 1344   Kansas City Missouri US 2020-05-06 02:32:31 39.0997 -94.5786 683 16 0 667 Kansas City, Missouri, US
1748 1748   Michigan Department of Corrections (MDOC) Michigan US 2020-05-06 02:32:31     1898 48 0 1850 Michigan Department of Corrections (MDOC), Michigan, US
2420 2420   Southeast Utah Utah US 2020-05-06 02:32:31 38.99617072 -110.70139579999999 12 0 0 12 Southeast Utah, Utah, US
2588 2588   TriCounty Utah US 2020-05-06 02:32:31 40.12491499 -109.5174415 14 0 0 14 TriCounty, Utah, US
2813 2813   Weber-Morgan Utah US 2020-05-06 02:32:31 41.27116049 -111.9145117 173 2 0 171 Weber-Morgan, Utah, US
2938 2938     Alberta Canada 2020-05-06 02:32:31 53.9333 -116.5765 5893 106 0 5787 Alberta, Canada
2939 2939     Anguilla United Kingdom 2020-05-06 02:32:31 18.2206 -63.0686 3 0 3 0 Anguilla, United Kingdom
2940 2940     Anhui China 2020-05-06 02:32:31 31.8257 117.2264 991 6 985 0 Anhui, China
2941 2941     Aruba Netherlands 2020-05-06 02:32:31 12.5211 -69.9683 101 2 82 17 Aruba, Netherlands
2942 2942     Australian Capital Territory Australia 2020-05-06 02:32:31 -35.4735 149.0124 107 3 103 1 Australian Capital Territory, Australia
2943 2943     Beijing China 2020-05-06 02:32:31 40.1824 116.4142 593 9 555 29 Beijing, China
2944 2944     Bermuda United Kingdom 2020-05-06 02:32:31 32.3078 -64.7505 115 7 54 54 Bermuda, United Kingdom
2945 2945     Bonaire, Sint Eustatius and Saba Netherlands 2020-05-06 02:32:31 12.1784 -68.2385 6 0 0 6 Bonaire, Sint Eustatius and Saba, Netherlands
2946 2946     British Columbia Canada 2020-05-06 02:32:31 53.7267 -127.6476 2232 121 0 2111 British Columbia, Canada
2947 2947     British Virgin Islands United Kingdom 2020-05-06 02:32:31 18.4207 -64.64 6 1 3 2 British Virgin Islands, United Kingdom
2948 2948     Cayman Islands United Kingdom 2020-05-06 02:32:31 19.3133 -81.2546 78 1 30 47 Cayman Islands, United Kingdom
2949 2949     Channel Islands United Kingdom 2020-05-06 02:32:31 49.3723 -2.3644 545 40 406 99 Channel Islands, United Kingdom
2950 2950     Chongqing China 2020-05-06 02:32:31 30.0572 107.874 579 6 573 0 Chongqing, China
2951 2951     Curacao Netherlands 2020-05-06 02:32:31 12.1696 -68.99 16 1 13 2 Curacao, Netherlands
2952 2952     Diamond Princess Canada 2020-05-06 02:32:31     1 1 0 0 Diamond Princess, Canada
2954 2954     Falkland Islands (Malvinas) United Kingdom 2020-05-06 02:32:31 -51.7963 -59.5236 13 0 13 0 Falkland Islands (Malvinas), United Kingdom
2955 2955     Faroe Islands Denmark 2020-05-06 02:32:31 61.8926 -6.9118 187 0 185 2 Faroe Islands, Denmark
2956 2956     French Guiana France 2020-05-06 02:32:31 4.0 -53.0 133 1 100 32 French Guiana, France
2957 2957     French Polynesia France 2020-05-06 02:32:31 -17.6797 -149.4068 60 0 54 6 French Polynesia, France
2958 2958     Fujian China 2020-05-06 02:32:31 26.0789 117.9874 356 1 353 2 Fujian, China
2959 2959     Gansu China 2020-05-06 02:32:31 37.8099 101.0583 139 2 137 0 Gansu, China
2960 2960     Gibraltar United Kingdom 2020-05-06 02:32:31 36.1408 -5.3536 144 0 133 11 Gibraltar, United Kingdom
2961 2961     Grand Princess Canada 2020-05-06 02:32:31     13 0 0 13 Grand Princess, Canada
2963 2963     Greenland Denmark 2020-05-06 02:32:31 71.7069 -42.6043 11 0 11 0 Greenland, Denmark
2964 2964     Guadeloupe France 2020-05-06 02:32:31 16.265 -61.551 152 12 98 42 Guadeloupe, France
2966 2966     Guangdong China 2020-05-06 02:32:31 23.3417 113.4244 1588 8 1575 5 Guangdong, China
2967 2967     Guangxi China 2020-05-06 02:32:31 23.8298 108.7881 254 2 252 0 Guangxi, China
2968 2968     Guizhou China 2020-05-06 02:32:31 26.8154 106.8748 147 2 145 0 Guizhou, China
2969 2969     Hainan China 2020-05-06 02:32:31 19.1959 109.7453 168 6 162 0 Hainan, China
2970 2970     Hebei China 2020-05-06 02:32:31 39.549 116.1306 328 6 320 2 Hebei, China
2971 2971     Heilongjiang China 2020-05-06 02:32:31 47.862 127.7615 944 13 758 173 Heilongjiang, China
2972 2972     Henan China 2020-05-06 02:32:31 33.882 113.614 1276 22 1254 0 Henan, China
2973 2973     Hong Kong China 2020-05-06 02:32:31 22.3 114.2 1040 4 920 116 Hong Kong, China
2974 2974     Hubei China 2020-05-06 02:32:31 30.9756 112.2707 68128 4512 63616 0 Hubei, China
2975 2975     Hunan China 2020-05-06 02:32:31 27.6104 111.7088 1019 4 1015 0 Hunan, China
2976 2976     Inner Mongolia China 2020-05-06 02:32:31 44.0935 113.9448 201 1 167 33 Inner Mongolia, China
2977 2977     Isle of Man United Kingdom 2020-05-06 02:32:31 54.2361 -4.5481 326 23 271 32 Isle of Man, United Kingdom
2978 2978     Jiangsu China 2020-05-06 02:32:31 32.9711 119.455 653 0 650 3 Jiangsu, China
2979 2979     Jiangxi China 2020-05-06 02:32:31 27.614 115.7221 937 1 936 0 Jiangxi, China
2980 2980     Jilin China 2020-05-06 02:32:31 43.6661 126.1923 112 1 103 8 Jilin, China
2981 2981     Liaoning China 2020-05-06 02:32:31 41.2956 122.6085 146 2 144 0 Liaoning, China
2982 2982     Macau China 2020-05-06 02:32:31 22.1667 113.55 45 0 39 6 Macau, China
2983 2983     Manitoba Canada 2020-05-06 02:32:31 53.7609 -98.8139 284 7 0 277 Manitoba, Canada
2984 2984     Martinique France 2020-05-06 02:32:31 14.6415 -61.0242 181 14 83 84 Martinique, France
2985 2985     Mayotte France 2020-05-06 02:32:31 -12.8275 45.166244 739 9 352 378 Mayotte, France
2986 2986     Montserrat United Kingdom 2020-05-06 02:32:31 16.742498 -62.187366000000004 11 1 7 3 Montserrat, United Kingdom
2987 2987     New Brunswick Canada 2020-05-06 02:32:31 46.5653 -66.4619 119 0 0 119 New Brunswick, Canada
2988 2988     New Caledonia France 2020-05-06 02:32:31 -20.904304999999997 165.618042 18 0 17 1 New Caledonia, France
2989 2989     New South Wales Australia 2020-05-06 02:32:31 -33.8688 151.2093 3042 44 2418 580 New South Wales, Australia
2990 2990     Newfoundland and Labrador Canada 2020-05-06 02:32:31 53.1355 -57.6604 259 3 0 256 Newfoundland and Labrador, Canada
2991 2991     Ningxia China 2020-05-06 02:32:31 37.2692 106.1655 75 0 75 0 Ningxia, China
2993 2993     Northern Territory Australia 2020-05-06 02:32:31 -12.4634 130.8456 29 0 26 3 Northern Territory, Australia
2994 2994     Northwest Territories Canada 2020-05-06 02:32:31 64.8255 -124.8457 5 0 0 5 Northwest Territories, Canada
2995 2995     Nova Scotia Canada 2020-05-06 02:32:31 44.681999999999995 -63.7443 991 41 0 950 Nova Scotia, Canada
2996 2996     Nunavut Canada 2020-05-06 02:32:31 70.2998 -83.1076 0 0 0 0 Nunavut, Canada
2997 2997     Ontario Canada 2020-05-06 02:32:31 51.2538 -85.3232 19468 1505 0 17963 Ontario, Canada
2998 2998     Prince Edward Island Canada 2020-05-06 02:32:31 46.5107 -63.4168 27 0 0 27 Prince Edward Island, Canada
3000 3000     Qinghai China 2020-05-06 02:32:31 35.7452 95.9956 18 0 18 0 Qinghai, China
3001 3001     Quebec Canada 2020-05-06 02:32:31 52.9399 -73.5491 33425 3290 0 31026 Quebec, Canada
3002 3002     Queensland Australia 2020-05-06 02:32:31 -27.4698 153.0251 1043 6 985 52 Queensland, Australia
3003 3003     Recovered Canada 2020-05-06 02:32:31     0 0 27006 -27006 Recovered, Canada
3004 3004     Recovered US 2020-05-06 02:32:31     0 0 189791 -160761 Recovered, US
3005 3005     Reunion France 2020-05-06 02:32:31 -21.1151 55.5364 424 0 300 124 Reunion, France
3006 3006     Saint Barthelemy France 2020-05-06 02:32:31 17.9 -62.8333 6 0 6 0 Saint Barthelemy, France
3007 3007     Saint Helena, Ascension and Tristan da Cunha United Kingdom 2020-05-06 02:32:31 -7.9467 -14.3559 0 0 0 0 Saint Helena, Ascension and Tristan da Cunha, United Kingdom
3008 3008     Saint Pierre and Miquelon France 2020-05-06 02:32:31 46.8852 -56.3159 1 0 0 1 Saint Pierre and Miquelon, France
3009 3009     Saskatchewan Canada 2020-05-06 02:32:31 52.9399 -106.4509 487 7 0 480 Saskatchewan, Canada
3010 3010     Shaanxi China 2020-05-06 02:32:31 35.1917 108.8701 308 3 264 41 Shaanxi, China
3011 3011     Shandong China 2020-05-06 02:32:31 36.3427 118.1498 788 7 775 6 Shandong, China
3012 3012     Shanghai China 2020-05-06 02:32:31 31.202 121.4491 656 7 620 29 Shanghai, China
3013 3013     Shanxi China 2020-05-06 02:32:31 37.5777 112.2922 198 0 193 5 Shanxi, China
3014 3014     Sichuan China 2020-05-06 02:32:31 30.6171 102.7103 561 3 558 0 Sichuan, China
3015 3015     Sint Maarten Netherlands 2020-05-06 02:32:31 18.0425 -63.0548 76 14 44 18 Sint Maarten, Netherlands
3016 3016     South Australia Australia 2020-05-06 02:32:31 -34.9285 138.6007 438 4 429 5 South Australia, Australia
3017 3017     St Martin France 2020-05-06 02:32:31 18.0708 -63.0501 38 3 29 6 St Martin, France
3018 3018     Tasmania Australia 2020-05-06 02:32:31 -42.8821 147.3272 225 13 165 47 Tasmania, Australia
3019 3019     Tianjin China 2020-05-06 02:32:31 39.3054 117.323 190 3 186 1 Tianjin, China
3020 3020     Tibet China 2020-05-06 02:32:31 31.6927 88.0924 1 0 1 0 Tibet, China
3021 3021     Turks and Caicos Islands United Kingdom 2020-05-06 02:32:31 21.69400000000001 -71.7979 12 1 6 5 Turks and Caicos Islands, United Kingdom
3022 3022     Victoria Australia 2020-05-06 02:32:31 -37.8136 144.9631 1440 18 1321 101 Victoria, Australia
3024 3024     Western Australia Australia 2020-05-06 02:32:31 -31.9505 115.8605 551 9 528 14 Western Australia, Australia
3025 3025     Xinjiang China 2020-05-06 02:32:31 41.1129 85.2401 76 3 73 0 Xinjiang, China
3026 3026     Yukon Canada 2020-05-06 02:32:31 64.2823 -135.0 11 0 0 11 Yukon, Canada
3027 3027     Yunnan China 2020-05-06 02:32:31 24.974 101.487 185 2 181 2 Yunnan, China
3028 3028     Zhejiang China 2020-05-06 02:32:31 29.1832 120.0934 1268 1 1267 0 Zhejiang, China
3029 3029       Afghanistan 2020-05-06 02:32:31 33.93911 67.709953 3225 95 421 2708 Afghanistan
3030 3030       Albania 2020-05-06 02:32:31 41.1533 20.1683 820 31 570 219 Albania
3031 3031       Algeria 2020-05-06 02:32:31 28.0339 1.6596 4838 470 2067 2301 Algeria
3032 3032       Andorra 2020-05-06 02:32:31 42.5063 1.5218 751 46 514 191 Andorra
3033 3033       Angola 2020-05-06 02:32:31 -11.2027 17.8739 36 2 11 23 Angola
3034 3034       Antigua and Barbuda 2020-05-06 02:32:31 17.0608 -61.7964 25 3 16 6 Antigua and Barbuda

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

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