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 district
This data as json, copyable, CSV (advanced)
Suggested facets: type, end, party, 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1441 | 1441 | Jonathan Roberts R000313 | sen | PA | 1815-12-04 | 1821-03-03 | 1 | Republican | |||||||||||||
1488 | 1488 | George Campbell C000083 | sen | TN | 1815-12-04 | 1819-03-03 | 1 | Republican | |||||||||||||
1540 | 1540 | Samuel Dana D000024 | sen | CT | 1815-12-04 | 1821-03-03 | 1 | Federalist | |||||||||||||
1587 | 1587 | Christopher Gore G000322 | sen | MA | 1815-12-04 | 1817-03-03 | 1 | Federalist | |||||||||||||
1606 | 1606 | Outerbridge Horsey H000795 | sen | DE | 1815-12-04 | 1821-03-03 | 1 | Federalist | |||||||||||||
1617 | 1617 | William Hunter H000991 | sen | RI | 1815-12-04 | 1821-03-03 | 1 | Federalist | |||||||||||||
1754 | 1754 | Isaac Tichenor T000264 | sen | VT | 1815-12-04 | 1821-03-03 | 1 | Federalist | |||||||||||||
1770 | 1770 | James Wilson W000595 | sen | NJ | 1815-12-04 | 1821-01-08 | 1 | Republican | |||||||||||||
1948 | 1948 | John Williams W000516 | sen | TN | 1815-12-04 | 1817-03-03 | 2 | Republican | |||||||||||||
2186 | 2186 | Isham Talbot T000017 | sen | KY | 1815-12-04 | 1819-03-03 | 3 | Republican | |||||||||||||
2193 | 2193 | James Barbour B000127 | sen | VA | 1815-12-04 | 1821-03-03 | 1 | Republican | |||||||||||||
2757 | 2757 | Nathan Sanford S000052 | sen | NY | 1815-12-04 | 1821-03-03 | 1 | Republican | |||||||||||||
2938 | 2938 | Benjamin Ruggles R000500 | sen | OH | 1815-12-04 | 1821-03-03 | 1 | Republican | |||||||||||||
1450 | 1450 | Charles Atherton A000324 | 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 | |||||||||||||
1466 | 1466 | David Bard B000137 | rep | PA | 1815-12-04 | 1817-03-03 | Republican | -1 | |||||||||||||
1494 | 1494 | Epaphroditus Champion C000288 | rep | CT | 1815-12-04 | 1817-03-03 | Federalist | -1 | |||||||||||||
1499 | 1499 | Bradbury Cilley C000394 | rep | NH | 1815-12-04 | 1817-03-03 | Federalist | -1 | |||||||||||||
1510 | 1510 | Matthew Clay C000487 | rep | VA | 1815-12-04 | 1817-03-03 | Republican | -1 | |||||||||||||
1549 | 1549 | John Davenport D000075 | rep | CT | 1815-12-04 | 1817-03-03 | Federalist | -1 | |||||||||||||
1552 | 1552 | Rufus Easton E000022 | rep | MO | 1815-12-04 | 1817-03-03 | -1 | ||||||||||||||
1566 | 1566 | Jonathan Fisk F000155 | rep | NY | 1815-12-04 | 1817-03-03 | Republican | -1 | |||||||||||||
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 | |||||||||||||
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 | |||||||||||||
1673 | 1673 | Nicholas Moore M000909 | rep | MD | 1815-12-04 | 1817-03-03 | Republican | -1 | |||||||||||||
1702 | 1702 | John Sevier S000257 | rep | TN | 1815-12-04 | 1817-03-03 | Republican | -1 | |||||||||||||
1711 | 1711 | William Smith S000638 | rep | NY | 1815-12-04 | 1817-03-03 | Federalist | -1 | |||||||||||||
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 | |||||||||||||
1745 | 1745 | Benjamin Tallmadge T000029 | rep | CT | 1815-12-04 | 1817-03-03 | Federalist | -1 | |||||||||||||
1750 | 1750 | Thomas Telfair T000115 | rep | GA | 1815-12-04 | 1817-03-03 | Republican | -1 | |||||||||||||
1756 | 1756 | Roger Vose V000120 | rep | NH | 1815-12-04 | 1817-03-03 | Federalist | -1 | |||||||||||||
1761 | 1761 | Thomas Ward W000141 | rep | NJ | 1815-12-04 | 1817-03-03 | Republican | -1 | |||||||||||||
1767 | 1767 | Jeduthun Wilcox W000456 | rep | NH | 1815-12-04 | 1817-03-03 | Federalist | -1 | |||||||||||||
1768 | 1768 | Jonathan Williams W000523 | rep | PA | 1815-12-04 | 1817-03-03 | -1 | ||||||||||||||
1800 | 1800 | Benjamin Bennet B000368 | rep | NJ | 1815-12-04 | 1817-03-03 | Republican | -1 | |||||||||||||
1804 | 1804 | John Boss B000650 | rep | RI | 1815-12-04 | 1817-03-03 | Federalist | -1 | |||||||||||||
1817 | 1817 | Zadock Cook C000728 | rep | GA | 1815-12-04 | 1817-03-03 | Republican | -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 | |||||||||||||
1901 | 1901 | Nathaniel Pope P000432 | rep | IL | 1815-12-04 | 1817-03-03 | -1 | ||||||||||||||
2088 | 2088 | Jonathan Moseley M001023 | rep | CT | 1815-12-04 | 1817-03-03 | Federalist | -1 | |||||||||||||
2145 | 2145 | Henry Southard S000685 | rep | NJ | 1815-12-04 | 1817-03-03 | Republican | -1 | |||||||||||||
2714 | 2714 | John Scott S000176 | rep | MO | 1815-12-04 | 1817-03-03 | -1 | ||||||||||||||
2744 | 2744 | Ephraim Bateman B000228 | rep | NJ | 1815-12-04 | 1817-03-03 | Republican | -1 | |||||||||||||
3149 | 3149 | Jonathan Jennings J000097 | rep | IN | 1815-12-04 | 1817-03-03 | -1 | ||||||||||||||
3340 | 3340 | Lewis Condict C000668 | rep | NJ | 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 | |||||||||||||
5565 | 5565 | Daniel Webster W000238 | rep | NH | 1815-12-04 | 1817-03-03 | Federalist | -1 | |||||||||||||
1497 | 1497 | Daniel Chipman C000366 | rep | VT | 1815-12-04 | 1817-03-03 | Federalist | 0 | |||||||||||||
1525 | 1525 | Thomas Cooper C000762 | rep | DE | 1815-12-04 | 1817-03-03 | Federalist | 0 | |||||||||||||
1626 | 1626 | Luther Jewett J000107 | rep | VT | 1815-12-04 | 1817-03-03 | Federalist | 0 | |||||||||||||
1635 | 1635 | Chauncey Langdon L000066 | rep | VT | 1815-12-04 | 1817-03-03 | Federalist | 0 | |||||||||||||
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 | |||||||||||||
1683 | 1683 | John Noyes N000164 | rep | VT | 1815-12-04 | 1817-03-03 | Federalist | 0 | |||||||||||||
4749 | 4749 | Thomas Clayton C000499 | rep | DE | 1815-12-04 | 1817-03-03 | Federalist | 0 | |||||||||||||
1530 | 1530 | Henry Crocheron C000914 | 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 | |||||||||||||
1625 | 1625 | John Jackson J000021 | rep | VA | 1815-12-04 | 1817-03-03 | Republican | 1 | |||||||||||||
1665 | 1665 | John McLean M000549 | rep | OH | 1815-12-04 | 1817-03-03 | Republican | 1 | |||||||||||||
1682 | 1682 | William Murfree M001084 | rep | NC | 1815-12-04 | 1817-03-03 | Republican | 1 | |||||||||||||
1697 | 1697 | Samuel Powell P000484 | rep | TN | 1815-12-04 | 1817-03-03 | Republican | 1 | |||||||||||||
1709 | 1709 | Thomas Smith S000617 | rep | PA | 1815-12-04 | 1817-03-03 | Federalist | 1 | |||||||||||||
1758 | 1758 | Artemas Ward W000128 | rep | MA | 1815-12-04 | 1817-03-03 | Federalist | 1 | |||||||||||||
1861 | 1861 | Joseph Hopkinson H000784 | rep | PA | 1815-12-04 | 1817-03-03 | Federalist | 1 | |||||||||||||
1878 | 1878 | Henry Middleton M000699 | rep | SC | 1815-12-04 | 1817-03-03 | Republican | 1 | |||||||||||||
1908 | 1908 | Thomas Robertson R000326 | rep | LA | 1815-12-04 | 1817-03-03 | Republican | 1 | |||||||||||||
1935 | 1935 | Philip Stuart S001036 | rep | MD | 1815-12-04 | 1817-03-03 | Federalist | 1 | |||||||||||||
1939 | 1939 | George Townsend T000333 | rep | NY | 1815-12-04 | 1817-03-03 | Republican | 1 | |||||||||||||
2269 | 2269 | William Milnor M000786 | rep | PA | 1815-12-04 | 1817-03-03 | Federalist | 1 | |||||||||||||
3063 | 3063 | James Clark C000436 | rep | KY | 1815-12-04 | 1817-03-03 | Republican | 1 | |||||||||||||
3399 | 3399 | William Hendricks H000494 | rep | IN | 1815-12-04 | 1817-03-03 | Republican | 1 | |||||||||||||
4650 | 4650 | William Harrison H000279 | rep | OH | 1815-12-04 | 1817-03-03 | Republican | 1 | |||||||||||||
4989 | 4989 | John Sergeant S000246 | rep | PA | 1815-12-04 | 1817-03-03 | Federalist | 1 | |||||||||||||
1449 | 1449 | John Alexander A000096 | rep | OH | 1815-12-04 | 1817-03-03 | Republican | 2 | |||||||||||||
1593 | 1593 | John Hahn H000018 | rep | PA | 1815-12-04 | 1817-03-03 | Republican | 2 | |||||||||||||
1690 | 1690 | Timothy Pickering P000324 | rep | MA | 1815-12-04 | 1817-03-03 | Federalist | 2 | |||||||||||||
1746 | 1746 | Magnus Tate T000047 | rep | VA | 1815-12-04 | 1817-03-03 | Federalist | 2 | |||||||||||||
1802 | 1802 | William Blount B000571 | rep | TN | 1815-12-04 | 1817-03-03 | Republican | 2 | |||||||||||||
1806 | 1806 | Joseph Bryan B000990 | rep | NC | 1815-12-04 | 1817-03-03 | Republican | 2 | |||||||||||||
1856 | 1856 | John Herbert H000525 | rep | MD | 1815-12-04 | 1817-03-03 | Federalist | 2 | |||||||||||||
1867 | 1867 | William Irving I000038 | rep | NY | 1815-12-04 | 1817-03-03 | Republican | 2 | |||||||||||||
2171 | 2171 | Peter Wendover W000293 | rep | NY | 1815-12-04 | 1817-03-03 | Republican | 2 | |||||||||||||
2226 | 2226 | William Darlington D000059 | rep | PA | 1815-12-04 | 1817-03-03 | Republican | 2 | |||||||||||||
2261 | 2261 | William Lowndes L000483 | rep | SC | 1815-12-04 | 1817-03-03 | Republican | 2 | |||||||||||||
5932 | 5932 | Henry Clay C000482 | rep | KY | 1815-12-04 | 1817-03-03 | Republican | 2 | |||||||||||||
1500 | 1500 | James Clark C000438 | rep | NC | 1815-12-04 | 1817-03-03 | Republican | 3 | |||||||||||||
1610 | 1610 | Benjamin Huger H000915 | rep | SC | 1815-12-04 | 1817-03-03 | Federalist | 3 | |||||||||||||
1751 | 1751 | Isaac Thomas T000169 | rep | TN | 1815-12-04 | 1817-03-03 | Republican | 3 | |||||||||||||
1759 | 1759 | Jonathan Ward W000136 | rep | NY | 1815-12-04 | 1817-03-03 | Republican | 3 | |||||||||||||
1780 | 1780 | Alexander Hanson H000176 | rep | MD | 1815-12-04 | 1816-12-20 | Federalist | 3 | |||||||||||||
1941 | 1941 | Henry Tucker T000398 | rep | VA | 1815-12-04 | 1817-03-03 | Republican | 3 | |||||||||||||
1944 | 1944 | John Whiteside W000412 | rep | PA | 1815-12-04 | 1817-03-03 | Republican | 3 | |||||||||||||
2168 | 2168 | James Wallace W000078 | rep | PA | 1815-12-04 | 1817-03-03 | Republican | 3 |
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);