legislator_terms
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
474 rows where "end" is on date 1969-01-03
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
29466 | 29466 | Byron Rogers R000389 | rep | CO | 1967-01-10 | 1969-01-03 | Democrat | 1 | |||||||||||||
29469 | 29469 | Daniel Ronan R000420 | rep | IL | 1967-01-10 | 1969-01-03 | Democrat | 6 | |||||||||||||
29474 | 29474 | Richard Roudebush R000464 | rep | IN | 1967-01-10 | 1969-01-03 | Republican | 10 | |||||||||||||
29478 | 29478 | Donald Rumsfeld R000508 | rep | IL | 1967-01-10 | 1969-01-03 | Republican | 13 | |||||||||||||
29483 | 29483 | Henry Schadeberg S000108 | rep | WI | 1967-01-10 | 1969-01-03 | Republican | 1 | |||||||||||||
29488 | 29488 | William St. Onge S000769 | rep | CT | 1967-01-10 | 1969-01-03 | Democrat | 2 | |||||||||||||
29497 | 29497 | James Utt U000034 | rep | CA | 1967-01-10 | 1969-01-03 | Republican | 35 | |||||||||||||
29500 | 29500 | George Watkins W000192 | rep | PA | 1967-01-10 | 1969-01-03 | Republican | 9 | |||||||||||||
29504 | 29504 | Albert Watson W000197 | rep | SC | 1967-01-10 | 1969-01-03 | Republican | 2 | |||||||||||||
29521 | 29521 | Watkins Abbitt A000002 | rep | VA | 1967-01-10 | 1969-01-03 | Democrat | 4 | |||||||||||||
29536 | 29536 | Thomas Abernethy A000016 | rep | MS | 1967-01-10 | 1969-01-03 | Democrat | 1 | |||||||||||||
29540 | 29540 | William Anderson A000203 | rep | TN | 1967-01-10 | 1969-01-03 | Democrat | 6 | |||||||||||||
29556 | 29556 | George Andrews A000206 | rep | AL | 1967-01-10 | 1969-01-03 | Democrat | 3 | |||||||||||||
29568 | 29568 | Wayne Aspinall A000225 | rep | CO | 1967-01-10 | 1969-01-03 | Democrat | 4 | |||||||||||||
29578 | 29578 | Walter Baring B000141 | rep | NV | 1967-01-10 | 1969-01-03 | Democrat | 0 | |||||||||||||
29592 | 29592 | Page Belcher B000323 | rep | OK | 1967-01-10 | 1969-01-03 | Republican | 1 | |||||||||||||
29603 | 29603 | Jackson Betts B000426 | rep | OH | 1967-01-10 | 1969-01-03 | Republican | 8 | |||||||||||||
29606 | 29606 | Leonard Blanton B000548 | rep | TN | 1967-01-10 | 1969-01-03 | Democrat | 7 | |||||||||||||
29620 | 29620 | Thomas Boggs B000594 | rep | LA | 1967-01-10 | 1969-01-03 | Democrat | 2 | |||||||||||||
29631 | 29631 | Frank Bow B000676 | rep | OH | 1967-01-10 | 1969-01-03 | Republican | 16 | |||||||||||||
29636 | 29636 | William Brock B000851 | rep | TN | 1967-01-10 | 1969-01-03 | Republican | 3 | |||||||||||||
29647 | 29647 | James Byrne B001212 | rep | PA | 1967-01-10 | 1969-01-03 | Democrat | 3 | |||||||||||||
29661 | 29661 | John Byrnes B001216 | rep | WI | 1967-01-10 | 1969-01-03 | Republican | 8 | |||||||||||||
29665 | 29665 | Earle Cabell C000002 | rep | TX | 1967-01-10 | 1969-01-03 | Democrat | 5 | |||||||||||||
29693 | 29693 | Emanuel Celler C000264 | rep | NY | 1967-01-10 | 1969-01-03 | Democrat | 10 | |||||||||||||
29713 | 29713 | William Colmer C000645 | rep | MS | 1967-01-10 | 1969-01-03 | Democrat | 5 | |||||||||||||
29729 | 29729 | Robert Corbett C000772 | rep | PA | 1967-01-10 | 1969-01-03 | Republican | 18 | |||||||||||||
29736 | 29736 | John Dow D000462 | rep | NY | 1967-01-10 | 1969-01-03 | Democrat | 27 | |||||||||||||
29746 | 29746 | John Dowdy D000467 | rep | TX | 1967-01-10 | 1969-01-03 | Democrat | 2 | |||||||||||||
29754 | 29754 | Florence Dwyer D000587 | rep | NJ | 1967-01-10 | 1969-01-03 | Republican | 12 | |||||||||||||
29764 | 29764 | Edmond Edmondson E000054 | rep | OK | 1967-01-10 | 1969-01-03 | Democrat | 2 | |||||||||||||
29768 | 29768 | Edwin Edwards E000067 | rep | LA | 1967-01-10 | 1969-01-03 | Democrat | 7 | |||||||||||||
29787 | 29787 | James Fulton F000422 | rep | PA | 1967-01-10 | 1969-01-03 | Republican | 27 | |||||||||||||
29790 | 29790 | Nick Galifianakis G000015 | rep | NC | 1967-01-10 | 1969-01-03 | Democrat | 5 | |||||||||||||
29797 | 29797 | Cornelius Gallagher G000016 | rep | NJ | 1967-01-10 | 1969-01-03 | Democrat | 13 | |||||||||||||
29811 | 29811 | Edward Garmatz G000071 | rep | MD | 1967-01-10 | 1969-01-03 | Democrat | 3 | |||||||||||||
29814 | 29814 | Charles Griffin G000458 | rep | MS | 1967-01-10 | 1969-01-03 | Democrat | 3 | |||||||||||||
29820 | 29820 | George Hagan H000010 | rep | GA | 1967-01-10 | 1969-01-03 | Democrat | 1 | |||||||||||||
29826 | 29826 | Durward Hall H000049 | rep | MO | 1967-01-10 | 1969-01-03 | Republican | 7 | |||||||||||||
29833 | 29833 | Seymour Halpern H000085 | rep | NY | 1967-01-10 | 1969-01-03 | Republican | 6 | |||||||||||||
29854 | 29854 | William Hull H000947 | rep | MO | 1967-01-10 | 1969-01-03 | Democrat | 6 | |||||||||||||
29864 | 29864 | Charles Jonas J000206 | rep | NC | 1967-01-10 | 1969-01-03 | Republican | 8 | |||||||||||||
29868 | 29868 | James Kee K000038 | rep | WV | 1967-01-10 | 1969-01-03 | Democrat | 5 | |||||||||||||
29875 | 29875 | Hastings Keith K000053 | rep | MA | 1967-01-10 | 1969-01-03 | Republican | 12 | |||||||||||||
29881 | 29881 | John Kyl K000351 | rep | IA | 1967-01-10 | 1969-01-03 | Republican | 4 | |||||||||||||
29890 | 29890 | Alton Lennon L000240 | rep | NC | 1967-01-10 | 1969-01-03 | Democrat | 7 | |||||||||||||
29895 | 29895 | Sherman Lloyd L000382 | rep | UT | 1967-01-10 | 1969-01-03 | Republican | 2 | |||||||||||||
29899 | 29899 | Speedy Long L000429 | rep | LA | 1967-01-10 | 1969-01-03 | Democrat | 8 | |||||||||||||
29921 | 29921 | William McCulloch M000393 | rep | OH | 1967-01-10 | 1969-01-03 | Republican | 4 | |||||||||||||
29924 | 29924 | Jack McDonald M000410 | rep | MI | 1967-01-10 | 1969-01-03 | Republican | 19 | |||||||||||||
29945 | 29945 | John McMillan M000568 | rep | SC | 1967-01-10 | 1969-01-03 | Democrat | 6 | |||||||||||||
29959 | 29959 | George Miller M000727 | rep | CA | 1967-01-10 | 1969-01-03 | Democrat | 8 | |||||||||||||
29966 | 29966 | John Monagan M000847 | rep | CT | 1967-01-10 | 1969-01-03 | Democrat | 5 | |||||||||||||
29979 | 29979 | Frank Morse M001009 | rep | MA | 1967-01-10 | 1969-01-03 | Republican | 5 | |||||||||||||
29984 | 29984 | Rogers Morton M001021 | rep | MD | 1967-01-10 | 1969-01-03 | Republican | 1 | |||||||||||||
30002 | 30002 | Alvin O’Konski O000058 | rep | WI | 1967-01-10 | 1969-01-03 | Republican | 10 | |||||||||||||
30017 | 30017 | Thomas Pelly P000196 | rep | WA | 1967-01-10 | 1969-01-03 | Republican | 1 | |||||||||||||
30024 | 30024 | Alexander Pirnie P000366 | rep | NY | 1967-01-10 | 1969-01-03 | Republican | 32 | |||||||||||||
30034 | 30034 | Richard Poff P000401 | rep | VA | 1967-01-10 | 1969-01-03 | Republican | 6 | |||||||||||||
30041 | 30041 | Roman Pucinski P000559 | rep | IL | 1967-01-10 | 1969-01-03 | Democrat | 11 | |||||||||||||
30047 | 30047 | Graham Purcell P000569 | rep | TX | 1967-01-10 | 1969-01-03 | Democrat | 13 | |||||||||||||
30052 | 30052 | Charlotte Reid R000143 | rep | IL | 1967-01-10 | 1969-01-03 | Republican | 15 | |||||||||||||
30058 | 30058 | William Ryan R000562 | rep | NY | 1967-01-10 | 1969-01-03 | Democrat | 20 | |||||||||||||
30068 | 30068 | Frederick Schwengel S000161 | rep | IA | 1967-01-10 | 1969-01-03 | Republican | 1 | |||||||||||||
30087 | 30087 | H. Smith S000545 | rep | CA | 1967-01-10 | 1969-01-03 | Republican | 20 | |||||||||||||
30098 | 30098 | William Springer S000756 | rep | IL | 1967-01-10 | 1969-01-03 | Republican | 22 | |||||||||||||
30106 | 30106 | Robert Taft T000010 | rep | OH | 1967-01-10 | 1969-01-03 | Republican | 1 | |||||||||||||
30110 | 30110 | Standish Thompson T000217 | rep | GA | 1967-01-10 | 1969-01-03 | Republican | 5 | |||||||||||||
30114 | 30114 | John Tunney T000410 | rep | CA | 1967-01-10 | 1969-01-03 | Democrat | 38 | |||||||||||||
30125 | 30125 | John Watts W000212 | rep | KY | 1967-01-10 | 1969-01-03 | Democrat | 6 | |||||||||||||
30132 | 30132 | John Whalley W000320 | rep | PA | 1967-01-10 | 1969-01-03 | Republican | 12 | |||||||||||||
30154 | 30154 | Leslie Arends A000216 | rep | IL | 1967-01-10 | 1969-01-03 | Republican | 17 | |||||||||||||
30161 | 30161 | Benjamin Blackburn B000506 | rep | GA | 1967-01-10 | 1969-01-03 | Republican | 4 | |||||||||||||
30175 | 30175 | John Blatnik B000550 | rep | MN | 1967-01-10 | 1969-01-03 | Democrat | 8 | |||||||||||||
30179 | 30179 | Frank Brasco B000771 | rep | NY | 1967-01-10 | 1969-01-03 | Democrat | 11 | |||||||||||||
30191 | 30191 | William Bray B000778 | rep | IN | 1967-01-10 | 1969-01-03 | Republican | 6 | |||||||||||||
30198 | 30198 | Donald Brotzman B000893 | rep | CO | 1967-01-10 | 1969-01-03 | Republican | 2 | |||||||||||||
30209 | 30209 | Joel Broyhill B000967 | rep | VA | 1967-01-10 | 1969-01-03 | Republican | 10 | |||||||||||||
30219 | 30219 | Hugh Carey C000143 | rep | NY | 1967-01-10 | 1969-01-03 | Democrat | 15 | |||||||||||||
30237 | 30237 | Charles Chamberlain C000275 | rep | MI | 1967-01-10 | 1969-01-03 | Republican | 6 | |||||||||||||
30247 | 30247 | Frank Clark C000431 | rep | PA | 1967-01-10 | 1969-01-03 | Democrat | 25 | |||||||||||||
30257 | 30257 | Harold Collier C000629 | rep | IL | 1967-01-10 | 1969-01-03 | Republican | 10 | |||||||||||||
30282 | 30282 | Glenn Davis D000102 | rep | WI | 1967-01-10 | 1969-01-03 | Republican | 9 | |||||||||||||
30289 | 30289 | John Davis D000122 | rep | GA | 1967-01-10 | 1969-01-03 | Democrat | 7 | |||||||||||||
30293 | 30293 | John Dellenback D000220 | rep | OR | 1967-01-10 | 1969-01-03 | Republican | 4 | |||||||||||||
30312 | 30312 | Harold Donohue D000419 | rep | MA | 1967-01-10 | 1969-01-03 | Democrat | 4 | |||||||||||||
30325 | 30325 | William Dorn D000434 | rep | SC | 1967-01-10 | 1969-01-03 | Democrat | 3 | |||||||||||||
30333 | 30333 | Thaddeus Dulski D000523 | rep | NY | 1967-01-10 | 1969-01-03 | Democrat | 41 | |||||||||||||
30356 | 30356 | Ovie Fisher F000152 | rep | TX | 1967-01-10 | 1969-01-03 | Democrat | 21 | |||||||||||||
30367 | 30367 | Peter Frelinghuysen F000371 | rep | NJ | 1967-01-10 | 1969-01-03 | Republican | 5 | |||||||||||||
30374 | 30374 | Thomas Gettys G000144 | rep | SC | 1967-01-10 | 1969-01-03 | Democrat | 5 | |||||||||||||
30380 | 30380 | George Goodling G000290 | rep | PA | 1967-01-10 | 1969-01-03 | Republican | 19 | |||||||||||||
30392 | 30392 | Edith Green G000407 | rep | OR | 1967-01-10 | 1969-01-03 | Democrat | 3 | |||||||||||||
30410 | 30410 | Martha Griffiths G000471 | rep | MI | 1967-01-10 | 1969-01-03 | Democrat | 17 | |||||||||||||
30423 | 30423 | Harold Gross G000495 | rep | IA | 1967-01-10 | 1969-01-03 | Republican | 3 | |||||||||||||
30429 | 30429 | James Grover G000504 | rep | NY | 1967-01-10 | 1969-01-03 | Republican | 2 | |||||||||||||
30440 | 30440 | Charles Gubser G000512 | rep | CA | 1967-01-10 | 1969-01-03 | Republican | 10 | |||||||||||||
30447 | 30447 | Richard Hanna H000164 | rep | CA | 1967-01-10 | 1969-01-03 | Democrat | 34 | |||||||||||||
30458 | 30458 | Julia Hansen H000174 | rep | WA | 1967-01-10 | 1969-01-03 | Democrat | 3 | |||||||||||||
30468 | 30468 | James Harvey H000306 | rep | MI | 1967-01-10 | 1969-01-03 | Republican | 8 |
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);