legislator_terms
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
409 rows where "end" is on date 1903-03-03 sorted by legislator_id
This data as json, copyable, CSV (advanced)
Suggested facets: type, start, class, district, 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
14965 | 14965 | Ernest Acheson A000019 | rep | PA | 1901-12-02 | 1903-03-03 | Republican | 24 | |||||||||||||
14552 | 14552 | Robert Adams A000044 | rep | PA | 1901-12-02 | 1903-03-03 | Republican | 2 | |||||||||||||
17046 | 17046 | William Adamson A000051 | rep | GA | 1901-12-02 | 1903-03-03 | Democrat | 4 | |||||||||||||
15325 | 15325 | De Alexander A000091 | rep | NY | 1901-12-02 | 1903-03-03 | Republican | 33 | |||||||||||||
15331 | 15331 | Amos Allen A000112 | rep | ME | 1901-12-02 | 1903-03-03 | Republican | 1 | |||||||||||||
13844 | 13844 | Henry Allen A000125 | rep | KY | 1901-12-02 | 1903-03-03 | Democrat | 2 | |||||||||||||
14235 | 14235 | William Allison A000160 | sen | IA | 1897-03-15 | 1903-03-03 | 3 | Republican | |||||||||||||
13845 | 13845 | Henry Aplin A000265 | rep | MI | 1901-12-02 | 1903-03-03 | Republican | 10 | |||||||||||||
14567 | 14567 | Joseph Babcock B000004 | rep | WI | 1901-12-02 | 1903-03-03 | Republican | 3 | |||||||||||||
17543 | 17543 | Lewis Ball B000100 | rep | DE | 1901-12-02 | 1903-03-03 | Republican | 0 | |||||||||||||
14242 | 14242 | Thomas Ball B000101 | rep | TX | 1901-12-02 | 1903-03-03 | Democrat | 1 | |||||||||||||
17553 | 17553 | John Bankhead B000110 | rep | AL | 1901-12-02 | 1903-03-03 | Democrat | 6 | |||||||||||||
13849 | 13849 | Samuel Barney B000163 | rep | WI | 1901-12-02 | 1903-03-03 | Republican | 5 | |||||||||||||
16266 | 16266 | Richard Bartholdt B000196 | rep | MO | 1901-12-02 | 1903-03-03 | Republican | 10 | |||||||||||||
16276 | 16276 | Charles Bartlett B000199 | rep | GA | 1901-12-02 | 1903-03-03 | Democrat | 6 | |||||||||||||
15848 | 15848 | Arthur Bates B000230 | rep | PA | 1901-12-02 | 1903-03-03 | Republican | 26 | |||||||||||||
14570 | 14570 | Jacob Beidler B000317 | rep | OH | 1901-12-02 | 1903-03-03 | Republican | 20 | |||||||||||||
13854 | 13854 | John Bell B000341 | rep | CO | 1901-12-02 | 1903-03-03 | Populist | 2 | |||||||||||||
13856 | 13856 | John Bellamy B000349 | rep | NC | 1901-12-02 | 1903-03-03 | Democrat | 6 | |||||||||||||
13857 | 13857 | Oliver Belmont B000352 | rep | NY | 1901-12-02 | 1903-03-03 | Democrat | 13 | |||||||||||||
14249 | 14249 | Maecenas Benton B000397 | rep | MO | 1901-12-02 | 1903-03-03 | Democrat | 15 | |||||||||||||
13862 | 13862 | Alexander Billmeyer B000465 | rep | PA | 1901-12-02 | 1903-03-03 | Democrat | 17 | |||||||||||||
15865 | 15865 | Henry Bingham B000469 | rep | PA | 1901-12-02 | 1903-03-03 | Republican | 1 | |||||||||||||
14578 | 14578 | Roswell Bishop B000489 | rep | MI | 1901-12-02 | 1903-03-03 | Republican | 9 | |||||||||||||
14581 | 14581 | Edmond Blackburn B000507 | rep | NC | 1901-12-02 | 1903-03-03 | Republican | 8 | |||||||||||||
18049 | 18049 | Albert Blakeney B000535 | rep | MD | 1901-12-02 | 1903-03-03 | Republican | 2 | |||||||||||||
14252 | 14252 | Vincent Boreing B000637 | rep | KY | 1901-12-02 | 1903-03-03 | Republican | 11 | |||||||||||||
15346 | 15346 | Henry Boutell B000672 | rep | IL | 1901-12-02 | 1903-03-03 | Republican | 6 | |||||||||||||
13880 | 13880 | Charles Boutelle B000673 | rep | ME | 1901-12-02 | 1903-03-03 | Republican | -1 | |||||||||||||
14584 | 14584 | Justin Bowersock B000693 | rep | KS | 1901-12-02 | 1903-03-03 | Republican | 2 | |||||||||||||
14587 | 14587 | Sydney Bowie B000695 | rep | AL | 1901-12-02 | 1903-03-03 | Democrat | 4 | |||||||||||||
18059 | 18059 | Frank Brandegee B000769 | rep | CT | 1902-11-04 | 1903-03-03 | Republican | 3 | |||||||||||||
15881 | 15881 | William Brantley B000770 | rep | GA | 1901-12-02 | 1903-03-03 | Democrat | 11 | |||||||||||||
14255 | 14255 | Phanor Breazeale B000781 | rep | LA | 1901-12-02 | 1903-03-03 | Democrat | 4 | |||||||||||||
14991 | 14991 | Abraham Brick B000819 | rep | IN | 1901-12-02 | 1903-03-03 | Republican | 13 | |||||||||||||
13881 | 13881 | Henry Bristow B000843 | rep | NY | 1901-12-02 | 1903-03-03 | Republican | 3 | |||||||||||||
13886 | 13886 | Jacob Bromwell B000866 | rep | OH | 1901-12-02 | 1903-03-03 | Republican | 2 | |||||||||||||
13893 | 13893 | Marriott Brosius B000892 | rep | PA | 1901-12-02 | 1903-03-03 | Republican | 10 | |||||||||||||
16698 | 16698 | Robert Broussard B000896 | rep | LA | 1901-12-02 | 1903-03-03 | Democrat | 3 | |||||||||||||
14593 | 14593 | Webster Brown B000946 | rep | WI | 1901-12-02 | 1903-03-03 | Republican | 9 | |||||||||||||
15359 | 15359 | Walter Brownlow B000962 | rep | TN | 1901-12-02 | 1903-03-03 | Republican | 1 | |||||||||||||
15008 | 15008 | Stephen Brundidge B000979 | rep | AR | 1901-12-02 | 1903-03-03 | Democrat | 6 | |||||||||||||
13897 | 13897 | Melville Bull B001048 | rep | RI | 1901-12-02 | 1903-03-03 | Republican | 1 | |||||||||||||
16712 | 16712 | George Burgess B001083 | rep | TX | 1901-12-02 | 1903-03-03 | Democrat | 10 | |||||||||||||
14258 | 14258 | Henry Burk B001085 | rep | PA | 1901-12-02 | 1903-03-03 | Republican | 3 | |||||||||||||
16298 | 16298 | Charles Burke B001087 | rep | SD | 1901-12-02 | 1903-03-03 | Republican | -1 | |||||||||||||
13900 | 13900 | Robert Burke B001097 | rep | TX | 1901-12-02 | 1903-03-03 | Democrat | 6 | |||||||||||||
14600 | 14600 | Elmer Burkett B001103 | rep | NE | 1901-12-02 | 1903-03-03 | Republican | 1 | |||||||||||||
16311 | 16311 | Edwin Burleigh B001105 | rep | ME | 1901-12-02 | 1903-03-03 | Republican | 3 | |||||||||||||
16318 | 16318 | Albert Burleson B001110 | rep | TX | 1901-12-02 | 1903-03-03 | Democrat | 9 | |||||||||||||
17581 | 17581 | John Burnett B001121 | rep | AL | 1901-12-02 | 1903-03-03 | Democrat | 7 | |||||||||||||
19559 | 19559 | Theodore Burton B001159 | rep | OH | 1901-12-02 | 1903-03-03 | Republican | 21 | |||||||||||||
14260 | 14260 | James Butler B001178 | rep | MO | 1901-12-02 | 1903-03-03 | Democrat | 12 | |||||||||||||
19242 | 19242 | Thomas Butler B001192 | rep | PA | 1901-12-02 | 1903-03-03 | Republican | 6 | |||||||||||||
15370 | 15370 | William Calderhead C000026 | rep | KS | 1901-12-02 | 1903-03-03 | Republican | 5 | |||||||||||||
15018 | 15018 | Ben Caldwell C000029 | rep | IL | 1901-12-02 | 1903-03-03 | Democrat | 17 | |||||||||||||
17594 | 17594 | Ezekiel Candler C000110 | rep | MS | 1901-12-02 | 1903-03-03 | Democrat | 1 | |||||||||||||
18106 | 18106 | Joseph Cannon C000121 | rep | IL | 1901-12-02 | 1903-03-03 | Republican | 12 | |||||||||||||
15377 | 15377 | Adin Capron C000135 | rep | RI | 1901-12-02 | 1903-03-03 | Republican | 2 | |||||||||||||
15022 | 15022 | Henry Cassel C000235 | rep | PA | 1901-12-02 | 1903-03-03 | Republican | 10 | |||||||||||||
14262 | 14262 | John Cassingham C000239 | rep | OH | 1901-12-02 | 1903-03-03 | Democrat | 17 | |||||||||||||
17614 | 17614 | James Clark C000437 | rep | MO | 1901-12-02 | 1903-03-03 | Democrat | 9 | |||||||||||||
15386 | 15386 | Alexander Clay C000478 | sen | GA | 1897-03-15 | 1903-03-03 | 3 | Democrat | |||||||||||||
16330 | 16330 | Henry Clayton C000495 | rep | AL | 1901-12-02 | 1903-03-03 | Democrat | 3 | |||||||||||||
14266 | 14266 | Charles Cochran C000562 | rep | MO | 1901-12-02 | 1903-03-03 | Democrat | 4 | |||||||||||||
14270 | 14270 | William Connell C000687 | rep | PA | 1901-12-02 | 1903-03-03 | Republican | 11 | |||||||||||||
15030 | 15030 | James Conner C000690 | rep | IA | 1901-12-02 | 1903-03-03 | Republican | 10 | |||||||||||||
13907 | 13907 | Joseph Conry C000706 | rep | MA | 1901-12-02 | 1903-03-03 | Democrat | 9 | |||||||||||||
13908 | 13908 | Frank Coombs C000741 | rep | CA | 1901-12-02 | 1903-03-03 | Republican | 1 | |||||||||||||
13911 | 13911 | James Cooney C000744 | rep | MO | 1901-12-02 | 1903-03-03 | Democrat | 7 | |||||||||||||
20235 | 20235 | Henry Cooper C000752 | rep | WI | 1901-12-02 | 1903-03-03 | Republican | 1 | |||||||||||||
15039 | 15039 | Samuel Cooper C000761 | rep | TX | 1901-12-02 | 1903-03-03 | Democrat | 2 | |||||||||||||
13915 | 13915 | John Corliss C000779 | rep | MI | 1901-12-02 | 1903-03-03 | Republican | 1 | |||||||||||||
15046 | 15046 | Robert Cousins C000811 | rep | IA | 1901-12-02 | 1903-03-03 | Republican | 5 | |||||||||||||
14274 | 14274 | William Cowherd C000825 | rep | MO | 1901-12-02 | 1903-03-03 | Democrat | 5 | |||||||||||||
13917 | 13917 | Thomas Creamer C000899 | rep | NY | 1901-12-02 | 1903-03-03 | Democrat | 8 | |||||||||||||
14622 | 14622 | George Cromer C000924 | rep | IN | 1901-12-02 | 1903-03-03 | Republican | 8 | |||||||||||||
14279 | 14279 | Joseph Crowley C000943 | rep | IL | 1901-12-02 | 1903-03-03 | Democrat | 19 | |||||||||||||
13921 | 13921 | Rousseau Crump C000957 | rep | MI | 1901-12-02 | 1903-03-03 | Republican | 10 | |||||||||||||
15904 | 15904 | Edgar Crumpacker C000958 | rep | IN | 1901-12-02 | 1903-03-03 | Republican | 10 | |||||||||||||
13929 | 13929 | Amos Cummings C000983 | rep | NY | 1901-12-02 | 1903-03-03 | Democrat | 10 | |||||||||||||
15910 | 15910 | Frank Currier C000999 | rep | NH | 1901-12-02 | 1903-03-03 | Republican | 2 | |||||||||||||
19273 | 19273 | Charles Curtis C001008 | rep | KS | 1901-12-02 | 1903-03-03 | Republican | 1 | |||||||||||||
15411 | 15411 | Francis Cushman C001018 | rep | WA | 1901-12-02 | 1903-03-03 | Republican | -1 | |||||||||||||
13931 | 13931 | Herman Dahle D000005 | rep | WI | 1901-12-02 | 1903-03-03 | Republican | 2 | |||||||||||||
15924 | 15924 | John Dalzell D000016 | rep | PA | 1901-12-02 | 1903-03-03 | Republican | 22 | |||||||||||||
15064 | 15064 | Archibald Darragh D000060 | rep | MI | 1901-12-02 | 1903-03-03 | Republican | 11 | |||||||||||||
15071 | 15071 | Robert Davey D000081 | rep | LA | 1901-12-02 | 1903-03-03 | Democrat | 2 | |||||||||||||
17134 | 17134 | James Davidson D000084 | rep | WI | 1901-12-02 | 1903-03-03 | Republican | 6 | |||||||||||||
14284 | 14284 | Robert Davis D000132 | rep | FL | 1901-12-02 | 1903-03-03 | Democrat | 2 | |||||||||||||
14635 | 14635 | Alston Dayton D000163 | rep | WV | 1901-12-02 | 1903-03-03 | Republican | 2 | |||||||||||||
15424 | 15424 | David De Armond D000167 | rep | MO | 1901-12-02 | 1903-03-03 | Democrat | 6 | |||||||||||||
13289 | 13289 | William Deboe D000182 | sen | KY | 1897-03-15 | 1903-03-03 | 3 | Republican | |||||||||||||
14638 | 14638 | Elias Deemer D000186 | rep | PA | 1901-12-02 | 1903-03-03 | Republican | 16 | |||||||||||||
13934 | 13934 | Reese De Graffenreid D000194 | rep | TX | 1901-12-02 | 1903-03-03 | Democrat | 3 | |||||||||||||
14287 | 14287 | Federico Degetau D000196 | rep | PR | 1901-12-02 | 1903-03-03 | Republican | 0 | |||||||||||||
14542 | 14542 | Charles Dick D000302 | rep | OH | 1901-12-02 | 1903-03-03 | Republican | 19 | |||||||||||||
18148 | 18148 | William Dillingham D000347 | sen | VT | 1900-01-01 | 1903-03-03 | 3 | Republican | |||||||||||||
14296 | 14296 | Hugh Dinsmore D000358 | rep | AR | 1901-12-02 | 1903-03-03 | Democrat | 5 | |||||||||||||
14299 | 14299 | John Dougherty D000447 | rep | MO | 1901-12-02 | 1903-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);