legislator_terms
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
35 rows where party = "Republican", state = "ND" and type = "sen" sorted by contact_form
This data as json, copyable, CSV (advanced)
Suggested facets: legislator_id, class, address, office, 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
11656 | 11656 | Lyman Casey C000227 | sen | ND | 1889-12-02 | 1893-03-03 | 1 | Republican | |||||||||||||
11903 | 11903 | Gilbert Pierce P000334 | sen | ND | 1889-12-02 | 1891-03-03 | 3 | Republican | |||||||||||||
14342 | 14342 | Henry Hansbrough H000169 | sen | ND | 1891-12-07 | 1897-03-03 | 3 | Republican | |||||||||||||
14343 | 14343 | Henry Hansbrough H000169 | sen | ND | 1897-03-15 | 1903-03-03 | 3 | Republican | |||||||||||||
14344 | 14344 | Henry Hansbrough H000169 | sen | ND | 1903-11-09 | 1909-03-03 | 3 | Republican | |||||||||||||
15562 | 15562 | Martin Johnson J000162 | sen | ND | 1909-03-15 | 1909-12-31 | 3 | Republican | |||||||||||||
16772 | 16772 | Asle Gronna G000491 | sen | ND | 1911-04-04 | 1915-03-03 | 3 | Republican | |||||||||||||
16773 | 16773 | Asle Gronna G000491 | sen | ND | 1915-12-06 | 1921-03-03 | 3 | Republican | |||||||||||||
17347 | 17347 | Porter McCumber M000397 | sen | ND | 1899-12-04 | 1905-03-03 | 1 | Republican | |||||||||||||
17348 | 17348 | Porter McCumber M000397 | sen | ND | 1905-12-04 | 1911-03-03 | 1 | Republican | |||||||||||||
17349 | 17349 | Porter McCumber M000397 | sen | ND | 1911-04-04 | 1917-03-03 | 1 | Republican | |||||||||||||
17350 | 17350 | Porter McCumber M000397 | sen | ND | 1917-04-02 | 1923-03-03 | 1 | Republican | |||||||||||||
18302 | 18302 | Edwin Ladd L000012 | sen | ND | 1921-04-11 | 1925-12-31 | 3 | Republican | |||||||||||||
21765 | 21765 | Lynn Frazier F000354 | sen | ND | 1923-12-03 | 1929-03-03 | 1 | Republican | |||||||||||||
21766 | 21766 | Lynn Frazier F000354 | sen | ND | 1929-04-15 | 1935-01-03 | 1 | Republican | |||||||||||||
21767 | 21767 | Lynn Frazier F000354 | sen | ND | 1935-01-03 | 1941-01-03 | 1 | Republican | |||||||||||||
22734 | 22734 | Gerald Nye N000176 | sen | ND | 1925-12-07 | 1927-03-04 | 3 | Republican | appointment | ||||||||||||
22735 | 22735 | Gerald Nye N000176 | sen | ND | 1927-12-05 | 1933-03-03 | 3 | Republican | |||||||||||||
22736 | 22736 | Gerald Nye N000176 | sen | ND | 1933-03-09 | 1939-01-03 | 3 | Republican | |||||||||||||
22737 | 22737 | Gerald Nye N000176 | sen | ND | 1939-01-03 | 1945-01-03 | 3 | Republican | |||||||||||||
25743 | 25743 | William Langer L000070 | sen | ND | 1941-01-03 | 1947-01-03 | 1 | Republican | |||||||||||||
25744 | 25744 | William Langer L000070 | sen | ND | 1947-01-03 | 1953-01-03 | 1 | Republican | |||||||||||||
25745 | 25745 | William Langer L000070 | sen | ND | 1953-01-03 | 1959-01-03 | 1 | Republican | |||||||||||||
25746 | 25746 | William Langer L000070 | sen | ND | 1959-01-03 | 1959-11-08 | 1 | Republican | |||||||||||||
26762 | 26762 | Clarence Brunsdale B000982 | sen | ND | 1959-11-19 | 1961-01-03 | 1 | Republican | appointment | ||||||||||||
31402 | 31402 | Milton Young Y000047 | sen | ND | 1945-03-12 | 1951-01-03 | 3 | Republican | appointment | ||||||||||||
31403 | 31403 | Milton Young Y000047 | sen | ND | 1951-01-03 | 1957-01-03 | 3 | Republican | |||||||||||||
31404 | 31404 | Milton Young Y000047 | sen | ND | 1957-01-03 | 1963-01-03 | 3 | Republican | |||||||||||||
31405 | 31405 | Milton Young Y000047 | sen | ND | 1963-01-09 | 1969-01-03 | 3 | Republican | |||||||||||||
31406 | 31406 | Milton Young Y000047 | sen | ND | 1969-01-03 | 1975-01-03 | 3 | Republican | |||||||||||||
31407 | 31407 | Milton Young Y000047 | sen | ND | 1975-01-14 | 1981-01-03 | 3 | Republican | |||||||||||||
32444 | 32444 | Mark Andrews A000208 | sen | ND | 1981-01-05 | 1987-01-03 | 3 | Republican | |||||||||||||
42530 | 42530 | John Hoeven H001061 | sen | ND | 2011-01-05 | 2017-01-03 | 3 | Republican | https://www.hoeven.senate.gov | 338 Russell Senate Office Building Washington DC 20510 | 202-224-2551 | 202-224-7999 | http://www.hoeven.senate.gov/public/index.cfm/email-the-senator | 338 Russell Senate Office Building | senior | http://www.hoeven.senate.gov/public/index.cfm/rss/feed | |||||
43811 | 43811 | Kevin Cramer C001096 | sen | ND | 2019-01-03 | 2025-01-03 | 1 | Republican | https://www.cramer.senate.gov | 330 Hart Senate Office Building Washington DC 20510 | 202-224-2043 | https://www.cramer.senate.gov/contact/contact-kevin | 330 Hart Senate Office Building | junior | |||||||
42531 | 42531 | John Hoeven H001061 | sen | ND | 2017-01-03 | 2023-01-03 | 3 | Republican | https://www.hoeven.senate.gov | 338 Russell Senate Office Building Washington DC 20510 | 202-224-2551 | 202-224-7999 | https://www.hoeven.senate.gov/contact/email-the-senator/form | 338 Russell Senate Office Building | senior | http://www.hoeven.senate.gov/public/index.cfm/rss/feed |
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);