03-30-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,442 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
3298 3298       Central African Republic 3/30/20 22:52 6.6111 20.9394 3 0 0 3 Central African Republic
3305 3305       Cote d'Ivoire 3/30/20 22:52 7.54 -5.5471 168 1 6 161 Cote d'Ivoire
3418 3418       Sri Lanka 3/30/20 22:52 7.873054 80.771797 122 2 15 105 Sri Lanka
3330 3330       Ghana 3/30/20 22:52 7.9465 -1.0232 152 5 2 145 Ghana
3392 3392       Panama 3/30/20 22:52 8.538 -80.7821 989 24 4 961 Panama
3428 3428       Togo 3/30/20 22:52 8.6195 0.8248 30 1 1 28 Togo
3387 3387       Nigeria 3/30/20 22:52 9.082 8.6753 131 2 8 121 Nigeria
3322 3322       Ethiopia 3/30/20 22:52 9.145 40.4897 23 0 4 19 Ethiopia
3285 3285       Benin 3/30/20 22:52 9.3077 2.3158 6 0 0 6 Benin
3304 3304       Costa Rica 3/30/20 22:52 9.7489 -83.7534 330 2 4 324 Costa Rica
3334 3334       Guinea 3/30/20 22:52 9.9456 -9.6966 22 0 0 22 Guinea
3429 3429       Trinidad and Tobago 3/30/20 22:52 10.6918 -61.2225 82 3 1 78 Trinidad and Tobago
3296 3296       Cambodia 3/30/20 22:52 11.55 104.9167 107 0 21 86 Cambodia
3335 3335       Guinea-Bissau 3/30/20 22:52 11.8037 -15.1804 8 0 0 8 Guinea-Bissau
3312 3312       Djibouti 3/30/20 22:52 11.8251 42.5903 18 0 0 18 Djibouti
3332 3332       Grenada 3/30/20 22:52 12.1165 -61.679 9 0 0 9 Grenada
3192 3192     Curacao Netherlands 3/30/20 22:52 12.1696 -68.99 11 1 2 8 Curacao, Netherlands
3293 3293       Burkina Faso 3/30/20 22:52 12.2383 -1.5616 246 12 31 203 Burkina Faso
3183 3183     Aruba Netherlands 3/30/20 22:52 12.5211 -69.9683 50 0 1 49 Aruba, Netherlands
3419 3419       Sudan 3/30/20 22:52 12.8628 30.2176 6 2 0 4 Sudan
3385 3385       Nicaragua 3/30/20 22:52 12.865416 -85.207229 4 1 0 3 Nicaragua
3396 3396       Philippines 3/30/20 22:52 12.879721 121.774017 1546 78 42 1426 Philippines
3405 3405       Saint Vincent and the Grenadines 3/30/20 22:52 12.9843 -61.2872 1 0 1 0 Saint Vincent and the Grenadines
3281 3281       Barbados 3/30/20 22:52 13.1939 -59.5432 33 0 0 33 Barbados
3327 3327       Gambia 3/30/20 22:52 13.4432 -15.3101 4 1 0 3 Gambia
3205 3205 66000   Guam US 3/30/20 22:52 13.4443 144.7937 58 1 0 0 Guam, US
3317 3317       El Salvador 3/30/20 22:52 13.7942 -88.8965 30 0 0 30 El Salvador
3404 3404       Saint Lucia 3/30/20 22:52 13.9094 -60.9789 9 0 1 8 Saint Lucia
3439 3439       Vietnam 3/30/20 22:52 14.058324 108.277199 203 0 55 148 Vietnam
3409 3409       Senegal 3/30/20 22:52 14.4974 -14.4524 162 0 27 135 Senegal
3224 3224     Martinique France 3/30/20 22:52 14.6415 -61.0242 93 1 0 92 Martinique, France
3232 3232 69000   Northern Mariana Islands US 3/30/20 22:52 15.0979 145.6739 0 0 0 0 Northern Mariana Islands, US
3319 3319       Eritrea 3/30/20 22:52 15.1794 39.7823 12 0 0 12 Eritrea
3339 3339       Honduras 3/30/20 22:52 15.2 -86.2419 139 7 3 129 Honduras
3313 3313       Dominica 3/30/20 22:52 15.415 -61.371 11 0 0 11 Dominica
3299 3299       Chad 3/30/20 22:52 15.4542 18.7322 5 0 0 5 Chad
3333 3333       Guatemala 3/30/20 22:52 15.7835 -90.2308 36 1 10 25 Guatemala
3426 3426       Thailand 3/30/20 22:52 15.870032 100.992541 1524 9 127 1286 Thailand
3204 3204     Guadeloupe France 3/30/20 22:52 16.265 -61.551 106 4 17 85 Guadeloupe, France
3295 3295       Cabo Verde 3/30/20 22:52 16.5388 -23.0418 6 1 0 5 Cabo Verde
3226 3226     Montserrat United Kingdom 3/30/20 22:52 16.742498 -62.187366 5 0 0 5 Montserrat, United Kingdom
3273 3273       Antigua and Barbuda 3/30/20 22:52 17.0608 -61.7964 7 0 0 7 Antigua and Barbuda
3284 3284       Belize 3/30/20 22:52 17.1899 -88.4976 3 0 0 3 ,,Belize
3403 3403       Saint Kitts and Nevis 3/30/20 22:52 17.357822 -62.782998 7 0 0 7 Saint Kitts and Nevis
3370 3370       Mali 3/30/20 22:52 17.570692 -3.996166 25 2 0 23 Mali
3386 3386       Niger 3/30/20 22:52 17.607789 8.081666 27 3 0 24 Niger
3246 3246     Saint Barthelemy France 3/30/20 22:52 17.9 -62.8333 6 0 1 5 Saint Barthelemy, France
3254 3254     Sint Maarten Netherlands 3/30/20 22:52 18.0425 -63.0548 6 0 0 6 Sint Maarten, Netherlands
3256 3256     St Martin France 3/30/20 22:52 18.0708 -63.0501 15 1 2 12 St Martin, France
3349 3349       Jamaica 3/30/20 22:52 18.1096 -77.2975 36 1 2 33 Jamaica
3181 3181     Anguilla United Kingdom 3/30/20 22:52 18.2206 -63.0686 2 0 0 2 Anguilla, United Kingdom
3239 3239     Puerto Rico US 3/30/20 22:52 18.2208 -66.5901 174 6 0 0 Puerto Rico, US
3262 3262 78000   Virgin Islands US 3/30/20 22:52 18.3358 -64.8963 30 0 0 0 Virgin Islands, US
3188 3188     British Virgin Islands United Kingdom 3/30/20 22:52 18.4207 -64.64 2 0 0 2 British Virgin Islands, United Kingdom
3314 3314       Dominican Republic 3/30/20 22:52 18.7357 -70.1627 901 42 4 855 Dominican Republic
3337 3337       Haiti 3/30/20 22:52 18.9712 -72.2852 15 0 1 14 Haiti
3209 3209     Hainan China 3/24/20 4:29 19.1959 109.7453 168 6 162 0 Hainan, China
3189 3189     Cayman Islands United Kingdom 3/30/20 22:52 19.3133 -81.2546 12 1 0 11 Cayman Islands, United Kingdom
1230 1230 15001 Hawaii Hawaii US 3/30/20 22:52 19.60121157 -155.5210167 12 0 0 0 Hawaii, Hawaii, US
3358 3358       Laos 3/30/20 22:52 19.85627 102.495496 8 0 0 8 Laos
3342 3342       India 3/30/20 22:52 20.593684 78.96288 1251 32 102 1117 India
1842 1842 15009 Maui Hawaii US 3/30/20 22:52 20.86399628 -156.5689097 20 0 0 0 Maui, Hawaii, US
3372 3372       Mauritania 3/30/20 22:52 21.0079 -10.9408 5 1 2 2 ,,Mauritania
1465 1465 15005 Kalawao Hawaii US 3/30/20 22:52 21.17882515 -156.9583592 0 0 0 0 Kalawao, Hawaii, US
1287 1287 15003 Honolulu Hawaii US 3/30/20 22:52 21.45803166 -157.9712182 123 0 0 0 Honolulu, Hawaii, US
3390 3390       Oman 3/30/20 22:52 21.512583 55.923255 179 0 29 150 Oman
3307 3307       Cuba 3/30/20 22:52 21.521757 -77.781167 170 4 4 162 Cuba
3260 3260     Turks and Caicos Islands United Kingdom 3/30/20 22:52 21.694 -71.7979 5 0 0 5 Turks and Caicos Islands, United Kingdom
3294 3294       Burma 3/30/20 22:52 21.9162 95.956 14 0 0 14 Burma
1475 1475 15007 Kauai Hawaii US 3/30/20 22:52 22.03935037 -159.5966786 12 0 0 0 Kauai, Hawaii, US
3222 3222     Macau China 3/30/20 2:07 22.1667 113.55 38 0 10 28 Macau, China
3213 3213     Hong Kong China 3/30/20 9:27 22.3 114.2 682 4 123 555 Hong Kong, China
3206 3206     Guangdong China 3/30/20 2:07 23.3417 113.4244 1484 8 1351 125 Guangdong, China
3434 3434       United Arab Emirates 3/30/20 22:52 23.424076 53.847818 611 5 61 545 United Arab Emirates
3374 3374       Mexico 3/30/20 22:52 23.6345 -102.5528 993 20 35 938 Mexico
3280 3280       Bangladesh 3/30/20 22:52 23.685 90.3563 49 5 19 25 Bangladesh
3424 3424       Taiwan* 3/30/20 7:11 23.7 121.0 306 5 39 262 Taiwan*
3207 3207     Guangxi China 3/20/20 4:33 23.8298 108.7881 254 2 250 2 Guangxi, China
3408 3408       Saudi Arabia 3/30/20 22:52 23.885942 45.079162 1453 8 115 1330 Saudi Arabia
3266 3266     Yunnan China 3/26/20 23:16 24.974 101.487 180 2 172 6 Yunnan, China
3278 3278       Bahamas 3/30/20 22:52 25.025885 -78.035889 14 0 1 13 Bahamas
1959 1959 12087 Monroe Florida US 3/30/20 22:52 25.20904673 -81.07812416 24 0 0 0 Monroe, Florida, US
3399 3399       Qatar 3/30/20 22:52 25.3548 51.1839 693 1 51 641 Qatar
1914 1914 12086 Miami-Dade Florida US 3/30/20 22:52 25.6112362 -80.55170587 1632 3 0 0 Miami-Dade, Florida, US
3279 3279       Bahrain 3/30/20 22:52 26.0275 50.55 515 4 279 232 Bahrain
3198 3198     Fujian China 3/30/20 0:32 26.0789 117.9874 340 1 295 44 Fujian, China
600 600 12021 Collier Florida US 3/30/20 22:52 26.11091986 -81.34687065 119 1 0 0 Collier, Florida, US
372 372 48061 Cameron Texas US 3/30/20 22:52 26.14524221 -97.48140372 20 0 0 0 Cameron, Texas, US
284 284 12011 Broward Florida US 3/30/20 22:52 26.15184651 -80.48725556 1152 11 0 0 Broward, Florida, US
3362 3362       Libya 3/30/20 22:52 26.3351 17.228331 8 0 0 8 Libya
1266 1266 48215 Hidalgo Texas US 3/30/20 22:52 26.39418217 -98.18299696 28 0 0 0 Hidalgo, Texas, US
3096 3096 48489 Willacy Texas US 3/30/20 22:52 26.47411727 -97.61535848 2 0 0 0 Willacy, Texas, US
1245 1245 12051 Hendry Florida US 3/30/20 22:52 26.55386945 -81.16469006 3 0 0 0 Hendry, Florida, US
2690 2690 48427 Starr Texas US 3/30/20 22:52 26.56150059 -98.73892358 2 0 0 0 Starr, Texas, US
1626 1626 12071 Lee Florida US 3/30/20 22:52 26.58410348 -81.88399313 164 6 0 0 Lee, Florida, US
2193 2193 12099 Palm Beach Florida US 3/30/20 22:52 26.64676272 -80.46536002 423 7 0 0 Palm Beach, Florida, US
3208 3208     Guizhou China 3/18/20 1:37 26.8154 106.8748 146 2 144 0 Guizhou, China
3316 3316       Egypt 3/30/20 22:52 26.820553 30.802498 656 41 150 465 Egypt
454 454 12015 Charlotte Florida US 3/30/20 22:52 26.90131002 -81.92949121 18 0 0 0 Charlotte, Florida, US
1485 1485 48261 Kenedy Texas US 3/30/20 22:52 26.92601662 -97.66413984 0 0 0 0 Kenedy, Texas, US

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

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