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 ✖
- 1961-01-03 483
- 1969-01-03 482
- 1981-01-05 482
- 1963-01-09 481
- 1989-01-03 481
- 1975-01-14 480
- 1971-01-21 478
- 1977-01-04 478
- 1983-01-03 478
- 1991-01-03 478
- 1973-01-03 477
- 1979-01-15 477
- 1985-01-03 477
- 1987-01-06 477
- 1965-01-04 476
- 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
- 1995-01-04 472
- 2001-01-03 472
- 2009-01-06 472
- 2019-01-03 471
- …
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
26791 | 26791 | Gordon Canfield C000113 | rep | NJ | 1959-01-07 | 1961-01-03 | Republican | 8 | |||||||||||||
26792 | 26792 | Albert Carnahan C000162 | rep | MO | 1945-01-03 | 1947-01-03 | Democrat | 8 | |||||||||||||
26793 | 26793 | Albert Carnahan C000162 | rep | MO | 1949-01-03 | 1951-01-03 | Democrat | 8 | |||||||||||||
26794 | 26794 | Albert Carnahan C000162 | rep | MO | 1951-01-03 | 1953-01-03 | Democrat | 8 | |||||||||||||
26795 | 26795 | Albert Carnahan C000162 | rep | MO | 1953-01-03 | 1955-01-03 | Democrat | 8 | |||||||||||||
26796 | 26796 | Albert Carnahan C000162 | rep | MO | 1955-01-05 | 1957-01-03 | Democrat | 8 | |||||||||||||
26797 | 26797 | Albert Carnahan C000162 | rep | MO | 1957-01-03 | 1959-01-03 | Democrat | 8 | |||||||||||||
26798 | 26798 | Albert Carnahan C000162 | rep | MO | 1959-01-07 | 1961-01-03 | Democrat | 8 | |||||||||||||
26799 | 26799 | Steven Carter C000199 | rep | IA | 1959-01-07 | 1961-01-03 | Democrat | 4 | |||||||||||||
26800 | 26800 | Dennis Chavez C000338 | rep | NM | 1931-12-07 | 1933-03-03 | Democrat | 1 | |||||||||||||
26801 | 26801 | Dennis Chavez C000338 | rep | NM | 1933-03-09 | 1935-01-03 | Democrat | 1 | |||||||||||||
26802 | 26802 | Dennis Chavez C000338 | sen | NM | 1935-05-11 | 1941-01-03 | 1 | Democrat | appointment | ||||||||||||
26803 | 26803 | Dennis Chavez C000338 | sen | NM | 1941-01-03 | 1947-01-03 | 1 | Democrat | |||||||||||||
26804 | 26804 | Dennis Chavez C000338 | sen | NM | 1947-01-03 | 1953-01-03 | 1 | Democrat | |||||||||||||
26805 | 26805 | Dennis Chavez C000338 | sen | NM | 1953-01-03 | 1959-01-03 | 1 | Democrat | |||||||||||||
26806 | 26806 | Dennis Chavez C000338 | sen | NM | 1959-01-07 | 1962-11-18 | 1 | Democrat | |||||||||||||
26807 | 26807 | George Christopher C000383 | rep | MO | 1949-01-03 | 1951-01-03 | Democrat | 6 | |||||||||||||
26808 | 26808 | George Christopher C000383 | rep | MO | 1955-01-05 | 1957-01-03 | Democrat | 4 | |||||||||||||
26809 | 26809 | George Christopher C000383 | rep | MO | 1957-01-03 | 1959-01-03 | Democrat | 4 | |||||||||||||
26810 | 26810 | George Christopher C000383 | rep | MO | 1959-01-07 | 1961-01-03 | Democrat | 4 | |||||||||||||
26811 | 26811 | Frank Coffin C000589 | rep | ME | 1957-01-03 | 1959-01-03 | Democrat | 2 | |||||||||||||
26812 | 26812 | Frank Coffin C000589 | rep | ME | 1959-01-07 | 1961-01-03 | Democrat | 2 | |||||||||||||
26813 | 26813 | Henry Dixon D000368 | rep | UT | 1955-01-05 | 1957-01-03 | Republican | 1 | |||||||||||||
26814 | 26814 | Henry Dixon D000368 | rep | UT | 1957-01-03 | 1959-01-03 | Republican | 1 | |||||||||||||
26815 | 26815 | Henry Dixon D000368 | rep | UT | 1959-01-07 | 1961-01-03 | Republican | 1 | |||||||||||||
26816 | 26816 | Isidore Dollinger D000402 | rep | NY | 1949-01-03 | 1951-01-03 | Democrat | 24 | |||||||||||||
26817 | 26817 | Isidore Dollinger D000402 | rep | NY | 1951-01-03 | 1953-01-03 | Democrat | 24 | |||||||||||||
26818 | 26818 | Isidore Dollinger D000402 | rep | NY | 1953-01-03 | 1955-01-03 | Democrat | 23 | |||||||||||||
26819 | 26819 | Isidore Dollinger D000402 | rep | NY | 1955-01-05 | 1957-01-03 | Democrat | 23 | |||||||||||||
26820 | 26820 | Isidore Dollinger D000402 | rep | NY | 1957-01-03 | 1959-01-03 | Democrat | 23 | |||||||||||||
26821 | 26821 | Isidore Dollinger D000402 | rep | NY | 1959-01-07 | 1961-01-03 | Democrat | 23 | |||||||||||||
26822 | 26822 | Francis Dorn D000433 | rep | NY | 1953-01-03 | 1955-01-03 | Republican | 12 | |||||||||||||
26823 | 26823 | Francis Dorn D000433 | rep | NY | 1955-01-05 | 1957-01-03 | Republican | 12 | |||||||||||||
26824 | 26824 | Francis Dorn D000433 | rep | NY | 1957-01-03 | 1959-01-03 | Republican | 12 | |||||||||||||
26825 | 26825 | Francis Dorn D000433 | rep | NY | 1959-01-07 | 1961-01-03 | Republican | 12 | |||||||||||||
26826 | 26826 | Carl Durham D000571 | rep | NC | 1939-01-03 | 1941-01-03 | Democrat | 6 | |||||||||||||
26827 | 26827 | Carl Durham D000571 | rep | NC | 1941-01-03 | 1943-01-03 | Democrat | 6 | |||||||||||||
26828 | 26828 | Carl Durham D000571 | rep | NC | 1943-01-06 | 1945-01-03 | Democrat | 6 | |||||||||||||
26829 | 26829 | Carl Durham D000571 | rep | NC | 1945-01-03 | 1947-01-03 | Democrat | 6 | |||||||||||||
26830 | 26830 | Carl Durham D000571 | rep | NC | 1947-01-03 | 1949-01-03 | Democrat | 6 | |||||||||||||
26831 | 26831 | Carl Durham D000571 | rep | NC | 1949-01-03 | 1951-01-03 | Democrat | 6 | |||||||||||||
26832 | 26832 | Carl Durham D000571 | rep | NC | 1951-01-03 | 1953-01-03 | Democrat | 6 | |||||||||||||
26833 | 26833 | Carl Durham D000571 | rep | NC | 1953-01-03 | 1955-01-03 | Democrat | 6 | |||||||||||||
26834 | 26834 | Carl Durham D000571 | rep | NC | 1955-01-05 | 1957-01-03 | Democrat | 6 | |||||||||||||
26835 | 26835 | Carl Durham D000571 | rep | NC | 1957-01-03 | 1959-01-03 | Democrat | 6 | |||||||||||||
26836 | 26836 | Carl Durham D000571 | rep | NC | 1959-01-07 | 1961-01-03 | Democrat | 6 | |||||||||||||
26837 | 26837 | Douglas Elliott E000121 | rep | PA | 1959-01-07 | 1961-01-03 | Republican | 18 | |||||||||||||
26838 | 26838 | Clair Engle E000181 | rep | CA | 1943-01-06 | 1945-01-03 | Democrat | 2 | |||||||||||||
26839 | 26839 | Clair Engle E000181 | rep | CA | 1945-01-03 | 1947-01-03 | Democrat | 2 | |||||||||||||
26840 | 26840 | Clair Engle E000181 | rep | CA | 1947-01-03 | 1949-01-03 | Democrat | 2 | |||||||||||||
26841 | 26841 | Clair Engle E000181 | rep | CA | 1949-01-03 | 1951-01-03 | Democrat | 2 | |||||||||||||
26842 | 26842 | Clair Engle E000181 | rep | CA | 1951-01-03 | 1953-01-03 | Democrat | 2 | |||||||||||||
26843 | 26843 | Clair Engle E000181 | rep | CA | 1953-01-03 | 1955-01-03 | Democrat | 2 | |||||||||||||
26844 | 26844 | Clair Engle E000181 | rep | CA | 1955-01-05 | 1957-01-03 | Democrat | 2 | |||||||||||||
26845 | 26845 | Clair Engle E000181 | rep | CA | 1957-01-03 | 1959-01-03 | Democrat | 2 | |||||||||||||
26846 | 26846 | Clair Engle E000181 | sen | CA | 1959-01-07 | 1965-01-03 | 1 | Democrat | |||||||||||||
26847 | 26847 | Gerald Flynn F000227 | rep | WI | 1959-01-07 | 1961-01-03 | Democrat | 1 | |||||||||||||
26848 | 26848 | John Foley F000237 | rep | MD | 1959-01-07 | 1961-01-03 | Democrat | 6 | |||||||||||||
26849 | 26849 | Aime Forand F000255 | rep | RI | 1937-01-05 | 1939-01-03 | Democrat | 1 | |||||||||||||
26850 | 26850 | Aime Forand F000255 | rep | RI | 1941-01-03 | 1943-01-03 | Democrat | 1 | |||||||||||||
26851 | 26851 | Aime Forand F000255 | rep | RI | 1943-01-06 | 1945-01-03 | Democrat | 1 | |||||||||||||
26852 | 26852 | Aime Forand F000255 | rep | RI | 1945-01-03 | 1947-01-03 | Democrat | 1 | |||||||||||||
26853 | 26853 | Aime Forand F000255 | rep | RI | 1947-01-03 | 1949-01-03 | Democrat | 1 | |||||||||||||
26854 | 26854 | Aime Forand F000255 | rep | RI | 1949-01-03 | 1951-01-03 | Democrat | 1 | |||||||||||||
26855 | 26855 | Aime Forand F000255 | rep | RI | 1951-01-03 | 1953-01-03 | Democrat | 1 | |||||||||||||
26856 | 26856 | Aime Forand F000255 | rep | RI | 1953-01-03 | 1955-01-03 | Democrat | 1 | |||||||||||||
26857 | 26857 | Aime Forand F000255 | rep | RI | 1955-01-05 | 1957-01-03 | Democrat | 1 | |||||||||||||
26858 | 26858 | Aime Forand F000255 | rep | RI | 1957-01-03 | 1959-01-03 | Democrat | 1 | |||||||||||||
26859 | 26859 | Aime Forand F000255 | rep | RI | 1959-01-07 | 1961-01-03 | Democrat | 1 | |||||||||||||
26860 | 26860 | Newell George G000130 | rep | KS | 1959-01-07 | 1961-01-03 | Democrat | 2 | |||||||||||||
26861 | 26861 | David Hall H000048 | rep | NC | 1959-01-07 | 1961-01-03 | Democrat | 12 | |||||||||||||
26862 | 26862 | Denver Hargis H000204 | rep | KS | 1959-01-07 | 1961-01-03 | Democrat | 3 | |||||||||||||
26863 | 26863 | Randall Harmon H000216 | rep | IN | 1959-01-07 | 1961-01-03 | Democrat | 10 | |||||||||||||
26864 | 26864 | John Henderson H000484 | rep | OH | 1955-01-05 | 1957-01-03 | Republican | 15 | |||||||||||||
26865 | 26865 | John Henderson H000484 | rep | OH | 1957-01-03 | 1959-01-03 | Republican | 15 | |||||||||||||
26866 | 26866 | John Henderson H000484 | rep | OH | 1959-01-07 | 1961-01-03 | Republican | 15 | |||||||||||||
26867 | 26867 | William Hess H000550 | rep | OH | 1929-04-15 | 1931-03-03 | Republican | 2 | |||||||||||||
26868 | 26868 | William Hess H000550 | rep | OH | 1931-12-07 | 1933-03-03 | Republican | 2 | |||||||||||||
26869 | 26869 | William Hess H000550 | rep | OH | 1933-03-09 | 1935-01-03 | Republican | 2 | |||||||||||||
26870 | 26870 | William Hess H000550 | rep | OH | 1935-01-03 | 1937-01-03 | Republican | 2 | |||||||||||||
26871 | 26871 | William Hess H000550 | rep | OH | 1939-01-03 | 1941-01-03 | Republican | 2 | |||||||||||||
26872 | 26872 | William Hess H000550 | rep | OH | 1941-01-03 | 1943-01-03 | Republican | 2 | |||||||||||||
26873 | 26873 | William Hess H000550 | rep | OH | 1943-01-06 | 1945-01-03 | Republican | 2 | |||||||||||||
26874 | 26874 | William Hess H000550 | rep | OH | 1945-01-03 | 1947-01-03 | Republican | 2 | |||||||||||||
26875 | 26875 | William Hess H000550 | rep | OH | 1947-01-03 | 1949-01-03 | Republican | 2 | |||||||||||||
26876 | 26876 | William Hess H000550 | rep | OH | 1951-01-03 | 1953-01-03 | Republican | 2 | |||||||||||||
26877 | 26877 | William Hess H000550 | rep | OH | 1953-01-03 | 1955-01-03 | Republican | 2 | |||||||||||||
26878 | 26878 | William Hess H000550 | rep | OH | 1955-01-05 | 1957-01-03 | Republican | 2 | |||||||||||||
26879 | 26879 | William Hess H000550 | rep | OH | 1957-01-03 | 1959-01-03 | Republican | 2 | |||||||||||||
26880 | 26880 | William Hess H000550 | rep | OH | 1959-01-07 | 1961-01-03 | Republican | 2 | |||||||||||||
26881 | 26881 | Earl Hogan H000690 | rep | IN | 1959-01-07 | 1961-01-03 | Democrat | 9 | |||||||||||||
26882 | 26882 | Joseph Holt H000746 | rep | CA | 1953-01-03 | 1955-01-03 | Republican | 22 | |||||||||||||
26883 | 26883 | Joseph Holt H000746 | rep | CA | 1955-01-05 | 1957-01-03 | Republican | 22 | |||||||||||||
26884 | 26884 | Joseph Holt H000746 | rep | CA | 1957-01-03 | 1959-01-03 | Republican | 22 | |||||||||||||
26885 | 26885 | Joseph Holt H000746 | rep | CA | 1959-01-07 | 1961-01-03 | Republican | 22 | |||||||||||||
26886 | 26886 | Donald Jackson J000008 | rep | CA | 1947-01-03 | 1949-01-03 | Republican | 16 | |||||||||||||
26887 | 26887 | Donald Jackson J000008 | rep | CA | 1949-01-03 | 1951-01-03 | Republican | 16 | |||||||||||||
26888 | 26888 | Donald Jackson J000008 | rep | CA | 1951-01-03 | 1953-01-03 | Republican | 16 | |||||||||||||
26889 | 26889 | Donald Jackson J000008 | rep | CA | 1953-01-03 | 1955-01-03 | Republican | 16 | |||||||||||||
26890 | 26890 | Donald Jackson J000008 | rep | CA | 1955-01-05 | 1957-01-03 | Republican | 16 |
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);