04-06-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,810 rows sorted by Province_State

✎ View and edit SQL

This data as json, copyable, CSV (advanced)

Suggested facets: Last_Update

Link rowid FIPS Admin2 Province_State ▼ Country_Region Last_Update Lat Long_ Confirmed Deaths Recovered Active Combined_Key
2630 2630       Afghanistan 4/6/20 23:21 33.93911 67.709953 368 15 18 338 Afghanistan
2631 2631       Albania 4/6/20 23:21 41.1533 20.1683 377 21 116 240 Albania
2632 2632       Algeria 4/6/20 23:21 28.0339 1.6596 1423 173 90 1160 Algeria
2633 2633       Andorra 4/6/20 23:21 42.5063 1.5218 525 21 31 473 Andorra
2634 2634       Angola 4/6/20 23:21 -11.2027 17.8739 16 2 2 12 Angola
2635 2635       Antigua and Barbuda 4/6/20 23:21 17.0608 -61.7964 15 0 0 15 Antigua and Barbuda
2636 2636       Argentina 4/6/20 23:21 -38.4161 -63.6167 1554 48 325 1181 Argentina
2637 2637       Armenia 4/6/20 23:21 40.0691 45.0382 833 8 62 763 Armenia
2638 2638       Austria 4/6/20 23:21 47.5162 14.5501 12297 220 3463 8614 Austria
2639 2639       Azerbaijan 4/6/20 23:21 40.1431 47.5769 641 7 44 590 Azerbaijan
2640 2640       Bahamas 4/6/20 23:21 25.025885 -78.035889 29 5 4 20 Bahamas
2641 2641       Bahrain 4/6/20 23:21 26.0275 50.55 756 4 458 294 Bahrain
2642 2642       Bangladesh 4/6/20 23:21 23.685 90.3563 123 12 33 78 Bangladesh
2643 2643       Barbados 4/6/20 23:21 13.1939 -59.5432 60 2 6 52 Barbados
2644 2644       Belarus 4/6/20 23:21 53.7098 27.9534 700 13 53 634 Belarus
2645 2645       Belgium 4/6/20 23:21 50.8333 4.469936 20814 1632 3986 15196 Belgium
2646 2646       Belize 4/6/20 23:21 17.1899 -88.4976 7 1 0 6 ,,Belize
2647 2647       Benin 4/6/20 23:21 9.3077 2.3158 26 1 5 20 Benin
2648 2648       Bhutan 4/6/20 23:21 27.5142 90.4336 5 0 2 3 Bhutan
2649 2649       Bolivia 4/6/20 23:21 -16.2902 -63.5887 183 11 2 170 Bolivia
2650 2650       Bosnia and Herzegovina 4/6/20 23:21 43.9159 17.6791 674 29 47 598 Bosnia and Herzegovina
2651 2651       Botswana 4/6/20 23:21 -22.3285 24.6849 6 1 0 5 Botswana
2652 2652       Brazil 4/6/20 23:21 -14.235 -51.9253 12161 564 127 11470 Brazil
2653 2653       Brunei 4/6/20 23:21 4.5353 114.7277 135 1 82 52 Brunei
2654 2654       Bulgaria 4/6/20 23:21 42.7339 25.4858 549 22 39 488 Bulgaria
2655 2655       Burkina Faso 4/6/20 23:21 12.2383 -1.5616 364 18 108 238 Burkina Faso
2656 2656       Burma 4/6/20 23:21 21.9162 95.956 22 1 0 21 Burma
2657 2657       Burundi 4/6/20 23:21 -3.3731 29.9189 3 0 0 3 Burundi
2658 2658       Cabo Verde 4/6/20 23:21 16.5388 -23.0418 7 1 1 5 Cabo Verde
2659 2659       Cambodia 4/6/20 23:21 11.55 104.9167 114 0 53 61 Cambodia
2660 2660       Cameroon 4/6/20 23:21 3.848 11.5021 658 9 17 632 Cameroon
2661 2661       Central African Republic 4/6/20 23:21 6.6111 20.9394 8 0 0 8 Central African Republic
2662 2662       Chad 4/6/20 23:21 15.4542 18.7322 9 0 0 9 Chad
2663 2663       Chile 4/6/20 23:21 -35.6751 -71.543 4815 37 728 4050 Chile
2664 2664       Colombia 4/6/20 23:21 4.5709 -74.2973 1579 46 88 1445 Colombia
2665 2665       Congo (Brazzaville) 4/6/20 23:21 -4.2634 15.2832 45 5 2 38 Congo (Brazzaville)
2666 2666       Congo (Kinshasa) 4/6/20 23:21 -4.322447 15.307045 161 18 5 138 Congo (Kinshasa)
2667 2667       Costa Rica 4/6/20 23:21 9.7489 -83.7534 467 2 18 447 Costa Rica
2668 2668       Cote d'Ivoire 4/6/20 23:21 7.54 -5.5471 323 3 41 279 Cote d'Ivoire
2669 2669       Croatia 4/6/20 23:21 45.1 15.2 1222 16 130 1076 Croatia
2670 2670       Cuba 4/6/20 23:21 21.521757 -77.781167 350 9 18 323 Cuba
2671 2671       Cyprus 4/6/20 23:21 35.1264 33.4299 465 9 45 411 Cyprus
2672 2672       Czechia 4/6/20 23:21 49.8175 15.473 4822 78 121 4623 Czechia
2673 2673       Denmark 4/6/20 23:21 56.2639 9.5018 4681 187 1378 3116 Denmark
2674 2674       Diamond Princess 4/6/20 23:21     712 11 619 82 Diamond Princess
2675 2675       Djibouti 4/6/20 23:21 11.8251 42.5903 90 0 9 81 Djibouti
2676 2676       Dominica 4/6/20 23:21 15.415 -61.371 15 0 1 14 Dominica
2677 2677       Dominican Republic 4/6/20 23:21 18.7357 -70.1627 1828 86 33 1709 Dominican Republic
2678 2678       Ecuador 4/6/20 23:21 -1.8312 -78.1834 3747 191 100 3456 Ecuador
2679 2679       Egypt 4/6/20 23:21 26.820553 30.802498 1322 85 259 978 Egypt
2680 2680       El Salvador 4/6/20 23:21 13.7942 -88.8965 69 4 5 60 El Salvador
2681 2681       Equatorial Guinea 4/6/20 23:21 1.6508 10.2679 16 0 3 13 Equatorial Guinea
2682 2682       Eritrea 4/6/20 23:21 15.1794 39.7823 31 0 0 31 Eritrea
2683 2683       Estonia 4/6/20 23:21 58.5953 25.0136 1108 19 62 1027 Estonia
2684 2684       Eswatini 4/6/20 23:21 -26.5225 31.4659 10 0 4 6 Eswatini
2685 2685       Ethiopia 4/6/20 23:21 9.145 40.4897 44 2 4 38 Ethiopia
2686 2686       Fiji 4/6/20 23:21 -17.7134 178.065 14 0 0 14 Fiji
2687 2687       Finland 4/6/20 23:21 61.92411 25.748151 2176 27 300 1849 Finland
2688 2688       France 4/6/20 23:21 46.2276 2.2137 73554 8899 17250 71849 France
2689 2689       Gabon 4/6/20 23:21 -0.8037 11.6094 24 1 1 22 Gabon
2690 2690       Gambia 4/6/20 23:21 13.4432 -15.3101 4 1 2 1 Gambia
2691 2691       Georgia 4/6/20 23:21 42.3154 43.3569 188 2 39 147 Georgia
2692 2692       Germany 4/6/20 23:21 51.165691 10.451526 103374 1810 28700 72864 Germany
2693 2693       Ghana 4/6/20 23:21 7.9465 -1.0232 214 5 31 178 Ghana
2694 2694       Greece 4/6/20 23:21 39.0742 21.8243 1755 79 269 1407 Greece
2695 2695       Grenada 4/6/20 23:21 12.1165 -61.679 12 0 0 12 Grenada
2696 2696       Guatemala 4/6/20 23:21 15.7835 -90.2308 70 3 15 52 Guatemala
2697 2697       Guinea 4/6/20 23:21 9.9456 -9.6966 128 0 5 123 Guinea
2698 2698       Guinea-Bissau 4/6/20 23:21 11.8037 -15.1804 18 0 0 18 Guinea-Bissau
2699 2699       Guyana 4/6/20 23:21 4.860416 -58.93018 31 4 8 19 Guyana
2700 2700       Haiti 4/6/20 23:21 18.9712 -72.2852 21 0 0 23 Haiti
2701 2701       Holy See 4/6/20 23:21 41.9029 12.4534 7 0 0 7 Holy See
2702 2702       Honduras 4/6/20 23:21 15.2 -86.2419 298 22 6 270 Honduras
2703 2703       Hungary 4/6/20 23:21 47.1625 19.5033 744 38 67 639 Hungary
2704 2704       Iceland 4/6/20 23:21 64.9631 -19.0208 1562 6 460 1096 Iceland
2705 2705       India 4/6/20 23:21 20.593684 78.96288 4778 136 375 4267 India
2706 2706       Indonesia 4/6/20 23:21 -0.7893 113.9213 2491 209 192 2090 Indonesia
2707 2707       Iran 4/6/20 23:21 32.427908 53.688046 60500 3739 24236 32525 Iran
2708 2708       Iraq 4/6/20 23:21 33.223191 43.679291 1031 64 344 623 Iraq
2709 2709       Ireland 4/6/20 23:21 53.1424 -7.6921 5364 174 25 5165 Ireland
2710 2710       Israel 4/6/20 23:21 31.046051 34.851612 9191 64 939 8262 Israel
2711 2711       Italy 4/6/20 23:21 41.87194 12.56738 132547 16523 22837 93187 Italy
2712 2712       Jamaica 4/6/20 23:21 18.1096 -77.2975 58 3 8 47 Jamaica
2713 2713       Japan 4/6/20 23:21 36.204824 138.252924 3654 85 575 2994 Japan
2714 2714       Jordan 4/6/20 23:21 31.24 36.51 349 6 126 217 Jordan
2715 2715       Kazakhstan 4/6/20 23:21 48.0196 66.9237 662 6 46 610 Kazakhstan
2716 2716       Kenya 4/6/20 23:21 -0.0236 37.9062 158 6 4 148 Kenya
2717 2717       Korea, South 4/6/20 23:21 35.907757 127.766922 10284 186 6598 3500 Korea, South
2718 2718       Kosovo 4/6/20 23:21 42.602636 20.902977 145 1 23 121 Kosovo
2719 2719       Kuwait 4/6/20 23:21 29.31166 47.481766 665 1 103 561 Kuwait
2720 2720       Kyrgyzstan 4/6/20 23:21 41.20438 74.766098 216 4 33 179 Kyrgyzstan
2721 2721       Laos 4/6/20 23:21 19.85627 102.495496 12 0 0 12 Laos
2722 2722       Latvia 4/6/20 23:21 56.8796 24.6032 542 1 16 525 Latvia
2723 2723       Lebanon 4/6/20 23:21 33.8547 35.8623 541 19 60 462 Lebanon
2724 2724       Liberia 4/6/20 23:21 6.428055 -9.429499 14 3 3 8 Liberia
2725 2725       Libya 4/6/20 23:21 26.3351 17.228331 19 1 1 17 Libya
2726 2726       Liechtenstein 4/6/20 23:21 47.14 9.55 77 1 55 21 Liechtenstein
2727 2727       Lithuania 4/6/20 23:21 55.1694 23.8813 750 10 0 820 Lithuania
2728 2728       Luxembourg 4/6/20 23:21 49.8153 6.1296 2843 41 500 2302 Luxembourg
2729 2729       MS Zaandam 4/6/20 23:21     9 2 0 7 ,,MS Zaandam

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

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