05-08-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,232 rows sorted by Long_ descending

✎ 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
3107 3107       Fiji 2020-05-09 02:32:35 -17.7134 178.065 18 0 14 4 Fiji
3169 3169       New Zealand 2020-05-09 02:32:35 -40.9006 174.886 1492 21 1368 103 New Zealand
3009 3009     New Caledonia France 2020-05-09 02:32:35 -20.904305 165.618042 18 0 18 0 New Caledonia, France
3023 3023     Queensland Australia 2020-05-09 02:32:35 -27.4698 153.0251 1045 6 1019 20 Queensland, Australia
3010 3010     New South Wales Australia 2020-05-09 02:32:35 -33.8688 151.2093 3051 44 2504 503 New South Wales, Australia
2963 2963     Australian Capital Territory Australia 2020-05-09 02:32:35 -35.4735 149.0124 107 3 103 1 Australian Capital Territory, Australia
3039 3039     Tasmania Australia 2020-05-09 02:32:35 -42.8821 147.3272 227 13 175 39 Tasmania, Australia
3013 3013 69   Northern Mariana Islands US 2020-05-09 02:32:35 15.0979 145.6739 15 2 0 13 Northern Mariana Islands, US
3043 3043     Victoria Australia 2020-05-09 02:32:35 -37.8136 144.9631 1468 18 1327 123 Victoria, Australia
2986 2986 66   Guam US 2020-05-09 02:32:35 13.4443 144.7937 151 5 0 146 Guam, US
3178 3178       Papua New Guinea 2020-05-09 02:32:35 -6.314993 143.95555 8 0 8 0 Papua New Guinea
3037 3037     South Australia Australia 2020-05-09 02:32:35 -34.9285 138.6007 439 4 433 2 South Australia, Australia
3134 3134       Japan 2020-05-09 02:32:35 36.204824 138.252924 15575 590 5146 9839 Japan
3014 3014     Northern Territory Australia 2020-05-09 02:32:35 -12.4634 130.8456 29 0 27 2 Northern Territory, Australia
3138 3138       Korea, South 2020-05-09 02:32:35 35.90775700000001 127.766922 10840 256 9568 1016 Korea, South
2992 2992     Heilongjiang China 2020-05-09 02:32:35 47.862 127.7615 944 13 815 116 Heilongjiang, China
3001 3001     Jilin China 2020-05-09 02:32:35 43.6661 126.1923 113 1 104 8 Jilin, China
3216 3216       Timor-Leste 2020-05-09 02:32:35 -8.874217 125.727539 24 0 21 3 Timor-Leste
3002 3002     Liaoning China 2020-05-09 02:32:35 41.2956 122.6085 146 2 144 0 Liaoning, China
3181 3181       Philippines 2020-05-09 02:32:35 12.879721 121.774017 10463 696 1734 8033 Philippines
3033 3033     Shanghai China 2020-05-09 02:32:35 31.202 121.4491 657 7 623 27 Shanghai, China
3212 3212       Taiwan* 2020-05-09 02:32:35 23.7 121.0 440 6 355 79 Taiwan*
3049 3049     Zhejiang China 2020-05-09 02:32:35 29.1832 120.0934 1268 1 1267 0 Zhejiang, China
2999 2999     Jiangsu China 2020-05-09 02:32:35 32.9711 119.455 653 0 652 1 Jiangsu, China
3032 3032     Shandong China 2020-05-09 02:32:35 36.3427 118.1498 788 7 776 5 Shandong, China
2979 2979     Fujian China 2020-05-09 02:32:35 26.0789 117.9874 356 1 354 1 Fujian, China
3040 3040     Tianjin China 2020-05-09 02:32:35 39.3054 117.323 191 3 186 2 Tianjin, China
2961 2961     Anhui China 2020-05-09 02:32:35 31.8257 117.2264 991 6 985 0 Anhui, China
2964 2964     Beijing China 2020-05-09 02:32:35 40.1824 116.4142 593 9 560 24 Beijing, China
2991 2991     Hebei China 2020-05-09 02:32:35 39.549 116.1306 328 6 320 2 Hebei, China
3045 3045     Western Australia Australia 2020-05-09 02:32:35 -31.9505 115.8605 552 9 534 9 Western Australia, Australia
3000 3000     Jiangxi China 2020-05-09 02:32:35 27.614 115.7221 937 1 936 0 Jiangxi, China
3073 3073       Brunei 2020-05-09 02:32:35 4.5353 114.7277 141 1 132 8 Brunei
2994 2994     Hong Kong China 2020-05-09 02:32:35 22.3 114.2 1044 4 960 80 Hong Kong, China
2997 2997     Inner Mongolia China 2020-05-09 02:32:35 44.0935 113.9448 201 1 172 28 Inner Mongolia, China
3127 3127       Indonesia 2020-05-09 02:32:35 -0.7893 113.9213 13112 943 2494 9675 Indonesia
2993 2993     Henan China 2020-05-09 02:32:35 33.882 113.614 1276 22 1254 0 Henan, China
3003 3003     Macau China 2020-05-09 02:32:35 22.1667 113.55 45 0 40 5 Macau, China
2987 2987     Guangdong China 2020-05-09 02:32:35 23.3417 113.4244 1589 8 1575 6 Guangdong, China
3034 3034     Shanxi China 2020-05-09 02:32:35 37.5777 112.2922 198 0 195 3 Shanxi, China
2995 2995     Hubei China 2020-05-09 02:32:35 30.9756 112.2707 68128 4512 63616 0 Hubei, China
2996 2996     Hunan China 2020-05-09 02:32:35 27.6104 111.7088 1019 4 1015 0 Hunan, China
2990 2990     Hainan China 2020-05-09 02:32:35 19.1959 109.7453 168 6 162 0 Hainan, China
3031 3031     Shaanxi China 2020-05-09 02:32:35 35.1917 108.8701 308 3 268 37 Shaanxi, China
2988 2988     Guangxi China 2020-05-09 02:32:35 23.8298 108.7881 254 2 252 0 Guangxi, China
3228 3228       Vietnam 2020-05-09 02:32:35 14.058324 108.277199 288 0 241 47 Vietnam
2971 2971     Chongqing China 2020-05-09 02:32:35 30.0572 107.874 579 6 573 0 Chongqing, China
2989 2989     Guizhou China 2020-05-09 02:32:35 26.8154 106.8748 147 2 145 0 Guizhou, China
3012 3012     Ningxia China 2020-05-09 02:32:35 37.2692 106.1655 75 0 75 0 Ningxia, China
3186 3186       Russia 2020-05-09 02:32:35 61.52401 105.318756 187859 1723 26608 159528 Russia
3079 3079       Cambodia 2020-05-09 02:32:35 11.55 104.9167 122 0 120 2 Cambodia
3162 3162       Mongolia 2020-05-09 02:32:35 46.8625 103.8467 42 0 13 29 Mongolia
3199 3199       Singapore 2020-05-09 02:32:35 1.2833 103.8333 21707 20 2040 19647 Singapore
3035 3035     Sichuan China 2020-05-09 02:32:35 30.6171 102.7103 561 3 558 0 Sichuan, China
3142 3142       Laos 2020-05-09 02:32:35 19.85627 102.495496 19 0 9 10 Laos
3153 3153       Malaysia 2020-05-09 02:32:35 4.210483999999999 101.975766 6535 107 4864 1564 Malaysia
3048 3048     Yunnan China 2020-05-09 02:32:35 24.974 101.487 185 2 182 1 Yunnan, China
2980 2980     Gansu China 2020-05-09 02:32:35 37.8099 101.0583 139 2 137 0 Gansu, China
3215 3215       Thailand 2020-05-09 02:32:35 15.870032 100.992541 3000 55 2784 161 Thailand
3021 3021     Qinghai China 2020-05-09 02:32:35 35.7452 95.9956 18 0 18 0 Qinghai, China
3076 3076       Burma 2020-05-09 02:32:35 21.9162 95.956 177 6 67 104 Burma
3068 3068       Bhutan 2020-05-09 02:32:35 27.5142 90.4336 7 0 5 2 Bhutan
3062 3062       Bangladesh 2020-05-09 02:32:35 23.685 90.3563 13134 206 2101 10827 Bangladesh
3041 3041     Tibet China 2020-05-09 02:32:35 31.6927 88.0924 1 0 1 0 Tibet, China
3046 3046     Xinjiang China 2020-05-09 02:32:35 41.1129 85.2401 76 3 73 0 Xinjiang, China
3167 3167       Nepal 2020-05-09 02:32:35 28.1667 84.25 102 0 31 71 Nepal
3206 3206       Sri Lanka 2020-05-09 02:32:35 7.873054 80.77179699999998 835 9 240 586 Sri Lanka
3126 3126       India 2020-05-09 02:32:35 20.593684 78.96288 59695 1985 17887 39823 India
3141 3141       Kyrgyzstan 2020-05-09 02:32:35 41.20438 74.766098 906 12 650 244 Kyrgyzstan
3154 3154       Maldives 2020-05-09 02:32:35 3.2028 73.2207 744 3 20 721 Maldives
3213 3213       Tajikistan 2020-05-09 02:32:35 38.861034 71.276093 522 12 0 510 Tajikistan
3176 3176       Pakistan 2020-05-09 02:32:35 30.3753 69.3451 26435 599 7530 18306 Pakistan
3050 3050       Afghanistan 2020-05-09 02:32:35 33.93911 67.709953 3781 109 472 3197 Afghanistan
3136 3136       Kazakhstan 2020-05-09 02:32:35 48.0196 66.9237 4834 31 1631 3172 Kazakhstan
3226 3226       Uzbekistan 2020-05-09 02:32:35 41.377491 64.585262 2325 10 1775 540 Uzbekistan
3158 3158       Mauritius 2020-05-09 02:32:35 -20.348404 57.552152 332 10 320 2 Mauritius
3175 3175       Oman 2020-05-09 02:32:35 21.512583 55.92325500000001 3112 16 1025 2071 Oman
3026 3026     Reunion France 2020-05-09 02:32:35 -21.1151 55.5364 426 0 354 72 Reunion, France
3197 3197       Seychelles 2020-05-09 02:32:35 -4.6796 55.492 11 0 8 3 Seychelles
3223 3223       United Arab Emirates 2020-05-09 02:32:35 23.424076 53.847818 16793 174 3837 12782 United Arab Emirates
3128 3128       Iran 2020-05-09 02:32:35 32.427908 53.68804599999999 104691 6541 83837 14313 Iran
3184 3184       Qatar 2020-05-09 02:32:35 25.3548 51.1839 20201 12 2370 17819 Qatar
3061 3061       Bahrain 2020-05-09 02:32:35 26.0275 50.55 4444 8 2028 2408 Bahrain
3230 3230       Yemen 2020-05-09 02:32:35 15.552727 48.516388 34 5 1 26 Yemen
3059 3059       Azerbaijan 2020-05-09 02:32:35 40.1431 47.5769 2279 28 1576 675 Azerbaijan
3140 3140       Kuwait 2020-05-09 02:32:35 29.31166 47.481766 7208 47 2466 4695 Kuwait
3151 3151       Madagascar 2020-05-09 02:32:35 -18.766947 46.869107 193 0 101 92 Madagascar
3202 3202       Somalia 2020-05-09 02:32:35 5.152149 46.199616 928 44 106 778 Somalia
3006 3006     Mayotte France 2020-05-09 02:32:35 -12.8275 45.166244 854 10 352 492 Mayotte, France
3194 3194       Saudi Arabia 2020-05-09 02:32:35 23.885942 45.079162 35432 229 9120 26083 Saudi Arabia
3057 3057       Armenia 2020-05-09 02:32:35 40.0691 45.0382 3029 43 1218 1768 Armenia
3129 3129       Iraq 2020-05-09 02:32:35 33.223191 43.679291 2603 104 1661 838 Iraq
3112 3112       Georgia 2020-05-09 02:32:35 42.3154 43.3569 623 10 288 325 Georgia
3085 3085       Comoros 2020-05-09 02:32:35 -11.6455 43.3333 8 1 0 7 Comoros
3096 3096       Djibouti 2020-05-09 02:32:35 11.8251 42.5903 1135 3 824 308 Djibouti
3106 3106       Ethiopia 2020-05-09 02:32:35 9.145 40.4897 194 4 95 95 Ethiopia
3103 3103       Eritrea 2020-05-09 02:32:35 15.1794 39.7823 39 0 37 2 Eritrea
3211 3211       Syria 2020-05-09 02:32:35 34.802075 38.99681500000001 47 3 29 15 Syria
3137 3137       Kenya 2020-05-09 02:32:35 -0.0236 37.9062 621 29 202 390 Kenya
3135 3135       Jordan 2020-05-09 02:32:35 31.24 36.51 508 9 385 114 Jordan

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

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