03-30-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,442 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
3342 3342       India 3/30/20 22:52 20.593684 78.96288 1251 32 102 1117 India
3341 3341       Iceland 3/30/20 22:52 64.9631 -19.0208 1086 2 157 927 Iceland
3340 3340       Hungary 3/30/20 22:52 47.1625 19.5033 447 15 34 398 Hungary
3339 3339       Honduras 3/30/20 22:52 15.2 -86.2419 139 7 3 129 Honduras
3338 3338       Holy See 3/30/20 22:52 41.9029 12.4534 6 0 0 6 Holy See
3337 3337       Haiti 3/30/20 22:52 18.9712 -72.2852 15 0 1 14 Haiti
3336 3336       Guyana 3/30/20 22:52 4.860416 -58.93018 8 1 0 7 Guyana
3335 3335       Guinea-Bissau 3/30/20 22:52 11.8037 -15.1804 8 0 0 8 Guinea-Bissau
3334 3334       Guinea 3/30/20 22:52 9.9456 -9.6966 22 0 0 22 Guinea
3333 3333       Guatemala 3/30/20 22:52 15.7835 -90.2308 36 1 10 25 Guatemala
3332 3332       Grenada 3/30/20 22:52 12.1165 -61.679 9 0 0 9 Grenada
3331 3331       Greece 3/30/20 22:52 39.0742 21.8243 1212 43 52 1117 Greece
3330 3330       Ghana 3/30/20 22:52 7.9465 -1.0232 152 5 2 145 Ghana
3329 3329       Germany 3/30/20 22:52 51.165691 10.451526 66885 645 13500 52740 Germany
3328 3328       Georgia 3/30/20 22:52 42.3154 43.3569 103 0 20 83 Georgia
3327 3327       Gambia 3/30/20 22:52 13.4432 -15.3101 4 1 0 3 Gambia
3326 3326       Gabon 3/30/20 22:52 -0.8037 11.6094 7 1 0 6 Gabon
3325 3325       France 3/30/20 22:52 46.2276 2.2137 44029 3020 7927 33599 France
3324 3324       Finland 3/30/20 22:52 61.92411 25.748151 1352 13 10 1329 Finland
3323 3323       Fiji 3/30/20 22:52 -17.7134 178.065 5 0 0 5 Fiji
3322 3322       Ethiopia 3/30/20 22:52 9.145 40.4897 23 0 4 19 Ethiopia
3321 3321       Eswatini 3/30/20 22:52 -26.5225 31.4659 9 0 0 9 Eswatini
3320 3320       Estonia 3/30/20 22:52 58.5953 25.0136 715 3 20 692 Estonia
3319 3319       Eritrea 3/30/20 22:52 15.1794 39.7823 12 0 0 12 Eritrea
3318 3318       Equatorial Guinea 3/30/20 22:52 1.6508 10.2679 12 0 0 12 Equatorial Guinea
3317 3317       El Salvador 3/30/20 22:52 13.7942 -88.8965 30 0 0 30 El Salvador
3316 3316       Egypt 3/30/20 22:52 26.820553 30.802498 656 41 150 465 Egypt
3315 3315       Ecuador 3/30/20 22:52 -1.8312 -78.1834 1962 60 3 1899 Ecuador
3314 3314       Dominican Republic 3/30/20 22:52 18.7357 -70.1627 901 42 4 855 Dominican Republic
3313 3313       Dominica 3/30/20 22:52 15.415 -61.371 11 0 0 11 Dominica
3312 3312       Djibouti 3/30/20 22:52 11.8251 42.5903 18 0 0 18 Djibouti
3311 3311       Diamond Princess 3/30/20 22:52 0.0 0.0 712 10 603 99 Diamond Princess
3310 3310       Denmark 3/30/20 22:52 56.2639 9.5018 2577 77 1 2499 Denmark
3309 3309       Czechia 3/30/20 22:52 49.8175 15.473 3001 23 25 2953 Czechia
3308 3308       Cyprus 3/30/20 22:52 35.1264 33.4299 230 7 22 201 Cyprus
3307 3307       Cuba 3/30/20 22:52 21.521757 -77.781167 170 4 4 162 Cuba
3306 3306       Croatia 3/30/20 22:52 45.1 15.2 790 6 67 717 Croatia
3305 3305       Cote d'Ivoire 3/30/20 22:52 7.54 -5.5471 168 1 6 161 Cote d'Ivoire
3304 3304       Costa Rica 3/30/20 22:52 9.7489 -83.7534 330 2 4 324 Costa Rica
3303 3303       Congo (Kinshasa) 3/30/20 22:52 -4.322447 15.307045 81 8 2 71 Congo (Kinshasa)
3302 3302       Congo (Brazzaville) 3/30/20 22:52 -4.2634 15.2832 19 0 0 19 Congo (Brazzaville)
3301 3301       Colombia 3/30/20 22:52 4.5709 -74.2973 798 12 15 771 Colombia
3300 3300       Chile 3/30/20 22:52 -35.6751 -71.543 2449 8 156 2285 Chile
3299 3299       Chad 3/30/20 22:52 15.4542 18.7322 5 0 0 5 Chad
3298 3298       Central African Republic 3/30/20 22:52 6.6111 20.9394 3 0 0 3 Central African Republic
3297 3297       Cameroon 3/30/20 22:52 3.848 11.5021 139 6 5 128 Cameroon
3296 3296       Cambodia 3/30/20 22:52 11.55 104.9167 107 0 21 86 Cambodia
3295 3295       Cabo Verde 3/30/20 22:52 16.5388 -23.0418 6 1 0 5 Cabo Verde
3294 3294       Burma 3/30/20 22:52 21.9162 95.956 14 0 0 14 Burma
3293 3293       Burkina Faso 3/30/20 22:52 12.2383 -1.5616 246 12 31 203 Burkina Faso
3292 3292       Bulgaria 3/30/20 22:52 42.7339 25.4858 359 8 17 334 Bulgaria
3291 3291       Brunei 3/30/20 22:52 4.5353 114.7277 127 1 38 88 Brunei
3290 3290       Brazil 3/30/20 22:52 -14.235 -51.9253 4579 159 120 4300 Brazil
3289 3289       Botswana 3/30/20 22:52 -22.3285 24.6849 3 0 0 3 Botswana
3288 3288       Bosnia and Herzegovina 3/30/20 22:52 43.9159 17.6791 368 10 17 341 Bosnia and Herzegovina
3287 3287       Bolivia 3/30/20 22:52 -16.2902 -63.5887 97 4 0 93 Bolivia
3286 3286       Bhutan 3/30/20 22:52 27.5142 90.4336 4 0 0 4 Bhutan
3285 3285       Benin 3/30/20 22:52 9.3077 2.3158 6 0 0 6 Benin
3284 3284       Belize 3/30/20 22:52 17.1899 -88.4976 3 0 0 3 ,,Belize
3283 3283       Belgium 3/30/20 22:52 50.8333 4.469936 11899 513 1527 9859 Belgium
3282 3282       Belarus 3/30/20 22:52 53.7098 27.9534 152 0 32 120 Belarus
3281 3281       Barbados 3/30/20 22:52 13.1939 -59.5432 33 0 0 33 Barbados
3280 3280       Bangladesh 3/30/20 22:52 23.685 90.3563 49 5 19 25 Bangladesh
3279 3279       Bahrain 3/30/20 22:52 26.0275 50.55 515 4 279 232 Bahrain
3278 3278       Bahamas 3/30/20 22:52 25.025885 -78.035889 14 0 1 13 Bahamas
3277 3277       Azerbaijan 3/30/20 22:52 40.1431 47.5769 273 4 26 243 Azerbaijan
3276 3276       Austria 3/30/20 22:52 47.5162 14.5501 9618 108 636 8874 Austria
3275 3275       Armenia 3/30/20 22:52 40.0691 45.0382 482 3 30 449 Armenia
3274 3274       Argentina 3/30/20 22:52 -38.4161 -63.6167 820 23 228 569 Argentina
3273 3273       Antigua and Barbuda 3/30/20 22:52 17.0608 -61.7964 7 0 0 7 Antigua and Barbuda
3272 3272       Angola 3/30/20 22:52 -11.2027 17.8739 7 2 0 5 Angola
3271 3271       Andorra 3/30/20 22:52 42.5063 1.5218 370 8 10 352 Andorra
3270 3270       Algeria 3/30/20 22:52 28.0339 1.6596 584 35 37 512 Algeria
3269 3269       Albania 3/30/20 22:52 41.1533 20.1683 223 11 44 168 Albania
3268 3268       Afghanistan 3/30/20 22:52 33.93911 67.709953 146 4 2 164 Afghanistan
3267 3267     Zhejiang China 3/30/20 1:32 29.1832 120.0934 1255 1 1225 29 Zhejiang, China
3266 3266     Yunnan China 3/26/20 23:16 24.974 101.487 180 2 172 6 Yunnan, China
3265 3265     Yukon Canada 3/30/20 22:58 64.2823 -135.0 4 0 0 0 ,Yukon,Canada
3264 3264     Xinjiang China 3/8/20 5:31 41.1129 85.2401 76 3 73 0 Xinjiang, China
3263 3263     Western Australia Australia 3/30/20 22:58 -31.9505 115.8605 355 2 41 312 Western Australia, Australia
3262 3262 78000   Virgin Islands US 3/30/20 22:52 18.3358 -64.8963 30 0 0 0 Virgin Islands, US
3261 3261     Victoria Australia 3/30/20 22:58 -37.8136 144.9631 821 4 191 626 Victoria, Australia
3260 3260     Turks and Caicos Islands United Kingdom 3/30/20 22:52 21.694 -71.7979 5 0 0 5 Turks and Caicos Islands, United Kingdom
3259 3259     Tibet China 2/23/20 11:19 31.6927 88.0924 1 0 1 0 Tibet, China
3258 3258     Tianjin China 3/30/20 8:42 39.3054 117.323 174 3 133 38 Tianjin, China
3257 3257     Tasmania Australia 3/30/20 22:58 -42.8821 147.3272 66 0 5 61 Tasmania, Australia
3256 3256     St Martin France 3/30/20 22:52 18.0708 -63.0501 15 1 2 12 St Martin, France
3255 3255     South Australia Australia 3/30/20 22:58 -34.9285 138.6007 305 0 6 299 South Australia, Australia
3254 3254     Sint Maarten Netherlands 3/30/20 22:52 18.0425 -63.0548 6 0 0 6 Sint Maarten, Netherlands
3253 3253     Sichuan China 3/30/20 1:09 30.6171 102.7103 550 3 536 11 Sichuan, China
3252 3252     Shanxi China 3/29/20 0:20 37.5777 112.2922 136 0 133 3 Shanxi, China
3251 3251     Shanghai China 3/30/20 5:05 31.202 121.4491 498 5 338 155 Shanghai, China
3250 3250     Shandong China 3/30/20 0:22 36.3427 118.1498 773 7 753 13 Shandong, China
3249 3249     Shaanxi China 3/26/20 2:14 35.1917 108.8701 253 3 242 8 Shaanxi, China
3248 3248     Saskatchewan Canada 3/30/20 22:58 52.9399 -106.4509 156 2 0 0 Saskatchewan, Canada
3247 3247     Saint Helena, Ascension and Tristan da Cunha United Kingdom 3/30/20 22:52 -7.9467 -14.3559 0 0 0 0 Saint Helena, Ascension and Tristan da Cunha, United Kingdom
3246 3246     Saint Barthelemy France 3/30/20 22:52 17.9 -62.8333 6 0 1 5 Saint Barthelemy, France
3245 3245     Reunion France 3/30/20 22:52 -21.1151 55.5364 224 0 1 223 Reunion, France
3244 3244     Recovered US 3/30/20 22:52 0.0 0.0 0 0 5644 0 Recovered, US
3243 3243     Recovered Canada 3/30/20 22:58 0.0 0.0 0 0 466 0 Recovered, Canada

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

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