legislator_terms
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
404 rows where "end" is on date 1899-03-03 sorted by party
This data as json, copyable, CSV (advanced)
Suggested facets: state, start, 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
12388 | 12388 | Roger Mills M000777 | sen | TX | 1893-03-04 | 1899-03-03 | 1 | Democrat | |||||||||||||
12542 | 12542 | Charles Faulkner F000045 | sen | WV | 1893-08-07 | 1899-03-03 | 1 | Democrat | |||||||||||||
12586 | 12586 | George Gray G000396 | sen | DE | 1893-08-07 | 1899-03-03 | 1 | Democrat | |||||||||||||
12691 | 12691 | John Mitchell M000821 | sen | WI | 1893-08-07 | 1899-03-03 | 1 | Democrat | |||||||||||||
12698 | 12698 | Edward Murphy M001090 | sen | NY | 1893-08-07 | 1899-03-03 | 1 | Democrat | |||||||||||||
12751 | 12751 | Samuel Pasco P000095 | sen | FL | 1893-08-07 | 1899-03-03 | 1 | Democrat | |||||||||||||
12770 | 12770 | William Roach R000290 | sen | ND | 1893-08-07 | 1899-03-03 | 1 | Democrat | |||||||||||||
12790 | 12790 | James Smith S000561 | sen | NJ | 1893-08-07 | 1899-03-03 | 1 | Democrat | |||||||||||||
12835 | 12835 | David Turpie T000432 | sen | IN | 1893-08-07 | 1899-03-03 | 1 | Democrat | |||||||||||||
12852 | 12852 | Stephen White W000394 | sen | CA | 1893-08-07 | 1899-03-03 | 1 | Democrat | |||||||||||||
13203 | 13203 | Edward Walthall W000111 | sen | MS | 1895-12-02 | 1899-03-03 | 2 | Democrat | |||||||||||||
13241 | 13241 | Jehu Baker B000066 | rep | IL | 1897-03-15 | 1899-03-03 | Democrat | 21 | |||||||||||||
13257 | 13257 | George Benner B000366 | rep | PA | 1897-03-15 | 1899-03-03 | Democrat | 19 | |||||||||||||
13260 | 13260 | Robert Bodine B000584 | rep | MO | 1897-03-15 | 1899-03-03 | Democrat | 2 | |||||||||||||
13269 | 13269 | Ferdinand Brucker B000973 | rep | MI | 1897-03-15 | 1899-03-03 | Democrat | 8 | |||||||||||||
13271 | 13271 | James Campbell C000089 | rep | IL | 1897-03-15 | 1899-03-03 | Democrat | 20 | |||||||||||||
13274 | 13274 | John Clardy C000415 | rep | KY | 1897-03-15 | 1899-03-03 | Democrat | 2 | |||||||||||||
13285 | 13285 | John Cranford C000876 | rep | TX | 1897-03-15 | 1899-03-03 | Democrat | 4 | |||||||||||||
13297 | 13297 | Alexander Dockery D000384 | rep | MO | 1897-03-15 | 1899-03-03 | Democrat | 3 | |||||||||||||
13316 | 13316 | Levin Handy H000156 | rep | DE | 1897-03-15 | 1899-03-03 | Democrat | 0 | |||||||||||||
13332 | 13332 | William Hinrichsen H000637 | rep | IL | 1897-03-15 | 1899-03-03 | Democrat | 16 | |||||||||||||
13349 | 13349 | William Holman H000732 | rep | IN | 1897-03-15 | 1899-03-03 | Democrat | 4 | |||||||||||||
13355 | 13355 | Andrew Hunter H000980 | rep | IL | 1897-03-15 | 1899-03-03 | Democrat | 19 | |||||||||||||
13381 | 13381 | William Love L000461 | rep | MS | 1897-03-15 | 1899-03-03 | Democrat | 6 | |||||||||||||
13386 | 13386 | James Maguire M000059 | rep | CA | 1897-03-15 | 1899-03-03 | Democrat | 4 | |||||||||||||
13389 | 13389 | George Marshall M000153 | rep | OH | 1897-03-15 | 1899-03-03 | Democrat | 4 | |||||||||||||
13411 | 13411 | Benton McMillin M000575 | rep | TN | 1897-03-15 | 1899-03-03 | Democrat | 4 | |||||||||||||
13444 | 13444 | Henry Ogden O000044 | rep | LA | 1897-03-15 | 1899-03-03 | Democrat | 4 | |||||||||||||
13445 | 13445 | John Osborne O000113 | rep | WY | 1897-03-15 | 1899-03-03 | Democrat | 0 | |||||||||||||
13453 | 13453 | Thomas Plowman P000388 | rep | AL | 1897-03-15 | 1899-03-03 | Democrat | 4 | |||||||||||||
13471 | 13471 | Joseph Sayers S000099 | rep | TX | 1897-03-15 | 1899-03-03 | Democrat | 9 | |||||||||||||
13498 | 13498 | Thomas Strait S000989 | rep | SC | 1897-03-15 | 1899-03-03 | Democrat | 5 | |||||||||||||
13506 | 13506 | Albert Todd T000291 | rep | MI | 1897-03-15 | 1899-03-03 | Democrat | 3 | |||||||||||||
13514 | 13514 | John Vehslage V000080 | rep | NY | 1897-03-15 | 1899-03-03 | Democrat | 7 | |||||||||||||
13554 | 13554 | John Allen A000134 | rep | MS | 1897-03-15 | 1899-03-03 | Democrat | 1 | |||||||||||||
13560 | 13560 | Samuel Baird B000055 | rep | LA | 1897-03-15 | 1899-03-03 | Democrat | 5 | |||||||||||||
13570 | 13570 | William Bate B000227 | sen | TN | 1893-08-07 | 1899-03-03 | 1 | Democrat | |||||||||||||
13574 | 13574 | Albert Berry B000414 | rep | KY | 1897-03-15 | 1899-03-03 | Democrat | 6 | |||||||||||||
13587 | 13587 | Richard Bland B000544 | rep | MO | 1897-03-15 | 1899-03-03 | Democrat | 8 | |||||||||||||
13589 | 13589 | Thomas Bradley B000746 | rep | NY | 1897-03-15 | 1899-03-03 | Democrat | 9 | |||||||||||||
13591 | 13591 | John Brenner B000801 | rep | OH | 1897-03-15 | 1899-03-03 | Democrat | 3 | |||||||||||||
13593 | 13593 | Willis Brewer B000812 | rep | AL | 1897-03-15 | 1899-03-03 | Democrat | 5 | |||||||||||||
13604 | 13604 | Thomas Catchings C000247 | rep | MS | 1897-03-15 | 1899-03-03 | Democrat | 3 | |||||||||||||
13619 | 13619 | Francis Cockrell C000576 | sen | MO | 1893-08-07 | 1899-03-03 | 1 | Democrat | |||||||||||||
13624 | 13624 | Nicholas Cox C000838 | rep | TN | 1897-03-15 | 1899-03-03 | Democrat | 7 | |||||||||||||
13640 | 13640 | Marion De Vries D000277 | rep | CA | 1897-03-15 | 1899-03-03 | Democrat | 2 | |||||||||||||
13652 | 13652 | Edmund Driggs D000497 | rep | NY | 1897-03-15 | 1899-03-03 | Democrat | 3 | |||||||||||||
13654 | 13654 | Sydney Epes E000196 | rep | VA | 1897-03-15 | 1899-03-03 | Democrat | 4 | |||||||||||||
13660 | 13660 | Daniel Ermentrout E000205 | rep | PA | 1897-03-15 | 1899-03-03 | Democrat | 9 | |||||||||||||
13665 | 13665 | Thomas Fitzpatrick F000177 | rep | KY | 1897-03-15 | 1899-03-03 | Democrat | 10 | |||||||||||||
13709 | 13709 | Patrick Henry H000512 | rep | MS | 1897-03-15 | 1899-03-03 | Democrat | 7 | |||||||||||||
13724 | 13724 | John Lentz L000244 | rep | OH | 1897-03-15 | 1899-03-03 | Democrat | 12 | |||||||||||||
13734 | 13734 | William McAleer M000294 | rep | PA | 1897-03-15 | 1899-03-03 | Democrat | 3 | |||||||||||||
13741 | 13741 | John McDowell M000421 | rep | OH | 1897-03-15 | 1899-03-03 | Democrat | 17 | |||||||||||||
13744 | 13744 | David Meekison M000630 | rep | OH | 1897-03-15 | 1899-03-03 | Democrat | 5 | |||||||||||||
13749 | 13749 | James Norton N000149 | rep | SC | 1897-03-15 | 1899-03-03 | Democrat | 6 | |||||||||||||
13790 | 13790 | Evan Settle S000252 | rep | KY | 1897-03-15 | 1899-03-03 | Democrat | 7 | |||||||||||||
13796 | 13796 | Jesse Stallings S000784 | rep | AL | 1897-03-15 | 1899-03-03 | Democrat | 2 | |||||||||||||
13811 | 13811 | William Terry T000137 | rep | AR | 1897-03-15 | 1899-03-03 | Democrat | 4 | |||||||||||||
13828 | 13828 | Joseph Wheeler W000338 | rep | AL | 1897-03-15 | 1899-03-03 | Democrat | 8 | |||||||||||||
13835 | 13835 | Stanyarne Wilson W000612 | rep | SC | 1897-03-15 | 1899-03-03 | Democrat | 4 | |||||||||||||
13839 | 13839 | William Young Y000056 | rep | VA | 1897-03-15 | 1899-03-03 | Democrat | 2 | |||||||||||||
13898 | 13898 | Robert Burke B001097 | rep | TX | 1897-03-15 | 1899-03-03 | Democrat | 6 | |||||||||||||
13902 | 13902 | Edward Carmack C000157 | rep | TN | 1897-03-15 | 1899-03-03 | Democrat | 10 | |||||||||||||
13909 | 13909 | James Cooney C000744 | rep | MO | 1897-03-15 | 1899-03-03 | Democrat | 7 | |||||||||||||
13927 | 13927 | Amos Cummings C000983 | rep | NY | 1897-03-15 | 1899-03-03 | Democrat | 10 | |||||||||||||
13932 | 13932 | Reese De Graffenreid D000194 | rep | TX | 1897-03-15 | 1899-03-03 | Democrat | 3 | |||||||||||||
13949 | 13949 | William Elliott E000129 | rep | SC | 1897-03-15 | 1899-03-03 | Democrat | 1 | |||||||||||||
13956 | 13956 | William Fleming F000198 | rep | GA | 1897-03-15 | 1899-03-03 | Democrat | 10 | |||||||||||||
13963 | 13963 | Andrew Fox F000330 | rep | MS | 1897-03-15 | 1899-03-03 | Democrat | 4 | |||||||||||||
14023 | 14023 | Thomas Jett J000102 | rep | IL | 1897-03-15 | 1899-03-03 | Democrat | 18 | |||||||||||||
14034 | 14034 | Rudolph Kleberg K000258 | rep | TX | 1897-03-15 | 1899-03-03 | Democrat | 11 | |||||||||||||
14046 | 14046 | Samuel Lanham L000078 | rep | TX | 1897-03-15 | 1899-03-03 | Democrat | 8 | |||||||||||||
14059 | 14059 | Philip McCulloch M000391 | rep | AR | 1897-03-15 | 1899-03-03 | Democrat | 1 | |||||||||||||
14071 | 14071 | Thomas McRae M000597 | rep | AR | 1897-03-15 | 1899-03-03 | Democrat | 3 | |||||||||||||
14113 | 14113 | James Norton N000150 | rep | OH | 1897-03-15 | 1899-03-03 | Democrat | 13 | |||||||||||||
14117 | 14117 | Peter Otey O000126 | rep | VA | 1897-03-15 | 1899-03-03 | Democrat | 6 | |||||||||||||
14192 | 14192 | James Stokes S000947 | rep | SC | 1897-03-15 | 1899-03-03 | Democrat | 7 | |||||||||||||
14199 | 14199 | William Talbert T000016 | rep | SC | 1897-03-15 | 1899-03-03 | Democrat | 2 | |||||||||||||
14212 | 14212 | Charles Wheeler W000331 | rep | KY | 1897-03-15 | 1899-03-03 | Democrat | 1 | |||||||||||||
14240 | 14240 | Thomas Ball B000101 | rep | TX | 1897-03-15 | 1899-03-03 | Democrat | 1 | |||||||||||||
14247 | 14247 | Maecenas Benton B000397 | rep | MO | 1897-03-15 | 1899-03-03 | Democrat | 15 | |||||||||||||
14264 | 14264 | Charles Cochran C000562 | rep | MO | 1897-03-15 | 1899-03-03 | Democrat | 4 | |||||||||||||
14272 | 14272 | William Cowherd C000825 | rep | MO | 1897-03-15 | 1899-03-03 | Democrat | 5 | |||||||||||||
14282 | 14282 | Robert Davis D000132 | rep | FL | 1897-03-15 | 1899-03-03 | Democrat | 2 | |||||||||||||
14294 | 14294 | Hugh Dinsmore D000358 | rep | AR | 1897-03-15 | 1899-03-03 | Democrat | 5 | |||||||||||||
14335 | 14335 | Arthur Gorman G000326 | sen | MD | 1893-08-07 | 1899-03-03 | 1 | Democrat | |||||||||||||
14337 | 14337 | Francis Griffith G000468 | rep | IN | 1897-03-15 | 1899-03-03 | Democrat | 4 | |||||||||||||
14375 | 14375 | Asbury Latimer L000114 | rep | SC | 1897-03-15 | 1899-03-03 | Democrat | 3 | |||||||||||||
14391 | 14391 | John Maddox M000040 | rep | GA | 1897-03-15 | 1899-03-03 | Democrat | 7 | |||||||||||||
14402 | 14402 | George McClellan M000331 | rep | NY | 1897-03-15 | 1899-03-03 | Democrat | 12 | |||||||||||||
14416 | 14416 | Robert Miers M000700 | rep | IN | 1897-03-15 | 1899-03-03 | Democrat | 2 | |||||||||||||
14429 | 14429 | Rice Pierce P000337 | rep | TN | 1897-03-15 | 1899-03-03 | Democrat | 9 | |||||||||||||
14446 | 14446 | John Rhea R000182 | rep | KY | 1897-03-15 | 1899-03-03 | Democrat | 3 | |||||||||||||
14456 | 14456 | James Richardson R000222 | rep | TN | 1897-03-15 | 1899-03-03 | Democrat | 5 | |||||||||||||
14461 | 14461 | Edward Robb R000296 | rep | MO | 1897-03-15 | 1899-03-03 | Democrat | 13 | |||||||||||||
14465 | 14465 | James Robinson R000338 | rep | IN | 1897-03-15 | 1899-03-03 | Democrat | 12 | |||||||||||||
14488 | 14488 | Farish Tate T000046 | rep | GA | 1897-03-15 | 1899-03-03 | Democrat | 9 | |||||||||||||
14516 | 14516 | Willard Vandiver V000032 | rep | MO | 1897-03-15 | 1899-03-03 | Democrat | 14 | |||||||||||||
14628 | 14628 | John Daniel D000035 | sen | VA | 1893-08-07 | 1899-03-03 | 1 | Democrat |
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);