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 ---------+----------------------+--------+---------+------------+------------+---------+-----------------------+------------+-------+----------------------+-------+----------+-----------+---------+-------+----------------+----------+--------------+-----------+------------ 101 | William Irvine | rep | PA | 1793-12-02 | 1795-03-03 | | | -1 | | | | | | | | | | | | 102 | Amasa Learned | rep | CT | 1791-10-24 | 1793-03-03 | | | -1 | | | | | | | | | | | | 103 | Amasa Learned | rep | CT | 1793-12-02 | 1795-03-03 | | | -1 | | | | | | | | | | | | 104 | Richard Lee | rep | VA | 1789-03-04 | 1791-03-03 | | | 4 | | | | | | | | | | | | 105 | Richard Lee | rep | VA | 1791-10-24 | 1793-03-03 | | | 4 | | | | | | | | | | | | 106 | Richard Lee | rep | VA | 1793-12-02 | 1795-03-03 | | | 17 | | | | | | | | | | | | 107 | Alexander Martin | sen | NC | 1793-12-02 | 1799-03-03 | 2 | Republican | | | | | | | | | | | | | 108 | Joseph McDowell | rep | NC | 1793-12-02 | 1795-03-03 | | | 1 | | | | | | | | | | | | 109 | Alexander Mebane | rep | NC | 1793-12-02 | 1795-03-03 | | | 4 | | | | | | | | | | | | 110 | John Mercer | rep | MD | 1791-10-24 | 1793-03-03 | | | 3 | | | | | | | | | | | | 111 | John Mercer | rep | MD | 1793-12-02 | 1795-03-03 | | | 2 | | | | | | | | | | | | 112 | Stephen Mitchell | sen | CT | 1793-12-02 | 1795-03-03 | 3 | Pro-Administration | | | | | | | | | | | | | 113 | William Montgomery | rep | PA | 1793-12-02 | 1795-03-03 | | | -1 | | | | | | | | | | | | 114 | Joseph Neville | rep | VA | 1793-12-02 | 1795-03-03 | | | 3 | | | | | | | | | | | | 115 | Nathaniel Niles | rep | VT | 1791-10-24 | 1793-03-03 | | | 2 | | | | | | | | | | | | 116 | Nathaniel Niles | rep | VT | 1793-12-02 | 1795-03-03 | | | 2 | | | | | | | | | | | | 117 | Andrew Pickens | rep | SC | 1793-12-02 | 1795-03-03 | | | 6 | | | | | | | | | | | | 118 | Thomas Scott | rep | PA | 1789-03-04 | 1791-03-03 | | | -1 | | | | | | | | | | | | 119 | Thomas Scott | rep | PA | 1793-12-02 | 1795-03-03 | | | -1 | | | | | | | | | | | | 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 | | | | | | | | | | | | | 122 | Silas Talbot | rep | NY | 1793-12-02 | 1795-03-03 | | | 10 | | | | | | | | | | | | 123 | Thomas Tredwell | rep | NY | 1791-10-24 | 1793-03-03 | | | 1 | | | | | | | | | | | | 124 | Thomas Tredwell | rep | NY | 1793-12-02 | 1795-03-03 | | | 2 | | | | | | | | | | | | 125 | Peter Van Gaasbeck | rep | NY | 1793-12-02 | 1795-03-03 | | | 4 | | | | | | | | | | | | 126 | John Vining | rep | DE | 1789-03-04 | 1791-03-03 | | Pro-Administration | 0 | | | | | | | | | | | | 127 | John Vining | rep | DE | 1791-10-24 | 1793-03-03 | | Pro-Administration | 0 | | | | | | | | | | | | 128 | John Vining | sen | DE | 1793-12-02 | 1799-03-03 | 2 | Federalist | | | | | | | | | | | | | 129 | Jeremiah Wadsworth | rep | CT | 1789-03-04 | 1791-03-03 | | | -1 | | | | | | | | | | | | 130 | Jeremiah Wadsworth | rep | CT | 1791-10-24 | 1793-03-03 | | | -1 | | | | | | | | | | | | 131 | Jeremiah Wadsworth | rep | CT | 1793-12-02 | 1795-03-03 | | | -1 | | | | | | | | | | | | 132 | Francis Walker | rep | VA | 1793-12-02 | 1795-03-03 | | | 14 | | | | | | | | | | | | 133 | Artemas Ward | rep | MA | 1791-10-24 | 1793-03-03 | | | 7 | | | | | | | | | | | | 134 | Artemas Ward | rep | MA | 1793-12-02 | 1795-03-03 | | | 2 | | | | | | | | | | | | 135 | John Watts | rep | NY | 1793-12-02 | 1795-03-03 | | | 1 | | | | | | | | | | | | 136 | Benjamin Williams | rep | NC | 1793-12-02 | 1795-03-03 | | | 10 | | | | | | | | | | | | 137 | Paine Wingate | sen | NH | 1789-03-04 | 1793-03-03 | 2 | Anti-Administration | | | | | | | | | | | | | 138 | Paine Wingate | rep | NH | 1793-12-02 | 1795-03-03 | | | -1 | | | | | | | | | | | | 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 | | | | | | | | | | | | | 141 | Fisher Ames | rep | MA | 1789-03-04 | 1791-03-03 | | Federalist | 1 | | | | | | | | | | | | 142 | Fisher Ames | rep | MA | 1791-10-24 | 1793-03-03 | | Federalist | 1 | | | | | | | | | | | | 143 | Fisher Ames | rep | MA | 1793-12-02 | 1795-03-03 | | Federalist | 1 | | | | | | | | | | | | 144 | Fisher Ames | rep | MA | 1795-12-07 | 1797-03-03 | | Federalist | 8 | | | | | | | | | | | | 145 | William Bingham | sen | PA | 1795-12-07 | 1801-03-03 | 3 | Federalist | | | | | | | | | | | | | 146 | Timothy Bloodworth | rep | NC | 1789-03-04 | 1791-03-03 | | | 3 | | | | | | | | | | | | 147 | Timothy Bloodworth | sen | NC | 1795-12-07 | 1801-03-03 | 3 | Republican | | | | | | | | | | | | | 148 | Benjamin Bourne | rep | RI | 1789-03-04 | 1791-03-03 | | Federalist | 1 | | | | | | | | | | | | 149 | Benjamin Bourne | rep | RI | 1791-10-24 | 1793-03-03 | | Federalist | 1 | | | | | | | | | | | | 150 | Benjamin Bourne | rep | RI | 1793-12-02 | 1795-03-03 | | Federalist | -1 | | | | | | | | | | | | 151 | Benjamin Bourne | rep | RI | 1795-12-07 | 1797-03-03 | | Federalist | -1 | | | | | | | | | | | | 152 | Daniel Buck | rep | VT | 1795-12-07 | 1797-03-03 | | Federalist | 2 | | | | | | | | | | | | 153 | Isaac Coles | rep | VA | 1789-03-04 | 1791-03-03 | | Republican | 6 | | | | | | | | | | | | 154 | Isaac Coles | rep | VA | 1793-12-02 | 1795-03-03 | | Republican | 6 | | | | | | | | | | | | 155 | Isaac Coles | rep | VA | 1795-12-07 | 1797-03-03 | | Republican | 6 | | | | | | | | | | | | 156 | Jeremiah Crabb | rep | MD | 1795-12-07 | 1797-03-03 | | Federalist | 3 | | | | | | | | | | | | 157 | Henry Dearborn | rep | MA | 1793-12-02 | 1795-03-03 | | Republican | 4 | | | | | | | | | | | | 158 | Henry Dearborn | rep | MA | 1795-12-07 | 1797-03-03 | | Republican | 12 | | | | | | | | | | | | 159 | Gabriel Duvall | rep | MD | 1793-12-02 | 1795-03-03 | | Republican | 2 | | | | | | | | | | | | 160 | Gabriel Duvall | rep | MD | 1795-12-07 | 1797-03-03 | | Republican | 2 | | | | | | | | | | | | 161 | Samuel Earle | rep | SC | 1795-12-07 | 1797-03-03 | | Republican | 6 | | | | | | | | | | | | 162 | Ezekiel Gilbert | rep | NY | 1793-12-02 | 1795-03-03 | | Federalist | 6 | | | | | | | | | | | | 163 | Ezekiel Gilbert | rep | NY | 1795-12-07 | 1797-03-03 | | Federalist | 6 | | | | | | | | | | | | 164 | Christopher Greenup | rep | KY | 1791-10-24 | 1793-03-03 | | Republican | 1 | | | | | | | | | | | | 165 | Christopher Greenup | rep | KY | 1793-12-02 | 1795-03-03 | | Republican | 1 | | | | | | | | | | | | 166 | Christopher Greenup | rep | KY | 1795-12-07 | 1797-03-03 | | Republican | 1 | | | | | | | | | | | | 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 | | | | | | | | | | | | | 169 | George Hancock | rep | VA | 1793-12-02 | 1795-03-03 | | | 5 | | | | | | | | | | | | 170 | George Hancock | rep | VA | 1795-12-07 | 1797-03-03 | | Federalist | 5 | | | | | | | | | | | | 171 | John Hathorn | rep | NY | 1789-03-04 | 1791-03-03 | | Republican | 4 | | | | | | | | | | | | 172 | John Hathorn | rep | NY | 1795-12-07 | 1797-03-03 | | Republican | 4 | | | | | | | | | | | | 173 | John Heath | rep | VA | 1793-12-02 | 1795-03-03 | | Republican | 19 | | | | | | | | | | | | 174 | John Heath | rep | VA | 1795-12-07 | 1797-03-03 | | Republican | 19 | | | | | | | | | | | | 175 | Thomas Henderson | rep | NJ | 1795-12-07 | 1797-03-03 | | Federalist | -1 | | | | | | | | | | | | 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 | | | | | | | | | | | | | 180 | George Leonard | rep | MA | 1789-03-04 | 1791-03-03 | | Federalist | 7 | | | | | | | | | | | | 181 | George Leonard | rep | MA | 1791-10-24 | 1793-03-03 | | Federalist | 6 | | | | | | | | | | | | 182 | George Leonard | rep | MA | 1795-12-07 | 1797-03-03 | | Federalist | 7 | | | | | | | | | | | | 183 | William Lyman | rep | MA | 1793-12-02 | 1795-03-03 | | Republican | 2 | | | | | | | | | | | | 184 | William Lyman | rep | MA | 1795-12-07 | 1797-03-03 | | Republican | 2 | | | | | | | | | | | | 185 | Humphrey Marshall | sen | KY | 1795-12-07 | 1801-03-03 | 3 | Federalist | | | | | | | | | | | | | 186 | Frederick Muhlenberg | rep | PA | 1789-03-04 | 1791-03-03 | | Pro-administration | -1 | | | | | | | | | | | | 187 | Frederick Muhlenberg | rep | PA | 1791-10-24 | 1793-03-03 | | Anti-administration | 2 | | | | | | | | | | | | 188 | Frederick Muhlenberg | rep | PA | 1793-12-02 | 1795-03-03 | | Anti-administration | -1 | | | | | | | | | | | | 189 | Frederick Muhlenberg | rep | PA | 1795-12-07 | 1797-03-03 | | Republican | 2 | | | | | | | | | | | | 190 | William Murray | rep | MD | 1791-10-24 | 1793-03-03 | | Federalist | 5 | | | | | | | | | | | | 191 | William Murray | rep | MD | 1793-12-02 | 1795-03-03 | | Federalist | 8 | | | | | | | | | | | | 192 | William Murray | rep | MD | 1795-12-07 | 1797-03-03 | | Federalist | 8 | | | | | | | | | | | | 193 | Alexander Orr | rep | KY | 1791-10-24 | 1793-03-03 | | Republican | 2 | | | | | | | | | | | | 194 | Alexander Orr | rep | KY | 1793-12-02 | 1795-03-03 | | Republican | 2 | | | | | | | | | | | | 195 | Alexander Orr | rep | KY | 1795-12-07 | 1797-03-03 | | Republican | 2 | | | | | | | | | | | | 196 | John Page | rep | VA | 1789-03-04 | 1791-03-03 | | Republican | 7 | | | | | | | | | | | | 197 | John Page | rep | VA | 1791-10-24 | 1793-03-03 | | Republican | 7 | | | | | | | | | | | | 198 | John Page | rep | VA | 1793-12-02 | 1795-03-03 | | Republican | 12 | | | | | | | | | | | | 199 | John Page | rep | VA | 1795-12-07 | 1797-03-03 | | Republican | 12 | | | | | | | | | | | | 200 | Elijah Paine | sen | VT | 1795-12-07 | 1801-03-03 | 3 | Federalist | | | | | | | | | | | | |