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 party
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1552 | 1552 | Rufus Easton E000022 | rep | MO | 1815-12-04 | 1817-03-03 | -1 | ||||||||||||||
1639 | 1639 | William Lattimore L000118 | rep | MS | 1815-12-04 | 1817-03-03 | -1 | ||||||||||||||
1724 | 1724 | Benjamin Stephenson S000862 | rep | IL | 1815-12-04 | 1817-03-03 | -1 | ||||||||||||||
1768 | 1768 | Jonathan Williams W000523 | rep | PA | 1815-12-04 | 1817-03-03 | -1 | ||||||||||||||
1901 | 1901 | Nathaniel Pope P000432 | rep | IL | 1815-12-04 | 1817-03-03 | -1 | ||||||||||||||
2714 | 2714 | John Scott S000176 | rep | MO | 1815-12-04 | 1817-03-03 | -1 | ||||||||||||||
3149 | 3149 | Jonathan Jennings J000097 | rep | IN | 1815-12-04 | 1817-03-03 | -1 | ||||||||||||||
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 | |||||||||||||
1443 | 1443 | Thomas Thompson T000220 | sen | NH | 1814-01-01 | 1817-03-03 | 2 | Federalist | |||||||||||||
1450 | 1450 | Charles Atherton A000324 | rep | NH | 1815-12-04 | 1817-03-03 | Federalist | -1 | |||||||||||||
1456 | 1456 | George Baer B000026 | rep | MD | 1815-12-04 | 1817-03-03 | Federalist | 4 | |||||||||||||
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 | |||||||||||||
1479 | 1479 | Benjamin Brown B000904 | rep | MA | 1815-12-04 | 1817-03-03 | Federalist | 16 | |||||||||||||
1481 | 1481 | Daniel Cady C000014 | rep | NY | 1815-12-04 | 1817-03-03 | Federalist | 14 | |||||||||||||
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 | |||||||||||||
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 | |||||||||||||
1525 | 1525 | Thomas Cooper C000762 | rep | DE | 1815-12-04 | 1817-03-03 | Federalist | 0 | |||||||||||||
1549 | 1549 | John Davenport D000075 | rep | CT | 1815-12-04 | 1817-03-03 | Federalist | -1 | |||||||||||||
1569 | 1569 | William Gaston G000096 | rep | NC | 1815-12-04 | 1817-03-03 | Federalist | 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 | |||||||||||||
1592 | 1592 | Thomas Grosvenor G000498 | rep | NY | 1815-12-04 | 1817-03-03 | Federalist | 5 | |||||||||||||
1596 | 1596 | William Hale H000039 | rep | NH | 1815-12-04 | 1817-03-03 | Federalist | -1 | |||||||||||||
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 | |||||||||||||
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 | |||||||||||||
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 | |||||||||||||
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 | |||||||||||||
1652 | 1652 | John Lovett L000466 | rep | NY | 1815-12-04 | 1817-03-03 | Federalist | 9 | |||||||||||||
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 | |||||||||||||
1667 | 1667 | Hosea Moffitt M000840 | rep | NY | 1815-12-04 | 1817-03-03 | Federalist | 10 | |||||||||||||
1683 | 1683 | John Noyes N000164 | rep | VT | 1815-12-04 | 1817-03-03 | Federalist | 0 | |||||||||||||
1690 | 1690 | Timothy Pickering P000324 | rep | MA | 1815-12-04 | 1817-03-03 | Federalist | 2 | |||||||||||||
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 | |||||||||||||
1722 | 1722 | Asahel Stearns S000821 | rep | MA | 1815-12-04 | 1817-03-03 | Federalist | 4 | |||||||||||||
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 | |||||||||||||
1745 | 1745 | Benjamin Tallmadge T000029 | rep | CT | 1815-12-04 | 1817-03-03 | Federalist | -1 | |||||||||||||
1746 | 1746 | Magnus Tate T000047 | rep | VA | 1815-12-04 | 1817-03-03 | Federalist | 2 | |||||||||||||
1756 | 1756 | Roger Vose V000120 | rep | NH | 1815-12-04 | 1817-03-03 | Federalist | -1 | |||||||||||||
1758 | 1758 | Artemas Ward W000128 | rep | MA | 1815-12-04 | 1817-03-03 | Federalist | 1 | |||||||||||||
1765 | 1765 | Laban Wheaton W000329 | rep | MA | 1815-12-04 | 1817-03-03 | Federalist | 10 | |||||||||||||
1767 | 1767 | Jeduthun Wilcox W000456 | rep | NH | 1815-12-04 | 1817-03-03 | Federalist | -1 | |||||||||||||
1773 | 1773 | John Woods W000725 | rep | PA | 1815-12-04 | 1817-03-03 | Federalist | 14 | |||||||||||||
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 | |||||||||||||
1804 | 1804 | John Boss B000650 | rep | RI | 1815-12-04 | 1817-03-03 | Federalist | -1 | |||||||||||||
1856 | 1856 | John Herbert H000525 | rep | MD | 1815-12-04 | 1817-03-03 | Federalist | 2 | |||||||||||||
1861 | 1861 | Joseph Hopkinson H000784 | rep | PA | 1815-12-04 | 1817-03-03 | Federalist | 1 | |||||||||||||
1876 | 1876 | James Mason M000215 | rep | RI | 1815-12-04 | 1817-03-03 | Federalist | -1 | |||||||||||||
1899 | 1899 | Timothy Pitkin P000368 | rep | CT | 1815-12-04 | 1817-03-03 | Federalist | -1 | |||||||||||||
1904 | 1904 | Thomas Rice R000204 | rep | MA | 1815-12-04 | 1817-03-03 | Federalist | 18 | |||||||||||||
1914 | 1914 | Nathaniel Ruggles R000503 | rep | MA | 1815-12-04 | 1817-03-03 | Federalist | 13 | |||||||||||||
1931 | 1931 | Solomon Strong S001017 | rep | MA | 1815-12-04 | 1817-03-03 | Federalist | 12 | |||||||||||||
1935 | 1935 | Philip Stuart S001036 | rep | MD | 1815-12-04 | 1817-03-03 | Federalist | 1 | |||||||||||||
1960 | 1960 | Benjamin Adams A000030 | rep | MA | 1815-12-04 | 1817-03-03 | Federalist | 11 | |||||||||||||
2088 | 2088 | Jonathan Moseley M001023 | rep | CT | 1815-12-04 | 1817-03-03 | Federalist | -1 | |||||||||||||
2182 | 2182 | Elijah Mills M000774 | rep | MA | 1815-12-04 | 1817-03-03 | Federalist | 5 | |||||||||||||
2269 | 2269 | William Milnor M000786 | rep | PA | 1815-12-04 | 1817-03-03 | Federalist | 1 | |||||||||||||
2694 | 2694 | George Peter P000250 | rep | MD | 1815-12-04 | 1817-03-03 | Federalist | 3 | |||||||||||||
2825 | 2825 | John Culpepper C000976 | rep | NC | 1815-12-04 | 1817-03-03 | Federalist | 7 | |||||||||||||
3497 | 3497 | Jeremiah Nelson N000036 | rep | MA | 1815-12-04 | 1817-03-03 | Federalist | 3 | |||||||||||||
3610 | 3610 | William Baylies B000256 | rep | MA | 1815-12-04 | 1817-03-03 | Federalist | 8 | |||||||||||||
4585 | 4585 | John Reed R000121 | rep | MA | 1815-12-04 | 1817-03-03 | Federalist | 9 | |||||||||||||
4749 | 4749 | Thomas Clayton C000499 | rep | DE | 1815-12-04 | 1817-03-03 | Federalist | 0 | |||||||||||||
4989 | 4989 | John Sergeant S000246 | rep | PA | 1815-12-04 | 1817-03-03 | Federalist | 1 | |||||||||||||
5565 | 5565 | Daniel Webster W000238 | rep | NH | 1815-12-04 | 1817-03-03 | Federalist | -1 | |||||||||||||
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 | |||||||||||||
1435 | 1435 | William Barry B000192 | sen | KY | 1814-01-01 | 1817-03-03 | 2 | Republican | |||||||||||||
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 | |||||||||||||
1453 | 1453 | Daniel Avery A000345 | rep | NY | 1815-12-04 | 1817-03-03 | Republican | 20 | |||||||||||||
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 | |||||||||||||
1478 | 1478 | Micah Brooks B000883 | rep | NY | 1815-12-04 | 1817-03-03 | Republican | 21 | |||||||||||||
1480 | 1480 | Thomas Burnside B001132 | rep | PA | 1815-12-04 | 1817-03-03 | Republican | 9 | |||||||||||||
1483 | 1483 | James Caldwell C000033 | rep | OH | 1815-12-04 | 1817-03-03 | Republican | 4 | |||||||||||||
1496 | 1496 | John Chappell C000320 | rep | SC | 1815-12-04 | 1817-03-03 | Republican | 4 | |||||||||||||
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 | |||||||||||||
1529 | 1529 | William Crawford C000894 | rep | PA | 1815-12-04 | 1817-03-03 | Republican | 5 |
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);