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 type descending
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)
Link | rowid | investigation | investigation-start | investigation-end | investigation-days | name | indictment-days | type ▲ | cp-date | cp-days | overturned | pardoned | american | president |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 | ||
25 | 25 | watergate | 1973-05-19 | 1977-06-19 | 1492 | Dwayne O. Andreas | 153 | indictment | 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 | ||
40 | 40 | watergate | 1973-05-19 | 1977-06-19 | 1492 | Felipe De Diego | 292 | indictment | 0 | 0 | 1 | Richard Nixon | ||
51 | 51 | watergate | 1973-05-19 | 1977-06-19 | 1492 | John B. Connally | 436 | indictment | 0 | 0 | 1 | Richard Nixon | ||
62 | 62 | watergate | 1973-05-19 | 1977-06-19 | 1492 | Stuart Russell | 579 | indictment | 1975-07-11 | 783 | 1 | 0 | 1 | Richard Nixon |
67 | 67 | watergate | 1973-05-19 | 1977-06-19 | 1492 | Frank DeMarco | 641 | indictment | 0 | 0 | 1 | Richard Nixon | ||
87 | 87 | iran-contra | 1986-12-19 | 1993-08-03 | 2419 | Joseph Fernandez | 549 | indictment | 0 | 0 | 1 | Ronald Reagan | ||
92 | 92 | iran-contra | 1986-12-19 | 1993-08-03 | 2419 | Duane Clarridge | 1803 | indictment | 0 | 1 | 1 | Ronald Reagan | ||
93 | 93 | iran-contra | 1986-12-19 | 1993-08-03 | 2419 | Caspar Weinberger | 2006 | indictment | 0 | 1 | 1 | Ronald Reagan | ||
100 | 100 | pierce | 1990-03-01 | 1998-10-27 | 3162 | Victor R. Cruse | 754 | indictment | 0 | 0 | 1 | George H.W. Bush | ||
103 | 103 | pierce | 1990-03-01 | 1998-10-27 | 3162 | Phillip McCafferty | 831 | indictment | 0 | 0 | 1 | George H.W. Bush | ||
130 | 130 | whitewater | 1994-08-05 | 2002-03-06 | 2770 | Herbert Branscum | 565 | indictment | 0 | 0 | 1 | Bill Clinton | ||
131 | 131 | whitewater | 1994-08-05 | 2002-03-06 | 2770 | Robert Hill | 565 | indictment | 0 | 0 | 1 | Bill Clinton | ||
132 | 132 | whitewater | 1994-08-05 | 2002-03-06 | 2770 | Suzanna Hubbell | 1364 | indictment | 0 | 0 | 1 | Bill Clinton | ||
133 | 133 | whitewater | 1994-08-05 | 2002-03-06 | 2770 | Michael C. Schaufele | 1364 | indictment | 0 | 0 | 1 | Bill Clinton | ||
134 | 134 | whitewater | 1994-08-05 | 2002-03-06 | 2770 | Charles C. Owen | 1364 | indictment | 0 | 0 | 1 | Bill Clinton | ||
135 | 135 | whitewater | 1994-08-05 | 2002-03-06 | 2770 | Julie Hiatt Steele | 1616 | indictment | 0 | 0 | 1 | Bill Clinton | ||
138 | 138 | espy | 1994-09-09 | 2001-01-30 | 2335 | Brooke Keith Mitchell, Jr | 622 | indictment | 0 | 0 | 1 | Bill Clinton | ||
139 | 139 | espy | 1994-09-09 | 2001-01-30 | 2335 | Gary Black | 630 | indictment | 0 | 0 | 1 | Bill Clinton | ||
141 | 141 | espy | 1994-09-09 | 2001-01-30 | 2335 | Henry Espy, Jr. | 670 | indictment | 0 | 0 | 1 | Bill Clinton | ||
145 | 145 | espy | 1994-09-09 | 2001-01-30 | 2335 | Norris Faust, Jr. | 803 | indictment | 0 | 0 | 1 | Bill Clinton | ||
147 | 147 | espy | 1994-09-09 | 2001-01-30 | 2335 | Mike Espy | 1083 | indictment | 0 | 0 | 1 | Bill Clinton | ||
153 | 153 | cisneros | 1995-05-24 | 2004-08-31 | 3387 | Sylvia Arce-Garcia | 932 | indictment | 0 | 0 | 1 | Bill Clinton | ||
154 | 154 | cisneros | 1995-05-24 | 2004-08-31 | 3387 | John D. Rosales | 932 | indictment | 0 | 0 | 1 | Bill Clinton | ||
158 | 158 | herman | 1998-05-26 | 2000-04-07 | 682 | Abdul Rahman | 631 | indictment | 0 | 0 | 0 | Bill Clinton | ||
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 | |||
180 | 180 | russia | 2017-05-17 | 659 | Konstantin Kilimnik | 387 | indictment | 0 | 0 | 0 | Donald Trump | |||
181 | 181 | russia | 2017-05-17 | 659 | Russian national 14 | 422 | indictment | 0 | 0 | 0 | Donald Trump | |||
182 | 182 | russia | 2017-05-17 | 659 | Russian national 15 | 422 | indictment | 0 | 0 | 0 | Donald Trump | |||
183 | 183 | russia | 2017-05-17 | 659 | Russian national 16 | 422 | indictment | 0 | 0 | 0 | Donald Trump | |||
184 | 184 | russia | 2017-05-17 | 659 | Russian national 17 | 422 | indictment | 0 | 0 | 0 | Donald Trump | |||
185 | 185 | russia | 2017-05-17 | 659 | Russian national 18 | 422 | indictment | 0 | 0 | 0 | Donald Trump | |||
186 | 186 | russia | 2017-05-17 | 659 | Russian national 19 | 422 | indictment | 0 | 0 | 0 | Donald Trump | |||
187 | 187 | russia | 2017-05-17 | 659 | Russian national 20 | 422 | indictment | 0 | 0 | 0 | Donald Trump | |||
188 | 188 | russia | 2017-05-17 | 659 | Russian national 21 | 422 | indictment | 0 | 0 | 0 | Donald Trump | |||
189 | 189 | russia | 2017-05-17 | 659 | Russian national 22 | 422 | indictment | 0 | 0 | 0 | Donald Trump | |||
190 | 190 | russia | 2017-05-17 | 659 | Russian national 23 | 422 | indictment | 0 | 0 | 0 | Donald Trump | |||
191 | 191 | russia | 2017-05-17 | 659 | Russian national 24 | 422 | indictment | 0 | 0 | 0 | Donald Trump | |||
192 | 192 | russia | 2017-05-17 | 659 | Russian national 25 | 422 | indictment | 0 | 0 | 0 | Donald Trump | |||
194 | 194 | russia | 2017-05-17 | 659 | Roger Stone | 618 | indictment | 0 | 0 | 1 | Donald Trump | |||
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 |
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 );