legislator_terms
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
485 rows where "end" is on date 1955-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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
26271 | 26271 | Albert Cretella C000905 | rep | CT | 1953-01-03 | 1955-01-03 | Republican | 3 | |||||||||||||
25856 | 25856 | Edward Crippa C000906 | sen | WY | 1954-06-24 | 1955-01-03 | 2 | Republican | appointment | ||||||||||||
25657 | 25657 | Robert Crosser C000932 | rep | OH | 1953-01-03 | 1955-01-03 | Democrat | 21 | |||||||||||||
25903 | 25903 | Shepard Crumpacker C000960 | rep | IN | 1953-01-03 | 1955-01-03 | Republican | 3 | |||||||||||||
26280 | 26280 | Paul Cunningham C000993 | rep | IA | 1953-01-03 | 1955-01-03 | Republican | 5 | |||||||||||||
30271 | 30271 | Carl Curtis C001006 | rep | NE | 1953-01-03 | 1955-01-03 | Republican | 1 | |||||||||||||
27165 | 27165 | Laurence Curtis C001011 | rep | MA | 1953-01-03 | 1955-01-03 | Republican | 10 | |||||||||||||
28808 | 28808 | Thomas Curtis C001014 | rep | MO | 1953-01-03 | 1955-01-03 | Republican | 2 | |||||||||||||
28399 | 28399 | Paul Dague D000004 | rep | PA | 1953-01-03 | 1955-01-03 | Republican | 9 | |||||||||||||
25857 | 25857 | Charles Daniel D000031 | sen | SC | 1954-09-06 | 1955-01-03 | 2 | Democrat | appointment | ||||||||||||
27730 | 27730 | Clifford Davis D000094 | rep | TN | 1953-01-03 | 1955-01-03 | Democrat | 9 | |||||||||||||
30279 | 30279 | Glenn Davis D000102 | rep | WI | 1953-01-03 | 1955-01-03 | Republican | 2 | |||||||||||||
27173 | 27173 | James Davis D000109 | rep | GA | 1953-01-03 | 1955-01-03 | Democrat | 5 | |||||||||||||
26284 | 26284 | William Dawson D000155 | rep | UT | 1953-01-03 | 1955-01-03 | Republican | 2 | |||||||||||||
29209 | 29209 | William Dawson D000158 | rep | IL | 1953-01-03 | 1955-01-03 | Democrat | 1 | |||||||||||||
25909 | 25909 | Charles Deane D000175 | rep | NC | 1953-01-03 | 1955-01-03 | Democrat | 8 | |||||||||||||
31514 | 31514 | James Delaney D000211 | rep | NY | 1953-01-03 | 1955-01-03 | Democrat | 7 | |||||||||||||
26292 | 26292 | John Dempsey D000228 | rep | NM | 1953-01-03 | 1955-01-03 | Democrat | 0 | |||||||||||||
27736 | 27736 | Steven Derounian D000266 | rep | NY | 1953-01-03 | 1955-01-03 | Republican | 2 | |||||||||||||
26297 | 26297 | James Devereux D000278 | rep | MD | 1953-01-03 | 1955-01-03 | Republican | 2 | |||||||||||||
25662 | 25662 | Wesley D’Ewart D000281 | rep | MT | 1953-01-03 | 1955-01-03 | Republican | 2 | |||||||||||||
26307 | 26307 | Martin Dies D000338 | rep | TX | 1953-01-03 | 1955-01-03 | Democrat | 0 | |||||||||||||
25921 | 25921 | John Dingell D000354 | rep | MI | 1953-01-03 | 1955-01-03 | Democrat | 15 | |||||||||||||
28414 | 28414 | Thomas Dodd D000390 | rep | CT | 1953-01-03 | 1955-01-03 | Democrat | 1 | |||||||||||||
26818 | 26818 | Isidore Dollinger D000402 | rep | NY | 1953-01-03 | 1955-01-03 | Democrat | 23 | |||||||||||||
25927 | 25927 | James Dolliver D000403 | rep | IA | 1953-01-03 | 1955-01-03 | Republican | 6 | |||||||||||||
25939 | 25939 | George Dondero D000411 | rep | MI | 1953-01-03 | 1955-01-03 | Republican | 18 | |||||||||||||
30305 | 30305 | Harold Donohue D000419 | rep | MA | 1953-01-03 | 1955-01-03 | Democrat | 4 | |||||||||||||
25942 | 25942 | James Donovan D000421 | rep | NY | 1953-01-03 | 1955-01-03 | Democrat | 18 | |||||||||||||
26822 | 26822 | Francis Dorn D000433 | rep | NY | 1953-01-03 | 1955-01-03 | Republican | 12 | |||||||||||||
30318 | 30318 | William Dorn D000434 | rep | SC | 1953-01-03 | 1955-01-03 | Democrat | 3 | |||||||||||||
27181 | 27181 | Paul Douglas D000456 | sen | IL | 1949-01-03 | 1955-01-03 | 2 | Democrat | |||||||||||||
29739 | 29739 | John Dowdy D000467 | rep | TX | 1953-01-03 | 1955-01-03 | Democrat | 7 | |||||||||||||
27756 | 27756 | Clyde Doyle D000481 | rep | CA | 1953-01-03 | 1955-01-03 | Democrat | 23 | |||||||||||||
26833 | 26833 | Carl Durham D000571 | rep | NC | 1953-01-03 | 1955-01-03 | Democrat | 6 | |||||||||||||
27189 | 27189 | Henry Dworshak D000585 | sen | ID | 1949-10-14 | 1955-01-03 | 2 | Republican | appointment | ||||||||||||
30339 | 30339 | James Eastland E000018 | sen | MS | 1949-01-03 | 1955-01-03 | 2 | Democrat | |||||||||||||
26318 | 26318 | Herman Eberharter E000029 | rep | PA | 1953-01-03 | 1955-01-03 | Democrat | 28 | |||||||||||||
29757 | 29757 | Edmond Edmondson E000054 | rep | OK | 1953-01-03 | 1955-01-03 | Democrat | 2 | |||||||||||||
28818 | 28818 | Allen Ellender E000112 | sen | LA | 1949-01-03 | 1955-01-03 | 2 | Democrat | |||||||||||||
27765 | 27765 | Carl Elliott E000120 | rep | AL | 1953-01-03 | 1955-01-03 | Democrat | 7 | |||||||||||||
25949 | 25949 | Mathew Ellsworth E000146 | rep | OR | 1953-01-03 | 1955-01-03 | Republican | 4 | |||||||||||||
26843 | 26843 | Clair Engle E000181 | rep | CA | 1953-01-03 | 1955-01-03 | Democrat | 2 | |||||||||||||
30924 | 30924 | Joseph Evins E000273 | rep | TN | 1953-01-03 | 1955-01-03 | Democrat | 4 | |||||||||||||
29239 | 29239 | George Fallon F000012 | rep | MD | 1953-01-03 | 1955-01-03 | Democrat | 4 | |||||||||||||
25669 | 25669 | Joseph Farrington F000034 | rep | HI | 1953-01-03 | 1955-01-03 | Republican | 0 | |||||||||||||
25951 | 25951 | Mary Farrington F000035 | rep | HI | 1953-01-03 | 1955-01-03 | Republican | 0 | |||||||||||||
29260 | 29260 | Michael Feighan F000060 | rep | OH | 1953-01-03 | 1955-01-03 | Democrat | 20 | |||||||||||||
27199 | 27199 | Ivor Fenton F000075 | rep | PA | 1953-01-03 | 1955-01-03 | Republican | 12 | |||||||||||||
24831 | 24831 | Homer Ferguson F000081 | sen | MI | 1949-01-03 | 1955-01-03 | 2 | Republican | |||||||||||||
25958 | 25958 | Antonio Fernández F000085 | rep | NM | 1953-01-03 | 1955-01-03 | Democrat | 0 | |||||||||||||
27775 | 27775 | Antonio Fernós-Isern F000087 | rep | PR | 1953-01-03 | 1955-01-03 | Popular Democrat | 0 | |||||||||||||
25961 | 25961 | Sidney Fine F000126 | rep | NY | 1953-01-03 | 1955-01-03 | Democrat | 22 | |||||||||||||
28822 | 28822 | Paul Fino F000137 | rep | NY | 1953-01-03 | 1955-01-03 | Republican | 25 | |||||||||||||
30349 | 30349 | Ovie Fisher F000152 | rep | TX | 1953-01-03 | 1955-01-03 | Democrat | 21 | |||||||||||||
31556 | 31556 | John Flynt F000229 | rep | GA | 1953-01-03 | 1955-01-03 | Democrat | 4 | |||||||||||||
28836 | 28836 | John Fogarty F000233 | rep | RI | 1953-01-03 | 1955-01-03 | Democrat | 2 | |||||||||||||
26856 | 26856 | Aime Forand F000255 | rep | RI | 1953-01-03 | 1955-01-03 | Democrat | 1 | |||||||||||||
30789 | 30789 | Gerald Ford F000260 | rep | MI | 1953-01-03 | 1955-01-03 | Republican | 5 | |||||||||||||
27784 | 27784 | Elijah Forrester F000283 | rep | GA | 1953-01-03 | 1955-01-03 | Democrat | 3 | |||||||||||||
32658 | 32658 | Lawrence Fountain F000319 | rep | NC | 1953-01-03 | 1955-01-03 | Democrat | 2 | |||||||||||||
27206 | 27206 | James Frazier F000353 | rep | TN | 1953-01-03 | 1955-01-03 | Democrat | 3 | |||||||||||||
25964 | 25964 | Joseph Frear F000356 | sen | DE | 1949-01-03 | 1955-01-03 | 2 | Democrat | |||||||||||||
30360 | 30360 | Peter Frelinghuysen F000371 | rep | NJ | 1953-01-03 | 1955-01-03 | Republican | 5 | |||||||||||||
29271 | 29271 | Samuel Friedel F000384 | rep | MD | 1953-01-03 | 1955-01-03 | Democrat | 7 | |||||||||||||
29780 | 29780 | James Fulton F000422 | rep | PA | 1953-01-03 | 1955-01-03 | Republican | 27 | |||||||||||||
25974 | 25974 | Ralph Gamble G000031 | rep | NY | 1953-01-03 | 1955-01-03 | Republican | 26 | |||||||||||||
29804 | 29804 | Edward Garmatz G000071 | rep | MD | 1953-01-03 | 1955-01-03 | Democrat | 3 | |||||||||||||
27794 | 27794 | Julian Gary G000091 | rep | VA | 1953-01-03 | 1955-01-03 | Democrat | 3 | |||||||||||||
28852 | 28852 | Ezekiel Gathings G000098 | rep | AR | 1953-01-03 | 1955-01-03 | Democrat | 1 | |||||||||||||
27805 | 27805 | Leon Gavin G000102 | rep | PA | 1953-01-03 | 1955-01-03 | Republican | 23 | |||||||||||||
25976 | 25976 | Brady Gentry G000124 | rep | TX | 1953-01-03 | 1955-01-03 | Democrat | 3 | |||||||||||||
26323 | 26323 | Myron George G000129 | rep | KS | 1953-01-03 | 1955-01-03 | Republican | 3 | |||||||||||||
24835 | 24835 | Guy Gillette G000205 | sen | IA | 1949-01-03 | 1955-01-03 | 2 | Democrat | |||||||||||||
25675 | 25675 | James Golden G000258 | rep | KY | 1953-01-03 | 1955-01-03 | Republican | 8 | |||||||||||||
25681 | 25681 | Angier Goodwin G000297 | rep | MA | 1953-01-03 | 1955-01-03 | Republican | 8 | |||||||||||||
26331 | 26331 | Thomas Gordon G000316 | rep | IL | 1953-01-03 | 1955-01-03 | Democrat | 8 | |||||||||||||
25689 | 25689 | Louis Graham G000360 | rep | PA | 1953-01-03 | 1955-01-03 | Republican | 25 | |||||||||||||
25981 | 25981 | William Granahan G000369 | rep | PA | 1953-01-03 | 1955-01-03 | Democrat | 2 | |||||||||||||
27824 | 27824 | George Grant G000381 | rep | AL | 1953-01-03 | 1955-01-03 | Democrat | 2 | |||||||||||||
25985 | 25985 | Theodore Green G000418 | sen | RI | 1949-01-03 | 1955-01-03 | 2 | Democrat | |||||||||||||
27833 | 27833 | William Green G000421 | rep | PA | 1953-01-03 | 1955-01-03 | Democrat | 5 | |||||||||||||
26342 | 26342 | Noble Gregory G000447 | rep | KY | 1953-01-03 | 1955-01-03 | Democrat | 1 | |||||||||||||
25571 | 25571 | Dwight Griswold G000481 | sen | NE | 1952-01-01 | 1955-01-03 | 2 | Republican | |||||||||||||
30416 | 30416 | Harold Gross G000495 | rep | IA | 1953-01-03 | 1955-01-03 | Republican | 3 | |||||||||||||
30433 | 30433 | Charles Gubser G000512 | rep | CA | 1953-01-03 | 1955-01-03 | Republican | 10 | |||||||||||||
26349 | 26349 | Ralph Gwinn G000541 | rep | NY | 1953-01-03 | 1955-01-03 | Republican | 27 | |||||||||||||
28439 | 28439 | Harlan Hagen H000013 | rep | CA | 1953-01-03 | 1955-01-03 | Democrat | 14 | |||||||||||||
25695 | 25695 | Harold Hagen H000014 | rep | MN | 1953-01-03 | 1955-01-03 | Republican | 9 | |||||||||||||
26357 | 26357 | Robert Hale H000036 | rep | ME | 1953-01-03 | 1955-01-03 | Republican | 1 | |||||||||||||
30957 | 30957 | James Haley H000041 | rep | FL | 1953-01-03 | 1955-01-03 | Democrat | 7 | |||||||||||||
28869 | 28869 | Charles Halleck H000081 | rep | IN | 1953-01-03 | 1955-01-03 | Republican | 2 | |||||||||||||
25991 | 25991 | Thomas Hand H000154 | rep | NJ | 1953-01-03 | 1955-01-03 | Republican | 2 | |||||||||||||
26362 | 26362 | Cecil Harden H000182 | rep | IN | 1953-01-03 | 1955-01-03 | Republican | 6 | |||||||||||||
28880 | 28880 | Porter Hardy H000197 | rep | VA | 1953-01-03 | 1955-01-03 | Democrat | 2 | |||||||||||||
28453 | 28453 | Oren Harris H000249 | rep | AR | 1953-01-03 | 1955-01-03 | Democrat | 4 | |||||||||||||
27220 | 27220 | Burr Harrison H000264 | rep | VA | 1953-01-03 | 1955-01-03 | Democrat | 7 | |||||||||||||
26366 | 26366 | Robert Harrison H000275 | rep | NE | 1953-01-03 | 1955-01-03 | Republican | 3 | |||||||||||||
28891 | 28891 | William Harrison H000278 | rep | WY | 1953-01-03 | 1955-01-03 | Republican | 0 | |||||||||||||
25705 | 25705 | Edward Hart H000284 | rep | NJ | 1953-01-03 | 1955-01-03 | Democrat | 14 |
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);