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 legislator_id
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
34512 | 34512 | John Hammerschmidt H000124 | rep | AR | 1969-01-03 | 1971-01-03 | Republican | 3 | |||||||||||||
32091 | 32091 | James Hanley H000158 | rep | NY | 1969-01-03 | 1971-01-03 | Democrat | 34 | |||||||||||||
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 | |||||||||||||
31585 | 31585 | Michael Harrington H000230 | rep | MA | 1969-01-03 | 1971-01-03 | Democrat | 6 | |||||||||||||
32104 | 32104 | William Harsha H000281 | rep | OH | 1969-01-03 | 1971-01-03 | Republican | 6 | |||||||||||||
30469 | 30469 | James Harvey H000306 | rep | MI | 1969-01-03 | 1971-01-03 | Republican | 8 | |||||||||||||
30970 | 30970 | James Hastings H000327 | rep | NY | 1969-01-03 | 1971-01-03 | Republican | 38 | |||||||||||||
30475 | 30475 | William Hathaway H000346 | rep | ME | 1969-01-03 | 1971-01-03 | Democrat | 2 | |||||||||||||
33936 | 33936 | Augustus Hawkins H000367 | rep | CA | 1969-01-03 | 1971-01-03 | Democrat | 21 | |||||||||||||
30985 | 30985 | Wayne Hays H000408 | rep | OH | 1969-01-03 | 1971-01-03 | Democrat | 18 | |||||||||||||
31049 | 31049 | Felix Hébert H000437 | rep | LA | 1969-01-03 | 1971-01-03 | Democrat | 1 | |||||||||||||
30994 | 30994 | Kenneth Hechler H000438 | rep | WV | 1969-01-03 | 1971-01-03 | Democrat | 4 | |||||||||||||
32705 | 32705 | Margaret Heckler H000440 | rep | MA | 1969-01-03 | 1971-01-03 | Republican | 10 | |||||||||||||
31000 | 31000 | Henry Helstoski H000465 | rep | NJ | 1969-01-03 | 1971-01-03 | Democrat | 9 | |||||||||||||
31008 | 31008 | David Henderson H000479 | rep | NC | 1969-01-03 | 1971-01-03 | Democrat | 3 | |||||||||||||
31014 | 31014 | Floyd Hicks H000563 | rep | WA | 1969-01-03 | 1971-01-03 | Democrat | 6 | |||||||||||||
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 | |||||||||||||
36650 | 36650 | Ernest Hollings H000725 | sen | SC | 1969-01-03 | 1975-01-03 | 3 | Democrat | |||||||||||||
34566 | 34566 | Frank Horton H000797 | rep | NY | 1969-01-03 | 1971-01-03 | Republican | 36 | |||||||||||||
30505 | 30505 | Craig Hosmer H000802 | rep | CA | 1969-01-03 | 1971-01-03 | Republican | 32 | |||||||||||||
33602 | 33602 | James Howard H000840 | rep | NJ | 1969-01-03 | 1971-01-03 | Democrat | 3 | |||||||||||||
29296 | 29296 | Harold Hughes H000922 | sen | IA | 1969-01-03 | 1975-01-03 | 3 | Democrat | |||||||||||||
29855 | 29855 | William Hull H000947 | rep | MO | 1969-01-03 | 1971-01-03 | Democrat | 6 | |||||||||||||
31024 | 31024 | William Hungate H000965 | rep | MO | 1969-01-03 | 1971-01-03 | Democrat | 9 | |||||||||||||
30511 | 30511 | John Hunt H000972 | rep | NJ | 1969-01-03 | 1971-01-03 | Republican | 1 | |||||||||||||
31031 | 31031 | J. Hutchinson H001011 | rep | MI | 1969-01-03 | 1971-01-03 | Republican | 4 | |||||||||||||
32121 | 32121 | Richard Ichord I000001 | rep | MO | 1969-01-03 | 1971-01-03 | Democrat | 8 | |||||||||||||
39022 | 39022 | Daniel Inouye I000025 | sen | HI | 1969-01-03 | 1975-01-03 | 3 | Democrat | |||||||||||||
35865 | 35865 | Andrew Jacobs J000033 | rep | IN | 1969-01-03 | 1971-01-03 | Democrat | 11 | |||||||||||||
31062 | 31062 | John Jarman J000057 | rep | OK | 1969-01-03 | 1971-01-03 | Democrat | 5 | |||||||||||||
31072 | 31072 | Jacob Javits J000064 | sen | NY | 1969-01-03 | 1975-01-03 | 3 | Republican | |||||||||||||
29301 | 29301 | Charles Joelson J000108 | rep | NJ | 1969-01-03 | 1971-01-03 | Democrat | 8 | |||||||||||||
31077 | 31077 | Albert Johnson J000115 | rep | PA | 1969-01-03 | 1971-01-03 | Republican | 23 | |||||||||||||
32136 | 32136 | Harold Johnson J000135 | rep | CA | 1969-01-03 | 1971-01-03 | Democrat | 2 | |||||||||||||
29865 | 29865 | Charles Jonas J000206 | rep | NC | 1969-01-03 | 1971-01-03 | Republican | 9 | |||||||||||||
33612 | 33612 | Ed Jones J000216 | rep | TN | 1969-01-03 | 1971-01-03 | Democrat | 8 | |||||||||||||
31092 | 31092 | Robert Jones J000248 | rep | AL | 1969-01-03 | 1971-01-03 | Democrat | 8 | |||||||||||||
34622 | 34622 | Walter Jones J000256 | rep | NC | 1969-01-03 | 1971-01-03 | Democrat | 1 | |||||||||||||
31101 | 31101 | Joseph Karth K000014 | rep | MN | 1969-01-03 | 1971-01-03 | Democrat | 4 | |||||||||||||
33963 | 33963 | Robert Kastenmeier K000020 | rep | WI | 1969-01-03 | 1971-01-03 | Democrat | 2 | |||||||||||||
33012 | 33012 | Abraham Kazen K000025 | rep | TX | 1969-01-03 | 1971-01-03 | Democrat | 23 | |||||||||||||
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 | |||||||||||||
30520 | 30520 | Carleton King K000195 | rep | NY | 1969-01-03 | 1971-01-03 | Republican | 30 | |||||||||||||
29318 | 29318 | Michael Kirwan K000244 | rep | OH | 1969-01-03 | 1971-01-03 | Democrat | 19 | |||||||||||||
29320 | 29320 | Thomas Kleppe K000264 | rep | ND | 1969-01-03 | 1971-01-03 | Republican | 2 | |||||||||||||
31114 | 31114 | John Kluczynski K000273 | rep | IL | 1969-01-03 | 1971-01-03 | Democrat | 5 | |||||||||||||
31605 | 31605 | Edward Koch K000302 | rep | NY | 1969-01-03 | 1971-01-03 | Democrat | 17 | |||||||||||||
30524 | 30524 | Dan Kuykendall K000348 | rep | TN | 1969-01-03 | 1971-01-03 | Republican | 9 | |||||||||||||
29882 | 29882 | John Kyl K000351 | rep | IA | 1969-01-03 | 1971-01-03 | Republican | 4 | |||||||||||||
30528 | 30528 | Peter Kyros K000356 | rep | ME | 1969-01-03 | 1971-01-03 | Democrat | 1 | |||||||||||||
29329 | 29329 | Melvin Laird L000024 | rep | WI | 1969-01-03 | 1971-01-03 | Republican | 7 | |||||||||||||
30531 | 30531 | Earl Landgrebe L000049 | rep | IN | 1969-01-03 | 1971-01-03 | Republican | 2 | |||||||||||||
31126 | 31126 | Phillip Landrum L000054 | rep | GA | 1969-01-03 | 1971-01-03 | Democrat | 9 | |||||||||||||
29335 | 29335 | Odin Langen L000069 | rep | MN | 1969-01-03 | 1971-01-03 | Republican | 7 | |||||||||||||
33642 | 33642 | Delbert Latta L000116 | rep | OH | 1969-01-03 | 1971-01-03 | Republican | 5 | |||||||||||||
31616 | 31616 | Robert Leggett L000221 | rep | CA | 1969-01-03 | 1971-01-03 | Democrat | 4 | |||||||||||||
29891 | 29891 | Alton Lennon L000240 | rep | NC | 1969-01-03 | 1971-01-03 | Democrat | 7 | |||||||||||||
29344 | 29344 | Glenard Lipscomb L000344 | rep | CA | 1969-01-03 | 1971-01-03 | Republican | 24 | |||||||||||||
29896 | 29896 | Sherman Lloyd L000382 | rep | UT | 1969-01-03 | 1971-01-03 | Republican | 2 | |||||||||||||
33031 | 33031 | Clarence Long L000413 | rep | MD | 1969-01-03 | 1971-01-03 | Democrat | 2 | |||||||||||||
32737 | 32737 | Russell Long L000428 | sen | LA | 1969-01-03 | 1975-01-03 | 3 | Democrat | |||||||||||||
29900 | 29900 | Speedy Long L000429 | rep | LA | 1969-01-03 | 1971-01-03 | Democrat | 8 | |||||||||||||
29345 | 29345 | Allard Lowenstein L000477 | rep | NY | 1969-01-03 | 1971-01-03 | Democrat | 5 | |||||||||||||
33657 | 33657 | Manuel Luján L000506 | rep | NM | 1969-01-03 | 1971-01-03 | Republican | 1 | |||||||||||||
33995 | 33995 | Donald Lukens L000509 | rep | OH | 1969-01-03 | 1971-01-03 | Republican | 24 | |||||||||||||
31139 | 31139 | Torbert Macdonald M000005 | rep | MA | 1969-01-03 | 1971-01-03 | Democrat | 7 | |||||||||||||
29350 | 29350 | Clark MacGregor M000010 | rep | MN | 1969-01-03 | 1971-01-03 | Republican | 3 | |||||||||||||
31156 | 31156 | Ray Madden M000039 | rep | IN | 1969-01-03 | 1971-01-03 | Democrat | 1 | |||||||||||||
31169 | 31169 | Warren Magnuson M000053 | sen | WA | 1969-01-03 | 1975-01-03 | 3 | Democrat | |||||||||||||
31638 | 31638 | George Mahon M000065 | rep | TX | 1969-01-03 | 1971-01-03 | Democrat | 19 | |||||||||||||
30542 | 30542 | William Mailliard M000070 | rep | CA | 1969-01-03 | 1971-01-03 | Republican | 6 | |||||||||||||
31643 | 31643 | James Mann M000105 | rep | SC | 1969-01-03 | 1971-01-03 | Democrat | 4 | |||||||||||||
29354 | 29354 | John Marsh M000148 | rep | VA | 1969-01-03 | 1971-01-03 | Democrat | 7 | |||||||||||||
30552 | 30552 | David Martin M000175 | rep | NE | 1969-01-03 | 1971-01-03 | Republican | 3 | |||||||||||||
32747 | 32747 | Charles Mathias M000241 | sen | MD | 1969-01-03 | 1975-01-03 | 3 | Republican | |||||||||||||
30556 | 30556 | Robert Mathias M000242 | rep | CA | 1969-01-03 | 1971-01-03 | Republican | 18 | |||||||||||||
34006 | 34006 | Spark Matsunaga M000250 | rep | HI | 1969-01-03 | 1971-01-03 | Democrat | 2 | |||||||||||||
29360 | 29360 | Catherine May M000273 | rep | WA | 1969-01-03 | 1971-01-03 | Republican | 4 | |||||||||||||
30560 | 30560 | Wiley Mayne M000286 | rep | IA | 1969-01-03 | 1971-01-03 | Republican | 6 | |||||||||||||
29363 | 29363 | Richard McCarthy M000318 | rep | NY | 1969-01-03 | 1971-01-03 | Democrat | 39 | |||||||||||||
32757 | 32757 | Robert McClory M000340 | rep | IL | 1969-01-03 | 1971-01-03 | Republican | 12 | |||||||||||||
32765 | 32765 | Paul McCloskey M000343 | rep | CA | 1969-01-03 | 1971-01-03 | Republican | 11 | |||||||||||||
33353 | 33353 | James McClure M000346 | rep | ID | 1969-01-03 | 1971-01-03 | Republican | 1 | |||||||||||||
29385 | 29385 | John McCormack M000364 | rep | MA | 1969-01-03 | 1971-01-03 | Democrat | 9 | |||||||||||||
29922 | 29922 | William McCulloch M000393 | rep | OH | 1969-01-03 | 1971-01-03 | Republican | 4 | |||||||||||||
36298 | 36298 | Joseph McDade M000399 | rep | PA | 1969-01-03 | 1971-01-03 | Republican | 10 | |||||||||||||
29925 | 29925 | Jack McDonald M000410 | rep | MI | 1969-01-03 | 1971-01-03 | Republican | 19 | |||||||||||||
32168 | 32168 | Robert McEwen M000433 | rep | NY | 1969-01-03 | 1971-01-03 | Republican | 31 | |||||||||||||
31654 | 31654 | John McFall M000436 | rep | CA | 1969-01-03 | 1971-01-03 | Democrat | 15 | |||||||||||||
31177 | 31177 | George McGovern M000452 | sen | SD | 1969-01-03 | 1975-01-03 | 3 | Democrat | |||||||||||||
29386 | 29386 | Martin McKneally M000530 | rep | NY | 1969-01-03 | 1971-01-03 | Republican | 27 | |||||||||||||
29946 | 29946 | John McMillan M000568 | rep | SC | 1969-01-03 | 1971-01-03 | Democrat | 6 | |||||||||||||
31661 | 31661 | Lloyd Meeds M000626 | rep | WA | 1969-01-03 | 1971-01-03 | Democrat | 2 | |||||||||||||
33055 | 33055 | John Melcher M000635 | rep | MT | 1969-01-03 | 1971-01-03 | Democrat | 2 | |||||||||||||
29388 | 29388 | Thomas Meskill M000667 | rep | CT | 1969-01-03 | 1971-01-03 | Republican | 6 | |||||||||||||
35434 | 35434 | Robert Michel M000692 | rep | IL | 1969-01-03 | 1971-01-03 | Republican | 18 |
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);