legislator_terms
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
480 rows where "start" is on date 1957-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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
26811 | 26811 | Frank Coffin C000589 | rep | ME | 1957-01-03 | 1959-01-03 | Democrat | 2 | |||||||||||||
26249 | 26249 | William Cole C000617 | rep | NY | 1957-01-03 | 1959-01-03 | Republican | 37 | |||||||||||||
30252 | 30252 | Harold Collier C000629 | rep | IL | 1957-01-03 | 1959-01-03 | Republican | 10 | |||||||||||||
29708 | 29708 | William Colmer C000645 | rep | MS | 1957-01-03 | 1959-01-03 | Democrat | 6 | |||||||||||||
28385 | 28385 | Harold Cooley C000736 | rep | NC | 1957-01-03 | 1959-01-03 | Democrat | 4 | |||||||||||||
26264 | 26264 | Jere Cooper C000755 | rep | TN | 1957-01-03 | 1959-01-03 | Democrat | 8 | |||||||||||||
29724 | 29724 | Robert Corbett C000772 | rep | PA | 1957-01-03 | 1959-01-03 | Republican | 29 | |||||||||||||
30882 | 30882 | Norris Cotton C000802 | sen | NH | 1957-01-03 | 1963-01-03 | 3 | Republican | |||||||||||||
26270 | 26270 | Frederic Coudert C000804 | rep | NY | 1957-01-03 | 1959-01-03 | Republican | 17 | |||||||||||||
29184 | 29184 | William Cramer C000869 | rep | FL | 1957-01-03 | 1959-01-03 | Republican | 1 | |||||||||||||
26273 | 26273 | Albert Cretella C000905 | rep | CT | 1957-01-03 | 1959-01-03 | Republican | 3 | |||||||||||||
29191 | 29191 | Glenn Cunningham C000991 | rep | NE | 1957-01-03 | 1959-01-03 | Republican | 2 | |||||||||||||
26282 | 26282 | Paul Cunningham C000993 | rep | IA | 1957-01-03 | 1959-01-03 | Republican | 5 | |||||||||||||
28391 | 28391 | Willard Curtin C001005 | rep | PA | 1957-01-03 | 1959-01-03 | Republican | 8 | |||||||||||||
27167 | 27167 | Laurence Curtis C001011 | rep | MA | 1957-01-03 | 1959-01-03 | Republican | 10 | |||||||||||||
28810 | 28810 | Thomas Curtis C001014 | rep | MO | 1957-01-03 | 1959-01-03 | Republican | 2 | |||||||||||||
28401 | 28401 | Paul Dague D000004 | rep | PA | 1957-01-03 | 1959-01-03 | Republican | 9 | |||||||||||||
27732 | 27732 | Clifford Davis D000094 | rep | TN | 1957-01-03 | 1959-01-03 | Democrat | 9 | |||||||||||||
27175 | 27175 | James Davis D000109 | rep | GA | 1957-01-03 | 1959-01-03 | Democrat | 5 | |||||||||||||
26286 | 26286 | William Dawson D000155 | rep | UT | 1957-01-03 | 1959-01-03 | Republican | 2 | |||||||||||||
29211 | 29211 | William Dawson D000158 | rep | IL | 1957-01-03 | 1959-01-03 | Democrat | 1 | |||||||||||||
31516 | 31516 | James Delaney D000211 | rep | NY | 1957-01-03 | 1959-01-03 | Democrat | 7 | |||||||||||||
26287 | 26287 | Vincent Dellay D000219 | rep | NJ | 1957-01-03 | 1959-01-03 | Democrat | 14 | |||||||||||||
26294 | 26294 | John Dempsey D000228 | rep | NM | 1957-01-03 | 1959-01-03 | Democrat | 0 | |||||||||||||
26295 | 26295 | David Dennison D000246 | rep | OH | 1957-01-03 | 1959-01-03 | Republican | 11 | |||||||||||||
31527 | 31527 | John Dent D000255 | rep | PA | 1957-01-03 | 1959-01-03 | Democrat | 21 | |||||||||||||
28409 | 28409 | Winfield Denton D000260 | rep | IN | 1957-01-03 | 1959-01-03 | Democrat | 8 | |||||||||||||
27738 | 27738 | Steven Derounian D000266 | rep | NY | 1957-01-03 | 1959-01-03 | Republican | 2 | |||||||||||||
26299 | 26299 | James Devereux D000278 | rep | MD | 1957-01-03 | 1959-01-03 | Republican | 2 | |||||||||||||
26309 | 26309 | Martin Dies D000338 | rep | TX | 1957-01-03 | 1959-01-03 | Democrat | 0 | |||||||||||||
32027 | 32027 | Charles Diggs D000344 | rep | MI | 1957-01-03 | 1959-01-03 | Democrat | 13 | |||||||||||||
39800 | 39800 | John Dingell D000355 | rep | MI | 1957-01-03 | 1959-01-03 | Democrat | 15 | |||||||||||||
27751 | 27751 | Everett Dirksen D000360 | sen | IL | 1957-01-03 | 1963-01-03 | 3 | Republican | |||||||||||||
26814 | 26814 | Henry Dixon D000368 | rep | UT | 1957-01-03 | 1959-01-03 | Republican | 1 | |||||||||||||
26820 | 26820 | Isidore Dollinger D000402 | rep | NY | 1957-01-03 | 1959-01-03 | Democrat | 23 | |||||||||||||
30307 | 30307 | Harold Donohue D000419 | rep | MA | 1957-01-03 | 1959-01-03 | Democrat | 4 | |||||||||||||
27178 | 27178 | Edwin Dooley D000425 | rep | NY | 1957-01-03 | 1959-01-03 | Republican | 26 | |||||||||||||
26824 | 26824 | Francis Dorn D000433 | rep | NY | 1957-01-03 | 1959-01-03 | Republican | 12 | |||||||||||||
30320 | 30320 | William Dorn D000434 | rep | SC | 1957-01-03 | 1959-01-03 | Democrat | 3 | |||||||||||||
29741 | 29741 | John Dowdy D000467 | rep | TX | 1957-01-03 | 1959-01-03 | Democrat | 7 | |||||||||||||
27758 | 27758 | Clyde Doyle D000481 | rep | CA | 1957-01-03 | 1959-01-03 | Democrat | 23 | |||||||||||||
26835 | 26835 | Carl Durham D000571 | rep | NC | 1957-01-03 | 1959-01-03 | Democrat | 6 | |||||||||||||
29749 | 29749 | Florence Dwyer D000587 | rep | NJ | 1957-01-03 | 1959-01-03 | Republican | 6 | |||||||||||||
26320 | 26320 | Herman Eberharter E000029 | rep | PA | 1957-01-03 | 1959-01-03 | Democrat | 28 | |||||||||||||
29759 | 29759 | Edmond Edmondson E000054 | rep | OK | 1957-01-03 | 1959-01-03 | Democrat | 2 | |||||||||||||
27767 | 27767 | Carl Elliott E000120 | rep | AL | 1957-01-03 | 1959-01-03 | Democrat | 7 | |||||||||||||
26845 | 26845 | Clair Engle E000181 | rep | CA | 1957-01-03 | 1959-01-03 | Democrat | 2 | |||||||||||||
29225 | 29225 | Samuel Ervin E000211 | sen | NC | 1957-01-03 | 1963-01-03 | 3 | Democrat | |||||||||||||
29228 | 29228 | Robert Everett E000266 | rep | TN | 1957-01-03 | 1959-01-03 | Democrat | 8 | |||||||||||||
30926 | 30926 | Joseph Evins E000273 | rep | TN | 1957-01-03 | 1959-01-03 | Democrat | 4 | |||||||||||||
29241 | 29241 | George Fallon F000012 | rep | MD | 1957-01-03 | 1959-01-03 | Democrat | 4 | |||||||||||||
29248 | 29248 | Leonard Farbstein F000015 | rep | NY | 1957-01-03 | 1959-01-03 | Democrat | 19 | |||||||||||||
34443 | 34443 | Dante Fascell F000041 | rep | FL | 1957-01-03 | 1959-01-03 | Democrat | 4 | |||||||||||||
29262 | 29262 | Michael Feighan F000060 | rep | OH | 1957-01-03 | 1959-01-03 | Democrat | 20 | |||||||||||||
27201 | 27201 | Ivor Fenton F000075 | rep | PA | 1957-01-03 | 1959-01-03 | Republican | 12 | |||||||||||||
27777 | 27777 | Antonio Fernós-Isern F000087 | rep | PR | 1957-01-03 | 1959-01-03 | Popular Democrat | 0 | |||||||||||||
28824 | 28824 | Paul Fino F000137 | rep | NY | 1957-01-03 | 1959-01-03 | Republican | 25 | |||||||||||||
30351 | 30351 | Ovie Fisher F000152 | rep | TX | 1957-01-03 | 1959-01-03 | Democrat | 21 | |||||||||||||
32064 | 32064 | Daniel Flood F000209 | rep | PA | 1957-01-03 | 1959-01-03 | Democrat | 11 | |||||||||||||
31558 | 31558 | John Flynt F000229 | rep | GA | 1957-01-03 | 1959-01-03 | Democrat | 4 | |||||||||||||
28838 | 28838 | John Fogarty F000233 | rep | RI | 1957-01-03 | 1959-01-03 | Democrat | 2 | |||||||||||||
26858 | 26858 | Aime Forand F000255 | rep | RI | 1957-01-03 | 1959-01-03 | Democrat | 1 | |||||||||||||
30791 | 30791 | Gerald Ford F000260 | rep | MI | 1957-01-03 | 1959-01-03 | Republican | 5 | |||||||||||||
27786 | 27786 | Elijah Forrester F000283 | rep | GA | 1957-01-03 | 1959-01-03 | Democrat | 3 | |||||||||||||
32660 | 32660 | Lawrence Fountain F000319 | rep | NC | 1957-01-03 | 1959-01-03 | Democrat | 2 | |||||||||||||
27208 | 27208 | James Frazier F000353 | rep | TN | 1957-01-03 | 1959-01-03 | Democrat | 3 | |||||||||||||
30362 | 30362 | Peter Frelinghuysen F000371 | rep | NJ | 1957-01-03 | 1959-01-03 | Republican | 5 | |||||||||||||
29273 | 29273 | Samuel Friedel F000384 | rep | MD | 1957-01-03 | 1959-01-03 | Democrat | 7 | |||||||||||||
29283 | 29283 | James Fulbright F000401 | sen | AR | 1957-01-03 | 1963-01-03 | 3 | Democrat | |||||||||||||
29782 | 29782 | James Fulton F000422 | rep | PA | 1957-01-03 | 1959-01-03 | Republican | 27 | |||||||||||||
29806 | 29806 | Edward Garmatz G000071 | rep | MD | 1957-01-03 | 1959-01-03 | Democrat | 3 | |||||||||||||
27796 | 27796 | Julian Gary G000091 | rep | VA | 1957-01-03 | 1959-01-03 | Democrat | 3 | |||||||||||||
28854 | 28854 | Ezekiel Gathings G000098 | rep | AR | 1957-01-03 | 1959-01-03 | Democrat | 1 | |||||||||||||
27807 | 27807 | Leon Gavin G000102 | rep | PA | 1957-01-03 | 1959-01-03 | Republican | 23 | |||||||||||||
26325 | 26325 | Myron George G000129 | rep | KS | 1957-01-03 | 1959-01-03 | Republican | 3 | |||||||||||||
27812 | 27812 | Milton Glenn G000237 | rep | NJ | 1957-01-03 | 1959-01-03 | Republican | 2 | |||||||||||||
26333 | 26333 | Thomas Gordon G000316 | rep | IL | 1957-01-03 | 1959-01-03 | Democrat | 8 | |||||||||||||
27213 | 27213 | Kathryn Granahan G000368 | rep | PA | 1957-01-03 | 1959-01-03 | Democrat | 2 | |||||||||||||
27826 | 27826 | George Grant G000381 | rep | AL | 1957-01-03 | 1959-01-03 | Democrat | 2 | |||||||||||||
33589 | 33589 | Kenneth Gray G000400 | rep | IL | 1957-01-03 | 1959-01-03 | Democrat | 25 | |||||||||||||
30387 | 30387 | Edith Green G000407 | rep | OR | 1957-01-03 | 1959-01-03 | Democrat | 3 | |||||||||||||
27835 | 27835 | William Green G000421 | rep | PA | 1957-01-03 | 1959-01-03 | Democrat | 5 | |||||||||||||
26344 | 26344 | Noble Gregory G000447 | rep | KY | 1957-01-03 | 1959-01-03 | Democrat | 1 | |||||||||||||
30396 | 30396 | Robert Griffin G000465 | rep | MI | 1957-01-03 | 1959-01-03 | Republican | 9 | |||||||||||||
30405 | 30405 | Martha Griffiths G000471 | rep | MI | 1957-01-03 | 1959-01-03 | Democrat | 17 | |||||||||||||
30418 | 30418 | Harold Gross G000495 | rep | IA | 1957-01-03 | 1959-01-03 | Republican | 3 | |||||||||||||
30435 | 30435 | Charles Gubser G000512 | rep | CA | 1957-01-03 | 1959-01-03 | Republican | 10 | |||||||||||||
26351 | 26351 | Ralph Gwinn G000541 | rep | NY | 1957-01-03 | 1959-01-03 | Republican | 27 | |||||||||||||
28441 | 28441 | Harlan Hagen H000013 | rep | CA | 1957-01-03 | 1959-01-03 | Democrat | 14 | |||||||||||||
26359 | 26359 | Robert Hale H000036 | rep | ME | 1957-01-03 | 1959-01-03 | Republican | 1 | |||||||||||||
30959 | 30959 | James Haley H000041 | rep | FL | 1957-01-03 | 1959-01-03 | Democrat | 7 | |||||||||||||
28871 | 28871 | Charles Halleck H000081 | rep | IN | 1957-01-03 | 1959-01-03 | Republican | 2 | |||||||||||||
26364 | 26364 | Cecil Harden H000182 | rep | IN | 1957-01-03 | 1959-01-03 | Republican | 6 | |||||||||||||
28882 | 28882 | Porter Hardy H000197 | rep | VA | 1957-01-03 | 1959-01-03 | Democrat | 2 | |||||||||||||
28455 | 28455 | Oren Harris H000249 | rep | AR | 1957-01-03 | 1959-01-03 | Democrat | 4 | |||||||||||||
27222 | 27222 | Burr Harrison H000264 | rep | VA | 1957-01-03 | 1959-01-03 | Democrat | 7 | |||||||||||||
26368 | 26368 | Robert Harrison H000275 | rep | NE | 1957-01-03 | 1959-01-03 | Republican | 3 | |||||||||||||
28465 | 28465 | Ralph Harvey H000310 | rep | IN | 1957-01-03 | 1959-01-03 | Republican | 10 | |||||||||||||
26369 | 26369 | Harry Haskell H000318 | rep | DE | 1957-01-03 | 1959-01-03 | Republican | 0 | |||||||||||||
27856 | 27856 | Carl Hayden H000385 | sen | AZ | 1957-01-03 | 1963-01-03 | 3 | Democrat |
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);