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 district descending
This data as json, copyable, CSV (advanced)
Suggested facets: type, 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
32534 | 32534 | Clair Burgener B001080 | rep | CA | 1977-01-04 | 1979-01-03 | Republican | 43 | |||||||||||||
32374 | 32374 | Lionel Van Deerlin V000024 | rep | CA | 1977-01-04 | 1979-01-03 | Democrat | 42 | |||||||||||||
32410 | 32410 | Robert Wilson W000610 | rep | CA | 1977-01-04 | 1979-01-03 | Republican | 41 | |||||||||||||
33478 | 33478 | Robert Badham B000024 | rep | CA | 1977-01-04 | 1979-01-03 | Republican | 40 | |||||||||||||
31892 | 31892 | Charles Wiggins W000448 | rep | CA | 1977-01-04 | 1979-01-03 | Republican | 39 | |||||||||||||
33347 | 33347 | Stanley Lundine L000516 | rep | NY | 1977-01-04 | 1979-01-03 | Democrat | 39 | |||||||||||||
33083 | 33083 | Jerry Patterson P000121 | rep | CA | 1977-01-04 | 1979-01-03 | Democrat | 38 | |||||||||||||
33630 | 33630 | Jack Kemp K000086 | rep | NY | 1977-01-04 | 1979-01-03 | Republican | 38 | |||||||||||||
31708 | 31708 | Shirley Pettis P000273 | rep | CA | 1977-01-04 | 1979-01-03 | Republican | 37 | |||||||||||||
34789 | 34789 | Henry Nowak N000163 | rep | NY | 1977-01-04 | 1979-01-03 | Democrat | 37 | |||||||||||||
36528 | 36528 | George Brown B000918 | rep | CA | 1977-01-04 | 1979-01-03 | Democrat | 36 | |||||||||||||
36988 | 36988 | John LaFalce L000556 | rep | NY | 1977-01-04 | 1979-01-03 | Democrat | 36 | |||||||||||||
32151 | 32151 | James Lloyd L000379 | rep | CA | 1977-01-04 | 1979-01-03 | Democrat | 35 | |||||||||||||
32928 | 32928 | Barber Conable C000666 | rep | NY | 1977-01-04 | 1979-01-03 | Republican | 35 | |||||||||||||
31584 | 31584 | Mark Hannaford H000166 | rep | CA | 1977-01-04 | 1979-01-03 | Democrat | 34 | |||||||||||||
34570 | 34570 | Frank Horton H000797 | rep | NY | 1977-01-04 | 1979-01-03 | Republican | 34 | |||||||||||||
31506 | 31506 | Delwin Clawson C000476 | rep | CA | 1977-01-04 | 1979-01-03 | Republican | 33 | |||||||||||||
31880 | 31880 | William Walsh W000107 | rep | NY | 1977-01-04 | 1979-01-03 | Republican | 33 | |||||||||||||
32095 | 32095 | James Hanley H000158 | rep | NY | 1977-01-04 | 1979-01-03 | Democrat | 32 | |||||||||||||
34178 | 34178 | Glenn Anderson A000189 | rep | CA | 1977-01-04 | 1979-01-03 | Democrat | 32 | |||||||||||||
32396 | 32396 | Charles Wilson W000571 | rep | CA | 1977-01-04 | 1979-01-03 | Democrat | 31 | |||||||||||||
32774 | 32774 | Donald Mitchell M000808 | rep | NY | 1977-01-04 | 1979-01-03 | Republican | 31 | |||||||||||||
32172 | 32172 | Robert McEwen M000433 | rep | NY | 1977-01-04 | 1979-01-03 | Republican | 30 | |||||||||||||
32589 | 32589 | George Danielson D000043 | rep | CA | 1977-01-04 | 1979-01-03 | Democrat | 30 | |||||||||||||
31706 | 31706 | Edward Pattison P000134 | rep | NY | 1977-01-04 | 1979-01-03 | Democrat | 29 | |||||||||||||
33940 | 33940 | Augustus Hawkins H000367 | rep | CA | 1977-01-04 | 1979-01-03 | Democrat | 29 | |||||||||||||
31452 | 31452 | Yvonne Burke B001102 | rep | CA | 1977-01-04 | 1979-01-03 | Democrat | 28 | |||||||||||||
33771 | 33771 | Samuel Stratton S000997 | rep | NY | 1977-01-04 | 1979-01-03 | Democrat | 28 | |||||||||||||
34740 | 34740 | Matthew McHugh M000473 | rep | NY | 1977-01-04 | 1979-01-03 | Democrat | 27 | |||||||||||||
35772 | 35772 | Robert Dornan D000435 | rep | CA | 1977-01-04 | 1979-01-03 | Republican | 27 | |||||||||||||
32848 | 32848 | John Rousselot R000469 | rep | CA | 1977-01-04 | 1979-01-03 | Republican | 26 | |||||||||||||
36922 | 36922 | Benjamin Gilman G000212 | rep | NY | 1977-01-04 | 1979-01-03 | Republican | 26 | |||||||||||||
31693 | 31693 | Gary Myers M001128 | rep | PA | 1977-01-04 | 1979-01-03 | Republican | 25 | |||||||||||||
34905 | 34905 | Edward Roybal R000485 | rep | CA | 1977-01-04 | 1979-01-03 | Democrat | 25 | |||||||||||||
35236 | 35236 | Hamilton Fish F000141 | rep | NY | 1977-01-04 | 1979-01-03 | Republican | 25 | |||||||||||||
31674 | 31674 | Dale Milford M000708 | rep | TX | 1977-01-04 | 1979-01-03 | Democrat | 24 | |||||||||||||
32740 | 32740 | Marc Marks M000136 | rep | PA | 1977-01-04 | 1979-01-03 | Republican | 24 | |||||||||||||
33076 | 33076 | Richard Ottinger O000134 | rep | NY | 1977-01-04 | 1979-01-03 | Democrat | 24 | |||||||||||||
34957 | 34957 | Paul Simon S000423 | rep | IL | 1977-01-04 | 1979-01-03 | Democrat | 24 | |||||||||||||
40080 | 40080 | Henry Waxman W000215 | rep | CA | 1977-01-04 | 1979-01-03 | Democrat | 24 | |||||||||||||
31414 | 31414 | Joseph Ammerman A000177 | rep | PA | 1977-01-04 | 1979-01-03 | Democrat | 23 | |||||||||||||
31480 | 31480 | Bruce Caputo C000137 | rep | NY | 1977-01-04 | 1979-01-03 | Republican | 23 | |||||||||||||
32791 | 32791 | Ronald Mottl M001044 | rep | OH | 1977-01-04 | 1979-01-03 | Democrat | 23 | |||||||||||||
33016 | 33016 | Abraham Kazen K000025 | rep | TX | 1977-01-04 | 1979-01-03 | Democrat | 23 | |||||||||||||
33711 | 33711 | Charles Price P000522 | rep | IL | 1977-01-04 | 1979-01-03 | Democrat | 23 | |||||||||||||
35683 | 35683 | Anthony Beilenson B000318 | rep | CA | 1977-01-04 | 1979-01-03 | Democrat | 23 | |||||||||||||
31582 | 31582 | Robert Gammage G000036 | rep | TX | 1977-01-04 | 1979-01-03 | Democrat | 22 | |||||||||||||
31799 | 31799 | George Shipley S000367 | rep | IL | 1977-01-04 | 1979-01-03 | Democrat | 22 | |||||||||||||
32387 | 32387 | Charles Vanik V000047 | rep | OH | 1977-01-04 | 1979-01-03 | Democrat | 22 | |||||||||||||
32482 | 32482 | Jonathan Bingham B000472 | rep | NY | 1977-01-04 | 1979-01-03 | Democrat | 22 | |||||||||||||
35448 | 35448 | Austin Murphy M001088 | rep | PA | 1977-01-04 | 1979-01-03 | Democrat | 22 | |||||||||||||
35935 | 35935 | Carlos Moorhead M000926 | rep | CA | 1977-01-04 | 1979-01-03 | Republican | 22 | |||||||||||||
31418 | 31418 | Herman Badillo B000025 | rep | NY | 1977-01-04 | 1979-01-03 | Democrat | 21 | |||||||||||||
31537 | 31537 | John Dent D000255 | rep | PA | 1977-01-04 | 1979-01-03 | Democrat | 21 | |||||||||||||
32008 | 32008 | James Corman C000780 | rep | CA | 1977-01-04 | 1979-01-03 | Democrat | 21 | |||||||||||||
33924 | 33924 | Robert Garcia G000047 | rep | NY | 1977-01-04 | 1979-01-03 | Democrat | 21 | |||||||||||||
34698 | 34698 | Edward Madigan M000041 | rep | IL | 1977-01-04 | 1979-01-03 | Republican | 21 | |||||||||||||
35352 | 35352 | Robert Krueger K000333 | rep | TX | 1977-01-04 | 1979-01-03 | Democrat | 21 | |||||||||||||
36402 | 36402 | Louis Stokes S000948 | rep | OH | 1977-01-04 | 1979-01-03 | Democrat | 21 | |||||||||||||
32651 | 32651 | Paul Findley F000123 | rep | IL | 1977-01-04 | 1979-01-03 | Republican | 20 | |||||||||||||
32687 | 32687 | Barry Goldwater G000268 | rep | CA | 1977-01-04 | 1979-01-03 | Republican | 20 | |||||||||||||
34475 | 34475 | Joseph Gaydos G000105 | rep | PA | 1977-01-04 | 1979-01-03 | Democrat | 20 | |||||||||||||
34802 | 34802 | Mary Oakar O000001 | rep | OH | 1977-01-04 | 1979-01-03 | Democrat | 20 | |||||||||||||
35049 | 35049 | Theodore Weiss W000258 | rep | NY | 1977-01-04 | 1979-01-03 | Democrat | 20 | |||||||||||||
36211 | 36211 | Henry González G000272 | rep | TX | 1977-01-04 | 1979-01-03 | Democrat | 20 | |||||||||||||
31485 | 31485 | Charles Carney C000164 | rep | OH | 1977-01-04 | 1979-01-03 | Democrat | 19 | |||||||||||||
31642 | 31642 | George Mahon M000065 | rep | TX | 1977-01-04 | 1979-01-03 | Democrat | 19 | |||||||||||||
32806 | 32806 | Thomas Railsback R000012 | rep | IL | 1977-01-04 | 1979-01-03 | Republican | 19 | |||||||||||||
34275 | 34275 | William Broomfield B000890 | rep | MI | 1977-01-04 | 1979-01-03 | Republican | 19 | |||||||||||||
34655 | 34655 | Robert Lagomarsino L000020 | rep | CA | 1977-01-04 | 1979-01-03 | Republican | 19 | |||||||||||||
36632 | 36632 | William Goodling G000291 | rep | PA | 1977-01-04 | 1979-01-03 | Republican | 19 | |||||||||||||
40441 | 40441 | Charles Rangel R000053 | rep | NY | 1977-01-04 | 1979-01-03 | Democrat | 19 | |||||||||||||
31599 | 31599 | Barbara Jordan J000266 | rep | TX | 1977-01-04 | 1979-01-03 | Democrat | 18 | |||||||||||||
31602 | 31602 | William Ketchum K000153 | rep | CA | 1977-01-04 | 1979-01-03 | Republican | 18 | |||||||||||||
31609 | 31609 | Edward Koch K000302 | rep | NY | 1977-01-04 | 1979-01-03 | Democrat | 18 | |||||||||||||
32486 | 32486 | James Blanchard B000538 | rep | MI | 1977-01-04 | 1979-01-03 | Democrat | 18 | |||||||||||||
34124 | 34124 | Douglas Walgren W000044 | rep | PA | 1977-01-04 | 1979-01-03 | Democrat | 18 | |||||||||||||
34496 | 34496 | Sedgwick Green G000417 | rep | NY | 1977-01-04 | 1979-01-03 | Republican | 18 | |||||||||||||
35099 | 35099 | Douglas Applegate A000214 | rep | OH | 1977-01-04 | 1979-01-03 | Democrat | 18 | |||||||||||||
35438 | 35438 | Robert Michel M000692 | rep | IL | 1977-01-04 | 1979-01-03 | Republican | 18 | |||||||||||||
31468 | 31468 | Omar Burleson B001111 | rep | TX | 1977-01-04 | 1979-01-03 | Democrat | 17 | |||||||||||||
31611 | 31611 | John Krebs K000325 | rep | CA | 1977-01-04 | 1979-01-03 | Democrat | 17 | |||||||||||||
32202 | 32202 | John Murphy M001098 | rep | NY | 1977-01-04 | 1979-01-03 | Democrat | 17 | |||||||||||||
32454 | 32454 | John Ashbrook A000221 | rep | OH | 1977-01-04 | 1979-01-03 | Republican | 17 | |||||||||||||
32520 | 32520 | William Brodhead B000862 | rep | MI | 1977-01-04 | 1979-01-03 | Democrat | 17 | |||||||||||||
32622 | 32622 | Allen Ertel E000208 | rep | PA | 1977-01-04 | 1979-01-03 | Democrat | 17 | |||||||||||||
33377 | 33377 | George O’Brien O000010 | rep | IL | 1977-01-04 | 1979-01-03 | Republican | 17 | |||||||||||||
31928 | 31928 | John Anderson A000195 | rep | IL | 1977-01-04 | 1979-01-03 | Republican | 16 | |||||||||||||
32112 | 32112 | Elizabeth Holtzman H000752 | rep | NY | 1977-01-04 | 1979-01-03 | Democrat | 16 | |||||||||||||
32887 | 32887 | Richard White W000390 | rep | TX | 1977-01-04 | 1979-01-03 | Democrat | 16 | |||||||||||||
35493 | 35493 | Leon Panetta P000047 | rep | CA | 1977-01-04 | 1979-01-03 | Democrat | 16 | |||||||||||||
36078 | 36078 | Robert Walker W000068 | rep | PA | 1977-01-04 | 1979-01-03 | Republican | 16 | |||||||||||||
38295 | 38295 | Ralph Regula R000141 | rep | OH | 1977-01-04 | 1979-01-03 | Republican | 16 | |||||||||||||
39810 | 39810 | John Dingell D000355 | rep | MI | 1977-01-04 | 1979-01-03 | Democrat | 16 | |||||||||||||
31776 | 31776 | Frederick Rooney R000423 | rep | PA | 1977-01-04 | 1979-01-03 | Democrat | 15 | |||||||||||||
31830 | 31830 | Bernice Sisk S000454 | rep | CA | 1977-01-04 | 1979-01-03 | Democrat | 15 | |||||||||||||
32230 | 32230 | Edward Patten P000106 | rep | NJ | 1977-01-04 | 1979-01-03 | Democrat | 15 | |||||||||||||
32891 | 32891 | Leo Zeferetti Z000002 | rep | NY | 1977-01-04 | 1979-01-03 | Democrat | 15 | |||||||||||||
32932 | 32932 | Thomas Corcoran C000773 | rep | IL | 1977-01-04 | 1979-01-03 | Republican | 15 | |||||||||||||
34453 | 34453 | Dante Fascell F000041 | rep | FL | 1977-01-04 | 1979-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);