legislator_terms
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
11 rows where district = 0 and "start" is on date 1989-01-03
This data as json, copyable, CSV (advanced)
Suggested facets: state, end, 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
33851 | 33851 | Richard Cheney C000344 | rep | WY | 1989-01-03 | 1990-03-17 | Republican | 0 | |||||||||||||
33898 | 33898 | Walter Fauntroy F000046 | rep | DC | 1989-01-03 | 1991-01-03 | Democrat | 0 | |||||||||||||
34102 | 34102 | Peter Smith S000601 | rep | VT | 1989-01-03 | 1991-01-03 | Republican | 0 | |||||||||||||
34257 | 34257 | Ben Blaz B000551 | rep | GU | 1989-01-03 | 1991-01-03 | Republican | 0 | |||||||||||||
34468 | 34468 | Jaime Fuster F000435 | rep | PR | 1989-01-03 | 1991-01-03 | Democrat | 0 | |||||||||||||
35676 | 35676 | Ron de Lugo D000209 | rep | VI | 1989-01-03 | 1991-01-03 | Democrat | 0 | |||||||||||||
37616 | 37616 | Byron Dorgan D000432 | rep | ND | 1989-01-03 | 1991-01-03 | Democrat | 0 | |||||||||||||
38349 | 38349 | Craig Thomas T000162 | rep | WY | 1989-01-03 | 1991-01-03 | Republican | 0 | |||||||||||||
39829 | 39829 | Eni Faleomavaega F000010 | rep | AS | 1989-01-03 | 1991-01-03 | Democrat | 0 | |||||||||||||
41672 | 41672 | Don Young Y000033 | rep | AK | 1989-01-03 | 1991-01-03 | Republican | 0 | |||||||||||||
41761 | 41761 | Thomas Carper C000174 | rep | DE | 1989-01-03 | 1991-01-03 | Democrat | 0 |
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);