04-25-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,134 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
3002 3002       Fiji 2020-04-26 02:30:31 -17.7134 178.065 18 0 10 8 Fiji
3064 3064       New Zealand 2020-04-26 02:30:31 -40.9006 174.886 1470 18 1142 310 New Zealand
2915 2915     New Caledonia France 2020-04-26 02:30:31 -20.904304999999997 165.618042 18 0 17 1 New Caledonia, France
3130 3130     Queensland Australia 2020-04-26 02:31:18 -27.4698 153.0251 1026 6 803 217 Queensland, Australia
3128 3128     New South Wales Australia 2020-04-26 02:31:18 -33.8688 151.2093 2994 33 2193 768 New South Wales, Australia
3127 3127     Australian Capital Territory Australia 2020-04-26 02:31:18 -35.4735 149.0124 106 3 98 5 Australian Capital Territory, Australia
3132 3132     Tasmania Australia 2020-04-26 02:31:18 -42.8821 147.3272 207 10 117 80 Tasmania, Australia
2918 2918 69   Northern Mariana Islands US 2020-04-26 02:30:51 15.0979 145.6739 14 2 0 12 Northern Mariana Islands, US
3133 3133     Victoria Australia 2020-04-26 02:31:18 -37.8136 144.9631 1346 16 133 1197 Victoria, Australia
2892 2892 66   Guam US 2020-04-26 02:30:51 13.4443 144.7937 141 5 0 136 Guam, US
3073 3073       Papua New Guinea 2020-04-26 02:30:31 -6.314993 143.95555 8 0 0 8 Papua New Guinea
3131 3131     South Australia Australia 2020-04-26 02:31:18 -34.9285 138.6007 438 4 401 33 South Australia, Australia
3029 3029       Japan 2020-04-26 02:30:31 36.204824 138.252924 13231 360 1656 11215 Japan
3129 3129     Northern Territory Australia 2020-04-26 02:31:18 -12.4634 130.8456 28 0 0 28 Northern Territory, Australia
3033 3033       Korea, South 2020-04-26 02:30:31 35.90775700000001 127.766922 10728 242 8717 1769 Korea, South
2898 2898     Heilongjiang China 2020-04-26 00:12:00 47.862 127.7615 935 13 511 411 Heilongjiang, China
2907 2907     Jilin China 2020-04-25 00:08:49 43.6661 126.1923 109 1 99 9 Jilin, China
3110 3110       Timor-Leste 2020-04-26 02:30:31 -8.874217 125.727539 24 0 2 22 Timor-Leste
2908 2908     Liaoning China 2020-04-20 01:20:14 41.2956 122.6085 146 2 143 1 Liaoning, China
3076 3076       Philippines 2020-04-26 02:30:31 12.879721 121.77401699999999 7294 494 792 6008 Philippines
2933 2933     Shanghai China 2020-04-26 00:08:58 31.202 121.4491 642 7 558 77 Shanghai, China
3107 3107       Taiwan* 2020-04-26 00:38:32 23.7 121.0 429 6 275 148 Taiwan*
2945 2945     Zhejiang China 2020-04-26 01:12:11 29.1832 120.0934 1268 1 1257 10 Zhejiang, China
2905 2905     Jiangsu China 2020-04-24 01:27:14 32.9711 119.455 653 0 646 7 Jiangsu, China
2932 2932     Shandong China 2020-04-25 00:34:20 36.3427 118.1498 787 7 767 13 Shandong, China
2886 2886     Fujian China 2020-04-25 01:01:53 26.0789 117.9874 355 1 349 5 Fujian, China
2938 2938     Tianjin China 2020-04-26 01:08:08 39.3054 117.323 190 3 182 5 Tianjin, China
2869 2869     Anhui China 2020-04-24 12:04:47 31.8257 117.2264 991 6 985 0 Anhui, China
2871 2871     Beijing China 2020-04-25 01:30:21 40.1824 116.4142 593 8 525 60 Beijing, China
2897 2897     Hebei China 2020-04-25 00:34:20 39.549 116.1306 328 6 318 4 Hebei, China
3134 3134     Western Australia Australia 2020-04-26 02:31:18 -31.9505 115.8605 549 8 478 63 Western Australia, Australia
2906 2906     Jiangxi China 2020-04-10 01:22:42 27.614 115.7221 937 1 936 0 Jiangxi, China
2969 2969       Brunei 2020-04-26 02:30:31 4.5353 114.7277 138 1 121 16 Brunei
2900 2900     Hong Kong China 2020-04-25 09:12:59 22.3 114.2 1037 4 753 280 Hong Kong, China
2903 2903     Inner Mongolia China 2020-04-26 00:38:32 44.0935 113.9448 198 1 121 76 Inner Mongolia, China
3022 3022       Indonesia 2020-04-26 02:30:31 -0.7893 113.9213 8607 720 1042 6845 Indonesia
2899 2899     Henan China 2020-04-14 00:43:57 33.882 113.614 1276 22 1254 0 Henan, China
2909 2909     Macau China 2020-04-26 00:38:32 22.1667 113.55 45 0 28 17 Macau, China
2893 2893     Guangdong China 2020-04-26 00:47:41 23.3417 113.4244 1586 8 1542 36 Guangdong, China
2934 2934     Shanxi China 2020-04-26 00:55:48 37.5777 112.2922 197 0 154 43 Shanxi, China
2901 2901     Hubei China 2020-04-26 00:51:44 30.9756 112.2707 68128 4512 63604 12 Hubei, China
2902 2902     Hunan China 2020-04-18 01:15:10 27.6104 111.7088 1019 4 1015 0 Hunan, China
2896 2896     Hainan China 2020-03-24 04:19:14 19.1959 109.7453 168 6 162 0 Hainan, China
2931 2931     Shaanxi China 2020-04-25 01:22:13 35.1917 108.8701 286 3 253 30 Shaanxi, China
2894 2894     Guangxi China 2020-04-02 00:16:02 23.8298 108.7881 254 2 252 0 Guangxi, China
3122 3122       Vietnam 2020-04-26 02:30:31 14.058323999999999 108.277199 270 0 225 45 Vietnam
2878 2878     Chongqing China 2020-04-24 00:43:27 30.0572 107.874 579 6 573 0 Chongqing, China
2895 2895     Guizhou China 2020-04-19 00:51:07 26.8154 106.8748 147 2 145 0 Guizhou, China
2917 2917     Ningxia China 2020-03-16 08:47:05 37.2692 106.1655 75 0 75 0 Ningxia, China
3081 3081       Russia 2020-04-26 02:30:31 61.52401 105.31875600000001 74588 681 6250 67657 Russia
2975 2975       Cambodia 2020-04-26 02:30:31 11.55 104.9167 122 0 117 5 Cambodia
3057 3057       Mongolia 2020-04-26 02:30:31 46.8625 103.8467 37 0 9 28 Mongolia
3094 3094       Singapore 2020-04-26 02:30:31 1.2833 103.8333 12693 12 1002 11679 Singapore
2935 2935     Sichuan China 2020-04-24 01:27:14 30.6171 102.7103 561 3 558 0 Sichuan, China
3037 3037       Laos 2020-04-26 02:30:31 19.856270000000002 102.495496 19 0 7 12 Laos
3048 3048       Malaysia 2020-04-26 02:30:31 4.210483999999999 101.97576600000001 5742 98 3762 1882 Malaysia
2944 2944     Yunnan China 2020-04-25 23:55:42 24.974 101.487 185 2 181 2 Yunnan, China
2887 2887     Gansu China 2020-04-16 13:44:14 37.8099 101.0583 139 2 137 0 Gansu, China
3109 3109       Thailand 2020-04-26 02:30:31 15.870032 100.992541 2907 51 2547 309 Thailand
2923 2923     Qinghai China 2020-02-23 11:19:02 35.7452 95.9956 18 0 18 0 Qinghai, China
2972 2972       Burma 2020-04-26 02:30:31 21.9162 95.956 146 5 10 131 Burma
2964 2964       Bhutan 2020-04-26 02:30:31 27.5142 90.4336 7 0 3 4 Bhutan
2958 2958       Bangladesh 2020-04-26 02:30:31 23.685 90.3563 4998 140 113 4745 Bangladesh
2939 2939     Tibet China 2020-02-23 11:19:02 31.6927 88.0924 1 0 1 0 Tibet, China
2942 2942     Xinjiang China 2020-03-08 05:31:02 41.1129 85.2401 76 3 73 0 Xinjiang, China
3062 3062       Nepal 2020-04-26 02:30:31 28.1667 84.25 49 0 12 37 Nepal
3101 3101       Sri Lanka 2020-04-26 02:30:31 7.873054 80.77179699999998 460 7 118 335 Sri Lanka
3021 3021       India 2020-04-26 02:30:31 20.593684 78.96288 26283 825 5939 19519 India
3036 3036       Kyrgyzstan 2020-04-26 02:30:31 41.20438 74.766098 665 8 345 312 Kyrgyzstan
3049 3049       Maldives 2020-04-26 02:30:31 3.2028 73.2207 177 0 17 160 Maldives
3071 3071       Pakistan 2020-04-26 02:30:31 30.3753 69.3451 12723 269 2866 9588 Pakistan
2946 2946       Afghanistan 2020-04-26 02:30:31 33.93911 67.709953 1464 47 188 1228 Afghanistan
3031 3031       Kazakhstan 2020-04-26 02:30:31 48.0196 66.9237 2601 25 646 1930 Kazakhstan
3120 3120       Uzbekistan 2020-04-26 02:30:31 41.377491 64.585262 1862 8 707 1147 Uzbekistan
3053 3053       Mauritius 2020-04-26 02:30:31 -20.348404000000002 57.552152 331 9 295 27 Mauritius
3070 3070       Oman 2020-04-26 02:30:31 21.512583 55.92325500000001 1905 10 329 1566 Oman
2927 2927     Reunion France 2020-04-26 02:30:31 -21.1151 55.5364 417 0 300 117 Reunion, France
3092 3092       Seychelles 2020-04-26 02:30:31 -4.6796 55.492 11 0 6 5 Seychelles
3117 3117       United Arab Emirates 2020-04-26 02:30:31 23.424076 53.847818000000004 9813 71 1887 7855 United Arab Emirates
3023 3023       Iran 2020-04-26 02:30:31 32.427908 53.68804599999999 89328 5650 68193 15485 Iran
3079 3079       Qatar 2020-04-26 02:30:31 25.3548 51.1839 9358 10 929 8419 Qatar
2957 2957       Bahrain 2020-04-26 02:30:31 26.0275 50.55 2588 8 1160 1420 Bahrain
3124 3124       Yemen 2020-04-26 02:30:31 15.552726999999999 48.516388 1 0 0 0 Yemen
2955 2955       Azerbaijan 2020-04-26 02:30:31 40.1431 47.5769 1617 21 1080 516 Azerbaijan
3035 3035       Kuwait 2020-04-26 02:30:31 29.311659999999996 47.481766 2892 19 656 2217 Kuwait
3046 3046       Madagascar 2020-04-26 02:30:31 -18.766947000000002 46.869107 123 0 62 61 Madagascar
3097 3097       Somalia 2020-04-26 02:30:31 5.152149 46.199616 390 18 8 364 Somalia
2912 2912     Mayotte France 2020-04-26 02:30:31 -12.8275 45.166244 380 4 144 232 Mayotte, France
3089 3089       Saudi Arabia 2020-04-26 02:30:31 23.885942 45.079162 16299 136 2215 13948 Saudi Arabia
2953 2953       Armenia 2020-04-26 02:30:31 40.0691 45.0382 1677 28 803 846 Armenia
3024 3024       Iraq 2020-04-26 02:30:31 33.223191 43.679291 1763 86 1224 453 Iraq
3007 3007       Georgia 2020-04-26 02:30:31 42.3154 43.3569 456 5 139 312 Georgia
2991 2991       Djibouti 2020-04-26 02:30:31 11.8251 42.5903 1008 2 373 633 Djibouti
3001 3001       Ethiopia 2020-04-26 02:30:31 9.145 40.4897 122 3 29 90 Ethiopia
2998 2998       Eritrea 2020-04-26 02:30:31 15.1794 39.7823 39 0 13 26 Eritrea
3106 3106       Syria 2020-04-26 02:30:31 34.802075 38.99681500000001 42 3 11 28 Syria
3032 3032       Kenya 2020-04-26 02:30:31 -0.0236 37.9062 343 14 98 231 Kenya
3030 3030       Jordan 2020-04-26 02:30:31 31.24 36.51 444 7 332 105 Jordan
3039 3039       Lebanon 2020-04-26 02:30:31 33.8547 35.8623 704 24 143 537 Lebanon
3060 3060       Mozambique 2020-04-26 02:30:31 -18.665695 35.529562 70 0 12 58 Mozambique

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

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