03-29-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,437 rows sorted by rowid descending

✎ 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
3337 3337       India 3/29/20 23:08 20.593684 78.96288 1024 27 95 902 India
3336 3336       Iceland 3/29/20 23:08 64.9631 -19.0208 1020 2 135 883 Iceland
3335 3335       Hungary 3/29/20 23:08 47.1625 19.5033 408 13 34 361 Hungary
3334 3334       Honduras 3/29/20 23:08 15.2 -86.2419 110 3 3 104 Honduras
3333 3333       Holy See 3/29/20 23:08 41.9029 12.4534 6 0 0 6 Holy See
3332 3332       Haiti 3/29/20 23:08 18.9712 -72.2852 8 0 1 14 Haiti
3331 3331       Guyana 3/29/20 23:08 4.860416 -58.93018 8 1 0 7 Guyana
3330 3330       Guinea-Bissau 3/29/20 23:08 11.8037 -15.1804 2 0 0 2 Guinea-Bissau
3329 3329       Guinea 3/29/20 23:08 9.9456 -9.6966 16 0 0 16 Guinea
3328 3328       Guatemala 3/29/20 23:08 15.7835 -90.2308 34 1 10 23 Guatemala
3327 3327       Grenada 3/29/20 23:08 12.1165 -61.679 9 0 0 9 Grenada
3326 3326       Greece 3/29/20 23:08 39.0742 21.8243 1156 38 52 1066 Greece
3325 3325       Ghana 3/29/20 23:08 7.9465 -1.0232 152 5 2 145 Ghana
3324 3324       Germany 3/29/20 23:08 51.165691 10.451526 62095 533 9211 52351 Germany
3323 3323       Georgia 3/29/20 23:08 42.3154 43.3569 91 0 18 73 Georgia
3322 3322       Gambia 3/29/20 23:08 13.4432 -15.3101 4 1 0 3 Gambia
3321 3321       Gabon 3/29/20 23:08 -0.8037 11.6094 7 1 0 6 Gabon
3320 3320       France 3/29/20 23:08 46.2276 2.2137 39761 2603 7202 30366 France
3319 3319       Finland 3/29/20 23:08 61.92411 25.748151 1240 11 10 1219 Finland
3318 3318       Fiji 3/29/20 23:08 -17.7134 178.065 5 0 0 5 Fiji
3317 3317       Ethiopia 3/29/20 23:08 9.145 40.4897 21 0 1 20 Ethiopia
3316 3316       Eswatini 3/29/20 23:08 -26.5225 31.4659 9 0 0 9 Eswatini
3315 3315       Estonia 3/29/20 23:08 58.5953 25.0136 679 3 20 656 Estonia
3314 3314       Eritrea 3/29/20 23:08 15.1794 39.7823 12 0 0 12 Eritrea
3313 3313       Equatorial Guinea 3/29/20 23:08 1.6508 10.2679 12 0 0 12 Equatorial Guinea
3312 3312       El Salvador 3/29/20 23:08 13.7942 -88.8965 24 0 0 24 El Salvador
3311 3311       Egypt 3/29/20 23:08 26.820553 30.802498 609 40 132 437 Egypt
3310 3310       Ecuador 3/29/20 23:08 -1.8312 -78.1834 1924 58 3 1863 Ecuador
3309 3309       Dominican Republic 3/29/20 23:08 18.7357 -70.1627 859 39 3 817 Dominican Republic
3308 3308       Dominica 3/29/20 23:08 15.415 -61.371 11 0 0 11 Dominica
3307 3307       Djibouti 3/29/20 23:08 11.8251 42.5903 18 0 0 18 Djibouti
3306 3306       Diamond Princess 3/29/20 23:08 0.0 0.0 712 10 603 99 Diamond Princess
3305 3305       Denmark 3/29/20 23:08 56.2639 9.5018 2395 72 1 2322 Denmark
3304 3304       Czechia 3/29/20 23:08 49.8175 15.473 2817 16 11 2790 Czechia
3303 3303       Cyprus 3/29/20 23:08 35.1264 33.4299 214 5 15 194 Cyprus
3302 3302       Cuba 3/29/20 23:08 21.521757 -77.781167 139 3 4 132 Cuba
3301 3301       Croatia 3/29/20 23:08 45.1 15.2 713 6 52 655 Croatia
3300 3300       Cote d'Ivoire 3/29/20 23:08 7.54 -5.5471 165 1 4 160 Cote d'Ivoire
3299 3299       Costa Rica 3/29/20 23:08 9.7489 -83.7534 314 2 3 309 Costa Rica
3298 3298       Congo (Kinshasa) 3/29/20 23:08 -4.322447 15.307045 65 6 2 57 Congo (Kinshasa)
3297 3297       Congo (Brazzaville) 3/29/20 23:08 -4.2634 15.2832 19 0 0 19 Congo (Brazzaville)
3296 3296       Colombia 3/29/20 23:08 4.5709 -74.2973 702 10 10 682 Colombia
3295 3295       Chile 3/29/20 23:08 -35.6751 -71.543 2139 7 75 2057 Chile
3294 3294       Chad 3/29/20 23:08 15.4542 18.7322 3 0 0 3 Chad
3293 3293       Central African Republic 3/29/20 23:08 6.6111 20.9394 3 0 0 3 Central African Republic
3292 3292       Cameroon 3/29/20 23:08 3.848 11.5021 139 6 5 128 Cameroon
3291 3291       Cambodia 3/29/20 23:08 11.55 104.9167 103 0 21 82 Cambodia
3290 3290       Cabo Verde 3/29/20 23:08 16.5388 -23.0418 6 1 0 5 Cabo Verde
3289 3289       Burma 3/29/20 23:08 21.9162 95.956 10 0 0 10 Burma
3288 3288       Burkina Faso 3/29/20 23:08 12.2383 -1.5616 222 12 23 187 Burkina Faso
3287 3287       Bulgaria 3/29/20 23:08 42.7339 25.4858 346 8 14 324 Bulgaria
3286 3286       Brunei 3/29/20 23:08 4.5353 114.7277 126 1 34 91 Brunei
3285 3285       Brazil 3/29/20 23:08 -14.235 -51.9253 4256 136 6 4114 Brazil
3284 3284       Bosnia and Herzegovina 3/29/20 23:08 43.9159 17.6791 323 6 8 309 Bosnia and Herzegovina
3283 3283       Bolivia 3/29/20 23:08 -16.2902 -63.5887 81 1 0 80 Bolivia
3282 3282       Bhutan 3/29/20 23:08 27.5142 90.4336 4 0 0 4 Bhutan
3281 3281       Benin 3/29/20 23:08 9.3077 2.3158 6 0 0 6 Benin
3280 3280       Belize 3/29/20 23:08 17.1899 -88.4976 2 0 0 2 ,,Belize
3279 3279       Belgium 3/29/20 23:08 50.8333 4.469936 10836 431 1359 9046 Belgium
3278 3278       Belarus 3/29/20 23:08 53.7098 27.9534 94 0 32 62 Belarus
3277 3277       Barbados 3/29/20 23:08 13.1939 -59.5432 33 0 0 33 Barbados
3276 3276       Bangladesh 3/29/20 23:08 23.685 90.3563 48 5 15 28 Bangladesh
3275 3275       Bahrain 3/29/20 23:08 26.0275 50.55 499 4 272 223 Bahrain
3274 3274       Bahamas 3/29/20 23:08 25.025885 -78.035889 11 0 1 10 Bahamas
3273 3273       Azerbaijan 3/29/20 23:08 40.1431 47.5769 209 4 15 190 Azerbaijan
3272 3272       Austria 3/29/20 23:08 47.5162 14.5501 8788 86 479 8223 Austria
3271 3271       Armenia 3/29/20 23:08 40.0691 45.0382 424 3 30 391 Armenia
3270 3270       Argentina 3/29/20 23:08 -38.4161 -63.6167 745 19 72 654 Argentina
3269 3269       Antigua and Barbuda 3/29/20 23:08 17.0608 -61.7964 7 0 0 7 Antigua and Barbuda
3268 3268       Angola 3/29/20 23:08 -11.2027 17.8739 7 2 0 5 Angola
3267 3267       Andorra 3/29/20 23:08 42.5063 1.5218 334 6 1 327 Andorra
3266 3266       Algeria 3/29/20 23:08 28.0339 1.6596 511 31 31 449 Algeria
3265 3265       Albania 3/29/20 23:08 41.1533 20.1683 212 10 33 169 Albania
3264 3264       Afghanistan 3/29/20 23:08 33.93911 67.709953 118 4 2 114 Afghanistan
3263 3263     Zhejiang China 3/29/20 2:22 29.1832 120.0934 1254 1 1225 28 Zhejiang, China
3262 3262     Yunnan China 3/26/20 23:16 24.974 101.487 180 2 172 6 Yunnan, China
3261 3261     Yukon Canada 3/29/20 23:13 64.2823 -135.0 4 0 0 0 ,Yukon,Canada
3260 3260     Xinjiang China 3/8/20 5:31 41.1129 85.2401 76 3 73 0 Xinjiang, China
3259 3259     Western Australia Australia 3/29/20 23:14 -31.9505 115.8605 311 2 28 281 Western Australia, Australia
3258 3258 78000   Virgin Islands US 3/29/20 23:08 18.3358 -64.8963 23 0 0 0 Virgin Islands, US
3257 3257     Victoria Australia 3/29/20 23:14 -37.8136 144.9631 769 4 191 574 Victoria, Australia
3256 3256     Turks and Caicos Islands United Kingdom 3/29/20 23:08 21.694 -71.7979 4 0 0 4 Turks and Caicos Islands, United Kingdom
3255 3255     Tibet China 2/23/20 11:19 31.6927 88.0924 1 0 1 0 Tibet, China
3254 3254     Tianjin China 3/29/20 6:13 39.3054 117.323 166 3 133 30 Tianjin, China
3253 3253     Tasmania Australia 3/29/20 23:14 -42.8821 147.3272 66 0 5 61 Tasmania, Australia
3252 3252     St Martin France 3/29/20 23:08 18.0708 -63.0501 11 0 0 11 St Martin, France
3251 3251     South Australia Australia 3/29/20 23:14 -34.9285 138.6007 299 0 6 293 South Australia, Australia
3250 3250     Sint Maarten Netherlands 3/29/20 23:08 18.0425 -63.0548 6 0 0 6 Sint Maarten, Netherlands
3249 3249     Sichuan China 3/29/20 1:49 30.6171 102.7103 550 3 536 11 Sichuan, China
3248 3248     Shanxi China 3/29/20 0:20 37.5777 112.2922 136 0 133 3 Shanxi, China
3247 3247     Shanghai China 3/29/20 2:09 31.202 121.4491 492 5 334 153 Shanghai, China
3246 3246     Shandong China 3/27/20 7:48 36.3427 118.1498 772 7 752 13 Shandong, China
3245 3245     Shaanxi China 3/26/20 2:14 35.1917 108.8701 253 3 242 8 Shaanxi, China
3244 3244     Saskatchewan Canada 3/29/20 23:13 52.9399 -106.4509 156 0 0 0 Saskatchewan, Canada
3243 3243     Saint Helena, Ascension and Tristan da Cunha United Kingdom 3/29/20 23:08 -7.9467 -14.3559 0 0 0 0 Saint Helena, Ascension and Tristan da Cunha, United Kingdom
3242 3242     Saint Barthelemy France 3/29/20 23:08 17.9 -62.8333 5 0 0 5 Saint Barthelemy, France
3241 3241     Reunion France 3/29/20 23:08 -21.1151 55.5364 183 0 1 182 Reunion, France
3240 3240     Recovered US 3/29/20 23:08 0.0 0.0 0 0 2665 0 Recovered, US
3239 3239     Recovered Canada 3/29/20 23:13 0.0 0.0 0 0 466 0 Recovered, Canada
3238 3238     Queensland Australia 3/29/20 23:14 -27.4698 153.0251 656 2 8 646 Queensland, Australia

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

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