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 legislator_id descending
This data as json, copyable, CSV (advanced)
Suggested facets: type, 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
30778 | 30778 | John Zwach Z000016 | rep | MN | 1969-01-03 | 1971-01-03 | Republican | 6 | |||||||||||||
30774 | 30774 | Roger Zion Z000010 | rep | IN | 1969-01-03 | 1971-01-03 | Republican | 8 | |||||||||||||
33201 | 33201 | Clement Zablocki Z000001 | rep | WI | 1969-01-03 | 1971-01-03 | Democrat | 4 | |||||||||||||
31406 | 31406 | Milton Young Y000047 | sen | ND | 1969-01-03 | 1975-01-03 | 3 | Republican | |||||||||||||
31908 | 31908 | John Young Y000043 | rep | TX | 1969-01-03 | 1971-01-03 | Democrat | 14 | |||||||||||||
35078 | 35078 | Gus Yatron Y000014 | rep | PA | 1969-01-03 | 1971-01-03 | Democrat | 6 | |||||||||||||
36457 | 36457 | Sidney Yates Y000013 | rep | IL | 1969-01-03 | 1971-01-03 | Democrat | 9 | |||||||||||||
30783 | 30783 | Louis Wyman W000782 | rep | NH | 1969-01-03 | 1971-01-03 | Republican | 1 | |||||||||||||
35066 | 35066 | Chalmers Wylie W000781 | rep | OH | 1969-01-03 | 1971-01-03 | Republican | 15 | |||||||||||||
32424 | 32424 | John Wydler W000780 | rep | NY | 1969-01-03 | 1971-01-03 | Republican | 4 | |||||||||||||
30768 | 30768 | Wendell Wyatt W000778 | rep | OR | 1969-01-03 | 1971-01-03 | Republican | 1 | |||||||||||||
34149 | 34149 | James Wright W000763 | rep | TX | 1969-01-03 | 1971-01-03 | Democrat | 12 | |||||||||||||
32414 | 32414 | Lester Wolff W000680 | rep | NY | 1969-01-03 | 1971-01-03 | Democrat | 3 | |||||||||||||
29506 | 29506 | John Wold W000671 | rep | WY | 1969-01-03 | 1971-01-03 | Republican | 0 | |||||||||||||
33177 | 33177 | Edward Winn W000636 | rep | KS | 1969-01-03 | 1971-01-03 | Republican | 3 | |||||||||||||
32406 | 32406 | Robert Wilson W000610 | rep | CA | 1969-01-03 | 1971-01-03 | Republican | 36 | |||||||||||||
32392 | 32392 | Charles Wilson W000571 | rep | CA | 1969-01-03 | 1971-01-03 | Democrat | 31 | |||||||||||||
30762 | 30762 | Lawrence Williams W000525 | rep | PA | 1969-01-03 | 1971-01-03 | Republican | 7 | |||||||||||||
31888 | 31888 | Charles Wiggins W000448 | rep | CA | 1969-01-03 | 1971-01-03 | Republican | 25 | |||||||||||||
30758 | 30758 | William Widnall W000445 | rep | NJ | 1969-01-03 | 1971-01-03 | Republican | 7 | |||||||||||||
35656 | 35656 | Jamie Whitten W000428 | rep | MS | 1969-01-03 | 1971-01-03 | Democrat | 2 | |||||||||||||
33434 | 33434 | George Whitehurst W000406 | rep | VA | 1969-01-03 | 1971-01-03 | Republican | 2 | |||||||||||||
32883 | 32883 | Richard White W000390 | rep | TX | 1969-01-03 | 1971-01-03 | Democrat | 16 | |||||||||||||
30133 | 30133 | John Whalley W000320 | rep | PA | 1969-01-03 | 1971-01-03 | Republican | 12 | |||||||||||||
31882 | 31882 | Charles Whalen W000317 | rep | OH | 1969-01-03 | 1971-01-03 | Republican | 3 | |||||||||||||
33169 | 33169 | Lowell Weicker W000253 | rep | CT | 1969-01-03 | 1971-01-03 | Republican | 4 | |||||||||||||
30126 | 30126 | John Watts W000212 | rep | KY | 1969-01-03 | 1971-01-03 | Democrat | 6 | |||||||||||||
29505 | 29505 | Albert Watson W000197 | rep | SC | 1969-01-03 | 1971-01-03 | Republican | 2 | |||||||||||||
29501 | 29501 | George Watkins W000192 | rep | PA | 1969-01-03 | 1971-01-03 | Republican | 9 | |||||||||||||
30745 | 30745 | John Ware W000147 | rep | PA | 1969-01-03 | 1971-01-03 | Republican | 9 | |||||||||||||
32873 | 32873 | William Wampler W000121 | rep | VA | 1969-01-03 | 1971-01-03 | Republican | 9 | |||||||||||||
30742 | 30742 | Jerome Waldie W000035 | rep | CA | 1969-01-03 | 1971-01-03 | Democrat | 14 | |||||||||||||
31873 | 31873 | Joseph Waggonner W000018 | rep | LA | 1969-01-03 | 1971-01-03 | Democrat | 4 | |||||||||||||
31398 | 31398 | Joseph Vigorito V000098 | rep | PA | 1969-01-03 | 1971-01-03 | Democrat | 24 | |||||||||||||
32383 | 32383 | Charles Vanik V000047 | rep | OH | 1969-01-03 | 1971-01-03 | Democrat | 22 | |||||||||||||
35031 | 35031 | Guy Vander Jagt V000027 | rep | MI | 1969-01-03 | 1971-01-03 | Republican | 9 | |||||||||||||
32370 | 32370 | Lionel Van Deerlin V000024 | rep | CA | 1969-01-03 | 1971-01-03 | Democrat | 37 | |||||||||||||
29498 | 29498 | James Utt U000034 | rep | CA | 1969-01-03 | 1971-01-03 | Republican | 35 | |||||||||||||
32361 | 32361 | Albert Ullman U000004 | rep | OR | 1969-01-03 | 1971-01-03 | Democrat | 2 | |||||||||||||
35017 | 35017 | Morris Udall U000001 | rep | AZ | 1969-01-03 | 1971-01-03 | Democrat | 2 | |||||||||||||
30115 | 30115 | John Tunney T000410 | rep | CA | 1969-01-03 | 1971-01-03 | Democrat | 38 | |||||||||||||
30734 | 30734 | Robert Tiernan T000265 | rep | RI | 1969-01-03 | 1971-01-03 | Democrat | 2 | |||||||||||||
30730 | 30730 | Vernon Thomson T000233 | rep | WI | 1969-01-03 | 1971-01-03 | Republican | 3 | |||||||||||||
30111 | 30111 | Standish Thompson T000217 | rep | GA | 1969-01-03 | 1971-01-03 | Republican | 5 | |||||||||||||
32338 | 32338 | Frank Thompson T000200 | rep | NJ | 1969-01-03 | 1971-01-03 | Democrat | 4 | |||||||||||||
31858 | 31858 | Olin Teague T000110 | rep | TX | 1969-01-03 | 1971-01-03 | Democrat | 6 | |||||||||||||
30723 | 30723 | Charles Teague T000109 | rep | CA | 1969-01-03 | 1971-01-03 | Republican | 13 | |||||||||||||
31390 | 31390 | Roy Taylor T000099 | rep | NC | 1969-01-03 | 1971-01-03 | Democrat | 11 | |||||||||||||
31383 | 31383 | Herman Talmadge T000035 | sen | GA | 1969-01-03 | 1975-01-03 | 3 | Democrat | |||||||||||||
31377 | 31377 | Burt Talcott T000022 | rep | CA | 1969-01-03 | 1971-01-03 | Republican | 12 | |||||||||||||
30107 | 30107 | Robert Taft T000010 | rep | OH | 1969-01-03 | 1971-01-03 | Republican | 1 | |||||||||||||
31370 | 31370 | James Symington S001134 | rep | MO | 1969-01-03 | 1971-01-03 | Democrat | 2 | |||||||||||||
31366 | 31366 | Leonor Sullivan S001057 | rep | MO | 1969-01-03 | 1971-01-03 | Democrat | 3 | |||||||||||||
31354 | 31354 | Williamson Stuckey S001039 | rep | GA | 1969-01-03 | 1971-01-03 | Democrat | 8 | |||||||||||||
30713 | 30713 | Frank Stubblefield S001037 | rep | KY | 1969-01-03 | 1971-01-03 | Democrat | 1 | |||||||||||||
33767 | 33767 | Samuel Stratton S000997 | rep | NY | 1969-01-03 | 1971-01-03 | Democrat | 35 | |||||||||||||
36398 | 36398 | Louis Stokes S000948 | rep | OH | 1969-01-03 | 1971-01-03 | Democrat | 21 | |||||||||||||
31346 | 31346 | Robert Stephens S000860 | rep | GA | 1969-01-03 | 1971-01-03 | Democrat | 10 | |||||||||||||
31841 | 31841 | William Steiger S000847 | rep | WI | 1969-01-03 | 1971-01-03 | Republican | 6 | |||||||||||||
31338 | 31338 | Sam Steiger S000846 | rep | AZ | 1969-01-03 | 1971-01-03 | Republican | 3 | |||||||||||||
30705 | 30705 | Robert Steele S000836 | rep | CT | 1969-01-03 | 1971-01-03 | Republican | 2 | |||||||||||||
32324 | 32324 | Thomas Steed S000829 | rep | OK | 1969-01-03 | 1971-01-03 | Democrat | 4 | |||||||||||||
32860 | 32860 | John Stanton S000804 | rep | OH | 1969-01-03 | 1971-01-03 | Republican | 11 | |||||||||||||
32308 | 32308 | Harley Staggers S000778 | rep | WV | 1969-01-03 | 1971-01-03 | Democrat | 2 | |||||||||||||
33150 | 33150 | Robert Stafford S000776 | rep | VT | 1969-01-03 | 1971-01-03 | Republican | 0 | |||||||||||||
29489 | 29489 | William St. Onge S000769 | rep | CT | 1969-01-03 | 1971-01-03 | Democrat | 2 | |||||||||||||
33752 | 33752 | Fernand St. Germain S000762 | rep | RI | 1969-01-03 | 1971-01-03 | Democrat | 1 | |||||||||||||
30099 | 30099 | William Springer S000756 | rep | IL | 1969-01-03 | 1971-01-03 | Republican | 22 | |||||||||||||
33417 | 33417 | Marion Snyder S000669 | rep | KY | 1969-01-03 | 1971-01-03 | Republican | 4 | |||||||||||||
35587 | 35587 | Neal Smith S000596 | rep | IA | 1969-01-03 | 1971-01-03 | Democrat | 5 | |||||||||||||
30691 | 30691 | Henry Smith S000548 | rep | NY | 1969-01-03 | 1971-01-03 | Republican | 40 | |||||||||||||
30088 | 30088 | H. Smith S000545 | rep | CA | 1969-01-03 | 1971-01-03 | Republican | 20 | |||||||||||||
32288 | 32288 | John Slack S000473 | rep | WV | 1969-01-03 | 1971-01-03 | Democrat | 3 | |||||||||||||
31834 | 31834 | Joe Skubitz S000472 | rep | KS | 1969-01-03 | 1971-01-03 | Republican | 5 | |||||||||||||
31826 | 31826 | Bernice Sisk S000454 | rep | CA | 1969-01-03 | 1971-01-03 | Democrat | 16 | |||||||||||||
31814 | 31814 | Robert Sikes S000406 | rep | FL | 1969-01-03 | 1971-01-03 | Democrat | 1 | |||||||||||||
31328 | 31328 | Garner Shriver S000388 | rep | KS | 1969-01-03 | 1971-01-03 | Republican | 4 | |||||||||||||
31795 | 31795 | George Shipley S000367 | rep | IL | 1969-01-03 | 1971-01-03 | Democrat | 23 | |||||||||||||
32277 | 32277 | Keith Sebelius S000217 | rep | KS | 1969-01-03 | 1971-01-03 | Republican | 1 | |||||||||||||
30684 | 30684 | William Scott S000189 | rep | VA | 1969-01-03 | 1971-01-03 | Republican | 8 | |||||||||||||
30069 | 30069 | Frederick Schwengel S000161 | rep | IA | 1969-01-03 | 1971-01-03 | Republican | 1 | |||||||||||||
31322 | 31322 | Richard Schweiker S000159 | sen | PA | 1969-01-03 | 1975-01-03 | 3 | Republican | |||||||||||||
31314 | 31314 | Herman Schneebeli S000135 | rep | PA | 1969-01-03 | 1971-01-03 | Republican | 17 | |||||||||||||
30061 | 30061 | John Schmitz S000133 | rep | CA | 1969-01-03 | 1971-01-03 | Republican | 35 | |||||||||||||
34930 | 34930 | James Scheuer S000124 | rep | NY | 1969-01-03 | 1971-01-03 | Democrat | 21 | |||||||||||||
30680 | 30680 | William Scherle S000121 | rep | IA | 1969-01-03 | 1971-01-03 | Republican | 7 | |||||||||||||
29484 | 29484 | Henry Schadeberg S000108 | rep | WI | 1969-01-03 | 1971-01-03 | Republican | 1 | |||||||||||||
30676 | 30676 | John Saylor S000102 | rep | PA | 1969-01-03 | 1971-01-03 | Republican | 22 | |||||||||||||
29480 | 29480 | William Saxbe S000096 | sen | OH | 1969-01-03 | 1974-01-03 | 3 | Republican | |||||||||||||
32271 | 32271 | David Satterfield S000070 | rep | VA | 1969-01-03 | 1971-01-03 | Democrat | 3 | |||||||||||||
30663 | 30663 | Charles Sandman S000045 | rep | NJ | 1969-01-03 | 1971-01-03 | Republican | 2 | |||||||||||||
30059 | 30059 | William Ryan R000562 | rep | NY | 1969-01-03 | 1971-01-03 | Democrat | 20 | |||||||||||||
30659 | 30659 | Earl Ruth R000545 | rep | NC | 1969-01-03 | 1971-01-03 | Republican | 8 | |||||||||||||
31778 | 31778 | Philip Ruppe R000512 | rep | MI | 1969-01-03 | 1971-01-03 | Republican | 11 | |||||||||||||
29479 | 29479 | Donald Rumsfeld R000508 | rep | IL | 1969-01-03 | 1971-01-03 | Republican | 13 | |||||||||||||
34901 | 34901 | Edward Roybal R000485 | rep | CA | 1969-01-03 | 1971-01-03 | Democrat | 30 | |||||||||||||
32844 | 32844 | John Rousselot R000469 | rep | CA | 1969-01-03 | 1971-01-03 | Republican | 24 | |||||||||||||
29475 | 29475 | Richard Roudebush R000464 | rep | IN | 1969-01-03 | 1971-01-03 | Republican | 5 | |||||||||||||
36018 | 36018 | William Roth R000460 | rep | DE | 1969-01-03 | 1971-01-03 | Republican | 0 | |||||||||||||
35539 | 35539 | Daniel Rostenkowski R000458 | rep | IL | 1969-01-03 | 1971-01-03 | Democrat | 8 |
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);