legislator_terms
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
78 rows where party = "Federalist" and "start" is on date 1813-05-24
This data as json, copyable, CSV (advanced)
Suggested facets: type, end, district, 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 | |||||||||||||
1313 | 1313 | David Daggett D000002 | sen | CT | 1813-05-24 | 1819-03-03 | 3 | Federalist | |||||||||||||
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 | |||||||||||||
1358 | 1358 | Jacob Hufty H000914 | rep | NJ | 1813-05-24 | 1814-05-20 | Federalist | 3 | |||||||||||||
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 | |||||||||||||
1374 | 1374 | Jeremiah Mason M000217 | sen | NH | 1813-05-24 | 1817-12-31 | 3 | Federalist | |||||||||||||
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 | |||||||||||||
1424 | 1424 | William Wells W000287 | sen | DE | 1813-05-24 | 1817-03-03 | 2 | Federalist | |||||||||||||
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 | |||||||||||||
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 | |||||||||||||
1611 | 1611 | John Hulbert H000935 | rep | MA | 1813-05-24 | 1815-03-03 | Federalist | 12 | |||||||||||||
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 | |||||||||||||
2053 | 2053 | Rufus King K000212 | sen | NY | 1813-05-24 | 1819-03-03 | 3 | Federalist | |||||||||||||
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 | |||||||||||||
3911 | 3911 | Robert Goldsborough G000264 | sen | MD | 1813-05-24 | 1819-03-03 | 3 | Federalist | |||||||||||||
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 |
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);