legislator_terms
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
489 rows where "end" is on date 1963-01-03 sorted by state descending
This data as json, copyable, CSV (advanced)
Suggested facets: 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
27225 | 27225 | John Hickey H000561 | sen | WY | 1961-01-03 | 1963-01-03 | 2 | Democrat | appointment | ||||||||||||
28892 | 28892 | William Harrison H000278 | rep | WY | 1961-01-03 | 1963-01-03 | Republican | 0 | |||||||||||||
27099 | 27099 | Cleveland Bailey B000035 | rep | WV | 1961-01-03 | 1963-01-03 | Democrat | 3 | |||||||||||||
27948 | 27948 | Maude Kee K000040 | rep | WV | 1961-01-03 | 1963-01-03 | Democrat | 5 | |||||||||||||
28968 | 28968 | Arch Moore M000892 | rep | WV | 1961-01-03 | 1963-01-03 | Republican | 1 | |||||||||||||
30990 | 30990 | Kenneth Hechler H000438 | rep | WV | 1961-01-03 | 1963-01-03 | Democrat | 4 | |||||||||||||
32284 | 32284 | John Slack S000473 | rep | WV | 1961-01-03 | 1963-01-03 | Democrat | 6 | |||||||||||||
32304 | 32304 | Harley Staggers S000778 | rep | WV | 1961-01-03 | 1963-01-03 | Democrat | 2 | |||||||||||||
26670 | 26670 | Alexander Wiley W000465 | sen | WI | 1957-01-03 | 1963-01-03 | 3 | Republican | |||||||||||||
27937 | 27937 | Lester Johnson J000158 | rep | WI | 1961-01-03 | 1963-01-03 | Democrat | 9 | |||||||||||||
28201 | 28201 | William Van Pelt V000051 | rep | WI | 1961-01-03 | 1963-01-03 | Republican | 6 | |||||||||||||
29325 | 29325 | Melvin Laird L000024 | rep | WI | 1961-01-03 | 1963-01-03 | Republican | 7 | |||||||||||||
29481 | 29481 | Henry Schadeberg S000108 | rep | WI | 1961-01-03 | 1963-01-03 | Republican | 1 | |||||||||||||
29658 | 29658 | John Byrnes B001216 | rep | WI | 1961-01-03 | 1963-01-03 | Republican | 8 | |||||||||||||
29999 | 29999 | Alvin O’Konski O000058 | rep | WI | 1961-01-03 | 1963-01-03 | Republican | 10 | |||||||||||||
30726 | 30726 | Vernon Thomson T000233 | rep | WI | 1961-01-03 | 1963-01-03 | Republican | 3 | |||||||||||||
32812 | 32812 | Henry Reuss R000165 | rep | WI | 1961-01-03 | 1963-01-03 | Democrat | 5 | |||||||||||||
33197 | 33197 | Clement Zablocki Z000001 | rep | WI | 1961-01-03 | 1963-01-03 | Democrat | 4 | |||||||||||||
33959 | 33959 | Robert Kastenmeier K000020 | rep | WI | 1961-01-03 | 1963-01-03 | Democrat | 2 | |||||||||||||
27335 | 27335 | Donald Magnuson M000052 | rep | WA | 1961-01-03 | 1963-01-03 | Democrat | 7 | |||||||||||||
27908 | 27908 | Walter Horan H000786 | rep | WA | 1961-01-03 | 1963-01-03 | Republican | 5 | |||||||||||||
28194 | 28194 | Thor Tollefson T000298 | rep | WA | 1961-01-03 | 1963-01-03 | Republican | 6 | |||||||||||||
28254 | 28254 | Alfred Westland W000310 | rep | WA | 1961-01-03 | 1963-01-03 | Republican | 2 | |||||||||||||
29356 | 29356 | Catherine May M000273 | rep | WA | 1961-01-03 | 1963-01-03 | Republican | 4 | |||||||||||||
30014 | 30014 | Thomas Pelly P000196 | rep | WA | 1961-01-03 | 1963-01-03 | Republican | 1 | |||||||||||||
30455 | 30455 | Julia Hansen H000174 | rep | WA | 1961-01-03 | 1963-01-03 | Democrat | 3 | |||||||||||||
31167 | 31167 | Warren Magnuson M000053 | sen | WA | 1957-01-03 | 1963-01-03 | 3 | Democrat | |||||||||||||
29116 | 29116 | George Aiken A000062 | sen | VT | 1957-01-03 | 1963-01-03 | 3 | Republican | |||||||||||||
33146 | 33146 | Robert Stafford S000776 | rep | VT | 1961-01-03 | 1963-01-03 | Republican | 0 | |||||||||||||
27224 | 27224 | Burr Harrison H000264 | rep | VA | 1961-01-03 | 1963-01-03 | Democrat | 7 | |||||||||||||
27798 | 27798 | Julian Gary G000091 | rep | VA | 1961-01-03 | 1963-01-03 | Democrat | 3 | |||||||||||||
28478 | 28478 | William Jennings J000098 | rep | VA | 1961-01-03 | 1963-01-03 | Democrat | 9 | |||||||||||||
28672 | 28672 | Howard Smith S000554 | rep | VA | 1961-01-03 | 1963-01-03 | Democrat | 8 | |||||||||||||
28884 | 28884 | Porter Hardy H000197 | rep | VA | 1961-01-03 | 1963-01-03 | Democrat | 2 | |||||||||||||
29055 | 29055 | William Tuck T000395 | rep | VA | 1961-01-03 | 1963-01-03 | Democrat | 5 | |||||||||||||
29518 | 29518 | Watkins Abbitt A000002 | rep | VA | 1961-01-03 | 1963-01-03 | Democrat | 4 | |||||||||||||
30031 | 30031 | Richard Poff P000401 | rep | VA | 1961-01-03 | 1963-01-03 | Republican | 6 | |||||||||||||
30206 | 30206 | Joel Broyhill B000967 | rep | VA | 1961-01-03 | 1963-01-03 | Republican | 10 | |||||||||||||
30902 | 30902 | Thomas Downing D000474 | rep | VA | 1961-01-03 | 1963-01-03 | Democrat | 1 | |||||||||||||
27410 | 27410 | Morris Peterson P000264 | rep | UT | 1961-01-03 | 1963-01-03 | Democrat | 1 | |||||||||||||
28509 | 28509 | David King K000199 | rep | UT | 1961-01-03 | 1963-01-03 | Democrat | 2 | |||||||||||||
29146 | 29146 | Wallace Bennett B000384 | sen | UT | 1957-01-03 | 1963-01-03 | 3 | Republican | |||||||||||||
27255 | 27255 | Frank Ikard I000007 | rep | TX | 1961-01-03 | 1963-01-03 | Democrat | 13 | |||||||||||||
27298 | 27298 | Paul Kilday K000171 | rep | TX | 1961-01-03 | 1963-01-03 | Democrat | 20 | |||||||||||||
27458 | 27458 | Samuel Rayburn R000082 | rep | TX | 1961-01-03 | 1963-01-03 | Democrat | 4 | |||||||||||||
27501 | 27501 | J. Rutherford R000547 | rep | TX | 1961-01-03 | 1963-01-03 | Democrat | 16 | |||||||||||||
27606 | 27606 | Bruce Alger A000106 | rep | TX | 1961-01-03 | 1963-01-03 | Republican | 5 | |||||||||||||
27966 | 27966 | Joe Kilgore K000177 | rep | TX | 1961-01-03 | 1963-01-03 | Democrat | 15 | |||||||||||||
28185 | 28185 | William Thornberry T000237 | rep | TX | 1961-01-03 | 1963-01-03 | Democrat | 10 | |||||||||||||
28326 | 28326 | Lindley Beckworth B000296 | rep | TX | 1961-01-03 | 1963-01-03 | Democrat | 3 | |||||||||||||
28626 | 28626 | Walter Rogers R000404 | rep | TX | 1961-01-03 | 1963-01-03 | Democrat | 18 | |||||||||||||
28689 | 28689 | Albert Thomas T000156 | rep | TX | 1961-01-03 | 1963-01-03 | Democrat | 8 | |||||||||||||
28701 | 28701 | Clark Thompson T000198 | rep | TX | 1961-01-03 | 1963-01-03 | Democrat | 9 | |||||||||||||
29743 | 29743 | John Dowdy D000467 | rep | TX | 1961-01-03 | 1963-01-03 | Democrat | 7 | |||||||||||||
30044 | 30044 | Graham Purcell P000569 | rep | TX | 1961-01-03 | 1963-01-03 | Democrat | 13 | |||||||||||||
30353 | 30353 | Ovie Fisher F000152 | rep | TX | 1961-01-03 | 1963-01-03 | Democrat | 21 | |||||||||||||
30856 | 30856 | Robert Casey C000228 | rep | TX | 1961-01-03 | 1963-01-03 | Democrat | 22 | |||||||||||||
31268 | 31268 | John Patman P000103 | rep | TX | 1961-01-03 | 1963-01-03 | Democrat | 1 | |||||||||||||
31460 | 31460 | Omar Burleson B001111 | rep | TX | 1961-01-03 | 1963-01-03 | Democrat | 17 | |||||||||||||
31634 | 31634 | George Mahon M000065 | rep | TX | 1961-01-03 | 1963-01-03 | Democrat | 19 | |||||||||||||
31730 | 31730 | William Poage P000398 | rep | TX | 1961-01-03 | 1963-01-03 | Democrat | 11 | |||||||||||||
31854 | 31854 | Olin Teague T000110 | rep | TX | 1961-01-03 | 1963-01-03 | Democrat | 6 | |||||||||||||
31904 | 31904 | John Young Y000043 | rep | TX | 1961-01-03 | 1963-01-03 | Democrat | 14 | |||||||||||||
32253 | 32253 | Herbert Roberts R000312 | rep | TX | 1961-01-03 | 1963-01-03 | Democrat | 4 | |||||||||||||
34145 | 34145 | James Wright W000763 | rep | TX | 1961-01-03 | 1963-01-03 | Democrat | 12 | |||||||||||||
35139 | 35139 | Jack Brooks B000880 | rep | TX | 1961-01-03 | 1963-01-03 | Democrat | 2 | |||||||||||||
36203 | 36203 | Henry González G000272 | rep | TX | 1961-01-03 | 1963-01-03 | Democrat | 20 | |||||||||||||
27210 | 27210 | James Frazier F000353 | rep | TN | 1961-01-03 | 1963-01-03 | Democrat | 3 | |||||||||||||
27317 | 27317 | Joseph Loser L000446 | rep | TN | 1961-01-03 | 1963-01-03 | Democrat | 5 | |||||||||||||
27476 | 27476 | Brazilla Reece R000108 | rep | TN | 1961-01-03 | 1963-01-03 | Republican | 1 | |||||||||||||
27477 | 27477 | Louise Reece R000109 | rep | TN | 1961-01-03 | 1963-01-03 | Republican | 1 | |||||||||||||
27629 | 27629 | Howard Baker B000062 | rep | TN | 1961-01-03 | 1963-01-03 | Republican | 2 | |||||||||||||
27734 | 27734 | Clifford Davis D000094 | rep | TN | 1961-01-03 | 1963-01-03 | Democrat | 9 | |||||||||||||
28305 | 28305 | Ross Bass B000223 | rep | TN | 1961-01-03 | 1963-01-03 | Democrat | 6 | |||||||||||||
28596 | 28596 | Thomas Murray M001114 | rep | TN | 1961-01-03 | 1963-01-03 | Democrat | 7 | |||||||||||||
29230 | 29230 | Robert Everett E000266 | rep | TN | 1961-01-03 | 1963-01-03 | Democrat | 8 | |||||||||||||
30928 | 30928 | Joseph Evins E000273 | rep | TN | 1961-01-03 | 1963-01-03 | Democrat | 4 | |||||||||||||
26222 | 26222 | Francis Case C000221 | sen | SD | 1957-01-03 | 1963-01-03 | 3 | Republican | |||||||||||||
27599 | 27599 | Joseph Bottum B000656 | sen | SD | 1962-07-09 | 1963-01-03 | 3 | Republican | appointment | ||||||||||||
29154 | 29154 | Ellis Berry B000416 | rep | SD | 1961-01-03 | 1963-01-03 | Republican | 2 | |||||||||||||
29435 | 29435 | Benjamin Reifel R000152 | rep | SD | 1961-01-03 | 1963-01-03 | Republican | 1 | |||||||||||||
27478 | 27478 | Corinne Riley R000259 | rep | SC | 1961-01-03 | 1963-01-03 | Democrat | 2 | |||||||||||||
27486 | 27486 | John Riley R000260 | rep | SC | 1961-01-03 | 1963-01-03 | Democrat | 2 | |||||||||||||
27865 | 27865 | Robert Hemphill H000471 | rep | SC | 1961-01-03 | 1963-01-03 | Democrat | 5 | |||||||||||||
27941 | 27941 | Olin Johnston J000195 | sen | SC | 1957-01-03 | 1963-01-03 | 3 | Democrat | |||||||||||||
28768 | 28768 | Robert Ashmore A000223 | rep | SC | 1961-01-03 | 1963-01-03 | Democrat | 4 | |||||||||||||
29453 | 29453 | Lucius Rivers R000280 | rep | SC | 1961-01-03 | 1963-01-03 | Democrat | 1 | |||||||||||||
29942 | 29942 | John McMillan M000568 | rep | SC | 1961-01-03 | 1963-01-03 | Democrat | 6 | |||||||||||||
30322 | 30322 | William Dorn D000434 | rep | SC | 1961-01-03 | 1963-01-03 | Democrat | 3 | |||||||||||||
28840 | 28840 | John Fogarty F000233 | rep | RI | 1961-01-03 | 1963-01-03 | Democrat | 2 | |||||||||||||
33748 | 33748 | Fernand St. Germain S000762 | rep | RI | 1961-01-03 | 1963-01-03 | Democrat | 1 | |||||||||||||
27779 | 27779 | Antonio Fernós-Isern F000087 | rep | PR | 1961-01-03 | 1963-01-03 | Popular Democrat | 0 | |||||||||||||
27203 | 27203 | Ivor Fenton F000075 | rep | PA | 1961-01-03 | 1963-01-03 | Republican | 12 | |||||||||||||
27215 | 27215 | Kathryn Granahan G000368 | rep | PA | 1961-01-03 | 1963-01-03 | Democrat | 2 | |||||||||||||
27275 | 27275 | Carroll Kearns K000032 | rep | PA | 1961-01-03 | 1963-01-03 | Republican | 24 | |||||||||||||
27395 | 27395 | Walter Mumma M001077 | rep | PA | 1961-01-03 | 1963-01-03 | Republican | 16 | |||||||||||||
27520 | 27520 | William Scranton S000193 | rep | PA | 1961-01-03 | 1963-01-03 | Republican | 10 | |||||||||||||
27583 | 27583 | James Van Zandt V000069 | rep | PA | 1961-01-03 | 1963-01-03 | Republican | 20 | |||||||||||||
27721 | 27721 | Joseph Clark C000444 | sen | PA | 1957-01-03 | 1963-01-03 | 3 | Democrat | |||||||||||||
27809 | 27809 | Leon Gavin G000102 | rep | PA | 1961-01-03 | 1963-01-03 | Republican | 23 |
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);