rowid investigation investigation-start investigation-end investigation-days name indictment-days type cp-date cp-days overturned pardoned american president 1 watergate 1973-05-19 1977-06-19 1492 James W. McCord -246 conviction 1973-01-30 -109 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 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 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 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 10 watergate 1973-05-19 1977-06-19 1492 E. Howard Hunt -246 guilty-plea 1973-01-11 -128 0 0 1 Richard Nixon 11 watergate 1973-05-19 1977-06-19 1492 Robert C. Mardian 286 conviction 1975-01-01 592 1 0 1 Richard Nixon 12 watergate 1973-05-19 1977-06-19 1492 Maurice H. Stans -9 indictment 0 0 1 Richard Nixon 13 watergate 1973-05-19 1977-06-19 1492 Maurice H. Stans 662 guilty-plea 1975-03-12 662 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 16 watergate 1973-05-19 1977-06-19 1492 George Hearing -15 guilty-plea 1973-05-11 -8 0 0 1 Richard Nixon 17 watergate 1973-05-19 1977-06-19 1492 John N. Mitchell 286 conviction 1975-01-01 592 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 21 watergate 1973-05-19 1977-06-19 1492 Egil Krogh 145 guilty-plea 1973-11-30 195 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 25 watergate 1973-05-19 1977-06-19 1492 Dwayne O. Andreas 153 indictment 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 29 watergate 1973-05-19 1977-06-19 1492 Dwight Chapin 194 conviction 1974-04-05 321 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 33 watergate 1973-05-19 1977-06-19 1492 Jake Jacobsen 278 guilty-plea 1974-08-07 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 35 watergate 1973-05-19 1977-06-19 1492 Charles Colson 286 guilty-plea 1974-06-03 380 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 37 watergate 1973-05-19 1977-06-19 1492 John D. Ehrlichman 286 conviction 1975-01-01 592 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 41 watergate 1973-05-19 1977-06-19 1492 Ray Dubrowin 292 guilty-plea 1974-03-07 292 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 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 watergate 1973-05-19 1977-06-19 1492 John H. Melcher 327 guilty-plea 1974-04-11 327 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 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 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 50 watergate 1973-05-19 1977-06-19 1492 David L. Parr 430 guilty-plea 1974-07-23 430 0 1 1 Richard Nixon 51 watergate 1973-05-19 1977-06-19 1492 John B. Connally 436 indictment 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 53 watergate 1973-05-19 1977-06-19 1492 Norman Sherman 450 guilty-plea 1974-08-12 450 0 0 1 Richard Nixon 54 watergate 1973-05-19 1977-06-19 1492 John Valentine 450 guilty-plea 1974-08-12 450 0 0 1 Richard Nixon 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 watergate 1973-05-19 1977-06-19 1492 Raymond Abendroth 522 guilty-plea 1974-10-23 522 0 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 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 watergate 1973-05-19 1977-06-19 1492 Charles N. Huseman 563 guilty-plea 1974-12-03 563 0 0 1 Richard Nixon 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 watergate 1973-05-19 1977-06-19 1492 Harry Dent 571 guilty-plea 1974-12-11 571 0 0 1 Richard Nixon 62 watergate 1973-05-19 1977-06-19 1492 Stuart Russell 579 indictment 1975-07-11 783 1 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 64 watergate 1973-05-19 1977-06-19 1492 Harry Ratrie 619 conviction 1975-01-28 619 0 0 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 66 watergate 1973-05-19 1977-06-19 1492 Wendell Wyatt 753 conviction 1975-06-11 753 0 0 1 Richard Nixon 67 watergate 1973-05-19 1977-06-19 1492 Frank DeMarco 641 indictment 0 0 1 Richard Nixon 68 watergate 1973-05-19 1977-06-19 1492 Ralph Newman 641 conviction 1975-11-12 892 0 0 1 Richard Nixon 69 watergate 1973-05-19 1977-06-19 1493 Armand Hammer 865 guilty-plea 1976-03-04 865 0 1 1 Richard Nixon 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 watergate 1973-05-19 1977-06-19 1494 William C. Viglia 1112 guilty-plea 1976-07-02 1140 0 0 1 Richard Nixon 72 watergate 1973-05-19 1977-06-19 1492 W. Marvin Watson 1223 guilty-plea 1976-09-23 1223 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 78 deaver 1986-05-29 1989-08-16 1175 Michael Deaver 293 conviction 1987-12-16 566 0 0 1 Ronald Reagan 79 sealed-investigation-reagan 1986-12-19 1987-12-18 364 0 0 1 Ronald Reagan 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 iran-contra 1986-12-19 1993-08-03 2419 Richard Miller 138 guilty-plea 1987-05-06 138 0 0 1 Ronald Reagan 82 iran-contra 1986-12-19 1993-08-03 2419 Robert McFarlane 448 guilty-plea 1988-03-11 448 0 1 1 Ronald Reagan 83 iran-contra 1986-12-19 1993-08-03 2419 Oliver North 453 conviction 1989-05-04 867 1 0 1 Ronald Reagan 84 iran-contra 1986-12-19 1993-08-03 2419 John Poindexter 453 conviction 1990-04-07 1205 1 0 1 Ronald Reagan 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 iran-contra 1986-12-19 1993-08-03 2419 Albert Hakim 453 guilty-plea 1989-11-21 1068 0 0 1 Ronald Reagan 87 iran-contra 1986-12-19 1993-08-03 2419 Joseph Fernandez 549 indictment 0 0 1 Ronald Reagan 88 iran-contra 1986-12-19 1993-08-03 2419 Thomas G. Clines 1161 conviction 1990-09-18 1369 0 0 1 Ronald Reagan 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 90 iran-contra 1986-12-19 1993-08-03 2419 Clair E. George 1722 conviction 1992-12-10 2183 0 1 1 Ronald Reagan 91 iran-contra 1986-12-19 1993-08-03 2419 Elliott Abrams 1753 guilty-plea 1991-10-07 1753 0 1 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 94 wedtech 1987-02-02 1988-07-08 522 Lyn Nofziger 166 conviction 1988-02-11 374 1 0 1 Ronald Reagan 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