legislator_terms
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
1,277 rows where class = 1 sorted by state
This data as json, copyable, CSV (advanced)
Suggested facets: rss_url, start (date), end (date)
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
21622 | 21622 | Henry Ashurst A000319 | sen | AZ | 1912-03-27 | 1917-03-03 | 1 | Democrat | |||||||||||||
21623 | 21623 | Henry Ashurst A000319 | sen | AZ | 1917-04-02 | 1923-03-03 | 1 | Democrat | |||||||||||||
21624 | 21624 | Henry Ashurst A000319 | sen | AZ | 1923-12-03 | 1929-03-03 | 1 | Democrat | |||||||||||||
21625 | 21625 | Henry Ashurst A000319 | sen | AZ | 1929-04-15 | 1935-01-03 | 1 | Democrat | |||||||||||||
21626 | 21626 | Henry Ashurst A000319 | sen | AZ | 1935-01-03 | 1941-01-03 | 1 | Democrat | |||||||||||||
24600 | 24600 | Ernest McFarland M000438 | sen | AZ | 1941-01-03 | 1947-01-03 | 1 | Democrat | |||||||||||||
24601 | 24601 | Ernest McFarland M000438 | sen | AZ | 1947-01-03 | 1953-01-03 | 1 | Democrat | |||||||||||||
29771 | 29771 | Paul Fannin F000013 | sen | AZ | 1965-01-04 | 1971-01-03 | 1 | Republican | |||||||||||||
29772 | 29772 | Paul Fannin F000013 | sen | AZ | 1971-01-21 | 1977-01-03 | 1 | Republican | |||||||||||||
32678 | 32678 | Barry Goldwater G000267 | sen | AZ | 1953-01-03 | 1959-01-03 | 1 | Republican | |||||||||||||
32679 | 32679 | Barry Goldwater G000267 | sen | AZ | 1959-01-07 | 1965-01-03 | 1 | Republican | |||||||||||||
33877 | 33877 | Dennis DeConcini D000185 | sen | AZ | 1977-01-04 | 1983-01-03 | 1 | Democrat | |||||||||||||
33878 | 33878 | Dennis DeConcini D000185 | sen | AZ | 1983-01-03 | 1989-01-03 | 1 | Democrat | |||||||||||||
33879 | 33879 | Dennis DeConcini D000185 | sen | AZ | 1989-01-03 | 1995-01-03 | 1 | Democrat | |||||||||||||
40663 | 40663 | Jon Kyl K000352 | sen | AZ | 1995-01-04 | 2001-01-03 | 1 | Republican | |||||||||||||
40664 | 40664 | Jon Kyl K000352 | sen | AZ | 2001-01-03 | 2007-01-03 | 1 | Republican | http://kyl.senate.gov/ | ||||||||||||
40665 | 40665 | Jon Kyl K000352 | sen | AZ | 2007-01-04 | 2013-01-03 | 1 | Republican | http://kyl.senate.gov/ | 730 HART SENATE OFFICE BUILDING WASHINGTON DC 20510 | 202-224-4521 | 202-224-2207 | http://www.kyl.senate.gov/contact.cfm | 730 Hart Senate Office Building | |||||||
40804 | 40804 | Jeff Flake F000444 | sen | AZ | 2013-01-03 | 2019-01-03 | 1 | Republican | https://www.flake.senate.gov/public | 413 Russell Senate Office Building Washington DC 20510 | 202-224-4521 | 202-226-4386 | https://www.flake.senate.gov/public/index.cfm/contact-jeff | 413 Russell Senate Office Building | senior | http://www.flake.senate.gov/public/index.cfm/rss/feed | |||||
43707 | 43707 | Kyrsten Sinema S001191 | sen | AZ | 2019-01-03 | 2025-01-03 | 1 | Democrat | https://www.sinema.senate.gov | 317 Hart Senate Office Building Washington DC 20510 | 202-224-4521 | https://www.sinema.senate.gov/contact-kyrsten | 317 Hart Senate Office Building | senior | |||||||
6188 | 6188 | John Frémont F000374 | sen | CA | 1850-01-01 | 1851-03-03 | 1 | Democrat | |||||||||||||
6482 | 6482 | John Weller W000274 | sen | CA | 1852-01-01 | 1857-03-03 | 1 | Democrat | |||||||||||||
6994 | 6994 | David Broderick B000857 | sen | CA | 1857-12-07 | 1859-12-31 | 1 | Democrat | |||||||||||||
7438 | 7438 | Henry Haun H000353 | sen | CA | 1859-12-05 | 1861-03-03 | 1 | Democrat | |||||||||||||
7646 | 7646 | Milton Latham L000110 | sen | CA | 1860-01-01 | 1863-03-03 | 1 | Democrat | |||||||||||||
7931 | 7931 | John Conness C000695 | sen | CA | 1863-12-07 | 1869-03-03 | 1 | Republican | |||||||||||||
8542 | 8542 | Eugene Casserly C000236 | sen | CA | 1869-03-04 | 1873-12-31 | 1 | Democrat | |||||||||||||
9185 | 9185 | John Hager H000016 | sen | CA | 1873-12-01 | 1875-03-03 | 1 | Democrat | |||||||||||||
9452 | 9452 | Newton Booth B000630 | sen | CA | 1875-12-06 | 1881-03-03 | 1 | Republican | |||||||||||||
10464 | 10464 | John Miller M000740 | sen | CA | 1881-12-05 | 1887-03-03 | 1 | Republican | |||||||||||||
11282 | 11282 | Abram Williams W000486 | sen | CA | 1886-01-01 | 1887-03-03 | 1 | Republican | |||||||||||||
11390 | 11390 | George Hearst H000428 | sen | CA | 1886-01-01 | 1887-03-03 | 1 | Democrat | |||||||||||||
11391 | 11391 | George Hearst H000428 | sen | CA | 1887-12-05 | 1891-12-31 | 1 | Democrat | |||||||||||||
12156 | 12156 | Charles Felton F000068 | sen | CA | 1891-12-07 | 1893-03-03 | 1 | Republican | |||||||||||||
12852 | 12852 | Stephen White W000394 | sen | CA | 1893-08-07 | 1899-03-03 | 1 | Democrat | |||||||||||||
13842 | 13842 | Thomas Bard B000138 | sen | CA | 1900-01-01 | 1905-03-03 | 1 | Republican | |||||||||||||
14662 | 14662 | Frank Flint F000207 | sen | CA | 1905-12-04 | 1911-03-03 | 1 | Republican | |||||||||||||
16239 | 16239 | John Works W000743 | sen | CA | 1911-04-04 | 1917-03-03 | 1 | Republican | |||||||||||||
23072 | 23072 | Hiram Johnson J000140 | sen | CA | 1917-04-02 | 1923-03-03 | 1 | Republican | |||||||||||||
23073 | 23073 | Hiram Johnson J000140 | sen | CA | 1923-12-03 | 1929-03-03 | 1 | Republican | |||||||||||||
23074 | 23074 | Hiram Johnson J000140 | sen | CA | 1929-04-15 | 1935-01-03 | 1 | Republican | |||||||||||||
23075 | 23075 | Hiram Johnson J000140 | sen | CA | 1935-01-03 | 1941-01-03 | 1 | Republican | |||||||||||||
23076 | 23076 | Hiram Johnson J000140 | sen | CA | 1941-01-03 | 1945-12-31 | 1 | Republican | |||||||||||||
25740 | 25740 | William Knowland K000292 | sen | CA | 1945-08-14 | 1947-01-03 | 1 | Republican | appointment | ||||||||||||
25741 | 25741 | William Knowland K000292 | sen | CA | 1947-01-03 | 1953-01-03 | 1 | Republican | |||||||||||||
25742 | 25742 | William Knowland K000292 | sen | CA | 1953-01-03 | 1959-01-03 | 1 | Republican | |||||||||||||
26846 | 26846 | Clair Engle E000181 | sen | CA | 1959-01-07 | 1965-01-03 | 1 | Democrat | |||||||||||||
28308 | 28308 | Pierre Salinger S000016 | sen | CA | 1964-08-04 | 1965-01-03 | 1 | Democrat | appointment | ||||||||||||
28586 | 28586 | George Murphy M001092 | sen | CA | 1965-01-04 | 1971-01-03 | 1 | Republican | |||||||||||||
30116 | 30116 | John Tunney T000410 | sen | CA | 1971-01-21 | 1977-01-03 | 1 | Democrat | |||||||||||||
31590 | 31590 | Samuel Hayakawa H000384 | sen | CA | 1977-01-04 | 1983-01-03 | 1 | Republican | |||||||||||||
34140 | 34140 | Pete Wilson W000607 | sen | CA | 1983-01-03 | 1989-01-03 | 1 | Republican | |||||||||||||
34141 | 34141 | Pete Wilson W000607 | sen | CA | 1989-01-03 | 1991-12-31 | 1 | Republican | |||||||||||||
34950 | 34950 | John Seymour S000269 | sen | CA | 1991-01-07 | 1993-01-03 | 1 | Republican | appointment | ||||||||||||
41770 | 41770 | Dianne Feinstein F000062 | sen | CA | 1992-11-10 | 1995-01-03 | 1 | Democrat | |||||||||||||
41771 | 41771 | Dianne Feinstein F000062 | sen | CA | 1995-01-04 | 2001-01-03 | 1 | Democrat | |||||||||||||
41772 | 41772 | Dianne Feinstein F000062 | sen | CA | 2001-01-03 | 2007-01-03 | 1 | Democrat | http://feinstein.senate.gov | ||||||||||||
41773 | 41773 | Dianne Feinstein F000062 | sen | CA | 2007-01-04 | 2013-01-03 | 1 | Democrat | http://feinstein.senate.gov | 331 HART SENATE OFFICE BUILDING WASHINGTON DC 20510 | 202-224-3841 | 202-228-3954 | http://www.feinstein.senate.gov/public/index.cfm/e-mail-me | 331 Hart Senate Office Building | |||||||
41774 | 41774 | Dianne Feinstein F000062 | sen | CA | 2013-01-03 | 2019-01-03 | 1 | Democrat | https://www.feinstein.senate.gov | 331 Hart Senate Office Building Washington DC 20510 | 202-224-3841 | 202-228-3954 | https://www.feinstein.senate.gov/public/index.cfm/e-mail-me | 331 Hart Senate Office Building | senior | http://www.feinstein.senate.gov/public/?a=rss.feed | |||||
41775 | 41775 | Dianne Feinstein F000062 | sen | CA | 2019-01-03 | 2025-01-03 | 1 | Democrat | https://www.feinstein.senate.gov | 331 Hart Senate Office Building Washington DC 20510 | 202-224-3841 | https://www.feinstein.senate.gov/public/index.cfm/e-mail-me | 331 Hart Senate Office Building | senior | http://www.feinstein.senate.gov/public/?a=rss.feed | ||||||
38 | 38 | Oliver Ellsworth E000147 | sen | CT | 1789-03-04 | 1791-03-03 | 1 | Pro-Administration | |||||||||||||
39 | 39 | Oliver Ellsworth E000147 | sen | CT | 1791-10-24 | 1797-03-03 | 1 | Federalist | |||||||||||||
986 | 986 | James Hillhouse H000618 | sen | CT | 1796-05-18 | 1797-03-03 | 1 | Federalist | |||||||||||||
987 | 987 | James Hillhouse H000618 | sen | CT | 1797-03-04 | 1803-03-03 | 1 | Federalist | |||||||||||||
988 | 988 | James Hillhouse H000618 | sen | CT | 1803-03-04 | 1809-03-03 | 1 | Federalist | |||||||||||||
989 | 989 | James Hillhouse H000618 | sen | CT | 1809-05-22 | 1810-06-10 | 1 | Federalist | |||||||||||||
1539 | 1539 | Samuel Dana D000024 | sen | CT | 1810-12-04 | 1815-03-03 | 1 | Federalist | |||||||||||||
1540 | 1540 | Samuel Dana D000024 | sen | CT | 1815-12-04 | 1821-03-03 | 1 | Federalist | |||||||||||||
2204 | 2204 | Elijah Boardman B000577 | sen | CT | 1821-12-03 | 1823-12-31 | 1 | Republican | |||||||||||||
2408 | 2408 | Henry Edwards E000070 | sen | CT | 1823-12-01 | 1827-03-03 | 1 | Jackson | |||||||||||||
3676 | 3676 | Samuel Foot F000247 | sen | CT | 1827-12-03 | 1833-03-03 | 1 | Adams | |||||||||||||
3795 | 3795 | Nathan Smith S000594 | sen | CT | 1833-12-02 | 1835-12-31 | 1 | Anti-Jacksonian | |||||||||||||
4402 | 4402 | Thaddeus Betts B000428 | sen | CT | 1839-12-02 | 1841-03-03 | 1 | Whig | |||||||||||||
5256 | 5256 | John Niles N000108 | sen | CT | 1835-12-07 | 1839-03-03 | 1 | Democrat | |||||||||||||
5452 | 5452 | Jabez Huntington H000997 | sen | CT | 1840-01-01 | 1845-03-03 | 1 | Whig | |||||||||||||
5453 | 5453 | Jabez Huntington H000997 | sen | CT | 1845-12-01 | 1847-12-31 | 1 | Whig | |||||||||||||
5606 | 5606 | Roger Baldwin B000096 | sen | CT | 1847-12-06 | 1851-03-03 | 1 | Whig | |||||||||||||
6478 | 6478 | Isaac Toucey T000319 | sen | CT | 1852-01-01 | 1857-03-03 | 1 | Democrat | |||||||||||||
7946 | 7946 | James Dixon D000369 | sen | CT | 1857-12-07 | 1863-03-03 | 1 | Republican | |||||||||||||
7947 | 7947 | James Dixon D000369 | sen | CT | 1863-12-07 | 1869-03-03 | 1 | Republican | |||||||||||||
8536 | 8536 | William Buckingham B001021 | sen | CT | 1869-03-04 | 1875-03-03 | 1 | Republican | |||||||||||||
10706 | 10706 | William Eaton E000028 | sen | CT | 1875-12-06 | 1881-03-03 | 1 | Democrat | |||||||||||||
13702 | 13702 | Joseph Hawley H000377 | sen | CT | 1881-12-05 | 1887-03-03 | 1 | Republican | |||||||||||||
13703 | 13703 | Joseph Hawley H000377 | sen | CT | 1887-12-05 | 1893-03-03 | 1 | Republican | |||||||||||||
13704 | 13704 | Joseph Hawley H000377 | sen | CT | 1893-08-07 | 1899-03-03 | 1 | Republican | |||||||||||||
13705 | 13705 | Joseph Hawley H000377 | sen | CT | 1899-12-04 | 1905-03-03 | 1 | Republican | |||||||||||||
14598 | 14598 | Morgan Bulkeley B001044 | sen | CT | 1905-12-04 | 1911-03-03 | 1 | Republican | |||||||||||||
18756 | 18756 | George McLean M000547 | sen | CT | 1911-04-04 | 1917-03-03 | 1 | Republican | |||||||||||||
18757 | 18757 | George McLean M000547 | sen | CT | 1917-04-02 | 1923-03-03 | 1 | Republican | |||||||||||||
18758 | 18758 | George McLean M000547 | sen | CT | 1923-12-03 | 1929-03-03 | 1 | Republican | |||||||||||||
20029 | 20029 | Frederic Walcott W000032 | sen | CT | 1929-04-15 | 1935-01-03 | 1 | Republican | |||||||||||||
23111 | 23111 | Francis Maloney M000088 | sen | CT | 1935-01-03 | 1941-01-03 | 1 | Democrat | |||||||||||||
23112 | 23112 | Francis Maloney M000088 | sen | CT | 1941-01-03 | 1945-12-31 | 1 | Democrat | |||||||||||||
23873 | 23873 | Thomas Hart H000293 | sen | CT | 1945-02-15 | 1947-01-03 | 1 | Republican | appointment | ||||||||||||
24231 | 24231 | Raymond Baldwin B000095 | sen | CT | 1946-12-27 | 1947-01-03 | 1 | Republican | |||||||||||||
24232 | 24232 | Raymond Baldwin B000095 | sen | CT | 1947-01-03 | 1949-12-16 | 1 | Republican | |||||||||||||
24739 | 24739 | William Benton B000399 | sen | CT | 1949-12-17 | 1953-01-03 | 1 | Democrat | appointment | ||||||||||||
25784 | 25784 | William Purtell P000575 | sen | CT | 1953-01-03 | 1959-01-03 | 1 | Republican | |||||||||||||
28416 | 28416 | Thomas Dodd D000390 | sen | CT | 1959-01-07 | 1965-01-03 | 1 | Democrat | |||||||||||||
28417 | 28417 | Thomas Dodd D000390 | sen | CT | 1965-01-04 | 1971-01-03 | 1 | Democrat | |||||||||||||
33170 | 33170 | Lowell Weicker W000253 | sen | CT | 1971-01-21 | 1977-01-03 | 1 | Republican |
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);