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 1991-01-03 sorted by end
This data as json, copyable, CSV (advanced)
Suggested facets: state, end, party, 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
34341 | 34341 | Silvio Conte C000709 | rep | MA | 1991-01-03 | 1991-02-08 | Republican | 1 | |||||||||||||
34705 | 34705 | Edward Madigan M000041 | rep | IL | 1991-01-03 | 1991-03-08 | Republican | 15 | |||||||||||||
34232 | 34232 | Harry Bartlett B000204 | rep | TX | 1991-01-03 | 1991-03-11 | Republican | 3 | |||||||||||||
35028 | 35028 | Morris Udall U000001 | rep | AZ | 1991-01-03 | 1991-05-04 | Democrat | 2 | |||||||||||||
34495 | 34495 | William Gray G000402 | rep | PA | 1991-01-03 | 1991-09-11 | Democrat | 2 | |||||||||||||
34969 | 34969 | Daniel Slaughter S000479 | rep | VA | 1991-01-03 | 1991-11-04 | Republican | 7 | |||||||||||||
35056 | 35056 | Theodore Weiss W000258 | rep | NY | 1991-01-03 | 1992-09-14 | Democrat | 17 | |||||||||||||
34633 | 34633 | Walter Jones J000256 | rep | NC | 1991-01-03 | 1992-09-15 | Democrat | 1 | |||||||||||||
37617 | 37617 | Byron Dorgan D000432 | rep | ND | 1991-01-03 | 1992-12-14 | Democrat | 0 | |||||||||||||
34488 | 34488 | Albert Gore G000321 | sen | TN | 1991-01-03 | 1993-01-02 | 2 | Democrat | |||||||||||||
34173 | 34173 | William Alexander A000103 | rep | AR | 1991-01-03 | 1993-01-03 | Democrat | 1 | |||||||||||||
34185 | 34185 | Glenn Anderson A000189 | rep | CA | 1991-01-03 | 1993-01-03 | Democrat | 32 | |||||||||||||
34199 | 34199 | Frank Annunzio A000212 | rep | IL | 1991-01-03 | 1993-01-03 | Democrat | 11 | |||||||||||||
34206 | 34206 | Beryl Anthony A000213 | rep | AR | 1991-01-03 | 1993-01-03 | Democrat | 4 | |||||||||||||
34210 | 34210 | Chester Atkins A000226 | rep | MA | 1991-01-03 | 1993-01-03 | Democrat | 5 | |||||||||||||
34219 | 34219 | Les AuCoin A000337 | rep | OR | 1991-01-03 | 1993-01-03 | Democrat | 1 | |||||||||||||
34227 | 34227 | Druie Barnard B000153 | rep | GA | 1991-01-03 | 1993-01-03 | Democrat | 10 | |||||||||||||
34254 | 34254 | Charles Bennett B000371 | rep | FL | 1991-01-03 | 1993-01-03 | Democrat | 3 | |||||||||||||
34258 | 34258 | Ben Blaz B000551 | rep | GU | 1991-01-03 | 1993-01-03 | Republican | 0 | |||||||||||||
34282 | 34282 | William Broomfield B000890 | rep | MI | 1991-01-03 | 1993-01-03 | Republican | 18 | |||||||||||||
34292 | 34292 | Terry Bruce B000971 | rep | IL | 1991-01-03 | 1993-01-03 | Democrat | 19 | |||||||||||||
34296 | 34296 | Albert Bustamante B001172 | rep | TX | 1991-01-03 | 1993-01-03 | Democrat | 23 | |||||||||||||
34303 | 34303 | Beverly Byron B001220 | rep | MD | 1991-01-03 | 1993-01-03 | Democrat | 6 | |||||||||||||
34308 | 34308 | Rodney Chandler C000293 | rep | WA | 1991-01-03 | 1993-01-03 | Republican | 8 | |||||||||||||
34323 | 34323 | Earl Coleman C000618 | rep | MO | 1991-01-03 | 1993-01-03 | Republican | 6 | |||||||||||||
34324 | 34324 | Antonio Colorado C000646 | rep | PR | 1991-01-03 | 1993-01-03 | Democrat | 0 | |||||||||||||
34353 | 34353 | Robert Coughlin C000807 | rep | PA | 1991-01-03 | 1993-01-03 | Republican | 13 | |||||||||||||
34354 | 34354 | John Cox C000836 | rep | IL | 1991-01-03 | 1993-01-03 | Democrat | 16 | |||||||||||||
34361 | 34361 | William Dannemeyer D000044 | rep | CA | 1991-01-03 | 1993-01-03 | Republican | 39 | |||||||||||||
34368 | 34368 | Robert Davis D000131 | rep | MI | 1991-01-03 | 1993-01-03 | Republican | 11 | |||||||||||||
34382 | 34382 | William Dickinson D000326 | rep | AL | 1991-01-03 | 1993-01-03 | Republican | 2 | |||||||||||||
34389 | 34389 | Brian Donnelly D000416 | rep | MA | 1991-01-03 | 1993-01-03 | Democrat | 11 | |||||||||||||
34398 | 34398 | Thomas Downey D000471 | rep | NY | 1991-01-03 | 1993-01-03 | Democrat | 2 | |||||||||||||
34404 | 34404 | Bernard Dwyer D000586 | rep | NJ | 1991-01-03 | 1993-01-03 | Democrat | 6 | |||||||||||||
34410 | 34410 | Mervyn Dymally D000592 | rep | CA | 1991-01-03 | 1993-01-03 | Democrat | 31 | |||||||||||||
34419 | 34419 | Joseph Early E000013 | rep | MA | 1991-01-03 | 1993-01-03 | Democrat | 3 | |||||||||||||
34425 | 34425 | Dennis Eckart E000031 | rep | OH | 1991-01-03 | 1993-01-03 | Democrat | 11 | |||||||||||||
34433 | 34433 | Marvin Edwards E000077 | rep | OK | 1991-01-03 | 1993-01-03 | Republican | 5 | |||||||||||||
34438 | 34438 | Ben Erdreich E000201 | rep | AL | 1991-01-03 | 1993-01-03 | Democrat | 6 | |||||||||||||
34460 | 34460 | Dante Fascell F000041 | rep | FL | 1991-01-03 | 1993-01-03 | Democrat | 19 | |||||||||||||
34465 | 34465 | Edward Feighan F000059 | rep | OH | 1991-01-03 | 1993-01-03 | Democrat | 19 | |||||||||||||
34469 | 34469 | Jaime Fuster F000435 | rep | PR | 1991-01-03 | 1993-01-03 | Democrat | 0 | |||||||||||||
34482 | 34482 | Joseph Gaydos G000105 | rep | PA | 1991-01-03 | 1993-01-03 | Democrat | 20 | |||||||||||||
34503 | 34503 | Sedgwick Green G000417 | rep | NY | 1991-01-03 | 1993-01-03 | Republican | 15 | |||||||||||||
34510 | 34510 | Frank Guarini G000511 | rep | NJ | 1991-01-03 | 1993-01-03 | Democrat | 14 | |||||||||||||
34523 | 34523 | John Hammerschmidt H000124 | rep | AR | 1991-01-03 | 1993-01-03 | Republican | 3 | |||||||||||||
34526 | 34526 | Claude Harris H000236 | rep | AL | 1991-01-03 | 1993-01-03 | Democrat | 7 | |||||||||||||
34532 | 34532 | Charles Hatcher H000340 | rep | GA | 1991-01-03 | 1993-01-03 | Democrat | 2 | |||||||||||||
34542 | 34542 | Charles Hayes H000388 | rep | IL | 1991-01-03 | 1993-01-03 | Democrat | 1 | |||||||||||||
34551 | 34551 | Dennis Hertel H000547 | rep | MI | 1991-01-03 | 1993-01-03 | Democrat | 14 | |||||||||||||
34554 | 34554 | Clyde Holloway H000729 | rep | LA | 1991-01-03 | 1993-01-03 | Republican | 8 | |||||||||||||
34561 | 34561 | Larry Hopkins H000776 | rep | KY | 1991-01-03 | 1993-01-03 | Republican | 6 | |||||||||||||
34562 | 34562 | Joan Horn H000788 | rep | MO | 1991-01-03 | 1993-01-03 | Democrat | 2 | |||||||||||||
34577 | 34577 | Frank Horton H000797 | rep | NY | 1991-01-03 | 1993-01-03 | Republican | 29 | |||||||||||||
34586 | 34586 | Carroll Hubbard H000878 | rep | KY | 1991-01-03 | 1993-01-03 | Democrat | 1 | |||||||||||||
34594 | 34594 | Thomas Huckaby H000901 | rep | LA | 1991-01-03 | 1993-01-03 | Democrat | 5 | |||||||||||||
34602 | 34602 | Andrew Ireland I000029 | rep | FL | 1991-01-03 | 1993-01-03 | Republican | 10 | |||||||||||||
34604 | 34604 | Craig James J000047 | rep | FL | 1991-01-03 | 1993-01-03 | Republican | 4 | |||||||||||||
34612 | 34612 | Edgar Jenkins J000083 | rep | GA | 1991-01-03 | 1993-01-03 | Democrat | 9 | |||||||||||||
34619 | 34619 | Ben Jones J000211 | rep | GA | 1991-01-03 | 1993-01-03 | Democrat | 4 | |||||||||||||
34636 | 34636 | James Jontz J000265 | rep | IN | 1991-01-03 | 1993-01-03 | Democrat | 5 | |||||||||||||
34645 | 34645 | Joseph Kolter K000307 | rep | PA | 1991-01-03 | 1993-01-03 | Democrat | 4 | |||||||||||||
34652 | 34652 | Peter Kostmayer K000319 | rep | PA | 1991-01-03 | 1993-01-03 | Democrat | 8 | |||||||||||||
34662 | 34662 | Robert Lagomarsino L000020 | rep | CA | 1991-01-03 | 1993-01-03 | Republican | 19 | |||||||||||||
34672 | 34672 | William Lehman L000226 | rep | FL | 1991-01-03 | 1993-01-03 | Democrat | 17 | |||||||||||||
34683 | 34683 | Norman Lent L000243 | rep | NY | 1991-01-03 | 1993-01-03 | Republican-Conservative | 4 | |||||||||||||
34688 | 34688 | Meldon Levine L000264 | rep | CA | 1991-01-03 | 1993-01-03 | Democrat | 27 | |||||||||||||
34694 | 34694 | William Lowery L000479 | rep | CA | 1991-01-03 | 1993-01-03 | Republican | 41 | |||||||||||||
34695 | 34695 | Charles Luken L000507 | rep | OH | 1991-01-03 | 1993-01-03 | Democrat | 1 | |||||||||||||
34713 | 34713 | Ronald Marlenee M000139 | rep | MT | 1991-01-03 | 1993-01-03 | Republican | 2 | |||||||||||||
34719 | 34719 | David Martin M000174 | rep | NY | 1991-01-03 | 1993-01-03 | Republican | 26 | |||||||||||||
34726 | 34726 | Nicholas Mavroules M000264 | rep | MA | 1991-01-03 | 1993-01-03 | Democrat | 6 | |||||||||||||
34732 | 34732 | Bob McEwen M000432 | rep | OH | 1991-01-03 | 1993-01-03 | Republican | 6 | |||||||||||||
34738 | 34738 | Raymond McGrath M000458 | rep | NY | 1991-01-03 | 1993-01-03 | Republican | 5 | |||||||||||||
34747 | 34747 | Matthew McHugh M000473 | rep | NY | 1991-01-03 | 1993-01-03 | Democrat | 28 | |||||||||||||
34750 | 34750 | Charles McMillen M000573 | rep | MD | 1991-01-03 | 1993-01-03 | Democrat | 4 | |||||||||||||
34763 | 34763 | Clarence Miller M000718 | rep | OH | 1991-01-03 | 1993-01-03 | Republican | 10 | |||||||||||||
34767 | 34767 | John Miller M000736 | rep | WA | 1991-01-03 | 1993-01-03 | Republican | 1 | |||||||||||||
34772 | 34772 | Jim Moody M000881 | rep | WI | 1991-01-03 | 1993-01-03 | Democrat | 5 | |||||||||||||
34778 | 34778 | Sidney Morrison M000999 | rep | WA | 1991-01-03 | 1993-01-03 | Republican | 4 | |||||||||||||
34783 | 34783 | Robert Mrazek M001057 | rep | NY | 1991-01-03 | 1993-01-03 | Democrat | 3 | |||||||||||||
34786 | 34786 | David Nagle N000003 | rep | IA | 1991-01-03 | 1993-01-03 | Democrat | 3 | |||||||||||||
34787 | 34787 | Richard Nichols N000094 | rep | KS | 1991-01-03 | 1993-01-03 | Republican | 5 | |||||||||||||
34796 | 34796 | Henry Nowak N000163 | rep | NY | 1991-01-03 | 1993-01-03 | Democrat | 33 | |||||||||||||
34809 | 34809 | Mary Oakar O000001 | rep | OH | 1991-01-03 | 1993-01-03 | Democrat | 20 | |||||||||||||
34814 | 34814 | James Olin O000069 | rep | VA | 1991-01-03 | 1993-01-03 | Democrat | 6 | |||||||||||||
34818 | 34818 | Douglas Owens O000156 | rep | UT | 1991-01-03 | 1993-01-03 | Democrat | 2 | |||||||||||||
34821 | 34821 | Elizabeth Patterson P000112 | rep | SC | 1991-01-03 | 1993-01-03 | Democrat | 4 | |||||||||||||
34829 | 34829 | Donald Pease P000170 | rep | OH | 1991-01-03 | 1993-01-03 | Democrat | 13 | |||||||||||||
34840 | 34840 | Carl Perkins P000229 | rep | KY | 1991-01-03 | 1993-01-03 | Democrat | 7 | |||||||||||||
34860 | 34860 | Carl Pursell P000574 | rep | MI | 1991-01-03 | 1993-01-03 | Republican | 2 | |||||||||||||
34865 | 34865 | Richard Ray R000080 | rep | GA | 1991-01-03 | 1993-01-03 | Democrat | 3 | |||||||||||||
34868 | 34868 | John Rhodes R000189 | rep | AZ | 1991-01-03 | 1993-01-03 | Republican | 1 | |||||||||||||
34878 | 34878 | Matthew Rinaldo R000262 | rep | NJ | 1991-01-03 | 1993-01-03 | Republican | 7 | |||||||||||||
34885 | 34885 | Donald Ritter R000277 | rep | PA | 1991-01-03 | 1993-01-03 | Republican | 15 | |||||||||||||
34897 | 34897 | Robert Roe R000383 | rep | NJ | 1991-01-03 | 1993-01-03 | Democrat | 8 | |||||||||||||
34912 | 34912 | Edward Roybal R000485 | rep | CA | 1991-01-03 | 1993-01-03 | Democrat | 25 | |||||||||||||
34921 | 34921 | Martin Russo R000543 | rep | IL | 1991-01-03 | 1993-01-03 | Democrat | 3 | |||||||||||||
34927 | 34927 | Gus Savage S000081 | rep | IL | 1991-01-03 | 1993-01-03 | Democrat | 2 | |||||||||||||
34940 | 34940 | James Scheuer S000124 | rep | NY | 1991-01-03 | 1993-01-03 | Democrat-Liberal | 8 |
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);