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 Confirmed 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
3017 3017       Spain 2020-04-16 23:30:31 40.463667 -3.7492199999999998 184948 19315 74797 90836 Spain
2944 2944       Italy 2020-04-16 23:30:31 41.87194 12.56738 168941 22170 40164 106607 Italy
2921 2921       France 2020-04-16 23:30:31 46.2276 2.2137 145051 17901 32812 95228 France
2925 2925       Germany 2020-04-16 23:30:31 51.165690999999995 10.451526 137698 4052 77000 56646 Germany
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
3035 3035       United Kingdom 2020-04-16 23:30:31 55.3781 -3.4360000000000004 103093 13729 0 89364 United Kingdom
2940 2940       Iran 2020-04-16 23:30:31 32.427908 53.68804599999999 77995 4869 52229 20897 Iran
3031 3031       Turkey 2020-04-16 23:30:31 38.9637 35.2433 74193 1643 7089 65461 Turkey
2808 2808     Hubei China 2020-04-16 01:54:44 30.9756 112.2707 67803 3222 64435 146 Hubei, China
2878 2878       Belgium 2020-04-16 23:30:31 50.8333 4.469936 34809 4857 7562 22390 Belgium
2885 2885       Brazil 2020-04-16 23:30:31 -14.235 -51.9253 30425 1924 14026 14475 Brazil
2980 2980       Netherlands 2020-04-16 23:30:31 52.1326 5.2913 29214 3315 250 25649 Netherlands
2998 2998       Russia 2020-04-16 23:30:31 61.52401 105.31875600000001 27938 232 2304 25402 Russia
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
3022 3022       Switzerland 2020-04-16 23:30:31 46.8182 8.2275 26732 1281 15900 9551 Switzerland
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
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
2995 2995       Portugal 2020-04-16 23:30:31 39.3999 -8.2245 18841 629 493 17719 Portugal
551 551 17031 Cook Illinois US 2020-04-16 23:30:51 41.84144849 -87.81658794 18087 722 0 17365 Cook, Illinois, US
2835 2835     Quebec Canada 2020-04-16 23:38:03 52.9399 -73.5491 15857 1089 0 15227 Quebec, Canada
2871 2871       Austria 2020-04-16 23:30:31 47.5162 14.5501 14476 410 8986 5080 Austria
2938 2938       India 2020-04-16 23:30:31 20.593684 78.96288 13430 448 1768 11214 India
2942 2942       Ireland 2020-04-16 23:30:31 53.1424 -7.6921 13271 486 77 12708 Ireland
2943 2943       Israel 2020-04-16 23:30:31 31.046051000000002 34.851612 12948 146 3174 9798 Israel
2645 2645 26163 Wayne Michigan US 2020-04-16 23:30:51 42.28098405 -83.281255 12544 884 0 11660 Wayne, Michigan, US
3021 3021       Sweden 2020-04-16 23:30:31 60.128161 18.643501 12540 1333 550 10657 Sweden
2992 2992       Peru 2020-04-16 23:30:31 -9.19 -75.0152 12491 274 6120 6097 Peru
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
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
2950 2950       Korea, South 2020-04-16 23:30:31 35.90775700000001 127.766922 10613 229 7757 2627 Korea, South
2831 2831     Ontario Canada 2020-04-16 23:38:03 51.2538 -85.3232 9840 490 0 9350 Ontario, Canada
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
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
2896 2896       Chile 2020-04-16 23:30:31 -35.6751 -71.543 8807 105 3299 5403 Chile
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
2946 2946       Japan 2020-04-16 23:30:31 36.204824 138.252924 8626 178 901 7547 Japan
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
2911 2911       Ecuador 2020-04-16 23:30:31 -1.8312 -78.1834 8225 403 838 6984 Ecuador
1952 1952 42101 Philadelphia Pennsylvania US 2020-04-16 23:30:51 40.00338507 -75.1379271 8045 264 0 7781 Philadelphia, Pennsylvania, US
2994 2994       Poland 2020-04-16 23:30:31 51.9194 19.1451 7918 314 774 6830 Poland
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
2997 2997       Romania 2020-04-16 23:30:31 45.9432 24.9668 7707 392 1357 5958 Romania
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
1654 1654 25017 Middlesex Massachusetts US 2020-04-16 23:30:51 42.48607732 -71.39049229 7206 221 0 6985 Middlesex, Massachusetts, 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
2988 2988       Pakistan 2020-04-16 23:30:31 30.3753 69.3451 6919 128 1645 5146 Pakistan
2986 2986       Norway 2020-04-16 23:30:31 60.472 8.4689 6896 152 32 6712 Norway
2906 2906       Denmark 2020-04-16 23:30:31 56.2639 9.5018 6879 321 3023 3535 Denmark
2353 2353 25025 Suffolk Massachusetts US 2020-04-16 23:30:51 42.327951399999996 -71.07850442 6820 145 0 6675 Suffolk, Massachusetts, US
779 779 9001 Fairfield Connecticut US 2020-04-16 23:30:51 41.26809896 -73.3881171 6816 406 0 6410 Fairfield, Connecticut, US
2905 2905       Czechia 2020-04-16 23:30:31 49.8175 15.472999999999999 6433 169 972 5292 Czechia
3006 3006       Saudi Arabia 2020-04-16 23:30:31 23.885942 45.079162 6380 83 990 5307 Saudi Arabia
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
1864 1864 22071 Orleans Louisiana US 2020-04-16 23:30:51 30.06971951 -89.92660315 5847 302 0 5545 Orleans, Louisiana, US
2971 2971       Mexico 2020-04-16 23:30:31 23.6345 -102.5528 5847 449 2125 3273 Mexico
3034 3034       United Arab Emirates 2020-04-16 23:30:31 23.424076 53.847818000000004 5825 35 1095 4695 United Arab Emirates
1823 1823 26125 Oakland Michigan US 2020-04-16 23:30:51 42.66090111 -83.38595416 5778 420 0 5358 Oakland, Michigan, US
2993 2993       Philippines 2020-04-16 23:30:31 12.879721 121.77401699999999 5660 362 435 4863 Philippines
2939 2939       Indonesia 2020-04-16 23:30:31 -0.7893 113.9213 5516 496 548 4472 Indonesia
1209 1209 22051 Jefferson Louisiana US 2020-04-16 23:30:51 29.74075478 -90.11115756 5346 261 0 5085 Jefferson, Louisiana, US
3008 3008       Serbia 2020-04-16 23:30:31 44.0165 21.0059 5318 103 0 5215 Serbia
2965 2965       Malaysia 2020-04-16 23:30:31 4.210483999999999 101.97576600000001 5182 84 2766 2332 Malaysia
1289 1289 53033 King Washington US 2020-04-16 23:30:51 47.49137892 -121.8346131 4697 348 0 4385 King, Washington, US
3011 3011       Singapore 2020-04-16 23:30:31 1.2833 103.8333 4427 10 683 3734 Singapore
1038 1038 48201 Harris Texas US 2020-04-16 23:30:51 29.86 -95.39 4306 63 0 4243 Harris, Texas, US
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
768 768 25009 Essex Massachusetts US 2020-04-16 23:30:51 42.6687626 -70.94687179 4245 140 0 4105 Essex, Massachusetts, US
2877 2877       Belarus 2020-04-16 23:30:31 53.7098 27.9534 4204 40 203 3961 Belarus
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
3033 3033       Ukraine 2020-04-16 23:30:31 48.3794 31.1656 4161 116 186 3859 Ukraine
2996 2996       Qatar 2020-04-16 23:30:31 25.3548 51.1839 4103 7 415 3681 Qatar
1498 1498 26099 Macomb Michigan US 2020-04-16 23:30:51 42.69158356 -82.92752801 3992 354 0 3638 Macomb, Michigan, US
2910 2910       Dominican Republic 2020-04-16 23:30:31 18.7357 -70.1627 3755 196 215 3344 Dominican Republic
2989 2989       Panama 2020-04-16 23:30:31 8.538 -80.7821 3751 103 75 3573 Panama
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
245 245 12011 Broward Florida US 2020-04-16 23:30:51 26.15184651 -80.48725556 3466 101 0 3365 Broward, Florida, US
2961 2961       Luxembourg 2020-04-16 23:30:31 49.8153 6.1296 3444 69 552 2823 Luxembourg
2920 2920       Finland 2020-04-16 23:30:31 61.92411 25.748151 3369 75 1700 1594 Finland
1808 1808 25021 Norfolk Massachusetts US 2020-04-16 23:30:51 42.16073095 -71.20530408 3342 147 0 3195 Norfolk, Massachusetts, US
1547 1547 18097 Marion Indiana US 2020-04-16 23:30:51 39.78163624 -86.13826325 3320 164 0 3156 Marion, Indiana, US
2897 2897       Colombia 2020-04-16 23:30:31 4.5709 -74.2973 3233 144 550 2539 Colombia
2823 2823     New South Wales Australia 2020-04-16 23:38:19 -33.8688 151.2093 2897 25 4 2868 New South Wales, Australia
1050 1050 9003 Hartford Connecticut US 2020-04-16 23:30:51 41.80283011 -72.73103891 2859 243 0 2616 Hartford, Connecticut, US
2036 2036 24033 Prince George's Maryland US 2020-04-16 23:30:51 38.83070039 -76.8496441 2722 72 0 2650 Prince George's, Maryland, US
2912 2912       Egypt 2020-04-16 23:30:31 26.820553000000004 30.802497999999996 2673 196 596 1881 Egypt
3026 3026       Thailand 2020-04-16 23:30:31 15.870032 100.992541 2672 46 1593 1033 Thailand
3015 3015       South Africa 2020-04-16 23:30:31 -30.5595 22.9375 2605 48 903 1654 South Africa
2869 2869       Argentina 2020-04-16 23:30:31 -38.4161 -63.6167 2571 115 631 1825 Argentina
460 460 32003 Clark Nevada US 2020-04-16 23:30:51 36.21458855 -115.0130241 2559 115 0 2444 Clark, Nevada, US
1719 1719 42091 Montgomery Pennsylvania US 2020-04-16 23:30:51 40.21053671 -75.36652296 2544 89 0 2455 Montgomery, Pennsylvania, US
2737 2737 25027 Worcester Massachusetts US 2020-04-16 23:30:51 42.35026951 -71.90493363 2503 74 0 2429 Worcester, Massachusetts, US
1993 1993 25023 Plymouth Massachusetts US 2020-04-16 23:30:51 41.94070556 -70.80802823 2466 89 0 2377 Plymouth, Massachusetts, US
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
2976 2976       Morocco 2020-04-16 23:30:31 31.7917 -7.0926 2283 130 249 1904 Morocco
2865 2865       Algeria 2020-04-16 23:30:31 28.0339 1.6596 2268 348 783 1137 Algeria
1538 1538 4013 Maricopa Arizona US 2020-04-16 23:30:51 33.34835867 -112.49181540000001 2264 64 0 2200 Maricopa, Arizona, US
2927 2927       Greece 2020-04-16 23:30:31 39.0742 21.8243 2207 105 269 1833 Greece
2972 2972       Moldova 2020-04-16 23:30:31 47.4116 28.3699 2154 54 235 1865 Moldova
1713 1713 24031 Montgomery Maryland US 2020-04-16 23:30:51 39.13676329 -77.20358245 2133 56 0 2077 Montgomery, Maryland, 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
);