legislator_terms
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
498 rows where "end" is on date 1923-03-03 sorted by legislator_id
This data as json, copyable, CSV (advanced)
Suggested facets: start, class, 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
21066 | 21066 | Charles Abernethy A000015 | rep | NC | 1921-04-11 | 1923-03-03 | Democrat | 3 | |||||||||||||
20074 | 20074 | Ernest Ackerman A000021 | rep | NJ | 1921-04-11 | 1923-03-03 | Republican | 5 | |||||||||||||
21083 | 21083 | Edward Almon A000162 | rep | AL | 1921-04-11 | 1923-03-03 | Democrat | 8 | |||||||||||||
18569 | 18569 | Sydney Anderson A000233 | rep | MN | 1921-04-11 | 1923-03-03 | Republican | 1 | |||||||||||||
21607 | 21607 | Abram Andrew A000240 | rep | MA | 1921-04-11 | 1923-03-03 | Republican | 6 | |||||||||||||
18035 | 18035 | William Andrews A000251 | rep | NE | 1921-04-11 | 1923-03-03 | Republican | 5 | |||||||||||||
18036 | 18036 | Martin Ansorge A000260 | rep | NY | 1921-04-11 | 1923-03-03 | Republican | 21 | |||||||||||||
19194 | 19194 | Daniel Anthony A000261 | rep | KS | 1921-04-11 | 1923-03-03 | Republican | 1 | |||||||||||||
18037 | 18037 | Theodore Appleby A000267 | rep | NJ | 1921-04-11 | 1923-03-03 | Republican | 3 | |||||||||||||
20093 | 20093 | Samuel Arentz A000277 | rep | NV | 1921-04-11 | 1923-03-03 | Republican | 0 | |||||||||||||
21623 | 21623 | Henry Ashurst A000319 | sen | AZ | 1917-04-02 | 1923-03-03 | 1 | Democrat | |||||||||||||
20102 | 20102 | James Aswell A000321 | rep | LA | 1921-04-11 | 1923-03-03 | Democrat | 8 | |||||||||||||
18038 | 18038 | William Atkeson A000326 | rep | MO | 1921-04-11 | 1923-03-03 | Republican | 6 | |||||||||||||
21632 | 21632 | Isaac Bacharach B000009 | rep | NJ | 1921-04-11 | 1923-03-03 | Republican | 2 | |||||||||||||
18039 | 18039 | Henry Baldwin B000088 | rep | HI | 1921-04-11 | 1923-03-03 | Republican | -1 | |||||||||||||
22490 | 22490 | William Bankhead B000113 | rep | AL | 1921-04-11 | 1923-03-03 | Democrat | 10 | |||||||||||||
20114 | 20114 | Henry Barbour B000126 | rep | CA | 1921-04-11 | 1923-03-03 | Republican | 7 | |||||||||||||
25871 | 25871 | Alben Barkley B000145 | rep | KY | 1921-04-11 | 1923-03-03 | Democrat | 1 | |||||||||||||
18558 | 18558 | Thomas Bayard B000252 | sen | DE | 1922-11-08 | 1923-03-03 | 1 | Democrat | |||||||||||||
19198 | 19198 | Joseph Beck B000291 | rep | WI | 1921-04-11 | 1923-03-03 | Republican | 7 | |||||||||||||
21112 | 21112 | Carroll Beedy B000307 | rep | ME | 1921-04-11 | 1923-03-03 | Republican | 1 | |||||||||||||
19203 | 19203 | James Begg B000314 | rep | OH | 1921-04-11 | 1923-03-03 | Republican | 13 | |||||||||||||
19582 | 19582 | Thomas Bell B000348 | rep | GA | 1921-04-11 | 1923-03-03 | Democrat | 9 | |||||||||||||
18041 | 18041 | John Benham B000361 | rep | IN | 1921-04-11 | 1923-03-03 | Republican | 4 | |||||||||||||
18042 | 18042 | Richard Bird B000479 | rep | KS | 1921-04-11 | 1923-03-03 | Republican | 8 | |||||||||||||
18911 | 18911 | Harris Bixler B000493 | rep | PA | 1921-04-11 | 1923-03-03 | Republican | 28 | |||||||||||||
19217 | 19217 | Eugene Black B000495 | rep | TX | 1921-04-11 | 1923-03-03 | Democrat | 1 | |||||||||||||
18048 | 18048 | Fred Blackmon B000514 | rep | AL | 1921-04-11 | 1923-03-03 | Democrat | -1 | |||||||||||||
18050 | 18050 | Albert Blakeney B000535 | rep | MD | 1921-04-11 | 1923-03-03 | Republican | 2 | |||||||||||||
18053 | 18053 | Oscar Bland B000542 | rep | IN | 1921-04-11 | 1923-03-03 | Republican | 2 | |||||||||||||
24744 | 24744 | Schuyler Bland B000545 | rep | VA | 1921-04-11 | 1923-03-03 | Democrat | 1 | |||||||||||||
21645 | 21645 | Thomas Blanton B000549 | rep | TX | 1921-04-11 | 1923-03-03 | Democrat | 17 | |||||||||||||
19223 | 19223 | William Boies B000597 | rep | IA | 1921-04-11 | 1923-03-03 | Republican | 11 | |||||||||||||
18054 | 18054 | Charles Bond B000610 | rep | NY | 1921-04-11 | 1923-03-03 | Republican | 8 | |||||||||||||
18058 | 18058 | George Bowers B000690 | rep | WV | 1921-04-11 | 1923-03-03 | Republican | 2 | |||||||||||||
19230 | 19230 | William Bowling B000702 | rep | AL | 1921-04-11 | 1923-03-03 | Democrat | 5 | |||||||||||||
19589 | 19589 | John Box B000710 | rep | TX | 1921-04-11 | 1923-03-03 | Democrat | 2 | |||||||||||||
21135 | 21135 | Charles Brand B000767 | rep | GA | 1921-04-11 | 1923-03-03 | Democrat | 8 | |||||||||||||
18066 | 18066 | Vincent Brennan B000800 | rep | MI | 1921-04-11 | 1923-03-03 | Republican | 13 | |||||||||||||
21143 | 21143 | Clay Briggs B000826 | rep | TX | 1921-04-11 | 1923-03-03 | Democrat | 7 | |||||||||||||
18068 | 18068 | Samuel Brinson B000840 | rep | NC | 1921-04-11 | 1923-03-03 | Democrat | 3 | |||||||||||||
21154 | 21154 | Frederick Britten B000847 | rep | IL | 1921-04-11 | 1923-03-03 | Republican | 9 | |||||||||||||
18070 | 18070 | Edward Brooks B000876 | rep | PA | 1921-04-11 | 1923-03-03 | Republican | 20 | |||||||||||||
18072 | 18072 | Edwin Brooks B000877 | rep | IL | 1921-04-11 | 1923-03-03 | Republican | 23 | |||||||||||||
18073 | 18073 | Joseph Brown B000935 | rep | TN | 1921-04-11 | 1923-03-03 | Republican | 3 | |||||||||||||
19602 | 19602 | Edward Browne B000955 | rep | WI | 1921-04-11 | 1923-03-03 | Republican | 8 | |||||||||||||
22066 | 22066 | James Buchanan B001006 | rep | TX | 1921-04-11 | 1923-03-03 | Democrat | 10 | |||||||||||||
24775 | 24775 | Alfred Bulwinkle B001056 | rep | NC | 1921-04-11 | 1923-03-03 | Democrat | 9 | |||||||||||||
20138 | 20138 | Clark Burdick B001075 | rep | RI | 1921-04-11 | 1923-03-03 | Republican | 1 | |||||||||||||
18075 | 18075 | William Burke B001101 | rep | PA | 1921-04-11 | 1923-03-03 | Republican | -1 | |||||||||||||
18078 | 18078 | Sherman Burroughs B001138 | rep | NH | 1921-04-11 | 1923-03-03 | Republican | 1 | |||||||||||||
20144 | 20144 | Olger Burtness B001146 | rep | ND | 1921-04-11 | 1923-03-03 | Republican | 1 | |||||||||||||
19564 | 19564 | Theodore Burton B001159 | rep | OH | 1921-04-11 | 1923-03-03 | Republican | 22 | |||||||||||||
19252 | 19252 | Thomas Butler B001192 | rep | PA | 1921-04-11 | 1923-03-03 | Republican | 7 | |||||||||||||
22082 | 22082 | James Byrnes B001215 | rep | SC | 1921-04-11 | 1923-03-03 | Democrat | 2 | |||||||||||||
21676 | 21676 | Joseph Byrns B001217 | rep | TN | 1921-04-11 | 1923-03-03 | Democrat | 6 | |||||||||||||
20153 | 20153 | John Cable C000007 | rep | OH | 1921-04-11 | 1923-03-03 | Republican | 4 | |||||||||||||
17093 | 17093 | William Calder C000025 | sen | NY | 1917-04-02 | 1923-03-03 | 1 | Republican | |||||||||||||
20161 | 20161 | Guy Campbell C000084 | rep | PA | 1921-04-11 | 1923-03-03 | Democrat | 32 | |||||||||||||
18092 | 18092 | Philip Campbell C000097 | rep | KS | 1921-04-11 | 1923-03-03 | Republican | 3 | |||||||||||||
18115 | 18115 | Joseph Cannon C000121 | rep | IL | 1921-04-11 | 1923-03-03 | Republican | 18 | |||||||||||||
18581 | 18581 | James Cantrill C000126 | rep | KY | 1921-04-11 | 1923-03-03 | Democrat | 7 | |||||||||||||
19611 | 19611 | John Carew C000142 | rep | NY | 1921-04-11 | 1923-03-03 | Democrat | 18 | |||||||||||||
18923 | 18923 | Charles Carter C000196 | rep | OK | 1921-04-11 | 1923-03-03 | Democrat | 3 | |||||||||||||
19622 | 19622 | William Chalmers C000274 | rep | OH | 1921-04-11 | 1923-03-03 | Republican | 9 | |||||||||||||
18117 | 18117 | Thomas Chandler C000295 | rep | OK | 1921-04-11 | 1923-03-03 | Republican | 1 | |||||||||||||
18121 | 18121 | Walter Chandler C000297 | rep | NY | 1921-04-11 | 1923-03-03 | Republican | 19 | |||||||||||||
20176 | 20176 | Carl Chindblom C000361 | rep | IL | 1921-04-11 | 1923-03-03 | Republican | 10 | |||||||||||||
20188 | 20188 | Charles Christopherson C000384 | rep | SD | 1921-04-11 | 1923-03-03 | Republican | 1 | |||||||||||||
20194 | 20194 | Frank Clague C000401 | rep | MN | 1921-04-11 | 1923-03-03 | Republican | 2 | |||||||||||||
18591 | 18591 | Frank Clark C000430 | rep | FL | 1921-04-11 | 1923-03-03 | Democrat | 2 | |||||||||||||
21199 | 21199 | John Clarke C000465 | rep | NY | 1921-04-11 | 1923-03-03 | Republican | 34 | |||||||||||||
18124 | 18124 | David Classon C000474 | rep | WI | 1921-04-11 | 1923-03-03 | Republican | 9 | |||||||||||||
18125 | 18125 | Wynne Clouse C000532 | rep | TN | 1921-04-11 | 1923-03-03 | Republican | 4 | |||||||||||||
18599 | 18599 | William Cockran C000575 | rep | NY | 1921-04-11 | 1923-03-03 | Democrat | 16 | |||||||||||||
18126 | 18126 | George Codd C000579 | rep | MI | 1921-04-11 | 1923-03-03 | Republican | 1 | |||||||||||||
20204 | 20204 | Cyrenus Cole C000608 | rep | IA | 1921-04-11 | 1923-03-03 | Republican | 5 | |||||||||||||
18602 | 18602 | Raymond Cole C000613 | rep | OH | 1921-04-11 | 1923-03-03 | Republican | 8 | |||||||||||||
20216 | 20216 | James Collier C000630 | rep | MS | 1921-04-11 | 1923-03-03 | Democrat | 8 | |||||||||||||
22931 | 22931 | Ross Collins C000642 | rep | MS | 1921-04-11 | 1923-03-03 | Democrat | 5 | |||||||||||||
20222 | 20222 | Don Colton C000652 | rep | UT | 1921-04-11 | 1923-03-03 | Republican | 1 | |||||||||||||
24315 | 24315 | Thomas Connally C000684 | rep | TX | 1921-04-11 | 1923-03-03 | Democrat | 11 | |||||||||||||
18127 | 18127 | Charles Connell C000685 | rep | PA | 1921-04-11 | 1923-03-03 | Republican | 10 | |||||||||||||
21211 | 21211 | James Connolly C000698 | rep | PA | 1921-04-11 | 1923-03-03 | Republican | 5 | |||||||||||||
20244 | 20244 | Henry Cooper C000752 | rep | WI | 1921-04-11 | 1923-03-03 | Republican | 1 | |||||||||||||
21713 | 21713 | John Cooper C000757 | rep | OH | 1921-04-11 | 1923-03-03 | Republican | 19 | |||||||||||||
18133 | 18133 | Ira Copley C000770 | rep | IL | 1921-04-11 | 1923-03-03 | Republican | 11 | |||||||||||||
18134 | 18134 | Clarence Coughlin C000806 | rep | PA | 1921-04-11 | 1923-03-03 | Republican | 11 | |||||||||||||
18139 | 18139 | Thomas Crago C000853 | rep | PA | 1921-04-11 | 1923-03-03 | Republican | -1 | |||||||||||||
19632 | 19632 | Louis Cramton C000870 | rep | MI | 1921-04-11 | 1923-03-03 | Republican | 7 | |||||||||||||
20265 | 20265 | Charles Crisp C000909 | rep | GA | 1921-04-11 | 1923-03-03 | Democrat | 3 | |||||||||||||
18140 | 18140 | William Crow C000938 | sen | PA | 1921-10-17 | 1923-03-03 | 1 | Republican | appointment | ||||||||||||
22946 | 22946 | Frank Crowther C000948 | rep | NY | 1921-04-11 | 1923-03-03 | Republican | 30 | |||||||||||||
17128 | 17128 | Charles Culberson C000963 | sen | TX | 1917-04-02 | 1923-03-03 | 1 | Democrat | |||||||||||||
23395 | 23395 | Thomas Cullen C000970 | rep | NY | 1921-04-11 | 1923-03-03 | Democrat | 4 | |||||||||||||
19641 | 19641 | Charles Curry C001000 | rep | CA | 1921-04-11 | 1923-03-03 | Republican | 3 | |||||||||||||
19283 | 19283 | Porter Dale D000009 | rep | VT | 1921-04-11 | 1923-03-03 | Republican | 2 | |||||||||||||
20275 | 20275 | Frederick Dallinger D000012 | rep | MA | 1921-04-11 | 1923-03-03 | Republican | 8 | |||||||||||||
22552 | 22552 | George Darrow D000063 | rep | PA | 1921-04-11 | 1923-03-03 | Republican | 6 | |||||||||||||
20332 | 20332 | Félix Dávila D000090 | rep | PR | 1921-04-11 | 1923-03-03 | Unionist | 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);