03-29-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,437 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
3423 3423       Togo 3/29/20 23:08 8.6195 0.8248 25 1 1 23 Togo
3382 3382       Nigeria 3/29/20 23:08 9.082 8.6753 111 1 3 107 Nigeria
3317 3317       Ethiopia 3/29/20 23:08 9.145 40.4897 21 0 1 20 Ethiopia
3281 3281       Benin 3/29/20 23:08 9.3077 2.3158 6 0 0 6 Benin
3299 3299       Costa Rica 3/29/20 23:08 9.7489 -83.7534 314 2 3 309 Costa Rica
3329 3329       Guinea 3/29/20 23:08 9.9456 -9.6966 16 0 0 16 Guinea
3424 3424       Trinidad and Tobago 3/29/20 23:08 10.6918 -61.2225 78 3 1 74 Trinidad and Tobago
3291 3291       Cambodia 3/29/20 23:08 11.55 104.9167 103 0 21 82 Cambodia
3330 3330       Guinea-Bissau 3/29/20 23:08 11.8037 -15.1804 2 0 0 2 Guinea-Bissau
3307 3307       Djibouti 3/29/20 23:08 11.8251 42.5903 18 0 0 18 Djibouti
3327 3327       Grenada 3/29/20 23:08 12.1165 -61.679 9 0 0 9 Grenada
3188 3188     Curacao Netherlands 3/29/20 23:08 12.1696 -68.99 8 1 2 5 Curacao, Netherlands
3288 3288       Burkina Faso 3/29/20 23:08 12.2383 -1.5616 222 12 23 187 Burkina Faso
3179 3179     Aruba Netherlands 3/29/20 23:08 12.5211 -69.9683 50 0 1 49 Aruba, Netherlands
3414 3414       Sudan 3/29/20 23:08 12.8628 30.2176 5 1 0 5 Sudan
3380 3380       Nicaragua 3/29/20 23:08 12.865416 -85.207229 4 1 0 3 Nicaragua
3391 3391       Philippines 3/29/20 23:08 12.879721 121.774017 1418 71 42 1305 Philippines
3400 3400       Saint Vincent and the Grenadines 3/29/20 23:08 12.9843 -61.2872 1 0 1 0 Saint Vincent and the Grenadines
3277 3277       Barbados 3/29/20 23:08 13.1939 -59.5432 33 0 0 33 Barbados
3322 3322       Gambia 3/29/20 23:08 13.4432 -15.3101 4 1 0 3 Gambia
3201 3201 66000   Guam US 3/29/20 23:08 13.4443 144.7937 56 1 0 0 Guam, US
3312 3312       El Salvador 3/29/20 23:08 13.7942 -88.8965 24 0 0 24 El Salvador
3399 3399       Saint Lucia 3/29/20 23:08 13.9094 -60.9789 9 0 1 8 Saint Lucia
3434 3434       Vietnam 3/29/20 23:08 14.058324 108.277199 188 0 25 163 Vietnam
3404 3404       Senegal 3/29/20 23:08 14.4974 -14.4524 142 0 27 115 Senegal
3220 3220     Martinique France 3/29/20 23:08 14.6415 -61.0242 93 1 0 92 Martinique, France
3228 3228 69000   Northern Mariana Islands US 3/29/20 23:08 15.0979 145.6739 0 0 0 0 Northern Mariana Islands, US
3314 3314       Eritrea 3/29/20 23:08 15.1794 39.7823 12 0 0 12 Eritrea
3334 3334       Honduras 3/29/20 23:08 15.2 -86.2419 110 3 3 104 Honduras
3308 3308       Dominica 3/29/20 23:08 15.415 -61.371 11 0 0 11 Dominica
3294 3294       Chad 3/29/20 23:08 15.4542 18.7322 3 0 0 3 Chad
3328 3328       Guatemala 3/29/20 23:08 15.7835 -90.2308 34 1 10 23 Guatemala
3421 3421       Thailand 3/29/20 23:08 15.870032 100.992541 1388 7 111 1284 Thailand
3200 3200     Guadeloupe France 3/29/20 23:08 16.265 -61.551 106 4 17 85 Guadeloupe, France
3290 3290       Cabo Verde 3/29/20 23:08 16.5388 -23.0418 6 1 0 5 Cabo Verde
3222 3222     Montserrat United Kingdom 3/29/20 23:08 16.742498 -62.187366 5 0 0 5 Montserrat, United Kingdom
3269 3269       Antigua and Barbuda 3/29/20 23:08 17.0608 -61.7964 7 0 0 7 Antigua and Barbuda
3280 3280       Belize 3/29/20 23:08 17.1899 -88.4976 2 0 0 2 ,,Belize
3398 3398       Saint Kitts and Nevis 3/29/20 23:08 17.357822 -62.782998 2 0 0 2 Saint Kitts and Nevis
3365 3365       Mali 3/29/20 23:08 17.570692 -3.996166 18 1 0 17 Mali
3381 3381       Niger 3/29/20 23:08 17.607789 8.081666 18 1 0 17 Niger
3242 3242     Saint Barthelemy France 3/29/20 23:08 17.9 -62.8333 5 0 0 5 Saint Barthelemy, France
3250 3250     Sint Maarten Netherlands 3/29/20 23:08 18.0425 -63.0548 6 0 0 6 Sint Maarten, Netherlands
3252 3252     St Martin France 3/29/20 23:08 18.0708 -63.0501 11 0 0 11 St Martin, France
3344 3344       Jamaica 3/29/20 23:08 18.1096 -77.2975 32 1 2 29 Jamaica
3177 3177     Anguilla United Kingdom 3/29/20 23:08 18.2206 -63.0686 2 0 0 2 Anguilla, United Kingdom
3235 3235     Puerto Rico US 3/29/20 23:08 18.2208 -66.5901 127 3 0 0 Puerto Rico, US
3258 3258 78000   Virgin Islands US 3/29/20 23:08 18.3358 -64.8963 23 0 0 0 Virgin Islands, US
3184 3184     British Virgin Islands United Kingdom 3/29/20 23:08 18.4207 -64.64 2 0 0 2 British Virgin Islands, United Kingdom
3309 3309       Dominican Republic 3/29/20 23:08 18.7357 -70.1627 859 39 3 817 Dominican Republic
3332 3332       Haiti 3/29/20 23:08 18.9712 -72.2852 8 0 1 14 Haiti
3205 3205     Hainan China 3/24/20 4:29 19.1959 109.7453 168 6 162 0 Hainan, China
3185 3185     Cayman Islands United Kingdom 3/29/20 23:08 19.3133 -81.2546 8 1 0 7 Cayman Islands, United Kingdom
1230 1230 15001 Hawaii Hawaii US 3/29/20 23:08 19.60121157 -155.5210167 10 0 0 0 Hawaii, Hawaii, US
3353 3353       Laos 3/29/20 23:08 19.85627 102.495496 8 0 0 8 Laos
3337 3337       India 3/29/20 23:08 20.593684 78.96288 1024 27 95 902 India
1842 1842 15009 Maui Hawaii US 3/29/20 23:08 20.86399628 -156.5689097 16 0 0 0 Maui, Hawaii, US
3367 3367       Mauritania 3/29/20 23:08 21.0079 -10.9408 5 0 2 3 ,,Mauritania
1465 1465 15005 Kalawao Hawaii US 3/29/20 23:08 21.17882515 -156.9583592 0 0 0 0 Kalawao, Hawaii, US
1287 1287 15003 Honolulu Hawaii US 3/29/20 23:08 21.45803166 -157.9712182 108 0 0 0 Honolulu, Hawaii, US
3385 3385       Oman 3/29/20 23:08 21.512583 55.923255 167 0 23 144 Oman
3302 3302       Cuba 3/29/20 23:08 21.521757 -77.781167 139 3 4 132 Cuba
3256 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
3289 3289       Burma 3/29/20 23:08 21.9162 95.956 10 0 0 10 Burma
1475 1475 15007 Kauai Hawaii US 3/29/20 23:08 22.03935037 -159.5966786 11 0 0 0 Kauai, Hawaii, US
3218 3218     Macau China 3/28/20 15:17 22.1667 113.55 37 0 10 27 Macau, China
3209 3209     Hong Kong China 3/29/20 9:40 22.3 114.2 641 4 112 525 Hong Kong, China
3202 3202     Guangdong China 3/29/20 2:09 23.3417 113.4244 1475 8 1349 118 Guangdong, China
3429 3429       United Arab Emirates 3/29/20 23:08 23.424076 53.847818 570 3 58 509 United Arab Emirates
3369 3369       Mexico 3/29/20 23:08 23.6345 -102.5528 848 16 4 828 Mexico
3276 3276       Bangladesh 3/29/20 23:08 23.685 90.3563 48 5 15 28 Bangladesh
3419 3419       Taiwan* 3/29/20 8:04 23.7 121.0 298 2 30 266 Taiwan*
3203 3203     Guangxi China 3/20/20 4:33 23.8298 108.7881 254 2 250 2 Guangxi, China
3403 3403       Saudi Arabia 3/29/20 23:08 23.885942 45.079162 1299 8 66 1225 Saudi Arabia
3262 3262     Yunnan China 3/26/20 23:16 24.974 101.487 180 2 172 6 Yunnan, China
3274 3274       Bahamas 3/29/20 23:08 25.025885 -78.035889 11 0 1 10 Bahamas
1959 1959 12087 Monroe Florida US 3/29/20 23:08 25.20904673 -81.07812416 22 0 0 0 Monroe, Florida, US
3394 3394       Qatar 3/29/20 23:08 25.3548 51.1839 634 1 48 585 Qatar
1914 1914 12086 Miami-Dade Florida US 3/29/20 23:08 25.6112362 -80.55170587 1192 3 0 0 Miami-Dade, Florida, US
3275 3275       Bahrain 3/29/20 23:08 26.0275 50.55 499 4 272 223 Bahrain
3194 3194     Fujian China 3/29/20 0:57 26.0789 117.9874 338 1 295 42 Fujian, China
600 600 12021 Collier Florida US 3/29/20 23:08 26.11091986 -81.34687065 95 0 0 0 Collier, Florida, US
372 372 48061 Cameron Texas US 3/29/20 23:08 26.14524221 -97.48140372 20 0 0 0 Cameron, Texas, US
284 284 12011 Broward Florida US 3/29/20 23:08 26.15184651 -80.48725556 838 11 0 0 Broward, Florida, US
3357 3357       Libya 3/29/20 23:08 26.3351 17.228331 8 0 0 8 Libya
1266 1266 48215 Hidalgo Texas US 3/29/20 23:08 26.39418217 -98.18299696 27 0 0 0 Hidalgo, Texas, US
3092 3092 48489 Willacy Texas US 3/29/20 23:08 26.47411727 -97.61535848 1 0 0 0 Willacy, Texas, US
1245 1245 12051 Hendry Florida US 3/29/20 23:08 26.55386945 -81.16469006 1 0 0 0 Hendry, Florida, US
2690 2690 48427 Starr Texas US 3/29/20 23:08 26.56150059 -98.73892358 2 0 0 0 Starr, Texas, US
1626 1626 12071 Lee Florida US 3/29/20 23:08 26.58410348 -81.88399313 124 6 0 0 Lee, Florida, US
2193 2193 12099 Palm Beach Florida US 3/29/20 23:08 26.64676272 -80.46536002 333 5 0 0 Palm Beach, Florida, US
3204 3204     Guizhou China 3/18/20 1:37 26.8154 106.8748 146 2 144 0 Guizhou, China
3311 3311       Egypt 3/29/20 23:08 26.820553 30.802498 609 40 132 437 Egypt
454 454 12015 Charlotte Florida US 3/29/20 23:08 26.90131002 -81.92949121 16 0 0 0 Charlotte, Florida, US
1485 1485 48261 Kenedy Texas US 3/29/20 23:08 26.92601662 -97.66413984 0 0 0 0 Kenedy, Texas, US
1048 1048 12043 Glades Florida US 3/29/20 23:08 26.95635849 -81.18996211 0 0 0 0 Glades, Florida, US
3172 3172 48505 Zapata Texas US 3/29/20 23:08 27.00156391 -99.16987152 0 0 0 0 Zapata, Texas, US
281 281 48047 Brooks Texas US 3/29/20 23:08 27.03103197 -98.21808402 0 0 0 0 Brooks, Texas, US
1435 1435 48247 Jim Hogg Texas US 3/29/20 23:08 27.04453923 -98.6968187 0 0 0 0 Jim Hogg, Texas, US
1825 1825 12085 Martin Florida US 3/29/20 23:08 27.0772071 -80.43109784 26 0 0 0 Martin, Florida, US

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
);