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 ✖
- 1981-01-05 482
- 1989-01-03 481
- 1983-01-03 478
- 1991-01-03 478
- 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
- 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
- 2021-01-03 471
- 1979-01-15 459
- 1977-01-04 378
- 1975-01-14 315
- 1973-01-03 232
- 1971-01-21 184
- 1969-01-03 161
- 1967-01-10 135
- 1965-01-04 112
- 1963-01-09 80
- …
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
32048 | 32048 | Robert Duncan D000537 | rep | OR | 1979-01-15 | 1981-01-03 | Democrat | 3 | |||||||||||||
32049 | 32049 | Robert Eckhardt E000035 | rep | TX | 1967-01-10 | 1969-01-03 | Democrat | 8 | |||||||||||||
32050 | 32050 | Robert Eckhardt E000035 | rep | TX | 1969-01-03 | 1971-01-03 | Democrat | 8 | |||||||||||||
32051 | 32051 | Robert Eckhardt E000035 | rep | TX | 1971-01-21 | 1973-01-03 | Democrat | 8 | |||||||||||||
32052 | 32052 | Robert Eckhardt E000035 | rep | TX | 1973-01-03 | 1975-01-03 | Democrat | 8 | |||||||||||||
32053 | 32053 | Robert Eckhardt E000035 | rep | TX | 1975-01-14 | 1977-01-03 | Democrat | 8 | |||||||||||||
32054 | 32054 | Robert Eckhardt E000035 | rep | TX | 1977-01-04 | 1979-01-03 | Democrat | 8 | |||||||||||||
32055 | 32055 | Robert Eckhardt E000035 | rep | TX | 1979-01-15 | 1981-01-03 | Democrat | 8 | |||||||||||||
32056 | 32056 | Melvin Evans E000254 | rep | VI | 1979-01-15 | 1981-01-03 | Republican | 0 | |||||||||||||
32057 | 32057 | Joseph Fisher F000151 | rep | VA | 1975-01-14 | 1977-01-03 | Democrat | 10 | |||||||||||||
32058 | 32058 | Joseph Fisher F000151 | rep | VA | 1977-01-04 | 1979-01-03 | Democrat | 10 | |||||||||||||
32059 | 32059 | Joseph Fisher F000151 | rep | VA | 1979-01-15 | 1981-01-03 | Democrat | 10 | |||||||||||||
32060 | 32060 | Daniel Flood F000209 | rep | PA | 1945-01-03 | 1947-01-03 | Democrat | 11 | |||||||||||||
32061 | 32061 | Daniel Flood F000209 | rep | PA | 1949-01-03 | 1951-01-03 | Democrat | 11 | |||||||||||||
32062 | 32062 | Daniel Flood F000209 | rep | PA | 1951-01-03 | 1953-01-03 | Democrat | 11 | |||||||||||||
32063 | 32063 | Daniel Flood F000209 | rep | PA | 1955-01-05 | 1957-01-03 | Democrat | 11 | |||||||||||||
32064 | 32064 | Daniel Flood F000209 | rep | PA | 1957-01-03 | 1959-01-03 | Democrat | 11 | |||||||||||||
32065 | 32065 | Daniel Flood F000209 | rep | PA | 1959-01-07 | 1961-01-03 | Democrat | 11 | |||||||||||||
32066 | 32066 | Daniel Flood F000209 | rep | PA | 1961-01-03 | 1963-01-03 | Democrat | 11 | |||||||||||||
32067 | 32067 | Daniel Flood F000209 | rep | PA | 1963-01-09 | 1965-01-03 | Democrat | 11 | |||||||||||||
32068 | 32068 | Daniel Flood F000209 | rep | PA | 1965-01-04 | 1967-01-03 | Democrat | 11 | |||||||||||||
32069 | 32069 | Daniel Flood F000209 | rep | PA | 1967-01-10 | 1969-01-03 | Democrat | 11 | |||||||||||||
32070 | 32070 | Daniel Flood F000209 | rep | PA | 1969-01-03 | 1971-01-03 | Democrat | 11 | |||||||||||||
32071 | 32071 | Daniel Flood F000209 | rep | PA | 1971-01-21 | 1973-01-03 | Democrat | 11 | |||||||||||||
32072 | 32072 | Daniel Flood F000209 | rep | PA | 1973-01-03 | 1975-01-03 | Democrat | 11 | |||||||||||||
32073 | 32073 | Daniel Flood F000209 | rep | PA | 1975-01-14 | 1977-01-03 | Democrat | 11 | |||||||||||||
32074 | 32074 | Daniel Flood F000209 | rep | PA | 1977-01-04 | 1979-01-03 | Democrat | 11 | |||||||||||||
32075 | 32075 | Daniel Flood F000209 | rep | PA | 1979-01-15 | 1981-01-03 | Democrat | 11 | |||||||||||||
32076 | 32076 | Robert Giaimo G000151 | rep | CT | 1959-01-07 | 1961-01-03 | Democrat | 3 | |||||||||||||
32077 | 32077 | Robert Giaimo G000151 | rep | CT | 1961-01-03 | 1963-01-03 | Democrat | 3 | |||||||||||||
32078 | 32078 | Robert Giaimo G000151 | rep | CT | 1963-01-09 | 1965-01-03 | Democrat | 3 | |||||||||||||
32079 | 32079 | Robert Giaimo G000151 | rep | CT | 1965-01-04 | 1967-01-03 | Democrat | 3 | |||||||||||||
32080 | 32080 | Robert Giaimo G000151 | rep | CT | 1967-01-10 | 1969-01-03 | Democrat | 3 | |||||||||||||
32081 | 32081 | Robert Giaimo G000151 | rep | CT | 1969-01-03 | 1971-01-03 | Democrat | 3 | |||||||||||||
32082 | 32082 | Robert Giaimo G000151 | rep | CT | 1971-01-21 | 1973-01-03 | Democrat | 3 | |||||||||||||
32083 | 32083 | Robert Giaimo G000151 | rep | CT | 1973-01-03 | 1975-01-03 | Democrat | 3 | |||||||||||||
32084 | 32084 | Robert Giaimo G000151 | rep | CT | 1975-01-14 | 1977-01-03 | Democrat | 3 | |||||||||||||
32085 | 32085 | Robert Giaimo G000151 | rep | CT | 1977-01-04 | 1979-01-03 | Democrat | 3 | |||||||||||||
32086 | 32086 | Robert Giaimo G000151 | rep | CT | 1979-01-15 | 1981-01-03 | Democrat | 3 | |||||||||||||
32087 | 32087 | Vonno Gudger G000515 | rep | NC | 1977-01-04 | 1979-01-03 | Democrat | 11 | |||||||||||||
32088 | 32088 | Vonno Gudger G000515 | rep | NC | 1979-01-15 | 1981-01-03 | Democrat | 11 | |||||||||||||
32089 | 32089 | James Hanley H000158 | rep | NY | 1965-01-04 | 1967-01-03 | Democrat | 34 | |||||||||||||
32090 | 32090 | James Hanley H000158 | rep | NY | 1967-01-10 | 1969-01-03 | Democrat | 34 | |||||||||||||
32091 | 32091 | James Hanley H000158 | rep | NY | 1969-01-03 | 1971-01-03 | Democrat | 34 | |||||||||||||
32092 | 32092 | James Hanley H000158 | rep | NY | 1971-01-21 | 1973-01-03 | Democrat | 35 | |||||||||||||
32093 | 32093 | James Hanley H000158 | rep | NY | 1973-01-03 | 1975-01-03 | Democrat | 32 | |||||||||||||
32094 | 32094 | James Hanley H000158 | rep | NY | 1975-01-14 | 1977-01-03 | Democrat | 32 | |||||||||||||
32095 | 32095 | James Hanley H000158 | rep | NY | 1977-01-04 | 1979-01-03 | Democrat | 32 | |||||||||||||
32096 | 32096 | James Hanley H000158 | rep | NY | 1979-01-15 | 1981-01-03 | Democrat | 32 | |||||||||||||
32097 | 32097 | Herbert Harris H000241 | rep | VA | 1975-01-14 | 1977-01-03 | Democrat | 8 | |||||||||||||
32098 | 32098 | Herbert Harris H000241 | rep | VA | 1977-01-04 | 1979-01-03 | Democrat | 8 | |||||||||||||
32099 | 32099 | Herbert Harris H000241 | rep | VA | 1979-01-15 | 1981-01-03 | Democrat | 8 | |||||||||||||
32100 | 32100 | William Harsha H000281 | rep | OH | 1961-01-03 | 1963-01-03 | Republican | 6 | |||||||||||||
32101 | 32101 | William Harsha H000281 | rep | OH | 1963-01-09 | 1965-01-03 | Republican | 6 | |||||||||||||
32102 | 32102 | William Harsha H000281 | rep | OH | 1965-01-04 | 1967-01-03 | Republican | 6 | |||||||||||||
32103 | 32103 | William Harsha H000281 | rep | OH | 1967-01-10 | 1969-01-03 | Republican | 6 | |||||||||||||
32104 | 32104 | William Harsha H000281 | rep | OH | 1969-01-03 | 1971-01-03 | Republican | 6 | |||||||||||||
32105 | 32105 | William Harsha H000281 | rep | OH | 1971-01-21 | 1973-01-03 | Republican | 6 | |||||||||||||
32106 | 32106 | William Harsha H000281 | rep | OH | 1973-01-03 | 1975-01-03 | Republican | 6 | |||||||||||||
32107 | 32107 | William Harsha H000281 | rep | OH | 1975-01-14 | 1977-01-03 | Republican | 6 | |||||||||||||
32108 | 32108 | William Harsha H000281 | rep | OH | 1977-01-04 | 1979-01-03 | Republican | 6 | |||||||||||||
32109 | 32109 | William Harsha H000281 | rep | OH | 1979-01-15 | 1981-01-03 | Republican | 6 | |||||||||||||
32110 | 32110 | Elizabeth Holtzman H000752 | rep | NY | 1973-01-03 | 1975-01-03 | Democrat | 16 | |||||||||||||
32111 | 32111 | Elizabeth Holtzman H000752 | rep | NY | 1975-01-14 | 1977-01-03 | Democrat | 16 | |||||||||||||
32112 | 32112 | Elizabeth Holtzman H000752 | rep | NY | 1977-01-04 | 1979-01-03 | Democrat | 16 | |||||||||||||
32113 | 32113 | Elizabeth Holtzman H000752 | rep | NY | 1979-01-15 | 1981-01-03 | Democrat | 16 | |||||||||||||
32114 | 32114 | Walter Huddleston H000905 | sen | KY | 1973-01-03 | 1979-01-03 | 2 | Democrat | |||||||||||||
32115 | 32115 | Walter Huddleston H000905 | sen | KY | 1979-01-15 | 1985-01-03 | 2 | Democrat | |||||||||||||
32116 | 32116 | John Hutchinson H001013 | rep | WV | 1979-01-15 | 1981-01-03 | Democrat | 3 | |||||||||||||
32117 | 32117 | Richard Ichord I000001 | rep | MO | 1961-01-03 | 1963-01-03 | Democrat | 8 | |||||||||||||
32118 | 32118 | Richard Ichord I000001 | rep | MO | 1963-01-09 | 1965-01-03 | Democrat | 8 | |||||||||||||
32119 | 32119 | Richard Ichord I000001 | rep | MO | 1965-01-04 | 1967-01-03 | Democrat | 8 | |||||||||||||
32120 | 32120 | Richard Ichord I000001 | rep | MO | 1967-01-10 | 1969-01-03 | Democrat | 8 | |||||||||||||
32121 | 32121 | Richard Ichord I000001 | rep | MO | 1969-01-03 | 1971-01-03 | Democrat | 8 | |||||||||||||
32122 | 32122 | Richard Ichord I000001 | rep | MO | 1971-01-21 | 1973-01-03 | Democrat | 8 | |||||||||||||
32123 | 32123 | Richard Ichord I000001 | rep | MO | 1973-01-03 | 1975-01-03 | Democrat | 8 | |||||||||||||
32124 | 32124 | Richard Ichord I000001 | rep | MO | 1975-01-14 | 1977-01-03 | Democrat | 8 | |||||||||||||
32125 | 32125 | Richard Ichord I000001 | rep | MO | 1977-01-04 | 1979-01-03 | Democrat | 8 | |||||||||||||
32126 | 32126 | Richard Ichord I000001 | rep | MO | 1979-01-15 | 1981-01-03 | Democrat | 8 | |||||||||||||
32127 | 32127 | John Jenrette J000099 | rep | SC | 1975-01-14 | 1977-01-03 | Democrat | 6 | |||||||||||||
32128 | 32128 | John Jenrette J000099 | rep | SC | 1977-01-04 | 1979-01-03 | Democrat | 6 | |||||||||||||
32129 | 32129 | John Jenrette J000099 | rep | SC | 1979-01-15 | 1981-01-03 | Democrat | 6 | |||||||||||||
32130 | 32130 | Roger Jepsen J000101 | sen | IA | 1979-01-15 | 1985-01-03 | 2 | Republican | |||||||||||||
32131 | 32131 | Harold Johnson J000135 | rep | CA | 1959-01-07 | 1961-01-03 | Democrat | 2 | |||||||||||||
32132 | 32132 | Harold Johnson J000135 | rep | CA | 1961-01-03 | 1963-01-03 | Democrat | 2 | |||||||||||||
32133 | 32133 | Harold Johnson J000135 | rep | CA | 1963-01-09 | 1965-01-03 | Democrat | 2 | |||||||||||||
32134 | 32134 | Harold Johnson J000135 | rep | CA | 1965-01-04 | 1967-01-03 | Democrat | 2 | |||||||||||||
32135 | 32135 | Harold Johnson J000135 | rep | CA | 1967-01-10 | 1969-01-03 | Democrat | 2 | |||||||||||||
32136 | 32136 | Harold Johnson J000135 | rep | CA | 1969-01-03 | 1971-01-03 | Democrat | 2 | |||||||||||||
32137 | 32137 | Harold Johnson J000135 | rep | CA | 1971-01-21 | 1973-01-03 | Democrat | 2 | |||||||||||||
32138 | 32138 | Harold Johnson J000135 | rep | CA | 1973-01-03 | 1975-01-03 | Democrat | 2 | |||||||||||||
32139 | 32139 | Harold Johnson J000135 | rep | CA | 1975-01-14 | 1977-01-03 | Democrat | 1 | |||||||||||||
32140 | 32140 | Harold Johnson J000135 | rep | CA | 1977-01-04 | 1979-01-03 | Democrat | 1 | |||||||||||||
32141 | 32141 | Harold Johnson J000135 | rep | CA | 1979-01-15 | 1981-01-03 | Democrat | 1 | |||||||||||||
32142 | 32142 | James Johnson J000148 | rep | CO | 1973-01-03 | 1975-01-03 | Republican | 4 | |||||||||||||
32143 | 32143 | James Johnson J000148 | rep | CO | 1975-01-14 | 1977-01-03 | Republican | 4 | |||||||||||||
32144 | 32144 | James Johnson J000148 | rep | CO | 1977-01-04 | 1979-01-03 | Republican | 4 | |||||||||||||
32145 | 32145 | James Johnson J000148 | rep | CO | 1979-01-15 | 1981-01-03 | Republican | 4 | |||||||||||||
32146 | 32146 | Richard Kelly K000077 | rep | FL | 1975-01-14 | 1977-01-03 | Republican | 5 | |||||||||||||
32147 | 32147 | Richard Kelly K000077 | rep | FL | 1977-01-04 | 1979-01-03 | Republican | 5 |
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);