04-12-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,990 rows sorted by Province_State

✎ View and edit SQL

This data as json, copyable, CSV (advanced)

Suggested facets: Last_Update, Last_Update (date)

Link rowid FIPS Admin2 Province_State ▼ Country_Region Last_Update Lat Long_ Confirmed Deaths Recovered Active Combined_Key
2809 2809       Afghanistan 2020-04-12 23:17:00 33.93911 67.709953 608 19 32 557 Afghanistan
2810 2810       Albania 2020-04-12 23:17:00 41.1533 20.1683 446 23 217 206 Albania
2811 2811       Algeria 2020-04-12 23:17:00 28.0339 1.6596 1914 293 591 1030 Algeria
2812 2812       Andorra 2020-04-12 23:17:00 42.5063 1.5218 638 29 128 481 Andorra
2813 2813       Angola 2020-04-12 23:17:00 -11.2027 17.8739 19 2 4 13 Angola
2814 2814       Antigua and Barbuda 2020-04-12 23:17:00 17.0608 -61.7964 21 2 0 19 Antigua and Barbuda
2815 2815       Argentina 2020-04-12 23:17:00 -38.4161 -63.6167 2142 90 468 1584 Argentina
2816 2816       Armenia 2020-04-12 23:17:00 40.0691 45.0382 1013 13 197 803 Armenia
2817 2817       Austria 2020-04-12 23:17:00 47.5162 14.5501 13945 350 6987 6608 Austria
2818 2818       Azerbaijan 2020-04-12 23:17:00 40.1431 47.5769 1098 11 250 837 Azerbaijan
2819 2819       Bahamas 2020-04-12 23:17:00 25.025885 -78.035889 46 8 5 33 Bahamas
2820 2820       Bahrain 2020-04-12 23:17:00 26.0275 50.55 1136 6 558 572 Bahrain
2821 2821       Bangladesh 2020-04-12 23:17:00 23.685 90.3563 621 34 39 548 Bangladesh
2822 2822       Barbados 2020-04-12 23:17:00 13.1939 -59.5432 71 4 11 56 Barbados
2823 2823       Belarus 2020-04-12 23:17:00 53.7098 27.9534 2578 26 203 2349 Belarus
2824 2824       Belgium 2020-04-12 23:17:00 50.8333 4.469936 29647 3600 6463 19584 Belgium
2825 2825       Belize 2020-04-12 23:17:00 17.1899 -88.4976 14 2 0 12 Belize
2826 2826       Benin 2020-04-12 23:17:00 9.3077 2.3158 35 1 5 29 Benin
2827 2827       Bhutan 2020-04-12 23:17:00 27.5142 90.4336 5 0 2 3 Bhutan
2828 2828       Bolivia 2020-04-12 23:17:00 -16.2902 -63.5887 300 24 2 274 Bolivia
2829 2829       Bosnia and Herzegovina 2020-04-12 23:17:00 43.9159 17.6791 1009 39 193 777 Bosnia and Herzegovina
2830 2830       Botswana 2020-04-12 23:17:00 -22.3285 24.6849 13 1 0 12 Botswana
2831 2831       Brazil 2020-04-12 23:17:00 -14.235 -51.9253 22192 1223 173 20796 Brazil
2832 2832       Brunei 2020-04-12 23:17:00 4.5353 114.7277 136 1 106 29 Brunei
2833 2833       Bulgaria 2020-04-12 23:17:00 42.7339 25.4858 675 29 68 578 Bulgaria
2834 2834       Burkina Faso 2020-04-12 23:17:00 12.2383 -1.5616 497 27 161 309 Burkina Faso
2835 2835       Burma 2020-04-12 23:17:00 21.9162 95.956 41 4 2 35 Burma
2836 2836       Burundi 2020-04-12 23:17:00 -3.3731 29.9189 5 0 0 5 Burundi
2837 2837       Cabo Verde 2020-04-12 23:17:00 16.5388 -23.0418 8 1 1 6 Cabo Verde
2838 2838       Cambodia 2020-04-12 23:17:00 11.55 104.9167 122 0 77 45 Cambodia
2839 2839       Cameroon 2020-04-12 23:17:00 3.848 11.5021 820 12 98 710 Cameroon
2840 2840       Central African Republic 2020-04-12 23:17:00 6.6111 20.9394 8 0 0 8 Central African Republic
2841 2841       Chad 2020-04-12 23:17:00 15.4542 18.7322 18 0 2 16 Chad
2842 2842       Chile 2020-04-12 23:17:00 -35.6751 -71.543 7213 80 2059 5074 Chile
2843 2843       Colombia 2020-04-12 23:17:00 4.5709 -74.2973 2776 109 270 2397 Colombia
2844 2844       Congo (Brazzaville) 2020-04-12 23:17:00 -4.2634 15.2832 60 5 5 50 Congo (Brazzaville)
2845 2845       Congo (Kinshasa) 2020-04-12 23:17:00 -4.322447 15.307045 234 20 16 198 Congo (Kinshasa)
2846 2846       Costa Rica 2020-04-12 23:17:00 9.7489 -83.7534 595 3 56 536 Costa Rica
2847 2847       Cote d'Ivoire 2020-04-12 23:17:00 7.54 -5.5471 574 5 85 484 Cote d'Ivoire
2848 2848       Croatia 2020-04-12 23:17:00 45.1 15.2 1600 23 373 1204 Croatia
2849 2849       Cuba 2020-04-12 23:17:00 21.521757 -77.781167 669 18 92 559 Cuba
2850 2850       Cyprus 2020-04-12 23:17:00 35.1264 33.4299 633 11 65 557 Cyprus
2851 2851       Czechia 2020-04-12 23:17:00 49.8175 15.473 5991 138 464 5389 Czechia
2852 2852       Denmark 2020-04-12 23:17:00 56.2639 9.5018 6174 273 2123 3778 Denmark
2853 2853       Diamond Princess 2020-04-12 23:17:00     712 11 619 82 Diamond Princess
2854 2854       Djibouti 2020-04-12 23:17:00 11.8251 42.5903 214 2 36 176 Djibouti
2855 2855       Dominica 2020-04-12 23:17:00 15.415 -61.371 16 0 8 8 Dominica
2856 2856       Dominican Republic 2020-04-12 23:17:00 18.7357 -70.1627 2967 173 131 2663 Dominican Republic
2857 2857       Ecuador 2020-04-12 23:17:00 -1.8312 -78.1834 7466 333 501 6632 Ecuador
2858 2858       Egypt 2020-04-12 23:17:00 26.820553 30.802498 2065 159 589 1317 Egypt
2859 2859       El Salvador 2020-04-12 23:17:00 13.7942 -88.8965 125 6 21 98 El Salvador
2860 2860       Equatorial Guinea 2020-04-12 23:17:00 1.6508 10.2679 21 0 3 18 Equatorial Guinea
2861 2861       Eritrea 2020-04-12 23:17:00 15.1794 39.7823 34 0 0 34 Eritrea
2862 2862       Estonia 2020-04-12 23:17:00 58.5953 25.0136 1309 25 98 1186 Estonia
2863 2863       Eswatini 2020-04-12 23:17:00 -26.5225 31.4659 14 0 7 7 Eswatini
2864 2864       Ethiopia 2020-04-12 23:17:00 9.145 40.4897 71 3 10 58 Ethiopia
2865 2865       Fiji 2020-04-12 23:17:00 -17.7134 178.065 16 0 0 16 Fiji
2866 2866       Finland 2020-04-12 23:17:00 61.92411 25.748151 2974 56 300 2618 Finland
2867 2867 250     France 2020-04-12 23:17:00 46.2276 2.2137 119670 14377 27186 91012 France
2868 2868       Gabon 2020-04-12 23:17:00 -0.8037 11.6094 49 1 1 47 Gabon
2869 2869       Gambia 2020-04-12 23:17:00 13.4432 -15.3101 9 1 2 6 Gambia
2870 2870       Georgia 2020-04-12 23:17:00 42.3154 43.3569 257 3 67 187 Georgia
2871 2871       Germany 2020-04-12 23:17:00 51.165691 10.451526 127854 3022 60300 64532 Germany
2872 2872       Ghana 2020-04-12 23:17:00 7.9465 -1.0232 566 8 4 554 Ghana
2873 2873       Greece 2020-04-12 23:17:00 39.0742 21.8243 2114 98 269 1747 Greece
2874 2874       Grenada 2020-04-12 23:17:00 12.1165 -61.679 14 0 0 14 Grenada
2875 2875       Guatemala 2020-04-12 23:17:00 15.7835 -90.2308 155 5 19 131 Guatemala
2876 2876       Guinea 2020-04-12 23:17:00 9.9456 -9.6966 250 0 17 233 Guinea
2877 2877       Guinea-Bissau 2020-04-12 23:17:00 11.8037 -15.1804 38 0 0 38 Guinea-Bissau
2878 2878       Guyana 2020-04-12 23:17:00 4.860416 -58.93018 45 6 8 31 Guyana
2879 2879       Haiti 2020-04-12 23:17:00 18.9712 -72.2852 31 2 0 30 Haiti
2880 2880       Holy See 2020-04-12 23:17:00 41.9029 12.4534 8 0 2 6 Holy See
2881 2881       Honduras 2020-04-12 23:17:00 15.2 -86.2419 393 25 7 361 Honduras
2882 2882       Hungary 2020-04-12 23:17:00 47.1625 19.5033 1410 99 118 1193 Hungary
2883 2883       Iceland 2020-04-12 23:17:00 64.9631 -19.0208 1701 8 889 804 Iceland
2884 2884       India 2020-04-12 23:17:00 20.593684 78.96288 9205 331 1080 7794 India
2885 2885       Indonesia 2020-04-12 23:17:00 -0.7893 113.9213 4241 373 359 3509 Indonesia
2886 2886       Iran 2020-04-12 23:17:00 32.427908 53.688046 71686 4474 43894 23318 Iran
2887 2887       Iraq 2020-04-12 23:17:00 33.223191 43.679291 1352 76 640 636 Iraq
2888 2888       Ireland 2020-04-12 23:17:00 53.1424 -7.6921 9655 334 25 9296 Ireland
2889 2889       Israel 2020-04-12 23:17:00 31.046051 34.851612 11504 109 1909 9415 Israel
2890 2890       Italy 2020-04-12 23:17:00 41.87194 12.56738 156363 19899 34211 102253 Italy
2891 2891       Jamaica 2020-04-12 23:17:00 18.1096 -77.2975 69 4 13 52 Jamaica
2892 2892       Japan 2020-04-12 23:17:00 36.204824 138.252924 6748 108 762 5878 Japan
2893 2893       Jordan 2020-04-12 23:17:00 31.24 36.51 389 7 201 181 Jordan
2894 2894       Kazakhstan 2020-04-12 23:17:00 48.0196 66.9237 951 10 99 842 Kazakhstan
2895 2895       Kenya 2020-04-12 23:17:00 -0.0236 37.9062 197 8 25 164 Kenya
2896 2896       Korea, South 2020-04-12 23:17:00 35.907757 127.766922 10512 214 7368 2930 Korea, South
2897 2897       Kosovo 2020-04-12 23:17:00 42.602636 20.902977 283 7 58 218 Kosovo
2898 2898       Kuwait 2020-04-12 23:17:00 29.31166 47.481766 1234 1 142 1091 Kuwait
2899 2899       Kyrgyzstan 2020-04-12 23:17:00 41.20438 74.766098 377 5 54 318 Kyrgyzstan
2900 2900       Laos 2020-04-12 23:17:00 19.85627 102.495496 19 0 0 19 Laos
2901 2901       Latvia 2020-04-12 23:17:00 56.8796 24.6032 651 5 16 630 Latvia
2902 2902       Lebanon 2020-04-12 23:17:00 33.8547 35.8623 630 20 80 530 Lebanon
2903 2903       Liberia 2020-04-12 23:17:00 6.428055 -9.429499 50 5 3 42 Liberia
2904 2904       Libya 2020-04-12 23:17:00 26.3351 17.228331 25 1 9 15 Libya
2905 2905       Liechtenstein 2020-04-12 23:17:00 47.14 9.55 79 1 55 23 Liechtenstein
2906 2906       Lithuania 2020-04-12 23:17:00 55.1694 23.8813 952 14 2 933 Lithuania
2907 2907       Luxembourg 2020-04-12 23:17:00 49.8153 6.1296 3281 66 500 2715 Luxembourg
2908 2908       MS Zaandam 2020-04-12 23:17:00     9 2 0 7 MS Zaandam

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

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