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 Lat

✎ 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
1289 1289   McIntosh Georgia US 2020-04-01 21:58:49     1 0 0 0 McIntosh,Georgia,US
2299 2299     Tasmania Australia 2020-04-01 22:04:58 -42.8821 147.3272 69 2 5 62 Tasmania, Australia
2427 2427       New Zealand 2020-04-01 21:58:34 -40.9006 174.886 708 1 83 624 New Zealand
2316 2316       Argentina 2020-04-01 21:58:34 -38.4161 -63.6167 1054 28 248 778 Argentina
2303 2303     Victoria Australia 2020-04-01 22:04:58 -37.8136 144.9631 968 4 343 621 Victoria, Australia
2343 2343       Chile 2020-04-01 21:58:34 -35.6751 -71.543 3031 16 234 2781 Chile
2226 2226     Australian Capital Territory Australia 2020-04-01 22:04:58 -35.4735 149.0124 84 1 8 75 Australian Capital Territory, Australia
2297 2297     South Australia Australia 2020-04-01 22:04:58 -34.9285 138.6007 367 0 6 361 South Australia, 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
2480 2480       Uruguay 2020-04-01 21:58:34 -32.5228 -55.7658 338 2 41 295 Uruguay
2305 2305     Western Australia Australia 2020-04-01 22:04:58 -31.9505 115.8605 392 2 48 342 Western Australia, Australia
2460 2460       South Africa 2020-04-01 21:58:34 -30.5595 22.9375 1380 5 50 1325 South Africa
2284 2284     Queensland Australia 2020-04-01 22:04:58 -27.4698 153.0251 781 2 8 771 Queensland, Australia
2364 2364       Eswatini 2020-04-01 21:58:34 -26.5225 31.4659 9 0 0 9 Eswatini
2437 2437       Paraguay 2020-04-01 21:58:34 -23.4425 -58.4438 69 3 1 65 Paraguay
2424 2424       Namibia 2020-04-01 21:58:34 -22.9576 18.4904 14 0 2 12 Namibia
2331 2331       Botswana 2020-04-01 21:58:34 -22.3285 24.6849 4 1 0 3 Botswana
2287 2287     Reunion France 2020-04-01 21:58:34 -21.1151 55.5364 281 0 40 241 Reunion, France
2270 2270     New Caledonia France 2020-04-01 21:58:34 -20.904304999999997 165.618042 16 0 0 16 New Caledonia, France
2416 2416       Mauritius 2020-04-01 21:58:34 -20.348404000000002 57.552152 161 6 0 155 Mauritius
2486 2486       Zimbabwe 2020-04-01 21:58:34 -19.015438 29.154857 8 1 0 7 Zimbabwe
2410 2410       Madagascar 2020-04-01 21:58:34 -18.766947000000002 46.869107 57 0 0 57 Madagascar
2423 2423       Mozambique 2020-04-01 21:58:34 -18.665695 35.529562 10 0 0 10 Mozambique
2366 2366       Fiji 2020-04-01 21:58:34 -17.7134 178.065 5 0 0 5 Fiji
2239 2239     French Polynesia France 2020-04-01 21:58:34 -17.6797 -149.4068 37 0 0 37 French Polynesia, France
2329 2329       Bolivia 2020-04-01 21:58:34 -16.2902 -63.5887 115 7 1 107 Bolivia
2332 2332       Brazil 2020-04-01 21:58:34 -14.235 -51.9253 6836 240 127 6469 Brazil
2449 2449       Samoa 2020-04-01 22:04:44 -13.759 -172.1046 0 0 0 0 Samoa
2485 2485       Zambia 2020-04-01 21:58:34 -13.133897 27.849332 36 0 0 36 Zambia
2267 2267     Mayotte France 2020-04-01 21:58:34 -12.8275 45.166244 94 1 10 83 Mayotte, France
2275 2275     Northern Territory Australia 2020-04-01 22:04:58 -12.4634 130.8456 19 0 0 19 Northern Territory, Australia
2314 2314       Angola 2020-04-01 21:58:34 -11.2027 17.8739 8 2 1 5 Angola
2438 2438       Peru 2020-04-01 21:58:34 -9.19 -75.0152 1323 38 394 891 Peru
2471 2471       Timor-Leste 2020-04-01 21:58:34 -8.874217 125.727539 1 0 0 1 Timor-Leste
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
2469 2469       Tanzania 2020-04-01 21:58:34 -6.369028 34.888822 20 1 1 18 Tanzania
2436 2436       Papua New Guinea 2020-04-01 21:58:34 -6.314993 143.95555 1 0 0 1 Papua New Guinea
2454 2454       Seychelles 2020-04-01 21:58:34 -4.6796 55.492 10 0 0 10 Seychelles
2346 2346       Congo (Kinshasa) 2020-04-01 21:58:34 -4.322447 15.307045 109 9 3 97 Congo (Kinshasa)
2345 2345       Congo (Brazzaville) 2020-04-01 21:58:34 -4.2634 15.2832 19 0 0 19 Congo (Brazzaville)
2337 2337       Burundi 2020-04-01 21:58:34 -3.3731 29.9189 2 0 0 2 Burundi
2445 2445       Rwanda 2020-04-01 21:58:34 -1.9403 29.8739 82 0 0 82 Rwanda
2358 2358       Ecuador 2020-04-01 21:58:34 -1.8312 -78.1834 2748 93 58 2597 Ecuador
2369 2369       Gabon 2020-04-01 21:58:34 -0.8037 11.6094 18 1 0 17 Gabon
2386 2386       Indonesia 2020-04-01 21:58:34 -0.7893 113.9213 1677 157 103 1417 Indonesia
2396 2396       Kenya 2020-04-01 21:58:34 -0.0236 37.9062 81 1 3 77 Kenya
1519 1519   Out of MI Michigan US 2020-04-01 21:58:49 0.0 0.0 42 1 0 0 Out of MI,Michigan,US
1520 1520   Out of OK Oklahoma US 2020-04-01 21:58:49 0.0 0.0 2 0 0 0 Out of OK,Oklahoma,US
1521 1521   Out of TN Tennessee US 2020-04-01 21:58:49 0.0 0.0 243 0 0 0 Out of TN,Tennessee,US
1522 1522   Out of UT Utah US 2020-04-01 21:58:49 0.0 0.0 22 0 0 0 Out of UT,Utah,US
1973 1973   Unassigned Alabama US 2020-04-01 21:58:49 0.0 0.0 0 0 0 0 Unassigned, Alabama, US
1974 1974   Unassigned Alaska US 2020-04-01 21:58:49 0.0 0.0 0 2 0 0 Unassigned, Alaska, US
1975 1975   Unassigned Arizona US 2020-04-01 21:58:49 0.0 0.0 0 18 0 0 Unassigned, Arizona, US
1976 1976   Unassigned Arkansas US 2020-04-01 21:58:49 0.0 0.0 44 4 0 0 Unassigned, Arkansas, US
1977 1977   Unassigned California US 2020-04-01 21:58:49 0.0 0.0 0 1 0 0 Unassigned, California, US
1978 1978   Unassigned Colorado US 2020-04-01 21:58:49 0.0 0.0 129 1 0 0 Unassigned, Colorado, US
1979 1979   Unassigned Connecticut US 2020-04-01 21:58:49 0.0 0.0 185 2 0 0 Unassigned, Connecticut, US
1980 1980   Unassigned Florida US 2020-04-01 21:58:49 0.0 0.0 3 2 0 0 Unassigned, Florida, US
1981 1981   Unassigned Georgia US 2020-04-01 21:58:49 0.0 0.0 516 2 0 0 Unassigned, Georgia, US
1982 1982   Unassigned Hawaii US 2020-04-01 21:58:49 0.0 0.0 15 1 0 0 Unassigned, Hawaii, US
1983 1983   Unassigned Illinois US 2020-04-01 21:58:49 0.0 0.0 28 0 0 0 Unassigned, Illinois, US
1984 1984   Unassigned Iowa US 2020-04-01 21:58:49 0.0 0.0 0 1 0 0 Unassigned, Iowa, US
1985 1985   Unassigned Kentucky US 2020-04-01 21:58:49 0.0 0.0 18 3 0 0 Unassigned, Kentucky, US
1986 1986   Unassigned Louisiana US 2020-04-01 21:58:49 0.0 0.0 28 0 0 0 Unassigned, Louisiana, US
1987 1987   Unassigned Maine US 2020-04-01 21:58:49 0.0 0.0 6 0 0 0 Unassigned, Maine, US
1988 1988   Unassigned Maryland US 2020-04-01 21:58:49 0.0 0.0 0 12 0 0 Unassigned, Maryland, US
1989 1989   Unassigned Massachusetts US 2020-04-01 21:58:49 0.0 0.0 251 9 0 0 Unassigned, Massachusetts, US
1990 1990   Unassigned Michigan US 2020-04-01 21:58:49 0.0 0.0 142 0 0 0 Unassigned,Michigan,US
1991 1991   Unassigned Minnesota US 2020-04-01 21:58:49 0.0 0.0 0 8 0 0 Unassigned, Minnesota, US
1992 1992   Unassigned Missouri US 2020-04-01 21:58:49 0.0 0.0 0 0 0 0 Unassigned, Missouri, US
1993 1993   Unassigned Nebraska US 2020-04-01 21:58:49 0.0 0.0 3 0 0 0 Unassigned, Nebraska, US
1994 1994   Unassigned Nevada US 2020-04-01 21:58:49 0.0 0.0 148 0 0 0 Unassigned, Nevada, US
1995 1995   Unassigned New Hampshire US 2020-04-01 21:58:49 0.0 0.0 0 0 0 0 Unassigned, New Hampshire, US
1996 1996   Unassigned New Jersey US 2020-04-01 21:58:49 0.0 0.0 4512 0 0 0 Unassigned, New Jersey, US
1997 1997   Unassigned New York US 2020-04-01 21:58:49 0.0 0.0 0 565 0 0 Unassigned, New York, US
1998 1998   Unassigned Oklahoma US 2020-04-01 21:58:49 0.0 0.0 0 1 0 0 Unassigned, Oklahoma, US
1999 1999   Unassigned Rhode Island US 2020-04-01 21:58:49 0.0 0.0 160 1 0 0 Unassigned, Rhode Island, US
2000 2000   Unassigned Tennessee US 2020-04-01 21:58:49 0.0 0.0 442 11 0 0 Unassigned, Tennessee, US
2001 2001   Unassigned Vermont US 2020-04-01 21:58:49 0.0 0.0 14 11 0 0 Unassigned, Vermont, US
2002 2002   Unassigned Virginia US 2020-04-01 21:58:49 0.0 0.0 0 19 0 0 Unassigned,Virginia,US
2003 2003   Unassigned Washington US 2020-04-01 21:58:49 0.0 0.0 303 0 0 0 Unassigned, Washington, US
2004 2004   Unassigned Wisconsin US 2020-04-01 21:58:49 0.0 0.0 0 0 0 0 Unassigned, Wisconsin, US
2235 2235     Diamond Princess Canada 2020-04-01 22:04:44 0.0 0.0 0 1 0 0 Diamond Princess, Canada
2236 2236 88888   Diamond Princess US 2020-04-01 21:58:49 0.0 0.0 49 0 0 0 Diamond Princess, US
2243 2243     Grand Princess Canada 2020-04-01 22:04:44 0.0 0.0 13 0 0 0 Grand Princess, Canada
2244 2244 99999   Grand Princess US 2020-04-01 21:58:49 0.0 0.0 103 3 0 0 Grand Princess, US
2285 2285     Recovered Canada 2020-04-01 22:04:44 0.0 0.0 0 0 1324 0 Recovered, Canada
2286 2286     Recovered US 2020-04-01 21:58:49 0.0 0.0 0 0 8474 0 Recovered, US
2354 2354       Diamond Princess 2020-04-01 21:58:34 0.0 0.0 712 11 603 98 Diamond Princess
2409 2409       MS Zaandam 2020-04-01 21:58:34 0.0 0.0 9 2 0 7 ,,MS Zaandam
2456 2456       Singapore 2020-04-01 21:58:34 1.2833 103.8333 1000 3 245 752 Singapore
2476 2476       Uganda 2020-04-01 21:58:34 1.373333 32.290275 44 0 0 44 Uganda
2361 2361       Equatorial Guinea 2020-04-01 21:58:34 1.6508 10.2679 15 0 1 14 Equatorial Guinea
2412 2412       Maldives 2020-04-01 21:58:34 3.2028 73.2207 19 0 13 6 Maldives
2340 2340       Cameroon 2020-04-01 21:58:34 3.8480000000000003 11.5021 233 6 10 217 Cameroon
2464 2464       Suriname 2020-04-01 21:58:34 3.9193 -56.0278 10 0 0 10 Suriname
2238 2238     French Guiana France 2020-04-01 21:58:34 4.0 -53.0 51 0 15 36 French Guiana, France
2411 2411       Malaysia 2020-04-01 21:58:34 4.210483999999999 101.97576600000001 2908 45 645 2218 Malaysia
2333 2333       Brunei 2020-04-01 21:58:34 4.5353 114.7277 131 1 52 78 Brunei
2344 2344       Colombia 2020-04-01 21:58:34 4.5709 -74.2973 1065 17 39 1009 Colombia

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