legislator_terms
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
84 rows where state = "IN" and type = "sen"
This data as json, copyable, CSV (advanced)
Suggested facets: class, party, url, phone, state_rank, start (date), 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2157 | 2157 | Waller Taylor T000102 | sen | IN | 1816-01-01 | 1819-03-03 | 3 | Republican | |||||||||||||
2158 | 2158 | Waller Taylor T000102 | sen | IN | 1819-12-06 | 1825-03-03 | 3 | Republican | |||||||||||||
2915 | 2915 | James Noble N000118 | sen | IN | 1816-01-01 | 1821-03-03 | 1 | Republican | |||||||||||||
2916 | 2916 | James Noble N000118 | sen | IN | 1821-12-03 | 1827-03-03 | 1 | Adams | |||||||||||||
2917 | 2917 | James Noble N000118 | sen | IN | 1827-12-03 | 1831-12-31 | 1 | Adams | |||||||||||||
3398 | 3398 | Robert Hanna H000165 | sen | IN | 1831-12-05 | 1833-03-03 | 1 | Anti-Jacksonian | |||||||||||||
3403 | 3403 | William Hendricks H000494 | sen | IN | 1825-12-05 | 1831-03-03 | 3 | Adams | |||||||||||||
3404 | 3404 | William Hendricks H000494 | sen | IN | 1831-12-05 | 1837-03-03 | 3 | Adams | |||||||||||||
3588 | 3588 | John Tipton T000284 | sen | IN | 1832-01-03 | 1833-03-02 | 1 | Democrat | |||||||||||||
3589 | 3589 | John Tipton T000284 | sen | IN | 1833-12-02 | 1839-03-03 | 1 | Democrat | |||||||||||||
4351 | 4351 | Oliver Smith S000599 | sen | IN | 1837-09-04 | 1843-03-03 | 3 | Whig | |||||||||||||
5213 | 5213 | Edward Hannegan H000167 | sen | IN | 1843-12-04 | 1849-03-03 | 3 | Democrat | |||||||||||||
6170 | 6170 | James Whitcomb W000349 | sen | IN | 1849-12-03 | 1853-03-03 | 3 | Democrat | |||||||||||||
6471 | 6471 | Charles Cathcart C000250 | sen | IN | 1852-01-01 | 1853-12-31 | 3 | Democrat | |||||||||||||
6671 | 6671 | John Pettit P000277 | sen | IN | 1853-12-05 | 1855-03-03 | 3 | Democrat | |||||||||||||
6991 | 6991 | Jesse Bright B000835 | sen | IN | 1845-12-01 | 1851-03-03 | 1 | Democrat | |||||||||||||
6992 | 6992 | Jesse Bright B000835 | sen | IN | 1851-12-01 | 1857-03-03 | 1 | Democrat | |||||||||||||
6993 | 6993 | Jesse Bright B000835 | sen | IN | 1857-12-07 | 1863-03-03 | 1 | Democrat | |||||||||||||
7046 | 7046 | Graham Fitch F000158 | sen | IN | 1857-12-07 | 1861-03-03 | 3 | Democrat | |||||||||||||
7781 | 7781 | Henry Lane L000060 | sen | IN | 1861-07-04 | 1867-03-03 | 3 | Republican | |||||||||||||
7880 | 7880 | Albert White W000351 | sen | IN | 1839-12-02 | 1845-03-03 | 1 | Whig | |||||||||||||
7902 | 7902 | Joseph Wright W000766 | sen | IN | 1862-01-01 | 1863-03-03 | 1 | Unionist | |||||||||||||
7969 | 7969 | Thomas Hendricks H000493 | sen | IN | 1863-12-07 | 1869-03-03 | 1 | Democrat | |||||||||||||
8691 | 8691 | Daniel Pratt P000497 | sen | IN | 1869-03-04 | 1875-03-03 | 1 | Republican | |||||||||||||
9279 | 9279 | Oliver Morton M001020 | sen | IN | 1867-03-04 | 1873-03-03 | 3 | Republican | |||||||||||||
9280 | 9280 | Oliver Morton M001020 | sen | IN | 1873-12-01 | 1877-12-31 | 3 | Republican | |||||||||||||
9582 | 9582 | Joseph McDonald M000412 | sen | IN | 1875-12-06 | 1881-03-03 | 1 | Democrat | |||||||||||||
11554 | 11554 | Benjamin Harrison H000263 | sen | IN | 1881-12-05 | 1887-03-03 | 1 | Republican | |||||||||||||
12350 | 12350 | Daniel Voorhees V000116 | sen | IN | 1877-10-15 | 1879-03-03 | 3 | Democrat | |||||||||||||
12351 | 12351 | Daniel Voorhees V000116 | sen | IN | 1879-03-18 | 1885-03-03 | 3 | Democrat | |||||||||||||
12352 | 12352 | Daniel Voorhees V000116 | sen | IN | 1885-12-07 | 1891-03-03 | 3 | Democrat | |||||||||||||
12353 | 12353 | Daniel Voorhees V000116 | sen | IN | 1891-12-07 | 1897-03-03 | 3 | Democrat | |||||||||||||
12833 | 12833 | David Turpie T000432 | sen | IN | 1863-12-07 | 1863-12-31 | 1 | Democrat | |||||||||||||
12834 | 12834 | David Turpie T000432 | sen | IN | 1887-12-05 | 1893-03-03 | 1 | Democrat | |||||||||||||
12835 | 12835 | David Turpie T000432 | sen | IN | 1893-08-07 | 1899-03-03 | 1 | Democrat | |||||||||||||
14306 | 14306 | Charles Fairbanks F000003 | sen | IN | 1897-03-15 | 1903-03-03 | 3 | Republican | |||||||||||||
14307 | 14307 | Charles Fairbanks F000003 | sen | IN | 1903-11-09 | 1905-12-31 | 3 | Republican | |||||||||||||
14573 | 14573 | Albert Beveridge B000429 | sen | IN | 1899-12-04 | 1905-03-03 | 1 | Republican | |||||||||||||
14574 | 14574 | Albert Beveridge B000429 | sen | IN | 1905-12-04 | 1911-03-03 | 1 | Republican | |||||||||||||
14706 | 14706 | James Hemenway H000467 | sen | IN | 1905-12-04 | 1909-03-03 | 3 | Republican | |||||||||||||
16021 | 16021 | John Kern K000132 | sen | IN | 1911-04-04 | 1917-03-03 | 1 | Democrat | |||||||||||||
16960 | 16960 | Benjamin Shively S000371 | sen | IN | 1909-03-15 | 1915-03-03 | 3 | Democrat | |||||||||||||
16961 | 16961 | Benjamin Shively S000371 | sen | IN | 1915-12-06 | 1917-03-03 | 3 | Democrat | |||||||||||||
17043 | 17043 | Thomas Taggart T000013 | sen | IN | 1916-03-20 | 1917-03-03 | 3 | Democrat | appointment | ||||||||||||
17362 | 17362 | Harry New N000059 | sen | IN | 1917-04-02 | 1923-03-03 | 1 | Republican | |||||||||||||
18809 | 18809 | Samuel Ralston R000020 | sen | IN | 1923-12-03 | 1925-12-31 | 1 | Democrat | |||||||||||||
19536 | 19536 | James Watson W000203 | sen | IN | 1916-01-01 | 1921-03-03 | 3 | Republican | |||||||||||||
19537 | 19537 | James Watson W000203 | sen | IN | 1921-04-11 | 1927-03-04 | 3 | Republican | |||||||||||||
19538 | 19538 | James Watson W000203 | sen | IN | 1927-12-05 | 1933-03-03 | 3 | Republican | |||||||||||||
19944 | 19944 | Arthur Robinson R000332 | sen | IN | 1925-12-07 | 1929-03-03 | 1 | Republican | appointment | ||||||||||||
19945 | 19945 | Arthur Robinson R000332 | sen | IN | 1929-04-15 | 1935-01-03 | 1 | Republican | |||||||||||||
21889 | 21889 | Sherman Minton M000800 | sen | IN | 1935-01-03 | 1941-01-03 | 1 | Democrat | |||||||||||||
22822 | 22822 | Frederick Van Nuys V000050 | sen | IN | 1933-03-09 | 1939-01-03 | 3 | Democrat | |||||||||||||
22823 | 22823 | Frederick Van Nuys V000050 | sen | IN | 1939-01-03 | 1945-01-03 | 3 | Democrat | |||||||||||||
23329 | 23329 | Raymond Willis W000563 | sen | IN | 1941-01-03 | 1947-01-03 | 1 | Republican | |||||||||||||
23762 | 23762 | Samuel Jackson J000026 | sen | IN | 1944-01-28 | 1945-01-03 | 3 | Democrat | appointment | ||||||||||||
25728 | 25728 | William Jenner J000093 | sen | IN | 1944-01-01 | 1945-01-03 | 3 | Republican | |||||||||||||
25729 | 25729 | William Jenner J000093 | sen | IN | 1947-01-03 | 1953-01-03 | 1 | Republican | |||||||||||||
25730 | 25730 | William Jenner J000093 | sen | IN | 1953-01-03 | 1959-01-03 | 1 | Republican | |||||||||||||
26204 | 26204 | Homer Capehart C000128 | sen | IN | 1945-01-03 | 1951-01-03 | 3 | Republican | |||||||||||||
26205 | 26205 | Homer Capehart C000128 | sen | IN | 1951-01-03 | 1957-01-03 | 3 | Republican | |||||||||||||
26206 | 26206 | Homer Capehart C000128 | sen | IN | 1957-01-03 | 1963-01-03 | 3 | Republican | |||||||||||||
29839 | 29839 | Rupert Hartke H000297 | sen | IN | 1959-01-07 | 1965-01-03 | 1 | Democrat | |||||||||||||
29840 | 29840 | Rupert Hartke H000297 | sen | IN | 1965-01-04 | 1971-01-03 | 1 | Democrat | |||||||||||||
29841 | 29841 | Rupert Hartke H000297 | sen | IN | 1971-01-21 | 1977-01-03 | 1 | Democrat | |||||||||||||
30835 | 30835 | Birch Bayh B000254 | sen | IN | 1963-01-09 | 1969-01-03 | 3 | Democrat | |||||||||||||
30836 | 30836 | Birch Bayh B000254 | sen | IN | 1969-01-03 | 1975-01-03 | 3 | Democrat | |||||||||||||
30837 | 30837 | Birch Bayh B000254 | sen | IN | 1975-01-14 | 1981-01-03 | 3 | Democrat | |||||||||||||
33719 | 33719 | James Quayle Q000007 | sen | IN | 1981-01-05 | 1987-01-03 | 3 | Republican | |||||||||||||
33720 | 33720 | James Quayle Q000007 | sen | IN | 1987-01-06 | 1989-12-31 | 3 | Republican | |||||||||||||
37513 | 37513 | Evan Bayh B001233 | sen | IN | 1999-01-06 | 2005-01-03 | 3 | Democrat | http://bayh.senate.gov/ | ||||||||||||
37514 | 37514 | Evan Bayh B001233 | sen | IN | 2005-01-04 | 2011-01-03 | 3 | Democrat | http://bayh.senate.gov | ||||||||||||
39063 | 39063 | Richard Lugar L000504 | sen | IN | 1977-01-04 | 1983-01-03 | 1 | Republican | |||||||||||||
39064 | 39064 | Richard Lugar L000504 | sen | IN | 1983-01-03 | 1989-01-03 | 1 | Republican | |||||||||||||
39065 | 39065 | Richard Lugar L000504 | sen | IN | 1989-01-03 | 1995-01-03 | 1 | Republican | |||||||||||||
39066 | 39066 | Richard Lugar L000504 | sen | IN | 1995-01-04 | 2001-01-03 | 1 | Republican | |||||||||||||
39067 | 39067 | Richard Lugar L000504 | sen | IN | 2001-01-03 | 2007-01-03 | 1 | Republican | http://lugar.senate.gov/ | ||||||||||||
39068 | 39068 | Richard Lugar L000504 | sen | IN | 2007-01-04 | 2013-01-03 | 1 | Republican | http://lugar.senate.gov/ | 306 HART SENATE OFFICE BUILDING WASHINGTON DC 20510 | 202-224-4814 | 202-228-0360 | http://www.lugar.senate.gov/contact/ | 306 Hart Senate Office Building | |||||||
40214 | 40214 | Daniel Coats C000542 | sen | IN | 1989-01-03 | 1993-01-03 | 3 | Republican | appointment | ||||||||||||
40215 | 40215 | Daniel Coats C000542 | sen | IN | 1993-01-05 | 1999-01-03 | 3 | Republican | |||||||||||||
40216 | 40216 | Daniel Coats C000542 | sen | IN | 2011-01-05 | 2017-01-03 | 3 | Republican | http://www.coats.senate.gov | 493 Russell Senate Office Building Washington DC 20510 | 202-224-5623 | 202-228-1820 | http://www.coats.senate.gov/contact/ | 493 Russell Senate Office Building | senior | http://www.coats.senate.gov/rss/feeds/?type=all& | |||||
40775 | 40775 | Joe Donnelly D000607 | sen | IN | 2013-01-03 | 2019-01-03 | 1 | Democrat | https://www.donnelly.senate.gov | 720 Hart Senate Office Building Washington DC 20510 | 202-224-4814 | 202-225-6798 | https://www.donnelly.senate.gov/contact/email-joe | 720 Hart Senate Office Building | senior | http://www.donnelly.senate.gov/rss/feeds/?type=all | |||||
43654 | 43654 | Todd Young Y000064 | sen | IN | 2017-01-03 | 2023-01-03 | 3 | Republican | https://www.young.senate.gov | 185 Dirksen Senate Office Building Washington DC 20510 | 202-224-5623 | 202-226-6866 | https://www.young.senate.gov/contact | 185 Dirksen Senate Office Building | senior | ||||||
44415 | 44415 | Mike Braun B001310 | sen | IN | 2019-01-03 | 2025-01-03 | 1 | Republican | https://www.braun.senate.gov | 404 Russell Senate Office Building Washington DC 20510 | 202-224-4814 | https://www.braun.senate.gov/contact-mike | 404 Russell Senate Office Building | junior |
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);