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 ✖
- 1981-01-05 482
- 1989-01-03 481
- 1975-01-14 480
- 1977-01-04 478
- 1983-01-03 478
- 1991-01-03 478
- 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
- 1999-01-06 473
- 2005-01-04 473
- 2007-01-04 473
- 2013-01-03 473
- 1995-01-04 472
- 2001-01-03 472
- 2009-01-06 472
- 2019-01-03 471
- 2021-01-03 471
- 1973-01-03 463
- 1971-01-21 378
- 1969-01-03 341
- 1967-01-10 297
- 1965-01-04 236
- 1963-01-09 199
- …
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
30240 | 30240 | Charles Chamberlain C000275 | rep | MI | 1973-01-03 | 1975-01-03 | Republican | 6 | |||||||||||||
30241 | 30241 | Frank Clark C000431 | rep | PA | 1955-01-05 | 1957-01-03 | Democrat | 25 | |||||||||||||
30242 | 30242 | Frank Clark C000431 | rep | PA | 1957-01-03 | 1959-01-03 | Democrat | 25 | |||||||||||||
30243 | 30243 | Frank Clark C000431 | rep | PA | 1959-01-07 | 1961-01-03 | Democrat | 25 | |||||||||||||
30244 | 30244 | Frank Clark C000431 | rep | PA | 1961-01-03 | 1963-01-03 | Democrat | 25 | |||||||||||||
30245 | 30245 | Frank Clark C000431 | rep | PA | 1963-01-09 | 1965-01-03 | Democrat | 25 | |||||||||||||
30246 | 30246 | Frank Clark C000431 | rep | PA | 1965-01-04 | 1967-01-03 | Democrat | 25 | |||||||||||||
30247 | 30247 | Frank Clark C000431 | rep | PA | 1967-01-10 | 1969-01-03 | Democrat | 25 | |||||||||||||
30248 | 30248 | Frank Clark C000431 | rep | PA | 1969-01-03 | 1971-01-03 | Democrat | 25 | |||||||||||||
30249 | 30249 | Frank Clark C000431 | rep | PA | 1971-01-21 | 1973-01-03 | Democrat | 25 | |||||||||||||
30250 | 30250 | Frank Clark C000431 | rep | PA | 1973-01-03 | 1975-01-03 | Democrat | 25 | |||||||||||||
30251 | 30251 | Richard Clark C000448 | sen | IA | 1973-01-03 | 1979-01-03 | 2 | Democrat | |||||||||||||
30252 | 30252 | Harold Collier C000629 | rep | IL | 1957-01-03 | 1959-01-03 | Republican | 10 | |||||||||||||
30253 | 30253 | Harold Collier C000629 | rep | IL | 1959-01-07 | 1961-01-03 | Republican | 10 | |||||||||||||
30254 | 30254 | Harold Collier C000629 | rep | IL | 1961-01-03 | 1963-01-03 | Republican | 10 | |||||||||||||
30255 | 30255 | Harold Collier C000629 | rep | IL | 1963-01-09 | 1965-01-03 | Republican | 10 | |||||||||||||
30256 | 30256 | Harold Collier C000629 | rep | IL | 1965-01-04 | 1967-01-03 | Republican | 10 | |||||||||||||
30257 | 30257 | Harold Collier C000629 | rep | IL | 1967-01-10 | 1969-01-03 | Republican | 10 | |||||||||||||
30258 | 30258 | Harold Collier C000629 | rep | IL | 1969-01-03 | 1971-01-03 | Republican | 10 | |||||||||||||
30259 | 30259 | Harold Collier C000629 | rep | IL | 1971-01-21 | 1973-01-03 | Republican | 10 | |||||||||||||
30260 | 30260 | Harold Collier C000629 | rep | IL | 1973-01-03 | 1975-01-03 | Republican | 6 | |||||||||||||
30261 | 30261 | George Collins C000637 | rep | IL | 1970-11-03 | 1971-01-03 | Democrat | 6 | |||||||||||||
30262 | 30262 | George Collins C000637 | rep | IL | 1971-01-21 | 1972-12-08 | Democrat | 6 | |||||||||||||
30263 | 30263 | Paul Cronin C000925 | rep | MA | 1973-01-03 | 1975-01-03 | Republican | 5 | |||||||||||||
30264 | 30264 | Carl Curtis C001006 | rep | NE | 1939-01-03 | 1941-01-03 | Republican | 4 | |||||||||||||
30265 | 30265 | Carl Curtis C001006 | rep | NE | 1941-01-03 | 1943-01-03 | Republican | 4 | |||||||||||||
30266 | 30266 | Carl Curtis C001006 | rep | NE | 1943-01-06 | 1945-01-03 | Republican | 1 | |||||||||||||
30267 | 30267 | Carl Curtis C001006 | rep | NE | 1945-01-03 | 1947-01-03 | Republican | 1 | |||||||||||||
30268 | 30268 | Carl Curtis C001006 | rep | NE | 1947-01-03 | 1949-01-03 | Republican | 1 | |||||||||||||
30269 | 30269 | Carl Curtis C001006 | rep | NE | 1949-01-03 | 1951-01-03 | Republican | 1 | |||||||||||||
30270 | 30270 | Carl Curtis C001006 | rep | NE | 1951-01-03 | 1953-01-03 | Republican | 1 | |||||||||||||
30271 | 30271 | Carl Curtis C001006 | rep | NE | 1953-01-03 | 1955-01-03 | Republican | 1 | |||||||||||||
30272 | 30272 | Carl Curtis C001006 | sen | NE | 1955-01-05 | 1961-01-03 | 2 | Republican | |||||||||||||
30273 | 30273 | Carl Curtis C001006 | sen | NE | 1961-01-03 | 1967-01-03 | 2 | Republican | |||||||||||||
30274 | 30274 | Carl Curtis C001006 | sen | NE | 1967-01-10 | 1973-01-03 | 2 | Republican | |||||||||||||
30275 | 30275 | Carl Curtis C001006 | sen | NE | 1973-01-03 | 1979-01-03 | 2 | Republican | |||||||||||||
30276 | 30276 | Glenn Davis D000102 | rep | WI | 1947-01-03 | 1949-01-03 | Republican | 2 | |||||||||||||
30277 | 30277 | Glenn Davis D000102 | rep | WI | 1949-01-03 | 1951-01-03 | Republican | 2 | |||||||||||||
30278 | 30278 | Glenn Davis D000102 | rep | WI | 1951-01-03 | 1953-01-03 | Republican | 2 | |||||||||||||
30279 | 30279 | Glenn Davis D000102 | rep | WI | 1953-01-03 | 1955-01-03 | Republican | 2 | |||||||||||||
30280 | 30280 | Glenn Davis D000102 | rep | WI | 1955-01-05 | 1957-01-03 | Republican | 2 | |||||||||||||
30281 | 30281 | Glenn Davis D000102 | rep | WI | 1965-01-04 | 1967-01-03 | Republican | 9 | |||||||||||||
30282 | 30282 | Glenn Davis D000102 | rep | WI | 1967-01-10 | 1969-01-03 | Republican | 9 | |||||||||||||
30283 | 30283 | Glenn Davis D000102 | rep | WI | 1969-01-03 | 1971-01-03 | Republican | 9 | |||||||||||||
30284 | 30284 | Glenn Davis D000102 | rep | WI | 1971-01-21 | 1973-01-03 | Republican | 9 | |||||||||||||
30285 | 30285 | Glenn Davis D000102 | rep | WI | 1973-01-03 | 1975-01-03 | Republican | 9 | |||||||||||||
30286 | 30286 | John Davis D000122 | rep | GA | 1961-01-03 | 1963-01-03 | Democrat | 7 | |||||||||||||
30287 | 30287 | John Davis D000122 | rep | GA | 1963-01-09 | 1965-01-03 | Democrat | 7 | |||||||||||||
30288 | 30288 | John Davis D000122 | rep | GA | 1965-01-04 | 1967-01-03 | Democrat | 7 | |||||||||||||
30289 | 30289 | John Davis D000122 | rep | GA | 1967-01-10 | 1969-01-03 | Democrat | 7 | |||||||||||||
30290 | 30290 | John Davis D000122 | rep | GA | 1969-01-03 | 1971-01-03 | Democrat | 7 | |||||||||||||
30291 | 30291 | John Davis D000122 | rep | GA | 1971-01-21 | 1973-01-03 | Democrat | 7 | |||||||||||||
30292 | 30292 | John Davis D000122 | rep | GA | 1973-01-03 | 1975-01-03 | Democrat | 7 | |||||||||||||
30293 | 30293 | John Dellenback D000220 | rep | OR | 1967-01-10 | 1969-01-03 | Republican | 4 | |||||||||||||
30294 | 30294 | John Dellenback D000220 | rep | OR | 1969-01-03 | 1971-01-03 | Republican | 4 | |||||||||||||
30295 | 30295 | John Dellenback D000220 | rep | OR | 1971-01-21 | 1973-01-03 | Republican | 4 | |||||||||||||
30296 | 30296 | John Dellenback D000220 | rep | OR | 1973-01-03 | 1975-01-03 | Republican | 4 | |||||||||||||
30297 | 30297 | Frank Denholm D000234 | rep | SD | 1971-01-21 | 1973-01-03 | Democrat | 1 | |||||||||||||
30298 | 30298 | Frank Denholm D000234 | rep | SD | 1973-01-03 | 1975-01-03 | Democrat | 1 | |||||||||||||
30299 | 30299 | David Dennis D000241 | rep | IN | 1969-01-03 | 1971-01-03 | Republican | 10 | |||||||||||||
30300 | 30300 | David Dennis D000241 | rep | IN | 1971-01-21 | 1973-01-03 | Republican | 10 | |||||||||||||
30301 | 30301 | David Dennis D000241 | rep | IN | 1973-01-03 | 1975-01-03 | Republican | 10 | |||||||||||||
30302 | 30302 | Harold Donohue D000419 | rep | MA | 1947-01-03 | 1949-01-03 | Democrat | 4 | |||||||||||||
30303 | 30303 | Harold Donohue D000419 | rep | MA | 1949-01-03 | 1951-01-03 | Democrat | 4 | |||||||||||||
30304 | 30304 | Harold Donohue D000419 | rep | MA | 1951-01-03 | 1953-01-03 | Democrat | 4 | |||||||||||||
30305 | 30305 | Harold Donohue D000419 | rep | MA | 1953-01-03 | 1955-01-03 | Democrat | 4 | |||||||||||||
30306 | 30306 | Harold Donohue D000419 | rep | MA | 1955-01-05 | 1957-01-03 | Democrat | 4 | |||||||||||||
30307 | 30307 | Harold Donohue D000419 | rep | MA | 1957-01-03 | 1959-01-03 | Democrat | 4 | |||||||||||||
30308 | 30308 | Harold Donohue D000419 | rep | MA | 1959-01-07 | 1961-01-03 | Democrat | 4 | |||||||||||||
30309 | 30309 | Harold Donohue D000419 | rep | MA | 1961-01-03 | 1963-01-03 | Democrat | 4 | |||||||||||||
30310 | 30310 | Harold Donohue D000419 | rep | MA | 1963-01-09 | 1965-01-03 | Democrat | 4 | |||||||||||||
30311 | 30311 | Harold Donohue D000419 | rep | MA | 1965-01-04 | 1967-01-03 | Democrat | 4 | |||||||||||||
30312 | 30312 | Harold Donohue D000419 | rep | MA | 1967-01-10 | 1969-01-03 | Democrat | 4 | |||||||||||||
30313 | 30313 | Harold Donohue D000419 | rep | MA | 1969-01-03 | 1971-01-03 | Democrat | 4 | |||||||||||||
30314 | 30314 | Harold Donohue D000419 | rep | MA | 1971-01-21 | 1973-01-03 | Democrat | 4 | |||||||||||||
30315 | 30315 | Harold Donohue D000419 | rep | MA | 1973-01-03 | 1975-01-03 | Democrat | 3 | |||||||||||||
30316 | 30316 | William Dorn D000434 | rep | SC | 1947-01-03 | 1949-01-03 | Democrat | 3 | |||||||||||||
30317 | 30317 | William Dorn D000434 | rep | SC | 1951-01-03 | 1953-01-03 | Democrat | 3 | |||||||||||||
30318 | 30318 | William Dorn D000434 | rep | SC | 1953-01-03 | 1955-01-03 | Democrat | 3 | |||||||||||||
30319 | 30319 | William Dorn D000434 | rep | SC | 1955-01-05 | 1957-01-03 | Democrat | 3 | |||||||||||||
30320 | 30320 | William Dorn D000434 | rep | SC | 1957-01-03 | 1959-01-03 | Democrat | 3 | |||||||||||||
30321 | 30321 | William Dorn D000434 | rep | SC | 1959-01-07 | 1961-01-03 | Democrat | 3 | |||||||||||||
30322 | 30322 | William Dorn D000434 | rep | SC | 1961-01-03 | 1963-01-03 | Democrat | 3 | |||||||||||||
30323 | 30323 | William Dorn D000434 | rep | SC | 1963-01-09 | 1965-01-03 | Democrat | 3 | |||||||||||||
30324 | 30324 | William Dorn D000434 | rep | SC | 1965-01-04 | 1967-01-03 | Democrat | 3 | |||||||||||||
30325 | 30325 | William Dorn D000434 | rep | SC | 1967-01-10 | 1969-01-03 | Democrat | 3 | |||||||||||||
30326 | 30326 | William Dorn D000434 | rep | SC | 1969-01-03 | 1971-01-03 | Democrat | 3 | |||||||||||||
30327 | 30327 | William Dorn D000434 | rep | SC | 1971-01-21 | 1973-01-03 | Democrat | 3 | |||||||||||||
30328 | 30328 | William Dorn D000434 | rep | SC | 1973-01-03 | 1975-01-03 | Democrat | 3 | |||||||||||||
30329 | 30329 | Thaddeus Dulski D000523 | rep | NY | 1959-01-07 | 1961-01-03 | Democrat | 41 | |||||||||||||
30330 | 30330 | Thaddeus Dulski D000523 | rep | NY | 1961-01-03 | 1963-01-03 | Democrat | 41 | |||||||||||||
30331 | 30331 | Thaddeus Dulski D000523 | rep | NY | 1963-01-09 | 1965-01-03 | Democrat | 41 | |||||||||||||
30332 | 30332 | Thaddeus Dulski D000523 | rep | NY | 1965-01-04 | 1967-01-03 | Democrat | 41 | |||||||||||||
30333 | 30333 | Thaddeus Dulski D000523 | rep | NY | 1967-01-10 | 1969-01-03 | Democrat | 41 | |||||||||||||
30334 | 30334 | Thaddeus Dulski D000523 | rep | NY | 1969-01-03 | 1971-01-03 | Democrat | 41 | |||||||||||||
30335 | 30335 | Thaddeus Dulski D000523 | rep | NY | 1971-01-21 | 1973-01-03 | Democrat | 41 | |||||||||||||
30336 | 30336 | Thaddeus Dulski D000523 | rep | NY | 1973-01-03 | 1975-01-03 | Democrat | 37 | |||||||||||||
30337 | 30337 | James Eastland E000018 | sen | MS | 1941-06-30 | 1941-12-31 | 2 | Democrat | appointment | ||||||||||||
30338 | 30338 | James Eastland E000018 | sen | MS | 1943-01-06 | 1949-01-03 | 2 | Democrat | |||||||||||||
30339 | 30339 | James Eastland E000018 | sen | MS | 1949-01-03 | 1955-01-03 | 2 | Democrat |
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);