04-05-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,765 rows sorted by Province_State

✎ 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
2586 2586       Afghanistan 2020-04-05 23:06:26 33.93911 67.709953 338 12 15 327 Afghanistan
2587 2587       Albania 2020-04-05 23:06:26 41.1533 20.1683 361 20 104 237 Albania
2588 2588       Algeria 2020-04-05 23:06:26 28.0339 1.6596 1320 152 90 1078 Algeria
2589 2589       Andorra 2020-04-05 23:06:26 42.5063 1.5218 501 18 26 457 Andorra
2590 2590       Angola 2020-04-05 23:06:26 -11.2027 17.8739 14 2 2 10 Angola
2591 2591       Antigua and Barbuda 2020-04-05 23:06:26 17.0608 -61.7964 15 0 0 15 Antigua and Barbuda
2592 2592       Argentina 2020-04-05 23:06:26 -38.4161 -63.6167 1451 44 280 1127 Argentina
2593 2593       Armenia 2020-04-05 23:06:26 40.0691 45.0382 822 7 57 758 Armenia
2594 2594       Austria 2020-04-05 23:06:26 47.5162 14.5501 12051 204 2998 8849 Austria
2595 2595       Azerbaijan 2020-04-05 23:06:26 40.1431 47.5769 584 7 32 545 Azerbaijan
2596 2596       Bahamas 2020-04-05 23:06:26 25.025885 -78.035889 28 4 0 24 Bahamas
2597 2597       Bahrain 2020-04-05 23:06:26 26.0275 50.55 700 4 431 265 Bahrain
2598 2598       Bangladesh 2020-04-05 23:06:26 23.685 90.3563 88 9 33 46 Bangladesh
2599 2599       Barbados 2020-04-05 23:06:26 13.1939 -59.5432 56 1 6 49 Barbados
2600 2600       Belarus 2020-04-05 23:06:26 53.7098 27.9534 562 8 52 502 Belarus
2601 2601       Belgium 2020-04-05 23:06:26 50.8333 4.469936 19691 1447 3751 14493 Belgium
2602 2602       Belize 2020-04-05 23:06:26 17.1899 -88.4976 5 0 0 5 ,,Belize
2603 2603       Benin 2020-04-05 23:06:26 9.3077 2.3158 22 0 5 17 Benin
2604 2604       Bhutan 2020-04-05 23:06:26 27.5142 90.4336 5 0 2 3 Bhutan
2605 2605       Bolivia 2020-04-05 23:06:26 -16.2902 -63.5887 157 10 2 145 Bolivia
2606 2606       Bosnia and Herzegovina 2020-04-05 23:06:26 43.9159 17.6791 654 23 30 601 Bosnia and Herzegovina
2607 2607       Botswana 2020-04-05 23:06:26 -22.3285 24.6849 6 1 0 5 Botswana
2608 2608       Brazil 2020-04-05 23:06:26 -14.235 -51.9253 11130 486 127 10517 Brazil
2609 2609       Brunei 2020-04-05 23:06:26 4.5353 114.7277 135 1 73 61 Brunei
2610 2610       Bulgaria 2020-04-05 23:06:26 42.7339 25.4858 531 20 37 474 Bulgaria
2611 2611       Burkina Faso 2020-04-05 23:06:26 12.2383 -1.5616 345 17 90 238 Burkina Faso
2612 2612       Burma 2020-04-05 23:06:26 21.9162 95.956 21 1 0 20 Burma
2613 2613       Burundi 2020-04-05 23:06:26 -3.3731 29.9189 3 0 0 3 Burundi
2614 2614       Cabo Verde 2020-04-05 23:06:26 16.5388 -23.0418 7 1 0 6 Cabo Verde
2615 2615       Cambodia 2020-04-05 23:06:26 11.55 104.9167 114 0 50 64 Cambodia
2616 2616       Cameroon 2020-04-05 23:06:26 3.8480000000000003 11.5021 650 9 17 624 Cameroon
2617 2617       Central African Republic 2020-04-05 23:06:26 6.6111 20.9394 8 0 0 8 Central African Republic
2618 2618       Chad 2020-04-05 23:06:26 15.4542 18.7322 9 0 0 9 Chad
2619 2619       Chile 2020-04-05 23:06:26 -35.6751 -71.543 4471 34 618 3819 Chile
2620 2620       Colombia 2020-04-05 23:06:26 4.5709 -74.2973 1485 35 88 1362 Colombia
2621 2621       Congo (Brazzaville) 2020-04-05 23:06:26 -4.2634 15.2832 45 5 2 38 Congo (Brazzaville)
2622 2622       Congo (Kinshasa) 2020-04-05 23:06:26 -4.322447 15.307045 154 18 3 133 Congo (Kinshasa)
2623 2623       Costa Rica 2020-04-05 23:06:26 9.7489 -83.7534 454 2 16 436 Costa Rica
2624 2624       Cote d'Ivoire 2020-04-05 23:06:26 7.54 -5.5471 261 3 37 221 Cote d'Ivoire
2625 2625       Croatia 2020-04-05 23:06:26 45.1 15.2 1182 15 125 1042 Croatia
2626 2626       Cuba 2020-04-05 23:06:26 21.521757 -77.78116700000002 320 8 15 297 Cuba
2627 2627       Cyprus 2020-04-05 23:06:26 35.1264 33.4299 446 9 37 400 Cyprus
2628 2628       Czechia 2020-04-05 23:06:26 49.8175 15.472999999999999 4587 67 96 4424 Czechia
2629 2629       Denmark 2020-04-05 23:06:26 56.2639 9.5018 4369 179 1327 2863 Denmark
2630 2630       Diamond Princess 2020-04-05 23:06:26     712 11 619 82 Diamond Princess
2631 2631       Djibouti 2020-04-05 23:06:26 11.8251 42.5903 59 0 9 50 Djibouti
2632 2632       Dominica 2020-04-05 23:06:26 15.415 -61.371 14 0 0 14 Dominica
2633 2633       Dominican Republic 2020-04-05 23:06:26 18.7357 -70.1627 1745 82 17 1646 Dominican Republic
2634 2634       Ecuador 2020-04-05 23:06:26 -1.8312 -78.1834 3646 180 100 3366 Ecuador
2635 2635       Egypt 2020-04-05 23:06:26 26.820553000000004 30.802497999999996 1173 78 247 848 Egypt
2636 2636       El Salvador 2020-04-05 23:06:26 13.7942 -88.8965 62 3 2 57 El Salvador
2637 2637       Equatorial Guinea 2020-04-05 23:06:26 1.6508 10.2679 16 0 1 15 Equatorial Guinea
2638 2638       Eritrea 2020-04-05 23:06:26 15.1794 39.7823 29 0 0 29 Eritrea
2639 2639       Estonia 2020-04-05 23:06:26 58.5953 25.0136 1097 15 62 1020 Estonia
2640 2640       Eswatini 2020-04-05 23:06:26 -26.5225 31.4659 9 0 0 9 Eswatini
2641 2641       Ethiopia 2020-04-05 23:06:26 9.145 40.4897 43 2 4 37 Ethiopia
2642 2642       Fiji 2020-04-05 23:06:26 -17.7134 178.065 12 0 0 12 Fiji
2643 2643       Finland 2020-04-05 23:06:26 61.92411 25.748151 1927 28 300 1599 Finland
2644 2644       France 2020-04-05 23:06:26 46.2276 2.2137 69660 8066 16183 68578 France
2645 2645       Gabon 2020-04-05 23:06:26 -0.8037 11.6094 21 1 1 19 Gabon
2646 2646       Gambia 2020-04-05 23:06:26 13.4432 -15.3101 4 1 2 1 Gambia
2647 2647       Georgia 2020-04-05 23:06:26 42.3154 43.3569 174 2 36 136 Georgia
2648 2648       Germany 2020-04-05 23:06:26 51.165690999999995 10.451526 100123 1584 28700 69839 Germany
2649 2649       Ghana 2020-04-05 23:06:26 7.9465 -1.0232 214 5 31 178 Ghana
2650 2650       Greece 2020-04-05 23:06:26 39.0742 21.8243 1735 73 78 1584 Greece
2651 2651       Grenada 2020-04-05 23:06:26 12.1165 -61.678999999999995 12 0 0 12 Grenada
2652 2652       Guatemala 2020-04-05 23:06:26 15.7835 -90.2308 61 2 15 44 Guatemala
2653 2653       Guinea 2020-04-05 23:06:26 9.9456 -9.6966 121 0 5 116 Guinea
2654 2654       Guinea-Bissau 2020-04-05 23:06:26 11.8037 -15.1804 18 0 0 18 Guinea-Bissau
2655 2655       Guyana 2020-04-05 23:06:26 4.860416000000002 -58.93018000000001 24 4 0 20 Guyana
2656 2656       Haiti 2020-04-05 23:06:26 18.9712 -72.2852 18 0 1 19 Haiti
2657 2657       Holy See 2020-04-05 23:06:26 41.9029 12.4534 7 0 0 7 Holy See
2658 2658       Honduras 2020-04-05 23:06:26 15.2 -86.2419 268 22 6 240 Honduras
2659 2659       Hungary 2020-04-05 23:06:26 47.1625 19.5033 733 34 66 633 Hungary
2660 2660       Iceland 2020-04-05 23:06:26 64.9631 -19.0208 1486 4 428 1054 Iceland
2661 2661       India 2020-04-05 23:06:26 20.593684 78.96288 3588 99 229 3260 India
2662 2662       Indonesia 2020-04-05 23:06:26 -0.7893 113.9213 2273 198 164 1911 Indonesia
2663 2663       Iran 2020-04-05 23:06:26 32.427908 53.68804599999999 58226 3603 19736 34887 Iran
2664 2664       Iraq 2020-04-05 23:06:26 33.223191 43.679291 961 61 279 621 Iraq
2665 2665       Ireland 2020-04-05 23:06:26 53.1424 -7.6921 4994 158 25 4811 Ireland
2666 2666       Israel 2020-04-05 23:06:26 31.046051000000002 34.851612 8740 56 820 7904 Israel
2667 2667       Italy 2020-04-05 23:06:26 41.87194 12.56738 128948 15887 21815 91246 Italy
2668 2668       Jamaica 2020-04-05 23:06:26 18.1096 -77.2975 58 3 8 47 Jamaica
2669 2669       Japan 2020-04-05 23:06:26 36.204824 138.252924 3139 77 514 2548 Japan
2670 2670       Jordan 2020-04-05 23:06:26 31.24 36.51 345 5 110 230 Jordan
2671 2671       Kazakhstan 2020-04-05 23:06:26 48.0196 66.9237 584 6 42 536 Kazakhstan
2672 2672       Kenya 2020-04-05 23:06:26 -0.0236 37.9062 142 4 4 134 Kenya
2673 2673       Korea, South 2020-04-05 23:06:26 35.90775700000001 127.766922 10237 183 6463 3591 Korea, South
2674 2674       Kosovo 2020-04-05 23:06:26 42.602636 20.902977 145 1 23 121 Kosovo
2675 2675       Kuwait 2020-04-05 23:06:26 29.311659999999996 47.481766 556 1 99 456 Kuwait
2676 2676       Kyrgyzstan 2020-04-05 23:06:26 41.20438 74.766098 147 1 9 137 Kyrgyzstan
2677 2677       Laos 2020-04-05 23:06:26 19.856270000000002 102.495496 11 0 0 11 Laos
2678 2678       Latvia 2020-04-05 23:06:26 56.8796 24.6032 533 1 1 531 Latvia
2679 2679       Lebanon 2020-04-05 23:06:26 33.8547 35.8623 527 18 54 455 Lebanon
2680 2680       Liberia 2020-04-05 23:06:26 6.4280550000000005 -9.429499 13 3 3 7 Liberia
2681 2681       Libya 2020-04-05 23:06:26 26.3351 17.228331 18 1 0 17 Libya
2682 2682       Liechtenstein 2020-04-05 23:06:26 47.14 9.55 77 1 0 76 Liechtenstein
2683 2683       Lithuania 2020-04-05 23:06:26 55.1694 23.8813 716 8 0 791 Lithuania
2684 2684       Luxembourg 2020-04-05 23:06:26 49.8153 6.1296 2804 36 500 2268 Luxembourg
2685 2685       MS Zaandam 2020-04-05 23:06:26     9 2 0 7 ,,MS Zaandam

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

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