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 1935-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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
23402 | 23402 | Thomas Cullen C000970 | rep | NY | 1935-01-03 | 1937-01-03 | Democrat | 4 | |||||||||||||
22539 | 22539 | Fred Cummings C000985 | rep | CO | 1935-01-03 | 1937-01-03 | Democrat | 2 | |||||||||||||
22542 | 22542 | Edward Curley C000995 | rep | NY | 1935-01-03 | 1937-01-03 | Democrat | 22 | |||||||||||||
19648 | 19648 | Bronson Cutting C001028 | sen | NM | 1935-01-03 | 1935-05-06 | 1 | Republican | |||||||||||||
22545 | 22545 | John Daly D000014 | rep | PA | 1935-01-03 | 1937-01-03 | Democrat | 4 | |||||||||||||
22958 | 22958 | Colgate Darden D000050 | rep | VA | 1935-01-03 | 1937-01-03 | Democrat | 2 | |||||||||||||
22559 | 22559 | George Darrow D000063 | rep | PA | 1935-01-03 | 1937-01-03 | Republican | 7 | |||||||||||||
21736 | 21736 | Cleveland Dear D000177 | rep | LA | 1935-01-03 | 1937-01-03 | Democrat | 8 | |||||||||||||
22108 | 22108 | Braswell Deen D000187 | rep | GA | 1935-01-03 | 1937-01-03 | Democrat | 8 | |||||||||||||
24342 | 24342 | John Delaney D000212 | rep | NY | 1935-01-03 | 1937-01-03 | Democrat | 7 | |||||||||||||
21737 | 21737 | Francisco Delgado D000218 | rep | PI | 1935-01-03 | 1937-01-03 | 0 | ||||||||||||||
26288 | 26288 | John Dempsey D000228 | rep | NM | 1935-01-03 | 1937-01-03 | Democrat | 1 | |||||||||||||
22568 | 22568 | René De Rouen D000265 | rep | LA | 1935-01-03 | 1937-01-03 | Democrat | 7 | |||||||||||||
23832 | 23832 | Samuel Dickstein D000335 | rep | NY | 1935-01-03 | 1937-01-03 | Democrat | 12 | |||||||||||||
26302 | 26302 | Martin Dies D000338 | rep | TX | 1935-01-03 | 1937-01-03 | Democrat | 2 | |||||||||||||
21738 | 21738 | Charles Dietrich D000340 | rep | PA | 1935-01-03 | 1937-01-03 | Democrat | 15 | |||||||||||||
23413 | 23413 | Anthony Dimond D000353 | rep | AK | 1935-01-03 | 1937-01-03 | Democrat | 0 | |||||||||||||
25912 | 25912 | John Dingell D000354 | rep | MI | 1935-01-03 | 1937-01-03 | Democrat | 15 | |||||||||||||
27743 | 27743 | Everett Dirksen D000360 | rep | IL | 1935-01-03 | 1937-01-03 | Republican | 16 | |||||||||||||
23420 | 23420 | Wesley Disney D000362 | rep | OK | 1935-01-03 | 1937-01-03 | Democrat | 1 | |||||||||||||
23426 | 23426 | John Ditter D000363 | rep | PA | 1935-01-03 | 1937-01-03 | Republican | 17 | |||||||||||||
21740 | 21740 | Donald Dobbins D000382 | rep | IL | 1935-01-03 | 1937-01-03 | Democrat | 19 | |||||||||||||
22112 | 22112 | John Dockweiler D000387 | rep | CA | 1935-01-03 | 1937-01-03 | Democrat | 16 | |||||||||||||
21741 | 21741 | Alvin Donahey D000410 | sen | OH | 1935-01-03 | 1941-01-03 | 1 | Democrat | |||||||||||||
25930 | 25930 | George Dondero D000411 | rep | MI | 1935-01-03 | 1937-01-03 | Republican | 17 | |||||||||||||
22114 | 22114 | Frank Dorsey D000438 | rep | PA | 1935-01-03 | 1937-01-03 | Democrat | 5 | |||||||||||||
25225 | 25225 | Robert Doughton D000448 | rep | NC | 1935-01-03 | 1937-01-03 | Democrat | 9 | |||||||||||||
21746 | 21746 | Isaac Doutrich D000460 | rep | PA | 1935-01-03 | 1937-01-03 | Republican | 19 | |||||||||||||
22966 | 22966 | Wall Doxey D000480 | rep | MS | 1935-01-03 | 1937-01-03 | Democrat | 2 | |||||||||||||
24362 | 24362 | Patrick Drewry D000496 | rep | VA | 1935-01-03 | 1937-01-03 | Democrat | 4 | |||||||||||||
21747 | 21747 | Denis Driscoll D000501 | rep | PA | 1935-01-03 | 1937-01-03 | Democrat | 20 | |||||||||||||
22124 | 22124 | William Driver D000503 | rep | AR | 1935-01-03 | 1937-01-03 | Democrat | 1 | |||||||||||||
21749 | 21749 | Warren Duffey D000517 | rep | OH | 1935-01-03 | 1937-01-03 | Democrat | 9 | |||||||||||||
21750 | 21750 | James Duffy D000519 | rep | NY | 1935-01-03 | 1937-01-03 | Democrat | 38 | |||||||||||||
22971 | 22971 | Richard Duncan D000536 | rep | MO | 1935-01-03 | 1937-01-03 | Democrat | 3 | |||||||||||||
21751 | 21751 | Aubert Dunn D000545 | rep | MS | 1935-01-03 | 1937-01-03 | Democrat | 5 | |||||||||||||
22584 | 22584 | Matthew Dunn D000551 | rep | PA | 1935-01-03 | 1937-01-03 | Democrat | 34 | |||||||||||||
21758 | 21758 | Joe Eagle E000003 | rep | TX | 1935-01-03 | 1937-01-03 | Democrat | 8 | |||||||||||||
25240 | 25240 | Charles Eaton E000023 | rep | NJ | 1935-01-03 | 1937-01-03 | Republican | 5 | |||||||||||||
22126 | 22126 | Charles Eckert E000032 | rep | PA | 1935-01-03 | 1937-01-03 | Democrat | 26 | |||||||||||||
22978 | 22978 | Andrew Edmiston E000051 | rep | WV | 1935-01-03 | 1937-01-03 | Democrat | 3 | |||||||||||||
22129 | 22129 | Edward Eicher E000094 | rep | IA | 1935-01-03 | 1937-01-03 | Democrat | 1 | |||||||||||||
21760 | 21760 | William Ekwall E000098 | rep | OR | 1935-01-03 | 1937-01-03 | Republican | 3 | |||||||||||||
22132 | 22132 | Henry Ellenbogen E000111 | rep | PA | 1935-01-03 | 1937-01-03 | Democrat | 33 | |||||||||||||
24822 | 24822 | Albert Engel E000178 | rep | MI | 1935-01-03 | 1937-01-03 | Republican | 9 | |||||||||||||
23446 | 23446 | Harry Englebright E000182 | rep | CA | 1935-01-03 | 1937-01-03 | Republican | 2 | |||||||||||||
22588 | 22588 | Marcellus Evans E000253 | rep | NY | 1935-01-03 | 1937-01-03 | Democrat | 5 | |||||||||||||
22986 | 22986 | Charles Faddis F000001 | rep | PA | 1935-01-03 | 1937-01-03 | Democrat | 25 | |||||||||||||
22135 | 22135 | James Farley F000019 | rep | IN | 1935-01-03 | 1937-01-03 | Democrat | 4 | |||||||||||||
21761 | 21761 | Clare Fenerty F000071 | rep | PA | 1935-01-03 | 1937-01-03 | Republican | 3 | |||||||||||||
22591 | 22591 | Phillip Ferguson F000082 | rep | OK | 1935-01-03 | 1937-01-03 | Democrat | 8 | |||||||||||||
22596 | 22596 | Joachim Fernández F000086 | rep | LA | 1935-01-03 | 1937-01-03 | Democrat | 1 | |||||||||||||
21764 | 21764 | William Fiesinger F000114 | rep | OH | 1935-01-03 | 1937-01-03 | Democrat | 13 | |||||||||||||
23461 | 23461 | Hamilton Fish F000142 | rep | NY | 1935-01-03 | 1937-01-03 | Republican | 26 | |||||||||||||
23470 | 23470 | James Fitzpatrick F000175 | rep | NY | 1935-01-03 | 1937-01-03 | Democrat | 24 | |||||||||||||
24383 | 24383 | John Flannagan F000191 | rep | VA | 1935-01-03 | 1937-01-03 | Democrat | 9 | |||||||||||||
22141 | 22141 | Thomas Fletcher F000205 | rep | OH | 1935-01-03 | 1937-01-03 | Democrat | 8 | |||||||||||||
22151 | 22151 | Benjamin Focht F000230 | rep | PA | 1935-01-03 | 1937-01-03 | Republican | 18 | |||||||||||||
23000 | 23000 | Aaron Ford F000258 | rep | MS | 1935-01-03 | 1937-01-03 | Democrat | 4 | |||||||||||||
23476 | 23476 | Thomas Ford F000267 | rep | CA | 1935-01-03 | 1937-01-03 | Democrat | 14 | |||||||||||||
21767 | 21767 | Lynn Frazier F000354 | sen | ND | 1935-01-03 | 1941-01-03 | 1 | Republican | |||||||||||||
22154 | 22154 | Oliver Frey F000382 | rep | PA | 1935-01-03 | 1937-01-03 | Democrat | 9 | |||||||||||||
22159 | 22159 | Claude Fuller F000408 | rep | AR | 1935-01-03 | 1937-01-03 | Democrat | 3 | |||||||||||||
23488 | 23488 | Hampton Fulmer F000417 | rep | SC | 1935-01-03 | 1937-01-03 | Democrat | 2 | |||||||||||||
22167 | 22167 | Stephen Gambrill G000035 | rep | MD | 1935-01-03 | 1937-01-03 | Democrat | 5 | |||||||||||||
22175 | 22175 | Allard Gasque G000092 | rep | SC | 1935-01-03 | 1937-01-03 | Democrat | 6 | |||||||||||||
21768 | 21768 | Percy Gassaway G000094 | rep | OK | 1935-01-03 | 1937-01-03 | Democrat | 4 | |||||||||||||
23500 | 23500 | Joseph Gavagan G000101 | rep | NY | 1935-01-03 | 1937-01-03 | Democrat | 21 | |||||||||||||
24401 | 24401 | Bertrand Gearhart G000111 | rep | CA | 1935-01-03 | 1937-01-03 | Republican | 9 | |||||||||||||
23006 | 23006 | Bernard Gehrmann G000118 | rep | WI | 1935-01-03 | 1937-01-03 | Progressive | 10 | |||||||||||||
23013 | 23013 | Peter Gerry G000141 | sen | RI | 1935-01-03 | 1941-01-03 | 1 | Democrat | |||||||||||||
24420 | 24420 | Charles Gifford G000169 | rep | MA | 1935-01-03 | 1937-01-03 | Republican | 15 | |||||||||||||
23507 | 23507 | Fred Gilchrist G000181 | rep | IA | 1935-01-03 | 1937-01-03 | Republican | 8 | |||||||||||||
22178 | 22178 | James Gildea G000182 | rep | PA | 1935-01-03 | 1937-01-03 | Democrat | 13 | |||||||||||||
22180 | 22180 | Don Gingery G000224 | rep | PA | 1935-01-03 | 1937-01-03 | Democrat | 23 | |||||||||||||
22620 | 22620 | Thomas Goldsborough G000265 | rep | MD | 1935-01-03 | 1937-01-03 | Democrat | 1 | |||||||||||||
22183 | 22183 | Philip Goodwin G000302 | rep | NY | 1935-01-03 | 1937-01-03 | Republican | 27 | |||||||||||||
21772 | 21772 | William Granfield G000372 | rep | MA | 1935-01-03 | 1937-01-03 | Democrat | 2 | |||||||||||||
22190 | 22190 | Finly Gray G000395 | rep | IN | 1935-01-03 | 1937-01-03 | Democrat | 10 | |||||||||||||
22192 | 22192 | Joseph Gray G000399 | rep | PA | 1935-01-03 | 1937-01-03 | Democrat | 27 | |||||||||||||
23531 | 23531 | Robert Green G000415 | rep | FL | 1935-01-03 | 1937-01-03 | Democrat | 2 | |||||||||||||
21774 | 21774 | Isabella Greenway G000435 | rep | AZ | 1935-01-03 | 1937-01-03 | Democrat | 0 | |||||||||||||
22200 | 22200 | Arthur Greenwood G000437 | rep | IN | 1935-01-03 | 1937-01-03 | Democrat | 7 | |||||||||||||
22202 | 22202 | Paul Greever G000440 | rep | WY | 1935-01-03 | 1937-01-03 | Democrat | 0 | |||||||||||||
21779 | 21779 | William Gregory G000448 | rep | KY | 1935-01-03 | 1937-01-03 | Democrat | 1 | |||||||||||||
21789 | 21789 | Anthony Griffin G000457 | rep | NY | 1935-01-03 | 1937-01-03 | Democrat | 22 | |||||||||||||
22206 | 22206 | Glenn Griswold G000483 | rep | IN | 1935-01-03 | 1937-01-03 | Democrat | 5 | |||||||||||||
21796 | 21796 | Pedro Guevara G000518 | rep | PI | 1935-01-03 | 1937-01-03 | 0 | ||||||||||||||
23017 | 23017 | Joseph Guffey G000519 | sen | PA | 1935-01-03 | 1941-01-03 | 1 | Democrat | |||||||||||||
23541 | 23541 | Ulysses Guyer G000538 | rep | KS | 1935-01-03 | 1937-01-03 | Republican | 2 | |||||||||||||
24445 | 24445 | John Gwynne G000543 | rep | IA | 1935-01-03 | 1937-01-03 | Republican | 3 | |||||||||||||
23021 | 23021 | Harry Haines H000026 | rep | PA | 1935-01-03 | 1937-01-03 | Democrat | 22 | |||||||||||||
21800 | 21800 | Frederick Hale H000031 | sen | ME | 1935-01-03 | 1941-01-03 | 1 | Republican | |||||||||||||
28860 | 28860 | Charles Halleck H000081 | rep | IN | 1935-01-03 | 1937-01-03 | Republican | 2 | |||||||||||||
21801 | 21801 | Simon Hamlin H000122 | rep | ME | 1935-01-03 | 1937-01-03 | Democrat | 1 | |||||||||||||
21802 | 21802 | Peter Hammond H000131 | rep | OH | 1935-01-03 | 1937-01-03 | Democrat | 11 | |||||||||||||
23859 | 23859 | Clarence Hancock H000146 | rep | NY | 1935-01-03 | 1937-01-03 | Republican | 35 | |||||||||||||
22212 | 22212 | Franklin Hancock H000147 | rep | NC | 1935-01-03 | 1937-01-03 | Democrat | 5 | |||||||||||||
22216 | 22216 | Byron Harlan H000209 | rep | OH | 1935-01-03 | 1937-01-03 | Democrat | 3 | |||||||||||||
25696 | 25696 | Edward Hart H000284 | rep | NJ | 1935-01-03 | 1937-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);