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,423 rows sorted by Province_State

View and edit SQL

Suggested facets: Last_Update, Last_Update (date)

Link rowid FIPS Admin2 Province_State ▼ Country_Region Last_Update Lat Long_ Confirmed Deaths Recovered Active Combined_Key
3254       Afghanistan 2020-03-25 23:33:04 33.93911 67.709953 76 2 2 80 Afghanistan
3255       Albania 2020-03-25 23:33:04 41.1533 20.1683 146 5 17 124 Albania
3256       Algeria 2020-03-25 23:33:04 28.0339 1.6596 302 21 65 216 Algeria
3257       Andorra 2020-03-25 23:33:04 42.5063 1.5218 188 1 1 186 Andorra
3258       Angola 2020-03-25 23:33:04 -11.2027 17.8739 3 0 0 3 Angola
3259       Antigua and Barbuda 2020-03-25 23:33:04 17.0608 -61.7964 3 0 0 3 Antigua and Barbuda
3260       Argentina 2020-03-25 23:33:04 -38.4161 -63.6167 387 8 52 327 Argentina
3261       Armenia 2020-03-25 23:33:04 40.0691 45.0382 265 0 16 249 Armenia
3262       Austria 2020-03-25 23:33:04 47.5162 14.5501 5588 30 9 5549 Austria
3263       Azerbaijan 2020-03-25 23:33:04 40.1431 47.5769 93 2 10 81 Azerbaijan
3264       Bahamas 2020-03-25 23:33:04 25.025885 -78.035889 5 0 1 4 Bahamas
3265       Bahrain 2020-03-25 23:33:04 26.0275 50.55 419 4 177 238 Bahrain
3266       Bangladesh 2020-03-25 23:33:04 23.685 90.3563 39 5 7 27 Bangladesh
3267       Barbados 2020-03-25 23:33:04 13.1939 -59.5432 18 0 0 18 Barbados
3268       Belarus 2020-03-25 23:33:04 53.7098 27.9534 86 0 29 57 Belarus
3269       Belgium 2020-03-25 23:33:04 50.8333 4.469936 4937 178 547 4212 Belgium
3270       Belize 2020-03-25 23:33:04 17.1899 -88.4976 2 0 0 2 Belize
3271       Benin 2020-03-25 23:33:04 9.3077 2.3158 6 0 0 6 Benin
3272       Bhutan 2020-03-25 23:33:04 27.5142 90.4336 2 0 0 2 Bhutan
3273       Bolivia 2020-03-25 23:33:04 -16.2902 -63.5887 32 0 0 32 Bolivia
3274       Bosnia and Herzegovina 2020-03-25 23:33:04 43.9159 17.6791 176 3 2 171 Bosnia and Herzegovina
3275       Brazil 2020-03-25 23:33:04 -14.235 -51.9253 2554 59 2 2493 Brazil
3276       Brunei 2020-03-25 23:33:04 4.5353 114.7277 109 0 2 107 Brunei
3277       Bulgaria 2020-03-25 23:33:04 42.7339 25.4858 242 3 4 235 Bulgaria
3278       Burkina Faso 2020-03-25 23:33:04 12.2383 -1.5616 146 4 10 132 Burkina Faso
3279       Cabo Verde 2020-03-25 23:33:04 16.5388 -23.0418 4 1 0 3 Cabo Verde
3280       Cambodia 2020-03-25 23:33:04 11.55 104.9167 96 0 10 86 Cambodia
3281       Cameroon 2020-03-25 23:33:04 3.8480000000000003 11.5021 75 1 2 72 Cameroon
3282       Central African Republic 2020-03-25 23:33:04 6.6111 20.9394 3 0 0 3 Central African Republic
3283       Chad 2020-03-25 23:33:04 15.4542 18.7322 3 0 0 3 Chad
3284       Chile 2020-03-25 23:33:04 -35.6751 -71.543 1142 3 22 1117 Chile
3285       Colombia 2020-03-25 23:33:04 4.5709 -74.2973 470 4 8 458 Colombia
3286       Congo (Brazzaville) 2020-03-25 23:33:04 -4.2634 15.2832 4 0 0 4 Congo (Brazzaville)
3287       Congo (Kinshasa) 2020-03-25 23:33:04 -4.322447 15.307045 48 2 0 46 Congo (Kinshasa)
3288       Costa Rica 2020-03-25 23:33:04 9.7489 -83.7534 201 2 2 197 Costa Rica
3289       Cote d'Ivoire 2020-03-25 23:33:04 7.54 -5.5471 80 0 3 77 Cote d'Ivoire
3290       Croatia 2020-03-25 23:33:04 45.1 15.2 442 1 22 419 Croatia
3291       Cuba 2020-03-25 23:33:04 21.521757 -77.78116700000002 57 1 1 55 Cuba
3292       Cyprus 2020-03-25 23:33:04 35.1264 33.4299 132 3 3 126 Cyprus
3293       Czechia 2020-03-25 23:33:04 49.8175 15.472999999999999 1654 6 10 1638 Czechia
3294       Denmark 2020-03-25 23:33:04 56.2639 9.5018 1724 34 1 1689 Denmark
3295       Diamond Princess 2020-03-25 23:33:04 0.0 0.0 712 10 587 115 Diamond Princess
3296       Djibouti 2020-03-25 23:33:04 11.8251 42.5903 11 0 0 11 Djibouti
3297       Dominica 2020-03-25 23:33:04 15.415 -61.371 7 0 0 7 Dominica
3298       Dominican Republic 2020-03-25 23:33:04 18.7357 -70.1627 392 10 3 379 Dominican Republic
3299       Ecuador 2020-03-25 23:33:04 -1.8312 -78.1834 1173 28 3 1142 Ecuador
3300       Egypt 2020-03-25 23:33:04 26.820553000000004 30.802497999999996 456 21 95 340 Egypt
3301       El Salvador 2020-03-25 23:33:04 13.7942 -88.8965 9 0 0 9 El Salvador
3302       Equatorial Guinea 2020-03-25 23:33:04 1.6508 10.2679 9 0 0 9 Equatorial Guinea
3303       Eritrea 2020-03-25 23:33:04 15.1794 39.7823 4 0 0 4 Eritrea
3304       Estonia 2020-03-25 23:33:04 58.5953 25.0136 404 1 8 395 Estonia
3305       Eswatini 2020-03-25 23:33:04 -26.5225 31.4659 4 0 0 4 Eswatini
3306       Ethiopia 2020-03-25 23:33:04 9.145 40.4897 12 0 0 12 Ethiopia
3307       Fiji 2020-03-25 23:33:04 -17.7134 178.065 5 0 0 5 Fiji
3308       Finland 2020-03-25 23:33:04 61.92411 25.748151 880 3 10 867 Finland
3309       France 2020-03-25 23:33:04 46.2276 2.2137 24967 1331 3900 20002 France
3310       Gabon 2020-03-25 23:33:04 -0.8037 11.6094 6 1 0 5 Gabon
3311       Gambia 2020-03-25 23:33:04 13.4432 -15.3101 3 1 0 2 Gambia
3312       Georgia 2020-03-25 23:33:04 42.3154 43.3569 75 0 10 65 Georgia
3313       Germany 2020-03-25 23:33:04 51.165690999999995 10.451526 37323 206 3547 33570 Germany
3314       Ghana 2020-03-25 23:33:04 7.9465 -1.0232 93 4 0 89 Ghana
3315       Greece 2020-03-25 23:33:04 39.0742 21.8243 821 22 36 763 Greece
3316       Grenada 2020-03-25 23:33:04 12.1165 -61.678999999999995 1 0 0 1 Grenada
3317       Guatemala 2020-03-25 23:33:04 15.7835 -90.2308 24 1 4 19 Guatemala
3318       Guinea 2020-03-25 23:33:04 9.9456 -9.6966 4 0 0 4 Guinea
3319       Guinea-Bissau 2020-03-25 23:33:04 11.8037 -15.1804 2 0 0 2 Guinea-Bissau
3320       Guyana 2020-03-25 23:33:04 4.860416000000002 -58.93018000000001 5 1 0 4 Guyana
3321       Haiti 2020-03-25 23:33:04 18.9712 -72.2852 7 0 0 8 Haiti
3322       Holy See 2020-03-25 23:33:04 41.9029 12.4534 4 0 0 4 Holy See
3323       Honduras 2020-03-25 23:33:04 15.2 -86.2419 36 0 0 36 Honduras
3324       Hungary 2020-03-25 23:33:04 47.1625 19.5033 226 10 21 195 Hungary
3325       Iceland 2020-03-25 23:33:04 64.9631 -19.0208 737 2 56 679 Iceland
3326       India 2020-03-25 23:33:04 20.593684 78.96288 657 12 43 602 India
3327       Indonesia 2020-03-25 23:33:04 -0.7893 113.9213 790 58 31 701 Indonesia
3328       Iran 2020-03-25 23:33:04 32.427908 53.68804599999999 27017 2077 9625 15315 Iran
3329       Iraq 2020-03-25 23:33:04 33.223191 43.679291 346 29 103 214 Iraq
3330       Ireland 2020-03-25 23:33:04 53.1424 -7.6921 1564 9 5 1550 Ireland
3331       Israel 2020-03-25 23:33:04 31.046051000000002 34.851612 2468 5 37 2306 Israel
3332       Italy 2020-03-25 23:33:04 41.87194 12.56738 74386 7503 9362 57521 Italy
3333       Jamaica 2020-03-25 23:33:04 18.1096 -77.2975 26 1 2 23 Jamaica
3334       Japan 2020-03-25 23:33:04 36.204824 138.252924 1307 45 310 952 Japan
3335       Jordan 2020-03-25 23:33:04 31.24 36.51 172 0 1 171 Jordan
3336       Kazakhstan 2020-03-25 23:33:04 48.0196 66.9237 81 0 0 81 Kazakhstan
3337       Kenya 2020-03-25 23:33:04 -0.0236 37.9062 28 0 1 27 Kenya
3338       Korea, South 2020-03-25 23:33:04 35.90775700000001 127.766922 9137 126 3730 5281 Korea, South
3339       Kuwait 2020-03-25 23:33:04 29.311659999999996 47.481766 195 0 43 152 Kuwait
3340       Kyrgyzstan 2020-03-25 23:33:04 41.20438 74.766098 44 0 0 44 Kyrgyzstan
3341       Laos 2020-03-25 23:33:04 19.856270000000002 102.495496 3 0 0 3 Laos
3342       Latvia 2020-03-25 23:33:04 56.8796 24.6032 221 0 1 220 Latvia
3343       Lebanon 2020-03-25 23:33:04 33.8547 35.8623 333 6 20 307 Lebanon
3344       Liberia 2020-03-25 23:33:04 6.4280550000000005 -9.429499 3 0 0 3 Liberia
3345       Libya 2020-03-25 23:33:04 26.3351 17.228331 1 0 0 1 Libya
3346       Liechtenstein 2020-03-25 23:33:04 47.14 9.55 51 0 0 51 Liechtenstein
3347       Lithuania 2020-03-25 23:33:04 55.1694 23.8813 208 2 0 269 Lithuania
3348       Luxembourg 2020-03-25 23:33:04 49.8153 6.1296 1333 8 6 1319 Luxembourg
3349       Madagascar 2020-03-25 23:33:04 -18.766947000000002 46.869107 19 0 0 19 Madagascar
3350       Malaysia 2020-03-25 23:33:04 4.210483999999999 101.97576600000001 1796 20 199 1577 Malaysia
3351       Maldives 2020-03-25 23:33:04 3.2028 73.2207 13 0 8 5 Maldives
3352       Mali 2020-03-25 23:33:04 17.570692 -3.996166000000001 2 0 0 2 Mali
3353       Malta 2020-03-25 23:33:04 35.9375 14.3754 129 0 2 127 Malta

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

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