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 end-type
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 ▼ |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 | |||||||||||||
26091 | 26091 | James Priest P000536 | rep | TN | 1953-01-03 | 1955-01-03 | Democrat | 5 | |||||||||||||
26102 | 26102 | Chauncey Reed R000111 | rep | IL | 1953-01-03 | 1955-01-03 | Republican | 14 | |||||||||||||
26114 | 26114 | James Richards R000214 | rep | SC | 1953-01-03 | 1955-01-03 | Democrat | 5 | |||||||||||||
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 | |||||||||||||
26182 | 26182 | James Bowler B000698 | rep | IL | 1953-01-03 | 1955-01-03 | Democrat | 7 | |||||||||||||
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 | |||||||||||||
26225 | 26225 | Earl Chudoff C000386 | rep | PA | 1953-01-03 | 1955-01-03 | Democrat | 4 | |||||||||||||
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 | |||||||||||||
26262 | 26262 | Jere Cooper C000755 | rep | TN | 1953-01-03 | 1955-01-03 | Democrat | 8 | |||||||||||||
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 | |||||||||||||
26292 | 26292 | John Dempsey D000228 | rep | NM | 1953-01-03 | 1955-01-03 | Democrat | 0 | |||||||||||||
26297 | 26297 | James Devereux D000278 | rep | MD | 1953-01-03 | 1955-01-03 | Republican | 2 | |||||||||||||
26307 | 26307 | Martin Dies D000338 | rep | TX | 1953-01-03 | 1955-01-03 | Democrat | 0 | |||||||||||||
26318 | 26318 | Herman Eberharter E000029 | rep | PA | 1953-01-03 | 1955-01-03 | Democrat | 28 | |||||||||||||
26323 | 26323 | Myron George G000129 | rep | KS | 1953-01-03 | 1955-01-03 | Republican | 3 | |||||||||||||
26331 | 26331 | Thomas Gordon G000316 | rep | IL | 1953-01-03 | 1955-01-03 | Democrat | 8 | |||||||||||||
26342 | 26342 | Noble Gregory G000447 | rep | KY | 1953-01-03 | 1955-01-03 | Democrat | 1 | |||||||||||||
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 | |||||||||||||
26375 | 26375 | Lawrence Hays H000405 | rep | AR | 1953-01-03 | 1955-01-03 | Democrat | 5 | |||||||||||||
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 | |||||||||||||
26461 | 26461 | Augustine Kelley K000058 | rep | PA | 1953-01-03 | 1955-01-03 | Democrat | 21 | |||||||||||||
26466 | 26466 | Otto Krueger K000332 | rep | ND | 1953-01-03 | 1955-01-03 | Republican | 0 | |||||||||||||
26472 | 26472 | Henderson Lanham L000077 | rep | GA | 1953-01-03 | 1955-01-03 | Democrat | 7 | |||||||||||||
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 | |||||||||||||
26492 | 26492 | George Long L000416 | rep | LA | 1953-01-03 | 1955-01-03 | Democrat | 8 | |||||||||||||
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 | |||||||||||||
26562 | 26562 | Edmund Radwan R000008 | rep | NY | 1953-01-03 | 1955-01-03 | Republican | 41 | |||||||||||||
26567 | 26567 | Edward Robeson R000329 | rep | VA | 1953-01-03 | 1955-01-03 | Democrat | 1 | |||||||||||||
26570 | 26570 | John Robsion R000359 | rep | KY | 1953-01-03 | 1955-01-03 | Republican | 3 | |||||||||||||
26576 | 26576 | Antoni Sadlak S000009 | rep | CT | 1953-01-03 | 1955-01-03 | Republican | 0 | |||||||||||||
26584 | 26584 | Errett Scrivner S000194 | rep | KS | 1953-01-03 | 1955-01-03 | Republican | 2 | |||||||||||||
26589 | 26589 | Hubert Scudder S000198 | rep | CA | 1953-01-03 | 1955-01-03 | Republican | 1 | |||||||||||||
26593 | 26593 | Timothy Sheehan S000315 | rep | IL | 1953-01-03 | 1955-01-03 | Republican | 11 | |||||||||||||
26596 | 26596 | George Shuford S000390 | rep | NC | 1953-01-03 | 1955-01-03 | Democrat | 12 | |||||||||||||
26600 | 26600 | Alfred Sieminski S000405 | rep | NJ | 1953-01-03 | 1955-01-03 | Democrat | 13 | |||||||||||||
26608 | 26608 | Sidney Simpson S000437 | rep | IL | 1953-01-03 | 1955-01-03 | Republican | 20 | |||||||||||||
26617 | 26617 | Lawrence Smith S000585 | rep | WI | 1953-01-03 | 1955-01-03 | Republican | 1 | |||||||||||||
26620 | 26620 | Simon Stauffer S000819 | rep | PA | 1953-01-03 | 1955-01-03 | Republican | 19 | |||||||||||||
26629 | 26629 | Henry Talle T000028 | rep | IA | 1953-01-03 | 1955-01-03 | Republican | 2 | |||||||||||||
26640 | 26640 | John Vorys V000119 | rep | OH | 1953-01-03 | 1955-01-03 | Republican | 12 | |||||||||||||
26648 | 26648 | Charles Vursell V000125 | rep | IL | 1953-01-03 | 1955-01-03 | Republican | 23 | |||||||||||||
26664 | 26664 | Richard Wigglesworth W000450 | rep | MA | 1953-01-03 | 1955-01-03 | Republican | 13 | |||||||||||||
26672 | 26672 | William Williams W000549 | rep | NY | 1953-01-03 | 1955-01-03 | Republican | 34 | |||||||||||||
26688 | 26688 | Charles Wolverton W000683 | rep | NJ | 1953-01-03 | 1955-01-03 | Republican | 1 | |||||||||||||
26702 | 26702 | Leo Allen A000138 | rep | IL | 1953-01-03 | 1955-01-03 | Republican | 16 | |||||||||||||
26717 | 26717 | Graham Barden B000139 | rep | NC | 1953-01-03 | 1955-01-03 | Democrat | 3 | |||||||||||||
26733 | 26733 | Alvin Bentley B000391 | rep | MI | 1953-01-03 | 1955-01-03 | Republican | 8 | |||||||||||||
26737 | 26737 | Albert Bosch B000646 | rep | NY | 1953-01-03 | 1955-01-03 | Republican | 5 | |||||||||||||
26758 | 26758 | Paul Brown B000940 | rep | GA | 1953-01-03 | 1955-01-03 | Democrat | 10 | |||||||||||||
26764 | 26764 | Hamer Budge B001035 | rep | ID | 1953-01-03 | 1955-01-03 | Republican | 2 | |||||||||||||
26771 | 26771 | Alvin Bush B001165 | rep | PA | 1953-01-03 | 1955-01-03 | Republican | 17 | |||||||||||||
26788 | 26788 | Gordon Canfield C000113 | rep | NJ | 1953-01-03 | 1955-01-03 | Republican | 8 | |||||||||||||
26795 | 26795 | Albert Carnahan C000162 | rep | MO | 1953-01-03 | 1955-01-03 | Democrat | 8 | |||||||||||||
26818 | 26818 | Isidore Dollinger D000402 | rep | NY | 1953-01-03 | 1955-01-03 | Democrat | 23 | |||||||||||||
26822 | 26822 | Francis Dorn D000433 | rep | NY | 1953-01-03 | 1955-01-03 | Republican | 12 | |||||||||||||
26833 | 26833 | Carl Durham D000571 | rep | NC | 1953-01-03 | 1955-01-03 | Democrat | 6 | |||||||||||||
26843 | 26843 | Clair Engle E000181 | rep | CA | 1953-01-03 | 1955-01-03 | Democrat | 2 | |||||||||||||
26856 | 26856 | Aime Forand F000255 | rep | RI | 1953-01-03 | 1955-01-03 | Democrat | 1 | |||||||||||||
26877 | 26877 | William Hess H000550 | rep | OH | 1953-01-03 | 1955-01-03 | Republican | 2 | |||||||||||||
26882 | 26882 | Joseph Holt H000746 | rep | CA | 1953-01-03 | 1955-01-03 | Republican | 22 | |||||||||||||
26889 | 26889 | Donald Jackson J000008 | rep | CA | 1953-01-03 | 1955-01-03 | Republican | 16 | |||||||||||||
26898 | 26898 | Kenneth Keating K000036 | rep | NY | 1953-01-03 | 1955-01-03 | Republican | 38 | |||||||||||||
26909 | 26909 | Russell Mack M000021 | rep | WA | 1953-01-03 | 1955-01-03 | Republican | 3 | |||||||||||||
26934 | 26934 | James Polk P000408 | rep | OH | 1953-01-03 | 1955-01-03 | Democrat | 6 |
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);