legislator_terms
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
506 rows where "end" is on date 1919-03-03 sorted by legislator_id
This data as json, copyable, CSV (advanced)
Suggested facets: party, start (date), end (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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
17054 | 17054 | William Adamson A000051 | rep | GA | 1917-04-02 | 1919-03-03 | Democrat | 4 | |||||||||||||
17537 | 17537 | Joshua Alexander A000098 | rep | MO | 1917-04-02 | 1919-03-03 | Democrat | 3 | |||||||||||||
21081 | 21081 | Edward Almon A000162 | rep | AL | 1917-04-02 | 1919-03-03 | Democrat | 8 | |||||||||||||
18567 | 18567 | Sydney Anderson A000233 | rep | MN | 1917-04-02 | 1919-03-03 | Republican | 1 | |||||||||||||
19192 | 19192 | Daniel Anthony A000261 | rep | KS | 1917-04-02 | 1919-03-03 | Republican | 1 | |||||||||||||
22481 | 22481 | William Ashbrook A000306 | rep | OH | 1917-04-02 | 1919-03-03 | Democrat | 17 | |||||||||||||
20100 | 20100 | James Aswell A000321 | rep | LA | 1917-04-02 | 1919-03-03 | Democrat | 8 | |||||||||||||
17059 | 17059 | Richard Austin A000341 | rep | TN | 1917-04-02 | 1919-03-03 | Republican | 2 | |||||||||||||
21097 | 21097 | William Ayres A000354 | rep | KS | 1917-04-02 | 1919-03-03 | Democrat | 8 | |||||||||||||
21630 | 21630 | Isaac Bacharach B000009 | rep | NJ | 1917-04-02 | 1919-03-03 | Republican | 2 | |||||||||||||
17060 | 17060 | Mark Bacon B000018 | rep | MI | 1917-04-02 | 1919-03-03 | Republican | 2 | |||||||||||||
17541 | 17541 | John Baer B000027 | rep | ND | 1917-04-02 | 1919-03-03 | Republican | 1 | |||||||||||||
17520 | 17520 | David Baird B000052 | sen | NJ | 1918-02-23 | 1919-03-03 | 2 | Republican | appointment | ||||||||||||
17557 | 17557 | John Bankhead B000110 | sen | AL | 1913-04-07 | 1919-03-03 | 2 | Democrat | |||||||||||||
22488 | 22488 | William Bankhead B000113 | rep | AL | 1917-04-02 | 1919-03-03 | Democrat | 10 | |||||||||||||
25869 | 25869 | Alben Barkley B000145 | rep | KY | 1917-04-02 | 1919-03-03 | Democrat | 1 | |||||||||||||
17066 | 17066 | Henry Barnhart B000164 | rep | IN | 1917-04-02 | 1919-03-03 | Democrat | 13 | |||||||||||||
17069 | 17069 | Elsworth Bathrick B000240 | rep | OH | 1917-04-02 | 1919-03-03 | Democrat | 14 | |||||||||||||
17072 | 17072 | Samuel Beakes B000264 | rep | MI | 1917-04-02 | 1919-03-03 | Democrat | 2 | |||||||||||||
19580 | 19580 | Thomas Bell B000348 | rep | GA | 1917-04-02 | 1919-03-03 | Democrat | 9 | |||||||||||||
17521 | 17521 | Christie Benet B000360 | sen | SC | 1918-07-06 | 1919-03-03 | 2 | Democrat | appointment | ||||||||||||
17560 | 17560 | Carville Benson B000387 | rep | MD | 1917-04-02 | 1919-03-03 | Democrat | 2 | |||||||||||||
17073 | 17073 | Earl Beshlin B000421 | rep | PA | 1917-04-02 | 1919-03-03 | Democrat | 28 | |||||||||||||
17074 | 17074 | William Birch B000476 | rep | NJ | 1917-04-02 | 1919-03-03 | Republican | 5 | |||||||||||||
19215 | 19215 | Eugene Black B000495 | rep | TX | 1917-04-02 | 1919-03-03 | Democrat | 1 | |||||||||||||
18046 | 18046 | Fred Blackmon B000514 | rep | AL | 1917-04-02 | 1919-03-03 | Democrat | 4 | |||||||||||||
18051 | 18051 | Oscar Bland B000542 | rep | IN | 1917-04-02 | 1919-03-03 | Republican | 2 | |||||||||||||
24742 | 24742 | Schuyler Bland B000545 | rep | VA | 1917-04-02 | 1919-03-03 | Democrat | 1 | |||||||||||||
21643 | 21643 | Thomas Blanton B000549 | rep | TX | 1917-04-02 | 1919-03-03 | Democrat | 16 | |||||||||||||
17075 | 17075 | Orrin Bleakley B000552 | rep | PA | 1917-04-02 | 1919-03-03 | Republican | 28 | |||||||||||||
17569 | 17569 | Charles Booher B000626 | rep | MO | 1917-04-02 | 1919-03-03 | Democrat | 4 | |||||||||||||
22048 | 22048 | William Borah B000634 | sen | ID | 1913-04-07 | 1919-03-03 | 2 | Republican | |||||||||||||
17080 | 17080 | William Borland B000643 | rep | MO | 1917-04-02 | 1919-03-03 | Democrat | 5 | |||||||||||||
18056 | 18056 | George Bowers B000690 | rep | WV | 1917-04-02 | 1919-03-03 | Republican | 2 | |||||||||||||
16695 | 16695 | James Brady B000753 | sen | ID | 1915-12-06 | 1919-03-03 | 3 | Republican | |||||||||||||
21133 | 21133 | Charles Brand B000767 | rep | GA | 1917-04-02 | 1919-03-03 | Democrat | 8 | |||||||||||||
17082 | 17082 | James Britt B000846 | rep | NC | 1917-04-02 | 1919-03-03 | Republican | 10 | |||||||||||||
21152 | 21152 | Frederick Britten B000847 | rep | IL | 1917-04-02 | 1919-03-03 | Republican | 9 | |||||||||||||
17084 | 17084 | Andrew Brodbeck B000855 | rep | PA | 1917-04-02 | 1919-03-03 | Democrat | 20 | |||||||||||||
16705 | 16705 | Robert Broussard B000896 | sen | LA | 1915-12-06 | 1919-03-03 | 3 | Democrat | |||||||||||||
19600 | 19600 | Edward Browne B000955 | rep | WI | 1917-04-02 | 1919-03-03 | Republican | 8 | |||||||||||||
17574 | 17574 | William Browning B000961 | rep | NJ | 1917-04-02 | 1919-03-03 | Republican | 1 | |||||||||||||
17087 | 17087 | Henry Bruckner B000974 | rep | NY | 1917-04-02 | 1919-03-03 | Democrat | 22 | |||||||||||||
17578 | 17578 | Clement Brumbaugh B000975 | rep | OH | 1917-04-02 | 1919-03-03 | Democrat | 12 | |||||||||||||
22064 | 22064 | James Buchanan B001006 | rep | TX | 1917-04-02 | 1919-03-03 | Democrat | 10 | |||||||||||||
17589 | 17589 | John Burnett B001121 | rep | AL | 1917-04-02 | 1919-03-03 | Democrat | 7 | |||||||||||||
18076 | 18076 | Sherman Burroughs B001138 | rep | NH | 1917-04-02 | 1919-03-03 | Republican | 1 | |||||||||||||
19250 | 19250 | Thomas Butler B001192 | rep | PA | 1917-04-02 | 1919-03-03 | Republican | 7 | |||||||||||||
22080 | 22080 | James Byrnes B001215 | rep | SC | 1917-04-02 | 1919-03-03 | Democrat | 2 | |||||||||||||
21674 | 21674 | Joseph Byrns B001217 | rep | TN | 1917-04-02 | 1919-03-03 | Democrat | 6 | |||||||||||||
17592 | 17592 | Charles Caldwell C000030 | rep | NY | 1917-04-02 | 1919-03-03 | Democrat | 2 | |||||||||||||
20159 | 20159 | Guy Campbell C000084 | rep | PA | 1917-04-02 | 1919-03-03 | Democrat | 32 | |||||||||||||
18090 | 18090 | Philip Campbell C000097 | rep | KS | 1917-04-02 | 1919-03-03 | Republican | 3 | |||||||||||||
17602 | 17602 | Ezekiel Candler C000110 | rep | MS | 1917-04-02 | 1919-03-03 | Democrat | 1 | |||||||||||||
18113 | 18113 | Joseph Cannon C000121 | rep | IL | 1917-04-02 | 1919-03-03 | Republican | 18 | |||||||||||||
18579 | 18579 | James Cantrill C000126 | rep | KY | 1917-04-02 | 1919-03-03 | Democrat | 7 | |||||||||||||
17095 | 17095 | John Capstick C000136 | rep | NJ | 1917-04-02 | 1919-03-03 | Republican | 5 | |||||||||||||
19258 | 19258 | Thaddeus Caraway C000139 | rep | AR | 1917-04-02 | 1919-03-03 | Democrat | 1 | |||||||||||||
19609 | 19609 | John Carew C000142 | rep | NY | 1917-04-02 | 1919-03-03 | Democrat | 17 | |||||||||||||
17609 | 17609 | Charles Carlin C000151 | rep | VA | 1917-04-02 | 1919-03-03 | Democrat | 8 | |||||||||||||
18921 | 18921 | Charles Carter C000196 | rep | OK | 1917-04-02 | 1919-03-03 | Democrat | 3 | |||||||||||||
17097 | 17097 | William Carter C000205 | rep | MA | 1917-04-02 | 1919-03-03 | Republican | 13 | |||||||||||||
17103 | 17103 | William Cary C000218 | rep | WI | 1917-04-02 | 1919-03-03 | Republican | 4 | |||||||||||||
18116 | 18116 | Thomas Chandler C000295 | rep | OK | 1917-04-02 | 1919-03-03 | Republican | 1 | |||||||||||||
18120 | 18120 | Walter Chandler C000297 | rep | NY | 1917-04-02 | 1919-03-03 | Republican | 19 | |||||||||||||
21197 | 21197 | Denver Church C000387 | rep | CA | 1917-04-02 | 1919-03-03 | Democrat | 7 | |||||||||||||
18589 | 18589 | Frank Clark C000430 | rep | FL | 1917-04-02 | 1919-03-03 | Democrat | 2 | |||||||||||||
17104 | 17104 | Henry Clark C000433 | rep | PA | 1917-04-02 | 1919-03-03 | Republican | 25 | |||||||||||||
17622 | 17622 | James Clark C000437 | rep | MO | 1917-04-02 | 1919-03-03 | Democrat | 9 | |||||||||||||
18122 | 18122 | David Classon C000474 | rep | WI | 1917-04-02 | 1919-03-03 | Republican | 9 | |||||||||||||
17107 | 17107 | Horatio Claypool C000490 | rep | OH | 1917-04-02 | 1919-03-03 | Democrat | 11 | |||||||||||||
18927 | 18927 | William Cleary C000500 | rep | NY | 1917-04-02 | 1919-03-03 | Democrat | 8 | |||||||||||||
17626 | 17626 | Charles Coady C000541 | rep | MD | 1917-04-02 | 1919-03-03 | Democrat | 3 | |||||||||||||
20214 | 20214 | James Collier C000630 | rep | MS | 1917-04-02 | 1919-03-03 | Democrat | 8 | |||||||||||||
17628 | 17628 | LeBaron Colt C000651 | sen | RI | 1913-04-07 | 1919-03-03 | 2 | Republican | |||||||||||||
17108 | 17108 | Daniel Comstock C000663 | rep | IN | 1917-04-02 | 1919-03-03 | Republican | 6 | |||||||||||||
24313 | 24313 | Thomas Connally C000684 | rep | TX | 1917-04-02 | 1919-03-03 | Democrat | 11 | |||||||||||||
17111 | 17111 | John Connelly C000689 | rep | KS | 1917-04-02 | 1919-03-03 | Democrat | 6 | |||||||||||||
17116 | 17116 | Michael Conry C000707 | rep | NY | 1917-04-02 | 1919-03-03 | Democrat | -1 | |||||||||||||
17118 | 17118 | Edward Cooper C000748 | rep | WV | 1917-04-02 | 1919-03-03 | Republican | 5 | |||||||||||||
20243 | 20243 | Henry Cooper C000752 | rep | WI | 1917-04-02 | 1919-03-03 | Republican | 1 | |||||||||||||
21711 | 21711 | John Cooper C000757 | rep | OH | 1917-04-02 | 1919-03-03 | Republican | 19 | |||||||||||||
18131 | 18131 | Ira Copley C000770 | rep | IL | 1917-04-02 | 1919-03-03 | Republican | 11 | |||||||||||||
17631 | 17631 | Peter Costello C000796 | rep | PA | 1917-04-02 | 1919-03-03 | Republican | 5 | |||||||||||||
17124 | 17124 | William Cox C000840 | rep | IN | 1917-04-02 | 1919-03-03 | Democrat | 3 | |||||||||||||
18137 | 18137 | Thomas Crago C000853 | rep | PA | 1917-04-02 | 1919-03-03 | Republican | -1 | |||||||||||||
19630 | 19630 | Louis Cramton C000870 | rep | MI | 1917-04-02 | 1919-03-03 | Republican | 7 | |||||||||||||
20263 | 20263 | Charles Crisp C000909 | rep | GA | 1917-04-02 | 1919-03-03 | Democrat | 3 | |||||||||||||
25641 | 25641 | Robert Crosser C000932 | rep | OH | 1917-04-02 | 1919-03-03 | Democrat | 21 | |||||||||||||
17633 | 17633 | Gilbert Currie C000998 | rep | MI | 1917-04-02 | 1919-03-03 | Republican | 10 | |||||||||||||
19639 | 19639 | Charles Curry C001000 | rep | CA | 1917-04-02 | 1919-03-03 | Republican | 3 | |||||||||||||
17131 | 17131 | Harry Dale D000008 | rep | NY | 1917-04-02 | 1919-03-03 | Democrat | 4 | |||||||||||||
19281 | 19281 | Porter Dale D000009 | rep | VT | 1917-04-02 | 1919-03-03 | Republican | 2 | |||||||||||||
20273 | 20273 | Frederick Dallinger D000012 | rep | MA | 1917-04-02 | 1919-03-03 | Republican | 8 | |||||||||||||
22550 | 22550 | George Darrow D000063 | rep | PA | 1917-04-02 | 1919-03-03 | Republican | 6 | |||||||||||||
19286 | 19286 | Martin Davey D000080 | rep | OH | 1917-04-02 | 1919-03-03 | Democrat | 14 | |||||||||||||
17140 | 17140 | James Davidson D000084 | rep | WI | 1917-04-02 | 1919-03-03 | Republican | 6 | |||||||||||||
20330 | 20330 | Félix Dávila D000090 | rep | PR | 1917-04-02 | 1919-03-03 | Unionist | 0 | |||||||||||||
18614 | 18614 | Charles Davis D000093 | rep | MN | 1917-04-02 | 1919-03-03 | Republican | 3 | |||||||||||||
17143 | 17143 | Perl Decker D000184 | rep | MO | 1917-04-02 | 1919-03-03 | Democrat | 15 |
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);