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

View and edit SQL

Link rowid FIPS Admin2 Province_State ▼ Country_Region Last_Update Lat Long_ Confirmed Deaths Recovered Active Combined_Key
3260       Afghanistan 3/28/20 23:05 33.93911 67.709953 107 4 2 104 Afghanistan
3261       Albania 3/28/20 23:05 41.1533 20.1683 197 10 31 156 Albania
3262       Algeria 3/28/20 23:05 28.0339 1.6596 454 29 31 394 Algeria
3263       Andorra 3/28/20 23:05 42.5063 1.5218 308 3 1 304 Andorra
3264       Angola 3/28/20 23:05 -11.2027 17.8739 5 0 0 5 Angola
3265       Antigua and Barbuda 3/28/20 23:05 17.0608 -61.7964 7 0 0 7 Antigua and Barbuda
3266       Argentina 3/28/20 23:05 -38.4161 -63.6167 690 18 72 600 Argentina
3267       Armenia 3/28/20 23:05 40.0691 45.0382 407 1 30 376 Armenia
3268       Austria 3/28/20 23:05 47.5162 14.5501 8271 68 225 7978 Austria
3269       Azerbaijan 3/28/20 23:05 40.1431 47.5769 182 4 15 163 Azerbaijan
3270       Bahamas 3/28/20 23:05 25.025885 -78.035889 10 0 1 9 Bahamas
3271       Bahrain 3/28/20 23:05 26.0275 50.55 476 4 265 207 Bahrain
3272       Bangladesh 3/28/20 23:05 23.685 90.3563 48 5 15 28 Bangladesh
3273       Barbados 3/28/20 23:05 13.1939 -59.5432 26 0 0 26 Barbados
3274       Belarus 3/28/20 23:05 53.7098 27.9534 94 0 32 62 Belarus
3275       Belgium 3/28/20 23:05 50.8333 4.469936 9134 353 1063 7718 Belgium
3276       Belize 3/28/20 23:05 17.1899 -88.4976 2 0 0 2 ,,Belize
3277       Benin 3/28/20 23:05 9.3077 2.3158 6 0 0 6 Benin
3278       Bhutan 3/28/20 23:05 27.5142 90.4336 3 0 0 3 Bhutan
3279       Bolivia 3/28/20 23:05 -16.2902 -63.5887 74 0 0 74 Bolivia
3280       Bosnia and Herzegovina 3/28/20 23:05 43.9159 17.6791 258 5 5 248 Bosnia and Herzegovina
3281       Brazil 3/28/20 23:05 -14.235 -51.9253 3904 111 6 3787 Brazil
3282       Brunei 3/28/20 23:05 4.5353 114.7277 120 1 25 94 Brunei
3283       Bulgaria 3/28/20 23:05 42.7339 25.4858 331 7 11 313 Bulgaria
3284       Burkina Faso 3/28/20 23:05 12.2383 -1.5616 207 11 21 175 Burkina Faso
3285       Burma 3/28/20 23:05 21.9162 95.956 8 0 0 8 Burma
3286       Cabo Verde 3/28/20 23:05 16.5388 -23.0418 5 1 0 4 Cabo Verde
3287       Cambodia 3/28/20 23:05 11.55 104.9167 99 0 13 86 Cambodia
3288       Cameroon 3/28/20 23:05 3.848 11.5021 91 2 2 87 Cameroon
3289       Central African Republic 3/28/20 23:05 6.6111 20.9394 3 0 0 3 Central African Republic
3290       Chad 3/28/20 23:05 15.4542 18.7322 3 0 0 3 Chad
3291       Chile 3/28/20 23:05 -35.6751 -71.543 1909 6 61 1842 Chile
3292       Colombia 3/28/20 23:05 4.5709 -74.2973 608 6 10 592 Colombia
3293       Congo (Brazzaville) 3/28/20 23:05 -4.2634 15.2832 4 0 0 4 Congo (Brazzaville)
3294       Congo (Kinshasa) 3/28/20 23:05 -4.322447 15.307045 65 6 2 57 Congo (Kinshasa)
3295       Costa Rica 3/28/20 23:05 9.7489 -83.7534 295 2 3 290 Costa Rica
3296       Cote d'Ivoire 3/28/20 23:05 7.54 -5.5471 101 0 3 98 Cote d'Ivoire
3297       Croatia 3/28/20 23:05 45.1 15.2 657 5 45 607 Croatia
3298       Cuba 3/28/20 23:05 21.521757 -77.781167 119 3 4 112 Cuba
3299       Cyprus 3/28/20 23:05 35.1264 33.4299 179 5 15 159 Cyprus
3300       Czechia 3/28/20 23:05 49.8175 15.473 2631 11 11 2609 Czechia
3301       Denmark 3/28/20 23:05 56.2639 9.5018 2201 65 1 2135 Denmark
3302       Diamond Princess 3/28/20 23:05 0.0 0.0 712 10 597 105 Diamond Princess
3303       Djibouti 3/28/20 23:05 11.8251 42.5903 14 0 0 14 Djibouti
3304       Dominica 3/28/20 23:05 15.415 -61.371 11 0 0 11 Dominica
3305       Dominican Republic 3/28/20 23:05 18.7357 -70.1627 719 28 3 688 Dominican Republic
3306       Ecuador 3/28/20 23:05 -1.8312 -78.1834 1823 48 3 1772 Ecuador
3307       Egypt 3/28/20 23:05 26.820553 30.802498 576 36 121 419 Egypt
3308       El Salvador 3/28/20 23:05 13.7942 -88.8965 19 0 0 19 El Salvador
3309       Equatorial Guinea 3/28/20 23:05 1.6508 10.2679 12 0 0 12 Equatorial Guinea
3310       Eritrea 3/28/20 23:05 15.1794 39.7823 6 0 0 6 Eritrea
3311       Estonia 3/28/20 23:05 58.5953 25.0136 645 1 20 624 Estonia
3312       Eswatini 3/28/20 23:05 -26.5225 31.4659 9 0 0 9 Eswatini
3313       Ethiopia 3/28/20 23:05 9.145 40.4897 16 0 1 15 Ethiopia
3314       Fiji 3/28/20 23:05 -17.7134 178.065 5 0 0 5 Fiji
3315       Finland 3/28/20 23:05 61.92411 25.748151 1167 9 10 1148 Finland
3316       France 3/28/20 23:05 46.2276 2.2137 37162 2311 5700 29561 France
3317       Gabon 3/28/20 23:05 -0.8037 11.6094 7 1 0 6 Gabon
3318       Gambia 3/28/20 23:05 13.4432 -15.3101 3 1 0 2 Gambia
3319       Georgia 3/28/20 23:05 42.3154 43.3569 90 0 14 76 Georgia
3320       Germany 3/28/20 23:05 51.165691 10.451526 57695 433 8481 48781 Germany
3321       Ghana 3/28/20 23:05 7.9465 -1.0232 141 5 2 134 Ghana
3322       Greece 3/28/20 23:05 39.0742 21.8243 1061 32 52 977 Greece
3323       Grenada 3/28/20 23:05 12.1165 -61.679 7 0 0 7 Grenada
3324       Guatemala 3/28/20 23:05 15.7835 -90.2308 34 1 10 23 Guatemala
3325       Guinea 3/28/20 23:05 9.9456 -9.6966 8 0 0 8 Guinea
3326       Guinea-Bissau 3/28/20 23:05 11.8037 -15.1804 2 0 0 2 Guinea-Bissau
3327       Guyana 3/28/20 23:05 4.860416 -58.93018 8 1 0 7 Guyana
3328       Haiti 3/28/20 23:05 18.9712 -72.2852 8 0 0 8 Haiti
3329       Holy See 3/28/20 23:05 41.9029 12.4534 6 0 0 6 Holy See
3330       Honduras 3/28/20 23:05 15.2 -86.2419 95 1 3 91 Honduras
3331       Hungary 3/28/20 23:05 47.1625 19.5033 343 11 34 298 Hungary
3332       Iceland 3/28/20 23:05 64.9631 -19.0208 963 2 114 847 Iceland
3333       India 3/28/20 23:05 20.593684 78.96288 987 24 84 879 India
3334       Indonesia 3/28/20 23:05 -0.7893 113.9213 1155 102 59 994 Indonesia
3335       Iran 3/28/20 23:05 32.427908 53.688046 35408 2517 11679 21212 Iran
3336       Iraq 3/28/20 23:05 33.223191 43.679291 506 42 131 333 Iraq
3337       Ireland 3/28/20 23:05 53.1424 -7.6921 2415 36 5 2374 Ireland
3338       Israel 3/28/20 23:05 31.046051 34.851612 3901 13 84 3518 Israel
3339       Italy 3/28/20 23:05 41.87194 12.56738 92472 10023 12384 70065 Italy
3340       Jamaica 3/28/20 23:05 18.1096 -77.2975 30 1 2 27 Jamaica
3341       Japan 3/28/20 23:05 36.204824 138.252924 1693 52 404 1237 Japan
3342       Jordan 3/28/20 23:05 31.24 36.51 246 1 18 227 Jordan
3343       Kazakhstan 3/28/20 23:05 48.0196 66.9237 228 1 16 211 Kazakhstan
3344       Kenya 3/28/20 23:05 -0.0236 37.9062 38 1 1 36 Kenya
3345       Korea, South 3/28/20 23:05 35.907757 127.766922 9478 144 4811 4523 Korea, South
3346       Kosovo 3/28/20 23:05 42.602636 20.902977 91 1 1 89 Kosovo
3347       Kuwait 3/28/20 23:05 29.31166 47.481766 235 0 64 171 Kuwait
3348       Kyrgyzstan 3/28/20 23:05 41.20438 74.766098 58 0 0 58 Kyrgyzstan
3349       Laos 3/28/20 23:05 19.85627 102.495496 8 0 0 8 Laos
3350       Latvia 3/28/20 23:05 56.8796 24.6032 305 0 1 304 Latvia
3351       Lebanon 3/28/20 23:05 33.8547 35.8623 412 8 30 374 Lebanon
3352       Liberia 3/28/20 23:05 6.428055 -9.429499 3 0 0 3 Liberia
3353       Libya 3/28/20 23:05 26.3351 17.228331 3 0 0 3 Libya
3354       Liechtenstein 3/28/20 23:05 47.14 9.55 56 0 0 56 Liechtenstein
3355       Lithuania 3/28/20 23:05 55.1694 23.8813 339 4 0 386 Lithuania
3356       Luxembourg 3/28/20 23:05 49.8153 6.1296 1831 18 40 1773 Luxembourg
3357       MS Zaandam 3/28/20 23:05 0.0 0.0 2 0 0 2 ,,MS Zaandam
3358       Madagascar 3/28/20 23:05 -18.766947 46.869107 26 0 0 26 Madagascar
3359       Malaysia 3/28/20 23:05 4.210484 101.975766 2320 27 320 1973 Malaysia

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

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