legislator_terms
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
499 rows where "end" is on date 1921-03-03 sorted by legislator_id
This data as json, copyable, CSV (advanced)
Suggested facets: type, class, 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
20073 | 20073 | Ernest Ackerman A000021 | rep | NJ | 1919-05-19 | 1921-03-03 | Republican | 5 | |||||||||||||
17538 | 17538 | Joshua Alexander A000098 | rep | MO | 1919-05-19 | 1921-03-03 | Democrat | 3 | |||||||||||||
21082 | 21082 | Edward Almon A000162 | rep | AL | 1919-05-19 | 1921-03-03 | Democrat | 8 | |||||||||||||
18568 | 18568 | Sydney Anderson A000233 | rep | MN | 1919-05-19 | 1921-03-03 | Republican | 1 | |||||||||||||
18034 | 18034 | William Andrews A000251 | rep | NE | 1919-05-19 | 1921-03-03 | Republican | 5 | |||||||||||||
17539 | 17539 | William Andrews A000253 | rep | MD | 1919-05-19 | 1921-03-03 | Republican | 1 | |||||||||||||
19193 | 19193 | Daniel Anthony A000261 | rep | KS | 1919-05-19 | 1921-03-03 | Republican | 1 | |||||||||||||
22482 | 22482 | William Ashbrook A000306 | rep | OH | 1919-05-19 | 1921-03-03 | Democrat | 17 | |||||||||||||
20101 | 20101 | James Aswell A000321 | rep | LA | 1919-05-19 | 1921-03-03 | Democrat | 8 | |||||||||||||
21098 | 21098 | William Ayres A000354 | rep | KS | 1919-05-19 | 1921-03-03 | Democrat | 8 | |||||||||||||
17540 | 17540 | John Babka B000007 | rep | OH | 1919-05-19 | 1921-03-03 | Democrat | 21 | |||||||||||||
21631 | 21631 | Isaac Bacharach B000009 | rep | NJ | 1919-05-19 | 1921-03-03 | Republican | 2 | |||||||||||||
17542 | 17542 | John Baer B000027 | rep | ND | 1919-05-19 | 1921-03-03 | Republican | 1 | |||||||||||||
17558 | 17558 | John Bankhead B000110 | sen | AL | 1919-05-19 | 1921-03-03 | 2 | Democrat | |||||||||||||
22489 | 22489 | William Bankhead B000113 | rep | AL | 1919-05-19 | 1921-03-03 | Democrat | 10 | |||||||||||||
20113 | 20113 | Henry Barbour B000126 | rep | CA | 1919-05-19 | 1921-03-03 | Republican | 7 | |||||||||||||
25870 | 25870 | Alben Barkley B000145 | rep | KY | 1919-05-19 | 1921-03-03 | Democrat | 1 | |||||||||||||
16688 | 16688 | John Beckham B000293 | sen | KY | 1915-12-06 | 1921-03-03 | 3 | Democrat | |||||||||||||
17559 | 17559 | Carlos Bee B000303 | rep | TX | 1919-05-19 | 1921-03-03 | Democrat | 14 | |||||||||||||
19202 | 19202 | James Begg B000314 | rep | OH | 1919-05-19 | 1921-03-03 | Republican | 13 | |||||||||||||
19581 | 19581 | Thomas Bell B000348 | rep | GA | 1919-05-19 | 1921-03-03 | Democrat | 9 | |||||||||||||
18040 | 18040 | John Benham B000361 | rep | IN | 1919-05-19 | 1921-03-03 | Republican | 4 | |||||||||||||
17561 | 17561 | Carville Benson B000387 | rep | MD | 1919-05-19 | 1921-03-03 | Democrat | 2 | |||||||||||||
19208 | 19208 | Victor Berger B000407 | rep | WI | 1919-05-19 | 1921-03-03 | Socialist | -1 | |||||||||||||
19216 | 19216 | Eugene Black B000495 | rep | TX | 1919-05-19 | 1921-03-03 | Democrat | 1 | |||||||||||||
18047 | 18047 | Fred Blackmon B000514 | rep | AL | 1919-05-19 | 1921-03-03 | Democrat | 4 | |||||||||||||
18052 | 18052 | Oscar Bland B000542 | rep | IN | 1919-05-19 | 1921-03-03 | Republican | 2 | |||||||||||||
24743 | 24743 | Schuyler Bland B000545 | rep | VA | 1919-05-19 | 1921-03-03 | Democrat | 1 | |||||||||||||
17562 | 17562 | William Bland B000547 | rep | MO | 1919-05-19 | 1921-03-03 | Democrat | 5 | |||||||||||||
21644 | 21644 | Thomas Blanton B000549 | rep | TX | 1919-05-19 | 1921-03-03 | Democrat | 17 | |||||||||||||
19222 | 19222 | William Boies B000597 | rep | IA | 1919-05-19 | 1921-03-03 | Republican | 11 | |||||||||||||
17570 | 17570 | Charles Booher B000626 | rep | MO | 1919-05-19 | 1921-03-03 | Democrat | 4 | |||||||||||||
18057 | 18057 | George Bowers B000690 | rep | WV | 1919-05-19 | 1921-03-03 | Republican | 2 | |||||||||||||
19229 | 19229 | William Bowling B000702 | rep | AL | 1919-05-19 | 1921-03-03 | Democrat | 5 | |||||||||||||
19588 | 19588 | John Box B000710 | rep | TX | 1919-05-19 | 1921-03-03 | Democrat | 2 | |||||||||||||
21134 | 21134 | Charles Brand B000767 | rep | GA | 1919-05-19 | 1921-03-03 | Democrat | 8 | |||||||||||||
18064 | 18064 | Frank Brandegee B000769 | sen | CT | 1915-12-06 | 1921-03-03 | 3 | Republican | |||||||||||||
21142 | 21142 | Clay Briggs B000826 | rep | TX | 1919-05-19 | 1921-03-03 | Democrat | 7 | |||||||||||||
18067 | 18067 | Samuel Brinson B000840 | rep | NC | 1919-05-19 | 1921-03-03 | Democrat | 3 | |||||||||||||
21153 | 21153 | Frederick Britten B000847 | rep | IL | 1919-05-19 | 1921-03-03 | Republican | 9 | |||||||||||||
18069 | 18069 | Edward Brooks B000876 | rep | PA | 1919-05-19 | 1921-03-03 | Republican | 20 | |||||||||||||
18071 | 18071 | Edwin Brooks B000877 | rep | IL | 1919-05-19 | 1921-03-03 | Republican | 23 | |||||||||||||
19601 | 19601 | Edward Browne B000955 | rep | WI | 1919-05-19 | 1921-03-03 | Republican | 8 | |||||||||||||
17575 | 17575 | William Browning B000961 | rep | NJ | 1919-05-19 | 1921-03-03 | Republican | 1 | |||||||||||||
17579 | 17579 | Clement Brumbaugh B000975 | rep | OH | 1919-05-19 | 1921-03-03 | Democrat | 12 | |||||||||||||
22065 | 22065 | James Buchanan B001006 | rep | TX | 1919-05-19 | 1921-03-03 | Democrat | 10 | |||||||||||||
20137 | 20137 | Clark Burdick B001075 | rep | RI | 1919-05-19 | 1921-03-03 | Republican | 1 | |||||||||||||
18074 | 18074 | William Burke B001101 | rep | PA | 1919-05-19 | 1921-03-03 | Republican | -1 | |||||||||||||
17590 | 17590 | John Burnett B001121 | rep | AL | 1919-05-19 | 1921-03-03 | Democrat | 7 | |||||||||||||
18077 | 18077 | Sherman Burroughs B001138 | rep | NH | 1919-05-19 | 1921-03-03 | Republican | 1 | |||||||||||||
19251 | 19251 | Thomas Butler B001192 | rep | PA | 1919-05-19 | 1921-03-03 | Republican | 7 | |||||||||||||
22081 | 22081 | James Byrnes B001215 | rep | SC | 1919-05-19 | 1921-03-03 | Democrat | 2 | |||||||||||||
21675 | 21675 | Joseph Byrns B001217 | rep | TN | 1919-05-19 | 1921-03-03 | Democrat | 6 | |||||||||||||
17593 | 17593 | Charles Caldwell C000030 | rep | NY | 1919-05-19 | 1921-03-03 | Democrat | 2 | |||||||||||||
20160 | 20160 | Guy Campbell C000084 | rep | PA | 1919-05-19 | 1921-03-03 | Democrat | 32 | |||||||||||||
18091 | 18091 | Philip Campbell C000097 | rep | KS | 1919-05-19 | 1921-03-03 | Republican | 3 | |||||||||||||
17603 | 17603 | Ezekiel Candler C000110 | rep | MS | 1919-05-19 | 1921-03-03 | Democrat | 1 | |||||||||||||
18114 | 18114 | Joseph Cannon C000121 | rep | IL | 1919-05-19 | 1921-03-03 | Republican | 18 | |||||||||||||
18580 | 18580 | James Cantrill C000126 | rep | KY | 1919-05-19 | 1921-03-03 | Democrat | 7 | |||||||||||||
19259 | 19259 | Thaddeus Caraway C000139 | rep | AR | 1919-05-19 | 1921-03-03 | Democrat | 1 | |||||||||||||
19610 | 19610 | John Carew C000142 | rep | NY | 1919-05-19 | 1921-03-03 | Democrat | 18 | |||||||||||||
17610 | 17610 | Charles Carlin C000151 | rep | VA | 1919-05-19 | 1921-03-03 | Democrat | -1 | |||||||||||||
19262 | 19262 | William Carss C000194 | rep | MN | 1919-05-19 | 1921-03-03 | Union Labor | 8 | |||||||||||||
18922 | 18922 | Charles Carter C000196 | rep | OK | 1919-05-19 | 1921-03-03 | Democrat | 3 | |||||||||||||
19618 | 19618 | John Casey C000223 | rep | PA | 1919-05-19 | 1921-03-03 | Democrat | 11 | |||||||||||||
16727 | 16727 | George Chamberlain C000277 | sen | OR | 1915-12-06 | 1921-03-03 | 3 | Democrat | |||||||||||||
20175 | 20175 | Carl Chindblom C000361 | rep | IL | 1919-05-19 | 1921-03-03 | Republican | 10 | |||||||||||||
20187 | 20187 | Charles Christopherson C000384 | rep | SD | 1919-05-19 | 1921-03-03 | Republican | 1 | |||||||||||||
18590 | 18590 | Frank Clark C000430 | rep | FL | 1919-05-19 | 1921-03-03 | Democrat | 2 | |||||||||||||
17623 | 17623 | James Clark C000437 | rep | MO | 1919-05-19 | 1921-03-03 | Democrat | 9 | |||||||||||||
18123 | 18123 | David Classon C000474 | rep | WI | 1919-05-19 | 1921-03-03 | Republican | 9 | |||||||||||||
18928 | 18928 | William Cleary C000500 | rep | NY | 1919-05-19 | 1921-03-03 | Democrat | 8 | |||||||||||||
17627 | 17627 | Charles Coady C000541 | rep | MD | 1919-05-19 | 1921-03-03 | Democrat | 3 | |||||||||||||
18601 | 18601 | Raymond Cole C000613 | rep | OH | 1919-05-19 | 1921-03-03 | Republican | 8 | |||||||||||||
20215 | 20215 | James Collier C000630 | rep | MS | 1919-05-19 | 1921-03-03 | Democrat | 8 | |||||||||||||
18031 | 18031 | Braxton Comer C000657 | sen | AL | 1920-03-05 | 1921-03-03 | 2 | Democrat | appointment | ||||||||||||
24314 | 24314 | Thomas Connally C000684 | rep | TX | 1919-05-19 | 1921-03-03 | Democrat | 11 | |||||||||||||
21712 | 21712 | John Cooper C000757 | rep | OH | 1919-05-19 | 1921-03-03 | Republican | 19 | |||||||||||||
18132 | 18132 | Ira Copley C000770 | rep | IL | 1919-05-19 | 1921-03-03 | Republican | 11 | |||||||||||||
17632 | 17632 | Peter Costello C000796 | rep | PA | 1919-05-19 | 1921-03-03 | Republican | 5 | |||||||||||||
18138 | 18138 | Thomas Crago C000853 | rep | PA | 1919-05-19 | 1921-03-03 | Republican | -1 | |||||||||||||
19631 | 19631 | Louis Cramton C000870 | rep | MI | 1919-05-19 | 1921-03-03 | Republican | 7 | |||||||||||||
20264 | 20264 | Charles Crisp C000909 | rep | GA | 1919-05-19 | 1921-03-03 | Democrat | 3 | |||||||||||||
22945 | 22945 | Frank Crowther C000948 | rep | NY | 1919-05-19 | 1921-03-03 | Republican | 30 | |||||||||||||
23394 | 23394 | Thomas Cullen C000970 | rep | NY | 1919-05-19 | 1921-03-03 | Democrat | 4 | |||||||||||||
18143 | 18143 | Albert Cummins C000988 | sen | IA | 1915-12-06 | 1921-03-03 | 3 | Republican | |||||||||||||
17634 | 17634 | Gilbert Currie C000998 | rep | MI | 1919-05-19 | 1921-03-03 | Republican | 10 | |||||||||||||
19640 | 19640 | Charles Curry C001000 | rep | CA | 1919-05-19 | 1921-03-03 | Republican | 3 | |||||||||||||
19277 | 19277 | Charles Curtis C001008 | sen | KS | 1915-12-06 | 1921-03-03 | 3 | Republican | |||||||||||||
19282 | 19282 | Porter Dale D000009 | rep | VT | 1919-05-19 | 1921-03-03 | Republican | 2 | |||||||||||||
20274 | 20274 | Frederick Dallinger D000012 | rep | MA | 1919-05-19 | 1921-03-03 | Republican | 8 | |||||||||||||
22551 | 22551 | George Darrow D000063 | rep | PA | 1919-05-19 | 1921-03-03 | Republican | 6 | |||||||||||||
19287 | 19287 | Martin Davey D000080 | rep | OH | 1919-05-19 | 1921-03-03 | Democrat | 14 | |||||||||||||
20331 | 20331 | Félix Dávila D000090 | rep | PR | 1919-05-19 | 1921-03-03 | Unionist | 0 | |||||||||||||
18615 | 18615 | Charles Davis D000093 | rep | MN | 1919-05-19 | 1921-03-03 | Republican | 3 | |||||||||||||
20285 | 20285 | Ewin Davis D000098 | rep | TN | 1919-05-19 | 1921-03-03 | Democrat | 5 | |||||||||||||
19651 | 19651 | Stephen Dempsey D000229 | rep | NY | 1919-05-19 | 1921-03-03 | Republican | 40 | |||||||||||||
19659 | 19659 | Edward Denison D000237 | rep | IL | 1919-05-19 | 1921-03-03 | Republican | 25 | |||||||||||||
17640 | 17640 | Stanley Dent D000256 | rep | AL | 1919-05-19 | 1921-03-03 | Democrat | 2 | |||||||||||||
18146 | 18146 | Jaime De Veyra D000276 | rep | PI | 1919-05-19 | 1921-03-03 | 0 |
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);