legislator_terms
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
90 rows where party = "Democrat" and state = "HI"
This data as json, copyable, CSV (advanced)
Suggested facets: legislator_id, type, class, district, url, address, phone, contact_form, office, rss_url, start (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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 | |||||||||||||
21398 | 21398 | Lincoln McCandless M000307 | rep | HI | 1933-03-09 | 1935-01-03 | Democrat | 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 | |||||||||||||
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 | |||||||||||||
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 | ||||||||||||
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 | |||||||||||||
39039 | 39039 | Daniel Akaka A000069 | sen | HI | 2001-01-03 | 2007-01-03 | 1 | Democrat | http://akaka.senate.gov | ||||||||||||
39040 | 39040 | Daniel Akaka A000069 | sen | HI | 2007-01-04 | 2013-01-03 | 1 | Democrat | http://akaka.senate.gov | 141 HART SENATE OFFICE BUILDING WASHINGTON DC 20510 | 202-224-6361 | 202-224-2126 | http://www.akaka.senate.gov/email-senator-akaka.cfm | 141 Hart Senate Office Building | |||||||
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 | |||||||
42528 | 42528 | Mazie Hirono H001042 | sen | HI | 2013-01-03 | 2019-01-03 | 1 | Democrat | https://www.hirono.senate.gov | 730 Hart Senate Office Building Washington DC 20510 | 202-224-6361 | 202-225-4987 | https://www.hirono.senate.gov/contact | 730 Hart Senate Office Building | junior | http://www.hirono.senate.gov/rss/feeds/?type=all | |||||
42529 | 42529 | Mazie Hirono H001042 | sen | HI | 2019-01-03 | 2025-01-03 | 1 | Democrat | https://www.hirono.senate.gov | 109 Hart Senate Office Building Washington DC 20510 | 202-224-6361 | https://www.hirono.senate.gov/contact | 109 Hart Senate Office Building | junior | http://www.hirono.senate.gov/rss/feeds/?type=all | ||||||
43685 | 43685 | Brian Schatz S001194 | sen | HI | 2012-12-27 | 2015-01-03 | 3 | Democrat | appointment | http://www.schatz.senate.gov | 722 Hart Senate Office Building Washington DC 20510 | 202-224-3934 | 202-228-1153 | http://www.schatz.senate.gov/contact | 722 Hart Senate Office Building | senior | |||||
43686 | 43686 | Brian Schatz S001194 | sen | HI | 2015-01-06 | 2017-01-03 | 3 | Democrat | http://www.schatz.senate.gov | 722 Hart Senate Office Building Washington DC 20510 | 202-224-3934 | 202-228-1153 | http://www.schatz.senate.gov/contact | 722 Hart Senate Office Building | senior | ||||||
43687 | 43687 | Brian Schatz S001194 | sen | HI | 2017-01-03 | 2023-01-03 | 3 | Democrat | https://www.schatz.senate.gov | 722 Hart Senate Office Building Washington DC 20510 | 202-224-3934 | 202-228-1153 | https://www.schatz.senate.gov/contact | 722 Hart Senate Office Building | senior | ||||||
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);