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

Link rowid ▲ FIPS Admin2 Province_State Country_Region Last_Update Lat Long_ Confirmed Deaths Recovered Active Combined_Key
3437       Zimbabwe 3/29/20 23:08 -19.015438 29.154857 7 1 0 6 Zimbabwe
3436       Zambia 3/29/20 23:08 -13.133897 27.849332 29 0 0 29 Zambia
3435       West Bank and Gaza 3/29/20 23:08 31.9522 35.2332 109 1 18 90 West Bank and Gaza
3434       Vietnam 3/29/20 23:08 14.058324 108.277199 188 0 25 163 Vietnam
3433       Venezuela 3/29/20 23:08 6.4238 -66.5897 119 2 39 78 Venezuela
3432       Uzbekistan 3/29/20 23:08 41.377491 64.585262 144 2 7 135 Uzbekistan
3431       Uruguay 3/29/20 23:08 -32.5228 -55.7658 304 1 0 303 Uruguay
3430       United Kingdom 3/29/20 23:08 55.3781 -3.436 19522 1228 135 18159 United Kingdom
3429       United Arab Emirates 3/29/20 23:08 23.424076 53.847818 570 3 58 509 United Arab Emirates
3428       Ukraine 3/29/20 23:08 48.3794 31.1656 475 10 6 459 Ukraine
3427       Uganda 3/29/20 23:08 1.373333 32.290275 33 0 0 33 Uganda
3426       Turkey 3/29/20 23:08 38.9637 35.2433 9217 131 105 8981 Turkey
3425       Tunisia 3/29/20 23:08 33.886917 9.537499 312 8 2 302 Tunisia
3424       Trinidad and Tobago 3/29/20 23:08 10.6918 -61.2225 78 3 1 74 Trinidad and Tobago
3423       Togo 3/29/20 23:08 8.6195 0.8248 25 1 1 23 Togo
3422       Timor-Leste 3/29/20 23:08 -8.874217 125.727539 1 0 0 1 Timor-Leste
3421       Thailand 3/29/20 23:08 15.870032 100.992541 1388 7 111 1284 Thailand
3420       Tanzania 3/29/20 23:08 -6.369028 34.888822 14 0 1 13 Tanzania
3419       Taiwan* 3/29/20 8:04 23.7 121.0 298 2 30 266 Taiwan*
3418       Syria 3/29/20 23:08 34.802075 38.996815 9 1 0 8 Syria
3417       Switzerland 3/29/20 23:08 46.8182 8.2275 14829 300 1595 12934 Switzerland
3416       Sweden 3/29/20 23:08 60.128161 18.643501 3700 110 16 3574 Sweden
3415       Suriname 3/29/20 23:08 3.9193 -56.0278 8 0 0 8 Suriname
3414       Sudan 3/29/20 23:08 12.8628 30.2176 5 1 0 5 Sudan
3413       Sri Lanka 3/29/20 23:08 7.873054 80.771797 117 1 11 105 Sri Lanka
3412       Spain 3/29/20 23:08 40.463667 -3.74922 80110 6803 14709 58598 Spain
3411       South Africa 3/29/20 23:08 -30.5595 22.9375 1280 2 31 1247 South Africa
3410       Somalia 3/29/20 23:08 5.152149 46.199616 3 0 0 3 Somalia
3409       Slovenia 3/29/20 23:08 46.1512 14.9955 730 11 10 709 Slovenia
3408       Slovakia 3/29/20 23:08 48.669 19.699 314 0 2 312 Slovakia
3407       Singapore 3/29/20 23:08 1.2833 103.8333 844 3 212 629 Singapore
3406       Seychelles 3/29/20 23:08 -4.6796 55.492 8 0 0 8 Seychelles
3405       Serbia 3/29/20 23:08 44.0165 21.0059 741 13 0 728 Serbia
3404       Senegal 3/29/20 23:08 14.4974 -14.4524 142 0 27 115 Senegal
3403       Saudi Arabia 3/29/20 23:08 23.885942 45.079162 1299 8 66 1225 Saudi Arabia
3402       San Marino 3/29/20 23:08 43.9424 12.4578 224 22 6 196 San Marino
3401       Samoa 3/29/20 23:13 -13.759 -172.1046 0 0 0 0 Samoa
3400       Saint Vincent and the Grenadines 3/29/20 23:08 12.9843 -61.2872 1 0 1 0 Saint Vincent and the Grenadines
3399       Saint Lucia 3/29/20 23:08 13.9094 -60.9789 9 0 1 8 Saint Lucia
3398       Saint Kitts and Nevis 3/29/20 23:08 17.357822 -62.782998 2 0 0 2 Saint Kitts and Nevis
3397       Rwanda 3/29/20 23:08 -1.9403 29.8739 70 0 0 70 Rwanda
3396       Russia 3/29/20 23:08 61.52401 105.318756 1534 8 64 1462 Russia
3395       Romania 3/29/20 23:08 45.9432 24.9668 1815 43 206 1566 Romania
3394       Qatar 3/29/20 23:08 25.3548 51.1839 634 1 48 585 Qatar
3393       Portugal 3/29/20 23:08 39.3999 -8.2245 5962 119 43 5800 Portugal
3392       Poland 3/29/20 23:08 51.9194 19.1451 1862 22 7 1833 Poland
3391       Philippines 3/29/20 23:08 12.879721 121.774017 1418 71 42 1305 Philippines
3390       Peru 3/29/20 23:08 -9.19 -75.0152 852 18 16 818 Peru
3389       Paraguay 3/29/20 23:08 -23.4425 -58.4438 59 3 1 55 Paraguay
3388       Papua New Guinea 3/29/20 23:08 -6.314993 143.95555 1 0 0 1 Papua New Guinea
3387       Panama 3/29/20 23:08 8.538 -80.7821 901 17 4 880 Panama
3386       Pakistan 3/29/20 23:08 30.3753 69.3451 1597 14 29 1554 Pakistan
3385       Oman 3/29/20 23:08 21.512583 55.923255 167 0 23 144 Oman
3384       Norway 3/29/20 23:08 60.472 8.4689 4284 25 7 4252 Norway
3383       North Macedonia 3/29/20 23:08 41.6086 21.7453 259 6 3 250 North Macedonia
3382       Nigeria 3/29/20 23:08 9.082 8.6753 111 1 3 107 Nigeria
3381       Niger 3/29/20 23:08 17.607789 8.081666 18 1 0 17 Niger
3380       Nicaragua 3/29/20 23:08 12.865416 -85.207229 4 1 0 3 Nicaragua
3379       New Zealand 3/29/20 23:08 -40.9006 174.886 514 1 56 457 New Zealand
3378       Netherlands 3/29/20 23:08 52.1326 5.2913 10866 771 250 9845 Netherlands
3377       Nepal 3/29/20 23:08 28.1667 84.25 5 0 1 4 Nepal
3376       Namibia 3/29/20 23:08 -22.9576 18.4904 11 0 2 9 Namibia
3375       Mozambique 3/29/20 23:08 -18.665695 35.529562 8 0 0 8 Mozambique
3374       Morocco 3/29/20 23:08 31.7917 -7.0926 479 26 13 440 Morocco
3373       Montenegro 3/29/20 23:08 42.708678 19.37439 85 1 0 84 Montenegro
3372       Mongolia 3/29/20 23:08 46.8625 103.8467 12 0 0 12 Mongolia
3371       Monaco 3/29/20 23:08 43.7333 7.4167 46 1 1 44 Monaco
3370       Moldova 3/29/20 23:08 47.4116 28.3699 263 2 2 259 Moldova
3369       Mexico 3/29/20 23:08 23.6345 -102.5528 848 16 4 828 Mexico
3368       Mauritius 3/29/20 23:08 -20.348404 57.552152 107 3 0 104 Mauritius
3367       Mauritania 3/29/20 23:08 21.0079 -10.9408 5 0 2 3 ,,Mauritania
3366       Malta 3/29/20 23:08 35.9375 14.3754 151 0 2 149 Malta
3365       Mali 3/29/20 23:08 17.570692 -3.996166 18 1 0 17 Mali
3364       Maldives 3/29/20 23:08 3.2028 73.2207 17 0 13 4 Maldives
3363       Malaysia 3/29/20 23:08 4.210484 101.975766 2470 35 388 2047 Malaysia
3362       Madagascar 3/29/20 23:08 -18.766947 46.869107 39 0 0 39 Madagascar
3361       MS Zaandam 3/29/20 23:08 0.0 0.0 2 0 0 2 ,,MS Zaandam
3360       Luxembourg 3/29/20 23:08 49.8153 6.1296 1950 21 40 1889 Luxembourg
3359       Lithuania 3/29/20 23:08 55.1694 23.8813 378 4 0 452 Lithuania
3358       Liechtenstein 3/29/20 23:08 47.14 9.55 56 0 0 56 Liechtenstein
3357       Libya 3/29/20 23:08 26.3351 17.228331 8 0 0 8 Libya
3356       Liberia 3/29/20 23:08 6.428055 -9.429499 3 0 0 3 Liberia
3355       Lebanon 3/29/20 23:08 33.8547 35.8623 438 10 30 398 Lebanon
3354       Latvia 3/29/20 23:08 56.8796 24.6032 347 0 1 346 Latvia
3353       Laos 3/29/20 23:08 19.85627 102.495496 8 0 0 8 Laos
3352       Kyrgyzstan 3/29/20 23:08 41.20438 74.766098 84 0 0 84 Kyrgyzstan
3351       Kuwait 3/29/20 23:08 29.31166 47.481766 255 0 67 188 Kuwait
3350       Kosovo 3/29/20 23:08 42.602636 20.902977 94 1 1 92 Kosovo
3349       Korea, South 3/29/20 23:08 35.907757 127.766922 9583 152 5033 4398 Korea, South
3348       Kenya 3/29/20 23:08 -0.0236 37.9062 42 1 1 40 Kenya
3347       Kazakhstan 3/29/20 23:08 48.0196 66.9237 284 1 20 263 Kazakhstan
3346       Jordan 3/29/20 23:08 31.24 36.51 259 3 18 238 Jordan
3345       Japan 3/29/20 23:08 36.204824 138.252924 1866 54 424 1388 Japan
3344       Jamaica 3/29/20 23:08 18.1096 -77.2975 32 1 2 29 Jamaica
3343       Italy 3/29/20 23:08 41.87194 12.56738 97689 10779 13030 73880 Italy
3342       Israel 3/29/20 23:08 31.046051 34.851612 4433 16 105 4100 Israel
3341       Ireland 3/29/20 23:08 53.1424 -7.6921 2615 46 5 2564 Ireland
3340       Iraq 3/29/20 23:08 33.223191 43.679291 547 42 143 362 Iraq
3339       Iran 3/29/20 23:08 32.427908 53.688046 38309 2640 12391 23278 Iran
3338       Indonesia 3/29/20 23:08 -0.7893 113.9213 1285 114 64 1107 Indonesia

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