legislator_terms
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
444 rows where "end" is on date 1911-03-03 sorted by legislator_id
This data as json, copyable, CSV (advanced)
Suggested facets: state, 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
16665 | 16665 | John Adair A000027 | rep | IN | 1909-03-15 | 1911-03-03 | Democrat | 8 | |||||||||||||
17050 | 17050 | William Adamson A000051 | rep | GA | 1909-03-15 | 1911-03-03 | Democrat | 4 | |||||||||||||
16672 | 16672 | Wyatt Aiken A000064 | rep | SC | 1909-03-15 | 1911-03-03 | Democrat | 3 | |||||||||||||
14561 | 14561 | Nelson Aldrich A000083 | sen | RI | 1905-12-04 | 1911-03-03 | 1 | Republican | |||||||||||||
15329 | 15329 | De Alexander A000091 | rep | NY | 1909-03-15 | 1911-03-03 | Republican | 36 | |||||||||||||
17533 | 17533 | Joshua Alexander A000098 | rep | MO | 1909-03-15 | 1911-03-03 | Democrat | 3 | |||||||||||||
15335 | 15335 | Amos Allen A000112 | rep | ME | 1909-03-15 | 1911-03-03 | Republican | 1 | |||||||||||||
15835 | 15835 | Butler Ames A000173 | rep | MA | 1909-03-15 | 1911-03-03 | Republican | 5 | |||||||||||||
15837 | 15837 | Carl Anderson A000182 | rep | OH | 1909-03-15 | 1911-03-03 | Democrat | 13 | |||||||||||||
15841 | 15841 | William Andrews A000252 | rep | NM | 1909-03-15 | 1911-03-03 | Republican | -1 | |||||||||||||
15845 | 15845 | John Andrus A000254 | rep | NY | 1909-03-15 | 1911-03-03 | Republican | 19 | |||||||||||||
16252 | 16252 | Timothy Ansberry A000259 | rep | OH | 1909-03-15 | 1911-03-03 | Democrat | 5 | |||||||||||||
19188 | 19188 | Daniel Anthony A000261 | rep | KS | 1909-03-15 | 1911-03-03 | Republican | 1 | |||||||||||||
22477 | 22477 | William Ashbrook A000306 | rep | OH | 1909-03-15 | 1911-03-03 | Democrat | 17 | |||||||||||||
17055 | 17055 | Richard Austin A000341 | rep | TN | 1909-03-15 | 1911-03-03 | Republican | 2 | |||||||||||||
16683 | 16683 | Andrew Barchfeld B000133 | rep | PA | 1909-03-15 | 1911-03-03 | Republican | 32 | |||||||||||||
15337 | 15337 | Charles Barclay B000135 | rep | PA | 1909-03-15 | 1911-03-03 | Republican | 21 | |||||||||||||
15338 | 15338 | William Barnard B000155 | rep | IN | 1909-03-15 | 1911-03-03 | Republican | 6 | |||||||||||||
17062 | 17062 | Henry Barnhart B000164 | rep | IN | 1909-03-15 | 1911-03-03 | Democrat | 13 | |||||||||||||
16270 | 16270 | Richard Bartholdt B000196 | rep | MO | 1909-03-15 | 1911-03-03 | Republican | 10 | |||||||||||||
16280 | 16280 | Charles Bartlett B000199 | rep | GA | 1909-03-15 | 1911-03-03 | Democrat | 6 | |||||||||||||
15340 | 15340 | George Bartlett B000203 | rep | NV | 1909-03-15 | 1911-03-03 | Democrat | 0 | |||||||||||||
15852 | 15852 | Arthur Bates B000230 | rep | PA | 1909-03-15 | 1911-03-03 | Republican | 25 | |||||||||||||
16287 | 16287 | James Beall B000270 | rep | TX | 1909-03-15 | 1911-03-03 | Democrat | 5 | |||||||||||||
19576 | 19576 | Thomas Bell B000348 | rep | GA | 1909-03-15 | 1911-03-03 | Democrat | 9 | |||||||||||||
16692 | 16692 | William Bennet B000370 | rep | NY | 1909-03-15 | 1911-03-03 | Republican | 17 | |||||||||||||
15343 | 15343 | Joseph Bennett B000378 | rep | KY | 1909-03-15 | 1911-03-03 | Republican | 9 | |||||||||||||
14574 | 14574 | Albert Beveridge B000429 | sen | IN | 1905-12-04 | 1911-03-03 | 1 | Republican | |||||||||||||
15869 | 15869 | Henry Bingham B000469 | rep | PA | 1909-03-15 | 1911-03-03 | Republican | 1 | |||||||||||||
15871 | 15871 | John Boehne B000587 | rep | IN | 1909-03-15 | 1911-03-03 | Democrat | 1 | |||||||||||||
17565 | 17565 | Charles Booher B000626 | rep | MO | 1909-03-15 | 1911-03-03 | Democrat | 4 | |||||||||||||
17076 | 17076 | William Borland B000643 | rep | MO | 1909-03-15 | 1911-03-03 | Democrat | 5 | |||||||||||||
15350 | 15350 | Henry Boutell B000672 | rep | IL | 1909-03-15 | 1911-03-03 | Republican | 9 | |||||||||||||
15354 | 15354 | Eaton Bowers B000689 | rep | MS | 1909-03-15 | 1911-03-03 | Democrat | 6 | |||||||||||||
15877 | 15877 | Thomas Bradley B000747 | rep | NY | 1909-03-15 | 1911-03-03 | Republican | 20 | |||||||||||||
15885 | 15885 | William Brantley B000770 | rep | GA | 1909-03-15 | 1911-03-03 | Democrat | 11 | |||||||||||||
16702 | 16702 | Robert Broussard B000896 | rep | LA | 1909-03-15 | 1911-03-03 | Democrat | 3 | |||||||||||||
15363 | 15363 | Walter Brownlow B000962 | rep | TN | 1909-03-15 | 1911-03-03 | Republican | 1 | |||||||||||||
14598 | 14598 | Morgan Bulkeley B001044 | sen | CT | 1905-12-04 | 1911-03-03 | 1 | Republican | |||||||||||||
16716 | 16716 | George Burgess B001083 | rep | TX | 1909-03-15 | 1911-03-03 | Democrat | 9 | |||||||||||||
16301 | 16301 | Charles Burke B001087 | rep | SD | 1909-03-15 | 1911-03-03 | Republican | -1 | |||||||||||||
16306 | 16306 | James Burke B001093 | rep | PA | 1909-03-15 | 1911-03-03 | Republican | 31 | |||||||||||||
14602 | 14602 | Elmer Burkett B001103 | sen | NE | 1905-12-04 | 1911-03-03 | 1 | Republican | |||||||||||||
16315 | 16315 | Edwin Burleigh B001105 | rep | ME | 1909-03-15 | 1911-03-03 | Republican | 3 | |||||||||||||
16322 | 16322 | Albert Burleson B001110 | rep | TX | 1909-03-15 | 1911-03-03 | Democrat | 10 | |||||||||||||
17585 | 17585 | John Burnett B001121 | rep | AL | 1909-03-15 | 1911-03-03 | Democrat | 7 | |||||||||||||
14613 | 14613 | Julius Burrows B001142 | sen | MI | 1905-12-04 | 1911-03-03 | 1 | Republican | |||||||||||||
19246 | 19246 | Thomas Butler B001192 | rep | PA | 1909-03-15 | 1911-03-03 | Republican | 7 | |||||||||||||
15367 | 15367 | Adam Byrd B001207 | rep | MS | 1909-03-15 | 1911-03-03 | Democrat | 5 | |||||||||||||
21670 | 21670 | Joseph Byrns B001217 | rep | TN | 1909-03-15 | 1911-03-03 | Democrat | 6 | |||||||||||||
17090 | 17090 | William Calder C000025 | rep | NY | 1909-03-15 | 1911-03-03 | Republican | 6 | |||||||||||||
15374 | 15374 | William Calderhead C000026 | rep | KS | 1909-03-15 | 1911-03-03 | Republican | 5 | |||||||||||||
18080 | 18080 | Ralph Cameron C000066 | rep | AZ | 1909-03-15 | 1911-03-03 | Republican | 0 | |||||||||||||
18086 | 18086 | Philip Campbell C000097 | rep | KS | 1909-03-15 | 1911-03-03 | Republican | 3 | |||||||||||||
17598 | 17598 | Ezekiel Candler C000110 | rep | MS | 1909-03-15 | 1911-03-03 | Democrat | 1 | |||||||||||||
18110 | 18110 | Joseph Cannon C000121 | rep | IL | 1909-03-15 | 1911-03-03 | Republican | 18 | |||||||||||||
18575 | 18575 | James Cantrill C000126 | rep | KY | 1909-03-15 | 1911-03-03 | Democrat | 7 | |||||||||||||
15381 | 15381 | Adin Capron C000135 | rep | RI | 1909-03-15 | 1911-03-03 | Republican | 2 | |||||||||||||
17605 | 17605 | Charles Carlin C000151 | rep | VA | 1909-03-15 | 1911-03-03 | Democrat | 8 | |||||||||||||
18917 | 18917 | Charles Carter C000196 | rep | OK | 1909-03-15 | 1911-03-03 | Democrat | 4 | |||||||||||||
14618 | 14618 | Thomas Carter C000200 | sen | MT | 1905-12-04 | 1911-03-03 | 1 | Republican | |||||||||||||
17099 | 17099 | William Cary C000218 | rep | WI | 1909-03-15 | 1911-03-03 | Republican | 4 | |||||||||||||
15382 | 15382 | James Cassidy C000238 | rep | OH | 1909-03-15 | 1911-03-03 | Republican | 21 | |||||||||||||
15385 | 15385 | Pleasant Chapman C000315 | rep | IL | 1909-03-15 | 1911-03-03 | Republican | 24 | |||||||||||||
15891 | 15891 | Moses Clapp C000414 | sen | MN | 1905-12-04 | 1911-03-03 | 1 | Republican | |||||||||||||
15897 | 15897 | Clarence Clark C000425 | sen | WY | 1905-12-04 | 1911-03-03 | 1 | Republican | |||||||||||||
18585 | 18585 | Frank Clark C000430 | rep | FL | 1909-03-15 | 1911-03-03 | Democrat | 2 | |||||||||||||
17618 | 17618 | James Clark C000437 | rep | MO | 1909-03-15 | 1911-03-03 | Democrat | 9 | |||||||||||||
15388 | 15388 | Alexander Clay C000478 | sen | GA | 1909-03-15 | 1911-03-03 | 3 | Democrat | |||||||||||||
16334 | 16334 | Henry Clayton C000495 | rep | AL | 1909-03-15 | 1911-03-03 | Democrat | 3 | |||||||||||||
16732 | 16732 | Cyrus Cline C000521 | rep | IN | 1909-03-15 | 1911-03-03 | Democrat | 12 | |||||||||||||
15391 | 15391 | William Cocks C000578 | rep | NY | 1909-03-15 | 1911-03-03 | Republican | 1 | |||||||||||||
15394 | 15394 | Ralph Cole C000612 | rep | OH | 1909-03-15 | 1911-03-03 | Republican | 8 | |||||||||||||
20210 | 20210 | James Collier C000630 | rep | MS | 1909-03-15 | 1911-03-03 | Democrat | 8 | |||||||||||||
17112 | 17112 | Michael Conry C000707 | rep | NY | 1909-03-15 | 1911-03-03 | Democrat | 12 | |||||||||||||
15396 | 15396 | Joel Cook C000718 | rep | PA | 1909-03-15 | 1911-03-03 | Republican | 2 | |||||||||||||
15400 | 15400 | Allen Cooper C000745 | rep | PA | 1909-03-15 | 1911-03-03 | Republican | 23 | |||||||||||||
20239 | 20239 | Henry Cooper C000752 | rep | WI | 1909-03-15 | 1911-03-03 | Republican | 1 | |||||||||||||
15403 | 15403 | Harry Coudrey C000805 | rep | MO | 1909-03-15 | 1911-03-03 | Republican | 12 | |||||||||||||
16338 | 16338 | James Covington C000816 | rep | MD | 1909-03-15 | 1911-03-03 | Democrat | 1 | |||||||||||||
15404 | 15404 | Charles Cowles C000826 | rep | NC | 1909-03-15 | 1911-03-03 | Republican | 8 | |||||||||||||
15900 | 15900 | James Cox C000835 | rep | OH | 1909-03-15 | 1911-03-03 | Democrat | 3 | |||||||||||||
17120 | 17120 | William Cox C000840 | rep | IN | 1909-03-15 | 1911-03-03 | Democrat | 3 | |||||||||||||
15406 | 15406 | William Craig C000861 | rep | AL | 1909-03-15 | 1911-03-03 | Democrat | 4 | |||||||||||||
22527 | 22527 | William Cravens C000886 | rep | AR | 1909-03-15 | 1911-03-03 | Democrat | 4 | |||||||||||||
15408 | 15408 | Charles Creager C000897 | rep | OK | 1909-03-15 | 1911-03-03 | Republican | 3 | |||||||||||||
15409 | 15409 | Charles Crow C000937 | rep | MO | 1909-03-15 | 1911-03-03 | Republican | 14 | |||||||||||||
15908 | 15908 | Edgar Crumpacker C000958 | rep | IN | 1909-03-15 | 1911-03-03 | Republican | 10 | |||||||||||||
17126 | 17126 | Charles Culberson C000963 | sen | TX | 1905-12-04 | 1911-03-03 | 1 | Democrat | |||||||||||||
16737 | 16737 | William Cullop C000975 | rep | IN | 1909-03-15 | 1911-03-03 | Democrat | 2 | |||||||||||||
15914 | 15914 | Frank Currier C000999 | rep | NH | 1909-03-15 | 1911-03-03 | Republican | 2 | |||||||||||||
15415 | 15415 | Francis Cushman C001018 | rep | WA | 1909-03-15 | 1911-03-03 | Republican | 2 | |||||||||||||
15928 | 15928 | John Dalzell D000016 | rep | PA | 1909-03-15 | 1911-03-03 | Republican | 30 | |||||||||||||
14630 | 14630 | John Daniel D000035 | sen | VA | 1905-12-04 | 1911-03-03 | 1 | Democrat | |||||||||||||
17138 | 17138 | James Davidson D000084 | rep | WI | 1909-03-15 | 1911-03-03 | Republican | 8 | |||||||||||||
18610 | 18610 | Charles Davis D000093 | rep | MN | 1909-03-15 | 1911-03-03 | Republican | 3 | |||||||||||||
15418 | 15418 | Albert Dawson D000150 | rep | IA | 1909-03-15 | 1911-03-03 | Republican | 2 | |||||||||||||
15428 | 15428 | David De Armond D000167 | rep | MO | 1909-03-15 | 1911-03-03 | Democrat | 6 | |||||||||||||
15431 | 15431 | Edwin Denby D000232 | rep | MI | 1909-03-15 | 1911-03-03 | Republican | 1 | |||||||||||||
17635 | 17635 | Stanley Dent D000256 | rep | AL | 1909-03-15 | 1911-03-03 | Democrat | 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);