04-19-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,074 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
2975 2975       Italy 2020-04-19 23:40:41 41.87194 12.56738 178972 23660 47055 108257 Italy
3048 3048       Spain 2020-04-19 23:40:41 40.463667 -3.74922 198674 20453 77357 100864 Spain
2952 2952       France 2020-04-19 23:40:41 46.2276 2.2137 151838 19692 36578 96598 France
3066 3066       United Kingdom 2020-04-19 23:40:41 55.3781 -3.436 120067 16060 0 104007 United Kingdom
1804 1804 36061 New York City New York US 2020-04-19 23:41:01 40.7672726 -73.97152637 138700 14451 0 124249 New York City, New York, US
2909 2909       Belgium 2020-04-19 23:40:41 50.8333 4.469936 38496 5683 8757 24056 Belgium
2971 2971       Iran 2020-04-19 23:40:41 32.427908 53.688046 82211 5118 57023 20070 Iran
2956 2956       Germany 2020-04-19 23:40:41 51.165691 10.451526 145184 4586 88000 52598 Germany
2839 2839     Hubei China 2020-04-19 01:34:48 30.9756 112.2707 68128 4512 63507 109 Hubei, China
3011 3011       Netherlands 2020-04-19 23:40:41 52.1326 5.2913 32655 3684 250 28721 Netherlands
2916 2916       Brazil 2020-04-19 23:40:41 -14.235 -51.9253 38654 2462 22130 14062 Brazil
3062 3062       Turkey 2020-04-19 23:40:41 38.9637 35.2433 86306 2017 11976 72313 Turkey
3052 3052       Sweden 2020-04-19 23:40:41 60.128161 18.643501 14385 1540 550 12295 Sweden
2866 2866     Quebec Canada 2020-04-19 23:48:49 52.9399 -73.5491 17950 1400 0 17130 Quebec, Canada
3053 3053       Switzerland 2020-04-19 23:40:41 46.8182 8.2275 27740 1393 17800 8547 Switzerland
2672 2672 26163 Wayne Michigan US 2020-04-19 23:41:01 42.28098405 -83.281255 13692 1119 0 12573 Wayne, Michigan, US
1785 1785 36059 Nassau New York US 2020-04-19 23:41:01 40.74066522 -73.58941873 30013 1109 0 28904 Nassau, New York, US
558 558 17031 Cook Illinois US 2020-04-19 23:41:01 41.84144849 -87.81658794 21272 877 0 20395 Cook, Illinois, US
170 170 34003 Bergen New Jersey US 2020-04-19 23:41:01 40.96010917 -74.07164325 12639 767 0 11872 Bergen, New Jersey, US
776 776 34013 Essex New Jersey US 2020-04-19 23:41:01 40.78681335 -74.24657979 10304 740 0 9564 Essex, New Jersey, US
3026 3026       Portugal 2020-04-19 23:40:41 39.3999 -8.2245 20206 714 610 18882 Portugal
2379 2379 36103 Suffolk New York US 2020-04-19 23:41:01 40.88320119 -72.8012172 26888 693 0 26195 Suffolk, New York, US
2697 2697 36119 Westchester New York US 2020-04-19 23:41:01 41.16278376 -73.75741653 23803 668 0 23135 Westchester, New York, US
3002 3002       Mexico 2020-04-19 23:40:41 23.6345 -102.5528 7497 650 2627 4220 Mexico
1138 1138 34017 Hudson New Jersey US 2020-04-19 23:41:01 40.73766234 -74.07515667 10486 612 0 9874 Hudson, New Jersey, US
2973 2973       Ireland 2020-04-19 23:40:41 53.1424 -7.6921 15251 610 77 14564 Ireland
1487 1487 6037 Los Angeles California US 2020-04-19 23:41:01 34.30828379 -118.2282411 12341 600 0 11741 Los Angeles, California, US
2862 2862     Ontario Canada 2020-04-19 23:48:49 51.2538 -85.3232 11561 591 0 10970 Ontario, Canada
2970 2970       Indonesia 2020-04-19 23:40:41 -0.7893 113.9213 6575 582 686 5307 Indonesia
2969 2969       India 2020-04-19 23:40:41 20.593684 78.96288 17615 559 2854 14202 India
2942 2942       Ecuador 2020-04-19 23:40:41 -1.8312 -78.1834 9468 474 1061 7933 Ecuador
1842 1842 26125 Oakland Michigan US 2020-04-19 23:41:01 42.66090111 -83.38595416 6109 471 0 5638 Oakland, Michigan, US
2902 2902       Austria 2020-04-19 23:40:41 47.5162 14.5501 14749 452 10501 3796 Austria
3028 3028       Romania 2020-04-19 23:40:41 45.9432 24.9668 8746 451 1892 6403 Romania
786 786 9001 Fairfield Connecticut US 2020-04-19 23:41:01 41.26809896 -73.3881171 7434 447 0 6987 Fairfield, Connecticut, US
3024 3024       Philippines 2020-04-19 23:40:41 12.879721 121.774017 6259 409 572 5278 Philippines
2526 2526 90036 Unassigned New York US 2020-04-19 23:41:01     0 401 0 -401 Unassigned, New York, US
3023 3023       Peru 2020-04-19 23:40:41 -9.19 -75.0152 15628 400 6811 8417 Peru
1513 1513 26099 Macomb Michigan US 2020-04-19 23:41:01 42.69158356 -82.92752801 4360 391 0 3969 Macomb, Michigan, US
1303 1303 53033 King Washington US 2020-04-19 23:41:01 47.49137892 -121.8346131 5174 380 0 4828 King, Washington, US
2896 2896       Algeria 2020-04-19 23:40:41 28.0339 1.6596 2629 375 1047 1207 Algeria
1667 1667 25017 Middlesex Massachusetts US 2020-04-19 23:41:01 42.48607732 -71.39049229 8737 372 0 8365 Middlesex, Massachusetts, US
2552 2552 34039 Union New Jersey US 2020-04-19 23:41:01 40.65835409 -74.30680092 9609 372 0 9237 Union, New Jersey, US
1972 1972 42101 Philadelphia Pennsylvania US 2020-04-19 23:41:01 40.00338507 -75.1379271 9214 365 0 8849 Philadelphia, Pennsylvania, US
3029 3029       Russia 2020-04-19 23:40:41 61.52401 105.318756 42853 361 3291 39201 Russia
3025 3025       Poland 2020-04-19 23:40:41 51.9194 19.1451 9287 360 1040 7887 Poland
2937 2937       Denmark 2020-04-19 23:40:41 56.2639 9.5018 7384 355 4141 2888 Denmark
2152 2152 36087 Rockland New York US 2020-04-19 23:41:01 41.15027894 -74.02560498 9364 334 0 9030 Rockland, New York, US
1668 1668 34023 Middlesex New Jersey US 2020-04-19 23:41:01 40.43629879 -74.41426991 8017 329 0 7688 Middlesex, New Jersey, US
1883 1883 22071 Orleans Louisiana US 2020-04-19 23:41:01 30.06971951 -89.92660315 6000 329 0 5671 Orleans, Louisiana, US
1061 1061 9003 Hartford Connecticut US 2020-04-19 23:41:01 41.80283011 -72.73103891 3351 295 0 3056 Hartford, Connecticut, US
1224 1224 22051 Jefferson Louisiana US 2020-04-19 23:41:01 29.74075478 -90.11115756 5592 282 0 5310 Jefferson, Louisiana, US
1758 1758 34027 Morris New Jersey US 2020-04-19 23:41:01 40.86095313 -74.5455371 4136 257 0 3879 Morris, New Jersey, US
1800 1800 9009 New Haven Connecticut US 2020-04-19 23:41:01 41.4080325 -72.93620426 4871 257 0 4614 New Haven, Connecticut, US
1936 1936 34031 Passaic New Jersey US 2020-04-19 23:41:01 41.03238628 -74.29954144 8288 250 0 8038 Passaic, New Jersey, US
1827 1827 25021 Norfolk Massachusetts US 2020-04-19 23:41:01 42.16073095 -71.20530408 3789 244 0 3545 Norfolk, Massachusetts, US
2943 2943       Egypt 2020-04-19 23:40:41 26.820553 30.802498 3144 239 732 2173 Egypt
2378 2378 25025 Suffolk Massachusetts US 2020-04-19 23:41:01 42.3279514 -71.07850442 8074 236 0 7838 Suffolk, Massachusetts, US
2977 2977       Japan 2020-04-19 23:40:41 36.204824 138.252924 10797 236 1159 9402 Japan
2981 2981       Korea, South 2020-04-19 23:40:41 35.907757 127.766922 10661 234 8042 2385 Korea, South
1698 1698 34025 Monmouth New Jersey US 2020-04-19 23:41:01 40.26549699 -74.22240686 4669 226 0 4443 Monmouth, New Jersey, US
2941 2941       Dominican Republic 2020-04-19 23:40:41 18.7357 -70.1627 4680 226 363 4091 Dominican Republic
1844 1844 34029 Ocean New Jersey US 2020-04-19 23:41:01 39.8895449 -74.28089251 4648 217 0 4431 Ocean, New Jersey, US
1019 1019 25013 Hampden Massachusetts US 2020-04-19 23:41:01 42.13440424 -72.63235561 2337 211 0 2126 Hampden, Massachusetts, US
1876 1876 36071 Orange New York US 2020-04-19 23:41:01 41.40337468 -74.30240757 6514 211 0 6303 Orange, New York, US
775 775 25009 Essex Massachusetts US 2020-04-19 23:41:01 42.6687626 -70.94687179 5153 209 0 4944 Essex, Massachusetts, US
1664 1664 12086 Miami-Dade Florida US 2020-04-19 23:41:01 25.6112362 -80.55170587 9354 207 0 9147 Miami-Dade, Florida, US
1562 1562 18097 Marion Indiana US 2020-04-19 23:41:01 39.78163624 -86.13826325 3889 192 0 3697 Marion, Indiana, US
2967 2967       Hungary 2020-04-19 23:40:41 47.1625 19.5033 1916 189 250 1477 Hungary
2936 2936       Czechia 2020-04-19 23:40:41 49.8175 15.473 6746 186 1298 5262 Czechia
2928 2928       Colombia 2020-04-19 23:40:41 4.5709 -74.2973 3792 179 711 2902 Colombia
2974 2974       Israel 2020-04-19 23:40:41 31.046051 34.851612 13813 174 4228 9565 Israel
3019 3019       Pakistan 2020-04-19 23:40:41 30.3753 69.3451 8348 168 1868 6312 Pakistan
3017 3017       Norway 2020-04-19 23:40:41 60.472 8.4689 7078 165 32 6881 Norway
1734 1734 42091 Montgomery Pennsylvania US 2020-04-19 23:41:01 40.21053671 -75.36652296 2913 164 0 2749 Montgomery, Pennsylvania, US
2303 2303 34035 Somerset New Jersey US 2020-04-19 23:41:01 40.56465737 -74.61683016 2384 158 0 2226 Somerset, New Jersey, US
3007 3007       Morocco 2020-04-19 23:40:41 31.7917 -7.0926 2855 141 327 2387 Morocco
3064 3064       Ukraine 2020-04-19 23:40:41 48.3794 31.1656 5449 141 347 4961 Ukraine
2509 2509 90018 Unassigned Indiana US 2020-04-19 23:41:01     0 140 0 0 Unassigned, Indiana, US
466 466 32003 Clark Nevada US 2020-04-19 23:41:01 36.21458855 -115.0130241 2940 137 0 2803 Clark, Nevada, US
770 770 36029 Erie New York US 2020-04-19 23:41:01 42.76249024 -78.73063652 2192 135 0 2057 Erie, New York, US
2927 2927       Chile 2020-04-19 23:40:41 -35.6751 -71.543 10088 133 4338 5617 Chile
2900 2900       Argentina 2020-04-19 23:40:41 -38.4161 -63.6167 2839 132 709 1998 Argentina
2014 2014 25023 Plymouth Massachusetts US 2020-04-19 23:41:01 41.94070556 -70.80802823 2832 131 0 2701 Plymouth, Massachusetts, US
1679 1679 55079 Milwaukee Wisconsin US 2020-04-19 23:41:01 43.00486062 -87.96733172 2150 125 0 2025 Milwaukee, Wisconsin, US
3039 3039       Serbia 2020-04-19 23:40:41 44.0165 21.0059 6318 122 753 5443 Serbia
1923 1923 12099 Palm Beach Florida US 2020-04-19 23:41:01 26.64676272 -80.46536002 2170 121 0 2049 Palm Beach, Florida, US
3020 3020       Panama 2020-04-19 23:40:41 8.538 -80.7821 4273 120 140 4013 Panama
248 248 12011 Broward Florida US 2020-04-19 23:41:01 26.15184651 -80.48725556 3971 115 0 3856 Broward, Florida, US
899 899 26049 Genesee Michigan US 2020-04-19 23:41:01 43.02244215 -83.70589709 1240 115 0 1125 Genesee, Michigan, US
2766 2766 25027 Worcester Massachusetts US 2020-04-19 23:41:01 42.35026951 -71.90493363 3069 114 0 2955 Worcester, Massachusetts, US
1652 1652 34021 Mercer New Jersey US 2020-04-19 23:41:01 40.28047017 -74.70479631 2395 113 0 2282 Mercer, New Jersey, US
2537 2537 90051 Unassigned Virginia US 2020-04-19 23:41:01     0 113 0 -113 Unassigned, Virginia, US
2958 2958       Greece 2020-04-19 23:40:41 39.0742 21.8243 2235 113 269 1853 Greece
2057 2057 24033 Prince George's Maryland US 2020-04-19 23:41:01 38.83070039 -76.8496441 3345 105 0 3240 Prince George's, Maryland, US
2725 2725 17197 Will Illinois US 2020-04-19 23:41:01 41.44619267 -87.97862712 1643 101 0 1542 Will, Illinois, US
2297 2297 53061 Snohomish Washington US 2020-04-19 23:41:01 48.04615983 -121.7170703 2143 99 0 2050 Snohomish, Washington, US
1368 1368 42071 Lancaster Pennsylvania US 2020-04-19 23:41:01 40.03904563 -76.24770128 1188 98 0 1090 Lancaster, Pennsylvania, US
3037 3037       Saudi Arabia 2020-04-19 23:40:41 23.885942 45.079162 9362 97 1398 7867 Saudi Arabia
697 697 11001 District of Columbia District of Columbia US 2020-04-19 23:41:01 38.90417773 -77.01655992 2793 96 0 2697 District of Columbia, District of Columbia, US

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

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