legislator_terms
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
485 rows where "end" is on date 1955-01-03 sorted by legislator_id
This data as json, copyable, CSV (advanced)
Suggested facets: 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
29514 | 29514 | Watkins Abbitt A000002 | rep | VA | 1953-01-03 | 1955-01-03 | Democrat | 4 | |||||||||||||
25846 | 25846 | Hazel Abel A000010 | sen | NE | 1954-01-01 | 1955-01-03 | 2 | Republican | |||||||||||||
29529 | 29529 | Thomas Abernethy A000016 | rep | MS | 1953-01-03 | 1955-01-03 | Democrat | 1 | |||||||||||||
29104 | 29104 | Edwin Adair A000024 | rep | IN | 1953-01-03 | 1955-01-03 | Republican | 4 | |||||||||||||
27063 | 27063 | Hugh Addonizio A000054 | rep | NJ | 1953-01-03 | 1955-01-03 | Democrat | 11 | |||||||||||||
30806 | 30806 | Carl Albert A000073 | rep | OK | 1953-01-03 | 1955-01-03 | Democrat | 3 | |||||||||||||
27068 | 27068 | Hugh Alexander A000094 | rep | NC | 1953-01-03 | 1955-01-03 | Democrat | 9 | |||||||||||||
26159 | 26159 | John Allen A000133 | rep | CA | 1953-01-03 | 1955-01-03 | Republican | 7 | |||||||||||||
26702 | 26702 | Leo Allen A000138 | rep | IL | 1953-01-03 | 1955-01-03 | Republican | 16 | |||||||||||||
27082 | 27082 | Herman Andersen A000179 | rep | MN | 1953-01-03 | 1955-01-03 | Republican | 7 | |||||||||||||
28760 | 28760 | Clinton Anderson A000186 | sen | NM | 1949-01-03 | 1955-01-03 | 2 | Democrat | |||||||||||||
29549 | 29549 | George Andrews A000206 | rep | AL | 1953-01-03 | 1955-01-03 | Democrat | 3 | |||||||||||||
30147 | 30147 | Leslie Arends A000216 | rep | IL | 1953-01-03 | 1955-01-03 | Republican | 17 | |||||||||||||
28764 | 28764 | Robert Ashmore A000223 | rep | SC | 1953-01-03 | 1955-01-03 | Democrat | 4 | |||||||||||||
29561 | 29561 | Wayne Aspinall A000225 | rep | CO | 1953-01-03 | 1955-01-03 | Democrat | 4 | |||||||||||||
27613 | 27613 | James Auchincloss A000227 | rep | NJ | 1953-01-03 | 1955-01-03 | Republican | 3 | |||||||||||||
29120 | 29120 | William Ayres A000229 | rep | OH | 1953-01-03 | 1955-01-03 | Republican | 14 | |||||||||||||
26175 | 26175 | August Andresen A000239 | rep | MN | 1953-01-03 | 1955-01-03 | Republican | 1 | |||||||||||||
25584 | 25584 | Homer Angell A000257 | rep | OR | 1953-01-03 | 1955-01-03 | Republican | 3 | |||||||||||||
27095 | 27095 | Cleveland Bailey B000035 | rep | WV | 1953-01-03 | 1955-01-03 | Democrat | 3 | |||||||||||||
27625 | 27625 | Howard Baker B000062 | rep | TN | 1953-01-03 | 1955-01-03 | Republican | 2 | |||||||||||||
26717 | 26717 | Graham Barden B000139 | rep | NC | 1953-01-03 | 1955-01-03 | Democrat | 3 | |||||||||||||
30823 | 30823 | William Barrett B000178 | rep | PA | 1953-01-03 | 1955-01-03 | Democrat | 1 | |||||||||||||
28776 | 28776 | Edward Bartlett B000201 | rep | AK | 1953-01-03 | 1955-01-03 | Democrat | 0 | |||||||||||||
29131 | 29131 | William Bates B000239 | rep | MA | 1953-01-03 | 1955-01-03 | Republican | 6 | |||||||||||||
25593 | 25593 | Laurie Battle B000242 | rep | AL | 1953-01-03 | 1955-01-03 | Democrat | 9 | |||||||||||||
26179 | 26179 | John Beamer B000276 | rep | IN | 1953-01-03 | 1955-01-03 | Republican | 5 | |||||||||||||
27635 | 27635 | Frank Becker B000292 | rep | NY | 1953-01-03 | 1955-01-03 | Republican | 3 | |||||||||||||
29585 | 29585 | Page Belcher B000323 | rep | OK | 1953-01-03 | 1955-01-03 | Republican | 1 | |||||||||||||
34235 | 34235 | Charles Bennett B000371 | rep | FL | 1953-01-03 | 1955-01-03 | Democrat | 2 | |||||||||||||
27647 | 27647 | John Bennett B000377 | rep | MI | 1953-01-03 | 1955-01-03 | Republican | 12 | |||||||||||||
26733 | 26733 | Alvin Bentley B000391 | rep | MI | 1953-01-03 | 1955-01-03 | Republican | 8 | |||||||||||||
33817 | 33817 | Lloyd Bentsen B000401 | rep | TX | 1953-01-03 | 1955-01-03 | Democrat | 15 | |||||||||||||
29150 | 29150 | Ellis Berry B000416 | rep | SD | 1953-01-03 | 1955-01-03 | Republican | 2 | |||||||||||||
29596 | 29596 | Jackson Betts B000426 | rep | OH | 1953-01-03 | 1955-01-03 | Republican | 8 | |||||||||||||
25600 | 25600 | Cecil Bishop B000486 | rep | IL | 1953-01-03 | 1955-01-03 | Republican | 25 | |||||||||||||
30168 | 30168 | John Blatnik B000550 | rep | MN | 1953-01-03 | 1955-01-03 | Democrat | 8 | |||||||||||||
29613 | 29613 | Thomas Boggs B000594 | rep | LA | 1953-01-03 | 1955-01-03 | Democrat | 2 | |||||||||||||
33494 | 33494 | Edward Boland B000600 | rep | MA | 1953-01-03 | 1955-01-03 | Democrat | 2 | |||||||||||||
32491 | 32491 | Richard Bolling B000605 | rep | MO | 1953-01-03 | 1955-01-03 | Democrat | 5 | |||||||||||||
28794 | 28794 | Frances Bolton B000607 | rep | OH | 1953-01-03 | 1955-01-03 | Republican | 22 | |||||||||||||
27653 | 27653 | Oliver Bolton B000608 | rep | OH | 1953-01-03 | 1955-01-03 | Republican | 11 | |||||||||||||
25601 | 25601 | Edward Bonin B000618 | rep | PA | 1953-01-03 | 1955-01-03 | Republican | 11 | |||||||||||||
28336 | 28336 | Herbert Bonner B000621 | rep | NC | 1953-01-03 | 1955-01-03 | Democrat | 1 | |||||||||||||
26737 | 26737 | Albert Bosch B000646 | rep | NY | 1953-01-03 | 1955-01-03 | Republican | 5 | |||||||||||||
29624 | 29624 | Frank Bow B000676 | rep | OH | 1953-01-03 | 1955-01-03 | Republican | 16 | |||||||||||||
26182 | 26182 | James Bowler B000698 | rep | IL | 1953-01-03 | 1955-01-03 | Democrat | 7 | |||||||||||||
25854 | 25854 | Eva Bowring B000709 | sen | NE | 1954-04-16 | 1955-01-03 | 2 | Republican | appointment | ||||||||||||
27119 | 27119 | Frank Boykin B000725 | rep | AL | 1953-01-03 | 1955-01-03 | Democrat | 1 | |||||||||||||
25605 | 25605 | Ernest Bramblett B000762 | rep | CA | 1953-01-03 | 1955-01-03 | Republican | 13 | |||||||||||||
30184 | 30184 | William Bray B000778 | rep | IN | 1953-01-03 | 1955-01-03 | Republican | 7 | |||||||||||||
25882 | 25882 | Henry Bridges B000823 | sen | NH | 1949-01-03 | 1955-01-03 | 2 | Republican | |||||||||||||
35135 | 35135 | Jack Brooks B000880 | rep | TX | 1953-01-03 | 1955-01-03 | Democrat | 2 | |||||||||||||
27135 | 27135 | Overton Brooks B000884 | rep | LA | 1953-01-03 | 1955-01-03 | Democrat | 4 | |||||||||||||
28350 | 28350 | Clarence Brown B000909 | rep | OH | 1953-01-03 | 1955-01-03 | Republican | 7 | |||||||||||||
25855 | 25855 | Ernest Brown B000913 | sen | NV | 1954-10-01 | 1955-01-03 | 3 | Republican | appointment | ||||||||||||
26758 | 26758 | Paul Brown B000940 | rep | GA | 1953-01-03 | 1955-01-03 | Democrat | 10 | |||||||||||||
26186 | 26186 | Charles Brownson B000964 | rep | IN | 1953-01-03 | 1955-01-03 | Republican | 11 | |||||||||||||
30202 | 30202 | Joel Broyhill B000967 | rep | VA | 1953-01-03 | 1955-01-03 | Republican | 10 | |||||||||||||
25615 | 25615 | Joseph Bryson B000999 | rep | SC | 1953-01-03 | 1955-01-03 | Democrat | 4 | |||||||||||||
25886 | 25886 | Vera Buchanan B001009 | rep | PA | 1953-01-03 | 1955-01-03 | Democrat | 30 | |||||||||||||
27672 | 27672 | Charles Buckley B001024 | rep | NY | 1953-01-03 | 1955-01-03 | Democrat | 24 | |||||||||||||
26764 | 26764 | Hamer Budge B001035 | rep | ID | 1953-01-03 | 1955-01-03 | Republican | 2 | |||||||||||||
26196 | 26196 | Usher Burdick B001079 | rep | ND | 1953-01-03 | 1955-01-03 | Republican | 0 | |||||||||||||
25616 | 25616 | Thomas Burke B001099 | sen | OH | 1953-10-13 | 1955-01-03 | 3 | Democrat | appointment | ||||||||||||
31456 | 31456 | Omar Burleson B001111 | rep | TX | 1953-01-03 | 1955-01-03 | Democrat | 17 | |||||||||||||
25620 | 25620 | Fred Busbey B001161 | rep | IL | 1953-01-03 | 1955-01-03 | Republican | 3 | |||||||||||||
26771 | 26771 | Alvin Bush B001165 | rep | PA | 1953-01-03 | 1955-01-03 | Republican | 17 | |||||||||||||
37951 | 37951 | Robert Byrd B001210 | rep | WV | 1953-01-03 | 1955-01-03 | Democrat | 6 | |||||||||||||
29640 | 29640 | James Byrne B001212 | rep | PA | 1953-01-03 | 1955-01-03 | Democrat | 3 | |||||||||||||
29654 | 29654 | John Byrnes B001216 | rep | WI | 1953-01-03 | 1955-01-03 | Republican | 8 | |||||||||||||
25631 | 25631 | Albert Camp C000070 | rep | GA | 1953-01-03 | 1955-01-03 | Democrat | 4 | |||||||||||||
25632 | 25632 | Courtney Campbell C000080 | rep | FL | 1953-01-03 | 1955-01-03 | Democrat | 1 | |||||||||||||
26788 | 26788 | Gordon Canfield C000113 | rep | NJ | 1953-01-03 | 1955-01-03 | Republican | 8 | |||||||||||||
27694 | 27694 | Clarence Cannon C000117 | rep | MO | 1953-01-03 | 1955-01-03 | Democrat | 9 | |||||||||||||
25893 | 25893 | Frank Carlyle C000156 | rep | NC | 1953-01-03 | 1955-01-03 | Democrat | 7 | |||||||||||||
26795 | 26795 | Albert Carnahan C000162 | rep | MO | 1953-01-03 | 1955-01-03 | Democrat | 8 | |||||||||||||
26208 | 26208 | Joseph Carrigg C000182 | rep | PA | 1953-01-03 | 1955-01-03 | Republican | 10 | |||||||||||||
30227 | 30227 | Clifford Case C000220 | rep | NJ | 1953-01-03 | 1955-01-03 | Republican | 6 | |||||||||||||
31486 | 31486 | Elford Cederberg C000263 | rep | MI | 1953-01-03 | 1955-01-03 | Republican | 10 | |||||||||||||
29686 | 29686 | Emanuel Celler C000264 | rep | NY | 1953-01-03 | 1955-01-03 | Democrat | 11 | |||||||||||||
25898 | 25898 | Richard Chatham C000336 | rep | NC | 1953-01-03 | 1955-01-03 | Democrat | 5 | |||||||||||||
28365 | 28365 | Frank Chelf C000342 | rep | KY | 1953-01-03 | 1955-01-03 | Democrat | 4 | |||||||||||||
27715 | 27715 | John Chenoweth C000346 | rep | CO | 1953-01-03 | 1955-01-03 | Republican | 3 | |||||||||||||
27149 | 27149 | Robert Chiperfield C000365 | rep | IL | 1953-01-03 | 1955-01-03 | Republican | 19 | |||||||||||||
26225 | 26225 | Earl Chudoff C000386 | rep | PA | 1953-01-03 | 1955-01-03 | Democrat | 4 | |||||||||||||
27155 | 27155 | Marguerite Church C000389 | rep | IL | 1953-01-03 | 1955-01-03 | Republican | 13 | |||||||||||||
25633 | 25633 | Kit Clardy C000416 | rep | MI | 1953-01-03 | 1955-01-03 | Republican | 6 | |||||||||||||
26235 | 26235 | Cliff Clevenger C000515 | rep | OH | 1953-01-03 | 1955-01-03 | Republican | 5 | |||||||||||||
25637 | 25637 | William Cole C000614 | rep | MO | 1953-01-03 | 1955-01-03 | Republican | 6 | |||||||||||||
26247 | 26247 | William Cole C000617 | rep | NY | 1953-01-03 | 1955-01-03 | Republican | 37 | |||||||||||||
29706 | 29706 | William Colmer C000645 | rep | MS | 1953-01-03 | 1955-01-03 | Democrat | 6 | |||||||||||||
25638 | 25638 | Robert Condon C000674 | rep | CA | 1953-01-03 | 1955-01-03 | Democrat | 6 | |||||||||||||
28383 | 28383 | Harold Cooley C000736 | rep | NC | 1953-01-03 | 1955-01-03 | Democrat | 4 | |||||||||||||
25900 | 25900 | Samuel Coon C000743 | rep | OR | 1953-01-03 | 1955-01-03 | Republican | 2 | |||||||||||||
26262 | 26262 | Jere Cooper C000755 | rep | TN | 1953-01-03 | 1955-01-03 | Democrat | 8 | |||||||||||||
28803 | 28803 | John Cooper C000758 | sen | KY | 1952-01-01 | 1955-01-03 | 2 | Republican | |||||||||||||
29722 | 29722 | Robert Corbett C000772 | rep | PA | 1953-01-03 | 1955-01-03 | Republican | 29 | |||||||||||||
24813 | 24813 | Guy Cordon C000774 | sen | OR | 1949-01-03 | 1955-01-03 | 2 | Republican | |||||||||||||
26268 | 26268 | Frederic Coudert C000804 | rep | NY | 1953-01-03 | 1955-01-03 | Republican | 17 |
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);