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)
end (date) >30 ✖
- 1963-01-03 489
- 1953-01-03 486
- 1955-01-03 485
- 1961-01-03 483
- 1971-01-03 483
- 1965-01-03 482
- 1983-01-03 481
- 1959-01-03 480
- 1977-01-03 480
- 1967-01-03 479
- 1975-01-03 479
- 1981-01-03 479
- 1987-01-03 478
- 1951-01-03 477
- 1957-01-03 477
- 1973-01-03 477
- 1979-01-03 477
- 1985-01-03 477
- 2015-01-03 476
- 1989-01-03 475
- 1993-01-03 475
- 1969-01-03 474
- 1995-01-03 474
- 1949-01-03 473
- 1991-01-03 473
- 1999-01-03 473
- 2001-01-03 473
- 2011-01-03 473
- 2017-01-03 473
- 1997-01-03 472
- …
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
24107 | 24107 | Paul Stewart S000918 | rep | OK | 1943-01-06 | 1945-01-03 | Democrat | 3 | |||||||||||||
24108 | 24108 | Paul Stewart S000918 | rep | OK | 1945-01-03 | 1947-01-03 | Democrat | 3 | |||||||||||||
24109 | 24109 | Jessie Sumner S001071 | rep | IL | 1939-01-03 | 1941-01-03 | Republican | 18 | |||||||||||||
24110 | 24110 | Jessie Sumner S001071 | rep | IL | 1941-01-03 | 1943-01-03 | Republican | 18 | |||||||||||||
24111 | 24111 | Jessie Sumner S001071 | rep | IL | 1943-01-06 | 1945-01-03 | Republican | 18 | |||||||||||||
24112 | 24112 | Jessie Sumner S001071 | rep | IL | 1945-01-03 | 1947-01-03 | Republican | 18 | |||||||||||||
24113 | 24113 | Hatton Sumners S001072 | rep | TX | 1913-04-07 | 1915-03-03 | Democrat | -1 | |||||||||||||
24114 | 24114 | Hatton Sumners S001072 | rep | TX | 1915-12-06 | 1917-03-03 | Democrat | 5 | |||||||||||||
24115 | 24115 | Hatton Sumners S001072 | rep | TX | 1917-04-02 | 1919-03-03 | Democrat | 5 | |||||||||||||
24116 | 24116 | Hatton Sumners S001072 | rep | TX | 1919-05-19 | 1921-03-03 | Democrat | 5 | |||||||||||||
24117 | 24117 | Hatton Sumners S001072 | rep | TX | 1921-04-11 | 1923-03-03 | Democrat | 5 | |||||||||||||
24118 | 24118 | Hatton Sumners S001072 | rep | TX | 1923-12-03 | 1925-03-03 | Democrat | 5 | |||||||||||||
24119 | 24119 | Hatton Sumners S001072 | rep | TX | 1925-12-07 | 1927-03-04 | Democrat | 5 | |||||||||||||
24120 | 24120 | Hatton Sumners S001072 | rep | TX | 1927-12-05 | 1929-03-03 | Democrat | 5 | |||||||||||||
24121 | 24121 | Hatton Sumners S001072 | rep | TX | 1929-04-15 | 1931-03-03 | Democrat | 5 | |||||||||||||
24122 | 24122 | Hatton Sumners S001072 | rep | TX | 1931-12-07 | 1933-03-03 | Democrat | 5 | |||||||||||||
24123 | 24123 | Hatton Sumners S001072 | rep | TX | 1933-03-09 | 1935-01-03 | Democrat | 5 | |||||||||||||
24124 | 24124 | Hatton Sumners S001072 | rep | TX | 1935-01-03 | 1937-01-03 | Democrat | 5 | |||||||||||||
24125 | 24125 | Hatton Sumners S001072 | rep | TX | 1937-01-05 | 1939-01-03 | Democrat | 5 | |||||||||||||
24126 | 24126 | Hatton Sumners S001072 | rep | TX | 1939-01-03 | 1941-01-03 | Democrat | 5 | |||||||||||||
24127 | 24127 | Hatton Sumners S001072 | rep | TX | 1941-01-03 | 1943-01-03 | Democrat | 5 | |||||||||||||
24128 | 24128 | Hatton Sumners S001072 | rep | TX | 1943-01-06 | 1945-01-03 | Democrat | 5 | |||||||||||||
24129 | 24129 | Hatton Sumners S001072 | rep | TX | 1945-01-03 | 1947-01-03 | Democrat | 5 | |||||||||||||
24130 | 24130 | Joseph Talbot T000018 | rep | CT | 1941-01-03 | 1943-01-03 | Republican | 5 | |||||||||||||
24131 | 24131 | Joseph Talbot T000018 | rep | CT | 1943-01-06 | 1945-01-03 | Republican | 5 | |||||||||||||
24132 | 24132 | Joseph Talbot T000018 | rep | CT | 1945-01-03 | 1947-01-03 | Republican | 5 | |||||||||||||
24133 | 24133 | Malcolm Tarver T000045 | rep | GA | 1927-12-05 | 1929-03-03 | Democrat | 7 | |||||||||||||
24134 | 24134 | Malcolm Tarver T000045 | rep | GA | 1929-04-15 | 1931-03-03 | Democrat | 7 | |||||||||||||
24135 | 24135 | Malcolm Tarver T000045 | rep | GA | 1931-12-07 | 1933-03-03 | Democrat | 7 | |||||||||||||
24136 | 24136 | Malcolm Tarver T000045 | rep | GA | 1933-03-09 | 1935-01-03 | Democrat | 7 | |||||||||||||
24137 | 24137 | Malcolm Tarver T000045 | rep | GA | 1935-01-03 | 1937-01-03 | Democrat | 7 | |||||||||||||
24138 | 24138 | Malcolm Tarver T000045 | rep | GA | 1937-01-05 | 1939-01-03 | Democrat | 7 | |||||||||||||
24139 | 24139 | Malcolm Tarver T000045 | rep | GA | 1939-01-03 | 1941-01-03 | Democrat | 7 | |||||||||||||
24140 | 24140 | Malcolm Tarver T000045 | rep | GA | 1941-01-03 | 1943-01-03 | Democrat | 7 | |||||||||||||
24141 | 24141 | Malcolm Tarver T000045 | rep | GA | 1943-01-06 | 1945-01-03 | Democrat | 7 | |||||||||||||
24142 | 24142 | Malcolm Tarver T000045 | rep | GA | 1945-01-03 | 1947-01-03 | Democrat | 7 | |||||||||||||
24143 | 24143 | Glen Taylor T000079 | sen | ID | 1945-01-03 | 1951-01-03 | 3 | Democrat | |||||||||||||
24144 | 24144 | William Thom T000155 | rep | OH | 1933-03-09 | 1935-01-03 | Democrat | 16 | |||||||||||||
24145 | 24145 | William Thom T000155 | rep | OH | 1935-01-03 | 1937-01-03 | Democrat | 16 | |||||||||||||
24146 | 24146 | William Thom T000155 | rep | OH | 1937-01-05 | 1939-01-03 | Democrat | 16 | |||||||||||||
24147 | 24147 | William Thom T000155 | rep | OH | 1941-01-03 | 1943-01-03 | Democrat | 16 | |||||||||||||
24148 | 24148 | William Thom T000155 | rep | OH | 1945-01-03 | 1947-01-03 | Democrat | 16 | |||||||||||||
24149 | 24149 | Elbert Thomas T000164 | sen | UT | 1933-03-09 | 1939-01-03 | 3 | Democrat | |||||||||||||
24150 | 24150 | Elbert Thomas T000164 | sen | UT | 1939-01-03 | 1945-01-03 | 3 | Democrat | |||||||||||||
24151 | 24151 | Elbert Thomas T000164 | sen | UT | 1945-01-03 | 1951-01-03 | 3 | Democrat | |||||||||||||
24152 | 24152 | John Thomas T000177 | rep | OK | 1923-12-03 | 1925-03-03 | Democrat | 6 | |||||||||||||
24153 | 24153 | John Thomas T000177 | rep | OK | 1925-12-07 | 1927-03-04 | Democrat | 6 | |||||||||||||
24154 | 24154 | John Thomas T000177 | sen | OK | 1927-12-05 | 1933-03-03 | 3 | Democrat | |||||||||||||
24155 | 24155 | John Thomas T000177 | sen | OK | 1933-03-09 | 1939-01-03 | 3 | Democrat | |||||||||||||
24156 | 24156 | John Thomas T000177 | sen | OK | 1939-01-03 | 1945-01-03 | 3 | Democrat | |||||||||||||
24157 | 24157 | John Thomas T000177 | sen | OK | 1945-01-03 | 1951-01-03 | 3 | Democrat | |||||||||||||
24158 | 24158 | John Tolan T000295 | rep | CA | 1935-01-03 | 1937-01-03 | Democrat | 7 | |||||||||||||
24159 | 24159 | John Tolan T000295 | rep | CA | 1937-01-05 | 1939-01-03 | Democrat | 7 | |||||||||||||
24160 | 24160 | John Tolan T000295 | rep | CA | 1939-01-03 | 1941-01-03 | Democrat | 7 | |||||||||||||
24161 | 24161 | John Tolan T000295 | rep | CA | 1941-01-03 | 1943-01-03 | Democrat | 7 | |||||||||||||
24162 | 24162 | John Tolan T000295 | rep | CA | 1943-01-06 | 1945-01-03 | Democrat | 7 | |||||||||||||
24163 | 24163 | John Tolan T000295 | rep | CA | 1945-01-03 | 1947-01-03 | Democrat | 7 | |||||||||||||
24164 | 24164 | James Torrens T000315 | rep | NY | 1943-01-06 | 1945-01-03 | Democrat | 21 | |||||||||||||
24165 | 24165 | James Torrens T000315 | rep | NY | 1945-01-03 | 1947-01-03 | Democrat | 21 | |||||||||||||
24166 | 24166 | Philip Traynor T000357 | rep | DE | 1941-01-03 | 1943-01-03 | Democrat | 0 | |||||||||||||
24167 | 24167 | Philip Traynor T000357 | rep | DE | 1945-01-03 | 1947-01-03 | Democrat | 0 | |||||||||||||
24168 | 24168 | Millard Tydings T000446 | rep | MD | 1923-12-03 | 1925-03-03 | Democrat | 2 | |||||||||||||
24169 | 24169 | Millard Tydings T000446 | rep | MD | 1925-12-07 | 1927-03-04 | Democrat | 2 | |||||||||||||
24170 | 24170 | Millard Tydings T000446 | sen | MD | 1927-12-05 | 1933-03-03 | 3 | Democrat | |||||||||||||
24171 | 24171 | Millard Tydings T000446 | sen | MD | 1933-03-09 | 1939-01-03 | 3 | Democrat | |||||||||||||
24172 | 24172 | Millard Tydings T000446 | sen | MD | 1939-01-03 | 1945-01-03 | 3 | Democrat | |||||||||||||
24173 | 24173 | Millard Tydings T000446 | sen | MD | 1945-01-03 | 1951-01-03 | 3 | Democrat | |||||||||||||
24174 | 24174 | Horace Voorhis V000118 | rep | CA | 1937-01-05 | 1939-01-03 | Democrat | 12 | |||||||||||||
24175 | 24175 | Horace Voorhis V000118 | rep | CA | 1939-01-03 | 1941-01-03 | Democrat | 12 | |||||||||||||
24176 | 24176 | Horace Voorhis V000118 | rep | CA | 1941-01-03 | 1943-01-03 | Democrat | 12 | |||||||||||||
24177 | 24177 | Horace Voorhis V000118 | rep | CA | 1943-01-06 | 1945-01-03 | Democrat | 12 | |||||||||||||
24178 | 24178 | Horace Voorhis V000118 | rep | CA | 1945-01-03 | 1947-01-03 | Democrat | 12 | |||||||||||||
24179 | 24179 | Robert Wagner W000021 | sen | NY | 1927-12-05 | 1933-03-03 | 3 | Democrat | |||||||||||||
24180 | 24180 | Robert Wagner W000021 | sen | NY | 1933-03-09 | 1939-01-03 | 3 | Democrat | |||||||||||||
24181 | 24181 | Robert Wagner W000021 | sen | NY | 1939-01-03 | 1945-01-03 | 3 | Democrat | |||||||||||||
24182 | 24182 | Robert Wagner W000021 | sen | NY | 1945-01-03 | 1949-12-31 | 3 | Democrat | |||||||||||||
24183 | 24183 | Thaddeus Wasielewski W000183 | rep | WI | 1941-01-03 | 1943-01-03 | Democrat | 4 | |||||||||||||
24184 | 24184 | Thaddeus Wasielewski W000183 | rep | WI | 1943-01-06 | 1945-01-03 | Democrat | 4 | |||||||||||||
24185 | 24185 | Thaddeus Wasielewski W000183 | rep | WI | 1945-01-03 | 1947-01-03 | Democrat | 4 | |||||||||||||
24186 | 24186 | Zebulon Weaver W000230 | rep | NC | 1917-04-02 | 1919-03-03 | Democrat | 10 | |||||||||||||
24187 | 24187 | Zebulon Weaver W000230 | rep | NC | 1919-05-19 | 1921-03-03 | Democrat | 10 | |||||||||||||
24188 | 24188 | Zebulon Weaver W000230 | rep | NC | 1921-04-11 | 1923-03-03 | Democrat | 10 | |||||||||||||
24189 | 24189 | Zebulon Weaver W000230 | rep | NC | 1923-12-03 | 1925-03-03 | Democrat | 10 | |||||||||||||
24190 | 24190 | Zebulon Weaver W000230 | rep | NC | 1925-12-07 | 1927-03-04 | Democrat | 10 | |||||||||||||
24191 | 24191 | Zebulon Weaver W000230 | rep | NC | 1927-12-05 | 1929-03-03 | Democrat | 10 | |||||||||||||
24192 | 24192 | Zebulon Weaver W000230 | rep | NC | 1931-12-07 | 1933-03-03 | Democrat | 10 | |||||||||||||
24193 | 24193 | Zebulon Weaver W000230 | rep | NC | 1933-03-09 | 1935-01-03 | Democrat | 11 | |||||||||||||
24194 | 24194 | Zebulon Weaver W000230 | rep | NC | 1935-01-03 | 1937-01-03 | Democrat | 11 | |||||||||||||
24195 | 24195 | Zebulon Weaver W000230 | rep | NC | 1937-01-05 | 1939-01-03 | Democrat | 11 | |||||||||||||
24196 | 24196 | Zebulon Weaver W000230 | rep | NC | 1939-01-03 | 1941-01-03 | Democrat | 11 | |||||||||||||
24197 | 24197 | Zebulon Weaver W000230 | rep | NC | 1941-01-03 | 1943-01-03 | Democrat | 11 | |||||||||||||
24198 | 24198 | Zebulon Weaver W000230 | rep | NC | 1943-01-06 | 1945-01-03 | Democrat | 12 | |||||||||||||
24199 | 24199 | Zebulon Weaver W000230 | rep | NC | 1945-01-03 | 1947-01-03 | Democrat | 12 | |||||||||||||
24200 | 24200 | Samuel Weiss W000257 | rep | PA | 1941-01-03 | 1943-01-03 | Democrat | 31 | |||||||||||||
24201 | 24201 | Samuel Weiss W000257 | rep | PA | 1943-01-06 | 1945-01-03 | Democrat | 30 | |||||||||||||
24202 | 24202 | Samuel Weiss W000257 | rep | PA | 1945-01-03 | 1947-01-03 | Democrat | 33 | |||||||||||||
24203 | 24203 | Thomas Winter W000645 | rep | KS | 1939-01-03 | 1941-01-03 | Republican | 3 | |||||||||||||
24204 | 24204 | Thomas Winter W000645 | rep | KS | 1941-01-03 | 1943-01-03 | Republican | 3 | |||||||||||||
24205 | 24205 | Thomas Winter W000645 | rep | KS | 1943-01-06 | 1945-01-03 | Republican | 3 | |||||||||||||
24206 | 24206 | Thomas Winter W000645 | rep | KS | 1945-01-03 | 1947-01-03 | Republican | 3 |
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);