03-28-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,433 rows sorted by Recovered descending

✎ 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
3206 3206     Hubei China 3/28/20 1:26 30.9756 112.2707 67801 3177 62098 2526 Hubei, China
3339 3339       Italy 3/28/20 23:05 41.87194 12.56738 92472 10023 12384 70065 Italy
3408 3408       Spain 3/28/20 23:05 40.463667 -3.74922 73235 5982 12285 54968 Spain
3335 3335       Iran 3/28/20 23:05 32.427908 53.688046 35408 2517 11679 21212 Iran
3320 3320       Germany 3/28/20 23:05 51.165691 10.451526 57695 433 8481 48781 Germany
3316 3316       France 3/28/20 23:05 46.2276 2.2137 37162 2311 5700 29561 France
3345 3345       Korea, South 3/28/20 23:05 35.907757 127.766922 9478 144 4811 4523 Korea, South
3413 3413       Switzerland 3/28/20 23:05 46.8182 8.2275 14076 264 1530 12282 Switzerland
3198 3198     Guangdong China 3/28/20 2:13 23.3417 113.4244 1467 8 1341 118 Guangdong, China
3204 3204     Henan China 3/28/20 1:35 33.882 113.614 1275 22 1251 2 Henan, China
3259 3259     Zhejiang China 3/28/20 2:01 29.1832 120.0934 1251 1 1225 25 Zhejiang, China
3236 3236     Recovered US 3/28/20 23:05 0.0 0.0 0 0 1072 0 Recovered, US
3275 3275       Belgium 3/28/20 23:05 50.8333 4.469936 9134 353 1063 7718 Belgium
3207 3207     Hunan China 3/14/20 8:25 27.6104 111.7088 1018 4 1014 0 Hunan, China
3174 3174     Anhui China 3/8/20 5:19 31.8257 117.2264 990 6 984 0 Anhui, China
3211 3211     Jiangxi China 3/23/20 1:27 27.614 115.7221 936 1 934 1 Jiangxi, China
3242 3242     Shandong China 3/27/20 7:48 36.3427 118.1498 772 7 752 13 Shandong, China
3210 3210     Jiangsu China 3/27/20 1:49 32.9711 119.455 641 0 631 10 Jiangsu, China
3302 3302       Diamond Princess 3/28/20 23:05 0.0 0.0 712 10 597 105 Diamond Princess
3183 3183     Chongqing China 3/23/20 23:34 30.0572 107.874 578 6 570 2 Chongqing, China
3245 3245     Sichuan China 3/27/20 2:27 30.6171 102.7103 548 3 536 9 Sichuan, China
3203 3203     Heilongjiang China 3/26/20 0:15 47.862 127.7615 484 13 469 2 Heilongjiang, China
3235 3235     Recovered Canada 3/28/20 23:10 0.0 0.0 0 0 466 0 Recovered, Canada
3177 3177     Beijing China 3/28/20 6:15 40.1824 116.4142 573 8 410 155 Beijing, China
3341 3341       Japan 3/28/20 23:05 36.204824 138.252924 1693 52 404 1237 Japan
3243 3243     Shanghai China 3/28/20 2:01 31.202 121.4491 485 5 334 146 Shanghai, China
3359 3359       Malaysia 3/28/20 23:05 4.210484 101.975766 2320 27 320 1973 Malaysia
3202 3202     Hebei China 3/23/20 1:53 39.549 116.1306 319 6 310 3 Hebei, China
3190 3190     Fujian China 3/28/20 1:35 26.0789 117.9874 337 1 295 41 Fujian, China
3271 3271       Bahrain 3/28/20 23:05 26.0275 50.55 476 4 265 207 Bahrain
3199 3199     Guangxi China 3/20/20 4:33 23.8298 108.7881 254 2 250 2 Guangxi, China
3241 3241     Shaanxi China 3/26/20 2:14 35.1917 108.8701 253 3 242 8 Shaanxi, China
3268 3268       Austria 3/28/20 23:05 47.5162 14.5501 8271 68 225 7978 Austria
3403 3403       Singapore 3/28/20 23:05 1.2833 103.8333 802 2 198 602 Singapore
3253 3253     Victoria Australia 3/28/20 23:11 -37.8136 144.9631 685 3 191 491 Victoria, Australia
3258 3258     Yunnan China 3/26/20 23:16 24.974 101.487 180 2 172 6 Yunnan, China
3201 3201     Hainan China 3/24/20 4:29 19.1959 109.7453 168 6 162 0 Hainan, China
3200 3200     Guizhou China 3/18/20 1:37 26.8154 106.8748 146 2 144 0 Guizhou, China
3391 3391       Romania 3/28/20 23:05 45.9432 24.9668 1452 37 139 1276 Romania
3426 3426       United Kingdom 3/28/20 23:05 55.3781 -3.436 17089 1019 135 15935 United Kingdom
3244 3244     Shanxi China 3/25/20 23:21 37.5777 112.2922 135 0 133 2 Shanxi, China
3250 3250     Tianjin China 3/28/20 8:36 39.3054 117.323 161 3 133 25 Tianjin, China
3336 3336       Iraq 3/28/20 23:05 33.223191 43.679291 506 42 131 333 Iraq
3191 3191     Gansu China 3/28/20 2:33 37.8099 101.0583 136 2 125 9 Gansu, China
3213 3213     Liaoning China 3/28/20 13:46 41.2956 122.6085 132 2 124 6 Liaoning, China
3307 3307       Egypt 3/28/20 23:05 26.820553 30.802498 576 36 121 419 Egypt
3332 3332       Iceland 3/28/20 23:05 64.9631 -19.0208 963 2 114 847 Iceland
3205 3205     Hong Kong China 3/28/20 12:50 22.3 114.2 561 4 112 445 Hong Kong, China
3417 3417       Thailand 3/28/20 23:05 15.870032 100.992541 1245 6 100 1142 Thailand
3212 3212     Jilin China 3/28/20 0:42 43.6661 126.1923 97 1 92 4 Jilin, China
3333 3333       India 3/28/20 23:05 20.593684 78.96288 987 24 84 879 India
3338 3338       Israel 3/28/20 23:05 31.046051 34.851612 3901 13 84 3518 Israel
3223 3223     Ningxia China 3/16/20 8:47 37.2692 106.1655 75 0 75 0 Ningxia, China
3208 3208     Inner Mongolia China 3/28/20 2:19 44.0935 113.9448 94 1 74 19 Inner Mongolia, China
3256 3256     Xinjiang China 3/8/20 5:31 41.1129 85.2401 76 3 73 0 Xinjiang, China
3266 3266       Argentina 3/28/20 23:05 -38.4161 -63.6167 690 18 72 600 Argentina
3422 3422       Turkey 3/28/20 23:05 38.9637 35.2433 7402 108 70 7224 Turkey
3347 3347       Kuwait 3/28/20 23:05 29.31166 47.481766 235 0 64 171 Kuwait
3291 3291       Chile 3/28/20 23:05 -35.6751 -71.543 1909 6 61 1842 Chile
3334 3334       Indonesia 3/28/20 23:05 -0.7893 113.9213 1155 102 59 994 Indonesia
3187 3187     Faroe Islands Denmark 3/28/20 23:05 61.8926 -6.9118 155 0 54 101 Faroe Islands, Denmark
3322 3322       Greece 3/28/20 23:05 39.0742 21.8243 1061 32 52 977 Greece
3425 3425       United Arab Emirates 3/28/20 23:05 23.424076 53.847818 468 2 52 414 United Arab Emirates
3375 3375       New Zealand 3/28/20 23:05 -40.9006 174.886 451 0 50 401 New Zealand
3392 3392       Russia 3/28/20 23:05 61.52401 105.318756 1264 4 49 1211 Russia
3297 3297       Croatia 3/28/20 23:05 45.1 15.2 657 5 45 607 Croatia
3390 3390       Qatar 3/28/20 23:05 25.3548 51.1839 590 1 45 544 Qatar
3389 3389       Portugal 3/28/20 23:05 39.3999 -8.2245 5170 100 43 5027 Portugal
3356 3356       Luxembourg 3/28/20 23:05 49.8153 6.1296 1831 18 40 1773 Luxembourg
3429 3429       Venezuela 3/28/20 23:05 6.4238 -66.5897 119 2 39 78 Venezuela
3399 3399       Saudi Arabia 3/28/20 23:05 23.885942 45.079162 1203 4 37 1162 Saudi Arabia
3387 3387       Philippines 3/28/20 23:05 12.879721 121.774017 1075 68 35 972 Philippines
3331 3331       Hungary 3/28/20 23:05 47.1625 19.5033 343 11 34 298 Hungary
3274 3274       Belarus 3/28/20 23:05 53.7098 27.9534 94 0 32 62 Belarus
3261 3261       Albania 3/28/20 23:05 41.1533 20.1683 197 10 31 156 Albania
3262 3262       Algeria 3/28/20 23:05 28.0339 1.6596 454 29 31 394 Algeria
3407 3407       South Africa 3/28/20 23:05 -30.5595 22.9375 1187 1 31 1155 South Africa
3267 3267       Armenia 3/28/20 23:05 40.0691 45.0382 407 1 30 376 Armenia
3351 3351       Lebanon 3/28/20 23:05 33.8547 35.8623 412 8 30 374 Lebanon
3415 3415       Taiwan* 3/28/20 6:58 23.7 121.0 283 2 30 251 Taiwan*
3382 3382       Pakistan 3/28/20 23:05 30.3753 69.3451 1495 12 29 1454 Pakistan
3255 3255     Western Australia Australia 3/28/20 23:11 -31.9505 115.8605 278 2 28 248 Western Australia, Australia
3282 3282       Brunei 3/28/20 23:05 4.5353 114.7277 120 1 25 94 Brunei
3381 3381       Oman 3/28/20 23:05 21.512583 55.923255 152 0 23 129 Oman
3284 3284       Burkina Faso 3/28/20 23:05 12.2383 -1.5616 207 11 21 175 Burkina Faso
3430 3430       Vietnam 3/28/20 23:05 14.058324 108.277199 174 0 21 153 Vietnam
3311 3311       Estonia 3/28/20 23:05 58.5953 25.0136 645 1 20 624 Estonia
3232 3232     Qinghai China 2/23/20 11:19 35.7452 95.9956 18 0 18 0 Qinghai, China
3342 3342       Jordan 3/28/20 23:05 31.24 36.51 246 1 18 227 Jordan
3400 3400       Senegal 3/28/20 23:05 14.4974 -14.4524 130 0 18 112 Senegal
3431 3431       West Bank and Gaza 3/28/20 23:05 31.9522 35.2332 98 1 18 79 West Bank and Gaza
3196 3196     Guadeloupe France 3/28/20 23:05 16.265 -61.551 102 2 17 83 Guadeloupe, France
3343 3343       Kazakhstan 3/28/20 23:05 48.0196 66.9237 228 1 16 211 Kazakhstan
3386 3386       Peru 3/28/20 23:05 -9.19 -75.0152 671 16 16 639 Peru
3412 3412       Sweden 3/28/20 23:05 60.128161 18.643501 3447 105 16 3326 Sweden
3269 3269       Azerbaijan 3/28/20 23:05 40.1431 47.5769 182 4 15 163 Azerbaijan
3272 3272       Bangladesh 3/28/20 23:05 23.685 90.3563 48 5 15 28 Bangladesh
3299 3299       Cyprus 3/28/20 23:05 35.1264 33.4299 179 5 15 159 Cyprus
3192 3192     Gibraltar United Kingdom 3/28/20 23:05 36.1408 -5.3536 56 0 14 42 Gibraltar, United Kingdom
3319 3319       Georgia 3/28/20 23:05 42.3154 43.3569 90 0 14 76 Georgia

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

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