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 ✖
- 1971-01-03 483
- 1983-01-03 481
- 1977-01-03 480
- 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
- 1989-01-03 475
- 1993-01-03 475
- 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
- 2003-01-03 471
- 2007-01-03 471
- 2013-01-03 470
- 2019-01-03 470
- 2021-01-03 469
- 1967-01-03 464
- 1969-01-03 462
- 1965-01-03 382
- …
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
28371 | 28371 | Frank Chelf C000342 | rep | KY | 1965-01-04 | 1967-01-03 | Democrat | 4 | |||||||||||||
28372 | 28372 | Raymond Clevenger C000516 | rep | MI | 1965-01-04 | 1967-01-03 | Democrat | 11 | |||||||||||||
28373 | 28373 | Harold Cooley C000736 | rep | NC | 1933-03-09 | 1935-01-03 | Democrat | 4 | |||||||||||||
28374 | 28374 | Harold Cooley C000736 | rep | NC | 1935-01-03 | 1937-01-03 | Democrat | 4 | |||||||||||||
28375 | 28375 | Harold Cooley C000736 | rep | NC | 1937-01-05 | 1939-01-03 | Democrat | 4 | |||||||||||||
28376 | 28376 | Harold Cooley C000736 | rep | NC | 1939-01-03 | 1941-01-03 | Democrat | 4 | |||||||||||||
28377 | 28377 | Harold Cooley C000736 | rep | NC | 1941-01-03 | 1943-01-03 | Democrat | 4 | |||||||||||||
28378 | 28378 | Harold Cooley C000736 | rep | NC | 1943-01-06 | 1945-01-03 | Democrat | 4 | |||||||||||||
28379 | 28379 | Harold Cooley C000736 | rep | NC | 1945-01-03 | 1947-01-03 | Democrat | 4 | |||||||||||||
28380 | 28380 | Harold Cooley C000736 | rep | NC | 1947-01-03 | 1949-01-03 | Democrat | 4 | |||||||||||||
28381 | 28381 | Harold Cooley C000736 | rep | NC | 1949-01-03 | 1951-01-03 | Democrat | 4 | |||||||||||||
28382 | 28382 | Harold Cooley C000736 | rep | NC | 1951-01-03 | 1953-01-03 | Democrat | 4 | |||||||||||||
28383 | 28383 | Harold Cooley C000736 | rep | NC | 1953-01-03 | 1955-01-03 | Democrat | 4 | |||||||||||||
28384 | 28384 | Harold Cooley C000736 | rep | NC | 1955-01-05 | 1957-01-03 | Democrat | 4 | |||||||||||||
28385 | 28385 | Harold Cooley C000736 | rep | NC | 1957-01-03 | 1959-01-03 | Democrat | 4 | |||||||||||||
28386 | 28386 | Harold Cooley C000736 | rep | NC | 1959-01-07 | 1961-01-03 | Democrat | 4 | |||||||||||||
28387 | 28387 | Harold Cooley C000736 | rep | NC | 1961-01-03 | 1963-01-03 | Democrat | 4 | |||||||||||||
28388 | 28388 | Harold Cooley C000736 | rep | NC | 1963-01-09 | 1965-01-03 | Democrat | 4 | |||||||||||||
28389 | 28389 | Harold Cooley C000736 | rep | NC | 1965-01-04 | 1967-01-03 | Democrat | 4 | |||||||||||||
28390 | 28390 | Nathaniel Craley C000866 | rep | PA | 1965-01-04 | 1967-01-03 | Democrat | 19 | |||||||||||||
28391 | 28391 | Willard Curtin C001005 | rep | PA | 1957-01-03 | 1959-01-03 | Republican | 8 | |||||||||||||
28392 | 28392 | Willard Curtin C001005 | rep | PA | 1959-01-07 | 1961-01-03 | Republican | 8 | |||||||||||||
28393 | 28393 | Willard Curtin C001005 | rep | PA | 1961-01-03 | 1963-01-03 | Republican | 8 | |||||||||||||
28394 | 28394 | Willard Curtin C001005 | rep | PA | 1963-01-09 | 1965-01-03 | Republican | 8 | |||||||||||||
28395 | 28395 | Willard Curtin C001005 | rep | PA | 1965-01-04 | 1967-01-03 | Republican | 8 | |||||||||||||
28396 | 28396 | Paul Dague D000004 | rep | PA | 1947-01-03 | 1949-01-03 | Republican | 9 | |||||||||||||
28397 | 28397 | Paul Dague D000004 | rep | PA | 1949-01-03 | 1951-01-03 | Republican | 9 | |||||||||||||
28398 | 28398 | Paul Dague D000004 | rep | PA | 1951-01-03 | 1953-01-03 | Republican | 9 | |||||||||||||
28399 | 28399 | Paul Dague D000004 | rep | PA | 1953-01-03 | 1955-01-03 | Republican | 9 | |||||||||||||
28400 | 28400 | Paul Dague D000004 | rep | PA | 1955-01-05 | 1957-01-03 | Republican | 9 | |||||||||||||
28401 | 28401 | Paul Dague D000004 | rep | PA | 1957-01-03 | 1959-01-03 | Republican | 9 | |||||||||||||
28402 | 28402 | Paul Dague D000004 | rep | PA | 1959-01-07 | 1961-01-03 | Republican | 9 | |||||||||||||
28403 | 28403 | Paul Dague D000004 | rep | PA | 1961-01-03 | 1963-01-03 | Republican | 9 | |||||||||||||
28404 | 28404 | Paul Dague D000004 | rep | PA | 1963-01-09 | 1965-01-03 | Republican | 9 | |||||||||||||
28405 | 28405 | Paul Dague D000004 | rep | PA | 1965-01-04 | 1967-01-03 | Republican | 9 | |||||||||||||
28406 | 28406 | Winfield Denton D000260 | rep | IN | 1949-01-03 | 1951-01-03 | Democrat | 8 | |||||||||||||
28407 | 28407 | Winfield Denton D000260 | rep | IN | 1951-01-03 | 1953-01-03 | Democrat | 8 | |||||||||||||
28408 | 28408 | Winfield Denton D000260 | rep | IN | 1955-01-05 | 1957-01-03 | Democrat | 8 | |||||||||||||
28409 | 28409 | Winfield Denton D000260 | rep | IN | 1957-01-03 | 1959-01-03 | Democrat | 8 | |||||||||||||
28410 | 28410 | Winfield Denton D000260 | rep | IN | 1959-01-07 | 1961-01-03 | Democrat | 8 | |||||||||||||
28411 | 28411 | Winfield Denton D000260 | rep | IN | 1961-01-03 | 1963-01-03 | Democrat | 8 | |||||||||||||
28412 | 28412 | Winfield Denton D000260 | rep | IN | 1963-01-09 | 1965-01-03 | Democrat | 8 | |||||||||||||
28413 | 28413 | Winfield Denton D000260 | rep | IN | 1965-01-04 | 1967-01-03 | Democrat | 8 | |||||||||||||
28414 | 28414 | Thomas Dodd D000390 | rep | CT | 1953-01-03 | 1955-01-03 | Democrat | 1 | |||||||||||||
28415 | 28415 | Thomas Dodd D000390 | rep | CT | 1955-01-05 | 1957-01-03 | Democrat | 1 | |||||||||||||
28416 | 28416 | Thomas Dodd D000390 | sen | CT | 1959-01-07 | 1965-01-03 | 1 | Democrat | |||||||||||||
28417 | 28417 | Thomas Dodd D000390 | sen | CT | 1965-01-04 | 1971-01-03 | 1 | Democrat | |||||||||||||
28418 | 28418 | Kenneth Dyal D000588 | rep | CA | 1965-01-04 | 1967-01-03 | Democrat | 33 | |||||||||||||
28419 | 28419 | Robert Ellsworth E000148 | rep | KS | 1961-01-03 | 1963-01-03 | Republican | 2 | |||||||||||||
28420 | 28420 | Robert Ellsworth E000148 | rep | KS | 1963-01-09 | 1965-01-03 | Republican | 3 | |||||||||||||
28421 | 28421 | Robert Ellsworth E000148 | rep | KS | 1965-01-04 | 1967-01-03 | Republican | 3 | |||||||||||||
28422 | 28422 | Charles Farnsley F000023 | rep | KY | 1965-01-04 | 1967-01-03 | Democrat | 3 | |||||||||||||
28423 | 28423 | Billie Farnum F000025 | rep | MI | 1965-01-04 | 1967-01-03 | Democrat | 19 | |||||||||||||
28424 | 28424 | John Gilligan G000208 | rep | OH | 1965-01-04 | 1967-01-03 | Democrat | 1 | |||||||||||||
28425 | 28425 | Albert Gore G000320 | rep | TN | 1939-01-03 | 1941-01-03 | Democrat | 4 | |||||||||||||
28426 | 28426 | Albert Gore G000320 | rep | TN | 1941-01-03 | 1943-01-03 | Democrat | 4 | |||||||||||||
28427 | 28427 | Albert Gore G000320 | rep | TN | 1943-01-06 | 1945-01-03 | Democrat | 4 | |||||||||||||
28428 | 28428 | Albert Gore G000320 | rep | TN | 1945-01-03 | 1947-01-03 | Democrat | 4 | |||||||||||||
28429 | 28429 | Albert Gore G000320 | rep | TN | 1947-01-03 | 1949-01-03 | Democrat | 4 | |||||||||||||
28430 | 28430 | Albert Gore G000320 | rep | TN | 1949-01-03 | 1951-01-03 | Democrat | 4 | |||||||||||||
28431 | 28431 | Albert Gore G000320 | rep | TN | 1951-01-03 | 1953-01-03 | Democrat | 4 | |||||||||||||
28432 | 28432 | Albert Gore G000320 | sen | TN | 1953-01-03 | 1959-01-03 | 1 | Democrat | |||||||||||||
28433 | 28433 | Albert Gore G000320 | sen | TN | 1959-01-07 | 1965-01-03 | 1 | Democrat | |||||||||||||
28434 | 28434 | Albert Gore G000320 | sen | TN | 1965-01-04 | 1971-01-03 | 1 | Democrat | |||||||||||||
28435 | 28435 | Bernard Grabowski G000348 | rep | CT | 1963-01-09 | 1965-01-03 | Democrat | 0 | |||||||||||||
28436 | 28436 | Bernard Grabowski G000348 | rep | CT | 1965-01-04 | 1967-01-03 | Democrat | 6 | |||||||||||||
28437 | 28437 | Stanley Greigg G000450 | rep | IA | 1965-01-04 | 1967-01-03 | Democrat | 6 | |||||||||||||
28438 | 28438 | George Grider G000454 | rep | TN | 1965-01-04 | 1967-01-03 | Democrat | 9 | |||||||||||||
28439 | 28439 | Harlan Hagen H000013 | rep | CA | 1953-01-03 | 1955-01-03 | Democrat | 14 | |||||||||||||
28440 | 28440 | Harlan Hagen H000013 | rep | CA | 1955-01-05 | 1957-01-03 | Democrat | 14 | |||||||||||||
28441 | 28441 | Harlan Hagen H000013 | rep | CA | 1957-01-03 | 1959-01-03 | Democrat | 14 | |||||||||||||
28442 | 28442 | Harlan Hagen H000013 | rep | CA | 1959-01-07 | 1961-01-03 | Democrat | 14 | |||||||||||||
28443 | 28443 | Harlan Hagen H000013 | rep | CA | 1961-01-03 | 1963-01-03 | Democrat | 14 | |||||||||||||
28444 | 28444 | Harlan Hagen H000013 | rep | CA | 1963-01-09 | 1965-01-03 | Democrat | 18 | |||||||||||||
28445 | 28445 | Harlan Hagen H000013 | rep | CA | 1965-01-04 | 1967-01-03 | Democrat | 18 | |||||||||||||
28446 | 28446 | John Hansen H000173 | rep | IA | 1965-01-04 | 1967-01-03 | Democrat | 7 | |||||||||||||
28447 | 28447 | Oren Harris H000249 | rep | AR | 1941-01-03 | 1943-01-03 | Democrat | 7 | |||||||||||||
28448 | 28448 | Oren Harris H000249 | rep | AR | 1943-01-06 | 1945-01-03 | Democrat | 7 | |||||||||||||
28449 | 28449 | Oren Harris H000249 | rep | AR | 1945-01-03 | 1947-01-03 | Democrat | 7 | |||||||||||||
28450 | 28450 | Oren Harris H000249 | rep | AR | 1947-01-03 | 1949-01-03 | Democrat | 7 | |||||||||||||
28451 | 28451 | Oren Harris H000249 | rep | AR | 1949-01-03 | 1951-01-03 | Democrat | 7 | |||||||||||||
28452 | 28452 | Oren Harris H000249 | rep | AR | 1951-01-03 | 1953-01-03 | Democrat | 7 | |||||||||||||
28453 | 28453 | Oren Harris H000249 | rep | AR | 1953-01-03 | 1955-01-03 | Democrat | 4 | |||||||||||||
28454 | 28454 | Oren Harris H000249 | rep | AR | 1955-01-05 | 1957-01-03 | Democrat | 4 | |||||||||||||
28455 | 28455 | Oren Harris H000249 | rep | AR | 1957-01-03 | 1959-01-03 | Democrat | 4 | |||||||||||||
28456 | 28456 | Oren Harris H000249 | rep | AR | 1959-01-07 | 1961-01-03 | Democrat | 4 | |||||||||||||
28457 | 28457 | Oren Harris H000249 | rep | AR | 1961-01-03 | 1963-01-03 | Democrat | 4 | |||||||||||||
28458 | 28458 | Oren Harris H000249 | rep | AR | 1963-01-09 | 1965-01-03 | Democrat | 4 | |||||||||||||
28459 | 28459 | Oren Harris H000249 | rep | AR | 1965-01-04 | 1967-01-03 | Democrat | 4 | |||||||||||||
28460 | 28460 | Ralph Harvey H000310 | rep | IN | 1947-01-03 | 1949-01-03 | Republican | 10 | |||||||||||||
28461 | 28461 | Ralph Harvey H000310 | rep | IN | 1949-01-03 | 1951-01-03 | Republican | 10 | |||||||||||||
28462 | 28462 | Ralph Harvey H000310 | rep | IN | 1951-01-03 | 1953-01-03 | Republican | 10 | |||||||||||||
28463 | 28463 | Ralph Harvey H000310 | rep | IN | 1953-01-03 | 1955-01-03 | Republican | 10 | |||||||||||||
28464 | 28464 | Ralph Harvey H000310 | rep | IN | 1955-01-05 | 1957-01-03 | Republican | 10 | |||||||||||||
28465 | 28465 | Ralph Harvey H000310 | rep | IN | 1957-01-03 | 1959-01-03 | Republican | 10 | |||||||||||||
28466 | 28466 | Ralph Harvey H000310 | rep | IN | 1961-01-03 | 1963-01-03 | Republican | 10 | |||||||||||||
28467 | 28467 | Ralph Harvey H000310 | rep | IN | 1963-01-09 | 1965-01-03 | Republican | 10 | |||||||||||||
28468 | 28468 | Ralph Harvey H000310 | rep | IN | 1965-01-04 | 1967-01-03 | Republican | 10 | |||||||||||||
28469 | 28469 | Spessard Holland H000720 | sen | FL | 1946-09-25 | 1947-01-03 | 1 | Democrat | appointment | ||||||||||||
28470 | 28470 | Spessard Holland H000720 | sen | FL | 1947-01-03 | 1953-01-03 | 1 | 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);