legislator_terms
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
225 rows where "start" is on date 1815-12-04 sorted by state
This data as json, copyable, CSV (advanced)
Suggested facets: state, end, party, district, end (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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1494 | 1494 | Epaphroditus Champion C000288 | rep | CT | 1815-12-04 | 1817-03-03 | Federalist | -1 | |||||||||||||
1540 | 1540 | Samuel Dana D000024 | sen | CT | 1815-12-04 | 1821-03-03 | 1 | Federalist | |||||||||||||
1549 | 1549 | John Davenport D000075 | rep | CT | 1815-12-04 | 1817-03-03 | Federalist | -1 | |||||||||||||
1642 | 1642 | Lyman Law L000126 | rep | CT | 1815-12-04 | 1817-03-03 | Federalist | -1 | |||||||||||||
1730 | 1730 | Lewis Sturges S001048 | rep | CT | 1815-12-04 | 1817-03-03 | Federalist | -1 | |||||||||||||
1745 | 1745 | Benjamin Tallmadge T000029 | rep | CT | 1815-12-04 | 1817-03-03 | Federalist | -1 | |||||||||||||
1899 | 1899 | Timothy Pitkin P000368 | rep | CT | 1815-12-04 | 1817-03-03 | Federalist | -1 | |||||||||||||
2088 | 2088 | Jonathan Moseley M001023 | rep | CT | 1815-12-04 | 1817-03-03 | Federalist | -1 | |||||||||||||
1525 | 1525 | Thomas Cooper C000762 | rep | DE | 1815-12-04 | 1817-03-03 | Federalist | 0 | |||||||||||||
1606 | 1606 | Outerbridge Horsey H000795 | sen | DE | 1815-12-04 | 1821-03-03 | 1 | Federalist | |||||||||||||
4749 | 4749 | Thomas Clayton C000499 | rep | DE | 1815-12-04 | 1817-03-03 | Federalist | 0 | |||||||||||||
1599 | 1599 | Bolling Hall H000045 | rep | GA | 1815-12-04 | 1817-03-03 | Republican | -1 | |||||||||||||
1750 | 1750 | Thomas Telfair T000115 | rep | GA | 1815-12-04 | 1817-03-03 | Republican | -1 | |||||||||||||
1817 | 1817 | Zadock Cook C000728 | rep | GA | 1815-12-04 | 1817-03-03 | Republican | -1 | |||||||||||||
3384 | 3384 | John Forsyth F000284 | rep | GA | 1815-12-04 | 1817-03-03 | Republican | -1 | |||||||||||||
3819 | 3819 | Richard Wilde W000460 | rep | GA | 1815-12-04 | 1817-03-03 | Republican | -1 | |||||||||||||
4184 | 4184 | Alfred Cuthbert C001023 | rep | GA | 1815-12-04 | 1817-03-03 | Republican | -1 | |||||||||||||
4263 | 4263 | Wilson Lumpkin L000512 | rep | GA | 1815-12-04 | 1817-03-03 | Republican | -1 | |||||||||||||
1724 | 1724 | Benjamin Stephenson S000862 | rep | IL | 1815-12-04 | 1817-03-03 | -1 | ||||||||||||||
1901 | 1901 | Nathaniel Pope P000432 | rep | IL | 1815-12-04 | 1817-03-03 | -1 | ||||||||||||||
3149 | 3149 | Jonathan Jennings J000097 | rep | IN | 1815-12-04 | 1817-03-03 | -1 | ||||||||||||||
3399 | 3399 | William Hendricks H000494 | rep | IN | 1815-12-04 | 1817-03-03 | Republican | 1 | |||||||||||||
1567 | 1567 | Thomas Fletcher F000204 | rep | KY | 1815-12-04 | 1817-03-03 | Republican | 1 | |||||||||||||
1663 | 1663 | Samuel McKee M000496 | rep | KY | 1815-12-04 | 1817-03-03 | Republican | 7 | |||||||||||||
1686 | 1686 | Stephen Ormsby O000100 | rep | KY | 1815-12-04 | 1817-03-03 | Republican | 8 | |||||||||||||
1704 | 1704 | Solomon Sharp S000295 | rep | KY | 1815-12-04 | 1817-03-03 | Republican | 6 | |||||||||||||
1747 | 1747 | Micah Taul T000054 | rep | KY | 1815-12-04 | 1817-03-03 | Republican | 9 | |||||||||||||
1826 | 1826 | Joseph Desha D000271 | rep | KY | 1815-12-04 | 1817-03-03 | Republican | 4 | |||||||||||||
2074 | 2074 | Alney McLean M000544 | rep | KY | 1815-12-04 | 1817-03-03 | Republican | 5 | |||||||||||||
2186 | 2186 | Isham Talbot T000017 | sen | KY | 1815-12-04 | 1819-03-03 | 3 | Republican | |||||||||||||
3063 | 3063 | James Clark C000436 | rep | KY | 1815-12-04 | 1817-03-03 | Republican | 1 | |||||||||||||
3919 | 3919 | Benjamin Hardin H000184 | rep | KY | 1815-12-04 | 1817-03-03 | Republican | 10 | |||||||||||||
3959 | 3959 | Richard Johnson J000170 | rep | KY | 1815-12-04 | 1817-03-03 | Republican | 3 | |||||||||||||
5932 | 5932 | Henry Clay C000482 | rep | KY | 1815-12-04 | 1817-03-03 | Republican | 2 | |||||||||||||
1908 | 1908 | Thomas Robertson R000326 | rep | LA | 1815-12-04 | 1817-03-03 | Republican | 1 | |||||||||||||
1470 | 1470 | George Bradbury B000733 | rep | MA | 1815-12-04 | 1817-03-03 | Federalist | 15 | |||||||||||||
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 | |||||||||||||
1489 | 1489 | James Carr C000176 | rep | MA | 1815-12-04 | 1817-03-03 | Federalist | 17 | |||||||||||||
1523 | 1523 | Samuel Conner C000692 | rep | MA | 1815-12-04 | 1817-03-03 | Republican | 19 | |||||||||||||
1587 | 1587 | Christopher Gore G000322 | sen | MA | 1815-12-04 | 1817-03-03 | 1 | Federalist | |||||||||||||
1612 | 1612 | John Hulbert H000935 | rep | MA | 1815-12-04 | 1817-03-03 | Federalist | 7 | |||||||||||||
1634 | 1634 | Cyrus King K000197 | rep | MA | 1815-12-04 | 1817-03-03 | Federalist | 14 | |||||||||||||
1690 | 1690 | Timothy Pickering P000324 | rep | MA | 1815-12-04 | 1817-03-03 | Federalist | 2 | |||||||||||||
1722 | 1722 | Asahel Stearns S000821 | rep | MA | 1815-12-04 | 1817-03-03 | Federalist | 4 | |||||||||||||
1737 | 1737 | Samuel Taggart T000012 | rep | MA | 1815-12-04 | 1817-03-03 | Federalist | 6 | |||||||||||||
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 | |||||||||||||
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 | |||||||||||||
1960 | 1960 | Benjamin Adams A000030 | rep | MA | 1815-12-04 | 1817-03-03 | Federalist | 11 | |||||||||||||
2182 | 2182 | Elijah Mills M000774 | rep | MA | 1815-12-04 | 1817-03-03 | Federalist | 5 | |||||||||||||
2928 | 2928 | Albion Parris P000079 | rep | MA | 1815-12-04 | 1817-03-03 | Republican | 20 | |||||||||||||
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 | |||||||||||||
1456 | 1456 | George Baer B000026 | rep | MD | 1815-12-04 | 1817-03-03 | Federalist | 4 | |||||||||||||
1585 | 1585 | Charles Goldsborough G000261 | rep | MD | 1815-12-04 | 1817-03-03 | Federalist | 8 | |||||||||||||
1673 | 1673 | Nicholas Moore M000909 | rep | MD | 1815-12-04 | 1817-03-03 | Republican | -1 | |||||||||||||
1780 | 1780 | Alexander Hanson H000176 | rep | MD | 1815-12-04 | 1816-12-20 | Federalist | 3 | |||||||||||||
1856 | 1856 | John Herbert H000525 | rep | MD | 1815-12-04 | 1817-03-03 | Federalist | 2 | |||||||||||||
1935 | 1935 | Philip Stuart S001036 | rep | MD | 1815-12-04 | 1817-03-03 | Federalist | 1 | |||||||||||||
1968 | 1968 | Stevenson Archer A000273 | rep | MD | 1815-12-04 | 1817-03-03 | Republican | 6 | |||||||||||||
2302 | 2302 | William Pinkney P000362 | rep | MD | 1815-12-04 | 1817-03-03 | Republican | 5 | |||||||||||||
2357 | 2357 | Robert Wright W000768 | rep | MD | 1815-12-04 | 1817-03-03 | Republican | 7 | |||||||||||||
2694 | 2694 | George Peter P000250 | rep | MD | 1815-12-04 | 1817-03-03 | Federalist | 3 | |||||||||||||
2871 | 2871 | Peter Little L000354 | rep | MD | 1815-12-04 | 1817-03-03 | Republican | 5 | |||||||||||||
2964 | 2964 | Samuel Smith S000609 | rep | MD | 1815-12-04 | 1817-03-03 | Republican | 5 | |||||||||||||
1552 | 1552 | Rufus Easton E000022 | rep | MO | 1815-12-04 | 1817-03-03 | -1 | ||||||||||||||
2714 | 2714 | John Scott S000176 | rep | MO | 1815-12-04 | 1817-03-03 | -1 | ||||||||||||||
1639 | 1639 | William Lattimore L000118 | rep | MS | 1815-12-04 | 1817-03-03 | -1 | ||||||||||||||
1500 | 1500 | James Clark C000438 | rep | NC | 1815-12-04 | 1817-03-03 | Republican | 3 | |||||||||||||
1550 | 1550 | Samuel Dickens D000306 | rep | NC | 1815-12-04 | 1817-03-03 | Republican | 8 | |||||||||||||
1569 | 1569 | William Gaston G000096 | rep | NC | 1815-12-04 | 1817-03-03 | Federalist | 4 | |||||||||||||
1650 | 1650 | William Love L000460 | rep | NC | 1815-12-04 | 1817-03-03 | Republican | 10 | |||||||||||||
1682 | 1682 | William Murfree M001084 | rep | NC | 1815-12-04 | 1817-03-03 | Republican | 1 | |||||||||||||
1721 | 1721 | Richard Stanford S000794 | rep | NC | 1815-12-04 | 1817-03-03 | Republican | 8 | |||||||||||||
1776 | 1776 | Bartlett Yancey Y000001 | rep | NC | 1815-12-04 | 1817-03-03 | Republican | 9 | |||||||||||||
1806 | 1806 | Joseph Bryan B000990 | rep | NC | 1815-12-04 | 1817-03-03 | Republican | 2 | |||||||||||||
1841 | 1841 | Daniel Forney F000278 | rep | NC | 1815-12-04 | 1817-03-03 | Republican | 11 | |||||||||||||
2427 | 2427 | Charles Hooks H000761 | rep | NC | 1815-12-04 | 1817-03-03 | Republican | 5 | |||||||||||||
2590 | 2590 | Weldon Edwards E000083 | rep | NC | 1815-12-04 | 1817-03-03 | Republican | 6 | |||||||||||||
2676 | 2676 | Nathaniel Macon M000034 | rep | NC | 1815-12-04 | 1815-12-13 | Republican | 6 | |||||||||||||
2753 | 2753 | Israel Pickens P000322 | rep | NC | 1815-12-04 | 1817-03-03 | Republican | 12 | |||||||||||||
2825 | 2825 | John Culpepper C000976 | rep | NC | 1815-12-04 | 1817-03-03 | Federalist | 7 | |||||||||||||
5070 | 5070 | Lewis Williams W000527 | rep | NC | 1815-12-04 | 1817-03-03 | Republican | 13 | |||||||||||||
5872 | 5872 | William King K000217 | rep | NC | 1815-12-04 | 1816-11-04 | Republican | 5 | |||||||||||||
1450 | 1450 | Charles Atherton A000324 | rep | NH | 1815-12-04 | 1817-03-03 | Federalist | -1 | |||||||||||||
1499 | 1499 | Bradbury Cilley C000394 | rep | NH | 1815-12-04 | 1817-03-03 | Federalist | -1 | |||||||||||||
1596 | 1596 | William Hale H000039 | rep | NH | 1815-12-04 | 1817-03-03 | Federalist | -1 | |||||||||||||
1756 | 1756 | Roger Vose V000120 | rep | NH | 1815-12-04 | 1817-03-03 | Federalist | -1 | |||||||||||||
1767 | 1767 | Jeduthun Wilcox W000456 | rep | NH | 1815-12-04 | 1817-03-03 | Federalist | -1 | |||||||||||||
5565 | 5565 | Daniel Webster W000238 | rep | NH | 1815-12-04 | 1817-03-03 | Federalist | -1 | |||||||||||||
1457 | 1457 | Ezra Baker B000060 | rep | NJ | 1815-12-04 | 1817-03-03 | Republican | -1 | |||||||||||||
1761 | 1761 | Thomas Ward W000141 | rep | NJ | 1815-12-04 | 1817-03-03 | Republican | -1 | |||||||||||||
1770 | 1770 | James Wilson W000595 | sen | NJ | 1815-12-04 | 1821-01-08 | 1 | Republican | |||||||||||||
1800 | 1800 | Benjamin Bennet B000368 | rep | NJ | 1815-12-04 | 1817-03-03 | Republican | -1 | |||||||||||||
2145 | 2145 | Henry Southard S000685 | rep | NJ | 1815-12-04 | 1817-03-03 | Republican | -1 | |||||||||||||
2744 | 2744 | Ephraim Bateman B000228 | rep | NJ | 1815-12-04 | 1817-03-03 | Republican | -1 |
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);