legislator_terms
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
489 rows where "end" is on date 1963-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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
28566 | 28566 | Harris McDowell M000418 | rep | DE | 1961-01-03 | 1963-01-03 | Democrat | 0 | |||||||||||||
28572 | 28572 | Walter Moeller M000836 | rep | OH | 1961-01-03 | 1963-01-03 | Democrat | 10 | |||||||||||||
28583 | 28583 | James Morrison M000995 | rep | LA | 1961-01-03 | 1963-01-03 | Democrat | 6 | |||||||||||||
28596 | 28596 | Thomas Murray M001114 | rep | TN | 1961-01-03 | 1963-01-03 | Democrat | 7 | |||||||||||||
28604 | 28604 | Leo O’Brien O000015 | rep | NY | 1961-01-03 | 1963-01-03 | Democrat | 30 | |||||||||||||
28618 | 28618 | Ralph Rivers R000282 | rep | AK | 1961-01-03 | 1963-01-03 | Democrat | 0 | |||||||||||||
28626 | 28626 | Walter Rogers R000404 | rep | TX | 1961-01-03 | 1963-01-03 | Democrat | 18 | |||||||||||||
28632 | 28632 | James Roosevelt R000426 | rep | CA | 1961-01-03 | 1963-01-03 | Democrat | 26 | |||||||||||||
28640 | 28640 | Ralph Scott S000184 | rep | NC | 1961-01-03 | 1963-01-03 | Democrat | 5 | |||||||||||||
28672 | 28672 | Howard Smith S000554 | rep | VA | 1961-01-03 | 1963-01-03 | Democrat | 8 | |||||||||||||
28689 | 28689 | Albert Thomas T000156 | rep | TX | 1961-01-03 | 1963-01-03 | Democrat | 8 | |||||||||||||
28701 | 28701 | Clark Thompson T000198 | rep | TX | 1961-01-03 | 1963-01-03 | Democrat | 9 | |||||||||||||
28708 | 28708 | Theo Thompson T000218 | rep | LA | 1961-01-03 | 1963-01-03 | Democrat | 7 | |||||||||||||
28713 | 28713 | Herman Toll T000297 | rep | PA | 1961-01-03 | 1963-01-03 | Democrat | 6 | |||||||||||||
28724 | 28724 | James Trimble T000373 | rep | AR | 1961-01-03 | 1963-01-03 | Democrat | 3 | |||||||||||||
28727 | 28727 | Stanley Tupper T000411 | rep | ME | 1961-01-03 | 1963-01-03 | Republican | 2 | |||||||||||||
28768 | 28768 | Robert Ashmore A000223 | rep | SC | 1961-01-03 | 1963-01-03 | Democrat | 4 | |||||||||||||
28798 | 28798 | Frances Bolton B000607 | rep | OH | 1961-01-03 | 1963-01-03 | Republican | 22 | |||||||||||||
28812 | 28812 | Thomas Curtis C001014 | rep | MO | 1961-01-03 | 1963-01-03 | Republican | 2 | |||||||||||||
28826 | 28826 | Paul Fino F000137 | rep | NY | 1961-01-03 | 1963-01-03 | Republican | 25 | |||||||||||||
28840 | 28840 | John Fogarty F000233 | rep | RI | 1961-01-03 | 1963-01-03 | Democrat | 2 | |||||||||||||
28856 | 28856 | Ezekiel Gathings G000098 | rep | AR | 1961-01-03 | 1963-01-03 | Democrat | 1 | |||||||||||||
28873 | 28873 | Charles Halleck H000081 | rep | IN | 1961-01-03 | 1963-01-03 | Republican | 2 | |||||||||||||
28884 | 28884 | Porter Hardy H000197 | rep | VA | 1961-01-03 | 1963-01-03 | Democrat | 2 | |||||||||||||
28892 | 28892 | William Harrison H000278 | rep | WY | 1961-01-03 | 1963-01-03 | Republican | 0 | |||||||||||||
28901 | 28901 | Albert Herlong H000530 | rep | FL | 1961-01-03 | 1963-01-03 | Democrat | 5 | |||||||||||||
28909 | 28909 | Elmer Holland H000717 | rep | PA | 1961-01-03 | 1963-01-03 | Democrat | 30 | |||||||||||||
28928 | 28928 | Frank Karsten K000013 | rep | MO | 1961-01-03 | 1963-01-03 | Democrat | 1 | |||||||||||||
28938 | 28938 | Edna Kelly K000070 | rep | NY | 1961-01-03 | 1963-01-03 | Democrat | 10 | |||||||||||||
28952 | 28952 | Cecil King K000196 | rep | CA | 1961-01-03 | 1963-01-03 | Democrat | 17 | |||||||||||||
28956 | 28956 | Horace Kornegay K000318 | rep | NC | 1961-01-03 | 1963-01-03 | Democrat | 6 | |||||||||||||
28968 | 28968 | Arch Moore M000892 | rep | WV | 1961-01-03 | 1963-01-03 | Republican | 1 | |||||||||||||
28973 | 28973 | Thomas Morris M000990 | rep | NM | 1961-01-03 | 1963-01-03 | Democrat | 0 | |||||||||||||
28984 | 28984 | Abraham Multer M001074 | rep | NY | 1961-01-03 | 1963-01-03 | Democrat | 13 | |||||||||||||
29003 | 29003 | Barratt O’Hara O000053 | rep | IL | 1961-01-03 | 1963-01-03 | Democrat | 2 | |||||||||||||
29020 | 29020 | George Rhodes R000187 | rep | PA | 1961-01-03 | 1963-01-03 | Democrat | 14 | |||||||||||||
29035 | 29035 | Armistead Selden S000232 | rep | AL | 1961-01-03 | 1963-01-03 | Democrat | 6 | |||||||||||||
29055 | 29055 | William Tuck T000395 | rep | VA | 1961-01-03 | 1963-01-03 | Democrat | 5 | |||||||||||||
29063 | 29063 | Basil Whitener W000410 | rep | NC | 1961-01-03 | 1963-01-03 | Democrat | 11 | |||||||||||||
29074 | 29074 | John Williams W000517 | rep | MS | 1961-01-03 | 1963-01-03 | Democrat | 4 | |||||||||||||
29084 | 29084 | Edwin Willis W000559 | rep | LA | 1961-01-03 | 1963-01-03 | Democrat | 3 | |||||||||||||
29092 | 29092 | Jesse Younger Y000060 | rep | CA | 1961-01-03 | 1963-01-03 | Republican | 9 | |||||||||||||
29099 | 29099 | Charles Goodell G000282 | rep | NY | 1961-01-03 | 1963-01-03 | Republican | 43 | |||||||||||||
29108 | 29108 | Edwin Adair A000024 | rep | IN | 1961-01-03 | 1963-01-03 | Republican | 4 | |||||||||||||
29116 | 29116 | George Aiken A000062 | sen | VT | 1957-01-03 | 1963-01-03 | 3 | Republican | |||||||||||||
29124 | 29124 | William Ayres A000229 | rep | OH | 1961-01-03 | 1963-01-03 | Republican | 14 | |||||||||||||
29135 | 29135 | William Bates B000239 | rep | MA | 1961-01-03 | 1963-01-03 | Republican | 6 | |||||||||||||
29140 | 29140 | James Battin B000241 | rep | MT | 1961-01-03 | 1963-01-03 | Republican | 2 | |||||||||||||
29146 | 29146 | Wallace Bennett B000384 | sen | UT | 1957-01-03 | 1963-01-03 | 3 | Republican | |||||||||||||
29154 | 29154 | Ellis Berry B000416 | rep | SD | 1961-01-03 | 1963-01-03 | Republican | 2 | |||||||||||||
29160 | 29160 | Alan Bible B000436 | sen | NV | 1957-01-03 | 1963-01-03 | 3 | Democrat | |||||||||||||
29170 | 29170 | William Cahill C000019 | rep | NJ | 1961-01-03 | 1963-01-03 | Republican | 1 | |||||||||||||
29176 | 29176 | Jeffery Cohelan C000596 | rep | CA | 1961-01-03 | 1963-01-03 | Democrat | 7 | |||||||||||||
29186 | 29186 | William Cramer C000869 | rep | FL | 1961-01-03 | 1963-01-03 | Republican | 1 | |||||||||||||
29193 | 29193 | Glenn Cunningham C000991 | rep | NE | 1961-01-03 | 1963-01-03 | Republican | 2 | |||||||||||||
29199 | 29199 | Emilio Daddario D000001 | rep | CT | 1961-01-03 | 1963-01-03 | Democrat | 1 | |||||||||||||
29213 | 29213 | William Dawson D000158 | rep | IL | 1961-01-03 | 1963-01-03 | Democrat | 1 | |||||||||||||
29220 | 29220 | Peter Dominick D000409 | rep | CO | 1961-01-03 | 1963-01-03 | Republican | 2 | |||||||||||||
29225 | 29225 | Samuel Ervin E000211 | sen | NC | 1957-01-03 | 1963-01-03 | 3 | Democrat | |||||||||||||
29230 | 29230 | Robert Everett E000266 | rep | TN | 1961-01-03 | 1963-01-03 | Democrat | 8 | |||||||||||||
29243 | 29243 | George Fallon F000012 | rep | MD | 1961-01-03 | 1963-01-03 | Democrat | 4 | |||||||||||||
29250 | 29250 | Leonard Farbstein F000015 | rep | NY | 1961-01-03 | 1963-01-03 | Democrat | 19 | |||||||||||||
29264 | 29264 | Michael Feighan F000060 | rep | OH | 1961-01-03 | 1963-01-03 | Democrat | 20 | |||||||||||||
29275 | 29275 | Samuel Friedel F000384 | rep | MD | 1961-01-03 | 1963-01-03 | Democrat | 7 | |||||||||||||
29283 | 29283 | James Fulbright F000401 | sen | AR | 1957-01-03 | 1963-01-03 | 3 | Democrat | |||||||||||||
29287 | 29287 | Jacob Gilbert G000175 | rep | NY | 1961-01-03 | 1963-01-03 | Democrat | 23 | |||||||||||||
29297 | 29297 | Charles Joelson J000108 | rep | NJ | 1961-01-03 | 1963-01-03 | Democrat | 8 | |||||||||||||
29314 | 29314 | Michael Kirwan K000244 | rep | OH | 1961-01-03 | 1963-01-03 | Democrat | 19 | |||||||||||||
29325 | 29325 | Melvin Laird L000024 | rep | WI | 1961-01-03 | 1963-01-03 | Republican | 7 | |||||||||||||
29331 | 29331 | Odin Langen L000069 | rep | MN | 1961-01-03 | 1963-01-03 | Republican | 9 | |||||||||||||
29340 | 29340 | Glenard Lipscomb L000344 | rep | CA | 1961-01-03 | 1963-01-03 | Republican | 24 | |||||||||||||
29346 | 29346 | Clark MacGregor M000010 | rep | MN | 1961-01-03 | 1963-01-03 | Republican | 3 | |||||||||||||
29356 | 29356 | Catherine May M000273 | rep | WA | 1961-01-03 | 1963-01-03 | Republican | 4 | |||||||||||||
29381 | 29381 | John McCormack M000364 | rep | MA | 1961-01-03 | 1963-01-03 | Democrat | 12 | |||||||||||||
29393 | 29393 | William Murphy M001104 | rep | IL | 1961-01-03 | 1963-01-03 | Democrat | 3 | |||||||||||||
29401 | 29401 | Arnold Olsen O000083 | rep | MT | 1961-01-03 | 1963-01-03 | Democrat | 1 | |||||||||||||
29415 | 29415 | Philip Philbin P000303 | rep | MA | 1961-01-03 | 1963-01-03 | Democrat | 3 | |||||||||||||
29430 | 29430 | Adam Powell P000477 | rep | NY | 1961-01-03 | 1963-01-03 | Democrat | 16 | |||||||||||||
29435 | 29435 | Benjamin Reifel R000152 | rep | SD | 1961-01-03 | 1963-01-03 | Republican | 1 | |||||||||||||
29453 | 29453 | Lucius Rivers R000280 | rep | SC | 1961-01-03 | 1963-01-03 | Democrat | 1 | |||||||||||||
29463 | 29463 | Byron Rogers R000389 | rep | CO | 1961-01-03 | 1963-01-03 | Democrat | 1 | |||||||||||||
29471 | 29471 | Richard Roudebush R000464 | rep | IN | 1961-01-03 | 1963-01-03 | Republican | 6 | |||||||||||||
29481 | 29481 | Henry Schadeberg S000108 | rep | WI | 1961-01-03 | 1963-01-03 | Republican | 1 | |||||||||||||
29494 | 29494 | James Utt U000034 | rep | CA | 1961-01-03 | 1963-01-03 | Republican | 28 | |||||||||||||
29518 | 29518 | Watkins Abbitt A000002 | rep | VA | 1961-01-03 | 1963-01-03 | Democrat | 4 | |||||||||||||
29533 | 29533 | Thomas Abernethy A000016 | rep | MS | 1961-01-03 | 1963-01-03 | Democrat | 1 | |||||||||||||
29553 | 29553 | George Andrews A000206 | rep | AL | 1961-01-03 | 1963-01-03 | Democrat | 3 | |||||||||||||
29565 | 29565 | Wayne Aspinall A000225 | rep | CO | 1961-01-03 | 1963-01-03 | Democrat | 4 | |||||||||||||
29575 | 29575 | Walter Baring B000141 | rep | NV | 1961-01-03 | 1963-01-03 | Democrat | 0 | |||||||||||||
29589 | 29589 | Page Belcher B000323 | rep | OK | 1961-01-03 | 1963-01-03 | Republican | 1 | |||||||||||||
29600 | 29600 | Jackson Betts B000426 | rep | OH | 1961-01-03 | 1963-01-03 | Republican | 8 | |||||||||||||
29617 | 29617 | Thomas Boggs B000594 | rep | LA | 1961-01-03 | 1963-01-03 | Democrat | 2 | |||||||||||||
29628 | 29628 | Frank Bow B000676 | rep | OH | 1961-01-03 | 1963-01-03 | Republican | 16 | |||||||||||||
29644 | 29644 | James Byrne B001212 | rep | PA | 1961-01-03 | 1963-01-03 | Democrat | 3 | |||||||||||||
29658 | 29658 | John Byrnes B001216 | rep | WI | 1961-01-03 | 1963-01-03 | Republican | 8 | |||||||||||||
29690 | 29690 | Emanuel Celler C000264 | rep | NY | 1961-01-03 | 1963-01-03 | Democrat | 11 | |||||||||||||
29710 | 29710 | William Colmer C000645 | rep | MS | 1961-01-03 | 1963-01-03 | Democrat | 6 | |||||||||||||
29726 | 29726 | Robert Corbett C000772 | rep | PA | 1961-01-03 | 1963-01-03 | Republican | 29 | |||||||||||||
29743 | 29743 | John Dowdy D000467 | rep | TX | 1961-01-03 | 1963-01-03 | Democrat | 7 | |||||||||||||
29751 | 29751 | Florence Dwyer D000587 | rep | NJ | 1961-01-03 | 1963-01-03 | Republican | 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);