04-21-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,093 rows sorted by Deaths 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
2994 2994       Italy 2020-04-21 23:30:30 41.87194 12.56738 183957 24648 51600 107709 Italy
3067 3067       Spain 2020-04-21 23:30:30 40.463667 -3.7492199999999998 204178 21282 82514 100382 Spain
2971 2971       France 2020-04-21 23:30:30 46.2276 2.2137 156950 20767 39181 98073 France
3085 3085       United Kingdom 2020-04-21 23:30:30 55.3781 -3.4360000000000004 129044 17337 0 111707 United Kingdom
1819 1819 36061 New York City New York US 2020-04-21 23:30:50 40.76727260000001 -73.97152637 144190 14887 0 129303 New York City, New York, US
2928 2928       Belgium 2020-04-21 23:30:30 50.8333 4.469936 40956 5998 9002 25956 Belgium
2990 2990       Iran 2020-04-21 23:30:30 32.427908 53.68804599999999 84802 5297 60965 18540 Iran
2975 2975       Germany 2020-04-21 23:30:30 51.165690999999995 10.451526 148291 5033 95200 48058 Germany
2858 2858     Hubei China 2020-04-21 01:02:30 30.9756 112.2707 68128 4512 63514 102 Hubei, China
3030 3030       Netherlands 2020-04-21 23:30:30 52.1326 5.2913 34134 3916 0 30218 Netherlands
2935 2935       Brazil 2020-04-21 23:30:30 -14.235 -51.9253 43079 2741 22991 17347 Brazil
3081 3081       Turkey 2020-04-21 23:30:30 38.9637 35.2433 95591 2259 14918 78414 Turkey
3071 3071       Sweden 2020-04-21 23:30:30 60.128161 18.643501 15322 1765 550 13007 Sweden
2885 2885     Quebec Canada 2020-04-21 23:38:53 52.9399 -73.5491 20126 1618 0 19082 Quebec, Canada
3072 3072       Switzerland 2020-04-21 23:30:30 46.8182 8.2275 28063 1478 19400 7185 Switzerland
1800 1800 36059 Nassau New York US 2020-04-21 23:30:50 40.74066522 -73.58941873 31079 1390 0 29689 Nassau, New York, US
2690 2690 26163 Wayne Michigan US 2020-04-21 23:30:50 42.28098405 -83.281255 13912 1148 0 12764 Wayne, Michigan, US
563 563 17031 Cook Illinois US 2020-04-21 23:30:50 41.84144849 -87.81658794 23181 1002 0 22179 Cook, Illinois, US
2396 2396 36103 Suffolk New York US 2020-04-21 23:30:50 40.88320119 -72.8012172 28701 888 0 27813 Suffolk, New York, US
2715 2715 36119 Westchester New York US 2020-04-21 23:30:50 41.16278376 -73.75741653 24656 809 0 23847 Westchester, New York, US
171 171 34003 Bergen New Jersey US 2020-04-21 23:30:50 40.96010917 -74.07164325 13356 787 0 12569 Bergen, New Jersey, US
3045 3045       Portugal 2020-04-21 23:30:30 39.3999 -8.2245 21379 762 917 19700 Portugal
783 783 34013 Essex New Jersey US 2020-04-21 23:30:50 40.78681335 -74.24657979 11128 751 0 10377 Essex, New Jersey, US
2992 2992       Ireland 2020-04-21 23:30:30 53.1424 -7.6921 16040 730 9233 6077 Ireland
3021 3021       Mexico 2020-04-21 23:30:30 23.6345 -102.5528 8772 712 2627 5433 Mexico
2881 2881     Ontario Canada 2020-04-21 23:38:53 51.2538 -85.3232 12715 694 0 12021 Ontario, Canada
1498 1498 6037 Los Angeles California US 2020-04-21 23:30:50 34.30828379 -118.2282411 15153 663 0 14490 Los Angeles, California, US
2988 2988       India 2020-04-21 23:30:30 20.593684 78.96288 20080 645 3975 15460 India
1147 1147 34017 Hudson New Jersey US 2020-04-21 23:30:50 40.73766234 -74.07515667 11221 636 0 10585 Hudson, New Jersey, US
2989 2989       Indonesia 2020-04-21 23:30:30 -0.7893 113.9213 7135 616 842 5677 Indonesia
793 793 9001 Fairfield Connecticut US 2020-04-21 23:30:50 41.26809896 -73.3881171 8472 544 0 7928 Fairfield, Connecticut, US
2961 2961       Ecuador 2020-04-21 23:30:30 -1.8312 -78.1834 10398 520 1207 8671 Ecuador
1857 1857 26125 Oakland Michigan US 2020-04-21 23:30:50 42.66090111 -83.38595416 6306 506 0 5800 Oakland, Michigan, US
3047 3047       Romania 2020-04-21 23:30:30 45.9432 24.9668 9242 498 2153 6591 Romania
2921 2921       Austria 2020-04-21 23:30:30 47.5162 14.5501 14873 491 10971 3411 Austria
3042 3042       Peru 2020-04-21 23:30:30 -9.19 -75.0152 17837 484 6982 10371 Peru
3048 3048       Russia 2020-04-21 23:30:30 61.52401 105.31875600000001 52763 456 3873 48434 Russia
1524 1524 26099 Macomb Michigan US 2020-04-21 23:30:50 42.69158356 -82.92752801 4544 445 0 4099 Macomb, Michigan, US
3043 3043       Philippines 2020-04-21 23:30:30 12.879721 121.77401699999999 6599 437 654 5508 Philippines
1682 1682 25017 Middlesex Massachusetts US 2020-04-21 23:30:50 42.48607732 -71.39049229 9621 428 0 9193 Middlesex, Massachusetts, US
1069 1069 9003 Hartford Connecticut US 2020-04-21 23:30:50 41.80283011 -72.73103891 3951 402 0 3549 Hartford, Connecticut, US
2168 2168 36087 Rockland New York US 2020-04-21 23:30:50 41.15027894 -74.02560498 9568 401 0 9167 Rockland, New York, US
3044 3044       Poland 2020-04-21 23:30:30 51.9194 19.1451 9856 401 1297 8158 Poland
1313 1313 53033 King Washington US 2020-04-21 23:30:50 47.49137892 -121.8346131 5293 400 0 4933 King, Washington, US
1988 1988 42101 Philadelphia Pennsylvania US 2020-04-21 23:30:50 40.00338507 -75.1379271 10028 394 0 9634 Philadelphia, Pennsylvania, US
2915 2915       Algeria 2020-04-21 23:30:30 28.0339 1.6596 2811 392 1152 1267 Algeria
2570 2570 34039 Union New Jersey US 2020-04-21 23:30:50 40.65835409 -74.30680092 9972 387 0 9585 Union, New Jersey, US
2956 2956       Denmark 2020-04-21 23:30:30 56.2639 9.5018 7695 370 4700 2625 Denmark
1683 1683 34023 Middlesex New Jersey US 2020-04-21 23:30:50 40.43629879 -74.41426991 8346 345 0 8001 Middlesex, New Jersey, US
1898 1898 22071 Orleans Louisiana US 2020-04-21 23:30:50 30.06971951 -89.92660315 6169 344 0 5825 Orleans, Louisiana, US
1815 1815 9009 New Haven Connecticut US 2020-04-21 23:30:50 41.4080325 -72.93620426 5493 322 0 5171 New Haven, Connecticut, US
1842 1842 25021 Norfolk Massachusetts US 2020-04-21 23:30:50 42.16073095 -71.20530408 4062 290 0 3772 Norfolk, Massachusetts, US
1234 1234 22051 Jefferson Louisiana US 2020-04-21 23:30:50 29.74075478 -90.11115756 5802 288 0 5514 Jefferson, Louisiana, US
2395 2395 25025 Suffolk Massachusetts US 2020-04-21 23:30:50 42.3279514 -71.07850442 8669 285 0 8384 Suffolk, Massachusetts, US
1773 1773 34027 Morris New Jersey US 2020-04-21 23:30:50 40.86095313 -74.54553709999998 4236 269 0 3967 Morris, New Jersey, US
2962 2962       Egypt 2020-04-21 23:30:30 26.820553000000004 30.802497999999996 3490 264 870 2356 Egypt
1951 1951 34031 Passaic New Jersey US 2020-04-21 23:30:50 41.03238628 -74.29954144 8479 263 0 8216 Passaic, New Jersey, US
2996 2996       Japan 2020-04-21 23:30:30 36.204824 138.252924 11135 263 1239 9633 Japan
782 782 25009 Essex Massachusetts US 2020-04-21 23:30:50 42.6687626 -70.94687179 5521 245 0 5276 Essex, Massachusetts, US
2960 2960       Dominican Republic 2020-04-21 23:30:30 18.7357 -70.1627 5044 245 463 4336 Dominican Republic
1026 1026 25013 Hampden Massachusetts US 2020-04-21 23:30:50 42.13440424 -72.63235561 2533 244 0 2289 Hampden, Massachusetts, US
3000 3000       Korea, South 2020-04-21 23:30:30 35.90775700000001 127.766922 10683 237 8213 2233 Korea, South
1679 1679 12086 Miami-Dade Florida US 2020-04-21 23:30:50 25.6112362 -80.55170587 10056 233 0 9823 Miami-Dade, Florida, US
2542 2542 90034 Unassigned New Jersey US 2020-04-21 23:30:50     3073 233 0 2840 Unassigned, New Jersey, US
1891 1891 36071 Orange New York US 2020-04-21 23:30:50 41.40337468 -74.30240757 7029 231 0 6798 Orange, New York, US
1713 1713 34025 Monmouth New Jersey US 2020-04-21 23:30:50 40.26549699 -74.22240686 4787 230 0 4557 Monmouth, New Jersey, US
1749 1749 42091 Montgomery Pennsylvania US 2020-04-21 23:30:50 40.21053671 -75.36652296 3154 223 0 2931 Montgomery, Pennsylvania, US
1859 1859 34029 Ocean New Jersey US 2020-04-21 23:30:50 39.8895449 -74.28089251 4868 222 0 4646 Ocean, New Jersey, US
2986 2986       Hungary 2020-04-21 23:30:30 47.1625 19.5033 2098 213 287 1598 Hungary
1573 1573 18097 Marion Indiana US 2020-04-21 23:30:50 39.78163624 -86.13826325 4176 206 0 3970 Marion, Indiana, US
2955 2955       Czechia 2020-04-21 23:30:30 49.8175 15.472999999999999 7033 201 1753 5079 Czechia
3038 3038       Pakistan 2020-04-21 23:30:30 30.3753 69.3451 9565 201 2073 7291 Pakistan
2947 2947       Colombia 2020-04-21 23:30:30 4.5709 -74.2973 4149 196 804 3149 Colombia
2993 2993       Israel 2020-04-21 23:30:30 31.046051000000002 34.851612 14394 189 5103 9251 Israel
3036 3036       Norway 2020-04-21 23:30:30 60.472 8.4689 7191 182 32 6977 Norway
2320 2320 34035 Somerset New Jersey US 2020-04-21 23:30:50 40.56465737 -74.61683016 2488 170 0 2318 Somerset, New Jersey, US
777 777 36029 Erie New York US 2020-04-21 23:30:50 42.76249024 -78.73063652 2284 162 0 2122 Erie, New York, US
3083 3083       Ukraine 2020-04-21 23:30:30 48.3794 31.1656 6125 161 367 5597 Ukraine
2526 2526 90018 Unassigned Indiana US 2020-04-21 23:30:50     0 155 0 0 Unassigned, Indiana, US
2919 2919       Argentina 2020-04-21 23:30:30 -38.4161 -63.6167 3031 147 840 2044 Argentina
2946 2946       Chile 2020-04-21 23:30:30 -35.6751 -71.543 10832 147 4969 5716 Chile
3026 3026       Morocco 2020-04-21 23:30:30 31.7917 -7.0926 3209 145 393 2671 Morocco
471 471 32003 Clark Nevada US 2020-04-21 23:30:50 36.21458855 -115.0130241 3099 141 0 2958 Clark, Nevada, US
2030 2030 25023 Plymouth Massachusetts US 2020-04-21 23:30:50 41.94070556 -70.80802823 3043 141 0 2902 Plymouth, Massachusetts, US
2970 2970       Finland 2020-04-21 23:30:30 61.92411 25.748151 4014 141 2000 1873 Finland
2555 2555 90051 Unassigned Virginia US 2020-04-21 23:30:50     0 140 0 -140 Unassigned, Virginia, US
1694 1694 55079 Milwaukee Wisconsin US 2020-04-21 23:30:50 43.00486062 -87.96733172 2234 139 0 2095 Milwaukee, Wisconsin, US
3039 3039       Panama 2020-04-21 23:30:30 8.538 -80.7821 4658 136 204 4318 Panama
2785 2785 25027 Worcester Massachusetts US 2020-04-21 23:30:50 42.35026951 -71.90493363 3341 133 0 3208 Worcester, Massachusetts, US
906 906 26049 Genesee Michigan US 2020-04-21 23:30:50 43.02244215 -83.70589709 1298 131 0 1167 Genesee, Michigan, US
1938 1938 12099 Palm Beach Florida US 2020-04-21 23:30:50 26.64676272 -80.46536002 2320 131 0 2189 Palm Beach, Florida, US
249 249 12011 Broward Florida US 2020-04-21 23:30:50 26.15184651 -80.48725556 4168 126 0 4042 Broward, Florida, US
3058 3058       Serbia 2020-04-21 23:30:30 44.0165 21.0059 6630 125 870 5635 Serbia
1667 1667 34021 Mercer New Jersey US 2020-04-21 23:30:50 40.28047017 -74.70479631 2591 122 0 2469 Mercer, New Jersey, US
2977 2977       Greece 2020-04-21 23:30:30 39.0742 21.8243 2401 121 577 1703 Greece
2532 2532 90024 Unassigned Maryland US 2020-04-21 23:38:51     0 120 0 -120 Unassigned, Maryland, US
682 682 42045 Delaware Pennsylvania US 2020-04-21 23:30:50 39.91680171 -75.40243663 2654 118 0 2536 Delaware, Pennsylvania, US
2073 2073 24033 Prince George's Maryland US 2020-04-21 23:38:51 38.83070039 -76.8496441 3734 118 0 3616 Prince George's, Maryland, US
265 265 42017 Bucks Pennsylvania US 2020-04-21 23:30:50 40.33682119 -75.10836643 1977 116 0 1861 Bucks, Pennsylvania, US
1743 1743 24031 Montgomery Maryland US 2020-04-21 23:38:51 39.13676329 -77.20358245 2768 116 0 2652 Montgomery, Maryland, US

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

CREATE TABLE [04-21-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
);