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 ✖
- 1943-01-06 487
- 1947-01-03 485
- 1945-01-03 484
- 1951-01-03 484
- 1959-01-07 484
- 1961-01-03 484
- 1969-01-03 482
- 1981-01-05 482
- 1963-01-09 481
- 1989-01-03 481
- 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
- 1953-01-03 477
- 1965-01-04 477
- 1973-01-03 477
- 1979-01-15 477
- 1985-01-03 477
- 1987-01-06 477
- 1993-01-05 476
- 1997-01-07 475
- 2015-01-06 475
- 2003-01-07 474
- 2011-01-05 474
- 2017-01-03 474
- 1967-01-10 473
- …
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
23210 | 23210 | Leon Sacks S000008 | rep | PA | 1937-01-05 | 1939-01-03 | Democrat | 1 | |||||||||||||
23211 | 23211 | Leon Sacks S000008 | rep | PA | 1939-01-03 | 1941-01-03 | Democrat | 1 | |||||||||||||
23212 | 23212 | Leon Sacks S000008 | rep | PA | 1941-01-03 | 1943-01-03 | Democrat | 1 | |||||||||||||
23213 | 23213 | Jared Sanders S000036 | rep | LA | 1933-03-09 | 1935-01-03 | Democrat | 6 | |||||||||||||
23214 | 23214 | Jared Sanders S000036 | rep | LA | 1935-01-03 | 1937-01-03 | Democrat | 6 | |||||||||||||
23215 | 23215 | Jared Sanders S000036 | rep | LA | 1941-01-03 | 1943-01-03 | Democrat | 6 | |||||||||||||
23216 | 23216 | Edwin Schaefer S000110 | rep | IL | 1933-03-09 | 1935-01-03 | Democrat | 22 | |||||||||||||
23217 | 23217 | Edwin Schaefer S000110 | rep | IL | 1935-01-03 | 1937-01-03 | Democrat | 22 | |||||||||||||
23218 | 23218 | Edwin Schaefer S000110 | rep | IL | 1937-01-05 | 1939-01-03 | Democrat | 22 | |||||||||||||
23219 | 23219 | Edwin Schaefer S000110 | rep | IL | 1939-01-03 | 1941-01-03 | Democrat | 22 | |||||||||||||
23220 | 23220 | Edwin Schaefer S000110 | rep | IL | 1941-01-03 | 1943-01-03 | Democrat | 22 | |||||||||||||
23221 | 23221 | William Schulte S000145 | rep | IN | 1933-03-09 | 1935-01-03 | Democrat | 1 | |||||||||||||
23222 | 23222 | William Schulte S000145 | rep | IN | 1935-01-03 | 1937-01-03 | Democrat | 1 | |||||||||||||
23223 | 23223 | William Schulte S000145 | rep | IN | 1937-01-05 | 1939-01-03 | Democrat | 1 | |||||||||||||
23224 | 23224 | William Schulte S000145 | rep | IN | 1939-01-03 | 1941-01-03 | Democrat | 1 | |||||||||||||
23225 | 23225 | William Schulte S000145 | rep | IN | 1941-01-03 | 1943-01-03 | Democrat | 1 | |||||||||||||
23226 | 23226 | Pius Schwert S000162 | rep | NY | 1939-01-03 | 1941-01-03 | Democrat | 42 | |||||||||||||
23227 | 23227 | Pius Schwert S000162 | rep | NY | 1941-01-03 | 1943-01-03 | Democrat | 42 | |||||||||||||
23228 | 23228 | James Shanley S000285 | rep | CT | 1935-01-03 | 1937-01-03 | Democrat | 3 | |||||||||||||
23229 | 23229 | James Shanley S000285 | rep | CT | 1937-01-05 | 1939-01-03 | Democrat | 3 | |||||||||||||
23230 | 23230 | James Shanley S000285 | rep | CT | 1939-01-03 | 1941-01-03 | Democrat | 3 | |||||||||||||
23231 | 23231 | James Shanley S000285 | rep | CT | 1941-01-03 | 1943-01-03 | Democrat | 3 | |||||||||||||
23232 | 23232 | Joseph Shannon S000287 | rep | MO | 1931-12-07 | 1933-03-03 | Democrat | 5 | |||||||||||||
23233 | 23233 | Joseph Shannon S000287 | rep | MO | 1933-03-09 | 1935-01-03 | Democrat | 0 | |||||||||||||
23234 | 23234 | Joseph Shannon S000287 | rep | MO | 1935-01-03 | 1937-01-03 | Democrat | 5 | |||||||||||||
23235 | 23235 | Joseph Shannon S000287 | rep | MO | 1937-01-05 | 1939-01-03 | Democrat | 5 | |||||||||||||
23236 | 23236 | Joseph Shannon S000287 | rep | MO | 1939-01-03 | 1941-01-03 | Democrat | 5 | |||||||||||||
23237 | 23237 | Joseph Shannon S000287 | rep | MO | 1941-01-03 | 1943-01-03 | Democrat | 5 | |||||||||||||
23238 | 23238 | Henrik Shipstead S000369 | sen | MN | 1923-12-03 | 1929-03-03 | 1 | Farmer-Labor | |||||||||||||
23239 | 23239 | Henrik Shipstead S000369 | sen | MN | 1929-04-15 | 1935-01-03 | 1 | Farmer-Labor | |||||||||||||
23240 | 23240 | Henrik Shipstead S000369 | sen | MN | 1935-01-03 | 1941-01-03 | 1 | Republican | |||||||||||||
23241 | 23241 | Henrik Shipstead S000369 | sen | MN | 1941-01-03 | 1947-01-03 | 1 | Republican | |||||||||||||
23242 | 23242 | Kenneth Simpson S000433 | rep | NY | 1941-01-03 | 1943-01-03 | Republican | 17 | |||||||||||||
23243 | 23243 | Francis Smith S000532 | rep | PA | 1941-01-03 | 1943-01-03 | Democrat | 5 | |||||||||||||
23244 | 23244 | John Smith S000572 | rep | CT | 1935-01-03 | 1937-01-03 | Democrat | 5 | |||||||||||||
23245 | 23245 | John Smith S000572 | rep | CT | 1937-01-05 | 1939-01-03 | Democrat | 5 | |||||||||||||
23246 | 23246 | John Smith S000572 | rep | CT | 1939-01-03 | 1941-01-03 | Democrat | 5 | |||||||||||||
23247 | 23247 | John Smith S000572 | rep | CT | 1941-01-03 | 1943-01-03 | Democrat | 5 | |||||||||||||
23248 | 23248 | Martin Smith S000591 | rep | WA | 1933-03-09 | 1935-01-03 | Democrat | 3 | |||||||||||||
23249 | 23249 | Martin Smith S000591 | rep | WA | 1935-01-03 | 1937-01-03 | Democrat | 3 | |||||||||||||
23250 | 23250 | Martin Smith S000591 | rep | WA | 1937-01-05 | 1939-01-03 | Democrat | 3 | |||||||||||||
23251 | 23251 | Martin Smith S000591 | rep | WA | 1939-01-03 | 1941-01-03 | Democrat | 3 | |||||||||||||
23252 | 23252 | Martin Smith S000591 | rep | WA | 1941-01-03 | 1943-01-03 | Democrat | 3 | |||||||||||||
23253 | 23253 | Charles South S000683 | rep | TX | 1935-01-03 | 1937-01-03 | Democrat | 21 | |||||||||||||
23254 | 23254 | Charles South S000683 | rep | TX | 1937-01-05 | 1939-01-03 | Democrat | 21 | |||||||||||||
23255 | 23255 | Charles South S000683 | rep | TX | 1939-01-03 | 1941-01-03 | Democrat | 21 | |||||||||||||
23256 | 23256 | Charles South S000683 | rep | TX | 1941-01-03 | 1943-01-03 | Democrat | 21 | |||||||||||||
23257 | 23257 | George Spencer S000724 | sen | AR | 1941-04-01 | 1943-01-03 | 2 | Democrat | appointment | ||||||||||||
23258 | 23258 | William Sutphin S001086 | rep | NJ | 1931-12-07 | 1933-03-03 | Democrat | 3 | |||||||||||||
23259 | 23259 | William Sutphin S001086 | rep | NJ | 1933-03-09 | 1935-01-03 | Democrat | 3 | |||||||||||||
23260 | 23260 | William Sutphin S001086 | rep | NJ | 1935-01-03 | 1937-01-03 | Democrat | 3 | |||||||||||||
23261 | 23261 | William Sutphin S001086 | rep | NJ | 1937-01-05 | 1939-01-03 | Democrat | 3 | |||||||||||||
23262 | 23262 | William Sutphin S001086 | rep | NJ | 1939-01-03 | 1941-01-03 | Democrat | 3 | |||||||||||||
23263 | 23263 | William Sutphin S001086 | rep | NJ | 1941-01-03 | 1943-01-03 | Democrat | 3 | |||||||||||||
23264 | 23264 | Martin Sweeney S001102 | rep | OH | 1931-12-07 | 1933-03-03 | Democrat | 20 | |||||||||||||
23265 | 23265 | Martin Sweeney S001102 | rep | OH | 1933-03-09 | 1935-01-03 | Democrat | 20 | |||||||||||||
23266 | 23266 | Martin Sweeney S001102 | rep | OH | 1935-01-03 | 1937-01-03 | Democrat | 20 | |||||||||||||
23267 | 23267 | Martin Sweeney S001102 | rep | OH | 1937-01-05 | 1939-01-03 | Democrat | 20 | |||||||||||||
23268 | 23268 | Martin Sweeney S001102 | rep | OH | 1939-01-03 | 1941-01-03 | Democrat | 20 | |||||||||||||
23269 | 23269 | Martin Sweeney S001102 | rep | OH | 1941-01-03 | 1943-01-03 | Democrat | 20 | |||||||||||||
23270 | 23270 | Edward Taylor T000072 | rep | CO | 1909-03-15 | 1911-03-03 | Democrat | -1 | |||||||||||||
23271 | 23271 | Edward Taylor T000072 | rep | CO | 1911-04-04 | 1913-03-03 | Democrat | -1 | |||||||||||||
23272 | 23272 | Edward Taylor T000072 | rep | CO | 1913-04-07 | 1915-03-03 | Democrat | -1 | |||||||||||||
23273 | 23273 | Edward Taylor T000072 | rep | CO | 1915-12-06 | 1917-03-03 | Democrat | 4 | |||||||||||||
23274 | 23274 | Edward Taylor T000072 | rep | CO | 1917-04-02 | 1919-03-03 | Democrat | 4 | |||||||||||||
23275 | 23275 | Edward Taylor T000072 | rep | CO | 1919-05-19 | 1921-03-03 | Democrat | 4 | |||||||||||||
23276 | 23276 | Edward Taylor T000072 | rep | CO | 1921-04-11 | 1923-03-03 | Democrat | 4 | |||||||||||||
23277 | 23277 | Edward Taylor T000072 | rep | CO | 1923-12-03 | 1925-03-03 | Democrat | 4 | |||||||||||||
23278 | 23278 | Edward Taylor T000072 | rep | CO | 1925-12-07 | 1927-03-04 | Democrat | 4 | |||||||||||||
23279 | 23279 | Edward Taylor T000072 | rep | CO | 1927-12-05 | 1929-03-03 | Democrat | 4 | |||||||||||||
23280 | 23280 | Edward Taylor T000072 | rep | CO | 1929-04-15 | 1931-03-03 | Democrat | 4 | |||||||||||||
23281 | 23281 | Edward Taylor T000072 | rep | CO | 1931-12-07 | 1933-03-03 | Democrat | 4 | |||||||||||||
23282 | 23282 | Edward Taylor T000072 | rep | CO | 1933-03-09 | 1935-01-03 | Democrat | 4 | |||||||||||||
23283 | 23283 | Edward Taylor T000072 | rep | CO | 1935-01-03 | 1937-01-03 | Democrat | 4 | |||||||||||||
23284 | 23284 | Edward Taylor T000072 | rep | CO | 1937-01-05 | 1939-01-03 | Democrat | 4 | |||||||||||||
23285 | 23285 | Edward Taylor T000072 | rep | CO | 1939-01-03 | 1941-01-03 | Democrat | 4 | |||||||||||||
23286 | 23286 | Edward Taylor T000072 | rep | CO | 1941-01-03 | 1943-01-03 | Democrat | 4 | |||||||||||||
23287 | 23287 | Rudolph Tenerowicz T000124 | rep | MI | 1939-01-03 | 1941-01-03 | Democrat | 1 | |||||||||||||
23288 | 23288 | Rudolph Tenerowicz T000124 | rep | MI | 1941-01-03 | 1943-01-03 | Democrat | 1 | |||||||||||||
23289 | 23289 | David Terry T000133 | rep | AR | 1933-03-09 | 1935-01-03 | Democrat | 5 | |||||||||||||
23290 | 23290 | David Terry T000133 | rep | AR | 1935-01-03 | 1937-01-03 | Democrat | 5 | |||||||||||||
23291 | 23291 | David Terry T000133 | rep | AR | 1937-01-05 | 1939-01-03 | Democrat | 5 | |||||||||||||
23292 | 23292 | David Terry T000133 | rep | AR | 1939-01-03 | 1941-01-03 | Democrat | 5 | |||||||||||||
23293 | 23293 | David Terry T000133 | rep | AR | 1941-01-03 | 1943-01-03 | Democrat | 5 | |||||||||||||
23294 | 23294 | Lewis Thill T000153 | rep | WI | 1939-01-03 | 1941-01-03 | Republican | 5 | |||||||||||||
23295 | 23295 | Lewis Thill T000153 | rep | WI | 1941-01-03 | 1943-01-03 | Republican | 5 | |||||||||||||
23296 | 23296 | George Tinkham T000283 | rep | MA | 1915-12-06 | 1917-03-03 | Republican | 11 | |||||||||||||
23297 | 23297 | George Tinkham T000283 | rep | MA | 1917-04-02 | 1919-03-03 | Republican | 11 | |||||||||||||
23298 | 23298 | George Tinkham T000283 | rep | MA | 1919-05-19 | 1921-03-03 | Republican | 11 | |||||||||||||
23299 | 23299 | George Tinkham T000283 | rep | MA | 1921-04-11 | 1923-03-03 | Republican | 11 | |||||||||||||
23300 | 23300 | George Tinkham T000283 | rep | MA | 1923-12-03 | 1925-03-03 | Republican | 11 | |||||||||||||
23301 | 23301 | George Tinkham T000283 | rep | MA | 1925-12-07 | 1927-03-04 | Republican | 11 | |||||||||||||
23302 | 23302 | George Tinkham T000283 | rep | MA | 1927-12-05 | 1929-03-03 | Republican | 11 | |||||||||||||
23303 | 23303 | George Tinkham T000283 | rep | MA | 1929-04-15 | 1931-03-03 | Republican | 11 | |||||||||||||
23304 | 23304 | George Tinkham T000283 | rep | MA | 1931-12-07 | 1933-03-03 | Republican | 11 | |||||||||||||
23305 | 23305 | George Tinkham T000283 | rep | MA | 1933-03-09 | 1935-01-03 | Republican | 10 | |||||||||||||
23306 | 23306 | George Tinkham T000283 | rep | MA | 1935-01-03 | 1937-01-03 | Republican | 10 | |||||||||||||
23307 | 23307 | George Tinkham T000283 | rep | MA | 1937-01-05 | 1939-01-03 | Republican | 10 | |||||||||||||
23308 | 23308 | George Tinkham T000283 | rep | MA | 1939-01-03 | 1941-01-03 | Republican | 10 | |||||||||||||
23309 | 23309 | George Tinkham T000283 | rep | MA | 1941-01-03 | 1943-01-03 | Republican | 10 |
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);