legislator_terms
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
478 rows where "start" is on date 1971-01-21 sorted by legislator_id 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
30779 | 30779 | John Zwach Z000016 | rep | MN | 1971-01-21 | 1973-01-03 | Republican | 6 | |||||||||||||
30775 | 30775 | Roger Zion Z000010 | rep | IN | 1971-01-21 | 1973-01-03 | Republican | 8 | |||||||||||||
33202 | 33202 | Clement Zablocki Z000001 | rep | WI | 1971-01-21 | 1973-01-03 | Democrat | 4 | |||||||||||||
31909 | 31909 | John Young Y000043 | rep | TX | 1971-01-21 | 1973-01-03 | Democrat | 14 | |||||||||||||
39622 | 39622 | C. Young Y000031 | rep | FL | 1971-01-21 | 1973-01-03 | Republican | 8 | |||||||||||||
35079 | 35079 | Gus Yatron Y000014 | rep | PA | 1971-01-21 | 1973-01-03 | Democrat | 6 | |||||||||||||
36458 | 36458 | Sidney Yates Y000013 | rep | IL | 1971-01-21 | 1973-01-03 | Democrat | 9 | |||||||||||||
30784 | 30784 | Louis Wyman W000782 | rep | NH | 1971-01-21 | 1973-01-03 | Republican | 1 | |||||||||||||
35067 | 35067 | Chalmers Wylie W000781 | rep | OH | 1971-01-21 | 1973-01-03 | Republican | 15 | |||||||||||||
32425 | 32425 | John Wydler W000780 | rep | NY | 1971-01-21 | 1973-01-03 | Republican | 4 | |||||||||||||
30769 | 30769 | Wendell Wyatt W000778 | rep | OR | 1971-01-21 | 1973-01-03 | Republican | 1 | |||||||||||||
34150 | 34150 | James Wright W000763 | rep | TX | 1971-01-21 | 1973-01-03 | Democrat | 12 | |||||||||||||
32415 | 32415 | Lester Wolff W000680 | rep | NY | 1971-01-21 | 1973-01-03 | Democrat | 3 | |||||||||||||
33178 | 33178 | Edward Winn W000636 | rep | KS | 1971-01-21 | 1973-01-03 | Republican | 3 | |||||||||||||
32407 | 32407 | Robert Wilson W000610 | rep | CA | 1971-01-21 | 1973-01-03 | Republican | 36 | |||||||||||||
32393 | 32393 | Charles Wilson W000571 | rep | CA | 1971-01-21 | 1973-01-03 | Democrat | 31 | |||||||||||||
30763 | 30763 | Lawrence Williams W000525 | rep | PA | 1971-01-21 | 1973-01-03 | Republican | 7 | |||||||||||||
31897 | 31897 | Harrison Williams W000502 | sen | NJ | 1971-01-21 | 1977-01-03 | 1 | Democrat | |||||||||||||
31889 | 31889 | Charles Wiggins W000448 | rep | CA | 1971-01-21 | 1973-01-03 | Republican | 25 | |||||||||||||
30759 | 30759 | William Widnall W000445 | rep | NJ | 1971-01-21 | 1973-01-03 | Republican | 7 | |||||||||||||
35657 | 35657 | Jamie Whitten W000428 | rep | MS | 1971-01-21 | 1973-01-03 | Democrat | 2 | |||||||||||||
33435 | 33435 | George Whitehurst W000406 | rep | VA | 1971-01-21 | 1973-01-03 | Republican | 2 | |||||||||||||
32884 | 32884 | Richard White W000390 | rep | TX | 1971-01-21 | 1973-01-03 | Democrat | 16 | |||||||||||||
30134 | 30134 | John Whalley W000320 | rep | PA | 1971-01-21 | 1973-01-03 | Republican | 12 | |||||||||||||
31883 | 31883 | Charles Whalen W000317 | rep | OH | 1971-01-21 | 1973-01-03 | Republican | 3 | |||||||||||||
33170 | 33170 | Lowell Weicker W000253 | sen | CT | 1971-01-21 | 1977-01-03 | 1 | Republican | |||||||||||||
30127 | 30127 | John Watts W000212 | rep | KY | 1971-01-21 | 1973-01-03 | Democrat | 6 | |||||||||||||
30746 | 30746 | John Ware W000147 | rep | PA | 1971-01-21 | 1973-01-03 | Republican | 9 | |||||||||||||
32874 | 32874 | William Wampler W000121 | rep | VA | 1971-01-21 | 1973-01-03 | Republican | 9 | |||||||||||||
30743 | 30743 | Jerome Waldie W000035 | rep | CA | 1971-01-21 | 1973-01-03 | Democrat | 14 | |||||||||||||
31874 | 31874 | Joseph Waggonner W000018 | rep | LA | 1971-01-21 | 1973-01-03 | Democrat | 4 | |||||||||||||
31399 | 31399 | Joseph Vigorito V000098 | rep | PA | 1971-01-21 | 1973-01-03 | Democrat | 24 | |||||||||||||
30738 | 30738 | Victor Veysey V000093 | rep | CA | 1971-01-21 | 1973-01-03 | Republican | 38 | |||||||||||||
32384 | 32384 | Charles Vanik V000047 | rep | OH | 1971-01-21 | 1973-01-03 | Democrat | 22 | |||||||||||||
35032 | 35032 | Guy Vander Jagt V000027 | rep | MI | 1971-01-21 | 1973-01-03 | Republican | 9 | |||||||||||||
32371 | 32371 | Lionel Van Deerlin V000024 | rep | CA | 1971-01-21 | 1973-01-03 | Democrat | 37 | |||||||||||||
32362 | 32362 | Albert Ullman U000004 | rep | OR | 1971-01-21 | 1973-01-03 | Democrat | 2 | |||||||||||||
35018 | 35018 | Morris Udall U000001 | rep | AZ | 1971-01-21 | 1973-01-03 | Democrat | 2 | |||||||||||||
30116 | 30116 | John Tunney T000410 | sen | CA | 1971-01-21 | 1977-01-03 | 1 | Democrat | |||||||||||||
30735 | 30735 | Robert Tiernan T000265 | rep | RI | 1971-01-21 | 1973-01-03 | Democrat | 2 | |||||||||||||
31863 | 31863 | Charles Thone T000234 | rep | NE | 1971-01-21 | 1973-01-03 | Republican | 1 | |||||||||||||
30731 | 30731 | Vernon Thomson T000233 | rep | WI | 1971-01-21 | 1973-01-03 | Republican | 3 | |||||||||||||
30112 | 30112 | Standish Thompson T000217 | rep | GA | 1971-01-21 | 1973-01-03 | Republican | 5 | |||||||||||||
32339 | 32339 | Frank Thompson T000200 | rep | NJ | 1971-01-21 | 1973-01-03 | Democrat | 4 | |||||||||||||
30109 | 30109 | John Terry T000134 | rep | NY | 1971-01-21 | 1973-01-03 | Republican | 34 | |||||||||||||
31859 | 31859 | Olin Teague T000110 | rep | TX | 1971-01-21 | 1973-01-03 | Democrat | 6 | |||||||||||||
30724 | 30724 | Charles Teague T000109 | rep | CA | 1971-01-21 | 1973-01-03 | Republican | 13 | |||||||||||||
31391 | 31391 | Roy Taylor T000099 | rep | NC | 1971-01-21 | 1973-01-03 | Democrat | 11 | |||||||||||||
31378 | 31378 | Burt Talcott T000022 | rep | CA | 1971-01-21 | 1973-01-03 | Republican | 12 | |||||||||||||
30108 | 30108 | Robert Taft T000010 | sen | OH | 1971-01-21 | 1976-12-28 | 1 | Republican | |||||||||||||
30104 | 30104 | William Symington S001136 | sen | MO | 1971-01-21 | 1976-12-27 | 1 | Democrat | |||||||||||||
31371 | 31371 | James Symington S001134 | rep | MO | 1971-01-21 | 1973-01-03 | Democrat | 2 | |||||||||||||
31367 | 31367 | Leonor Sullivan S001057 | rep | MO | 1971-01-21 | 1973-01-03 | Democrat | 3 | |||||||||||||
31355 | 31355 | Williamson Stuckey S001039 | rep | GA | 1971-01-21 | 1973-01-03 | Democrat | 8 | |||||||||||||
30714 | 30714 | Frank Stubblefield S001037 | rep | KY | 1971-01-21 | 1973-01-03 | Democrat | 1 | |||||||||||||
33768 | 33768 | Samuel Stratton S000997 | rep | NY | 1971-01-21 | 1973-01-03 | Democrat | 29 | |||||||||||||
36399 | 36399 | Louis Stokes S000948 | rep | OH | 1971-01-21 | 1973-01-03 | Democrat | 21 | |||||||||||||
31347 | 31347 | Robert Stephens S000860 | rep | GA | 1971-01-21 | 1973-01-03 | Democrat | 10 | |||||||||||||
33159 | 33159 | John Stennis S000852 | sen | MS | 1971-01-21 | 1977-01-03 | 1 | Democrat | |||||||||||||
31842 | 31842 | William Steiger S000847 | rep | WI | 1971-01-21 | 1973-01-03 | Republican | 6 | |||||||||||||
31339 | 31339 | Sam Steiger S000846 | rep | AZ | 1971-01-21 | 1973-01-03 | Republican | 3 | |||||||||||||
30706 | 30706 | Robert Steele S000836 | rep | CT | 1971-01-21 | 1973-01-03 | Republican | 2 | |||||||||||||
32325 | 32325 | Thomas Steed S000829 | rep | OK | 1971-01-21 | 1973-01-03 | Democrat | 4 | |||||||||||||
32861 | 32861 | John Stanton S000804 | rep | OH | 1971-01-21 | 1973-01-03 | Republican | 11 | |||||||||||||
31332 | 31332 | James Stanton S000803 | rep | OH | 1971-01-21 | 1973-01-03 | Democrat | 20 | |||||||||||||
32309 | 32309 | Harley Staggers S000778 | rep | WV | 1971-01-21 | 1973-01-03 | Democrat | 2 | |||||||||||||
33151 | 33151 | Robert Stafford S000776 | rep | VT | 1971-01-21 | 1971-09-16 | Republican | 0 | |||||||||||||
33753 | 33753 | Fernand St. Germain S000762 | rep | RI | 1971-01-21 | 1973-01-03 | Democrat | 1 | |||||||||||||
30100 | 30100 | William Springer S000756 | rep | IL | 1971-01-21 | 1973-01-03 | Republican | 22 | |||||||||||||
37154 | 37154 | Floyd Spence S000718 | rep | SC | 1971-01-21 | 1973-01-03 | Republican | 2 | |||||||||||||
33418 | 33418 | Marion Snyder S000669 | rep | KY | 1971-01-21 | 1973-01-03 | Republican | 4 | |||||||||||||
35588 | 35588 | Neal Smith S000596 | rep | IA | 1971-01-21 | 1973-01-03 | Democrat | 5 | |||||||||||||
30692 | 30692 | Henry Smith S000548 | rep | NY | 1971-01-21 | 1973-01-03 | Republican | 40 | |||||||||||||
30089 | 30089 | H. Smith S000545 | rep | CA | 1971-01-21 | 1973-01-03 | Republican | 20 | |||||||||||||
32289 | 32289 | John Slack S000473 | rep | WV | 1971-01-21 | 1973-01-03 | Democrat | 3 | |||||||||||||
31835 | 31835 | Joe Skubitz S000472 | rep | KS | 1971-01-21 | 1973-01-03 | Republican | 5 | |||||||||||||
31827 | 31827 | Bernice Sisk S000454 | rep | CA | 1971-01-21 | 1973-01-03 | Democrat | 16 | |||||||||||||
31815 | 31815 | Robert Sikes S000406 | rep | FL | 1971-01-21 | 1973-01-03 | Democrat | 1 | |||||||||||||
31329 | 31329 | Garner Shriver S000388 | rep | KS | 1971-01-21 | 1973-01-03 | Republican | 4 | |||||||||||||
30687 | 30687 | Richard Shoup S000383 | rep | MT | 1971-01-21 | 1973-01-03 | Republican | 1 | |||||||||||||
31796 | 31796 | George Shipley S000367 | rep | IL | 1971-01-21 | 1973-01-03 | Democrat | 23 | |||||||||||||
33404 | 33404 | John Seiberling S000230 | rep | OH | 1971-01-21 | 1973-01-03 | Democrat | 14 | |||||||||||||
32278 | 32278 | Keith Sebelius S000217 | rep | KS | 1971-01-21 | 1973-01-03 | Republican | 1 | |||||||||||||
30685 | 30685 | William Scott S000189 | rep | VA | 1971-01-21 | 1973-01-03 | Republican | 8 | |||||||||||||
30081 | 30081 | Hugh Scott S000174 | sen | PA | 1971-01-21 | 1977-01-03 | 1 | Republican | |||||||||||||
30070 | 30070 | Frederick Schwengel S000161 | rep | IA | 1971-01-21 | 1973-01-03 | Republican | 1 | |||||||||||||
31315 | 31315 | Herman Schneebeli S000135 | rep | PA | 1971-01-21 | 1973-01-03 | Republican | 17 | |||||||||||||
30062 | 30062 | John Schmitz S000133 | rep | CA | 1971-01-21 | 1973-01-03 | Republican | 35 | |||||||||||||
34931 | 34931 | James Scheuer S000124 | rep | NY | 1971-01-21 | 1973-01-03 | Democrat | 22 | |||||||||||||
30681 | 30681 | William Scherle S000121 | rep | IA | 1971-01-21 | 1973-01-03 | Republican | 7 | |||||||||||||
30677 | 30677 | John Saylor S000102 | rep | PA | 1971-01-21 | 1973-01-03 | Republican | 22 | |||||||||||||
32272 | 32272 | David Satterfield S000070 | rep | VA | 1971-01-21 | 1973-01-03 | Democrat | 3 | |||||||||||||
37093 | 37093 | Paul Sarbanes S000064 | rep | MD | 1971-01-21 | 1973-01-03 | Democrat | 4 | |||||||||||||
30664 | 30664 | Charles Sandman S000045 | rep | NJ | 1971-01-21 | 1973-01-03 | Republican | 2 | |||||||||||||
30060 | 30060 | William Ryan R000562 | rep | NY | 1971-01-21 | 1973-01-03 | Democrat | 20 | |||||||||||||
30660 | 30660 | Earl Ruth R000545 | rep | NC | 1971-01-21 | 1973-01-03 | Republican | 8 | |||||||||||||
31779 | 31779 | Philip Ruppe R000512 | rep | MI | 1971-01-21 | 1973-01-03 | Republican | 11 | |||||||||||||
32264 | 32264 | Harold Runnels R000510 | rep | NM | 1971-01-21 | 1973-01-03 | Democrat | 2 | |||||||||||||
34902 | 34902 | Edward Roybal R000485 | rep | CA | 1971-01-21 | 1973-01-03 | Democrat | 30 | |||||||||||||
30657 | 30657 | William Roy R000484 | rep | KS | 1971-01-21 | 1973-01-03 | Democrat | 2 |
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);