legislator_terms
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
489 rows where "end" is on date 1963-01-03 sorted by party
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
28457 | 28457 | Oren Harris H000249 | rep | AR | 1961-01-03 | 1963-01-03 | Democrat | 4 | |||||||||||||
28478 | 28478 | William Jennings J000098 | rep | VA | 1961-01-03 | 1963-01-03 | Democrat | 9 | |||||||||||||
28489 | 28489 | Paul Jones J000246 | rep | MO | 1961-01-03 | 1963-01-03 | Democrat | 10 | |||||||||||||
28505 | 28505 | Eugene Keogh K000130 | rep | NY | 1961-01-03 | 1963-01-03 | Democrat | 9 | |||||||||||||
28509 | 28509 | David King K000199 | rep | UT | 1961-01-03 | 1963-01-03 | Democrat | 2 | |||||||||||||
28554 | 28554 | Donald Matthews M000253 | rep | FL | 1961-01-03 | 1963-01-03 | Democrat | 8 | |||||||||||||
28566 | 28566 | Harris McDowell M000418 | rep | DE | 1961-01-03 | 1963-01-03 | Democrat | 0 | |||||||||||||
28572 | 28572 | Walter Moeller M000836 | rep | OH | 1961-01-03 | 1963-01-03 | Democrat | 10 | |||||||||||||
28583 | 28583 | James Morrison M000995 | rep | LA | 1961-01-03 | 1963-01-03 | Democrat | 6 | |||||||||||||
28596 | 28596 | Thomas Murray M001114 | rep | TN | 1961-01-03 | 1963-01-03 | Democrat | 7 | |||||||||||||
28604 | 28604 | Leo O’Brien O000015 | rep | NY | 1961-01-03 | 1963-01-03 | Democrat | 30 | |||||||||||||
28618 | 28618 | Ralph Rivers R000282 | rep | AK | 1961-01-03 | 1963-01-03 | Democrat | 0 | |||||||||||||
28626 | 28626 | Walter Rogers R000404 | rep | TX | 1961-01-03 | 1963-01-03 | Democrat | 18 | |||||||||||||
28632 | 28632 | James Roosevelt R000426 | rep | CA | 1961-01-03 | 1963-01-03 | Democrat | 26 | |||||||||||||
28640 | 28640 | Ralph Scott S000184 | rep | NC | 1961-01-03 | 1963-01-03 | Democrat | 5 | |||||||||||||
28672 | 28672 | Howard Smith S000554 | rep | VA | 1961-01-03 | 1963-01-03 | Democrat | 8 | |||||||||||||
28689 | 28689 | Albert Thomas T000156 | rep | TX | 1961-01-03 | 1963-01-03 | Democrat | 8 | |||||||||||||
28701 | 28701 | Clark Thompson T000198 | rep | TX | 1961-01-03 | 1963-01-03 | Democrat | 9 | |||||||||||||
28708 | 28708 | Theo Thompson T000218 | rep | LA | 1961-01-03 | 1963-01-03 | Democrat | 7 | |||||||||||||
28713 | 28713 | Herman Toll T000297 | rep | PA | 1961-01-03 | 1963-01-03 | Democrat | 6 | |||||||||||||
28724 | 28724 | James Trimble T000373 | rep | AR | 1961-01-03 | 1963-01-03 | Democrat | 3 | |||||||||||||
28768 | 28768 | Robert Ashmore A000223 | rep | SC | 1961-01-03 | 1963-01-03 | Democrat | 4 | |||||||||||||
28840 | 28840 | John Fogarty F000233 | rep | RI | 1961-01-03 | 1963-01-03 | Democrat | 2 | |||||||||||||
28856 | 28856 | Ezekiel Gathings G000098 | rep | AR | 1961-01-03 | 1963-01-03 | Democrat | 1 | |||||||||||||
28884 | 28884 | Porter Hardy H000197 | rep | VA | 1961-01-03 | 1963-01-03 | Democrat | 2 | |||||||||||||
28901 | 28901 | Albert Herlong H000530 | rep | FL | 1961-01-03 | 1963-01-03 | Democrat | 5 | |||||||||||||
28909 | 28909 | Elmer Holland H000717 | rep | PA | 1961-01-03 | 1963-01-03 | Democrat | 30 | |||||||||||||
28928 | 28928 | Frank Karsten K000013 | rep | MO | 1961-01-03 | 1963-01-03 | Democrat | 1 | |||||||||||||
28938 | 28938 | Edna Kelly K000070 | rep | NY | 1961-01-03 | 1963-01-03 | Democrat | 10 | |||||||||||||
28952 | 28952 | Cecil King K000196 | rep | CA | 1961-01-03 | 1963-01-03 | Democrat | 17 | |||||||||||||
28956 | 28956 | Horace Kornegay K000318 | rep | NC | 1961-01-03 | 1963-01-03 | Democrat | 6 | |||||||||||||
28973 | 28973 | Thomas Morris M000990 | rep | NM | 1961-01-03 | 1963-01-03 | Democrat | 0 | |||||||||||||
28984 | 28984 | Abraham Multer M001074 | rep | NY | 1961-01-03 | 1963-01-03 | Democrat | 13 | |||||||||||||
29003 | 29003 | Barratt O’Hara O000053 | rep | IL | 1961-01-03 | 1963-01-03 | Democrat | 2 | |||||||||||||
29020 | 29020 | George Rhodes R000187 | rep | PA | 1961-01-03 | 1963-01-03 | Democrat | 14 | |||||||||||||
29035 | 29035 | Armistead Selden S000232 | rep | AL | 1961-01-03 | 1963-01-03 | Democrat | 6 | |||||||||||||
29055 | 29055 | William Tuck T000395 | rep | VA | 1961-01-03 | 1963-01-03 | Democrat | 5 | |||||||||||||
29063 | 29063 | Basil Whitener W000410 | rep | NC | 1961-01-03 | 1963-01-03 | Democrat | 11 | |||||||||||||
29074 | 29074 | John Williams W000517 | rep | MS | 1961-01-03 | 1963-01-03 | Democrat | 4 | |||||||||||||
29084 | 29084 | Edwin Willis W000559 | rep | LA | 1961-01-03 | 1963-01-03 | Democrat | 3 | |||||||||||||
29160 | 29160 | Alan Bible B000436 | sen | NV | 1957-01-03 | 1963-01-03 | 3 | Democrat | |||||||||||||
29176 | 29176 | Jeffery Cohelan C000596 | rep | CA | 1961-01-03 | 1963-01-03 | Democrat | 7 | |||||||||||||
29199 | 29199 | Emilio Daddario D000001 | rep | CT | 1961-01-03 | 1963-01-03 | Democrat | 1 | |||||||||||||
29213 | 29213 | William Dawson D000158 | rep | IL | 1961-01-03 | 1963-01-03 | Democrat | 1 | |||||||||||||
29225 | 29225 | Samuel Ervin E000211 | sen | NC | 1957-01-03 | 1963-01-03 | 3 | Democrat | |||||||||||||
29230 | 29230 | Robert Everett E000266 | rep | TN | 1961-01-03 | 1963-01-03 | Democrat | 8 | |||||||||||||
29243 | 29243 | George Fallon F000012 | rep | MD | 1961-01-03 | 1963-01-03 | Democrat | 4 | |||||||||||||
29250 | 29250 | Leonard Farbstein F000015 | rep | NY | 1961-01-03 | 1963-01-03 | Democrat | 19 | |||||||||||||
29264 | 29264 | Michael Feighan F000060 | rep | OH | 1961-01-03 | 1963-01-03 | Democrat | 20 | |||||||||||||
29275 | 29275 | Samuel Friedel F000384 | rep | MD | 1961-01-03 | 1963-01-03 | Democrat | 7 | |||||||||||||
29283 | 29283 | James Fulbright F000401 | sen | AR | 1957-01-03 | 1963-01-03 | 3 | Democrat | |||||||||||||
29287 | 29287 | Jacob Gilbert G000175 | rep | NY | 1961-01-03 | 1963-01-03 | Democrat | 23 | |||||||||||||
29297 | 29297 | Charles Joelson J000108 | rep | NJ | 1961-01-03 | 1963-01-03 | Democrat | 8 | |||||||||||||
29314 | 29314 | Michael Kirwan K000244 | rep | OH | 1961-01-03 | 1963-01-03 | Democrat | 19 | |||||||||||||
29381 | 29381 | John McCormack M000364 | rep | MA | 1961-01-03 | 1963-01-03 | Democrat | 12 | |||||||||||||
29393 | 29393 | William Murphy M001104 | rep | IL | 1961-01-03 | 1963-01-03 | Democrat | 3 | |||||||||||||
29401 | 29401 | Arnold Olsen O000083 | rep | MT | 1961-01-03 | 1963-01-03 | Democrat | 1 | |||||||||||||
29415 | 29415 | Philip Philbin P000303 | rep | MA | 1961-01-03 | 1963-01-03 | Democrat | 3 | |||||||||||||
29430 | 29430 | Adam Powell P000477 | rep | NY | 1961-01-03 | 1963-01-03 | Democrat | 16 | |||||||||||||
29453 | 29453 | Lucius Rivers R000280 | rep | SC | 1961-01-03 | 1963-01-03 | Democrat | 1 | |||||||||||||
29463 | 29463 | Byron Rogers R000389 | rep | CO | 1961-01-03 | 1963-01-03 | Democrat | 1 | |||||||||||||
29518 | 29518 | Watkins Abbitt A000002 | rep | VA | 1961-01-03 | 1963-01-03 | Democrat | 4 | |||||||||||||
29533 | 29533 | Thomas Abernethy A000016 | rep | MS | 1961-01-03 | 1963-01-03 | Democrat | 1 | |||||||||||||
29553 | 29553 | George Andrews A000206 | rep | AL | 1961-01-03 | 1963-01-03 | Democrat | 3 | |||||||||||||
29565 | 29565 | Wayne Aspinall A000225 | rep | CO | 1961-01-03 | 1963-01-03 | Democrat | 4 | |||||||||||||
29575 | 29575 | Walter Baring B000141 | rep | NV | 1961-01-03 | 1963-01-03 | Democrat | 0 | |||||||||||||
29617 | 29617 | Thomas Boggs B000594 | rep | LA | 1961-01-03 | 1963-01-03 | Democrat | 2 | |||||||||||||
29644 | 29644 | James Byrne B001212 | rep | PA | 1961-01-03 | 1963-01-03 | Democrat | 3 | |||||||||||||
29690 | 29690 | Emanuel Celler C000264 | rep | NY | 1961-01-03 | 1963-01-03 | Democrat | 11 | |||||||||||||
29710 | 29710 | William Colmer C000645 | rep | MS | 1961-01-03 | 1963-01-03 | Democrat | 6 | |||||||||||||
29743 | 29743 | John Dowdy D000467 | rep | TX | 1961-01-03 | 1963-01-03 | Democrat | 7 | |||||||||||||
29761 | 29761 | Edmond Edmondson E000054 | rep | OK | 1961-01-03 | 1963-01-03 | Democrat | 2 | |||||||||||||
29794 | 29794 | Cornelius Gallagher G000016 | rep | NJ | 1961-01-03 | 1963-01-03 | Democrat | 13 | |||||||||||||
29808 | 29808 | Edward Garmatz G000071 | rep | MD | 1961-01-03 | 1963-01-03 | Democrat | 3 | |||||||||||||
29817 | 29817 | George Hagan H000010 | rep | GA | 1961-01-03 | 1963-01-03 | Democrat | 1 | |||||||||||||
29851 | 29851 | William Hull H000947 | rep | MO | 1961-01-03 | 1963-01-03 | Democrat | 6 | |||||||||||||
29887 | 29887 | Alton Lennon L000240 | rep | NC | 1961-01-03 | 1963-01-03 | Democrat | 7 | |||||||||||||
29942 | 29942 | John McMillan M000568 | rep | SC | 1961-01-03 | 1963-01-03 | Democrat | 6 | |||||||||||||
29956 | 29956 | George Miller M000727 | rep | CA | 1961-01-03 | 1963-01-03 | Democrat | 8 | |||||||||||||
29963 | 29963 | John Monagan M000847 | rep | CT | 1961-01-03 | 1963-01-03 | Democrat | 5 | |||||||||||||
29971 | 29971 | Joseph Montoya M000876 | rep | NM | 1961-01-03 | 1963-01-03 | Democrat | 0 | |||||||||||||
30038 | 30038 | Roman Pucinski P000559 | rep | IL | 1961-01-03 | 1963-01-03 | Democrat | 11 | |||||||||||||
30044 | 30044 | Graham Purcell P000569 | rep | TX | 1961-01-03 | 1963-01-03 | Democrat | 13 | |||||||||||||
30055 | 30055 | William Ryan R000562 | rep | NY | 1961-01-03 | 1963-01-03 | Democrat | 20 | |||||||||||||
30122 | 30122 | John Watts W000212 | rep | KY | 1961-01-03 | 1963-01-03 | Democrat | 6 | |||||||||||||
30172 | 30172 | John Blatnik B000550 | rep | MN | 1961-01-03 | 1963-01-03 | Democrat | 8 | |||||||||||||
30216 | 30216 | Hugh Carey C000143 | rep | NY | 1961-01-03 | 1963-01-03 | Democrat | 12 | |||||||||||||
30244 | 30244 | Frank Clark C000431 | rep | PA | 1961-01-03 | 1963-01-03 | Democrat | 25 | |||||||||||||
30286 | 30286 | John Davis D000122 | rep | GA | 1961-01-03 | 1963-01-03 | Democrat | 7 | |||||||||||||
30309 | 30309 | Harold Donohue D000419 | rep | MA | 1961-01-03 | 1963-01-03 | Democrat | 4 | |||||||||||||
30322 | 30322 | William Dorn D000434 | rep | SC | 1961-01-03 | 1963-01-03 | Democrat | 3 | |||||||||||||
30330 | 30330 | Thaddeus Dulski D000523 | rep | NY | 1961-01-03 | 1963-01-03 | Democrat | 41 | |||||||||||||
30353 | 30353 | Ovie Fisher F000152 | rep | TX | 1961-01-03 | 1963-01-03 | Democrat | 21 | |||||||||||||
30389 | 30389 | Edith Green G000407 | rep | OR | 1961-01-03 | 1963-01-03 | Democrat | 3 | |||||||||||||
30407 | 30407 | Martha Griffiths G000471 | rep | MI | 1961-01-03 | 1963-01-03 | Democrat | 17 | |||||||||||||
30455 | 30455 | Julia Hansen H000174 | rep | WA | 1961-01-03 | 1963-01-03 | Democrat | 3 | |||||||||||||
30490 | 30490 | Chester Holifield H000713 | rep | CA | 1961-01-03 | 1963-01-03 | Democrat | 19 | |||||||||||||
30650 | 30650 | John Rooney R000424 | rep | NY | 1961-01-03 | 1963-01-03 | Democrat | 14 | |||||||||||||
30709 | 30709 | Frank Stubblefield S001037 | rep | KY | 1961-01-03 | 1963-01-03 | Democrat | 1 | |||||||||||||
30810 | 30810 | Carl Albert A000073 | rep | OK | 1961-01-03 | 1963-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);