04-01-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,486 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
48 48 48003 Andrews Texas US 2020-04-01 21:58:49 32.30468633 -102.63765479999999 0 0 0 0 Andrews, Texas, US
59 59 48007 Aransas Texas US 2020-04-01 21:58:49 28.10556197 -96.9995047 0 0 0 0 Aransas, Texas, US
237 237 46019 Butte South Dakota US 2020-04-01 21:58:49 44.90608745 -103.5079318 0 0 0 0 Butte, South Dakota, US
546 546 47039 Decatur Tennessee US 2020-04-01 21:58:49 35.60048904 -88.11043779 0 0 0 0 Decatur, Tennessee, US
563 563 26043 Dickinson Michigan US 2020-04-01 21:58:49 46.00999672 -87.86961634 0 0 0 0 Dickinson, Michigan, US
632 632 1053 Escambia Alabama US 2020-04-01 21:58:49 31.1256789 -87.15918694 0 0 0 0 Escambia, Alabama, US
641 641 51600 Fairfax City Virginia US 2020-04-01 21:58:49 38.85157547 -77.29779640000002 0 0 0 0 Fairfax City, Virginia, US
675 675 20057 Ford Kansas US 2020-04-01 21:58:49 37.69200114 -99.88825298 0 0 0 0 Ford, Kansas, US
970 970 13161 Jeff Davis Georgia US 2020-04-01 21:58:49 31.80405727 -82.63724870000001 0 0 0 0 Jeff Davis, Georgia, US
1047 1047 46077 Kingsbury South Dakota US 2020-04-01 21:58:49 44.36956169 -97.4913945 0 0 0 0 Kingsbury, South Dakota, US
1310 1310 17129 Menard Illinois US 2020-04-01 21:58:49 40.02742725 -89.80246001 0 0 0 0 Menard, Illinois, US
1316 1316 38057 Mercer North Dakota US 2020-04-01 21:58:49 47.31213126 -101.8318399 0 0 0 0 Mercer, North Dakota, US
1757 1757 26153 Schoolcraft Michigan US 2020-04-01 21:58:49 46.19235734 -86.19972234 0 0 0 0 Schoolcraft, Michigan, US
1973 1973   Unassigned Alabama US 2020-04-01 21:58:49 0.0 0.0 0 0 0 0 Unassigned, Alabama, US
1974 1974   Unassigned Alaska US 2020-04-01 21:58:49 0.0 0.0 0 2 0 0 Unassigned, Alaska, US
1975 1975   Unassigned Arizona US 2020-04-01 21:58:49 0.0 0.0 0 18 0 0 Unassigned, Arizona, US
1977 1977   Unassigned California US 2020-04-01 21:58:49 0.0 0.0 0 1 0 0 Unassigned, California, US
1984 1984   Unassigned Iowa US 2020-04-01 21:58:49 0.0 0.0 0 1 0 0 Unassigned, Iowa, US
1988 1988   Unassigned Maryland US 2020-04-01 21:58:49 0.0 0.0 0 12 0 0 Unassigned, Maryland, US
1991 1991   Unassigned Minnesota US 2020-04-01 21:58:49 0.0 0.0 0 8 0 0 Unassigned, Minnesota, US
1992 1992   Unassigned Missouri US 2020-04-01 21:58:49 0.0 0.0 0 0 0 0 Unassigned, Missouri, US
1995 1995   Unassigned New Hampshire US 2020-04-01 21:58:49 0.0 0.0 0 0 0 0 Unassigned, New Hampshire, US
1997 1997   Unassigned New York US 2020-04-01 21:58:49 0.0 0.0 0 565 0 0 Unassigned, New York, US
1998 1998   Unassigned Oklahoma US 2020-04-01 21:58:49 0.0 0.0 0 1 0 0 Unassigned, Oklahoma, US
2002 2002   Unassigned Virginia US 2020-04-01 21:58:49 0.0 0.0 0 19 0 0 Unassigned,Virginia,US
2004 2004   Unassigned Wisconsin US 2020-04-01 21:58:49 0.0 0.0 0 0 0 0 Unassigned, Wisconsin, US
2235 2235     Diamond Princess Canada 2020-04-01 22:04:44 0.0 0.0 0 1 0 0 Diamond Princess, Canada
2278 2278     Nunavut Canada 2020-04-01 22:04:44 70.2998 -83.1076 0 0 0 0 Nunavut, Canada
2285 2285     Recovered Canada 2020-04-01 22:04:44 0.0 0.0 0 0 1324 0 Recovered, Canada
2286 2286     Recovered US 2020-04-01 21:58:49 0.0 0.0 0 0 8474 0 Recovered, US
2289 2289     Saint Helena, Ascension and Tristan da Cunha United Kingdom 2020-04-01 21:58:34 -7.9467 -14.3559 0 0 0 0 Saint Helena, Ascension and Tristan da Cunha, United Kingdom
2449 2449       Samoa 2020-04-01 22:04:44 -13.759 -172.1046 0 0 0 0 Samoa
5 5 19001 Adair Iowa US 2020-04-01 21:58:49 41.33075609 -94.47105874 1 0 0 0 Adair, Iowa, US
10 10 18001 Adams Indiana US 2020-04-01 21:58:49 40.7457653 -84.93671406 1 0 0 0 Adams, Indiana, US
20 20 8003 Alamosa Colorado US 2020-04-01 21:58:49 37.57250606 -105.7885451 1 0 0 0 Alamosa, Colorado, US
31 31 51005 Alleghany Virginia US 2020-04-01 21:58:49 37.78636074 -80.00222498 1 0 0 0 Alleghany, Virginia, US
37 37 45005 Allendale South Carolina US 2020-04-01 21:58:49 32.98837386 -81.35321066 1 0 0 0 Allendale, South Carolina, US
38 38 6003 Alpine California US 2020-04-01 21:58:49 38.59678594 -119.82235940000001 1 0 0 0 Alpine, California, US
47 47 48001 Anderson Texas US 2020-04-01 21:58:49 31.81534745 -95.65354823 1 0 0 0 Anderson, Texas, US
53 53 37007 Anson North Carolina US 2020-04-01 21:58:49 34.97403241 -80.09953279 1 0 0 0 Anson, North Carolina, US
54 54 31003 Antelope Nebraska US 2020-04-01 21:58:49 42.17695516 -98.06662829999999 1 0 0 0 Antelope, Nebraska, US
57 57 19007 Appanoose Iowa US 2020-04-01 21:58:49 40.74324454 -92.86865906 1 0 0 0 Appanoose, Iowa, US
58 58 13001 Appling Georgia US 2020-04-01 21:58:49 31.74847232 -82.28909114 1 0 0 0 Appling, Georgia, US
61 61 8007 Archuleta Colorado US 2020-04-01 21:58:49 37.19474156 -107.04768670000001 1 0 0 0 Archuleta, Colorado, US
62 62 26011 Arenac Michigan US 2020-04-01 21:58:49 44.0636262 -83.89277559 1 0 0 0 Arenac, Michigan, US
63 63 5001 Arkansas Arkansas US 2020-04-01 21:58:49 34.29145151 -91.37277296 1 0 0 0 Arkansas, Arkansas, US
68 68 55003 Ashland Wisconsin US 2020-04-01 21:58:49 46.31956891 -90.67837132 1 0 0 0 Ashland, Wisconsin, US
69 69 5003 Ashley Arkansas US 2020-04-01 21:58:49 33.19153461 -91.76984709999999 1 0 0 0 Ashley, Arkansas, US
73 73 20005 Atchison Kansas US 2020-04-01 21:58:49 39.53185661 -95.30870026 1 0 0 0 Atchison, Kansas, US
74 74 29005 Atchison Missouri US 2020-04-01 21:58:49 40.43238737 -95.42970639 1 0 0 0 Atchison, Missouri, US
78 78 19009 Audubon Iowa US 2020-04-01 21:58:49 41.6844628 -94.90581859 1 0 0 0 Audubon, Iowa, US
80 80 51015 Augusta Virginia US 2020-04-01 21:58:49 38.16404586 -79.12461614 1 0 0 0 Augusta, Virginia, US
81 81 46003 Aurora South Dakota US 2020-04-01 21:58:49 43.71757685 -98.56050467 1 0 0 0 Aurora, South Dakota, US
96 96 54001 Barbour West Virginia US 2020-04-01 21:58:49 39.1307219 -80.00350858 1 0 0 0 Barbour, West Virginia, US
100 100 21009 Barren Kentucky US 2020-04-01 21:58:49 36.96469836 -85.93338945 1 0 0 0 Barren, Kentucky, US
103 103 29009 Barry Missouri US 2020-04-01 21:58:49 36.70978521 -93.82919888 1 0 0 0 Barry, Missouri, US
105 105 20009 Barton Kansas US 2020-04-01 21:58:49 38.47889676 -98.75636726 1 0 0 0 Barton, Kansas, US
109 109 5005 Baxter Arkansas US 2020-04-01 21:58:49 36.28784385 -92.33782872 1 0 0 0 Baxter, Arkansas, US
118 118 40009 Beckham Oklahoma US 2020-04-01 21:58:49 35.26862449 -99.68128023 1 0 0 0 Beckham, Oklahoma, US
129 129 18007 Benton Indiana US 2020-04-01 21:58:49 40.60626947 -87.31093999 1 0 0 0 Benton, Indiana, US
131 131 27009 Benton Minnesota US 2020-04-01 21:58:49 45.69804958 -93.99514135 1 0 0 0 Benton, Minnesota, US
150 150 27011 Big Stone Minnesota US 2020-04-01 21:58:49 45.42712824 -96.41403739 1 0 0 0 Big Stone, Minnesota, US
155 155 48031 Blanco Texas US 2020-04-01 21:58:49 30.26640707 -98.3999852 1 0 0 0 Blanco, Texas, US
156 156 13023 Bleckley Georgia US 2020-04-01 21:58:49 32.43829035 -83.33035166 1 0 0 0 Bleckley, Georgia, US
162 162 29017 Bollinger Missouri US 2020-04-01 21:58:49 37.32449052 -90.02725304 1 0 0 0 Bollinger, Missouri, US
163 163 46009 Bon Homme South Dakota US 2020-04-01 21:58:49 42.98914167 -97.88592746 1 0 0 0 Bon Homme, South Dakota, US
165 165 16017 Bonner Idaho US 2020-04-01 21:58:49 48.29996017 -116.6017932 1 0 0 0 Bonner, Idaho, US
167 167 5009 Boone Arkansas US 2020-04-01 21:58:49 36.3084504 -93.09374925 1 0 0 0 Boone, Arkansas, US
169 169 19015 Boone Iowa US 2020-04-01 21:58:49 42.03657094 -93.9313999 1 0 0 0 Boone, Iowa, US
181 181 21023 Bracken Kentucky US 2020-04-01 21:58:49 38.69158994 -84.08532444 1 0 0 0 Bracken, Kentucky, US
194 194 51520 Bristol Virginia US 2020-04-01 21:58:49 36.616302399999995 -82.16359122 1 0 0 0 Bristol, Virginia, US
208 208 51025 Brunswick Virginia US 2020-04-01 21:58:49 36.76366949 -77.8593436 1 0 0 0 Brunswick, Virginia, US
210 210 40013 Bryan Oklahoma US 2020-04-01 21:58:49 33.96472458 -96.25903472 1 0 0 0 Bryan, Oklahoma, US
216 216 55011 Buffalo Wisconsin US 2020-04-01 21:58:49 44.37835084 -91.75332578 1 0 0 0 Buffalo, Wisconsin, US
226 226 48051 Burleson Texas US 2020-04-01 21:58:49 30.49273808 -96.62158484 1 0 0 0 Burleson, Texas, US
229 229 1013 Butler Alabama US 2020-04-01 21:58:49 31.75300095 -86.68057478 1 0 0 0 Butler, Alabama, US
230 230 19023 Butler Iowa US 2020-04-01 21:58:49 42.73172833 -92.79015971 1 0 0 0 Butler, Iowa, US
232 232 21031 Butler Kentucky US 2020-04-01 21:58:49 37.20946153 -86.68748787 1 0 0 0 Butler, Kentucky, US
233 233 29023 Butler Missouri US 2020-04-01 21:58:49 36.71462476 -90.40421163 1 0 0 0 Butler, Missouri, US
240 240 54011 Cabell West Virginia US 2020-04-01 21:58:49 38.42424062 -82.23855912 1 0 0 0 Cabell, West Virginia, US
243 243 40015 Caddo Oklahoma US 2020-04-01 21:58:49 35.17364557 -98.37534464 1 0 0 0 Caddo, Oklahoma, US
246 246 29025 Caldwell Missouri US 2020-04-01 21:58:49 39.65620858 -93.98308093 1 0 0 0 Caldwell, Missouri, US
248 248 48055 Caldwell Texas US 2020-04-01 21:58:49 29.83668859 -97.61814775 1 0 0 0 Caldwell, Texas, US
251 251 12013 Calhoun Florida US 2020-04-01 21:58:49 30.40666734 -85.19394153 1 0 0 0 Calhoun, Florida, US
261 261 16025 Camas Idaho US 2020-04-01 21:58:49 43.46665742 -114.8065892 1 0 0 0 Camas, Idaho, US
266 266 42023 Cameron Pennsylvania US 2020-04-01 21:58:49 41.43625568 -78.20376845 1 0 0 0 Cameron, Pennsylvania, US
268 268 48063 Camp Texas US 2020-04-01 21:58:49 32.97195142 -94.97790104 1 0 0 0 Camp, Texas, US
274 274 13043 Candler Georgia US 2020-04-01 21:58:49 32.40209349 -82.07702563 1 0 0 0 Candler, Georgia, US
286 286 19027 Carroll Iowa US 2020-04-01 21:58:49 42.03617207 -94.86032705 1 0 0 0 Carroll, Iowa, US
293 293 51035 Carroll Virginia US 2020-04-01 21:58:49 36.73066666 -80.73455942 1 0 0 0 Carroll, Virginia, US
296 296 40019 Carter Oklahoma US 2020-04-01 21:58:49 34.25103751 -97.28552485 1 0 0 0 Carter, Oklahoma, US
297 297 47019 Carter Tennessee US 2020-04-01 21:58:49 36.28969086 -82.12588974 1 0 0 0 Carter, Tennessee, US
301 301 18017 Cass Indiana US 2020-04-01 21:58:49 40.76135835 -86.34830753 1 0 0 0 Cass, Indiana, US
303 303 27021 Cass Minnesota US 2020-04-01 21:58:49 46.95043611 -94.32603968 1 0 0 0 Cass, Minnesota, US
308 308 16031 Cassia Idaho US 2020-04-01 21:58:49 42.28347888 -113.6012409 1 1 0 0 Cassia, Idaho, US
310 310 37033 Caswell North Carolina US 2020-04-01 21:58:49 36.39312665 -79.33353281 1 0 0 0 Caswell, North Carolina, US
329 329 46023 Charles Mix South Dakota US 2020-04-01 21:58:49 43.20660134 -98.58856175 1 0 0 0 Charles Mix, South Dakota, US
334 334 13049 Charlton Georgia US 2020-04-01 21:58:49 30.78371028 -82.13951596 1 0 0 0 Charlton, Georgia, US
339 339 20019 Chautauqua Kansas US 2020-04-01 21:58:49 37.14994405 -96.2454192 1 0 0 0 Chautauqua, Kansas, US
347 347 1019 Cherokee Alabama US 2020-04-01 21:58:49 34.17805983 -85.60638968 1 0 0 0 Cherokee, Alabama, US

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

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