russia-investigation/russia-investigation: 6

russia-investigation.csv contains every special investigation since the Watergate probe began in 1973 and who was charged in them.

Header	Definition
`investigation`	Unique id for each investigation
`investigation-start`	Start date of the investigation
`investigation-end`	End date of the investigation
`investigation-days`	Length, in days, of the investigation. Days will be negative if the charge occured before the investigation began.
`name`	Name of the person charged (if applicable). Will be blank if there were no charges.
`indictment-days`	Length, in days, from the start of the investigation to the date the person was charged (if applicable). Days will be negative if the charge occured before the investigation began.
`type`	Result of charge (if applicable)
`cp-date`	Date the person pled guilty or was convicted (if applicable)
`cp-days`	Length, in days, from the start of the investigation to the date the person pled guilty or was convicted (if applicable)
`overturned`	Whether or not the relevant person's conviction was overturned
`pardoned`	Whether or not the relevant person's charge was pardoned
`american`	Whether or not the relevant person's charge was a U.S. resident
`president`	President at the center of the investigation

This data as json, copyable

rowid	investigation	investigation-start	investigation-end	investigation-days	name	indictment-days	type	cp-date	cp-days	overturned	pardoned	american	president
6	watergate	1973-05-19	1977-06-19	1492	Frank A. Sturgis	-246	guilty-plea	1973-01-15	-124	0	0	1	Richard Nixon