03-22-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,420 rows sorted by Province_State

✎ View and edit SQL

This data as json, copyable, CSV (advanced)

Suggested facets: Last_Update

Link rowid FIPS Admin2 Province_State ▼ Country_Region Last_Update Lat Long_ Confirmed Deaths Recovered Active Combined_Key
3206 3206       Taiwan* 3/22/20 8:11 23.7 121.0 169 2 28 139 Taiwan*
3235 3235       Italy 3/22/20 23:45 41.87194 12.56738 59138 5476 7024 46638 Italy
3236 3236       Spain 3/22/20 23:45 40.463667 -3.74922 28603 1756 2125 24722 Spain
3237 3237       Germany 3/22/20 23:45 51.165691 10.451526 24873 94 266 24513 Germany
3238 3238       Iran 3/22/20 23:45 32.427908 53.688046 21638 1685 7635 12318 Iran
3239 3239       France 3/22/20 23:45 46.2276 2.2137 16533 674 2200 13144 France
3240 3240       Korea, South 3/22/20 23:45 35.907757 127.766922 8897 104 2909 5884 Korea, South
3241 3241       Switzerland 3/22/20 23:45 46.8182 8.2275 7474 98 131 7245 Switzerland
3242 3242       United Kingdom 3/22/20 23:45 55.3781 -3.436 5683 281 93 5309 United Kingdom
3243 3243       Netherlands 3/22/20 23:45 52.1326 5.2913 4204 179 2 4023 Netherlands
3244 3244       Austria 3/22/20 23:45 47.5162 14.5501 3580 16 9 3555 Austria
3245 3245       Belgium 3/22/20 23:45 50.8333 4.469936 3401 75 263 3063 Belgium
3246 3246       Norway 3/22/20 23:45 60.472 8.4689 2263 7 6 2250 Norway
3247 3247       Sweden 3/22/20 23:45 60.128161 18.643501 1931 21 16 1894 Sweden
3248 3248       Portugal 3/22/20 23:45 39.3999 -8.2245 1600 14 5 1581 Portugal
3249 3249       Brazil 3/22/20 23:45 -14.235 -51.9253 1546 25 2 1519 Brazil
3250 3250       Denmark 3/22/20 23:45 56.2639 9.5018 1395 13 1 1381 Denmark
3251 3251       Malaysia 3/22/20 23:45 4.210484 101.975766 1306 10 139 1157 Malaysia
3252 3252       Turkey 3/22/20 23:45 38.9637 35.2433 1236 30 0 1206 Turkey
3253 3253       Czechia 3/22/20 23:45 49.8175 15.473 1120 1 6 1113 Czechia
3254 3254       Japan 3/22/20 23:45 36.204824 138.252924 1086 36 235 815 Japan
3255 3255       Israel 3/22/20 23:45 31.046051 34.851612 1268 1 19 1033 Israel
3256 3256       Ireland 3/22/20 23:45 53.1424 -7.6921 906 4 5 897 Ireland
3257 3257       Luxembourg 3/22/20 23:45 49.8153 6.1296 798 8 6 784 Luxembourg
3258 3258       Ecuador 3/22/20 23:45 -1.8312 -78.1834 789 14 3 772 Ecuador
3259 3259       Pakistan 3/22/20 23:45 30.3753 69.3451 776 4 13 759 Pakistan
3261 3261       Poland 3/22/20 23:45 51.9194 19.1451 634 7 13 614 Poland
3262 3262       Chile 3/22/20 23:45 -35.6751 -71.543 632 1 8 623 Chile
3263 3263       Finland 3/22/20 23:45 61.92411 25.748151 626 1 10 615 Finland
3264 3264       Greece 3/22/20 23:45 39.0742 21.8243 624 15 19 590 Greece
3265 3265       Thailand 3/22/20 23:45 15.870032 100.992541 599 1 45 554 Thailand
3266 3266       Iceland 3/22/20 23:45 64.9631 -19.0208 568 1 5 562 Iceland
3267 3267       Indonesia 3/22/20 23:45 -0.7893 113.9213 514 48 29 437 Indonesia
3268 3268       Saudi Arabia 3/22/20 23:45 23.885942 45.079162 511 0 17 494 Saudi Arabia
3269 3269       Qatar 3/22/20 23:45 25.3548 51.1839 494 0 33 461 Qatar
3270 3270       Singapore 3/22/20 23:45 1.2833 103.8333 455 2 144 309 Singapore
3271 3271       Romania 3/22/20 23:45 45.9432 24.9668 433 3 64 366 Romania
3272 3272       Slovenia 3/22/20 23:45 46.1512 14.9955 414 2 0 412 Slovenia
3273 3273       India 3/22/20 23:45 20.593684 78.96288 396 7 24 365 India
3274 3274       Philippines 3/22/20 23:45 12.879721 121.774017 380 25 15 340 Philippines
3275 3275       Russia 3/22/20 23:45 61.52401 105.318756 367 1 16 350 Russia
3276 3276       Peru 3/22/20 23:45 -9.19 -75.0152 363 5 1 357 Peru
3277 3277       Bahrain 3/22/20 23:45 26.0275 50.55 334 2 149 183 Bahrain
3278 3278       Egypt 3/22/20 23:45 26.820553 30.802498 327 14 56 257 Egypt
3279 3279       Estonia 3/22/20 23:45 58.5953 25.0136 326 0 4 322 Estonia
3280 3280       Panama 3/22/20 23:45 8.538 -80.7821 313 3 1 309 Panama
3281 3281       South Africa 3/22/20 23:45 -30.5595 22.9375 274 0 2 272 South Africa
3282 3282       Argentina 3/22/20 23:45 -38.4161 -63.6167 266 4 27 235 Argentina
3283 3283       Croatia 3/22/20 23:45 45.1 15.2 254 1 5 248 Croatia
3284 3284       Mexico 3/22/20 23:45 23.6345 -102.5528 251 2 4 245 Mexico
3285 3285       Lebanon 3/22/20 23:45 33.8547 35.8623 248 4 8 236 Lebanon
3286 3286       Iraq 3/22/20 23:45 33.223191 43.679291 233 20 57 156 Iraq
3287 3287       Colombia 3/22/20 23:45 4.5709 -74.2973 231 2 3 226 Colombia
3288 3288       Serbia 3/22/20 23:45 44.0165 21.0059 222 2 2 218 Serbia
3289 3289       Dominican Republic 3/22/20 23:45 18.7357 -70.1627 202 3 0 199 Dominican Republic
3290 3290       Algeria 3/22/20 23:45 28.0339 1.6596 201 17 65 119 Algeria
3291 3291       Armenia 3/22/20 23:45 40.0691 45.0382 194 0 2 192 Armenia
3292 3292       Kuwait 3/22/20 23:45 29.31166 47.481766 188 0 30 158 Kuwait
3293 3293       Bulgaria 3/22/20 23:45 42.7339 25.4858 187 3 3 181 Bulgaria
3294 3294       Slovakia 3/22/20 23:45 48.669 19.699 185 0 7 178 Slovakia
3295 3295       San Marino 3/22/20 23:45 43.9424 12.4578 175 20 4 151 San Marino
3296 3296       United Arab Emirates 3/22/20 23:45 23.424076 53.847818 153 2 38 113 United Arab Emirates
3297 3297       Latvia 3/22/20 23:45 56.8796 24.6032 139 0 1 138 Latvia
3298 3298       Uruguay 3/22/20 23:45 -32.5228 -55.7658 135 0 0 135 Uruguay
3299 3299       Costa Rica 3/22/20 23:45 9.7489 -83.7534 134 2 2 130 Costa Rica
3300 3300       Hungary 3/22/20 23:45 47.1625 19.5033 131 6 16 109 Hungary
3301 3301       Lithuania 3/22/20 23:45 55.1694 23.8813 97 0 0 127 Lithuania
3302 3302       Bosnia and Herzegovina 3/22/20 23:45 43.9159 17.6791 126 1 2 123 Bosnia and Herzegovina
3303 3303       Morocco 3/22/20 23:45 31.7917 -7.0926 115 4 3 108 Morocco
3304 3304       North Macedonia 3/22/20 23:45 41.6086 21.7453 115 1 1 113 North Macedonia
3306 3306       Andorra 3/22/20 23:45 42.5063 1.5218 113 1 1 111 Andorra
3307 3307       Vietnam 3/22/20 23:45 14.058324 108.277199 113 0 17 96 Vietnam
3308 3308       Jordan 3/22/20 23:45 31.24 36.51 112 0 1 111 Jordan
3309 3309       New Zealand 3/22/20 23:45 -40.9006 174.886 102 0 0 102 New Zealand
3310 3310       Cyprus 3/22/20 23:45 35.1264 33.4299 95 1 3 91 Cyprus
3311 3311       Moldova 3/22/20 23:45 47.4116 28.3699 94 1 1 92 Moldova
3312 3312       Malta 3/22/20 23:45 35.9375 14.3754 90 0 2 88 Malta
3313 3313       Albania 3/22/20 23:45 41.1533 20.1683 89 2 2 85 Albania
3314 3314       Brunei 3/22/20 23:45 4.5353 114.7277 88 0 2 86 Brunei
3315 3315       Cambodia 3/22/20 23:45 11.55 104.9167 84 0 2 82 Cambodia
3316 3316       Sri Lanka 3/22/20 23:45 7.873054 80.771797 82 0 3 79 Sri Lanka
3317 3317       Belarus 3/22/20 23:45 53.7098 27.9534 76 0 15 61 Belarus
3318 3318       Burkina Faso 3/22/20 23:45 12.2383 -1.5616 75 4 5 66 Burkina Faso
3319 3319       Tunisia 3/22/20 23:45 33.886917 9.537499 75 3 1 71 Tunisia
3320 3320       Ukraine 3/22/20 23:45 48.3794 31.1656 73 3 1 69 Ukraine
3321 3321       Venezuela 3/22/20 23:45 6.4238 -66.5897 70 0 15 55 Venezuela
3322 3322       Senegal 3/22/20 23:45 14.4974 -14.4524 67 0 5 62 Senegal
3323 3323       Azerbaijan 3/22/20 23:45 40.1431 47.5769 65 1 11 53 Azerbaijan
3324 3324       Kazakhstan 3/22/20 23:45 48.0196 66.9237 60 0 0 59 Kazakhstan
3326 3326       Oman 3/22/20 23:45 21.512583 55.923255 55 0 17 38 Oman
3327 3327       Georgia 3/22/20 23:45 42.3154 43.3569 54 0 1 53 Georgia
3328 3328       Trinidad and Tobago 3/22/20 23:45 10.6918 -61.2225 50 0 0 50 Trinidad and Tobago
3330 3330       Uzbekistan 3/22/20 23:45 41.377491 64.585262 43 0 0 43 Uzbekistan
3331 3331       Afghanistan 3/22/20 23:45 33.93911 67.709953 34 1 1 38 Afghanistan
3332 3332       Cameroon 3/22/20 23:45 3.848 11.5021 40 0 2 38 Cameroon
3334 3334       Liechtenstein 3/22/20 23:45 47.14 9.55 37 0 0 37 Liechtenstein
3335 3335       Cuba 3/22/20 23:45 21.521757 -77.781167 35 1 0 34 Cuba
3337 3337       Congo (Kinshasa) 3/22/20 23:45 -4.322447 15.307045 30 1 0 29 Congo (Kinshasa)
3338 3338       Nigeria 3/22/20 23:45 9.082 8.6753 30 0 2 28 Nigeria
3339 3339       Mauritius 3/22/20 23:45 -20.348404 57.552152 28 2 0 26 Mauritius

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

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