legislator_terms
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
406 rows where "start" is on date 1897-03-15 sorted by party
This data as json, copyable, CSV (advanced)
Suggested facets: state, end, class, district, 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 | |||||||||||||
13299 | 13299 | Joseph Earle E000009 | sen | SC | 1897-03-15 | 1897-12-31 | 3 | Democrat | |||||||||||||
13316 | 13316 | Levin Handy H000156 | rep | DE | 1897-03-15 | 1899-03-03 | Democrat | 0 | |||||||||||||
13322 | 13322 | Henry Heitfeld H000458 | sen | ID | 1897-03-15 | 1903-03-03 | 3 | Democrat | |||||||||||||
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 | |||||||||||||
13366 | 13366 | James Jones J000231 | sen | AR | 1897-03-15 | 1903-03-03 | 3 | Democrat | |||||||||||||
13374 | 13374 | Richard Kenney K000121 | sen | DE | 1897-03-15 | 1901-03-03 | 2 | Democrat | |||||||||||||
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 | |||||||||||||
13401 | 13401 | John McLaurin M000543 | sen | SC | 1897-03-15 | 1903-03-03 | 3 | Democrat | |||||||||||||
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 | |||||||||||||
13460 | 13460 | Joseph Rawlins R000073 | sen | UT | 1897-03-15 | 1903-03-03 | 3 | Democrat | |||||||||||||
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 | |||||||||||||
13507 | 13507 | Thomas Turley T000412 | sen | TN | 1897-03-15 | 1901-03-03 | 2 | Democrat | |||||||||||||
13508 | 13508 | George Turner T000420 | sen | WA | 1897-03-15 | 1903-03-03 | 3 | Democrat | |||||||||||||
13514 | 13514 | John Vehslage V000080 | rep | NY | 1897-03-15 | 1899-03-03 | Democrat | 7 | |||||||||||||
13518 | 13518 | George Vest V000091 | sen | MO | 1897-03-15 | 1903-03-03 | 3 | Democrat | |||||||||||||
13543 | 13543 | William Sullivan S001062 | rep | MS | 1897-03-15 | 1898-05-31 | Democrat | 2 | |||||||||||||
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 | |||||||||||||
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 | |||||||||||||
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 | |||||||||||||
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 | |||||||||||||
14399 | 14399 | Stephen Mallory M000085 | sen | FL | 1897-03-15 | 1903-03-03 | 3 | Democrat | |||||||||||||
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 | |||||||||||||
14424 | 14424 | Edmund Pettus P000279 | sen | AL | 1897-03-15 | 1903-03-03 | 3 | Democrat | |||||||||||||
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 | |||||||||||||
14496 | 14496 | Henry Teller T000116 | sen | CO | 1897-03-15 | 1903-03-03 | 3 | Democrat | |||||||||||||
14516 | 14516 | Willard Vandiver V000032 | rep | MO | 1897-03-15 | 1899-03-03 | Democrat | 14 | |||||||||||||
14775 | 14775 | Rufus Lester L000255 | rep | GA | 1897-03-15 | 1899-03-03 | Democrat | 1 | |||||||||||||
14788 | 14788 | John Little L000352 | rep | AR | 1897-03-15 | 1899-03-03 | Democrat | 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);