Russia Investigation: russia-investigation.csv
Data license: CC Attribution 4.0 License · Data source: fivethirtyeight/data on GitHub · About: simonw/fivethirtyeight-datasette
56 rows where type = "indictment"
This data as json, copyable, CSV (advanced)
Link | rowid ▼ | investigation | investigation-start | investigation-end | investigation-days | name | indictment-days | type | cp-date | cp-days | overturned | pardoned | american | president |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 |
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 );