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 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
3176 3176       Spain 2020-05-05 02:32:34 40.463667 -3.74922 218011 25428 121343 71240 Spain
3103 3103       Italy 2020-05-05 02:32:34 41.87194 12.56738 211938 29079 82879 99980 Italy
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
3080 3080       France 2020-05-05 02:32:34 46.2276 2.2137 169405 25168 50438 92280 France
3084 3084       Germany 2020-05-05 02:32:34 51.165690999999995 10.451526 166152 6993 132700 26459 Germany
3157 3157       Russia 2020-05-05 02:32:34 61.52401 105.31875600000001 145268 1356 18095 125817 Russia
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
3099 3099       Iran 2020-05-05 02:32:34 32.427908 53.68804599999999 98647 6277 79379 12991 Iran
2966 2966     Hubei China 2020-05-05 02:32:34 30.9756 112.2707 68128 4512 63616 0 Hubei, China
3036 3036       Belgium 2020-05-05 02:32:34 50.8333 4.469936 50267 7924 12378 29965 Belgium
3151 3151       Peru 2020-05-05 02:32:34 -9.19 -75.0152 47372 1344 14427 31601 Peru
3097 3097       India 2020-05-05 02:32:34 20.593684 78.96288 46437 1566 12847 32024 India
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
2993 2993     Quebec Canada 2020-05-05 02:32:34 52.9399 -73.5491 32631 3189 0 30350 Quebec, Canada
3070 3070       Ecuador 2020-05-05 02:32:34 -1.8312 -78.1834 31881 1569 3433 26879 Ecuador
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
3181 3181       Switzerland 2020-05-05 02:32:34 46.8182 8.2275 29981 1784 25200 2997 Switzerland
3165 3165       Saudi Arabia 2020-05-05 02:32:34 23.885942 45.079162 28656 191 4476 23989 Saudi Arabia
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
3154 3154       Portugal 2020-05-05 02:32:34 39.3999 -8.2245 25524 1063 1712 22749 Portugal
3130 3130       Mexico 2020-05-05 02:32:34 23.6345 -102.5528 24905 2271 13447 9187 Mexico
3180 3180       Sweden 2020-05-05 02:32:34 60.128161 18.643501 22721 2769 4074 15878 Sweden
3101 3101       Ireland 2020-05-05 02:32:34 53.1424 -7.6921 21772 1319 13386 7067 Ireland
3147 3147       Pakistan 2020-05-05 02:32:34 30.3753 69.3451 20941 476 5635 14830 Pakistan
3054 3054       Chile 2020-05-05 02:32:34 -35.6751 -71.543 20643 270 10415 9958 Chile
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
3035 3035       Belarus 2020-05-05 02:32:34 53.7098 27.9534 17489 103 3259 14127 Belarus
2793 2793 26163 Wayne Michigan US 2020-05-05 02:32:34 42.28098405 -83.281255 17314 1924 0 15390 Wayne, Michigan, 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
3155 3155       Qatar 2020-05-05 02:32:34 25.3548 51.1839 16191 12 1810 14369 Qatar
3102 3102       Israel 2020-05-05 02:32:34 31.046051000000002 34.851612 16149 238 10233 5947 Israel
2062 2062 42101 Philadelphia Pennsylvania US 2020-05-05 02:32:34 40.00338507 -75.1379271 16040 726 0 15314 Philadelphia, Pennsylvania, 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
1744 1744 25017 Middlesex Massachusetts US 2020-05-05 02:32:34 42.48607732 -71.39049229 15757 997 0 14760 Middlesex, Massachusetts, US
3029 3029       Austria 2020-05-05 02:32:34 47.5162 14.5501 15621 600 13316 1705 Austria
3105 3105       Japan 2020-05-05 02:32:34 36.204824 138.252924 15078 536 4156 10386 Japan
3194 3194       United Arab Emirates 2020-05-05 02:32:34 23.424076 53.847818000000004 14730 137 2966 11627 United Arab Emirates
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
3153 3153       Poland 2020-05-05 02:32:34 51.9194 19.1451 14006 698 4095 9213 Poland
2485 2485 25025 Suffolk Massachusetts US 2020-05-05 02:32:34 42.327951399999996 -71.07850442 13941 596 0 13345 Suffolk, Massachusetts, US
3156 3156       Romania 2020-05-05 02:32:34 45.9432 24.9668 13512 818 5269 7425 Romania
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
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
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
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
3193 3193       Ukraine 2020-05-05 02:32:34 48.3794 31.1656 12331 303 1619 10409 Ukraine
819 819 9001 Fairfield Connecticut US 2020-05-05 02:32:34 41.26809896 -73.3881171 12245 910 0 11335 Fairfield, Connecticut, US
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
3098 3098       Indonesia 2020-05-05 02:32:34 -0.7893 113.9213 11587 864 1954 8769 Indonesia
3109 3109       Korea, South 2020-05-05 02:32:34 35.90775700000001 127.766922 10804 254 9283 1267 Korea, South
3033 3033       Bangladesh 2020-05-05 02:32:34 23.685 90.3563 10143 182 1209 8752 Bangladesh
807 807 25009 Essex Massachusetts US 2020-05-05 02:32:34 42.6687626 -70.94687179 9773 512 0 9261 Essex, Massachusetts, US
3065 3065       Denmark 2020-05-05 02:32:34 56.2639 9.5018 9670 493 7088 2089 Denmark
3167 3167       Serbia 2020-05-05 02:32:34 44.0165 21.0059 9557 197 1574 7786 Serbia
3152 3152       Philippines 2020-05-05 02:32:34 12.879721 121.77401699999999 9485 623 1315 7547 Philippines
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
3069 3069       Dominican Republic 2020-05-05 02:32:34 18.7357 -70.1627 8235 346 1771 6118 Dominican Republic
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
3055 3055       Colombia 2020-05-05 02:32:34 4.5709 -74.2973 7973 358 1807 5808 Colombia
3145 3145       Norway 2020-05-05 02:32:34 60.472 8.4689 7904 214 32 7658 Norway
3064 3064       Czechia 2020-05-05 02:32:34 49.8175 15.472999999999999 7819 252 3807 3760 Czechia
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
1926 1926 26125 Oakland Michigan US 2020-05-05 02:32:34 42.66090111 -83.38595416 7499 762 0 6737 Oakland, Michigan, US
3174 3174       South Africa 2020-05-05 02:32:34 -30.5595 22.9375 7220 138 2746 4336 South Africa
3148 3148       Panama 2020-05-05 02:32:34 8.538 -80.7821 7197 200 641 6356 Panama
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
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
1100 1100 48201 Harris Texas US 2020-05-05 02:32:34 29.86 -95.39 6967 140 0 6827 Harris, Texas, US
3071 3071       Egypt 2020-05-05 02:32:34 26.820553000000004 30.802497999999996 6813 436 1632 4745 Egypt
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
2891 2891 25027 Worcester Massachusetts US 2020-05-05 02:32:34 42.35026951 -71.90493363 6471 320 0 6151 Worcester, Massachusetts, US
1282 1282 22051 Jefferson Louisiana US 2020-05-05 02:32:34 29.74075478 -90.11115756 6426 377 0 6049 Jefferson, Louisiana, US
1910 1910 25021 Norfolk Massachusetts US 2020-05-05 02:32:34 42.16073095 -71.20530408 6382 555 0 5827 Norfolk, Massachusetts, 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
3124 3124       Malaysia 2020-05-05 02:32:34 4.210483999999999 101.97576600000001 6353 105 4484 1764 Malaysia
1631 1631 18097 Marion Indiana US 2020-05-05 02:32:34 39.78163624 -86.13826325 6327 363 0 5964 Marion, Indiana, US
1112 1112 9003 Hartford Connecticut US 2020-05-05 02:32:34 41.80283011 -72.73103891 6173 773 0 5400 Hartford, Connecticut, US
2930 2930     Alberta Canada 2020-05-05 02:32:34 53.9333 -116.5765 5836 104 0 5732 Alberta, Canada
1581 1581 26099 Macomb Michigan US 2020-05-05 02:32:34 42.69158356 -82.92752801 5736 643 0 5093 Macomb, Michigan, US
2104 2104 25023 Plymouth Massachusetts US 2020-05-05 02:32:34 41.94070556 -70.80802823 5602 333 0 5269 Plymouth, Massachusetts, 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
1809 1809 24031 Montgomery Maryland US 2020-05-05 02:32:34 39.13676329 -77.20358245 5384 301 0 5083 Montgomery, Maryland, US
254 254 12011 Broward Florida US 2020-05-05 02:32:34 26.15184651 -80.48725556 5383 208 0 5175 Broward, Florida, US
3079 3079       Finland 2020-05-05 02:32:34 61.92411 25.748151 5327 240 3500 1587 Finland
3111 3111       Kuwait 2020-05-05 02:32:34 29.311659999999996 47.481766 5278 40 1947 3291 Kuwait
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
3135 3135       Morocco 2020-05-05 02:32:34 31.7917 -7.0926 5053 179 1653 3221 Morocco
3027 3027       Argentina 2020-05-05 02:32:34 -38.4161 -63.6167 4887 260 1442 3185 Argentina
1622 1622 4013 Maricopa Arizona US 2020-05-05 02:32:34 33.34835867 -112.49181540000001 4751 147 0 4604 Maricopa, Arizona, US
3023 3023       Algeria 2020-05-05 02:32:34 28.0339 1.6596 4648 465 1998 2185 Algeria
1815 1815 42091 Montgomery Pennsylvania US 2020-05-05 02:32:34 40.21053671 -75.36652296 4645 382 0 4263 Montgomery, Pennsylvania, 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

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
);