03-31-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,437 rows sorted by Recovered 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
2207 2207     Hubei China 2020-03-31 01:06:37 30.9756 112.2707 67801 3187 63153 1461 Hubei, China
2412 2412       Spain 2020-03-31 23:43:43 40.463667 -3.7492199999999998 95923 8464 19259 68200 Spain
2323 2323       Germany 2020-03-31 23:43:43 51.165690999999995 10.451526 71808 775 16100 54933 Germany
2342 2342       Italy 2020-03-31 23:43:43 41.87194 12.56738 105792 12428 15729 77635 Italy
2338 2338       Iran 2020-03-31 23:43:43 32.427908 53.68804599999999 44605 2898 14656 27051 Iran
2319 2319       France 2020-03-31 23:43:43 46.2276 2.2137 51579 3517 9444 39161 France
2237 2237     Recovered US 2020-03-31 23:43:56 0.0 0.0 0 0 7024 0 Recovered, US
2348 2348       Korea, South 2020-03-31 23:43:43 35.90775700000001 127.766922 9786 162 5408 4216 Korea, South
2417 2417       Switzerland 2020-03-31 23:43:43 46.8182 8.2275 16605 433 1823 14349 Switzerland
2276 2276       Belgium 2020-03-31 23:43:43 50.8333 4.469936 12775 705 1696 10374 Belgium
2236 2236     Recovered Canada 2020-03-31 23:49:13 0.0 0.0 0 0 1592 0 Recovered, Canada
2199 2199     Guangdong China 2020-03-31 09:56:36 23.3417 113.4244 1494 8 1356 130 Guangdong, China
2205 2205     Henan China 2020-03-29 01:44:01 33.882 113.614 1276 22 1251 3 Henan, China
2260 2260     Zhejiang China 2020-03-31 01:23:49 29.1832 120.0934 1257 1 1226 30 Zhejiang, China
2269 2269       Austria 2020-03-31 23:43:43 47.5162 14.5501 10180 128 1095 8957 Austria
2208 2208     Hunan China 2020-03-14 08:25:05 27.6104 111.7088 1018 4 1014 0 Hunan, China
2175 2175     Anhui China 2020-03-08 05:19:01 31.8257 117.2264 990 6 984 0 Anhui, China
2212 2212     Jiangxi China 2020-03-30 03:15:15 27.614 115.7221 937 1 935 1 Jiangxi, China
2243 2243     Shandong China 2020-03-31 00:44:17 36.3427 118.1498 774 7 753 14 Shandong, China
2211 2211     Jiangsu China 2020-03-31 01:10:41 32.9711 119.455 646 0 631 15 Jiangsu, China
2305 2305       Diamond Princess 2020-03-31 23:43:43 0.0 0.0 712 10 603 99 Diamond Princess
2184 2184     Chongqing China 2020-03-29 00:14:12 30.0572 107.874 579 6 570 3 Chongqing, China
2362 2362       Malaysia 2020-03-31 23:43:43 4.210483999999999 101.97576600000001 2766 43 537 2186 Malaysia
2246 2246     Sichuan China 2020-03-30 01:09:15 30.6171 102.7103 550 3 536 11 Sichuan, China
2204 2204     Heilongjiang China 2020-03-26 00:15:39 47.862 127.7615 484 13 469 2 Heilongjiang, China
2344 2344       Japan 2020-03-31 23:43:43 36.204824 138.252924 1953 56 424 1473 Japan
2178 2178     Beijing China 2020-03-31 05:46:54 40.1824 116.4142 580 8 418 154 Beijing, China
2389 2389       Peru 2020-03-31 23:43:43 -9.19 -75.0152 1065 30 394 641 Peru
2421 2421       Thailand 2020-03-31 23:43:43 15.870032 100.992541 1651 10 342 1299 Thailand
2244 2244     Shanghai China 2020-03-31 07:43:11 31.202 121.4491 509 5 341 163 Shanghai, China
2203 2203     Hebei China 2020-03-30 02:07:50 39.549 116.1306 321 6 310 5 Hebei, China
2191 2191     Fujian China 2020-03-31 02:10:31 26.0789 117.9874 343 1 295 47 Fujian, China
2272 2272       Bahrain 2020-03-31 23:43:43 26.0275 50.55 567 4 295 268 Bahrain
2254 2254     Victoria Australia 2020-03-31 23:49:27 -37.8136 144.9631 917 4 291 622 Victoria, Australia
2200 2200     Guangxi China 2020-03-20 04:33:45 23.8298 108.7881 254 2 250 2 Guangxi, China
2377 2377       Netherlands 2020-03-31 23:43:43 52.1326 5.2913 12595 1039 250 11306 Netherlands
2426 2426       Turkey 2020-03-31 23:43:43 38.9637 35.2433 13531 214 243 13074 Turkey
2242 2242     Shaanxi China 2020-03-26 02:14:25 35.1917 108.8701 253 3 242 8 Shaanxi, China
2267 2267       Argentina 2020-03-31 23:43:43 -38.4161 -63.6167 1054 27 240 787 Argentina
2407 2407       Singapore 2020-03-31 23:43:43 1.2833 103.8333 926 3 240 683 Singapore
2394 2394       Romania 2020-03-31 23:43:43 45.9432 24.9668 2245 82 220 1943 Romania
2341 2341       Israel 2020-03-31 23:43:43 31.046051000000002 34.851612 5717 21 210 5114 Israel
2335 2335       Iceland 2020-03-31 23:43:43 64.9631 -19.0208 1135 2 198 935 Iceland
2259 2259     Yunnan China 2020-03-31 23:31:54 24.974 101.487 182 2 172 8 Yunnan, China
2339 2339       Iraq 2020-03-31 23:43:43 33.223191 43.679291 694 50 170 474 Iraq
2402 2402       Saudi Arabia 2020-03-31 23:43:43 23.885942 45.079162 1563 10 165 1388 Saudi Arabia
2202 2202     Hainan China 2020-03-24 04:29:15 19.1959 109.7453 168 6 162 0 Hainan, China
2310 2310       Egypt 2020-03-31 23:43:43 26.820553000000004 30.802497999999996 710 46 157 507 Egypt
2294 2294       Chile 2020-03-31 23:43:43 -35.6751 -71.543 2738 12 156 2570 Chile
2201 2201     Guizhou China 2020-03-18 01:37:43 26.8154 106.8748 146 2 144 0 Guizhou, China
2251 2251     Tianjin China 2020-03-31 13:54:04 39.3054 117.323 174 3 135 36 Tianjin, China
2430 2430       United Kingdom 2020-03-31 23:43:43 55.3781 -3.4360000000000004 25150 1789 135 23226 United Kingdom
2245 2245     Shanxi China 2020-03-29 00:20:15 37.5777 112.2922 136 0 133 3 Shanxi, China
2206 2206     Hong Kong China 2020-03-31 09:10:05 22.3 114.2 714 4 128 582 Hong Kong, China
2283 2283       Brazil 2020-03-31 23:43:43 -14.235 -51.9253 5717 201 127 5389 Brazil
2192 2192     Gansu China 2020-03-29 14:25:46 37.8099 101.0583 138 2 125 11 Gansu, China
2214 2214     Liaoning China 2020-03-31 00:23:00 41.2956 122.6085 139 2 124 13 Liaoning, China
2336 2336       India 2020-03-31 23:43:43 20.593684 78.96288 1397 35 123 1239 India
2395 2395       Russia 2020-03-31 23:43:43 61.52401 105.31875600000001 2337 17 121 2199 Russia
2213 2213     Jilin China 2020-03-29 00:28:20 43.6661 126.1923 98 1 92 5 Jilin, China
2337 2337       Indonesia 2020-03-31 23:43:43 -0.7893 113.9213 1528 136 81 1311 Indonesia
2359 2359       Luxembourg 2020-03-31 23:43:43 49.8153 6.1296 2178 23 80 2075 Luxembourg
2385 2385       Pakistan 2020-03-31 23:43:43 30.3753 69.3451 1938 26 76 1836 Pakistan
2224 2224     Ningxia China 2020-03-16 08:47:05 37.2692 106.1655 75 0 75 0 Ningxia, China
2188 2188     Faroe Islands Denmark 2020-03-31 23:43:43 61.8926 -6.9118 169 0 74 95 Faroe Islands, Denmark
2209 2209     Inner Mongolia China 2020-03-30 23:54:43 44.0935 113.9448 107 1 74 32 Inner Mongolia, China
2378 2378       New Zealand 2020-03-31 23:43:43 -40.9006 174.886 647 1 74 572 New Zealand
2257 2257     Xinjiang China 2020-03-08 05:31:02 41.1129 85.2401 76 3 73 0 Xinjiang, China
2350 2350       Kuwait 2020-03-31 23:43:43 29.311659999999996 47.481766 289 0 73 216 Kuwait
2300 2300       Croatia 2020-03-31 23:43:43 45.1 15.2 867 6 67 794 Croatia
2393 2393       Qatar 2020-03-31 23:43:43 25.3548 51.1839 781 2 62 717 Qatar
2429 2429       United Arab Emirates 2020-03-31 23:43:43 23.424076 53.847818000000004 664 6 61 597 United Arab Emirates
2434 2434       Vietnam 2020-03-31 23:43:43 14.058323999999999 108.277199 212 0 58 154 Vietnam
2309 2309       Ecuador 2020-03-31 23:43:43 -1.8312 -78.1834 2240 75 54 2111 Ecuador
2262 2262       Albania 2020-03-31 23:43:43 41.1533 20.1683 243 15 52 176 Albania
2325 2325       Greece 2020-03-31 23:43:43 39.0742 21.8243 1314 49 52 1213 Greece
2390 2390       Philippines 2020-03-31 23:43:43 12.879721 121.77401699999999 2084 88 49 1947 Philippines
2275 2275       Belarus 2020-03-31 23:43:43 53.7098 27.9534 152 1 47 104 Belarus
2263 2263       Algeria 2020-03-31 23:43:43 28.0339 1.6596 716 44 46 626 Algeria
2284 2284       Brunei 2020-03-31 23:43:43 4.5353 114.7277 129 1 45 83 Brunei
2303 2303       Czechia 2020-03-31 23:43:43 49.8175 15.472999999999999 3308 31 45 3232 Czechia
2392 2392       Portugal 2020-03-31 23:43:43 39.3999 -8.2245 7443 160 43 7240 Portugal
2256 2256     Western Australia Australia 2020-03-31 23:49:27 -31.9505 115.8605 364 2 41 321 Western Australia, Australia
2431 2431       Uruguay 2020-03-31 23:43:43 -32.5228 -55.7658 338 1 41 296 Uruguay
2403 2403       Senegal 2020-03-31 23:43:43 14.4974 -14.4524 175 0 40 135 Senegal
2419 2419       Taiwan* 2020-03-31 07:26:59 23.7 121.0 322 5 39 278 Taiwan*
2433 2433       Venezuela 2020-03-31 23:43:43 6.4238 -66.5897 135 3 39 93 Venezuela
2334 2334       Hungary 2020-03-31 23:43:43 47.1625 19.5033 492 16 37 439 Hungary
2354 2354       Lebanon 2020-03-31 23:43:43 33.8547 35.8623 470 12 37 421 Lebanon
2368 2368       Mexico 2020-03-31 23:43:43 23.6345 -102.5528 1094 28 35 1031 Mexico
2193 2193     Gibraltar United Kingdom 2020-03-31 23:43:43 36.1408 -5.3536 69 0 34 35 Gibraltar, United Kingdom
2384 2384       Oman 2020-03-31 23:43:43 21.512583 55.92325500000001 192 1 34 157 Oman
2286 2286       Burkina Faso 2020-03-31 23:43:43 12.2383 -1.5616 261 14 32 215 Burkina Faso
2295 2295       Colombia 2020-03-31 23:43:43 4.5709 -74.2973 906 16 31 859 Colombia
2324 2324       Ghana 2020-03-31 23:43:43 7.9465 -1.0232 161 5 31 125 Ghana
2411 2411       South Africa 2020-03-31 23:43:43 -30.5595 22.9375 1353 5 31 1317 South Africa
2268 2268       Armenia 2020-03-31 23:43:43 40.0691 45.0382 532 3 30 499 Armenia
2345 2345       Jordan 2020-03-31 23:43:43 31.24 36.51 274 5 30 239 Jordan
2217 2217     Martinique France 2020-03-31 23:43:43 14.6415 -61.0242 128 3 27 98 Martinique, France
2270 2270       Azerbaijan 2020-03-31 23:43:43 40.1431 47.5769 298 5 26 267 Azerbaijan

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

CREATE TABLE [03-31-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
);