legislator_terms
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
136 rows where party = "Democrat", state = "IA" and type = "rep"
This data as json, copyable, CSV (advanced)
Suggested facets: district, url, phone, fax, 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 | |||||||||||||
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 | |||||||||||||
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 | |||||||||||||
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 | |||||||||||||
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 | |||||||||||||
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 | |||||||||||||
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 | |||||||||||||
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 | |||||||||||||
33239 | 33239 | Berkley Bedell B000298 | rep | IA | 1985-01-03 | 1987-01-03 | Democrat | 6 | |||||||||||||
34784 | 34784 | David Nagle N000003 | rep | IA | 1987-01-06 | 1989-01-03 | Democrat | 3 | |||||||||||||
34785 | 34785 | David Nagle N000003 | rep | IA | 1989-01-03 | 1991-01-03 | Democrat | 3 | |||||||||||||
34786 | 34786 | David Nagle N000003 | rep | IA | 1991-01-03 | 1993-01-03 | Democrat | 3 | |||||||||||||
35582 | 35582 | Neal Smith S000596 | rep | IA | 1959-01-07 | 1961-01-03 | Democrat | 5 | |||||||||||||
35583 | 35583 | Neal Smith S000596 | rep | IA | 1961-01-03 | 1963-01-03 | Democrat | 5 | |||||||||||||
35584 | 35584 | Neal Smith S000596 | rep | IA | 1963-01-09 | 1965-01-03 | Democrat | 5 | |||||||||||||
35585 | 35585 | Neal Smith S000596 | rep | IA | 1965-01-04 | 1967-01-03 | Democrat | 5 | |||||||||||||
35586 | 35586 | Neal Smith S000596 | rep | IA | 1967-01-10 | 1969-01-03 | Democrat | 5 | |||||||||||||
35587 | 35587 | Neal Smith S000596 | rep | IA | 1969-01-03 | 1971-01-03 | Democrat | 5 | |||||||||||||
35588 | 35588 | Neal Smith S000596 | rep | IA | 1971-01-21 | 1973-01-03 | Democrat | 5 | |||||||||||||
35589 | 35589 | Neal Smith S000596 | rep | IA | 1973-01-03 | 1975-01-03 | Democrat | 4 | |||||||||||||
35590 | 35590 | Neal Smith S000596 | rep | IA | 1975-01-14 | 1977-01-03 | Democrat | 4 |
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);