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 president

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 ▼
115 bush-clinton-passport 1992-12-14 1995-11-30 1081           0 0 1 Bill Clinton
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 whitewater 1994-08-05 2002-03-06 2770 Charles Matthews -316 guilty-plea 1994-06-23 -43 0 0 1 Bill Clinton
118 whitewater 1994-08-05 2002-03-06 2770 Eugene Fitzhugh -316 guilty-plea 1994-06-23 -43 0 0 1 Bill Clinton
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 whitewater 1994-08-05 2002-03-06 2770 Webster L. Hubbell 123 guilty-plea 1994-12-06 123 0 1 1 Bill Clinton
121 whitewater 1994-08-05 2002-03-06 2770 Neal T. Ainley 208 guilty-plea 1995-05-02 270 0 0 1 Bill Clinton
122 whitewater 1994-08-05 2002-03-06 2770 Christopher Wade 228 guilty-plea 1995-03-21 228 0 1 1 Bill Clinton
123 whitewater 1994-08-05 2002-03-06 2770 Jim Guy Tucker 307 conviction 1996-05-26 660 0 0 1 Bill Clinton
124 whitewater 1994-08-05 2002-03-06 2770 John Haley 307 guilty-plea 1998-02-20 1295 0 0 1 Bill Clinton
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 whitewater 1994-08-05 2002-03-06 2770 William J. Marks Sr. 307 guilty-plea 1997-08-28 1119 0 0 1 Bill Clinton
127 whitewater 1994-08-05 2002-03-06 2770 Larry Kuca 342 guilty-plea 1995-07-13 342 0 0 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
129 whitewater 1994-08-05 2002-03-06 2770 Susan McDougal 377 conviction 1996-05-26 660 0 1 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
136 espy 1994-09-09 2001-01-30 2335 James Lake 409 guilty-plea 1995-10-23 409 0 1 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
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
140 espy 1994-09-09 2001-01-30 2335 Alverez Ferrouillet 670 conviction 1996-12-20 833 0 1 1 Bill Clinton
141 espy 1994-09-09 2001-01-30 2335 Henry Espy, Jr. 670 indictment     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
143 espy 1994-09-09 2001-01-30 2335 Jack L. Williams 740 conviction 1998-06-26 1386 0 1 1 Bill Clinton
144 espy 1994-09-09 2001-01-30 2335 Richard Douglas 769 guilty-plea 1998-03-16 1284 0 1 1 Bill Clinton
145 espy 1994-09-09 2001-01-30 2335 Norris Faust, Jr. 803 indictment     0 0 1 Bill Clinton
146 espy 1994-09-09 2001-01-30 2335 Ronald H. Blackley 957 conviction 1997-12-01 1179 0 0 1 Bill Clinton
147 espy 1994-09-09 2001-01-30 2335 Mike Espy 1083 indictment     0 0 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
149 cisneros 1995-05-24 2004-08-31 3387 Linda (Medlar) Jones 843 guilty-plea 1998-01-15 967 0 1 1 Bill Clinton
150 cisneros 1995-05-24 2004-08-31 3387 Patsy Wooten 843 guilty-plea 1998-01-15 967 0 0 1 Bill Clinton
151 cisneros 1995-05-24 2004-08-31 3387 Allen Wooten 843 guilty-plea 1998-01-15 967 0 0 1 Bill Clinton
152 cisneros 1995-05-24 2004-08-31 3387 Henry Cisneros 932 guilty-plea 1999-09-07 1567 0 1 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
161 russia 2017-05-17   659 George Papadopolous 141 guilty-plea 2017-10-05 141 0 0 1 Donald Trump
162 russia 2017-05-17   659 Paul Manafort 166 conviction 2018-08-21 461 0 0 1 Donald Trump
163 russia 2017-05-17   659 Rick Gates 166 guilty-plea 2018-02-23 282 0 0 1 Donald Trump
164 russia 2017-05-17   659 Michael Flynn 198 guilty-plea 2017-12-01 198 0 0 1 Donald Trump
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
178 russia 2017-05-17   659 Richard Pinedo 266 guilty-plea 2018-02-12 271 0 0 1 Donald Trump
179 russia 2017-05-17   659 Alex Van Der Zwaan 275 guilty-plea 2018-02-20 279 0 0 1 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
193 russia 2017-05-17   659 Michael Cohen 561 guilty-plea 2018-11-29 561 0 0 1 Donald Trump
194 russia 2017-05-17   659 Roger Stone 618 indictment     0 0 1 Donald Trump
95 sealed-investigation-hwbush-1 1991-04-19 1992-07-15 453           0 0 1 George H.W. Bush
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 pierce 1990-03-01 1998-10-27 3162 Maurice Steier 468 conviction 1993-01-05 1041 0 0 1 George H.W. Bush
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 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 pierce 1990-03-01 1998-10-27 3162 Victor R. Cruse 754 indictment     0 0 1 George H.W. Bush
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 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 pierce 1990-03-01 1998-10-27 3162 Phillip McCafferty 831 indictment     0 0 1 George H.W. Bush
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 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 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 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 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 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 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 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 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 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
114 sealed-investigation-hwbush-2 1991-04-19 1992-07-15 453           0 0 1 George H.W. Bush
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

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