legislator_terms
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
33 rows where "start" is on date 1949-01-03 and type = "sen"
This data as json, copyable, CSV (advanced)
Suggested facets: class, 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 |
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);