legislator_terms
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
415 rows where "end" is on date 1895-03-03 sorted by legislator_id
This data as json, copyable, CSV (advanced)
Suggested facets: type, start, class, 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
12889 | 12889 | Jo Abbott A000005 | rep | TX | 1893-08-07 | 1895-03-03 | Democrat | 6 | |||||||||||||
14548 | 14548 | Robert Adams A000044 | rep | PA | 1893-08-07 | 1895-03-03 | Republican | 2 | |||||||||||||
12394 | 12394 | Silas Adams A000047 | rep | KY | 1893-08-07 | 1895-03-03 | Republican | 11 | |||||||||||||
12891 | 12891 | David Aitken A000068 | rep | MI | 1893-08-07 | 1895-03-03 | Republican | 6 | |||||||||||||
12397 | 12397 | John Alderson A000080 | rep | WV | 1893-08-07 | 1895-03-03 | Democrat | 3 | |||||||||||||
12893 | 12893 | James Aldrich A000082 | rep | IL | 1893-08-07 | 1895-03-03 | Republican | 1 | |||||||||||||
12399 | 12399 | Sydenham Alexander A000102 | rep | NC | 1893-08-07 | 1895-03-03 | Democrat | 6 | |||||||||||||
13552 | 13552 | John Allen A000134 | rep | MS | 1893-08-07 | 1895-03-03 | Democrat | 1 | |||||||||||||
12898 | 12898 | Lewis Apsley A000271 | rep | MA | 1893-08-07 | 1895-03-03 | Republican | 4 | |||||||||||||
12401 | 12401 | Marshall Arnold A000292 | rep | MO | 1893-08-07 | 1895-03-03 | Democrat | 14 | |||||||||||||
12904 | 12904 | John Avery A000346 | rep | MI | 1893-08-07 | 1895-03-03 | Republican | 11 | |||||||||||||
14563 | 14563 | Joseph Babcock B000004 | rep | WI | 1893-08-07 | 1895-03-03 | Republican | 3 | |||||||||||||
14970 | 14970 | Joseph Bailey B000044 | rep | TX | 1893-08-07 | 1895-03-03 | Democrat | 5 | |||||||||||||
12906 | 12906 | Henry Baker B000061 | rep | NH | 1893-08-07 | 1895-03-03 | Republican | 2 | |||||||||||||
12910 | 12910 | William Baker B000075 | rep | KS | 1893-08-07 | 1895-03-03 | Populist | 6 | |||||||||||||
12402 | 12402 | Melvin Baldwin B000094 | rep | MN | 1893-08-07 | 1895-03-03 | Democrat | 6 | |||||||||||||
17549 | 17549 | John Bankhead B000110 | rep | AL | 1893-08-07 | 1895-03-03 | Democrat | 6 | |||||||||||||
12403 | 12403 | Lyman Barnes B000159 | rep | WI | 1893-08-07 | 1895-03-03 | Democrat | 8 | |||||||||||||
16262 | 16262 | Richard Bartholdt B000196 | rep | MO | 1893-08-07 | 1895-03-03 | Republican | 10 | |||||||||||||
12912 | 12912 | Franklin Bartlett B000202 | rep | NY | 1893-08-07 | 1895-03-03 | Democrat | 7 | |||||||||||||
12406 | 12406 | Charles Barwig B000218 | rep | WI | 1893-08-07 | 1895-03-03 | Democrat | 2 | |||||||||||||
12407 | 12407 | William Beckner B000294 | rep | KY | 1893-08-07 | 1895-03-03 | Democrat | 10 | |||||||||||||
13252 | 13252 | James Belden B000325 | rep | NY | 1893-08-07 | 1895-03-03 | Republican | 27 | |||||||||||||
12914 | 12914 | Charles Bell B000333 | rep | TX | 1893-08-07 | 1895-03-03 | Democrat | 8 | |||||||||||||
13850 | 13850 | John Bell B000341 | rep | CO | 1893-08-07 | 1895-03-03 | Populist | 2 | |||||||||||||
12411 | 12411 | Frank Beltzhoover B000355 | rep | PA | 1893-08-07 | 1895-03-03 | Democrat | 19 | |||||||||||||
13572 | 13572 | Albert Berry B000414 | rep | KY | 1893-08-07 | 1895-03-03 | Democrat | 6 | |||||||||||||
13859 | 13859 | James Berry B000418 | sen | AR | 1889-12-02 | 1895-03-03 | 2 | Democrat | |||||||||||||
15861 | 15861 | Henry Bingham B000469 | rep | PA | 1893-08-07 | 1895-03-03 | Republican | 1 | |||||||||||||
12917 | 12917 | James Black B000502 | rep | GA | 1893-08-07 | 1895-03-03 | Democrat | 10 | |||||||||||||
12412 | 12412 | John Black B000504 | rep | IL | 1893-08-07 | 1895-03-03 | Democrat | -1 | |||||||||||||
12417 | 12417 | Henry Blair B000524 | rep | NH | 1893-08-07 | 1895-03-03 | Republican | 1 | |||||||||||||
13586 | 13586 | Richard Bland B000544 | rep | MO | 1893-08-07 | 1895-03-03 | Democrat | 8 | |||||||||||||
12922 | 12922 | Charles Boatner B000580 | rep | LA | 1893-08-07 | 1895-03-03 | Democrat | 5 | |||||||||||||
12418 | 12418 | Haldor Boen B000590 | rep | MN | 1893-08-07 | 1895-03-03 | Populist | 7 | |||||||||||||
13876 | 13876 | Charles Boutelle B000673 | rep | ME | 1893-08-07 | 1895-03-03 | Republican | 4 | |||||||||||||
12419 | 12419 | William Bower B000688 | rep | NC | 1893-08-07 | 1895-03-03 | Democrat | 8 | |||||||||||||
12925 | 12925 | William Bowers B000692 | rep | CA | 1893-08-07 | 1895-03-03 | Republican | 7 | |||||||||||||
12421 | 12421 | William Branch B000765 | rep | NC | 1893-08-07 | 1895-03-03 | Democrat | 1 | |||||||||||||
12422 | 12422 | Robert Bratton B000773 | rep | MD | 1893-08-07 | 1895-03-03 | Democrat | 1 | |||||||||||||
12424 | 12424 | William Brawley B000775 | rep | SC | 1893-08-07 | 1895-03-03 | Democrat | 1 | |||||||||||||
12430 | 12430 | Clifton Breckinridge B000784 | rep | AR | 1893-08-07 | 1895-03-03 | Democrat | 2 | |||||||||||||
12435 | 12435 | William Breckinridge B000790 | rep | KY | 1893-08-07 | 1895-03-03 | Democrat | 7 | |||||||||||||
12437 | 12437 | John Bretz B000807 | rep | IN | 1893-08-07 | 1895-03-03 | Democrat | 2 | |||||||||||||
12440 | 12440 | George Brickner B000821 | rep | WI | 1893-08-07 | 1895-03-03 | Democrat | 5 | |||||||||||||
13266 | 13266 | Case Broderick B000856 | rep | KS | 1893-08-07 | 1895-03-03 | Republican | 1 | |||||||||||||
13882 | 13882 | Jacob Bromwell B000866 | rep | OH | 1893-08-07 | 1895-03-03 | Republican | 2 | |||||||||||||
12443 | 12443 | Elijah Brookshire B000886 | rep | IN | 1893-08-07 | 1895-03-03 | Democrat | 8 | |||||||||||||
13889 | 13889 | Marriott Brosius B000892 | rep | PA | 1893-08-07 | 1895-03-03 | Republican | 10 | |||||||||||||
12446 | 12446 | Jason Brown B000924 | rep | IN | 1893-08-07 | 1895-03-03 | Democrat | 3 | |||||||||||||
12448 | 12448 | William Bryan B000995 | rep | NE | 1893-08-07 | 1895-03-03 | Democrat | 1 | |||||||||||||
12451 | 12451 | Hezekiah Bundy B001059 | rep | OH | 1893-08-07 | 1895-03-03 | Republican | 10 | |||||||||||||
12454 | 12454 | Benjamin Bunn B001062 | rep | NC | 1893-08-07 | 1895-03-03 | Democrat | 4 | |||||||||||||
12455 | 12455 | Daniel Burnes B001115 | rep | MO | 1893-08-07 | 1895-03-03 | Democrat | 4 | |||||||||||||
14610 | 14610 | Julius Burrows B001142 | rep | MI | 1893-08-07 | 1895-03-03 | Republican | 3 | |||||||||||||
11638 | 11638 | Matthew Butler B001184 | sen | SC | 1889-12-02 | 1895-03-03 | 2 | Democrat | |||||||||||||
12460 | 12460 | William Bynum B001205 | rep | IN | 1893-08-07 | 1895-03-03 | Democrat | 7 | |||||||||||||
12461 | 12461 | Thomas Cabaniss C000001 | rep | GA | 1893-08-07 | 1895-03-03 | Democrat | 6 | |||||||||||||
12463 | 12463 | Cornelius Cadmus C000010 | rep | NJ | 1893-08-07 | 1895-03-03 | Democrat | 5 | |||||||||||||
12932 | 12932 | Donelson Caffery C000016 | sen | LA | 1892-01-01 | 1895-03-03 | 2 | Democrat | |||||||||||||
12466 | 12466 | John Caldwell C000034 | rep | OH | 1893-08-07 | 1895-03-03 | Republican | 2 | |||||||||||||
12468 | 12468 | Johnson Camden C000062 | sen | WV | 1893-08-07 | 1895-03-03 | 2 | Democrat | |||||||||||||
12470 | 12470 | Anthony Caminetti C000069 | rep | CA | 1893-08-07 | 1895-03-03 | Democrat | 2 | |||||||||||||
12474 | 12474 | Timothy Campbell C000103 | rep | NY | 1893-08-07 | 1895-03-03 | Democrat | 9 | |||||||||||||
18102 | 18102 | Joseph Cannon C000121 | rep | IL | 1893-08-07 | 1895-03-03 | Republican | 15 | |||||||||||||
12475 | 12475 | Marion Cannon C000122 | rep | CA | 1893-08-07 | 1895-03-03 | Populist | 6 | |||||||||||||
12477 | 12477 | James Capehart C000129 | rep | WV | 1893-08-07 | 1895-03-03 | Democrat | 4 | |||||||||||||
12055 | 12055 | Joseph Carey C000145 | sen | WY | 1890-11-15 | 1895-03-03 | 2 | Republican | |||||||||||||
12481 | 12481 | Asher Caruth C000208 | rep | KY | 1893-08-07 | 1895-03-03 | Democrat | 5 | |||||||||||||
13602 | 13602 | Thomas Catchings C000247 | rep | MS | 1893-08-07 | 1895-03-03 | Democrat | 3 | |||||||||||||
12483 | 12483 | John Causey C000257 | rep | DE | 1893-08-07 | 1895-03-03 | Democrat | 0 | |||||||||||||
12935 | 12935 | William Chandler C000298 | sen | NH | 1889-12-02 | 1895-03-03 | 2 | Republican | |||||||||||||
13607 | 13607 | Charles Chickering C000351 | rep | NY | 1893-08-07 | 1895-03-03 | Republican | 24 | |||||||||||||
12484 | 12484 | Robert Childs C000354 | rep | IL | 1893-08-07 | 1895-03-03 | Republican | 8 | |||||||||||||
12488 | 12488 | John Chipman C000367 | rep | MI | 1893-08-07 | 1895-03-03 | Democrat | 1 | |||||||||||||
12491 | 12491 | John Clancy C000410 | rep | NY | 1893-08-07 | 1895-03-03 | Democrat | 2 | |||||||||||||
17611 | 17611 | James Clark C000437 | rep | MO | 1893-08-07 | 1895-03-03 | Democrat | 9 | |||||||||||||
12942 | 12942 | Richard Clarke C000469 | rep | AL | 1893-08-07 | 1895-03-03 | Democrat | 1 | |||||||||||||
12947 | 12947 | James Cobb C000549 | rep | AL | 1893-08-07 | 1895-03-03 | Democrat | 5 | |||||||||||||
12950 | 12950 | Seth Cobb C000550 | rep | MO | 1893-08-07 | 1895-03-03 | Democrat | 12 | |||||||||||||
18595 | 18595 | William Cockran C000575 | rep | NY | 1893-08-07 | 1895-03-03 | Democrat | 12 | |||||||||||||
12952 | 12952 | Jeremiah Cockrell C000577 | rep | TX | 1893-08-07 | 1895-03-03 | Democrat | 13 | |||||||||||||
12492 | 12492 | Henry Coffeen C000585 | rep | WY | 1893-08-07 | 1895-03-03 | Democrat | 0 | |||||||||||||
12954 | 12954 | Charles Coffin C000588 | rep | MD | 1893-08-07 | 1895-03-03 | Republican | 5 | |||||||||||||
12959 | 12959 | William Cogswell C000595 | rep | MA | 1893-08-07 | 1895-03-03 | Republican | 6 | |||||||||||||
11676 | 11676 | Richard Coke C000601 | sen | TX | 1889-12-02 | 1895-03-03 | 2 | Democrat | |||||||||||||
11680 | 11680 | Alfred Colquitt C000647 | sen | GA | 1889-12-02 | 1895-03-03 | 2 | Democrat | |||||||||||||
12497 | 12497 | Barnes Compton C000660 | rep | MD | 1893-08-07 | 1895-03-03 | Democrat | 5 | |||||||||||||
12498 | 12498 | Charles Conn C000683 | rep | IN | 1893-08-07 | 1895-03-03 | Democrat | 13 | |||||||||||||
12500 | 12500 | William Coombs C000742 | rep | NY | 1893-08-07 | 1895-03-03 | Democrat | 4 | |||||||||||||
12962 | 12962 | Charles Cooper C000746 | rep | FL | 1893-08-07 | 1895-03-03 | Democrat | 2 | |||||||||||||
12503 | 12503 | George Cooper C000750 | rep | IN | 1893-08-07 | 1895-03-03 | Democrat | 5 | |||||||||||||
20231 | 20231 | Henry Cooper C000752 | rep | WI | 1893-08-07 | 1895-03-03 | Republican | 1 | |||||||||||||
15035 | 15035 | Samuel Cooper C000761 | rep | TX | 1893-08-07 | 1895-03-03 | Democrat | 2 | |||||||||||||
12504 | 12504 | Johnston Cornish C000786 | rep | NJ | 1893-08-07 | 1895-03-03 | Democrat | 4 | |||||||||||||
15042 | 15042 | Robert Cousins C000811 | rep | IA | 1893-08-07 | 1895-03-03 | Republican | 5 | |||||||||||||
12509 | 12509 | James Covert C000814 | rep | NY | 1893-08-07 | 1895-03-03 | Democrat | 1 | |||||||||||||
13622 | 13622 | Nicholas Cox C000838 | rep | TN | 1893-08-07 | 1895-03-03 | Democrat | 7 | |||||||||||||
12969 | 12969 | William Crain C000865 | rep | TX | 1893-08-07 | 1895-03-03 | Democrat | 11 | |||||||||||||
15053 | 15053 | William Crawford C000896 | rep | NC | 1893-08-07 | 1895-03-03 | Democrat | 9 |
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);