Russia Investigation: russia-investigation.csv
Data license: CC Attribution 4.0 License · Data source: fivethirtyeight/data on GitHub · About: simonw/fivethirtyeight-datasette
4 rows where "cp-date" is on date 1973-01-15
This data as json, copyable, CSV (advanced)
Suggested facets: type, pardoned, investigation-end (date)
investigation-start (date) 1 ✖
Link | rowid ▼ | investigation | investigation-start | investigation-end | investigation-days | name | indictment-days | type | cp-date | cp-days | overturned | pardoned | american | president |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2 | 2 | watergate | 1973-05-19 | 1977-06-19 | 1492 | Bernard L. Barker | -246 | conviction | 1973-01-15 | -124 | 0 | 0 | 1 | Richard Nixon |
4 | 4 | watergate | 1973-05-19 | 1977-06-19 | 1492 | Eugenio R. Martinez | -246 | guilty-plea | 1973-01-15 | -124 | 0 | 1 | 1 | Richard Nixon |
6 | 6 | watergate | 1973-05-19 | 1977-06-19 | 1492 | Frank A. Sturgis | -246 | guilty-plea | 1973-01-15 | -124 | 0 | 0 | 1 | Richard Nixon |
7 | 7 | watergate | 1973-05-19 | 1977-06-19 | 1492 | Virgilio R. Gonzalez | -246 | guilty-plea | 1973-01-15 | -124 | 0 | 0 | 1 | Richard Nixon |
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 );