legislator_terms
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
755 rows where state = "IA" sorted by rowid descending
This data as json, copyable, CSV (advanced)
Suggested facets: class, district, url, address, fax, contact_form, state_rank, rss_url, start (date), end (date)
party 6 ✖
- Republican 592
- Democrat 154
- National Greenbacker 5
- Whig 2
- Ind. Republican 1
- Ind. Republican-Democrat 1
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
44493 | 44493 | Randy Feenstra F000446 | rep | IA | 2021-01-03 | 2023-01-03 | Republican | 4 | https://feenstra.house.gov | 1440 Longworth House Office Building Washington DC 20515-1504 | 202-225-4426 | 1440 Longworth House Office Building | |||||||||
44492 | 44492 | Mariannette Miller-Meeks M001215 | rep | IA | 2021-01-03 | 2023-01-03 | Republican | 2 | https://millermeeks.house.gov | 1716 Longworth House Office Building Washington DC 20515-1502 | 202-225-6576 | 1716 Longworth House Office Building | |||||||||
44491 | 44491 | Ashley Hinson H001091 | rep | IA | 2021-01-03 | 2023-01-03 | Republican | 1 | https://hinson.house.gov | 1429 Longworth House Office Building Washington DC 20515-1501 | 202-225-2911 | 1429 Longworth House Office Building | |||||||||
44307 | 44307 | Cynthia Axne A000378 | rep | IA | 2021-01-03 | 2023-01-03 | Democrat | 3 | https://axne.house.gov | 1034 Longworth House Office Building Washington DC 20515-1503 | 202-225-5476 | 1034 Longworth House Office Building | |||||||||
44306 | 44306 | Cynthia Axne A000378 | rep | IA | 2019-01-03 | 2021-01-03 | Democrat | 3 | https://axne.house.gov | 330 Cannon House Office Building Washington DC 20515-1503 | 202-225-5476 | 330 Cannon House Office Building | |||||||||
44075 | 44075 | Joni Ernst E000295 | sen | IA | 2021-01-03 | 2027-01-03 | 2 | Republican | https://www.ernst.senate.gov | 730 Hart Senate Office Building Washington DC 20510 | 202-224-3254 | https://www.ernst.senate.gov/public/index.cfm/contact | 730 Hart Senate Office Building | junior | |||||||
44074 | 44074 | Joni Ernst E000295 | sen | IA | 2015-01-06 | 2021-01-03 | 2 | Republican | https://www.ernst.senate.gov/public | 730 Hart Senate Office Building Washington DC 20510 | 202-224-3254 | https://www.ernst.senate.gov/public/index.cfm/contact | 730 Hart Senate Office Building | junior | |||||||
42443 | 42443 | Charles Grassley G000386 | sen | IA | 2017-01-03 | 2023-01-03 | 3 | Republican | https://www.grassley.senate.gov | 135 Hart Senate Office Building Washington DC 20510 | 202-224-3744 | 202-224-6020 | https://www.grassley.senate.gov/contact | 135 Hart Senate Office Building | senior | http://grassley.senate.gov/customcf/rss_feed.cfm | |||||
42442 | 42442 | Charles Grassley G000386 | sen | IA | 2011-01-05 | 2017-01-03 | 3 | Republican | http://www.grassley.senate.gov | 135 Hart Senate Office Building Washington DC 20510 | 202-224-3744 | 202-224-6020 | http://www.grassley.senate.gov/constituents/questions-and-comments | 135 Hart Senate Office Building | senior | http://grassley.senate.gov/customcf/rss_feed.cfm | |||||
42441 | 42441 | Charles Grassley G000386 | sen | IA | 2005-01-04 | 2011-01-03 | 3 | Republican | http://grassley.senate.gov | ||||||||||||
42440 | 42440 | Charles Grassley G000386 | sen | IA | 1999-01-06 | 2005-01-03 | 3 | Republican | http://grassley.senate.gov/ | ||||||||||||
42439 | 42439 | Charles Grassley G000386 | sen | IA | 1993-01-05 | 1999-01-03 | 3 | Republican | |||||||||||||
42438 | 42438 | Charles Grassley G000386 | sen | IA | 1987-01-06 | 1993-01-03 | 3 | Republican | |||||||||||||
42437 | 42437 | Charles Grassley G000386 | sen | IA | 1981-01-05 | 1987-01-03 | 3 | Republican | |||||||||||||
42436 | 42436 | Charles Grassley G000386 | rep | IA | 1979-01-15 | 1981-01-03 | Republican | 3 | |||||||||||||
42435 | 42435 | Charles Grassley G000386 | rep | IA | 1977-01-04 | 1979-01-03 | Republican | 3 | |||||||||||||
42434 | 42434 | Charles Grassley G000386 | rep | IA | 1975-01-14 | 1977-01-03 | Republican | 3 | |||||||||||||
41601 | 41601 | Abby Finkenauer F000467 | rep | IA | 2019-01-03 | 2021-01-03 | Democrat | 1 | https://finkenauer.house.gov | 124 Cannon House Office Building Washington DC 20515-1501 | 202-225-2911 | 124 Cannon House Office Building | |||||||||
41388 | 41388 | David Loebsack L000565 | rep | IA | 2019-01-03 | 2021-01-03 | Democrat | 2 | https://loebsack.house.gov | 1211 Longworth House Office Building Washington DC 20515-1502 | 202-225-6576 | 1211 Longworth House Office Building | http://loebsack.house.gov/news/rss.aspx | ||||||||
41387 | 41387 | David Loebsack L000565 | rep | IA | 2017-01-03 | 2019-01-03 | Democrat | 2 | https://loebsack.house.gov | 1527 Longworth House Office Building; Washington DC 20515-1502 | 202-225-6576 | 202-226-0757 | 1527 Longworth House Office Building | http://loebsack.house.gov/news/rss.aspx | |||||||
41386 | 41386 | David Loebsack L000565 | rep | IA | 2015-01-06 | 2017-01-03 | Democrat | 2 | http://loebsack.house.gov | 1527 Longworth HOB; Washington DC 20515-1502 | 202-225-6576 | 202-226-0757 | https://loebsack.house.gov/forms/writeyourrep/ | 1527 Longworth House Office Building | http://loebsack.house.gov/news/rss.aspx | ||||||
41385 | 41385 | David Loebsack L000565 | rep | IA | 2013-01-03 | 2015-01-03 | Democrat | 2 | http://loebsack.house.gov | 1527 Longworth HOB; Washington DC 20515-1502 | 202-225-6576 | 202-226-0757 | https://loebsack.house.gov/forms/writeyourrep/ | 1527 Longworth House Office Building | http://loebsack.house.gov/news/rss.aspx | ||||||
41384 | 41384 | David Loebsack L000565 | rep | IA | 2011-01-05 | 2013-01-03 | Democrat | 2 | http://loebsack.house.gov | 1527 Longworth HOB; Washington DC 20515-1502 | 202-225-6576 | 202-226-0757 | http://loebsack.house.gov/contactform/ | 1527 Longworth House Office Building | |||||||
41383 | 41383 | David Loebsack L000565 | rep | IA | 2009-01-06 | 2011-01-03 | Democrat | 2 | http://loebsack.house.gov | ||||||||||||
41382 | 41382 | David Loebsack L000565 | rep | IA | 2007-01-04 | 2009-01-03 | Democrat | 2 | http://loebsack.house.gov | ||||||||||||
41373 | 41373 | Steve King K000362 | rep | IA | 2019-01-03 | 2021-01-03 | Republican | 4 | https://steveking.house.gov | 2210 Rayburn House Office Building Washington DC 20515-1504 | 202-225-4426 | 2210 Rayburn House Office Building | http://steveking.house.gov/index.php?format=feed&type=rss | ||||||||
41372 | 41372 | Steve King K000362 | rep | IA | 2017-01-03 | 2019-01-03 | Republican | 4 | https://steveking.house.gov | 2210 Rayburn House Office Building; Washington DC 20515-1504 | 202-225-4426 | 202-225-3193 | 2210 Rayburn House Office Building | http://steveking.house.gov/index.php?format=feed&type=rss | |||||||
41371 | 41371 | Steve King K000362 | rep | IA | 2015-01-06 | 2017-01-03 | Republican | 4 | https://steveking.house.gov | 2210 Rayburn HOB; Washington DC 20515-1504 | 202-225-4426 | 202-225-3193 | https://forms.house.gov/king/webforms/issue_subscribe.html | 2210 Rayburn House Office Building | http://steveking.house.gov/index.php?format=feed&type=rss | ||||||
41370 | 41370 | Steve King K000362 | rep | IA | 2013-01-03 | 2015-01-03 | Republican | 4 | http://steveking.house.gov | 2210 Rayburn HOB; Washington DC 20515-1504 | 202-225-4426 | 202-225-3193 | https://forms.house.gov/king/webforms/issue_subscribe.html | 2210 Rayburn House Office Building | http://steveking.house.gov/index.php?format=feed&type=rss | ||||||
41369 | 41369 | Steve King K000362 | rep | IA | 2011-01-05 | 2013-01-03 | Republican | 5 | http://www.house.gov/steveking | 1131 Longworth HOB; Washington DC 20515-1505 | 202-225-4426 | 202-225-3193 | http://www.house.gov/steveking/email.shtm | 1131 Longworth House Office Building | |||||||
41368 | 41368 | Steve King K000362 | rep | IA | 2009-01-06 | 2011-01-03 | Republican | 5 | http://www.house.gov/steveking | ||||||||||||
41367 | 41367 | Steve King K000362 | rep | IA | 2007-01-04 | 2009-01-03 | Republican | 5 | http://www.house.gov/steveking | ||||||||||||
41366 | 41366 | Steve King K000362 | rep | IA | 2005-01-04 | 2007-01-03 | Republican | 5 | http://www.house.gov/steveking | ||||||||||||
41365 | 41365 | Steve King K000362 | rep | IA | 2003-01-07 | 2005-01-03 | Republican | 5 | http://www.house.gov/steveking | ||||||||||||
41135 | 41135 | David Young Y000066 | rep | IA | 2017-01-03 | 2019-01-03 | Republican | 3 | https://davidyoung.house.gov | 240 Cannon House Office Building; Washington DC 20515-1503 | 202-225-5476 | 240 Cannon House Office Building | |||||||||
41134 | 41134 | David Young Y000066 | rep | IA | 2015-01-06 | 2017-01-03 | Republican | 3 | https://davidyoung.house.gov | 515 Cannon HOB; Washington DC 20515-1503 | 202-225-5476 | 515 Cannon House Office Building | |||||||||
41133 | 41133 | Rod Blum B001294 | rep | IA | 2017-01-03 | 2019-01-03 | Republican | 1 | https://blum.house.gov | 1108 Longworth House Office Building; Washington DC 20515-1501 | 202-225-2911 | 1108 Longworth House Office Building | |||||||||
41132 | 41132 | Rod Blum B001294 | rep | IA | 2015-01-06 | 2017-01-03 | Republican | 1 | https://blum.house.gov | 213 Cannon HOB; Washington DC 20515-1501 | 202-225-2911 | 213 Cannon House Office Building | |||||||||
39911 | 39911 | Tom Latham L000111 | rep | IA | 2013-01-03 | 2015-01-03 | Republican | 3 | http://latham.house.gov | 2217 Rayburn HOB; Washington DC 20515-1503 | 202-225-5476 | 202-225-3301 | https://latham.house.gov/contact/contactform.htm | 2217 Rayburn House Office Building | http://www.house.gov/news/rss.aspx | ||||||
39910 | 39910 | Tom Latham L000111 | rep | IA | 2011-01-05 | 2013-01-03 | Republican | 4 | http://www.house.gov/latham | 2217 Rayburn HOB; Washington DC 20515-1504 | 202-225-5476 | 202-225-3301 | http://www.tomlatham.house.gov/Contact/ | 2217 Rayburn House Office Building | |||||||
39909 | 39909 | Tom Latham L000111 | rep | IA | 2009-01-06 | 2011-01-03 | Republican | 4 | http://www.house.gov/latham | ||||||||||||
39908 | 39908 | Tom Latham L000111 | rep | IA | 2007-01-04 | 2009-01-03 | Republican | 4 | http://www.house.gov/latham | ||||||||||||
39907 | 39907 | Tom Latham L000111 | rep | IA | 2005-01-04 | 2007-01-03 | Republican | 4 | http://www.house.gov/latham | ||||||||||||
39906 | 39906 | Tom Latham L000111 | rep | IA | 2003-01-07 | 2005-01-03 | Republican | 4 | http://www.house.gov/latham | ||||||||||||
39905 | 39905 | Tom Latham L000111 | rep | IA | 2001-01-03 | 2003-01-03 | Republican | 5 | |||||||||||||
39904 | 39904 | Tom Latham L000111 | rep | IA | 1999-01-06 | 2001-01-03 | Republican | 5 | |||||||||||||
39903 | 39903 | Tom Latham L000111 | rep | IA | 1997-01-07 | 1999-01-03 | Republican | 5 | |||||||||||||
39902 | 39902 | Tom Latham L000111 | rep | IA | 1995-01-04 | 1997-01-03 | Republican | 5 | |||||||||||||
39763 | 39763 | Bruce Braley B001259 | rep | IA | 2013-01-03 | 2015-01-03 | Democrat | 1 | http://braley.house.gov | 2263 Rayburn HOB; Washington DC 20515-1501 | 202-225-2911 | 202-225-6666 | http://braley.house.gov/contact | 2263 Rayburn House Office Building | http://braley.house.gov/rss.xml | ||||||
39762 | 39762 | Bruce Braley B001259 | rep | IA | 2011-01-05 | 2013-01-03 | Democrat | 1 | http://braley.house.gov | 1727 Longworth HOB; Washington DC 20515-1501 | 202-225-2911 | 202-225-6666 | https://forms.house.gov/braley/webforms/issue_subscribe.html | 1727 Longworth House Office Building | |||||||
39761 | 39761 | Bruce Braley B001259 | rep | IA | 2009-01-06 | 2011-01-03 | Democrat | 1 | http://braley.house.gov | ||||||||||||
39760 | 39760 | Bruce Braley B001259 | rep | IA | 2007-01-04 | 2009-01-03 | Democrat | 1 | http://braley.house.gov | ||||||||||||
39703 | 39703 | Thomas Harkin H000206 | sen | IA | 2009-01-06 | 2015-01-03 | 2 | Democrat | http://www.harkin.senate.gov | 731 Hart Senate Office Building Washington DC 20510 | 202-224-3254 | 202-224-9369 | http://www.harkin.senate.gov/contact.cfm | 731 Hart Senate Office Building | junior | http://www.harkin.senate.gov/rss/rss.cfm | |||||
39702 | 39702 | Thomas Harkin H000206 | sen | IA | 2003-01-07 | 2009-01-03 | 2 | Democrat | http://harkin.senate.gov/ | ||||||||||||
39701 | 39701 | Thomas Harkin H000206 | sen | IA | 1997-01-07 | 2003-01-03 | 2 | Democrat | |||||||||||||
39700 | 39700 | Thomas Harkin H000206 | sen | IA | 1991-01-03 | 1997-01-03 | 2 | Democrat | |||||||||||||
39699 | 39699 | Thomas Harkin H000206 | sen | IA | 1985-01-03 | 1991-01-03 | 2 | Democrat | |||||||||||||
39698 | 39698 | Thomas Harkin H000206 | rep | IA | 1983-01-03 | 1985-01-03 | Democrat | 5 | |||||||||||||
39697 | 39697 | Thomas Harkin H000206 | rep | IA | 1981-01-05 | 1983-01-03 | Democrat | 5 | |||||||||||||
39696 | 39696 | Thomas Harkin H000206 | rep | IA | 1979-01-15 | 1981-01-03 | Democrat | 5 | |||||||||||||
39695 | 39695 | Thomas Harkin H000206 | rep | IA | 1977-01-04 | 1979-01-03 | Democrat | 5 | |||||||||||||
39694 | 39694 | Thomas Harkin H000206 | rep | IA | 1975-01-14 | 1977-01-03 | Democrat | 5 | |||||||||||||
39191 | 39191 | Leonard Boswell B000652 | rep | IA | 2011-01-05 | 2013-01-03 | Democrat | 3 | http://boswell.house.gov | 1026 Longworth HOB; Washington DC 20515-1503 | 202-225-3806 | 202-225-5608 | http://boswell.house.gov/messageform.htm | 1026 Longworth House Office Building | |||||||
39190 | 39190 | Leonard Boswell B000652 | rep | IA | 2009-01-06 | 2011-01-03 | Democrat | 3 | http://boswell.house.gov | ||||||||||||
39189 | 39189 | Leonard Boswell B000652 | rep | IA | 2007-01-04 | 2009-01-03 | Democrat | 3 | http://boswell.house.gov | ||||||||||||
39188 | 39188 | Leonard Boswell B000652 | rep | IA | 2005-01-04 | 2007-01-03 | Democrat | 3 | http://www.house.gov/boswell | ||||||||||||
39187 | 39187 | Leonard Boswell B000652 | rep | IA | 2003-01-07 | 2005-01-03 | Democrat | 3 | http://www.house.gov/boswell | ||||||||||||
39186 | 39186 | Leonard Boswell B000652 | rep | IA | 2001-01-03 | 2003-01-03 | Democrat | 3 | |||||||||||||
39185 | 39185 | Leonard Boswell B000652 | rep | IA | 1999-01-06 | 2001-01-03 | Democrat | 3 | |||||||||||||
39184 | 39184 | Leonard Boswell B000652 | rep | IA | 1997-01-07 | 1999-01-03 | Democrat | 3 | |||||||||||||
37801 | 37801 | James Nussle N000172 | rep | IA | 2005-01-04 | 2007-01-03 | Republican | 1 | http://nussle.house.gov | ||||||||||||
37800 | 37800 | James Nussle N000172 | rep | IA | 2003-01-07 | 2005-01-03 | Republican | 1 | http://nussle.house.gov | ||||||||||||
37799 | 37799 | James Nussle N000172 | rep | IA | 2001-01-03 | 2003-01-03 | Republican | 2 | |||||||||||||
37798 | 37798 | James Nussle N000172 | rep | IA | 1999-01-06 | 2001-01-03 | Republican | 2 | |||||||||||||
37797 | 37797 | James Nussle N000172 | rep | IA | 1997-01-07 | 1999-01-03 | Republican | 2 | |||||||||||||
37796 | 37796 | James Nussle N000172 | rep | IA | 1995-01-04 | 1997-01-03 | Republican | 2 | |||||||||||||
37795 | 37795 | James Nussle N000172 | rep | IA | 1993-01-05 | 1995-01-03 | Republican | 2 | |||||||||||||
37794 | 37794 | James Nussle N000172 | rep | IA | 1991-01-03 | 1993-01-03 | Republican | 2 | |||||||||||||
37771 | 37771 | James Leach L000169 | rep | IA | 2005-01-04 | 2007-01-03 | Republican | 2 | http://www.house.gov/leach | ||||||||||||
37770 | 37770 | James Leach L000169 | rep | IA | 2003-01-07 | 2005-01-03 | Republican | 2 | http://www.house.gov/leach | ||||||||||||
37769 | 37769 | James Leach L000169 | rep | IA | 2001-01-03 | 2003-01-03 | Republican | 1 | |||||||||||||
37768 | 37768 | James Leach L000169 | rep | IA | 1999-01-06 | 2001-01-03 | Republican | 1 | |||||||||||||
37767 | 37767 | James Leach L000169 | rep | IA | 1997-01-07 | 1999-01-03 | Republican | 1 | |||||||||||||
37766 | 37766 | James Leach L000169 | rep | IA | 1995-01-04 | 1997-01-03 | Republican | 1 | |||||||||||||
37765 | 37765 | James Leach L000169 | rep | IA | 1993-01-05 | 1995-01-03 | Republican | 1 | |||||||||||||
37764 | 37764 | James Leach L000169 | rep | IA | 1991-01-03 | 1993-01-03 | Republican | 1 | |||||||||||||
37763 | 37763 | James Leach L000169 | rep | IA | 1989-01-03 | 1991-01-03 | Republican | 1 | |||||||||||||
37762 | 37762 | James Leach L000169 | rep | IA | 1987-01-06 | 1989-01-03 | Republican | 1 | |||||||||||||
37761 | 37761 | James Leach L000169 | rep | IA | 1985-01-03 | 1987-01-03 | Republican | 1 | |||||||||||||
37760 | 37760 | James Leach L000169 | rep | IA | 1983-01-03 | 1985-01-03 | Republican | 1 | |||||||||||||
37759 | 37759 | James Leach L000169 | rep | IA | 1981-01-05 | 1983-01-03 | Republican | 1 | |||||||||||||
37758 | 37758 | James Leach L000169 | rep | IA | 1979-01-15 | 1981-01-03 | Republican | 1 | |||||||||||||
37757 | 37757 | James Leach L000169 | rep | IA | 1977-01-04 | 1979-01-03 | Republican | 1 | |||||||||||||
36909 | 36909 | Greg Ganske G000041 | rep | IA | 2001-01-03 | 2003-01-03 | Republican | 4 | |||||||||||||
36908 | 36908 | Greg Ganske G000041 | rep | IA | 1999-01-06 | 2001-01-03 | Republican | 4 | |||||||||||||
36907 | 36907 | Greg Ganske G000041 | rep | IA | 1997-01-07 | 1999-01-03 | Republican | 4 | |||||||||||||
36906 | 36906 | Greg Ganske G000041 | rep | IA | 1995-01-04 | 1997-01-03 | Republican | 4 | |||||||||||||
35893 | 35893 | James Lightfoot L000305 | rep | IA | 1995-01-04 | 1997-01-03 | Republican | 3 | |||||||||||||
35892 | 35892 | James Lightfoot L000305 | rep | IA | 1993-01-05 | 1995-01-03 | Republican | 3 | |||||||||||||
35891 | 35891 | James Lightfoot L000305 | rep | IA | 1991-01-03 | 1993-01-03 | Republican | 5 |
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);