legislator_terms
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
438 rows where "end" is on date 1907-03-03 sorted by party
This data as json, copyable, CSV (advanced)
Suggested facets: start, class, party
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
13861 | 13861 | James Berry B000418 | sen | AR | 1901-12-02 | 1907-03-03 | 2 | Democrat | |||||||||||||
13870 | 13870 | Joseph Blackburn B000508 | sen | KY | 1901-12-02 | 1907-03-03 | 2 | Democrat | |||||||||||||
13904 | 13904 | Edward Carmack C000157 | sen | TN | 1901-12-02 | 1907-03-03 | 2 | Democrat | |||||||||||||
13906 | 13906 | William Clark C000454 | sen | MT | 1901-12-02 | 1907-03-03 | 2 | Democrat | |||||||||||||
13939 | 13939 | Fred Dubois D000509 | sen | ID | 1901-12-02 | 1907-03-03 | 2 | Democrat | |||||||||||||
14096 | 14096 | John Morgan M000954 | sen | AL | 1901-12-02 | 1907-03-03 | 2 | Democrat | |||||||||||||
14122 | 14122 | Thomas Patterson P000130 | sen | CO | 1901-12-02 | 1907-03-03 | 2 | Democrat | |||||||||||||
14336 | 14336 | Arthur Gorman G000326 | sen | MD | 1903-11-09 | 1907-03-03 | 3 | Democrat | |||||||||||||
14589 | 14589 | Sydney Bowie B000695 | rep | AL | 1905-12-04 | 1907-03-03 | Democrat | 4 | |||||||||||||
14590 | 14590 | Moses Broocks B000870 | rep | TX | 1905-12-04 | 1907-03-03 | Democrat | 2 | |||||||||||||
14614 | 14614 | Mounce Butler B001185 | rep | TN | 1905-12-04 | 1907-03-03 | Democrat | 4 | |||||||||||||
14631 | 14631 | Thomas Davis D000137 | rep | WV | 1905-12-04 | 1907-03-03 | Democrat | 2 | |||||||||||||
14653 | 14653 | Scott Field F000107 | rep | TX | 1905-12-04 | 1907-03-03 | Democrat | 6 | |||||||||||||
14666 | 14666 | Harvey Garber G000044 | rep | OH | 1905-12-04 | 1907-03-03 | Democrat | 4 | |||||||||||||
14667 | 14667 | John Gearin G000112 | sen | OR | 1905-12-04 | 1907-03-03 | 2 | Democrat | |||||||||||||
14671 | 14671 | George Gilbert G000174 | rep | KY | 1905-12-04 | 1907-03-03 | Democrat | 8 | |||||||||||||
14696 | 14696 | William Hearst H000429 | rep | NY | 1905-12-04 | 1907-03-03 | Democrat | 11 | |||||||||||||
14732 | 14732 | Francis Hopkins H000773 | rep | KY | 1905-12-04 | 1907-03-03 | Democrat | 10 | |||||||||||||
14734 | 14734 | John Hunt H000973 | rep | MO | 1905-12-04 | 1907-03-03 | Democrat | 11 | |||||||||||||
14759 | 14759 | Marcus Kline K000268 | rep | PA | 1905-12-04 | 1907-03-03 | Democrat | 13 | |||||||||||||
14779 | 14779 | Rufus Lester L000255 | rep | GA | 1905-12-04 | 1907-03-03 | Democrat | 1 | |||||||||||||
14792 | 14792 | John Little L000352 | rep | AR | 1905-12-04 | 1907-03-03 | Democrat | 4 | |||||||||||||
14821 | 14821 | Allan McDermott M000403 | rep | NJ | 1905-12-04 | 1907-03-03 | Democrat | 10 | |||||||||||||
14823 | 14823 | William McNary M000584 | rep | MA | 1905-12-04 | 1907-03-03 | Democrat | 10 | |||||||||||||
14858 | 14858 | Gilbert Patterson P000117 | rep | NC | 1905-12-04 | 1907-03-03 | Democrat | 6 | |||||||||||||
14861 | 14861 | Malcolm Patterson P000126 | rep | TN | 1905-12-04 | 1907-03-03 | Democrat | 10 | |||||||||||||
14864 | 14864 | John Pinckney P000356 | rep | TX | 1905-12-04 | 1907-03-03 | Democrat | 8 | |||||||||||||
14869 | 14869 | James Richardson R000223 | rep | KY | 1905-12-04 | 1907-03-03 | Democrat | 3 | |||||||||||||
14880 | 14880 | Samuel Robertson R000324 | rep | LA | 1905-12-04 | 1907-03-03 | Democrat | 6 | |||||||||||||
14884 | 14884 | Jacob Ruppert R000513 | rep | NY | 1905-12-04 | 1907-03-03 | Democrat | 16 | |||||||||||||
14900 | 14900 | David Smith S000525 | rep | KY | 1905-12-04 | 1907-03-03 | Democrat | 4 | |||||||||||||
14901 | 14901 | Thomas Smith S000618 | rep | MD | 1905-12-04 | 1907-03-03 | Democrat | 1 | |||||||||||||
14907 | 14907 | Robert Southall S000684 | rep | VA | 1905-12-04 | 1907-03-03 | Democrat | 4 | |||||||||||||
14915 | 14915 | John Sullivan S001055 | rep | MA | 1905-12-04 | 1907-03-03 | Democrat | 11 | |||||||||||||
14920 | 14920 | Charles Towne T000324 | rep | NY | 1905-12-04 | 1907-03-03 | Democrat | 14 | |||||||||||||
14923 | 14923 | South Trimble T000376 | rep | KY | 1905-12-04 | 1907-03-03 | Democrat | 7 | |||||||||||||
14926 | 14926 | Clarence Van Duzer V000033 | rep | NV | 1905-12-04 | 1907-03-03 | Democrat | 0 | |||||||||||||
14945 | 14945 | Frank Waskey W000184 | rep | AK | 1905-12-04 | 1907-03-03 | Democrat | 0 | |||||||||||||
14952 | 14952 | Ernest Wood W000693 | rep | MO | 1905-12-04 | 1907-03-03 | Democrat | 12 | |||||||||||||
14957 | 14957 | William Zenor Z000005 | rep | IN | 1905-12-04 | 1907-03-03 | Democrat | 3 | |||||||||||||
14974 | 14974 | Joseph Bailey B000044 | sen | TX | 1901-12-02 | 1907-03-03 | 2 | Democrat | |||||||||||||
15010 | 15010 | Stephen Brundidge B000979 | rep | AR | 1905-12-04 | 1907-03-03 | Democrat | 2 | |||||||||||||
15073 | 15073 | Robert Davey D000081 | rep | LA | 1905-12-04 | 1907-03-03 | Democrat | 2 | |||||||||||||
15100 | 15100 | Murphy Foster F000310 | sen | LA | 1901-12-02 | 1907-03-03 | 2 | Democrat | |||||||||||||
15118 | 15118 | John Gaines G000007 | rep | TN | 1905-12-04 | 1907-03-03 | Democrat | 6 | |||||||||||||
15127 | 15127 | Daniel Granger G000375 | rep | RI | 1905-12-04 | 1907-03-03 | Democrat | 1 | |||||||||||||
15154 | 15154 | Wilson Hill H000614 | rep | MS | 1905-12-04 | 1907-03-03 | Democrat | 4 | |||||||||||||
15176 | 15176 | William Kitchin K000252 | rep | NC | 1905-12-04 | 1907-03-03 | Democrat | 5 | |||||||||||||
15184 | 15184 | William Lamar L000031 | rep | FL | 1905-12-04 | 1907-03-03 | Democrat | 3 | |||||||||||||
15199 | 15199 | Elijah Lewis L000281 | rep | GA | 1905-12-04 | 1907-03-03 | Democrat | 3 | |||||||||||||
15219 | 15219 | Frank McLain M000533 | rep | MS | 1905-12-04 | 1907-03-03 | Democrat | 7 | |||||||||||||
15222 | 15222 | Anselm McLaurin M000542 | sen | MS | 1901-12-02 | 1907-03-03 | 2 | Democrat | |||||||||||||
15232 | 15232 | Adolph Meyer M000679 | rep | LA | 1905-12-04 | 1907-03-03 | Democrat | 1 | |||||||||||||
15269 | 15269 | John Rixey R000287 | rep | VA | 1905-12-04 | 1907-03-03 | Democrat | 8 | |||||||||||||
15274 | 15274 | William Ryan R000563 | rep | NY | 1905-12-04 | 1907-03-03 | Democrat | 35 | |||||||||||||
15309 | 15309 | Ariosto Wiley W000466 | rep | AL | 1905-12-04 | 1907-03-03 | Democrat | 2 | |||||||||||||
15352 | 15352 | Eaton Bowers B000689 | rep | MS | 1905-12-04 | 1907-03-03 | Democrat | 6 | |||||||||||||
15365 | 15365 | Adam Byrd B001207 | rep | MS | 1905-12-04 | 1907-03-03 | Democrat | 5 | |||||||||||||
15426 | 15426 | David De Armond D000167 | rep | MO | 1905-12-04 | 1907-03-03 | Democrat | 6 | |||||||||||||
15479 | 15479 | John Gill G000188 | rep | MD | 1905-12-04 | 1907-03-03 | Democrat | 4 | |||||||||||||
15483 | 15483 | Oscar Gillespie G000198 | rep | TX | 1905-12-04 | 1907-03-03 | Democrat | 12 | |||||||||||||
15511 | 15511 | James Griggs G000473 | rep | GA | 1905-12-04 | 1907-03-03 | Democrat | 2 | |||||||||||||
15526 | 15526 | William Howard H000848 | rep | GA | 1905-12-04 | 1907-03-03 | Democrat | 8 | |||||||||||||
15574 | 15574 | John Keliher K000055 | rep | MA | 1905-12-04 | 1907-03-03 | Democrat | 9 | |||||||||||||
15607 | 15607 | Leonidas Livingston L000368 | rep | GA | 1905-12-04 | 1907-03-03 | Democrat | 5 | |||||||||||||
15631 | 15631 | Harry Maynard M000283 | rep | VA | 1905-12-04 | 1907-03-03 | Democrat | 2 | |||||||||||||
15687 | 15687 | James Patterson P000118 | rep | SC | 1905-12-04 | 1907-03-03 | Democrat | 2 | |||||||||||||
15714 | 15714 | Charles Reid R000142 | rep | AR | 1905-12-04 | 1907-03-03 | Democrat | 5 | |||||||||||||
15720 | 15720 | Joseph Rhinock R000185 | rep | KY | 1905-12-04 | 1907-03-03 | Democrat | 6 | |||||||||||||
15726 | 15726 | Gordon Russell R000526 | rep | TX | 1905-12-04 | 1907-03-03 | Democrat | 3 | |||||||||||||
15758 | 15758 | Thomas Spight S000734 | rep | MS | 1905-12-04 | 1907-03-03 | Democrat | 2 | |||||||||||||
15783 | 15783 | Charles Thomas T000159 | rep | NC | 1905-12-04 | 1907-03-03 | Democrat | 3 | |||||||||||||
15799 | 15799 | Robert Wallace W000082 | rep | AR | 1905-12-04 | 1907-03-03 | Democrat | 7 | |||||||||||||
15815 | 15815 | Charles Weisse W000259 | rep | WI | 1905-12-04 | 1907-03-03 | Democrat | 6 | |||||||||||||
15883 | 15883 | William Brantley B000770 | rep | GA | 1905-12-04 | 1907-03-03 | Democrat | 11 | |||||||||||||
15958 | 15958 | James Ellerbe E000113 | rep | SC | 1905-12-04 | 1907-03-03 | Democrat | 6 | |||||||||||||
16030 | 16030 | John Lamb L000033 | rep | VA | 1905-12-04 | 1907-03-03 | Democrat | 3 | |||||||||||||
16050 | 16050 | George Lindsay L000324 | rep | NY | 1905-12-04 | 1907-03-03 | Democrat | 2 | |||||||||||||
16067 | 16067 | Robert Macon M000035 | rep | AR | 1905-12-04 | 1907-03-03 | Democrat | 1 | |||||||||||||
16114 | 16114 | John Moore M000904 | rep | TX | 1905-12-04 | 1907-03-03 | Democrat | 8 | |||||||||||||
16160 | 16160 | Arsène Pujo P000567 | rep | LA | 1905-12-04 | 1907-03-03 | Democrat | 7 | |||||||||||||
16166 | 16166 | Choice Randell R000042 | rep | TX | 1905-12-04 | 1907-03-03 | Democrat | 4 | |||||||||||||
16200 | 16200 | William Sulzer S001065 | rep | NY | 1905-12-04 | 1907-03-03 | Democrat | 10 | |||||||||||||
16257 | 16257 | Augustus Bacon B000014 | sen | GA | 1901-12-02 | 1907-03-03 | 2 | Democrat | |||||||||||||
16278 | 16278 | Charles Bartlett B000199 | rep | GA | 1905-12-04 | 1907-03-03 | Democrat | 6 | |||||||||||||
16285 | 16285 | James Beall B000270 | rep | TX | 1905-12-04 | 1907-03-03 | Democrat | 5 | |||||||||||||
16320 | 16320 | Albert Burleson B001110 | rep | TX | 1905-12-04 | 1907-03-03 | Democrat | 10 | |||||||||||||
16332 | 16332 | Henry Clayton C000495 | rep | AL | 1905-12-04 | 1907-03-03 | Democrat | 3 | |||||||||||||
16358 | 16358 | John Floyd F000222 | rep | AR | 1905-12-04 | 1907-03-03 | Democrat | 3 | |||||||||||||
16384 | 16384 | James Gudger G000514 | rep | NC | 1905-12-04 | 1907-03-03 | Democrat | 10 | |||||||||||||
16411 | 16411 | Ollie James J000051 | rep | KY | 1905-12-04 | 1907-03-03 | Democrat | 1 | |||||||||||||
16446 | 16446 | George Legaré L000219 | rep | SC | 1905-12-04 | 1907-03-03 | Democrat | 1 | |||||||||||||
16472 | 16472 | Thomas Martin M000200 | sen | VA | 1901-12-02 | 1907-03-03 | 2 | Democrat | |||||||||||||
16544 | 16544 | William Richardson R000227 | rep | AL | 1905-12-04 | 1907-03-03 | Democrat | 8 | |||||||||||||
16598 | 16598 | Timothy Sullivan S001061 | rep | NY | 1905-12-04 | 1907-03-03 | Democrat | 8 | |||||||||||||
16607 | 16607 | George Taylor T000078 | rep | AL | 1905-12-04 | 1907-03-03 | Democrat | 1 | |||||||||||||
16616 | 16616 | Benjamin Tillman T000274 | sen | SC | 1901-12-02 | 1907-03-03 | 2 | Democrat | |||||||||||||
16654 | 16654 | Thomas Hardwick H000193 | rep | GA | 1905-12-04 | 1907-03-03 | Democrat | 10 | |||||||||||||
16670 | 16670 | Wyatt Aiken A000064 | rep | SC | 1905-12-04 | 1907-03-03 | Democrat | 3 | |||||||||||||
16700 | 16700 | Robert Broussard B000896 | rep | LA | 1905-12-04 | 1907-03-03 | Democrat | 3 |
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);