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 ✖
- 1947-01-03 485
- 1945-01-03 484
- 1951-01-03 484
- 1959-01-07 484
- 1961-01-03 484
- 1969-01-03 482
- 1981-01-05 482
- 1963-01-09 481
- 1989-01-03 481
- 1949-01-03 480
- 1957-01-03 480
- 1975-01-14 480
- 1971-01-21 478
- 1977-01-04 478
- 1983-01-03 478
- 1991-01-03 478
- 1953-01-03 477
- 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
- …
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
23759 | 23759 | James Wright W000762 | rep | PA | 1941-01-03 | 1943-01-03 | Democrat | 34 | |||||||||||||
23760 | 23760 | James Wright W000762 | rep | PA | 1943-01-06 | 1945-01-03 | Democrat | 32 | |||||||||||||
23761 | 23761 | Wilton Hall H000080 | sen | SC | 1944-11-20 | 1945-01-03 | 3 | Democrat | appointment | ||||||||||||
23762 | 23762 | Samuel Jackson J000026 | sen | IN | 1944-01-28 | 1945-01-03 | 3 | Democrat | appointment | ||||||||||||
23763 | 23763 | Sinclair Weeks W000248 | sen | MA | 1944-02-08 | 1945-01-03 | 2 | Republican | appointment | ||||||||||||
23764 | 23764 | Sherman Adams A000046 | rep | NH | 1945-01-03 | 1947-01-03 | Republican | 2 | |||||||||||||
23765 | 23765 | Harry Baldwin B000086 | rep | MD | 1943-01-06 | 1945-01-03 | Democrat | 2 | |||||||||||||
23766 | 23766 | Harry Baldwin B000086 | rep | MD | 1945-01-03 | 1947-01-03 | Democrat | 2 | |||||||||||||
23767 | 23767 | Joseph Baldwin B000093 | rep | NY | 1941-01-03 | 1943-01-03 | Republican | 17 | |||||||||||||
23768 | 23768 | Joseph Baldwin B000093 | rep | NY | 1943-01-06 | 1945-01-03 | Republican | 17 | |||||||||||||
23769 | 23769 | Joseph Baldwin B000093 | rep | NY | 1945-01-03 | 1947-01-03 | Republican | 17 | |||||||||||||
23770 | 23770 | William Barry B000191 | rep | NY | 1935-01-03 | 1937-01-03 | Democrat | 2 | |||||||||||||
23771 | 23771 | William Barry B000191 | rep | NY | 1937-01-05 | 1939-01-03 | Democrat | 2 | |||||||||||||
23772 | 23772 | William Barry B000191 | rep | NY | 1939-01-03 | 1941-01-03 | Democrat | 2 | |||||||||||||
23773 | 23773 | William Barry B000191 | rep | NY | 1941-01-03 | 1943-01-03 | Democrat | 2 | |||||||||||||
23774 | 23774 | William Barry B000191 | rep | NY | 1943-01-06 | 1945-01-03 | Democrat | 2 | |||||||||||||
23775 | 23775 | William Barry B000191 | rep | NY | 1945-01-03 | 1947-01-03 | Democrat | 4 | |||||||||||||
23776 | 23776 | Augustus Bennet B000367 | rep | NY | 1945-01-03 | 1947-01-03 | Republican | 29 | |||||||||||||
23777 | 23777 | Lyle Boren B000640 | rep | OK | 1937-01-05 | 1939-01-03 | Democrat | 4 | |||||||||||||
23778 | 23778 | Lyle Boren B000640 | rep | OK | 1939-01-03 | 1941-01-03 | Democrat | 4 | |||||||||||||
23779 | 23779 | Lyle Boren B000640 | rep | OK | 1941-01-03 | 1943-01-03 | Democrat | 4 | |||||||||||||
23780 | 23780 | Lyle Boren B000640 | rep | OK | 1943-01-06 | 1945-01-03 | Democrat | 4 | |||||||||||||
23781 | 23781 | Lyle Boren B000640 | rep | OK | 1945-01-03 | 1947-01-03 | Democrat | 4 | |||||||||||||
23782 | 23782 | Michael Bradley B000743 | rep | PA | 1937-01-05 | 1939-01-03 | Democrat | 3 | |||||||||||||
23783 | 23783 | Michael Bradley B000743 | rep | PA | 1939-01-03 | 1941-01-03 | Democrat | 3 | |||||||||||||
23784 | 23784 | Michael Bradley B000743 | rep | PA | 1941-01-03 | 1943-01-03 | Democrat | 3 | |||||||||||||
23785 | 23785 | Michael Bradley B000743 | rep | PA | 1943-01-06 | 1945-01-03 | Democrat | 3 | |||||||||||||
23786 | 23786 | Michael Bradley B000743 | rep | PA | 1945-01-03 | 1947-01-03 | Democrat | 3 | |||||||||||||
23787 | 23787 | Frank Briggs B000828 | sen | MO | 1945-01-18 | 1947-01-03 | 1 | Democrat | appointment | ||||||||||||
23788 | 23788 | David Brumbaugh B000976 | rep | PA | 1943-01-06 | 1945-01-03 | Republican | 23 | |||||||||||||
23789 | 23789 | David Brumbaugh B000976 | rep | PA | 1945-01-03 | 1947-01-03 | Republican | 22 | |||||||||||||
23790 | 23790 | Berkeley Bunker B001061 | sen | NV | 1940-11-27 | 1941-01-03 | 1 | Democrat | appointment | ||||||||||||
23791 | 23791 | Berkeley Bunker B001061 | sen | NV | 1941-01-03 | 1942-12-06 | 1 | Democrat | |||||||||||||
23792 | 23792 | Berkeley Bunker B001061 | rep | NV | 1945-01-03 | 1947-01-03 | Democrat | 0 | |||||||||||||
23793 | 23793 | William Burgin B001084 | rep | NC | 1939-01-03 | 1941-01-03 | Democrat | 8 | |||||||||||||
23794 | 23794 | William Burgin B001084 | rep | NC | 1941-01-03 | 1943-01-03 | Democrat | 8 | |||||||||||||
23795 | 23795 | William Burgin B001084 | rep | NC | 1943-01-06 | 1945-01-03 | Democrat | 8 | |||||||||||||
23796 | 23796 | William Burgin B001084 | rep | NC | 1945-01-03 | 1947-01-03 | Democrat | 8 | |||||||||||||
23797 | 23797 | Howard Campbell C000085 | rep | PA | 1945-01-03 | 1947-01-03 | Republican | 29 | |||||||||||||
23798 | 23798 | Arthur Cannon C000115 | rep | FL | 1939-01-03 | 1941-01-03 | Democrat | 4 | |||||||||||||
23799 | 23799 | Arthur Cannon C000115 | rep | FL | 1941-01-03 | 1943-01-03 | Democrat | 4 | |||||||||||||
23800 | 23800 | Arthur Cannon C000115 | rep | FL | 1943-01-06 | 1945-01-03 | Democrat | 4 | |||||||||||||
23801 | 23801 | Arthur Cannon C000115 | rep | FL | 1945-01-03 | 1947-01-03 | Democrat | 4 | |||||||||||||
23802 | 23802 | Edward Carville C000211 | sen | NV | 1945-07-25 | 1947-01-03 | 1 | Democrat | appointment | ||||||||||||
23803 | 23803 | John Cochran C000565 | rep | MO | 1925-12-07 | 1927-03-04 | Democrat | 11 | |||||||||||||
23804 | 23804 | John Cochran C000565 | rep | MO | 1927-12-05 | 1929-03-03 | Democrat | 11 | |||||||||||||
23805 | 23805 | John Cochran C000565 | rep | MO | 1929-04-15 | 1931-03-03 | Democrat | 11 | |||||||||||||
23806 | 23806 | John Cochran C000565 | rep | MO | 1931-12-07 | 1933-03-03 | Democrat | 11 | |||||||||||||
23807 | 23807 | John Cochran C000565 | rep | MO | 1933-03-09 | 1935-01-03 | Democrat | 0 | |||||||||||||
23808 | 23808 | John Cochran C000565 | rep | MO | 1935-01-03 | 1937-01-03 | Democrat | 13 | |||||||||||||
23809 | 23809 | John Cochran C000565 | rep | MO | 1937-01-05 | 1939-01-03 | Democrat | 13 | |||||||||||||
23810 | 23810 | John Cochran C000565 | rep | MO | 1939-01-03 | 1941-01-03 | Democrat | 13 | |||||||||||||
23811 | 23811 | John Cochran C000565 | rep | MO | 1941-01-03 | 1943-01-03 | Democrat | 13 | |||||||||||||
23812 | 23812 | John Cochran C000565 | rep | MO | 1943-01-06 | 1945-01-03 | Democrat | 13 | |||||||||||||
23813 | 23813 | John Cochran C000565 | rep | MO | 1945-01-03 | 1947-01-03 | Democrat | 13 | |||||||||||||
23814 | 23814 | John Coffee C000584 | rep | WA | 1937-01-05 | 1939-01-03 | Democrat | 6 | |||||||||||||
23815 | 23815 | John Coffee C000584 | rep | WA | 1939-01-03 | 1941-01-03 | Democrat | 6 | |||||||||||||
23816 | 23816 | John Coffee C000584 | rep | WA | 1941-01-03 | 1943-01-03 | Democrat | 6 | |||||||||||||
23817 | 23817 | John Coffee C000584 | rep | WA | 1943-01-06 | 1945-01-03 | Democrat | 6 | |||||||||||||
23818 | 23818 | John Coffee C000584 | rep | WA | 1945-01-03 | 1947-01-03 | Democrat | 6 | |||||||||||||
23819 | 23819 | James Curley C000996 | rep | MA | 1911-04-04 | 1913-03-03 | Democrat | 10 | |||||||||||||
23820 | 23820 | James Curley C000996 | rep | MA | 1913-04-07 | 1915-03-03 | Democrat | 12 | |||||||||||||
23821 | 23821 | James Curley C000996 | rep | MA | 1943-01-06 | 1945-01-03 | Democrat | 11 | |||||||||||||
23822 | 23822 | James Curley C000996 | rep | MA | 1945-01-03 | 1947-01-03 | Democrat | 11 | |||||||||||||
23823 | 23823 | Ralph Daughton D000067 | rep | VA | 1943-01-06 | 1945-01-03 | Democrat | 2 | |||||||||||||
23824 | 23824 | Ralph Daughton D000067 | rep | VA | 1945-01-03 | 1947-01-03 | Democrat | 2 | |||||||||||||
23825 | 23825 | Emerson De Lacy D000206 | rep | WA | 1945-01-03 | 1947-01-03 | Democrat | 1 | |||||||||||||
23826 | 23826 | Samuel Dickstein D000335 | rep | NY | 1923-12-03 | 1925-03-03 | Democrat | 12 | |||||||||||||
23827 | 23827 | Samuel Dickstein D000335 | rep | NY | 1925-12-07 | 1927-03-04 | Democrat | 12 | |||||||||||||
23828 | 23828 | Samuel Dickstein D000335 | rep | NY | 1927-12-05 | 1929-03-03 | Democrat | 12 | |||||||||||||
23829 | 23829 | Samuel Dickstein D000335 | rep | NY | 1929-04-15 | 1931-03-03 | Democrat | 12 | |||||||||||||
23830 | 23830 | Samuel Dickstein D000335 | rep | NY | 1931-12-07 | 1933-03-03 | Democrat | 12 | |||||||||||||
23831 | 23831 | Samuel Dickstein D000335 | rep | NY | 1933-03-09 | 1935-01-03 | Democrat | 12 | |||||||||||||
23832 | 23832 | Samuel Dickstein D000335 | rep | NY | 1935-01-03 | 1937-01-03 | Democrat | 12 | |||||||||||||
23833 | 23833 | Samuel Dickstein D000335 | rep | NY | 1937-01-05 | 1939-01-03 | Democrat | 12 | |||||||||||||
23834 | 23834 | Samuel Dickstein D000335 | rep | NY | 1939-01-03 | 1941-01-03 | Democrat | 12 | |||||||||||||
23835 | 23835 | Samuel Dickstein D000335 | rep | NY | 1941-01-03 | 1943-01-03 | Democrat | 12 | |||||||||||||
23836 | 23836 | Samuel Dickstein D000335 | rep | NY | 1943-01-06 | 1945-01-03 | Democrat | 12 | |||||||||||||
23837 | 23837 | Samuel Dickstein D000335 | rep | NY | 1945-01-03 | 1947-01-03 | Democrat | 19 | |||||||||||||
23838 | 23838 | Forrest Donnell D000414 | sen | MO | 1945-01-03 | 1951-01-03 | 3 | Republican | |||||||||||||
23839 | 23839 | Emily Douglas D000452 | rep | IL | 1945-01-03 | 1947-01-03 | Democrat | 0 | |||||||||||||
23840 | 23840 | Sheridan Downey D000469 | sen | CA | 1939-01-03 | 1945-01-03 | 3 | Democrat | |||||||||||||
23841 | 23841 | Sheridan Downey D000469 | sen | CA | 1945-01-03 | 1951-01-03 | 3 | Democrat | |||||||||||||
23842 | 23842 | Harold Earthman E000016 | rep | TN | 1945-01-03 | 1947-01-03 | Democrat | 5 | |||||||||||||
23843 | 23843 | Joseph Ervin E000210 | rep | NC | 1945-01-03 | 1947-01-03 | Democrat | 10 | |||||||||||||
23844 | 23844 | William Gallagher G000019 | rep | MN | 1945-01-03 | 1947-01-03 | Democrat | 3 | |||||||||||||
23845 | 23845 | Edward Gardner G000051 | rep | OH | 1945-01-03 | 1947-01-03 | Democrat | 3 | |||||||||||||
23846 | 23846 | James Geelan G000117 | rep | CT | 1945-01-03 | 1947-01-03 | Democrat | 3 | |||||||||||||
23847 | 23847 | John Gibson G000163 | rep | GA | 1941-01-03 | 1943-01-03 | Democrat | 8 | |||||||||||||
23848 | 23848 | John Gibson G000163 | rep | GA | 1943-01-06 | 1945-01-03 | Democrat | 8 | |||||||||||||
23849 | 23849 | John Gibson G000163 | rep | GA | 1945-01-03 | 1947-01-03 | Democrat | 8 | |||||||||||||
23850 | 23850 | Dean Gillespie G000194 | rep | CO | 1943-01-06 | 1945-01-03 | Republican | 1 | |||||||||||||
23851 | 23851 | Dean Gillespie G000194 | rep | CO | 1945-01-03 | 1947-01-03 | Republican | 1 | |||||||||||||
23852 | 23852 | Charles Gossett G000337 | sen | ID | 1945-11-17 | 1947-01-03 | 2 | Democrat | appointment | ||||||||||||
23853 | 23853 | John Gurney G000532 | sen | SD | 1939-01-03 | 1945-01-03 | 3 | Republican | |||||||||||||
23854 | 23854 | John Gurney G000532 | sen | SD | 1945-01-03 | 1951-01-03 | 3 | Republican | |||||||||||||
23855 | 23855 | Clarence Hancock H000146 | rep | NY | 1927-12-05 | 1929-03-03 | Republican | 35 | |||||||||||||
23856 | 23856 | Clarence Hancock H000146 | rep | NY | 1929-04-15 | 1931-03-03 | Republican | 35 | |||||||||||||
23857 | 23857 | Clarence Hancock H000146 | rep | NY | 1931-12-07 | 1933-03-03 | Republican | 35 | |||||||||||||
23858 | 23858 | Clarence Hancock H000146 | rep | NY | 1933-03-09 | 1935-01-03 | Republican | 35 |
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);