03-31-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,437 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
46 46 48003 Andrews Texas US 2020-03-31 23:43:56 32.30468633 -102.63765479999999 0 0 0 0 Andrews, Texas, US
57 57 48007 Aransas Texas US 2020-03-31 23:43:56 28.10556197 -96.9995047 0 0 0 0 Aransas, Texas, US
230 230 46019 Butte South Dakota US 2020-03-31 23:43:56 44.90608745 -103.5079318 0 0 0 0 Butte, South Dakota, US
529 529 47039 Decatur Tennessee US 2020-03-31 23:43:56 35.60048904 -88.11043779 0 0 0 0 Decatur, Tennessee, US
546 546 26043 Dickinson Michigan US 2020-03-31 23:43:56 46.00999672 -87.86961634 0 0 0 0 Dickinson, Michigan, US
614 614 1053 Escambia Alabama US 2020-03-31 23:43:56 31.1256789 -87.15918694 0 0 0 0 Escambia, Alabama, US
943 943 13161 Jeff Davis Georgia US 2020-03-31 23:43:56 31.80405727 -82.63724870000001 0 0 0 0 Jeff Davis, Georgia, US
1282 1282 38057 Mercer North Dakota US 2020-03-31 23:43:56 47.31213126 -101.8318399 0 0 0 0 Mercer, North Dakota, US
1927 1927   Unassigned Alabama US 2020-03-31 23:43:56 0.0 0.0 0 8 0 0 Unassigned, Alabama, US
1928 1928   Unassigned Alaska US 2020-03-31 23:43:56 0.0 0.0 0 2 0 0 Unassigned, Alaska, US
1929 1929   Unassigned Arizona US 2020-03-31 23:43:56 0.0 0.0 0 13 0 0 Unassigned, Arizona, US
1931 1931   Unassigned California US 2020-03-31 23:43:56 0.0 0.0 0 0 0 0 Unassigned, California, US
1934 1934   Unassigned Delaware US 2020-03-31 23:43:56 0.0 0.0 0 3 0 0 Unassigned, Delaware, US
1945 1945   Unassigned Minnesota US 2020-03-31 23:43:56 0.0 0.0 0 3 0 0 Unassigned, Minnesota, US
1946 1946   Unassigned Missouri US 2020-03-31 23:43:56 0.0 0.0 0 0 0 0 Unassigned, Missouri, US
1949 1949   Unassigned New Hampshire US 2020-03-31 23:43:56 0.0 0.0 0 0 0 0 Unassigned, New Hampshire, US
1951 1951   Unassigned New York US 2020-03-31 23:43:56 0.0 0.0 0 468 0 0 Unassigned, New York, US
1955 1955   Unassigned Virginia US 2020-03-31 23:43:56 0.0 0.0 0 12 0 0 Unassigned,Virginia,US
1957 1957   Unassigned Wisconsin US 2020-03-31 23:43:56 0.0 0.0 0 0 0 0 Unassigned, Wisconsin, US
2186 2186     Diamond Princess Canada 2020-03-31 23:49:13 0.0 0.0 0 1 0 0 Diamond Princess, Canada
2229 2229     Nunavut Canada 2020-03-31 23:49:13 70.2998 -83.1076 0 0 0 0 Nunavut, Canada
2236 2236     Recovered Canada 2020-03-31 23:49:13 0.0 0.0 0 0 1592 0 Recovered, Canada
2237 2237     Recovered US 2020-03-31 23:43:56 0.0 0.0 0 0 7024 0 Recovered, US
2240 2240     Saint Helena, Ascension and Tristan da Cunha United Kingdom 2020-03-31 23:43:43 -7.9467 -14.3559 0 0 0 0 Saint Helena, Ascension and Tristan da Cunha, United Kingdom
2400 2400       Samoa 2020-03-31 23:49:13 -13.759 -172.1046 0 0 0 0 Samoa
5 5 19001 Adair Iowa US 2020-03-31 23:43:56 41.33075609 -94.47105874 1 0 0 0 Adair, Iowa, US
10 10 18001 Adams Indiana US 2020-03-31 23:43:56 40.7457653 -84.93671406 1 0 0 0 Adams, Indiana, US
20 20 8003 Alamosa Colorado US 2020-03-31 23:43:56 37.57250606 -105.7885451 1 0 0 0 Alamosa, Colorado, US
22 22 56001 Albany Wyoming US 2020-03-31 23:43:56 41.65498705 -105.72354150000001 1 0 0 0 Albany, Wyoming, US
31 31 51005 Alleghany Virginia US 2020-03-31 23:43:56 37.78636074 -80.00222498 1 0 0 0 Alleghany, Virginia, US
45 45 48001 Anderson Texas US 2020-03-31 23:43:56 31.81534745 -95.65354823 1 0 0 0 Anderson, Texas, US
51 51 37007 Anson North Carolina US 2020-03-31 23:43:56 34.97403241 -80.09953279 1 0 0 0 Anson, North Carolina, US
52 52 31003 Antelope Nebraska US 2020-03-31 23:43:56 42.17695516 -98.06662829999999 1 0 0 0 Antelope, Nebraska, US
55 55 19007 Appanoose Iowa US 2020-03-31 23:43:56 40.74324454 -92.86865906 1 0 0 0 Appanoose, Iowa, US
59 59 8007 Archuleta Colorado US 2020-03-31 23:43:56 37.19474156 -107.04768670000001 1 0 0 0 Archuleta, Colorado, US
60 60 26011 Arenac Michigan US 2020-03-31 23:43:56 44.0636262 -83.89277559 1 0 0 0 Arenac, Michigan, US
61 61 5001 Arkansas Arkansas US 2020-03-31 23:43:56 34.29145151 -91.37277296 1 0 0 0 Arkansas, Arkansas, US
66 66 55003 Ashland Wisconsin US 2020-03-31 23:43:56 46.31956891 -90.67837132 1 0 0 0 Ashland, Wisconsin, US
67 67 5003 Ashley Arkansas US 2020-03-31 23:43:56 33.19153461 -91.76984709999999 1 0 0 0 Ashley, Arkansas, US
71 71 20005 Atchison Kansas US 2020-03-31 23:43:56 39.53185661 -95.30870026 1 0 0 0 Atchison, Kansas, US
72 72 29005 Atchison Missouri US 2020-03-31 23:43:56 40.43238737 -95.42970639 1 0 0 0 Atchison, Missouri, US
76 76 19009 Audubon Iowa US 2020-03-31 23:43:56 41.6844628 -94.90581859 1 0 0 0 Audubon, Iowa, US
78 78 46003 Aurora South Dakota US 2020-03-31 23:43:56 43.71757685 -98.56050467 1 0 0 0 Aurora, South Dakota, US
95 95 45011 Barnwell South Carolina US 2020-03-31 23:43:56 33.26679302 -81.43584352 1 0 0 0 Barnwell, South Carolina, US
96 96 21009 Barren Kentucky US 2020-03-31 23:43:56 36.96469836 -85.93338945 1 0 0 0 Barren, Kentucky, US
99 99 29009 Barry Missouri US 2020-03-31 23:43:56 36.70978521 -93.82919888 1 0 0 0 Barry, Missouri, US
101 101 20009 Barton Kansas US 2020-03-31 23:43:56 38.47889676 -98.75636726 1 0 0 0 Barton, Kansas, US
104 104 29013 Bates Missouri US 2020-03-31 23:43:56 38.25271289 -94.34113157 1 0 0 0 Bates, Missouri, US
105 105 5005 Baxter Arkansas US 2020-03-31 23:43:56 36.28784385 -92.33782872 1 0 0 0 Baxter, Arkansas, US
114 114 40009 Beckham Oklahoma US 2020-03-31 23:43:56 35.26862449 -99.68128023 1 0 0 0 Beckham, Oklahoma, US
126 126 27009 Benton Minnesota US 2020-03-31 23:43:56 45.69804958 -93.99514135 1 0 0 0 Benton, Minnesota, US
138 138 13019 Berrien Georgia US 2020-03-31 23:43:56 31.27590016 -83.22529920000002 1 0 0 0 Berrien, Georgia, US
145 145 27011 Big Stone Minnesota US 2020-03-31 23:43:56 45.42712824 -96.41403739 1 0 0 0 Big Stone, Minnesota, US
150 150 48031 Blanco Texas US 2020-03-31 23:43:56 30.26640707 -98.3999852 1 0 0 0 Blanco, Texas, US
151 151 13023 Bleckley Georgia US 2020-03-31 23:43:56 32.43829035 -83.33035166 1 0 0 0 Bleckley, Georgia, US
157 157 29017 Bollinger Missouri US 2020-03-31 23:43:56 37.32449052 -90.02725304 1 0 0 0 Bollinger, Missouri, US
158 158 46009 Bon Homme South Dakota US 2020-03-31 23:43:56 42.98914167 -97.88592746 1 0 0 0 Bon Homme, South Dakota, US
160 160 16017 Bonner Idaho US 2020-03-31 23:43:56 48.29996017 -116.6017932 1 0 0 0 Bonner, Idaho, US
162 162 5009 Boone Arkansas US 2020-03-31 23:43:56 36.3084504 -93.09374925 1 0 0 0 Boone, Arkansas, US
164 164 19015 Boone Iowa US 2020-03-31 23:43:56 42.03657094 -93.9313999 1 0 0 0 Boone, Iowa, US
176 176 21023 Bracken Kentucky US 2020-03-31 23:43:56 38.69158994 -84.08532444 1 0 0 0 Bracken, Kentucky, US
189 189 51520 Bristol Virginia US 2020-03-31 23:43:56 36.616302399999995 -82.16359122 1 0 0 0 Bristol, Virginia, US
191 191 46011 Brookings South Dakota US 2020-03-31 23:43:56 44.36974375 -96.79079945 1 0 0 0 Brookings, South Dakota, US
203 203 51025 Brunswick Virginia US 2020-03-31 23:43:56 36.76366949 -77.8593436 1 0 0 0 Brunswick, Virginia, US
205 205 40013 Bryan Oklahoma US 2020-03-31 23:43:56 33.96472458 -96.25903472 1 0 0 0 Bryan, Oklahoma, US
211 211 55011 Buffalo Wisconsin US 2020-03-31 23:43:56 44.37835084 -91.75332578 1 0 0 0 Buffalo, Wisconsin, US
216 216 17011 Bureau Illinois US 2020-03-31 23:43:56 41.40385234 -89.5283051 1 0 0 0 Bureau, Illinois, US
220 220 48051 Burleson Texas US 2020-03-31 23:43:56 30.49273808 -96.62158484 1 0 0 0 Burleson, Texas, US
223 223 1013 Butler Alabama US 2020-03-31 23:43:56 31.75300095 -86.68057478 1 0 0 0 Butler, Alabama, US
224 224 19023 Butler Iowa US 2020-03-31 23:43:56 42.73172833 -92.79015971 1 0 0 0 Butler, Iowa, US
226 226 21031 Butler Kentucky US 2020-03-31 23:43:56 37.20946153 -86.68748787 1 0 0 0 Butler, Kentucky, US
233 233 54011 Cabell West Virginia US 2020-03-31 23:43:56 38.42424062 -82.23855912 1 0 0 0 Cabell, West Virginia, US
236 236 40015 Caddo Oklahoma US 2020-03-31 23:43:56 35.17364557 -98.37534464 1 0 0 0 Caddo, Oklahoma, US
240 240 48055 Caldwell Texas US 2020-03-31 23:43:56 29.83668859 -97.61814775 1 0 0 0 Caldwell, Texas, US
243 243 12013 Calhoun Florida US 2020-03-31 23:43:56 30.40666734 -85.19394153 1 0 0 0 Calhoun, Florida, US
251 251 55015 Calumet Wisconsin US 2020-03-31 23:43:56 44.0816316 -88.21780273 1 0 0 0 Calumet, Wisconsin, US
253 253 16025 Camas Idaho US 2020-03-31 23:43:56 43.46665742 -114.8065892 1 0 0 0 Camas, Idaho, US
258 258 42023 Cameron Pennsylvania US 2020-03-31 23:43:56 41.43625568 -78.20376845 1 0 0 0 Cameron, Pennsylvania, US
262 262 51031 Campbell Virginia US 2020-03-31 23:43:56 37.20553386 -79.09678609 1 0 0 0 Campbell, Virginia, US
265 265 13043 Candler Georgia US 2020-03-31 23:43:56 32.40209349 -82.07702563 1 0 0 0 Candler, Georgia, US
272 272 27017 Carlton Minnesota US 2020-03-31 23:43:56 46.59180601 -92.67601019 1 0 0 0 Carlton, Minnesota, US
277 277 19027 Carroll Iowa US 2020-03-31 23:43:56 42.03617207 -94.86032705 1 0 0 0 Carroll, Iowa, US
280 280 28015 Carroll Mississippi US 2020-03-31 23:43:56 33.44834567 -89.91994479 1 0 0 0 Carroll, Mississippi, US
284 284 51035 Carroll Virginia US 2020-03-31 23:43:56 36.73066666 -80.73455942 1 0 0 0 Carroll, Virginia, US
287 287 40019 Carter Oklahoma US 2020-03-31 23:43:56 34.25103751 -97.28552485 1 0 0 0 Carter, Oklahoma, US
288 288 47019 Carter Tennessee US 2020-03-31 23:43:56 36.28969086 -82.12588974 1 0 0 0 Carter, Tennessee, US
292 292 18017 Cass Indiana US 2020-03-31 23:43:56 40.76135835 -86.34830753 1 0 0 0 Cass, Indiana, US
294 294 27021 Cass Minnesota US 2020-03-31 23:43:56 46.95043611 -94.32603968 1 0 0 0 Cass, Minnesota, US
299 299 16031 Cassia Idaho US 2020-03-31 23:43:56 42.28347888 -113.6012409 1 0 0 0 Cassia, Idaho, US
301 301 37033 Caswell North Carolina US 2020-03-31 23:43:56 36.39312665 -79.33353281 1 0 0 0 Caswell, North Carolina, US
319 319 51036 Charles City Virginia US 2020-03-31 23:43:56 37.35358063 -77.05634116 1 0 0 0 Charles City, Virginia, US
320 320 46023 Charles Mix South Dakota US 2020-03-31 23:43:56 43.20660134 -98.58856175 1 0 0 0 Charles Mix, South Dakota, US
325 325 13049 Charlton Georgia US 2020-03-31 23:43:56 30.78371028 -82.13951596 1 0 0 0 Charlton, Georgia, US
328 328 13053 Chattahoochee Georgia US 2020-03-31 23:43:56 32.34341231 -84.78809239 1 0 0 0 Chattahoochee, Georgia, US
330 330 20019 Chautauqua Kansas US 2020-03-31 23:43:56 37.14994405 -96.2454192 1 0 0 0 Chautauqua, Kansas, US
334 334 26031 Cheboygan Michigan US 2020-03-31 23:43:56 45.44787015 -84.50122149 1 0 0 0 Cheboygan, Michigan, US
338 338 1019 Cherokee Alabama US 2020-03-31 23:43:56 34.17805983 -85.60638968 1 0 0 0 Cherokee, Alabama, US
352 352 5017 Chicot Arkansas US 2020-03-31 23:43:56 33.26458973 -91.29539209 1 0 0 0 Chicot, Arkansas, US
354 354 26033 Chippewa Michigan US 2020-03-31 23:43:56 46.29552653 -84.54353449 1 0 0 0 Chippewa, Michigan, US
360 360 40023 Choctaw Oklahoma US 2020-03-31 23:43:56 34.02807439 -95.54771129 1 0 0 0 Choctaw, Oklahoma, US

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

CREATE TABLE [03-31-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
);