legislator_terms
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
172 rows where "start" is on date 1809-05-22 sorted by legislator_id
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
937 | 937 | Joseph Allen A000136 | rep | MA | 1809-05-22 | 1811-03-03 | Federalist | 10 | |||||||||||||
939 | 939 | Lemuel Alston A000165 | rep | SC | 1809-05-22 | 1811-03-03 | Republican | 8 | |||||||||||||
3028 | 3028 | Willis Alston A000167 | rep | NC | 1809-05-22 | 1811-03-03 | Republican | 2 | |||||||||||||
943 | 943 | Joseph Anderson A000197 | sen | TN | 1809-05-22 | 1815-03-03 | 1 | Republican | |||||||||||||
1794 | 1794 | William Anderson A000235 | rep | PA | 1809-05-22 | 1811-03-03 | Republican | 1 | |||||||||||||
1097 | 1097 | Ezekiel Bacon B000015 | rep | MA | 1809-05-22 | 1811-03-03 | Republican | 12 | |||||||||||||
1463 | 1463 | David Bard B000137 | rep | PA | 1809-05-22 | 1811-03-03 | Republican | 4 | |||||||||||||
1434 | 1434 | William Barry B000192 | rep | KY | 1809-05-22 | 1811-03-03 | Republican | 5 | |||||||||||||
2783 | 2783 | Burwell Bassett B000224 | rep | VA | 1809-05-22 | 1811-03-03 | Republican | 12 | |||||||||||||
3608 | 3608 | William Baylies B000256 | rep | MA | 1809-05-22 | 1811-03-03 | Federalist | 7 | |||||||||||||
1281 | 1281 | William Bibb B000434 | rep | GA | 1809-05-22 | 1811-03-03 | Republican | -1 | |||||||||||||
1285 | 1285 | Abijah Bigelow B000453 | rep | MA | 1809-05-22 | 1811-03-03 | Federalist | 11 | |||||||||||||
944 | 944 | Daniel Blaisdell B000530 | rep | NH | 1809-05-22 | 1811-03-03 | Federalist | -1 | |||||||||||||
1120 | 1120 | Adam Boyd B000714 | rep | NJ | 1809-05-22 | 1811-03-03 | Republican | -1 | |||||||||||||
1471 | 1471 | James Breckinridge B000785 | rep | VA | 1809-05-22 | 1811-03-03 | Federalist | 5 | |||||||||||||
948 | 948 | Richard Brent B000802 | sen | VA | 1809-05-22 | 1815-03-03 | 1 | Republican | |||||||||||||
949 | 949 | John Brown B000928 | rep | MD | 1809-05-22 | 1811-03-03 | Republican | 7 | |||||||||||||
1301 | 1301 | Robert Brown B000942 | rep | PA | 1809-05-22 | 1811-03-03 | Republican | 2 | |||||||||||||
1983 | 1983 | William Burwell B001160 | rep | VA | 1809-05-22 | 1811-03-03 | Republican | 13 | |||||||||||||
1126 | 1126 | William Butler B001194 | rep | SC | 1809-05-22 | 1811-03-03 | Republican | 2 | |||||||||||||
951 | 951 | Joseph Calhoun C000045 | rep | SC | 1809-05-22 | 1811-03-03 | Republican | 6 | |||||||||||||
952 | 952 | Alexander Campbell C000076 | sen | OH | 1809-05-22 | 1813-03-03 | 3 | Republican | |||||||||||||
957 | 957 | John Campbell C000091 | rep | MD | 1809-05-22 | 1811-03-03 | Federalist | 1 | |||||||||||||
958 | 958 | John Chamberlain C000279 | rep | NH | 1809-05-22 | 1811-03-03 | Federalist | -1 | |||||||||||||
960 | 960 | William Chamberlain C000280 | rep | VT | 1809-05-22 | 1811-03-03 | Federalist | 3 | |||||||||||||
1491 | 1491 | Epaphroditus Champion C000288 | rep | CT | 1809-05-22 | 1811-03-03 | Federalist | -1 | |||||||||||||
963 | 963 | Christopher Champlin C000289 | sen | RI | 1809-05-22 | 1811-12-31 | 1 | Federalist | |||||||||||||
1307 | 1307 | Langdon Cheves C000350 | rep | SC | 1809-05-22 | 1811-03-03 | Republican | 1 | |||||||||||||
1132 | 1132 | Martin Chittenden C000372 | rep | VT | 1809-05-22 | 1811-03-03 | Federalist | 4 | |||||||||||||
1508 | 1508 | Matthew Clay C000487 | rep | VA | 1809-05-22 | 1811-03-03 | Republican | 14 | |||||||||||||
1519 | 1519 | John Clopton C000531 | rep | VA | 1809-05-22 | 1811-03-03 | Republican | 22 | |||||||||||||
1135 | 1135 | Howell Cobb C000547 | rep | GA | 1809-05-22 | 1811-03-03 | Republican | -1 | |||||||||||||
1137 | 1137 | James Cochran C000564 | rep | NC | 1809-05-22 | 1811-03-03 | Republican | 9 | |||||||||||||
1999 | 1999 | John Condit C000671 | sen | NJ | 1809-05-22 | 1811-03-03 | 2 | Republican | |||||||||||||
966 | 966 | Orchard Cook C000723 | rep | MA | 1809-05-22 | 1811-03-03 | Republican | 16 | |||||||||||||
967 | 967 | James Cox C000834 | rep | NJ | 1809-05-22 | 1811-03-03 | Republican | -1 | |||||||||||||
1526 | 1526 | William Crawford C000894 | rep | PA | 1809-05-22 | 1811-03-03 | Republican | 6 | |||||||||||||
968 | 968 | Henry Crist C000910 | rep | KY | 1809-05-22 | 1811-03-03 | Republican | 3 | |||||||||||||
1146 | 1146 | Richard Cutts C001033 | rep | MA | 1809-05-22 | 1811-03-03 | Republican | 14 | |||||||||||||
1538 | 1538 | Samuel Dana D000024 | rep | CT | 1809-05-22 | 1810-05-10 | Federalist | -1 | |||||||||||||
1546 | 1546 | John Davenport D000075 | rep | CT | 1809-05-22 | 1811-03-03 | Federalist | -1 | |||||||||||||
1324 | 1324 | John Dawson D000151 | rep | VA | 1809-05-22 | 1811-03-03 | Republican | 10 | |||||||||||||
969 | 969 | William Denning D000240 | rep | NY | 1809-05-22 | 1811-03-03 | -1 | ||||||||||||||
1823 | 1823 | Joseph Desha D000271 | rep | KY | 1809-05-22 | 1811-03-03 | Republican | 6 | |||||||||||||
1332 | 1332 | William Ely E000168 | rep | MA | 1809-05-22 | 1811-03-03 | Federalist | 5 | |||||||||||||
1149 | 1149 | James Emott E000176 | rep | NY | 1809-05-22 | 1811-03-03 | Federalist | 4 | |||||||||||||
1833 | 1833 | John Eppes E000197 | rep | VA | 1809-05-22 | 1811-03-03 | Republican | 16 | |||||||||||||
1560 | 1560 | William Findley F000124 | rep | PA | 1809-05-22 | 1811-03-03 | Republican | 8 | |||||||||||||
1564 | 1564 | Jonathan Fisk F000155 | rep | NY | 1809-05-22 | 1811-03-03 | Republican | 3 | |||||||||||||
1339 | 1339 | Meshack Franklin F000346 | rep | NC | 1809-05-22 | 1811-03-03 | Republican | 12 | |||||||||||||
1152 | 1152 | Barzillai Gannett G000039 | rep | MA | 1809-05-22 | 1811-03-03 | Republican | 17 | |||||||||||||
971 | 971 | Barent Gardenier G000049 | rep | NY | 1809-05-22 | 1811-03-03 | Federalist | 5 | |||||||||||||
972 | 972 | Gideon Gardner G000054 | rep | MA | 1809-05-22 | 1811-03-03 | Republican | 8 | |||||||||||||
973 | 973 | David Garland G000066 | rep | VA | 1809-05-22 | 1811-03-03 | Republican | 21 | |||||||||||||
974 | 974 | Obadiah German G000136 | sen | NY | 1809-05-22 | 1815-03-03 | 1 | Republican | |||||||||||||
1571 | 1571 | Thomas Gholson G000150 | rep | VA | 1809-05-22 | 1811-03-03 | Republican | 17 | |||||||||||||
1577 | 1577 | Thomas Gold G000257 | rep | NY | 1809-05-22 | 1811-03-03 | Federalist | 11 | |||||||||||||
1582 | 1582 | Charles Goldsborough G000261 | rep | MD | 1809-05-22 | 1811-03-03 | Federalist | 8 | |||||||||||||
1848 | 1848 | Peterson Goodwyn G000306 | rep | VA | 1809-05-22 | 1811-03-03 | Republican | 18 | |||||||||||||
1175 | 1175 | Edwin Gray G000394 | rep | VA | 1809-05-22 | 1811-03-03 | Republican | 19 | |||||||||||||
975 | 975 | Stanley Griswold G000489 | sen | OH | 1809-05-22 | 1809-12-31 | 3 | Republican | |||||||||||||
1594 | 1594 | William Hale H000039 | rep | NH | 1809-05-22 | 1811-03-03 | Federalist | -1 | |||||||||||||
976 | 976 | Nathaniel Haven H000354 | rep | NH | 1809-05-22 | 1811-03-03 | Federalist | -1 | |||||||||||||
981 | 981 | William Helms H000464 | rep | NJ | 1809-05-22 | 1811-03-03 | Republican | -1 | |||||||||||||
982 | 982 | Daniel Hiester H000571 | rep | PA | 1809-05-22 | 1811-03-03 | Republican | 3 | |||||||||||||
989 | 989 | James Hillhouse H000618 | sen | CT | 1809-05-22 | 1810-06-10 | 1 | Federalist | |||||||||||||
995 | 995 | James Holland H000718 | rep | NC | 1809-05-22 | 1811-03-03 | Republican | 11 | |||||||||||||
997 | 997 | Benjamin Howard H000834 | rep | KY | 1809-05-22 | 1811-03-03 | Republican | 5 | |||||||||||||
998 | 998 | Jonathan Hubbard H000886 | rep | VT | 1809-05-22 | 1811-03-03 | Federalist | 2 | |||||||||||||
1356 | 1356 | Jacob Hufty H000914 | rep | NJ | 1809-05-22 | 1811-03-03 | Republican | 0 | |||||||||||||
1864 | 1864 | Ebenezer Huntington H000996 | rep | CT | 1809-05-22 | 1811-03-03 | Federalist | -1 | |||||||||||||
1623 | 1623 | John Jackson J000021 | rep | VA | 1809-05-22 | 1811-03-03 | Republican | 1 | |||||||||||||
1363 | 1363 | Richard Jackson J000025 | rep | RI | 1809-05-22 | 1811-03-03 | Federalist | -1 | |||||||||||||
1000 | 1000 | Robert Jenkins J000087 | rep | PA | 1809-05-22 | 1811-03-03 | Federalist | 3 | |||||||||||||
3146 | 3146 | Jonathan Jennings J000097 | rep | IN | 1809-05-22 | 1811-03-03 | -1 | ||||||||||||||
3956 | 3956 | Richard Johnson J000170 | rep | KY | 1809-05-22 | 1811-03-03 | Republican | 4 | |||||||||||||
1005 | 1005 | Walter Jones J000254 | rep | VA | 1809-05-22 | 1811-03-03 | Republican | 8 | |||||||||||||
1008 | 1008 | Thomas Kenan K000089 | rep | NC | 1809-05-22 | 1811-03-03 | Republican | 5 | |||||||||||||
1367 | 1367 | William Kennedy K000116 | rep | NC | 1809-05-22 | 1811-03-03 | Republican | 3 | |||||||||||||
1184 | 1184 | Philip Key K000159 | rep | MD | 1809-05-22 | 1811-03-03 | Federalist | 3 | |||||||||||||
1009 | 1009 | Herman Knickerbocker K000282 | rep | NY | 1809-05-22 | 1811-03-03 | Federalist | 6 | |||||||||||||
1012 | 1012 | John Lambert L000036 | sen | NJ | 1809-05-22 | 1815-03-03 | 1 | Republican | |||||||||||||
1017 | 1017 | Michael Leib L000229 | sen | PA | 1809-05-22 | 1815-03-03 | 1 | Republican | |||||||||||||
1646 | 1646 | Joseph Lewis L000290 | rep | VA | 1809-05-22 | 1811-03-03 | Federalist | 7 | |||||||||||||
1019 | 1019 | Edward Livermore L000363 | rep | MA | 1809-05-22 | 1811-03-03 | Federalist | 3 | |||||||||||||
1187 | 1187 | Robert Livingston L000370 | rep | NY | 1809-05-22 | 1811-03-03 | Federalist | 6 | |||||||||||||
1021 | 1021 | John Love L000456 | rep | VA | 1809-05-22 | 1811-03-03 | Republican | 9 | |||||||||||||
1653 | 1653 | Aaron Lyle L000524 | rep | PA | 1809-05-22 | 1811-03-03 | Republican | 10 | |||||||||||||
1027 | 1027 | Matthew Lyon L000545 | rep | KY | 1809-05-22 | 1811-03-03 | Republican | 1 | |||||||||||||
2673 | 2673 | Nathaniel Macon M000034 | rep | NC | 1809-05-22 | 1811-03-03 | Republican | 6 | |||||||||||||
1030 | 1030 | Francis Malbone M000076 | sen | RI | 1809-05-22 | 1809-12-31 | 1 | Federalist | |||||||||||||
1033 | 1033 | Robert Marion M000130 | rep | SC | 1809-05-22 | 1811-03-03 | Republican | 1 | |||||||||||||
1034 | 1034 | Vincent Mathews M000239 | rep | NY | 1809-05-22 | 1811-03-03 | Federalist | 14 | |||||||||||||
1190 | 1190 | Archibald McBryde M000302 | rep | NC | 1809-05-22 | 1811-03-03 | Federalist | 7 | |||||||||||||
1660 | 1660 | Samuel McKee M000496 | rep | KY | 1809-05-22 | 1811-03-03 | Republican | 2 | |||||||||||||
1375 | 1375 | Alexander McKim M000515 | rep | MD | 1809-05-22 | 1811-03-03 | Republican | 5 | |||||||||||||
1035 | 1035 | William McKinley M000520 | rep | VA | 1809-05-22 | 1811-03-03 | Republican | 1 | |||||||||||||
1036 | 1036 | Pleasant Miller M000750 | rep | TN | 1809-05-22 | 1811-03-03 | Republican | 2 | |||||||||||||
2268 | 2268 | William Milnor M000786 | rep | PA | 1809-05-22 | 1811-03-03 | Federalist | 2 | |||||||||||||
1200 | 1200 | John Montgomery M000867 | rep | MD | 1809-05-22 | 1811-03-03 | Republican | 6 |
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);