legislator_terms
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
481 rows where "start" is on date 1963-01-09 sorted by rowid descending
This data as json, copyable, CSV (advanced)
Suggested facets: type, party, end (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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
39803 | 39803 | John Dingell D000355 | rep | MI | 1963-01-09 | 1965-01-03 | Democrat | 15 | |||||||||||||
39021 | 39021 | Daniel Inouye I000025 | sen | HI | 1963-01-09 | 1969-01-03 | 3 | Democrat | |||||||||||||
36522 | 36522 | George Brown B000918 | rep | CA | 1963-01-09 | 1965-01-03 | Democrat | 29 | |||||||||||||
36295 | 36295 | Joseph McDade M000399 | rep | PA | 1963-01-09 | 1965-01-03 | Republican | 10 | |||||||||||||
36204 | 36204 | Henry González G000272 | rep | TX | 1963-01-09 | 1965-01-03 | Democrat | 20 | |||||||||||||
35975 | 35975 | James Quillen Q000013 | rep | TN | 1963-01-09 | 1965-01-03 | Republican | 1 | |||||||||||||
35821 | 35821 | Sam Gibbons G000153 | rep | FL | 1963-01-09 | 1965-01-03 | Democrat | 10 | |||||||||||||
35653 | 35653 | Jamie Whitten W000428 | rep | MS | 1963-01-09 | 1965-01-03 | Democrat | 2 | |||||||||||||
35584 | 35584 | Neal Smith S000596 | rep | IA | 1963-01-09 | 1965-01-03 | Democrat | 5 | |||||||||||||
35536 | 35536 | Daniel Rostenkowski R000458 | rep | IL | 1963-01-09 | 1965-01-03 | Democrat | 8 | |||||||||||||
35508 | 35508 | James Pickle P000328 | rep | TX | 1963-01-09 | 1965-01-03 | Democrat | 10 | |||||||||||||
35462 | 35462 | William Natcher N000009 | rep | KY | 1963-01-09 | 1965-01-03 | Democrat | 2 | |||||||||||||
35431 | 35431 | Robert Michel M000692 | rep | IL | 1963-01-09 | 1965-01-03 | Republican | 18 | |||||||||||||
35199 | 35199 | William Edwards E000064 | rep | CA | 1963-01-09 | 1965-01-03 | Democrat | 9 | |||||||||||||
35191 | 35191 | Robert Dole D000401 | rep | KS | 1963-01-09 | 1965-01-03 | Republican | 1 | |||||||||||||
35140 | 35140 | Jack Brooks B000880 | rep | TX | 1963-01-09 | 1965-01-03 | Democrat | 2 | |||||||||||||
35014 | 35014 | Morris Udall U000001 | rep | AZ | 1963-01-09 | 1965-01-03 | Democrat | 2 | |||||||||||||
34898 | 34898 | Edward Roybal R000485 | rep | CA | 1963-01-09 | 1965-01-03 | Democrat | 30 | |||||||||||||
34563 | 34563 | Frank Horton H000797 | rep | NY | 1963-01-09 | 1965-01-03 | Republican | 36 | |||||||||||||
34446 | 34446 | Dante Fascell F000041 | rep | FL | 1963-01-09 | 1965-01-03 | Democrat | 4 | |||||||||||||
34327 | 34327 | Silvio Conte C000709 | rep | MA | 1963-01-09 | 1965-01-03 | Republican | 1 | |||||||||||||
34268 | 34268 | William Broomfield B000890 | rep | MI | 1963-01-09 | 1965-01-03 | Republican | 18 | |||||||||||||
34240 | 34240 | Charles Bennett B000371 | rep | FL | 1963-01-09 | 1965-01-03 | Democrat | 2 | |||||||||||||
34146 | 34146 | James Wright W000763 | rep | TX | 1963-01-09 | 1965-01-03 | Democrat | 12 | |||||||||||||
34049 | 34049 | Claude Pepper P000218 | rep | FL | 1963-01-09 | 1965-01-03 | Democrat | 3 | |||||||||||||
34003 | 34003 | Spark Matsunaga M000250 | rep | HI | 1963-01-09 | 1965-01-03 | Democrat | 2 | |||||||||||||
33960 | 33960 | Robert Kastenmeier K000020 | rep | WI | 1963-01-09 | 1965-01-03 | Democrat | 2 | |||||||||||||
33933 | 33933 | Augustus Hawkins H000367 | rep | CA | 1963-01-09 | 1965-01-03 | Democrat | 21 | |||||||||||||
33764 | 33764 | Samuel Stratton S000997 | rep | NY | 1963-01-09 | 1965-01-03 | Democrat | 35 | |||||||||||||
33749 | 33749 | Fernand St. Germain S000762 | rep | RI | 1963-01-09 | 1965-01-03 | Democrat | 1 | |||||||||||||
33728 | 33728 | Peter Rodino R000374 | rep | NJ | 1963-01-09 | 1965-01-03 | Democrat | 10 | |||||||||||||
33704 | 33704 | Charles Price P000522 | rep | IL | 1963-01-09 | 1965-01-03 | Democrat | 24 | |||||||||||||
33639 | 33639 | Delbert Latta L000116 | rep | OH | 1963-01-09 | 1965-01-03 | Republican | 5 | |||||||||||||
33592 | 33592 | Kenneth Gray G000400 | rep | IL | 1963-01-09 | 1965-01-03 | Democrat | 21 | |||||||||||||
33499 | 33499 | Edward Boland B000600 | rep | MA | 1963-01-09 | 1965-01-03 | Democrat | 2 | |||||||||||||
33457 | 33457 | James Broyhill B000966 | rep | NC | 1963-01-09 | 1965-01-03 | Republican | 9 | |||||||||||||
33415 | 33415 | Marion Snyder S000669 | rep | KY | 1963-01-09 | 1965-01-03 | Republican | 3 | |||||||||||||
33387 | 33387 | Thomas O’Neill O000098 | rep | MA | 1963-01-09 | 1965-01-03 | Democrat | 8 | |||||||||||||
33338 | 33338 | Gillis Long L000417 | rep | LA | 1963-01-09 | 1965-01-03 | Democrat | 8 | |||||||||||||
33270 | 33270 | Don Fuqua F000430 | rep | FL | 1963-01-09 | 1965-01-03 | Democrat | 9 | |||||||||||||
33213 | 33213 | Joseph Addabbo A000052 | rep | NY | 1963-01-09 | 1965-01-03 | Democrat | 7 | |||||||||||||
33198 | 33198 | Clement Zablocki Z000001 | rep | WI | 1963-01-09 | 1965-01-03 | Democrat | 4 | |||||||||||||
33147 | 33147 | Robert Stafford S000776 | rep | VT | 1963-01-09 | 1965-01-03 | Republican | 0 | |||||||||||||
33128 | 33128 | Benjamin Rosenthal R000442 | rep | NY | 1963-01-09 | 1965-01-03 | Democrat | 8 | |||||||||||||
33094 | 33094 | Carl Perkins P000230 | rep | KY | 1963-01-09 | 1965-01-03 | Democrat | 7 | |||||||||||||
33061 | 33061 | Joseph Minish M000796 | rep | NJ | 1963-01-09 | 1965-01-03 | Democrat | 11 | |||||||||||||
33028 | 33028 | Clarence Long L000413 | rep | MD | 1963-01-09 | 1965-01-03 | Democrat | 2 | |||||||||||||
32908 | 32908 | Phillip Burton B001156 | rep | CA | 1963-01-09 | 1965-01-03 | Democrat | 5 | |||||||||||||
32828 | 32828 | John Rhodes R000188 | rep | AZ | 1963-01-09 | 1965-01-03 | Republican | 1 | |||||||||||||
32813 | 32813 | Henry Reuss R000165 | rep | WI | 1963-01-09 | 1965-01-03 | Democrat | 5 | |||||||||||||
32754 | 32754 | Robert McClory M000340 | rep | IL | 1963-01-09 | 1965-01-03 | Republican | 12 | |||||||||||||
32744 | 32744 | Charles Mathias M000241 | rep | MD | 1963-01-09 | 1965-01-03 | Republican | 6 | |||||||||||||
32736 | 32736 | Russell Long L000428 | sen | LA | 1963-01-09 | 1969-01-03 | 3 | Democrat | |||||||||||||
32663 | 32663 | Lawrence Fountain F000319 | rep | NC | 1963-01-09 | 1965-01-03 | Democrat | 2 | |||||||||||||
32644 | 32644 | Paul Findley F000123 | rep | IL | 1963-01-09 | 1965-01-03 | Republican | 20 | |||||||||||||
32598 | 32598 | Edward Derwinski D000269 | rep | IL | 1963-01-09 | 1965-01-03 | Republican | 4 | |||||||||||||
32556 | 32556 | Donald Clausen C000475 | rep | CA | 1963-01-09 | 1965-01-03 | Republican | 1 | |||||||||||||
32496 | 32496 | Richard Bolling B000605 | rep | MO | 1963-01-09 | 1965-01-03 | Democrat | 5 | |||||||||||||
32447 | 32447 | John Ashbrook A000221 | rep | OH | 1963-01-09 | 1965-01-03 | Republican | 17 | |||||||||||||
32435 | 32435 | Mark Andrews A000208 | rep | ND | 1963-01-09 | 1965-01-03 | Republican | 1 | |||||||||||||
32421 | 32421 | John Wydler W000780 | rep | NY | 1963-01-09 | 1965-01-03 | Republican | 4 | |||||||||||||
32403 | 32403 | Robert Wilson W000610 | rep | CA | 1963-01-09 | 1965-01-03 | Republican | 36 | |||||||||||||
32389 | 32389 | Charles Wilson W000571 | rep | CA | 1963-01-09 | 1965-01-03 | Democrat | 31 | |||||||||||||
32380 | 32380 | Charles Vanik V000047 | rep | OH | 1963-01-09 | 1965-01-03 | Democrat | 21 | |||||||||||||
32367 | 32367 | Lionel Van Deerlin V000024 | rep | CA | 1963-01-09 | 1965-01-03 | Democrat | 37 | |||||||||||||
32358 | 32358 | Albert Ullman U000004 | rep | OR | 1963-01-09 | 1965-01-03 | Democrat | 2 | |||||||||||||
32335 | 32335 | Frank Thompson T000200 | rep | NJ | 1963-01-09 | 1965-01-03 | Democrat | 4 | |||||||||||||
32321 | 32321 | Thomas Steed S000829 | rep | OK | 1963-01-09 | 1965-01-03 | Democrat | 4 | |||||||||||||
32305 | 32305 | Harley Staggers S000778 | rep | WV | 1963-01-09 | 1965-01-03 | Democrat | 2 | |||||||||||||
32285 | 32285 | John Slack S000473 | rep | WV | 1963-01-09 | 1965-01-03 | Democrat | 3 | |||||||||||||
32254 | 32254 | Herbert Roberts R000312 | rep | TX | 1963-01-09 | 1965-01-03 | Democrat | 4 | |||||||||||||
32223 | 32223 | Edward Patten P000106 | rep | NJ | 1963-01-09 | 1965-01-03 | Democrat | 15 | |||||||||||||
32214 | 32214 | Lucien Nedzi N000019 | rep | MI | 1963-01-09 | 1965-01-03 | Democrat | 1 | |||||||||||||
32195 | 32195 | John Murphy M001098 | rep | NY | 1963-01-09 | 1965-01-03 | Democrat | 16 | |||||||||||||
32186 | 32186 | William Moorhead M000930 | rep | PA | 1963-01-09 | 1965-01-03 | Democrat | 14 | |||||||||||||
32133 | 32133 | Harold Johnson J000135 | rep | CA | 1963-01-09 | 1965-01-03 | Democrat | 2 | |||||||||||||
32118 | 32118 | Richard Ichord I000001 | rep | MO | 1963-01-09 | 1965-01-03 | Democrat | 8 | |||||||||||||
32101 | 32101 | William Harsha H000281 | rep | OH | 1963-01-09 | 1965-01-03 | Republican | 6 | |||||||||||||
32078 | 32078 | Robert Giaimo G000151 | rep | CT | 1963-01-09 | 1965-01-03 | Democrat | 3 | |||||||||||||
32067 | 32067 | Daniel Flood F000209 | rep | PA | 1963-01-09 | 1965-01-03 | Democrat | 11 | |||||||||||||
32044 | 32044 | Robert Duncan D000537 | rep | OR | 1963-01-09 | 1965-01-03 | Democrat | 4 | |||||||||||||
32030 | 32030 | Charles Diggs D000344 | rep | MI | 1963-01-09 | 1965-01-03 | Democrat | 13 | |||||||||||||
32017 | 32017 | Samuel Devine D000279 | rep | OH | 1963-01-09 | 1965-01-03 | Republican | 12 | |||||||||||||
32001 | 32001 | James Corman C000780 | rep | CA | 1963-01-09 | 1965-01-03 | Democrat | 22 | |||||||||||||
31991 | 31991 | James Cleveland C000512 | rep | NH | 1963-01-09 | 1965-01-03 | Republican | 2 | |||||||||||||
31958 | 31958 | John Brademas B000736 | rep | IN | 1963-01-09 | 1965-01-03 | Democrat | 3 | |||||||||||||
31934 | 31934 | Thomas Ashley A000222 | rep | OH | 1963-01-09 | 1965-01-03 | Democrat | 9 | |||||||||||||
31921 | 31921 | John Anderson A000195 | rep | IL | 1963-01-09 | 1965-01-03 | Republican | 16 | |||||||||||||
31905 | 31905 | John Young Y000043 | rep | TX | 1963-01-09 | 1965-01-03 | Democrat | 14 | |||||||||||||
31870 | 31870 | Joseph Waggonner W000018 | rep | LA | 1963-01-09 | 1965-01-03 | Democrat | 4 | |||||||||||||
31855 | 31855 | Olin Teague T000110 | rep | TX | 1963-01-09 | 1965-01-03 | Democrat | 6 | |||||||||||||
31831 | 31831 | Joe Skubitz S000472 | rep | KS | 1963-01-09 | 1965-01-03 | Republican | 5 | |||||||||||||
31823 | 31823 | Bernice Sisk S000454 | rep | CA | 1963-01-09 | 1965-01-03 | Democrat | 16 | |||||||||||||
31811 | 31811 | Robert Sikes S000406 | rep | FL | 1963-01-09 | 1965-01-03 | Democrat | 1 | |||||||||||||
31792 | 31792 | George Shipley S000367 | rep | IL | 1963-01-09 | 1965-01-03 | Democrat | 23 | |||||||||||||
31769 | 31769 | Frederick Rooney R000423 | rep | PA | 1963-01-09 | 1965-01-03 | Democrat | 15 | |||||||||||||
31756 | 31756 | Paul Rogers R000401 | rep | FL | 1963-01-09 | 1965-01-03 | Democrat | 6 | |||||||||||||
31742 | 31742 | Albert Quie Q000010 | rep | MN | 1963-01-09 | 1965-01-03 | Republican | 1 | |||||||||||||
31731 | 31731 | William Poage P000398 | rep | TX | 1963-01-09 | 1965-01-03 | Democrat | 11 | |||||||||||||
31710 | 31710 | Otis Pike P000348 | rep | NY | 1963-01-09 | 1965-01-03 | Democrat | 1 |
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);