Russia Investigation: russia-investigation.csv

Table actions

This table contains data behind the story Is The Russia Investigation Really Another Watergate?.

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

Data license: CC Attribution 4.0 License · Data source: fivethirtyeight/data on GitHub · About: simonw/fivethirtyeight-datasette

13 rows where "investigation-start" is on date 1994-09-09

✎ View and edit SQL

This data as json, copyable, CSV (advanced)

Suggested facets: indictment-days , type, cp-date, cp-days, pardoned, investigation-start (date), investigation-end (date), cp-date (date)

Link rowid ▼ investigation investigation-start investigation-end investigation-days name indictment-days type cp-date cp-days overturned pardoned american president
136 136 espy 1994-09-09 2001-01-30 2335 James Lake 409 guilty-plea 1995-10-23 409 0 1 1 Bill Clinton
137 137 espy 1994-09-09 2001-01-30 2335 Brooke Keith Mitchell, Sr 622 guilty-plea 1996-11-13 796 0 1 1 Bill Clinton
138 138 espy 1994-09-09 2001-01-30 2335 Brooke Keith Mitchell, Jr 622 indictment     0 0 1 Bill Clinton
139 139 espy 1994-09-09 2001-01-30 2335 Gary Black 630 indictment     0 0 1 Bill Clinton
140 140 espy 1994-09-09 2001-01-30 2335 Alverez Ferrouillet 670 conviction 1996-12-20 833 0 1 1 Bill Clinton
141 141 espy 1994-09-09 2001-01-30 2335 Henry Espy, Jr. 670 indictment     0 0 1 Bill Clinton
142 142 espy 1994-09-09 2001-01-30 2335 John Hemmingson 698 conviction 1996-12-19 832 0 1 1 Bill Clinton
143 143 espy 1994-09-09 2001-01-30 2335 Jack L. Williams 740 conviction 1998-06-26 1386 0 1 1 Bill Clinton
144 144 espy 1994-09-09 2001-01-30 2335 Richard Douglas 769 guilty-plea 1998-03-16 1284 0 1 1 Bill Clinton
145 145 espy 1994-09-09 2001-01-30 2335 Norris Faust, Jr. 803 indictment     0 0 1 Bill Clinton
146 146 espy 1994-09-09 2001-01-30 2335 Ronald H. Blackley 957 conviction 1997-12-01 1179 0 0 1 Bill Clinton
147 147 espy 1994-09-09 2001-01-30 2335 Mike Espy 1083 indictment     0 0 1 Bill Clinton
148 148 espy 1994-09-09 2001-01-30 2335 Archibald Schaffer 1225 conviction 1998-06-26 1386 0 1 1 Bill Clinton

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

CREATE TABLE "russia-investigation/russia-investigation" (
"investigation" TEXT,
  "investigation-start" TEXT,
  "investigation-end" TEXT,
  "investigation-days" INTEGER,
  "name" TEXT,
  "indictment-days " INTEGER,
  "type" TEXT,
  "cp-date" TEXT,
  "cp-days" INTEGER,
  "overturned" INTEGER,
  "pardoned" INTEGER,
  "american" INTEGER,
  "president" TEXT
);