legislator_terms
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
480 rows where "start" is on date 1949-01-03 sorted by district
This data as json, copyable, CSV (advanced)
Suggested facets: type, 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
24729 | 24729 | Joseph Broughton B000894 | sen | NC | 1949-01-03 | 1949-03-06 | 2 | Democrat | |||||||||||||
24802 | 24802 | Virgil Chapman C000317 | sen | KY | 1949-01-03 | 1951-03-08 | 2 | Democrat | |||||||||||||
24813 | 24813 | Guy Cordon C000774 | sen | OR | 1949-01-03 | 1955-01-03 | 2 | Republican | |||||||||||||
24831 | 24831 | Homer Ferguson F000081 | sen | MI | 1949-01-03 | 1955-01-03 | 2 | Republican | |||||||||||||
24835 | 24835 | Guy Gillette G000205 | sen | IA | 1949-01-03 | 1955-01-03 | 2 | Democrat | |||||||||||||
24845 | 24845 | Robert Hendrickson H000495 | sen | NJ | 1949-01-03 | 1955-01-03 | 2 | Republican | |||||||||||||
24857 | 24857 | Lester Hunt H000975 | sen | WY | 1949-01-03 | 1954-06-19 | 2 | Democrat | |||||||||||||
24867 | 24867 | Edwin Johnson J000127 | sen | CO | 1949-01-03 | 1955-01-03 | 2 | Democrat | |||||||||||||
24921 | 24921 | Burnet Maybank M000279 | sen | SC | 1949-01-03 | 1955-01-03 | 2 | Democrat | |||||||||||||
24949 | 24949 | Bert Miller M000716 | sen | ID | 1949-01-03 | 1949-12-31 | 2 | Democrat | |||||||||||||
25075 | 25075 | Kenneth Wherry W000344 | sen | NE | 1949-01-03 | 1951-12-31 | 2 | Republican | |||||||||||||
25368 | 25368 | Herbert Lehman L000224 | sen | NY | 1949-01-03 | 1951-01-03 | 3 | Democrat | |||||||||||||
25882 | 25882 | Henry Bridges B000823 | sen | NH | 1949-01-03 | 1955-01-03 | 2 | Republican | |||||||||||||
25964 | 25964 | Joseph Frear F000356 | sen | DE | 1949-01-03 | 1955-01-03 | 2 | Democrat | |||||||||||||
25985 | 25985 | Theodore Green G000418 | sen | RI | 1949-01-03 | 1955-01-03 | 2 | Democrat | |||||||||||||
26061 | 26061 | James Murray M001108 | sen | MT | 1949-01-03 | 1955-01-03 | 2 | Democrat | |||||||||||||
26071 | 26071 | Matthew Neely N000023 | sen | WV | 1949-01-03 | 1955-01-03 | 2 | Democrat | |||||||||||||
27181 | 27181 | Paul Douglas D000456 | sen | IL | 1949-01-03 | 1955-01-03 | 2 | Democrat | |||||||||||||
27281 | 27281 | Carey Kefauver K000044 | sen | TN | 1949-01-03 | 1955-01-03 | 2 | Democrat | |||||||||||||
27284 | 27284 | Robert Kerr K000144 | sen | OK | 1949-01-03 | 1955-01-03 | 2 | Democrat | |||||||||||||
27495 | 27495 | Absalom Robertson R000317 | sen | VA | 1949-01-03 | 1955-01-03 | 2 | Democrat | |||||||||||||
27503 | 27503 | Leverett Saltonstall S000021 | sen | MA | 1949-01-03 | 1955-01-03 | 2 | Republican | |||||||||||||
27517 | 27517 | Andrew Schoeppel S000138 | sen | KS | 1949-01-03 | 1955-01-03 | 2 | Republican | |||||||||||||
28300 | 28300 | Lyndon Johnson J000160 | sen | TX | 1949-01-03 | 1955-01-03 | 2 | Democrat | |||||||||||||
28760 | 28760 | Clinton Anderson A000186 | sen | NM | 1949-01-03 | 1955-01-03 | 2 | Democrat | |||||||||||||
28818 | 28818 | Allen Ellender E000112 | sen | LA | 1949-01-03 | 1955-01-03 | 2 | Democrat | |||||||||||||
28994 | 28994 | Karl Mundt M001078 | sen | SD | 1949-01-03 | 1955-01-03 | 2 | Republican | |||||||||||||
29027 | 29027 | Richard Russell R000536 | sen | GA | 1949-01-03 | 1955-01-03 | 2 | Democrat | |||||||||||||
29045 | 29045 | Margaret Smith S000590 | sen | ME | 1949-01-03 | 1955-01-03 | 2 | Republican | |||||||||||||
30339 | 30339 | James Eastland E000018 | sen | MS | 1949-01-03 | 1955-01-03 | 2 | Democrat | |||||||||||||
30566 | 30566 | John McClellan M000332 | sen | AR | 1949-01-03 | 1955-01-03 | 2 | Democrat | |||||||||||||
30700 | 30700 | John Sparkman S000701 | sen | AL | 1949-01-03 | 1955-01-03 | 2 | Democrat | |||||||||||||
31592 | 31592 | Hubert Humphrey H000953 | sen | MN | 1949-01-03 | 1955-01-03 | 2 | Democrat | |||||||||||||
24888 | 24888 | William Lemke L000238 | rep | ND | 1949-01-03 | 1951-01-03 | Republican | 0 | |||||||||||||
24948 | 24948 | John Miles M000705 | rep | NM | 1949-01-03 | 1951-01-03 | Democrat | 0 | |||||||||||||
25000 | 25000 | Charles Plumley P000395 | rep | VT | 1949-01-03 | 1951-01-03 | Republican | 0 | |||||||||||||
25588 | 25588 | Frank Barrett B000176 | rep | WY | 1949-01-03 | 1951-01-03 | Republican | 0 | |||||||||||||
25667 | 25667 | Joseph Farrington F000034 | rep | HI | 1949-01-03 | 1951-01-03 | Republican | 0 | |||||||||||||
25956 | 25956 | Antonio Fernández F000085 | rep | NM | 1949-01-03 | 1951-01-03 | Democrat | 0 | |||||||||||||
26194 | 26194 | Usher Burdick B001079 | rep | ND | 1949-01-03 | 1951-01-03 | Republican | 0 | |||||||||||||
26574 | 26574 | Antoni Sadlak S000009 | rep | CT | 1949-01-03 | 1951-01-03 | Republican | 0 | |||||||||||||
27773 | 27773 | Antonio Fernós-Isern F000087 | rep | PR | 1949-01-03 | 1951-01-03 | Popular Democrat | 0 | |||||||||||||
28749 | 28749 | Stephen Young Y000053 | rep | OH | 1949-01-03 | 1951-01-03 | Democrat | 0 | |||||||||||||
28774 | 28774 | Edward Bartlett B000201 | rep | AK | 1949-01-03 | 1951-01-03 | Democrat | 0 | |||||||||||||
28783 | 28783 | James Boggs B000593 | rep | DE | 1949-01-03 | 1951-01-03 | Republican | 0 | |||||||||||||
29571 | 29571 | Walter Baring B000141 | rep | NV | 1949-01-03 | 1951-01-03 | Democrat | 0 | |||||||||||||
24758 | 24758 | Schuyler Bland B000545 | rep | VA | 1949-01-03 | 1951-01-03 | Democrat | 1 | |||||||||||||
24836 | 24836 | William Gilmer G000219 | rep | OK | 1949-01-03 | 1951-01-03 | Democrat | 1 | |||||||||||||
24910 | 24910 | William Macy M000037 | rep | NY | 1949-01-03 | 1951-01-03 | Republican | 1 | |||||||||||||
24980 | 24980 | James Peterson P000261 | rep | FL | 1949-01-03 | 1951-01-03 | Democrat | 1 | |||||||||||||
24991 | 24991 | Dayton Phillips P000306 | rep | TN | 1949-01-03 | 1951-01-03 | Republican | 1 | |||||||||||||
25017 | 25017 | George Sadowski S000011 | rep | MI | 1949-01-03 | 1951-01-03 | Democrat | 1 | |||||||||||||
25084 | 25084 | Compton White W000361 | rep | ID | 1949-01-03 | 1951-01-03 | Democrat | 1 | |||||||||||||
25183 | 25183 | Albert Cole C000606 | rep | KS | 1949-01-03 | 1951-01-03 | Republican | 1 | |||||||||||||
25254 | 25254 | Charles Elston E000160 | rep | OH | 1949-01-03 | 1951-01-03 | Republican | 1 | |||||||||||||
25289 | 25289 | Walter Granger G000379 | rep | UT | 1949-01-03 | 1951-01-03 | Democrat | 1 | |||||||||||||
25372 | 25372 | Clare Magee M000045 | rep | MO | 1949-01-03 | 1951-01-03 | Democrat | 1 | |||||||||||||
25391 | 25391 | Hugh Mitchell M000814 | rep | WA | 1949-01-03 | 1951-01-03 | Democrat | 1 | |||||||||||||
25400 | 25400 | John Murdock M001081 | rep | AZ | 1949-01-03 | 1951-01-03 | Democrat | 1 | |||||||||||||
25431 | 25431 | Robert Ramsay R000025 | rep | WV | 1949-01-03 | 1951-01-03 | Democrat | 1 | |||||||||||||
25447 | 25447 | John Rankin R000056 | rep | MS | 1949-01-03 | 1951-01-03 | Democrat | 1 | |||||||||||||
26044 | 26044 | Harold Lovre L000468 | rep | SD | 1949-01-03 | 1951-01-03 | Republican | 1 | |||||||||||||
26053 | 26053 | Thomas Martin M000199 | rep | IA | 1949-01-03 | 1951-01-03 | Republican | 1 | |||||||||||||
26173 | 26173 | August Andresen A000239 | rep | MN | 1949-01-03 | 1951-01-03 | Republican | 1 | |||||||||||||
26212 | 26212 | John Carroll C000189 | rep | CO | 1949-01-03 | 1951-01-03 | Democrat | 1 | |||||||||||||
26340 | 26340 | Noble Gregory G000447 | rep | KY | 1949-01-03 | 1951-01-03 | Democrat | 1 | |||||||||||||
26355 | 26355 | Robert Hale H000036 | rep | ME | 1949-01-03 | 1951-01-03 | Republican | 1 | |||||||||||||
26385 | 26385 | John Heselton H000549 | rep | MA | 1949-01-03 | 1951-01-03 | Republican | 1 | |||||||||||||
26528 | 26528 | Edward Miller M000724 | rep | MD | 1949-01-03 | 1951-01-03 | Republican | 1 | |||||||||||||
26565 | 26565 | Edward Robeson R000329 | rep | VA | 1949-01-03 | 1951-01-03 | Democrat | 1 | |||||||||||||
26587 | 26587 | Hubert Scudder S000198 | rep | CA | 1949-01-03 | 1951-01-03 | Republican | 1 | |||||||||||||
26615 | 26615 | Lawrence Smith S000585 | rep | WI | 1949-01-03 | 1951-01-03 | Republican | 1 | |||||||||||||
26686 | 26686 | Charles Wolverton W000683 | rep | NJ | 1949-01-03 | 1951-01-03 | Republican | 1 | |||||||||||||
26854 | 26854 | Aime Forand F000255 | rep | RI | 1949-01-03 | 1951-01-03 | Democrat | 1 | |||||||||||||
26941 | 26941 | Prince Preston P000516 | rep | GA | 1949-01-03 | 1951-01-03 | Democrat | 1 | |||||||||||||
27117 | 27117 | Frank Boykin B000725 | rep | AL | 1949-01-03 | 1951-01-03 | Democrat | 1 | |||||||||||||
27373 | 27373 | Chester Merrow M000664 | rep | NH | 1949-01-03 | 1951-01-03 | Republican | 1 | |||||||||||||
28043 | 28043 | Albin Norblad N000133 | rep | OR | 1949-01-03 | 1951-01-03 | Republican | 1 | |||||||||||||
28334 | 28334 | Herbert Bonner B000621 | rep | NC | 1949-01-03 | 1951-01-03 | Democrat | 1 | |||||||||||||
28850 | 28850 | Ezekiel Gathings G000098 | rep | AR | 1949-01-03 | 1951-01-03 | Democrat | 1 | |||||||||||||
29207 | 29207 | William Dawson D000158 | rep | IL | 1949-01-03 | 1951-01-03 | Democrat | 1 | |||||||||||||
29447 | 29447 | Lucius Rivers R000280 | rep | SC | 1949-01-03 | 1951-01-03 | Democrat | 1 | |||||||||||||
29905 | 29905 | Michael Mansfield M000113 | rep | MT | 1949-01-03 | 1951-01-03 | Democrat | 1 | |||||||||||||
30269 | 30269 | Carl Curtis C001006 | rep | NE | 1949-01-03 | 1951-01-03 | Republican | 1 | |||||||||||||
30821 | 30821 | William Barrett B000178 | rep | PA | 1949-01-03 | 1951-01-03 | Democrat | 1 | |||||||||||||
31039 | 31039 | Felix Hébert H000437 | rep | LA | 1949-01-03 | 1951-01-03 | Democrat | 1 | |||||||||||||
31146 | 31146 | Ray Madden M000039 | rep | IN | 1949-01-03 | 1951-01-03 | Democrat | 1 | |||||||||||||
31262 | 31262 | John Patman P000103 | rep | TX | 1949-01-03 | 1951-01-03 | Democrat | 1 | |||||||||||||
31296 | 31296 | Abraham Ribicoff R000191 | rep | CT | 1949-01-03 | 1951-01-03 | Democrat | 1 | |||||||||||||
24773 | 24773 | William Bolton B000609 | rep | MD | 1949-01-03 | 1951-01-03 | Democrat | 2 | |||||||||||||
24864 | 24864 | John Jennings J000096 | rep | TN | 1949-01-03 | 1951-01-03 | Republican | 2 | |||||||||||||
24947 | 24947 | Earl Michener M000693 | rep | MI | 1949-01-03 | 1951-01-03 | Republican | 2 | |||||||||||||
24964 | 24964 | Eugene O’Sullivan O000122 | rep | NE | 1949-01-03 | 1951-01-03 | Democrat | 2 | |||||||||||||
25019 | 25019 | John Sanborn S000029 | rep | ID | 1949-01-03 | 1951-01-03 | Republican | 2 | |||||||||||||
25020 | 25020 | Hugo Sims S000439 | rep | SC | 1949-01-03 | 1951-01-03 | Democrat | 2 | |||||||||||||
25059 | 25059 | Earl Wagner W000019 | rep | OH | 1949-01-03 | 1951-01-03 | Democrat | 2 | |||||||||||||
25100 | 25100 | Chase Woodhouse W000714 | rep | CT | 1949-01-03 | 1951-01-03 | Democrat | 2 | |||||||||||||
25146 | 25146 | Reva Bosone B000649 | rep | UT | 1949-01-03 | 1951-01-03 | Democrat | 2 | |||||||||||||
25187 | 25187 | Jesse Combs C000655 | rep | TX | 1949-01-03 | 1951-01-03 | Democrat | 2 | |||||||||||||
25201 | 25201 | Edward Cox C000831 | rep | GA | 1949-01-03 | 1951-01-03 | Democrat | 2 |
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);