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 1975-01-14 and type = "sen"
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
30819 | 30819 | James Allen A000127 | sen | AL | 1975-01-14 | 1978-06-01 | 3 | Democrat | |||||||||||||
30837 | 30837 | Birch Bayh B000254 | sen | IN | 1975-01-14 | 1981-01-03 | 3 | Democrat | |||||||||||||
30847 | 30847 | Henry Bellmon B000351 | sen | OK | 1975-01-14 | 1981-01-03 | 3 | Republican | |||||||||||||
30867 | 30867 | Frank Church C000388 | sen | ID | 1975-01-14 | 1981-01-03 | 3 | Democrat | |||||||||||||
30891 | 30891 | John Culver C000979 | sen | IA | 1975-01-14 | 1981-01-03 | 3 | Democrat | |||||||||||||
30944 | 30944 | Maurice Gravel G000388 | sen | AK | 1975-01-14 | 1981-01-03 | 3 | Democrat | |||||||||||||
31073 | 31073 | Jacob Javits J000064 | sen | NY | 1975-01-14 | 1981-01-03 | 3 | Republican | |||||||||||||
31170 | 31170 | Warren Magnuson M000053 | sen | WA | 1975-01-14 | 1981-01-03 | 3 | Democrat | |||||||||||||
31178 | 31178 | George McGovern M000452 | sen | SD | 1975-01-14 | 1981-01-03 | 3 | Democrat | |||||||||||||
31200 | 31200 | Robert Morgan M000956 | sen | NC | 1975-01-14 | 1981-01-03 | 3 | Democrat | |||||||||||||
31227 | 31227 | Gaylord Nelson N000033 | sen | WI | 1975-01-14 | 1981-01-03 | 3 | Democrat | |||||||||||||
31300 | 31300 | Abraham Ribicoff R000191 | sen | CT | 1975-01-14 | 1981-01-03 | 3 | Democrat | |||||||||||||
31323 | 31323 | Richard Schweiker S000159 | sen | PA | 1975-01-14 | 1981-01-03 | 3 | Republican | |||||||||||||
31351 | 31351 | Adlai Stevenson S000890 | sen | IL | 1975-01-14 | 1981-01-03 | 3 | Democrat | |||||||||||||
31352 | 31352 | Richard Stone S000962 | sen | FL | 1975-01-14 | 1981-01-03 | 3 | Democrat | |||||||||||||
31384 | 31384 | Herman Talmadge T000035 | sen | GA | 1975-01-14 | 1981-01-03 | 3 | Democrat | |||||||||||||
31407 | 31407 | Milton Young Y000047 | sen | ND | 1975-01-14 | 1981-01-03 | 3 | Republican | |||||||||||||
32613 | 32613 | Thomas Eagleton E000004 | sen | MO | 1975-01-14 | 1981-01-03 | 3 | Democrat | |||||||||||||
32681 | 32681 | Barry Goldwater G000267 | sen | AZ | 1975-01-14 | 1981-01-03 | 3 | Republican | |||||||||||||
32701 | 32701 | Gary Hart H000287 | sen | CO | 1975-01-14 | 1981-01-03 | 3 | Democrat | |||||||||||||
32725 | 32725 | Paul Laxalt L000148 | sen | NV | 1975-01-14 | 1981-01-03 | 3 | Republican | |||||||||||||
32738 | 32738 | Russell Long L000428 | sen | LA | 1975-01-14 | 1981-01-03 | 3 | Democrat | |||||||||||||
32748 | 32748 | Charles Mathias M000241 | sen | MD | 1975-01-14 | 1981-01-03 | 3 | Republican | |||||||||||||
33540 | 33540 | Alan Cranston C000877 | sen | CA | 1975-01-14 | 1981-01-03 | 3 | Democrat | |||||||||||||
33585 | 33585 | Edwin Garn G000072 | sen | UT | 1975-01-14 | 1981-01-03 | 3 | Republican | |||||||||||||
35156 | 35156 | Dale Bumpers B001057 | sen | AR | 1975-01-14 | 1981-01-03 | 3 | Democrat | |||||||||||||
35195 | 35195 | Robert Dole D000401 | sen | KS | 1975-01-14 | 1981-01-03 | 3 | Republican | |||||||||||||
35261 | 35261 | Wendell Ford F000268 | sen | KY | 1975-01-14 | 1981-01-03 | 3 | Democrat | |||||||||||||
35286 | 35286 | John Glenn G000236 | sen | OH | 1975-01-14 | 1981-01-03 | 3 | Democrat | |||||||||||||
35489 | 35489 | Robert Packwood P000009 | sen | OR | 1975-01-14 | 1981-01-03 | 3 | Republican | |||||||||||||
36651 | 36651 | Ernest Hollings H000725 | sen | SC | 1975-01-14 | 1981-01-03 | 3 | Democrat | |||||||||||||
39023 | 39023 | Daniel Inouye I000025 | sen | HI | 1975-01-14 | 1981-01-03 | 3 | Democrat | |||||||||||||
42717 | 42717 | Patrick Leahy L000174 | sen | VT | 1975-01-14 | 1981-01-03 | 3 | 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);