legislator_terms
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
484 rows where "end" is on date 1927-03-04 sorted by legislator_id
This data as json, copyable, CSV (advanced)
Suggested facets: party, 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
21068 | 21068 | Charles Abernethy A000015 | rep | NC | 1925-12-07 | 1927-03-04 | Democrat | 3 | |||||||||||||
20076 | 20076 | Ernest Ackerman A000021 | rep | NJ | 1925-12-07 | 1927-03-04 | Republican | 5 | |||||||||||||
20080 | 20080 | Charles Adkins A000057 | rep | IL | 1925-12-07 | 1927-03-04 | Republican | 19 | |||||||||||||
20085 | 20085 | Richard Aldrich A000084 | rep | RI | 1925-12-07 | 1927-03-04 | Republican | 2 | |||||||||||||
20089 | 20089 | John Allen A000131 | rep | IL | 1925-12-07 | 1927-03-04 | Republican | 14 | |||||||||||||
21075 | 21075 | Miles Allgood A000156 | rep | AL | 1925-12-07 | 1927-03-04 | Democrat | 7 | |||||||||||||
21085 | 21085 | Edward Almon A000162 | rep | AL | 1925-12-07 | 1927-03-04 | Democrat | 8 | |||||||||||||
26162 | 26162 | August Andresen A000239 | rep | MN | 1925-12-07 | 1927-03-04 | Republican | 3 | |||||||||||||
21609 | 21609 | Abram Andrew A000240 | rep | MA | 1925-12-07 | 1927-03-04 | Republican | 6 | |||||||||||||
19196 | 19196 | Daniel Anthony A000261 | rep | KS | 1925-12-07 | 1927-03-04 | Republican | 1 | |||||||||||||
18909 | 18909 | Stewart Appleby A000266 | rep | NJ | 1925-12-07 | 1927-03-04 | Republican | 3 | |||||||||||||
20094 | 20094 | Samuel Arentz A000277 | rep | NV | 1925-12-07 | 1927-03-04 | Republican | 0 | |||||||||||||
21616 | 21616 | William Arnold A000300 | rep | IL | 1925-12-07 | 1927-03-04 | Democrat | 23 | |||||||||||||
20104 | 20104 | James Aswell A000321 | rep | LA | 1925-12-07 | 1927-03-04 | Democrat | 8 | |||||||||||||
21091 | 21091 | Oscar Auf Der Heide A000338 | rep | NJ | 1925-12-07 | 1927-03-04 | Democrat | 11 | |||||||||||||
21100 | 21100 | William Ayres A000354 | rep | KS | 1925-12-07 | 1927-03-04 | Democrat | 8 | |||||||||||||
21634 | 21634 | Isaac Bacharach B000009 | rep | NJ | 1925-12-07 | 1927-03-04 | Republican | 2 | |||||||||||||
20108 | 20108 | Carl Bachmann B000012 | rep | WV | 1925-12-07 | 1927-03-04 | Republican | 1 | |||||||||||||
22028 | 22028 | Robert Bacon B000019 | rep | NY | 1925-12-07 | 1927-03-04 | Republican | 1 | |||||||||||||
18910 | 18910 | Ralph Bailey B000048 | rep | MO | 1925-12-07 | 1927-03-04 | Republican | 14 | |||||||||||||
22492 | 22492 | William Bankhead B000113 | rep | AL | 1925-12-07 | 1927-03-04 | Democrat | 10 | |||||||||||||
20116 | 20116 | Henry Barbour B000126 | rep | CA | 1925-12-07 | 1927-03-04 | Republican | 7 | |||||||||||||
25873 | 25873 | Alben Barkley B000145 | rep | KY | 1925-12-07 | 1927-03-04 | Democrat | 1 | |||||||||||||
19200 | 19200 | Joseph Beck B000291 | rep | WI | 1925-12-07 | 1927-03-04 | Republican | 7 | |||||||||||||
21114 | 21114 | Carroll Beedy B000307 | rep | ME | 1925-12-07 | 1927-03-04 | Republican | 1 | |||||||||||||
20122 | 20122 | Edward Beers B000312 | rep | PA | 1925-12-07 | 1927-03-04 | Republican | 18 | |||||||||||||
19205 | 19205 | James Begg B000314 | rep | OH | 1925-12-07 | 1927-03-04 | Republican | 13 | |||||||||||||
19584 | 19584 | Thomas Bell B000348 | rep | GA | 1925-12-07 | 1927-03-04 | Democrat | 9 | |||||||||||||
19210 | 19210 | Victor Berger B000407 | rep | WI | 1925-12-07 | 1927-03-04 | Socialist | 5 | |||||||||||||
19212 | 19212 | Hiram Bingham B000470 | sen | CT | 1924-01-01 | 1927-03-04 | 3 | Republican | |||||||||||||
18913 | 18913 | Harris Bixler B000493 | rep | PA | 1925-12-07 | 1927-03-04 | Republican | 28 | |||||||||||||
19219 | 19219 | Eugene Black B000495 | rep | TX | 1925-12-07 | 1927-03-04 | Democrat | 1 | |||||||||||||
21122 | 21122 | Loring Black B000505 | rep | NY | 1925-12-07 | 1927-03-04 | Democrat | 5 | |||||||||||||
24746 | 24746 | Schuyler Bland B000545 | rep | VA | 1925-12-07 | 1927-03-04 | Democrat | 1 | |||||||||||||
21647 | 21647 | Thomas Blanton B000549 | rep | TX | 1925-12-07 | 1927-03-04 | Democrat | 17 | |||||||||||||
24760 | 24760 | Sol Bloom B000565 | rep | NY | 1925-12-07 | 1927-03-04 | Democrat | 19 | |||||||||||||
19225 | 19225 | William Boies B000597 | rep | IA | 1925-12-07 | 1927-03-04 | Republican | 11 | |||||||||||||
19227 | 19227 | Henry Bowles B000700 | rep | MA | 1925-12-07 | 1927-03-04 | Republican | 2 | |||||||||||||
19232 | 19232 | William Bowling B000702 | rep | AL | 1925-12-07 | 1927-03-04 | Democrat | 5 | |||||||||||||
21128 | 21128 | Frank Bowman B000704 | rep | WV | 1925-12-07 | 1927-03-04 | Republican | 2 | |||||||||||||
19591 | 19591 | John Box B000710 | rep | TX | 1925-12-07 | 1927-03-04 | Democrat | 2 | |||||||||||||
22055 | 22055 | John Boylan B000726 | rep | NY | 1925-12-07 | 1927-03-04 | Democrat | 15 | |||||||||||||
20131 | 20131 | Charles Brand B000766 | rep | OH | 1925-12-07 | 1927-03-04 | Republican | 7 | |||||||||||||
21137 | 21137 | Charles Brand B000767 | rep | GA | 1925-12-07 | 1927-03-04 | Democrat | 8 | |||||||||||||
21145 | 21145 | Clay Briggs B000826 | rep | TX | 1925-12-07 | 1927-03-04 | Democrat | 7 | |||||||||||||
19594 | 19594 | Elbert Brigham B000832 | rep | VT | 1925-12-07 | 1927-03-04 | Republican | 1 | |||||||||||||
21156 | 21156 | Frederick Britten B000847 | rep | IL | 1925-12-07 | 1927-03-04 | Republican | 9 | |||||||||||||
19235 | 19235 | Smith Brookhart B000873 | sen | IA | 1925-12-07 | 1927-03-04 | 2 | Republican | |||||||||||||
19237 | 19237 | Edwin Broussard B000895 | sen | LA | 1921-04-11 | 1927-03-04 | 3 | Democrat | |||||||||||||
19604 | 19604 | Edward Browne B000955 | rep | WI | 1925-12-07 | 1927-03-04 | Republican | 8 | |||||||||||||
21164 | 21164 | Gordon Browning B000959 | rep | TN | 1925-12-07 | 1927-03-04 | Democrat | 8 | |||||||||||||
21170 | 21170 | George Brumm B000978 | rep | PA | 1925-12-07 | 1927-03-04 | Republican | 13 | |||||||||||||
22068 | 22068 | James Buchanan B001006 | rep | TX | 1925-12-07 | 1927-03-04 | Democrat | 10 | |||||||||||||
24777 | 24777 | Alfred Bulwinkle B001056 | rep | NC | 1925-12-07 | 1927-03-04 | Democrat | 9 | |||||||||||||
20140 | 20140 | Clark Burdick B001075 | rep | RI | 1925-12-07 | 1927-03-04 | Republican | 1 | |||||||||||||
20146 | 20146 | Olger Burtness B001146 | rep | ND | 1925-12-07 | 1927-03-04 | Republican | 1 | |||||||||||||
19566 | 19566 | Theodore Burton B001159 | rep | OH | 1925-12-07 | 1927-03-04 | Republican | 22 | |||||||||||||
21180 | 21180 | Thomas Busby B001163 | rep | MS | 1925-12-07 | 1927-03-04 | Democrat | 4 | |||||||||||||
19254 | 19254 | Thomas Butler B001192 | rep | PA | 1925-12-07 | 1927-03-04 | Republican | 8 | |||||||||||||
18907 | 18907 | William Butler B001196 | sen | MA | 1924-11-13 | 1927-03-04 | 1 | Republican | appointment | ||||||||||||
21678 | 21678 | Joseph Byrns B001217 | rep | TN | 1925-12-07 | 1927-03-04 | Democrat | 6 | |||||||||||||
18082 | 18082 | Ralph Cameron C000066 | sen | AZ | 1921-04-11 | 1927-03-04 | 3 | Republican | |||||||||||||
20163 | 20163 | Guy Campbell C000084 | rep | PA | 1925-12-07 | 1927-03-04 | Republican | 36 | |||||||||||||
20168 | 20168 | Harry Canfield C000114 | rep | IN | 1925-12-07 | 1927-03-04 | Democrat | 4 | |||||||||||||
27680 | 27680 | Clarence Cannon C000117 | rep | MO | 1925-12-07 | 1927-03-04 | Democrat | 9 | |||||||||||||
19260 | 19260 | Thaddeus Caraway C000139 | sen | AR | 1921-04-11 | 1927-03-04 | 3 | Democrat | |||||||||||||
19613 | 19613 | John Carew C000142 | rep | NY | 1925-12-07 | 1927-03-04 | Democrat | 18 | |||||||||||||
18915 | 18915 | Edmund Carpenter C000168 | rep | PA | 1925-12-07 | 1927-03-04 | Republican | 12 | |||||||||||||
19263 | 19263 | William Carss C000194 | rep | MN | 1925-12-07 | 1927-03-04 | Farmer-Labor | 8 | |||||||||||||
23362 | 23362 | Albert Carter C000195 | rep | CA | 1925-12-07 | 1927-03-04 | Republican | 6 | |||||||||||||
18925 | 18925 | Charles Carter C000196 | rep | OK | 1925-12-07 | 1927-03-04 | Democrat | 3 | |||||||||||||
29672 | 29672 | Emanuel Celler C000264 | rep | NY | 1925-12-07 | 1927-03-04 | Democrat | 10 | |||||||||||||
19623 | 19623 | William Chalmers C000274 | rep | OH | 1925-12-07 | 1927-03-04 | Republican | 9 | |||||||||||||
24791 | 24791 | Virgil Chapman C000317 | rep | KY | 1925-12-07 | 1927-03-04 | Democrat | 7 | |||||||||||||
20178 | 20178 | Carl Chindblom C000361 | rep | IL | 1925-12-07 | 1927-03-04 | Republican | 10 | |||||||||||||
20190 | 20190 | Charles Christopherson C000384 | rep | SD | 1925-12-07 | 1927-03-04 | Republican | 1 | |||||||||||||
18926 | 18926 | George Churchill C000391 | rep | MA | 1925-12-07 | 1927-03-04 | Republican | 2 | |||||||||||||
20196 | 20196 | Frank Clague C000401 | rep | MN | 1925-12-07 | 1927-03-04 | Republican | 2 | |||||||||||||
18930 | 18930 | William Cleary C000500 | rep | NY | 1925-12-07 | 1927-03-04 | Democrat | 8 | |||||||||||||
23803 | 23803 | John Cochran C000565 | rep | MO | 1925-12-07 | 1927-03-04 | Democrat | 11 | |||||||||||||
20206 | 20206 | Cyrenus Cole C000608 | rep | IA | 1925-12-07 | 1927-03-04 | Republican | 5 | |||||||||||||
20218 | 20218 | James Collier C000630 | rep | MS | 1925-12-07 | 1927-03-04 | Democrat | 8 | |||||||||||||
22933 | 22933 | Ross Collins C000642 | rep | MS | 1925-12-07 | 1927-03-04 | Democrat | 5 | |||||||||||||
20224 | 20224 | Don Colton C000652 | rep | UT | 1925-12-07 | 1927-03-04 | Republican | 1 | |||||||||||||
24317 | 24317 | Thomas Connally C000684 | rep | TX | 1925-12-07 | 1927-03-04 | Democrat | 11 | |||||||||||||
22096 | 22096 | William Connery C000694 | rep | MA | 1925-12-07 | 1927-03-04 | Democrat | 7 | |||||||||||||
21213 | 21213 | James Connolly C000698 | rep | PA | 1925-12-07 | 1927-03-04 | Republican | 5 | |||||||||||||
20246 | 20246 | Henry Cooper C000752 | rep | WI | 1925-12-07 | 1927-03-04 | Republican | 1 | |||||||||||||
21715 | 21715 | John Cooper C000757 | rep | OH | 1925-12-07 | 1927-03-04 | Republican | 19 | |||||||||||||
21725 | 21725 | Parker Corning C000785 | rep | NY | 1925-12-07 | 1927-03-04 | Democrat | 28 | |||||||||||||
25189 | 25189 | Edward Cox C000831 | rep | GA | 1925-12-07 | 1927-03-04 | Democrat | 2 | |||||||||||||
20254 | 20254 | William Coyle C000844 | rep | PA | 1925-12-07 | 1927-03-04 | Republican | 30 | |||||||||||||
19634 | 19634 | Louis Cramton C000870 | rep | MI | 1925-12-07 | 1927-03-04 | Republican | 7 | |||||||||||||
20267 | 20267 | Charles Crisp C000909 | rep | GA | 1925-12-07 | 1927-03-04 | Democrat | 3 | |||||||||||||
25643 | 25643 | Robert Crosser C000932 | rep | OH | 1925-12-07 | 1927-03-04 | Democrat | 21 | |||||||||||||
22948 | 22948 | Frank Crowther C000948 | rep | NY | 1925-12-07 | 1927-03-04 | Republican | 30 | |||||||||||||
19267 | 19267 | Maurice Crumpacker C000959 | rep | OR | 1925-12-07 | 1927-03-04 | Republican | 3 | |||||||||||||
23397 | 23397 | Thomas Cullen C000970 | rep | NY | 1925-12-07 | 1927-03-04 | Democrat | 4 | |||||||||||||
19643 | 19643 | Charles Curry C001000 | rep | CA | 1925-12-07 | 1927-03-04 | Republican | 3 | |||||||||||||
19278 | 19278 | Charles Curtis C001008 | sen | KS | 1921-04-11 | 1927-03-04 | 3 | Republican |
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);