legislator_terms
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
225 rows where "end" is on date 1817-03-03 sorted by legislator_id
This data as json, copyable, CSV (advanced)
Suggested facets: state, class, 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1960 | 1960 | Benjamin Adams A000030 | rep | MA | 1815-12-04 | 1817-03-03 | Federalist | 11 | |||||||||||||
3592 | 3592 | John Adams A000038 | rep | NY | 1815-12-04 | 1817-03-03 | Republican | 8 | |||||||||||||
1447 | 1447 | Asa Adgate A000056 | rep | NY | 1815-12-04 | 1817-03-03 | Republican | 12 | |||||||||||||
1449 | 1449 | John Alexander A000096 | rep | OH | 1815-12-04 | 1817-03-03 | Republican | 2 | |||||||||||||
1968 | 1968 | Stevenson Archer A000273 | rep | MD | 1815-12-04 | 1817-03-03 | Republican | 6 | |||||||||||||
1450 | 1450 | Charles Atherton A000324 | rep | NH | 1815-12-04 | 1817-03-03 | Federalist | -1 | |||||||||||||
1453 | 1453 | Daniel Avery A000345 | rep | NY | 1815-12-04 | 1817-03-03 | Republican | 20 | |||||||||||||
1456 | 1456 | George Baer B000026 | rep | MD | 1815-12-04 | 1817-03-03 | Federalist | 4 | |||||||||||||
1457 | 1457 | Ezra Baker B000060 | rep | NJ | 1815-12-04 | 1817-03-03 | Republican | -1 | |||||||||||||
3040 | 3040 | Philip Barbour B000131 | rep | VA | 1815-12-04 | 1817-03-03 | Republican | 11 | |||||||||||||
1466 | 1466 | David Bard B000137 | rep | PA | 1815-12-04 | 1817-03-03 | Republican | -1 | |||||||||||||
1435 | 1435 | William Barry B000192 | sen | KY | 1814-01-01 | 1817-03-03 | 2 | Republican | |||||||||||||
2785 | 2785 | Burwell Bassett B000224 | rep | VA | 1815-12-04 | 1817-03-03 | Republican | 13 | |||||||||||||
2744 | 2744 | Ephraim Bateman B000228 | rep | NJ | 1815-12-04 | 1817-03-03 | Republican | -1 | |||||||||||||
3610 | 3610 | William Baylies B000256 | rep | MA | 1815-12-04 | 1817-03-03 | Federalist | 8 | |||||||||||||
1800 | 1800 | Benjamin Bennet B000368 | rep | NJ | 1815-12-04 | 1817-03-03 | Republican | -1 | |||||||||||||
1467 | 1467 | Samuel Betts B000427 | rep | NY | 1815-12-04 | 1817-03-03 | Republican | 7 | |||||||||||||
1468 | 1468 | James Birdsall B000482 | rep | NY | 1815-12-04 | 1817-03-03 | Republican | 15 | |||||||||||||
4695 | 4695 | Victory Birdseye B000484 | rep | NY | 1815-12-04 | 1817-03-03 | Republican | 19 | |||||||||||||
1802 | 1802 | William Blount B000571 | rep | TN | 1815-12-04 | 1817-03-03 | Republican | 2 | |||||||||||||
1804 | 1804 | John Boss B000650 | rep | RI | 1815-12-04 | 1817-03-03 | Federalist | -1 | |||||||||||||
1470 | 1470 | George Bradbury B000733 | rep | MA | 1815-12-04 | 1817-03-03 | Federalist | 15 | |||||||||||||
1474 | 1474 | James Breckinridge B000785 | rep | VA | 1815-12-04 | 1817-03-03 | Federalist | 5 | |||||||||||||
1477 | 1477 | Elijah Brigham B000833 | rep | MA | 1815-12-04 | 1817-03-03 | Federalist | 11 | |||||||||||||
1478 | 1478 | Micah Brooks B000883 | rep | NY | 1815-12-04 | 1817-03-03 | Republican | 21 | |||||||||||||
1479 | 1479 | Benjamin Brown B000904 | rep | MA | 1815-12-04 | 1817-03-03 | Federalist | 16 | |||||||||||||
1976 | 1976 | James Brown B000921 | sen | LA | 1813-05-24 | 1817-03-03 | 2 | Republican | |||||||||||||
1806 | 1806 | Joseph Bryan B000990 | rep | NC | 1815-12-04 | 1817-03-03 | Republican | 2 | |||||||||||||
1480 | 1480 | Thomas Burnside B001132 | rep | PA | 1815-12-04 | 1817-03-03 | Republican | 9 | |||||||||||||
1986 | 1986 | William Burwell B001160 | rep | VA | 1815-12-04 | 1817-03-03 | Republican | 14 | |||||||||||||
1481 | 1481 | Daniel Cady C000014 | rep | NY | 1815-12-04 | 1817-03-03 | Federalist | 14 | |||||||||||||
1483 | 1483 | James Caldwell C000033 | rep | OH | 1815-12-04 | 1817-03-03 | Republican | 4 | |||||||||||||
5635 | 5635 | John Calhoun C000044 | rep | SC | 1815-12-04 | 1817-03-03 | Republican | 6 | |||||||||||||
2216 | 2216 | Newton Cannon C000123 | rep | TN | 1815-12-04 | 1817-03-03 | Republican | 5 | |||||||||||||
1489 | 1489 | James Carr C000176 | rep | MA | 1815-12-04 | 1817-03-03 | Federalist | 17 | |||||||||||||
1494 | 1494 | Epaphroditus Champion C000288 | rep | CT | 1815-12-04 | 1817-03-03 | Federalist | -1 | |||||||||||||
1496 | 1496 | John Chappell C000320 | rep | SC | 1815-12-04 | 1817-03-03 | Republican | 4 | |||||||||||||
1497 | 1497 | Daniel Chipman C000366 | rep | VT | 1815-12-04 | 1817-03-03 | Federalist | 0 | |||||||||||||
1499 | 1499 | Bradbury Cilley C000394 | rep | NH | 1815-12-04 | 1817-03-03 | Federalist | -1 | |||||||||||||
3063 | 3063 | James Clark C000436 | rep | KY | 1815-12-04 | 1817-03-03 | Republican | 1 | |||||||||||||
1500 | 1500 | James Clark C000438 | rep | NC | 1815-12-04 | 1817-03-03 | Republican | 3 | |||||||||||||
1501 | 1501 | Archibald Clarke C000456 | rep | NY | 1815-12-04 | 1817-03-03 | Republican | 21 | |||||||||||||
5932 | 5932 | Henry Clay C000482 | rep | KY | 1815-12-04 | 1817-03-03 | Republican | 2 | |||||||||||||
1510 | 1510 | Matthew Clay C000487 | rep | VA | 1815-12-04 | 1817-03-03 | Republican | -1 | |||||||||||||
4749 | 4749 | Thomas Clayton C000499 | rep | DE | 1815-12-04 | 1817-03-03 | Federalist | 0 | |||||||||||||
1512 | 1512 | David Clendenin C000510 | rep | OH | 1815-12-04 | 1817-03-03 | Republican | 6 | |||||||||||||
1522 | 1522 | John Clopton C000531 | rep | VA | 1815-12-04 | 1817-03-03 | Republican | 23 | |||||||||||||
1815 | 1815 | Oliver Comstock C000664 | rep | NY | 1815-12-04 | 1817-03-03 | Republican | 20 | |||||||||||||
3340 | 3340 | Lewis Condict C000668 | rep | NJ | 1815-12-04 | 1817-03-03 | Republican | -1 | |||||||||||||
2000 | 2000 | John Condit C000671 | sen | NJ | 1811-11-04 | 1817-03-03 | 2 | Republican | |||||||||||||
1523 | 1523 | Samuel Conner C000692 | rep | MA | 1815-12-04 | 1817-03-03 | Republican | 19 | |||||||||||||
1817 | 1817 | Zadock Cook C000728 | rep | GA | 1815-12-04 | 1817-03-03 | Republican | -1 | |||||||||||||
1525 | 1525 | Thomas Cooper C000762 | rep | DE | 1815-12-04 | 1817-03-03 | Federalist | 0 | |||||||||||||
1529 | 1529 | William Crawford C000894 | rep | PA | 1815-12-04 | 1817-03-03 | Republican | 5 | |||||||||||||
3355 | 3355 | William Creighton C000902 | rep | OH | 1815-12-04 | 1817-03-03 | Republican | 3 | |||||||||||||
1530 | 1530 | Henry Crocheron C000914 | rep | NY | 1815-12-04 | 1817-03-03 | Republican | 1 | |||||||||||||
2825 | 2825 | John Culpepper C000976 | rep | NC | 1815-12-04 | 1817-03-03 | Federalist | 7 | |||||||||||||
4184 | 4184 | Alfred Cuthbert C001023 | rep | GA | 1815-12-04 | 1817-03-03 | Republican | -1 | |||||||||||||
2226 | 2226 | William Darlington D000059 | rep | PA | 1815-12-04 | 1817-03-03 | Republican | 2 | |||||||||||||
1549 | 1549 | John Davenport D000075 | rep | CT | 1815-12-04 | 1817-03-03 | Federalist | -1 | |||||||||||||
1826 | 1826 | Joseph Desha D000271 | rep | KY | 1815-12-04 | 1817-03-03 | Republican | 4 | |||||||||||||
1550 | 1550 | Samuel Dickens D000306 | rep | NC | 1815-12-04 | 1817-03-03 | Republican | 8 | |||||||||||||
1552 | 1552 | Rufus Easton E000022 | rep | MO | 1815-12-04 | 1817-03-03 | -1 | ||||||||||||||
2590 | 2590 | Weldon Edwards E000083 | rep | NC | 1815-12-04 | 1817-03-03 | Republican | 6 | |||||||||||||
1563 | 1563 | William Findley F000124 | rep | PA | 1815-12-04 | 1817-03-03 | Republican | 11 | |||||||||||||
1566 | 1566 | Jonathan Fisk F000155 | rep | NY | 1815-12-04 | 1817-03-03 | Republican | -1 | |||||||||||||
1567 | 1567 | Thomas Fletcher F000204 | rep | KY | 1815-12-04 | 1817-03-03 | Republican | 1 | |||||||||||||
1841 | 1841 | Daniel Forney F000278 | rep | NC | 1815-12-04 | 1817-03-03 | Republican | 11 | |||||||||||||
3384 | 3384 | John Forsyth F000284 | rep | GA | 1815-12-04 | 1817-03-03 | Republican | -1 | |||||||||||||
1569 | 1569 | William Gaston G000096 | rep | NC | 1815-12-04 | 1817-03-03 | Federalist | 4 | |||||||||||||
1574 | 1574 | Thomas Gholson G000150 | rep | VA | 1815-12-04 | 1817-03-03 | Republican | 18 | |||||||||||||
1576 | 1576 | Hugh Glasgow G000231 | rep | PA | 1815-12-04 | 1817-03-03 | Republican | 4 | |||||||||||||
1579 | 1579 | Thomas Gold G000257 | rep | NY | 1815-12-04 | 1817-03-03 | Federalist | 16 | |||||||||||||
1585 | 1585 | Charles Goldsborough G000261 | rep | MD | 1815-12-04 | 1817-03-03 | Federalist | 8 | |||||||||||||
1851 | 1851 | Peterson Goodwyn G000306 | rep | VA | 1815-12-04 | 1817-03-03 | Republican | 19 | |||||||||||||
1587 | 1587 | Christopher Gore G000322 | sen | MA | 1815-12-04 | 1817-03-03 | 1 | Federalist | |||||||||||||
1589 | 1589 | Isaac Griffin G000461 | rep | PA | 1815-12-04 | 1817-03-03 | Republican | 13 | |||||||||||||
1592 | 1592 | Thomas Grosvenor G000498 | rep | NY | 1815-12-04 | 1817-03-03 | Federalist | 5 | |||||||||||||
1593 | 1593 | John Hahn H000018 | rep | PA | 1815-12-04 | 1817-03-03 | Republican | 2 | |||||||||||||
1596 | 1596 | William Hale H000039 | rep | NH | 1815-12-04 | 1817-03-03 | Federalist | -1 | |||||||||||||
1599 | 1599 | Bolling Hall H000045 | rep | GA | 1815-12-04 | 1817-03-03 | Republican | -1 | |||||||||||||
1600 | 1600 | Jabez Hammond H000127 | rep | NY | 1815-12-04 | 1817-03-03 | Republican | 15 | |||||||||||||
3919 | 3919 | Benjamin Hardin H000184 | rep | KY | 1815-12-04 | 1817-03-03 | Republican | 10 | |||||||||||||
1782 | 1782 | Martin Hardin H000186 | sen | KY | 1816-01-01 | 1817-03-03 | 2 | Federalist | |||||||||||||
1787 | 1787 | Robert Harper H000225 | sen | MD | 1816-01-01 | 1817-03-03 | 1 | Federalist | |||||||||||||
4650 | 4650 | William Harrison H000279 | rep | OH | 1815-12-04 | 1817-03-03 | Republican | 1 | |||||||||||||
1603 | 1603 | Aylett Hawes H000361 | rep | VA | 1815-12-04 | 1817-03-03 | Republican | 10 | |||||||||||||
1604 | 1604 | Bennett Henderson H000476 | rep | TN | 1815-12-04 | 1817-03-03 | Republican | 4 | |||||||||||||
3399 | 3399 | William Hendricks H000494 | rep | IN | 1815-12-04 | 1817-03-03 | Republican | 1 | |||||||||||||
1856 | 1856 | John Herbert H000525 | rep | MD | 1815-12-04 | 1817-03-03 | Federalist | 2 | |||||||||||||
2041 | 2041 | Joseph Hiester H000574 | rep | PA | 1815-12-04 | 1817-03-03 | Republican | 7 | |||||||||||||
2427 | 2427 | Charles Hooks H000761 | rep | NC | 1815-12-04 | 1817-03-03 | Republican | 5 | |||||||||||||
1861 | 1861 | Joseph Hopkinson H000784 | rep | PA | 1815-12-04 | 1817-03-03 | Federalist | 1 | |||||||||||||
1182 | 1182 | Jeremiah Howell H000865 | sen | RI | 1811-11-04 | 1817-03-03 | 2 | Republican | |||||||||||||
1610 | 1610 | Benjamin Huger H000915 | rep | SC | 1815-12-04 | 1817-03-03 | Federalist | 3 | |||||||||||||
1612 | 1612 | John Hulbert H000935 | rep | MA | 1815-12-04 | 1817-03-03 | Federalist | 7 | |||||||||||||
1615 | 1615 | John Hungerford H000967 | rep | VA | 1815-12-04 | 1817-03-03 | Republican | 9 | |||||||||||||
3138 | 3138 | Samuel Ingham I000022 | rep | PA | 1815-12-04 | 1817-03-03 | Republican | 6 | |||||||||||||
1867 | 1867 | William Irving I000038 | rep | NY | 1815-12-04 | 1817-03-03 | Republican | 2 | |||||||||||||
1619 | 1619 | Jared Irwin I000042 | rep | PA | 1815-12-04 | 1817-03-03 | Republican | 10 |
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);