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 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
30288 | 30288 | John Davis D000122 | rep | GA | 1965-01-04 | 1967-01-03 | Democrat | 7 | |||||||||||||
29215 | 29215 | William Dawson D000158 | rep | IL | 1965-01-04 | 1967-01-03 | Democrat | 1 | |||||||||||||
36116 | 36116 | Eligio de la Garza D000203 | rep | TX | 1965-01-04 | 1967-01-03 | Democrat | 15 | |||||||||||||
31520 | 31520 | James Delaney D000211 | rep | NY | 1965-01-04 | 1967-01-03 | Democrat | 9 | |||||||||||||
31531 | 31531 | John Dent D000255 | rep | PA | 1965-01-04 | 1967-01-03 | Democrat | 21 | |||||||||||||
28413 | 28413 | Winfield Denton D000260 | rep | IN | 1965-01-04 | 1967-01-03 | Democrat | 8 | |||||||||||||
32599 | 32599 | Edward Derwinski D000269 | rep | IL | 1965-01-04 | 1967-01-03 | Republican | 4 | |||||||||||||
32018 | 32018 | Samuel Devine D000279 | rep | OH | 1965-01-04 | 1967-01-03 | Republican | 12 | |||||||||||||
34369 | 34369 | William Dickinson D000326 | rep | AL | 1965-01-04 | 1967-01-03 | Republican | 2 | |||||||||||||
32031 | 32031 | Charles Diggs D000344 | rep | MI | 1965-01-04 | 1967-01-03 | Democrat | 13 | |||||||||||||
39804 | 39804 | John Dingell D000355 | rep | MI | 1965-01-04 | 1967-01-03 | Democrat | 16 | |||||||||||||
35192 | 35192 | Robert Dole D000401 | rep | KS | 1965-01-04 | 1967-01-03 | Republican | 1 | |||||||||||||
30311 | 30311 | Harold Donohue D000419 | rep | MA | 1965-01-04 | 1967-01-03 | Democrat | 4 | |||||||||||||
30324 | 30324 | William Dorn D000434 | rep | SC | 1965-01-04 | 1967-01-03 | Democrat | 3 | |||||||||||||
27183 | 27183 | Paul Douglas D000456 | sen | IL | 1961-01-03 | 1967-01-03 | 2 | Democrat | |||||||||||||
29735 | 29735 | John Dow D000462 | rep | NY | 1965-01-04 | 1967-01-03 | Democrat | 27 | |||||||||||||
29745 | 29745 | John Dowdy D000467 | rep | TX | 1965-01-04 | 1967-01-03 | Democrat | 7 | |||||||||||||
30904 | 30904 | Thomas Downing D000474 | rep | VA | 1965-01-04 | 1967-01-03 | Democrat | 1 | |||||||||||||
30332 | 30332 | Thaddeus Dulski D000523 | rep | NY | 1965-01-04 | 1967-01-03 | Democrat | 41 | |||||||||||||
33566 | 33566 | John Duncan D000534 | rep | TN | 1965-01-04 | 1967-01-03 | Republican | 2 | |||||||||||||
32045 | 32045 | Robert Duncan D000537 | rep | OR | 1965-01-04 | 1967-01-03 | Democrat | 4 | |||||||||||||
29753 | 29753 | Florence Dwyer D000587 | rep | NJ | 1965-01-04 | 1967-01-03 | Republican | 6 | |||||||||||||
28418 | 28418 | Kenneth Dyal D000588 | rep | CA | 1965-01-04 | 1967-01-03 | Democrat | 33 | |||||||||||||
30341 | 30341 | James Eastland E000018 | sen | MS | 1961-01-03 | 1967-01-03 | 2 | Democrat | |||||||||||||
29763 | 29763 | Edmond Edmondson E000054 | rep | OK | 1965-01-04 | 1967-01-03 | Democrat | 2 | |||||||||||||
35200 | 35200 | William Edwards E000064 | rep | CA | 1965-01-04 | 1967-01-03 | Democrat | 9 | |||||||||||||
29767 | 29767 | Edwin Edwards E000067 | rep | LA | 1965-01-04 | 1967-01-03 | Democrat | 7 | |||||||||||||
32948 | 32948 | William Edwards E000084 | rep | AL | 1965-01-04 | 1967-01-03 | Republican | 1 | |||||||||||||
28820 | 28820 | Allen Ellender E000112 | sen | LA | 1961-01-03 | 1967-01-03 | 2 | Democrat | |||||||||||||
28421 | 28421 | Robert Ellsworth E000148 | rep | KS | 1965-01-04 | 1967-01-03 | Republican | 3 | |||||||||||||
32958 | 32958 | John Erlenborn E000204 | rep | IL | 1965-01-04 | 1967-01-03 | Republican | 14 | |||||||||||||
31544 | 31544 | Frank Evans E000240 | rep | CO | 1965-01-04 | 1967-01-03 | Democrat | 3 | |||||||||||||
29232 | 29232 | Robert Everett E000266 | rep | TN | 1965-01-04 | 1967-01-03 | Democrat | 8 | |||||||||||||
30930 | 30930 | Joseph Evins E000273 | rep | TN | 1965-01-04 | 1967-01-03 | Democrat | 4 | |||||||||||||
29245 | 29245 | George Fallon F000012 | rep | MD | 1965-01-04 | 1967-01-03 | Democrat | 4 | |||||||||||||
29252 | 29252 | Leonard Farbstein F000015 | rep | NY | 1965-01-04 | 1967-01-03 | Democrat | 19 | |||||||||||||
28422 | 28422 | Charles Farnsley F000023 | rep | KY | 1965-01-04 | 1967-01-03 | Democrat | 3 | |||||||||||||
28423 | 28423 | Billie Farnum F000025 | rep | MI | 1965-01-04 | 1967-01-03 | Democrat | 19 | |||||||||||||
34447 | 34447 | Dante Fascell F000041 | rep | FL | 1965-01-04 | 1967-01-03 | Democrat | 4 | |||||||||||||
29266 | 29266 | Michael Feighan F000060 | rep | OH | 1965-01-04 | 1967-01-03 | Democrat | 20 | |||||||||||||
32645 | 32645 | Paul Findley F000123 | rep | IL | 1965-01-04 | 1967-01-03 | Republican | 20 | |||||||||||||
28828 | 28828 | Paul Fino F000137 | rep | NY | 1965-01-04 | 1967-01-03 | Republican | 24 | |||||||||||||
30355 | 30355 | Ovie Fisher F000152 | rep | TX | 1965-01-04 | 1967-01-03 | Democrat | 21 | |||||||||||||
32068 | 32068 | Daniel Flood F000209 | rep | PA | 1965-01-04 | 1967-01-03 | Democrat | 11 | |||||||||||||
31562 | 31562 | John Flynt F000229 | rep | GA | 1965-01-04 | 1967-01-03 | Democrat | 6 | |||||||||||||
28842 | 28842 | John Fogarty F000233 | rep | RI | 1965-01-04 | 1967-01-03 | Democrat | 2 | |||||||||||||
35245 | 35245 | Thomas Foley F000239 | rep | WA | 1965-01-04 | 1967-01-03 | Democrat | 5 | |||||||||||||
30795 | 30795 | Gerald Ford F000260 | rep | MI | 1965-01-04 | 1967-01-03 | Republican | 5 | |||||||||||||
35265 | 35265 | William Ford F000270 | rep | MI | 1965-01-04 | 1967-01-03 | Democrat | 15 | |||||||||||||
32664 | 32664 | Lawrence Fountain F000319 | rep | NC | 1965-01-04 | 1967-01-03 | Democrat | 2 | |||||||||||||
31570 | 31570 | Donald Fraser F000350 | rep | MN | 1965-01-04 | 1967-01-03 | Democrat | 5 | |||||||||||||
30366 | 30366 | Peter Frelinghuysen F000371 | rep | NJ | 1965-01-04 | 1967-01-03 | Republican | 5 | |||||||||||||
29277 | 29277 | Samuel Friedel F000384 | rep | MD | 1965-01-04 | 1967-01-03 | Democrat | 7 | |||||||||||||
29786 | 29786 | James Fulton F000422 | rep | PA | 1965-01-04 | 1967-01-03 | Republican | 27 | |||||||||||||
30937 | 30937 | Richard Fulton F000424 | rep | TN | 1965-01-04 | 1967-01-03 | Democrat | 5 | |||||||||||||
33271 | 33271 | Don Fuqua F000430 | rep | FL | 1965-01-04 | 1967-01-03 | Democrat | 9 | |||||||||||||
29796 | 29796 | Cornelius Gallagher G000016 | rep | NJ | 1965-01-04 | 1967-01-03 | Democrat | 13 | |||||||||||||
29810 | 29810 | Edward Garmatz G000071 | rep | MD | 1965-01-04 | 1967-01-03 | Democrat | 3 | |||||||||||||
28858 | 28858 | Ezekiel Gathings G000098 | rep | AR | 1965-01-04 | 1967-01-03 | Democrat | 1 | |||||||||||||
30373 | 30373 | Thomas Gettys G000144 | rep | SC | 1965-01-04 | 1967-01-03 | Democrat | 5 | |||||||||||||
32079 | 32079 | Robert Giaimo G000151 | rep | CT | 1965-01-04 | 1967-01-03 | Democrat | 3 | |||||||||||||
35822 | 35822 | Sam Gibbons G000153 | rep | FL | 1965-01-04 | 1967-01-03 | Democrat | 10 | |||||||||||||
29289 | 29289 | Jacob Gilbert G000175 | rep | NY | 1965-01-04 | 1967-01-03 | Democrat | 22 | |||||||||||||
28424 | 28424 | John Gilligan G000208 | rep | OH | 1965-01-04 | 1967-01-03 | Democrat | 1 | |||||||||||||
36205 | 36205 | Henry González G000272 | rep | TX | 1965-01-04 | 1967-01-03 | Democrat | 20 | |||||||||||||
29101 | 29101 | Charles Goodell G000282 | rep | NY | 1965-01-04 | 1967-01-03 | Republican | 38 | |||||||||||||
28436 | 28436 | Bernard Grabowski G000348 | rep | CT | 1965-01-04 | 1967-01-03 | Democrat | 6 | |||||||||||||
33593 | 33593 | Kenneth Gray G000400 | rep | IL | 1965-01-04 | 1967-01-03 | Democrat | 21 | |||||||||||||
30391 | 30391 | Edith Green G000407 | rep | OR | 1965-01-04 | 1967-01-03 | Democrat | 3 | |||||||||||||
30946 | 30946 | William Green G000420 | rep | PA | 1965-01-04 | 1967-01-03 | Democrat | 5 | |||||||||||||
28437 | 28437 | Stanley Greigg G000450 | rep | IA | 1965-01-04 | 1967-01-03 | Democrat | 6 | |||||||||||||
28438 | 28438 | George Grider G000454 | rep | TN | 1965-01-04 | 1967-01-03 | Democrat | 9 | |||||||||||||
30401 | 30401 | Robert Griffin G000465 | sen | MI | 1966-05-11 | 1967-01-03 | 2 | Republican | appointment | ||||||||||||
30409 | 30409 | Martha Griffiths G000471 | rep | MI | 1965-01-04 | 1967-01-03 | Democrat | 17 | |||||||||||||
30422 | 30422 | Harold Gross G000495 | rep | IA | 1965-01-04 | 1967-01-03 | Republican | 3 | |||||||||||||
30428 | 30428 | James Grover G000504 | rep | NY | 1965-01-04 | 1967-01-03 | Republican | 2 | |||||||||||||
30439 | 30439 | Charles Gubser G000512 | rep | CA | 1965-01-04 | 1967-01-03 | Republican | 10 | |||||||||||||
29293 | 29293 | Edward Gurney G000531 | rep | FL | 1965-01-04 | 1967-01-03 | Republican | 11 | |||||||||||||
29819 | 29819 | George Hagan H000010 | rep | GA | 1965-01-04 | 1967-01-03 | Democrat | 1 | |||||||||||||
28445 | 28445 | Harlan Hagen H000013 | rep | CA | 1965-01-04 | 1967-01-03 | Democrat | 18 | |||||||||||||
30963 | 30963 | James Haley H000041 | rep | FL | 1965-01-04 | 1967-01-03 | Democrat | 7 | |||||||||||||
29825 | 29825 | Durward Hall H000049 | rep | MO | 1965-01-04 | 1967-01-03 | Republican | 7 | |||||||||||||
28875 | 28875 | Charles Halleck H000081 | rep | IN | 1965-01-04 | 1967-01-03 | Republican | 2 | |||||||||||||
29832 | 29832 | Seymour Halpern H000085 | rep | NY | 1965-01-04 | 1967-01-03 | Republican | 6 | |||||||||||||
36228 | 36228 | Lee Hamilton H000114 | rep | IN | 1965-01-04 | 1967-01-03 | Democrat | 9 | |||||||||||||
32089 | 32089 | James Hanley H000158 | rep | NY | 1965-01-04 | 1967-01-03 | Democrat | 34 | |||||||||||||
30446 | 30446 | Richard Hanna H000164 | rep | CA | 1965-01-04 | 1967-01-03 | Democrat | 34 | |||||||||||||
32985 | 32985 | George Hansen H000171 | rep | ID | 1965-01-04 | 1967-01-03 | Republican | 2 | |||||||||||||
28446 | 28446 | John Hansen H000173 | rep | IA | 1965-01-04 | 1967-01-03 | Democrat | 7 | |||||||||||||
30457 | 30457 | Julia Hansen H000174 | rep | WA | 1965-01-04 | 1967-01-03 | Democrat | 3 | |||||||||||||
28886 | 28886 | Porter Hardy H000197 | rep | VA | 1965-01-04 | 1967-01-03 | Democrat | 2 | |||||||||||||
28888 | 28888 | Fred Harris H000237 | sen | OK | 1964-01-01 | 1967-01-03 | 2 | Democrat | |||||||||||||
28459 | 28459 | Oren Harris H000249 | rep | AR | 1965-01-04 | 1967-01-03 | Democrat | 4 | |||||||||||||
32102 | 32102 | William Harsha H000281 | rep | OH | 1965-01-04 | 1967-01-03 | Republican | 6 | |||||||||||||
30467 | 30467 | James Harvey H000306 | rep | MI | 1965-01-04 | 1967-01-03 | Republican | 8 | |||||||||||||
28468 | 28468 | Ralph Harvey H000310 | rep | IN | 1965-01-04 | 1967-01-03 | Republican | 10 | |||||||||||||
30473 | 30473 | William Hathaway H000346 | rep | ME | 1965-01-04 | 1967-01-03 | Democrat | 2 | |||||||||||||
33934 | 33934 | Augustus Hawkins H000367 | rep | CA | 1965-01-04 | 1967-01-03 | Democrat | 21 | |||||||||||||
30983 | 30983 | Wayne Hays H000408 | rep | OH | 1965-01-04 | 1967-01-03 | Democrat | 18 | |||||||||||||
31047 | 31047 | Felix Hébert H000437 | rep | LA | 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);