legislator_terms
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
477 rows where "start" is on date 1973-01-03
This data as json, copyable, CSV (advanced)
Suggested facets: state, 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
30137 | 30137 | James Abourezk A000017 | sen | SD | 1973-01-03 | 1979-01-03 | 2 | Democrat | |||||||||||||
30157 | 30157 | Leslie Arends A000216 | rep | IL | 1973-01-03 | 1975-01-03 | Republican | 15 | |||||||||||||
30159 | 30159 | LaMar Baker B000069 | rep | TN | 1973-01-03 | 1975-01-03 | Republican | 3 | |||||||||||||
30160 | 30160 | Dewey Bartlett B000200 | sen | OK | 1973-01-03 | 1979-01-03 | 2 | Republican | |||||||||||||
30164 | 30164 | Benjamin Blackburn B000506 | rep | GA | 1973-01-03 | 1975-01-03 | Republican | 4 | |||||||||||||
30178 | 30178 | John Blatnik B000550 | rep | MN | 1973-01-03 | 1975-01-03 | Democrat | 8 | |||||||||||||
30182 | 30182 | Frank Brasco B000771 | rep | NY | 1973-01-03 | 1975-01-03 | Democrat | 11 | |||||||||||||
30194 | 30194 | William Bray B000778 | rep | IN | 1973-01-03 | 1975-01-03 | Republican | 6 | |||||||||||||
30196 | 30196 | Edward Brooke B000871 | sen | MA | 1973-01-03 | 1979-01-03 | 2 | Republican | |||||||||||||
30201 | 30201 | Donald Brotzman B000893 | rep | CO | 1973-01-03 | 1975-01-03 | Republican | 2 | |||||||||||||
30212 | 30212 | Joel Broyhill B000967 | rep | VA | 1973-01-03 | 1975-01-03 | Republican | 10 | |||||||||||||
30215 | 30215 | John Camp C000073 | rep | OK | 1973-01-03 | 1975-01-03 | Republican | 6 | |||||||||||||
30222 | 30222 | Hugh Carey C000143 | rep | NY | 1973-01-03 | 1975-01-03 | Democrat | 15 | |||||||||||||
30231 | 30231 | Clifford Case C000220 | sen | NJ | 1973-01-03 | 1979-01-03 | 2 | Republican | |||||||||||||
30240 | 30240 | Charles Chamberlain C000275 | rep | MI | 1973-01-03 | 1975-01-03 | Republican | 6 | |||||||||||||
30250 | 30250 | Frank Clark C000431 | rep | PA | 1973-01-03 | 1975-01-03 | Democrat | 25 | |||||||||||||
30251 | 30251 | Richard Clark C000448 | sen | IA | 1973-01-03 | 1979-01-03 | 2 | Democrat | |||||||||||||
30260 | 30260 | Harold Collier C000629 | rep | IL | 1973-01-03 | 1975-01-03 | Republican | 6 | |||||||||||||
30263 | 30263 | Paul Cronin C000925 | rep | MA | 1973-01-03 | 1975-01-03 | Republican | 5 | |||||||||||||
30275 | 30275 | Carl Curtis C001006 | sen | NE | 1973-01-03 | 1979-01-03 | 2 | Republican | |||||||||||||
30285 | 30285 | Glenn Davis D000102 | rep | WI | 1973-01-03 | 1975-01-03 | Republican | 9 | |||||||||||||
30292 | 30292 | John Davis D000122 | rep | GA | 1973-01-03 | 1975-01-03 | Democrat | 7 | |||||||||||||
30296 | 30296 | John Dellenback D000220 | rep | OR | 1973-01-03 | 1975-01-03 | Republican | 4 | |||||||||||||
30298 | 30298 | Frank Denholm D000234 | rep | SD | 1973-01-03 | 1975-01-03 | Democrat | 1 | |||||||||||||
30301 | 30301 | David Dennis D000241 | rep | IN | 1973-01-03 | 1975-01-03 | Republican | 10 | |||||||||||||
30315 | 30315 | Harold Donohue D000419 | rep | MA | 1973-01-03 | 1975-01-03 | Democrat | 3 | |||||||||||||
30328 | 30328 | William Dorn D000434 | rep | SC | 1973-01-03 | 1975-01-03 | Democrat | 3 | |||||||||||||
30336 | 30336 | Thaddeus Dulski D000523 | rep | NY | 1973-01-03 | 1975-01-03 | Democrat | 37 | |||||||||||||
30343 | 30343 | James Eastland E000018 | sen | MS | 1973-01-03 | 1979-01-03 | 2 | Democrat | |||||||||||||
30359 | 30359 | Ovie Fisher F000152 | rep | TX | 1973-01-03 | 1975-01-03 | Democrat | 21 | |||||||||||||
30370 | 30370 | Peter Frelinghuysen F000371 | rep | NJ | 1973-01-03 | 1975-01-03 | Republican | 5 | |||||||||||||
30371 | 30371 | Harold Froehlich F000388 | rep | WI | 1973-01-03 | 1975-01-03 | Republican | 8 | |||||||||||||
30377 | 30377 | Thomas Gettys G000144 | rep | SC | 1973-01-03 | 1975-01-03 | Democrat | 5 | |||||||||||||
30383 | 30383 | George Goodling G000290 | rep | PA | 1973-01-03 | 1975-01-03 | Republican | 19 | |||||||||||||
30385 | 30385 | Ella Grasso G000387 | rep | CT | 1973-01-03 | 1975-01-03 | Democrat | 6 | |||||||||||||
30395 | 30395 | Edith Green G000407 | rep | OR | 1973-01-03 | 1975-01-03 | Democrat | 3 | |||||||||||||
30403 | 30403 | Robert Griffin G000465 | sen | MI | 1973-01-03 | 1979-01-03 | 2 | Republican | |||||||||||||
30413 | 30413 | Martha Griffiths G000471 | rep | MI | 1973-01-03 | 1975-01-03 | Democrat | 17 | |||||||||||||
30426 | 30426 | Harold Gross G000495 | rep | IA | 1973-01-03 | 1975-01-03 | Republican | 3 | |||||||||||||
30432 | 30432 | James Grover G000504 | rep | NY | 1973-01-03 | 1975-01-03 | Republican | 2 | |||||||||||||
30443 | 30443 | Charles Gubser G000512 | rep | CA | 1973-01-03 | 1975-01-03 | Republican | 10 | |||||||||||||
30444 | 30444 | William Gunter G000528 | rep | FL | 1973-01-03 | 1975-01-03 | Democrat | 5 | |||||||||||||
30450 | 30450 | Richard Hanna H000164 | rep | CA | 1973-01-03 | 1975-01-03 | Democrat | 34 | |||||||||||||
30451 | 30451 | Robert Hanrahan H000168 | rep | IL | 1973-01-03 | 1975-01-03 | Republican | 3 | |||||||||||||
30453 | 30453 | Clifford Hansen H000170 | sen | WY | 1973-01-03 | 1979-01-03 | 2 | Republican | |||||||||||||
30461 | 30461 | Julia Hansen H000174 | rep | WA | 1973-01-03 | 1975-01-03 | Democrat | 3 | |||||||||||||
30464 | 30464 | Orval Hansen H000175 | rep | ID | 1973-01-03 | 1975-01-03 | Republican | 2 | |||||||||||||
30471 | 30471 | James Harvey H000306 | rep | MI | 1973-01-03 | 1975-01-03 | Republican | 8 | |||||||||||||
30472 | 30472 | Floyd Haskell H000317 | sen | CO | 1973-01-03 | 1979-01-03 | 2 | Democrat | |||||||||||||
30477 | 30477 | William Hathaway H000346 | sen | ME | 1973-01-03 | 1979-01-03 | 2 | Democrat | |||||||||||||
30480 | 30480 | Lawrence Hogan H000692 | rep | MD | 1973-01-03 | 1975-01-03 | Republican | 5 | |||||||||||||
30496 | 30496 | Chester Holifield H000713 | rep | CA | 1973-01-03 | 1975-01-03 | Democrat | 19 | |||||||||||||
30507 | 30507 | Craig Hosmer H000802 | rep | CA | 1973-01-03 | 1975-01-03 | Republican | 32 | |||||||||||||
30508 | 30508 | Robert Huber H000897 | rep | MI | 1973-01-03 | 1975-01-03 | Republican | 18 | |||||||||||||
30509 | 30509 | William Hudnut H000906 | rep | IN | 1973-01-03 | 1975-01-03 | Republican | 11 | |||||||||||||
30513 | 30513 | John Hunt H000972 | rep | NJ | 1973-01-03 | 1975-01-03 | Republican | 1 | |||||||||||||
30515 | 30515 | William Keating K000037 | rep | OH | 1973-01-03 | 1975-01-03 | Republican | 1 | |||||||||||||
30522 | 30522 | Carleton King K000195 | rep | NY | 1973-01-03 | 1975-01-03 | Republican | 29 | |||||||||||||
30526 | 30526 | Dan Kuykendall K000348 | rep | TN | 1973-01-03 | 1975-01-03 | Republican | 8 | |||||||||||||
30530 | 30530 | Peter Kyros K000356 | rep | ME | 1973-01-03 | 1975-01-03 | Democrat | 1 | |||||||||||||
30533 | 30533 | Earl Landgrebe L000049 | rep | IN | 1973-01-03 | 1975-01-03 | Republican | 2 | |||||||||||||
30544 | 30544 | William Mailliard M000070 | rep | CA | 1973-01-03 | 1975-01-03 | Republican | 6 | |||||||||||||
30546 | 30546 | Richard Mallary M000078 | rep | VT | 1973-01-03 | 1975-01-03 | Republican | 0 | |||||||||||||
30547 | 30547 | Joseph Maraziti M000121 | rep | NJ | 1973-01-03 | 1975-01-03 | Republican | 13 | |||||||||||||
30554 | 30554 | David Martin M000175 | rep | NE | 1973-01-03 | 1975-01-03 | Republican | 3 | |||||||||||||
30558 | 30558 | Robert Mathias M000242 | rep | CA | 1973-01-03 | 1975-01-03 | Republican | 18 | |||||||||||||
30562 | 30562 | Wiley Mayne M000286 | rep | IA | 1973-01-03 | 1975-01-03 | Republican | 6 | |||||||||||||
30570 | 30570 | John McClellan M000332 | sen | AR | 1973-01-03 | 1977-12-31 | 2 | Democrat | |||||||||||||
30573 | 30573 | Thomas McIntyre M000486 | sen | NH | 1973-01-03 | 1979-01-03 | 2 | Democrat | |||||||||||||
30574 | 30574 | Clem McSpadden M000603 | rep | OK | 1973-01-03 | 1975-01-03 | Democrat | 2 | |||||||||||||
30581 | 30581 | Lee Metcalf M000671 | sen | MT | 1973-01-03 | 1978-01-12 | 2 | Democrat | |||||||||||||
30583 | 30583 | William Mills M000779 | rep | MD | 1973-01-03 | 1975-01-03 | Republican | 1 | |||||||||||||
30593 | 30593 | William Minshall M000799 | rep | OH | 1973-01-03 | 1975-01-03 | Republican | 23 | |||||||||||||
30596 | 30596 | Wilmer Mizell M000833 | rep | NC | 1973-01-03 | 1975-01-03 | Republican | 5 | |||||||||||||
30599 | 30599 | Walter Mondale M000851 | sen | MN | 1973-01-03 | 1976-12-30 | 2 | Democrat | |||||||||||||
30607 | 30607 | Ancher Nelsen N000028 | rep | MN | 1973-01-03 | 1975-01-03 | Republican | 2 | |||||||||||||
30610 | 30610 | James Pearson P000166 | sen | KS | 1973-01-03 | 1978-12-23 | 2 | Republican | |||||||||||||
30614 | 30614 | Bertram Podell P000399 | rep | NY | 1973-01-03 | 1975-01-03 | Democrat | 13 | |||||||||||||
30616 | 30616 | Walter Powell P000485 | rep | OH | 1973-01-03 | 1975-01-03 | Republican | 8 | |||||||||||||
30620 | 30620 | Robert Price P000528 | rep | TX | 1973-01-03 | 1975-01-03 | Republican | 13 | |||||||||||||
30624 | 30624 | John Rarick R000065 | rep | LA | 1973-01-03 | 1975-01-03 | Democrat | 6 | |||||||||||||
30630 | 30630 | Ogden Reid R000150 | rep | NY | 1973-01-03 | 1975-01-03 | Democrat | 24 | |||||||||||||
30639 | 30639 | Howard Robison R000357 | rep | NY | 1973-01-03 | 1975-01-03 | Republican | 27 | |||||||||||||
30640 | 30640 | Angelo Roncallo R000422 | rep | NY | 1973-01-03 | 1975-01-03 | Republican | 3 | |||||||||||||
30656 | 30656 | John Rooney R000424 | rep | NY | 1973-01-03 | 1975-01-03 | Democrat | 14 | |||||||||||||
30658 | 30658 | William Roy R000484 | rep | KS | 1973-01-03 | 1975-01-03 | Democrat | 2 | |||||||||||||
30661 | 30661 | Earl Ruth R000545 | rep | NC | 1973-01-03 | 1975-01-03 | Republican | 8 | |||||||||||||
30665 | 30665 | Charles Sandman S000045 | rep | NJ | 1973-01-03 | 1975-01-03 | Republican | 2 | |||||||||||||
30678 | 30678 | John Saylor S000102 | rep | PA | 1973-01-03 | 1975-01-03 | Republican | 12 | |||||||||||||
30682 | 30682 | William Scherle S000121 | rep | IA | 1973-01-03 | 1975-01-03 | Republican | 5 | |||||||||||||
30686 | 30686 | William Scott S000189 | sen | VA | 1973-01-03 | 1979-01-03 | 2 | Republican | |||||||||||||
30688 | 30688 | Richard Shoup S000383 | rep | MT | 1973-01-03 | 1975-01-03 | Republican | 1 | |||||||||||||
30693 | 30693 | Henry Smith S000548 | rep | NY | 1973-01-03 | 1975-01-03 | Republican | 36 | |||||||||||||
30704 | 30704 | John Sparkman S000701 | sen | AL | 1973-01-03 | 1979-01-03 | 2 | Democrat | |||||||||||||
30707 | 30707 | Robert Steele S000836 | rep | CT | 1973-01-03 | 1975-01-03 | Republican | 2 | |||||||||||||
30715 | 30715 | Frank Stubblefield S001037 | rep | KY | 1973-01-03 | 1975-01-03 | Democrat | 1 | |||||||||||||
30725 | 30725 | Charles Teague T000109 | rep | CA | 1973-01-03 | 1975-01-03 | Republican | 13 | |||||||||||||
30732 | 30732 | Vernon Thomson T000233 | rep | WI | 1973-01-03 | 1975-01-03 | Republican | 3 | |||||||||||||
30736 | 30736 | Robert Tiernan T000265 | rep | RI | 1973-01-03 | 1975-01-03 | Democrat | 2 | |||||||||||||
30737 | 30737 | David Towell T000321 | rep | NV | 1973-01-03 | 1975-01-03 | Republican | 0 |
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);