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 cp-date

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
12 watergate 1973-05-19 1977-06-19 1492 Maurice H. Stans -9 indictment     0 0 1 Richard Nixon
14 watergate 1973-05-19 1977-06-19 1492 Robert L. Vesco -9 indictment     0 0 1 Richard Nixon
15 watergate 1973-05-19 1977-06-19 1492 Harry L. Sears -9 indictment     0 0 1 Richard Nixon
25 watergate 1973-05-19 1977-06-19 1492 Dwayne O. Andreas 153 indictment     0 0 1 Richard Nixon
38 watergate 1973-05-19 1977-06-19 1492 Gordon C. Strachan 286 indictment     0 0 1 Richard Nixon
39 watergate 1973-05-19 1977-06-19 1492 Kenneth W. Parkinson 286 indictment     0 0 1 Richard Nixon
40 watergate 1973-05-19 1977-06-19 1492 Felipe De Diego 292 indictment     0 0 1 Richard Nixon
51 watergate 1973-05-19 1977-06-19 1492 John B. Connally 436 indictment     0 0 1 Richard Nixon
67 watergate 1973-05-19 1977-06-19 1492 Frank DeMarco 641 indictment     0 0 1 Richard Nixon
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
87 iran-contra 1986-12-19 1993-08-03 2419 Joseph Fernandez 549 indictment     0 0 1 Ronald Reagan
92 iran-contra 1986-12-19 1993-08-03 2419 Duane Clarridge 1803 indictment     0 1 1 Ronald Reagan
93 iran-contra 1986-12-19 1993-08-03 2419 Caspar Weinberger 2006 indictment     0 1 1 Ronald Reagan
95 sealed-investigation-hwbush-1 1991-04-19 1992-07-15 453           0 0 1 George H.W. Bush
100 pierce 1990-03-01 1998-10-27 3162 Victor R. Cruse 754 indictment     0 0 1 George H.W. Bush
103 pierce 1990-03-01 1998-10-27 3162 Phillip McCafferty 831 indictment     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
130 whitewater 1994-08-05 2002-03-06 2770 Herbert Branscum 565 indictment     0 0 1 Bill Clinton
131 whitewater 1994-08-05 2002-03-06 2770 Robert Hill 565 indictment     0 0 1 Bill Clinton
132 whitewater 1994-08-05 2002-03-06 2770 Suzanna Hubbell 1364 indictment     0 0 1 Bill Clinton
133 whitewater 1994-08-05 2002-03-06 2770 Michael C. Schaufele 1364 indictment     0 0 1 Bill Clinton
134 whitewater 1994-08-05 2002-03-06 2770 Charles C. Owen 1364 indictment     0 0 1 Bill Clinton
135 whitewater 1994-08-05 2002-03-06 2770 Julie Hiatt Steele 1616 indictment     0 0 1 Bill Clinton
138 espy 1994-09-09 2001-01-30 2335 Brooke Keith Mitchell, Jr 622 indictment     0 0 1 Bill Clinton
139 espy 1994-09-09 2001-01-30 2335 Gary Black 630 indictment     0 0 1 Bill Clinton
141 espy 1994-09-09 2001-01-30 2335 Henry Espy, Jr. 670 indictment     0 0 1 Bill Clinton
145 espy 1994-09-09 2001-01-30 2335 Norris Faust, Jr. 803 indictment     0 0 1 Bill Clinton
147 espy 1994-09-09 2001-01-30 2335 Mike Espy 1083 indictment     0 0 1 Bill Clinton
153 cisneros 1995-05-24 2004-08-31 3387 Sylvia Arce-Garcia 932 indictment     0 0 1 Bill Clinton
154 cisneros 1995-05-24 2004-08-31 3387 John D. Rosales 932 indictment     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
158 herman 1998-05-26 2000-04-07 682 Abdul Rahman 631 indictment     0 0 0 Bill Clinton
159 waco 1999-09-09 2000-04-22 226           0 0 1 Bill Clinton
165 russia 2017-05-17   659 Russian national 1 275 indictment     0 0 0 Donald Trump
166 russia 2017-05-17   659 Russian national 2 275 indictment     0 0 0 Donald Trump
167 russia 2017-05-17   659 Russian national 3 275 indictment     0 0 0 Donald Trump
168 russia 2017-05-17   659 Russian national 4 275 indictment     0 0 0 Donald Trump
169 russia 2017-05-17   659 Russian national 5 275 indictment     0 0 0 Donald Trump
170 russia 2017-05-17   659 Russian national 6 275 indictment     0 0 0 Donald Trump
171 russia 2017-05-17   659 Russian national 7 275 indictment     0 0 0 Donald Trump
172 russia 2017-05-17   659 Russian national 8 275 indictment     0 0 0 Donald Trump
173 russia 2017-05-17   659 Russian national 9 275 indictment     0 0 0 Donald Trump
174 russia 2017-05-17   659 Russian national 10 275 indictment     0 0 0 Donald Trump
175 russia 2017-05-17   659 Russian national 11 275 indictment     0 0 0 Donald Trump
176 russia 2017-05-17   659 Russian national 12 275 indictment     0 0 0 Donald Trump
177 russia 2017-05-17   659 Russian national 13 275 indictment     0 0 0 Donald Trump
180 russia 2017-05-17   659 Konstantin Kilimnik 387 indictment     0 0 0 Donald Trump
181 russia 2017-05-17   659 Russian national 14 422 indictment     0 0 0 Donald Trump
182 russia 2017-05-17   659 Russian national 15 422 indictment     0 0 0 Donald Trump
183 russia 2017-05-17   659 Russian national 16 422 indictment     0 0 0 Donald Trump
184 russia 2017-05-17   659 Russian national 17 422 indictment     0 0 0 Donald Trump
185 russia 2017-05-17   659 Russian national 18 422 indictment     0 0 0 Donald Trump
186 russia 2017-05-17   659 Russian national 19 422 indictment     0 0 0 Donald Trump
187 russia 2017-05-17   659 Russian national 20 422 indictment     0 0 0 Donald Trump
188 russia 2017-05-17   659 Russian national 21 422 indictment     0 0 0 Donald Trump
189 russia 2017-05-17   659 Russian national 22 422 indictment     0 0 0 Donald Trump
190 russia 2017-05-17   659 Russian national 23 422 indictment     0 0 0 Donald Trump
191 russia 2017-05-17   659 Russian national 24 422 indictment     0 0 0 Donald Trump
192 russia 2017-05-17   659 Russian national 25 422 indictment     0 0 0 Donald Trump
194 russia 2017-05-17   659 Roger Stone 618 indictment     0 0 1 Donald Trump
10 watergate 1973-05-19 1977-06-19 1492 E. Howard Hunt -246 guilty-plea 1973-01-11 -128 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
4 watergate 1973-05-19 1977-06-19 1492 Eugenio R. Martinez -246 guilty-plea 1973-01-15 -124 0 1 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
7 watergate 1973-05-19 1977-06-19 1492 Virgilio R. Gonzalez -246 guilty-plea 1973-01-15 -124 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
8 watergate 1973-05-19 1977-06-19 1492 G. Gordon Liddy -246 conviction 1973-01-30 -109 0 0 1 Richard Nixon
16 watergate 1973-05-19 1977-06-19 1492 George Hearing -15 guilty-plea 1973-05-11 -8 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
19 watergate 1973-05-19 1977-06-19 1492 Jeb Magruder 89 guilty-plea 1973-08-16 89 0 0 1 Richard Nixon
20 watergate 1973-05-19 1977-06-19 1492 Donald Segretti 135 guilty-plea 1973-10-01 135 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
23 watergate 1973-05-19 1977-06-19 1492 Russell DeYoung 151 guilty-plea 1973-10-17 151 0 0 1 Richard Nixon
24 watergate 1973-05-19 1977-06-19 1492 John W. Dean III 153 guilty-plea 1973-10-19 153 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
27 watergate 1973-05-19 1977-06-19 1492 Claude C. Wild, Jr. 178 guilty-plea 1973-11-13   0 0 1 Richard Nixon
28 watergate 1973-05-19 1977-06-19 1492 Orin E. Atkins 178 guilty-plea 1973-11-13   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
30 watergate 1973-05-19 1977-06-19 1492 William W. Keeler 199 guilty-plea 1973-12-04 199 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
32 watergate 1973-05-19 1977-06-19 1492 Herbert Porter 247 guilty-plea 1974-01-28 254 0 0 1 Richard Nixon
34 watergate 1973-05-19 1977-06-19 1492 Herbert Kalmbach 282 guilty-plea 1974-02-25 282 0 0 1 Richard Nixon
41 watergate 1973-05-19 1977-06-19 1492 Ray Dubrowin 292 guilty-plea 1974-03-07 292 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
44 watergate 1973-05-19 1977-06-19 1492 John H. Melcher 327 guilty-plea 1974-04-11 327 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
47 watergate 1973-05-19 1977-06-19 1492 Thomas V. Jones 347 guilty-plea 1974-05-01 347 0 0 1 Richard Nixon
45 watergate 1973-05-19 1977-06-19 1492 Richard Kleindienst 362 guilty-plea 1974-05-16 362 0 0 1 Richard Nixon
48 watergate 1973-05-19 1977-06-19 1492 Richard L. Allison 363 guilty-plea 1974-05-17 363 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
35 watergate 1973-05-19 1977-06-19 1492 Charles Colson 286 guilty-plea 1974-06-03 380 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

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