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 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 12 William Grayson sen VA 1789-03-04 1791-03-03 1 Anti-Administration 14 Benjamin Hawkins sen NC 1789-03-04 1795-03-03 3 Pro-Administration 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 22 Robert Morris sen PA 1789-03-04 1795-03-03 3 Pro-Administration 24 William Paterson sen NJ 1789-03-04 1791-03-03 2 Pro-Administration 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 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 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 54 Roger Sherman sen CT 1791-10-24 1793-12-31 3 Pro-Administration 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 79 William Bradford sen RI 1793-12-02 1797-12-31 2 Federalist 93 Frederick Frelinghuysen sen NJ 1793-12-02 1797-03-03 2 Federalist 107 Alexander Martin sen NC 1793-12-02 1799-03-03 2 Republican 112 Stephen Mitchell sen CT 1793-12-02 1795-03-03 3 Pro-Administration 120 Caleb Strong sen MA 1789-03-04 1793-03-03 2 Pro-Administration 121 Caleb Strong sen MA 1793-12-02 1797-03-03 2 Federalist 128 John Vining sen DE 1793-12-02 1799-03-03 2 Federalist 137 Paine Wingate sen NH 1789-03-04 1793-03-03 2 Anti-Administration 139 Henry Tazewell sen VA 1794-01-01 1799-03-03 2 Republican 140 George Walton sen GA 1795-11-16 1796-02-20 2 Federalist 145 William Bingham sen PA 1795-12-07 1801-03-03 3 Federalist 147 Timothy Bloodworth sen NC 1795-12-07 1801-03-03 3 Republican 167 James Gunn sen GA 1789-03-04 1795-03-03 3 Federalist 168 James Gunn sen GA 1795-12-07 1801-03-03 3 Federalist 176 John Henry sen MD 1789-03-04 1795-03-03 3 Pro-Administration 177 John Henry sen MD 1795-12-07 1797-12-31 3 Federalist 178 John Langdon sen NH 1789-03-04 1795-03-03 3 Democratic Republican 179 John Langdon sen NH 1795-12-07 1801-03-03 3 Republican 185 Humphrey Marshall sen KY 1795-12-07 1801-03-03 3 Federalist 200 Elijah Paine sen VT 1795-12-07 1801-03-03 3 Federalist 205 Jacob Read sen SC 1795-12-07 1801-03-03 3 Federalist 221 Jonathan Trumbull sen CT 1795-12-07 1797-03-03 3 Federalist 224 William Blount sen TN 1796-01-01 1797-12-31 2 Republican 229 Benjamin Goodhue sen MA 1796-06-11 1797-03-03 1 Federalist 230 Benjamin Goodhue sen MA 1797-03-04 1800-11-08 1 Federalist 231 John Howard sen MD 1796-12-05 1797-03-04 1 Federalist 232 John Howard sen MD 1797-03-04 1803-03-03 1 Federalist 234 John Hunter sen SC 1796-01-01 1799-03-03 2 Republican 237 John Laurance sen NY 1796-01-01 1801-03-03 3 Federalist 238 Josiah Tattnall sen GA 1796-01-01 1799-03-03 2 Republican 252 Nathaniel Chipman sen VT 1797-05-15 1803-03-03 1 Federalist 261 Theodore Foster sen RI 1790-06-12 1791-03-03 1 Federalist 262 Theodore Foster sen RI 1791-03-04 1797-03-03 1 Federalist 263 Theodore Foster sen RI 1797-05-15 1803-03-03 1 Republican 271 Henry Latimer sen DE 1795-12-07 1797-03-03 1 Federalist 272 Henry Latimer sen DE 1797-05-15 1801-12-31 1 Federalist 273 James Lloyd sen MD 1797-05-15 1801-03-03 3 Federalist 278 Stevens Mason sen VA 1794-01-01 1797-03-03 1 Republican 279 Stevens Mason sen VA 1797-05-15 1803-03-03 1 Republican 285 James Ross sen PA 1794-01-01 1797-03-03 1 Federalist 286 James Ross sen PA 1797-05-15 1803-03-03 1 Federalist 287 John Rutherfurd sen NJ 1791-10-24 1797-03-03 1 Federalist 288 John Rutherfurd sen NJ 1797-05-15 1799-03-03 1 Federalist 289 Philip Schuyler sen NY 1789-03-04 1791-03-03 1 Pro-Administration 290 Philip Schuyler sen NY 1797-05-15 1799-03-03 1 Federalist 317 Joshua Clayton sen DE 1798-01-01 1799-03-03 2 Federalist 318 John Hobart sen NY 1798-01-01 1799-03-03 1 Federalist 319 William North sen NY 1798-01-01 1799-03-03 1 Federalist 320 James Watson sen NY 1798-01-01 1801-03-03 1 Federalist 328 John Brown sen KY 1792-06-18 1793-03-03 2 Republican 329 John Brown sen KY 1793-03-04 1799-03-03 2 Republican 330 John Brown sen KY 1799-12-02 1805-03-03 2 Republican 334 William Cocke sen TN 1796-01-01 1797-03-03 1 Republican 335 William Cocke sen TN 1799-12-02 1805-03-03 2 Republican 341 Franklin Davenport sen NJ 1798-12-05 1799-03-03 1 Federalist 347 Jonathan Dayton sen NJ 1799-12-02 1805-03-03 2 Federalist 353 Samuel Dexter sen MA 1799-12-02 1801-03-03 2 Federalist 374 Ray Greene sen RI 1797-05-15 1799-03-03 2 Federalist 375 Ray Greene sen RI 1799-12-02 1801-12-31 2 Federalist 397 Samuel Livermore sen NH 1793-12-02 1799-03-03 2 Federalist 398 Samuel Livermore sen NH 1799-12-02 1801-12-31 2 Federalist 426 Theodore Sedgwick sen MA 1796-01-01 1799-03-03 2 Federalist 448 Dwight Foster sen MA 1800-01-01 1803-12-31 2 Federalist 453 William Hindman sen MD 1800-01-01 1801-03-03 3 Federalist 454 Gouverneur Morris sen NY 1800-01-01 1803-03-03 1 Federalist 459 John Breckinridge sen KY 1801-12-07 1805-12-31 3 Republican 464 John Colhoun sen SC 1801-12-07 1803-03-03 3 Republican 468 Christopher Ellery sen RI 1801-12-07 1805-03-03 2 Republican 494 James Jackson sen GA 1793-12-02 1795-12-31 2 Republican 495 James Jackson sen GA 1801-12-07 1807-03-03 3 Republican 502 George Logan sen PA 1801-12-07 1807-03-03 3 Republican 512 John Muhlenberg sen PA 1801-12-07 1801-12-31 3 Democratic Republican 513 Aaron Ogden sen NJ 1801-12-07 1803-03-03 1 Federalist