legislator_terms
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
229 rows where "end" is on date 1953-01-03 and party = "Republican"
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
24243 | 24243 | Harry Cain C000021 | sen | WA | 1947-01-03 | 1953-01-03 | 1 | Republican | |||||||||||||
24285 | 24285 | Ralph Brewster B000816 | sen | ME | 1947-01-03 | 1953-01-03 | 1 | Republican | |||||||||||||
24369 | 24369 | Zales Ecton E000037 | sen | MT | 1947-01-03 | 1953-01-03 | 1 | Republican | |||||||||||||
24513 | 24513 | James Kem K000082 | sen | MO | 1947-01-03 | 1953-01-03 | 1 | Republican | |||||||||||||
24558 | 24558 | Henry Lodge L000394 | sen | MA | 1947-01-03 | 1953-01-03 | 1 | Republican | |||||||||||||
25111 | 25111 | Fred Aandahl A000001 | rep | ND | 1951-01-03 | 1953-01-03 | Republican | 0 | |||||||||||||
25126 | 25126 | John Anderson A000196 | rep | CA | 1951-01-03 | 1953-01-03 | Republican | 8 | |||||||||||||
25127 | 25127 | Orland Armstrong A000218 | rep | MO | 1951-01-03 | 1953-01-03 | Republican | 6 | |||||||||||||
25129 | 25129 | Claude Bakewell B000080 | rep | MO | 1951-01-03 | 1953-01-03 | Republican | 11 | |||||||||||||
25145 | 25145 | William Blackney B000515 | rep | MI | 1951-01-03 | 1953-01-03 | Republican | 6 | |||||||||||||
25154 | 25154 | Walter Brehm B000794 | rep | OH | 1951-01-03 | 1953-01-03 | Republican | 11 | |||||||||||||
25162 | 25162 | Howard Buffett B001039 | rep | NE | 1951-01-03 | 1953-01-03 | Republican | 2 | |||||||||||||
25170 | 25170 | John Butler B001179 | rep | NY | 1951-01-03 | 1953-01-03 | Republican | 44 | |||||||||||||
25184 | 25184 | Albert Cole C000606 | rep | KS | 1951-01-03 | 1953-01-03 | Republican | 1 | |||||||||||||
25211 | 25211 | Fred Crawford C000889 | rep | MI | 1951-01-03 | 1953-01-03 | Republican | 8 | |||||||||||||
25212 | 25212 | Harmar Denny D000249 | rep | PA | 1951-01-03 | 1953-01-03 | Republican | 29 | |||||||||||||
25248 | 25248 | Charles Eaton E000023 | rep | NJ | 1951-01-03 | 1953-01-03 | Republican | 5 | |||||||||||||
25255 | 25255 | Charles Elston E000160 | rep | OH | 1951-01-03 | 1953-01-03 | Republican | 1 | |||||||||||||
25261 | 25261 | Frank Fellows F000066 | rep | ME | 1951-01-03 | 1953-01-03 | Republican | 3 | |||||||||||||
25277 | 25277 | Wilson Gillette G000206 | rep | PA | 1951-01-03 | 1953-01-03 | Republican | 14 | |||||||||||||
25298 | 25298 | Edwin Hall H000050 | rep | NY | 1951-01-03 | 1953-01-03 | Republican | 37 | |||||||||||||
25305 | 25305 | Leonard Hall H000060 | rep | NY | 1951-01-03 | 1953-01-03 | Republican | 2 | |||||||||||||
25326 | 25326 | Christian Herter H000548 | rep | MA | 1951-01-03 | 1953-01-03 | Republican | 10 | |||||||||||||
25334 | 25334 | Edward Jenison J000080 | rep | IL | 1951-01-03 | 1953-01-03 | Republican | 23 | |||||||||||||
25410 | 25410 | Reid Murray M001112 | rep | WI | 1951-01-03 | 1953-01-03 | Republican | 7 | |||||||||||||
25453 | 25453 | Robert Ross R000453 | rep | NY | 1951-01-03 | 1953-01-03 | Republican | 5 | |||||||||||||
25486 | 25486 | George Schwabe S000155 | rep | OK | 1951-01-03 | 1953-01-03 | Republican | 1 | |||||||||||||
25489 | 25489 | Hardie Scott S000172 | rep | PA | 1951-01-03 | 1953-01-03 | Republican | 3 | |||||||||||||
25490 | 25490 | Frederick Seaton S000214 | sen | NE | 1951-12-10 | 1953-01-03 | 2 | Republican | appointment | ||||||||||||
25491 | 25491 | Edward Sittler S000461 | rep | PA | 1951-01-03 | 1953-01-03 | Republican | 23 | |||||||||||||
25500 | 25500 | Karl Stefan S000845 | rep | NE | 1951-01-03 | 1953-01-03 | Republican | 3 | |||||||||||||
25510 | 25510 | Lowell Stockman S000936 | rep | OR | 1951-01-03 | 1953-01-03 | Republican | 2 | |||||||||||||
25530 | 25530 | Harry Towe T000320 | rep | NJ | 1951-01-03 | 1953-01-03 | Republican | 9 | |||||||||||||
25535 | 25535 | Richard Vail V000003 | rep | IL | 1951-01-03 | 1953-01-03 | Republican | 2 | |||||||||||||
25536 | 25536 | Albert Vaughn V000077 | rep | PA | 1951-01-03 | 1953-01-03 | Republican | 8 | |||||||||||||
25541 | 25541 | Thomas Werdel W000298 | rep | CA | 1951-01-03 | 1953-01-03 | Republican | 10 | |||||||||||||
25551 | 25551 | John Wood W000700 | rep | ID | 1951-01-03 | 1953-01-03 | Republican | 1 | |||||||||||||
25568 | 25568 | Roy Woodruff W000718 | rep | MI | 1951-01-03 | 1953-01-03 | Republican | 10 | |||||||||||||
25575 | 25575 | Charles Potter P000460 | sen | MI | 1952-11-05 | 1953-01-03 | 1 | Republican | |||||||||||||
25583 | 25583 | Homer Angell A000257 | rep | OR | 1951-01-03 | 1953-01-03 | Republican | 3 | |||||||||||||
25599 | 25599 | Cecil Bishop B000486 | rep | IL | 1951-01-03 | 1953-01-03 | Republican | 26 | |||||||||||||
25604 | 25604 | Ernest Bramblett B000762 | rep | CA | 1951-01-03 | 1953-01-03 | Republican | 11 | |||||||||||||
25606 | 25606 | John Bricker B000820 | sen | OH | 1947-01-03 | 1953-01-03 | 1 | Republican | |||||||||||||
25619 | 25619 | Fred Busbey B001161 | rep | IL | 1951-01-03 | 1953-01-03 | Republican | 3 | |||||||||||||
25622 | 25622 | Hugh Butler B001177 | sen | NE | 1947-01-03 | 1953-01-03 | 1 | Republican | |||||||||||||
25661 | 25661 | Wesley D’Ewart D000281 | rep | MT | 1951-01-03 | 1953-01-03 | Republican | 2 | |||||||||||||
25668 | 25668 | Joseph Farrington F000034 | rep | HI | 1951-01-03 | 1953-01-03 | Republican | 0 | |||||||||||||
25671 | 25671 | Ralph Flanders F000190 | sen | VT | 1947-01-03 | 1953-01-03 | 1 | Republican | |||||||||||||
25674 | 25674 | James Golden G000258 | rep | KY | 1951-01-03 | 1953-01-03 | Republican | 9 | |||||||||||||
25680 | 25680 | Angier Goodwin G000297 | rep | MA | 1951-01-03 | 1953-01-03 | Republican | 8 | |||||||||||||
25688 | 25688 | Louis Graham G000360 | rep | PA | 1951-01-03 | 1953-01-03 | Republican | 25 | |||||||||||||
25694 | 25694 | Harold Hagen H000014 | rep | MN | 1951-01-03 | 1953-01-03 | Republican | 9 | |||||||||||||
25722 | 25722 | Merlin Hull H000943 | rep | WI | 1951-01-03 | 1953-01-03 | Republican | 9 | |||||||||||||
25724 | 25724 | Allan Hunter H000979 | rep | CA | 1951-01-03 | 1953-01-03 | Republican | 9 | |||||||||||||
25726 | 25726 | Irving Ives I000050 | sen | NY | 1947-01-03 | 1953-01-03 | 1 | Republican | |||||||||||||
25729 | 25729 | William Jenner J000093 | sen | IN | 1947-01-03 | 1953-01-03 | 1 | Republican | |||||||||||||
25732 | 25732 | Edgar Jonas J000207 | rep | IL | 1951-01-03 | 1953-01-03 | Republican | 12 | |||||||||||||
25735 | 25735 | Charles Kersten K000150 | rep | WI | 1951-01-03 | 1953-01-03 | Republican | 5 | |||||||||||||
25741 | 25741 | William Knowland K000292 | sen | CA | 1947-01-03 | 1953-01-03 | 1 | Republican | |||||||||||||
25744 | 25744 | William Langer L000070 | sen | ND | 1947-01-03 | 1953-01-03 | 1 | Republican | |||||||||||||
25758 | 25758 | George Malone M000086 | sen | NV | 1947-01-03 | 1953-01-03 | 1 | Republican | |||||||||||||
25760 | 25760 | Edward Martin M000177 | sen | PA | 1947-01-03 | 1953-01-03 | 1 | Republican | |||||||||||||
25762 | 25762 | Joseph McCarthy M000315 | sen | WI | 1947-01-03 | 1953-01-03 | 1 | Republican | |||||||||||||
25781 | 25781 | C. Poulson P000475 | rep | CA | 1951-01-03 | 1953-01-03 | Republican | 13 | |||||||||||||
25783 | 25783 | William Purtell P000575 | sen | CT | 1952-08-29 | 1953-01-03 | 3 | Republican | appointment | ||||||||||||
25806 | 25806 | Paul Shafer S000277 | rep | MI | 1951-01-03 | 1953-01-03 | Republican | 3 | |||||||||||||
25810 | 25810 | Howard Smith S000553 | sen | NJ | 1947-01-03 | 1953-01-03 | 1 | Republican | |||||||||||||
25821 | 25821 | Edward Thye T000259 | sen | MN | 1947-01-03 | 1953-01-03 | 1 | Republican | |||||||||||||
25825 | 25825 | Arthur Watkins W000190 | sen | UT | 1947-01-03 | 1953-01-03 | 1 | Republican | |||||||||||||
25831 | 25831 | Alvin Weichel W000252 | rep | OH | 1951-01-03 | 1953-01-03 | Republican | 13 | |||||||||||||
25852 | 25852 | George Bender B000356 | rep | OH | 1951-01-03 | 1953-01-03 | Republican | 0 | |||||||||||||
25902 | 25902 | Shepard Crumpacker C000960 | rep | IN | 1951-01-03 | 1953-01-03 | Republican | 3 | |||||||||||||
25926 | 25926 | James Dolliver D000403 | rep | IA | 1951-01-03 | 1953-01-03 | Republican | 6 | |||||||||||||
25938 | 25938 | George Dondero D000411 | rep | MI | 1951-01-03 | 1953-01-03 | Republican | 17 | |||||||||||||
25948 | 25948 | Mathew Ellsworth E000146 | rep | OR | 1951-01-03 | 1953-01-03 | Republican | 4 | |||||||||||||
25973 | 25973 | Ralph Gamble G000031 | rep | NY | 1951-01-03 | 1953-01-03 | Republican | 28 | |||||||||||||
25990 | 25990 | Thomas Hand H000154 | rep | NJ | 1951-01-03 | 1953-01-03 | Republican | 2 | |||||||||||||
26000 | 26000 | John Hinshaw H000640 | rep | CA | 1951-01-03 | 1953-01-03 | Republican | 20 | |||||||||||||
26004 | 26004 | Richard Hoffman H000689 | rep | IL | 1951-01-03 | 1953-01-03 | Republican | 10 | |||||||||||||
26019 | 26019 | Clifford Hope H000768 | rep | KS | 1951-01-03 | 1953-01-03 | Republican | 5 | |||||||||||||
26026 | 26026 | Justin Johnson J000157 | rep | CA | 1951-01-03 | 1953-01-03 | Republican | 3 | |||||||||||||
26033 | 26033 | Karl King K000208 | rep | PA | 1951-01-03 | 1953-01-03 | Republican | 8 | |||||||||||||
26045 | 26045 | Harold Lovre L000468 | rep | SD | 1951-01-03 | 1953-01-03 | Republican | 1 | |||||||||||||
26054 | 26054 | Thomas Martin M000199 | rep | IA | 1951-01-03 | 1953-01-03 | Republican | 1 | |||||||||||||
26074 | 26074 | Charles Nelson N000031 | rep | ME | 1951-01-03 | 1953-01-03 | Republican | 2 | |||||||||||||
26082 | 26082 | John Phillips P000309 | rep | CA | 1951-01-03 | 1953-01-03 | Republican | 22 | |||||||||||||
26101 | 26101 | Chauncey Reed R000111 | rep | IL | 1951-01-03 | 1953-01-03 | Republican | 14 | |||||||||||||
26125 | 26125 | Dewey Short S000377 | rep | MO | 1951-01-03 | 1953-01-03 | Republican | 7 | |||||||||||||
26128 | 26128 | Ruth Thompson T000216 | rep | MI | 1951-01-03 | 1953-01-03 | Republican | 9 | |||||||||||||
26133 | 26133 | Harold Velde V000082 | rep | IL | 1951-01-03 | 1953-01-03 | Republican | 18 | |||||||||||||
26146 | 26146 | Jesse Wolcott W000668 | rep | MI | 1951-01-03 | 1953-01-03 | Republican | 7 | |||||||||||||
26158 | 26158 | John Allen A000133 | rep | CA | 1951-01-03 | 1953-01-03 | Republican | 7 | |||||||||||||
26174 | 26174 | August Andresen A000239 | rep | MN | 1951-01-03 | 1953-01-03 | Republican | 1 | |||||||||||||
26178 | 26178 | John Beamer B000276 | rep | IN | 1951-01-03 | 1953-01-03 | Republican | 5 | |||||||||||||
26185 | 26185 | Charles Brownson B000964 | rep | IN | 1951-01-03 | 1953-01-03 | Republican | 11 | |||||||||||||
26195 | 26195 | Usher Burdick B001079 | rep | ND | 1951-01-03 | 1953-01-03 | Republican | 0 | |||||||||||||
26207 | 26207 | Joseph Carrigg C000182 | rep | PA | 1951-01-03 | 1953-01-03 | Republican | 14 | |||||||||||||
26234 | 26234 | Cliff Clevenger C000515 | rep | OH | 1951-01-03 | 1953-01-03 | Republican | 5 | |||||||||||||
26246 | 26246 | William Cole C000617 | rep | NY | 1951-01-03 | 1953-01-03 | Republican | 39 | |||||||||||||
26267 | 26267 | Frederic Coudert C000804 | rep | NY | 1951-01-03 | 1953-01-03 | Republican | 17 |
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);