legislator_terms
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
21 rows where district = 8 and "start" is on date 1989-01-03
This data as json, copyable, CSV (advanced)
Suggested facets: 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
33997 | 33997 | Donald Lukens L000509 | rep | OH | 1989-01-03 | 1991-01-03 | Republican | 8 | |||||||||||||
34039 | 34039 | Stanford Parris P000080 | rep | VA | 1989-01-03 | 1991-01-03 | Republican | 8 | |||||||||||||
34307 | 34307 | Rodney Chandler C000293 | rep | WA | 1989-01-03 | 1991-01-03 | Republican | 8 | |||||||||||||
34553 | 34553 | Clyde Holloway H000729 | rep | LA | 1989-01-03 | 1991-01-03 | Republican | 8 | |||||||||||||
34651 | 34651 | Peter Kostmayer K000319 | rep | PA | 1989-01-03 | 1991-01-03 | Democrat | 8 | |||||||||||||
34896 | 34896 | Robert Roe R000383 | rep | NJ | 1989-01-03 | 1991-01-03 | Democrat | 8 | |||||||||||||
34939 | 34939 | James Scheuer S000124 | rep | NY | 1989-01-03 | 1991-01-03 | Democrat | 8 | |||||||||||||
35011 | 35011 | Jerome Traxler T000356 | rep | MI | 1989-01-03 | 1991-01-03 | Democrat | 8 | |||||||||||||
35413 | 35413 | Francis McCloskey M000342 | rep | IN | 1989-01-03 | 1991-01-03 | Democrat | 8 | |||||||||||||
35549 | 35549 | Daniel Rostenkowski R000458 | rep | IL | 1989-01-03 | 1991-01-03 | Democrat | 8 | |||||||||||||
35555 | 35555 | James Rowland R000481 | rep | GA | 1989-01-03 | 1991-01-03 | Democrat | 8 | |||||||||||||
35785 | 35785 | Norvell Emerson E000174 | rep | MO | 1989-01-03 | 1991-01-03 | Republican | 8 | |||||||||||||
35795 | 35795 | Jack Fields F000111 | rep | TX | 1989-01-03 | 1991-01-03 | Republican | 8 | |||||||||||||
36013 | 36013 | Toby Roth R000459 | rep | WI | 1989-01-03 | 1991-01-03 | Republican | 8 | |||||||||||||
36151 | 36151 | Ronald Dellums D000222 | rep | CA | 1989-01-03 | 1991-01-03 | Democrat | 8 | |||||||||||||
36252 | 36252 | Willie Hefner H000448 | rep | NC | 1989-01-03 | 1991-01-03 | Democrat | 8 | |||||||||||||
36267 | 36267 | Joseph Kennedy K000110 | rep | MA | 1989-01-03 | 1991-01-03 | Democrat | 8 | |||||||||||||
37056 | 37056 | Constance Morella M000941 | rep | MD | 1989-01-03 | 1991-01-03 | Republican | 8 | |||||||||||||
38719 | 38719 | James Oberstar O000006 | rep | MN | 1989-01-03 | 1991-01-03 | Democrat | 8 | |||||||||||||
38870 | 38870 | John Tanner T000038 | rep | TN | 1989-01-03 | 1991-01-03 | Democrat | 8 | |||||||||||||
39631 | 39631 | C. Young Y000031 | rep | FL | 1989-01-03 | 1991-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);