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

34 rows where "investigation-start" is on date 2017-05-17

✎ View and edit SQL

This data as json, copyable, CSV (advanced)

Suggested facets: indictment-days , type, american, investigation-start (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
161 161 russia 2017-05-17   659 George Papadopolous 141 guilty-plea 2017-10-05 141 0 0 1 Donald Trump
162 162 russia 2017-05-17   659 Paul Manafort 166 conviction 2018-08-21 461 0 0 1 Donald Trump
163 163 russia 2017-05-17   659 Rick Gates 166 guilty-plea 2018-02-23 282 0 0 1 Donald Trump
164 164 russia 2017-05-17   659 Michael Flynn 198 guilty-plea 2017-12-01 198 0 0 1 Donald Trump
165 165 russia 2017-05-17   659 Russian national 1 275 indictment     0 0 0 Donald Trump
166 166 russia 2017-05-17   659 Russian national 2 275 indictment     0 0 0 Donald Trump
167 167 russia 2017-05-17   659 Russian national 3 275 indictment     0 0 0 Donald Trump
168 168 russia 2017-05-17   659 Russian national 4 275 indictment     0 0 0 Donald Trump
169 169 russia 2017-05-17   659 Russian national 5 275 indictment     0 0 0 Donald Trump
170 170 russia 2017-05-17   659 Russian national 6 275 indictment     0 0 0 Donald Trump
171 171 russia 2017-05-17   659 Russian national 7 275 indictment     0 0 0 Donald Trump
172 172 russia 2017-05-17   659 Russian national 8 275 indictment     0 0 0 Donald Trump
173 173 russia 2017-05-17   659 Russian national 9 275 indictment     0 0 0 Donald Trump
174 174 russia 2017-05-17   659 Russian national 10 275 indictment     0 0 0 Donald Trump
175 175 russia 2017-05-17   659 Russian national 11 275 indictment     0 0 0 Donald Trump
176 176 russia 2017-05-17   659 Russian national 12 275 indictment     0 0 0 Donald Trump
177 177 russia 2017-05-17   659 Russian national 13 275 indictment     0 0 0 Donald Trump
178 178 russia 2017-05-17   659 Richard Pinedo 266 guilty-plea 2018-02-12 271 0 0 1 Donald Trump
179 179 russia 2017-05-17   659 Alex Van Der Zwaan 275 guilty-plea 2018-02-20 279 0 0 1 Donald Trump
180 180 russia 2017-05-17   659 Konstantin Kilimnik 387 indictment     0 0 0 Donald Trump
181 181 russia 2017-05-17   659 Russian national 14 422 indictment     0 0 0 Donald Trump
182 182 russia 2017-05-17   659 Russian national 15 422 indictment     0 0 0 Donald Trump
183 183 russia 2017-05-17   659 Russian national 16 422 indictment     0 0 0 Donald Trump
184 184 russia 2017-05-17   659 Russian national 17 422 indictment     0 0 0 Donald Trump
185 185 russia 2017-05-17   659 Russian national 18 422 indictment     0 0 0 Donald Trump
186 186 russia 2017-05-17   659 Russian national 19 422 indictment     0 0 0 Donald Trump
187 187 russia 2017-05-17   659 Russian national 20 422 indictment     0 0 0 Donald Trump
188 188 russia 2017-05-17   659 Russian national 21 422 indictment     0 0 0 Donald Trump
189 189 russia 2017-05-17   659 Russian national 22 422 indictment     0 0 0 Donald Trump
190 190 russia 2017-05-17   659 Russian national 23 422 indictment     0 0 0 Donald Trump
191 191 russia 2017-05-17   659 Russian national 24 422 indictment     0 0 0 Donald Trump
192 192 russia 2017-05-17   659 Russian national 25 422 indictment     0 0 0 Donald Trump
193 193 russia 2017-05-17   659 Michael Cohen 561 guilty-plea 2018-11-29 561 0 0 1 Donald Trump
194 194 russia 2017-05-17   659 Roger Stone 618 indictment     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
);