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
- 1961-01-03 483
- 1971-01-03 483
- 1965-01-03 482
- 1983-01-03 481
- 1959-01-03 480
- 1977-01-03 480
- 1955-01-03 479
- 1967-01-03 479
- 1975-01-03 479
- 1981-01-03 479
- 1987-01-03 478
- 1973-01-03 477
- 1979-01-03 477
- 1985-01-03 477
- 2015-01-03 476
- 1957-01-03 475
- 1989-01-03 475
- 1993-01-03 475
- 1969-01-03 474
- 1995-01-03 474
- 1991-01-03 473
- 1999-01-03 473
- 2001-01-03 473
- 2011-01-03 473
- 2017-01-03 473
- 1997-01-03 472
- 2005-01-03 472
- 2009-01-03 472
- 2023-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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
25248 | 25248 | Charles Eaton E000023 | rep | NJ | 1951-01-03 | 1953-01-03 | Republican | 5 | |||||||||||||
25249 | 25249 | Charles Elston E000160 | rep | OH | 1939-01-03 | 1941-01-03 | Republican | 1 | |||||||||||||
25250 | 25250 | Charles Elston E000160 | rep | OH | 1941-01-03 | 1943-01-03 | Republican | 1 | |||||||||||||
25251 | 25251 | Charles Elston E000160 | rep | OH | 1943-01-06 | 1945-01-03 | Republican | 1 | |||||||||||||
25252 | 25252 | Charles Elston E000160 | rep | OH | 1945-01-03 | 1947-01-03 | Republican | 1 | |||||||||||||
25253 | 25253 | Charles Elston E000160 | rep | OH | 1947-01-03 | 1949-01-03 | Republican | 1 | |||||||||||||
25254 | 25254 | Charles Elston E000160 | rep | OH | 1949-01-03 | 1951-01-03 | Republican | 1 | |||||||||||||
25255 | 25255 | Charles Elston E000160 | rep | OH | 1951-01-03 | 1953-01-03 | Republican | 1 | |||||||||||||
25256 | 25256 | Frank Fellows F000066 | rep | ME | 1941-01-03 | 1943-01-03 | Republican | 3 | |||||||||||||
25257 | 25257 | Frank Fellows F000066 | rep | ME | 1943-01-06 | 1945-01-03 | Republican | 3 | |||||||||||||
25258 | 25258 | Frank Fellows F000066 | rep | ME | 1945-01-03 | 1947-01-03 | Republican | 3 | |||||||||||||
25259 | 25259 | Frank Fellows F000066 | rep | ME | 1947-01-03 | 1949-01-03 | Republican | 3 | |||||||||||||
25260 | 25260 | Frank Fellows F000066 | rep | ME | 1949-01-03 | 1951-01-03 | Republican | 3 | |||||||||||||
25261 | 25261 | Frank Fellows F000066 | rep | ME | 1951-01-03 | 1953-01-03 | Republican | 3 | |||||||||||||
25262 | 25262 | Thomas Fugate F000399 | rep | VA | 1949-01-03 | 1951-01-03 | Democrat | 9 | |||||||||||||
25263 | 25263 | Thomas Fugate F000399 | rep | VA | 1951-01-03 | 1953-01-03 | Democrat | 9 | |||||||||||||
25264 | 25264 | John Furcolo F000431 | rep | MA | 1949-01-03 | 1951-01-03 | Democrat | 2 | |||||||||||||
25265 | 25265 | John Furcolo F000431 | rep | MA | 1951-01-03 | 1953-01-03 | Democrat | 2 | |||||||||||||
25266 | 25266 | Walter George G000131 | sen | GA | 1922-01-01 | 1927-03-04 | 3 | Democrat | |||||||||||||
25267 | 25267 | Walter George G000131 | sen | GA | 1927-12-05 | 1933-03-03 | 3 | Democrat | |||||||||||||
25268 | 25268 | Walter George G000131 | sen | GA | 1933-03-09 | 1939-01-03 | 3 | Democrat | |||||||||||||
25269 | 25269 | Walter George G000131 | sen | GA | 1939-01-03 | 1945-01-03 | 3 | Democrat | |||||||||||||
25270 | 25270 | Walter George G000131 | sen | GA | 1945-01-03 | 1951-01-03 | 3 | Democrat | |||||||||||||
25271 | 25271 | Walter George G000131 | sen | GA | 1951-01-03 | 1957-01-03 | 3 | Democrat | |||||||||||||
25272 | 25272 | Wilson Gillette G000206 | rep | PA | 1941-01-03 | 1943-01-03 | Republican | 15 | |||||||||||||
25273 | 25273 | Wilson Gillette G000206 | rep | PA | 1943-01-06 | 1945-01-03 | Republican | 15 | |||||||||||||
25274 | 25274 | Wilson Gillette G000206 | rep | PA | 1945-01-03 | 1947-01-03 | Republican | 14 | |||||||||||||
25275 | 25275 | Wilson Gillette G000206 | rep | PA | 1947-01-03 | 1949-01-03 | Republican | 14 | |||||||||||||
25276 | 25276 | Wilson Gillette G000206 | rep | PA | 1949-01-03 | 1951-01-03 | Republican | 14 | |||||||||||||
25277 | 25277 | Wilson Gillette G000206 | rep | PA | 1951-01-03 | 1953-01-03 | Republican | 14 | |||||||||||||
25278 | 25278 | Ed Gossett G000338 | rep | TX | 1939-01-03 | 1941-01-03 | Democrat | 13 | |||||||||||||
25279 | 25279 | Ed Gossett G000338 | rep | TX | 1941-01-03 | 1943-01-03 | Democrat | 13 | |||||||||||||
25280 | 25280 | Ed Gossett G000338 | rep | TX | 1943-01-06 | 1945-01-03 | Democrat | 13 | |||||||||||||
25281 | 25281 | Ed Gossett G000338 | rep | TX | 1945-01-03 | 1947-01-03 | Democrat | 13 | |||||||||||||
25282 | 25282 | Ed Gossett G000338 | rep | TX | 1947-01-03 | 1949-01-03 | Democrat | 13 | |||||||||||||
25283 | 25283 | Ed Gossett G000338 | rep | TX | 1949-01-03 | 1951-01-03 | Democrat | 13 | |||||||||||||
25284 | 25284 | Ed Gossett G000338 | rep | TX | 1951-01-03 | 1953-01-03 | Democrat | 13 | |||||||||||||
25285 | 25285 | Walter Granger G000379 | rep | UT | 1941-01-03 | 1943-01-03 | Democrat | 1 | |||||||||||||
25286 | 25286 | Walter Granger G000379 | rep | UT | 1943-01-06 | 1945-01-03 | Democrat | 1 | |||||||||||||
25287 | 25287 | Walter Granger G000379 | rep | UT | 1945-01-03 | 1947-01-03 | Democrat | 1 | |||||||||||||
25288 | 25288 | Walter Granger G000379 | rep | UT | 1947-01-03 | 1949-01-03 | Democrat | 1 | |||||||||||||
25289 | 25289 | Walter Granger G000379 | rep | UT | 1949-01-03 | 1951-01-03 | Democrat | 1 | |||||||||||||
25290 | 25290 | Walter Granger G000379 | rep | UT | 1951-01-03 | 1953-01-03 | Democrat | 1 | |||||||||||||
25291 | 25291 | Ernest Greenwood G000438 | rep | NY | 1951-01-03 | 1953-01-03 | Democrat | 1 | |||||||||||||
25292 | 25292 | Edwin Hall H000050 | rep | NY | 1939-01-03 | 1941-01-03 | Republican | 34 | |||||||||||||
25293 | 25293 | Edwin Hall H000050 | rep | NY | 1941-01-03 | 1943-01-03 | Republican | 34 | |||||||||||||
25294 | 25294 | Edwin Hall H000050 | rep | NY | 1943-01-06 | 1945-01-03 | Republican | 34 | |||||||||||||
25295 | 25295 | Edwin Hall H000050 | rep | NY | 1945-01-03 | 1947-01-03 | Republican | 37 | |||||||||||||
25296 | 25296 | Edwin Hall H000050 | rep | NY | 1947-01-03 | 1949-01-03 | Republican | 37 | |||||||||||||
25297 | 25297 | Edwin Hall H000050 | rep | NY | 1949-01-03 | 1951-01-03 | Republican | 37 | |||||||||||||
25298 | 25298 | Edwin Hall H000050 | rep | NY | 1951-01-03 | 1953-01-03 | Republican | 37 | |||||||||||||
25299 | 25299 | Leonard Hall H000060 | rep | NY | 1939-01-03 | 1941-01-03 | Republican | 1 | |||||||||||||
25300 | 25300 | Leonard Hall H000060 | rep | NY | 1941-01-03 | 1943-01-03 | Republican | 1 | |||||||||||||
25301 | 25301 | Leonard Hall H000060 | rep | NY | 1943-01-06 | 1945-01-03 | Republican | 1 | |||||||||||||
25302 | 25302 | Leonard Hall H000060 | rep | NY | 1945-01-03 | 1947-01-03 | Republican | 2 | |||||||||||||
25303 | 25303 | Leonard Hall H000060 | rep | NY | 1947-01-03 | 1949-01-03 | Republican | 2 | |||||||||||||
25304 | 25304 | Leonard Hall H000060 | rep | NY | 1949-01-03 | 1951-01-03 | Republican | 2 | |||||||||||||
25305 | 25305 | Leonard Hall H000060 | rep | NY | 1951-01-03 | 1953-01-03 | Republican | 2 | |||||||||||||
25306 | 25306 | Franck Havenner H000356 | rep | CA | 1937-01-05 | 1939-01-03 | Progressive | 4 | |||||||||||||
25307 | 25307 | Franck Havenner H000356 | rep | CA | 1939-01-03 | 1941-01-03 | Democrat | 4 | |||||||||||||
25308 | 25308 | Franck Havenner H000356 | rep | CA | 1945-01-03 | 1947-01-03 | Democrat | 4 | |||||||||||||
25309 | 25309 | Franck Havenner H000356 | rep | CA | 1947-01-03 | 1949-01-03 | Democrat | 4 | |||||||||||||
25310 | 25310 | Franck Havenner H000356 | rep | CA | 1949-01-03 | 1951-01-03 | Democrat | 4 | |||||||||||||
25311 | 25311 | Franck Havenner H000356 | rep | CA | 1951-01-03 | 1953-01-03 | Democrat | 4 | |||||||||||||
25312 | 25312 | Erland Hedrick H000442 | rep | WV | 1945-01-03 | 1947-01-03 | Democrat | 6 | |||||||||||||
25313 | 25313 | Erland Hedrick H000442 | rep | WV | 1947-01-03 | 1949-01-03 | Democrat | 6 | |||||||||||||
25314 | 25314 | Erland Hedrick H000442 | rep | WV | 1949-01-03 | 1951-01-03 | Democrat | 6 | |||||||||||||
25315 | 25315 | Erland Hedrick H000442 | rep | WV | 1951-01-03 | 1953-01-03 | Democrat | 6 | |||||||||||||
25316 | 25316 | James Heffernan H000443 | rep | NY | 1941-01-03 | 1943-01-03 | Democrat | 5 | |||||||||||||
25317 | 25317 | James Heffernan H000443 | rep | NY | 1943-01-06 | 1945-01-03 | Democrat | 5 | |||||||||||||
25318 | 25318 | James Heffernan H000443 | rep | NY | 1945-01-03 | 1947-01-03 | Democrat | 11 | |||||||||||||
25319 | 25319 | James Heffernan H000443 | rep | NY | 1947-01-03 | 1949-01-03 | Democrat | 11 | |||||||||||||
25320 | 25320 | James Heffernan H000443 | rep | NY | 1949-01-03 | 1951-01-03 | Democrat | 11 | |||||||||||||
25321 | 25321 | James Heffernan H000443 | rep | NY | 1951-01-03 | 1953-01-03 | Democrat | 11 | |||||||||||||
25322 | 25322 | Christian Herter H000548 | rep | MA | 1943-01-06 | 1945-01-03 | Republican | 10 | |||||||||||||
25323 | 25323 | Christian Herter H000548 | rep | MA | 1945-01-03 | 1947-01-03 | Republican | 10 | |||||||||||||
25324 | 25324 | Christian Herter H000548 | rep | MA | 1947-01-03 | 1949-01-03 | Republican | 10 | |||||||||||||
25325 | 25325 | Christian Herter H000548 | rep | MA | 1949-01-03 | 1951-01-03 | Republican | 10 | |||||||||||||
25326 | 25326 | Christian Herter H000548 | rep | MA | 1951-01-03 | 1953-01-03 | Republican | 10 | |||||||||||||
25327 | 25327 | Clyde Hoey H000679 | rep | NC | 1919-05-19 | 1921-03-03 | Democrat | 9 | |||||||||||||
25328 | 25328 | Clyde Hoey H000679 | sen | NC | 1945-01-03 | 1951-01-03 | 3 | Democrat | |||||||||||||
25329 | 25329 | Clyde Hoey H000679 | sen | NC | 1951-01-03 | 1955-01-03 | 3 | Democrat | |||||||||||||
25330 | 25330 | Theodore Irving I000037 | rep | MO | 1949-01-03 | 1951-01-03 | Democrat | 4 | |||||||||||||
25331 | 25331 | Theodore Irving I000037 | rep | MO | 1951-01-03 | 1953-01-03 | Democrat | 4 | |||||||||||||
25332 | 25332 | Edward Jenison J000080 | rep | IL | 1947-01-03 | 1949-01-03 | Republican | 18 | |||||||||||||
25333 | 25333 | Edward Jenison J000080 | rep | IL | 1949-01-03 | 1951-01-03 | Republican | 23 | |||||||||||||
25334 | 25334 | Edward Jenison J000080 | rep | IL | 1951-01-03 | 1953-01-03 | Republican | 23 | |||||||||||||
25335 | 25335 | Hamilton Jones J000224 | rep | NC | 1947-01-03 | 1949-01-03 | Democrat | 10 | |||||||||||||
25336 | 25336 | Hamilton Jones J000224 | rep | NC | 1949-01-03 | 1951-01-03 | Democrat | 10 | |||||||||||||
25337 | 25337 | Hamilton Jones J000224 | rep | NC | 1951-01-03 | 1953-01-03 | Democrat | 10 | |||||||||||||
25338 | 25338 | John Kee K000039 | rep | WV | 1933-03-09 | 1935-01-03 | Democrat | 5 | |||||||||||||
25339 | 25339 | John Kee K000039 | rep | WV | 1935-01-03 | 1937-01-03 | Democrat | 5 | |||||||||||||
25340 | 25340 | John Kee K000039 | rep | WV | 1937-01-05 | 1939-01-03 | Democrat | 5 | |||||||||||||
25341 | 25341 | John Kee K000039 | rep | WV | 1939-01-03 | 1941-01-03 | Democrat | 5 | |||||||||||||
25342 | 25342 | John Kee K000039 | rep | WV | 1941-01-03 | 1943-01-03 | Democrat | 5 | |||||||||||||
25343 | 25343 | John Kee K000039 | rep | WV | 1943-01-06 | 1945-01-03 | Democrat | 5 | |||||||||||||
25344 | 25344 | John Kee K000039 | rep | WV | 1945-01-03 | 1947-01-03 | Democrat | 5 | |||||||||||||
25345 | 25345 | John Kee K000039 | rep | WV | 1947-01-03 | 1949-01-03 | Democrat | 5 | |||||||||||||
25346 | 25346 | John Kee K000039 | rep | WV | 1949-01-03 | 1951-01-03 | Democrat | 5 | |||||||||||||
25347 | 25347 | John Kee K000039 | rep | WV | 1951-01-03 | 1953-01-03 | Democrat | 5 |
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);