04-02-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,572 rows sorted by Confirmed

✎ View and edit SQL

This data as json, copyable, CSV (advanced)

Link rowid FIPS Admin2 Province_State Country_Region Last_Update Lat Long_ Confirmed ▼ Deaths Recovered Active Combined_Key
52 52 48003 Andrews Texas US 4/2/20 23:25 32.30468633 -102.6376548 0 0 0 0 Andrews, Texas, US
63 63 48007 Aransas Texas US 4/2/20 23:25 28.10556197 -96.9995047 0 0 0 0 Aransas, Texas, US
134 134 18007 Benton Indiana US 4/2/20 23:25 40.60626947 -87.31093999 0 0 0 0 Benton, Indiana, US
245 245 46019 Butte South Dakota US 4/2/20 23:25 44.90608745 -103.5079318 0 0 0 0 Butte, South Dakota, US
474 474 1035 Conecuh Alabama US 4/2/20 23:25 31.43401703 -86.99320044 0 0 0 0 Conecuh, Alabama, US
566 566 47039 Decatur Tennessee US 4/2/20 23:25 35.60048904 -88.11043779 0 0 0 0 Decatur, Tennessee, US
663 663 51600 Fairfax City Virginia US 4/2/20 23:25 38.85157547 -77.2977964 0 0 0 0 Fairfax City, Virginia, US
697 697 20057 Ford Kansas US 4/2/20 23:25 37.69200114 -99.88825298 0 0 0 0 Ford, Kansas, US
1006 1006 13161 Jeff Davis Georgia US 4/2/20 23:25 31.80405727 -82.6372487 0 0 0 0 Jeff Davis, Georgia, US
1087 1087 46077 Kingsbury South Dakota US 4/2/20 23:25 44.36956169 -97.4913945 0 0 0 0 Kingsbury, South Dakota, US
1370 1370 38057 Mercer North Dakota US 4/2/20 23:25 47.31213126 -101.8318399 0 0 0 0 Mercer, North Dakota, US
1578 1578 80008 Out of CO Colorado US 4/2/20 23:25     0 1 0 0 Out of CO,Colorado,US
1730 1730 47143 Rhea Tennessee US 4/2/20 23:25 35.60536161 -84.93076643 0 0 0 0 Rhea, Tennessee, US
1763 1763 38079 Rolette North Dakota US 4/2/20 23:25 48.77245354 -99.84097493 0 0 0 0 Rolette, North Dakota, US
1822 1822 26153 Schoolcraft Michigan US 4/2/20 23:25 46.19235734 -86.19972234 0 0 0 0 Schoolcraft, Michigan, US
2038 2038 48457 Tyler Texas US 4/2/20 23:25 30.77031716 -94.37690895 0 0 0 0 Tyler, Texas, US
2043 2043 90001 Unassigned Alabama US 4/2/20 23:25     0 5 0 0 Unassigned, Alabama, US
2044 2044 90002 Unassigned Alaska US 4/2/20 23:25     0 2 0 0 Unassigned, Alaska, US
2045 2045 90004 Unassigned Arizona US 4/2/20 23:25     0 3 0 0 Unassigned, Arizona, US
2047 2047 90006 Unassigned California US 4/2/20 23:25     0 0 0 0 Unassigned, California, US
2050 2050 90010 Unassigned Delaware US 4/2/20 23:25     0 16 0 0 Unassigned, Delaware, US
2056 2056 90019 Unassigned Iowa US 4/2/20 23:25     0 1 0 0 Unassigned, Iowa, US
2060 2060 90024 Unassigned Maryland US 4/2/20 23:25     0 0 0 0 Unassigned, Maryland, US
2063 2063 90027 Unassigned Minnesota US 4/2/20 23:25     0 8 0 0 Unassigned, Minnesota, US
2064 2064 90029 Unassigned Missouri US 4/2/20 23:25     0 0 0 0 Unassigned, Missouri, US
2065 2065 90030 Unassigned Montana US 4/2/20 23:25     0 0 0 0 Unassigned, Montana, US
2068 2068 90033 Unassigned New Hampshire US 4/2/20 23:25     0 2 0 0 Unassigned, New Hampshire, US
2071 2071 90036 Unassigned New York US 4/2/20 23:25     0 675 0 0 Unassigned, New York, US
2072 2072 90038 Unassigned North Dakota US 4/2/20 23:25     0 0 0 0 Unassigned, North Dakota, US
2073 2073 90040 Unassigned Oklahoma US 4/2/20 23:25     0 0 0 0 Unassigned, Oklahoma, US
2075 2075 90046 Unassigned South Dakota US 4/2/20 23:25     0 0 0 0 Unassigned, South Dakota, US
2078 2078 90051 Unassigned Virginia US 4/2/20 23:25     0 26 0 0 Unassigned,Virginia,US
2080 2080 90054 Unassigned West Virginia US 4/2/20 23:25     0 1 0 0 Unassigned, West Virginia, US
2081 2081 90055 Unassigned Wisconsin US 4/2/20 23:25     0 5 0 0 Unassigned, Wisconsin, US
2319 2319     Diamond Princess Canada 4/2/20 23:31     0 1 0 0 Diamond Princess, Canada
2362 2362     Nunavut Canada 4/2/20 23:31 70.2998 -83.1076 0 0 0 0 Nunavut, Canada
2369 2369     Recovered Canada 4/2/20 23:31     0 0 1735 0 Recovered, Canada
2370 2370     Recovered US 4/2/20 23:25     0 0 9001 0 Recovered, US
2373 2373     Saint Helena, Ascension and Tristan da Cunha United Kingdom 4/2/20 23:25 -7.9467 -14.3559 0 0 0 0 Saint Helena, Ascension and Tristan da Cunha, United Kingdom
2534 2534       Samoa 4/2/20 23:31 -13.759 -172.1046 0 0 0 0 Samoa
2572 2572   unassigned Wyoming US 4/2/20 23:25     0 0 0 0 unassigned, Wyoming, US
5 5 19001 Adair Iowa US 4/2/20 23:25 41.33075609 -94.47105874 1 0 0 0 Adair, Iowa, US
9 9 16003 Adams Idaho US 4/2/20 23:25 44.89333571 -116.4545247 1 0 0 0 Adams,Idaho,US
11 11 18001 Adams Indiana US 4/2/20 23:25 40.7457653 -84.93671406 1 0 0 0 Adams, Indiana, US
16 16 55001 Adams Wisconsin US 4/2/20 23:25 43.96974651 -89.76782777 1 0 0 0 Adams, Wisconsin, US
31 31 24001 Allegany Maryland US 4/2/20 23:25 39.62357628 -78.69280486 1 0 0 0 Allegany, Maryland, US
40 40 45005 Allendale South Carolina US 4/2/20 23:25 32.98837386 -81.35321066 1 0 0 0 Allendale, South Carolina, US
41 41 6003 Alpine California US 4/2/20 23:25 38.59678594 -119.8223594 1 0 0 0 Alpine, California, US
47 47 20003 Anderson Kansas US 4/2/20 23:25 38.21413251 -95.29272815 1 0 0 0 Anderson, Kansas, US
51 51 48001 Anderson Texas US 4/2/20 23:25 31.81534745 -95.65354823 1 0 0 0 Anderson, Texas, US
57 57 37007 Anson North Carolina US 4/2/20 23:25 34.97403241 -80.09953279 1 0 0 0 Anson, North Carolina, US
58 58 31003 Antelope Nebraska US 4/2/20 23:25 42.17695516 -98.0666283 1 0 0 0 Antelope, Nebraska, US
61 61 19007 Appanoose Iowa US 4/2/20 23:25 40.74324454 -92.86865906 1 0 0 0 Appanoose, Iowa, US
65 65 8007 Archuleta Colorado US 4/2/20 23:25 37.19474156 -107.0476867 1 0 0 0 Archuleta, Colorado, US
66 66 26011 Arenac Michigan US 4/2/20 23:25 44.0636262 -83.89277559 1 0 0 0 Arenac, Michigan, US
67 67 5001 Arkansas Arkansas US 4/2/20 23:25 34.29145151 -91.37277296 1 0 0 0 Arkansas, Arkansas, US
72 72 55003 Ashland Wisconsin US 4/2/20 23:25 46.31956891 -90.67837132 1 0 0 0 Ashland, Wisconsin, US
73 73 5003 Ashley Arkansas US 4/2/20 23:25 33.19153461 -91.7698471 1 0 0 0 Ashley, Arkansas, US
77 77 20005 Atchison Kansas US 4/2/20 23:25 39.53185661 -95.30870026 1 0 0 0 Atchison, Kansas, US
78 78 29005 Atchison Missouri US 4/2/20 23:25 40.43238737 -95.42970639 1 0 0 0 Atchison, Missouri, US
81 81 40005 Atoka Oklahoma US 4/2/20 23:25 34.37366573 -96.03802487 1 0 0 0 Atoka, Oklahoma, US
83 83 19009 Audubon Iowa US 4/2/20 23:25 41.6844628 -94.90581859 1 0 0 0 Audubon, Iowa, US
86 86 46003 Aurora South Dakota US 4/2/20 23:25 43.71757685 -98.56050467 1 0 0 0 Aurora, South Dakota, US
101 101 54001 Barbour West Virginia US 4/2/20 23:25 39.1307219 -80.00350858 1 0 0 0 Barbour, West Virginia, US
105 105 21009 Barren Kentucky US 4/2/20 23:25 36.96469836 -85.93338945 1 0 0 0 Barren, Kentucky, US
108 108 29009 Barry Missouri US 4/2/20 23:25 36.70978521 -93.82919888 1 0 0 0 Barry, Missouri, US
114 114 5005 Baxter Arkansas US 4/2/20 23:25 36.28784385 -92.33782872 1 0 0 0 Baxter, Arkansas, US
123 123 40009 Beckham Oklahoma US 4/2/20 23:25 35.26862449 -99.68128023 1 0 0 0 Beckham, Oklahoma, US
136 136 27009 Benton Minnesota US 4/2/20 23:25 45.69804958 -93.99514135 1 0 0 0 Benton, Minnesota, US
155 155 27011 Big Stone Minnesota US 4/2/20 23:25 45.42712824 -96.41403739 1 0 0 0 Big Stone, Minnesota, US
158 158 18009 Blackford Indiana US 4/2/20 23:25 40.47388153 -85.32499702 1 0 0 0 Blackford, Indiana, US
159 159 37017 Bladen North Carolina US 4/2/20 23:25 34.61296243 -78.56180059 1 0 0 0 Bladen, North Carolina, US
162 162 48031 Blanco Texas US 4/2/20 23:25 30.26640707 -98.3999852 1 0 0 0 Blanco, Texas, US
163 163 13023 Bleckley Georgia US 4/2/20 23:25 32.43829035 -83.33035166 1 0 0 0 Bleckley, Georgia, US
169 169 29017 Bollinger Missouri US 4/2/20 23:25 37.32449052 -90.02725304 1 0 0 0 Bollinger, Missouri, US
170 170 46009 Bon Homme South Dakota US 4/2/20 23:25 42.98914167 -97.88592746 1 0 0 0 Bon Homme, South Dakota, US
172 172 16017 Bonner Idaho US 4/2/20 23:25 48.29996017 -116.6017932 1 0 0 0 Bonner, Idaho, US
174 174 5009 Boone Arkansas US 4/2/20 23:25 36.3084504 -93.09374925 1 0 0 0 Boone, Arkansas, US
188 188 21023 Bracken Kentucky US 4/2/20 23:25 38.69158994 -84.08532444 1 0 0 0 Bracken, Kentucky, US
198 198 19017 Bremer Iowa US 4/2/20 23:25 42.77461496 -92.31795937 1 0 0 0 Bremer, Iowa, US
202 202 51520 Bristol Virginia US 4/2/20 23:25 36.6163024 -82.16359122 1 0 0 0 Bristol, Virginia, US
216 216 51025 Brunswick Virginia US 4/2/20 23:25 36.76366949 -77.8593436 1 0 0 0 Brunswick, Virginia, US
234 234 48051 Burleson Texas US 4/2/20 23:25 30.49273808 -96.62158484 1 0 0 0 Burleson, Texas, US
237 237 1013 Butler Alabama US 4/2/20 23:25 31.75300095 -86.68057478 1 0 0 0 Butler, Alabama, US
238 238 19023 Butler Iowa US 4/2/20 23:25 42.73172833 -92.79015971 1 0 0 0 Butler, Iowa, US
240 240 21031 Butler Kentucky US 4/2/20 23:25 37.20946153 -86.68748787 1 0 0 0 Butler, Kentucky, US
241 241 29023 Butler Missouri US 4/2/20 23:25 36.71462476 -90.40421163 1 0 0 0 Butler, Missouri, US
254 254 29025 Caldwell Missouri US 4/2/20 23:25 39.65620858 -93.98308093 1 0 0 0 Caldwell, Missouri, US
256 256 48055 Caldwell Texas US 4/2/20 23:25 29.83668859 -97.61814775 1 0 0 0 Caldwell, Texas, US
259 259 12013 Calhoun Florida US 4/2/20 23:25 30.40666734 -85.19394153 1 0 0 0 Calhoun, Florida, US
269 269 16025 Camas Idaho US 4/2/20 23:25 43.46665742 -114.8065892 1 0 0 0 Camas, Idaho, US
274 274 42023 Cameron Pennsylvania US 4/2/20 23:25 41.43625568 -78.20376845 1 0 0 0 Cameron, Pennsylvania, US
276 276 48063 Camp Texas US 4/2/20 23:25 32.97195142 -94.97790104 1 0 0 0 Camp, Texas, US
282 282 13043 Candler Georgia US 4/2/20 23:25 32.40209349 -82.07702563 1 0 0 0 Candler, Georgia, US
287 287 30009 Carbon Montana US 4/2/20 23:25 45.22850116 -109.0274047 1 0 0 0 Carbon, Montana, US
292 292 5015 Carroll Arkansas US 4/2/20 23:25 36.3403856 -93.54270261 1 0 0 0 Carroll, Arkansas, US
296 296 19027 Carroll Iowa US 4/2/20 23:25 42.03617207 -94.86032705 1 0 0 0 Carroll, Iowa, US
303 303 51035 Carroll Virginia US 4/2/20 23:25 36.73066666 -80.73455942 1 0 0 0 Carroll, Virginia, US
306 306 40019 Carter Oklahoma US 4/2/20 23:25 34.25103751 -97.28552485 1 0 0 0 Carter, Oklahoma, US
307 307 47019 Carter Tennessee US 4/2/20 23:25 36.28969086 -82.12588974 1 0 0 0 Carter, Tennessee, US

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

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