05-11-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,236 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
3209 3209       Spain 2020-05-12 03:32:27 40.463667 -3.74922 227436 26744 137139 63553 Spain
3228 3228       United Kingdom 2020-05-12 03:32:27 55.3781 -3.4360000000000004 223060 32065 0 190995 United Kingdom
3190 3190       Russia 2020-05-12 03:32:27 61.52401 105.318756 221344 2009 39801 179534 Russia
3136 3136       Italy 2020-05-12 03:32:27 41.87194 12.56738 219814 30739 106587 82488 Italy
1907 1907 36061 New York City New York US 2020-05-12 03:32:27 40.76727260000001 -73.97152637 185357 20056 0 165301 New York City, New York, US
3113 3113       France 2020-05-12 03:32:27 46.2276 2.2137 176651 26604 55561 93314 France
3117 3117       Germany 2020-05-12 03:32:27 51.165691 10.451526 172576 7661 145617 19298 Germany
3076 3076       Brazil 2020-05-12 03:32:27 -14.235 -51.9253 169594 11653 67384 90557 Brazil
3224 3224       Turkey 2020-05-12 03:32:27 38.9637 35.2433 139771 3841 95780 40150 Turkey
3132 3132       Iran 2020-05-12 03:32:27 32.427908 53.68804599999999 109286 6685 87422 15179 Iran
3130 3130       India 2020-05-12 03:32:27 20.593684 78.96288 70768 2294 22549 45925 India
3184 3184       Peru 2020-05-12 03:32:27 -9.19 -75.0152 68822 1961 22406 44455 Peru
2999 2999     Hubei China 2020-05-12 03:32:27 30.9756 112.2707 68134 4512 63616 6 Hubei, China
3069 3069       Belgium 2020-05-12 03:32:27 50.8333 4.469936 53449 8707 13697 31045 Belgium
589 589 17031 Cook Illinois US 2020-05-12 03:32:27 41.84144849 -87.81658794 53381 2361 0 51020 Cook, Illinois, US
3172 3172       Netherlands 2020-05-12 03:32:27 52.1326 5.2913 42788 5456 0 37332 Netherlands
3198 3198       Saudi Arabia 2020-05-12 03:32:27 23.885942 45.079162 41014 255 12737 28022 Saudi Arabia
3026 3026     Quebec Canada 2020-05-12 03:32:27 52.9399 -73.5491 38480 3855 0 35466 Quebec, Canada
1887 1887 36059 Nassau New York US 2020-05-12 03:32:27 40.74066522 -73.58941873 38337 1973 0 36364 Nassau, New York, US
2514 2514 36103 Suffolk New York US 2020-05-12 03:32:27 40.88320119 -72.8012172 36911 1639 0 35272 Suffolk, New York, US
3163 3163       Mexico 2020-05-12 03:32:27 23.6345 -102.5528 36327 3573 23100 9654 Mexico
1575 1575 6037 Los Angeles California US 2020-05-12 03:32:27 34.30828379 -118.2282411 32263 1570 0 30693 Los Angeles, California, US
3180 3180       Pakistan 2020-05-12 03:32:27 30.3753 69.3451 32081 706 8555 22820 Pakistan
2851 2851 36119 Westchester New York US 2020-05-12 03:32:27 41.16278376 -73.75741653 31384 1227 0 30157 Westchester, New York, US
3214 3214       Switzerland 2020-05-12 03:32:27 46.8182 8.2275 30344 1845 26800 1699 Switzerland
3087 3087       Chile 2020-05-12 03:32:27 -35.6751 -71.543 30063 323 13605 16135 Chile
3103 3103       Ecuador 2020-05-12 03:32:27 -1.8312 -78.1834 29509 2145 3433 23931 Ecuador
3187 3187       Portugal 2020-05-12 03:32:27 39.3999 -8.2245 27679 1144 2549 23986 Portugal
3213 3213       Sweden 2020-05-12 03:32:27 60.128161 18.643501 26670 3256 4971 18443 Sweden
3068 3068       Belarus 2020-05-12 03:32:27 53.7098 27.9534 23906 135 6531 17240 Belarus
3203 3203       Singapore 2020-05-12 03:32:27 1.2833 103.8333 23822 21 3225 20576 Singapore
3188 3188       Qatar 2020-05-12 03:32:27 25.3548 51.1839 23623 14 2840 20769 Qatar
3134 3134       Ireland 2020-05-12 03:32:27 53.1424 -7.6921 23135 1467 17110 4558 Ireland
3022 3022     Ontario Canada 2020-05-12 03:32:27 51.2538 -85.3232 21817 1788 0 20029 Ontario, Canada
3227 3227       United Arab Emirates 2020-05-12 03:32:27 23.424076 53.847818 18878 201 5381 13296 United Arab Emirates
2085 2085 42101 Philadelphia Pennsylvania US 2020-05-12 03:32:27 40.00338507 -75.1379271 18313 893 0 17420 Philadelphia, Pennsylvania, US
2825 2825 26163 Wayne Michigan US 2020-05-12 03:32:27 42.28098405 -83.281255 18194 2105 0 16089 Wayne, Michigan, US
1210 1210 34017 Hudson New Jersey US 2020-05-12 03:32:27 40.73766234 -74.07515667 17808 996 0 16805 Hudson, New Jersey, US
1765 1765 25017 Middlesex Massachusetts US 2020-05-12 03:32:27 42.48607732 -71.39049229 17774 1235 0 16539 Middlesex, Massachusetts, US
176 176 34003 Bergen New Jersey US 2020-05-12 03:32:27 40.96010917 -74.07164325 17045 1358 0 15670 Bergen, New Jersey, US
3135 3135       Israel 2020-05-12 03:32:27 31.046051 34.851612 16427 260 11940 4405 Israel
3186 3186       Poland 2020-05-12 03:32:27 51.9194 19.1451 16326 811 5816 9699 Poland
3062 3062       Austria 2020-05-12 03:32:27 47.5162 14.5501 15882 620 14061 1201 Austria
3138 3138       Japan 2020-05-12 03:32:27 36.204824 138.252924 15847 633 8293 6921 Japan
819 819 34013 Essex New Jersey US 2020-05-12 03:32:27 40.78681335 -74.24657979 15733 1431 0 14296 Essex, New Jersey, US
3066 3066       Bangladesh 2020-05-12 03:32:27 23.685 90.3563 15691 239 2902 12550 Bangladesh
3226 3226       Ukraine 2020-05-12 03:32:27 48.3794 31.1656 15648 408 3288 11952 Ukraine
3189 3189       Romania 2020-05-12 03:32:27 45.9432 24.9668 15588 982 7245 7361 Romania
2513 2513 25025 Suffolk Massachusetts US 2020-05-12 03:32:27 42.3279514 -71.07850442 15356 731 0 14625 Suffolk, Massachusetts, US
2046 2046 34031 Passaic New Jersey US 2020-05-12 03:32:27 41.03238628 -74.29954144 14646 747 0 13898 Passaic, New Jersey, US
3131 3131       Indonesia 2020-05-12 03:32:27 -0.7893 113.9213 14265 991 2881 10393 Indonesia
1762 1762 12086 Miami-Dade Florida US 2020-05-12 03:32:27 25.6112362 -80.55170587 14167 490 0 13677 Miami-Dade, Florida, US
2697 2697 34039 Union New Jersey US 2020-05-12 03:32:27 40.65835409 -74.30680092 14167 875 0 13289 Union, New Jersey, US
1766 1766 34023 Middlesex New Jersey US 2020-05-12 03:32:27 40.43629879 -74.41426991 14042 794 0 13242 Middlesex, New Jersey, US
830 830 9001 Fairfield Connecticut US 2020-05-12 03:32:27 41.26809896 -73.3881171 13312 1034 0 12278 Fairfield, Connecticut, US
2276 2276 36087 Rockland New York US 2020-05-12 03:32:27 41.15027894 -74.02560498 12484 576 0 11908 Rockland, New York, US
3088 3088       Colombia 2020-05-12 03:32:27 4.5709 -74.2973 11613 479 2825 8309 Colombia
818 818 25009 Essex Massachusetts US 2020-05-12 03:32:27 42.6687626 -70.94687179 11432 669 0 10763 Essex, Massachusetts, US
3185 3185       Philippines 2020-05-12 03:32:27 12.879721 121.774017 11086 726 1999 8361 Philippines
3142 3142       Korea, South 2020-05-12 03:32:27 35.90775700000001 127.766922 10936 258 9670 1008 Korea, South
3207 3207       South Africa 2020-05-12 03:32:27 -30.5595 22.9375 10652 206 4357 6089 South Africa
3102 3102       Dominican Republic 2020-05-12 03:32:27 18.7357 -70.1627 10634 393 2870 7371 Dominican Republic
3098 3098       Denmark 2020-05-12 03:32:27 56.2639 9.5018 10513 533 8328 1652 Denmark
3200 3200       Serbia 2020-05-12 03:32:27 44.0165 21.0059 10176 218 3290 6668 Serbia
3104 3104       Egypt 2020-05-12 03:32:27 26.820553000000004 30.802498 9746 533 2172 7041 Egypt
2175 2175 24033 Prince George's Maryland US 2020-05-12 03:32:27 38.83070039 -76.8496441 9687 359 0 9328 Prince George's, Maryland, US
1982 1982 36071 Orange New York US 2020-05-12 03:32:27 41.40337468 -74.30240757 9584 388 0 9196 Orange, New York, US
3144 3144       Kuwait 2020-05-12 03:32:27 29.31166 47.481766 9286 65 2907 6314 Kuwait
1903 1903 9009 New Haven Connecticut US 2020-05-12 03:32:27 41.4080325 -72.93620426 9260 716 0 8544 New Haven, Connecticut, US
2178 2178 44007 Providence Rhode Island US 2020-05-12 03:32:27 41.87064746 -71.57753536 8674 0 0 8674 Providence, Rhode Island, US
3181 3181       Panama 2020-05-12 03:32:27 8.538 -80.7821 8616 249 4687 3680 Panama
1116 1116 48201 Harris Texas US 2020-05-12 03:32:27 29.86 -95.39 8176 179 0 7997 Harris, Texas, US
3097 3097       Czechia 2020-05-12 03:32:27 49.8175 15.473 8176 282 4711 3183 Czechia
3178 3178       Norway 2020-05-12 03:32:27 60.472 8.4689 8132 224 32 7876 Norway
2923 2923 25027 Worcester Massachusetts US 2020-05-12 03:32:27 42.35026951 -71.90493363 7818 457 0 7361 Worcester, Massachusetts, US
1947 1947 26125 Oakland Michigan US 2020-05-12 03:32:27 42.66090111 -83.38595416 7752 849 0 6903 Oakland, Michigan, US
1949 1949 34029 Ocean New Jersey US 2020-05-12 03:32:27 39.8895449 -74.28089251 7569 547 0 7022 Ocean, New Jersey, US
1651 1651 18097 Marion Indiana US 2020-05-12 03:32:27 39.78163624 -86.13826325 7510 423 0 7087 Marion, Indiana, US
1128 1128 9003 Hartford Connecticut US 2020-05-12 03:32:27 41.80283011 -72.73103891 7358 921 0 6437 Hartford, Connecticut, US
1382 1382 53033 King Washington US 2020-05-12 03:32:27 47.49137892 -121.8346131 7068 516 0 6562 King, Washington, US
1931 1931 25021 Norfolk Massachusetts US 2020-05-12 03:32:27 42.16073095 -71.20530408 7004 661 0 6343 Norfolk, Massachusetts, US
1798 1798 34025 Monmouth New Jersey US 2020-05-12 03:32:27 40.26549699 -74.22240686 6989 445 0 6543 Monmouth, New Jersey, US
1830 1830 24031 Montgomery Maryland US 2020-05-12 03:32:27 39.13676329 -77.20358245 6909 388 0 6521 Montgomery, Maryland, US
1298 1298 22051 Jefferson Louisiana US 2020-05-12 03:32:27 29.74075478 -90.11115756 6755 402 0 6353 Jefferson, Louisiana, US
3157 3157       Malaysia 2020-05-12 03:32:27 4.210483999999999 101.975766 6726 109 5113 1504 Malaysia
1989 1989 22071 Orleans Louisiana US 2020-05-12 03:32:27 30.06971951 -89.92660315 6693 470 0 6223 Orleans, Louisiana, US
2128 2128 25023 Plymouth Massachusetts US 2020-05-12 03:32:27 41.94070556 -70.80802823 6457 408 0 6049 Plymouth, Massachusetts, US
734 734 11001 District of Columbia District of Columbia US 2020-05-12 03:32:27 38.90417773 -77.01655992 6389 328 0 6061 District of Columbia, District of Columbia, US
2963 2963     Alberta Canada 2020-05-12 03:32:27 53.9333 -116.5765 6300 117 0 6183 Alberta, Canada
3168 3168       Morocco 2020-05-12 03:32:27 31.7917 -7.0926 6281 188 2811 3282 Morocco
3060 3060       Argentina 2020-05-12 03:32:27 -38.4161 -63.6167 6278 314 1837 4127 Argentina
828 828 51059 Fairfax Virginia US 2020-05-12 03:32:27 38.83677558 -77.27565836 6200 243 0 5957 Fairfax, Virginia, US
666 666 48113 Dallas Texas US 2020-05-12 03:32:27 32.76670599 -96.7779605 6123 173 0 5978 Dallas, Texas, US
1601 1601 26099 Macomb Michigan US 2020-05-12 03:32:27 42.69158356 -82.92752801 6064 699 0 5365 Macomb, Michigan, US
1642 1642 4013 Maricopa Arizona US 2020-05-12 03:32:27 33.34835867 -112.4918154 5988 250 0 5738 Maricopa, Arizona, US
3112 3112       Finland 2020-05-12 03:32:27 61.92411 25.748151 5984 271 4000 1713 Finland
3056 3056       Algeria 2020-05-12 03:32:27 28.0339 1.6596 5891 507 2841 2543 Algeria
259 259 12011 Broward Florida US 2020-05-12 03:32:27 26.15184651 -80.48725556 5882 258 0 5624 Broward, Florida, US
1860 1860 34027 Morris New Jersey US 2020-05-12 03:32:27 40.86095313 -74.54553709999998 5876 518 0 5358 Morris, New Jersey, US
1749 1749 34021 Mercer New Jersey US 2020-05-12 03:32:27 40.28047017 -74.70479631 5394 340 0 5053 Mercer, New Jersey, US

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

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