04-07-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,858 rows sorted by Country_Region

✎ 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
2605 2605     Faroe Islands Denmark 2020-04-07 23:04:29 61.8926 -6.9118 184 0 120 64 Faroe Islands, Denmark
2613 2613     Greenland Denmark 2020-04-07 23:04:29 71.7069 -42.6043 11 0 10 1 Greenland, Denmark
2722 2722       Denmark 2020-04-07 23:04:29 56.2639 9.5018 5071 203 1491 3377 Denmark
2723 2723       Diamond Princess 2020-04-07 23:04:29     712 11 619 82 Diamond Princess
2724 2724       Djibouti 2020-04-07 23:04:29 11.8251 42.5903 90 0 9 81 Djibouti
2725 2725       Dominica 2020-04-07 23:04:29 15.415 -61.371 15 0 1 14 Dominica
2726 2726       Dominican Republic 2020-04-07 23:04:29 18.7357 -70.1627 1956 98 36 1822 Dominican Republic
2727 2727       Ecuador 2020-04-07 23:04:29 -1.8312 -78.1834 3747 191 100 3456 Ecuador
2728 2728       Egypt 2020-04-07 23:04:29 26.820553000000004 30.802497999999996 1450 94 276 1080 Egypt
2729 2729       El Salvador 2020-04-07 23:04:29 13.7942 -88.8965 78 4 5 69 El Salvador
2730 2730       Equatorial Guinea 2020-04-07 23:04:29 1.6508 10.2679 16 0 3 13 Equatorial Guinea
2731 2731       Eritrea 2020-04-07 23:04:29 15.1794 39.7823 31 0 0 31 Eritrea
2732 2732       Estonia 2020-04-07 23:04:29 58.5953 25.0136 1149 21 69 1059 Estonia
2733 2733       Eswatini 2020-04-07 23:04:29 -26.5225 31.4659 10 0 4 6 Eswatini
2734 2734       Ethiopia 2020-04-07 23:04:29 9.145 40.4897 52 2 4 46 Ethiopia
2735 2735       Fiji 2020-04-07 23:04:29 -17.7134 178.065 15 0 0 15 Fiji
2736 2736       Finland 2020-04-07 23:04:29 61.92411 25.748151 2308 34 300 1974 Finland
2606 2606     French Guiana France 2020-04-07 23:04:29 4.0 -53.0 72 0 34 38 French Guiana, France
2607 2607     French Polynesia France 2020-04-07 23:04:29 -17.6797 -149.4068 47 0 0 47 French Polynesia, France
2614 2614     Guadeloupe France 2020-04-07 23:04:29 16.265 -61.551 139 7 31 101 Guadeloupe, France
2634 2634     Martinique France 2020-04-07 23:04:29 14.6415 -61.0242 152 4 50 98 Martinique, France
2635 2635     Mayotte France 2020-04-07 23:04:29 -12.8275 45.166244 171 2 22 147 Mayotte, France
2638 2638     New Caledonia France 2020-04-07 23:04:29 -20.904304999999997 165.618042 18 0 1 17 New Caledonia, France
2655 2655     Reunion France 2020-04-07 23:04:29 -21.1151 55.5364 358 0 40 318 Reunion, France
2656 2656     Saint Barthelemy France 2020-04-07 23:04:29 17.9 -62.8333 6 0 1 5 Saint Barthelemy, France
2658 2658     Saint Pierre and Miquelon France 2020-04-07 23:04:29 46.8852 -56.3159 1 0 0 1 Saint Pierre and Miquelon, France
2667 2667     St Martin France 2020-04-07 23:04:29 18.0708 -63.0501 32 2 7 23 St Martin, France
2737 2737       France 2020-04-07 23:04:29 46.2276 2.2137 77302 10315 19337 79404 France
2738 2738       Gabon 2020-04-07 23:04:29 -0.8037 11.6094 30 1 1 28 Gabon
2739 2739       Gambia 2020-04-07 23:04:29 13.4432 -15.3101 4 1 2 1 Gambia
2740 2740       Georgia 2020-04-07 23:04:29 42.3154 43.3569 196 3 46 147 Georgia
2741 2741       Germany 2020-04-07 23:04:29 51.165690999999995 10.451526 107663 2016 36081 69566 Germany
2742 2742       Ghana 2020-04-07 23:04:29 7.9465 -1.0232 287 5 31 251 Ghana
2743 2743       Greece 2020-04-07 23:04:29 39.0742 21.8243 1832 81 269 1482 Greece
2744 2744       Grenada 2020-04-07 23:04:29 12.1165 -61.678999999999995 12 0 0 12 Grenada
2745 2745       Guatemala 2020-04-07 23:04:29 15.7835 -90.2308 77 3 17 57 Guatemala
2746 2746       Guinea 2020-04-07 23:04:29 9.9456 -9.6966 144 0 5 139 Guinea
2747 2747       Guinea-Bissau 2020-04-07 23:04:29 11.8037 -15.1804 33 0 0 33 Guinea-Bissau
2748 2748       Guyana 2020-04-07 23:04:29 4.860416000000002 -58.93018000000001 33 5 8 20 Guyana
2749 2749       Haiti 2020-04-07 23:04:29 18.9712 -72.2852 24 1 0 24 Haiti
2750 2750       Holy See 2020-04-07 23:04:29 41.9029 12.4534 7 0 0 7 Holy See
2751 2751       Honduras 2020-04-07 23:04:29 15.2 -86.2419 305 22 6 277 Honduras
2752 2752       Hungary 2020-04-07 23:04:29 47.1625 19.5033 817 47 71 699 Hungary
2753 2753       Iceland 2020-04-07 23:04:29 64.9631 -19.0208 1586 6 559 1021 Iceland
2754 2754       India 2020-04-07 23:04:29 20.593684 78.96288 5311 150 421 4740 India
2755 2755       Indonesia 2020-04-07 23:04:29 -0.7893 113.9213 2738 221 204 2313 Indonesia
2756 2756       Iran 2020-04-07 23:04:29 32.427908 53.68804599999999 62589 3872 27039 31678 Iran
2757 2757       Iraq 2020-04-07 23:04:29 33.223191 43.679291 1122 65 373 684 Iraq
2758 2758       Ireland 2020-04-07 23:04:29 53.1424 -7.6921 5709 210 25 5474 Ireland
2759 2759       Israel 2020-04-07 23:04:29 31.046051000000002 34.851612 9568 72 1059 8413 Israel
2760 2760       Italy 2020-04-07 23:04:29 41.87194 12.56738 135586 17127 24392 94067 Italy
2761 2761       Jamaica 2020-04-07 23:04:29 18.1096 -77.2975 63 3 8 52 Jamaica
2762 2762       Japan 2020-04-07 23:04:29 36.204824 138.252924 3906 92 592 3222 Japan
2763 2763       Jordan 2020-04-07 23:04:29 31.24 36.51 353 6 138 209 Jordan
2764 2764       Kazakhstan 2020-04-07 23:04:29 48.0196 66.9237 697 6 51 640 Kazakhstan
2765 2765       Kenya 2020-04-07 23:04:29 -0.0236 37.9062 172 6 7 159 Kenya
2766 2766       Korea, South 2020-04-07 23:04:29 35.90775700000001 127.766922 10331 192 6694 3445 Korea, South
2767 2767       Kosovo 2020-04-07 23:04:29 42.602636 20.902977 170 4 24 142 Kosovo
2768 2768       Kuwait 2020-04-07 23:04:29 29.311659999999996 47.481766 743 1 105 637 Kuwait
2769 2769       Kyrgyzstan 2020-04-07 23:04:29 41.20438 74.766098 228 4 33 191 Kyrgyzstan
2770 2770       Laos 2020-04-07 23:04:29 19.856270000000002 102.495496 14 0 0 14 Laos
2771 2771       Latvia 2020-04-07 23:04:29 56.8796 24.6032 548 2 16 530 Latvia
2772 2772       Lebanon 2020-04-07 23:04:29 33.8547 35.8623 548 19 62 467 Lebanon
2773 2773       Liberia 2020-04-07 23:04:29 6.4280550000000005 -9.429499 14 3 3 8 Liberia
2774 2774       Libya 2020-04-07 23:04:29 26.3351 17.228331 20 1 1 18 Libya
2775 2775       Liechtenstein 2020-04-07 23:04:29 47.14 9.55 78 1 55 22 Liechtenstein
2776 2776       Lithuania 2020-04-07 23:04:29 55.1694 23.8813 783 11 0 857 Lithuania
2777 2777       Luxembourg 2020-04-07 23:04:29 49.8153 6.1296 2970 44 500 2426 Luxembourg
2778 2778       MS Zaandam 2020-04-07 23:04:29     9 2 0 7 ,,MS Zaandam
2779 2779       Madagascar 2020-04-07 23:04:29 -18.766947000000002 46.869107 88 0 7 81 Madagascar
2780 2780       Malawi 2020-04-07 23:04:29 -13.254307999999998 34.301525 8 1 0 7 Malawi
2781 2781       Malaysia 2020-04-07 23:04:29 4.210483999999999 101.97576600000001 3963 63 1321 2579 Malaysia
2782 2782       Maldives 2020-04-07 23:04:29 3.2028 73.2207 19 0 13 6 Maldives
2783 2783       Mali 2020-04-07 23:04:29 17.570692 -3.996166000000001 56 5 12 39 Mali
2784 2784       Malta 2020-04-07 23:04:29 35.9375 14.3754 293 0 5 288 Malta
2785 2785       Mauritania 2020-04-07 23:04:29 21.0079 -10.9408 6 1 2 3 ,,Mauritania
2786 2786       Mauritius 2020-04-07 23:04:29 -20.348404000000002 57.552152 268 7 8 253 Mauritius
2787 2787       Mexico 2020-04-07 23:04:29 23.6345 -102.5528 2439 125 633 1681 Mexico
2788 2788       Moldova 2020-04-07 23:04:29 47.4116 28.3699 1056 22 40 994 Moldova
2789 2789       Monaco 2020-04-07 23:04:29 43.7333 7.4167 79 1 4 74 Monaco
2790 2790       Mongolia 2020-04-07 23:04:29 46.8625 103.8467 15 0 4 11 Mongolia
2791 2791       Montenegro 2020-04-07 23:04:29 42.708678000000006 19.37439 241 2 4 235 Montenegro
2792 2792       Morocco 2020-04-07 23:04:29 31.7917 -7.0926 1184 90 93 1001 Morocco
2793 2793       Mozambique 2020-04-07 23:04:29 -18.665695 35.529562 10 0 1 9 Mozambique
2794 2794       Namibia 2020-04-07 23:04:29 -22.9576 18.4904 16 0 3 13 Namibia
2795 2795       Nepal 2020-04-07 23:04:29 28.1667 84.25 9 0 1 8 Nepal
2591 2591     Aruba Netherlands 2020-04-07 23:04:29 12.5211 -69.9683 74 0 14 60 Aruba, Netherlands
2595 2595     Bonaire, Sint Eustatius and Saba Netherlands 2020-04-07 23:04:29 12.1784 -68.2385 2 0 0 2 Bonaire, Sint Eustatius and Saba, Netherlands
2601 2601     Curacao Netherlands 2020-04-07 23:04:29 12.1696 -68.99 13 1 7 5 Curacao, Netherlands
2665 2665     Sint Maarten Netherlands 2020-04-07 23:04:29 18.0425 -63.0548 40 6 1 33 Sint Maarten, Netherlands
2796 2796       Netherlands 2020-04-07 23:04:29 52.1326 5.2913 19580 2101 250 17229 Netherlands
2797 2797       New Zealand 2020-04-07 23:04:29 -40.9006 174.886 1160 1 241 918 New Zealand
2798 2798       Nicaragua 2020-04-07 23:04:29 12.865416 -85.207229 6 1 0 5 Nicaragua
2799 2799       Niger 2020-04-07 23:04:29 17.607789 8.081666 278 11 26 241 Niger
2800 2800       Nigeria 2020-04-07 23:04:29 9.082 8.6753 254 6 44 204 Nigeria
2801 2801       North Macedonia 2020-04-07 23:04:29 41.6086 21.7453 599 26 30 543 North Macedonia
2802 2802       Norway 2020-04-07 23:04:29 60.472 8.4689 6086 89 32 5965 Norway
2803 2803       Oman 2020-04-07 23:04:29 21.512583 55.92325500000001 371 2 67 302 Oman
2804 2804       Pakistan 2020-04-07 23:04:29 30.3753 69.3451 4035 57 429 3549 Pakistan
2805 2805       Panama 2020-04-07 23:04:29 8.538 -80.7821 2100 55 14 2031 Panama

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

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