legislator_terms
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
44,551 rows sorted by end
This data as json, copyable, CSV (advanced)
start (date) >30 ✖
- 1929-04-15 499
- 1919-05-19 498
- 1913-04-07 497
- 1917-04-02 496
- 1923-12-03 495
- 1931-12-07 495
- 1939-01-03 495
- 1921-04-11 492
- 1941-01-03 492
- 1943-01-06 487
- 1925-12-07 485
- 1927-12-05 485
- 1933-03-09 485
- 1947-01-03 485
- 1945-01-03 484
- 1951-01-03 484
- 1959-01-07 484
- 1961-01-03 484
- 1937-01-05 483
- 1969-01-03 482
- 1981-01-05 482
- 1915-12-06 481
- 1963-01-09 481
- 1989-01-03 481
- 1935-01-03 480
- 1949-01-03 480
- 1957-01-03 480
- 1975-01-14 480
- 1971-01-21 478
- 1977-01-04 478
- …
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 | ||||||||||||||
131 | 131 | Jeremiah Wadsworth W000013 | rep | CT | 1793-12-02 | 1795-03-03 | -1 | ||||||||||||||
132 | 132 | Francis Walker W000051 | rep | VA | 1793-12-02 | 1795-03-03 | 14 | ||||||||||||||
134 | 134 | Artemas Ward W000127 | rep | MA | 1793-12-02 | 1795-03-03 | 2 | ||||||||||||||
135 | 135 | John Watts W000211 | rep | NY | 1793-12-02 | 1795-03-03 | 1 | ||||||||||||||
136 | 136 | Benjamin Williams W000491 | rep | NC | 1793-12-02 | 1795-03-03 | 10 | ||||||||||||||
138 | 138 | Paine Wingate W000633 | rep | NH | 1793-12-02 | 1795-03-03 | -1 | ||||||||||||||
143 | 143 | Fisher Ames A000174 | rep | MA | 1793-12-02 | 1795-03-03 | Federalist | 1 | |||||||||||||
150 | 150 | Benjamin Bourne B000669 | rep | RI | 1793-12-02 | 1795-03-03 | Federalist | -1 | |||||||||||||
154 | 154 | Isaac Coles C000624 | rep | VA | 1793-12-02 | 1795-03-03 | Republican | 6 | |||||||||||||
157 | 157 | Henry Dearborn D000178 | rep | MA | 1793-12-02 | 1795-03-03 | Republican | 4 | |||||||||||||
159 | 159 | Gabriel Duvall D000578 | rep | MD | 1793-12-02 | 1795-03-03 | Republican | 2 | |||||||||||||
162 | 162 | Ezekiel Gilbert G000173 | rep | NY | 1793-12-02 | 1795-03-03 | Federalist | 6 | |||||||||||||
165 | 165 | Christopher Greenup G000434 | rep | KY | 1793-12-02 | 1795-03-03 | Republican | 1 | |||||||||||||
167 | 167 | James Gunn G000526 | sen | GA | 1789-03-04 | 1795-03-03 | 3 | Federalist | |||||||||||||
169 | 169 | George Hancock H000148 | rep | VA | 1793-12-02 | 1795-03-03 | 5 | ||||||||||||||
173 | 173 | John Heath H000431 | rep | VA | 1793-12-02 | 1795-03-03 | Republican | 19 | |||||||||||||
176 | 176 | John Henry H000508 | sen | MD | 1789-03-04 | 1795-03-03 | 3 | Pro-Administration | |||||||||||||
178 | 178 | John Langdon L000067 | sen | NH | 1789-03-04 | 1795-03-03 | 3 | Democratic Republican | |||||||||||||
183 | 183 | William Lyman L000530 | rep | MA | 1793-12-02 | 1795-03-03 | Republican | 2 | |||||||||||||
188 | 188 | Frederick Muhlenberg M001063 | rep | PA | 1793-12-02 | 1795-03-03 | Anti-administration | -1 | |||||||||||||
191 | 191 | William Murray M001119 | rep | MD | 1793-12-02 | 1795-03-03 | Federalist | 8 | |||||||||||||
194 | 194 | Alexander Orr O000101 | rep | KY | 1793-12-02 | 1795-03-03 | Republican | 2 | |||||||||||||
198 | 198 | John Page P000018 | rep | VA | 1793-12-02 | 1795-03-03 | Republican | 12 | |||||||||||||
201 | 201 | John Patten P000108 | rep | DE | 1793-12-02 | 1795-03-03 | Republican | 0 | |||||||||||||
203 | 203 | Francis Preston P000514 | rep | VA | 1793-12-02 | 1795-03-03 | Republican | 4 | |||||||||||||
207 | 207 | Robert Rutherford R000548 | rep | VA | 1793-12-02 | 1795-03-03 | Republican | 1 | |||||||||||||
209 | 209 | John Sherburne S000339 | rep | NH | 1793-12-02 | 1795-03-03 | Republican | -1 | |||||||||||||
212 | 212 | Thomas Sprigg S000753 | rep | MD | 1793-12-02 | 1795-03-03 | Republican | 4 | |||||||||||||
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 | |||||||||||||
222 | 222 | James White W000377 | rep | TN | 1793-12-02 | 1795-03-03 | -1 | ||||||||||||||
227 | 227 | Benjamin Goodhue G000286 | rep | MA | 1793-12-02 | 1795-03-03 | Federalist | 1 | |||||||||||||
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 | |||||||||||||
254 | 254 | Joshua Coit C000600 | rep | CT | 1793-12-02 | 1795-03-03 | Federalist | -1 | |||||||||||||
266 | 266 | Carter Harrison H000266 | rep | VA | 1793-12-02 | 1795-03-03 | Anti-Administration | 10 | |||||||||||||
270 | 270 | Henry Latimer L000115 | rep | DE | 1793-12-02 | 1795-03-03 | Federalist | 0 | |||||||||||||
274 | 274 | Matthew Locke L000389 | rep | NC | 1793-12-02 | 1795-03-03 | Republican | 2 | |||||||||||||
296 | 296 | Jeremiah Smith S000563 | rep | NH | 1793-12-02 | 1795-03-03 | Federalist | -1 | |||||||||||||
304 | 304 | William Smith S000633 | rep | SC | 1793-12-02 | 1795-03-03 | Federalist | 1 | |||||||||||||
312 | 312 | John Van Alen V000012 | rep | NY | 1793-12-02 | 1795-03-03 | Federalist | 7 | |||||||||||||
331 | 331 | Gabriel Christie C000382 | rep | MD | 1793-12-02 | 1795-03-03 | Republican | 6 | |||||||||||||
344 | 344 | Jonathan Dayton D000165 | rep | NJ | 1793-12-02 | 1795-03-03 | Federalist | -1 | |||||||||||||
348 | 348 | George Dent D000254 | rep | MD | 1793-12-02 | 1795-03-03 | Federalist | 1 | |||||||||||||
352 | 352 | Samuel Dexter D000296 | rep | MA | 1793-12-02 | 1795-03-03 | Federalist | 1 | |||||||||||||
366 | 366 | Henry Glen G000235 | rep | NY | 1793-12-02 | 1795-03-03 | Federalist | 8 | |||||||||||||
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 | |||||||||||||
404 | 404 | John Nicholas N000084 | rep | VA | 1793-12-02 | 1795-03-03 | Republican | 18 | |||||||||||||
412 | 412 | Josiah Parker P000065 | rep | VA | 1793-12-02 | 1795-03-03 | Federalist | 11 | |||||||||||||
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 | |||||||||||||
450 | 450 | William Hindman H000629 | rep | MD | 1793-12-02 | 1795-03-03 | Federalist | 7 | |||||||||||||
480 | 480 | William Grove G000502 | rep | NC | 1793-12-02 | 1795-03-03 | Federalist | 7 | |||||||||||||
510 | 510 | John Muhlenberg M001066 | rep | PA | 1793-12-02 | 1795-03-03 | -1 | ||||||||||||||
536 | 536 | Uriah Tracy T000348 | rep | CT | 1793-12-02 | 1795-03-03 | Federalist | -1 | |||||||||||||
553 | 553 | Theodorus Bailey B000049 | rep | NY | 1793-12-02 | 1795-03-03 | 5 | ||||||||||||||
562 | 562 | Thomas Claiborne C000406 | rep | VA | 1793-12-02 | 1795-03-03 | Republican | 8 | |||||||||||||
575 | 575 | James Gillespie G000196 | rep | NC | 1793-12-02 | 1795-03-03 | Anti-Administration | 6 | |||||||||||||
586 | 586 | Daniel Hiester H000570 | rep | PA | 1793-12-02 | 1795-03-03 | Republican | -1 | |||||||||||||
614 | 614 | Israel Smith S000557 | rep | VT | 1793-12-02 | 1795-03-03 | Democratic Republican | 1 | |||||||||||||
632 | 632 | Abraham Venable V000083 | rep | VA | 1793-12-02 | 1795-03-03 | Democratic Republican | 7 | |||||||||||||
647 | 647 | Andrew Moore M000891 | rep | VA | 1793-12-02 | 1795-03-03 | Democratic Republican | 2 | |||||||||||||
658 | 658 | Abraham Baldwin B000084 | rep | GA | 1793-12-02 | 1795-03-03 | Democratic Republican | 0 | |||||||||||||
719 | 719 | Aaron Kitchell K000246 | rep | NJ | 1793-12-02 | 1795-03-03 | Democratic Republican | -1 | |||||||||||||
773 | 773 | Peleg Wadsworth W000014 | rep | MA | 1793-12-02 | 1795-03-03 | Federalist | 4 | |||||||||||||
786 | 786 | Joseph Winston W000642 | rep | NC | 1793-12-02 | 1795-03-03 | Republican | 3 | |||||||||||||
809 | 809 | Stephen Bradley B000745 | sen | VT | 1791-10-24 | 1795-03-03 | 3 | ||||||||||||||
846 | 846 | Andrew Gregg G000442 | rep | PA | 1793-12-02 | 1795-03-03 | Democratic Republican | -1 | |||||||||||||
911 | 911 | Philip Van Cortlandt V000022 | rep | NY | 1793-12-02 | 1795-03-03 | Republican | 3 | |||||||||||||
935 | 935 | James Madison M000043 | rep | VA | 1793-12-02 | 1795-03-03 | Republican | 15 | |||||||||||||
984 | 984 | James Hillhouse H000618 | rep | CT | 1793-12-02 | 1795-03-03 | -1 | ||||||||||||||
1028 | 1028 | Francis Malbone M000076 | rep | RI | 1793-12-02 | 1795-03-03 | Federalist | -1 | |||||||||||||
1112 | 1112 | Thomas Blount B000569 | rep | NC | 1793-12-02 | 1795-03-03 | Republican | 9 | |||||||||||||
1156 | 1156 | William Giles G000183 | rep | VA | 1793-12-02 | 1795-03-03 | Republican | 9 | |||||||||||||
1166 | 1166 | Nicholas Gilman G000215 | rep | NH | 1793-12-02 | 1795-03-03 | Democratic Republican | -1 | |||||||||||||
1225 | 1225 | John Smilie S000508 | rep | PA | 1793-12-02 | 1795-03-03 | Republican | -1 | |||||||||||||
1261 | 1261 | Richard Winn W000637 | rep | SC | 1793-12-02 | 1795-03-03 | Republican | 4 | |||||||||||||
1554 | 1554 | William Findley F000124 | rep | PA | 1793-12-02 | 1795-03-03 | Anti-Administration | -1 | |||||||||||||
1783 | 1783 | Robert Harper H000225 | rep | SC | 1793-12-02 | 1795-03-03 | 5 | ||||||||||||||
2051 | 2051 | Rufus King K000212 | sen | NY | 1789-03-04 | 1795-03-03 | 3 | Federalist | |||||||||||||
2287 | 2287 | Anthony New N000058 | rep | VA | 1793-12-02 | 1795-03-03 | Republican | 16 | |||||||||||||
2665 | 2665 | Nathaniel Macon M000034 | rep | NC | 1793-12-02 | 1795-03-03 | Democratic Republican | 5 | |||||||||||||
2957 | 2957 | Samuel Smith S000609 | rep | MD | 1793-12-02 | 1795-03-03 | Democratic Republican | 5 | |||||||||||||
494 | 494 | James Jackson J000017 | sen | GA | 1793-12-02 | 1795-12-31 | 2 | Republican | |||||||||||||
140 | 140 | George Walton W000114 | sen | GA | 1795-11-16 | 1796-02-20 | 2 | Federalist | |||||||||||||
985 | 985 | James Hillhouse H000618 | rep | CT | 1795-12-07 | 1796-05-18 | Federalist | -1 | |||||||||||||
228 | 228 | Benjamin Goodhue G000286 | rep | MA | 1795-06-08 | 1796-06-11 | Federalist | 1 | |||||||||||||
537 | 537 | Uriah Tracy T000348 | rep | CT | 1795-12-07 | 1796-10-13 | Federalist | -1 | |||||||||||||
71 | 71 | Richard Potts P000473 | sen | MD | 1793-01-10 | 1796-10-14 | 1 | Federalist | |||||||||||||
48 | 48 | Moses Robinson R000350 | sen | VT | 1791-10-24 | 1796-10-15 | 1 | Anti-Administration | |||||||||||||
34 | 34 | Aaron Burr B001133 | sen | NY | 1791-10-24 | 1797-03-03 | 1 | Republican | |||||||||||||
35 | 35 | George Cabot C000009 | sen | MA | 1791-10-24 | 1797-03-03 | 1 | Federalist | |||||||||||||
39 | 39 | Oliver Ellsworth E000147 | sen | CT | 1791-10-24 | 1797-03-03 | 1 | Federalist | |||||||||||||
93 | 93 | Frederick Frelinghuysen F000368 | sen | NJ | 1793-12-02 | 1797-03-03 | 2 | Federalist | |||||||||||||
121 | 121 | Caleb Strong S001009 | sen | MA | 1793-12-02 | 1797-03-03 | 2 | Federalist |
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);