legislator_terms
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
33 rows where party = "Independent" and type = "rep"
This data as json, copyable, CSV (advanced)
Suggested facets: legislator_id, start, end, district, url, start (date), end (date)
state 19 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
4941 | 4941 | John Pope P000431 | rep | KY | 1837-09-04 | 1839-03-03 | Independent | 7 | |||||||||||||
6178 | 6178 | George Wright W000760 | rep | CA | 1849-12-03 | 1851-03-03 | Independent | -1 | |||||||||||||
6437 | 6437 | Amos Tuck T000394 | rep | NH | 1847-12-06 | 1849-03-03 | Independent | 1 | |||||||||||||
6643 | 6643 | Caleb Lyon L000540 | rep | NY | 1853-12-05 | 1855-03-03 | Independent | 23 | |||||||||||||
7453 | 7453 | Robert Hunter H000988 | rep | VA | 1841-05-31 | 1843-03-03 | Independent | 9 | |||||||||||||
8261 | 8261 | Coles Bashford B000219 | rep | AZ | 1867-03-04 | 1869-03-03 | Independent | 0 | |||||||||||||
9443 | 9443 | William Anderson A000236 | rep | IL | 1875-12-06 | 1877-03-03 | Independent | 19 | |||||||||||||
9451 | 9451 | Thomas Bennett B000383 | rep | ID | 1875-12-06 | 1877-03-03 | Independent | -1 | |||||||||||||
9477 | 9477 | Alexander Campbell C000075 | rep | IL | 1875-12-06 | 1877-03-03 | Independent | 7 | |||||||||||||
9632 | 9632 | Julius Seelye S000225 | rep | MA | 1875-12-06 | 1877-03-03 | Independent | 10 | |||||||||||||
10541 | 10541 | John Smith S000571 | rep | NY | 1881-12-05 | 1883-03-03 | Independent | 3 | |||||||||||||
10671 | 10671 | James Chalmers C000272 | rep | MS | 1883-12-03 | 1885-03-03 | Independent | 2 | |||||||||||||
10827 | 10827 | Thomas Ochiltree O000021 | rep | TX | 1883-12-03 | 1885-03-03 | Independent | 7 | |||||||||||||
11460 | 11460 | John Nichols N000091 | rep | NC | 1887-12-05 | 1889-03-03 | Independent | 4 | |||||||||||||
11582 | 11582 | Nathaniel Banks B000116 | rep | MA | 1875-12-06 | 1877-03-03 | Independent | 5 | |||||||||||||
15021 | 15021 | Thomas Cale C000042 | rep | AK | 1907-12-02 | 1909-03-03 | Independent | 0 | |||||||||||||
16836 | 16836 | William Kent K000127 | rep | CA | 1913-04-07 | 1915-03-03 | Independent | 1 | |||||||||||||
16837 | 16837 | William Kent K000127 | rep | CA | 1915-12-06 | 1917-03-03 | Independent | 1 | |||||||||||||
25785 | 25785 | Henry Reams R000100 | rep | OH | 1951-01-03 | 1953-01-03 | Independent | 9 | |||||||||||||
25786 | 25786 | Henry Reams R000100 | rep | OH | 1953-01-03 | 1955-01-03 | Independent | 9 | |||||||||||||
35814 | 35814 | Victor Frazer F000351 | rep | VI | 1995-01-04 | 1997-01-03 | Independent | 0 | |||||||||||||
36179 | 36179 | Thomas Foglietta F000235 | rep | PA | 1981-01-05 | 1983-01-03 | Independent | 1 | |||||||||||||
38073 | 38073 | Virgil Goode G000280 | rep | VA | 1999-01-06 | 2001-01-03 | Independent | 5 | [ { "start": "1999-01-06", "end": "2000-01-27", "party": "Democrat" }, { "start": "2000-01-27", "end": "2001-01-03", "party": "Independent" } ] |
||||||||||||
41591 | 41591 | Paul Mitchell M001201 | rep | MI | 2019-01-03 | 2021-01-03 | Independent | 10 | [ { "start": "2019-01-03", "end": "2020-12-13", "party": "Republican" }, { "start": "2020-12-14", "end": "2021-01-03", "party": "Independent" } ] |
https://mitchell.house.gov | 211 Cannon House Office Building Washington DC 20515-2210 | 202-225-2106 | 211 Cannon House Office Building | ||||||||
41790 | 41790 | Bernard Sanders S000033 | rep | VT | 1991-01-03 | 1993-01-03 | Independent | 0 | Democrat | ||||||||||||
41791 | 41791 | Bernard Sanders S000033 | rep | VT | 1993-01-05 | 1995-01-03 | Independent | 0 | Democrat | ||||||||||||
41792 | 41792 | Bernard Sanders S000033 | rep | VT | 1995-01-04 | 1997-01-03 | Independent | 0 | Democrat | ||||||||||||
41793 | 41793 | Bernard Sanders S000033 | rep | VT | 1997-01-07 | 1999-01-03 | Independent | 0 | Democrat | ||||||||||||
41794 | 41794 | Bernard Sanders S000033 | rep | VT | 1999-01-06 | 2001-01-03 | Independent | 0 | Democrat | ||||||||||||
41795 | 41795 | Bernard Sanders S000033 | rep | VT | 2001-01-03 | 2003-01-03 | Independent | 0 | Democrat | ||||||||||||
41796 | 41796 | Bernard Sanders S000033 | rep | VT | 2003-01-07 | 2005-01-03 | Independent | 0 | http://bernie.house.gov | Democrat | |||||||||||
41797 | 41797 | Bernard Sanders S000033 | rep | VT | 2005-01-04 | 2007-01-03 | Independent | 0 | http://bernie.house.gov | Democrat | |||||||||||
43236 | 43236 | Gregorio Sablan S001177 | rep | MP | 2015-01-06 | 2017-01-03 | Independent | 0 | http://sablan.house.gov | Democrat | 423 Cannon HOB; Washington DC 20515-5201 | 202-225-2646 | 202-226-4249 | http://sablan.house.gov/email-me | 423 Cannon House Office Building | http://sablan.house.gov/rss.xml |
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);