legislator_terms
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
40,641 rows where type = "rep" sorted by district
This data as json, copyable, CSV (advanced)
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
534 | 534 | Thomas Tillinghast T000273 | rep | RI | 1797-05-15 | 1799-03-03 | Federalist | -1 | |||||||||||||
535 | 535 | Thomas Tillinghast T000273 | rep | RI | 1801-12-07 | 1803-03-03 | Republican | -1 | |||||||||||||
536 | 536 | Uriah Tracy T000348 | rep | CT | 1793-12-02 | 1795-03-03 | Federalist | -1 | |||||||||||||
537 | 537 | Uriah Tracy T000348 | rep | CT | 1795-12-07 | 1796-10-13 | Federalist | -1 | |||||||||||||
540 | 540 | George Upham U000022 | rep | NH | 1801-12-07 | 1803-03-03 | Federalist | -1 | |||||||||||||
558 | 558 | Simeon Baldwin B000097 | rep | CT | 1803-10-17 | 1805-03-03 | Federalist | -1 | |||||||||||||
581 | 581 | Samuel Hammond H000133 | rep | GA | 1803-10-17 | 1805-03-03 | Republican | -1 | |||||||||||||
584 | 584 | Daniel Hiester H000570 | rep | PA | 1789-03-04 | 1791-03-03 | Republican | -1 | |||||||||||||
586 | 586 | Daniel Hiester H000570 | rep | PA | 1793-12-02 | 1795-03-03 | Republican | -1 | |||||||||||||
591 | 591 | Samuel Hunt H000976 | rep | NH | 1801-12-07 | 1803-03-03 | Federalist | -1 | |||||||||||||
592 | 592 | Samuel Hunt H000976 | rep | NH | 1803-10-17 | 1805-03-03 | Federalist | -1 | |||||||||||||
601 | 601 | James Mott M001039 | rep | NJ | 1801-12-07 | 1803-03-03 | Republican | -1 | |||||||||||||
602 | 602 | James Mott M001039 | rep | NJ | 1803-10-17 | 1805-03-03 | Republican | -1 | |||||||||||||
660 | 660 | Abraham Baldwin B000084 | rep | GA | 1797-05-15 | 1799-03-03 | Republican | -1 | |||||||||||||
665 | 665 | Silas Betton B000425 | rep | NH | 1803-10-17 | 1805-03-03 | Federalist | -1 | |||||||||||||
666 | 666 | Silas Betton B000425 | rep | NH | 1805-12-02 | 1807-03-03 | Federalist | -1 | |||||||||||||
671 | 671 | Joseph Bryan B000989 | rep | GA | 1803-10-17 | 1805-03-03 | Republican | -1 | |||||||||||||
672 | 672 | Joseph Bryan B000989 | rep | GA | 1805-12-02 | 1807-03-03 | Republican | -1 | |||||||||||||
681 | 681 | William Dickson D000333 | rep | TN | 1803-10-17 | 1805-03-03 | Republican | -1 | |||||||||||||
683 | 683 | Theodore Dwight D000582 | rep | CT | 1805-12-02 | 1807-03-03 | Federalist | -1 | |||||||||||||
684 | 684 | Peter Early E000014 | rep | GA | 1801-12-07 | 1803-03-03 | Republican | -1 | |||||||||||||
685 | 685 | Peter Early E000014 | rep | GA | 1803-10-17 | 1805-03-03 | Republican | -1 | |||||||||||||
686 | 686 | Peter Early E000014 | rep | GA | 1805-12-02 | 1807-03-03 | Republican | -1 | |||||||||||||
687 | 687 | Caleb Ellis E000130 | rep | NH | 1805-12-02 | 1807-03-03 | Federalist | -1 | |||||||||||||
688 | 688 | Ebenezer Elmer E000154 | rep | NJ | 1801-12-07 | 1803-03-03 | Republican | -1 | |||||||||||||
689 | 689 | Ebenezer Elmer E000154 | rep | NJ | 1803-10-17 | 1805-03-03 | Republican | -1 | |||||||||||||
690 | 690 | Ebenezer Elmer E000154 | rep | NJ | 1805-12-02 | 1807-03-03 | Republican | -1 | |||||||||||||
697 | 697 | Calvin Goddard G000248 | rep | CT | 1801-12-07 | 1803-03-03 | Federalist | -1 | |||||||||||||
698 | 698 | Calvin Goddard G000248 | rep | CT | 1803-10-17 | 1805-03-03 | Federalist | -1 | |||||||||||||
699 | 699 | Calvin Goddard G000248 | rep | CT | 1805-12-02 | 1807-03-03 | Federalist | -1 | |||||||||||||
700 | 700 | Roger Griswold G000488 | rep | CT | 1795-12-07 | 1797-03-03 | Federalist | -1 | |||||||||||||
701 | 701 | Roger Griswold G000488 | rep | CT | 1797-05-15 | 1799-03-03 | Federalist | -1 | |||||||||||||
702 | 702 | Roger Griswold G000488 | rep | CT | 1799-12-02 | 1801-03-03 | Federalist | -1 | |||||||||||||
703 | 703 | Roger Griswold G000488 | rep | CT | 1801-12-07 | 1803-03-03 | Federalist | -1 | |||||||||||||
704 | 704 | Roger Griswold G000488 | rep | CT | 1803-10-17 | 1805-03-03 | Federalist | -1 | |||||||||||||
705 | 705 | Roger Griswold G000488 | rep | CT | 1805-12-02 | 1807-03-03 | Federalist | -1 | |||||||||||||
712 | 712 | John Hanna H000161 | rep | PA | 1805-12-02 | 1807-03-03 | Republican | -1 | |||||||||||||
716 | 716 | David Hough H000811 | rep | NH | 1803-10-17 | 1805-03-03 | Federalist | -1 | |||||||||||||
717 | 717 | David Hough H000811 | rep | NH | 1805-12-02 | 1807-03-03 | Federalist | -1 | |||||||||||||
718 | 718 | Aaron Kitchell K000246 | rep | NJ | 1791-10-24 | 1793-03-03 | Democratic Republican | -1 | |||||||||||||
719 | 719 | Aaron Kitchell K000246 | rep | NJ | 1793-12-02 | 1795-03-03 | Democratic Republican | -1 | |||||||||||||
720 | 720 | Aaron Kitchell K000246 | rep | NJ | 1795-12-07 | 1797-03-03 | Federalist | -1 | |||||||||||||
727 | 727 | John Lucas L000492 | rep | PA | 1805-12-02 | 1807-03-03 | Republican | -1 | |||||||||||||
730 | 730 | Cowles Mead M000614 | rep | GA | 1805-12-02 | 1807-03-03 | Republican | -1 | |||||||||||||
731 | 731 | David Meriwether M000649 | rep | GA | 1801-12-07 | 1803-03-03 | Republican | -1 | |||||||||||||
732 | 732 | David Meriwether M000649 | rep | GA | 1803-10-17 | 1805-03-03 | Republican | -1 | |||||||||||||
733 | 733 | David Meriwether M000649 | rep | GA | 1805-12-02 | 1807-03-03 | Republican | -1 | |||||||||||||
748 | 748 | John Smith S000570 | rep | CT | 1799-12-02 | 1801-03-03 | Federalist | -1 | |||||||||||||
749 | 749 | John Smith S000570 | rep | CT | 1801-12-07 | 1803-03-03 | Federalist | -1 | |||||||||||||
750 | 750 | John Smith S000570 | rep | CT | 1803-10-17 | 1805-03-03 | Federalist | -1 | |||||||||||||
751 | 751 | John Smith S000570 | rep | CT | 1805-12-02 | 1807-03-03 | Federalist | -1 | |||||||||||||
753 | 753 | Thomas Spalding S000698 | rep | GA | 1805-12-02 | 1807-03-03 | Republican | -1 | |||||||||||||
755 | 755 | Joseph Stanton S000805 | rep | RI | 1801-12-07 | 1803-03-03 | Republican | -1 | |||||||||||||
756 | 756 | Joseph Stanton S000805 | rep | RI | 1803-10-17 | 1805-03-03 | Republican | -1 | |||||||||||||
757 | 757 | Joseph Stanton S000805 | rep | RI | 1805-12-02 | 1807-03-03 | Republican | -1 | |||||||||||||
765 | 765 | Samuel Tenney T000127 | rep | NH | 1799-12-02 | 1801-03-03 | Federalist | -1 | |||||||||||||
766 | 766 | Samuel Tenney T000127 | rep | NH | 1801-12-07 | 1803-03-03 | Federalist | -1 | |||||||||||||
767 | 767 | Samuel Tenney T000127 | rep | NH | 1803-10-17 | 1805-03-03 | Federalist | -1 | |||||||||||||
768 | 768 | Samuel Tenney T000127 | rep | NH | 1805-12-02 | 1807-03-03 | Federalist | -1 | |||||||||||||
803 | 803 | Barnabas Bidwell B000446 | rep | MA | 1807-10-26 | 1809-03-03 | Republican | -1 | |||||||||||||
814 | 814 | Peter Carleton C000148 | rep | NH | 1807-10-26 | 1809-03-03 | Republican | -1 | |||||||||||||
817 | 817 | Daniel Clark C000426 | rep | OL | 1805-12-02 | 1807-03-03 | -1 | ||||||||||||||
818 | 818 | Daniel Clark C000426 | rep | OL | 1807-10-26 | 1809-03-03 | -1 | ||||||||||||||
828 | 828 | Ezra Darby D000047 | rep | NJ | 1805-12-02 | 1807-03-03 | Republican | -1 | |||||||||||||
829 | 829 | Ezra Darby D000047 | rep | NJ | 1807-10-26 | 1809-03-03 | Republican | -1 | |||||||||||||
831 | 831 | Daniel Durell D000565 | rep | NH | 1807-10-26 | 1809-03-03 | Republican | -1 | |||||||||||||
838 | 838 | Francis Gardner G000052 | rep | NH | 1807-10-26 | 1809-03-03 | Republican | -1 | |||||||||||||
841 | 841 | Chauncey Goodrich G000293 | rep | CT | 1795-12-07 | 1797-03-03 | Federalist | -1 | |||||||||||||
842 | 842 | Chauncey Goodrich G000293 | rep | CT | 1797-05-15 | 1799-03-03 | Federalist | -1 | |||||||||||||
843 | 843 | Chauncey Goodrich G000293 | rep | CT | 1799-12-02 | 1801-03-03 | Federalist | -1 | |||||||||||||
846 | 846 | Andrew Gregg G000442 | rep | PA | 1793-12-02 | 1795-03-03 | Democratic Republican | -1 | |||||||||||||
865 | 865 | Nehemiah Knight K000286 | rep | RI | 1803-10-17 | 1805-03-03 | Republican | -1 | |||||||||||||
866 | 866 | Nehemiah Knight K000286 | rep | RI | 1805-12-02 | 1807-03-03 | Republican | -1 | |||||||||||||
867 | 867 | Nehemiah Knight K000286 | rep | RI | 1807-10-26 | 1809-03-03 | Republican | -1 | |||||||||||||
877 | 877 | Benjamin Parke P000052 | rep | IN | 1805-12-02 | 1807-03-03 | -1 | ||||||||||||||
878 | 878 | Benjamin Parke P000052 | rep | IN | 1807-10-26 | 1809-03-03 | -1 | ||||||||||||||
889 | 889 | James Sloan S000493 | rep | NJ | 1803-10-17 | 1805-03-03 | Republican | -1 | |||||||||||||
890 | 890 | James Sloan S000493 | rep | NJ | 1805-12-02 | 1807-03-03 | Republican | -1 | |||||||||||||
891 | 891 | James Sloan S000493 | rep | NJ | 1807-10-26 | 1809-03-03 | Republican | -1 | |||||||||||||
892 | 892 | Jedediah Smith S000562 | rep | NH | 1807-10-26 | 1809-03-03 | Republican | -1 | |||||||||||||
922 | 922 | Isaac Wilbour W000454 | rep | RI | 1807-10-26 | 1809-03-03 | Republican | -1 | |||||||||||||
944 | 944 | Daniel Blaisdell B000530 | rep | NH | 1809-05-22 | 1811-03-03 | Federalist | -1 | |||||||||||||
958 | 958 | John Chamberlain C000279 | rep | NH | 1809-05-22 | 1811-03-03 | Federalist | -1 | |||||||||||||
961 | 961 | Christopher Champlin C000289 | rep | RI | 1797-05-15 | 1799-03-03 | Federalist | -1 | |||||||||||||
962 | 962 | Christopher Champlin C000289 | rep | RI | 1799-12-02 | 1801-03-03 | Federalist | -1 | |||||||||||||
967 | 967 | James Cox C000834 | rep | NJ | 1809-05-22 | 1811-03-03 | Republican | -1 | |||||||||||||
969 | 969 | William Denning D000240 | rep | NY | 1809-05-22 | 1811-03-03 | -1 | ||||||||||||||
976 | 976 | Nathaniel Haven H000354 | rep | NH | 1809-05-22 | 1811-03-03 | Federalist | -1 | |||||||||||||
977 | 977 | William Helms H000464 | rep | NJ | 1801-12-07 | 1803-03-03 | Republican | -1 | |||||||||||||
978 | 978 | William Helms H000464 | rep | NJ | 1803-10-17 | 1805-03-03 | Republican | -1 | |||||||||||||
979 | 979 | William Helms H000464 | rep | NJ | 1805-12-02 | 1807-03-03 | Republican | -1 | |||||||||||||
980 | 980 | William Helms H000464 | rep | NJ | 1807-10-26 | 1809-03-03 | Republican | -1 | |||||||||||||
981 | 981 | William Helms H000464 | rep | NJ | 1809-05-22 | 1811-03-03 | Republican | -1 | |||||||||||||
983 | 983 | James Hillhouse H000618 | rep | CT | 1791-10-24 | 1793-03-03 | -1 | ||||||||||||||
984 | 984 | James Hillhouse H000618 | rep | CT | 1793-12-02 | 1795-03-03 | -1 | ||||||||||||||
985 | 985 | James Hillhouse H000618 | rep | CT | 1795-12-07 | 1796-05-18 | Federalist | -1 | |||||||||||||
1010 | 1010 | John Lambert L000036 | rep | NJ | 1805-12-02 | 1807-03-03 | Republican | -1 | |||||||||||||
1011 | 1011 | John Lambert L000036 | rep | NJ | 1807-10-26 | 1809-03-03 | Republican | -1 | |||||||||||||
1028 | 1028 | Francis Malbone M000076 | rep | RI | 1793-12-02 | 1795-03-03 | Federalist | -1 | |||||||||||||
1029 | 1029 | Francis Malbone M000076 | rep | RI | 1795-12-07 | 1797-03-03 | Federalist | -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);