legislator_terms
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
482 rows where "end" is on date 1951-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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
30269 | 30269 | Carl Curtis C001006 | rep | NE | 1949-01-03 | 1951-01-03 | Republican | 1 | |||||||||||||
28397 | 28397 | Paul Dague D000004 | rep | PA | 1949-01-03 | 1951-01-03 | Republican | 9 | |||||||||||||
24815 | 24815 | Harry Darby D000048 | sen | KS | 1949-12-02 | 1951-01-03 | 3 | Republican | appointment | ||||||||||||
24816 | 24816 | Harry Davenport D000071 | rep | PA | 1949-01-03 | 1951-01-03 | Democrat | 29 | |||||||||||||
24817 | 24817 | John Davies D000089 | rep | NY | 1949-01-03 | 1951-01-03 | Democrat | 35 | |||||||||||||
27728 | 27728 | Clifford Davis D000094 | rep | TN | 1949-01-03 | 1951-01-03 | Democrat | 10 | |||||||||||||
30277 | 30277 | Glenn Davis D000102 | rep | WI | 1949-01-03 | 1951-01-03 | Republican | 2 | |||||||||||||
27171 | 27171 | James Davis D000109 | rep | GA | 1949-01-03 | 1951-01-03 | Democrat | 5 | |||||||||||||
29207 | 29207 | William Dawson D000158 | rep | IL | 1949-01-03 | 1951-01-03 | Democrat | 1 | |||||||||||||
25907 | 25907 | Charles Deane D000175 | rep | NC | 1949-01-03 | 1951-01-03 | Democrat | 8 | |||||||||||||
25569 | 25569 | Edward deGraffenried D000198 | rep | AL | 1949-01-03 | 1951-01-03 | Democrat | 6 | |||||||||||||
31512 | 31512 | James Delaney D000211 | rep | NY | 1949-01-03 | 1951-01-03 | Democrat | 6 | |||||||||||||
28406 | 28406 | Winfield Denton D000260 | rep | IN | 1949-01-03 | 1951-01-03 | Democrat | 8 | |||||||||||||
25660 | 25660 | Wesley D’Ewart D000281 | rep | MT | 1949-01-03 | 1951-01-03 | Republican | 2 | |||||||||||||
25919 | 25919 | John Dingell D000354 | rep | MI | 1949-01-03 | 1951-01-03 | Democrat | 15 | |||||||||||||
26816 | 26816 | Isidore Dollinger D000402 | rep | NY | 1949-01-03 | 1951-01-03 | Democrat | 24 | |||||||||||||
25925 | 25925 | James Dolliver D000403 | rep | IA | 1949-01-03 | 1951-01-03 | Republican | 6 | |||||||||||||
25937 | 25937 | George Dondero D000411 | rep | MI | 1949-01-03 | 1951-01-03 | Republican | 17 | |||||||||||||
23838 | 23838 | Forrest Donnell D000414 | sen | MO | 1945-01-03 | 1951-01-03 | 3 | Republican | |||||||||||||
30303 | 30303 | Harold Donohue D000419 | rep | MA | 1949-01-03 | 1951-01-03 | Democrat | 4 | |||||||||||||
25232 | 25232 | Robert Doughton D000448 | rep | NC | 1949-01-03 | 1951-01-03 | Democrat | 9 | |||||||||||||
24820 | 24820 | Helen Douglas D000454 | rep | CA | 1949-01-03 | 1951-01-03 | Democrat | 14 | |||||||||||||
23841 | 23841 | Sheridan Downey D000469 | sen | CA | 1945-01-03 | 1951-01-03 | 3 | Democrat | |||||||||||||
27754 | 27754 | Clyde Doyle D000481 | rep | CA | 1949-01-03 | 1951-01-03 | Democrat | 18 | |||||||||||||
26831 | 26831 | Carl Durham D000571 | rep | NC | 1949-01-03 | 1951-01-03 | Democrat | 6 | |||||||||||||
25247 | 25247 | Charles Eaton E000023 | rep | NJ | 1949-01-03 | 1951-01-03 | Republican | 5 | |||||||||||||
26316 | 26316 | Herman Eberharter E000029 | rep | PA | 1949-01-03 | 1951-01-03 | Democrat | 32 | |||||||||||||
27763 | 27763 | Carl Elliott E000120 | rep | AL | 1949-01-03 | 1951-01-03 | Democrat | 7 | |||||||||||||
25947 | 25947 | Mathew Ellsworth E000146 | rep | OR | 1949-01-03 | 1951-01-03 | Republican | 4 | |||||||||||||
25254 | 25254 | Charles Elston E000160 | rep | OH | 1949-01-03 | 1951-01-03 | Republican | 1 | |||||||||||||
24829 | 24829 | Albert Engel E000178 | rep | MI | 1949-01-03 | 1951-01-03 | Republican | 9 | |||||||||||||
26841 | 26841 | Clair Engle E000181 | rep | CA | 1949-01-03 | 1951-01-03 | Democrat | 2 | |||||||||||||
30922 | 30922 | Joseph Evins E000273 | rep | TN | 1949-01-03 | 1951-01-03 | Democrat | 5 | |||||||||||||
29237 | 29237 | George Fallon F000012 | rep | MD | 1949-01-03 | 1951-01-03 | Democrat | 4 | |||||||||||||
25667 | 25667 | Joseph Farrington F000034 | rep | HI | 1949-01-03 | 1951-01-03 | Republican | 0 | |||||||||||||
29258 | 29258 | Michael Feighan F000060 | rep | OH | 1949-01-03 | 1951-01-03 | Democrat | 20 | |||||||||||||
25260 | 25260 | Frank Fellows F000066 | rep | ME | 1949-01-03 | 1951-01-03 | Republican | 3 | |||||||||||||
27197 | 27197 | Ivor Fenton F000075 | rep | PA | 1949-01-03 | 1951-01-03 | Republican | 12 | |||||||||||||
25956 | 25956 | Antonio Fernández F000085 | rep | NM | 1949-01-03 | 1951-01-03 | Democrat | 0 | |||||||||||||
27773 | 27773 | Antonio Fernós-Isern F000087 | rep | PR | 1949-01-03 | 1951-01-03 | Popular Democrat | 0 | |||||||||||||
30347 | 30347 | Ovie Fisher F000152 | rep | TX | 1949-01-03 | 1951-01-03 | Democrat | 21 | |||||||||||||
32061 | 32061 | Daniel Flood F000209 | rep | PA | 1949-01-03 | 1951-01-03 | Democrat | 11 | |||||||||||||
28834 | 28834 | John Fogarty F000233 | rep | RI | 1949-01-03 | 1951-01-03 | Democrat | 2 | |||||||||||||
26854 | 26854 | Aime Forand F000255 | rep | RI | 1949-01-03 | 1951-01-03 | Democrat | 1 | |||||||||||||
30787 | 30787 | Gerald Ford F000260 | rep | MI | 1949-01-03 | 1951-01-03 | Republican | 5 | |||||||||||||
27204 | 27204 | James Frazier F000353 | rep | TN | 1949-01-03 | 1951-01-03 | Democrat | 3 | |||||||||||||
25262 | 25262 | Thomas Fugate F000399 | rep | VA | 1949-01-03 | 1951-01-03 | Democrat | 9 | |||||||||||||
29281 | 29281 | James Fulbright F000401 | sen | AR | 1945-01-03 | 1951-01-03 | 3 | Democrat | |||||||||||||
29778 | 29778 | James Fulton F000422 | rep | PA | 1949-01-03 | 1951-01-03 | Republican | 31 | |||||||||||||
25264 | 25264 | John Furcolo F000431 | rep | MA | 1949-01-03 | 1951-01-03 | Democrat | 2 | |||||||||||||
25972 | 25972 | Ralph Gamble G000031 | rep | NY | 1949-01-03 | 1951-01-03 | Republican | 28 | |||||||||||||
29802 | 29802 | Edward Garmatz G000071 | rep | MD | 1949-01-03 | 1951-01-03 | Democrat | 3 | |||||||||||||
27792 | 27792 | Julian Gary G000091 | rep | VA | 1949-01-03 | 1951-01-03 | Democrat | 3 | |||||||||||||
28850 | 28850 | Ezekiel Gathings G000098 | rep | AR | 1949-01-03 | 1951-01-03 | Democrat | 1 | |||||||||||||
27803 | 27803 | Leon Gavin G000102 | rep | PA | 1949-01-03 | 1951-01-03 | Republican | 19 | |||||||||||||
26321 | 26321 | Myron George G000129 | rep | KS | 1949-01-03 | 1951-01-03 | Republican | 3 | |||||||||||||
25270 | 25270 | Walter George G000131 | sen | GA | 1945-01-03 | 1951-01-03 | 3 | Democrat | |||||||||||||
25276 | 25276 | Wilson Gillette G000206 | rep | PA | 1949-01-03 | 1951-01-03 | Republican | 14 | |||||||||||||
24836 | 24836 | William Gilmer G000219 | rep | OK | 1949-01-03 | 1951-01-03 | Democrat | 1 | |||||||||||||
25673 | 25673 | James Golden G000258 | rep | KY | 1949-01-03 | 1951-01-03 | Republican | 9 | |||||||||||||
25679 | 25679 | Angier Goodwin G000297 | rep | MA | 1949-01-03 | 1951-01-03 | Republican | 8 | |||||||||||||
26329 | 26329 | Thomas Gordon G000316 | rep | IL | 1949-01-03 | 1951-01-03 | Democrat | 8 | |||||||||||||
28430 | 28430 | Albert Gore G000320 | rep | TN | 1949-01-03 | 1951-01-03 | Democrat | 4 | |||||||||||||
24837 | 24837 | Chester Gorski G000331 | rep | NY | 1949-01-03 | 1951-01-03 | Democrat | 44 | |||||||||||||
24841 | 24841 | Martin Gorski G000332 | rep | IL | 1949-01-03 | 1951-01-03 | Democrat | 5 | |||||||||||||
25283 | 25283 | Ed Gossett G000338 | rep | TX | 1949-01-03 | 1951-01-03 | Democrat | 13 | |||||||||||||
24842 | 24842 | Frank Graham G000353 | sen | NC | 1949-03-29 | 1951-01-03 | 2 | Democrat | appointment | ||||||||||||
25687 | 25687 | Louis Graham G000360 | rep | PA | 1949-01-03 | 1951-01-03 | Republican | 25 | |||||||||||||
25979 | 25979 | William Granahan G000369 | rep | PA | 1949-01-03 | 1951-01-03 | Democrat | 2 | |||||||||||||
25289 | 25289 | Walter Granger G000379 | rep | UT | 1949-01-03 | 1951-01-03 | Democrat | 1 | |||||||||||||
27822 | 27822 | George Grant G000381 | rep | AL | 1949-01-03 | 1951-01-03 | Democrat | 2 | |||||||||||||
27831 | 27831 | William Green G000421 | rep | PA | 1949-01-03 | 1951-01-03 | Democrat | 5 | |||||||||||||
26340 | 26340 | Noble Gregory G000447 | rep | KY | 1949-01-03 | 1951-01-03 | Democrat | 1 | |||||||||||||
30414 | 30414 | Harold Gross G000495 | rep | IA | 1949-01-03 | 1951-01-03 | Republican | 3 | |||||||||||||
24843 | 24843 | Ben Guill G000521 | rep | TX | 1949-01-03 | 1951-01-03 | Republican | 18 | |||||||||||||
23854 | 23854 | John Gurney G000532 | sen | SD | 1945-01-03 | 1951-01-03 | 3 | Republican | |||||||||||||
26347 | 26347 | Ralph Gwinn G000541 | rep | NY | 1949-01-03 | 1951-01-03 | Republican | 27 | |||||||||||||
25693 | 25693 | Harold Hagen H000014 | rep | MN | 1949-01-03 | 1951-01-03 | Republican | 9 | |||||||||||||
26355 | 26355 | Robert Hale H000036 | rep | ME | 1949-01-03 | 1951-01-03 | Republican | 1 | |||||||||||||
25297 | 25297 | Edwin Hall H000050 | rep | NY | 1949-01-03 | 1951-01-03 | Republican | 37 | |||||||||||||
25304 | 25304 | Leonard Hall H000060 | rep | NY | 1949-01-03 | 1951-01-03 | Republican | 2 | |||||||||||||
28867 | 28867 | Charles Halleck H000081 | rep | IN | 1949-01-03 | 1951-01-03 | Republican | 2 | |||||||||||||
25989 | 25989 | Thomas Hand H000154 | rep | NJ | 1949-01-03 | 1951-01-03 | Republican | 2 | |||||||||||||
26360 | 26360 | Cecil Harden H000182 | rep | IN | 1949-01-03 | 1951-01-03 | Republican | 6 | |||||||||||||
28878 | 28878 | Porter Hardy H000197 | rep | VA | 1949-01-03 | 1951-01-03 | Democrat | 2 | |||||||||||||
24844 | 24844 | James Hare H000202 | rep | SC | 1949-01-03 | 1951-01-03 | Democrat | 3 | |||||||||||||
28451 | 28451 | Oren Harris H000249 | rep | AR | 1949-01-03 | 1951-01-03 | Democrat | 7 | |||||||||||||
27218 | 27218 | Burr Harrison H000264 | rep | VA | 1949-01-03 | 1951-01-03 | Democrat | 7 | |||||||||||||
25703 | 25703 | Edward Hart H000284 | rep | NJ | 1949-01-03 | 1951-01-03 | Democrat | 14 | |||||||||||||
28461 | 28461 | Ralph Harvey H000310 | rep | IN | 1949-01-03 | 1951-01-03 | Republican | 10 | |||||||||||||
25310 | 25310 | Franck Havenner H000356 | rep | CA | 1949-01-03 | 1951-01-03 | Democrat | 4 | |||||||||||||
27854 | 27854 | Carl Hayden H000385 | sen | AZ | 1945-01-03 | 1951-01-03 | 3 | Democrat | |||||||||||||
26373 | 26373 | Lawrence Hays H000405 | rep | AR | 1949-01-03 | 1951-01-03 | Democrat | 5 | |||||||||||||
30975 | 30975 | Wayne Hays H000408 | rep | OH | 1949-01-03 | 1951-01-03 | Democrat | 18 | |||||||||||||
31039 | 31039 | Felix Hébert H000437 | rep | LA | 1949-01-03 | 1951-01-03 | Democrat | 1 | |||||||||||||
25314 | 25314 | Erland Hedrick H000442 | rep | WV | 1949-01-03 | 1951-01-03 | Democrat | 6 | |||||||||||||
25320 | 25320 | James Heffernan H000443 | rep | NY | 1949-01-03 | 1951-01-03 | Democrat | 11 | |||||||||||||
25706 | 25706 | Louis Heller H000460 | rep | NY | 1949-01-03 | 1951-01-03 | Democrat | 7 | |||||||||||||
28895 | 28895 | Albert Herlong H000530 | rep | FL | 1949-01-03 | 1951-01-03 | Democrat | 5 | |||||||||||||
25325 | 25325 | Christian Herter H000548 | rep | MA | 1949-01-03 | 1951-01-03 | Republican | 10 |
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);