legislator_terms
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
166 rows where "end" is on date 1813-03-03
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1590 | 1590 | Thomas Grosvenor G000498 | rep | NY | 1811-11-04 | 1813-03-03 | Federalist | 6 | |||||||||||||
1597 | 1597 | Bolling Hall H000045 | rep | GA | 1811-11-04 | 1813-03-03 | Republican | -1 | |||||||||||||
1601 | 1601 | Aylett Hawes H000361 | rep | VA | 1811-11-04 | 1813-03-03 | Republican | 9 | |||||||||||||
1613 | 1613 | John Hungerford H000967 | rep | VA | 1811-11-04 | 1813-03-03 | Republican | 8 | |||||||||||||
1640 | 1640 | Lyman Law L000126 | rep | CT | 1811-11-04 | 1813-03-03 | Federalist | -1 | |||||||||||||
1647 | 1647 | Joseph Lewis L000290 | rep | VA | 1811-11-04 | 1813-03-03 | Federalist | 7 | |||||||||||||
1654 | 1654 | Aaron Lyle L000524 | rep | PA | 1811-11-04 | 1813-03-03 | Republican | 10 | |||||||||||||
1661 | 1661 | Samuel McKee M000496 | rep | KY | 1811-11-04 | 1813-03-03 | Republican | 2 | |||||||||||||
1679 | 1679 | Thomas Moore M000919 | rep | SC | 1811-11-04 | 1813-03-03 | Republican | 7 | |||||||||||||
1684 | 1684 | Stephen Ormsby O000100 | rep | KY | 1811-11-04 | 1813-03-03 | Republican | 3 | |||||||||||||
1691 | 1691 | William Piper P000363 | rep | PA | 1811-11-04 | 1813-03-03 | Republican | 7 | |||||||||||||
1695 | 1695 | Peter Porter P000446 | rep | NY | 1811-11-04 | 1813-03-03 | Republican | 15 | |||||||||||||
1700 | 1700 | John Sevier S000257 | rep | TN | 1811-11-04 | 1813-03-03 | Republican | 2 | |||||||||||||
1706 | 1706 | Daniel Sheffey S000317 | rep | VA | 1811-11-04 | 1813-03-03 | Federalist | 6 | |||||||||||||
1719 | 1719 | Richard Stanford S000794 | rep | NC | 1811-11-04 | 1813-03-03 | Republican | 8 | |||||||||||||
1728 | 1728 | Lewis Sturges S001048 | rep | CT | 1811-11-04 | 1813-03-03 | Federalist | -1 | |||||||||||||
1735 | 1735 | Samuel Taggart T000012 | rep | MA | 1811-11-04 | 1813-03-03 | Federalist | 6 | |||||||||||||
1743 | 1743 | Benjamin Tallmadge T000029 | rep | CT | 1811-11-04 | 1813-03-03 | Federalist | -1 | |||||||||||||
1763 | 1763 | Laban Wheaton W000329 | rep | MA | 1811-11-04 | 1813-03-03 | Federalist | 9 | |||||||||||||
1795 | 1795 | William Anderson A000235 | rep | PA | 1811-11-04 | 1813-03-03 | Republican | 1 | |||||||||||||
1824 | 1824 | Joseph Desha D000271 | rep | KY | 1811-11-04 | 1813-03-03 | Republican | 6 | |||||||||||||
1838 | 1838 | James Fisk F000154 | rep | VT | 1811-11-04 | 1813-03-03 | Republican | 3 | |||||||||||||
1849 | 1849 | Peterson Goodwyn G000306 | rep | VA | 1811-11-04 | 1813-03-03 | Republican | 18 | |||||||||||||
1897 | 1897 | Timothy Pitkin P000368 | rep | CT | 1811-11-04 | 1813-03-03 | Federalist | -1 | |||||||||||||
1906 | 1906 | Thomas Robertson R000326 | rep | LA | 1811-11-04 | 1813-03-03 | Republican | 1 | |||||||||||||
1921 | 1921 | Adam Seybert S000264 | rep | PA | 1811-11-04 | 1813-03-03 | Republican | 1 | |||||||||||||
1933 | 1933 | Philip Stuart S001036 | rep | MD | 1811-11-04 | 1813-03-03 | Federalist | 1 | |||||||||||||
1966 | 1966 | Stevenson Archer A000273 | rep | MD | 1811-11-04 | 1813-03-03 | Republican | 6 | |||||||||||||
1984 | 1984 | William Burwell B001160 | rep | VA | 1811-11-04 | 1813-03-03 | Republican | 13 | |||||||||||||
2014 | 2014 | Elias Earle E000007 | rep | SC | 1811-11-04 | 1813-03-03 | Republican | 8 | |||||||||||||
2086 | 2086 | Jonathan Moseley M001023 | rep | CT | 1811-11-04 | 1813-03-03 | Federalist | -1 | |||||||||||||
2105 | 2105 | James Pleasants P000386 | rep | VA | 1811-11-04 | 1813-03-03 | Republican | 16 | |||||||||||||
2116 | 2116 | Samuel Ringgold R000263 | rep | MD | 1811-11-04 | 1813-03-03 | Republican | 4 | |||||||||||||
2121 | 2121 | Ebenezer Sage S000012 | rep | NY | 1811-11-04 | 1813-03-03 | Republican | 1 | |||||||||||||
2150 | 2150 | William Strong S001022 | rep | VT | 1811-11-04 | 1813-03-03 | Republican | 2 | |||||||||||||
2259 | 2259 | William Lowndes L000483 | rep | SC | 1811-11-04 | 1813-03-03 | Republican | 4 | |||||||||||||
2280 | 2280 | Hugh Nelson N000035 | rep | VA | 1811-11-04 | 1813-03-03 | Republican | 21 | |||||||||||||
2293 | 2293 | Anthony New N000058 | rep | KY | 1811-11-04 | 1813-03-03 | Republican | 1 | |||||||||||||
2306 | 2306 | Philip Reed R000125 | sen | MD | 1807-10-26 | 1813-03-03 | 3 | Republican | |||||||||||||
2316 | 2316 | John Rhea R000181 | rep | TN | 1811-11-04 | 1813-03-03 | Republican | 1 | |||||||||||||
2355 | 2355 | Robert Wright W000768 | rep | MD | 1811-11-04 | 1813-03-03 | Republican | 7 | |||||||||||||
2605 | 2605 | John Gaillard G000005 | sen | SC | 1807-10-26 | 1813-03-03 | 3 | Republican | |||||||||||||
2674 | 2674 | Nathaniel Macon M000034 | rep | NC | 1811-11-04 | 1813-03-03 | Republican | 6 | |||||||||||||
2751 | 2751 | Israel Pickens P000322 | rep | NC | 1811-11-04 | 1813-03-03 | Republican | 11 | |||||||||||||
2784 | 2784 | Burwell Bassett B000224 | rep | VA | 1811-11-04 | 1813-03-03 | Republican | 12 | |||||||||||||
2870 | 2870 | Peter Little L000354 | rep | MD | 1811-11-04 | 1813-03-03 | Republican | 5 | |||||||||||||
2935 | 2935 | Henry Ridgely R000245 | rep | DE | 1811-11-04 | 1813-03-03 | Federalist | 0 | |||||||||||||
2943 | 2943 | Lemuel Sawyer S000089 | rep | NC | 1811-11-04 | 1813-03-03 | Republican | 1 | |||||||||||||
3029 | 3029 | Willis Alston A000167 | rep | NC | 1811-11-04 | 1813-03-03 | Republican | 2 | |||||||||||||
3147 | 3147 | Jonathan Jennings J000097 | rep | IN | 1811-11-04 | 1813-03-03 | -1 | ||||||||||||||
3252 | 3252 | George Troup T000382 | rep | GA | 1811-11-04 | 1813-03-03 | Republican | -1 | |||||||||||||
3281 | 3281 | George Poindexter P000402 | rep | MS | 1811-11-04 | 1813-03-03 | -1 | ||||||||||||||
3338 | 3338 | Lewis Condict C000668 | rep | NJ | 1811-11-04 | 1813-03-03 | Republican | -1 | |||||||||||||
3469 | 3469 | William McCoy M000377 | rep | VA | 1811-11-04 | 1813-03-03 | Republican | 4 | |||||||||||||
3509 | 3509 | Thomas Newton N000078 | rep | VA | 1811-11-04 | 1813-03-03 | Republican | 20 | |||||||||||||
3710 | 3710 | Joseph Kent K000125 | rep | MD | 1811-11-04 | 1813-03-03 | Republican | 2 | |||||||||||||
3779 | 3779 | John Randolph R000047 | rep | VA | 1811-11-04 | 1813-03-03 | Republican | 15 | |||||||||||||
3957 | 3957 | Richard Johnson J000170 | rep | KY | 1811-11-04 | 1813-03-03 | Republican | 4 | |||||||||||||
4044 | 4044 | John Roane R000291 | rep | VA | 1811-11-04 | 1813-03-03 | Republican | 11 | |||||||||||||
4492 | 4492 | Felix Grundy G000509 | rep | TN | 1811-11-04 | 1813-03-03 | Republican | 3 | |||||||||||||
4916 | 4916 | Jeremiah Morrow M001003 | rep | OH | 1811-11-04 | 1813-03-03 | Republican | 1 | |||||||||||||
4940 | 4940 | John Pope P000431 | sen | KY | 1807-10-26 | 1813-03-03 | 3 | Republican | |||||||||||||
5021 | 5021 | John Taliaferro T000027 | rep | VA | 1811-11-04 | 1813-03-03 | Republican | 8 | |||||||||||||
5633 | 5633 | John Calhoun C000044 | rep | SC | 1811-11-04 | 1813-03-03 | Republican | 6 | |||||||||||||
5870 | 5870 | William King K000217 | rep | NC | 1811-11-04 | 1813-03-03 | Republican | 5 | |||||||||||||
5930 | 5930 | Henry Clay C000482 | rep | KY | 1811-11-04 | 1813-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);