04-10-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,943 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
2762 2762       Afghanistan 2020-04-10 22:53:48 33.93911 67.709953 532 18 32 474 Afghanistan
2763 2763       Albania 2020-04-10 22:53:48 41.1533 20.1683 416 23 182 211 Albania
2764 2764       Algeria 2020-04-10 22:53:48 28.0339 1.6596 1761 256 405 1100 Algeria
2765 2765       Andorra 2020-04-10 22:53:48 42.5063 1.5218 601 26 71 504 Andorra
2766 2766       Angola 2020-04-10 22:53:48 -11.2027 17.8739 19 2 2 15 Angola
2767 2767       Antigua and Barbuda 2020-04-10 22:53:48 17.0608 -61.7964 19 2 0 17 Antigua and Barbuda
2768 2768       Argentina 2020-04-10 22:53:48 -38.4161 -63.6167 1975 82 375 1518 Argentina
2769 2769       Armenia 2020-04-10 22:53:48 40.0691 45.0382 937 12 149 776 Armenia
2770 2770       Austria 2020-04-10 22:53:48 47.5162 14.5501 13555 319 6064 7172 Austria
2771 2771       Azerbaijan 2020-04-10 22:53:48 40.1431 47.5769 991 10 159 822 Azerbaijan
2772 2772       Bahamas 2020-04-10 22:53:48 25.025885 -78.035889 42 8 5 29 Bahamas
2773 2773       Bahrain 2020-04-10 22:53:48 26.0275 50.55 925 6 539 380 Bahrain
2774 2774       Bangladesh 2020-04-10 22:53:48 23.685 90.3563 424 27 33 364 Bangladesh
2775 2775       Barbados 2020-04-10 22:53:48 13.1939 -59.5432 67 4 11 52 Barbados
2776 2776       Belarus 2020-04-10 22:53:48 53.7098 27.9534 1981 19 169 1793 Belarus
2777 2777       Belgium 2020-04-10 22:53:48 50.8333 4.469936 26667 3019 5568 18080 Belgium
2778 2778       Belize 2020-04-10 22:53:48 17.1899 -88.4976 10 2 0 8 ,,Belize
2779 2779       Benin 2020-04-10 22:53:48 9.3077 2.3158 35 1 5 29 Benin
2780 2780       Bhutan 2020-04-10 22:53:48 27.5142 90.4336 5 0 2 3 Bhutan
2781 2781       Bolivia 2020-04-10 22:53:48 -16.2902 -63.5887 268 19 2 247 Bolivia
2782 2782       Bosnia and Herzegovina 2020-04-10 22:53:48 43.9159 17.6791 901 36 129 736 Bosnia and Herzegovina
2783 2783       Botswana 2020-04-10 22:53:48 -22.3285 24.6849 13 1 0 12 Botswana
2784 2784       Brazil 2020-04-10 22:53:48 -14.235 -51.9253 19638 1057 173 18408 Brazil
2785 2785       Brunei 2020-04-10 22:53:48 4.5353 114.7277 136 1 99 36 Brunei
2786 2786       Bulgaria 2020-04-10 22:53:48 42.7339 25.4858 635 25 54 556 Bulgaria
2787 2787       Burkina Faso 2020-04-10 22:53:48 12.2383 -1.5616 443 24 146 273 Burkina Faso
2788 2788       Burma 2020-04-10 22:53:48 21.9162 95.956 27 3 2 22 Burma
2789 2789       Burundi 2020-04-10 22:53:48 -3.3731 29.9189 3 0 0 3 Burundi
2790 2790       Cabo Verde 2020-04-10 22:53:48 16.5388 -23.0418 7 1 1 5 Cabo Verde
2791 2791       Cambodia 2020-04-10 22:53:48 11.55 104.9167 119 0 72 47 Cambodia
2792 2792       Cameroon 2020-04-10 22:53:48 3.8480000000000003 11.5021 820 12 98 710 Cameroon
2793 2793       Central African Republic 2020-04-10 22:53:48 6.6111 20.9394 8 0 0 8 Central African Republic
2794 2794       Chad 2020-04-10 22:53:48 15.4542 18.7322 11 0 2 9 Chad
2795 2795       Chile 2020-04-10 22:53:48 -35.6751 -71.543 6501 65 1571 4865 Chile
2796 2796       Colombia 2020-04-10 22:53:48 4.5709 -74.2973 2473 80 197 2196 Colombia
2797 2797       Congo (Brazzaville) 2020-04-10 22:53:48 -4.2634 15.2832 60 5 5 50 Congo (Brazzaville)
2798 2798       Congo (Kinshasa) 2020-04-10 22:53:48 -4.322447 15.307045 215 20 13 182 Congo (Kinshasa)
2799 2799       Costa Rica 2020-04-10 22:53:48 9.7489 -83.7534 558 3 42 513 Costa Rica
2800 2800       Cote d'Ivoire 2020-04-10 22:53:48 7.54 -5.5471 444 3 52 389 Cote d'Ivoire
2801 2801       Croatia 2020-04-10 22:53:48 45.1 15.2 1495 21 231 1243 Croatia
2802 2802       Cuba 2020-04-10 22:53:48 21.521757 -77.78116700000002 564 15 51 498 Cuba
2803 2803       Cyprus 2020-04-10 22:53:48 35.1264 33.4299 595 10 58 527 Cyprus
2804 2804       Czechia 2020-04-10 22:53:48 49.8175 15.472999999999999 5732 119 346 5267 Czechia
2805 2805       Denmark 2020-04-10 22:53:48 56.2639 9.5018 5819 247 1773 3799 Denmark
2806 2806       Diamond Princess 2020-04-10 22:53:48     712 11 619 82 Diamond Princess
2807 2807       Djibouti 2020-04-10 22:53:48 11.8251 42.5903 150 1 36 113 Djibouti
2808 2808       Dominica 2020-04-10 22:53:48 15.415 -61.371 16 0 5 11 Dominica
2809 2809       Dominican Republic 2020-04-10 22:53:48 18.7357 -70.1627 2620 126 98 2396 Dominican Republic
2810 2810       Ecuador 2020-04-10 22:53:48 -1.8312 -78.1834 7161 297 368 6496 Ecuador
2811 2811       Egypt 2020-04-10 22:53:48 26.820553000000004 30.802497999999996 1794 135 384 1275 Egypt
2812 2812       El Salvador 2020-04-10 22:53:48 13.7942 -88.8965 117 6 15 96 El Salvador
2813 2813       Equatorial Guinea 2020-04-10 22:53:48 1.6508 10.2679 18 0 3 15 Equatorial Guinea
2814 2814       Eritrea 2020-04-10 22:53:48 15.1794 39.7823 34 0 0 34 Eritrea
2815 2815       Estonia 2020-04-10 22:53:48 58.5953 25.0136 1258 24 93 1141 Estonia
2816 2816       Eswatini 2020-04-10 22:53:48 -26.5225 31.4659 12 0 7 5 Eswatini
2817 2817       Ethiopia 2020-04-10 22:53:48 9.145 40.4897 65 3 4 58 Ethiopia
2818 2818       Fiji 2020-04-10 22:53:48 -17.7134 178.065 16 0 0 16 Fiji
2819 2819       Finland 2020-04-10 22:53:48 61.92411 25.748151 2769 48 300 2421 Finland
2820 2820 250     France 2020-04-10 22:53:48 46.2276 2.2137 89731 13181 24932 86740 ,,France
2821 2821       Gabon 2020-04-10 22:53:48 -0.8037 11.6094 44 1 1 42 Gabon
2822 2822       Gambia 2020-04-10 22:53:48 13.4432 -15.3101 4 1 2 1 Gambia
2823 2823       Georgia 2020-04-10 22:53:48 42.3154 43.3569 234 3 54 177 Georgia
2824 2824       Germany 2020-04-10 22:53:48 51.165690999999995 10.451526 122171 2767 53913 65491 Germany
2825 2825       Ghana 2020-04-10 22:53:48 7.9465 -1.0232 378 6 4 368 Ghana
2826 2826       Greece 2020-04-10 22:53:48 39.0742 21.8243 2011 92 269 1650 Greece
2827 2827       Grenada 2020-04-10 22:53:48 12.1165 -61.678999999999995 14 0 0 14 Grenada
2828 2828       Guatemala 2020-04-10 22:53:48 15.7835 -90.2308 126 3 17 106 Guatemala
2829 2829       Guinea 2020-04-10 22:53:48 9.9456 -9.6966 212 0 15 197 Guinea
2830 2830       Guinea-Bissau 2020-04-10 22:53:48 11.8037 -15.1804 36 0 0 36 Guinea-Bissau
2831 2831       Guyana 2020-04-10 22:53:48 4.860416000000002 -58.93018000000001 37 6 8 23 Guyana
2832 2832       Haiti 2020-04-10 22:53:48 18.9712 -72.2852 30 2 0 29 Haiti
2833 2833       Holy See 2020-04-10 22:53:48 41.9029 12.4534 8 0 2 6 Holy See
2834 2834       Honduras 2020-04-10 22:53:48 15.2 -86.2419 382 23 7 352 Honduras
2835 2835       Hungary 2020-04-10 22:53:48 47.1625 19.5033 1190 77 112 1001 Hungary
2836 2836       Iceland 2020-04-10 22:53:48 64.9631 -19.0208 1675 7 751 917 Iceland
2837 2837       India 2020-04-10 22:53:48 20.593684 78.96288 7598 246 774 6578 India
2838 2838       Indonesia 2020-04-10 22:53:48 -0.7893 113.9213 3512 306 282 2924 Indonesia
2839 2839       Iran 2020-04-10 22:53:48 32.427908 53.68804599999999 68192 4232 35465 28495 Iran
2840 2840       Iraq 2020-04-10 22:53:48 33.223191 43.679291 1279 70 550 659 Iraq
2841 2841       Ireland 2020-04-10 22:53:48 53.1424 -7.6921 8089 287 25 7777 Ireland
2842 2842       Israel 2020-04-10 22:53:48 31.046051000000002 34.851612 10607 97 1460 9130 Israel
2843 2843       Italy 2020-04-10 22:53:48 41.87194 12.56738 147577 18849 30455 98273 Italy
2844 2844       Jamaica 2020-04-10 22:53:48 18.1096 -77.2975 63 4 13 46 Jamaica
2845 2845       Japan 2020-04-10 22:53:48 36.204824 138.252924 5530 99 685 4746 Japan
2846 2846       Jordan 2020-04-10 22:53:48 31.24 36.51 372 7 170 195 Jordan
2847 2847       Kazakhstan 2020-04-10 22:53:48 48.0196 66.9237 812 10 64 738 Kazakhstan
2848 2848       Kenya 2020-04-10 22:53:48 -0.0236 37.9062 189 7 22 160 Kenya
2849 2849       Korea, South 2020-04-10 22:53:48 35.90775700000001 127.766922 10450 208 7117 3125 Korea, South
2850 2850       Kosovo 2020-04-10 22:53:48 42.602636 20.902977 250 7 52 191 Kosovo
2851 2851       Kuwait 2020-04-10 22:53:48 29.311659999999996 47.481766 993 1 123 869 Kuwait
2852 2852       Kyrgyzstan 2020-04-10 22:53:48 41.20438 74.766098 298 5 35 258 Kyrgyzstan
2853 2853       Laos 2020-04-10 22:53:48 19.856270000000002 102.495496 16 0 0 16 Laos
2854 2854       Latvia 2020-04-10 22:53:48 56.8796 24.6032 612 3 16 593 Latvia
2855 2855       Lebanon 2020-04-10 22:53:48 33.8547 35.8623 609 20 76 513 Lebanon
2856 2856       Liberia 2020-04-10 22:53:48 6.4280550000000005 -9.429499 37 5 3 29 Liberia
2857 2857       Libya 2020-04-10 22:53:48 26.3351 17.228331 24 1 8 15 Libya
2858 2858       Liechtenstein 2020-04-10 22:53:48 47.14 9.55 79 1 55 23 Liechtenstein
2859 2859       Lithuania 2020-04-10 22:53:48 55.1694 23.8813 896 12 2 923 Lithuania
2860 2860       Luxembourg 2020-04-10 22:53:48 49.8153 6.1296 3223 54 500 2669 Luxembourg
2861 2861       MS Zaandam 2020-04-10 22:53:48     9 2 0 7 ,,MS Zaandam

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

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