legislator_terms
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
482 rows where "end" is on date 1965-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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
28388 | 28388 | Harold Cooley C000736 | rep | NC | 1963-01-09 | 1965-01-03 | Democrat | 4 | |||||||||||||
28394 | 28394 | Willard Curtin C001005 | rep | PA | 1963-01-09 | 1965-01-03 | Republican | 8 | |||||||||||||
28404 | 28404 | Paul Dague D000004 | rep | PA | 1963-01-09 | 1965-01-03 | Republican | 9 | |||||||||||||
28412 | 28412 | Winfield Denton D000260 | rep | IN | 1963-01-09 | 1965-01-03 | Democrat | 8 | |||||||||||||
28416 | 28416 | Thomas Dodd D000390 | sen | CT | 1959-01-07 | 1965-01-03 | 1 | Democrat | |||||||||||||
28420 | 28420 | Robert Ellsworth E000148 | rep | KS | 1963-01-09 | 1965-01-03 | Republican | 3 | |||||||||||||
28433 | 28433 | Albert Gore G000320 | sen | TN | 1959-01-07 | 1965-01-03 | 1 | Democrat | |||||||||||||
28435 | 28435 | Bernard Grabowski G000348 | rep | CT | 1963-01-09 | 1965-01-03 | Democrat | 0 | |||||||||||||
28444 | 28444 | Harlan Hagen H000013 | rep | CA | 1963-01-09 | 1965-01-03 | Democrat | 18 | |||||||||||||
28458 | 28458 | Oren Harris H000249 | rep | AR | 1963-01-09 | 1965-01-03 | Democrat | 4 | |||||||||||||
28467 | 28467 | Ralph Harvey H000310 | rep | IN | 1963-01-09 | 1965-01-03 | Republican | 10 | |||||||||||||
28472 | 28472 | Spessard Holland H000720 | sen | FL | 1959-01-07 | 1965-01-03 | 1 | Democrat | |||||||||||||
28479 | 28479 | William Jennings J000098 | rep | VA | 1963-01-09 | 1965-01-03 | Democrat | 9 | |||||||||||||
28490 | 28490 | Paul Jones J000246 | rep | MO | 1963-01-09 | 1965-01-03 | Democrat | 10 | |||||||||||||
28506 | 28506 | Eugene Keogh K000130 | rep | NY | 1963-01-09 | 1965-01-03 | Democrat | 11 | |||||||||||||
28519 | 28519 | John Kunkel K000341 | rep | PA | 1963-01-09 | 1965-01-03 | Republican | 16 | |||||||||||||
28523 | 28523 | John Lindsay L000326 | rep | NY | 1963-01-09 | 1965-01-03 | Republican | 17 | |||||||||||||
28548 | 28548 | Joseph Martin M000191 | rep | MA | 1963-01-09 | 1965-01-03 | Republican | 10 | |||||||||||||
28555 | 28555 | Donald Matthews M000253 | rep | FL | 1963-01-09 | 1965-01-03 | Democrat | 8 | |||||||||||||
28562 | 28562 | Eugene McCarthy M000311 | sen | MN | 1959-01-07 | 1965-01-03 | 1 | Democrat | |||||||||||||
28567 | 28567 | Harris McDowell M000418 | rep | DE | 1963-01-09 | 1965-01-03 | Democrat | 0 | |||||||||||||
28584 | 28584 | James Morrison M000995 | rep | LA | 1963-01-09 | 1965-01-03 | Democrat | 6 | |||||||||||||
28597 | 28597 | Thomas Murray M001114 | rep | TN | 1963-01-09 | 1965-01-03 | Democrat | 7 | |||||||||||||
28605 | 28605 | Leo O’Brien O000015 | rep | NY | 1963-01-09 | 1965-01-03 | Democrat | 29 | |||||||||||||
28607 | 28607 | Alec Olson O000084 | rep | MN | 1963-01-09 | 1965-01-03 | Democrat | 6 | |||||||||||||
28613 | 28613 | Winston Prouty P000552 | sen | VT | 1959-01-07 | 1965-01-03 | 1 | Republican | |||||||||||||
28619 | 28619 | Ralph Rivers R000282 | rep | AK | 1963-01-09 | 1965-01-03 | Democrat | 0 | |||||||||||||
28627 | 28627 | Walter Rogers R000404 | rep | TX | 1963-01-09 | 1965-01-03 | Democrat | 18 | |||||||||||||
28633 | 28633 | James Roosevelt R000426 | rep | CA | 1963-01-09 | 1965-01-03 | Democrat | 26 | |||||||||||||
28641 | 28641 | Ralph Scott S000184 | rep | NC | 1963-01-09 | 1965-01-03 | Democrat | 5 | |||||||||||||
28651 | 28651 | Robert Secrest S000219 | rep | OH | 1963-01-09 | 1965-01-03 | Democrat | 15 | |||||||||||||
28653 | 28653 | George Senner S000243 | rep | AZ | 1963-01-09 | 1965-01-03 | Democrat | 3 | |||||||||||||
28655 | 28655 | Carlton Sickles S000401 | rep | MD | 1963-01-09 | 1965-01-03 | Democrat | 0 | |||||||||||||
28673 | 28673 | Howard Smith S000554 | rep | VA | 1963-01-09 | 1965-01-03 | Democrat | 8 | |||||||||||||
28690 | 28690 | Albert Thomas T000156 | rep | TX | 1963-01-09 | 1965-01-03 | Democrat | 8 | |||||||||||||
28702 | 28702 | Clark Thompson T000198 | rep | TX | 1963-01-09 | 1965-01-03 | Democrat | 9 | |||||||||||||
28709 | 28709 | Theo Thompson T000218 | rep | LA | 1963-01-09 | 1965-01-03 | Democrat | 7 | |||||||||||||
28714 | 28714 | Herman Toll T000297 | rep | PA | 1963-01-09 | 1965-01-03 | Democrat | 4 | |||||||||||||
28725 | 28725 | James Trimble T000373 | rep | AR | 1963-01-09 | 1965-01-03 | Democrat | 3 | |||||||||||||
28728 | 28728 | Stanley Tupper T000411 | rep | ME | 1963-01-09 | 1965-01-03 | Republican | 1 | |||||||||||||
28730 | 28730 | James Tuten T000436 | rep | GA | 1963-01-09 | 1965-01-03 | Democrat | 8 | |||||||||||||
28735 | 28735 | Charles Weltner W000290 | rep | GA | 1963-01-09 | 1965-01-03 | Democrat | 5 | |||||||||||||
28737 | 28737 | Compton White W000362 | rep | ID | 1963-01-09 | 1965-01-03 | Democrat | 1 | |||||||||||||
28741 | 28741 | John Williams W000518 | sen | DE | 1959-01-07 | 1965-01-03 | 1 | Republican | |||||||||||||
28744 | 28744 | Ralph Yarborough Y000006 | sen | TX | 1959-01-07 | 1965-01-03 | 1 | Democrat | |||||||||||||
28750 | 28750 | Stephen Young Y000053 | sen | OH | 1959-01-07 | 1965-01-03 | 1 | Democrat | |||||||||||||
28769 | 28769 | Robert Ashmore A000223 | rep | SC | 1963-01-09 | 1965-01-03 | Democrat | 4 | |||||||||||||
28799 | 28799 | Frances Bolton B000607 | rep | OH | 1963-01-09 | 1965-01-03 | Republican | 22 | |||||||||||||
28813 | 28813 | Thomas Curtis C001014 | rep | MO | 1963-01-09 | 1965-01-03 | Republican | 2 | |||||||||||||
28827 | 28827 | Paul Fino F000137 | rep | NY | 1963-01-09 | 1965-01-03 | Republican | 24 | |||||||||||||
28841 | 28841 | John Fogarty F000233 | rep | RI | 1963-01-09 | 1965-01-03 | Democrat | 2 | |||||||||||||
28857 | 28857 | Ezekiel Gathings G000098 | rep | AR | 1963-01-09 | 1965-01-03 | Democrat | 1 | |||||||||||||
28874 | 28874 | Charles Halleck H000081 | rep | IN | 1963-01-09 | 1965-01-03 | Republican | 2 | |||||||||||||
28885 | 28885 | Porter Hardy H000197 | rep | VA | 1963-01-09 | 1965-01-03 | Democrat | 2 | |||||||||||||
28893 | 28893 | William Harrison H000278 | rep | WY | 1963-01-09 | 1965-01-03 | Republican | 0 | |||||||||||||
28902 | 28902 | Albert Herlong H000530 | rep | FL | 1963-01-09 | 1965-01-03 | Democrat | 5 | |||||||||||||
28910 | 28910 | Elmer Holland H000717 | rep | PA | 1963-01-09 | 1965-01-03 | Democrat | 20 | |||||||||||||
28929 | 28929 | Frank Karsten K000013 | rep | MO | 1963-01-09 | 1965-01-03 | Democrat | 1 | |||||||||||||
28939 | 28939 | Edna Kelly K000070 | rep | NY | 1963-01-09 | 1965-01-03 | Democrat | 12 | |||||||||||||
28953 | 28953 | Cecil King K000196 | rep | CA | 1963-01-09 | 1965-01-03 | Democrat | 17 | |||||||||||||
28957 | 28957 | Horace Kornegay K000318 | rep | NC | 1963-01-09 | 1965-01-03 | Democrat | 6 | |||||||||||||
28969 | 28969 | Arch Moore M000892 | rep | WV | 1963-01-09 | 1965-01-03 | Republican | 1 | |||||||||||||
28974 | 28974 | Thomas Morris M000990 | rep | NM | 1963-01-09 | 1965-01-03 | Democrat | 0 | |||||||||||||
28985 | 28985 | Abraham Multer M001074 | rep | NY | 1963-01-09 | 1965-01-03 | Democrat | 13 | |||||||||||||
29004 | 29004 | Barratt O’Hara O000053 | rep | IL | 1963-01-09 | 1965-01-03 | Democrat | 2 | |||||||||||||
29009 | 29009 | Joe Pool P000426 | rep | TX | 1963-01-09 | 1965-01-03 | Democrat | 0 | |||||||||||||
29021 | 29021 | George Rhodes R000187 | rep | PA | 1963-01-09 | 1965-01-03 | Democrat | 6 | |||||||||||||
29036 | 29036 | Armistead Selden S000232 | rep | AL | 1963-01-09 | 1965-01-03 | Democrat | 0 | |||||||||||||
29056 | 29056 | William Tuck T000395 | rep | VA | 1963-01-09 | 1965-01-03 | Democrat | 5 | |||||||||||||
29064 | 29064 | Basil Whitener W000410 | rep | NC | 1963-01-09 | 1965-01-03 | Democrat | 10 | |||||||||||||
29075 | 29075 | John Williams W000517 | rep | MS | 1963-01-09 | 1965-01-03 | Democrat | 3 | |||||||||||||
29085 | 29085 | Edwin Willis W000559 | rep | LA | 1963-01-09 | 1965-01-03 | Democrat | 3 | |||||||||||||
29093 | 29093 | Jesse Younger Y000060 | rep | CA | 1963-01-09 | 1965-01-03 | Republican | 11 | |||||||||||||
29100 | 29100 | Charles Goodell G000282 | rep | NY | 1963-01-09 | 1965-01-03 | Republican | 38 | |||||||||||||
29109 | 29109 | Edwin Adair A000024 | rep | IN | 1963-01-09 | 1965-01-03 | Republican | 4 | |||||||||||||
29125 | 29125 | William Ayres A000229 | rep | OH | 1963-01-09 | 1965-01-03 | Republican | 14 | |||||||||||||
29136 | 29136 | William Bates B000239 | rep | MA | 1963-01-09 | 1965-01-03 | Republican | 6 | |||||||||||||
29141 | 29141 | James Battin B000241 | rep | MT | 1963-01-09 | 1965-01-03 | Republican | 2 | |||||||||||||
29155 | 29155 | Ellis Berry B000416 | rep | SD | 1963-01-09 | 1965-01-03 | Republican | 2 | |||||||||||||
29163 | 29163 | Laurence Burton B001155 | rep | UT | 1963-01-09 | 1965-01-03 | Republican | 1 | |||||||||||||
29171 | 29171 | William Cahill C000019 | rep | NJ | 1963-01-09 | 1965-01-03 | Republican | 1 | |||||||||||||
29177 | 29177 | Jeffery Cohelan C000596 | rep | CA | 1963-01-09 | 1965-01-03 | Democrat | 7 | |||||||||||||
29187 | 29187 | William Cramer C000869 | rep | FL | 1963-01-09 | 1965-01-03 | Republican | 12 | |||||||||||||
29194 | 29194 | Glenn Cunningham C000991 | rep | NE | 1963-01-09 | 1965-01-03 | Republican | 2 | |||||||||||||
29200 | 29200 | Emilio Daddario D000001 | rep | CT | 1963-01-09 | 1965-01-03 | Democrat | 1 | |||||||||||||
29214 | 29214 | William Dawson D000158 | rep | IL | 1963-01-09 | 1965-01-03 | Democrat | 1 | |||||||||||||
29231 | 29231 | Robert Everett E000266 | rep | TN | 1963-01-09 | 1965-01-03 | Democrat | 8 | |||||||||||||
29244 | 29244 | George Fallon F000012 | rep | MD | 1963-01-09 | 1965-01-03 | Democrat | 4 | |||||||||||||
29251 | 29251 | Leonard Farbstein F000015 | rep | NY | 1963-01-09 | 1965-01-03 | Democrat | 19 | |||||||||||||
29265 | 29265 | Michael Feighan F000060 | rep | OH | 1963-01-09 | 1965-01-03 | Democrat | 20 | |||||||||||||
29269 | 29269 | Edgar Foreman F000272 | rep | TX | 1963-01-09 | 1965-01-03 | Republican | 16 | |||||||||||||
29276 | 29276 | Samuel Friedel F000384 | rep | MD | 1963-01-09 | 1965-01-03 | Democrat | 7 | |||||||||||||
29288 | 29288 | Jacob Gilbert G000175 | rep | NY | 1963-01-09 | 1965-01-03 | Democrat | 22 | |||||||||||||
29292 | 29292 | Edward Gurney G000531 | rep | FL | 1963-01-09 | 1965-01-03 | Republican | 11 | |||||||||||||
29298 | 29298 | Charles Joelson J000108 | rep | NJ | 1963-01-09 | 1965-01-03 | Democrat | 8 | |||||||||||||
29315 | 29315 | Michael Kirwan K000244 | rep | OH | 1963-01-09 | 1965-01-03 | Democrat | 19 | |||||||||||||
29326 | 29326 | Melvin Laird L000024 | rep | WI | 1963-01-09 | 1965-01-03 | Republican | 7 | |||||||||||||
29332 | 29332 | Odin Langen L000069 | rep | MN | 1963-01-09 | 1965-01-03 | Republican | 7 | |||||||||||||
29341 | 29341 | Glenard Lipscomb L000344 | rep | CA | 1963-01-09 | 1965-01-03 | Republican | 24 | |||||||||||||
29347 | 29347 | Clark MacGregor M000010 | rep | MN | 1963-01-09 | 1965-01-03 | Republican | 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);