legislator_terms
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
383 rows where "end" is on date 1893-03-03 sorted by legislator_id
This data as json, copyable, CSV (advanced)
Suggested facets: state, party, 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
12888 | 12888 | Jo Abbott A000005 | rep | TX | 1891-12-07 | 1893-03-03 | Democrat | 6 | |||||||||||||
12396 | 12396 | John Alderson A000080 | rep | WV | 1891-12-07 | 1893-03-03 | Democrat | 3 | |||||||||||||
14558 | 14558 | Nelson Aldrich A000083 | sen | RI | 1887-12-05 | 1893-03-03 | 1 | Republican | |||||||||||||
12398 | 12398 | Sydenham Alexander A000102 | rep | NC | 1891-12-07 | 1893-03-03 | Democrat | 6 | |||||||||||||
11562 | 11562 | John Allen A000130 | sen | WA | 1889-11-19 | 1893-03-03 | 1 | Republican | |||||||||||||
13551 | 13551 | John Allen A000134 | rep | MS | 1891-12-07 | 1893-03-03 | Democrat | 1 | |||||||||||||
12066 | 12066 | Lemuel Amerman A000171 | rep | PA | 1891-12-07 | 1893-03-03 | Democrat | 11 | |||||||||||||
12068 | 12068 | John Andrew A000242 | rep | MA | 1891-12-07 | 1893-03-03 | Democrat | 3 | |||||||||||||
12069 | 12069 | Edwin Antony A000264 | rep | TX | 1891-12-07 | 1893-03-03 | Democrat | 9 | |||||||||||||
12400 | 12400 | Marshall Arnold A000292 | rep | MO | 1891-12-07 | 1893-03-03 | Democrat | 14 | |||||||||||||
12074 | 12074 | Louis Atkinson A000331 | rep | PA | 1891-12-07 | 1893-03-03 | Republican | 18 | |||||||||||||
12075 | 12075 | Clinton Babbitt B000001 | rep | WI | 1891-12-07 | 1893-03-03 | Democrat | 1 | |||||||||||||
12078 | 12078 | Henry Bacon B000016 | rep | NY | 1891-12-07 | 1893-03-03 | Democrat | 15 | |||||||||||||
14969 | 14969 | Joseph Bailey B000044 | rep | TX | 1891-12-07 | 1893-03-03 | Democrat | 5 | |||||||||||||
12909 | 12909 | William Baker B000075 | rep | KS | 1891-12-07 | 1893-03-03 | Populist | 6 | |||||||||||||
17548 | 17548 | John Bankhead B000110 | rep | AL | 1891-12-07 | 1893-03-03 | Democrat | 6 | |||||||||||||
11588 | 11588 | John Barbour B000129 | sen | VA | 1889-12-02 | 1893-03-03 | 2 | Democrat | |||||||||||||
12080 | 12080 | Horace Bartine B000197 | rep | NV | 1891-12-07 | 1893-03-03 | Republican | 0 | |||||||||||||
12405 | 12405 | Charles Barwig B000218 | rep | WI | 1891-12-07 | 1893-03-03 | Democrat | 2 | |||||||||||||
13569 | 13569 | William Bate B000227 | sen | TN | 1887-12-05 | 1893-03-03 | 1 | Democrat | |||||||||||||
12081 | 12081 | Joseph Beeman B000309 | rep | MS | 1891-12-07 | 1893-03-03 | Democrat | 5 | |||||||||||||
13251 | 13251 | James Belden B000325 | rep | NY | 1891-12-07 | 1893-03-03 | Republican | 25 | |||||||||||||
12083 | 12083 | Charles Belknap B000328 | rep | MI | 1891-12-07 | 1893-03-03 | Republican | 5 | |||||||||||||
12410 | 12410 | Frank Beltzhoover B000355 | rep | PA | 1891-12-07 | 1893-03-03 | Democrat | 19 | |||||||||||||
12084 | 12084 | Henry Bentley B000393 | rep | NY | 1891-12-07 | 1893-03-03 | Democrat | 23 | |||||||||||||
12086 | 12086 | Christopher Bergen B000404 | rep | NJ | 1891-12-07 | 1893-03-03 | Republican | 1 | |||||||||||||
15860 | 15860 | Henry Bingham B000469 | rep | PA | 1891-12-07 | 1893-03-03 | Republican | 1 | |||||||||||||
12881 | 12881 | Newton Blanchard B000541 | rep | LA | 1891-12-07 | 1893-03-03 | Democrat | 4 | |||||||||||||
13585 | 13585 | Richard Bland B000544 | rep | MO | 1891-12-07 | 1893-03-03 | Democrat | 11 | |||||||||||||
11299 | 11299 | Rufus Blodgett B000562 | sen | NJ | 1887-12-05 | 1893-03-03 | 1 | Democrat | |||||||||||||
12096 | 12096 | James Blount B000568 | rep | GA | 1891-12-07 | 1893-03-03 | Democrat | 6 | |||||||||||||
12921 | 12921 | Charles Boatner B000580 | rep | LA | 1891-12-07 | 1893-03-03 | Democrat | 5 | |||||||||||||
12097 | 12097 | David Boody B000625 | rep | NY | 1891-12-07 | 1893-03-03 | Democrat | 2 | |||||||||||||
13875 | 13875 | Charles Boutelle B000673 | rep | ME | 1891-12-07 | 1893-03-03 | Republican | 4 | |||||||||||||
12924 | 12924 | William Bowers B000692 | rep | CA | 1891-12-07 | 1893-03-03 | Republican | 6 | |||||||||||||
12098 | 12098 | Thomas Bowman B000706 | rep | IA | 1891-12-07 | 1893-03-03 | Democrat | 9 | |||||||||||||
12420 | 12420 | William Branch B000765 | rep | NC | 1891-12-07 | 1893-03-03 | Democrat | 1 | |||||||||||||
12423 | 12423 | William Brawley B000775 | rep | SC | 1891-12-07 | 1893-03-03 | Democrat | 1 | |||||||||||||
12429 | 12429 | Clifton Breckinridge B000784 | rep | AR | 1891-12-07 | 1893-03-03 | Democrat | 2 | |||||||||||||
12434 | 12434 | William Breckinridge B000790 | rep | KY | 1891-12-07 | 1893-03-03 | Democrat | 7 | |||||||||||||
12436 | 12436 | John Bretz B000807 | rep | IN | 1891-12-07 | 1893-03-03 | Democrat | 2 | |||||||||||||
12439 | 12439 | George Brickner B000821 | rep | WI | 1891-12-07 | 1893-03-03 | Democrat | 5 | |||||||||||||
13265 | 13265 | Case Broderick B000856 | rep | KS | 1891-12-07 | 1893-03-03 | Republican | 1 | |||||||||||||
12442 | 12442 | Elijah Brookshire B000886 | rep | IN | 1891-12-07 | 1893-03-03 | Democrat | 8 | |||||||||||||
13888 | 13888 | Marriott Brosius B000892 | rep | PA | 1891-12-07 | 1893-03-03 | Republican | 10 | |||||||||||||
12445 | 12445 | Jason Brown B000924 | rep | IN | 1891-12-07 | 1893-03-03 | Democrat | 3 | |||||||||||||
12100 | 12100 | John Brown B000930 | rep | MD | 1891-12-07 | 1893-03-03 | Democrat | 1 | |||||||||||||
12102 | 12102 | David Brunner B000980 | rep | PA | 1891-12-07 | 1893-03-03 | Democrat | 9 | |||||||||||||
12447 | 12447 | William Bryan B000995 | rep | NE | 1891-12-07 | 1893-03-03 | Democrat | 1 | |||||||||||||
12106 | 12106 | James Buchanan B001004 | rep | NJ | 1891-12-07 | 1893-03-03 | Republican | 2 | |||||||||||||
12108 | 12108 | John Buchanan B001007 | rep | VA | 1891-12-07 | 1893-03-03 | Democrat | 9 | |||||||||||||
12110 | 12110 | Robert Bullock B001052 | rep | FL | 1891-12-07 | 1893-03-03 | Democrat | 2 | |||||||||||||
12453 | 12453 | Benjamin Bunn B001062 | rep | NC | 1891-12-07 | 1893-03-03 | Democrat | 4 | |||||||||||||
12111 | 12111 | Thomas Bunting B001067 | rep | NY | 1891-12-07 | 1893-03-03 | Democrat | 33 | |||||||||||||
14609 | 14609 | Julius Burrows B001142 | rep | MI | 1891-12-07 | 1893-03-03 | Republican | 4 | |||||||||||||
12112 | 12112 | Samuel Busey B001164 | rep | IL | 1891-12-07 | 1893-03-03 | Democrat | 15 | |||||||||||||
12113 | 12113 | Allen Bushnell B001170 | rep | WI | 1891-12-07 | 1893-03-03 | Democrat | 3 | |||||||||||||
12114 | 12114 | Walter Butler B001193 | rep | IA | 1891-12-07 | 1893-03-03 | Democrat | 4 | |||||||||||||
12459 | 12459 | William Bynum B001205 | rep | IN | 1891-12-07 | 1893-03-03 | Democrat | 7 | |||||||||||||
12115 | 12115 | Samuel Byrns B001219 | rep | MO | 1891-12-07 | 1893-03-03 | Democrat | 10 | |||||||||||||
12116 | 12116 | Benjamin Cable C000006 | rep | IL | 1891-12-07 | 1893-03-03 | Democrat | 11 | |||||||||||||
12462 | 12462 | Cornelius Cadmus C000010 | rep | NJ | 1891-12-07 | 1893-03-03 | Democrat | 5 | |||||||||||||
12122 | 12122 | John Caine C000023 | rep | UT | 1891-12-07 | 1893-03-03 | Democrat | -1 | |||||||||||||
12465 | 12465 | John Caldwell C000034 | rep | OH | 1891-12-07 | 1893-03-03 | Republican | 2 | |||||||||||||
12469 | 12469 | Anthony Caminetti C000069 | rep | CA | 1891-12-07 | 1893-03-03 | Democrat | 2 | |||||||||||||
12473 | 12473 | Timothy Campbell C000103 | rep | NY | 1891-12-07 | 1893-03-03 | Democrat | 8 | |||||||||||||
12476 | 12476 | James Capehart C000129 | rep | WV | 1891-12-07 | 1893-03-03 | Democrat | 4 | |||||||||||||
12480 | 12480 | Asher Caruth C000208 | rep | KY | 1891-12-07 | 1893-03-03 | Democrat | 5 | |||||||||||||
11656 | 11656 | Lyman Casey C000227 | sen | ND | 1889-12-02 | 1893-03-03 | 1 | Republican | |||||||||||||
12130 | 12130 | James Castle C000242 | rep | MN | 1891-12-07 | 1893-03-03 | Democrat | 4 | |||||||||||||
13601 | 13601 | Thomas Catchings C000247 | rep | MS | 1891-12-07 | 1893-03-03 | Democrat | 3 | |||||||||||||
12132 | 12132 | William Cate C000249 | rep | AR | 1891-12-07 | 1893-03-03 | Democrat | 1 | |||||||||||||
12482 | 12482 | John Causey C000257 | rep | DE | 1891-12-07 | 1893-03-03 | Democrat | 0 | |||||||||||||
12133 | 12133 | Alfred Chapin C000304 | rep | NY | 1891-12-07 | 1893-03-03 | Democrat | 1 | |||||||||||||
12135 | 12135 | Henry Cheatham C000340 | rep | NC | 1891-12-07 | 1893-03-03 | Republican | 2 | |||||||||||||
12937 | 12937 | Horace Chilton C000357 | sen | TX | 1891-12-07 | 1893-03-03 | 1 | Democrat | |||||||||||||
12487 | 12487 | John Chipman C000367 | rep | MI | 1891-12-07 | 1893-03-03 | Democrat | 1 | |||||||||||||
12490 | 12490 | John Clancy C000410 | rep | NY | 1891-12-07 | 1893-03-03 | Democrat | 4 | |||||||||||||
15894 | 15894 | Clarence Clark C000425 | rep | WY | 1891-12-07 | 1893-03-03 | Republican | 0 | |||||||||||||
12941 | 12941 | Richard Clarke C000469 | rep | AL | 1891-12-07 | 1893-03-03 | Democrat | 1 | |||||||||||||
12136 | 12136 | Benjamin Clover C000533 | rep | KS | 1891-12-07 | 1893-03-03 | Populist | 3 | |||||||||||||
12946 | 12946 | James Cobb C000549 | rep | AL | 1891-12-07 | 1893-03-03 | Democrat | 5 | |||||||||||||
12949 | 12949 | Seth Cobb C000550 | rep | MO | 1891-12-07 | 1893-03-03 | Democrat | 9 | |||||||||||||
12137 | 12137 | Frank Coburn C000557 | rep | WI | 1891-12-07 | 1893-03-03 | Democrat | 7 | |||||||||||||
18594 | 18594 | William Cockran C000575 | rep | NY | 1891-12-07 | 1893-03-03 | Democrat | 10 | |||||||||||||
13618 | 13618 | Francis Cockrell C000576 | sen | MO | 1887-12-05 | 1893-03-03 | 1 | Democrat | |||||||||||||
12958 | 12958 | William Cogswell C000595 | rep | MA | 1891-12-07 | 1893-03-03 | Republican | 7 | |||||||||||||
12496 | 12496 | Barnes Compton C000660 | rep | MD | 1891-12-07 | 1893-03-03 | Democrat | 5 | |||||||||||||
12138 | 12138 | Frederick Coolidge C000739 | rep | MA | 1891-12-07 | 1893-03-03 | Democrat | 11 | |||||||||||||
12499 | 12499 | William Coombs C000742 | rep | NY | 1891-12-07 | 1893-03-03 | Democrat | 3 | |||||||||||||
12502 | 12502 | George Cooper C000750 | rep | IN | 1891-12-07 | 1893-03-03 | Democrat | 5 | |||||||||||||
12508 | 12508 | James Covert C000814 | rep | NY | 1891-12-07 | 1893-03-03 | Democrat | 1 | |||||||||||||
12142 | 12142 | William Cowles C000829 | rep | NC | 1891-12-07 | 1893-03-03 | Democrat | 8 | |||||||||||||
12143 | 12143 | Isaac Cox C000832 | rep | NY | 1891-12-07 | 1893-03-03 | Democrat | 17 | |||||||||||||
13621 | 13621 | Nicholas Cox C000838 | rep | TN | 1891-12-07 | 1893-03-03 | Democrat | 7 | |||||||||||||
12144 | 12144 | Alexander Craig C000854 | rep | PA | 1891-12-07 | 1893-03-03 | Democrat | 24 | |||||||||||||
12968 | 12968 | William Crain C000865 | rep | TX | 1891-12-07 | 1893-03-03 | Democrat | 7 | |||||||||||||
15052 | 15052 | William Crawford C000896 | rep | NC | 1891-12-07 | 1893-03-03 | Democrat | 9 | |||||||||||||
12975 | 12975 | Charles Crisp C000908 | rep | GA | 1891-12-07 | 1893-03-03 | Democrat | 3 | |||||||||||||
12145 | 12145 | John Crosby C000929 | rep | MA | 1891-12-07 | 1893-03-03 | Democrat | 12 |
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);