legislator_terms
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
483 rows where "start" is on date 1937-01-05 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
22543 | 22543 | Edward Curley C000995 | rep | NY | 1937-01-05 | 1939-01-03 | Democrat | 22 | |||||||||||||
22546 | 22546 | John Daly D000014 | rep | PA | 1937-01-05 | 1939-01-03 | Democrat | 4 | |||||||||||||
22109 | 22109 | Braswell Deen D000187 | rep | GA | 1937-01-05 | 1939-01-03 | Democrat | 8 | |||||||||||||
24343 | 24343 | John Delaney D000212 | rep | NY | 1937-01-05 | 1939-01-03 | Democrat | 7 | |||||||||||||
22106 | 22106 | Peter De Muth D000225 | rep | PA | 1937-01-05 | 1939-01-03 | Democrat | 30 | |||||||||||||
26289 | 26289 | John Dempsey D000228 | rep | NM | 1937-01-05 | 1939-01-03 | Democrat | 1 | |||||||||||||
22569 | 22569 | René De Rouen D000265 | rep | LA | 1937-01-05 | 1939-01-03 | Democrat | 7 | |||||||||||||
23833 | 23833 | Samuel Dickstein D000335 | rep | NY | 1937-01-05 | 1939-01-03 | Democrat | 12 | |||||||||||||
26303 | 26303 | Martin Dies D000338 | rep | TX | 1937-01-05 | 1939-01-03 | Democrat | 2 | |||||||||||||
23414 | 23414 | Anthony Dimond D000353 | rep | AK | 1937-01-05 | 1939-01-03 | Democrat | 0 | |||||||||||||
25913 | 25913 | John Dingell D000354 | rep | MI | 1937-01-05 | 1939-01-03 | Democrat | 15 | |||||||||||||
27744 | 27744 | Everett Dirksen D000360 | rep | IL | 1937-01-05 | 1939-01-03 | Republican | 16 | |||||||||||||
23421 | 23421 | Wesley Disney D000362 | rep | OK | 1937-01-05 | 1939-01-03 | Democrat | 1 | |||||||||||||
23427 | 23427 | John Ditter D000363 | rep | PA | 1937-01-05 | 1939-01-03 | Republican | 17 | |||||||||||||
22110 | 22110 | Joseph Dixon D000371 | rep | OH | 1937-01-05 | 1939-01-03 | Democrat | 1 | |||||||||||||
22113 | 22113 | John Dockweiler D000387 | rep | CA | 1937-01-05 | 1939-01-03 | Democrat | 16 | |||||||||||||
25931 | 25931 | George Dondero D000411 | rep | MI | 1937-01-05 | 1939-01-03 | Republican | 17 | |||||||||||||
22115 | 22115 | Frank Dorsey D000438 | rep | PA | 1937-01-05 | 1939-01-03 | Democrat | 5 | |||||||||||||
25226 | 25226 | Robert Doughton D000448 | rep | NC | 1937-01-05 | 1939-01-03 | Democrat | 9 | |||||||||||||
23431 | 23431 | Fred Douglas D000453 | rep | NY | 1937-01-05 | 1939-01-03 | Republican | 33 | |||||||||||||
22581 | 22581 | Cassius Dowell D000468 | rep | IA | 1937-01-05 | 1939-01-03 | Republican | 6 | |||||||||||||
22967 | 22967 | Wall Doxey D000480 | rep | MS | 1937-01-05 | 1939-01-03 | Democrat | 2 | |||||||||||||
22116 | 22116 | Ira Drew D000494 | rep | PA | 1937-01-05 | 1939-01-03 | Democrat | 7 | |||||||||||||
24363 | 24363 | Patrick Drewry D000496 | rep | VA | 1937-01-05 | 1939-01-03 | Democrat | 4 | |||||||||||||
22125 | 22125 | William Driver D000503 | rep | AR | 1937-01-05 | 1939-01-03 | Democrat | 1 | |||||||||||||
22972 | 22972 | Richard Duncan D000536 | rep | MO | 1937-01-05 | 1939-01-03 | Democrat | 3 | |||||||||||||
22585 | 22585 | Matthew Dunn D000551 | rep | PA | 1937-01-05 | 1939-01-03 | Democrat | 34 | |||||||||||||
25241 | 25241 | Charles Eaton E000023 | rep | NJ | 1937-01-05 | 1939-01-03 | Republican | 5 | |||||||||||||
26310 | 26310 | Herman Eberharter E000029 | rep | PA | 1937-01-05 | 1939-01-03 | Democrat | 32 | |||||||||||||
22127 | 22127 | Charles Eckert E000032 | rep | PA | 1937-01-05 | 1939-01-03 | Democrat | 26 | |||||||||||||
22979 | 22979 | Andrew Edmiston E000051 | rep | WV | 1937-01-05 | 1939-01-03 | Democrat | 3 | |||||||||||||
22130 | 22130 | Edward Eicher E000094 | rep | IA | 1937-01-05 | 1939-01-03 | Democrat | 1 | |||||||||||||
23435 | 23435 | Joaquin Elizalde E000108 | rep | PI | 1937-01-05 | 1939-01-03 | 0 | ||||||||||||||
22133 | 22133 | Henry Ellenbogen E000111 | rep | PA | 1937-01-05 | 1939-01-03 | Democrat | 33 | |||||||||||||
28816 | 28816 | Allen Ellender E000112 | sen | LA | 1937-01-05 | 1943-01-03 | 2 | Democrat | |||||||||||||
24370 | 24370 | Alfred Elliott E000119 | rep | CA | 1937-01-05 | 1939-01-03 | Democrat | 10 | |||||||||||||
24823 | 24823 | Albert Engel E000178 | rep | MI | 1937-01-05 | 1939-01-03 | Republican | 9 | |||||||||||||
23447 | 23447 | Harry Englebright E000182 | rep | CA | 1937-01-05 | 1939-01-03 | Republican | 2 | |||||||||||||
22589 | 22589 | Marcellus Evans E000253 | rep | NY | 1937-01-05 | 1939-01-03 | Democrat | 5 | |||||||||||||
22987 | 22987 | Charles Faddis F000001 | rep | PA | 1937-01-05 | 1939-01-03 | Democrat | 25 | |||||||||||||
22136 | 22136 | James Farley F000019 | rep | IN | 1937-01-05 | 1939-01-03 | Democrat | 4 | |||||||||||||
22592 | 22592 | Phillip Ferguson F000082 | rep | OK | 1937-01-05 | 1939-01-03 | Democrat | 8 | |||||||||||||
22597 | 22597 | Joachim Fernández F000086 | rep | LA | 1937-01-05 | 1939-01-03 | Democrat | 1 | |||||||||||||
23462 | 23462 | Hamilton Fish F000142 | rep | NY | 1937-01-05 | 1939-01-03 | Republican | 26 | |||||||||||||
22990 | 22990 | William Fitzgerald F000169 | rep | CT | 1937-01-05 | 1939-01-03 | Democrat | 2 | |||||||||||||
23471 | 23471 | James Fitzpatrick F000175 | rep | NY | 1937-01-05 | 1939-01-03 | Democrat | 24 | |||||||||||||
22992 | 22992 | Thomas Flaherty F000183 | rep | MA | 1937-01-05 | 1939-01-03 | Democrat | 11 | |||||||||||||
24384 | 24384 | John Flannagan F000191 | rep | VA | 1937-01-05 | 1939-01-03 | Democrat | 9 | |||||||||||||
22995 | 22995 | John Flannery F000192 | rep | PA | 1937-01-05 | 1939-01-03 | Democrat | 12 | |||||||||||||
22137 | 22137 | Anthony Fleger F000195 | rep | OH | 1937-01-05 | 1939-01-03 | Democrat | 22 | |||||||||||||
22142 | 22142 | Thomas Fletcher F000205 | rep | OH | 1937-01-05 | 1939-01-03 | Democrat | 8 | |||||||||||||
22152 | 22152 | Benjamin Focht F000230 | rep | PA | 1937-01-05 | 1939-01-03 | Republican | 18 | |||||||||||||
26849 | 26849 | Aime Forand F000255 | rep | RI | 1937-01-05 | 1939-01-03 | Democrat | 1 | |||||||||||||
23001 | 23001 | Aaron Ford F000258 | rep | MS | 1937-01-05 | 1939-01-03 | Democrat | 4 | |||||||||||||
23477 | 23477 | Thomas Ford F000267 | rep | CA | 1937-01-05 | 1939-01-03 | Democrat | 14 | |||||||||||||
22155 | 22155 | Oliver Frey F000382 | rep | PA | 1937-01-05 | 1939-01-03 | Democrat | 9 | |||||||||||||
22599 | 22599 | Frank Fries F000385 | rep | IL | 1937-01-05 | 1939-01-03 | Democrat | 21 | |||||||||||||
22160 | 22160 | Claude Fuller F000408 | rep | AR | 1937-01-05 | 1939-01-03 | Democrat | 3 | |||||||||||||
23489 | 23489 | Hampton Fulmer F000417 | rep | SC | 1937-01-05 | 1939-01-03 | Democrat | 2 | |||||||||||||
25966 | 25966 | Ralph Gamble G000031 | rep | NY | 1937-01-05 | 1939-01-03 | Republican | 25 | |||||||||||||
22168 | 22168 | Stephen Gambrill G000035 | rep | MD | 1937-01-05 | 1939-01-03 | Democrat | 5 | |||||||||||||
22601 | 22601 | Clyde Garrett G000080 | rep | TX | 1937-01-05 | 1939-01-03 | Democrat | 17 | |||||||||||||
22176 | 22176 | Allard Gasque G000092 | rep | SC | 1937-01-05 | 1939-01-03 | Democrat | 6 | |||||||||||||
22177 | 22177 | Elizabeth Gasque G000093 | rep | SC | 1937-01-05 | 1939-01-03 | Democrat | 6 | |||||||||||||
23501 | 23501 | Joseph Gavagan G000101 | rep | NY | 1937-01-05 | 1939-01-03 | Democrat | 21 | |||||||||||||
24402 | 24402 | Bertrand Gearhart G000111 | rep | CA | 1937-01-05 | 1939-01-03 | Republican | 9 | |||||||||||||
23007 | 23007 | Bernard Gehrmann G000118 | rep | WI | 1937-01-05 | 1939-01-03 | Progressive | 10 | |||||||||||||
24421 | 24421 | Charles Gifford G000169 | rep | MA | 1937-01-05 | 1939-01-03 | Republican | 15 | |||||||||||||
23508 | 23508 | Fred Gilchrist G000181 | rep | IA | 1937-01-05 | 1939-01-03 | Republican | 8 | |||||||||||||
22179 | 22179 | James Gildea G000182 | rep | PA | 1937-01-05 | 1939-01-03 | Democrat | 13 | |||||||||||||
22181 | 22181 | Don Gingery G000224 | rep | PA | 1937-01-05 | 1939-01-03 | Democrat | 23 | |||||||||||||
23524 | 23524 | Carter Glass G000232 | sen | VA | 1937-01-05 | 1943-01-03 | 2 | Democrat | |||||||||||||
22621 | 22621 | Thomas Goldsborough G000265 | rep | MD | 1937-01-05 | 1939-01-03 | Democrat | 1 | |||||||||||||
22184 | 22184 | Philip Goodwin G000302 | rep | NY | 1937-01-05 | 1939-01-03 | Republican | 27 | |||||||||||||
27816 | 27816 | George Grant G000381 | rep | AL | 1937-01-05 | 1939-01-03 | Democrat | 2 | |||||||||||||
22191 | 22191 | Finly Gray G000395 | rep | IN | 1937-01-05 | 1939-01-03 | Democrat | 10 | |||||||||||||
22193 | 22193 | Joseph Gray G000399 | rep | PA | 1937-01-05 | 1939-01-03 | Democrat | 27 | |||||||||||||
23532 | 23532 | Robert Green G000415 | rep | FL | 1937-01-05 | 1939-01-03 | Democrat | 2 | |||||||||||||
25983 | 25983 | Theodore Green G000418 | sen | RI | 1937-01-05 | 1943-01-03 | 2 | Democrat | |||||||||||||
22201 | 22201 | Arthur Greenwood G000437 | rep | IN | 1937-01-05 | 1939-01-03 | Democrat | 7 | |||||||||||||
22203 | 22203 | Paul Greever G000440 | rep | WY | 1937-01-05 | 1939-01-03 | Democrat | 0 | |||||||||||||
26334 | 26334 | Noble Gregory G000447 | rep | KY | 1937-01-05 | 1939-01-03 | Democrat | 1 | |||||||||||||
22624 | 22624 | John Griffith G000469 | rep | LA | 1937-01-05 | 1939-01-03 | Democrat | 6 | |||||||||||||
22207 | 22207 | Glenn Griswold G000483 | rep | IN | 1937-01-05 | 1939-01-03 | Democrat | 5 | |||||||||||||
23542 | 23542 | Ulysses Guyer G000538 | rep | KS | 1937-01-05 | 1939-01-03 | Republican | 2 | |||||||||||||
24446 | 24446 | John Gwynne G000543 | rep | IA | 1937-01-05 | 1939-01-03 | Republican | 3 | |||||||||||||
23022 | 23022 | Harry Haines H000026 | rep | PA | 1937-01-05 | 1939-01-03 | Democrat | 22 | |||||||||||||
28861 | 28861 | Charles Halleck H000081 | rep | IN | 1937-01-05 | 1939-01-03 | Republican | 2 | |||||||||||||
22208 | 22208 | Norman Hamilton H000116 | rep | VA | 1937-01-05 | 1939-01-03 | Democrat | 2 | |||||||||||||
23860 | 23860 | Clarence Hancock H000146 | rep | NY | 1937-01-05 | 1939-01-03 | Republican | 35 | |||||||||||||
22213 | 22213 | Franklin Hancock H000147 | rep | NC | 1937-01-05 | 1939-01-03 | Democrat | 5 | |||||||||||||
22217 | 22217 | Byron Harlan H000209 | rep | OH | 1937-01-05 | 1939-01-03 | Democrat | 3 | |||||||||||||
23024 | 23024 | Vincent Harrington H000231 | rep | IA | 1937-01-05 | 1939-01-03 | Democrat | 9 | |||||||||||||
22225 | 22225 | Byron Harrison H000265 | sen | MS | 1937-01-05 | 1941-12-31 | 2 | Democrat | |||||||||||||
25697 | 25697 | Edward Hart H000284 | rep | NJ | 1937-01-05 | 1939-01-03 | Democrat | 14 | |||||||||||||
23029 | 23029 | Dow Harter H000294 | rep | OH | 1937-01-05 | 1939-01-03 | Democrat | 14 | |||||||||||||
24464 | 24464 | Fred Hartley H000298 | rep | NJ | 1937-01-05 | 1939-01-03 | Republican | 10 | |||||||||||||
23549 | 23549 | Carl Hatch H000334 | sen | NM | 1937-01-05 | 1943-01-03 | 2 | Democrat | |||||||||||||
25306 | 25306 | Franck Havenner H000356 | rep | CA | 1937-01-05 | 1939-01-03 | Progressive | 4 | |||||||||||||
23034 | 23034 | Arthur Healey H000423 | rep | MA | 1937-01-05 | 1939-01-03 | Democrat | 8 |
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);