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 class
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
30872 | 30872 | Donald Clancy C000409 | rep | OH | 1969-01-03 | 1971-01-03 | Republican | 2 | |||||||||||||
30888 | 30888 | John Culver C000979 | rep | IA | 1969-01-03 | 1971-01-03 | Democrat | 2 | |||||||||||||
30897 | 30897 | Dominick Daniels D000041 | rep | NJ | 1969-01-03 | 1971-01-03 | Democrat | 14 | |||||||||||||
30906 | 30906 | Thomas Downing D000474 | rep | VA | 1969-01-03 | 1971-01-03 | Democrat | 1 | |||||||||||||
30912 | 30912 | Marvin Esch E000213 | rep | MI | 1969-01-03 | 1971-01-03 | Republican | 2 | |||||||||||||
30917 | 30917 | Edwin Eshleman E000214 | rep | PA | 1969-01-03 | 1971-01-03 | Republican | 16 | |||||||||||||
30932 | 30932 | Joseph Evins E000273 | rep | TN | 1969-01-03 | 1971-01-03 | Democrat | 4 | |||||||||||||
30939 | 30939 | Richard Fulton F000424 | rep | TN | 1969-01-03 | 1971-01-03 | Democrat | 5 | |||||||||||||
30948 | 30948 | William Green G000420 | rep | PA | 1969-01-03 | 1971-01-03 | Democrat | 5 | |||||||||||||
30953 | 30953 | Gilbert Gude G000513 | rep | MD | 1969-01-03 | 1971-01-03 | Republican | 8 | |||||||||||||
30965 | 30965 | James Haley H000041 | rep | FL | 1969-01-03 | 1971-01-03 | Democrat | 7 | |||||||||||||
30970 | 30970 | James Hastings H000327 | rep | NY | 1969-01-03 | 1971-01-03 | Republican | 38 | |||||||||||||
30985 | 30985 | Wayne Hays H000408 | rep | OH | 1969-01-03 | 1971-01-03 | Democrat | 18 | |||||||||||||
30994 | 30994 | Kenneth Hechler H000438 | rep | WV | 1969-01-03 | 1971-01-03 | Democrat | 4 | |||||||||||||
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 | |||||||||||||
31024 | 31024 | William Hungate H000965 | rep | MO | 1969-01-03 | 1971-01-03 | Democrat | 9 | |||||||||||||
31031 | 31031 | J. Hutchinson H001011 | rep | MI | 1969-01-03 | 1971-01-03 | Republican | 4 | |||||||||||||
31049 | 31049 | Felix Hébert H000437 | rep | LA | 1969-01-03 | 1971-01-03 | Democrat | 1 | |||||||||||||
31062 | 31062 | John Jarman J000057 | rep | OK | 1969-01-03 | 1971-01-03 | Democrat | 5 | |||||||||||||
31077 | 31077 | Albert Johnson J000115 | rep | PA | 1969-01-03 | 1971-01-03 | Republican | 23 | |||||||||||||
31092 | 31092 | Robert Jones J000248 | rep | AL | 1969-01-03 | 1971-01-03 | Democrat | 8 | |||||||||||||
31101 | 31101 | Joseph Karth K000014 | rep | MN | 1969-01-03 | 1971-01-03 | Democrat | 4 | |||||||||||||
31114 | 31114 | John Kluczynski K000273 | rep | IL | 1969-01-03 | 1971-01-03 | Democrat | 5 | |||||||||||||
31126 | 31126 | Phillip Landrum L000054 | rep | GA | 1969-01-03 | 1971-01-03 | Democrat | 9 | |||||||||||||
31139 | 31139 | Torbert Macdonald M000005 | rep | MA | 1969-01-03 | 1971-01-03 | Democrat | 7 | |||||||||||||
31156 | 31156 | Ray Madden M000039 | rep | IN | 1969-01-03 | 1971-01-03 | Democrat | 1 | |||||||||||||
31196 | 31196 | Wilbur Mills M000778 | rep | AR | 1969-01-03 | 1971-01-03 | Democrat | 2 | |||||||||||||
31213 | 31213 | Thomas Morgan M000958 | rep | PA | 1969-01-03 | 1971-01-03 | Democrat | 26 | |||||||||||||
31221 | 31221 | Charles Mosher M001031 | rep | OH | 1969-01-03 | 1971-01-03 | Republican | 13 | |||||||||||||
31233 | 31233 | James O’Hara O000055 | rep | MI | 1969-01-03 | 1971-01-03 | Democrat | 12 | |||||||||||||
31248 | 31248 | Otto Passman P000098 | rep | LA | 1969-01-03 | 1971-01-03 | Democrat | 5 | |||||||||||||
31272 | 31272 | John Patman P000103 | rep | TX | 1969-01-03 | 1971-01-03 | Democrat | 1 | |||||||||||||
31277 | 31277 | Jerry Pettis P000272 | rep | CA | 1969-01-03 | 1971-01-03 | Republican | 33 | |||||||||||||
31286 | 31286 | William Randall R000041 | rep | MO | 1969-01-03 | 1971-01-03 | Democrat | 4 | |||||||||||||
31292 | 31292 | Thomas Rees R000134 | rep | CA | 1969-01-03 | 1971-01-03 | Democrat | 26 | |||||||||||||
31314 | 31314 | Herman Schneebeli S000135 | rep | PA | 1969-01-03 | 1971-01-03 | Republican | 17 | |||||||||||||
31328 | 31328 | Garner Shriver S000388 | rep | KS | 1969-01-03 | 1971-01-03 | Republican | 4 | |||||||||||||
31338 | 31338 | Sam Steiger S000846 | rep | AZ | 1969-01-03 | 1971-01-03 | Republican | 3 | |||||||||||||
31346 | 31346 | Robert Stephens S000860 | rep | GA | 1969-01-03 | 1971-01-03 | Democrat | 10 | |||||||||||||
31354 | 31354 | Williamson Stuckey S001039 | rep | GA | 1969-01-03 | 1971-01-03 | Democrat | 8 | |||||||||||||
31366 | 31366 | Leonor Sullivan S001057 | rep | MO | 1969-01-03 | 1971-01-03 | Democrat | 3 | |||||||||||||
31370 | 31370 | James Symington S001134 | rep | MO | 1969-01-03 | 1971-01-03 | Democrat | 2 | |||||||||||||
31377 | 31377 | Burt Talcott T000022 | rep | CA | 1969-01-03 | 1971-01-03 | Republican | 12 | |||||||||||||
31390 | 31390 | Roy Taylor T000099 | rep | NC | 1969-01-03 | 1971-01-03 | Democrat | 11 | |||||||||||||
31398 | 31398 | Joseph Vigorito V000098 | rep | PA | 1969-01-03 | 1971-01-03 | Democrat | 24 | |||||||||||||
31429 | 31429 | Garry Brown B000917 | rep | MI | 1969-01-03 | 1971-01-03 | Republican | 3 | |||||||||||||
31435 | 31435 | J. Burke B001091 | rep | FL | 1969-01-03 | 1971-01-03 | Republican | 10 | |||||||||||||
31445 | 31445 | James Burke B001092 | rep | MA | 1969-01-03 | 1971-01-03 | Democrat | 11 | |||||||||||||
31464 | 31464 | Omar Burleson B001111 | rep | TX | 1969-01-03 | 1971-01-03 | Democrat | 17 | |||||||||||||
31481 | 31481 | Charles Carney C000164 | rep | OH | 1969-01-03 | 1971-01-03 | Democrat | 19 | |||||||||||||
31494 | 31494 | Elford Cederberg C000263 | rep | MI | 1969-01-03 | 1971-01-03 | Republican | 10 | |||||||||||||
31502 | 31502 | Delwin Clawson C000476 | rep | CA | 1969-01-03 | 1971-01-03 | Republican | 23 | |||||||||||||
31522 | 31522 | James Delaney D000211 | rep | NY | 1969-01-03 | 1971-01-03 | Democrat | 9 | |||||||||||||
31533 | 31533 | John Dent D000255 | rep | PA | 1969-01-03 | 1971-01-03 | Democrat | 21 | |||||||||||||
31539 | 31539 | Joshua Eilberg E000096 | rep | PA | 1969-01-03 | 1971-01-03 | Democrat | 4 | |||||||||||||
31546 | 31546 | Frank Evans E000240 | rep | CO | 1969-01-03 | 1971-01-03 | Democrat | 3 | |||||||||||||
31551 | 31551 | Walter Flowers F000218 | rep | AL | 1969-01-03 | 1971-01-03 | Democrat | 5 | |||||||||||||
31564 | 31564 | John Flynt F000229 | rep | GA | 1969-01-03 | 1971-01-03 | Democrat | 6 | |||||||||||||
31572 | 31572 | Donald Fraser F000350 | rep | MN | 1969-01-03 | 1971-01-03 | Democrat | 5 | |||||||||||||
31577 | 31577 | Louis Frey F000381 | rep | FL | 1969-01-03 | 1971-01-03 | Republican | 5 | |||||||||||||
31585 | 31585 | Michael Harrington H000230 | rep | MA | 1969-01-03 | 1971-01-03 | Democrat | 6 | |||||||||||||
31605 | 31605 | Edward Koch K000302 | rep | NY | 1969-01-03 | 1971-01-03 | Democrat | 17 | |||||||||||||
31616 | 31616 | Robert Leggett L000221 | rep | CA | 1969-01-03 | 1971-01-03 | Democrat | 4 | |||||||||||||
31638 | 31638 | George Mahon M000065 | rep | TX | 1969-01-03 | 1971-01-03 | Democrat | 19 | |||||||||||||
31643 | 31643 | James Mann M000105 | rep | SC | 1969-01-03 | 1971-01-03 | Democrat | 4 | |||||||||||||
31654 | 31654 | John McFall M000436 | rep | CA | 1969-01-03 | 1971-01-03 | Democrat | 15 | |||||||||||||
31661 | 31661 | Lloyd Meeds M000626 | rep | WA | 1969-01-03 | 1971-01-03 | Democrat | 2 | |||||||||||||
31683 | 31683 | John Moss M001035 | rep | CA | 1969-01-03 | 1971-01-03 | Democrat | 3 | |||||||||||||
31700 | 31700 | Robert Nix N000113 | rep | PA | 1969-01-03 | 1971-01-03 | Democrat | 2 | |||||||||||||
31713 | 31713 | Otis Pike P000348 | rep | NY | 1969-01-03 | 1971-01-03 | Democrat | 1 | |||||||||||||
31734 | 31734 | William Poage P000398 | rep | TX | 1969-01-03 | 1971-01-03 | Democrat | 11 | |||||||||||||
31745 | 31745 | Albert Quie Q000010 | rep | MN | 1969-01-03 | 1971-01-03 | Republican | 1 | |||||||||||||
31759 | 31759 | Paul Rogers R000401 | rep | FL | 1969-01-03 | 1971-01-03 | Democrat | 9 | |||||||||||||
31772 | 31772 | Frederick Rooney R000423 | rep | PA | 1969-01-03 | 1971-01-03 | Democrat | 15 | |||||||||||||
31778 | 31778 | Philip Ruppe R000512 | rep | MI | 1969-01-03 | 1971-01-03 | Republican | 11 | |||||||||||||
31795 | 31795 | George Shipley S000367 | rep | IL | 1969-01-03 | 1971-01-03 | Democrat | 23 | |||||||||||||
31814 | 31814 | Robert Sikes S000406 | rep | FL | 1969-01-03 | 1971-01-03 | Democrat | 1 | |||||||||||||
31826 | 31826 | Bernice Sisk S000454 | rep | CA | 1969-01-03 | 1971-01-03 | Democrat | 16 | |||||||||||||
31834 | 31834 | Joe Skubitz S000472 | rep | KS | 1969-01-03 | 1971-01-03 | Republican | 5 | |||||||||||||
31841 | 31841 | William Steiger S000847 | rep | WI | 1969-01-03 | 1971-01-03 | Republican | 6 | |||||||||||||
31858 | 31858 | Olin Teague T000110 | rep | TX | 1969-01-03 | 1971-01-03 | Democrat | 6 | |||||||||||||
31873 | 31873 | Joseph Waggonner W000018 | rep | LA | 1969-01-03 | 1971-01-03 | Democrat | 4 | |||||||||||||
31882 | 31882 | Charles Whalen W000317 | rep | OH | 1969-01-03 | 1971-01-03 | Republican | 3 | |||||||||||||
31888 | 31888 | Charles Wiggins W000448 | rep | CA | 1969-01-03 | 1971-01-03 | Republican | 25 | |||||||||||||
31908 | 31908 | John Young Y000043 | rep | TX | 1969-01-03 | 1971-01-03 | Democrat | 14 | |||||||||||||
31924 | 31924 | John Anderson A000195 | rep | IL | 1969-01-03 | 1971-01-03 | Republican | 16 | |||||||||||||
31937 | 31937 | Thomas Ashley A000222 | rep | OH | 1969-01-03 | 1971-01-03 | Democrat | 9 | |||||||||||||
31961 | 31961 | John Brademas B000736 | rep | IN | 1969-01-03 | 1971-01-03 | Democrat | 3 | |||||||||||||
31969 | 31969 | John Buchanan B001008 | rep | AL | 1969-01-03 | 1971-01-03 | Republican | 6 | |||||||||||||
31975 | 31975 | William Burlison B001113 | rep | MO | 1969-01-03 | 1971-01-03 | Democrat | 10 | |||||||||||||
31983 | 31983 | Tim Carter C000201 | rep | KY | 1969-01-03 | 1971-01-03 | Republican | 5 | |||||||||||||
31994 | 31994 | James Cleveland C000512 | rep | NH | 1969-01-03 | 1971-01-03 | Republican | 2 | |||||||||||||
32004 | 32004 | James Corman C000780 | rep | CA | 1969-01-03 | 1971-01-03 | Democrat | 22 | |||||||||||||
32020 | 32020 | Samuel Devine D000279 | rep | OH | 1969-01-03 | 1971-01-03 | Republican | 12 | |||||||||||||
32033 | 32033 | Charles Diggs D000344 | rep | MI | 1969-01-03 | 1971-01-03 | Democrat | 13 | |||||||||||||
32050 | 32050 | Robert Eckhardt E000035 | rep | TX | 1969-01-03 | 1971-01-03 | Democrat | 8 | |||||||||||||
32070 | 32070 | Daniel Flood F000209 | rep | PA | 1969-01-03 | 1971-01-03 | Democrat | 11 | |||||||||||||
32081 | 32081 | Robert Giaimo G000151 | rep | CT | 1969-01-03 | 1971-01-03 | Democrat | 3 |
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);