Russia Investigation: russia-investigation.csv
Data license: CC Attribution 4.0 License · Data source: fivethirtyeight/data on GitHub · About: simonw/fivethirtyeight-datasette
45 rows where president = "Bill Clinton"
This data as json, copyable, CSV (advanced)
Suggested facets: investigation, investigation-start, investigation-end, investigation-days, indictment-days , type, cp-date, cp-days, pardoned, american, 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
115 | 115 | bush-clinton-passport | 1992-12-14 | 1995-11-30 | 1081 | 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 |
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 |
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 |
122 | 122 | whitewater | 1994-08-05 | 2002-03-06 | 2770 | Christopher Wade | 228 | guilty-plea | 1995-03-21 | 228 | 0 | 1 | 1 | Bill Clinton |
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 |
127 | 127 | whitewater | 1994-08-05 | 2002-03-06 | 2770 | Larry Kuca | 342 | guilty-plea | 1995-07-13 | 342 | 0 | 0 | 1 | Bill Clinton |
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 |
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 | ||
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 |
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 | ||
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 | |||||
158 | 158 | herman | 1998-05-26 | 2000-04-07 | 682 | Abdul Rahman | 631 | indictment | 0 | 0 | 0 | Bill Clinton | ||
159 | 159 | waco | 1999-09-09 | 2000-04-22 | 226 | 0 | 0 | 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 );