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

20 rows where "investigation-start" is on date 1994-08-05

✎ View and edit SQL

This data as json, copyable, CSV (advanced)

Suggested facets: indictment-days , type, cp-date, cp-days, 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
116 116 whitewater 1994-08-05 2002-03-06 2770 David L. Hale -316 guilty-plea 1994-03-22 -136 0 0 1 Bill Clinton
117 117 whitewater 1994-08-05 2002-03-06 2770 Charles Matthews -316 guilty-plea 1994-06-23 -43 0 0 1 Bill Clinton
118 118 whitewater 1994-08-05 2002-03-06 2770 Eugene Fitzhugh -316 guilty-plea 1994-06-23 -43 0 0 1 Bill Clinton
119 119 whitewater 1994-08-05 2002-03-06 2770 Robert W. Palmer 123 guilty-plea 1994-12-05 122 0 0 1 Bill Clinton
120 120 whitewater 1994-08-05 2002-03-06 2770 Webster L. Hubbell 123 guilty-plea 1994-12-06 123 0 1 1 Bill Clinton
121 121 whitewater 1994-08-05 2002-03-06 2770 Neal T. Ainley 208 guilty-plea 1995-05-02 270 0 0 1 Bill Clinton
122 122 whitewater 1994-08-05 2002-03-06 2770 Christopher Wade 228 guilty-plea 1995-03-21 228 0 1 1 Bill Clinton
123 123 whitewater 1994-08-05 2002-03-06 2770 Jim Guy Tucker 307 conviction 1996-05-26 660 0 0 1 Bill Clinton
124 124 whitewater 1994-08-05 2002-03-06 2770 John Haley 307 guilty-plea 1998-02-20 1295 0 0 1 Bill Clinton
125 125 whitewater 1994-08-05 2002-03-06 2770 Stephen A. Smith 307 guilty-plea 1995-06-08 307 0 1 1 Bill Clinton
126 126 whitewater 1994-08-05 2002-03-06 2770 William J. Marks Sr. 307 guilty-plea 1997-08-28 1119 0 0 1 Bill Clinton
127 127 whitewater 1994-08-05 2002-03-06 2770 Larry Kuca 342 guilty-plea 1995-07-13 342 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
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

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