legislator_terms
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
479 rows where "end" is on date 1967-01-03 sorted by legislator_id
This data as json, copyable, CSV (advanced)
Suggested facets: class
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
29520 | 29520 | Watkins Abbitt A000002 | rep | VA | 1965-01-04 | 1967-01-03 | Democrat | 4 | |||||||||||||
29535 | 29535 | Thomas Abernethy A000016 | rep | MS | 1965-01-04 | 1967-01-03 | Democrat | 1 | |||||||||||||
29110 | 29110 | Edwin Adair A000024 | rep | IN | 1965-01-04 | 1967-01-03 | Republican | 4 | |||||||||||||
33470 | 33470 | Brockman Adams A000031 | rep | WA | 1965-01-04 | 1967-01-03 | Democrat | 7 | |||||||||||||
33214 | 33214 | Joseph Addabbo A000052 | rep | NY | 1965-01-04 | 1967-01-03 | Democrat | 7 | |||||||||||||
30812 | 30812 | Carl Albert A000073 | rep | OK | 1965-01-04 | 1967-01-03 | Democrat | 3 | |||||||||||||
28755 | 28755 | Gordon Allott A000161 | sen | CO | 1961-01-03 | 1967-01-03 | 2 | Republican | |||||||||||||
28762 | 28762 | Clinton Anderson A000186 | sen | NM | 1961-01-03 | 1967-01-03 | 2 | Democrat | |||||||||||||
31922 | 31922 | John Anderson A000195 | rep | IL | 1965-01-04 | 1967-01-03 | Republican | 16 | |||||||||||||
29539 | 29539 | William Anderson A000203 | rep | TN | 1965-01-04 | 1967-01-03 | Democrat | 6 | |||||||||||||
28309 | 28309 | Arthur Andrews A000204 | rep | AL | 1965-01-04 | 1967-01-03 | Republican | 4 | |||||||||||||
29555 | 29555 | George Andrews A000206 | rep | AL | 1965-01-04 | 1967-01-03 | Democrat | 3 | |||||||||||||
32436 | 32436 | Mark Andrews A000208 | rep | ND | 1965-01-04 | 1967-01-03 | Republican | 1 | |||||||||||||
34186 | 34186 | Frank Annunzio A000212 | rep | IL | 1965-01-04 | 1967-01-03 | Democrat | 7 | |||||||||||||
30153 | 30153 | Leslie Arends A000216 | rep | IL | 1965-01-04 | 1967-01-03 | Republican | 17 | |||||||||||||
32448 | 32448 | John Ashbrook A000221 | rep | OH | 1965-01-04 | 1967-01-03 | Republican | 17 | |||||||||||||
31935 | 31935 | Thomas Ashley A000222 | rep | OH | 1965-01-04 | 1967-01-03 | Democrat | 9 | |||||||||||||
28770 | 28770 | Robert Ashmore A000223 | rep | SC | 1965-01-04 | 1967-01-03 | Democrat | 4 | |||||||||||||
29567 | 29567 | Wayne Aspinall A000225 | rep | CO | 1965-01-04 | 1967-01-03 | Democrat | 4 | |||||||||||||
29126 | 29126 | William Ayres A000229 | rep | OH | 1965-01-04 | 1967-01-03 | Republican | 14 | |||||||||||||
28315 | 28315 | John Baldwin B000092 | rep | CA | 1965-01-04 | 1967-01-03 | Republican | 14 | |||||||||||||
28316 | 28316 | Bert Bandstra B000108 | rep | IA | 1965-01-04 | 1967-01-03 | Democrat | 4 | |||||||||||||
29577 | 29577 | Walter Baring B000141 | rep | NV | 1965-01-04 | 1967-01-03 | Democrat | 0 | |||||||||||||
30829 | 30829 | William Barrett B000178 | rep | PA | 1965-01-04 | 1967-01-03 | Democrat | 1 | |||||||||||||
28780 | 28780 | Edward Bartlett B000201 | sen | AK | 1961-01-03 | 1967-01-03 | 2 | Democrat | |||||||||||||
28307 | 28307 | Ross Bass B000223 | sen | TN | 1964-11-04 | 1967-01-03 | 2 | Democrat | |||||||||||||
29137 | 29137 | William Bates B000239 | rep | MA | 1965-01-04 | 1967-01-03 | Republican | 6 | |||||||||||||
29142 | 29142 | James Battin B000241 | rep | MT | 1965-01-04 | 1967-01-03 | Republican | 2 | |||||||||||||
28328 | 28328 | Lindley Beckworth B000296 | rep | TX | 1965-01-04 | 1967-01-03 | Democrat | 3 | |||||||||||||
29591 | 29591 | Page Belcher B000323 | rep | OK | 1965-01-04 | 1967-01-03 | Republican | 1 | |||||||||||||
30840 | 30840 | Alphonzo Bell B000330 | rep | CA | 1965-01-04 | 1967-01-03 | Republican | 28 | |||||||||||||
34241 | 34241 | Charles Bennett B000371 | rep | FL | 1965-01-04 | 1967-01-03 | Democrat | 2 | |||||||||||||
29156 | 29156 | Ellis Berry B000416 | rep | SD | 1965-01-04 | 1967-01-03 | Republican | 2 | |||||||||||||
29602 | 29602 | Jackson Betts B000426 | rep | OH | 1965-01-04 | 1967-01-03 | Republican | 8 | |||||||||||||
32476 | 32476 | Jonathan Bingham B000472 | rep | NY | 1965-01-04 | 1967-01-03 | Democrat | 23 | |||||||||||||
30174 | 30174 | John Blatnik B000550 | rep | MN | 1965-01-04 | 1967-01-03 | Democrat | 8 | |||||||||||||
28785 | 28785 | James Boggs B000593 | sen | DE | 1961-01-03 | 1967-01-03 | 2 | Republican | |||||||||||||
29619 | 29619 | Thomas Boggs B000594 | rep | LA | 1965-01-04 | 1967-01-03 | Democrat | 2 | |||||||||||||
33500 | 33500 | Edward Boland B000600 | rep | MA | 1965-01-04 | 1967-01-03 | Democrat | 2 | |||||||||||||
32497 | 32497 | Richard Bolling B000605 | rep | MO | 1965-01-04 | 1967-01-03 | Democrat | 5 | |||||||||||||
28800 | 28800 | Frances Bolton B000607 | rep | OH | 1965-01-04 | 1967-01-03 | Republican | 22 | |||||||||||||
28342 | 28342 | Herbert Bonner B000621 | rep | NC | 1965-01-04 | 1967-01-03 | Democrat | 1 | |||||||||||||
29630 | 29630 | Frank Bow B000676 | rep | OH | 1965-01-04 | 1967-01-03 | Republican | 16 | |||||||||||||
31959 | 31959 | John Brademas B000736 | rep | IN | 1965-01-04 | 1967-01-03 | Democrat | 3 | |||||||||||||
30190 | 30190 | William Bray B000778 | rep | IN | 1965-01-04 | 1967-01-03 | Republican | 7 | |||||||||||||
29635 | 29635 | William Brock B000851 | rep | TN | 1965-01-04 | 1967-01-03 | Republican | 3 | |||||||||||||
35141 | 35141 | Jack Brooks B000880 | rep | TX | 1965-01-04 | 1967-01-03 | Democrat | 2 | |||||||||||||
34269 | 34269 | William Broomfield B000890 | rep | MI | 1965-01-04 | 1967-01-03 | Republican | 18 | |||||||||||||
28356 | 28356 | Clarence Brown B000909 | rep | OH | 1965-01-04 | 1967-01-03 | Republican | 7 | |||||||||||||
32523 | 32523 | Clarence Brown B000910 | rep | OH | 1965-01-04 | 1967-01-03 | Republican | 7 | |||||||||||||
36523 | 36523 | George Brown B000918 | rep | CA | 1965-01-04 | 1967-01-03 | Democrat | 29 | |||||||||||||
33458 | 33458 | James Broyhill B000966 | rep | NC | 1965-01-04 | 1967-01-03 | Republican | 9 | |||||||||||||
30208 | 30208 | Joel Broyhill B000967 | rep | VA | 1965-01-04 | 1967-01-03 | Republican | 10 | |||||||||||||
31967 | 31967 | John Buchanan B001008 | rep | AL | 1965-01-04 | 1967-01-03 | Republican | 6 | |||||||||||||
31443 | 31443 | James Burke B001092 | rep | MA | 1965-01-04 | 1967-01-03 | Democrat | 11 | |||||||||||||
31462 | 31462 | Omar Burleson B001111 | rep | TX | 1965-01-04 | 1967-01-03 | Democrat | 17 | |||||||||||||
29164 | 29164 | Laurence Burton B001155 | rep | UT | 1965-01-04 | 1967-01-03 | Republican | 1 | |||||||||||||
32909 | 32909 | Phillip Burton B001156 | rep | CA | 1965-01-04 | 1967-01-03 | Democrat | 5 | |||||||||||||
29646 | 29646 | James Byrne B001212 | rep | PA | 1965-01-04 | 1967-01-03 | Democrat | 3 | |||||||||||||
29660 | 29660 | John Byrnes B001216 | rep | WI | 1965-01-04 | 1967-01-03 | Republican | 8 | |||||||||||||
29664 | 29664 | Earle Cabell C000002 | rep | TX | 1965-01-04 | 1967-01-03 | Democrat | 5 | |||||||||||||
29172 | 29172 | William Cahill C000019 | rep | NJ | 1965-01-04 | 1967-01-03 | Republican | 1 | |||||||||||||
28357 | 28357 | Clair Callan C000054 | rep | NE | 1965-01-04 | 1967-01-03 | Democrat | 1 | |||||||||||||
28358 | 28358 | Howard Callaway C000055 | rep | GA | 1965-01-04 | 1967-01-03 | Republican | 3 | |||||||||||||
28360 | 28360 | Ronald Cameron C000067 | rep | CA | 1965-01-04 | 1967-01-03 | Democrat | 25 | |||||||||||||
30218 | 30218 | Hugh Carey C000143 | rep | NY | 1965-01-04 | 1967-01-03 | Democrat | 15 | |||||||||||||
31981 | 31981 | Tim Carter C000201 | rep | KY | 1965-01-04 | 1967-01-03 | Republican | 5 | |||||||||||||
30229 | 30229 | Clifford Case C000220 | sen | NJ | 1961-01-03 | 1967-01-03 | 2 | Republican | |||||||||||||
30858 | 30858 | Robert Casey C000228 | rep | TX | 1965-01-04 | 1967-01-03 | Democrat | 22 | |||||||||||||
31492 | 31492 | Elford Cederberg C000263 | rep | MI | 1965-01-04 | 1967-01-03 | Republican | 10 | |||||||||||||
29692 | 29692 | Emanuel Celler C000264 | rep | NY | 1965-01-04 | 1967-01-03 | Democrat | 10 | |||||||||||||
30236 | 30236 | Charles Chamberlain C000275 | rep | MI | 1965-01-04 | 1967-01-03 | Republican | 6 | |||||||||||||
28371 | 28371 | Frank Chelf C000342 | rep | KY | 1965-01-04 | 1967-01-03 | Democrat | 4 | |||||||||||||
30870 | 30870 | Donald Clancy C000409 | rep | OH | 1965-01-04 | 1967-01-03 | Republican | 2 | |||||||||||||
30246 | 30246 | Frank Clark C000431 | rep | PA | 1965-01-04 | 1967-01-03 | Democrat | 25 | |||||||||||||
32557 | 32557 | Donald Clausen C000475 | rep | CA | 1965-01-04 | 1967-01-03 | Republican | 1 | |||||||||||||
31500 | 31500 | Delwin Clawson C000476 | rep | CA | 1965-01-04 | 1967-01-03 | Republican | 23 | |||||||||||||
31992 | 31992 | James Cleveland C000512 | rep | NH | 1965-01-04 | 1967-01-03 | Republican | 2 | |||||||||||||
28372 | 28372 | Raymond Clevenger C000516 | rep | MI | 1965-01-04 | 1967-01-03 | Democrat | 11 | |||||||||||||
29178 | 29178 | Jeffery Cohelan C000596 | rep | CA | 1965-01-04 | 1967-01-03 | Democrat | 7 | |||||||||||||
30256 | 30256 | Harold Collier C000629 | rep | IL | 1965-01-04 | 1967-01-03 | Republican | 10 | |||||||||||||
29712 | 29712 | William Colmer C000645 | rep | MS | 1965-01-04 | 1967-01-03 | Democrat | 5 | |||||||||||||
32922 | 32922 | Barber Conable C000666 | rep | NY | 1965-01-04 | 1967-01-03 | Republican | 37 | |||||||||||||
34328 | 34328 | Silvio Conte C000709 | rep | MA | 1965-01-04 | 1967-01-03 | Republican | 1 | |||||||||||||
40555 | 40555 | John Conyers C000714 | rep | MI | 1965-01-04 | 1967-01-03 | Democrat | 1 | |||||||||||||
28389 | 28389 | Harold Cooley C000736 | rep | NC | 1965-01-04 | 1967-01-03 | Democrat | 4 | |||||||||||||
28805 | 28805 | John Cooper C000758 | sen | KY | 1961-01-03 | 1967-01-03 | 2 | Republican | |||||||||||||
29728 | 29728 | Robert Corbett C000772 | rep | PA | 1965-01-04 | 1967-01-03 | Republican | 18 | |||||||||||||
32002 | 32002 | James Corman C000780 | rep | CA | 1965-01-04 | 1967-01-03 | Democrat | 22 | |||||||||||||
28390 | 28390 | Nathaniel Craley C000866 | rep | PA | 1965-01-04 | 1967-01-03 | Democrat | 19 | |||||||||||||
29188 | 29188 | William Cramer C000869 | rep | FL | 1965-01-04 | 1967-01-03 | Republican | 12 | |||||||||||||
30886 | 30886 | John Culver C000979 | rep | IA | 1965-01-04 | 1967-01-03 | Democrat | 2 | |||||||||||||
29195 | 29195 | Glenn Cunningham C000991 | rep | NE | 1965-01-04 | 1967-01-03 | Republican | 2 | |||||||||||||
28395 | 28395 | Willard Curtin C001005 | rep | PA | 1965-01-04 | 1967-01-03 | Republican | 8 | |||||||||||||
30273 | 30273 | Carl Curtis C001006 | sen | NE | 1961-01-03 | 1967-01-03 | 2 | Republican | |||||||||||||
28814 | 28814 | Thomas Curtis C001014 | rep | MO | 1965-01-04 | 1967-01-03 | Republican | 2 | |||||||||||||
29201 | 29201 | Emilio Daddario D000001 | rep | CT | 1965-01-04 | 1967-01-03 | Democrat | 1 | |||||||||||||
28405 | 28405 | Paul Dague D000004 | rep | PA | 1965-01-04 | 1967-01-03 | Republican | 9 | |||||||||||||
30895 | 30895 | Dominick Daniels D000041 | rep | NJ | 1965-01-04 | 1967-01-03 | Democrat | 14 | |||||||||||||
30281 | 30281 | Glenn Davis D000102 | rep | WI | 1965-01-04 | 1967-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);