03-27-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,432 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
3313 3313       Ethiopia 2020-03-27 23:23:03 9.145 40.4897 16 0 0 16 Ethiopia
3277 3277       Benin 2020-03-27 23:23:03 9.3077 2.3158 6 0 0 6 Benin
3295 3295       Costa Rica 2020-03-27 23:23:03 9.7489 -83.7534 263 2 3 258 Costa Rica
3325 3325       Guinea 2020-03-27 23:23:03 9.9456 -9.6966 8 0 0 8 Guinea
3419 3419       Trinidad and Tobago 2020-03-27 23:23:03 10.6918 -61.2225 66 2 1 63 Trinidad and Tobago
3287 3287       Cambodia 2020-03-27 23:23:03 11.55 104.9167 99 0 11 88 Cambodia
3326 3326       Guinea-Bissau 2020-03-27 23:23:03 11.8037 -15.1804 2 0 0 2 Guinea-Bissau
3303 3303       Djibouti 2020-03-27 23:23:03 11.8251 42.5903 12 0 0 12 Djibouti
3323 3323       Grenada 2020-03-27 23:23:03 12.1165 -61.678999999999995 7 0 0 7 Grenada
3185 3185     Curacao Netherlands 2020-03-27 23:23:03 12.1696 -68.99 8 1 2 5 Curacao, Netherlands
3284 3284       Burkina Faso 2020-03-27 23:23:03 12.2383 -1.5616 180 9 12 159 Burkina Faso
3177 3177     Aruba Netherlands 2020-03-27 23:23:03 12.5211 -69.9683 33 0 1 32 Aruba, Netherlands
3409 3409       Sudan 2020-03-27 23:23:03 12.8628 30.2176 3 1 0 2 Sudan
3375 3375       Nicaragua 2020-03-27 23:23:03 12.865416 -85.207229 2 1 0 1 Nicaragua
3386 3386       Philippines 2020-03-27 23:23:03 12.879721 121.77401699999999 803 54 31 718 Philippines
3395 3395       Saint Vincent and the Grenadines 2020-03-27 23:23:03 12.9843 -61.2872 1 0 0 1 Saint Vincent and the Grenadines
3273 3273       Barbados 2020-03-27 23:23:03 13.1939 -59.5432 24 0 0 24 Barbados
3318 3318       Gambia 2020-03-27 23:23:03 13.4432 -15.3101 3 1 0 2 Gambia
3198 3198 66000   Guam US 2020-03-27 22:14:55 13.4443 144.7937 51 1 0 0 Guam, US
3308 3308       El Salvador 2020-03-27 23:23:03 13.7942 -88.8965 13 0 0 13 El Salvador
3394 3394       Saint Lucia 2020-03-27 23:23:03 13.9094 -60.9789 3 0 1 2 Saint Lucia
3429 3429       Vietnam 2020-03-27 23:23:03 14.058323999999999 108.277199 163 0 20 143 Vietnam
3399 3399       Senegal 2020-03-27 23:23:03 14.4974 -14.4524 119 0 11 108 Senegal
3217 3217     Martinique France 2020-03-27 23:23:03 14.6415 -61.0242 81 1 0 80 Martinique, France
3225 3225 69000   Northern Mariana Islands US 2020-03-27 22:14:55 15.0979 145.6739 0 0 0 0 Northern Mariana Islands, US
3310 3310       Eritrea 2020-03-27 23:23:03 15.1794 39.7823 6 0 0 6 Eritrea
3330 3330       Honduras 2020-03-27 23:23:03 15.2 -86.2419 68 1 0 67 Honduras
3304 3304       Dominica 2020-03-27 23:23:03 15.415 -61.371 11 0 0 11 Dominica
3290 3290       Chad 2020-03-27 23:23:03 15.4542 18.7322 3 0 0 3 Chad
3324 3324       Guatemala 2020-03-27 23:23:03 15.7835 -90.2308 28 1 4 23 Guatemala
3416 3416       Thailand 2020-03-27 23:23:03 15.870032 100.992541 1136 5 97 1034 Thailand
3197 3197     Guadeloupe France 2020-03-27 23:23:03 16.265 -61.551 73 1 0 72 Guadeloupe, France
3286 3286       Cabo Verde 2020-03-27 23:23:03 16.5388 -23.0418 5 1 0 4 Cabo Verde
3219 3219     Montserrat United Kingdom 2020-03-27 23:23:03 16.742498 -62.187366000000004 5 0 0 5 Montserrat, United Kingdom
3265 3265       Antigua and Barbuda 2020-03-27 23:23:03 17.0608 -61.7964 7 0 0 7 Antigua and Barbuda
3276 3276       Belize 2020-03-27 23:23:03 17.1899 -88.4976 2 0 0 2 ,,Belize
3393 3393       Saint Kitts and Nevis 2020-03-27 23:23:03 17.357822 -62.782998 2 0 0 2 Saint Kitts and Nevis
3360 3360       Mali 2020-03-27 23:23:03 17.570692 -3.996166000000001 11 0 0 11 Mali
3376 3376       Niger 2020-03-27 23:23:03 17.607789 8.081666 10 1 0 9 Niger
3239 3239     Saint Barthelemy France 2020-03-27 23:23:03 17.9 -62.8333 5 0 0 5 Saint Barthelemy, France
3247 3247     Sint Maarten Netherlands 2020-03-27 23:23:03 18.0425 -63.0548 3 0 0 3 Sint Maarten, Netherlands
3249 3249     St Martin France 2020-03-27 23:23:03 18.0708 -63.0501 11 0 0 11 St Martin, France
3340 3340       Jamaica 2020-03-27 23:23:03 18.1096 -77.2975 26 1 2 23 Jamaica
3232 3232     Puerto Rico US 2020-03-27 22:14:55 18.2208 -66.5901 79 3 0 0 Puerto Rico, US
3254 3254 78000   Virgin Islands US 2020-03-27 22:14:55 18.3358 -64.8963 19 0 0 0 Virgin Islands, US
3305 3305       Dominican Republic 2020-03-27 23:23:03 18.7357 -70.1627 581 20 3 558 Dominican Republic
3328 3328       Haiti 2020-03-27 23:23:03 18.9712 -72.2852 8 0 0 8 Haiti
3202 3202     Hainan China 2020-03-24 04:29:15 19.1959 109.7453 168 6 162 0 Hainan, China
3182 3182     Cayman Islands United Kingdom 2020-03-27 23:23:03 19.3133 -81.2546 8 1 0 7 Cayman Islands, United Kingdom
1230 1230 15001 Hawaii Hawaii US 2020-03-27 22:14:55 19.60121157 -155.5210167 5 0 0 0 Hawaii, Hawaii, US
3349 3349       Laos 2020-03-27 23:23:03 19.856270000000002 102.495496 6 0 0 6 Laos
3333 3333       India 2020-03-27 23:23:03 20.593684 78.96288 887 20 73 794 India
1842 1842 15009 Maui Hawaii US 2020-03-27 22:14:55 20.86399628 -156.56890969999995 14 0 0 0 Maui, Hawaii, US
3362 3362       Mauritania 2020-03-27 23:23:03 21.0079 -10.9408 3 0 0 3 ,,Mauritania
1465 1465 15005 Kalawao Hawaii US 2020-03-27 22:14:55 21.17882515 -156.9583592 0 0 0 0 Kalawao, Hawaii, US
1287 1287 15003 Honolulu Hawaii US 2020-03-27 22:14:55 21.45803166 -157.97121819999995 76 0 0 0 Honolulu, Hawaii, US
3380 3380       Oman 2020-03-27 23:23:03 21.512583 55.92325500000001 131 0 23 108 Oman
3298 3298       Cuba 2020-03-27 23:23:03 21.521757 -77.78116700000002 80 2 4 74 Cuba
3285 3285       Burma 2020-03-27 23:23:03 21.9162 95.956 8 0 0 8 Burma
1475 1475 15007 Kauai Hawaii US 2020-03-27 22:14:55 22.03935037 -159.5966786 5 0 0 0 Kauai, Hawaii, US
3215 3215     Macau China 2020-03-26 17:03:36 22.1667 113.55 33 0 10 23 Macau, China
3206 3206     Hong Kong China 2020-03-27 09:27:52 22.3 114.2 519 4 110 405 Hong Kong, China
3199 3199     Guangdong China 2020-03-27 04:09:46 23.3417 113.4244 1456 8 1337 111 Guangdong, China
3424 3424       United Arab Emirates 2020-03-27 23:23:03 23.424076 53.847818000000004 405 2 52 351 United Arab Emirates
3364 3364       Mexico 2020-03-27 23:23:03 23.6345 -102.5528 585 8 4 573 Mexico
3272 3272       Bangladesh 2020-03-27 23:23:03 23.685 90.3563 48 5 11 32 Bangladesh
3414 3414       Taiwan* 2020-03-27 06:33:04 23.7 121.0 267 2 29 236 Taiwan*
3200 3200     Guangxi China 2020-03-20 04:33:45 23.8298 108.7881 254 2 250 2 Guangxi, China
3398 3398       Saudi Arabia 2020-03-27 23:23:03 23.885942 45.079162 1104 3 35 1066 Saudi Arabia
3258 3258     Yunnan China 2020-03-26 23:16:51 24.974 101.487 180 2 172 6 Yunnan, China
3270 3270       Bahamas 2020-03-27 23:23:03 25.025885 -78.035889 10 0 1 9 Bahamas
1959 1959 12087 Monroe Florida US 2020-03-27 22:14:55 25.20904673 -81.07812416 16 0 0 0 Monroe, Florida, US
3389 3389       Qatar 2020-03-27 23:23:03 25.3548 51.1839 562 0 43 519 Qatar
1914 1914 12086 Miami-Dade Florida US 2020-03-27 22:14:55 25.6112362 -80.55170587 763 1 0 0 Miami-Dade, Florida, US
3271 3271       Bahrain 2020-03-27 23:23:03 26.0275 50.55 466 4 227 235 Bahrain
3191 3191     Fujian China 2020-03-27 01:08:02 26.0789 117.9874 331 1 295 35 Fujian, China
600 600 12021 Collier Florida US 2020-03-27 22:14:55 26.11091986 -81.34687065 81 0 0 0 Collier, Florida, US
372 372 48061 Cameron Texas US 2020-03-27 22:14:55 26.14524221 -97.48140372 13 0 0 0 Cameron, Texas, US
284 284 12011 Broward Florida US 2020-03-27 22:14:55 26.15184651 -80.48725556 614 5 0 0 Broward, Florida, US
3353 3353       Libya 2020-03-27 23:23:03 26.3351 17.228331 1 0 0 1 Libya
1266 1266 48215 Hidalgo Texas US 2020-03-27 22:14:55 26.39418217 -98.18299696 11 0 0 0 Hidalgo, Texas, US
3091 3091 48489 Willacy Texas US 2020-03-27 22:14:55 26.47411727 -97.61535848 1 0 0 0 Willacy, Texas, US
1245 1245 12051 Hendry Florida US 2020-03-27 22:14:55 26.55386945 -81.16469006 0 0 0 0 Hendry, Florida, US
2690 2690 48427 Starr Texas US 2020-03-27 22:14:55 26.56150059 -98.73892358 2 0 0 0 Starr, Texas, US
1626 1626 12071 Lee Florida US 2020-03-27 22:14:55 26.58410348 -81.88399313 76 4 0 0 Lee, Florida, US
2193 2193 12099 Palm Beach Florida US 2020-03-27 22:14:55 26.64676272 -80.46536002 194 3 0 0 Palm Beach, Florida, US
3201 3201     Guizhou China 2020-03-18 01:37:43 26.8154 106.8748 146 2 144 0 Guizhou, China
3307 3307       Egypt 2020-03-27 23:23:03 26.820553000000004 30.802497999999996 536 30 116 390 Egypt
454 454 12015 Charlotte Florida US 2020-03-27 22:14:55 26.90131002 -81.92949121 5 0 0 0 Charlotte, Florida, US
1485 1485 48261 Kenedy Texas US 2020-03-27 22:14:55 26.92601662 -97.66413984 0 0 0 0 Kenedy, Texas, US
1048 1048 12043 Glades Florida US 2020-03-27 22:14:55 26.95635849 -81.18996211 0 0 0 0 Glades, Florida, US
3171 3171 48505 Zapata Texas US 2020-03-27 22:14:55 27.00156391 -99.16987152 0 0 0 0 Zapata, Texas, US
281 281 48047 Brooks Texas US 2020-03-27 22:14:55 27.03103197 -98.21808402 0 0 0 0 Brooks, Texas, US
1435 1435 48247 Jim Hogg Texas US 2020-03-27 22:14:55 27.04453923 -98.69681870000001 0 0 0 0 Jim Hogg, Texas, US
1825 1825 12085 Martin Florida US 2020-03-27 22:14:55 27.0772071 -80.43109784 16 0 0 0 Martin, Florida, US
2535 2535 12115 Sarasota Florida US 2020-03-27 22:14:55 27.18546175 -82.33174248 40 2 0 0 Sarasota, Florida, US
745 745 12027 DeSoto Florida US 2020-03-27 22:14:55 27.18677893 -81.80941373 6 0 0 0 DeSoto,Florida,US
1269 1269 12055 Highlands Florida US 2020-03-27 22:14:55 27.34254618 -81.34071957 5 1 0 0 Highlands, Florida, US
2674 2674 12111 St. Lucie Florida US 2020-03-27 22:14:55 27.37763908 -80.47106649 14 1 0 0 St. Lucie, Florida, US
2127 2127 12093 Okeechobee Florida US 2020-03-27 22:14:55 27.386336199999995 -80.88944347 0 0 0 0 Okeechobee, Florida, US

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

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