legislator_terms
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
339 rows where "start" is on date 1879-03-18 sorted by legislator_id
This data as json, copyable, CSV (advanced)
Suggested facets: state, end, party, end (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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
9993 | 9993 | Joseph Acklen A000023 | rep | LA | 1879-03-18 | 1881-03-03 | Democrat | 3 | |||||||||||||
10954 | 10954 | David Aiken A000061 | rep | SC | 1879-03-18 | 1881-03-03 | Democrat | 3 | |||||||||||||
10248 | 10248 | George Ainslie A000066 | rep | ID | 1879-03-18 | 1881-03-03 | Democrat | -1 | |||||||||||||
14555 | 14555 | Nelson Aldrich A000083 | rep | RI | 1879-03-18 | 1881-03-03 | Republican | 1 | |||||||||||||
10251 | 10251 | William Aldrich A000086 | rep | IL | 1879-03-18 | 1881-03-03 | Republican | 1 | |||||||||||||
14232 | 14232 | William Allison A000160 | sen | IA | 1879-03-18 | 1885-03-03 | 3 | Republican | |||||||||||||
11565 | 11565 | John Anderson A000194 | rep | KS | 1879-03-18 | 1881-03-03 | Republican | 1 | |||||||||||||
10254 | 10254 | Robert Armfield A000278 | rep | NC | 1879-03-18 | 1881-03-03 | Democrat | 7 | |||||||||||||
10256 | 10256 | Gibson Atherton A000325 | rep | OH | 1879-03-18 | 1881-03-03 | Democrat | 14 | |||||||||||||
10262 | 10262 | John Atkins A000327 | rep | TN | 1879-03-18 | 1881-03-03 | Democrat | 8 | |||||||||||||
9994 | 9994 | Reuben Bachman B000011 | rep | PA | 1879-03-18 | 1881-03-03 | Democrat | 10 | |||||||||||||
9996 | 9996 | John Bailey B000042 | rep | NY | 1879-03-18 | 1881-03-03 | Republican | 16 | |||||||||||||
9999 | 9999 | John Baker B000068 | rep | IN | 1879-03-18 | 1881-03-03 | Republican | 13 | |||||||||||||
10000 | 10000 | Henry Baldwin B000089 | sen | MI | 1879-03-18 | 1881-03-03 | 1 | Republican | |||||||||||||
10003 | 10003 | Latimer Ballou B000106 | rep | RI | 1879-03-18 | 1881-03-03 | Republican | 2 | |||||||||||||
10004 | 10004 | Hiram Barber B000120 | rep | IL | 1879-03-18 | 1881-03-03 | Republican | 3 | |||||||||||||
10005 | 10005 | Bradley Barlow B000148 | rep | VT | 1879-03-18 | 1881-03-03 | National Greenbacker | 3 | |||||||||||||
11593 | 11593 | Thomas Bayne B000261 | rep | PA | 1879-03-18 | 1881-03-03 | Republican | 23 | |||||||||||||
10008 | 10008 | Richard Beale B000268 | rep | VA | 1879-03-18 | 1881-03-03 | Democrat | 1 | |||||||||||||
10635 | 10635 | James Belford B000326 | rep | CO | 1879-03-18 | 1881-03-03 | Republican | 1 | |||||||||||||
10009 | 10009 | Charles Bell B000331 | sen | NH | 1879-03-18 | 1879-12-31 | 3 | Republican | |||||||||||||
12408 | 12408 | Frank Beltzhoover B000355 | rep | PA | 1879-03-18 | 1881-03-03 | Democrat | 19 | |||||||||||||
10010 | 10010 | Granville Bennett B000374 | rep | DK | 1879-03-18 | 1881-03-03 | Republican | -1 | |||||||||||||
10267 | 10267 | Campbell Berry B000415 | rep | CA | 1879-03-18 | 1881-03-03 | Democrat | 3 | |||||||||||||
10012 | 10012 | George Bicknell B000438 | rep | IN | 1879-03-18 | 1881-03-03 | Democrat | 3 | |||||||||||||
15854 | 15854 | Henry Bingham B000469 | rep | PA | 1879-03-18 | 1881-03-03 | Republican | 1 | |||||||||||||
10639 | 10639 | Horatio Bisbee B000485 | rep | FL | 1879-03-18 | 1881-03-03 | Republican | 2 | |||||||||||||
13865 | 13865 | Joseph Blackburn B000508 | rep | KY | 1879-03-18 | 1881-03-03 | Democrat | 7 | |||||||||||||
12415 | 12415 | Henry Blair B000524 | sen | NH | 1879-03-18 | 1885-03-03 | 3 | Republican | |||||||||||||
10013 | 10013 | John Blake B000532 | rep | NJ | 1879-03-18 | 1881-03-03 | Republican | 6 | |||||||||||||
13579 | 13579 | Richard Bland B000544 | rep | MO | 1879-03-18 | 1881-03-03 | Democrat | 5 | |||||||||||||
11295 | 11295 | Archibald Bliss B000558 | rep | NY | 1879-03-18 | 1881-03-03 | Democrat | 4 | |||||||||||||
12090 | 12090 | James Blount B000568 | rep | GA | 1879-03-18 | 1881-03-03 | Democrat | 6 | |||||||||||||
10015 | 10015 | Gabriel Bouck B000658 | rep | WI | 1879-03-18 | 1881-03-03 | Democrat | 6 | |||||||||||||
10270 | 10270 | Selwyn Bowman B000705 | rep | MA | 1879-03-18 | 1881-03-03 | Republican | 5 | |||||||||||||
10017 | 10017 | Thomas Boyd B000721 | rep | IL | 1879-03-18 | 1881-03-03 | Republican | 9 | |||||||||||||
10975 | 10975 | Edward Bragg B000757 | rep | WI | 1879-03-18 | 1881-03-03 | Democrat | 5 | |||||||||||||
10646 | 10646 | Thomas Brents B000806 | rep | WA | 1879-03-18 | 1881-03-03 | Republican | -1 | |||||||||||||
11615 | 11615 | Mark Brewer B000811 | rep | MI | 1879-03-18 | 1881-03-03 | Republican | 6 | |||||||||||||
10273 | 10273 | James Briggs B000831 | rep | NH | 1879-03-18 | 1881-03-03 | Republican | 2 | |||||||||||||
10018 | 10018 | Lewis Brigham B000834 | rep | NJ | 1879-03-18 | 1881-03-03 | Republican | 7 | |||||||||||||
10023 | 10023 | John Bright B000836 | rep | TN | 1879-03-18 | 1881-03-03 | Democrat | 5 | |||||||||||||
11623 | 11623 | Thomas Browne B000958 | rep | IN | 1879-03-18 | 1881-03-03 | Republican | 5 | |||||||||||||
10658 | 10658 | Aylett Buckner B001031 | rep | MO | 1879-03-18 | 1881-03-03 | Democrat | 13 | |||||||||||||
14604 | 14604 | Julius Burrows B001142 | rep | MI | 1879-03-18 | 1881-03-03 | Republican | 4 | |||||||||||||
11639 | 11639 | Benjamin Butterworth B001200 | rep | OH | 1879-03-18 | 1881-03-03 | Republican | 1 | |||||||||||||
10988 | 10988 | George Cabell C000004 | rep | VA | 1879-03-18 | 1881-03-03 | Democrat | 5 | |||||||||||||
10277 | 10277 | John Caldwell C000036 | rep | KY | 1879-03-18 | 1881-03-03 | Democrat | 3 | |||||||||||||
10663 | 10663 | William Calkins C000048 | rep | IN | 1879-03-18 | 1881-03-03 | Republican | 10 | |||||||||||||
12123 | 12123 | Wilkinson Call C000051 | sen | FL | 1879-03-18 | 1885-03-03 | 3 | Democrat | |||||||||||||
12127 | 12127 | James Cameron C000065 | sen | PA | 1879-03-18 | 1885-03-03 | 3 | Republican | |||||||||||||
10282 | 10282 | John Camp C000072 | rep | NY | 1879-03-18 | 1881-03-03 | Republican | 26 | |||||||||||||
10024 | 10024 | John Campbell C000092 | rep | AZ | 1879-03-18 | 1881-03-03 | Democrat | 0 | |||||||||||||
10287 | 10287 | George Cannon C000119 | rep | UT | 1879-03-18 | 1881-03-03 | Republican | -1 | |||||||||||||
18096 | 18096 | Joseph Cannon C000121 | rep | IL | 1879-03-18 | 1881-03-03 | Republican | 14 | |||||||||||||
12057 | 12057 | John Carlisle C000152 | rep | KY | 1879-03-18 | 1881-03-03 | Democrat | 6 | |||||||||||||
10289 | 10289 | Cyrus Carpenter C000166 | rep | IA | 1879-03-18 | 1881-03-03 | Republican | 9 | |||||||||||||
10026 | 10026 | Matthew Carpenter C000171 | sen | WI | 1879-03-18 | 1881-12-31 | 3 | Republican | |||||||||||||
11659 | 11659 | Lucien Caswell C000245 | rep | WI | 1879-03-18 | 1881-03-03 | Republican | 2 | |||||||||||||
10669 | 10669 | James Chalmers C000272 | rep | MS | 1879-03-18 | 1881-03-03 | Democrat | 6 | |||||||||||||
10030 | 10030 | Zachariah Chandler C000299 | sen | MI | 1879-03-18 | 1879-12-31 | 1 | Republican | |||||||||||||
10034 | 10034 | Simeon Chittenden C000373 | rep | NY | 1879-03-18 | 1881-03-03 | Republican | 3 | |||||||||||||
10036 | 10036 | William Claflin C000398 | rep | MA | 1879-03-18 | 1881-03-03 | Republican | 8 | |||||||||||||
11320 | 11320 | Martin Clardy C000417 | rep | MO | 1879-03-18 | 1881-03-03 | Democrat | 1 | |||||||||||||
10038 | 10038 | Alvah Clark C000419 | rep | NJ | 1879-03-18 | 1881-03-03 | Democrat | 4 | |||||||||||||
10295 | 10295 | John Clark C000442 | rep | MO | 1879-03-18 | 1881-03-03 | Democrat | 11 | |||||||||||||
10040 | 10040 | Rush Clark C000450 | rep | IA | 1879-03-18 | 1881-03-03 | Republican | 5 | |||||||||||||
10041 | 10041 | Newton Clements C000509 | rep | AL | 1879-03-18 | 1881-03-03 | Democrat | 6 | |||||||||||||
10045 | 10045 | Hiester Clymer C000539 | rep | PA | 1879-03-18 | 1881-03-03 | Democrat | 8 | |||||||||||||
11004 | 11004 | Thomas Cobb C000552 | rep | IN | 1879-03-18 | 1881-03-03 | Democrat | 2 | |||||||||||||
10048 | 10048 | Alexander Coffroth C000593 | rep | PA | 1879-03-18 | 1881-03-03 | Democrat | 17 | |||||||||||||
10297 | 10297 | Walpole Colerick C000623 | rep | IN | 1879-03-18 | 1881-03-03 | Democrat | 12 | |||||||||||||
10304 | 10304 | Omar Conger C000678 | rep | MI | 1879-03-18 | 1881-03-03 | Republican | 7 | |||||||||||||
10054 | 10054 | Roscoe Conkling C000681 | sen | NY | 1879-03-18 | 1881-12-31 | 3 | Republican | |||||||||||||
10674 | 10674 | George Converse C000711 | rep | OH | 1879-03-18 | 1881-03-03 | Democrat | 9 | |||||||||||||
10309 | 10309 | Philip Cook C000724 | rep | GA | 1879-03-18 | 1881-03-03 | Democrat | 3 | |||||||||||||
12506 | 12506 | James Covert C000814 | rep | NY | 1879-03-18 | 1881-03-03 | Democrat | 1 | |||||||||||||
10055 | 10055 | Calvin Cowgill C000824 | rep | IN | 1879-03-18 | 1881-03-03 | Republican | 11 | |||||||||||||
11700 | 11700 | Samuel Cox C000839 | rep | NY | 1879-03-18 | 1881-03-03 | Democrat | 6 | |||||||||||||
10315 | 10315 | William Crapo C000881 | rep | MA | 1879-03-18 | 1881-03-03 | Republican | 1 | |||||||||||||
10318 | 10318 | Jordan Cravens C000885 | rep | AR | 1879-03-18 | 1881-03-03 | Democrat | 3 | |||||||||||||
10320 | 10320 | Richard Crowley C000945 | rep | NY | 1879-03-18 | 1881-03-03 | Republican | 31 | |||||||||||||
12982 | 12982 | David Culberson C000964 | rep | TX | 1879-03-18 | 1881-03-03 | Democrat | 2 | |||||||||||||
10056 | 10056 | Rollin Daggett D000003 | rep | NV | 1879-03-18 | 1881-03-03 | Republican | 0 | |||||||||||||
11719 | 11719 | Robert Davidson D000085 | rep | FL | 1879-03-18 | 1881-03-03 | Democrat | 1 | |||||||||||||
10688 | 10688 | George Davis D000100 | rep | IL | 1879-03-18 | 1881-03-03 | Republican | 2 | |||||||||||||
10058 | 10058 | Horace Davis D000105 | rep | CA | 1879-03-18 | 1881-03-03 | Republican | 1 | |||||||||||||
10061 | 10061 | Joseph Davis D000123 | rep | NC | 1879-03-18 | 1881-03-03 | Democrat | 4 | |||||||||||||
10691 | 10691 | Lowndes Davis D000124 | rep | MO | 1879-03-18 | 1881-03-03 | Democrat | 4 | |||||||||||||
10331 | 10331 | Nathaniel Deering D000188 | rep | IA | 1879-03-18 | 1881-03-03 | Republican | 4 | |||||||||||||
10062 | 10062 | Gilbert De La Matyr D000204 | rep | IN | 1879-03-18 | 1881-03-03 | National Greenbacker | 7 | |||||||||||||
10694 | 10694 | Peter Deuster D000274 | rep | WI | 1879-03-18 | 1881-03-03 | Democrat | 4 | |||||||||||||
10699 | 10699 | George Dibrell D000301 | rep | TN | 1879-03-18 | 1881-03-03 | Democrat | 3 | |||||||||||||
10063 | 10063 | Samuel Dick D000305 | rep | PA | 1879-03-18 | 1881-03-03 | Republican | 26 | |||||||||||||
10065 | 10065 | Henry Dickey D000311 | rep | OH | 1879-03-18 | 1881-03-03 | Democrat | 11 | |||||||||||||
10066 | 10066 | Stephen Downey D000470 | rep | WY | 1879-03-18 | 1881-03-03 | Republican | 0 | |||||||||||||
11353 | 11353 | Poindexter Dunn D000552 | rep | AR | 1879-03-18 | 1881-03-03 | Democrat | 1 | |||||||||||||
11744 | 11744 | Mark Dunnell D000555 | rep | MN | 1879-03-18 | 1881-03-03 | Republican | 1 | |||||||||||||
10337 | 10337 | Jeremiah Dwight D000580 | rep | NY | 1879-03-18 | 1881-03-03 | Republican | 28 | |||||||||||||
10067 | 10067 | Edwin Einstein E000097 | rep | NY | 1879-03-18 | 1881-03-03 | Republican | 7 |
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);