Russia Investigation: russia-investigation.csv
Data license: CC Attribution 4.0 License · Data source: fivethirtyeight/data on GitHub · About: simonw/fivethirtyeight-datasette
39 rows where type = "conviction"
This data as json, copyable, CSV (advanced)
Suggested facets: investigation, investigation-start, investigation-end, investigation-days, indictment-days , cp-date, cp-days, 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1 | 1 | watergate | 1973-05-19 | 1977-06-19 | 1492 | James W. McCord | -246 | conviction | 1973-01-30 | -109 | 0 | 0 | 1 | Richard Nixon |
2 | 2 | watergate | 1973-05-19 | 1977-06-19 | 1492 | Bernard L. Barker | -246 | conviction | 1973-01-15 | -124 | 0 | 0 | 1 | Richard Nixon |
3 | 3 | watergate | 1973-05-19 | 1977-06-19 | 1492 | Bernard L. Barker | 292 | conviction | 1974-07-12 | 419 | 1 | 0 | 1 | Richard Nixon |
5 | 5 | watergate | 1973-05-19 | 1977-06-19 | 1492 | Eugenio R. Martinez | 292 | conviction | 1974-07-12 | 419 | 1 | 0 | 1 | Richard Nixon |
8 | 8 | watergate | 1973-05-19 | 1977-06-19 | 1492 | G. Gordon Liddy | -246 | conviction | 1973-01-30 | -109 | 0 | 0 | 1 | Richard Nixon |
9 | 9 | watergate | 1973-05-19 | 1977-06-19 | 1492 | G. Gordon Liddy | 292 | conviction | 1974-07-12 | 419 | 0 | 0 | 1 | Richard Nixon |
11 | 11 | watergate | 1973-05-19 | 1977-06-19 | 1492 | Robert C. Mardian | 286 | conviction | 1975-01-01 | 592 | 1 | 0 | 1 | Richard Nixon |
17 | 17 | watergate | 1973-05-19 | 1977-06-19 | 1492 | John N. Mitchell | 286 | conviction | 1975-01-01 | 592 | 0 | 0 | 1 | Richard Nixon |
29 | 29 | watergate | 1973-05-19 | 1977-06-19 | 1492 | Dwight Chapin | 194 | conviction | 1974-04-05 | 321 | 0 | 0 | 1 | Richard Nixon |
36 | 36 | watergate | 1973-05-19 | 1977-06-19 | 1492 | H.R. Haldeman | 286 | conviction | 1975-01-01 | 592 | 0 | 0 | 1 | Richard Nixon |
37 | 37 | watergate | 1973-05-19 | 1977-06-19 | 1492 | John D. Ehrlichman | 286 | conviction | 1975-01-01 | 592 | 0 | 0 | 1 | Richard Nixon |
42 | 42 | watergate | 1973-05-19 | 1977-06-19 | 1492 | Ed Reinecke | 319 | conviction | 1974-07-27 | 434 | 1 | 0 | 1 | Richard Nixon |
63 | 63 | watergate | 1973-05-19 | 1977-06-19 | 1492 | Jack Chestnut | 583 | conviction | 1975-05-08 | 719 | 0 | 0 | 1 | Richard Nixon |
64 | 64 | watergate | 1973-05-19 | 1977-06-19 | 1492 | Harry Ratrie | 619 | conviction | 1975-01-28 | 619 | 0 | 0 | 1 | Richard Nixon |
65 | 65 | watergate | 1973-05-19 | 1977-06-19 | 1492 | Augustus Robbins, III | 619 | conviction | 1975-01-28 | 619 | 0 | 0 | 1 | Richard Nixon |
66 | 66 | watergate | 1973-05-19 | 1977-06-19 | 1492 | Wendell Wyatt | 753 | conviction | 1975-06-11 | 753 | 0 | 0 | 1 | Richard Nixon |
68 | 68 | watergate | 1973-05-19 | 1977-06-19 | 1492 | Ralph Newman | 641 | conviction | 1975-11-12 | 892 | 0 | 0 | 1 | Richard Nixon |
78 | 78 | deaver | 1986-05-29 | 1989-08-16 | 1175 | Michael Deaver | 293 | conviction | 1987-12-16 | 566 | 0 | 0 | 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 |
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 |
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 |
94 | 94 | wedtech | 1987-02-02 | 1988-07-08 | 522 | Lyn Nofziger | 166 | conviction | 1988-02-11 | 374 | 1 | 0 | 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 |
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 |
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 |
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 |
123 | 123 | whitewater | 1994-08-05 | 2002-03-06 | 2770 | Jim Guy Tucker | 307 | conviction | 1996-05-26 | 660 | 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 |
140 | 140 | espy | 1994-09-09 | 2001-01-30 | 2335 | Alverez Ferrouillet | 670 | conviction | 1996-12-20 | 833 | 0 | 1 | 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 |
146 | 146 | espy | 1994-09-09 | 2001-01-30 | 2335 | Ronald H. Blackley | 957 | conviction | 1997-12-01 | 1179 | 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 |
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 |
162 | 162 | russia | 2017-05-17 | 659 | Paul Manafort | 166 | conviction | 2018-08-21 | 461 | 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 );