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

86 rows where type = "guilty-plea"

✎ View and edit SQL

This data as json, copyable, CSV (advanced)

Suggested facets: investigation, investigation-start, investigation-end, investigation-days, pardoned, 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
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
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
13 13 watergate 1973-05-19 1977-06-19 1492 Maurice H. Stans 662 guilty-plea 1975-03-12 662 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
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
20 20 watergate 1973-05-19 1977-06-19 1492 Donald Segretti 135 guilty-plea 1973-10-01 135 0 0 1 Richard Nixon
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
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
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
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
32 32 watergate 1973-05-19 1977-06-19 1492 Herbert Porter 247 guilty-plea 1974-01-28 254 0 0 1 Richard Nixon
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
35 35 watergate 1973-05-19 1977-06-19 1492 Charles Colson 286 guilty-plea 1974-06-03 380 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
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
45 45 watergate 1973-05-19 1977-06-19 1492 Richard Kleindienst 362 guilty-plea 1974-05-16 362 0 0 1 Richard Nixon
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
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
50 50 watergate 1973-05-19 1977-06-19 1492 David L. Parr 430 guilty-plea 1974-07-23 430 0 1 1 Richard Nixon
52 52 watergate 1973-05-19 1977-06-19 1492 Harold Nelson 438 guilty-plea 1974-07-31 438 0 1 1 Richard Nixon
53 53 watergate 1973-05-19 1977-06-19 1492 Norman Sherman 450 guilty-plea 1974-08-12 450 0 0 1 Richard Nixon
54 54 watergate 1973-05-19 1977-06-19 1492 John Valentine 450 guilty-plea 1974-08-12 450 0 0 1 Richard Nixon
55 55 watergate 1973-05-19 1977-06-19 1492 William Lyles, Sr. 486 guilty-plea 1974-09-17 486 0 0 1 Richard Nixon
56 56 watergate 1973-05-19 1977-06-19 1492 Raymond Abendroth 522 guilty-plea 1974-10-23 522 0 0 1 Richard Nixon
57 57 watergate 1973-05-19 1977-06-19 1492 Edward Morgan 538 guilty-plea 1974-11-08 538 0 0 1 Richard Nixon
58 58 watergate 1973-05-19 1977-06-19 1492 Jack A. Gleason 545 guilty-plea 1974-11-15 545 0 0 1 Richard Nixon
59 59 watergate 1973-05-19 1977-06-19 1492 Charles N. Huseman 563 guilty-plea 1974-12-03 563 0 0 1 Richard Nixon
60 60 watergate 1973-05-19 1977-06-19 1492 Tim M. Babcock 570 guilty-plea 1974-12-10 570 0 0 1 Richard Nixon
61 61 watergate 1973-05-19 1977-06-19 1492 Harry Dent 571 guilty-plea 1974-12-11 571 0 0 1 Richard Nixon
69 69 watergate 1973-05-19 1977-06-19 1493 Armand Hammer 865 guilty-plea 1976-03-04 865 0 1 1 Richard Nixon
70 70 watergate 1973-05-19 1977-06-19 1492 James R. Jones 985 guilty-plea 1976-01-29 985 0 0 1 Richard Nixon
71 71 watergate 1973-05-19 1977-06-19 1494 William C. Viglia 1112 guilty-plea 1976-07-02 1140 0 0 1 Richard Nixon
72 72 watergate 1973-05-19 1977-06-19 1492 W. Marvin Watson 1223 guilty-plea 1976-09-23 1223 0 0 1 Richard Nixon
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
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
82 82 iran-contra 1986-12-19 1993-08-03 2419 Robert McFarlane 448 guilty-plea 1988-03-11 448 0 1 1 Ronald Reagan
85 85 iran-contra 1986-12-19 1993-08-03 2419 Richard Secord 453 guilty-plea 1989-11-08 1055 0 0 1 Ronald Reagan
86 86 iran-contra 1986-12-19 1993-08-03 2419 Albert Hakim 453 guilty-plea 1989-11-21 1068 0 0 1 Ronald Reagan
89 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
91 91 iran-contra 1986-12-19 1993-08-03 2419 Elliott Abrams 1753 guilty-plea 1991-10-07 1753 0 1 1 Ronald Reagan
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
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
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
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
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
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
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
122 122 whitewater 1994-08-05 2002-03-06 2770 Christopher Wade 228 guilty-plea 1995-03-21 228 0 1 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
127 127 whitewater 1994-08-05 2002-03-06 2770 Larry Kuca 342 guilty-plea 1995-07-13 342 0 0 1 Bill Clinton
136 136 espy 1994-09-09 2001-01-30 2335 James Lake 409 guilty-plea 1995-10-23 409 0 1 1 Bill Clinton
137 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
144 144 espy 1994-09-09 2001-01-30 2335 Richard Douglas 769 guilty-plea 1998-03-16 1284 0 1 1 Bill Clinton
149 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 150 cisneros 1995-05-24 2004-08-31 3387 Patsy Wooten 843 guilty-plea 1998-01-15 967 0 0 1 Bill Clinton
151 151 cisneros 1995-05-24 2004-08-31 3387 Allen Wooten 843 guilty-plea 1998-01-15 967 0 0 1 Bill Clinton
152 152 cisneros 1995-05-24 2004-08-31 3387 Henry Cisneros 932 guilty-plea 1999-09-07 1567 0 1 1 Bill Clinton
161 161 russia 2017-05-17   659 George Papadopolous 141 guilty-plea 2017-10-05 141 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
164 164 russia 2017-05-17   659 Michael Flynn 198 guilty-plea 2017-12-01 198 0 0 1 Donald Trump
178 178 russia 2017-05-17   659 Richard Pinedo 266 guilty-plea 2018-02-12 271 0 0 1 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
193 193 russia 2017-05-17   659 Michael Cohen 561 guilty-plea 2018-11-29 561 0 0 1 Donald Trump

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