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

194 rows sorted by name

View and edit SQL

Suggested facets: investigation, investigation-start, investigation-end, investigation-days, type, overturned, pardoned, american, president, 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
73 hamilton-jordan 1979-11-29 1980-05-28 181           0 0 1 Jimmy Carter
74 tim-kraft 1980-09-09 1982-01-15 493           0 0 1 Jimmy Carter
75 raymond-donovan 1981-12-29 1982-06-25 178           0 0 1 Ronald Reagan
76 edwin-meese 1984-04-02 1984-09-20 171           0 0 1 Ronald Reagan
77 ted-olson 1986-04-23 1989-03-14 1056           0 0 1 Ronald Reagan
79 sealed-investigation-reagan 1986-12-19 1987-12-18 364           0 0 1 Ronald Reagan
95 sealed-investigation-hwbush-1 1991-04-19 1992-07-15 453           0 0 1 George H.W. Bush
114 sealed-investigation-hwbush-2 1991-04-19 1992-07-15 453           0 0 1 George H.W. Bush
115 bush-clinton-passport 1992-12-14 1995-11-30 1081           0 0 1 Bill Clinton
155 ron-brown 1995-07-06 1996-11-14 497           0 0 1 Bill Clinton
156 eli-segal 1996-11-27 1997-08-21 267           0 0 1 Bill Clinton
157 bruce-babbitt 1998-03-19 1999-12-30 651           0 0 1 Bill Clinton
159 waco 1999-09-09 2000-04-22 226           0 0 1 Bill Clinton
158 herman 1998-05-26 2000-04-07 682 Abdul Rahman 631 indictment     0 0 0 Bill Clinton
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
86 iran-contra 1986-12-19 1993-08-03 2419 Albert Hakim 453 guilty-plea 1989-11-21 1068 0 0 1 Ronald Reagan
179 russia 2017-05-17   659 Alex Van Der Zwaan 275 guilty-plea 2018-02-20 279 0 0 1 Donald Trump
151 cisneros 1995-05-24 2004-08-31 3387 Allen Wooten 843 guilty-plea 1998-01-15 967 0 0 1 Bill Clinton
140 espy 1994-09-09 2001-01-30 2335 Alverez Ferrouillet 670 conviction 1996-12-20 833 0 1 1 Bill Clinton
148 espy 1994-09-09 2001-01-30 2335 Archibald Schaffer 1225 conviction 1998-06-26 1386 0 1 1 Bill Clinton
69 watergate 1973-05-19 1977-06-19 1493 Armand Hammer 865 guilty-plea 1976-03-04 865 0 1 1 Richard Nixon
65 watergate 1973-05-19 1977-06-19 1492 Augustus Robbins, III 619 conviction 1975-01-28 619 0 0 1 Richard Nixon
2 watergate 1973-05-19 1977-06-19 1492 Bernard L. Barker -246 conviction 1973-01-15 -124 0 0 1 Richard Nixon
3 watergate 1973-05-19 1977-06-19 1492 Bernard L. Barker 292 conviction 1974-07-12 419 1 0 1 Richard Nixon
138 espy 1994-09-09 2001-01-30 2335 Brooke Keith Mitchell, Jr 622 indictment     0 0 1 Bill Clinton
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
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
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
93 iran-contra 1986-12-19 1993-08-03 2419 Caspar Weinberger 2006 indictment     0 1 1 Ronald Reagan
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
134 whitewater 1994-08-05 2002-03-06 2770 Charles C. Owen 1364 indictment     0 0 1 Bill Clinton
35 watergate 1973-05-19 1977-06-19 1492 Charles Colson 286 guilty-plea 1974-06-03 380 0 0 1 Richard Nixon
117 whitewater 1994-08-05 2002-03-06 2770 Charles Matthews -316 guilty-plea 1994-06-23 -43 0 0 1 Bill Clinton
59 watergate 1973-05-19 1977-06-19 1492 Charles N. Huseman 563 guilty-plea 1974-12-03 563 0 0 1 Richard Nixon
122 whitewater 1994-08-05 2002-03-06 2770 Christopher Wade 228 guilty-plea 1995-03-21 228 0 1 1 Bill Clinton
90 iran-contra 1986-12-19 1993-08-03 2419 Clair E. George 1722 conviction 1992-12-10 2183 0 1 1 Ronald Reagan
27 watergate 1973-05-19 1977-06-19 1492 Claude C. Wild, Jr. 178 guilty-plea 1973-11-13   0 0 1 Richard Nixon
116 whitewater 1994-08-05 2002-03-06 2770 David L. Hale -316 guilty-plea 1994-03-22 -136 0 0 1 Bill Clinton
50 watergate 1973-05-19 1977-06-19 1492 David L. Parr 430 guilty-plea 1974-07-23 430 0 1 1 Richard Nixon
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
20 watergate 1973-05-19 1977-06-19 1492 Donald Segretti 135 guilty-plea 1973-10-01 135 0 0 1 Richard Nixon
92 iran-contra 1986-12-19 1993-08-03 2419 Duane Clarridge 1803 indictment     0 1 1 Ronald Reagan
25 watergate 1973-05-19 1977-06-19 1492 Dwayne O. Andreas 153 indictment     0 0 1 Richard Nixon
29 watergate 1973-05-19 1977-06-19 1492 Dwight Chapin 194 conviction 1974-04-05 321 0 0 1 Richard Nixon
10 watergate 1973-05-19 1977-06-19 1492 E. Howard Hunt -246 guilty-plea 1973-01-11 -128 0 0 1 Richard Nixon
42 watergate 1973-05-19 1977-06-19 1492 Ed Reinecke 319 conviction 1974-07-27 434 1 0 1 Richard Nixon
57 watergate 1973-05-19 1977-06-19 1492 Edward Morgan 538 guilty-plea 1974-11-08 538 0 0 1 Richard Nixon
21 watergate 1973-05-19 1977-06-19 1492 Egil Krogh 145 guilty-plea 1973-11-30 195 0 0 1 Richard Nixon
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
91 iran-contra 1986-12-19 1993-08-03 2419 Elliott Abrams 1753 guilty-plea 1991-10-07 1753 0 1 1 Ronald Reagan
118 whitewater 1994-08-05 2002-03-06 2770 Eugene Fitzhugh -316 guilty-plea 1994-06-23 -43 0 0 1 Bill Clinton
4 watergate 1973-05-19 1977-06-19 1492 Eugenio R. Martinez -246 guilty-plea 1973-01-15 -124 0 1 1 Richard Nixon
5 watergate 1973-05-19 1977-06-19 1492 Eugenio R. Martinez 292 conviction 1974-07-12 419 1 0 1 Richard Nixon
40 watergate 1973-05-19 1977-06-19 1492 Felipe De Diego 292 indictment     0 0 1 Richard Nixon
49 watergate 1973-05-19 1977-06-19 1492 Francis X. Carroll 374 guilty-plea 1974-05-28 374 0 0 1 Richard Nixon
6 watergate 1973-05-19 1977-06-19 1492 Frank A. Sturgis -246 guilty-plea 1973-01-15 -124 0 0 1 Richard Nixon
67 watergate 1973-05-19 1977-06-19 1492 Frank DeMarco 641 indictment     0 0 1 Richard Nixon
18 watergate 1973-05-19 1977-06-19 1492 Frederick LaRue 39 guilty-plea 1973-06-28 40 0 0 1 Richard Nixon
8 watergate 1973-05-19 1977-06-19 1492 G. Gordon Liddy -246 conviction 1973-01-30 -109 0 0 1 Richard Nixon
9 watergate 1973-05-19 1977-06-19 1492 G. Gordon Liddy 292 conviction 1974-07-12 419 0 0 1 Richard Nixon
139 espy 1994-09-09 2001-01-30 2335 Gary Black 630 indictment     0 0 1 Bill Clinton
16 watergate 1973-05-19 1977-06-19 1492 George Hearing -15 guilty-plea 1973-05-11 -8 0 0 1 Richard Nixon
43 watergate 1973-05-19 1977-06-19 1492 George M. Steinbrenner 321 guilty-plea 1974-08-23 461 0 1 1 Richard Nixon
161 russia 2017-05-17   659 George Papadopolous 141 guilty-plea 2017-10-05 141 0 0 1 Donald Trump
38 watergate 1973-05-19 1977-06-19 1492 Gordon C. Strachan 286 indictment     0 0 1 Richard Nixon
31 watergate 1973-05-19 1977-06-19 1492 H. Everett Olson 214 guilty-plea 1973-12-19 214 0 0 1 Richard Nixon
36 watergate 1973-05-19 1977-06-19 1492 H.R. Haldeman 286 conviction 1975-01-01 592 0 0 1 Richard Nixon
26 watergate 1973-05-19 1977-06-19 1492 Harding L. Lawrence 178 guilty-plea 1973-11-13 178 0 0 1 Richard Nixon
52 watergate 1973-05-19 1977-06-19 1492 Harold Nelson 438 guilty-plea 1974-07-31 438 0 1 1 Richard Nixon
61 watergate 1973-05-19 1977-06-19 1492 Harry Dent 571 guilty-plea 1974-12-11 571 0 0 1 Richard Nixon
22 watergate 1973-05-19 1977-06-19 1492 Harry Heltzer 151 guilty-plea 1973-10-17 151 0 0 1 Richard Nixon
15 watergate 1973-05-19 1977-06-19 1492 Harry L. Sears -9 indictment     0 0 1 Richard Nixon
64 watergate 1973-05-19 1977-06-19 1492 Harry Ratrie 619 conviction 1975-01-28 619 0 0 1 Richard Nixon
152 cisneros 1995-05-24 2004-08-31 3387 Henry Cisneros 932 guilty-plea 1999-09-07 1567 0 1 1 Bill Clinton
141 espy 1994-09-09 2001-01-30 2335 Henry Espy, Jr. 670 indictment     0 0 1 Bill Clinton
130 whitewater 1994-08-05 2002-03-06 2770 Herbert Branscum 565 indictment     0 0 1 Bill Clinton
34 watergate 1973-05-19 1977-06-19 1492 Herbert Kalmbach 282 guilty-plea 1974-02-25 282 0 0 1 Richard Nixon
32 watergate 1973-05-19 1977-06-19 1492 Herbert Porter 247 guilty-plea 1974-01-28 254 0 0 1 Richard Nixon
160 plame 2003-12-31 2007-03-06 1161 I. Lewis "Scooter" Libby 1161 conviction 2007-03-06 1161 0 1 1 George W. Bush
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
58 watergate 1973-05-19 1977-06-19 1492 Jack A. Gleason 545 guilty-plea 1974-11-15 545 0 0 1 Richard Nixon
63 watergate 1973-05-19 1977-06-19 1492 Jack Chestnut 583 conviction 1975-05-08 719 0 0 1 Richard Nixon
143 espy 1994-09-09 2001-01-30 2335 Jack L. Williams 740 conviction 1998-06-26 1386 0 1 1 Bill Clinton
33 watergate 1973-05-19 1977-06-19 1492 Jake Jacobsen 278 guilty-plea 1974-08-07   0 0 1 Richard Nixon
46 watergate 1973-05-19 1977-06-19 1492 James Allen 347 guilty-plea 1974-05-01 347 0 0 1 Richard Nixon
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
136 espy 1994-09-09 2001-01-30 2335 James Lake 409 guilty-plea 1995-10-23 409 0 1 1 Bill Clinton
128 whitewater 1994-08-05 2002-03-06 2770 James McDougal 377 conviction 1996-05-26 660 0 0 1 Bill Clinton
70 watergate 1973-05-19 1977-06-19 1492 James R. Jones 985 guilty-plea 1976-01-29 985 0 0 1 Richard Nixon
1 watergate 1973-05-19 1977-06-19 1492 James W. McCord -246 conviction 1973-01-30 -109 0 0 1 Richard Nixon
19 watergate 1973-05-19 1977-06-19 1492 Jeb Magruder 89 guilty-plea 1973-08-16 89 0 0 1 Richard Nixon
123 whitewater 1994-08-05 2002-03-06 2770 Jim Guy Tucker 307 conviction 1996-05-26 660 0 0 1 Bill Clinton
51 watergate 1973-05-19 1977-06-19 1492 John B. Connally 436 indictment     0 0 1 Richard Nixon
37 watergate 1973-05-19 1977-06-19 1492 John D. Ehrlichman 286 conviction 1975-01-01 592 0 0 1 Richard Nixon
154 cisneros 1995-05-24 2004-08-31 3387 John D. Rosales 932 indictment     0 0 1 Bill Clinton
44 watergate 1973-05-19 1977-06-19 1492 John H. Melcher 327 guilty-plea 1974-04-11 327 0 0 1 Richard Nixon
124 whitewater 1994-08-05 2002-03-06 2770 John Haley 307 guilty-plea 1998-02-20 1295 0 0 1 Bill Clinton
142 espy 1994-09-09 2001-01-30 2335 John Hemmingson 698 conviction 1996-12-19 832 0 1 1 Bill Clinton
17 watergate 1973-05-19 1977-06-19 1492 John N. Mitchell 286 conviction 1975-01-01 592 0 0 1 Richard Nixon
84 iran-contra 1986-12-19 1993-08-03 2419 John Poindexter 453 conviction 1990-04-07 1205 1 0 1 Ronald Reagan

Next page

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