legislator_terms
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
480 rows where "end" is on date 1959-01-03 sorted by party
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
28149 | 28149 | Harry Sheppard S000335 | rep | CA | 1957-01-03 | 1959-01-03 | Democrat | 27 | |||||||||||||
28183 | 28183 | William Thornberry T000237 | rep | TX | 1957-01-03 | 1959-01-03 | Democrat | 10 | |||||||||||||
28225 | 28225 | Carl Vinson V000105 | rep | GA | 1957-01-03 | 1959-01-03 | Democrat | 6 | |||||||||||||
28244 | 28244 | Francis Walter W000108 | rep | PA | 1957-01-03 | 1959-01-03 | Democrat | 15 | |||||||||||||
28290 | 28290 | William Winstead W000641 | rep | MS | 1957-01-03 | 1959-01-03 | Democrat | 5 | |||||||||||||
28303 | 28303 | Ross Bass B000223 | rep | TN | 1957-01-03 | 1959-01-03 | Democrat | 6 | |||||||||||||
28324 | 28324 | Lindley Beckworth B000296 | rep | TX | 1957-01-03 | 1959-01-03 | Democrat | 3 | |||||||||||||
28338 | 28338 | Herbert Bonner B000621 | rep | NC | 1957-01-03 | 1959-01-03 | Democrat | 1 | |||||||||||||
28367 | 28367 | Frank Chelf C000342 | rep | KY | 1957-01-03 | 1959-01-03 | Democrat | 4 | |||||||||||||
28385 | 28385 | Harold Cooley C000736 | rep | NC | 1957-01-03 | 1959-01-03 | Democrat | 4 | |||||||||||||
28409 | 28409 | Winfield Denton D000260 | rep | IN | 1957-01-03 | 1959-01-03 | Democrat | 8 | |||||||||||||
28432 | 28432 | Albert Gore G000320 | sen | TN | 1953-01-03 | 1959-01-03 | 1 | Democrat | |||||||||||||
28441 | 28441 | Harlan Hagen H000013 | rep | CA | 1957-01-03 | 1959-01-03 | Democrat | 14 | |||||||||||||
28455 | 28455 | Oren Harris H000249 | rep | AR | 1957-01-03 | 1959-01-03 | Democrat | 4 | |||||||||||||
28471 | 28471 | Spessard Holland H000720 | sen | FL | 1953-01-03 | 1959-01-03 | 1 | Democrat | |||||||||||||
28476 | 28476 | William Jennings J000098 | rep | VA | 1957-01-03 | 1959-01-03 | Democrat | 9 | |||||||||||||
28487 | 28487 | Paul Jones J000246 | rep | MO | 1957-01-03 | 1959-01-03 | Democrat | 10 | |||||||||||||
28503 | 28503 | Eugene Keogh K000130 | rep | NY | 1957-01-03 | 1959-01-03 | Democrat | 9 | |||||||||||||
28552 | 28552 | Donald Matthews M000253 | rep | FL | 1957-01-03 | 1959-01-03 | Democrat | 8 | |||||||||||||
28561 | 28561 | Eugene McCarthy M000311 | rep | MN | 1957-01-03 | 1959-01-03 | Democrat | 4 | |||||||||||||
28581 | 28581 | James Morrison M000995 | rep | LA | 1957-01-03 | 1959-01-03 | Democrat | 6 | |||||||||||||
28594 | 28594 | Thomas Murray M001114 | rep | TN | 1957-01-03 | 1959-01-03 | Democrat | 7 | |||||||||||||
28602 | 28602 | Leo O’Brien O000015 | rep | NY | 1957-01-03 | 1959-01-03 | Democrat | 30 | |||||||||||||
28624 | 28624 | Walter Rogers R000404 | rep | TX | 1957-01-03 | 1959-01-03 | Democrat | 18 | |||||||||||||
28630 | 28630 | James Roosevelt R000426 | rep | CA | 1957-01-03 | 1959-01-03 | Democrat | 26 | |||||||||||||
28638 | 28638 | Ralph Scott S000184 | rep | NC | 1957-01-03 | 1959-01-03 | Democrat | 5 | |||||||||||||
28670 | 28670 | Howard Smith S000554 | rep | VA | 1957-01-03 | 1959-01-03 | Democrat | 8 | |||||||||||||
28687 | 28687 | Albert Thomas T000156 | rep | TX | 1957-01-03 | 1959-01-03 | Democrat | 8 | |||||||||||||
28699 | 28699 | Clark Thompson T000198 | rep | TX | 1957-01-03 | 1959-01-03 | Democrat | 9 | |||||||||||||
28706 | 28706 | Theo Thompson T000218 | rep | LA | 1957-01-03 | 1959-01-03 | Democrat | 7 | |||||||||||||
28722 | 28722 | James Trimble T000373 | rep | AR | 1957-01-03 | 1959-01-03 | Democrat | 3 | |||||||||||||
28743 | 28743 | Ralph Yarborough Y000006 | sen | TX | 1957-01-03 | 1959-01-03 | 1 | Democrat | |||||||||||||
28766 | 28766 | Robert Ashmore A000223 | rep | SC | 1957-01-03 | 1959-01-03 | Democrat | 4 | |||||||||||||
28778 | 28778 | Edward Bartlett B000201 | rep | AK | 1957-01-03 | 1959-01-03 | Democrat | 0 | |||||||||||||
28838 | 28838 | John Fogarty F000233 | rep | RI | 1957-01-03 | 1959-01-03 | Democrat | 2 | |||||||||||||
28854 | 28854 | Ezekiel Gathings G000098 | rep | AR | 1957-01-03 | 1959-01-03 | Democrat | 1 | |||||||||||||
28882 | 28882 | Porter Hardy H000197 | rep | VA | 1957-01-03 | 1959-01-03 | Democrat | 2 | |||||||||||||
28899 | 28899 | Albert Herlong H000530 | rep | FL | 1957-01-03 | 1959-01-03 | Democrat | 5 | |||||||||||||
28907 | 28907 | Elmer Holland H000717 | rep | PA | 1957-01-03 | 1959-01-03 | Democrat | 30 | |||||||||||||
28926 | 28926 | Frank Karsten K000013 | rep | MO | 1957-01-03 | 1959-01-03 | Democrat | 1 | |||||||||||||
28936 | 28936 | Edna Kelly K000070 | rep | NY | 1957-01-03 | 1959-01-03 | Democrat | 10 | |||||||||||||
28950 | 28950 | Cecil King K000196 | rep | CA | 1957-01-03 | 1959-01-03 | Democrat | 17 | |||||||||||||
28982 | 28982 | Abraham Multer M001074 | rep | NY | 1957-01-03 | 1959-01-03 | Democrat | 13 | |||||||||||||
29001 | 29001 | Barratt O’Hara O000053 | rep | IL | 1957-01-03 | 1959-01-03 | Democrat | 2 | |||||||||||||
29018 | 29018 | George Rhodes R000187 | rep | PA | 1957-01-03 | 1959-01-03 | Democrat | 14 | |||||||||||||
29033 | 29033 | Armistead Selden S000232 | rep | AL | 1957-01-03 | 1959-01-03 | Democrat | 6 | |||||||||||||
29053 | 29053 | William Tuck T000395 | rep | VA | 1957-01-03 | 1959-01-03 | Democrat | 5 | |||||||||||||
29061 | 29061 | Basil Whitener W000410 | rep | NC | 1957-01-03 | 1959-01-03 | Democrat | 11 | |||||||||||||
29072 | 29072 | John Williams W000517 | rep | MS | 1957-01-03 | 1959-01-03 | Democrat | 4 | |||||||||||||
29082 | 29082 | Edwin Willis W000559 | rep | LA | 1957-01-03 | 1959-01-03 | Democrat | 3 | |||||||||||||
29211 | 29211 | William Dawson D000158 | rep | IL | 1957-01-03 | 1959-01-03 | Democrat | 1 | |||||||||||||
29228 | 29228 | Robert Everett E000266 | rep | TN | 1957-01-03 | 1959-01-03 | Democrat | 8 | |||||||||||||
29241 | 29241 | George Fallon F000012 | rep | MD | 1957-01-03 | 1959-01-03 | Democrat | 4 | |||||||||||||
29248 | 29248 | Leonard Farbstein F000015 | rep | NY | 1957-01-03 | 1959-01-03 | Democrat | 19 | |||||||||||||
29262 | 29262 | Michael Feighan F000060 | rep | OH | 1957-01-03 | 1959-01-03 | Democrat | 20 | |||||||||||||
29273 | 29273 | Samuel Friedel F000384 | rep | MD | 1957-01-03 | 1959-01-03 | Democrat | 7 | |||||||||||||
29312 | 29312 | Michael Kirwan K000244 | rep | OH | 1957-01-03 | 1959-01-03 | Democrat | 19 | |||||||||||||
29379 | 29379 | John McCormack M000364 | rep | MA | 1957-01-03 | 1959-01-03 | Democrat | 12 | |||||||||||||
29413 | 29413 | Philip Philbin P000303 | rep | MA | 1957-01-03 | 1959-01-03 | Democrat | 3 | |||||||||||||
29428 | 29428 | Adam Powell P000477 | rep | NY | 1957-01-03 | 1959-01-03 | Democrat | 16 | |||||||||||||
29451 | 29451 | Lucius Rivers R000280 | rep | SC | 1957-01-03 | 1959-01-03 | Democrat | 1 | |||||||||||||
29461 | 29461 | Byron Rogers R000389 | rep | CO | 1957-01-03 | 1959-01-03 | Democrat | 1 | |||||||||||||
29516 | 29516 | Watkins Abbitt A000002 | rep | VA | 1957-01-03 | 1959-01-03 | Democrat | 4 | |||||||||||||
29531 | 29531 | Thomas Abernethy A000016 | rep | MS | 1957-01-03 | 1959-01-03 | Democrat | 1 | |||||||||||||
29551 | 29551 | George Andrews A000206 | rep | AL | 1957-01-03 | 1959-01-03 | Democrat | 3 | |||||||||||||
29563 | 29563 | Wayne Aspinall A000225 | rep | CO | 1957-01-03 | 1959-01-03 | Democrat | 4 | |||||||||||||
29573 | 29573 | Walter Baring B000141 | rep | NV | 1957-01-03 | 1959-01-03 | Democrat | 0 | |||||||||||||
29615 | 29615 | Thomas Boggs B000594 | rep | LA | 1957-01-03 | 1959-01-03 | Democrat | 2 | |||||||||||||
29642 | 29642 | James Byrne B001212 | rep | PA | 1957-01-03 | 1959-01-03 | Democrat | 3 | |||||||||||||
29688 | 29688 | Emanuel Celler C000264 | rep | NY | 1957-01-03 | 1959-01-03 | Democrat | 11 | |||||||||||||
29708 | 29708 | William Colmer C000645 | rep | MS | 1957-01-03 | 1959-01-03 | Democrat | 6 | |||||||||||||
29741 | 29741 | John Dowdy D000467 | rep | TX | 1957-01-03 | 1959-01-03 | Democrat | 7 | |||||||||||||
29759 | 29759 | Edmond Edmondson E000054 | rep | OK | 1957-01-03 | 1959-01-03 | Democrat | 2 | |||||||||||||
29806 | 29806 | Edward Garmatz G000071 | rep | MD | 1957-01-03 | 1959-01-03 | Democrat | 3 | |||||||||||||
29849 | 29849 | William Hull H000947 | rep | MO | 1957-01-03 | 1959-01-03 | Democrat | 6 | |||||||||||||
29885 | 29885 | Alton Lennon L000240 | rep | NC | 1957-01-03 | 1959-01-03 | Democrat | 7 | |||||||||||||
29907 | 29907 | Michael Mansfield M000113 | sen | MT | 1953-01-03 | 1959-01-03 | 1 | Democrat | |||||||||||||
29940 | 29940 | John McMillan M000568 | rep | SC | 1957-01-03 | 1959-01-03 | Democrat | 6 | |||||||||||||
29954 | 29954 | George Miller M000727 | rep | CA | 1957-01-03 | 1959-01-03 | Democrat | 8 | |||||||||||||
29969 | 29969 | Joseph Montoya M000876 | rep | NM | 1957-01-03 | 1959-01-03 | Democrat | 0 | |||||||||||||
30006 | 30006 | John Pastore P000100 | sen | RI | 1953-01-03 | 1959-01-03 | 1 | Democrat | |||||||||||||
30101 | 30101 | William Symington S001136 | sen | MO | 1953-01-03 | 1959-01-03 | 1 | Democrat | |||||||||||||
30120 | 30120 | John Watts W000212 | rep | KY | 1957-01-03 | 1959-01-03 | Democrat | 6 | |||||||||||||
30170 | 30170 | John Blatnik B000550 | rep | MN | 1957-01-03 | 1959-01-03 | Democrat | 8 | |||||||||||||
30242 | 30242 | Frank Clark C000431 | rep | PA | 1957-01-03 | 1959-01-03 | Democrat | 25 | |||||||||||||
30307 | 30307 | Harold Donohue D000419 | rep | MA | 1957-01-03 | 1959-01-03 | Democrat | 4 | |||||||||||||
30320 | 30320 | William Dorn D000434 | rep | SC | 1957-01-03 | 1959-01-03 | Democrat | 3 | |||||||||||||
30351 | 30351 | Ovie Fisher F000152 | rep | TX | 1957-01-03 | 1959-01-03 | Democrat | 21 | |||||||||||||
30387 | 30387 | Edith Green G000407 | rep | OR | 1957-01-03 | 1959-01-03 | Democrat | 3 | |||||||||||||
30405 | 30405 | Martha Griffiths G000471 | rep | MI | 1957-01-03 | 1959-01-03 | Democrat | 17 | |||||||||||||
30488 | 30488 | Chester Holifield H000713 | rep | CA | 1957-01-03 | 1959-01-03 | Democrat | 19 | |||||||||||||
30577 | 30577 | Lee Metcalf M000671 | rep | MT | 1957-01-03 | 1959-01-03 | Democrat | 1 | |||||||||||||
30648 | 30648 | John Rooney R000424 | rep | NY | 1957-01-03 | 1959-01-03 | Democrat | 14 | |||||||||||||
30808 | 30808 | Carl Albert A000073 | rep | OK | 1957-01-03 | 1959-01-03 | Democrat | 3 | |||||||||||||
30825 | 30825 | William Barrett B000178 | rep | PA | 1957-01-03 | 1959-01-03 | Democrat | 1 | |||||||||||||
30926 | 30926 | Joseph Evins E000273 | rep | TN | 1957-01-03 | 1959-01-03 | Democrat | 4 | |||||||||||||
30959 | 30959 | James Haley H000041 | rep | FL | 1957-01-03 | 1959-01-03 | Democrat | 7 | |||||||||||||
30979 | 30979 | Wayne Hays H000408 | rep | OH | 1957-01-03 | 1959-01-03 | Democrat | 18 | |||||||||||||
31043 | 31043 | Felix Hébert H000437 | rep | LA | 1957-01-03 | 1959-01-03 | Democrat | 1 | |||||||||||||
31056 | 31056 | John Jarman J000057 | rep | OK | 1957-01-03 | 1959-01-03 | Democrat | 5 |
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);