legislator_terms
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
493 rows where "end" is on date 1925-03-03 sorted by legislator_id
This data as json, copyable, CSV (advanced)
Suggested facets: start
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
21067 | 21067 | Charles Abernethy A000015 | rep | NC | 1923-12-03 | 1925-03-03 | Democrat | 3 | |||||||||||||
20075 | 20075 | Ernest Ackerman A000021 | rep | NJ | 1923-12-03 | 1925-03-03 | Republican | 5 | |||||||||||||
22468 | 22468 | Alva Adams A000028 | sen | CO | 1923-12-03 | 1925-03-03 | 3 | Democrat | appointment | ||||||||||||
20084 | 20084 | Richard Aldrich A000084 | rep | RI | 1923-12-03 | 1925-03-03 | Republican | 2 | |||||||||||||
18563 | 18563 | Robert Allen A000144 | rep | WV | 1923-12-03 | 1925-03-03 | Democrat | 2 | |||||||||||||
21074 | 21074 | Miles Allgood A000156 | rep | AL | 1923-12-03 | 1925-03-03 | Democrat | 7 | |||||||||||||
21084 | 21084 | Edward Almon A000162 | rep | AL | 1923-12-03 | 1925-03-03 | Democrat | 8 | |||||||||||||
18570 | 18570 | Sydney Anderson A000233 | rep | MN | 1923-12-03 | 1925-03-03 | Republican | 1 | |||||||||||||
21608 | 21608 | Abram Andrew A000240 | rep | MA | 1923-12-03 | 1925-03-03 | Republican | 6 | |||||||||||||
19195 | 19195 | Daniel Anthony A000261 | rep | KS | 1923-12-03 | 1925-03-03 | Republican | 1 | |||||||||||||
21615 | 21615 | William Arnold A000300 | rep | IL | 1923-12-03 | 1925-03-03 | Democrat | 23 | |||||||||||||
20103 | 20103 | James Aswell A000321 | rep | LA | 1923-12-03 | 1925-03-03 | Democrat | 8 | |||||||||||||
21099 | 21099 | William Ayres A000354 | rep | KS | 1923-12-03 | 1925-03-03 | Democrat | 8 | |||||||||||||
21633 | 21633 | Isaac Bacharach B000009 | rep | NJ | 1923-12-03 | 1925-03-03 | Republican | 2 | |||||||||||||
22027 | 22027 | Robert Bacon B000019 | rep | NY | 1923-12-03 | 1925-03-03 | Republican | 1 | |||||||||||||
17545 | 17545 | Lewis Ball B000100 | sen | DE | 1919-05-19 | 1925-03-03 | 2 | Republican | |||||||||||||
22491 | 22491 | William Bankhead B000113 | rep | AL | 1923-12-03 | 1925-03-03 | Democrat | 10 | |||||||||||||
20115 | 20115 | Henry Barbour B000126 | rep | CA | 1923-12-03 | 1925-03-03 | Republican | 7 | |||||||||||||
25872 | 25872 | Alben Barkley B000145 | rep | KY | 1923-12-03 | 1925-03-03 | Democrat | 1 | |||||||||||||
19199 | 19199 | Joseph Beck B000291 | rep | WI | 1923-12-03 | 1925-03-03 | Republican | 7 | |||||||||||||
21113 | 21113 | Carroll Beedy B000307 | rep | ME | 1923-12-03 | 1925-03-03 | Republican | 1 | |||||||||||||
20121 | 20121 | Edward Beers B000312 | rep | PA | 1923-12-03 | 1925-03-03 | Republican | 18 | |||||||||||||
19204 | 19204 | James Begg B000314 | rep | OH | 1923-12-03 | 1925-03-03 | Republican | 13 | |||||||||||||
19583 | 19583 | Thomas Bell B000348 | rep | GA | 1923-12-03 | 1925-03-03 | Democrat | 9 | |||||||||||||
19209 | 19209 | Victor Berger B000407 | rep | WI | 1923-12-03 | 1925-03-03 | Socialist | 5 | |||||||||||||
18912 | 18912 | Harris Bixler B000493 | rep | PA | 1923-12-03 | 1925-03-03 | Republican | 28 | |||||||||||||
19218 | 19218 | Eugene Black B000495 | rep | TX | 1923-12-03 | 1925-03-03 | Democrat | 1 | |||||||||||||
21121 | 21121 | Loring Black B000505 | rep | NY | 1923-12-03 | 1925-03-03 | Democrat | 5 | |||||||||||||
24745 | 24745 | Schuyler Bland B000545 | rep | VA | 1923-12-03 | 1925-03-03 | Democrat | 1 | |||||||||||||
21646 | 21646 | Thomas Blanton B000549 | rep | TX | 1923-12-03 | 1925-03-03 | Democrat | 17 | |||||||||||||
24759 | 24759 | Sol Bloom B000565 | rep | NY | 1923-12-03 | 1925-03-03 | Democrat | 19 | |||||||||||||
19224 | 19224 | William Boies B000597 | rep | IA | 1923-12-03 | 1925-03-03 | Republican | 11 | |||||||||||||
22049 | 22049 | William Borah B000634 | sen | ID | 1919-05-19 | 1925-03-03 | 2 | Republican | |||||||||||||
19231 | 19231 | William Bowling B000702 | rep | AL | 1923-12-03 | 1925-03-03 | Democrat | 5 | |||||||||||||
19590 | 19590 | John Box B000710 | rep | TX | 1923-12-03 | 1925-03-03 | Democrat | 2 | |||||||||||||
18571 | 18571 | William Boyce B000712 | rep | DE | 1923-12-03 | 1925-03-03 | Democrat | 0 | |||||||||||||
22054 | 22054 | John Boylan B000726 | rep | NY | 1923-12-03 | 1925-03-03 | Democrat | 15 | |||||||||||||
20130 | 20130 | Charles Brand B000766 | rep | OH | 1923-12-03 | 1925-03-03 | Republican | 7 | |||||||||||||
21136 | 21136 | Charles Brand B000767 | rep | GA | 1923-12-03 | 1925-03-03 | Democrat | 8 | |||||||||||||
21144 | 21144 | Clay Briggs B000826 | rep | TX | 1923-12-03 | 1925-03-03 | Democrat | 7 | |||||||||||||
21155 | 21155 | Frederick Britten B000847 | rep | IL | 1923-12-03 | 1925-03-03 | Republican | 9 | |||||||||||||
19234 | 19234 | Smith Brookhart B000873 | sen | IA | 1922-01-01 | 1925-03-03 | 2 | Republican | |||||||||||||
18572 | 18572 | Charles Browne B000954 | rep | NJ | 1923-12-03 | 1925-03-03 | Democrat | 4 | |||||||||||||
19603 | 19603 | Edward Browne B000955 | rep | WI | 1923-12-03 | 1925-03-03 | Republican | 8 | |||||||||||||
21163 | 21163 | Gordon Browning B000959 | rep | TN | 1923-12-03 | 1925-03-03 | Democrat | 8 | |||||||||||||
21169 | 21169 | George Brumm B000978 | rep | PA | 1923-12-03 | 1925-03-03 | Republican | 13 | |||||||||||||
22067 | 22067 | James Buchanan B001006 | rep | TX | 1923-12-03 | 1925-03-03 | Democrat | 10 | |||||||||||||
18574 | 18574 | James Buckley B001027 | rep | IL | 1923-12-03 | 1925-03-03 | Democrat | 6 | |||||||||||||
24776 | 24776 | Alfred Bulwinkle B001056 | rep | NC | 1923-12-03 | 1925-03-03 | Democrat | 9 | |||||||||||||
20139 | 20139 | Clark Burdick B001075 | rep | RI | 1923-12-03 | 1925-03-03 | Republican | 1 | |||||||||||||
18079 | 18079 | Holm Bursum B001144 | sen | NM | 1921-04-11 | 1925-03-03 | 2 | Republican | appointment | ||||||||||||
20145 | 20145 | Olger Burtness B001146 | rep | ND | 1923-12-03 | 1925-03-03 | Republican | 1 | |||||||||||||
19565 | 19565 | Theodore Burton B001159 | rep | OH | 1923-12-03 | 1925-03-03 | Republican | 22 | |||||||||||||
21179 | 21179 | Thomas Busby B001163 | rep | MS | 1923-12-03 | 1925-03-03 | Democrat | 4 | |||||||||||||
19253 | 19253 | Thomas Butler B001192 | rep | PA | 1923-12-03 | 1925-03-03 | Republican | 8 | |||||||||||||
22083 | 22083 | James Byrnes B001215 | rep | SC | 1923-12-03 | 1925-03-03 | Democrat | 2 | |||||||||||||
21677 | 21677 | Joseph Byrns B001217 | rep | TN | 1923-12-03 | 1925-03-03 | Democrat | 6 | |||||||||||||
20154 | 20154 | John Cable C000007 | rep | OH | 1923-12-03 | 1925-03-03 | Republican | 4 | |||||||||||||
20162 | 20162 | Guy Campbell C000084 | rep | PA | 1923-12-03 | 1925-03-03 | Republican | 36 | |||||||||||||
20167 | 20167 | Harry Canfield C000114 | rep | IN | 1923-12-03 | 1925-03-03 | Democrat | 4 | |||||||||||||
27679 | 27679 | Clarence Cannon C000117 | rep | MO | 1923-12-03 | 1925-03-03 | Democrat | 9 | |||||||||||||
18582 | 18582 | James Cantrill C000126 | rep | KY | 1923-12-03 | 1925-03-03 | Democrat | 7 | |||||||||||||
23356 | 23356 | Arthur Capper C000133 | sen | KS | 1919-05-19 | 1925-03-03 | 2 | Republican | |||||||||||||
19612 | 19612 | John Carew C000142 | rep | NY | 1923-12-03 | 1925-03-03 | Democrat | 18 | |||||||||||||
18924 | 18924 | Charles Carter C000196 | rep | OK | 1923-12-03 | 1925-03-03 | Democrat | 3 | |||||||||||||
19619 | 19619 | John Casey C000223 | rep | PA | 1923-12-03 | 1925-03-03 | Democrat | 12 | |||||||||||||
29671 | 29671 | Emanuel Celler C000264 | rep | NY | 1923-12-03 | 1925-03-03 | Democrat | 10 | |||||||||||||
20177 | 20177 | Carl Chindblom C000361 | rep | IL | 1923-12-03 | 1925-03-03 | Republican | 10 | |||||||||||||
20189 | 20189 | Charles Christopherson C000384 | rep | SD | 1923-12-03 | 1925-03-03 | Republican | 1 | |||||||||||||
20195 | 20195 | Frank Clague C000401 | rep | MN | 1923-12-03 | 1925-03-03 | Republican | 2 | |||||||||||||
20200 | 20200 | Robert Clancy C000412 | rep | MI | 1923-12-03 | 1925-03-03 | Democrat | 1 | |||||||||||||
18592 | 18592 | Frank Clark C000430 | rep | FL | 1923-12-03 | 1925-03-03 | Democrat | 2 | |||||||||||||
21200 | 21200 | John Clarke C000465 | rep | NY | 1923-12-03 | 1925-03-03 | Republican | 34 | |||||||||||||
18929 | 18929 | William Cleary C000500 | rep | NY | 1923-12-03 | 1925-03-03 | Democrat | 8 | |||||||||||||
18600 | 18600 | William Cockran C000575 | rep | NY | 1923-12-03 | 1925-03-03 | Democrat | -1 | |||||||||||||
20205 | 20205 | Cyrenus Cole C000608 | rep | IA | 1923-12-03 | 1925-03-03 | Republican | 5 | |||||||||||||
18603 | 18603 | Raymond Cole C000613 | rep | OH | 1923-12-03 | 1925-03-03 | Republican | 8 | |||||||||||||
20217 | 20217 | James Collier C000630 | rep | MS | 1923-12-03 | 1925-03-03 | Democrat | 8 | |||||||||||||
22932 | 22932 | Ross Collins C000642 | rep | MS | 1923-12-03 | 1925-03-03 | Democrat | 5 | |||||||||||||
20223 | 20223 | Don Colton C000652 | rep | UT | 1923-12-03 | 1925-03-03 | Republican | 1 | |||||||||||||
24316 | 24316 | Thomas Connally C000684 | rep | TX | 1923-12-03 | 1925-03-03 | Democrat | 11 | |||||||||||||
22095 | 22095 | William Connery C000694 | rep | MA | 1923-12-03 | 1925-03-03 | Democrat | 7 | |||||||||||||
21212 | 21212 | James Connolly C000698 | rep | PA | 1923-12-03 | 1925-03-03 | Republican | 5 | |||||||||||||
18604 | 18604 | Samuel Cook C000727 | rep | IN | 1923-12-03 | 1925-03-03 | Democrat | 11 | |||||||||||||
20245 | 20245 | Henry Cooper C000752 | rep | WI | 1923-12-03 | 1925-03-03 | Republican | 1 | |||||||||||||
21714 | 21714 | John Cooper C000757 | rep | OH | 1923-12-03 | 1925-03-03 | Republican | 19 | |||||||||||||
21724 | 21724 | Parker Corning C000785 | rep | NY | 1923-12-03 | 1925-03-03 | Democrat | 28 | |||||||||||||
20251 | 20251 | James Couzens C000812 | sen | MI | 1922-11-29 | 1925-03-03 | 2 | Republican | appointment | ||||||||||||
19633 | 19633 | Louis Cramton C000870 | rep | MI | 1923-12-03 | 1925-03-03 | Republican | 7 | |||||||||||||
20266 | 20266 | Charles Crisp C000909 | rep | GA | 1923-12-03 | 1925-03-03 | Democrat | 3 | |||||||||||||
18605 | 18605 | William Croll C000923 | rep | PA | 1923-12-03 | 1925-03-03 | Democrat | 14 | |||||||||||||
25642 | 25642 | Robert Crosser C000932 | rep | OH | 1923-12-03 | 1925-03-03 | Democrat | 21 | |||||||||||||
22947 | 22947 | Frank Crowther C000948 | rep | NY | 1923-12-03 | 1925-03-03 | Republican | 30 | |||||||||||||
23396 | 23396 | Thomas Cullen C000970 | rep | NY | 1923-12-03 | 1925-03-03 | Democrat | 4 | |||||||||||||
18606 | 18606 | Herbert Cummings C000987 | rep | PA | 1923-12-03 | 1925-03-03 | Democrat | 17 | |||||||||||||
19642 | 19642 | Charles Curry C001000 | rep | CA | 1923-12-03 | 1925-03-03 | Republican | 3 | |||||||||||||
20276 | 20276 | Frederick Dallinger D000012 | rep | MA | 1923-12-03 | 1925-03-03 | Republican | 8 | |||||||||||||
22553 | 22553 | George Darrow D000063 | rep | PA | 1923-12-03 | 1925-03-03 | Republican | 7 | |||||||||||||
19288 | 19288 | Martin Davey D000080 | rep | OH | 1923-12-03 | 1925-03-03 | Democrat | 14 | |||||||||||||
20333 | 20333 | Félix Dávila D000090 | rep | PR | 1923-12-03 | 1925-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);