legislator_terms
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
497 rows where "start" is on date 1913-04-07 sorted by legislator_id
This data as json, copyable, CSV (advanced)
Suggested facets: class
end 5 ✖
- 1915-03-03 462
- 1919-03-03 28
- 1913-12-31 4
- 1917-03-03 2
- 1917-12-31 1
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
16662 | 16662 | John Abercrombie A000013 | rep | AL | 1913-04-07 | 1915-03-03 | Democrat | -1 | |||||||||||||
16667 | 16667 | John Adair A000027 | rep | IN | 1913-04-07 | 1915-03-03 | Democrat | 8 | |||||||||||||
17052 | 17052 | William Adamson A000051 | rep | GA | 1913-04-07 | 1915-03-03 | Democrat | 4 | |||||||||||||
16674 | 16674 | Wyatt Aiken A000064 | rep | SC | 1913-04-07 | 1915-03-03 | Democrat | 3 | |||||||||||||
16250 | 16250 | William Ainey A000065 | rep | PA | 1913-04-07 | 1915-03-03 | Republican | 14 | |||||||||||||
17535 | 17535 | Joshua Alexander A000098 | rep | MO | 1913-04-07 | 1915-03-03 | Democrat | 3 | |||||||||||||
16677 | 16677 | Alfred Allen A000111 | rep | OH | 1913-04-07 | 1915-03-03 | Democrat | 2 | |||||||||||||
18565 | 18565 | Sydney Anderson A000233 | rep | MN | 1913-04-07 | 1915-03-03 | Republican | 1 | |||||||||||||
16254 | 16254 | Timothy Ansberry A000259 | rep | OH | 1913-04-07 | 1915-03-03 | Democrat | 5 | |||||||||||||
19190 | 19190 | Daniel Anthony A000261 | rep | KS | 1913-04-07 | 1915-03-03 | Republican | 1 | |||||||||||||
22479 | 22479 | William Ashbrook A000306 | rep | OH | 1913-04-07 | 1915-03-03 | Democrat | 17 | |||||||||||||
20098 | 20098 | James Aswell A000321 | rep | LA | 1913-04-07 | 1915-03-03 | Democrat | 8 | |||||||||||||
17057 | 17057 | Richard Austin A000341 | rep | TN | 1913-04-07 | 1915-03-03 | Republican | 2 | |||||||||||||
16255 | 16255 | Samuel Avis A000348 | rep | WV | 1913-04-07 | 1915-03-03 | Republican | 3 | |||||||||||||
16259 | 16259 | Augustus Bacon B000014 | sen | GA | 1913-04-07 | 1915-03-03 | 2 | Democrat | |||||||||||||
16679 | 16679 | Warren Bailey B000050 | rep | PA | 1913-04-07 | 1915-03-03 | Democrat | 19 | |||||||||||||
16260 | 16260 | Jacob Baker B000065 | rep | NJ | 1913-04-07 | 1915-03-03 | Democrat | 2 | |||||||||||||
16261 | 16261 | William Baltz B000107 | rep | IL | 1913-04-07 | 1915-03-03 | Democrat | 22 | |||||||||||||
17557 | 17557 | John Bankhead B000110 | sen | AL | 1913-04-07 | 1919-03-03 | 2 | Democrat | |||||||||||||
16685 | 16685 | Andrew Barchfeld B000133 | rep | PA | 1913-04-07 | 1915-03-03 | Republican | 32 | |||||||||||||
25867 | 25867 | Alben Barkley B000145 | rep | KY | 1913-04-07 | 1915-03-03 | Democrat | 1 | |||||||||||||
17064 | 17064 | Henry Barnhart B000164 | rep | IN | 1913-04-07 | 1915-03-03 | Democrat | 13 | |||||||||||||
16272 | 16272 | Richard Bartholdt B000196 | rep | MO | 1913-04-07 | 1915-03-03 | Republican | 10 | |||||||||||||
16282 | 16282 | Charles Bartlett B000199 | rep | GA | 1913-04-07 | 1915-03-03 | Democrat | 6 | |||||||||||||
16283 | 16283 | Silas Barton B000216 | rep | NE | 1913-04-07 | 1915-03-03 | Republican | 5 | |||||||||||||
17068 | 17068 | Elsworth Bathrick B000240 | rep | OH | 1913-04-07 | 1915-03-03 | Democrat | 19 | |||||||||||||
17070 | 17070 | Samuel Beakes B000264 | rep | MI | 1913-04-07 | 1915-03-03 | Democrat | 2 | |||||||||||||
16289 | 16289 | James Beall B000270 | rep | TX | 1913-04-07 | 1915-03-03 | Democrat | 5 | |||||||||||||
16290 | 16290 | Charles Bell B000334 | rep | CA | 1913-04-07 | 1915-03-03 | Republican | 9 | |||||||||||||
19578 | 19578 | Thomas Bell B000348 | rep | GA | 1913-04-07 | 1915-03-03 | Democrat | 9 | |||||||||||||
18044 | 18044 | Fred Blackmon B000514 | rep | AL | 1913-04-07 | 1915-03-03 | Democrat | 4 | |||||||||||||
17567 | 17567 | Charles Booher B000626 | rep | MO | 1913-04-07 | 1915-03-03 | Democrat | 4 | |||||||||||||
22048 | 22048 | William Borah B000634 | sen | ID | 1913-04-07 | 1919-03-03 | 2 | Republican | |||||||||||||
16291 | 16291 | Charles Borchers B000635 | rep | IL | 1913-04-07 | 1915-03-03 | Democrat | 19 | |||||||||||||
17078 | 17078 | William Borland B000643 | rep | MO | 1913-04-07 | 1915-03-03 | Democrat | 5 | |||||||||||||
16292 | 16292 | Stanley Bowdle B000679 | rep | OH | 1913-04-07 | 1915-03-03 | Democrat | 1 | |||||||||||||
16694 | 16694 | James Brady B000753 | sen | ID | 1913-04-07 | 1915-03-03 | 3 | Republican | |||||||||||||
16293 | 16293 | Robert Bremner B000796 | rep | NJ | 1913-04-07 | 1915-03-03 | Democrat | 7 | |||||||||||||
21150 | 21150 | Frederick Britten B000847 | rep | IL | 1913-04-07 | 1915-03-03 | Republican | 9 | |||||||||||||
16294 | 16294 | Franklin Brockson B000853 | rep | DE | 1913-04-07 | 1915-03-03 | Democrat | 0 | |||||||||||||
17083 | 17083 | Andrew Brodbeck B000855 | rep | PA | 1913-04-07 | 1915-03-03 | Democrat | 20 | |||||||||||||
16704 | 16704 | Robert Broussard B000896 | rep | LA | 1913-04-07 | 1915-03-03 | Democrat | 3 | |||||||||||||
16295 | 16295 | Lathrop Brown B000937 | rep | NY | 1913-04-07 | 1915-03-03 | Democrat | 1 | |||||||||||||
16707 | 16707 | William Brown B000949 | rep | WV | 1913-04-07 | 1915-03-03 | Democrat | 2 | |||||||||||||
19598 | 19598 | Edward Browne B000955 | rep | WI | 1913-04-07 | 1915-03-03 | Republican | 8 | |||||||||||||
17572 | 17572 | William Browning B000961 | rep | NJ | 1913-04-07 | 1915-03-03 | Republican | 1 | |||||||||||||
17085 | 17085 | Henry Bruckner B000974 | rep | NY | 1913-04-07 | 1915-03-03 | Democrat | 22 | |||||||||||||
17576 | 17576 | Clement Brumbaugh B000975 | rep | OH | 1913-04-07 | 1915-03-03 | Democrat | 12 | |||||||||||||
16296 | 16296 | James Bryan B000987 | rep | WA | 1913-04-07 | 1915-03-03 | Progressive | -1 | |||||||||||||
16710 | 16710 | Frank Buchanan B001001 | rep | IL | 1913-04-07 | 1915-03-03 | Democrat | 7 | |||||||||||||
22062 | 22062 | James Buchanan B001006 | rep | TX | 1913-04-07 | 1915-03-03 | Democrat | 10 | |||||||||||||
21175 | 21175 | Robert Bulkley B001045 | rep | OH | 1913-04-07 | 1915-03-03 | Democrat | 21 | |||||||||||||
16718 | 16718 | George Burgess B001083 | rep | TX | 1913-04-07 | 1915-03-03 | Democrat | 9 | |||||||||||||
16303 | 16303 | Charles Burke B001087 | rep | SD | 1913-04-07 | 1915-03-03 | Republican | 2 | |||||||||||||
16308 | 16308 | James Burke B001093 | rep | PA | 1913-04-07 | 1915-03-03 | Republican | 31 | |||||||||||||
16721 | 16721 | Michael Burke B001095 | rep | WI | 1913-04-07 | 1915-03-03 | Democrat | 2 | |||||||||||||
16316 | 16316 | Edwin Burleigh B001105 | sen | ME | 1913-04-07 | 1917-03-03 | 2 | Republican | |||||||||||||
16324 | 16324 | Albert Burleson B001110 | rep | TX | 1913-04-07 | 1915-03-03 | Democrat | 10 | |||||||||||||
17587 | 17587 | John Burnett B001121 | rep | AL | 1913-04-07 | 1915-03-03 | Democrat | 7 | |||||||||||||
19248 | 19248 | Thomas Butler B001192 | rep | PA | 1913-04-07 | 1915-03-03 | Republican | 7 | |||||||||||||
22078 | 22078 | James Byrnes B001215 | rep | SC | 1913-04-07 | 1915-03-03 | Democrat | 2 | |||||||||||||
21672 | 21672 | Joseph Byrns B001217 | rep | TN | 1913-04-07 | 1915-03-03 | Democrat | 6 | |||||||||||||
17092 | 17092 | William Calder C000025 | rep | NY | 1913-04-07 | 1915-03-03 | Republican | 6 | |||||||||||||
16724 | 16724 | Oscar Callaway C000056 | rep | TX | 1913-04-07 | 1915-03-03 | Democrat | 12 | |||||||||||||
18088 | 18088 | Philip Campbell C000097 | rep | KS | 1913-04-07 | 1915-03-03 | Republican | 3 | |||||||||||||
17600 | 17600 | Ezekiel Candler C000110 | rep | MS | 1913-04-07 | 1915-03-03 | Democrat | 1 | |||||||||||||
16325 | 16325 | Jacob Cantor C000125 | rep | NY | 1913-04-07 | 1915-03-03 | Democrat | 20 | |||||||||||||
18577 | 18577 | James Cantrill C000126 | rep | KY | 1913-04-07 | 1915-03-03 | Democrat | 7 | |||||||||||||
19256 | 19256 | Thaddeus Caraway C000139 | rep | AR | 1913-04-07 | 1915-03-03 | Democrat | 1 | |||||||||||||
19607 | 19607 | John Carew C000142 | rep | NY | 1913-04-07 | 1915-03-03 | Democrat | 17 | |||||||||||||
17607 | 17607 | Charles Carlin C000151 | rep | VA | 1913-04-07 | 1915-03-03 | Democrat | 8 | |||||||||||||
16326 | 16326 | Wooda Carr C000180 | rep | PA | 1913-04-07 | 1915-03-03 | Democrat | 23 | |||||||||||||
18919 | 18919 | Charles Carter C000196 | rep | OK | 1913-04-07 | 1915-03-03 | Democrat | 4 | |||||||||||||
17101 | 17101 | William Cary C000218 | rep | WI | 1913-04-07 | 1915-03-03 | Republican | 4 | |||||||||||||
19616 | 19616 | John Casey C000223 | rep | PA | 1913-04-07 | 1915-03-03 | Democrat | 11 | |||||||||||||
18118 | 18118 | Walter Chandler C000297 | rep | NY | 1913-04-07 | 1915-03-03 | Progressive | 19 | |||||||||||||
21195 | 21195 | Denver Church C000387 | rep | CA | 1913-04-07 | 1915-03-03 | Democrat | 7 | |||||||||||||
16327 | 16327 | John Clancy C000411 | rep | NY | 1913-04-07 | 1915-03-03 | Democrat | 35 | |||||||||||||
18587 | 18587 | Frank Clark C000430 | rep | FL | 1913-04-07 | 1915-03-03 | Democrat | 2 | |||||||||||||
17620 | 17620 | James Clark C000437 | rep | MO | 1913-04-07 | 1915-03-03 | Democrat | 9 | |||||||||||||
17106 | 17106 | Horatio Claypool C000490 | rep | OH | 1913-04-07 | 1915-03-03 | Democrat | 11 | |||||||||||||
16336 | 16336 | Henry Clayton C000495 | rep | AL | 1913-04-07 | 1915-03-03 | Democrat | 3 | |||||||||||||
16734 | 16734 | Cyrus Cline C000521 | rep | IN | 1913-04-07 | 1915-03-03 | Democrat | 12 | |||||||||||||
17624 | 17624 | Charles Coady C000541 | rep | MD | 1913-04-07 | 1915-03-03 | Democrat | 3 | |||||||||||||
20212 | 20212 | James Collier C000630 | rep | MS | 1913-04-07 | 1915-03-03 | Democrat | 8 | |||||||||||||
17628 | 17628 | LeBaron Colt C000651 | sen | RI | 1913-04-07 | 1919-03-03 | 2 | Republican | |||||||||||||
17109 | 17109 | John Connelly C000689 | rep | KS | 1913-04-07 | 1915-03-03 | Democrat | 6 | |||||||||||||
16337 | 16337 | Maurice Connolly C000699 | rep | IA | 1913-04-07 | 1915-03-03 | Democrat | 3 | |||||||||||||
17114 | 17114 | Michael Conry C000707 | rep | NY | 1913-04-07 | 1915-03-03 | Democrat | 15 | |||||||||||||
20241 | 20241 | Henry Cooper C000752 | rep | WI | 1913-04-07 | 1915-03-03 | Republican | 1 | |||||||||||||
18129 | 18129 | Ira Copley C000770 | rep | IL | 1913-04-07 | 1915-03-03 | Republican | 11 | |||||||||||||
16340 | 16340 | James Covington C000816 | rep | MD | 1913-04-07 | 1915-03-03 | Democrat | 1 | |||||||||||||
17122 | 17122 | William Cox C000840 | rep | IN | 1913-04-07 | 1915-03-03 | Democrat | 3 | |||||||||||||
19628 | 19628 | Louis Cramton C000870 | rep | MI | 1913-04-07 | 1915-03-03 | Republican | 7 | |||||||||||||
20261 | 20261 | Charles Crisp C000909 | rep | GA | 1913-04-07 | 1915-03-03 | Democrat | 3 | |||||||||||||
25639 | 25639 | Robert Crosser C000932 | rep | OH | 1913-04-07 | 1915-03-03 | Democrat | -1 | |||||||||||||
16739 | 16739 | William Cullop C000975 | rep | IN | 1913-04-07 | 1915-03-03 | Democrat | 2 | |||||||||||||
23820 | 23820 | James Curley C000996 | rep | MA | 1913-04-07 | 1915-03-03 | Democrat | 12 | |||||||||||||
19637 | 19637 | Charles Curry C001000 | rep | CA | 1913-04-07 | 1915-03-03 | Republican | 3 | |||||||||||||
17129 | 17129 | Harry Dale D000008 | rep | NY | 1913-04-07 | 1915-03-03 | Democrat | 4 |
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);