Russia Investigation: russia-investigation.csv
Data license: CC Attribution 4.0 License · Data source: fivethirtyeight/data on GitHub · About: simonw/fivethirtyeight-datasette
20 rows where president = "Ronald Reagan"
This data as json, copyable, CSV (advanced)
Suggested facets: investigation, investigation-start, investigation-end, investigation-days, indictment-days , type, overturned, pardoned, 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 | |||||
78 | 78 | deaver | 1986-05-29 | 1989-08-16 | 1175 | Michael Deaver | 293 | conviction | 1987-12-16 | 566 | 0 | 0 | 1 | Ronald Reagan |
79 | 79 | sealed-investigation-reagan | 1986-12-19 | 1987-12-18 | 364 | 0 | 0 | 1 | Ronald Reagan | |||||
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 | ||
94 | 94 | wedtech | 1987-02-02 | 1988-07-08 | 522 | Lyn Nofziger | 166 | conviction | 1988-02-11 | 374 | 1 | 0 | 1 | Ronald Reagan |
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 );