05-01-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,190 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
3163 3163       Spain 2020-05-02 02:32:27 40.463667 -3.74922 213435 24543 112050 76842 Spain
3090 3090       Italy 2020-05-02 02:32:27 41.87194 12.56738 207428 28236 78249 100943 Italy
3182 3182       United Kingdom 2020-05-02 02:32:27 55.3781 -3.4360000000000004 177454 27510 0 149944 United Kingdom
1877 1877 36061 New York City New York US 2020-05-02 02:32:27 40.76727260000001 -73.97152637 169690 18399 0 151291 New York City, New York, US
3067 3067       France 2020-05-02 02:32:27 46.2276 2.2137 167846 24563 50212 90958 France
3071 3071       Germany 2020-05-02 02:32:27 51.165690999999995 10.451526 164077 6736 126900 30441 Germany
3178 3178       Turkey 2020-05-02 02:32:27 38.9637 35.2433 122392 3258 53808 65326 Turkey
3144 3144       Russia 2020-05-02 02:32:27 61.52401 105.31875600000001 114431 1169 13220 100042 Russia
3086 3086       Iran 2020-05-02 02:32:27 32.427908 53.68804599999999 95646 6091 76318 13237 Iran
3030 3030       Brazil 2020-05-02 02:32:27 -14.235 -51.9253 92202 6412 38039 47751 Brazil
2953 2953     Hubei China 2020-05-02 02:32:27 30.9756 112.2707 68128 4512 63616 0 Hubei, China
3023 3023       Belgium 2020-05-02 02:32:27 50.8333 4.469936 49032 7703 11892 29437 Belgium
3138 3138       Peru 2020-05-02 02:32:27 -9.19 -75.0152 40459 1124 11129 28206 Peru
3126 3126       Netherlands 2020-05-02 02:32:27 52.1326 5.2913 39791 4893 0 34898 Netherlands
576 576 17031 Cook Illinois US 2020-05-02 02:32:27 41.84144849 -87.81658794 38668 1673 0 36995 Cook, Illinois, US
3084 3084       India 2020-05-02 02:32:27 20.593684 78.96288 37257 1223 10007 26027 India
1857 1857 36059 Nassau New York US 2020-05-02 02:32:27 40.74066522 -73.58941873 36161 1720 0 34441 Nassau, New York, US
2476 2476 36103 Suffolk New York US 2020-05-02 02:32:27 40.88320119 -72.8012172 34037 1203 0 32834 Suffolk, New York, US
3168 3168       Switzerland 2020-05-02 02:32:27 46.8182 8.2275 29705 1754 23900 4051 Switzerland
2807 2807 36119 Westchester New York US 2020-05-02 02:32:27 41.16278376 -73.75741653 29232 1049 0 28183 Westchester, New York, US
2980 2980     Quebec Canada 2020-05-02 02:32:27 52.9399 -73.5491 28656 2866 0 26634 Quebec, Canada
3057 3057       Ecuador 2020-05-02 02:32:27 -1.8312 -78.1834 26336 1063 1913 23360 Ecuador
3141 3141       Portugal 2020-05-02 02:32:27 39.3999 -8.2245 25351 1007 1647 22697 Portugal
1547 1547 6037 Los Angeles California US 2020-05-02 02:32:27 34.30828379 -118.22824109999999 24262 1174 0 23088 Los Angeles, California, US
3152 3152       Saudi Arabia 2020-05-02 02:32:27 23.885942 45.079162 24097 169 3555 20373 Saudi Arabia
3167 3167       Sweden 2020-05-02 02:32:27 60.128161 18.643501 21520 2653 1005 17862 Sweden
3088 3088       Ireland 2020-05-02 02:32:27 53.1424 -7.6921 20833 1265 13386 6182 Ireland
3117 3117       Mexico 2020-05-02 02:32:27 23.6345 -102.5528 20739 1972 12377 6390 Mexico
3134 3134       Pakistan 2020-05-02 02:32:27 30.3753 69.3451 18114 417 4715 12982 Pakistan
2976 2976     Ontario Canada 2020-05-02 02:32:27 51.2538 -85.3232 17880 1265 0 16615 Ontario, Canada
3157 3157       Singapore 2020-05-02 02:32:27 1.2833 103.8333 17101 16 1268 15817 Singapore
3041 3041       Chile 2020-05-02 02:32:27 -35.6751 -71.543 17008 234 9018 7756 Chile
2781 2781 26163 Wayne Michigan US 2020-05-02 02:32:27 42.28098405 -83.281255 16970 1802 0 15168 Wayne, Michigan, US
3089 3089       Israel 2020-05-02 02:32:27 31.046051000000002 34.851612 16012 229 9393 6720 Israel
172 172 34003 Bergen New Jersey US 2020-05-02 02:32:27 40.96010917 -74.07164325 15832 1187 0 14643 Bergen, New Jersey, US
3016 3016       Austria 2020-05-02 02:32:27 47.5162 14.5501 15531 589 13110 1832 Austria
1187 1187 34017 Hudson New Jersey US 2020-05-02 02:32:27 40.73766234 -74.07515667 15149 819 0 14329 Hudson, New Jersey, US
2053 2053 42101 Philadelphia Pennsylvania US 2020-05-02 02:32:27 40.00338507 -75.1379271 15137 638 0 14499 Philadelphia, Pennsylvania, US
3022 3022       Belarus 2020-05-02 02:32:27 53.7098 27.9534 14917 93 2918 11906 Belarus
1736 1736 25017 Middlesex Massachusetts US 2020-05-02 02:32:27 42.48607732 -71.39049229 14607 885 0 13722 Middlesex, Massachusetts, US
3092 3092       Japan 2020-05-02 02:32:27 36.204824 138.252924 14305 455 2975 10875 Japan
3142 3142       Qatar 2020-05-02 02:32:27 25.3548 51.1839 14096 12 1436 12648 Qatar
804 804 34013 Essex New Jersey US 2020-05-02 02:32:27 40.78681335 -74.24657979 13995 1240 0 12754 Essex, New Jersey, US
2475 2475 25025 Suffolk Massachusetts US 2020-05-02 02:32:27 42.327951399999996 -71.07850442 13295 550 0 12745 Suffolk, Massachusetts, US
3140 3140       Poland 2020-05-02 02:32:27 51.9194 19.1451 13105 651 3491 8963 Poland
3181 3181       United Arab Emirates 2020-05-02 02:32:27 23.424076 53.847818000000004 13038 111 2543 10384 United Arab Emirates
2014 2014 34031 Passaic New Jersey US 2020-05-02 02:32:27 41.03238628 -74.29954144 12814 599 0 12215 Passaic, New Jersey, US
2653 2653 34039 Union New Jersey US 2020-05-02 02:32:27 40.65835409 -74.30680092 12779 714 0 12065 Union, New Jersey, US
3143 3143       Romania 2020-05-02 02:32:27 45.9432 24.9668 12567 744 4328 7495 Romania
1733 1733 12086 Miami-Dade Florida US 2020-05-02 02:32:27 25.6112362 -80.55170587 12389 358 0 12031 Miami-Dade, Florida, US
1737 1737 34023 Middlesex New Jersey US 2020-05-02 02:32:27 40.43629879 -74.41426991 11949 591 0 11356 Middlesex, New Jersey, US
2239 2239 36087 Rockland New York US 2020-05-02 02:32:27 41.15027894 -74.02560498 11812 519 0 11293 Rockland, New York, US
815 815 9001 Fairfield Connecticut US 2020-05-02 02:32:27 41.26809896 -73.3881171 11612 839 0 10773 Fairfield, Connecticut, US
3180 3180       Ukraine 2020-05-02 02:32:27 48.3794 31.1656 10861 272 1413 9176 Ukraine
3096 3096       Korea, South 2020-05-02 02:32:27 35.90775700000001 127.766922 10780 250 9123 1407 Korea, South
3085 3085       Indonesia 2020-05-02 02:32:27 -0.7893 113.9213 10551 800 1591 8160 Indonesia
3052 3052       Denmark 2020-05-02 02:32:27 56.2639 9.5018 9311 460 6729 2122 Denmark
803 803 25009 Essex Massachusetts US 2020-05-02 02:32:27 42.6687626 -70.94687179 9028 460 0 8568 Essex, Massachusetts, US
3154 3154       Serbia 2020-05-02 02:32:27 44.0165 21.0059 9009 179 1343 7487 Serbia
3139 3139       Philippines 2020-05-02 02:32:27 12.879721 121.77401699999999 8772 579 1084 7109 Philippines
1952 1952 36071 Orange New York US 2020-05-02 02:32:27 41.40337468 -74.30240757 8751 329 0 8422 Orange, New York, US
3020 3020       Bangladesh 2020-05-02 02:32:27 23.685 90.3563 8238 170 174 7894 Bangladesh
1873 1873 9009 New Haven Connecticut US 2020-05-02 02:32:27 41.408032500000004 -72.93620426 7900 533 0 7367 New Haven, Connecticut, US
3132 3132       Norway 2020-05-02 02:32:27 60.472 8.4689 7783 210 32 7541 Norway
3051 3051       Czechia 2020-05-02 02:32:27 49.8175 15.472999999999999 7737 240 3372 4125 Czechia
1917 1917 26125 Oakland Michigan US 2020-05-02 02:32:27 42.66090111 -83.38595416 7423 705 0 6718 Oakland, Michigan, US
3056 3056       Dominican Republic 2020-05-02 02:32:27 18.7357 -70.1627 7288 313 1387 5588 Dominican Republic
3042 3042       Colombia 2020-05-02 02:32:27 4.5709 -74.2973 7006 314 1551 5141 Colombia
2140 2140 24033 Prince George's Maryland US 2020-05-02 02:32:27 38.83070039 -76.8496441 6735 243 0 6492 Prince George's, Maryland, US
3135 3135       Panama 2020-05-02 02:32:27 8.538 -80.7821 6720 192 622 5906 Panama
2143 2143 44007 Providence Rhode Island US 2020-05-02 02:32:27 41.87064746 -71.57753536 6579 0 0 6579 Providence, Rhode Island, US
1095 1095 48201 Harris Texas US 2020-05-02 02:32:27 29.86 -95.39 6551 122 0 6429 Harris, Texas, US
1919 1919 34029 Ocean New Jersey US 2020-05-02 02:32:27 39.8895449 -74.28089251 6505 420 0 6085 Ocean, New Jersey, US
1959 1959 22071 Orleans Louisiana US 2020-05-02 02:32:27 30.06971951 -89.92660315 6495 437 0 6058 Orleans, Louisiana, US
1275 1275 22051 Jefferson Louisiana US 2020-05-02 02:32:27 29.74075478 -90.11115756 6305 368 0 5937 Jefferson, Louisiana, US
1357 1357 53033 King Washington US 2020-05-02 02:32:27 47.49137892 -121.8346131 6274 465 0 5822 King, Washington, US
1769 1769 34025 Monmouth New Jersey US 2020-05-02 02:32:27 40.26549699 -74.22240686 6132 355 0 5777 Monmouth, New Jersey, US
3111 3111       Malaysia 2020-05-02 02:32:27 4.210483999999999 101.97576600000001 6071 103 4210 1758 Malaysia
1901 1901 25021 Norfolk Massachusetts US 2020-05-02 02:32:27 42.16073095 -71.20530408 6065 522 0 5543 Norfolk, Massachusetts, US
3161 3161       South Africa 2020-05-02 02:32:27 -30.5595 22.9375 5951 116 2382 3453 South Africa
1107 1107 9003 Hartford Connecticut US 2020-05-02 02:32:27 41.80283011 -72.73103891 5931 715 0 5216 Hartford, Connecticut, US
3058 3058       Egypt 2020-05-02 02:32:27 26.820553000000004 30.802497999999996 5895 406 1460 4029 Egypt
2879 2879 25027 Worcester Massachusetts US 2020-05-02 02:32:27 42.35026951 -71.90493363 5787 278 0 5509 Worcester, Massachusetts, US
1623 1623 18097 Marion Indiana US 2020-05-02 02:32:27 39.78163624 -86.13826325 5754 339 0 5415 Marion, Indiana, US
1573 1573 26099 Macomb Michigan US 2020-05-02 02:32:27 42.69158356 -82.92752801 5623 614 0 5009 Macomb, Michigan, US
2917 2917     Alberta Canada 2020-05-02 02:32:27 53.9333 -116.5765 5573 92 0 5481 Alberta, Canada
1830 1830 34027 Morris New Jersey US 2020-05-02 02:32:27 40.86095313 -74.54553709999998 5354 430 0 4924 Morris, New Jersey, US
2095 2095 25023 Plymouth Massachusetts US 2020-05-02 02:32:27 41.94070556 -70.80802823 5259 301 0 4958 Plymouth, Massachusetts, US
252 252 12011 Broward Florida US 2020-05-02 02:32:27 26.15184651 -80.48725556 5144 199 0 4945 Broward, Florida, US
3066 3066       Finland 2020-05-02 02:32:27 61.92411 25.748151 5051 218 3000 1833 Finland
1800 1800 24031 Montgomery Maryland US 2020-05-02 02:32:27 39.13676329 -77.20358245 4754 262 0 4492 Montgomery, Maryland, US
720 720 11001 District of Columbia District of Columbia US 2020-05-02 02:32:27 38.90417773 -77.01655992 4658 231 0 4427 District of Columbia, District of Columbia, US
3122 3122       Morocco 2020-05-02 02:32:27 31.7917 -7.0926 4569 171 1083 3315 Morocco
3014 3014       Argentina 2020-05-02 02:32:27 -38.4161 -63.6167 4532 225 1292 3015 Argentina
1806 1806 42091 Montgomery Pennsylvania US 2020-05-02 02:32:27 40.21053671 -75.36652296 4406 362 0 4044 Montgomery, Pennsylvania, US
3098 3098       Kuwait 2020-05-02 02:32:27 29.311659999999996 47.481766 4377 30 1602 2745 Kuwait
1614 1614 4013 Maricopa Arizona US 2020-05-02 02:32:27 33.34835867 -112.49181540000001 4156 147 0 4009 Maricopa, Arizona, US
3010 3010       Algeria 2020-05-02 02:32:27 28.0339 1.6596 4154 453 1821 1880 Algeria
482 482 32003 Clark Nevada US 2020-05-02 02:32:27 36.21458855 -115.0130241 4118 206 0 3912 Clark, Nevada, US
2220 2220 6065 Riverside California US 2020-05-02 02:32:27 33.74314981 -115.9933578 4079 156 0 3923 Riverside, California, US

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

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