04-07-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,858 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-07 23:04:49 38.21413251 -95.29272815 0 0 0 0 Anderson, Kansas, US
125 125 51017 Bath Virginia US 2020-04-07 23:04:49 38.05852573 -79.73912095 0 0 0 0 Bath, Virginia, US
148 148 18007 Benton Indiana US 2020-04-07 23:04:49 40.60626947 -87.31093999 0 0 0 0 Benton, Indiana, US
156 156 26019 Benzie Michigan US 2020-04-07 23:04:49 44.63899297 -86.01608482 0 0 0 0 Benzie, Michigan, US
179 179 51021 Bland Virginia US 2020-04-07 23:04:49 37.13128068 -81.13599391 0 0 0 0 Bland, Virginia, US
268 268 46019 Butte South Dakota US 2020-04-07 23:04:49 44.90608745 -103.5079318 0 0 0 0 Butte, South Dakota, US
500 500 51570 Colonial Heights Virginia US 2020-04-07 23:04:49 37.26420587 -77.39609676 0 0 0 0 Colonial Heights, Virginia, US
561 561 47033 Crockett Tennessee US 2020-04-07 23:04:49 35.81830662 -89.14916269 0 0 0 0 Crockett, Tennessee, US
627 627 47039 Decatur Tennessee US 2020-04-07 23:04:49 35.60048904 -88.11043779 0 0 0 0 Decatur, Tennessee, US
646 646 51051 Dickenson Virginia US 2020-04-07 23:04:49 37.12560977 -82.35124171 0 0 0 0 Dickenson, Virginia, US
733 733 51057 Essex Virginia US 2020-04-07 23:04:49 37.93357639 -76.94230311 0 0 0 0 Essex, Virginia, US
738 738 51600 Fairfax City Virginia US 2020-04-07 23:04:49 38.85157547 -77.29779640000002 0 0 0 0 Fairfax City, Virginia, US
744 744 51610 Falls Church Virginia US 2020-04-07 23:04:49 38.88485255 -77.17560759 0 0 0 0 Falls Church, Virginia, US
773 773 51063 Floyd Virginia US 2020-04-07 23:04:49 36.9302126 -80.36738849 0 0 0 0 Floyd, Virginia, US
899 899 51077 Grayson Virginia US 2020-04-07 23:04:49 36.65677234 -81.23215889 0 0 0 0 Grayson, Virginia, US
962 962 47067 Hancock Tennessee US 2020-04-07 23:04:49 36.52692871 -83.22375847 0 0 0 0 Hancock, Tennessee, US
1021 1021 51091 Highland Virginia US 2020-04-07 23:04:49 38.35799465 -79.56124594 0 0 0 0 Highland, Virginia, US
1213 1213 46077 Kingsbury South Dakota US 2020-04-07 23:04:49 44.36956169 -97.4913945 0 0 0 0 Kingsbury, South Dakota, US
1256 1256 47095 Lake Tennessee US 2020-04-07 23:04:49 36.34180170000001 -89.48921915 0 0 0 0 Lake, Tennessee, US
1320 1320 16061 Lewis Idaho US 2020-04-07 23:04:49 46.23315327 -116.434146 0 0 0 0 Lewis, Idaho, US
1478 1478 51690 Martinsville Virginia US 2020-04-07 23:04:49 36.68212094 -79.86352771 0 0 0 0 Martinsville, Virginia, US
1539 1539 38057 Mercer North Dakota US 2020-04-07 23:04:49 47.31213126 -101.8318399 0 0 0 0 Mercer, North Dakota, US
1554 1554 51119 Middlesex Virginia US 2020-04-07 23:04:49 37.63191998 -76.55064617 0 0 0 0 Middlesex, Virginia, US
1619 1619 47127 Moore Tennessee US 2020-04-07 23:04:49 35.27724699 -86.36230578 0 0 0 0 Moore, Tennessee, US
1699 1699 51720 Norton Virginia US 2020-04-07 23:04:49 36.93357076 -82.62750411 0 0 0 0 Norton, Virginia, US
1734 1734 26131 Ontonagon Michigan US 2020-04-07 23:04:49 46.665226200000006 -89.31390481 0 0 0 0 Ontonagon, Michigan, US
1769 1769 80008 Out of CO Colorado US 2020-04-07 23:04:49     0 1 0 0 Out of CO,Colorado,US
1795 1795 51141 Patrick Virginia US 2020-04-07 23:04:49 36.680163799999995 -80.2865648 0 0 0 0 Patrick, Virginia, US
1812 1812 55091 Pepin Wisconsin US 2020-04-07 23:04:49 44.58307413 -91.99949611 0 0 0 0 Pepin, Wisconsin, US
1836 1836 47137 Pickett Tennessee US 2020-04-07 23:04:49 36.55606529 -85.07763299999998 0 0 0 0 Pickett, Tennessee, US
1918 1918 39137 Putnam Ohio US 2020-04-07 23:04:49 41.02094889 -84.1336111 0 0 0 0 Putnam, Ohio, US
1953 1953 47143 Rhea Tennessee US 2020-04-07 23:04:49 35.60536161 -84.93076643 0 0 0 0 Rhea, Tennessee, US
1989 1989 38079 Rolette North Dakota US 2020-04-07 23:04:49 48.77245354 -99.84097493 0 0 0 0 Rolette, North Dakota, US
2052 2052 26153 Schoolcraft Michigan US 2020-04-07 23:04:49 46.19235734 -86.19972234 0 0 0 0 Schoolcraft, Michigan, US
2067 2067 51169 Scott Virginia US 2020-04-07 23:04:49 36.71466456 -82.60171704 0 0 0 0 Scott, Virginia, US
2249 2249 29215 Texas Missouri US 2020-04-07 23:04:49 37.31728859 -91.96564727 0 0 0 0 Texas, Missouri, US
2300 2300 90002 Unassigned Alaska US 2020-04-07 23:04:49     0 1 0 0 Unassigned, Alaska, US
2301 2301 90004 Unassigned Arizona US 2020-04-07 23:04:49     0 14 0 0 Unassigned, Arizona, US
2306 2306 90010 Unassigned Delaware US 2020-04-07 23:04:49     0 10 0 0 Unassigned, Delaware, US
2310 2310 90016 Unassigned Idaho US 2020-04-07 23:04:49     0 0 0 0 Unassigned, Idaho, US
2312 2312 90018 Unassigned Indiana US 2020-04-07 23:04:49     0 136 0 0 Unassigned, Indiana, US
2313 2313 90019 Unassigned Iowa US 2020-04-07 23:04:49     0 1 0 0 Unassigned, Iowa, US
2314 2314 90020 Unassigned Kansas US 2020-04-07 23:04:49     0 5 0 0 Unassigned,Kansas,US
2318 2318 90024 Unassigned Maryland US 2020-04-07 23:04:49     0 0 0 0 Unassigned, Maryland, US
2323 2323 90030 Unassigned Montana US 2020-04-07 23:04:49     0 0 0 0 Unassigned, Montana, US
2328 2328 90035 Unassigned New Mexico US 2020-04-07 23:04:49     0 0 0 0 Unassigned, New Mexico, US
2329 2329 90036 Unassigned New York US 2020-04-07 23:04:49     0 116 0 0 Unassigned, New York, US
2330 2330 90037 Unassigned North Carolina US 2020-04-07 23:04:49     0 2 0 0 Unassigned, North Carolina, US
2331 2331 90038 Unassigned North Dakota US 2020-04-07 23:04:49     0 0 0 0 Unassigned, North Dakota, US
2332 2332 90039 Unassigned Ohio US 2020-04-07 23:04:49     0 0 0 0 Unassigned, Ohio, US
2333 2333 90040 Unassigned Oklahoma US 2020-04-07 23:04:49     0 0 0 0 Unassigned, Oklahoma, US
2334 2334 90042 Unassigned Pennsylvania US 2020-04-07 23:04:49     0 0 0 0 Unassigned, Pennsylvania, US
2336 2336 90046 Unassigned South Dakota US 2020-04-07 23:04:49     0 0 0 0 Unassigned, South Dakota, US
2338 2338 90049 Unassigned Utah US 2020-04-07 23:04:49     0 0 0 0 Unassigned,Utah,US
2340 2340 90051 Unassigned Virginia US 2020-04-07 23:04:49     0 50 0 0 Unassigned, Virginia, US
2342 2342 90055 Unassigned Wisconsin US 2020-04-07 23:04:49     0 0 0 0 Unassigned, Wisconsin, US
2343 2343   Unassigned Wyoming US 2020-04-07 23:04:49     0 0 0 0 Unassigned,Wyoming,US
2371 2371 47175 Van Buren Tennessee US 2020-04-07 23:04:49 35.69864497 -85.45221699 0 0 0 0 Van Buren, Tennessee, US
2602 2602     Diamond Princess Canada 2020-04-07 23:11:15     0 1 0 0 Diamond Princess, Canada
2646 2646     Nunavut Canada 2020-04-07 23:11:15 70.2998 -83.1076 0 0 0 0 Nunavut, Canada
2653 2653     Recovered Canada 2020-04-07 23:11:15     0 0 3791 0 Recovered, Canada
2654 2654     Recovered US 2020-04-07 23:04:49     0 0 21763 0 Recovered, US
2657 2657     Saint Helena, Ascension and Tristan da Cunha United Kingdom 2020-04-07 23:04:29 -7.9467 -14.3559 0 0 0 0 Saint Helena, Ascension and Tristan da Cunha, United Kingdom
2819 2819       Samoa 2020-04-07 23:11:15 -13.759 -172.1046 0 0 0 0 Samoa
5 5 19001 Adair Iowa US 2020-04-07 23:04:49 41.33075609 -94.47105874 1 0 0 0 Adair, Iowa, US
10 10 16003 Adams Idaho US 2020-04-07 23:04:49 44.89333571 -116.4545247 1 0 0 0 Adams, Idaho, US
43 43 6003 Alpine California US 2020-04-07 23:04:49 38.59678594 -119.82235940000001 1 0 0 0 Alpine, California, US
60 60 31003 Antelope Nebraska US 2020-04-07 23:04:49 42.17695516 -98.06662829999999 1 0 0 0 Antelope, Nebraska, US
63 63 19007 Appanoose Iowa US 2020-04-07 23:04:49 40.74324454 -92.86865906 1 1 0 0 Appanoose, Iowa, US
70 70 5001 Arkansas Arkansas US 2020-04-07 23:04:49 34.29145151 -91.37277296 1 0 0 0 Arkansas, Arkansas, US
77 77 55003 Ashland Wisconsin US 2020-04-07 23:04:49 46.31956891 -90.67837132 1 0 0 0 Ashland, Wisconsin, US
84 84 29005 Atchison Missouri US 2020-04-07 23:04:49 40.43238737 -95.42970639 1 0 0 0 Atchison, Missouri, US
88 88 40005 Atoka Oklahoma US 2020-04-07 23:04:49 34.37366573 -96.03802487 1 0 0 0 Atoka, Oklahoma, US
90 90 19009 Audubon Iowa US 2020-04-07 23:04:49 41.6844628 -94.90581859 1 0 0 0 Audubon, Iowa, US
93 93 46003 Aurora South Dakota US 2020-04-07 23:04:49 43.71757685 -98.56050467 1 0 0 0 Aurora, South Dakota, US
108 108 20007 Barber Kansas US 2020-04-07 23:04:49 37.2288586 -98.68460053 1 0 0 0 Barber, Kansas, US
114 114 21009 Barren Kentucky US 2020-04-07 23:04:49 36.96469836 -85.93338945 1 0 0 0 Barren, Kentucky, US
118 118 29009 Barry Missouri US 2020-04-07 23:04:49 36.70978521 -93.82919888 1 0 0 0 Barry, Missouri, US
124 124 21011 Bath Kentucky US 2020-04-07 23:04:49 38.14735938 -83.74588932 1 0 0 0 Bath, Kentucky, US
126 126 5005 Baxter Arkansas US 2020-04-07 23:04:49 36.28784385 -92.33782872 1 0 0 0 Baxter, Arkansas, US
134 134 40007 Beaver Oklahoma US 2020-04-07 23:04:49 36.7496847 -100.4758872 1 0 0 0 Beaver, Oklahoma, US
136 136 30001 Beaverhead Montana US 2020-04-07 23:04:49 45.13434354 -112.89846940000001 1 0 0 0 Beaverhead, Montana, US
137 137 40009 Beckham Oklahoma US 2020-04-07 23:04:49 35.26862449 -99.68128023 1 0 0 0 Beckham, Oklahoma, US
150 150 27009 Benton Minnesota US 2020-04-07 23:04:49 45.69804958 -93.99514135 1 0 0 0 Benton, Minnesota, US
166 166 2050 Bethel Alaska US 2020-04-07 23:04:49 60.90980451 -159.8561831 1 0 0 0 Bethel, Alaska, US
171 171 27011 Big Stone Minnesota US 2020-04-07 23:04:49 45.42712824 -96.41403739 1 0 0 0 Big Stone, Minnesota, US
175 175 37017 Bladen North Carolina US 2020-04-07 23:04:49 34.61296243 -78.56180059 1 0 0 0 Bladen, North Carolina, US
180 180 13023 Bleckley Georgia US 2020-04-07 23:04:49 32.43829035 -83.33035166 1 0 0 0 Bleckley, Georgia, US
191 191 5009 Boone Arkansas US 2020-04-07 23:04:49 36.3084504 -93.09374925 1 0 0 0 Boone, Arkansas, US
203 203 38011 Bowman North Dakota US 2020-04-07 23:04:49 46.11285362 -103.5203343 1 0 0 0 Bowman, North Dakota, US
207 207 21023 Bracken Kentucky US 2020-04-07 23:04:49 38.69158994 -84.08532444 1 0 0 0 Bracken, Kentucky, US
216 216 21025 Breathitt Kentucky US 2020-04-07 23:04:49 37.52333168 -83.31959161 1 0 0 0 Breathitt, Kentucky, US
222 222 51520 Bristol Virginia US 2020-04-07 23:04:49 36.616302399999995 -82.16359122 1 0 0 0 Bristol, Virginia, US
224 224 54009 Brooke West Virginia US 2020-04-07 23:04:49 40.27367263 -80.57915332 1 0 0 0 Brooke, West Virginia, US
237 237 51025 Brunswick Virginia US 2020-04-07 23:04:49 36.76366949 -77.8593436 1 0 0 0 Brunswick, Virginia, US
242 242 51027 Buchanan Virginia US 2020-04-07 23:04:49 37.26818323 -82.03749726 1 0 0 0 Buchanan, Virginia, US
261 261 19023 Butler Iowa US 2020-04-07 23:04:49 42.73172833 -92.79015971 1 0 0 0 Butler, Iowa, US
263 263 21031 Butler Kentucky US 2020-04-07 23:04:49 37.20946153 -86.68748787 1 0 0 0 Butler, Kentucky, US
279 279 29025 Caldwell Missouri US 2020-04-07 23:04:49 39.65620858 -93.98308093 1 0 0 0 Caldwell, Missouri, US
286 286 17013 Calhoun Illinois US 2020-04-07 23:04:49 39.16840183 -90.66330078 1 0 0 0 Calhoun, Illinois, US

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

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