legislator_terms
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
480 rows where "end" is on date 1977-01-03 sorted by legislator_id descending
This data as json, copyable, CSV (advanced)
Suggested facets: type, party, start (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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
33209 | 33209 | Edward Zorinsky Z000013 | sen | NE | 1976-12-28 | 1977-01-03 | 1 | Democrat | |||||||||||||
32890 | 32890 | Leo Zeferetti Z000002 | rep | NY | 1975-01-14 | 1977-01-03 | Democrat | 15 | |||||||||||||
33204 | 33204 | Clement Zablocki Z000001 | rep | WI | 1975-01-14 | 1977-01-03 | Democrat | 4 | |||||||||||||
31911 | 31911 | John Young Y000043 | rep | TX | 1975-01-14 | 1977-01-03 | Democrat | 14 | |||||||||||||
41665 | 41665 | Don Young Y000033 | rep | AK | 1975-01-14 | 1977-01-03 | Republican | 0 | |||||||||||||
39624 | 39624 | C. Young Y000031 | rep | FL | 1975-01-14 | 1977-01-03 | Republican | 6 | |||||||||||||
31900 | 31900 | Andrew Young Y000028 | rep | GA | 1975-01-14 | 1977-01-03 | Democrat | 5 | |||||||||||||
35081 | 35081 | Gus Yatron Y000014 | rep | PA | 1975-01-14 | 1977-01-03 | Democrat | 6 | |||||||||||||
36460 | 36460 | Sidney Yates Y000013 | rep | IL | 1975-01-14 | 1977-01-03 | Democrat | 9 | |||||||||||||
35069 | 35069 | Chalmers Wylie W000781 | rep | OH | 1975-01-14 | 1977-01-03 | Republican | 15 | |||||||||||||
32427 | 32427 | John Wydler W000780 | rep | NY | 1975-01-14 | 1977-01-03 | Republican | 5 | |||||||||||||
34152 | 34152 | James Wright W000763 | rep | TX | 1975-01-14 | 1977-01-03 | Democrat | 12 | |||||||||||||
33186 | 33186 | Antonio Won Pat W000686 | rep | GU | 1975-01-14 | 1977-01-03 | Democrat | 0 | |||||||||||||
32417 | 32417 | Lester Wolff W000680 | rep | NY | 1975-01-14 | 1977-01-03 | Democrat | 6 | |||||||||||||
33799 | 33799 | Timothy Wirth W000647 | rep | CO | 1975-01-14 | 1977-01-03 | Democrat | 2 | |||||||||||||
33180 | 33180 | Edward Winn W000636 | rep | KS | 1975-01-14 | 1977-01-03 | Republican | 3 | |||||||||||||
32409 | 32409 | Robert Wilson W000610 | rep | CA | 1975-01-14 | 1977-01-03 | Republican | 41 | |||||||||||||
32395 | 32395 | Charles Wilson W000571 | rep | CA | 1975-01-14 | 1977-01-03 | Democrat | 31 | |||||||||||||
36099 | 36099 | Charles Wilson W000570 | rep | TX | 1975-01-14 | 1977-01-03 | Democrat | 2 | |||||||||||||
31897 | 31897 | Harrison Williams W000502 | sen | NJ | 1971-01-21 | 1977-01-03 | 1 | Democrat | |||||||||||||
31891 | 31891 | Charles Wiggins W000448 | rep | CA | 1975-01-14 | 1977-01-03 | Republican | 39 | |||||||||||||
35659 | 35659 | Jamie Whitten W000428 | rep | MS | 1975-01-14 | 1977-01-03 | Democrat | 1 | |||||||||||||
33437 | 33437 | George Whitehurst W000406 | rep | VA | 1975-01-14 | 1977-01-03 | Republican | 2 | |||||||||||||
32886 | 32886 | Richard White W000390 | rep | TX | 1975-01-14 | 1977-01-03 | Democrat | 16 | |||||||||||||
31885 | 31885 | Charles Whalen W000317 | rep | OH | 1975-01-14 | 1977-01-03 | Republican | 3 | |||||||||||||
33170 | 33170 | Lowell Weicker W000253 | sen | CT | 1971-01-21 | 1977-01-03 | 1 | Republican | |||||||||||||
33428 | 33428 | James Weaver W000227 | rep | OR | 1975-01-14 | 1977-01-03 | Democrat | 4 | |||||||||||||
40079 | 40079 | Henry Waxman W000215 | rep | CA | 1975-01-14 | 1977-01-03 | Democrat | 24 | |||||||||||||
32876 | 32876 | William Wampler W000121 | rep | VA | 1975-01-14 | 1977-01-03 | Republican | 9 | |||||||||||||
31879 | 31879 | William Walsh W000107 | rep | NY | 1975-01-14 | 1977-01-03 | Republican | 33 | |||||||||||||
31876 | 31876 | Joseph Waggonner W000018 | rep | LA | 1975-01-14 | 1977-01-03 | Democrat | 4 | |||||||||||||
31401 | 31401 | Joseph Vigorito V000098 | rep | PA | 1975-01-14 | 1977-01-03 | Democrat | 24 | |||||||||||||
32386 | 32386 | Charles Vanik V000047 | rep | OH | 1975-01-14 | 1977-01-03 | Democrat | 22 | |||||||||||||
31395 | 31395 | Richard Vander Veen V000029 | rep | MI | 1975-01-14 | 1977-01-03 | Democrat | 5 | |||||||||||||
35034 | 35034 | Guy Vander Jagt V000027 | rep | MI | 1975-01-14 | 1977-01-03 | Republican | 9 | |||||||||||||
32373 | 32373 | Lionel Van Deerlin V000024 | rep | CA | 1975-01-14 | 1977-01-03 | Democrat | 42 | |||||||||||||
32364 | 32364 | Albert Ullman U000004 | rep | OR | 1975-01-14 | 1977-01-03 | Democrat | 2 | |||||||||||||
35020 | 35020 | Morris Udall U000001 | rep | AZ | 1975-01-14 | 1977-01-03 | Democrat | 2 | |||||||||||||
30116 | 30116 | John Tunney T000410 | sen | CA | 1971-01-21 | 1977-01-03 | 1 | Democrat | |||||||||||||
32352 | 32352 | Paul Tsongas T000393 | rep | MA | 1975-01-14 | 1977-01-03 | Democrat | 5 | |||||||||||||
32349 | 32349 | David Treen T000362 | rep | LA | 1975-01-14 | 1977-01-03 | Republican | 3 | |||||||||||||
35004 | 35004 | Jerome Traxler T000356 | rep | MI | 1975-01-14 | 1977-01-03 | Democrat | 8 | |||||||||||||
36051 | 36051 | Raymond Thornton T000243 | rep | AR | 1975-01-14 | 1977-01-03 | Democrat | 4 | |||||||||||||
31865 | 31865 | Charles Thone T000234 | rep | NE | 1975-01-14 | 1977-01-03 | Republican | 1 | |||||||||||||
32341 | 32341 | Frank Thompson T000200 | rep | NJ | 1975-01-14 | 1977-01-03 | Democrat | 4 | |||||||||||||
31861 | 31861 | Olin Teague T000110 | rep | TX | 1975-01-14 | 1977-01-03 | Democrat | 6 | |||||||||||||
31393 | 31393 | Roy Taylor T000099 | rep | NC | 1975-01-14 | 1977-01-03 | Democrat | 11 | |||||||||||||
33792 | 33792 | Gene Taylor T000075 | rep | MO | 1975-01-14 | 1977-01-03 | Republican | 7 | |||||||||||||
31380 | 31380 | Burt Talcott T000022 | rep | CA | 1975-01-14 | 1977-01-03 | Republican | 16 | |||||||||||||
33786 | 33786 | Steven Symms S001138 | rep | ID | 1975-01-14 | 1977-01-03 | Republican | 1 | |||||||||||||
31373 | 31373 | James Symington S001134 | rep | MO | 1975-01-14 | 1977-01-03 | Democrat | 2 | |||||||||||||
31369 | 31369 | Leonor Sullivan S001057 | rep | MO | 1975-01-14 | 1977-01-03 | Democrat | 3 | |||||||||||||
36038 | 36038 | Gerry Studds S001040 | rep | MA | 1975-01-14 | 1977-01-03 | Democrat | 12 | |||||||||||||
31357 | 31357 | Williamson Stuckey S001039 | rep | GA | 1975-01-14 | 1977-01-03 | Democrat | 8 | |||||||||||||
33770 | 33770 | Samuel Stratton S000997 | rep | NY | 1975-01-14 | 1977-01-03 | Democrat | 28 | |||||||||||||
36401 | 36401 | Louis Stokes S000948 | rep | OH | 1975-01-14 | 1977-01-03 | Democrat | 21 | |||||||||||||
31349 | 31349 | Robert Stephens S000860 | rep | GA | 1975-01-14 | 1977-01-03 | Democrat | 10 | |||||||||||||
33159 | 33159 | John Stennis S000852 | sen | MS | 1971-01-21 | 1977-01-03 | 1 | Democrat | |||||||||||||
31844 | 31844 | William Steiger S000847 | rep | WI | 1975-01-14 | 1977-01-03 | Republican | 6 | |||||||||||||
31341 | 31341 | Sam Steiger S000846 | rep | AZ | 1975-01-14 | 1977-01-03 | Republican | 3 | |||||||||||||
31336 | 31336 | Alan Steelman S000841 | rep | TX | 1975-01-14 | 1977-01-03 | Republican | 5 | |||||||||||||
32327 | 32327 | Thomas Steed S000829 | rep | OK | 1975-01-14 | 1977-01-03 | Democrat | 4 | |||||||||||||
39514 | 39514 | Fortney Stark S000810 | rep | CA | 1975-01-14 | 1977-01-03 | Democrat | 9 | |||||||||||||
32863 | 32863 | John Stanton S000804 | rep | OH | 1975-01-14 | 1977-01-03 | Republican | 11 | |||||||||||||
31334 | 31334 | James Stanton S000803 | rep | OH | 1975-01-14 | 1977-01-03 | Democrat | 20 | |||||||||||||
32311 | 32311 | Harley Staggers S000778 | rep | WV | 1975-01-14 | 1977-01-03 | Democrat | 2 | |||||||||||||
33152 | 33152 | Robert Stafford S000776 | sen | VT | 1971-09-16 | 1977-01-03 | 1 | Republican | appointment | ||||||||||||
33755 | 33755 | Fernand St. Germain S000762 | rep | RI | 1975-01-14 | 1977-01-03 | Democrat | 1 | |||||||||||||
37156 | 37156 | Floyd Spence S000718 | rep | SC | 1975-01-14 | 1977-01-03 | Republican | 2 | |||||||||||||
32294 | 32294 | Gladys Spellman S000716 | rep | MD | 1975-01-14 | 1977-01-03 | Democrat | 5 | |||||||||||||
34975 | 34975 | Stephen Solarz S000673 | rep | NY | 1975-01-14 | 1977-01-03 | Democrat | 13 | |||||||||||||
33420 | 33420 | Marion Snyder S000669 | rep | KY | 1975-01-14 | 1977-01-03 | Republican | 4 | |||||||||||||
34103 | 34103 | Virginia Smith S000622 | rep | NE | 1975-01-14 | 1977-01-03 | Republican | 3 | |||||||||||||
35590 | 35590 | Neal Smith S000596 | rep | IA | 1975-01-14 | 1977-01-03 | Democrat | 4 | |||||||||||||
32291 | 32291 | John Slack S000473 | rep | WV | 1975-01-14 | 1977-01-03 | Democrat | 3 | |||||||||||||
31837 | 31837 | Joe Skubitz S000472 | rep | KS | 1975-01-14 | 1977-01-03 | Republican | 5 | |||||||||||||
31829 | 31829 | Bernice Sisk S000454 | rep | CA | 1975-01-14 | 1977-01-03 | Democrat | 16 | |||||||||||||
34956 | 34956 | Paul Simon S000423 | rep | IL | 1975-01-14 | 1977-01-03 | Democrat | 24 | |||||||||||||
31817 | 31817 | Robert Sikes S000406 | rep | FL | 1975-01-14 | 1977-01-03 | Democrat | 1 | |||||||||||||
37119 | 37119 | Elmer Shuster S000394 | rep | PA | 1975-01-14 | 1977-01-03 | Republican | 9 | |||||||||||||
31331 | 31331 | Garner Shriver S000388 | rep | KS | 1975-01-14 | 1977-01-03 | Republican | 4 | |||||||||||||
31798 | 31798 | George Shipley S000367 | rep | IL | 1975-01-14 | 1977-01-03 | Democrat | 22 | |||||||||||||
35565 | 35565 | Philip Sharp S000294 | rep | IN | 1975-01-14 | 1977-01-03 | Democrat | 10 | |||||||||||||
33406 | 33406 | John Seiberling S000230 | rep | OH | 1975-01-14 | 1977-01-03 | Democrat | 14 | |||||||||||||
32280 | 32280 | Keith Sebelius S000217 | rep | KS | 1975-01-14 | 1977-01-03 | Republican | 1 | |||||||||||||
30081 | 30081 | Hugh Scott S000174 | sen | PA | 1971-01-21 | 1977-01-03 | 1 | Republican | |||||||||||||
34941 | 34941 | Richard Schulze S000146 | rep | PA | 1975-01-14 | 1977-01-03 | Republican | 5 | |||||||||||||
36025 | 36025 | Patricia Schroeder S000142 | rep | CO | 1975-01-14 | 1977-01-03 | Democrat | 1 | |||||||||||||
31317 | 31317 | Herman Schneebeli S000135 | rep | PA | 1975-01-14 | 1977-01-03 | Republican | 17 | |||||||||||||
34932 | 34932 | James Scheuer S000124 | rep | NY | 1975-01-14 | 1977-01-03 | Democrat | 11 | |||||||||||||
32274 | 32274 | David Satterfield S000070 | rep | VA | 1975-01-14 | 1977-01-03 | Democrat | 3 | |||||||||||||
37095 | 37095 | Paul Sarbanes S000064 | rep | MD | 1975-01-14 | 1977-01-03 | Democrat | 3 | |||||||||||||
31787 | 31787 | Ronald Sarasin S000062 | rep | CT | 1975-01-14 | 1977-01-03 | Republican | 5 | |||||||||||||
32851 | 32851 | James Santini S000058 | rep | NV | 1975-01-14 | 1977-01-03 | Democrat | 0 | |||||||||||||
31784 | 31784 | Leo Ryan R000558 | rep | CA | 1975-01-14 | 1977-01-03 | Democrat | 11 | |||||||||||||
34913 | 34913 | Martin Russo R000543 | rep | IL | 1975-01-14 | 1977-01-03 | Democrat | 3 | |||||||||||||
31781 | 31781 | Philip Ruppe R000512 | rep | MI | 1975-01-14 | 1977-01-03 | Republican | 11 | |||||||||||||
32266 | 32266 | Harold Runnels R000510 | rep | NM | 1975-01-14 | 1977-01-03 | Democrat | 2 | |||||||||||||
34904 | 34904 | Edward Roybal R000485 | rep | CA | 1975-01-14 | 1977-01-03 | Democrat | 25 | |||||||||||||
32847 | 32847 | John Rousselot R000469 | rep | CA | 1975-01-14 | 1977-01-03 | Republican | 26 |
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);