legislator_terms
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
479 rows where "end" is on date 1967-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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
32215 | 32215 | Lucien Nedzi N000019 | rep | MI | 1965-01-04 | 1967-01-03 | Democrat | 14 | |||||||||||||
32196 | 32196 | John Murphy M001098 | rep | NY | 1965-01-04 | 1967-01-03 | Democrat | 16 | |||||||||||||
32187 | 32187 | William Moorhead M000930 | rep | PA | 1965-01-04 | 1967-01-03 | Democrat | 14 | |||||||||||||
32166 | 32166 | Robert McEwen M000433 | rep | NY | 1965-01-04 | 1967-01-03 | Republican | 31 | |||||||||||||
32134 | 32134 | Harold Johnson J000135 | rep | CA | 1965-01-04 | 1967-01-03 | Democrat | 2 | |||||||||||||
32119 | 32119 | Richard Ichord I000001 | rep | MO | 1965-01-04 | 1967-01-03 | Democrat | 8 | |||||||||||||
32102 | 32102 | William Harsha H000281 | rep | OH | 1965-01-04 | 1967-01-03 | Republican | 6 | |||||||||||||
32089 | 32089 | James Hanley H000158 | rep | NY | 1965-01-04 | 1967-01-03 | Democrat | 34 | |||||||||||||
32079 | 32079 | Robert Giaimo G000151 | rep | CT | 1965-01-04 | 1967-01-03 | Democrat | 3 | |||||||||||||
32068 | 32068 | Daniel Flood F000209 | rep | PA | 1965-01-04 | 1967-01-03 | Democrat | 11 | |||||||||||||
32045 | 32045 | Robert Duncan D000537 | rep | OR | 1965-01-04 | 1967-01-03 | Democrat | 4 | |||||||||||||
32031 | 32031 | Charles Diggs D000344 | rep | MI | 1965-01-04 | 1967-01-03 | Democrat | 13 | |||||||||||||
32018 | 32018 | Samuel Devine D000279 | rep | OH | 1965-01-04 | 1967-01-03 | Republican | 12 | |||||||||||||
32002 | 32002 | James Corman C000780 | rep | CA | 1965-01-04 | 1967-01-03 | Democrat | 22 | |||||||||||||
31992 | 31992 | James Cleveland C000512 | rep | NH | 1965-01-04 | 1967-01-03 | Republican | 2 | |||||||||||||
31981 | 31981 | Tim Carter C000201 | rep | KY | 1965-01-04 | 1967-01-03 | Republican | 5 | |||||||||||||
31967 | 31967 | John Buchanan B001008 | rep | AL | 1965-01-04 | 1967-01-03 | Republican | 6 | |||||||||||||
31959 | 31959 | John Brademas B000736 | rep | IN | 1965-01-04 | 1967-01-03 | Democrat | 3 | |||||||||||||
31935 | 31935 | Thomas Ashley A000222 | rep | OH | 1965-01-04 | 1967-01-03 | Democrat | 9 | |||||||||||||
31922 | 31922 | John Anderson A000195 | rep | IL | 1965-01-04 | 1967-01-03 | Republican | 16 | |||||||||||||
31906 | 31906 | John Young Y000043 | rep | TX | 1965-01-04 | 1967-01-03 | Democrat | 14 | |||||||||||||
31871 | 31871 | Joseph Waggonner W000018 | rep | LA | 1965-01-04 | 1967-01-03 | Democrat | 4 | |||||||||||||
31856 | 31856 | Olin Teague T000110 | rep | TX | 1965-01-04 | 1967-01-03 | Democrat | 6 | |||||||||||||
31832 | 31832 | Joe Skubitz S000472 | rep | KS | 1965-01-04 | 1967-01-03 | Republican | 5 | |||||||||||||
31824 | 31824 | Bernice Sisk S000454 | rep | CA | 1965-01-04 | 1967-01-03 | Democrat | 16 | |||||||||||||
31812 | 31812 | Robert Sikes S000406 | rep | FL | 1965-01-04 | 1967-01-03 | Democrat | 1 | |||||||||||||
31793 | 31793 | George Shipley S000367 | rep | IL | 1965-01-04 | 1967-01-03 | Democrat | 23 | |||||||||||||
31770 | 31770 | Frederick Rooney R000423 | rep | PA | 1965-01-04 | 1967-01-03 | Democrat | 15 | |||||||||||||
31764 | 31764 | Teno Roncalio R000421 | rep | WY | 1965-01-04 | 1967-01-03 | Democrat | 0 | |||||||||||||
31757 | 31757 | Paul Rogers R000401 | rep | FL | 1965-01-04 | 1967-01-03 | Democrat | 6 | |||||||||||||
31743 | 31743 | Albert Quie Q000010 | rep | MN | 1965-01-04 | 1967-01-03 | Republican | 1 | |||||||||||||
31732 | 31732 | William Poage P000398 | rep | TX | 1965-01-04 | 1967-01-03 | Democrat | 11 | |||||||||||||
31711 | 31711 | Otis Pike P000348 | rep | NY | 1965-01-04 | 1967-01-03 | Democrat | 1 | |||||||||||||
31698 | 31698 | Robert Nix N000113 | rep | PA | 1965-01-04 | 1967-01-03 | Democrat | 2 | |||||||||||||
31681 | 31681 | John Moss M001035 | rep | CA | 1965-01-04 | 1967-01-03 | Democrat | 3 | |||||||||||||
31659 | 31659 | Lloyd Meeds M000626 | rep | WA | 1965-01-04 | 1967-01-03 | Democrat | 2 | |||||||||||||
31652 | 31652 | John McFall M000436 | rep | CA | 1965-01-04 | 1967-01-03 | Democrat | 15 | |||||||||||||
31636 | 31636 | George Mahon M000065 | rep | TX | 1965-01-04 | 1967-01-03 | Democrat | 19 | |||||||||||||
31614 | 31614 | Robert Leggett L000221 | rep | CA | 1965-01-04 | 1967-01-03 | Democrat | 4 | |||||||||||||
31570 | 31570 | Donald Fraser F000350 | rep | MN | 1965-01-04 | 1967-01-03 | Democrat | 5 | |||||||||||||
31562 | 31562 | John Flynt F000229 | rep | GA | 1965-01-04 | 1967-01-03 | Democrat | 6 | |||||||||||||
31544 | 31544 | Frank Evans E000240 | rep | CO | 1965-01-04 | 1967-01-03 | Democrat | 3 | |||||||||||||
31531 | 31531 | John Dent D000255 | rep | PA | 1965-01-04 | 1967-01-03 | Democrat | 21 | |||||||||||||
31520 | 31520 | James Delaney D000211 | rep | NY | 1965-01-04 | 1967-01-03 | Democrat | 9 | |||||||||||||
31500 | 31500 | Delwin Clawson C000476 | rep | CA | 1965-01-04 | 1967-01-03 | Republican | 23 | |||||||||||||
31492 | 31492 | Elford Cederberg C000263 | rep | MI | 1965-01-04 | 1967-01-03 | Republican | 10 | |||||||||||||
31462 | 31462 | Omar Burleson B001111 | rep | TX | 1965-01-04 | 1967-01-03 | Democrat | 17 | |||||||||||||
31443 | 31443 | James Burke B001092 | rep | MA | 1965-01-04 | 1967-01-03 | Democrat | 11 | |||||||||||||
31396 | 31396 | Joseph Vigorito V000098 | rep | PA | 1965-01-04 | 1967-01-03 | Democrat | 24 | |||||||||||||
31388 | 31388 | Roy Taylor T000099 | rep | NC | 1965-01-04 | 1967-01-03 | Democrat | 11 | |||||||||||||
31375 | 31375 | Burt Talcott T000022 | rep | CA | 1965-01-04 | 1967-01-03 | Republican | 12 | |||||||||||||
31364 | 31364 | Leonor Sullivan S001057 | rep | MO | 1965-01-04 | 1967-01-03 | Democrat | 3 | |||||||||||||
31344 | 31344 | Robert Stephens S000860 | rep | GA | 1965-01-04 | 1967-01-03 | Democrat | 10 | |||||||||||||
31326 | 31326 | Garner Shriver S000388 | rep | KS | 1965-01-04 | 1967-01-03 | Republican | 4 | |||||||||||||
31320 | 31320 | Richard Schweiker S000159 | rep | PA | 1965-01-04 | 1967-01-03 | Republican | 13 | |||||||||||||
31312 | 31312 | Herman Schneebeli S000135 | rep | PA | 1965-01-04 | 1967-01-03 | Republican | 17 | |||||||||||||
31304 | 31304 | John Roush R000467 | rep | IN | 1965-01-04 | 1967-01-03 | Democrat | 5 | |||||||||||||
31290 | 31290 | Thomas Rees R000134 | rep | CA | 1965-01-04 | 1967-01-03 | Democrat | 26 | |||||||||||||
31284 | 31284 | William Randall R000041 | rep | MO | 1965-01-04 | 1967-01-03 | Democrat | 4 | |||||||||||||
31270 | 31270 | John Patman P000103 | rep | TX | 1965-01-04 | 1967-01-03 | Democrat | 1 | |||||||||||||
31246 | 31246 | Otto Passman P000098 | rep | LA | 1965-01-04 | 1967-01-03 | Democrat | 5 | |||||||||||||
31231 | 31231 | James O’Hara O000055 | rep | MI | 1965-01-04 | 1967-01-03 | Democrat | 12 | |||||||||||||
31219 | 31219 | Charles Mosher M001031 | rep | OH | 1965-01-04 | 1967-01-03 | Republican | 13 | |||||||||||||
31211 | 31211 | Thomas Morgan M000958 | rep | PA | 1965-01-04 | 1967-01-03 | Democrat | 26 | |||||||||||||
31194 | 31194 | Wilbur Mills M000778 | rep | AR | 1965-01-04 | 1967-01-03 | Democrat | 2 | |||||||||||||
31154 | 31154 | Ray Madden M000039 | rep | IN | 1965-01-04 | 1967-01-03 | Democrat | 1 | |||||||||||||
31137 | 31137 | Torbert Macdonald M000005 | rep | MA | 1965-01-04 | 1967-01-03 | Democrat | 7 | |||||||||||||
31124 | 31124 | Phillip Landrum L000054 | rep | GA | 1965-01-04 | 1967-01-03 | Democrat | 9 | |||||||||||||
31112 | 31112 | John Kluczynski K000273 | rep | IL | 1965-01-04 | 1967-01-03 | Democrat | 5 | |||||||||||||
31099 | 31099 | Joseph Karth K000014 | rep | MN | 1965-01-04 | 1967-01-03 | Democrat | 4 | |||||||||||||
31090 | 31090 | Robert Jones J000248 | rep | AL | 1965-01-04 | 1967-01-03 | Democrat | 8 | |||||||||||||
31075 | 31075 | Albert Johnson J000115 | rep | PA | 1965-01-04 | 1967-01-03 | Republican | 23 | |||||||||||||
31060 | 31060 | John Jarman J000057 | rep | OK | 1965-01-04 | 1967-01-03 | Democrat | 5 | |||||||||||||
31047 | 31047 | Felix Hébert H000437 | rep | LA | 1965-01-04 | 1967-01-03 | Democrat | 1 | |||||||||||||
31029 | 31029 | J. Hutchinson H001011 | rep | MI | 1965-01-04 | 1967-01-03 | Republican | 4 | |||||||||||||
31022 | 31022 | William Hungate H000965 | rep | MO | 1965-01-04 | 1967-01-03 | Democrat | 9 | |||||||||||||
31012 | 31012 | Floyd Hicks H000563 | rep | WA | 1965-01-04 | 1967-01-03 | Democrat | 6 | |||||||||||||
31006 | 31006 | David Henderson H000479 | rep | NC | 1965-01-04 | 1967-01-03 | Democrat | 3 | |||||||||||||
30998 | 30998 | Henry Helstoski H000465 | rep | NJ | 1965-01-04 | 1967-01-03 | Democrat | 9 | |||||||||||||
30992 | 30992 | Kenneth Hechler H000438 | rep | WV | 1965-01-04 | 1967-01-03 | Democrat | 4 | |||||||||||||
30983 | 30983 | Wayne Hays H000408 | rep | OH | 1965-01-04 | 1967-01-03 | Democrat | 18 | |||||||||||||
30963 | 30963 | James Haley H000041 | rep | FL | 1965-01-04 | 1967-01-03 | Democrat | 7 | |||||||||||||
30946 | 30946 | William Green G000420 | rep | PA | 1965-01-04 | 1967-01-03 | Democrat | 5 | |||||||||||||
30937 | 30937 | Richard Fulton F000424 | rep | TN | 1965-01-04 | 1967-01-03 | Democrat | 5 | |||||||||||||
30930 | 30930 | Joseph Evins E000273 | rep | TN | 1965-01-04 | 1967-01-03 | Democrat | 4 | |||||||||||||
30904 | 30904 | Thomas Downing D000474 | rep | VA | 1965-01-04 | 1967-01-03 | Democrat | 1 | |||||||||||||
30895 | 30895 | Dominick Daniels D000041 | rep | NJ | 1965-01-04 | 1967-01-03 | Democrat | 14 | |||||||||||||
30886 | 30886 | John Culver C000979 | rep | IA | 1965-01-04 | 1967-01-03 | Democrat | 2 | |||||||||||||
30870 | 30870 | Donald Clancy C000409 | rep | OH | 1965-01-04 | 1967-01-03 | Republican | 2 | |||||||||||||
30858 | 30858 | Robert Casey C000228 | rep | TX | 1965-01-04 | 1967-01-03 | Democrat | 22 | |||||||||||||
30840 | 30840 | Alphonzo Bell B000330 | rep | CA | 1965-01-04 | 1967-01-03 | Republican | 28 | |||||||||||||
30829 | 30829 | William Barrett B000178 | rep | PA | 1965-01-04 | 1967-01-03 | Democrat | 1 | |||||||||||||
30812 | 30812 | Carl Albert A000073 | rep | OK | 1965-01-04 | 1967-01-03 | Democrat | 3 | |||||||||||||
30795 | 30795 | Gerald Ford F000260 | rep | MI | 1965-01-04 | 1967-01-03 | Republican | 5 | |||||||||||||
30766 | 30766 | Wendell Wyatt W000778 | rep | OR | 1965-01-04 | 1967-01-03 | Republican | 1 | |||||||||||||
30756 | 30756 | William Widnall W000445 | rep | NJ | 1965-01-04 | 1967-01-03 | Republican | 7 | |||||||||||||
30740 | 30740 | Jerome Waldie W000035 | rep | CA | 1965-01-04 | 1967-01-03 | Democrat | 14 | |||||||||||||
30728 | 30728 | Vernon Thomson T000233 | rep | WI | 1965-01-04 | 1967-01-03 | Republican | 3 | |||||||||||||
30721 | 30721 | Charles Teague T000109 | rep | CA | 1965-01-04 | 1967-01-03 | Republican | 13 | |||||||||||||
30711 | 30711 | Frank Stubblefield S001037 | rep | KY | 1965-01-04 | 1967-01-03 | Democrat | 1 |
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);