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

194 rows sorted by indictment-days

✎ View and edit SQL

This data as json, copyable, CSV (advanced)

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 73 hamilton-jordan 1979-11-29 1980-05-28 181           0 0 1 Jimmy Carter
74 74 tim-kraft 1980-09-09 1982-01-15 493           0 0 1 Jimmy Carter
75 75 raymond-donovan 1981-12-29 1982-06-25 178           0 0 1 Ronald Reagan
76 76 edwin-meese 1984-04-02 1984-09-20 171           0 0 1 Ronald Reagan
77 77 ted-olson 1986-04-23 1989-03-14 1056           0 0 1 Ronald Reagan
79 79 sealed-investigation-reagan 1986-12-19 1987-12-18 364           0 0 1 Ronald Reagan
95 95 sealed-investigation-hwbush-1 1991-04-19 1992-07-15 453           0 0 1 George H.W. Bush
114 114 sealed-investigation-hwbush-2 1991-04-19 1992-07-15 453           0 0 1 George H.W. Bush
115 115 bush-clinton-passport 1992-12-14 1995-11-30 1081           0 0 1 Bill Clinton
155 155 ron-brown 1995-07-06 1996-11-14 497           0 0 1 Bill Clinton
156 156 eli-segal 1996-11-27 1997-08-21 267           0 0 1 Bill Clinton
157 157 bruce-babbitt 1998-03-19 1999-12-30 651           0 0 1 Bill Clinton
159 159 waco 1999-09-09 2000-04-22 226           0 0 1 Bill Clinton
116 116 whitewater 1994-08-05 2002-03-06 2770 David L. Hale -316 guilty-plea 1994-03-22 -136 0 0 1 Bill Clinton
117 117 whitewater 1994-08-05 2002-03-06 2770 Charles Matthews -316 guilty-plea 1994-06-23 -43 0 0 1 Bill Clinton
118 118 whitewater 1994-08-05 2002-03-06 2770 Eugene Fitzhugh -316 guilty-plea 1994-06-23 -43 0 0 1 Bill Clinton
1 1 watergate 1973-05-19 1977-06-19 1492 James W. McCord -246 conviction 1973-01-30 -109 0 0 1 Richard Nixon
2 2 watergate 1973-05-19 1977-06-19 1492 Bernard L. Barker -246 conviction 1973-01-15 -124 0 0 1 Richard Nixon
4 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 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 7 watergate 1973-05-19 1977-06-19 1492 Virgilio R. Gonzalez -246 guilty-plea 1973-01-15 -124 0 0 1 Richard Nixon
8 8 watergate 1973-05-19 1977-06-19 1492 G. Gordon Liddy -246 conviction 1973-01-30 -109 0 0 1 Richard Nixon
10 10 watergate 1973-05-19 1977-06-19 1492 E. Howard Hunt -246 guilty-plea 1973-01-11 -128 0 0 1 Richard Nixon
16 16 watergate 1973-05-19 1977-06-19 1492 George Hearing -15 guilty-plea 1973-05-11 -8 0 0 1 Richard Nixon
12 12 watergate 1973-05-19 1977-06-19 1492 Maurice H. Stans -9 indictment     0 0 1 Richard Nixon
14 14 watergate 1973-05-19 1977-06-19 1492 Robert L. Vesco -9 indictment     0 0 1 Richard Nixon
15 15 watergate 1973-05-19 1977-06-19 1492 Harry L. Sears -9 indictment     0 0 1 Richard Nixon
18 18 watergate 1973-05-19 1977-06-19 1492 Frederick LaRue 39 guilty-plea 1973-06-28 40 0 0 1 Richard Nixon
19 19 watergate 1973-05-19 1977-06-19 1492 Jeb Magruder 89 guilty-plea 1973-08-16 89 0 0 1 Richard Nixon
119 119 whitewater 1994-08-05 2002-03-06 2770 Robert W. Palmer 123 guilty-plea 1994-12-05 122 0 0 1 Bill Clinton
120 120 whitewater 1994-08-05 2002-03-06 2770 Webster L. Hubbell 123 guilty-plea 1994-12-06 123 0 1 1 Bill Clinton
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
20 20 watergate 1973-05-19 1977-06-19 1492 Donald Segretti 135 guilty-plea 1973-10-01 135 0 0 1 Richard Nixon
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
161 161 russia 2017-05-17   659 George Papadopolous 141 guilty-plea 2017-10-05 141 0 0 1 Donald Trump
21 21 watergate 1973-05-19 1977-06-19 1492 Egil Krogh 145 guilty-plea 1973-11-30 195 0 0 1 Richard Nixon
22 22 watergate 1973-05-19 1977-06-19 1492 Harry Heltzer 151 guilty-plea 1973-10-17 151 0 0 1 Richard Nixon
23 23 watergate 1973-05-19 1977-06-19 1492 Russell DeYoung 151 guilty-plea 1973-10-17 151 0 0 1 Richard Nixon
24 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
25 25 watergate 1973-05-19 1977-06-19 1492 Dwayne O. Andreas 153 indictment     0 0 1 Richard Nixon
94 94 wedtech 1987-02-02 1988-07-08 522 Lyn Nofziger 166 conviction 1988-02-11 374 1 0 1 Ronald Reagan
162 162 russia 2017-05-17   659 Paul Manafort 166 conviction 2018-08-21 461 0 0 1 Donald Trump
163 163 russia 2017-05-17   659 Rick Gates 166 guilty-plea 2018-02-23 282 0 0 1 Donald Trump
26 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 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 28 watergate 1973-05-19 1977-06-19 1492 Orin E. Atkins 178 guilty-plea 1973-11-13   0 0 1 Richard Nixon
29 29 watergate 1973-05-19 1977-06-19 1492 Dwight Chapin 194 conviction 1974-04-05 321 0 0 1 Richard Nixon
164 164 russia 2017-05-17   659 Michael Flynn 198 guilty-plea 2017-12-01 198 0 0 1 Donald Trump
30 30 watergate 1973-05-19 1977-06-19 1492 William W. Keeler 199 guilty-plea 1973-12-04 199 0 0 1 Richard Nixon
121 121 whitewater 1994-08-05 2002-03-06 2770 Neal T. Ainley 208 guilty-plea 1995-05-02 270 0 0 1 Bill Clinton
31 31 watergate 1973-05-19 1977-06-19 1492 H. Everett Olson 214 guilty-plea 1973-12-19 214 0 0 1 Richard Nixon
122 122 whitewater 1994-08-05 2002-03-06 2770 Christopher Wade 228 guilty-plea 1995-03-21 228 0 1 1 Bill Clinton
32 32 watergate 1973-05-19 1977-06-19 1492 Herbert Porter 247 guilty-plea 1974-01-28 254 0 0 1 Richard Nixon
178 178 russia 2017-05-17   659 Richard Pinedo 266 guilty-plea 2018-02-12 271 0 0 1 Donald Trump
165 165 russia 2017-05-17   659 Russian national 1 275 indictment     0 0 0 Donald Trump
166 166 russia 2017-05-17   659 Russian national 2 275 indictment     0 0 0 Donald Trump
167 167 russia 2017-05-17   659 Russian national 3 275 indictment     0 0 0 Donald Trump
168 168 russia 2017-05-17   659 Russian national 4 275 indictment     0 0 0 Donald Trump
169 169 russia 2017-05-17   659 Russian national 5 275 indictment     0 0 0 Donald Trump
170 170 russia 2017-05-17   659 Russian national 6 275 indictment     0 0 0 Donald Trump
171 171 russia 2017-05-17   659 Russian national 7 275 indictment     0 0 0 Donald Trump
172 172 russia 2017-05-17   659 Russian national 8 275 indictment     0 0 0 Donald Trump
173 173 russia 2017-05-17   659 Russian national 9 275 indictment     0 0 0 Donald Trump
174 174 russia 2017-05-17   659 Russian national 10 275 indictment     0 0 0 Donald Trump
175 175 russia 2017-05-17   659 Russian national 11 275 indictment     0 0 0 Donald Trump
176 176 russia 2017-05-17   659 Russian national 12 275 indictment     0 0 0 Donald Trump
177 177 russia 2017-05-17   659 Russian national 13 275 indictment     0 0 0 Donald Trump
179 179 russia 2017-05-17   659 Alex Van Der Zwaan 275 guilty-plea 2018-02-20 279 0 0 1 Donald Trump
33 33 watergate 1973-05-19 1977-06-19 1492 Jake Jacobsen 278 guilty-plea 1974-08-07   0 0 1 Richard Nixon
34 34 watergate 1973-05-19 1977-06-19 1492 Herbert Kalmbach 282 guilty-plea 1974-02-25 282 0 0 1 Richard Nixon
11 11 watergate 1973-05-19 1977-06-19 1492 Robert C. Mardian 286 conviction 1975-01-01 592 1 0 1 Richard Nixon
17 17 watergate 1973-05-19 1977-06-19 1492 John N. Mitchell 286 conviction 1975-01-01 592 0 0 1 Richard Nixon
35 35 watergate 1973-05-19 1977-06-19 1492 Charles Colson 286 guilty-plea 1974-06-03 380 0 0 1 Richard Nixon
36 36 watergate 1973-05-19 1977-06-19 1492 H.R. Haldeman 286 conviction 1975-01-01 592 0 0 1 Richard Nixon
37 37 watergate 1973-05-19 1977-06-19 1492 John D. Ehrlichman 286 conviction 1975-01-01 592 0 0 1 Richard Nixon
38 38 watergate 1973-05-19 1977-06-19 1492 Gordon C. Strachan 286 indictment     0 0 1 Richard Nixon
39 39 watergate 1973-05-19 1977-06-19 1492 Kenneth W. Parkinson 286 indictment     0 0 1 Richard Nixon
3 3 watergate 1973-05-19 1977-06-19 1492 Bernard L. Barker 292 conviction 1974-07-12 419 1 0 1 Richard Nixon
5 5 watergate 1973-05-19 1977-06-19 1492 Eugenio R. Martinez 292 conviction 1974-07-12 419 1 0 1 Richard Nixon
9 9 watergate 1973-05-19 1977-06-19 1492 G. Gordon Liddy 292 conviction 1974-07-12 419 0 0 1 Richard Nixon
40 40 watergate 1973-05-19 1977-06-19 1492 Felipe De Diego 292 indictment     0 0 1 Richard Nixon
41 41 watergate 1973-05-19 1977-06-19 1492 Ray Dubrowin 292 guilty-plea 1974-03-07 292 0 0 1 Richard Nixon
78 78 deaver 1986-05-29 1989-08-16 1175 Michael Deaver 293 conviction 1987-12-16 566 0 0 1 Ronald Reagan
123 123 whitewater 1994-08-05 2002-03-06 2770 Jim Guy Tucker 307 conviction 1996-05-26 660 0 0 1 Bill Clinton
124 124 whitewater 1994-08-05 2002-03-06 2770 John Haley 307 guilty-plea 1998-02-20 1295 0 0 1 Bill Clinton
125 125 whitewater 1994-08-05 2002-03-06 2770 Stephen A. Smith 307 guilty-plea 1995-06-08 307 0 1 1 Bill Clinton
126 126 whitewater 1994-08-05 2002-03-06 2770 William J. Marks Sr. 307 guilty-plea 1997-08-28 1119 0 0 1 Bill Clinton
42 42 watergate 1973-05-19 1977-06-19 1492 Ed Reinecke 319 conviction 1974-07-27 434 1 0 1 Richard Nixon
43 43 watergate 1973-05-19 1977-06-19 1492 George M. Steinbrenner 321 guilty-plea 1974-08-23 461 0 1 1 Richard Nixon
44 44 watergate 1973-05-19 1977-06-19 1492 John H. Melcher 327 guilty-plea 1974-04-11 327 0 0 1 Richard Nixon
127 127 whitewater 1994-08-05 2002-03-06 2770 Larry Kuca 342 guilty-plea 1995-07-13 342 0 0 1 Bill Clinton
46 46 watergate 1973-05-19 1977-06-19 1492 James Allen 347 guilty-plea 1974-05-01 347 0 0 1 Richard Nixon
47 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 45 watergate 1973-05-19 1977-06-19 1492 Richard Kleindienst 362 guilty-plea 1974-05-16 362 0 0 1 Richard Nixon
48 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 49 watergate 1973-05-19 1977-06-19 1492 Francis X. Carroll 374 guilty-plea 1974-05-28 374 0 0 1 Richard Nixon
128 128 whitewater 1994-08-05 2002-03-06 2770 James McDougal 377 conviction 1996-05-26 660 0 0 1 Bill Clinton
129 129 whitewater 1994-08-05 2002-03-06 2770 Susan McDougal 377 conviction 1996-05-26 660 0 1 1 Bill Clinton
180 180 russia 2017-05-17   659 Konstantin Kilimnik 387 indictment     0 0 0 Donald Trump
136 136 espy 1994-09-09 2001-01-30 2335 James Lake 409 guilty-plea 1995-10-23 409 0 1 1 Bill Clinton

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