legislator_terms
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
479 rows where "end" is on date 1981-01-03
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
32509 | 32509 | David Bowen B000682 | rep | MS | 1979-01-15 | 1981-01-03 | Democrat | 2 | |||||||||||||
32517 | 32517 | Jack Brinkley B000839 | rep | GA | 1979-01-15 | 1981-01-03 | Democrat | 3 | |||||||||||||
32521 | 32521 | William Brodhead B000862 | rep | MI | 1979-01-15 | 1981-01-03 | Democrat | 17 | |||||||||||||
32530 | 32530 | Clarence Brown B000910 | rep | OH | 1979-01-15 | 1981-01-03 | Republican | 7 | |||||||||||||
32535 | 32535 | Clair Burgener B001080 | rep | CA | 1979-01-15 | 1981-01-03 | Republican | 43 | |||||||||||||
32540 | 32540 | John Burton B001153 | rep | CA | 1979-01-15 | 1981-01-03 | Democrat | 5 | |||||||||||||
32546 | 32546 | Manley Butler B001182 | rep | VA | 1979-01-15 | 1981-01-03 | Republican | 6 | |||||||||||||
32554 | 32554 | Shirley Chisholm C000371 | rep | NY | 1979-01-15 | 1981-01-03 | Democrat | 12 | |||||||||||||
32564 | 32564 | Donald Clausen C000475 | rep | CA | 1979-01-15 | 1981-01-03 | Republican | 2 | |||||||||||||
32572 | 32572 | James Collins C000638 | rep | TX | 1979-01-15 | 1981-01-03 | Republican | 3 | |||||||||||||
32578 | 32578 | William Cotter C000799 | rep | CT | 1979-01-15 | 1981-01-03 | Democrat | 1 | |||||||||||||
32584 | 32584 | Robert Daniel D000037 | rep | VA | 1979-01-15 | 1981-01-03 | Republican | 4 | |||||||||||||
32590 | 32590 | George Danielson D000043 | rep | CA | 1979-01-15 | 1981-01-03 | Democrat | 30 | |||||||||||||
32593 | 32593 | Huey Deckard D000183 | rep | IN | 1979-01-15 | 1981-01-03 | Republican | 8 | |||||||||||||
32606 | 32606 | Edward Derwinski D000269 | rep | IL | 1979-01-15 | 1981-01-03 | Republican | 4 | |||||||||||||
32608 | 32608 | Charles Dougherty D000446 | rep | PA | 1979-01-15 | 1981-01-03 | Republican | 4 | |||||||||||||
32613 | 32613 | Thomas Eagleton E000004 | sen | MO | 1975-01-14 | 1981-01-03 | 3 | Democrat | |||||||||||||
32618 | 32618 | David Emery E000175 | rep | ME | 1979-01-15 | 1981-01-03 | Republican | 1 | |||||||||||||
32620 | 32620 | Arlen Erdahl E000198 | rep | MN | 1979-01-15 | 1981-01-03 | Republican | 1 | |||||||||||||
32623 | 32623 | Allen Ertel E000208 | rep | PA | 1979-01-15 | 1981-01-03 | Democrat | 17 | |||||||||||||
32626 | 32626 | Billy Evans E000233 | rep | GA | 1979-01-15 | 1981-01-03 | Democrat | 8 | |||||||||||||
32630 | 32630 | David Evans E000239 | rep | IN | 1979-01-15 | 1981-01-03 | Democrat | 6 | |||||||||||||
32633 | 32633 | Thomas Evans E000258 | rep | DE | 1979-01-15 | 1981-01-03 | Republican | 0 | |||||||||||||
32637 | 32637 | John Fary F000040 | rep | IL | 1979-01-15 | 1981-01-03 | Democrat | 5 | |||||||||||||
32641 | 32641 | Millicent Fenwick F000078 | rep | NJ | 1979-01-15 | 1981-01-03 | Republican | 5 | |||||||||||||
32652 | 32652 | Paul Findley F000123 | rep | IL | 1979-01-15 | 1981-01-03 | Republican | 20 | |||||||||||||
32656 | 32656 | Floyd Fithian F000161 | rep | IN | 1979-01-15 | 1981-01-03 | Democrat | 2 | |||||||||||||
32671 | 32671 | Lawrence Fountain F000319 | rep | NC | 1979-01-15 | 1981-01-03 | Democrat | 2 | |||||||||||||
32676 | 32676 | Ronald Ginn G000226 | rep | GA | 1979-01-15 | 1981-01-03 | Democrat | 1 | |||||||||||||
32681 | 32681 | Barry Goldwater G000267 | sen | AZ | 1975-01-14 | 1981-01-03 | 3 | Republican | |||||||||||||
32688 | 32688 | Barry Goldwater G000268 | rep | CA | 1979-01-15 | 1981-01-03 | Republican | 20 | |||||||||||||
32690 | 32690 | Wayne Grisham G000480 | rep | CA | 1979-01-15 | 1981-01-03 | Republican | 33 | |||||||||||||
32695 | 32695 | Tennyson Guyer G000537 | rep | OH | 1979-01-15 | 1981-01-03 | Republican | 4 | |||||||||||||
32699 | 32699 | Thomas Hagedorn H000012 | rep | MN | 1979-01-15 | 1981-01-03 | Republican | 2 | |||||||||||||
32701 | 32701 | Gary Hart H000287 | sen | CO | 1975-01-14 | 1981-01-03 | 3 | Democrat | |||||||||||||
32710 | 32710 | Margaret Heckler H000440 | rep | MA | 1979-01-15 | 1981-01-03 | Republican | 10 | |||||||||||||
32712 | 32712 | Jon Hinson H000641 | rep | MS | 1979-01-15 | 1981-01-03 | Republican | 4 | |||||||||||||
32716 | 32716 | Kenneth Holland H000719 | rep | SC | 1979-01-15 | 1981-01-03 | Democrat | 5 | |||||||||||||
32719 | 32719 | Harold Hollenbeck H000722 | rep | NJ | 1979-01-15 | 1981-01-03 | Republican | 9 | |||||||||||||
32721 | 32721 | James Jeffries J000074 | rep | KS | 1979-01-15 | 1981-01-03 | Republican | 2 | |||||||||||||
32725 | 32725 | Paul Laxalt L000148 | sen | NV | 1975-01-14 | 1981-01-03 | 3 | Republican | |||||||||||||
32729 | 32729 | Raymond Lederer L000187 | rep | PA | 1979-01-15 | 1981-01-03 | Democrat | 3 | |||||||||||||
32731 | 32731 | Gary Lee L000192 | rep | NY | 1979-01-15 | 1981-01-03 | Republican | 33 | |||||||||||||
32738 | 32738 | Russell Long L000428 | sen | LA | 1975-01-14 | 1981-01-03 | 3 | Democrat | |||||||||||||
32741 | 32741 | Marc Marks M000136 | rep | PA | 1979-01-15 | 1981-01-03 | Republican | 24 | |||||||||||||
32748 | 32748 | Charles Mathias M000241 | sen | MD | 1975-01-14 | 1981-01-03 | 3 | Republican | |||||||||||||
32752 | 32752 | James Mattox M000260 | rep | TX | 1979-01-15 | 1981-01-03 | Democrat | 5 | |||||||||||||
32762 | 32762 | Robert McClory M000340 | rep | IL | 1979-01-15 | 1981-01-03 | Republican | 13 | |||||||||||||
32770 | 32770 | Paul McCloskey M000343 | rep | CA | 1979-01-15 | 1981-01-03 | Republican | 12 | |||||||||||||
32775 | 32775 | Donald Mitchell M000808 | rep | NY | 1979-01-15 | 1981-01-03 | Republican | 31 | |||||||||||||
32779 | 32779 | Anthony Moffett M000839 | rep | CT | 1979-01-15 | 1981-01-03 | Democrat | 6 | |||||||||||||
32788 | 32788 | Robert Mollohan M000845 | rep | WV | 1979-01-15 | 1981-01-03 | Democrat | 1 | |||||||||||||
32792 | 32792 | Ronald Mottl M001044 | rep | OH | 1979-01-15 | 1981-01-03 | Democrat | 23 | |||||||||||||
32799 | 32799 | Peter Peyser P000280 | rep | NY | 1979-01-15 | 1981-01-03 | Democrat | 23 | |||||||||||||
32807 | 32807 | Thomas Railsback R000012 | rep | IL | 1979-01-15 | 1981-01-03 | Republican | 19 | |||||||||||||
32821 | 32821 | Henry Reuss R000165 | rep | WI | 1979-01-15 | 1981-01-03 | Democrat | 5 | |||||||||||||
32836 | 32836 | John Rhodes R000188 | rep | AZ | 1979-01-15 | 1981-01-03 | Republican | 1 | |||||||||||||
32840 | 32840 | Frederick Richmond R000232 | rep | NY | 1979-01-15 | 1981-01-03 | Democrat | 14 | |||||||||||||
32849 | 32849 | John Rousselot R000469 | rep | CA | 1979-01-15 | 1981-01-03 | Republican | 26 | |||||||||||||
32853 | 32853 | James Santini S000058 | rep | NV | 1979-01-15 | 1981-01-03 | Democrat | 0 | |||||||||||||
32865 | 32865 | John Stanton S000804 | rep | OH | 1979-01-15 | 1981-01-03 | Republican | 11 | |||||||||||||
32869 | 32869 | David Stockman S000935 | rep | MI | 1979-01-15 | 1981-01-03 | Republican | 4 | |||||||||||||
32878 | 32878 | William Wampler W000121 | rep | VA | 1979-01-15 | 1981-01-03 | Republican | 9 | |||||||||||||
32888 | 32888 | Richard White W000390 | rep | TX | 1979-01-15 | 1981-01-03 | Democrat | 16 | |||||||||||||
32892 | 32892 | Leo Zeferetti Z000002 | rep | NY | 1979-01-15 | 1981-01-03 | Democrat | 15 | |||||||||||||
32895 | 32895 | Donald Albosta A000076 | rep | MI | 1979-01-15 | 1981-01-03 | Democrat | 10 | |||||||||||||
32901 | 32901 | Ike Andrews A000207 | rep | NC | 1979-01-15 | 1981-01-03 | Democrat | 4 | |||||||||||||
32904 | 32904 | Edwin Bethune B000422 | rep | AR | 1979-01-15 | 1981-01-03 | Republican | 2 | |||||||||||||
32916 | 32916 | Phillip Burton B001156 | rep | CA | 1979-01-15 | 1981-01-03 | Democrat | 6 | |||||||||||||
32929 | 32929 | Barber Conable C000666 | rep | NY | 1979-01-15 | 1981-01-03 | Republican | 35 | |||||||||||||
32933 | 32933 | Thomas Corcoran C000773 | rep | IL | 1979-01-15 | 1981-01-03 | Republican | 15 | |||||||||||||
32937 | 32937 | Baltasar Corrada-del Río C000788 | rep | PR | 1979-01-15 | 1981-01-03 | New Progressive | 0 | |||||||||||||
32940 | 32940 | Daniel Crane C000871 | rep | IL | 1979-01-15 | 1981-01-03 | Republican | 22 | |||||||||||||
32945 | 32945 | Norman D’Amours D000017 | rep | NH | 1979-01-15 | 1981-01-03 | Democrat | 1 | |||||||||||||
32955 | 32955 | William Edwards E000084 | rep | AL | 1979-01-15 | 1981-01-03 | Republican | 1 | |||||||||||||
32965 | 32965 | John Erlenborn E000204 | rep | IL | 1979-01-15 | 1981-01-03 | Republican | 14 | |||||||||||||
32969 | 32969 | Geraldine Ferraro F000088 | rep | NY | 1979-01-15 | 1981-01-03 | Democrat | 9 | |||||||||||||
32977 | 32977 | Edwin Forsythe F000286 | rep | NJ | 1979-01-15 | 1981-01-03 | Republican | 6 | |||||||||||||
32982 | 32982 | Kent Hance H000144 | rep | TX | 1979-01-15 | 1981-01-03 | Democrat | 19 | |||||||||||||
32989 | 32989 | George Hansen H000171 | rep | ID | 1979-01-15 | 1981-01-03 | Republican | 2 | |||||||||||||
32996 | 32996 | Jack Hightower H000582 | rep | TX | 1979-01-15 | 1981-01-03 | Democrat | 13 | |||||||||||||
33017 | 33017 | Abraham Kazen K000025 | rep | TX | 1979-01-15 | 1981-01-03 | Democrat | 23 | |||||||||||||
33020 | 33020 | Raymond Kogovsek K000304 | rep | CO | 1979-01-15 | 1981-01-03 | Democrat | 3 | |||||||||||||
33025 | 33025 | Elliott Levitas L000265 | rep | GA | 1979-01-15 | 1981-01-03 | Democrat | 4 | |||||||||||||
33036 | 33036 | Clarence Long L000413 | rep | MD | 1979-01-15 | 1981-01-03 | Democrat | 2 | |||||||||||||
33040 | 33040 | David Marriott M000143 | rep | UT | 1979-01-15 | 1981-01-03 | Republican | 2 | |||||||||||||
33046 | 33046 | James Martin M000183 | rep | NC | 1979-01-15 | 1981-01-03 | Republican | 9 | |||||||||||||
33051 | 33051 | Lawrence McDonald M000413 | rep | GA | 1979-01-15 | 1981-01-03 | Democrat | 7 | |||||||||||||
33069 | 33069 | Joseph Minish M000796 | rep | NJ | 1979-01-15 | 1981-01-03 | Democrat | 11 | |||||||||||||
33077 | 33077 | Richard Ottinger O000134 | rep | NY | 1979-01-15 | 1981-01-03 | Democrat | 24 | |||||||||||||
33084 | 33084 | Jerry Patterson P000121 | rep | CA | 1979-01-15 | 1981-01-03 | Democrat | 38 | |||||||||||||
33102 | 33102 | Carl Perkins P000230 | rep | KY | 1979-01-15 | 1981-01-03 | Democrat | 7 | |||||||||||||
33108 | 33108 | Joel Pritchard P000546 | rep | WA | 1979-01-15 | 1981-01-03 | Republican | 1 | |||||||||||||
33117 | 33117 | William Ratchford R000067 | rep | CT | 1979-01-15 | 1981-01-03 | Democrat | 5 | |||||||||||||
33124 | 33124 | James Robinson R000337 | rep | VA | 1979-01-15 | 1981-01-03 | Republican | 7 | |||||||||||||
33136 | 33136 | Benjamin Rosenthal R000442 | rep | NY | 1979-01-15 | 1981-01-03 | Democrat | 8 | |||||||||||||
33140 | 33140 | Harold Sawyer S000087 | rep | MI | 1979-01-15 | 1981-01-03 | Republican | 5 | |||||||||||||
33143 | 33143 | James Shannon S000286 | rep | MA | 1979-01-15 | 1981-01-03 | Democrat | 5 | |||||||||||||
33163 | 33163 | Paul Trible T000367 | rep | VA | 1979-01-15 | 1981-01-03 | Republican | 1 | |||||||||||||
33173 | 33173 | Lyle Williams W000528 | rep | OH | 1979-01-15 | 1981-01-03 | Republican | 19 |
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);