legislator_terms
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
222 rows where "end" is on date 1815-03-03 sorted by party
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1291 | 1291 | Shadrack Bond B000612 | rep | IL | 1813-05-24 | 1815-03-03 | -1 | ||||||||||||||
1350 | 1350 | Edward Hempstead H000472 | rep | MO | 1813-05-24 | 1815-03-03 | -1 | ||||||||||||||
1551 | 1551 | Rufus Easton E000022 | rep | MO | 1813-05-24 | 1815-03-03 | -1 | ||||||||||||||
1638 | 1638 | William Lattimore L000118 | rep | MS | 1813-05-24 | 1815-03-03 | -1 | ||||||||||||||
1723 | 1723 | Benjamin Stephenson S000862 | rep | IL | 1813-05-24 | 1815-03-03 | -1 | ||||||||||||||
2448 | 2448 | Duncan McArthur M000299 | rep | OH | 1813-05-24 | 1815-03-03 | -1 | ||||||||||||||
3148 | 3148 | Jonathan Jennings J000097 | rep | IN | 1813-05-24 | 1815-03-03 | -1 | ||||||||||||||
1274 | 1274 | Thomas Bayly B000260 | rep | VA | 1813-05-24 | 1815-03-03 | Federalist | 13 | |||||||||||||
1278 | 1278 | Egbert Benson B000388 | rep | NY | 1813-05-24 | 1815-03-03 | Federalist | 2 | |||||||||||||
1287 | 1287 | Abijah Bigelow B000453 | rep | MA | 1813-05-24 | 1815-03-03 | Federalist | 11 | |||||||||||||
1293 | 1293 | John Bowers B000691 | rep | NY | 1813-05-24 | 1815-03-03 | Federalist | 15 | |||||||||||||
1294 | 1294 | Alexander Boyd B000715 | rep | NY | 1813-05-24 | 1815-03-03 | Federalist | 13 | |||||||||||||
1306 | 1306 | Hugh Caperton C000131 | rep | VA | 1813-05-24 | 1815-03-03 | Federalist | 7 | |||||||||||||
1311 | 1311 | William Coxe C000843 | rep | NJ | 1813-05-24 | 1815-03-03 | Federalist | 3 | |||||||||||||
1317 | 1317 | Samuel Davis D000134 | rep | MA | 1813-05-24 | 1815-03-03 | Federalist | 16 | |||||||||||||
1328 | 1328 | Daniel Dewey D000293 | rep | MA | 1813-05-24 | 1815-03-03 | Federalist | 12 | |||||||||||||
1334 | 1334 | William Ely E000168 | rep | MA | 1813-05-24 | 1815-03-03 | Federalist | 5 | |||||||||||||
1343 | 1343 | James Geddes G000116 | rep | NY | 1813-05-24 | 1815-03-03 | Federalist | 19 | |||||||||||||
1344 | 1344 | John Gloninger G000241 | rep | PA | 1813-05-24 | 1815-03-03 | Federalist | 3 | |||||||||||||
1351 | 1351 | Samuel Henderson H000487 | rep | PA | 1813-05-24 | 1815-03-03 | Federalist | 2 | |||||||||||||
1353 | 1353 | Samuel Hopkins H000780 | rep | NY | 1813-05-24 | 1815-03-03 | Federalist | 21 | |||||||||||||
1354 | 1354 | Nathaniel Howell H000867 | rep | NY | 1813-05-24 | 1815-03-03 | Federalist | 21 | |||||||||||||
1365 | 1365 | Richard Jackson J000025 | rep | RI | 1813-05-24 | 1815-03-03 | Federalist | -1 | |||||||||||||
1373 | 1373 | Jacob Markell M000132 | rep | NY | 1813-05-24 | 1815-03-03 | Federalist | 14 | |||||||||||||
1378 | 1378 | Morris Miller M000747 | rep | NY | 1813-05-24 | 1815-03-03 | Federalist | 16 | |||||||||||||
1381 | 1381 | Joseph Pearson P000168 | rep | NC | 1813-05-24 | 1815-03-03 | Federalist | 10 | |||||||||||||
1382 | 1382 | Jotham Post P000455 | rep | NY | 1813-05-24 | 1815-03-03 | Federalist | 2 | |||||||||||||
1387 | 1387 | Elisha Potter P000463 | rep | RI | 1813-05-24 | 1815-03-03 | Federalist | -1 | |||||||||||||
1394 | 1394 | William Reed R000130 | rep | MA | 1813-05-24 | 1815-03-03 | Federalist | 2 | |||||||||||||
1400 | 1400 | James Schureman S000150 | rep | NJ | 1813-05-24 | 1815-03-03 | Federalist | 2 | |||||||||||||
1401 | 1401 | Samuel Sherwood S000356 | rep | NY | 1813-05-24 | 1815-03-03 | Federalist | 8 | |||||||||||||
1402 | 1402 | Zebulon Shipherd S000366 | rep | NY | 1813-05-24 | 1815-03-03 | Federalist | 12 | |||||||||||||
1404 | 1404 | Amos Slaymaker S000483 | rep | PA | 1813-05-24 | 1815-03-03 | Federalist | 3 | |||||||||||||
1413 | 1413 | Samuel Smith S000608 | rep | NH | 1813-05-24 | 1815-03-03 | Federalist | -1 | |||||||||||||
1415 | 1415 | Richard Stockton S000941 | rep | NJ | 1813-05-24 | 1815-03-03 | Federalist | 2 | |||||||||||||
1422 | 1422 | Joel Thompson T000205 | rep | NY | 1813-05-24 | 1815-03-03 | Federalist | 15 | |||||||||||||
1425 | 1425 | Francis White W000367 | rep | VA | 1813-05-24 | 1815-03-03 | Federalist | 2 | |||||||||||||
1432 | 1432 | Elisha Winter W000644 | rep | NY | 1813-05-24 | 1815-03-03 | Federalist | 12 | |||||||||||||
1469 | 1469 | George Bradbury B000733 | rep | MA | 1813-05-24 | 1815-03-03 | Federalist | 15 | |||||||||||||
1473 | 1473 | James Breckinridge B000785 | rep | VA | 1813-05-24 | 1815-03-03 | Federalist | 5 | |||||||||||||
1476 | 1476 | Elijah Brigham B000833 | rep | MA | 1813-05-24 | 1815-03-03 | Federalist | 10 | |||||||||||||
1493 | 1493 | Epaphroditus Champion C000288 | rep | CT | 1813-05-24 | 1815-03-03 | Federalist | -1 | |||||||||||||
1498 | 1498 | Bradbury Cilley C000394 | rep | NH | 1813-05-24 | 1815-03-03 | Federalist | -1 | |||||||||||||
1524 | 1524 | Thomas Cooper C000762 | rep | DE | 1813-05-24 | 1815-03-03 | Federalist | 0 | |||||||||||||
1539 | 1539 | Samuel Dana D000024 | sen | CT | 1810-12-04 | 1815-03-03 | 1 | Federalist | |||||||||||||
1548 | 1548 | John Davenport D000075 | rep | CT | 1813-05-24 | 1815-03-03 | Federalist | -1 | |||||||||||||
1568 | 1568 | William Gaston G000096 | rep | NC | 1813-05-24 | 1815-03-03 | Federalist | 4 | |||||||||||||
1584 | 1584 | Charles Goldsborough G000261 | rep | MD | 1813-05-24 | 1815-03-03 | Federalist | 8 | |||||||||||||
1586 | 1586 | Christopher Gore G000322 | sen | MA | 1813-05-24 | 1815-03-03 | 1 | Federalist | |||||||||||||
1591 | 1591 | Thomas Grosvenor G000498 | rep | NY | 1813-05-24 | 1815-03-03 | Federalist | 5 | |||||||||||||
1595 | 1595 | William Hale H000039 | rep | NH | 1813-05-24 | 1815-03-03 | Federalist | -1 | |||||||||||||
1605 | 1605 | Outerbridge Horsey H000795 | sen | DE | 1810-01-01 | 1815-03-03 | 1 | Federalist | |||||||||||||
1611 | 1611 | John Hulbert H000935 | rep | MA | 1813-05-24 | 1815-03-03 | Federalist | 12 | |||||||||||||
1616 | 1616 | William Hunter H000991 | sen | RI | 1811-11-04 | 1815-03-03 | 1 | Federalist | |||||||||||||
1627 | 1627 | Moss Kent K000126 | rep | NY | 1813-05-24 | 1815-03-03 | Federalist | 18 | |||||||||||||
1633 | 1633 | Cyrus King K000197 | rep | MA | 1813-05-24 | 1815-03-03 | Federalist | 14 | |||||||||||||
1641 | 1641 | Lyman Law L000126 | rep | CT | 1813-05-24 | 1815-03-03 | Federalist | -1 | |||||||||||||
1648 | 1648 | Joseph Lewis L000290 | rep | VA | 1813-05-24 | 1815-03-03 | Federalist | 8 | |||||||||||||
1651 | 1651 | John Lovett L000466 | rep | NY | 1813-05-24 | 1815-03-03 | Federalist | 9 | |||||||||||||
1666 | 1666 | Hosea Moffitt M000840 | rep | NY | 1813-05-24 | 1815-03-03 | Federalist | 10 | |||||||||||||
1689 | 1689 | Timothy Pickering P000324 | rep | MA | 1813-05-24 | 1815-03-03 | Federalist | 3 | |||||||||||||
1707 | 1707 | Daniel Sheffey S000317 | rep | VA | 1813-05-24 | 1815-03-03 | Federalist | 6 | |||||||||||||
1710 | 1710 | William Smith S000638 | rep | NY | 1813-05-24 | 1815-03-03 | Federalist | 17 | |||||||||||||
1729 | 1729 | Lewis Sturges S001048 | 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 | |||||||||||||
1744 | 1744 | Benjamin Tallmadge T000029 | rep | CT | 1813-05-24 | 1815-03-03 | Federalist | -1 | |||||||||||||
1755 | 1755 | Roger Vose V000120 | rep | NH | 1813-05-24 | 1815-03-03 | Federalist | -1 | |||||||||||||
1757 | 1757 | Artemas Ward W000128 | rep | MA | 1813-05-24 | 1815-03-03 | Federalist | 1 | |||||||||||||
1764 | 1764 | Laban Wheaton W000329 | rep | MA | 1813-05-24 | 1815-03-03 | Federalist | 9 | |||||||||||||
1766 | 1766 | Jeduthun Wilcox W000456 | rep | NH | 1813-05-24 | 1815-03-03 | Federalist | -1 | |||||||||||||
1779 | 1779 | Alexander Hanson H000176 | rep | MD | 1813-05-24 | 1815-03-03 | Federalist | 3 | |||||||||||||
1898 | 1898 | Timothy Pitkin P000368 | rep | CT | 1813-05-24 | 1815-03-03 | Federalist | -1 | |||||||||||||
1913 | 1913 | Nathaniel Ruggles R000503 | rep | MA | 1813-05-24 | 1815-03-03 | Federalist | 13 | |||||||||||||
1934 | 1934 | Philip Stuart S001036 | rep | MD | 1813-05-24 | 1815-03-03 | Federalist | 1 | |||||||||||||
1951 | 1951 | John Wilson W000598 | rep | MA | 1813-05-24 | 1815-03-03 | Federalist | 18 | |||||||||||||
2087 | 2087 | Jonathan Moseley M001023 | rep | CT | 1813-05-24 | 1815-03-03 | Federalist | -1 | |||||||||||||
2824 | 2824 | John Culpepper C000976 | rep | NC | 1813-05-24 | 1815-03-03 | Federalist | 7 | |||||||||||||
2921 | 2921 | Thomas Oakley O000003 | rep | NY | 1813-05-24 | 1815-03-03 | Federalist | 4 | |||||||||||||
2936 | 2936 | Henry Ridgely R000245 | rep | DE | 1813-05-24 | 1815-03-03 | Federalist | 0 | |||||||||||||
3609 | 3609 | William Baylies B000256 | rep | MA | 1813-05-24 | 1815-03-03 | Federalist | 7 | |||||||||||||
4584 | 4584 | John Reed R000121 | rep | MA | 1813-05-24 | 1815-03-03 | Federalist | 8 | |||||||||||||
5564 | 5564 | Daniel Webster W000238 | rep | NH | 1813-05-24 | 1815-03-03 | Federalist | -1 | |||||||||||||
943 | 943 | Joseph Anderson A000197 | sen | TN | 1809-05-22 | 1815-03-03 | 1 | Republican | |||||||||||||
948 | 948 | Richard Brent B000802 | sen | VA | 1809-05-22 | 1815-03-03 | 1 | Republican | |||||||||||||
974 | 974 | Obadiah German G000136 | sen | NY | 1809-05-22 | 1815-03-03 | 1 | Republican | |||||||||||||
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 | |||||||||||||
1056 | 1056 | Jonathan Robinson R000346 | sen | VT | 1809-05-22 | 1815-03-03 | 1 | Republican | |||||||||||||
1095 | 1095 | Thomas Worthington W000750 | sen | OH | 1810-01-01 | 1815-03-03 | 1 | Republican | |||||||||||||
1163 | 1163 | William Giles G000183 | sen | VA | 1811-11-04 | 1815-03-03 | 2 | Republican | |||||||||||||
1169 | 1169 | Nicholas Gilman G000215 | sen | NH | 1811-11-04 | 1815-03-03 | 2 | Republican | |||||||||||||
1273 | 1273 | William Barnett B000161 | rep | GA | 1813-05-24 | 1815-03-03 | Republican | -1 | |||||||||||||
1275 | 1275 | Reasin Beall B000273 | rep | OH | 1813-05-24 | 1815-03-03 | Republican | 6 | |||||||||||||
1288 | 1288 | Thomas Bines B000467 | rep | NJ | 1813-05-24 | 1815-03-03 | Republican | 3 | |||||||||||||
1289 | 1289 | Jesse Bledsoe B000554 | sen | KY | 1813-05-24 | 1815-03-03 | 3 | Republican | |||||||||||||
1292 | 1292 | John Bowen B000684 | rep | TN | 1813-05-24 | 1815-03-03 | Republican | 4 | |||||||||||||
1303 | 1303 | Robert Brown B000942 | rep | PA | 1813-05-24 | 1815-03-03 | Republican | 6 | |||||||||||||
1305 | 1305 | Ezra Butler B001176 | rep | VT | 1813-05-24 | 1815-03-03 | Republican | 0 | |||||||||||||
1309 | 1309 | Langdon Cheves C000350 | rep | SC | 1813-05-24 | 1815-03-03 | Republican | 1 | |||||||||||||
1310 | 1310 | John Conard C000667 | rep | PA | 1813-05-24 | 1815-03-03 | Republican | 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);