legislator_terms
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
371 rows where "end" is on date 1887-03-03 sorted by state
This data as json, copyable, CSV (advanced)
Suggested facets: state, class, district, 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
11125 | 11125 | John Martin M000188 | rep | AL | 1885-12-07 | 1887-03-03 | Democrat | 6 | |||||||||||||
11181 | 11181 | Thomas Sadler S000010 | rep | AL | 1885-12-07 | 1887-03-03 | Democrat | 5 | |||||||||||||
11331 | 11331 | Alexander Davidson D000082 | rep | AL | 1885-12-07 | 1887-03-03 | Democrat | 4 | |||||||||||||
11423 | 11423 | James Jones J000233 | rep | AL | 1885-12-07 | 1887-03-03 | Democrat | 1 | |||||||||||||
12169 | 12169 | William Forney F000280 | rep | AL | 1885-12-07 | 1887-03-03 | Democrat | 7 | |||||||||||||
12204 | 12204 | Hilary Herbert H000524 | rep | AL | 1885-12-07 | 1887-03-03 | Democrat | 2 | |||||||||||||
12736 | 12736 | William Oates O000005 | rep | AL | 1885-12-07 | 1887-03-03 | Democrat | 3 | |||||||||||||
13822 | 13822 | Joseph Wheeler W000338 | rep | AL | 1885-12-07 | 1887-03-03 | Democrat | 8 | |||||||||||||
11356 | 11356 | Poindexter Dunn D000552 | rep | AR | 1885-12-07 | 1887-03-03 | Democrat | 1 | |||||||||||||
11937 | 11937 | John Rogers R000399 | rep | AR | 1885-12-07 | 1887-03-03 | Democrat | 4 | |||||||||||||
12266 | 12266 | Samuel Peel P000184 | rep | AR | 1885-12-07 | 1887-03-03 | Democrat | 5 | |||||||||||||
12426 | 12426 | Clifton Breckinridge B000784 | rep | AR | 1885-12-07 | 1887-03-03 | Democrat | 2 | |||||||||||||
14065 | 14065 | Thomas McRae M000597 | rep | AR | 1885-12-07 | 1887-03-03 | Democrat | 3 | |||||||||||||
10968 | 10968 | Curtis Bean B000278 | rep | AZ | 1885-12-07 | 1887-03-03 | Republican | 0 | |||||||||||||
10464 | 10464 | John Miller M000740 | sen | CA | 1881-12-05 | 1887-03-03 | 1 | Republican | |||||||||||||
11077 | 11077 | Barclay Henley H000498 | rep | CA | 1885-12-07 | 1887-03-03 | Democrat | 1 | |||||||||||||
11119 | 11119 | James Louttit L000453 | rep | CA | 1885-12-07 | 1887-03-03 | Republican | 2 | |||||||||||||
11124 | 11124 | Henry Markham M000134 | rep | CA | 1885-12-07 | 1887-03-03 | Republican | 6 | |||||||||||||
11282 | 11282 | Abram Williams W000486 | sen | CA | 1886-01-01 | 1887-03-03 | 1 | Republican | |||||||||||||
11390 | 11390 | George Hearst H000428 | sen | CA | 1886-01-01 | 1887-03-03 | 1 | Democrat | |||||||||||||
11871 | 11871 | William Morrow M001006 | rep | CA | 1885-12-07 | 1887-03-03 | Republican | 4 | |||||||||||||
12154 | 12154 | Charles Felton F000068 | rep | CA | 1885-12-07 | 1887-03-03 | Republican | 5 | |||||||||||||
12238 | 12238 | Joseph McKenna M000500 | rep | CA | 1885-12-07 | 1887-03-03 | Republican | 3 | |||||||||||||
11516 | 11516 | George Symes S001133 | rep | CO | 1885-12-07 | 1887-03-03 | Republican | 1 | |||||||||||||
10983 | 10983 | John Buck B001018 | rep | CT | 1885-12-07 | 1887-03-03 | Republican | 1 | |||||||||||||
11133 | 11133 | Charles Mitchell M000807 | rep | CT | 1885-12-07 | 1887-03-03 | Democrat | 2 | |||||||||||||
11186 | 11186 | Edward Seymour S000266 | rep | CT | 1885-12-07 | 1887-03-03 | Democrat | 4 | |||||||||||||
11249 | 11249 | John Wait W000025 | rep | CT | 1885-12-07 | 1887-03-03 | Republican | 3 | |||||||||||||
13702 | 13702 | Joseph Hawley H000377 | sen | CT | 1881-12-05 | 1887-03-03 | 1 | Republican | |||||||||||||
11118 | 11118 | Charles Lore L000443 | rep | DE | 1885-12-07 | 1887-03-03 | Democrat | 0 | |||||||||||||
12584 | 12584 | George Gray G000396 | sen | DE | 1885-12-07 | 1887-03-03 | 1 | Democrat | |||||||||||||
11770 | 11770 | Oscar Gifford G000170 | rep | DK | 1885-12-07 | 1887-03-03 | Republican | -1 | |||||||||||||
10405 | 10405 | Charles Jones J000214 | sen | FL | 1881-12-05 | 1887-03-03 | 1 | Democrat | |||||||||||||
11348 | 11348 | Charles Dougherty D000445 | rep | FL | 1885-12-07 | 1887-03-03 | Democrat | 2 | |||||||||||||
11722 | 11722 | Robert Davidson D000085 | rep | FL | 1885-12-07 | 1887-03-03 | Democrat | 1 | |||||||||||||
11065 | 11065 | Nathaniel Hammond H000130 | rep | GA | 1885-12-07 | 1887-03-03 | Democrat | 5 | |||||||||||||
11073 | 11073 | Henry Harris H000239 | rep | GA | 1885-12-07 | 1887-03-03 | Democrat | 4 | |||||||||||||
11169 | 11169 | Seaborn Reese R000136 | rep | GA | 1885-12-07 | 1887-03-03 | Democrat | 8 | |||||||||||||
11462 | 11462 | Thomas Norwood N000160 | rep | GA | 1885-12-07 | 1887-03-03 | Democrat | 1 | |||||||||||||
11589 | 11589 | George Barnes B000157 | rep | GA | 1885-12-07 | 1887-03-03 | Democrat | 10 | |||||||||||||
11649 | 11649 | Allen Candler C000109 | rep | GA | 1885-12-07 | 1887-03-03 | Democrat | 9 | |||||||||||||
11670 | 11670 | Judson Clements C000508 | rep | GA | 1885-12-07 | 1887-03-03 | Democrat | 7 | |||||||||||||
12093 | 12093 | James Blount B000568 | rep | GA | 1885-12-07 | 1887-03-03 | Democrat | 6 | |||||||||||||
12972 | 12972 | Charles Crisp C000908 | rep | GA | 1885-12-07 | 1887-03-03 | Democrat | 3 | |||||||||||||
13185 | 13185 | Henry Turner T000421 | rep | GA | 1885-12-07 | 1887-03-03 | Democrat | 2 | |||||||||||||
11043 | 11043 | Benjamin Frederick F000357 | rep | IA | 1885-12-07 | 1887-03-03 | Democrat | 5 | |||||||||||||
11059 | 11059 | Benton Hall H000044 | rep | IA | 1885-12-07 | 1887-03-03 | Democrat | 1 | |||||||||||||
11143 | 11143 | Jeremiah Murphy M001096 | rep | IA | 1885-12-07 | 1887-03-03 | Democrat | 2 | |||||||||||||
11374 | 11374 | William Fuller F000414 | rep | IA | 1885-12-07 | 1887-03-03 | Republican | 4 | |||||||||||||
11404 | 11404 | Adoniram Holmes H000733 | rep | IA | 1885-12-07 | 1887-03-03 | Republican | 10 | |||||||||||||
11435 | 11435 | Joseph Lyman L000526 | rep | IA | 1885-12-07 | 1887-03-03 | Republican | 9 | |||||||||||||
11535 | 11535 | James Weaver W000225 | rep | IA | 1885-12-07 | 1887-03-03 | National Greenbacker | 6 | |||||||||||||
11682 | 11682 | Edwin Conger C000675 | rep | IA | 1885-12-07 | 1887-03-03 | Republican | 7 | |||||||||||||
11976 | 11976 | Isaac Struble S001028 | rep | IA | 1885-12-07 | 1887-03-03 | Republican | 11 | |||||||||||||
13991 | 13991 | David Henderson H000478 | rep | IA | 1885-12-07 | 1887-03-03 | Republican | 3 | |||||||||||||
15144 | 15144 | William Hepburn H000523 | rep | IA | 1885-12-07 | 1887-03-03 | Republican | 8 | |||||||||||||
11057 | 11057 | John Hailey H000023 | rep | ID | 1885-12-07 | 1887-03-03 | Democrat | -1 | |||||||||||||
11023 | 11023 | John Eden E000042 | rep | IL | 1885-12-07 | 1887-03-03 | Democrat | 17 | |||||||||||||
11028 | 11028 | Reuben Ellwood E000151 | rep | IL | 1885-12-07 | 1887-03-03 | Republican | 5 | |||||||||||||
11116 | 11116 | John Logan L000403 | sen | IL | 1885-12-07 | 1887-03-03 | 3 | Republican | |||||||||||||
11141 | 11141 | William Morrison M001000 | rep | IL | 1885-12-07 | 1887-03-03 | Democrat | 18 | |||||||||||||
11145 | 11145 | William Neece N000020 | rep | IL | 1885-12-07 | 1887-03-03 | Democrat | 11 | |||||||||||||
11178 | 11178 | James Riggs R000253 | rep | IL | 1885-12-07 | 1887-03-03 | Democrat | 12 | |||||||||||||
11253 | 11253 | James Ward W000134 | rep | IL | 1885-12-07 | 1887-03-03 | Democrat | 3 | |||||||||||||
11280 | 11280 | Nicholas Worthington W000749 | rep | IL | 1885-12-07 | 1887-03-03 | Democrat | 10 | |||||||||||||
11351 | 11351 | Ransom Dunham D000541 | rep | IL | 1885-12-07 | 1887-03-03 | Republican | 1 | |||||||||||||
11428 | 11428 | Silas Landes L000048 | rep | IL | 1885-12-07 | 1887-03-03 | Democrat | 16 | |||||||||||||
11478 | 11478 | Ralph Plumb P000390 | rep | IL | 1885-12-07 | 1887-03-03 | Republican | 8 | |||||||||||||
11526 | 11526 | John Thomas T000176 | rep | IL | 1885-12-07 | 1887-03-03 | Republican | 20 | |||||||||||||
11556 | 11556 | George Adams A000034 | rep | IL | 1885-12-07 | 1887-03-03 | Republican | 4 | |||||||||||||
11819 | 11819 | Frank Lawler L000128 | rep | IL | 1885-12-07 | 1887-03-03 | Democrat | 2 | |||||||||||||
11889 | 11889 | Lewis Payson P000157 | rep | IL | 1885-12-07 | 1887-03-03 | Republican | 9 | |||||||||||||
11941 | 11941 | Jonathan Rowell R000478 | rep | IL | 1885-12-07 | 1887-03-03 | Republican | 14 | |||||||||||||
11991 | 11991 | Richard Townshend T000339 | rep | IL | 1885-12-07 | 1887-03-03 | Democrat | 19 | |||||||||||||
12628 | 12628 | Thomas Henderson H000489 | rep | IL | 1885-12-07 | 1887-03-03 | Republican | 7 | |||||||||||||
12801 | 12801 | William Springer S000757 | rep | IL | 1885-12-07 | 1887-03-03 | Democrat | 13 | |||||||||||||
14347 | 14347 | Albert Hopkins H000770 | rep | IL | 1885-12-07 | 1887-03-03 | Republican | 5 | |||||||||||||
14717 | 14717 | Robert Hitt H000649 | rep | IL | 1885-12-07 | 1887-03-03 | Republican | 6 | |||||||||||||
18099 | 18099 | Joseph Cannon C000121 | rep | IL | 1885-12-07 | 1887-03-03 | Republican | 15 | |||||||||||||
11007 | 11007 | Thomas Cobb C000552 | rep | IN | 1885-12-07 | 1887-03-03 | Democrat | 2 | |||||||||||||
11041 | 11041 | George Ford F000259 | rep | IN | 1885-12-07 | 1887-03-03 | Democrat | 13 | |||||||||||||
11101 | 11101 | John Kleiner K000263 | rep | IN | 1885-12-07 | 1887-03-03 | Democrat | 1 | |||||||||||||
11123 | 11123 | Robert Lowry L000487 | rep | IN | 1885-12-07 | 1887-03-03 | Democrat | 12 | |||||||||||||
11255 | 11255 | Thomas Ward W000142 | rep | IN | 1885-12-07 | 1887-03-03 | Democrat | 9 | |||||||||||||
11409 | 11409 | Jonas Howard H000842 | rep | IN | 1885-12-07 | 1887-03-03 | Democrat | 3 | |||||||||||||
11417 | 11417 | James Johnston J000188 | rep | IN | 1885-12-07 | 1887-03-03 | Republican | 8 | |||||||||||||
11444 | 11444 | Courtland Matson M000248 | rep | IN | 1885-12-07 | 1887-03-03 | Democrat | 5 | |||||||||||||
11554 | 11554 | Benjamin Harrison H000263 | sen | IN | 1881-12-05 | 1887-03-03 | 1 | Republican | |||||||||||||
11626 | 11626 | Thomas Browne B000958 | rep | IN | 1885-12-07 | 1887-03-03 | Republican | 6 | |||||||||||||
11884 | 11884 | William Owen O000155 | rep | IN | 1885-12-07 | 1887-03-03 | Republican | 10 | |||||||||||||
12456 | 12456 | William Bynum B001205 | rep | IN | 1885-12-07 | 1887-03-03 | Democrat | 7 | |||||||||||||
13344 | 13344 | William Holman H000732 | rep | IN | 1885-12-07 | 1887-03-03 | Democrat | 4 | |||||||||||||
14179 | 14179 | George Steele S000830 | rep | IN | 1885-12-07 | 1887-03-03 | Republican | 11 | |||||||||||||
11069 | 11069 | Lewis Hanback H000142 | rep | KS | 1885-12-07 | 1887-03-03 | Republican | 6 | |||||||||||||
11568 | 11568 | John Anderson A000194 | rep | KS | 1885-12-07 | 1887-03-03 | Republican | 5 | |||||||||||||
11868 | 11868 | Edmund Morrill M000968 | rep | KS | 1885-12-07 | 1887-03-03 | Republican | 1 | |||||||||||||
11898 | 11898 | Samuel Peters P000256 | rep | KS | 1885-12-07 | 1887-03-03 | Republican | 7 | |||||||||||||
11950 | 11950 | Thomas Ryan R000559 | rep | KS | 1885-12-07 | 1887-03-03 | Republican | 4 | |||||||||||||
12390 | 12390 | Bishop Perkins P000228 | rep | KS | 1885-12-07 | 1887-03-03 | Republican | 3 | |||||||||||||
12558 | 12558 | Edward Funston F000429 | rep | KS | 1885-12-07 | 1887-03-03 | Republican | 2 |
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);