legislator_terms
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
482 rows where "start" is on date 1969-01-03 sorted by start
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
29865 | 29865 | Charles Jonas J000206 | rep | NC | 1969-01-03 | 1971-01-03 | Republican | 9 | |||||||||||||
29869 | 29869 | James Kee K000038 | rep | WV | 1969-01-03 | 1971-01-03 | Democrat | 5 | |||||||||||||
29876 | 29876 | Hastings Keith K000053 | rep | MA | 1969-01-03 | 1971-01-03 | Republican | 12 | |||||||||||||
29882 | 29882 | John Kyl K000351 | rep | IA | 1969-01-03 | 1971-01-03 | Republican | 4 | |||||||||||||
29891 | 29891 | Alton Lennon L000240 | rep | NC | 1969-01-03 | 1971-01-03 | Democrat | 7 | |||||||||||||
29896 | 29896 | Sherman Lloyd L000382 | rep | UT | 1969-01-03 | 1971-01-03 | Republican | 2 | |||||||||||||
29900 | 29900 | Speedy Long L000429 | rep | LA | 1969-01-03 | 1971-01-03 | Democrat | 8 | |||||||||||||
29922 | 29922 | William McCulloch M000393 | rep | OH | 1969-01-03 | 1971-01-03 | Republican | 4 | |||||||||||||
29925 | 29925 | Jack McDonald M000410 | rep | MI | 1969-01-03 | 1971-01-03 | Republican | 19 | |||||||||||||
29946 | 29946 | John McMillan M000568 | rep | SC | 1969-01-03 | 1971-01-03 | Democrat | 6 | |||||||||||||
29960 | 29960 | George Miller M000727 | rep | CA | 1969-01-03 | 1971-01-03 | Democrat | 8 | |||||||||||||
29967 | 29967 | John Monagan M000847 | rep | CT | 1969-01-03 | 1971-01-03 | Democrat | 5 | |||||||||||||
29980 | 29980 | Frank Morse M001009 | rep | MA | 1969-01-03 | 1971-01-03 | Republican | 5 | |||||||||||||
29985 | 29985 | Rogers Morton M001021 | rep | MD | 1969-01-03 | 1971-01-03 | Republican | 1 | |||||||||||||
30003 | 30003 | Alvin O’Konski O000058 | rep | WI | 1969-01-03 | 1971-01-03 | Republican | 10 | |||||||||||||
30018 | 30018 | Thomas Pelly P000196 | rep | WA | 1969-01-03 | 1971-01-03 | Republican | 1 | |||||||||||||
30025 | 30025 | Alexander Pirnie P000366 | rep | NY | 1969-01-03 | 1971-01-03 | Republican | 32 | |||||||||||||
30035 | 30035 | Richard Poff P000401 | rep | VA | 1969-01-03 | 1971-01-03 | Republican | 6 | |||||||||||||
30042 | 30042 | Roman Pucinski P000559 | rep | IL | 1969-01-03 | 1971-01-03 | Democrat | 11 | |||||||||||||
30048 | 30048 | Graham Purcell P000569 | rep | TX | 1969-01-03 | 1971-01-03 | Democrat | 13 | |||||||||||||
30053 | 30053 | Charlotte Reid R000143 | rep | IL | 1969-01-03 | 1971-01-03 | Republican | 15 | |||||||||||||
30059 | 30059 | William Ryan R000562 | rep | NY | 1969-01-03 | 1971-01-03 | Democrat | 20 | |||||||||||||
30061 | 30061 | John Schmitz S000133 | rep | CA | 1969-01-03 | 1971-01-03 | Republican | 35 | |||||||||||||
30069 | 30069 | Frederick Schwengel S000161 | rep | IA | 1969-01-03 | 1971-01-03 | Republican | 1 | |||||||||||||
30088 | 30088 | H. Smith S000545 | rep | CA | 1969-01-03 | 1971-01-03 | Republican | 20 | |||||||||||||
30099 | 30099 | William Springer S000756 | rep | IL | 1969-01-03 | 1971-01-03 | Republican | 22 | |||||||||||||
30107 | 30107 | Robert Taft T000010 | rep | OH | 1969-01-03 | 1971-01-03 | Republican | 1 | |||||||||||||
30111 | 30111 | Standish Thompson T000217 | rep | GA | 1969-01-03 | 1971-01-03 | Republican | 5 | |||||||||||||
30115 | 30115 | John Tunney T000410 | rep | CA | 1969-01-03 | 1971-01-03 | Democrat | 38 | |||||||||||||
30126 | 30126 | John Watts W000212 | rep | KY | 1969-01-03 | 1971-01-03 | Democrat | 6 | |||||||||||||
30133 | 30133 | John Whalley W000320 | rep | PA | 1969-01-03 | 1971-01-03 | Republican | 12 | |||||||||||||
30155 | 30155 | Leslie Arends A000216 | rep | IL | 1969-01-03 | 1971-01-03 | Republican | 17 | |||||||||||||
30162 | 30162 | Benjamin Blackburn B000506 | rep | GA | 1969-01-03 | 1971-01-03 | Republican | 4 | |||||||||||||
30176 | 30176 | John Blatnik B000550 | rep | MN | 1969-01-03 | 1971-01-03 | Democrat | 8 | |||||||||||||
30180 | 30180 | Frank Brasco B000771 | rep | NY | 1969-01-03 | 1971-01-03 | Democrat | 11 | |||||||||||||
30192 | 30192 | William Bray B000778 | rep | IN | 1969-01-03 | 1971-01-03 | Republican | 6 | |||||||||||||
30199 | 30199 | Donald Brotzman B000893 | rep | CO | 1969-01-03 | 1971-01-03 | Republican | 2 | |||||||||||||
30210 | 30210 | Joel Broyhill B000967 | rep | VA | 1969-01-03 | 1971-01-03 | Republican | 10 | |||||||||||||
30213 | 30213 | John Camp C000073 | rep | OK | 1969-01-03 | 1971-01-03 | Republican | 6 | |||||||||||||
30220 | 30220 | Hugh Carey C000143 | rep | NY | 1969-01-03 | 1971-01-03 | Democrat | 15 | |||||||||||||
30238 | 30238 | Charles Chamberlain C000275 | rep | MI | 1969-01-03 | 1971-01-03 | Republican | 6 | |||||||||||||
30248 | 30248 | Frank Clark C000431 | rep | PA | 1969-01-03 | 1971-01-03 | Democrat | 25 | |||||||||||||
30258 | 30258 | Harold Collier C000629 | rep | IL | 1969-01-03 | 1971-01-03 | Republican | 10 | |||||||||||||
30283 | 30283 | Glenn Davis D000102 | rep | WI | 1969-01-03 | 1971-01-03 | Republican | 9 | |||||||||||||
30290 | 30290 | John Davis D000122 | rep | GA | 1969-01-03 | 1971-01-03 | Democrat | 7 | |||||||||||||
30294 | 30294 | John Dellenback D000220 | rep | OR | 1969-01-03 | 1971-01-03 | Republican | 4 | |||||||||||||
30299 | 30299 | David Dennis D000241 | rep | IN | 1969-01-03 | 1971-01-03 | Republican | 10 | |||||||||||||
30313 | 30313 | Harold Donohue D000419 | rep | MA | 1969-01-03 | 1971-01-03 | Democrat | 4 | |||||||||||||
30326 | 30326 | William Dorn D000434 | rep | SC | 1969-01-03 | 1971-01-03 | Democrat | 3 | |||||||||||||
30334 | 30334 | Thaddeus Dulski D000523 | rep | NY | 1969-01-03 | 1971-01-03 | Democrat | 41 | |||||||||||||
30357 | 30357 | Ovie Fisher F000152 | rep | TX | 1969-01-03 | 1971-01-03 | Democrat | 21 | |||||||||||||
30368 | 30368 | Peter Frelinghuysen F000371 | rep | NJ | 1969-01-03 | 1971-01-03 | Republican | 5 | |||||||||||||
30375 | 30375 | Thomas Gettys G000144 | rep | SC | 1969-01-03 | 1971-01-03 | Democrat | 5 | |||||||||||||
30381 | 30381 | George Goodling G000290 | rep | PA | 1969-01-03 | 1971-01-03 | Republican | 19 | |||||||||||||
30393 | 30393 | Edith Green G000407 | rep | OR | 1969-01-03 | 1971-01-03 | Democrat | 3 | |||||||||||||
30411 | 30411 | Martha Griffiths G000471 | rep | MI | 1969-01-03 | 1971-01-03 | Democrat | 17 | |||||||||||||
30424 | 30424 | Harold Gross G000495 | rep | IA | 1969-01-03 | 1971-01-03 | Republican | 3 | |||||||||||||
30430 | 30430 | James Grover G000504 | rep | NY | 1969-01-03 | 1971-01-03 | Republican | 2 | |||||||||||||
30441 | 30441 | Charles Gubser G000512 | rep | CA | 1969-01-03 | 1971-01-03 | Republican | 10 | |||||||||||||
30448 | 30448 | Richard Hanna H000164 | rep | CA | 1969-01-03 | 1971-01-03 | Democrat | 34 | |||||||||||||
30459 | 30459 | Julia Hansen H000174 | rep | WA | 1969-01-03 | 1971-01-03 | Democrat | 3 | |||||||||||||
30462 | 30462 | Orval Hansen H000175 | rep | ID | 1969-01-03 | 1971-01-03 | Republican | 2 | |||||||||||||
30469 | 30469 | James Harvey H000306 | rep | MI | 1969-01-03 | 1971-01-03 | Republican | 8 | |||||||||||||
30475 | 30475 | William Hathaway H000346 | rep | ME | 1969-01-03 | 1971-01-03 | Democrat | 2 | |||||||||||||
30478 | 30478 | Lawrence Hogan H000692 | rep | MD | 1969-01-03 | 1971-01-03 | Republican | 5 | |||||||||||||
30494 | 30494 | Chester Holifield H000713 | rep | CA | 1969-01-03 | 1971-01-03 | Democrat | 19 | |||||||||||||
30505 | 30505 | Craig Hosmer H000802 | rep | CA | 1969-01-03 | 1971-01-03 | Republican | 32 | |||||||||||||
30511 | 30511 | John Hunt H000972 | rep | NJ | 1969-01-03 | 1971-01-03 | Republican | 1 | |||||||||||||
30520 | 30520 | Carleton King K000195 | rep | NY | 1969-01-03 | 1971-01-03 | Republican | 30 | |||||||||||||
30524 | 30524 | Dan Kuykendall K000348 | rep | TN | 1969-01-03 | 1971-01-03 | Republican | 9 | |||||||||||||
30528 | 30528 | Peter Kyros K000356 | rep | ME | 1969-01-03 | 1971-01-03 | Democrat | 1 | |||||||||||||
30531 | 30531 | Earl Landgrebe L000049 | rep | IN | 1969-01-03 | 1971-01-03 | Republican | 2 | |||||||||||||
30542 | 30542 | William Mailliard M000070 | rep | CA | 1969-01-03 | 1971-01-03 | Republican | 6 | |||||||||||||
30552 | 30552 | David Martin M000175 | rep | NE | 1969-01-03 | 1971-01-03 | Republican | 3 | |||||||||||||
30556 | 30556 | Robert Mathias M000242 | rep | CA | 1969-01-03 | 1971-01-03 | Republican | 18 | |||||||||||||
30560 | 30560 | Wiley Mayne M000286 | rep | IA | 1969-01-03 | 1971-01-03 | Republican | 6 | |||||||||||||
30591 | 30591 | William Minshall M000799 | rep | OH | 1969-01-03 | 1971-01-03 | Republican | 23 | |||||||||||||
30594 | 30594 | Wilmer Mizell M000833 | rep | NC | 1969-01-03 | 1971-01-03 | Republican | 5 | |||||||||||||
30605 | 30605 | Ancher Nelsen N000028 | rep | MN | 1969-01-03 | 1971-01-03 | Republican | 2 | |||||||||||||
30612 | 30612 | Bertram Podell P000399 | rep | NY | 1969-01-03 | 1971-01-03 | Democrat | 13 | |||||||||||||
30618 | 30618 | Robert Price P000528 | rep | TX | 1969-01-03 | 1971-01-03 | Republican | 18 | |||||||||||||
30622 | 30622 | John Rarick R000065 | rep | LA | 1969-01-03 | 1971-01-03 | Democrat | 6 | |||||||||||||
30628 | 30628 | Ogden Reid R000150 | rep | NY | 1969-01-03 | 1971-01-03 | Republican | 26 | |||||||||||||
30637 | 30637 | Howard Robison R000357 | rep | NY | 1969-01-03 | 1971-01-03 | Republican | 33 | |||||||||||||
30654 | 30654 | John Rooney R000424 | rep | NY | 1969-01-03 | 1971-01-03 | Democrat | 14 | |||||||||||||
30659 | 30659 | Earl Ruth R000545 | rep | NC | 1969-01-03 | 1971-01-03 | Republican | 8 | |||||||||||||
30663 | 30663 | Charles Sandman S000045 | rep | NJ | 1969-01-03 | 1971-01-03 | Republican | 2 | |||||||||||||
30676 | 30676 | John Saylor S000102 | rep | PA | 1969-01-03 | 1971-01-03 | Republican | 22 | |||||||||||||
30680 | 30680 | William Scherle S000121 | rep | IA | 1969-01-03 | 1971-01-03 | Republican | 7 | |||||||||||||
30684 | 30684 | William Scott S000189 | rep | VA | 1969-01-03 | 1971-01-03 | Republican | 8 | |||||||||||||
30691 | 30691 | Henry Smith S000548 | rep | NY | 1969-01-03 | 1971-01-03 | Republican | 40 | |||||||||||||
30705 | 30705 | Robert Steele S000836 | rep | CT | 1969-01-03 | 1971-01-03 | Republican | 2 | |||||||||||||
30713 | 30713 | Frank Stubblefield S001037 | rep | KY | 1969-01-03 | 1971-01-03 | Democrat | 1 | |||||||||||||
30723 | 30723 | Charles Teague T000109 | rep | CA | 1969-01-03 | 1971-01-03 | Republican | 13 | |||||||||||||
30730 | 30730 | Vernon Thomson T000233 | rep | WI | 1969-01-03 | 1971-01-03 | Republican | 3 | |||||||||||||
30734 | 30734 | Robert Tiernan T000265 | rep | RI | 1969-01-03 | 1971-01-03 | Democrat | 2 | |||||||||||||
30742 | 30742 | Jerome Waldie W000035 | rep | CA | 1969-01-03 | 1971-01-03 | Democrat | 14 | |||||||||||||
30745 | 30745 | John Ware W000147 | rep | PA | 1969-01-03 | 1971-01-03 | Republican | 9 | |||||||||||||
30758 | 30758 | William Widnall W000445 | rep | NJ | 1969-01-03 | 1971-01-03 | Republican | 7 | |||||||||||||
30762 | 30762 | Lawrence Williams W000525 | rep | PA | 1969-01-03 | 1971-01-03 | Republican | 7 |
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);