Members of the United States Congress

Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette

Custom SQL query returning 101 rows (hide)

This data as json, CSV

rowidtypestartendpartyhowexecutive_id
1 prez 1789-04-30 1793-03-04 no party election 1
2 prez 1793-03-04 1797-03-04 no party election 1
3 viceprez 1789-04-21 1793-03-04 Federalist election 2
4 viceprez 1793-03-04 1797-03-04 Federalist election 2
5 prez 1797-03-04 1801-03-04 Federalist election 2
6 viceprez 1797-03-04 1801-03-04 Democratic-Republican election 3
7 prez 1801-03-04 1805-03-04 Democratic-Republican election 3
8 prez 1805-03-04 1809-03-04 Democratic-Republican election 3
9 viceprez 1801-03-04 1805-03-04 Democratic-Republican election 4
10 viceprez 1805-03-04 1809-03-04 Democratic-Republican election 5
11 viceprez 1809-03-04 1812-04-20 Democratic-Republican election 5
12 viceprez 1813-03-04 1814-11-23 Democratic-Republican election 6
13 prez 1809-03-04 1813-03-04 Democratic-Republican election 7
14 prez 1813-03-04 1817-03-04 Democratic-Republican election 7
15 viceprez 1817-03-04 1821-03-05 Democratic-Republican election 8
16 viceprez 1821-03-05 1825-03-04 Democratic-Republican election 8
17 prez 1817-03-04 1821-03-05 Democratic-Republican election 9
18 prez 1821-03-05 1825-03-04 Democratic-Republican election 9
19 prez 1825-03-04 1829-03-04 Democratic-Republican election 10
20 viceprez 1825-03-04 1829-03-04 Democratic-Republican election 11
21 viceprez 1829-03-04 1832-12-28 Democrat election 11
22 prez 1829-03-04 1833-03-04 Democrat election 12
23 prez 1833-03-04 1837-03-04 Democrat election 12
24 viceprez 1837-03-04 1841-03-04 Democrat election 13
25 viceprez 1833-03-04 1837-03-04 Democrat election 14
26 prez 1837-03-04 1841-03-04 Democrat election 14
27 prez 1841-03-04 1841-04-04 Whig election 15
28 viceprez 1841-03-04 1841-04-04 Whig election 16
29 prez 1841-04-04 1845-03-04 Whig succession 16
30 viceprez 1845-03-04 1849-03-04 Democrat election 17
31 prez 1845-03-04 1849-03-04 Democrat election 18
32 prez 1849-03-04 1850-07-09 Whig election 19
33 viceprez 1849-03-04 1850-07-09 Whig election 20
34 prez 1850-07-09 1853-03-04 Whig succession 20
35 viceprez 1853-03-04 1853-04-18 Democrat election 21
36 prez 1853-03-04 1857-03-04 Democrat election 22
37 viceprez 1857-03-04 1861-03-04 Democrat election 23
38 prez 1857-03-04 1861-03-04 Democrat election 24
39 viceprez 1861-03-04 1865-03-04 Republican election 25
40 prez 1861-03-04 1865-03-04 Republican election 26
41 prez 1865-03-04 1865-04-15 Republican election 26
42 viceprez 1865-03-04 1865-04-15 Democrat election 27
43 prez 1865-04-15 1869-03-04 Democrat succession 27
44 viceprez 1869-03-04 1873-03-04 Republican election 28
45 viceprez 1873-03-04 1875-11-22 Republican election 29
46 prez 1869-03-04 1873-03-04 Republican election 30
47 prez 1873-03-04 1877-03-04 Republican election 30
48 viceprez 1877-03-04 1881-03-04 Republican election 31
49 prez 1877-03-04 1881-03-04 Republican election 32
50 prez 1881-03-04 1881-09-19 Republican election 33
51 viceprez 1881-03-04 1881-09-19 Republican election 34
52 prez 1881-09-19 1885-03-04 Republican succession 34
53 viceprez 1885-03-04 1885-11-25 Democrat election 35
54 viceprez 1889-03-04 1893-03-04 Republican election 36
55 prez 1889-03-04 1893-03-04 Republican election 37
56 viceprez 1893-03-04 1897-03-04 Democrat election 38
57 prez 1885-03-04 1889-03-04 Democrat election 39
58 prez 1893-03-04 1897-03-04 Democrat election 39
59 viceprez 1897-03-04 1899-11-21 Republican election 40
60 prez 1897-03-04 1901-03-04 Republican election 41
61 prez 1901-03-04 1901-09-14 Republican election 41
62 viceprez 1905-03-04 1909-03-04 Republican election 42
63 viceprez 1901-03-04 1901-09-14 Republican election 43
64 prez 1901-09-14 1905-03-04 Republican succession 43
65 prez 1905-03-04 1909-03-04 Republican election 43
66 viceprez 1909-03-04 1912-10-30 Republican election 44
67 prez 1909-03-04 1913-03-04 Republican election 45
68 viceprez 1913-03-04 1917-03-04 Democrat election 46
69 viceprez 1917-03-04 1921-03-04 Democrat election 46
70 prez 1913-03-04 1917-03-04 Democrat election 47
71 prez 1917-03-04 1921-03-04 Democrat election 47
72 prez 1921-03-04 1923-08-02 Republican election 48
73 viceprez 1925-03-04 1929-03-04 Republican election 49
74 viceprez 1921-03-04 1923-08-02 Republican election 50
75 prez 1923-08-02 1925-03-04 Republican succession 50
76 prez 1925-03-04 1929-03-04 Republican election 50
77 viceprez 1929-03-04 1933-03-04 Republican election 51
78 prez 1929-03-04 1933-03-04 Republican election 52
79 viceprez 1933-03-04 1937-01-20 Democrat election 53
80 viceprez 1937-01-20 1941-01-20 Democrat election 53
81 viceprez 1941-01-20 1945-01-20 Democrat election 54
82 prez 1933-03-04 1937-01-20 Democrat election 55
83 prez 1937-01-20 1941-01-20 Democrat election 55
84 prez 1941-01-20 1945-01-20 Democrat election 55
85 prez 1945-01-20 1945-04-12 Democrat election 55
86 viceprez 1949-01-20 1953-01-20 Democrat election 56
87 viceprez 1945-01-20 1945-04-12 Democrat election 57
88 prez 1945-04-12 1949-01-20 Democrat succession 57
89 prez 1949-01-20 1953-01-20 Democrat election 57
90 prez 1953-01-20 1957-01-20 Republican election 58
91 prez 1957-01-20 1961-01-20 Republican election 58
92 prez 1961-01-20 1963-11-22 Democrat election 59
93 viceprez 1965-01-20 1969-01-20 Democrat election 60
94 viceprez 1961-01-20 1963-11-22 Democrat election 61
95 prez 1963-11-22 1965-01-20 Democrat succession 61
96 prez 1965-01-20 1969-01-20 Democrat election 61
97 viceprez 1969-01-20 1973-01-20 Republican election 62
98 viceprez 1973-01-20 1973-10-10 Republican election 62
99 viceprez 1953-01-20 1957-01-20 Republican election 63
100 viceprez 1957-01-20 1961-01-20 Republican election 63
101 prez 1969-01-20 1973-01-20 Republican election 63