03-22-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,420 rows sorted by Country_Region

✎ View and edit SQL

This data as json, copyable, CSV (advanced)

Suggested facets: Last_Update

Link rowid FIPS Admin2 Province_State Country_Region ▼ Last_Update Lat Long_ Confirmed Deaths Recovered Active Combined_Key
3331 3331       Afghanistan 3/22/20 23:45 33.93911 67.709953 34 1 1 38 Afghanistan
3313 3313       Albania 3/22/20 23:45 41.1533 20.1683 89 2 2 85 Albania
3290 3290       Algeria 3/22/20 23:45 28.0339 1.6596 201 17 65 119 Algeria
3306 3306       Andorra 3/22/20 23:45 42.5063 1.5218 113 1 1 111 Andorra
3389 3389       Angola 3/22/20 23:45 -11.2027 17.8739 2 0 0 2 Angola
3401 3401       Antigua and Barbuda 3/22/20 23:45 17.0608 -61.7964 1 0 0 1 Antigua and Barbuda
3282 3282       Argentina 3/22/20 23:45 -38.4161 -63.6167 266 4 27 235 Argentina
3291 3291       Armenia 3/22/20 23:45 40.0691 45.0382 194 0 2 192 Armenia
3191 3191     New South Wales Australia 3/22/20 23:48 -33.8688 151.2093 669 6 4 659 New South Wales, Australia
3192 3192     Victoria Australia 3/22/20 23:48 -37.8136 144.9631 296 0 70 226 Victoria, Australia
3193 3193     Queensland Australia 3/22/20 23:48 -27.4698 153.0251 259 0 8 251 Queensland, Australia
3194 3194     Western Australia Australia 3/22/20 23:48 -31.9505 115.8605 120 1 1 118 Western Australia, Australia
3195 3195     South Australia Australia 3/22/20 23:48 -34.9285 138.6007 100 0 6 94 South Australia, Australia
3196 3196     Tasmania Australia 3/22/20 23:48 -42.8821 147.3272 22 0 3 19 Tasmania, Australia
3197 3197     Australian Capital Territory Australia 3/22/20 23:48 -35.4735 149.0124 19 0 0 19 Australian Capital Territory, Australia
3198 3198     Northern Territory Australia 3/22/20 23:48 -12.4634 130.8456 5 0 0 5 Northern Territory, Australia
3199 3199     External territories Australia 3/22/20 23:48     0 0 0 0 External territories, Australia
3200 3200     Jervis Bay Territory Australia 3/22/20 23:48     0 0 0 0 Jervis Bay Territory, Australia
3244 3244       Austria 3/22/20 23:45 47.5162 14.5501 3580 16 9 3555 Austria
3323 3323       Azerbaijan 3/22/20 23:45 40.1431 47.5769 65 1 11 53 Azerbaijan
3371 3371       Bahamas 3/22/20 23:45 25.025885 -78.035889 4 0 0 4 Bahamas
3277 3277       Bahrain 3/22/20 23:45 26.0275 50.55 334 2 149 183 Bahrain
3340 3340       Bangladesh 3/22/20 23:45 23.685 90.3563 27 2 3 22 Bangladesh
3356 3356       Barbados 3/22/20 23:45 13.1939 -59.5432 14 0 0 14 Barbados
3317 3317       Belarus 3/22/20 23:45 53.7098 27.9534 76 0 15 61 Belarus
3245 3245       Belgium 3/22/20 23:45 50.8333 4.469936 3401 75 263 3063 Belgium
3390 3390       Benin 3/22/20 23:45 9.3077 2.3158 2 0 0 2 Benin
3392 3392       Bhutan 3/22/20 23:45 27.5142 90.4336 2 0 0 2 Bhutan
3342 3342       Bolivia 3/22/20 23:45 -16.2902 -63.5887 24 0 0 24 Bolivia
3302 3302       Bosnia and Herzegovina 3/22/20 23:45 43.9159 17.6791 126 1 2 123 Bosnia and Herzegovina
3249 3249       Brazil 3/22/20 23:45 -14.235 -51.9253 1546 25 2 1519 Brazil
3314 3314       Brunei 3/22/20 23:45 4.5353 114.7277 88 0 2 86 Brunei
3293 3293       Bulgaria 3/22/20 23:45 42.7339 25.4858 187 3 3 181 Bulgaria
3318 3318       Burkina Faso 3/22/20 23:45 12.2383 -1.5616 75 4 5 66 Burkina Faso
3377 3377       Cabo Verde 3/22/20 23:45 16.5388 -23.0418 3 0 0 3 Cabo Verde
3315 3315       Cambodia 3/22/20 23:45 11.55 104.9167 84 0 2 82 Cambodia
3332 3332       Cameroon 3/22/20 23:45 3.848 11.5021 40 0 2 38 Cameroon
3177 3177     Ontario Canada 3/22/20 23:48 51.2538 -85.3232 425 5 0 0 Ontario, Canada
3178 3178     British Columbia Canada 3/22/20 23:48 53.7267 -127.6476 424 10 0 0 British Columbia, Canada
3179 3179     Alberta Canada 3/22/20 23:48 53.9333 -116.5765 259 1 0 0 Alberta, Canada
3180 3180     Quebec Canada 3/22/20 23:48 52.9399 -73.5491 219 5 0 0 Quebec, Canada
3181 3181     Saskatchewan Canada 3/22/20 23:48 52.9399 -106.4509 52 0 0 0 Saskatchewan, Canada
3182 3182     Nova Scotia Canada 3/22/20 23:48 44.682 -63.7443 28 0 0 0 Nova Scotia, Canada
3183 3183     Nunavut Canada 3/22/20 23:48 70.2998 -83.1076 0 0 0 0 Nunavut, Canada
3184 3184     Manitoba Canada 3/22/20 23:48 53.7609 -98.8139 20 0 0 0 Manitoba, Canada
3185 3185     New Brunswick Canada 3/22/20 23:48 46.5653 -66.4619 17 0 0 0 New Brunswick, Canada
3186 3186     Grand Princess Canada 3/22/20 23:48 0.0 0.0 13 0 0 0 Grand Princess, Canada
3187 3187     Newfoundland and Labrador Canada 3/22/20 23:48 53.1355 -57.6604 9 0 0 0 Newfoundland and Labrador, Canada
3188 3188     Prince Edward Island Canada 3/22/20 23:48 46.5107 -63.4168 3 0 0 0 Prince Edward Island, Canada
3189 3189     Northwest Territories Canada 3/22/20 23:48     1 0 0 0 Northwest Territories, Canada
3190 3190     Diamond Princess Canada 3/22/20 23:48 0.0 0.0 0 1 0 0 Diamond Princess, Canada
3378 3378       Central African Republic 3/22/20 23:45 6.6111 20.9394 3 0 0 3 Central African Republic
3402 3402       Chad 3/22/20 23:45 15.4542 18.7322 1 0 0 1 Chad
3262 3262       Chile 3/22/20 23:45 -35.6751 -71.543 632 1 8 623 Chile
3201 3201     Macau China 3/22/20 14:23 22.1667 113.55 20 0 10 10 Macau, China
3202 3202     Gansu China 3/22/20 14:23 37.8099 101.0583 136 2 114 20 Gansu, China
3203 3203     Chongqing China 3/22/20 10:52 30.0572 107.874 577 6 570 1 Chongqing, China
3204 3204     Hubei China 3/22/20 9:33 30.9756 112.2707 67800 3144 59433 5223 Hubei, China
3205 3205     Hong Kong China 3/22/20 9:33 22.3 114.2 317 4 100 213 Hong Kong, China
3207 3207     Shandong China 3/22/20 8:10 36.3427 118.1498 766 7 750 9 Shandong, China
3208 3208     Beijing China 3/22/20 7:20 40.1824 116.4142 514 8 400 106 Beijing, China
3209 3209     Shanghai China 3/22/20 7:20 31.202 121.4491 394 4 328 62 Shanghai, China
3210 3210     Jiangxi China 3/22/20 7:20 27.614 115.7221 936 1 934 1 Jiangxi, China
3211 3211     Guangdong China 3/22/20 7:20 23.3417 113.4244 1407 8 1329 70 Guangdong, China
3212 3212     Sichuan China 3/22/20 7:20 30.6171 102.7103 543 3 536 4 Sichuan, China
3213 3213     Fujian China 3/22/20 7:20 26.0789 117.9874 307 1 295 11 Fujian, China
3214 3214     Hebei China 3/22/20 7:20 39.549 116.1306 319 6 310 3 Hebei, China
3215 3215     Heilongjiang China 3/22/20 7:20 47.862 127.7615 484 13 466 5 Heilongjiang, China
3216 3216     Liaoning China 3/22/20 7:20 41.2956 122.6085 126 2 124 0 Liaoning, China
3217 3217     Jiangsu China 3/22/20 7:20 32.9711 119.455 633 0 631 2 Jiangsu, China
3218 3218     Zhejiang China 3/22/20 7:20 29.1832 120.0934 1237 1 1219 17 Zhejiang, China
3219 3219     Shaanxi China 3/21/20 2:03 35.1917 108.8701 248 3 239 6 Shaanxi, China
3220 3220     Tianjin China 3/20/20 4:33 39.3054 117.323 137 3 133 1 Tianjin, China
3221 3221     Guangxi China 3/20/20 4:33 23.8298 108.7881 254 2 250 2 Guangxi, China
3222 3222     Inner Mongolia China 3/19/20 0:16 44.0935 113.9448 75 1 74 0 Inner Mongolia, China
3223 3223     Guizhou China 3/18/20 1:37 26.8154 106.8748 146 2 144 0 Guizhou, China
3224 3224     Yunnan China 3/16/20 23:37 24.974 101.487 176 2 172 2 Yunnan, China
3225 3225     Hainan China 3/16/20 13:49 19.1959 109.7453 168 6 161 1 Hainan, China
3226 3226     Ningxia China 3/16/20 8:47 37.2692 106.1655 75 0 75 0 Ningxia, China
3227 3227     Henan China 3/14/20 9:49 33.882 113.614 1273 22 1250 1 Henan, China
3228 3228     Hunan China 3/14/20 8:25 27.6104 111.7088 1018 4 1014 0 Hunan, China
3229 3229     Shanxi China 3/13/20 8:56 37.5777 112.2922 133 0 133 0 Shanxi, China
3230 3230     Jilin China 3/12/20 12:54 43.6661 126.1923 93 1 92 0 Jilin, China
3231 3231     Xinjiang China 3/8/20 5:31 41.1129 85.2401 76 3 73 0 Xinjiang, China
3232 3232     Anhui China 3/8/20 5:19 31.8257 117.2264 990 6 984 0 Anhui, China
3233 3233     Tibet China 2/23/20 11:19 31.6927 88.0924 1 0 1 0 Tibet, China
3234 3234     Qinghai China 2/23/20 11:19 35.7452 95.9956 18 0 18 0 Qinghai, China
3287 3287       Colombia 3/22/20 23:45 4.5709 -74.2973 231 2 3 226 Colombia
3379 3379       Congo (Brazzaville) 3/22/20 23:45 -4.2634 15.2832 3 0 0 3 Congo (Brazzaville)
3337 3337       Congo (Kinshasa) 3/22/20 23:45 -4.322447 15.307045 30 1 0 29 Congo (Kinshasa)
3299 3299       Costa Rica 3/22/20 23:45 9.7489 -83.7534 134 2 2 130 Costa Rica
3357 3357       Cote d'Ivoire 3/22/20 23:45 7.54 -5.5471 14 0 1 13 Cote d'Ivoire
3283 3283       Croatia 3/22/20 23:45 45.1 15.2 254 1 5 248 Croatia
3260 3260     Diamond Princess Cruise Ship 3/22/20 23:45 0.0 0.0 712 8 567 137 Diamond Princess, Cruise Ship
3335 3335       Cuba 3/22/20 23:45 21.521757 -77.781167 35 1 0 34 Cuba
3310 3310       Cyprus 3/22/20 23:45 35.1264 33.4299 95 1 3 91 Cyprus
3253 3253       Czechia 3/22/20 23:45 49.8175 15.473 1120 1 6 1113 Czechia
3250 3250       Denmark 3/22/20 23:45 56.2639 9.5018 1395 13 1 1381 Denmark
3305 3305     Faroe Islands Denmark 3/22/20 23:45 61.8926 -6.9118 115 0 3 112 Faroe Islands, Denmark
3372 3372     Greenland Denmark 3/22/20 23:45 71.7069 -42.6043 4 0 0 4 Greenland, Denmark

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

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