legislator_terms
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
44,551 rows
This data as json, copyable, CSV (advanced)
start (date) >30 ✖
- 1929-04-15 499
- 1919-05-19 497
- 1917-04-02 496
- 1923-12-03 495
- 1931-12-07 495
- 1939-01-03 495
- 1921-04-11 492
- 1941-01-03 492
- 1943-01-06 487
- 1925-12-07 485
- 1927-12-05 485
- 1933-03-09 485
- 1947-01-03 485
- 1945-01-03 484
- 1951-01-03 484
- 1959-01-07 484
- 1961-01-03 484
- 1937-01-05 483
- 1969-01-03 482
- 1981-01-05 482
- 1963-01-09 481
- 1989-01-03 481
- 1935-01-03 480
- 1949-01-03 480
- 1957-01-03 480
- 1975-01-14 480
- 1971-01-21 478
- 1977-01-04 478
- 1983-01-03 478
- 1991-01-03 478
- …
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
17034 | 17034 | William Williams W000548 | rep | IL | 1899-12-04 | 1901-03-03 | Democrat | 16 | |||||||||||||
17035 | 17035 | William Williams W000548 | rep | IL | 1913-04-07 | 1915-03-03 | Democrat | -1 | |||||||||||||
17036 | 17036 | William Williams W000548 | rep | IL | 1915-12-06 | 1917-03-03 | Democrat | -1 | |||||||||||||
17037 | 17037 | Emmett Wilson W000575 | rep | FL | 1913-04-07 | 1915-03-03 | Democrat | 3 | |||||||||||||
17038 | 17038 | Emmett Wilson W000575 | rep | FL | 1915-12-06 | 1917-03-03 | Democrat | 3 | |||||||||||||
17039 | 17039 | Samuel Witherspoon W000662 | rep | MS | 1911-04-04 | 1913-03-03 | Democrat | 5 | |||||||||||||
17040 | 17040 | Samuel Witherspoon W000662 | rep | MS | 1913-04-07 | 1915-03-03 | Democrat | 5 | |||||||||||||
17041 | 17041 | Samuel Witherspoon W000662 | rep | MS | 1915-12-06 | 1917-03-03 | Democrat | 5 | |||||||||||||
17042 | 17042 | William Kirby K000233 | sen | AR | 1916-01-01 | 1921-03-03 | 3 | Democrat | |||||||||||||
17043 | 17043 | Thomas Taggart T000013 | sen | IN | 1916-03-20 | 1917-03-03 | 3 | Democrat | appointment | ||||||||||||
17044 | 17044 | William Adamson A000051 | rep | GA | 1897-03-15 | 1899-03-03 | Democrat | 4 | |||||||||||||
17045 | 17045 | William Adamson A000051 | rep | GA | 1899-12-04 | 1901-03-03 | Democrat | 4 | |||||||||||||
17046 | 17046 | William Adamson A000051 | rep | GA | 1901-12-02 | 1903-03-03 | Democrat | 4 | |||||||||||||
17047 | 17047 | William Adamson A000051 | rep | GA | 1903-11-09 | 1905-03-03 | Democrat | 4 | |||||||||||||
17048 | 17048 | William Adamson A000051 | rep | GA | 1905-12-04 | 1907-03-03 | Democrat | 4 | |||||||||||||
17049 | 17049 | William Adamson A000051 | rep | GA | 1907-12-02 | 1909-03-03 | Democrat | 4 | |||||||||||||
17050 | 17050 | William Adamson A000051 | rep | GA | 1909-03-15 | 1911-03-03 | Democrat | 4 | |||||||||||||
17051 | 17051 | William Adamson A000051 | rep | GA | 1911-04-04 | 1913-03-03 | Democrat | 4 | |||||||||||||
17052 | 17052 | William Adamson A000051 | rep | GA | 1913-04-07 | 1915-03-03 | Democrat | 4 | |||||||||||||
17053 | 17053 | William Adamson A000051 | rep | GA | 1915-12-06 | 1917-03-03 | Democrat | 4 | |||||||||||||
17054 | 17054 | William Adamson A000051 | rep | GA | 1917-04-02 | 1919-03-03 | Democrat | 4 | |||||||||||||
17055 | 17055 | Richard Austin A000341 | rep | TN | 1909-03-15 | 1911-03-03 | Republican | 2 | |||||||||||||
17056 | 17056 | Richard Austin A000341 | rep | TN | 1911-04-04 | 1913-03-03 | Republican | 2 | |||||||||||||
17057 | 17057 | Richard Austin A000341 | rep | TN | 1913-04-07 | 1915-03-03 | Republican | 2 | |||||||||||||
17058 | 17058 | Richard Austin A000341 | rep | TN | 1915-12-06 | 1917-03-03 | Republican | 2 | |||||||||||||
17059 | 17059 | Richard Austin A000341 | rep | TN | 1917-04-02 | 1919-03-03 | Republican | 2 | |||||||||||||
17060 | 17060 | Mark Bacon B000018 | rep | MI | 1917-04-02 | 1919-03-03 | Republican | 2 | |||||||||||||
17061 | 17061 | Henry Barnhart B000164 | rep | IN | 1907-12-02 | 1909-03-03 | Democrat | 13 | |||||||||||||
17062 | 17062 | Henry Barnhart B000164 | rep | IN | 1909-03-15 | 1911-03-03 | Democrat | 13 | |||||||||||||
17063 | 17063 | Henry Barnhart B000164 | rep | IN | 1911-04-04 | 1913-03-03 | Democrat | 13 | |||||||||||||
17064 | 17064 | Henry Barnhart B000164 | rep | IN | 1913-04-07 | 1915-03-03 | Democrat | 13 | |||||||||||||
17065 | 17065 | Henry Barnhart B000164 | rep | IN | 1915-12-06 | 1917-03-03 | Democrat | 13 | |||||||||||||
17066 | 17066 | Henry Barnhart B000164 | rep | IN | 1917-04-02 | 1919-03-03 | Democrat | 13 | |||||||||||||
17067 | 17067 | Elsworth Bathrick B000240 | rep | OH | 1911-04-04 | 1913-03-03 | Democrat | 19 | |||||||||||||
17068 | 17068 | Elsworth Bathrick B000240 | rep | OH | 1913-04-07 | 1915-03-03 | Democrat | 19 | |||||||||||||
17069 | 17069 | Elsworth Bathrick B000240 | rep | OH | 1917-04-02 | 1919-03-03 | Democrat | 14 | |||||||||||||
17070 | 17070 | Samuel Beakes B000264 | rep | MI | 1913-04-07 | 1915-03-03 | Democrat | 2 | |||||||||||||
17071 | 17071 | Samuel Beakes B000264 | rep | MI | 1915-12-06 | 1917-03-03 | Democrat | 2 | |||||||||||||
17072 | 17072 | Samuel Beakes B000264 | rep | MI | 1917-04-02 | 1919-03-03 | Democrat | 2 | |||||||||||||
17073 | 17073 | Earl Beshlin B000421 | rep | PA | 1917-04-02 | 1919-03-03 | Democrat | 28 | |||||||||||||
17074 | 17074 | William Birch B000476 | rep | NJ | 1917-04-02 | 1919-03-03 | Republican | 5 | |||||||||||||
17075 | 17075 | Orrin Bleakley B000552 | rep | PA | 1917-04-02 | 1919-03-03 | Republican | 28 | |||||||||||||
17076 | 17076 | William Borland B000643 | rep | MO | 1909-03-15 | 1911-03-03 | Democrat | 5 | |||||||||||||
17077 | 17077 | William Borland B000643 | rep | MO | 1911-04-04 | 1913-03-03 | Democrat | 5 | |||||||||||||
17078 | 17078 | William Borland B000643 | rep | MO | 1913-04-07 | 1915-03-03 | Democrat | 5 | |||||||||||||
17079 | 17079 | William Borland B000643 | rep | MO | 1915-12-06 | 1917-03-03 | Democrat | 5 | |||||||||||||
17080 | 17080 | William Borland B000643 | rep | MO | 1917-04-02 | 1919-03-03 | Democrat | 5 | |||||||||||||
17081 | 17081 | James Britt B000846 | rep | NC | 1915-12-06 | 1917-03-03 | Republican | 10 | |||||||||||||
17082 | 17082 | James Britt B000846 | rep | NC | 1917-04-02 | 1919-03-03 | Republican | 10 | |||||||||||||
17083 | 17083 | Andrew Brodbeck B000855 | rep | PA | 1913-04-07 | 1915-03-03 | Democrat | 20 | |||||||||||||
17084 | 17084 | Andrew Brodbeck B000855 | rep | PA | 1917-04-02 | 1919-03-03 | Democrat | 20 | |||||||||||||
17085 | 17085 | Henry Bruckner B000974 | rep | NY | 1913-04-07 | 1915-03-03 | Democrat | 22 | |||||||||||||
17086 | 17086 | Henry Bruckner B000974 | rep | NY | 1915-12-06 | 1917-03-03 | Democrat | 22 | |||||||||||||
17087 | 17087 | Henry Bruckner B000974 | rep | NY | 1917-04-02 | 1919-03-03 | Democrat | 22 | |||||||||||||
17088 | 17088 | William Calder C000025 | rep | NY | 1905-12-04 | 1907-03-03 | Republican | 6 | |||||||||||||
17089 | 17089 | William Calder C000025 | rep | NY | 1907-12-02 | 1909-03-03 | Republican | 6 | |||||||||||||
17090 | 17090 | William Calder C000025 | rep | NY | 1909-03-15 | 1911-03-03 | Republican | 6 | |||||||||||||
17091 | 17091 | William Calder C000025 | rep | NY | 1911-04-04 | 1913-03-03 | Republican | 6 | |||||||||||||
17092 | 17092 | William Calder C000025 | rep | NY | 1913-04-07 | 1915-03-03 | Republican | 6 | |||||||||||||
17093 | 17093 | William Calder C000025 | sen | NY | 1917-04-02 | 1923-03-03 | 1 | Republican | |||||||||||||
17094 | 17094 | John Capstick C000136 | rep | NJ | 1915-12-06 | 1917-03-03 | Republican | 5 | |||||||||||||
17095 | 17095 | John Capstick C000136 | rep | NJ | 1917-04-02 | 1919-03-03 | Republican | 5 | |||||||||||||
17096 | 17096 | William Carter C000205 | rep | MA | 1915-12-06 | 1917-03-03 | Republican | 13 | |||||||||||||
17097 | 17097 | William Carter C000205 | rep | MA | 1917-04-02 | 1919-03-03 | Republican | 13 | |||||||||||||
17098 | 17098 | William Cary C000218 | rep | WI | 1907-12-02 | 1909-03-03 | Republican | 4 | |||||||||||||
17099 | 17099 | William Cary C000218 | rep | WI | 1909-03-15 | 1911-03-03 | Republican | 4 | |||||||||||||
17100 | 17100 | William Cary C000218 | rep | WI | 1911-04-04 | 1913-03-03 | Republican | 4 | |||||||||||||
17101 | 17101 | William Cary C000218 | rep | WI | 1913-04-07 | 1915-03-03 | Republican | 4 | |||||||||||||
17102 | 17102 | William Cary C000218 | rep | WI | 1915-12-06 | 1917-03-03 | Republican | 4 | |||||||||||||
17103 | 17103 | William Cary C000218 | rep | WI | 1917-04-02 | 1919-03-03 | Republican | 4 | |||||||||||||
17104 | 17104 | Henry Clark C000433 | rep | PA | 1917-04-02 | 1919-03-03 | Republican | 25 | |||||||||||||
17105 | 17105 | Horatio Claypool C000490 | rep | OH | 1911-04-04 | 1913-03-03 | Democrat | 11 | |||||||||||||
17106 | 17106 | Horatio Claypool C000490 | rep | OH | 1913-04-07 | 1915-03-03 | Democrat | 11 | |||||||||||||
17107 | 17107 | Horatio Claypool C000490 | rep | OH | 1917-04-02 | 1919-03-03 | Democrat | 11 | |||||||||||||
17108 | 17108 | Daniel Comstock C000663 | rep | IN | 1917-04-02 | 1919-03-03 | Republican | 6 | |||||||||||||
17109 | 17109 | John Connelly C000689 | rep | KS | 1913-04-07 | 1915-03-03 | Democrat | 6 | |||||||||||||
17110 | 17110 | John Connelly C000689 | rep | KS | 1915-12-06 | 1917-03-03 | Democrat | 6 | |||||||||||||
17111 | 17111 | John Connelly C000689 | rep | KS | 1917-04-02 | 1919-03-03 | Democrat | 6 | |||||||||||||
17112 | 17112 | Michael Conry C000707 | rep | NY | 1909-03-15 | 1911-03-03 | Democrat | 12 | |||||||||||||
17113 | 17113 | Michael Conry C000707 | rep | NY | 1911-04-04 | 1913-03-03 | Democrat | 12 | |||||||||||||
17114 | 17114 | Michael Conry C000707 | rep | NY | 1913-04-07 | 1915-03-03 | Democrat | 15 | |||||||||||||
17115 | 17115 | Michael Conry C000707 | rep | NY | 1915-12-06 | 1917-03-03 | Democrat | 15 | |||||||||||||
17116 | 17116 | Michael Conry C000707 | rep | NY | 1917-04-02 | 1919-03-03 | Democrat | -1 | |||||||||||||
17117 | 17117 | Edward Cooper C000748 | rep | WV | 1915-12-06 | 1917-03-03 | Republican | 5 | |||||||||||||
17118 | 17118 | Edward Cooper C000748 | rep | WV | 1917-04-02 | 1919-03-03 | Republican | 5 | |||||||||||||
17119 | 17119 | William Cox C000840 | rep | IN | 1907-12-02 | 1909-03-03 | Democrat | 3 | |||||||||||||
17120 | 17120 | William Cox C000840 | rep | IN | 1909-03-15 | 1911-03-03 | Democrat | 3 | |||||||||||||
17121 | 17121 | William Cox C000840 | rep | IN | 1911-04-04 | 1913-03-03 | Democrat | 3 | |||||||||||||
17122 | 17122 | William Cox C000840 | rep | IN | 1913-04-07 | 1915-03-03 | Democrat | 3 | |||||||||||||
17123 | 17123 | William Cox C000840 | rep | IN | 1915-12-06 | 1917-03-03 | Democrat | 3 | |||||||||||||
17124 | 17124 | William Cox C000840 | rep | IN | 1917-04-02 | 1919-03-03 | Democrat | 3 | |||||||||||||
17125 | 17125 | Charles Culberson C000963 | sen | TX | 1899-12-04 | 1905-03-03 | 1 | Democrat | |||||||||||||
17126 | 17126 | Charles Culberson C000963 | sen | TX | 1905-12-04 | 1911-03-03 | 1 | Democrat | |||||||||||||
17127 | 17127 | Charles Culberson C000963 | sen | TX | 1911-04-04 | 1917-03-03 | 1 | Democrat | |||||||||||||
17128 | 17128 | Charles Culberson C000963 | sen | TX | 1917-04-02 | 1923-03-03 | 1 | Democrat | |||||||||||||
17129 | 17129 | Harry Dale D000008 | rep | NY | 1913-04-07 | 1915-03-03 | Democrat | 4 | |||||||||||||
17130 | 17130 | Harry Dale D000008 | rep | NY | 1915-12-06 | 1917-03-03 | Democrat | 4 | |||||||||||||
17131 | 17131 | Harry Dale D000008 | rep | NY | 1917-04-02 | 1919-03-03 | Democrat | 4 | |||||||||||||
17132 | 17132 | James Davidson D000084 | rep | WI | 1897-03-15 | 1899-03-03 | Republican | 6 | |||||||||||||
17133 | 17133 | James Davidson D000084 | rep | WI | 1899-12-04 | 1901-03-03 | Republican | 6 |
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);