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 sorted by party
This data as json, copyable, CSV (advanced)
Suggested facets: state, party
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 | |||||||||||||
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 | |||||||||||||
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 | |||||||||||||
34324 | 34324 | Antonio Colorado C000646 | rep | PR | 1991-01-03 | 1993-01-03 | Democrat | 0 | |||||||||||||
34354 | 34354 | John Cox C000836 | rep | IL | 1991-01-03 | 1993-01-03 | Democrat | 16 | |||||||||||||
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 | |||||||||||||
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 | |||||||||||||
34510 | 34510 | Frank Guarini G000511 | rep | NJ | 1991-01-03 | 1993-01-03 | Democrat | 14 | |||||||||||||
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 | |||||||||||||
34562 | 34562 | Joan Horn H000788 | rep | MO | 1991-01-03 | 1993-01-03 | Democrat | 2 | |||||||||||||
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 | |||||||||||||
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 | |||||||||||||
34672 | 34672 | William Lehman L000226 | rep | FL | 1991-01-03 | 1993-01-03 | Democrat | 17 | |||||||||||||
34688 | 34688 | Meldon Levine L000264 | rep | CA | 1991-01-03 | 1993-01-03 | Democrat | 27 | |||||||||||||
34695 | 34695 | Charles Luken L000507 | rep | OH | 1991-01-03 | 1993-01-03 | Democrat | 1 | |||||||||||||
34726 | 34726 | Nicholas Mavroules M000264 | rep | MA | 1991-01-03 | 1993-01-03 | Democrat | 6 | |||||||||||||
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 | |||||||||||||
34772 | 34772 | Jim Moody M000881 | rep | WI | 1991-01-03 | 1993-01-03 | Democrat | 5 | |||||||||||||
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 | |||||||||||||
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 | |||||||||||||
34865 | 34865 | Richard Ray R000080 | rep | GA | 1991-01-03 | 1993-01-03 | Democrat | 3 | |||||||||||||
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 | |||||||||||||
34955 | 34955 | Gerald Sikorski S000407 | rep | MN | 1991-01-03 | 1993-01-03 | Democrat | 6 | |||||||||||||
34974 | 34974 | Lawrence Smith S000586 | rep | FL | 1991-01-03 | 1993-01-03 | Democrat | 16 | |||||||||||||
34983 | 34983 | Stephen Solarz S000673 | rep | NY | 1991-01-03 | 1993-01-03 | Democrat | 13 | |||||||||||||
34988 | 34988 | Harley Staggers S000779 | rep | WV | 1991-01-03 | 1993-01-03 | Democrat | 2 | |||||||||||||
34992 | 34992 | Richard Stallings S000785 | rep | ID | 1991-01-03 | 1993-01-03 | Democrat | 2 | |||||||||||||
34997 | 34997 | Robert Tallon T000034 | rep | SC | 1991-01-03 | 1993-01-03 | Democrat | 6 | |||||||||||||
35002 | 35002 | Robert Thomas T000184 | rep | GA | 1991-01-03 | 1993-01-03 | Democrat | 1 | |||||||||||||
35012 | 35012 | Jerome Traxler T000356 | rep | MI | 1991-01-03 | 1993-01-03 | Democrat | 8 | |||||||||||||
35064 | 35064 | Howard Wolpe W000682 | rep | MI | 1991-01-03 | 1993-01-03 | Democrat | 3 | |||||||||||||
35089 | 35089 | Gus Yatron Y000014 | rep | PA | 1991-01-03 | 1993-01-03 | Democrat | 6 | |||||||||||||
35095 | 35095 | Michael Andrews A000209 | rep | TX | 1991-01-03 | 1993-01-03 | Democrat | 25 | |||||||||||||
35097 | 35097 | Thomas Andrews A000211 | rep | ME | 1991-01-03 | 1993-01-03 | Democrat | 1 | |||||||||||||
35106 | 35106 | Douglas Applegate A000214 | rep | OH | 1991-01-03 | 1993-01-03 | Democrat | 18 | |||||||||||||
35118 | 35118 | Leslie Aspin A000224 | rep | WI | 1991-01-03 | 1993-01-03 | Democrat | 1 | |||||||||||||
35120 | 35120 | James Bacchus B000008 | rep | FL | 1991-01-03 | 1993-01-03 | Democrat | 11 | |||||||||||||
35131 | 35131 | James Bilbray B000462 | rep | NV | 1991-01-03 | 1993-01-03 | Democrat | 1 | |||||||||||||
35133 | 35133 | Lucien Blackwell B000517 | rep | PA | 1991-11-05 | 1993-01-03 | Democrat | 2 | |||||||||||||
35154 | 35154 | Jack Brooks B000880 | rep | TX | 1991-01-03 | 1993-01-03 | Democrat | 9 | |||||||||||||
35158 | 35158 | Dale Bumpers B001057 | sen | AR | 1987-01-06 | 1993-01-03 | 3 | Democrat | |||||||||||||
35168 | 35168 | Milton Carr C000178 | rep | MI | 1991-01-03 | 1993-01-03 | Democrat | 6 | |||||||||||||
35178 | 35178 | George Darden D000051 | rep | GA | 1991-01-03 | 1993-01-03 | Democrat | 7 | |||||||||||||
35188 | 35188 | Butler Derrick D000267 | rep | SC | 1991-01-03 | 1993-01-03 | Democrat | 3 | |||||||||||||
35213 | 35213 | William Edwards E000064 | rep | CA | 1991-01-03 | 1993-01-03 | Democrat | 10 | |||||||||||||
35223 | 35223 | Glenn English E000184 | rep | OK | 1991-01-03 | 1993-01-03 | Democrat | 6 | |||||||||||||
35228 | 35228 | Albert Espy E000218 | rep | MS | 1991-01-03 | 1993-01-03 | Democrat | 2 | |||||||||||||
35258 | 35258 | Thomas Foley F000239 | rep | WA | 1991-01-03 | 1993-01-03 | Democrat | 5 | |||||||||||||
35263 | 35263 | Wendell Ford F000268 | sen | KY | 1987-01-06 | 1993-01-03 | 3 | Democrat | |||||||||||||
35278 | 35278 | William Ford F000270 | rep | MI | 1991-01-03 | 1993-01-03 | Democrat | 15 | |||||||||||||
35288 | 35288 | John Glenn G000236 | sen | OH | 1987-01-06 | 1993-01-03 | 3 | Democrat | |||||||||||||
35297 | 35297 | Daniel Glickman G000240 | rep | KS | 1991-01-03 | 1993-01-03 | Democrat | 4 | |||||||||||||
35320 | 35320 | Peter Hoagland H000652 | rep | NE | 1991-01-03 | 1993-01-03 | Democrat | 2 | |||||||||||||
35324 | 35324 | George Hochbrueckner H000670 | rep | NY | 1991-01-03 | 1993-01-03 | Democrat | 1 | |||||||||||||
35335 | 35335 | William Hughes H000930 | rep | NJ | 1991-01-03 | 1993-01-03 | Democrat | 2 | |||||||||||||
35343 | 35343 | Earl Hutto H001018 | rep | FL | 1991-01-03 | 1993-01-03 | Democrat | 1 | |||||||||||||
35348 | 35348 | Michael Kopetski K000312 | rep | OR | 1991-01-03 | 1993-01-03 | Democrat | 5 | |||||||||||||
35354 | 35354 | Larry LaRocco L000098 | rep | ID | 1991-01-03 | 1993-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);