legislator_terms
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
194 rows where "end" is on date 1963-01-03 and party = "Republican"
This data as json, copyable, CSV (advanced)
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 | |||||||||||||
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 | |||||||||||||
27086 | 27086 | Herman Andersen A000179 | rep | MN | 1961-01-03 | 1963-01-03 | Republican | 7 | |||||||||||||
27103 | 27103 | Perkins Bass B000222 | rep | NH | 1961-01-03 | 1963-01-03 | Republican | 2 | |||||||||||||
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 | |||||||||||||
27169 | 27169 | Laurence Curtis C001011 | rep | MA | 1961-01-03 | 1963-01-03 | Republican | 10 | |||||||||||||
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 | |||||||||||||
27211 | 27211 | Peter Garland G000069 | rep | ME | 1961-01-03 | 1963-01-03 | Republican | 1 | |||||||||||||
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 | |||||||||||||
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 | |||||||||||||
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 | |||||||||||||
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 | |||||||||||||
27382 | 27382 | Tom Moorehead M000927 | rep | OH | 1961-01-03 | 1963-01-03 | Republican | 15 | |||||||||||||
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 | ||||||||||||
27433 | 27433 | John Ray R000077 | rep | NY | 1961-01-03 | 1963-01-03 | Republican | 15 | |||||||||||||
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 | |||||||||||||
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 | |||||||||||||
27568 | 27568 | John Taber T000001 | rep | NY | 1961-01-03 | 1963-01-03 | Republican | 36 | |||||||||||||
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 | |||||||||||||
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 | |||||||||||||
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 | |||||||||||||
27708 | 27708 | Frank Carlson C000154 | sen | KS | 1957-01-03 | 1963-01-03 | 3 | Republican | |||||||||||||
27719 | 27719 | John Chenoweth C000346 | rep | CO | 1961-01-03 | 1963-01-03 | Republican | 3 | |||||||||||||
27740 | 27740 | Steven Derounian D000266 | rep | NY | 1961-01-03 | 1963-01-03 | Republican | 2 | |||||||||||||
27751 | 27751 | Everett Dirksen D000360 | sen | IL | 1957-01-03 | 1963-01-03 | 3 | Republican | |||||||||||||
27809 | 27809 | Leon Gavin G000102 | rep | PA | 1961-01-03 | 1963-01-03 | Republican | 23 | |||||||||||||
27814 | 27814 | Milton Glenn G000237 | rep | NJ | 1961-01-03 | 1963-01-03 | Republican | 2 | |||||||||||||
27869 | 27869 | Bourke Hickenlooper H000559 | sen | IA | 1957-01-03 | 1963-01-03 | 3 | Republican | |||||||||||||
27894 | 27894 | Charles Hoeven H000678 | rep | IA | 1961-01-03 | 1963-01-03 | Republican | 8 | |||||||||||||
27897 | 27897 | Elmer Hoffman H000684 | rep | IL | 1961-01-03 | 1963-01-03 | Republican | 14 | |||||||||||||
27908 | 27908 | Walter Horan H000786 | rep | WA | 1961-01-03 | 1963-01-03 | Republican | 5 | |||||||||||||
27926 | 27926 | Benton Jensen J000100 | rep | IA | 1961-01-03 | 1963-01-03 | Republican | 7 | |||||||||||||
27931 | 27931 | August Johansen J000109 | rep | MI | 1961-01-03 | 1963-01-03 | Republican | 3 | |||||||||||||
27961 | 27961 | Clarence Kilburn K000170 | rep | NY | 1961-01-03 | 1963-01-03 | Republican | 33 | |||||||||||||
27972 | 27972 | Victor Knox K000298 | rep | MI | 1961-01-03 | 1963-01-03 | Republican | 11 | |||||||||||||
27975 | 27975 | Thomas Kuchel K000335 | sen | CA | 1957-01-03 | 1963-01-03 | 3 | Republican | |||||||||||||
28003 | 28003 | Clifford McIntire M000478 | rep | ME | 1961-01-03 | 1963-01-03 | Republican | 3 | |||||||||||||
28011 | 28011 | George Meader M000620 | rep | MI | 1961-01-03 | 1963-01-03 | Republican | 2 | |||||||||||||
28018 | 28018 | William Miller M000762 | rep | NY | 1961-01-03 | 1963-01-03 | Republican | 40 | |||||||||||||
28021 | 28021 | William Milliken M000770 | rep | PA | 1961-01-03 | 1963-01-03 | Republican | 7 | |||||||||||||
28039 | 28039 | Thruston Morton M001022 | sen | KY | 1957-01-03 | 1963-01-03 | 3 | Republican | |||||||||||||
28049 | 28049 | Albin Norblad N000133 | rep | OR | 1961-01-03 | 1963-01-03 | Republican | 1 | |||||||||||||
28051 | 28051 | Hjalmar Nygaard N000178 | rep | ND | 1961-01-03 | 1963-01-03 | Republican | 0 | |||||||||||||
28074 | 28074 | Frank Osmers O000120 | rep | NJ | 1961-01-03 | 1963-01-03 | Republican | 9 | |||||||||||||
28081 | 28081 | Harold Ostertag O000121 | rep | NY | 1961-01-03 | 1963-01-03 | Republican | 39 | |||||||||||||
28093 | 28093 | John Pillion P000352 | rep | NY | 1961-01-03 | 1963-01-03 | Republican | 42 | |||||||||||||
28113 | 28113 | Roy Riehlman R000250 | rep | NY | 1961-01-03 | 1963-01-03 | Republican | 35 | |||||||||||||
28129 | 28129 | Paul Schenck S000117 | rep | OH | 1961-01-03 | 1963-01-03 | Republican | 3 | |||||||||||||
28154 | 28154 | Don Short S000378 | rep | ND | 1961-01-03 | 1963-01-03 | Republican | 0 | |||||||||||||
28156 | 28156 | Abner Sibal S000395 | rep | CT | 1961-01-03 | 1963-01-03 | Republican | 4 | |||||||||||||
28161 | 28161 | Eugene Siler S000408 | rep | KY | 1961-01-03 | 1963-01-03 | Republican | 8 | |||||||||||||
28175 | 28175 | Katharine St. George S000764 | rep | NY | 1961-01-03 | 1963-01-03 | Republican | 28 | |||||||||||||
28194 | 28194 | Thor Tollefson T000298 | rep | WA | 1961-01-03 | 1963-01-03 | Republican | 6 | |||||||||||||
28201 | 28201 | William Van Pelt V000051 | rep | WI | 1961-01-03 | 1963-01-03 | Republican | 6 | |||||||||||||
28230 | 28230 | George Wallhauser W000089 | rep | NJ | 1961-01-03 | 1963-01-03 | Republican | 12 | |||||||||||||
28254 | 28254 | Alfred Westland W000310 | rep | WA | 1961-01-03 | 1963-01-03 | Republican | 2 | |||||||||||||
28261 | 28261 | James Wharton W000323 | rep | NY | 1961-01-03 | 1963-01-03 | Republican | 29 | |||||||||||||
28281 | 28281 | Earl Wilson W000572 | rep | IN | 1961-01-03 | 1963-01-03 | Republican | 9 | |||||||||||||
28313 | 28313 | John Baldwin B000092 | rep | CA | 1961-01-03 | 1963-01-03 | Republican | 6 | |||||||||||||
28354 | 28354 | Clarence Brown B000909 | rep | OH | 1961-01-03 | 1963-01-03 | Republican | 7 | |||||||||||||
28393 | 28393 | Willard Curtin C001005 | rep | PA | 1961-01-03 | 1963-01-03 | Republican | 8 | |||||||||||||
28403 | 28403 | Paul Dague D000004 | rep | PA | 1961-01-03 | 1963-01-03 | Republican | 9 | |||||||||||||
28419 | 28419 | Robert Ellsworth E000148 | rep | KS | 1961-01-03 | 1963-01-03 | Republican | 2 | |||||||||||||
28466 | 28466 | Ralph Harvey H000310 | rep | IN | 1961-01-03 | 1963-01-03 | Republican | 10 | |||||||||||||
28518 | 28518 | John Kunkel K000341 | rep | PA | 1961-01-03 | 1963-01-03 | Republican | 16 | |||||||||||||
28522 | 28522 | John Lindsay L000326 | rep | NY | 1961-01-03 | 1963-01-03 | Republican | 17 | |||||||||||||
28547 | 28547 | Joseph Martin M000191 | rep | MA | 1961-01-03 | 1963-01-03 | Republican | 14 | |||||||||||||
28727 | 28727 | Stanley Tupper T000411 | rep | ME | 1961-01-03 | 1963-01-03 | Republican | 2 | |||||||||||||
28798 | 28798 | Frances Bolton B000607 | rep | OH | 1961-01-03 | 1963-01-03 | Republican | 22 | |||||||||||||
28812 | 28812 | Thomas Curtis C001014 | rep | MO | 1961-01-03 | 1963-01-03 | Republican | 2 | |||||||||||||
28826 | 28826 | Paul Fino F000137 | rep | NY | 1961-01-03 | 1963-01-03 | Republican | 25 | |||||||||||||
28873 | 28873 | Charles Halleck H000081 | rep | IN | 1961-01-03 | 1963-01-03 | Republican | 2 | |||||||||||||
28892 | 28892 | William Harrison H000278 | rep | WY | 1961-01-03 | 1963-01-03 | Republican | 0 | |||||||||||||
28968 | 28968 | Arch Moore M000892 | rep | WV | 1961-01-03 | 1963-01-03 | Republican | 1 |
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);