legislator_terms
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
91 rows where party = "Democrat" and state = "NH"
This data as json, copyable, CSV (advanced)
Suggested facets: type, class, address, phone, fax, contact_form, office, state_rank, 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3943 | 3943 | Henry Hubbard H000883 | sen | NH | 1835-12-07 | 1841-03-03 | 2 | Democrat | |||||||||||||
4182 | 4182 | Samuel Cushman C001021 | rep | NH | 1837-09-04 | 1839-03-03 | Democrat | -1 | |||||||||||||
4200 | 4200 | James Farrington F000033 | rep | NH | 1837-09-04 | 1839-03-03 | Democrat | -1 | |||||||||||||
4374 | 4374 | Joseph Weeks W000247 | rep | NH | 1837-09-04 | 1839-03-03 | Democrat | -1 | |||||||||||||
4767 | 4767 | Ira Eastman E000020 | rep | NH | 1839-12-02 | 1841-03-03 | Democrat | -1 | |||||||||||||
4768 | 4768 | Ira Eastman E000020 | rep | NH | 1841-05-31 | 1843-03-03 | Democrat | -1 | |||||||||||||
4999 | 4999 | Tristram Shaw S000311 | rep | NH | 1839-12-02 | 1841-03-03 | Democrat | -1 | |||||||||||||
5000 | 5000 | Tristram Shaw S000311 | rep | NH | 1841-05-31 | 1843-03-03 | Democrat | -1 | |||||||||||||
5089 | 5089 | Levi Woodbury W000711 | sen | NH | 1841-05-31 | 1845-12-31 | 2 | Democrat | |||||||||||||
5111 | 5111 | Leonard Wilcox W000458 | sen | NH | 1842-01-01 | 1843-03-03 | 3 | Democrat | |||||||||||||
5149 | 5149 | Edmund Burke B001088 | rep | NH | 1839-12-02 | 1841-03-03 | Democrat | -1 | |||||||||||||
5150 | 5150 | Edmund Burke B001088 | rep | NH | 1841-05-31 | 1843-03-03 | Democrat | -1 | |||||||||||||
5151 | 5151 | Edmund Burke B001088 | rep | NH | 1843-12-04 | 1845-03-03 | Democrat | -1 | |||||||||||||
5273 | 5273 | John Reding R000106 | rep | NH | 1841-05-31 | 1843-03-03 | Democrat | -1 | |||||||||||||
5274 | 5274 | John Reding R000106 | rep | NH | 1843-12-04 | 1845-03-03 | Democrat | -1 | |||||||||||||
5454 | 5454 | Benning Jenness J000094 | sen | NH | 1845-12-01 | 1847-03-03 | 2 | Democrat | |||||||||||||
5487 | 5487 | Mace Moulton M001046 | rep | NH | 1845-12-01 | 1847-03-03 | Democrat | -1 | |||||||||||||
5748 | 5748 | James Johnson J000146 | rep | NH | 1845-12-01 | 1847-03-03 | Democrat | -1 | |||||||||||||
5749 | 5749 | James Johnson J000146 | rep | NH | 1847-12-06 | 1849-03-03 | Democrat | 4 | |||||||||||||
6082 | 6082 | Moses Norris N000140 | rep | NH | 1843-12-04 | 1845-03-03 | Democrat | -1 | |||||||||||||
6083 | 6083 | Moses Norris N000140 | rep | NH | 1845-12-01 | 1847-03-03 | Democrat | -1 | |||||||||||||
6084 | 6084 | Moses Norris N000140 | sen | NH | 1849-12-03 | 1855-03-03 | 3 | Democrat | |||||||||||||
6381 | 6381 | Charles Peaslee P000173 | rep | NH | 1847-12-06 | 1849-03-03 | Democrat | 2 | |||||||||||||
6382 | 6382 | Charles Peaslee P000173 | rep | NH | 1849-12-03 | 1851-03-03 | Democrat | 2 | |||||||||||||
6383 | 6383 | Charles Peaslee P000173 | rep | NH | 1851-12-01 | 1853-03-03 | Democrat | 2 | |||||||||||||
6485 | 6485 | Franklin Pierce P000333 | sen | NH | 1837-09-04 | 1843-03-03 | 3 | Democrat | |||||||||||||
6494 | 6494 | Charles Atherton A000323 | rep | NH | 1837-09-04 | 1839-03-03 | Democrat | -1 | |||||||||||||
6495 | 6495 | Charles Atherton A000323 | rep | NH | 1839-12-02 | 1841-03-03 | Democrat | -1 | |||||||||||||
6496 | 6496 | Charles Atherton A000323 | rep | NH | 1841-05-31 | 1843-03-03 | Democrat | -1 | |||||||||||||
6497 | 6497 | Charles Atherton A000323 | sen | NH | 1843-12-04 | 1849-03-03 | 3 | Democrat | |||||||||||||
6498 | 6498 | Charles Atherton A000323 | sen | NH | 1853-12-05 | 1853-12-31 | 2 | Democrat | |||||||||||||
6608 | 6608 | Harry Hibbard H000557 | rep | NH | 1849-12-03 | 1851-03-03 | Democrat | 4 | |||||||||||||
6609 | 6609 | Harry Hibbard H000557 | rep | NH | 1851-12-01 | 1853-03-03 | Democrat | 4 | |||||||||||||
6610 | 6610 | Harry Hibbard H000557 | rep | NH | 1853-12-05 | 1855-03-03 | Democrat | 3 | |||||||||||||
6635 | 6635 | George Kittredge K000256 | rep | NH | 1853-12-05 | 1855-03-03 | Democrat | 1 | |||||||||||||
6653 | 6653 | George Morrison M000994 | rep | NH | 1849-12-03 | 1851-03-03 | Democrat | 3 | |||||||||||||
6654 | 6654 | George Morrison M000994 | rep | NH | 1853-12-05 | 1855-03-03 | Democrat | 2 | |||||||||||||
6736 | 6736 | Jared Williams W000511 | rep | NH | 1837-09-04 | 1839-03-03 | Democrat | -1 | |||||||||||||
6737 | 6737 | Jared Williams W000511 | rep | NH | 1839-12-02 | 1841-03-03 | Democrat | -1 | |||||||||||||
6738 | 6738 | Jared Williams W000511 | sen | NH | 1853-12-05 | 1855-03-03 | 2 | Democrat | |||||||||||||
6947 | 6947 | John Wells W000285 | sen | NH | 1855-12-03 | 1855-12-31 | 3 | Democrat | |||||||||||||
7426 | 7426 | John Hale H000034 | rep | NH | 1843-12-04 | 1845-03-03 | Democrat | -1 | |||||||||||||
7995 | 7995 | Daniel Marcy M000126 | rep | NH | 1863-12-07 | 1865-03-03 | Democrat | 1 | |||||||||||||
8928 | 8928 | Ellery Hibbard H000556 | rep | NH | 1871-03-04 | 1873-03-03 | Democrat | 1 | |||||||||||||
9305 | 9305 | Hosea Parker P000057 | rep | NH | 1871-03-04 | 1873-03-03 | Democrat | 3 | |||||||||||||
9306 | 9306 | Hosea Parker P000057 | rep | NH | 1873-12-01 | 1875-03-03 | Democrat | 3 | |||||||||||||
9449 | 9449 | Samuel Bell B000346 | rep | NH | 1871-03-04 | 1873-03-03 | Democrat | 2 | |||||||||||||
9450 | 9450 | Samuel Bell B000346 | rep | NH | 1875-12-06 | 1877-03-03 | Democrat | 2 | |||||||||||||
9863 | 9863 | Frank Jones J000219 | rep | NH | 1875-12-06 | 1877-03-03 | Democrat | 1 | |||||||||||||
9864 | 9864 | Frank Jones J000219 | rep | NH | 1877-10-15 | 1879-03-03 | Democrat | 1 | |||||||||||||
12147 | 12147 | Warren Daniell D000039 | rep | NH | 1891-12-07 | 1893-03-03 | Democrat | 2 | |||||||||||||
12242 | 12242 | Luther McKinney M000526 | rep | NH | 1887-12-05 | 1889-03-03 | Democrat | 1 | |||||||||||||
12243 | 12243 | Luther McKinney M000526 | rep | NH | 1891-12-07 | 1893-03-03 | Democrat | 1 | |||||||||||||
16403 | 16403 | Henry Hollis H000727 | sen | NH | 1913-04-07 | 1919-03-03 | 2 | Democrat | |||||||||||||
16538 | 16538 | Eugene Reed R000116 | rep | NH | 1913-04-07 | 1915-03-03 | Democrat | 1 | |||||||||||||
16595 | 16595 | Raymond Stevens S000885 | rep | NH | 1913-04-07 | 1915-03-03 | Democrat | 2 | |||||||||||||
21161 | 21161 | Fred Brown B000916 | sen | NH | 1933-03-09 | 1939-01-03 | 3 | Democrat | |||||||||||||
21943 | 21943 | William Rogers R000408 | rep | NH | 1923-12-03 | 1925-03-03 | Democrat | 1 | |||||||||||||
21944 | 21944 | William Rogers R000408 | rep | NH | 1931-12-07 | 1933-03-03 | Democrat | 1 | |||||||||||||
21945 | 21945 | William Rogers R000408 | rep | NH | 1933-03-09 | 1935-01-03 | Democrat | 1 | |||||||||||||
21946 | 21946 | William Rogers R000408 | rep | NH | 1935-01-03 | 1937-01-03 | Democrat | 1 | |||||||||||||
22384 | 22384 | Alphonse Roy R000483 | rep | NH | 1937-01-05 | 1939-01-03 | Democrat | 1 | |||||||||||||
28474 | 28474 | Joseph Huot H001001 | rep | NH | 1965-01-04 | 1967-01-03 | Democrat | 1 | |||||||||||||
30571 | 30571 | Thomas McIntyre M000486 | sen | NH | 1962-01-01 | 1967-01-03 | 2 | Democrat | |||||||||||||
30572 | 30572 | Thomas McIntyre M000486 | sen | NH | 1967-01-10 | 1973-01-03 | 2 | Democrat | |||||||||||||
30573 | 30573 | Thomas McIntyre M000486 | sen | NH | 1973-01-03 | 1979-01-03 | 2 | Democrat | |||||||||||||
30910 | 30910 | John Durkin D000574 | sen | NH | 1975-09-18 | 1980-12-29 | 3 | Democrat | |||||||||||||
32943 | 32943 | Norman D’Amours D000017 | rep | NH | 1975-01-14 | 1977-01-03 | Democrat | 1 | |||||||||||||
32944 | 32944 | Norman D’Amours D000017 | rep | NH | 1977-01-04 | 1979-01-03 | Democrat | 1 | |||||||||||||
32945 | 32945 | Norman D’Amours D000017 | rep | NH | 1979-01-15 | 1981-01-03 | Democrat | 1 | |||||||||||||
32946 | 32946 | Norman D’Amours D000017 | rep | NH | 1981-01-05 | 1983-01-03 | Democrat | 1 | |||||||||||||
32947 | 32947 | Norman D’Amours D000017 | rep | NH | 1983-01-03 | 1985-01-03 | Democrat | 1 | |||||||||||||
35606 | 35606 | Richard Swett S001113 | rep | NH | 1991-01-03 | 1993-01-03 | Democrat | 2 | |||||||||||||
35607 | 35607 | Richard Swett S001113 | rep | NH | 1993-01-05 | 1995-01-03 | Democrat | 2 | |||||||||||||
38583 | 38583 | Paul Hodes H001043 | rep | NH | 2007-01-04 | 2009-01-03 | Democrat | 2 | http://hodes.house.gov | ||||||||||||
38584 | 38584 | Paul Hodes H001043 | rep | NH | 2009-01-06 | 2011-01-03 | Democrat | 2 | http://hodes.house.gov | ||||||||||||
41158 | 41158 | Carol Shea-Porter S001170 | rep | NH | 2007-01-04 | 2009-01-03 | Democrat | 1 | http://shea-porter.house.gov | ||||||||||||
41159 | 41159 | Carol Shea-Porter S001170 | rep | NH | 2009-01-06 | 2011-01-03 | Democrat | 1 | http://shea-porter.house.gov | ||||||||||||
41160 | 41160 | Carol Shea-Porter S001170 | rep | NH | 2013-01-03 | 2015-01-03 | Democrat | 1 | http://shea-porter.house.gov | 1530 Longworth HOB; Washington DC 20515-2901 | 202-225-5456 | 202-228-6362 | https://shea-porter.house.gov/contact/email-me | 1530 Longworth House Office Building | http://shea-porter.house.gov/rss.xml | ||||||
41161 | 41161 | Carol Shea-Porter S001170 | rep | NH | 2017-01-03 | 2019-01-03 | Democrat | 1 | https://shea-porter.house.gov | 1530 Longworth House Office Building; Washington DC 20515-2901 | 202-225-5456 | 202-228-6362 | 1530 Longworth House Office Building | http://shea-porter.house.gov/rss.xml | |||||||
41887 | 41887 | Jeanne Shaheen S001181 | sen | NH | 2009-01-06 | 2015-01-03 | 2 | Democrat | http://www.shaheen.senate.gov | 520 Hart Senate Office Building Washington DC 20510 | 202-224-2841 | 202-228-3194 | http://www.shaheen.senate.gov/contact/ | 520 Hart Senate Office Building | senior | http://www.shaheen.senate.gov/rss/ | |||||
41888 | 41888 | Jeanne Shaheen S001181 | sen | NH | 2015-01-06 | 2021-01-03 | 2 | Democrat | https://www.shaheen.senate.gov | 506 Hart Senate Office Building Washington DC 20510 | 202-224-2841 | 202-228-3194 | https://www.shaheen.senate.gov/contact/contact-jeanne | 506 Hart Senate Office Building | senior | http://www.shaheen.senate.gov/rss/ | |||||
41889 | 41889 | Jeanne Shaheen S001181 | sen | NH | 2021-01-03 | 2027-01-03 | 2 | Democrat | https://www.shaheen.senate.gov | 506 Hart Senate Office Building Washington DC 20510 | 202-224-2841 | https://www.shaheen.senate.gov/contact/contact-jeanne | 506 Hart Senate Office Building | senior | http://www.shaheen.senate.gov/rss/ | ||||||
43814 | 43814 | Ann Kuster K000382 | rep | NH | 2013-01-03 | 2015-01-03 | Democrat | 2 | http://kuster.house.gov | 137 Cannon HOB; Washington DC 20515-2902 | 202-225-5206 | 202-225-2946 | https://kuster.house.gov/contact/email-me | 137 Cannon House Office Building | http://kuster.house.gov/rss.xml | ||||||
43815 | 43815 | Ann Kuster K000382 | rep | NH | 2015-01-06 | 2017-01-03 | Democrat | 2 | http://kuster.house.gov | 137 Cannon HOB; Washington DC 20515-2902 | 202-225-5206 | 202-225-2946 | https://kuster.house.gov/contact/email-me | 137 Cannon House Office Building | http://kuster.house.gov/rss.xml | ||||||
43816 | 43816 | Ann Kuster K000382 | rep | NH | 2017-01-03 | 2019-01-03 | Democrat | 2 | https://kuster.house.gov | 137 Cannon House Office Building; Washington DC 20515-2902 | 202-225-5206 | 202-225-2946 | 137 Cannon House Office Building | http://kuster.house.gov/rss.xml | |||||||
43817 | 43817 | Ann Kuster K000382 | rep | NH | 2019-01-03 | 2021-01-03 | Democrat | 2 | https://kuster.house.gov | 320 Cannon House Office Building Washington DC 20515-2902 | 202-225-5206 | 320 Cannon House Office Building | http://kuster.house.gov/rss.xml | ||||||||
43818 | 43818 | Ann Kuster K000382 | rep | NH | 2021-01-03 | 2023-01-03 | Democrat | 2 | https://kuster.house.gov | 320 Cannon House Office Building Washington DC 20515-2902 | 202-225-5206 | 320 Cannon House Office Building | http://kuster.house.gov/rss.xml | ||||||||
44103 | 44103 | Margaret Hassan H001076 | sen | NH | 2017-01-03 | 2023-01-03 | 3 | Democrat | https://www.hassan.senate.gov | 324 Hart Senate Office Building Washington DC 20510 | 202-224-3324 | https://www.hassan.senate.gov/content/contact-senator | 324 Hart Senate Office Building | junior | |||||||
44348 | 44348 | Chris Pappas P000614 | rep | NH | 2019-01-03 | 2021-01-03 | Democrat | 1 | https://pappas.house.gov | 323 Cannon House Office Building Washington DC 20515-2901 | 202-225-5456 | 323 Cannon House Office Building | |||||||||
44349 | 44349 | Chris Pappas P000614 | rep | NH | 2021-01-03 | 2023-01-03 | Democrat | 1 | https://pappas.house.gov | 319 Cannon House Office Building Washington DC 20515-2901 | 202-225-5456 | 319 Cannon House Office Building |
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);