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 Admin2

✎ 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
2173 2173     Alberta Canada 2020-03-31 23:49:13 53.9333 -116.5765 690 8 0 0 Alberta, Canada
2174 2174     Anguilla United Kingdom 2020-03-31 23:43:43 18.2206 -63.0686 2 0 0 2 Anguilla, United Kingdom
2175 2175     Anhui China 2020-03-08 05:19:01 31.8257 117.2264 990 6 984 0 Anhui, China
2176 2176     Aruba Netherlands 2020-03-31 23:43:43 12.5211 -69.9683 55 0 1 54 Aruba, Netherlands
2177 2177     Australian Capital Territory Australia 2020-03-31 23:49:27 -35.4735 149.0124 80 1 3 76 Australian Capital Territory, Australia
2178 2178     Beijing China 2020-03-31 05:46:54 40.1824 116.4142 580 8 418 154 Beijing, China
2179 2179     Bermuda United Kingdom 2020-03-31 23:43:43 32.3078 -64.7505 32 0 10 22 Bermuda, United Kingdom
2180 2180     British Columbia Canada 2020-03-31 23:49:13 53.7267 -127.6476 1013 24 0 0 British Columbia, Canada
2181 2181     British Virgin Islands United Kingdom 2020-03-31 23:43:43 18.4207 -64.64 3 0 0 3 British Virgin Islands, United Kingdom
2182 2182     Cayman Islands United Kingdom 2020-03-31 23:43:43 19.3133 -81.2546 14 1 0 13 Cayman Islands, United Kingdom
2183 2183     Channel Islands United Kingdom 2020-03-31 23:43:43 49.3723 -2.3644 141 3 0 138 Channel Islands, United Kingdom
2184 2184     Chongqing China 2020-03-29 00:14:12 30.0572 107.874 579 6 570 3 Chongqing, China
2185 2185     Curacao Netherlands 2020-03-31 23:43:43 12.1696 -68.99 11 1 2 8 Curacao, Netherlands
2186 2186     Diamond Princess Canada 2020-03-31 23:49:13 0.0 0.0 0 1 0 0 Diamond Princess, Canada
2187 2187 88888   Diamond Princess US 2020-03-31 23:43:56 0.0 0.0 49 0 0 0 Diamond Princess, US
2188 2188     Faroe Islands Denmark 2020-03-31 23:43:43 61.8926 -6.9118 169 0 74 95 Faroe Islands, Denmark
2189 2189     French Guiana France 2020-03-31 23:43:43 4.0 -53.0 43 0 6 37 French Guiana, France
2190 2190     French Polynesia France 2020-03-31 23:43:43 -17.6797 149.4068 36 0 0 36 French Polynesia, France
2191 2191     Fujian China 2020-03-31 02:10:31 26.0789 117.9874 343 1 295 47 Fujian, China
2192 2192     Gansu China 2020-03-29 14:25:46 37.8099 101.0583 138 2 125 11 Gansu, China
2193 2193     Gibraltar United Kingdom 2020-03-31 23:43:43 36.1408 -5.3536 69 0 34 35 Gibraltar, United Kingdom
2194 2194     Grand Princess Canada 2020-03-31 23:49:13 0.0 0.0 13 0 0 0 Grand Princess, Canada
2195 2195 99999   Grand Princess US 2020-03-31 23:43:56 0.0 0.0 103 3 0 0 Grand Princess, US
2196 2196     Greenland Denmark 2020-03-31 23:43:43 71.7069 -42.6043 10 0 2 8 Greenland, Denmark
2197 2197     Guadeloupe France 2020-03-31 23:43:43 16.265 -61.551 114 4 22 88 Guadeloupe, France
2198 2198 66000   Guam US 2020-03-31 23:43:56 13.4443 144.7937 69 2 0 0 Guam, US
2199 2199     Guangdong China 2020-03-31 09:56:36 23.3417 113.4244 1494 8 1356 130 Guangdong, China
2200 2200     Guangxi China 2020-03-20 04:33:45 23.8298 108.7881 254 2 250 2 Guangxi, China
2201 2201     Guizhou China 2020-03-18 01:37:43 26.8154 106.8748 146 2 144 0 Guizhou, China
2202 2202     Hainan China 2020-03-24 04:29:15 19.1959 109.7453 168 6 162 0 Hainan, China
2203 2203     Hebei China 2020-03-30 02:07:50 39.549 116.1306 321 6 310 5 Hebei, China
2204 2204     Heilongjiang China 2020-03-26 00:15:39 47.862 127.7615 484 13 469 2 Heilongjiang, China
2205 2205     Henan China 2020-03-29 01:44:01 33.882 113.614 1276 22 1251 3 Henan, China
2206 2206     Hong Kong China 2020-03-31 09:10:05 22.3 114.2 714 4 128 582 Hong Kong, China
2207 2207     Hubei China 2020-03-31 01:06:37 30.9756 112.2707 67801 3187 63153 1461 Hubei, China
2208 2208     Hunan China 2020-03-14 08:25:05 27.6104 111.7088 1018 4 1014 0 Hunan, China
2209 2209     Inner Mongolia China 2020-03-30 23:54:43 44.0935 113.9448 107 1 74 32 Inner Mongolia, China
2210 2210     Isle of Man United Kingdom 2020-03-31 23:43:43 54.2361 -4.5481 60 0 0 60 Isle of Man, United Kingdom
2211 2211     Jiangsu China 2020-03-31 01:10:41 32.9711 119.455 646 0 631 15 Jiangsu, China
2212 2212     Jiangxi China 2020-03-30 03:15:15 27.614 115.7221 937 1 935 1 Jiangxi, China
2213 2213     Jilin China 2020-03-29 00:28:20 43.6661 126.1923 98 1 92 5 Jilin, China
2214 2214     Liaoning China 2020-03-31 00:23:00 41.2956 122.6085 139 2 124 13 Liaoning, China
2215 2215     Macau China 2020-03-31 13:54:04 22.1667 113.55 41 0 10 31 Macau, China
2216 2216     Manitoba Canada 2020-03-31 23:49:13 53.7609 -98.8139 103 1 0 0 Manitoba, Canada
2217 2217     Martinique France 2020-03-31 23:43:43 14.6415 -61.0242 128 3 27 98 Martinique, France
2218 2218     Mayotte France 2020-03-31 23:43:43 -12.8275 45.166244 94 1 10 83 Mayotte, France
2219 2219     Montserrat United Kingdom 2020-03-31 23:43:43 16.742498 -62.187366000000004 5 0 0 5 Montserrat, United Kingdom
2220 2220     New Brunswick Canada 2020-03-31 23:49:13 46.5653 -66.4619 70 0 0 0 New Brunswick, Canada
2221 2221     New Caledonia France 2020-03-31 23:43:43 -20.904304999999997 165.618042 16 0 0 16 New Caledonia, France
2222 2222     New South Wales Australia 2020-03-31 23:49:27 -33.8688 151.2093 2032 8 4 2020 New South Wales, Australia
2223 2223     Newfoundland and Labrador Canada 2020-03-31 23:49:13 53.1355 -57.6604 152 1 0 0 Newfoundland and Labrador, Canada
2224 2224     Ningxia China 2020-03-16 08:47:05 37.2692 106.1655 75 0 75 0 Ningxia, China
2225 2225     Northern Mariana Islands US 2020-03-31 23:43:56 15.0979 145.6739 2 0 0 0 ,Northern Mariana Islands,US
2226 2226     Northern Territory Australia 2020-03-31 23:49:27 -12.4634 130.8456 17 0 0 17 Northern Territory, Australia
2227 2227     Northwest Territories Canada 2020-03-31 23:49:13 64.8255 -124.8457 1 0 0 0 ,Northwest Territories,Canada
2228 2228     Nova Scotia Canada 2020-03-31 23:49:13 44.681999999999995 -63.7443 147 0 0 0 Nova Scotia, Canada
2229 2229     Nunavut Canada 2020-03-31 23:49:13 70.2998 -83.1076 0 0 0 0 Nunavut, Canada
2230 2230     Ontario Canada 2020-03-31 23:49:13 51.2538 -85.3232 1966 33 0 0 Ontario, Canada
2231 2231     Prince Edward Island Canada 2020-03-31 23:49:13 46.5107 -63.4168 21 0 0 0 Prince Edward Island, Canada
2232 2232     Puerto Rico US 2020-03-31 23:43:56 18.2208 -66.5901 239 8 0 0 Puerto Rico, US
2233 2233     Qinghai China 2020-02-23 11:19:02 35.7452 95.9956 18 0 18 0 Qinghai, China
2234 2234     Quebec Canada 2020-03-31 23:49:13 52.9399 -73.5491 4162 82 0 0 Quebec, Canada
2235 2235     Queensland Australia 2020-03-31 23:49:27 -27.4698 153.0251 743 2 8 733 Queensland, Australia
2236 2236     Recovered Canada 2020-03-31 23:49:13 0.0 0.0 0 0 1592 0 Recovered, Canada
2237 2237     Recovered US 2020-03-31 23:43:56 0.0 0.0 0 0 7024 0 Recovered, US
2238 2238     Reunion France 2020-03-31 23:43:43 -21.1151 55.5364 247 0 1 246 Reunion, France
2239 2239     Saint Barthelemy France 2020-03-31 23:43:43 17.9 -62.8333 6 0 1 5 Saint Barthelemy, France
2240 2240     Saint Helena, Ascension and Tristan da Cunha United Kingdom 2020-03-31 23:43:43 -7.9467 -14.3559 0 0 0 0 Saint Helena, Ascension and Tristan da Cunha, United Kingdom
2241 2241     Saskatchewan Canada 2020-03-31 23:49:13 52.9399 -106.4509 184 2 0 0 Saskatchewan, Canada
2242 2242     Shaanxi China 2020-03-26 02:14:25 35.1917 108.8701 253 3 242 8 Shaanxi, China
2243 2243     Shandong China 2020-03-31 00:44:17 36.3427 118.1498 774 7 753 14 Shandong, China
2244 2244     Shanghai China 2020-03-31 07:43:11 31.202 121.4491 509 5 341 163 Shanghai, China
2245 2245     Shanxi China 2020-03-29 00:20:15 37.5777 112.2922 136 0 133 3 Shanxi, China
2246 2246     Sichuan China 2020-03-30 01:09:15 30.6171 102.7103 550 3 536 11 Sichuan, China
2247 2247     Sint Maarten Netherlands 2020-03-31 23:43:43 18.0425 -63.0548 6 0 0 6 Sint Maarten, Netherlands
2248 2248     South Australia Australia 2020-03-31 23:49:27 -34.9285 138.6007 337 0 6 331 South Australia, Australia
2249 2249     St Martin France 2020-03-31 23:43:43 18.0708 -63.0501 15 1 2 12 St Martin, France
2250 2250     Tasmania Australia 2020-03-31 23:49:27 -42.8821 147.3272 69 1 5 63 Tasmania, Australia
2251 2251     Tianjin China 2020-03-31 13:54:04 39.3054 117.323 174 3 135 36 Tianjin, China
2252 2252     Tibet China 2020-02-23 11:19:02 31.6927 88.0924 1 0 1 0 Tibet, China
2253 2253     Turks and Caicos Islands United Kingdom 2020-03-31 23:43:43 21.69400000000001 -71.7979 5 0 0 5 Turks and Caicos Islands, United Kingdom
2254 2254     Victoria Australia 2020-03-31 23:49:27 -37.8136 144.9631 917 4 291 622 Victoria, Australia
2255 2255     Virgin Islands US 2020-03-31 23:43:56 18.3358 -64.8963 30 0 0 0 ,Virgin Islands,US
2256 2256     Western Australia Australia 2020-03-31 23:49:27 -31.9505 115.8605 364 2 41 321 Western Australia, Australia
2257 2257     Xinjiang China 2020-03-08 05:31:02 41.1129 85.2401 76 3 73 0 Xinjiang, China
2258 2258     Yukon Canada 2020-03-31 23:49:13 64.2823 -135.0 5 0 0 0 ,Yukon,Canada
2259 2259     Yunnan China 2020-03-31 23:31:54 24.974 101.487 182 2 172 8 Yunnan, China
2260 2260     Zhejiang China 2020-03-31 01:23:49 29.1832 120.0934 1257 1 1226 30 Zhejiang, China
2261 2261       Afghanistan 2020-03-31 23:43:43 33.93911 67.709953 175 4 5 165 Afghanistan
2262 2262       Albania 2020-03-31 23:43:43 41.1533 20.1683 243 15 52 176 Albania
2263 2263       Algeria 2020-03-31 23:43:43 28.0339 1.6596 716 44 46 626 Algeria
2264 2264       Andorra 2020-03-31 23:43:43 42.5063 1.5218 376 12 10 354 Andorra
2265 2265       Angola 2020-03-31 23:43:43 -11.2027 17.8739 7 2 1 4 Angola
2266 2266       Antigua and Barbuda 2020-03-31 23:43:43 17.0608 -61.7964 7 0 0 7 Antigua and Barbuda
2267 2267       Argentina 2020-03-31 23:43:43 -38.4161 -63.6167 1054 27 240 787 Argentina
2268 2268       Armenia 2020-03-31 23:43:43 40.0691 45.0382 532 3 30 499 Armenia
2269 2269       Austria 2020-03-31 23:43:43 47.5162 14.5501 10180 128 1095 8957 Austria
2270 2270       Azerbaijan 2020-03-31 23:43:43 40.1431 47.5769 298 5 26 267 Azerbaijan
2271 2271       Bahamas 2020-03-31 23:43:43 25.025885 -78.035889 14 0 1 13 Bahamas
2272 2272       Bahrain 2020-03-31 23:43:43 26.0275 50.55 567 4 295 268 Bahrain

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