legislator_terms
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
337 rows where "end" is on date 1879-03-03 sorted by legislator_id
This data as json, copyable, CSV (advanced)
Suggested facets: type, start, 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
9992 | 9992 | Joseph Acklen A000023 | rep | LA | 1877-10-15 | 1879-03-03 | Democrat | 3 | |||||||||||||
10953 | 10953 | David Aiken A000061 | rep | SC | 1877-10-15 | 1879-03-03 | Democrat | 3 | |||||||||||||
10250 | 10250 | William Aldrich A000086 | rep | IL | 1877-10-15 | 1879-03-03 | Republican | 1 | |||||||||||||
14231 | 14231 | William Allison A000160 | sen | IA | 1873-12-01 | 1879-03-03 | 3 | Republican | |||||||||||||
9729 | 9729 | David Armstrong A000279 | sen | MO | 1877-10-15 | 1879-03-03 | 3 | Democrat | |||||||||||||
10261 | 10261 | John Atkins A000327 | rep | TN | 1877-10-15 | 1879-03-03 | Democrat | 8 | |||||||||||||
9730 | 9730 | William Bacon B000020 | rep | NY | 1877-10-15 | 1879-03-03 | Republican | 23 | |||||||||||||
9732 | 9732 | George Bagley B000032 | rep | NY | 1877-10-15 | 1879-03-03 | Republican | 22 | |||||||||||||
9995 | 9995 | John Bailey B000042 | rep | NY | 1877-10-15 | 1879-03-03 | Republican | 16 | |||||||||||||
9998 | 9998 | John Baker B000068 | rep | IN | 1877-10-15 | 1879-03-03 | Republican | 13 | |||||||||||||
9735 | 9735 | William Baker B000077 | rep | NY | 1877-10-15 | 1879-03-03 | Republican | 24 | |||||||||||||
10002 | 10002 | Latimer Ballou B000106 | rep | RI | 1877-10-15 | 1879-03-03 | Republican | 2 | |||||||||||||
11583 | 11583 | Nathaniel Banks B000116 | rep | MA | 1877-10-15 | 1879-03-03 | Republican | 5 | |||||||||||||
9738 | 9738 | Henry Banning B000117 | rep | OH | 1877-10-15 | 1879-03-03 | Democrat | 2 | |||||||||||||
9713 | 9713 | William Barnum B000166 | sen | CT | 1876-01-01 | 1879-03-03 | 3 | Democrat | |||||||||||||
11592 | 11592 | Thomas Bayne B000261 | rep | PA | 1877-10-15 | 1879-03-03 | Republican | 23 | |||||||||||||
10007 | 10007 | Richard Beale B000268 | rep | VA | 1877-10-15 | 1879-03-03 | Democrat | 1 | |||||||||||||
9740 | 9740 | George Beebe B000305 | rep | NY | 1877-10-15 | 1879-03-03 | Democrat | 14 | |||||||||||||
10634 | 10634 | James Belford B000326 | rep | CO | 1877-10-15 | 1879-03-03 | Republican | 1 | |||||||||||||
9742 | 9742 | Hiram Bell B000336 | rep | GA | 1877-10-15 | 1879-03-03 | Democrat | 9 | |||||||||||||
9743 | 9743 | Charles Benedict B000357 | rep | NY | 1877-10-15 | 1879-03-03 | Democrat | 31 | |||||||||||||
10011 | 10011 | George Bicknell B000438 | rep | IN | 1877-10-15 | 1879-03-03 | Democrat | 3 | |||||||||||||
10638 | 10638 | Horatio Bisbee B000485 | rep | FL | 1877-10-15 | 1879-03-03 | Republican | 2 | |||||||||||||
13864 | 13864 | Joseph Blackburn B000508 | rep | KY | 1877-10-15 | 1879-03-03 | Democrat | 7 | |||||||||||||
12414 | 12414 | Henry Blair B000524 | rep | NH | 1877-10-15 | 1879-03-03 | Republican | 3 | |||||||||||||
13578 | 13578 | Richard Bland B000544 | rep | MO | 1877-10-15 | 1879-03-03 | Democrat | 5 | |||||||||||||
11294 | 11294 | Archibald Bliss B000558 | rep | NY | 1877-10-15 | 1879-03-03 | Democrat | 4 | |||||||||||||
12089 | 12089 | James Blount B000568 | rep | GA | 1877-10-15 | 1879-03-03 | Democrat | 6 | |||||||||||||
9745 | 9745 | Andrew Boone B000629 | rep | KY | 1877-10-15 | 1879-03-03 | Democrat | 1 | |||||||||||||
10014 | 10014 | Gabriel Bouck B000658 | rep | WI | 1877-10-15 | 1879-03-03 | Democrat | 6 | |||||||||||||
10016 | 10016 | Thomas Boyd B000721 | rep | IL | 1877-10-15 | 1879-03-03 | Republican | 9 | |||||||||||||
10974 | 10974 | Edward Bragg B000757 | rep | WI | 1877-10-15 | 1879-03-03 | Democrat | 5 | |||||||||||||
9746 | 9746 | Lorenzo Brentano B000804 | rep | IL | 1877-10-15 | 1879-03-03 | Republican | 3 | |||||||||||||
11614 | 11614 | Mark Brewer B000811 | rep | MI | 1877-10-15 | 1879-03-03 | Republican | 6 | |||||||||||||
9749 | 9749 | Samuel Bridges B000824 | rep | PA | 1877-10-15 | 1879-03-03 | Democrat | 10 | |||||||||||||
10272 | 10272 | James Briggs B000831 | rep | NH | 1877-10-15 | 1879-03-03 | Republican | 2 | |||||||||||||
10022 | 10022 | John Bright B000836 | rep | TN | 1877-10-15 | 1879-03-03 | Democrat | 5 | |||||||||||||
9750 | 9750 | Curtis Brogden B000863 | rep | NC | 1877-10-15 | 1879-03-03 | Republican | 2 | |||||||||||||
11622 | 11622 | Thomas Browne B000958 | rep | IN | 1877-10-15 | 1879-03-03 | Republican | 5 | |||||||||||||
10657 | 10657 | Aylett Buckner B001031 | rep | MO | 1877-10-15 | 1879-03-03 | Democrat | 13 | |||||||||||||
9751 | 9751 | Solomon Bundy B001060 | rep | NY | 1877-10-15 | 1879-03-03 | Republican | 21 | |||||||||||||
9756 | 9756 | Horatio Burchard B001070 | rep | IL | 1877-10-15 | 1879-03-03 | Republican | 5 | |||||||||||||
9757 | 9757 | Theodore Burdick B001078 | rep | IA | 1877-10-15 | 1879-03-03 | Republican | 3 | |||||||||||||
9762 | 9762 | Benjamin Butler B001174 | rep | MA | 1877-10-15 | 1879-03-03 | Republican | 7 | |||||||||||||
10987 | 10987 | George Cabell C000004 | rep | VA | 1877-10-15 | 1879-03-03 | Democrat | 5 | |||||||||||||
9764 | 9764 | Richard Cain C000022 | rep | SC | 1877-10-15 | 1879-03-03 | Republican | 2 | |||||||||||||
10276 | 10276 | John Caldwell C000036 | rep | KY | 1877-10-15 | 1879-03-03 | Democrat | 3 | |||||||||||||
9766 | 9766 | William Caldwell C000041 | rep | TN | 1877-10-15 | 1879-03-03 | Democrat | 9 | |||||||||||||
10662 | 10662 | William Calkins C000048 | rep | IN | 1877-10-15 | 1879-03-03 | Republican | 10 | |||||||||||||
12126 | 12126 | James Cameron C000065 | sen | PA | 1877-10-15 | 1879-03-03 | 3 | Republican | |||||||||||||
10281 | 10281 | John Camp C000072 | rep | NY | 1877-10-15 | 1879-03-03 | Republican | 26 | |||||||||||||
10994 | 10994 | Jacob Campbell C000086 | rep | PA | 1877-10-15 | 1879-03-03 | Republican | 17 | |||||||||||||
9768 | 9768 | Milton Candler C000112 | rep | GA | 1877-10-15 | 1879-03-03 | Democrat | 5 | |||||||||||||
10286 | 10286 | George Cannon C000119 | rep | UT | 1877-10-15 | 1879-03-03 | Republican | -1 | |||||||||||||
18095 | 18095 | Joseph Cannon C000121 | rep | IL | 1877-10-15 | 1879-03-03 | Republican | 14 | |||||||||||||
12056 | 12056 | John Carlisle C000152 | rep | KY | 1877-10-15 | 1879-03-03 | Democrat | 6 | |||||||||||||
11658 | 11658 | Lucien Caswell C000245 | rep | WI | 1877-10-15 | 1879-03-03 | Republican | 2 | |||||||||||||
9725 | 9725 | Jerome Chaffee C000271 | sen | CO | 1876-01-01 | 1879-03-03 | 3 | Republican | |||||||||||||
10668 | 10668 | James Chalmers C000272 | rep | MS | 1877-10-15 | 1879-03-03 | Democrat | 6 | |||||||||||||
10033 | 10033 | Simeon Chittenden C000373 | rep | NY | 1877-10-15 | 1879-03-03 | Republican | 3 | |||||||||||||
10035 | 10035 | William Claflin C000398 | rep | MA | 1877-10-15 | 1879-03-03 | Republican | 8 | |||||||||||||
10037 | 10037 | Alvah Clark C000419 | rep | NJ | 1877-10-15 | 1879-03-03 | Democrat | 4 | |||||||||||||
10294 | 10294 | John Clark C000442 | rep | MO | 1877-10-15 | 1879-03-03 | Democrat | 11 | |||||||||||||
10039 | 10039 | Rush Clark C000450 | rep | IA | 1877-10-15 | 1879-03-03 | Republican | 5 | |||||||||||||
9770 | 9770 | John Clarke C000464 | rep | KY | 1877-10-15 | 1879-03-03 | Democrat | 10 | |||||||||||||
10044 | 10044 | Hiester Clymer C000539 | rep | PA | 1877-10-15 | 1879-03-03 | Democrat | 8 | |||||||||||||
11003 | 11003 | Thomas Cobb C000552 | rep | IN | 1877-10-15 | 1879-03-03 | Democrat | 2 | |||||||||||||
9771 | 9771 | Nathan Cole C000610 | rep | MO | 1877-10-15 | 1879-03-03 | Republican | 2 | |||||||||||||
9773 | 9773 | Francis Collins C000636 | rep | PA | 1877-10-15 | 1879-03-03 | Democrat | 11 | |||||||||||||
10303 | 10303 | Omar Conger C000678 | rep | MI | 1877-10-15 | 1879-03-03 | Republican | 7 | |||||||||||||
10053 | 10053 | Roscoe Conkling C000681 | sen | NY | 1873-12-01 | 1879-03-03 | 3 | Republican | |||||||||||||
9133 | 9133 | Simon Conover C000701 | sen | FL | 1873-12-01 | 1879-03-03 | 3 | Republican | |||||||||||||
10308 | 10308 | Philip Cook C000724 | rep | GA | 1877-10-15 | 1879-03-03 | Democrat | 3 | |||||||||||||
9774 | 9774 | William Corlett C000777 | rep | WY | 1877-10-15 | 1879-03-03 | Republican | 0 | |||||||||||||
12505 | 12505 | James Covert C000814 | rep | NY | 1877-10-15 | 1879-03-03 | Democrat | 1 | |||||||||||||
9775 | 9775 | Jacob Cox C000833 | rep | OH | 1877-10-15 | 1879-03-03 | Republican | 6 | |||||||||||||
11699 | 11699 | Samuel Cox C000839 | rep | NY | 1877-10-15 | 1879-03-03 | Democrat | 6 | |||||||||||||
10314 | 10314 | William Crapo C000881 | rep | MA | 1877-10-15 | 1879-03-03 | Republican | 1 | |||||||||||||
10317 | 10317 | Jordan Cravens C000885 | rep | AR | 1877-10-15 | 1879-03-03 | Ind. Democrat | 3 | |||||||||||||
9777 | 9777 | Thomas Crittenden C000913 | rep | MO | 1877-10-15 | 1879-03-03 | Democrat | 7 | |||||||||||||
12981 | 12981 | David Culberson C000964 | rep | TX | 1877-10-15 | 1879-03-03 | Democrat | 2 | |||||||||||||
9778 | 9778 | Henry Cummings C000986 | rep | IA | 1877-10-15 | 1879-03-03 | Republican | 7 | |||||||||||||
9780 | 9780 | Augustus Cutler C001025 | rep | NJ | 1877-10-15 | 1879-03-03 | Democrat | 5 | |||||||||||||
13630 | 13630 | Lorenzo Danford D000028 | rep | OH | 1877-10-15 | 1879-03-03 | Republican | 16 | |||||||||||||
10326 | 10326 | Chester Darrall D000062 | rep | LA | 1877-10-15 | 1879-03-03 | Republican | 3 | |||||||||||||
11718 | 11718 | Robert Davidson D000085 | rep | FL | 1877-10-15 | 1879-03-03 | Democrat | 1 | |||||||||||||
10057 | 10057 | Horace Davis D000105 | rep | CA | 1877-10-15 | 1879-03-03 | Republican | 1 | |||||||||||||
10060 | 10060 | Joseph Davis D000123 | rep | NC | 1877-10-15 | 1879-03-03 | Democrat | 4 | |||||||||||||
9784 | 9784 | Benjamin Dean D000170 | rep | MA | 1877-10-15 | 1879-03-03 | Democrat | 3 | |||||||||||||
10330 | 10330 | Nathaniel Deering D000188 | rep | IA | 1877-10-15 | 1879-03-03 | Republican | 4 | |||||||||||||
9786 | 9786 | Dudley Denison D000236 | rep | VT | 1877-10-15 | 1879-03-03 | Republican | 2 | |||||||||||||
9151 | 9151 | George Dennis D000242 | sen | MD | 1873-12-01 | 1879-03-03 | 3 | Democrat | |||||||||||||
10698 | 10698 | George Dibrell D000301 | rep | TN | 1877-10-15 | 1879-03-03 | Democrat | 3 | |||||||||||||
10064 | 10064 | Henry Dickey D000311 | rep | OH | 1877-10-15 | 1879-03-03 | Democrat | 7 | |||||||||||||
9154 | 9154 | Stephen Dorsey D000441 | sen | AR | 1873-12-01 | 1879-03-03 | 3 | Republican | |||||||||||||
9788 | 9788 | Beverly Douglas D000450 | rep | VA | 1877-10-15 | 1879-03-03 | Democrat | 1 | |||||||||||||
11743 | 11743 | Mark Dunnell D000555 | rep | MN | 1877-10-15 | 1879-03-03 | Republican | 1 | |||||||||||||
9791 | 9791 | Milton Durham D000572 | rep | KY | 1877-10-15 | 1879-03-03 | Democrat | 8 | |||||||||||||
10336 | 10336 | Jeremiah Dwight D000580 | rep | NY | 1877-10-15 | 1879-03-03 | Republican | 28 | |||||||||||||
9795 | 9795 | Benjamin Eames E000005 | rep | RI | 1877-10-15 | 1879-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);