legislator_terms
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
485 rows where "end" is on date 1917-03-03 sorted by legislator_id
This data as json, copyable, CSV (advanced)
Suggested facets: 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
16663 | 16663 | John Abercrombie A000013 | rep | AL | 1915-12-06 | 1917-03-03 | Democrat | -1 | |||||||||||||
16668 | 16668 | John Adair A000027 | rep | IN | 1915-12-06 | 1917-03-03 | Democrat | 8 | |||||||||||||
17053 | 17053 | William Adamson A000051 | rep | GA | 1915-12-06 | 1917-03-03 | Democrat | 4 | |||||||||||||
16675 | 16675 | Wyatt Aiken A000064 | rep | SC | 1915-12-06 | 1917-03-03 | Democrat | 3 | |||||||||||||
17536 | 17536 | Joshua Alexander A000098 | rep | MO | 1915-12-06 | 1917-03-03 | Democrat | 3 | |||||||||||||
16678 | 16678 | Alfred Allen A000111 | rep | OH | 1915-12-06 | 1917-03-03 | Democrat | 2 | |||||||||||||
21080 | 21080 | Edward Almon A000162 | rep | AL | 1915-12-06 | 1917-03-03 | Democrat | 8 | |||||||||||||
18566 | 18566 | Sydney Anderson A000233 | rep | MN | 1915-12-06 | 1917-03-03 | Republican | 1 | |||||||||||||
19191 | 19191 | Daniel Anthony A000261 | rep | KS | 1915-12-06 | 1917-03-03 | Republican | 1 | |||||||||||||
22480 | 22480 | William Ashbrook A000306 | rep | OH | 1915-12-06 | 1917-03-03 | Democrat | 17 | |||||||||||||
21622 | 21622 | Henry Ashurst A000319 | sen | AZ | 1912-03-27 | 1917-03-03 | 1 | Democrat | |||||||||||||
20099 | 20099 | James Aswell A000321 | rep | LA | 1915-12-06 | 1917-03-03 | Democrat | 8 | |||||||||||||
17058 | 17058 | Richard Austin A000341 | rep | TN | 1915-12-06 | 1917-03-03 | Republican | 2 | |||||||||||||
21096 | 21096 | William Ayres A000354 | rep | KS | 1915-12-06 | 1917-03-03 | Democrat | 8 | |||||||||||||
21629 | 21629 | Isaac Bacharach B000009 | rep | NJ | 1915-12-06 | 1917-03-03 | Republican | 2 | |||||||||||||
16680 | 16680 | Warren Bailey B000050 | rep | PA | 1915-12-06 | 1917-03-03 | Democrat | 19 | |||||||||||||
16686 | 16686 | Andrew Barchfeld B000133 | rep | PA | 1915-12-06 | 1917-03-03 | Republican | 32 | |||||||||||||
25868 | 25868 | Alben Barkley B000145 | rep | KY | 1915-12-06 | 1917-03-03 | Democrat | 1 | |||||||||||||
17065 | 17065 | Henry Barnhart B000164 | rep | IN | 1915-12-06 | 1917-03-03 | Democrat | 13 | |||||||||||||
17071 | 17071 | Samuel Beakes B000264 | rep | MI | 1915-12-06 | 1917-03-03 | Democrat | 2 | |||||||||||||
16687 | 16687 | Cyrus Beales B000269 | rep | PA | 1915-12-06 | 1917-03-03 | Republican | 20 | |||||||||||||
19579 | 19579 | Thomas Bell B000348 | rep | GA | 1915-12-06 | 1917-03-03 | Democrat | 9 | |||||||||||||
16689 | 16689 | Henry Benedict B000359 | rep | CA | 1915-12-06 | 1917-03-03 | Republican | 10 | |||||||||||||
16693 | 16693 | William Bennet B000370 | rep | NY | 1915-12-06 | 1917-03-03 | Republican | 23 | |||||||||||||
19214 | 19214 | Eugene Black B000495 | rep | TX | 1915-12-06 | 1917-03-03 | Democrat | 1 | |||||||||||||
18045 | 18045 | Fred Blackmon B000514 | rep | AL | 1915-12-06 | 1917-03-03 | Democrat | 4 | |||||||||||||
17568 | 17568 | Charles Booher B000626 | rep | MO | 1915-12-06 | 1917-03-03 | Democrat | 4 | |||||||||||||
17079 | 17079 | William Borland B000643 | rep | MO | 1915-12-06 | 1917-03-03 | Democrat | 5 | |||||||||||||
18055 | 18055 | George Bowers B000690 | rep | WV | 1915-12-06 | 1917-03-03 | Republican | 2 | |||||||||||||
17081 | 17081 | James Britt B000846 | rep | NC | 1915-12-06 | 1917-03-03 | Republican | 10 | |||||||||||||
21151 | 21151 | Frederick Britten B000847 | rep | IL | 1915-12-06 | 1917-03-03 | Republican | 9 | |||||||||||||
16708 | 16708 | William Brown B000949 | rep | WV | 1915-12-06 | 1917-03-03 | Democrat | 2 | |||||||||||||
19599 | 19599 | Edward Browne B000955 | rep | WI | 1915-12-06 | 1917-03-03 | Republican | 8 | |||||||||||||
17573 | 17573 | William Browning B000961 | rep | NJ | 1915-12-06 | 1917-03-03 | Republican | 1 | |||||||||||||
17086 | 17086 | Henry Bruckner B000974 | rep | NY | 1915-12-06 | 1917-03-03 | Democrat | 22 | |||||||||||||
17577 | 17577 | Clement Brumbaugh B000975 | rep | OH | 1915-12-06 | 1917-03-03 | Democrat | 12 | |||||||||||||
15887 | 15887 | Nathan Bryan B000992 | sen | FL | 1911-04-04 | 1917-03-03 | 1 | Democrat | |||||||||||||
16711 | 16711 | Frank Buchanan B001001 | rep | IL | 1915-12-06 | 1917-03-03 | Democrat | 7 | |||||||||||||
22063 | 22063 | James Buchanan B001006 | rep | TX | 1915-12-06 | 1917-03-03 | Democrat | 10 | |||||||||||||
16719 | 16719 | George Burgess B001083 | rep | TX | 1915-12-06 | 1917-03-03 | Democrat | 9 | |||||||||||||
16722 | 16722 | Michael Burke B001095 | rep | WI | 1915-12-06 | 1917-03-03 | Democrat | 2 | |||||||||||||
16316 | 16316 | Edwin Burleigh B001105 | sen | ME | 1913-04-07 | 1917-03-03 | 2 | Republican | |||||||||||||
17588 | 17588 | John Burnett B001121 | rep | AL | 1915-12-06 | 1917-03-03 | Democrat | 7 | |||||||||||||
19249 | 19249 | Thomas Butler B001192 | rep | PA | 1915-12-06 | 1917-03-03 | Republican | 7 | |||||||||||||
22079 | 22079 | James Byrnes B001215 | rep | SC | 1915-12-06 | 1917-03-03 | Democrat | 2 | |||||||||||||
21673 | 21673 | Joseph Byrns B001217 | rep | TN | 1915-12-06 | 1917-03-03 | Democrat | 6 | |||||||||||||
17591 | 17591 | Charles Caldwell C000030 | rep | NY | 1915-12-06 | 1917-03-03 | Democrat | 2 | |||||||||||||
16725 | 16725 | Oscar Callaway C000056 | rep | TX | 1915-12-06 | 1917-03-03 | Democrat | 12 | |||||||||||||
18089 | 18089 | Philip Campbell C000097 | rep | KS | 1915-12-06 | 1917-03-03 | Republican | 3 | |||||||||||||
17601 | 17601 | Ezekiel Candler C000110 | rep | MS | 1915-12-06 | 1917-03-03 | Democrat | 1 | |||||||||||||
18112 | 18112 | Joseph Cannon C000121 | rep | IL | 1915-12-06 | 1917-03-03 | Republican | 18 | |||||||||||||
18578 | 18578 | James Cantrill C000126 | rep | KY | 1915-12-06 | 1917-03-03 | Democrat | 7 | |||||||||||||
17094 | 17094 | John Capstick C000136 | rep | NJ | 1915-12-06 | 1917-03-03 | Republican | 5 | |||||||||||||
19257 | 19257 | Thaddeus Caraway C000139 | rep | AR | 1915-12-06 | 1917-03-03 | Democrat | 1 | |||||||||||||
19608 | 19608 | John Carew C000142 | rep | NY | 1915-12-06 | 1917-03-03 | Democrat | 17 | |||||||||||||
17608 | 17608 | Charles Carlin C000151 | rep | VA | 1915-12-06 | 1917-03-03 | Democrat | 8 | |||||||||||||
18920 | 18920 | Charles Carter C000196 | rep | OK | 1915-12-06 | 1917-03-03 | Democrat | 3 | |||||||||||||
17096 | 17096 | William Carter C000205 | rep | MA | 1915-12-06 | 1917-03-03 | Republican | 13 | |||||||||||||
17102 | 17102 | William Cary C000218 | rep | WI | 1915-12-06 | 1917-03-03 | Republican | 4 | |||||||||||||
19617 | 19617 | John Casey C000223 | rep | PA | 1915-12-06 | 1917-03-03 | Democrat | 11 | |||||||||||||
16244 | 16244 | Thomas Catron C000253 | sen | NM | 1912-01-01 | 1917-03-03 | 1 | Republican | |||||||||||||
18119 | 18119 | Walter Chandler C000297 | rep | NY | 1915-12-06 | 1917-03-03 | Progressive | 19 | |||||||||||||
16728 | 16728 | William Charles C000323 | rep | NY | 1915-12-06 | 1917-03-03 | Republican | 30 | |||||||||||||
15889 | 15889 | William Chilton C000360 | sen | WV | 1911-04-04 | 1917-03-03 | 1 | Democrat | |||||||||||||
20182 | 20182 | Burnett Chiperfield C000364 | rep | IL | 1915-12-06 | 1917-03-03 | Republican | -1 | |||||||||||||
21196 | 21196 | Denver Church C000387 | rep | CA | 1915-12-06 | 1917-03-03 | Democrat | 7 | |||||||||||||
15892 | 15892 | Moses Clapp C000414 | sen | MN | 1911-04-04 | 1917-03-03 | 1 | Republican | |||||||||||||
15898 | 15898 | Clarence Clark C000425 | sen | WY | 1911-04-04 | 1917-03-03 | 1 | Republican | |||||||||||||
18588 | 18588 | Frank Clark C000430 | rep | FL | 1915-12-06 | 1917-03-03 | Democrat | 2 | |||||||||||||
17621 | 17621 | James Clark C000437 | rep | MO | 1915-12-06 | 1917-03-03 | Democrat | 9 | |||||||||||||
16731 | 16731 | James Clarke C000463 | sen | AR | 1915-12-06 | 1917-03-03 | 3 | Democrat | |||||||||||||
16735 | 16735 | Cyrus Cline C000521 | rep | IN | 1915-12-06 | 1917-03-03 | Democrat | 12 | |||||||||||||
17625 | 17625 | Charles Coady C000541 | rep | MD | 1915-12-06 | 1917-03-03 | Democrat | 3 | |||||||||||||
16736 | 16736 | William Coleman C000622 | rep | PA | 1915-12-06 | 1917-03-03 | Republican | 30 | |||||||||||||
20213 | 20213 | James Collier C000630 | rep | MS | 1915-12-06 | 1917-03-03 | Democrat | 8 | |||||||||||||
17110 | 17110 | John Connelly C000689 | rep | KS | 1915-12-06 | 1917-03-03 | Democrat | 6 | |||||||||||||
17115 | 17115 | Michael Conry C000707 | rep | NY | 1915-12-06 | 1917-03-03 | Democrat | 15 | |||||||||||||
17117 | 17117 | Edward Cooper C000748 | rep | WV | 1915-12-06 | 1917-03-03 | Republican | 5 | |||||||||||||
20242 | 20242 | Henry Cooper C000752 | rep | WI | 1915-12-06 | 1917-03-03 | Republican | 1 | |||||||||||||
21710 | 21710 | John Cooper C000757 | rep | OH | 1915-12-06 | 1917-03-03 | Republican | 19 | |||||||||||||
18130 | 18130 | Ira Copley C000770 | rep | IL | 1915-12-06 | 1917-03-03 | Progressive | 11 | |||||||||||||
17630 | 17630 | Peter Costello C000796 | rep | PA | 1915-12-06 | 1917-03-03 | Republican | 5 | |||||||||||||
17123 | 17123 | William Cox C000840 | rep | IN | 1915-12-06 | 1917-03-03 | Democrat | 3 | |||||||||||||
18136 | 18136 | Thomas Crago C000853 | rep | PA | 1915-12-06 | 1917-03-03 | Republican | -1 | |||||||||||||
19629 | 19629 | Louis Cramton C000870 | rep | MI | 1915-12-06 | 1917-03-03 | Republican | 7 | |||||||||||||
20262 | 20262 | Charles Crisp C000909 | rep | GA | 1915-12-06 | 1917-03-03 | Democrat | 3 | |||||||||||||
25640 | 25640 | Robert Crosser C000932 | rep | OH | 1915-12-06 | 1917-03-03 | Democrat | 21 | |||||||||||||
17127 | 17127 | Charles Culberson C000963 | sen | TX | 1911-04-04 | 1917-03-03 | 1 | Democrat | |||||||||||||
16740 | 16740 | William Cullop C000975 | rep | IN | 1915-12-06 | 1917-03-03 | Democrat | 2 | |||||||||||||
19638 | 19638 | Charles Curry C001000 | rep | CA | 1915-12-06 | 1917-03-03 | Republican | 3 | |||||||||||||
17130 | 17130 | Harry Dale D000008 | rep | NY | 1915-12-06 | 1917-03-03 | Democrat | 4 | |||||||||||||
19280 | 19280 | Porter Dale D000009 | rep | VT | 1915-12-06 | 1917-03-03 | Republican | 2 | |||||||||||||
20272 | 20272 | Frederick Dallinger D000012 | rep | MA | 1915-12-06 | 1917-03-03 | Republican | 8 | |||||||||||||
16743 | 16743 | Henry Danforth D000029 | rep | NY | 1915-12-06 | 1917-03-03 | Republican | 39 | |||||||||||||
22549 | 22549 | George Darrow D000063 | rep | PA | 1915-12-06 | 1917-03-03 | Republican | 6 | |||||||||||||
16747 | 16747 | James Davenport D000074 | rep | OK | 1915-12-06 | 1917-03-03 | Democrat | 1 | |||||||||||||
18613 | 18613 | Charles Davis D000093 | rep | MN | 1915-12-06 | 1917-03-03 | Republican | 3 | |||||||||||||
16748 | 16748 | James Davis D000110 | rep | TX | 1915-12-06 | 1917-03-03 | Democrat | -1 | |||||||||||||
17142 | 17142 | Perl Decker D000184 | rep | MO | 1915-12-06 | 1917-03-03 | Democrat | 15 | |||||||||||||
19649 | 19649 | Stephen Dempsey D000229 | rep | NY | 1915-12-06 | 1917-03-03 | Republican | 40 |
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);