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

Link rowid ▲ FIPS Admin2 Province_State Country_Region Last_Update Lat Long_ Confirmed Deaths Recovered Active Combined_Key
3442       Zimbabwe 3/30/20 22:52 -19.015438 29.154857 7 1 0 6 Zimbabwe
3441       Zambia 3/30/20 22:52 -13.133897 27.849332 35 0 0 35 Zambia
3440       West Bank and Gaza 3/30/20 22:52 31.9522 35.2332 116 1 18 97 West Bank and Gaza
3439       Vietnam 3/30/20 22:52 14.058324 108.277199 203 0 55 148 Vietnam
3438       Venezuela 3/30/20 22:52 6.4238 -66.5897 135 3 39 93 Venezuela
3437       Uzbekistan 3/30/20 22:52 41.377491 64.585262 149 2 7 140 Uzbekistan
3436       Uruguay 3/30/20 22:52 -32.5228 -55.7658 310 1 0 309 Uruguay
3435       United Kingdom 3/30/20 22:52 55.3781 -3.436 22141 1408 135 20598 United Kingdom
3434       United Arab Emirates 3/30/20 22:52 23.424076 53.847818 611 5 61 545 United Arab Emirates
3433       Ukraine 3/30/20 22:52 48.3794 31.1656 548 13 8 527 Ukraine
3432       Uganda 3/30/20 22:52 1.373333 32.290275 33 0 0 33 Uganda
3431       Turkey 3/30/20 22:52 38.9637 35.2433 10827 168 162 10497 Turkey
3430       Tunisia 3/30/20 22:52 33.886917 9.537499 312 8 3 301 Tunisia
3429       Trinidad and Tobago 3/30/20 22:52 10.6918 -61.2225 82 3 1 78 Trinidad and Tobago
3428       Togo 3/30/20 22:52 8.6195 0.8248 30 1 1 28 Togo
3427       Timor-Leste 3/30/20 22:52 -8.874217 125.727539 1 0 0 1 Timor-Leste
3426       Thailand 3/30/20 22:52 15.870032 100.992541 1524 9 127 1286 Thailand
3425       Tanzania 3/30/20 22:52 -6.369028 34.888822 19 0 1 18 Tanzania
3424       Taiwan* 3/30/20 7:11 23.7 121.0 306 5 39 262 Taiwan*
3423       Syria 3/30/20 22:52 34.802075 38.996815 10 2 0 8 Syria
3422       Switzerland 3/30/20 22:52 46.8182 8.2275 15922 359 1823 13740 Switzerland
3421       Sweden 3/30/20 22:52 60.128161 18.643501 4028 146 16 3866 Sweden
3420       Suriname 3/30/20 22:52 3.9193 -56.0278 8 0 0 8 Suriname
3419       Sudan 3/30/20 22:52 12.8628 30.2176 6 2 0 4 Sudan
3418       Sri Lanka 3/30/20 22:52 7.873054 80.771797 122 2 15 105 Sri Lanka
3417       Spain 3/30/20 22:52 40.463667 -3.74922 87956 7716 16780 63460 Spain
3416       South Africa 3/30/20 22:52 -30.5595 22.9375 1326 3 31 1292 South Africa
3415       Somalia 3/30/20 22:52 5.152149 46.199616 3 0 0 3 Somalia
3414       Slovenia 3/30/20 22:52 46.1512 14.9955 756 11 10 735 Slovenia
3413       Slovakia 3/30/20 22:52 48.669 19.699 336 0 7 329 Slovakia
3412       Singapore 3/30/20 22:52 1.2833 103.8333 879 3 228 648 Singapore
3411       Seychelles 3/30/20 22:52 -4.6796 55.492 8 0 0 8 Seychelles
3410       Serbia 3/30/20 22:52 44.0165 21.0059 785 16 0 769 Serbia
3409       Senegal 3/30/20 22:52 14.4974 -14.4524 162 0 27 135 Senegal
3408       Saudi Arabia 3/30/20 22:52 23.885942 45.079162 1453 8 115 1330 Saudi Arabia
3407       San Marino 3/30/20 22:52 43.9424 12.4578 230 25 13 192 San Marino
3406       Samoa 3/30/20 22:58 -13.759 -172.1046 0 0 0 0 Samoa
3405       Saint Vincent and the Grenadines 3/30/20 22:52 12.9843 -61.2872 1 0 1 0 Saint Vincent and the Grenadines
3404       Saint Lucia 3/30/20 22:52 13.9094 -60.9789 9 0 1 8 Saint Lucia
3403       Saint Kitts and Nevis 3/30/20 22:52 17.357822 -62.782998 7 0 0 7 Saint Kitts and Nevis
3402       Rwanda 3/30/20 22:52 -1.9403 29.8739 70 0 0 70 Rwanda
3401       Russia 3/30/20 22:52 61.52401 105.318756 1836 9 66 1761 Russia
3400       Romania 3/30/20 22:52 45.9432 24.9668 2109 65 209 1835 Romania
3399       Qatar 3/30/20 22:52 25.3548 51.1839 693 1 51 641 Qatar
3398       Portugal 3/30/20 22:52 39.3999 -8.2245 6408 140 43 6225 Portugal
3397       Poland 3/30/20 22:52 51.9194 19.1451 2055 31 7 2017 Poland
3396       Philippines 3/30/20 22:52 12.879721 121.774017 1546 78 42 1426 Philippines
3395       Peru 3/30/20 22:52 -9.19 -75.0152 950 24 53 873 Peru
3394       Paraguay 3/30/20 22:52 -23.4425 -58.4438 64 3 1 60 Paraguay
3393       Papua New Guinea 3/30/20 22:52 -6.314993 143.95555 1 0 0 1 Papua New Guinea
3392       Panama 3/30/20 22:52 8.538 -80.7821 989 24 4 961 Panama
3391       Pakistan 3/30/20 22:52 30.3753 69.3451 1717 21 76 1620 Pakistan
3390       Oman 3/30/20 22:52 21.512583 55.923255 179 0 29 150 Oman
3389       Norway 3/30/20 22:52 60.472 8.4689 4445 32 12 4401 Norway
3388       North Macedonia 3/30/20 22:52 41.6086 21.7453 285 7 12 266 North Macedonia
3387       Nigeria 3/30/20 22:52 9.082 8.6753 131 2 8 121 Nigeria
3386       Niger 3/30/20 22:52 17.607789 8.081666 27 3 0 24 Niger
3385       Nicaragua 3/30/20 22:52 12.865416 -85.207229 4 1 0 3 Nicaragua
3384       New Zealand 3/30/20 22:52 -40.9006 174.886 589 1 63 525 New Zealand
3383       Netherlands 3/30/20 22:52 52.1326 5.2913 11750 864 250 10636 Netherlands
3382       Nepal 3/30/20 22:52 28.1667 84.25 5 0 1 4 Nepal
3381       Namibia 3/30/20 22:52 -22.9576 18.4904 11 0 2 9 Namibia
3380       Mozambique 3/30/20 22:52 -18.665695 35.529562 8 0 0 8 Mozambique
3379       Morocco 3/30/20 22:52 31.7917 -7.0926 556 33 15 508 Morocco
3378       Montenegro 3/30/20 22:52 42.708678 19.37439 91 1 0 90 Montenegro
3377       Mongolia 3/30/20 22:52 46.8625 103.8467 12 0 2 10 Mongolia
3376       Monaco 3/30/20 22:52 43.7333 7.4167 49 1 1 47 Monaco
3375       Moldova 3/30/20 22:52 47.4116 28.3699 298 2 15 281 Moldova
3374       Mexico 3/30/20 22:52 23.6345 -102.5528 993 20 35 938 Mexico
3373       Mauritius 3/30/20 22:52 -20.348404 57.552152 128 3 0 125 Mauritius
3372       Mauritania 3/30/20 22:52 21.0079 -10.9408 5 1 2 2 ,,Mauritania
3371       Malta 3/30/20 22:52 35.9375 14.3754 156 0 2 154 Malta
3370       Mali 3/30/20 22:52 17.570692 -3.996166 25 2 0 23 Mali
3369       Maldives 3/30/20 22:52 3.2028 73.2207 17 0 13 4 Maldives
3368       Malaysia 3/30/20 22:52 4.210484 101.975766 2626 37 479 2110 Malaysia
3367       Madagascar 3/30/20 22:52 -18.766947 46.869107 43 0 0 43 Madagascar
3366       MS Zaandam 3/30/20 22:52 0.0 0.0 2 0 0 2 ,,MS Zaandam
3365       Luxembourg 3/30/20 22:52 49.8153 6.1296 1988 22 40 1926 Luxembourg
3364       Lithuania 3/30/20 22:52 55.1694 23.8813 424 4 0 477 Lithuania
3363       Liechtenstein 3/30/20 22:52 47.14 9.55 62 0 0 62 Liechtenstein
3362       Libya 3/30/20 22:52 26.3351 17.228331 8 0 0 8 Libya
3361       Liberia 3/30/20 22:52 6.428055 -9.429499 3 0 0 3 Liberia
3360       Lebanon 3/30/20 22:52 33.8547 35.8623 446 11 35 400 Lebanon
3359       Latvia 3/30/20 22:52 56.8796 24.6032 376 0 1 375 Latvia
3358       Laos 3/30/20 22:52 19.85627 102.495496 8 0 0 8 Laos
3357       Kyrgyzstan 3/30/20 22:52 41.20438 74.766098 94 0 3 91 Kyrgyzstan
3356       Kuwait 3/30/20 22:52 29.31166 47.481766 266 0 72 194 Kuwait
3355       Kosovo 3/30/20 22:52 42.602636 20.902977 94 1 1 92 Kosovo
3354       Korea, South 3/30/20 22:52 35.907757 127.766922 9661 158 5228 4275 Korea, South
3353       Kenya 3/30/20 22:52 -0.0236 37.9062 50 1 1 48 Kenya
3352       Kazakhstan 3/30/20 22:52 48.0196 66.9237 302 1 21 280 Kazakhstan
3351       Jordan 3/30/20 22:52 31.24 36.51 268 5 26 237 Jordan
3350       Japan 3/30/20 22:52 36.204824 138.252924 1866 54 424 1388 Japan
3349       Jamaica 3/30/20 22:52 18.1096 -77.2975 36 1 2 33 Jamaica
3348       Italy 3/30/20 22:52 41.87194 12.56738 101739 11591 14620 75528 Italy
3347       Israel 3/30/20 22:52 31.046051 34.851612 4979 17 147 4518 Israel
3346       Ireland 3/30/20 22:52 53.1424 -7.6921 2910 54 5 2851 Ireland
3345       Iraq 3/30/20 22:52 33.223191 43.679291 630 46 152 432 Iraq
3344       Iran 3/30/20 22:52 32.427908 53.688046 41495 2757 13911 24827 Iran
3343       Indonesia 3/30/20 22:52 -0.7893 113.9213 1414 122 75 1217 Indonesia

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