05-04-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,203 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
3151 3151       Peru 2020-05-05 02:32:34 -9.19 -75.0152 47372 1344 14427 31601 Peru
3187 3187       Timor-Leste 2020-05-05 02:32:34 -8.874217 125.727539 24 0 20 4 Timor-Leste
2999 2999     Saint Helena, Ascension and Tristan da Cunha United Kingdom 2020-05-05 02:32:34 -7.9467 -14.3559 0 0 0 0 Saint Helena, Ascension and Tristan da Cunha, United Kingdom
3185 3185       Tanzania 2020-05-05 02:32:34 -6.369028 34.888822 480 16 167 297 Tanzania
3149 3149       Papua New Guinea 2020-05-05 02:32:34 -6.314993 143.95555 8 0 8 0 Papua New Guinea
3168 3168       Seychelles 2020-05-05 02:32:34 -4.6796 55.492 11 0 6 5 Seychelles
3058 3058       Congo (Kinshasa) 2020-05-05 02:32:34 -4.322447 15.307045 682 34 80 568 Congo (Kinshasa)
3057 3057       Congo (Brazzaville) 2020-05-05 02:32:34 -4.2634 15.2832 236 10 26 200 Congo (Brazzaville)
3048 3048       Burundi 2020-05-05 02:32:34 -3.3731 29.9189 15 1 7 7 Burundi
3158 3158       Rwanda 2020-05-05 02:32:34 -1.9403 29.8739 261 0 128 133 Rwanda
3070 3070       Ecuador 2020-05-05 02:32:34 -1.8312 -78.1834 31881 1569 3433 26879 Ecuador
3081 3081       Gabon 2020-05-05 02:32:34 -0.8037 11.6094 367 6 93 268 Gabon
3098 3098       Indonesia 2020-05-05 02:32:34 -0.7893 113.9213 11587 864 1954 8769 Indonesia
3108 3108       Kenya 2020-05-05 02:32:34 -0.0236 37.9062 490 24 173 293 Kenya
3164 3164       Sao Tome and Principe 2020-05-05 02:32:34 0.18636 6.613081 23 3 4 16 Sao Tome and Principe
3170 3170       Singapore 2020-05-05 02:32:34 1.2833 103.8333 18778 18 1457 17303 Singapore
3192 3192       Uganda 2020-05-05 02:32:34 1.373333 32.290275 97 0 55 42 Uganda
3073 3073       Equatorial Guinea 2020-05-05 02:32:34 1.6508 10.2679 315 3 13 299 Equatorial Guinea
3125 3125       Maldives 2020-05-05 02:32:34 3.2028 73.2207 541 1 18 522 Maldives
3051 3051       Cameroon 2020-05-05 02:32:34 3.8480000000000003 11.5021 2104 64 953 1087 Cameroon
3179 3179       Suriname 2020-05-05 02:32:34 3.9193 -56.0278 10 1 9 0 Suriname
2948 2948     French Guiana France 2020-05-05 02:32:34 4.0 -53.0 133 1 100 32 French Guiana, France
3124 3124       Malaysia 2020-05-05 02:32:34 4.210483999999999 101.97576600000001 6353 105 4484 1764 Malaysia
3044 3044       Brunei 2020-05-05 02:32:34 4.5353 114.7277 138 1 130 7 Brunei
3055 3055       Colombia 2020-05-05 02:32:34 4.5709 -74.2973 7973 358 1807 5808 Colombia
3091 3091       Guyana 2020-05-05 02:32:34 4.860416000000002 -58.93018000000001 92 9 27 56 Guyana
3173 3173       Somalia 2020-05-05 02:32:34 5.152149 46.199616 756 35 61 660 Somalia
3198 3198       Venezuela 2020-05-05 02:32:34 6.4238 -66.5897 357 10 158 189 Venezuela
3116 3116       Liberia 2020-05-05 02:32:34 6.4280550000000005 -9.429499 166 18 58 90 Liberia
3052 3052       Central African Republic 2020-05-05 02:32:34 6.6111 20.9394 85 0 10 75 Central African Republic
3175 3175       South Sudan 2020-05-05 02:32:34 6.8770000000000024 31.307 46 0 0 46 South Sudan
3060 3060       Cote d'Ivoire 2020-05-05 02:32:34 7.54 -5.5471 1432 17 693 722 Cote d'Ivoire
3177 3177       Sri Lanka 2020-05-05 02:32:34 7.873054 80.77179699999998 751 8 194 549 Sri Lanka
3085 3085       Ghana 2020-05-05 02:32:34 7.9465 -1.0232 2719 18 294 2407 Ghana
3169 3169       Sierra Leone 2020-05-05 02:32:34 8.460555000000001 -11.779889 178 9 37 132 Sierra Leone
3148 3148       Panama 2020-05-05 02:32:34 8.538 -80.7821 7197 200 641 6356 Panama
3188 3188       Togo 2020-05-05 02:32:34 8.6195 0.8248 126 9 74 43 Togo
3143 3143       Nigeria 2020-05-05 02:32:34 9.082 8.6753 2802 93 417 2292 Nigeria
3077 3077       Ethiopia 2020-05-05 02:32:34 9.145 40.4897 140 3 75 62 Ethiopia
3038 3038       Benin 2020-05-05 02:32:34 9.3077 2.3158 96 2 50 44 Benin
3059 3059       Costa Rica 2020-05-05 02:32:34 9.7489 -83.7534 742 6 399 337 Costa Rica
3089 3089       Guinea 2020-05-05 02:32:34 9.9456 -9.6966 1710 9 450 1251 Guinea
3189 3189       Trinidad and Tobago 2020-05-05 02:32:34 10.6918 -61.2225 116 8 99 9 Trinidad and Tobago
3050 3050       Cambodia 2020-05-05 02:32:34 11.55 104.9167 122 0 120 2 Cambodia
3090 3090       Guinea-Bissau 2020-05-05 02:32:34 11.8037 -15.1804 413 1 19 393 Guinea-Bissau
3067 3067       Djibouti 2020-05-05 02:32:34 11.8251 42.5903 1116 2 713 401 Djibouti
3087 3087       Grenada 2020-05-05 02:32:34 12.1165 -61.678999999999995 21 0 13 8 Grenada
2943 2943     Curacao Netherlands 2020-05-05 02:32:34 12.1696 -68.99 16 1 13 2 Curacao, Netherlands
2937 2937     Bonaire, Sint Eustatius and Saba Netherlands 2020-05-05 02:32:34 12.1784 -68.2385 6 0 0 6 Bonaire, Sint Eustatius and Saba, Netherlands
3046 3046       Burkina Faso 2020-05-05 02:32:34 12.2383 -1.5616 672 46 545 81 Burkina Faso
2933 2933     Aruba Netherlands 2020-05-05 02:32:34 12.5211 -69.9683 100 2 81 17 Aruba, Netherlands
3178 3178       Sudan 2020-05-05 02:32:34 12.8628 30.2176 678 41 61 576 Sudan
3141 3141       Nicaragua 2020-05-05 02:32:34 12.865416 -85.207229 15 5 7 3 Nicaragua
3152 3152       Philippines 2020-05-05 02:32:34 12.879721 121.77401699999999 9485 623 1315 7547 Philippines
3161 3161       Saint Vincent and the Grenadines 2020-05-05 02:32:34 12.9843 -61.2872 17 0 9 8 Saint Vincent and the Grenadines
3034 3034       Barbados 2020-05-05 02:32:34 13.1939 -59.5432 82 7 46 29 Barbados
3082 3082       Gambia 2020-05-05 02:32:34 13.4432 -15.3101 17 1 9 7 Gambia
2957 2957 66   Guam US 2020-05-05 02:32:34 13.4443 144.7937 145 5 0 140 Guam, US
3072 3072       El Salvador 2020-05-05 02:32:34 13.7942 -88.8965 555 13 180 362 El Salvador
3160 3160       Saint Lucia 2020-05-05 02:32:34 13.9094 -60.9789 18 0 15 3 Saint Lucia
3199 3199       Vietnam 2020-05-05 02:32:34 14.058323999999999 108.277199 271 0 219 52 Vietnam
3166 3166       Senegal 2020-05-05 02:32:34 14.4974 -14.4524 1271 10 415 846 Senegal
2976 2976     Martinique France 2020-05-05 02:32:34 14.6415 -61.0242 181 14 83 84 Martinique, France
2984 2984 69   Northern Mariana Islands US 2020-05-05 02:32:34 15.0979 145.6739 14 2 0 12 Northern Mariana Islands, US
3074 3074       Eritrea 2020-05-05 02:32:34 15.1794 39.7823 39 0 26 13 Eritrea
3094 3094       Honduras 2020-05-05 02:32:34 15.2 -86.2419 1178 83 122 973 Honduras
3068 3068       Dominica 2020-05-05 02:32:34 15.415 -61.371 16 0 13 3 Dominica
3053 3053       Chad 2020-05-05 02:32:34 15.4542 18.7322 117 10 39 68 Chad
3201 3201       Yemen 2020-05-05 02:32:34 15.552726999999999 48.516388 12 2 1 9 Yemen
3088 3088       Guatemala 2020-05-05 02:32:34 15.7835 -90.2308 730 19 79 632 Guatemala
3186 3186       Thailand 2020-05-05 02:32:34 15.870032 100.992541 2987 54 2740 193 Thailand
2956 2956     Guadeloupe France 2020-05-05 02:32:34 16.265 -61.551 152 12 98 42 Guadeloupe, France
3049 3049       Cabo Verde 2020-05-05 02:32:34 16.5388 -23.0418 175 2 37 136 Cabo Verde
2978 2978     Montserrat United Kingdom 2020-05-05 02:32:34 16.742498 -62.187366000000004 11 1 7 3 Montserrat, United Kingdom
3026 3026       Antigua and Barbuda 2020-05-05 02:32:34 17.0608 -61.7964 25 3 15 7 Antigua and Barbuda
3037 3037       Belize 2020-05-05 02:32:34 17.1899 -88.4976 18 2 14 2 Belize
3159 3159       Saint Kitts and Nevis 2020-05-05 02:32:34 17.357822 -62.782998 15 0 8 7 Saint Kitts and Nevis
3126 3126       Mali 2020-05-05 02:32:34 17.570692 -3.996166000000001 580 29 223 328 Mali
3142 3142       Niger 2020-05-05 02:32:34 17.607789 8.081666 755 37 534 184 Niger
2998 2998     Saint Barthelemy France 2020-05-05 02:32:34 17.9 -62.8333 6 0 6 0 Saint Barthelemy, France
3007 3007     Sint Maarten Netherlands 2020-05-05 02:32:34 18.0425 -63.0548 76 13 44 19 Sint Maarten, Netherlands
3009 3009     St Martin France 2020-05-05 02:32:34 18.0708 -63.0501 38 3 29 6 St Martin, France
3104 3104       Jamaica 2020-05-05 02:32:34 18.1096 -77.2975 471 9 38 424 Jamaica
2931 2931     Anguilla United Kingdom 2020-05-05 02:32:34 18.2206 -63.0686 3 0 3 0 Anguilla, United Kingdom
2991 2991 72   Puerto Rico US 2020-05-05 02:32:34 18.2208 -66.5901 1843 97 0 1746 Puerto Rico, US
3015 3015 78   Virgin Islands US 2020-05-05 02:32:34 18.3358 -64.8963 66 4 0 62 Virgin Islands, US
2939 2939     British Virgin Islands United Kingdom 2020-05-05 02:32:34 18.4207 -64.64 6 1 3 2 British Virgin Islands, United Kingdom
3069 3069       Dominican Republic 2020-05-05 02:32:34 18.7357 -70.1627 8235 346 1771 6118 Dominican Republic
3092 3092       Haiti 2020-05-05 02:32:34 18.9712 -72.2852 85 8 10 79 Haiti
2961 2961     Hainan China 2020-05-05 02:32:34 19.1959 109.7453 168 6 162 0 Hainan, China
2940 2940     Cayman Islands United Kingdom 2020-05-05 02:32:34 19.3133 -81.2546 75 1 14 60 Cayman Islands, United Kingdom
1117 1117 15001 Hawaii Hawaii US 2020-05-05 02:32:34 19.60121157 -155.5210167 75 0 0 75 Hawaii, Hawaii, US
3113 3113       Laos 2020-05-05 02:32:34 19.856270000000002 102.495496 19 0 9 10 Laos
3097 3097       India 2020-05-05 02:32:34 20.593684 78.96288 46437 1566 12847 32024 India
1675 1675 15009 Maui Hawaii US 2020-05-05 02:32:34 20.86399628 -156.56890969999995 116 6 0 110 Maui, Hawaii, US
3128 3128       Mauritania 2020-05-05 02:32:34 21.0079 -10.9408 8 1 6 1 Mauritania
1170 1170 15003 Honolulu Hawaii US 2020-05-05 02:32:34 21.45803166 -157.97121819999995 400 11 0 389 Honolulu, Hawaii, US
3146 3146       Oman 2020-05-05 02:32:34 21.512583 55.92325500000001 2637 12 816 1809 Oman
3062 3062       Cuba 2020-05-05 02:32:34 21.521757 -77.78116700000002 1668 69 876 723 Cuba
3013 3013     Turks and Caicos Islands United Kingdom 2020-05-05 02:32:34 21.69400000000001 -71.7979 12 1 6 5 Turks and Caicos Islands, United Kingdom

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

CREATE TABLE [05-04-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
);