legislator_terms
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
99 rows where state = "HI" and type = "rep"
This data as json, copyable, CSV (advanced)
Suggested facets: legislator_id, district, address, fax, contact_form, rss_url, 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 | |||||||||||||
27811 | 27811 | Thomas Gill G000192 | rep | HI | 1963-01-09 | 1965-01-03 | Democrat | 1 | |||||||||||||
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 | |||||||||||||
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 | |||||||||||||
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 | |||||||||||||
40189 | 40189 | Mark Takai T000473 | rep | HI | 2015-01-06 | 2016-07-20 | Democrat | 1 | https://takai.house.gov | 422 Cannon HOB; Washington DC 20515-1101 | 202-225-2726 | 202-225-0688 | 422 Cannon House Office Building | ||||||||
41154 | 41154 | Colleen Hanabusa H001050 | rep | HI | 2011-01-05 | 2013-01-03 | Democrat | 1 | http://hanabusa.house.gov/ | 238 Cannon HOB; Washington DC 20515-1101 | 202-225-2726 | 202-225-4580 | 238 Cannon House Office Building | ||||||||
41155 | 41155 | Colleen Hanabusa H001050 | rep | HI | 2013-01-03 | 2015-01-03 | Democrat | 1 | http://hanabusa.house.gov | 238 Cannon HOB; Washington DC 20515-1101 | 202-225-2726 | 202-225-4580 | https://hanabusa.house.gov/contact-me/email-me | 238 Cannon House Office Building | http://hanabusa.house.gov/rss.xml | ||||||
41156 | 41156 | Colleen Hanabusa H001050 | rep | HI | 2016-11-14 | 2017-01-03 | Democrat | 1 | https://hanabusa.house.gov/ | 422 Cannon HOB; Washington DC 20515-1101 | 202-225-2726 | 202-225-0688 | https://hanabusa.house.gov/contact/email | 422 Cannon House Office Building | https://hanabusa.house.gov/rss.xml | ||||||
41157 | 41157 | Colleen Hanabusa H001050 | rep | HI | 2017-01-03 | 2019-01-03 | Democrat | 1 | https://hanabusa.house.gov | 422 Cannon House Office Building; Washington DC 20515-1101 | 202-225-2726 | 202-225-0688 | 422 Cannon House Office Building | https://hanabusa.house.gov/rss.xml | |||||||
41554 | 41554 | Tulsi Gabbard G000571 | rep | HI | 2013-01-03 | 2015-01-03 | Democrat | 2 | http://gabbard.house.gov | 502 Cannon HOB; Washington DC 20515-1102 | 202-225-4906 | 202-225-4987 | https://forms.house.gov/formsgabbard/webforms/email-me.shtml | 502 Cannon House Office Building | http://gabbard.house.gov/rss.xml | ||||||
41555 | 41555 | Tulsi Gabbard G000571 | rep | HI | 2015-01-06 | 2017-01-03 | Democrat | 2 | http://gabbard.house.gov | 1609 Longworth HOB; Washington DC 20515-1102 | 202-225-4906 | 202-225-4987 | https://forms.house.gov/formsgabbard/webforms/email-me.shtml | 1609 Longworth House Office Building | http://gabbard.house.gov/rss.xml | ||||||
41556 | 41556 | Tulsi Gabbard G000571 | rep | HI | 2017-01-03 | 2019-01-03 | Democrat | 2 | https://gabbard.house.gov | 1433 Longworth House Office Building; Washington DC 20515-1102 | 202-225-4906 | 202-225-4987 | 1433 Longworth House Office Building | http://gabbard.house.gov/rss.xml | |||||||
41557 | 41557 | Tulsi Gabbard G000571 | rep | HI | 2019-01-03 | 2021-01-03 | Democrat | 2 | https://gabbard.house.gov | 1433 Longworth House Office Building Washington DC 20515-1102 | 202-225-4906 | 1433 Longworth House Office Building | http://gabbard.house.gov/rss.xml | ||||||||
42525 | 42525 | Mazie Hirono H001042 | rep | HI | 2007-01-04 | 2009-01-03 | Democrat | 2 | http://hirono.house.gov | ||||||||||||
42526 | 42526 | Mazie Hirono H001042 | rep | HI | 2009-01-06 | 2011-01-03 | Democrat | 2 | http://hirono.house.gov | ||||||||||||
42527 | 42527 | Mazie Hirono H001042 | rep | HI | 2011-01-05 | 2013-01-03 | Democrat | 2 | http://hirono.house.gov | 1410 Longworth HOB; Washington DC 20515-1102 | 202-225-4906 | 202-225-4987 | http://hirono.house.gov/IMA/issue_subscribe.htm | 1410 Longworth House Office Building | |||||||
44272 | 44272 | Ed Case C001055 | rep | HI | 2003-01-07 | 2005-01-03 | Democrat | 2 | http://www.house.gov/case | ||||||||||||
44273 | 44273 | Ed Case C001055 | rep | HI | 2005-01-04 | 2007-01-03 | Democrat | 2 | http://www.house.gov/case | ||||||||||||
44274 | 44274 | Ed Case C001055 | rep | HI | 2019-01-03 | 2021-01-03 | Democrat | 1 | https://case.house.gov | 2443 Rayburn House Office Building Washington DC 20515-1101 | 202-225-2726 | 2443 Rayburn House Office Building | |||||||||
44275 | 44275 | Ed Case C001055 | rep | HI | 2021-01-03 | 2023-01-03 | Democrat | 1 | https://case.house.gov | 2210 Rayburn House Office Building Washington DC 20515-1101 | 202-225-2726 | 2210 Rayburn House Office Building | |||||||||
44490 | 44490 | Kaialiʻi Kahele K000396 | rep | HI | 2021-01-03 | 2023-01-03 | Democrat | 2 | https://kahele.house.gov | 1205 Longworth House Office Building Washington DC 20515-1102 | 202-225-4906 | 1205 Longworth 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);