04-30-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,179 rows sorted by Province_State

✎ View and edit SQL

This data as json, copyable, CSV (advanced)

Link rowid FIPS Admin2 Province_State ▼ Country_Region Last_Update Lat Long_ Confirmed Deaths Recovered Active Combined_Key
3097 3097       MS Zaandam 2020-05-01 02:32:28     9 2 0 7 MS Zaandam
3098 3098       Madagascar 2020-05-01 02:32:28 -18.766947000000002 46.869107 128 0 92 36 Madagascar
3099 3099       Malawi 2020-05-01 02:32:28 -13.254307999999998 34.301525 37 3 7 27 Malawi
3100 3100       Malaysia 2020-05-01 02:32:28 4.210483999999999 101.97576600000001 6002 102 4171 1729 Malaysia
3101 3101       Maldives 2020-05-01 02:32:28 3.2028 73.2207 468 1 17 450 Maldives
3102 3102       Mali 2020-05-01 02:32:28 17.570692 -3.996166000000001 490 26 135 329 Mali
3103 3103       Malta 2020-05-01 02:32:28 35.9375 14.3754 465 4 351 110 Malta
3104 3104       Mauritania 2020-05-01 02:32:28 21.0079 -10.9408 8 1 6 1 Mauritania
3105 3105       Mauritius 2020-05-01 02:32:28 -20.348404000000002 57.552152 332 10 310 12 Mauritius
3106 3106       Mexico 2020-05-01 02:32:28 23.6345 -102.5528 19224 1859 11423 5942 Mexico
3107 3107       Moldova 2020-05-01 02:32:28 47.4116 28.3699 3897 116 1182 2599 Moldova
3108 3108       Monaco 2020-05-01 02:32:28 43.7333 7.4167 95 4 64 27 Monaco
3109 3109       Mongolia 2020-05-01 02:32:28 46.8625 103.8467 38 0 10 28 Mongolia
3110 3110       Montenegro 2020-05-01 02:32:28 42.708678000000006 19.37439 322 7 214 101 Montenegro
3111 3111       Morocco 2020-05-01 02:32:28 31.7917 -7.0926 4423 170 984 3269 Morocco
3112 3112       Mozambique 2020-05-01 02:32:28 -18.665695 35.529562 76 0 12 64 Mozambique
3113 3113       Namibia 2020-05-01 02:32:28 -22.9576 18.4904 16 0 8 8 Namibia
3114 3114       Nepal 2020-05-01 02:32:28 28.1667 84.25 57 0 16 41 Nepal
3115 3115       Netherlands 2020-05-01 02:32:28 52.1326 5.2913 39316 4795 0 34521 Netherlands
3116 3116       New Zealand 2020-05-01 02:32:28 -40.9006 174.886 1479 19 1252 208 New Zealand
3117 3117       Nicaragua 2020-05-01 02:32:28 12.865416 -85.207229 14 3 7 4 Nicaragua
3118 3118       Niger 2020-05-01 02:32:28 17.607789 8.081666 719 32 452 235 Niger
3119 3119       Nigeria 2020-05-01 02:32:28 9.082 8.6753 1932 58 319 1555 Nigeria
3120 3120       North Macedonia 2020-05-01 02:32:28 41.6086 21.7453 1465 77 738 650 North Macedonia
3121 3121       Norway 2020-05-01 02:32:28 60.472 8.4689 7738 210 32 7496 Norway
3122 3122       Oman 2020-05-01 02:32:28 21.512583 55.92325500000001 2348 11 495 1842 Oman
3123 3123       Pakistan 2020-05-01 02:32:28 30.3753 69.3451 16817 385 4315 12117 Pakistan
3124 3124       Panama 2020-05-01 02:32:28 8.538 -80.7821 6532 188 576 5768 Panama
3125 3125       Papua New Guinea 2020-05-01 02:32:28 -6.314993 143.95555 8 0 0 8 Papua New Guinea
3126 3126       Paraguay 2020-05-01 02:32:28 -23.4425 -58.4438 266 10 113 143 Paraguay
3127 3127       Peru 2020-05-01 02:32:28 -9.19 -75.0152 36976 1051 10405 25520 Peru
3128 3128       Philippines 2020-05-01 02:32:28 12.879721 121.77401699999999 8488 568 1043 6877 Philippines
3129 3129       Poland 2020-05-01 02:32:28 51.9194 19.1451 12877 644 3236 8997 Poland
3130 3130       Portugal 2020-05-01 02:32:28 39.3999 -8.2245 25045 989 1519 22537 Portugal
3131 3131       Qatar 2020-05-01 02:32:28 25.3548 51.1839 13409 10 1372 12027 Qatar
3132 3132       Romania 2020-05-01 02:32:28 45.9432 24.9668 12240 717 4017 7506 Romania
3133 3133       Russia 2020-05-01 02:32:28 61.52401 105.31875600000001 106498 1073 11619 93806 Russia
3134 3134       Rwanda 2020-05-01 02:32:28 -1.9403 29.8739 243 0 104 139 Rwanda
3135 3135       Saint Kitts and Nevis 2020-05-01 02:32:28 17.357822 -62.782998 15 0 6 9 Saint Kitts and Nevis
3136 3136       Saint Lucia 2020-05-01 02:32:28 13.9094 -60.9789 17 0 15 2 Saint Lucia
3137 3137       Saint Vincent and the Grenadines 2020-05-01 02:32:28 12.9843 -61.2872 16 0 8 8 Saint Vincent and the Grenadines
3138 3138       Samoa 2020-05-01 02:32:28 -13.759 -172.1046 0 0 0 0 Samoa
3139 3139       San Marino 2020-05-01 02:32:28 43.9424 12.4578 569 41 78 450 San Marino
3140 3140       Sao Tome and Principe 2020-05-01 02:32:28 0.18636 6.613081 14 0 4 10 Sao Tome and Principe
3141 3141       Saudi Arabia 2020-05-01 02:32:28 23.885942 45.079162 22753 162 3163 19428 Saudi Arabia
3142 3142       Senegal 2020-05-01 02:32:28 14.4974 -14.4524 933 9 334 590 Senegal
3143 3143       Serbia 2020-05-01 02:32:28 44.0165 21.0059 9009 179 1343 7487 Serbia
3144 3144       Seychelles 2020-05-01 02:32:28 -4.6796 55.492 11 0 6 5 Seychelles
3145 3145       Sierra Leone 2020-05-01 02:32:28 8.460555000000001 -11.779889 124 7 21 96 Sierra Leone
3146 3146       Singapore 2020-05-01 02:32:28 1.2833 103.8333 16169 15 1244 14910 Singapore
3147 3147       Slovakia 2020-05-01 02:32:28 48.669 19.699 1396 23 524 849 Slovakia
3148 3148       Slovenia 2020-05-01 02:32:28 46.1512 14.9955 1429 91 233 1105 Slovenia
3149 3149       Somalia 2020-05-01 02:32:28 5.152149 46.199616 601 28 31 542 Somalia
3150 3150       South Africa 2020-05-01 02:32:28 -30.5595 22.9375 5647 103 2073 3471 South Africa
3151 3151       South Sudan 2020-05-01 02:32:28 6.8770000000000024 31.307 35 0 0 35 South Sudan
3152 3152       Spain 2020-05-01 02:32:28 40.463667 -3.74922 213435 24543 112050 76842 Spain
3153 3153       Sri Lanka 2020-05-01 02:32:28 7.873054 80.77179699999998 663 7 154 502 Sri Lanka
3154 3154       Sudan 2020-05-01 02:32:28 12.8628 30.2176 375 31 39 372 Sudan
3155 3155       Suriname 2020-05-01 02:32:28 3.9193 -56.0278 10 1 8 1 Suriname
3156 3156       Sweden 2020-05-01 02:32:28 60.128161 18.643501 21092 2586 1005 17501 Sweden
3157 3157       Switzerland 2020-05-01 02:32:28 46.8182 8.2275 29586 1737 23400 4449 Switzerland
3158 3158       Syria 2020-05-01 02:32:28 34.802075 38.99681500000001 43 3 21 19 Syria
3159 3159       Taiwan* 2020-05-01 02:32:28 23.7 121.0 429 6 322 101 Taiwan*
3160 3160       Tajikistan 2020-05-01 02:32:28 38.861034000000004 71.276093 15 0 0 15 Tajikistan
3161 3161       Tanzania 2020-05-01 02:32:28 -6.369028 34.888822 480 16 167 297 Tanzania
3162 3162       Thailand 2020-05-01 02:32:28 15.870032 100.992541 2954 54 2687 216 Thailand
3163 3163       Timor-Leste 2020-05-01 02:32:28 -8.874217 125.727539 24 0 16 8 Timor-Leste
3164 3164       Togo 2020-05-01 02:32:28 8.6195 0.8248 116 9 65 42 Togo
3165 3165       Trinidad and Tobago 2020-05-01 02:32:28 10.6918 -61.2225 116 8 72 36 Trinidad and Tobago
3166 3166       Tunisia 2020-05-01 02:32:28 33.886917 9.537499 994 41 305 648 Tunisia
3167 3167       Turkey 2020-05-01 02:32:28 38.9637 35.2433 120204 3174 48886 68144 Turkey
3168 3168       Uganda 2020-05-01 02:32:28 1.373333 32.290275 83 0 52 31 Uganda
3169 3169       Ukraine 2020-05-01 02:32:28 48.3794 31.1656 10406 261 1238 8907 Ukraine
3170 3170       United Arab Emirates 2020-05-01 02:32:28 23.424076 53.847818000000004 12481 105 2429 9947 United Arab Emirates
3171 3171       United Kingdom 2020-05-01 02:32:28 55.3781 -3.4360000000000004 171253 26771 0 144482 United Kingdom
3172 3172       Uruguay 2020-05-01 02:32:28 -32.5228 -55.7658 643 17 417 209 Uruguay
3173 3173       Uzbekistan 2020-05-01 02:32:28 41.377491 64.585262 2039 9 1133 897 Uzbekistan
3174 3174       Venezuela 2020-05-01 02:32:28 6.4238 -66.5897 333 16 142 175 Venezuela
3175 3175       Vietnam 2020-05-01 02:32:28 14.058323999999999 108.277199 270 0 219 51 Vietnam
3176 3176       West Bank and Gaza 2020-05-01 02:32:28 31.9522 35.2332 344 2 76 266 West Bank and Gaza
3177 3177       Yemen 2020-05-01 02:32:28 15.552726999999999 48.516388 6 2 1 3 Yemen
3178 3178       Zambia 2020-05-01 02:32:28 -13.133897 27.849332 106 3 55 48 Zambia
3179 3179       Zimbabwe 2020-05-01 02:32:28 -19.015438 29.154857 40 4 5 31 Zimbabwe
104 104 1001 Autauga Alabama US 2020-05-01 02:32:28 32.53952745 -86.64408227 42 4 0 40 Autauga, Alabama, US
110 110 1003 Baldwin Alabama US 2020-05-01 02:32:28 30.72774991 -87.72207058 180 3 0 171 Baldwin, Alabama, US
121 121 1005 Barbour Alabama US 2020-05-01 02:32:28 31.868263 -85.3871286 38 1 0 38 Barbour, Alabama, US
183 183 1007 Bibb Alabama US 2020-05-01 02:32:28 32.99642064 -87.12511459999996 40 0 0 42 Bibb, Alabama, US
199 199 1009 Blount Alabama US 2020-05-01 02:32:28 33.98210918 -86.56790593 39 0 0 37 Blount, Alabama, US
275 275 1011 Bullock Alabama US 2020-05-01 02:32:28 32.10030533 -85.71265535 13 0 0 13 Bullock, Alabama, US
286 286 1013 Butler Alabama US 2020-05-01 02:32:28 31.75300095 -86.68057478 55 1 0 52 Butler, Alabama, US
309 309 1015 Calhoun Alabama US 2020-05-01 02:32:28 33.77483727 -85.82630386 97 3 0 91 Calhoun, Alabama, US
399 399 1017 Chambers Alabama US 2020-05-01 02:32:28 32.91360079 -85.39072749 292 21 0 274 Chambers, Alabama, US
426 426 1019 Cherokee Alabama US 2020-05-01 02:32:28 34.17805983 -85.60638968 16 0 0 15 Cherokee, Alabama, US
448 448 1021 Chilton Alabama US 2020-05-01 02:32:28 32.85044126 -86.7173256 55 1 0 52 Chilton, Alabama, US
454 454 1023 Choctaw Alabama US 2020-05-01 02:32:28 32.02227341 -88.26564429999998 44 0 0 43 Choctaw, Alabama, US
484 484 1025 Clarke Alabama US 2020-05-01 02:32:28 31.68099859 -87.83548597 31 1 0 31 Clarke, Alabama, US
490 490 1027 Clay Alabama US 2020-05-01 02:32:28 33.26984193 -85.85836077 20 1 0 20 Clay, Alabama, US
512 512 1029 Cleburne Alabama US 2020-05-01 02:32:28 33.67679204 -85.52005899 12 1 0 11 Cleburne, Alabama, US
536 536 1031 Coffee Alabama US 2020-05-01 02:32:28 31.39932826 -85.98901039 110 0 0 111 Coffee, Alabama, US
540 540 1033 Colbert Alabama US 2020-05-01 02:32:28 34.69847452 -87.80168544 35 2 0 27 Colbert, Alabama, US

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

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