legislator_terms
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
58 rows where party = "Federalist" and state = "NH"
This data as json, copyable, CSV (advanced)
Suggested facets: class, 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
295 | 295 | Jeremiah Smith S000563 | rep | NH | 1791-10-24 | 1793-03-03 | Federalist | -1 | |||||||||||||
296 | 296 | Jeremiah Smith S000563 | rep | NH | 1793-12-02 | 1795-03-03 | Federalist | -1 | |||||||||||||
297 | 297 | Jeremiah Smith S000563 | rep | NH | 1795-12-07 | 1797-03-03 | Federalist | -1 | |||||||||||||
298 | 298 | Jeremiah Smith S000563 | rep | NH | 1797-05-15 | 1799-03-03 | Federalist | -1 | |||||||||||||
307 | 307 | Peleg Sprague S000743 | rep | NH | 1797-05-15 | 1799-03-03 | Federalist | -1 | |||||||||||||
361 | 361 | Jonathan Freeman F000364 | rep | NH | 1797-05-15 | 1799-03-03 | Federalist | -1 | |||||||||||||
362 | 362 | Jonathan Freeman F000364 | rep | NH | 1799-12-02 | 1801-03-03 | Federalist | -1 | |||||||||||||
372 | 372 | William Gordon G000318 | rep | NH | 1797-05-15 | 1799-03-03 | Federalist | -1 | |||||||||||||
373 | 373 | William Gordon G000318 | rep | NH | 1799-12-02 | 1801-03-03 | Federalist | -1 | |||||||||||||
395 | 395 | Samuel Livermore L000364 | rep | NH | 1789-03-04 | 1791-03-03 | Federalist | -1 | |||||||||||||
396 | 396 | Samuel Livermore L000364 | rep | NH | 1791-10-24 | 1793-03-03 | Federalist | -1 | |||||||||||||
397 | 397 | Samuel Livermore L000364 | sen | NH | 1793-12-02 | 1799-03-03 | 2 | Federalist | |||||||||||||
398 | 398 | Samuel Livermore L000364 | sen | NH | 1799-12-02 | 1801-12-31 | 2 | Federalist | |||||||||||||
473 | 473 | Abiel Foster F000297 | rep | NH | 1789-03-04 | 1791-03-03 | Federalist | -1 | |||||||||||||
474 | 474 | Abiel Foster F000297 | rep | NH | 1795-12-07 | 1797-03-03 | Federalist | -1 | |||||||||||||
475 | 475 | Abiel Foster F000297 | rep | NH | 1797-05-15 | 1799-03-03 | Federalist | -1 | |||||||||||||
476 | 476 | Abiel Foster F000297 | rep | NH | 1799-12-02 | 1801-03-03 | Federalist | -1 | |||||||||||||
477 | 477 | Abiel Foster F000297 | rep | NH | 1801-12-07 | 1803-03-03 | Federalist | -1 | |||||||||||||
514 | 514 | Simeon Olcott O000060 | sen | NH | 1801-12-07 | 1805-03-03 | 2 | Federalist | |||||||||||||
515 | 515 | Joseph Peirce P000190 | rep | NH | 1801-12-07 | 1803-03-03 | Federalist | -1 | |||||||||||||
522 | 522 | James Sheafe S000312 | rep | NH | 1799-12-02 | 1801-03-03 | Federalist | -1 | |||||||||||||
523 | 523 | James Sheafe S000312 | sen | NH | 1801-12-07 | 1803-03-03 | 3 | Federalist | |||||||||||||
540 | 540 | George Upham U000022 | rep | NH | 1801-12-07 | 1803-03-03 | Federalist | -1 | |||||||||||||
552 | 552 | William Plumer P000393 | sen | NH | 1802-01-01 | 1807-03-03 | 3 | Federalist | |||||||||||||
591 | 591 | Samuel Hunt H000976 | rep | NH | 1801-12-07 | 1803-03-03 | Federalist | -1 | |||||||||||||
592 | 592 | Samuel Hunt H000976 | rep | NH | 1803-10-17 | 1805-03-03 | Federalist | -1 | |||||||||||||
665 | 665 | Silas Betton B000425 | rep | NH | 1803-10-17 | 1805-03-03 | Federalist | -1 | |||||||||||||
666 | 666 | Silas Betton B000425 | rep | NH | 1805-12-02 | 1807-03-03 | Federalist | -1 | |||||||||||||
687 | 687 | Caleb Ellis E000130 | rep | NH | 1805-12-02 | 1807-03-03 | Federalist | -1 | |||||||||||||
716 | 716 | David Hough H000811 | rep | NH | 1803-10-17 | 1805-03-03 | Federalist | -1 | |||||||||||||
717 | 717 | David Hough H000811 | rep | NH | 1805-12-02 | 1807-03-03 | Federalist | -1 | |||||||||||||
765 | 765 | Samuel Tenney T000127 | rep | NH | 1799-12-02 | 1801-03-03 | Federalist | -1 | |||||||||||||
766 | 766 | Samuel Tenney T000127 | rep | NH | 1801-12-07 | 1803-03-03 | Federalist | -1 | |||||||||||||
767 | 767 | Samuel Tenney T000127 | rep | NH | 1803-10-17 | 1805-03-03 | Federalist | -1 | |||||||||||||
768 | 768 | Samuel Tenney T000127 | rep | NH | 1805-12-02 | 1807-03-03 | Federalist | -1 | |||||||||||||
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 | |||||||||||||
976 | 976 | Nathaniel Haven H000354 | rep | NH | 1809-05-22 | 1811-03-03 | Federalist | -1 | |||||||||||||
1087 | 1087 | James Wilson W000592 | rep | NH | 1809-05-22 | 1811-03-03 | Federalist | -1 | |||||||||||||
1167 | 1167 | Nicholas Gilman G000215 | rep | NH | 1795-12-07 | 1797-03-03 | Federalist | -1 | |||||||||||||
1236 | 1236 | George Sullivan S001052 | rep | NH | 1811-11-04 | 1813-03-03 | Federalist | -1 | |||||||||||||
1374 | 1374 | Jeremiah Mason M000217 | sen | NH | 1813-05-24 | 1817-12-31 | 3 | Federalist | |||||||||||||
1413 | 1413 | Samuel Smith S000608 | rep | NH | 1813-05-24 | 1815-03-03 | Federalist | -1 | |||||||||||||
1442 | 1442 | Thomas Thompson T000220 | rep | NH | 1805-12-02 | 1807-03-03 | Federalist | -1 | |||||||||||||
1443 | 1443 | Thomas Thompson T000220 | sen | NH | 1814-01-01 | 1817-03-03 | 2 | Federalist | |||||||||||||
1450 | 1450 | Charles Atherton A000324 | rep | NH | 1815-12-04 | 1817-03-03 | Federalist | -1 | |||||||||||||
1498 | 1498 | Bradbury Cilley C000394 | rep | NH | 1813-05-24 | 1815-03-03 | Federalist | -1 | |||||||||||||
1499 | 1499 | Bradbury Cilley C000394 | rep | NH | 1815-12-04 | 1817-03-03 | Federalist | -1 | |||||||||||||
1594 | 1594 | William Hale H000039 | rep | NH | 1809-05-22 | 1811-03-03 | Federalist | -1 | |||||||||||||
1595 | 1595 | William Hale H000039 | rep | NH | 1813-05-24 | 1815-03-03 | Federalist | -1 | |||||||||||||
1596 | 1596 | William Hale H000039 | rep | NH | 1815-12-04 | 1817-03-03 | Federalist | -1 | |||||||||||||
1755 | 1755 | Roger Vose V000120 | rep | NH | 1813-05-24 | 1815-03-03 | Federalist | -1 | |||||||||||||
1756 | 1756 | Roger Vose V000120 | rep | NH | 1815-12-04 | 1817-03-03 | Federalist | -1 | |||||||||||||
1766 | 1766 | Jeduthun Wilcox W000456 | rep | NH | 1813-05-24 | 1815-03-03 | Federalist | -1 | |||||||||||||
1767 | 1767 | Jeduthun Wilcox W000456 | rep | NH | 1815-12-04 | 1817-03-03 | Federalist | -1 | |||||||||||||
1992 | 1992 | Clifton Clagett C000399 | rep | NH | 1803-10-17 | 1805-03-03 | Federalist | -1 | |||||||||||||
5564 | 5564 | Daniel Webster W000238 | rep | NH | 1813-05-24 | 1815-03-03 | Federalist | -1 | |||||||||||||
5565 | 5565 | Daniel Webster W000238 | rep | NH | 1815-12-04 | 1817-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);