04-17-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,047 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
3021 3021       Spain 2020-04-17 23:30:32 40.463667 -3.7492199999999998 190839 20002 74797 96040 Spain
2948 2948       Italy 2020-04-17 23:30:32 41.87194 12.56738 172434 22745 42727 106962 Italy
2925 2925       France 2020-04-17 23:30:32 46.2276 2.2137 146942 18662 34420 94868 France
2929 2929       Germany 2020-04-17 23:30:32 51.165690999999995 10.451526 141397 4352 83114 53931 Germany
1787 1787 36061 New York City New York US 2020-04-17 23:30:52 40.76727260000001 -73.97152637 127352 13202 0 114150 New York City, New York, US
3039 3039       United Kingdom 2020-04-17 23:30:32 55.3781 -3.4360000000000004 108692 14576 0 94116 United Kingdom
2944 2944       Iran 2020-04-17 23:30:32 32.427908 53.68804599999999 79494 4958 54064 20472 Iran
3035 3035       Turkey 2020-04-17 23:30:32 38.9637 35.2433 78546 1769 8631 68146 Turkey
2812 2812     Hubei China 2020-04-17 05:08:48 30.9756 112.2707 68128 4512 63487 129 Hubei, China
2882 2882       Belgium 2020-04-17 23:30:32 50.8333 4.469936 36138 5163 7961 23014 Belgium
2889 2889       Brazil 2020-04-17 23:30:32 -14.235 -51.9253 33682 2141 14026 17515 Brazil
3002 3002       Russia 2020-04-17 23:30:32 61.52401 105.31875600000001 32008 273 2590 29145 Russia
2984 2984       Netherlands 2020-04-17 23:30:32 52.1326 5.2913 30449 3459 250 26740 Netherlands
1769 1769 36059 Nassau New York US 2020-04-17 23:30:52 40.74066522 -73.58941873 28539 1109 0 27430 Nassau, New York, US
3026 3026       Switzerland 2020-04-17 23:30:32 46.8182 8.2275 27078 1327 16400 9351 Switzerland
2357 2357 36103 Suffolk New York US 2020-04-17 23:30:52 40.88320119 -72.8012172 25035 693 0 24342 Suffolk, New York, US
2672 2672 36119 Westchester New York US 2020-04-17 23:30:52 41.16278376 -73.75741653 22476 668 0 21808 Westchester, New York, US
553 553 17031 Cook Illinois US 2020-04-17 23:30:52 41.84144849 -87.81658794 19391 760 0 18631 Cook, Illinois, US
2999 2999       Portugal 2020-04-17 23:30:32 39.3999 -8.2245 19022 657 519 17846 Portugal
2839 2839     Quebec Canada 2020-04-17 23:38:31 52.9399 -73.5491 16798 1176 0 16110 Quebec, Canada
2875 2875       Austria 2020-04-17 23:30:32 47.5162 14.5501 14595 431 9704 4460 Austria
2942 2942       India 2020-04-17 23:30:32 20.593684 78.96288 14352 486 2041 11825 India
2946 2946       Ireland 2020-04-17 23:30:32 53.1424 -7.6921 13980 530 77 13373 Ireland
2996 2996       Peru 2020-04-17 23:30:32 -9.19 -75.0152 13489 300 6541 6648 Peru
2947 2947       Israel 2020-04-17 23:30:32 31.046051000000002 34.851612 13246 155 3550 9705 Israel
2647 2647 26163 Wayne Michigan US 2020-04-17 23:30:52 42.28098405 -83.281255 13233 1044 0 12189 Wayne, Michigan, US
3025 3025       Sweden 2020-04-17 23:30:32 60.128161 18.643501 13216 1400 550 11266 Sweden
169 169 34003 Bergen New Jersey US 2020-04-17 23:30:52 40.96010917 -74.07164325 11863 714 0 11149 Bergen, New Jersey, US
1471 1471 6037 Los Angeles California US 2020-04-17 23:30:52 34.30828379 -118.22824109999999 11400 497 0 10903 Los Angeles, California, US
2954 2954       Korea, South 2020-04-17 23:30:32 35.90775700000001 127.766922 10635 230 7829 2576 Korea, South
2835 2835     Ontario Canada 2020-04-17 23:38:31 51.2538 -85.3232 10456 524 0 9932 Ontario, Canada
2950 2950       Japan 2020-04-17 23:30:32 36.204824 138.252924 9787 190 935 8662 Japan
770 770 34013 Essex New Jersey US 2020-04-17 23:30:52 40.78681335 -74.24657979 9672 684 0 8988 Essex, New Jersey, US
1123 1123 34017 Hudson New Jersey US 2020-04-17 23:30:52 40.73766234 -74.07515667 9636 420 0 9216 Hudson, New Jersey, US
2900 2900       Chile 2020-04-17 23:30:32 -35.6751 -71.543 9252 116 3621 5515 Chile
2132 2132 36087 Rockland New York US 2020-04-17 23:30:52 41.15027894 -74.02560498 8987 319 0 8668 Rockland, New York, US
1650 1650 12086 Miami-Dade Florida US 2020-04-17 23:30:52 25.6112362 -80.55170587 8824 195 0 8629 Miami-Dade, Florida, US
1954 1954 42101 Philadelphia Pennsylvania US 2020-04-17 23:30:52 40.00338507 -75.1379271 8563 298 0 8265 Philadelphia, Pennsylvania, US
2915 2915       Ecuador 2020-04-17 23:30:32 -1.8312 -78.1834 8450 421 838 7191 Ecuador
2527 2527 34039 Union New Jersey US 2020-04-17 23:30:52 40.65835409 -74.30680092 8429 330 0 8099 Union, New Jersey, US
2998 2998       Poland 2020-04-17 23:30:32 51.9194 19.1451 8379 332 866 7181 Poland
3001 3001       Romania 2020-04-17 23:30:32 45.9432 24.9668 8067 411 1508 6148 Romania
1653 1653 25017 Middlesex Massachusetts US 2020-04-17 23:30:52 42.48607732 -71.39049229 7744 258 0 7486 Middlesex, Massachusetts, US
1918 1918 34031 Passaic New Jersey US 2020-04-17 23:30:52 41.03238628 -74.29954144 7604 221 0 7383 Passaic, New Jersey, US
1654 1654 34023 Middlesex New Jersey US 2020-04-17 23:30:52 40.43629879 -74.41426991 7308 309 0 6999 Middlesex, New Jersey, US
2356 2356 25025 Suffolk Massachusetts US 2020-04-17 23:30:52 42.327951399999996 -71.07850442 7272 164 0 7108 Suffolk, Massachusetts, US
780 780 9001 Fairfield Connecticut US 2020-04-17 23:30:52 41.26809896 -73.3881171 7146 425 0 6721 Fairfield, Connecticut, US
3010 3010       Saudi Arabia 2020-04-17 23:30:32 23.885942 45.079162 7142 87 1049 6006 Saudi Arabia
2910 2910       Denmark 2020-04-17 23:30:32 56.2639 9.5018 7073 336 3389 3348 Denmark
2992 2992       Pakistan 2020-04-17 23:30:32 30.3753 69.3451 7025 135 1765 5125 Pakistan
2990 2990       Norway 2020-04-17 23:30:32 60.472 8.4689 6937 161 32 6744 Norway
2909 2909       Czechia 2020-04-17 23:30:32 49.8175 15.472999999999999 6549 173 1174 5202 Czechia
1859 1859 36071 Orange New York US 2020-04-17 23:30:52 41.40337468 -74.30240757 6514 204 0 6310 Orange, New York, US
3038 3038       United Arab Emirates 2020-04-17 23:30:32 23.424076 53.847818000000004 6302 37 1188 5077 United Arab Emirates
2975 2975       Mexico 2020-04-17 23:30:32 23.6345 -102.5528 6297 486 2125 3686 Mexico
2943 2943       Indonesia 2020-04-17 23:30:32 -0.7893 113.9213 5923 520 607 4796 Indonesia
1866 1866 22071 Orleans Louisiana US 2020-04-17 23:30:52 30.06971951 -89.92660315 5906 317 0 5589 Orleans, Louisiana, US
1825 1825 26125 Oakland Michigan US 2020-04-17 23:30:52 42.66090111 -83.38595416 5901 442 0 5459 Oakland, Michigan, US
2997 2997       Philippines 2020-04-17 23:30:32 12.879721 121.77401699999999 5878 387 487 5004 Philippines
3012 3012       Serbia 2020-04-17 23:30:32 44.0165 21.0059 5690 110 534 5046 Serbia
1209 1209 22051 Jefferson Louisiana US 2020-04-17 23:30:52 29.74075478 -90.11115756 5476 269 0 5207 Jefferson, Louisiana, US
2969 2969       Malaysia 2020-04-17 23:30:32 4.210483999999999 101.97576600000001 5251 86 2967 2198 Malaysia
3015 3015       Singapore 2020-04-17 23:30:32 1.2833 103.8333 5050 11 708 4331 Singapore
1288 1288 53033 King Washington US 2020-04-17 23:30:52 47.49137892 -121.8346131 4902 355 0 4571 King, Washington, US
2881 2881       Belarus 2020-04-17 23:30:32 53.7098 27.9534 4779 42 342 4395 Belarus
3000 3000       Qatar 2020-04-17 23:30:32 25.3548 51.1839 4663 7 464 4192 Qatar
3037 3037       Ukraine 2020-04-17 23:30:32 48.3794 31.1656 4662 125 246 4291 Ukraine
769 769 25009 Essex Massachusetts US 2020-04-17 23:30:52 42.6687626 -70.94687179 4584 159 0 4425 Essex, Massachusetts, US
1783 1783 9009 New Haven Connecticut US 2020-04-17 23:30:52 41.408032500000004 -72.93620426 4520 229 0 4291 New Haven, Connecticut, US
1037 1037 48201 Harris Texas US 2020-04-17 23:30:52 29.86 -95.39 4460 67 0 4393 Harris, Texas, US
1827 1827 34029 Ocean New Jersey US 2020-04-17 23:30:52 39.8895449 -74.28089251 4424 201 0 4223 Ocean, New Jersey, US
1684 1684 34025 Monmouth New Jersey US 2020-04-17 23:30:52 40.26549699 -74.22240686 4414 206 0 4208 Monmouth, New Jersey, US
1497 1497 26099 Macomb Michigan US 2020-04-17 23:30:52 42.69158356 -82.92752801 4145 373 0 3772 Macomb, Michigan, US
2914 2914       Dominican Republic 2020-04-17 23:30:32 18.7357 -70.1627 4126 200 268 3658 Dominican Republic
2993 2993       Panama 2020-04-17 23:30:32 8.538 -80.7821 4016 109 98 3809 Panama
1744 1744 34027 Morris New Jersey US 2020-04-17 23:30:52 40.86095313 -74.54553709999998 3822 232 0 3590 Morris, New Jersey, US
248 248 12011 Broward Florida US 2020-04-17 23:30:52 26.15184651 -80.48725556 3688 107 0 3581 Broward, Florida, US
1546 1546 18097 Marion Indiana US 2020-04-17 23:30:52 39.78163624 -86.13826325 3518 182 0 3336 Marion, Indiana, US
1810 1810 25021 Norfolk Massachusetts US 2020-04-17 23:30:52 42.16073095 -71.20530408 3499 173 0 3326 Norfolk, Massachusetts, US
2924 2924       Finland 2020-04-17 23:30:32 61.92411 25.748151 3489 82 1700 1707 Finland
2965 2965       Luxembourg 2020-04-17 23:30:32 49.8153 6.1296 3480 72 579 2829 Luxembourg
2901 2901       Colombia 2020-04-17 23:30:32 4.5709 -74.2973 3439 153 634 2652 Colombia
1049 1049 9003 Hartford Connecticut US 2020-04-17 23:30:52 41.80283011 -72.73103891 3015 266 0 2749 Hartford, Connecticut, US
2038 2038 24033 Prince George's Maryland US 2020-04-17 23:30:52 38.83070039 -76.8496441 2966 77 0 2889 Prince George's, Maryland, US
2827 2827     New South Wales Australia 2020-04-17 23:38:48 -33.8688 151.2093 2926 26 1379 1521 New South Wales, Australia
2916 2916       Egypt 2020-04-17 23:30:32 26.820553000000004 30.802497999999996 2844 205 646 1993 Egypt
3019 3019       South Africa 2020-04-17 23:30:32 -30.5595 22.9375 2783 50 903 1830 South Africa
2740 2740 25027 Worcester Massachusetts US 2020-04-17 23:30:52 42.35026951 -71.90493363 2765 84 0 2681 Worcester, Massachusetts, US
462 462 32003 Clark Nevada US 2020-04-17 23:30:52 36.21458855 -115.0130241 2738 124 0 2614 Clark, Nevada, US
2041 2041 44007 Providence Rhode Island US 2020-04-17 23:30:52 41.87064746 -71.57753536 2703 3 0 2700 Providence, Rhode Island, US
3030 3030       Thailand 2020-04-17 23:30:32 15.870032 100.992541 2700 47 1689 964 Thailand
1720 1720 42091 Montgomery Pennsylvania US 2020-04-17 23:30:52 40.21053671 -75.36652296 2684 97 0 2587 Montgomery, Pennsylvania, US
2873 2873       Argentina 2020-04-17 23:30:32 -38.4161 -63.6167 2669 123 666 1880 Argentina
1995 1995 25023 Plymouth Massachusetts US 2020-04-17 23:30:52 41.94070556 -70.80802823 2577 93 0 2484 Plymouth, Massachusetts, US
2980 2980       Morocco 2020-04-17 23:30:32 31.7917 -7.0926 2564 135 281 2148 Morocco
691 691 11001 District of Columbia District of Columbia US 2020-04-17 23:30:52 38.90417773 -77.01655992 2476 86 0 2390 District of Columbia, District of Columbia, US
2113 2113 6065 Riverside California US 2020-04-17 23:30:52 33.74314981 -115.9933578 2457 69 0 2388 Riverside, California, US
2869 2869       Algeria 2020-04-17 23:30:32 28.0339 1.6596 2418 364 846 1208 Algeria
1537 1537 4013 Maricopa Arizona US 2020-04-17 23:30:52 33.34835867 -112.49181540000001 2404 69 0 2335 Maricopa, Arizona, US
2777 2777     Alberta Canada 2020-04-17 23:38:31 53.9333 -116.5765 2397 50 0 2347 Alberta, Canada

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

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