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 party descending
This data as json, copyable, CSV (advanced)
Suggested facets: party
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
29582 | 29582 | John Beall B000272 | sen | MD | 1971-01-21 | 1977-01-03 | 1 | Republican | |||||||||||||
29594 | 29594 | Page Belcher B000323 | rep | OK | 1971-01-21 | 1973-01-03 | Republican | 1 | |||||||||||||
29605 | 29605 | Jackson Betts B000426 | rep | OH | 1971-01-21 | 1973-01-03 | Republican | 8 | |||||||||||||
29633 | 29633 | Frank Bow B000676 | rep | OH | 1971-01-21 | 1973-01-03 | Republican | 16 | |||||||||||||
29638 | 29638 | William Brock B000851 | sen | TN | 1971-01-21 | 1977-01-03 | 1 | Republican | |||||||||||||
29663 | 29663 | John Byrnes B001216 | rep | WI | 1971-01-21 | 1973-01-03 | Republican | 8 | |||||||||||||
29670 | 29670 | Cliffard Carlson C000153 | rep | IL | 1971-01-21 | 1973-01-03 | Republican | 15 | |||||||||||||
29716 | 29716 | William Conover C000702 | rep | PA | 1971-01-21 | 1973-01-03 | Republican | 27 | |||||||||||||
29731 | 29731 | Robert Corbett C000772 | rep | PA | 1971-01-21 | 1973-01-03 | Republican | 18 | |||||||||||||
29756 | 29756 | Florence Dwyer D000587 | rep | NJ | 1971-01-21 | 1973-01-03 | Republican | 12 | |||||||||||||
29772 | 29772 | Paul Fannin F000013 | sen | AZ | 1971-01-21 | 1977-01-03 | 1 | Republican | |||||||||||||
29775 | 29775 | Hiram Fong F000245 | sen | HI | 1971-01-21 | 1977-01-03 | 1 | Republican | |||||||||||||
29789 | 29789 | James Fulton F000422 | rep | PA | 1971-01-21 | 1973-01-03 | Republican | 27 | |||||||||||||
29828 | 29828 | Durward Hall H000049 | rep | MO | 1971-01-21 | 1973-01-03 | Republican | 7 | |||||||||||||
29835 | 29835 | Seymour Halpern H000085 | rep | NY | 1971-01-21 | 1973-01-03 | Republican | 6 | |||||||||||||
29847 | 29847 | Roman Hruska H000875 | sen | NE | 1971-01-21 | 1976-12-27 | 1 | Republican | |||||||||||||
29866 | 29866 | Charles Jonas J000206 | rep | NC | 1971-01-21 | 1973-01-03 | Republican | 9 | |||||||||||||
29877 | 29877 | Hastings Keith K000053 | rep | MA | 1971-01-21 | 1973-01-03 | Republican | 12 | |||||||||||||
29883 | 29883 | John Kyl K000351 | rep | IA | 1971-01-21 | 1973-01-03 | Republican | 4 | |||||||||||||
29897 | 29897 | Sherman Lloyd L000382 | rep | UT | 1971-01-21 | 1973-01-03 | Republican | 2 | |||||||||||||
29923 | 29923 | William McCulloch M000393 | rep | OH | 1971-01-21 | 1973-01-03 | Republican | 4 | |||||||||||||
29926 | 29926 | Jack McDonald M000410 | rep | MI | 1971-01-21 | 1973-01-03 | Republican | 19 | |||||||||||||
29930 | 29930 | James McKevitt M000513 | rep | CO | 1971-01-21 | 1973-01-03 | Republican | 1 | |||||||||||||
29981 | 29981 | Frank Morse M001009 | rep | MA | 1971-01-21 | 1973-01-03 | Republican | 5 | |||||||||||||
29986 | 29986 | Rogers Morton M001021 | rep | MD | 1971-01-21 | 1973-01-03 | Republican | 1 | |||||||||||||
30004 | 30004 | Alvin O’Konski O000058 | rep | WI | 1971-01-21 | 1973-01-03 | Republican | 10 | |||||||||||||
30019 | 30019 | Thomas Pelly P000196 | rep | WA | 1971-01-21 | 1973-01-03 | Republican | 1 | |||||||||||||
30026 | 30026 | Alexander Pirnie P000366 | rep | NY | 1971-01-21 | 1973-01-03 | Republican | 32 | |||||||||||||
30036 | 30036 | Richard Poff P000401 | rep | VA | 1971-01-21 | 1973-01-03 | Republican | 6 | |||||||||||||
30054 | 30054 | Charlotte Reid R000143 | rep | IL | 1971-01-21 | 1973-01-03 | Republican | 15 | |||||||||||||
30062 | 30062 | John Schmitz S000133 | rep | CA | 1971-01-21 | 1973-01-03 | Republican | 35 | |||||||||||||
30070 | 30070 | Frederick Schwengel S000161 | rep | IA | 1971-01-21 | 1973-01-03 | Republican | 1 | |||||||||||||
30081 | 30081 | Hugh Scott S000174 | sen | PA | 1971-01-21 | 1977-01-03 | 1 | Republican | |||||||||||||
30089 | 30089 | H. Smith S000545 | rep | CA | 1971-01-21 | 1973-01-03 | Republican | 20 | |||||||||||||
30100 | 30100 | William Springer S000756 | rep | IL | 1971-01-21 | 1973-01-03 | Republican | 22 | |||||||||||||
30108 | 30108 | Robert Taft T000010 | sen | OH | 1971-01-21 | 1976-12-28 | 1 | Republican | |||||||||||||
30109 | 30109 | John Terry T000134 | rep | NY | 1971-01-21 | 1973-01-03 | Republican | 34 | |||||||||||||
30112 | 30112 | Standish Thompson T000217 | rep | GA | 1971-01-21 | 1973-01-03 | Republican | 5 | |||||||||||||
30134 | 30134 | John Whalley W000320 | rep | PA | 1971-01-21 | 1973-01-03 | Republican | 12 | |||||||||||||
30156 | 30156 | Leslie Arends A000216 | rep | IL | 1971-01-21 | 1973-01-03 | Republican | 17 | |||||||||||||
30158 | 30158 | LaMar Baker B000069 | rep | TN | 1971-01-21 | 1973-01-03 | Republican | 3 | |||||||||||||
30163 | 30163 | Benjamin Blackburn B000506 | rep | GA | 1971-01-21 | 1973-01-03 | Republican | 4 | |||||||||||||
30193 | 30193 | William Bray B000778 | rep | IN | 1971-01-21 | 1973-01-03 | Republican | 6 | |||||||||||||
30200 | 30200 | Donald Brotzman B000893 | rep | CO | 1971-01-21 | 1973-01-03 | Republican | 2 | |||||||||||||
30211 | 30211 | Joel Broyhill B000967 | rep | VA | 1971-01-21 | 1973-01-03 | Republican | 10 | |||||||||||||
30214 | 30214 | John Camp C000073 | rep | OK | 1971-01-21 | 1973-01-03 | Republican | 6 | |||||||||||||
30239 | 30239 | Charles Chamberlain C000275 | rep | MI | 1971-01-21 | 1973-01-03 | Republican | 6 | |||||||||||||
30259 | 30259 | Harold Collier C000629 | rep | IL | 1971-01-21 | 1973-01-03 | Republican | 10 | |||||||||||||
30284 | 30284 | Glenn Davis D000102 | rep | WI | 1971-01-21 | 1973-01-03 | Republican | 9 | |||||||||||||
30295 | 30295 | John Dellenback D000220 | rep | OR | 1971-01-21 | 1973-01-03 | Republican | 4 | |||||||||||||
30300 | 30300 | David Dennis D000241 | rep | IN | 1971-01-21 | 1973-01-03 | Republican | 10 | |||||||||||||
30369 | 30369 | Peter Frelinghuysen F000371 | rep | NJ | 1971-01-21 | 1973-01-03 | Republican | 5 | |||||||||||||
30382 | 30382 | George Goodling G000290 | rep | PA | 1971-01-21 | 1973-01-03 | Republican | 19 | |||||||||||||
30425 | 30425 | Harold Gross G000495 | rep | IA | 1971-01-21 | 1973-01-03 | Republican | 3 | |||||||||||||
30431 | 30431 | James Grover G000504 | rep | NY | 1971-01-21 | 1973-01-03 | Republican | 2 | |||||||||||||
30442 | 30442 | Charles Gubser G000512 | rep | CA | 1971-01-21 | 1973-01-03 | Republican | 10 | |||||||||||||
30463 | 30463 | Orval Hansen H000175 | rep | ID | 1971-01-21 | 1973-01-03 | Republican | 2 | |||||||||||||
30470 | 30470 | James Harvey H000306 | rep | MI | 1971-01-21 | 1973-01-03 | Republican | 8 | |||||||||||||
30479 | 30479 | Lawrence Hogan H000692 | rep | MD | 1971-01-21 | 1973-01-03 | Republican | 5 | |||||||||||||
30506 | 30506 | Craig Hosmer H000802 | rep | CA | 1971-01-21 | 1973-01-03 | Republican | 32 | |||||||||||||
30512 | 30512 | John Hunt H000972 | rep | NJ | 1971-01-21 | 1973-01-03 | Republican | 1 | |||||||||||||
30514 | 30514 | William Keating K000037 | rep | OH | 1971-01-21 | 1973-01-03 | Republican | 1 | |||||||||||||
30521 | 30521 | Carleton King K000195 | rep | NY | 1971-01-21 | 1973-01-03 | Republican | 30 | |||||||||||||
30525 | 30525 | Dan Kuykendall K000348 | rep | TN | 1971-01-21 | 1973-01-03 | Republican | 9 | |||||||||||||
30532 | 30532 | Earl Landgrebe L000049 | rep | IN | 1971-01-21 | 1973-01-03 | Republican | 2 | |||||||||||||
30543 | 30543 | William Mailliard M000070 | rep | CA | 1971-01-21 | 1973-01-03 | Republican | 6 | |||||||||||||
30545 | 30545 | Richard Mallary M000078 | rep | VT | 1971-01-21 | 1973-01-03 | Republican | 0 | |||||||||||||
30553 | 30553 | David Martin M000175 | rep | NE | 1971-01-21 | 1973-01-03 | Republican | 3 | |||||||||||||
30557 | 30557 | Robert Mathias M000242 | rep | CA | 1971-01-21 | 1973-01-03 | Republican | 18 | |||||||||||||
30561 | 30561 | Wiley Mayne M000286 | rep | IA | 1971-01-21 | 1973-01-03 | Republican | 6 | |||||||||||||
30582 | 30582 | William Mills M000779 | rep | MD | 1971-01-21 | 1973-01-03 | Republican | 1 | |||||||||||||
30592 | 30592 | William Minshall M000799 | rep | OH | 1971-01-21 | 1973-01-03 | Republican | 23 | |||||||||||||
30595 | 30595 | Wilmer Mizell M000833 | rep | NC | 1971-01-21 | 1973-01-03 | Republican | 5 | |||||||||||||
30606 | 30606 | Ancher Nelsen N000028 | rep | MN | 1971-01-21 | 1973-01-03 | Republican | 2 | |||||||||||||
30615 | 30615 | Walter Powell P000485 | rep | OH | 1971-01-21 | 1973-01-03 | Republican | 24 | |||||||||||||
30619 | 30619 | Robert Price P000528 | rep | TX | 1971-01-21 | 1973-01-03 | Republican | 18 | |||||||||||||
30638 | 30638 | Howard Robison R000357 | rep | NY | 1971-01-21 | 1973-01-03 | Republican | 33 | |||||||||||||
30660 | 30660 | Earl Ruth R000545 | rep | NC | 1971-01-21 | 1973-01-03 | Republican | 8 | |||||||||||||
30664 | 30664 | Charles Sandman S000045 | rep | NJ | 1971-01-21 | 1973-01-03 | Republican | 2 | |||||||||||||
30677 | 30677 | John Saylor S000102 | rep | PA | 1971-01-21 | 1973-01-03 | Republican | 22 | |||||||||||||
30681 | 30681 | William Scherle S000121 | rep | IA | 1971-01-21 | 1973-01-03 | Republican | 7 | |||||||||||||
30685 | 30685 | William Scott S000189 | rep | VA | 1971-01-21 | 1973-01-03 | Republican | 8 | |||||||||||||
30687 | 30687 | Richard Shoup S000383 | rep | MT | 1971-01-21 | 1973-01-03 | Republican | 1 | |||||||||||||
30692 | 30692 | Henry Smith S000548 | rep | NY | 1971-01-21 | 1973-01-03 | Republican | 40 | |||||||||||||
30706 | 30706 | Robert Steele S000836 | rep | CT | 1971-01-21 | 1973-01-03 | Republican | 2 | |||||||||||||
30724 | 30724 | Charles Teague T000109 | rep | CA | 1971-01-21 | 1973-01-03 | Republican | 13 | |||||||||||||
30731 | 30731 | Vernon Thomson T000233 | rep | WI | 1971-01-21 | 1973-01-03 | Republican | 3 | |||||||||||||
30738 | 30738 | Victor Veysey V000093 | rep | CA | 1971-01-21 | 1973-01-03 | Republican | 38 | |||||||||||||
30746 | 30746 | John Ware W000147 | rep | PA | 1971-01-21 | 1973-01-03 | Republican | 9 | |||||||||||||
30759 | 30759 | William Widnall W000445 | rep | NJ | 1971-01-21 | 1973-01-03 | Republican | 7 | |||||||||||||
30763 | 30763 | Lawrence Williams W000525 | rep | PA | 1971-01-21 | 1973-01-03 | Republican | 7 | |||||||||||||
30769 | 30769 | Wendell Wyatt W000778 | rep | OR | 1971-01-21 | 1973-01-03 | Republican | 1 | |||||||||||||
30775 | 30775 | Roger Zion Z000010 | rep | IN | 1971-01-21 | 1973-01-03 | Republican | 8 | |||||||||||||
30779 | 30779 | John Zwach Z000016 | rep | MN | 1971-01-21 | 1973-01-03 | Republican | 6 | |||||||||||||
30784 | 30784 | Louis Wyman W000782 | rep | NH | 1971-01-21 | 1973-01-03 | Republican | 1 | |||||||||||||
30798 | 30798 | Gerald Ford F000260 | rep | MI | 1971-01-21 | 1973-01-03 | Republican | 5 | |||||||||||||
30843 | 30843 | Alphonzo Bell B000330 | rep | CA | 1971-01-21 | 1973-01-03 | Republican | 28 | |||||||||||||
30852 | 30852 | Edward Biester B000451 | rep | PA | 1971-01-21 | 1973-01-03 | Republican | 8 | |||||||||||||
30873 | 30873 | Donald Clancy C000409 | rep | OH | 1971-01-21 | 1973-01-03 | Republican | 2 | |||||||||||||
30913 | 30913 | Marvin Esch E000213 | rep | MI | 1971-01-21 | 1973-01-03 | Republican | 2 |
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);