04-08-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,884 rows sorted by Confirmed

✎ 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
49 49 20003 Anderson Kansas US 2020-04-08 22:51:58 38.21413251 -95.29272815 0 0 0 0 Anderson, Kansas, US
126 126 51017 Bath Virginia US 2020-04-08 22:51:58 38.05852573 -79.73912095 0 0 0 0 Bath, Virginia, US
149 149 18007 Benton Indiana US 2020-04-08 22:51:58 40.60626947 -87.31093999 0 0 0 0 Benton, Indiana, US
157 157 26019 Benzie Michigan US 2020-04-08 22:51:58 44.63899297 -86.01608482 0 0 0 0 Benzie, Michigan, US
180 180 51021 Bland Virginia US 2020-04-08 22:51:58 37.13128068 -81.13599391 0 0 0 0 Bland, Virginia, US
272 272 46019 Butte South Dakota US 2020-04-08 22:51:58 44.90608745 -103.5079318 0 0 0 0 Butte, South Dakota, US
566 566 47033 Crockett Tennessee US 2020-04-08 22:51:58 35.81830662 -89.14916269 0 0 0 0 Crockett, Tennessee, US
652 652 51051 Dickenson Virginia US 2020-04-08 22:51:58 37.12560977 -82.35124171 0 0 0 0 Dickenson, Virginia, US
739 739 51057 Essex Virginia US 2020-04-08 22:51:58 37.93357639 -76.94230311 0 0 0 0 Essex, Virginia, US
744 744 51600 Fairfax City Virginia US 2020-04-08 22:51:58 38.85157547 -77.29779640000002 0 0 0 0 Fairfax City, Virginia, US
750 750 51610 Falls Church Virginia US 2020-04-08 22:51:58 38.88485255 -77.17560759 0 0 0 0 Falls Church, Virginia, US
779 779 51063 Floyd Virginia US 2020-04-08 22:51:58 36.9302126 -80.36738849 0 0 0 0 Floyd, Virginia, US
851 851 1061 Geneva Alabama US 2020-04-08 22:51:58 31.09389027 -85.83572839 0 0 0 0 Geneva, Alabama, US
907 907 51077 Grayson Virginia US 2020-04-08 22:51:58 36.65677234 -81.23215889 0 0 0 0 Grayson, Virginia, US
973 973 47067 Hancock Tennessee US 2020-04-08 22:51:58 36.52692871 -83.22375847 0 0 0 0 Hancock, Tennessee, US
1033 1033 51091 Highland Virginia US 2020-04-08 22:51:58 38.35799465 -79.56124594 0 0 0 0 Highland, Virginia, US
1228 1228 46077 Kingsbury South Dakota US 2020-04-08 22:51:58 44.36956169 -97.4913945 0 0 0 0 Kingsbury, South Dakota, US
1271 1271 47095 Lake Tennessee US 2020-04-08 22:51:58 36.34180170000001 -89.48921915 0 0 0 0 Lake, Tennessee, US
1335 1335 16061 Lewis Idaho US 2020-04-08 22:51:58 46.23315327 -116.434146 0 0 0 0 Lewis, Idaho, US
1385 1385 31113 Logan Nebraska US 2020-04-08 22:51:58 41.56650314 -100.4817851 0 0 0 0 Logan, Nebraska, US
1493 1493 51690 Martinsville Virginia US 2020-04-08 22:51:58 36.68212094 -79.86352771 0 0 0 0 Martinsville, Virginia, US
1513 1513 48307 McCulloch Texas US 2020-04-08 22:51:58 31.1925468 -99.34682807 0 0 0 0 McCulloch, Texas, US
1554 1554 38057 Mercer North Dakota US 2020-04-08 22:51:58 47.31213126 -101.8318399 0 0 0 0 Mercer, North Dakota, US
1569 1569 51119 Middlesex Virginia US 2020-04-08 22:51:58 37.63191998 -76.55064617 0 0 0 0 Middlesex, Virginia, US
1634 1634 47127 Moore Tennessee US 2020-04-08 22:51:58 35.27724699 -86.36230578 0 0 0 0 Moore, Tennessee, US
1714 1714 51720 Norton Virginia US 2020-04-08 22:51:58 36.93357076 -82.62750411 0 0 0 0 Norton, Virginia, US
1750 1750 26131 Ontonagon Michigan US 2020-04-08 22:51:58 46.665226200000006 -89.31390481 0 0 0 0 Ontonagon, Michigan, US
1785 1785 80008 Out of CO Colorado US 2020-04-08 22:51:58     0 1 0 0 Out of CO,Colorado,US
1811 1811 51141 Patrick Virginia US 2020-04-08 22:51:58 36.680163799999995 -80.2865648 0 0 0 0 Patrick, Virginia, US
1828 1828 55091 Pepin Wisconsin US 2020-04-08 22:51:58 44.58307413 -91.99949611 0 0 0 0 Pepin, Wisconsin, US
1877 1877 56031 Platte Wyoming US 2020-04-08 22:51:58 42.13299116 -104.96633100000001 0 0 0 0 Platte, Wyoming, US
1934 1934 39137 Putnam Ohio US 2020-04-08 22:51:58 41.02094889 -84.1336111 0 0 0 0 Putnam, Ohio, US
1969 1969 47143 Rhea Tennessee US 2020-04-08 22:51:58 35.60536161 -84.93076643 0 0 0 0 Rhea, Tennessee, US
2007 2007 38079 Rolette North Dakota US 2020-04-08 22:51:58 48.77245354 -99.84097493 0 0 0 0 Rolette, North Dakota, US
2087 2087 51169 Scott Virginia US 2020-04-08 22:51:58 36.71466456 -82.60171704 0 0 0 0 Scott, Virginia, US
2272 2272 29215 Texas Missouri US 2020-04-08 22:51:58 37.31728859 -91.96564727 0 0 0 0 Texas, Missouri, US
2324 2324 90004 Unassigned Arizona US 2020-04-08 22:51:58     0 12 0 0 Unassigned, Arizona, US
2329 2329 90010 Unassigned Delaware US 2020-04-08 22:51:58     0 13 0 0 Unassigned, Delaware, US
2333 2333 90016 Unassigned Idaho US 2020-04-08 22:51:58     0 0 0 0 Unassigned, Idaho, US
2335 2335 90018 Unassigned Indiana US 2020-04-08 22:51:58     0 135 0 0 Unassigned, Indiana, US
2336 2336 90019 Unassigned Iowa US 2020-04-08 22:51:58     0 1 0 0 Unassigned, Iowa, US
2337 2337 90020 Unassigned Kansas US 2020-04-08 22:51:58     0 4 0 0 Unassigned,Kansas,US
2341 2341 90024 Unassigned Maryland US 2020-04-08 22:51:58     0 0 0 0 Unassigned, Maryland, US
2345 2345 90028 Unassigned Mississippi US 2020-04-08 22:51:58     0 0 0 0 Unassigned, Mississippi, US
2347 2347 90030 Unassigned Montana US 2020-04-08 22:51:58     0 0 0 0 Unassigned, Montana, US
2348 2348 90031 Unassigned Nebraska US 2020-04-08 22:51:58     0 1 0 0 Unassigned, Nebraska, US
2349 2349 90032 Unassigned Nevada US 2020-04-08 22:51:58     0 0 0 0 Unassigned, Nevada, US
2352 2352 90035 Unassigned New Mexico US 2020-04-08 22:51:58     0 0 0 0 Unassigned, New Mexico, US
2353 2353 90036 Unassigned New York US 2020-04-08 22:51:58     0 152 0 0 Unassigned, New York, US
2354 2354 90038 Unassigned North Dakota US 2020-04-08 22:51:58     0 0 0 0 Unassigned, North Dakota, US
2355 2355 90039 Unassigned Ohio US 2020-04-08 22:51:58     0 0 0 0 Unassigned, Ohio, US
2356 2356 90040 Unassigned Oklahoma US 2020-04-08 22:51:58     0 0 0 0 Unassigned, Oklahoma, US
2357 2357 90042 Unassigned Pennsylvania US 2020-04-08 22:51:58     0 0 0 0 Unassigned, Pennsylvania, US
2359 2359 90046 Unassigned South Dakota US 2020-04-08 22:51:58     0 0 0 0 Unassigned, South Dakota, US
2361 2361 90049 Unassigned Utah US 2020-04-08 22:51:58     0 0 0 0 Unassigned,Utah,US
2363 2363 90051 Unassigned Virginia US 2020-04-08 22:51:58     0 42 0 0 Unassigned, Virginia, US
2366 2366 90055 Unassigned Wisconsin US 2020-04-08 22:51:58     0 0 0 0 Unassigned, Wisconsin, US
2367 2367   Unassigned Wyoming US 2020-04-08 22:51:58     0 0 0 0 Unassigned,Wyoming,US
2395 2395 47175 Van Buren Tennessee US 2020-04-08 22:51:58 35.69864497 -85.45221699 0 0 0 0 Van Buren, Tennessee, US
2467 2467 29221 Washington Missouri US 2020-04-08 22:51:58 37.96130078 -90.87948158 0 0 0 0 Washington, Missouri, US
2628 2628     Diamond Princess Canada 2020-04-08 22:58:44     0 1 0 0 Diamond Princess, Canada
2672 2672     Nunavut Canada 2020-04-08 22:58:44 70.2998 -83.1076 0 0 0 0 Nunavut, Canada
2679 2679     Recovered Canada 2020-04-08 22:58:44     0 0 4154 0 Recovered, Canada
2680 2680     Recovered US 2020-04-08 22:51:58     0 0 23559 0 Recovered, US
2683 2683     Saint Helena, Ascension and Tristan da Cunha United Kingdom 2020-04-08 22:51:39 -7.9467 -14.3559 0 0 0 0 Saint Helena, Ascension and Tristan da Cunha, United Kingdom
2845 2845       Samoa 2020-04-08 22:58:44 -13.759 -172.1046 0 0 0 0 Samoa
5 5 19001 Adair Iowa US 2020-04-08 22:51:58 41.33075609 -94.47105874 1 0 0 0 Adair, Iowa, US
10 10 16003 Adams Idaho US 2020-04-08 22:51:58 44.89333571 -116.4545247 1 0 0 0 Adams, Idaho, US
11 11 17001 Adams Illinois US 2020-04-08 22:51:58 39.98815591 -91.18786813 1 0 0 0 Adams, Illinois, US
43 43 6003 Alpine California US 2020-04-08 22:51:58 38.59678594 -119.82235940000001 1 0 0 0 Alpine, California, US
60 60 31003 Antelope Nebraska US 2020-04-08 22:51:58 42.17695516 -98.06662829999999 1 0 0 0 Antelope, Nebraska, US
63 63 19007 Appanoose Iowa US 2020-04-08 22:51:58 40.74324454 -92.86865906 1 1 0 0 Appanoose, Iowa, US
70 70 5001 Arkansas Arkansas US 2020-04-08 22:51:58 34.29145151 -91.37277296 1 0 0 0 Arkansas, Arkansas, US
77 77 55003 Ashland Wisconsin US 2020-04-08 22:51:58 46.31956891 -90.67837132 1 0 0 0 Ashland, Wisconsin, US
84 84 29005 Atchison Missouri US 2020-04-08 22:51:58 40.43238737 -95.42970639 1 0 0 0 Atchison, Missouri, US
88 88 40005 Atoka Oklahoma US 2020-04-08 22:51:58 34.37366573 -96.03802487 1 0 0 0 Atoka, Oklahoma, US
90 90 19009 Audubon Iowa US 2020-04-08 22:51:58 41.6844628 -94.90581859 1 0 0 0 Audubon, Iowa, US
93 93 46003 Aurora South Dakota US 2020-04-08 22:51:58 43.71757685 -98.56050467 1 0 0 0 Aurora, South Dakota, US
106 106 48019 Bandera Texas US 2020-04-08 22:51:58 29.74619598 -99.24598147 1 0 0 0 Bandera, Texas, US
109 109 20007 Barber Kansas US 2020-04-08 22:51:58 37.2288586 -98.68460053 1 0 0 0 Barber, Kansas, US
115 115 21009 Barren Kentucky US 2020-04-08 22:51:58 36.96469836 -85.93338945 1 0 0 0 Barren, Kentucky, US
119 119 29009 Barry Missouri US 2020-04-08 22:51:58 36.70978521 -93.82919888 1 0 0 0 Barry, Missouri, US
125 125 21011 Bath Kentucky US 2020-04-08 22:51:58 38.14735938 -83.74588932 1 0 0 0 Bath, Kentucky, US
127 127 5005 Baxter Arkansas US 2020-04-08 22:51:58 36.28784385 -92.33782872 1 0 0 0 Baxter, Arkansas, US
135 135 40007 Beaver Oklahoma US 2020-04-08 22:51:58 36.7496847 -100.4758872 1 0 0 0 Beaver, Oklahoma, US
137 137 30001 Beaverhead Montana US 2020-04-08 22:51:58 45.13434354 -112.89846940000001 1 0 0 0 Beaverhead, Montana, US
138 138 40009 Beckham Oklahoma US 2020-04-08 22:51:58 35.26862449 -99.68128023 1 0 0 0 Beckham, Oklahoma, US
151 151 27009 Benton Minnesota US 2020-04-08 22:51:58 45.69804958 -93.99514135 1 0 0 0 Benton, Minnesota, US
167 167 2050 Bethel Alaska US 2020-04-08 22:51:58 60.90980451 -159.8561831 1 0 0 0 Bethel, Alaska, US
172 172 27011 Big Stone Minnesota US 2020-04-08 22:51:58 45.42712824 -96.41403739 1 0 0 0 Big Stone, Minnesota, US
176 176 37017 Bladen North Carolina US 2020-04-08 22:51:58 34.61296243 -78.56180059 1 0 0 0 Bladen, North Carolina, US
181 181 13023 Bleckley Georgia US 2020-04-08 22:51:58 32.43829035 -83.33035166 1 0 0 0 Bleckley, Georgia, US
192 192 5009 Boone Arkansas US 2020-04-08 22:51:58 36.3084504 -93.09374925 1 0 0 0 Boone, Arkansas, US
198 198 54005 Boone West Virginia US 2020-04-08 22:51:58 38.01974191 -81.69888019 1 0 0 0 Boone, West Virginia, US
205 205 38011 Bowman North Dakota US 2020-04-08 22:51:58 46.11285362 -103.5203343 1 0 0 0 Bowman, North Dakota, US
209 209 21023 Bracken Kentucky US 2020-04-08 22:51:58 38.69158994 -84.08532444 1 0 0 0 Bracken, Kentucky, US
216 216 54007 Braxton West Virginia US 2020-04-08 22:51:58 38.70036159 -80.72011184 1 0 0 0 Braxton, West Virginia, US
219 219 21025 Breathitt Kentucky US 2020-04-08 22:51:58 37.52333168 -83.31959161 1 0 0 0 Breathitt, Kentucky, US
225 225 51520 Bristol Virginia US 2020-04-08 22:51:58 36.616302399999995 -82.16359122 1 0 0 0 Bristol, Virginia, US
227 227 54009 Brooke West Virginia US 2020-04-08 22:51:58 40.27367263 -80.57915332 1 0 0 0 Brooke, West Virginia, US

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

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