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)
end (date) >30 ✖
- 1983-01-03 481
- 1981-01-03 479
- 1987-01-03 478
- 1979-01-03 477
- 1985-01-03 477
- 2015-01-03 476
- 1977-01-03 475
- 1989-01-03 475
- 1993-01-03 475
- 1995-01-03 474
- 1975-01-03 473
- 1991-01-03 473
- 1999-01-03 473
- 2001-01-03 473
- 2011-01-03 473
- 2017-01-03 473
- 1997-01-03 472
- 2005-01-03 472
- 2009-01-03 472
- 2023-01-03 472
- 2003-01-03 471
- 2007-01-03 471
- 2013-01-03 470
- 2019-01-03 470
- 2021-01-03 469
- 1973-01-03 432
- 1971-01-03 383
- 1969-01-03 336
- 1967-01-03 274
- 1965-01-03 243
- …
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
29822 | 29822 | George Hagan H000010 | rep | GA | 1971-01-21 | 1973-01-03 | Democrat | 1 | |||||||||||||
29823 | 29823 | Durward Hall H000049 | rep | MO | 1961-01-03 | 1963-01-03 | Republican | 7 | |||||||||||||
29824 | 29824 | Durward Hall H000049 | rep | MO | 1963-01-09 | 1965-01-03 | Republican | 7 | |||||||||||||
29825 | 29825 | Durward Hall H000049 | rep | MO | 1965-01-04 | 1967-01-03 | Republican | 7 | |||||||||||||
29826 | 29826 | Durward Hall H000049 | rep | MO | 1967-01-10 | 1969-01-03 | Republican | 7 | |||||||||||||
29827 | 29827 | Durward Hall H000049 | rep | MO | 1969-01-03 | 1971-01-03 | Republican | 7 | |||||||||||||
29828 | 29828 | Durward Hall H000049 | rep | MO | 1971-01-21 | 1973-01-03 | Republican | 7 | |||||||||||||
29829 | 29829 | Seymour Halpern H000085 | rep | NY | 1959-01-07 | 1961-01-03 | Republican | 4 | |||||||||||||
29830 | 29830 | Seymour Halpern H000085 | rep | NY | 1961-01-03 | 1963-01-03 | Republican | 4 | |||||||||||||
29831 | 29831 | Seymour Halpern H000085 | rep | NY | 1963-01-09 | 1965-01-03 | Republican | 6 | |||||||||||||
29832 | 29832 | Seymour Halpern H000085 | rep | NY | 1965-01-04 | 1967-01-03 | Republican | 6 | |||||||||||||
29833 | 29833 | Seymour Halpern H000085 | rep | NY | 1967-01-10 | 1969-01-03 | Republican | 6 | |||||||||||||
29834 | 29834 | Seymour Halpern H000085 | rep | NY | 1969-01-03 | 1971-01-03 | Republican | 6 | |||||||||||||
29835 | 29835 | Seymour Halpern H000085 | rep | NY | 1971-01-21 | 1973-01-03 | Republican | 6 | |||||||||||||
29836 | 29836 | Philip Hart H000291 | sen | MI | 1959-01-07 | 1965-01-03 | 1 | Democrat | |||||||||||||
29837 | 29837 | Philip Hart H000291 | sen | MI | 1965-01-04 | 1971-01-03 | 1 | Democrat | |||||||||||||
29838 | 29838 | Philip Hart H000291 | sen | MI | 1971-01-21 | 1977-01-03 | 1 | Democrat | |||||||||||||
29839 | 29839 | Rupert Hartke H000297 | sen | IN | 1959-01-07 | 1965-01-03 | 1 | Democrat | |||||||||||||
29840 | 29840 | Rupert Hartke H000297 | sen | IN | 1965-01-04 | 1971-01-03 | 1 | Democrat | |||||||||||||
29841 | 29841 | Rupert Hartke H000297 | sen | IN | 1971-01-21 | 1977-01-03 | 1 | Democrat | |||||||||||||
29842 | 29842 | Louise Hicks H000566 | rep | MA | 1971-01-21 | 1973-01-03 | Democrat | 9 | |||||||||||||
29843 | 29843 | Roman Hruska H000875 | rep | NE | 1953-01-03 | 1954-11-08 | Republican | 2 | |||||||||||||
29844 | 29844 | Roman Hruska H000875 | sen | NE | 1954-11-08 | 1959-01-03 | 1 | Republican | |||||||||||||
29845 | 29845 | Roman Hruska H000875 | sen | NE | 1959-01-07 | 1965-01-03 | 1 | Republican | |||||||||||||
29846 | 29846 | Roman Hruska H000875 | sen | NE | 1965-01-04 | 1971-01-03 | 1 | Republican | |||||||||||||
29847 | 29847 | Roman Hruska H000875 | sen | NE | 1971-01-21 | 1976-12-27 | 1 | Republican | |||||||||||||
29848 | 29848 | William Hull H000947 | rep | MO | 1955-01-05 | 1957-01-03 | Democrat | 6 | |||||||||||||
29849 | 29849 | William Hull H000947 | rep | MO | 1957-01-03 | 1959-01-03 | Democrat | 6 | |||||||||||||
29850 | 29850 | William Hull H000947 | rep | MO | 1959-01-07 | 1961-01-03 | Democrat | 6 | |||||||||||||
29851 | 29851 | William Hull H000947 | rep | MO | 1961-01-03 | 1963-01-03 | Democrat | 6 | |||||||||||||
29852 | 29852 | William Hull H000947 | rep | MO | 1963-01-09 | 1965-01-03 | Democrat | 6 | |||||||||||||
29853 | 29853 | William Hull H000947 | rep | MO | 1965-01-04 | 1967-01-03 | Democrat | 6 | |||||||||||||
29854 | 29854 | William Hull H000947 | rep | MO | 1967-01-10 | 1969-01-03 | Democrat | 6 | |||||||||||||
29855 | 29855 | William Hull H000947 | rep | MO | 1969-01-03 | 1971-01-03 | Democrat | 6 | |||||||||||||
29856 | 29856 | William Hull H000947 | rep | MO | 1971-01-21 | 1973-01-03 | Democrat | 6 | |||||||||||||
29857 | 29857 | Charles Jonas J000206 | rep | NC | 1953-01-03 | 1955-01-03 | Republican | 10 | |||||||||||||
29858 | 29858 | Charles Jonas J000206 | rep | NC | 1955-01-05 | 1957-01-03 | Republican | 10 | |||||||||||||
29859 | 29859 | Charles Jonas J000206 | rep | NC | 1957-01-03 | 1959-01-03 | Republican | 10 | |||||||||||||
29860 | 29860 | Charles Jonas J000206 | rep | NC | 1959-01-07 | 1961-01-03 | Republican | 10 | |||||||||||||
29861 | 29861 | Charles Jonas J000206 | rep | NC | 1961-01-03 | 1963-01-03 | Republican | 10 | |||||||||||||
29862 | 29862 | Charles Jonas J000206 | rep | NC | 1963-01-09 | 1965-01-03 | Republican | 8 | |||||||||||||
29863 | 29863 | Charles Jonas J000206 | rep | NC | 1965-01-04 | 1967-01-03 | Republican | 8 | |||||||||||||
29864 | 29864 | Charles Jonas J000206 | rep | NC | 1967-01-10 | 1969-01-03 | Republican | 8 | |||||||||||||
29865 | 29865 | Charles Jonas J000206 | rep | NC | 1969-01-03 | 1971-01-03 | Republican | 9 | |||||||||||||
29866 | 29866 | Charles Jonas J000206 | rep | NC | 1971-01-21 | 1973-01-03 | Republican | 9 | |||||||||||||
29867 | 29867 | James Kee K000038 | rep | WV | 1965-01-04 | 1967-01-03 | Democrat | 5 | |||||||||||||
29868 | 29868 | James Kee K000038 | rep | WV | 1967-01-10 | 1969-01-03 | Democrat | 5 | |||||||||||||
29869 | 29869 | James Kee K000038 | rep | WV | 1969-01-03 | 1971-01-03 | Democrat | 5 | |||||||||||||
29870 | 29870 | James Kee K000038 | rep | WV | 1971-01-21 | 1973-01-03 | Democrat | 5 | |||||||||||||
29871 | 29871 | Hastings Keith K000053 | rep | MA | 1959-01-07 | 1961-01-03 | Republican | 9 | |||||||||||||
29872 | 29872 | Hastings Keith K000053 | rep | MA | 1961-01-03 | 1963-01-03 | Republican | 9 | |||||||||||||
29873 | 29873 | Hastings Keith K000053 | rep | MA | 1963-01-09 | 1965-01-03 | Republican | 12 | |||||||||||||
29874 | 29874 | Hastings Keith K000053 | rep | MA | 1965-01-04 | 1967-01-03 | Republican | 12 | |||||||||||||
29875 | 29875 | Hastings Keith K000053 | rep | MA | 1967-01-10 | 1969-01-03 | Republican | 12 | |||||||||||||
29876 | 29876 | Hastings Keith K000053 | rep | MA | 1969-01-03 | 1971-01-03 | Republican | 12 | |||||||||||||
29877 | 29877 | Hastings Keith K000053 | rep | MA | 1971-01-21 | 1973-01-03 | Republican | 12 | |||||||||||||
29878 | 29878 | John Kyl K000351 | rep | IA | 1959-01-07 | 1961-01-03 | Republican | 4 | |||||||||||||
29879 | 29879 | John Kyl K000351 | rep | IA | 1961-01-03 | 1963-01-03 | Republican | 4 | |||||||||||||
29880 | 29880 | John Kyl K000351 | rep | IA | 1963-01-09 | 1965-01-03 | Republican | 4 | |||||||||||||
29881 | 29881 | John Kyl K000351 | rep | IA | 1967-01-10 | 1969-01-03 | Republican | 4 | |||||||||||||
29882 | 29882 | John Kyl K000351 | rep | IA | 1969-01-03 | 1971-01-03 | Republican | 4 | |||||||||||||
29883 | 29883 | John Kyl K000351 | rep | IA | 1971-01-21 | 1973-01-03 | Republican | 4 | |||||||||||||
29884 | 29884 | Alton Lennon L000240 | sen | NC | 1953-07-10 | 1955-01-03 | 2 | Democrat | appointment | ||||||||||||
29885 | 29885 | Alton Lennon L000240 | rep | NC | 1957-01-03 | 1959-01-03 | Democrat | 7 | |||||||||||||
29886 | 29886 | Alton Lennon L000240 | rep | NC | 1959-01-07 | 1961-01-03 | Democrat | 7 | |||||||||||||
29887 | 29887 | Alton Lennon L000240 | rep | NC | 1961-01-03 | 1963-01-03 | Democrat | 7 | |||||||||||||
29888 | 29888 | Alton Lennon L000240 | rep | NC | 1963-01-09 | 1965-01-03 | Democrat | 7 | |||||||||||||
29889 | 29889 | Alton Lennon L000240 | rep | NC | 1965-01-04 | 1967-01-03 | Democrat | 7 | |||||||||||||
29890 | 29890 | Alton Lennon L000240 | rep | NC | 1967-01-10 | 1969-01-03 | Democrat | 7 | |||||||||||||
29891 | 29891 | Alton Lennon L000240 | rep | NC | 1969-01-03 | 1971-01-03 | Democrat | 7 | |||||||||||||
29892 | 29892 | Alton Lennon L000240 | rep | NC | 1971-01-21 | 1973-01-03 | Democrat | 7 | |||||||||||||
29893 | 29893 | Arthur Link L000333 | rep | ND | 1971-01-21 | 1973-01-03 | Democrat | 2 | |||||||||||||
29894 | 29894 | Sherman Lloyd L000382 | rep | UT | 1963-01-09 | 1965-01-03 | Republican | 2 | |||||||||||||
29895 | 29895 | Sherman Lloyd L000382 | rep | UT | 1967-01-10 | 1969-01-03 | Republican | 2 | |||||||||||||
29896 | 29896 | Sherman Lloyd L000382 | rep | UT | 1969-01-03 | 1971-01-03 | Republican | 2 | |||||||||||||
29897 | 29897 | Sherman Lloyd L000382 | rep | UT | 1971-01-21 | 1973-01-03 | Republican | 2 | |||||||||||||
29898 | 29898 | Speedy Long L000429 | rep | LA | 1965-01-04 | 1967-01-03 | Democrat | 8 | |||||||||||||
29899 | 29899 | Speedy Long L000429 | rep | LA | 1967-01-10 | 1969-01-03 | Democrat | 8 | |||||||||||||
29900 | 29900 | Speedy Long L000429 | rep | LA | 1969-01-03 | 1971-01-03 | Democrat | 8 | |||||||||||||
29901 | 29901 | Speedy Long L000429 | rep | LA | 1971-01-21 | 1973-01-03 | Democrat | 8 | |||||||||||||
29902 | 29902 | Michael Mansfield M000113 | rep | MT | 1943-01-06 | 1945-01-03 | Democrat | 1 | |||||||||||||
29903 | 29903 | Michael Mansfield M000113 | rep | MT | 1945-01-03 | 1947-01-03 | Democrat | 1 | |||||||||||||
29904 | 29904 | Michael Mansfield M000113 | rep | MT | 1947-01-03 | 1949-01-03 | Democrat | 1 | |||||||||||||
29905 | 29905 | Michael Mansfield M000113 | rep | MT | 1949-01-03 | 1951-01-03 | Democrat | 1 | |||||||||||||
29906 | 29906 | Michael Mansfield M000113 | rep | MT | 1951-01-03 | 1953-01-03 | Democrat | 1 | |||||||||||||
29907 | 29907 | Michael Mansfield M000113 | sen | MT | 1953-01-03 | 1959-01-03 | 1 | Democrat | |||||||||||||
29908 | 29908 | Michael Mansfield M000113 | sen | MT | 1959-01-07 | 1965-01-03 | 1 | Democrat | |||||||||||||
29909 | 29909 | Michael Mansfield M000113 | sen | MT | 1965-01-04 | 1971-01-03 | 1 | Democrat | |||||||||||||
29910 | 29910 | Michael Mansfield M000113 | sen | MT | 1971-01-21 | 1977-01-03 | 1 | Democrat | |||||||||||||
29911 | 29911 | William McCulloch M000393 | rep | OH | 1947-01-03 | 1949-01-03 | Republican | 4 | |||||||||||||
29912 | 29912 | William McCulloch M000393 | rep | OH | 1949-01-03 | 1951-01-03 | Republican | 4 | |||||||||||||
29913 | 29913 | William McCulloch M000393 | rep | OH | 1951-01-03 | 1953-01-03 | Republican | 4 | |||||||||||||
29914 | 29914 | William McCulloch M000393 | rep | OH | 1953-01-03 | 1955-01-03 | Republican | 4 | |||||||||||||
29915 | 29915 | William McCulloch M000393 | rep | OH | 1955-01-05 | 1957-01-03 | Republican | 4 | |||||||||||||
29916 | 29916 | William McCulloch M000393 | rep | OH | 1957-01-03 | 1959-01-03 | Republican | 4 | |||||||||||||
29917 | 29917 | William McCulloch M000393 | rep | OH | 1959-01-07 | 1961-01-03 | Republican | 4 | |||||||||||||
29918 | 29918 | William McCulloch M000393 | rep | OH | 1961-01-03 | 1963-01-03 | Republican | 4 | |||||||||||||
29919 | 29919 | William McCulloch M000393 | rep | OH | 1963-01-09 | 1965-01-03 | Republican | 4 | |||||||||||||
29920 | 29920 | William McCulloch M000393 | rep | OH | 1965-01-04 | 1967-01-03 | Republican | 4 | |||||||||||||
29921 | 29921 | William McCulloch M000393 | rep | OH | 1967-01-10 | 1969-01-03 | Republican | 4 |
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);