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 Last_Update

✎ View and edit SQL

This data as json, copyable, CSV (advanced)

Link rowid FIPS Admin2 Province_State Country_Region Last_Update ▼ Lat Long_ Confirmed Deaths Recovered Active Combined_Key
2744 2744       Croatia 2020-04-08 22:51:39 45.1 15.2 1343 19 179 1145 Croatia
2745 2745       Cuba 2020-04-08 22:51:39 21.521757 -77.78116700000002 457 12 27 418 Cuba
2746 2746       Cyprus 2020-04-08 22:51:39 35.1264 33.4299 526 9 52 465 Cyprus
2747 2747       Czechia 2020-04-08 22:51:39 49.8175 15.472999999999999 5312 99 233 4980 Czechia
2748 2748       Denmark 2020-04-08 22:51:39 56.2639 9.5018 5402 218 1621 3563 Denmark
2749 2749       Diamond Princess 2020-04-08 22:51:39     712 11 619 82 Diamond Princess
2750 2750       Djibouti 2020-04-08 22:51:39 11.8251 42.5903 135 0 25 110 Djibouti
2751 2751       Dominica 2020-04-08 22:51:39 15.415 -61.371 15 0 1 14 Dominica
2752 2752       Dominican Republic 2020-04-08 22:51:39 18.7357 -70.1627 2111 108 50 1953 Dominican Republic
2753 2753       Ecuador 2020-04-08 22:51:39 -1.8312 -78.1834 4450 242 140 4068 Ecuador
2754 2754       Egypt 2020-04-08 22:51:39 26.820553000000004 30.802497999999996 1560 103 305 1152 Egypt
2755 2755       El Salvador 2020-04-08 22:51:39 13.7942 -88.8965 93 5 9 79 El Salvador
2756 2756       Equatorial Guinea 2020-04-08 22:51:39 1.6508 10.2679 18 0 3 15 Equatorial Guinea
2757 2757       Eritrea 2020-04-08 22:51:39 15.1794 39.7823 33 0 0 33 Eritrea
2758 2758       Estonia 2020-04-08 22:51:39 58.5953 25.0136 1185 24 72 1089 Estonia
2759 2759       Eswatini 2020-04-08 22:51:39 -26.5225 31.4659 12 0 7 5 Eswatini
2760 2760       Ethiopia 2020-04-08 22:51:39 9.145 40.4897 55 2 4 49 Ethiopia
2761 2761       Fiji 2020-04-08 22:51:39 -17.7134 178.065 15 0 0 15 Fiji
2762 2762       Finland 2020-04-08 22:51:39 61.92411 25.748151 2487 40 300 2147 Finland
2763 2763       France 2020-04-08 22:51:39 46.2276 2.2137 81144 10856 21254 80827 France
2764 2764       Gabon 2020-04-08 22:51:39 -0.8037 11.6094 34 1 1 32 Gabon
2765 2765       Gambia 2020-04-08 22:51:39 13.4432 -15.3101 4 1 2 1 Gambia
2766 2766       Georgia 2020-04-08 22:51:39 42.3154 43.3569 211 3 50 158 Georgia
2767 2767       Germany 2020-04-08 22:51:39 51.165690999999995 10.451526 113296 2349 46300 64647 Germany
2768 2768       Ghana 2020-04-08 22:51:39 7.9465 -1.0232 313 6 34 273 Ghana
2769 2769       Greece 2020-04-08 22:51:39 39.0742 21.8243 1884 83 269 1532 Greece
2770 2770       Grenada 2020-04-08 22:51:39 12.1165 -61.678999999999995 12 0 0 12 Grenada
2771 2771       Guatemala 2020-04-08 22:51:39 15.7835 -90.2308 87 3 17 67 Guatemala
2772 2772       Guinea 2020-04-08 22:51:39 9.9456 -9.6966 164 0 5 159 Guinea
2773 2773       Guinea-Bissau 2020-04-08 22:51:39 11.8037 -15.1804 33 0 0 33 Guinea-Bissau
2774 2774       Guyana 2020-04-08 22:51:39 4.860416000000002 -58.93018000000001 37 6 8 23 Guyana
2775 2775       Haiti 2020-04-08 22:51:39 18.9712 -72.2852 25 1 0 26 Haiti
2776 2776       Holy See 2020-04-08 22:51:39 41.9029 12.4534 8 0 2 6 Holy See
2777 2777       Honduras 2020-04-08 22:51:39 15.2 -86.2419 312 22 6 284 Honduras
2778 2778       Hungary 2020-04-08 22:51:39 47.1625 19.5033 895 58 94 743 Hungary
2779 2779       Iceland 2020-04-08 22:51:39 64.9631 -19.0208 1616 6 633 977 Iceland
2780 2780       India 2020-04-08 22:51:39 20.593684 78.96288 5916 178 506 5232 India
2781 2781       Indonesia 2020-04-08 22:51:39 -0.7893 113.9213 2956 240 222 2494 Indonesia
2782 2782       Iran 2020-04-08 22:51:39 32.427908 53.68804599999999 64586 3993 29812 30781 Iran
2783 2783       Iraq 2020-04-08 22:51:39 33.223191 43.679291 1202 69 452 681 Iraq
2784 2784       Ireland 2020-04-08 22:51:39 53.1424 -7.6921 6074 235 25 5814 Ireland
2785 2785       Israel 2020-04-08 22:51:39 31.046051000000002 34.851612 9906 80 1191 8530 Israel
2786 2786       Italy 2020-04-08 22:51:39 41.87194 12.56738 139422 17669 26491 95262 Italy
2787 2787       Jamaica 2020-04-08 22:51:39 18.1096 -77.2975 63 4 10 49 Jamaica
2788 2788       Japan 2020-04-08 22:51:39 36.204824 138.252924 4257 93 622 3542 Japan
2789 2789       Jordan 2020-04-08 22:51:39 31.24 36.51 358 6 150 202 Jordan
2790 2790       Kazakhstan 2020-04-08 22:51:39 48.0196 66.9237 727 7 54 666 Kazakhstan
2791 2791       Kenya 2020-04-08 22:51:39 -0.0236 37.9062 179 6 9 164 Kenya
2792 2792       Korea, South 2020-04-08 22:51:39 35.90775700000001 127.766922 10384 200 6776 3408 Korea, South
2793 2793       Kosovo 2020-04-08 22:51:39 42.602636 20.902977 184 5 30 149 Kosovo
2794 2794       Kuwait 2020-04-08 22:51:39 29.311659999999996 47.481766 855 1 111 743 Kuwait
2795 2795       Kyrgyzstan 2020-04-08 22:51:39 41.20438 74.766098 270 4 33 233 Kyrgyzstan
2796 2796       Laos 2020-04-08 22:51:39 19.856270000000002 102.495496 15 0 0 15 Laos
2797 2797       Latvia 2020-04-08 22:51:39 56.8796 24.6032 577 2 16 559 Latvia
2798 2798       Lebanon 2020-04-08 22:51:39 33.8547 35.8623 576 19 62 495 Lebanon
2799 2799       Liberia 2020-04-08 22:51:39 6.4280550000000005 -9.429499 31 4 3 24 Liberia
2800 2800       Libya 2020-04-08 22:51:39 26.3351 17.228331 21 1 8 12 Libya
2801 2801       Liechtenstein 2020-04-08 22:51:39 47.14 9.55 78 1 55 22 Liechtenstein
2802 2802       Lithuania 2020-04-08 22:51:39 55.1694 23.8813 821 11 1 889 Lithuania
2803 2803       Luxembourg 2020-04-08 22:51:39 49.8153 6.1296 3034 46 500 2488 Luxembourg
2804 2804       MS Zaandam 2020-04-08 22:51:39     9 2 0 7 ,,MS Zaandam
2805 2805       Madagascar 2020-04-08 22:51:39 -18.766947000000002 46.869107 93 0 11 82 Madagascar
2806 2806       Malawi 2020-04-08 22:51:39 -13.254307999999998 34.301525 8 1 0 7 Malawi
2807 2807       Malaysia 2020-04-08 22:51:39 4.210483999999999 101.97576600000001 4119 65 1487 2567 Malaysia
2808 2808       Maldives 2020-04-08 22:51:39 3.2028 73.2207 19 0 13 6 Maldives
2809 2809       Mali 2020-04-08 22:51:39 17.570692 -3.996166000000001 59 7 16 36 Mali
2810 2810       Malta 2020-04-08 22:51:39 35.9375 14.3754 299 1 16 282 Malta
2811 2811       Mauritania 2020-04-08 22:51:39 21.0079 -10.9408 6 1 2 3 ,,Mauritania
2812 2812       Mauritius 2020-04-08 22:51:39 -20.348404000000002 57.552152 273 7 19 247 Mauritius
2813 2813       Mexico 2020-04-08 22:51:39 23.6345 -102.5528 2785 141 633 2011 Mexico
2814 2814       Moldova 2020-04-08 22:51:39 47.4116 28.3699 1174 27 40 1107 Moldova
2815 2815       Monaco 2020-04-08 22:51:39 43.7333 7.4167 81 1 4 76 Monaco
2816 2816       Mongolia 2020-04-08 22:51:39 46.8625 103.8467 16 0 4 12 Mongolia
2817 2817       Montenegro 2020-04-08 22:51:39 42.708678000000006 19.37439 248 2 4 242 Montenegro
2818 2818       Morocco 2020-04-08 22:51:39 31.7917 -7.0926 1275 93 97 1085 Morocco
2819 2819       Mozambique 2020-04-08 22:51:39 -18.665695 35.529562 17 0 1 16 Mozambique
2820 2820       Namibia 2020-04-08 22:51:39 -22.9576 18.4904 16 0 3 13 Namibia
2821 2821       Nepal 2020-04-08 22:51:39 28.1667 84.25 9 0 1 8 Nepal
2822 2822       Netherlands 2020-04-08 22:51:39 52.1326 5.2913 20549 2248 250 18051 Netherlands
2823 2823       New Zealand 2020-04-08 22:51:39 -40.9006 174.886 1210 1 282 927 New Zealand
2824 2824       Nicaragua 2020-04-08 22:51:39 12.865416 -85.207229 6 1 0 5 Nicaragua
2825 2825       Niger 2020-04-08 22:51:39 17.607789 8.081666 342 11 28 303 Niger
2826 2826       Nigeria 2020-04-08 22:51:39 9.082 8.6753 276 6 44 226 Nigeria
2827 2827       North Macedonia 2020-04-08 22:51:39 41.6086 21.7453 617 29 35 553 North Macedonia
2828 2828       Norway 2020-04-08 22:51:39 60.472 8.4689 6086 101 32 5953 Norway
2829 2829       Oman 2020-04-08 22:51:39 21.512583 55.92325500000001 419 2 72 345 Oman
2830 2830       Pakistan 2020-04-08 22:51:39 30.3753 69.3451 4263 61 467 3735 Pakistan
2831 2831       Panama 2020-04-08 22:51:39 8.538 -80.7821 2249 59 16 2174 Panama
2832 2832       Papua New Guinea 2020-04-08 22:51:39 -6.314993 143.95555 2 0 0 2 Papua New Guinea
2833 2833       Paraguay 2020-04-08 22:51:39 -23.4425 -58.4438 119 5 15 99 Paraguay
2834 2834       Peru 2020-04-08 22:51:39 -9.19 -75.0152 4342 121 1333 2888 Peru
2835 2835       Philippines 2020-04-08 22:51:39 12.879721 121.77401699999999 3870 182 96 3592 Philippines
2836 2836       Poland 2020-04-08 22:51:39 51.9194 19.1451 5205 159 222 4824 Poland
2837 2837       Portugal 2020-04-08 22:51:39 39.3999 -8.2245 13141 380 196 12565 Portugal
2838 2838       Qatar 2020-04-08 22:51:39 25.3548 51.1839 2210 6 178 2026 Qatar
2839 2839       Romania 2020-04-08 22:51:39 45.9432 24.9668 4761 220 528 4013 Romania
2840 2840       Russia 2020-04-08 22:51:39 61.52401 105.31875600000001 8672 63 580 8029 Russia
2841 2841       Rwanda 2020-04-08 22:51:39 -1.9403 29.8739 110 0 7 103 Rwanda
2842 2842       Saint Kitts and Nevis 2020-04-08 22:51:39 17.357822 -62.782998 11 0 0 11 Saint Kitts and Nevis
2843 2843       Saint Lucia 2020-04-08 22:51:39 13.9094 -60.9789 14 0 1 13 Saint Lucia

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