04-16-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,043 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
2944 2944       Italy 2020-04-16 23:30:31 41.87194 12.56738 168941 22170 40164 106607 Italy
3017 3017       Spain 2020-04-16 23:30:31 40.463667 -3.7492199999999998 184948 19315 74797 90836 Spain
2921 2921       France 2020-04-16 23:30:31 46.2276 2.2137 145051 17901 32812 95228 France
3035 3035       United Kingdom 2020-04-16 23:30:31 55.3781 -3.4360000000000004 103093 13729 0 89364 United Kingdom
1785 1785 36061 New York City New York US 2020-04-16 23:30:51 40.76727260000001 -73.97152637 123146 11477 0 111669 New York City, New York, US
2940 2940       Iran 2020-04-16 23:30:31 32.427908 53.68804599999999 77995 4869 52229 20897 Iran
2878 2878       Belgium 2020-04-16 23:30:31 50.8333 4.469936 34809 4857 7562 22390 Belgium
2925 2925       Germany 2020-04-16 23:30:31 51.165690999999995 10.451526 137698 4052 77000 56646 Germany
2980 2980       Netherlands 2020-04-16 23:30:31 52.1326 5.2913 29214 3315 250 25649 Netherlands
2808 2808     Hubei China 2020-04-16 01:54:44 30.9756 112.2707 67803 3222 64435 146 Hubei, China
2885 2885       Brazil 2020-04-16 23:30:31 -14.235 -51.9253 30425 1924 14026 14475 Brazil
3031 3031       Turkey 2020-04-16 23:30:31 38.9637 35.2433 74193 1643 7089 65461 Turkey
3021 3021       Sweden 2020-04-16 23:30:31 60.128161 18.643501 12540 1333 550 10657 Sweden
3022 3022       Switzerland 2020-04-16 23:30:31 46.8182 8.2275 26732 1281 15900 9551 Switzerland
1767 1767 36059 Nassau New York US 2020-04-16 23:30:51 40.74066522 -73.58941873 27772 1109 0 26663 Nassau, New York, US
2835 2835     Quebec Canada 2020-04-16 23:38:03 52.9399 -73.5491 15857 1089 0 15227 Quebec, Canada
2645 2645 26163 Wayne Michigan US 2020-04-16 23:30:51 42.28098405 -83.281255 12544 884 0 11660 Wayne, Michigan, US
551 551 17031 Cook Illinois US 2020-04-16 23:30:51 41.84144849 -87.81658794 18087 722 0 17365 Cook, Illinois, US
2354 2354 36103 Suffolk New York US 2020-04-16 23:30:51 40.88320119 -72.8012172 24812 693 0 24119 Suffolk, New York, US
166 166 34003 Bergen New Jersey US 2020-04-16 23:30:51 40.96010917 -74.07164325 11409 668 0 10741 Bergen, New Jersey, US
2670 2670 36119 Westchester New York US 2020-04-16 23:30:51 41.16278376 -73.75741653 21828 668 0 21160 Westchester, New York, US
769 769 34013 Essex New Jersey US 2020-04-16 23:30:51 40.78681335 -74.24657979 9084 642 0 8442 Essex, New Jersey, US
2995 2995       Portugal 2020-04-16 23:30:31 39.3999 -8.2245 18841 629 493 17719 Portugal
2939 2939       Indonesia 2020-04-16 23:30:31 -0.7893 113.9213 5516 496 548 4472 Indonesia
2831 2831     Ontario Canada 2020-04-16 23:38:03 51.2538 -85.3232 9840 490 0 9350 Ontario, Canada
2942 2942       Ireland 2020-04-16 23:30:31 53.1424 -7.6921 13271 486 77 12708 Ireland
1472 1472 6037 Los Angeles California US 2020-04-16 23:30:51 34.30828379 -118.22824109999999 10854 457 0 10397 Los Angeles, California, US
2971 2971       Mexico 2020-04-16 23:30:31 23.6345 -102.5528 5847 449 2125 3273 Mexico
2938 2938       India 2020-04-16 23:30:31 20.593684 78.96288 13430 448 1768 11214 India
1823 1823 26125 Oakland Michigan US 2020-04-16 23:30:51 42.66090111 -83.38595416 5778 420 0 5358 Oakland, Michigan, US
2871 2871       Austria 2020-04-16 23:30:31 47.5162 14.5501 14476 410 8986 5080 Austria
779 779 9001 Fairfield Connecticut US 2020-04-16 23:30:51 41.26809896 -73.3881171 6816 406 0 6410 Fairfield, Connecticut, US
2911 2911       Ecuador 2020-04-16 23:30:31 -1.8312 -78.1834 8225 403 838 6984 Ecuador
2997 2997       Romania 2020-04-16 23:30:31 45.9432 24.9668 7707 392 1357 5958 Romania
1122 1122 34017 Hudson New Jersey US 2020-04-16 23:30:51 40.73766234 -74.07515667 9165 365 0 8800 Hudson, New Jersey, US
2993 2993       Philippines 2020-04-16 23:30:31 12.879721 121.77401699999999 5660 362 435 4863 Philippines
1498 1498 26099 Macomb Michigan US 2020-04-16 23:30:51 42.69158356 -82.92752801 3992 354 0 3638 Macomb, Michigan, US
1289 1289 53033 King Washington US 2020-04-16 23:30:51 47.49137892 -121.8346131 4697 348 0 4385 King, Washington, US
2865 2865       Algeria 2020-04-16 23:30:31 28.0339 1.6596 2268 348 783 1137 Algeria
2906 2906       Denmark 2020-04-16 23:30:31 56.2639 9.5018 6879 321 3023 3535 Denmark
2130 2130 36087 Rockland New York US 2020-04-16 23:30:51 41.15027894 -74.02560498 8752 319 0 8433 Rockland, New York, US
2994 2994       Poland 2020-04-16 23:30:31 51.9194 19.1451 7918 314 774 6830 Poland
1864 1864 22071 Orleans Louisiana US 2020-04-16 23:30:51 30.06971951 -89.92660315 5847 302 0 5545 Orleans, Louisiana, US
2525 2525 34039 Union New Jersey US 2020-04-16 23:30:51 40.65835409 -74.30680092 7904 301 0 7603 Union, New Jersey, US
1655 1655 34023 Middlesex New Jersey US 2020-04-16 23:30:51 40.43629879 -74.41426991 6994 278 0 6716 Middlesex, New Jersey, US
2992 2992       Peru 2020-04-16 23:30:31 -9.19 -75.0152 12491 274 6120 6097 Peru
1952 1952 42101 Philadelphia Pennsylvania US 2020-04-16 23:30:51 40.00338507 -75.1379271 8045 264 0 7781 Philadelphia, Pennsylvania, US
1209 1209 22051 Jefferson Louisiana US 2020-04-16 23:30:51 29.74075478 -90.11115756 5346 261 0 5085 Jefferson, Louisiana, US
1050 1050 9003 Hartford Connecticut US 2020-04-16 23:30:51 41.80283011 -72.73103891 2859 243 0 2616 Hartford, Connecticut, US
2998 2998       Russia 2020-04-16 23:30:31 61.52401 105.31875600000001 27938 232 2304 25402 Russia
2950 2950       Korea, South 2020-04-16 23:30:31 35.90775700000001 127.766922 10613 229 7757 2627 Korea, South
1654 1654 25017 Middlesex Massachusetts US 2020-04-16 23:30:51 42.48607732 -71.39049229 7206 221 0 6985 Middlesex, Massachusetts, US
1743 1743 34027 Morris New Jersey US 2020-04-16 23:30:51 40.86095313 -74.54553709999998 3701 216 0 3485 Morris, New Jersey, US
1781 1781 9009 New Haven Connecticut US 2020-04-16 23:30:51 41.408032500000004 -72.93620426 4163 214 0 3949 New Haven, Connecticut, US
1916 1916 34031 Passaic New Jersey US 2020-04-16 23:30:51 41.03238628 -74.29954144 7317 211 0 7106 Passaic, New Jersey, US
1857 1857 36071 Orange New York US 2020-04-16 23:30:51 41.40337468 -74.30240757 6266 204 0 6062 Orange, New York, US
2910 2910       Dominican Republic 2020-04-16 23:30:31 18.7357 -70.1627 3755 196 215 3344 Dominican Republic
2912 2912       Egypt 2020-04-16 23:30:31 26.820553000000004 30.802497999999996 2673 196 596 1881 Egypt
1683 1683 34025 Monmouth New Jersey US 2020-04-16 23:30:51 40.26549699 -74.22240686 4299 190 0 4109 Monmouth, New Jersey, US
1825 1825 34029 Ocean New Jersey US 2020-04-16 23:30:51 39.8895449 -74.28089251 4272 185 0 4087 Ocean, New Jersey, US
1651 1651 12086 Miami-Dade Florida US 2020-04-16 23:30:51 25.6112362 -80.55170587 8326 183 0 8143 Miami-Dade, Florida, US
2946 2946       Japan 2020-04-16 23:30:31 36.204824 138.252924 8626 178 901 7547 Japan
2905 2905       Czechia 2020-04-16 23:30:31 49.8175 15.472999999999999 6433 169 972 5292 Czechia
1547 1547 18097 Marion Indiana US 2020-04-16 23:30:51 39.78163624 -86.13826325 3320 164 0 3156 Marion, Indiana, US
2986 2986       Norway 2020-04-16 23:30:31 60.472 8.4689 6896 152 32 6712 Norway
1009 1009 25013 Hampden Massachusetts US 2020-04-16 23:30:51 42.13440424 -72.63235561 1985 151 0 1834 Hampden, Massachusetts, US
1808 1808 25021 Norfolk Massachusetts US 2020-04-16 23:30:51 42.16073095 -71.20530408 3342 147 0 3195 Norfolk, Massachusetts, US
2943 2943       Israel 2020-04-16 23:30:31 31.046051000000002 34.851612 12948 146 3174 9798 Israel
2353 2353 25025 Suffolk Massachusetts US 2020-04-16 23:30:51 42.327951399999996 -71.07850442 6820 145 0 6675 Suffolk, Massachusetts, US
2897 2897       Colombia 2020-04-16 23:30:31 4.5709 -74.2973 3233 144 550 2539 Colombia
2936 2936       Hungary 2020-04-16 23:30:31 47.1625 19.5033 1652 142 199 1311 Hungary
768 768 25009 Essex Massachusetts US 2020-04-16 23:30:51 42.6687626 -70.94687179 4245 140 0 4105 Essex, Massachusetts, US
2976 2976       Morocco 2020-04-16 23:30:31 31.7917 -7.0926 2283 130 249 1904 Morocco
2988 2988       Pakistan 2020-04-16 23:30:31 30.3753 69.3451 6919 128 1645 5146 Pakistan
2483 2483 90018 Unassigned Indiana US 2020-04-16 23:30:51     0 125 0 -1 Unassigned, Indiana, US
2280 2280 34035 Somerset New Jersey US 2020-04-16 23:30:51 40.56465737 -74.61683016 2103 121 0 1982 Somerset, New Jersey, US
3033 3033       Ukraine 2020-04-16 23:30:31 48.3794 31.1656 4161 116 186 3859 Ukraine
460 460 32003 Clark Nevada US 2020-04-16 23:30:51 36.21458855 -115.0130241 2559 115 0 2444 Clark, Nevada, US
2869 2869       Argentina 2020-04-16 23:30:31 -38.4161 -63.6167 2571 115 631 1825 Argentina
1664 1664 55079 Milwaukee Wisconsin US 2020-04-16 23:30:51 43.00486062 -87.96733172 1947 114 0 1833 Milwaukee, Wisconsin, US
1904 1904 12099 Palm Beach Florida US 2020-04-16 23:30:51 26.64676272 -80.46536002 1867 112 0 1755 Palm Beach, Florida, US
763 763 36029 Erie New York US 2020-04-16 23:30:51 42.76249024 -78.73063652 1951 107 0 1844 Erie, New York, US
2896 2896       Chile 2020-04-16 23:30:31 -35.6751 -71.543 8807 105 3299 5403 Chile
2927 2927       Greece 2020-04-16 23:30:31 39.0742 21.8243 2207 105 269 1833 Greece
2989 2989       Panama 2020-04-16 23:30:31 8.538 -80.7821 3751 103 75 3573 Panama
3008 3008       Serbia 2020-04-16 23:30:31 44.0165 21.0059 5318 103 0 5215 Serbia
245 245 12011 Broward Florida US 2020-04-16 23:30:51 26.15184651 -80.48725556 3466 101 0 3365 Broward, Florida, US
891 891 26049 Genesee Michigan US 2020-04-16 23:30:51 43.02244215 -83.70589709 1147 99 0 1048 Genesee, Michigan, US
2274 2274 53061 Snohomish Washington US 2020-04-16 23:30:51 48.04615983 -121.7170703 2032 90 0 1946 Snohomish, Washington, US
1719 1719 42091 Montgomery Pennsylvania US 2020-04-16 23:30:51 40.21053671 -75.36652296 2544 89 0 2455 Montgomery, Pennsylvania, US
1993 1993 25023 Plymouth Massachusetts US 2020-04-16 23:30:51 41.94070556 -70.80802823 2466 89 0 2377 Plymouth, Massachusetts, US
2698 2698 17197 Will Illinois US 2020-04-16 23:30:51 41.44619267 -87.97862712 1494 88 0 1406 Will, Illinois, US
1639 1639 34021 Mercer New Jersey US 2020-04-16 23:30:51 40.28047017 -74.70479631 2037 87 0 1950 Mercer, New Jersey, US
2965 2965       Malaysia 2020-04-16 23:30:31 4.210483999999999 101.97576600000001 5182 84 2766 2332 Malaysia
702 702 13095 Dougherty Georgia US 2020-04-16 23:30:51 31.53328528 -84.21722377 1338 83 0 1255 Dougherty, Georgia, US
3006 3006       Saudi Arabia 2020-04-16 23:30:31 23.885942 45.079162 6380 83 990 5307 Saudi Arabia
688 688 11001 District of Columbia District of Columbia US 2020-04-16 23:30:51 38.90417773 -77.01655992 2350 81 0 2269 District of Columbia, District of Columbia, US
2941 2941       Iraq 2020-04-16 23:30:31 33.223191 43.679291 1434 80 856 498 Iraq
2510 2510 90051 Unassigned Virginia US 2020-04-16 23:30:51     0 77 0 -77 Unassigned, Virginia, US
2505 2505 90044 Unassigned Rhode Island US 2020-04-16 23:30:51     902 76 0 818 Unassigned, Rhode Island, US

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

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