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 Recovered 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
2707 2707     Hubei China 2020-04-10 01:42:58 30.9756 112.2707 67803 3216 64236 351 Hubei, China
2916 2916       Spain 2020-04-10 22:53:48 40.463667 -3.7492199999999998 158273 16081 55668 86524 Spain
2824 2824       Germany 2020-04-10 22:53:48 51.165690999999995 10.451526 122171 2767 53913 65491 Germany
2839 2839       Iran 2020-04-10 22:53:48 32.427908 53.68804599999999 68192 4232 35465 28495 Iran
2843 2843       Italy 2020-04-10 22:53:48 41.87194 12.56738 147577 18849 30455 98273 Italy
2737 2737     Recovered US 2020-04-10 22:54:07     0 0 28790 0 Recovered, US
2820 2820 250     France 2020-04-10 22:53:48 46.2276 2.2137 89731 13181 24932 86740 ,,France
2921 2921       Switzerland 2020-04-10 22:53:48 46.8182 8.2275 24551 1002 11100 12449 Switzerland
2849 2849       Korea, South 2020-04-10 22:53:48 35.90775700000001 127.766922 10450 208 7117 3125 Korea, South
2770 2770       Austria 2020-04-10 22:53:48 47.5162 14.5501 13555 319 6064 7172 Austria
2736 2736     Recovered Canada 2020-04-10 23:01:26     0 0 5855 0 Recovered, Canada
2777 2777       Belgium 2020-04-10 22:53:48 50.8333 4.469936 26667 3019 5568 18080 Belgium
2930 2930       Turkey 2020-04-10 22:53:48 38.9637 35.2433 47029 1006 2423 43600 Turkey
2864 2864       Malaysia 2020-04-10 22:53:48 4.210483999999999 101.97576600000001 4346 70 1830 2446 Malaysia
2805 2805       Denmark 2020-04-10 22:53:48 56.2639 9.5018 5819 247 1773 3799 Denmark
2795 2795       Chile 2020-04-10 22:53:48 -35.6751 -71.543 6501 65 1571 4865 Chile
2891 2891       Peru 2020-04-10 22:53:48 -9.19 -75.0152 5897 169 1569 4159 Peru
2842 2842       Israel 2020-04-10 22:53:48 31.046051000000002 34.851612 10607 97 1460 9130 Israel
2699 2699     Guangdong China 2020-04-10 01:51:07 23.3417 113.4244 1544 8 1434 102 Guangdong, China
2705 2705     Henan China 2020-04-06 00:42:07 33.882 113.614 1276 22 1252 2 Henan, China
2761 2761     Zhejiang China 2020-04-09 01:45:42 29.1832 120.0934 1267 1 1235 31 Zhejiang, China
2708 2708     Hunan China 2020-04-02 01:30:57 27.6104 111.7088 1019 4 1014 1 Hunan, China
2925 2925       Thailand 2020-04-10 22:53:48 15.870032 100.992541 2473 33 1013 1427 Thailand
2673 2673     Anhui China 2020-04-09 01:12:20 31.8257 117.2264 991 6 984 1 Anhui, China
2712 2712     Jiangxi China 2020-04-10 01:22:42 27.614 115.7221 937 1 936 0 Jiangxi, China
2755 2755     Victoria Australia 2020-04-10 23:01:43 -37.8136 144.9631 1241 13 926 302 Victoria, Australia
2897 2897       Russia 2020-04-10 22:53:48 61.52401 105.31875600000001 11917 94 795 11028 Russia
2837 2837       India 2020-04-10 22:53:48 20.593684 78.96288 7598 246 774 6578 India
2744 2744     Shandong China 2020-04-09 00:40:50 36.3427 118.1498 783 7 756 20 Shandong, China
2836 2836       Iceland 2020-04-10 22:53:48 64.9631 -19.0208 1675 7 751 917 Iceland
2896 2896       Romania 2020-04-10 22:53:48 45.9432 24.9668 5467 270 729 4468 Romania
2887 2887       Pakistan 2020-04-10 22:53:48 30.3753 69.3451 4695 66 727 3902 Pakistan
2845 2845       Japan 2020-04-10 22:53:48 36.204824 138.252924 5530 99 685 4746 Japan
2905 2905       Saudi Arabia 2020-04-10 22:53:48 23.885942 45.079162 3651 47 685 2919 Saudi Arabia
2711 2711     Jiangsu China 2020-04-10 01:26:45 32.9711 119.455 651 0 634 17 Jiangsu, China
2870 2870       Mexico 2020-04-10 22:53:48 23.6345 -102.5528 3441 194 633 2614 Mexico
2806 2806       Diamond Princess 2020-04-10 22:53:48     712 11 619 82 Diamond Princess
2683 2683     Chongqing China 2020-03-29 00:14:12 30.0572 107.874 579 6 570 3 Chongqing, China
2840 2840       Iraq 2020-04-10 22:53:48 33.223191 43.679291 1279 70 550 659 Iraq
2747 2747     Sichuan China 2020-04-10 01:07:31 30.6171 102.7103 560 3 546 11 Sichuan, China
2773 2773       Bahrain 2020-04-10 22:53:48 26.0275 50.55 925 6 539 380 Bahrain
2860 2860       Luxembourg 2020-04-10 22:53:48 49.8153 6.1296 3223 54 500 2669 Luxembourg
2910 2910       Singapore 2020-04-10 22:53:48 1.2833 103.8333 2108 7 492 1609 Singapore
2704 2704     Heilongjiang China 2020-04-10 01:01:27 47.862 127.7615 638 13 470 155 Heilongjiang, China
2676 2676     Beijing China 2020-04-10 01:14:37 40.1824 116.4142 588 8 469 111 Beijing, China
2745 2745     Shanghai China 2020-04-10 08:48:52 31.202 121.4491 555 7 435 113 Shanghai, China
2933 2933       United Arab Emirates 2020-04-10 22:53:48 23.424076 53.847818000000004 3360 16 418 2926 United Arab Emirates
2914 2914       South Africa 2020-04-10 22:53:48 -30.5595 22.9375 2003 24 410 1569 South Africa
2764 2764       Algeria 2020-04-10 22:53:48 28.0339 1.6596 1761 256 405 1100 Algeria
2811 2811       Egypt 2020-04-10 22:53:48 26.820553000000004 30.802497999999996 1794 135 384 1275 Egypt
2920 2920       Sweden 2020-04-10 22:53:48 60.128161 18.643501 9685 870 381 8434 Sweden
2768 2768       Argentina 2020-04-10 22:53:48 -38.4161 -63.6167 1975 82 375 1518 Argentina
2880 2880       New Zealand 2020-04-10 22:53:48 -40.9006 174.886 1283 2 373 908 New Zealand
2735 2735     Queensland Australia 2020-04-10 23:01:43 -27.4698 153.0251 965 4 372 589 Queensland, Australia
2810 2810       Ecuador 2020-04-10 22:53:48 -1.8312 -78.1834 7161 297 368 6496 Ecuador
2804 2804       Czechia 2020-04-10 22:53:48 49.8175 15.472999999999999 5732 119 346 5267 Czechia
2934 2934       United Kingdom 2020-04-10 22:53:48 55.3781 -3.4360000000000004 73758 8958 344 64456 United Kingdom
2893 2893       Poland 2020-04-10 22:53:48 51.9194 19.1451 5955 181 318 5456 Poland
2703 2703     Hebei China 2020-04-09 00:59:02 39.549 116.1306 327 6 313 8 Hebei, China
2691 2691     Fujian China 2020-04-10 01:01:27 26.0789 117.9874 351 1 311 39 Fujian, China
2706 2706     Hong Kong China 2020-04-10 10:12:56 22.3 114.2 989 4 309 676 Hong Kong, China
2819 2819       Finland 2020-04-10 22:53:48 61.92411 25.748151 2769 48 300 2421 Finland
2838 2838       Indonesia 2020-04-10 22:53:48 -0.7893 113.9213 3512 306 282 2924 Indonesia
2826 2826       Greece 2020-04-10 22:53:48 39.0742 21.8243 2011 92 269 1650 Greece
2700 2700     Guangxi China 2020-04-02 00:16:02 23.8298 108.7881 254 2 252 0 Guangxi, China
2879 2879       Netherlands 2020-04-10 22:53:48 52.1326 5.2913 23097 2511 250 20336 Netherlands
2743 2743     Shaanxi China 2020-04-06 01:14:34 35.1917 108.8701 256 3 246 7 Shaanxi, China
2894 2894       Portugal 2020-04-10 22:53:48 39.3999 -8.2245 15472 435 233 14804 Portugal
2801 2801       Croatia 2020-04-10 22:53:48 45.1 15.2 1495 21 231 1243 Croatia
2895 2895       Qatar 2020-04-10 22:53:48 25.3548 51.1839 2512 6 227 2279 Qatar
2935 2935       Uruguay 2020-04-10 22:53:48 -32.5228 -55.7658 473 7 206 260 Uruguay
2757 2757     Western Australia Australia 2020-04-10 23:01:43 -31.9505 115.8605 506 6 203 297 Western Australia, Australia
2796 2796       Colombia 2020-04-10 22:53:48 4.5709 -74.2973 2473 80 197 2196 Colombia
2763 2763       Albania 2020-04-10 22:53:48 41.1533 20.1683 416 23 182 211 Albania
2749 2749     South Australia Australia 2020-04-10 23:01:43 -34.9285 138.6007 428 3 179 246 South Australia, Australia
2760 2760     Yunnan China 2020-04-07 00:20:57 24.974 101.487 184 2 173 9 Yunnan, China
2784 2784       Brazil 2020-04-10 22:53:48 -14.235 -51.9253 19638 1057 173 18408 Brazil
2846 2846       Jordan 2020-04-10 22:53:48 31.24 36.51 372 7 170 195 Jordan
2776 2776       Belarus 2020-04-10 22:53:48 53.7098 27.9534 1981 19 169 1793 Belarus
2702 2702     Hainan China 2020-03-24 04:19:14 19.1959 109.7453 168 6 162 0 Hainan, China
2771 2771       Azerbaijan 2020-04-10 22:53:48 40.1431 47.5769 991 10 159 822 Azerbaijan
2752 2752     Tianjin China 2020-04-10 14:38:27 39.3054 117.323 183 3 158 22 Tianjin, China
2769 2769       Armenia 2020-04-10 22:53:48 40.0691 45.0382 937 12 149 776 Armenia
2787 2787       Burkina Faso 2020-04-10 22:53:48 12.2383 -1.5616 443 24 146 273 Burkina Faso
2688 2688     Faroe Islands Denmark 2020-04-10 22:53:48 61.8926 -6.9118 184 0 145 39 Faroe Islands, Denmark
2701 2701     Guizhou China 2020-03-18 01:37:43 26.8154 106.8748 146 2 144 0 Guizhou, China
2938 2938       Vietnam 2020-04-10 22:53:48 14.058323999999999 108.277199 257 0 144 113 Vietnam
2892 2892       Philippines 2020-04-10 22:53:48 12.879721 121.77401699999999 4195 221 140 3834 Philippines
2906 2906       Senegal 2020-04-10 22:53:48 14.4974 -14.4524 265 2 137 126 Senegal
2912 2912       Slovenia 2020-04-10 22:53:48 46.1512 14.9955 1160 45 137 978 Slovenia
2692 2692     Gansu China 2020-04-09 02:02:54 37.8099 101.0583 139 2 135 2 Gansu, China
2746 2746     Shanxi China 2020-04-10 00:23:52 37.5777 112.2922 168 0 134 34 Shanxi, China
2714 2714     Liaoning China 2020-04-09 12:08:14 41.2956 122.6085 144 2 132 10 Liaoning, China
2782 2782       Bosnia and Herzegovina 2020-04-10 22:53:48 43.9159 17.6791 901 36 129 736 Bosnia and Herzegovina
2851 2851       Kuwait 2020-04-10 22:53:48 29.311659999999996 47.481766 993 1 123 869 Kuwait
2875 2875       Morocco 2020-04-10 22:53:48 31.7917 -7.0926 1448 107 122 1219 Morocco
2835 2835       Hungary 2020-04-10 22:53:48 47.1625 19.5033 1190 77 112 1001 Hungary
2886 2886       Oman 2020-04-10 22:53:48 21.512583 55.92325500000001 484 3 109 372 Oman
2710 2710     Isle of Man United Kingdom 2020-04-10 22:53:48 54.2361 -4.5481 201 1 103 97 Isle of Man, United Kingdom
2785 2785       Brunei 2020-04-10 22:53:48 4.5353 114.7277 136 1 99 36 Brunei

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
);