legislator_terms
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
485 rows where "end" is on date 1955-01-03 sorted by district
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
25776 | 25776 | Harold Patten P000107 | rep | AZ | 1953-01-03 | 1955-01-03 | Democrat | 2 | |||||||||||||
25900 | 25900 | Samuel Coon C000743 | rep | OR | 1953-01-03 | 1955-01-03 | Republican | 2 | |||||||||||||
25981 | 25981 | William Granahan G000369 | rep | PA | 1953-01-03 | 1955-01-03 | Democrat | 2 | |||||||||||||
25991 | 25991 | Thomas Hand H000154 | rep | NJ | 1953-01-03 | 1955-01-03 | Republican | 2 | |||||||||||||
26075 | 26075 | Charles Nelson N000031 | rep | ME | 1953-01-03 | 1955-01-03 | Republican | 2 | |||||||||||||
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 | |||||||||||||
26396 | 26396 | William Hill H000613 | rep | CO | 1953-01-03 | 1955-01-03 | Republican | 2 | |||||||||||||
26552 | 26552 | Joseph O’Hara O000056 | rep | MN | 1953-01-03 | 1955-01-03 | Republican | 2 | |||||||||||||
26584 | 26584 | Errett Scrivner S000194 | rep | KS | 1953-01-03 | 1955-01-03 | Republican | 2 | |||||||||||||
26629 | 26629 | Henry Talle T000028 | rep | IA | 1953-01-03 | 1955-01-03 | Republican | 2 | |||||||||||||
26764 | 26764 | Hamer Budge B001035 | rep | ID | 1953-01-03 | 1955-01-03 | Republican | 2 | |||||||||||||
26843 | 26843 | Clair Engle E000181 | rep | CA | 1953-01-03 | 1955-01-03 | Democrat | 2 | |||||||||||||
26877 | 26877 | William Hess H000550 | rep | OH | 1953-01-03 | 1955-01-03 | Republican | 2 | |||||||||||||
27482 | 27482 | John Riley R000260 | rep | SC | 1953-01-03 | 1955-01-03 | Democrat | 2 | |||||||||||||
27523 | 27523 | Horace Seely-Brown S000224 | rep | CT | 1953-01-03 | 1955-01-03 | Republican | 2 | |||||||||||||
27625 | 27625 | Howard Baker B000062 | rep | TN | 1953-01-03 | 1955-01-03 | Republican | 2 | |||||||||||||
27736 | 27736 | Steven Derounian D000266 | rep | NY | 1953-01-03 | 1955-01-03 | Republican | 2 | |||||||||||||
27824 | 27824 | George Grant G000381 | rep | AL | 1953-01-03 | 1955-01-03 | Democrat | 2 | |||||||||||||
28007 | 28007 | George Meader M000620 | rep | MI | 1953-01-03 | 1955-01-03 | Republican | 2 | |||||||||||||
28083 | 28083 | John Pilcher P000349 | rep | GA | 1953-01-03 | 1955-01-03 | Democrat | 2 | |||||||||||||
28250 | 28250 | Alfred Westland W000310 | rep | WA | 1953-01-03 | 1955-01-03 | Republican | 2 | |||||||||||||
28808 | 28808 | Thomas Curtis C001014 | rep | MO | 1953-01-03 | 1955-01-03 | Republican | 2 | |||||||||||||
28836 | 28836 | John Fogarty F000233 | rep | RI | 1953-01-03 | 1955-01-03 | Democrat | 2 | |||||||||||||
28869 | 28869 | Charles Halleck H000081 | rep | IN | 1953-01-03 | 1955-01-03 | Republican | 2 | |||||||||||||
28880 | 28880 | Porter Hardy H000197 | rep | VA | 1953-01-03 | 1955-01-03 | Democrat | 2 | |||||||||||||
28999 | 28999 | Barratt O’Hara O000053 | rep | IL | 1953-01-03 | 1955-01-03 | Democrat | 2 | |||||||||||||
29150 | 29150 | Ellis Berry B000416 | rep | SD | 1953-01-03 | 1955-01-03 | Republican | 2 | |||||||||||||
29613 | 29613 | Thomas Boggs B000594 | rep | LA | 1953-01-03 | 1955-01-03 | Democrat | 2 | |||||||||||||
29757 | 29757 | Edmond Edmondson E000054 | rep | OK | 1953-01-03 | 1955-01-03 | Democrat | 2 | |||||||||||||
30279 | 30279 | Glenn Davis D000102 | rep | WI | 1953-01-03 | 1955-01-03 | Republican | 2 | |||||||||||||
31188 | 31188 | Wilbur Mills M000778 | rep | AR | 1953-01-03 | 1955-01-03 | Democrat | 2 | |||||||||||||
32300 | 32300 | Harley Staggers S000778 | rep | WV | 1953-01-03 | 1955-01-03 | Democrat | 2 | |||||||||||||
32658 | 32658 | Lawrence Fountain F000319 | rep | NC | 1953-01-03 | 1955-01-03 | Democrat | 2 | |||||||||||||
33494 | 33494 | Edward Boland B000600 | rep | MA | 1953-01-03 | 1955-01-03 | Democrat | 2 | |||||||||||||
34235 | 34235 | Charles Bennett B000371 | rep | FL | 1953-01-03 | 1955-01-03 | Democrat | 2 | |||||||||||||
35135 | 35135 | Jack Brooks B000880 | rep | TX | 1953-01-03 | 1955-01-03 | Democrat | 2 | |||||||||||||
35457 | 35457 | William Natcher N000009 | rep | KY | 1953-01-03 | 1955-01-03 | Democrat | 2 | |||||||||||||
35648 | 35648 | Jamie Whitten W000428 | rep | MS | 1953-01-03 | 1955-01-03 | Democrat | 2 | |||||||||||||
25584 | 25584 | Homer Angell A000257 | rep | OR | 1953-01-03 | 1955-01-03 | Republican | 3 | |||||||||||||
25620 | 25620 | Fred Busbey B001161 | rep | IL | 1953-01-03 | 1955-01-03 | Republican | 3 | |||||||||||||
25807 | 25807 | Paul Shafer S000277 | rep | MI | 1953-01-03 | 1955-01-03 | Republican | 3 | |||||||||||||
25903 | 25903 | Shepard Crumpacker C000960 | rep | IN | 1953-01-03 | 1955-01-03 | Republican | 3 | |||||||||||||
25976 | 25976 | Brady Gentry G000124 | rep | TX | 1953-01-03 | 1955-01-03 | Democrat | 3 | |||||||||||||
26271 | 26271 | Albert Cretella C000905 | rep | CT | 1953-01-03 | 1955-01-03 | Republican | 3 | |||||||||||||
26323 | 26323 | Myron George G000129 | rep | KS | 1953-01-03 | 1955-01-03 | Republican | 3 | |||||||||||||
26366 | 26366 | Robert Harrison H000275 | rep | NE | 1953-01-03 | 1955-01-03 | Republican | 3 | |||||||||||||
26570 | 26570 | John Robsion R000359 | rep | KY | 1953-01-03 | 1955-01-03 | Republican | 3 | |||||||||||||
26717 | 26717 | Graham Barden B000139 | rep | NC | 1953-01-03 | 1955-01-03 | Democrat | 3 | |||||||||||||
26909 | 26909 | Russell Mack M000021 | rep | WA | 1953-01-03 | 1955-01-03 | Republican | 3 | |||||||||||||
27042 | 27042 | Roy Wier W000446 | rep | MN | 1953-01-03 | 1955-01-03 | Democrat | 3 | |||||||||||||
27052 | 27052 | Gardner Withrow W000663 | rep | WI | 1953-01-03 | 1955-01-03 | Republican | 3 | |||||||||||||
27095 | 27095 | Cleveland Bailey B000035 | rep | WV | 1953-01-03 | 1955-01-03 | Democrat | 3 | |||||||||||||
27206 | 27206 | James Frazier F000353 | rep | TN | 1953-01-03 | 1955-01-03 | Democrat | 3 | |||||||||||||
27528 | 27528 | Frank Smith S000533 | rep | MS | 1953-01-03 | 1955-01-03 | Democrat | 3 | |||||||||||||
27613 | 27613 | James Auchincloss A000227 | rep | NJ | 1953-01-03 | 1955-01-03 | Republican | 3 | |||||||||||||
27635 | 27635 | Frank Becker B000292 | rep | NY | 1953-01-03 | 1955-01-03 | Republican | 3 | |||||||||||||
27715 | 27715 | John Chenoweth C000346 | rep | CO | 1953-01-03 | 1955-01-03 | Republican | 3 | |||||||||||||
27784 | 27784 | Elijah Forrester F000283 | rep | GA | 1953-01-03 | 1955-01-03 | Democrat | 3 | |||||||||||||
27794 | 27794 | Julian Gary G000091 | rep | VA | 1953-01-03 | 1955-01-03 | Democrat | 3 | |||||||||||||
27999 | 27999 | Clifford McIntire M000478 | rep | ME | 1953-01-03 | 1955-01-03 | Republican | 3 | |||||||||||||
28125 | 28125 | Paul Schenck S000117 | rep | OH | 1953-01-03 | 1955-01-03 | Republican | 3 | |||||||||||||
28720 | 28720 | James Trimble T000373 | rep | AR | 1953-01-03 | 1955-01-03 | Democrat | 3 | |||||||||||||
29080 | 29080 | Edwin Willis W000559 | rep | LA | 1953-01-03 | 1955-01-03 | Democrat | 3 | |||||||||||||
29411 | 29411 | Philip Philbin P000303 | rep | MA | 1953-01-03 | 1955-01-03 | Democrat | 3 | |||||||||||||
29549 | 29549 | George Andrews A000206 | rep | AL | 1953-01-03 | 1955-01-03 | Democrat | 3 | |||||||||||||
29640 | 29640 | James Byrne B001212 | rep | PA | 1953-01-03 | 1955-01-03 | Democrat | 3 | |||||||||||||
29804 | 29804 | Edward Garmatz G000071 | rep | MD | 1953-01-03 | 1955-01-03 | Democrat | 3 | |||||||||||||
30318 | 30318 | William Dorn D000434 | rep | SC | 1953-01-03 | 1955-01-03 | Democrat | 3 | |||||||||||||
30416 | 30416 | Harold Gross G000495 | rep | IA | 1953-01-03 | 1955-01-03 | Republican | 3 | |||||||||||||
30806 | 30806 | Carl Albert A000073 | rep | OK | 1953-01-03 | 1955-01-03 | Democrat | 3 | |||||||||||||
31358 | 31358 | Leonor Sullivan S001057 | rep | MO | 1953-01-03 | 1955-01-03 | Democrat | 3 | |||||||||||||
31675 | 31675 | John Moss M001035 | rep | CA | 1953-01-03 | 1955-01-03 | Democrat | 3 | |||||||||||||
31806 | 31806 | Robert Sikes S000406 | rep | FL | 1953-01-03 | 1955-01-03 | Democrat | 3 | |||||||||||||
25615 | 25615 | Joseph Bryson B000999 | rep | SC | 1953-01-03 | 1955-01-03 | Democrat | 4 | |||||||||||||
25631 | 25631 | Albert Camp C000070 | rep | GA | 1953-01-03 | 1955-01-03 | Democrat | 4 | |||||||||||||
25709 | 25709 | Jeffrey Hillelson H000616 | rep | MO | 1953-01-03 | 1955-01-03 | Republican | 4 | |||||||||||||
25712 | 25712 | Charles Howell H000858 | rep | NJ | 1953-01-03 | 1955-01-03 | Democrat | 4 | |||||||||||||
25748 | 25748 | William Lantaff L000089 | rep | FL | 1953-01-03 | 1955-01-03 | Democrat | 4 | |||||||||||||
25949 | 25949 | Mathew Ellsworth E000146 | rep | OR | 1953-01-03 | 1955-01-03 | Republican | 4 | |||||||||||||
26225 | 26225 | Earl Chudoff C000386 | rep | PA | 1953-01-03 | 1955-01-03 | Democrat | 4 | |||||||||||||
26408 | 26408 | Otis Holmes H000740 | rep | WA | 1953-01-03 | 1955-01-03 | Republican | 4 | |||||||||||||
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 | |||||||||||||
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 | |||||||||||||
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 | |||||||||||||
26979 | 26979 | Edward Rees R000132 | rep | KS | 1953-01-03 | 1955-01-03 | Republican | 4 | |||||||||||||
27135 | 27135 | Overton Brooks B000884 | rep | LA | 1953-01-03 | 1955-01-03 | Democrat | 4 | |||||||||||||
27240 | 27240 | Clare Hoffman H000683 | rep | MI | 1953-01-03 | 1955-01-03 | Republican | 4 | |||||||||||||
27454 | 27454 | Samuel Rayburn R000082 | rep | TX | 1953-01-03 | 1955-01-03 | Democrat | 4 | |||||||||||||
28116 | 28116 | Kenneth Roberts R000314 | rep | AL | 1953-01-03 | 1955-01-03 | Democrat | 4 | |||||||||||||
28365 | 28365 | Frank Chelf C000342 | rep | KY | 1953-01-03 | 1955-01-03 | Democrat | 4 | |||||||||||||
28383 | 28383 | Harold Cooley C000736 | rep | NC | 1953-01-03 | 1955-01-03 | Democrat | 4 | |||||||||||||
28453 | 28453 | Oren Harris H000249 | rep | AR | 1953-01-03 | 1955-01-03 | Democrat | 4 | |||||||||||||
28559 | 28559 | Eugene McCarthy M000311 | rep | MN | 1953-01-03 | 1955-01-03 | Democrat | 4 | |||||||||||||
28764 | 28764 | Robert Ashmore A000223 | rep | SC | 1953-01-03 | 1955-01-03 | Democrat | 4 | |||||||||||||
29070 | 29070 | John Williams W000517 | rep | MS | 1953-01-03 | 1955-01-03 | Democrat | 4 | |||||||||||||
29104 | 29104 | Edwin Adair A000024 | rep | IN | 1953-01-03 | 1955-01-03 | Republican | 4 |
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);