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 state descending
This data as json, copyable, CSV (advanced)
Suggested facets: end, party, end (date)
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
29506 | 29506 | John Wold W000671 | rep | WY | 1969-01-03 | 1971-01-03 | Republican | 0 | |||||||||||||
29869 | 29869 | James Kee K000038 | rep | WV | 1969-01-03 | 1971-01-03 | Democrat | 5 | |||||||||||||
30994 | 30994 | Kenneth Hechler H000438 | rep | WV | 1969-01-03 | 1971-01-03 | Democrat | 4 | |||||||||||||
32288 | 32288 | John Slack S000473 | rep | WV | 1969-01-03 | 1971-01-03 | Democrat | 3 | |||||||||||||
32308 | 32308 | Harley Staggers S000778 | rep | WV | 1969-01-03 | 1971-01-03 | Democrat | 2 | |||||||||||||
32783 | 32783 | Robert Mollohan M000845 | rep | WV | 1969-01-03 | 1971-01-03 | Democrat | 1 | |||||||||||||
29329 | 29329 | Melvin Laird L000024 | rep | WI | 1969-01-03 | 1971-01-03 | Republican | 7 | |||||||||||||
29484 | 29484 | Henry Schadeberg S000108 | rep | WI | 1969-01-03 | 1971-01-03 | Republican | 1 | |||||||||||||
29662 | 29662 | John Byrnes B001216 | rep | WI | 1969-01-03 | 1971-01-03 | Republican | 8 | |||||||||||||
30003 | 30003 | Alvin O’Konski O000058 | rep | WI | 1969-01-03 | 1971-01-03 | Republican | 10 | |||||||||||||
30283 | 30283 | Glenn Davis D000102 | rep | WI | 1969-01-03 | 1971-01-03 | Republican | 9 | |||||||||||||
30730 | 30730 | Vernon Thomson T000233 | rep | WI | 1969-01-03 | 1971-01-03 | Republican | 3 | |||||||||||||
31226 | 31226 | Gaylord Nelson N000033 | sen | WI | 1969-01-03 | 1975-01-03 | 3 | Democrat | |||||||||||||
31841 | 31841 | William Steiger S000847 | rep | WI | 1969-01-03 | 1971-01-03 | Republican | 6 | |||||||||||||
32816 | 32816 | Henry Reuss R000165 | rep | WI | 1969-01-03 | 1971-01-03 | Democrat | 5 | |||||||||||||
33201 | 33201 | Clement Zablocki Z000001 | rep | WI | 1969-01-03 | 1971-01-03 | Democrat | 4 | |||||||||||||
33963 | 33963 | Robert Kastenmeier K000020 | rep | WI | 1969-01-03 | 1971-01-03 | Democrat | 2 | |||||||||||||
38730 | 38730 | David Obey O000007 | rep | WI | 1969-01-03 | 1971-01-03 | Democrat | 7 | |||||||||||||
29360 | 29360 | Catherine May M000273 | rep | WA | 1969-01-03 | 1971-01-03 | Republican | 4 | |||||||||||||
30018 | 30018 | Thomas Pelly P000196 | rep | WA | 1969-01-03 | 1971-01-03 | Republican | 1 | |||||||||||||
30459 | 30459 | Julia Hansen H000174 | rep | WA | 1969-01-03 | 1971-01-03 | Democrat | 3 | |||||||||||||
31014 | 31014 | Floyd Hicks H000563 | rep | WA | 1969-01-03 | 1971-01-03 | Democrat | 6 | |||||||||||||
31169 | 31169 | Warren Magnuson M000053 | sen | WA | 1969-01-03 | 1975-01-03 | 3 | Democrat | |||||||||||||
31661 | 31661 | Lloyd Meeds M000626 | rep | WA | 1969-01-03 | 1971-01-03 | Democrat | 2 | |||||||||||||
33472 | 33472 | Brockman Adams A000031 | rep | WA | 1969-01-03 | 1971-01-03 | Democrat | 7 | |||||||||||||
35247 | 35247 | Thomas Foley F000239 | rep | WA | 1969-01-03 | 1971-01-03 | Democrat | 5 | |||||||||||||
29118 | 29118 | George Aiken A000062 | sen | VT | 1969-01-03 | 1975-01-03 | 3 | Republican | |||||||||||||
33150 | 33150 | Robert Stafford S000776 | rep | VT | 1969-01-03 | 1971-01-03 | Republican | 0 | |||||||||||||
29354 | 29354 | John Marsh M000148 | rep | VA | 1969-01-03 | 1971-01-03 | Democrat | 7 | |||||||||||||
29522 | 29522 | Watkins Abbitt A000002 | rep | VA | 1969-01-03 | 1971-01-03 | Democrat | 4 | |||||||||||||
30035 | 30035 | Richard Poff P000401 | rep | VA | 1969-01-03 | 1971-01-03 | Republican | 6 | |||||||||||||
30210 | 30210 | Joel Broyhill B000967 | rep | VA | 1969-01-03 | 1971-01-03 | Republican | 10 | |||||||||||||
30684 | 30684 | William Scott S000189 | rep | VA | 1969-01-03 | 1971-01-03 | Republican | 8 | |||||||||||||
30906 | 30906 | Thomas Downing D000474 | rep | VA | 1969-01-03 | 1971-01-03 | Democrat | 1 | |||||||||||||
32271 | 32271 | David Satterfield S000070 | rep | VA | 1969-01-03 | 1971-01-03 | Democrat | 3 | |||||||||||||
32873 | 32873 | William Wampler W000121 | rep | VA | 1969-01-03 | 1971-01-03 | Republican | 9 | |||||||||||||
33434 | 33434 | George Whitehurst W000406 | rep | VA | 1969-01-03 | 1971-01-03 | Republican | 2 | |||||||||||||
33543 | 33543 | Wilbur Daniel D000038 | rep | VA | 1969-01-03 | 1971-01-03 | Democrat | 5 | |||||||||||||
29148 | 29148 | Wallace Bennett B000384 | sen | UT | 1969-01-03 | 1974-12-20 | 3 | Republican | |||||||||||||
29166 | 29166 | Laurence Burton B001155 | rep | UT | 1969-01-03 | 1971-01-03 | Republican | 1 | |||||||||||||
29896 | 29896 | Sherman Lloyd L000382 | rep | UT | 1969-01-03 | 1971-01-03 | Republican | 2 | |||||||||||||
29666 | 29666 | Earle Cabell C000002 | rep | TX | 1969-01-03 | 1971-01-03 | Democrat | 5 | |||||||||||||
29747 | 29747 | John Dowdy D000467 | rep | TX | 1969-01-03 | 1971-01-03 | Democrat | 2 | |||||||||||||
30048 | 30048 | Graham Purcell P000569 | rep | TX | 1969-01-03 | 1971-01-03 | Democrat | 13 | |||||||||||||
30357 | 30357 | Ovie Fisher F000152 | rep | TX | 1969-01-03 | 1971-01-03 | Democrat | 21 | |||||||||||||
30618 | 30618 | Robert Price P000528 | rep | TX | 1969-01-03 | 1971-01-03 | Republican | 18 | |||||||||||||
30860 | 30860 | Robert Casey C000228 | rep | TX | 1969-01-03 | 1971-01-03 | Democrat | 22 | |||||||||||||
31272 | 31272 | John Patman P000103 | rep | TX | 1969-01-03 | 1971-01-03 | Democrat | 1 | |||||||||||||
31464 | 31464 | Omar Burleson B001111 | rep | TX | 1969-01-03 | 1971-01-03 | Democrat | 17 | |||||||||||||
31638 | 31638 | George Mahon M000065 | rep | TX | 1969-01-03 | 1971-01-03 | Democrat | 19 | |||||||||||||
31734 | 31734 | William Poage P000398 | rep | TX | 1969-01-03 | 1971-01-03 | Democrat | 11 | |||||||||||||
31858 | 31858 | Olin Teague T000110 | rep | TX | 1969-01-03 | 1971-01-03 | Democrat | 6 | |||||||||||||
31908 | 31908 | John Young Y000043 | rep | TX | 1969-01-03 | 1971-01-03 | Democrat | 14 | |||||||||||||
32050 | 32050 | Robert Eckhardt E000035 | rep | TX | 1969-01-03 | 1971-01-03 | Democrat | 8 | |||||||||||||
32257 | 32257 | Herbert Roberts R000312 | rep | TX | 1969-01-03 | 1971-01-03 | Democrat | 4 | |||||||||||||
32567 | 32567 | James Collins C000638 | rep | TX | 1969-01-03 | 1971-01-03 | Republican | 3 | |||||||||||||
32883 | 32883 | Richard White W000390 | rep | TX | 1969-01-03 | 1971-01-03 | Democrat | 16 | |||||||||||||
33012 | 33012 | Abraham Kazen K000025 | rep | TX | 1969-01-03 | 1971-01-03 | Democrat | 23 | |||||||||||||
34149 | 34149 | James Wright W000763 | rep | TX | 1969-01-03 | 1971-01-03 | Democrat | 12 | |||||||||||||
34161 | 34161 | George Bush B001166 | rep | TX | 1969-01-03 | 1971-01-03 | Republican | 7 | |||||||||||||
35143 | 35143 | Jack Brooks B000880 | rep | TX | 1969-01-03 | 1971-01-03 | Democrat | 9 | |||||||||||||
35511 | 35511 | James Pickle P000328 | rep | TX | 1969-01-03 | 1971-01-03 | Democrat | 10 | |||||||||||||
36118 | 36118 | Eligio de la Garza D000203 | rep | TX | 1969-01-03 | 1971-01-03 | Democrat | 15 | |||||||||||||
36207 | 36207 | Henry González G000272 | rep | TX | 1969-01-03 | 1971-01-03 | Democrat | 20 | |||||||||||||
29234 | 29234 | Robert Everett E000266 | rep | TN | 1969-01-03 | 1971-01-03 | Democrat | 8 | |||||||||||||
29541 | 29541 | William Anderson A000203 | rep | TN | 1969-01-03 | 1971-01-03 | Democrat | 6 | |||||||||||||
29607 | 29607 | Leonard Blanton B000548 | rep | TN | 1969-01-03 | 1971-01-03 | Democrat | 7 | |||||||||||||
29637 | 29637 | William Brock B000851 | rep | TN | 1969-01-03 | 1971-01-03 | Republican | 3 | |||||||||||||
30524 | 30524 | Dan Kuykendall K000348 | rep | TN | 1969-01-03 | 1971-01-03 | Republican | 9 | |||||||||||||
30932 | 30932 | Joseph Evins E000273 | rep | TN | 1969-01-03 | 1971-01-03 | Democrat | 4 | |||||||||||||
30939 | 30939 | Richard Fulton F000424 | rep | TN | 1969-01-03 | 1971-01-03 | Democrat | 5 | |||||||||||||
33568 | 33568 | John Duncan D000534 | rep | TN | 1969-01-03 | 1971-01-03 | Republican | 2 | |||||||||||||
33612 | 33612 | Ed Jones J000216 | rep | TN | 1969-01-03 | 1971-01-03 | Democrat | 8 | |||||||||||||
35978 | 35978 | James Quillen Q000013 | rep | TN | 1969-01-03 | 1971-01-03 | Republican | 1 | |||||||||||||
29158 | 29158 | Ellis Berry B000416 | rep | SD | 1969-01-03 | 1971-01-03 | Republican | 2 | |||||||||||||
29439 | 29439 | Benjamin Reifel R000152 | rep | SD | 1969-01-03 | 1971-01-03 | Republican | 1 | |||||||||||||
31177 | 31177 | George McGovern M000452 | sen | SD | 1969-01-03 | 1975-01-03 | 3 | Democrat | |||||||||||||
29457 | 29457 | Lucius Rivers R000280 | rep | SC | 1969-01-03 | 1971-01-03 | Democrat | 1 | |||||||||||||
29505 | 29505 | Albert Watson W000197 | rep | SC | 1969-01-03 | 1971-01-03 | Republican | 2 | |||||||||||||
29946 | 29946 | John McMillan M000568 | rep | SC | 1969-01-03 | 1971-01-03 | Democrat | 6 | |||||||||||||
30326 | 30326 | William Dorn D000434 | rep | SC | 1969-01-03 | 1971-01-03 | Democrat | 3 | |||||||||||||
30375 | 30375 | Thomas Gettys G000144 | rep | SC | 1969-01-03 | 1971-01-03 | Democrat | 5 | |||||||||||||
31643 | 31643 | James Mann M000105 | rep | SC | 1969-01-03 | 1971-01-03 | Democrat | 4 | |||||||||||||
36650 | 36650 | Ernest Hollings H000725 | sen | SC | 1969-01-03 | 1975-01-03 | 3 | Democrat | |||||||||||||
30734 | 30734 | Robert Tiernan T000265 | rep | RI | 1969-01-03 | 1971-01-03 | Democrat | 2 | |||||||||||||
33752 | 33752 | Fernand St. Germain S000762 | rep | RI | 1969-01-03 | 1971-01-03 | Democrat | 1 | |||||||||||||
29733 | 29733 | Jorge Córdova Díaz C000775 | rep | PR | 1969-01-03 | 1971-01-03 | New Progressive | 0 | |||||||||||||
29501 | 29501 | George Watkins W000192 | rep | PA | 1969-01-03 | 1971-01-03 | Republican | 9 | |||||||||||||
29648 | 29648 | James Byrne B001212 | rep | PA | 1969-01-03 | 1971-01-03 | Democrat | 3 | |||||||||||||
29730 | 29730 | Robert Corbett C000772 | rep | PA | 1969-01-03 | 1971-01-03 | Republican | 18 | |||||||||||||
29788 | 29788 | James Fulton F000422 | rep | PA | 1969-01-03 | 1971-01-03 | Republican | 27 | |||||||||||||
30133 | 30133 | John Whalley W000320 | rep | PA | 1969-01-03 | 1971-01-03 | Republican | 12 | |||||||||||||
30248 | 30248 | Frank Clark C000431 | rep | PA | 1969-01-03 | 1971-01-03 | Democrat | 25 | |||||||||||||
30381 | 30381 | George Goodling G000290 | rep | PA | 1969-01-03 | 1971-01-03 | Republican | 19 | |||||||||||||
30676 | 30676 | John Saylor S000102 | rep | PA | 1969-01-03 | 1971-01-03 | Republican | 22 | |||||||||||||
30745 | 30745 | John Ware W000147 | rep | PA | 1969-01-03 | 1971-01-03 | Republican | 9 | |||||||||||||
30762 | 30762 | Lawrence Williams W000525 | rep | PA | 1969-01-03 | 1971-01-03 | Republican | 7 | |||||||||||||
30831 | 30831 | William Barrett B000178 | rep | PA | 1969-01-03 | 1971-01-03 | Democrat | 1 | |||||||||||||
30851 | 30851 | Edward Biester B000451 | rep | PA | 1969-01-03 | 1971-01-03 | Republican | 8 | |||||||||||||
30917 | 30917 | Edwin Eshleman E000214 | rep | PA | 1969-01-03 | 1971-01-03 | Republican | 16 |
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);