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 1975-01-14 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
34904 | 34904 | Edward Roybal R000485 | rep | CA | 1975-01-14 | 1977-01-03 | Democrat | 25 | |||||||||||||
34889 | 34889 | Robert Roe R000383 | rep | NJ | 1975-01-14 | 1977-01-03 | Democrat | 8 | |||||||||||||
34870 | 34870 | Matthew Rinaldo R000262 | rep | NJ | 1975-01-14 | 1977-01-03 | Republican | 12 | |||||||||||||
34841 | 34841 | Larry Pressler P000513 | rep | SD | 1975-01-14 | 1977-01-03 | Republican | 1 | |||||||||||||
34788 | 34788 | Henry Nowak N000163 | rep | NY | 1975-01-14 | 1977-01-03 | Democrat | 37 | |||||||||||||
34755 | 34755 | Clarence Miller M000718 | rep | OH | 1975-01-14 | 1977-01-03 | Republican | 10 | |||||||||||||
34739 | 34739 | Matthew McHugh M000473 | rep | NY | 1975-01-14 | 1977-01-03 | Democrat | 27 | |||||||||||||
34697 | 34697 | Edward Madigan M000041 | rep | IL | 1975-01-14 | 1977-01-03 | Republican | 21 | |||||||||||||
34675 | 34675 | Norman Lent L000243 | rep | NY | 1975-01-14 | 1977-01-03 | Republican | 4 | |||||||||||||
34664 | 34664 | William Lehman L000226 | rep | FL | 1975-01-14 | 1977-01-03 | Democrat | 13 | |||||||||||||
34654 | 34654 | Robert Lagomarsino L000020 | rep | CA | 1975-01-14 | 1977-01-03 | Republican | 19 | |||||||||||||
34625 | 34625 | Walter Jones J000256 | rep | NC | 1975-01-14 | 1977-01-03 | Democrat | 1 | |||||||||||||
34578 | 34578 | Carroll Hubbard H000878 | rep | KY | 1975-01-14 | 1977-01-03 | Democrat | 1 | |||||||||||||
34569 | 34569 | Frank Horton H000797 | rep | NY | 1975-01-14 | 1977-01-03 | Republican | 34 | |||||||||||||
34515 | 34515 | John Hammerschmidt H000124 | rep | AR | 1975-01-14 | 1977-01-03 | Republican | 3 | |||||||||||||
34474 | 34474 | Joseph Gaydos G000105 | rep | PA | 1975-01-14 | 1977-01-03 | Democrat | 20 | |||||||||||||
34452 | 34452 | Dante Fascell F000041 | rep | FL | 1975-01-14 | 1977-01-03 | Democrat | 15 | |||||||||||||
34411 | 34411 | Joseph Early E000013 | rep | MA | 1975-01-14 | 1977-01-03 | Democrat | 3 | |||||||||||||
34390 | 34390 | Thomas Downey D000471 | rep | NY | 1975-01-14 | 1977-01-03 | Democrat | 2 | |||||||||||||
34374 | 34374 | William Dickinson D000326 | rep | AL | 1975-01-14 | 1977-01-03 | Republican | 2 | |||||||||||||
34345 | 34345 | Robert Coughlin C000807 | rep | PA | 1975-01-14 | 1977-01-03 | Republican | 13 | |||||||||||||
34333 | 34333 | Silvio Conte C000709 | rep | MA | 1975-01-14 | 1977-01-03 | Republican | 1 | |||||||||||||
34315 | 34315 | Earl Coleman C000618 | rep | MO | 1975-01-14 | 1977-01-03 | Republican | 6 | |||||||||||||
34310 | 34310 | William Cohen C000598 | rep | ME | 1975-01-14 | 1977-01-03 | Republican | 2 | |||||||||||||
34274 | 34274 | William Broomfield B000890 | rep | MI | 1975-01-14 | 1977-01-03 | Republican | 19 | |||||||||||||
34246 | 34246 | Charles Bennett B000371 | rep | FL | 1975-01-14 | 1977-01-03 | Democrat | 3 | |||||||||||||
34211 | 34211 | Les AuCoin A000337 | rep | OR | 1975-01-14 | 1977-01-03 | Democrat | 1 | |||||||||||||
34191 | 34191 | Frank Annunzio A000212 | rep | IL | 1975-01-14 | 1977-01-03 | Democrat | 11 | |||||||||||||
34177 | 34177 | Glenn Anderson A000189 | rep | CA | 1975-01-14 | 1977-01-03 | Democrat | 32 | |||||||||||||
34165 | 34165 | William Alexander A000103 | rep | AR | 1975-01-14 | 1977-01-03 | Democrat | 1 | |||||||||||||
34152 | 34152 | James Wright W000763 | rep | TX | 1975-01-14 | 1977-01-03 | Democrat | 12 | |||||||||||||
34103 | 34103 | Virginia Smith S000622 | rep | NE | 1975-01-14 | 1977-01-03 | Republican | 3 | |||||||||||||
34067 | 34067 | Donald Riegle R000249 | rep | MI | 1975-01-14 | 1977-01-03 | Democrat | 7 | |||||||||||||
34055 | 34055 | Claude Pepper P000218 | rep | FL | 1975-01-14 | 1977-01-03 | Democrat | 14 | |||||||||||||
34009 | 34009 | Spark Matsunaga M000250 | rep | HI | 1975-01-14 | 1977-01-03 | Democrat | 1 | |||||||||||||
33966 | 33966 | Robert Kastenmeier K000020 | rep | WI | 1975-01-14 | 1977-01-03 | Democrat | 2 | |||||||||||||
33949 | 33949 | Henry Heinz H000456 | rep | PA | 1975-01-14 | 1977-01-03 | Republican | 18 | |||||||||||||
33939 | 33939 | Augustus Hawkins H000367 | rep | CA | 1975-01-14 | 1977-01-03 | Democrat | 29 | |||||||||||||
33916 | 33916 | William Frenzel F000380 | rep | MN | 1975-01-14 | 1977-01-03 | Republican | 3 | |||||||||||||
33906 | 33906 | James Florio F000215 | rep | NJ | 1975-01-14 | 1977-01-03 | Democrat | 1 | |||||||||||||
33891 | 33891 | Walter Fauntroy F000046 | rep | DC | 1975-01-14 | 1977-01-03 | Democrat | 0 | |||||||||||||
33823 | 33823 | Corinne Boggs B000592 | rep | LA | 1975-01-14 | 1977-01-03 | Democrat | 2 | |||||||||||||
33799 | 33799 | Timothy Wirth W000647 | rep | CO | 1975-01-14 | 1977-01-03 | Democrat | 2 | |||||||||||||
33792 | 33792 | Gene Taylor T000075 | rep | MO | 1975-01-14 | 1977-01-03 | Republican | 7 | |||||||||||||
33786 | 33786 | Steven Symms S001138 | rep | ID | 1975-01-14 | 1977-01-03 | Republican | 1 | |||||||||||||
33770 | 33770 | Samuel Stratton S000997 | rep | NY | 1975-01-14 | 1977-01-03 | Democrat | 28 | |||||||||||||
33755 | 33755 | Fernand St. Germain S000762 | rep | RI | 1975-01-14 | 1977-01-03 | Democrat | 1 | |||||||||||||
33734 | 33734 | Peter Rodino R000374 | rep | NJ | 1975-01-14 | 1977-01-03 | Democrat | 10 | |||||||||||||
33710 | 33710 | Charles Price P000522 | rep | IL | 1975-01-14 | 1977-01-03 | Democrat | 23 | |||||||||||||
33688 | 33688 | William Nichols N000095 | rep | AL | 1975-01-14 | 1977-01-03 | Democrat | 3 | |||||||||||||
33672 | 33672 | Stewart McKinney M000527 | rep | CT | 1975-01-14 | 1977-01-03 | Republican | 4 | |||||||||||||
33660 | 33660 | Manuel Luján L000506 | rep | NM | 1975-01-14 | 1977-01-03 | Republican | 1 | |||||||||||||
33645 | 33645 | Delbert Latta L000116 | rep | OH | 1975-01-14 | 1977-01-03 | Republican | 5 | |||||||||||||
33629 | 33629 | Jack Kemp K000086 | rep | NY | 1975-01-14 | 1977-01-03 | Republican | 38 | |||||||||||||
33623 | 33623 | Robert Kasten K000019 | rep | WI | 1975-01-14 | 1977-01-03 | Republican | 9 | |||||||||||||
33615 | 33615 | Ed Jones J000216 | rep | TN | 1975-01-14 | 1977-01-03 | Democrat | 7 | |||||||||||||
33605 | 33605 | James Howard H000840 | rep | NJ | 1975-01-14 | 1977-01-03 | Democrat | 3 | |||||||||||||
33585 | 33585 | Edwin Garn G000072 | sen | UT | 1975-01-14 | 1981-01-03 | 3 | Republican | |||||||||||||
33571 | 33571 | John Duncan D000534 | rep | TN | 1975-01-14 | 1977-01-03 | Republican | 2 | |||||||||||||
33546 | 33546 | Wilbur Daniel D000038 | rep | VA | 1975-01-14 | 1977-01-03 | Democrat | 5 | |||||||||||||
33540 | 33540 | Alan Cranston C000877 | sen | CA | 1975-01-14 | 1981-01-03 | 3 | Democrat | |||||||||||||
33532 | 33532 | William Chappell C000321 | rep | FL | 1975-01-14 | 1977-01-03 | Democrat | 4 | |||||||||||||
33517 | 33517 | Don Bonker B000620 | rep | WA | 1975-01-14 | 1977-01-03 | Democrat | 3 | |||||||||||||
33505 | 33505 | Edward Boland B000600 | rep | MA | 1975-01-14 | 1977-01-03 | Democrat | 2 | |||||||||||||
33487 | 33487 | Mario Biaggi B000432 | rep | NY | 1975-01-14 | 1977-01-03 | Democrat | 10 | |||||||||||||
33475 | 33475 | Brockman Adams A000031 | rep | WA | 1975-01-14 | 1977-01-03 | Democrat | 7 | |||||||||||||
33463 | 33463 | James Broyhill B000966 | rep | NC | 1975-01-14 | 1977-01-03 | Republican | 10 | |||||||||||||
33437 | 33437 | George Whitehurst W000406 | rep | VA | 1975-01-14 | 1977-01-03 | Republican | 2 | |||||||||||||
33428 | 33428 | James Weaver W000227 | rep | OR | 1975-01-14 | 1977-01-03 | Democrat | 4 | |||||||||||||
33420 | 33420 | Marion Snyder S000669 | rep | KY | 1975-01-14 | 1977-01-03 | Republican | 4 | |||||||||||||
33406 | 33406 | John Seiberling S000230 | rep | OH | 1975-01-14 | 1977-01-03 | Democrat | 14 | |||||||||||||
33393 | 33393 | Thomas O’Neill O000098 | rep | MA | 1975-01-14 | 1977-01-03 | Democrat | 8 | |||||||||||||
33376 | 33376 | George O’Brien O000010 | rep | IL | 1975-01-14 | 1977-01-03 | Republican | 17 | |||||||||||||
33369 | 33369 | William Moore M000923 | rep | LA | 1975-01-14 | 1977-01-03 | Republican | 6 | |||||||||||||
33362 | 33362 | Parren Mitchell M000826 | rep | MD | 1975-01-14 | 1977-01-03 | Democrat | 7 | |||||||||||||
33346 | 33346 | Stanley Lundine L000516 | rep | NY | 1975-01-14 | 1977-01-03 | Democrat | 39 | |||||||||||||
33340 | 33340 | Gillis Long L000417 | rep | LA | 1975-01-14 | 1977-01-03 | Democrat | 8 | |||||||||||||
33323 | 33323 | Thomas Kindness K000190 | rep | OH | 1975-01-14 | 1977-01-03 | Republican | 8 | |||||||||||||
33317 | 33317 | James Jones J000232 | rep | OK | 1975-01-14 | 1977-01-03 | Democrat | 1 | |||||||||||||
33308 | 33308 | Marjorie Holt H000747 | rep | MD | 1975-01-14 | 1977-01-03 | Republican | 4 | |||||||||||||
33301 | 33301 | Elwood Hillis H000624 | rep | IN | 1975-01-14 | 1977-01-03 | Republican | 5 | |||||||||||||
33283 | 33283 | Sam Hall H000070 | rep | TX | 1975-01-14 | 1977-01-03 | Democrat | 1 | |||||||||||||
33276 | 33276 | Don Fuqua F000430 | rep | FL | 1975-01-14 | 1977-01-03 | Democrat | 2 | |||||||||||||
33256 | 33256 | Robert Edgar E000043 | rep | PA | 1975-01-14 | 1977-01-03 | Democrat | 7 | |||||||||||||
33234 | 33234 | Berkley Bedell B000298 | rep | IA | 1975-01-14 | 1977-01-03 | Democrat | 6 | |||||||||||||
33226 | 33226 | William Armstrong A000219 | rep | CO | 1975-01-14 | 1977-01-03 | Republican | 5 | |||||||||||||
33219 | 33219 | Joseph Addabbo A000052 | rep | NY | 1975-01-14 | 1977-01-03 | Democrat | 7 | |||||||||||||
33204 | 33204 | Clement Zablocki Z000001 | rep | WI | 1975-01-14 | 1977-01-03 | Democrat | 4 | |||||||||||||
33186 | 33186 | Antonio Won Pat W000686 | rep | GU | 1975-01-14 | 1977-01-03 | Democrat | 0 | |||||||||||||
33180 | 33180 | Edward Winn W000636 | rep | KS | 1975-01-14 | 1977-01-03 | Republican | 3 | |||||||||||||
33134 | 33134 | Benjamin Rosenthal R000442 | rep | NY | 1975-01-14 | 1977-01-03 | Democrat | 8 | |||||||||||||
33122 | 33122 | James Robinson R000337 | rep | VA | 1975-01-14 | 1977-01-03 | Republican | 7 | |||||||||||||
33106 | 33106 | Joel Pritchard P000546 | rep | WA | 1975-01-14 | 1977-01-03 | Republican | 1 | |||||||||||||
33100 | 33100 | Carl Perkins P000230 | rep | KY | 1975-01-14 | 1977-01-03 | Democrat | 7 | |||||||||||||
33082 | 33082 | Jerry Patterson P000121 | rep | CA | 1975-01-14 | 1977-01-03 | Democrat | 38 | |||||||||||||
33075 | 33075 | Richard Ottinger O000134 | rep | NY | 1975-01-14 | 1977-01-03 | Democrat | 24 | |||||||||||||
33067 | 33067 | Joseph Minish M000796 | rep | NJ | 1975-01-14 | 1977-01-03 | Democrat | 11 | |||||||||||||
33058 | 33058 | John Melcher M000635 | rep | MT | 1975-01-14 | 1977-01-03 | Democrat | 2 | |||||||||||||
33049 | 33049 | Lawrence McDonald M000413 | rep | GA | 1975-01-14 | 1977-01-03 | Democrat | 7 | |||||||||||||
33044 | 33044 | James Martin M000183 | rep | NC | 1975-01-14 | 1977-01-03 | Republican | 9 |
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);