legislator_terms
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
486 rows where "end" is on date 1953-01-03 sorted by legislator_id
This data as json, copyable, CSV (advanced)
Suggested facets: type, 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
25111 | 25111 | Fred Aandahl A000001 | rep | ND | 1951-01-03 | 1953-01-03 | Republican | 0 | |||||||||||||
29513 | 29513 | Watkins Abbitt A000002 | rep | VA | 1951-01-03 | 1953-01-03 | Democrat | 4 | |||||||||||||
29528 | 29528 | Thomas Abernethy A000016 | rep | MS | 1951-01-03 | 1953-01-03 | Democrat | 4 | |||||||||||||
29103 | 29103 | Edwin Adair A000024 | rep | IN | 1951-01-03 | 1953-01-03 | Republican | 4 | |||||||||||||
27062 | 27062 | Hugh Addonizio A000054 | rep | NJ | 1951-01-03 | 1953-01-03 | Democrat | 11 | |||||||||||||
30805 | 30805 | Carl Albert A000073 | rep | OK | 1951-01-03 | 1953-01-03 | Democrat | 3 | |||||||||||||
25119 | 25119 | Asa Allen A000114 | rep | LA | 1951-01-03 | 1953-01-03 | Democrat | 8 | |||||||||||||
26158 | 26158 | John Allen A000133 | rep | CA | 1951-01-03 | 1953-01-03 | Republican | 7 | |||||||||||||
26701 | 26701 | Leo Allen A000138 | rep | IL | 1951-01-03 | 1953-01-03 | Republican | 16 | |||||||||||||
27081 | 27081 | Herman Andersen A000179 | rep | MN | 1951-01-03 | 1953-01-03 | Republican | 7 | |||||||||||||
25126 | 25126 | John Anderson A000196 | rep | CA | 1951-01-03 | 1953-01-03 | Republican | 8 | |||||||||||||
29548 | 29548 | George Andrews A000206 | rep | AL | 1951-01-03 | 1953-01-03 | Democrat | 3 | |||||||||||||
30146 | 30146 | Leslie Arends A000216 | rep | IL | 1951-01-03 | 1953-01-03 | Republican | 17 | |||||||||||||
25127 | 25127 | Orland Armstrong A000218 | rep | MO | 1951-01-03 | 1953-01-03 | Republican | 6 | |||||||||||||
29560 | 29560 | Wayne Aspinall A000225 | rep | CO | 1951-01-03 | 1953-01-03 | Democrat | 4 | |||||||||||||
27612 | 27612 | James Auchincloss A000227 | rep | NJ | 1951-01-03 | 1953-01-03 | Republican | 3 | |||||||||||||
29119 | 29119 | William Ayres A000229 | rep | OH | 1951-01-03 | 1953-01-03 | Republican | 14 | |||||||||||||
26174 | 26174 | August Andresen A000239 | rep | MN | 1951-01-03 | 1953-01-03 | Republican | 1 | |||||||||||||
27087 | 27087 | Victor Anfuso A000255 | rep | NY | 1951-01-03 | 1953-01-03 | Democrat | 8 | |||||||||||||
25583 | 25583 | Homer Angell A000257 | rep | OR | 1951-01-03 | 1953-01-03 | Republican | 3 | |||||||||||||
27094 | 27094 | Cleveland Bailey B000035 | rep | WV | 1951-01-03 | 1953-01-03 | Democrat | 3 | |||||||||||||
27624 | 27624 | Howard Baker B000062 | rep | TN | 1951-01-03 | 1953-01-03 | Republican | 2 | |||||||||||||
25129 | 25129 | Claude Bakewell B000080 | rep | MO | 1951-01-03 | 1953-01-03 | Republican | 11 | |||||||||||||
26716 | 26716 | Graham Barden B000139 | rep | NC | 1951-01-03 | 1953-01-03 | Democrat | 3 | |||||||||||||
29572 | 29572 | Walter Baring B000141 | rep | NV | 1951-01-03 | 1953-01-03 | Democrat | 0 | |||||||||||||
30822 | 30822 | William Barrett B000178 | rep | PA | 1951-01-03 | 1953-01-03 | Democrat | 1 | |||||||||||||
28775 | 28775 | Edward Bartlett B000201 | rep | AK | 1951-01-03 | 1953-01-03 | Democrat | 0 | |||||||||||||
25137 | 25137 | Joseph Bates B000237 | rep | KY | 1951-01-03 | 1953-01-03 | Democrat | 8 | |||||||||||||
29130 | 29130 | William Bates B000239 | rep | MA | 1951-01-03 | 1953-01-03 | Republican | 6 | |||||||||||||
25592 | 25592 | Laurie Battle B000242 | rep | AL | 1951-01-03 | 1953-01-03 | Democrat | 9 | |||||||||||||
26730 | 26730 | James Beall B000271 | rep | MD | 1951-01-03 | 1953-01-03 | Republican | 6 | |||||||||||||
26178 | 26178 | John Beamer B000276 | rep | IN | 1951-01-03 | 1953-01-03 | Republican | 5 | |||||||||||||
28323 | 28323 | Lindley Beckworth B000296 | rep | TX | 1951-01-03 | 1953-01-03 | Democrat | 3 | |||||||||||||
29584 | 29584 | Page Belcher B000323 | rep | OK | 1951-01-03 | 1953-01-03 | Republican | 8 | |||||||||||||
25852 | 25852 | George Bender B000356 | rep | OH | 1951-01-03 | 1953-01-03 | Republican | 0 | |||||||||||||
34234 | 34234 | Charles Bennett B000371 | rep | FL | 1951-01-03 | 1953-01-03 | Democrat | 2 | |||||||||||||
27646 | 27646 | John Bennett B000377 | rep | MI | 1951-01-03 | 1953-01-03 | Republican | 12 | |||||||||||||
24739 | 24739 | William Benton B000399 | sen | CT | 1949-12-17 | 1953-01-03 | 1 | Democrat | appointment | ||||||||||||
33816 | 33816 | Lloyd Bentsen B000401 | rep | TX | 1951-01-03 | 1953-01-03 | Democrat | 15 | |||||||||||||
29149 | 29149 | Ellis Berry B000416 | rep | SD | 1951-01-03 | 1953-01-03 | Republican | 2 | |||||||||||||
29595 | 29595 | Jackson Betts B000426 | rep | OH | 1951-01-03 | 1953-01-03 | Republican | 8 | |||||||||||||
25599 | 25599 | Cecil Bishop B000486 | rep | IL | 1951-01-03 | 1953-01-03 | Republican | 26 | |||||||||||||
25145 | 25145 | William Blackney B000515 | rep | MI | 1951-01-03 | 1953-01-03 | Republican | 6 | |||||||||||||
30167 | 30167 | John Blatnik B000550 | rep | MN | 1951-01-03 | 1953-01-03 | Democrat | 8 | |||||||||||||
28784 | 28784 | James Boggs B000593 | rep | DE | 1951-01-03 | 1953-01-03 | Republican | 0 | |||||||||||||
29612 | 29612 | Thomas Boggs B000594 | rep | LA | 1951-01-03 | 1953-01-03 | Democrat | 2 | |||||||||||||
32490 | 32490 | Richard Bolling B000605 | rep | MO | 1951-01-03 | 1953-01-03 | Democrat | 5 | |||||||||||||
28793 | 28793 | Frances Bolton B000607 | rep | OH | 1951-01-03 | 1953-01-03 | Republican | 22 | |||||||||||||
28335 | 28335 | Herbert Bonner B000621 | rep | NC | 1951-01-03 | 1953-01-03 | Democrat | 1 | |||||||||||||
25147 | 25147 | Reva Bosone B000649 | rep | UT | 1951-01-03 | 1953-01-03 | Democrat | 2 | |||||||||||||
29623 | 29623 | Frank Bow B000676 | rep | OH | 1951-01-03 | 1953-01-03 | Republican | 16 | |||||||||||||
27118 | 27118 | Frank Boykin B000725 | rep | AL | 1951-01-03 | 1953-01-03 | Democrat | 1 | |||||||||||||
25604 | 25604 | Ernest Bramblett B000762 | rep | CA | 1951-01-03 | 1953-01-03 | Republican | 11 | |||||||||||||
30183 | 30183 | William Bray B000778 | rep | IN | 1951-01-03 | 1953-01-03 | Republican | 7 | |||||||||||||
25149 | 25149 | Edward Breen B000792 | rep | OH | 1951-01-03 | 1953-01-03 | Democrat | 3 | |||||||||||||
25154 | 25154 | Walter Brehm B000794 | rep | OH | 1951-01-03 | 1953-01-03 | Republican | 11 | |||||||||||||
24285 | 24285 | Ralph Brewster B000816 | sen | ME | 1947-01-03 | 1953-01-03 | 1 | Republican | |||||||||||||
25606 | 25606 | John Bricker B000820 | sen | OH | 1947-01-03 | 1953-01-03 | 1 | Republican | |||||||||||||
27134 | 27134 | Overton Brooks B000884 | rep | LA | 1951-01-03 | 1953-01-03 | Democrat | 4 | |||||||||||||
28349 | 28349 | Clarence Brown B000909 | rep | OH | 1951-01-03 | 1953-01-03 | Republican | 7 | |||||||||||||
26757 | 26757 | Paul Brown B000940 | rep | GA | 1951-01-03 | 1953-01-03 | Democrat | 10 | |||||||||||||
26185 | 26185 | Charles Brownson B000964 | rep | IN | 1951-01-03 | 1953-01-03 | Republican | 11 | |||||||||||||
25614 | 25614 | Joseph Bryson B000999 | rep | SC | 1951-01-03 | 1953-01-03 | Democrat | 4 | |||||||||||||
25158 | 25158 | Frank Buchanan B001002 | rep | PA | 1951-01-03 | 1953-01-03 | Democrat | 33 | |||||||||||||
25885 | 25885 | Vera Buchanan B001009 | rep | PA | 1951-01-03 | 1953-01-03 | Democrat | 33 | |||||||||||||
27671 | 27671 | Charles Buckley B001024 | rep | NY | 1951-01-03 | 1953-01-03 | Democrat | 25 | |||||||||||||
26763 | 26763 | Hamer Budge B001035 | rep | ID | 1951-01-03 | 1953-01-03 | Republican | 2 | |||||||||||||
25162 | 25162 | Howard Buffett B001039 | rep | NE | 1951-01-03 | 1953-01-03 | Republican | 2 | |||||||||||||
26195 | 26195 | Usher Burdick B001079 | rep | ND | 1951-01-03 | 1953-01-03 | Republican | 0 | |||||||||||||
31455 | 31455 | Omar Burleson B001111 | rep | TX | 1951-01-03 | 1953-01-03 | Democrat | 17 | |||||||||||||
25889 | 25889 | Maurice Burnside B001131 | rep | WV | 1951-01-03 | 1953-01-03 | Democrat | 4 | |||||||||||||
25165 | 25165 | Clarence Burton B001148 | rep | VA | 1951-01-03 | 1953-01-03 | Democrat | 6 | |||||||||||||
25619 | 25619 | Fred Busbey B001161 | rep | IL | 1951-01-03 | 1953-01-03 | Republican | 3 | |||||||||||||
26770 | 26770 | Alvin Bush B001165 | rep | PA | 1951-01-03 | 1953-01-03 | Republican | 15 | |||||||||||||
25622 | 25622 | Hugh Butler B001177 | sen | NE | 1947-01-03 | 1953-01-03 | 1 | Republican | |||||||||||||
25170 | 25170 | John Butler B001179 | rep | NY | 1951-01-03 | 1953-01-03 | Republican | 44 | |||||||||||||
26778 | 26778 | Harry Byrd B001208 | sen | VA | 1947-01-03 | 1953-01-03 | 1 | Democrat | |||||||||||||
25178 | 25178 | William Byrne B001214 | rep | NY | 1951-01-03 | 1953-01-03 | Democrat | 32 | |||||||||||||
29653 | 29653 | John Byrnes B001216 | rep | WI | 1951-01-03 | 1953-01-03 | Republican | 8 | |||||||||||||
24243 | 24243 | Harry Cain C000021 | sen | WA | 1947-01-03 | 1953-01-03 | 1 | Republican | |||||||||||||
25630 | 25630 | Albert Camp C000070 | rep | GA | 1951-01-03 | 1953-01-03 | Democrat | 4 | |||||||||||||
26787 | 26787 | Gordon Canfield C000113 | rep | NJ | 1951-01-03 | 1953-01-03 | Republican | 8 | |||||||||||||
27693 | 27693 | Clarence Cannon C000117 | rep | MO | 1951-01-03 | 1953-01-03 | Democrat | 9 | |||||||||||||
25892 | 25892 | Frank Carlyle C000156 | rep | NC | 1951-01-03 | 1953-01-03 | Democrat | 7 | |||||||||||||
26794 | 26794 | Albert Carnahan C000162 | rep | MO | 1951-01-03 | 1953-01-03 | Democrat | 8 | |||||||||||||
26207 | 26207 | Joseph Carrigg C000182 | rep | PA | 1951-01-03 | 1953-01-03 | Republican | 14 | |||||||||||||
30226 | 30226 | Clifford Case C000220 | rep | NJ | 1951-01-03 | 1953-01-03 | Republican | 6 | |||||||||||||
29685 | 29685 | Emanuel Celler C000264 | rep | NY | 1951-01-03 | 1953-01-03 | Democrat | 15 | |||||||||||||
25897 | 25897 | Richard Chatham C000336 | rep | NC | 1951-01-03 | 1953-01-03 | Democrat | 5 | |||||||||||||
26804 | 26804 | Dennis Chavez C000338 | sen | NM | 1947-01-03 | 1953-01-03 | 1 | Democrat | |||||||||||||
28364 | 28364 | Frank Chelf C000342 | rep | KY | 1951-01-03 | 1953-01-03 | Democrat | 4 | |||||||||||||
27714 | 27714 | John Chenoweth C000346 | rep | CO | 1951-01-03 | 1953-01-03 | Republican | 3 | |||||||||||||
27148 | 27148 | Robert Chiperfield C000365 | rep | IL | 1951-01-03 | 1953-01-03 | Republican | 19 | |||||||||||||
26224 | 26224 | Earl Chudoff C000386 | rep | PA | 1951-01-03 | 1953-01-03 | Democrat | 4 | |||||||||||||
27154 | 27154 | Marguerite Church C000389 | rep | IL | 1951-01-03 | 1953-01-03 | Republican | 13 | |||||||||||||
25180 | 25180 | Louis Clemente C000504 | rep | NY | 1951-01-03 | 1953-01-03 | Democrat | 4 | |||||||||||||
26234 | 26234 | Cliff Clevenger C000515 | rep | OH | 1951-01-03 | 1953-01-03 | Republican | 5 | |||||||||||||
25184 | 25184 | Albert Cole C000606 | rep | KS | 1951-01-03 | 1953-01-03 | Republican | 1 | |||||||||||||
26246 | 26246 | William Cole C000617 | rep | NY | 1951-01-03 | 1953-01-03 | Republican | 39 | |||||||||||||
29705 | 29705 | William Colmer C000645 | rep | MS | 1951-01-03 | 1953-01-03 | Democrat | 6 |
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);