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)
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
34949 | 34949 | Richard Schulze S000146 | rep | PA | 1991-01-03 | 1993-01-03 | Republican | 5 | |||||||||||||
34950 | 34950 | John Seymour S000269 | sen | CA | 1991-01-07 | 1993-01-03 | 1 | Republican | appointment | ||||||||||||
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 | |||||||||||||
35042 | 35042 | Guy Vander Jagt V000027 | rep | MI | 1991-01-03 | 1993-01-03 | Republican | 9 | |||||||||||||
35048 | 35048 | John Weber W000237 | rep | MN | 1991-01-03 | 1993-01-03 | Republican | 2 | |||||||||||||
35064 | 35064 | Howard Wolpe W000682 | rep | MI | 1991-01-03 | 1993-01-03 | Democrat | 3 | |||||||||||||
35077 | 35077 | Chalmers Wylie W000781 | rep | OH | 1991-01-03 | 1993-01-03 | Republican | 15 | |||||||||||||
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 | |||||||||||||
35127 | 35127 | Helen Bentley B000392 | rep | MD | 1991-01-03 | 1993-01-03 | Republican | 2 | |||||||||||||
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 | |||||||||||||
35172 | 35172 | Alfonse D’Amato D000018 | sen | NY | 1987-01-06 | 1993-01-03 | 3 | Republican | |||||||||||||
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 | |||||||||||||
35197 | 35197 | Robert Dole D000401 | sen | KS | 1987-01-06 | 1993-01-03 | 3 | Republican | |||||||||||||
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 | |||||||||||||
35243 | 35243 | Hamilton Fish F000141 | rep | NY | 1991-01-03 | 1993-01-03 | Republican | 21 | |||||||||||||
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 | |||||||||||||
35283 | 35283 | Dean Gallo G000025 | rep | NJ | 1991-01-03 | 1993-01-03 | Republican | 11 | |||||||||||||
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 | |||||||||||||
35307 | 35307 | Willis Gradison G000349 | rep | OH | 1991-01-03 | 1993-01-03 | Republican | 2 | |||||||||||||
35311 | 35311 | Frederick Grandy G000371 | rep | IA | 1991-01-03 | 1993-01-03 | Republican | 6 | |||||||||||||
35317 | 35317 | Paul Henry H000514 | rep | MI | 1991-01-03 | 1993-01-03 | Republican | 5 | |||||||||||||
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 | |||||||||||||
35358 | 35358 | H. Lancaster L000045 | rep | NC | 1991-01-03 | 1993-01-03 | Democrat | 3 | |||||||||||||
35364 | 35364 | Richard Lehman L000225 | rep | CA | 1991-01-03 | 1993-01-03 | Democrat | 18 | |||||||||||||
35371 | 35371 | Thomas Lewis L000295 | rep | FL | 1991-01-03 | 1993-01-03 | Republican | 12 | |||||||||||||
35381 | 35381 | Marilyn Lloyd L000381 | rep | TN | 1991-01-03 | 1993-01-03 | Democrat | 3 | |||||||||||||
35384 | 35384 | Jill Long Thompson L000420 | rep | IN | 1991-01-03 | 1993-01-03 | Democrat | 4 | |||||||||||||
35387 | 35387 | Ronald Machtley M000015 | rep | RI | 1991-01-03 | 1993-01-03 | Republican | 1 | |||||||||||||
35402 | 35402 | Romano Mazzoli M000291 | rep | KY | 1991-01-03 | 1993-01-03 | Democrat | 3 | |||||||||||||
35408 | 35408 | Alfred McCandless M000306 | rep | CA | 1991-01-03 | 1993-01-03 | Republican | 37 | |||||||||||||
35414 | 35414 | Francis McCloskey M000342 | rep | IN | 1991-01-03 | 1993-01-03 | Democrat | 8 | |||||||||||||
35421 | 35421 | David McCurdy M000398 | rep | OK | 1991-01-03 | 1993-01-03 | Democrat | 4 | |||||||||||||
35426 | 35426 | John McMillan M000566 | rep | NC | 1991-01-03 | 1993-01-03 | Republican | 9 | |||||||||||||
35445 | 35445 | Robert Michel M000692 | rep | IL | 1991-01-03 | 1993-01-03 | Republican | 18 | |||||||||||||
35455 | 35455 | Austin Murphy M001088 | rep | PA | 1991-01-03 | 1993-01-03 | Democrat | 22 | |||||||||||||
35476 | 35476 | William Natcher N000009 | rep | KY | 1991-01-03 | 1993-01-03 | Democrat | 2 | |||||||||||||
35486 | 35486 | Stephen Neal N000016 | rep | NC | 1991-01-03 | 1993-01-03 | Democrat | 5 | |||||||||||||
35491 | 35491 | Robert Packwood P000009 | sen | OR | 1987-01-06 | 1993-01-03 | 3 | Republican | |||||||||||||
35500 | 35500 | Leon Panetta P000047 | rep | CA | 1991-01-03 | 1993-01-03 | Democrat | 16 | |||||||||||||
35506 | 35506 | Timothy Penny P000215 | rep | MN | 1991-01-03 | 1993-01-03 | Democrat | 1 | |||||||||||||
35522 | 35522 | James Pickle P000328 | rep | TX | 1991-01-03 | 1993-01-03 | Democrat | 10 | |||||||||||||
35526 | 35526 | Arthur Ravenel R000072 | rep | SC | 1991-01-03 | 1993-01-03 | Republican | 1 | |||||||||||||
35532 | 35532 | Thomas Ridge R000243 | rep | PA | 1991-01-03 | 1993-01-03 | Republican | 21 | |||||||||||||
35550 | 35550 | Daniel Rostenkowski R000458 | rep | IL | 1991-01-03 | 1993-01-03 | Democrat | 8 | |||||||||||||
35556 | 35556 | James Rowland R000481 | rep | GA | 1991-01-03 | 1993-01-03 | Democrat | 8 | |||||||||||||
35559 | 35559 | George Sangmeister S000056 | rep | IL | 1991-01-03 | 1993-01-03 | Democrat | 4 | |||||||||||||
35562 | 35562 | William Sarpalius S000066 | rep | TX | 1991-01-03 | 1993-01-03 | Democrat | 13 | |||||||||||||
35573 | 35573 | Philip Sharp S000294 | rep | IN | 1991-01-03 | 1993-01-03 | Democrat | 2 | |||||||||||||
35580 | 35580 | James Slattery S000477 | rep | KS | 1991-01-03 | 1993-01-03 | Democrat | 2 | |||||||||||||
35598 | 35598 | Neal Smith S000596 | rep | IA | 1991-01-03 | 1993-01-03 | Democrat | 4 | |||||||||||||
35604 | 35604 | Donald Sundquist S001075 | rep | TN | 1991-01-03 | 1993-01-03 | Republican | 7 | |||||||||||||
35606 | 35606 | Richard Swett S001113 | rep | NH | 1991-01-03 | 1993-01-03 | Democrat | 2 | |||||||||||||
35614 | 35614 | Allan Swift S001115 | rep | WA | 1991-01-03 | 1993-01-03 | Democrat | 2 | |||||||||||||
35622 | 35622 | Michael Synar S001139 | rep | OK | 1991-01-03 | 1993-01-03 | Democrat | 2 | |||||||||||||
35625 | 35625 | Jolene Unsoeld U000017 | rep | WA | 1991-01-03 | 1993-01-03 | Democrat | 3 | |||||||||||||
35631 | 35631 | Itimous Valentine V000006 | rep | NC | 1991-01-03 | 1993-01-03 | Democrat | 2 | |||||||||||||
35634 | 35634 | Craig Washington W000177 | rep | TX | 1991-01-03 | 1993-01-03 | Democrat | 18 | |||||||||||||
35640 | 35640 | Alan Wheat W000326 | rep | MO | 1991-01-03 | 1993-01-03 | Democrat | 5 | |||||||||||||
35667 | 35667 | Jamie Whitten W000428 | rep | MS | 1991-01-03 | 1993-01-03 | Democrat | 1 | |||||||||||||
35677 | 35677 | Ron de Lugo D000209 | rep | VI | 1991-01-03 | 1993-01-03 | Democrat | 0 | |||||||||||||
35690 | 35690 | Anthony Beilenson B000318 | rep | CA | 1991-01-03 | 1993-01-03 | Democrat | 23 | |||||||||||||
35705 | 35705 | Tom Bevill B000431 | rep | AL | 1991-01-03 | 1993-01-03 | Democrat | 4 | |||||||||||||
35710 | 35710 | William Brewster B000817 | rep | OK | 1991-01-03 | 1993-01-03 | Democrat | 3 | |||||||||||||
35714 | 35714 | John Browder B000897 | rep | AL | 1991-01-03 | 1993-01-03 | Democrat | 3 | |||||||||||||
35723 | 35723 | John Bryant B000997 | rep | TX | 1991-01-03 | 1993-01-03 | Democrat | 5 | |||||||||||||
35735 | 35735 | Jim Chapman C000312 | rep | TX | 1991-01-03 | 1993-01-03 | Democrat | 1 | |||||||||||||
35745 | 35745 | William Clinger C000523 | rep | PA | 1991-01-03 | 1993-01-03 | Republican | 23 | |||||||||||||
35752 | 35752 | Ronald Coleman C000621 | rep | TX | 1991-01-03 | 1993-01-03 | Democrat | 16 | |||||||||||||
35755 | 35755 | Barbara-Rose Collins C000633 | rep | MI | 1991-01-03 | 1993-01-03 | Democrat | 13 | |||||||||||||
35767 | 35767 | Cardiss Collins C000634 | rep | IL | 1991-01-03 | 1993-01-03 | Democrat | 7 | |||||||||||||
35778 | 35778 | Robert Dornan D000435 | rep | CA | 1991-01-03 | 1993-01-03 | Republican | 38 | |||||||||||||
35786 | 35786 | Norvell Emerson E000174 | rep | MO | 1991-01-03 | 1993-01-03 | Republican | 8 | |||||||||||||
35796 | 35796 | Jack Fields F000111 | rep | TX | 1991-01-03 | 1993-01-03 | Republican | 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);