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 state
This data as json, copyable, CSV (advanced)
Suggested facets: type, start, 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
13351 | 13351 | Milford Howard H000843 | rep | AL | 1897-03-15 | 1899-03-03 | Populist | 7 | |||||||||||||
13453 | 13453 | Thomas Plowman P000388 | rep | AL | 1897-03-15 | 1899-03-03 | Democrat | 4 | |||||||||||||
13546 | 13546 | William Aldrich A000087 | rep | AL | 1897-03-15 | 1899-03-03 | Republican | 4 | |||||||||||||
13593 | 13593 | Willis Brewer B000812 | rep | AL | 1897-03-15 | 1899-03-03 | Democrat | 5 | |||||||||||||
13796 | 13796 | Jesse Stallings S000784 | rep | AL | 1897-03-15 | 1899-03-03 | Democrat | 2 | |||||||||||||
13828 | 13828 | Joseph Wheeler W000338 | rep | AL | 1897-03-15 | 1899-03-03 | Democrat | 8 | |||||||||||||
16328 | 16328 | Henry Clayton C000495 | rep | AL | 1897-03-15 | 1899-03-03 | Democrat | 3 | |||||||||||||
16603 | 16603 | George Taylor T000078 | rep | AL | 1897-03-15 | 1899-03-03 | Democrat | 1 | |||||||||||||
17551 | 17551 | John Bankhead B000110 | rep | AL | 1897-03-15 | 1899-03-03 | Democrat | 6 | |||||||||||||
18525 | 18525 | Oscar Underwood U000013 | rep | AL | 1897-03-15 | 1899-03-03 | Democrat | 9 | |||||||||||||
13811 | 13811 | William Terry T000137 | rep | AR | 1897-03-15 | 1899-03-03 | Democrat | 4 | |||||||||||||
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 | |||||||||||||
14294 | 14294 | Hugh Dinsmore D000358 | rep | AR | 1897-03-15 | 1899-03-03 | Democrat | 5 | |||||||||||||
14788 | 14788 | John Little L000352 | rep | AR | 1897-03-15 | 1899-03-03 | Democrat | 2 | |||||||||||||
15006 | 15006 | Stephen Brundidge B000979 | rep | AR | 1897-03-15 | 1899-03-03 | Democrat | 6 | |||||||||||||
16974 | 16974 | Marcus Smith S000589 | rep | AZ | 1897-03-15 | 1899-03-03 | Democrat | 0 | |||||||||||||
12852 | 12852 | Stephen White W000394 | sen | CA | 1893-08-07 | 1899-03-03 | 1 | Democrat | |||||||||||||
13243 | 13243 | Charles Barlow B000149 | rep | CA | 1897-03-15 | 1899-03-03 | Populist | 6 | |||||||||||||
13272 | 13272 | Curtis Castle C000241 | rep | CA | 1897-03-15 | 1899-03-03 | Populist | 7 | |||||||||||||
13331 | 13331 | Samuel Hilborn H000583 | rep | CA | 1897-03-15 | 1899-03-03 | Republican | 3 | |||||||||||||
13386 | 13386 | James Maguire M000059 | rep | CA | 1897-03-15 | 1899-03-03 | Democrat | 4 | |||||||||||||
13567 | 13567 | John Barham B000140 | rep | CA | 1897-03-15 | 1899-03-03 | Republican | 1 | |||||||||||||
13640 | 13640 | Marion De Vries D000277 | rep | CA | 1897-03-15 | 1899-03-03 | Democrat | 2 | |||||||||||||
14054 | 14054 | Eugene Loud L000448 | rep | CA | 1897-03-15 | 1899-03-03 | Republican | 5 | |||||||||||||
13852 | 13852 | John Bell B000341 | rep | CO | 1897-03-15 | 1899-03-03 | Populist | 2 | |||||||||||||
16560 | 16560 | John Shafroth S000279 | rep | CO | 1897-03-15 | 1899-03-03 | Silver Republican | 1 | |||||||||||||
13704 | 13704 | Joseph Hawley H000377 | sen | CT | 1893-08-07 | 1899-03-03 | 1 | Republican | |||||||||||||
14150 | 14150 | Charles Russell R000521 | rep | CT | 1897-03-15 | 1899-03-03 | Republican | 3 | |||||||||||||
15747 | 15747 | Nehemiah Sperry S000733 | rep | CT | 1897-03-15 | 1899-03-03 | Republican | 2 | |||||||||||||
15998 | 15998 | Edward Henry H000505 | rep | CT | 1897-03-15 | 1899-03-03 | Republican | 1 | |||||||||||||
17274 | 17274 | Ebenezer Hill H000591 | rep | CT | 1897-03-15 | 1899-03-03 | Republican | 4 | |||||||||||||
12586 | 12586 | George Gray G000396 | sen | DE | 1893-08-07 | 1899-03-03 | 1 | Democrat | |||||||||||||
13316 | 13316 | Levin Handy H000156 | rep | DE | 1897-03-15 | 1899-03-03 | Democrat | 0 | |||||||||||||
12751 | 12751 | Samuel Pasco P000095 | sen | FL | 1893-08-07 | 1899-03-03 | 1 | Democrat | |||||||||||||
14282 | 14282 | Robert Davis D000132 | rep | FL | 1897-03-15 | 1899-03-03 | Democrat | 2 | |||||||||||||
16988 | 16988 | Stephen Sparkman S000702 | rep | FL | 1897-03-15 | 1899-03-03 | Democrat | 1 | |||||||||||||
13956 | 13956 | William Fleming F000198 | rep | GA | 1897-03-15 | 1899-03-03 | Democrat | 10 | |||||||||||||
14391 | 14391 | John Maddox M000040 | rep | GA | 1897-03-15 | 1899-03-03 | Democrat | 7 | |||||||||||||
14488 | 14488 | Farish Tate T000046 | rep | GA | 1897-03-15 | 1899-03-03 | Democrat | 9 | |||||||||||||
14775 | 14775 | Rufus Lester L000255 | rep | GA | 1897-03-15 | 1899-03-03 | Democrat | 1 | |||||||||||||
15195 | 15195 | Elijah Lewis L000281 | rep | GA | 1897-03-15 | 1899-03-03 | Democrat | 3 | |||||||||||||
15507 | 15507 | James Griggs G000473 | rep | GA | 1897-03-15 | 1899-03-03 | Democrat | 2 | |||||||||||||
15522 | 15522 | William Howard H000848 | rep | GA | 1897-03-15 | 1899-03-03 | Democrat | 8 | |||||||||||||
15603 | 15603 | Leonidas Livingston L000368 | rep | GA | 1897-03-15 | 1899-03-03 | Democrat | 5 | |||||||||||||
15879 | 15879 | William Brantley B000770 | rep | GA | 1897-03-15 | 1899-03-03 | Democrat | 11 | |||||||||||||
16274 | 16274 | Charles Bartlett B000199 | rep | GA | 1897-03-15 | 1899-03-03 | Democrat | 6 | |||||||||||||
17044 | 17044 | William Adamson A000051 | rep | GA | 1897-03-15 | 1899-03-03 | Democrat | 4 | |||||||||||||
13276 | 13276 | Samuel Clark C000452 | rep | IA | 1897-03-15 | 1899-03-03 | Republican | 1 | |||||||||||||
13287 | 13287 | George Curtis C001010 | rep | IA | 1897-03-15 | 1899-03-03 | Republican | 2 | |||||||||||||
13315 | 13315 | Alva Hager H000015 | rep | IA | 1897-03-15 | 1899-03-03 | Republican | 9 | |||||||||||||
13449 | 13449 | George Perkins P000233 | rep | IA | 1897-03-15 | 1899-03-03 | Republican | 11 | |||||||||||||
13513 | 13513 | Thomas Updegraff U000019 | rep | IA | 1897-03-15 | 1899-03-03 | Republican | 4 | |||||||||||||
13997 | 13997 | David Henderson H000478 | rep | IA | 1897-03-15 | 1899-03-03 | Republican | 3 | |||||||||||||
14763 | 14763 | John Lacey L000010 | rep | IA | 1897-03-15 | 1899-03-03 | Republican | 6 | |||||||||||||
15044 | 15044 | Robert Cousins C000811 | rep | IA | 1897-03-15 | 1899-03-03 | Republican | 5 | |||||||||||||
15085 | 15085 | Jonathan Dolliver D000404 | rep | IA | 1897-03-15 | 1899-03-03 | Republican | 10 | |||||||||||||
15147 | 15147 | William Hepburn H000523 | rep | IA | 1897-03-15 | 1899-03-03 | Republican | 8 | |||||||||||||
15549 | 15549 | John Hull H000942 | rep | IA | 1897-03-15 | 1899-03-03 | Republican | 7 | |||||||||||||
13312 | 13312 | James Gunn G000525 | rep | ID | 1897-03-15 | 1899-03-03 | Populist | 1 | |||||||||||||
13241 | 13241 | Jehu Baker B000066 | rep | IL | 1897-03-15 | 1899-03-03 | Democrat | 21 | |||||||||||||
13256 | 13256 | Hugh Belknap B000329 | rep | IL | 1897-03-15 | 1899-03-03 | Republican | 3 | |||||||||||||
13271 | 13271 | James Campbell C000089 | rep | IL | 1897-03-15 | 1899-03-03 | Democrat | 20 | |||||||||||||
13282 | 13282 | James Connolly C000697 | rep | IL | 1897-03-15 | 1899-03-03 | Republican | 17 | |||||||||||||
13284 | 13284 | Edward Cooke C000731 | rep | IL | 1897-03-15 | 1899-03-03 | Republican | 6 | |||||||||||||
13332 | 13332 | William Hinrichsen H000637 | rep | IL | 1897-03-15 | 1899-03-03 | Democrat | 16 | |||||||||||||
13355 | 13355 | Andrew Hunter H000980 | rep | IL | 1897-03-15 | 1899-03-03 | Democrat | 19 | |||||||||||||
13422 | 13422 | Daniel Mills M000773 | rep | IL | 1897-03-15 | 1899-03-03 | Republican | 4 | |||||||||||||
13531 | 13531 | George White W000371 | rep | IL | 1897-03-15 | 1899-03-03 | Republican | 5 | |||||||||||||
14023 | 14023 | Thomas Jett J000102 | rep | IL | 1897-03-15 | 1899-03-03 | Democrat | 18 | |||||||||||||
14137 | 14137 | Walter Reeves R000139 | rep | IL | 1897-03-15 | 1899-03-03 | Republican | 11 | |||||||||||||
14353 | 14353 | Albert Hopkins H000770 | rep | IL | 1897-03-15 | 1899-03-03 | Republican | 8 | |||||||||||||
14522 | 14522 | Vespasian Warner W000158 | rep | IL | 1897-03-15 | 1899-03-03 | Republican | 13 | |||||||||||||
14723 | 14723 | Robert Hitt H000649 | rep | IL | 1897-03-15 | 1899-03-03 | Republican | 9 | |||||||||||||
14805 | 14805 | Benjamin Marsh M000145 | rep | IL | 1897-03-15 | 1899-03-03 | Republican | 15 | |||||||||||||
15293 | 15293 | George Smith S000541 | rep | IL | 1897-03-15 | 1899-03-03 | Republican | 22 | |||||||||||||
15344 | 15344 | Henry Boutell B000672 | rep | IL | 1897-03-15 | 1899-03-03 | Republican | 6 | |||||||||||||
15493 | 15493 | Joseph Graff G000351 | rep | IL | 1897-03-15 | 1899-03-03 | Republican | 14 | |||||||||||||
15611 | 15611 | William Lorimer L000444 | rep | IL | 1897-03-15 | 1899-03-03 | Republican | 2 | |||||||||||||
16151 | 16151 | George Prince P000538 | rep | IL | 1897-03-15 | 1899-03-03 | Republican | 10 | |||||||||||||
17196 | 17196 | George Foss F000295 | rep | IL | 1897-03-15 | 1899-03-03 | Republican | 7 | |||||||||||||
18104 | 18104 | Joseph Cannon C000121 | rep | IL | 1897-03-15 | 1899-03-03 | Republican | 12 | |||||||||||||
18322 | 18322 | James Mann M000104 | rep | IL | 1897-03-15 | 1899-03-03 | Republican | 1 | |||||||||||||
12835 | 12835 | David Turpie T000432 | sen | IN | 1893-08-07 | 1899-03-03 | 1 | Democrat | |||||||||||||
13324 | 13324 | Charles Henry H000503 | rep | IN | 1897-03-15 | 1899-03-03 | Republican | 8 | |||||||||||||
13349 | 13349 | William Holman H000732 | rep | IN | 1897-03-15 | 1899-03-03 | Democrat | 4 | |||||||||||||
13361 | 13361 | Henry Johnson J000138 | rep | IN | 1897-03-15 | 1899-03-03 | Republican | 6 | |||||||||||||
13462 | 13462 | Lemuel Royse R000490 | rep | IN | 1897-03-15 | 1899-03-03 | Republican | 13 | |||||||||||||
13663 | 13663 | George Faris F000016 | rep | IN | 1897-03-15 | 1899-03-03 | Republican | 5 | |||||||||||||
14182 | 14182 | George Steele S000830 | rep | IN | 1897-03-15 | 1899-03-03 | Republican | 11 | |||||||||||||
14337 | 14337 | Francis Griffith G000468 | rep | IN | 1897-03-15 | 1899-03-03 | Democrat | 4 | |||||||||||||
14416 | 14416 | Robert Miers M000700 | rep | IN | 1897-03-15 | 1899-03-03 | Democrat | 2 | |||||||||||||
14465 | 14465 | James Robinson R000338 | rep | IN | 1897-03-15 | 1899-03-03 | Democrat | 12 | |||||||||||||
14702 | 14702 | James Hemenway H000467 | rep | IN | 1897-03-15 | 1899-03-03 | Republican | 1 | |||||||||||||
14953 | 14953 | William Zenor Z000005 | rep | IN | 1897-03-15 | 1899-03-03 | Democrat | 3 | |||||||||||||
15186 | 15186 | Charles Landis L000050 | rep | IN | 1897-03-15 | 1899-03-03 | Republican | 9 | |||||||||||||
15238 | 15238 | Jesse Overstreet O000144 | rep | IN | 1897-03-15 | 1899-03-03 | Republican | 7 | |||||||||||||
15902 | 15902 | Edgar Crumpacker C000958 | rep | IN | 1897-03-15 | 1899-03-03 | Republican | 10 | |||||||||||||
13262 | 13262 | Jeremiah Botkin B000654 | rep | KS | 1897-03-15 | 1899-03-03 | Populist | -1 | |||||||||||||
13268 | 13268 | Case Broderick B000856 | rep | KS | 1897-03-15 | 1899-03-03 | Republican | 1 |
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);