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 rowid descending
This data as json, copyable, CSV (advanced)
Suggested facets: type, start, 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
40555 | 40555 | John Conyers C000714 | rep | MI | 1965-01-04 | 1967-01-03 | Democrat | 1 | |||||||||||||
39804 | 39804 | John Dingell D000355 | rep | MI | 1965-01-04 | 1967-01-03 | Democrat | 16 | |||||||||||||
37027 | 37027 | Patsy Mink M000797 | rep | HI | 1965-01-04 | 1967-01-03 | Democrat | 1 | |||||||||||||
36523 | 36523 | George Brown B000918 | rep | CA | 1965-01-04 | 1967-01-03 | Democrat | 29 | |||||||||||||
36455 | 36455 | Sidney Yates Y000013 | rep | IL | 1965-01-04 | 1967-01-03 | Democrat | 9 | |||||||||||||
36421 | 36421 | J. Thurmond T000254 | sen | SC | 1961-01-03 | 1967-01-03 | 2 | Republican | [ { "start": "1961-01-03", "end": "1964-09-16", "party": "Democrat" }, { "start": "1964-09-16", "end": "1967-01-03", "party": "Republican" } ] |
||||||||||||
36296 | 36296 | Joseph McDade M000399 | rep | PA | 1965-01-04 | 1967-01-03 | Republican | 10 | |||||||||||||
36228 | 36228 | Lee Hamilton H000114 | rep | IN | 1965-01-04 | 1967-01-03 | Democrat | 9 | |||||||||||||
36205 | 36205 | Henry González G000272 | rep | TX | 1965-01-04 | 1967-01-03 | Democrat | 20 | |||||||||||||
36116 | 36116 | Eligio de la Garza D000203 | rep | TX | 1965-01-04 | 1967-01-03 | Democrat | 15 | |||||||||||||
35976 | 35976 | James Quillen Q000013 | rep | TN | 1965-01-04 | 1967-01-03 | Republican | 1 | |||||||||||||
35863 | 35863 | Andrew Jacobs J000033 | rep | IN | 1965-01-04 | 1967-01-03 | Democrat | 11 | |||||||||||||
35822 | 35822 | Sam Gibbons G000153 | rep | FL | 1965-01-04 | 1967-01-03 | Democrat | 10 | |||||||||||||
35654 | 35654 | Jamie Whitten W000428 | rep | MS | 1965-01-04 | 1967-01-03 | Democrat | 2 | |||||||||||||
35585 | 35585 | Neal Smith S000596 | rep | IA | 1965-01-04 | 1967-01-03 | Democrat | 5 | |||||||||||||
35537 | 35537 | Daniel Rostenkowski R000458 | rep | IL | 1965-01-04 | 1967-01-03 | Democrat | 8 | |||||||||||||
35509 | 35509 | James Pickle P000328 | rep | TX | 1965-01-04 | 1967-01-03 | Democrat | 10 | |||||||||||||
35463 | 35463 | William Natcher N000009 | rep | KY | 1965-01-04 | 1967-01-03 | Democrat | 2 | |||||||||||||
35432 | 35432 | Robert Michel M000692 | rep | IL | 1965-01-04 | 1967-01-03 | Republican | 18 | |||||||||||||
35265 | 35265 | William Ford F000270 | rep | MI | 1965-01-04 | 1967-01-03 | Democrat | 15 | |||||||||||||
35245 | 35245 | Thomas Foley F000239 | rep | WA | 1965-01-04 | 1967-01-03 | Democrat | 5 | |||||||||||||
35200 | 35200 | William Edwards E000064 | rep | CA | 1965-01-04 | 1967-01-03 | Democrat | 9 | |||||||||||||
35192 | 35192 | Robert Dole D000401 | rep | KS | 1965-01-04 | 1967-01-03 | Republican | 1 | |||||||||||||
35141 | 35141 | Jack Brooks B000880 | rep | TX | 1965-01-04 | 1967-01-03 | Democrat | 2 | |||||||||||||
35029 | 35029 | Guy Vander Jagt V000027 | rep | MI | 1965-01-04 | 1967-01-03 | Republican | 9 | |||||||||||||
35015 | 35015 | Morris Udall U000001 | rep | AZ | 1965-01-04 | 1967-01-03 | Democrat | 2 | |||||||||||||
34928 | 34928 | James Scheuer S000124 | rep | NY | 1965-01-04 | 1967-01-03 | Democrat | 21 | |||||||||||||
34899 | 34899 | Edward Roybal R000485 | rep | CA | 1965-01-04 | 1967-01-03 | Democrat | 30 | |||||||||||||
34846 | 34846 | David Pryor P000556 | rep | AR | 1965-01-04 | 1967-01-03 | Democrat | 4 | |||||||||||||
34830 | 34830 | Claiborne Pell P000193 | sen | RI | 1961-01-03 | 1967-01-03 | 2 | Democrat | |||||||||||||
34620 | 34620 | Walter Jones J000256 | rep | NC | 1965-01-04 | 1967-01-03 | Democrat | 1 | |||||||||||||
34564 | 34564 | Frank Horton H000797 | rep | NY | 1965-01-04 | 1967-01-03 | Republican | 36 | |||||||||||||
34447 | 34447 | Dante Fascell F000041 | rep | FL | 1965-01-04 | 1967-01-03 | Democrat | 4 | |||||||||||||
34369 | 34369 | William Dickinson D000326 | rep | AL | 1965-01-04 | 1967-01-03 | Republican | 2 | |||||||||||||
34328 | 34328 | Silvio Conte C000709 | rep | MA | 1965-01-04 | 1967-01-03 | Republican | 1 | |||||||||||||
34269 | 34269 | William Broomfield B000890 | rep | MI | 1965-01-04 | 1967-01-03 | Republican | 18 | |||||||||||||
34241 | 34241 | Charles Bennett B000371 | rep | FL | 1965-01-04 | 1967-01-03 | Democrat | 2 | |||||||||||||
34186 | 34186 | Frank Annunzio A000212 | rep | IL | 1965-01-04 | 1967-01-03 | Democrat | 7 | |||||||||||||
34147 | 34147 | James Wright W000763 | rep | TX | 1965-01-04 | 1967-01-03 | Democrat | 12 | |||||||||||||
34050 | 34050 | Claude Pepper P000218 | rep | FL | 1965-01-04 | 1967-01-03 | Democrat | 3 | |||||||||||||
34004 | 34004 | Spark Matsunaga M000250 | rep | HI | 1965-01-04 | 1967-01-03 | Democrat | 2 | |||||||||||||
33961 | 33961 | Robert Kastenmeier K000020 | rep | WI | 1965-01-04 | 1967-01-03 | Democrat | 2 | |||||||||||||
33934 | 33934 | Augustus Hawkins H000367 | rep | CA | 1965-01-04 | 1967-01-03 | Democrat | 21 | |||||||||||||
33765 | 33765 | Samuel Stratton S000997 | rep | NY | 1965-01-04 | 1967-01-03 | Democrat | 35 | |||||||||||||
33750 | 33750 | Fernand St. Germain S000762 | rep | RI | 1965-01-04 | 1967-01-03 | Democrat | 1 | |||||||||||||
33729 | 33729 | Peter Rodino R000374 | rep | NJ | 1965-01-04 | 1967-01-03 | Democrat | 10 | |||||||||||||
33705 | 33705 | Charles Price P000522 | rep | IL | 1965-01-04 | 1967-01-03 | Democrat | 24 | |||||||||||||
33640 | 33640 | Delbert Latta L000116 | rep | OH | 1965-01-04 | 1967-01-03 | Republican | 5 | |||||||||||||
33600 | 33600 | James Howard H000840 | rep | NJ | 1965-01-04 | 1967-01-03 | Democrat | 3 | |||||||||||||
33593 | 33593 | Kenneth Gray G000400 | rep | IL | 1965-01-04 | 1967-01-03 | Democrat | 21 | |||||||||||||
33566 | 33566 | John Duncan D000534 | rep | TN | 1965-01-04 | 1967-01-03 | Republican | 2 | |||||||||||||
33500 | 33500 | Edward Boland B000600 | rep | MA | 1965-01-04 | 1967-01-03 | Democrat | 2 | |||||||||||||
33470 | 33470 | Brockman Adams A000031 | rep | WA | 1965-01-04 | 1967-01-03 | Democrat | 7 | |||||||||||||
33458 | 33458 | James Broyhill B000966 | rep | NC | 1965-01-04 | 1967-01-03 | Republican | 9 | |||||||||||||
33388 | 33388 | Thomas O’Neill O000098 | rep | MA | 1965-01-04 | 1967-01-03 | Democrat | 8 | |||||||||||||
33271 | 33271 | Don Fuqua F000430 | rep | FL | 1965-01-04 | 1967-01-03 | Democrat | 9 | |||||||||||||
33214 | 33214 | Joseph Addabbo A000052 | rep | NY | 1965-01-04 | 1967-01-03 | Democrat | 7 | |||||||||||||
33199 | 33199 | Clement Zablocki Z000001 | rep | WI | 1965-01-04 | 1967-01-03 | Democrat | 4 | |||||||||||||
33148 | 33148 | Robert Stafford S000776 | rep | VT | 1965-01-04 | 1967-01-03 | Republican | 0 | |||||||||||||
33129 | 33129 | Benjamin Rosenthal R000442 | rep | NY | 1965-01-04 | 1967-01-03 | Democrat | 8 | |||||||||||||
33095 | 33095 | Carl Perkins P000230 | rep | KY | 1965-01-04 | 1967-01-03 | Democrat | 7 | |||||||||||||
33072 | 33072 | Richard Ottinger O000134 | rep | NY | 1965-01-04 | 1967-01-03 | Democrat | 25 | |||||||||||||
33062 | 33062 | Joseph Minish M000796 | rep | NJ | 1965-01-04 | 1967-01-03 | Democrat | 11 | |||||||||||||
33029 | 33029 | Clarence Long L000413 | rep | MD | 1965-01-04 | 1967-01-03 | Democrat | 2 | |||||||||||||
32985 | 32985 | George Hansen H000171 | rep | ID | 1965-01-04 | 1967-01-03 | Republican | 2 | |||||||||||||
32958 | 32958 | John Erlenborn E000204 | rep | IL | 1965-01-04 | 1967-01-03 | Republican | 14 | |||||||||||||
32948 | 32948 | William Edwards E000084 | rep | AL | 1965-01-04 | 1967-01-03 | Republican | 1 | |||||||||||||
32922 | 32922 | Barber Conable C000666 | rep | NY | 1965-01-04 | 1967-01-03 | Republican | 37 | |||||||||||||
32909 | 32909 | Phillip Burton B001156 | rep | CA | 1965-01-04 | 1967-01-03 | Democrat | 5 | |||||||||||||
32881 | 32881 | Richard White W000390 | rep | TX | 1965-01-04 | 1967-01-03 | Democrat | 16 | |||||||||||||
32858 | 32858 | John Stanton S000804 | rep | OH | 1965-01-04 | 1967-01-03 | Republican | 11 | |||||||||||||
32829 | 32829 | John Rhodes R000188 | rep | AZ | 1965-01-04 | 1967-01-03 | Republican | 1 | |||||||||||||
32814 | 32814 | Henry Reuss R000165 | rep | WI | 1965-01-04 | 1967-01-03 | Democrat | 5 | |||||||||||||
32755 | 32755 | Robert McClory M000340 | rep | IL | 1965-01-04 | 1967-01-03 | Republican | 12 | |||||||||||||
32745 | 32745 | Charles Mathias M000241 | rep | MD | 1965-01-04 | 1967-01-03 | Republican | 6 | |||||||||||||
32664 | 32664 | Lawrence Fountain F000319 | rep | NC | 1965-01-04 | 1967-01-03 | Democrat | 2 | |||||||||||||
32645 | 32645 | Paul Findley F000123 | rep | IL | 1965-01-04 | 1967-01-03 | Republican | 20 | |||||||||||||
32599 | 32599 | Edward Derwinski D000269 | rep | IL | 1965-01-04 | 1967-01-03 | Republican | 4 | |||||||||||||
32557 | 32557 | Donald Clausen C000475 | rep | CA | 1965-01-04 | 1967-01-03 | Republican | 1 | |||||||||||||
32523 | 32523 | Clarence Brown B000910 | rep | OH | 1965-01-04 | 1967-01-03 | Republican | 7 | |||||||||||||
32497 | 32497 | Richard Bolling B000605 | rep | MO | 1965-01-04 | 1967-01-03 | Democrat | 5 | |||||||||||||
32476 | 32476 | Jonathan Bingham B000472 | rep | NY | 1965-01-04 | 1967-01-03 | Democrat | 23 | |||||||||||||
32448 | 32448 | John Ashbrook A000221 | rep | OH | 1965-01-04 | 1967-01-03 | Republican | 17 | |||||||||||||
32436 | 32436 | Mark Andrews A000208 | rep | ND | 1965-01-04 | 1967-01-03 | Republican | 1 | |||||||||||||
32422 | 32422 | John Wydler W000780 | rep | NY | 1965-01-04 | 1967-01-03 | Republican | 4 | |||||||||||||
32412 | 32412 | Lester Wolff W000680 | rep | NY | 1965-01-04 | 1967-01-03 | Democrat | 3 | |||||||||||||
32404 | 32404 | Robert Wilson W000610 | rep | CA | 1965-01-04 | 1967-01-03 | Republican | 36 | |||||||||||||
32390 | 32390 | Charles Wilson W000571 | rep | CA | 1965-01-04 | 1967-01-03 | Democrat | 31 | |||||||||||||
32381 | 32381 | Charles Vanik V000047 | rep | OH | 1965-01-04 | 1967-01-03 | Democrat | 21 | |||||||||||||
32368 | 32368 | Lionel Van Deerlin V000024 | rep | CA | 1965-01-04 | 1967-01-03 | Democrat | 37 | |||||||||||||
32359 | 32359 | Albert Ullman U000004 | rep | OR | 1965-01-04 | 1967-01-03 | Democrat | 2 | |||||||||||||
32344 | 32344 | John Tower T000322 | sen | TX | 1961-01-03 | 1967-01-03 | 2 | Republican | |||||||||||||
32336 | 32336 | Frank Thompson T000200 | rep | NJ | 1965-01-04 | 1967-01-03 | Democrat | 4 | |||||||||||||
32322 | 32322 | Thomas Steed S000829 | rep | OK | 1965-01-04 | 1967-01-03 | Democrat | 4 | |||||||||||||
32306 | 32306 | Harley Staggers S000778 | rep | WV | 1965-01-04 | 1967-01-03 | Democrat | 2 | |||||||||||||
32286 | 32286 | John Slack S000473 | rep | WV | 1965-01-04 | 1967-01-03 | Democrat | 3 | |||||||||||||
32269 | 32269 | David Satterfield S000070 | rep | VA | 1965-01-04 | 1967-01-03 | Democrat | 3 | |||||||||||||
32255 | 32255 | Herbert Roberts R000312 | rep | TX | 1965-01-04 | 1967-01-03 | Democrat | 4 | |||||||||||||
32249 | 32249 | Jennings Randolph R000046 | sen | WV | 1961-01-03 | 1967-01-03 | 2 | Democrat | |||||||||||||
32224 | 32224 | Edward Patten P000106 | rep | NJ | 1965-01-04 | 1967-01-03 | Democrat | 15 |
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);