legislator_terms
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
27 rows where class = 2 and "end" is on date 1877-03-03
This data as json, copyable, CSV (advanced)
Suggested facets: state, start, 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
8793 | 8793 | Morgan Hamilton H000115 | sen | TX | 1871-03-04 | 1877-03-03 | 2 | Republican | |||||||||||||
8799 | 8799 | James Alcorn A000079 | sen | MS | 1871-03-04 | 1877-03-03 | 2 | Republican | |||||||||||||
8858 | 8858 | Powell Clayton C000498 | sen | AR | 1871-03-04 | 1877-03-03 | 2 | Republican | |||||||||||||
8866 | 8866 | Henry Cooper C000751 | sen | TN | 1871-03-04 | 1877-03-03 | 2 | Democrat | |||||||||||||
8870 | 8870 | Aaron Cragin C000852 | sen | NH | 1871-03-04 | 1877-03-03 | 2 | Republican | |||||||||||||
8901 | 8901 | Frederick Frelinghuysen F000369 | sen | NJ | 1871-03-04 | 1877-03-03 | 2 | Republican | |||||||||||||
8911 | 8911 | George Goldthwaite G000266 | sen | AL | 1871-03-04 | 1877-03-03 | 2 | Democrat | |||||||||||||
8933 | 8933 | Phineas Hitchcock H000648 | sen | NE | 1871-03-04 | 1877-03-03 | 2 | Republican | |||||||||||||
8940 | 8940 | James Kelly K000074 | sen | OR | 1871-03-04 | 1877-03-03 | 2 | Democrat | |||||||||||||
8981 | 8981 | Lot Morrill M000970 | sen | ME | 1871-03-04 | 1877-03-03 | 2 | Republican | |||||||||||||
9003 | 9003 | Thomas Robertson R000327 | sen | SC | 1871-03-04 | 1877-03-03 | 2 | Republican | |||||||||||||
9029 | 9029 | John Stevenson S000894 | sen | KY | 1871-03-04 | 1877-03-03 | 2 | Democrat | |||||||||||||
9054 | 9054 | Joseph West W000303 | sen | LA | 1871-03-04 | 1877-03-03 | 2 | Republican | |||||||||||||
9065 | 9065 | George Wright W000759 | sen | IA | 1871-03-04 | 1877-03-03 | 2 | Republican | |||||||||||||
9097 | 9097 | George Boutwell B000674 | sen | MA | 1873-12-01 | 1877-03-03 | 2 | Republican | |||||||||||||
9432 | 9432 | James Harvey H000307 | sen | KS | 1874-01-01 | 1877-03-03 | 2 | Republican | |||||||||||||
9721 | 9721 | James Blaine B000519 | sen | ME | 1876-07-10 | 1877-03-03 | 2 | Republican | |||||||||||||
9782 | 9782 | Henry Davis D000103 | sen | WV | 1871-03-04 | 1877-03-03 | 2 | Democrat | |||||||||||||
9805 | 9805 | Thomas Ferry F000095 | sen | MI | 1871-03-04 | 1877-03-03 | 2 | Republican | |||||||||||||
9861 | 9861 | John Johnston J000191 | sen | VA | 1871-03-15 | 1877-03-03 | 2 | Democrat | |||||||||||||
10245 | 10245 | William Windom W000629 | sen | MN | 1871-03-04 | 1877-03-03 | 2 | Republican | |||||||||||||
10626 | 10626 | Henry Anthony A000262 | sen | RI | 1871-03-04 | 1877-03-03 | 2 | Republican | |||||||||||||
10874 | 10874 | Eli Saulsbury S000072 | sen | DE | 1871-03-04 | 1877-03-03 | 2 | Democrat | |||||||||||||
11114 | 11114 | John Logan L000403 | sen | IL | 1871-03-04 | 1877-03-03 | 2 | Republican | |||||||||||||
11461 | 11461 | Thomas Norwood N000160 | sen | GA | 1871-03-04 | 1877-03-03 | 2 | Democrat | |||||||||||||
11926 | 11926 | Matt Ransom R000062 | sen | NC | 1872-01-01 | 1877-03-03 | 2 | Democrat | |||||||||||||
14492 | 14492 | Henry Teller T000116 | sen | CO | 1876-11-15 | 1877-03-03 | 2 | Republican |
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);