legislator_terms
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
1,187 rows where state = "IN" sorted by legislator_id
This data as json, copyable, CSV (advanced)
Suggested facets: class, district, phone, fax, contact_form, state_rank, start (date), end (date)
party 14 ✖
- Republican 572
- Democrat 531
- Whig 31
- Jackson 17
- Ind. Republican-Democrat 9
- Adams 8
- National Greenbacker 2
- Anti Jacksonian 1
- Anti-Jacksonian 1
- Anti-Lecompton Democrat 1
- Democratic Republican 1
- Free Soil 1
- Jackson Republican 1
- Unionist 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
29103 | 29103 | Edwin Adair A000024 | rep | IN | 1951-01-03 | 1953-01-03 | Republican | 4 | |||||||||||||
29104 | 29104 | Edwin Adair A000024 | rep | IN | 1953-01-03 | 1955-01-03 | Republican | 4 | |||||||||||||
29105 | 29105 | Edwin Adair A000024 | rep | IN | 1955-01-05 | 1957-01-03 | Republican | 4 | |||||||||||||
29106 | 29106 | Edwin Adair A000024 | rep | IN | 1957-01-03 | 1959-01-03 | Republican | 4 | |||||||||||||
29107 | 29107 | Edwin Adair A000024 | rep | IN | 1959-01-07 | 1961-01-03 | Republican | 4 | |||||||||||||
29108 | 29108 | Edwin Adair A000024 | rep | IN | 1961-01-03 | 1963-01-03 | Republican | 4 | |||||||||||||
29109 | 29109 | Edwin Adair A000024 | rep | IN | 1963-01-09 | 1965-01-03 | Republican | 4 | |||||||||||||
29110 | 29110 | Edwin Adair A000024 | rep | IN | 1965-01-04 | 1967-01-03 | Republican | 4 | |||||||||||||
29111 | 29111 | Edwin Adair A000024 | rep | IN | 1967-01-10 | 1969-01-03 | Republican | 4 | |||||||||||||
29112 | 29112 | Edwin Adair A000024 | rep | IN | 1969-01-03 | 1971-01-03 | Republican | 4 | |||||||||||||
16664 | 16664 | John Adair A000027 | rep | IN | 1907-12-02 | 1909-03-03 | Democrat | 8 | |||||||||||||
16665 | 16665 | John Adair A000027 | rep | IN | 1909-03-15 | 1911-03-03 | Democrat | 8 | |||||||||||||
16666 | 16666 | John Adair A000027 | rep | IN | 1911-04-04 | 1913-03-03 | Democrat | 8 | |||||||||||||
16667 | 16667 | John Adair A000027 | rep | IN | 1913-04-07 | 1915-03-03 | Democrat | 8 | |||||||||||||
16668 | 16668 | John Adair A000027 | rep | IN | 1915-12-06 | 1917-03-03 | Democrat | 8 | |||||||||||||
5889 | 5889 | Nathaniel Albertson A000075 | rep | IN | 1849-12-03 | 1851-03-03 | Democrat | 1 | |||||||||||||
9997 | 9997 | John Baker B000068 | rep | IN | 1875-12-06 | 1877-03-03 | Republican | 13 | |||||||||||||
9998 | 9998 | John Baker B000068 | rep | IN | 1877-10-15 | 1879-03-03 | Republican | 13 | |||||||||||||
9999 | 9999 | John Baker B000068 | rep | IN | 1879-03-18 | 1881-03-03 | Republican | 13 | |||||||||||||
6760 | 6760 | Lucien Barbour B000130 | rep | IN | 1855-12-03 | 1857-03-03 | Ind. Republican-Democrat | 6 | |||||||||||||
15338 | 15338 | William Barnard B000155 | rep | IN | 1909-03-15 | 1911-03-03 | Republican | 6 | |||||||||||||
17061 | 17061 | Henry Barnhart B000164 | rep | IN | 1907-12-02 | 1909-03-03 | Democrat | 13 | |||||||||||||
17062 | 17062 | Henry Barnhart B000164 | rep | IN | 1909-03-15 | 1911-03-03 | Democrat | 13 | |||||||||||||
17063 | 17063 | Henry Barnhart B000164 | rep | IN | 1911-04-04 | 1913-03-03 | Democrat | 13 | |||||||||||||
17064 | 17064 | Henry Barnhart B000164 | rep | IN | 1913-04-07 | 1915-03-03 | Democrat | 13 | |||||||||||||
17065 | 17065 | Henry Barnhart B000164 | rep | IN | 1915-12-06 | 1917-03-03 | Democrat | 13 | |||||||||||||
17066 | 17066 | Henry Barnhart B000164 | rep | IN | 1917-04-02 | 1919-03-03 | Democrat | 13 | |||||||||||||
26721 | 26721 | Joseph Barr B000170 | rep | IN | 1959-01-07 | 1961-01-03 | Democrat | 11 | |||||||||||||
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 | |||||||||||||
26178 | 26178 | John Beamer B000276 | rep | IN | 1951-01-03 | 1953-01-03 | Republican | 5 | |||||||||||||
26179 | 26179 | John Beamer B000276 | rep | IN | 1953-01-03 | 1955-01-03 | Republican | 5 | |||||||||||||
26180 | 26180 | John Beamer B000276 | rep | IN | 1955-01-05 | 1957-01-03 | Republican | 5 | |||||||||||||
26181 | 26181 | John Beamer B000276 | rep | IN | 1957-01-03 | 1959-01-03 | Republican | 5 | |||||||||||||
18040 | 18040 | John Benham B000361 | rep | IN | 1919-05-19 | 1921-03-03 | Republican | 4 | |||||||||||||
18041 | 18041 | John Benham B000361 | rep | IN | 1921-04-11 | 1923-03-03 | Republican | 4 | |||||||||||||
32473 | 32473 | Adam Benjamin B000363 | rep | IN | 1977-01-04 | 1979-01-03 | Democrat | 1 | |||||||||||||
32474 | 32474 | Adam Benjamin B000363 | rep | IN | 1979-01-15 | 1981-01-03 | Democrat | 1 | |||||||||||||
32475 | 32475 | Adam Benjamin B000363 | rep | IN | 1981-01-05 | 1983-01-03 | Democrat | 1 | |||||||||||||
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 | |||||||||||||
10011 | 10011 | George Bicknell B000438 | rep | IN | 1877-10-15 | 1879-03-03 | Democrat | 3 | |||||||||||||
10012 | 10012 | George Bicknell B000438 | rep | IN | 1879-03-18 | 1881-03-03 | Democrat | 3 | |||||||||||||
2798 | 2798 | Thomas Blake B000534 | rep | IN | 1827-12-03 | 1829-03-03 | Adams | 1 | |||||||||||||
18051 | 18051 | Oscar Bland B000542 | rep | IN | 1917-04-02 | 1919-03-03 | Republican | 2 | |||||||||||||
18052 | 18052 | Oscar Bland B000542 | rep | IN | 1919-05-19 | 1921-03-03 | Republican | 2 | |||||||||||||
18053 | 18053 | Oscar Bland B000542 | rep | IN | 1921-04-11 | 1923-03-03 | Republican | 2 | |||||||||||||
15871 | 15871 | John Boehne B000587 | rep | IN | 1909-03-15 | 1911-03-03 | Democrat | 1 | |||||||||||||
15872 | 15872 | John Boehne B000587 | rep | IN | 1911-04-04 | 1913-03-03 | Democrat | 1 | |||||||||||||
22874 | 22874 | John Boehne B000588 | rep | IN | 1931-12-07 | 1933-03-03 | Democrat | 1 | |||||||||||||
22875 | 22875 | John Boehne B000588 | rep | IN | 1933-03-09 | 1935-01-03 | Democrat | 8 | |||||||||||||
22876 | 22876 | John Boehne B000588 | rep | IN | 1935-01-03 | 1937-01-03 | Democrat | 8 | |||||||||||||
22877 | 22877 | John Boehne B000588 | rep | IN | 1937-01-05 | 1939-01-03 | Democrat | 8 | |||||||||||||
22878 | 22878 | John Boehne B000588 | rep | IN | 1939-01-03 | 1941-01-03 | Democrat | 8 | |||||||||||||
22879 | 22879 | John Boehne B000588 | rep | IN | 1941-01-03 | 1943-01-03 | Democrat | 8 | |||||||||||||
4134 | 4134 | Ratliff Boon B000628 | rep | IN | 1825-12-05 | 1827-03-03 | Jackson | 1 | |||||||||||||
4135 | 4135 | Ratliff Boon B000628 | rep | IN | 1829-12-07 | 1831-03-03 | Jackson | 1 | |||||||||||||
4136 | 4136 | Ratliff Boon B000628 | rep | IN | 1831-12-05 | 1833-03-03 | Jackson | 1 | |||||||||||||
4137 | 4137 | Ratliff Boon B000628 | rep | IN | 1833-12-02 | 1835-03-03 | Jackson | 1 | |||||||||||||
4138 | 4138 | Ratliff Boon B000628 | rep | IN | 1835-12-07 | 1837-03-03 | Jackson | 1 | |||||||||||||
4139 | 4139 | Ratliff Boon B000628 | rep | IN | 1837-09-04 | 1839-03-03 | Democrat | 1 | |||||||||||||
31956 | 31956 | John Brademas B000736 | rep | IN | 1959-01-07 | 1961-01-03 | Democrat | 3 | |||||||||||||
31957 | 31957 | John Brademas B000736 | rep | IN | 1961-01-03 | 1963-01-03 | Democrat | 3 | |||||||||||||
31958 | 31958 | John Brademas B000736 | rep | IN | 1963-01-09 | 1965-01-03 | Democrat | 3 | |||||||||||||
31959 | 31959 | John Brademas B000736 | rep | IN | 1965-01-04 | 1967-01-03 | Democrat | 3 | |||||||||||||
31960 | 31960 | John Brademas B000736 | rep | IN | 1967-01-10 | 1969-01-03 | Democrat | 3 | |||||||||||||
31961 | 31961 | John Brademas B000736 | rep | IN | 1969-01-03 | 1971-01-03 | Democrat | 3 | |||||||||||||
31962 | 31962 | John Brademas B000736 | rep | IN | 1971-01-21 | 1973-01-03 | Democrat | 3 | |||||||||||||
31963 | 31963 | John Brademas B000736 | rep | IN | 1973-01-03 | 1975-01-03 | Democrat | 3 | |||||||||||||
31964 | 31964 | John Brademas B000736 | rep | IN | 1975-01-14 | 1977-01-03 | Democrat | 3 | |||||||||||||
31965 | 31965 | John Brademas B000736 | rep | IN | 1977-01-04 | 1979-01-03 | Democrat | 3 | |||||||||||||
31966 | 31966 | John Brademas B000736 | rep | IN | 1979-01-15 | 1981-01-03 | Democrat | 3 | |||||||||||||
30183 | 30183 | William Bray B000778 | rep | IN | 1951-01-03 | 1953-01-03 | Republican | 7 | |||||||||||||
30184 | 30184 | William Bray B000778 | rep | IN | 1953-01-03 | 1955-01-03 | Republican | 7 | |||||||||||||
30185 | 30185 | William Bray B000778 | rep | IN | 1955-01-05 | 1957-01-03 | Republican | 7 | |||||||||||||
30186 | 30186 | William Bray B000778 | rep | IN | 1957-01-03 | 1959-01-03 | Republican | 7 | |||||||||||||
30187 | 30187 | William Bray B000778 | rep | IN | 1959-01-07 | 1961-01-03 | Republican | 7 | |||||||||||||
30188 | 30188 | William Bray B000778 | rep | IN | 1961-01-03 | 1963-01-03 | Republican | 7 | |||||||||||||
30189 | 30189 | William Bray B000778 | rep | IN | 1963-01-09 | 1965-01-03 | Republican | 7 | |||||||||||||
30190 | 30190 | William Bray B000778 | rep | IN | 1965-01-04 | 1967-01-03 | Republican | 7 | |||||||||||||
30191 | 30191 | William Bray B000778 | rep | IN | 1967-01-10 | 1969-01-03 | Republican | 6 | |||||||||||||
30192 | 30192 | William Bray B000778 | rep | IN | 1969-01-03 | 1971-01-03 | Republican | 6 | |||||||||||||
30193 | 30193 | William Bray B000778 | rep | IN | 1971-01-21 | 1973-01-03 | Republican | 6 | |||||||||||||
30194 | 30194 | William Bray B000778 | rep | IN | 1973-01-03 | 1975-01-03 | Republican | 6 | |||||||||||||
6988 | 6988 | Samuel Brenton B000805 | rep | IN | 1851-12-01 | 1853-03-03 | Whig | 10 | |||||||||||||
6989 | 6989 | Samuel Brenton B000805 | rep | IN | 1855-12-03 | 1857-03-03 | Ind. Republican-Democrat | 10 | |||||||||||||
6990 | 6990 | Samuel Brenton B000805 | rep | IN | 1857-12-07 | 1859-03-03 | Republican | 10 | |||||||||||||
12436 | 12436 | John Bretz B000807 | rep | IN | 1891-12-07 | 1893-03-03 | Democrat | 2 | |||||||||||||
12437 | 12437 | John Bretz B000807 | rep | IN | 1893-08-07 | 1895-03-03 | Democrat | 2 | |||||||||||||
14990 | 14990 | Abraham Brick B000819 | rep | IN | 1899-12-04 | 1901-03-03 | Republican | 13 | |||||||||||||
14991 | 14991 | Abraham Brick B000819 | rep | IN | 1901-12-02 | 1903-03-03 | Republican | 13 | |||||||||||||
14992 | 14992 | Abraham Brick B000819 | rep | IN | 1903-11-09 | 1905-03-03 | Republican | 13 | |||||||||||||
14993 | 14993 | Abraham Brick B000819 | rep | IN | 1905-12-04 | 1907-03-03 | Republican | 13 | |||||||||||||
14994 | 14994 | Abraham Brick B000819 | rep | IN | 1907-12-02 | 1909-03-03 | Republican | 13 | |||||||||||||
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 | |||||||||||||
12441 | 12441 | Elijah Brookshire B000886 | rep | IN | 1889-12-02 | 1891-03-03 | Democrat | 8 | |||||||||||||
12442 | 12442 | Elijah Brookshire B000886 | rep | IN | 1891-12-07 | 1893-03-03 | Democrat | 8 |
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);