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 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
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
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
3076 3076       Brazil 2020-05-12 03:32:27 -14.235 -51.9253 169594 11653 67384 90557 Brazil
3136 3136       Italy 2020-05-12 03:32:27 41.87194 12.56738 219814 30739 106587 82488 Italy
3209 3209       Spain 2020-05-12 03:32:27 40.463667 -3.74922 227436 26744 137139 63553 Spain
589 589 17031 Cook Illinois US 2020-05-12 03:32:27 41.84144849 -87.81658794 53381 2361 0 51020 Cook, Illinois, US
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
3224 3224       Turkey 2020-05-12 03:32:27 38.9637 35.2433 139771 3841 95780 40150 Turkey
3172 3172       Netherlands 2020-05-12 03:32:27 52.1326 5.2913 42788 5456 0 37332 Netherlands
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
3026 3026     Quebec Canada 2020-05-12 03:32:27 52.9399 -73.5491 38480 3855 0 35466 Quebec, Canada
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
3069 3069       Belgium 2020-05-12 03:32:27 50.8333 4.469936 53449 8707 13697 31045 Belgium
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
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
3198 3198       Saudi Arabia 2020-05-12 03:32:27 23.885942 45.079162 41014 255 12737 28022 Saudi Arabia
3187 3187       Portugal 2020-05-12 03:32:27 39.3999 -8.2245 27679 1144 2549 23986 Portugal
3103 3103       Ecuador 2020-05-12 03:32:27 -1.8312 -78.1834 29509 2145 3433 23931 Ecuador
3180 3180       Pakistan 2020-05-12 03:32:27 30.3753 69.3451 32081 706 8555 22820 Pakistan
3188 3188       Qatar 2020-05-12 03:32:27 25.3548 51.1839 23623 14 2840 20769 Qatar
3203 3203       Singapore 2020-05-12 03:32:27 1.2833 103.8333 23822 21 3225 20576 Singapore
3022 3022     Ontario Canada 2020-05-12 03:32:27 51.2538 -85.3232 21817 1788 0 20029 Ontario, Canada
3117 3117       Germany 2020-05-12 03:32:27 51.165691 10.451526 172576 7661 145617 19298 Germany
3213 3213       Sweden 2020-05-12 03:32:27 60.128161 18.643501 26670 3256 4971 18443 Sweden
2085 2085 42101 Philadelphia Pennsylvania US 2020-05-12 03:32:27 40.00338507 -75.1379271 18313 893 0 17420 Philadelphia, Pennsylvania, US
3068 3068       Belarus 2020-05-12 03:32:27 53.7098 27.9534 23906 135 6531 17240 Belarus
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
3087 3087       Chile 2020-05-12 03:32:27 -35.6751 -71.543 30063 323 13605 16135 Chile
2825 2825 26163 Wayne Michigan US 2020-05-12 03:32:27 42.28098405 -83.281255 18194 2105 0 16089 Wayne, Michigan, 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
3132 3132       Iran 2020-05-12 03:32:27 32.427908 53.68804599999999 109286 6685 87422 15179 Iran
2513 2513 25025 Suffolk Massachusetts US 2020-05-12 03:32:27 42.3279514 -71.07850442 15356 731 0 14625 Suffolk, Massachusetts, US
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
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
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
3227 3227       United Arab Emirates 2020-05-12 03:32:27 23.424076 53.847818 18878 201 5381 13296 United Arab Emirates
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
3066 3066       Bangladesh 2020-05-12 03:32:27 23.685 90.3563 15691 239 2902 12550 Bangladesh
830 830 9001 Fairfield Connecticut US 2020-05-12 03:32:27 41.26809896 -73.3881171 13312 1034 0 12278 Fairfield, Connecticut, US
3226 3226       Ukraine 2020-05-12 03:32:27 48.3794 31.1656 15648 408 3288 11952 Ukraine
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
818 818 25009 Essex Massachusetts US 2020-05-12 03:32:27 42.6687626 -70.94687179 11432 669 0 10763 Essex, Massachusetts, US
3131 3131       Indonesia 2020-05-12 03:32:27 -0.7893 113.9213 14265 991 2881 10393 Indonesia
3186 3186       Poland 2020-05-12 03:32:27 51.9194 19.1451 16326 811 5816 9699 Poland
3163 3163       Mexico 2020-05-12 03:32:27 23.6345 -102.5528 36327 3573 23100 9654 Mexico
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
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
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
3185 3185       Philippines 2020-05-12 03:32:27 12.879721 121.774017 11086 726 1999 8361 Philippines
3088 3088       Colombia 2020-05-12 03:32:27 4.5709 -74.2973 11613 479 2825 8309 Colombia
1116 1116 48201 Harris Texas US 2020-05-12 03:32:27 29.86 -95.39 8176 179 0 7997 Harris, Texas, US
3178 3178       Norway 2020-05-12 03:32:27 60.472 8.4689 8132 224 32 7876 Norway
3102 3102       Dominican Republic 2020-05-12 03:32:27 18.7357 -70.1627 10634 393 2870 7371 Dominican Republic
2923 2923 25027 Worcester Massachusetts US 2020-05-12 03:32:27 42.35026951 -71.90493363 7818 457 0 7361 Worcester, Massachusetts, US
3189 3189       Romania 2020-05-12 03:32:27 45.9432 24.9668 15588 982 7245 7361 Romania
1651 1651 18097 Marion Indiana US 2020-05-12 03:32:27 39.78163624 -86.13826325 7510 423 0 7087 Marion, Indiana, US
3104 3104       Egypt 2020-05-12 03:32:27 26.820553000000004 30.802498 9746 533 2172 7041 Egypt
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
3138 3138       Japan 2020-05-12 03:32:27 36.204824 138.252924 15847 633 8293 6921 Japan
1947 1947 26125 Oakland Michigan US 2020-05-12 03:32:27 42.66090111 -83.38595416 7752 849 0 6903 Oakland, Michigan, US
3200 3200       Serbia 2020-05-12 03:32:27 44.0165 21.0059 10176 218 3290 6668 Serbia
1382 1382 53033 King Washington US 2020-05-12 03:32:27 47.49137892 -121.8346131 7068 516 0 6562 King, Washington, 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
1128 1128 9003 Hartford Connecticut US 2020-05-12 03:32:27 41.80283011 -72.73103891 7358 921 0 6437 Hartford, Connecticut, US
1298 1298 22051 Jefferson Louisiana US 2020-05-12 03:32:27 29.74075478 -90.11115756 6755 402 0 6353 Jefferson, Louisiana, US
1931 1931 25021 Norfolk Massachusetts US 2020-05-12 03:32:27 42.16073095 -71.20530408 7004 661 0 6343 Norfolk, Massachusetts, US
3144 3144       Kuwait 2020-05-12 03:32:27 29.31166 47.481766 9286 65 2907 6314 Kuwait
1989 1989 22071 Orleans Louisiana US 2020-05-12 03:32:27 30.06971951 -89.92660315 6693 470 0 6223 Orleans, Louisiana, US
2963 2963     Alberta Canada 2020-05-12 03:32:27 53.9333 -116.5765 6300 117 0 6183 Alberta, Canada
3207 3207       South Africa 2020-05-12 03:32:27 -30.5595 22.9375 10652 206 4357 6089 South Africa
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
2128 2128 25023 Plymouth Massachusetts US 2020-05-12 03:32:27 41.94070556 -70.80802823 6457 408 0 6049 Plymouth, Massachusetts, US
666 666 48113 Dallas Texas US 2020-05-12 03:32:27 32.76670599 -96.7779605 6123 173 0 5978 Dallas, Texas, US
828 828 51059 Fairfax Virginia US 2020-05-12 03:32:27 38.83677558 -77.27565836 6200 243 0 5957 Fairfax, Virginia, US
1642 1642 4013 Maricopa Arizona US 2020-05-12 03:32:27 33.34835867 -112.4918154 5988 250 0 5738 Maricopa, Arizona, US
259 259 12011 Broward Florida US 2020-05-12 03:32:27 26.15184651 -80.48725556 5882 258 0 5624 Broward, Florida, US
1601 1601 26099 Macomb Michigan US 2020-05-12 03:32:27 42.69158356 -82.92752801 6064 699 0 5365 Macomb, Michigan, 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
1434 1434 17097 Lake Illinois US 2020-05-12 03:32:27 42.3224907 -88.00367925 5323 173 0 5150 Lake, Illinois, 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
2257 2257 6065 Riverside California US 2020-05-12 03:32:27 33.74314981 -115.9933578 5189 217 0 4972 Riverside, California, US
2319 2319 6073 San Diego California US 2020-05-12 03:32:27 33.03484597 -116.7365326 5065 175 0 4890 San Diego, California, US
1836 1836 42091 Montgomery Pennsylvania US 2020-05-12 03:32:27 40.21053671 -75.36652296 5292 525 0 4767 Montgomery, Pennsylvania, US
337 337 34007 Camden New Jersey US 2020-05-12 03:32:27 39.80343818 -74.96388753 4962 227 0 4732 Camden, New Jersey, US
249 249 25005 Bristol Massachusetts US 2020-05-12 03:32:27 41.79228404 -71.10872211 4999 274 0 4725 Bristol, Massachusetts, US
713 713 42045 Delaware Pennsylvania US 2020-05-12 03:32:27 39.91680171 -75.40243663 5046 399 0 4647 Delaware, Pennsylvania, US
3134 3134       Ireland 2020-05-12 03:32:27 53.1424 -7.6921 23135 1467 17110 4558 Ireland
491 491 32003 Clark Nevada US 2020-05-12 03:32:27 36.21458855 -115.0130241 4762 260 0 4502 Clark, Nevada, US
762 762 17043 DuPage Illinois US 2020-05-12 03:32:27 41.85116968 -88.08642662 4745 251 0 4494 DuPage, Illinois, US
3135 3135       Israel 2020-05-12 03:32:27 31.046051 34.851612 16427 260 11940 4405 Israel
1080 1080 25013 Hampden Massachusetts US 2020-05-12 03:32:27 42.13440424 -72.63235561 4763 458 0 4305 Hampden, Massachusetts, US
3118 3118       Ghana 2020-05-12 03:32:27 7.9465 -1.0232 4700 22 494 4184 Ghana
3060 3060       Argentina 2020-05-12 03:32:27 -38.4161 -63.6167 6278 314 1837 4127 Argentina

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