legislator_terms
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
218 rows where party = "Republican" and "start" is on date 1957-01-03
This data as json, copyable, CSV (advanced)
Suggested facets: end
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
26161 | 26161 | John Allen A000133 | rep | CA | 1957-01-03 | 1959-01-03 | Republican | 7 | |||||||||||||
26177 | 26177 | August Andresen A000239 | rep | MN | 1957-01-03 | 1959-01-03 | Republican | 1 | |||||||||||||
26181 | 26181 | John Beamer B000276 | rep | IN | 1957-01-03 | 1959-01-03 | Republican | 5 | |||||||||||||
26188 | 26188 | Charles Brownson B000964 | rep | IN | 1957-01-03 | 1959-01-03 | Republican | 11 | |||||||||||||
26198 | 26198 | Usher Burdick B001079 | rep | ND | 1957-01-03 | 1959-01-03 | Republican | 0 | |||||||||||||
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 | |||||||||||||
26203 | 26203 | Emmet Byrne B001211 | rep | IL | 1957-01-03 | 1959-01-03 | Republican | 3 | |||||||||||||
26206 | 26206 | Homer Capehart C000128 | sen | IN | 1957-01-03 | 1963-01-03 | 3 | Republican | |||||||||||||
26210 | 26210 | Joseph Carrigg C000182 | rep | PA | 1957-01-03 | 1959-01-03 | Republican | 10 | |||||||||||||
26222 | 26222 | Francis Case C000221 | sen | SD | 1957-01-03 | 1963-01-03 | 3 | Republican | |||||||||||||
26237 | 26237 | Cliff Clevenger C000515 | rep | OH | 1957-01-03 | 1959-01-03 | Republican | 5 | |||||||||||||
26249 | 26249 | William Cole C000617 | rep | NY | 1957-01-03 | 1959-01-03 | Republican | 37 | |||||||||||||
26270 | 26270 | Frederic Coudert C000804 | rep | NY | 1957-01-03 | 1959-01-03 | Republican | 17 | |||||||||||||
26273 | 26273 | Albert Cretella C000905 | rep | CT | 1957-01-03 | 1959-01-03 | Republican | 3 | |||||||||||||
26282 | 26282 | Paul Cunningham C000993 | rep | IA | 1957-01-03 | 1959-01-03 | Republican | 5 | |||||||||||||
26286 | 26286 | William Dawson D000155 | rep | UT | 1957-01-03 | 1959-01-03 | Republican | 2 | |||||||||||||
26295 | 26295 | David Dennison D000246 | rep | OH | 1957-01-03 | 1959-01-03 | Republican | 11 | |||||||||||||
26299 | 26299 | James Devereux D000278 | rep | MD | 1957-01-03 | 1959-01-03 | Republican | 2 | |||||||||||||
26325 | 26325 | Myron George G000129 | rep | KS | 1957-01-03 | 1959-01-03 | Republican | 3 | |||||||||||||
26351 | 26351 | Ralph Gwinn G000541 | rep | NY | 1957-01-03 | 1959-01-03 | Republican | 27 | |||||||||||||
26359 | 26359 | Robert Hale H000036 | rep | ME | 1957-01-03 | 1959-01-03 | Republican | 1 | |||||||||||||
26364 | 26364 | Cecil Harden H000182 | rep | IN | 1957-01-03 | 1959-01-03 | Republican | 6 | |||||||||||||
26368 | 26368 | Robert Harrison H000275 | rep | NE | 1957-01-03 | 1959-01-03 | Republican | 3 | |||||||||||||
26369 | 26369 | Harry Haskell H000318 | rep | DE | 1957-01-03 | 1959-01-03 | Republican | 0 | |||||||||||||
26389 | 26389 | John Heselton H000549 | rep | MA | 1957-01-03 | 1959-01-03 | Republican | 1 | |||||||||||||
26398 | 26398 | William Hill H000613 | rep | CO | 1957-01-03 | 1959-01-03 | Republican | 2 | |||||||||||||
26402 | 26402 | Patrick Hillings H000623 | rep | CA | 1957-01-03 | 1959-01-03 | Republican | 25 | |||||||||||||
26410 | 26410 | Otis Holmes H000740 | rep | WA | 1957-01-03 | 1959-01-03 | Republican | 4 | |||||||||||||
26413 | 26413 | DeWitt Hyde H001021 | rep | MD | 1957-01-03 | 1959-01-03 | Republican | 6 | |||||||||||||
26418 | 26418 | Benjamin James J000045 | rep | PA | 1957-01-03 | 1959-01-03 | Republican | 7 | |||||||||||||
26435 | 26435 | Thomas Jenkins J000088 | rep | OH | 1957-01-03 | 1959-01-03 | Republican | 10 | |||||||||||||
26445 | 26445 | Robert Kean K000029 | rep | NJ | 1957-01-03 | 1959-01-03 | Republican | 12 | |||||||||||||
26453 | 26453 | Bernard Kearney K000030 | rep | NY | 1957-01-03 | 1959-01-03 | Republican | 32 | |||||||||||||
26454 | 26454 | Russell Keeney K000042 | rep | IL | 1957-01-03 | 1959-01-03 | Republican | 14 | |||||||||||||
26468 | 26468 | Otto Krueger K000332 | rep | ND | 1957-01-03 | 1959-01-03 | Republican | 0 | |||||||||||||
26481 | 26481 | Henry Latham L000108 | rep | NY | 1957-01-03 | 1959-01-03 | Republican | 4 | |||||||||||||
26491 | 26491 | Karl Le Compte L000157 | rep | IA | 1957-01-03 | 1959-01-03 | Republican | 4 | |||||||||||||
26495 | 26495 | Edwin May M000274 | rep | CT | 1957-01-03 | 1959-01-03 | Republican | 1 | |||||||||||||
26503 | 26503 | Samuel McConnell M000354 | rep | PA | 1957-01-03 | 1959-01-03 | Republican | 13 | |||||||||||||
26513 | 26513 | J. McGregor M000460 | rep | OH | 1957-01-03 | 1959-01-03 | Republican | 17 | |||||||||||||
26514 | 26514 | Robert McIntosh M000483 | rep | MI | 1957-01-03 | 1959-01-03 | Republican | 7 | |||||||||||||
26518 | 26518 | William McVey M000609 | rep | IL | 1957-01-03 | 1959-01-03 | Republican | 4 | |||||||||||||
26526 | 26526 | Arthur Miller M000715 | rep | NE | 1957-01-03 | 1959-01-03 | Republican | 4 | |||||||||||||
26532 | 26532 | Edward Miller M000724 | rep | MD | 1957-01-03 | 1959-01-03 | Republican | 1 | |||||||||||||
26536 | 26536 | Albert Morano M000935 | rep | CT | 1957-01-03 | 1959-01-03 | Republican | 4 | |||||||||||||
26538 | 26538 | William Neal N000017 | rep | WV | 1957-01-03 | 1959-01-03 | Republican | 4 | |||||||||||||
26544 | 26544 | Donald Nicholson N000097 | rep | MA | 1957-01-03 | 1959-01-03 | Republican | 9 | |||||||||||||
26545 | 26545 | F. Nimtz N000110 | rep | IN | 1957-01-03 | 1959-01-03 | Republican | 3 | |||||||||||||
26554 | 26554 | Joseph O’Hara O000056 | rep | MN | 1957-01-03 | 1959-01-03 | Republican | 2 | |||||||||||||
26560 | 26560 | James Patterson P000119 | rep | CT | 1957-01-03 | 1959-01-03 | Republican | 5 | |||||||||||||
26564 | 26564 | Edmund Radwan R000008 | rep | NY | 1957-01-03 | 1959-01-03 | Republican | 41 | |||||||||||||
26572 | 26572 | John Robsion R000359 | rep | KY | 1957-01-03 | 1959-01-03 | Republican | 3 | |||||||||||||
26578 | 26578 | Antoni Sadlak S000009 | rep | CT | 1957-01-03 | 1959-01-03 | Republican | 0 | |||||||||||||
26586 | 26586 | Errett Scrivner S000194 | rep | KS | 1957-01-03 | 1959-01-03 | Republican | 2 | |||||||||||||
26591 | 26591 | Hubert Scudder S000198 | rep | CA | 1957-01-03 | 1959-01-03 | Republican | 1 | |||||||||||||
26595 | 26595 | Timothy Sheehan S000315 | rep | IL | 1957-01-03 | 1959-01-03 | Republican | 11 | |||||||||||||
26610 | 26610 | Sidney Simpson S000437 | rep | IL | 1957-01-03 | 1959-01-03 | Republican | 20 | |||||||||||||
26619 | 26619 | Lawrence Smith S000585 | rep | WI | 1957-01-03 | 1959-01-03 | Republican | 1 | |||||||||||||
26621 | 26621 | Simon Stauffer S000819 | rep | PA | 1957-01-03 | 1959-01-03 | Republican | 19 | |||||||||||||
26631 | 26631 | Henry Talle T000028 | rep | IA | 1957-01-03 | 1959-01-03 | Republican | 2 | |||||||||||||
26632 | 26632 | Donald Tewes T000139 | rep | WI | 1957-01-03 | 1959-01-03 | Republican | 2 | |||||||||||||
26642 | 26642 | John Vorys V000119 | rep | OH | 1957-01-03 | 1959-01-03 | Republican | 12 | |||||||||||||
26650 | 26650 | Charles Vursell V000125 | rep | IL | 1957-01-03 | 1959-01-03 | Republican | 23 | |||||||||||||
26666 | 26666 | Richard Wigglesworth W000450 | rep | MA | 1957-01-03 | 1959-01-03 | Republican | 13 | |||||||||||||
26670 | 26670 | Alexander Wiley W000465 | sen | WI | 1957-01-03 | 1963-01-03 | 3 | Republican | |||||||||||||
26674 | 26674 | William Williams W000549 | rep | NY | 1957-01-03 | 1959-01-03 | Republican | 34 | |||||||||||||
26690 | 26690 | Charles Wolverton W000683 | rep | NJ | 1957-01-03 | 1959-01-03 | Republican | 1 | |||||||||||||
26704 | 26704 | Leo Allen A000138 | rep | IL | 1957-01-03 | 1959-01-03 | Republican | 16 | |||||||||||||
26724 | 26724 | Albert Baumhart B000245 | rep | OH | 1957-01-03 | 1959-01-03 | Republican | 13 | |||||||||||||
26735 | 26735 | Alvin Bentley B000391 | rep | MI | 1957-01-03 | 1959-01-03 | Republican | 8 | |||||||||||||
26739 | 26739 | Albert Bosch B000646 | rep | NY | 1957-01-03 | 1959-01-03 | Republican | 5 | |||||||||||||
26766 | 26766 | Hamer Budge B001035 | rep | ID | 1957-01-03 | 1959-01-03 | Republican | 2 | |||||||||||||
26773 | 26773 | Alvin Bush B001165 | rep | PA | 1957-01-03 | 1959-01-03 | Republican | 17 | |||||||||||||
26790 | 26790 | Gordon Canfield C000113 | rep | NJ | 1957-01-03 | 1959-01-03 | Republican | 8 | |||||||||||||
26814 | 26814 | Henry Dixon D000368 | rep | UT | 1957-01-03 | 1959-01-03 | Republican | 1 | |||||||||||||
26824 | 26824 | Francis Dorn D000433 | rep | NY | 1957-01-03 | 1959-01-03 | Republican | 12 | |||||||||||||
26865 | 26865 | John Henderson H000484 | rep | OH | 1957-01-03 | 1959-01-03 | Republican | 15 | |||||||||||||
26879 | 26879 | William Hess H000550 | rep | OH | 1957-01-03 | 1959-01-03 | Republican | 2 | |||||||||||||
26884 | 26884 | Joseph Holt H000746 | rep | CA | 1957-01-03 | 1959-01-03 | Republican | 22 | |||||||||||||
26891 | 26891 | Donald Jackson J000008 | rep | CA | 1957-01-03 | 1959-01-03 | Republican | 16 | |||||||||||||
26900 | 26900 | Kenneth Keating K000036 | rep | NY | 1957-01-03 | 1959-01-03 | Republican | 38 | |||||||||||||
26902 | 26902 | John Lafore L000018 | rep | PA | 1957-01-03 | 1959-01-03 | Republican | 13 | |||||||||||||
26911 | 26911 | Russell Mack M000021 | rep | WA | 1957-01-03 | 1959-01-03 | Republican | 3 | |||||||||||||
26969 | 26969 | Daniel Reed R000113 | rep | NY | 1957-01-03 | 1959-01-03 | Republican | 43 | |||||||||||||
26981 | 26981 | Edward Rees R000132 | rep | KS | 1957-01-03 | 1959-01-03 | Republican | 4 | |||||||||||||
26999 | 26999 | Edith Rogers R000392 | rep | MA | 1957-01-03 | 1959-01-03 | Republican | 5 | |||||||||||||
27012 | 27012 | Richard Simpson S000436 | rep | PA | 1957-01-03 | 1959-01-03 | Republican | 18 | |||||||||||||
27019 | 27019 | Wint Smith S000640 | rep | KS | 1957-01-03 | 1959-01-03 | Republican | 6 | |||||||||||||
27028 | 27028 | Dean Taylor T000070 | rep | NY | 1957-01-03 | 1959-01-03 | Republican | 31 | |||||||||||||
27033 | 27033 | Edwin Thomson T000229 | rep | WY | 1957-01-03 | 1959-01-03 | Republican | 0 | |||||||||||||
27037 | 27037 | Stuyvesant Wainwright W000024 | rep | NY | 1957-01-03 | 1959-01-03 | Republican | 1 | |||||||||||||
27054 | 27054 | Gardner Withrow W000663 | rep | WI | 1957-01-03 | 1959-01-03 | Republican | 3 | |||||||||||||
27084 | 27084 | Herman Andersen A000179 | rep | MN | 1957-01-03 | 1959-01-03 | Republican | 7 | |||||||||||||
27101 | 27101 | Perkins Bass B000222 | rep | NH | 1957-01-03 | 1959-01-03 | Republican | 2 | |||||||||||||
27151 | 27151 | Robert Chiperfield C000365 | rep | IL | 1957-01-03 | 1959-01-03 | Republican | 19 | |||||||||||||
27157 | 27157 | Marguerite Church C000389 | rep | IL | 1957-01-03 | 1959-01-03 | Republican | 13 | |||||||||||||
27167 | 27167 | Laurence Curtis C001011 | rep | MA | 1957-01-03 | 1959-01-03 | Republican | 10 | |||||||||||||
27178 | 27178 | Edwin Dooley D000425 | rep | NY | 1957-01-03 | 1959-01-03 | Republican | 26 | |||||||||||||
27201 | 27201 | Ivor Fenton F000075 | rep | PA | 1957-01-03 | 1959-01-03 | Republican | 12 |
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);