legislator_terms
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
31 rows where class = 1 and "end" is on date 1905-03-03
This data as json, copyable, CSV (advanced)
Suggested facets: state, start, party, 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 | |||||||||||||
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 | |||||||||||||
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 | |||||||||||||
13805 | 13805 | William Stewart S000922 | sen | NV | 1899-12-04 | 1905-03-03 | 1 | Republican | |||||||||||||
13842 | 13842 | Thomas Bard B000138 | sen | CA | 1900-01-01 | 1905-03-03 | 1 | Republican | |||||||||||||
13935 | 13935 | Charles Dietrich D000341 | sen | NE | 1901-12-02 | 1905-03-03 | 1 | Republican | |||||||||||||
13966 | 13966 | Paris Gibson G000164 | sen | MT | 1901-12-02 | 1905-03-03 | 1 | Democrat | |||||||||||||
14031 | 14031 | Thomas Kearns K000034 | sen | UT | 1901-12-02 | 1905-03-03 | 1 | Republican | |||||||||||||
14544 | 14544 | Charles Dick D000302 | sen | OH | 1904-03-24 | 1905-03-03 | 1 | Republican | |||||||||||||
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 | |||||||||||||
15890 | 15890 | Moses Clapp C000414 | sen | MN | 1901-12-02 | 1905-03-03 | 1 | Republican | |||||||||||||
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 | |||||||||||||
17331 | 17331 | Philander Knox K000296 | sen | PA | 1904-06-10 | 1905-03-03 | 1 | Republican | |||||||||||||
17347 | 17347 | Porter McCumber M000397 | sen | ND | 1899-12-04 | 1905-03-03 | 1 | Republican | |||||||||||||
17544 | 17544 | Lewis Ball B000100 | sen | DE | 1903-11-09 | 1905-03-03 | 1 | Republican | |||||||||||||
18739 | 18739 | Henry Lodge L000393 | sen | MA | 1899-12-04 | 1905-03-03 | 1 | Republican |
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);