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 ---------+-------------------------+--------+---------+------------+------------+---------+---------------------+------------+-------+----------------------+-------+----------+-----------+---------+-------+----------------+----------+--------------+-----------+------------ 1 | Richard Bassett | sen | DE | 1789-03-04 | 1793-03-03 | 2 | Anti-Administration | | | | | | | | | | | | | 2 | Theodorick Bland | rep | VA | 1789-03-04 | 1791-03-03 | | | 9 | | | | | | | | | | | | 3 | Aedanus Burke | rep | SC | 1789-03-04 | 1791-03-03 | | | 2 | | | | | | | | | | | | 4 | Daniel Carroll | rep | MD | 1789-03-04 | 1791-03-03 | | | 6 | | | | | | | | | | | | 5 | George Clymer | rep | PA | 1789-03-04 | 1791-03-03 | | | -1 | | | | | | | | | | | | 6 | Benjamin Contee | rep | MD | 1789-03-04 | 1791-03-03 | | | 3 | | | | | | | | | | | | 7 | Tristram Dalton | sen | MA | 1789-03-04 | 1791-03-03 | 1 | Pro-Administration | | | | | | | | | | | | | 8 | Jonathan Elmer | sen | NJ | 1789-03-04 | 1791-03-03 | 1 | Pro-Administration | | | | | | | | | | | | | 9 | William Few | sen | GA | 1789-03-04 | 1793-03-03 | 2 | Anti-Administration | | | | | | | | | | | | | 10 | William Floyd | rep | NY | 1789-03-04 | 1791-03-03 | | | 1 | | | | | | | | | | | | 11 | George Gale | rep | MD | 1789-03-04 | 1791-03-03 | | | 5 | | | | | | | | | | | | 12 | William Grayson | sen | VA | 1789-03-04 | 1791-03-03 | 1 | Anti-Administration | | | | | | | | | | | | | 13 | Jonathan Grout | rep | MA | 1789-03-04 | 1791-03-03 | | | 8 | | | | | | | | | | | | 14 | Benjamin Hawkins | sen | NC | 1789-03-04 | 1795-03-03 | 3 | Pro-Administration | | | | | | | | | | | | | 15 | Benjamin Huntington | rep | CT | 1789-03-04 | 1791-03-03 | | | -1 | | | | | | | | | | | | 16 | Ralph Izard | sen | SC | 1789-03-04 | 1795-03-03 | 3 | Pro-Administration | | | | | | | | | | | | | 17 | William Johnson | sen | CT | 1789-03-04 | 1791-12-31 | 3 | Pro-Administration | | | | | | | | | | | | | 18 | Samuel Johnston | sen | NC | 1789-03-04 | 1793-03-03 | 2 | Pro-Administration | | | | | | | | | | | | | 19 | Richard Lee | sen | VA | 1789-03-04 | 1793-03-03 | 2 | Anti-Administration | | | | | | | | | | | | | 20 | William Maclay | sen | PA | 1789-03-04 | 1791-03-03 | 1 | Anti-Administration | | | | | | | | | | | | | 21 | George Mathews | rep | GA | 1789-03-04 | 1791-03-03 | | | 3 | | | | | | | | | | | | 22 | Robert Morris | sen | PA | 1789-03-04 | 1795-03-03 | 3 | Pro-Administration | | | | | | | | | | | | | 23 | George Partridge | rep | MA | 1789-03-04 | 1791-03-03 | | | 5 | | | | | | | | | | | | 24 | William Paterson | sen | NJ | 1789-03-04 | 1791-03-03 | 2 | Pro-Administration | | | | | | | | | | | | | 25 | William Smith | rep | MD | 1789-03-04 | 1791-03-03 | | | 4 | | | | | | | | | | | | 26 | Michael Stone | rep | MD | 1789-03-04 | 1791-03-03 | | | 1 | | | | | | | | | | | | 27 | Jeremiah Van Rensselaer | rep | NY | 1789-03-04 | 1791-03-03 | | | 6 | | | | | | | | | | | | 28 | Henry Wynkoop | rep | PA | 1789-03-04 | 1791-03-03 | | | -1 | | | | | | | | | | | | 29 | Philemon Dickinson | sen | NJ | 1790-01-01 | 1793-03-03 | 2 | Pro-Administration | | | | | | | | | | | | | 30 | John Walker | sen | VA | 1790-01-01 | 1791-03-03 | 1 | Pro-Administration | | | | | | | | | | | | | 31 | John Ashe | rep | NC | 1789-03-04 | 1791-03-03 | | | 1 | | | | | | | | | | | | 32 | John Ashe | rep | NC | 1791-10-24 | 1793-03-03 | | | 3 | | | | | | | | | | | | 33 | Robert Barnwell | rep | SC | 1791-10-24 | 1793-03-03 | | | 2 | | | | | | | | | | | | 34 | Aaron Burr | sen | NY | 1791-10-24 | 1797-03-03 | 1 | Republican | | | | | | | | | | | | | 35 | George Cabot | sen | MA | 1791-10-24 | 1797-03-03 | 1 | Federalist | | | | | | | | | | | | | 36 | Charles Carroll | sen | MD | 1789-03-04 | 1791-03-03 | 1 | Pro-Administration | | | | | | | | | | | | | 37 | Charles Carroll | sen | MD | 1791-10-24 | 1793-03-03 | 1 | | | | | | | | | | | | | | 38 | Oliver Ellsworth | sen | CT | 1789-03-04 | 1791-03-03 | 1 | Pro-Administration | | | | | | | | | | | | | 39 | Oliver Ellsworth | sen | CT | 1791-10-24 | 1797-03-03 | 1 | Federalist | | | | | | | | | | | | | 40 | Elbridge Gerry | rep | MA | 1789-03-04 | 1791-03-03 | | | 3 | | | | | | | | | | | | 41 | Elbridge Gerry | rep | MA | 1791-10-24 | 1793-03-03 | | | 3 | | | | | | | | | | | | 42 | Daniel Huger | rep | SC | 1789-03-04 | 1791-03-03 | | | 3 | | | | | | | | | | | | 43 | Daniel Huger | rep | SC | 1791-10-24 | 1793-03-03 | | | 3 | | | | | | | | | | | | 44 | Israel Jacobs | rep | PA | 1791-10-24 | 1793-03-03 | | | 3 | | | | | | | | | | | | 45 | Philip Key | rep | MD | 1791-10-24 | 1793-03-03 | | | 1 | | | | | | | | | | | | 46 | George Read | sen | DE | 1789-03-04 | 1791-03-03 | 1 | Pro-Administration | | | | | | | | | | | | | 47 | George Read | sen | DE | 1791-10-24 | 1793-12-31 | 1 | | | | | | | | | | | | | | 48 | Moses Robinson | sen | VT | 1791-10-24 | 1796-10-15 | 1 | Anti-Administration | | | | | | | | | | | | | 49 | Cornelius Schoonmaker | rep | NY | 1791-10-24 | 1793-03-03 | | | 4 | | | | | | | | | | | | 50 | Joshua Seney | rep | MD | 1789-03-04 | 1791-03-03 | | | 2 | | | | | | | | | | | | 51 | Joshua Seney | rep | MD | 1791-10-24 | 1793-03-03 | | | 2 | | | | | | | | | | | | 52 | Upton Sheredine | rep | MD | 1791-10-24 | 1793-03-03 | | | 6 | | | | | | | | | | | | 53 | Roger Sherman | rep | CT | 1789-03-04 | 1791-03-03 | | Pro-Administration | -1 | | | | | | | | | | | | 54 | Roger Sherman | sen | CT | 1791-10-24 | 1793-12-31 | 3 | Pro-Administration | | | | | | | | | | | | | 55 | Peter Silvester | rep | NY | 1789-03-04 | 1791-03-03 | | | 5 | | | | | | | | | | | | 56 | Peter Silvester | rep | NY | 1791-10-24 | 1793-03-03 | | | 5 | | | | | | | | | | | | 57 | John Steele | rep | NC | 1789-03-04 | 1791-03-03 | | | 4 | | | | | | | | | | | | 58 | John Steele | rep | NC | 1791-10-24 | 1793-03-03 | | | 1 | | | | | | | | | | | | 59 | Samuel Sterett | rep | MD | 1791-10-24 | 1793-03-03 | | | 4 | | | | | | | | | | | | 60 | Jonathan Sturges | rep | CT | 1789-03-04 | 1791-03-03 | | | -1 | | | | | | | | | | | | 61 | Jonathan Sturges | rep | CT | 1791-10-24 | 1793-03-03 | | | -1 | | | | | | | | | | | | 62 | Thomas Tucker | rep | SC | 1789-03-04 | 1791-03-03 | | | 5 | | | | | | | | | | | | 63 | Thomas Tucker | rep | SC | 1791-10-24 | 1793-03-03 | | | 5 | | | | | | | | | | | | 64 | Anthony Wayne | rep | GA | 1791-10-24 | 1793-03-03 | | | 1 | | | | | | | | | | | | 65 | Alexander White | rep | VA | 1789-03-04 | 1791-03-03 | | | 1 | | | | | | | | | | | | 66 | Alexander White | rep | VA | 1791-10-24 | 1793-03-03 | | | 1 | | | | | | | | | | | | 67 | Hugh Williamson | rep | NC | 1789-03-04 | 1791-03-03 | | Federalist | 2 | | | | | | | | | | | | 68 | Hugh Williamson | rep | NC | 1791-10-24 | 1793-03-03 | | Federalist | 4 | | | | | | | | | | | | 69 | Francis Willis | rep | GA | 1791-10-24 | 1793-03-03 | | | 3 | | | | | | | | | | | | 70 | John Edwards | sen | KY | 1792-01-01 | 1795-03-03 | 3 | Anti-Administration | | | | | | | | | | | | | 71 | Richard Potts | sen | MD | 1793-01-10 | 1796-10-14 | 1 | Federalist | | | | | | | | | | | | | 72 | James Armstrong | rep | PA | 1793-12-02 | 1795-03-03 | | | -1 | | | | | | | | | | | | 73 | John Beatty | rep | NJ | 1793-12-02 | 1795-03-03 | | | -1 | | | | | | | | | | | | 74 | Elias Boudinot | rep | NJ | 1789-03-04 | 1791-03-03 | | | -1 | | | | | | | | | | | | 75 | Elias Boudinot | rep | NJ | 1791-10-24 | 1793-03-03 | | | -1 | | | | | | | | | | | | 76 | Elias Boudinot | rep | NJ | 1793-12-02 | 1795-03-03 | | | -1 | | | | | | | | | | | | 77 | Shearjashub Bourne | rep | MA | 1791-10-24 | 1793-03-03 | | | 5 | | | | | | | | | | | | 78 | Shearjashub Bourne | rep | MA | 1793-12-02 | 1795-03-03 | | | 3 | | | | | | | | | | | | 79 | William Bradford | sen | RI | 1793-12-02 | 1797-12-31 | 2 | Federalist | | | | | | | | | | | | | 80 | Lambert Cadwalader | rep | NJ | 1789-03-04 | 1791-03-03 | | | -1 | | | | | | | | | | | | 81 | Lambert Cadwalader | rep | NJ | 1793-12-02 | 1795-03-03 | | | -1 | | | | | | | | | | | | 82 | Thomas Carnes | rep | GA | 1793-12-02 | 1795-03-03 | | | 0 | | | | | | | | | | | | 83 | Abraham Clark | rep | NJ | 1791-10-24 | 1793-03-03 | | | -1 | | | | | | | | | | | | 84 | Abraham Clark | rep | NJ | 1793-12-02 | 1795-03-03 | | | -1 | | | | | | | | | | | | 85 | David Cobb | rep | MA | 1793-12-02 | 1795-03-03 | | | -1 | | | | | | | | | | | | 86 | Peleg Coffin | rep | MA | 1793-12-02 | 1795-03-03 | | | 3 | | | | | | | | | | | | 87 | William Dawson | rep | NC | 1793-12-02 | 1795-03-03 | | Anti-Administration | 8 | | | | | | | | | | | | 88 | Benjamin Edwards | rep | MD | 1793-12-02 | 1795-03-03 | | | 3 | | | | | | | | | | | | 89 | Thomas Fitzsimons | rep | PA | 1789-03-04 | 1791-03-03 | | | -1 | | | | | | | | | | | | 90 | Thomas Fitzsimons | rep | PA | 1791-10-24 | 1793-03-03 | | | 1 | | | | | | | | | | | | 91 | Thomas Fitzsimons | rep | PA | 1793-12-02 | 1795-03-03 | | | -1 | | | | | | | | | | | | 92 | Uriah Forrest | rep | MD | 1793-12-02 | 1795-03-03 | | | 3 | | | | | | | | | | | | 93 | Frederick Frelinghuysen | sen | NJ | 1793-12-02 | 1797-03-03 | 2 | Federalist | | | | | | | | | | | | | 94 | Alexander Gillon | rep | SC | 1793-12-02 | 1795-03-03 | | | 5 | | | | | | | | | | | | 95 | James Gordon | rep | NY | 1791-10-24 | 1793-03-03 | | | 6 | | | | | | | | | | | | 96 | James Gordon | rep | NY | 1793-12-02 | 1795-03-03 | | | 9 | | | | | | | | | | | | 97 | Samuel Griffin | rep | VA | 1789-03-04 | 1791-03-03 | | | 10 | | | | | | | | | | | | 98 | Samuel Griffin | rep | VA | 1791-10-24 | 1793-03-03 | | | 10 | | | | | | | | | | | | 99 | Samuel Griffin | rep | VA | 1793-12-02 | 1795-03-03 | | | 13 | | | | | | | | | | | | 100 | Samuel Holten | rep | MA | 1793-12-02 | 1795-03-03 | | | 1 | | | | | | | | | | | |