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

15 rows where "investigation-start" is on date 1986-12-19

✎ View and edit SQL

This data as json, copyable, CSV (advanced)

Suggested facets: investigation, investigation-end, investigation-days, indictment-days , type, overturned, 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
79 79 sealed-investigation-reagan 1986-12-19 1987-12-18 364           0 0 1 Ronald Reagan
80 80 iran-contra 1986-12-19 1993-08-03 2419 Carl R. Channell 131 guilty-plea 1987-04-29 131 0 0 1 Ronald Reagan
81 81 iran-contra 1986-12-19 1993-08-03 2419 Richard Miller 138 guilty-plea 1987-05-06 138 0 0 1 Ronald Reagan
82 82 iran-contra 1986-12-19 1993-08-03 2419 Robert McFarlane 448 guilty-plea 1988-03-11 448 0 1 1 Ronald Reagan
83 83 iran-contra 1986-12-19 1993-08-03 2419 Oliver North 453 conviction 1989-05-04 867 1 0 1 Ronald Reagan
84 84 iran-contra 1986-12-19 1993-08-03 2419 John Poindexter 453 conviction 1990-04-07 1205 1 0 1 Ronald Reagan
85 85 iran-contra 1986-12-19 1993-08-03 2419 Richard Secord 453 guilty-plea 1989-11-08 1055 0 0 1 Ronald Reagan
86 86 iran-contra 1986-12-19 1993-08-03 2419 Albert Hakim 453 guilty-plea 1989-11-21 1068 0 0 1 Ronald Reagan
87 87 iran-contra 1986-12-19 1993-08-03 2419 Joseph Fernandez 549 indictment     0 0 1 Ronald Reagan
88 88 iran-contra 1986-12-19 1993-08-03 2419 Thomas G. Clines 1161 conviction 1990-09-18 1369 0 0 1 Ronald Reagan
89 89 iran-contra 1986-12-19 1993-08-03 2419 Alan G. Fiers 1663 guilty-plea 1991-07-10 1664 0 1 1 Ronald Reagan
90 90 iran-contra 1986-12-19 1993-08-03 2419 Clair E. George 1722 conviction 1992-12-10 2183 0 1 1 Ronald Reagan
91 91 iran-contra 1986-12-19 1993-08-03 2419 Elliott Abrams 1753 guilty-plea 1991-10-07 1753 0 1 1 Ronald Reagan
92 92 iran-contra 1986-12-19 1993-08-03 2419 Duane Clarridge 1803 indictment     0 1 1 Ronald Reagan
93 93 iran-contra 1986-12-19 1993-08-03 2419 Caspar Weinberger 2006 indictment     0 1 1 Ronald Reagan

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
);