legislator_terms
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
25 rows where district = 7 and "start" is on date 1883-12-03
This data as json, copyable, CSV (advanced)
Suggested facets: state, 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
10660 | 10660 | Aylett Buckner B001031 | rep | MO | 1883-12-03 | 1885-03-03 | Democrat | 7 | |||||||||||||
10702 | 10702 | William Dorsheimer D000442 | rep | NY | 1883-12-03 | 1885-03-03 | Democrat | 7 | |||||||||||||
10714 | 10714 | William English E000190 | rep | IN | 1883-12-03 | 1885-03-03 | Democrat | 7 | |||||||||||||
10778 | 10778 | John Kasson K000018 | rep | IA | 1883-12-03 | 1885-03-03 | Republican | 7 | |||||||||||||
10800 | 10800 | Edmund Mackey M000024 | rep | SC | 1883-12-03 | 1885-03-03 | Republican | 7 | |||||||||||||
10827 | 10827 | Thomas Ochiltree O000021 | rep | TX | 1883-12-03 | 1885-03-03 | Independent | 7 | |||||||||||||
10834 | 10834 | John Paul P000144 | rep | VA | 1883-12-03 | 1885-03-03 | Readjuster | 7 | |||||||||||||
10836 | 10836 | Stanton Peelle P000185 | rep | IN | 1883-12-03 | 1885-03-03 | Republican | 7 | |||||||||||||
10901 | 10901 | Hiram Smith S000550 | rep | IA | 1883-12-03 | 1885-03-03 | Republican | 7 | |||||||||||||
10942 | 10942 | Gilbert Woodward W000731 | rep | WI | 1883-12-03 | 1885-03-03 | Democrat | 7 | |||||||||||||
10944 | 10944 | Tyre York Y000022 | rep | NC | 1883-12-03 | 1885-03-03 | Ind. Democrat | 7 | |||||||||||||
10961 | 10961 | John Ballentine B000105 | rep | TN | 1883-12-03 | 1885-03-03 | Democrat | 7 | |||||||||||||
10963 | 10963 | Ethelbert Barksdale B000146 | rep | MS | 1883-12-03 | 1885-03-03 | Democrat | 7 | |||||||||||||
10998 | 10998 | Ezra Carleton C000147 | rep | MI | 1883-12-03 | 1885-03-03 | Democrat | 7 | |||||||||||||
11033 | 11033 | Isaac Evans E000244 | rep | PA | 1883-12-03 | 1885-03-03 | Republican | 7 | |||||||||||||
11199 | 11199 | Robert Smalls S000502 | rep | SC | 1883-12-03 | 1885-03-03 | Republican | 7 | |||||||||||||
11208 | 11208 | Eben Stone S000956 | rep | MA | 1883-12-03 | 1885-03-03 | Republican | 7 | |||||||||||||
11317 | 11317 | James Campbell C000087 | rep | OH | 1883-12-03 | 1885-03-03 | Democrat | 7 | |||||||||||||
11669 | 11669 | Judson Clements C000508 | rep | GA | 1883-12-03 | 1885-03-03 | Democrat | 7 | |||||||||||||
11839 | 11839 | William McAdoo M000292 | rep | NJ | 1883-12-03 | 1885-03-03 | Democrat | 7 | |||||||||||||
11862 | 11862 | Henry Morey M000943 | rep | OH | 1883-12-03 | 1885-03-03 | Republican | 7 | |||||||||||||
12168 | 12168 | William Forney F000280 | rep | AL | 1883-12-03 | 1885-03-03 | Democrat | 7 | |||||||||||||
12627 | 12627 | Thomas Henderson H000489 | rep | IL | 1883-12-03 | 1885-03-03 | Republican | 7 | |||||||||||||
12705 | 12705 | Charles O’Ferrall O000040 | rep | VA | 1883-12-03 | 1885-03-03 | Democrat | 7 | |||||||||||||
13867 | 13867 | Joseph Blackburn B000508 | rep | KY | 1883-12-03 | 1885-03-03 | Democrat | 7 |
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);