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 party
This data as json, copyable, CSV (advanced)
Suggested facets: class, district, url, address, phone, fax, contact_form, office, 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
4422 | 4422 | William Chapman C000318 | rep | IA | 1837-09-04 | 1839-03-03 | Democrat | -1 | |||||||||||||
4423 | 4423 | William Chapman C000318 | rep | IA | 1839-12-02 | 1841-03-03 | Democrat | -1 | |||||||||||||
5436 | 5436 | Serranus Hastings H000330 | rep | IA | 1845-12-01 | 1847-03-03 | Democrat | -1 | |||||||||||||
5862 | 5862 | Augustus Dodge D000394 | rep | IA | 1840-12-28 | 1841-03-03 | Democrat | 0 | |||||||||||||
5863 | 5863 | Augustus Dodge D000394 | rep | IA | 1841-05-31 | 1843-03-03 | Democrat | 0 | |||||||||||||
5864 | 5864 | Augustus Dodge D000394 | rep | IA | 1843-12-04 | 1845-03-03 | Democrat | 0 | |||||||||||||
5865 | 5865 | Augustus Dodge D000394 | rep | IA | 1845-12-01 | 1846-12-28 | Democrat | 0 | |||||||||||||
5866 | 5866 | Augustus Dodge D000394 | sen | IA | 1848-12-07 | 1849-03-03 | 3 | Democrat | |||||||||||||
5867 | 5867 | Augustus Dodge D000394 | sen | IA | 1849-03-05 | 1855-02-22 | 3 | Democrat | |||||||||||||
6040 | 6040 | Shepherd Leffler L000215 | rep | IA | 1845-12-01 | 1847-03-03 | Democrat | -1 | |||||||||||||
6041 | 6041 | Shepherd Leffler L000215 | rep | IA | 1847-12-06 | 1849-03-03 | Democrat | 2 | |||||||||||||
6042 | 6042 | Shepherd Leffler L000215 | rep | IA | 1849-12-03 | 1851-03-03 | Democrat | 2 | |||||||||||||
6146 | 6146 | William Thompson T000223 | rep | IA | 1847-12-06 | 1849-03-03 | Democrat | 1 | |||||||||||||
6147 | 6147 | William Thompson T000223 | rep | IA | 1849-12-03 | 1851-03-03 | Democrat | 1 | |||||||||||||
6257 | 6257 | Lincoln Clark C000445 | rep | IA | 1851-12-01 | 1853-03-03 | Democrat | 2 | |||||||||||||
6606 | 6606 | Bernhart Henn H000500 | rep | IA | 1851-12-01 | 1853-03-03 | Democrat | 1 | |||||||||||||
6607 | 6607 | Bernhart Henn H000500 | rep | IA | 1853-12-05 | 1855-03-03 | Democrat | 1 | |||||||||||||
6631 | 6631 | George Jones J000221 | sen | IA | 1848-01-01 | 1853-03-03 | 2 | Democrat | |||||||||||||
6632 | 6632 | George Jones J000221 | sen | IA | 1853-12-05 | 1859-03-03 | 2 | Democrat | |||||||||||||
6826 | 6826 | Augustus Hall H000043 | rep | IA | 1855-12-03 | 1857-03-03 | Democrat | 1 | |||||||||||||
9442 | 9442 | Lucien Ainsworth A000067 | rep | IA | 1875-12-06 | 1877-03-03 | Democrat | 3 | |||||||||||||
10677 | 10677 | John Cook C000719 | rep | IA | 1881-12-05 | 1883-03-03 | Democrat | 6 | |||||||||||||
10678 | 10678 | John Cook C000719 | rep | IA | 1883-12-03 | 1885-03-03 | Democrat | 6 | |||||||||||||
10852 | 10852 | William Pusey P000579 | rep | IA | 1883-12-03 | 1885-03-03 | Democrat | 9 | |||||||||||||
11042 | 11042 | Benjamin Frederick F000357 | rep | IA | 1883-12-03 | 1885-03-03 | Democrat | 5 | |||||||||||||
11043 | 11043 | Benjamin Frederick F000357 | rep | IA | 1885-12-07 | 1887-03-03 | Democrat | 5 | |||||||||||||
11059 | 11059 | Benton Hall H000044 | rep | IA | 1885-12-07 | 1887-03-03 | Democrat | 1 | |||||||||||||
11142 | 11142 | Jeremiah Murphy M001096 | rep | IA | 1883-12-03 | 1885-03-03 | Democrat | 2 | |||||||||||||
11143 | 11143 | Jeremiah Murphy M001096 | rep | IA | 1885-12-07 | 1887-03-03 | Democrat | 2 | |||||||||||||
12098 | 12098 | Thomas Bowman B000706 | rep | IA | 1891-12-07 | 1893-03-03 | Democrat | 9 | |||||||||||||
12114 | 12114 | Walter Butler B001193 | rep | IA | 1891-12-07 | 1893-03-03 | Democrat | 4 | |||||||||||||
12189 | 12189 | John Hamilton H000113 | rep | IA | 1891-12-07 | 1893-03-03 | Democrat | 5 | |||||||||||||
12289 | 12289 | John Seerley S000226 | rep | IA | 1891-12-07 | 1893-03-03 | Democrat | 1 | |||||||||||||
12357 | 12357 | Frederick White W000369 | rep | IA | 1891-12-07 | 1893-03-03 | Democrat | 6 | |||||||||||||
12609 | 12609 | Walter Hayes H000394 | rep | IA | 1887-12-05 | 1889-03-03 | Democrat | 2 | |||||||||||||
12610 | 12610 | Walter Hayes H000394 | rep | IA | 1889-12-02 | 1891-03-03 | Democrat | 2 | |||||||||||||
12611 | 12611 | Walter Hayes H000394 | rep | IA | 1891-12-07 | 1893-03-03 | Democrat | 2 | |||||||||||||
12612 | 12612 | Walter Hayes H000394 | rep | IA | 1893-08-07 | 1895-03-03 | Democrat | 2 | |||||||||||||
14520 | 14520 | Martin Wade W000007 | rep | IA | 1903-11-09 | 1905-03-03 | Democrat | 2 | |||||||||||||
15136 | 15136 | Daniel Hamilton H000107 | rep | IA | 1907-12-02 | 1909-03-03 | Democrat | 6 | |||||||||||||
15556 | 15556 | William Jamieson J000055 | rep | IA | 1909-03-15 | 1911-03-03 | Democrat | 8 | |||||||||||||
16337 | 16337 | Maurice Connolly C000699 | rep | IA | 1913-04-07 | 1915-03-03 | Democrat | 3 | |||||||||||||
16424 | 16424 | Sanford Kirkpatrick K000237 | rep | IA | 1913-04-07 | 1915-03-03 | Democrat | 6 | |||||||||||||
16524 | 16524 | Irvin Pepper P000220 | rep | IA | 1911-04-04 | 1913-03-03 | Democrat | 2 | |||||||||||||
16525 | 16525 | Irvin Pepper P000220 | rep | IA | 1913-04-07 | 1915-03-03 | Democrat | 2 | |||||||||||||
16627 | 16627 | Henry Vollmer V000113 | rep | IA | 1913-04-07 | 1915-03-03 | Democrat | 2 | |||||||||||||
16998 | 16998 | Thomas Steele S000837 | rep | IA | 1915-12-06 | 1917-03-03 | Democrat | 11 | |||||||||||||
19185 | 19185 | Daniel Steck S000826 | sen | IA | 1926-01-01 | 1931-03-03 | 2 | Democrat | |||||||||||||
21446 | 21446 | Richard Murphy M001103 | sen | IA | 1933-03-09 | 1937-01-03 | 3 | Democrat | |||||||||||||
21603 | 21603 | Albert Willford W000485 | rep | IA | 1933-03-09 | 1935-01-03 | Democrat | 3 | |||||||||||||
21830 | 21830 | Bernhard Jacobsen J000038 | rep | IA | 1931-12-07 | 1933-03-03 | Democrat | 2 | |||||||||||||
21831 | 21831 | Bernhard Jacobsen J000038 | rep | IA | 1933-03-09 | 1935-01-03 | Democrat | 2 | |||||||||||||
21832 | 21832 | Bernhard Jacobsen J000038 | rep | IA | 1935-01-03 | 1937-01-03 | Democrat | 2 | |||||||||||||
21994 | 21994 | Hubert Utterback U000036 | rep | IA | 1935-01-03 | 1937-01-03 | Democrat | 6 | |||||||||||||
22037 | 22037 | Frederick Biermann B000449 | rep | IA | 1933-03-09 | 1935-01-03 | Democrat | 4 | |||||||||||||
22038 | 22038 | Frederick Biermann B000449 | rep | IA | 1935-01-03 | 1937-01-03 | Democrat | 4 | |||||||||||||
22039 | 22039 | Frederick Biermann B000449 | rep | IA | 1937-01-05 | 1939-01-03 | Democrat | 4 | |||||||||||||
22128 | 22128 | Edward Eicher E000094 | rep | IA | 1933-03-09 | 1935-01-03 | Democrat | 1 | |||||||||||||
22129 | 22129 | Edward Eicher E000094 | rep | IA | 1935-01-03 | 1937-01-03 | Democrat | 1 | |||||||||||||
22130 | 22130 | Edward Eicher E000094 | rep | IA | 1937-01-05 | 1939-01-03 | Democrat | 1 | |||||||||||||
22226 | 22226 | Clyde Herring H000543 | sen | IA | 1937-01-05 | 1943-01-03 | 2 | Democrat | |||||||||||||
22457 | 22457 | Otha Wearin W000221 | rep | IA | 1933-03-09 | 1935-01-03 | Democrat | 7 | |||||||||||||
22458 | 22458 | Otha Wearin W000221 | rep | IA | 1935-01-03 | 1937-01-03 | Democrat | 7 | |||||||||||||
22459 | 22459 | Otha Wearin W000221 | rep | IA | 1937-01-05 | 1939-01-03 | Democrat | 7 | |||||||||||||
23024 | 23024 | Vincent Harrington H000231 | rep | IA | 1937-01-05 | 1939-01-03 | Democrat | 9 | |||||||||||||
23025 | 23025 | Vincent Harrington H000231 | rep | IA | 1939-01-03 | 1941-01-03 | Democrat | 9 | |||||||||||||
23026 | 23026 | Vincent Harrington H000231 | rep | IA | 1941-01-03 | 1943-01-03 | Democrat | 9 | |||||||||||||
23055 | 23055 | William Jacobsen J000039 | rep | IA | 1937-01-05 | 1939-01-03 | Democrat | 2 | |||||||||||||
23056 | 23056 | William Jacobsen J000039 | rep | IA | 1939-01-03 | 1941-01-03 | Democrat | 2 | |||||||||||||
23057 | 23057 | William Jacobsen J000039 | rep | IA | 1941-01-03 | 1943-01-03 | Democrat | 2 | |||||||||||||
24832 | 24832 | Guy Gillette G000205 | rep | IA | 1933-03-09 | 1935-01-03 | Democrat | 9 | |||||||||||||
24833 | 24833 | Guy Gillette G000205 | sen | IA | 1936-01-01 | 1939-01-03 | 3 | Democrat | |||||||||||||
24834 | 24834 | Guy Gillette G000205 | sen | IA | 1939-01-03 | 1945-01-03 | 3 | Democrat | |||||||||||||
24835 | 24835 | Guy Gillette G000205 | sen | IA | 1949-01-03 | 1955-01-03 | 2 | Democrat | |||||||||||||
26799 | 26799 | Steven Carter C000199 | rep | IA | 1959-01-07 | 1961-01-03 | Democrat | 4 | |||||||||||||
27056 | 27056 | Leonard Wolf W000675 | rep | IA | 1959-01-07 | 1961-01-03 | Democrat | 2 | |||||||||||||
27160 | 27160 | Merwin Coad C000540 | rep | IA | 1957-01-03 | 1959-01-03 | Democrat | 6 | |||||||||||||
27161 | 27161 | Merwin Coad C000540 | rep | IA | 1959-01-07 | 1961-01-03 | Democrat | 6 | |||||||||||||
27162 | 27162 | Merwin Coad C000540 | rep | IA | 1961-01-03 | 1963-01-03 | Democrat | 6 | |||||||||||||
28316 | 28316 | Bert Bandstra B000108 | rep | IA | 1965-01-04 | 1967-01-03 | Democrat | 4 | |||||||||||||
28437 | 28437 | Stanley Greigg G000450 | rep | IA | 1965-01-04 | 1967-01-03 | Democrat | 6 | |||||||||||||
28446 | 28446 | John Hansen H000173 | rep | IA | 1965-01-04 | 1967-01-03 | Democrat | 7 | |||||||||||||
28637 | 28637 | John Schmidhauser S000131 | rep | IA | 1965-01-04 | 1967-01-03 | Democrat | 1 | |||||||||||||
29296 | 29296 | Harold Hughes H000922 | sen | IA | 1969-01-03 | 1975-01-03 | 3 | Democrat | |||||||||||||
30251 | 30251 | Richard Clark C000448 | sen | IA | 1973-01-03 | 1979-01-03 | 2 | Democrat | |||||||||||||
30886 | 30886 | John Culver C000979 | rep | IA | 1965-01-04 | 1967-01-03 | Democrat | 2 | |||||||||||||
30887 | 30887 | John Culver C000979 | rep | IA | 1967-01-10 | 1969-01-03 | Democrat | 2 | |||||||||||||
30888 | 30888 | John Culver C000979 | rep | IA | 1969-01-03 | 1971-01-03 | Democrat | 2 | |||||||||||||
30889 | 30889 | John Culver C000979 | rep | IA | 1971-01-21 | 1973-01-03 | Democrat | 2 | |||||||||||||
30890 | 30890 | John Culver C000979 | rep | IA | 1973-01-03 | 1975-01-03 | Democrat | 2 | |||||||||||||
30891 | 30891 | John Culver C000979 | sen | IA | 1975-01-14 | 1981-01-03 | 3 | Democrat | |||||||||||||
31179 | 31179 | Edward Mezvinsky M000686 | rep | IA | 1973-01-03 | 1975-01-03 | Democrat | 1 | |||||||||||||
31180 | 31180 | Edward Mezvinsky M000686 | rep | IA | 1975-01-14 | 1977-01-03 | Democrat | 1 | |||||||||||||
31423 | 31423 | Michael Blouin B000567 | rep | IA | 1975-01-14 | 1977-01-03 | Democrat | 2 | |||||||||||||
31424 | 31424 | Michael Blouin B000567 | rep | IA | 1977-01-04 | 1979-01-03 | Democrat | 2 | |||||||||||||
33234 | 33234 | Berkley Bedell B000298 | rep | IA | 1975-01-14 | 1977-01-03 | Democrat | 6 | |||||||||||||
33235 | 33235 | Berkley Bedell B000298 | rep | IA | 1977-01-04 | 1979-01-03 | Democrat | 6 | |||||||||||||
33236 | 33236 | Berkley Bedell B000298 | rep | IA | 1979-01-15 | 1981-01-03 | Democrat | 6 | |||||||||||||
33237 | 33237 | Berkley Bedell B000298 | rep | IA | 1981-01-05 | 1983-01-03 | Democrat | 6 | |||||||||||||
33238 | 33238 | Berkley Bedell B000298 | rep | IA | 1983-01-03 | 1985-01-03 | Democrat | 6 |
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);