04-01-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,486 rows sorted by Last_Update

✎ 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
2282 2282     Qinghai China 2020-02-23 11:19:02 35.7452 95.9956 18 0 18 0 Qinghai, China
2301 2301     Tibet China 2020-02-23 11:19:02 31.6927 88.0924 1 0 1 0 Tibet, China
2224 2224     Anhui China 2020-03-08 05:19:01 31.8257 117.2264 990 6 984 0 Anhui, China
2306 2306     Xinjiang China 2020-03-08 05:31:02 41.1129 85.2401 76 3 73 0 Xinjiang, China
2257 2257     Hunan China 2020-03-14 08:25:05 27.6104 111.7088 1018 4 1014 0 Hunan, China
2273 2273     Ningxia China 2020-03-16 08:47:05 37.2692 106.1655 75 0 75 0 Ningxia, China
2250 2250     Guizhou China 2020-03-18 01:37:43 26.8154 106.8748 146 2 144 0 Guizhou, China
2249 2249     Guangxi China 2020-03-20 04:33:45 23.8298 108.7881 254 2 250 2 Guangxi, China
2251 2251     Hainan China 2020-03-24 04:29:15 19.1959 109.7453 168 6 162 0 Hainan, China
2253 2253     Heilongjiang China 2020-03-26 00:15:39 47.861999999999995 127.7615 484 13 469 2 Heilongjiang, China
2233 2233     Chongqing China 2020-03-29 00:14:12 30.0572 107.874 579 6 570 3 Chongqing, China
2262 2262     Jilin China 2020-03-29 00:28:20 43.6661 126.1923 98 1 92 5 Jilin, China
2254 2254     Henan China 2020-03-29 01:44:01 33.882 113.61399999999999 1276 22 1251 3 Henan, China
2261 2261     Jiangxi China 2020-03-30 03:15:15 27.614 115.7221 937 1 935 1 Jiangxi, China
2292 2292     Shandong China 2020-03-31 00:44:17 36.3427 118.1498 774 7 753 14 Shandong, China
2260 2260     Jiangsu China 2020-03-31 01:10:41 32.9711 119.455 646 0 631 15 Jiangsu, China
2309 2309     Zhejiang China 2020-03-31 01:23:49 29.1832 120.0934 1257 1 1226 30 Zhejiang, China
2264 2264     Macau China 2020-03-31 13:54:04 22.1667 113.55 41 0 10 31 Macau, China
2308 2308     Yunnan China 2020-03-31 23:31:54 24.974 101.48700000000001 182 2 172 8 Yunnan, China
2294 2294     Shanxi China 2020-03-31 23:35:56 37.5777 112.2922 137 0 133 4 Shanxi, China
2293 2293     Shanghai China 2020-04-01 00:04:18 31.201999999999998 121.4491 516 6 341 169 Shanghai, China
2252 2252     Hebei China 2020-04-01 00:13:24 39.549 116.1306 323 6 310 7 Hebei, China
2263 2263     Liaoning China 2020-04-01 00:18:27 41.2956 122.6085 140 2 124 14 Liaoning, China
2227 2227     Beijing China 2020-04-01 00:55:49 40.1824 116.4142 580 8 418 154 Beijing, China
2291 2291     Shaanxi China 2020-04-01 01:36:18 35.1917 108.8701 255 3 242 10 Shaanxi, China
2248 2248     Guangdong China 2020-04-01 05:36:53 23.3417 113.4244 1501 8 1357 136 Guangdong, China
2256 2256     Hubei China 2020-04-01 06:20:26 30.9756 112.2707 67802 3193 63326 1283 Hubei, China
2258 2258     Inner Mongolia China 2020-04-01 06:20:26 44.0935 113.9448 111 1 74 36 Inner Mongolia, China
2300 2300     Tianjin China 2020-04-01 10:53:31 39.3054 117.323 176 3 135 38 Tianjin, China
2468 2468       Taiwan* 2020-04-01 10:56:33 23.7 121.0 329 5 39 285 Taiwan*
2255 2255     Hong Kong China 2020-04-01 11:07:39 22.3 114.2 765 4 147 614 Hong Kong, China
2240 2240     Fujian China 2020-04-01 11:54:10 26.0789 117.9874 345 1 298 46 Fujian, China
2295 2295     Sichuan China 2020-04-01 11:54:10 30.6171 102.7103 552 3 537 12 Sichuan, China
2241 2241     Gansu China 2020-04-01 14:00:34 37.8099 101.0583 138 2 127 9 Gansu, China
2223 2223     Anguilla United Kingdom 2020-04-01 21:58:34 18.2206 -63.0686 2 0 0 2 Anguilla, United Kingdom
2225 2225     Aruba Netherlands 2020-04-01 21:58:34 12.5211 -69.9683 55 0 1 54 Aruba, Netherlands
2228 2228     Bermuda United Kingdom 2020-04-01 21:58:34 32.3078 -64.7505 32 0 10 22 Bermuda, United Kingdom
2230 2230     British Virgin Islands United Kingdom 2020-04-01 21:58:34 18.4207 -64.64 3 0 0 3 British Virgin Islands, United Kingdom
2231 2231     Cayman Islands United Kingdom 2020-04-01 21:58:34 19.3133 -81.2546 22 1 0 21 Cayman Islands, United Kingdom
2232 2232     Channel Islands United Kingdom 2020-04-01 21:58:34 49.3723 -2.3644 172 3 0 169 Channel Islands, United Kingdom
2234 2234     Curacao Netherlands 2020-04-01 21:58:34 12.1696 -68.99 11 1 3 7 Curacao, Netherlands
2237 2237     Faroe Islands Denmark 2020-04-01 21:58:34 61.8926 -6.9118 173 0 75 98 Faroe Islands, Denmark
2238 2238     French Guiana France 2020-04-01 21:58:34 4.0 -53.0 51 0 15 36 French Guiana, France
2239 2239     French Polynesia France 2020-04-01 21:58:34 -17.6797 -149.4068 37 0 0 37 French Polynesia, France
2242 2242     Gibraltar United Kingdom 2020-04-01 21:58:34 36.1408 -5.3536 81 0 34 47 Gibraltar, United Kingdom
2245 2245     Greenland Denmark 2020-04-01 21:58:34 71.7069 -42.6043 10 0 2 8 Greenland, Denmark
2246 2246     Guadeloupe France 2020-04-01 21:58:34 16.265 -61.551 125 6 24 95 Guadeloupe, France
2259 2259     Isle of Man United Kingdom 2020-04-01 21:58:34 54.2361 -4.5481 68 1 0 67 Isle of Man, United Kingdom
2266 2266     Martinique France 2020-04-01 21:58:34 14.6415 -61.0242 135 3 27 105 Martinique, France
2267 2267     Mayotte France 2020-04-01 21:58:34 -12.8275 45.166244 94 1 10 83 Mayotte, France
2268 2268     Montserrat United Kingdom 2020-04-01 21:58:34 16.742498 -62.187366000000004 5 0 0 5 Montserrat, United Kingdom
2270 2270     New Caledonia France 2020-04-01 21:58:34 -20.904304999999997 165.618042 16 0 0 16 New Caledonia, France
2287 2287     Reunion France 2020-04-01 21:58:34 -21.1151 55.5364 281 0 40 241 Reunion, France
2288 2288     Saint Barthelemy France 2020-04-01 21:58:34 17.9 -62.8333 6 0 1 5 Saint Barthelemy, France
2289 2289     Saint Helena, Ascension and Tristan da Cunha United Kingdom 2020-04-01 21:58:34 -7.9467 -14.3559 0 0 0 0 Saint Helena, Ascension and Tristan da Cunha, United Kingdom
2296 2296     Sint Maarten Netherlands 2020-04-01 21:58:34 18.0425 -63.0548 16 1 6 9 Sint Maarten, Netherlands
2298 2298     St Martin France 2020-04-01 21:58:34 18.0708 -63.0501 15 1 2 12 St Martin, France
2302 2302     Turks and Caicos Islands United Kingdom 2020-04-01 21:58:34 21.69400000000001 -71.7979 6 0 0 6 Turks and Caicos Islands, United Kingdom
2310 2310       Afghanistan 2020-04-01 21:58:34 33.93911 67.709953 197 4 5 228 Afghanistan
2311 2311       Albania 2020-04-01 21:58:34 41.1533 20.1683 259 15 67 177 Albania
2312 2312       Algeria 2020-04-01 21:58:34 28.0339 1.6596 847 58 61 728 Algeria
2313 2313       Andorra 2020-04-01 21:58:34 42.5063 1.5218 390 14 10 366 Andorra
2314 2314       Angola 2020-04-01 21:58:34 -11.2027 17.8739 8 2 1 5 Angola
2315 2315       Antigua and Barbuda 2020-04-01 21:58:34 17.0608 -61.7964 7 0 0 7 Antigua and Barbuda
2316 2316       Argentina 2020-04-01 21:58:34 -38.4161 -63.6167 1054 28 248 778 Argentina
2317 2317       Armenia 2020-04-01 21:58:34 40.0691 45.0382 571 4 31 536 Armenia
2318 2318       Austria 2020-04-01 21:58:34 47.5162 14.5501 10711 146 1436 9129 Austria
2319 2319       Azerbaijan 2020-04-01 21:58:34 40.1431 47.5769 359 5 26 328 Azerbaijan
2320 2320       Bahamas 2020-04-01 21:58:34 25.025885 -78.035889 21 1 1 19 Bahamas
2321 2321       Bahrain 2020-04-01 21:58:34 26.0275 50.55 569 4 337 228 Bahrain
2322 2322       Bangladesh 2020-04-01 21:58:34 23.685 90.3563 54 6 25 23 Bangladesh
2323 2323       Barbados 2020-04-01 21:58:34 13.1939 -59.5432 34 0 0 34 Barbados
2324 2324       Belarus 2020-04-01 21:58:34 53.7098 27.9534 163 2 53 108 Belarus
2325 2325       Belgium 2020-04-01 21:58:34 50.8333 4.469936 13964 828 2132 11004 Belgium
2326 2326       Belize 2020-04-01 21:58:34 17.1899 -88.4976 3 0 0 3 ,,Belize
2327 2327       Benin 2020-04-01 21:58:34 9.3077 2.3158 13 0 1 12 Benin
2328 2328       Bhutan 2020-04-01 21:58:34 27.5142 90.4336 4 0 0 4 Bhutan
2329 2329       Bolivia 2020-04-01 21:58:34 -16.2902 -63.5887 115 7 1 107 Bolivia
2330 2330       Bosnia and Herzegovina 2020-04-01 21:58:34 43.9159 17.6791 459 13 19 427 Bosnia and Herzegovina
2331 2331       Botswana 2020-04-01 21:58:34 -22.3285 24.6849 4 1 0 3 Botswana
2332 2332       Brazil 2020-04-01 21:58:34 -14.235 -51.9253 6836 240 127 6469 Brazil
2333 2333       Brunei 2020-04-01 21:58:34 4.5353 114.7277 131 1 52 78 Brunei
2334 2334       Bulgaria 2020-04-01 21:58:34 42.7339 25.4858 422 10 20 392 Bulgaria
2335 2335       Burkina Faso 2020-04-01 21:58:34 12.2383 -1.5616 282 16 46 220 Burkina Faso
2336 2336       Burma 2020-04-01 21:58:34 21.9162 95.956 15 1 0 14 Burma
2337 2337       Burundi 2020-04-01 21:58:34 -3.3731 29.9189 2 0 0 2 Burundi
2338 2338       Cabo Verde 2020-04-01 21:58:34 16.5388 -23.0418 6 1 0 5 Cabo Verde
2339 2339       Cambodia 2020-04-01 21:58:34 11.55 104.9167 109 0 25 84 Cambodia
2340 2340       Cameroon 2020-04-01 21:58:34 3.8480000000000003 11.5021 233 6 10 217 Cameroon
2341 2341       Central African Republic 2020-04-01 21:58:34 6.6111 20.9394 3 0 0 3 Central African Republic
2342 2342       Chad 2020-04-01 21:58:34 15.4542 18.7322 7 0 0 7 Chad
2343 2343       Chile 2020-04-01 21:58:34 -35.6751 -71.543 3031 16 234 2781 Chile
2344 2344       Colombia 2020-04-01 21:58:34 4.5709 -74.2973 1065 17 39 1009 Colombia
2345 2345       Congo (Brazzaville) 2020-04-01 21:58:34 -4.2634 15.2832 19 0 0 19 Congo (Brazzaville)
2346 2346       Congo (Kinshasa) 2020-04-01 21:58:34 -4.322447 15.307045 109 9 3 97 Congo (Kinshasa)
2347 2347       Costa Rica 2020-04-01 21:58:34 9.7489 -83.7534 375 2 4 369 Costa Rica
2348 2348       Cote d'Ivoire 2020-04-01 21:58:34 7.54 -5.5471 190 1 9 180 Cote d'Ivoire
2349 2349       Croatia 2020-04-01 21:58:34 45.1 15.2 963 6 73 884 Croatia
2350 2350       Cuba 2020-04-01 21:58:34 21.521757 -77.78116700000002 212 6 12 194 Cuba
2351 2351       Cyprus 2020-04-01 21:58:34 35.1264 33.4299 320 9 28 283 Cyprus

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

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