legislator_terms
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
484 rows where "start" is on date 1951-01-03
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
25630 | 25630 | Albert Camp C000070 | rep | GA | 1951-01-03 | 1953-01-03 | Democrat | 4 | |||||||||||||
25656 | 25656 | Robert Crosser C000932 | rep | OH | 1951-01-03 | 1953-01-03 | Democrat | 21 | |||||||||||||
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 | |||||||||||||
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 | |||||||||||||
25704 | 25704 | Edward Hart H000284 | rep | NJ | 1951-01-03 | 1953-01-03 | Democrat | 14 | |||||||||||||
25707 | 25707 | Louis Heller H000460 | rep | NY | 1951-01-03 | 1953-01-03 | Democrat | 7 | |||||||||||||
25711 | 25711 | Charles Howell H000858 | rep | NJ | 1951-01-03 | 1953-01-03 | Democrat | 4 | |||||||||||||
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 | |||||||||||||
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 | |||||||||||||
25747 | 25747 | William Lantaff L000089 | rep | FL | 1951-01-03 | 1953-01-03 | Democrat | 4 | |||||||||||||
25751 | 25751 | Wingate Lucas L000496 | rep | TX | 1951-01-03 | 1953-01-03 | Democrat | 12 | |||||||||||||
25756 | 25756 | John Lyle L000525 | rep | TX | 1951-01-03 | 1953-01-03 | Democrat | 14 | |||||||||||||
25771 | 25771 | George O’Brien O000009 | rep | MI | 1951-01-03 | 1953-01-03 | Democrat | 13 | |||||||||||||
25775 | 25775 | Harold Patten P000107 | rep | AZ | 1951-01-03 | 1953-01-03 | Democrat | 2 | |||||||||||||
25781 | 25781 | C. Poulson P000475 | rep | CA | 1951-01-03 | 1953-01-03 | Republican | 13 | |||||||||||||
25785 | 25785 | Henry Reams R000100 | rep | OH | 1951-01-03 | 1953-01-03 | Independent | 9 | |||||||||||||
25789 | 25789 | Kenneth Regan R000140 | rep | TX | 1951-01-03 | 1953-01-03 | Democrat | 16 | |||||||||||||
25794 | 25794 | Dwight Rogers R000391 | rep | FL | 1951-01-03 | 1953-01-03 | Democrat | 6 | |||||||||||||
25797 | 25797 | Franklin Roosevelt R000425 | rep | NY | 1951-01-03 | 1953-01-03 | Democrat | 20 | |||||||||||||
25806 | 25806 | Paul Shafer S000277 | rep | MI | 1951-01-03 | 1953-01-03 | Republican | 3 | |||||||||||||
25815 | 25815 | Thomas Stanley S000797 | rep | VA | 1951-01-03 | 1953-01-03 | Democrat | 5 | |||||||||||||
25819 | 25819 | James Sutton S001087 | rep | TN | 1951-01-03 | 1953-01-03 | Democrat | 7 | |||||||||||||
25831 | 25831 | Alvin Weichel W000252 | rep | OH | 1951-01-03 | 1953-01-03 | Republican | 13 | |||||||||||||
25835 | 25835 | William Wheeler W000342 | rep | GA | 1951-01-03 | 1953-01-03 | Democrat | 8 | |||||||||||||
25839 | 25839 | Joseph Wilson W000604 | rep | TX | 1951-01-03 | 1953-01-03 | Democrat | 5 | |||||||||||||
25844 | 25844 | Samuel Yorty Y000024 | rep | CA | 1951-01-03 | 1953-01-03 | Democrat | 14 | |||||||||||||
25852 | 25852 | George Bender B000356 | rep | OH | 1951-01-03 | 1953-01-03 | Republican | 0 | |||||||||||||
25885 | 25885 | Vera Buchanan B001009 | rep | PA | 1951-01-03 | 1953-01-03 | Democrat | 33 | |||||||||||||
25889 | 25889 | Maurice Burnside B001131 | rep | WV | 1951-01-03 | 1953-01-03 | Democrat | 4 | |||||||||||||
25892 | 25892 | Frank Carlyle C000156 | rep | NC | 1951-01-03 | 1953-01-03 | Democrat | 7 | |||||||||||||
25897 | 25897 | Richard Chatham C000336 | rep | NC | 1951-01-03 | 1953-01-03 | Democrat | 5 | |||||||||||||
25902 | 25902 | Shepard Crumpacker C000960 | rep | IN | 1951-01-03 | 1953-01-03 | Republican | 3 | |||||||||||||
25908 | 25908 | Charles Deane D000175 | rep | NC | 1951-01-03 | 1953-01-03 | Democrat | 8 | |||||||||||||
25920 | 25920 | John Dingell D000354 | rep | MI | 1951-01-03 | 1953-01-03 | Democrat | 15 | |||||||||||||
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 | |||||||||||||
25941 | 25941 | James Donovan D000421 | rep | NY | 1951-01-03 | 1953-01-03 | Democrat | 18 | |||||||||||||
25948 | 25948 | Mathew Ellsworth E000146 | rep | OR | 1951-01-03 | 1953-01-03 | Republican | 4 | |||||||||||||
25957 | 25957 | Antonio Fernández F000085 | rep | NM | 1951-01-03 | 1953-01-03 | Democrat | 0 | |||||||||||||
25960 | 25960 | Sidney Fine F000126 | rep | NY | 1951-01-03 | 1953-01-03 | Democrat | 23 | |||||||||||||
25973 | 25973 | Ralph Gamble G000031 | rep | NY | 1951-01-03 | 1953-01-03 | Republican | 28 | |||||||||||||
25980 | 25980 | William Granahan G000369 | rep | PA | 1951-01-03 | 1953-01-03 | Democrat | 2 | |||||||||||||
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 | |||||||||||||
26030 | 26030 | Woodrow Jones J000263 | rep | NC | 1951-01-03 | 1953-01-03 | Democrat | 11 | |||||||||||||
26033 | 26033 | Karl King K000208 | rep | PA | 1951-01-03 | 1953-01-03 | Republican | 8 | |||||||||||||
26041 | 26041 | Arthur Klein K000261 | rep | NY | 1951-01-03 | 1953-01-03 | Democrat | 19 | |||||||||||||
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 | |||||||||||||
26090 | 26090 | James Priest P000536 | rep | TN | 1951-01-03 | 1953-01-03 | Democrat | 6 | |||||||||||||
26101 | 26101 | Chauncey Reed R000111 | rep | IL | 1951-01-03 | 1953-01-03 | Republican | 14 | |||||||||||||
26113 | 26113 | James Richards R000214 | rep | SC | 1951-01-03 | 1953-01-03 | Democrat | 5 | |||||||||||||
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 | |||||||||||||
26201 | 26201 | John Butler B001180 | sen | MD | 1951-01-03 | 1957-01-03 | 3 | Republican | |||||||||||||
26205 | 26205 | Homer Capehart C000128 | sen | IN | 1951-01-03 | 1957-01-03 | 3 | Republican | |||||||||||||
26207 | 26207 | Joseph Carrigg C000182 | rep | PA | 1951-01-03 | 1953-01-03 | Republican | 14 | |||||||||||||
26221 | 26221 | Francis Case C000221 | sen | SD | 1951-01-03 | 1957-01-03 | 3 | Republican | |||||||||||||
26224 | 26224 | Earl Chudoff C000386 | rep | PA | 1951-01-03 | 1953-01-03 | Democrat | 4 | |||||||||||||
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 | |||||||||||||
26261 | 26261 | Jere Cooper C000755 | rep | TN | 1951-01-03 | 1953-01-03 | Democrat | 9 | |||||||||||||
26267 | 26267 | Frederic Coudert C000804 | rep | NY | 1951-01-03 | 1953-01-03 | Republican | 17 | |||||||||||||
26279 | 26279 | Paul Cunningham C000993 | rep | IA | 1951-01-03 | 1953-01-03 | Republican | 5 | |||||||||||||
26291 | 26291 | John Dempsey D000228 | rep | NM | 1951-01-03 | 1953-01-03 | Democrat | 0 | |||||||||||||
26296 | 26296 | James Devereux D000278 | rep | MD | 1951-01-03 | 1953-01-03 | Republican | 2 | |||||||||||||
26317 | 26317 | Herman Eberharter E000029 | rep | PA | 1951-01-03 | 1953-01-03 | Democrat | 32 | |||||||||||||
26322 | 26322 | Myron George G000129 | rep | KS | 1951-01-03 | 1953-01-03 | Republican | 3 | |||||||||||||
26330 | 26330 | Thomas Gordon G000316 | rep | IL | 1951-01-03 | 1953-01-03 | Democrat | 8 | |||||||||||||
26341 | 26341 | Noble Gregory G000447 | rep | KY | 1951-01-03 | 1953-01-03 | Democrat | 1 | |||||||||||||
26348 | 26348 | Ralph Gwinn G000541 | rep | NY | 1951-01-03 | 1953-01-03 | Republican | 27 | |||||||||||||
26356 | 26356 | Robert Hale H000036 | rep | ME | 1951-01-03 | 1953-01-03 | Republican | 1 | |||||||||||||
26361 | 26361 | Cecil Harden H000182 | rep | IN | 1951-01-03 | 1953-01-03 | Republican | 6 | |||||||||||||
26365 | 26365 | Robert Harrison H000275 | rep | NE | 1951-01-03 | 1953-01-03 | Republican | 3 | |||||||||||||
26374 | 26374 | Lawrence Hays H000405 | rep | AR | 1951-01-03 | 1953-01-03 | Democrat | 5 | |||||||||||||
26381 | 26381 | Thomas Hennings H000502 | sen | MO | 1951-01-03 | 1957-01-03 | 3 | Democrat | |||||||||||||
26386 | 26386 | John Heselton H000549 | rep | MA | 1951-01-03 | 1953-01-03 | Republican | 1 | |||||||||||||
26395 | 26395 | William Hill H000613 | rep | CO | 1951-01-03 | 1953-01-03 | Republican | 2 | |||||||||||||
26399 | 26399 | Patrick Hillings H000623 | rep | CA | 1951-01-03 | 1953-01-03 | Republican | 12 | |||||||||||||
26407 | 26407 | Otis Holmes H000740 | rep | WA | 1951-01-03 | 1953-01-03 | Republican | 4 | |||||||||||||
26415 | 26415 | Benjamin James J000045 | rep | PA | 1951-01-03 | 1953-01-03 | Republican | 7 | |||||||||||||
26432 | 26432 | Thomas Jenkins J000088 | rep | OH | 1951-01-03 | 1953-01-03 | Republican | 10 |
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);