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 descending
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
6958 | 6958 | David Yulee Y000061 | rep | FL | 1843-12-04 | 1845-03-03 | Democrat | -1 | |||||||||||||
6959 | 6959 | David Yulee Y000061 | sen | FL | 1845-12-01 | 1851-03-03 | 1 | Democrat | |||||||||||||
6960 | 6960 | David Yulee Y000061 | sen | FL | 1855-12-03 | 1861-03-03 | 3 | Democrat | |||||||||||||
29088 | 29088 | Jesse Younger Y000060 | rep | CA | 1953-01-03 | 1955-01-03 | Republican | 9 | |||||||||||||
29089 | 29089 | Jesse Younger Y000060 | rep | CA | 1955-01-05 | 1957-01-03 | Republican | 9 | |||||||||||||
29090 | 29090 | Jesse Younger Y000060 | rep | CA | 1957-01-03 | 1959-01-03 | Republican | 9 | |||||||||||||
29091 | 29091 | Jesse Younger Y000060 | rep | CA | 1959-01-07 | 1961-01-03 | Republican | 9 | |||||||||||||
29092 | 29092 | Jesse Younger Y000060 | rep | CA | 1961-01-03 | 1963-01-03 | Republican | 9 | |||||||||||||
29093 | 29093 | Jesse Younger Y000060 | rep | CA | 1963-01-09 | 1965-01-03 | Republican | 11 | |||||||||||||
29094 | 29094 | Jesse Younger Y000060 | rep | CA | 1965-01-04 | 1967-01-03 | Republican | 11 | |||||||||||||
29095 | 29095 | Jesse Younger Y000060 | rep | CA | 1967-01-10 | 1969-01-03 | Republican | 11 | |||||||||||||
23330 | 23330 | Oscar Youngdahl Y000059 | rep | MN | 1939-01-03 | 1941-01-03 | Republican | 5 | |||||||||||||
23331 | 23331 | Oscar Youngdahl Y000059 | rep | MN | 1941-01-03 | 1943-01-03 | Republican | 5 | |||||||||||||
24720 | 24720 | Harold Youngblood Y000058 | rep | MI | 1947-01-03 | 1949-01-03 | Republican | 14 | |||||||||||||
3015 | 3015 | William Young Y000057 | rep | KY | 1825-12-05 | 1827-03-03 | Adams | 11 | |||||||||||||
3016 | 3016 | William Young Y000057 | rep | KY | 1827-12-03 | 1829-03-03 | -1 | ||||||||||||||
13839 | 13839 | William Young Y000056 | rep | VA | 1897-03-15 | 1899-03-03 | Democrat | 2 | |||||||||||||
13840 | 13840 | William Young Y000056 | rep | VA | 1899-12-04 | 1901-03-03 | Democrat | 2 | |||||||||||||
6179 | 6179 | Timothy Young Y000055 | rep | IL | 1849-12-03 | 1851-03-03 | Democrat | 3 | |||||||||||||
10618 | 10618 | Thomas Young Y000054 | rep | OH | 1879-03-18 | 1881-03-03 | Republican | 2 | |||||||||||||
10619 | 10619 | Thomas Young Y000054 | rep | OH | 1881-12-05 | 1883-03-03 | Republican | 2 | |||||||||||||
28746 | 28746 | Stephen Young Y000053 | rep | OH | 1933-03-09 | 1935-01-03 | Democrat | 0 | |||||||||||||
28747 | 28747 | Stephen Young Y000053 | rep | OH | 1935-01-03 | 1937-01-03 | Democrat | 0 | |||||||||||||
28748 | 28748 | Stephen Young Y000053 | rep | OH | 1941-01-03 | 1943-01-03 | Democrat | 0 | |||||||||||||
28749 | 28749 | Stephen Young Y000053 | rep | OH | 1949-01-03 | 1951-01-03 | Democrat | 0 | |||||||||||||
28750 | 28750 | Stephen Young Y000053 | sen | OH | 1959-01-07 | 1965-01-03 | 1 | Democrat | |||||||||||||
28751 | 28751 | Stephen Young Y000053 | sen | OH | 1965-01-04 | 1971-01-03 | 1 | Democrat | |||||||||||||
30772 | 30772 | Samuel Young Y000052 | rep | IL | 1973-01-03 | 1975-01-03 | Republican | 10 | |||||||||||||
33448 | 33448 | Robert Young Y000051 | rep | MO | 1977-01-04 | 1979-01-03 | Democrat | 2 | |||||||||||||
33449 | 33449 | Robert Young Y000051 | rep | MO | 1979-01-15 | 1981-01-03 | Democrat | 2 | |||||||||||||
33450 | 33450 | Robert Young Y000051 | rep | MO | 1981-01-05 | 1983-01-03 | Democrat | 2 | |||||||||||||
33451 | 33451 | Robert Young Y000051 | rep | MO | 1983-01-03 | 1985-01-03 | Democrat | 2 | |||||||||||||
33452 | 33452 | Robert Young Y000051 | rep | MO | 1985-01-03 | 1987-01-03 | Democrat | 2 | |||||||||||||
4386 | 4386 | Richard Young Y000050 | sen | IL | 1837-09-04 | 1843-03-03 | 3 | Democrat | |||||||||||||
15825 | 15825 | Richard Young Y000049 | rep | NY | 1909-03-15 | 1911-03-03 | Republican | 5 | |||||||||||||
9428 | 9428 | Pierce Young Y000048 | rep | GA | 1867-03-04 | 1869-03-03 | Democrat | 7 | |||||||||||||
9429 | 9429 | Pierce Young Y000048 | rep | GA | 1869-03-04 | 1871-03-03 | Democrat | 7 | |||||||||||||
9430 | 9430 | Pierce Young Y000048 | rep | GA | 1871-03-04 | 1873-03-03 | Democrat | 7 | |||||||||||||
9431 | 9431 | Pierce Young Y000048 | rep | GA | 1873-12-01 | 1875-03-03 | Democrat | 7 | |||||||||||||
31402 | 31402 | Milton Young Y000047 | sen | ND | 1945-03-12 | 1951-01-03 | 3 | Republican | appointment | ||||||||||||
31403 | 31403 | Milton Young Y000047 | sen | ND | 1951-01-03 | 1957-01-03 | 3 | Republican | |||||||||||||
31404 | 31404 | Milton Young Y000047 | sen | ND | 1957-01-03 | 1963-01-03 | 3 | Republican | |||||||||||||
31405 | 31405 | Milton Young Y000047 | sen | ND | 1963-01-09 | 1969-01-03 | 3 | Republican | |||||||||||||
31406 | 31406 | Milton Young Y000047 | sen | ND | 1969-01-03 | 1975-01-03 | 3 | Republican | |||||||||||||
31407 | 31407 | Milton Young Y000047 | sen | ND | 1975-01-14 | 1981-01-03 | 3 | Republican | |||||||||||||
15830 | 15830 | Lafayette Young Y000046 | sen | IA | 1910-01-01 | 1911-12-31 | 2 | Republican | |||||||||||||
9991 | 9991 | John Young Y000045 | rep | LA | 1877-10-15 | 1879-03-03 | Democrat | 5 | |||||||||||||
9427 | 9427 | John Young Y000044 | rep | KY | 1873-12-01 | 1875-03-03 | Democrat | 10 | |||||||||||||
31902 | 31902 | John Young Y000043 | rep | TX | 1957-01-03 | 1959-01-03 | Democrat | 14 | |||||||||||||
31903 | 31903 | John Young Y000043 | rep | TX | 1959-01-07 | 1961-01-03 | Democrat | 14 | |||||||||||||
31904 | 31904 | John Young Y000043 | rep | TX | 1961-01-03 | 1963-01-03 | Democrat | 14 | |||||||||||||
31905 | 31905 | John Young Y000043 | rep | TX | 1963-01-09 | 1965-01-03 | Democrat | 14 | |||||||||||||
31906 | 31906 | John Young Y000043 | rep | TX | 1965-01-04 | 1967-01-03 | Democrat | 14 | |||||||||||||
31907 | 31907 | John Young Y000043 | rep | TX | 1967-01-10 | 1969-01-03 | Democrat | 14 | |||||||||||||
31908 | 31908 | John Young Y000043 | rep | TX | 1969-01-03 | 1971-01-03 | Democrat | 14 | |||||||||||||
31909 | 31909 | John Young Y000043 | rep | TX | 1971-01-21 | 1973-01-03 | Democrat | 14 | |||||||||||||
31910 | 31910 | John Young Y000043 | rep | TX | 1973-01-03 | 1975-01-03 | Democrat | 14 | |||||||||||||
31911 | 31911 | John Young Y000043 | rep | TX | 1975-01-14 | 1977-01-03 | Democrat | 14 | |||||||||||||
31912 | 31912 | John Young Y000043 | rep | TX | 1977-01-04 | 1979-01-03 | Democrat | 14 | |||||||||||||
5093 | 5093 | John Young Y000042 | rep | NY | 1835-12-07 | 1837-03-03 | Whig | 30 | |||||||||||||
5094 | 5094 | John Young Y000042 | rep | NY | 1841-05-31 | 1843-03-03 | Whig | 30 | |||||||||||||
14221 | 14221 | James Young Y000041 | rep | PA | 1897-03-15 | 1899-03-03 | Republican | 4 | |||||||||||||
14222 | 14222 | James Young Y000041 | rep | PA | 1899-12-04 | 1901-03-03 | Republican | 4 | |||||||||||||
14223 | 14223 | James Young Y000041 | rep | PA | 1901-12-02 | 1903-03-03 | Republican | 4 | |||||||||||||
18026 | 18026 | James Young Y000040 | rep | TX | 1911-04-04 | 1913-03-03 | Democrat | 3 | |||||||||||||
18027 | 18027 | James Young Y000040 | rep | TX | 1913-04-07 | 1915-03-03 | Democrat | 3 | |||||||||||||
18028 | 18028 | James Young Y000040 | rep | TX | 1915-12-06 | 1917-03-03 | Democrat | 3 | |||||||||||||
18029 | 18029 | James Young Y000040 | rep | TX | 1917-04-02 | 1919-03-03 | Democrat | 3 | |||||||||||||
18030 | 18030 | James Young Y000040 | rep | TX | 1919-05-19 | 1921-03-03 | Democrat | 3 | |||||||||||||
16240 | 16240 | Isaac Young Y000039 | rep | KS | 1911-04-04 | 1913-03-03 | Republican | 6 | |||||||||||||
16646 | 16646 | Horace Young Y000038 | rep | MI | 1903-11-09 | 1905-03-03 | Republican | 12 | |||||||||||||
16647 | 16647 | Horace Young Y000038 | rep | MI | 1905-12-04 | 1907-03-03 | Republican | 12 | |||||||||||||
16648 | 16648 | Horace Young Y000038 | rep | MI | 1907-12-02 | 1909-03-03 | Republican | 12 | |||||||||||||
16649 | 16649 | Horace Young Y000038 | rep | MI | 1909-03-15 | 1911-03-03 | Republican | 12 | |||||||||||||
16650 | 16650 | Horace Young Y000038 | rep | MI | 1911-04-04 | 1913-03-03 | Republican | 12 | |||||||||||||
16651 | 16651 | Horace Young Y000038 | rep | MI | 1913-04-07 | 1915-03-03 | Republican | 12 | |||||||||||||
10945 | 10945 | Hiram Young Y000037 | rep | TN | 1875-12-06 | 1877-03-03 | Democrat | 10 | |||||||||||||
10946 | 10946 | Hiram Young Y000037 | rep | TN | 1877-10-15 | 1879-03-03 | Democrat | 10 | |||||||||||||
10947 | 10947 | Hiram Young Y000037 | rep | TN | 1879-03-18 | 1881-03-03 | Democrat | 10 | |||||||||||||
10948 | 10948 | Hiram Young Y000037 | rep | TN | 1883-12-03 | 1885-03-03 | Democrat | 10 | |||||||||||||
18901 | 18901 | George Young Y000036 | rep | ND | 1913-04-07 | 1915-03-03 | Republican | 2 | |||||||||||||
18902 | 18902 | George Young Y000036 | rep | ND | 1915-12-06 | 1917-03-03 | Republican | 2 | |||||||||||||
18903 | 18903 | George Young Y000036 | rep | ND | 1917-04-02 | 1919-03-03 | Republican | 2 | |||||||||||||
18904 | 18904 | George Young Y000036 | rep | ND | 1919-05-19 | 1921-03-03 | Republican | 2 | |||||||||||||
18905 | 18905 | George Young Y000036 | rep | ND | 1921-04-11 | 1923-03-03 | Republican | 2 | |||||||||||||
18906 | 18906 | George Young Y000036 | rep | ND | 1923-12-03 | 1925-03-03 | Republican | 2 | |||||||||||||
30771 | 30771 | Edward Young Y000035 | rep | SC | 1973-01-03 | 1975-01-03 | Republican | 6 | |||||||||||||
3826 | 3826 | Ebenezer Young Y000034 | rep | CT | 1829-12-07 | 1831-03-03 | -1 | ||||||||||||||
3827 | 3827 | Ebenezer Young Y000034 | rep | CT | 1831-12-05 | 1833-03-03 | -1 | ||||||||||||||
3828 | 3828 | Ebenezer Young Y000034 | rep | CT | 1833-12-02 | 1835-03-03 | -1 | ||||||||||||||
41664 | 41664 | Don Young Y000033 | rep | AK | 1973-03-06 | 1975-01-03 | Republican | 0 | |||||||||||||
41665 | 41665 | Don Young Y000033 | rep | AK | 1975-01-14 | 1977-01-03 | Republican | 0 | |||||||||||||
41666 | 41666 | Don Young Y000033 | rep | AK | 1977-01-04 | 1979-01-03 | Republican | 0 | |||||||||||||
41667 | 41667 | Don Young Y000033 | rep | AK | 1979-01-15 | 1981-01-03 | Republican | 0 | |||||||||||||
41668 | 41668 | Don Young Y000033 | rep | AK | 1981-01-05 | 1983-01-03 | Republican | 0 | |||||||||||||
41669 | 41669 | Don Young Y000033 | rep | AK | 1983-01-03 | 1985-01-03 | Republican | 0 | |||||||||||||
41670 | 41670 | Don Young Y000033 | rep | AK | 1985-01-03 | 1987-01-03 | Republican | 0 | |||||||||||||
41671 | 41671 | Don Young Y000033 | rep | AK | 1987-01-06 | 1989-01-03 | Republican | 0 | |||||||||||||
41672 | 41672 | Don Young Y000033 | rep | AK | 1989-01-03 | 1991-01-03 | Republican | 0 | |||||||||||||
41673 | 41673 | Don Young Y000033 | rep | AK | 1991-01-03 | 1993-01-03 | Republican | 0 |
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);