03-28-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,433 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       Costa Rica 3/28/20 23:05 9.7489 -83.7534 295 2 3 290 Costa Rica
3325 3325       Guinea 3/28/20 23:05 9.9456 -9.6966 8 0 0 8 Guinea
3420 3420       Trinidad and Tobago 3/28/20 23:05 10.6918 -61.2225 74 3 1 70 Trinidad and Tobago
3287 3287       Cambodia 3/28/20 23:05 11.55 104.9167 99 0 13 86 Cambodia
3326 3326       Guinea-Bissau 3/28/20 23:05 11.8037 -15.1804 2 0 0 2 Guinea-Bissau
3303 3303       Djibouti 3/28/20 23:05 11.8251 42.5903 14 0 0 14 Djibouti
3323 3323       Grenada 3/28/20 23:05 12.1165 -61.679 7 0 0 7 Grenada
3184 3184     Curacao Netherlands 3/28/20 23:05 12.1696 -68.99 8 1 2 5 Curacao, Netherlands
3284 3284       Burkina Faso 3/28/20 23:05 12.2383 -1.5616 207 11 21 175 Burkina Faso
3175 3175     Aruba Netherlands 3/28/20 23:05 12.5211 -69.9683 46 0 1 45 Aruba, Netherlands
3410 3410       Sudan 3/28/20 23:05 12.8628 30.2176 5 1 0 4 Sudan
3376 3376       Nicaragua 3/28/20 23:05 12.865416 -85.207229 4 1 0 3 Nicaragua
3387 3387       Philippines 3/28/20 23:05 12.879721 121.774017 1075 68 35 972 Philippines
3396 3396       Saint Vincent and the Grenadines 3/28/20 23:05 12.9843 -61.2872 1 0 1 0 Saint Vincent and the Grenadines
3273 3273       Barbados 3/28/20 23:05 13.1939 -59.5432 26 0 0 26 Barbados
3318 3318       Gambia 3/28/20 23:05 13.4432 -15.3101 3 1 0 2 Gambia
3197 3197 66000   Guam US 3/28/20 23:05 13.4443 144.7937 55 1 0 0 Guam, US
3308 3308       El Salvador 3/28/20 23:05 13.7942 -88.8965 19 0 0 19 El Salvador
3395 3395       Saint Lucia 3/28/20 23:05 13.9094 -60.9789 3 0 1 2 Saint Lucia
3430 3430       Vietnam 3/28/20 23:05 14.058324 108.277199 174 0 21 153 Vietnam
3400 3400       Senegal 3/28/20 23:05 14.4974 -14.4524 130 0 18 112 Senegal
3216 3216     Martinique France 3/28/20 23:05 14.6415 -61.0242 93 1 0 92 Martinique, France
3224 3224 69000   Northern Mariana Islands US 3/28/20 23:05 15.0979 145.6739 0 0 0 0 Northern Mariana Islands, US
3310 3310       Eritrea 3/28/20 23:05 15.1794 39.7823 6 0 0 6 Eritrea
3330 3330       Honduras 3/28/20 23:05 15.2 -86.2419 95 1 3 91 Honduras
3304 3304       Dominica 3/28/20 23:05 15.415 -61.371 11 0 0 11 Dominica
3290 3290       Chad 3/28/20 23:05 15.4542 18.7322 3 0 0 3 Chad
3324 3324       Guatemala 3/28/20 23:05 15.7835 -90.2308 34 1 10 23 Guatemala
3417 3417       Thailand 3/28/20 23:05 15.870032 100.992541 1245 6 100 1142 Thailand
3196 3196     Guadeloupe France 3/28/20 23:05 16.265 -61.551 102 2 17 83 Guadeloupe, France
3286 3286       Cabo Verde 3/28/20 23:05 16.5388 -23.0418 5 1 0 4 Cabo Verde
3218 3218     Montserrat United Kingdom 3/28/20 23:05 16.742498 -62.187366 5 0 0 5 Montserrat, United Kingdom
3265 3265       Antigua and Barbuda 3/28/20 23:05 17.0608 -61.7964 7 0 0 7 Antigua and Barbuda
3276 3276       Belize 3/28/20 23:05 17.1899 -88.4976 2 0 0 2 ,,Belize
3394 3394       Saint Kitts and Nevis 3/28/20 23:05 17.357822 -62.782998 2 0 0 2 Saint Kitts and Nevis
3361 3361       Mali 3/28/20 23:05 17.570692 -3.996166 18 0 0 18 Mali
3377 3377       Niger 3/28/20 23:05 17.607789 8.081666 10 1 0 9 Niger
3238 3238     Saint Barthelemy France 3/28/20 23:05 17.9 -62.8333 5 0 0 5 Saint Barthelemy, France
3246 3246     Sint Maarten Netherlands 3/28/20 23:05 18.0425 -63.0548 3 0 0 3 Sint Maarten, Netherlands
3248 3248     St Martin France 3/28/20 23:05 18.0708 -63.0501 11 0 0 11 St Martin, France
3340 3340       Jamaica 3/28/20 23:05 18.1096 -77.2975 30 1 2 27 Jamaica
3173 3173     Anguilla United Kingdom 3/28/20 23:05 18.2206 -63.0686 2 0 0 2 Anguilla, United Kingdom
3231 3231     Puerto Rico US 3/28/20 23:05 18.2208 -66.5901 100 3 0 0 Puerto Rico, US
3254 3254 78000   Virgin Islands US 3/28/20 23:05 18.3358 -64.8963 22 0 0 0 Virgin Islands, US
3180 3180     British Virgin Islands United Kingdom 3/28/20 23:05 18.4207 -64.64 2 0 0 2 British Virgin Islands, United Kingdom
3305 3305       Dominican Republic 3/28/20 23:05 18.7357 -70.1627 719 28 3 688 Dominican Republic
3328 3328       Haiti 3/28/20 23:05 18.9712 -72.2852 8 0 0 8 Haiti
3201 3201     Hainan China 3/24/20 4:29 19.1959 109.7453 168 6 162 0 Hainan, China
3181 3181     Cayman Islands United Kingdom 3/28/20 23:05 19.3133 -81.2546 8 1 0 7 Cayman Islands, United Kingdom
1230 1230 15001 Hawaii Hawaii US 3/28/20 23:05 19.60121157 -155.5210167 10 0 0 0 Hawaii, Hawaii, US
3349 3349       Laos 3/28/20 23:05 19.85627 102.495496 8 0 0 8 Laos
3333 3333       India 3/28/20 23:05 20.593684 78.96288 987 24 84 879 India
1842 1842 15009 Maui Hawaii US 3/28/20 23:05 20.86399628 -156.5689097 16 0 0 0 Maui, Hawaii, US
3363 3363       Mauritania 3/28/20 23:05 21.0079 -10.9408 5 0 0 5 ,,Mauritania
1465 1465 15005 Kalawao Hawaii US 3/28/20 23:05 21.17882515 -156.9583592 0 0 0 0 Kalawao, Hawaii, US
1287 1287 15003 Honolulu Hawaii US 3/28/20 23:05 21.45803166 -157.9712182 108 0 0 0 Honolulu, Hawaii, US
3381 3381       Oman 3/28/20 23:05 21.512583 55.923255 152 0 23 129 Oman
3298 3298       Cuba 3/28/20 23:05 21.521757 -77.781167 119 3 4 112 Cuba
3252 3252     Turks and Caicos Islands United Kingdom 3/28/20 23:05 21.694 -71.7979 4 0 0 4 Turks and Caicos Islands, United Kingdom
3285 3285       Burma 3/28/20 23:05 21.9162 95.956 8 0 0 8 Burma
1475 1475 15007 Kauai Hawaii US 3/28/20 23:05 22.03935037 -159.5966786 11 0 0 0 Kauai, Hawaii, US
3214 3214     Macau China 3/28/20 15:17 22.1667 113.55 37 0 10 27 Macau, China
3205 3205     Hong Kong China 3/28/20 12:50 22.3 114.2 561 4 112 445 Hong Kong, China
3198 3198     Guangdong China 3/28/20 2:13 23.3417 113.4244 1467 8 1341 118 Guangdong, China
3425 3425       United Arab Emirates 3/28/20 23:05 23.424076 53.847818 468 2 52 414 United Arab Emirates
3365 3365       Mexico 3/28/20 23:05 23.6345 -102.5528 717 12 4 701 Mexico
3272 3272       Bangladesh 3/28/20 23:05 23.685 90.3563 48 5 15 28 Bangladesh
3415 3415       Taiwan* 3/28/20 6:58 23.7 121.0 283 2 30 251 Taiwan*
3199 3199     Guangxi China 3/20/20 4:33 23.8298 108.7881 254 2 250 2 Guangxi, China
3399 3399       Saudi Arabia 3/28/20 23:05 23.885942 45.079162 1203 4 37 1162 Saudi Arabia
3258 3258     Yunnan China 3/26/20 23:16 24.974 101.487 180 2 172 6 Yunnan, China
3270 3270       Bahamas 3/28/20 23:05 25.025885 -78.035889 10 0 1 9 Bahamas
1959 1959 12087 Monroe Florida US 3/28/20 23:05 25.20904673 -81.07812416 20 0 0 0 Monroe, Florida, US
3390 3390       Qatar 3/28/20 23:05 25.3548 51.1839 590 1 45 544 Qatar
1914 1914 12086 Miami-Dade Florida US 3/28/20 23:05 25.6112362 -80.55170587 1003 2 0 0 Miami-Dade, Florida, US
3271 3271       Bahrain 3/28/20 23:05 26.0275 50.55 476 4 265 207 Bahrain
3190 3190     Fujian China 3/28/20 1:35 26.0789 117.9874 337 1 295 41 Fujian, China
600 600 12021 Collier Florida US 3/28/20 23:05 26.11091986 -81.34687065 92 0 0 0 Collier, Florida, US
372 372 48061 Cameron Texas US 3/28/20 23:05 26.14524221 -97.48140372 13 0 0 0 Cameron, Texas, US
284 284 12011 Broward Florida US 3/28/20 23:05 26.15184651 -80.48725556 814 10 0 0 Broward, Florida, US
3353 3353       Libya 3/28/20 23:05 26.3351 17.228331 3 0 0 3 Libya
1266 1266 48215 Hidalgo Texas US 3/28/20 23:05 26.39418217 -98.18299696 18 0 0 0 Hidalgo, Texas, US
3088 3088 48489 Willacy Texas US 3/28/20 23:05 26.47411727 -97.61535848 1 0 0 0 Willacy, Texas, US
1245 1245 12051 Hendry Florida US 3/28/20 23:05 26.55386945 -81.16469006 0 0 0 0 Hendry, Florida, US
2690 2690 48427 Starr Texas US 3/28/20 23:05 26.56150059 -98.73892358 2 0 0 0 Starr, Texas, US
1626 1626 12071 Lee Florida US 3/28/20 23:05 26.58410348 -81.88399313 101 5 0 0 Lee, Florida, US
2193 2193 12099 Palm Beach Florida US 3/28/20 23:05 26.64676272 -80.46536002 292 5 0 0 Palm Beach, Florida, US
3200 3200     Guizhou China 3/18/20 1:37 26.8154 106.8748 146 2 144 0 Guizhou, China
3307 3307       Egypt 3/28/20 23:05 26.820553 30.802498 576 36 121 419 Egypt
454 454 12015 Charlotte Florida US 3/28/20 23:05 26.90131002 -81.92949121 12 0 0 0 Charlotte, Florida, US
1485 1485 48261 Kenedy Texas US 3/28/20 23:05 26.92601662 -97.66413984 0 0 0 0 Kenedy, Texas, US
1048 1048 12043 Glades Florida US 3/28/20 23:05 26.95635849 -81.18996211 0 0 0 0 Glades, Florida, US
3168 3168 48505 Zapata Texas US 3/28/20 23:05 27.00156391 -99.16987152 0 0 0 0 Zapata, Texas, US
281 281 48047 Brooks Texas US 3/28/20 23:05 27.03103197 -98.21808402 0 0 0 0 Brooks, Texas, US
1435 1435 48247 Jim Hogg Texas US 3/28/20 23:05 27.04453923 -98.6968187 0 0 0 0 Jim Hogg, Texas, US
1825 1825 12085 Martin Florida US 3/28/20 23:05 27.0772071 -80.43109784 25 0 0 0 Martin, Florida, US
2535 2535 12115 Sarasota Florida US 3/28/20 23:05 27.18546175 -82.33174248 48 2 0 0 Sarasota, Florida, US
745 745 12027 DeSoto Florida US 3/28/20 23:05 27.18677893 -81.80941373 7 0 0 0 DeSoto,Florida,US
1269 1269 12055 Highlands Florida US 3/28/20 23:05 27.34254618 -81.34071957 10 1 0 0 Highlands, Florida, US
2674 2674 12111 St. Lucie Florida US 3/28/20 23:05 27.37763908 -80.47106649 21 1 0 0 St. Lucie, Florida, US

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

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