\begin{tabular}{rlllllrlrllllllllllll} \toprule 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 \\ \midrule 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 & & & & & & & & & & & & \\ \bottomrule \end{tabular}