05-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

3,232 rows sorted by Active 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
3224 3224       United Kingdom 2020-05-09 02:32:35 55.3781 -3.4360000000000004 211364 31241 0 180123 United Kingdom
1905 1905 36061 New York City New York US 2020-05-09 02:32:35 40.76727260000001 -73.97152637 181783 19561 0 162222 New York City, New York, US
3186 3186       Russia 2020-05-09 02:32:35 61.52401 105.318756 187859 1723 26608 159528 Russia
3109 3109       France 2020-05-09 02:32:35 46.2276 2.2137 175743 26192 54770 93356 France
3132 3132       Italy 2020-05-09 02:32:35 41.87194 12.56738 217185 30201 99023 87961 Italy
3072 3072       Brazil 2020-05-09 02:32:35 -14.235 -51.9253 146894 10017 59297 77580 Brazil
3205 3205       Spain 2020-05-09 02:32:35 40.463667 -3.74922 222857 26299 131148 65410 Spain
588 588 17031 Cook Illinois US 2020-05-09 02:32:35 41.84144849 -87.81658794 50236 2197 0 48039 Cook, Illinois, US
3220 3220       Turkey 2020-05-09 02:32:35 38.9637 35.2433 135569 3689 86396 45484 Turkey
3180 3180       Peru 2020-05-09 02:32:35 -9.19 -75.0152 61847 1714 19012 41121 Peru
3126 3126       India 2020-05-09 02:32:35 20.593684 78.96288 59695 1985 17887 39823 India
3168 3168       Netherlands 2020-05-09 02:32:35 52.1326 5.2913 42093 5359 0 36734 Netherlands
1885 1885 36059 Nassau New York US 2020-05-09 02:32:35 40.74066522 -73.58941873 37812 1918 0 35894 Nassau, New York, US
2511 2511 36103 Suffolk New York US 2020-05-09 02:32:35 40.88320119 -72.8012172 36223 1568 0 34655 Suffolk, New York, US
3022 3022     Quebec Canada 2020-05-09 02:32:35 52.9399 -73.5491 36161 3569 0 33435 Quebec, Canada
3065 3065       Belgium 2020-05-09 02:32:35 50.8333 4.469936 52011 8521 13201 30289 Belgium
2847 2847 36119 Westchester New York US 2020-05-09 02:32:35 41.16278376 -73.75741653 30905 1191 0 29714 Westchester, New York, US
1573 1573 6037 Los Angeles California US 2020-05-09 02:32:35 34.30828379 -118.2282411 30319 1470 0 28849 Los Angeles, California, US
3194 3194       Saudi Arabia 2020-05-09 02:32:35 23.885942 45.079162 35432 229 9120 26083 Saudi Arabia
3183 3183       Portugal 2020-05-09 02:32:35 39.3999 -8.2245 27268 1114 2422 23732 Portugal
3099 3099       Ecuador 2020-05-09 02:32:35 -1.8312 -78.1834 28818 1704 3433 23681 Ecuador
3113 3113       Germany 2020-05-09 02:32:35 51.165691 10.451526 170588 7510 141700 21378 Germany
3199 3199       Singapore 2020-05-09 02:32:35 1.2833 103.8333 21707 20 2040 19647 Singapore
3018 3018     Ontario Canada 2020-05-09 02:32:35 51.2538 -85.3232 20826 1665 0 19161 Ontario, Canada
3176 3176       Pakistan 2020-05-09 02:32:35 30.3753 69.3451 26435 599 7530 18306 Pakistan
3184 3184       Qatar 2020-05-09 02:32:35 25.3548 51.1839 20201 12 2370 17819 Qatar
3209 3209       Sweden 2020-05-09 02:32:35 60.128161 18.643501 25265 3175 4971 17119 Sweden
2083 2083 42101 Philadelphia Pennsylvania US 2020-05-09 02:32:35 40.00338507 -75.1379271 17517 875 0 16642 Philadelphia, Pennsylvania, US
1209 1209 34017 Hudson New Jersey US 2020-05-09 02:32:35 40.73766234 -74.07515667 17368 945 0 16420 Hudson, New Jersey, US
1763 1763 25017 Middlesex Massachusetts US 2020-05-09 02:32:35 42.48607732 -71.39049229 17014 1132 0 15882 Middlesex, Massachusetts, US
2821 2821 26163 Wayne Michigan US 2020-05-09 02:32:35 42.28098405 -83.281255 17824 2028 0 15796 Wayne, Michigan, US
3064 3064       Belarus 2020-05-09 02:32:35 53.7098 27.9534 21101 121 5484 15496 Belarus
175 175 34003 Bergen New Jersey US 2020-05-09 02:32:35 40.96010917 -74.07164325 16721 1329 0 15380 Bergen, New Jersey, US
3128 3128       Iran 2020-05-09 02:32:35 32.427908 53.68804599999999 104691 6541 83837 14313 Iran
2510 2510 25025 Suffolk Massachusetts US 2020-05-09 02:32:35 42.3279514 -71.07850442 14944 683 0 14261 Suffolk, Massachusetts, US
818 818 34013 Essex New Jersey US 2020-05-09 02:32:35 40.78681335 -74.24657979 15353 1402 0 13948 Essex, New Jersey, US
2044 2044 34031 Passaic New Jersey US 2020-05-09 02:32:35 41.03238628 -74.29954144 14280 715 0 13565 Passaic, New Jersey, US
3083 3083       Chile 2020-05-09 02:32:35 -35.6751 -71.543 25972 294 12160 13518 Chile
1760 1760 12086 Miami-Dade Florida US 2020-05-09 02:32:35 25.6112362 -80.55170587 13664 468 0 13196 Miami-Dade, Florida, US
2693 2693 34039 Union New Jersey US 2020-05-09 02:32:35 40.65835409 -74.30680092 13920 844 0 13073 Union, New Jersey, US
1764 1764 34023 Middlesex New Jersey US 2020-05-09 02:32:35 40.43629879 -74.41426991 13622 748 0 12869 Middlesex, New Jersey, US
3223 3223       United Arab Emirates 2020-05-09 02:32:35 23.424076 53.847818 16793 174 3837 12782 United Arab Emirates
829 829 9001 Fairfield Connecticut US 2020-05-09 02:32:35 41.26809896 -73.3881171 12879 1006 0 11873 Fairfield, Connecticut, US
2273 2273 36087 Rockland New York US 2020-05-09 02:32:35 41.15027894 -74.02560498 12349 562 0 11787 Rockland, New York, US
3222 3222       Ukraine 2020-05-09 02:32:35 48.3794 31.1656 14195 361 2706 11128 Ukraine
3062 3062       Bangladesh 2020-05-09 02:32:35 23.685 90.3563 13134 206 2101 10827 Bangladesh
817 817 25009 Essex Massachusetts US 2020-05-09 02:32:35 42.6687626 -70.94687179 10995 601 0 10394 Essex, Massachusetts, US
3134 3134       Japan 2020-05-09 02:32:35 36.204824 138.252924 15575 590 5146 9839 Japan
3127 3127       Indonesia 2020-05-09 02:32:35 -0.7893 113.9213 13112 943 2494 9675 Indonesia
3182 3182       Poland 2020-05-09 02:32:35 51.9194 19.1451 15366 776 5184 9406 Poland
1980 1980 36071 Orange New York US 2020-05-09 02:32:35 41.40337468 -74.30240757 9402 367 0 9035 Orange, New York, US
2172 2172 24033 Prince George's Maryland US 2020-05-09 02:32:35 38.83070039 -76.8496441 8901 339 0 8562 Prince George's, Maryland, US
1901 1901 9009 New Haven Connecticut US 2020-05-09 02:32:35 41.4080325 -72.93620426 8887 669 0 8218 New Haven, Connecticut, US
3159 3159       Mexico 2020-05-09 02:32:35 23.6345 -102.5528 31522 3160 20314 8048 Mexico
3181 3181       Philippines 2020-05-09 02:32:35 12.879721 121.774017 10463 696 1734 8033 Philippines
3174 3174       Norway 2020-05-09 02:32:35 60.472 8.4689 8070 218 32 7820 Norway
3185 3185       Romania 2020-05-09 02:32:35 45.9432 24.9668 14811 923 6423 7465 Romania
1115 1115 48201 Harris Texas US 2020-05-09 02:32:35 29.86 -95.39 7594 160 0 7434 Harris, Texas, US
3196 3196       Serbia 2020-05-09 02:32:35 44.0165 21.0059 9943 209 2453 7281 Serbia
3084 3084       Colombia 2020-05-09 02:32:35 4.5709 -74.2973 10051 428 2424 7199 Colombia
2175 2175 44007 Providence Rhode Island US 2020-05-09 02:32:35 41.87064746 -71.57753536 7138 0 0 7138 Providence, Rhode Island, US
2919 2919 25027 Worcester Massachusetts US 2020-05-09 02:32:35 42.35026951 -71.90493363 7410 404 0 7006 Worcester, Massachusetts, US
3177 3177       Panama 2020-05-09 02:32:35 8.538 -80.7821 8070 231 886 6953 Panama
1945 1945 26125 Oakland Michigan US 2020-05-09 02:32:35 42.66090111 -83.38595416 7664 805 0 6859 Oakland, Michigan, US
1947 1947 34029 Ocean New Jersey US 2020-05-09 02:32:35 39.8895449 -74.28089251 7277 516 0 6761 Ocean, New Jersey, US
3098 3098       Dominican Republic 2020-05-09 02:32:35 18.7357 -70.1627 9376 380 2286 6710 Dominican Republic
1649 1649 18097 Marion Indiana US 2020-05-09 02:32:35 39.78163624 -86.13826325 7078 403 0 6675 Marion, Indiana, US
1381 1381 53033 King Washington US 2020-05-09 02:32:35 47.49137892 -121.8346131 6863 500 0 6376 King, Washington, US
1796 1796 34025 Monmouth New Jersey US 2020-05-09 02:32:35 40.26549699 -74.22240686 6753 429 0 6323 Monmouth, New Jersey, US
1297 1297 22051 Jefferson Louisiana US 2020-05-09 02:32:35 29.74075478 -90.11115756 6610 392 0 6218 Jefferson, Louisiana, US
1987 1987 22071 Orleans Louisiana US 2020-05-09 02:32:35 30.06971951 -89.92660315 6645 463 0 6182 Orleans, Louisiana, US
1929 1929 25021 Norfolk Massachusetts US 2020-05-09 02:32:35 42.16073095 -71.20530408 6801 623 0 6178 Norfolk, Massachusetts, US
3100 3100       Egypt 2020-05-09 02:32:35 26.820553000000004 30.802498 8476 503 1945 6028 Egypt
1127 1127 9003 Hartford Connecticut US 2020-05-09 02:32:35 41.80283011 -72.73103891 6904 884 0 6020 Hartford, Connecticut, US
2959 2959     Alberta Canada 2020-05-09 02:32:35 53.9333 -116.5765 6098 115 0 5983 Alberta, Canada
1828 1828 24031 Montgomery Maryland US 2020-05-09 02:32:35 39.13676329 -77.20358245 6316 355 0 5961 Montgomery, Maryland, US
2125 2125 25023 Plymouth Massachusetts US 2020-05-09 02:32:35 41.94070556 -70.80802823 6194 375 0 5819 Plymouth, Massachusetts, US
733 733 11001 District of Columbia District of Columbia US 2020-05-09 02:32:35 38.90417773 -77.01655992 5899 304 0 5595 District of Columbia, District of Columbia, US
3203 3203       South Africa 2020-05-09 02:32:35 -30.5595 22.9375 8895 178 3153 5564 South Africa
258 258 12011 Broward Florida US 2020-05-09 02:32:35 26.15184651 -80.48725556 5688 248 0 5440 Broward, Florida, US
1640 1640 4013 Maricopa Arizona US 2020-05-09 02:32:35 33.34835867 -112.4918154 5525 238 0 5287 Maricopa, Arizona, US
1599 1599 26099 Macomb Michigan US 2020-05-09 02:32:35 42.69158356 -82.92752801 5963 682 0 5281 Macomb, Michigan, US
1858 1858 34027 Morris New Jersey US 2020-05-09 02:32:35 40.86095313 -74.54553709999998 5767 506 0 5261 Morris, New Jersey, US
665 665 48113 Dallas Texas US 2020-05-09 02:32:35 32.76670599 -96.7779605 5369 156 0 5234 Dallas, Texas, US
827 827 51059 Fairfax Virginia US 2020-05-09 02:32:35 38.83677558 -77.27565836 5338 227 0 5111 Fairfax, Virginia, US
3131 3131       Israel 2020-05-09 02:32:35 31.046051 34.851612 16340 248 11318 4962 Israel
1432 1432 17097 Lake Illinois US 2020-05-09 02:32:35 42.3224907 -88.00367925 4985 170 0 4815 Lake, Illinois, US
1747 1747 34021 Mercer New Jersey US 2020-05-09 02:32:35 40.28047017 -74.70479631 5112 322 0 4789 Mercer, New Jersey, US
3140 3140       Kuwait 2020-05-09 02:32:35 29.31166 47.481766 7208 47 2466 4695 Kuwait
2254 2254 6065 Riverside California US 2020-05-09 02:32:35 33.74314981 -115.9933578 4756 192 0 4564 Riverside, California, US
1834 1834 42091 Montgomery Pennsylvania US 2020-05-09 02:32:35 40.21053671 -75.36652296 5037 515 0 4522 Montgomery, Pennsylvania, US
336 336 34007 Camden New Jersey US 2020-05-09 02:32:35 39.80343818 -74.96388753 4620 199 0 4420 Camden, New Jersey, US
248 248 25005 Bristol Massachusetts US 2020-05-09 02:32:35 41.79228404 -71.10872211 4670 252 0 4418 Bristol, Massachusetts, US
490 490 32003 Clark Nevada US 2020-05-09 02:32:35 36.21458855 -115.0130241 4573 245 0 4328 Clark, Nevada, US
712 712 42045 Delaware Pennsylvania US 2020-05-09 02:32:35 39.91680171 -75.40243663 4680 382 0 4298 Delaware, Pennsylvania, US
2316 2316 6073 San Diego California US 2020-05-09 02:32:35 33.03484597 -116.7365326 4429 165 0 4264 San Diego, California, US
761 761 17043 DuPage Illinois US 2020-05-09 02:32:35 41.85116968 -88.08642662 4374 236 0 4138 DuPage, Illinois, US
1079 1079 25013 Hampden Massachusetts US 2020-05-09 02:32:35 42.13440424 -72.63235561 4522 441 0 4081 Hampden, Massachusetts, US
3130 3130       Ireland 2020-05-09 02:32:35 53.1424 -7.6921 22541 1429 17110 4002 Ireland
812 812 36029 Erie New York US 2020-05-09 02:32:35 42.76249024 -78.73063652 4255 346 0 3909 Erie, New York, US

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

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