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 rowid descending
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
32972 | 32972 | Edwin Forsythe F000286 | rep | NJ | 1969-01-03 | 1971-01-03 | Republican | 6 | |||||||||||||
32960 | 32960 | John Erlenborn E000204 | rep | IL | 1969-01-03 | 1971-01-03 | Republican | 14 | |||||||||||||
32950 | 32950 | William Edwards E000084 | rep | AL | 1969-01-03 | 1971-01-03 | Republican | 1 | |||||||||||||
32924 | 32924 | Barber Conable C000666 | rep | NY | 1969-01-03 | 1971-01-03 | Republican | 37 | |||||||||||||
32911 | 32911 | Phillip Burton B001156 | rep | CA | 1969-01-03 | 1971-01-03 | Democrat | 5 | |||||||||||||
32883 | 32883 | Richard White W000390 | rep | TX | 1969-01-03 | 1971-01-03 | Democrat | 16 | |||||||||||||
32873 | 32873 | William Wampler W000121 | rep | VA | 1969-01-03 | 1971-01-03 | Republican | 9 | |||||||||||||
32860 | 32860 | John Stanton S000804 | rep | OH | 1969-01-03 | 1971-01-03 | Republican | 11 | |||||||||||||
32844 | 32844 | John Rousselot R000469 | rep | CA | 1969-01-03 | 1971-01-03 | Republican | 24 | |||||||||||||
32831 | 32831 | John Rhodes R000188 | rep | AZ | 1969-01-03 | 1971-01-03 | Republican | 1 | |||||||||||||
32816 | 32816 | Henry Reuss R000165 | rep | WI | 1969-01-03 | 1971-01-03 | Democrat | 5 | |||||||||||||
32802 | 32802 | Thomas Railsback R000012 | rep | IL | 1969-01-03 | 1971-01-03 | Republican | 19 | |||||||||||||
32783 | 32783 | Robert Mollohan M000845 | rep | WV | 1969-01-03 | 1971-01-03 | Democrat | 1 | |||||||||||||
32765 | 32765 | Paul McCloskey M000343 | rep | CA | 1969-01-03 | 1971-01-03 | Republican | 11 | |||||||||||||
32757 | 32757 | Robert McClory M000340 | rep | IL | 1969-01-03 | 1971-01-03 | Republican | 12 | |||||||||||||
32747 | 32747 | Charles Mathias M000241 | sen | MD | 1969-01-03 | 1975-01-03 | 3 | Republican | |||||||||||||
32737 | 32737 | Russell Long L000428 | sen | LA | 1969-01-03 | 1975-01-03 | 3 | Democrat | |||||||||||||
32705 | 32705 | Margaret Heckler H000440 | rep | MA | 1969-01-03 | 1971-01-03 | Republican | 10 | |||||||||||||
32683 | 32683 | Barry Goldwater G000268 | rep | CA | 1969-01-03 | 1971-01-03 | Republican | 27 | |||||||||||||
32680 | 32680 | Barry Goldwater G000267 | sen | AZ | 1969-01-03 | 1975-01-03 | 3 | Republican | |||||||||||||
32666 | 32666 | Lawrence Fountain F000319 | rep | NC | 1969-01-03 | 1971-01-03 | Democrat | 2 | |||||||||||||
32647 | 32647 | Paul Findley F000123 | rep | IL | 1969-01-03 | 1971-01-03 | Republican | 20 | |||||||||||||
32612 | 32612 | Thomas Eagleton E000004 | sen | MO | 1969-01-03 | 1975-01-03 | 3 | Democrat | |||||||||||||
32601 | 32601 | Edward Derwinski D000269 | rep | IL | 1969-01-03 | 1971-01-03 | Republican | 4 | |||||||||||||
32567 | 32567 | James Collins C000638 | rep | TX | 1969-01-03 | 1971-01-03 | Republican | 3 | |||||||||||||
32559 | 32559 | Donald Clausen C000475 | rep | CA | 1969-01-03 | 1971-01-03 | Republican | 1 | |||||||||||||
32549 | 32549 | Shirley Chisholm C000371 | rep | NY | 1969-01-03 | 1971-01-03 | Democrat | 12 | |||||||||||||
32525 | 32525 | Clarence Brown B000910 | rep | OH | 1969-01-03 | 1971-01-03 | Republican | 7 | |||||||||||||
32512 | 32512 | Jack Brinkley B000839 | rep | GA | 1969-01-03 | 1971-01-03 | Democrat | 3 | |||||||||||||
32499 | 32499 | Richard Bolling B000605 | rep | MO | 1969-01-03 | 1971-01-03 | Democrat | 5 | |||||||||||||
32478 | 32478 | Jonathan Bingham B000472 | rep | NY | 1969-01-03 | 1971-01-03 | Democrat | 23 | |||||||||||||
32450 | 32450 | John Ashbrook A000221 | rep | OH | 1969-01-03 | 1971-01-03 | Republican | 17 | |||||||||||||
32438 | 32438 | Mark Andrews A000208 | rep | ND | 1969-01-03 | 1971-01-03 | Republican | 1 | |||||||||||||
32424 | 32424 | John Wydler W000780 | rep | NY | 1969-01-03 | 1971-01-03 | Republican | 4 | |||||||||||||
32414 | 32414 | Lester Wolff W000680 | rep | NY | 1969-01-03 | 1971-01-03 | Democrat | 3 | |||||||||||||
32406 | 32406 | Robert Wilson W000610 | rep | CA | 1969-01-03 | 1971-01-03 | Republican | 36 | |||||||||||||
32392 | 32392 | Charles Wilson W000571 | rep | CA | 1969-01-03 | 1971-01-03 | Democrat | 31 | |||||||||||||
32383 | 32383 | Charles Vanik V000047 | rep | OH | 1969-01-03 | 1971-01-03 | Democrat | 22 | |||||||||||||
32370 | 32370 | Lionel Van Deerlin V000024 | rep | CA | 1969-01-03 | 1971-01-03 | Democrat | 37 | |||||||||||||
32361 | 32361 | Albert Ullman U000004 | rep | OR | 1969-01-03 | 1971-01-03 | Democrat | 2 | |||||||||||||
32338 | 32338 | Frank Thompson T000200 | rep | NJ | 1969-01-03 | 1971-01-03 | Democrat | 4 | |||||||||||||
32324 | 32324 | Thomas Steed S000829 | rep | OK | 1969-01-03 | 1971-01-03 | Democrat | 4 | |||||||||||||
32308 | 32308 | Harley Staggers S000778 | rep | WV | 1969-01-03 | 1971-01-03 | Democrat | 2 | |||||||||||||
32288 | 32288 | John Slack S000473 | rep | WV | 1969-01-03 | 1971-01-03 | Democrat | 3 | |||||||||||||
32277 | 32277 | Keith Sebelius S000217 | rep | KS | 1969-01-03 | 1971-01-03 | Republican | 1 | |||||||||||||
32271 | 32271 | David Satterfield S000070 | rep | VA | 1969-01-03 | 1971-01-03 | Democrat | 3 | |||||||||||||
32257 | 32257 | Herbert Roberts R000312 | rep | TX | 1969-01-03 | 1971-01-03 | Democrat | 4 | |||||||||||||
32235 | 32235 | Lunsford Preyer P000520 | rep | NC | 1969-01-03 | 1971-01-03 | Democrat | 6 | |||||||||||||
32226 | 32226 | Edward Patten P000106 | rep | NJ | 1969-01-03 | 1971-01-03 | Democrat | 15 | |||||||||||||
32217 | 32217 | Lucien Nedzi N000019 | rep | MI | 1969-01-03 | 1971-01-03 | Democrat | 14 | |||||||||||||
32198 | 32198 | John Murphy M001098 | rep | NY | 1969-01-03 | 1971-01-03 | Democrat | 16 | |||||||||||||
32189 | 32189 | William Moorhead M000930 | rep | PA | 1969-01-03 | 1971-01-03 | Democrat | 14 | |||||||||||||
32179 | 32179 | Abner Mikva M000703 | rep | IL | 1969-01-03 | 1971-01-03 | Democrat | 2 | |||||||||||||
32168 | 32168 | Robert McEwen M000433 | rep | NY | 1969-01-03 | 1971-01-03 | Republican | 31 | |||||||||||||
32136 | 32136 | Harold Johnson J000135 | rep | CA | 1969-01-03 | 1971-01-03 | Democrat | 2 | |||||||||||||
32121 | 32121 | Richard Ichord I000001 | rep | MO | 1969-01-03 | 1971-01-03 | Democrat | 8 | |||||||||||||
32104 | 32104 | William Harsha H000281 | rep | OH | 1969-01-03 | 1971-01-03 | Republican | 6 | |||||||||||||
32091 | 32091 | James Hanley H000158 | rep | NY | 1969-01-03 | 1971-01-03 | Democrat | 34 | |||||||||||||
32081 | 32081 | Robert Giaimo G000151 | rep | CT | 1969-01-03 | 1971-01-03 | Democrat | 3 | |||||||||||||
32070 | 32070 | Daniel Flood F000209 | rep | PA | 1969-01-03 | 1971-01-03 | Democrat | 11 | |||||||||||||
32050 | 32050 | Robert Eckhardt E000035 | rep | TX | 1969-01-03 | 1971-01-03 | Democrat | 8 | |||||||||||||
32033 | 32033 | Charles Diggs D000344 | rep | MI | 1969-01-03 | 1971-01-03 | Democrat | 13 | |||||||||||||
32020 | 32020 | Samuel Devine D000279 | rep | OH | 1969-01-03 | 1971-01-03 | Republican | 12 | |||||||||||||
32004 | 32004 | James Corman C000780 | rep | CA | 1969-01-03 | 1971-01-03 | Democrat | 22 | |||||||||||||
31994 | 31994 | James Cleveland C000512 | rep | NH | 1969-01-03 | 1971-01-03 | Republican | 2 | |||||||||||||
31983 | 31983 | Tim Carter C000201 | rep | KY | 1969-01-03 | 1971-01-03 | Republican | 5 | |||||||||||||
31975 | 31975 | William Burlison B001113 | rep | MO | 1969-01-03 | 1971-01-03 | Democrat | 10 | |||||||||||||
31969 | 31969 | John Buchanan B001008 | rep | AL | 1969-01-03 | 1971-01-03 | Republican | 6 | |||||||||||||
31961 | 31961 | John Brademas B000736 | rep | IN | 1969-01-03 | 1971-01-03 | Democrat | 3 | |||||||||||||
31937 | 31937 | Thomas Ashley A000222 | rep | OH | 1969-01-03 | 1971-01-03 | Democrat | 9 | |||||||||||||
31924 | 31924 | John Anderson A000195 | rep | IL | 1969-01-03 | 1971-01-03 | Republican | 16 | |||||||||||||
31908 | 31908 | John Young Y000043 | rep | TX | 1969-01-03 | 1971-01-03 | Democrat | 14 | |||||||||||||
31888 | 31888 | Charles Wiggins W000448 | rep | CA | 1969-01-03 | 1971-01-03 | Republican | 25 | |||||||||||||
31882 | 31882 | Charles Whalen W000317 | rep | OH | 1969-01-03 | 1971-01-03 | Republican | 3 | |||||||||||||
31873 | 31873 | Joseph Waggonner W000018 | rep | LA | 1969-01-03 | 1971-01-03 | Democrat | 4 | |||||||||||||
31858 | 31858 | Olin Teague T000110 | rep | TX | 1969-01-03 | 1971-01-03 | Democrat | 6 | |||||||||||||
31841 | 31841 | William Steiger S000847 | rep | WI | 1969-01-03 | 1971-01-03 | Republican | 6 | |||||||||||||
31834 | 31834 | Joe Skubitz S000472 | rep | KS | 1969-01-03 | 1971-01-03 | Republican | 5 | |||||||||||||
31826 | 31826 | Bernice Sisk S000454 | rep | CA | 1969-01-03 | 1971-01-03 | Democrat | 16 | |||||||||||||
31814 | 31814 | Robert Sikes S000406 | rep | FL | 1969-01-03 | 1971-01-03 | Democrat | 1 | |||||||||||||
31795 | 31795 | George Shipley S000367 | rep | IL | 1969-01-03 | 1971-01-03 | Democrat | 23 | |||||||||||||
31778 | 31778 | Philip Ruppe R000512 | rep | MI | 1969-01-03 | 1971-01-03 | Republican | 11 | |||||||||||||
31772 | 31772 | Frederick Rooney R000423 | rep | PA | 1969-01-03 | 1971-01-03 | Democrat | 15 | |||||||||||||
31759 | 31759 | Paul Rogers R000401 | rep | FL | 1969-01-03 | 1971-01-03 | Democrat | 9 | |||||||||||||
31745 | 31745 | Albert Quie Q000010 | rep | MN | 1969-01-03 | 1971-01-03 | Republican | 1 | |||||||||||||
31734 | 31734 | William Poage P000398 | rep | TX | 1969-01-03 | 1971-01-03 | Democrat | 11 | |||||||||||||
31713 | 31713 | Otis Pike P000348 | rep | NY | 1969-01-03 | 1971-01-03 | Democrat | 1 | |||||||||||||
31700 | 31700 | Robert Nix N000113 | rep | PA | 1969-01-03 | 1971-01-03 | Democrat | 2 | |||||||||||||
31683 | 31683 | John Moss M001035 | rep | CA | 1969-01-03 | 1971-01-03 | Democrat | 3 | |||||||||||||
31661 | 31661 | Lloyd Meeds M000626 | rep | WA | 1969-01-03 | 1971-01-03 | Democrat | 2 | |||||||||||||
31654 | 31654 | John McFall M000436 | rep | CA | 1969-01-03 | 1971-01-03 | Democrat | 15 | |||||||||||||
31643 | 31643 | James Mann M000105 | rep | SC | 1969-01-03 | 1971-01-03 | Democrat | 4 | |||||||||||||
31638 | 31638 | George Mahon M000065 | rep | TX | 1969-01-03 | 1971-01-03 | Democrat | 19 | |||||||||||||
31616 | 31616 | Robert Leggett L000221 | rep | CA | 1969-01-03 | 1971-01-03 | Democrat | 4 | |||||||||||||
31605 | 31605 | Edward Koch K000302 | rep | NY | 1969-01-03 | 1971-01-03 | Democrat | 17 | |||||||||||||
31585 | 31585 | Michael Harrington H000230 | rep | MA | 1969-01-03 | 1971-01-03 | Democrat | 6 | |||||||||||||
31577 | 31577 | Louis Frey F000381 | rep | FL | 1969-01-03 | 1971-01-03 | Republican | 5 | |||||||||||||
31572 | 31572 | Donald Fraser F000350 | rep | MN | 1969-01-03 | 1971-01-03 | Democrat | 5 | |||||||||||||
31564 | 31564 | John Flynt F000229 | rep | GA | 1969-01-03 | 1971-01-03 | Democrat | 6 | |||||||||||||
31551 | 31551 | Walter Flowers F000218 | rep | AL | 1969-01-03 | 1971-01-03 | Democrat | 5 |
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);