04-06-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

2,810 rows sorted by Active descending

✎ 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
2711 2711       Italy 4/6/20 23:21 41.87194 12.56738 132547 16523 22837 93187 Italy
2784 2784       Spain 4/6/20 23:21 40.463667 -3.74922 136675 13341 40437 82897 Spain
2692 2692       Germany 4/6/20 23:21 51.165691 10.451526 103374 1810 28700 72864 Germany
2688 2688       France 4/6/20 23:21 46.2276 2.2137 73554 8899 17250 71849 France
2802 2802       United Kingdom 4/6/20 23:21 55.3781 -3.436 51608 5373 135 46100 United Kingdom
2707 2707       Iran 4/6/20 23:21 32.427908 53.688046 60500 3739 24236 32525 Iran
2798 2798       Turkey 4/6/20 23:21 38.9637 35.2433 30217 649 1326 28242 Turkey
2747 2747       Netherlands 4/6/20 23:21 52.1326 5.2913 18803 1867 250 16686 Netherlands
2645 2645       Belgium 4/6/20 23:21 50.8333 4.469936 20814 1632 3986 15196 Belgium
2789 2789       Switzerland 4/6/20 23:21 46.8182 8.2275 21657 765 8056 12836 Switzerland
2652 2652       Brazil 4/6/20 23:21 -14.235 -51.9253 12161 564 127 11470 Brazil
2762 2762       Portugal 4/6/20 23:21 39.3999 -8.2245 11730 311 140 11279 Portugal
2638 2638       Austria 4/6/20 23:21 47.5162 14.5501 12297 220 3463 8614 Austria
2710 2710       Israel 4/6/20 23:21 31.046051 34.851612 9191 64 939 8262 Israel
2788 2788       Sweden 4/6/20 23:21 60.128161 18.643501 7206 477 205 6524 Sweden
2765 2765       Russia 4/6/20 23:21 61.52401 105.318756 6343 47 406 5890 Russia
2753 2753       Norway 4/6/20 23:21 60.472 8.4689 5865 76 32 5757 Norway
2709 2709       Ireland 4/6/20 23:21 53.1424 -7.6921 5364 174 25 5165 Ireland
2672 2672       Czechia 4/6/20 23:21 49.8175 15.473 4822 78 121 4623 Czechia
2705 2705       India 4/6/20 23:21 20.593684 78.96288 4778 136 375 4267 India
2761 2761       Poland 4/6/20 23:21 51.9194 19.1451 4413 107 162 4144 Poland
2663 2663       Chile 4/6/20 23:21 -35.6751 -71.543 4815 37 728 4050 Chile
2717 2717       Korea, South 4/6/20 23:21 35.907757 127.766922 10284 186 6598 3500 Korea, South
2764 2764       Romania 4/6/20 23:21 45.9432 24.9668 4057 176 406 3475 Romania
2678 2678       Ecuador 4/6/20 23:21 -1.8312 -78.1834 3747 191 100 3456 Ecuador
2755 2755       Pakistan 4/6/20 23:21 30.3753 69.3451 3766 53 259 3454 Pakistan
2760 2760       Philippines 4/6/20 23:21 12.879721 121.774017 3660 163 73 3424 Philippines
2673 2673       Denmark 4/6/20 23:21 56.2639 9.5018 4681 187 1378 3116 Denmark
2713 2713       Japan 4/6/20 23:21 36.204824 138.252924 3654 85 575 2994 Japan
2590 2590     New South Wales Australia 4/6/20 23:28 -33.8688 151.2093 2637 18 4 2615 New South Wales, Australia
2732 2732       Malaysia 4/6/20 23:21 4.210484 101.975766 3793 62 1241 2490 Malaysia
2728 2728       Luxembourg 4/6/20 23:21 49.8153 6.1296 2843 41 500 2302 Luxembourg
2775 2775       Serbia 4/6/20 23:21 44.0165 21.0059 2200 58 0 2142 Serbia
2706 2706       Indonesia 4/6/20 23:21 -0.7893 113.9213 2491 209 192 2090 Indonesia
2773 2773       Saudi Arabia 4/6/20 23:21 23.885942 45.079162 2605 38 551 2016 Saudi Arabia
2756 2756       Panama 4/6/20 23:21 8.538 -80.7821 1988 54 13 1921 Panama
2801 2801       United Arab Emirates 4/6/20 23:21 23.424076 53.847818 2076 11 167 1898 United Arab Emirates
2687 2687       Finland 4/6/20 23:21 61.92411 25.748151 2176 27 300 1849 Finland
2677 2677       Dominican Republic 4/6/20 23:21 18.7357 -70.1627 1828 86 33 1709 Dominican Republic
2763 2763       Qatar 4/6/20 23:21 25.3548 51.1839 1832 4 131 1697 Qatar
2782 2782       South Africa 4/6/20 23:21 -30.5595 22.9375 1686 12 95 1579 South Africa
2759 2759       Peru 4/6/20 23:21 -9.19 -75.0152 2561 92 997 1472 Peru
2664 2664       Colombia 4/6/20 23:21 4.5709 -74.2973 1579 46 88 1445 Colombia
2738 2738       Mexico 4/6/20 23:21 23.6345 -102.5528 2143 94 633 1416 Mexico
2694 2694       Greece 4/6/20 23:21 39.0742 21.8243 1755 79 269 1407 Greece
2793 2793       Thailand 4/6/20 23:21 15.870032 100.992541 2220 26 793 1401 Thailand
2800 2800       Ukraine 4/6/20 23:21 48.3794 31.1656 1319 38 28 1253 Ukraine
2636 2636       Argentina 4/6/20 23:21 -38.4161 -63.6167 1554 48 325 1181 Argentina
2632 2632       Algeria 4/6/20 23:21 28.0339 1.6596 1423 173 90 1160 Algeria
2704 2704       Iceland 4/6/20 23:21 64.9631 -19.0208 1562 6 460 1096 Iceland
2669 2669       Croatia 4/6/20 23:21 45.1 15.2 1222 16 130 1076 Croatia
2683 2683       Estonia 4/6/20 23:21 58.5953 25.0136 1108 19 62 1027 Estonia
2778 2778       Singapore 4/6/20 23:21 1.2833 103.8333 1375 6 344 1025 Singapore
2679 2679       Egypt 4/6/20 23:21 26.820553 30.802498 1322 85 259 978 Egypt
2743 2743       Morocco 4/6/20 23:21 31.7917 -7.0926 1120 80 81 959 Morocco
2748 2748       New Zealand 4/6/20 23:21 -40.9006 174.886 1106 1 176 929 New Zealand
2739 2739       Moldova 4/6/20 23:21 47.4116 28.3699 965 19 37 909 Moldova
2780 2780       Slovenia 4/6/20 23:21 46.1512 14.9955 1021 30 102 889 Slovenia
2727 2727       Lithuania 4/6/20 23:21 55.1694 23.8813 750 10 0 820 Lithuania
2637 2637       Armenia 4/6/20 23:21 40.0691 45.0382 833 8 62 763 Armenia
2603 2603     Queensland Australia 4/6/20 23:28 -27.4698 153.0251 921 4 173 744 Queensland, Australia
2574 2574     Hong Kong China 4/6/20 9:37 22.3 114.2 914 4 216 694 Hong Kong, China
2703 2703       Hungary 4/6/20 23:21 47.1625 19.5033 744 38 67 639 Hungary
2644 2644       Belarus 4/6/20 23:21 53.7098 27.9534 700 13 53 634 Belarus
2660 2660       Cameroon 4/6/20 23:21 3.848 11.5021 658 9 17 632 Cameroon
2708 2708       Iraq 4/6/20 23:21 33.223191 43.679291 1031 64 344 623 Iraq
2715 2715       Kazakhstan 4/6/20 23:21 48.0196 66.9237 662 6 46 610 Kazakhstan
2650 2650       Bosnia and Herzegovina 4/6/20 23:21 43.9159 17.6791 674 29 47 598 Bosnia and Herzegovina
2639 2639       Azerbaijan 4/6/20 23:21 40.1431 47.5769 641 7 44 590 Azerbaijan
2575 2575     Hubei China 4/6/20 2:21 30.9756 112.2707 67803 3212 64014 577 Hubei, China
2797 2797       Tunisia 4/6/20 23:21 33.886917 9.537499 596 22 5 569 Tunisia
2719 2719       Kuwait 4/6/20 23:21 29.31166 47.481766 665 1 103 561 Kuwait
2623 2623     Victoria Australia 4/6/20 23:28 -37.8136 144.9631 1158 10 620 528 Victoria, Australia
2722 2722       Latvia 4/6/20 23:21 56.8796 24.6032 542 1 16 525 Latvia
2779 2779       Slovakia 4/6/20 23:21 48.669 19.699 534 2 8 524 Slovakia
2752 2752       North Macedonia 4/6/20 23:21 41.6086 21.7453 570 23 30 517 North Macedonia
2654 2654       Bulgaria 4/6/20 23:21 42.7339 25.4858 549 22 39 488 Bulgaria
2633 2633       Andorra 4/6/20 23:21 42.5063 1.5218 525 21 31 473 Andorra
2723 2723       Lebanon 4/6/20 23:21 33.8547 35.8623 541 19 60 462 Lebanon
2667 2667       Costa Rica 4/6/20 23:21 9.7489 -83.7534 467 2 18 447 Costa Rica
2804 2804       Uzbekistan 4/6/20 23:21 41.377491 64.585262 457 2 30 425 Uzbekistan
2671 2671       Cyprus 4/6/20 23:21 35.1264 33.4299 465 9 45 411 Cyprus
2617 2617     South Australia Australia 4/6/20 23:28 -34.9285 138.6007 411 0 53 358 South Australia, Australia
2630 2630       Afghanistan 4/6/20 23:21 33.93911 67.709953 368 15 18 338 Afghanistan
2670 2670       Cuba 4/6/20 23:21 21.521757 -77.781167 350 9 18 323 Cuba
2791 2791       Taiwan* 4/6/20 6:20 23.7 121.0 373 5 57 311 Taiwan*
2606 2606     Reunion France 4/6/20 23:21 -21.1151 55.5364 349 0 40 309 Reunion, France
2803 2803       Uruguay 4/6/20 23:21 -32.5228 -55.7658 406 6 104 296 Uruguay
2625 2625     Western Australia Australia 4/6/20 23:28 -31.9505 115.8605 460 4 162 294 Western Australia, Australia
2641 2641       Bahrain 4/6/20 23:21 26.0275 50.55 756 4 458 294 Bahrain
2550 2550     Channel Islands United Kingdom 4/6/20 23:21 49.3723 -2.3644 323 7 27 289 Channel Islands, United Kingdom
2668 2668       Cote d'Ivoire 4/6/20 23:21 7.54 -5.5471 323 3 41 279 Cote d'Ivoire
2702 2702       Honduras 4/6/20 23:21 15.2 -86.2419 298 22 6 270 Honduras
2754 2754       Oman 4/6/20 23:21 21.512583 55.923255 331 2 61 268 Oman
2631 2631       Albania 4/6/20 23:21 41.1533 20.1683 377 21 116 240 Albania
2655 2655       Burkina Faso 4/6/20 23:21 12.2383 -1.5616 364 18 108 238 Burkina Faso
2735 2735       Malta 4/6/20 23:21 35.9375 14.3754 241 0 5 236 Malta
2737 2737       Mauritius 4/6/20 23:21 -20.348404 57.552152 244 7 7 230 Mauritius
2742 2742       Montenegro 4/6/20 23:21 42.708678 19.37439 233 2 1 230 Montenegro
2807 2807       West Bank and Gaza 4/6/20 23:21 31.9522 35.2332 254 1 24 229 West Bank and Gaza

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

CREATE TABLE [04-06-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
);