legislator_terms
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
220 rows where "start" is on date 1813-05-24 sorted by rowid descending
This data as json, copyable, CSV (advanced)
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
6538 | 6538 | Dudley Chase C000325 | sen | VT | 1813-05-24 | 1817-12-31 | 3 | Republican | |||||||||||||
5931 | 5931 | Henry Clay C000482 | rep | KY | 1813-05-24 | 1815-03-03 | Republican | 2 | |||||||||||||
5871 | 5871 | William King K000217 | rep | NC | 1813-05-24 | 1815-03-03 | Republican | 5 | |||||||||||||
5733 | 5733 | Charles Ingersoll I000015 | rep | PA | 1813-05-24 | 1815-03-03 | Republican | 1 | |||||||||||||
5634 | 5634 | John Calhoun C000044 | rep | SC | 1813-05-24 | 1815-03-03 | Republican | 6 | |||||||||||||
5564 | 5564 | Daniel Webster W000238 | rep | NH | 1813-05-24 | 1815-03-03 | Federalist | -1 | |||||||||||||
4917 | 4917 | Jeremiah Morrow M001003 | sen | OH | 1813-05-24 | 1819-03-03 | 3 | Republican | |||||||||||||
4584 | 4584 | John Reed R000121 | rep | MA | 1813-05-24 | 1815-03-03 | Federalist | 8 | |||||||||||||
4493 | 4493 | Felix Grundy G000509 | rep | TN | 1813-05-24 | 1815-03-03 | Republican | 5 | |||||||||||||
4183 | 4183 | Alfred Cuthbert C001023 | rep | GA | 1813-05-24 | 1815-03-03 | Republican | -1 | |||||||||||||
4045 | 4045 | John Roane R000291 | rep | VA | 1813-05-24 | 1815-03-03 | Republican | 12 | |||||||||||||
3958 | 3958 | Richard Johnson J000170 | rep | KY | 1813-05-24 | 1815-03-03 | Republican | 3 | |||||||||||||
3911 | 3911 | Robert Goldsborough G000264 | sen | MD | 1813-05-24 | 1819-03-03 | 3 | Federalist | |||||||||||||
3711 | 3711 | Joseph Kent K000125 | rep | MD | 1813-05-24 | 1815-03-03 | Republican | 2 | |||||||||||||
3609 | 3609 | William Baylies B000256 | rep | MA | 1813-05-24 | 1815-03-03 | Federalist | 7 | |||||||||||||
3552 | 3552 | John Taylor T000091 | rep | NY | 1813-05-24 | 1815-03-03 | Republican | 11 | |||||||||||||
3510 | 3510 | Thomas Newton N000078 | rep | VA | 1813-05-24 | 1815-03-03 | Republican | 21 | |||||||||||||
3470 | 3470 | William McCoy M000377 | rep | VA | 1813-05-24 | 1815-03-03 | Republican | 4 | |||||||||||||
3383 | 3383 | John Forsyth F000284 | rep | GA | 1813-05-24 | 1815-03-03 | Republican | -1 | |||||||||||||
3354 | 3354 | William Creighton C000902 | rep | OH | 1813-05-24 | 1815-03-03 | Republican | 3 | |||||||||||||
3339 | 3339 | Lewis Condict C000668 | rep | NJ | 1813-05-24 | 1815-03-03 | Republican | 1 | |||||||||||||
3253 | 3253 | George Troup T000382 | rep | GA | 1813-05-24 | 1815-03-03 | Republican | -1 | |||||||||||||
3148 | 3148 | Jonathan Jennings J000097 | rep | IN | 1813-05-24 | 1815-03-03 | -1 | ||||||||||||||
3137 | 3137 | Samuel Ingham I000022 | rep | PA | 1813-05-24 | 1815-03-03 | Republican | 6 | |||||||||||||
3062 | 3062 | James Clark C000436 | rep | KY | 1813-05-24 | 1815-03-03 | Republican | 1 | |||||||||||||
3039 | 3039 | Philip Barbour B000131 | rep | VA | 1813-05-24 | 1815-03-03 | Republican | 11 | |||||||||||||
3030 | 3030 | Willis Alston A000167 | rep | NC | 1813-05-24 | 1815-03-03 | Republican | 2 | |||||||||||||
2936 | 2936 | Henry Ridgely R000245 | rep | DE | 1813-05-24 | 1815-03-03 | Federalist | 0 | |||||||||||||
2921 | 2921 | Thomas Oakley O000003 | rep | NY | 1813-05-24 | 1815-03-03 | Federalist | 4 | |||||||||||||
2824 | 2824 | John Culpepper C000976 | rep | NC | 1813-05-24 | 1815-03-03 | Federalist | 7 | |||||||||||||
2752 | 2752 | Israel Pickens P000322 | rep | NC | 1813-05-24 | 1815-03-03 | Republican | 12 | |||||||||||||
2675 | 2675 | Nathaniel Macon M000034 | rep | NC | 1813-05-24 | 1815-03-03 | Republican | 6 | |||||||||||||
2606 | 2606 | John Gaillard G000005 | sen | SC | 1813-05-24 | 1819-03-03 | 3 | Republican | |||||||||||||
2562 | 2562 | William Bradley B000748 | rep | VT | 1813-05-24 | 1815-03-03 | Republican | 0 | |||||||||||||
2531 | 2531 | Isaac Williams W000505 | rep | NY | 1813-05-24 | 1815-03-03 | Republican | 15 | |||||||||||||
2512 | 2512 | Daniel Udree U000003 | rep | PA | 1813-05-24 | 1815-03-03 | Republican | 7 | |||||||||||||
2467 | 2467 | Charles Rich R000207 | rep | VT | 1813-05-24 | 1815-03-03 | Republican | 0 | |||||||||||||
2448 | 2448 | Duncan McArthur M000299 | rep | OH | 1813-05-24 | 1815-03-03 | -1 | ||||||||||||||
2356 | 2356 | Robert Wright W000768 | rep | MD | 1813-05-24 | 1815-03-03 | Republican | 7 | |||||||||||||
2317 | 2317 | John Rhea R000181 | rep | TN | 1813-05-24 | 1815-03-03 | Republican | 1 | |||||||||||||
2281 | 2281 | Hugh Nelson N000035 | rep | VA | 1813-05-24 | 1815-03-03 | Republican | 22 | |||||||||||||
2271 | 2271 | Thomas Montgomery M000872 | rep | KY | 1813-05-24 | 1815-03-03 | Republican | 9 | |||||||||||||
2260 | 2260 | William Lowndes L000483 | rep | SC | 1813-05-24 | 1815-03-03 | Republican | 2 | |||||||||||||
2215 | 2215 | Newton Cannon C000123 | rep | TN | 1813-05-24 | 1815-03-03 | Republican | 5 | |||||||||||||
2151 | 2151 | William Strong S001022 | rep | VT | 1813-05-24 | 1815-03-03 | Republican | 0 | |||||||||||||
2122 | 2122 | Ebenezer Sage S000012 | rep | NY | 1813-05-24 | 1815-03-03 | Republican | 1 | |||||||||||||
2117 | 2117 | Samuel Ringgold R000263 | rep | MD | 1813-05-24 | 1815-03-03 | Republican | 4 | |||||||||||||
2106 | 2106 | James Pleasants P000386 | rep | VA | 1813-05-24 | 1815-03-03 | Republican | 17 | |||||||||||||
2093 | 2093 | James Parker P000060 | rep | MA | 1813-05-24 | 1815-03-03 | Republican | 19 | |||||||||||||
2087 | 2087 | Jonathan Moseley M001023 | rep | CT | 1813-05-24 | 1815-03-03 | Federalist | -1 | |||||||||||||
2053 | 2053 | Rufus King K000212 | sen | NY | 1813-05-24 | 1819-03-03 | 3 | Federalist | |||||||||||||
2046 | 2046 | James Johnson J000142 | rep | VA | 1813-05-24 | 1815-03-03 | Republican | 20 | |||||||||||||
2015 | 2015 | Elias Earle E000007 | rep | SC | 1813-05-24 | 1815-03-03 | Republican | 7 | |||||||||||||
1985 | 1985 | William Burwell B001160 | rep | VA | 1813-05-24 | 1815-03-03 | Republican | 14 | |||||||||||||
1976 | 1976 | James Brown B000921 | sen | LA | 1813-05-24 | 1817-03-03 | 2 | Republican | |||||||||||||
1967 | 1967 | Stevenson Archer A000273 | rep | MD | 1813-05-24 | 1815-03-03 | Republican | 6 | |||||||||||||
1951 | 1951 | John Wilson W000598 | rep | MA | 1813-05-24 | 1815-03-03 | Federalist | 18 | |||||||||||||
1934 | 1934 | Philip Stuart S001036 | rep | MD | 1813-05-24 | 1815-03-03 | Federalist | 1 | |||||||||||||
1922 | 1922 | Adam Seybert S000264 | rep | PA | 1813-05-24 | 1815-03-03 | Republican | 1 | |||||||||||||
1913 | 1913 | Nathaniel Ruggles R000503 | rep | MA | 1813-05-24 | 1815-03-03 | Federalist | 13 | |||||||||||||
1907 | 1907 | Thomas Robertson R000326 | rep | LA | 1813-05-24 | 1815-03-03 | Republican | 1 | |||||||||||||
1898 | 1898 | Timothy Pitkin P000368 | rep | CT | 1813-05-24 | 1815-03-03 | Federalist | -1 | |||||||||||||
1866 | 1866 | William Irving I000038 | rep | NY | 1813-05-24 | 1815-03-03 | Republican | 2 | |||||||||||||
1850 | 1850 | Peterson Goodwyn G000306 | rep | VA | 1813-05-24 | 1815-03-03 | Republican | 19 | |||||||||||||
1839 | 1839 | James Fisk F000154 | rep | VT | 1813-05-24 | 1815-03-03 | Republican | 0 | |||||||||||||
1834 | 1834 | John Eppes E000197 | rep | VA | 1813-05-24 | 1815-03-03 | Republican | 16 | |||||||||||||
1825 | 1825 | Joseph Desha D000271 | rep | KY | 1813-05-24 | 1815-03-03 | Republican | 4 | |||||||||||||
1814 | 1814 | Oliver Comstock C000664 | rep | NY | 1813-05-24 | 1815-03-03 | Republican | 20 | |||||||||||||
1796 | 1796 | William Anderson A000235 | rep | PA | 1813-05-24 | 1815-03-03 | Republican | 1 | |||||||||||||
1779 | 1779 | Alexander Hanson H000176 | rep | MD | 1813-05-24 | 1815-03-03 | Federalist | 3 | |||||||||||||
1775 | 1775 | Bartlett Yancey Y000001 | rep | NC | 1813-05-24 | 1815-03-03 | Republican | 9 | |||||||||||||
1771 | 1771 | Thomas Wilson W000616 | rep | PA | 1813-05-24 | 1815-03-03 | Republican | 15 | |||||||||||||
1766 | 1766 | Jeduthun Wilcox W000456 | rep | NH | 1813-05-24 | 1815-03-03 | Federalist | -1 | |||||||||||||
1764 | 1764 | Laban Wheaton W000329 | rep | MA | 1813-05-24 | 1815-03-03 | Federalist | 9 | |||||||||||||
1760 | 1760 | Thomas Ward W000141 | rep | NJ | 1813-05-24 | 1815-03-03 | Republican | 1 | |||||||||||||
1757 | 1757 | Artemas Ward W000128 | rep | MA | 1813-05-24 | 1815-03-03 | Federalist | 1 | |||||||||||||
1755 | 1755 | Roger Vose V000120 | rep | NH | 1813-05-24 | 1815-03-03 | Federalist | -1 | |||||||||||||
1749 | 1749 | Thomas Telfair T000115 | rep | GA | 1813-05-24 | 1815-03-03 | Republican | -1 | |||||||||||||
1744 | 1744 | Benjamin Tallmadge T000029 | rep | CT | 1813-05-24 | 1815-03-03 | Federalist | -1 | |||||||||||||
1736 | 1736 | Samuel Taggart T000012 | rep | MA | 1813-05-24 | 1815-03-03 | Federalist | 6 | |||||||||||||
1729 | 1729 | Lewis Sturges S001048 | rep | CT | 1813-05-24 | 1815-03-03 | Federalist | -1 | |||||||||||||
1723 | 1723 | Benjamin Stephenson S000862 | rep | IL | 1813-05-24 | 1815-03-03 | -1 | ||||||||||||||
1720 | 1720 | Richard Stanford S000794 | rep | NC | 1813-05-24 | 1815-03-03 | Republican | 8 | |||||||||||||
1710 | 1710 | William Smith S000638 | rep | NY | 1813-05-24 | 1815-03-03 | Federalist | 17 | |||||||||||||
1707 | 1707 | Daniel Sheffey S000317 | rep | VA | 1813-05-24 | 1815-03-03 | Federalist | 6 | |||||||||||||
1703 | 1703 | Solomon Sharp S000295 | rep | KY | 1813-05-24 | 1815-03-03 | Republican | 6 | |||||||||||||
1701 | 1701 | John Sevier S000257 | rep | TN | 1813-05-24 | 1815-03-03 | Republican | 2 | |||||||||||||
1692 | 1692 | William Piper P000363 | rep | PA | 1813-05-24 | 1815-03-03 | Republican | 8 | |||||||||||||
1689 | 1689 | Timothy Pickering P000324 | rep | MA | 1813-05-24 | 1815-03-03 | Federalist | 3 | |||||||||||||
1685 | 1685 | Stephen Ormsby O000100 | rep | KY | 1813-05-24 | 1815-03-03 | Republican | 8 | |||||||||||||
1681 | 1681 | William Murfree M001084 | rep | NC | 1813-05-24 | 1815-03-03 | Republican | 1 | |||||||||||||
1672 | 1672 | Nicholas Moore M000909 | rep | MD | 1813-05-24 | 1815-03-03 | Republican | 5 | |||||||||||||
1666 | 1666 | Hosea Moffitt M000840 | rep | NY | 1813-05-24 | 1815-03-03 | Federalist | 10 | |||||||||||||
1664 | 1664 | John McLean M000549 | rep | OH | 1813-05-24 | 1815-03-03 | Republican | 1 | |||||||||||||
1662 | 1662 | Samuel McKee M000496 | rep | KY | 1813-05-24 | 1815-03-03 | Republican | 7 | |||||||||||||
1655 | 1655 | Aaron Lyle L000524 | rep | PA | 1813-05-24 | 1815-03-03 | Republican | 12 | |||||||||||||
1651 | 1651 | John Lovett L000466 | rep | NY | 1813-05-24 | 1815-03-03 | Federalist | 9 | |||||||||||||
1648 | 1648 | Joseph Lewis L000290 | rep | VA | 1813-05-24 | 1815-03-03 | Federalist | 8 | |||||||||||||
1641 | 1641 | Lyman Law L000126 | rep | CT | 1813-05-24 | 1815-03-03 | Federalist | -1 | |||||||||||||
1638 | 1638 | William Lattimore L000118 | rep | MS | 1813-05-24 | 1815-03-03 | -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);