legislator_terms
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
1,187 rows where state = "IN"
This data as json, copyable, CSV (advanced)
Suggested facets: district, how, fax, contact_form, state_rank, rss_url, 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
877 | 877 | Benjamin Parke P000052 | rep | IN | 1805-12-02 | 1807-03-03 | -1 | ||||||||||||||
878 | 878 | Benjamin Parke P000052 | rep | IN | 1807-10-26 | 1809-03-03 | -1 | ||||||||||||||
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 | |||||||||||||
2388 | 2388 | Jacob Call C000049 | rep | IN | 1823-12-01 | 1825-03-03 | Jackson Republican | 1 | |||||||||||||
2464 | 2464 | William Prince P000540 | rep | IN | 1823-12-01 | 1825-03-03 | Republican | 1 | |||||||||||||
2499 | 2499 | Jesse Thomas T000171 | rep | IN | 1807-10-26 | 1809-03-03 | Democratic Republican | -1 | |||||||||||||
2798 | 2798 | Thomas Blake B000534 | rep | IN | 1827-12-03 | 1829-03-03 | Adams | 1 | |||||||||||||
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 | |||||||||||||
3146 | 3146 | Jonathan Jennings J000097 | rep | IN | 1809-05-22 | 1811-03-03 | -1 | ||||||||||||||
3147 | 3147 | Jonathan Jennings J000097 | rep | IN | 1811-11-04 | 1813-03-03 | -1 | ||||||||||||||
3148 | 3148 | Jonathan Jennings J000097 | rep | IN | 1813-05-24 | 1815-03-03 | -1 | ||||||||||||||
3149 | 3149 | Jonathan Jennings J000097 | rep | IN | 1815-12-04 | 1817-03-03 | -1 | ||||||||||||||
3150 | 3150 | Jonathan Jennings J000097 | rep | IN | 1821-12-03 | 1823-03-03 | Republican | 1 | |||||||||||||
3151 | 3151 | Jonathan Jennings J000097 | rep | IN | 1823-12-01 | 1825-03-03 | 2 | ||||||||||||||
3152 | 3152 | Jonathan Jennings J000097 | rep | IN | 1825-12-05 | 1827-03-03 | Adams | 2 | |||||||||||||
3153 | 3153 | Jonathan Jennings J000097 | rep | IN | 1827-12-03 | 1829-03-03 | Adams | 2 | |||||||||||||
3154 | 3154 | Jonathan Jennings J000097 | rep | IN | 1829-12-07 | 1831-03-03 | 2 | ||||||||||||||
3244 | 3244 | John Test T000138 | rep | IN | 1823-12-01 | 1825-03-03 | 3 | ||||||||||||||
3245 | 3245 | John Test T000138 | rep | IN | 1825-12-05 | 1827-03-03 | Adams | 3 | |||||||||||||
3246 | 3246 | John Test T000138 | rep | IN | 1829-12-07 | 1831-03-03 | 3 | ||||||||||||||
3398 | 3398 | Robert Hanna H000165 | sen | IN | 1831-12-05 | 1833-03-03 | 1 | Anti-Jacksonian | |||||||||||||
3399 | 3399 | William Hendricks H000494 | rep | IN | 1815-12-04 | 1817-03-03 | Republican | 1 | |||||||||||||
3400 | 3400 | William Hendricks H000494 | rep | IN | 1817-12-01 | 1819-03-03 | Republican | 1 | |||||||||||||
3401 | 3401 | William Hendricks H000494 | rep | IN | 1819-12-06 | 1821-03-03 | Republican | 1 | |||||||||||||
3402 | 3402 | William Hendricks H000494 | rep | IN | 1821-12-03 | 1823-03-03 | Republican | 1 | |||||||||||||
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 | |||||||||||||
3975 | 3975 | George Kinnard K000224 | rep | IN | 1833-12-02 | 1835-03-03 | Jackson | 6 | |||||||||||||
3976 | 3976 | George Kinnard K000224 | rep | IN | 1835-12-07 | 1837-03-03 | Jackson | 6 | |||||||||||||
3981 | 3981 | Amos Lane L000057 | rep | IN | 1833-12-02 | 1835-03-03 | Jackson | 4 | |||||||||||||
3982 | 3982 | Amos Lane L000057 | rep | IN | 1835-12-07 | 1837-03-03 | Jackson | 4 | |||||||||||||
4012 | 4012 | Johnathan McCarty M000320 | rep | IN | 1831-12-05 | 1833-03-03 | Jackson | 3 | |||||||||||||
4013 | 4013 | Johnathan McCarty M000320 | rep | IN | 1833-12-02 | 1835-03-03 | Jackson | 5 | |||||||||||||
4014 | 4014 | Johnathan McCarty M000320 | rep | IN | 1835-12-07 | 1837-03-03 | Anti Jacksonian | 5 | |||||||||||||
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 | |||||||||||||
4196 | 4196 | George Dunn D000547 | rep | IN | 1837-09-04 | 1839-03-03 | Whig | 4 | |||||||||||||
4198 | 4198 | John Ewing E000277 | rep | IN | 1833-12-02 | 1835-03-03 | Whig | 2 | |||||||||||||
4199 | 4199 | John Ewing E000277 | rep | IN | 1837-09-04 | 1839-03-03 | Whig | 2 | |||||||||||||
4209 | 4209 | William Graham G000361 | rep | IN | 1837-09-04 | 1839-03-03 | Whig | 3 | |||||||||||||
4232 | 4232 | William Herod H000536 | rep | IN | 1835-12-07 | 1837-03-03 | Whig | 6 | |||||||||||||
4233 | 4233 | William Herod H000536 | rep | IN | 1837-09-04 | 1839-03-03 | Whig | 6 | |||||||||||||
4350 | 4350 | Oliver Smith S000599 | rep | IN | 1827-12-03 | 1829-03-03 | Jackson | 3 | |||||||||||||
4351 | 4351 | Oliver Smith S000599 | sen | IN | 1837-09-04 | 1843-03-03 | 3 | Whig | |||||||||||||
4414 | 4414 | John Carr C000177 | rep | IN | 1831-12-05 | 1833-03-03 | Jackson | 2 | |||||||||||||
4415 | 4415 | John Carr C000177 | rep | IN | 1833-12-02 | 1835-03-03 | Jackson | 3 | |||||||||||||
4416 | 4416 | John Carr C000177 | rep | IN | 1835-12-07 | 1837-03-03 | Jackson | 3 | |||||||||||||
4417 | 4417 | John Carr C000177 | rep | IN | 1839-12-02 | 1841-03-03 | Democrat | 3 | |||||||||||||
4518 | 4518 | Tilghman Howard H000844 | rep | IN | 1839-12-02 | 1841-03-03 | Democrat | 7 | |||||||||||||
4582 | 4582 | James Rariden R000066 | rep | IN | 1837-09-04 | 1839-03-03 | Whig | 5 | |||||||||||||
4583 | 4583 | James Rariden R000066 | rep | IN | 1839-12-02 | 1841-03-03 | Whig | 5 | |||||||||||||
4756 | 4756 | James Cravens C000884 | rep | IN | 1841-05-31 | 1843-03-03 | Whig | 4 | |||||||||||||
4945 | 4945 | George Proffit P000548 | rep | IN | 1839-12-02 | 1841-03-03 | Whig | 1 | |||||||||||||
4946 | 4946 | George Proffit P000548 | rep | IN | 1841-05-31 | 1843-03-03 | Whig | 1 | |||||||||||||
5047 | 5047 | David Wallace W000076 | rep | IN | 1841-05-31 | 1843-03-03 | Whig | 6 | |||||||||||||
5065 | 5065 | Joseph White W000382 | rep | IN | 1841-05-31 | 1843-03-03 | Whig | 3 | |||||||||||||
5212 | 5212 | Edward Hannegan H000167 | rep | IN | 1835-12-07 | 1837-03-03 | Jackson | 7 | |||||||||||||
5213 | 5213 | Edward Hannegan H000167 | sen | IN | 1843-12-04 | 1849-03-03 | 3 | Democrat | |||||||||||||
5281 | 5281 | Samuel Sample S000024 | rep | IN | 1843-12-04 | 1845-03-03 | Whig | 9 | |||||||||||||
5399 | 5399 | John Davis D000120 | rep | IN | 1835-12-07 | 1837-03-03 | Jackson | 2 | |||||||||||||
5400 | 5400 | John Davis D000120 | rep | IN | 1839-12-02 | 1841-03-03 | Democrat | 2 | |||||||||||||
5401 | 5401 | John Davis D000120 | rep | IN | 1843-12-04 | 1845-03-03 | Democrat | 6 | |||||||||||||
5402 | 5402 | John Davis D000120 | rep | IN | 1845-12-01 | 1847-03-03 | Democrat | 6 | |||||||||||||
5464 | 5464 | Andrew Kennedy K000102 | rep | IN | 1841-05-31 | 1843-03-03 | Democrat | 5 | |||||||||||||
5465 | 5465 | Andrew Kennedy K000102 | rep | IN | 1843-12-04 | 1845-03-03 | Democrat | 10 | |||||||||||||
5466 | 5466 | Andrew Kennedy K000102 | rep | IN | 1845-12-01 | 1847-03-03 | Democrat | 10 | |||||||||||||
5490 | 5490 | Robert Owen O000152 | rep | IN | 1843-12-04 | 1845-03-03 | Democrat | 1 | |||||||||||||
5491 | 5491 | Robert Owen O000152 | rep | IN | 1845-12-01 | 1847-03-03 | Democrat | 1 | |||||||||||||
5521 | 5521 | Thomas Smith S000615 | rep | IN | 1839-12-02 | 1841-03-03 | Democrat | 4 | |||||||||||||
5522 | 5522 | Thomas Smith S000615 | rep | IN | 1843-12-04 | 1845-03-03 | Democrat | 3 | |||||||||||||
5523 | 5523 | Thomas Smith S000615 | rep | IN | 1845-12-01 | 1847-03-03 | Democrat | 3 | |||||||||||||
5687 | 5687 | Elisha Embree E000169 | rep | IN | 1847-12-06 | 1849-03-03 | Whig | 1 | |||||||||||||
5716 | 5716 | Thomas Henley H000499 | rep | IN | 1843-12-04 | 1845-03-03 | Democrat | 2 | |||||||||||||
5717 | 5717 | Thomas Henley H000499 | rep | IN | 1845-12-01 | 1847-03-03 | Democrat | 2 | |||||||||||||
5718 | 5718 | Thomas Henley H000499 | rep | IN | 1847-12-06 | 1849-03-03 | Democrat | 2 | |||||||||||||
5809 | 5809 | William Rockhill R000364 | rep | IN | 1847-12-06 | 1849-03-03 | Democrat | 10 | |||||||||||||
5822 | 5822 | Caleb Smith S000519 | rep | IN | 1843-12-04 | 1845-03-03 | Whig | 4 | |||||||||||||
5823 | 5823 | Caleb Smith S000519 | rep | IN | 1845-12-01 | 1847-03-03 | Whig | 4 | |||||||||||||
5824 | 5824 | Caleb Smith S000519 | rep | IN | 1847-12-06 | 1849-03-03 | Whig | 4 | |||||||||||||
5842 | 5842 | Richard Thompson T000214 | rep | IN | 1841-05-31 | 1843-03-03 | Whig | 2 | |||||||||||||
5843 | 5843 | Richard Thompson T000214 | rep | IN | 1847-12-06 | 1849-03-03 | Whig | 7 | |||||||||||||
5854 | 5854 | William Wick W000436 | rep | IN | 1839-12-02 | 1841-03-03 | Democrat | 6 | |||||||||||||
5855 | 5855 | William Wick W000436 | rep | IN | 1845-12-01 | 1847-03-03 | Democrat | 5 | |||||||||||||
5856 | 5856 | William Wick W000436 | rep | IN | 1847-12-06 | 1849-03-03 | Democrat | 5 | |||||||||||||
5889 | 5889 | Nathaniel Albertson A000075 | rep | IN | 1849-12-03 | 1851-03-03 | Democrat | 1 | |||||||||||||
5914 | 5914 | William Brown B000950 | rep | IN | 1843-12-04 | 1845-03-03 | Democrat | 5 | |||||||||||||
5915 | 5915 | William Brown B000950 | rep | IN | 1849-12-03 | 1851-03-03 | Democrat | 5 | |||||||||||||
6058 | 6058 | Edward McGaughey M000443 | rep | IN | 1845-12-01 | 1847-03-03 | Whig | 7 | |||||||||||||
6059 | 6059 | Edward McGaughey M000443 | rep | IN | 1849-12-03 | 1851-03-03 | Whig | 7 | |||||||||||||
6170 | 6170 | James Whitcomb W000349 | sen | IN | 1849-12-03 | 1853-03-03 | 3 | Democrat | |||||||||||||
6313 | 6313 | Willis Gorman G000330 | rep | IN | 1849-12-03 | 1851-03-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);