legislator_terms

Table actions Table actions

1,207 rows where state = "IN"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: type, class, party, district, start (date), end (date)

Link rowid ▼ legislator_id type state start end class party district how party_affiliations caucus url address phone fax contact_form office state_rank rss_url end-type
877 877 P000052 rep IN 1805-12-02 1807-03-03     -1                        
878 878 P000052 rep IN 1807-10-26 1809-03-03     -1                        
2157 2157 T000102 sen IN 1816-01-01 1819-03-03 3 Republican                          
2158 2158 T000102 sen IN 1819-12-06 1825-03-03 3 Republican                          
2388 2388 C000049 rep IN 1823-12-01 1825-03-03   Jackson Republican 1                        
2464 2464 P000540 rep IN 1823-12-01 1825-03-03   Republican 1                        
2499 2499 T000171 rep IN 1807-10-26 1809-03-03   Democratic Republican -1                        
2798 2798 B000534 rep IN 1827-12-03 1829-03-03   Adams 1                        
2915 2915 N000118 sen IN 1816-01-01 1821-03-03 1 Republican                          
2916 2916 N000118 sen IN 1821-12-03 1827-03-03 1 Adams                          
2917 2917 N000118 sen IN 1827-12-03 1831-12-31 1 Adams                          
3146 3146 J000097 rep IN 1809-05-22 1811-03-03     -1                        
3147 3147 J000097 rep IN 1811-11-04 1813-03-03     -1                        
3148 3148 J000097 rep IN 1813-05-24 1815-03-03     -1                        
3149 3149 J000097 rep IN 1815-12-04 1817-03-03     -1                        
3150 3150 J000097 rep IN 1821-12-03 1823-03-03   Republican 1                        
3151 3151 J000097 rep IN 1823-12-01 1825-03-03     2                        
3152 3152 J000097 rep IN 1825-12-05 1827-03-03   Adams 2                        
3153 3153 J000097 rep IN 1827-12-03 1829-03-03   Adams 2                        
3154 3154 J000097 rep IN 1829-12-07 1831-03-03     2                        
3244 3244 T000138 rep IN 1823-12-01 1825-03-03     3                        
3245 3245 T000138 rep IN 1825-12-05 1827-03-03   Adams 3                        
3246 3246 T000138 rep IN 1829-12-07 1831-03-03     3                        
3398 3398 H000165 sen IN 1831-12-05 1833-03-03 1 Anti-Jacksonian                          
3399 3399 H000494 rep IN 1815-12-04 1817-03-03   Republican 1                        
3400 3400 H000494 rep IN 1817-12-01 1819-03-03   Republican 1                        
3401 3401 H000494 rep IN 1819-12-06 1821-03-03   Republican 1                        
3402 3402 H000494 rep IN 1821-12-03 1823-03-03   Republican 1                        
3403 3403 H000494 sen IN 1825-12-05 1831-03-03 3 Adams                          
3404 3404 H000494 sen IN 1831-12-05 1837-03-03 3 Adams                          
3588 3588 T000284 sen IN 1832-01-03 1833-03-02 1 Democrat                          
3589 3589 T000284 sen IN 1833-12-02 1839-03-03 1 Democrat                          
3975 3975 K000224 rep IN 1833-12-02 1835-03-03   Jackson 6                        
3976 3976 K000224 rep IN 1835-12-07 1837-03-03   Jackson 6                        
3981 3981 L000057 rep IN 1833-12-02 1835-03-03   Jackson 4                        
3982 3982 L000057 rep IN 1835-12-07 1837-03-03   Jackson 4                        
4012 4012 M000320 rep IN 1831-12-05 1833-03-03   Jackson 3                        
4013 4013 M000320 rep IN 1833-12-02 1835-03-03   Jackson 5                        
4014 4014 M000320 rep IN 1835-12-07 1837-03-03   Anti Jacksonian 5                        
4134 4134 B000628 rep IN 1825-12-05 1827-03-03   Jackson 1                        
4135 4135 B000628 rep IN 1829-12-07 1831-03-03   Jackson 1                        
4136 4136 B000628 rep IN 1831-12-05 1833-03-03   Jackson 1                        
4137 4137 B000628 rep IN 1833-12-02 1835-03-03   Jackson 1                        
4138 4138 B000628 rep IN 1835-12-07 1837-03-03   Jackson 1                        
4139 4139 B000628 rep IN 1837-09-04 1839-03-03   Democrat 1                        
4196 4196 D000547 rep IN 1837-09-04 1839-03-03   Whig 4                        
4198 4198 E000277 rep IN 1833-12-02 1835-03-03   Whig 2                        
4199 4199 E000277 rep IN 1837-09-04 1839-03-03   Whig 2                        
4209 4209 G000361 rep IN 1837-09-04 1839-03-03   Whig 3                        
4232 4232 H000536 rep IN 1835-12-07 1837-03-03   Whig 6                        
4233 4233 H000536 rep IN 1837-09-04 1839-03-03   Whig 6                        
4350 4350 S000599 rep IN 1827-12-03 1829-03-03   Jackson 3                        
4351 4351 S000599 sen IN 1837-09-04 1843-03-03 3 Whig                          
4414 4414 C000177 rep IN 1831-12-05 1833-03-03   Jackson 2                        
4415 4415 C000177 rep IN 1833-12-02 1835-03-03   Jackson 3                        
4416 4416 C000177 rep IN 1835-12-07 1837-03-03   Jackson 3                        
4417 4417 C000177 rep IN 1839-12-02 1841-03-03   Democrat 3                        
4518 4518 H000844 rep IN 1839-12-02 1841-03-03   Democrat 7                        
4582 4582 R000066 rep IN 1837-09-04 1839-03-03   Whig 5                        
4583 4583 R000066 rep IN 1839-12-02 1841-03-03   Whig 5                        
4756 4756 C000884 rep IN 1841-05-31 1843-03-03   Whig 4                        
4945 4945 P000548 rep IN 1839-12-02 1841-03-03   Whig 1                        
4946 4946 P000548 rep IN 1841-05-31 1843-03-03   Whig 1                        
5047 5047 W000076 rep IN 1841-05-31 1843-03-03   Whig 6                        
5065 5065 W000382 rep IN 1841-05-31 1843-03-03   Whig 3                        
5212 5212 H000167 rep IN 1835-12-07 1837-03-03   Jackson 7                        
5213 5213 H000167 sen IN 1843-12-04 1849-03-03 3 Democrat                          
5281 5281 S000024 rep IN 1843-12-04 1845-03-03   Whig 9                        
5399 5399 D000120 rep IN 1835-12-07 1837-03-03   Jackson 2                        
5400 5400 D000120 rep IN 1839-12-02 1841-03-03   Democrat 2                        
5401 5401 D000120 rep IN 1843-12-04 1845-03-03   Democrat 6                        
5402 5402 D000120 rep IN 1845-12-01 1847-03-03   Democrat 6                        
5464 5464 K000102 rep IN 1841-05-31 1843-03-03   Democrat 5                        
5465 5465 K000102 rep IN 1843-12-04 1845-03-03   Democrat 10                        
5466 5466 K000102 rep IN 1845-12-01 1847-03-03   Democrat 10                        
5490 5490 O000152 rep IN 1843-12-04 1845-03-03   Democrat 1                        
5491 5491 O000152 rep IN 1845-12-01 1847-03-03   Democrat 1                        
5521 5521 S000615 rep IN 1839-12-02 1841-03-03   Democrat 4                        
5522 5522 S000615 rep IN 1843-12-04 1845-03-03   Democrat 3                        
5523 5523 S000615 rep IN 1845-12-01 1847-03-03   Democrat 3                        
5687 5687 E000169 rep IN 1847-12-06 1849-03-03   Whig 1                        
5716 5716 H000499 rep IN 1843-12-04 1845-03-03   Democrat 2                        
5717 5717 H000499 rep IN 1845-12-01 1847-03-03   Democrat 2                        
5718 5718 H000499 rep IN 1847-12-06 1849-03-03   Democrat 2                        
5809 5809 R000364 rep IN 1847-12-06 1849-03-03   Democrat 10                        
5822 5822 S000519 rep IN 1843-12-04 1845-03-03   Whig 4                        
5823 5823 S000519 rep IN 1845-12-01 1847-03-03   Whig 4                        
5824 5824 S000519 rep IN 1847-12-06 1849-03-03   Whig 4                        
5842 5842 T000214 rep IN 1841-05-31 1843-03-03   Whig 2                        
5843 5843 T000214 rep IN 1847-12-06 1849-03-03   Whig 7                        
5854 5854 W000436 rep IN 1839-12-02 1841-03-03   Democrat 6                        
5855 5855 W000436 rep IN 1845-12-01 1847-03-03   Democrat 5                        
5856 5856 W000436 rep IN 1847-12-06 1849-03-03   Democrat 5                        
5889 5889 A000075 rep IN 1849-12-03 1851-03-03   Democrat 1                        
5914 5914 B000950 rep IN 1843-12-04 1845-03-03   Democrat 5                        
5915 5915 B000950 rep IN 1849-12-03 1851-03-03   Democrat 5                        
6058 6058 M000443 rep IN 1845-12-01 1847-03-03   Whig 7                        
6059 6059 M000443 rep IN 1849-12-03 1851-03-03   Whig 7                        
6170 6170 W000349 sen IN 1849-12-03 1853-03-03 3 Democrat                          
6313 6313 G000330 rep IN 1849-12-03 1851-03-03   Democrat 6                        

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

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, [caucus] TEXT, [url] TEXT, [address] TEXT, [phone] TEXT, [fax] TEXT, [contact_form] TEXT, [office] TEXT, [state_rank] TEXT, [rss_url] TEXT, [end-type] TEXT);