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 district
This data as json, copyable, CSV (advanced)
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
29005 | 29005 | Barratt O’Hara O000053 | rep | IL | 1965-01-04 | 1967-01-03 | Democrat | 2 | |||||||||||||
29142 | 29142 | James Battin B000241 | rep | MT | 1965-01-04 | 1967-01-03 | Republican | 2 | |||||||||||||
29156 | 29156 | Ellis Berry B000416 | rep | SD | 1965-01-04 | 1967-01-03 | Republican | 2 | |||||||||||||
29195 | 29195 | Glenn Cunningham C000991 | rep | NE | 1965-01-04 | 1967-01-03 | Republican | 2 | |||||||||||||
29389 | 29389 | Chester Mize M000832 | rep | KS | 1965-01-04 | 1967-01-03 | Republican | 2 | |||||||||||||
29398 | 29398 | Maston O’Neal O000090 | rep | GA | 1965-01-04 | 1967-01-03 | Democrat | 2 | |||||||||||||
29487 | 29487 | William St. Onge S000769 | rep | CT | 1965-01-04 | 1967-01-03 | Democrat | 2 | |||||||||||||
29503 | 29503 | Albert Watson W000197 | rep | SC | 1965-01-04 | 1967-01-03 | Democrat | 2 | |||||||||||||
29619 | 29619 | Thomas Boggs B000594 | rep | LA | 1965-01-04 | 1967-01-03 | Democrat | 2 | |||||||||||||
29763 | 29763 | Edmond Edmondson E000054 | rep | OK | 1965-01-04 | 1967-01-03 | Democrat | 2 | |||||||||||||
30428 | 30428 | James Grover G000504 | rep | NY | 1965-01-04 | 1967-01-03 | Republican | 2 | |||||||||||||
30473 | 30473 | William Hathaway H000346 | rep | ME | 1965-01-04 | 1967-01-03 | Democrat | 2 | |||||||||||||
30603 | 30603 | Ancher Nelsen N000028 | rep | MN | 1965-01-04 | 1967-01-03 | Republican | 2 | |||||||||||||
30870 | 30870 | Donald Clancy C000409 | rep | OH | 1965-01-04 | 1967-01-03 | Republican | 2 | |||||||||||||
30886 | 30886 | John Culver C000979 | rep | IA | 1965-01-04 | 1967-01-03 | Democrat | 2 | |||||||||||||
31194 | 31194 | Wilbur Mills M000778 | rep | AR | 1965-01-04 | 1967-01-03 | Democrat | 2 | |||||||||||||
31659 | 31659 | Lloyd Meeds M000626 | rep | WA | 1965-01-04 | 1967-01-03 | Democrat | 2 | |||||||||||||
31698 | 31698 | Robert Nix N000113 | rep | PA | 1965-01-04 | 1967-01-03 | Democrat | 2 | |||||||||||||
31992 | 31992 | James Cleveland C000512 | rep | NH | 1965-01-04 | 1967-01-03 | Republican | 2 | |||||||||||||
32134 | 32134 | Harold Johnson J000135 | rep | CA | 1965-01-04 | 1967-01-03 | Democrat | 2 | |||||||||||||
32306 | 32306 | Harley Staggers S000778 | rep | WV | 1965-01-04 | 1967-01-03 | Democrat | 2 | |||||||||||||
32359 | 32359 | Albert Ullman U000004 | rep | OR | 1965-01-04 | 1967-01-03 | Democrat | 2 | |||||||||||||
32664 | 32664 | Lawrence Fountain F000319 | rep | NC | 1965-01-04 | 1967-01-03 | Democrat | 2 | |||||||||||||
32985 | 32985 | George Hansen H000171 | rep | ID | 1965-01-04 | 1967-01-03 | Republican | 2 | |||||||||||||
33029 | 33029 | Clarence Long L000413 | rep | MD | 1965-01-04 | 1967-01-03 | Democrat | 2 | |||||||||||||
33500 | 33500 | Edward Boland B000600 | rep | MA | 1965-01-04 | 1967-01-03 | Democrat | 2 | |||||||||||||
33566 | 33566 | John Duncan D000534 | rep | TN | 1965-01-04 | 1967-01-03 | Republican | 2 | |||||||||||||
33961 | 33961 | Robert Kastenmeier K000020 | rep | WI | 1965-01-04 | 1967-01-03 | Democrat | 2 | |||||||||||||
34004 | 34004 | Spark Matsunaga M000250 | rep | HI | 1965-01-04 | 1967-01-03 | Democrat | 2 | |||||||||||||
34241 | 34241 | Charles Bennett B000371 | rep | FL | 1965-01-04 | 1967-01-03 | Democrat | 2 | |||||||||||||
34369 | 34369 | William Dickinson D000326 | rep | AL | 1965-01-04 | 1967-01-03 | Republican | 2 | |||||||||||||
35015 | 35015 | Morris Udall U000001 | rep | AZ | 1965-01-04 | 1967-01-03 | Democrat | 2 | |||||||||||||
35141 | 35141 | Jack Brooks B000880 | rep | TX | 1965-01-04 | 1967-01-03 | Democrat | 2 | |||||||||||||
35463 | 35463 | William Natcher N000009 | rep | KY | 1965-01-04 | 1967-01-03 | Democrat | 2 | |||||||||||||
35654 | 35654 | Jamie Whitten W000428 | rep | MS | 1965-01-04 | 1967-01-03 | Democrat | 2 | |||||||||||||
28328 | 28328 | Lindley Beckworth B000296 | rep | TX | 1965-01-04 | 1967-01-03 | Democrat | 3 | |||||||||||||
28358 | 28358 | Howard Callaway C000055 | rep | GA | 1965-01-04 | 1967-01-03 | Republican | 3 | |||||||||||||
28421 | 28421 | Robert Ellsworth E000148 | rep | KS | 1965-01-04 | 1967-01-03 | Republican | 3 | |||||||||||||
28422 | 28422 | Charles Farnsley F000023 | rep | KY | 1965-01-04 | 1967-01-03 | Democrat | 3 | |||||||||||||
28525 | 28525 | Rodney Love L000458 | rep | OH | 1965-01-04 | 1967-01-03 | Democrat | 3 | |||||||||||||
28654 | 28654 | George Senner S000243 | rep | AZ | 1965-01-04 | 1967-01-03 | Democrat | 3 | |||||||||||||
28711 | 28711 | Paul Todd T000294 | rep | MI | 1965-01-04 | 1967-01-03 | Democrat | 3 | |||||||||||||
28726 | 28726 | James Trimble T000373 | rep | AR | 1965-01-04 | 1967-01-03 | Democrat | 3 | |||||||||||||
29076 | 29076 | John Williams W000517 | rep | MS | 1965-01-04 | 1967-01-03 | Democrat | 3 | |||||||||||||
29086 | 29086 | Edwin Willis W000559 | rep | LA | 1965-01-04 | 1967-01-03 | Democrat | 3 | |||||||||||||
29348 | 29348 | Clark MacGregor M000010 | rep | MN | 1965-01-04 | 1967-01-03 | Republican | 3 | |||||||||||||
29395 | 29395 | William Murphy M001104 | rep | IL | 1965-01-04 | 1967-01-03 | Democrat | 3 | |||||||||||||
29417 | 29417 | Philip Philbin P000303 | rep | MA | 1965-01-04 | 1967-01-03 | Democrat | 3 | |||||||||||||
29555 | 29555 | George Andrews A000206 | rep | AL | 1965-01-04 | 1967-01-03 | Democrat | 3 | |||||||||||||
29635 | 29635 | William Brock B000851 | rep | TN | 1965-01-04 | 1967-01-03 | Republican | 3 | |||||||||||||
29646 | 29646 | James Byrne B001212 | rep | PA | 1965-01-04 | 1967-01-03 | Democrat | 3 | |||||||||||||
29810 | 29810 | Edward Garmatz G000071 | rep | MD | 1965-01-04 | 1967-01-03 | Democrat | 3 | |||||||||||||
30324 | 30324 | William Dorn D000434 | rep | SC | 1965-01-04 | 1967-01-03 | Democrat | 3 | |||||||||||||
30391 | 30391 | Edith Green G000407 | rep | OR | 1965-01-04 | 1967-01-03 | Democrat | 3 | |||||||||||||
30422 | 30422 | Harold Gross G000495 | rep | IA | 1965-01-04 | 1967-01-03 | Republican | 3 | |||||||||||||
30457 | 30457 | Julia Hansen H000174 | rep | WA | 1965-01-04 | 1967-01-03 | Democrat | 3 | |||||||||||||
30550 | 30550 | David Martin M000175 | rep | NE | 1965-01-04 | 1967-01-03 | Republican | 3 | |||||||||||||
30728 | 30728 | Vernon Thomson T000233 | rep | WI | 1965-01-04 | 1967-01-03 | Republican | 3 | |||||||||||||
30812 | 30812 | Carl Albert A000073 | rep | OK | 1965-01-04 | 1967-01-03 | Democrat | 3 | |||||||||||||
31006 | 31006 | David Henderson H000479 | rep | NC | 1965-01-04 | 1967-01-03 | Democrat | 3 | |||||||||||||
31364 | 31364 | Leonor Sullivan S001057 | rep | MO | 1965-01-04 | 1967-01-03 | Democrat | 3 | |||||||||||||
31544 | 31544 | Frank Evans E000240 | rep | CO | 1965-01-04 | 1967-01-03 | Democrat | 3 | |||||||||||||
31681 | 31681 | John Moss M001035 | rep | CA | 1965-01-04 | 1967-01-03 | Democrat | 3 | |||||||||||||
31959 | 31959 | John Brademas B000736 | rep | IN | 1965-01-04 | 1967-01-03 | Democrat | 3 | |||||||||||||
32079 | 32079 | Robert Giaimo G000151 | rep | CT | 1965-01-04 | 1967-01-03 | Democrat | 3 | |||||||||||||
32269 | 32269 | David Satterfield S000070 | rep | VA | 1965-01-04 | 1967-01-03 | Democrat | 3 | |||||||||||||
32286 | 32286 | John Slack S000473 | rep | WV | 1965-01-04 | 1967-01-03 | Democrat | 3 | |||||||||||||
32412 | 32412 | Lester Wolff W000680 | rep | NY | 1965-01-04 | 1967-01-03 | Democrat | 3 | |||||||||||||
33600 | 33600 | James Howard H000840 | rep | NJ | 1965-01-04 | 1967-01-03 | Democrat | 3 | |||||||||||||
34050 | 34050 | Claude Pepper P000218 | rep | FL | 1965-01-04 | 1967-01-03 | Democrat | 3 | |||||||||||||
28309 | 28309 | Arthur Andrews A000204 | rep | AL | 1965-01-04 | 1967-01-03 | Republican | 4 | |||||||||||||
28316 | 28316 | Bert Bandstra B000108 | rep | IA | 1965-01-04 | 1967-01-03 | Democrat | 4 | |||||||||||||
28371 | 28371 | Frank Chelf C000342 | rep | KY | 1965-01-04 | 1967-01-03 | Democrat | 4 | |||||||||||||
28389 | 28389 | Harold Cooley C000736 | rep | NC | 1965-01-04 | 1967-01-03 | Democrat | 4 | |||||||||||||
28459 | 28459 | Oren Harris H000249 | rep | AR | 1965-01-04 | 1967-01-03 | Democrat | 4 | |||||||||||||
28526 | 28526 | James MacKay M000022 | rep | GA | 1965-01-04 | 1967-01-03 | Democrat | 4 | |||||||||||||
28715 | 28715 | Herman Toll T000297 | rep | PA | 1965-01-04 | 1967-01-03 | Democrat | 4 | |||||||||||||
28734 | 28734 | Prentiss Walker W000065 | rep | MS | 1965-01-04 | 1967-01-03 | Republican | 4 | |||||||||||||
28770 | 28770 | Robert Ashmore A000223 | rep | SC | 1965-01-04 | 1967-01-03 | Democrat | 4 | |||||||||||||
28914 | 28914 | Donald Irwin I000039 | rep | CT | 1965-01-04 | 1967-01-03 | Democrat | 4 | |||||||||||||
29110 | 29110 | Edwin Adair A000024 | rep | IN | 1965-01-04 | 1967-01-03 | Republican | 4 | |||||||||||||
29245 | 29245 | George Fallon F000012 | rep | MD | 1965-01-04 | 1967-01-03 | Democrat | 4 | |||||||||||||
29358 | 29358 | Catherine May M000273 | rep | WA | 1965-01-04 | 1967-01-03 | Republican | 4 | |||||||||||||
29520 | 29520 | Watkins Abbitt A000002 | rep | VA | 1965-01-04 | 1967-01-03 | Democrat | 4 | |||||||||||||
29567 | 29567 | Wayne Aspinall A000225 | rep | CO | 1965-01-04 | 1967-01-03 | Democrat | 4 | |||||||||||||
29920 | 29920 | William McCulloch M000393 | rep | OH | 1965-01-04 | 1967-01-03 | Republican | 4 | |||||||||||||
30311 | 30311 | Harold Donohue D000419 | rep | MA | 1965-01-04 | 1967-01-03 | Democrat | 4 | |||||||||||||
30930 | 30930 | Joseph Evins E000273 | rep | TN | 1965-01-04 | 1967-01-03 | Democrat | 4 | |||||||||||||
30992 | 30992 | Kenneth Hechler H000438 | rep | WV | 1965-01-04 | 1967-01-03 | Democrat | 4 | |||||||||||||
31029 | 31029 | J. Hutchinson H001011 | rep | MI | 1965-01-04 | 1967-01-03 | Republican | 4 | |||||||||||||
31099 | 31099 | Joseph Karth K000014 | rep | MN | 1965-01-04 | 1967-01-03 | Democrat | 4 | |||||||||||||
31284 | 31284 | William Randall R000041 | rep | MO | 1965-01-04 | 1967-01-03 | Democrat | 4 | |||||||||||||
31326 | 31326 | Garner Shriver S000388 | rep | KS | 1965-01-04 | 1967-01-03 | Republican | 4 | |||||||||||||
31614 | 31614 | Robert Leggett L000221 | rep | CA | 1965-01-04 | 1967-01-03 | Democrat | 4 | |||||||||||||
31871 | 31871 | Joseph Waggonner W000018 | rep | LA | 1965-01-04 | 1967-01-03 | Democrat | 4 | |||||||||||||
32045 | 32045 | Robert Duncan D000537 | rep | OR | 1965-01-04 | 1967-01-03 | Democrat | 4 | |||||||||||||
32255 | 32255 | Herbert Roberts R000312 | rep | TX | 1965-01-04 | 1967-01-03 | Democrat | 4 | |||||||||||||
32322 | 32322 | Thomas Steed S000829 | rep | OK | 1965-01-04 | 1967-01-03 | Democrat | 4 | |||||||||||||
32336 | 32336 | Frank Thompson T000200 | rep | NJ | 1965-01-04 | 1967-01-03 | Democrat | 4 | |||||||||||||
32422 | 32422 | John Wydler W000780 | rep | NY | 1965-01-04 | 1967-01-03 | Republican | 4 |
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);