legislator_terms
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
347 rows where state = "NH" and type = "rep"
This data as json, copyable, CSV (advanced)
Suggested facets: district, url, address, phone, fax, contact_form, office, rss_url, start (date), 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
138 | 138 | Paine Wingate W000633 | rep | NH | 1793-12-02 | 1795-03-03 | -1 | ||||||||||||||
209 | 209 | John Sherburne S000339 | rep | NH | 1793-12-02 | 1795-03-03 | Republican | -1 | |||||||||||||
210 | 210 | John Sherburne S000339 | rep | NH | 1795-12-07 | 1797-03-03 | Republican | -1 | |||||||||||||
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 | |||||||||||||
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 | |||||||||||||
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 | |||||||||||||
540 | 540 | George Upham U000022 | rep | NH | 1801-12-07 | 1803-03-03 | Federalist | -1 | |||||||||||||
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 | |||||||||||||
814 | 814 | Peter Carleton C000148 | rep | NH | 1807-10-26 | 1809-03-03 | Republican | -1 | |||||||||||||
831 | 831 | Daniel Durell D000565 | rep | NH | 1807-10-26 | 1809-03-03 | Republican | -1 | |||||||||||||
838 | 838 | Francis Gardner G000052 | rep | NH | 1807-10-26 | 1809-03-03 | Republican | -1 | |||||||||||||
892 | 892 | Jedediah Smith S000562 | rep | NH | 1807-10-26 | 1809-03-03 | Republican | -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 | |||||||||||||
1100 | 1100 | Josiah Bartlett B000207 | rep | NH | 1811-11-04 | 1813-03-03 | Republican | -1 | |||||||||||||
1148 | 1148 | Samuel Dinsmoor D000357 | rep | NH | 1811-11-04 | 1813-03-03 | Republican | -1 | |||||||||||||
1164 | 1164 | Nicholas Gilman G000215 | rep | NH | 1789-03-04 | 1791-03-03 | Democratic Republican | -1 | |||||||||||||
1165 | 1165 | Nicholas Gilman G000215 | rep | NH | 1791-10-24 | 1793-03-03 | Democratic Republican | -1 | |||||||||||||
1166 | 1166 | Nicholas Gilman G000215 | rep | NH | 1793-12-02 | 1795-03-03 | Democratic Republican | -1 | |||||||||||||
1167 | 1167 | Nicholas Gilman G000215 | rep | NH | 1795-12-07 | 1797-03-03 | Federalist | -1 | |||||||||||||
1180 | 1180 | Obed Hall H000064 | rep | NH | 1811-11-04 | 1813-03-03 | Republican | -1 | |||||||||||||
1181 | 1181 | John Harper H000223 | rep | NH | 1811-11-04 | 1813-03-03 | Republican | -1 | |||||||||||||
1236 | 1236 | George Sullivan S001052 | rep | NH | 1811-11-04 | 1813-03-03 | Federalist | -1 | |||||||||||||
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 | |||||||||||||
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 | |||||||||||||
1853 | 1853 | Salma Hale H000038 | rep | NH | 1817-12-01 | 1819-03-03 | Republican | -1 | |||||||||||||
1929 | 1929 | Clement Storer S000972 | rep | NH | 1807-10-26 | 1809-03-03 | Republican | -1 | |||||||||||||
1980 | 1980 | Joseph Buffum B001042 | rep | NH | 1819-12-06 | 1821-03-03 | Republican | -1 | |||||||||||||
1992 | 1992 | Clifton Clagett C000399 | rep | NH | 1803-10-17 | 1805-03-03 | Federalist | -1 | |||||||||||||
1993 | 1993 | Clifton Clagett C000399 | rep | NH | 1817-12-01 | 1819-03-03 | Republican | -1 | |||||||||||||
1994 | 1994 | Clifton Clagett C000399 | rep | NH | 1819-12-06 | 1821-03-03 | Republican | -1 | |||||||||||||
2096 | 2096 | John Parrott P000084 | rep | NH | 1817-12-01 | 1819-03-03 | Republican | -1 | |||||||||||||
2211 | 2211 | Josiah Butler B001181 | rep | NH | 1817-12-01 | 1819-03-03 | Republican | -1 | |||||||||||||
2212 | 2212 | Josiah Butler B001181 | rep | NH | 1819-12-06 | 1821-03-03 | Republican | -1 | |||||||||||||
2213 | 2213 | Josiah Butler B001181 | rep | NH | 1821-12-03 | 1823-03-03 | Republican | -1 | |||||||||||||
2334 | 2334 | Nathaniel Upham U000024 | rep | NH | 1817-12-01 | 1819-03-03 | Republican | -1 | |||||||||||||
2335 | 2335 | Nathaniel Upham U000024 | rep | NH | 1819-12-06 | 1821-03-03 | Republican | -1 | |||||||||||||
2336 | 2336 | Nathaniel Upham U000024 | rep | NH | 1821-12-03 | 1823-03-03 | Republican | -1 | |||||||||||||
2421 | 2421 | Matthew Harvey H000309 | rep | NH | 1821-12-03 | 1823-03-03 | Republican | -1 | |||||||||||||
2422 | 2422 | Matthew Harvey H000309 | rep | NH | 1823-12-01 | 1825-03-03 | -1 | ||||||||||||||
2440 | 2440 | Arthur Livermore L000362 | rep | NH | 1817-12-01 | 1819-03-03 | Republican | -1 | |||||||||||||
2441 | 2441 | Arthur Livermore L000362 | rep | NH | 1819-12-06 | 1821-03-03 | Republican | -1 | |||||||||||||
2442 | 2442 | Arthur Livermore L000362 | rep | NH | 1823-12-01 | 1825-03-03 | Republican | -1 | |||||||||||||
2446 | 2446 | Aaron Matson M000247 | rep | NH | 1821-12-03 | 1823-03-03 | Republican | -1 | |||||||||||||
2447 | 2447 | Aaron Matson M000247 | rep | NH | 1823-12-01 | 1825-03-03 | -1 | ||||||||||||||
2461 | 2461 | William Plumer P000394 | rep | NH | 1819-12-06 | 1821-03-03 | Republican | -1 | |||||||||||||
2462 | 2462 | William Plumer P000394 | rep | NH | 1821-12-03 | 1823-03-03 | Republican | -1 | |||||||||||||
2463 | 2463 | William Plumer P000394 | rep | NH | 1823-12-01 | 1825-03-03 | -1 | ||||||||||||||
2585 | 2585 | Nehemiah Eastman E000021 | rep | NH | 1825-12-05 | 1827-03-03 | Adams | -1 | |||||||||||||
2773 | 2773 | David Barker B000143 | rep | NH | 1827-12-03 | 1829-03-03 | Adams | -1 | |||||||||||||
2778 | 2778 | Ichabod Bartlett B000205 | rep | NH | 1823-12-01 | 1825-03-03 | -1 | ||||||||||||||
2779 | 2779 | Ichabod Bartlett B000205 | rep | NH | 1825-12-05 | 1827-03-03 | Adams | -1 | |||||||||||||
2780 | 2780 | Ichabod Bartlett B000205 | rep | NH | 1827-12-03 | 1829-03-03 | Adams | -1 | |||||||||||||
2802 | 2802 | Titus Brown B000945 | rep | NH | 1825-12-05 | 1827-03-03 | Adams | -1 | |||||||||||||
2803 | 2803 | Titus Brown B000945 | rep | NH | 1827-12-03 | 1829-03-03 | Adams | -1 | |||||||||||||
2856 | 2856 | Joseph Healy H000425 | rep | NH | 1825-12-05 | 1827-03-03 | Adams | -1 | |||||||||||||
2857 | 2857 | Joseph Healy H000425 | rep | NH | 1827-12-03 | 1829-03-03 | Adams | -1 | |||||||||||||
2991 | 2991 | Thomas Whipple W000345 | rep | NH | 1821-12-03 | 1823-03-03 | Republican | -1 | |||||||||||||
2992 | 2992 | Thomas Whipple W000345 | rep | NH | 1823-12-01 | 1825-03-03 | -1 | ||||||||||||||
2993 | 2993 | Thomas Whipple W000345 | rep | NH | 1825-12-05 | 1827-03-03 | Adams | -1 | |||||||||||||
2994 | 2994 | Thomas Whipple W000345 | rep | NH | 1827-12-03 | 1829-03-03 | Adams | -1 | |||||||||||||
3115 | 3115 | Jonathan Harvey H000308 | rep | NH | 1825-12-05 | 1827-03-03 | Jackson | -1 | |||||||||||||
3116 | 3116 | Jonathan Harvey H000308 | rep | NH | 1827-12-03 | 1829-03-03 | Jackson | -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);