legislators: executive_terms: 131 rows

131 rows

Link	rowid	type	start	end	party	how	executive_id
1	1	prez	1789-04-30	1793-03-04	no party	election	George Washington 1
2	2	prez	1793-03-04	1797-03-04	no party	election	George Washington 1
3	3	viceprez	1789-04-21	1793-03-04	Federalist	election	John Adams 2
4	4	viceprez	1793-03-04	1797-03-04	Federalist	election	John Adams 2
5	5	prez	1797-03-04	1801-03-04	Federalist	election	John Adams 2
6	6	viceprez	1797-03-04	1801-03-04	Democratic-Republican	election	Thomas Jefferson 3
7	7	prez	1801-03-04	1805-03-04	Democratic-Republican	election	Thomas Jefferson 3
8	8	prez	1805-03-04	1809-03-04	Democratic-Republican	election	Thomas Jefferson 3
9	9	viceprez	1801-03-04	1805-03-04	Democratic-Republican	election	Aaron Burr 4
10	10	viceprez	1805-03-04	1809-03-04	Democratic-Republican	election	George Clinton 5
11	11	viceprez	1809-03-04	1812-04-20	Democratic-Republican	election	George Clinton 5
12	12	viceprez	1813-03-04	1814-11-23	Democratic-Republican	election	Elbridge Gerry 6
13	13	prez	1809-03-04	1813-03-04	Democratic-Republican	election	James Madison 7
14	14	prez	1813-03-04	1817-03-04	Democratic-Republican	election	James Madison 7
15	15	viceprez	1817-03-04	1821-03-05	Democratic-Republican	election	Daniel Tompkins 8
16	16	viceprez	1821-03-05	1825-03-04	Democratic-Republican	election	Daniel Tompkins 8
17	17	prez	1817-03-04	1821-03-05	Democratic-Republican	election	James Monroe 9
18	18	prez	1821-03-05	1825-03-04	Democratic-Republican	election	James Monroe 9
19	19	prez	1825-03-04	1829-03-04	Democratic-Republican	election	John Adams 10
20	20	viceprez	1825-03-04	1829-03-04	Democratic-Republican	election	John Calhoun 11
21	21	viceprez	1829-03-04	1832-12-28	Democrat	election	John Calhoun 11
22	22	prez	1829-03-04	1833-03-04	Democrat	election	Andrew Jackson 12
23	23	prez	1833-03-04	1837-03-04	Democrat	election	Andrew Jackson 12
24	24	viceprez	1837-03-04	1841-03-04	Democrat	election	Richard Johnson 13
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
27	27	prez	1841-03-04	1841-04-04	Whig	election	William Harrison 15
28	28	viceprez	1841-03-04	1841-04-04	Whig	election	John Tyler 16
29	29	prez	1841-04-04	1845-03-04	Whig	succession	John Tyler 16
30	30	viceprez	1845-03-04	1849-03-04	Democrat	election	George Dallas 17
31	31	prez	1845-03-04	1849-03-04	Democrat	election	James Polk 18
32	32	prez	1849-03-04	1850-07-09	Whig	election	Zachary Taylor 19
33	33	viceprez	1849-03-04	1850-07-09	Whig	election	Millard Fillmore 20
34	34	prez	1850-07-09	1853-03-04	Whig	succession	Millard Fillmore 20
35	35	viceprez	1853-03-04	1853-04-18	Democrat	election	William King 21
36	36	prez	1853-03-04	1857-03-04	Democrat	election	Franklin Pierce 22
37	37	viceprez	1857-03-04	1861-03-04	Democrat	election	John Breckinridge 23
38	38	prez	1857-03-04	1861-03-04	Democrat	election	James Buchanan 24
39	39	viceprez	1861-03-04	1865-03-04	Republican	election	Hannibal Hamlin 25
40	40	prez	1861-03-04	1865-03-04	Republican	election	Abraham Lincoln 26
41	41	prez	1865-03-04	1865-04-15	Republican	election	Abraham Lincoln 26
42	42	viceprez	1865-03-04	1865-04-15	Democrat	election	Andrew Johnson 27
43	43	prez	1865-04-15	1869-03-04	Democrat	succession	Andrew Johnson 27
44	44	viceprez	1869-03-04	1873-03-04	Republican	election	Schuyler Colfax 28
45	45	viceprez	1873-03-04	1875-11-22	Republican	election	Henry Wilson 29
46	46	prez	1869-03-04	1873-03-04	Republican	election	Ulysses Grant 30
47	47	prez	1873-03-04	1877-03-04	Republican	election	Ulysses Grant 30
48	48	viceprez	1877-03-04	1881-03-04	Republican	election	William Wheeler 31
49	49	prez	1877-03-04	1881-03-04	Republican	election	Rutherford Hayes 32
50	50	prez	1881-03-04	1881-09-19	Republican	election	James Garfield 33
51	51	viceprez	1881-03-04	1881-09-19	Republican	election	Chester Arthur 34
52	52	prez	1881-09-19	1885-03-04	Republican	succession	Chester Arthur 34
53	53	viceprez	1885-03-04	1885-11-25	Democrat	election	Thomas Hendricks 35
54	54	viceprez	1889-03-04	1893-03-04	Republican	election	Levi Morton 36
55	55	prez	1889-03-04	1893-03-04	Republican	election	Benjamin Harrison 37
56	56	viceprez	1893-03-04	1897-03-04	Democrat	election	Adlai Stevenson 38
57	57	prez	1885-03-04	1889-03-04	Democrat	election	Grover Cleveland 39
58	58	prez	1893-03-04	1897-03-04	Democrat	election	Grover Cleveland 39
59	59	viceprez	1897-03-04	1899-11-21	Republican	election	Garret Hobart 40
60	60	prez	1897-03-04	1901-03-04	Republican	election	William McKinley 41
61	61	prez	1901-03-04	1901-09-14	Republican	election	William McKinley 41
62	62	viceprez	1905-03-04	1909-03-04	Republican	election	Charles Fairbanks 42
63	63	viceprez	1901-03-04	1901-09-14	Republican	election	Theodore Roosevelt 43
64	64	prez	1901-09-14	1905-03-04	Republican	succession	Theodore Roosevelt 43
65	65	prez	1905-03-04	1909-03-04	Republican	election	Theodore Roosevelt 43
66	66	viceprez	1909-03-04	1912-10-30	Republican	election	James Sherman 44
67	67	prez	1909-03-04	1913-03-04	Republican	election	William Taft 45
68	68	viceprez	1913-03-04	1917-03-04	Democrat	election	Thomas Marshall 46
69	69	viceprez	1917-03-04	1921-03-04	Democrat	election	Thomas Marshall 46
70	70	prez	1913-03-04	1917-03-04	Democrat	election	Woodrow Wilson 47
71	71	prez	1917-03-04	1921-03-04	Democrat	election	Woodrow Wilson 47
72	72	prez	1921-03-04	1923-08-02	Republican	election	Warren Harding 48
73	73	viceprez	1925-03-04	1929-03-04	Republican	election	Charles Dawes 49
74	74	viceprez	1921-03-04	1923-08-02	Republican	election	Calvin Coolidge 50
75	75	prez	1923-08-02	1925-03-04	Republican	succession	Calvin Coolidge 50
76	76	prez	1925-03-04	1929-03-04	Republican	election	Calvin Coolidge 50
77	77	viceprez	1929-03-04	1933-03-04	Republican	election	Charles Curtis 51
78	78	prez	1929-03-04	1933-03-04	Republican	election	Herbert Hoover 52
79	79	viceprez	1933-03-04	1937-01-20	Democrat	election	John Garner 53
80	80	viceprez	1937-01-20	1941-01-20	Democrat	election	John Garner 53
81	81	viceprez	1941-01-20	1945-01-20	Democrat	election	Henry Wallace 54
82	82	prez	1933-03-04	1937-01-20	Democrat	election	Franklin Roosevelt 55
83	83	prez	1937-01-20	1941-01-20	Democrat	election	Franklin Roosevelt 55
84	84	prez	1941-01-20	1945-01-20	Democrat	election	Franklin Roosevelt 55
85	85	prez	1945-01-20	1945-04-12	Democrat	election	Franklin Roosevelt 55
86	86	viceprez	1949-01-20	1953-01-20	Democrat	election	Alben Barkley 56
87	87	viceprez	1945-01-20	1945-04-12	Democrat	election	Harry Truman 57
88	88	prez	1945-04-12	1949-01-20	Democrat	succession	Harry Truman 57
89	89	prez	1949-01-20	1953-01-20	Democrat	election	Harry Truman 57
90	90	prez	1953-01-20	1957-01-20	Republican	election	Dwight Eisenhower 58
91	91	prez	1957-01-20	1961-01-20	Republican	election	Dwight Eisenhower 58
92	92	prez	1961-01-20	1963-11-22	Democrat	election	John Kennedy 59
93	93	viceprez	1965-01-20	1969-01-20	Democrat	election	Hubert Humphrey 60
94	94	viceprez	1961-01-20	1963-11-22	Democrat	election	Lyndon Johnson 61
95	95	prez	1963-11-22	1965-01-20	Democrat	succession	Lyndon Johnson 61
96	96	prez	1965-01-20	1969-01-20	Democrat	election	Lyndon Johnson 61
97	97	viceprez	1969-01-20	1973-01-20	Republican	election	Spiro Agnew 62
98	98	viceprez	1973-01-20	1973-10-10	Republican	election	Spiro Agnew 62
99	99	viceprez	1953-01-20	1957-01-20	Republican	election	Richard Nixon 63
100	100	viceprez	1957-01-20	1961-01-20	Republican	election	Richard Nixon 63

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])
);