legislator_terms
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
90 rows where district = 9 and state = "IN"
This data as json, copyable, CSV (advanced)
Suggested facets: legislator_id, party, url, address, office, 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
5281 | 5281 | Samuel Sample S000024 | rep | IN | 1843-12-04 | 1845-03-03 | Whig | 9 | |||||||||||||
6469 | 6469 | Charles Cathcart C000250 | rep | IN | 1845-12-01 | 1847-03-03 | Democrat | 9 | |||||||||||||
6470 | 6470 | Charles Cathcart C000250 | rep | IN | 1847-12-06 | 1849-03-03 | Democrat | 9 | |||||||||||||
6576 | 6576 | Norman Eddy E000039 | rep | IN | 1853-12-05 | 1855-03-03 | Democrat | 9 | |||||||||||||
7044 | 7044 | Graham Fitch F000158 | rep | IN | 1849-12-03 | 1851-03-03 | Democrat | 9 | |||||||||||||
7045 | 7045 | Graham Fitch F000158 | rep | IN | 1851-12-01 | 1853-03-03 | Democrat | 9 | |||||||||||||
8290 | 8290 | Schuyler Colfax C000626 | rep | IN | 1855-12-03 | 1857-03-03 | Ind. Republican-Democrat | 9 | |||||||||||||
8291 | 8291 | Schuyler Colfax C000626 | rep | IN | 1857-12-07 | 1859-03-03 | Republican | 9 | |||||||||||||
8292 | 8292 | Schuyler Colfax C000626 | rep | IN | 1859-12-05 | 1861-03-03 | Republican | 9 | |||||||||||||
8293 | 8293 | Schuyler Colfax C000626 | rep | IN | 1861-07-04 | 1863-03-03 | Republican | 9 | |||||||||||||
8294 | 8294 | Schuyler Colfax C000626 | rep | IN | 1863-12-07 | 1865-03-03 | Republican | 9 | |||||||||||||
8295 | 8295 | Schuyler Colfax C000626 | rep | IN | 1865-12-04 | 1867-03-03 | Republican | 9 | |||||||||||||
8296 | 8296 | Schuyler Colfax C000626 | rep | IN | 1867-03-04 | 1869-03-03 | Republican | 9 | |||||||||||||
9354 | 9354 | John Shanks S000284 | rep | IN | 1869-03-04 | 1871-03-03 | Republican | 9 | |||||||||||||
9355 | 9355 | John Shanks S000284 | rep | IN | 1871-03-04 | 1873-03-03 | Republican | 9 | |||||||||||||
9356 | 9356 | John Shanks S000284 | rep | IN | 1873-12-01 | 1875-03-03 | Republican | 9 | |||||||||||||
9481 | 9481 | Thomas Cason C000232 | rep | IN | 1875-12-06 | 1877-03-03 | Republican | 9 | |||||||||||||
9976 | 9976 | Michael White W000386 | rep | IN | 1877-10-15 | 1879-03-03 | Republican | 9 | |||||||||||||
10334 | 10334 | Charles Doxey D000479 | rep | IN | 1881-12-05 | 1883-03-03 | Republican | 9 | |||||||||||||
10490 | 10490 | Godlove Orth O000106 | rep | IN | 1879-03-18 | 1881-03-03 | Republican | 9 | |||||||||||||
10491 | 10491 | Godlove Orth O000106 | rep | IN | 1881-12-05 | 1883-03-03 | Republican | 9 | |||||||||||||
11254 | 11254 | Thomas Ward W000142 | rep | IN | 1883-12-03 | 1885-03-03 | Democrat | 9 | |||||||||||||
11255 | 11255 | Thomas Ward W000142 | rep | IN | 1885-12-07 | 1887-03-03 | Democrat | 9 | |||||||||||||
11664 | 11664 | Joseph Cheadle C000339 | rep | IN | 1887-12-05 | 1889-03-03 | Republican | 9 | |||||||||||||
11665 | 11665 | Joseph Cheadle C000339 | rep | IN | 1889-12-02 | 1891-03-03 | Republican | 9 | |||||||||||||
12844 | 12844 | Daniel Waugh W000214 | rep | IN | 1891-12-07 | 1893-03-03 | Republican | 9 | |||||||||||||
12845 | 12845 | Daniel Waugh W000214 | rep | IN | 1893-08-07 | 1895-03-03 | Republican | 9 | |||||||||||||
15186 | 15186 | Charles Landis L000050 | rep | IN | 1897-03-15 | 1899-03-03 | Republican | 9 | |||||||||||||
15187 | 15187 | Charles Landis L000050 | rep | IN | 1899-12-04 | 1901-03-03 | Republican | 9 | |||||||||||||
15188 | 15188 | Charles Landis L000050 | rep | IN | 1901-12-02 | 1903-03-03 | Republican | 9 | |||||||||||||
15189 | 15189 | Charles Landis L000050 | rep | IN | 1903-11-09 | 1905-03-03 | Republican | 9 | |||||||||||||
15190 | 15190 | Charles Landis L000050 | rep | IN | 1905-12-04 | 1907-03-03 | Republican | 9 | |||||||||||||
15191 | 15191 | Charles Landis L000050 | rep | IN | 1907-12-02 | 1909-03-03 | Republican | 9 | |||||||||||||
16892 | 16892 | Martin Morrison M000998 | rep | IN | 1909-03-15 | 1911-03-03 | Democrat | 9 | |||||||||||||
16893 | 16893 | Martin Morrison M000998 | rep | IN | 1911-04-04 | 1913-03-03 | Democrat | 9 | |||||||||||||
16894 | 16894 | Martin Morrison M000998 | rep | IN | 1913-04-07 | 1915-03-03 | Democrat | 9 | |||||||||||||
16895 | 16895 | Martin Morrison M000998 | rep | IN | 1915-12-06 | 1917-03-03 | Democrat | 9 | |||||||||||||
20780 | 20780 | Fred Purnell P000573 | rep | IN | 1917-04-02 | 1919-03-03 | Republican | 9 | |||||||||||||
20781 | 20781 | Fred Purnell P000573 | rep | IN | 1919-05-19 | 1921-03-03 | Republican | 9 | |||||||||||||
20782 | 20782 | Fred Purnell P000573 | rep | IN | 1921-04-11 | 1923-03-03 | Republican | 9 | |||||||||||||
20783 | 20783 | Fred Purnell P000573 | rep | IN | 1923-12-03 | 1925-03-03 | Republican | 9 | |||||||||||||
20784 | 20784 | Fred Purnell P000573 | rep | IN | 1925-12-07 | 1927-03-04 | Republican | 9 | |||||||||||||
20785 | 20785 | Fred Purnell P000573 | rep | IN | 1927-12-05 | 1929-03-03 | Republican | 9 | |||||||||||||
20786 | 20786 | Fred Purnell P000573 | rep | IN | 1929-04-15 | 1931-03-03 | Republican | 9 | |||||||||||||
20787 | 20787 | Fred Purnell P000573 | rep | IN | 1931-12-07 | 1933-03-03 | Republican | 9 | |||||||||||||
22534 | 22534 | Eugene Crowe C000940 | rep | IN | 1933-03-09 | 1935-01-03 | Democrat | 9 | |||||||||||||
22535 | 22535 | Eugene Crowe C000940 | rep | IN | 1935-01-03 | 1937-01-03 | Democrat | 9 | |||||||||||||
22536 | 22536 | Eugene Crowe C000940 | rep | IN | 1937-01-05 | 1939-01-03 | Democrat | 9 | |||||||||||||
22537 | 22537 | Eugene Crowe C000940 | rep | IN | 1939-01-03 | 1941-01-03 | Democrat | 9 | |||||||||||||
26881 | 26881 | Earl Hogan H000690 | rep | IN | 1959-01-07 | 1961-01-03 | Democrat | 9 | |||||||||||||
28272 | 28272 | Earl Wilson W000572 | rep | IN | 1941-01-03 | 1943-01-03 | Republican | 9 | |||||||||||||
28273 | 28273 | Earl Wilson W000572 | rep | IN | 1943-01-06 | 1945-01-03 | Republican | 9 | |||||||||||||
28274 | 28274 | Earl Wilson W000572 | rep | IN | 1945-01-03 | 1947-01-03 | Republican | 9 | |||||||||||||
28275 | 28275 | Earl Wilson W000572 | rep | IN | 1947-01-03 | 1949-01-03 | Republican | 9 | |||||||||||||
28276 | 28276 | Earl Wilson W000572 | rep | IN | 1949-01-03 | 1951-01-03 | Republican | 9 | |||||||||||||
28277 | 28277 | Earl Wilson W000572 | rep | IN | 1951-01-03 | 1953-01-03 | Republican | 9 | |||||||||||||
28278 | 28278 | Earl Wilson W000572 | rep | IN | 1953-01-03 | 1955-01-03 | Republican | 9 | |||||||||||||
28279 | 28279 | Earl Wilson W000572 | rep | IN | 1955-01-05 | 1957-01-03 | Republican | 9 | |||||||||||||
28280 | 28280 | Earl Wilson W000572 | rep | IN | 1957-01-03 | 1959-01-03 | Republican | 9 | |||||||||||||
28281 | 28281 | Earl Wilson W000572 | rep | IN | 1961-01-03 | 1963-01-03 | Republican | 9 | |||||||||||||
28282 | 28282 | Earl Wilson W000572 | rep | IN | 1963-01-09 | 1965-01-03 | Republican | 9 | |||||||||||||
36228 | 36228 | Lee Hamilton H000114 | rep | IN | 1965-01-04 | 1967-01-03 | Democrat | 9 | |||||||||||||
36229 | 36229 | Lee Hamilton H000114 | rep | IN | 1967-01-10 | 1969-01-03 | Democrat | 9 | |||||||||||||
36230 | 36230 | Lee Hamilton H000114 | rep | IN | 1969-01-03 | 1971-01-03 | Democrat | 9 | |||||||||||||
36231 | 36231 | Lee Hamilton H000114 | rep | IN | 1971-01-21 | 1973-01-03 | Democrat | 9 | |||||||||||||
36232 | 36232 | Lee Hamilton H000114 | rep | IN | 1973-01-03 | 1975-01-03 | Democrat | 9 | |||||||||||||
36233 | 36233 | Lee Hamilton H000114 | rep | IN | 1975-01-14 | 1977-01-03 | Democrat | 9 | |||||||||||||
36234 | 36234 | Lee Hamilton H000114 | rep | IN | 1977-01-04 | 1979-01-03 | Democrat | 9 | |||||||||||||
36235 | 36235 | Lee Hamilton H000114 | rep | IN | 1979-01-15 | 1981-01-03 | Democrat | 9 | |||||||||||||
36236 | 36236 | Lee Hamilton H000114 | rep | IN | 1981-01-05 | 1983-01-03 | Democrat | 9 | |||||||||||||
36237 | 36237 | Lee Hamilton H000114 | rep | IN | 1983-01-03 | 1985-01-03 | Democrat | 9 | |||||||||||||
36238 | 36238 | Lee Hamilton H000114 | rep | IN | 1985-01-03 | 1987-01-03 | Democrat | 9 | |||||||||||||
36239 | 36239 | Lee Hamilton H000114 | rep | IN | 1987-01-06 | 1989-01-03 | Democrat | 9 | |||||||||||||
36240 | 36240 | Lee Hamilton H000114 | rep | IN | 1989-01-03 | 1991-01-03 | Democrat | 9 | |||||||||||||
36241 | 36241 | Lee Hamilton H000114 | rep | IN | 1991-01-03 | 1993-01-03 | Democrat | 9 | |||||||||||||
36242 | 36242 | Lee Hamilton H000114 | rep | IN | 1993-01-05 | 1995-01-03 | Democrat | 9 | |||||||||||||
36243 | 36243 | Lee Hamilton H000114 | rep | IN | 1995-01-04 | 1997-01-03 | Democrat | 9 | |||||||||||||
36244 | 36244 | Lee Hamilton H000114 | rep | IN | 1997-01-07 | 1999-01-03 | Democrat | 9 | |||||||||||||
37882 | 37882 | Michael Sodrel S001160 | rep | IN | 2005-01-04 | 2007-01-03 | Republican | 9 | |||||||||||||
38578 | 38578 | Baron Hill H001030 | rep | IN | 1999-01-06 | 2001-01-03 | Democrat | 9 | |||||||||||||
38579 | 38579 | Baron Hill H001030 | rep | IN | 2001-01-03 | 2003-01-03 | Democrat | 9 | |||||||||||||
38580 | 38580 | Baron Hill H001030 | rep | IN | 2003-01-07 | 2005-01-03 | Democrat | 9 | http://www.house.gov/baronhill | ||||||||||||
38581 | 38581 | Baron Hill H001030 | rep | IN | 2007-01-04 | 2009-01-03 | Democrat | 9 | http://baronhill.house.gov | ||||||||||||
38582 | 38582 | Baron Hill H001030 | rep | IN | 2009-01-06 | 2011-01-03 | Democrat | 9 | http://baronhill.house.gov | ||||||||||||
43651 | 43651 | Todd Young Y000064 | rep | IN | 2011-01-05 | 2013-01-03 | Republican | 9 | http://toddyoung.house.gov/ | 1721 Longworth HOB; Washington DC 20515-1409 | 202-225-5315 | 202-226-6866 | 1721 Longworth House Office Building | ||||||||
43652 | 43652 | Todd Young Y000064 | rep | IN | 2013-01-03 | 2015-01-03 | Republican | 9 | http://toddyoung.house.gov | 1007 Longworth HOB; Washington DC 20515-1409 | 202-225-5315 | 202-226-6866 | https://toddyoungforms.house.gov/give-me-your-opinion | 1007 Longworth House Office Building | http://toddyoung.house.gov/common/rss//index.cfm?rss=49 | ||||||
43653 | 43653 | Todd Young Y000064 | rep | IN | 2015-01-06 | 2017-01-03 | Republican | 9 | http://toddyoung.house.gov | 1007 Longworth HOB; Washington DC 20515-1409 | 202-225-5315 | 202-226-6866 | https://toddyoungforms.house.gov/give-me-your-opinion | 1007 Longworth House Office Building | http://toddyoung.house.gov/common/rss//index.cfm?rss=49 | ||||||
44166 | 44166 | Trey Hollingsworth H001074 | rep | IN | 2017-01-03 | 2019-01-03 | Republican | 9 | https://hollingsworth.house.gov | 1641 Longworth House Office Building; Washington DC 20515-1409 | 202-225-5315 | 1641 Longworth House Office Building | |||||||||
44167 | 44167 | Trey Hollingsworth H001074 | rep | IN | 2019-01-03 | 2021-01-03 | Republican | 9 | https://hollingsworth.house.gov | 1641 Longworth House Office Building Washington DC 20515-1409 | 202-225-5315 | 1641 Longworth House Office Building | |||||||||
44168 | 44168 | Trey Hollingsworth H001074 | rep | IN | 2021-01-03 | 2023-01-03 | Republican | 9 | https://hollingsworth.house.gov | 1641 Longworth House Office Building Washington DC 20515-1409 | 202-225-5315 | 1641 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);