executive_terms
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
2 rows where how = "appointment" sorted by type
This data as json, copyable, CSV (advanced)
Suggested facets: start (date)
end (date) 2 ✖
- 1974-08-09 1
- 1977-01-20 1
Link | rowid | type ▼ | start | end | party | how | executive_id |
---|---|---|---|---|---|---|---|
103 | 103 | viceprez | 1973-12-06 | 1974-08-09 | Republican | appointment | Gerald Ford 64 |
105 | 105 | viceprez | 1974-12-19 | 1977-01-20 | Republican | appointment | Nelson Rockefeller 65 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE [executive_terms] ( [type] TEXT, [start] TEXT, [end] TEXT, [party] TEXT, [how] TEXT, [executive_id] INTEGER REFERENCES [executives]([id]) );