legislator_terms
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
406 rows where "end" is on date 1897-03-03 sorted by party
This data as json, copyable, CSV (advanced)
Suggested facets: type, start, 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
12099 | 12099 | Calvin Brice B000818 | sen | OH | 1891-12-07 | 1897-03-03 | 3 | Democrat | |||||||||||||
12125 | 12125 | Wilkinson Call C000051 | sen | FL | 1891-12-07 | 1897-03-03 | 3 | Democrat | |||||||||||||
12180 | 12180 | Charles Gibson G000157 | sen | MD | 1891-12-07 | 1897-03-03 | 3 | Democrat | |||||||||||||
12184 | 12184 | John Gordon G000313 | sen | GA | 1891-12-07 | 1897-03-03 | 3 | Democrat | |||||||||||||
12216 | 12216 | John Irby I000027 | sen | SC | 1891-12-07 | 1897-03-03 | 3 | Democrat | |||||||||||||
12260 | 12260 | John Palmer P000042 | sen | IL | 1891-12-07 | 1897-03-03 | 3 | Democrat | |||||||||||||
12274 | 12274 | James Pugh P000561 | sen | AL | 1891-12-07 | 1897-03-03 | 3 | Democrat | |||||||||||||
12344 | 12344 | William Vilas V000099 | sen | WI | 1891-12-07 | 1897-03-03 | 3 | Democrat | |||||||||||||
12353 | 12353 | Daniel Voorhees V000116 | sen | IN | 1891-12-07 | 1897-03-03 | 3 | Democrat | |||||||||||||
12371 | 12371 | David Hill H000590 | sen | NY | 1892-01-01 | 1897-03-03 | 3 | Democrat | |||||||||||||
12882 | 12882 | Newton Blanchard B000541 | sen | LA | 1894-01-01 | 1897-03-03 | 3 | Democrat | |||||||||||||
12890 | 12890 | Jo Abbott A000005 | rep | TX | 1895-12-02 | 1897-03-03 | Democrat | 6 | |||||||||||||
12913 | 12913 | Franklin Bartlett B000202 | rep | NY | 1895-12-02 | 1897-03-03 | Democrat | 7 | |||||||||||||
12915 | 12915 | Charles Bell B000333 | rep | TX | 1895-12-02 | 1897-03-03 | Democrat | 8 | |||||||||||||
12918 | 12918 | James Black B000502 | rep | GA | 1895-12-02 | 1897-03-03 | Democrat | 10 | |||||||||||||
12923 | 12923 | Charles Boatner B000580 | rep | LA | 1895-12-02 | 1897-03-03 | Democrat | 5 | |||||||||||||
12928 | 12928 | Charles Buck B001012 | rep | LA | 1895-12-02 | 1897-03-03 | Democrat | 2 | |||||||||||||
12943 | 12943 | Richard Clarke C000469 | rep | AL | 1895-12-02 | 1897-03-03 | Democrat | 1 | |||||||||||||
12948 | 12948 | James Cobb C000549 | rep | AL | 1895-12-02 | 1897-03-03 | Democrat | 5 | |||||||||||||
12951 | 12951 | Seth Cobb C000550 | rep | MO | 1895-12-02 | 1897-03-03 | Democrat | 12 | |||||||||||||
12953 | 12953 | Jeremiah Cockrell C000577 | rep | TX | 1895-12-02 | 1897-03-03 | Democrat | 13 | |||||||||||||
12963 | 12963 | Charles Cooper C000746 | rep | FL | 1895-12-02 | 1897-03-03 | Democrat | 2 | |||||||||||||
12964 | 12964 | John Cowen C000822 | rep | MD | 1895-12-02 | 1897-03-03 | Democrat | 4 | |||||||||||||
12970 | 12970 | William Crain C000865 | rep | TX | 1895-12-02 | 1897-03-03 | Democrat | 11 | |||||||||||||
12977 | 12977 | Charles Crisp C000908 | rep | GA | 1895-12-02 | 1897-03-03 | Democrat | 3 | |||||||||||||
12978 | 12978 | Miles Crowley C000944 | rep | TX | 1895-12-02 | 1897-03-03 | Democrat | 10 | |||||||||||||
12990 | 12990 | David Culberson C000964 | rep | TX | 1895-12-02 | 1897-03-03 | Democrat | 4 | |||||||||||||
12997 | 12997 | Walter Denny D000251 | rep | MS | 1895-12-02 | 1897-03-03 | Democrat | 6 | |||||||||||||
13000 | 13000 | Finis Downing D000473 | rep | IL | 1895-12-02 | 1897-03-03 | Democrat | 16 | |||||||||||||
13003 | 13003 | Tazewell Ellett E000117 | rep | VA | 1895-12-02 | 1897-03-03 | Democrat | 3 | |||||||||||||
13005 | 13005 | Constantine Erdman E000199 | rep | PA | 1895-12-02 | 1897-03-03 | Democrat | 9 | |||||||||||||
13017 | 13017 | Uriel Hall H000075 | rep | MO | 1895-12-02 | 1897-03-03 | Democrat | 2 | |||||||||||||
13029 | 13029 | George Harrison H000270 | rep | AL | 1895-12-02 | 1897-03-03 | Democrat | 3 | |||||||||||||
13030 | 13030 | Joseph Hart H000289 | rep | PA | 1895-12-02 | 1897-03-03 | Democrat | 8 | |||||||||||||
13034 | 13034 | John Hendrick H000491 | rep | KY | 1895-12-02 | 1897-03-03 | Democrat | 1 | |||||||||||||
13041 | 13041 | Joseph Hutcheson H001007 | rep | TX | 1895-12-02 | 1897-03-03 | Democrat | 1 | |||||||||||||
13048 | 13048 | Joseph Kendall K000095 | rep | KY | 1895-12-02 | 1897-03-03 | Democrat | 10 | |||||||||||||
13054 | 13054 | John Kyle K000354 | rep | MS | 1895-12-02 | 1897-03-03 | Democrat | 2 | |||||||||||||
13057 | 13057 | Thomas Lawson L000146 | rep | GA | 1895-12-02 | 1897-03-03 | Democrat | 8 | |||||||||||||
13060 | 13060 | Fernando Layton L000152 | rep | OH | 1895-12-02 | 1897-03-03 | Democrat | 4 | |||||||||||||
13071 | 13071 | James Lockhart L000391 | rep | NC | 1895-12-02 | 1897-03-03 | Democrat | 6 | |||||||||||||
13082 | 13082 | James McDearmon M000402 | rep | TN | 1895-12-02 | 1897-03-03 | Democrat | 9 | |||||||||||||
13085 | 13085 | Lawrence McGann M000441 | rep | IL | 1895-12-02 | 1897-03-03 | Democrat | 3 | |||||||||||||
13086 | 13086 | William McKenney M000502 | rep | VA | 1895-12-02 | 1897-03-03 | Democrat | 4 | |||||||||||||
13091 | 13091 | Elisha Meredith M000647 | rep | VA | 1895-12-02 | 1897-03-03 | Democrat | 8 | |||||||||||||
13092 | 13092 | Joshua Miles M000706 | rep | MD | 1895-12-02 | 1897-03-03 | Democrat | 1 | |||||||||||||
13095 | 13095 | Henry Miner M000792 | rep | NY | 1895-12-02 | 1897-03-03 | Democrat | 9 | |||||||||||||
13102 | 13102 | Charles Moses M001027 | rep | GA | 1895-12-02 | 1897-03-03 | Democrat | 4 | |||||||||||||
13109 | 13109 | Robert Neill N000025 | rep | AR | 1895-12-02 | 1897-03-03 | Democrat | 6 | |||||||||||||
13111 | 13111 | William Owens O000161 | rep | KY | 1895-12-02 | 1897-03-03 | Democrat | 7 | |||||||||||||
13114 | 13114 | Josiah Patterson P000124 | rep | TN | 1895-12-02 | 1897-03-03 | Democrat | 10 | |||||||||||||
13116 | 13116 | George Pendleton P000202 | rep | TX | 1895-12-02 | 1897-03-03 | Democrat | 7 | |||||||||||||
13135 | 13135 | Andrew Price P000521 | rep | LA | 1895-12-02 | 1897-03-03 | Democrat | 3 | |||||||||||||
13147 | 13147 | Harry Rusk R000516 | rep | MD | 1895-12-02 | 1897-03-03 | Democrat | 3 | |||||||||||||
13149 | 13149 | Benjamin Russell R000520 | rep | GA | 1895-12-02 | 1897-03-03 | Democrat | 2 | |||||||||||||
13159 | 13159 | John Shaw S000309 | rep | NC | 1895-12-02 | 1897-03-03 | Democrat | 3 | |||||||||||||
13163 | 13163 | Paul Sorg S000679 | rep | OH | 1895-12-02 | 1897-03-03 | Democrat | 3 | |||||||||||||
13164 | 13164 | James Spencer S000726 | rep | MS | 1895-12-02 | 1897-03-03 | Democrat | 7 | |||||||||||||
13176 | 13176 | John Tarsney T000043 | rep | MO | 1895-12-02 | 1897-03-03 | Democrat | 5 | |||||||||||||
13190 | 13190 | Henry Turner T000421 | rep | GA | 1895-12-02 | 1897-03-03 | Democrat | 11 | |||||||||||||
13192 | 13192 | Smith Turner T000427 | rep | VA | 1895-12-02 | 1897-03-03 | Democrat | 7 | |||||||||||||
13194 | 13194 | David Tyler T000448 | rep | VA | 1895-12-02 | 1897-03-03 | Democrat | 2 | |||||||||||||
13200 | 13200 | James Walsh W000098 | rep | NY | 1895-12-02 | 1897-03-03 | Democrat | 8 | |||||||||||||
13208 | 13208 | Joseph Washington W000181 | rep | TN | 1895-12-02 | 1897-03-03 | Democrat | 6 | |||||||||||||
13221 | 13221 | Frederick Woodard W000707 | rep | NC | 1895-12-02 | 1897-03-03 | Democrat | 2 | |||||||||||||
13225 | 13225 | Charles Yoakum Y000018 | rep | TX | 1895-12-02 | 1897-03-03 | Democrat | 3 | |||||||||||||
13273 | 13273 | John Clardy C000415 | rep | KY | 1895-12-02 | 1897-03-03 | Democrat | 2 | |||||||||||||
13296 | 13296 | Alexander Dockery D000384 | rep | MO | 1895-12-02 | 1897-03-03 | Democrat | 3 | |||||||||||||
13365 | 13365 | James Jones J000231 | sen | AR | 1891-12-07 | 1897-03-03 | 3 | Democrat | |||||||||||||
13385 | 13385 | James Maguire M000059 | rep | CA | 1895-12-02 | 1897-03-03 | Democrat | 4 | |||||||||||||
13400 | 13400 | John McLaurin M000543 | rep | SC | 1895-12-02 | 1897-03-03 | Democrat | 6 | |||||||||||||
13410 | 13410 | Benton McMillin M000575 | rep | TN | 1895-12-02 | 1897-03-03 | Democrat | 4 | |||||||||||||
13443 | 13443 | Henry Ogden O000044 | rep | LA | 1895-12-02 | 1897-03-03 | Democrat | 4 | |||||||||||||
13470 | 13470 | Joseph Sayers S000099 | rep | TX | 1895-12-02 | 1897-03-03 | Democrat | 9 | |||||||||||||
13497 | 13497 | Thomas Strait S000989 | rep | SC | 1895-12-02 | 1897-03-03 | Democrat | 5 | |||||||||||||
13517 | 13517 | George Vest V000091 | sen | MO | 1891-12-07 | 1897-03-03 | 3 | Democrat | |||||||||||||
13553 | 13553 | John Allen A000134 | rep | MS | 1895-12-02 | 1897-03-03 | Democrat | 1 | |||||||||||||
13573 | 13573 | Albert Berry B000414 | rep | KY | 1895-12-02 | 1897-03-03 | Democrat | 6 | |||||||||||||
13603 | 13603 | Thomas Catchings C000247 | rep | MS | 1895-12-02 | 1897-03-03 | Democrat | 3 | |||||||||||||
13623 | 13623 | Nicholas Cox C000838 | rep | TN | 1895-12-02 | 1897-03-03 | Democrat | 7 | |||||||||||||
13786 | 13786 | Gaston Robbins R000299 | rep | AL | 1895-12-02 | 1897-03-03 | Democrat | 4 | |||||||||||||
13795 | 13795 | Jesse Stallings S000784 | rep | AL | 1895-12-02 | 1897-03-03 | Democrat | 2 | |||||||||||||
13810 | 13810 | William Terry T000137 | rep | AR | 1895-12-02 | 1897-03-03 | Democrat | 4 | |||||||||||||
13827 | 13827 | Joseph Wheeler W000338 | rep | AL | 1895-12-02 | 1897-03-03 | Democrat | 8 | |||||||||||||
13834 | 13834 | Stanyarne Wilson W000612 | rep | SC | 1895-12-02 | 1897-03-03 | Democrat | 4 | |||||||||||||
13869 | 13869 | Joseph Blackburn B000508 | sen | KY | 1891-12-07 | 1897-03-03 | 3 | Democrat | |||||||||||||
13926 | 13926 | Amos Cummings C000983 | rep | NY | 1895-12-02 | 1897-03-03 | Democrat | 10 | |||||||||||||
13948 | 13948 | William Elliott E000129 | rep | SC | 1895-12-02 | 1897-03-03 | Democrat | 1 | |||||||||||||
14033 | 14033 | Rudolph Kleberg K000258 | rep | TX | 1895-12-02 | 1897-03-03 | Democrat | 11 | |||||||||||||
14058 | 14058 | Philip McCulloch M000391 | rep | AR | 1895-12-02 | 1897-03-03 | Democrat | 1 | |||||||||||||
14070 | 14070 | Thomas McRae M000597 | rep | AR | 1895-12-02 | 1897-03-03 | Democrat | 3 | |||||||||||||
14116 | 14116 | Peter Otey O000126 | rep | VA | 1895-12-02 | 1897-03-03 | Democrat | 6 | |||||||||||||
14191 | 14191 | James Stokes S000947 | rep | SC | 1895-12-02 | 1897-03-03 | Democrat | 7 | |||||||||||||
14198 | 14198 | William Talbert T000016 | rep | SC | 1895-12-02 | 1897-03-03 | Democrat | 2 | |||||||||||||
14293 | 14293 | Hugh Dinsmore D000358 | rep | AR | 1895-12-02 | 1897-03-03 | Democrat | 5 | |||||||||||||
14374 | 14374 | Asbury Latimer L000114 | rep | SC | 1895-12-02 | 1897-03-03 | Democrat | 3 | |||||||||||||
14390 | 14390 | John Maddox M000040 | rep | GA | 1895-12-02 | 1897-03-03 | Democrat | 7 | |||||||||||||
14401 | 14401 | George McClellan M000331 | rep | NY | 1895-12-02 | 1897-03-03 | Democrat | 12 | |||||||||||||
14411 | 14411 | James McCreary M000382 | rep | KY | 1895-12-02 | 1897-03-03 | Democrat | 8 | |||||||||||||
14455 | 14455 | James Richardson R000222 | rep | TN | 1895-12-02 | 1897-03-03 | Democrat | 5 |
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);