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
This data as json, copyable, CSV (advanced)
Suggested facets: type, start, 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1182 | 1182 | Jeremiah Howell H000865 | sen | RI | 1811-11-04 | 1817-03-03 | 2 | Republican | |||||||||||||
1244 | 1244 | James Turner T000423 | sen | NC | 1811-11-04 | 1817-03-03 | 2 | Republican | |||||||||||||
1254 | 1254 | Joseph Varnum V000074 | sen | MA | 1811-11-04 | 1817-03-03 | 2 | Democratic Republican | |||||||||||||
1424 | 1424 | William Wells W000287 | sen | DE | 1813-05-24 | 1817-03-03 | 2 | Federalist | |||||||||||||
1435 | 1435 | William Barry B000192 | sen | KY | 1814-01-01 | 1817-03-03 | 2 | Republican | |||||||||||||
1443 | 1443 | Thomas Thompson T000220 | sen | NH | 1814-01-01 | 1817-03-03 | 2 | Federalist | |||||||||||||
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 | |||||||||||||
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 | |||||||||||||
1466 | 1466 | David Bard B000137 | rep | PA | 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 | |||||||||||||
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 | |||||||||||||
1480 | 1480 | Thomas Burnside B001132 | rep | PA | 1815-12-04 | 1817-03-03 | Republican | 9 | |||||||||||||
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 | |||||||||||||
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 | |||||||||||||
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 | |||||||||||||
1510 | 1510 | Matthew Clay C000487 | rep | VA | 1815-12-04 | 1817-03-03 | Republican | -1 | |||||||||||||
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 | |||||||||||||
1523 | 1523 | Samuel Conner C000692 | rep | MA | 1815-12-04 | 1817-03-03 | Republican | 19 | |||||||||||||
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 | |||||||||||||
1530 | 1530 | Henry Crocheron C000914 | rep | NY | 1815-12-04 | 1817-03-03 | Republican | 1 | |||||||||||||
1549 | 1549 | John Davenport D000075 | rep | CT | 1815-12-04 | 1817-03-03 | Federalist | -1 | |||||||||||||
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 | ||||||||||||||
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 | |||||||||||||
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 | |||||||||||||
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 | |||||||||||||
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 | |||||||||||||
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 | |||||||||||||
1619 | 1619 | Jared Irwin I000042 | rep | PA | 1815-12-04 | 1817-03-03 | Republican | 10 | |||||||||||||
1625 | 1625 | John Jackson J000021 | rep | VA | 1815-12-04 | 1817-03-03 | Republican | 1 | |||||||||||||
1626 | 1626 | Luther Jewett J000107 | rep | VT | 1815-12-04 | 1817-03-03 | Federalist | 0 | |||||||||||||
1628 | 1628 | Moss Kent K000126 | rep | NY | 1815-12-04 | 1817-03-03 | Federalist | 18 | |||||||||||||
1630 | 1630 | John Kerr K000136 | rep | VA | 1815-12-04 | 1817-03-03 | Republican | 15 | |||||||||||||
1632 | 1632 | James Kilbourne K000169 | rep | OH | 1815-12-04 | 1817-03-03 | Republican | 5 | |||||||||||||
1634 | 1634 | Cyrus King K000197 | rep | MA | 1815-12-04 | 1817-03-03 | Federalist | 14 | |||||||||||||
1635 | 1635 | Chauncey Langdon L000066 | rep | VT | 1815-12-04 | 1817-03-03 | Federalist | 0 | |||||||||||||
1639 | 1639 | William Lattimore L000118 | rep | MS | 1815-12-04 | 1817-03-03 | -1 | ||||||||||||||
1642 | 1642 | Lyman Law L000126 | rep | CT | 1815-12-04 | 1817-03-03 | Federalist | -1 | |||||||||||||
1649 | 1649 | Joseph Lewis L000290 | rep | VA | 1815-12-04 | 1817-03-03 | Federalist | 8 | |||||||||||||
1650 | 1650 | William Love L000460 | rep | NC | 1815-12-04 | 1817-03-03 | Republican | 10 | |||||||||||||
1652 | 1652 | John Lovett L000466 | rep | NY | 1815-12-04 | 1817-03-03 | Federalist | 9 | |||||||||||||
1656 | 1656 | Aaron Lyle L000524 | rep | PA | 1815-12-04 | 1817-03-03 | Republican | 12 | |||||||||||||
1657 | 1657 | Asa Lyon L000539 | rep | VT | 1815-12-04 | 1817-03-03 | Federalist | 0 | |||||||||||||
1658 | 1658 | Charles Marsh M000146 | rep | VT | 1815-12-04 | 1817-03-03 | Federalist | 0 | |||||||||||||
1659 | 1659 | William Mayrant M000288 | rep | SC | 1815-12-04 | 1817-03-03 | Republican | 9 | |||||||||||||
1663 | 1663 | Samuel McKee M000496 | rep | KY | 1815-12-04 | 1817-03-03 | Republican | 7 | |||||||||||||
1665 | 1665 | John McLean M000549 | rep | OH | 1815-12-04 | 1817-03-03 | Republican | 1 | |||||||||||||
1667 | 1667 | Hosea Moffitt M000840 | rep | NY | 1815-12-04 | 1817-03-03 | Federalist | 10 | |||||||||||||
1673 | 1673 | Nicholas Moore M000909 | rep | MD | 1815-12-04 | 1817-03-03 | Republican | -1 | |||||||||||||
1680 | 1680 | Thomas Moore M000919 | rep | SC | 1815-12-04 | 1817-03-03 | Republican | 8 | |||||||||||||
1682 | 1682 | William Murfree M001084 | rep | NC | 1815-12-04 | 1817-03-03 | Republican | 1 | |||||||||||||
1683 | 1683 | John Noyes N000164 | rep | VT | 1815-12-04 | 1817-03-03 | Federalist | 0 | |||||||||||||
1686 | 1686 | Stephen Ormsby O000100 | rep | KY | 1815-12-04 | 1817-03-03 | Republican | 8 | |||||||||||||
1690 | 1690 | Timothy Pickering P000324 | rep | MA | 1815-12-04 | 1817-03-03 | Federalist | 2 | |||||||||||||
1693 | 1693 | William Piper P000363 | rep | PA | 1815-12-04 | 1817-03-03 | Republican | 8 | |||||||||||||
1696 | 1696 | Peter Porter P000446 | rep | NY | 1815-12-04 | 1817-03-03 | Republican | 21 | |||||||||||||
1697 | 1697 | Samuel Powell P000484 | rep | TN | 1815-12-04 | 1817-03-03 | Republican | 1 | |||||||||||||
1698 | 1698 | Abraham Schenck S000115 | rep | NY | 1815-12-04 | 1817-03-03 | Republican | 4 | |||||||||||||
1702 | 1702 | John Sevier S000257 | rep | TN | 1815-12-04 | 1817-03-03 | Republican | -1 | |||||||||||||
1704 | 1704 | Solomon Sharp S000295 | rep | KY | 1815-12-04 | 1817-03-03 | Republican | 6 | |||||||||||||
1708 | 1708 | Daniel Sheffey S000317 | rep | VA | 1815-12-04 | 1817-03-03 | Federalist | 6 | |||||||||||||
1709 | 1709 | Thomas Smith S000617 | rep | PA | 1815-12-04 | 1817-03-03 | Federalist | 1 | |||||||||||||
1711 | 1711 | William Smith S000638 | rep | NY | 1815-12-04 | 1817-03-03 | Federalist | -1 | |||||||||||||
1721 | 1721 | Richard Stanford S000794 | rep | NC | 1815-12-04 | 1817-03-03 | Republican | 8 | |||||||||||||
1722 | 1722 | Asahel Stearns S000821 | rep | MA | 1815-12-04 | 1817-03-03 | Federalist | 4 | |||||||||||||
1724 | 1724 | Benjamin Stephenson S000862 | rep | IL | 1815-12-04 | 1817-03-03 | -1 | ||||||||||||||
1730 | 1730 | Lewis Sturges S001048 | rep | CT | 1815-12-04 | 1817-03-03 | Federalist | -1 | |||||||||||||
1737 | 1737 | Samuel Taggart T000012 | rep | MA | 1815-12-04 | 1817-03-03 | Federalist | 6 |
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);