04-08-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

2,884 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
2786 2786       Italy 2020-04-08 22:51:39 41.87194 12.56738 139422 17669 26491 95262 Italy
2859 2859       Spain 2020-04-08 22:51:39 40.463667 -3.7492199999999998 148220 14792 48021 85407 Spain
2763 2763       France 2020-04-08 22:51:39 46.2276 2.2137 81144 10856 21254 80827 France
2877 2877       United Kingdom 2020-04-08 22:51:39 55.3781 -3.4360000000000004 60733 7097 135 53501 United Kingdom
1688 1688 36061 New York City New York US 2020-04-08 22:51:58 40.76727260000001 -73.97152637 81803 4571 0 0 New York City, New York, US
2782 2782       Iran 2020-04-08 22:51:39 32.427908 53.68804599999999 64586 3993 29812 30781 Iran
2650 2650     Hubei China 2020-04-08 00:37:38 30.9756 112.2707 67803 3213 64142 448 Hubei, China
2767 2767       Germany 2020-04-08 22:51:39 51.165690999999995 10.451526 113296 2349 46300 64647 Germany
2822 2822       Netherlands 2020-04-08 22:51:39 52.1326 5.2913 20549 2248 250 18051 Netherlands
2720 2720       Belgium 2020-04-08 22:51:39 50.8333 4.469936 23403 2240 4681 16482 Belgium
2864 2864       Switzerland 2020-04-08 22:51:39 46.8182 8.2275 23280 895 9800 12585 Switzerland
2727 2727       Brazil 2020-04-08 22:51:39 -14.235 -51.9253 16170 819 127 15224 Brazil
2873 2873       Turkey 2020-04-08 22:51:39 38.9637 35.2433 38226 812 1846 35568 Turkey
2863 2863       Sweden 2020-04-08 22:51:39 60.128161 18.643501 8419 687 205 7527 Sweden
1670 1670 36059 Nassau New York US 2020-04-08 22:51:58 40.74066522 -73.58941873 18548 500 0 0 Nassau, New York, US
2492 2492 26163 Wayne Michigan US 2020-04-08 22:51:58 42.278056 -83.37861099999998 9626 446 0 0 Wayne,Michigan,US
2677 2677     Quebec Canada 2020-04-08 22:58:44 52.9399 -73.5491 10031 416 0 0 Quebec, Canada
2837 2837       Portugal 2020-04-08 22:51:39 39.3999 -8.2245 13141 380 196 12565 Portugal
2214 2214 36103 Suffolk New York US 2020-04-08 22:51:58 40.88320119 -72.8012172 17008 323 0 0 Suffolk, New York, US
158 158 34003 Bergen New Jersey US 2020-04-08 22:51:58 40.96010917 -74.07164325 7874 314 0 0 Bergen, New Jersey, US
528 528 17031 Cook Illinois US 2020-04-08 22:51:58 41.84144849 -87.81658794 10520 310 0 0 Cook, Illinois, US
1222 1222 53033 King Washington US 2020-04-08 22:51:58 47.49137892 -121.8346131 3688 283 0 0 King, Washington, US
2514 2514 36119 Westchester New York US 2020-04-08 22:51:58 41.16278376 -73.75741653 15887 283 0 0 Westchester, New York, US
737 737 34013 Essex New Jersey US 2020-04-08 22:51:58 40.78681335 -74.24657979 5598 276 0 0 Essex, New Jersey, US
2713 2713       Austria 2020-04-08 22:51:39 47.5162 14.5501 12942 273 4512 8157 Austria
2753 2753       Ecuador 2020-04-08 22:51:39 -1.8312 -78.1834 4450 242 140 4068 Ecuador
2781 2781       Indonesia 2020-04-08 22:51:39 -0.7893 113.9213 2956 240 222 2494 Indonesia
2784 2784       Ireland 2020-04-08 22:51:39 53.1424 -7.6921 6074 235 25 5814 Ireland
1721 1721 26125 Oakland Michigan US 2020-04-08 22:51:58 42.66090111 -83.38595416 4007 234 0 0 Oakland, Michigan, US
2839 2839       Romania 2020-04-08 22:51:39 45.9432 24.9668 4761 220 528 4013 Romania
2748 2748       Denmark 2020-04-08 22:51:39 56.2639 9.5018 5402 218 1621 3563 Denmark
1761 1761 22071 Orleans Louisiana US 2020-04-08 22:51:58 30.06971951 -89.92660315 5070 208 0 0 Orleans, Louisiana, US
2707 2707       Algeria 2020-04-08 22:51:39 28.0339 1.6596 1572 205 237 1130 Algeria
2792 2792       Korea, South 2020-04-08 22:51:39 35.90775700000001 127.766922 10384 200 6776 3408 Korea, South
1393 1393 6037 Los Angeles California US 2020-04-08 22:51:58 34.30828379 -118.22824109999999 7559 198 0 0 Los Angeles, California, US
2835 2835       Philippines 2020-04-08 22:51:39 12.879721 121.77401699999999 3870 182 96 3592 Philippines
2780 2780       India 2020-04-08 22:51:39 20.593684 78.96288 5916 178 506 5232 India
2836 2836       Poland 2020-04-08 22:51:39 51.9194 19.1451 5205 159 222 4824 Poland
2004 2004 36087 Rockland New York US 2020-04-08 22:51:58 41.15027894 -74.02560498 6413 154 0 0 Rockland, New York, US
2673 2673     Ontario Canada 2020-04-08 22:58:44 51.2538 -85.3232 5276 153 0 0 Ontario, Canada
2353 2353 90036 Unassigned New York US 2020-04-08 22:51:58     0 152 0 0 Unassigned, New York, US
1148 1148 22051 Jefferson Louisiana US 2020-04-08 22:51:58 29.74075478 -90.11115756 4092 149 0 0 Jefferson, Louisiana, US
1418 1418 26099 Macomb Michigan US 2020-04-08 22:51:58 42.69158356 -82.92752801 2626 141 0 0 Macomb, Michigan, US
2813 2813       Mexico 2020-04-08 22:51:39 23.6345 -102.5528 2785 141 633 2011 Mexico
1568 1568 34023 Middlesex New Jersey US 2020-04-08 22:51:58 40.43629879 -74.41426991 4156 139 0 0 Middlesex, New Jersey, US
2335 2335 90018 Unassigned Indiana US 2020-04-08 22:51:58     0 135 0 0 Unassigned, Indiana, US
745 745 9001 Fairfield Connecticut US 2020-04-08 22:51:58 41.26809896 -73.3881171 4136 132 0 0 Fairfield, Connecticut, US
2376 2376 34039 Union New Jersey US 2020-04-08 22:51:58 40.65835409 -74.30680092 4831 125 0 0 Union, New Jersey, US
1066 1066 34017 Hudson New Jersey US 2020-04-08 22:51:58 40.73766234 -74.07515667 5437 122 0 0 Hudson, New Jersey, US
2834 2834       Peru 2020-04-08 22:51:39 -9.19 -75.0152 4342 121 1333 2888 Peru
2752 2752       Dominican Republic 2020-04-08 22:51:39 18.7357 -70.1627 2111 108 50 1953 Dominican Republic
1754 1754 36071 Orange New York US 2020-04-08 22:51:58 41.40337468 -74.30240757 4075 107 0 0 Orange, New York, US
2754 2754       Egypt 2020-04-08 22:51:39 26.820553000000004 30.802497999999996 1560 103 305 1152 Egypt
1647 1647 34027 Morris New Jersey US 2020-04-08 22:51:58 40.86095313 -74.54553709999998 2468 102 0 0 Morris, New Jersey, US
1723 1723 34029 Ocean New Jersey US 2020-04-08 22:51:58 39.8895449 -74.28089251 2856 101 0 0 Ocean, New Jersey, US
2828 2828       Norway 2020-04-08 22:51:39 60.472 8.4689 6086 101 32 5953 Norway
2747 2747       Czechia 2020-04-08 22:51:39 49.8175 15.472999999999999 5312 99 233 4980 Czechia
2788 2788       Japan 2020-04-08 22:51:39 36.204824 138.252924 4257 93 622 3542 Japan
2818 2818       Morocco 2020-04-08 22:51:39 31.7917 -7.0926 1275 93 97 1085 Morocco
1844 1844 42101 Philadelphia Pennsylvania US 2020-04-08 22:51:58 40.00338507 -75.1379271 4777 87 0 0 Philadelphia, Pennsylvania, US
1594 1594 34025 Monmouth New Jersey US 2020-04-08 22:51:58 40.26549699 -74.22240686 3038 86 0 0 Monmouth, New Jersey, US
2769 2769       Greece 2020-04-08 22:51:39 39.0742 21.8243 1884 83 269 1532 Greece
1567 1567 25017 Middlesex Massachusetts US 2020-04-08 22:51:58 42.48607732 -71.39049229 3545 80 0 0 Middlesex, Massachusetts, US
2785 2785       Israel 2020-04-08 22:51:39 31.046051000000002 34.851612 9906 80 1191 8530 Israel
1810 1810 34031 Passaic New Jersey US 2020-04-08 22:51:58 41.03238628 -74.29954144 4372 71 0 0 Passaic, New Jersey, US
1798 1798 12099 Palm Beach Florida US 2020-04-08 22:51:58 26.64676272 -80.46536002 1206 69 0 0 Palm Beach, Florida, US
2783 2783       Iraq 2020-04-08 22:51:39 33.223191 43.679291 1202 69 452 681 Iraq
441 441 32003 Clark Nevada US 2020-04-08 22:51:58 36.21458855 -115.0130241 1878 65 0 0 Clark, Nevada, US
2138 2138 53061 Snohomish Washington US 2020-04-08 22:51:58 48.04615983 -121.7170703 1695 65 0 0 Snohomish, Washington, US
2807 2807       Malaysia 2020-04-08 22:51:39 4.210483999999999 101.97576600000001 4119 65 1487 2567 Malaysia
2850 2850       Serbia 2020-04-08 22:51:39 44.0165 21.0059 2666 65 0 2601 Serbia
2711 2711       Argentina 2020-04-08 22:51:39 -38.4161 -63.6167 1715 63 358 1294 Argentina
2840 2840       Russia 2020-04-08 22:51:39 61.52401 105.31875600000001 8672 63 580 8029 Russia
960 960 25013 Hampden Massachusetts US 2020-04-08 22:51:58 42.13440424 -72.63235561 1081 62 0 0 Hampden, Massachusetts, US
672 672 13095 Dougherty Georgia US 2020-04-08 22:51:58 31.53328528 -84.21722377 986 61 0 0 Dougherty, Georgia, US
2830 2830       Pakistan 2020-04-08 22:51:39 30.3753 69.3451 4263 61 467 3735 Pakistan
1684 1684 9009 New Haven Connecticut US 2020-04-08 22:51:58 41.408032500000004 -72.93620426 1664 60 0 0 New Haven, Connecticut, US
2831 2831       Panama 2020-04-08 22:51:39 8.538 -80.7821 2249 59 16 2174 Panama
232 232 12011 Broward Florida US 2020-04-08 22:51:58 26.15184651 -80.48725556 2358 58 0 0 Broward, Florida, US
1464 1464 18097 Marion Indiana US 2020-04-08 22:51:58 39.78163624 -86.13826325 2290 58 0 0 Marion, Indiana, US
2778 2778       Hungary 2020-04-08 22:51:39 47.1625 19.5033 895 58 94 743 Hungary
1577 1577 55079 Milwaukee Wisconsin US 2020-04-08 22:51:58 43.00486062 -87.96733172 1416 56 0 0 Milwaukee, Wisconsin, US
2739 2739       Colombia 2020-04-08 22:51:39 4.5709 -74.2973 2054 54 123 1877 Colombia
2328 2328 90009 Unassigned Connecticut US 2020-04-08 22:51:58     292 52 0 0 Unassigned, Connecticut, US
2875 2875       Ukraine 2020-04-08 22:51:39 48.3794 31.1656 1668 52 35 1581 Ukraine
736 736 25009 Essex Massachusetts US 2020-04-08 22:51:58 42.6687626 -70.94687179 2103 50 0 0 Essex, Massachusetts, US
1565 1565 12086 Miami-Dade Florida US 2020-04-08 22:51:58 25.6112362 -80.55170587 5354 49 0 0 Miami-Dade, Florida, US
999 999 9003 Hartford Connecticut US 2020-04-08 22:51:58 41.80283011 -72.73103891 1045 48 0 0 Hartford, Connecticut, US
2213 2213 25025 Suffolk Massachusetts US 2020-04-08 22:51:58 42.327951399999996 -71.07850442 3600 48 0 0 Suffolk, Massachusetts, US
2738 2738       Chile 2020-04-08 22:51:39 -35.6751 -71.543 5546 48 1115 4383 Chile
2059 2059 6085 Santa Clara California US 2020-04-08 22:51:58 37.23104908 -121.6970462 1380 46 0 0 Santa Clara, California, US
2144 2144 34035 Somerset New Jersey US 2020-04-08 22:51:58 40.56465737 -74.61683016 1160 46 0 0 Somerset, New Jersey, US
2803 2803       Luxembourg 2020-04-08 22:51:39 49.8153 6.1296 3034 46 500 2488 Luxembourg
731 731 36029 Erie New York US 2020-04-08 22:51:58 42.76249024 -78.73063652 1335 45 0 0 Erie, New York, US
2622 2622     British Columbia Canada 2020-04-08 22:58:44 53.7267 -127.6476 1291 43 0 0 British Columbia, Canada
2363 2363 90051 Unassigned Virginia US 2020-04-08 22:51:58     0 42 0 0 Unassigned, Virginia, US
824 824 13121 Fulton Georgia US 2020-04-08 22:51:58 33.79216944 -84.46319413 1240 41 0 0 Fulton, Georgia, US
1707 1707 25021 Norfolk Massachusetts US 2020-04-08 22:51:58 42.16073095 -71.20530408 1778 41 0 0 Norfolk, Massachusetts, US
2848 2848       Saudi Arabia 2020-04-08 22:51:39 23.885942 45.079162 2932 41 631 2260 Saudi Arabia
2762 2762       Finland 2020-04-08 22:51:39 61.92411 25.748151 2487 40 300 2147 Finland

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

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