05-06-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,218 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
3210 3210       United Kingdom 2020-05-07 02:32:28 55.3781 -3.4360000000000004 201101 30076 0 171025 United Kingdom
1896 1896 36061 New York City New York US 2020-05-07 02:32:28 40.76727260000001 -73.97152637 178351 19174 0 159177 New York City, New York, US
3172 3172       Russia 2020-05-07 02:32:28 61.52401 105.31875600000001 165929 1537 21327 143065 Russia
3095 3095       France 2020-05-07 02:32:28 46.2276 2.2137 174596 25772 53022 93671 France
3118 3118       Italy 2020-05-07 02:32:28 41.87194 12.56738 214457 29684 93245 91528 Italy
3191 3191       Spain 2020-05-07 02:32:28 40.463667 -3.74922 220325 25857 126002 68466 Spain
3058 3058       Brazil 2020-05-07 02:32:28 -14.235 -51.9253 126611 8588 51370 66653 Brazil
3206 3206       Turkey 2020-05-07 02:32:28 38.9637 35.2433 131744 3584 78202 49958 Turkey
584 584 17031 Cook Illinois US 2020-05-07 02:32:28 41.84144849 -87.81658794 46689 2004 0 44685 Cook, Illinois, US
3154 3154       Netherlands 2020-05-07 02:32:28 52.1326 5.2913 41319 5204 0 36115 Netherlands
3112 3112       India 2020-05-07 02:32:28 20.593684 78.96288 52987 1785 15331 35871 India
3166 3166       Peru 2020-05-07 02:32:28 -9.19 -75.0152 54817 1533 17527 35757 Peru
1876 1876 36059 Nassau New York US 2020-05-07 02:32:28 40.74066522 -73.58941873 37350 1891 0 35459 Nassau, New York, US
2498 2498 36103 Suffolk New York US 2020-05-07 02:32:28 40.88320119 -72.8012172 35543 1522 0 34021 Suffolk, New York, US
3008 3008     Quebec Canada 2020-05-07 02:32:28 52.9399 -73.5491 34334 3385 0 31823 Quebec, Canada
3051 3051       Belgium 2020-05-07 02:32:28 50.8333 4.469936 50781 8339 12731 29711 Belgium
2833 2833 36119 Westchester New York US 2020-05-07 02:32:28 41.16278376 -73.75741653 30426 1167 0 29259 Westchester, New York, US
1564 1564 6037 Los Angeles California US 2020-05-07 02:32:28 34.30828379 -118.22824109999999 28665 1369 0 27296 Los Angeles, California, US
3085 3085       Ecuador 2020-05-07 02:32:28 -1.8312 -78.1834 31881 1618 3433 26830 Ecuador
3180 3180       Saudi Arabia 2020-05-07 02:32:28 23.885942 45.079162 31938 209 6783 24946 Saudi Arabia
3169 3169       Portugal 2020-05-07 02:32:28 39.3999 -8.2245 26182 1089 2076 23017 Portugal
3099 3099       Germany 2020-05-07 02:32:28 51.165690999999995 10.451526 168162 7275 139900 20987 Germany
3185 3185       Singapore 2020-05-07 02:32:28 1.2833 103.8333 20198 20 1634 18544 Singapore
3004 3004     Ontario Canada 2020-05-07 02:32:28 51.2538 -85.3232 19910 1560 0 18350 Ontario, Canada
3162 3162       Pakistan 2020-05-07 02:32:28 30.3753 69.3451 24073 564 6464 17045 Pakistan
3195 3195       Sweden 2020-05-07 02:32:28 60.128161 18.643501 23918 2941 4074 16903 Sweden
2073 2073 42101 Philadelphia Pennsylvania US 2020-05-07 02:32:28 40.00338507 -75.1379271 16697 803 0 15894 Philadelphia, Pennsylvania, US
3170 3170       Qatar 2020-05-07 02:32:28 25.3548 51.1839 17972 12 2070 15890 Qatar
2807 2807 26163 Wayne Michigan US 2020-05-07 02:32:28 42.28098405 -83.281255 17571 1973 0 15598 Wayne, Michigan, US
1202 1202 34017 Hudson New Jersey US 2020-05-07 02:32:28 40.73766234 -74.07515667 16199 903 0 15294 Hudson, New Jersey, US
1754 1754 25017 Middlesex Massachusetts US 2020-05-07 02:32:28 42.48607732 -71.39049229 16327 1070 0 15257 Middlesex, Massachusetts, US
174 174 34003 Bergen New Jersey US 2020-05-07 02:32:28 40.96010917 -74.07164325 16529 1289 0 15231 Bergen, New Jersey, US
3050 3050       Belarus 2020-05-07 02:32:28 53.7098 27.9534 19255 112 4388 14755 Belarus
2497 2497 25025 Suffolk Massachusetts US 2020-05-07 02:32:28 42.327951399999996 -71.07850442 14476 642 0 13834 Suffolk, Massachusetts, US
3114 3114       Iran 2020-05-07 02:32:28 32.427908 53.68804599999999 101650 6418 81587 13645 Iran
814 814 34013 Essex New Jersey US 2020-05-07 02:32:28 40.78681335 -74.24657979 14953 1349 0 13602 Essex, New Jersey, US
2034 2034 34031 Passaic New Jersey US 2020-05-07 02:32:28 41.03238628 -74.29954144 13971 690 0 13281 Passaic, New Jersey, US
1751 1751 12086 Miami-Dade Florida US 2020-05-07 02:32:28 25.6112362 -80.55170587 13371 432 0 12939 Miami-Dade, Florida, US
2679 2679 34039 Union New Jersey US 2020-05-07 02:32:28 40.65835409 -74.30680092 13605 800 0 12804 Union, New Jersey, US
1755 1755 34023 Middlesex New Jersey US 2020-05-07 02:32:28 40.43629879 -74.41426991 13257 706 0 12548 Middlesex, New Jersey, US
3209 3209       United Arab Emirates 2020-05-07 02:32:28 23.424076 53.847818000000004 15738 157 3359 12222 United Arab Emirates
2262 2262 36087 Rockland New York US 2020-05-07 02:32:28 41.15027894 -74.02560498 12204 551 0 11653 Rockland, New York, US
3069 3069       Chile 2020-05-07 02:32:28 -35.6751 -71.543 23048 281 11189 11578 Chile
825 825 9001 Fairfield Connecticut US 2020-05-07 02:32:28 41.26809896 -73.3881171 12455 952 0 11503 Fairfield, Connecticut, US
3208 3208       Ukraine 2020-05-07 02:32:28 48.3794 31.1656 13184 327 2097 10760 Ukraine
3120 3120       Japan 2020-05-07 02:32:28 36.204824 138.252924 15253 556 4496 10201 Japan
3048 3048       Bangladesh 2020-05-07 02:32:28 23.685 90.3563 11719 186 1403 10130 Bangladesh
813 813 25009 Essex Massachusetts US 2020-05-07 02:32:28 42.6687626 -70.94687179 10344 561 0 9783 Essex, Massachusetts, US
3168 3168       Poland 2020-05-07 02:32:28 51.9194 19.1451 14740 733 4655 9352 Poland
3113 3113       Indonesia 2020-05-07 02:32:28 -0.7893 113.9213 12438 895 2317 9226 Indonesia
1971 1971 36071 Orange New York US 2020-05-07 02:32:28 41.40337468 -74.30240757 9215 358 0 8857 Orange, New York, US
3167 3167       Philippines 2020-05-07 02:32:28 12.879721 121.77401699999999 10004 658 1506 7840 Philippines
2161 2161 24033 Prince George's Maryland US 2020-05-07 02:32:28 38.83070039 -76.8496441 8135 311 0 7824 Prince George's, Maryland, US
1892 1892 9009 New Haven Connecticut US 2020-05-07 02:32:28 41.408032500000004 -72.93620426 8419 629 0 7790 New Haven, Connecticut, US
3160 3160       Norway 2020-05-07 02:32:28 60.472 8.4689 7996 216 32 7748 Norway
3182 3182       Serbia 2020-05-07 02:32:28 44.0165 21.0059 9791 203 1971 7617 Serbia
3171 3171       Romania 2020-05-07 02:32:28 45.9432 24.9668 14107 864 5788 7455 Romania
3145 3145       Mexico 2020-05-07 02:32:28 23.6345 -102.5528 27634 2704 17781 7149 Mexico
2164 2164 44007 Providence Rhode Island US 2020-05-07 02:32:28 41.87064746 -71.57753536 7138 0 0 7138 Providence, Rhode Island, US
1108 1108 48201 Harris Texas US 2020-05-07 02:32:28 29.86 -95.39 7244 150 0 7094 Harris, Texas, US
1936 1936 26125 Oakland Michigan US 2020-05-07 02:32:28 42.66090111 -83.38595416 7573 774 0 6799 Oakland, Michigan, US
3163 3163       Panama 2020-05-07 02:32:28 8.538 -80.7821 7731 218 859 6654 Panama
1938 1938 34029 Ocean New Jersey US 2020-05-07 02:32:28 39.8895449 -74.28089251 7125 483 0 6642 Ocean, New Jersey, US
2905 2905 25027 Worcester Massachusetts US 2020-05-07 02:32:28 42.35026951 -71.90493363 6992 365 0 6627 Worcester, Massachusetts, US
3084 3084       Dominican Republic 2020-05-07 02:32:28 18.7357 -70.1627 8807 362 1960 6485 Dominican Republic
3070 3070       Colombia 2020-05-07 02:32:28 4.5709 -74.2973 8959 397 2148 6414 Colombia
1640 1640 18097 Marion Indiana US 2020-05-07 02:32:28 39.78163624 -86.13826325 6730 390 0 6340 Marion, Indiana, US
1373 1373 53033 King Washington US 2020-05-07 02:32:28 47.49137892 -121.8346131 6704 489 0 6230 King, Washington, US
1290 1290 22051 Jefferson Louisiana US 2020-05-07 02:32:28 29.74075478 -90.11115756 6554 387 0 6167 Jefferson, Louisiana, US
1978 1978 22071 Orleans Louisiana US 2020-05-07 02:32:28 30.06971951 -89.92660315 6608 464 0 6144 Orleans, Louisiana, US
1787 1787 34025 Monmouth New Jersey US 2020-05-07 02:32:28 40.26549699 -74.22240686 6552 417 0 6135 Monmouth, New Jersey, US
1920 1920 25021 Norfolk Massachusetts US 2020-05-07 02:32:28 42.16073095 -71.20530408 6610 596 0 6014 Norfolk, Massachusetts, US
2945 2945     Alberta Canada 2020-05-07 02:32:28 53.9333 -116.5765 5963 112 0 5851 Alberta, Canada
1120 1120 9003 Hartford Connecticut US 2020-05-07 02:32:28 41.80283011 -72.73103891 6530 842 0 5688 Hartford, Connecticut, US
2115 2115 25023 Plymouth Massachusetts US 2020-05-07 02:32:28 41.94070556 -70.80802823 5899 357 0 5542 Plymouth, Massachusetts, US
1819 1819 24031 Montgomery Maryland US 2020-05-07 02:32:28 39.13676329 -77.20358245 5790 333 0 5457 Montgomery, Maryland, US
3117 3117       Israel 2020-05-07 02:32:28 31.046051000000002 34.851612 16246 241 10843 5434 Israel
257 257 12011 Broward Florida US 2020-05-07 02:32:28 26.15184651 -80.48725556 5553 219 0 5334 Broward, Florida, US
3086 3086       Egypt 2020-05-07 02:32:28 26.820553000000004 30.802497999999996 7588 469 1815 5304 Egypt
729 729 11001 District of Columbia District of Columbia US 2020-05-07 02:32:28 38.90417773 -77.01655992 5461 277 0 5184 District of Columbia, District of Columbia, US
1590 1590 26099 Macomb Michigan US 2020-05-07 02:32:28 42.69158356 -82.92752801 5832 662 0 5170 Macomb, Michigan, US
1849 1849 34027 Morris New Jersey US 2020-05-07 02:32:28 40.86095313 -74.54553709999998 5655 491 0 5164 Morris, New Jersey, US
1631 1631 4013 Maricopa Arizona US 2020-05-07 02:32:28 33.34835867 -112.49181540000001 5138 186 0 4952 Maricopa, Arizona, US
661 661 48113 Dallas Texas US 2020-05-07 02:32:28 32.76670599 -96.77796049999999 4869 148 0 4746 Dallas, Texas, US
823 823 51059 Fairfax Virginia US 2020-05-07 02:32:28 38.83677558 -77.27565836 4834 201 0 4633 Fairfax, Virginia, US
1738 1738 34021 Mercer New Jersey US 2020-05-07 02:32:28 40.28047017 -74.70479631 4861 298 0 4562 Mercer, New Jersey, US
3189 3189       South Africa 2020-05-07 02:32:28 -30.5595 22.9375 7808 153 3153 4502 South Africa
2243 2243 6065 Riverside California US 2020-05-07 02:32:28 33.74314981 -115.9933578 4672 186 0 4486 Riverside, California, US
1424 1424 17097 Lake Illinois US 2020-05-07 02:32:28 42.3224907 -88.00367925 4529 162 0 4367 Lake, Illinois, US
1825 1825 42091 Montgomery Pennsylvania US 2020-05-07 02:32:28 40.21053671 -75.36652296 4827 471 0 4356 Montgomery, Pennsylvania, US
488 488 32003 Clark Nevada US 2020-05-07 02:32:28 36.21458855 -115.0130241 4473 238 0 4235 Clark, Nevada, US
2305 2305 6073 San Diego California US 2020-05-07 02:32:28 33.03484597 -116.73653259999999 4319 158 0 4161 San Diego, California, US
247 247 25005 Bristol Massachusetts US 2020-05-07 02:32:28 41.79228404 -71.10872211 4380 223 0 4157 Bristol, Massachusetts, US
335 335 34007 Camden New Jersey US 2020-05-07 02:32:28 39.80343818 -74.96388753 4307 189 0 4118 Camden, New Jersey, US
708 708 42045 Delaware Pennsylvania US 2020-05-07 02:32:28 39.91680171 -75.40243663 4373 326 0 4047 Delaware, Pennsylvania, US
3126 3126       Kuwait 2020-05-07 02:32:28 29.311659999999996 47.481766 6289 42 2219 4028 Kuwait
1073 1073 25013 Hampden Massachusetts US 2020-05-07 02:32:28 42.13440424 -72.63235561 4321 425 0 3896 Hampden, Massachusetts, US
757 757 17043 DuPage Illinois US 2020-05-07 02:32:28 41.85116968 -88.08642662 4056 220 0 3836 DuPage, Illinois, US
3116 3116       Ireland 2020-05-07 02:32:28 53.1424 -7.6921 22248 1375 17110 3763 Ireland
808 808 36029 Erie New York US 2020-05-07 02:32:28 42.76249024 -78.73063652 4008 323 0 3685 Erie, New York, US

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

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