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 sorted by rowid descending
This data as json, copyable, CSV (advanced)
Suggested facets: type, end, party, end (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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
36449 | 36449 | Sidney Yates Y000013 | rep | IL | 1951-01-03 | 1953-01-03 | Democrat | 9 | |||||||||||||
35647 | 35647 | Jamie Whitten W000428 | rep | MS | 1951-01-03 | 1953-01-03 | Democrat | 2 | |||||||||||||
34234 | 34234 | Charles Bennett B000371 | rep | FL | 1951-01-03 | 1953-01-03 | Democrat | 2 | |||||||||||||
33816 | 33816 | Lloyd Bentsen B000401 | rep | TX | 1951-01-03 | 1953-01-03 | Democrat | 15 | |||||||||||||
33722 | 33722 | Peter Rodino R000374 | rep | NJ | 1951-01-03 | 1953-01-03 | Democrat | 10 | |||||||||||||
33698 | 33698 | Charles Price P000522 | rep | IL | 1951-01-03 | 1953-01-03 | Democrat | 25 | |||||||||||||
33192 | 33192 | Clement Zablocki Z000001 | rep | WI | 1951-01-03 | 1953-01-03 | Democrat | 4 | |||||||||||||
33088 | 33088 | Carl Perkins P000230 | rep | KY | 1951-01-03 | 1953-01-03 | Democrat | 7 | |||||||||||||
33004 | 33004 | Henry Jackson J000013 | rep | WA | 1951-01-03 | 1953-01-03 | Democrat | 2 | |||||||||||||
32734 | 32734 | Russell Long L000428 | sen | LA | 1951-01-03 | 1957-01-03 | 3 | Democrat | |||||||||||||
32490 | 32490 | Richard Bolling B000605 | rep | MO | 1951-01-03 | 1953-01-03 | Democrat | 5 | |||||||||||||
32315 | 32315 | Thomas Steed S000829 | rep | OK | 1951-01-03 | 1953-01-03 | Democrat | 4 | |||||||||||||
32299 | 32299 | Harley Staggers S000778 | rep | WV | 1951-01-03 | 1953-01-03 | Democrat | 2 | |||||||||||||
32062 | 32062 | Daniel Flood F000209 | rep | PA | 1951-01-03 | 1953-01-03 | Democrat | 11 | |||||||||||||
31849 | 31849 | Olin Teague T000110 | rep | TX | 1951-01-03 | 1953-01-03 | Democrat | 6 | |||||||||||||
31805 | 31805 | Robert Sikes S000406 | rep | FL | 1951-01-03 | 1953-01-03 | Democrat | 3 | |||||||||||||
31725 | 31725 | William Poage P000398 | rep | TX | 1951-01-03 | 1953-01-03 | Democrat | 11 | |||||||||||||
31629 | 31629 | George Mahon M000065 | rep | TX | 1951-01-03 | 1953-01-03 | Democrat | 19 | |||||||||||||
31513 | 31513 | James Delaney D000211 | rep | NY | 1951-01-03 | 1953-01-03 | Democrat | 6 | |||||||||||||
31455 | 31455 | Omar Burleson B001111 | rep | TX | 1951-01-03 | 1953-01-03 | Democrat | 17 | |||||||||||||
31403 | 31403 | Milton Young Y000047 | sen | ND | 1951-01-03 | 1957-01-03 | 3 | Republican | |||||||||||||
31297 | 31297 | Abraham Ribicoff R000191 | rep | CT | 1951-01-03 | 1953-01-03 | Democrat | 1 | |||||||||||||
31263 | 31263 | John Patman P000103 | rep | TX | 1951-01-03 | 1953-01-03 | Democrat | 1 | |||||||||||||
31239 | 31239 | Otto Passman P000098 | rep | LA | 1951-01-03 | 1953-01-03 | Democrat | 5 | |||||||||||||
31204 | 31204 | Thomas Morgan M000958 | rep | PA | 1951-01-03 | 1953-01-03 | Democrat | 24 | |||||||||||||
31187 | 31187 | Wilbur Mills M000778 | rep | AR | 1951-01-03 | 1953-01-03 | Democrat | 2 | |||||||||||||
31166 | 31166 | Warren Magnuson M000053 | sen | WA | 1951-01-03 | 1957-01-03 | 3 | Democrat | |||||||||||||
31147 | 31147 | Ray Madden M000039 | rep | IN | 1951-01-03 | 1953-01-03 | Democrat | 1 | |||||||||||||
31105 | 31105 | John Kluczynski K000273 | rep | IL | 1951-01-03 | 1953-01-03 | Democrat | 5 | |||||||||||||
31083 | 31083 | Robert Jones J000248 | rep | AL | 1951-01-03 | 1953-01-03 | Democrat | 8 | |||||||||||||
31068 | 31068 | Jacob Javits J000064 | rep | NY | 1951-01-03 | 1953-01-03 | Republican | 21 | |||||||||||||
31053 | 31053 | John Jarman J000057 | rep | OK | 1951-01-03 | 1953-01-03 | Democrat | 5 | |||||||||||||
31040 | 31040 | Felix Hébert H000437 | rep | LA | 1951-01-03 | 1953-01-03 | Democrat | 1 | |||||||||||||
30976 | 30976 | Wayne Hays H000408 | rep | OH | 1951-01-03 | 1953-01-03 | Democrat | 18 | |||||||||||||
30923 | 30923 | Joseph Evins E000273 | rep | TN | 1951-01-03 | 1953-01-03 | Democrat | 5 | |||||||||||||
30880 | 30880 | Norris Cotton C000802 | rep | NH | 1951-01-03 | 1953-01-03 | Republican | 2 | |||||||||||||
30822 | 30822 | William Barrett B000178 | rep | PA | 1951-01-03 | 1953-01-03 | Democrat | 1 | |||||||||||||
30805 | 30805 | Carl Albert A000073 | rep | OK | 1951-01-03 | 1953-01-03 | Democrat | 3 | |||||||||||||
30788 | 30788 | Gerald Ford F000260 | rep | MI | 1951-01-03 | 1953-01-03 | Republican | 5 | |||||||||||||
30749 | 30749 | William Widnall W000445 | rep | NJ | 1951-01-03 | 1953-01-03 | Republican | 7 | |||||||||||||
30667 | 30667 | John Saylor S000102 | rep | PA | 1951-01-03 | 1953-01-03 | Republican | 26 | |||||||||||||
30645 | 30645 | John Rooney R000424 | rep | NY | 1951-01-03 | 1953-01-03 | Democrat | 12 | |||||||||||||
30485 | 30485 | Chester Holifield H000713 | rep | CA | 1951-01-03 | 1953-01-03 | Democrat | 19 | |||||||||||||
30415 | 30415 | Harold Gross G000495 | rep | IA | 1951-01-03 | 1953-01-03 | Republican | 3 | |||||||||||||
30348 | 30348 | Ovie Fisher F000152 | rep | TX | 1951-01-03 | 1953-01-03 | Democrat | 21 | |||||||||||||
30317 | 30317 | William Dorn D000434 | rep | SC | 1951-01-03 | 1953-01-03 | Democrat | 3 | |||||||||||||
30304 | 30304 | Harold Donohue D000419 | rep | MA | 1951-01-03 | 1953-01-03 | Democrat | 4 | |||||||||||||
30278 | 30278 | Glenn Davis D000102 | rep | WI | 1951-01-03 | 1953-01-03 | Republican | 2 | |||||||||||||
30270 | 30270 | Carl Curtis C001006 | rep | NE | 1951-01-03 | 1953-01-03 | Republican | 1 | |||||||||||||
30226 | 30226 | Clifford Case C000220 | rep | NJ | 1951-01-03 | 1953-01-03 | Republican | 6 | |||||||||||||
30183 | 30183 | William Bray B000778 | rep | IN | 1951-01-03 | 1953-01-03 | Republican | 7 | |||||||||||||
30167 | 30167 | John Blatnik B000550 | rep | MN | 1951-01-03 | 1953-01-03 | Democrat | 8 | |||||||||||||
30146 | 30146 | Leslie Arends A000216 | rep | IL | 1951-01-03 | 1953-01-03 | Republican | 17 | |||||||||||||
30117 | 30117 | John Watts W000212 | rep | KY | 1951-01-03 | 1953-01-03 | Democrat | 6 | |||||||||||||
30090 | 30090 | William Springer S000756 | rep | IL | 1951-01-03 | 1953-01-03 | Republican | 22 | |||||||||||||
30075 | 30075 | Hugh Scott S000174 | rep | PA | 1951-01-03 | 1953-01-03 | Republican | 6 | |||||||||||||
29994 | 29994 | Alvin O’Konski O000058 | rep | WI | 1951-01-03 | 1953-01-03 | Republican | 10 | |||||||||||||
29951 | 29951 | George Miller M000727 | rep | CA | 1951-01-03 | 1953-01-03 | Democrat | 6 | |||||||||||||
29937 | 29937 | John McMillan M000568 | rep | SC | 1951-01-03 | 1953-01-03 | Democrat | 6 | |||||||||||||
29913 | 29913 | William McCulloch M000393 | rep | OH | 1951-01-03 | 1953-01-03 | Republican | 4 | |||||||||||||
29906 | 29906 | Michael Mansfield M000113 | rep | MT | 1951-01-03 | 1953-01-03 | Democrat | 1 | |||||||||||||
29803 | 29803 | Edward Garmatz G000071 | rep | MD | 1951-01-03 | 1953-01-03 | Democrat | 3 | |||||||||||||
29779 | 29779 | James Fulton F000422 | rep | PA | 1951-01-03 | 1953-01-03 | Republican | 31 | |||||||||||||
29738 | 29738 | John Dowdy D000467 | rep | TX | 1951-01-03 | 1953-01-03 | Democrat | 7 | |||||||||||||
29721 | 29721 | Robert Corbett C000772 | rep | PA | 1951-01-03 | 1953-01-03 | Republican | 30 | |||||||||||||
29705 | 29705 | William Colmer C000645 | rep | MS | 1951-01-03 | 1953-01-03 | Democrat | 6 | |||||||||||||
29685 | 29685 | Emanuel Celler C000264 | rep | NY | 1951-01-03 | 1953-01-03 | Democrat | 15 | |||||||||||||
29653 | 29653 | John Byrnes B001216 | rep | WI | 1951-01-03 | 1953-01-03 | Republican | 8 | |||||||||||||
29623 | 29623 | Frank Bow B000676 | rep | OH | 1951-01-03 | 1953-01-03 | Republican | 16 | |||||||||||||
29612 | 29612 | Thomas Boggs B000594 | rep | LA | 1951-01-03 | 1953-01-03 | Democrat | 2 | |||||||||||||
29595 | 29595 | Jackson Betts B000426 | rep | OH | 1951-01-03 | 1953-01-03 | Republican | 8 | |||||||||||||
29584 | 29584 | Page Belcher B000323 | rep | OK | 1951-01-03 | 1953-01-03 | Republican | 8 | |||||||||||||
29572 | 29572 | Walter Baring B000141 | rep | NV | 1951-01-03 | 1953-01-03 | Democrat | 0 | |||||||||||||
29560 | 29560 | Wayne Aspinall A000225 | rep | CO | 1951-01-03 | 1953-01-03 | Democrat | 4 | |||||||||||||
29548 | 29548 | George Andrews A000206 | rep | AL | 1951-01-03 | 1953-01-03 | Democrat | 3 | |||||||||||||
29528 | 29528 | Thomas Abernethy A000016 | rep | MS | 1951-01-03 | 1953-01-03 | Democrat | 4 | |||||||||||||
29513 | 29513 | Watkins Abbitt A000002 | rep | VA | 1951-01-03 | 1953-01-03 | Democrat | 4 | |||||||||||||
29510 | 29510 | Richard Nixon N000116 | sen | CA | 1951-01-03 | 1953-12-31 | 3 | Republican | |||||||||||||
29458 | 29458 | Byron Rogers R000389 | rep | CO | 1951-01-03 | 1953-01-03 | Democrat | 1 | |||||||||||||
29448 | 29448 | Lucius Rivers R000280 | rep | SC | 1951-01-03 | 1953-01-03 | Democrat | 1 | |||||||||||||
29425 | 29425 | Adam Powell P000477 | rep | NY | 1951-01-03 | 1953-01-03 | Democrat | 22 | |||||||||||||
29410 | 29410 | Philip Philbin P000303 | rep | MA | 1951-01-03 | 1953-01-03 | Democrat | 3 | |||||||||||||
29376 | 29376 | John McCormack M000364 | rep | MA | 1951-01-03 | 1953-01-03 | Democrat | 12 | |||||||||||||
29309 | 29309 | Michael Kirwan K000244 | rep | OH | 1951-01-03 | 1953-01-03 | Democrat | 19 | |||||||||||||
29282 | 29282 | James Fulbright F000401 | sen | AR | 1951-01-03 | 1957-01-03 | 3 | Democrat | |||||||||||||
29259 | 29259 | Michael Feighan F000060 | rep | OH | 1951-01-03 | 1953-01-03 | Democrat | 20 | |||||||||||||
29238 | 29238 | George Fallon F000012 | rep | MD | 1951-01-03 | 1953-01-03 | Democrat | 4 | |||||||||||||
29208 | 29208 | William Dawson D000158 | rep | IL | 1951-01-03 | 1953-01-03 | Democrat | 1 | |||||||||||||
29149 | 29149 | Ellis Berry B000416 | rep | SD | 1951-01-03 | 1953-01-03 | Republican | 2 | |||||||||||||
29145 | 29145 | Wallace Bennett B000384 | sen | UT | 1951-01-03 | 1957-01-03 | 3 | Republican | |||||||||||||
29130 | 29130 | William Bates B000239 | rep | MA | 1951-01-03 | 1953-01-03 | Republican | 6 | |||||||||||||
29119 | 29119 | William Ayres A000229 | rep | OH | 1951-01-03 | 1953-01-03 | Republican | 14 | |||||||||||||
29115 | 29115 | George Aiken A000062 | sen | VT | 1951-01-03 | 1957-01-03 | 3 | Republican | |||||||||||||
29103 | 29103 | Edwin Adair A000024 | rep | IN | 1951-01-03 | 1953-01-03 | Republican | 4 | |||||||||||||
29079 | 29079 | Edwin Willis W000559 | rep | LA | 1951-01-03 | 1953-01-03 | Democrat | 3 | |||||||||||||
29069 | 29069 | John Williams W000517 | rep | MS | 1951-01-03 | 1953-01-03 | Democrat | 7 | |||||||||||||
29015 | 29015 | George Rhodes R000187 | rep | PA | 1951-01-03 | 1953-01-03 | Democrat | 13 | |||||||||||||
28979 | 28979 | Abraham Multer M001074 | rep | NY | 1951-01-03 | 1953-01-03 | Democrat | 14 | |||||||||||||
28947 | 28947 | Cecil King K000196 | rep | CA | 1951-01-03 | 1953-01-03 | Democrat | 17 | |||||||||||||
28933 | 28933 | Edna Kelly K000070 | rep | NY | 1951-01-03 | 1953-01-03 | Democrat | 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);