legislator_terms
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
238 rows where "end" is on date 1955-01-03 and party = "Republican"
This data as json, copyable, CSV (advanced)
Suggested facets: type, 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
24813 | 24813 | Guy Cordon C000774 | sen | OR | 1949-01-03 | 1955-01-03 | 2 | Republican | |||||||||||||
24831 | 24831 | Homer Ferguson F000081 | sen | MI | 1949-01-03 | 1955-01-03 | 2 | Republican | |||||||||||||
24845 | 24845 | Robert Hendrickson H000495 | sen | NJ | 1949-01-03 | 1955-01-03 | 2 | Republican | |||||||||||||
25571 | 25571 | Dwight Griswold G000481 | sen | NE | 1952-01-01 | 1955-01-03 | 2 | Republican | |||||||||||||
25584 | 25584 | Homer Angell A000257 | rep | OR | 1953-01-03 | 1955-01-03 | Republican | 3 | |||||||||||||
25600 | 25600 | Cecil Bishop B000486 | rep | IL | 1953-01-03 | 1955-01-03 | Republican | 25 | |||||||||||||
25601 | 25601 | Edward Bonin B000618 | rep | PA | 1953-01-03 | 1955-01-03 | Republican | 11 | |||||||||||||
25605 | 25605 | Ernest Bramblett B000762 | rep | CA | 1953-01-03 | 1955-01-03 | Republican | 13 | |||||||||||||
25620 | 25620 | Fred Busbey B001161 | rep | IL | 1953-01-03 | 1955-01-03 | Republican | 3 | |||||||||||||
25633 | 25633 | Kit Clardy C000416 | rep | MI | 1953-01-03 | 1955-01-03 | Republican | 6 | |||||||||||||
25637 | 25637 | William Cole C000614 | rep | MO | 1953-01-03 | 1955-01-03 | Republican | 6 | |||||||||||||
25662 | 25662 | Wesley D’Ewart D000281 | rep | MT | 1953-01-03 | 1955-01-03 | Republican | 2 | |||||||||||||
25669 | 25669 | Joseph Farrington F000034 | rep | HI | 1953-01-03 | 1955-01-03 | Republican | 0 | |||||||||||||
25675 | 25675 | James Golden G000258 | rep | KY | 1953-01-03 | 1955-01-03 | Republican | 8 | |||||||||||||
25681 | 25681 | Angier Goodwin G000297 | rep | MA | 1953-01-03 | 1955-01-03 | Republican | 8 | |||||||||||||
25689 | 25689 | Louis Graham G000360 | rep | PA | 1953-01-03 | 1955-01-03 | Republican | 25 | |||||||||||||
25695 | 25695 | Harold Hagen H000014 | rep | MN | 1953-01-03 | 1955-01-03 | Republican | 9 | |||||||||||||
25709 | 25709 | Jeffrey Hillelson H000616 | rep | MO | 1953-01-03 | 1955-01-03 | Republican | 4 | |||||||||||||
25723 | 25723 | Merlin Hull H000943 | rep | WI | 1953-01-03 | 1955-01-03 | Republican | 9 | |||||||||||||
25725 | 25725 | Allan Hunter H000979 | rep | CA | 1953-01-03 | 1955-01-03 | Republican | 12 | |||||||||||||
25733 | 25733 | Edgar Jonas J000207 | rep | IL | 1953-01-03 | 1955-01-03 | Republican | 12 | |||||||||||||
25736 | 25736 | Charles Kersten K000150 | rep | WI | 1953-01-03 | 1955-01-03 | Republican | 5 | |||||||||||||
25764 | 25764 | D. Merrill M000656 | rep | IN | 1953-01-03 | 1955-01-03 | Republican | 8 | |||||||||||||
25773 | 25773 | Charles Oakman O000004 | rep | MI | 1953-01-03 | 1955-01-03 | Republican | 17 | |||||||||||||
25782 | 25782 | C. Poulson P000475 | rep | CA | 1953-01-03 | 1955-01-03 | Republican | 24 | |||||||||||||
25807 | 25807 | Paul Shafer S000277 | rep | MI | 1953-01-03 | 1955-01-03 | Republican | 3 | |||||||||||||
25808 | 25808 | Frank Small S000499 | rep | MD | 1953-01-03 | 1955-01-03 | Republican | 5 | |||||||||||||
25817 | 25817 | Douglas Stringfellow S001006 | rep | UT | 1953-01-03 | 1955-01-03 | Republican | 1 | |||||||||||||
25823 | 25823 | Robert Upton U000032 | sen | NH | 1953-08-14 | 1955-01-03 | 3 | Republican | appointment | ||||||||||||
25824 | 25824 | Herbert Warburton W000123 | rep | DE | 1953-01-03 | 1955-01-03 | Republican | 0 | |||||||||||||
25832 | 25832 | Alvin Weichel W000252 | rep | OH | 1953-01-03 | 1955-01-03 | Republican | 13 | |||||||||||||
25846 | 25846 | Hazel Abel A000010 | sen | NE | 1954-01-01 | 1955-01-03 | 2 | Republican | |||||||||||||
25854 | 25854 | Eva Bowring B000709 | sen | NE | 1954-04-16 | 1955-01-03 | 2 | Republican | appointment | ||||||||||||
25855 | 25855 | Ernest Brown B000913 | sen | NV | 1954-10-01 | 1955-01-03 | 3 | Republican | appointment | ||||||||||||
25856 | 25856 | Edward Crippa C000906 | sen | WY | 1954-06-24 | 1955-01-03 | 2 | Republican | appointment | ||||||||||||
25864 | 25864 | Samuel Reynolds R000180 | sen | NE | 1954-07-03 | 1955-01-03 | 1 | Republican | appointment | ||||||||||||
25882 | 25882 | Henry Bridges B000823 | sen | NH | 1949-01-03 | 1955-01-03 | 2 | Republican | |||||||||||||
25900 | 25900 | Samuel Coon C000743 | rep | OR | 1953-01-03 | 1955-01-03 | Republican | 2 | |||||||||||||
25903 | 25903 | Shepard Crumpacker C000960 | rep | IN | 1953-01-03 | 1955-01-03 | Republican | 3 | |||||||||||||
25927 | 25927 | James Dolliver D000403 | rep | IA | 1953-01-03 | 1955-01-03 | Republican | 6 | |||||||||||||
25939 | 25939 | George Dondero D000411 | rep | MI | 1953-01-03 | 1955-01-03 | Republican | 18 | |||||||||||||
25949 | 25949 | Mathew Ellsworth E000146 | rep | OR | 1953-01-03 | 1955-01-03 | Republican | 4 | |||||||||||||
25951 | 25951 | Mary Farrington F000035 | rep | HI | 1953-01-03 | 1955-01-03 | Republican | 0 | |||||||||||||
25974 | 25974 | Ralph Gamble G000031 | rep | NY | 1953-01-03 | 1955-01-03 | Republican | 26 | |||||||||||||
25991 | 25991 | Thomas Hand H000154 | rep | NJ | 1953-01-03 | 1955-01-03 | Republican | 2 | |||||||||||||
26001 | 26001 | John Hinshaw H000640 | rep | CA | 1953-01-03 | 1955-01-03 | Republican | 20 | |||||||||||||
26005 | 26005 | Richard Hoffman H000689 | rep | IL | 1953-01-03 | 1955-01-03 | Republican | 10 | |||||||||||||
26020 | 26020 | Clifford Hope H000768 | rep | KS | 1953-01-03 | 1955-01-03 | Republican | 5 | |||||||||||||
26027 | 26027 | Justin Johnson J000157 | rep | CA | 1953-01-03 | 1955-01-03 | Republican | 11 | |||||||||||||
26034 | 26034 | Karl King K000208 | rep | PA | 1953-01-03 | 1955-01-03 | Republican | 8 | |||||||||||||
26046 | 26046 | Harold Lovre L000468 | rep | SD | 1953-01-03 | 1955-01-03 | Republican | 1 | |||||||||||||
26055 | 26055 | Thomas Martin M000199 | rep | IA | 1953-01-03 | 1955-01-03 | Republican | 1 | |||||||||||||
26075 | 26075 | Charles Nelson N000031 | rep | ME | 1953-01-03 | 1955-01-03 | Republican | 2 | |||||||||||||
26083 | 26083 | John Phillips P000309 | rep | CA | 1953-01-03 | 1955-01-03 | Republican | 29 | |||||||||||||
26102 | 26102 | Chauncey Reed R000111 | rep | IL | 1953-01-03 | 1955-01-03 | Republican | 14 | |||||||||||||
26126 | 26126 | Dewey Short S000377 | rep | MO | 1953-01-03 | 1955-01-03 | Republican | 7 | |||||||||||||
26129 | 26129 | Ruth Thompson T000216 | rep | MI | 1953-01-03 | 1955-01-03 | Republican | 9 | |||||||||||||
26134 | 26134 | Harold Velde V000082 | rep | IL | 1953-01-03 | 1955-01-03 | Republican | 18 | |||||||||||||
26147 | 26147 | Jesse Wolcott W000668 | rep | MI | 1953-01-03 | 1955-01-03 | Republican | 7 | |||||||||||||
26149 | 26149 | Clarence Young Y000032 | rep | NV | 1953-01-03 | 1955-01-03 | Republican | 0 | |||||||||||||
26159 | 26159 | John Allen A000133 | rep | CA | 1953-01-03 | 1955-01-03 | Republican | 7 | |||||||||||||
26175 | 26175 | August Andresen A000239 | rep | MN | 1953-01-03 | 1955-01-03 | Republican | 1 | |||||||||||||
26179 | 26179 | John Beamer B000276 | rep | IN | 1953-01-03 | 1955-01-03 | Republican | 5 | |||||||||||||
26186 | 26186 | Charles Brownson B000964 | rep | IN | 1953-01-03 | 1955-01-03 | Republican | 11 | |||||||||||||
26196 | 26196 | Usher Burdick B001079 | rep | ND | 1953-01-03 | 1955-01-03 | Republican | 0 | |||||||||||||
26208 | 26208 | Joseph Carrigg C000182 | rep | PA | 1953-01-03 | 1955-01-03 | Republican | 10 | |||||||||||||
26235 | 26235 | Cliff Clevenger C000515 | rep | OH | 1953-01-03 | 1955-01-03 | Republican | 5 | |||||||||||||
26247 | 26247 | William Cole C000617 | rep | NY | 1953-01-03 | 1955-01-03 | Republican | 37 | |||||||||||||
26268 | 26268 | Frederic Coudert C000804 | rep | NY | 1953-01-03 | 1955-01-03 | Republican | 17 | |||||||||||||
26271 | 26271 | Albert Cretella C000905 | rep | CT | 1953-01-03 | 1955-01-03 | Republican | 3 | |||||||||||||
26280 | 26280 | Paul Cunningham C000993 | rep | IA | 1953-01-03 | 1955-01-03 | Republican | 5 | |||||||||||||
26284 | 26284 | William Dawson D000155 | rep | UT | 1953-01-03 | 1955-01-03 | Republican | 2 | |||||||||||||
26297 | 26297 | James Devereux D000278 | rep | MD | 1953-01-03 | 1955-01-03 | Republican | 2 | |||||||||||||
26323 | 26323 | Myron George G000129 | rep | KS | 1953-01-03 | 1955-01-03 | Republican | 3 | |||||||||||||
26349 | 26349 | Ralph Gwinn G000541 | rep | NY | 1953-01-03 | 1955-01-03 | Republican | 27 | |||||||||||||
26357 | 26357 | Robert Hale H000036 | rep | ME | 1953-01-03 | 1955-01-03 | Republican | 1 | |||||||||||||
26362 | 26362 | Cecil Harden H000182 | rep | IN | 1953-01-03 | 1955-01-03 | Republican | 6 | |||||||||||||
26366 | 26366 | Robert Harrison H000275 | rep | NE | 1953-01-03 | 1955-01-03 | Republican | 3 | |||||||||||||
26387 | 26387 | John Heselton H000549 | rep | MA | 1953-01-03 | 1955-01-03 | Republican | 1 | |||||||||||||
26396 | 26396 | William Hill H000613 | rep | CO | 1953-01-03 | 1955-01-03 | Republican | 2 | |||||||||||||
26400 | 26400 | Patrick Hillings H000623 | rep | CA | 1953-01-03 | 1955-01-03 | Republican | 25 | |||||||||||||
26408 | 26408 | Otis Holmes H000740 | rep | WA | 1953-01-03 | 1955-01-03 | Republican | 4 | |||||||||||||
26411 | 26411 | DeWitt Hyde H001021 | rep | MD | 1953-01-03 | 1955-01-03 | Republican | 6 | |||||||||||||
26416 | 26416 | Benjamin James J000045 | rep | PA | 1953-01-03 | 1955-01-03 | Republican | 7 | |||||||||||||
26433 | 26433 | Thomas Jenkins J000088 | rep | OH | 1953-01-03 | 1955-01-03 | Republican | 10 | |||||||||||||
26443 | 26443 | Robert Kean K000029 | rep | NJ | 1953-01-03 | 1955-01-03 | Republican | 12 | |||||||||||||
26451 | 26451 | Bernard Kearney K000030 | rep | NY | 1953-01-03 | 1955-01-03 | Republican | 32 | |||||||||||||
26466 | 26466 | Otto Krueger K000332 | rep | ND | 1953-01-03 | 1955-01-03 | Republican | 0 | |||||||||||||
26479 | 26479 | Henry Latham L000108 | rep | NY | 1953-01-03 | 1955-01-03 | Republican | 4 | |||||||||||||
26489 | 26489 | Karl Le Compte L000157 | rep | IA | 1953-01-03 | 1955-01-03 | Republican | 4 | |||||||||||||
26501 | 26501 | Samuel McConnell M000354 | rep | PA | 1953-01-03 | 1955-01-03 | Republican | 13 | |||||||||||||
26511 | 26511 | J. McGregor M000460 | rep | OH | 1953-01-03 | 1955-01-03 | Republican | 17 | |||||||||||||
26516 | 26516 | William McVey M000609 | rep | IL | 1953-01-03 | 1955-01-03 | Republican | 4 | |||||||||||||
26524 | 26524 | Arthur Miller M000715 | rep | NE | 1953-01-03 | 1955-01-03 | Republican | 4 | |||||||||||||
26530 | 26530 | Edward Miller M000724 | rep | MD | 1953-01-03 | 1955-01-03 | Republican | 1 | |||||||||||||
26534 | 26534 | Albert Morano M000935 | rep | CT | 1953-01-03 | 1955-01-03 | Republican | 4 | |||||||||||||
26537 | 26537 | William Neal N000017 | rep | WV | 1953-01-03 | 1955-01-03 | Republican | 4 | |||||||||||||
26542 | 26542 | Donald Nicholson N000097 | rep | MA | 1953-01-03 | 1955-01-03 | Republican | 9 | |||||||||||||
26552 | 26552 | Joseph O’Hara O000056 | rep | MN | 1953-01-03 | 1955-01-03 | Republican | 2 | |||||||||||||
26558 | 26558 | James Patterson P000119 | rep | CT | 1953-01-03 | 1955-01-03 | Republican | 5 |
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);