04-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,165 rows sorted by Deaths descending

✎ View and edit SQL

This data as json, copyable, CSV (advanced)

Suggested facets: Last_Update (date)

Link rowid FIPS Admin2 Province_State Country_Region Last_Update Lat Long_ Confirmed Deaths ▲ Recovered Active Combined_Key
3066 3066       Italy 2020-04-29 02:32:29 41.87194 12.56738 201505 27359 68941 105205 Italy
3139 3139       Spain 2020-04-29 02:32:29 40.463667 -3.7492199999999998 232128 23822 123903 84403 Spain
3043 3043       France 2020-04-29 02:32:29 46.2276 2.2137 167650 23631 46886 97059 France
3157 3157       United Kingdom 2020-04-29 02:32:29 55.3781 -3.4360000000000004 161145 21678 0 139467 United Kingdom
1860 1860 36061 New York City New York US 2020-04-29 02:32:29 40.76727260000001 -73.97152637 162338 17682 0 144656 New York City, New York, US
3000 3000       Belgium 2020-04-29 02:32:29 50.8333 4.469936 47334 7331 10943 29060 Belgium
3047 3047       Germany 2020-04-29 02:32:29 51.165690999999995 10.451526 159912 6314 117400 36198 Germany
3062 3062       Iran 2020-04-29 02:32:29 32.427908 53.68804599999999 92584 5877 72439 14268 Iran
3007 3007       Brazil 2020-04-29 02:32:29 -14.235 -51.9253 73235 5083 32544 35608 Brazil
3102 3102       Netherlands 2020-04-29 02:32:29 52.1326 5.2913 38416 4566 0 33850 Netherlands
2930 2930     Hubei China 2020-04-29 02:32:29 30.9756 112.2707 68128 4512 63616 0 Hubei, China
3153 3153       Turkey 2020-04-29 02:32:29 38.9637 35.2433 114653 2992 38809 72852 Turkey
2957 2957     Quebec Canada 2020-04-29 02:32:29 52.9399 -73.5491 25761 2456 0 24078 Quebec, Canada
3143 3143       Sweden 2020-04-29 02:32:29 60.128161 18.643501 19621 2355 1005 16261 Sweden
3144 3144       Switzerland 2020-04-29 02:32:29 46.8182 8.2275 29264 1699 22600 4965 Switzerland
2758 2758 26163 Wayne Michigan US 2020-04-29 02:32:29 42.28098405 -83.281255 16173 1682 0 14491 Wayne, Michigan, US
1840 1840 36059 Nassau New York US 2020-04-29 02:32:29 40.74066522 -73.58941873 35085 1647 0 33438 Nassau, New York, US
3093 3093       Mexico 2020-04-29 02:32:29 23.6345 -102.5528 16752 1569 11423 3760 Mexico
573 573 17031 Cook Illinois US 2020-04-29 02:32:29 41.84144849 -87.81658794 33449 1457 0 31992 Cook, Illinois, US
3064 3064       Ireland 2020-04-29 02:32:29 53.1424 -7.6921 19877 1159 9233 9485 Ireland
2455 2455 36103 Suffolk New York US 2020-04-29 02:32:29 40.88320119 -72.8012172 32724 1131 0 31593 Suffolk, New York, US
797 797 34013 Essex New Jersey US 2020-04-29 02:32:29 40.78681335 -74.24657979 13190 1090 0 12100 Essex, New Jersey, US
2953 2953     Ontario Canada 2020-04-29 02:32:29 51.2538 -85.3232 16500 1072 0 15428 Ontario, Canada
3060 3060       India 2020-04-29 02:32:29 20.593684 78.96288 31324 1008 7747 22569 India
172 172 34003 Bergen New Jersey US 2020-04-29 02:32:29 40.96010917 -74.07164325 15251 1002 0 14249 Bergen, New Jersey, US
1530 1530 6037 Los Angeles California US 2020-04-29 02:32:29 34.30828379 -118.2282411 20996 1002 0 19994 Los Angeles, California, US
2784 2784 36119 Westchester New York US 2020-04-29 02:32:29 41.16278376 -73.75741653 28245 983 0 27262 Westchester, New York, US
3117 3117       Portugal 2020-04-29 02:32:29 39.3999 -8.2245 24322 948 1389 21985 Portugal
3033 3033       Ecuador 2020-04-29 02:32:29 -1.8312 -78.1834 24258 871 1557 21830 Ecuador
3120 3120       Russia 2020-04-29 02:32:29 61.52401 105.31875600000001 93558 867 8456 84235 Russia
3114 3114       Peru 2020-04-29 02:32:29 -9.19 -75.0152 31190 854 9179 21157 Peru
3061 3061       Indonesia 2020-04-29 02:32:29 -0.7893 113.9213 9511 773 1254 7484 Indonesia
808 808 9001 Fairfield Connecticut US 2020-04-29 02:32:29 41.26809896 -73.3881171 10874 747 0 10127 Fairfield, Connecticut, US
1719 1719 25017 Middlesex Massachusetts US 2020-04-29 02:32:29 42.48607732 -71.39049229 13417 731 0 12686 Middlesex, Massachusetts, US
1173 1173 34017 Hudson New Jersey US 2020-04-29 02:32:29 40.73766234 -74.07515667 14309 722 0 13587 Hudson, New Jersey, US
3119 3119       Romania 2020-04-29 02:32:29 45.9432 24.9668 11616 663 3404 7549 Romania
1899 1899 26125 Oakland Michigan US 2020-04-29 02:32:29 42.66090111 -83.38595416 7012 654 0 6358 Oakland, Michigan, US
1094 1094 9003 Hartford Connecticut US 2020-04-29 02:32:29 41.80283011 -72.73103891 5224 643 0 4581 Hartford, Connecticut, US
2632 2632 34039 Union New Jersey US 2020-04-29 02:32:29 40.65835409 -74.30680092 12188 627 0 11561 Union, New Jersey, US
3116 3116       Poland 2020-04-29 02:32:29 51.9194 19.1451 12218 596 2655 8967 Poland
1556 1556 26099 Macomb Michigan US 2020-04-29 02:32:29 42.69158356 -82.92752801 5339 572 0 4767 Macomb, Michigan, US
2993 2993       Austria 2020-04-29 02:32:29 47.5162 14.5501 15357 569 12580 2208 Austria
3115 3115       Philippines 2020-04-29 02:32:29 12.879721 121.77401699999999 7958 530 975 6453 Philippines
2035 2035 42101 Philadelphia Pennsylvania US 2020-04-29 02:32:29 40.00338507 -75.1379271 13445 516 0 12929 Philadelphia, Pennsylvania, US
1720 1720 34023 Middlesex New Jersey US 2020-04-29 02:32:29 40.43629879 -74.41426991 11102 515 0 10587 Middlesex, New Jersey, US
2220 2220 36087 Rockland New York US 2020-04-29 02:32:29 41.15027894 -74.02560498 11453 481 0 10972 Rockland, New York, US
1856 1856 9009 New Haven Connecticut US 2020-04-29 02:32:29 41.4080325 -72.93620426 7089 478 0 6611 New Haven, Connecticut, US
1996 1996 34031 Passaic New Jersey US 2020-04-29 02:32:29 41.03238628 -74.29954144 11755 475 0 11280 Passaic, New Jersey, US
2454 2454 25025 Suffolk Massachusetts US 2020-04-29 02:32:29 42.3279514 -71.07850442 12140 469 0 11671 Suffolk, Massachusetts, US
1342 1342 53033 King Washington US 2020-04-29 02:32:29 47.49137892 -121.8346131 6001 448 0 5572 King, Washington, US
1884 1884 25021 Norfolk Massachusetts US 2020-04-29 02:32:29 42.16073095 -71.20530408 5567 448 0 5119 Norfolk, Massachusetts, US
2987 2987       Algeria 2020-04-29 02:32:29 28.0339 1.6596 3649 437 1651 1561 Algeria
3028 3028       Denmark 2020-04-29 02:32:29 56.2639 9.5018 8851 434 6121 2296 Denmark
1941 1941 22071 Orleans Louisiana US 2020-04-29 02:32:29 30.06971951 -89.92660315 6380 410 0 5970 Orleans, Louisiana, US
3068 3068       Japan 2020-04-29 02:32:29 36.204824 138.252924 13736 394 1899 11443 Japan
796 796 25009 Essex Massachusetts US 2020-04-29 02:32:29 42.6687626 -70.94687179 7972 383 0 7589 Essex, Massachusetts, US
1813 1813 34027 Morris New Jersey US 2020-04-29 02:32:29 40.86095313 -74.54553709999998 5128 377 0 4751 Morris, New Jersey, US
3034 3034       Egypt 2020-04-29 02:32:29 26.820553000000004 30.802497999999996 5042 359 1304 3379 Egypt
1048 1048 25013 Hampden Massachusetts US 2020-04-29 02:32:29 42.13440424 -72.63235561 3546 346 0 3200 Hampden, Massachusetts, US
1901 1901 34029 Ocean New Jersey US 2020-04-29 02:32:29 39.8895449 -74.28089251 6151 342 0 5809 Ocean, New Jersey, US
1261 1261 22051 Jefferson Louisiana US 2020-04-29 02:32:29 29.74075478 -90.11115756 6135 340 0 5795 Jefferson, Louisiana, US
1716 1716 12086 Miami-Dade Florida US 2020-04-29 02:32:29 25.6112362 -80.55170587 11831 324 0 11507 Miami-Dade, Florida, US
3110 3110       Pakistan 2020-04-29 02:32:29 30.3753 69.3451 14612 312 3233 11067 Pakistan
1752 1752 34025 Monmouth New Jersey US 2020-04-29 02:32:29 40.26549699 -74.22240686 5826 305 0 5521 Monmouth, New Jersey, US
1934 1934 36071 Orange New York US 2020-04-29 02:32:29 41.40337468 -74.30240757 8374 299 0 8075 Orange, New York, US
3058 3058       Hungary 2020-04-29 02:32:29 47.1625 19.5033 2649 291 516 1842 Hungary
3032 3032       Dominican Republic 2020-04-29 02:32:29 18.7357 -70.1627 6416 286 1165 4965 Dominican Republic
1606 1606 18097 Marion Indiana US 2020-04-29 02:32:29 39.78163624 -86.13826325 5080 282 0 4798 Marion, Indiana, US
3019 3019       Colombia 2020-04-29 02:32:29 4.5709 -74.2973 5949 269 1268 4412 Colombia
2077 2077 25023 Plymouth Massachusetts US 2020-04-29 02:32:29 41.94070556 -70.80802823 4744 256 0 4488 Plymouth, Massachusetts, US
1789 1789 42091 Montgomery Pennsylvania US 2020-04-29 02:32:29 40.21053671 -75.36652296 4043 249 0 3794 Montgomery, Pennsylvania, US
3072 3072       Korea, South 2020-04-29 02:32:29 35.90775700000001 127.766922 10761 246 8922 1593 Korea, South
2376 2376 34035 Somerset New Jersey US 2020-04-29 02:32:29 40.56465737 -74.61683016 3278 242 0 3036 Somerset, New Jersey, US
3155 3155       Ukraine 2020-04-29 02:32:29 48.3794 31.1656 9410 239 992 8179 Ukraine
2856 2856 25027 Worcester Massachusetts US 2020-04-29 02:32:29 42.35026951 -71.90493363 4999 229 0 4770 Worcester, Massachusetts, US
3027 3027       Czechia 2020-04-29 02:32:29 49.8175 15.472999999999999 7504 227 2948 4329 Czechia
1783 1783 24031 Montgomery Maryland US 2020-04-29 02:32:29 39.13676329 -77.20358245 4003 221 0 3782 Montgomery, Maryland, US
3065 3065       Israel 2020-04-29 02:32:29 31.046051000000002 34.851612 15672 213 8118 7772 Israel
1703 1703 34021 Mercer New Jersey US 2020-04-29 02:32:29 40.28047017 -74.70479631 3605 212 0 3393 Mercer, New Jersey, US
791 791 36029 Erie New York US 2020-04-29 02:32:29 42.76249024 -78.73063652 3089 207 0 2882 Erie, New York, US
2991 2991       Argentina 2020-04-29 02:32:29 -38.4161 -63.6167 4127 207 1162 2758 Argentina
3018 3018       Chile 2020-04-29 02:32:29 -35.6751 -71.543 14365 207 7710 6448 Chile
2122 2122 24033 Prince George's Maryland US 2020-04-29 02:32:29 38.83070039 -76.8496441 5496 206 0 5290 Prince George's, Maryland, US
3108 3108       Norway 2020-04-29 02:32:29 60.472 8.4689 7660 206 32 7422 Norway
3042 3042       Finland 2020-04-29 02:32:29 61.92411 25.748151 4740 199 2800 1741 Finland
1114 1114 27053 Hennepin Minnesota US 2020-04-29 02:32:29 45.00761521 -93.47694895 1524 193 0 1331 Hennepin, Minnesota, US
714 714 11001 District of Columbia District of Columbia US 2020-04-29 02:32:29 38.90417773 -77.01655992 3994 190 0 3804 District of Columbia, District of Columbia, US
479 479 32003 Clark Nevada US 2020-04-29 02:32:29 36.21458855 -115.0130241 3793 186 0 3607 Clark, Nevada, US
251 251 12011 Broward Florida US 2020-04-29 02:32:29 26.15184651 -80.48725556 4847 179 0 4668 Broward, Florida, US
924 924 26049 Genesee Michigan US 2020-04-29 02:32:29 43.02244215 -83.70589709 1533 174 0 1359 Genesee, Michigan, US
1731 1731 55079 Milwaukee Wisconsin US 2020-04-29 02:32:29 43.00486062 -87.96733172 2722 174 0 2548 Milwaukee, Wisconsin, US
1983 1983 12099 Palm Beach Florida US 2020-04-29 02:32:29 26.64676272 -80.46536002 2877 173 0 2704 Palm Beach, Florida, US
2585 2585 90018 Unassigned Indiana US 2020-04-29 02:32:29     0 171 0 0 Unassigned, Indiana, US
267 267 42017 Bucks Pennsylvania US 2020-04-29 02:32:29 40.33682119 -75.10836643 2675 168 0 2507 Bucks, Pennsylvania, US
3111 3111       Panama 2020-04-29 02:32:29 8.538 -80.7821 6021 167 455 5399 Panama
3098 3098       Morocco 2020-04-29 02:32:29 31.7917 -7.0926 4252 165 778 3309 Morocco
1408 1408 42071 Lancaster Pennsylvania US 2020-04-29 02:32:29 40.03904563 -76.24770128 1678 164 0 1514 Lancaster, Pennsylvania, US
694 694 42045 Delaware Pennsylvania US 2020-04-29 02:32:29 39.91680171 -75.40243663 3463 161 0 3302 Delaware, Pennsylvania, US
2410 2410 29189 St. Louis Missouri US 2020-04-29 02:32:29 38.63770039999999 -90.4458375 2965 159 0 2806 St. Louis, Missouri, US
241 241 25005 Bristol Massachusetts US 2020-04-29 02:32:29 41.79228404 -71.10872211 3270 155 0 3115 Bristol, Massachusetts, US

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

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