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 Confirmed

✎ 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
49 49 20003 Anderson Kansas US 4/6/20 23:22 38.21413251 -95.29272815 0 0 0 0 Anderson, Kansas, US
112 112 21009 Barren Kentucky US 4/6/20 23:22 36.96469836 -85.93338945 0 0 0 0 Barren, Kentucky, US
123 123 51017 Bath Virginia US 4/6/20 23:22 38.05852573 -79.73912095 0 0 0 0 Bath, Virginia, US
145 145 18007 Benton Indiana US 4/6/20 23:22 40.60626947 -87.31093999 0 0 0 0 Benton, Indiana, US
153 153 26019 Benzie Michigan US 4/6/20 23:22 44.63899297 -86.01608482 0 0 0 0 Benzie, Michigan, US
175 175 51021 Bland Virginia US 4/6/20 23:22 37.13128068 -81.13599391 0 0 0 0 Bland, Virginia, US
236 236 51027 Buchanan Virginia US 4/6/20 23:22 37.26818323 -82.03749726 0 0 0 0 Buchanan, Virginia, US
262 262 46019 Butte South Dakota US 4/6/20 23:22 44.90608745 -103.5079318 0 0 0 0 Butte, South Dakota, US
491 491 51570 Colonial Heights Virginia US 4/6/20 23:22 37.26420587 -77.39609676 0 0 0 0 Colonial Heights, Virginia, US
551 551 47033 Crockett Tennessee US 4/6/20 23:22 35.81830662 -89.14916269 0 0 0 0 Crockett, Tennessee, US
616 616 47039 Decatur Tennessee US 4/6/20 23:22 35.60048904 -88.11043779 0 0 0 0 Decatur, Tennessee, US
621 621 19055 Delaware Iowa US 4/6/20 23:22 42.47104597 -91.3664492 0 0 0 0 Delaware, Iowa, US
634 634 51051 Dickenson Virginia US 4/6/20 23:22 37.12560977 -82.35124171 0 0 0 0 Dickenson, Virginia, US
639 639 51053 Dinwiddie Virginia US 4/6/20 23:22 37.07544585 -77.63451754 0 0 0 0 Dinwiddie, Virginia, US
719 719 51057 Essex Virginia US 4/6/20 23:22 37.93357639 -76.94230311 0 0 0 0 Essex, Virginia, US
724 724 51600 Fairfax City Virginia US 4/6/20 23:22 38.85157547 -77.2977964 0 0 0 0 Fairfax City, Virginia, US
730 730 51610 Falls Church Virginia US 4/6/20 23:22 38.88485255 -77.17560759 0 0 0 0 Falls Church, Virginia, US
757 757 51063 Floyd Virginia US 4/6/20 23:22 36.9302126 -80.36738849 0 0 0 0 Floyd, Virginia, US
880 880 51077 Grayson Virginia US 4/6/20 23:22 36.65677234 -81.23215889 0 0 0 0 Grayson, Virginia, US
941 941 47067 Hancock Tennessee US 4/6/20 23:22 36.52692871 -83.22375847 0 0 0 0 Hancock, Tennessee, US
1000 1000 51091 Highland Virginia US 4/6/20 23:22 38.35799465 -79.56124594 0 0 0 0 Highland, Virginia, US
1188 1188 46077 Kingsbury South Dakota US 4/6/20 23:22 44.36956169 -97.4913945 0 0 0 0 Kingsbury, South Dakota, US
1229 1229 47095 Lake Tennessee US 4/6/20 23:22 36.3418017 -89.48921915 0 0 0 0 Lake, Tennessee, US
1361 1361 51111 Lunenburg Virginia US 4/6/20 23:22 36.94618528 -78.24133319 0 0 0 0 Lunenburg, Virginia, US
1447 1447 51690 Martinsville Virginia US 4/6/20 23:22 36.68212094 -79.86352771 0 0 0 0 Martinsville, Virginia, US
1504 1504 38057 Mercer North Dakota US 4/6/20 23:22 47.31213126 -101.8318399 0 0 0 0 Mercer, North Dakota, US
1519 1519 51119 Middlesex Virginia US 4/6/20 23:22 37.63191998 -76.55064617 0 0 0 0 Middlesex, Virginia, US
1583 1583 47127 Moore Tennessee US 4/6/20 23:22 35.27724699 -86.36230578 0 0 0 0 Moore, Tennessee, US
1605 1605 21177 Muhlenberg Kentucky US 4/6/20 23:22 37.21425819 -87.14632053 0 0 0 0 Muhlenberg, Kentucky, US
1662 1662 51720 Norton Virginia US 4/6/20 23:22 36.93357076 -82.62750411 0 0 0 0 Norton, Virginia, US
1731 1731 80008 Out of CO Colorado US 4/6/20 23:22     0 1 0 0 Out of CO,Colorado,US
1757 1757 51141 Patrick Virginia US 4/6/20 23:22 36.6801638 -80.2865648 0 0 0 0 Patrick, Virginia, US
1774 1774 55091 Pepin Wisconsin US 4/6/20 23:22 44.58307413 -91.99949611 0 0 0 0 Pepin, Wisconsin, US
1798 1798 47137 Pickett Tennessee US 4/6/20 23:22 36.55606529 -85.077633 0 0 0 0 Pickett, Tennessee, US
1901 1901 51157 Rappahannock Virginia US 4/6/20 23:22 38.68295619 -78.15826963 0 0 0 0 Rappahannock, Virginia, US
1912 1912 47143 Rhea Tennessee US 4/6/20 23:22 35.60536161 -84.93076643 0 0 0 0 Rhea, Tennessee, US
1948 1948 38079 Rolette North Dakota US 4/6/20 23:22 48.77245354 -99.84097493 0 0 0 0 Rolette, North Dakota, US
2011 2011 26153 Schoolcraft Michigan US 4/6/20 23:22 46.19235734 -86.19972234 0 0 0 0 Schoolcraft, Michigan, US
2024 2024 51169 Scott Virginia US 4/6/20 23:22 36.71466456 -82.60171704 0 0 0 0 Scott, Virginia, US
2203 2203 29215 Texas Missouri US 4/6/20 23:22 37.31728859 -91.96564727 0 0 0 0 Texas, Missouri, 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
2259 2259 90010 Unassigned Delaware US 4/6/20 23:22     0 9 0 0 Unassigned, Delaware, US
2263 2263 90016 Unassigned Idaho US 4/6/20 23:22     0 0 0 0 Unassigned, Idaho, 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
2271 2271 90024 Unassigned Maryland US 4/6/20 23:22     0 0 0 0 Unassigned, Maryland, US
2276 2276 90030 Unassigned Montana US 4/6/20 23:22     0 0 0 0 Unassigned, Montana, 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
2287 2287 90046 Unassigned South Dakota US 4/6/20 23:22     0 0 0 0 Unassigned, South Dakota, US
2289 2289 90049 Unassigned Utah US 4/6/20 23:22     0 0 0 0 Unassigned,Utah,US
2291 2291 90051 Unassigned Virginia US 4/6/20 23:22     0 50 0 0 Unassigned, Virginia, US
2293 2293 90055 Unassigned Wisconsin US 4/6/20 23:22     0 0 0 0 Unassigned, Wisconsin, US
2321 2321 47175 Van Buren Tennessee US 4/6/20 23:22 35.69864497 -85.45221699 0 0 0 0 Van Buren, Tennessee, US
2408 2408 40149 Washita Oklahoma US 4/6/20 23:22 35.29071824 -98.99180434 0 0 0 0 Washita, Oklahoma, US
2553 2553     Diamond Princess Canada 4/6/20 23:28     0 1 0 0 Diamond Princess, Canada
2597 2597     Nunavut Canada 4/6/20 23:28 70.2998 -83.1076 0 0 0 0 Nunavut, Canada
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
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
2770 2770       Samoa 4/6/20 23:28 -13.759 -172.1046 0 0 0 0 Samoa
2810 2810   unassigned Wyoming US 4/6/20 23:22     0 0 0 0 unassigned, Wyoming, US
5 5 19001 Adair Iowa US 4/6/20 23:22 41.33075609 -94.47105874 1 0 0 0 Adair, Iowa, US
10 10 16003 Adams Idaho US 4/6/20 23:22 44.89333571 -116.4545247 1 0 0 0 Adams, Idaho, US
43 43 6003 Alpine California US 4/6/20 23:22 38.59678594 -119.8223594 1 0 0 0 Alpine, California, US
53 53 48001 Anderson Texas US 4/6/20 23:22 31.81534745 -95.65354823 1 0 0 0 Anderson, Texas, US
60 60 31003 Antelope Nebraska US 4/6/20 23:22 42.17695516 -98.0666283 1 0 0 0 Antelope, Nebraska, US
63 63 19007 Appanoose Iowa US 4/6/20 23:22 40.74324454 -92.86865906 1 2 0 0 Appanoose, Iowa, US
65 65 51011 Appomattox Virginia US 4/6/20 23:22 37.37569884 -78.81340003 1 0 0 0 Appomattox, Virginia, US
66 66 48007 Aransas Texas US 4/6/20 23:22 28.10556197 -96.9995047 1 0 0 0 Aransas, Texas, US
70 70 5001 Arkansas Arkansas US 4/6/20 23:22 34.29145151 -91.37277296 1 0 0 0 Arkansas, Arkansas, US
73 73 23003 Aroostook Maine US 4/6/20 23:22 46.65926321 -68.59841248 1 0 0 0 Aroostook, Maine, US
75 75 37009 Ashe North Carolina US 4/6/20 23:22 36.43296207 -81.49862729 1 0 0 0 Ashe, North Carolina, US
77 77 55003 Ashland Wisconsin US 4/6/20 23:22 46.31956891 -90.67837132 1 0 0 0 Ashland, Wisconsin, US
78 78 5003 Ashley Arkansas US 4/6/20 23:22 33.19153461 -91.7698471 1 0 0 0 Ashley, Arkansas, US
84 84 29005 Atchison Missouri US 4/6/20 23:22 40.43238737 -95.42970639 1 0 0 0 Atchison, Missouri, US
87 87 40005 Atoka Oklahoma US 4/6/20 23:22 34.37366573 -96.03802487 1 0 0 0 Atoka, Oklahoma, US
89 89 19009 Audubon Iowa US 4/6/20 23:22 41.6844628 -94.90581859 1 0 0 0 Audubon, Iowa, US
92 92 46003 Aurora South Dakota US 4/6/20 23:22 43.71757685 -98.56050467 1 0 0 0 Aurora, South Dakota, US
116 116 29009 Barry Missouri US 4/6/20 23:22 36.70978521 -93.82919888 1 0 0 0 Barry, Missouri, US
122 122 21011 Bath Kentucky US 4/6/20 23:22 38.14735938 -83.74588932 1 0 0 0 Bath, Kentucky, US
124 124 5005 Baxter Arkansas US 4/6/20 23:22 36.28784385 -92.33782872 1 0 0 0 Baxter, Arkansas, US
133 133 30001 Beaverhead Montana US 4/6/20 23:22 45.13434354 -112.8984694 1 0 0 0 Beaverhead, Montana, US
134 134 40009 Beckham Oklahoma US 4/6/20 23:22 35.26862449 -99.68128023 1 0 0 0 Beckham, Oklahoma, US
147 147 27009 Benton Minnesota US 4/6/20 23:22 45.69804958 -93.99514135 1 0 0 0 Benton, Minnesota, US
167 167 27011 Big Stone Minnesota US 4/6/20 23:22 45.42712824 -96.41403739 1 0 0 0 Big Stone, Minnesota, US
171 171 37017 Bladen North Carolina US 4/6/20 23:22 34.61296243 -78.56180059 1 0 0 0 Bladen, North Carolina, US
176 176 13023 Bleckley Georgia US 4/6/20 23:22 32.43829035 -83.33035166 1 0 0 0 Bleckley, Georgia, US
182 182 29017 Bollinger Missouri US 4/6/20 23:22 37.32449052 -90.02725304 1 0 0 0 Bollinger, Missouri, US
187 187 5009 Boone Arkansas US 4/6/20 23:22 36.3084504 -93.09374925 1 0 0 0 Boone, Arkansas, US
202 202 21023 Bracken Kentucky US 4/6/20 23:22 38.69158994 -84.08532444 1 0 0 0 Bracken, Kentucky, US
211 211 21025 Breathitt Kentucky US 4/6/20 23:22 37.52333168 -83.31959161 1 0 0 0 Breathitt, Kentucky, US
217 217 51520 Bristol Virginia US 4/6/20 23:22 36.6163024 -82.16359122 1 0 0 0 Bristol, Virginia, US
231 231 51025 Brunswick Virginia US 4/6/20 23:22 36.76366949 -77.8593436 1 0 0 0 Brunswick, Virginia, US
254 254 1013 Butler Alabama US 4/6/20 23:22 31.75300095 -86.68057478 1 0 0 0 Butler, Alabama, US
255 255 19023 Butler Iowa US 4/6/20 23:22 42.73172833 -92.79015971 1 0 0 0 Butler, Iowa, US

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