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
- 1985-01-03 477
- 2015-01-03 476
- 1989-01-03 475
- 1993-01-03 475
- 1995-01-03 474
- 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
- 1977-01-03 467
- 1979-01-03 463
- 1975-01-03 379
- 1973-01-03 298
- 1971-01-03 264
- 1969-01-03 238
- 1967-01-03 193
- 1965-01-03 161
- …
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
30800 | 30800 | Bella Abzug A000018 | rep | NY | 1971-01-21 | 1973-01-03 | Democrat | 19 | |||||||||||||
30801 | 30801 | Bella Abzug A000018 | rep | NY | 1973-01-03 | 1975-01-03 | Democrat | 20 | |||||||||||||
30802 | 30802 | Bella Abzug A000018 | rep | NY | 1975-01-14 | 1977-01-03 | Democrat | 20 | |||||||||||||
30803 | 30803 | Carl Albert A000073 | rep | OK | 1947-01-03 | 1949-01-03 | Democrat | 3 | |||||||||||||
30804 | 30804 | Carl Albert A000073 | rep | OK | 1949-01-03 | 1951-01-03 | Democrat | 3 | |||||||||||||
30805 | 30805 | Carl Albert A000073 | rep | OK | 1951-01-03 | 1953-01-03 | Democrat | 3 | |||||||||||||
30806 | 30806 | Carl Albert A000073 | rep | OK | 1953-01-03 | 1955-01-03 | Democrat | 3 | |||||||||||||
30807 | 30807 | Carl Albert A000073 | rep | OK | 1955-01-05 | 1957-01-03 | Democrat | 3 | |||||||||||||
30808 | 30808 | Carl Albert A000073 | rep | OK | 1957-01-03 | 1959-01-03 | Democrat | 3 | |||||||||||||
30809 | 30809 | Carl Albert A000073 | rep | OK | 1959-01-07 | 1961-01-03 | Democrat | 3 | |||||||||||||
30810 | 30810 | Carl Albert A000073 | rep | OK | 1961-01-03 | 1963-01-03 | Democrat | 3 | |||||||||||||
30811 | 30811 | Carl Albert A000073 | rep | OK | 1963-01-09 | 1965-01-03 | Democrat | 3 | |||||||||||||
30812 | 30812 | Carl Albert A000073 | rep | OK | 1965-01-04 | 1967-01-03 | Democrat | 3 | |||||||||||||
30813 | 30813 | Carl Albert A000073 | rep | OK | 1967-01-10 | 1969-01-03 | Democrat | 3 | |||||||||||||
30814 | 30814 | Carl Albert A000073 | rep | OK | 1969-01-03 | 1971-01-03 | Democrat | 3 | |||||||||||||
30815 | 30815 | Carl Albert A000073 | rep | OK | 1971-01-21 | 1973-01-03 | Democrat | 3 | |||||||||||||
30816 | 30816 | Carl Albert A000073 | rep | OK | 1973-01-03 | 1975-01-03 | Democrat | 3 | |||||||||||||
30817 | 30817 | Carl Albert A000073 | rep | OK | 1975-01-14 | 1977-01-03 | Democrat | 3 | |||||||||||||
30818 | 30818 | James Allen A000127 | sen | AL | 1969-01-03 | 1975-01-03 | 3 | Democrat | |||||||||||||
30819 | 30819 | James Allen A000127 | sen | AL | 1975-01-14 | 1978-06-01 | 3 | Democrat | |||||||||||||
30820 | 30820 | William Barrett B000178 | rep | PA | 1945-01-03 | 1947-01-03 | Democrat | 1 | |||||||||||||
30821 | 30821 | William Barrett B000178 | rep | PA | 1949-01-03 | 1951-01-03 | Democrat | 1 | |||||||||||||
30822 | 30822 | William Barrett B000178 | rep | PA | 1951-01-03 | 1953-01-03 | Democrat | 1 | |||||||||||||
30823 | 30823 | William Barrett B000178 | rep | PA | 1953-01-03 | 1955-01-03 | Democrat | 1 | |||||||||||||
30824 | 30824 | William Barrett B000178 | rep | PA | 1955-01-05 | 1957-01-03 | Democrat | 1 | |||||||||||||
30825 | 30825 | William Barrett B000178 | rep | PA | 1957-01-03 | 1959-01-03 | Democrat | 1 | |||||||||||||
30826 | 30826 | William Barrett B000178 | rep | PA | 1959-01-07 | 1961-01-03 | Democrat | 1 | |||||||||||||
30827 | 30827 | William Barrett B000178 | rep | PA | 1961-01-03 | 1963-01-03 | Democrat | 1 | |||||||||||||
30828 | 30828 | William Barrett B000178 | rep | PA | 1963-01-09 | 1965-01-03 | Democrat | 1 | |||||||||||||
30829 | 30829 | William Barrett B000178 | rep | PA | 1965-01-04 | 1967-01-03 | Democrat | 1 | |||||||||||||
30830 | 30830 | William Barrett B000178 | rep | PA | 1967-01-10 | 1969-01-03 | Democrat | 1 | |||||||||||||
30831 | 30831 | William Barrett B000178 | rep | PA | 1969-01-03 | 1971-01-03 | Democrat | 1 | |||||||||||||
30832 | 30832 | William Barrett B000178 | rep | PA | 1971-01-21 | 1973-01-03 | Democrat | 1 | |||||||||||||
30833 | 30833 | William Barrett B000178 | rep | PA | 1973-01-03 | 1975-01-03 | Democrat | 1 | |||||||||||||
30834 | 30834 | William Barrett B000178 | rep | PA | 1975-01-14 | 1977-01-03 | Democrat | 1 | |||||||||||||
30835 | 30835 | Birch Bayh B000254 | sen | IN | 1963-01-09 | 1969-01-03 | 3 | Democrat | |||||||||||||
30836 | 30836 | Birch Bayh B000254 | sen | IN | 1969-01-03 | 1975-01-03 | 3 | Democrat | |||||||||||||
30837 | 30837 | Birch Bayh B000254 | sen | IN | 1975-01-14 | 1981-01-03 | 3 | Democrat | |||||||||||||
30838 | 30838 | Alphonzo Bell B000330 | rep | CA | 1961-01-03 | 1963-01-03 | Republican | 16 | |||||||||||||
30839 | 30839 | Alphonzo Bell B000330 | rep | CA | 1963-01-09 | 1965-01-03 | Republican | 28 | |||||||||||||
30840 | 30840 | Alphonzo Bell B000330 | rep | CA | 1965-01-04 | 1967-01-03 | Republican | 28 | |||||||||||||
30841 | 30841 | Alphonzo Bell B000330 | rep | CA | 1967-01-10 | 1969-01-03 | Republican | 28 | |||||||||||||
30842 | 30842 | Alphonzo Bell B000330 | rep | CA | 1969-01-03 | 1971-01-03 | Republican | 28 | |||||||||||||
30843 | 30843 | Alphonzo Bell B000330 | rep | CA | 1971-01-21 | 1973-01-03 | Republican | 28 | |||||||||||||
30844 | 30844 | Alphonzo Bell B000330 | rep | CA | 1973-01-03 | 1975-01-03 | Republican | 28 | |||||||||||||
30845 | 30845 | Alphonzo Bell B000330 | rep | CA | 1975-01-14 | 1977-01-03 | Republican | 27 | |||||||||||||
30846 | 30846 | Henry Bellmon B000351 | sen | OK | 1969-01-03 | 1975-01-03 | 3 | Republican | |||||||||||||
30847 | 30847 | Henry Bellmon B000351 | sen | OK | 1975-01-14 | 1981-01-03 | 3 | Republican | |||||||||||||
30848 | 30848 | Jaime Benítez B000362 | rep | PR | 1973-01-03 | 1975-01-03 | Popular Democrat | 0 | |||||||||||||
30849 | 30849 | Jaime Benítez B000362 | rep | PR | 1975-01-14 | 1977-01-03 | Popular Democrat | 0 | |||||||||||||
30850 | 30850 | Edward Biester B000451 | rep | PA | 1967-01-10 | 1969-01-03 | Republican | 8 | |||||||||||||
30851 | 30851 | Edward Biester B000451 | rep | PA | 1969-01-03 | 1971-01-03 | Republican | 8 | |||||||||||||
30852 | 30852 | Edward Biester B000451 | rep | PA | 1971-01-21 | 1973-01-03 | Republican | 8 | |||||||||||||
30853 | 30853 | Edward Biester B000451 | rep | PA | 1973-01-03 | 1975-01-03 | Republican | 8 | |||||||||||||
30854 | 30854 | Edward Biester B000451 | rep | PA | 1975-01-14 | 1977-01-03 | Republican | 8 | |||||||||||||
30855 | 30855 | Robert Casey C000228 | rep | TX | 1959-01-07 | 1961-01-03 | Democrat | 22 | |||||||||||||
30856 | 30856 | Robert Casey C000228 | rep | TX | 1961-01-03 | 1963-01-03 | Democrat | 22 | |||||||||||||
30857 | 30857 | Robert Casey C000228 | rep | TX | 1963-01-09 | 1965-01-03 | Democrat | 22 | |||||||||||||
30858 | 30858 | Robert Casey C000228 | rep | TX | 1965-01-04 | 1967-01-03 | Democrat | 22 | |||||||||||||
30859 | 30859 | Robert Casey C000228 | rep | TX | 1967-01-10 | 1969-01-03 | Democrat | 22 | |||||||||||||
30860 | 30860 | Robert Casey C000228 | rep | TX | 1969-01-03 | 1971-01-03 | Democrat | 22 | |||||||||||||
30861 | 30861 | Robert Casey C000228 | rep | TX | 1971-01-21 | 1973-01-03 | Democrat | 22 | |||||||||||||
30862 | 30862 | Robert Casey C000228 | rep | TX | 1973-01-03 | 1975-01-03 | Democrat | 22 | |||||||||||||
30863 | 30863 | Robert Casey C000228 | rep | TX | 1975-01-14 | 1977-01-03 | Democrat | 22 | |||||||||||||
30864 | 30864 | Frank Church C000388 | sen | ID | 1957-01-03 | 1963-01-03 | 3 | Democrat | |||||||||||||
30865 | 30865 | Frank Church C000388 | sen | ID | 1963-01-09 | 1969-01-03 | 3 | Democrat | |||||||||||||
30866 | 30866 | Frank Church C000388 | sen | ID | 1969-01-03 | 1975-01-03 | 3 | Democrat | |||||||||||||
30867 | 30867 | Frank Church C000388 | sen | ID | 1975-01-14 | 1981-01-03 | 3 | Democrat | |||||||||||||
30868 | 30868 | Donald Clancy C000409 | rep | OH | 1961-01-03 | 1963-01-03 | Republican | 2 | |||||||||||||
30869 | 30869 | Donald Clancy C000409 | rep | OH | 1963-01-09 | 1965-01-03 | Republican | 2 | |||||||||||||
30870 | 30870 | Donald Clancy C000409 | rep | OH | 1965-01-04 | 1967-01-03 | Republican | 2 | |||||||||||||
30871 | 30871 | Donald Clancy C000409 | rep | OH | 1967-01-10 | 1969-01-03 | Republican | 2 | |||||||||||||
30872 | 30872 | Donald Clancy C000409 | rep | OH | 1969-01-03 | 1971-01-03 | Republican | 2 | |||||||||||||
30873 | 30873 | Donald Clancy C000409 | rep | OH | 1971-01-21 | 1973-01-03 | Republican | 2 | |||||||||||||
30874 | 30874 | Donald Clancy C000409 | rep | OH | 1973-01-03 | 1975-01-03 | Republican | 2 | |||||||||||||
30875 | 30875 | Donald Clancy C000409 | rep | OH | 1975-01-14 | 1977-01-03 | Republican | 2 | |||||||||||||
30876 | 30876 | John Conlan C000682 | rep | AZ | 1973-01-03 | 1975-01-03 | Republican | 4 | |||||||||||||
30877 | 30877 | John Conlan C000682 | rep | AZ | 1975-01-14 | 1977-01-03 | Republican | 4 | |||||||||||||
30878 | 30878 | Norris Cotton C000802 | rep | NH | 1947-01-03 | 1949-01-03 | Republican | 2 | |||||||||||||
30879 | 30879 | Norris Cotton C000802 | rep | NH | 1949-01-03 | 1951-01-03 | Republican | 2 | |||||||||||||
30880 | 30880 | Norris Cotton C000802 | rep | NH | 1951-01-03 | 1953-01-03 | Republican | 2 | |||||||||||||
30881 | 30881 | Norris Cotton C000802 | sen | NH | 1954-11-08 | 1957-01-03 | 3 | Republican | |||||||||||||
30882 | 30882 | Norris Cotton C000802 | sen | NH | 1957-01-03 | 1963-01-03 | 3 | Republican | |||||||||||||
30883 | 30883 | Norris Cotton C000802 | sen | NH | 1963-01-09 | 1969-01-03 | 3 | Republican | |||||||||||||
30884 | 30884 | Norris Cotton C000802 | sen | NH | 1969-01-03 | 1974-12-31 | 3 | Republican | |||||||||||||
30885 | 30885 | Norris Cotton C000802 | sen | NH | 1975-08-08 | 1975-09-18 | 3 | Republican | appointment | ||||||||||||
30886 | 30886 | John Culver C000979 | rep | IA | 1965-01-04 | 1967-01-03 | Democrat | 2 | |||||||||||||
30887 | 30887 | John Culver C000979 | rep | IA | 1967-01-10 | 1969-01-03 | Democrat | 2 | |||||||||||||
30888 | 30888 | John Culver C000979 | rep | IA | 1969-01-03 | 1971-01-03 | Democrat | 2 | |||||||||||||
30889 | 30889 | John Culver C000979 | rep | IA | 1971-01-21 | 1973-01-03 | Democrat | 2 | |||||||||||||
30890 | 30890 | John Culver C000979 | rep | IA | 1973-01-03 | 1975-01-03 | Democrat | 2 | |||||||||||||
30891 | 30891 | John Culver C000979 | sen | IA | 1975-01-14 | 1981-01-03 | 3 | Democrat | |||||||||||||
30892 | 30892 | Dominick Daniels D000041 | rep | NJ | 1959-01-07 | 1961-01-03 | Democrat | 14 | |||||||||||||
30893 | 30893 | Dominick Daniels D000041 | rep | NJ | 1961-01-03 | 1963-01-03 | Democrat | 14 | |||||||||||||
30894 | 30894 | Dominick Daniels D000041 | rep | NJ | 1963-01-09 | 1965-01-03 | Democrat | 14 | |||||||||||||
30895 | 30895 | Dominick Daniels D000041 | rep | NJ | 1965-01-04 | 1967-01-03 | Democrat | 14 | |||||||||||||
30896 | 30896 | Dominick Daniels D000041 | rep | NJ | 1967-01-10 | 1969-01-03 | Democrat | 14 | |||||||||||||
30897 | 30897 | Dominick Daniels D000041 | rep | NJ | 1969-01-03 | 1971-01-03 | Democrat | 14 | |||||||||||||
30898 | 30898 | Dominick Daniels D000041 | rep | NJ | 1971-01-21 | 1973-01-03 | Democrat | 14 | |||||||||||||
30899 | 30899 | Dominick Daniels D000041 | rep | NJ | 1973-01-03 | 1975-01-03 | Democrat | 14 |
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);