legislator_terms
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
44,551 rows sorted by district
This data as json, copyable, CSV (advanced)
start (date) >30 ✖
- 1975-01-14 391
- 1981-01-05 391
- 1989-01-03 391
- 1977-01-04 390
- 1979-01-15 390
- 1983-01-03 389
- 1987-01-06 388
- 1991-01-03 388
- 1973-01-03 387
- 1985-01-03 387
- 1997-01-07 387
- 1993-01-05 385
- 1995-01-04 385
- 1999-01-06 385
- 2003-01-07 385
- 2007-01-04 385
- 2011-01-05 385
- 1971-01-21 384
- 2001-01-03 384
- 2005-01-04 384
- 2009-01-06 384
- 2013-01-03 384
- 2015-01-06 384
- 2017-01-03 384
- 2019-01-03 383
- 2021-01-03 383
- 1969-01-03 382
- 1967-01-10 369
- 1965-01-04 368
- 1959-01-07 364
- …
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
30463 | 30463 | Orval Hansen H000175 | rep | ID | 1971-01-21 | 1973-01-03 | Republican | 2 | |||||||||||||
30464 | 30464 | Orval Hansen H000175 | rep | ID | 1973-01-03 | 1975-01-03 | Republican | 2 | |||||||||||||
30473 | 30473 | William Hathaway H000346 | rep | ME | 1965-01-04 | 1967-01-03 | Democrat | 2 | |||||||||||||
30474 | 30474 | William Hathaway H000346 | rep | ME | 1967-01-10 | 1969-01-03 | Democrat | 2 | |||||||||||||
30475 | 30475 | William Hathaway H000346 | rep | ME | 1969-01-03 | 1971-01-03 | Democrat | 2 | |||||||||||||
30476 | 30476 | William Hathaway H000346 | rep | ME | 1971-01-21 | 1973-01-03 | Democrat | 2 | |||||||||||||
30531 | 30531 | Earl Landgrebe L000049 | rep | IN | 1969-01-03 | 1971-01-03 | Republican | 2 | |||||||||||||
30532 | 30532 | Earl Landgrebe L000049 | rep | IN | 1971-01-21 | 1973-01-03 | Republican | 2 | |||||||||||||
30533 | 30533 | Earl Landgrebe L000049 | rep | IN | 1973-01-03 | 1975-01-03 | Republican | 2 | |||||||||||||
30574 | 30574 | Clem McSpadden M000603 | rep | OK | 1973-01-03 | 1975-01-03 | Democrat | 2 | |||||||||||||
30600 | 30600 | Ancher Nelsen N000028 | rep | MN | 1959-01-07 | 1961-01-03 | Republican | 2 | |||||||||||||
30601 | 30601 | Ancher Nelsen N000028 | rep | MN | 1961-01-03 | 1963-01-03 | Republican | 2 | |||||||||||||
30602 | 30602 | Ancher Nelsen N000028 | rep | MN | 1963-01-09 | 1965-01-03 | Republican | 2 | |||||||||||||
30603 | 30603 | Ancher Nelsen N000028 | rep | MN | 1965-01-04 | 1967-01-03 | Republican | 2 | |||||||||||||
30604 | 30604 | Ancher Nelsen N000028 | rep | MN | 1967-01-10 | 1969-01-03 | Republican | 2 | |||||||||||||
30605 | 30605 | Ancher Nelsen N000028 | rep | MN | 1969-01-03 | 1971-01-03 | Republican | 2 | |||||||||||||
30606 | 30606 | Ancher Nelsen N000028 | rep | MN | 1971-01-21 | 1973-01-03 | Republican | 2 | |||||||||||||
30607 | 30607 | Ancher Nelsen N000028 | rep | MN | 1973-01-03 | 1975-01-03 | Republican | 2 | |||||||||||||
30657 | 30657 | William Roy R000484 | rep | KS | 1971-01-21 | 1973-01-03 | Democrat | 2 | |||||||||||||
30658 | 30658 | William Roy R000484 | rep | KS | 1973-01-03 | 1975-01-03 | Democrat | 2 | |||||||||||||
30662 | 30662 | Charles Sandman S000045 | rep | NJ | 1967-01-10 | 1969-01-03 | Republican | 2 | |||||||||||||
30663 | 30663 | Charles Sandman S000045 | rep | NJ | 1969-01-03 | 1971-01-03 | Republican | 2 | |||||||||||||
30664 | 30664 | Charles Sandman S000045 | rep | NJ | 1971-01-21 | 1973-01-03 | Republican | 2 | |||||||||||||
30665 | 30665 | Charles Sandman S000045 | rep | NJ | 1973-01-03 | 1975-01-03 | Republican | 2 | |||||||||||||
30705 | 30705 | Robert Steele S000836 | rep | CT | 1969-01-03 | 1971-01-03 | Republican | 2 | |||||||||||||
30706 | 30706 | Robert Steele S000836 | rep | CT | 1971-01-21 | 1973-01-03 | Republican | 2 | |||||||||||||
30707 | 30707 | Robert Steele S000836 | rep | CT | 1973-01-03 | 1975-01-03 | Republican | 2 | |||||||||||||
30733 | 30733 | Robert Tiernan T000265 | rep | RI | 1967-01-10 | 1969-01-03 | Democrat | 2 | |||||||||||||
30734 | 30734 | Robert Tiernan T000265 | rep | RI | 1969-01-03 | 1971-01-03 | Democrat | 2 | |||||||||||||
30735 | 30735 | Robert Tiernan T000265 | rep | RI | 1971-01-21 | 1973-01-03 | Democrat | 2 | |||||||||||||
30736 | 30736 | Robert Tiernan T000265 | rep | RI | 1973-01-03 | 1975-01-03 | Democrat | 2 | |||||||||||||
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 | |||||||||||||
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 | |||||||||||||
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 | |||||||||||||
30911 | 30911 | Marvin Esch E000213 | rep | MI | 1967-01-10 | 1969-01-03 | Republican | 2 | |||||||||||||
30912 | 30912 | Marvin Esch E000213 | rep | MI | 1969-01-03 | 1971-01-03 | Republican | 2 | |||||||||||||
30913 | 30913 | Marvin Esch E000213 | rep | MI | 1971-01-21 | 1973-01-03 | Republican | 2 | |||||||||||||
30914 | 30914 | Marvin Esch E000213 | rep | MI | 1973-01-03 | 1975-01-03 | Republican | 2 | |||||||||||||
30915 | 30915 | Marvin Esch E000213 | rep | MI | 1975-01-14 | 1977-01-03 | Republican | 2 | |||||||||||||
31020 | 31020 | Allan Howe H000851 | rep | UT | 1975-01-14 | 1977-01-03 | Democrat | 2 | |||||||||||||
31171 | 31171 | John McCollister M000349 | rep | NE | 1971-01-21 | 1973-01-03 | Republican | 2 | |||||||||||||
31172 | 31172 | John McCollister M000349 | rep | NE | 1973-01-03 | 1975-01-03 | Republican | 2 | |||||||||||||
31173 | 31173 | John McCollister M000349 | rep | NE | 1975-01-14 | 1977-01-03 | Republican | 2 | |||||||||||||
31181 | 31181 | Wilbur Mills M000778 | rep | AR | 1939-01-03 | 1941-01-03 | Democrat | 2 | |||||||||||||
31182 | 31182 | Wilbur Mills M000778 | rep | AR | 1941-01-03 | 1943-01-03 | Democrat | 2 | |||||||||||||
31183 | 31183 | Wilbur Mills M000778 | rep | AR | 1943-01-06 | 1945-01-03 | Democrat | 2 | |||||||||||||
31184 | 31184 | Wilbur Mills M000778 | rep | AR | 1945-01-03 | 1947-01-03 | Democrat | 2 | |||||||||||||
31185 | 31185 | Wilbur Mills M000778 | rep | AR | 1947-01-03 | 1949-01-03 | Democrat | 2 | |||||||||||||
31186 | 31186 | Wilbur Mills M000778 | rep | AR | 1949-01-03 | 1951-01-03 | Democrat | 2 | |||||||||||||
31187 | 31187 | Wilbur Mills M000778 | rep | AR | 1951-01-03 | 1953-01-03 | Democrat | 2 | |||||||||||||
31188 | 31188 | Wilbur Mills M000778 | rep | AR | 1953-01-03 | 1955-01-03 | Democrat | 2 | |||||||||||||
31189 | 31189 | Wilbur Mills M000778 | rep | AR | 1955-01-05 | 1957-01-03 | Democrat | 2 | |||||||||||||
31190 | 31190 | Wilbur Mills M000778 | rep | AR | 1957-01-03 | 1959-01-03 | Democrat | 2 | |||||||||||||
31191 | 31191 | Wilbur Mills M000778 | rep | AR | 1959-01-07 | 1961-01-03 | Democrat | 2 | |||||||||||||
31192 | 31192 | Wilbur Mills M000778 | rep | AR | 1961-01-03 | 1963-01-03 | Democrat | 2 | |||||||||||||
31193 | 31193 | Wilbur Mills M000778 | rep | AR | 1963-01-09 | 1965-01-03 | Democrat | 2 | |||||||||||||
31194 | 31194 | Wilbur Mills M000778 | rep | AR | 1965-01-04 | 1967-01-03 | Democrat | 2 | |||||||||||||
31195 | 31195 | Wilbur Mills M000778 | rep | AR | 1967-01-10 | 1969-01-03 | Democrat | 2 | |||||||||||||
31196 | 31196 | Wilbur Mills M000778 | rep | AR | 1969-01-03 | 1971-01-03 | Democrat | 2 | |||||||||||||
31197 | 31197 | Wilbur Mills M000778 | rep | AR | 1971-01-21 | 1973-01-03 | Democrat | 2 | |||||||||||||
31198 | 31198 | Wilbur Mills M000778 | rep | AR | 1973-01-03 | 1975-01-03 | Democrat | 2 | |||||||||||||
31199 | 31199 | Wilbur Mills M000778 | rep | AR | 1975-01-14 | 1977-01-03 | Democrat | 2 | |||||||||||||
31370 | 31370 | James Symington S001134 | rep | MO | 1969-01-03 | 1971-01-03 | Democrat | 2 | |||||||||||||
31371 | 31371 | James Symington S001134 | rep | MO | 1971-01-21 | 1973-01-03 | Democrat | 2 | |||||||||||||
31372 | 31372 | James Symington S001134 | rep | MO | 1973-01-03 | 1975-01-03 | Democrat | 2 | |||||||||||||
31373 | 31373 | James Symington S001134 | rep | MO | 1975-01-14 | 1977-01-03 | Democrat | 2 | |||||||||||||
31423 | 31423 | Michael Blouin B000567 | rep | IA | 1975-01-14 | 1977-01-03 | Democrat | 2 | |||||||||||||
31424 | 31424 | Michael Blouin B000567 | rep | IA | 1977-01-04 | 1979-01-03 | Democrat | 2 | |||||||||||||
31603 | 31603 | Martha Keys K000162 | rep | KS | 1975-01-14 | 1977-01-03 | Democrat | 2 | |||||||||||||
31604 | 31604 | Martha Keys K000162 | rep | KS | 1977-01-04 | 1979-01-03 | Democrat | 2 | |||||||||||||
31659 | 31659 | Lloyd Meeds M000626 | rep | WA | 1965-01-04 | 1967-01-03 | Democrat | 2 | |||||||||||||
31660 | 31660 | Lloyd Meeds M000626 | rep | WA | 1967-01-10 | 1969-01-03 | Democrat | 2 | |||||||||||||
31661 | 31661 | Lloyd Meeds M000626 | rep | WA | 1969-01-03 | 1971-01-03 | Democrat | 2 | |||||||||||||
31662 | 31662 | Lloyd Meeds M000626 | rep | WA | 1971-01-21 | 1973-01-03 | Democrat | 2 | |||||||||||||
31663 | 31663 | Lloyd Meeds M000626 | rep | WA | 1973-01-03 | 1975-01-03 | Democrat | 2 | |||||||||||||
31664 | 31664 | Lloyd Meeds M000626 | rep | WA | 1975-01-14 | 1977-01-03 | Democrat | 2 | |||||||||||||
31665 | 31665 | Lloyd Meeds M000626 | rep | WA | 1977-01-04 | 1979-01-03 | Democrat | 2 | |||||||||||||
31697 | 31697 | Robert Nix N000113 | rep | PA | 1963-01-09 | 1965-01-03 | Democrat | 2 | |||||||||||||
31698 | 31698 | Robert Nix N000113 | rep | PA | 1965-01-04 | 1967-01-03 | Democrat | 2 | |||||||||||||
31699 | 31699 | Robert Nix N000113 | rep | PA | 1967-01-10 | 1969-01-03 | Democrat | 2 | |||||||||||||
31700 | 31700 | Robert Nix N000113 | rep | PA | 1969-01-03 | 1971-01-03 | Democrat | 2 | |||||||||||||
31701 | 31701 | Robert Nix N000113 | rep | PA | 1971-01-21 | 1973-01-03 | Democrat | 2 | |||||||||||||
31702 | 31702 | Robert Nix N000113 | rep | PA | 1973-01-03 | 1975-01-03 | Democrat | 2 | |||||||||||||
31703 | 31703 | Robert Nix N000113 | rep | PA | 1975-01-14 | 1977-01-03 | Democrat | 2 | |||||||||||||
31704 | 31704 | Robert Nix N000113 | rep | PA | 1977-01-04 | 1979-01-03 | Democrat | 2 | |||||||||||||
31750 | 31750 | Theodore Risenhoover R000268 | rep | OK | 1975-01-14 | 1977-01-03 | Democrat | 2 | |||||||||||||
31751 | 31751 | Theodore Risenhoover R000268 | rep | OK | 1977-01-04 | 1979-01-03 | Democrat | 2 |
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);