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 rowid descending
This data as json, copyable, CSV (advanced)
Suggested facets: type, start, 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
37951 | 37951 | Robert Byrd B001210 | rep | WV | 1953-01-03 | 1955-01-03 | Democrat | 6 | |||||||||||||
36450 | 36450 | Sidney Yates Y000013 | rep | IL | 1953-01-03 | 1955-01-03 | Democrat | 9 | |||||||||||||
36418 | 36418 | J. Thurmond T000254 | sen | SC | 1954-12-24 | 1955-01-03 | 2 | Democrat | |||||||||||||
35648 | 35648 | Jamie Whitten W000428 | rep | MS | 1953-01-03 | 1955-01-03 | Democrat | 2 | |||||||||||||
35457 | 35457 | William Natcher N000009 | rep | KY | 1953-01-03 | 1955-01-03 | Democrat | 2 | |||||||||||||
35135 | 35135 | Jack Brooks B000880 | rep | TX | 1953-01-03 | 1955-01-03 | Democrat | 2 | |||||||||||||
34235 | 34235 | Charles Bennett B000371 | rep | FL | 1953-01-03 | 1955-01-03 | Democrat | 2 | |||||||||||||
33817 | 33817 | Lloyd Bentsen B000401 | rep | TX | 1953-01-03 | 1955-01-03 | Democrat | 15 | |||||||||||||
33723 | 33723 | Peter Rodino R000374 | rep | NJ | 1953-01-03 | 1955-01-03 | Democrat | 10 | |||||||||||||
33699 | 33699 | Charles Price P000522 | rep | IL | 1953-01-03 | 1955-01-03 | Democrat | 24 | |||||||||||||
33494 | 33494 | Edward Boland B000600 | rep | MA | 1953-01-03 | 1955-01-03 | Democrat | 2 | |||||||||||||
33382 | 33382 | Thomas O’Neill O000098 | rep | MA | 1953-01-03 | 1955-01-03 | Democrat | 11 | |||||||||||||
33193 | 33193 | Clement Zablocki Z000001 | rep | WI | 1953-01-03 | 1955-01-03 | Democrat | 4 | |||||||||||||
33089 | 33089 | Carl Perkins P000230 | rep | KY | 1953-01-03 | 1955-01-03 | Democrat | 7 | |||||||||||||
32871 | 32871 | William Wampler W000121 | rep | VA | 1953-01-03 | 1955-01-03 | Republican | 9 | |||||||||||||
32823 | 32823 | John Rhodes R000188 | rep | AZ | 1953-01-03 | 1955-01-03 | Republican | 1 | |||||||||||||
32781 | 32781 | Robert Mollohan M000845 | rep | WV | 1953-01-03 | 1955-01-03 | Democrat | 1 | |||||||||||||
32658 | 32658 | Lawrence Fountain F000319 | rep | NC | 1953-01-03 | 1955-01-03 | Democrat | 2 | |||||||||||||
32491 | 32491 | Richard Bolling B000605 | rep | MO | 1953-01-03 | 1955-01-03 | Democrat | 5 | |||||||||||||
32398 | 32398 | Robert Wilson W000610 | rep | CA | 1953-01-03 | 1955-01-03 | Republican | 30 | |||||||||||||
32316 | 32316 | Thomas Steed S000829 | rep | OK | 1953-01-03 | 1955-01-03 | Democrat | 4 | |||||||||||||
32300 | 32300 | Harley Staggers S000778 | rep | WV | 1953-01-03 | 1955-01-03 | Democrat | 2 | |||||||||||||
31893 | 31893 | Harrison Williams W000502 | rep | NJ | 1953-01-03 | 1955-01-03 | Democrat | 6 | |||||||||||||
31850 | 31850 | Olin Teague T000110 | rep | TX | 1953-01-03 | 1955-01-03 | Democrat | 6 | |||||||||||||
31806 | 31806 | Robert Sikes S000406 | rep | FL | 1953-01-03 | 1955-01-03 | Democrat | 3 | |||||||||||||
31726 | 31726 | William Poage P000398 | rep | TX | 1953-01-03 | 1955-01-03 | Democrat | 11 | |||||||||||||
31675 | 31675 | John Moss M001035 | rep | CA | 1953-01-03 | 1955-01-03 | Democrat | 3 | |||||||||||||
31630 | 31630 | George Mahon M000065 | rep | TX | 1953-01-03 | 1955-01-03 | Democrat | 19 | |||||||||||||
31592 | 31592 | Hubert Humphrey H000953 | sen | MN | 1949-01-03 | 1955-01-03 | 2 | Democrat | |||||||||||||
31556 | 31556 | John Flynt F000229 | rep | GA | 1953-01-03 | 1955-01-03 | Democrat | 4 | |||||||||||||
31514 | 31514 | James Delaney D000211 | rep | NY | 1953-01-03 | 1955-01-03 | Democrat | 7 | |||||||||||||
31486 | 31486 | Elford Cederberg C000263 | rep | MI | 1953-01-03 | 1955-01-03 | Republican | 10 | |||||||||||||
31456 | 31456 | Omar Burleson B001111 | rep | TX | 1953-01-03 | 1955-01-03 | Democrat | 17 | |||||||||||||
31358 | 31358 | Leonor Sullivan S001057 | rep | MO | 1953-01-03 | 1955-01-03 | Democrat | 3 | |||||||||||||
31264 | 31264 | John Patman P000103 | rep | TX | 1953-01-03 | 1955-01-03 | Democrat | 1 | |||||||||||||
31240 | 31240 | Otto Passman P000098 | rep | LA | 1953-01-03 | 1955-01-03 | Democrat | 5 | |||||||||||||
31205 | 31205 | Thomas Morgan M000958 | rep | PA | 1953-01-03 | 1955-01-03 | Democrat | 26 | |||||||||||||
31188 | 31188 | Wilbur Mills M000778 | rep | AR | 1953-01-03 | 1955-01-03 | Democrat | 2 | |||||||||||||
31148 | 31148 | Ray Madden M000039 | rep | IN | 1953-01-03 | 1955-01-03 | Democrat | 1 | |||||||||||||
31118 | 31118 | Phillip Landrum L000054 | rep | GA | 1953-01-03 | 1955-01-03 | Democrat | 9 | |||||||||||||
31106 | 31106 | John Kluczynski K000273 | rep | IL | 1953-01-03 | 1955-01-03 | Democrat | 5 | |||||||||||||
31084 | 31084 | Robert Jones J000248 | rep | AL | 1953-01-03 | 1955-01-03 | Democrat | 8 | |||||||||||||
31069 | 31069 | Jacob Javits J000064 | rep | NY | 1953-01-03 | 1955-01-03 | Republican | 21 | |||||||||||||
31054 | 31054 | John Jarman J000057 | rep | OK | 1953-01-03 | 1955-01-03 | Democrat | 5 | |||||||||||||
31041 | 31041 | Felix Hébert H000437 | rep | LA | 1953-01-03 | 1955-01-03 | Democrat | 1 | |||||||||||||
30977 | 30977 | Wayne Hays H000408 | rep | OH | 1953-01-03 | 1955-01-03 | Democrat | 18 | |||||||||||||
30957 | 30957 | James Haley H000041 | rep | FL | 1953-01-03 | 1955-01-03 | Democrat | 7 | |||||||||||||
30924 | 30924 | Joseph Evins E000273 | rep | TN | 1953-01-03 | 1955-01-03 | Democrat | 4 | |||||||||||||
30823 | 30823 | William Barrett B000178 | rep | PA | 1953-01-03 | 1955-01-03 | Democrat | 1 | |||||||||||||
30806 | 30806 | Carl Albert A000073 | rep | OK | 1953-01-03 | 1955-01-03 | Democrat | 3 | |||||||||||||
30789 | 30789 | Gerald Ford F000260 | rep | MI | 1953-01-03 | 1955-01-03 | Republican | 5 | |||||||||||||
30750 | 30750 | William Widnall W000445 | rep | NJ | 1953-01-03 | 1955-01-03 | Republican | 7 | |||||||||||||
30700 | 30700 | John Sparkman S000701 | sen | AL | 1949-01-03 | 1955-01-03 | 2 | Democrat | |||||||||||||
30668 | 30668 | John Saylor S000102 | rep | PA | 1953-01-03 | 1955-01-03 | Republican | 22 | |||||||||||||
30646 | 30646 | John Rooney R000424 | rep | NY | 1953-01-03 | 1955-01-03 | Democrat | 14 | |||||||||||||
30575 | 30575 | Lee Metcalf M000671 | rep | MT | 1953-01-03 | 1955-01-03 | Democrat | 1 | |||||||||||||
30566 | 30566 | John McClellan M000332 | sen | AR | 1949-01-03 | 1955-01-03 | 2 | Democrat | |||||||||||||
30534 | 30534 | William Mailliard M000070 | rep | CA | 1953-01-03 | 1955-01-03 | Republican | 4 | |||||||||||||
30497 | 30497 | Craig Hosmer H000802 | rep | CA | 1953-01-03 | 1955-01-03 | Republican | 18 | |||||||||||||
30486 | 30486 | Chester Holifield H000713 | rep | CA | 1953-01-03 | 1955-01-03 | Democrat | 19 | |||||||||||||
30433 | 30433 | Charles Gubser G000512 | rep | CA | 1953-01-03 | 1955-01-03 | Republican | 10 | |||||||||||||
30416 | 30416 | Harold Gross G000495 | rep | IA | 1953-01-03 | 1955-01-03 | Republican | 3 | |||||||||||||
30360 | 30360 | Peter Frelinghuysen F000371 | rep | NJ | 1953-01-03 | 1955-01-03 | Republican | 5 | |||||||||||||
30349 | 30349 | Ovie Fisher F000152 | rep | TX | 1953-01-03 | 1955-01-03 | Democrat | 21 | |||||||||||||
30339 | 30339 | James Eastland E000018 | sen | MS | 1949-01-03 | 1955-01-03 | 2 | Democrat | |||||||||||||
30318 | 30318 | William Dorn D000434 | rep | SC | 1953-01-03 | 1955-01-03 | Democrat | 3 | |||||||||||||
30305 | 30305 | Harold Donohue D000419 | rep | MA | 1953-01-03 | 1955-01-03 | Democrat | 4 | |||||||||||||
30279 | 30279 | Glenn Davis D000102 | rep | WI | 1953-01-03 | 1955-01-03 | Republican | 2 | |||||||||||||
30271 | 30271 | Carl Curtis C001006 | rep | NE | 1953-01-03 | 1955-01-03 | Republican | 1 | |||||||||||||
30227 | 30227 | Clifford Case C000220 | rep | NJ | 1953-01-03 | 1955-01-03 | Republican | 6 | |||||||||||||
30202 | 30202 | Joel Broyhill B000967 | rep | VA | 1953-01-03 | 1955-01-03 | Republican | 10 | |||||||||||||
30184 | 30184 | William Bray B000778 | rep | IN | 1953-01-03 | 1955-01-03 | Republican | 7 | |||||||||||||
30168 | 30168 | John Blatnik B000550 | rep | MN | 1953-01-03 | 1955-01-03 | Democrat | 8 | |||||||||||||
30147 | 30147 | Leslie Arends A000216 | rep | IL | 1953-01-03 | 1955-01-03 | Republican | 17 | |||||||||||||
30118 | 30118 | John Watts W000212 | rep | KY | 1953-01-03 | 1955-01-03 | Democrat | 6 | |||||||||||||
30091 | 30091 | William Springer S000756 | rep | IL | 1953-01-03 | 1955-01-03 | Republican | 22 | |||||||||||||
30076 | 30076 | Hugh Scott S000174 | rep | PA | 1953-01-03 | 1955-01-03 | Republican | 6 | |||||||||||||
30027 | 30027 | Richard Poff P000401 | rep | VA | 1953-01-03 | 1955-01-03 | Republican | 6 | |||||||||||||
30010 | 30010 | Thomas Pelly P000196 | rep | WA | 1953-01-03 | 1955-01-03 | Republican | 1 | |||||||||||||
29995 | 29995 | Alvin O’Konski O000058 | rep | WI | 1953-01-03 | 1955-01-03 | Republican | 10 | |||||||||||||
29952 | 29952 | George Miller M000727 | rep | CA | 1953-01-03 | 1955-01-03 | Democrat | 8 | |||||||||||||
29938 | 29938 | John McMillan M000568 | rep | SC | 1953-01-03 | 1955-01-03 | Democrat | 6 | |||||||||||||
29914 | 29914 | William McCulloch M000393 | rep | OH | 1953-01-03 | 1955-01-03 | Republican | 4 | |||||||||||||
29884 | 29884 | Alton Lennon L000240 | sen | NC | 1953-07-10 | 1955-01-03 | 2 | Democrat | appointment | ||||||||||||
29857 | 29857 | Charles Jonas J000206 | rep | NC | 1953-01-03 | 1955-01-03 | Republican | 10 | |||||||||||||
29804 | 29804 | Edward Garmatz G000071 | rep | MD | 1953-01-03 | 1955-01-03 | Democrat | 3 | |||||||||||||
29780 | 29780 | James Fulton F000422 | rep | PA | 1953-01-03 | 1955-01-03 | Republican | 27 | |||||||||||||
29757 | 29757 | Edmond Edmondson E000054 | rep | OK | 1953-01-03 | 1955-01-03 | Democrat | 2 | |||||||||||||
29739 | 29739 | John Dowdy D000467 | rep | TX | 1953-01-03 | 1955-01-03 | Democrat | 7 | |||||||||||||
29722 | 29722 | Robert Corbett C000772 | rep | PA | 1953-01-03 | 1955-01-03 | Republican | 29 | |||||||||||||
29706 | 29706 | William Colmer C000645 | rep | MS | 1953-01-03 | 1955-01-03 | Democrat | 6 | |||||||||||||
29686 | 29686 | Emanuel Celler C000264 | rep | NY | 1953-01-03 | 1955-01-03 | Democrat | 11 | |||||||||||||
29654 | 29654 | John Byrnes B001216 | rep | WI | 1953-01-03 | 1955-01-03 | Republican | 8 | |||||||||||||
29640 | 29640 | James Byrne B001212 | rep | PA | 1953-01-03 | 1955-01-03 | Democrat | 3 | |||||||||||||
29624 | 29624 | Frank Bow B000676 | rep | OH | 1953-01-03 | 1955-01-03 | Republican | 16 | |||||||||||||
29613 | 29613 | Thomas Boggs B000594 | rep | LA | 1953-01-03 | 1955-01-03 | Democrat | 2 | |||||||||||||
29596 | 29596 | Jackson Betts B000426 | rep | OH | 1953-01-03 | 1955-01-03 | Republican | 8 | |||||||||||||
29585 | 29585 | Page Belcher B000323 | rep | OK | 1953-01-03 | 1955-01-03 | Republican | 1 | |||||||||||||
29561 | 29561 | Wayne Aspinall A000225 | rep | CO | 1953-01-03 | 1955-01-03 | Democrat | 4 | |||||||||||||
29549 | 29549 | George Andrews A000206 | rep | AL | 1953-01-03 | 1955-01-03 | Democrat | 3 |
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);