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,437 rows sorted by Admin2

View and edit SQL

Link rowid FIPS Admin2 ▼ Province_State Country_Region Last_Update Lat Long_ Confirmed Deaths Recovered Active Combined_Key
3175     Alberta Canada 3/29/20 23:13 53.9333 -116.5765 621 2 0 0 Alberta, Canada
3176 60000   American Samoa US 3/29/20 23:08 -14.271 -170.132 0 0 0 0 American Samoa, US
3177     Anguilla United Kingdom 3/29/20 23:08 18.2206 -63.0686 2 0 0 2 Anguilla, United Kingdom
3178     Anhui China 3/8/20 5:19 31.8257 117.2264 990 6 984 0 Anhui, China
3179     Aruba Netherlands 3/29/20 23:08 12.5211 -69.9683 50 0 1 49 Aruba, Netherlands
3180     Australian Capital Territory Australia 3/29/20 23:14 -35.4735 149.0124 77 0 2 75 Australian Capital Territory, Australia
3181     Beijing China 3/29/20 14:07 40.1824 116.4142 577 8 412 157 Beijing, China
3182     Bermuda United Kingdom 3/29/20 23:08 32.3078 -64.7505 22 0 2 20 Bermuda, United Kingdom
3183     British Columbia Canada 3/29/20 23:13 53.7267 -127.6476 884 17 0 0 British Columbia, Canada
3184     British Virgin Islands United Kingdom 3/29/20 23:08 18.4207 -64.64 2 0 0 2 British Virgin Islands, United Kingdom
3185     Cayman Islands United Kingdom 3/29/20 23:08 19.3133 -81.2546 8 1 0 7 Cayman Islands, United Kingdom
3186     Channel Islands United Kingdom 3/29/20 23:08 49.3723 -2.3644 108 2 0 106 Channel Islands, United Kingdom
3187     Chongqing China 3/29/20 0:14 30.0572 107.874 579 6 570 3 Chongqing, China
3188     Curacao Netherlands 3/29/20 23:08 12.1696 -68.99 8 1 2 5 Curacao, Netherlands
3189     Diamond Princess Canada 3/29/20 23:13 0.0 0.0 0 1 0 0 Diamond Princess, Canada
3190 88888   Diamond Princess US 3/29/20 23:08 0.0 0.0 49 0 0 0 Diamond Princess, US
3191     Faroe Islands Denmark 3/29/20 23:08 61.8926 -6.9118 159 0 70 89 Faroe Islands, Denmark
3192     French Guiana France 3/29/20 23:08 4.0 -53.0 28 0 6 22 French Guiana, France
3193     French Polynesia France 3/29/20 23:08 -17.6797 149.4068 30 0 0 30 French Polynesia, France
3194     Fujian China 3/29/20 0:57 26.0789 117.9874 338 1 295 42 Fujian, China
3195     Gansu China 3/29/20 14:25 37.8099 101.0583 138 2 125 11 Gansu, China
3196     Gibraltar United Kingdom 3/29/20 23:08 36.1408 -5.3536 65 0 14 51 Gibraltar, United Kingdom
3197     Grand Princess Canada 3/29/20 23:13 0.0 0.0 13 0 0 0 Grand Princess, Canada
3198 99999   Grand Princess US 3/29/20 23:08 0.0 0.0 103 3 0 0 Grand Princess, US
3199     Greenland Denmark 3/29/20 23:08 71.7069 -42.6043 10 0 2 8 Greenland, Denmark
3200     Guadeloupe France 3/29/20 23:08 16.265 -61.551 106 4 17 85 Guadeloupe, France
3201 66000   Guam US 3/29/20 23:08 13.4443 144.7937 56 1 0 0 Guam, US
3202     Guangdong China 3/29/20 2:09 23.3417 113.4244 1475 8 1349 118 Guangdong, China
3203     Guangxi China 3/20/20 4:33 23.8298 108.7881 254 2 250 2 Guangxi, China
3204     Guizhou China 3/18/20 1:37 26.8154 106.8748 146 2 144 0 Guizhou, China
3205     Hainan China 3/24/20 4:29 19.1959 109.7453 168 6 162 0 Hainan, China
3206     Hebei China 3/23/20 1:53 39.549 116.1306 319 6 310 3 Hebei, China
3207     Heilongjiang China 3/26/20 0:15 47.862 127.7615 484 13 469 2 Heilongjiang, China
3208     Henan China 3/29/20 1:44 33.882 113.614 1276 22 1251 3 Henan, China
3209     Hong Kong China 3/29/20 9:40 22.3 114.2 641 4 112 525 Hong Kong, China
3210     Hubei China 3/29/20 14:07 30.9756 112.2707 67801 3182 62570 2049 Hubei, China
3211     Hunan China 3/14/20 8:25 27.6104 111.7088 1018 4 1014 0 Hunan, China
3212     Inner Mongolia China 3/29/20 0:51 44.0935 113.9448 95 1 74 20 Inner Mongolia, China
3213     Isle of Man United Kingdom 3/29/20 23:08 54.2361 -4.5481 42 0 0 42 Isle of Man, United Kingdom
3214     Jiangsu China 3/29/20 2:00 32.9711 119.455 644 0 631 13 Jiangsu, China
3215     Jiangxi China 3/29/20 1:57 27.614 115.7221 937 1 934 2 Jiangxi, China
3216     Jilin China 3/29/20 0:28 43.6661 126.1923 98 1 92 5 Jilin, China
3217     Liaoning China 3/29/20 4:59 41.2956 122.6085 134 2 124 8 Liaoning, China
3218     Macau China 3/28/20 15:17 22.1667 113.55 37 0 10 27 Macau, China
3219     Manitoba Canada 3/29/20 23:13 53.7609 -98.8139 72 1 0 0 Manitoba, Canada
3220     Martinique France 3/29/20 23:08 14.6415 -61.0242 93 1 0 92 Martinique, France
3221     Mayotte France 3/29/20 23:08 -12.8275 45.166244 63 0 0 63 Mayotte, France
3222     Montserrat United Kingdom 3/29/20 23:08 16.742498 -62.187366 5 0 0 5 Montserrat, United Kingdom
3223     New Brunswick Canada 3/29/20 23:13 46.5653 -66.4619 66 0 0 0 New Brunswick, Canada
3224     New Caledonia France 3/29/20 23:08 -20.904305 165.618042 15 0 0 15 New Caledonia, France
3225     New South Wales Australia 3/29/20 23:14 -33.8688 151.2093 1791 8 4 1779 New South Wales, Australia
3226     Newfoundland and Labrador Canada 3/29/20 23:13 53.1355 -57.6604 135 0 0 0 Newfoundland and Labrador, Canada
3227     Ningxia China 3/16/20 8:47 37.2692 106.1655 75 0 75 0 Ningxia, China
3228 69000   Northern Mariana Islands US 3/29/20 23:08 15.0979 145.6739 0 0 0 0 Northern Mariana Islands, US
3229     Northern Territory Australia 3/29/20 23:14 -12.4634 130.8456 15 0 0 15 Northern Territory, Australia
3230     Northwest Territories Canada 3/29/20 23:13 64.8255 -124.8457 1 0 0 0 ,Northwest Territories,Canada
3231     Nova Scotia Canada 3/29/20 23:13 44.682 -63.7443 122 0 0 0 Nova Scotia, Canada
3232     Nunavut Canada 3/29/20 23:13 70.2998 -83.1076 0 0 0 0 Nunavut, Canada
3233     Ontario Canada 3/29/20 23:13 51.2538 -85.3232 1355 21 0 0 Ontario, Canada
3234     Prince Edward Island Canada 3/29/20 23:13 46.5107 -63.4168 11 0 0 0 Prince Edward Island, Canada
3235     Puerto Rico US 3/29/20 23:08 18.2208 -66.5901 127 3 0 0 Puerto Rico, US
3236     Qinghai China 2/23/20 11:19 35.7452 95.9956 18 0 18 0 Qinghai, China
3237     Quebec Canada 3/29/20 23:13 52.9399 -73.5491 2840 54 0 0 Quebec, Canada
3238     Queensland Australia 3/29/20 23:14 -27.4698 153.0251 656 2 8 646 Queensland, Australia
3239     Recovered Canada 3/29/20 23:13 0.0 0.0 0 0 466 0 Recovered, Canada
3240     Recovered US 3/29/20 23:08 0.0 0.0 0 0 2665 0 Recovered, US
3241     Reunion France 3/29/20 23:08 -21.1151 55.5364 183 0 1 182 Reunion, France
3242     Saint Barthelemy France 3/29/20 23:08 17.9 -62.8333 5 0 0 5 Saint Barthelemy, France
3243     Saint Helena, Ascension and Tristan da Cunha United Kingdom 3/29/20 23:08 -7.9467 -14.3559 0 0 0 0 Saint Helena, Ascension and Tristan da Cunha, United Kingdom
3244     Saskatchewan Canada 3/29/20 23:13 52.9399 -106.4509 156 0 0 0 Saskatchewan, Canada
3245     Shaanxi China 3/26/20 2:14 35.1917 108.8701 253 3 242 8 Shaanxi, China
3246     Shandong China 3/27/20 7:48 36.3427 118.1498 772 7 752 13 Shandong, China
3247     Shanghai China 3/29/20 2:09 31.202 121.4491 492 5 334 153 Shanghai, China
3248     Shanxi China 3/29/20 0:20 37.5777 112.2922 136 0 133 3 Shanxi, China
3249     Sichuan China 3/29/20 1:49 30.6171 102.7103 550 3 536 11 Sichuan, China
3250     Sint Maarten Netherlands 3/29/20 23:08 18.0425 -63.0548 6 0 0 6 Sint Maarten, Netherlands
3251     South Australia Australia 3/29/20 23:14 -34.9285 138.6007 299 0 6 293 South Australia, Australia
3252     St Martin France 3/29/20 23:08 18.0708 -63.0501 11 0 0 11 St Martin, France
3253     Tasmania Australia 3/29/20 23:14 -42.8821 147.3272 66 0 5 61 Tasmania, Australia
3254     Tianjin China 3/29/20 6:13 39.3054 117.323 166 3 133 30 Tianjin, China
3255     Tibet China 2/23/20 11:19 31.6927 88.0924 1 0 1 0 Tibet, China
3256     Turks and Caicos Islands United Kingdom 3/29/20 23:08 21.694 -71.7979 4 0 0 4 Turks and Caicos Islands, United Kingdom
3257     Victoria Australia 3/29/20 23:14 -37.8136 144.9631 769 4 191 574 Victoria, Australia
3258 78000   Virgin Islands US 3/29/20 23:08 18.3358 -64.8963 23 0 0 0 Virgin Islands, US
3259     Western Australia Australia 3/29/20 23:14 -31.9505 115.8605 311 2 28 281 Western Australia, Australia
3260     Xinjiang China 3/8/20 5:31 41.1129 85.2401 76 3 73 0 Xinjiang, China
3261     Yukon Canada 3/29/20 23:13 64.2823 -135.0 4 0 0 0 ,Yukon,Canada
3262     Yunnan China 3/26/20 23:16 24.974 101.487 180 2 172 6 Yunnan, China
3263     Zhejiang China 3/29/20 2:22 29.1832 120.0934 1254 1 1225 28 Zhejiang, China
3264       Afghanistan 3/29/20 23:08 33.93911 67.709953 118 4 2 114 Afghanistan
3265       Albania 3/29/20 23:08 41.1533 20.1683 212 10 33 169 Albania
3266       Algeria 3/29/20 23:08 28.0339 1.6596 511 31 31 449 Algeria
3267       Andorra 3/29/20 23:08 42.5063 1.5218 334 6 1 327 Andorra
3268       Angola 3/29/20 23:08 -11.2027 17.8739 7 2 0 5 Angola
3269       Antigua and Barbuda 3/29/20 23:08 17.0608 -61.7964 7 0 0 7 Antigua and Barbuda
3270       Argentina 3/29/20 23:08 -38.4161 -63.6167 745 19 72 654 Argentina
3271       Armenia 3/29/20 23:08 40.0691 45.0382 424 3 30 391 Armenia
3272       Austria 3/29/20 23:08 47.5162 14.5501 8788 86 479 8223 Austria
3273       Azerbaijan 3/29/20 23:08 40.1431 47.5769 209 4 15 190 Azerbaijan
3274       Bahamas 3/29/20 23:08 25.025885 -78.035889 11 0 1 10 Bahamas

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

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