03-26-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,424 rows sorted by Lat

✎ View and edit SQL

This data as json, copyable, CSV (advanced)

Link rowid FIPS Admin2 Province_State Country_Region Last_Update Lat ▼ Long_ Confirmed Deaths Recovered Active Combined_Key
3295 3295       Djibouti 2020-03-26 23:48:18 11.8251 42.5903 11 0 0 11 Djibouti
3315 3315       Grenada 2020-03-26 23:48:18 12.1165 -61.678999999999995 7 0 0 7 Grenada
3178 3178     Curacao Netherlands 2020-03-26 23:48:18 12.1696 -68.99 6 1 2 3 Curacao, Netherlands
3277 3277       Burkina Faso 2020-03-26 23:48:18 12.2383 -1.5616 152 7 10 135 Burkina Faso
3170 3170     Aruba Netherlands 2020-03-26 23:48:18 12.5211 -69.9683 28 0 1 27 Aruba, Netherlands
3401 3401       Sudan 2020-03-26 23:48:18 12.8628 30.2176 3 1 0 2 Sudan
3367 3367       Nicaragua 2020-03-26 23:48:18 12.865416 -85.207229 2 0 0 2 Nicaragua
3378 3378       Philippines 2020-03-26 23:48:18 12.879721 121.77401699999999 707 45 28 634 Philippines
3387 3387       Saint Vincent and the Grenadines 2020-03-26 23:48:18 12.9843 -61.2872 1 0 0 1 Saint Vincent and the Grenadines
3266 3266       Barbados 2020-03-26 23:48:18 13.1939 -59.5432 18 0 0 18 Barbados
3310 3310       Gambia 2020-03-26 23:48:18 13.4432 -15.3101 3 1 0 2 Gambia
3191 3191 66000   Guam US 2020-03-26 23:48:35 13.4443 144.7937 45 1 0 0 Guam, US
3300 3300       El Salvador 2020-03-26 23:48:18 13.7942 -88.8965 13 0 0 13 El Salvador
3386 3386       Saint Lucia 2020-03-26 23:48:18 13.9094 -60.9789 3 0 0 3 Saint Lucia
3421 3421       Vietnam 2020-03-26 23:48:18 14.058323999999999 108.277199 153 0 20 133 Vietnam
3391 3391       Senegal 2020-03-26 23:48:18 14.4974 -14.4524 105 0 9 96 Senegal
3210 3210     Martinique France 2020-03-26 23:48:18 14.6415 -61.0242 66 1 0 65 Martinique, France
3218 3218 69000   Northern Mariana Islands US 2020-03-26 23:48:35 15.0979 145.6739 0 0 0 0 Northern Mariana Islands, US
3302 3302       Eritrea 2020-03-26 23:48:18 15.1794 39.7823 6 0 0 6 Eritrea
3322 3322       Honduras 2020-03-26 23:48:18 15.2 -86.2419 52 1 0 51 Honduras
3296 3296       Dominica 2020-03-26 23:48:18 15.415 -61.371 11 0 0 11 Dominica
3282 3282       Chad 2020-03-26 23:48:18 15.4542 18.7322 3 0 0 3 Chad
3316 3316       Guatemala 2020-03-26 23:48:18 15.7835 -90.2308 25 1 4 20 Guatemala
3408 3408       Thailand 2020-03-26 23:48:18 15.870032 100.992541 1045 4 88 953 Thailand
3190 3190     Guadeloupe France 2020-03-26 23:48:18 16.265 -61.551 73 1 0 72 Guadeloupe, France
3278 3278       Cabo Verde 2020-03-26 23:48:18 16.5388 -23.0418 4 1 0 3 Cabo Verde
3212 3212     Montserrat United Kingdom 2020-03-26 23:48:18 16.742498 -62.187366000000004 5 0 0 5 Montserrat, United Kingdom
3258 3258       Antigua and Barbuda 2020-03-26 23:48:18 17.0608 -61.7964 7 0 0 7 Antigua and Barbuda
3269 3269       Belize 2020-03-26 23:48:18 17.1899 -88.4976 2 0 0 2 ,,Belize
3385 3385       Saint Kitts and Nevis 2020-03-26 23:48:18 17.357822 -62.782998 2 0 0 2 Saint Kitts and Nevis
3352 3352       Mali 2020-03-26 23:48:18 17.570692 -3.996166000000001 4 0 0 4 Mali
3368 3368       Niger 2020-03-26 23:48:18 17.607789 8.081666 10 1 0 9 Niger
3232 3232     Saint Barthelemy France 2020-03-26 23:48:18 17.9 -62.8333 3 0 0 3 Saint Barthelemy, France
3240 3240     Sint Maarten Netherlands 2020-03-26 23:48:18 18.0425 -63.0548 3 0 0 3 Sint Maarten, Netherlands
3242 3242     St Martin France 2020-03-26 23:48:18 18.0708 -63.0501 11 0 0 11 St Martin, France
3332 3332       Jamaica 2020-03-26 23:48:18 18.1096 -77.2975 26 1 2 23 Jamaica
3225 3225     Puerto Rico US 2020-03-26 23:48:35 18.2208 -66.5901 64 2 0 0 Puerto Rico, US
3247 3247 78000   Virgin Islands US 2020-03-26 23:48:35 18.3358 -64.8963 17 0 0 0 Virgin Islands, US
3297 3297       Dominican Republic 2020-03-26 23:48:18 18.7357 -70.1627 488 10 3 475 Dominican Republic
3320 3320       Haiti 2020-03-26 23:48:18 18.9712 -72.2852 8 0 0 8 Haiti
3195 3195     Hainan China 2020-03-24 04:29:15 19.1959 109.7453 168 6 162 0 Hainan, China
3175 3175     Cayman Islands United Kingdom 2020-03-26 23:48:18 19.3133 -81.2546 8 1 0 7 Cayman Islands, United Kingdom
1230 1230 15001 Hawaii Hawaii US 2020-03-26 23:48:35 19.60121157 -155.5210167 4 0 0 0 Hawaii, Hawaii, US
3341 3341       Laos 2020-03-26 23:48:18 19.856270000000002 102.495496 6 0 0 6 Laos
3325 3325       India 2020-03-26 23:48:18 20.593684 78.96288 727 20 45 662 India
1842 1842 15009 Maui Hawaii US 2020-03-26 23:48:35 20.86399628 -156.56890969999995 13 0 0 0 Maui, Hawaii, US
3354 3354       Mauritania 2020-03-26 23:48:18 21.0079 -10.9408 3 0 0 3 ,,Mauritania
1465 1465 15005 Kalawao Hawaii US 2020-03-26 23:48:35 21.17882515 -156.9583592 0 0 0 0 Kalawao, Hawaii, US
1287 1287 15003 Honolulu Hawaii US 2020-03-26 23:48:35 21.45803166 -157.97121819999995 68 0 0 0 Honolulu, Hawaii, US
3372 3372       Oman 2020-03-26 23:48:18 21.512583 55.92325500000001 109 0 23 86 Oman
3290 3290       Cuba 2020-03-26 23:48:18 21.521757 -77.78116700000002 67 2 1 64 Cuba
1475 1475 15007 Kauai Hawaii US 2020-03-26 23:48:35 22.03935037 -159.5966786 2 0 0 0 Kauai, Hawaii, US
3208 3208     Macau China 2020-03-26 03:08:32 22.1667 113.55 31 0 10 21 Macau, China
3199 3199     Hong Kong China 2020-03-26 10:05:28 22.3 114.2 453 4 110 339 Hong Kong, China
3192 3192     Guangdong China 2020-03-26 09:11:30 23.3417 113.4244 1448 8 1336 104 Guangdong, China
3416 3416       United Arab Emirates 2020-03-26 23:48:18 23.424076 53.847818000000004 333 2 52 279 United Arab Emirates
3356 3356       Mexico 2020-03-26 23:48:18 23.6345 -102.5528 475 6 4 465 Mexico
3265 3265       Bangladesh 2020-03-26 23:48:18 23.685 90.3563 44 5 11 28 Bangladesh
3406 3406       Taiwan* 2020-03-26 07:31:30 23.7 121.0 252 2 29 221 Taiwan*
3193 3193     Guangxi China 2020-03-20 04:33:45 23.8298 108.7881 254 2 250 2 Guangxi, China
3390 3390       Saudi Arabia 2020-03-26 23:48:18 23.885942 45.079162 1012 3 33 976 Saudi Arabia
3251 3251     Yunnan China 2020-03-25 23:30:18 24.974 101.48700000000001 178 2 172 4 Yunnan, China
3263 3263       Bahamas 2020-03-26 23:48:18 25.025885 -78.035889 9 0 1 8 Bahamas
1959 1959 12087 Monroe Florida US 2020-03-26 23:48:35 25.20904673 -81.07812416 12 0 0 0 Monroe, Florida, US
3381 3381       Qatar 2020-03-26 23:48:18 25.3548 51.1839 549 0 43 506 Qatar
1914 1914 12086 Miami-Dade Florida US 2020-03-26 23:48:35 25.6112362 -80.55170587 616 0 0 0 Miami-Dade, Florida, US
3264 3264       Bahrain 2020-03-26 23:48:18 26.0275 50.55 458 4 204 250 Bahrain
3184 3184     Fujian China 2020-03-26 01:21:08 26.0789 117.9874 328 1 295 32 Fujian, China
600 600 12021 Collier Florida US 2020-03-26 23:48:35 26.11091986 -81.34687065 65 0 0 0 Collier, Florida, US
372 372 48061 Cameron Texas US 2020-03-26 23:48:35 26.14524221 -97.48140372 10 0 0 0 Cameron, Texas, US
284 284 12011 Broward Florida US 2020-03-26 23:48:35 26.15184651 -80.48725556 504 3 0 0 Broward, Florida, US
3345 3345       Libya 2020-03-26 23:48:18 26.3351 17.228331 1 0 0 1 Libya
1266 1266 48215 Hidalgo Texas US 2020-03-26 23:48:35 26.39418217 -98.18299696 9 0 0 0 Hidalgo, Texas, US
3084 3084 48489 Willacy Texas US 2020-03-26 23:48:35 26.47411727 -97.61535848 0 0 0 0 Willacy, Texas, US
1245 1245 12051 Hendry Florida US 2020-03-26 23:48:35 26.55386945 -81.16469006 0 0 0 0 Hendry, Florida, US
2690 2690 48427 Starr Texas US 2020-03-26 23:48:35 26.56150059 -98.73892358 1 0 0 0 Starr, Texas, US
1626 1626 12071 Lee Florida US 2020-03-26 23:48:35 26.58410348 -81.88399313 56 3 0 0 Lee, Florida, US
2193 2193 12099 Palm Beach Florida US 2020-03-26 23:48:35 26.64676272 -80.46536002 169 3 0 0 Palm Beach, Florida, US
3194 3194     Guizhou China 2020-03-18 01:37:43 26.8154 106.8748 146 2 144 0 Guizhou, China
3299 3299       Egypt 2020-03-26 23:48:18 26.820553000000004 30.802497999999996 495 24 102 369 Egypt
454 454 12015 Charlotte Florida US 2020-03-26 23:48:35 26.90131002 -81.92949121 3 0 0 0 Charlotte, Florida, US
1485 1485 48261 Kenedy Texas US 2020-03-26 23:48:35 26.92601662 -97.66413984 0 0 0 0 Kenedy, Texas, US
1048 1048 12043 Glades Florida US 2020-03-26 23:48:35 26.95635849 -81.18996211 0 0 0 0 Glades, Florida, US
3164 3164 48505 Zapata Texas US 2020-03-26 23:48:35 27.00156391 -99.16987152 0 0 0 0 Zapata, Texas, US
281 281 48047 Brooks Texas US 2020-03-26 23:48:35 27.03103197 -98.21808402 0 0 0 0 Brooks, Texas, US
1435 1435 48247 Jim Hogg Texas US 2020-03-26 23:48:35 27.04453923 -98.69681870000001 0 0 0 0 Jim Hogg, Texas, US
1825 1825 12085 Martin Florida US 2020-03-26 23:48:35 27.0772071 -80.43109784 8 0 0 0 Martin, Florida, US
2535 2535 12115 Sarasota Florida US 2020-03-26 23:48:35 27.18546175 -82.33174248 34 1 0 0 Sarasota, Florida, US
745 745 12027 DeSoto Florida US 2020-03-26 23:48:35 27.18677893 -81.80941373 5 0 0 0 DeSoto,Florida,US
1269 1269 12055 Highlands Florida US 2020-03-26 23:48:35 27.34254618 -81.34071957 5 0 0 0 Highlands, Florida, US
2674 2674 12111 St. Lucie Florida US 2020-03-26 23:48:35 27.37763908 -80.47106649 10 0 0 0 St. Lucie, Florida, US
2127 2127 12093 Okeechobee Florida US 2020-03-26 23:48:35 27.386336199999995 -80.88944347 0 0 0 0 Okeechobee, Florida, US
1524 1524 48273 Kleberg Texas US 2020-03-26 23:48:35 27.42435506 -97.69894948 0 0 0 0 Kleberg, Texas, US
1783 1783 12081 Manatee Florida US 2020-03-26 23:48:35 27.47196942 -82.31831044 26 1 0 0 Manatee, Florida, US
1191 1191 12049 Hardee Florida US 2020-03-26 23:48:35 27.49293939 -81.80956574 0 0 0 0 Hardee, Florida, US
3271 3271       Bhutan 2020-03-26 23:48:18 27.5142 90.4336 2 0 0 2 Bhutan
3201 3201     Hunan China 2020-03-14 08:25:05 27.6104 111.7088 1018 4 1014 0 Hunan, China
3205 3205     Jiangxi China 2020-03-23 01:27:01 27.614 115.7221 936 1 934 1 Jiangxi, China
835 835 48131 Duval Texas US 2020-03-26 23:48:35 27.68184592 -98.50864568 0 0 0 0 Duval, Texas, US
1339 1339 12061 Indian River Florida US 2020-03-26 23:48:35 27.69308961 -80.60556721 13 0 0 0 Indian River, Florida, US

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

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