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
This data as json, copyable, CSV (advanced)
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
30249 | 30249 | Frank Clark C000431 | rep | PA | 1971-01-21 | 1973-01-03 | Democrat | 25 | |||||||||||||
30259 | 30259 | Harold Collier C000629 | rep | IL | 1971-01-21 | 1973-01-03 | Republican | 10 | |||||||||||||
30262 | 30262 | George Collins C000637 | rep | IL | 1971-01-21 | 1972-12-08 | Democrat | 6 | |||||||||||||
30284 | 30284 | Glenn Davis D000102 | rep | WI | 1971-01-21 | 1973-01-03 | Republican | 9 | |||||||||||||
30291 | 30291 | John Davis D000122 | rep | GA | 1971-01-21 | 1973-01-03 | Democrat | 7 | |||||||||||||
30295 | 30295 | John Dellenback D000220 | rep | OR | 1971-01-21 | 1973-01-03 | Republican | 4 | |||||||||||||
30297 | 30297 | Frank Denholm D000234 | rep | SD | 1971-01-21 | 1973-01-03 | Democrat | 1 | |||||||||||||
30300 | 30300 | David Dennis D000241 | rep | IN | 1971-01-21 | 1973-01-03 | Republican | 10 | |||||||||||||
30314 | 30314 | Harold Donohue D000419 | rep | MA | 1971-01-21 | 1973-01-03 | Democrat | 4 | |||||||||||||
30327 | 30327 | William Dorn D000434 | rep | SC | 1971-01-21 | 1973-01-03 | Democrat | 3 | |||||||||||||
30335 | 30335 | Thaddeus Dulski D000523 | rep | NY | 1971-01-21 | 1973-01-03 | Democrat | 41 | |||||||||||||
30358 | 30358 | Ovie Fisher F000152 | rep | TX | 1971-01-21 | 1973-01-03 | Democrat | 21 | |||||||||||||
30369 | 30369 | Peter Frelinghuysen F000371 | rep | NJ | 1971-01-21 | 1973-01-03 | Republican | 5 | |||||||||||||
30376 | 30376 | Thomas Gettys G000144 | rep | SC | 1971-01-21 | 1973-01-03 | Democrat | 5 | |||||||||||||
30382 | 30382 | George Goodling G000290 | rep | PA | 1971-01-21 | 1973-01-03 | Republican | 19 | |||||||||||||
30384 | 30384 | Ella Grasso G000387 | rep | CT | 1971-01-21 | 1973-01-03 | Democrat | 6 | |||||||||||||
30394 | 30394 | Edith Green G000407 | rep | OR | 1971-01-21 | 1973-01-03 | Democrat | 3 | |||||||||||||
30412 | 30412 | Martha Griffiths G000471 | rep | MI | 1971-01-21 | 1973-01-03 | Democrat | 17 | |||||||||||||
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 | |||||||||||||
30449 | 30449 | Richard Hanna H000164 | rep | CA | 1971-01-21 | 1973-01-03 | Democrat | 34 | |||||||||||||
30460 | 30460 | Julia Hansen H000174 | rep | WA | 1971-01-21 | 1973-01-03 | Democrat | 3 | |||||||||||||
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 | |||||||||||||
30476 | 30476 | William Hathaway H000346 | rep | ME | 1971-01-21 | 1973-01-03 | Democrat | 2 | |||||||||||||
30479 | 30479 | Lawrence Hogan H000692 | rep | MD | 1971-01-21 | 1973-01-03 | Republican | 5 | |||||||||||||
30495 | 30495 | Chester Holifield H000713 | rep | CA | 1971-01-21 | 1973-01-03 | Democrat | 19 | |||||||||||||
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 | |||||||||||||
30529 | 30529 | Peter Kyros K000356 | rep | ME | 1971-01-21 | 1973-01-03 | Democrat | 1 | |||||||||||||
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 | |||||||||||||
30613 | 30613 | Bertram Podell P000399 | rep | NY | 1971-01-21 | 1973-01-03 | Democrat | 13 | |||||||||||||
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 | |||||||||||||
30623 | 30623 | John Rarick R000065 | rep | LA | 1971-01-21 | 1973-01-03 | Democrat | 6 | |||||||||||||
30629 | 30629 | Ogden Reid R000150 | rep | NY | 1971-01-21 | 1973-01-03 | Democrat | 26 | [ { "start": "1971-01-21", "end": "1972-03-22", "party": "Republican" }, { "start": "1972-03-22", "end": "1973-01-03", "party": "Democrat" } ] |
||||||||||||
30638 | 30638 | Howard Robison R000357 | rep | NY | 1971-01-21 | 1973-01-03 | Republican | 33 | |||||||||||||
30655 | 30655 | John Rooney R000424 | rep | NY | 1971-01-21 | 1973-01-03 | Democrat | 14 | |||||||||||||
30657 | 30657 | William Roy R000484 | rep | KS | 1971-01-21 | 1973-01-03 | Democrat | 2 | |||||||||||||
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 | |||||||||||||
30714 | 30714 | Frank Stubblefield S001037 | rep | KY | 1971-01-21 | 1973-01-03 | Democrat | 1 | |||||||||||||
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 | |||||||||||||
30735 | 30735 | Robert Tiernan T000265 | rep | RI | 1971-01-21 | 1973-01-03 | Democrat | 2 | |||||||||||||
30738 | 30738 | Victor Veysey V000093 | rep | CA | 1971-01-21 | 1973-01-03 | Republican | 38 | |||||||||||||
30743 | 30743 | Jerome Waldie W000035 | rep | CA | 1971-01-21 | 1973-01-03 | Democrat | 14 | |||||||||||||
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 | |||||||||||||
30800 | 30800 | Bella Abzug A000018 | rep | NY | 1971-01-21 | 1973-01-03 | Democrat | 19 | |||||||||||||
30815 | 30815 | Carl Albert A000073 | rep | OK | 1971-01-21 | 1973-01-03 | Democrat | 3 | |||||||||||||
30832 | 30832 | William Barrett B000178 | rep | PA | 1971-01-21 | 1973-01-03 | Democrat | 1 | |||||||||||||
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 | |||||||||||||
30861 | 30861 | Robert Casey C000228 | rep | TX | 1971-01-21 | 1973-01-03 | Democrat | 22 | |||||||||||||
30873 | 30873 | Donald Clancy C000409 | rep | OH | 1971-01-21 | 1973-01-03 | Republican | 2 | |||||||||||||
30889 | 30889 | John Culver C000979 | rep | IA | 1971-01-21 | 1973-01-03 | Democrat | 2 | |||||||||||||
30898 | 30898 | Dominick Daniels D000041 | rep | NJ | 1971-01-21 | 1973-01-03 | Democrat | 14 | |||||||||||||
30907 | 30907 | Thomas Downing D000474 | rep | VA | 1971-01-21 | 1973-01-03 | Democrat | 1 | |||||||||||||
30913 | 30913 | Marvin Esch E000213 | rep | MI | 1971-01-21 | 1973-01-03 | Republican | 2 | |||||||||||||
30918 | 30918 | Edwin Eshleman E000214 | rep | PA | 1971-01-21 | 1973-01-03 | Republican | 16 | |||||||||||||
30933 | 30933 | Joseph Evins E000273 | rep | TN | 1971-01-21 | 1973-01-03 | Democrat | 4 | |||||||||||||
30940 | 30940 | Richard Fulton F000424 | rep | TN | 1971-01-21 | 1973-01-03 | Democrat | 5 | |||||||||||||
30949 | 30949 | William Green G000420 | rep | PA | 1971-01-21 | 1973-01-03 | Democrat | 5 | |||||||||||||
30954 | 30954 | Gilbert Gude G000513 | rep | MD | 1971-01-21 | 1973-01-03 | Republican | 8 | |||||||||||||
30966 | 30966 | James Haley H000041 | rep | FL | 1971-01-21 | 1973-01-03 | Democrat | 7 | |||||||||||||
30971 | 30971 | James Hastings H000327 | rep | NY | 1971-01-21 | 1973-01-03 | Republican | 38 | |||||||||||||
30986 | 30986 | Wayne Hays H000408 | rep | OH | 1971-01-21 | 1973-01-03 | Democrat | 18 | |||||||||||||
30995 | 30995 | Kenneth Hechler H000438 | rep | WV | 1971-01-21 | 1973-01-03 | Democrat | 4 | |||||||||||||
31001 | 31001 | Henry Helstoski H000465 | rep | NJ | 1971-01-21 | 1973-01-03 | Democrat | 9 | |||||||||||||
31009 | 31009 | David Henderson H000479 | rep | NC | 1971-01-21 | 1973-01-03 | Democrat | 3 | |||||||||||||
31015 | 31015 | Floyd Hicks H000563 | rep | WA | 1971-01-21 | 1973-01-03 | Democrat | 6 | |||||||||||||
31025 | 31025 | William Hungate H000965 | rep | MO | 1971-01-21 | 1973-01-03 | Democrat | 9 | |||||||||||||
31032 | 31032 | J. Hutchinson H001011 | rep | MI | 1971-01-21 | 1973-01-03 | Republican | 4 | |||||||||||||
31050 | 31050 | Felix Hébert H000437 | rep | LA | 1971-01-21 | 1973-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);