legislator_terms
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
478 rows where "start" is on date 1977-01-04 sorted by rowid descending
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
35236 | 35236 | Hamilton Fish F000141 | rep | NY | 1977-01-04 | 1979-01-03 | Republican | 25 | |||||||||||||
35216 | 35216 | Glenn English E000184 | rep | OK | 1977-01-04 | 1979-01-03 | Democrat | 6 | |||||||||||||
35206 | 35206 | William Edwards E000064 | rep | CA | 1977-01-04 | 1979-01-03 | Democrat | 10 | |||||||||||||
35181 | 35181 | Butler Derrick D000267 | rep | SC | 1977-01-04 | 1979-01-03 | Democrat | 3 | |||||||||||||
35162 | 35162 | Milton Carr C000178 | rep | MI | 1977-01-04 | 1979-01-03 | Democrat | 6 | |||||||||||||
35147 | 35147 | Jack Brooks B000880 | rep | TX | 1977-01-04 | 1979-01-03 | Democrat | 9 | |||||||||||||
35111 | 35111 | Leslie Aspin A000224 | rep | WI | 1977-01-04 | 1979-01-03 | Democrat | 1 | |||||||||||||
35099 | 35099 | Douglas Applegate A000214 | rep | OH | 1977-01-04 | 1979-01-03 | Democrat | 18 | |||||||||||||
35082 | 35082 | Gus Yatron Y000014 | rep | PA | 1977-01-04 | 1979-01-03 | Democrat | 6 | |||||||||||||
35070 | 35070 | Chalmers Wylie W000781 | rep | OH | 1977-01-04 | 1979-01-03 | Republican | 15 | |||||||||||||
35049 | 35049 | Theodore Weiss W000258 | rep | NY | 1977-01-04 | 1979-01-03 | Democrat | 20 | |||||||||||||
35035 | 35035 | Guy Vander Jagt V000027 | rep | MI | 1977-01-04 | 1979-01-03 | Republican | 9 | |||||||||||||
35021 | 35021 | Morris Udall U000001 | rep | AZ | 1977-01-04 | 1979-01-03 | Democrat | 2 | |||||||||||||
35005 | 35005 | Jerome Traxler T000356 | rep | MI | 1977-01-04 | 1979-01-03 | Democrat | 8 | |||||||||||||
34976 | 34976 | Stephen Solarz S000673 | rep | NY | 1977-01-04 | 1979-01-03 | Democrat | 13 | |||||||||||||
34957 | 34957 | Paul Simon S000423 | rep | IL | 1977-01-04 | 1979-01-03 | Democrat | 24 | |||||||||||||
34942 | 34942 | Richard Schulze S000146 | rep | PA | 1977-01-04 | 1979-01-03 | Republican | 5 | |||||||||||||
34933 | 34933 | James Scheuer S000124 | rep | NY | 1977-01-04 | 1979-01-03 | Democrat | 11 | |||||||||||||
34914 | 34914 | Martin Russo R000543 | rep | IL | 1977-01-04 | 1979-01-03 | Democrat | 3 | |||||||||||||
34905 | 34905 | Edward Roybal R000485 | rep | CA | 1977-01-04 | 1979-01-03 | Democrat | 25 | |||||||||||||
34890 | 34890 | Robert Roe R000383 | rep | NJ | 1977-01-04 | 1979-01-03 | Democrat | 8 | |||||||||||||
34871 | 34871 | Matthew Rinaldo R000262 | rep | NJ | 1977-01-04 | 1979-01-03 | Republican | 12 | |||||||||||||
34853 | 34853 | Carl Pursell P000574 | rep | MI | 1977-01-04 | 1979-01-03 | Republican | 2 | |||||||||||||
34842 | 34842 | Larry Pressler P000513 | rep | SD | 1977-01-04 | 1979-01-03 | Republican | 1 | |||||||||||||
34822 | 34822 | Donald Pease P000170 | rep | OH | 1977-01-04 | 1979-01-03 | Democrat | 13 | |||||||||||||
34802 | 34802 | Mary Oakar O000001 | rep | OH | 1977-01-04 | 1979-01-03 | Democrat | 20 | |||||||||||||
34789 | 34789 | Henry Nowak N000163 | rep | NY | 1977-01-04 | 1979-01-03 | Democrat | 37 | |||||||||||||
34756 | 34756 | Clarence Miller M000718 | rep | OH | 1977-01-04 | 1979-01-03 | Republican | 10 | |||||||||||||
34740 | 34740 | Matthew McHugh M000473 | rep | NY | 1977-01-04 | 1979-01-03 | Democrat | 27 | |||||||||||||
34706 | 34706 | Ronald Marlenee M000139 | rep | MT | 1977-01-04 | 1979-01-03 | Republican | 2 | |||||||||||||
34698 | 34698 | Edward Madigan M000041 | rep | IL | 1977-01-04 | 1979-01-03 | Republican | 21 | |||||||||||||
34676 | 34676 | Norman Lent L000243 | rep | NY | 1977-01-04 | 1979-01-03 | Republican | 4 | |||||||||||||
34665 | 34665 | William Lehman L000226 | rep | FL | 1977-01-04 | 1979-01-03 | Democrat | 13 | |||||||||||||
34655 | 34655 | Robert Lagomarsino L000020 | rep | CA | 1977-01-04 | 1979-01-03 | Republican | 19 | |||||||||||||
34646 | 34646 | Peter Kostmayer K000319 | rep | PA | 1977-01-04 | 1979-01-03 | Democrat | 8 | |||||||||||||
34626 | 34626 | Walter Jones J000256 | rep | NC | 1977-01-04 | 1979-01-03 | Democrat | 1 | |||||||||||||
34605 | 34605 | Edgar Jenkins J000083 | rep | GA | 1977-01-04 | 1979-01-03 | Democrat | 9 | |||||||||||||
34595 | 34595 | Andrew Ireland I000029 | rep | FL | 1977-01-04 | 1979-01-03 | Democrat | 8 | |||||||||||||
34587 | 34587 | Thomas Huckaby H000901 | rep | LA | 1977-01-04 | 1979-01-03 | Democrat | 5 | |||||||||||||
34579 | 34579 | Carroll Hubbard H000878 | rep | KY | 1977-01-04 | 1979-01-03 | Democrat | 1 | |||||||||||||
34570 | 34570 | Frank Horton H000797 | rep | NY | 1977-01-04 | 1979-01-03 | Republican | 34 | |||||||||||||
34516 | 34516 | John Hammerschmidt H000124 | rep | AR | 1977-01-04 | 1979-01-03 | Republican | 3 | |||||||||||||
34496 | 34496 | Sedgwick Green G000417 | rep | NY | 1977-01-04 | 1979-01-03 | Republican | 18 | |||||||||||||
34483 | 34483 | Albert Gore G000321 | rep | TN | 1977-01-04 | 1979-01-03 | Democrat | 4 | |||||||||||||
34475 | 34475 | Joseph Gaydos G000105 | rep | PA | 1977-01-04 | 1979-01-03 | Democrat | 20 | |||||||||||||
34453 | 34453 | Dante Fascell F000041 | rep | FL | 1977-01-04 | 1979-01-03 | Democrat | 15 | |||||||||||||
34426 | 34426 | Marvin Edwards E000077 | rep | OK | 1977-01-04 | 1979-01-03 | Republican | 5 | |||||||||||||
34412 | 34412 | Joseph Early E000013 | rep | MA | 1977-01-04 | 1979-01-03 | Democrat | 3 | |||||||||||||
34391 | 34391 | Thomas Downey D000471 | rep | NY | 1977-01-04 | 1979-01-03 | Democrat | 2 | |||||||||||||
34375 | 34375 | William Dickinson D000326 | rep | AL | 1977-01-04 | 1979-01-03 | Republican | 2 | |||||||||||||
34346 | 34346 | Robert Coughlin C000807 | rep | PA | 1977-01-04 | 1979-01-03 | Republican | 13 | |||||||||||||
34334 | 34334 | Silvio Conte C000709 | rep | MA | 1977-01-04 | 1979-01-03 | Republican | 1 | |||||||||||||
34316 | 34316 | Earl Coleman C000618 | rep | MO | 1977-01-04 | 1979-01-03 | Republican | 6 | |||||||||||||
34311 | 34311 | William Cohen C000598 | rep | ME | 1977-01-04 | 1979-01-03 | Republican | 2 | |||||||||||||
34275 | 34275 | William Broomfield B000890 | rep | MI | 1977-01-04 | 1979-01-03 | Republican | 19 | |||||||||||||
34247 | 34247 | Charles Bennett B000371 | rep | FL | 1977-01-04 | 1979-01-03 | Democrat | 3 | |||||||||||||
34220 | 34220 | Druie Barnard B000153 | rep | GA | 1977-01-04 | 1979-01-03 | Democrat | 10 | |||||||||||||
34212 | 34212 | Les AuCoin A000337 | rep | OR | 1977-01-04 | 1979-01-03 | Democrat | 1 | |||||||||||||
34192 | 34192 | Frank Annunzio A000212 | rep | IL | 1977-01-04 | 1979-01-03 | Democrat | 11 | |||||||||||||
34178 | 34178 | Glenn Anderson A000189 | rep | CA | 1977-01-04 | 1979-01-03 | Democrat | 32 | |||||||||||||
34166 | 34166 | William Alexander A000103 | rep | AR | 1977-01-04 | 1979-01-03 | Democrat | 1 | |||||||||||||
34153 | 34153 | James Wright W000763 | rep | TX | 1977-01-04 | 1979-01-03 | Democrat | 12 | |||||||||||||
34131 | 34131 | Malcolm Wallop W000092 | sen | WY | 1977-01-04 | 1983-01-03 | 1 | Republican | |||||||||||||
34124 | 34124 | Douglas Walgren W000044 | rep | PA | 1977-01-04 | 1979-01-03 | Democrat | 18 | |||||||||||||
34111 | 34111 | Arlan Stangeland S000795 | rep | MN | 1977-01-04 | 1979-01-03 | Republican | 7 | |||||||||||||
34104 | 34104 | Virginia Smith S000622 | rep | NE | 1977-01-04 | 1979-01-03 | Republican | 3 | |||||||||||||
34079 | 34079 | James Sasser S000068 | sen | TN | 1977-01-04 | 1983-01-03 | 1 | Democrat | |||||||||||||
34068 | 34068 | Donald Riegle R000249 | sen | MI | 1977-01-04 | 1983-01-03 | 1 | Democrat | |||||||||||||
34056 | 34056 | Claude Pepper P000218 | rep | FL | 1977-01-04 | 1979-01-03 | Democrat | 14 | |||||||||||||
34015 | 34015 | Howard Metzenbaum M000678 | sen | OH | 1977-01-04 | 1983-01-03 | 1 | Democrat | |||||||||||||
34010 | 34010 | Spark Matsunaga M000250 | sen | HI | 1977-01-04 | 1983-01-03 | 1 | Democrat | |||||||||||||
33987 | 33987 | Thomas Luken L000508 | rep | OH | 1977-01-04 | 1979-01-03 | Democrat | 2 | |||||||||||||
33967 | 33967 | Robert Kastenmeier K000020 | rep | WI | 1977-01-04 | 1979-01-03 | Democrat | 2 | |||||||||||||
33950 | 33950 | Henry Heinz H000456 | sen | PA | 1977-01-04 | 1983-01-03 | 1 | Republican | |||||||||||||
33940 | 33940 | Augustus Hawkins H000367 | rep | CA | 1977-01-04 | 1979-01-03 | Democrat | 29 | |||||||||||||
33924 | 33924 | Robert Garcia G000047 | rep | NY | 1977-01-04 | 1979-01-03 | Democrat | 21 | |||||||||||||
33917 | 33917 | William Frenzel F000380 | rep | MN | 1977-01-04 | 1979-01-03 | Republican | 3 | |||||||||||||
33907 | 33907 | James Florio F000215 | rep | NJ | 1977-01-04 | 1979-01-03 | Democrat | 1 | |||||||||||||
33899 | 33899 | Ronnie Flippo F000208 | rep | AL | 1977-01-04 | 1979-01-03 | Democrat | 5 | |||||||||||||
33892 | 33892 | Walter Fauntroy F000046 | rep | DC | 1977-01-04 | 1979-01-03 | Democrat | 0 | |||||||||||||
33877 | 33877 | Dennis DeConcini D000185 | sen | AZ | 1977-01-04 | 1983-01-03 | 1 | Democrat | |||||||||||||
33874 | 33874 | John Danforth D000030 | sen | MO | 1977-01-04 | 1983-01-03 | 1 | Republican | |||||||||||||
33843 | 33843 | Quentin Burdick B001077 | sen | ND | 1977-01-04 | 1983-01-03 | 1 | Democrat | |||||||||||||
33824 | 33824 | Corinne Boggs B000592 | rep | LA | 1977-01-04 | 1979-01-03 | Democrat | 2 | |||||||||||||
33819 | 33819 | Lloyd Bentsen B000401 | sen | TX | 1977-01-04 | 1983-01-03 | 1 | Democrat | |||||||||||||
33800 | 33800 | Timothy Wirth W000647 | rep | CO | 1977-01-04 | 1979-01-03 | Democrat | 2 | |||||||||||||
33793 | 33793 | Gene Taylor T000075 | rep | MO | 1977-01-04 | 1979-01-03 | Republican | 7 | |||||||||||||
33787 | 33787 | Steven Symms S001138 | rep | ID | 1977-01-04 | 1979-01-03 | Republican | 1 | |||||||||||||
33771 | 33771 | Samuel Stratton S000997 | rep | NY | 1977-01-04 | 1979-01-03 | Democrat | 28 | |||||||||||||
33756 | 33756 | Fernand St. Germain S000762 | rep | RI | 1977-01-04 | 1979-01-03 | Democrat | 1 | |||||||||||||
33735 | 33735 | Peter Rodino R000374 | rep | NJ | 1977-01-04 | 1979-01-03 | Democrat | 10 | |||||||||||||
33717 | 33717 | James Quayle Q000007 | rep | IN | 1977-01-04 | 1979-01-03 | Republican | 4 | |||||||||||||
33711 | 33711 | Charles Price P000522 | rep | IL | 1977-01-04 | 1979-01-03 | Democrat | 23 | |||||||||||||
33689 | 33689 | William Nichols N000095 | rep | AL | 1977-01-04 | 1979-01-03 | Democrat | 3 | |||||||||||||
33673 | 33673 | Stewart McKinney M000527 | rep | CT | 1977-01-04 | 1979-01-03 | Republican | 4 | |||||||||||||
33661 | 33661 | Manuel Luján L000506 | rep | NM | 1977-01-04 | 1979-01-03 | Republican | 1 | |||||||||||||
33646 | 33646 | Delbert Latta L000116 | rep | OH | 1977-01-04 | 1979-01-03 | Republican | 5 | |||||||||||||
33630 | 33630 | Jack Kemp K000086 | rep | NY | 1977-01-04 | 1979-01-03 | Republican | 38 | |||||||||||||
33624 | 33624 | Robert Kasten K000019 | rep | WI | 1977-01-04 | 1979-01-03 | Republican | 9 | |||||||||||||
33616 | 33616 | Ed Jones J000216 | rep | TN | 1977-01-04 | 1979-01-03 | Democrat | 7 |
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);