legislator_terms
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
391 rows where "end" is on date 1891-03-03 sorted by state
This data as json, copyable, CSV (advanced)
Suggested facets: state, district, start (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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
11849 | 11849 | John McDuffie M000428 | rep | AL | 1889-12-02 | 1891-03-03 | Republican | 4 | |||||||||||||
12171 | 12171 | William Forney F000280 | rep | AL | 1889-12-02 | 1891-03-03 | Democrat | 7 | |||||||||||||
12206 | 12206 | Hilary Herbert H000524 | rep | AL | 1889-12-02 | 1891-03-03 | Democrat | 2 | |||||||||||||
12273 | 12273 | James Pugh P000561 | sen | AL | 1885-12-07 | 1891-03-03 | 3 | Democrat | |||||||||||||
12738 | 12738 | William Oates O000005 | rep | AL | 1889-12-02 | 1891-03-03 | Democrat | 3 | |||||||||||||
12836 | 12836 | Louis Turpin T000434 | rep | AL | 1889-12-02 | 1891-03-03 | Democrat | 4 | |||||||||||||
12940 | 12940 | Richard Clarke C000469 | rep | AL | 1889-12-02 | 1891-03-03 | Democrat | 1 | |||||||||||||
12945 | 12945 | James Cobb C000549 | rep | AL | 1889-12-02 | 1891-03-03 | Democrat | 5 | |||||||||||||
13824 | 13824 | Joseph Wheeler W000338 | rep | AL | 1889-12-02 | 1891-03-03 | Democrat | 8 | |||||||||||||
17547 | 17547 | John Bankhead B000110 | rep | AL | 1889-12-02 | 1891-03-03 | Democrat | 6 | |||||||||||||
11752 | 11752 | Lewis Featherstone F000056 | rep | AR | 1889-12-02 | 1891-03-03 | Union Labor | 1 | |||||||||||||
11939 | 11939 | John Rogers R000399 | rep | AR | 1889-12-02 | 1891-03-03 | Democrat | 4 | |||||||||||||
12131 | 12131 | William Cate C000249 | rep | AR | 1889-12-02 | 1891-03-03 | Democrat | 1 | |||||||||||||
12268 | 12268 | Samuel Peel P000184 | rep | AR | 1889-12-02 | 1891-03-03 | Democrat | 5 | |||||||||||||
12428 | 12428 | Clifton Breckinridge B000784 | rep | AR | 1889-12-02 | 1891-03-03 | Democrat | 2 | |||||||||||||
13364 | 13364 | James Jones J000231 | sen | AR | 1885-12-07 | 1891-03-03 | 3 | Democrat | |||||||||||||
14067 | 14067 | Thomas McRae M000597 | rep | AR | 1889-12-02 | 1891-03-03 | Democrat | 3 | |||||||||||||
16971 | 16971 | Marcus Smith S000589 | rep | AZ | 1889-12-02 | 1891-03-03 | Democrat | 0 | |||||||||||||
11608 | 11608 | Marion Biggs B000458 | rep | CA | 1889-12-02 | 1891-03-03 | Democrat | 2 | |||||||||||||
11673 | 11673 | Thomas Clunie C000536 | rep | CA | 1889-12-02 | 1891-03-03 | Democrat | 5 | |||||||||||||
11725 | 11725 | John De Haven D000200 | rep | CA | 1889-12-02 | 1891-03-03 | Republican | 1 | |||||||||||||
11873 | 11873 | William Morrow M001006 | rep | CA | 1889-12-02 | 1891-03-03 | Republican | 4 | |||||||||||||
12002 | 12002 | William Vandever V000031 | rep | CA | 1889-12-02 | 1891-03-03 | Republican | 6 | |||||||||||||
12240 | 12240 | Joseph McKenna M000500 | rep | CA | 1889-12-02 | 1891-03-03 | Republican | 3 | |||||||||||||
12302 | 12302 | Leland Stanford S000793 | sen | CA | 1885-12-07 | 1891-03-03 | 3 | Republican | |||||||||||||
12566 | 12566 | Thomas Geary G000113 | rep | CA | 1889-12-02 | 1891-03-03 | Democrat | 1 | |||||||||||||
12336 | 12336 | Hosea Townsend T000334 | rep | CO | 1889-12-02 | 1891-03-03 | Republican | 1 | |||||||||||||
14494 | 14494 | Henry Teller T000116 | sen | CO | 1885-12-07 | 1891-03-03 | 3 | Republican | |||||||||||||
11855 | 11855 | Frederick Miles M000704 | rep | CT | 1889-12-02 | 1891-03-03 | Republican | 4 | |||||||||||||
11960 | 11960 | William Simonds S000424 | rep | CT | 1889-12-02 | 1891-03-03 | Republican | 1 | |||||||||||||
12361 | 12361 | Washington Willcox W000480 | rep | CT | 1889-12-02 | 1891-03-03 | Democrat | 2 | |||||||||||||
14146 | 14146 | Charles Russell R000521 | rep | CT | 1889-12-02 | 1891-03-03 | Republican | 3 | |||||||||||||
14434 | 14434 | Orville Platt P000382 | sen | CT | 1885-12-07 | 1891-03-03 | 3 | Republican | |||||||||||||
11893 | 11893 | John Penington P000209 | rep | DE | 1889-12-02 | 1891-03-03 | Democrat | 0 | |||||||||||||
11838 | 11838 | George Mathews M000235 | rep | DK | 1889-12-02 | 1891-03-03 | Republican | -1 | |||||||||||||
11724 | 11724 | Robert Davidson D000085 | rep | FL | 1889-12-02 | 1891-03-03 | Democrat | 1 | |||||||||||||
12109 | 12109 | Robert Bullock B001052 | rep | FL | 1889-12-02 | 1891-03-03 | Democrat | 2 | |||||||||||||
12124 | 12124 | Wilkinson Call C000051 | sen | FL | 1885-12-07 | 1891-03-03 | 3 | Democrat | |||||||||||||
10979 | 10979 | Joseph Brown B000936 | sen | GA | 1885-12-07 | 1891-03-03 | 3 | Democrat | |||||||||||||
11591 | 11591 | George Barnes B000157 | rep | GA | 1889-12-02 | 1891-03-03 | Democrat | 10 | |||||||||||||
11651 | 11651 | Allen Candler C000109 | rep | GA | 1889-12-02 | 1891-03-03 | Democrat | 9 | |||||||||||||
11655 | 11655 | Henry Carlton C000155 | rep | GA | 1889-12-02 | 1891-03-03 | Democrat | 8 | |||||||||||||
11672 | 11672 | Judson Clements C000508 | rep | GA | 1889-12-02 | 1891-03-03 | Democrat | 7 | |||||||||||||
11775 | 11775 | Thomas Grimes G000476 | rep | GA | 1889-12-02 | 1891-03-03 | Democrat | 4 | |||||||||||||
11972 | 11972 | John Stewart S000914 | rep | GA | 1889-12-02 | 1891-03-03 | Democrat | 5 | |||||||||||||
12095 | 12095 | James Blount B000568 | rep | GA | 1889-12-02 | 1891-03-03 | Democrat | 6 | |||||||||||||
12974 | 12974 | Charles Crisp C000908 | rep | GA | 1889-12-02 | 1891-03-03 | Democrat | 3 | |||||||||||||
13187 | 13187 | Henry Turner T000421 | rep | GA | 1889-12-02 | 1891-03-03 | Democrat | 2 | |||||||||||||
14771 | 14771 | Rufus Lester L000255 | rep | GA | 1889-12-02 | 1891-03-03 | Democrat | 1 | |||||||||||||
11684 | 11684 | Edwin Conger C000675 | rep | IA | 1889-12-02 | 1891-03-03 | Republican | 7 | |||||||||||||
11779 | 11779 | Edward Hays H000404 | rep | IA | 1889-12-02 | 1891-03-03 | Republican | 7 | |||||||||||||
11807 | 11807 | Daniel Kerr K000134 | rep | IA | 1889-12-02 | 1891-03-03 | Republican | 5 | |||||||||||||
11931 | 11931 | Joseph Reed R000124 | rep | IA | 1889-12-02 | 1891-03-03 | Republican | 9 | |||||||||||||
11978 | 11978 | Isaac Struble S001028 | rep | IA | 1889-12-02 | 1891-03-03 | Republican | 11 | |||||||||||||
11979 | 11979 | Joseph Sweney S001112 | rep | IA | 1889-12-02 | 1891-03-03 | Republican | 4 | |||||||||||||
12157 | 12157 | James Flick F000206 | rep | IA | 1889-12-02 | 1891-03-03 | Republican | 8 | |||||||||||||
12610 | 12610 | Walter Hayes H000394 | rep | IA | 1889-12-02 | 1891-03-03 | Democrat | 2 | |||||||||||||
13007 | 13007 | John Gear G000110 | rep | IA | 1889-12-02 | 1891-03-03 | Republican | 1 | |||||||||||||
13993 | 13993 | David Henderson H000478 | rep | IA | 1889-12-02 | 1891-03-03 | Republican | 3 | |||||||||||||
14233 | 14233 | William Allison A000160 | sen | IA | 1885-12-07 | 1891-03-03 | 3 | Republican | |||||||||||||
14760 | 14760 | John Lacey L000010 | rep | IA | 1889-12-02 | 1891-03-03 | Republican | 6 | |||||||||||||
15081 | 15081 | Jonathan Dolliver D000404 | rep | IA | 1889-12-02 | 1891-03-03 | Republican | 10 | |||||||||||||
12063 | 12063 | William McConnell M000357 | sen | ID | 1890-01-01 | 1891-03-03 | 3 | Republican | |||||||||||||
12822 | 12822 | Willis Sweet S001110 | rep | ID | 1889-12-02 | 1891-03-03 | Republican | 1 | |||||||||||||
13937 | 13937 | Fred Dubois D000509 | rep | ID | 1889-12-02 | 1891-03-03 | Republican | -1 | |||||||||||||
11367 | 11367 | Charles Farwell F000037 | sen | IL | 1887-12-05 | 1891-03-03 | 3 | Republican | |||||||||||||
11558 | 11558 | George Adams A000034 | rep | IL | 1889-12-02 | 1891-03-03 | Republican | 4 | |||||||||||||
11763 | 11763 | William Gest G000143 | rep | IL | 1889-12-02 | 1891-03-03 | Republican | 11 | |||||||||||||
11781 | 11781 | Charles Hill H000588 | rep | IL | 1889-12-02 | 1891-03-03 | Republican | 8 | |||||||||||||
11821 | 11821 | Frank Lawler L000128 | rep | IL | 1889-12-02 | 1891-03-03 | Democrat | 2 | |||||||||||||
11891 | 11891 | Lewis Payson P000157 | rep | IL | 1889-12-02 | 1891-03-03 | Republican | 9 | |||||||||||||
11943 | 11943 | Jonathan Rowell R000478 | rep | IL | 1889-12-02 | 1891-03-03 | Republican | 14 | |||||||||||||
11993 | 11993 | Richard Townshend T000339 | rep | IL | 1889-12-02 | 1891-03-03 | Democrat | 19 | |||||||||||||
12314 | 12314 | Abner Taylor T000062 | rep | IL | 1889-12-02 | 1891-03-03 | Republican | 1 | |||||||||||||
12359 | 12359 | Scott Wike W000451 | rep | IL | 1889-12-02 | 1891-03-03 | Democrat | 12 | |||||||||||||
12550 | 12550 | George Fithian F000162 | rep | IL | 1889-12-02 | 1891-03-03 | Democrat | 16 | |||||||||||||
12553 | 12553 | William Forman F000275 | rep | IL | 1889-12-02 | 1891-03-03 | Democrat | 18 | |||||||||||||
12630 | 12630 | Thomas Henderson H000489 | rep | IL | 1889-12-02 | 1891-03-03 | Republican | 7 | |||||||||||||
12660 | 12660 | Edward Lane L000058 | rep | IL | 1889-12-02 | 1891-03-03 | Democrat | 17 | |||||||||||||
12803 | 12803 | William Springer S000757 | rep | IL | 1889-12-02 | 1891-03-03 | Democrat | 13 | |||||||||||||
13128 | 13128 | Philip Post P000457 | rep | IL | 1889-12-02 | 1891-03-03 | Republican | 10 | |||||||||||||
14349 | 14349 | Albert Hopkins H000770 | rep | IL | 1889-12-02 | 1891-03-03 | Republican | 5 | |||||||||||||
14528 | 14528 | James Williams W000508 | rep | IL | 1889-12-02 | 1891-03-03 | Democrat | 19 | |||||||||||||
14719 | 14719 | Robert Hitt H000649 | rep | IL | 1889-12-02 | 1891-03-03 | Republican | 6 | |||||||||||||
15289 | 15289 | George Smith S000541 | rep | IL | 1889-12-02 | 1891-03-03 | Republican | 20 | |||||||||||||
18101 | 18101 | Joseph Cannon C000121 | rep | IL | 1889-12-02 | 1891-03-03 | Republican | 15 | |||||||||||||
18336 | 18336 | William Mason M000228 | rep | IL | 1889-12-02 | 1891-03-03 | Republican | 3 | |||||||||||||
11628 | 11628 | Thomas Browne B000958 | rep | IN | 1889-12-02 | 1891-03-03 | Republican | 6 | |||||||||||||
11665 | 11665 | Joseph Cheadle C000339 | rep | IN | 1889-12-02 | 1891-03-03 | Republican | 9 | |||||||||||||
11880 | 11880 | John O’Neall O000091 | rep | IN | 1889-12-02 | 1891-03-03 | Democrat | 2 | |||||||||||||
11886 | 11886 | William Owen O000155 | rep | IN | 1889-12-02 | 1891-03-03 | Republican | 10 | |||||||||||||
12235 | 12235 | Charles McClellan M000329 | rep | IN | 1889-12-02 | 1891-03-03 | Democrat | 12 | |||||||||||||
12261 | 12261 | William Parrett P000078 | rep | IN | 1889-12-02 | 1891-03-03 | Democrat | 1 | |||||||||||||
12352 | 12352 | Daniel Voorhees V000116 | sen | IN | 1885-12-07 | 1891-03-03 | 3 | Democrat | |||||||||||||
12441 | 12441 | Elijah Brookshire B000886 | rep | IN | 1889-12-02 | 1891-03-03 | Democrat | 8 | |||||||||||||
12444 | 12444 | Jason Brown B000924 | rep | IN | 1889-12-02 | 1891-03-03 | Democrat | 3 | |||||||||||||
12458 | 12458 | William Bynum B001205 | rep | IN | 1889-12-02 | 1891-03-03 | Democrat | 7 | |||||||||||||
12501 | 12501 | George Cooper C000750 | rep | IN | 1889-12-02 | 1891-03-03 | Democrat | 5 | |||||||||||||
12677 | 12677 | Augustus Martin M000167 | rep | IN | 1889-12-02 | 1891-03-03 | Democrat | 11 | |||||||||||||
13346 | 13346 | William Holman H000732 | rep | IN | 1889-12-02 | 1891-03-03 | Democrat | 4 |
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);