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 district descending
This data as json, copyable, CSV (advanced)
Suggested facets: 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
32533 | 32533 | Clair Burgener B001080 | rep | CA | 1975-01-14 | 1977-01-03 | Republican | 43 | |||||||||||||
32373 | 32373 | Lionel Van Deerlin V000024 | rep | CA | 1975-01-14 | 1977-01-03 | Democrat | 42 | |||||||||||||
32409 | 32409 | Robert Wilson W000610 | rep | CA | 1975-01-14 | 1977-01-03 | Republican | 41 | |||||||||||||
31019 | 31019 | Andrew Hinshaw H000638 | rep | CA | 1975-01-14 | 1977-01-03 | Republican | 40 | |||||||||||||
30973 | 30973 | James Hastings H000327 | rep | NY | 1975-01-14 | 1977-01-03 | Republican | 39 | |||||||||||||
31891 | 31891 | Charles Wiggins W000448 | rep | CA | 1975-01-14 | 1977-01-03 | Republican | 39 | |||||||||||||
33346 | 33346 | Stanley Lundine L000516 | rep | NY | 1975-01-14 | 1977-01-03 | Democrat | 39 | |||||||||||||
33082 | 33082 | Jerry Patterson P000121 | rep | CA | 1975-01-14 | 1977-01-03 | Democrat | 38 | |||||||||||||
33629 | 33629 | Jack Kemp K000086 | rep | NY | 1975-01-14 | 1977-01-03 | Republican | 38 | |||||||||||||
31280 | 31280 | Jerry Pettis P000272 | rep | CA | 1975-01-14 | 1975-02-14 | Republican | 37 | |||||||||||||
34788 | 34788 | Henry Nowak N000163 | rep | NY | 1975-01-14 | 1977-01-03 | Democrat | 37 | |||||||||||||
36527 | 36527 | George Brown B000918 | rep | CA | 1975-01-14 | 1977-01-03 | Democrat | 36 | |||||||||||||
36987 | 36987 | John LaFalce L000556 | rep | NY | 1975-01-14 | 1977-01-03 | Democrat | 36 | |||||||||||||
32150 | 32150 | James Lloyd L000379 | rep | CA | 1975-01-14 | 1977-01-03 | Democrat | 35 | |||||||||||||
32927 | 32927 | Barber Conable C000666 | rep | NY | 1975-01-14 | 1977-01-03 | Republican | 35 | |||||||||||||
31583 | 31583 | Mark Hannaford H000166 | rep | CA | 1975-01-14 | 1977-01-03 | Democrat | 34 | |||||||||||||
34569 | 34569 | Frank Horton H000797 | rep | NY | 1975-01-14 | 1977-01-03 | Republican | 34 | |||||||||||||
31505 | 31505 | Delwin Clawson C000476 | rep | CA | 1975-01-14 | 1977-01-03 | Republican | 33 | |||||||||||||
31879 | 31879 | William Walsh W000107 | rep | NY | 1975-01-14 | 1977-01-03 | Republican | 33 | |||||||||||||
32094 | 32094 | James Hanley H000158 | rep | NY | 1975-01-14 | 1977-01-03 | Democrat | 32 | |||||||||||||
34177 | 34177 | Glenn Anderson A000189 | rep | CA | 1975-01-14 | 1977-01-03 | Democrat | 32 | |||||||||||||
32395 | 32395 | Charles Wilson W000571 | rep | CA | 1975-01-14 | 1977-01-03 | Democrat | 31 | |||||||||||||
32773 | 32773 | Donald Mitchell M000808 | rep | NY | 1975-01-14 | 1977-01-03 | Republican | 31 | |||||||||||||
32171 | 32171 | Robert McEwen M000433 | rep | NY | 1975-01-14 | 1977-01-03 | Republican | 30 | |||||||||||||
32588 | 32588 | George Danielson D000043 | rep | CA | 1975-01-14 | 1977-01-03 | Democrat | 30 | |||||||||||||
31705 | 31705 | Edward Pattison P000134 | rep | NY | 1975-01-14 | 1977-01-03 | Democrat | 29 | |||||||||||||
33939 | 33939 | Augustus Hawkins H000367 | rep | CA | 1975-01-14 | 1977-01-03 | Democrat | 29 | |||||||||||||
31451 | 31451 | Yvonne Burke B001102 | rep | CA | 1975-01-14 | 1977-01-03 | Democrat | 28 | |||||||||||||
33770 | 33770 | Samuel Stratton S000997 | rep | NY | 1975-01-14 | 1977-01-03 | Democrat | 28 | |||||||||||||
30845 | 30845 | Alphonzo Bell B000330 | rep | CA | 1975-01-14 | 1977-01-03 | Republican | 27 | |||||||||||||
34739 | 34739 | Matthew McHugh M000473 | rep | NY | 1975-01-14 | 1977-01-03 | Democrat | 27 | |||||||||||||
32847 | 32847 | John Rousselot R000469 | rep | CA | 1975-01-14 | 1977-01-03 | Republican | 26 | |||||||||||||
36921 | 36921 | Benjamin Gilman G000212 | rep | NY | 1975-01-14 | 1977-01-03 | Republican | 26 | |||||||||||||
31692 | 31692 | Gary Myers M001128 | rep | PA | 1975-01-14 | 1977-01-03 | Republican | 25 | |||||||||||||
34904 | 34904 | Edward Roybal R000485 | rep | CA | 1975-01-14 | 1977-01-03 | Democrat | 25 | |||||||||||||
35235 | 35235 | Hamilton Fish F000141 | rep | NY | 1975-01-14 | 1977-01-03 | Republican | 25 | |||||||||||||
31401 | 31401 | Joseph Vigorito V000098 | rep | PA | 1975-01-14 | 1977-01-03 | Democrat | 24 | |||||||||||||
31673 | 31673 | Dale Milford M000708 | rep | TX | 1975-01-14 | 1977-01-03 | Democrat | 24 | |||||||||||||
33075 | 33075 | Richard Ottinger O000134 | rep | NY | 1975-01-14 | 1977-01-03 | Democrat | 24 | |||||||||||||
34956 | 34956 | Paul Simon S000423 | rep | IL | 1975-01-14 | 1977-01-03 | Democrat | 24 | |||||||||||||
40079 | 40079 | Henry Waxman W000215 | rep | CA | 1975-01-14 | 1977-01-03 | Democrat | 24 | |||||||||||||
31080 | 31080 | Albert Johnson J000115 | rep | PA | 1975-01-14 | 1977-01-03 | Republican | 23 | |||||||||||||
31295 | 31295 | Thomas Rees R000134 | rep | CA | 1975-01-14 | 1977-01-03 | Democrat | 23 | |||||||||||||
32790 | 32790 | Ronald Mottl M001044 | rep | OH | 1975-01-14 | 1977-01-03 | Democrat | 23 | |||||||||||||
32798 | 32798 | Peter Peyser P000280 | rep | NY | 1975-01-14 | 1977-01-03 | Republican | 23 | |||||||||||||
33015 | 33015 | Abraham Kazen K000025 | rep | TX | 1975-01-14 | 1977-01-03 | Democrat | 23 | |||||||||||||
33710 | 33710 | Charles Price P000522 | rep | IL | 1975-01-14 | 1977-01-03 | Democrat | 23 | |||||||||||||
30863 | 30863 | Robert Casey C000228 | rep | TX | 1975-01-14 | 1977-01-03 | Democrat | 22 | |||||||||||||
31216 | 31216 | Thomas Morgan M000958 | rep | PA | 1975-01-14 | 1977-01-03 | Democrat | 22 | |||||||||||||
31798 | 31798 | George Shipley S000367 | rep | IL | 1975-01-14 | 1977-01-03 | Democrat | 22 | |||||||||||||
32386 | 32386 | Charles Vanik V000047 | rep | OH | 1975-01-14 | 1977-01-03 | Democrat | 22 | |||||||||||||
32481 | 32481 | Jonathan Bingham B000472 | rep | NY | 1975-01-14 | 1977-01-03 | Democrat | 22 | |||||||||||||
35934 | 35934 | Carlos Moorhead M000926 | rep | CA | 1975-01-14 | 1977-01-03 | Republican | 22 | |||||||||||||
39448 | 39448 | Ronald Paul P000583 | rep | TX | 1975-01-14 | 1977-01-03 | Republican | 22 | |||||||||||||
31417 | 31417 | Herman Badillo B000025 | rep | NY | 1975-01-14 | 1977-01-03 | Democrat | 21 | |||||||||||||
31536 | 31536 | John Dent D000255 | rep | PA | 1975-01-14 | 1977-01-03 | Democrat | 21 | |||||||||||||
32007 | 32007 | James Corman C000780 | rep | CA | 1975-01-14 | 1977-01-03 | Democrat | 21 | |||||||||||||
34697 | 34697 | Edward Madigan M000041 | rep | IL | 1975-01-14 | 1977-01-03 | Republican | 21 | |||||||||||||
35351 | 35351 | Robert Krueger K000333 | rep | TX | 1975-01-14 | 1977-01-03 | Democrat | 21 | |||||||||||||
36401 | 36401 | Louis Stokes S000948 | rep | OH | 1975-01-14 | 1977-01-03 | Democrat | 21 | |||||||||||||
30802 | 30802 | Bella Abzug A000018 | rep | NY | 1975-01-14 | 1977-01-03 | Democrat | 20 | |||||||||||||
31334 | 31334 | James Stanton S000803 | rep | OH | 1975-01-14 | 1977-01-03 | Democrat | 20 | |||||||||||||
32650 | 32650 | Paul Findley F000123 | rep | IL | 1975-01-14 | 1977-01-03 | Republican | 20 | |||||||||||||
32686 | 32686 | Barry Goldwater G000268 | rep | CA | 1975-01-14 | 1977-01-03 | Republican | 20 | |||||||||||||
34474 | 34474 | Joseph Gaydos G000105 | rep | PA | 1975-01-14 | 1977-01-03 | Democrat | 20 | |||||||||||||
36210 | 36210 | Henry González G000272 | rep | TX | 1975-01-14 | 1977-01-03 | Democrat | 20 | |||||||||||||
31484 | 31484 | Charles Carney C000164 | rep | OH | 1975-01-14 | 1977-01-03 | Democrat | 19 | |||||||||||||
31641 | 31641 | George Mahon M000065 | rep | TX | 1975-01-14 | 1977-01-03 | Democrat | 19 | |||||||||||||
32805 | 32805 | Thomas Railsback R000012 | rep | IL | 1975-01-14 | 1977-01-03 | Republican | 19 | |||||||||||||
34274 | 34274 | William Broomfield B000890 | rep | MI | 1975-01-14 | 1977-01-03 | Republican | 19 | |||||||||||||
34654 | 34654 | Robert Lagomarsino L000020 | rep | CA | 1975-01-14 | 1977-01-03 | Republican | 19 | |||||||||||||
36631 | 36631 | William Goodling G000291 | rep | PA | 1975-01-14 | 1977-01-03 | Republican | 19 | |||||||||||||
40440 | 40440 | Charles Rangel R000053 | rep | NY | 1975-01-14 | 1977-01-03 | Democrat | 19 | |||||||||||||
30988 | 30988 | Wayne Hays H000408 | rep | OH | 1975-01-14 | 1977-01-03 | Democrat | 18 | |||||||||||||
31598 | 31598 | Barbara Jordan J000266 | rep | TX | 1975-01-14 | 1977-01-03 | Democrat | 18 | |||||||||||||
31601 | 31601 | William Ketchum K000153 | rep | CA | 1975-01-14 | 1977-01-03 | Republican | 18 | |||||||||||||
31608 | 31608 | Edward Koch K000302 | rep | NY | 1975-01-14 | 1977-01-03 | Democrat | 18 | |||||||||||||
32485 | 32485 | James Blanchard B000538 | rep | MI | 1975-01-14 | 1977-01-03 | Democrat | 18 | |||||||||||||
33949 | 33949 | Henry Heinz H000456 | rep | PA | 1975-01-14 | 1977-01-03 | Republican | 18 | |||||||||||||
35437 | 35437 | Robert Michel M000692 | rep | IL | 1975-01-14 | 1977-01-03 | Republican | 18 | |||||||||||||
31317 | 31317 | Herman Schneebeli S000135 | rep | PA | 1975-01-14 | 1977-01-03 | Republican | 17 | |||||||||||||
31467 | 31467 | Omar Burleson B001111 | rep | TX | 1975-01-14 | 1977-01-03 | Democrat | 17 | |||||||||||||
31610 | 31610 | John Krebs K000325 | rep | CA | 1975-01-14 | 1977-01-03 | Democrat | 17 | |||||||||||||
32201 | 32201 | John Murphy M001098 | rep | NY | 1975-01-14 | 1977-01-03 | Democrat | 17 | |||||||||||||
32453 | 32453 | John Ashbrook A000221 | rep | OH | 1975-01-14 | 1977-01-03 | Republican | 17 | |||||||||||||
32519 | 32519 | William Brodhead B000862 | rep | MI | 1975-01-14 | 1977-01-03 | Democrat | 17 | |||||||||||||
33376 | 33376 | George O’Brien O000010 | rep | IL | 1975-01-14 | 1977-01-03 | Republican | 17 | |||||||||||||
30920 | 30920 | Edwin Eshleman E000214 | rep | PA | 1975-01-14 | 1977-01-03 | Republican | 16 | |||||||||||||
31380 | 31380 | Burt Talcott T000022 | rep | CA | 1975-01-14 | 1977-01-03 | Republican | 16 | |||||||||||||
31829 | 31829 | Bernice Sisk S000454 | rep | CA | 1975-01-14 | 1977-01-03 | Democrat | 16 | |||||||||||||
31927 | 31927 | John Anderson A000195 | rep | IL | 1975-01-14 | 1977-01-03 | Republican | 16 | |||||||||||||
32111 | 32111 | Elizabeth Holtzman H000752 | rep | NY | 1975-01-14 | 1977-01-03 | Democrat | 16 | |||||||||||||
32886 | 32886 | Richard White W000390 | rep | TX | 1975-01-14 | 1977-01-03 | Democrat | 16 | |||||||||||||
38294 | 38294 | Ralph Regula R000141 | rep | OH | 1975-01-14 | 1977-01-03 | Republican | 16 | |||||||||||||
39809 | 39809 | John Dingell D000355 | rep | MI | 1975-01-14 | 1977-01-03 | Democrat | 16 | |||||||||||||
30969 | 30969 | Tim Hall H000073 | rep | IL | 1975-01-14 | 1977-01-03 | Democrat | 15 | |||||||||||||
31775 | 31775 | Frederick Rooney R000423 | rep | PA | 1975-01-14 | 1977-01-03 | Democrat | 15 | |||||||||||||
32229 | 32229 | Edward Patten P000106 | rep | NJ | 1975-01-14 | 1977-01-03 | Democrat | 15 | |||||||||||||
32890 | 32890 | Leo Zeferetti Z000002 | rep | NY | 1975-01-14 | 1977-01-03 | Democrat | 15 | |||||||||||||
34452 | 34452 | Dante Fascell F000041 | rep | FL | 1975-01-14 | 1977-01-03 | Democrat | 15 |
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);