04-05-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,765 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
1450 1450   McIntosh Georgia US 2020-04-05 23:06:45     2 0 0 0 McIntosh,Georgia,US
1705 1705 80008 Out of CO Colorado US 2020-04-05 23:06:45     0 1 0 0 Out of CO,Colorado,US
1706 1706 80015 Out of HI Hawaii US 2020-04-05 23:06:45     2 0 0 0 Out of HI,Hawaii,US
1707 1707   Out of MI Michigan US 2020-04-05 23:06:45     83 1 0 0 Out of MI,Michigan,US
1708 1708 80040 Out of OK Oklahoma US 2020-04-05 23:06:45     2 0 0 0 Out of OK,Oklahoma,US
1709 1709   Out of TN Tennessee US 2020-04-05 23:06:45     265 1 0 0 Out of TN,Tennessee,US
2216 2216 90002 Unassigned Alaska US 2020-04-05 23:06:45     0 5 0 0 Unassigned, Alaska, US
2217 2217 90004 Unassigned Arizona US 2020-04-05 23:06:45     0 10 0 0 Unassigned, Arizona, US
2218 2218 90005 Unassigned Arkansas US 2020-04-05 23:06:45     57 10 0 0 Unassigned, Arkansas, US
2219 2219 90006 Unassigned California US 2020-04-05 23:06:45     0 0 0 0 Unassigned, California, US
2220 2220 90008 Unassigned Colorado US 2020-04-05 23:06:45     251 0 0 0 Unassigned, Colorado, US
2221 2221 90009 Unassigned Connecticut US 2020-04-05 23:06:45     222 1 0 0 Unassigned, Connecticut, US
2222 2222 90010 Unassigned Delaware US 2020-04-05 23:06:45     0 7 0 0 Unassigned, Delaware, US
2223 2223 90012 Unassigned Florida US 2020-04-05 23:06:45     4 0 0 0 Unassigned, Florida, US
2224 2224 90013 Unassigned Georgia US 2020-04-05 23:06:45     278 5 0 0 Unassigned, Georgia, US
2225 2225 90015 Unassigned Hawaii US 2020-04-05 23:06:45     7 0 0 0 Unassigned, Hawaii, US
2226 2226 90016 Unassigned Idaho US 2020-04-05 23:06:45     0 0 0 0 Unassigned, Idaho, US
2227 2227 90017 Unassigned Illinois US 2020-04-05 23:06:45     62 0 0 0 Unassigned, Illinois, US
2228 2228 90019 Unassigned Iowa US 2020-04-05 23:06:45     0 0 0 0 Unassigned, Iowa, US
2229 2229 90020 Unassigned Kansas US 2020-04-05 23:06:45     0 3 0 0 Unassigned,Kansas,US
2230 2230 90021 Unassigned Kentucky US 2020-04-05 23:06:45     34 0 0 0 Unassigned, Kentucky, US
2231 2231   Unassigned Louisiana US 2020-04-05 23:06:45     31 4 0 0 Unassigned,Louisiana,US
2232 2232 90023 Unassigned Maine US 2020-04-05 23:06:45     11 3 0 0 Unassigned, Maine, US
2233 2233 90024 Unassigned Maryland US 2020-04-05 23:06:45     0 0 0 0 Unassigned, Maryland, US
2234 2234 90025 Unassigned Massachusetts US 2020-04-05 23:06:45     215 9 0 0 Unassigned, Massachusetts, US
2235 2235   Unassigned Michigan US 2020-04-05 23:06:45     349 1 0 0 Unassigned,Michigan,US
2236 2236 90027 Unassigned Minnesota US 2020-04-05 23:06:45     7 3 0 0 Unassigned, Minnesota, US
2237 2237 90029 Unassigned Missouri US 2020-04-05 23:06:45     3 0 0 0 Unassigned,Missouri,US
2238 2238 90030 Unassigned Montana US 2020-04-05 23:06:45     0 0 0 0 Unassigned, Montana, US
2239 2239 90031 Unassigned Nebraska US 2020-04-05 23:06:45     1 1 0 0 Unassigned, Nebraska, US
2240 2240 90032 Unassigned Nevada US 2020-04-05 23:06:45     25 0 0 0 Unassigned, Nevada, US
2241 2241 90033 Unassigned New Hampshire US 2020-04-05 23:06:45     4 6 0 0 Unassigned, New Hampshire, US
2242 2242 90034 Unassigned New Jersey US 2020-04-05 23:06:45     3821 13 0 0 Unassigned, New Jersey, US
2243 2243 90035 Unassigned New Mexico US 2020-04-05 23:06:45     0 0 0 0 Unassigned, New Mexico, US
2244 2244 90036 Unassigned New York US 2020-04-05 23:06:45     0 1260 0 0 Unassigned, New York, US
2245 2245 90038 Unassigned North Dakota US 2020-04-05 23:06:45     0 0 0 0 Unassigned, North Dakota, US
2246 2246 90039 Unassigned Ohio US 2020-04-05 23:06:45     0 0 0 0 Unassigned, Ohio, US
2247 2247 90040 Unassigned Oklahoma US 2020-04-05 23:06:45     0 0 0 0 Unassigned, Oklahoma, US
2248 2248 90044 Unassigned Rhode Island US 2020-04-05 23:06:45     238 9 0 0 Unassigned, Rhode Island, US
2249 2249 90046 Unassigned South Dakota US 2020-04-05 23:06:45     0 0 0 0 Unassigned, South Dakota, US
2250 2250 90047 Unassigned Tennessee US 2020-04-05 23:06:45     86 0 0 0 Unassigned, Tennessee, US
2251 2251 90049 Unassigned Utah US 2020-04-05 23:06:45     2 0 0 0 Unassigned,Utah,US
2252 2252 90050 Unassigned Vermont US 2020-04-05 23:06:45     13 17 0 0 Unassigned, Vermont, US
2253 2253 90051 Unassigned Virginia US 2020-04-05 23:06:45     3 36 0 0 Unassigned, Virginia, US
2254 2254 90053 Unassigned Washington US 2020-04-05 23:06:45     533 0 0 0 Unassigned, Washington, US
2255 2255 90055 Unassigned Wisconsin US 2020-04-05 23:06:45     0 0 0 0 Unassigned, Wisconsin, US
2509 2509     Diamond Princess Canada 2020-04-05 23:13:28     0 1 0 0 Diamond Princess, Canada
2510 2510 88888   Diamond Princess US 2020-04-05 23:06:45     49 0 0 0 Diamond Princess, US
2518 2518     Grand Princess Canada 2020-04-05 23:13:28     13 0 0 0 Grand Princess, Canada
2519 2519 99999   Grand Princess US 2020-04-05 23:06:45     103 3 0 0 Grand Princess, US
2560 2560     Recovered Canada 2020-04-05 23:13:28     0 0 3012 0 Recovered, Canada
2561 2561     Recovered US 2020-04-05 23:06:45     0 0 17448 0 Recovered, US
2630 2630       Diamond Princess 2020-04-05 23:06:26     712 11 619 82 Diamond Princess
2685 2685       MS Zaandam 2020-04-05 23:06:26     9 2 0 7 ,,MS Zaandam
2765 2765   unassigned Wyoming US 2020-04-05 23:06:45     0 0 0 0 unassigned, Wyoming, US
2511 2511     Falkland Islands (Islas Malvinas) United Kingdom 2020-04-05 23:06:26 -51.7963 -59.5236 2 0 0 2 Falkland Islands (Islas Malvinas), United Kingdom
2575 2575     Tasmania Australia 2020-04-05 23:13:44 -42.8821 147.3272 82 2 5 75 Tasmania, Australia
2704 2704       New Zealand 2020-04-05 23:06:26 -40.9006 174.886 1039 1 156 882 New Zealand
2592 2592       Argentina 2020-04-05 23:06:26 -38.4161 -63.6167 1451 44 280 1127 Argentina
2579 2579     Victoria Australia 2020-04-05 23:13:44 -37.8136 144.9631 1135 8 573 554 Victoria, Australia
2619 2619       Chile 2020-04-05 23:06:26 -35.6751 -71.543 4471 34 618 3819 Chile
2499 2499     Australian Capital Territory Australia 2020-04-05 23:13:44 -35.4735 149.0124 96 2 28 66 Australian Capital Territory, Australia
2573 2573     South Australia Australia 2020-04-05 23:13:44 -34.9285 138.6007 407 0 46 361 South Australia, Australia
2546 2546     New South Wales Australia 2020-04-05 23:13:44 -33.8688 151.2093 2580 16 4 2560 New South Wales, Australia
2758 2758       Uruguay 2020-04-05 23:06:26 -32.5228 -55.7658 400 5 93 302 Uruguay
2581 2581     Western Australia Australia 2020-04-05 23:13:44 -31.9505 115.8605 453 3 92 358 Western Australia, Australia
2737 2737       South Africa 2020-04-05 23:06:26 -30.5595 22.9375 1655 11 95 1549 South Africa
2559 2559     Queensland Australia 2020-04-05 23:13:44 -27.4698 153.0251 907 4 8 895 Queensland, Australia
2640 2640       Eswatini 2020-04-05 23:06:26 -26.5225 31.4659 9 0 0 9 Eswatini
2714 2714       Paraguay 2020-04-05 23:06:26 -23.4425 -58.4438 104 3 12 89 Paraguay
2701 2701       Namibia 2020-04-05 23:06:26 -22.9576 18.4904 16 0 3 13 Namibia
2607 2607       Botswana 2020-04-05 23:06:26 -22.3285 24.6849 6 1 0 5 Botswana
2562 2562     Reunion France 2020-04-05 23:06:26 -21.1151 55.5364 344 0 40 304 Reunion, France
2545 2545     New Caledonia France 2020-04-05 23:06:26 -20.904304999999997 165.618042 18 0 1 17 New Caledonia, France
2693 2693       Mauritius 2020-04-05 23:06:26 -20.348404000000002 57.552152 227 7 7 213 Mauritius
2764 2764       Zimbabwe 2020-04-05 23:06:26 -19.015438 29.154857 9 1 0 8 Zimbabwe
2686 2686       Madagascar 2020-04-05 23:06:26 -18.766947000000002 46.869107 72 0 2 70 Madagascar
2700 2700       Mozambique 2020-04-05 23:06:26 -18.665695 35.529562 10 0 1 9 Mozambique
2642 2642       Fiji 2020-04-05 23:06:26 -17.7134 178.065 12 0 0 12 Fiji
2514 2514     French Polynesia France 2020-04-05 23:06:26 -17.6797 -149.4068 41 0 0 41 French Polynesia, France
2605 2605       Bolivia 2020-04-05 23:06:26 -16.2902 -63.5887 157 10 2 145 Bolivia
2608 2608       Brazil 2020-04-05 23:06:26 -14.235 -51.9253 11130 486 127 10517 Brazil
2726 2726       Samoa 2020-04-05 23:13:28 -13.759 -172.1046 0 0 0 0 Samoa
2687 2687       Malawi 2020-04-05 23:06:26 -13.254307999999998 34.301525 4 0 0 4 Malawi
2763 2763       Zambia 2020-04-05 23:06:26 -13.133897 27.849332 39 1 3 35 Zambia
2542 2542     Mayotte France 2020-04-05 23:06:26 -12.8275 45.166244 147 2 14 131 Mayotte, France
2550 2550     Northern Territory Australia 2020-04-05 23:13:44 -12.4634 130.8456 27 0 1 26 Northern Territory, Australia
2590 2590       Angola 2020-04-05 23:06:26 -11.2027 17.8739 14 2 2 10 Angola
2715 2715       Peru 2020-04-05 23:06:26 -9.19 -75.0152 2281 83 989 1209 Peru
2749 2749       Timor-Leste 2020-04-05 23:06:26 -8.874217 125.727539 1 0 0 1 Timor-Leste
2564 2564     Saint Helena, Ascension and Tristan da Cunha United Kingdom 2020-04-05 23:06:26 -7.9467 -14.3559 0 0 0 0 Saint Helena, Ascension and Tristan da Cunha, United Kingdom
2747 2747       Tanzania 2020-04-05 23:06:26 -6.369028 34.888822 22 1 3 18 Tanzania
2713 2713       Papua New Guinea 2020-04-05 23:06:26 -6.314993 143.95555 1 0 0 1 Papua New Guinea
2731 2731       Seychelles 2020-04-05 23:06:26 -4.6796 55.492 10 0 0 10 Seychelles
2622 2622       Congo (Kinshasa) 2020-04-05 23:06:26 -4.322447 15.307045 154 18 3 133 Congo (Kinshasa)
2621 2621       Congo (Brazzaville) 2020-04-05 23:06:26 -4.2634 15.2832 45 5 2 38 Congo (Brazzaville)
2613 2613       Burundi 2020-04-05 23:06:26 -3.3731 29.9189 3 0 0 3 Burundi
2722 2722       Rwanda 2020-04-05 23:06:26 -1.9403 29.8739 104 0 4 100 Rwanda
2634 2634       Ecuador 2020-04-05 23:06:26 -1.8312 -78.1834 3646 180 100 3366 Ecuador
2645 2645       Gabon 2020-04-05 23:06:26 -0.8037 11.6094 21 1 1 19 Gabon

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

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