Russia Investigation: russia-investigation.csv
Data license: CC Attribution 4.0 License · Data source: fivethirtyeight/data on GitHub · About: simonw/fivethirtyeight-datasette
194 rows sorted by indictment-days
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) >30 ✖
- 1973-01-15 4
- 1975-01-01 4
- 1994-06-23 4
- 1973-11-13 3
- 1974-07-12 3
- 1993-01-05 3
- 1996-05-26 3
- 1998-01-15 3
- 1973-01-30 2
- 1973-10-17 2
- 1974-05-01 2
- 1974-08-12 2
- 1975-01-28 2
- 1998-06-26 2
- 1973-01-11 1
- 1973-05-11 1
- 1973-06-28 1
- 1973-08-16 1
- 1973-10-01 1
- 1973-10-19 1
- 1973-11-30 1
- 1973-12-04 1
- 1973-12-19 1
- 1974-01-28 1
- 1974-02-25 1
- 1974-03-07 1
- 1974-04-05 1
- 1974-04-11 1
- 1974-05-16 1
- 1974-05-17 1
- …
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 |
Advanced export
JSON shape: default, array, newline-delimited
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 );