04-16-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,043 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
2919 2919       Fiji 2020-04-16 23:30:31 -17.7134 178.065 17 0 0 17 Fiji
2981 2981       New Zealand 2020-04-16 23:30:31 -40.9006 174.886 1401 9 770 622 New Zealand
2822 2822     New Caledonia France 2020-04-16 23:30:31 -20.904304999999997 165.618042 18 0 1 17 New Caledonia, France
2836 2836     Queensland Australia 2020-04-16 23:38:19 -27.4698 153.0251 1001 5 442 554 Queensland, Australia
2823 2823     New South Wales Australia 2020-04-16 23:38:19 -33.8688 151.2093 2897 25 4 2868 New South Wales, Australia
2777 2777     Australian Capital Territory Australia 2020-04-16 23:38:19 -35.4735 149.0124 103 3 82 18 Australian Capital Territory, Australia
2852 2852     Tasmania Australia 2020-04-16 23:38:19 -42.8821 147.3272 169 6 67 96 Tasmania, Australia
2826 2826 69   Northern Mariana Islands US 2020-04-16 23:30:51 15.0979 145.6739 13 2 0 11 Northern Mariana Islands, US
2856 2856     Victoria Australia 2020-04-16 23:38:19 -37.8136 144.9631 1299 14 1137 148 Victoria, Australia
2799 2799 66   Guam US 2020-04-16 23:30:51 13.4443 144.7937 135 5 0 130 Guam, US
2990 2990       Papua New Guinea 2020-04-16 23:30:31 -6.314993 143.95555 7 0 0 7 Papua New Guinea
2850 2850     South Australia Australia 2020-04-16 23:38:19 -34.9285 138.6007 433 4 279 150 South Australia, Australia
2946 2946       Japan 2020-04-16 23:30:31 36.204824 138.252924 8626 178 901 7547 Japan
2827 2827     Northern Territory Australia 2020-04-16 23:38:19 -12.4634 130.8456 28 0 6 22 Northern Territory, Australia
2950 2950       Korea, South 2020-04-16 23:30:31 35.90775700000001 127.766922 10613 229 7757 2627 Korea, South
2805 2805     Heilongjiang China 2020-04-16 02:06:52 47.862 127.7615 861 13 471 377 Heilongjiang, China
2814 2814     Jilin China 2020-04-15 00:28:05 43.6661 126.1923 102 1 96 5 Jilin, China
3027 3027       Timor-Leste 2020-04-16 23:30:31 -8.874217 125.727539 18 0 1 17 Timor-Leste
2815 2815     Liaoning China 2020-04-16 08:07:24 41.2956 122.6085 145 2 140 3 Liaoning, China
2993 2993       Philippines 2020-04-16 23:30:31 12.879721 121.77401699999999 5660 362 435 4863 Philippines
2846 2846     Shanghai China 2020-04-16 06:35:57 31.202 121.4491 628 7 489 132 Shanghai, China
3024 3024       Taiwan* 2020-04-16 12:44:27 23.7 121.0 395 6 155 234 Taiwan*
2862 2862     Zhejiang China 2020-04-15 02:05:41 29.1832 120.0934 1268 1 1244 23 Zhejiang, China
2812 2812     Jiangsu China 2020-04-15 01:12:53 32.9711 119.455 653 0 642 11 Jiangsu, China
2845 2845     Shandong China 2020-04-15 00:52:31 36.3427 118.1498 784 7 761 16 Shandong, China
2792 2792     Fujian China 2020-04-16 02:06:52 26.0789 117.9874 353 1 333 19 Fujian, China
2853 2853     Tianjin China 2020-04-16 14:09:41 39.3054 117.323 186 3 172 11 Tianjin, China
2775 2775     Anhui China 2020-04-09 01:12:20 31.8257 117.2264 991 6 984 1 Anhui, China
2778 2778     Beijing China 2020-04-16 01:27:22 40.1824 116.4142 593 8 503 82 Beijing, China
2804 2804     Hebei China 2020-04-16 01:58:47 39.549 116.1306 328 6 315 7 Hebei, China
2858 2858     Western Australia Australia 2020-04-16 23:38:19 -31.9505 115.8605 532 6 338 188 Western Australia, Australia
2813 2813     Jiangxi China 2020-04-10 01:22:42 27.614 115.7221 937 1 936 0 Jiangxi, China
2886 2886       Brunei 2020-04-16 23:30:31 4.5353 114.7277 136 1 108 27 Brunei
2807 2807     Hong Kong China 2020-04-16 09:30:36 22.3 114.2 1017 4 485 528 Hong Kong, China
2810 2810     Inner Mongolia China 2020-04-16 00:37:36 44.0935 113.9448 193 1 94 98 Inner Mongolia, China
2939 2939       Indonesia 2020-04-16 23:30:31 -0.7893 113.9213 5516 496 548 4472 Indonesia
2806 2806     Henan China 2020-04-14 00:43:57 33.882 113.614 1276 22 1254 0 Henan, China
2816 2816     Macau China 2020-04-15 14:46:10 22.1667 113.55 45 0 16 29 Macau, China
2800 2800     Guangdong China 2020-04-16 01:54:44 23.3417 113.4244 1571 8 1471 92 Guangdong, China
2847 2847     Shanxi China 2020-04-16 00:32:33 37.5777 112.2922 194 0 135 59 Shanxi, China
2808 2808     Hubei China 2020-04-16 01:54:44 30.9756 112.2707 67803 3222 64435 146 Hubei, China
2809 2809     Hunan China 2020-04-02 01:30:57 27.6104 111.7088 1019 4 1014 1 Hunan, China
2803 2803     Hainan China 2020-03-24 04:19:14 19.1959 109.7453 168 6 162 0 Hainan, China
2844 2844     Shaanxi China 2020-04-15 01:20:59 35.1917 108.8701 256 3 251 2 Shaanxi, China
2801 2801     Guangxi China 2020-04-02 00:16:02 23.8298 108.7881 254 2 252 0 Guangxi, China
3039 3039       Vietnam 2020-04-16 23:30:31 14.058323999999999 108.277199 268 0 177 91 Vietnam
2785 2785     Chongqing China 2020-03-29 00:14:12 30.0572 107.874 579 6 570 3 Chongqing, China
2802 2802     Guizhou China 2020-03-18 01:37:43 26.8154 106.8748 146 2 144 0 Guizhou, China
2825 2825     Ningxia China 2020-03-16 08:47:05 37.2692 106.1655 75 0 75 0 Ningxia, China
2998 2998       Russia 2020-04-16 23:30:31 61.52401 105.31875600000001 27938 232 2304 25402 Russia
2892 2892       Cambodia 2020-04-16 23:30:31 11.55 104.9167 122 0 98 24 Cambodia
2974 2974       Mongolia 2020-04-16 23:30:31 46.8625 103.8467 31 0 5 26 Mongolia
3011 3011       Singapore 2020-04-16 23:30:31 1.2833 103.8333 4427 10 683 3734 Singapore
2848 2848     Sichuan China 2020-04-16 01:07:06 30.6171 102.7103 560 3 552 5 Sichuan, China
2954 2954       Laos 2020-04-16 23:30:31 19.856270000000002 102.495496 19 0 2 17 Laos
2965 2965       Malaysia 2020-04-16 23:30:31 4.210483999999999 101.97576600000001 5182 84 2766 2332 Malaysia
2861 2861     Yunnan China 2020-04-15 00:18:56 24.974 101.487 184 2 176 6 Yunnan, China
2793 2793     Gansu China 2020-04-16 13:44:14 37.8099 101.0583 139 2 137 0 Gansu, China
3026 3026       Thailand 2020-04-16 23:30:31 15.870032 100.992541 2672 46 1593 1033 Thailand
2834 2834     Qinghai China 2020-02-23 11:19:02 35.7452 95.9956 18 0 18 0 Qinghai, China
2889 2889       Burma 2020-04-16 23:30:31 21.9162 95.956 85 4 2 79 Burma
2881 2881       Bhutan 2020-04-16 23:30:31 27.5142 90.4336 5 0 2 3 Bhutan
2875 2875       Bangladesh 2020-04-16 23:30:31 23.685 90.3563 1572 60 49 1463 Bangladesh
2854 2854     Tibet China 2020-02-23 11:19:02 31.6927 88.0924 1 0 1 0 Tibet, China
2859 2859     Xinjiang China 2020-03-08 05:31:02 41.1129 85.2401 76 3 73 0 Xinjiang, China
2979 2979       Nepal 2020-04-16 23:30:31 28.1667 84.25 16 0 2 14 Nepal
3018 3018       Sri Lanka 2020-04-16 23:30:31 7.873054 80.77179699999998 238 7 68 163 Sri Lanka
2938 2938       India 2020-04-16 23:30:31 20.593684 78.96288 13430 448 1768 11214 India
2953 2953       Kyrgyzstan 2020-04-16 23:30:31 41.20438 74.766098 466 5 91 370 Kyrgyzstan
2966 2966       Maldives 2020-04-16 23:30:31 3.2028 73.2207 25 0 16 9 Maldives
2988 2988       Pakistan 2020-04-16 23:30:31 30.3753 69.3451 6919 128 1645 5146 Pakistan
2863 2863       Afghanistan 2020-04-16 23:30:31 33.93911 67.709953 841 30 54 756 Afghanistan
2948 2948       Kazakhstan 2020-04-16 23:30:31 48.0196 66.9237 1402 17 277 1108 Kazakhstan
3037 3037       Uzbekistan 2020-04-16 23:30:31 41.377491 64.585262 1349 4 129 1216 Uzbekistan
2970 2970       Mauritius 2020-04-16 23:30:31 -20.348404000000002 57.552152 324 9 81 234 Mauritius
2987 2987       Oman 2020-04-16 23:30:31 21.512583 55.92325500000001 1019 4 176 839 Oman
2839 2839     Reunion France 2020-04-16 23:30:31 -21.1151 55.5364 394 0 237 157 Reunion, France
3009 3009       Seychelles 2020-04-16 23:30:31 -4.6796 55.492 11 0 0 11 Seychelles
3034 3034       United Arab Emirates 2020-04-16 23:30:31 23.424076 53.847818000000004 5825 35 1095 4695 United Arab Emirates
2940 2940       Iran 2020-04-16 23:30:31 32.427908 53.68804599999999 77995 4869 52229 20897 Iran
2996 2996       Qatar 2020-04-16 23:30:31 25.3548 51.1839 4103 7 415 3681 Qatar
2874 2874       Bahrain 2020-04-16 23:30:31 26.0275 50.55 1700 7 703 990 Bahrain
3041 3041       Yemen 2020-04-16 23:30:31 15.552726999999999 48.516388 1 0 0 1 Yemen
2872 2872       Azerbaijan 2020-04-16 23:30:31 40.1431 47.5769 1283 15 460 808 Azerbaijan
2952 2952       Kuwait 2020-04-16 23:30:31 29.311659999999996 47.481766 1524 3 225 1296 Kuwait
2963 2963       Madagascar 2020-04-16 23:30:31 -18.766947000000002 46.869107 111 0 33 78 Madagascar
3014 3014       Somalia 2020-04-16 23:30:31 5.152149 46.199616 80 5 2 73 Somalia
2819 2819     Mayotte France 2020-04-16 23:30:31 -12.8275 45.166244 233 3 69 161 Mayotte, France
3006 3006       Saudi Arabia 2020-04-16 23:30:31 23.885942 45.079162 6380 83 990 5307 Saudi Arabia
2870 2870       Armenia 2020-04-16 23:30:31 40.0691 45.0382 1159 18 358 783 Armenia
2941 2941       Iraq 2020-04-16 23:30:31 33.223191 43.679291 1434 80 856 498 Iraq
2924 2924       Georgia 2020-04-16 23:30:31 42.3154 43.3569 348 3 76 269 Georgia
2908 2908       Djibouti 2020-04-16 23:30:31 11.8251 42.5903 591 2 73 516 Djibouti
2918 2918       Ethiopia 2020-04-16 23:30:31 9.145 40.4897 92 3 15 74 Ethiopia
2915 2915       Eritrea 2020-04-16 23:30:31 15.1794 39.7823 35 0 0 35 Eritrea
3023 3023       Syria 2020-04-16 23:30:31 34.802075 38.99681500000001 33 2 5 26 Syria
2949 2949       Kenya 2020-04-16 23:30:31 -0.0236 37.9062 234 11 53 170 Kenya
2947 2947       Jordan 2020-04-16 23:30:31 31.24 36.51 402 7 259 136 Jordan
2956 2956       Lebanon 2020-04-16 23:30:31 33.8547 35.8623 663 21 86 556 Lebanon
2977 2977       Mozambique 2020-04-16 23:30:31 -18.665695 35.529562 31 0 2 29 Mozambique

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

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