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 party descending
This data as json, copyable, CSV (advanced)
Suggested facets: type, 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
29097 | 29097 | Marlow Cook C000721 | sen | KY | 1969-01-03 | 1974-12-27 | 3 | Republican | |||||||||||||
29112 | 29112 | Edwin Adair A000024 | rep | IN | 1969-01-03 | 1971-01-03 | Republican | 4 | |||||||||||||
29118 | 29118 | George Aiken A000062 | sen | VT | 1969-01-03 | 1975-01-03 | 3 | Republican | |||||||||||||
29128 | 29128 | William Ayres A000229 | rep | OH | 1969-01-03 | 1971-01-03 | Republican | 14 | |||||||||||||
29139 | 29139 | William Bates B000239 | rep | MA | 1969-01-03 | 1971-01-03 | Republican | 6 | |||||||||||||
29144 | 29144 | James Battin B000241 | rep | MT | 1969-01-03 | 1971-01-03 | Republican | 2 | |||||||||||||
29148 | 29148 | Wallace Bennett B000384 | sen | UT | 1969-01-03 | 1974-12-20 | 3 | Republican | |||||||||||||
29158 | 29158 | Ellis Berry B000416 | rep | SD | 1969-01-03 | 1971-01-03 | Republican | 2 | |||||||||||||
29166 | 29166 | Laurence Burton B001155 | rep | UT | 1969-01-03 | 1971-01-03 | Republican | 1 | |||||||||||||
29168 | 29168 | Daniel Button B001201 | rep | NY | 1969-01-03 | 1971-01-03 | Republican | 29 | |||||||||||||
29174 | 29174 | William Cahill C000019 | rep | NJ | 1969-01-03 | 1971-01-03 | Republican | 6 | |||||||||||||
29182 | 29182 | William Cowger C000823 | rep | KY | 1969-01-03 | 1971-01-03 | Republican | 3 | |||||||||||||
29190 | 29190 | William Cramer C000869 | rep | FL | 1969-01-03 | 1971-01-03 | Republican | 8 | |||||||||||||
29197 | 29197 | Glenn Cunningham C000991 | rep | NE | 1969-01-03 | 1971-01-03 | Republican | 2 | |||||||||||||
29219 | 29219 | Robert Denney D000239 | rep | NE | 1969-01-03 | 1971-01-03 | Republican | 1 | |||||||||||||
29222 | 29222 | Peter Dominick D000409 | sen | CO | 1969-01-03 | 1975-01-03 | 3 | Republican | |||||||||||||
29270 | 29270 | Edgar Foreman F000272 | rep | NM | 1969-01-03 | 1971-01-03 | Republican | 2 | |||||||||||||
29295 | 29295 | Edward Gurney G000531 | sen | FL | 1969-01-03 | 1975-01-03 | 3 | Republican | |||||||||||||
29320 | 29320 | Thomas Kleppe K000264 | rep | ND | 1969-01-03 | 1971-01-03 | Republican | 2 | |||||||||||||
29329 | 29329 | Melvin Laird L000024 | rep | WI | 1969-01-03 | 1971-01-03 | Republican | 7 | |||||||||||||
29335 | 29335 | Odin Langen L000069 | rep | MN | 1969-01-03 | 1971-01-03 | Republican | 7 | |||||||||||||
29344 | 29344 | Glenard Lipscomb L000344 | rep | CA | 1969-01-03 | 1971-01-03 | Republican | 24 | |||||||||||||
29350 | 29350 | Clark MacGregor M000010 | rep | MN | 1969-01-03 | 1971-01-03 | Republican | 3 | |||||||||||||
29360 | 29360 | Catherine May M000273 | rep | WA | 1969-01-03 | 1971-01-03 | Republican | 4 | |||||||||||||
29386 | 29386 | Martin McKneally M000530 | rep | NY | 1969-01-03 | 1971-01-03 | Republican | 27 | |||||||||||||
29388 | 29388 | Thomas Meskill M000667 | rep | CT | 1969-01-03 | 1971-01-03 | Republican | 6 | |||||||||||||
29391 | 29391 | Chester Mize M000832 | rep | KS | 1969-01-03 | 1971-01-03 | Republican | 2 | |||||||||||||
29421 | 29421 | Howard Pollock P000415 | rep | AK | 1969-01-03 | 1971-01-03 | Republican | 0 | |||||||||||||
29439 | 29439 | Benjamin Reifel R000152 | rep | SD | 1969-01-03 | 1971-01-03 | Republican | 1 | |||||||||||||
29442 | 29442 | Edwin Reinecke R000159 | rep | CA | 1969-01-03 | 1971-01-03 | Republican | 27 | |||||||||||||
29475 | 29475 | Richard Roudebush R000464 | rep | IN | 1969-01-03 | 1971-01-03 | Republican | 5 | |||||||||||||
29479 | 29479 | Donald Rumsfeld R000508 | rep | IL | 1969-01-03 | 1971-01-03 | Republican | 13 | |||||||||||||
29480 | 29480 | William Saxbe S000096 | sen | OH | 1969-01-03 | 1974-01-03 | 3 | Republican | |||||||||||||
29484 | 29484 | Henry Schadeberg S000108 | rep | WI | 1969-01-03 | 1971-01-03 | Republican | 1 | |||||||||||||
29498 | 29498 | James Utt U000034 | rep | CA | 1969-01-03 | 1971-01-03 | Republican | 35 | |||||||||||||
29501 | 29501 | George Watkins W000192 | rep | PA | 1969-01-03 | 1971-01-03 | Republican | 9 | |||||||||||||
29505 | 29505 | Albert Watson W000197 | rep | SC | 1969-01-03 | 1971-01-03 | Republican | 2 | |||||||||||||
29506 | 29506 | John Wold W000671 | rep | WY | 1969-01-03 | 1971-01-03 | Republican | 0 | |||||||||||||
29581 | 29581 | John Beall B000272 | rep | MD | 1969-01-03 | 1971-01-03 | Republican | 6 | |||||||||||||
29593 | 29593 | Page Belcher B000323 | rep | OK | 1969-01-03 | 1971-01-03 | Republican | 1 | |||||||||||||
29604 | 29604 | Jackson Betts B000426 | rep | OH | 1969-01-03 | 1971-01-03 | Republican | 8 | |||||||||||||
29632 | 29632 | Frank Bow B000676 | rep | OH | 1969-01-03 | 1971-01-03 | Republican | 16 | |||||||||||||
29637 | 29637 | William Brock B000851 | rep | TN | 1969-01-03 | 1971-01-03 | Republican | 3 | |||||||||||||
29662 | 29662 | John Byrnes B001216 | rep | WI | 1969-01-03 | 1971-01-03 | Republican | 8 | |||||||||||||
29730 | 29730 | Robert Corbett C000772 | rep | PA | 1969-01-03 | 1971-01-03 | Republican | 18 | |||||||||||||
29755 | 29755 | Florence Dwyer D000587 | rep | NJ | 1969-01-03 | 1971-01-03 | Republican | 12 | |||||||||||||
29788 | 29788 | James Fulton F000422 | rep | PA | 1969-01-03 | 1971-01-03 | Republican | 27 | |||||||||||||
29827 | 29827 | Durward Hall H000049 | rep | MO | 1969-01-03 | 1971-01-03 | Republican | 7 | |||||||||||||
29834 | 29834 | Seymour Halpern H000085 | rep | NY | 1969-01-03 | 1971-01-03 | Republican | 6 | |||||||||||||
29865 | 29865 | Charles Jonas J000206 | rep | NC | 1969-01-03 | 1971-01-03 | Republican | 9 | |||||||||||||
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 | |||||||||||||
29896 | 29896 | Sherman Lloyd L000382 | rep | UT | 1969-01-03 | 1971-01-03 | Republican | 2 | |||||||||||||
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 | |||||||||||||
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 | |||||||||||||
30053 | 30053 | Charlotte Reid R000143 | rep | IL | 1969-01-03 | 1971-01-03 | Republican | 15 | |||||||||||||
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 | |||||||||||||
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 | |||||||||||||
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 | |||||||||||||
30238 | 30238 | Charles Chamberlain C000275 | rep | MI | 1969-01-03 | 1971-01-03 | Republican | 6 | |||||||||||||
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 | |||||||||||||
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 | |||||||||||||
30368 | 30368 | Peter Frelinghuysen F000371 | rep | NJ | 1969-01-03 | 1971-01-03 | Republican | 5 | |||||||||||||
30381 | 30381 | George Goodling G000290 | rep | PA | 1969-01-03 | 1971-01-03 | Republican | 19 | |||||||||||||
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 | |||||||||||||
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 | |||||||||||||
30478 | 30478 | Lawrence Hogan H000692 | rep | MD | 1969-01-03 | 1971-01-03 | Republican | 5 | |||||||||||||
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 | |||||||||||||
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 |
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);