04-23-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

3,122 rows sorted by Country_Region

✎ 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
2934 2934       Afghanistan 2020-04-24 03:30:31 33.93911 67.709953 1236 40 179 1058 Afghanistan
2935 2935       Albania 2020-04-24 03:30:31 41.1533 20.1683 663 27 385 251 Albania
2936 2936       Algeria 2020-04-24 03:30:31 28.0339 1.6596 3007 407 1355 1245 Algeria
2937 2937       Andorra 2020-04-24 03:30:31 42.5063 1.5218 723 37 333 353 Andorra
2938 2938       Angola 2020-04-24 03:30:31 -11.2027 17.8739 25 2 6 17 Angola
2939 2939       Antigua and Barbuda 2020-04-24 03:30:31 17.0608 -61.7964 24 3 10 11 Antigua and Barbuda
2940 2940       Argentina 2020-04-24 03:30:31 -38.4161 -63.6167 3435 165 919 2351 Argentina
2941 2941       Armenia 2020-04-24 03:30:31 40.0691 45.0382 1523 24 659 840 Armenia
3115 3115     Australian Capital Territory Australia 2020-04-24 03:31:35 -35.4735 149.0124 104 3 88 13 Australian Capital Territory, Australia
3116 3116     New South Wales Australia 2020-04-24 03:31:35 -33.8688 151.2093 2976 31 1379 1566 New South Wales, Australia
3117 3117     Northern Territory Australia 2020-04-24 03:31:35 -12.4634 130.8456 27 0 9 18 Northern Territory, Australia
3118 3118     Queensland Australia 2020-04-24 03:31:35 -27.4698 153.0251 1026 6 738 282 Queensland, Australia
3119 3119     South Australia Australia 2020-04-24 03:31:35 -34.9285 138.6007 438 4 331 103 South Australia, Australia
3120 3120     Tasmania Australia 2020-04-24 03:31:35 -42.8821 147.3272 207 8 67 132 Tasmania, Australia
3121 3121     Victoria Australia 2020-04-24 03:31:35 -37.8136 144.9631 1337 16 1172 149 Victoria, Australia
3122 3122     Western Australia Australia 2020-04-24 03:31:35 -31.9505 115.8605 546 7 340 199 Western Australia, Australia
2942 2942       Austria 2020-04-24 03:30:31 47.5162 14.5501 15002 522 11694 2786 Austria
2943 2943       Azerbaijan 2020-04-24 03:30:31 40.1431 47.5769 1548 20 948 580 Azerbaijan
2944 2944       Bahamas 2020-04-24 03:30:31 25.025885 -78.035889 72 11 14 47 Bahamas
2945 2945       Bahrain 2020-04-24 03:30:31 26.0275 50.55 2217 8 1082 1127 Bahrain
2946 2946       Bangladesh 2020-04-24 03:30:31 23.685 90.3563 4186 127 108 3951 Bangladesh
2947 2947       Barbados 2020-04-24 03:30:31 13.1939 -59.5432 76 6 30 40 Barbados
2948 2948       Belarus 2020-04-24 03:30:31 53.7098 27.9534 8022 60 938 7024 Belarus
2949 2949       Belgium 2020-04-24 03:30:31 50.8333 4.469936 42797 6490 9800 26507 Belgium
2950 2950       Belize 2020-04-24 03:30:31 17.1899 -88.4976 18 2 5 11 Belize
2951 2951       Benin 2020-04-24 03:30:31 9.3077 2.3158 54 1 27 26 Benin
2952 2952       Bhutan 2020-04-24 03:30:31 27.5142 90.4336 7 0 3 4 Bhutan
2953 2953       Bolivia 2020-04-24 03:30:31 -16.2902 -63.5887 703 43 44 616 Bolivia
2954 2954       Bosnia and Herzegovina 2020-04-24 03:30:31 43.9159 17.6791 1413 54 485 874 Bosnia and Herzegovina
2955 2955       Botswana 2020-04-24 03:30:31 -22.3285 24.6849 22 1 0 21 Botswana
2956 2956       Brazil 2020-04-24 03:30:31 -14.235 -51.9253 50036 3331 26573 20132 Brazil
2957 2957       Brunei 2020-04-24 03:30:31 4.5353 114.7277 138 1 119 18 Brunei
2958 2958       Bulgaria 2020-04-24 03:30:31 42.7339 25.4858 1097 52 190 855 Bulgaria
2959 2959       Burkina Faso 2020-04-24 03:30:31 12.2383 -1.5616 616 41 410 165 Burkina Faso
2960 2960       Burma 2020-04-24 03:30:31 21.9162 95.956 139 5 9 125 Burma
2961 2961       Burundi 2020-04-24 03:30:31 -3.3731 29.9189 11 1 4 6 Burundi
2962 2962       Cabo Verde 2020-04-24 03:30:31 16.5388 -23.0418 82 1 1 80 Cabo Verde
2963 2963       Cambodia 2020-04-24 03:30:31 11.55 104.9167 122 0 110 12 Cambodia
2964 2964       Cameroon 2020-04-24 03:30:31 3.8480000000000003 11.5021 1334 43 668 623 Cameroon
2852 2852     Alberta Canada 2020-04-24 03:31:19 53.9333 -116.5765 3720 68 0 3652 Alberta, Canada
2859 2859     British Columbia Canada 2020-04-24 03:31:19 53.7267 -127.6476 1824 94 0 1730 British Columbia, Canada
2865 2865     Diamond Princess Canada 2020-04-24 03:31:19     0 1 0 0 Diamond Princess, Canada
2895 2895     Manitoba Canada 2020-04-24 03:31:19 53.7609 -98.8139 262 6 0 256 Manitoba, Canada
2899 2899     New Brunswick Canada 2020-04-24 03:31:19 46.5653 -66.4619 118 0 0 118 New Brunswick, Canada
2901 2901     Newfoundland and Labrador Canada 2020-04-24 03:31:19 53.1355 -57.6604 256 3 0 253 Newfoundland and Labrador, Canada
2904 2904     Northwest Territories Canada 2020-04-24 03:31:19 64.8255 -124.8457 5 0 0 5 Northwest Territories, Canada
2905 2905     Nova Scotia Canada 2020-04-24 03:31:19 44.681999999999995 -63.7443 827 16 0 811 Nova Scotia, Canada
2906 2906     Nunavut Canada 2020-04-24 03:31:19 70.2998 -83.1076 0 0 0 0 Nunavut, Canada
2907 2907     Ontario Canada 2020-04-24 03:31:19 51.2538 -85.3232 14068 806 0 13262 Ontario, Canada
2908 2908     Prince Edward Island Canada 2020-04-24 03:31:19 46.5107 -63.4168 26 0 0 26 Prince Edward Island, Canada
2911 2911     Quebec Canada 2020-04-24 03:31:19 52.9399 -73.5491 21838 1852 0 20595 Quebec, Canada
2912 2912     Recovered Canada 2020-04-24 03:31:19     0 0 14761 -14761 Recovered, Canada
2918 2918     Saskatchewan Canada 2020-04-24 03:31:19 52.9399 -106.4509 331 4 0 327 Saskatchewan, Canada
2931 2931     Yukon Canada 2020-04-24 03:31:19 64.2823 -135.0 11 0 0 11 Yukon, Canada
2965 2965       Central African Republic 2020-04-24 03:30:31 6.6111 20.9394 16 0 10 6 Central African Republic
2966 2966       Chad 2020-04-24 03:30:31 15.4542 18.7322 33 0 8 25 Chad
2967 2967       Chile 2020-04-24 03:30:31 -35.6751 -71.543 11812 168 5804 5840 Chile
2854 2854     Anhui China 2020-04-09 01:12:20 31.8257 117.2264 991 6 984 1 Anhui, China
2856 2856     Beijing China 2020-04-24 01:36:27 40.1824 116.4142 593 8 524 61 Beijing, China
2863 2863     Chongqing China 2020-04-24 00:43:27 30.0572 107.874 579 6 573 0 Chongqing, China
2871 2871     Fujian China 2020-04-24 01:43:34 26.0789 117.9874 355 1 346 8 Fujian, China
2872 2872     Gansu China 2020-04-16 13:44:14 37.8099 101.0583 139 2 137 0 Gansu, China
2878 2878     Guangdong China 2020-04-24 01:27:14 23.3417 113.4244 1585 8 1528 49 Guangdong, China
2879 2879     Guangxi China 2020-04-02 00:16:02 23.8298 108.7881 254 2 252 0 Guangxi, China
2880 2880     Guizhou China 2020-04-19 00:51:07 26.8154 106.8748 147 2 145 0 Guizhou, China
2881 2881     Hainan China 2020-03-24 04:19:14 19.1959 109.7453 168 6 162 0 Hainan, China
2882 2882     Hebei China 2020-04-20 01:20:14 39.549 116.1306 328 6 317 5 Hebei, China
2883 2883     Heilongjiang China 2020-04-24 01:32:22 47.862 127.7615 928 13 485 430 Heilongjiang, China
2884 2884     Henan China 2020-04-14 00:43:57 33.882 113.614 1276 22 1254 0 Henan, China
2885 2885     Hong Kong China 2020-04-23 10:54:47 22.3 114.2 1035 4 699 332 Hong Kong, China
2886 2886     Hubei China 2020-04-24 01:35:26 30.9756 112.2707 68128 4512 63569 47 Hubei, China
2887 2887     Hunan China 2020-04-18 01:15:10 27.6104 111.7088 1019 4 1015 0 Hunan, China
2888 2888     Inner Mongolia China 2020-04-21 01:04:31 44.0935 113.9448 194 1 108 85 Inner Mongolia, China
2890 2890     Jiangsu China 2020-04-24 01:27:14 32.9711 119.455 653 0 646 7 Jiangsu, China
2891 2891     Jiangxi China 2020-04-10 01:22:42 27.614 115.7221 937 1 936 0 Jiangxi, China
2892 2892     Jilin China 2020-04-24 00:43:27 43.6661 126.1923 108 1 99 8 Jilin, China
2893 2893     Liaoning China 2020-04-20 01:20:14 41.2956 122.6085 146 2 143 1 Liaoning, China
2894 2894     Macau China 2020-04-23 10:54:47 22.1667 113.55 45 0 27 18 Macau, China
2902 2902     Ningxia China 2020-03-16 08:47:05 37.2692 106.1655 75 0 75 0 Ningxia, China
2910 2910     Qinghai China 2020-02-23 11:19:02 35.7452 95.9956 18 0 18 0 Qinghai, China
2919 2919     Shaanxi China 2020-04-22 02:37:29 35.1917 108.8701 279 3 253 23 Shaanxi, China
2920 2920     Shandong China 2020-04-22 00:33:30 36.3427 118.1498 787 7 766 14 Shandong, China
2921 2921     Shanghai China 2020-04-24 00:43:27 31.202 121.4491 641 7 533 101 Shanghai, China
2922 2922     Shanxi China 2020-04-23 00:58:30 37.5777 112.2922 197 0 142 55 Shanxi, China
2923 2923     Sichuan China 2020-04-24 01:27:14 30.6171 102.7103 561 3 558 0 Sichuan, China
2926 2926     Tianjin China 2020-04-23 15:26:19 39.3054 117.323 189 3 179 7 Tianjin, China
2927 2927     Tibet China 2020-02-23 11:19:02 31.6927 88.0924 1 0 1 0 Tibet, China
2930 2930     Xinjiang China 2020-03-08 05:31:02 41.1129 85.2401 76 3 73 0 Xinjiang, China
2932 2932     Yunnan China 2020-04-24 00:43:27 24.974 101.487 184 2 180 2 Yunnan, China
2933 2933     Zhejiang China 2020-04-24 01:36:27 29.1832 120.0934 1268 1 1256 11 Zhejiang, China
2968 2968       Colombia 2020-04-24 03:30:31 4.5709 -74.2973 4561 215 927 3419 Colombia
2969 2969       Congo (Brazzaville) 2020-04-24 03:30:31 -4.2634 15.2832 186 6 16 164 Congo (Brazzaville)
2970 2970       Congo (Kinshasa) 2020-04-24 03:30:31 -4.322447 15.307045 377 25 47 305 Congo (Kinshasa)
2971 2971       Costa Rica 2020-04-24 03:30:31 9.7489 -83.7534 686 6 196 484 Costa Rica
2972 2972       Cote d'Ivoire 2020-04-24 03:30:31 7.54 -5.5471 1004 14 359 631 Cote d'Ivoire
2973 2973       Croatia 2020-04-24 03:30:31 45.1 15.2 1981 50 883 1048 Croatia
2974 2974       Cuba 2020-04-24 03:30:31 21.521757 -77.78116700000002 1235 43 365 827 Cuba
2975 2975       Cyprus 2020-04-24 03:30:31 35.1264 33.4299 795 13 98 684 Cyprus
2976 2976       Czechia 2020-04-24 03:30:31 49.8175 15.472999999999999 7187 210 2152 4825 Czechia
2868 2868     Faroe Islands Denmark 2020-04-24 03:30:31 61.8926 -6.9118 187 0 178 9 Faroe Islands, Denmark

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

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