04-06-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,810 rows sorted by Lat

✎ View and edit SQL

This data as json, copyable, CSV (advanced)

Suggested facets: Last_Update

Link rowid FIPS Admin2 Province_State Country_Region Last_Update Lat ▼ Long_ Confirmed Deaths Recovered Active Combined_Key
1472 1472   McIntosh Georgia US 4/6/20 23:22     2 0 0 0 McIntosh,Georgia,US
1731 1731 80008 Out of CO Colorado US 4/6/20 23:22     0 1 0 0 Out of CO,Colorado,US
1732 1732 80015 Out of HI Hawaii US 4/6/20 23:22     2 0 0 0 Out of HI,Hawaii,US
1733 1733   Out of MI Michigan US 4/6/20 23:22     91 1 0 0 Out of MI,Michigan,US
1734 1734 80040 Out of OK Oklahoma US 4/6/20 23:22     2 0 0 0 Out of OK,Oklahoma,US
1735 1735   Out of TN Tennessee US 4/6/20 23:22     290 1 0 0 Out of TN,Tennessee,US
2253 2253 90002 Unassigned Alaska US 4/6/20 23:22     0 5 0 0 Unassigned, Alaska, US
2254 2254 90004 Unassigned Arizona US 4/6/20 23:22     0 10 0 0 Unassigned, Arizona, US
2255 2255 90005 Unassigned Arkansas US 4/6/20 23:22     67 10 0 0 Unassigned, Arkansas, US
2256 2256 90006 Unassigned California US 4/6/20 23:22     43 0 0 0 Unassigned, California, US
2257 2257 90008 Unassigned Colorado US 4/6/20 23:22     276 0 0 0 Unassigned, Colorado, US
2258 2258 90009 Unassigned Connecticut US 4/6/20 23:22     264 0 0 0 Unassigned, Connecticut, US
2259 2259 90010 Unassigned Delaware US 4/6/20 23:22     0 9 0 0 Unassigned, Delaware, US
2260 2260 90012 Unassigned Florida US 4/6/20 23:22     7 1 0 0 Unassigned,Florida,US
2261 2261 90013 Unassigned Georgia US 4/6/20 23:22     320 5 0 0 Unassigned,Georgia,US
2262 2262 90015 Unassigned Hawaii US 4/6/20 23:22     9 0 0 0 Unassigned, Hawaii, US
2263 2263 90016 Unassigned Idaho US 4/6/20 23:22     0 0 0 0 Unassigned, Idaho, US
2264 2264 90017 Unassigned Illinois US 4/6/20 23:22     72 1 0 0 Unassigned, Illinois, US
2265 2265 90018 Unassigned Indiana US 4/6/20 23:22     20 141 0 0 Unassigned, Indiana, US
2266 2266 90019 Unassigned Iowa US 4/6/20 23:22     0 0 0 0 Unassigned, Iowa, US
2267 2267 90020 Unassigned Kansas US 4/6/20 23:22     0 4 0 0 Unassigned,Kansas,US
2268 2268 90021 Unassigned Kentucky US 4/6/20 23:22     34 0 0 0 Unassigned, Kentucky, US
2269 2269   Unassigned Louisiana US 4/6/20 23:22     48 3 0 0 Unassigned,Louisiana,US
2270 2270 90023 Unassigned Maine US 4/6/20 23:22     11 3 0 0 Unassigned, Maine, US
2271 2271 90024 Unassigned Maryland US 4/6/20 23:22     0 0 0 0 Unassigned, Maryland, US
2272 2272 90025 Unassigned Massachusetts US 4/6/20 23:22     246 10 0 0 Unassigned, Massachusetts, US
2273 2273   Unassigned Michigan US 4/6/20 23:22     371 1 0 0 Unassigned,Michigan,US
2274 2274 90027 Unassigned Minnesota US 4/6/20 23:22     6 0 0 0 Unassigned, Minnesota, US
2275 2275 90029 Unassigned Missouri US 4/6/20 23:22     1 1 0 0 Unassigned, Missouri, US
2276 2276 90030 Unassigned Montana US 4/6/20 23:22     0 0 0 0 Unassigned, Montana, US
2277 2277 90031 Unassigned Nebraska US 4/6/20 23:22     1 0 0 0 Unassigned, Nebraska, US
2278 2278 90032 Unassigned Nevada US 4/6/20 23:22     33 0 0 0 Unassigned, Nevada, US
2279 2279 90033 Unassigned New Hampshire US 4/6/20 23:22     1 6 0 0 Unassigned, New Hampshire, US
2280 2280 90034 Unassigned New Jersey US 4/6/20 23:22     3521 14 0 0 Unassigned, New Jersey, US
2281 2281 90035 Unassigned New Mexico US 4/6/20 23:22     0 0 0 0 Unassigned, New Mexico, US
2282 2282 90036 Unassigned New York US 4/6/20 23:22     0 309 0 0 Unassigned, New York, US
2283 2283 90038 Unassigned North Dakota US 4/6/20 23:22     0 0 0 0 Unassigned, North Dakota, US
2284 2284 90039 Unassigned Ohio US 4/6/20 23:22     0 0 0 0 Unassigned, Ohio, US
2285 2285 90040 Unassigned Oklahoma US 4/6/20 23:22     0 0 0 0 Unassigned, Oklahoma, US
2286 2286 90044 Unassigned Rhode Island US 4/6/20 23:22     332 16 0 0 Unassigned, Rhode Island, US
2287 2287 90046 Unassigned South Dakota US 4/6/20 23:22     0 0 0 0 Unassigned, South Dakota, US
2288 2288 90047 Unassigned Tennessee US 4/6/20 23:22     69 0 0 0 Unassigned, Tennessee, US
2289 2289 90049 Unassigned Utah US 4/6/20 23:22     0 0 0 0 Unassigned,Utah,US
2290 2290 90050 Unassigned Vermont US 4/6/20 23:22     21 18 0 0 Unassigned, Vermont, US
2291 2291 90051 Unassigned Virginia US 4/6/20 23:22     0 50 0 0 Unassigned, Virginia, US
2292 2292 90053 Unassigned Washington US 4/6/20 23:22     648 0 0 0 Unassigned, Washington, US
2293 2293 90055 Unassigned Wisconsin US 4/6/20 23:22     0 0 0 0 Unassigned, Wisconsin, US
2553 2553     Diamond Princess Canada 4/6/20 23:28     0 1 0 0 Diamond Princess, Canada
2554 2554 88888   Diamond Princess US 4/6/20 23:22     49 0 0 0 Diamond Princess, US
2562 2562     Grand Princess Canada 4/6/20 23:28     13 0 0 0 Grand Princess, Canada
2563 2563 99999   Grand Princess US 4/6/20 23:22     103 3 0 0 Grand Princess, US
2604 2604     Recovered Canada 4/6/20 23:28     0 0 3256 0 Recovered, Canada
2605 2605     Recovered US 4/6/20 23:22     0 0 19581 0 Recovered, US
2674 2674       Diamond Princess 4/6/20 23:21     712 11 619 82 Diamond Princess
2729 2729       MS Zaandam 4/6/20 23:21     9 2 0 7 ,,MS Zaandam
2810 2810   unassigned Wyoming US 4/6/20 23:22     0 0 0 0 unassigned, Wyoming, US
2555 2555     Falkland Islands (Islas Malvinas) United Kingdom 4/6/20 23:21 -51.7963 -59.5236 2 0 0 2 Falkland Islands (Islas Malvinas), United Kingdom
2619 2619     Tasmania Australia 4/6/20 23:28 -42.8821 147.3272 86 2 26 58 Tasmania, Australia
2748 2748       New Zealand 4/6/20 23:21 -40.9006 174.886 1106 1 176 929 New Zealand
2636 2636       Argentina 4/6/20 23:21 -38.4161 -63.6167 1554 48 325 1181 Argentina
2623 2623     Victoria Australia 4/6/20 23:28 -37.8136 144.9631 1158 10 620 528 Victoria, Australia
2663 2663       Chile 4/6/20 23:21 -35.6751 -71.543 4815 37 728 4050 Chile
2543 2543     Australian Capital Territory Australia 4/6/20 23:28 -35.4735 149.0124 96 2 40 54 Australian Capital Territory, Australia
2617 2617     South Australia Australia 4/6/20 23:28 -34.9285 138.6007 411 0 53 358 South Australia, Australia
2590 2590     New South Wales Australia 4/6/20 23:28 -33.8688 151.2093 2637 18 4 2615 New South Wales, Australia
2803 2803       Uruguay 4/6/20 23:21 -32.5228 -55.7658 406 6 104 296 Uruguay
2625 2625     Western Australia Australia 4/6/20 23:28 -31.9505 115.8605 460 4 162 294 Western Australia, Australia
2782 2782       South Africa 4/6/20 23:21 -30.5595 22.9375 1686 12 95 1579 South Africa
2603 2603     Queensland Australia 4/6/20 23:28 -27.4698 153.0251 921 4 173 744 Queensland, Australia
2684 2684       Eswatini 4/6/20 23:21 -26.5225 31.4659 10 0 4 6 Eswatini
2758 2758       Paraguay 4/6/20 23:21 -23.4425 -58.4438 113 5 12 96 Paraguay
2745 2745       Namibia 4/6/20 23:21 -22.9576 18.4904 16 0 3 13 Namibia
2651 2651       Botswana 4/6/20 23:21 -22.3285 24.6849 6 1 0 5 Botswana
2606 2606     Reunion France 4/6/20 23:21 -21.1151 55.5364 349 0 40 309 Reunion, France
2589 2589     New Caledonia France 4/6/20 23:21 -20.904305 165.618042 18 0 1 17 New Caledonia, France
2737 2737       Mauritius 4/6/20 23:21 -20.348404 57.552152 244 7 7 230 Mauritius
2809 2809       Zimbabwe 4/6/20 23:21 -19.015438 29.154857 10 1 0 9 Zimbabwe
2730 2730       Madagascar 4/6/20 23:21 -18.766947 46.869107 82 0 2 80 Madagascar
2744 2744       Mozambique 4/6/20 23:21 -18.665695 35.529562 10 0 1 9 Mozambique
2686 2686       Fiji 4/6/20 23:21 -17.7134 178.065 14 0 0 14 Fiji
2558 2558     French Polynesia France 4/6/20 23:21 -17.6797 -149.4068 42 0 0 42 French Polynesia, France
2649 2649       Bolivia 4/6/20 23:21 -16.2902 -63.5887 183 11 2 170 Bolivia
2652 2652       Brazil 4/6/20 23:21 -14.235 -51.9253 12161 564 127 11470 Brazil
2770 2770       Samoa 4/6/20 23:28 -13.759 -172.1046 0 0 0 0 Samoa
2731 2731       Malawi 4/6/20 23:21 -13.254308 34.301525 5 0 0 5 Malawi
2808 2808       Zambia 4/6/20 23:21 -13.133897 27.849332 39 1 5 33 Zambia
2586 2586     Mayotte France 4/6/20 23:21 -12.8275 45.166244 147 2 14 131 Mayotte, France
2594 2594     Northern Territory Australia 4/6/20 23:28 -12.4634 130.8456 28 0 2 26 Northern Territory, Australia
2634 2634       Angola 4/6/20 23:21 -11.2027 17.8739 16 2 2 12 Angola
2759 2759       Peru 4/6/20 23:21 -9.19 -75.0152 2561 92 997 1472 Peru
2794 2794       Timor-Leste 4/6/20 23:21 -8.874217 125.727539 1 0 0 1 Timor-Leste
2608 2608     Saint Helena, Ascension and Tristan da Cunha United Kingdom 4/6/20 23:21 -7.9467 -14.3559 0 0 0 0 Saint Helena, Ascension and Tristan da Cunha, United Kingdom
2792 2792       Tanzania 4/6/20 23:21 -6.369028 34.888822 24 1 3 20 Tanzania
2757 2757       Papua New Guinea 4/6/20 23:21 -6.314993 143.95555 2 0 0 2 Papua New Guinea
2776 2776       Seychelles 4/6/20 23:21 -4.6796 55.492 11 0 0 11 Seychelles
2666 2666       Congo (Kinshasa) 4/6/20 23:21 -4.322447 15.307045 161 18 5 138 Congo (Kinshasa)
2665 2665       Congo (Brazzaville) 4/6/20 23:21 -4.2634 15.2832 45 5 2 38 Congo (Brazzaville)
2657 2657       Burundi 4/6/20 23:21 -3.3731 29.9189 3 0 0 3 Burundi
2766 2766       Rwanda 4/6/20 23:21 -1.9403 29.8739 105 0 4 101 Rwanda
2678 2678       Ecuador 4/6/20 23:21 -1.8312 -78.1834 3747 191 100 3456 Ecuador

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

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