legislator_terms
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
474 rows where "end" is on date 1969-01-03 sorted by legislator_id
This data as json, copyable, CSV (advanced)
Suggested facets: type, start, class, district, 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
29521 | 29521 | Watkins Abbitt A000002 | rep | VA | 1967-01-10 | 1969-01-03 | Democrat | 4 | |||||||||||||
29536 | 29536 | Thomas Abernethy A000016 | rep | MS | 1967-01-10 | 1969-01-03 | Democrat | 1 | |||||||||||||
29111 | 29111 | Edwin Adair A000024 | rep | IN | 1967-01-10 | 1969-01-03 | Republican | 4 | |||||||||||||
33471 | 33471 | Brockman Adams A000031 | rep | WA | 1967-01-10 | 1969-01-03 | Democrat | 7 | |||||||||||||
33215 | 33215 | Joseph Addabbo A000052 | rep | NY | 1967-01-10 | 1969-01-03 | Democrat | 7 | |||||||||||||
29117 | 29117 | George Aiken A000062 | sen | VT | 1963-01-09 | 1969-01-03 | 3 | Republican | |||||||||||||
30813 | 30813 | Carl Albert A000073 | rep | OK | 1967-01-10 | 1969-01-03 | Democrat | 3 | |||||||||||||
31923 | 31923 | John Anderson A000195 | rep | IL | 1967-01-10 | 1969-01-03 | Republican | 16 | |||||||||||||
29540 | 29540 | William Anderson A000203 | rep | TN | 1967-01-10 | 1969-01-03 | Democrat | 6 | |||||||||||||
29556 | 29556 | George Andrews A000206 | rep | AL | 1967-01-10 | 1969-01-03 | Democrat | 3 | |||||||||||||
32437 | 32437 | Mark Andrews A000208 | rep | ND | 1967-01-10 | 1969-01-03 | Republican | 1 | |||||||||||||
34187 | 34187 | Frank Annunzio A000212 | rep | IL | 1967-01-10 | 1969-01-03 | Democrat | 7 | |||||||||||||
30154 | 30154 | Leslie Arends A000216 | rep | IL | 1967-01-10 | 1969-01-03 | Republican | 17 | |||||||||||||
32449 | 32449 | John Ashbrook A000221 | rep | OH | 1967-01-10 | 1969-01-03 | Republican | 17 | |||||||||||||
31936 | 31936 | Thomas Ashley A000222 | rep | OH | 1967-01-10 | 1969-01-03 | Democrat | 9 | |||||||||||||
28771 | 28771 | Robert Ashmore A000223 | rep | SC | 1967-01-10 | 1969-01-03 | Democrat | 4 | |||||||||||||
29568 | 29568 | Wayne Aspinall A000225 | rep | CO | 1967-01-10 | 1969-01-03 | Democrat | 4 | |||||||||||||
29127 | 29127 | William Ayres A000229 | rep | OH | 1967-01-10 | 1969-01-03 | Republican | 14 | |||||||||||||
29578 | 29578 | Walter Baring B000141 | rep | NV | 1967-01-10 | 1969-01-03 | Democrat | 0 | |||||||||||||
30830 | 30830 | William Barrett B000178 | rep | PA | 1967-01-10 | 1969-01-03 | Democrat | 1 | |||||||||||||
29138 | 29138 | William Bates B000239 | rep | MA | 1967-01-10 | 1969-01-03 | Republican | 6 | |||||||||||||
29143 | 29143 | James Battin B000241 | rep | MT | 1967-01-10 | 1969-01-03 | Republican | 2 | |||||||||||||
30835 | 30835 | Birch Bayh B000254 | sen | IN | 1963-01-09 | 1969-01-03 | 3 | Democrat | |||||||||||||
29592 | 29592 | Page Belcher B000323 | rep | OK | 1967-01-10 | 1969-01-03 | Republican | 1 | |||||||||||||
30841 | 30841 | Alphonzo Bell B000330 | rep | CA | 1967-01-10 | 1969-01-03 | Republican | 28 | |||||||||||||
34242 | 34242 | Charles Bennett B000371 | rep | FL | 1967-01-10 | 1969-01-03 | Democrat | 3 | |||||||||||||
29147 | 29147 | Wallace Bennett B000384 | sen | UT | 1963-01-09 | 1969-01-03 | 3 | Republican | |||||||||||||
29157 | 29157 | Ellis Berry B000416 | rep | SD | 1967-01-10 | 1969-01-03 | Republican | 2 | |||||||||||||
29603 | 29603 | Jackson Betts B000426 | rep | OH | 1967-01-10 | 1969-01-03 | Republican | 8 | |||||||||||||
35693 | 35693 | Tom Bevill B000431 | rep | AL | 1967-01-10 | 1969-01-03 | Democrat | 7 | |||||||||||||
29161 | 29161 | Alan Bible B000436 | sen | NV | 1963-01-09 | 1969-01-03 | 3 | Democrat | |||||||||||||
30850 | 30850 | Edward Biester B000451 | rep | PA | 1967-01-10 | 1969-01-03 | Republican | 8 | |||||||||||||
32477 | 32477 | Jonathan Bingham B000472 | rep | NY | 1967-01-10 | 1969-01-03 | Democrat | 23 | |||||||||||||
30161 | 30161 | Benjamin Blackburn B000506 | rep | GA | 1967-01-10 | 1969-01-03 | Republican | 4 | |||||||||||||
29606 | 29606 | Leonard Blanton B000548 | rep | TN | 1967-01-10 | 1969-01-03 | Democrat | 7 | |||||||||||||
30175 | 30175 | John Blatnik B000550 | rep | MN | 1967-01-10 | 1969-01-03 | Democrat | 8 | |||||||||||||
29620 | 29620 | Thomas Boggs B000594 | rep | LA | 1967-01-10 | 1969-01-03 | Democrat | 2 | |||||||||||||
33501 | 33501 | Edward Boland B000600 | rep | MA | 1967-01-10 | 1969-01-03 | Democrat | 2 | |||||||||||||
32498 | 32498 | Richard Bolling B000605 | rep | MO | 1967-01-10 | 1969-01-03 | Democrat | 5 | |||||||||||||
28801 | 28801 | Frances Bolton B000607 | rep | OH | 1967-01-10 | 1969-01-03 | Republican | 22 | |||||||||||||
29631 | 29631 | Frank Bow B000676 | rep | OH | 1967-01-10 | 1969-01-03 | Republican | 16 | |||||||||||||
31960 | 31960 | John Brademas B000736 | rep | IN | 1967-01-10 | 1969-01-03 | Democrat | 3 | |||||||||||||
30179 | 30179 | Frank Brasco B000771 | rep | NY | 1967-01-10 | 1969-01-03 | Democrat | 11 | |||||||||||||
30191 | 30191 | William Bray B000778 | rep | IN | 1967-01-10 | 1969-01-03 | Republican | 6 | |||||||||||||
27658 | 27658 | Daniel Brewster B000813 | sen | MD | 1963-01-09 | 1969-01-03 | 3 | Democrat | |||||||||||||
32511 | 32511 | Jack Brinkley B000839 | rep | GA | 1967-01-10 | 1969-01-03 | Democrat | 3 | |||||||||||||
29636 | 29636 | William Brock B000851 | rep | TN | 1967-01-10 | 1969-01-03 | Republican | 3 | |||||||||||||
35142 | 35142 | Jack Brooks B000880 | rep | TX | 1967-01-10 | 1969-01-03 | Democrat | 9 | |||||||||||||
34270 | 34270 | William Broomfield B000890 | rep | MI | 1967-01-10 | 1969-01-03 | Republican | 18 | |||||||||||||
30198 | 30198 | Donald Brotzman B000893 | rep | CO | 1967-01-10 | 1969-01-03 | Republican | 2 | |||||||||||||
32524 | 32524 | Clarence Brown B000910 | rep | OH | 1967-01-10 | 1969-01-03 | Republican | 7 | |||||||||||||
31428 | 31428 | Garry Brown B000917 | rep | MI | 1967-01-10 | 1969-01-03 | Republican | 3 | |||||||||||||
36524 | 36524 | George Brown B000918 | rep | CA | 1967-01-10 | 1969-01-03 | Democrat | 29 | |||||||||||||
33459 | 33459 | James Broyhill B000966 | rep | NC | 1967-01-10 | 1969-01-03 | Republican | 9 | |||||||||||||
30209 | 30209 | Joel Broyhill B000967 | rep | VA | 1967-01-10 | 1969-01-03 | Republican | 10 | |||||||||||||
31968 | 31968 | John Buchanan B001008 | rep | AL | 1967-01-10 | 1969-01-03 | Republican | 6 | |||||||||||||
31434 | 31434 | J. Burke B001091 | rep | FL | 1967-01-10 | 1969-01-03 | Republican | 10 | |||||||||||||
31444 | 31444 | James Burke B001092 | rep | MA | 1967-01-10 | 1969-01-03 | Democrat | 11 | |||||||||||||
31463 | 31463 | Omar Burleson B001111 | rep | TX | 1967-01-10 | 1969-01-03 | Democrat | 17 | |||||||||||||
29165 | 29165 | Laurence Burton B001155 | rep | UT | 1967-01-10 | 1969-01-03 | Republican | 1 | |||||||||||||
32910 | 32910 | Phillip Burton B001156 | rep | CA | 1967-01-10 | 1969-01-03 | Democrat | 5 | |||||||||||||
34160 | 34160 | George Bush B001166 | rep | TX | 1967-01-10 | 1969-01-03 | Republican | 7 | |||||||||||||
29167 | 29167 | Daniel Button B001201 | rep | NY | 1967-01-10 | 1969-01-03 | Republican | 29 | |||||||||||||
29647 | 29647 | James Byrne B001212 | rep | PA | 1967-01-10 | 1969-01-03 | Democrat | 3 | |||||||||||||
29661 | 29661 | John Byrnes B001216 | rep | WI | 1967-01-10 | 1969-01-03 | Republican | 8 | |||||||||||||
29665 | 29665 | Earle Cabell C000002 | rep | TX | 1967-01-10 | 1969-01-03 | Democrat | 5 | |||||||||||||
29173 | 29173 | William Cahill C000019 | rep | NJ | 1967-01-10 | 1969-01-03 | Republican | 6 | |||||||||||||
30219 | 30219 | Hugh Carey C000143 | rep | NY | 1967-01-10 | 1969-01-03 | Democrat | 15 | |||||||||||||
27709 | 27709 | Frank Carlson C000154 | sen | KS | 1963-01-09 | 1969-01-03 | 3 | Republican | |||||||||||||
31982 | 31982 | Tim Carter C000201 | rep | KY | 1967-01-10 | 1969-01-03 | Republican | 5 | |||||||||||||
30859 | 30859 | Robert Casey C000228 | rep | TX | 1967-01-10 | 1969-01-03 | Democrat | 22 | |||||||||||||
31493 | 31493 | Elford Cederberg C000263 | rep | MI | 1967-01-10 | 1969-01-03 | Republican | 10 | |||||||||||||
29693 | 29693 | Emanuel Celler C000264 | rep | NY | 1967-01-10 | 1969-01-03 | Democrat | 10 | |||||||||||||
30237 | 30237 | Charles Chamberlain C000275 | rep | MI | 1967-01-10 | 1969-01-03 | Republican | 6 | |||||||||||||
30865 | 30865 | Frank Church C000388 | sen | ID | 1963-01-09 | 1969-01-03 | 3 | Democrat | |||||||||||||
30871 | 30871 | Donald Clancy C000409 | rep | OH | 1967-01-10 | 1969-01-03 | Republican | 2 | |||||||||||||
30247 | 30247 | Frank Clark C000431 | rep | PA | 1967-01-10 | 1969-01-03 | Democrat | 25 | |||||||||||||
27722 | 27722 | Joseph Clark C000444 | sen | PA | 1963-01-09 | 1969-01-03 | 3 | Democrat | |||||||||||||
32558 | 32558 | Donald Clausen C000475 | rep | CA | 1967-01-10 | 1969-01-03 | Republican | 1 | |||||||||||||
31501 | 31501 | Delwin Clawson C000476 | rep | CA | 1967-01-10 | 1969-01-03 | Republican | 23 | |||||||||||||
31993 | 31993 | James Cleveland C000512 | rep | NH | 1967-01-10 | 1969-01-03 | Republican | 2 | |||||||||||||
29179 | 29179 | Jeffery Cohelan C000596 | rep | CA | 1967-01-10 | 1969-01-03 | Democrat | 7 | |||||||||||||
30257 | 30257 | Harold Collier C000629 | rep | IL | 1967-01-10 | 1969-01-03 | Republican | 10 | |||||||||||||
32566 | 32566 | James Collins C000638 | rep | TX | 1967-01-10 | 1969-01-03 | Republican | 3 | |||||||||||||
29713 | 29713 | William Colmer C000645 | rep | MS | 1967-01-10 | 1969-01-03 | Democrat | 5 | |||||||||||||
32923 | 32923 | Barber Conable C000666 | rep | NY | 1967-01-10 | 1969-01-03 | Republican | 37 | |||||||||||||
34329 | 34329 | Silvio Conte C000709 | rep | MA | 1967-01-10 | 1969-01-03 | Republican | 1 | |||||||||||||
40556 | 40556 | John Conyers C000714 | rep | MI | 1967-01-10 | 1969-01-03 | Democrat | 1 | |||||||||||||
29096 | 29096 | Marlow Cook C000721 | sen | KY | 1968-12-17 | 1969-01-03 | 3 | Republican | |||||||||||||
29729 | 29729 | Robert Corbett C000772 | rep | PA | 1967-01-10 | 1969-01-03 | Republican | 18 | |||||||||||||
32003 | 32003 | James Corman C000780 | rep | CA | 1967-01-10 | 1969-01-03 | Democrat | 22 | |||||||||||||
30883 | 30883 | Norris Cotton C000802 | sen | NH | 1963-01-09 | 1969-01-03 | 3 | Republican | |||||||||||||
29181 | 29181 | William Cowger C000823 | rep | KY | 1967-01-10 | 1969-01-03 | Republican | 3 | |||||||||||||
29189 | 29189 | William Cramer C000869 | rep | FL | 1967-01-10 | 1969-01-03 | Republican | 8 | |||||||||||||
30887 | 30887 | John Culver C000979 | rep | IA | 1967-01-10 | 1969-01-03 | Democrat | 2 | |||||||||||||
29196 | 29196 | Glenn Cunningham C000991 | rep | NE | 1967-01-10 | 1969-01-03 | Republican | 2 | |||||||||||||
28815 | 28815 | Thomas Curtis C001014 | rep | MO | 1967-01-10 | 1969-01-03 | Republican | 2 | |||||||||||||
29202 | 29202 | Emilio Daddario D000001 | rep | CT | 1967-01-10 | 1969-01-03 | Democrat | 1 | |||||||||||||
30896 | 30896 | Dominick Daniels D000041 | rep | NJ | 1967-01-10 | 1969-01-03 | Democrat | 14 | |||||||||||||
30282 | 30282 | Glenn Davis D000102 | rep | WI | 1967-01-10 | 1969-01-03 | Republican | 9 |
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);