legislator_terms
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
482 rows where "start" is on date 1969-01-03 sorted by rowid descending
This data as json, copyable, CSV (advanced)
end (date) 8 ✖
- 1971-01-03 448
- 1975-01-03 28
- 1969-08-13 1
- 1974-01-03 1
- 1974-12-17 1
- 1974-12-20 1
- 1974-12-27 1
- 1974-12-31 1
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
40557 | 40557 | John Conyers C000714 | rep | MI | 1969-01-03 | 1971-01-03 | Democrat | 1 | |||||||||||||
39806 | 39806 | John Dingell D000355 | rep | MI | 1969-01-03 | 1971-01-03 | Democrat | 16 | |||||||||||||
39022 | 39022 | Daniel Inouye I000025 | sen | HI | 1969-01-03 | 1975-01-03 | 3 | Democrat | |||||||||||||
38730 | 38730 | David Obey O000007 | rep | WI | 1969-01-03 | 1971-01-03 | Democrat | 7 | |||||||||||||
37282 | 37282 | Philip Crane C000873 | rep | IL | 1969-01-03 | 1971-01-03 | Republican | 13 | |||||||||||||
37029 | 37029 | Patsy Mink M000797 | rep | HI | 1969-01-03 | 1971-01-03 | Democrat | 1 | |||||||||||||
36650 | 36650 | Ernest Hollings H000725 | sen | SC | 1969-01-03 | 1975-01-03 | 3 | Democrat | |||||||||||||
36557 | 36557 | William Clay C000488 | rep | MO | 1969-01-03 | 1971-01-03 | Democrat | 1 | |||||||||||||
36525 | 36525 | George Brown B000918 | rep | CA | 1969-01-03 | 1971-01-03 | Democrat | 29 | |||||||||||||
36457 | 36457 | Sidney Yates Y000013 | rep | IL | 1969-01-03 | 1971-01-03 | Democrat | 9 | |||||||||||||
36398 | 36398 | Louis Stokes S000948 | rep | OH | 1969-01-03 | 1971-01-03 | Democrat | 21 | |||||||||||||
36298 | 36298 | Joseph McDade M000399 | rep | PA | 1969-01-03 | 1971-01-03 | Republican | 10 | |||||||||||||
36230 | 36230 | Lee Hamilton H000114 | rep | IN | 1969-01-03 | 1971-01-03 | Democrat | 9 | |||||||||||||
36207 | 36207 | Henry González G000272 | rep | TX | 1969-01-03 | 1971-01-03 | Democrat | 20 | |||||||||||||
36118 | 36118 | Eligio de la Garza D000203 | rep | TX | 1969-01-03 | 1971-01-03 | Democrat | 15 | |||||||||||||
36018 | 36018 | William Roth R000460 | rep | DE | 1969-01-03 | 1971-01-03 | Republican | 0 | |||||||||||||
35978 | 35978 | James Quillen Q000013 | rep | TN | 1969-01-03 | 1971-01-03 | Republican | 1 | |||||||||||||
35950 | 35950 | John Myers M001130 | rep | IN | 1969-01-03 | 1971-01-03 | Republican | 7 | |||||||||||||
35919 | 35919 | Gillespie Montgomery M000865 | rep | MS | 1969-01-03 | 1971-01-03 | Democrat | 4 | |||||||||||||
35865 | 35865 | Andrew Jacobs J000033 | rep | IN | 1969-01-03 | 1971-01-03 | Democrat | 11 | |||||||||||||
35824 | 35824 | Sam Gibbons G000153 | rep | FL | 1969-01-03 | 1971-01-03 | Democrat | 6 | |||||||||||||
35694 | 35694 | Tom Bevill B000431 | rep | AL | 1969-01-03 | 1971-01-03 | Democrat | 7 | |||||||||||||
35656 | 35656 | Jamie Whitten W000428 | rep | MS | 1969-01-03 | 1971-01-03 | Democrat | 2 | |||||||||||||
35587 | 35587 | Neal Smith S000596 | rep | IA | 1969-01-03 | 1971-01-03 | Democrat | 5 | |||||||||||||
35539 | 35539 | Daniel Rostenkowski R000458 | rep | IL | 1969-01-03 | 1971-01-03 | Democrat | 8 | |||||||||||||
35511 | 35511 | James Pickle P000328 | rep | TX | 1969-01-03 | 1971-01-03 | Democrat | 10 | |||||||||||||
35488 | 35488 | Robert Packwood P000009 | sen | OR | 1969-01-03 | 1975-01-03 | 3 | Republican | |||||||||||||
35465 | 35465 | William Natcher N000009 | rep | KY | 1969-01-03 | 1971-01-03 | Democrat | 2 | |||||||||||||
35434 | 35434 | Robert Michel M000692 | rep | IL | 1969-01-03 | 1971-01-03 | Republican | 18 | |||||||||||||
35267 | 35267 | William Ford F000270 | rep | MI | 1969-01-03 | 1971-01-03 | Democrat | 15 | |||||||||||||
35247 | 35247 | Thomas Foley F000239 | rep | WA | 1969-01-03 | 1971-01-03 | Democrat | 5 | |||||||||||||
35232 | 35232 | Hamilton Fish F000141 | rep | NY | 1969-01-03 | 1971-01-03 | Republican | 28 | |||||||||||||
35202 | 35202 | William Edwards E000064 | rep | CA | 1969-01-03 | 1971-01-03 | Democrat | 9 | |||||||||||||
35194 | 35194 | Robert Dole D000401 | sen | KS | 1969-01-03 | 1975-01-03 | 3 | Republican | |||||||||||||
35143 | 35143 | Jack Brooks B000880 | rep | TX | 1969-01-03 | 1971-01-03 | Democrat | 9 | |||||||||||||
35078 | 35078 | Gus Yatron Y000014 | rep | PA | 1969-01-03 | 1971-01-03 | Democrat | 6 | |||||||||||||
35066 | 35066 | Chalmers Wylie W000781 | rep | OH | 1969-01-03 | 1971-01-03 | Republican | 15 | |||||||||||||
35031 | 35031 | Guy Vander Jagt V000027 | rep | MI | 1969-01-03 | 1971-01-03 | Republican | 9 | |||||||||||||
35017 | 35017 | Morris Udall U000001 | rep | AZ | 1969-01-03 | 1971-01-03 | Democrat | 2 | |||||||||||||
34930 | 34930 | James Scheuer S000124 | rep | NY | 1969-01-03 | 1971-01-03 | Democrat | 21 | |||||||||||||
34901 | 34901 | Edward Roybal R000485 | rep | CA | 1969-01-03 | 1971-01-03 | Democrat | 30 | |||||||||||||
34886 | 34886 | Robert Roe R000383 | rep | NJ | 1969-01-03 | 1971-01-03 | Democrat | 8 | |||||||||||||
34848 | 34848 | David Pryor P000556 | rep | AR | 1969-01-03 | 1971-01-03 | Democrat | 4 | |||||||||||||
34752 | 34752 | Clarence Miller M000718 | rep | OH | 1969-01-03 | 1971-01-03 | Republican | 10 | |||||||||||||
34622 | 34622 | Walter Jones J000256 | rep | NC | 1969-01-03 | 1971-01-03 | Democrat | 1 | |||||||||||||
34566 | 34566 | Frank Horton H000797 | rep | NY | 1969-01-03 | 1971-01-03 | Republican | 36 | |||||||||||||
34512 | 34512 | John Hammerschmidt H000124 | rep | AR | 1969-01-03 | 1971-01-03 | Republican | 3 | |||||||||||||
34471 | 34471 | Joseph Gaydos G000105 | rep | PA | 1969-01-03 | 1971-01-03 | Democrat | 20 | |||||||||||||
34449 | 34449 | Dante Fascell F000041 | rep | FL | 1969-01-03 | 1971-01-03 | Democrat | 12 | |||||||||||||
34371 | 34371 | William Dickinson D000326 | rep | AL | 1969-01-03 | 1971-01-03 | Republican | 2 | |||||||||||||
34342 | 34342 | Robert Coughlin C000807 | rep | PA | 1969-01-03 | 1971-01-03 | Republican | 13 | |||||||||||||
34330 | 34330 | Silvio Conte C000709 | rep | MA | 1969-01-03 | 1971-01-03 | Republican | 1 | |||||||||||||
34271 | 34271 | William Broomfield B000890 | rep | MI | 1969-01-03 | 1971-01-03 | Republican | 18 | |||||||||||||
34243 | 34243 | Charles Bennett B000371 | rep | FL | 1969-01-03 | 1971-01-03 | Democrat | 3 | |||||||||||||
34188 | 34188 | Frank Annunzio A000212 | rep | IL | 1969-01-03 | 1971-01-03 | Democrat | 7 | |||||||||||||
34174 | 34174 | Glenn Anderson A000189 | rep | CA | 1969-01-03 | 1971-01-03 | Democrat | 17 | |||||||||||||
34162 | 34162 | William Alexander A000103 | rep | AR | 1969-01-03 | 1971-01-03 | Democrat | 1 | |||||||||||||
34161 | 34161 | George Bush B001166 | rep | TX | 1969-01-03 | 1971-01-03 | Republican | 7 | |||||||||||||
34149 | 34149 | James Wright W000763 | rep | TX | 1969-01-03 | 1971-01-03 | Democrat | 12 | |||||||||||||
34064 | 34064 | Donald Riegle R000249 | rep | MI | 1969-01-03 | 1971-01-03 | Republican | 7 | |||||||||||||
34052 | 34052 | Claude Pepper P000218 | rep | FL | 1969-01-03 | 1971-01-03 | Democrat | 11 | |||||||||||||
34006 | 34006 | Spark Matsunaga M000250 | rep | HI | 1969-01-03 | 1971-01-03 | Democrat | 2 | |||||||||||||
33995 | 33995 | Donald Lukens L000509 | rep | OH | 1969-01-03 | 1971-01-03 | Republican | 24 | |||||||||||||
33963 | 33963 | Robert Kastenmeier K000020 | rep | WI | 1969-01-03 | 1971-01-03 | Democrat | 2 | |||||||||||||
33936 | 33936 | Augustus Hawkins H000367 | rep | CA | 1969-01-03 | 1971-01-03 | Democrat | 21 | |||||||||||||
33767 | 33767 | Samuel Stratton S000997 | rep | NY | 1969-01-03 | 1971-01-03 | Democrat | 35 | |||||||||||||
33752 | 33752 | Fernand St. Germain S000762 | rep | RI | 1969-01-03 | 1971-01-03 | Democrat | 1 | |||||||||||||
33731 | 33731 | Peter Rodino R000374 | rep | NJ | 1969-01-03 | 1971-01-03 | Democrat | 10 | |||||||||||||
33707 | 33707 | Charles Price P000522 | rep | IL | 1969-01-03 | 1971-01-03 | Democrat | 24 | |||||||||||||
33685 | 33685 | William Nichols N000095 | rep | AL | 1969-01-03 | 1971-01-03 | Democrat | 4 | |||||||||||||
33657 | 33657 | Manuel Luján L000506 | rep | NM | 1969-01-03 | 1971-01-03 | Republican | 1 | |||||||||||||
33642 | 33642 | Delbert Latta L000116 | rep | OH | 1969-01-03 | 1971-01-03 | Republican | 5 | |||||||||||||
33612 | 33612 | Ed Jones J000216 | rep | TN | 1969-01-03 | 1971-01-03 | Democrat | 8 | |||||||||||||
33602 | 33602 | James Howard H000840 | rep | NJ | 1969-01-03 | 1971-01-03 | Democrat | 3 | |||||||||||||
33595 | 33595 | Kenneth Gray G000400 | rep | IL | 1969-01-03 | 1971-01-03 | Democrat | 21 | |||||||||||||
33568 | 33568 | John Duncan D000534 | rep | TN | 1969-01-03 | 1971-01-03 | Republican | 2 | |||||||||||||
33543 | 33543 | Wilbur Daniel D000038 | rep | VA | 1969-01-03 | 1971-01-03 | Democrat | 5 | |||||||||||||
33539 | 33539 | Alan Cranston C000877 | sen | CA | 1969-01-03 | 1975-01-03 | 3 | Democrat | |||||||||||||
33529 | 33529 | William Chappell C000321 | rep | FL | 1969-01-03 | 1971-01-03 | Democrat | 4 | |||||||||||||
33502 | 33502 | Edward Boland B000600 | rep | MA | 1969-01-03 | 1971-01-03 | Democrat | 2 | |||||||||||||
33484 | 33484 | Mario Biaggi B000432 | rep | NY | 1969-01-03 | 1971-01-03 | Democrat | 24 | |||||||||||||
33472 | 33472 | Brockman Adams A000031 | rep | WA | 1969-01-03 | 1971-01-03 | Democrat | 7 | |||||||||||||
33460 | 33460 | James Broyhill B000966 | rep | NC | 1969-01-03 | 1971-01-03 | Republican | 10 | |||||||||||||
33434 | 33434 | George Whitehurst W000406 | rep | VA | 1969-01-03 | 1971-01-03 | Republican | 2 | |||||||||||||
33417 | 33417 | Marion Snyder S000669 | rep | KY | 1969-01-03 | 1971-01-03 | Republican | 4 | |||||||||||||
33390 | 33390 | Thomas O’Neill O000098 | rep | MA | 1969-01-03 | 1971-01-03 | Democrat | 8 | |||||||||||||
33353 | 33353 | James McClure M000346 | rep | ID | 1969-01-03 | 1971-01-03 | Republican | 1 | |||||||||||||
33273 | 33273 | Don Fuqua F000430 | rep | FL | 1969-01-03 | 1971-01-03 | Democrat | 2 | |||||||||||||
33216 | 33216 | Joseph Addabbo A000052 | rep | NY | 1969-01-03 | 1971-01-03 | Democrat | 7 | |||||||||||||
33201 | 33201 | Clement Zablocki Z000001 | rep | WI | 1969-01-03 | 1971-01-03 | Democrat | 4 | |||||||||||||
33177 | 33177 | Edward Winn W000636 | rep | KS | 1969-01-03 | 1971-01-03 | Republican | 3 | |||||||||||||
33169 | 33169 | Lowell Weicker W000253 | rep | CT | 1969-01-03 | 1971-01-03 | Republican | 4 | |||||||||||||
33150 | 33150 | Robert Stafford S000776 | rep | VT | 1969-01-03 | 1971-01-03 | Republican | 0 | |||||||||||||
33131 | 33131 | Benjamin Rosenthal R000442 | rep | NY | 1969-01-03 | 1971-01-03 | Democrat | 8 | |||||||||||||
33097 | 33097 | Carl Perkins P000230 | rep | KY | 1969-01-03 | 1971-01-03 | Democrat | 7 | |||||||||||||
33074 | 33074 | Richard Ottinger O000134 | rep | NY | 1969-01-03 | 1971-01-03 | Democrat | 25 | |||||||||||||
33064 | 33064 | Joseph Minish M000796 | rep | NJ | 1969-01-03 | 1971-01-03 | Democrat | 11 | |||||||||||||
33055 | 33055 | John Melcher M000635 | rep | MT | 1969-01-03 | 1971-01-03 | Democrat | 2 | |||||||||||||
33031 | 33031 | Clarence Long L000413 | rep | MD | 1969-01-03 | 1971-01-03 | Democrat | 2 | |||||||||||||
33012 | 33012 | Abraham Kazen K000025 | rep | TX | 1969-01-03 | 1971-01-03 | Democrat | 23 |
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);