legislator_terms
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
486 rows where "end" is on date 1953-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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
25188 | 25188 | Jesse Combs C000655 | rep | TX | 1951-01-03 | 1953-01-03 | Democrat | 2 | |||||||||||||
24322 | 24322 | Thomas Connally C000684 | sen | TX | 1947-01-03 | 1953-01-03 | 1 | Democrat | |||||||||||||
28382 | 28382 | Harold Cooley C000736 | rep | NC | 1951-01-03 | 1953-01-03 | Democrat | 4 | |||||||||||||
26261 | 26261 | Jere Cooper C000755 | rep | TN | 1951-01-03 | 1953-01-03 | Democrat | 9 | |||||||||||||
29721 | 29721 | Robert Corbett C000772 | rep | PA | 1951-01-03 | 1953-01-03 | Republican | 30 | |||||||||||||
30880 | 30880 | Norris Cotton C000802 | rep | NH | 1951-01-03 | 1953-01-03 | Republican | 2 | |||||||||||||
26267 | 26267 | Frederic Coudert C000804 | rep | NY | 1951-01-03 | 1953-01-03 | Republican | 17 | |||||||||||||
25202 | 25202 | Edward Cox C000831 | rep | GA | 1951-01-03 | 1953-01-03 | Democrat | 2 | |||||||||||||
25211 | 25211 | Fred Crawford C000889 | rep | MI | 1951-01-03 | 1953-01-03 | Republican | 8 | |||||||||||||
25656 | 25656 | Robert Crosser C000932 | rep | OH | 1951-01-03 | 1953-01-03 | Democrat | 21 | |||||||||||||
25902 | 25902 | Shepard Crumpacker C000960 | rep | IN | 1951-01-03 | 1953-01-03 | Republican | 3 | |||||||||||||
26279 | 26279 | Paul Cunningham C000993 | rep | IA | 1951-01-03 | 1953-01-03 | Republican | 5 | |||||||||||||
30270 | 30270 | Carl Curtis C001006 | rep | NE | 1951-01-03 | 1953-01-03 | Republican | 1 | |||||||||||||
28807 | 28807 | Thomas Curtis C001014 | rep | MO | 1951-01-03 | 1953-01-03 | Republican | 12 | |||||||||||||
28398 | 28398 | Paul Dague D000004 | rep | PA | 1951-01-03 | 1953-01-03 | Republican | 9 | |||||||||||||
27729 | 27729 | Clifford Davis D000094 | rep | TN | 1951-01-03 | 1953-01-03 | Democrat | 10 | |||||||||||||
30278 | 30278 | Glenn Davis D000102 | rep | WI | 1951-01-03 | 1953-01-03 | Republican | 2 | |||||||||||||
27172 | 27172 | James Davis D000109 | rep | GA | 1951-01-03 | 1953-01-03 | Democrat | 5 | |||||||||||||
29208 | 29208 | William Dawson D000158 | rep | IL | 1951-01-03 | 1953-01-03 | Democrat | 1 | |||||||||||||
25908 | 25908 | Charles Deane D000175 | rep | NC | 1951-01-03 | 1953-01-03 | Democrat | 8 | |||||||||||||
25570 | 25570 | Edward deGraffenried D000198 | rep | AL | 1951-01-03 | 1953-01-03 | Democrat | 6 | |||||||||||||
31513 | 31513 | James Delaney D000211 | rep | NY | 1951-01-03 | 1953-01-03 | Democrat | 6 | |||||||||||||
26291 | 26291 | John Dempsey D000228 | rep | NM | 1951-01-03 | 1953-01-03 | Democrat | 0 | |||||||||||||
25212 | 25212 | Harmar Denny D000249 | rep | PA | 1951-01-03 | 1953-01-03 | Republican | 29 | |||||||||||||
28407 | 28407 | Winfield Denton D000260 | rep | IN | 1951-01-03 | 1953-01-03 | Democrat | 8 | |||||||||||||
26296 | 26296 | James Devereux D000278 | rep | MD | 1951-01-03 | 1953-01-03 | Republican | 2 | |||||||||||||
25661 | 25661 | Wesley D’Ewart D000281 | rep | MT | 1951-01-03 | 1953-01-03 | Republican | 2 | |||||||||||||
25920 | 25920 | John Dingell D000354 | rep | MI | 1951-01-03 | 1953-01-03 | Democrat | 15 | |||||||||||||
26817 | 26817 | Isidore Dollinger D000402 | rep | NY | 1951-01-03 | 1953-01-03 | Democrat | 24 | |||||||||||||
25926 | 25926 | James Dolliver D000403 | rep | IA | 1951-01-03 | 1953-01-03 | Republican | 6 | |||||||||||||
25938 | 25938 | George Dondero D000411 | rep | MI | 1951-01-03 | 1953-01-03 | Republican | 17 | |||||||||||||
30304 | 30304 | Harold Donohue D000419 | rep | MA | 1951-01-03 | 1953-01-03 | Democrat | 4 | |||||||||||||
25941 | 25941 | James Donovan D000421 | rep | NY | 1951-01-03 | 1953-01-03 | Democrat | 18 | |||||||||||||
30317 | 30317 | William Dorn D000434 | rep | SC | 1951-01-03 | 1953-01-03 | Democrat | 3 | |||||||||||||
25233 | 25233 | Robert Doughton D000448 | rep | NC | 1951-01-03 | 1953-01-03 | Democrat | 9 | |||||||||||||
29738 | 29738 | John Dowdy D000467 | rep | TX | 1951-01-03 | 1953-01-03 | Democrat | 7 | |||||||||||||
27755 | 27755 | Clyde Doyle D000481 | rep | CA | 1951-01-03 | 1953-01-03 | Democrat | 18 | |||||||||||||
26832 | 26832 | Carl Durham D000571 | rep | NC | 1951-01-03 | 1953-01-03 | Democrat | 6 | |||||||||||||
25248 | 25248 | Charles Eaton E000023 | rep | NJ | 1951-01-03 | 1953-01-03 | Republican | 5 | |||||||||||||
26317 | 26317 | Herman Eberharter E000029 | rep | PA | 1951-01-03 | 1953-01-03 | Democrat | 32 | |||||||||||||
24369 | 24369 | Zales Ecton E000037 | sen | MT | 1947-01-03 | 1953-01-03 | 1 | Republican | |||||||||||||
27764 | 27764 | Carl Elliott E000120 | rep | AL | 1951-01-03 | 1953-01-03 | Democrat | 7 | |||||||||||||
25948 | 25948 | Mathew Ellsworth E000146 | rep | OR | 1951-01-03 | 1953-01-03 | Republican | 4 | |||||||||||||
25255 | 25255 | Charles Elston E000160 | rep | OH | 1951-01-03 | 1953-01-03 | Republican | 1 | |||||||||||||
26842 | 26842 | Clair Engle E000181 | rep | CA | 1951-01-03 | 1953-01-03 | Democrat | 2 | |||||||||||||
30923 | 30923 | Joseph Evins E000273 | rep | TN | 1951-01-03 | 1953-01-03 | Democrat | 5 | |||||||||||||
29238 | 29238 | George Fallon F000012 | rep | MD | 1951-01-03 | 1953-01-03 | Democrat | 4 | |||||||||||||
25668 | 25668 | Joseph Farrington F000034 | rep | HI | 1951-01-03 | 1953-01-03 | Republican | 0 | |||||||||||||
29259 | 29259 | Michael Feighan F000060 | rep | OH | 1951-01-03 | 1953-01-03 | Democrat | 20 | |||||||||||||
25261 | 25261 | Frank Fellows F000066 | rep | ME | 1951-01-03 | 1953-01-03 | Republican | 3 | |||||||||||||
27198 | 27198 | Ivor Fenton F000075 | rep | PA | 1951-01-03 | 1953-01-03 | Republican | 12 | |||||||||||||
25957 | 25957 | Antonio Fernández F000085 | rep | NM | 1951-01-03 | 1953-01-03 | Democrat | 0 | |||||||||||||
27774 | 27774 | Antonio Fernós-Isern F000087 | rep | PR | 1951-01-03 | 1953-01-03 | Popular Democrat | 0 | |||||||||||||
25960 | 25960 | Sidney Fine F000126 | rep | NY | 1951-01-03 | 1953-01-03 | Democrat | 23 | |||||||||||||
30348 | 30348 | Ovie Fisher F000152 | rep | TX | 1951-01-03 | 1953-01-03 | Democrat | 21 | |||||||||||||
25671 | 25671 | Ralph Flanders F000190 | sen | VT | 1947-01-03 | 1953-01-03 | 1 | Republican | |||||||||||||
32062 | 32062 | Daniel Flood F000209 | rep | PA | 1951-01-03 | 1953-01-03 | Democrat | 11 | |||||||||||||
28835 | 28835 | John Fogarty F000233 | rep | RI | 1951-01-03 | 1953-01-03 | Democrat | 2 | |||||||||||||
26855 | 26855 | Aime Forand F000255 | rep | RI | 1951-01-03 | 1953-01-03 | Democrat | 1 | |||||||||||||
30788 | 30788 | Gerald Ford F000260 | rep | MI | 1951-01-03 | 1953-01-03 | Republican | 5 | |||||||||||||
27783 | 27783 | Elijah Forrester F000283 | rep | GA | 1951-01-03 | 1953-01-03 | Democrat | 3 | |||||||||||||
27205 | 27205 | James Frazier F000353 | rep | TN | 1951-01-03 | 1953-01-03 | Democrat | 3 | |||||||||||||
25263 | 25263 | Thomas Fugate F000399 | rep | VA | 1951-01-03 | 1953-01-03 | Democrat | 9 | |||||||||||||
29779 | 29779 | James Fulton F000422 | rep | PA | 1951-01-03 | 1953-01-03 | Republican | 31 | |||||||||||||
25265 | 25265 | John Furcolo F000431 | rep | MA | 1951-01-03 | 1953-01-03 | Democrat | 2 | |||||||||||||
25973 | 25973 | Ralph Gamble G000031 | rep | NY | 1951-01-03 | 1953-01-03 | Republican | 28 | |||||||||||||
29803 | 29803 | Edward Garmatz G000071 | rep | MD | 1951-01-03 | 1953-01-03 | Democrat | 3 | |||||||||||||
27793 | 27793 | Julian Gary G000091 | rep | VA | 1951-01-03 | 1953-01-03 | Democrat | 3 | |||||||||||||
28851 | 28851 | Ezekiel Gathings G000098 | rep | AR | 1951-01-03 | 1953-01-03 | Democrat | 1 | |||||||||||||
27804 | 27804 | Leon Gavin G000102 | rep | PA | 1951-01-03 | 1953-01-03 | Republican | 19 | |||||||||||||
26322 | 26322 | Myron George G000129 | rep | KS | 1951-01-03 | 1953-01-03 | Republican | 3 | |||||||||||||
25277 | 25277 | Wilson Gillette G000206 | rep | PA | 1951-01-03 | 1953-01-03 | Republican | 14 | |||||||||||||
25674 | 25674 | James Golden G000258 | rep | KY | 1951-01-03 | 1953-01-03 | Republican | 9 | |||||||||||||
25680 | 25680 | Angier Goodwin G000297 | rep | MA | 1951-01-03 | 1953-01-03 | Republican | 8 | |||||||||||||
26330 | 26330 | Thomas Gordon G000316 | rep | IL | 1951-01-03 | 1953-01-03 | Democrat | 8 | |||||||||||||
28431 | 28431 | Albert Gore G000320 | rep | TN | 1951-01-03 | 1953-01-03 | Democrat | 4 | |||||||||||||
25284 | 25284 | Ed Gossett G000338 | rep | TX | 1951-01-03 | 1953-01-03 | Democrat | 13 | |||||||||||||
25688 | 25688 | Louis Graham G000360 | rep | PA | 1951-01-03 | 1953-01-03 | Republican | 25 | |||||||||||||
25980 | 25980 | William Granahan G000369 | rep | PA | 1951-01-03 | 1953-01-03 | Democrat | 2 | |||||||||||||
25290 | 25290 | Walter Granger G000379 | rep | UT | 1951-01-03 | 1953-01-03 | Democrat | 1 | |||||||||||||
27823 | 27823 | George Grant G000381 | rep | AL | 1951-01-03 | 1953-01-03 | Democrat | 2 | |||||||||||||
27832 | 27832 | William Green G000421 | rep | PA | 1951-01-03 | 1953-01-03 | Democrat | 5 | |||||||||||||
25291 | 25291 | Ernest Greenwood G000438 | rep | NY | 1951-01-03 | 1953-01-03 | Democrat | 1 | |||||||||||||
26341 | 26341 | Noble Gregory G000447 | rep | KY | 1951-01-03 | 1953-01-03 | Democrat | 1 | |||||||||||||
30415 | 30415 | Harold Gross G000495 | rep | IA | 1951-01-03 | 1953-01-03 | Republican | 3 | |||||||||||||
26348 | 26348 | Ralph Gwinn G000541 | rep | NY | 1951-01-03 | 1953-01-03 | Republican | 27 | |||||||||||||
25694 | 25694 | Harold Hagen H000014 | rep | MN | 1951-01-03 | 1953-01-03 | Republican | 9 | |||||||||||||
26356 | 26356 | Robert Hale H000036 | rep | ME | 1951-01-03 | 1953-01-03 | Republican | 1 | |||||||||||||
25298 | 25298 | Edwin Hall H000050 | rep | NY | 1951-01-03 | 1953-01-03 | Republican | 37 | |||||||||||||
25305 | 25305 | Leonard Hall H000060 | rep | NY | 1951-01-03 | 1953-01-03 | Republican | 2 | |||||||||||||
28868 | 28868 | Charles Halleck H000081 | rep | IN | 1951-01-03 | 1953-01-03 | Republican | 2 | |||||||||||||
25990 | 25990 | Thomas Hand H000154 | rep | NJ | 1951-01-03 | 1953-01-03 | Republican | 2 | |||||||||||||
26361 | 26361 | Cecil Harden H000182 | rep | IN | 1951-01-03 | 1953-01-03 | Republican | 6 | |||||||||||||
28879 | 28879 | Porter Hardy H000197 | rep | VA | 1951-01-03 | 1953-01-03 | Democrat | 2 | |||||||||||||
28452 | 28452 | Oren Harris H000249 | rep | AR | 1951-01-03 | 1953-01-03 | Democrat | 7 | |||||||||||||
27219 | 27219 | Burr Harrison H000264 | rep | VA | 1951-01-03 | 1953-01-03 | Democrat | 7 | |||||||||||||
26365 | 26365 | Robert Harrison H000275 | rep | NE | 1951-01-03 | 1953-01-03 | Republican | 3 | |||||||||||||
28890 | 28890 | William Harrison H000278 | rep | WY | 1951-01-03 | 1953-01-03 | Republican | 0 | |||||||||||||
25704 | 25704 | Edward Hart H000284 | rep | NJ | 1951-01-03 | 1953-01-03 | Democrat | 14 | |||||||||||||
28462 | 28462 | Ralph Harvey H000310 | rep | IN | 1951-01-03 | 1953-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);