legislator_terms
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
121 rows where "end" is on date 1795-03-03 sorted by state
This data as json, copyable, CSV (advanced)
Suggested facets: type, state, start, district, start (date)
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
103 | 103 | Amasa Learned L000178 | rep | CT | 1793-12-02 | 1795-03-03 | -1 | ||||||||||||||
112 | 112 | Stephen Mitchell M000828 | sen | CT | 1793-12-02 | 1795-03-03 | 3 | Pro-Administration | |||||||||||||
131 | 131 | Jeremiah Wadsworth W000013 | rep | CT | 1793-12-02 | 1795-03-03 | -1 | ||||||||||||||
215 | 215 | Zephaniah Swift S001119 | rep | CT | 1793-12-02 | 1795-03-03 | Federalist | -1 | |||||||||||||
220 | 220 | Jonathan Trumbull T000389 | rep | CT | 1793-12-02 | 1795-03-03 | Federalist | -1 | |||||||||||||
254 | 254 | Joshua Coit C000600 | rep | CT | 1793-12-02 | 1795-03-03 | Federalist | -1 | |||||||||||||
536 | 536 | Uriah Tracy T000348 | rep | CT | 1793-12-02 | 1795-03-03 | Federalist | -1 | |||||||||||||
984 | 984 | James Hillhouse H000618 | rep | CT | 1793-12-02 | 1795-03-03 | -1 | ||||||||||||||
201 | 201 | John Patten P000108 | rep | DE | 1793-12-02 | 1795-03-03 | Republican | 0 | |||||||||||||
270 | 270 | Henry Latimer L000115 | rep | DE | 1793-12-02 | 1795-03-03 | Federalist | 0 | |||||||||||||
82 | 82 | Thomas Carnes C000163 | rep | GA | 1793-12-02 | 1795-03-03 | 0 | ||||||||||||||
167 | 167 | James Gunn G000526 | sen | GA | 1789-03-04 | 1795-03-03 | 3 | Federalist | |||||||||||||
658 | 658 | Abraham Baldwin B000084 | rep | GA | 1793-12-02 | 1795-03-03 | Democratic Republican | 0 | |||||||||||||
70 | 70 | John Edwards E000075 | sen | KY | 1792-01-01 | 1795-03-03 | 3 | Anti-Administration | |||||||||||||
165 | 165 | Christopher Greenup G000434 | rep | KY | 1793-12-02 | 1795-03-03 | Republican | 1 | |||||||||||||
194 | 194 | Alexander Orr O000101 | rep | KY | 1793-12-02 | 1795-03-03 | Republican | 2 | |||||||||||||
78 | 78 | Shearjashub Bourne B000671 | rep | MA | 1793-12-02 | 1795-03-03 | 3 | ||||||||||||||
85 | 85 | David Cobb C000545 | rep | MA | 1793-12-02 | 1795-03-03 | -1 | ||||||||||||||
86 | 86 | Peleg Coffin C000591 | rep | MA | 1793-12-02 | 1795-03-03 | 3 | ||||||||||||||
100 | 100 | Samuel Holten H000750 | rep | MA | 1793-12-02 | 1795-03-03 | 1 | ||||||||||||||
134 | 134 | Artemas Ward W000127 | rep | MA | 1793-12-02 | 1795-03-03 | 2 | ||||||||||||||
143 | 143 | Fisher Ames A000174 | rep | MA | 1793-12-02 | 1795-03-03 | Federalist | 1 | |||||||||||||
157 | 157 | Henry Dearborn D000178 | rep | MA | 1793-12-02 | 1795-03-03 | Republican | 4 | |||||||||||||
183 | 183 | William Lyman L000530 | rep | MA | 1793-12-02 | 1795-03-03 | Republican | 2 | |||||||||||||
227 | 227 | Benjamin Goodhue G000286 | rep | MA | 1793-12-02 | 1795-03-03 | Federalist | 1 | |||||||||||||
352 | 352 | Samuel Dexter D000296 | rep | MA | 1793-12-02 | 1795-03-03 | Federalist | 1 | |||||||||||||
425 | 425 | Theodore Sedgwick S000222 | rep | MA | 1793-12-02 | 1795-03-03 | Federalist | 2 | |||||||||||||
435 | 435 | George Thatcher T000141 | rep | MA | 1793-12-02 | 1795-03-03 | Federalist | 4 | |||||||||||||
445 | 445 | Dwight Foster F000301 | rep | MA | 1793-12-02 | 1795-03-03 | Federalist | 2 | |||||||||||||
773 | 773 | Peleg Wadsworth W000014 | rep | MA | 1793-12-02 | 1795-03-03 | Federalist | 4 | |||||||||||||
88 | 88 | Benjamin Edwards E000060 | rep | MD | 1793-12-02 | 1795-03-03 | 3 | ||||||||||||||
92 | 92 | Uriah Forrest F000282 | rep | MD | 1793-12-02 | 1795-03-03 | 3 | ||||||||||||||
111 | 111 | John Mercer M000645 | rep | MD | 1793-12-02 | 1795-03-03 | 2 | ||||||||||||||
159 | 159 | Gabriel Duvall D000578 | rep | MD | 1793-12-02 | 1795-03-03 | Republican | 2 | |||||||||||||
176 | 176 | John Henry H000508 | sen | MD | 1789-03-04 | 1795-03-03 | 3 | Pro-Administration | |||||||||||||
191 | 191 | William Murray M001119 | rep | MD | 1793-12-02 | 1795-03-03 | Federalist | 8 | |||||||||||||
212 | 212 | Thomas Sprigg S000753 | rep | MD | 1793-12-02 | 1795-03-03 | Republican | 4 | |||||||||||||
331 | 331 | Gabriel Christie C000382 | rep | MD | 1793-12-02 | 1795-03-03 | Republican | 6 | |||||||||||||
348 | 348 | George Dent D000254 | rep | MD | 1793-12-02 | 1795-03-03 | Federalist | 1 | |||||||||||||
450 | 450 | William Hindman H000629 | rep | MD | 1793-12-02 | 1795-03-03 | Federalist | 7 | |||||||||||||
2957 | 2957 | Samuel Smith S000609 | rep | MD | 1793-12-02 | 1795-03-03 | Democratic Republican | 5 | |||||||||||||
14 | 14 | Benjamin Hawkins H000368 | sen | NC | 1789-03-04 | 1795-03-03 | 3 | Pro-Administration | |||||||||||||
87 | 87 | William Dawson D000157 | rep | NC | 1793-12-02 | 1795-03-03 | Anti-Administration | 8 | |||||||||||||
108 | 108 | Joseph McDowell M000424 | rep | NC | 1793-12-02 | 1795-03-03 | 1 | ||||||||||||||
109 | 109 | Alexander Mebane M000622 | rep | NC | 1793-12-02 | 1795-03-03 | 4 | ||||||||||||||
136 | 136 | Benjamin Williams W000491 | rep | NC | 1793-12-02 | 1795-03-03 | 10 | ||||||||||||||
274 | 274 | Matthew Locke L000389 | rep | NC | 1793-12-02 | 1795-03-03 | Republican | 2 | |||||||||||||
480 | 480 | William Grove G000502 | rep | NC | 1793-12-02 | 1795-03-03 | Federalist | 7 | |||||||||||||
575 | 575 | James Gillespie G000196 | rep | NC | 1793-12-02 | 1795-03-03 | Anti-Administration | 6 | |||||||||||||
786 | 786 | Joseph Winston W000642 | rep | NC | 1793-12-02 | 1795-03-03 | Republican | 3 | |||||||||||||
1112 | 1112 | Thomas Blount B000569 | rep | NC | 1793-12-02 | 1795-03-03 | Republican | 9 | |||||||||||||
2665 | 2665 | Nathaniel Macon M000034 | rep | NC | 1793-12-02 | 1795-03-03 | Democratic Republican | 5 | |||||||||||||
138 | 138 | Paine Wingate W000633 | rep | NH | 1793-12-02 | 1795-03-03 | -1 | ||||||||||||||
178 | 178 | John Langdon L000067 | sen | NH | 1789-03-04 | 1795-03-03 | 3 | Democratic Republican | |||||||||||||
209 | 209 | John Sherburne S000339 | rep | NH | 1793-12-02 | 1795-03-03 | Republican | -1 | |||||||||||||
296 | 296 | Jeremiah Smith S000563 | rep | NH | 1793-12-02 | 1795-03-03 | Federalist | -1 | |||||||||||||
1166 | 1166 | Nicholas Gilman G000215 | rep | NH | 1793-12-02 | 1795-03-03 | Democratic Republican | -1 | |||||||||||||
73 | 73 | John Beatty B000282 | rep | NJ | 1793-12-02 | 1795-03-03 | -1 | ||||||||||||||
76 | 76 | Elias Boudinot B000661 | rep | NJ | 1793-12-02 | 1795-03-03 | -1 | ||||||||||||||
81 | 81 | Lambert Cadwalader C000012 | rep | NJ | 1793-12-02 | 1795-03-03 | -1 | ||||||||||||||
84 | 84 | Abraham Clark C000418 | rep | NJ | 1793-12-02 | 1795-03-03 | -1 | ||||||||||||||
344 | 344 | Jonathan Dayton D000165 | rep | NJ | 1793-12-02 | 1795-03-03 | Federalist | -1 | |||||||||||||
719 | 719 | Aaron Kitchell K000246 | rep | NJ | 1793-12-02 | 1795-03-03 | Democratic Republican | -1 | |||||||||||||
96 | 96 | James Gordon G000311 | rep | NY | 1793-12-02 | 1795-03-03 | 9 | ||||||||||||||
122 | 122 | Silas Talbot T000019 | rep | NY | 1793-12-02 | 1795-03-03 | 10 | ||||||||||||||
124 | 124 | Thomas Tredwell T000361 | rep | NY | 1793-12-02 | 1795-03-03 | 2 | ||||||||||||||
125 | 125 | Peter Van Gaasbeck V000039 | rep | NY | 1793-12-02 | 1795-03-03 | 4 | ||||||||||||||
135 | 135 | John Watts W000211 | rep | NY | 1793-12-02 | 1795-03-03 | 1 | ||||||||||||||
162 | 162 | Ezekiel Gilbert G000173 | rep | NY | 1793-12-02 | 1795-03-03 | Federalist | 6 | |||||||||||||
312 | 312 | John Van Alen V000012 | rep | NY | 1793-12-02 | 1795-03-03 | Federalist | 7 | |||||||||||||
366 | 366 | Henry Glen G000235 | rep | NY | 1793-12-02 | 1795-03-03 | Federalist | 8 | |||||||||||||
553 | 553 | Theodorus Bailey B000049 | rep | NY | 1793-12-02 | 1795-03-03 | 5 | ||||||||||||||
911 | 911 | Philip Van Cortlandt V000022 | rep | NY | 1793-12-02 | 1795-03-03 | Republican | 3 | |||||||||||||
2051 | 2051 | Rufus King K000212 | sen | NY | 1789-03-04 | 1795-03-03 | 3 | Federalist | |||||||||||||
22 | 22 | Robert Morris M000985 | sen | PA | 1789-03-04 | 1795-03-03 | 3 | Pro-Administration | |||||||||||||
72 | 72 | James Armstrong A000280 | rep | PA | 1793-12-02 | 1795-03-03 | -1 | ||||||||||||||
91 | 91 | Thomas Fitzsimons F000178 | rep | PA | 1793-12-02 | 1795-03-03 | -1 | ||||||||||||||
101 | 101 | William Irvine I000035 | rep | PA | 1793-12-02 | 1795-03-03 | -1 | ||||||||||||||
113 | 113 | William Montgomery M000873 | rep | PA | 1793-12-02 | 1795-03-03 | -1 | ||||||||||||||
119 | 119 | Thomas Scott S000186 | rep | PA | 1793-12-02 | 1795-03-03 | -1 | ||||||||||||||
188 | 188 | Frederick Muhlenberg M001063 | rep | PA | 1793-12-02 | 1795-03-03 | Anti-administration | -1 | |||||||||||||
378 | 378 | Thomas Hartley H000299 | rep | PA | 1793-12-02 | 1795-03-03 | Federalist | -1 | |||||||||||||
389 | 389 | John Kittera K000253 | rep | PA | 1793-12-02 | 1795-03-03 | Federalist | -1 | |||||||||||||
510 | 510 | John Muhlenberg M001066 | rep | PA | 1793-12-02 | 1795-03-03 | -1 | ||||||||||||||
586 | 586 | Daniel Hiester H000570 | rep | PA | 1793-12-02 | 1795-03-03 | Republican | -1 | |||||||||||||
846 | 846 | Andrew Gregg G000442 | rep | PA | 1793-12-02 | 1795-03-03 | Democratic Republican | -1 | |||||||||||||
1225 | 1225 | John Smilie S000508 | rep | PA | 1793-12-02 | 1795-03-03 | Republican | -1 | |||||||||||||
1554 | 1554 | William Findley F000124 | rep | PA | 1793-12-02 | 1795-03-03 | Anti-Administration | -1 | |||||||||||||
150 | 150 | Benjamin Bourne B000669 | rep | RI | 1793-12-02 | 1795-03-03 | Federalist | -1 | |||||||||||||
1028 | 1028 | Francis Malbone M000076 | rep | RI | 1793-12-02 | 1795-03-03 | Federalist | -1 | |||||||||||||
16 | 16 | Ralph Izard I000053 | sen | SC | 1789-03-04 | 1795-03-03 | 3 | Pro-Administration | |||||||||||||
94 | 94 | Alexander Gillon G000211 | rep | SC | 1793-12-02 | 1795-03-03 | 5 | ||||||||||||||
117 | 117 | Andrew Pickens P000320 | rep | SC | 1793-12-02 | 1795-03-03 | 6 | ||||||||||||||
233 | 233 | John Hunter H000982 | rep | SC | 1793-12-02 | 1795-03-03 | 2 | ||||||||||||||
240 | 240 | Lemuel Benton B000396 | rep | SC | 1793-12-02 | 1795-03-03 | Republican | 3 | |||||||||||||
304 | 304 | William Smith S000633 | rep | SC | 1793-12-02 | 1795-03-03 | Federalist | 1 | |||||||||||||
1261 | 1261 | Richard Winn W000637 | rep | SC | 1793-12-02 | 1795-03-03 | Republican | 4 | |||||||||||||
1783 | 1783 | Robert Harper H000225 | rep | SC | 1793-12-02 | 1795-03-03 | 5 | ||||||||||||||
222 | 222 | James White W000377 | rep | TN | 1793-12-02 | 1795-03-03 | -1 | ||||||||||||||
99 | 99 | Samuel Griffin G000466 | rep | VA | 1793-12-02 | 1795-03-03 | 13 |
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);