legislator_terms
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
479 rows where "end" is on date 1975-01-03 sorted by legislator_id descending
This data as json, copyable, CSV (advanced)
Suggested facets: 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
30780 | 30780 | John Zwach Z000016 | rep | MN | 1973-01-03 | 1975-01-03 | Republican | 6 | |||||||||||||
30776 | 30776 | Roger Zion Z000010 | rep | IN | 1973-01-03 | 1975-01-03 | Republican | 8 | |||||||||||||
33203 | 33203 | Clement Zablocki Z000001 | rep | WI | 1973-01-03 | 1975-01-03 | Democrat | 4 | |||||||||||||
30772 | 30772 | Samuel Young Y000052 | rep | IL | 1973-01-03 | 1975-01-03 | Republican | 10 | |||||||||||||
31406 | 31406 | Milton Young Y000047 | sen | ND | 1969-01-03 | 1975-01-03 | 3 | Republican | |||||||||||||
31910 | 31910 | John Young Y000043 | rep | TX | 1973-01-03 | 1975-01-03 | Democrat | 14 | |||||||||||||
30771 | 30771 | Edward Young Y000035 | rep | SC | 1973-01-03 | 1975-01-03 | Republican | 6 | |||||||||||||
41664 | 41664 | Don Young Y000033 | rep | AK | 1973-03-06 | 1975-01-03 | Republican | 0 | |||||||||||||
39623 | 39623 | C. Young Y000031 | rep | FL | 1973-01-03 | 1975-01-03 | Republican | 6 | |||||||||||||
31899 | 31899 | Andrew Young Y000028 | rep | GA | 1973-01-03 | 1975-01-03 | Democrat | 5 | |||||||||||||
35080 | 35080 | Gus Yatron Y000014 | rep | PA | 1973-01-03 | 1975-01-03 | Democrat | 6 | |||||||||||||
36459 | 36459 | Sidney Yates Y000013 | rep | IL | 1973-01-03 | 1975-01-03 | Democrat | 9 | |||||||||||||
30786 | 30786 | Louis Wyman W000782 | sen | NH | 1974-12-31 | 1975-01-03 | 3 | Republican | appointment | ||||||||||||
35068 | 35068 | Chalmers Wylie W000781 | rep | OH | 1973-01-03 | 1975-01-03 | Republican | 15 | |||||||||||||
32426 | 32426 | John Wydler W000780 | rep | NY | 1973-01-03 | 1975-01-03 | Republican | 5 | |||||||||||||
30770 | 30770 | Wendell Wyatt W000778 | rep | OR | 1973-01-03 | 1975-01-03 | Republican | 1 | |||||||||||||
34151 | 34151 | James Wright W000763 | rep | TX | 1973-01-03 | 1975-01-03 | Democrat | 12 | |||||||||||||
33185 | 33185 | Antonio Won Pat W000686 | rep | GU | 1973-01-03 | 1975-01-03 | Democrat | 0 | |||||||||||||
32416 | 32416 | Lester Wolff W000680 | rep | NY | 1973-01-03 | 1975-01-03 | Democrat | 6 | |||||||||||||
33179 | 33179 | Edward Winn W000636 | rep | KS | 1973-01-03 | 1975-01-03 | Republican | 3 | |||||||||||||
32408 | 32408 | Robert Wilson W000610 | rep | CA | 1973-01-03 | 1975-01-03 | Republican | 40 | |||||||||||||
32394 | 32394 | Charles Wilson W000571 | rep | CA | 1973-01-03 | 1975-01-03 | Democrat | 31 | |||||||||||||
36098 | 36098 | Charles Wilson W000570 | rep | TX | 1973-01-03 | 1975-01-03 | Democrat | 2 | |||||||||||||
30764 | 30764 | Lawrence Williams W000525 | rep | PA | 1973-01-03 | 1975-01-03 | Republican | 7 | |||||||||||||
31890 | 31890 | Charles Wiggins W000448 | rep | CA | 1973-01-03 | 1975-01-03 | Republican | 25 | |||||||||||||
30760 | 30760 | William Widnall W000445 | rep | NJ | 1973-01-03 | 1975-01-03 | Republican | 7 | |||||||||||||
35658 | 35658 | Jamie Whitten W000428 | rep | MS | 1973-01-03 | 1975-01-03 | Democrat | 1 | |||||||||||||
33436 | 33436 | George Whitehurst W000406 | rep | VA | 1973-01-03 | 1975-01-03 | Republican | 2 | |||||||||||||
32885 | 32885 | Richard White W000390 | rep | TX | 1973-01-03 | 1975-01-03 | Democrat | 16 | |||||||||||||
31884 | 31884 | Charles Whalen W000317 | rep | OH | 1973-01-03 | 1975-01-03 | Republican | 3 | |||||||||||||
30747 | 30747 | John Ware W000147 | rep | PA | 1973-01-03 | 1975-01-03 | Republican | 5 | |||||||||||||
32875 | 32875 | William Wampler W000121 | rep | VA | 1973-01-03 | 1975-01-03 | Republican | 9 | |||||||||||||
31878 | 31878 | William Walsh W000107 | rep | NY | 1973-01-03 | 1975-01-03 | Republican | 33 | |||||||||||||
30744 | 30744 | Jerome Waldie W000035 | rep | CA | 1973-01-03 | 1975-01-03 | Democrat | 14 | |||||||||||||
31875 | 31875 | Joseph Waggonner W000018 | rep | LA | 1973-01-03 | 1975-01-03 | Democrat | 4 | |||||||||||||
31400 | 31400 | Joseph Vigorito V000098 | rep | PA | 1973-01-03 | 1975-01-03 | Democrat | 24 | |||||||||||||
30739 | 30739 | Victor Veysey V000093 | rep | CA | 1973-01-03 | 1975-01-03 | Republican | 43 | |||||||||||||
32385 | 32385 | Charles Vanik V000047 | rep | OH | 1973-01-03 | 1975-01-03 | Democrat | 22 | |||||||||||||
31394 | 31394 | Richard Vander Veen V000029 | rep | MI | 1973-01-03 | 1975-01-03 | Democrat | 5 | |||||||||||||
35033 | 35033 | Guy Vander Jagt V000027 | rep | MI | 1973-01-03 | 1975-01-03 | Republican | 9 | |||||||||||||
32372 | 32372 | Lionel Van Deerlin V000024 | rep | CA | 1973-01-03 | 1975-01-03 | Democrat | 41 | |||||||||||||
32363 | 32363 | Albert Ullman U000004 | rep | OR | 1973-01-03 | 1975-01-03 | Democrat | 2 | |||||||||||||
35019 | 35019 | Morris Udall U000001 | rep | AZ | 1973-01-03 | 1975-01-03 | Democrat | 2 | |||||||||||||
32348 | 32348 | David Treen T000362 | rep | LA | 1973-01-03 | 1975-01-03 | Republican | 3 | |||||||||||||
35003 | 35003 | Jerome Traxler T000356 | rep | MI | 1973-01-03 | 1975-01-03 | Democrat | 8 | |||||||||||||
30737 | 30737 | David Towell T000321 | rep | NV | 1973-01-03 | 1975-01-03 | Republican | 0 | |||||||||||||
30736 | 30736 | Robert Tiernan T000265 | rep | RI | 1973-01-03 | 1975-01-03 | Democrat | 2 | |||||||||||||
36050 | 36050 | Raymond Thornton T000243 | rep | AR | 1973-01-03 | 1975-01-03 | Democrat | 4 | |||||||||||||
31864 | 31864 | Charles Thone T000234 | rep | NE | 1973-01-03 | 1975-01-03 | Republican | 1 | |||||||||||||
30732 | 30732 | Vernon Thomson T000233 | rep | WI | 1973-01-03 | 1975-01-03 | Republican | 3 | |||||||||||||
32340 | 32340 | Frank Thompson T000200 | rep | NJ | 1973-01-03 | 1975-01-03 | Democrat | 4 | |||||||||||||
31860 | 31860 | Olin Teague T000110 | rep | TX | 1973-01-03 | 1975-01-03 | Democrat | 6 | |||||||||||||
30725 | 30725 | Charles Teague T000109 | rep | CA | 1973-01-03 | 1975-01-03 | Republican | 13 | |||||||||||||
31392 | 31392 | Roy Taylor T000099 | rep | NC | 1973-01-03 | 1975-01-03 | Democrat | 11 | |||||||||||||
33791 | 33791 | Gene Taylor T000075 | rep | MO | 1973-01-03 | 1975-01-03 | Republican | 7 | |||||||||||||
31383 | 31383 | Herman Talmadge T000035 | sen | GA | 1969-01-03 | 1975-01-03 | 3 | Democrat | |||||||||||||
31379 | 31379 | Burt Talcott T000022 | rep | CA | 1973-01-03 | 1975-01-03 | Republican | 12 | |||||||||||||
33785 | 33785 | Steven Symms S001138 | rep | ID | 1973-01-03 | 1975-01-03 | Republican | 1 | |||||||||||||
31372 | 31372 | James Symington S001134 | rep | MO | 1973-01-03 | 1975-01-03 | Democrat | 2 | |||||||||||||
31368 | 31368 | Leonor Sullivan S001057 | rep | MO | 1973-01-03 | 1975-01-03 | Democrat | 3 | |||||||||||||
36037 | 36037 | Gerry Studds S001040 | rep | MA | 1973-01-03 | 1975-01-03 | Democrat | 12 | |||||||||||||
31356 | 31356 | Williamson Stuckey S001039 | rep | GA | 1973-01-03 | 1975-01-03 | Democrat | 8 | |||||||||||||
30715 | 30715 | Frank Stubblefield S001037 | rep | KY | 1973-01-03 | 1975-01-03 | Democrat | 1 | |||||||||||||
33769 | 33769 | Samuel Stratton S000997 | rep | NY | 1973-01-03 | 1975-01-03 | Democrat | 28 | |||||||||||||
36400 | 36400 | Louis Stokes S000948 | rep | OH | 1973-01-03 | 1975-01-03 | Democrat | 21 | |||||||||||||
31350 | 31350 | Adlai Stevenson S000890 | sen | IL | 1970-01-01 | 1975-01-03 | 3 | Democrat | |||||||||||||
31348 | 31348 | Robert Stephens S000860 | rep | GA | 1973-01-03 | 1975-01-03 | Democrat | 10 | |||||||||||||
31843 | 31843 | William Steiger S000847 | rep | WI | 1973-01-03 | 1975-01-03 | Republican | 6 | |||||||||||||
31340 | 31340 | Sam Steiger S000846 | rep | AZ | 1973-01-03 | 1975-01-03 | Republican | 3 | |||||||||||||
31335 | 31335 | Alan Steelman S000841 | rep | TX | 1973-01-03 | 1975-01-03 | Republican | 5 | |||||||||||||
30707 | 30707 | Robert Steele S000836 | rep | CT | 1973-01-03 | 1975-01-03 | Republican | 2 | |||||||||||||
32326 | 32326 | Thomas Steed S000829 | rep | OK | 1973-01-03 | 1975-01-03 | Democrat | 4 | |||||||||||||
39513 | 39513 | Fortney Stark S000810 | rep | CA | 1973-01-03 | 1975-01-03 | Democrat | 8 | |||||||||||||
32862 | 32862 | John Stanton S000804 | rep | OH | 1973-01-03 | 1975-01-03 | Republican | 11 | |||||||||||||
31333 | 31333 | James Stanton S000803 | rep | OH | 1973-01-03 | 1975-01-03 | Democrat | 20 | |||||||||||||
32310 | 32310 | Harley Staggers S000778 | rep | WV | 1973-01-03 | 1975-01-03 | Democrat | 2 | |||||||||||||
33754 | 33754 | Fernand St. Germain S000762 | rep | RI | 1973-01-03 | 1975-01-03 | Democrat | 1 | |||||||||||||
37155 | 37155 | Floyd Spence S000718 | rep | SC | 1973-01-03 | 1975-01-03 | Republican | 2 | |||||||||||||
33419 | 33419 | Marion Snyder S000669 | rep | KY | 1973-01-03 | 1975-01-03 | Republican | 4 | |||||||||||||
35589 | 35589 | Neal Smith S000596 | rep | IA | 1973-01-03 | 1975-01-03 | Democrat | 4 | |||||||||||||
30693 | 30693 | Henry Smith S000548 | rep | NY | 1973-01-03 | 1975-01-03 | Republican | 36 | |||||||||||||
32290 | 32290 | John Slack S000473 | rep | WV | 1973-01-03 | 1975-01-03 | Democrat | 3 | |||||||||||||
31836 | 31836 | Joe Skubitz S000472 | rep | KS | 1973-01-03 | 1975-01-03 | Republican | 5 | |||||||||||||
31828 | 31828 | Bernice Sisk S000454 | rep | CA | 1973-01-03 | 1975-01-03 | Democrat | 16 | |||||||||||||
31816 | 31816 | Robert Sikes S000406 | rep | FL | 1973-01-03 | 1975-01-03 | Democrat | 1 | |||||||||||||
37118 | 37118 | Elmer Shuster S000394 | rep | PA | 1973-01-03 | 1975-01-03 | Republican | 9 | |||||||||||||
31330 | 31330 | Garner Shriver S000388 | rep | KS | 1973-01-03 | 1975-01-03 | Republican | 4 | |||||||||||||
30688 | 30688 | Richard Shoup S000383 | rep | MT | 1973-01-03 | 1975-01-03 | Republican | 1 | |||||||||||||
31797 | 31797 | George Shipley S000367 | rep | IL | 1973-01-03 | 1975-01-03 | Democrat | 22 | |||||||||||||
33405 | 33405 | John Seiberling S000230 | rep | OH | 1973-01-03 | 1975-01-03 | Democrat | 14 | |||||||||||||
32279 | 32279 | Keith Sebelius S000217 | rep | KS | 1973-01-03 | 1975-01-03 | Republican | 1 | |||||||||||||
31322 | 31322 | Richard Schweiker S000159 | sen | PA | 1969-01-03 | 1975-01-03 | 3 | Republican | |||||||||||||
36024 | 36024 | Patricia Schroeder S000142 | rep | CO | 1973-01-03 | 1975-01-03 | Democrat | 1 | |||||||||||||
31316 | 31316 | Herman Schneebeli S000135 | rep | PA | 1973-01-03 | 1975-01-03 | Republican | 17 | |||||||||||||
30682 | 30682 | William Scherle S000121 | rep | IA | 1973-01-03 | 1975-01-03 | Republican | 5 | |||||||||||||
30678 | 30678 | John Saylor S000102 | rep | PA | 1973-01-03 | 1975-01-03 | Republican | 12 | |||||||||||||
32273 | 32273 | David Satterfield S000070 | rep | VA | 1973-01-03 | 1975-01-03 | Democrat | 3 | |||||||||||||
37094 | 37094 | Paul Sarbanes S000064 | rep | MD | 1973-01-03 | 1975-01-03 | Democrat | 3 | |||||||||||||
31786 | 31786 | Ronald Sarasin S000062 | rep | CT | 1973-01-03 | 1975-01-03 | Republican | 5 | |||||||||||||
30665 | 30665 | Charles Sandman S000045 | rep | NJ | 1973-01-03 | 1975-01-03 | Republican | 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);