legislator_terms
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
482 rows where "start" is on date 1981-01-05 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
32536 | 32536 | Clair Burgener B001080 | rep | CA | 1981-01-05 | 1983-01-03 | Republican | 43 | |||||||||||||
38115 | 38115 | Duncan Hunter H000981 | rep | CA | 1981-01-05 | 1983-01-03 | Republican | 42 | |||||||||||||
34689 | 34689 | William Lowery L000479 | rep | CA | 1981-01-05 | 1983-01-03 | Republican | 41 | |||||||||||||
33480 | 33480 | Robert Badham B000024 | rep | CA | 1981-01-05 | 1983-01-03 | Republican | 40 | |||||||||||||
33349 | 33349 | Stanley Lundine L000516 | rep | NY | 1981-01-05 | 1983-01-03 | Democrat | 39 | |||||||||||||
34356 | 34356 | William Dannemeyer D000044 | rep | CA | 1981-01-05 | 1983-01-03 | Republican | 39 | |||||||||||||
33085 | 33085 | Jerry Patterson P000121 | rep | CA | 1981-01-05 | 1983-01-03 | Democrat | 38 | |||||||||||||
33632 | 33632 | Jack Kemp K000086 | rep | NY | 1981-01-05 | 1983-01-03 | Republican | 38 | |||||||||||||
34791 | 34791 | Henry Nowak N000163 | rep | NY | 1981-01-05 | 1983-01-03 | Democrat | 37 | |||||||||||||
39384 | 39384 | Jerry Lewis L000274 | rep | CA | 1981-01-05 | 1983-01-03 | Republican | 37 | |||||||||||||
36530 | 36530 | George Brown B000918 | rep | CA | 1981-01-05 | 1983-01-03 | Democrat | 36 | |||||||||||||
36990 | 36990 | John LaFalce L000556 | rep | NY | 1981-01-05 | 1983-01-03 | Democrat | 36 | |||||||||||||
32930 | 32930 | Barber Conable C000666 | rep | NY | 1981-01-05 | 1983-01-03 | Republican | 35 | |||||||||||||
39253 | 39253 | David Dreier D000492 | rep | CA | 1981-01-05 | 1983-01-03 | Republican | 35 | |||||||||||||
34572 | 34572 | Frank Horton H000797 | rep | NY | 1981-01-05 | 1983-01-03 | Republican | 34 | |||||||||||||
39401 | 39401 | Daniel Lungren L000517 | rep | CA | 1981-01-05 | 1983-01-03 | Republican | 34 | |||||||||||||
32691 | 32691 | Wayne Grisham G000480 | rep | CA | 1981-01-05 | 1983-01-03 | Republican | 33 | |||||||||||||
32732 | 32732 | Gary Lee L000192 | rep | NY | 1981-01-05 | 1983-01-03 | Republican | 33 | |||||||||||||
33806 | 33806 | George Wortley W000752 | rep | NY | 1981-01-05 | 1983-01-03 | Republican | 32 | |||||||||||||
34180 | 34180 | Glenn Anderson A000189 | rep | CA | 1981-01-05 | 1983-01-03 | Democrat | 32 | |||||||||||||
32776 | 32776 | Donald Mitchell M000808 | rep | NY | 1981-01-05 | 1983-01-03 | Republican | 31 | |||||||||||||
34405 | 34405 | Mervyn Dymally D000592 | rep | CA | 1981-01-05 | 1983-01-03 | Democrat | 31 | |||||||||||||
32591 | 32591 | George Danielson D000043 | rep | CA | 1981-01-05 | 1983-01-03 | Democrat | 30 | |||||||||||||
34714 | 34714 | David Martin M000174 | rep | NY | 1981-01-05 | 1983-01-03 | Republican | 30 | |||||||||||||
36686 | 36686 | Matthew Martínez M000206 | rep | CA | 1981-01-05 | 1983-01-03 | Democrat | 30 | |||||||||||||
33942 | 33942 | Augustus Hawkins H000367 | rep | CA | 1981-01-05 | 1983-01-03 | Democrat | 29 | |||||||||||||
36389 | 36389 | Gerald Solomon S000675 | rep | NY | 1981-01-05 | 1983-01-03 | Republican | 29 | |||||||||||||
33773 | 33773 | Samuel Stratton S000997 | rep | NY | 1981-01-05 | 1983-01-03 | Democrat | 28 | |||||||||||||
36593 | 36593 | Julian Dixon D000373 | rep | CA | 1981-01-05 | 1983-01-03 | Democrat | 28 | |||||||||||||
34742 | 34742 | Matthew McHugh M000473 | rep | NY | 1981-01-05 | 1983-01-03 | Democrat | 27 | |||||||||||||
35774 | 35774 | Robert Dornan D000435 | rep | CA | 1981-01-05 | 1983-01-03 | Republican | 27 | |||||||||||||
32850 | 32850 | John Rousselot R000469 | rep | CA | 1981-01-05 | 1983-01-03 | Republican | 26 | |||||||||||||
36924 | 36924 | Benjamin Gilman G000212 | rep | NY | 1981-01-05 | 1983-01-03 | Republican | 26 | |||||||||||||
32458 | 32458 | Eugene Atkinson A000329 | rep | PA | 1981-01-05 | 1983-01-03 | Republican | 25 | |||||||||||||
34907 | 34907 | Edward Roybal R000485 | rep | CA | 1981-01-05 | 1983-01-03 | Democrat | 25 | |||||||||||||
35238 | 35238 | Hamilton Fish F000141 | rep | NY | 1981-01-05 | 1983-01-03 | Republican | 25 | |||||||||||||
32742 | 32742 | Marc Marks M000136 | rep | PA | 1981-01-05 | 1983-01-03 | Republican | 24 | |||||||||||||
33078 | 33078 | Richard Ottinger O000134 | rep | NY | 1981-01-05 | 1983-01-03 | Democrat | 24 | |||||||||||||
34959 | 34959 | Paul Simon S000423 | rep | IL | 1981-01-05 | 1983-01-03 | Democrat | 24 | |||||||||||||
37330 | 37330 | Jonas Frost F000392 | rep | TX | 1981-01-05 | 1983-01-03 | Democrat | 24 | |||||||||||||
40082 | 40082 | Henry Waxman W000215 | rep | CA | 1981-01-05 | 1983-01-03 | Democrat | 24 | |||||||||||||
32793 | 32793 | Ronald Mottl M001044 | rep | OH | 1981-01-05 | 1983-01-03 | Democrat | 23 | |||||||||||||
32800 | 32800 | Peter Peyser P000280 | rep | NY | 1981-01-05 | 1983-01-03 | Democrat | 23 | |||||||||||||
33018 | 33018 | Abraham Kazen K000025 | rep | TX | 1981-01-05 | 1983-01-03 | Democrat | 23 | |||||||||||||
33713 | 33713 | Charles Price P000522 | rep | IL | 1981-01-05 | 1983-01-03 | Democrat | 23 | |||||||||||||
35685 | 35685 | Anthony Beilenson B000318 | rep | CA | 1981-01-05 | 1983-01-03 | Democrat | 23 | |||||||||||||
35740 | 35740 | William Clinger C000523 | rep | PA | 1981-01-05 | 1983-01-03 | Republican | 23 | |||||||||||||
32484 | 32484 | Jonathan Bingham B000472 | rep | NY | 1981-01-05 | 1983-01-03 | Democrat | 22 | |||||||||||||
32941 | 32941 | Daniel Crane C000871 | rep | IL | 1981-01-05 | 1983-01-03 | Republican | 22 | |||||||||||||
34420 | 34420 | Dennis Eckart E000031 | rep | OH | 1981-01-05 | 1983-01-03 | Democrat | 22 | |||||||||||||
35450 | 35450 | Austin Murphy M001088 | rep | PA | 1981-01-05 | 1983-01-03 | Democrat | 22 | |||||||||||||
35937 | 35937 | Carlos Moorhead M000926 | rep | CA | 1981-01-05 | 1983-01-03 | Republican | 22 | |||||||||||||
39450 | 39450 | Ronald Paul P000583 | rep | TX | 1981-01-05 | 1983-01-03 | Republican | 22 | |||||||||||||
32465 | 32465 | Donald Bailey B000037 | rep | PA | 1981-01-05 | 1983-01-03 | Democrat | 21 | |||||||||||||
33265 | 33265 | Bobbi Fiedler F000102 | rep | CA | 1981-01-05 | 1983-01-03 | Republican | 21 | |||||||||||||
33334 | 33334 | Thomas Loeffler L000396 | rep | TX | 1981-01-05 | 1983-01-03 | Republican | 21 | |||||||||||||
33926 | 33926 | Robert Garcia G000047 | rep | NY | 1981-01-05 | 1983-01-03 | Democrat | 21 | |||||||||||||
34700 | 34700 | Edward Madigan M000041 | rep | IL | 1981-01-05 | 1983-01-03 | Republican | 21 | |||||||||||||
36404 | 36404 | Louis Stokes S000948 | rep | OH | 1981-01-05 | 1983-01-03 | Democrat | 21 | |||||||||||||
32653 | 32653 | Paul Findley F000123 | rep | IL | 1981-01-05 | 1983-01-03 | Republican | 20 | |||||||||||||
32689 | 32689 | Barry Goldwater G000268 | rep | CA | 1981-01-05 | 1983-01-03 | Republican | 20 | |||||||||||||
34477 | 34477 | Joseph Gaydos G000105 | rep | PA | 1981-01-05 | 1983-01-03 | Democrat | 20 | |||||||||||||
34804 | 34804 | Mary Oakar O000001 | rep | OH | 1981-01-05 | 1983-01-03 | Democrat | 20 | |||||||||||||
35051 | 35051 | Theodore Weiss W000258 | rep | NY | 1981-01-05 | 1983-01-03 | Democrat | 20 | |||||||||||||
36213 | 36213 | Henry González G000272 | rep | TX | 1981-01-05 | 1983-01-03 | Democrat | 20 | |||||||||||||
32808 | 32808 | Thomas Railsback R000012 | rep | IL | 1981-01-05 | 1983-01-03 | Republican | 19 | |||||||||||||
32983 | 32983 | Kent Hance H000144 | rep | TX | 1981-01-05 | 1983-01-03 | Democrat | 19 | |||||||||||||
33174 | 33174 | Lyle Williams W000528 | rep | OH | 1981-01-05 | 1983-01-03 | Republican | 19 | |||||||||||||
34277 | 34277 | William Broomfield B000890 | rep | MI | 1981-01-05 | 1983-01-03 | Republican | 19 | |||||||||||||
34657 | 34657 | Robert Lagomarsino L000020 | rep | CA | 1981-01-05 | 1983-01-03 | Republican | 19 | |||||||||||||
36634 | 36634 | William Goodling G000291 | rep | PA | 1981-01-05 | 1983-01-03 | Republican | 19 | |||||||||||||
40443 | 40443 | Charles Rangel R000053 | rep | NY | 1981-01-05 | 1983-01-03 | Democrat | 19 | |||||||||||||
32488 | 32488 | James Blanchard B000538 | rep | MI | 1981-01-05 | 1983-01-03 | Democrat | 18 | |||||||||||||
33981 | 33981 | George Leland L000237 | rep | TX | 1981-01-05 | 1983-01-03 | Democrat | 18 | |||||||||||||
34126 | 34126 | Douglas Walgren W000044 | rep | PA | 1981-01-05 | 1983-01-03 | Democrat | 18 | |||||||||||||
34498 | 34498 | Sedgwick Green G000417 | rep | NY | 1981-01-05 | 1983-01-03 | Republican | 18 | |||||||||||||
35101 | 35101 | Douglas Applegate A000214 | rep | OH | 1981-01-05 | 1983-01-03 | Democrat | 18 | |||||||||||||
35440 | 35440 | Robert Michel M000692 | rep | IL | 1981-01-05 | 1983-01-03 | Republican | 18 | |||||||||||||
37907 | 37907 | William Thomas T000188 | rep | CA | 1981-01-05 | 1983-01-03 | Republican | 18 | |||||||||||||
32445 | 32445 | Jean Ashbrook A000220 | rep | OH | 1981-01-05 | 1983-01-03 | Republican | 17 | |||||||||||||
32456 | 32456 | John Ashbrook A000221 | rep | OH | 1981-01-05 | 1983-01-03 | Republican | 17 | |||||||||||||
32522 | 32522 | William Brodhead B000862 | rep | MI | 1981-01-05 | 1983-01-03 | Democrat | 17 | |||||||||||||
32624 | 32624 | Allen Ertel E000208 | rep | PA | 1981-01-05 | 1983-01-03 | Democrat | 17 | |||||||||||||
33379 | 33379 | George O’Brien O000010 | rep | IL | 1981-01-05 | 1983-01-03 | Republican | 17 | |||||||||||||
34021 | 34021 | Guy Molinari M000842 | rep | NY | 1981-01-05 | 1983-01-03 | Republican | 17 | |||||||||||||
34041 | 34041 | Charles Pashayan P000097 | rep | CA | 1981-01-05 | 1983-01-03 | Republican | 17 | |||||||||||||
37468 | 37468 | Charles Stenholm S000851 | rep | TX | 1981-01-05 | 1983-01-03 | Democrat | 17 | |||||||||||||
32889 | 32889 | Richard White W000390 | rep | TX | 1981-01-05 | 1983-01-03 | Democrat | 16 | |||||||||||||
33998 | 33998 | Lynn Martin M000195 | rep | IL | 1981-01-05 | 1983-01-03 | Republican | 16 | |||||||||||||
35495 | 35495 | Leon Panetta P000047 | rep | CA | 1981-01-05 | 1983-01-03 | Democrat | 16 | |||||||||||||
36080 | 36080 | Robert Walker W000068 | rep | PA | 1981-01-05 | 1983-01-03 | Republican | 16 | |||||||||||||
38297 | 38297 | Ralph Regula R000141 | rep | OH | 1981-01-05 | 1983-01-03 | Republican | 16 | |||||||||||||
39812 | 39812 | John Dingell D000355 | rep | MI | 1981-01-05 | 1983-01-03 | Democrat | 16 | |||||||||||||
43286 | 43286 | Charles Schumer S000148 | rep | NY | 1981-01-05 | 1983-01-03 | Democrat | 16 | |||||||||||||
32893 | 32893 | Leo Zeferetti Z000002 | rep | NY | 1981-01-05 | 1983-01-03 | Democrat | 15 | |||||||||||||
32934 | 32934 | Thomas Corcoran C000773 | rep | IL | 1981-01-05 | 1983-01-03 | Republican | 15 | |||||||||||||
33856 | 33856 | Anthony Coelho C000581 | rep | CA | 1981-01-05 | 1983-01-03 | Democrat | 15 | |||||||||||||
34399 | 34399 | Bernard Dwyer D000586 | rep | NJ | 1981-01-05 | 1983-01-03 | Democrat | 15 | |||||||||||||
34455 | 34455 | Dante Fascell F000041 | rep | FL | 1981-01-05 | 1983-01-03 | Democrat | 15 | |||||||||||||
34880 | 34880 | Donald Ritter R000277 | rep | PA | 1981-01-05 | 1983-01-03 | Republican | 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);