Russia Investigation: russia-investigation.csv
Data license: CC Attribution 4.0 License · Data source: fivethirtyeight/data on GitHub · About: simonw/fivethirtyeight-datasette
14 rows where investigation-days = 2419
This data as json, copyable, CSV (advanced)
Suggested facets: 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 |
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 );