fivethirtyeight
Data license: CC Attribution 4.0 License · Data source: fivethirtyeight/data on GitHub · About: simonw/fivethirtyeight-datasette
This data as json, copyable, CSV
rowid | investigation | investigation-start | investigation-end | investigation-days | name | indictment-days | type | cp-date | cp-days | overturned | pardoned | american | president |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 | |||||
95 | sealed-investigation-hwbush-1 | 1991-04-19 | 1992-07-15 | 453 | 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 | |||||
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 | |||||
159 | waco | 1999-09-09 | 2000-04-22 | 226 | 0 | 0 | 1 | Bill Clinton | |||||
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 |
5 | watergate | 1973-05-19 | 1977-06-19 | 1492 | Eugenio R. Martinez | 292 | conviction | 1974-07-12 | 419 | 1 | 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 |
11 | watergate | 1973-05-19 | 1977-06-19 | 1492 | Robert C. Mardian | 286 | conviction | 1975-01-01 | 592 | 1 | 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 |
29 | watergate | 1973-05-19 | 1977-06-19 | 1492 | Dwight Chapin | 194 | conviction | 1974-04-05 | 321 | 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 |
42 | watergate | 1973-05-19 | 1977-06-19 | 1492 | Ed Reinecke | 319 | conviction | 1974-07-27 | 434 | 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 |
68 | watergate | 1973-05-19 | 1977-06-19 | 1492 | Ralph Newman | 641 | conviction | 1975-11-12 | 892 | 0 | 0 | 1 | Richard Nixon |
78 | deaver | 1986-05-29 | 1989-08-16 | 1175 | Michael Deaver | 293 | conviction | 1987-12-16 | 566 | 0 | 0 | 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 |
88 | iran-contra | 1986-12-19 | 1993-08-03 | 2419 | Thomas G. Clines | 1161 | conviction | 1990-09-18 | 1369 | 0 | 0 | 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 |
94 | wedtech | 1987-02-02 | 1988-07-08 | 522 | Lyn Nofziger | 166 | conviction | 1988-02-11 | 374 | 1 | 0 | 1 | Ronald Reagan |
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 |
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 |
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 |
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 |
123 | whitewater | 1994-08-05 | 2002-03-06 | 2770 | Jim Guy Tucker | 307 | conviction | 1996-05-26 | 660 | 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 |
140 | espy | 1994-09-09 | 2001-01-30 | 2335 | Alverez Ferrouillet | 670 | conviction | 1996-12-20 | 833 | 0 | 1 | 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 |
146 | espy | 1994-09-09 | 2001-01-30 | 2335 | Ronald H. Blackley | 957 | conviction | 1997-12-01 | 1179 | 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 |
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 |
162 | russia | 2017-05-17 | 659 | Paul Manafort | 166 | conviction | 2018-08-21 | 461 | 0 | 0 | 1 | Donald Trump | |
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 |
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 | watergate | 1973-05-19 | 1977-06-19 | 1492 | Maurice H. Stans | 662 | guilty-plea | 1975-03-12 | 662 | 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 |
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 |
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 | |
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 |
41 | watergate | 1973-05-19 | 1977-06-19 | 1492 | Ray Dubrowin | 292 | guilty-plea | 1974-03-07 | 292 | 0 | 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 |
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 |
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 |
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 |
85 | iran-contra | 1986-12-19 | 1993-08-03 | 2419 | Richard Secord | 453 | guilty-plea | 1989-11-08 | 1055 | 0 | 0 | 1 | Ronald Reagan |