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 phone
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
26200 | 26200 | Prescott Bush B001167 | sen | CT | 1957-01-03 | 1963-01-03 | 3 | Republican | |||||||||||||
26202 | 26202 | John Butler B001180 | sen | MD | 1957-01-03 | 1963-01-03 | 3 | Republican | |||||||||||||
26206 | 26206 | Homer Capehart C000128 | sen | IN | 1957-01-03 | 1963-01-03 | 3 | Republican | |||||||||||||
26213 | 26213 | John Carroll C000189 | sen | CO | 1957-01-03 | 1963-01-03 | 3 | Democrat | |||||||||||||
26222 | 26222 | Francis Case C000221 | sen | SD | 1957-01-03 | 1963-01-03 | 3 | Republican | |||||||||||||
26670 | 26670 | Alexander Wiley W000465 | sen | WI | 1957-01-03 | 1963-01-03 | 3 | Republican | |||||||||||||
26905 | 26905 | Oren Long L000425 | sen | HI | 1959-01-07 | 1963-01-03 | 3 | Democrat | |||||||||||||
27060 | 27060 | Benjamin Smith S000517 | sen | MA | 1960-12-27 | 1963-01-03 | 1 | Democrat | appointment | ||||||||||||
27067 | 27067 | Hugh Addonizio A000054 | rep | NJ | 1961-01-03 | 1963-01-03 | Democrat | 11 | |||||||||||||
27072 | 27072 | Hugh Alexander A000094 | rep | NC | 1961-01-03 | 1963-01-03 | Democrat | 9 | |||||||||||||
27074 | 27074 | Thomas Alford A000105 | rep | AR | 1961-01-03 | 1963-01-03 | Democrat | 5 | |||||||||||||
27086 | 27086 | Herman Andersen A000179 | rep | MN | 1961-01-03 | 1963-01-03 | Republican | 7 | |||||||||||||
27091 | 27091 | Victor Anfuso A000255 | rep | NY | 1961-01-03 | 1963-01-03 | Democrat | 8 | |||||||||||||
27099 | 27099 | Cleveland Bailey B000035 | rep | WV | 1961-01-03 | 1963-01-03 | Democrat | 3 | |||||||||||||
27103 | 27103 | Perkins Bass B000222 | rep | NH | 1961-01-03 | 1963-01-03 | Republican | 2 | |||||||||||||
27109 | 27109 | Iris Blitch B000561 | rep | GA | 1961-01-03 | 1963-01-03 | Democrat | 8 | |||||||||||||
27123 | 27123 | Frank Boykin B000725 | rep | AL | 1961-01-03 | 1963-01-03 | Democrat | 1 | |||||||||||||
27126 | 27126 | James Breeding B000791 | rep | KS | 1961-01-03 | 1963-01-03 | Democrat | 5 | |||||||||||||
27139 | 27139 | Overton Brooks B000884 | rep | LA | 1961-01-03 | 1963-01-03 | Democrat | 4 | |||||||||||||
27141 | 27141 | Frank Burke B001090 | rep | KY | 1961-01-03 | 1963-01-03 | Democrat | 3 | |||||||||||||
27153 | 27153 | Robert Chiperfield C000365 | rep | IL | 1961-01-03 | 1963-01-03 | Republican | 19 | |||||||||||||
27159 | 27159 | Marguerite Church C000389 | rep | IL | 1961-01-03 | 1963-01-03 | Republican | 13 | |||||||||||||
27162 | 27162 | Merwin Coad C000540 | rep | IA | 1961-01-03 | 1963-01-03 | Democrat | 6 | |||||||||||||
27164 | 27164 | Robert Cook C000725 | rep | OH | 1961-01-03 | 1963-01-03 | Democrat | 11 | |||||||||||||
27169 | 27169 | Laurence Curtis C001011 | rep | MA | 1961-01-03 | 1963-01-03 | Republican | 10 | |||||||||||||
27177 | 27177 | James Davis D000109 | rep | GA | 1961-01-03 | 1963-01-03 | Democrat | 5 | |||||||||||||
27180 | 27180 | Edwin Dooley D000425 | rep | NY | 1961-01-03 | 1963-01-03 | Republican | 26 | |||||||||||||
27184 | 27184 | Edwin Durno D000575 | rep | OR | 1961-01-03 | 1963-01-03 | Republican | 4 | |||||||||||||
27191 | 27191 | Henry Dworshak D000585 | sen | ID | 1961-01-03 | 1963-01-03 | 2 | Republican | |||||||||||||
27203 | 27203 | Ivor Fenton F000075 | rep | PA | 1961-01-03 | 1963-01-03 | Republican | 12 | |||||||||||||
27210 | 27210 | James Frazier F000353 | rep | TN | 1961-01-03 | 1963-01-03 | Democrat | 3 | |||||||||||||
27211 | 27211 | Peter Garland G000069 | rep | ME | 1961-01-03 | 1963-01-03 | Republican | 1 | |||||||||||||
27215 | 27215 | Kathryn Granahan G000368 | rep | PA | 1961-01-03 | 1963-01-03 | Democrat | 2 | |||||||||||||
27224 | 27224 | Burr Harrison H000264 | rep | VA | 1961-01-03 | 1963-01-03 | Democrat | 7 | |||||||||||||
27225 | 27225 | John Hickey H000561 | sen | WY | 1961-01-03 | 1963-01-03 | 2 | Democrat | appointment | ||||||||||||
27230 | 27230 | Edgar Hiestand H000568 | rep | CA | 1961-01-03 | 1963-01-03 | Republican | 21 | |||||||||||||
27244 | 27244 | Clare Hoffman H000683 | rep | MI | 1961-01-03 | 1963-01-03 | Republican | 4 | |||||||||||||
27249 | 27249 | Lester Holtzman H000753 | rep | NY | 1961-01-03 | 1963-01-03 | Democrat | 6 | |||||||||||||
27255 | 27255 | Frank Ikard I000007 | rep | TX | 1961-01-03 | 1963-01-03 | Democrat | 13 | |||||||||||||
27257 | 27257 | Thomas Johnson J000176 | rep | MD | 1961-01-03 | 1963-01-03 | Democrat | 1 | |||||||||||||
27267 | 27267 | Walter Judd J000278 | rep | MN | 1961-01-03 | 1963-01-03 | Republican | 5 | |||||||||||||
27275 | 27275 | Carroll Kearns K000032 | rep | PA | 1961-01-03 | 1963-01-03 | Republican | 24 | |||||||||||||
27298 | 27298 | Paul Kilday K000171 | rep | TX | 1961-01-03 | 1963-01-03 | Democrat | 20 | |||||||||||||
27301 | 27301 | Alvin Kitchin K000249 | rep | NC | 1961-01-03 | 1963-01-03 | Democrat | 8 | |||||||||||||
27303 | 27303 | Frank Kowalski K000320 | rep | CT | 1961-01-03 | 1963-01-03 | Democrat | 0 | |||||||||||||
27314 | 27314 | Thomas Lane L000065 | rep | MA | 1961-01-03 | 1963-01-03 | Democrat | 7 | |||||||||||||
27317 | 27317 | Joseph Loser L000446 | rep | TN | 1961-01-03 | 1963-01-03 | Democrat | 5 | |||||||||||||
27323 | 27323 | Thaddeus Machrowicz M000014 | rep | MI | 1961-01-03 | 1963-01-03 | Democrat | 1 | |||||||||||||
27330 | 27330 | Peter Mack M000020 | rep | IL | 1961-01-03 | 1963-01-03 | Democrat | 21 | |||||||||||||
27335 | 27335 | Donald Magnuson M000052 | rep | WA | 1961-01-03 | 1963-01-03 | Democrat | 7 | |||||||||||||
27342 | 27342 | Fred Marshall M000152 | rep | MN | 1961-01-03 | 1963-01-03 | Democrat | 6 | |||||||||||||
27355 | 27355 | Noah Mason M000224 | rep | IL | 1961-01-03 | 1963-01-03 | Republican | 15 | |||||||||||||
27364 | 27364 | Gordon McDonough M000414 | rep | CA | 1961-01-03 | 1963-01-03 | Republican | 15 | |||||||||||||
27368 | 27368 | Harold McSween M000605 | rep | LA | 1961-01-03 | 1963-01-03 | Democrat | 8 | |||||||||||||
27369 | 27369 | Walter McVey M000608 | rep | KS | 1961-01-03 | 1963-01-03 | Republican | 3 | |||||||||||||
27379 | 27379 | Chester Merrow M000664 | rep | NH | 1961-01-03 | 1963-01-03 | Republican | 1 | |||||||||||||
27381 | 27381 | Clement Miller M000719 | rep | CA | 1961-01-03 | 1963-01-03 | Democrat | 1 | |||||||||||||
27382 | 27382 | Tom Moorehead M000927 | rep | OH | 1961-01-03 | 1963-01-03 | Republican | 15 | |||||||||||||
27389 | 27389 | Morgan Moulder M001045 | rep | MO | 1961-01-03 | 1963-01-03 | Democrat | 11 | |||||||||||||
27395 | 27395 | Walter Mumma M001077 | rep | PA | 1961-01-03 | 1963-01-03 | Republican | 16 | |||||||||||||
27396 | 27396 | Maurice Murphy M001100 | sen | NH | 1961-12-07 | 1963-01-03 | 2 | Republican | appointment | ||||||||||||
27397 | 27397 | Catherine Norrell N000136 | rep | AR | 1961-01-03 | 1963-01-03 | Democrat | 6 | |||||||||||||
27409 | 27409 | William Norrell N000137 | rep | AR | 1961-01-03 | 1963-01-03 | Democrat | 6 | |||||||||||||
27410 | 27410 | Morris Peterson P000264 | rep | UT | 1961-01-03 | 1963-01-03 | Democrat | 1 | |||||||||||||
27415 | 27415 | Gracie Pfost P000287 | rep | ID | 1961-01-03 | 1963-01-03 | Democrat | 1 | |||||||||||||
27428 | 27428 | Louis Rabaut R000001 | rep | MI | 1961-01-03 | 1963-01-03 | Democrat | 14 | |||||||||||||
27433 | 27433 | John Ray R000077 | rep | NY | 1961-01-03 | 1963-01-03 | Republican | 15 | |||||||||||||
27458 | 27458 | Samuel Rayburn R000082 | rep | TX | 1961-01-03 | 1963-01-03 | Democrat | 4 | |||||||||||||
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 | |||||||||||||
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 | |||||||||||||
27501 | 27501 | J. Rutherford R000547 | rep | TX | 1961-01-03 | 1963-01-03 | Democrat | 16 | |||||||||||||
27508 | 27508 | Alfred Santangelo S000057 | rep | NY | 1961-01-03 | 1963-01-03 | Democrat | 18 | |||||||||||||
27511 | 27511 | Dalip Saund S000075 | rep | CA | 1961-01-03 | 1963-01-03 | Democrat | 29 | |||||||||||||
27516 | 27516 | Gordon Scherer S000120 | rep | OH | 1961-01-03 | 1963-01-03 | Republican | 1 | |||||||||||||
27520 | 27520 | William Scranton S000193 | rep | PA | 1961-01-03 | 1963-01-03 | Republican | 10 | |||||||||||||
27526 | 27526 | Horace Seely-Brown S000224 | rep | CT | 1961-01-03 | 1963-01-03 | Republican | 2 | |||||||||||||
27532 | 27532 | Frank Smith S000533 | rep | MS | 1961-01-03 | 1963-01-03 | Democrat | 3 | |||||||||||||
27548 | 27548 | Brent Spence S000717 | rep | KY | 1961-01-03 | 1963-01-03 | Democrat | 5 | |||||||||||||
27568 | 27568 | John Taber T000001 | rep | NY | 1961-01-03 | 1963-01-03 | Republican | 36 | |||||||||||||
27572 | 27572 | Stewart Udall U000002 | rep | AZ | 1961-01-03 | 1963-01-03 | Democrat | 2 | |||||||||||||
27583 | 27583 | James Van Zandt V000069 | rep | PA | 1961-01-03 | 1963-01-03 | Republican | 20 | |||||||||||||
27587 | 27587 | Phillip Weaver W000228 | rep | NE | 1961-01-03 | 1963-01-03 | Republican | 1 | |||||||||||||
27589 | 27589 | Jessica Weis W000256 | rep | NY | 1961-01-03 | 1963-01-03 | Republican | 38 | |||||||||||||
27593 | 27593 | Herbert Zelenko Z000003 | rep | NY | 1961-01-03 | 1963-01-03 | Democrat | 21 | |||||||||||||
27599 | 27599 | Joseph Bottum B000656 | sen | SD | 1962-07-09 | 1963-01-03 | 3 | Republican | appointment | ||||||||||||
27606 | 27606 | Bruce Alger A000106 | rep | TX | 1961-01-03 | 1963-01-03 | Republican | 5 | |||||||||||||
27617 | 27617 | James Auchincloss A000227 | rep | NJ | 1961-01-03 | 1963-01-03 | Republican | 3 | |||||||||||||
27622 | 27622 | William Avery A000228 | rep | KS | 1961-01-03 | 1963-01-03 | Republican | 1 | |||||||||||||
27629 | 27629 | Howard Baker B000062 | rep | TN | 1961-01-03 | 1963-01-03 | Republican | 2 | |||||||||||||
27633 | 27633 | Robert Barry B000190 | rep | NY | 1961-01-03 | 1963-01-03 | Republican | 27 | |||||||||||||
27639 | 27639 | Frank Becker B000292 | rep | NY | 1961-01-03 | 1963-01-03 | Republican | 3 | |||||||||||||
27641 | 27641 | Ralph Beermann B000310 | rep | NE | 1961-01-03 | 1963-01-03 | Republican | 3 | |||||||||||||
27651 | 27651 | John Bennett B000377 | rep | MI | 1961-01-03 | 1963-01-03 | Republican | 12 | |||||||||||||
27657 | 27657 | Daniel Brewster B000813 | rep | MD | 1961-01-03 | 1963-01-03 | Democrat | 2 | |||||||||||||
27659 | 27659 | James Bromwell B000867 | rep | IA | 1961-01-03 | 1963-01-03 | Republican | 2 | |||||||||||||
27661 | 27661 | Donald Bruce B000969 | rep | IN | 1961-01-03 | 1963-01-03 | Republican | 11 | |||||||||||||
27676 | 27676 | Charles Buckley B001024 | rep | NY | 1961-01-03 | 1963-01-03 | Democrat | 24 | |||||||||||||
27698 | 27698 | Clarence Cannon C000117 | rep | MO | 1961-01-03 | 1963-01-03 | Democrat | 9 |
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);