legislator_terms
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
411 rows where "start" is on date 1899-12-04 sorted by district
This data as json, copyable, CSV (advanced)
Suggested facets: 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
13557 | 13557 | William Allen A000153 | sen | NE | 1899-12-04 | 1901-12-31 | 1 | Populist | |||||||||||||
13571 | 13571 | William Bate B000227 | sen | TN | 1899-12-04 | 1905-03-03 | 1 | Democrat | |||||||||||||
13620 | 13620 | Francis Cockrell C000576 | sen | MO | 1899-12-04 | 1905-03-03 | 1 | Democrat | |||||||||||||
13639 | 13639 | Cushman Davis D000095 | sen | MN | 1899-12-04 | 1901-03-03 | 1 | Republican | |||||||||||||
13667 | 13667 | Addison Foster F000298 | sen | WA | 1899-12-04 | 1905-03-03 | 1 | Republican | |||||||||||||
13684 | 13684 | Marcus Hanna H000163 | sen | OH | 1899-12-04 | 1905-03-03 | 1 | Republican | |||||||||||||
13705 | 13705 | Joseph Hawley H000377 | sen | CT | 1899-12-04 | 1905-03-03 | 1 | Republican | |||||||||||||
13708 | 13708 | Monroe Hayward H000409 | sen | NE | 1899-12-04 | 1899-12-31 | 1 | Republican | |||||||||||||
13740 | 13740 | Louis McComas M000351 | sen | MD | 1899-12-04 | 1905-03-03 | 1 | Republican | |||||||||||||
13769 | 13769 | Joseph Quarles Q000003 | sen | WI | 1899-12-04 | 1905-03-03 | 1 | Republican | |||||||||||||
13788 | 13788 | Jonathan Ross R000450 | sen | VT | 1899-12-04 | 1901-03-03 | 3 | Republican | |||||||||||||
13805 | 13805 | William Stewart S000922 | sen | NV | 1899-12-04 | 1905-03-03 | 1 | Republican | |||||||||||||
13905 | 13905 | William Clark C000454 | sen | MT | 1899-12-04 | 1901-03-03 | 1 | Democrat | |||||||||||||
14560 | 14560 | Nelson Aldrich A000083 | sen | RI | 1899-12-04 | 1905-03-03 | 1 | Republican | |||||||||||||
14573 | 14573 | Albert Beveridge B000429 | sen | IN | 1899-12-04 | 1905-03-03 | 1 | Republican | |||||||||||||
14612 | 14612 | Julius Burrows B001142 | sen | MI | 1899-12-04 | 1905-03-03 | 1 | Republican | |||||||||||||
14629 | 14629 | John Daniel D000035 | sen | VA | 1899-12-04 | 1905-03-03 | 1 | Democrat | |||||||||||||
14641 | 14641 | Chauncey Depew D000264 | sen | NY | 1899-12-04 | 1905-03-03 | 1 | Republican | |||||||||||||
14693 | 14693 | Eugene Hale H000029 | sen | ME | 1899-12-04 | 1905-03-03 | 1 | Republican | |||||||||||||
14737 | 14737 | John Kean K000028 | sen | NJ | 1899-12-04 | 1905-03-03 | 1 | Republican | |||||||||||||
14839 | 14839 | Hernando Money M000854 | sen | MS | 1899-12-04 | 1905-03-03 | 1 | Democrat | |||||||||||||
14867 | 14867 | Redfield Proctor P000547 | sen | VT | 1899-12-04 | 1905-03-03 | 1 | Republican | |||||||||||||
14887 | 14887 | Nathan Scott S000182 | sen | WV | 1899-12-04 | 1905-03-03 | 1 | Republican | |||||||||||||
14916 | 14916 | James Taliaferro T000026 | sen | FL | 1899-12-04 | 1905-03-03 | 1 | Democrat | |||||||||||||
15896 | 15896 | Clarence Clark C000425 | sen | WY | 1899-12-04 | 1905-03-03 | 1 | Republican | |||||||||||||
17125 | 17125 | Charles Culberson C000963 | sen | TX | 1899-12-04 | 1905-03-03 | 1 | Democrat | |||||||||||||
17347 | 17347 | Porter McCumber M000397 | sen | ND | 1899-12-04 | 1905-03-03 | 1 | Republican | |||||||||||||
18739 | 18739 | Henry Lodge L000393 | sen | MA | 1899-12-04 | 1905-03-03 | 1 | Republican | |||||||||||||
13559 | 13559 | Willis Bailey B000051 | rep | KS | 1899-12-04 | 1901-03-03 | Republican | -1 | |||||||||||||
13635 | 13635 | Samuel Davenport D000077 | rep | PA | 1899-12-04 | 1901-03-03 | Republican | -1 | |||||||||||||
13651 | 13651 | Nelson Dingley D000356 | rep | ME | 1899-12-04 | 1901-03-03 | Republican | -1 | |||||||||||||
13717 | 13717 | Warren Hooker H000760 | rep | NY | 1899-12-04 | 1901-03-03 | Republican | -1 | |||||||||||||
13759 | 13759 | Pedro Perea P000225 | rep | NM | 1899-12-04 | 1901-03-03 | Republican | -1 | |||||||||||||
13961 | 13961 | Dennis Flynn F000226 | rep | OK | 1899-12-04 | 1901-03-03 | Republican | -1 | |||||||||||||
13981 | 13981 | Galusha Grow G000507 | rep | PA | 1899-12-04 | 1901-03-03 | Republican | -1 | |||||||||||||
14216 | 14216 | Robert Wilcox W000459 | rep | HI | 1899-12-04 | 1901-03-03 | -1 | ||||||||||||||
15121 | 15121 | Robert Gamble G000032 | rep | SD | 1899-12-04 | 1901-03-03 | Republican | -1 | |||||||||||||
15410 | 15410 | Francis Cushman C001018 | rep | WA | 1899-12-04 | 1901-03-03 | Republican | -1 | |||||||||||||
16297 | 16297 | Charles Burke B001087 | rep | SD | 1899-12-04 | 1901-03-03 | Republican | -1 | |||||||||||||
19362 | 19362 | Wesley Jones J000257 | rep | WA | 1899-12-04 | 1901-03-03 | Republican | -1 | |||||||||||||
13711 | 13711 | John Hoffecker H000680 | rep | DE | 1899-12-04 | 1901-03-03 | Republican | 0 | |||||||||||||
13712 | 13712 | Walter Hoffecker H000681 | rep | DE | 1899-12-04 | 1901-03-03 | Republican | 0 | |||||||||||||
14534 | 14534 | John Wilson W000599 | rep | AZ | 1899-12-04 | 1901-03-03 | Democrat | 0 | |||||||||||||
16907 | 16907 | Francis Newlands N000069 | rep | NV | 1899-12-04 | 1901-03-03 | Democrat | 0 | |||||||||||||
18360 | 18360 | Franklin Mondell M000852 | rep | WY | 1899-12-04 | 1901-03-03 | Republican | 0 | |||||||||||||
13555 | 13555 | John Allen A000134 | rep | MS | 1899-12-04 | 1901-03-03 | Democrat | 1 | |||||||||||||
13568 | 13568 | John Barham B000140 | rep | CA | 1899-12-04 | 1901-03-03 | Republican | 1 | |||||||||||||
13597 | 13597 | Albert Campbell C000074 | rep | MT | 1899-12-04 | 1901-03-03 | Democrat | 1 | |||||||||||||
13719 | 13719 | Josiah Kerr K000142 | rep | MD | 1899-12-04 | 1901-03-03 | Republican | 1 | |||||||||||||
13765 | 13765 | Horace Powers P000490 | rep | VT | 1899-12-04 | 1901-03-03 | Republican | 1 | |||||||||||||
13782 | 13782 | Thomas Reed R000128 | rep | ME | 1899-12-04 | 1901-03-03 | Republican | 1 | |||||||||||||
13833 | 13833 | Edgar Wilson W000573 | rep | ID | 1899-12-04 | 1901-03-03 | Silver Republican | 1 | |||||||||||||
13896 | 13896 | Melville Bull B001048 | rep | RI | 1899-12-04 | 1901-03-03 | Republican | 1 | |||||||||||||
13914 | 13914 | John Corliss C000779 | rep | MI | 1899-12-04 | 1901-03-03 | Republican | 1 | |||||||||||||
13950 | 13950 | William Elliott E000129 | rep | SC | 1899-12-04 | 1901-03-03 | Democrat | 1 | |||||||||||||
14060 | 14060 | Philip McCulloch M000391 | rep | AR | 1899-12-04 | 1901-03-03 | Democrat | 1 | |||||||||||||
14158 | 14158 | William Shattuc S000300 | rep | OH | 1899-12-04 | 1901-03-03 | Republican | 1 | |||||||||||||
14213 | 14213 | Charles Wheeler W000331 | rep | KY | 1899-12-04 | 1901-03-03 | Democrat | 1 | |||||||||||||
14241 | 14241 | Thomas Ball B000101 | rep | TX | 1899-12-04 | 1901-03-03 | Democrat | 1 | |||||||||||||
14473 | 14473 | Townsend Scudder S000202 | rep | NY | 1899-12-04 | 1901-03-03 | Democrat | 1 | |||||||||||||
14481 | 14481 | Burleigh Spalding S000695 | rep | ND | 1899-12-04 | 1901-03-03 | Republican | 1 | |||||||||||||
14507 | 14507 | Thomas Tongue T000309 | rep | OR | 1899-12-04 | 1901-03-03 | Republican | 1 | |||||||||||||
14599 | 14599 | Elmer Burkett B001103 | rep | NE | 1899-12-04 | 1901-03-03 | Republican | 1 | |||||||||||||
14646 | 14646 | Blackburn Dovener D000461 | rep | WV | 1899-12-04 | 1901-03-03 | Republican | 1 | |||||||||||||
14697 | 14697 | Thomas Hedge H000441 | rep | IA | 1899-12-04 | 1901-03-03 | Republican | 1 | |||||||||||||
14703 | 14703 | James Hemenway H000467 | rep | IN | 1899-12-04 | 1901-03-03 | Republican | 1 | |||||||||||||
14776 | 14776 | Rufus Lester L000255 | rep | GA | 1899-12-04 | 1901-03-03 | Democrat | 1 | |||||||||||||
15229 | 15229 | Adolph Meyer M000679 | rep | LA | 1899-12-04 | 1901-03-03 | Democrat | 1 | |||||||||||||
15330 | 15330 | Amos Allen A000112 | rep | ME | 1899-12-04 | 1901-03-03 | Republican | 1 | |||||||||||||
15358 | 15358 | Walter Brownlow B000962 | rep | TN | 1899-12-04 | 1901-03-03 | Republican | 1 | |||||||||||||
15773 | 15773 | James Tawney T000060 | rep | MN | 1899-12-04 | 1901-03-03 | Republican | 1 | |||||||||||||
15864 | 15864 | Henry Bingham B000469 | rep | PA | 1899-12-04 | 1901-03-03 | Republican | 1 | |||||||||||||
15999 | 15999 | Edward Henry H000505 | rep | CT | 1899-12-04 | 1901-03-03 | Republican | 1 | |||||||||||||
16037 | 16037 | George Lawrence L000133 | rep | MA | 1899-12-04 | 1901-03-03 | Republican | 1 | |||||||||||||
16059 | 16059 | Henry Loudenslager L000450 | rep | NJ | 1899-12-04 | 1901-03-03 | Republican | 1 | |||||||||||||
16561 | 16561 | John Shafroth S000279 | rep | CO | 1899-12-04 | 1901-03-03 | Silver Republican | 1 | |||||||||||||
16604 | 16604 | George Taylor T000078 | rep | AL | 1899-12-04 | 1901-03-03 | Democrat | 1 | |||||||||||||
16856 | 16856 | James Lloyd L000380 | rep | MO | 1899-12-04 | 1901-03-03 | Democrat | 1 | |||||||||||||
16966 | 16966 | John Smith S000577 | rep | MD | 1899-12-04 | 1900-01-12 | Democrat | 1 | |||||||||||||
16989 | 16989 | Stephen Sparkman S000702 | rep | FL | 1899-12-04 | 1901-03-03 | Democrat | 1 | |||||||||||||
17313 | 17313 | William Jones J000259 | rep | VA | 1899-12-04 | 1901-03-03 | Democrat | 1 | |||||||||||||
17459 | 17459 | Cyrus Sulloway S001063 | rep | NH | 1899-12-04 | 1901-03-03 | Republican | 1 | |||||||||||||
17945 | 17945 | John Small S000500 | rep | NC | 1899-12-04 | 1901-03-03 | Democrat | 1 | |||||||||||||
18323 | 18323 | James Mann M000104 | rep | IL | 1899-12-04 | 1901-03-03 | Republican | 1 | |||||||||||||
19272 | 19272 | Charles Curtis C001008 | rep | KS | 1899-12-04 | 1901-03-03 | Republican | 1 | |||||||||||||
20234 | 20234 | Henry Cooper C000752 | rep | WI | 1899-12-04 | 1901-03-03 | Republican | 1 | |||||||||||||
21841 | 21841 | William King K000216 | rep | UT | 1899-12-04 | 1901-03-03 | Democrat | 1 | |||||||||||||
13564 | 13564 | William Baker B000076 | rep | MD | 1899-12-04 | 1901-03-03 | Republican | 2 | |||||||||||||
13612 | 13612 | Frank Clarke C000460 | rep | NH | 1899-12-04 | 1901-03-03 | Republican | 2 | |||||||||||||
13641 | 13641 | Marion De Vries D000277 | rep | CA | 1899-12-04 | 1901-03-03 | Democrat | 2 | |||||||||||||
13682 | 13682 | William Grout G000501 | rep | VT | 1899-12-04 | 1901-03-03 | Republican | 2 | |||||||||||||
13723 | 13723 | Joseph Lane L000063 | rep | IA | 1899-12-04 | 1901-03-03 | Republican | 2 | |||||||||||||
13797 | 13797 | Jesse Stallings S000784 | rep | AL | 1899-12-04 | 1901-03-03 | Democrat | 2 | |||||||||||||
13831 | 13831 | George White W000372 | rep | NC | 1899-12-04 | 1901-03-03 | Republican | 2 | |||||||||||||
13838 | 13838 | Richard Wise W000653 | rep | VA | 1899-12-04 | 1901-03-03 | Republican | 2 | |||||||||||||
13840 | 13840 | William Young Y000056 | rep | VA | 1899-12-04 | 1901-03-03 | Democrat | 2 | |||||||||||||
13843 | 13843 | Henry Allen A000125 | rep | KY | 1899-12-04 | 1901-03-03 | Democrat | 2 | |||||||||||||
13853 | 13853 | John Bell B000341 | rep | CO | 1899-12-04 | 1901-03-03 | Populist | 2 | |||||||||||||
13885 | 13885 | Jacob Bromwell B000866 | rep | OH | 1899-12-04 | 1901-03-03 | Republican | 2 | |||||||||||||
13930 | 13930 | Herman Dahle D000005 | rep | WI | 1899-12-04 | 1901-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);