03-25-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,423 rows sorted by Active descending

✎ View and edit SQL

This data as json, copyable, CSV (advanced)

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
3332 3332       Italy 2020-03-25 23:33:04 41.87194 12.56738 74386 7503 9362 57521 Italy
3399 3399       Spain 2020-03-25 23:33:04 40.463667 -3.7492199999999998 49515 3647 5367 40501 Spain
3313 3313       Germany 2020-03-25 23:33:04 51.165690999999995 10.451526 37323 206 3547 33570 Germany
3309 3309       France 2020-03-25 23:33:04 46.2276 2.2137 24967 1331 3900 20002 France
3328 3328       Iran 2020-03-25 23:33:04 32.427908 53.68804599999999 27017 2077 9625 15315 Iran
3404 3404       Switzerland 2020-03-25 23:33:04 46.8182 8.2275 10897 153 131 10613 Switzerland
3417 3417       United Kingdom 2020-03-25 23:33:04 55.3781 -3.4360000000000004 9529 465 135 8929 United Kingdom
3365 3365       Netherlands 2020-03-25 23:33:04 52.1326 5.2913 6412 356 3 6053 Netherlands
3262 3262       Austria 2020-03-25 23:33:04 47.5162 14.5501 5588 30 9 5549 Austria
3338 3338       Korea, South 2020-03-25 23:33:04 35.90775700000001 127.766922 9137 126 3730 5281 Korea, South
3269 3269       Belgium 2020-03-25 23:33:04 50.8333 4.469936 4937 178 547 4212 Belgium
3203 3203     Hubei China 2020-03-25 10:50:39 30.9756 112.2707 67801 3163 60811 3827 Hubei, China
3371 3371       Norway 2020-03-25 23:33:04 60.472 8.4689 3084 14 6 3064 Norway
3380 3380       Portugal 2020-03-25 23:33:04 39.3999 -8.2245 2995 43 22 2930 Portugal
3275 3275       Brazil 2020-03-25 23:33:04 -14.235 -51.9253 2554 59 2 2493 Brazil
3403 3403       Sweden 2020-03-25 23:33:04 60.128161 18.643501 2526 62 16 2448 Sweden
3413 3413       Turkey 2020-03-25 23:33:04 38.9637 35.2433 2433 59 26 2348 Turkey
3331 3331       Israel 2020-03-25 23:33:04 31.046051000000002 34.851612 2468 5 37 2306 Israel
3294 3294       Denmark 2020-03-25 23:33:04 56.2639 9.5018 1724 34 1 1689 Denmark
3293 3293       Czechia 2020-03-25 23:33:04 49.8175 15.472999999999999 1654 6 10 1638 Czechia
3350 3350       Malaysia 2020-03-25 23:33:04 4.210483999999999 101.97576600000001 1796 20 199 1577 Malaysia
3330 3330       Ireland 2020-03-25 23:33:04 53.1424 -7.6921 1564 9 5 1550 Ireland
3348 3348       Luxembourg 2020-03-25 23:33:04 49.8153 6.1296 1333 8 6 1319 Luxembourg
3299 3299       Ecuador 2020-03-25 23:33:04 -1.8312 -78.1834 1173 28 3 1142 Ecuador
3284 3284       Chile 2020-03-25 23:33:04 -35.6751 -71.543 1142 3 22 1117 Chile
3373 3373       Pakistan 2020-03-25 23:33:04 30.3753 69.3451 1063 8 21 1034 Pakistan
3379 3379       Poland 2020-03-25 23:33:04 51.9194 19.1451 1051 14 7 1030 Poland
3218 3218     New South Wales Australia 2020-03-25 23:37:49 -33.8688 151.2093 1029 7 4 1018 New South Wales, Australia
3334 3334       Japan 2020-03-25 23:33:04 36.204824 138.252924 1307 45 310 952 Japan
3390 3390       Saudi Arabia 2020-03-25 23:33:04 23.885942 45.079162 900 2 29 869 Saudi Arabia
3308 3308       Finland 2020-03-25 23:33:04 61.92411 25.748151 880 3 10 867 Finland
3408 3408       Thailand 2020-03-25 23:33:04 15.870032 100.992541 934 4 70 860 Thailand
3382 3382       Romania 2020-03-25 23:33:04 45.9432 24.9668 906 17 86 803 Romania
3315 3315       Greece 2020-03-25 23:33:04 39.0742 21.8243 821 22 36 763 Greece
3327 3327       Indonesia 2020-03-25 23:33:04 -0.7893 113.9213 790 58 31 701 Indonesia
3398 3398       South Africa 2020-03-25 23:33:04 -30.5595 22.9375 709 0 12 697 South Africa
3325 3325       Iceland 2020-03-25 23:33:04 64.9631 -19.0208 737 2 56 679 Iceland
3383 3383       Russia 2020-03-25 23:33:04 61.52401 105.31875600000001 658 3 29 626 Russia
3326 3326       India 2020-03-25 23:33:04 20.593684 78.96288 657 12 43 602 India
3378 3378       Philippines 2020-03-25 23:33:04 12.879721 121.77401699999999 636 38 26 572 Philippines
3396 3396       Slovenia 2020-03-25 23:33:04 46.1512 14.9955 528 5 10 513 Slovenia
3381 3381       Qatar 2020-03-25 23:33:04 25.3548 51.1839 537 0 41 496 Qatar
3377 3377       Peru 2020-03-25 23:33:04 -9.19 -75.0152 480 9 1 470 Peru
3394 3394       Singapore 2020-03-25 23:33:04 1.2833 103.8333 631 2 160 469 Singapore
3285 3285       Colombia 2020-03-25 23:33:04 4.5709 -74.2973 470 4 8 458 Colombia
3230 3230     Queensland Australia 2020-03-25 23:37:49 -27.4698 153.0251 443 0 8 435 Queensland, Australia
3374 3374       Panama 2020-03-25 23:33:04 8.538 -80.7821 443 8 1 434 Panama
3290 3290       Croatia 2020-03-25 23:33:04 45.1 15.2 442 1 22 419 Croatia
3356 3356       Mexico 2020-03-25 23:33:04 23.6345 -102.5528 405 5 4 396 Mexico
3304 3304       Estonia 2020-03-25 23:33:04 58.5953 25.0136 404 1 8 395 Estonia
3298 3298       Dominican Republic 2020-03-25 23:33:04 18.7357 -70.1627 392 10 3 379 Dominican Republic
3248 3248     Victoria Australia 2020-03-25 23:37:49 -37.8136 144.9631 466 0 97 369 Victoria, Australia
3392 3392       Serbia 2020-03-25 23:33:04 44.0165 21.0059 384 4 15 365 Serbia
3300 3300       Egypt 2020-03-25 23:33:04 26.820553000000004 30.802497999999996 456 21 95 340 Egypt
3260 3260       Argentina 2020-03-25 23:33:04 -38.4161 -63.6167 387 8 52 327 Argentina
3343 3343       Lebanon 2020-03-25 23:33:04 33.8547 35.8623 333 6 20 307 Lebanon
3202 3202     Hong Kong China 2020-03-25 09:10:20 22.3 114.2 410 4 102 304 Hong Kong, China
3416 3416       United Arab Emirates 2020-03-25 23:33:04 23.424076 53.847818000000004 333 2 52 279 United Arab Emirates
3347 3347       Lithuania 2020-03-25 23:33:04 55.1694 23.8813 208 2 0 269 Lithuania
3261 3261       Armenia 2020-03-25 23:33:04 40.0691 45.0382 265 0 16 249 Armenia
3265 3265       Bahrain 2020-03-25 23:33:04 26.0275 50.55 419 4 177 238 Bahrain
3277 3277       Bulgaria 2020-03-25 23:33:04 42.7339 25.4858 242 3 4 235 Bulgaria
3342 3342       Latvia 2020-03-25 23:33:04 56.8796 24.6032 221 0 1 220 Latvia
3256 3256       Algeria 2020-03-25 23:33:04 28.0339 1.6596 302 21 65 216 Algeria
3329 3329       Iraq 2020-03-25 23:33:04 33.223191 43.679291 346 29 103 214 Iraq
3361 3361       Morocco 2020-03-25 23:33:04 31.7917 -7.0926 225 6 7 212 Morocco
3395 3395       Slovakia 2020-03-25 23:33:04 48.669 19.699 216 0 7 209 Slovakia
3406 3406       Taiwan* 2020-03-25 08:02:14 23.7 121.0 235 2 29 204 Taiwan*
3288 3288       Costa Rica 2020-03-25 23:33:04 9.7489 -83.7534 201 2 2 197 Costa Rica
3324 3324       Hungary 2020-03-25 23:33:04 47.1625 19.5033 226 10 21 195 Hungary
3418 3418       Uruguay 2020-03-25 23:33:04 -32.5228 -55.7658 189 0 0 189 Uruguay
3257 3257       Andorra 2020-03-25 23:33:04 42.5063 1.5218 188 1 1 186 Andorra
3366 3366       New Zealand 2020-03-25 23:33:04 -40.9006 174.886 205 0 22 183 New Zealand
3389 3389       San Marino 2020-03-25 23:33:04 43.9424 12.4578 208 21 4 183 San Marino
3250 3250     Western Australia Australia 2020-03-25 23:37:49 -31.9505 115.8605 175 1 1 173 Western Australia, Australia
3370 3370       North Macedonia 2020-03-25 23:33:04 41.6086 21.7453 177 3 1 173 North Macedonia
3274 3274       Bosnia and Herzegovina 2020-03-25 23:33:04 43.9159 17.6791 176 3 2 171 Bosnia and Herzegovina
3335 3335       Jordan 2020-03-25 23:33:04 31.24 36.51 172 0 1 171 Jordan
3412 3412       Tunisia 2020-03-25 23:33:04 33.886917 9.537499 173 5 2 166 Tunisia
3243 3243     South Australia Australia 2020-03-25 23:37:49 -34.9285 138.6007 170 0 6 164 South Australia, Australia
3339 3339       Kuwait 2020-03-25 23:33:04 29.311659999999996 47.481766 195 0 43 152 Kuwait
3175 3175     Beijing China 2020-03-25 07:35:38 40.1824 116.4142 561 8 403 150 Beijing, China
3357 3357       Moldova 2020-03-25 23:33:04 47.4116 28.3699 149 1 2 146 Moldova
3415 3415       Ukraine 2020-03-25 23:33:04 48.3794 31.1656 145 5 1 139 Ukraine
3278 3278       Burkina Faso 2020-03-25 23:33:04 12.2383 -1.5616 146 4 10 132 Burkina Faso
3353 3353       Malta 2020-03-25 23:33:04 35.9375 14.3754 129 0 2 127 Malta
3292 3292       Cyprus 2020-03-25 23:33:04 35.1264 33.4299 132 3 3 126 Cyprus
3255 3255       Albania 2020-03-25 23:33:04 41.1533 20.1683 146 5 17 124 Albania
3421 3421       Vietnam 2020-03-25 23:33:04 14.058323999999999 108.277199 141 0 17 124 Vietnam
3295 3295       Diamond Princess 2020-03-25 23:33:04 0.0 0.0 712 10 587 115 Diamond Princess
3233 3233     Reunion France 2020-03-25 23:33:04 -21.1151 55.5364 111 0 1 110 Reunion, France
3276 3276       Brunei 2020-03-25 23:33:04 4.5353 114.7277 109 0 2 107 Brunei
3400 3400       Sri Lanka 2020-03-25 23:33:04 7.873054 80.77179699999998 102 0 3 99 Sri Lanka
3239 3239     Shanghai China 2020-03-25 06:43:02 31.202 121.4491 433 5 330 98 Shanghai, China
3184 3184     Faroe Islands Denmark 2020-03-25 23:33:04 61.8926 -6.9118 132 0 38 94 Faroe Islands, Denmark
3391 3391       Senegal 2020-03-25 23:33:04 14.4974 -14.4524 99 0 9 90 Senegal
3195 3195     Guangdong China 2020-03-25 10:50:39 23.3417 113.4244 1433 8 1336 89 Guangdong, China
3314 3314       Ghana 2020-03-25 23:33:04 7.9465 -1.0232 93 4 0 89 Ghana
3280 3280       Cambodia 2020-03-25 23:33:04 11.55 104.9167 96 0 10 86 Cambodia
3372 3372       Oman 2020-03-25 23:33:04 21.512583 55.92325500000001 99 0 17 82 Oman

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
);