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

18 rows where "investigation-start" is on date 1990-03-01

✎ View and edit SQL

This data as json, copyable, CSV (advanced)

Suggested facets: indictment-days , type, cp-date, cp-days, 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
96 96 pierce 1990-03-01 1998-10-27 3162 Leonard Briscoe 468 conviction 1993-01-05 1041 0 0 1 George H.W. Bush
97 97 pierce 1990-03-01 1998-10-27 3162 Maurice Steier 468 conviction 1993-01-05 1041 0 0 1 George H.W. Bush
98 98 pierce 1990-03-01 1998-10-27 3162 Samuel P. Singletary 651 guilty-plea 1992-02-20 721 0 0 1 George H.W. Bush
99 99 pierce 1990-03-01 1998-10-27 3162 Lance H. Wilson 684 conviction 1993-01-05 1041 1 0 1 George H.W. Bush
100 100 pierce 1990-03-01 1998-10-27 3162 Victor R. Cruse 754 indictment     0 0 1 George H.W. Bush
101 101 pierce 1990-03-01 1998-10-27 3162 Deborah Gore Dean 789 conviction 1993-10-26 1335 0 0 1 George H.W. Bush
102 102 pierce 1990-03-01 1998-10-27 3162 Thomas Demery 831 guilty-plea 1993-06-17 1204 0 0 1 George H.W. Bush
103 103 pierce 1990-03-01 1998-10-27 3162 Phillip McCafferty 831 indictment     0 0 1 George H.W. Bush
104 104 pierce 1990-03-01 1998-10-27 3162 Elaine Richardson 903 guilty-plea 1992-11-20 995 0 0 1 George H.W. Bush
105 105 pierce 1990-03-01 1998-10-27 3162 Silvio J. DeBartolomeis 959 guilty-plea 1992-10-15 959 0 0 1 George H.W. Bush
106 106 pierce 1990-03-01 1998-10-27 3162 Philip D. Winn 1076 guilty-plea 1993-02-09 1076 0 1 1 George H.W. Bush
107 107 pierce 1990-03-01 1998-10-27 3162 Robert B. Olsen 1167 guilty-plea 1993-05-12 1168 0 0 1 George H.W. Bush
108 108 pierce 1990-03-01 1998-10-27 3162 Joseph A. Straus 1245 guilty-plea 1994-04-15 1506 0 0 1 George H.W. Bush
109 109 pierce 1990-03-01 1998-10-27 3162 J. Michael Queenan 1336 conviction 1994-06-23 1575 0 0 1 George H.W. Bush
110 110 pierce 1990-03-01 1998-10-27 3162 Ronald L. Mahon 1336 conviction 1994-06-23 1575 0 0 1 George H.W. Bush
111 111 pierce 1990-03-01 1998-10-27 3162 Carlos A. Figueroa 1357 guilty-plea 1994-08-14 1627 0 0 1 George H.W. Bush
112 112 pierce 1990-03-01 1998-10-27 3162 Catalina Vasquez Villalpando 1449 guilty-plea 1994-02-17 1449 0 0 1 George H.W. Bush
113 113 pierce 1990-03-01 1998-10-27 3162 James G. Watt 1819 guilty-plea 1996-01-02 2133 0 0 1 George H.W. Bush

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