legislator_terms
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
37 rows where district = 3 and "start" is on date 1993-01-05
This data as json, copyable, CSV (advanced)
Suggested facets: end, 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
35189 | 35189 | Butler Derrick D000267 | rep | SC | 1993-01-05 | 1995-01-03 | Democrat | 3 | |||||||||||||
35318 | 35318 | Paul Henry H000514 | rep | MI | 1993-01-05 | 1993-07-31 | Republican | 3 | |||||||||||||
35359 | 35359 | H. Lancaster L000045 | rep | NC | 1993-01-05 | 1995-01-03 | Democrat | 3 | |||||||||||||
35382 | 35382 | Marilyn Lloyd L000381 | rep | TN | 1993-01-05 | 1995-01-03 | Democrat | 3 | |||||||||||||
35403 | 35403 | Romano Mazzoli M000291 | rep | KY | 1993-01-05 | 1995-01-03 | Democrat | 3 | |||||||||||||
35626 | 35626 | Jolene Unsoeld U000017 | rep | WA | 1993-01-05 | 1995-01-03 | Democrat | 3 | |||||||||||||
35708 | 35708 | Peter Blute B000576 | rep | MA | 1993-01-05 | 1995-01-03 | Republican | 3 | |||||||||||||
35711 | 35711 | William Brewster B000817 | rep | OK | 1993-01-05 | 1995-01-03 | Democrat | 3 | |||||||||||||
35715 | 35715 | John Browder B000897 | rep | AL | 1993-01-05 | 1995-01-03 | Democrat | 3 | |||||||||||||
35849 | 35849 | Steven Gunderson G000524 | rep | WI | 1993-01-05 | 1995-01-03 | Republican | 3 | |||||||||||||
35892 | 35892 | James Lightfoot L000305 | rep | IA | 1993-01-05 | 1995-01-03 | Republican | 3 | |||||||||||||
35905 | 35905 | Jan Meyers M000684 | rep | KS | 1993-01-05 | 1995-01-03 | Republican | 3 | |||||||||||||
35931 | 35931 | Gillespie Montgomery M000865 | rep | MS | 1993-01-05 | 1995-01-03 | Democrat | 3 | |||||||||||||
35965 | 35965 | William Orton O000108 | rep | UT | 1993-01-05 | 1995-01-03 | Democrat | 3 | |||||||||||||
36170 | 36170 | Victor Fazio F000053 | rep | CA | 1993-01-05 | 1995-01-03 | Democrat | 3 | |||||||||||||
36262 | 36262 | Tim Hutchinson H001015 | rep | AR | 1993-01-05 | 1995-01-03 | Republican | 3 | |||||||||||||
36345 | 36345 | William Richardson R000229 | rep | NM | 1993-01-05 | 1995-01-03 | Democrat | 3 | |||||||||||||
36488 | 36488 | Bill Barrett B000179 | rep | NE | 1993-01-05 | 1995-01-03 | Republican | 3 | |||||||||||||
36833 | 36833 | Robert Borski B000644 | rep | PA | 1993-01-05 | 1995-01-03 | Democrat | 3 | |||||||||||||
36943 | 36943 | Tony Hall H000074 | rep | OH | 1993-01-05 | 1995-01-03 | Democrat | 3 | |||||||||||||
37073 | 37073 | Timothy Roemer R000385 | rep | IN | 1993-01-05 | 1995-01-03 | Democrat | 3 | |||||||||||||
37178 | 37178 | Robert Stump S001044 | rep | AZ | 1993-01-05 | 1995-01-03 | Republican | 3 | |||||||||||||
37258 | 37258 | Michael Collins C000640 | rep | GA | 1993-01-05 | 1995-01-03 | Republican | 3 | |||||||||||||
37350 | 37350 | Richard Gephardt G000132 | rep | MO | 1993-01-05 | 1995-01-03 | Democrat | 3 | |||||||||||||
37405 | 37405 | William Lipinski L000342 | rep | IL | 1993-01-05 | 1995-01-03 | Democrat | 3 | |||||||||||||
37433 | 37433 | Scott McInnis M000477 | rep | CO | 1993-01-05 | 1995-01-03 | Republican | 3 | |||||||||||||
37498 | 37498 | William Tauzin T000058 | rep | LA | 1993-01-05 | 1995-01-03 | Democrat | 3 | |||||||||||||
38285 | 38285 | James Ramstad R000033 | rep | MN | 1993-01-05 | 1995-01-03 | Republican | 3 | |||||||||||||
38325 | 38325 | H. Saxton S000097 | rep | NJ | 1993-01-05 | 1995-01-03 | Republican | 3 | |||||||||||||
40035 | 40035 | Nick Rahall R000011 | rep | WV | 1993-01-05 | 1995-01-03 | Democrat | 3 | |||||||||||||
40255 | 40255 | Corrine Brown B000911 | rep | FL | 1993-01-05 | 1995-01-03 | Democrat | 3 | |||||||||||||
40883 | 40883 | Sam Johnson J000174 | rep | TX | 1993-01-05 | 1995-01-03 | Republican | 3 | |||||||||||||
41351 | 41351 | Peter King K000210 | rep | NY | 1993-01-05 | 1995-01-03 | Republican | 3 | |||||||||||||
41748 | 41748 | Benjamin Cardin C000141 | rep | MD | 1993-01-05 | 1995-01-03 | Democrat | 3 | |||||||||||||
42298 | 42298 | Rosa DeLauro D000216 | rep | CT | 1993-01-05 | 1995-01-03 | Democrat | 3 | |||||||||||||
43321 | 43321 | Robert Scott S000185 | rep | VA | 1993-01-05 | 1995-01-03 | Democrat | 3 | |||||||||||||
43636 | 43636 | Ron Wyden W000779 | rep | OR | 1993-01-05 | 1995-01-03 | Democrat | 3 |
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);