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

6 rows where "investigation-start" is on date 1995-05-24

✎ 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
149 149 cisneros 1995-05-24 2004-08-31 3387 Linda (Medlar) Jones 843 guilty-plea 1998-01-15 967 0 1 1 Bill Clinton
150 150 cisneros 1995-05-24 2004-08-31 3387 Patsy Wooten 843 guilty-plea 1998-01-15 967 0 0 1 Bill Clinton
151 151 cisneros 1995-05-24 2004-08-31 3387 Allen Wooten 843 guilty-plea 1998-01-15 967 0 0 1 Bill Clinton
152 152 cisneros 1995-05-24 2004-08-31 3387 Henry Cisneros 932 guilty-plea 1999-09-07 1567 0 1 1 Bill Clinton
153 153 cisneros 1995-05-24 2004-08-31 3387 Sylvia Arce-Garcia 932 indictment     0 0 1 Bill Clinton
154 154 cisneros 1995-05-24 2004-08-31 3387 John D. Rosales 932 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
);