05-04-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,203 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
3195 3195       United Kingdom 2020-05-05 02:32:34 55.3781 -3.4360000000000004 190584 28734 0 161850 United Kingdom
1886 1886 36061 New York City New York US 2020-05-05 02:32:34 40.76727260000001 -73.97152637 175651 19057 0 156594 New York City, New York, US
3157 3157       Russia 2020-05-05 02:32:34 61.52401 105.31875600000001 145268 1356 18095 125817 Russia
3103 3103       Italy 2020-05-05 02:32:34 41.87194 12.56738 211938 29079 82879 99980 Italy
3080 3080       France 2020-05-05 02:32:34 46.2276 2.2137 169405 25168 50438 92280 France
3176 3176       Spain 2020-05-05 02:32:34 40.463667 -3.74922 218011 25428 121343 71240 Spain
3191 3191       Turkey 2020-05-05 02:32:34 38.9637 35.2433 127659 3461 68166 56032 Turkey
3043 3043       Brazil 2020-05-05 02:32:34 -14.235 -51.9253 108620 7367 45815 55438 Brazil
579 579 17031 Cook Illinois US 2020-05-05 02:32:34 41.84144849 -87.81658794 43715 1802 0 41913 Cook, Illinois, US
3139 3139       Netherlands 2020-05-05 02:32:34 52.1326 5.2913 40770 5082 0 35688 Netherlands
1866 1866 36059 Nassau New York US 2020-05-05 02:32:34 40.74066522 -73.58941873 36965 1792 0 35173 Nassau, New York, US
2486 2486 36103 Suffolk New York US 2020-05-05 02:32:34 40.88320119 -72.8012172 35077 1273 0 33804 Suffolk, New York, US
3097 3097       India 2020-05-05 02:32:34 20.593684 78.96288 46437 1566 12847 32024 India
3151 3151       Peru 2020-05-05 02:32:34 -9.19 -75.0152 47372 1344 14427 31601 Peru
2993 2993     Quebec Canada 2020-05-05 02:32:34 52.9399 -73.5491 32631 3189 0 30350 Quebec, Canada
3036 3036       Belgium 2020-05-05 02:32:34 50.8333 4.469936 50267 7924 12378 29965 Belgium
2819 2819 36119 Westchester New York US 2020-05-05 02:32:34 41.16278376 -73.75741653 30097 1101 0 28996 Westchester, New York, US
3070 3070       Ecuador 2020-05-05 02:32:34 -1.8312 -78.1834 31881 1569 3433 26879 Ecuador
3084 3084       Germany 2020-05-05 02:32:34 51.165690999999995 10.451526 166152 6993 132700 26459 Germany
1555 1555 6037 Los Angeles California US 2020-05-05 02:32:34 34.30828379 -118.22824109999999 26225 1257 0 24968 Los Angeles, California, US
3165 3165       Saudi Arabia 2020-05-05 02:32:34 23.885942 45.079162 28656 191 4476 23989 Saudi Arabia
3154 3154       Portugal 2020-05-05 02:32:34 39.3999 -8.2245 25524 1063 1712 22749 Portugal
2989 2989     Ontario Canada 2020-05-05 02:32:34 51.2538 -85.3232 19097 1446 0 17651 Ontario, Canada
3170 3170       Singapore 2020-05-05 02:32:34 1.2833 103.8333 18778 18 1457 17303 Singapore
3180 3180       Sweden 2020-05-05 02:32:34 60.128161 18.643501 22721 2769 4074 15878 Sweden
2793 2793 26163 Wayne Michigan US 2020-05-05 02:32:34 42.28098405 -83.281255 17314 1924 0 15390 Wayne, Michigan, US
2062 2062 42101 Philadelphia Pennsylvania US 2020-05-05 02:32:34 40.00338507 -75.1379271 16040 726 0 15314 Philadelphia, Pennsylvania, US
172 172 34003 Bergen New Jersey US 2020-05-05 02:32:34 40.96010917 -74.07164325 16289 1215 0 15067 Bergen, New Jersey, US
1194 1194 34017 Hudson New Jersey US 2020-05-05 02:32:34 40.73766234 -74.07515667 15883 845 0 15036 Hudson, New Jersey, US
3147 3147       Pakistan 2020-05-05 02:32:34 30.3753 69.3451 20941 476 5635 14830 Pakistan
1744 1744 25017 Middlesex Massachusetts US 2020-05-05 02:32:34 42.48607732 -71.39049229 15757 997 0 14760 Middlesex, Massachusetts, US
3155 3155       Qatar 2020-05-05 02:32:34 25.3548 51.1839 16191 12 1810 14369 Qatar
3035 3035       Belarus 2020-05-05 02:32:34 53.7098 27.9534 17489 103 3259 14127 Belarus
2485 2485 25025 Suffolk Massachusetts US 2020-05-05 02:32:34 42.327951399999996 -71.07850442 13941 596 0 13345 Suffolk, Massachusetts, US
808 808 34013 Essex New Jersey US 2020-05-05 02:32:34 40.78681335 -74.24657979 14623 1292 0 13329 Essex, New Jersey, US
3099 3099       Iran 2020-05-05 02:32:34 32.427908 53.68804599999999 98647 6277 79379 12991 Iran
2023 2023 34031 Passaic New Jersey US 2020-05-05 02:32:34 41.03238628 -74.29954144 13496 633 0 12863 Passaic, New Jersey, US
1741 1741 12086 Miami-Dade Florida US 2020-05-05 02:32:34 25.6112362 -80.55170587 13092 378 0 12714 Miami-Dade, Florida, US
2665 2665 34039 Union New Jersey US 2020-05-05 02:32:34 40.65835409 -74.30680092 13357 737 0 12620 Union, New Jersey, US
1745 1745 34023 Middlesex New Jersey US 2020-05-05 02:32:34 40.43629879 -74.41426991 12770 642 0 12126 Middlesex, New Jersey, US
3194 3194       United Arab Emirates 2020-05-05 02:32:34 23.424076 53.847818000000004 14730 137 2966 11627 United Arab Emirates
2250 2250 36087 Rockland New York US 2020-05-05 02:32:34 41.15027894 -74.02560498 12095 536 0 11559 Rockland, New York, US
819 819 9001 Fairfield Connecticut US 2020-05-05 02:32:34 41.26809896 -73.3881171 12245 910 0 11335 Fairfield, Connecticut, US
3193 3193       Ukraine 2020-05-05 02:32:34 48.3794 31.1656 12331 303 1619 10409 Ukraine
3105 3105       Japan 2020-05-05 02:32:34 36.204824 138.252924 15078 536 4156 10386 Japan
3054 3054       Chile 2020-05-05 02:32:34 -35.6751 -71.543 20643 270 10415 9958 Chile
807 807 25009 Essex Massachusetts US 2020-05-05 02:32:34 42.6687626 -70.94687179 9773 512 0 9261 Essex, Massachusetts, US
3153 3153       Poland 2020-05-05 02:32:34 51.9194 19.1451 14006 698 4095 9213 Poland
3130 3130       Mexico 2020-05-05 02:32:34 23.6345 -102.5528 24905 2271 13447 9187 Mexico
3098 3098       Indonesia 2020-05-05 02:32:34 -0.7893 113.9213 11587 864 1954 8769 Indonesia
3033 3033       Bangladesh 2020-05-05 02:32:34 23.685 90.3563 10143 182 1209 8752 Bangladesh
1961 1961 36071 Orange New York US 2020-05-05 02:32:34 41.40337468 -74.30240757 9015 343 0 8672 Orange, New York, US
3167 3167       Serbia 2020-05-05 02:32:34 44.0165 21.0059 9557 197 1574 7786 Serbia
3145 3145       Norway 2020-05-05 02:32:34 60.472 8.4689 7904 214 32 7658 Norway
3152 3152       Philippines 2020-05-05 02:32:34 12.879721 121.77401699999999 9485 623 1315 7547 Philippines
1882 1882 9009 New Haven Connecticut US 2020-05-05 02:32:34 41.408032500000004 -72.93620426 8110 595 0 7515 New Haven, Connecticut, US
3156 3156       Romania 2020-05-05 02:32:34 45.9432 24.9668 13512 818 5269 7425 Romania
2149 2149 24033 Prince George's Maryland US 2020-05-05 02:32:34 38.83070039 -76.8496441 7598 284 0 7314 Prince George's, Maryland, US
2152 2152 44007 Providence Rhode Island US 2020-05-05 02:32:34 41.87064746 -71.57753536 7138 0 0 7138 Providence, Rhode Island, US
3101 3101       Ireland 2020-05-05 02:32:34 53.1424 -7.6921 21772 1319 13386 7067 Ireland
1100 1100 48201 Harris Texas US 2020-05-05 02:32:34 29.86 -95.39 6967 140 0 6827 Harris, Texas, US
1926 1926 26125 Oakland Michigan US 2020-05-05 02:32:34 42.66090111 -83.38595416 7499 762 0 6737 Oakland, Michigan, US
1928 1928 34029 Ocean New Jersey US 2020-05-05 02:32:34 39.8895449 -74.28089251 6974 447 0 6527 Ocean, New Jersey, US
3148 3148       Panama 2020-05-05 02:32:34 8.538 -80.7821 7197 200 641 6356 Panama
2891 2891 25027 Worcester Massachusetts US 2020-05-05 02:32:34 42.35026951 -71.90493363 6471 320 0 6151 Worcester, Massachusetts, US
3069 3069       Dominican Republic 2020-05-05 02:32:34 18.7357 -70.1627 8235 346 1771 6118 Dominican Republic
1968 1968 22071 Orleans Louisiana US 2020-05-05 02:32:34 30.06971951 -89.92660315 6557 447 0 6110 Orleans, Louisiana, US
1365 1365 53033 King Washington US 2020-05-05 02:32:34 47.49137892 -121.8346131 6545 480 0 6082 King, Washington, US
1282 1282 22051 Jefferson Louisiana US 2020-05-05 02:32:34 29.74075478 -90.11115756 6426 377 0 6049 Jefferson, Louisiana, US
1777 1777 34025 Monmouth New Jersey US 2020-05-05 02:32:34 40.26549699 -74.22240686 6378 385 0 5993 Monmouth, New Jersey, US
1631 1631 18097 Marion Indiana US 2020-05-05 02:32:34 39.78163624 -86.13826325 6327 363 0 5964 Marion, Indiana, US
3102 3102       Israel 2020-05-05 02:32:34 31.046051000000002 34.851612 16149 238 10233 5947 Israel
1910 1910 25021 Norfolk Massachusetts US 2020-05-05 02:32:34 42.16073095 -71.20530408 6382 555 0 5827 Norfolk, Massachusetts, US
3055 3055       Colombia 2020-05-05 02:32:34 4.5709 -74.2973 7973 358 1807 5808 Colombia
2930 2930     Alberta Canada 2020-05-05 02:32:34 53.9333 -116.5765 5836 104 0 5732 Alberta, Canada
1112 1112 9003 Hartford Connecticut US 2020-05-05 02:32:34 41.80283011 -72.73103891 6173 773 0 5400 Hartford, Connecticut, US
2104 2104 25023 Plymouth Massachusetts US 2020-05-05 02:32:34 41.94070556 -70.80802823 5602 333 0 5269 Plymouth, Massachusetts, US
254 254 12011 Broward Florida US 2020-05-05 02:32:34 26.15184651 -80.48725556 5383 208 0 5175 Broward, Florida, US
1839 1839 34027 Morris New Jersey US 2020-05-05 02:32:34 40.86095313 -74.54553709999998 5549 449 0 5100 Morris, New Jersey, US
1581 1581 26099 Macomb Michigan US 2020-05-05 02:32:34 42.69158356 -82.92752801 5736 643 0 5093 Macomb, Michigan, US
1809 1809 24031 Montgomery Maryland US 2020-05-05 02:32:34 39.13676329 -77.20358245 5384 301 0 5083 Montgomery, Maryland, US
724 724 11001 District of Columbia District of Columbia US 2020-05-05 02:32:34 38.90417773 -77.01655992 5170 258 0 4912 District of Columbia, District of Columbia, US
3071 3071       Egypt 2020-05-05 02:32:34 26.820553000000004 30.802497999999996 6813 436 1632 4745 Egypt
1622 1622 4013 Maricopa Arizona US 2020-05-05 02:32:34 33.34835867 -112.49181540000001 4751 147 0 4604 Maricopa, Arizona, US
817 817 51059 Fairfax Virginia US 2020-05-05 02:32:34 38.83677558 -77.27565836 4615 198 0 4417 Fairfax, Virginia, US
1728 1728 34021 Mercer New Jersey US 2020-05-05 02:32:34 40.28047017 -74.70479631 4594 256 0 4338 Mercer, New Jersey, US
3174 3174       South Africa 2020-05-05 02:32:34 -30.5595 22.9375 7220 138 2746 4336 South Africa
1815 1815 42091 Montgomery Pennsylvania US 2020-05-05 02:32:34 40.21053671 -75.36652296 4645 382 0 4263 Montgomery, Pennsylvania, US
656 656 48113 Dallas Texas US 2020-05-05 02:32:34 32.76670599 -96.77796049999999 4370 145 0 4256 Dallas, Texas, US
485 485 32003 Clark Nevada US 2020-05-05 02:32:34 36.21458855 -115.0130241 4411 223 0 4188 Clark, Nevada, US
2231 2231 6065 Riverside California US 2020-05-05 02:32:34 33.74314981 -115.9933578 4354 181 0 4173 Riverside, California, US
1416 1416 17097 Lake Illinois US 2020-05-05 02:32:34 42.3224907 -88.00367925 4252 151 0 4101 Lake, Illinois, US
703 703 42045 Delaware Pennsylvania US 2020-05-05 02:32:34 39.91680171 -75.40243663 4198 258 0 3940 Delaware, Pennsylvania, US
332 332 34007 Camden New Jersey US 2020-05-05 02:32:34 39.80343818 -74.96388753 4073 163 0 3910 Camden, New Jersey, US
244 244 25005 Bristol Massachusetts US 2020-05-05 02:32:34 41.79228404 -71.10872211 4103 205 0 3898 Bristol, Massachusetts, US
2293 2293 6073 San Diego California US 2020-05-05 02:32:34 33.03484597 -116.73653259999999 3927 139 0 3788 San Diego, California, US
3064 3064       Czechia 2020-05-05 02:32:34 49.8175 15.472999999999999 7819 252 3807 3760 Czechia
1065 1065 25013 Hampden Massachusetts US 2020-05-05 02:32:34 42.13440424 -72.63235561 4114 408 0 3706 Hampden, Massachusetts, US
752 752 17043 DuPage Illinois US 2020-05-05 02:32:34 41.85116968 -88.08642662 3803 196 0 3607 DuPage, Illinois, US
802 802 36029 Erie New York US 2020-05-05 02:32:34 42.76249024 -78.73063652 3802 283 0 3519 Erie, New York, US

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

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