legislator_terms
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
297 rows where party = "Democrat" and "start" is on date 1983-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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
32897 | 32897 | Donald Albosta A000076 | rep | MI | 1983-01-03 | 1985-01-03 | Democrat | 10 | |||||||||||||
32903 | 32903 | Ike Andrews A000207 | rep | NC | 1983-01-03 | 1985-01-03 | Democrat | 4 | |||||||||||||
32907 | 32907 | Charles Britt B000845 | rep | NC | 1983-01-03 | 1985-01-03 | Democrat | 6 | |||||||||||||
32918 | 32918 | Phillip Burton B001156 | rep | CA | 1983-01-03 | 1983-04-10 | Democrat | 5 | |||||||||||||
32921 | 32921 | Lawton Chiles C000356 | sen | FL | 1983-01-03 | 1989-01-03 | 1 | Democrat | |||||||||||||
32947 | 32947 | Norman D’Amours D000017 | rep | NH | 1983-01-03 | 1985-01-03 | Democrat | 1 | |||||||||||||
32971 | 32971 | Geraldine Ferraro F000088 | rep | NY | 1983-01-03 | 1985-01-03 | Democrat | 9 | |||||||||||||
32981 | 32981 | Katie Hall H000058 | rep | IN | 1983-01-03 | 1985-01-03 | Democrat | 1 | |||||||||||||
32984 | 32984 | Kent Hance H000144 | rep | TX | 1983-01-03 | 1985-01-03 | Democrat | 19 | |||||||||||||
32992 | 32992 | Frank Harrison H000269 | rep | PA | 1983-01-03 | 1985-01-03 | Democrat | 11 | |||||||||||||
32998 | 32998 | Jack Hightower H000582 | rep | TX | 1983-01-03 | 1985-01-03 | Democrat | 13 | |||||||||||||
33010 | 33010 | Henry Jackson J000013 | sen | WA | 1983-01-03 | 1983-09-01 | 1 | Democrat | |||||||||||||
33019 | 33019 | Abraham Kazen K000025 | rep | TX | 1983-01-03 | 1985-01-03 | Democrat | 23 | |||||||||||||
33022 | 33022 | Raymond Kogovsek K000304 | rep | CO | 1983-01-03 | 1985-01-03 | Democrat | 3 | |||||||||||||
33027 | 33027 | Elliott Levitas L000265 | rep | GA | 1983-01-03 | 1985-01-03 | Democrat | 4 | |||||||||||||
33038 | 33038 | Clarence Long L000413 | rep | MD | 1983-01-03 | 1985-01-03 | Democrat | 2 | |||||||||||||
33053 | 33053 | Lawrence McDonald M000413 | rep | GA | 1983-01-03 | 1985-01-03 | Democrat | 7 | |||||||||||||
33054 | 33054 | James McNulty M000589 | rep | AZ | 1983-01-03 | 1985-01-03 | Democrat | 5 | |||||||||||||
33060 | 33060 | John Melcher M000635 | sen | MT | 1983-01-03 | 1989-01-03 | 1 | Democrat | |||||||||||||
33071 | 33071 | Joseph Minish M000796 | rep | NJ | 1983-01-03 | 1985-01-03 | Democrat | 11 | |||||||||||||
33079 | 33079 | Richard Ottinger O000134 | rep | NY | 1983-01-03 | 1985-01-03 | Democrat | 20 | |||||||||||||
33081 | 33081 | William Patman P000104 | rep | TX | 1983-01-03 | 1985-01-03 | Democrat | 14 | |||||||||||||
33086 | 33086 | Jerry Patterson P000121 | rep | CA | 1983-01-03 | 1985-01-03 | Democrat | 38 | |||||||||||||
33104 | 33104 | Carl Perkins P000230 | rep | KY | 1983-01-03 | 1985-01-03 | Democrat | 7 | |||||||||||||
33116 | 33116 | William Proxmire P000553 | sen | WI | 1983-01-03 | 1989-01-03 | 1 | Democrat | |||||||||||||
33119 | 33119 | William Ratchford R000067 | rep | CT | 1983-01-03 | 1985-01-03 | Democrat | 5 | |||||||||||||
33138 | 33138 | Benjamin Rosenthal R000442 | rep | NY | 1983-01-03 | 1985-01-03 | Democrat | 7 | |||||||||||||
33145 | 33145 | James Shannon S000286 | rep | MA | 1983-01-03 | 1985-01-03 | Democrat | 5 | |||||||||||||
33161 | 33161 | John Stennis S000852 | sen | MS | 1983-01-03 | 1989-01-03 | 1 | Democrat | |||||||||||||
33166 | 33166 | Tommy Vandergriff V000026 | rep | TX | 1983-01-03 | 1985-01-03 | Democrat | 26 | |||||||||||||
33168 | 33168 | Harold Washington W000180 | rep | IL | 1983-01-03 | 1985-01-03 | Democrat | 1 | |||||||||||||
33190 | 33190 | Antonio Won Pat W000686 | rep | GU | 1983-01-03 | 1985-01-03 | Democrat | 0 | |||||||||||||
33208 | 33208 | Clement Zablocki Z000001 | rep | WI | 1983-01-03 | 1983-12-03 | Democrat | 4 | |||||||||||||
33211 | 33211 | Edward Zorinsky Z000013 | sen | NE | 1983-01-03 | 1987-12-31 | 1 | Democrat | |||||||||||||
33223 | 33223 | Joseph Addabbo A000052 | rep | NY | 1983-01-03 | 1985-01-03 | Democrat | 6 | |||||||||||||
33232 | 33232 | Michael Barnes B000160 | rep | MD | 1983-01-03 | 1985-01-03 | Democrat | 8 | |||||||||||||
33238 | 33238 | Berkley Bedell B000298 | rep | IA | 1983-01-03 | 1985-01-03 | Democrat | 6 | |||||||||||||
33260 | 33260 | Robert Edgar E000043 | rep | PA | 1983-01-03 | 1985-01-03 | Democrat | 7 | |||||||||||||
33280 | 33280 | Don Fuqua F000430 | rep | FL | 1983-01-03 | 1985-01-03 | Democrat | 2 | |||||||||||||
33287 | 33287 | Sam Hall H000070 | rep | TX | 1983-01-03 | 1985-01-03 | Democrat | 1 | |||||||||||||
33295 | 33295 | Cecil Heftel H000449 | rep | HI | 1983-01-03 | 1985-01-03 | Democrat | 1 | |||||||||||||
33321 | 33321 | James Jones J000232 | rep | OK | 1983-01-03 | 1985-01-03 | Democrat | 1 | |||||||||||||
33344 | 33344 | Gillis Long L000417 | rep | LA | 1983-01-03 | 1985-01-03 | Democrat | 8 | |||||||||||||
33350 | 33350 | Stanley Lundine L000516 | rep | NY | 1983-01-03 | 1985-01-03 | Democrat | 34 | |||||||||||||
33366 | 33366 | Parren Mitchell M000826 | rep | MD | 1983-01-03 | 1985-01-03 | Democrat | 7 | |||||||||||||
33397 | 33397 | Thomas O’Neill O000098 | rep | MA | 1983-01-03 | 1985-01-03 | Democrat | 8 | |||||||||||||
33410 | 33410 | John Seiberling S000230 | rep | OH | 1983-01-03 | 1985-01-03 | Democrat | 14 | |||||||||||||
33432 | 33432 | James Weaver W000227 | rep | OR | 1983-01-03 | 1985-01-03 | Democrat | 4 | |||||||||||||
33446 | 33446 | Charles Whitley W000419 | rep | NC | 1983-01-03 | 1985-01-03 | Democrat | 3 | |||||||||||||
33451 | 33451 | Robert Young Y000051 | rep | MO | 1983-01-03 | 1985-01-03 | Democrat | 2 | |||||||||||||
33491 | 33491 | Mario Biaggi B000432 | rep | NY | 1983-01-03 | 1985-01-03 | Democrat | 19 | |||||||||||||
33509 | 33509 | Edward Boland B000600 | rep | MA | 1983-01-03 | 1985-01-03 | Democrat | 2 | |||||||||||||
33514 | 33514 | William Boner B000615 | rep | TN | 1983-01-03 | 1985-01-03 | Democrat | 5 | |||||||||||||
33521 | 33521 | Don Bonker B000620 | rep | WA | 1983-01-03 | 1985-01-03 | Democrat | 3 | |||||||||||||
33536 | 33536 | William Chappell C000321 | rep | FL | 1983-01-03 | 1985-01-03 | Democrat | 4 | |||||||||||||
33550 | 33550 | Wilbur Daniel D000038 | rep | VA | 1983-01-03 | 1985-01-03 | Democrat | 5 | |||||||||||||
33563 | 33563 | Charles Dowdy D000466 | rep | MS | 1983-01-03 | 1985-01-03 | Democrat | 4 | |||||||||||||
33581 | 33581 | Wyche Fowler F000329 | rep | GA | 1983-01-03 | 1985-01-03 | Democrat | 5 | |||||||||||||
33609 | 33609 | James Howard H000840 | rep | NJ | 1983-01-03 | 1985-01-03 | Democrat | 3 | |||||||||||||
33619 | 33619 | Ed Jones J000216 | rep | TN | 1983-01-03 | 1985-01-03 | Democrat | 8 | |||||||||||||
33654 | 33654 | Michael Lowry L000486 | rep | WA | 1983-01-03 | 1985-01-03 | Democrat | 7 | |||||||||||||
33667 | 33667 | Kenneth MacKay M000023 | rep | FL | 1983-01-03 | 1985-01-03 | Democrat | 6 | |||||||||||||
33681 | 33681 | Daniel Mica M000688 | rep | FL | 1983-01-03 | 1985-01-03 | Democrat | 14 | |||||||||||||
33692 | 33692 | William Nichols N000095 | rep | AL | 1983-01-03 | 1985-01-03 | Democrat | 3 | |||||||||||||
33714 | 33714 | Charles Price P000522 | rep | IL | 1983-01-03 | 1985-01-03 | Democrat | 21 | |||||||||||||
33738 | 33738 | Peter Rodino R000374 | rep | NJ | 1983-01-03 | 1985-01-03 | Democrat | 10 | |||||||||||||
33742 | 33742 | Charles Roemer R000384 | rep | LA | 1983-01-03 | 1985-01-03 | Democrat | 4 | |||||||||||||
33759 | 33759 | Fernand St. Germain S000762 | rep | RI | 1983-01-03 | 1985-01-03 | Democrat | 1 | |||||||||||||
33774 | 33774 | Samuel Stratton S000997 | rep | NY | 1983-01-03 | 1985-01-03 | Democrat | 23 | |||||||||||||
33778 | 33778 | Fofó Sunia S001077 | rep | AS | 1983-01-03 | 1985-01-03 | Democrat | 0 | |||||||||||||
33803 | 33803 | Timothy Wirth W000647 | rep | CO | 1983-01-03 | 1985-01-03 | Democrat | 2 | |||||||||||||
33810 | 33810 | Jim Bates B000236 | rep | CA | 1983-01-03 | 1985-01-03 | Democrat | 44 | |||||||||||||
33820 | 33820 | Lloyd Bentsen B000401 | sen | TX | 1983-01-03 | 1989-01-03 | 1 | Democrat | |||||||||||||
33827 | 33827 | Corinne Boggs B000592 | rep | LA | 1983-01-03 | 1985-01-03 | Democrat | 2 | |||||||||||||
33831 | 33831 | Douglas Bosco B000648 | rep | CA | 1983-01-03 | 1985-01-03 | Democrat | 1 | |||||||||||||
33844 | 33844 | Quentin Burdick B001077 | sen | ND | 1983-01-03 | 1989-01-03 | 1 | Democrat | |||||||||||||
33852 | 33852 | James Clarke C000462 | rep | NC | 1983-01-03 | 1985-01-03 | Democrat | 11 | |||||||||||||
33857 | 33857 | Anthony Coelho C000581 | rep | CA | 1983-01-03 | 1985-01-03 | Democrat | 15 | |||||||||||||
33869 | 33869 | George Crockett C000919 | rep | MI | 1983-01-03 | 1985-01-03 | Democrat | 13 | |||||||||||||
33878 | 33878 | Dennis DeConcini D000185 | sen | AZ | 1983-01-03 | 1989-01-03 | 1 | Democrat | |||||||||||||
33885 | 33885 | Royden Dyson D000593 | rep | MD | 1983-01-03 | 1985-01-03 | Democrat | 1 | |||||||||||||
33895 | 33895 | Walter Fauntroy F000046 | rep | DC | 1983-01-03 | 1985-01-03 | Democrat | 0 | |||||||||||||
33902 | 33902 | Ronnie Flippo F000208 | rep | AL | 1983-01-03 | 1985-01-03 | Democrat | 5 | |||||||||||||
33910 | 33910 | James Florio F000215 | rep | NJ | 1983-01-03 | 1985-01-03 | Democrat | 1 | |||||||||||||
33927 | 33927 | Robert Garcia G000047 | rep | NY | 1983-01-03 | 1985-01-03 | Democrat | 18 | |||||||||||||
33943 | 33943 | Augustus Hawkins H000367 | rep | CA | 1983-01-03 | 1985-01-03 | Democrat | 29 | |||||||||||||
33970 | 33970 | Robert Kastenmeier K000020 | rep | WI | 1983-01-03 | 1985-01-03 | Democrat | 2 | |||||||||||||
33976 | 33976 | James Leath L000180 | rep | TX | 1983-01-03 | 1985-01-03 | Democrat | 11 | |||||||||||||
33982 | 33982 | George Leland L000237 | rep | TX | 1983-01-03 | 1985-01-03 | Democrat | 18 | |||||||||||||
33990 | 33990 | Thomas Luken L000508 | rep | OH | 1983-01-03 | 1985-01-03 | Democrat | 1 | |||||||||||||
34011 | 34011 | Spark Matsunaga M000250 | sen | HI | 1983-01-03 | 1989-01-03 | 1 | Democrat | |||||||||||||
34016 | 34016 | Howard Metzenbaum M000678 | sen | OH | 1983-01-03 | 1989-01-03 | 1 | Democrat | |||||||||||||
34019 | 34019 | George Mitchell M000811 | sen | ME | 1983-01-03 | 1989-01-03 | 1 | Democrat | |||||||||||||
34026 | 34026 | Bruce Morrison M000992 | rep | CT | 1983-01-03 | 1985-01-03 | Democrat | 3 | |||||||||||||
34059 | 34059 | Claude Pepper P000218 | rep | FL | 1983-01-03 | 1985-01-03 | Democrat | 18 | |||||||||||||
34069 | 34069 | Donald Riegle R000249 | sen | MI | 1983-01-03 | 1989-01-03 | 1 | Democrat | |||||||||||||
34080 | 34080 | James Sasser S000068 | sen | TN | 1983-01-03 | 1989-01-03 | 1 | Democrat | |||||||||||||
34127 | 34127 | Douglas Walgren W000044 | rep | PA | 1983-01-03 | 1985-01-03 | Democrat | 18 | |||||||||||||
34156 | 34156 | James Wright W000763 | rep | TX | 1983-01-03 | 1985-01-03 | Democrat | 12 | |||||||||||||
34169 | 34169 | William Alexander A000103 | rep | AR | 1983-01-03 | 1985-01-03 | Democrat | 1 |
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);