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 Country_Region

✎ 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
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
2226 2226     Australian Capital Territory Australia 2020-04-01 22:04:58 -35.4735 149.0124 84 1 8 75 Australian Capital Territory, Australia
2271 2271     New South Wales Australia 2020-04-01 22:04:58 -33.8688 151.2093 2182 9 4 2169 New South Wales, Australia
2275 2275     Northern Territory Australia 2020-04-01 22:04:58 -12.4634 130.8456 19 0 0 19 Northern Territory, Australia
2284 2284     Queensland Australia 2020-04-01 22:04:58 -27.4698 153.0251 781 2 8 771 Queensland, Australia
2297 2297     South Australia Australia 2020-04-01 22:04:58 -34.9285 138.6007 367 0 6 361 South Australia, Australia
2299 2299     Tasmania Australia 2020-04-01 22:04:58 -42.8821 147.3272 69 2 5 62 Tasmania, Australia
2303 2303     Victoria Australia 2020-04-01 22:04:58 -37.8136 144.9631 968 4 343 621 Victoria, Australia
2305 2305     Western Australia Australia 2020-04-01 22:04:58 -31.9505 115.8605 392 2 48 342 Western Australia, Australia
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
2222 2222     Alberta Canada 2020-04-01 22:04:44 53.9333 -116.5765 754 9 0 0 Alberta, Canada
2229 2229     British Columbia Canada 2020-04-01 22:04:44 53.7267 -127.6476 1013 24 0 0 British Columbia, Canada
2235 2235     Diamond Princess Canada 2020-04-01 22:04:44 0.0 0.0 0 1 0 0 Diamond Princess, Canada
2243 2243     Grand Princess Canada 2020-04-01 22:04:44 0.0 0.0 13 0 0 0 Grand Princess, Canada
2265 2265     Manitoba Canada 2020-04-01 22:04:44 53.7609 -98.8139 127 1 0 0 Manitoba, Canada
2269 2269     New Brunswick Canada 2020-04-01 22:04:44 46.5653 -66.4619 81 0 0 0 New Brunswick, Canada
2272 2272     Newfoundland and Labrador Canada 2020-04-01 22:04:44 53.1355 -57.6604 175 1 0 0 Newfoundland and Labrador, Canada
2276 2276     Northwest Territories Canada 2020-04-01 22:04:44 64.8255 -124.8457 2 0 0 0 ,Northwest Territories,Canada
2277 2277     Nova Scotia Canada 2020-04-01 22:04:44 44.681999999999995 -63.7443 173 0 0 0 Nova Scotia, Canada
2278 2278     Nunavut Canada 2020-04-01 22:04:44 70.2998 -83.1076 0 0 0 0 Nunavut, Canada
2279 2279     Ontario Canada 2020-04-01 22:04:44 51.2538 -85.3232 2392 37 0 0 Ontario, Canada
2280 2280     Prince Edward Island Canada 2020-04-01 22:04:44 46.5107 -63.4168 21 0 0 0 Prince Edward Island, Canada
2283 2283     Quebec Canada 2020-04-01 22:04:44 52.9399 -73.5491 4611 99 0 0 Quebec, Canada
2285 2285     Recovered Canada 2020-04-01 22:04:44 0.0 0.0 0 0 1324 0 Recovered, Canada
2290 2290     Saskatchewan Canada 2020-04-01 22:04:44 52.9399 -106.4509 193 3 0 0 Saskatchewan, Canada
2307 2307     Yukon Canada 2020-04-01 22:04:44 64.2823 -135.0 5 0 0 0 ,Yukon,Canada
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
2224 2224     Anhui China 2020-03-08 05:19:01 31.8257 117.2264 990 6 984 0 Anhui, China
2227 2227     Beijing China 2020-04-01 00:55:49 40.1824 116.4142 580 8 418 154 Beijing, China
2233 2233     Chongqing China 2020-03-29 00:14:12 30.0572 107.874 579 6 570 3 Chongqing, China
2240 2240     Fujian China 2020-04-01 11:54:10 26.0789 117.9874 345 1 298 46 Fujian, China
2241 2241     Gansu China 2020-04-01 14:00:34 37.8099 101.0583 138 2 127 9 Gansu, China
2248 2248     Guangdong China 2020-04-01 05:36:53 23.3417 113.4244 1501 8 1357 136 Guangdong, China
2249 2249     Guangxi China 2020-03-20 04:33:45 23.8298 108.7881 254 2 250 2 Guangxi, China
2250 2250     Guizhou China 2020-03-18 01:37:43 26.8154 106.8748 146 2 144 0 Guizhou, China
2251 2251     Hainan China 2020-03-24 04:29:15 19.1959 109.7453 168 6 162 0 Hainan, China
2252 2252     Hebei China 2020-04-01 00:13:24 39.549 116.1306 323 6 310 7 Hebei, China
2253 2253     Heilongjiang China 2020-03-26 00:15:39 47.861999999999995 127.7615 484 13 469 2 Heilongjiang, China
2254 2254     Henan China 2020-03-29 01:44:01 33.882 113.61399999999999 1276 22 1251 3 Henan, China
2255 2255     Hong Kong China 2020-04-01 11:07:39 22.3 114.2 765 4 147 614 Hong Kong, China
2256 2256     Hubei China 2020-04-01 06:20:26 30.9756 112.2707 67802 3193 63326 1283 Hubei, China
2257 2257     Hunan China 2020-03-14 08:25:05 27.6104 111.7088 1018 4 1014 0 Hunan, China
2258 2258     Inner Mongolia China 2020-04-01 06:20:26 44.0935 113.9448 111 1 74 36 Inner Mongolia, China
2260 2260     Jiangsu China 2020-03-31 01:10:41 32.9711 119.455 646 0 631 15 Jiangsu, China
2261 2261     Jiangxi China 2020-03-30 03:15:15 27.614 115.7221 937 1 935 1 Jiangxi, China
2262 2262     Jilin China 2020-03-29 00:28:20 43.6661 126.1923 98 1 92 5 Jilin, China
2263 2263     Liaoning China 2020-04-01 00:18:27 41.2956 122.6085 140 2 124 14 Liaoning, China
2264 2264     Macau China 2020-03-31 13:54:04 22.1667 113.55 41 0 10 31 Macau, China
2273 2273     Ningxia China 2020-03-16 08:47:05 37.2692 106.1655 75 0 75 0 Ningxia, China
2282 2282     Qinghai China 2020-02-23 11:19:02 35.7452 95.9956 18 0 18 0 Qinghai, China
2291 2291     Shaanxi China 2020-04-01 01:36:18 35.1917 108.8701 255 3 242 10 Shaanxi, China
2292 2292     Shandong China 2020-03-31 00:44:17 36.3427 118.1498 774 7 753 14 Shandong, China
2293 2293     Shanghai China 2020-04-01 00:04:18 31.201999999999998 121.4491 516 6 341 169 Shanghai, China
2294 2294     Shanxi China 2020-03-31 23:35:56 37.5777 112.2922 137 0 133 4 Shanxi, China
2295 2295     Sichuan China 2020-04-01 11:54:10 30.6171 102.7103 552 3 537 12 Sichuan, China
2300 2300     Tianjin China 2020-04-01 10:53:31 39.3054 117.323 176 3 135 38 Tianjin, China
2301 2301     Tibet China 2020-02-23 11:19:02 31.6927 88.0924 1 0 1 0 Tibet, China
2306 2306     Xinjiang China 2020-03-08 05:31:02 41.1129 85.2401 76 3 73 0 Xinjiang, China
2308 2308     Yunnan China 2020-03-31 23:31:54 24.974 101.48700000000001 182 2 172 8 Yunnan, China
2309 2309     Zhejiang China 2020-03-31 01:23:49 29.1832 120.0934 1257 1 1226 30 Zhejiang, China
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
2352 2352       Czechia 2020-04-01 21:58:34 49.8175 15.472999999999999 3508 39 61 3408 Czechia

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
);