legislator_terms
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
482 rows where "end" is on date 1965-01-03 sorted by legislator_id
This data as json, copyable, CSV (advanced)
Suggested facets: 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
29519 | 29519 | Watkins Abbitt A000002 | rep | VA | 1963-01-09 | 1965-01-03 | Democrat | 4 | |||||||||||||
27602 | 27602 | Homer Abele A000011 | rep | OH | 1963-01-09 | 1965-01-03 | Republican | 10 | |||||||||||||
29534 | 29534 | Thomas Abernethy A000016 | rep | MS | 1963-01-09 | 1965-01-03 | Democrat | 1 | |||||||||||||
29109 | 29109 | Edwin Adair A000024 | rep | IN | 1963-01-09 | 1965-01-03 | Republican | 4 | |||||||||||||
33213 | 33213 | Joseph Addabbo A000052 | rep | NY | 1963-01-09 | 1965-01-03 | Democrat | 7 | |||||||||||||
30811 | 30811 | Carl Albert A000073 | rep | OK | 1963-01-09 | 1965-01-03 | Democrat | 3 | |||||||||||||
27607 | 27607 | Bruce Alger A000106 | rep | TX | 1963-01-09 | 1965-01-03 | Republican | 5 | |||||||||||||
31921 | 31921 | John Anderson A000195 | rep | IL | 1963-01-09 | 1965-01-03 | Republican | 16 | |||||||||||||
29554 | 29554 | George Andrews A000206 | rep | AL | 1963-01-09 | 1965-01-03 | Democrat | 0 | |||||||||||||
32435 | 32435 | Mark Andrews A000208 | rep | ND | 1963-01-09 | 1965-01-03 | Republican | 1 | |||||||||||||
30152 | 30152 | Leslie Arends A000216 | rep | IL | 1963-01-09 | 1965-01-03 | Republican | 17 | |||||||||||||
32447 | 32447 | John Ashbrook A000221 | rep | OH | 1963-01-09 | 1965-01-03 | Republican | 17 | |||||||||||||
31934 | 31934 | Thomas Ashley A000222 | rep | OH | 1963-01-09 | 1965-01-03 | Democrat | 9 | |||||||||||||
28769 | 28769 | Robert Ashmore A000223 | rep | SC | 1963-01-09 | 1965-01-03 | Democrat | 4 | |||||||||||||
29566 | 29566 | Wayne Aspinall A000225 | rep | CO | 1963-01-09 | 1965-01-03 | Democrat | 4 | |||||||||||||
27618 | 27618 | James Auchincloss A000227 | rep | NJ | 1963-01-09 | 1965-01-03 | Republican | 3 | |||||||||||||
27623 | 27623 | William Avery A000228 | rep | KS | 1963-01-09 | 1965-01-03 | Republican | 2 | |||||||||||||
29125 | 29125 | William Ayres A000229 | rep | OH | 1963-01-09 | 1965-01-03 | Republican | 14 | |||||||||||||
27630 | 27630 | Howard Baker B000062 | rep | TN | 1963-01-09 | 1965-01-03 | Republican | 2 | |||||||||||||
27631 | 27631 | Irene Baker B000064 | rep | TN | 1963-01-09 | 1965-01-03 | Republican | 2 | |||||||||||||
28314 | 28314 | John Baldwin B000092 | rep | CA | 1963-01-09 | 1965-01-03 | Republican | 14 | |||||||||||||
29576 | 29576 | Walter Baring B000141 | rep | NV | 1963-01-09 | 1965-01-03 | Democrat | 0 | |||||||||||||
30828 | 30828 | William Barrett B000178 | rep | PA | 1963-01-09 | 1965-01-03 | Democrat | 1 | |||||||||||||
27634 | 27634 | Robert Barry B000190 | rep | NY | 1963-01-09 | 1965-01-03 | Republican | 25 | |||||||||||||
29136 | 29136 | William Bates B000239 | rep | MA | 1963-01-09 | 1965-01-03 | Republican | 6 | |||||||||||||
29141 | 29141 | James Battin B000241 | rep | MT | 1963-01-09 | 1965-01-03 | Republican | 2 | |||||||||||||
26732 | 26732 | James Beall B000271 | sen | MD | 1959-01-07 | 1965-01-03 | 1 | Republican | |||||||||||||
27640 | 27640 | Frank Becker B000292 | rep | NY | 1963-01-09 | 1965-01-03 | Republican | 5 | |||||||||||||
28327 | 28327 | Lindley Beckworth B000296 | rep | TX | 1963-01-09 | 1965-01-03 | Democrat | 3 | |||||||||||||
27642 | 27642 | Ralph Beermann B000310 | rep | NE | 1963-01-09 | 1965-01-03 | Republican | 1 | |||||||||||||
29590 | 29590 | Page Belcher B000323 | rep | OK | 1963-01-09 | 1965-01-03 | Republican | 1 | |||||||||||||
30839 | 30839 | Alphonzo Bell B000330 | rep | CA | 1963-01-09 | 1965-01-03 | Republican | 28 | |||||||||||||
34240 | 34240 | Charles Bennett B000371 | rep | FL | 1963-01-09 | 1965-01-03 | Democrat | 2 | |||||||||||||
27652 | 27652 | John Bennett B000377 | rep | MI | 1963-01-09 | 1965-01-03 | Republican | 12 | |||||||||||||
29155 | 29155 | Ellis Berry B000416 | rep | SD | 1963-01-09 | 1965-01-03 | Republican | 2 | |||||||||||||
29601 | 29601 | Jackson Betts B000426 | rep | OH | 1963-01-09 | 1965-01-03 | Republican | 8 | |||||||||||||
30173 | 30173 | John Blatnik B000550 | rep | MN | 1963-01-09 | 1965-01-03 | Democrat | 8 | |||||||||||||
29618 | 29618 | Thomas Boggs B000594 | rep | LA | 1963-01-09 | 1965-01-03 | Democrat | 2 | |||||||||||||
33499 | 33499 | Edward Boland B000600 | rep | MA | 1963-01-09 | 1965-01-03 | Democrat | 2 | |||||||||||||
32496 | 32496 | Richard Bolling B000605 | rep | MO | 1963-01-09 | 1965-01-03 | Democrat | 5 | |||||||||||||
28799 | 28799 | Frances Bolton B000607 | rep | OH | 1963-01-09 | 1965-01-03 | Republican | 22 | |||||||||||||
27655 | 27655 | Oliver Bolton B000608 | rep | OH | 1963-01-09 | 1965-01-03 | Republican | 11 | |||||||||||||
28341 | 28341 | Herbert Bonner B000621 | rep | NC | 1963-01-09 | 1965-01-03 | Democrat | 1 | |||||||||||||
29629 | 29629 | Frank Bow B000676 | rep | OH | 1963-01-09 | 1965-01-03 | Republican | 16 | |||||||||||||
31958 | 31958 | John Brademas B000736 | rep | IN | 1963-01-09 | 1965-01-03 | Democrat | 3 | |||||||||||||
30189 | 30189 | William Bray B000778 | rep | IN | 1963-01-09 | 1965-01-03 | Republican | 7 | |||||||||||||
29634 | 29634 | William Brock B000851 | rep | TN | 1963-01-09 | 1965-01-03 | Republican | 3 | |||||||||||||
27660 | 27660 | James Bromwell B000867 | rep | IA | 1963-01-09 | 1965-01-03 | Republican | 2 | |||||||||||||
35140 | 35140 | Jack Brooks B000880 | rep | TX | 1963-01-09 | 1965-01-03 | Democrat | 2 | |||||||||||||
34268 | 34268 | William Broomfield B000890 | rep | MI | 1963-01-09 | 1965-01-03 | Republican | 18 | |||||||||||||
30197 | 30197 | Donald Brotzman B000893 | rep | CO | 1963-01-09 | 1965-01-03 | Republican | 2 | |||||||||||||
28355 | 28355 | Clarence Brown B000909 | rep | OH | 1963-01-09 | 1965-01-03 | Republican | 7 | |||||||||||||
36522 | 36522 | George Brown B000918 | rep | CA | 1963-01-09 | 1965-01-03 | Democrat | 29 | |||||||||||||
33457 | 33457 | James Broyhill B000966 | rep | NC | 1963-01-09 | 1965-01-03 | Republican | 9 | |||||||||||||
30207 | 30207 | Joel Broyhill B000967 | rep | VA | 1963-01-09 | 1965-01-03 | Republican | 10 | |||||||||||||
27662 | 27662 | Donald Bruce B000969 | rep | IN | 1963-01-09 | 1965-01-03 | Republican | 11 | |||||||||||||
27677 | 27677 | Charles Buckley B001024 | rep | NY | 1963-01-09 | 1965-01-03 | Democrat | 23 | |||||||||||||
33840 | 33840 | Quentin Burdick B001077 | sen | ND | 1960-08-08 | 1965-01-03 | 1 | Democrat | |||||||||||||
31442 | 31442 | James Burke B001092 | rep | MA | 1963-01-09 | 1965-01-03 | Democrat | 11 | |||||||||||||
27678 | 27678 | Everett Burkhalter B001104 | rep | CA | 1963-01-09 | 1965-01-03 | Democrat | 27 | |||||||||||||
31461 | 31461 | Omar Burleson B001111 | rep | TX | 1963-01-09 | 1965-01-03 | Democrat | 17 | |||||||||||||
29163 | 29163 | Laurence Burton B001155 | rep | UT | 1963-01-09 | 1965-01-03 | Republican | 1 | |||||||||||||
32908 | 32908 | Phillip Burton B001156 | rep | CA | 1963-01-09 | 1965-01-03 | Democrat | 5 | |||||||||||||
26780 | 26780 | Harry Byrd B001208 | sen | VA | 1959-01-07 | 1965-01-03 | 1 | Democrat | |||||||||||||
37954 | 37954 | Robert Byrd B001210 | sen | WV | 1959-01-07 | 1965-01-03 | 1 | Democrat | |||||||||||||
29645 | 29645 | James Byrne B001212 | rep | PA | 1963-01-09 | 1965-01-03 | Democrat | 3 | |||||||||||||
29659 | 29659 | John Byrnes B001216 | rep | WI | 1963-01-09 | 1965-01-03 | Republican | 8 | |||||||||||||
29171 | 29171 | William Cahill C000019 | rep | NJ | 1963-01-09 | 1965-01-03 | Republican | 1 | |||||||||||||
28359 | 28359 | Ronald Cameron C000067 | rep | CA | 1963-01-09 | 1965-01-03 | Democrat | 25 | |||||||||||||
27699 | 27699 | Clarence Cannon C000117 | rep | MO | 1963-01-09 | 1965-01-03 | Democrat | 9 | |||||||||||||
31476 | 31476 | Howard Cannon C000120 | sen | NV | 1959-01-07 | 1965-01-03 | 1 | Democrat | |||||||||||||
30217 | 30217 | Hugh Carey C000143 | rep | NY | 1963-01-09 | 1965-01-03 | Democrat | 15 | |||||||||||||
30857 | 30857 | Robert Casey C000228 | rep | TX | 1963-01-09 | 1965-01-03 | Democrat | 22 | |||||||||||||
31491 | 31491 | Elford Cederberg C000263 | rep | MI | 1963-01-09 | 1965-01-03 | Republican | 10 | |||||||||||||
29691 | 29691 | Emanuel Celler C000264 | rep | NY | 1963-01-09 | 1965-01-03 | Democrat | 10 | |||||||||||||
30235 | 30235 | Charles Chamberlain C000275 | rep | MI | 1963-01-09 | 1965-01-03 | Republican | 6 | |||||||||||||
28370 | 28370 | Frank Chelf C000342 | rep | KY | 1963-01-09 | 1965-01-03 | Democrat | 4 | |||||||||||||
27720 | 27720 | John Chenoweth C000346 | rep | CO | 1963-01-09 | 1965-01-03 | Republican | 3 | |||||||||||||
30869 | 30869 | Donald Clancy C000409 | rep | OH | 1963-01-09 | 1965-01-03 | Republican | 2 | |||||||||||||
30245 | 30245 | Frank Clark C000431 | rep | PA | 1963-01-09 | 1965-01-03 | Democrat | 25 | |||||||||||||
32556 | 32556 | Donald Clausen C000475 | rep | CA | 1963-01-09 | 1965-01-03 | Republican | 1 | |||||||||||||
31499 | 31499 | Delwin Clawson C000476 | rep | CA | 1963-01-09 | 1965-01-03 | Republican | 23 | |||||||||||||
31991 | 31991 | James Cleveland C000512 | rep | NH | 1963-01-09 | 1965-01-03 | Republican | 2 | |||||||||||||
29177 | 29177 | Jeffery Cohelan C000596 | rep | CA | 1963-01-09 | 1965-01-03 | Democrat | 7 | |||||||||||||
30255 | 30255 | Harold Collier C000629 | rep | IL | 1963-01-09 | 1965-01-03 | Republican | 10 | |||||||||||||
29711 | 29711 | William Colmer C000645 | rep | MS | 1963-01-09 | 1965-01-03 | Democrat | 5 | |||||||||||||
34327 | 34327 | Silvio Conte C000709 | rep | MA | 1963-01-09 | 1965-01-03 | Republican | 1 | |||||||||||||
28388 | 28388 | Harold Cooley C000736 | rep | NC | 1963-01-09 | 1965-01-03 | Democrat | 4 | |||||||||||||
29727 | 29727 | Robert Corbett C000772 | rep | PA | 1963-01-09 | 1965-01-03 | Republican | 18 | |||||||||||||
32001 | 32001 | James Corman C000780 | rep | CA | 1963-01-09 | 1965-01-03 | Democrat | 22 | |||||||||||||
29187 | 29187 | William Cramer C000869 | rep | FL | 1963-01-09 | 1965-01-03 | Republican | 12 | |||||||||||||
29194 | 29194 | Glenn Cunningham C000991 | rep | NE | 1963-01-09 | 1965-01-03 | Republican | 2 | |||||||||||||
28394 | 28394 | Willard Curtin C001005 | rep | PA | 1963-01-09 | 1965-01-03 | Republican | 8 | |||||||||||||
28813 | 28813 | Thomas Curtis C001014 | rep | MO | 1963-01-09 | 1965-01-03 | Republican | 2 | |||||||||||||
29200 | 29200 | Emilio Daddario D000001 | rep | CT | 1963-01-09 | 1965-01-03 | Democrat | 1 | |||||||||||||
28404 | 28404 | Paul Dague D000004 | rep | PA | 1963-01-09 | 1965-01-03 | Republican | 9 | |||||||||||||
30894 | 30894 | Dominick Daniels D000041 | rep | NJ | 1963-01-09 | 1965-01-03 | Democrat | 14 | |||||||||||||
27735 | 27735 | Clifford Davis D000094 | rep | TN | 1963-01-09 | 1965-01-03 | Democrat | 9 | |||||||||||||
30287 | 30287 | John Davis D000122 | rep | GA | 1963-01-09 | 1965-01-03 | Democrat | 7 | |||||||||||||
29214 | 29214 | William Dawson D000158 | rep | IL | 1963-01-09 | 1965-01-03 | Democrat | 1 |
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);