legislator_terms
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
44,551 rows sorted by legislator_id
This data as json, copyable, CSV (advanced)
Link | rowid | legislator_id ▼ | type | state | start | end | class | party | district | how | party_affiliations | url | caucus | address | phone | fax | contact_form | office | state_rank | rss_url | end-type |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
32895 | 32895 | Donald Albosta A000076 | rep | MI | 1979-01-15 | 1981-01-03 | Democrat | 10 | |||||||||||||
32896 | 32896 | Donald Albosta A000076 | rep | MI | 1981-01-05 | 1983-01-03 | Democrat | 10 | |||||||||||||
32897 | 32897 | Donald Albosta A000076 | rep | MI | 1983-01-03 | 1985-01-03 | Democrat | 10 | |||||||||||||
9072 | 9072 | Charles Albright A000077 | rep | PA | 1873-12-01 | 1875-03-03 | Republican | -1 | |||||||||||||
6754 | 6754 | Charles Albright A000078 | rep | OH | 1855-12-03 | 1857-03-03 | Ind. Republican-Democrat | 17 | |||||||||||||
8799 | 8799 | James Alcorn A000079 | sen | MS | 1871-03-04 | 1877-03-03 | 2 | Republican | |||||||||||||
12395 | 12395 | John Alderson A000080 | rep | WV | 1889-12-02 | 1891-03-03 | Democrat | 3 | |||||||||||||
12396 | 12396 | John Alderson A000080 | rep | WV | 1891-12-07 | 1893-03-03 | Democrat | 3 | |||||||||||||
12397 | 12397 | John Alderson A000080 | rep | WV | 1893-08-07 | 1895-03-03 | Democrat | 3 | |||||||||||||
7650 | 7650 | Cyrus Aldrich A000081 | rep | MN | 1859-12-05 | 1861-03-03 | Republican | -1 | |||||||||||||
7651 | 7651 | Cyrus Aldrich A000081 | rep | MN | 1861-07-04 | 1863-03-03 | Republican | -1 | |||||||||||||
12893 | 12893 | James Aldrich A000082 | rep | IL | 1893-08-07 | 1895-03-03 | Republican | 1 | |||||||||||||
12894 | 12894 | James Aldrich A000082 | rep | IL | 1895-12-02 | 1897-03-03 | Republican | 1 | |||||||||||||
14555 | 14555 | Nelson Aldrich A000083 | rep | RI | 1879-03-18 | 1881-03-03 | Republican | 1 | |||||||||||||
14556 | 14556 | Nelson Aldrich A000083 | rep | RI | 1881-03-04 | 1881-10-04 | Republican | 1 | |||||||||||||
14557 | 14557 | Nelson Aldrich A000083 | sen | RI | 1881-10-05 | 1887-03-03 | 1 | Republican | |||||||||||||
14558 | 14558 | Nelson Aldrich A000083 | sen | RI | 1887-12-05 | 1893-03-03 | 1 | Republican | |||||||||||||
14559 | 14559 | Nelson Aldrich A000083 | sen | RI | 1893-08-07 | 1899-03-03 | 1 | Republican | |||||||||||||
14560 | 14560 | Nelson Aldrich A000083 | sen | RI | 1899-12-04 | 1905-03-03 | 1 | Republican | |||||||||||||
14561 | 14561 | Nelson Aldrich A000083 | sen | RI | 1905-12-04 | 1911-03-03 | 1 | Republican | |||||||||||||
20084 | 20084 | Richard Aldrich A000084 | rep | RI | 1923-12-03 | 1925-03-03 | Republican | 2 | |||||||||||||
20085 | 20085 | Richard Aldrich A000084 | rep | RI | 1925-12-07 | 1927-03-04 | Republican | 2 | |||||||||||||
20086 | 20086 | Richard Aldrich A000084 | rep | RI | 1927-12-05 | 1929-03-03 | Republican | 2 | |||||||||||||
20087 | 20087 | Richard Aldrich A000084 | rep | RI | 1929-04-15 | 1931-03-03 | Republican | 2 | |||||||||||||
20088 | 20088 | Richard Aldrich A000084 | rep | RI | 1931-12-07 | 1933-03-03 | Republican | 2 | |||||||||||||
12895 | 12895 | Truman Aldrich A000085 | rep | AL | 1895-12-02 | 1897-03-03 | Republican | 9 | |||||||||||||
10250 | 10250 | William Aldrich A000086 | rep | IL | 1877-10-15 | 1879-03-03 | Republican | 1 | |||||||||||||
10251 | 10251 | William Aldrich A000086 | rep | IL | 1879-03-18 | 1881-03-03 | Republican | 1 | |||||||||||||
10252 | 10252 | William Aldrich A000086 | rep | IL | 1881-12-05 | 1883-03-03 | Republican | 1 | |||||||||||||
13545 | 13545 | William Aldrich A000087 | rep | AL | 1895-12-02 | 1897-03-03 | Republican | 4 | |||||||||||||
13546 | 13546 | William Aldrich A000087 | rep | AL | 1897-03-15 | 1899-03-03 | Republican | 4 | |||||||||||||
13547 | 13547 | William Aldrich A000087 | rep | AL | 1899-12-04 | 1901-03-03 | Republican | 4 | |||||||||||||
22021 | 22021 | Arthur Aleshire A000088 | rep | OH | 1937-01-05 | 1939-01-03 | Democrat | 7 | |||||||||||||
2547 | 2547 | Adam Alexander A000089 | rep | TN | 1823-12-01 | 1825-03-03 | Jacksonian Republican | 9 | |||||||||||||
2548 | 2548 | Adam Alexander A000089 | rep | TN | 1825-12-05 | 1827-03-03 | Jackson | 9 | |||||||||||||
10623 | 10623 | Armstead Alexander A000090 | rep | MO | 1883-12-03 | 1885-03-03 | Democrat | 2 | |||||||||||||
15323 | 15323 | De Alexander A000091 | rep | NY | 1897-03-15 | 1899-03-03 | Republican | 33 | |||||||||||||
15324 | 15324 | De Alexander A000091 | rep | NY | 1899-12-04 | 1901-03-03 | Republican | 33 | |||||||||||||
15325 | 15325 | De Alexander A000091 | rep | NY | 1901-12-02 | 1903-03-03 | Republican | 33 | |||||||||||||
15326 | 15326 | De Alexander A000091 | rep | NY | 1903-11-09 | 1905-03-03 | Republican | 36 | |||||||||||||
15327 | 15327 | De Alexander A000091 | rep | NY | 1905-12-04 | 1907-03-03 | Republican | 36 | |||||||||||||
15328 | 15328 | De Alexander A000091 | rep | NY | 1907-12-02 | 1909-03-03 | Republican | 36 | |||||||||||||
15329 | 15329 | De Alexander A000091 | rep | NY | 1909-03-15 | 1911-03-03 | Republican | 36 | |||||||||||||
798 | 798 | Evan Alexander A000092 | rep | NC | 1806-02-24 | 1807-03-03 | Republican | 10 | |||||||||||||
799 | 799 | Evan Alexander A000092 | rep | NC | 1807-10-26 | 1809-03-03 | Republican | 10 | |||||||||||||
5890 | 5890 | Henry Alexander A000093 | rep | NY | 1849-12-03 | 1851-03-03 | Whig | 17 | |||||||||||||
27068 | 27068 | Hugh Alexander A000094 | rep | NC | 1953-01-03 | 1955-01-03 | Democrat | 9 | |||||||||||||
27069 | 27069 | Hugh Alexander A000094 | rep | NC | 1955-01-05 | 1957-01-03 | Democrat | 9 | |||||||||||||
27070 | 27070 | Hugh Alexander A000094 | rep | NC | 1957-01-03 | 1959-01-03 | Democrat | 9 | |||||||||||||
27071 | 27071 | Hugh Alexander A000094 | rep | NC | 1959-01-07 | 1961-01-03 | Democrat | 9 | |||||||||||||
27072 | 27072 | Hugh Alexander A000094 | rep | NC | 1961-01-03 | 1963-01-03 | Democrat | 9 | |||||||||||||
4125 | 4125 | James Alexander A000095 | rep | OH | 1837-09-04 | 1839-03-03 | Whig | 11 | |||||||||||||
1448 | 1448 | John Alexander A000096 | rep | OH | 1813-05-24 | 1815-03-03 | Republican | 2 | |||||||||||||
1449 | 1449 | John Alexander A000096 | rep | OH | 1815-12-04 | 1817-03-03 | Republican | 2 | |||||||||||||
22471 | 22471 | John Alexander A000097 | rep | MN | 1939-01-03 | 1941-01-03 | Republican | 3 | |||||||||||||
17532 | 17532 | Joshua Alexander A000098 | rep | MO | 1907-12-02 | 1909-03-03 | Democrat | 3 | |||||||||||||
17533 | 17533 | Joshua Alexander A000098 | rep | MO | 1909-03-15 | 1911-03-03 | Democrat | 3 | |||||||||||||
17534 | 17534 | Joshua Alexander A000098 | rep | MO | 1911-04-04 | 1913-03-03 | Democrat | 3 | |||||||||||||
17535 | 17535 | Joshua Alexander A000098 | rep | MO | 1913-04-07 | 1915-03-03 | Democrat | 3 | |||||||||||||
17536 | 17536 | Joshua Alexander A000098 | rep | MO | 1915-12-06 | 1917-03-03 | Democrat | 3 | |||||||||||||
17537 | 17537 | Joshua Alexander A000098 | rep | MO | 1917-04-02 | 1919-03-03 | Democrat | 3 | |||||||||||||
17538 | 17538 | Joshua Alexander A000098 | rep | MO | 1919-05-19 | 1921-03-03 | Democrat | 3 | |||||||||||||
3286 | 3286 | Mark Alexander A000099 | rep | VA | 1819-12-06 | 1821-03-03 | Republican | 18 | |||||||||||||
3287 | 3287 | Mark Alexander A000099 | rep | VA | 1821-12-03 | 1823-03-03 | Republican | 18 | |||||||||||||
3288 | 3288 | Mark Alexander A000099 | rep | VA | 1823-12-01 | 1825-03-03 | Jacksonian | 4 | |||||||||||||
3289 | 3289 | Mark Alexander A000099 | rep | VA | 1825-12-05 | 1827-03-03 | Jackson | 4 | |||||||||||||
3290 | 3290 | Mark Alexander A000099 | rep | VA | 1827-12-03 | 1829-03-03 | Jackson | 4 | |||||||||||||
3291 | 3291 | Mark Alexander A000099 | rep | VA | 1829-12-07 | 1831-03-03 | Jackson | 4 | |||||||||||||
3292 | 3292 | Mark Alexander A000099 | rep | VA | 1831-12-05 | 1833-03-03 | Jackson | 4 | |||||||||||||
650 | 650 | Nathaniel Alexander A000100 | rep | NC | 1803-03-04 | 1805-03-03 | Republican | 10 | |||||||||||||
12398 | 12398 | Sydenham Alexander A000102 | rep | NC | 1891-12-07 | 1893-03-03 | Democrat | 6 | |||||||||||||
12399 | 12399 | Sydenham Alexander A000102 | rep | NC | 1893-08-07 | 1895-03-03 | Democrat | 6 | |||||||||||||
34162 | 34162 | William Alexander A000103 | rep | AR | 1969-01-03 | 1971-01-03 | Democrat | 1 | |||||||||||||
34163 | 34163 | William Alexander A000103 | rep | AR | 1971-01-21 | 1973-01-03 | Democrat | 1 | |||||||||||||
34164 | 34164 | William Alexander A000103 | rep | AR | 1973-01-03 | 1975-01-03 | Democrat | 1 | |||||||||||||
34165 | 34165 | William Alexander A000103 | rep | AR | 1975-01-14 | 1977-01-03 | Democrat | 1 | |||||||||||||
34166 | 34166 | William Alexander A000103 | rep | AR | 1977-01-04 | 1979-01-03 | Democrat | 1 | |||||||||||||
34167 | 34167 | William Alexander A000103 | rep | AR | 1979-01-15 | 1981-01-03 | Democrat | 1 | |||||||||||||
34168 | 34168 | William Alexander A000103 | rep | AR | 1981-01-05 | 1983-01-03 | Democrat | 1 | |||||||||||||
34169 | 34169 | William Alexander A000103 | rep | AR | 1983-01-03 | 1985-01-03 | Democrat | 1 | |||||||||||||
34170 | 34170 | William Alexander A000103 | rep | AR | 1985-01-03 | 1987-01-03 | Democrat | 1 | |||||||||||||
34171 | 34171 | William Alexander A000103 | rep | AR | 1987-01-06 | 1989-01-03 | Democrat | 1 | |||||||||||||
34172 | 34172 | William Alexander A000103 | rep | AR | 1989-01-03 | 1991-01-03 | Democrat | 1 | |||||||||||||
34173 | 34173 | William Alexander A000103 | rep | AR | 1991-01-03 | 1993-01-03 | Democrat | 1 | |||||||||||||
4658 | 4658 | Julius Alford A000104 | rep | GA | 1835-12-07 | 1837-03-03 | Whig | -1 | |||||||||||||
4659 | 4659 | Julius Alford A000104 | rep | GA | 1839-12-02 | 1841-03-03 | Whig | -1 | |||||||||||||
4660 | 4660 | Julius Alford A000104 | rep | GA | 1841-05-31 | 1843-03-03 | Whig | -1 | |||||||||||||
27073 | 27073 | Thomas Alford A000105 | rep | AR | 1959-01-07 | 1961-01-03 | Ind. Democrat | 5 | |||||||||||||
27074 | 27074 | Thomas Alford A000105 | rep | AR | 1961-01-03 | 1963-01-03 | Democrat | 5 | |||||||||||||
27603 | 27603 | Bruce Alger A000106 | rep | TX | 1955-01-05 | 1957-01-03 | Republican | 5 | |||||||||||||
27604 | 27604 | Bruce Alger A000106 | rep | TX | 1957-01-03 | 1959-01-03 | Republican | 5 | |||||||||||||
27605 | 27605 | Bruce Alger A000106 | rep | TX | 1959-01-07 | 1961-01-03 | Republican | 5 | |||||||||||||
27606 | 27606 | Bruce Alger A000106 | rep | TX | 1961-01-03 | 1963-01-03 | Republican | 5 | |||||||||||||
27607 | 27607 | Bruce Alger A000106 | rep | TX | 1963-01-09 | 1965-01-03 | Republican | 5 | |||||||||||||
14224 | 14224 | Russell Alger A000107 | sen | MI | 1902-01-01 | 1907-03-03 | 2 | Republican | |||||||||||||
3831 | 3831 | Chilton Allan A000108 | rep | KY | 1831-12-05 | 1833-03-03 | Whig | 3 | |||||||||||||
3832 | 3832 | Chilton Allan A000108 | rep | KY | 1833-12-02 | 1835-03-03 | Whig | 10 | |||||||||||||
3833 | 3833 | Chilton Allan A000108 | rep | KY | 1835-12-07 | 1837-03-03 | Whig | 10 | |||||||||||||
37224 | 37224 | Wayne Allard A000109 | rep | CO | 1991-01-03 | 1993-01-03 | Republican | 4 | |||||||||||||
37225 | 37225 | Wayne Allard A000109 | rep | CO | 1993-01-05 | 1995-01-03 | Republican | 4 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE [legislator_terms] ( [legislator_id] TEXT REFERENCES [legislators]([id]), [type] TEXT, [state] TEXT, [start] TEXT, [end] TEXT, [class] INTEGER, [party] TEXT , [district] INTEGER, [how] TEXT, [party_affiliations] TEXT, [url] TEXT, [caucus] TEXT, [address] TEXT, [phone] TEXT, [fax] TEXT, [contact_form] TEXT, [office] TEXT, [state_rank] TEXT, [rss_url] TEXT, [end-type] TEXT);