legislator_terms
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
221 rows where party = "Republican" and "start" is on date 1899-12-04
This data as json, copyable, CSV (advanced)
Suggested facets: type, class, start (date), 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
13547 | 13547 | William Aldrich A000087 | rep | AL | 1899-12-04 | 1901-03-03 | Republican | 4 | |||||||||||||
13559 | 13559 | Willis Bailey B000051 | rep | KS | 1899-12-04 | 1901-03-03 | Republican | -1 | |||||||||||||
13564 | 13564 | William Baker B000076 | rep | MD | 1899-12-04 | 1901-03-03 | Republican | 2 | |||||||||||||
13568 | 13568 | John Barham B000140 | rep | CA | 1899-12-04 | 1901-03-03 | Republican | 1 | |||||||||||||
13596 | 13596 | Seth Brown B000943 | rep | OH | 1899-12-04 | 1901-03-03 | Republican | 6 | |||||||||||||
13610 | 13610 | Charles Chickering C000351 | rep | NY | 1899-12-04 | 1901-03-03 | Republican | 24 | |||||||||||||
13612 | 13612 | Frank Clarke C000460 | rep | NH | 1899-12-04 | 1901-03-03 | Republican | 2 | |||||||||||||
13615 | 13615 | Aaron Cochrane C000568 | rep | NY | 1899-12-04 | 1901-03-03 | Republican | 19 | |||||||||||||
13633 | 13633 | Lorenzo Danford D000028 | rep | OH | 1899-12-04 | 1901-03-03 | Republican | 16 | |||||||||||||
13635 | 13635 | Samuel Davenport D000077 | rep | PA | 1899-12-04 | 1901-03-03 | Republican | -1 | |||||||||||||
13639 | 13639 | Cushman Davis D000095 | sen | MN | 1899-12-04 | 1901-03-03 | 1 | Republican | |||||||||||||
13651 | 13651 | Nelson Dingley D000356 | rep | ME | 1899-12-04 | 1901-03-03 | Republican | -1 | |||||||||||||
13664 | 13664 | George Faris F000016 | rep | IN | 1899-12-04 | 1901-03-03 | Republican | 5 | |||||||||||||
13667 | 13667 | Addison Foster F000298 | sen | WA | 1899-12-04 | 1905-03-03 | 1 | Republican | |||||||||||||
13668 | 13668 | Romeo Freer F000367 | rep | WV | 1899-12-04 | 1901-03-03 | Republican | 4 | |||||||||||||
13682 | 13682 | William Grout G000501 | rep | VT | 1899-12-04 | 1901-03-03 | Republican | 2 | |||||||||||||
13684 | 13684 | Marcus Hanna H000163 | sen | OH | 1899-12-04 | 1905-03-03 | 1 | Republican | |||||||||||||
13698 | 13698 | Alfred Harmer H000215 | rep | PA | 1899-12-04 | 1901-03-03 | Republican | 5 | |||||||||||||
13705 | 13705 | Joseph Hawley H000377 | sen | CT | 1899-12-04 | 1905-03-03 | 1 | Republican | |||||||||||||
13707 | 13707 | Robert Hawley H000378 | rep | TX | 1899-12-04 | 1901-03-03 | Republican | 10 | |||||||||||||
13708 | 13708 | Monroe Hayward H000409 | sen | NE | 1899-12-04 | 1899-12-31 | 1 | Republican | |||||||||||||
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 | |||||||||||||
13717 | 13717 | Warren Hooker H000760 | rep | NY | 1899-12-04 | 1901-03-03 | Republican | -1 | |||||||||||||
13719 | 13719 | Josiah Kerr K000142 | rep | MD | 1899-12-04 | 1901-03-03 | Republican | 1 | |||||||||||||
13722 | 13722 | Winfield Kerr K000145 | rep | OH | 1899-12-04 | 1901-03-03 | Republican | 14 | |||||||||||||
13723 | 13723 | Joseph Lane L000063 | rep | IA | 1899-12-04 | 1901-03-03 | Republican | 2 | |||||||||||||
13728 | 13728 | Romulus Linney L000339 | rep | NC | 1899-12-04 | 1901-03-03 | Republican | 8 | |||||||||||||
13730 | 13730 | Archibald Lybrand L000523 | rep | OH | 1899-12-04 | 1901-03-03 | Republican | 8 | |||||||||||||
13740 | 13740 | Louis McComas M000351 | sen | MD | 1899-12-04 | 1905-03-03 | 1 | Republican | |||||||||||||
13743 | 13743 | Smith McPherson M000594 | rep | IA | 1899-12-04 | 1901-03-03 | Republican | 9 | |||||||||||||
13747 | 13747 | William Mesick M000666 | rep | MI | 1899-12-04 | 1901-03-03 | Republican | 11 | |||||||||||||
13751 | 13751 | James O’Grady O000051 | rep | NY | 1899-12-04 | 1901-03-03 | Republican | 31 | |||||||||||||
13753 | 13753 | Horace Packer P000007 | rep | PA | 1899-12-04 | 1901-03-03 | Republican | 16 | |||||||||||||
13755 | 13755 | Charles Pearce P000582 | rep | MO | 1899-12-04 | 1901-03-03 | Republican | 12 | |||||||||||||
13758 | 13758 | Richmond Pearson P000169 | rep | NC | 1899-12-04 | 1901-03-03 | Republican | 9 | |||||||||||||
13759 | 13759 | Pedro Perea P000225 | rep | NM | 1899-12-04 | 1901-03-03 | Republican | -1 | |||||||||||||
13760 | 13760 | Fremont Phillips P000307 | rep | OH | 1899-12-04 | 1901-03-03 | Republican | 20 | |||||||||||||
13765 | 13765 | Horace Powers P000490 | rep | VT | 1899-12-04 | 1901-03-03 | Republican | 1 | |||||||||||||
13768 | 13768 | Samuel Pugh P000564 | rep | KY | 1899-12-04 | 1901-03-03 | Republican | 9 | |||||||||||||
13769 | 13769 | Joseph Quarles Q000003 | sen | WI | 1899-12-04 | 1905-03-03 | 1 | Republican | |||||||||||||
13782 | 13782 | Thomas Reed R000128 | rep | ME | 1899-12-04 | 1901-03-03 | Republican | 1 | |||||||||||||
13788 | 13788 | Jonathan Ross R000450 | sen | VT | 1899-12-04 | 1901-03-03 | 3 | Republican | |||||||||||||
13793 | 13793 | Charles Sprague S000742 | rep | MA | 1899-12-04 | 1901-03-03 | Republican | 11 | |||||||||||||
13800 | 13800 | Alexander Stewart S000898 | rep | WI | 1899-12-04 | 1901-03-03 | Republican | 9 | |||||||||||||
13805 | 13805 | William Stewart S000922 | sen | NV | 1899-12-04 | 1905-03-03 | 1 | Republican | |||||||||||||
13813 | 13813 | Joseph Thropp T000248 | rep | PA | 1899-12-04 | 1901-03-03 | Republican | 20 | |||||||||||||
13816 | 13816 | Russell Waters W000188 | rep | CA | 1899-12-04 | 1901-03-03 | Republican | 6 | |||||||||||||
13818 | 13818 | Walter Weaver W000229 | rep | OH | 1899-12-04 | 1901-03-03 | Republican | 7 | |||||||||||||
13820 | 13820 | George Weymouth W000316 | rep | MA | 1899-12-04 | 1901-03-03 | Republican | 4 | |||||||||||||
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 | |||||||||||||
13848 | 13848 | Samuel Barney B000163 | rep | WI | 1899-12-04 | 1901-03-03 | Republican | 5 | |||||||||||||
13879 | 13879 | Charles Boutelle B000673 | rep | ME | 1899-12-04 | 1901-03-03 | Republican | 4 | |||||||||||||
13885 | 13885 | Jacob Bromwell B000866 | rep | OH | 1899-12-04 | 1901-03-03 | Republican | 2 | |||||||||||||
13892 | 13892 | Marriott Brosius B000892 | rep | PA | 1899-12-04 | 1901-03-03 | Republican | 10 | |||||||||||||
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 | |||||||||||||
13920 | 13920 | Rousseau Crump C000957 | rep | MI | 1899-12-04 | 1901-03-03 | Republican | 10 | |||||||||||||
13930 | 13930 | Herman Dahle D000005 | rep | WI | 1899-12-04 | 1901-03-03 | Republican | 2 | |||||||||||||
13942 | 13942 | Frank Eddy E000038 | rep | MN | 1899-12-04 | 1901-03-03 | Republican | 7 | |||||||||||||
13952 | 13952 | Louis Emerson E000173 | rep | NY | 1899-12-04 | 1901-03-03 | Republican | 23 | |||||||||||||
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 | |||||||||||||
13988 | 13988 | Joel Heatwole H000434 | rep | MN | 1899-12-04 | 1901-03-03 | Republican | 3 | |||||||||||||
13998 | 13998 | David Henderson H000478 | rep | IA | 1899-12-04 | 1901-03-03 | Republican | 3 | |||||||||||||
14020 | 14020 | Summers Jack J000001 | rep | PA | 1899-12-04 | 1901-03-03 | Republican | 21 | |||||||||||||
14029 | 14029 | Charles Joy J000274 | rep | MO | 1899-12-04 | 1901-03-03 | Republican | 11 | |||||||||||||
14039 | 14039 | William Knox K000299 | rep | MA | 1899-12-04 | 1901-03-03 | Republican | 5 | |||||||||||||
14055 | 14055 | Eugene Loud L000448 | rep | CA | 1899-12-04 | 1901-03-03 | Republican | 5 | |||||||||||||
14077 | 14077 | David Mercer M000643 | rep | NE | 1899-12-04 | 1901-03-03 | Republican | 2 | |||||||||||||
14086 | 14086 | Malcolm Moody M000882 | rep | OR | 1899-12-04 | 1901-03-03 | Republican | 2 | |||||||||||||
14090 | 14090 | William Moody M000883 | rep | MA | 1899-12-04 | 1901-03-03 | Republican | 6 | |||||||||||||
14098 | 14098 | Robert Morris M000986 | rep | MN | 1899-12-04 | 1901-03-03 | Republican | 6 | |||||||||||||
14134 | 14134 | George Ray R000076 | rep | NY | 1899-12-04 | 1901-03-03 | Republican | 26 | |||||||||||||
14138 | 14138 | Walter Reeves R000139 | rep | IL | 1899-12-04 | 1901-03-03 | Republican | 11 | |||||||||||||
14151 | 14151 | Charles Russell R000521 | rep | CT | 1899-12-04 | 1901-03-03 | Republican | 3 | |||||||||||||
14158 | 14158 | William Shattuc S000300 | rep | OH | 1899-12-04 | 1901-03-03 | Republican | 1 | |||||||||||||
14160 | 14160 | Albert Shaw S000302 | rep | NY | 1899-12-04 | 1901-03-03 | Republican | 24 | |||||||||||||
14163 | 14163 | Carlos Shelden S000321 | rep | MI | 1899-12-04 | 1901-03-03 | Republican | 12 | |||||||||||||
14168 | 14168 | Joseph Showalter S000385 | rep | PA | 1899-12-04 | 1901-03-03 | Republican | 25 | |||||||||||||
14170 | 14170 | Henry Smith S000547 | rep | MI | 1899-12-04 | 1901-03-03 | Republican | 2 | |||||||||||||
14183 | 14183 | George Steele S000830 | rep | IN | 1899-12-04 | 1901-03-03 | Republican | 11 | |||||||||||||
14187 | 14187 | James Stewart S000911 | rep | NJ | 1899-12-04 | 1901-03-03 | Republican | 5 | |||||||||||||
14189 | 14189 | John Stewart S000916 | rep | NY | 1899-12-04 | 1901-03-03 | Republican | 21 | |||||||||||||
14204 | 14204 | Robert Tayler T000061 | rep | OH | 1899-12-04 | 1901-03-03 | Republican | 18 | |||||||||||||
14206 | 14206 | Arthur Tompkins T000302 | rep | NY | 1899-12-04 | 1901-03-03 | Republican | 17 | |||||||||||||
14210 | 14210 | Edgar Weeks W000243 | rep | MI | 1899-12-04 | 1901-03-03 | Republican | 7 | |||||||||||||
14218 | 14218 | Samuel Woods W000726 | rep | CA | 1899-12-04 | 1901-03-03 | Republican | 2 | |||||||||||||
14222 | 14222 | James Young Y000041 | rep | PA | 1899-12-04 | 1901-03-03 | Republican | 4 | |||||||||||||
14251 | 14251 | Vincent Boreing B000637 | rep | KY | 1899-12-04 | 1901-03-03 | Republican | 11 | |||||||||||||
14269 | 14269 | William Connell C000687 | rep | PA | 1899-12-04 | 1901-03-03 | Republican | 11 | |||||||||||||
14319 | 14319 | Henry Gibson G000161 | rep | TN | 1899-12-04 | 1901-03-03 | Republican | 2 | |||||||||||||
14322 | 14322 | Joseph Gill G000189 | rep | OH | 1899-12-04 | 1901-03-03 | Republican | 16 | |||||||||||||
14328 | 14328 | Charles Gillet G000199 | rep | NY | 1899-12-04 | 1901-03-03 | Republican | 29 | |||||||||||||
14354 | 14354 | Albert Hopkins H000770 | rep | IL | 1899-12-04 | 1901-03-03 | Republican | 8 | |||||||||||||
14385 | 14385 | Chester Long L000412 | rep | KS | 1899-12-04 | 1901-03-03 | Republican | 7 | |||||||||||||
14413 | 14413 | Victor Metcalf M000672 | rep | CA | 1899-12-04 | 1901-03-03 | Republican | 3 | |||||||||||||
14420 | 14420 | Stephen Morgan M000957 | rep | OH | 1899-12-04 | 1901-03-03 | Republican | 10 | |||||||||||||
14481 | 14481 | Burleigh Spalding S000695 | rep | ND | 1899-12-04 | 1901-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);