legislator_terms
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
347 rows where "end" is on date 1877-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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
9440 | 9440 | Josiah Abbott A000007 | rep | MA | 1875-12-06 | 1877-03-03 | Democrat | 4 | |||||||||||||
9441 | 9441 | Charles Adams A000033 | rep | NY | 1875-12-06 | 1877-03-03 | Republican | 16 | |||||||||||||
9442 | 9442 | Lucien Ainsworth A000067 | rep | IA | 1875-12-06 | 1877-03-03 | Democrat | 3 | |||||||||||||
8799 | 8799 | James Alcorn A000079 | sen | MS | 1871-03-04 | 1877-03-03 | 2 | Republican | |||||||||||||
9443 | 9443 | William Anderson A000236 | rep | IL | 1875-12-06 | 1877-03-03 | Independent | 19 | |||||||||||||
10626 | 10626 | Henry Anthony A000262 | sen | RI | 1871-03-04 | 1877-03-03 | 2 | Republican | |||||||||||||
9445 | 9445 | Thomas Ashe A000309 | rep | NC | 1875-12-06 | 1877-03-03 | Democrat | 6 | |||||||||||||
10260 | 10260 | John Atkins A000327 | rep | TN | 1875-12-06 | 1877-03-03 | Democrat | 8 | |||||||||||||
9446 | 9446 | John Bagby B000031 | rep | IL | 1875-12-06 | 1877-03-03 | Democrat | 10 | |||||||||||||
9731 | 9731 | George Bagley B000032 | rep | NY | 1875-12-06 | 1877-03-03 | Republican | 22 | |||||||||||||
10629 | 10629 | John Bagley B000033 | rep | NY | 1875-12-06 | 1877-03-03 | Democrat | 15 | |||||||||||||
9997 | 9997 | John Baker B000068 | rep | IN | 1875-12-06 | 1877-03-03 | Republican | 13 | |||||||||||||
9734 | 9734 | William Baker B000077 | rep | NY | 1875-12-06 | 1877-03-03 | Republican | 24 | |||||||||||||
10001 | 10001 | Latimer Ballou B000106 | rep | RI | 1875-12-06 | 1877-03-03 | Republican | 2 | |||||||||||||
11582 | 11582 | Nathaniel Banks B000116 | rep | MA | 1875-12-06 | 1877-03-03 | Independent | 5 | |||||||||||||
9737 | 9737 | Henry Banning B000117 | rep | OH | 1875-12-06 | 1877-03-03 | Democrat | 2 | |||||||||||||
9448 | 9448 | Lyman Bass B000221 | rep | NY | 1875-12-06 | 1877-03-03 | Republican | 32 | |||||||||||||
9739 | 9739 | George Beebe B000305 | rep | NY | 1875-12-06 | 1877-03-03 | Democrat | 14 | |||||||||||||
10633 | 10633 | James Belford B000326 | rep | CO | 1875-12-06 | 1877-03-03 | Republican | 1 | |||||||||||||
9450 | 9450 | Samuel Bell B000346 | rep | NH | 1875-12-06 | 1877-03-03 | Democrat | 2 | |||||||||||||
9451 | 9451 | Thomas Bennett B000383 | rep | ID | 1875-12-06 | 1877-03-03 | Independent | -1 | |||||||||||||
13863 | 13863 | Joseph Blackburn B000508 | rep | KY | 1875-12-06 | 1877-03-03 | Democrat | 7 | |||||||||||||
9721 | 9721 | James Blaine B000519 | sen | ME | 1876-07-10 | 1877-03-03 | 2 | Republican | |||||||||||||
12413 | 12413 | Henry Blair B000524 | rep | NH | 1875-12-06 | 1877-03-03 | Republican | 3 | |||||||||||||
13577 | 13577 | Richard Bland B000544 | rep | MO | 1875-12-06 | 1877-03-03 | Democrat | 5 | |||||||||||||
11293 | 11293 | Archibald Bliss B000558 | rep | NY | 1875-12-06 | 1877-03-03 | Democrat | 4 | |||||||||||||
12088 | 12088 | James Blount B000568 | rep | GA | 1875-12-06 | 1877-03-03 | Democrat | 6 | |||||||||||||
9744 | 9744 | Andrew Boone B000629 | rep | KY | 1875-12-06 | 1877-03-03 | Democrat | 1 | |||||||||||||
9097 | 9097 | George Boutwell B000674 | sen | MA | 1873-12-01 | 1877-03-03 | 2 | Republican | |||||||||||||
9453 | 9453 | Taul Bradford B000738 | rep | AL | 1875-12-06 | 1877-03-03 | Democrat | 3 | |||||||||||||
9455 | 9455 | Nathan Bradley B000744 | rep | MI | 1875-12-06 | 1877-03-03 | Republican | 8 | |||||||||||||
10021 | 10021 | John Bright B000836 | rep | TN | 1875-12-06 | 1877-03-03 | Democrat | 5 | |||||||||||||
9459 | 9459 | John Brown B000933 | rep | KY | 1875-12-06 | 1877-03-03 | Democrat | 2 | |||||||||||||
9460 | 9460 | William Brown B000951 | rep | KS | 1875-12-06 | 1877-03-03 | Republican | 3 | |||||||||||||
10656 | 10656 | Aylett Buckner B001031 | rep | MO | 1875-12-06 | 1877-03-03 | Democrat | 13 | |||||||||||||
9469 | 9469 | James Buffinton B001040 | rep | MA | 1875-12-06 | 1877-03-03 | Republican | 1 | |||||||||||||
9755 | 9755 | Horatio Burchard B001070 | rep | IL | 1875-12-06 | 1877-03-03 | Republican | 5 | |||||||||||||
9470 | 9470 | Samuel Burchard B001071 | rep | WI | 1875-12-06 | 1877-03-03 | Democrat | 5 | |||||||||||||
9472 | 9472 | John Burleigh B001107 | rep | ME | 1875-12-06 | 1877-03-03 | Republican | 1 | |||||||||||||
9474 | 9474 | Charles Buttz B001202 | rep | SC | 1875-12-06 | 1877-03-03 | Republican | 2 | |||||||||||||
10986 | 10986 | George Cabell C000004 | rep | VA | 1875-12-06 | 1877-03-03 | Democrat | 5 | |||||||||||||
9476 | 9476 | John Caldwell C000035 | rep | AL | 1875-12-06 | 1877-03-03 | Democrat | 5 | |||||||||||||
9765 | 9765 | William Caldwell C000041 | rep | TN | 1875-12-06 | 1877-03-03 | Democrat | 9 | |||||||||||||
9477 | 9477 | Alexander Campbell C000075 | rep | IL | 1875-12-06 | 1877-03-03 | Independent | 7 | |||||||||||||
9767 | 9767 | Milton Candler C000112 | rep | GA | 1875-12-06 | 1877-03-03 | Democrat | 5 | |||||||||||||
10285 | 10285 | George Cannon C000119 | rep | UT | 1875-12-06 | 1877-03-03 | Republican | -1 | |||||||||||||
18094 | 18094 | Joseph Cannon C000121 | rep | IL | 1875-12-06 | 1877-03-03 | Republican | 14 | |||||||||||||
9478 | 9478 | Allen Caperton C000130 | sen | WV | 1875-12-06 | 1877-03-03 | 1 | Democrat | |||||||||||||
9479 | 9479 | Nathan Carr C000179 | rep | IN | 1875-12-06 | 1877-03-03 | Democrat | 3 | |||||||||||||
9481 | 9481 | Thomas Cason C000232 | rep | IN | 1875-12-06 | 1877-03-03 | Republican | 9 | |||||||||||||
11657 | 11657 | Lucien Caswell C000245 | rep | WI | 1875-12-06 | 1877-03-03 | Republican | 2 | |||||||||||||
9482 | 9482 | George Cate C000248 | rep | WI | 1875-12-06 | 1877-03-03 | Democrat | 8 | |||||||||||||
9484 | 9484 | Bernard Caulfield C000255 | rep | IL | 1875-12-06 | 1877-03-03 | Democrat | 1 | |||||||||||||
9485 | 9485 | Chester Chapin C000305 | rep | MA | 1875-12-06 | 1877-03-03 | Democrat | 11 | |||||||||||||
10032 | 10032 | Simeon Chittenden C000373 | rep | NY | 1875-12-06 | 1877-03-03 | Ind. Republican | 3 | |||||||||||||
10293 | 10293 | John Clark C000442 | rep | MO | 1875-12-06 | 1877-03-03 | Democrat | 11 | |||||||||||||
9769 | 9769 | John Clarke C000464 | rep | KY | 1875-12-06 | 1877-03-03 | Democrat | 10 | |||||||||||||
8858 | 8858 | Powell Clayton C000498 | sen | AR | 1871-03-04 | 1877-03-03 | 2 | Republican | |||||||||||||
10043 | 10043 | Hiester Clymer C000539 | rep | PA | 1875-12-06 | 1877-03-03 | Democrat | 8 | |||||||||||||
9487 | 9487 | Alexander Cochran C000561 | rep | PA | 1875-12-06 | 1877-03-03 | Democrat | 23 | |||||||||||||
9772 | 9772 | Francis Collins C000636 | rep | PA | 1875-12-06 | 1877-03-03 | Democrat | 11 | |||||||||||||
10302 | 10302 | Omar Conger C000678 | rep | MI | 1875-12-06 | 1877-03-03 | Republican | 7 | |||||||||||||
10307 | 10307 | Philip Cook C000724 | rep | GA | 1875-12-06 | 1877-03-03 | Democrat | 3 | |||||||||||||
8866 | 8866 | Henry Cooper C000751 | sen | TN | 1871-03-04 | 1877-03-03 | 2 | Democrat | |||||||||||||
9488 | 9488 | Jacob Cowan C000820 | rep | OH | 1875-12-06 | 1877-03-03 | Democrat | 14 | |||||||||||||
11698 | 11698 | Samuel Cox C000839 | rep | NY | 1875-12-06 | 1877-03-03 | Democrat | 6 | |||||||||||||
8870 | 8870 | Aaron Cragin C000852 | sen | NH | 1871-03-04 | 1877-03-03 | 2 | Republican | |||||||||||||
10313 | 10313 | William Crapo C000881 | rep | MA | 1875-12-06 | 1877-03-03 | Republican | 1 | |||||||||||||
9490 | 9490 | Lorenzo Crounse C000935 | rep | NE | 1875-12-06 | 1877-03-03 | Republican | 1 | |||||||||||||
12980 | 12980 | David Culberson C000964 | rep | TX | 1875-12-06 | 1877-03-03 | Democrat | 2 | |||||||||||||
9779 | 9779 | Augustus Cutler C001025 | rep | NJ | 1875-12-06 | 1877-03-03 | Democrat | 5 | |||||||||||||
13629 | 13629 | Lorenzo Danford D000028 | rep | OH | 1875-12-06 | 1877-03-03 | Republican | 16 | |||||||||||||
10325 | 10325 | Chester Darrall D000062 | rep | LA | 1875-12-06 | 1877-03-03 | Republican | 3 | |||||||||||||
9782 | 9782 | Henry Davis D000103 | sen | WV | 1871-03-04 | 1877-03-03 | 2 | Democrat | |||||||||||||
10059 | 10059 | Joseph Davis D000123 | rep | NC | 1875-12-06 | 1877-03-03 | Democrat | 4 | |||||||||||||
9491 | 9491 | John Davy D000145 | rep | NY | 1875-12-06 | 1877-03-03 | Republican | 30 | |||||||||||||
9492 | 9492 | Rezin De Bolt D000180 | rep | MO | 1875-12-06 | 1877-03-03 | Democrat | 10 | |||||||||||||
9785 | 9785 | Dudley Denison D000236 | rep | VT | 1875-12-06 | 1877-03-03 | Ind. Republican | 2 | |||||||||||||
10697 | 10697 | George Dibrell D000301 | rep | TN | 1875-12-06 | 1877-03-03 | Democrat | 3 | |||||||||||||
9494 | 9494 | Samuel Dobbins D000383 | rep | NJ | 1875-12-06 | 1877-03-03 | Republican | 2 | |||||||||||||
9787 | 9787 | Beverly Douglas D000450 | rep | VA | 1875-12-06 | 1877-03-03 | Democrat | 1 | |||||||||||||
11742 | 11742 | Mark Dunnell D000555 | rep | MN | 1875-12-06 | 1877-03-03 | Republican | 1 | |||||||||||||
9495 | 9495 | George Durand D000562 | rep | MI | 1875-12-06 | 1877-03-03 | Democrat | 6 | |||||||||||||
9790 | 9790 | Milton Durham D000572 | rep | KY | 1875-12-06 | 1877-03-03 | Democrat | 8 | |||||||||||||
9794 | 9794 | Benjamin Eames E000005 | rep | RI | 1875-12-06 | 1877-03-03 | Republican | 1 | |||||||||||||
11021 | 11021 | John Eden E000042 | rep | IL | 1875-12-06 | 1877-03-03 | Democrat | 15 | |||||||||||||
9496 | 9496 | Albert Egbert E000087 | rep | PA | 1875-12-06 | 1877-03-03 | Democrat | 27 | |||||||||||||
15094 | 15094 | Stephen Elkins E000110 | rep | NM | 1875-12-06 | 1877-03-03 | Republican | -1 | |||||||||||||
10709 | 10709 | Ezekiel Ellis E000134 | rep | LA | 1875-12-06 | 1877-03-03 | Democrat | 2 | |||||||||||||
9498 | 9498 | Smith Ely E000167 | rep | NY | 1875-12-06 | 1877-03-03 | Democrat | 7 | |||||||||||||
9501 | 9501 | James English E000185 | sen | CT | 1875-12-06 | 1877-03-03 | 3 | Democrat | |||||||||||||
9798 | 9798 | James Evans E000245 | rep | IN | 1875-12-06 | 1877-03-03 | Republican | 11 | |||||||||||||
11365 | 11365 | Charles Farwell F000037 | rep | IL | 1875-12-06 | 1877-03-03 | Republican | 3 | |||||||||||||
9506 | 9506 | Charles Faulkner F000044 | rep | VA | 1875-12-06 | 1877-03-03 | Democrat | -1 | |||||||||||||
10074 | 10074 | William Felton F000070 | rep | GA | 1875-12-06 | 1877-03-03 | Ind. Democrat | 7 | |||||||||||||
9800 | 9800 | Stephen Fenn F000073 | rep | ID | 1875-12-06 | 1877-03-03 | Democrat | -1 | |||||||||||||
9805 | 9805 | Thomas Ferry F000095 | sen | MI | 1871-03-04 | 1877-03-03 | 2 | Republican | |||||||||||||
9507 | 9507 | David Field F000104 | rep | NY | 1875-12-06 | 1877-03-03 | Democrat | 7 | |||||||||||||
10345 | 10345 | Jesse Finley F000134 | rep | FL | 1875-12-06 | 1877-03-03 | Democrat | 2 | |||||||||||||
9508 | 9508 | Samuel Fite F000160 | rep | TN | 1875-12-06 | 1877-03-03 | Democrat | 4 |
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);