legislator_terms
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
480 rows where "end" is on date 1959-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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
29516 | 29516 | Watkins Abbitt A000002 | rep | VA | 1957-01-03 | 1959-01-03 | Democrat | 4 | |||||||||||||
29531 | 29531 | Thomas Abernethy A000016 | rep | MS | 1957-01-03 | 1959-01-03 | Democrat | 1 | |||||||||||||
29106 | 29106 | Edwin Adair A000024 | rep | IN | 1957-01-03 | 1959-01-03 | Republican | 4 | |||||||||||||
27065 | 27065 | Hugh Addonizio A000054 | rep | NJ | 1957-01-03 | 1959-01-03 | Democrat | 11 | |||||||||||||
30808 | 30808 | Carl Albert A000073 | rep | OK | 1957-01-03 | 1959-01-03 | Democrat | 3 | |||||||||||||
27070 | 27070 | Hugh Alexander A000094 | rep | NC | 1957-01-03 | 1959-01-03 | Democrat | 9 | |||||||||||||
27604 | 27604 | Bruce Alger A000106 | rep | TX | 1957-01-03 | 1959-01-03 | Republican | 5 | |||||||||||||
26161 | 26161 | John Allen A000133 | rep | CA | 1957-01-03 | 1959-01-03 | Republican | 7 | |||||||||||||
26704 | 26704 | Leo Allen A000138 | rep | IL | 1957-01-03 | 1959-01-03 | Republican | 16 | |||||||||||||
27084 | 27084 | Herman Andersen A000179 | rep | MN | 1957-01-03 | 1959-01-03 | Republican | 7 | |||||||||||||
26706 | 26706 | LeRoy Anderson A000200 | rep | MT | 1957-01-03 | 1959-01-03 | Democrat | 2 | |||||||||||||
29551 | 29551 | George Andrews A000206 | rep | AL | 1957-01-03 | 1959-01-03 | Democrat | 3 | |||||||||||||
30149 | 30149 | Leslie Arends A000216 | rep | IL | 1957-01-03 | 1959-01-03 | Republican | 17 | |||||||||||||
31931 | 31931 | Thomas Ashley A000222 | rep | OH | 1957-01-03 | 1959-01-03 | Democrat | 9 | |||||||||||||
28766 | 28766 | Robert Ashmore A000223 | rep | SC | 1957-01-03 | 1959-01-03 | Democrat | 4 | |||||||||||||
29563 | 29563 | Wayne Aspinall A000225 | rep | CO | 1957-01-03 | 1959-01-03 | Democrat | 4 | |||||||||||||
27615 | 27615 | James Auchincloss A000227 | rep | NJ | 1957-01-03 | 1959-01-03 | Republican | 3 | |||||||||||||
27620 | 27620 | William Avery A000228 | rep | KS | 1957-01-03 | 1959-01-03 | Republican | 1 | |||||||||||||
29122 | 29122 | William Ayres A000229 | rep | OH | 1957-01-03 | 1959-01-03 | Republican | 14 | |||||||||||||
26177 | 26177 | August Andresen A000239 | rep | MN | 1957-01-03 | 1959-01-03 | Republican | 1 | |||||||||||||
27089 | 27089 | Victor Anfuso A000255 | rep | NY | 1957-01-03 | 1959-01-03 | Democrat | 8 | |||||||||||||
27097 | 27097 | Cleveland Bailey B000035 | rep | WV | 1957-01-03 | 1959-01-03 | Democrat | 3 | |||||||||||||
27627 | 27627 | Howard Baker B000062 | rep | TN | 1957-01-03 | 1959-01-03 | Republican | 2 | |||||||||||||
28311 | 28311 | John Baldwin B000092 | rep | CA | 1957-01-03 | 1959-01-03 | Republican | 6 | |||||||||||||
26719 | 26719 | Graham Barden B000139 | rep | NC | 1957-01-03 | 1959-01-03 | Democrat | 3 | |||||||||||||
29573 | 29573 | Walter Baring B000141 | rep | NV | 1957-01-03 | 1959-01-03 | Democrat | 0 | |||||||||||||
25589 | 25589 | Frank Barrett B000176 | sen | WY | 1953-01-03 | 1959-01-03 | 1 | Republican | |||||||||||||
30825 | 30825 | William Barrett B000178 | rep | PA | 1957-01-03 | 1959-01-03 | Democrat | 1 | |||||||||||||
28778 | 28778 | Edward Bartlett B000201 | rep | AK | 1957-01-03 | 1959-01-03 | Democrat | 0 | |||||||||||||
27101 | 27101 | Perkins Bass B000222 | rep | NH | 1957-01-03 | 1959-01-03 | Republican | 2 | |||||||||||||
28303 | 28303 | Ross Bass B000223 | rep | TN | 1957-01-03 | 1959-01-03 | Democrat | 6 | |||||||||||||
29133 | 29133 | William Bates B000239 | rep | MA | 1957-01-03 | 1959-01-03 | Republican | 6 | |||||||||||||
26724 | 26724 | Albert Baumhart B000245 | rep | OH | 1957-01-03 | 1959-01-03 | Republican | 13 | |||||||||||||
26731 | 26731 | James Beall B000271 | sen | MD | 1953-01-03 | 1959-01-03 | 1 | Republican | |||||||||||||
26181 | 26181 | John Beamer B000276 | rep | IN | 1957-01-03 | 1959-01-03 | Republican | 5 | |||||||||||||
27637 | 27637 | Frank Becker B000292 | rep | NY | 1957-01-03 | 1959-01-03 | Republican | 3 | |||||||||||||
28324 | 28324 | Lindley Beckworth B000296 | rep | TX | 1957-01-03 | 1959-01-03 | Democrat | 3 | |||||||||||||
29587 | 29587 | Page Belcher B000323 | rep | OK | 1957-01-03 | 1959-01-03 | Republican | 1 | |||||||||||||
34237 | 34237 | Charles Bennett B000371 | rep | FL | 1957-01-03 | 1959-01-03 | Democrat | 2 | |||||||||||||
27649 | 27649 | John Bennett B000377 | rep | MI | 1957-01-03 | 1959-01-03 | Republican | 12 | |||||||||||||
26735 | 26735 | Alvin Bentley B000391 | rep | MI | 1957-01-03 | 1959-01-03 | Republican | 8 | |||||||||||||
29152 | 29152 | Ellis Berry B000416 | rep | SD | 1957-01-03 | 1959-01-03 | Republican | 2 | |||||||||||||
29598 | 29598 | Jackson Betts B000426 | rep | OH | 1957-01-03 | 1959-01-03 | Republican | 8 | |||||||||||||
30170 | 30170 | John Blatnik B000550 | rep | MN | 1957-01-03 | 1959-01-03 | Democrat | 8 | |||||||||||||
27107 | 27107 | Iris Blitch B000561 | rep | GA | 1957-01-03 | 1959-01-03 | Democrat | 8 | |||||||||||||
29615 | 29615 | Thomas Boggs B000594 | rep | LA | 1957-01-03 | 1959-01-03 | Democrat | 2 | |||||||||||||
33496 | 33496 | Edward Boland B000600 | rep | MA | 1957-01-03 | 1959-01-03 | Democrat | 2 | |||||||||||||
32493 | 32493 | Richard Bolling B000605 | rep | MO | 1957-01-03 | 1959-01-03 | Democrat | 5 | |||||||||||||
28796 | 28796 | Frances Bolton B000607 | rep | OH | 1957-01-03 | 1959-01-03 | Republican | 22 | |||||||||||||
28338 | 28338 | Herbert Bonner B000621 | rep | NC | 1957-01-03 | 1959-01-03 | Democrat | 1 | |||||||||||||
26739 | 26739 | Albert Bosch B000646 | rep | NY | 1957-01-03 | 1959-01-03 | Republican | 5 | |||||||||||||
29626 | 29626 | Frank Bow B000676 | rep | OH | 1957-01-03 | 1959-01-03 | Republican | 16 | |||||||||||||
26184 | 26184 | James Bowler B000698 | rep | IL | 1957-01-03 | 1959-01-03 | Democrat | 7 | |||||||||||||
27121 | 27121 | Frank Boykin B000725 | rep | AL | 1957-01-03 | 1959-01-03 | Democrat | 1 | |||||||||||||
26743 | 26743 | Charles Boyle B000727 | rep | IL | 1957-01-03 | 1959-01-03 | Democrat | 12 | |||||||||||||
30186 | 30186 | William Bray B000778 | rep | IN | 1957-01-03 | 1959-01-03 | Republican | 7 | |||||||||||||
27124 | 27124 | James Breeding B000791 | rep | KS | 1957-01-03 | 1959-01-03 | Democrat | 5 | |||||||||||||
25607 | 25607 | John Bricker B000820 | sen | OH | 1953-01-03 | 1959-01-03 | 1 | Republican | |||||||||||||
35137 | 35137 | Jack Brooks B000880 | rep | TX | 1957-01-03 | 1959-01-03 | Democrat | 2 | |||||||||||||
27137 | 27137 | Overton Brooks B000884 | rep | LA | 1957-01-03 | 1959-01-03 | Democrat | 4 | |||||||||||||
34265 | 34265 | William Broomfield B000890 | rep | MI | 1957-01-03 | 1959-01-03 | Republican | 18 | |||||||||||||
26746 | 26746 | Charles Brown B000908 | rep | MO | 1957-01-03 | 1959-01-03 | Democrat | 7 | |||||||||||||
28352 | 28352 | Clarence Brown B000909 | rep | OH | 1957-01-03 | 1959-01-03 | Republican | 7 | |||||||||||||
26760 | 26760 | Paul Brown B000940 | rep | GA | 1957-01-03 | 1959-01-03 | Democrat | 10 | |||||||||||||
26188 | 26188 | Charles Brownson B000964 | rep | IN | 1957-01-03 | 1959-01-03 | Republican | 11 | |||||||||||||
30204 | 30204 | Joel Broyhill B000967 | rep | VA | 1957-01-03 | 1959-01-03 | Republican | 10 | |||||||||||||
27674 | 27674 | Charles Buckley B001024 | rep | NY | 1957-01-03 | 1959-01-03 | Democrat | 24 | |||||||||||||
26766 | 26766 | Hamer Budge B001035 | rep | ID | 1957-01-03 | 1959-01-03 | Republican | 2 | |||||||||||||
26198 | 26198 | Usher Burdick B001079 | rep | ND | 1957-01-03 | 1959-01-03 | Republican | 0 | |||||||||||||
31458 | 31458 | Omar Burleson B001111 | rep | TX | 1957-01-03 | 1959-01-03 | Democrat | 17 | |||||||||||||
26768 | 26768 | John Burns B001127 | rep | HI | 1957-01-03 | 1959-01-03 | Democrat | 0 | |||||||||||||
26773 | 26773 | Alvin Bush B001165 | rep | PA | 1957-01-03 | 1959-01-03 | Republican | 17 | |||||||||||||
26779 | 26779 | Harry Byrd B001208 | sen | VA | 1953-01-03 | 1959-01-03 | 1 | Democrat | |||||||||||||
37953 | 37953 | Robert Byrd B001210 | rep | WV | 1957-01-03 | 1959-01-03 | Democrat | 6 | |||||||||||||
26203 | 26203 | Emmet Byrne B001211 | rep | IL | 1957-01-03 | 1959-01-03 | Republican | 3 | |||||||||||||
29642 | 29642 | James Byrne B001212 | rep | PA | 1957-01-03 | 1959-01-03 | Democrat | 3 | |||||||||||||
29656 | 29656 | John Byrnes B001216 | rep | WI | 1957-01-03 | 1959-01-03 | Republican | 8 | |||||||||||||
26790 | 26790 | Gordon Canfield C000113 | rep | NJ | 1957-01-03 | 1959-01-03 | Republican | 8 | |||||||||||||
27696 | 27696 | Clarence Cannon C000117 | rep | MO | 1957-01-03 | 1959-01-03 | Democrat | 9 | |||||||||||||
26797 | 26797 | Albert Carnahan C000162 | rep | MO | 1957-01-03 | 1959-01-03 | Democrat | 8 | |||||||||||||
26210 | 26210 | Joseph Carrigg C000182 | rep | PA | 1957-01-03 | 1959-01-03 | Republican | 10 | |||||||||||||
31488 | 31488 | Elford Cederberg C000263 | rep | MI | 1957-01-03 | 1959-01-03 | Republican | 10 | |||||||||||||
29688 | 29688 | Emanuel Celler C000264 | rep | NY | 1957-01-03 | 1959-01-03 | Democrat | 11 | |||||||||||||
30232 | 30232 | Charles Chamberlain C000275 | rep | MI | 1957-01-03 | 1959-01-03 | Republican | 6 | |||||||||||||
26805 | 26805 | Dennis Chavez C000338 | sen | NM | 1953-01-03 | 1959-01-03 | 1 | Democrat | |||||||||||||
28367 | 28367 | Frank Chelf C000342 | rep | KY | 1957-01-03 | 1959-01-03 | Democrat | 4 | |||||||||||||
27717 | 27717 | John Chenoweth C000346 | rep | CO | 1957-01-03 | 1959-01-03 | Republican | 3 | |||||||||||||
27151 | 27151 | Robert Chiperfield C000365 | rep | IL | 1957-01-03 | 1959-01-03 | Republican | 19 | |||||||||||||
26809 | 26809 | George Christopher C000383 | rep | MO | 1957-01-03 | 1959-01-03 | Democrat | 4 | |||||||||||||
26227 | 26227 | Earl Chudoff C000386 | rep | PA | 1957-01-03 | 1959-01-03 | Democrat | 4 | |||||||||||||
27157 | 27157 | Marguerite Church C000389 | rep | IL | 1957-01-03 | 1959-01-03 | Republican | 13 | |||||||||||||
30242 | 30242 | Frank Clark C000431 | rep | PA | 1957-01-03 | 1959-01-03 | Democrat | 25 | |||||||||||||
26237 | 26237 | Cliff Clevenger C000515 | rep | OH | 1957-01-03 | 1959-01-03 | Republican | 5 | |||||||||||||
27160 | 27160 | Merwin Coad C000540 | rep | IA | 1957-01-03 | 1959-01-03 | Democrat | 6 | |||||||||||||
26811 | 26811 | Frank Coffin C000589 | rep | ME | 1957-01-03 | 1959-01-03 | Democrat | 2 | |||||||||||||
26249 | 26249 | William Cole C000617 | rep | NY | 1957-01-03 | 1959-01-03 | Republican | 37 | |||||||||||||
30252 | 30252 | Harold Collier C000629 | rep | IL | 1957-01-03 | 1959-01-03 | Republican | 10 | |||||||||||||
29708 | 29708 | William Colmer C000645 | rep | MS | 1957-01-03 | 1959-01-03 | Democrat | 6 | |||||||||||||
28385 | 28385 | Harold Cooley C000736 | rep | NC | 1957-01-03 | 1959-01-03 | Democrat | 4 | |||||||||||||
26264 | 26264 | Jere Cooper C000755 | rep | TN | 1957-01-03 | 1959-01-03 | Democrat | 8 |
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);