legislator_terms
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
44,551 rows
This data as json, copyable, CSV (advanced)
start (date) >30 ✖
- 1959-01-07 484
- 1961-01-03 484
- 1969-01-03 482
- 1981-01-05 482
- 1963-01-09 481
- 1989-01-03 481
- 1957-01-03 480
- 1975-01-14 480
- 1971-01-21 478
- 1977-01-04 478
- 1983-01-03 478
- 1991-01-03 478
- 1965-01-04 477
- 1973-01-03 477
- 1979-01-15 477
- 1985-01-03 477
- 1987-01-06 477
- 1993-01-05 476
- 1997-01-07 475
- 2015-01-06 475
- 2003-01-07 474
- 2011-01-05 474
- 2017-01-03 474
- 1967-01-10 473
- 1999-01-06 473
- 2005-01-04 473
- 2007-01-04 473
- 2013-01-03 473
- 1955-01-05 472
- 1995-01-04 472
- …
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
25620 | 25620 | Fred Busbey B001161 | rep | IL | 1953-01-03 | 1955-01-03 | Republican | 3 | |||||||||||||
25621 | 25621 | Hugh Butler B001177 | sen | NE | 1941-01-03 | 1947-01-03 | 1 | Republican | |||||||||||||
25622 | 25622 | Hugh Butler B001177 | sen | NE | 1947-01-03 | 1953-01-03 | 1 | Republican | |||||||||||||
25623 | 25623 | Hugh Butler B001177 | sen | NE | 1953-01-03 | 1954-07-01 | 1 | Republican | |||||||||||||
25624 | 25624 | Albert Camp C000070 | rep | GA | 1939-01-03 | 1941-01-03 | Democrat | 4 | |||||||||||||
25625 | 25625 | Albert Camp C000070 | rep | GA | 1941-01-03 | 1943-01-03 | Democrat | 4 | |||||||||||||
25626 | 25626 | Albert Camp C000070 | rep | GA | 1943-01-06 | 1945-01-03 | Democrat | 4 | |||||||||||||
25627 | 25627 | Albert Camp C000070 | rep | GA | 1945-01-03 | 1947-01-03 | Democrat | 4 | |||||||||||||
25628 | 25628 | Albert Camp C000070 | rep | GA | 1947-01-03 | 1949-01-03 | Democrat | 4 | |||||||||||||
25629 | 25629 | Albert Camp C000070 | rep | GA | 1949-01-03 | 1951-01-03 | Democrat | 4 | |||||||||||||
25630 | 25630 | Albert Camp C000070 | rep | GA | 1951-01-03 | 1953-01-03 | Democrat | 4 | |||||||||||||
25631 | 25631 | Albert Camp C000070 | rep | GA | 1953-01-03 | 1955-01-03 | Democrat | 4 | |||||||||||||
25632 | 25632 | Courtney Campbell C000080 | rep | FL | 1953-01-03 | 1955-01-03 | Democrat | 1 | |||||||||||||
25633 | 25633 | Kit Clardy C000416 | rep | MI | 1953-01-03 | 1955-01-03 | Republican | 6 | |||||||||||||
25634 | 25634 | William Cole C000614 | rep | MO | 1943-01-06 | 1945-01-03 | Republican | 3 | |||||||||||||
25635 | 25635 | William Cole C000614 | rep | MO | 1945-01-03 | 1947-01-03 | Republican | 3 | |||||||||||||
25636 | 25636 | William Cole C000614 | rep | MO | 1947-01-03 | 1949-01-03 | Republican | 3 | |||||||||||||
25637 | 25637 | William Cole C000614 | rep | MO | 1953-01-03 | 1955-01-03 | Republican | 6 | |||||||||||||
25638 | 25638 | Robert Condon C000674 | rep | CA | 1953-01-03 | 1955-01-03 | Democrat | 6 | |||||||||||||
25639 | 25639 | Robert Crosser C000932 | rep | OH | 1913-04-07 | 1915-03-03 | Democrat | -1 | |||||||||||||
25640 | 25640 | Robert Crosser C000932 | rep | OH | 1915-12-06 | 1917-03-03 | Democrat | 21 | |||||||||||||
25641 | 25641 | Robert Crosser C000932 | rep | OH | 1917-04-02 | 1919-03-03 | Democrat | 21 | |||||||||||||
25642 | 25642 | Robert Crosser C000932 | rep | OH | 1923-12-03 | 1925-03-03 | Democrat | 21 | |||||||||||||
25643 | 25643 | Robert Crosser C000932 | rep | OH | 1925-12-07 | 1927-03-04 | Democrat | 21 | |||||||||||||
25644 | 25644 | Robert Crosser C000932 | rep | OH | 1927-12-05 | 1929-03-03 | Democrat | 21 | |||||||||||||
25645 | 25645 | Robert Crosser C000932 | rep | OH | 1929-04-15 | 1931-03-03 | Democrat | 21 | |||||||||||||
25646 | 25646 | Robert Crosser C000932 | rep | OH | 1931-12-07 | 1933-03-03 | Democrat | 21 | |||||||||||||
25647 | 25647 | Robert Crosser C000932 | rep | OH | 1933-03-09 | 1935-01-03 | Democrat | 21 | |||||||||||||
25648 | 25648 | Robert Crosser C000932 | rep | OH | 1935-01-03 | 1937-01-03 | Democrat | 21 | |||||||||||||
25649 | 25649 | Robert Crosser C000932 | rep | OH | 1937-01-05 | 1939-01-03 | Democrat | 21 | |||||||||||||
25650 | 25650 | Robert Crosser C000932 | rep | OH | 1939-01-03 | 1941-01-03 | Democrat | 21 | |||||||||||||
25651 | 25651 | Robert Crosser C000932 | rep | OH | 1941-01-03 | 1943-01-03 | Democrat | 21 | |||||||||||||
25652 | 25652 | Robert Crosser C000932 | rep | OH | 1943-01-06 | 1945-01-03 | Democrat | 21 | |||||||||||||
25653 | 25653 | Robert Crosser C000932 | rep | OH | 1945-01-03 | 1947-01-03 | Democrat | 21 | |||||||||||||
25654 | 25654 | Robert Crosser C000932 | rep | OH | 1947-01-03 | 1949-01-03 | Democrat | 21 | |||||||||||||
25655 | 25655 | Robert Crosser C000932 | rep | OH | 1949-01-03 | 1951-01-03 | Democrat | 21 | |||||||||||||
25656 | 25656 | Robert Crosser C000932 | rep | OH | 1951-01-03 | 1953-01-03 | Democrat | 21 | |||||||||||||
25657 | 25657 | Robert Crosser C000932 | rep | OH | 1953-01-03 | 1955-01-03 | Democrat | 21 | |||||||||||||
25658 | 25658 | Wesley D’Ewart D000281 | rep | MT | 1945-01-03 | 1947-01-03 | Republican | 2 | |||||||||||||
25659 | 25659 | Wesley D’Ewart D000281 | rep | MT | 1947-01-03 | 1949-01-03 | Republican | 2 | |||||||||||||
25660 | 25660 | Wesley D’Ewart D000281 | rep | MT | 1949-01-03 | 1951-01-03 | Republican | 2 | |||||||||||||
25661 | 25661 | Wesley D’Ewart D000281 | rep | MT | 1951-01-03 | 1953-01-03 | Republican | 2 | |||||||||||||
25662 | 25662 | Wesley D’Ewart D000281 | rep | MT | 1953-01-03 | 1955-01-03 | Republican | 2 | |||||||||||||
25663 | 25663 | Marion Daniel D000036 | sen | TX | 1953-01-03 | 1957-12-31 | 1 | Democrat | |||||||||||||
25664 | 25664 | Joseph Farrington F000034 | rep | HI | 1943-01-06 | 1945-01-03 | Republican | 0 | |||||||||||||
25665 | 25665 | Joseph Farrington F000034 | rep | HI | 1945-01-03 | 1947-01-03 | Republican | 0 | |||||||||||||
25666 | 25666 | Joseph Farrington F000034 | rep | HI | 1947-01-03 | 1949-01-03 | Republican | 0 | |||||||||||||
25667 | 25667 | Joseph Farrington F000034 | rep | HI | 1949-01-03 | 1951-01-03 | Republican | 0 | |||||||||||||
25668 | 25668 | Joseph Farrington F000034 | rep | HI | 1951-01-03 | 1953-01-03 | Republican | 0 | |||||||||||||
25669 | 25669 | Joseph Farrington F000034 | rep | HI | 1953-01-03 | 1955-01-03 | Republican | 0 | |||||||||||||
25670 | 25670 | Ralph Flanders F000190 | sen | VT | 1946-11-01 | 1947-01-03 | 1 | Republican | appointment | ||||||||||||
25671 | 25671 | Ralph Flanders F000190 | sen | VT | 1947-01-03 | 1953-01-03 | 1 | Republican | |||||||||||||
25672 | 25672 | Ralph Flanders F000190 | sen | VT | 1953-01-03 | 1959-01-03 | 1 | Republican | |||||||||||||
25673 | 25673 | James Golden G000258 | rep | KY | 1949-01-03 | 1951-01-03 | Republican | 9 | |||||||||||||
25674 | 25674 | James Golden G000258 | rep | KY | 1951-01-03 | 1953-01-03 | Republican | 9 | |||||||||||||
25675 | 25675 | James Golden G000258 | rep | KY | 1953-01-03 | 1955-01-03 | Republican | 8 | |||||||||||||
25676 | 25676 | Angier Goodwin G000297 | rep | MA | 1943-01-06 | 1945-01-03 | Republican | 8 | |||||||||||||
25677 | 25677 | Angier Goodwin G000297 | rep | MA | 1945-01-03 | 1947-01-03 | Republican | 8 | |||||||||||||
25678 | 25678 | Angier Goodwin G000297 | rep | MA | 1947-01-03 | 1949-01-03 | Republican | 8 | |||||||||||||
25679 | 25679 | Angier Goodwin G000297 | rep | MA | 1949-01-03 | 1951-01-03 | Republican | 8 | |||||||||||||
25680 | 25680 | Angier Goodwin G000297 | rep | MA | 1951-01-03 | 1953-01-03 | Republican | 8 | |||||||||||||
25681 | 25681 | Angier Goodwin G000297 | rep | MA | 1953-01-03 | 1955-01-03 | Republican | 8 | |||||||||||||
25682 | 25682 | Louis Graham G000360 | rep | PA | 1939-01-03 | 1941-01-03 | Republican | 26 | |||||||||||||
25683 | 25683 | Louis Graham G000360 | rep | PA | 1941-01-03 | 1943-01-03 | Republican | 26 | |||||||||||||
25684 | 25684 | Louis Graham G000360 | rep | PA | 1943-01-06 | 1945-01-03 | Republican | 26 | |||||||||||||
25685 | 25685 | Louis Graham G000360 | rep | PA | 1945-01-03 | 1947-01-03 | Republican | 25 | |||||||||||||
25686 | 25686 | Louis Graham G000360 | rep | PA | 1947-01-03 | 1949-01-03 | Republican | 25 | |||||||||||||
25687 | 25687 | Louis Graham G000360 | rep | PA | 1949-01-03 | 1951-01-03 | Republican | 25 | |||||||||||||
25688 | 25688 | Louis Graham G000360 | rep | PA | 1951-01-03 | 1953-01-03 | Republican | 25 | |||||||||||||
25689 | 25689 | Louis Graham G000360 | rep | PA | 1953-01-03 | 1955-01-03 | Republican | 25 | |||||||||||||
25690 | 25690 | Harold Hagen H000014 | rep | MN | 1943-01-06 | 1945-01-03 | Farmer-Labor | 9 | |||||||||||||
25691 | 25691 | Harold Hagen H000014 | rep | MN | 1945-01-03 | 1947-01-03 | Republican | 9 | |||||||||||||
25692 | 25692 | Harold Hagen H000014 | rep | MN | 1947-01-03 | 1949-01-03 | Republican | 9 | |||||||||||||
25693 | 25693 | Harold Hagen H000014 | rep | MN | 1949-01-03 | 1951-01-03 | Republican | 9 | |||||||||||||
25694 | 25694 | Harold Hagen H000014 | rep | MN | 1951-01-03 | 1953-01-03 | Republican | 9 | |||||||||||||
25695 | 25695 | Harold Hagen H000014 | rep | MN | 1953-01-03 | 1955-01-03 | Republican | 9 | |||||||||||||
25696 | 25696 | Edward Hart H000284 | rep | NJ | 1935-01-03 | 1937-01-03 | Democrat | 14 | |||||||||||||
25697 | 25697 | Edward Hart H000284 | rep | NJ | 1937-01-05 | 1939-01-03 | Democrat | 14 | |||||||||||||
25698 | 25698 | Edward Hart H000284 | rep | NJ | 1939-01-03 | 1941-01-03 | Democrat | 14 | |||||||||||||
25699 | 25699 | Edward Hart H000284 | rep | NJ | 1941-01-03 | 1943-01-03 | Democrat | 14 | |||||||||||||
25700 | 25700 | Edward Hart H000284 | rep | NJ | 1943-01-06 | 1945-01-03 | Democrat | 14 | |||||||||||||
25701 | 25701 | Edward Hart H000284 | rep | NJ | 1945-01-03 | 1947-01-03 | Democrat | 14 | |||||||||||||
25702 | 25702 | Edward Hart H000284 | rep | NJ | 1947-01-03 | 1949-01-03 | Democrat | 14 | |||||||||||||
25703 | 25703 | Edward Hart H000284 | rep | NJ | 1949-01-03 | 1951-01-03 | Democrat | 14 | |||||||||||||
25704 | 25704 | Edward Hart H000284 | rep | NJ | 1951-01-03 | 1953-01-03 | Democrat | 14 | |||||||||||||
25705 | 25705 | Edward Hart H000284 | rep | NJ | 1953-01-03 | 1955-01-03 | Democrat | 14 | |||||||||||||
25706 | 25706 | Louis Heller H000460 | rep | NY | 1949-01-03 | 1951-01-03 | Democrat | 7 | |||||||||||||
25707 | 25707 | Louis Heller H000460 | rep | NY | 1951-01-03 | 1953-01-03 | Democrat | 7 | |||||||||||||
25708 | 25708 | Louis Heller H000460 | rep | NY | 1953-01-03 | 1955-01-03 | Democrat | 8 | |||||||||||||
25709 | 25709 | Jeffrey Hillelson H000616 | rep | MO | 1953-01-03 | 1955-01-03 | Republican | 4 | |||||||||||||
25710 | 25710 | Charles Howell H000858 | rep | NJ | 1949-01-03 | 1951-01-03 | Democrat | 4 | |||||||||||||
25711 | 25711 | Charles Howell H000858 | rep | NJ | 1951-01-03 | 1953-01-03 | Democrat | 4 | |||||||||||||
25712 | 25712 | Charles Howell H000858 | rep | NJ | 1953-01-03 | 1955-01-03 | Democrat | 4 | |||||||||||||
25713 | 25713 | Merlin Hull H000943 | rep | WI | 1929-04-15 | 1931-03-03 | Republican | 7 | |||||||||||||
25714 | 25714 | Merlin Hull H000943 | rep | WI | 1935-01-03 | 1937-01-03 | Progressive | 9 | |||||||||||||
25715 | 25715 | Merlin Hull H000943 | rep | WI | 1937-01-05 | 1939-01-03 | Progressive | 9 | |||||||||||||
25716 | 25716 | Merlin Hull H000943 | rep | WI | 1939-01-03 | 1941-01-03 | Progressive | 9 | |||||||||||||
25717 | 25717 | Merlin Hull H000943 | rep | WI | 1941-01-03 | 1943-01-03 | Progressive | 9 | |||||||||||||
25718 | 25718 | Merlin Hull H000943 | rep | WI | 1943-01-06 | 1945-01-03 | Progressive | 9 | |||||||||||||
25719 | 25719 | Merlin Hull H000943 | rep | WI | 1945-01-03 | 1947-01-03 | Progressive | 9 |
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);