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 Deaths 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
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
3206 3206     Hubei China 3/28/20 1:26 30.9756 112.2707 67801 3177 62098 2526 Hubei, China
3335 3335       Iran 3/28/20 23:05 32.427908 53.688046 35408 2517 11679 21212 Iran
3316 3316       France 3/28/20 23:05 46.2276 2.2137 37162 2311 5700 29561 France
3426 3426       United Kingdom 3/28/20 23:05 55.3781 -3.436 17089 1019 135 15935 United Kingdom
3374 3374       Netherlands 3/28/20 23:05 52.1326 5.2913 9762 639 3 9120 Netherlands
2067 2067 36061 New York City New York US 3/28/20 23:05 40.7672726 -73.97152637 29776 517 0 0 New York City, New York, US
3320 3320       Germany 3/28/20 23:05 51.165691 10.451526 57695 433 8481 48781 Germany
3275 3275       Belgium 3/28/20 23:05 50.8333 4.469936 9134 353 1063 7718 Belgium
3413 3413       Switzerland 3/28/20 23:05 46.8182 8.2275 14076 264 1530 12282 Switzerland
3345 3345       Korea, South 3/28/20 23:05 35.907757 127.766922 9478 144 4811 4523 Korea, South
1506 1506 53033 King Washington US 3/28/20 23:05 47.49137892 -121.8346131 2077 136 0 0 King, Washington, US
3281 3281       Brazil 3/28/20 23:05 -14.235 -51.9253 3904 111 6 3787 Brazil
2872 2872   Unassigned New York US 3/28/20 23:05 0.0 0.0 0 109 0 0 Unassigned, New York, US
3422 3422       Turkey 3/28/20 23:05 38.9637 35.2433 7402 108 70 7224 Turkey
3412 3412       Sweden 3/28/20 23:05 60.128161 18.643501 3447 105 16 3326 Sweden
3334 3334       Indonesia 3/28/20 23:05 -0.7893 113.9213 1155 102 59 994 Indonesia
3389 3389       Portugal 3/28/20 23:05 39.3999 -8.2245 5170 100 43 5027 Portugal
2871 2871   Unassigned New Jersey US 3/28/20 23:05 0.0 0.0 2478 86 0 0 Unassigned, New Jersey, US
2153 2153 22071 Orleans Louisiana US 3/28/20 23:05 30.06971951 -89.92660315 1298 70 0 0 Orleans, Louisiana, US
3268 3268       Austria 3/28/20 23:05 47.5162 14.5501 8271 68 225 7978 Austria
3387 3387       Philippines 3/28/20 23:05 12.879721 121.774017 1075 68 35 972 Philippines
3301 3301       Denmark 3/28/20 23:05 56.2639 9.5018 2201 65 1 2135 Denmark
3341 3341       Japan 3/28/20 23:05 36.204824 138.252924 1693 52 404 1237 Japan
3306 3306       Ecuador 3/28/20 23:05 -1.8312 -78.1834 1823 48 3 1772 Ecuador
3022 3022 26163 Wayne Michigan US 3/28/20 23:05 42.28098405 -83.281255 2316 46 0 0 Wayne, Michigan, US
3233 3233     Quebec Canada 3/28/20 23:10 52.9399 -73.5491 2498 43 0 0 Quebec, Canada
3336 3336       Iraq 3/28/20 23:05 33.223191 43.679291 506 42 131 333 Iraq
3391 3391       Romania 3/28/20 23:05 45.9432 24.9668 1452 37 139 1276 Romania
3307 3307       Egypt 3/28/20 23:05 26.820553 30.802498 576 36 121 419 Egypt
3337 3337       Ireland 3/28/20 23:05 53.1424 -7.6921 2415 36 5 2374 Ireland
3322 3322       Greece 3/28/20 23:05 39.0742 21.8243 1061 32 52 977 Greece
2110 2110 26125 Oakland Michigan US 3/28/20 23:05 42.66090111 -83.38595416 1018 31 0 0 Oakland, Michigan, US
2721 2721 36103 Suffolk New York US 3/28/20 23:05 40.88320119 -72.8012172 4138 30 0 0 Suffolk, New York, US
3262 3262       Algeria 3/28/20 23:05 28.0339 1.6596 454 29 31 394 Algeria
629 629 17031 Cook Illinois US 3/28/20 23:05 41.84144849 -87.81658794 2613 28 0 0 Cook, Illinois, US
3305 3305       Dominican Republic 3/28/20 23:05 18.7357 -70.1627 719 28 3 688 Dominican Republic
2046 2046 36059 Nassau New York US 3/28/20 23:05 40.74066522 -73.58941873 5537 27 0 0 Nassau, New York, US
3359 3359       Malaysia 3/28/20 23:05 4.210484 101.975766 2320 27 320 1973 Malaysia
1411 1411 22051 Jefferson Louisiana US 3/28/20 23:05 29.74075478 -90.11115756 744 26 0 0 Jefferson, Louisiana, US
1717 1717 6037 Los Angeles California US 3/28/20 23:05 34.30828379 -118.2282411 1465 26 0 0 Los Angeles, California, US
2530 2530 6085 Santa Clara California US 3/28/20 23:05 37.23104908 -121.6970462 591 25 0 0 Santa Clara, California, US
3370 3370       Morocco 3/28/20 23:05 31.7917 -7.0926 402 25 11 366 Morocco
3333 3333       India 3/28/20 23:05 20.593684 78.96288 987 24 84 879 India
2634 2634 53061 Snohomish Washington US 3/28/20 23:05 48.04615983 -121.7170703 913 23 0 0 Snohomish, Washington, US
3380 3380       Norway 3/28/20 23:05 60.472 8.4689 4015 23 7 3985 Norway
3204 3204     Henan China 3/28/20 1:35 33.882 113.614 1275 22 1251 2 Henan, China
3398 3398       San Marino 3/28/20 23:05 43.9424 12.4578 224 22 6 196 San Marino
901 901 9001 Fairfield Connecticut US 3/28/20 23:05 41.26809896 -73.3881171 908 20 0 0 Fairfield, Connecticut, US
3229 3229     Ontario Canada 3/28/20 23:10 51.2538 -85.3232 1144 18 0 0 Ontario, Canada
3266 3266       Argentina 3/28/20 23:05 -38.4161 -63.6167 690 18 72 600 Argentina
3356 3356       Luxembourg 3/28/20 23:05 49.8153 6.1296 1831 18 40 1773 Luxembourg
3388 3388       Poland 3/28/20 23:05 51.9194 19.1451 1638 18 7 1613 Poland
1746 1746 26099 Macomb Michigan US 3/28/20 23:05 42.69158356 -82.92752801 534 17 0 0 Macomb, Michigan, US
3179 3179     British Columbia Canada 3/28/20 23:10 53.7267 -127.6476 884 17 0 0 British Columbia, Canada
3386 3386       Peru 3/28/20 23:05 -9.19 -75.0152 671 16 16 639 Peru
3383 3383       Panama 3/28/20 23:05 8.538 -80.7821 786 14 2 770 Panama
191 191 34003 Bergen New Jersey US 3/28/20 23:05 40.96010917 -74.07164325 1838 13 0 0 Bergen, New Jersey, US
806 806 13095 Dougherty Georgia US 3/28/20 23:05 31.53328528 -84.21722377 205 13 0 0 Dougherty, Georgia, US
3203 3203     Heilongjiang China 3/26/20 0:15 47.862 127.7615 484 13 469 2 Heilongjiang, China
3338 3338       Israel 3/28/20 23:05 31.046051 34.851612 3901 13 84 3518 Israel
995 995 13121 Fulton Georgia US 3/28/20 23:05 33.79216944 -84.46319413 373 12 0 0 Fulton, Georgia, US
3365 3365       Mexico 3/28/20 23:05 23.6345 -102.5528 717 12 4 701 Mexico
3382 3382       Pakistan 3/28/20 23:05 30.3753 69.3451 1495 12 29 1454 Pakistan
3284 3284       Burkina Faso 3/28/20 23:05 12.2383 -1.5616 207 11 21 175 Burkina Faso
3300 3300       Czechia 3/28/20 23:05 49.8175 15.473 2631 11 11 2609 Czechia
3331 3331       Hungary 3/28/20 23:05 47.1625 19.5033 343 11 34 298 Hungary
284 284 12011 Broward Florida US 3/28/20 23:05 26.15184651 -80.48725556 814 10 0 0 Broward, Florida, US
528 528 32003 Clark Nevada US 3/28/20 23:05 36.21458855 -115.0130241 443 10 0 0 Clark, Nevada, US
1797 1797 18097 Marion Indiana US 3/28/20 23:05 39.78163624 -86.13826325 584 10 0 0 Marion, Indiana, US
3051 3051 36119 Westchester New York US 3/28/20 23:05 41.16278376 -73.75741653 7875 10 0 0 Westchester, New York, US
3261 3261       Albania 3/28/20 23:05 41.1533 20.1683 197 10 31 156 Albania
3302 3302       Diamond Princess 3/28/20 23:05 0.0 0.0 712 10 597 105 Diamond Princess
3401 3401       Serbia 3/28/20 23:05 44.0165 21.0059 659 10 0 649 Serbia
713 713 48113 Dallas Texas US 3/28/20 23:05 32.76670599 -96.7779605 439 9 0 0 Dallas, Texas, US
1930 1930 55079 Milwaukee Wisconsin US 3/28/20 23:05 43.00486062 -87.96733172 541 9 0 0 Milwaukee, Wisconsin, US
2868 2868   Unassigned Massachusetts US 3/28/20 23:05 0.0 0.0 356 9 0 0 Unassigned, Massachusetts, US
3315 3315       Finland 3/28/20 23:05 61.92411 25.748151 1167 9 10 1148 Finland
3405 3405       Slovenia 3/28/20 23:05 46.1512 14.9955 684 9 10 665 Slovenia
3424 3424       Ukraine 3/28/20 23:05 48.3794 31.1656 356 9 5 342 Ukraine
582 582 13067 Cobb Georgia US 3/28/20 23:05 33.94243204 -84.5761255 181 8 0 0 Cobb, Georgia, US
2091 2091 25021 Norfolk Massachusetts US 3/28/20 23:05 42.16073095 -71.20530408 490 8 0 0 Norfolk, Massachusetts, US
2440 2440 6065 Riverside California US 3/28/20 23:05 33.74314981 -115.9933578 183 8 0 0 Riverside, California, US
2461 2461 36087 Rockland New York US 3/28/20 23:05 41.15027894 -74.02560498 1896 8 0 0 Rockland, New York, US
2860 2860   Unassigned Florida US 3/28/20 23:05 0.0 0.0 0 8 0 0 Unassigned, Florida, US
3177 3177     Beijing China 3/28/20 6:15 40.1824 116.4142 573 8 410 155 Beijing, China
3198 3198     Guangdong China 3/28/20 2:13 23.3417 113.4244 1467 8 1341 118 Guangdong, China
3221 3221     New South Wales Australia 3/28/20 23:11 -33.8688 151.2093 1617 8 4 1605 New South Wales, Australia
3351 3351       Lebanon 3/28/20 23:05 33.8547 35.8623 412 8 30 374 Lebanon
3421 3421       Tunisia 3/28/20 23:05 33.886917 9.537499 278 8 2 268 Tunisia
860 860 8041 El Paso Colorado US 3/28/20 23:05 38.83240149 -104.5251411 160 7 0 0 El Paso, Colorado, US
889 889 34013 Essex New Jersey US 3/28/20 23:05 40.78681335 -74.24657979 1086 7 0 0 Essex, New Jersey, US
2207 2207 34031 Passaic New Jersey US 3/28/20 23:05 41.03238628 -74.29954144 608 7 0 0 Passaic, New Jersey, US
2875 2875   Unassigned Vermont US 3/28/20 23:05 0.0 0.0 7 7 0 0 Unassigned, Vermont, US
3242 3242     Shandong China 3/27/20 7:48 36.3427 118.1498 772 7 752 13 Shandong, China
3283 3283       Bulgaria 3/28/20 23:05 42.7339 25.4858 331 7 11 313 Bulgaria
531 531 53011 Clark Washington US 3/28/20 23:05 45.77568046 -122.4829204 82 6 0 0 Clark, Washington, US
821 821 17043 DuPage Illinois US 3/28/20 23:05 41.85116968 -88.08642662 202 6 0 0 DuPage, Illinois, US
882 882 36029 Erie New York US 3/28/20 23:05 42.76249024 -78.73063652 318 6 0 0 Erie, New York, US

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