legislator_terms
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
364 rows where "end" is on date 1889-03-03 sorted by legislator_id
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
12886 | 12886 | Jo Abbott A000005 | rep | TX | 1887-12-05 | 1889-03-03 | Democrat | 6 | |||||||||||||
11557 | 11557 | George Adams A000034 | rep | IL | 1887-12-05 | 1889-03-03 | Republican | 4 | |||||||||||||
11284 | 11284 | Charles Allen A000116 | rep | MA | 1887-12-05 | 1889-03-03 | Republican | 8 | |||||||||||||
11559 | 11559 | Edward Allen A000119 | rep | MI | 1887-12-05 | 1889-03-03 | Republican | 2 | |||||||||||||
13549 | 13549 | John Allen A000134 | rep | MS | 1887-12-05 | 1889-03-03 | Democrat | 1 | |||||||||||||
11285 | 11285 | Albert Anderson A000180 | rep | IA | 1887-12-05 | 1889-03-03 | Ind. Republican | 8 | |||||||||||||
11563 | 11563 | Chapman Anderson A000183 | rep | MS | 1887-12-05 | 1889-03-03 | Democrat | 5 | |||||||||||||
11286 | 11286 | George Anderson A000187 | rep | IL | 1887-12-05 | 1889-03-03 | Democrat | 12 | |||||||||||||
11569 | 11569 | John Anderson A000194 | rep | KS | 1887-12-05 | 1889-03-03 | Ind. Republican | 5 | |||||||||||||
12900 | 12900 | Warren Arnold A000298 | rep | RI | 1887-12-05 | 1889-03-03 | Republican | 2 | |||||||||||||
12072 | 12072 | Louis Atkinson A000331 | rep | PA | 1887-12-05 | 1889-03-03 | Republican | 18 | |||||||||||||
12077 | 12077 | Henry Bacon B000016 | rep | NY | 1887-12-05 | 1889-03-03 | Democrat | 15 | |||||||||||||
11573 | 11573 | Charles Baker B000057 | rep | NY | 1887-12-05 | 1889-03-03 | Republican | 30 | |||||||||||||
13240 | 13240 | Jehu Baker B000066 | rep | IL | 1887-12-05 | 1889-03-03 | Republican | 18 | |||||||||||||
17546 | 17546 | John Bankhead B000110 | rep | AL | 1887-12-05 | 1889-03-03 | Democrat | 6 | |||||||||||||
11590 | 11590 | George Barnes B000157 | rep | GA | 1887-12-05 | 1889-03-03 | Democrat | 10 | |||||||||||||
11288 | 11288 | Frederick Barry B000188 | rep | MS | 1887-12-05 | 1889-03-03 | Democrat | 4 | |||||||||||||
11597 | 11597 | Thomas Bayne B000261 | rep | PA | 1887-12-05 | 1889-03-03 | Republican | 23 | |||||||||||||
11604 | 11604 | James Beck B000289 | sen | KY | 1883-12-03 | 1889-03-03 | 2 | Democrat | |||||||||||||
13249 | 13249 | James Belden B000325 | rep | NY | 1887-12-05 | 1889-03-03 | Republican | 25 | |||||||||||||
11292 | 11292 | Perry Belmont B000353 | rep | NY | 1887-12-05 | 1889-03-03 | Democrat | 1 | |||||||||||||
13858 | 13858 | James Berry B000418 | sen | AR | 1885-12-07 | 1889-03-03 | 2 | Democrat | |||||||||||||
11607 | 11607 | Marion Biggs B000458 | rep | CA | 1887-12-05 | 1889-03-03 | Democrat | 2 | |||||||||||||
15858 | 15858 | Henry Bingham B000469 | rep | PA | 1887-12-05 | 1889-03-03 | Republican | 1 | |||||||||||||
12879 | 12879 | Newton Blanchard B000541 | rep | LA | 1887-12-05 | 1889-03-03 | Democrat | 4 | |||||||||||||
13583 | 13583 | Richard Bland B000544 | rep | MO | 1887-12-05 | 1889-03-03 | Democrat | 11 | |||||||||||||
11298 | 11298 | Archibald Bliss B000558 | rep | NY | 1887-12-05 | 1889-03-03 | Democrat | 5 | |||||||||||||
12094 | 12094 | James Blount B000568 | rep | GA | 1887-12-05 | 1889-03-03 | Democrat | 6 | |||||||||||||
17563 | 17563 | Charles Booher B000626 | rep | MO | 1887-12-05 | 1889-03-03 | Democrat | 4 | |||||||||||||
11610 | 11610 | Melvin Boothman B000632 | rep | OH | 1887-12-05 | 1889-03-03 | Republican | 6 | |||||||||||||
11301 | 11301 | Franklin Bound B000667 | rep | PA | 1887-12-05 | 1889-03-03 | Republican | 14 | |||||||||||||
13873 | 13873 | Charles Boutelle B000673 | rep | ME | 1887-12-05 | 1889-03-03 | Republican | 4 | |||||||||||||
11612 | 11612 | George Bowden B000677 | rep | VA | 1887-12-05 | 1889-03-03 | Republican | 2 | |||||||||||||
11303 | 11303 | Henry Bowen B000683 | rep | VA | 1887-12-05 | 1889-03-03 | Republican | 9 | |||||||||||||
10642 | 10642 | Thomas Bowen B000686 | sen | CO | 1883-12-03 | 1889-03-03 | 2 | Republican | |||||||||||||
12427 | 12427 | Clifton Breckinridge B000784 | rep | AR | 1887-12-05 | 1889-03-03 | Democrat | 2 | |||||||||||||
12432 | 12432 | William Breckinridge B000790 | rep | KY | 1887-12-05 | 1889-03-03 | Democrat | 7 | |||||||||||||
11616 | 11616 | Mark Brewer B000811 | rep | MI | 1887-12-05 | 1889-03-03 | Republican | 6 | |||||||||||||
11618 | 11618 | John Brower B000898 | rep | NC | 1887-12-05 | 1889-03-03 | Republican | 5 | |||||||||||||
11305 | 11305 | Charles Brown B000907 | rep | OH | 1887-12-05 | 1889-03-03 | Republican | 2 | |||||||||||||
11306 | 11306 | John Brown B000931 | rep | VA | 1887-12-05 | 1889-03-03 | Republican | 5 | |||||||||||||
11620 | 11620 | Thomas Browne B000957 | rep | VA | 1887-12-05 | 1889-03-03 | Republican | 1 | |||||||||||||
11627 | 11627 | Thomas Browne B000958 | rep | IN | 1887-12-05 | 1889-03-03 | Republican | 6 | |||||||||||||
15001 | 15001 | Charles Brumm B000977 | rep | PA | 1887-12-05 | 1889-03-03 | Republican | 13 | |||||||||||||
11307 | 11307 | Lloyd Bryce B000998 | rep | NY | 1887-12-05 | 1889-03-03 | Democrat | 7 | |||||||||||||
12104 | 12104 | James Buchanan B001004 | rep | NJ | 1887-12-05 | 1889-03-03 | Republican | 2 | |||||||||||||
11630 | 11630 | Charles Buckalew B001019 | rep | PA | 1887-12-05 | 1889-03-03 | Democrat | 11 | |||||||||||||
11310 | 11310 | Frank Bunnell B001064 | rep | PA | 1887-12-05 | 1889-03-03 | Republican | 15 | |||||||||||||
11634 | 11634 | James Burnes B001116 | rep | MO | 1887-12-05 | 1889-03-03 | Democrat | 4 | |||||||||||||
11311 | 11311 | Edward Burnett B001119 | rep | MA | 1887-12-05 | 1889-03-03 | Democrat | 9 | |||||||||||||
14607 | 14607 | Julius Burrows B001142 | rep | MI | 1887-12-05 | 1889-03-03 | Republican | 4 | |||||||||||||
11637 | 11637 | Matthew Butler B001184 | sen | SC | 1883-12-03 | 1889-03-03 | 2 | Democrat | |||||||||||||
11316 | 11316 | Roderick Butler B001188 | rep | TN | 1887-12-05 | 1889-03-03 | Republican | 1 | |||||||||||||
11642 | 11642 | Benjamin Butterworth B001200 | rep | OH | 1887-12-05 | 1889-03-03 | Republican | 1 | |||||||||||||
12457 | 12457 | William Bynum B001205 | rep | IN | 1887-12-05 | 1889-03-03 | Democrat | 7 | |||||||||||||
12120 | 12120 | John Caine C000023 | rep | UT | 1887-12-05 | 1889-03-03 | Democrat | -1 | |||||||||||||
11646 | 11646 | Felix Campbell C000082 | rep | NY | 1887-12-05 | 1889-03-03 | Democrat | 2 | |||||||||||||
11319 | 11319 | James Campbell C000087 | rep | OH | 1887-12-05 | 1889-03-03 | Democrat | 7 | |||||||||||||
12472 | 12472 | Timothy Campbell C000103 | rep | NY | 1887-12-05 | 1889-03-03 | Democrat | 8 | |||||||||||||
11650 | 11650 | Allen Candler C000109 | rep | GA | 1887-12-05 | 1889-03-03 | Democrat | 9 | |||||||||||||
18100 | 18100 | Joseph Cannon C000121 | rep | IL | 1887-12-05 | 1889-03-03 | Republican | 15 | |||||||||||||
12053 | 12053 | Joseph Carey C000145 | rep | WY | 1887-12-05 | 1889-03-03 | Republican | 0 | |||||||||||||
12061 | 12061 | John Carlisle C000152 | rep | KY | 1887-12-05 | 1889-03-03 | Democrat | 6 | |||||||||||||
11654 | 11654 | Henry Carlton C000155 | rep | GA | 1887-12-05 | 1889-03-03 | Democrat | 8 | |||||||||||||
12478 | 12478 | Asher Caruth C000208 | rep | KY | 1887-12-05 | 1889-03-03 | Democrat | 5 | |||||||||||||
11662 | 11662 | Lucien Caswell C000245 | rep | WI | 1887-12-05 | 1889-03-03 | Republican | 1 | |||||||||||||
13599 | 13599 | Thomas Catchings C000247 | rep | MS | 1887-12-05 | 1889-03-03 | Democrat | 3 | |||||||||||||
11002 | 11002 | Jonathan Chace C000267 | sen | RI | 1885-12-07 | 1889-03-03 | 2 | Republican | |||||||||||||
12934 | 12934 | William Chandler C000298 | sen | NH | 1887-12-05 | 1889-03-03 | 2 | Republican | |||||||||||||
11664 | 11664 | Joseph Cheadle C000339 | rep | IN | 1887-12-05 | 1889-03-03 | Republican | 9 | |||||||||||||
12485 | 12485 | John Chipman C000367 | rep | MI | 1887-12-05 | 1889-03-03 | Democrat | 1 | |||||||||||||
11324 | 11324 | Martin Clardy C000417 | rep | MO | 1887-12-05 | 1889-03-03 | Democrat | 10 | |||||||||||||
11666 | 11666 | Charles Clark C000422 | rep | WI | 1887-12-05 | 1889-03-03 | Republican | 6 | |||||||||||||
11671 | 11671 | Judson Clements C000508 | rep | GA | 1887-12-05 | 1889-03-03 | Democrat | 7 | |||||||||||||
12944 | 12944 | James Cobb C000549 | rep | AL | 1887-12-05 | 1889-03-03 | Democrat | 5 | |||||||||||||
18593 | 18593 | William Cockran C000575 | rep | NY | 1887-12-05 | 1889-03-03 | Democrat | 12 | |||||||||||||
12956 | 12956 | William Cogswell C000595 | rep | MA | 1887-12-05 | 1889-03-03 | Republican | 7 | |||||||||||||
11675 | 11675 | Richard Coke C000601 | sen | TX | 1883-12-03 | 1889-03-03 | 2 | Democrat | |||||||||||||
11327 | 11327 | Patrick Collins C000641 | rep | MA | 1887-12-05 | 1889-03-03 | Democrat | 4 | |||||||||||||
11679 | 11679 | Alfred Colquitt C000647 | sen | GA | 1883-12-03 | 1889-03-03 | 2 | Democrat | |||||||||||||
12494 | 12494 | Barnes Compton C000660 | rep | MD | 1887-12-05 | 1889-03-03 | Democrat | 5 | |||||||||||||
11683 | 11683 | Edwin Conger C000675 | rep | IA | 1887-12-05 | 1889-03-03 | Republican | 7 | |||||||||||||
11687 | 11687 | William Cooper C000765 | rep | OH | 1887-12-05 | 1889-03-03 | Republican | 9 | |||||||||||||
11689 | 11689 | James Cothran C000798 | rep | SC | 1887-12-05 | 1889-03-03 | Democrat | 3 | |||||||||||||
12140 | 12140 | William Cowles C000829 | rep | NC | 1887-12-05 | 1889-03-03 | Democrat | 8 | |||||||||||||
11704 | 11704 | Samuel Cox C000839 | rep | NY | 1887-12-05 | 1889-03-03 | Democrat | 9 | |||||||||||||
12966 | 12966 | William Crain C000865 | rep | TX | 1887-12-05 | 1889-03-03 | Democrat | 7 | |||||||||||||
12973 | 12973 | Charles Crisp C000908 | rep | GA | 1887-12-05 | 1889-03-03 | Democrat | 3 | |||||||||||||
11328 | 11328 | George Crouse C000936 | rep | OH | 1887-12-05 | 1889-03-03 | Republican | 20 | |||||||||||||
12986 | 12986 | David Culberson C000964 | rep | TX | 1887-12-05 | 1889-03-03 | Democrat | 4 | |||||||||||||
15059 | 15059 | Shelby Cullom C000973 | sen | IL | 1883-12-03 | 1889-03-03 | 2 | Republican | |||||||||||||
13922 | 13922 | Amos Cummings C000983 | rep | NY | 1887-12-05 | 1889-03-03 | Democrat | 6 | |||||||||||||
11710 | 11710 | Byron Cutcheon C001022 | rep | MI | 1887-12-05 | 1889-03-03 | Republican | 9 | |||||||||||||
15917 | 15917 | John Dalzell D000016 | rep | PA | 1887-12-05 | 1889-03-03 | Republican | 22 | |||||||||||||
11714 | 11714 | George Dargan D000053 | rep | SC | 1887-12-05 | 1889-03-03 | Democrat | 6 | |||||||||||||
11716 | 11716 | Smedley Darlington D000058 | rep | PA | 1887-12-05 | 1889-03-03 | Republican | 6 | |||||||||||||
11330 | 11330 | Ira Davenport D000072 | rep | NY | 1887-12-05 | 1889-03-03 | Republican | 29 | |||||||||||||
11332 | 11332 | Alexander Davidson D000082 | rep | AL | 1887-12-05 | 1889-03-03 | Democrat | 4 | |||||||||||||
11723 | 11723 | Robert Davidson D000085 | rep | FL | 1887-12-05 | 1889-03-03 | Democrat | 1 | |||||||||||||
11335 | 11335 | Robert Davis D000130 | rep | MA | 1887-12-05 | 1889-03-03 | Republican | 1 |
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);