legislator_terms
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
37 rows where district = 1 and "end" is on date 1889-03-03
This data as json, copyable, CSV (advanced)
Suggested facets: start (date), 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
11292 | 11292 | Perry Belmont B000353 | rep | NY | 1887-12-05 | 1889-03-03 | Democrat | 1 | |||||||||||||
11316 | 11316 | Roderick Butler B001188 | rep | TN | 1887-12-05 | 1889-03-03 | Republican | 1 | |||||||||||||
11335 | 11335 | Robert Davis D000130 | rep | MA | 1887-12-05 | 1889-03-03 | Republican | 1 | |||||||||||||
11352 | 11352 | Ransom Dunham D000541 | rep | IL | 1887-12-05 | 1889-03-03 | Republican | 1 | |||||||||||||
11357 | 11357 | Poindexter Dunn D000552 | rep | AR | 1887-12-05 | 1889-03-03 | Democrat | 1 | |||||||||||||
11395 | 11395 | George Hires H000642 | rep | NJ | 1887-12-05 | 1889-03-03 | Republican | 1 | |||||||||||||
11408 | 11408 | Alvin Hovey H000833 | rep | IN | 1887-12-05 | 1889-03-03 | Republican | 1 | |||||||||||||
11424 | 11424 | James Jones J000233 | rep | AL | 1887-12-05 | 1889-03-03 | Democrat | 1 | |||||||||||||
11431 | 11431 | Louis Latham L000109 | rep | NC | 1887-12-05 | 1889-03-03 | Democrat | 1 | |||||||||||||
11447 | 11447 | John McShane M000601 | rep | NE | 1887-12-05 | 1889-03-03 | Democrat | 1 | |||||||||||||
11463 | 11463 | Thomas Norwood N000160 | rep | GA | 1887-12-05 | 1889-03-03 | Democrat | 1 | |||||||||||||
11480 | 11480 | Francis Posey P000451 | rep | IN | 1887-12-05 | 1889-03-03 | Republican | 1 | |||||||||||||
11517 | 11517 | George Symes S001133 | rep | CO | 1887-12-05 | 1889-03-03 | Republican | 1 | |||||||||||||
11528 | 11528 | Thomas Thompson T000219 | rep | CA | 1887-12-05 | 1889-03-03 | Democrat | 1 | |||||||||||||
11531 | 11531 | Robert Vance V000020 | rep | CT | 1887-12-05 | 1889-03-03 | Democrat | 1 | |||||||||||||
11550 | 11550 | Thomas Wilson W000614 | rep | MN | 1887-12-05 | 1889-03-03 | Democrat | 1 | |||||||||||||
11620 | 11620 | Thomas Browne B000957 | rep | VA | 1887-12-05 | 1889-03-03 | Republican | 1 | |||||||||||||
11642 | 11642 | Benjamin Butterworth B001200 | rep | OH | 1887-12-05 | 1889-03-03 | Republican | 1 | |||||||||||||
11662 | 11662 | Lucien Caswell C000245 | rep | WI | 1887-12-05 | 1889-03-03 | Republican | 1 | |||||||||||||
11723 | 11723 | Robert Davidson D000085 | rep | FL | 1887-12-05 | 1889-03-03 | Democrat | 1 | |||||||||||||
11731 | 11731 | Samuel Dibble D000300 | rep | SC | 1887-12-05 | 1889-03-03 | Democrat | 1 | |||||||||||||
11869 | 11869 | Edmund Morrill M000968 | rep | KS | 1887-12-05 | 1889-03-03 | Republican | 1 | |||||||||||||
11969 | 11969 | Henry Spooner S000740 | rep | RI | 1887-12-05 | 1889-03-03 | Republican | 1 | |||||||||||||
12038 | 12038 | Theodore Wilkinson W000477 | rep | LA | 1887-12-05 | 1889-03-03 | Democrat | 1 | |||||||||||||
12178 | 12178 | Charles Gibson G000157 | rep | MD | 1887-12-05 | 1889-03-03 | Democrat | 1 | |||||||||||||
12242 | 12242 | Luther McKinney M000526 | rep | NH | 1887-12-05 | 1889-03-03 | Democrat | 1 | |||||||||||||
12308 | 12308 | Charles Stewart S000904 | rep | TX | 1887-12-05 | 1889-03-03 | Democrat | 1 | |||||||||||||
12485 | 12485 | John Chipman C000367 | rep | MI | 1887-12-05 | 1889-03-03 | Democrat | 1 | |||||||||||||
12601 | 12601 | William Hatch H000339 | rep | MO | 1887-12-05 | 1889-03-03 | Democrat | 1 | |||||||||||||
12815 | 12815 | William Stone S000969 | rep | KY | 1887-12-05 | 1889-03-03 | Democrat | 1 | |||||||||||||
13006 | 13006 | John Gear G000110 | rep | IA | 1887-12-05 | 1889-03-03 | Republican | 1 | |||||||||||||
13549 | 13549 | John Allen A000134 | rep | MS | 1887-12-05 | 1889-03-03 | Democrat | 1 | |||||||||||||
13776 | 13776 | Thomas Reed R000128 | rep | ME | 1887-12-05 | 1889-03-03 | Republican | 1 | |||||||||||||
14708 | 14708 | Binger Hermann H000531 | rep | OR | 1887-12-05 | 1889-03-03 | Republican | 1 | |||||||||||||
15317 | 15317 | John Stewart S000917 | rep | VT | 1887-12-05 | 1889-03-03 | Republican | 1 | |||||||||||||
15858 | 15858 | Henry Bingham B000469 | rep | PA | 1887-12-05 | 1889-03-03 | Republican | 1 | |||||||||||||
16376 | 16376 | Nathan Goff G000255 | rep | WV | 1887-12-05 | 1889-03-03 | Republican | 1 |
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);