executive_terms
2 rows where executive_id = 14
This data as json, CSV (advanced)
Suggested facets: start (date), end (date)
| Link | rowid ▼ | type | start | end | party | how | executive_id |
|---|---|---|---|---|---|---|---|
| 25 | 25 | viceprez | 1833-03-04 | 1837-03-04 | Democrat | election | Martin Van Buren 14 |
| 26 | 26 | prez | 1837-03-04 | 1841-03-04 | Democrat | election | Martin Van Buren 14 |
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")
);