04-02-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,572 rows sorted by Country_Region

✎ View and edit SQL

This data as json, copyable, CSV (advanced)

Link rowid FIPS Admin2 Province_State Country_Region ▼ Last_Update Lat Long_ Confirmed Deaths Recovered Active Combined_Key
2394 2394       Afghanistan 4/2/20 23:25 33.93911 67.709953 240 4 10 257 Afghanistan
2395 2395       Albania 4/2/20 23:25 41.1533 20.1683 277 16 76 185 Albania
2396 2396       Algeria 4/2/20 23:25 28.0339 1.6596 986 86 61 839 Algeria
2397 2397       Andorra 4/2/20 23:25 42.5063 1.5218 428 15 10 403 Andorra
2398 2398       Angola 4/2/20 23:25 -11.2027 17.8739 8 2 1 5 Angola
2399 2399       Antigua and Barbuda 4/2/20 23:25 17.0608 -61.7964 9 0 0 9 Antigua and Barbuda
2400 2400       Argentina 4/2/20 23:25 -38.4161 -63.6167 1133 36 256 841 Argentina
2401 2401       Armenia 4/2/20 23:25 40.0691 45.0382 663 7 33 623 Armenia
2309 2309     Australian Capital Territory Australia 4/2/20 23:32 -35.4735 149.0124 87 1 11 75 Australian Capital Territory, Australia
2355 2355     New South Wales Australia 4/2/20 23:32 -33.8688 151.2093 2298 10 4 2284 New South Wales, Australia
2359 2359     Northern Territory Australia 4/2/20 23:32 -12.4634 130.8456 21 0 0 21 Northern Territory, Australia
2368 2368     Queensland Australia 4/2/20 23:32 -27.4698 153.0251 835 4 8 823 Queensland, Australia
2381 2381     South Australia Australia 4/2/20 23:32 -34.9285 138.6007 367 0 6 361 South Australia, Australia
2383 2383     Tasmania Australia 4/2/20 23:32 -42.8821 147.3272 72 2 5 65 Tasmania, Australia
2387 2387     Victoria Australia 4/2/20 23:32 -37.8136 144.9631 1036 5 422 609 Victoria, Australia
2389 2389     Western Australia Australia 4/2/20 23:32 -31.9505 115.8605 400 2 64 334 Western Australia, Australia
2402 2402       Austria 4/2/20 23:25 47.5162 14.5501 11129 158 1749 9222 Austria
2403 2403       Azerbaijan 4/2/20 23:25 40.1431 47.5769 400 5 26 369 Azerbaijan
2404 2404       Bahamas 4/2/20 23:25 25.025885 -78.035889 24 1 1 22 Bahamas
2405 2405       Bahrain 4/2/20 23:25 26.0275 50.55 643 4 381 258 Bahrain
2406 2406       Bangladesh 4/2/20 23:25 23.685 90.3563 56 6 25 25 Bangladesh
2407 2407       Barbados 4/2/20 23:25 13.1939 -59.5432 46 0 0 46 Barbados
2408 2408       Belarus 4/2/20 23:25 53.7098 27.9534 304 4 53 247 Belarus
2409 2409       Belgium 4/2/20 23:25 50.8333 4.469936 15348 1011 2495 11842 Belgium
2410 2410       Belize 4/2/20 23:25 17.1899 -88.4976 3 0 0 3 ,,Belize
2411 2411       Benin 4/2/20 23:25 9.3077 2.3158 13 0 1 12 Benin
2412 2412       Bhutan 4/2/20 23:25 27.5142 90.4336 5 0 1 4 Bhutan
2413 2413       Bolivia 4/2/20 23:25 -16.2902 -63.5887 123 8 1 114 Bolivia
2414 2414       Bosnia and Herzegovina 4/2/20 23:25 43.9159 17.6791 533 16 20 497 Bosnia and Herzegovina
2415 2415       Botswana 4/2/20 23:25 -22.3285 24.6849 4 1 0 3 Botswana
2416 2416       Brazil 4/2/20 23:25 -14.235 -51.9253 8044 324 127 7593 Brazil
2417 2417       Brunei 4/2/20 23:25 4.5353 114.7277 133 1 56 76 Brunei
2418 2418       Bulgaria 4/2/20 23:25 42.7339 25.4858 457 10 25 422 Bulgaria
2419 2419       Burkina Faso 4/2/20 23:25 12.2383 -1.5616 288 16 50 222 Burkina Faso
2420 2420       Burma 4/2/20 23:25 21.9162 95.956 20 1 0 19 Burma
2421 2421       Burundi 4/2/20 23:25 -3.3731 29.9189 3 0 0 3 Burundi
2422 2422       Cabo Verde 4/2/20 23:25 16.5388 -23.0418 6 1 0 5 Cabo Verde
2423 2423       Cambodia 4/2/20 23:25 11.55 104.9167 110 0 34 76 Cambodia
2424 2424       Cameroon 4/2/20 23:25 3.848 11.5021 306 7 10 289 Cameroon
2305 2305     Alberta Canada 4/2/20 23:31 53.9333 -116.5765 969 13 0 0 Alberta, Canada
2313 2313     British Columbia Canada 4/2/20 23:31 53.7267 -127.6476 1121 31 0 0 British Columbia, Canada
2319 2319     Diamond Princess Canada 4/2/20 23:31     0 1 0 0 Diamond Princess, Canada
2327 2327     Grand Princess Canada 4/2/20 23:31     13 0 0 0 Grand Princess, Canada
2349 2349     Manitoba Canada 4/2/20 23:31 53.7609 -98.8139 167 1 0 0 Manitoba, Canada
2353 2353     New Brunswick Canada 4/2/20 23:31 46.5653 -66.4619 91 0 0 0 New Brunswick, Canada
2356 2356     Newfoundland and Labrador Canada 4/2/20 23:31 53.1355 -57.6604 183 1 0 0 Newfoundland and Labrador, Canada
2360 2360     Northwest Territories Canada 4/2/20 23:31 64.8255 -124.8457 2 0 0 0 ,Northwest Territories,Canada
2361 2361     Nova Scotia Canada 4/2/20 23:31 44.682 -63.7443 193 0 0 0 Nova Scotia, Canada
2362 2362     Nunavut Canada 4/2/20 23:31 70.2998 -83.1076 0 0 0 0 Nunavut, Canada
2363 2363     Ontario Canada 4/2/20 23:31 51.2538 -85.3232 2793 53 0 0 Ontario, Canada
2364 2364     Prince Edward Island Canada 4/2/20 23:31 46.5107 -63.4168 22 0 0 0 Prince Edward Island, Canada
2367 2367     Quebec Canada 4/2/20 23:31 52.9399 -73.5491 5518 121 0 0 Quebec, Canada
2369 2369     Recovered Canada 4/2/20 23:31     0 0 1735 0 Recovered, Canada
2374 2374     Saskatchewan Canada 4/2/20 23:31 52.9399 -106.4509 206 3 0 0 Saskatchewan, Canada
2391 2391     Yukon Canada 4/2/20 23:31 64.2823 -135.0 6 0 0 0 ,Yukon,Canada
2425 2425       Central African Republic 4/2/20 23:25 6.6111 20.9394 3 0 0 3 Central African Republic
2426 2426       Chad 4/2/20 23:25 15.4542 18.7322 8 0 0 8 Chad
2427 2427       Chile 4/2/20 23:25 -35.6751 -71.543 3404 18 335 3051 Chile
2307 2307     Anhui China 3/8/20 5:19 31.8257 117.2264 990 6 984 0 Anhui, China
2310 2310     Beijing China 4/2/20 2:23 40.1824 116.4142 582 8 424 150 Beijing, China
2317 2317     Chongqing China 3/29/20 0:14 30.0572 107.874 579 6 570 3 Chongqing, China
2324 2324     Fujian China 4/2/20 1:38 26.0789 117.9874 345 1 299 45 Fujian, China
2325 2325     Gansu China 4/1/20 14:00 37.8099 101.0583 138 2 127 9 Gansu, China
2332 2332     Guangdong China 4/2/20 1:26 23.3417 113.4244 1507 8 1365 134 Guangdong, China
2333 2333     Guangxi China 4/2/20 0:16 23.8298 108.7881 254 2 252 0 Guangxi, China
2334 2334     Guizhou China 3/18/20 1:37 26.8154 106.8748 146 2 144 0 Guizhou, China
2335 2335     Hainan China 3/24/20 4:19 19.1959 109.7453 168 6 162 0 Hainan, China
2336 2336     Hebei China 4/2/20 0:09 39.549 116.1306 325 6 310 9 Hebei, China
2337 2337     Heilongjiang China 4/2/20 0:09 47.862 127.7615 488 13 469 6 Heilongjiang, China
2338 2338     Henan China 3/29/20 1:44 33.882 113.614 1276 22 1251 3 Henan, China
2339 2339     Hong Kong China 4/2/20 8:53 22.3 114.2 802 4 147 651 Hong Kong, China
2340 2340     Hubei China 4/2/20 8:26 30.9756 112.2707 67802 3199 63471 1132 Hubei, China
2341 2341     Hunan China 4/2/20 1:30 27.6104 111.7088 1019 4 1014 1 Hunan, China
2342 2342     Inner Mongolia China 4/1/20 23:56 44.0935 113.9448 117 1 74 42 Inner Mongolia, China
2344 2344     Jiangsu China 4/2/20 0:58 32.9711 119.455 647 0 631 16 Jiangsu, China
2345 2345     Jiangxi China 3/30/20 3:15 27.614 115.7221 937 1 935 1 Jiangxi, China
2346 2346     Jilin China 3/29/20 0:28 43.6661 126.1923 98 1 92 5 Jilin, China
2347 2347     Liaoning China 4/2/20 13:24 41.2956 122.6085 141 2 124 15 Liaoning, China
2348 2348     Macau China 3/31/20 13:54 22.1667 113.55 41 0 10 31 Macau, China
2357 2357     Ningxia China 3/16/20 8:47 37.2692 106.1655 75 0 75 0 Ningxia, China
2366 2366     Qinghai China 2/23/20 11:19 35.7452 95.9956 18 0 18 0 Qinghai, China
2375 2375     Shaanxi China 4/1/20 1:36 35.1917 108.8701 255 3 242 10 Shaanxi, China
2376 2376     Shandong China 4/2/20 0:34 36.3427 118.1498 775 7 753 15 Shandong, China
2377 2377     Shanghai China 4/2/20 0:34 31.202 121.4491 522 6 343 173 Shanghai, China
2378 2378     Shanxi China 3/31/20 23:35 37.5777 112.2922 137 0 133 4 Shanxi, China
2379 2379     Sichuan China 4/2/20 0:58 30.6171 102.7103 554 3 537 14 Sichuan, China
2384 2384     Tianjin China 4/1/20 10:53 39.3054 117.323 176 3 135 38 Tianjin, China
2385 2385     Tibet China 2/23/20 11:19 31.6927 88.0924 1 0 1 0 Tibet, China
2390 2390     Xinjiang China 3/8/20 5:31 41.1129 85.2401 76 3 73 0 Xinjiang, China
2392 2392     Yunnan China 4/1/20 23:43 24.974 101.487 183 2 172 9 Yunnan, China
2393 2393     Zhejiang China 4/2/20 1:20 29.1832 120.0934 1258 1 1228 29 Zhejiang, China
2428 2428       Colombia 4/2/20 23:25 4.5709 -74.2973 1161 19 55 1087 Colombia
2429 2429       Congo (Brazzaville) 4/2/20 23:25 -4.2634 15.2832 22 2 2 18 Congo (Brazzaville)
2430 2430       Congo (Kinshasa) 4/2/20 23:25 -4.322447 15.307045 134 13 3 118 Congo (Kinshasa)
2431 2431       Costa Rica 4/2/20 23:25 9.7489 -83.7534 396 2 6 388 Costa Rica
2432 2432       Cote d'Ivoire 4/2/20 23:25 7.54 -5.5471 194 1 15 178 Cote d'Ivoire
2433 2433       Croatia 4/2/20 23:25 45.1 15.2 1011 7 88 916 Croatia
2434 2434       Cuba 4/2/20 23:25 21.521757 -77.781167 233 6 13 214 Cuba
2435 2435       Cyprus 4/2/20 23:25 35.1264 33.4299 356 10 28 318 Cyprus
2436 2436       Czechia 4/2/20 23:25 49.8175 15.473 3858 44 67 3747 Czechia

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

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