04-24-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,128 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
3104 3104       Timor-Leste 2020-04-25 06:30:33 -8.874217 125.727539 24 0 2 22 Timor-Leste
3102 3102       Tanzania 2020-04-25 06:30:33 -6.369028 34.888822 299 10 48 241 Tanzania
3067 3067       Papua New Guinea 2020-04-25 06:30:33 -6.314993 143.95555 8 0 0 8 Papua New Guinea
3086 3086       Seychelles 2020-04-25 06:30:33 -4.6796 55.492 11 0 6 5 Seychelles
2976 2976       Congo (Kinshasa) 2020-04-25 06:30:33 -4.322447 15.307045 394 25 48 321 Congo (Kinshasa)
2975 2975       Congo (Brazzaville) 2020-04-25 06:30:33 -4.2634 15.2832 200 6 19 175 Congo (Brazzaville)
2967 2967       Burundi 2020-04-25 06:30:33 -3.3731 29.9189 11 1 4 6 Burundi
3076 3076       Rwanda 2020-04-25 06:30:33 -1.9403 29.8739 176 0 87 89 Rwanda
2988 2988       Ecuador 2020-04-25 06:30:33 -1.8312 -78.1834 22719 576 1366 20777 Ecuador
2999 2999       Gabon 2020-04-25 06:30:33 -0.8037 11.6094 172 3 26 143 Gabon
3016 3016       Indonesia 2020-04-25 06:30:33 -0.7893 113.9213 8211 689 1002 6520 Indonesia
3026 3026       Kenya 2020-04-25 06:30:33 -0.0236 37.9062 336 14 94 228 Kenya
3082 3082       Sao Tome and Principe 2020-04-25 06:30:33 0.18636 6.613081 4 0 0 4 Sao Tome and Principe
3088 3088       Singapore 2020-04-25 06:30:33 1.2833 103.8333 12075 12 956 11107 Singapore
3109 3109       Uganda 2020-04-25 06:30:33 1.373333 32.290275 75 0 46 29 Uganda
2991 2991       Equatorial Guinea 2020-04-25 06:30:33 1.6508 10.2679 214 1 7 206 Equatorial Guinea
3043 3043       Maldives 2020-04-25 06:30:33 3.2028 73.2207 129 0 16 113 Maldives
2970 2970       Cameroon 2020-04-25 06:30:33 3.8480000000000003 11.5021 1430 43 668 719 Cameroon
3097 3097       Suriname 2020-04-25 06:30:33 3.9193 -56.0278 10 1 7 2 Suriname
2878 2878     French Guiana France 2020-04-25 06:30:33 4.0 -53.0 111 1 87 23 French Guiana, France
3042 3042       Malaysia 2020-04-25 06:30:33 4.210483999999999 101.97576600000001 5691 96 3663 1932 Malaysia
2963 2963       Brunei 2020-04-25 06:30:33 4.5353 114.7277 138 1 120 17 Brunei
2974 2974       Colombia 2020-04-25 06:30:33 4.5709 -74.2973 4881 225 1003 3653 Colombia
3009 3009       Guyana 2020-04-25 06:30:33 4.860416000000002 -58.93018000000001 73 7 12 54 Guyana
3091 3091       Somalia 2020-04-25 06:30:33 5.152149 46.199616 328 16 8 304 Somalia
3115 3115       Venezuela 2020-04-25 06:30:33 6.4238 -66.5897 318 10 132 176 Venezuela
3034 3034       Liberia 2020-04-25 06:30:33 6.4280550000000005 -9.429499 117 8 25 84 Liberia
2971 2971       Central African Republic 2020-04-25 06:30:33 6.6111 20.9394 16 0 10 6 Central African Republic
3093 3093       South Sudan 2020-04-25 06:30:33 6.8770000000000024 31.307 5 0 0 5 South Sudan
2978 2978       Cote d'Ivoire 2020-04-25 06:30:33 7.54 -5.5471 1077 14 419 644 Cote d'Ivoire
3095 3095       Sri Lanka 2020-04-25 06:30:33 7.873054 80.77179699999998 420 7 109 304 Sri Lanka
3003 3003       Ghana 2020-04-25 06:30:33 7.9465 -1.0232 1279 10 134 1135 Ghana
3087 3087       Sierra Leone 2020-04-25 06:30:33 8.460555000000001 -11.779889 82 2 10 70 Sierra Leone
3066 3066       Panama 2020-04-25 06:30:33 8.538 -80.7821 5338 154 319 4865 Panama
3105 3105       Togo 2020-04-25 06:30:33 8.6195 0.8248 90 6 59 25 Togo
3061 3061       Nigeria 2020-04-25 06:30:33 9.082 8.6753 1095 32 208 855 Nigeria
2995 2995       Ethiopia 2020-04-25 06:30:33 9.145 40.4897 117 3 25 89 Ethiopia
2957 2957       Benin 2020-04-25 06:30:33 9.3077 2.3158 54 1 27 26 Benin
2977 2977       Costa Rica 2020-04-25 06:30:33 9.7489 -83.7534 687 6 216 465 Costa Rica
3007 3007       Guinea 2020-04-25 06:30:33 9.9456 -9.6966 954 6 191 757 Guinea
3106 3106       Trinidad and Tobago 2020-04-25 06:30:33 10.6918 -61.2225 115 8 48 59 Trinidad and Tobago
2969 2969       Cambodia 2020-04-25 06:30:33 11.55 104.9167 122 0 117 5 Cambodia
3008 3008       Guinea-Bissau 2020-04-25 06:30:33 11.8037 -15.1804 52 0 3 49 Guinea-Bissau
2985 2985       Djibouti 2020-04-25 06:30:33 11.8251 42.5903 999 2 330 667 Djibouti
3005 3005       Grenada 2020-04-25 06:30:33 12.1165 -61.678999999999995 15 0 7 8 Grenada
2873 2873     Curacao Netherlands 2020-04-25 06:30:33 12.1696 -68.99 16 1 11 4 Curacao, Netherlands
2867 2867     Bonaire, Sint Eustatius and Saba Netherlands 2020-04-25 06:30:33 12.1784 -68.2385 5 0 0 5 Bonaire, Sint Eustatius and Saba, Netherlands
2965 2965       Burkina Faso 2020-04-25 06:30:33 12.2383 -1.5616 629 41 425 163 Burkina Faso
2864 2864     Aruba Netherlands 2020-04-25 06:30:33 12.5211 -69.9683 100 2 69 29 Aruba, Netherlands
3096 3096       Sudan 2020-04-25 06:30:33 12.8628 30.2176 174 16 14 144 Sudan
3059 3059       Nicaragua 2020-04-25 06:30:33 12.865416 -85.207229 11 3 7 1 Nicaragua
3070 3070       Philippines 2020-04-25 06:30:33 12.879721 121.77401699999999 7192 477 762 5953 Philippines
3079 3079       Saint Vincent and the Grenadines 2020-04-25 06:30:33 12.9843 -61.2872 14 0 5 9 Saint Vincent and the Grenadines
2953 2953       Barbados 2020-04-25 06:30:33 13.1939 -59.5432 77 6 31 40 Barbados
3000 3000       Gambia 2020-04-25 06:30:33 13.4432 -15.3101 10 1 8 1 Gambia
2886 2886 66   Guam US 2020-04-25 06:30:53 13.4443 144.7937 141 5 0 136 Guam, US
2990 2990       El Salvador 2020-04-25 06:30:33 13.7942 -88.8965 274 8 75 191 El Salvador
3078 3078       Saint Lucia 2020-04-25 06:30:33 13.9094 -60.9789 15 0 15 0 Saint Lucia
3116 3116       Vietnam 2020-04-25 06:30:33 14.058323999999999 108.277199 270 0 220 50 Vietnam
3084 3084       Senegal 2020-04-25 06:30:33 14.4974 -14.4524 545 7 262 276 Senegal
2905 2905     Martinique France 2020-04-25 06:30:33 14.6415 -61.0242 170 14 77 79 Martinique, France
2912 2912 69   Northern Mariana Islands US 2020-04-25 06:30:53 15.0979 145.6739 14 2 0 12 Northern Mariana Islands, US
2992 2992       Eritrea 2020-04-25 06:30:33 15.1794 39.7823 39 0 11 28 Eritrea
3012 3012       Honduras 2020-04-25 06:30:33 15.2 -86.2419 591 55 58 478 Honduras
2986 2986       Dominica 2020-04-25 06:30:33 15.415 -61.371 16 0 10 6 Dominica
2972 2972       Chad 2020-04-25 06:30:33 15.4542 18.7322 40 0 8 32 Chad
3118 3118       Yemen 2020-04-25 06:30:33 15.552726999999999 48.516388 1 0 0 0 Yemen
3006 3006       Guatemala 2020-04-25 06:30:33 15.7835 -90.2308 430 11 30 389 Guatemala
3103 3103       Thailand 2020-04-25 06:30:33 15.870032 100.992541 2854 50 2490 309 Thailand
2885 2885     Guadeloupe France 2020-04-25 06:30:33 16.265 -61.551 149 12 82 55 Guadeloupe, France
2968 2968       Cabo Verde 2020-04-25 06:30:33 16.5388 -23.0418 88 1 1 86 Cabo Verde
2907 2907     Montserrat United Kingdom 2020-04-25 06:30:33 16.742498 -62.187366000000004 11 1 2 8 Montserrat, United Kingdom
2945 2945       Antigua and Barbuda 2020-04-25 06:30:33 17.0608 -61.7964 24 3 11 10 Antigua and Barbuda
2956 2956       Belize 2020-04-25 06:30:33 17.1899 -88.4976 18 2 5 11 Belize
3077 3077       Saint Kitts and Nevis 2020-04-25 06:30:33 17.357822 -62.782998 15 0 2 13 Saint Kitts and Nevis
3044 3044       Mali 2020-04-25 06:30:33 17.570692 -3.996166000000001 325 21 87 217 Mali
3060 3060       Niger 2020-04-25 06:30:33 17.607789 8.081666 681 24 289 368 Niger
2922 2922     Saint Barthelemy France 2020-04-25 06:30:33 17.9 -62.8333 6 0 6 0 Saint Barthelemy, France
2930 2930     Sint Maarten Netherlands 2020-04-25 06:30:33 18.0425 -63.0548 73 12 22 39 Sint Maarten, Netherlands
2931 2931     St Martin France 2020-04-25 06:30:33 18.0708 -63.0501 38 3 24 11 St Martin, France
3022 3022       Jamaica 2020-04-25 06:30:33 18.1096 -77.2975 288 7 28 253 Jamaica
2862 2862     Anguilla United Kingdom 2020-04-25 06:30:33 18.2206 -63.0686 3 0 1 2 Anguilla, United Kingdom
2916 2916 72   Puerto Rico US 2020-04-25 06:30:53 18.2208 -66.5901 1276 77 0 1199 Puerto Rico, US
2935 2935 78   Virgin Islands US 2020-04-25 06:30:53 18.3358 -64.8963 54 3 0 51 Virgin Islands, US
2869 2869     British Virgin Islands United Kingdom 2020-04-25 06:30:33 18.4207 -64.64 5 1 3 1 British Virgin Islands, United Kingdom
2987 2987       Dominican Republic 2020-04-25 06:30:33 18.7357 -70.1627 5749 267 763 4719 Dominican Republic
3010 3010       Haiti 2020-04-25 06:30:33 18.9712 -72.2852 62 4 6 60 Haiti
2890 2890     Hainan China 2020-03-24 04:19:14 19.1959 109.7453 168 6 162 0 Hainan, China
2870 2870     Cayman Islands United Kingdom 2020-04-25 06:30:33 19.3133 -81.2546 70 1 8 61 Cayman Islands, United Kingdom
1087 1087 15001 Hawaii Hawaii US 2020-04-25 06:30:53 19.60121157 -155.5210167 69 0 0 69 Hawaii, Hawaii, US
3031 3031       Laos 2020-04-25 06:30:33 19.856270000000002 102.495496 19 0 4 15 Laos
3015 3015       India 2020-04-25 06:30:33 20.593684 78.96288 24530 780 5498 18252 India
1633 1633 15009 Maui Hawaii US 2020-04-25 06:30:53 20.86399628 -156.56890969999995 113 5 0 108 Maui, Hawaii, US
3046 3046       Mauritania 2020-04-25 06:30:33 21.0079 -10.9408 7 1 6 0 Mauritania
1138 1138 15003 Honolulu Hawaii US 2020-04-25 06:30:53 21.45803166 -157.97121819999995 392 8 0 384 Honolulu, Hawaii, US
3064 3064       Oman 2020-04-25 06:30:33 21.512583 55.92325500000001 1790 10 325 1455 Oman
2980 2980       Cuba 2020-04-25 06:30:33 21.521757 -77.78116700000002 1285 49 416 820 Cuba
2934 2934     Turks and Caicos Islands United Kingdom 2020-04-25 06:30:33 21.69400000000001 -71.7979 11 1 4 6 Turks and Caicos Islands, United Kingdom
2966 2966       Burma 2020-04-25 06:30:33 21.9162 95.956 144 5 9 130 Burma
1305 1305 15007 Kauai Hawaii US 2020-04-25 06:30:53 22.03935037 -159.5966786 21 0 0 21 Kauai, Hawaii, US

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

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