legislator_terms
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
28 rows where class = 1 and "end" is on date 1887-03-03
This data as json, copyable, CSV (advanced)
Suggested facets: state, start, 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
10305 | 10305 | Omar Conger C000678 | sen | MI | 1881-12-05 | 1887-03-03 | 1 | Republican | |||||||||||||
10343 | 10343 | James Fair F000002 | sen | NV | 1881-12-05 | 1887-03-03 | 1 | Democrat | |||||||||||||
10401 | 10401 | Howell Jackson J000014 | sen | TN | 1881-12-05 | 1887-03-03 | 1 | Democrat | |||||||||||||
10405 | 10405 | Charles Jones J000214 | sen | FL | 1881-12-05 | 1887-03-03 | 1 | Democrat | |||||||||||||
10441 | 10441 | William Mahone M000067 | sen | VA | 1881-12-05 | 1887-03-03 | 1 | Republican | |||||||||||||
10447 | 10447 | Samuel Maxey M000265 | sen | TX | 1881-12-05 | 1887-03-03 | 1 | Democrat | |||||||||||||
10463 | 10463 | Samuel McMillan M000570 | sen | MN | 1881-12-05 | 1887-03-03 | 1 | Republican | |||||||||||||
10464 | 10464 | John Miller M000740 | sen | CA | 1881-12-05 | 1887-03-03 | 1 | Republican | |||||||||||||
10466 | 10466 | Warner Miller M000760 | sen | NY | 1881-12-05 | 1887-03-03 | 1 | Republican | |||||||||||||
10469 | 10469 | John Mitchell M000819 | sen | PA | 1881-12-05 | 1887-03-03 | 1 | Republican | |||||||||||||
10583 | 10583 | Charles Van Wyck V000067 | sen | NE | 1881-12-05 | 1887-03-03 | 1 | Republican | |||||||||||||
11282 | 11282 | Abram Williams W000486 | sen | CA | 1886-01-01 | 1887-03-03 | 1 | Republican | |||||||||||||
11346 | 11346 | Henry Dawes D000148 | sen | MA | 1881-12-05 | 1887-03-03 | 1 | Republican | |||||||||||||
11361 | 11361 | George Edmunds E000056 | sen | VT | 1881-12-05 | 1887-03-03 | 1 | Republican | |||||||||||||
11390 | 11390 | George Hearst H000428 | sen | CA | 1886-01-01 | 1887-03-03 | 1 | Democrat | |||||||||||||
11503 | 11503 | Philetus Sawyer S000091 | sen | WI | 1881-12-05 | 1887-03-03 | 1 | Republican | |||||||||||||
11554 | 11554 | Benjamin Harrison H000263 | sen | IN | 1881-12-05 | 1887-03-03 | 1 | Republican | |||||||||||||
12028 | 12028 | Washington Whitthorne W000429 | sen | TN | 1886-01-01 | 1887-03-03 | 1 | Democrat | |||||||||||||
12467 | 12467 | Johnson Camden C000062 | sen | WV | 1881-12-05 | 1887-03-03 | 1 | Democrat | |||||||||||||
12572 | 12572 | James George G000127 | sen | MS | 1881-12-05 | 1887-03-03 | 1 | Democrat | |||||||||||||
12584 | 12584 | George Gray G000396 | sen | DE | 1885-12-07 | 1887-03-03 | 1 | Democrat | |||||||||||||
12782 | 12782 | John Sherman S000346 | sen | OH | 1881-12-05 | 1887-03-03 | 1 | Republican | |||||||||||||
13157 | 13157 | William Sewell S000262 | sen | NJ | 1881-12-05 | 1887-03-03 | 1 | Republican | |||||||||||||
13617 | 13617 | Francis Cockrell C000576 | sen | MO | 1881-12-05 | 1887-03-03 | 1 | Democrat | |||||||||||||
13702 | 13702 | Joseph Hawley H000377 | sen | CT | 1881-12-05 | 1887-03-03 | 1 | Republican | |||||||||||||
14333 | 14333 | Arthur Gorman G000326 | sen | MD | 1881-12-05 | 1887-03-03 | 1 | Democrat | |||||||||||||
14557 | 14557 | Nelson Aldrich A000083 | sen | RI | 1881-10-05 | 1887-03-03 | 1 | Republican | |||||||||||||
14690 | 14690 | Eugene Hale H000029 | sen | ME | 1881-12-05 | 1887-03-03 | 1 | Republican |
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);