legislator_terms
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
124 rows where state = "HI"
This data as json, copyable, CSV (advanced)
Suggested facets: legislator_id, start, end, class, district, url, address, phone, fax, contact_form, office, state_rank, 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
14216 | 14216 | Robert Wilcox W000459 | rep | HI | 1899-12-04 | 1901-03-03 | -1 | ||||||||||||||
14217 | 14217 | Robert Wilcox W000459 | rep | HI | 1901-12-02 | 1903-03-03 | -1 | ||||||||||||||
18039 | 18039 | Henry Baldwin B000088 | rep | HI | 1921-04-11 | 1923-03-03 | Republican | -1 | |||||||||||||
18257 | 18257 | Jonah Kalanianaole K000004 | rep | HI | 1903-11-09 | 1905-03-03 | Republican | -1 | |||||||||||||
18258 | 18258 | Jonah Kalanianaole K000004 | rep | HI | 1905-12-04 | 1907-03-03 | Republican | -1 | |||||||||||||
18259 | 18259 | Jonah Kalanianaole K000004 | rep | HI | 1907-12-02 | 1909-03-03 | Republican | -1 | |||||||||||||
18260 | 18260 | Jonah Kalanianaole K000004 | rep | HI | 1909-03-15 | 1911-03-03 | Republican | -1 | |||||||||||||
18261 | 18261 | Jonah Kalanianaole K000004 | rep | HI | 1911-04-04 | 1913-03-03 | Republican | -1 | |||||||||||||
18262 | 18262 | Jonah Kalanianaole K000004 | rep | HI | 1913-04-07 | 1915-03-03 | Republican | -1 | |||||||||||||
18263 | 18263 | Jonah Kalanianaole K000004 | rep | HI | 1915-12-06 | 1917-03-03 | Republican | -1 | |||||||||||||
18264 | 18264 | Jonah Kalanianaole K000004 | rep | HI | 1917-04-02 | 1919-03-03 | Republican | -1 | |||||||||||||
18265 | 18265 | Jonah Kalanianaole K000004 | rep | HI | 1919-05-19 | 1921-03-03 | Republican | -1 | |||||||||||||
18266 | 18266 | Jonah Kalanianaole K000004 | rep | HI | 1921-04-11 | 1923-03-03 | Republican | -1 | |||||||||||||
18993 | 18993 | William Jarrett J000061 | rep | HI | 1923-12-03 | 1925-03-03 | Democrat | -1 | |||||||||||||
18994 | 18994 | William Jarrett J000061 | rep | HI | 1925-12-07 | 1927-03-04 | Democrat | -1 | |||||||||||||
20536 | 20536 | Victor Houston H000828 | rep | HI | 1927-12-05 | 1929-03-03 | Republican | -1 | |||||||||||||
20537 | 20537 | Victor Houston H000828 | rep | HI | 1929-04-15 | 1931-03-03 | Republican | -1 | |||||||||||||
20538 | 20538 | Victor Houston H000828 | rep | HI | 1931-12-07 | 1933-03-03 | Republican | -1 | |||||||||||||
21398 | 21398 | Lincoln McCandless M000307 | rep | HI | 1933-03-09 | 1935-01-03 | Democrat | 0 | |||||||||||||
23079 | 23079 | Samuel King K000214 | rep | HI | 1935-01-03 | 1937-01-03 | Republican | 0 | |||||||||||||
23080 | 23080 | Samuel King K000214 | rep | HI | 1937-01-05 | 1939-01-03 | Republican | 0 | |||||||||||||
23081 | 23081 | Samuel King K000214 | rep | HI | 1939-01-03 | 1941-01-03 | Republican | 0 | |||||||||||||
23082 | 23082 | Samuel King K000214 | rep | HI | 1941-01-03 | 1943-01-03 | Republican | 0 | |||||||||||||
25664 | 25664 | Joseph Farrington F000034 | rep | HI | 1943-01-06 | 1945-01-03 | Republican | 0 | |||||||||||||
25665 | 25665 | Joseph Farrington F000034 | rep | HI | 1945-01-03 | 1947-01-03 | Republican | 0 | |||||||||||||
25666 | 25666 | Joseph Farrington F000034 | rep | HI | 1947-01-03 | 1949-01-03 | Republican | 0 | |||||||||||||
25667 | 25667 | Joseph Farrington F000034 | rep | HI | 1949-01-03 | 1951-01-03 | Republican | 0 | |||||||||||||
25668 | 25668 | Joseph Farrington F000034 | rep | HI | 1951-01-03 | 1953-01-03 | Republican | 0 | |||||||||||||
25669 | 25669 | Joseph Farrington F000034 | rep | HI | 1953-01-03 | 1955-01-03 | Republican | 0 | |||||||||||||
25951 | 25951 | Mary Farrington F000035 | rep | HI | 1953-01-03 | 1955-01-03 | Republican | 0 | |||||||||||||
25952 | 25952 | Mary Farrington F000035 | rep | HI | 1955-01-05 | 1957-01-03 | Republican | 0 | |||||||||||||
26768 | 26768 | John Burns B001127 | rep | HI | 1957-01-03 | 1959-01-03 | Democrat | 0 | |||||||||||||
26769 | 26769 | John Burns B001127 | rep | HI | 1959-01-07 | 1961-01-03 | Democrat | 0 | |||||||||||||
26905 | 26905 | Oren Long L000425 | sen | HI | 1959-01-07 | 1963-01-03 | 3 | Democrat | |||||||||||||
27811 | 27811 | Thomas Gill G000192 | rep | HI | 1963-01-09 | 1965-01-03 | Democrat | 1 | |||||||||||||
29773 | 29773 | Hiram Fong F000245 | sen | HI | 1959-01-07 | 1965-01-03 | 1 | Republican | |||||||||||||
29774 | 29774 | Hiram Fong F000245 | sen | HI | 1965-01-04 | 1971-01-03 | 1 | Republican | |||||||||||||
29775 | 29775 | Hiram Fong F000245 | sen | HI | 1971-01-21 | 1977-01-03 | 1 | Republican | |||||||||||||
33292 | 33292 | Cecil Heftel H000449 | rep | HI | 1977-01-04 | 1979-01-03 | Democrat | 1 | |||||||||||||
33293 | 33293 | Cecil Heftel H000449 | rep | HI | 1979-01-15 | 1981-01-03 | Democrat | 1 | |||||||||||||
33294 | 33294 | Cecil Heftel H000449 | rep | HI | 1981-01-05 | 1983-01-03 | Democrat | 1 | |||||||||||||
33295 | 33295 | Cecil Heftel H000449 | rep | HI | 1983-01-03 | 1985-01-03 | Democrat | 1 | |||||||||||||
33296 | 33296 | Cecil Heftel H000449 | rep | HI | 1985-01-03 | 1987-01-03 | Democrat | 1 | |||||||||||||
34003 | 34003 | Spark Matsunaga M000250 | rep | HI | 1963-01-09 | 1965-01-03 | Democrat | 2 | |||||||||||||
34004 | 34004 | Spark Matsunaga M000250 | rep | HI | 1965-01-04 | 1967-01-03 | Democrat | 2 | |||||||||||||
34005 | 34005 | Spark Matsunaga M000250 | rep | HI | 1967-01-10 | 1969-01-03 | Democrat | 2 | |||||||||||||
34006 | 34006 | Spark Matsunaga M000250 | rep | HI | 1969-01-03 | 1971-01-03 | Democrat | 2 | |||||||||||||
34007 | 34007 | Spark Matsunaga M000250 | rep | HI | 1971-01-21 | 1973-01-03 | Democrat | 1 | |||||||||||||
34008 | 34008 | Spark Matsunaga M000250 | rep | HI | 1973-01-03 | 1975-01-03 | Democrat | 1 | |||||||||||||
34009 | 34009 | Spark Matsunaga M000250 | rep | HI | 1975-01-14 | 1977-01-03 | Democrat | 1 | |||||||||||||
34010 | 34010 | Spark Matsunaga M000250 | sen | HI | 1977-01-04 | 1983-01-03 | 1 | Democrat | |||||||||||||
34011 | 34011 | Spark Matsunaga M000250 | sen | HI | 1983-01-03 | 1989-01-03 | 1 | Democrat | |||||||||||||
34012 | 34012 | Spark Matsunaga M000250 | sen | HI | 1989-01-03 | 1991-01-03 | 1 | Democrat | |||||||||||||
34077 | 34077 | Patricia Saiki S000014 | rep | HI | 1987-01-06 | 1989-01-03 | Republican | 1 | |||||||||||||
34078 | 34078 | Patricia Saiki S000014 | rep | HI | 1989-01-03 | 1991-01-03 | Republican | 1 | |||||||||||||
37027 | 37027 | Patsy Mink M000797 | rep | HI | 1965-01-04 | 1967-01-03 | Democrat | 1 | |||||||||||||
37028 | 37028 | Patsy Mink M000797 | rep | HI | 1967-01-10 | 1969-01-03 | Democrat | 1 | |||||||||||||
37029 | 37029 | Patsy Mink M000797 | rep | HI | 1969-01-03 | 1971-01-03 | Democrat | 1 | |||||||||||||
37030 | 37030 | Patsy Mink M000797 | rep | HI | 1971-01-21 | 1973-01-03 | Democrat | 2 | |||||||||||||
37031 | 37031 | Patsy Mink M000797 | rep | HI | 1973-01-03 | 1975-01-03 | Democrat | 2 | |||||||||||||
37032 | 37032 | Patsy Mink M000797 | rep | HI | 1975-01-14 | 1977-01-03 | Democrat | 2 | |||||||||||||
37033 | 37033 | Patsy Mink M000797 | rep | HI | 1990-09-22 | 1991-01-03 | Democrat | 2 | |||||||||||||
37034 | 37034 | Patsy Mink M000797 | rep | HI | 1991-01-03 | 1993-01-03 | Democrat | 2 | |||||||||||||
37035 | 37035 | Patsy Mink M000797 | rep | HI | 1993-01-05 | 1995-01-03 | Democrat | 2 | |||||||||||||
37036 | 37036 | Patsy Mink M000797 | rep | HI | 1995-01-04 | 1997-01-03 | Democrat | 2 | |||||||||||||
37037 | 37037 | Patsy Mink M000797 | rep | HI | 1997-01-07 | 1999-01-03 | Democrat | 2 | |||||||||||||
37038 | 37038 | Patsy Mink M000797 | rep | HI | 1999-01-06 | 2001-01-03 | Democrat | 2 | |||||||||||||
37039 | 37039 | Patsy Mink M000797 | rep | HI | 2001-01-03 | 2002-09-28 | Democrat | 2 | |||||||||||||
38394 | 38394 | Neil Abercrombie A000014 | rep | HI | 1985-01-03 | 1987-01-03 | Democrat | 1 | |||||||||||||
38395 | 38395 | Neil Abercrombie A000014 | rep | HI | 1991-01-03 | 1993-01-03 | Democrat | 1 | |||||||||||||
38396 | 38396 | Neil Abercrombie A000014 | rep | HI | 1993-01-05 | 1995-01-03 | Democrat | 1 | |||||||||||||
38397 | 38397 | Neil Abercrombie A000014 | rep | HI | 1995-01-04 | 1997-01-03 | Democrat | 1 | |||||||||||||
38398 | 38398 | Neil Abercrombie A000014 | rep | HI | 1997-01-07 | 1999-01-03 | Democrat | 1 | |||||||||||||
38399 | 38399 | Neil Abercrombie A000014 | rep | HI | 1999-01-06 | 2001-01-03 | Democrat | 1 | |||||||||||||
38400 | 38400 | Neil Abercrombie A000014 | rep | HI | 2001-01-03 | 2003-01-03 | Democrat | 1 | |||||||||||||
38401 | 38401 | Neil Abercrombie A000014 | rep | HI | 2003-01-07 | 2005-01-03 | Democrat | 1 | http://www.house.gov/abercrombie | ||||||||||||
38402 | 38402 | Neil Abercrombie A000014 | rep | HI | 2005-01-04 | 2007-01-03 | Democrat | 1 | http://www.house.gov/abercrombie | ||||||||||||
38403 | 38403 | Neil Abercrombie A000014 | rep | HI | 2007-01-04 | 2009-01-03 | Democrat | 1 | http://www.house.gov/abercrombie | ||||||||||||
38404 | 38404 | Neil Abercrombie A000014 | rep | HI | 2009-01-06 | 2010-03-01 | Democrat | 1 | http://www.house.gov/abercrombie | ||||||||||||
38935 | 38935 | Charles Djou D000611 | rep | HI | 2010-05-22 | 2011-01-03 | Republican | 1 | http://djou.house.gov/ | ||||||||||||
39019 | 39019 | Daniel Inouye I000025 | rep | HI | 1959-01-07 | 1961-01-03 | Democrat | 0 | |||||||||||||
39020 | 39020 | Daniel Inouye I000025 | rep | HI | 1961-01-03 | 1963-01-03 | Democrat | 0 | |||||||||||||
39021 | 39021 | Daniel Inouye I000025 | sen | HI | 1963-01-09 | 1969-01-03 | 3 | Democrat | |||||||||||||
39022 | 39022 | Daniel Inouye I000025 | sen | HI | 1969-01-03 | 1975-01-03 | 3 | Democrat | |||||||||||||
39023 | 39023 | Daniel Inouye I000025 | sen | HI | 1975-01-14 | 1981-01-03 | 3 | Democrat | |||||||||||||
39024 | 39024 | Daniel Inouye I000025 | sen | HI | 1981-01-05 | 1987-01-03 | 3 | Democrat | |||||||||||||
39025 | 39025 | Daniel Inouye I000025 | sen | HI | 1987-01-06 | 1993-01-03 | 3 | Democrat | |||||||||||||
39026 | 39026 | Daniel Inouye I000025 | sen | HI | 1993-01-05 | 1999-01-03 | 3 | Democrat | |||||||||||||
39027 | 39027 | Daniel Inouye I000025 | sen | HI | 1999-01-06 | 2005-01-03 | 3 | Democrat | http://inouye.senate.gov/ | ||||||||||||
39028 | 39028 | Daniel Inouye I000025 | sen | HI | 2005-01-04 | 2011-01-03 | 3 | Democrat | http://inouye.senate.gov/ | ||||||||||||
39029 | 39029 | Daniel Inouye I000025 | sen | HI | 2011-01-05 | 2012-12-17 | 3 | Democrat | http://inouye.senate.gov/ | 722 HART SENATE OFFICE BUILDING WASHINGTON DC 20510 | 202-224-3934 | 202-224-6747 | http://www.inouye.senate.gov/Contact/ContactDKI.cfm | 722 Hart Senate Office Building | |||||||
39030 | 39030 | Daniel Akaka A000069 | rep | HI | 1977-01-04 | 1979-01-03 | Democrat | 2 | |||||||||||||
39031 | 39031 | Daniel Akaka A000069 | rep | HI | 1979-01-15 | 1981-01-03 | Democrat | 2 | |||||||||||||
39032 | 39032 | Daniel Akaka A000069 | rep | HI | 1981-01-05 | 1983-01-03 | Democrat | 2 | |||||||||||||
39033 | 39033 | Daniel Akaka A000069 | rep | HI | 1983-01-03 | 1985-01-03 | Democrat | 2 | |||||||||||||
39034 | 39034 | Daniel Akaka A000069 | rep | HI | 1985-01-03 | 1987-01-03 | Democrat | 2 | |||||||||||||
39035 | 39035 | Daniel Akaka A000069 | rep | HI | 1987-01-06 | 1989-01-03 | Democrat | 2 | |||||||||||||
39036 | 39036 | Daniel Akaka A000069 | rep | HI | 1989-01-03 | 1990-05-15 | Democrat | 2 | |||||||||||||
39037 | 39037 | Daniel Akaka A000069 | sen | HI | 1990-05-16 | 1995-01-03 | 1 | Democrat | appointment | ||||||||||||
39038 | 39038 | Daniel Akaka A000069 | sen | HI | 1995-01-04 | 2001-01-03 | 1 | Democrat |
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);