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 investigation
This data as json, copyable, CSV (advanced)
Suggested facets: investigation, investigation-start, investigation-end, investigation-days, type, overturned, 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
157 | 157 | bruce-babbitt | 1998-03-19 | 1999-12-30 | 651 | 0 | 0 | 1 | Bill Clinton | |||||
115 | 115 | bush-clinton-passport | 1992-12-14 | 1995-11-30 | 1081 | 0 | 0 | 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 |
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 | ||
78 | 78 | deaver | 1986-05-29 | 1989-08-16 | 1175 | Michael Deaver | 293 | conviction | 1987-12-16 | 566 | 0 | 0 | 1 | Ronald Reagan |
76 | 76 | edwin-meese | 1984-04-02 | 1984-09-20 | 171 | 0 | 0 | 1 | Ronald Reagan | |||||
156 | 156 | eli-segal | 1996-11-27 | 1997-08-21 | 267 | 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 |
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 | ||
140 | 140 | espy | 1994-09-09 | 2001-01-30 | 2335 | Alverez Ferrouillet | 670 | conviction | 1996-12-20 | 833 | 0 | 1 | 1 | Bill Clinton |
141 | 141 | espy | 1994-09-09 | 2001-01-30 | 2335 | Henry Espy, Jr. | 670 | indictment | 0 | 0 | 1 | Bill Clinton | ||
142 | 142 | espy | 1994-09-09 | 2001-01-30 | 2335 | John Hemmingson | 698 | conviction | 1996-12-19 | 832 | 0 | 1 | 1 | Bill Clinton |
143 | 143 | espy | 1994-09-09 | 2001-01-30 | 2335 | Jack L. Williams | 740 | conviction | 1998-06-26 | 1386 | 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 |
145 | 145 | espy | 1994-09-09 | 2001-01-30 | 2335 | Norris Faust, Jr. | 803 | indictment | 0 | 0 | 1 | Bill Clinton | ||
146 | 146 | espy | 1994-09-09 | 2001-01-30 | 2335 | Ronald H. Blackley | 957 | conviction | 1997-12-01 | 1179 | 0 | 0 | 1 | Bill Clinton |
147 | 147 | espy | 1994-09-09 | 2001-01-30 | 2335 | Mike Espy | 1083 | indictment | 0 | 0 | 1 | Bill Clinton | ||
148 | 148 | espy | 1994-09-09 | 2001-01-30 | 2335 | Archibald Schaffer | 1225 | conviction | 1998-06-26 | 1386 | 0 | 1 | 1 | Bill Clinton |
73 | 73 | hamilton-jordan | 1979-11-29 | 1980-05-28 | 181 | 0 | 0 | 1 | Jimmy Carter | |||||
158 | 158 | herman | 1998-05-26 | 2000-04-07 | 682 | Abdul Rahman | 631 | indictment | 0 | 0 | 0 | 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 |
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 |
83 | 83 | iran-contra | 1986-12-19 | 1993-08-03 | 2419 | Oliver North | 453 | conviction | 1989-05-04 | 867 | 1 | 0 | 1 | Ronald Reagan |
84 | 84 | iran-contra | 1986-12-19 | 1993-08-03 | 2419 | John Poindexter | 453 | conviction | 1990-04-07 | 1205 | 1 | 0 | 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 |
87 | 87 | iran-contra | 1986-12-19 | 1993-08-03 | 2419 | Joseph Fernandez | 549 | indictment | 0 | 0 | 1 | Ronald Reagan | ||
88 | 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 | 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 | 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 | 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 | 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 | ||
96 | 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 | 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 | 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 | 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 | 100 | pierce | 1990-03-01 | 1998-10-27 | 3162 | Victor R. Cruse | 754 | indictment | 0 | 0 | 1 | George H.W. Bush | ||
101 | 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 |
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 |
103 | 103 | pierce | 1990-03-01 | 1998-10-27 | 3162 | Phillip McCafferty | 831 | indictment | 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 |
109 | 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 | 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 |
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 |
160 | 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 |
75 | 75 | raymond-donovan | 1981-12-29 | 1982-06-25 | 178 | 0 | 0 | 1 | Ronald Reagan | |||||
155 | 155 | ron-brown | 1995-07-06 | 1996-11-14 | 497 | 0 | 0 | 1 | Bill Clinton | |||||
161 | 161 | russia | 2017-05-17 | 659 | George Papadopolous | 141 | guilty-plea | 2017-10-05 | 141 | 0 | 0 | 1 | Donald Trump | |
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 | |
164 | 164 | russia | 2017-05-17 | 659 | Michael Flynn | 198 | guilty-plea | 2017-12-01 | 198 | 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 | |||
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 | |
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 | |||
193 | 193 | russia | 2017-05-17 | 659 | Michael Cohen | 561 | guilty-plea | 2018-11-29 | 561 | 0 | 0 | 1 | Donald Trump | |
194 | 194 | russia | 2017-05-17 | 659 | Roger Stone | 618 | indictment | 0 | 0 | 1 | Donald Trump | |||
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 | |||||
79 | 79 | sealed-investigation-reagan | 1986-12-19 | 1987-12-18 | 364 | 0 | 0 | 1 | Ronald Reagan | |||||
77 | 77 | ted-olson | 1986-04-23 | 1989-03-14 | 1056 | 0 | 0 | 1 | Ronald Reagan | |||||
74 | 74 | tim-kraft | 1980-09-09 | 1982-01-15 | 493 | 0 | 0 | 1 | Jimmy Carter |
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 );