04-10-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

2,943 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
2916 2916       Spain 2020-04-10 22:53:48 40.463667 -3.7492199999999998 158273 16081 55668 86524 Spain
2843 2843       Italy 2020-04-10 22:53:48 41.87194 12.56738 147577 18849 30455 98273 Italy
2824 2824       Germany 2020-04-10 22:53:48 51.165690999999995 10.451526 122171 2767 53913 65491 Germany
1717 1717 36061 New York City New York US 2020-04-10 22:54:07 40.76727260000001 -73.97152637 92384 5820 0 0 New York City, New York, US
2820 2820 250     France 2020-04-10 22:53:48 46.2276 2.2137 89731 13181 24932 86740 ,,France
2934 2934       United Kingdom 2020-04-10 22:53:48 55.3781 -3.4360000000000004 73758 8958 344 64456 United Kingdom
2839 2839       Iran 2020-04-10 22:53:48 32.427908 53.68804599999999 68192 4232 35465 28495 Iran
2707 2707     Hubei China 2020-04-10 01:42:58 30.9756 112.2707 67803 3216 64236 351 Hubei, China
2930 2930       Turkey 2020-04-10 22:53:48 38.9637 35.2433 47029 1006 2423 43600 Turkey
2777 2777       Belgium 2020-04-10 22:53:48 50.8333 4.469936 26667 3019 5568 18080 Belgium
2921 2921       Switzerland 2020-04-10 22:53:48 46.8182 8.2275 24551 1002 11100 12449 Switzerland
2879 2879       Netherlands 2020-04-10 22:53:48 52.1326 5.2913 23097 2511 250 20336 Netherlands
1699 1699 36059 Nassau New York US 2020-04-10 22:54:07 40.74066522 -73.58941873 21512 723 0 0 Nassau, New York, US
2263 2263 36103 Suffolk New York US 2020-04-10 22:54:07 40.88320119 -72.8012172 20320 414 0 0 Suffolk, New York, US
2784 2784       Brazil 2020-04-10 22:53:48 -14.235 -51.9253 19638 1057 173 18408 Brazil
2569 2569 36119 Westchester New York US 2020-04-10 22:54:07 41.16278376 -73.75741653 18077 389 0 0 Westchester, New York, US
2894 2894       Portugal 2020-04-10 22:53:48 39.3999 -8.2245 15472 435 233 14804 Portugal
2770 2770       Austria 2020-04-10 22:53:48 47.5162 14.5501 13555 319 6064 7172 Austria
534 534 17031 Cook Illinois US 2020-04-10 22:54:07 41.84144849 -87.81658794 12472 399 0 0 Cook, Illinois, US
2897 2897       Russia 2020-04-10 22:53:48 61.52401 105.31875600000001 11917 94 795 11028 Russia
2734 2734     Quebec Canada 2020-04-10 23:01:26 52.9399 -73.5491 11677 551 0 0 Quebec, Canada
2842 2842       Israel 2020-04-10 22:53:48 31.046051000000002 34.851612 10607 97 1460 9130 Israel
2545 2545 26163 Wayne Michigan US 2020-04-10 22:54:07 42.278056 -83.37861099999998 10539 609 0 0 Wayne,Michigan,US
2849 2849       Korea, South 2020-04-10 22:53:48 35.90775700000001 127.766922 10450 208 7117 3125 Korea, South
2920 2920       Sweden 2020-04-10 22:53:48 60.128161 18.643501 9685 870 381 8434 Sweden
160 160 34003 Bergen New Jersey US 2020-04-10 22:54:07 40.96010917 -74.07164325 8928 390 0 0 Bergen, New Jersey, US
1416 1416 6037 Los Angeles California US 2020-04-10 22:54:07 34.30828379 -118.22824109999999 8443 242 0 0 Los Angeles, California, US
2841 2841       Ireland 2020-04-10 22:53:48 53.1424 -7.6921 8089 287 25 7777 Ireland
2837 2837       India 2020-04-10 22:53:48 20.593684 78.96288 7598 246 774 6578 India
2810 2810       Ecuador 2020-04-10 22:53:48 -1.8312 -78.1834 7161 297 368 6496 Ecuador
2046 2046 36087 Rockland New York US 2020-04-10 22:54:07 41.15027894 -74.02560498 7122 200 0 0 Rockland, New York, US
747 747 34013 Essex New Jersey US 2020-04-10 22:54:07 40.78681335 -74.24657979 6580 352 0 0 Essex, New Jersey, US
2795 2795       Chile 2020-04-10 22:53:48 -35.6751 -71.543 6501 65 1571 4865 Chile
1082 1082 34017 Hudson New Jersey US 2020-04-10 22:54:07 40.73766234 -74.07515667 6411 163 0 0 Hudson, New Jersey, US
2885 2885       Norway 2020-04-10 22:53:48 60.472 8.4689 6314 113 32 6169 Norway
2730 2730     Ontario Canada 2020-04-10 23:01:26 51.2538 -85.3232 6237 222 0 0 Ontario, Canada
1591 1591 12086 Miami-Dade Florida US 2020-04-10 22:54:07 25.6112362 -80.55170587 6119 74 0 0 Miami-Dade, Florida, US
2893 2893       Poland 2020-04-10 22:53:48 51.9194 19.1451 5955 181 318 5456 Poland
2891 2891       Peru 2020-04-10 22:53:48 -9.19 -75.0152 5897 169 1569 4159 Peru
2805 2805       Denmark 2020-04-10 22:53:48 56.2639 9.5018 5819 247 1773 3799 Denmark
2804 2804       Czechia 2020-04-10 22:53:48 49.8175 15.472999999999999 5732 119 346 5267 Czechia
2428 2428 34039 Union New Jersey US 2020-04-10 22:54:07 40.65835409 -74.30680092 5575 161 0 0 Union, New Jersey, US
2845 2845       Japan 2020-04-10 22:53:48 36.204824 138.252924 5530 99 685 4746 Japan
1879 1879 42101 Philadelphia Pennsylvania US 2020-04-10 22:54:07 40.00338507 -75.1379271 5521 110 0 0 Philadelphia, Pennsylvania, US
2896 2896       Romania 2020-04-10 22:53:48 45.9432 24.9668 5467 270 729 4468 Romania
1794 1794 22071 Orleans Louisiana US 2020-04-10 22:54:07 30.06971951 -89.92660315 5416 225 0 0 Orleans, Louisiana, US
756 756 9001 Fairfield Connecticut US 2020-04-10 22:54:07 41.26809896 -73.3881171 5180 203 0 0 Fairfield, Connecticut, US
1594 1594 34023 Middlesex New Jersey US 2020-04-10 22:54:07 40.43629879 -74.41426991 5060 168 0 0 Middlesex, New Jersey, US
1844 1844 34031 Passaic New Jersey US 2020-04-10 22:54:07 41.03238628 -74.29954144 5017 101 0 0 Passaic, New Jersey, US
2887 2887       Pakistan 2020-04-10 22:53:48 30.3753 69.3451 4695 66 727 3902 Pakistan
1166 1166 22051 Jefferson Louisiana US 2020-04-10 22:54:07 29.74075478 -90.11115756 4678 165 0 0 Jefferson, Louisiana, US
2262 2262 25025 Suffolk Massachusetts US 2020-04-10 22:54:07 42.327951399999996 -71.07850442 4534 48 0 0 Suffolk, Massachusetts, US
1787 1787 36071 Orange New York US 2020-04-10 22:54:07 41.40337468 -74.30240757 4532 115 0 0 Orange, New York, US
1753 1753 26125 Oakland Michigan US 2020-04-10 22:54:07 42.66090111 -83.38595416 4511 282 0 0 Oakland, Michigan, US
1593 1593 25017 Middlesex Massachusetts US 2020-04-10 22:54:07 42.48607732 -71.39049229 4447 80 0 0 Middlesex, Massachusetts, US
2864 2864       Malaysia 2020-04-10 22:53:48 4.210483999999999 101.97576600000001 4346 70 1830 2446 Malaysia
2892 2892       Philippines 2020-04-10 22:53:48 12.879721 121.77401699999999 4195 221 140 3834 Philippines
1242 1242 53033 King Washington US 2020-04-10 22:54:07 47.49137892 -121.8346131 4117 302 0 0 King, Washington, US
2905 2905       Saudi Arabia 2020-04-10 22:53:48 23.885942 45.079162 3651 47 685 2919 Saudi Arabia
2838 2838       Indonesia 2020-04-10 22:53:48 -0.7893 113.9213 3512 306 282 2924 Indonesia
1621 1621 34025 Monmouth New Jersey US 2020-04-10 22:54:07 40.26549699 -74.22240686 3496 107 0 0 Monmouth, New Jersey, US
2870 2870       Mexico 2020-04-10 22:53:48 23.6345 -102.5528 3441 194 633 2614 Mexico
2933 2933       United Arab Emirates 2020-04-10 22:53:48 23.424076 53.847818000000004 3360 16 418 2926 United Arab Emirates
1755 1755 34029 Ocean New Jersey US 2020-04-10 22:54:07 39.8895449 -74.28089251 3269 121 0 0 Ocean, New Jersey, US
1003 1003 48201 Harris Texas US 2020-04-10 22:54:07 29.86 -95.39 3261 40 0 0 Harris,Texas,US
2860 2860       Luxembourg 2020-04-10 22:53:48 49.8153 6.1296 3223 54 500 2669 Luxembourg
2907 2907       Serbia 2020-04-10 22:53:48 44.0165 21.0059 3105 71 0 3034 Serbia
1441 1441 26099 Macomb Michigan US 2020-04-10 22:54:07 42.69158356 -82.92752801 2973 197 0 0 Macomb, Michigan, US
2722 2722     New South Wales Australia 2020-04-10 23:01:43 -33.8688 151.2093 2822 22 4 2796 New South Wales, Australia
1676 1676 34027 Morris New Jersey US 2020-04-10 22:54:07 40.86095313 -74.54553709999998 2771 135 0 0 Morris, New Jersey, US
2819 2819       Finland 2020-04-10 22:53:48 61.92411 25.748151 2769 48 300 2421 Finland
2888 2888       Panama 2020-04-10 22:53:48 8.538 -80.7821 2752 66 16 2670 Panama
746 746 25009 Essex Massachusetts US 2020-04-10 22:54:07 42.6687626 -70.94687179 2670 50 0 0 Essex, Massachusetts, US
235 235 12011 Broward Florida US 2020-04-10 22:54:07 26.15184651 -80.48725556 2645 72 0 0 Broward, Florida, US
2809 2809       Dominican Republic 2020-04-10 22:53:48 18.7357 -70.1627 2620 126 98 2396 Dominican Republic
1489 1489 18097 Marion Indiana US 2020-04-10 22:54:07 39.78163624 -86.13826325 2600 107 0 0 Marion, Indiana, US
2895 2895       Qatar 2020-04-10 22:53:48 25.3548 51.1839 2512 6 227 2279 Qatar
2796 2796       Colombia 2020-04-10 22:53:48 4.5709 -74.2973 2473 80 197 2196 Colombia
2925 2925       Thailand 2020-04-10 22:53:48 15.870032 100.992541 2473 33 1013 1427 Thailand
1713 1713 9009 New Haven Connecticut US 2020-04-10 22:54:07 41.408032500000004 -72.93620426 2383 98 0 0 New Haven, Connecticut, US
1739 1739 25021 Norfolk Massachusetts US 2020-04-10 22:54:07 42.16073095 -71.20530408 2216 41 0 0 Norfolk, Massachusetts, US
2932 2932       Ukraine 2020-04-10 22:53:48 48.3794 31.1656 2203 69 61 2073 Ukraine
445 445 32003 Clark Nevada US 2020-04-10 22:54:07 36.21458855 -115.0130241 2144 75 0 0 Clark, Nevada, US
2910 2910       Singapore 2020-04-10 22:53:48 1.2833 103.8333 2108 7 492 1609 Singapore
2826 2826       Greece 2020-04-10 22:53:48 39.0742 21.8243 2011 92 269 1650 Greece
2914 2914       South Africa 2020-04-10 22:53:48 -30.5595 22.9375 2003 24 410 1569 South Africa
2776 2776       Belarus 2020-04-10 22:53:48 53.7098 27.9534 1981 19 169 1793 Belarus
2768 2768       Argentina 2020-04-10 22:53:48 -38.4161 -63.6167 1975 82 375 1518 Argentina
1656 1656 42091 Montgomery Pennsylvania US 2020-04-10 22:54:07 40.21053671 -75.36652296 1889 50 0 0 Montgomery, Pennsylvania, US
2184 2184 53061 Snohomish Washington US 2020-04-10 22:54:07 48.04615983 -121.7170703 1802 69 0 0 Snohomish, Washington, US
2811 2811       Egypt 2020-04-10 22:53:48 26.820553000000004 30.802497999999996 1794 135 384 1275 Egypt
2764 2764       Algeria 2020-04-10 22:53:48 28.0339 1.6596 1761 256 405 1100 Algeria
1481 1481 4013 Maricopa Arizona US 2020-04-10 22:54:07 33.34835867 -112.49181540000001 1741 39 0 0 Maricopa, Arizona, US
1958 1958 24033 Prince George's Maryland US 2020-04-10 22:54:07 38.83070039 -76.8496441 1716 42 0 0 Prince George's, Maryland, US
2635 2635 25027 Worcester Massachusetts US 2020-04-10 22:54:07 42.35026951 -71.90493363 1678 29 0 0 Worcester, Massachusetts, US
1917 1917 25023 Plymouth Massachusetts US 2020-04-10 22:54:07 41.94070556 -70.80802823 1677 33 0 0 Plymouth, Massachusetts, US
2836 2836       Iceland 2020-04-10 22:53:48 64.9631 -19.0208 1675 7 751 917 Iceland
667 667 11001 District of Columbia District of Columbia US 2020-04-10 22:54:07 38.90417773 -77.01655992 1660 38 0 0 District of Columbia,District of Columbia,US
2084 2084 6073 San Diego California US 2020-04-10 22:54:07 33.03484597 -116.73653259999999 1628 40 0 0 San Diego, California, US
1014 1014 9003 Hartford Connecticut US 2020-04-10 22:54:07 41.80283011 -72.73103891 1615 88 0 0 Hartford, Connecticut, US

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

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