04-08-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,884 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
2650 2650     Hubei China 2020-04-08 00:37:38 30.9756 112.2707 67803 3213 64142 448 Hubei, China
2859 2859       Spain 2020-04-08 22:51:39 40.463667 -3.7492199999999998 148220 14792 48021 85407 Spain
2767 2767       Germany 2020-04-08 22:51:39 51.165690999999995 10.451526 113296 2349 46300 64647 Germany
2782 2782       Iran 2020-04-08 22:51:39 32.427908 53.68804599999999 64586 3993 29812 30781 Iran
2786 2786       Italy 2020-04-08 22:51:39 41.87194 12.56738 139422 17669 26491 95262 Italy
2680 2680     Recovered US 2020-04-08 22:51:58     0 0 23559 0 Recovered, US
2763 2763       France 2020-04-08 22:51:39 46.2276 2.2137 81144 10856 21254 80827 France
2864 2864       Switzerland 2020-04-08 22:51:39 46.8182 8.2275 23280 895 9800 12585 Switzerland
2792 2792       Korea, South 2020-04-08 22:51:39 35.90775700000001 127.766922 10384 200 6776 3408 Korea, South
2720 2720       Belgium 2020-04-08 22:51:39 50.8333 4.469936 23403 2240 4681 16482 Belgium
2713 2713       Austria 2020-04-08 22:51:39 47.5162 14.5501 12942 273 4512 8157 Austria
2679 2679     Recovered Canada 2020-04-08 22:58:44     0 0 4154 0 Recovered, Canada
2873 2873       Turkey 2020-04-08 22:51:39 38.9637 35.2433 38226 812 1846 35568 Turkey
2748 2748       Denmark 2020-04-08 22:51:39 56.2639 9.5018 5402 218 1621 3563 Denmark
2807 2807       Malaysia 2020-04-08 22:51:39 4.210483999999999 101.97576600000001 4119 65 1487 2567 Malaysia
2642 2642     Guangdong China 2020-04-08 02:01:44 23.3417 113.4244 1536 8 1411 117 Guangdong, China
2834 2834       Peru 2020-04-08 22:51:39 -9.19 -75.0152 4342 121 1333 2888 Peru
2648 2648     Henan China 2020-04-06 00:42:07 33.882 113.614 1276 22 1252 2 Henan, China
2704 2704     Zhejiang China 2020-04-08 02:01:44 29.1832 120.0934 1266 1 1232 33 Zhejiang, China
2785 2785       Israel 2020-04-08 22:51:39 31.046051000000002 34.851612 9906 80 1191 8530 Israel
2738 2738       Chile 2020-04-08 22:51:39 -35.6751 -71.543 5546 48 1115 4383 Chile
2651 2651     Hunan China 2020-04-02 01:30:57 27.6104 111.7088 1019 4 1014 1 Hunan, China
2616 2616     Anhui China 2020-03-08 05:19:01 31.8257 117.2264 990 6 984 0 Anhui, China
2655 2655     Jiangxi China 2020-03-30 03:15:15 27.614 115.7221 937 1 935 1 Jiangxi, China
2868 2868       Thailand 2020-04-08 22:51:39 15.870032 100.992541 2369 30 888 1451 Thailand
2687 2687     Shandong China 2020-04-08 01:47:35 36.3427 118.1498 783 7 755 21 Shandong, China
2654 2654     Jiangsu China 2020-04-05 01:33:26 32.9711 119.455 651 0 633 18 Jiangsu, China
2779 2779       Iceland 2020-04-08 22:51:39 64.9631 -19.0208 1616 6 633 977 Iceland
2813 2813       Mexico 2020-04-08 22:51:39 23.6345 -102.5528 2785 141 633 2011 Mexico
2848 2848       Saudi Arabia 2020-04-08 22:51:39 23.885942 45.079162 2932 41 631 2260 Saudi Arabia
2788 2788       Japan 2020-04-08 22:51:39 36.204824 138.252924 4257 93 622 3542 Japan
2698 2698     Victoria Australia 2020-04-08 22:59:00 -37.8136 144.9631 1212 12 620 580 Victoria, Australia
2749 2749       Diamond Princess 2020-04-08 22:51:39     712 11 619 82 Diamond Princess
2840 2840       Russia 2020-04-08 22:51:39 61.52401 105.31875600000001 8672 63 580 8029 Russia
2626 2626     Chongqing China 2020-03-29 00:14:12 30.0572 107.874 579 6 570 3 Chongqing, China
2690 2690     Sichuan China 2020-04-07 01:35:16 30.6171 102.7103 560 3 541 16 Sichuan, China
2839 2839       Romania 2020-04-08 22:51:39 45.9432 24.9668 4761 220 528 4013 Romania
2780 2780       India 2020-04-08 22:51:39 20.593684 78.96288 5916 178 506 5232 India
2803 2803       Luxembourg 2020-04-08 22:51:39 49.8153 6.1296 3034 46 500 2488 Luxembourg
2716 2716       Bahrain 2020-04-08 22:51:39 26.0275 50.55 823 5 477 341 Bahrain
2647 2647     Heilongjiang China 2020-04-08 00:48:46 47.862 127.7615 569 13 470 86 Heilongjiang, China
2830 2830       Pakistan 2020-04-08 22:51:39 30.3753 69.3451 4263 61 467 3735 Pakistan
2619 2619     Beijing China 2020-04-08 01:47:35 40.1824 116.4142 588 8 455 125 Beijing, China
2783 2783       Iraq 2020-04-08 22:51:39 33.223191 43.679291 1202 69 452 681 Iraq
2688 2688     Shanghai China 2020-04-08 05:20:24 31.202 121.4491 543 7 418 118 Shanghai, China
2853 2853       Singapore 2020-04-08 22:51:39 1.2833 103.8333 1623 6 406 1211 Singapore
2711 2711       Argentina 2020-04-08 22:51:39 -38.4161 -63.6167 1715 63 358 1294 Argentina
2646 2646     Hebei China 2020-04-07 00:29:03 39.549 116.1306 327 6 312 9 Hebei, China
2634 2634     Fujian China 2020-04-08 12:26:31 26.0789 117.9874 351 1 308 42 Fujian, China
2754 2754       Egypt 2020-04-08 22:51:39 26.820553000000004 30.802497999999996 1560 103 305 1152 Egypt
2762 2762       Finland 2020-04-08 22:51:39 61.92411 25.748151 2487 40 300 2147 Finland
2823 2823       New Zealand 2020-04-08 22:51:39 -40.9006 174.886 1210 1 282 927 New Zealand
2769 2769       Greece 2020-04-08 22:51:39 39.0742 21.8243 1884 83 269 1532 Greece
2649 2649     Hong Kong China 2020-04-08 09:23:07 22.3 114.2 960 4 264 692 Hong Kong, China
2643 2643     Guangxi China 2020-04-02 00:16:02 23.8298 108.7881 254 2 252 0 Guangxi, China
2822 2822       Netherlands 2020-04-08 22:51:39 52.1326 5.2913 20549 2248 250 18051 Netherlands
2686 2686     Shaanxi China 2020-04-06 01:14:34 35.1917 108.8701 256 3 246 7 Shaanxi, China
2876 2876       United Arab Emirates 2020-04-08 22:51:39 23.424076 53.847818000000004 2659 12 239 2408 United Arab Emirates
2707 2707       Algeria 2020-04-08 22:51:39 28.0339 1.6596 1572 205 237 1130 Algeria
2747 2747       Czechia 2020-04-08 22:51:39 49.8175 15.472999999999999 5312 99 233 4980 Czechia
2781 2781       Indonesia 2020-04-08 22:51:39 -0.7893 113.9213 2956 240 222 2494 Indonesia
2836 2836       Poland 2020-04-08 22:51:39 51.9194 19.1451 5205 159 222 4824 Poland
2863 2863       Sweden 2020-04-08 22:51:39 60.128161 18.643501 8419 687 205 7527 Sweden
2837 2837       Portugal 2020-04-08 22:51:39 39.3999 -8.2245 13141 380 196 12565 Portugal
2744 2744       Croatia 2020-04-08 22:51:39 45.1 15.2 1343 19 179 1145 Croatia
2838 2838       Qatar 2020-04-08 22:51:39 25.3548 51.1839 2210 6 178 2026 Qatar
2678 2678     Queensland Australia 2020-04-08 22:59:00 -27.4698 153.0251 943 4 173 766 Queensland, Australia
2703 2703     Yunnan China 2020-04-07 00:20:57 24.974 101.487 184 2 173 9 Yunnan, China
2645 2645     Hainan China 2020-03-24 04:19:14 19.1959 109.7453 168 6 162 0 Hainan, China
2700 2700     Western Australia Australia 2020-04-08 22:59:00 -31.9505 115.8605 481 6 162 313 Western Australia, Australia
2706 2706       Albania 2020-04-08 22:51:39 41.1533 20.1683 400 22 154 224 Albania
2695 2695     Tianjin China 2020-04-08 03:06:39 39.3054 117.323 180 3 152 25 Tianjin, China
2789 2789       Jordan 2020-04-08 22:51:39 31.24 36.51 358 6 150 202 Jordan
2878 2878       Uruguay 2020-04-08 22:51:39 -32.5228 -55.7658 424 7 150 267 Uruguay
2644 2644     Guizhou China 2020-03-18 01:37:43 26.8154 106.8748 146 2 144 0 Guizhou, China
2753 2753       Ecuador 2020-04-08 22:51:39 -1.8312 -78.1834 4450 242 140 4068 Ecuador
2877 2877       United Kingdom 2020-04-08 22:51:39 55.3781 -3.4360000000000004 60733 7097 135 53501 United Kingdom
2689 2689     Shanxi China 2020-04-08 02:10:52 37.5777 112.2922 163 0 134 29 Shanxi, China
2730 2730       Burkina Faso 2020-04-08 22:51:39 12.2383 -1.5616 414 23 134 257 Burkina Faso
2635 2635     Gansu China 2020-04-08 03:06:39 37.8099 101.0583 139 2 133 4 Gansu, China
2631 2631     Faroe Islands Denmark 2020-04-08 22:51:39 61.8926 -6.9118 184 0 131 53 Faroe Islands, Denmark
2657 2657     Liaoning China 2020-04-08 00:48:46 41.2956 122.6085 144 2 131 11 Liaoning, China
2727 2727       Brazil 2020-04-08 22:51:39 -14.235 -51.9253 16170 819 127 15224 Brazil
2881 2881       Vietnam 2020-04-08 22:51:39 14.058323999999999 108.277199 251 0 126 125 Vietnam
2739 2739       Colombia 2020-04-08 22:51:39 4.5709 -74.2973 2054 54 123 1877 Colombia
2855 2855       Slovenia 2020-04-08 22:51:39 46.1512 14.9955 1091 40 120 931 Slovenia
2712 2712       Armenia 2020-04-08 22:51:39 40.0691 45.0382 881 9 114 758 Armenia
2849 2849       Senegal 2020-04-08 22:51:39 14.4974 -14.4524 244 2 113 129 Senegal
2794 2794       Kuwait 2020-04-08 22:51:39 29.311659999999996 47.481766 855 1 111 743 Kuwait
2818 2818       Morocco 2020-04-08 22:51:39 31.7917 -7.0926 1275 93 97 1085 Morocco
2835 2835       Philippines 2020-04-08 22:51:39 12.879721 121.77401699999999 3870 182 96 3592 Philippines
2857 2857       South Africa 2020-04-08 22:51:39 -30.5595 22.9375 1845 18 95 1732 South Africa
2778 2778       Hungary 2020-04-08 22:51:39 47.1625 19.5033 895 58 94 743 Hungary
2656 2656     Jilin China 2020-04-08 12:24:29 43.6661 126.1923 98 1 93 4 Jilin, China
2728 2728       Brunei 2020-04-08 22:51:39 4.5353 114.7277 135 1 91 43 Brunei
2653 2653     Isle of Man United Kingdom 2020-04-08 22:51:39 54.2361 -4.5481 158 1 82 75 Isle of Man, United Kingdom
2725 2725       Bosnia and Herzegovina 2020-04-08 22:51:39 43.9159 17.6791 804 34 79 691 Bosnia and Herzegovina
2719 2719       Belarus 2020-04-08 22:51:39 53.7098 27.9534 1066 13 77 976 Belarus
2667 2667     Ningxia China 2020-03-16 08:47:05 37.2692 106.1655 75 0 75 0 Ningxia, China
2652 2652     Inner Mongolia China 2020-04-08 00:37:38 44.0935 113.9448 124 1 74 49 Inner Mongolia, China

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

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