legislator_terms
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
475 rows where "end" is on date 1993-01-03
This data as json, copyable, CSV (advanced)
Suggested facets: type, party, start (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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
33456 | 33456 | James Sanford S000055 | sen | NC | 1987-01-06 | 1993-01-03 | 3 | Democrat | |||||||||||||
33477 | 33477 | Brockman Adams A000031 | sen | WA | 1987-01-06 | 1993-01-03 | 3 | Democrat | |||||||||||||
33542 | 33542 | Alan Cranston C000877 | sen | CA | 1987-01-06 | 1993-01-03 | 3 | Democrat | |||||||||||||
33561 | 33561 | Alan Dixon D000366 | sen | IL | 1987-01-06 | 1993-01-03 | 3 | Democrat | |||||||||||||
33583 | 33583 | Wyche Fowler F000329 | sen | GA | 1987-01-06 | 1993-01-03 | 3 | Democrat | |||||||||||||
33587 | 33587 | Edwin Garn G000072 | sen | UT | 1987-01-06 | 1993-01-03 | 3 | Republican | |||||||||||||
33626 | 33626 | Robert Kasten K000019 | sen | WI | 1987-01-06 | 1993-01-03 | 3 | Republican | |||||||||||||
33747 | 33747 | Warren Rudman R000497 | sen | NH | 1987-01-06 | 1993-01-03 | 3 | Republican | |||||||||||||
33790 | 33790 | Steven Symms S001138 | sen | ID | 1987-01-06 | 1993-01-03 | 3 | Republican | |||||||||||||
33805 | 33805 | Timothy Wirth W000647 | sen | CO | 1987-01-06 | 1993-01-03 | 3 | 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);