legislator_terms
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
415 rows where "end" is on date 1901-03-03 sorted by legislator_id
This data as json, copyable, CSV (advanced)
Suggested facets: type, start, class, 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
14964 | 14964 | Ernest Acheson A000019 | rep | PA | 1899-12-04 | 1901-03-03 | Republican | 24 | |||||||||||||
14551 | 14551 | Robert Adams A000044 | rep | PA | 1899-12-04 | 1901-03-03 | Republican | 2 | |||||||||||||
17045 | 17045 | William Adamson A000051 | rep | GA | 1899-12-04 | 1901-03-03 | Democrat | 4 | |||||||||||||
13547 | 13547 | William Aldrich A000087 | rep | AL | 1899-12-04 | 1901-03-03 | Republican | 4 | |||||||||||||
15324 | 15324 | De Alexander A000091 | rep | NY | 1899-12-04 | 1901-03-03 | Republican | 33 | |||||||||||||
15330 | 15330 | Amos Allen A000112 | rep | ME | 1899-12-04 | 1901-03-03 | Republican | 1 | |||||||||||||
13843 | 13843 | Henry Allen A000125 | rep | KY | 1899-12-04 | 1901-03-03 | Democrat | 2 | |||||||||||||
13555 | 13555 | John Allen A000134 | rep | MS | 1899-12-04 | 1901-03-03 | Democrat | 1 | |||||||||||||
13558 | 13558 | John Atwater A000334 | rep | NC | 1899-12-04 | 1901-03-03 | Populist | 4 | |||||||||||||
14566 | 14566 | Joseph Babcock B000004 | rep | WI | 1899-12-04 | 1901-03-03 | Republican | 3 | |||||||||||||
16256 | 16256 | Augustus Bacon B000014 | sen | GA | 1895-12-02 | 1901-03-03 | 2 | Democrat | |||||||||||||
14973 | 14973 | Joseph Bailey B000044 | rep | TX | 1899-12-04 | 1901-03-03 | Democrat | 5 | |||||||||||||
13559 | 13559 | Willis Bailey B000051 | rep | KS | 1899-12-04 | 1901-03-03 | Republican | -1 | |||||||||||||
13561 | 13561 | Samuel Baird B000055 | rep | LA | 1899-12-04 | 1901-03-03 | Democrat | 5 | |||||||||||||
12908 | 12908 | Lucien Baker B000070 | sen | KS | 1895-12-02 | 1901-03-03 | 2 | Republican | |||||||||||||
13564 | 13564 | William Baker B000076 | rep | MD | 1899-12-04 | 1901-03-03 | Republican | 2 | |||||||||||||
14241 | 14241 | Thomas Ball B000101 | rep | TX | 1899-12-04 | 1901-03-03 | Democrat | 1 | |||||||||||||
17552 | 17552 | John Bankhead B000110 | rep | AL | 1899-12-04 | 1901-03-03 | Democrat | 6 | |||||||||||||
13565 | 13565 | Laird Barber B000123 | rep | PA | 1899-12-04 | 1901-03-03 | Democrat | 8 | |||||||||||||
13568 | 13568 | John Barham B000140 | rep | CA | 1899-12-04 | 1901-03-03 | Republican | 1 | |||||||||||||
13848 | 13848 | Samuel Barney B000163 | rep | WI | 1899-12-04 | 1901-03-03 | Republican | 5 | |||||||||||||
16265 | 16265 | Richard Bartholdt B000196 | rep | MO | 1899-12-04 | 1901-03-03 | Republican | 10 | |||||||||||||
16275 | 16275 | Charles Bartlett B000199 | rep | GA | 1899-12-04 | 1901-03-03 | Democrat | 6 | |||||||||||||
13853 | 13853 | John Bell B000341 | rep | CO | 1899-12-04 | 1901-03-03 | Populist | 2 | |||||||||||||
13855 | 13855 | John Bellamy B000349 | rep | NC | 1899-12-04 | 1901-03-03 | Democrat | 6 | |||||||||||||
14248 | 14248 | Maecenas Benton B000397 | rep | MO | 1899-12-04 | 1901-03-03 | Democrat | 15 | |||||||||||||
13575 | 13575 | Albert Berry B000414 | rep | KY | 1899-12-04 | 1901-03-03 | Democrat | 6 | |||||||||||||
13860 | 13860 | James Berry B000418 | sen | AR | 1895-12-02 | 1901-03-03 | 2 | Democrat | |||||||||||||
15864 | 15864 | Henry Bingham B000469 | rep | PA | 1899-12-04 | 1901-03-03 | Republican | 1 | |||||||||||||
14577 | 14577 | Roswell Bishop B000489 | rep | MI | 1899-12-04 | 1901-03-03 | Republican | 9 | |||||||||||||
13588 | 13588 | Richard Bland B000544 | rep | MO | 1899-12-04 | 1901-03-03 | Democrat | 8 | |||||||||||||
14251 | 14251 | Vincent Boreing B000637 | rep | KY | 1899-12-04 | 1901-03-03 | Republican | 11 | |||||||||||||
15345 | 15345 | Henry Boutell B000672 | rep | IL | 1899-12-04 | 1901-03-03 | Republican | 6 | |||||||||||||
13879 | 13879 | Charles Boutelle B000673 | rep | ME | 1899-12-04 | 1901-03-03 | Republican | 4 | |||||||||||||
14583 | 14583 | Justin Bowersock B000693 | rep | KS | 1899-12-04 | 1901-03-03 | Republican | 2 | |||||||||||||
13590 | 13590 | Thomas Bradley B000746 | rep | NY | 1899-12-04 | 1901-03-03 | Democrat | 9 | |||||||||||||
15880 | 15880 | William Brantley B000770 | rep | GA | 1899-12-04 | 1901-03-03 | Democrat | 11 | |||||||||||||
14254 | 14254 | Phanor Breazeale B000781 | rep | LA | 1899-12-04 | 1901-03-03 | Democrat | 4 | |||||||||||||
13592 | 13592 | John Brenner B000801 | rep | OH | 1899-12-04 | 1901-03-03 | Democrat | 3 | |||||||||||||
13594 | 13594 | Willis Brewer B000812 | rep | AL | 1899-12-04 | 1901-03-03 | Democrat | 5 | |||||||||||||
14990 | 14990 | Abraham Brick B000819 | rep | IN | 1899-12-04 | 1901-03-03 | Republican | 13 | |||||||||||||
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 | |||||||||||||
16697 | 16697 | Robert Broussard B000896 | rep | LA | 1899-12-04 | 1901-03-03 | Democrat | 3 | |||||||||||||
13596 | 13596 | Seth Brown B000943 | rep | OH | 1899-12-04 | 1901-03-03 | Republican | 6 | |||||||||||||
15358 | 15358 | Walter Brownlow B000962 | rep | TN | 1899-12-04 | 1901-03-03 | Republican | 1 | |||||||||||||
15007 | 15007 | Stephen Brundidge B000979 | rep | AR | 1899-12-04 | 1901-03-03 | Democrat | 6 | |||||||||||||
13896 | 13896 | Melville Bull B001048 | rep | RI | 1899-12-04 | 1901-03-03 | Republican | 1 | |||||||||||||
16297 | 16297 | Charles Burke B001087 | rep | SD | 1899-12-04 | 1901-03-03 | Republican | -1 | |||||||||||||
13899 | 13899 | Robert Burke B001097 | rep | TX | 1899-12-04 | 1901-03-03 | Democrat | 6 | |||||||||||||
14599 | 14599 | Elmer Burkett B001103 | rep | NE | 1899-12-04 | 1901-03-03 | Republican | 1 | |||||||||||||
16310 | 16310 | Edwin Burleigh B001105 | rep | ME | 1899-12-04 | 1901-03-03 | Republican | 3 | |||||||||||||
16317 | 16317 | Albert Burleson B001110 | rep | TX | 1899-12-04 | 1901-03-03 | Democrat | 9 | |||||||||||||
17580 | 17580 | John Burnett B001121 | rep | AL | 1899-12-04 | 1901-03-03 | Democrat | 7 | |||||||||||||
19558 | 19558 | Theodore Burton B001159 | rep | OH | 1899-12-04 | 1901-03-03 | Republican | 21 | |||||||||||||
12931 | 12931 | Marion Butler B001183 | sen | NC | 1895-12-02 | 1901-03-03 | 2 | Populist | |||||||||||||
19241 | 19241 | Thomas Butler B001192 | rep | PA | 1899-12-04 | 1901-03-03 | Republican | 6 | |||||||||||||
12933 | 12933 | Donelson Caffery C000016 | sen | LA | 1895-12-02 | 1901-03-03 | 2 | Democrat | |||||||||||||
15369 | 15369 | William Calderhead C000026 | rep | KS | 1899-12-04 | 1901-03-03 | Republican | 5 | |||||||||||||
15017 | 15017 | Ben Caldwell C000029 | rep | IL | 1899-12-04 | 1901-03-03 | Democrat | 17 | |||||||||||||
13597 | 13597 | Albert Campbell C000074 | rep | MT | 1899-12-04 | 1901-03-03 | Democrat | 1 | |||||||||||||
18105 | 18105 | Joseph Cannon C000121 | rep | IL | 1899-12-04 | 1901-03-03 | Republican | 12 | |||||||||||||
15376 | 15376 | Adin Capron C000135 | rep | RI | 1899-12-04 | 1901-03-03 | Republican | 2 | |||||||||||||
13903 | 13903 | Edward Carmack C000157 | rep | TN | 1899-12-04 | 1901-03-03 | Democrat | 10 | |||||||||||||
14617 | 14617 | Thomas Carter C000200 | sen | MT | 1895-12-02 | 1901-03-03 | 2 | Republican | |||||||||||||
13605 | 13605 | Thomas Catchings C000247 | rep | MS | 1899-12-04 | 1901-03-03 | Democrat | 3 | |||||||||||||
12936 | 12936 | William Chandler C000298 | sen | NH | 1895-12-02 | 1901-03-03 | 2 | Republican | |||||||||||||
13606 | 13606 | William Chanler C000303 | rep | NY | 1899-12-04 | 1901-03-03 | Democrat | 14 | |||||||||||||
13610 | 13610 | Charles Chickering C000351 | rep | NY | 1899-12-04 | 1901-03-03 | Republican | 24 | |||||||||||||
12938 | 12938 | Horace Chilton C000357 | sen | TX | 1895-12-02 | 1901-03-03 | 2 | Democrat | |||||||||||||
17613 | 17613 | James Clark C000437 | rep | MO | 1899-12-04 | 1901-03-03 | Democrat | 9 | |||||||||||||
13905 | 13905 | William Clark C000454 | sen | MT | 1899-12-04 | 1901-03-03 | 1 | Democrat | |||||||||||||
13612 | 13612 | Frank Clarke C000460 | rep | NH | 1899-12-04 | 1901-03-03 | Republican | 2 | |||||||||||||
13613 | 13613 | Bertram Clayton C000492 | rep | NY | 1899-12-04 | 1901-03-03 | Democrat | 4 | |||||||||||||
16329 | 16329 | Henry Clayton C000495 | rep | AL | 1899-12-04 | 1901-03-03 | Democrat | 3 | |||||||||||||
14265 | 14265 | Charles Cochran C000562 | rep | MO | 1899-12-04 | 1901-03-03 | Democrat | 4 | |||||||||||||
13615 | 13615 | Aaron Cochrane C000568 | rep | NY | 1899-12-04 | 1901-03-03 | Republican | 19 | |||||||||||||
14269 | 14269 | William Connell C000687 | rep | PA | 1899-12-04 | 1901-03-03 | Republican | 11 | |||||||||||||
15029 | 15029 | James Conner C000690 | rep | IA | 1899-12-04 | 1901-03-03 | Republican | 10 | |||||||||||||
13910 | 13910 | James Cooney C000744 | rep | MO | 1899-12-04 | 1901-03-03 | Democrat | 7 | |||||||||||||
20234 | 20234 | Henry Cooper C000752 | rep | WI | 1899-12-04 | 1901-03-03 | Republican | 1 | |||||||||||||
15038 | 15038 | Samuel Cooper C000761 | rep | TX | 1899-12-04 | 1901-03-03 | Democrat | 2 | |||||||||||||
13914 | 13914 | John Corliss C000779 | rep | MI | 1899-12-04 | 1901-03-03 | Republican | 1 | |||||||||||||
15045 | 15045 | Robert Cousins C000811 | rep | IA | 1899-12-04 | 1901-03-03 | Republican | 5 | |||||||||||||
14273 | 14273 | William Cowherd C000825 | rep | MO | 1899-12-04 | 1901-03-03 | Democrat | 5 | |||||||||||||
13625 | 13625 | Nicholas Cox C000838 | rep | TN | 1899-12-04 | 1901-03-03 | Democrat | 7 | |||||||||||||
15054 | 15054 | William Crawford C000896 | rep | NC | 1899-12-04 | 1901-03-03 | Democrat | 9 | |||||||||||||
14621 | 14621 | George Cromer C000924 | rep | IN | 1899-12-04 | 1901-03-03 | Republican | 8 | |||||||||||||
14278 | 14278 | Joseph Crowley C000943 | rep | IL | 1899-12-04 | 1901-03-03 | Democrat | 19 | |||||||||||||
13920 | 13920 | Rousseau Crump C000957 | rep | MI | 1899-12-04 | 1901-03-03 | Republican | 10 | |||||||||||||
15903 | 15903 | Edgar Crumpacker C000958 | rep | IN | 1899-12-04 | 1901-03-03 | Republican | 10 | |||||||||||||
15061 | 15061 | Shelby Cullom C000973 | sen | IL | 1895-12-02 | 1901-03-03 | 2 | Republican | |||||||||||||
13928 | 13928 | Amos Cummings C000983 | rep | NY | 1899-12-04 | 1901-03-03 | Democrat | 10 | |||||||||||||
19272 | 19272 | Charles Curtis C001008 | rep | KS | 1899-12-04 | 1901-03-03 | Republican | 1 | |||||||||||||
13626 | 13626 | Thomas Cusack C001015 | rep | IL | 1899-12-04 | 1901-03-03 | Democrat | 4 | |||||||||||||
15410 | 15410 | Francis Cushman C001018 | rep | WA | 1899-12-04 | 1901-03-03 | Republican | -1 | |||||||||||||
13930 | 13930 | Herman Dahle D000005 | rep | WI | 1899-12-04 | 1901-03-03 | Republican | 2 | |||||||||||||
13627 | 13627 | William Daly D000015 | rep | NJ | 1899-12-04 | 1901-03-03 | Democrat | 7 | |||||||||||||
15923 | 15923 | John Dalzell D000016 | rep | PA | 1899-12-04 | 1901-03-03 | Republican | 22 | |||||||||||||
13633 | 13633 | Lorenzo Danford D000028 | rep | OH | 1899-12-04 | 1901-03-03 | Republican | 16 |
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);