legislator_terms
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
168 rows where "end" is on date 1811-03-03 sorted by district
This data as json, copyable, CSV (advanced)
Suggested facets: state, start, party, start (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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
870 | 870 | Elisha Mathewson M000240 | sen | RI | 1807-10-26 | 1811-03-03 | 2 | Republican | |||||||||||||
879 | 879 | Nahum Parker P000067 | sen | NH | 1807-10-26 | 1811-03-03 | 3 | Republican | |||||||||||||
1086 | 1086 | Jenkin Whiteside W000411 | sen | TN | 1809-05-22 | 1811-03-03 | 2 | Republican | |||||||||||||
1092 | 1092 | John Taylor T000085 | sen | SC | 1810-12-31 | 1811-03-03 | 2 | Republican | |||||||||||||
1105 | 1105 | James Bayard B000249 | sen | DE | 1805-03-04 | 1811-03-03 | 2 | Federalist | |||||||||||||
1140 | 1140 | William Crawford C000895 | sen | GA | 1807-10-26 | 1811-03-03 | 2 | Republican | |||||||||||||
1162 | 1162 | William Giles G000183 | sen | VA | 1805-03-04 | 1811-03-03 | 2 | Republican | |||||||||||||
1168 | 1168 | Nicholas Gilman G000215 | sen | NH | 1805-12-02 | 1811-03-03 | 2 | Republican | |||||||||||||
1243 | 1243 | James Turner T000423 | sen | NC | 1805-12-02 | 1811-03-03 | 2 | Republican | |||||||||||||
1688 | 1688 | Timothy Pickering P000324 | sen | MA | 1805-12-02 | 1811-03-03 | 2 | Federalist | |||||||||||||
1999 | 1999 | John Condit C000671 | sen | NJ | 1809-05-22 | 1811-03-03 | 2 | Republican | |||||||||||||
5929 | 5929 | Henry Clay C000482 | sen | KY | 1810-01-01 | 1811-03-03 | 2 | Republican | |||||||||||||
944 | 944 | Daniel Blaisdell B000530 | rep | NH | 1809-05-22 | 1811-03-03 | Federalist | -1 | |||||||||||||
958 | 958 | John Chamberlain C000279 | rep | NH | 1809-05-22 | 1811-03-03 | Federalist | -1 | |||||||||||||
967 | 967 | James Cox C000834 | rep | NJ | 1809-05-22 | 1811-03-03 | Republican | -1 | |||||||||||||
969 | 969 | William Denning D000240 | rep | NY | 1809-05-22 | 1811-03-03 | -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 | |||||||||||||
1052 | 1052 | Julien Poydras P000493 | rep | OL | 1809-05-22 | 1811-03-03 | -1 | ||||||||||||||
1059 | 1059 | John Scudder S000200 | rep | NJ | 1809-05-22 | 1811-03-03 | Republican | -1 | |||||||||||||
1087 | 1087 | James Wilson W000592 | 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 | |||||||||||||
1135 | 1135 | Howell Cobb C000547 | rep | GA | 1809-05-22 | 1811-03-03 | Republican | -1 | |||||||||||||
1204 | 1204 | Thomas Newbold N000064 | rep | NJ | 1809-05-22 | 1811-03-03 | Republican | -1 | |||||||||||||
1281 | 1281 | William Bibb B000434 | rep | GA | 1809-05-22 | 1811-03-03 | Republican | -1 | |||||||||||||
1363 | 1363 | Richard Jackson J000025 | rep | RI | 1809-05-22 | 1811-03-03 | Federalist | -1 | |||||||||||||
1385 | 1385 | Elisha Potter P000463 | rep | RI | 1809-05-22 | 1811-03-03 | Federalist | -1 | |||||||||||||
1491 | 1491 | Epaphroditus Champion C000288 | rep | CT | 1809-05-22 | 1811-03-03 | Federalist | -1 | |||||||||||||
1546 | 1546 | John Davenport D000075 | rep | CT | 1809-05-22 | 1811-03-03 | Federalist | -1 | |||||||||||||
1594 | 1594 | William Hale H000039 | rep | NH | 1809-05-22 | 1811-03-03 | Federalist | -1 | |||||||||||||
1727 | 1727 | Lewis Sturges S001048 | rep | CT | 1809-05-22 | 1811-03-03 | Federalist | -1 | |||||||||||||
1742 | 1742 | Benjamin Tallmadge T000029 | rep | CT | 1809-05-22 | 1811-03-03 | Federalist | -1 | |||||||||||||
1864 | 1864 | Ebenezer Huntington H000996 | rep | CT | 1809-05-22 | 1811-03-03 | Federalist | -1 | |||||||||||||
1896 | 1896 | Timothy Pitkin P000368 | rep | CT | 1809-05-22 | 1811-03-03 | Federalist | -1 | |||||||||||||
2085 | 2085 | Jonathan Moseley M001023 | rep | CT | 1809-05-22 | 1811-03-03 | Federalist | -1 | |||||||||||||
2144 | 2144 | Henry Southard S000685 | rep | NJ | 1809-05-22 | 1811-03-03 | Republican | -1 | |||||||||||||
3146 | 3146 | Jonathan Jennings J000097 | rep | IN | 1809-05-22 | 1811-03-03 | -1 | ||||||||||||||
3251 | 3251 | George Troup T000382 | rep | GA | 1809-05-22 | 1811-03-03 | Republican | -1 | |||||||||||||
3280 | 3280 | George Poindexter P000402 | rep | MS | 1809-05-22 | 1811-03-03 | -1 | ||||||||||||||
1062 | 1062 | Dennis Smelt S000507 | rep | GA | 1809-05-22 | 1811-03-03 | Republican | 0 | |||||||||||||
1356 | 1356 | Jacob Hufty H000914 | rep | NJ | 1809-05-22 | 1811-03-03 | Republican | 0 | |||||||||||||
2517 | 2517 | Nicholas Van Dyke V000037 | rep | DE | 1809-05-22 | 1811-03-03 | Federalist | 0 | |||||||||||||
957 | 957 | John Campbell C000091 | rep | MD | 1809-05-22 | 1811-03-03 | Federalist | 1 | |||||||||||||
1027 | 1027 | Matthew Lyon L000545 | rep | KY | 1809-05-22 | 1811-03-03 | Republican | 1 | |||||||||||||
1033 | 1033 | Robert Marion M000130 | rep | SC | 1809-05-22 | 1811-03-03 | Republican | 1 | |||||||||||||
1035 | 1035 | William McKinley M000520 | rep | VA | 1809-05-22 | 1811-03-03 | Republican | 1 | |||||||||||||
1051 | 1051 | John Porter P000443 | rep | PA | 1809-05-22 | 1811-03-03 | Republican | 1 | |||||||||||||
1058 | 1058 | Benjamin Say S000098 | rep | PA | 1809-05-22 | 1811-03-03 | Republican | 1 | |||||||||||||
1210 | 1210 | Josiah Quincy Q000015 | rep | MA | 1809-05-22 | 1811-03-03 | Federalist | 1 | |||||||||||||
1223 | 1223 | Samuel Shaw S000310 | rep | VT | 1809-05-22 | 1811-03-03 | Republican | 1 | |||||||||||||
1307 | 1307 | Langdon Cheves C000350 | rep | SC | 1809-05-22 | 1811-03-03 | Republican | 1 | |||||||||||||
1623 | 1623 | John Jackson J000021 | rep | VA | 1809-05-22 | 1811-03-03 | Republican | 1 | |||||||||||||
1794 | 1794 | William Anderson A000235 | rep | PA | 1809-05-22 | 1811-03-03 | Republican | 1 | |||||||||||||
1920 | 1920 | Adam Seybert S000264 | rep | PA | 1809-05-22 | 1811-03-03 | Republican | 1 | |||||||||||||
2120 | 2120 | Ebenezer Sage S000012 | rep | NY | 1809-05-22 | 1811-03-03 | Republican | 1 | |||||||||||||
2315 | 2315 | John Rhea R000181 | rep | TN | 1809-05-22 | 1811-03-03 | Republican | 1 | |||||||||||||
2942 | 2942 | Lemuel Sawyer S000089 | rep | NC | 1809-05-22 | 1811-03-03 | Republican | 1 | |||||||||||||
4915 | 4915 | Jeremiah Morrow M001003 | rep | OH | 1809-05-22 | 1811-03-03 | Republican | 1 | |||||||||||||
998 | 998 | Jonathan Hubbard H000886 | rep | VT | 1809-05-22 | 1811-03-03 | Federalist | 2 | |||||||||||||
1036 | 1036 | Pleasant Miller M000750 | rep | TN | 1809-05-22 | 1811-03-03 | Republican | 2 | |||||||||||||
1039 | 1039 | Gurdon Mumford M001076 | rep | NY | 1809-05-22 | 1811-03-03 | Republican | 2 | |||||||||||||
1048 | 1048 | Benjamin Pickman P000330 | rep | MA | 1809-05-22 | 1811-03-03 | Federalist | 2 | |||||||||||||
1079 | 1079 | Archibald Van Horne V000043 | rep | MD | 1809-05-22 | 1811-03-03 | Republican | 2 | |||||||||||||
1126 | 1126 | William Butler B001194 | rep | SC | 1809-05-22 | 1811-03-03 | Republican | 2 | |||||||||||||
1197 | 1197 | Samuel Mitchill M000831 | rep | NY | 1810-12-04 | 1811-03-03 | Republican | 2 | |||||||||||||
1301 | 1301 | Robert Brown B000942 | rep | PA | 1809-05-22 | 1811-03-03 | Republican | 2 | |||||||||||||
1660 | 1660 | Samuel McKee M000496 | rep | KY | 1809-05-22 | 1811-03-03 | Republican | 2 | |||||||||||||
1910 | 1910 | John Ross R000449 | rep | PA | 1809-05-22 | 1811-03-03 | Republican | 2 | |||||||||||||
2268 | 2268 | William Milnor M000786 | rep | PA | 1809-05-22 | 1811-03-03 | Federalist | 2 | |||||||||||||
2492 | 2492 | James Stephenson S000864 | rep | VA | 1809-05-22 | 1811-03-03 | Federalist | 2 | |||||||||||||
3028 | 3028 | Willis Alston A000167 | rep | NC | 1809-05-22 | 1811-03-03 | Republican | 2 | |||||||||||||
960 | 960 | William Chamberlain C000280 | rep | VT | 1809-05-22 | 1811-03-03 | Federalist | 3 | |||||||||||||
968 | 968 | Henry Crist C000910 | rep | KY | 1809-05-22 | 1811-03-03 | Republican | 3 | |||||||||||||
982 | 982 | Daniel Hiester H000571 | rep | PA | 1809-05-22 | 1811-03-03 | Republican | 3 | |||||||||||||
1000 | 1000 | Robert Jenkins J000087 | rep | PA | 1809-05-22 | 1811-03-03 | Federalist | 3 | |||||||||||||
1019 | 1019 | Edward Livermore L000363 | rep | MA | 1809-05-22 | 1811-03-03 | Federalist | 3 | |||||||||||||
1054 | 1054 | Matthias Richards R000218 | rep | PA | 1809-05-22 | 1811-03-03 | Republican | 3 | |||||||||||||
1085 | 1085 | Robert Weakley W000220 | rep | TN | 1809-05-22 | 1811-03-03 | Republican | 3 | |||||||||||||
1088 | 1088 | Robert Witherspoon W000661 | rep | SC | 1809-05-22 | 1811-03-03 | Republican | 3 | |||||||||||||
1184 | 1184 | Philip Key K000159 | rep | MD | 1809-05-22 | 1811-03-03 | Federalist | 3 | |||||||||||||
1367 | 1367 | William Kennedy K000116 | rep | NC | 1809-05-22 | 1811-03-03 | Republican | 3 | |||||||||||||
1410 | 1410 | John Smith S000564 | rep | VA | 1809-05-22 | 1811-03-03 | Republican | 3 | |||||||||||||
1564 | 1564 | Jonathan Fisk F000155 | rep | NY | 1809-05-22 | 1811-03-03 | Republican | 3 | |||||||||||||
1043 | 1043 | Roger Nelson N000041 | rep | MD | 1809-05-22 | 1811-03-03 | Republican | 4 | |||||||||||||
1067 | 1067 | John Stanly S000800 | rep | NC | 1809-05-22 | 1811-03-03 | Federalist | 4 | |||||||||||||
1072 | 1072 | Jacob Swoope S001125 | rep | VA | 1809-05-22 | 1811-03-03 | Federalist | 4 | |||||||||||||
1132 | 1132 | Martin Chittenden C000372 | rep | VT | 1809-05-22 | 1811-03-03 | Federalist | 4 | |||||||||||||
1149 | 1149 | James Emott E000176 | rep | NY | 1809-05-22 | 1811-03-03 | Federalist | 4 | |||||||||||||
1253 | 1253 | Joseph Varnum V000074 | rep | MA | 1809-05-22 | 1811-03-03 | Democratic Republican | 4 | |||||||||||||
1429 | 1429 | Robert Whitehill W000404 | rep | PA | 1809-05-22 | 1811-03-03 | Republican | 4 | |||||||||||||
1463 | 1463 | David Bard B000137 | rep | PA | 1809-05-22 | 1811-03-03 | Republican | 4 | |||||||||||||
2115 | 2115 | Samuel Ringgold R000263 | rep | MD | 1809-05-22 | 1811-03-03 | Republican | 4 | |||||||||||||
3956 | 3956 | Richard Johnson J000170 | rep | KY | 1809-05-22 | 1811-03-03 | Republican | 4 | |||||||||||||
971 | 971 | Barent Gardenier G000049 | rep | NY | 1809-05-22 | 1811-03-03 | Federalist | 5 | |||||||||||||
997 | 997 | Benjamin Howard H000834 | rep | KY | 1809-05-22 | 1811-03-03 | Republican | 5 | |||||||||||||
1008 | 1008 | Thomas Kenan K000089 | rep | NC | 1809-05-22 | 1811-03-03 | Republican | 5 | |||||||||||||
1233 | 1233 | George Smith S000537 | rep | PA | 1809-05-22 | 1811-03-03 | Republican | 5 | |||||||||||||
1267 | 1267 | Richard Winn W000637 | rep | SC | 1809-05-22 | 1811-03-03 | Republican | 5 | |||||||||||||
1332 | 1332 | William Ely E000168 | rep | MA | 1809-05-22 | 1811-03-03 | Federalist | 5 | |||||||||||||
1375 | 1375 | Alexander McKim M000515 | rep | MD | 1809-05-22 | 1811-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);