legislator_terms
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
481 rows where "start" is on date 1963-01-09 sorted by party
This data as json, copyable, CSV (advanced)
Suggested facets: class
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
27658 | 27658 | Daniel Brewster B000813 | sen | MD | 1963-01-09 | 1969-01-03 | 3 | Democrat | |||||||||||||
27677 | 27677 | Charles Buckley B001024 | rep | NY | 1963-01-09 | 1965-01-03 | Democrat | 23 | |||||||||||||
27678 | 27678 | Everett Burkhalter B001104 | rep | CA | 1963-01-09 | 1965-01-03 | Democrat | 27 | |||||||||||||
27699 | 27699 | Clarence Cannon C000117 | rep | MO | 1963-01-09 | 1965-01-03 | Democrat | 9 | |||||||||||||
27722 | 27722 | Joseph Clark C000444 | sen | PA | 1963-01-09 | 1969-01-03 | 3 | Democrat | |||||||||||||
27735 | 27735 | Clifford Davis D000094 | rep | TN | 1963-01-09 | 1965-01-03 | Democrat | 9 | |||||||||||||
27761 | 27761 | Clyde Doyle D000481 | rep | CA | 1963-01-09 | 1965-01-03 | Democrat | 23 | |||||||||||||
27762 | 27762 | James Edmondson E000055 | sen | OK | 1963-01-09 | 1965-01-03 | 2 | Democrat | appointment | ||||||||||||
27770 | 27770 | Carl Elliott E000120 | rep | AL | 1963-01-09 | 1965-01-03 | Democrat | 0 | |||||||||||||
27782 | 27782 | Edward Finnegan F000135 | rep | IL | 1963-01-09 | 1965-01-03 | Democrat | 9 | |||||||||||||
27789 | 27789 | Elijah Forrester F000283 | rep | GA | 1963-01-09 | 1965-01-03 | Democrat | 3 | |||||||||||||
27799 | 27799 | Julian Gary G000091 | rep | VA | 1963-01-09 | 1965-01-03 | Democrat | 3 | |||||||||||||
27811 | 27811 | Thomas Gill G000192 | rep | HI | 1963-01-09 | 1965-01-03 | Democrat | 1 | |||||||||||||
27829 | 27829 | George Grant G000381 | rep | AL | 1963-01-09 | 1965-01-03 | Democrat | 0 | |||||||||||||
27838 | 27838 | William Green G000421 | rep | PA | 1963-01-09 | 1965-01-03 | Democrat | 5 | |||||||||||||
27840 | 27840 | Ernest Gruening G000508 | sen | AK | 1963-01-09 | 1969-01-03 | 3 | Democrat | |||||||||||||
27842 | 27842 | Ralph Harding H000191 | rep | ID | 1963-01-09 | 1965-01-03 | Democrat | 2 | |||||||||||||
27857 | 27857 | Carl Hayden H000385 | sen | AZ | 1963-01-09 | 1969-01-03 | 3 | Democrat | |||||||||||||
27862 | 27862 | James Healey H000424 | rep | NY | 1963-01-09 | 1965-01-03 | Democrat | 21 | |||||||||||||
27866 | 27866 | Robert Hemphill H000471 | rep | SC | 1963-01-09 | 1965-01-03 | Democrat | 5 | |||||||||||||
27884 | 27884 | Joseph Hill H000598 | sen | AL | 1963-01-09 | 1969-01-02 | 3 | Democrat | |||||||||||||
27914 | 27914 | George Huddleston H000904 | rep | AL | 1963-01-09 | 1965-01-03 | Democrat | 0 | |||||||||||||
27938 | 27938 | Lester Johnson J000158 | rep | WI | 1963-01-09 | 1965-01-03 | Democrat | 9 | |||||||||||||
27942 | 27942 | Olin Johnston J000195 | sen | SC | 1963-01-09 | 1965-12-31 | 3 | Democrat | |||||||||||||
27949 | 27949 | Maude Kee K000040 | rep | WV | 1963-01-09 | 1965-01-03 | Democrat | 5 | |||||||||||||
27967 | 27967 | Joe Kilgore K000177 | rep | TX | 1963-01-09 | 1965-01-03 | Democrat | 15 | |||||||||||||
27981 | 27981 | Richard Lankford L000081 | rep | MD | 1963-01-09 | 1965-01-03 | Democrat | 5 | |||||||||||||
27983 | 27983 | Frank Lausche L000122 | sen | OH | 1963-01-09 | 1969-01-03 | 3 | Democrat | |||||||||||||
27990 | 27990 | John Lesinski L000252 | rep | MI | 1963-01-09 | 1965-01-03 | Democrat | 16 | |||||||||||||
27994 | 27994 | Roland Libonati L000299 | rep | IL | 1963-01-09 | 1965-01-03 | Democrat | 7 | |||||||||||||
27996 | 27996 | Edward Long L000415 | sen | MO | 1963-01-09 | 1968-12-27 | 3 | Democrat | |||||||||||||
28031 | 28031 | Almer Monroney M000859 | sen | OK | 1963-01-09 | 1969-01-03 | 3 | Democrat | |||||||||||||
28035 | 28035 | Wayne Morse M001014 | sen | OR | 1963-01-09 | 1969-01-03 | 3 | Democrat | |||||||||||||
28066 | 28066 | Thomas O’Brien O000016 | rep | IL | 1963-01-09 | 1965-01-03 | Democrat | 6 | |||||||||||||
28088 | 28088 | John Pilcher P000349 | rep | GA | 1963-01-09 | 1965-01-03 | Democrat | 2 | |||||||||||||
28104 | 28104 | Albert Rains R000018 | rep | AL | 1963-01-09 | 1965-01-03 | Democrat | 0 | |||||||||||||
28121 | 28121 | Kenneth Roberts R000314 | rep | AL | 1963-01-09 | 1965-01-03 | Democrat | 0 | |||||||||||||
28123 | 28123 | Harold Ryan R000556 | rep | MI | 1963-01-09 | 1965-01-03 | Democrat | 14 | |||||||||||||
28138 | 28138 | John Shelley S000327 | rep | CA | 1963-01-09 | 1965-01-03 | Democrat | 5 | |||||||||||||
28152 | 28152 | Harry Sheppard S000335 | rep | CA | 1963-01-09 | 1965-01-03 | Democrat | 33 | |||||||||||||
28167 | 28167 | George Smathers S000505 | sen | FL | 1963-01-09 | 1969-01-03 | 3 | Democrat | |||||||||||||
28177 | 28177 | Neil Staebler S000775 | rep | MI | 1963-01-09 | 1965-01-03 | Democrat | 0 | |||||||||||||
28186 | 28186 | William Thornberry T000237 | rep | TX | 1963-01-09 | 1965-01-03 | Democrat | 10 | |||||||||||||
28228 | 28228 | Carl Vinson V000105 | rep | GA | 1963-01-09 | 1965-01-03 | Democrat | 6 | |||||||||||||
28247 | 28247 | Francis Walter W000108 | rep | PA | 1963-01-09 | 1965-01-03 | Democrat | 15 | |||||||||||||
28271 | 28271 | Victor Wickersham W000439 | rep | OK | 1963-01-09 | 1965-01-03 | Democrat | 6 | |||||||||||||
28293 | 28293 | William Winstead W000641 | rep | MS | 1963-01-09 | 1965-01-03 | Democrat | 4 | |||||||||||||
28306 | 28306 | Ross Bass B000223 | rep | TN | 1963-01-09 | 1964-11-03 | Democrat | 6 | |||||||||||||
28327 | 28327 | Lindley Beckworth B000296 | rep | TX | 1963-01-09 | 1965-01-03 | Democrat | 3 | |||||||||||||
28341 | 28341 | Herbert Bonner B000621 | rep | NC | 1963-01-09 | 1965-01-03 | Democrat | 1 | |||||||||||||
28359 | 28359 | Ronald Cameron C000067 | rep | CA | 1963-01-09 | 1965-01-03 | Democrat | 25 | |||||||||||||
28370 | 28370 | Frank Chelf C000342 | rep | KY | 1963-01-09 | 1965-01-03 | Democrat | 4 | |||||||||||||
28388 | 28388 | Harold Cooley C000736 | rep | NC | 1963-01-09 | 1965-01-03 | Democrat | 4 | |||||||||||||
28412 | 28412 | Winfield Denton D000260 | rep | IN | 1963-01-09 | 1965-01-03 | Democrat | 8 | |||||||||||||
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 | |||||||||||||
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 | |||||||||||||
28555 | 28555 | Donald Matthews M000253 | rep | FL | 1963-01-09 | 1965-01-03 | Democrat | 8 | |||||||||||||
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 | |||||||||||||
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 | |||||||||||||
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 | |||||||||||||
28769 | 28769 | Robert Ashmore A000223 | rep | SC | 1963-01-09 | 1965-01-03 | Democrat | 4 | |||||||||||||
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 | |||||||||||||
28885 | 28885 | Porter Hardy H000197 | rep | VA | 1963-01-09 | 1965-01-03 | Democrat | 2 | |||||||||||||
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 | |||||||||||||
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 |
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);