legislator_terms
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
481 rows where "start" is on date 1963-01-09 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
28404 | 28404 | Paul Dague D000004 | rep | PA | 1963-01-09 | 1965-01-03 | Republican | 9 | |||||||||||||
30894 | 30894 | Dominick Daniels D000041 | rep | NJ | 1963-01-09 | 1965-01-03 | Democrat | 14 | |||||||||||||
27735 | 27735 | Clifford Davis D000094 | rep | TN | 1963-01-09 | 1965-01-03 | Democrat | 9 | |||||||||||||
30287 | 30287 | John Davis D000122 | rep | GA | 1963-01-09 | 1965-01-03 | Democrat | 7 | |||||||||||||
29214 | 29214 | William Dawson D000158 | rep | IL | 1963-01-09 | 1965-01-03 | Democrat | 1 | |||||||||||||
31519 | 31519 | James Delaney D000211 | rep | NY | 1963-01-09 | 1965-01-03 | Democrat | 9 | |||||||||||||
31530 | 31530 | John Dent D000255 | rep | PA | 1963-01-09 | 1965-01-03 | Democrat | 21 | |||||||||||||
28412 | 28412 | Winfield Denton D000260 | rep | IN | 1963-01-09 | 1965-01-03 | Democrat | 8 | |||||||||||||
27741 | 27741 | Steven Derounian D000266 | rep | NY | 1963-01-09 | 1965-01-03 | Republican | 3 | |||||||||||||
32598 | 32598 | Edward Derwinski D000269 | rep | IL | 1963-01-09 | 1965-01-03 | Republican | 4 | |||||||||||||
32017 | 32017 | Samuel Devine D000279 | rep | OH | 1963-01-09 | 1965-01-03 | Republican | 12 | |||||||||||||
32030 | 32030 | Charles Diggs D000344 | rep | MI | 1963-01-09 | 1965-01-03 | Democrat | 13 | |||||||||||||
39803 | 39803 | John Dingell D000355 | rep | MI | 1963-01-09 | 1965-01-03 | Democrat | 15 | |||||||||||||
27752 | 27752 | Everett Dirksen D000360 | sen | IL | 1963-01-09 | 1969-01-03 | 3 | Republican | |||||||||||||
35191 | 35191 | Robert Dole D000401 | rep | KS | 1963-01-09 | 1965-01-03 | Republican | 1 | |||||||||||||
29221 | 29221 | Peter Dominick D000409 | sen | CO | 1963-01-09 | 1969-01-03 | 3 | Republican | |||||||||||||
30310 | 30310 | Harold Donohue D000419 | rep | MA | 1963-01-09 | 1965-01-03 | Democrat | 4 | |||||||||||||
30323 | 30323 | William Dorn D000434 | rep | SC | 1963-01-09 | 1965-01-03 | Democrat | 3 | |||||||||||||
29744 | 29744 | John Dowdy D000467 | rep | TX | 1963-01-09 | 1965-01-03 | Democrat | 7 | |||||||||||||
30903 | 30903 | Thomas Downing D000474 | rep | VA | 1963-01-09 | 1965-01-03 | Democrat | 1 | |||||||||||||
27761 | 27761 | Clyde Doyle D000481 | rep | CA | 1963-01-09 | 1965-01-03 | Democrat | 23 | |||||||||||||
30331 | 30331 | Thaddeus Dulski D000523 | rep | NY | 1963-01-09 | 1965-01-03 | Democrat | 41 | |||||||||||||
32044 | 32044 | Robert Duncan D000537 | rep | OR | 1963-01-09 | 1965-01-03 | Democrat | 4 | |||||||||||||
29752 | 29752 | Florence Dwyer D000587 | rep | NJ | 1963-01-09 | 1965-01-03 | Republican | 6 | |||||||||||||
29762 | 29762 | Edmond Edmondson E000054 | rep | OK | 1963-01-09 | 1965-01-03 | Democrat | 2 | |||||||||||||
27762 | 27762 | James Edmondson E000055 | sen | OK | 1963-01-09 | 1965-01-03 | 2 | Democrat | appointment | ||||||||||||
35199 | 35199 | William Edwards E000064 | rep | CA | 1963-01-09 | 1965-01-03 | Democrat | 9 | |||||||||||||
27770 | 27770 | Carl Elliott E000120 | rep | AL | 1963-01-09 | 1965-01-03 | Democrat | 0 | |||||||||||||
28420 | 28420 | Robert Ellsworth E000148 | rep | KS | 1963-01-09 | 1965-01-03 | Republican | 3 | |||||||||||||
29226 | 29226 | Samuel Ervin E000211 | sen | NC | 1963-01-09 | 1969-01-03 | 3 | Democrat | |||||||||||||
29231 | 29231 | Robert Everett E000266 | rep | TN | 1963-01-09 | 1965-01-03 | Democrat | 8 | |||||||||||||
30929 | 30929 | Joseph Evins E000273 | rep | TN | 1963-01-09 | 1965-01-03 | Democrat | 4 | |||||||||||||
29244 | 29244 | George Fallon F000012 | rep | MD | 1963-01-09 | 1965-01-03 | Democrat | 4 | |||||||||||||
29251 | 29251 | Leonard Farbstein F000015 | rep | NY | 1963-01-09 | 1965-01-03 | Democrat | 19 | |||||||||||||
34446 | 34446 | Dante Fascell F000041 | rep | FL | 1963-01-09 | 1965-01-03 | Democrat | 4 | |||||||||||||
29265 | 29265 | Michael Feighan F000060 | rep | OH | 1963-01-09 | 1965-01-03 | Democrat | 20 | |||||||||||||
27780 | 27780 | Antonio Fernós-Isern F000087 | rep | PR | 1963-01-09 | 1965-01-03 | Popular Democrat | 0 | |||||||||||||
32644 | 32644 | Paul Findley F000123 | rep | IL | 1963-01-09 | 1965-01-03 | Republican | 20 | |||||||||||||
27782 | 27782 | Edward Finnegan F000135 | rep | IL | 1963-01-09 | 1965-01-03 | Democrat | 9 | |||||||||||||
28827 | 28827 | Paul Fino F000137 | rep | NY | 1963-01-09 | 1965-01-03 | Republican | 24 | |||||||||||||
30354 | 30354 | Ovie Fisher F000152 | rep | TX | 1963-01-09 | 1965-01-03 | Democrat | 21 | |||||||||||||
32067 | 32067 | Daniel Flood F000209 | rep | PA | 1963-01-09 | 1965-01-03 | Democrat | 11 | |||||||||||||
31561 | 31561 | John Flynt F000229 | rep | GA | 1963-01-09 | 1965-01-03 | Democrat | 4 | |||||||||||||
28841 | 28841 | John Fogarty F000233 | rep | RI | 1963-01-09 | 1965-01-03 | Democrat | 2 | |||||||||||||
30794 | 30794 | Gerald Ford F000260 | rep | MI | 1963-01-09 | 1965-01-03 | Republican | 5 | |||||||||||||
29269 | 29269 | Edgar Foreman F000272 | rep | TX | 1963-01-09 | 1965-01-03 | Republican | 16 | |||||||||||||
27789 | 27789 | Elijah Forrester F000283 | rep | GA | 1963-01-09 | 1965-01-03 | Democrat | 3 | |||||||||||||
32663 | 32663 | Lawrence Fountain F000319 | rep | NC | 1963-01-09 | 1965-01-03 | Democrat | 2 | |||||||||||||
31569 | 31569 | Donald Fraser F000350 | rep | MN | 1963-01-09 | 1965-01-03 | Democrat | 5 | |||||||||||||
30365 | 30365 | Peter Frelinghuysen F000371 | rep | NJ | 1963-01-09 | 1965-01-03 | Republican | 5 | |||||||||||||
29276 | 29276 | Samuel Friedel F000384 | rep | MD | 1963-01-09 | 1965-01-03 | Democrat | 7 | |||||||||||||
29284 | 29284 | James Fulbright F000401 | sen | AR | 1963-01-09 | 1969-01-03 | 3 | Democrat | |||||||||||||
29785 | 29785 | James Fulton F000422 | rep | PA | 1963-01-09 | 1965-01-03 | Republican | 27 | |||||||||||||
30936 | 30936 | Richard Fulton F000424 | rep | TN | 1963-01-09 | 1965-01-03 | Democrat | 5 | |||||||||||||
33270 | 33270 | Don Fuqua F000430 | rep | FL | 1963-01-09 | 1965-01-03 | Democrat | 9 | |||||||||||||
29795 | 29795 | Cornelius Gallagher G000016 | rep | NJ | 1963-01-09 | 1965-01-03 | Democrat | 13 | |||||||||||||
29809 | 29809 | Edward Garmatz G000071 | rep | MD | 1963-01-09 | 1965-01-03 | Democrat | 3 | |||||||||||||
27799 | 27799 | Julian Gary G000091 | rep | VA | 1963-01-09 | 1965-01-03 | Democrat | 3 | |||||||||||||
28857 | 28857 | Ezekiel Gathings G000098 | rep | AR | 1963-01-09 | 1965-01-03 | Democrat | 1 | |||||||||||||
27810 | 27810 | Leon Gavin G000102 | rep | PA | 1963-01-09 | 1965-01-03 | Republican | 23 | |||||||||||||
30372 | 30372 | Thomas Gettys G000144 | rep | SC | 1963-01-09 | 1965-01-03 | Democrat | 5 | |||||||||||||
32078 | 32078 | Robert Giaimo G000151 | rep | CT | 1963-01-09 | 1965-01-03 | Democrat | 3 | |||||||||||||
35821 | 35821 | Sam Gibbons G000153 | rep | FL | 1963-01-09 | 1965-01-03 | Democrat | 10 | |||||||||||||
29288 | 29288 | Jacob Gilbert G000175 | rep | NY | 1963-01-09 | 1965-01-03 | Democrat | 22 | |||||||||||||
27811 | 27811 | Thomas Gill G000192 | rep | HI | 1963-01-09 | 1965-01-03 | Democrat | 1 | |||||||||||||
27815 | 27815 | Milton Glenn G000237 | rep | NJ | 1963-01-09 | 1965-01-03 | Republican | 2 | |||||||||||||
36204 | 36204 | Henry González G000272 | rep | TX | 1963-01-09 | 1965-01-03 | Democrat | 20 | |||||||||||||
29100 | 29100 | Charles Goodell G000282 | rep | NY | 1963-01-09 | 1965-01-03 | Republican | 38 | |||||||||||||
30379 | 30379 | George Goodling G000290 | rep | PA | 1963-01-09 | 1965-01-03 | Republican | 19 | |||||||||||||
28435 | 28435 | Bernard Grabowski G000348 | rep | CT | 1963-01-09 | 1965-01-03 | Democrat | 0 | |||||||||||||
27829 | 27829 | George Grant G000381 | rep | AL | 1963-01-09 | 1965-01-03 | Democrat | 0 | |||||||||||||
33592 | 33592 | Kenneth Gray G000400 | rep | IL | 1963-01-09 | 1965-01-03 | Democrat | 21 | |||||||||||||
30390 | 30390 | Edith Green G000407 | rep | OR | 1963-01-09 | 1965-01-03 | Democrat | 3 | |||||||||||||
27838 | 27838 | William Green G000421 | rep | PA | 1963-01-09 | 1965-01-03 | Democrat | 5 | |||||||||||||
30399 | 30399 | Robert Griffin G000465 | rep | MI | 1963-01-09 | 1965-01-03 | Republican | 9 | |||||||||||||
30408 | 30408 | Martha Griffiths G000471 | rep | MI | 1963-01-09 | 1965-01-03 | Democrat | 17 | |||||||||||||
30421 | 30421 | Harold Gross G000495 | rep | IA | 1963-01-09 | 1965-01-03 | Republican | 3 | |||||||||||||
30427 | 30427 | James Grover G000504 | rep | NY | 1963-01-09 | 1965-01-03 | Republican | 2 | |||||||||||||
27840 | 27840 | Ernest Gruening G000508 | sen | AK | 1963-01-09 | 1969-01-03 | 3 | Democrat | |||||||||||||
30438 | 30438 | Charles Gubser G000512 | rep | CA | 1963-01-09 | 1965-01-03 | Republican | 10 | |||||||||||||
29292 | 29292 | Edward Gurney G000531 | rep | FL | 1963-01-09 | 1965-01-03 | Republican | 11 | |||||||||||||
29818 | 29818 | George Hagan H000010 | rep | GA | 1963-01-09 | 1965-01-03 | Democrat | 1 | |||||||||||||
28444 | 28444 | Harlan Hagen H000013 | rep | CA | 1963-01-09 | 1965-01-03 | Democrat | 18 | |||||||||||||
30962 | 30962 | James Haley H000041 | rep | FL | 1963-01-09 | 1965-01-03 | Democrat | 7 | |||||||||||||
29824 | 29824 | Durward Hall H000049 | rep | MO | 1963-01-09 | 1965-01-03 | Republican | 7 | |||||||||||||
28874 | 28874 | Charles Halleck H000081 | rep | IN | 1963-01-09 | 1965-01-03 | Republican | 2 | |||||||||||||
29831 | 29831 | Seymour Halpern H000085 | rep | NY | 1963-01-09 | 1965-01-03 | Republican | 6 | |||||||||||||
30445 | 30445 | Richard Hanna H000164 | rep | CA | 1963-01-09 | 1965-01-03 | Democrat | 34 | |||||||||||||
30456 | 30456 | Julia Hansen H000174 | rep | WA | 1963-01-09 | 1965-01-03 | Democrat | 3 | |||||||||||||
27842 | 27842 | Ralph Harding H000191 | rep | ID | 1963-01-09 | 1965-01-03 | Democrat | 2 | |||||||||||||
28885 | 28885 | Porter Hardy H000197 | rep | VA | 1963-01-09 | 1965-01-03 | Democrat | 2 | |||||||||||||
28458 | 28458 | Oren Harris H000249 | rep | AR | 1963-01-09 | 1965-01-03 | Democrat | 4 | |||||||||||||
28893 | 28893 | William Harrison H000278 | rep | WY | 1963-01-09 | 1965-01-03 | Republican | 0 | |||||||||||||
32101 | 32101 | William Harsha H000281 | rep | OH | 1963-01-09 | 1965-01-03 | Republican | 6 | |||||||||||||
30466 | 30466 | James Harvey H000306 | rep | MI | 1963-01-09 | 1965-01-03 | Republican | 8 | |||||||||||||
28467 | 28467 | Ralph Harvey H000310 | rep | IN | 1963-01-09 | 1965-01-03 | Republican | 10 | |||||||||||||
33933 | 33933 | Augustus Hawkins H000367 | rep | CA | 1963-01-09 | 1965-01-03 | Democrat | 21 | |||||||||||||
27857 | 27857 | Carl Hayden H000385 | sen | AZ | 1963-01-09 | 1969-01-03 | 3 | Democrat | |||||||||||||
30982 | 30982 | Wayne Hays H000408 | rep | OH | 1963-01-09 | 1965-01-03 | Democrat | 18 | |||||||||||||
27862 | 27862 | James Healey H000424 | rep | NY | 1963-01-09 | 1965-01-03 | Democrat | 21 |
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);