Russia Investigation: russia-investigation.csv

Table actions

This table contains data behind the story Is The Russia Investigation Really Another Watergate?.

russia-investigation.csv contains every special investigation since the Watergate probe began in 1973 and who was charged in them.

Header Definition
investigation Unique id for each investigation
investigation-start Start date of the investigation
investigation-end End date of the investigation
investigation-days Length, in days, of the investigation. Days will be negative if the charge occured before the investigation began.
name Name of the person charged (if applicable). Will be blank if there were no charges.
indictment-days Length, in days, from the start of the investigation to the date the person was charged (if applicable). Days will be negative if the charge occured before the investigation began.
type Result of charge (if applicable)
cp-date Date the person pled guilty or was convicted (if applicable)
cp-days Length, in days, from the start of the investigation to the date the person pled guilty or was convicted (if applicable)
overturned Whether or not the relevant person's conviction was overturned
pardoned Whether or not the relevant person's charge was pardoned
american Whether or not the relevant person's charge was a U.S. resident
president President at the center of the investigation

Data license: CC Attribution 4.0 License · Data source: fivethirtyeight/data on GitHub · About: simonw/fivethirtyeight-datasette

39 rows where type = "conviction"

✎ View and edit SQL

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

CSV options: 

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
);