This folder contains data behind the story 'Is The Russia Investigation Really Another Watergate?' https://projects.fivethirtyeight.com/russia-investigation/
russia_investigationA dataset with 194 rows representing every special investigation since the Watergate probe began in 1973 and 13 variables
Unique id for each investigation
Start date of the investigation
End date of the investigation
Length, in days, of the investigation. Days will be negative if the charge occurred before the investigation began.
Name of the person charged (if applicable). Will be blank if there were no charges.
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 occurred before the investigation began.
Result of charge (if applicable)
Date the person pled guilty or was convicted (if applicable)
Length, in days, from the start of the investigation to the date the person pled guilty or was convicted (if applicable)
Whether or not the relevant person's conviction was overturned
Whether or not the relevant person's charge was pardoned
Whether or not the relevant person's charge was a U.S. resident
President at the center of the investigation