legislator_terms
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
478 rows where "start" is on date 1971-01-21 sorted by rowid descending
This data as json, copyable, CSV (advanced)
Suggested facets: type, end, party
end (date) 7 ✖
- 1973-01-03 443
- 1977-01-03 28
- 1976-12-27 2
- 1976-12-28 2
- 1971-09-16 1
- 1972-10-16 1
- 1972-12-08 1
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
40558 | 40558 | John Conyers C000714 | rep | MI | 1971-01-21 | 1973-01-03 | Democrat | 1 | |||||||||||||
40438 | 40438 | Charles Rangel R000053 | rep | NY | 1971-01-21 | 1973-01-03 | Democrat | 18 | |||||||||||||
39807 | 39807 | John Dingell D000355 | rep | MI | 1971-01-21 | 1973-01-03 | Democrat | 16 | |||||||||||||
39622 | 39622 | C. Young Y000031 | rep | FL | 1971-01-21 | 1973-01-03 | Republican | 8 | |||||||||||||
38731 | 38731 | David Obey O000007 | rep | WI | 1971-01-21 | 1973-01-03 | Democrat | 7 | |||||||||||||
38151 | 38151 | Edward Kennedy K000105 | sen | MA | 1971-01-21 | 1977-01-03 | 1 | Democrat | |||||||||||||
37956 | 37956 | Robert Byrd B001210 | sen | WV | 1971-01-21 | 1977-01-03 | 1 | Democrat | |||||||||||||
37283 | 37283 | Philip Crane C000873 | rep | IL | 1971-01-21 | 1973-01-03 | Republican | 13 | |||||||||||||
37154 | 37154 | Floyd Spence S000718 | rep | SC | 1971-01-21 | 1973-01-03 | Republican | 2 | |||||||||||||
37093 | 37093 | Paul Sarbanes S000064 | rep | MD | 1971-01-21 | 1973-01-03 | Democrat | 4 | |||||||||||||
37030 | 37030 | Patsy Mink M000797 | rep | HI | 1971-01-21 | 1973-01-03 | Democrat | 2 | |||||||||||||
36558 | 36558 | William Clay C000488 | rep | MO | 1971-01-21 | 1973-01-03 | Democrat | 1 | |||||||||||||
36511 | 36511 | John Breaux B000780 | rep | LA | 1971-01-21 | 1973-01-03 | Democrat | 7 | |||||||||||||
36472 | 36472 | Bill Archer A000215 | rep | TX | 1971-01-21 | 1973-01-03 | Republican | 7 | |||||||||||||
36458 | 36458 | Sidney Yates Y000013 | rep | IL | 1971-01-21 | 1973-01-03 | Democrat | 9 | |||||||||||||
36399 | 36399 | Louis Stokes S000948 | rep | OH | 1971-01-21 | 1973-01-03 | Democrat | 21 | |||||||||||||
36299 | 36299 | Joseph McDade M000399 | rep | PA | 1971-01-21 | 1973-01-03 | Republican | 10 | |||||||||||||
36231 | 36231 | Lee Hamilton H000114 | rep | IN | 1971-01-21 | 1973-01-03 | Democrat | 9 | |||||||||||||
36208 | 36208 | Henry González G000272 | rep | TX | 1971-01-21 | 1973-01-03 | Democrat | 20 | |||||||||||||
36142 | 36142 | Ronald Dellums D000222 | rep | CA | 1971-01-21 | 1973-01-03 | Democrat | 7 | |||||||||||||
36119 | 36119 | Eligio de la Garza D000203 | rep | TX | 1971-01-21 | 1973-01-03 | Democrat | 15 | |||||||||||||
36019 | 36019 | William Roth R000460 | sen | DE | 1971-01-21 | 1977-01-03 | 1 | Republican | |||||||||||||
35979 | 35979 | James Quillen Q000013 | rep | TN | 1971-01-21 | 1973-01-03 | Republican | 1 | |||||||||||||
35951 | 35951 | John Myers M001130 | rep | IN | 1971-01-21 | 1973-01-03 | Republican | 7 | |||||||||||||
35920 | 35920 | Gillespie Montgomery M000865 | rep | MS | 1971-01-21 | 1973-01-03 | Democrat | 4 | |||||||||||||
35866 | 35866 | Andrew Jacobs J000033 | rep | IN | 1971-01-21 | 1973-01-03 | Democrat | 11 | |||||||||||||
35825 | 35825 | Sam Gibbons G000153 | rep | FL | 1971-01-21 | 1973-01-03 | Democrat | 6 | |||||||||||||
35695 | 35695 | Tom Bevill B000431 | rep | AL | 1971-01-21 | 1973-01-03 | Democrat | 7 | |||||||||||||
35657 | 35657 | Jamie Whitten W000428 | rep | MS | 1971-01-21 | 1973-01-03 | Democrat | 2 | |||||||||||||
35588 | 35588 | Neal Smith S000596 | rep | IA | 1971-01-21 | 1973-01-03 | Democrat | 5 | |||||||||||||
35540 | 35540 | Daniel Rostenkowski R000458 | rep | IL | 1971-01-21 | 1973-01-03 | Democrat | 8 | |||||||||||||
35512 | 35512 | James Pickle P000328 | rep | TX | 1971-01-21 | 1973-01-03 | Democrat | 10 | |||||||||||||
35466 | 35466 | William Natcher N000009 | rep | KY | 1971-01-21 | 1973-01-03 | Democrat | 2 | |||||||||||||
35435 | 35435 | Robert Michel M000692 | rep | IL | 1971-01-21 | 1973-01-03 | Republican | 18 | |||||||||||||
35392 | 35392 | Romano Mazzoli M000291 | rep | KY | 1971-01-21 | 1973-01-03 | Democrat | 3 | |||||||||||||
35268 | 35268 | William Ford F000270 | rep | MI | 1971-01-21 | 1973-01-03 | Democrat | 15 | |||||||||||||
35248 | 35248 | Thomas Foley F000239 | rep | WA | 1971-01-21 | 1973-01-03 | Democrat | 5 | |||||||||||||
35233 | 35233 | Hamilton Fish F000141 | rep | NY | 1971-01-21 | 1973-01-03 | Republican | 28 | |||||||||||||
35203 | 35203 | William Edwards E000064 | rep | CA | 1971-01-21 | 1973-01-03 | Democrat | 9 | |||||||||||||
35144 | 35144 | Jack Brooks B000880 | rep | TX | 1971-01-21 | 1973-01-03 | Democrat | 9 | |||||||||||||
35108 | 35108 | Leslie Aspin A000224 | rep | WI | 1971-01-21 | 1973-01-03 | Democrat | 1 | |||||||||||||
35079 | 35079 | Gus Yatron Y000014 | rep | PA | 1971-01-21 | 1973-01-03 | Democrat | 6 | |||||||||||||
35067 | 35067 | Chalmers Wylie W000781 | rep | OH | 1971-01-21 | 1973-01-03 | Republican | 15 | |||||||||||||
35032 | 35032 | Guy Vander Jagt V000027 | rep | MI | 1971-01-21 | 1973-01-03 | Republican | 9 | |||||||||||||
35018 | 35018 | Morris Udall U000001 | rep | AZ | 1971-01-21 | 1973-01-03 | Democrat | 2 | |||||||||||||
34931 | 34931 | James Scheuer S000124 | rep | NY | 1971-01-21 | 1973-01-03 | Democrat | 22 | |||||||||||||
34902 | 34902 | Edward Roybal R000485 | rep | CA | 1971-01-21 | 1973-01-03 | Democrat | 30 | |||||||||||||
34887 | 34887 | Robert Roe R000383 | rep | NJ | 1971-01-21 | 1973-01-03 | Democrat | 8 | |||||||||||||
34849 | 34849 | David Pryor P000556 | rep | AR | 1971-01-21 | 1973-01-03 | Democrat | 4 | |||||||||||||
34753 | 34753 | Clarence Miller M000718 | rep | OH | 1971-01-21 | 1973-01-03 | Republican | 10 | |||||||||||||
34673 | 34673 | Norman Lent L000243 | rep | NY | 1971-01-21 | 1973-01-03 | Republican | 5 | |||||||||||||
34623 | 34623 | Walter Jones J000256 | rep | NC | 1971-01-21 | 1973-01-03 | Democrat | 1 | |||||||||||||
34567 | 34567 | Frank Horton H000797 | rep | NY | 1971-01-21 | 1973-01-03 | Republican | 36 | |||||||||||||
34513 | 34513 | John Hammerschmidt H000124 | rep | AR | 1971-01-21 | 1973-01-03 | Republican | 3 | |||||||||||||
34472 | 34472 | Joseph Gaydos G000105 | rep | PA | 1971-01-21 | 1973-01-03 | Democrat | 20 | |||||||||||||
34450 | 34450 | Dante Fascell F000041 | rep | FL | 1971-01-21 | 1973-01-03 | Democrat | 12 | |||||||||||||
34372 | 34372 | William Dickinson D000326 | rep | AL | 1971-01-21 | 1973-01-03 | Republican | 2 | |||||||||||||
34343 | 34343 | Robert Coughlin C000807 | rep | PA | 1971-01-21 | 1973-01-03 | Republican | 13 | |||||||||||||
34331 | 34331 | Silvio Conte C000709 | rep | MA | 1971-01-21 | 1973-01-03 | Republican | 1 | |||||||||||||
34272 | 34272 | William Broomfield B000890 | rep | MI | 1971-01-21 | 1973-01-03 | Republican | 18 | |||||||||||||
34244 | 34244 | Charles Bennett B000371 | rep | FL | 1971-01-21 | 1973-01-03 | Democrat | 3 | |||||||||||||
34189 | 34189 | Frank Annunzio A000212 | rep | IL | 1971-01-21 | 1973-01-03 | Democrat | 7 | |||||||||||||
34175 | 34175 | Glenn Anderson A000189 | rep | CA | 1971-01-21 | 1973-01-03 | Democrat | 17 | |||||||||||||
34163 | 34163 | William Alexander A000103 | rep | AR | 1971-01-21 | 1973-01-03 | Democrat | 1 | |||||||||||||
34150 | 34150 | James Wright W000763 | rep | TX | 1971-01-21 | 1973-01-03 | Democrat | 12 | |||||||||||||
34065 | 34065 | Donald Riegle R000249 | rep | MI | 1971-01-21 | 1973-01-03 | Republican | 7 | |||||||||||||
34053 | 34053 | Claude Pepper P000218 | rep | FL | 1971-01-21 | 1973-01-03 | Democrat | 11 | |||||||||||||
34007 | 34007 | Spark Matsunaga M000250 | rep | HI | 1971-01-21 | 1973-01-03 | Democrat | 1 | |||||||||||||
33964 | 33964 | Robert Kastenmeier K000020 | rep | WI | 1971-01-21 | 1973-01-03 | Democrat | 2 | |||||||||||||
33947 | 33947 | Henry Heinz H000456 | rep | PA | 1971-01-21 | 1973-01-03 | Republican | 18 | |||||||||||||
33937 | 33937 | Augustus Hawkins H000367 | rep | CA | 1971-01-21 | 1973-01-03 | Democrat | 21 | |||||||||||||
33914 | 33914 | William Frenzel F000380 | rep | MN | 1971-01-21 | 1973-01-03 | Republican | 3 | |||||||||||||
33889 | 33889 | Walter Fauntroy F000046 | rep | DC | 1971-01-21 | 1973-01-03 | Democrat | 0 | |||||||||||||
33842 | 33842 | Quentin Burdick B001077 | sen | ND | 1971-01-21 | 1977-01-03 | 1 | Democrat | |||||||||||||
33818 | 33818 | Lloyd Bentsen B000401 | sen | TX | 1971-01-21 | 1977-01-03 | 1 | Democrat | |||||||||||||
33768 | 33768 | Samuel Stratton S000997 | rep | NY | 1971-01-21 | 1973-01-03 | Democrat | 29 | |||||||||||||
33753 | 33753 | Fernand St. Germain S000762 | rep | RI | 1971-01-21 | 1973-01-03 | Democrat | 1 | |||||||||||||
33732 | 33732 | Peter Rodino R000374 | rep | NJ | 1971-01-21 | 1973-01-03 | Democrat | 10 | |||||||||||||
33708 | 33708 | Charles Price P000522 | rep | IL | 1971-01-21 | 1973-01-03 | Democrat | 24 | |||||||||||||
33686 | 33686 | William Nichols N000095 | rep | AL | 1971-01-21 | 1973-01-03 | Democrat | 4 | |||||||||||||
33670 | 33670 | Stewart McKinney M000527 | rep | CT | 1971-01-21 | 1973-01-03 | Republican | 4 | |||||||||||||
33658 | 33658 | Manuel Luján L000506 | rep | NM | 1971-01-21 | 1973-01-03 | Republican | 1 | |||||||||||||
33643 | 33643 | Delbert Latta L000116 | rep | OH | 1971-01-21 | 1973-01-03 | Republican | 5 | |||||||||||||
33627 | 33627 | Jack Kemp K000086 | rep | NY | 1971-01-21 | 1973-01-03 | Republican | 39 | |||||||||||||
33613 | 33613 | Ed Jones J000216 | rep | TN | 1971-01-21 | 1973-01-03 | Democrat | 8 | |||||||||||||
33603 | 33603 | James Howard H000840 | rep | NJ | 1971-01-21 | 1973-01-03 | Democrat | 3 | |||||||||||||
33596 | 33596 | Kenneth Gray G000400 | rep | IL | 1971-01-21 | 1973-01-03 | Democrat | 21 | |||||||||||||
33569 | 33569 | John Duncan D000534 | rep | TN | 1971-01-21 | 1973-01-03 | Republican | 2 | |||||||||||||
33544 | 33544 | Wilbur Daniel D000038 | rep | VA | 1971-01-21 | 1973-01-03 | Democrat | 5 | |||||||||||||
33530 | 33530 | William Chappell C000321 | rep | FL | 1971-01-21 | 1973-01-03 | Democrat | 4 | |||||||||||||
33503 | 33503 | Edward Boland B000600 | rep | MA | 1971-01-21 | 1973-01-03 | Democrat | 2 | |||||||||||||
33485 | 33485 | Mario Biaggi B000432 | rep | NY | 1971-01-21 | 1973-01-03 | Democrat | 24 | |||||||||||||
33473 | 33473 | Brockman Adams A000031 | rep | WA | 1971-01-21 | 1973-01-03 | Democrat | 7 | |||||||||||||
33461 | 33461 | James Broyhill B000966 | rep | NC | 1971-01-21 | 1973-01-03 | Republican | 10 | |||||||||||||
33435 | 33435 | George Whitehurst W000406 | rep | VA | 1971-01-21 | 1973-01-03 | Republican | 2 | |||||||||||||
33418 | 33418 | Marion Snyder S000669 | rep | KY | 1971-01-21 | 1973-01-03 | Republican | 4 | |||||||||||||
33404 | 33404 | John Seiberling S000230 | rep | OH | 1971-01-21 | 1973-01-03 | Democrat | 14 | |||||||||||||
33391 | 33391 | Thomas O’Neill O000098 | rep | MA | 1971-01-21 | 1973-01-03 | Democrat | 8 | |||||||||||||
33360 | 33360 | Parren Mitchell M000826 | rep | MD | 1971-01-21 | 1973-01-03 | Democrat | 7 | |||||||||||||
33354 | 33354 | James McClure M000346 | rep | ID | 1971-01-21 | 1973-01-03 | Republican | 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);