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 rowid descending
This data as json, copyable, CSV (advanced)
Suggested facets: type, start, class, district
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
40556 | 40556 | John Conyers C000714 | rep | MI | 1967-01-10 | 1969-01-03 | Democrat | 1 | |||||||||||||
39805 | 39805 | John Dingell D000355 | rep | MI | 1967-01-10 | 1969-01-03 | Democrat | 16 | |||||||||||||
39021 | 39021 | Daniel Inouye I000025 | sen | HI | 1963-01-09 | 1969-01-03 | 3 | Democrat | |||||||||||||
37028 | 37028 | Patsy Mink M000797 | rep | HI | 1967-01-10 | 1969-01-03 | Democrat | 1 | |||||||||||||
36649 | 36649 | Ernest Hollings H000725 | sen | SC | 1966-11-09 | 1969-01-03 | 3 | Democrat | |||||||||||||
36524 | 36524 | George Brown B000918 | rep | CA | 1967-01-10 | 1969-01-03 | Democrat | 29 | |||||||||||||
36456 | 36456 | Sidney Yates Y000013 | rep | IL | 1967-01-10 | 1969-01-03 | Democrat | 9 | |||||||||||||
36297 | 36297 | Joseph McDade M000399 | rep | PA | 1967-01-10 | 1969-01-03 | Republican | 10 | |||||||||||||
36229 | 36229 | Lee Hamilton H000114 | rep | IN | 1967-01-10 | 1969-01-03 | Democrat | 9 | |||||||||||||
36206 | 36206 | Henry González G000272 | rep | TX | 1967-01-10 | 1969-01-03 | Democrat | 20 | |||||||||||||
36117 | 36117 | Eligio de la Garza D000203 | rep | TX | 1967-01-10 | 1969-01-03 | Democrat | 15 | |||||||||||||
36017 | 36017 | William Roth R000460 | rep | DE | 1967-01-10 | 1969-01-03 | Republican | 0 | |||||||||||||
35977 | 35977 | James Quillen Q000013 | rep | TN | 1967-01-10 | 1969-01-03 | Republican | 1 | |||||||||||||
35949 | 35949 | John Myers M001130 | rep | IN | 1967-01-10 | 1969-01-03 | Republican | 7 | |||||||||||||
35918 | 35918 | Gillespie Montgomery M000865 | rep | MS | 1967-01-10 | 1969-01-03 | Democrat | 4 | |||||||||||||
35864 | 35864 | Andrew Jacobs J000033 | rep | IN | 1967-01-10 | 1969-01-03 | Democrat | 11 | |||||||||||||
35823 | 35823 | Sam Gibbons G000153 | rep | FL | 1967-01-10 | 1969-01-03 | Democrat | 6 | |||||||||||||
35693 | 35693 | Tom Bevill B000431 | rep | AL | 1967-01-10 | 1969-01-03 | Democrat | 7 | |||||||||||||
35655 | 35655 | Jamie Whitten W000428 | rep | MS | 1967-01-10 | 1969-01-03 | Democrat | 2 | |||||||||||||
35586 | 35586 | Neal Smith S000596 | rep | IA | 1967-01-10 | 1969-01-03 | Democrat | 5 | |||||||||||||
35538 | 35538 | Daniel Rostenkowski R000458 | rep | IL | 1967-01-10 | 1969-01-03 | Democrat | 8 | |||||||||||||
35510 | 35510 | James Pickle P000328 | rep | TX | 1967-01-10 | 1969-01-03 | Democrat | 10 | |||||||||||||
35464 | 35464 | William Natcher N000009 | rep | KY | 1967-01-10 | 1969-01-03 | Democrat | 2 | |||||||||||||
35433 | 35433 | Robert Michel M000692 | rep | IL | 1967-01-10 | 1969-01-03 | Republican | 18 | |||||||||||||
35266 | 35266 | William Ford F000270 | rep | MI | 1967-01-10 | 1969-01-03 | Democrat | 15 | |||||||||||||
35246 | 35246 | Thomas Foley F000239 | rep | WA | 1967-01-10 | 1969-01-03 | Democrat | 5 | |||||||||||||
35201 | 35201 | William Edwards E000064 | rep | CA | 1967-01-10 | 1969-01-03 | Democrat | 9 | |||||||||||||
35193 | 35193 | Robert Dole D000401 | rep | KS | 1967-01-10 | 1969-01-03 | Republican | 1 | |||||||||||||
35142 | 35142 | Jack Brooks B000880 | rep | TX | 1967-01-10 | 1969-01-03 | Democrat | 9 | |||||||||||||
35065 | 35065 | Chalmers Wylie W000781 | rep | OH | 1967-01-10 | 1969-01-03 | Republican | 15 | |||||||||||||
35030 | 35030 | Guy Vander Jagt V000027 | rep | MI | 1967-01-10 | 1969-01-03 | Republican | 9 | |||||||||||||
35016 | 35016 | Morris Udall U000001 | rep | AZ | 1967-01-10 | 1969-01-03 | Democrat | 2 | |||||||||||||
34929 | 34929 | James Scheuer S000124 | rep | NY | 1967-01-10 | 1969-01-03 | Democrat | 21 | |||||||||||||
34900 | 34900 | Edward Roybal R000485 | rep | CA | 1967-01-10 | 1969-01-03 | Democrat | 30 | |||||||||||||
34847 | 34847 | David Pryor P000556 | rep | AR | 1967-01-10 | 1969-01-03 | Democrat | 4 | |||||||||||||
34751 | 34751 | Clarence Miller M000718 | rep | OH | 1967-01-10 | 1969-01-03 | Republican | 10 | |||||||||||||
34621 | 34621 | Walter Jones J000256 | rep | NC | 1967-01-10 | 1969-01-03 | Democrat | 1 | |||||||||||||
34565 | 34565 | Frank Horton H000797 | rep | NY | 1967-01-10 | 1969-01-03 | Republican | 36 | |||||||||||||
34511 | 34511 | John Hammerschmidt H000124 | rep | AR | 1967-01-10 | 1969-01-03 | Republican | 3 | |||||||||||||
34470 | 34470 | Joseph Gaydos G000105 | rep | PA | 1967-01-10 | 1969-01-03 | Democrat | 20 | |||||||||||||
34448 | 34448 | Dante Fascell F000041 | rep | FL | 1967-01-10 | 1969-01-03 | Democrat | 12 | |||||||||||||
34370 | 34370 | William Dickinson D000326 | rep | AL | 1967-01-10 | 1969-01-03 | Republican | 2 | |||||||||||||
34329 | 34329 | Silvio Conte C000709 | rep | MA | 1967-01-10 | 1969-01-03 | Republican | 1 | |||||||||||||
34270 | 34270 | William Broomfield B000890 | rep | MI | 1967-01-10 | 1969-01-03 | Republican | 18 | |||||||||||||
34242 | 34242 | Charles Bennett B000371 | rep | FL | 1967-01-10 | 1969-01-03 | Democrat | 3 | |||||||||||||
34187 | 34187 | Frank Annunzio A000212 | rep | IL | 1967-01-10 | 1969-01-03 | Democrat | 7 | |||||||||||||
34160 | 34160 | George Bush B001166 | rep | TX | 1967-01-10 | 1969-01-03 | Republican | 7 | |||||||||||||
34148 | 34148 | James Wright W000763 | rep | TX | 1967-01-10 | 1969-01-03 | Democrat | 12 | |||||||||||||
34063 | 34063 | Donald Riegle R000249 | rep | MI | 1967-01-10 | 1969-01-03 | Republican | 7 | |||||||||||||
34051 | 34051 | Claude Pepper P000218 | rep | FL | 1967-01-10 | 1969-01-03 | Democrat | 11 | |||||||||||||
34005 | 34005 | Spark Matsunaga M000250 | rep | HI | 1967-01-10 | 1969-01-03 | Democrat | 2 | |||||||||||||
33994 | 33994 | Donald Lukens L000509 | rep | OH | 1967-01-10 | 1969-01-03 | Republican | 24 | |||||||||||||
33962 | 33962 | Robert Kastenmeier K000020 | rep | WI | 1967-01-10 | 1969-01-03 | Democrat | 2 | |||||||||||||
33935 | 33935 | Augustus Hawkins H000367 | rep | CA | 1967-01-10 | 1969-01-03 | Democrat | 21 | |||||||||||||
33766 | 33766 | Samuel Stratton S000997 | rep | NY | 1967-01-10 | 1969-01-03 | Democrat | 35 | |||||||||||||
33751 | 33751 | Fernand St. Germain S000762 | rep | RI | 1967-01-10 | 1969-01-03 | Democrat | 1 | |||||||||||||
33730 | 33730 | Peter Rodino R000374 | rep | NJ | 1967-01-10 | 1969-01-03 | Democrat | 10 | |||||||||||||
33706 | 33706 | Charles Price P000522 | rep | IL | 1967-01-10 | 1969-01-03 | Democrat | 24 | |||||||||||||
33684 | 33684 | William Nichols N000095 | rep | AL | 1967-01-10 | 1969-01-03 | Democrat | 4 | |||||||||||||
33641 | 33641 | Delbert Latta L000116 | rep | OH | 1967-01-10 | 1969-01-03 | Republican | 5 | |||||||||||||
33601 | 33601 | James Howard H000840 | rep | NJ | 1967-01-10 | 1969-01-03 | Democrat | 3 | |||||||||||||
33594 | 33594 | Kenneth Gray G000400 | rep | IL | 1967-01-10 | 1969-01-03 | Democrat | 21 | |||||||||||||
33567 | 33567 | John Duncan D000534 | rep | TN | 1967-01-10 | 1969-01-03 | Republican | 2 | |||||||||||||
33501 | 33501 | Edward Boland B000600 | rep | MA | 1967-01-10 | 1969-01-03 | Democrat | 2 | |||||||||||||
33471 | 33471 | Brockman Adams A000031 | rep | WA | 1967-01-10 | 1969-01-03 | Democrat | 7 | |||||||||||||
33459 | 33459 | James Broyhill B000966 | rep | NC | 1967-01-10 | 1969-01-03 | Republican | 9 | |||||||||||||
33416 | 33416 | Marion Snyder S000669 | rep | KY | 1967-01-10 | 1969-01-03 | Republican | 4 | |||||||||||||
33389 | 33389 | Thomas O’Neill O000098 | rep | MA | 1967-01-10 | 1969-01-03 | Democrat | 8 | |||||||||||||
33352 | 33352 | James McClure M000346 | rep | ID | 1967-01-10 | 1969-01-03 | Republican | 1 | |||||||||||||
33272 | 33272 | Don Fuqua F000430 | rep | FL | 1967-01-10 | 1969-01-03 | Democrat | 2 | |||||||||||||
33215 | 33215 | Joseph Addabbo A000052 | rep | NY | 1967-01-10 | 1969-01-03 | Democrat | 7 | |||||||||||||
33200 | 33200 | Clement Zablocki Z000001 | rep | WI | 1967-01-10 | 1969-01-03 | Democrat | 4 | |||||||||||||
33176 | 33176 | Edward Winn W000636 | rep | KS | 1967-01-10 | 1969-01-03 | Republican | 3 | |||||||||||||
33149 | 33149 | Robert Stafford S000776 | rep | VT | 1967-01-10 | 1969-01-03 | Republican | 0 | |||||||||||||
33130 | 33130 | Benjamin Rosenthal R000442 | rep | NY | 1967-01-10 | 1969-01-03 | Democrat | 8 | |||||||||||||
33096 | 33096 | Carl Perkins P000230 | rep | KY | 1967-01-10 | 1969-01-03 | Democrat | 7 | |||||||||||||
33073 | 33073 | Richard Ottinger O000134 | rep | NY | 1967-01-10 | 1969-01-03 | Democrat | 25 | |||||||||||||
33063 | 33063 | Joseph Minish M000796 | rep | NJ | 1967-01-10 | 1969-01-03 | Democrat | 11 | |||||||||||||
33030 | 33030 | Clarence Long L000413 | rep | MD | 1967-01-10 | 1969-01-03 | Democrat | 2 | |||||||||||||
33011 | 33011 | Abraham Kazen K000025 | rep | TX | 1967-01-10 | 1969-01-03 | Democrat | 23 | |||||||||||||
32986 | 32986 | George Hansen H000171 | rep | ID | 1967-01-10 | 1969-01-03 | Republican | 2 | |||||||||||||
32959 | 32959 | John Erlenborn E000204 | rep | IL | 1967-01-10 | 1969-01-03 | Republican | 14 | |||||||||||||
32949 | 32949 | William Edwards E000084 | rep | AL | 1967-01-10 | 1969-01-03 | Republican | 1 | |||||||||||||
32923 | 32923 | Barber Conable C000666 | rep | NY | 1967-01-10 | 1969-01-03 | Republican | 37 | |||||||||||||
32910 | 32910 | Phillip Burton B001156 | rep | CA | 1967-01-10 | 1969-01-03 | Democrat | 5 | |||||||||||||
32882 | 32882 | Richard White W000390 | rep | TX | 1967-01-10 | 1969-01-03 | Democrat | 16 | |||||||||||||
32872 | 32872 | William Wampler W000121 | rep | VA | 1967-01-10 | 1969-01-03 | Republican | 9 | |||||||||||||
32859 | 32859 | John Stanton S000804 | rep | OH | 1967-01-10 | 1969-01-03 | Republican | 11 | |||||||||||||
32830 | 32830 | John Rhodes R000188 | rep | AZ | 1967-01-10 | 1969-01-03 | Republican | 1 | |||||||||||||
32815 | 32815 | Henry Reuss R000165 | rep | WI | 1967-01-10 | 1969-01-03 | Democrat | 5 | |||||||||||||
32801 | 32801 | Thomas Railsback R000012 | rep | IL | 1967-01-10 | 1969-01-03 | Republican | 19 | |||||||||||||
32764 | 32764 | Paul McCloskey M000343 | rep | CA | 1967-01-10 | 1969-01-03 | Republican | 11 | |||||||||||||
32756 | 32756 | Robert McClory M000340 | rep | IL | 1967-01-10 | 1969-01-03 | Republican | 12 | |||||||||||||
32746 | 32746 | Charles Mathias M000241 | rep | MD | 1967-01-10 | 1969-01-03 | Republican | 6 | |||||||||||||
32736 | 32736 | Russell Long L000428 | sen | LA | 1963-01-09 | 1969-01-03 | 3 | Democrat | |||||||||||||
32704 | 32704 | Margaret Heckler H000440 | rep | MA | 1967-01-10 | 1969-01-03 | Republican | 10 | |||||||||||||
32665 | 32665 | Lawrence Fountain F000319 | rep | NC | 1967-01-10 | 1969-01-03 | Democrat | 2 | |||||||||||||
32646 | 32646 | Paul Findley F000123 | rep | IL | 1967-01-10 | 1969-01-03 | Republican | 20 | |||||||||||||
32611 | 32611 | Thomas Eagleton E000004 | sen | MO | 1968-12-28 | 1969-01-03 | 3 | Democrat | |||||||||||||
32600 | 32600 | Edward Derwinski D000269 | rep | IL | 1967-01-10 | 1969-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);