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
- 1979-01-15 477
- 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
- 1977-01-04 456
- 1975-01-14 380
- 1973-01-03 287
- 1971-01-21 233
- 1969-01-03 202
- 1967-01-10 171
- 1965-01-04 146
- 1963-01-09 107
- …
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
31537 | 31537 | John Dent D000255 | rep | PA | 1977-01-04 | 1979-01-03 | Democrat | 21 | |||||||||||||
31538 | 31538 | Joshua Eilberg E000096 | rep | PA | 1967-01-10 | 1969-01-03 | Democrat | 4 | |||||||||||||
31539 | 31539 | Joshua Eilberg E000096 | rep | PA | 1969-01-03 | 1971-01-03 | Democrat | 4 | |||||||||||||
31540 | 31540 | Joshua Eilberg E000096 | rep | PA | 1971-01-21 | 1973-01-03 | Democrat | 4 | |||||||||||||
31541 | 31541 | Joshua Eilberg E000096 | rep | PA | 1973-01-03 | 1975-01-03 | Democrat | 4 | |||||||||||||
31542 | 31542 | Joshua Eilberg E000096 | rep | PA | 1975-01-14 | 1977-01-03 | Democrat | 4 | |||||||||||||
31543 | 31543 | Joshua Eilberg E000096 | rep | PA | 1977-01-04 | 1979-01-03 | Democrat | 4 | |||||||||||||
31544 | 31544 | Frank Evans E000240 | rep | CO | 1965-01-04 | 1967-01-03 | Democrat | 3 | |||||||||||||
31545 | 31545 | Frank Evans E000240 | rep | CO | 1967-01-10 | 1969-01-03 | Democrat | 3 | |||||||||||||
31546 | 31546 | Frank Evans E000240 | rep | CO | 1969-01-03 | 1971-01-03 | Democrat | 3 | |||||||||||||
31547 | 31547 | Frank Evans E000240 | rep | CO | 1971-01-21 | 1973-01-03 | Democrat | 3 | |||||||||||||
31548 | 31548 | Frank Evans E000240 | rep | CO | 1973-01-03 | 1975-01-03 | Democrat | 3 | |||||||||||||
31549 | 31549 | Frank Evans E000240 | rep | CO | 1975-01-14 | 1977-01-03 | Democrat | 3 | |||||||||||||
31550 | 31550 | Frank Evans E000240 | rep | CO | 1977-01-04 | 1979-01-03 | Democrat | 3 | |||||||||||||
31551 | 31551 | Walter Flowers F000218 | rep | AL | 1969-01-03 | 1971-01-03 | Democrat | 5 | |||||||||||||
31552 | 31552 | Walter Flowers F000218 | rep | AL | 1971-01-21 | 1973-01-03 | Democrat | 5 | |||||||||||||
31553 | 31553 | Walter Flowers F000218 | rep | AL | 1973-01-03 | 1975-01-03 | Democrat | 7 | |||||||||||||
31554 | 31554 | Walter Flowers F000218 | rep | AL | 1975-01-14 | 1977-01-03 | Democrat | 7 | |||||||||||||
31555 | 31555 | Walter Flowers F000218 | rep | AL | 1977-01-04 | 1979-01-03 | Democrat | 7 | |||||||||||||
31556 | 31556 | John Flynt F000229 | rep | GA | 1953-01-03 | 1955-01-03 | Democrat | 4 | |||||||||||||
31557 | 31557 | John Flynt F000229 | rep | GA | 1955-01-05 | 1957-01-03 | Democrat | 4 | |||||||||||||
31558 | 31558 | John Flynt F000229 | rep | GA | 1957-01-03 | 1959-01-03 | Democrat | 4 | |||||||||||||
31559 | 31559 | John Flynt F000229 | rep | GA | 1959-01-07 | 1961-01-03 | Democrat | 4 | |||||||||||||
31560 | 31560 | John Flynt F000229 | rep | GA | 1961-01-03 | 1963-01-03 | Democrat | 4 | |||||||||||||
31561 | 31561 | John Flynt F000229 | rep | GA | 1963-01-09 | 1965-01-03 | Democrat | 4 | |||||||||||||
31562 | 31562 | John Flynt F000229 | rep | GA | 1965-01-04 | 1967-01-03 | Democrat | 6 | |||||||||||||
31563 | 31563 | John Flynt F000229 | rep | GA | 1967-01-10 | 1969-01-03 | Democrat | 6 | |||||||||||||
31564 | 31564 | John Flynt F000229 | rep | GA | 1969-01-03 | 1971-01-03 | Democrat | 6 | |||||||||||||
31565 | 31565 | John Flynt F000229 | rep | GA | 1971-01-21 | 1973-01-03 | Democrat | 6 | |||||||||||||
31566 | 31566 | John Flynt F000229 | rep | GA | 1973-01-03 | 1975-01-03 | Democrat | 6 | |||||||||||||
31567 | 31567 | John Flynt F000229 | rep | GA | 1975-01-14 | 1977-01-03 | Democrat | 6 | |||||||||||||
31568 | 31568 | John Flynt F000229 | rep | GA | 1977-01-04 | 1979-01-03 | Democrat | 6 | |||||||||||||
31569 | 31569 | Donald Fraser F000350 | rep | MN | 1963-01-09 | 1965-01-03 | Democrat | 5 | |||||||||||||
31570 | 31570 | Donald Fraser F000350 | rep | MN | 1965-01-04 | 1967-01-03 | Democrat | 5 | |||||||||||||
31571 | 31571 | Donald Fraser F000350 | rep | MN | 1967-01-10 | 1969-01-03 | Democrat | 5 | |||||||||||||
31572 | 31572 | Donald Fraser F000350 | rep | MN | 1969-01-03 | 1971-01-03 | Democrat | 5 | |||||||||||||
31573 | 31573 | Donald Fraser F000350 | rep | MN | 1971-01-21 | 1973-01-03 | Democrat | 5 | |||||||||||||
31574 | 31574 | Donald Fraser F000350 | rep | MN | 1973-01-03 | 1975-01-03 | Democrat | 5 | |||||||||||||
31575 | 31575 | Donald Fraser F000350 | rep | MN | 1975-01-14 | 1977-01-03 | Democrat | 5 | |||||||||||||
31576 | 31576 | Donald Fraser F000350 | rep | MN | 1977-01-04 | 1979-01-03 | Democrat | 5 | |||||||||||||
31577 | 31577 | Louis Frey F000381 | rep | FL | 1969-01-03 | 1971-01-03 | Republican | 5 | |||||||||||||
31578 | 31578 | Louis Frey F000381 | rep | FL | 1971-01-21 | 1973-01-03 | Republican | 5 | |||||||||||||
31579 | 31579 | Louis Frey F000381 | rep | FL | 1973-01-03 | 1975-01-03 | Republican | 9 | |||||||||||||
31580 | 31580 | Louis Frey F000381 | rep | FL | 1975-01-14 | 1977-01-03 | Republican | 9 | |||||||||||||
31581 | 31581 | Louis Frey F000381 | rep | FL | 1977-01-04 | 1979-01-03 | Republican | 9 | |||||||||||||
31582 | 31582 | Robert Gammage G000036 | rep | TX | 1977-01-04 | 1979-01-03 | Democrat | 22 | |||||||||||||
31583 | 31583 | Mark Hannaford H000166 | rep | CA | 1975-01-14 | 1977-01-03 | Democrat | 34 | |||||||||||||
31584 | 31584 | Mark Hannaford H000166 | rep | CA | 1977-01-04 | 1979-01-03 | Democrat | 34 | |||||||||||||
31585 | 31585 | Michael Harrington H000230 | rep | MA | 1969-01-03 | 1971-01-03 | Democrat | 6 | |||||||||||||
31586 | 31586 | Michael Harrington H000230 | rep | MA | 1971-01-21 | 1973-01-03 | Democrat | 6 | |||||||||||||
31587 | 31587 | Michael Harrington H000230 | rep | MA | 1973-01-03 | 1975-01-03 | Democrat | 6 | |||||||||||||
31588 | 31588 | Michael Harrington H000230 | rep | MA | 1975-01-14 | 1977-01-03 | Democrat | 6 | |||||||||||||
31589 | 31589 | Michael Harrington H000230 | rep | MA | 1977-01-04 | 1979-01-03 | Democrat | 6 | |||||||||||||
31590 | 31590 | Samuel Hayakawa H000384 | sen | CA | 1977-01-04 | 1983-01-03 | 1 | Republican | |||||||||||||
31591 | 31591 | Kaneaster Hodges H000675 | sen | AR | 1977-12-10 | 1979-01-03 | 2 | Democrat | appointment | ||||||||||||
31592 | 31592 | Hubert Humphrey H000953 | sen | MN | 1949-01-03 | 1955-01-03 | 2 | Democrat | |||||||||||||
31593 | 31593 | Hubert Humphrey H000953 | sen | MN | 1955-01-05 | 1961-01-03 | 2 | Democrat | |||||||||||||
31594 | 31594 | Hubert Humphrey H000953 | sen | MN | 1961-01-03 | 1964-12-29 | 2 | Democrat | |||||||||||||
31595 | 31595 | Hubert Humphrey H000953 | sen | MN | 1971-01-21 | 1977-01-03 | 1 | Democrat | |||||||||||||
31596 | 31596 | Hubert Humphrey H000953 | sen | MN | 1977-01-04 | 1978-01-13 | 1 | Democrat | |||||||||||||
31597 | 31597 | Barbara Jordan J000266 | rep | TX | 1973-01-03 | 1975-01-03 | Democrat | 18 | |||||||||||||
31598 | 31598 | Barbara Jordan J000266 | rep | TX | 1975-01-14 | 1977-01-03 | Democrat | 18 | |||||||||||||
31599 | 31599 | Barbara Jordan J000266 | rep | TX | 1977-01-04 | 1979-01-03 | Democrat | 18 | |||||||||||||
31600 | 31600 | William Ketchum K000153 | rep | CA | 1973-01-03 | 1975-01-03 | Republican | 36 | |||||||||||||
31601 | 31601 | William Ketchum K000153 | rep | CA | 1975-01-14 | 1977-01-03 | Republican | 18 | |||||||||||||
31602 | 31602 | William Ketchum K000153 | rep | CA | 1977-01-04 | 1979-01-03 | Republican | 18 | |||||||||||||
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 | |||||||||||||
31605 | 31605 | Edward Koch K000302 | rep | NY | 1969-01-03 | 1971-01-03 | Democrat | 17 | |||||||||||||
31606 | 31606 | Edward Koch K000302 | rep | NY | 1971-01-21 | 1973-01-03 | Democrat | 17 | |||||||||||||
31607 | 31607 | Edward Koch K000302 | rep | NY | 1973-01-03 | 1975-01-03 | Democrat | 18 | |||||||||||||
31608 | 31608 | Edward Koch K000302 | rep | NY | 1975-01-14 | 1977-01-03 | Democrat | 18 | |||||||||||||
31609 | 31609 | Edward Koch K000302 | rep | NY | 1977-01-04 | 1979-01-03 | Democrat | 18 | |||||||||||||
31610 | 31610 | John Krebs K000325 | rep | CA | 1975-01-14 | 1977-01-03 | Democrat | 17 | |||||||||||||
31611 | 31611 | John Krebs K000325 | rep | CA | 1977-01-04 | 1979-01-03 | Democrat | 17 | |||||||||||||
31612 | 31612 | Joseph LeFante L000561 | rep | NJ | 1977-01-04 | 1979-01-03 | Democrat | 14 | |||||||||||||
31613 | 31613 | Robert Leggett L000221 | rep | CA | 1963-01-09 | 1965-01-03 | Democrat | 4 | |||||||||||||
31614 | 31614 | Robert Leggett L000221 | rep | CA | 1965-01-04 | 1967-01-03 | Democrat | 4 | |||||||||||||
31615 | 31615 | Robert Leggett L000221 | rep | CA | 1967-01-10 | 1969-01-03 | Democrat | 4 | |||||||||||||
31616 | 31616 | Robert Leggett L000221 | rep | CA | 1969-01-03 | 1971-01-03 | Democrat | 4 | |||||||||||||
31617 | 31617 | Robert Leggett L000221 | rep | CA | 1971-01-21 | 1973-01-03 | Democrat | 4 | |||||||||||||
31618 | 31618 | Robert Leggett L000221 | rep | CA | 1973-01-03 | 1975-01-03 | Democrat | 4 | |||||||||||||
31619 | 31619 | Robert Leggett L000221 | rep | CA | 1975-01-14 | 1977-01-03 | Democrat | 4 | |||||||||||||
31620 | 31620 | Robert Leggett L000221 | rep | CA | 1977-01-04 | 1979-01-03 | Democrat | 4 | |||||||||||||
31621 | 31621 | George Mahon M000065 | rep | TX | 1935-01-03 | 1937-01-03 | Democrat | 19 | |||||||||||||
31622 | 31622 | George Mahon M000065 | rep | TX | 1937-01-05 | 1939-01-03 | Democrat | 19 | |||||||||||||
31623 | 31623 | George Mahon M000065 | rep | TX | 1939-01-03 | 1941-01-03 | Democrat | 19 | |||||||||||||
31624 | 31624 | George Mahon M000065 | rep | TX | 1941-01-03 | 1943-01-03 | Democrat | 19 | |||||||||||||
31625 | 31625 | George Mahon M000065 | rep | TX | 1943-01-06 | 1945-01-03 | Democrat | 19 | |||||||||||||
31626 | 31626 | George Mahon M000065 | rep | TX | 1945-01-03 | 1947-01-03 | Democrat | 19 | |||||||||||||
31627 | 31627 | George Mahon M000065 | rep | TX | 1947-01-03 | 1949-01-03 | Democrat | 19 | |||||||||||||
31628 | 31628 | George Mahon M000065 | rep | TX | 1949-01-03 | 1951-01-03 | Democrat | 19 | |||||||||||||
31629 | 31629 | George Mahon M000065 | rep | TX | 1951-01-03 | 1953-01-03 | Democrat | 19 | |||||||||||||
31630 | 31630 | George Mahon M000065 | rep | TX | 1953-01-03 | 1955-01-03 | Democrat | 19 | |||||||||||||
31631 | 31631 | George Mahon M000065 | rep | TX | 1955-01-05 | 1957-01-03 | Democrat | 19 | |||||||||||||
31632 | 31632 | George Mahon M000065 | rep | TX | 1957-01-03 | 1959-01-03 | Democrat | 19 | |||||||||||||
31633 | 31633 | George Mahon M000065 | rep | TX | 1959-01-07 | 1961-01-03 | Democrat | 19 | |||||||||||||
31634 | 31634 | George Mahon M000065 | rep | TX | 1961-01-03 | 1963-01-03 | Democrat | 19 | |||||||||||||
31635 | 31635 | George Mahon M000065 | rep | TX | 1963-01-09 | 1965-01-03 | Democrat | 19 | |||||||||||||
31636 | 31636 | George Mahon M000065 | rep | TX | 1965-01-04 | 1967-01-03 | Democrat | 19 |
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);