legislator_terms
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
499 rows where "start" is on date 1929-04-15 sorted by legislator_id
This data as json, copyable, CSV (advanced)
Suggested facets: 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
21070 | 21070 | Charles Abernethy A000015 | rep | NC | 1929-04-15 | 1931-03-03 | Democrat | 3 | |||||||||||||
20078 | 20078 | Ernest Ackerman A000021 | rep | NJ | 1929-04-15 | 1931-03-03 | Republican | 5 | |||||||||||||
20082 | 20082 | Charles Adkins A000057 | rep | IL | 1929-04-15 | 1931-03-03 | Republican | 19 | |||||||||||||
20087 | 20087 | Richard Aldrich A000084 | rep | RI | 1929-04-15 | 1931-03-03 | Republican | 2 | |||||||||||||
19571 | 19571 | Henry Allen A000126 | sen | KS | 1929-04-15 | 1931-03-03 | 3 | Republican | appointment | ||||||||||||
20091 | 20091 | John Allen A000131 | rep | IL | 1929-04-15 | 1931-03-03 | Republican | 14 | |||||||||||||
21077 | 21077 | Miles Allgood A000156 | rep | AL | 1929-04-15 | 1931-03-03 | Democrat | 7 | |||||||||||||
21087 | 21087 | Edward Almon A000162 | rep | AL | 1929-04-15 | 1931-03-03 | Democrat | 8 | |||||||||||||
26164 | 26164 | August Andresen A000239 | rep | MN | 1929-04-15 | 1931-03-03 | Republican | 3 | |||||||||||||
21611 | 21611 | Abram Andrew A000240 | rep | MA | 1929-04-15 | 1931-03-03 | Republican | 6 | |||||||||||||
20096 | 20096 | Samuel Arentz A000277 | rep | NV | 1929-04-15 | 1931-03-03 | Republican | 0 | |||||||||||||
21618 | 21618 | William Arnold A000300 | rep | IL | 1929-04-15 | 1931-03-03 | Democrat | 23 | |||||||||||||
21625 | 21625 | Henry Ashurst A000319 | sen | AZ | 1929-04-15 | 1935-01-03 | 1 | Democrat | |||||||||||||
20106 | 20106 | James Aswell A000321 | rep | LA | 1929-04-15 | 1931-03-03 | Democrat | 8 | |||||||||||||
21093 | 21093 | Oscar Auf Der Heide A000338 | rep | NJ | 1929-04-15 | 1931-03-03 | Democrat | 11 | |||||||||||||
21102 | 21102 | William Ayres A000354 | rep | KS | 1929-04-15 | 1931-03-03 | Democrat | 8 | |||||||||||||
21636 | 21636 | Isaac Bacharach B000009 | rep | NJ | 1929-04-15 | 1931-03-03 | Republican | 2 | |||||||||||||
20110 | 20110 | Carl Bachmann B000012 | rep | WV | 1929-04-15 | 1931-03-03 | Republican | 1 | |||||||||||||
22030 | 22030 | Robert Bacon B000019 | rep | NY | 1929-04-15 | 1931-03-03 | Republican | 1 | |||||||||||||
19573 | 19573 | Joseph Baird B000054 | rep | OH | 1929-04-15 | 1931-03-03 | Republican | 13 | |||||||||||||
22494 | 22494 | William Bankhead B000113 | rep | AL | 1929-04-15 | 1931-03-03 | Democrat | 10 | |||||||||||||
20118 | 20118 | Henry Barbour B000126 | rep | CA | 1929-04-15 | 1931-03-03 | Republican | 7 | |||||||||||||
21109 | 21109 | James Beck B000290 | rep | PA | 1929-04-15 | 1931-03-03 | Republican | 1 | |||||||||||||
21116 | 21116 | Carroll Beedy B000307 | rep | ME | 1929-04-15 | 1931-03-03 | Republican | 1 | |||||||||||||
20124 | 20124 | Edward Beers B000312 | rep | PA | 1929-04-15 | 1931-03-03 | Republican | 18 | |||||||||||||
19586 | 19586 | Thomas Bell B000348 | rep | GA | 1929-04-15 | 1931-03-03 | Democrat | 9 | |||||||||||||
21124 | 21124 | Loring Black B000505 | rep | NY | 1929-04-15 | 1931-03-03 | Democrat | 5 | |||||||||||||
19587 | 19587 | Robert Blackburn B000509 | rep | KY | 1929-04-15 | 1931-03-03 | Republican | 7 | |||||||||||||
24748 | 24748 | Schuyler Bland B000545 | rep | VA | 1929-04-15 | 1931-03-03 | Democrat | 1 | |||||||||||||
21649 | 21649 | Thomas Blanton B000549 | rep | TX | 1929-04-15 | 1931-03-03 | Democrat | 17 | |||||||||||||
24762 | 24762 | Sol Bloom B000565 | rep | NY | 1929-04-15 | 1931-03-03 | Democrat | 19 | |||||||||||||
20128 | 20128 | Frank Bohn B000596 | rep | MI | 1929-04-15 | 1931-03-03 | Republican | 11 | |||||||||||||
22502 | 22502 | Chester Bolton B000606 | rep | OH | 1929-04-15 | 1931-03-03 | Republican | 22 | |||||||||||||
21130 | 21130 | Frank Bowman B000704 | rep | WV | 1929-04-15 | 1931-03-03 | Republican | 2 | |||||||||||||
19593 | 19593 | John Box B000710 | rep | TX | 1929-04-15 | 1931-03-03 | Democrat | 2 | |||||||||||||
22057 | 22057 | John Boylan B000726 | rep | NY | 1929-04-15 | 1931-03-03 | Democrat | 15 | |||||||||||||
20133 | 20133 | Charles Brand B000766 | rep | OH | 1929-04-15 | 1931-03-03 | Republican | 7 | |||||||||||||
21139 | 21139 | Charles Brand B000767 | rep | GA | 1929-04-15 | 1931-03-03 | Democrat | 8 | |||||||||||||
21147 | 21147 | Clay Briggs B000826 | rep | TX | 1929-04-15 | 1931-03-03 | Democrat | 7 | |||||||||||||
19596 | 19596 | Elbert Brigham B000832 | rep | VT | 1929-04-15 | 1931-03-03 | Republican | 1 | |||||||||||||
21158 | 21158 | Frederick Britten B000847 | rep | IL | 1929-04-15 | 1931-03-03 | Republican | 9 | |||||||||||||
19606 | 19606 | Edward Browne B000955 | rep | WI | 1929-04-15 | 1931-03-03 | Republican | 8 | |||||||||||||
21166 | 21166 | Gordon Browning B000959 | rep | TN | 1929-04-15 | 1931-03-03 | Democrat | 8 | |||||||||||||
21171 | 21171 | George Brumm B000978 | rep | PA | 1929-04-15 | 1931-03-03 | Republican | 13 | |||||||||||||
21657 | 21657 | William Brunner B000981 | rep | NY | 1929-04-15 | 1931-03-03 | Democrat | 2 | |||||||||||||
22070 | 22070 | James Buchanan B001006 | rep | TX | 1929-04-15 | 1931-03-03 | Democrat | 10 | |||||||||||||
21662 | 21662 | John Buckbee B001020 | rep | IL | 1929-04-15 | 1931-03-03 | Republican | 12 | |||||||||||||
20142 | 20142 | Clark Burdick B001075 | rep | RI | 1929-04-15 | 1931-03-03 | Republican | 1 | |||||||||||||
20148 | 20148 | Olger Burtness B001146 | rep | ND | 1929-04-15 | 1931-03-03 | Republican | 1 | |||||||||||||
21182 | 21182 | Thomas Busby B001163 | rep | MS | 1929-04-15 | 1931-03-03 | Democrat | 4 | |||||||||||||
20151 | 20151 | Robert Butler B001187 | rep | OR | 1929-04-15 | 1931-03-03 | Republican | 2 | |||||||||||||
21680 | 21680 | Joseph Byrns B001217 | rep | TN | 1929-04-15 | 1931-03-03 | Democrat | 6 | |||||||||||||
20155 | 20155 | John Cable C000007 | rep | OH | 1929-04-15 | 1931-03-03 | Republican | 4 | |||||||||||||
20157 | 20157 | Ed Campbell C000081 | rep | IA | 1929-04-15 | 1931-03-03 | Republican | 11 | |||||||||||||
20165 | 20165 | Guy Campbell C000084 | rep | PA | 1929-04-15 | 1931-03-03 | Republican | 36 | |||||||||||||
20170 | 20170 | Harry Canfield C000114 | rep | IN | 1929-04-15 | 1931-03-03 | Democrat | 4 | |||||||||||||
27682 | 27682 | Clarence Cannon C000117 | rep | MO | 1929-04-15 | 1931-03-03 | Democrat | 9 | |||||||||||||
19615 | 19615 | John Carew C000142 | rep | NY | 1929-04-15 | 1931-03-03 | Democrat | 18 | |||||||||||||
21187 | 21187 | Patrick Carley C000149 | rep | NY | 1929-04-15 | 1931-03-03 | Democrat | 8 | |||||||||||||
23364 | 23364 | Albert Carter C000195 | rep | CA | 1929-04-15 | 1931-03-03 | Republican | 6 | |||||||||||||
21191 | 21191 | Vincent Carter C000203 | rep | WY | 1929-04-15 | 1931-03-03 | Republican | 0 | |||||||||||||
22903 | 22903 | Wilburn Cartwright C000207 | rep | OK | 1929-04-15 | 1931-03-03 | Democrat | 3 | |||||||||||||
19621 | 19621 | John Casey C000223 | rep | PA | 1929-04-15 | 1931-03-03 | Democrat | 12 | |||||||||||||
29674 | 29674 | Emanuel Celler C000264 | rep | NY | 1929-04-15 | 1931-03-03 | Democrat | 10 | |||||||||||||
19625 | 19625 | William Chalmers C000274 | rep | OH | 1929-04-15 | 1931-03-03 | Republican | 9 | |||||||||||||
20173 | 20173 | James Chase C000328 | rep | PA | 1929-04-15 | 1931-03-03 | Republican | 23 | |||||||||||||
20180 | 20180 | Carl Chindblom C000361 | rep | IL | 1929-04-15 | 1931-03-03 | Republican | 10 | |||||||||||||
20183 | 20183 | Burnett Chiperfield C000364 | rep | IL | 1929-04-15 | 1931-03-03 | Republican | 15 | |||||||||||||
20185 | 20185 | Victor Christgau C000378 | rep | MN | 1929-04-15 | 1931-03-03 | Republican | 1 | |||||||||||||
20192 | 20192 | Charles Christopherson C000384 | rep | SD | 1929-04-15 | 1931-03-03 | Republican | 1 | |||||||||||||
20198 | 20198 | Frank Clague C000401 | rep | MN | 1929-04-15 | 1931-03-03 | Republican | 2 | |||||||||||||
20202 | 20202 | Robert Clancy C000412 | rep | MI | 1929-04-15 | 1931-03-03 | Republican | 1 | |||||||||||||
24294 | 24294 | Jerome Clark C000439 | rep | NC | 1929-04-15 | 1931-03-03 | Democrat | 6 | |||||||||||||
19626 | 19626 | Linwood Clark C000446 | rep | MD | 1929-04-15 | 1931-03-03 | Republican | 2 | |||||||||||||
21202 | 21202 | John Clarke C000465 | rep | NY | 1929-04-15 | 1931-03-03 | Republican | 34 | |||||||||||||
23805 | 23805 | John Cochran C000565 | rep | MO | 1929-04-15 | 1931-03-03 | Democrat | 11 | |||||||||||||
21207 | 21207 | Thomas Cochran C000566 | rep | PA | 1929-04-15 | 1931-03-03 | Republican | 28 | |||||||||||||
20208 | 20208 | Cyrenus Cole C000608 | rep | IA | 1929-04-15 | 1931-03-03 | Republican | 5 | |||||||||||||
20220 | 20220 | James Collier C000630 | rep | MS | 1929-04-15 | 1931-03-03 | Democrat | 8 | |||||||||||||
22935 | 22935 | Ross Collins C000642 | rep | MS | 1929-04-15 | 1931-03-03 | Democrat | 5 | |||||||||||||
20226 | 20226 | Don Colton C000652 | rep | UT | 1929-04-15 | 1931-03-03 | Republican | 1 | |||||||||||||
21706 | 21706 | Francis Condon C000673 | rep | RI | 1929-04-15 | 1931-03-03 | Democrat | 3 | |||||||||||||
24319 | 24319 | Thomas Connally C000684 | sen | TX | 1929-04-15 | 1935-01-03 | 1 | Democrat | |||||||||||||
22098 | 22098 | William Connery C000694 | rep | MA | 1929-04-15 | 1931-03-03 | Democrat | 7 | |||||||||||||
21215 | 21215 | James Connolly C000698 | rep | PA | 1929-04-15 | 1931-03-03 | Republican | 5 | |||||||||||||
20228 | 20228 | Edmund Cooke C000730 | rep | NY | 1929-04-15 | 1931-03-03 | Republican | 41 | |||||||||||||
20248 | 20248 | Henry Cooper C000752 | rep | WI | 1929-04-15 | 1931-03-03 | Republican | 1 | |||||||||||||
26250 | 26250 | Jere Cooper C000755 | rep | TN | 1929-04-15 | 1931-03-03 | Democrat | 9 | |||||||||||||
21717 | 21717 | John Cooper C000757 | rep | OH | 1929-04-15 | 1931-03-03 | Republican | 19 | |||||||||||||
21722 | 21722 | Royal Copeland C000769 | sen | NY | 1929-04-15 | 1935-01-03 | 1 | Democrat | |||||||||||||
21727 | 21727 | Parker Corning C000785 | rep | NY | 1929-04-15 | 1931-03-03 | Democrat | 28 | |||||||||||||
25191 | 25191 | Edward Cox C000831 | rep | GA | 1929-04-15 | 1931-03-03 | Democrat | 2 | |||||||||||||
20255 | 20255 | William Coyle C000844 | rep | PA | 1929-04-15 | 1931-03-03 | Republican | 30 | |||||||||||||
19627 | 19627 | John Craddock C000849 | rep | KY | 1929-04-15 | 1931-03-03 | Republican | 4 | |||||||||||||
20258 | 20258 | Joe Crail C000864 | rep | CA | 1929-04-15 | 1931-03-03 | Republican | 10 | |||||||||||||
19636 | 19636 | Louis Cramton C000870 | rep | MI | 1929-04-15 | 1931-03-03 | Republican | 7 | |||||||||||||
20269 | 20269 | Charles Crisp C000909 | rep | GA | 1929-04-15 | 1931-03-03 | Democrat | 3 | |||||||||||||
21731 | 21731 | Oliver Cross C000931 | rep | TX | 1929-04-15 | 1931-03-03 | Democrat | 11 | |||||||||||||
25645 | 25645 | Robert Crosser C000932 | rep | OH | 1929-04-15 | 1931-03-03 | Democrat | 21 | |||||||||||||
22950 | 22950 | Frank Crowther C000948 | rep | NY | 1929-04-15 | 1931-03-03 | Republican | 30 |
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);