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 ✖
- 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
- 1991-01-03 432
- 1989-01-03 381
- 1987-01-06 346
- 1985-01-03 310
- 1983-01-03 273
- 1981-01-05 211
- 1979-01-15 178
- 1977-01-04 141
- 1975-01-14 114
- 1973-01-03 78
- 1971-01-21 53
- 1969-01-03 46
- 1967-01-10 39
- 1965-01-04 32
- 1963-01-09 19
- …
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
34532 | 34532 | Charles Hatcher H000340 | rep | GA | 1991-01-03 | 1993-01-03 | Democrat | 2 | |||||||||||||
34533 | 34533 | Mark Hatfield H000343 | sen | OR | 1967-01-10 | 1973-01-03 | 2 | Republican | |||||||||||||
34534 | 34534 | Mark Hatfield H000343 | sen | OR | 1973-01-03 | 1979-01-03 | 2 | Republican | |||||||||||||
34535 | 34535 | Mark Hatfield H000343 | sen | OR | 1979-01-15 | 1985-01-03 | 2 | Republican | |||||||||||||
34536 | 34536 | Mark Hatfield H000343 | sen | OR | 1985-01-03 | 1991-01-03 | 2 | Republican | |||||||||||||
34537 | 34537 | Mark Hatfield H000343 | sen | OR | 1991-01-03 | 1997-01-03 | 2 | Republican | |||||||||||||
34538 | 34538 | Charles Hayes H000388 | rep | IL | 1983-01-03 | 1985-01-03 | Democrat | 1 | |||||||||||||
34539 | 34539 | Charles Hayes H000388 | rep | IL | 1985-01-03 | 1987-01-03 | Democrat | 1 | |||||||||||||
34540 | 34540 | Charles Hayes H000388 | rep | IL | 1987-01-06 | 1989-01-03 | Democrat | 1 | |||||||||||||
34541 | 34541 | Charles Hayes H000388 | rep | IL | 1989-01-03 | 1991-01-03 | Democrat | 1 | |||||||||||||
34542 | 34542 | Charles Hayes H000388 | rep | IL | 1991-01-03 | 1993-01-03 | Democrat | 1 | |||||||||||||
34543 | 34543 | Howell Heflin H000445 | sen | AL | 1979-01-15 | 1985-01-03 | 2 | Democrat | |||||||||||||
34544 | 34544 | Howell Heflin H000445 | sen | AL | 1985-01-03 | 1991-01-03 | 2 | Democrat | |||||||||||||
34545 | 34545 | Howell Heflin H000445 | sen | AL | 1991-01-03 | 1997-01-03 | 2 | Democrat | |||||||||||||
34546 | 34546 | Dennis Hertel H000547 | rep | MI | 1981-01-05 | 1983-01-03 | Democrat | 14 | |||||||||||||
34547 | 34547 | Dennis Hertel H000547 | rep | MI | 1983-01-03 | 1985-01-03 | Democrat | 14 | |||||||||||||
34548 | 34548 | Dennis Hertel H000547 | rep | MI | 1985-01-03 | 1987-01-03 | Democrat | 14 | |||||||||||||
34549 | 34549 | Dennis Hertel H000547 | rep | MI | 1987-01-06 | 1989-01-03 | Democrat | 14 | |||||||||||||
34550 | 34550 | Dennis Hertel H000547 | rep | MI | 1989-01-03 | 1991-01-03 | Democrat | 14 | |||||||||||||
34551 | 34551 | Dennis Hertel H000547 | rep | MI | 1991-01-03 | 1993-01-03 | Democrat | 14 | |||||||||||||
34552 | 34552 | Clyde Holloway H000729 | rep | LA | 1987-01-06 | 1989-01-03 | Republican | 8 | |||||||||||||
34553 | 34553 | Clyde Holloway H000729 | rep | LA | 1989-01-03 | 1991-01-03 | Republican | 8 | |||||||||||||
34554 | 34554 | Clyde Holloway H000729 | rep | LA | 1991-01-03 | 1993-01-03 | Republican | 8 | |||||||||||||
34555 | 34555 | Larry Hopkins H000776 | rep | KY | 1979-01-15 | 1981-01-03 | Republican | 6 | |||||||||||||
34556 | 34556 | Larry Hopkins H000776 | rep | KY | 1981-01-05 | 1983-01-03 | Republican | 6 | |||||||||||||
34557 | 34557 | Larry Hopkins H000776 | rep | KY | 1983-01-03 | 1985-01-03 | Republican | 6 | |||||||||||||
34558 | 34558 | Larry Hopkins H000776 | rep | KY | 1985-01-03 | 1987-01-03 | Republican | 6 | |||||||||||||
34559 | 34559 | Larry Hopkins H000776 | rep | KY | 1987-01-06 | 1989-01-03 | Republican | 6 | |||||||||||||
34560 | 34560 | Larry Hopkins H000776 | rep | KY | 1989-01-03 | 1991-01-03 | Republican | 6 | |||||||||||||
34561 | 34561 | Larry Hopkins H000776 | rep | KY | 1991-01-03 | 1993-01-03 | Republican | 6 | |||||||||||||
34562 | 34562 | Joan Horn H000788 | rep | MO | 1991-01-03 | 1993-01-03 | Democrat | 2 | |||||||||||||
34563 | 34563 | Frank Horton H000797 | rep | NY | 1963-01-09 | 1965-01-03 | Republican | 36 | |||||||||||||
34564 | 34564 | Frank Horton H000797 | rep | NY | 1965-01-04 | 1967-01-03 | Republican | 36 | |||||||||||||
34565 | 34565 | Frank Horton H000797 | rep | NY | 1967-01-10 | 1969-01-03 | Republican | 36 | |||||||||||||
34566 | 34566 | Frank Horton H000797 | rep | NY | 1969-01-03 | 1971-01-03 | Republican | 36 | |||||||||||||
34567 | 34567 | Frank Horton H000797 | rep | NY | 1971-01-21 | 1973-01-03 | Republican | 36 | |||||||||||||
34568 | 34568 | Frank Horton H000797 | rep | NY | 1973-01-03 | 1975-01-03 | Republican | 34 | |||||||||||||
34569 | 34569 | Frank Horton H000797 | rep | NY | 1975-01-14 | 1977-01-03 | Republican | 34 | |||||||||||||
34570 | 34570 | Frank Horton H000797 | rep | NY | 1977-01-04 | 1979-01-03 | Republican | 34 | |||||||||||||
34571 | 34571 | Frank Horton H000797 | rep | NY | 1979-01-15 | 1981-01-03 | Republican | 34 | |||||||||||||
34572 | 34572 | Frank Horton H000797 | rep | NY | 1981-01-05 | 1983-01-03 | Republican | 34 | |||||||||||||
34573 | 34573 | Frank Horton H000797 | rep | NY | 1983-01-03 | 1985-01-03 | Republican | 29 | |||||||||||||
34574 | 34574 | Frank Horton H000797 | rep | NY | 1985-01-03 | 1987-01-03 | Republican | 29 | |||||||||||||
34575 | 34575 | Frank Horton H000797 | rep | NY | 1987-01-06 | 1989-01-03 | Republican | 29 | |||||||||||||
34576 | 34576 | Frank Horton H000797 | rep | NY | 1989-01-03 | 1991-01-03 | Republican | 29 | |||||||||||||
34577 | 34577 | Frank Horton H000797 | rep | NY | 1991-01-03 | 1993-01-03 | Republican | 29 | |||||||||||||
34578 | 34578 | Carroll Hubbard H000878 | rep | KY | 1975-01-14 | 1977-01-03 | Democrat | 1 | |||||||||||||
34579 | 34579 | Carroll Hubbard H000878 | rep | KY | 1977-01-04 | 1979-01-03 | Democrat | 1 | |||||||||||||
34580 | 34580 | Carroll Hubbard H000878 | rep | KY | 1979-01-15 | 1981-01-03 | Democrat | 1 | |||||||||||||
34581 | 34581 | Carroll Hubbard H000878 | rep | KY | 1981-01-05 | 1983-01-03 | Democrat | 1 | |||||||||||||
34582 | 34582 | Carroll Hubbard H000878 | rep | KY | 1983-01-03 | 1985-01-03 | Democrat | 1 | |||||||||||||
34583 | 34583 | Carroll Hubbard H000878 | rep | KY | 1985-01-03 | 1987-01-03 | Democrat | 1 | |||||||||||||
34584 | 34584 | Carroll Hubbard H000878 | rep | KY | 1987-01-06 | 1989-01-03 | Democrat | 1 | |||||||||||||
34585 | 34585 | Carroll Hubbard H000878 | rep | KY | 1989-01-03 | 1991-01-03 | Democrat | 1 | |||||||||||||
34586 | 34586 | Carroll Hubbard H000878 | rep | KY | 1991-01-03 | 1993-01-03 | Democrat | 1 | |||||||||||||
34587 | 34587 | Thomas Huckaby H000901 | rep | LA | 1977-01-04 | 1979-01-03 | Democrat | 5 | |||||||||||||
34588 | 34588 | Thomas Huckaby H000901 | rep | LA | 1979-01-15 | 1981-01-03 | Democrat | 5 | |||||||||||||
34589 | 34589 | Thomas Huckaby H000901 | rep | LA | 1981-01-05 | 1983-01-03 | Democrat | 5 | |||||||||||||
34590 | 34590 | Thomas Huckaby H000901 | rep | LA | 1983-01-03 | 1985-01-03 | Democrat | 5 | |||||||||||||
34591 | 34591 | Thomas Huckaby H000901 | rep | LA | 1985-01-03 | 1987-01-03 | Democrat | 5 | |||||||||||||
34592 | 34592 | Thomas Huckaby H000901 | rep | LA | 1987-01-06 | 1989-01-03 | Democrat | 5 | |||||||||||||
34593 | 34593 | Thomas Huckaby H000901 | rep | LA | 1989-01-03 | 1991-01-03 | Democrat | 5 | |||||||||||||
34594 | 34594 | Thomas Huckaby H000901 | rep | LA | 1991-01-03 | 1993-01-03 | Democrat | 5 | |||||||||||||
34595 | 34595 | Andrew Ireland I000029 | rep | FL | 1977-01-04 | 1979-01-03 | Democrat | 8 | |||||||||||||
34596 | 34596 | Andrew Ireland I000029 | rep | FL | 1979-01-15 | 1981-01-03 | Democrat | 8 | |||||||||||||
34597 | 34597 | Andrew Ireland I000029 | rep | FL | 1981-01-05 | 1983-01-03 | Democrat | 8 | |||||||||||||
34598 | 34598 | Andrew Ireland I000029 | rep | FL | 1983-01-03 | 1985-01-03 | Democrat | 10 | |||||||||||||
34599 | 34599 | Andrew Ireland I000029 | rep | FL | 1985-01-03 | 1987-01-03 | Republican | 10 | |||||||||||||
34600 | 34600 | Andrew Ireland I000029 | rep | FL | 1987-01-06 | 1989-01-03 | Republican | 10 | |||||||||||||
34601 | 34601 | Andrew Ireland I000029 | rep | FL | 1989-01-03 | 1991-01-03 | Republican | 10 | |||||||||||||
34602 | 34602 | Andrew Ireland I000029 | rep | FL | 1991-01-03 | 1993-01-03 | Republican | 10 | |||||||||||||
34603 | 34603 | Craig James J000047 | rep | FL | 1989-01-03 | 1991-01-03 | Republican | 4 | |||||||||||||
34604 | 34604 | Craig James J000047 | rep | FL | 1991-01-03 | 1993-01-03 | Republican | 4 | |||||||||||||
34605 | 34605 | Edgar Jenkins J000083 | rep | GA | 1977-01-04 | 1979-01-03 | Democrat | 9 | |||||||||||||
34606 | 34606 | Edgar Jenkins J000083 | rep | GA | 1979-01-15 | 1981-01-03 | Democrat | 9 | |||||||||||||
34607 | 34607 | Edgar Jenkins J000083 | rep | GA | 1981-01-05 | 1983-01-03 | Democrat | 9 | |||||||||||||
34608 | 34608 | Edgar Jenkins J000083 | rep | GA | 1983-01-03 | 1985-01-03 | Democrat | 9 | |||||||||||||
34609 | 34609 | Edgar Jenkins J000083 | rep | GA | 1985-01-03 | 1987-01-03 | Democrat | 9 | |||||||||||||
34610 | 34610 | Edgar Jenkins J000083 | rep | GA | 1987-01-06 | 1989-01-03 | Democrat | 9 | |||||||||||||
34611 | 34611 | Edgar Jenkins J000083 | rep | GA | 1989-01-03 | 1991-01-03 | Democrat | 9 | |||||||||||||
34612 | 34612 | Edgar Jenkins J000083 | rep | GA | 1991-01-03 | 1993-01-03 | Democrat | 9 | |||||||||||||
34613 | 34613 | John Johnston J000189 | sen | LA | 1972-11-14 | 1973-01-03 | 2 | Democrat | |||||||||||||
34614 | 34614 | John Johnston J000189 | sen | LA | 1973-01-03 | 1979-01-03 | 2 | Democrat | |||||||||||||
34615 | 34615 | John Johnston J000189 | sen | LA | 1979-01-15 | 1985-01-03 | 2 | Democrat | |||||||||||||
34616 | 34616 | John Johnston J000189 | sen | LA | 1985-01-03 | 1991-01-03 | 2 | Democrat | |||||||||||||
34617 | 34617 | John Johnston J000189 | sen | LA | 1991-01-03 | 1997-01-03 | 2 | Democrat | |||||||||||||
34618 | 34618 | Ben Jones J000211 | rep | GA | 1989-01-03 | 1991-01-03 | Democrat | 4 | |||||||||||||
34619 | 34619 | Ben Jones J000211 | rep | GA | 1991-01-03 | 1993-01-03 | Democrat | 4 | |||||||||||||
34620 | 34620 | Walter Jones J000256 | rep | NC | 1965-01-04 | 1967-01-03 | Democrat | 1 | |||||||||||||
34621 | 34621 | Walter Jones J000256 | rep | NC | 1967-01-10 | 1969-01-03 | Democrat | 1 | |||||||||||||
34622 | 34622 | Walter Jones J000256 | rep | NC | 1969-01-03 | 1971-01-03 | Democrat | 1 | |||||||||||||
34623 | 34623 | Walter Jones J000256 | rep | NC | 1971-01-21 | 1973-01-03 | Democrat | 1 | |||||||||||||
34624 | 34624 | Walter Jones J000256 | rep | NC | 1973-01-03 | 1975-01-03 | Democrat | 1 | |||||||||||||
34625 | 34625 | Walter Jones J000256 | rep | NC | 1975-01-14 | 1977-01-03 | Democrat | 1 | |||||||||||||
34626 | 34626 | Walter Jones J000256 | rep | NC | 1977-01-04 | 1979-01-03 | Democrat | 1 | |||||||||||||
34627 | 34627 | Walter Jones J000256 | rep | NC | 1979-01-15 | 1981-01-03 | Democrat | 1 | |||||||||||||
34628 | 34628 | Walter Jones J000256 | rep | NC | 1981-01-05 | 1983-01-03 | Democrat | 1 | |||||||||||||
34629 | 34629 | Walter Jones J000256 | rep | NC | 1983-01-03 | 1985-01-03 | Democrat | 1 | |||||||||||||
34630 | 34630 | Walter Jones J000256 | rep | NC | 1985-01-03 | 1987-01-03 | Democrat | 1 | |||||||||||||
34631 | 34631 | Walter Jones J000256 | rep | NC | 1987-01-06 | 1989-01-03 | Democrat | 1 |
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);