legislator_terms
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
299 rows where party = "Democrat" and "start" is on date 1939-01-03 sorted by legislator_id
This data as json, copyable, CSV (advanced)
Suggested facets: end
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
22470 | 22470 | Alva Adams A000028 | sen | CO | 1939-01-03 | 1941-12-31 | 3 | Democrat | |||||||||||||
25113 | 25113 | Asa Allen A000114 | rep | LA | 1939-01-03 | 1941-01-03 | Democrat | 8 | |||||||||||||
22473 | 22473 | Robert Allen A000145 | rep | PA | 1939-01-03 | 1941-01-03 | Democrat | 28 | |||||||||||||
22475 | 22475 | Charles Anderson A000184 | rep | MO | 1939-01-03 | 1941-01-03 | Democrat | 12 | |||||||||||||
22850 | 22850 | Laurence Arnold A000290 | rep | IL | 1939-01-03 | 1941-01-03 | Democrat | 23 | |||||||||||||
22485 | 22485 | William Ashbrook A000306 | rep | OH | 1939-01-03 | 1941-01-03 | Democrat | 17 | |||||||||||||
22499 | 22499 | William Bankhead B000113 | rep | AL | 1939-01-03 | 1941-01-03 | Democrat | 7 | |||||||||||||
26710 | 26710 | Graham Barden B000139 | rep | NC | 1939-01-03 | 1941-01-03 | Democrat | 3 | |||||||||||||
25876 | 25876 | Alben Barkley B000145 | sen | KY | 1939-01-03 | 1945-01-03 | 3 | Democrat | |||||||||||||
22859 | 22859 | James Barnes B000158 | rep | IL | 1939-01-03 | 1941-01-03 | Democrat | 20 | |||||||||||||
23772 | 23772 | William Barry B000191 | rep | NY | 1939-01-03 | 1941-01-03 | Democrat | 2 | |||||||||||||
25131 | 25131 | Joseph Bates B000237 | rep | KY | 1939-01-03 | 1941-01-03 | Democrat | 8 | |||||||||||||
22865 | 22865 | Harry Beam B000274 | rep | IL | 1939-01-03 | 1941-01-03 | Democrat | 4 | |||||||||||||
28317 | 28317 | Lindley Beckworth B000296 | rep | TX | 1939-01-03 | 1941-01-03 | Democrat | 3 | |||||||||||||
24267 | 24267 | Charles Bell B000332 | rep | MO | 1939-01-03 | 1941-01-03 | Democrat | 4 | |||||||||||||
24753 | 24753 | Schuyler Bland B000545 | rep | VA | 1939-01-03 | 1941-01-03 | Democrat | 1 | |||||||||||||
24767 | 24767 | Sol Bloom B000565 | rep | NY | 1939-01-03 | 1941-01-03 | Democrat | 19 | |||||||||||||
22878 | 22878 | John Boehne B000588 | rep | IN | 1939-01-03 | 1941-01-03 | Democrat | 8 | |||||||||||||
22884 | 22884 | Patrick Boland B000601 | rep | PA | 1939-01-03 | 1941-01-03 | Democrat | 11 | |||||||||||||
22508 | 22508 | Homer Bone B000614 | sen | WA | 1939-01-03 | 1944-11-13 | 3 | Democrat | |||||||||||||
28329 | 28329 | Herbert Bonner B000621 | rep | NC | 1939-01-03 | 1941-01-03 | Democrat | 1 | |||||||||||||
23778 | 23778 | Lyle Boren B000640 | rep | OK | 1939-01-03 | 1941-01-03 | Democrat | 4 | |||||||||||||
27112 | 27112 | Frank Boykin B000725 | rep | AL | 1939-01-03 | 1941-01-03 | Democrat | 1 | |||||||||||||
23783 | 23783 | Michael Bradley B000743 | rep | PA | 1939-01-03 | 1941-01-03 | Democrat | 3 | |||||||||||||
27128 | 27128 | Overton Brooks B000884 | rep | LA | 1939-01-03 | 1941-01-03 | Democrat | 4 | |||||||||||||
26751 | 26751 | Paul Brown B000940 | rep | GA | 1939-01-03 | 1941-01-03 | Democrat | 10 | |||||||||||||
25608 | 25608 | Joseph Bryson B000999 | rep | SC | 1939-01-03 | 1941-01-03 | Democrat | 4 | |||||||||||||
22892 | 22892 | Frank Buck B001017 | rep | CA | 1939-01-03 | 1941-01-03 | Democrat | 3 | |||||||||||||
27665 | 27665 | Charles Buckley B001024 | rep | NY | 1939-01-03 | 1941-01-03 | Democrat | 23 | |||||||||||||
24783 | 24783 | Alfred Bulwinkle B001056 | rep | NC | 1939-01-03 | 1941-01-03 | Democrat | 10 | |||||||||||||
24237 | 24237 | Thomas Burch B001069 | rep | VA | 1939-01-03 | 1941-01-03 | Democrat | 5 | |||||||||||||
23793 | 23793 | William Burgin B001084 | rep | NC | 1939-01-03 | 1941-01-03 | Democrat | 8 | |||||||||||||
22509 | 22509 | William Burney B001122 | rep | CO | 1939-01-03 | 1941-01-03 | Democrat | 3 | |||||||||||||
22900 | 22900 | William Byron B001206 | rep | MD | 1939-01-03 | 1941-01-03 | Democrat | 6 | |||||||||||||
25172 | 25172 | William Byrne B001214 | rep | NY | 1939-01-03 | 1941-01-03 | Democrat | 28 | |||||||||||||
22510 | 22510 | Joseph Byrns B001218 | rep | TN | 1939-01-03 | 1941-01-03 | Democrat | 5 | |||||||||||||
22514 | 22514 | Millard Caldwell C000038 | rep | FL | 1939-01-03 | 1941-01-03 | Democrat | 3 | |||||||||||||
25624 | 25624 | Albert Camp C000070 | rep | GA | 1939-01-03 | 1941-01-03 | Democrat | 4 | |||||||||||||
23798 | 23798 | Arthur Cannon C000115 | rep | FL | 1939-01-03 | 1941-01-03 | Democrat | 4 | |||||||||||||
27687 | 27687 | Clarence Cannon C000117 | rep | MO | 1939-01-03 | 1941-01-03 | Democrat | 9 | |||||||||||||
22517 | 22517 | Hattie Caraway C000138 | sen | AR | 1939-01-03 | 1945-01-03 | 3 | Democrat | |||||||||||||
22908 | 22908 | Wilburn Cartwright C000207 | rep | OK | 1939-01-03 | 1941-01-03 | Democrat | 3 | |||||||||||||
22912 | 22912 | Joseph Casey C000225 | rep | MA | 1939-01-03 | 1941-01-03 | Democrat | 3 | |||||||||||||
29679 | 29679 | Emanuel Celler C000264 | rep | NY | 1939-01-03 | 1941-01-03 | Democrat | 10 | |||||||||||||
22520 | 22520 | Walter Chandler C000296 | rep | TN | 1939-01-03 | 1941-01-03 | Democrat | 9 | |||||||||||||
24797 | 24797 | Virgil Chapman C000317 | rep | KY | 1939-01-03 | 1941-01-03 | Democrat | 6 | |||||||||||||
22523 | 22523 | David Clark C000428 | sen | ID | 1939-01-03 | 1945-01-03 | 3 | Democrat | |||||||||||||
24299 | 24299 | Jerome Clark C000439 | rep | NC | 1939-01-03 | 1941-01-03 | Democrat | 7 | |||||||||||||
22525 | 22525 | Joel Clark C000440 | sen | MO | 1939-01-03 | 1945-01-03 | 3 | Democrat | |||||||||||||
22915 | 22915 | Harold Claypool C000489 | rep | OH | 1939-01-03 | 1941-01-03 | Democrat | 11 | |||||||||||||
23810 | 23810 | John Cochran C000565 | rep | MO | 1939-01-03 | 1941-01-03 | Democrat | 13 | |||||||||||||
22922 | 22922 | Harry Coffee C000582 | rep | NE | 1939-01-03 | 1941-01-03 | Democrat | 5 | |||||||||||||
23815 | 23815 | John Coffee C000584 | rep | WA | 1939-01-03 | 1941-01-03 | Democrat | 6 | |||||||||||||
22929 | 22929 | William Cole C000616 | rep | MD | 1939-01-03 | 1941-01-03 | Democrat | 2 | |||||||||||||
22939 | 22939 | Ross Collins C000642 | rep | MS | 1939-01-03 | 1941-01-03 | Democrat | 5 | |||||||||||||
29699 | 29699 | William Colmer C000645 | rep | MS | 1939-01-03 | 1941-01-03 | Democrat | 6 | |||||||||||||
22942 | 22942 | Lawrence Connery C000693 | rep | MA | 1939-01-03 | 1941-01-03 | Democrat | 7 | |||||||||||||
28376 | 28376 | Harold Cooley C000736 | rep | NC | 1939-01-03 | 1941-01-03 | Democrat | 4 | |||||||||||||
26255 | 26255 | Jere Cooper C000755 | rep | TN | 1939-01-03 | 1941-01-03 | Democrat | 8 | |||||||||||||
23377 | 23377 | John Costello C000795 | rep | CA | 1939-01-03 | 1941-01-03 | Democrat | 15 | |||||||||||||
24323 | 24323 | William Courtney C000810 | rep | TN | 1939-01-03 | 1941-01-03 | Democrat | 6 | |||||||||||||
25196 | 25196 | Edward Cox C000831 | rep | GA | 1939-01-03 | 1941-01-03 | Democrat | 2 | |||||||||||||
22532 | 22532 | William Cravens C000886 | rep | AR | 1939-01-03 | 1941-01-03 | Democrat | 4 | |||||||||||||
24328 | 24328 | William Cravens C000887 | rep | AR | 1939-01-03 | 1941-01-03 | Democrat | 4 | |||||||||||||
23382 | 23382 | Edward Creal C000898 | rep | KY | 1939-01-03 | 1941-01-03 | Democrat | 4 | |||||||||||||
25650 | 25650 | Robert Crosser C000932 | rep | OH | 1939-01-03 | 1941-01-03 | Democrat | 21 | |||||||||||||
22537 | 22537 | Eugene Crowe C000940 | rep | IN | 1939-01-03 | 1941-01-03 | Democrat | 9 | |||||||||||||
23404 | 23404 | Thomas Cullen C000970 | rep | NY | 1939-01-03 | 1941-01-03 | Democrat | 4 | |||||||||||||
22541 | 22541 | Fred Cummings C000985 | rep | CO | 1939-01-03 | 1941-01-03 | Democrat | 2 | |||||||||||||
22544 | 22544 | Edward Curley C000995 | rep | NY | 1939-01-03 | 1941-01-03 | Democrat | 22 | |||||||||||||
24334 | 24334 | Thomas D’Alesandro D000007 | rep | MD | 1939-01-03 | 1941-01-03 | Democrat | 3 | |||||||||||||
22547 | 22547 | John Daly D000014 | rep | PA | 1939-01-03 | 1941-01-03 | Democrat | 4 | |||||||||||||
22959 | 22959 | Colgate Darden D000050 | rep | VA | 1939-01-03 | 1941-01-03 | Democrat | 2 | |||||||||||||
27723 | 27723 | Clifford Davis D000094 | rep | TN | 1939-01-03 | 1941-01-03 | Democrat | 9 | |||||||||||||
24344 | 24344 | John Delaney D000212 | rep | NY | 1939-01-03 | 1941-01-03 | Democrat | 7 | |||||||||||||
26290 | 26290 | John Dempsey D000228 | rep | NM | 1939-01-03 | 1941-01-03 | Democrat | 1 | |||||||||||||
22570 | 22570 | René De Rouen D000265 | rep | LA | 1939-01-03 | 1941-01-03 | Democrat | 7 | |||||||||||||
23834 | 23834 | Samuel Dickstein D000335 | rep | NY | 1939-01-03 | 1941-01-03 | Democrat | 12 | |||||||||||||
26304 | 26304 | Martin Dies D000338 | rep | TX | 1939-01-03 | 1941-01-03 | Democrat | 2 | |||||||||||||
23415 | 23415 | Anthony Dimond D000353 | rep | AK | 1939-01-03 | 1941-01-03 | Democrat | 0 | |||||||||||||
25914 | 25914 | John Dingell D000354 | rep | MI | 1939-01-03 | 1941-01-03 | Democrat | 15 | |||||||||||||
23422 | 23422 | Wesley Disney D000362 | rep | OK | 1939-01-03 | 1941-01-03 | Democrat | 1 | |||||||||||||
25227 | 25227 | Robert Doughton D000448 | rep | NC | 1939-01-03 | 1941-01-03 | Democrat | 9 | |||||||||||||
23840 | 23840 | Sheridan Downey D000469 | sen | CA | 1939-01-03 | 1945-01-03 | 3 | Democrat | |||||||||||||
22968 | 22968 | Wall Doxey D000480 | rep | MS | 1939-01-03 | 1941-01-03 | Democrat | 2 | |||||||||||||
24364 | 24364 | Patrick Drewry D000496 | rep | VA | 1939-01-03 | 1941-01-03 | Democrat | 4 | |||||||||||||
22973 | 22973 | Richard Duncan D000536 | rep | MO | 1939-01-03 | 1941-01-03 | Democrat | 3 | |||||||||||||
22586 | 22586 | Matthew Dunn D000551 | rep | PA | 1939-01-03 | 1941-01-03 | Democrat | 34 | |||||||||||||
26826 | 26826 | Carl Durham D000571 | rep | NC | 1939-01-03 | 1941-01-03 | Democrat | 6 | |||||||||||||
26311 | 26311 | Herman Eberharter E000029 | rep | PA | 1939-01-03 | 1941-01-03 | Democrat | 32 | |||||||||||||
22975 | 22975 | Morris Edelstein E000041 | rep | NY | 1939-01-03 | 1941-01-03 | Democrat | 14 | |||||||||||||
22980 | 22980 | Andrew Edmiston E000051 | rep | WV | 1939-01-03 | 1941-01-03 | Democrat | 3 | |||||||||||||
24371 | 24371 | Alfred Elliott E000119 | rep | CA | 1939-01-03 | 1941-01-03 | Democrat | 10 | |||||||||||||
22983 | 22983 | Clyde Ellis E000132 | rep | AR | 1939-01-03 | 1941-01-03 | Democrat | 3 | |||||||||||||
22590 | 22590 | Marcellus Evans E000253 | rep | NY | 1939-01-03 | 1941-01-03 | Democrat | 5 | |||||||||||||
22988 | 22988 | Charles Faddis F000001 | rep | PA | 1939-01-03 | 1941-01-03 | Democrat | 25 | |||||||||||||
23451 | 23451 | James Fay F000051 | rep | NY | 1939-01-03 | 1941-01-03 | Democrat | 16 | |||||||||||||
22593 | 22593 | Phillip Ferguson F000082 | rep | OK | 1939-01-03 | 1941-01-03 | Democrat | 8 | |||||||||||||
22598 | 22598 | Joachim Fernández F000086 | rep | LA | 1939-01-03 | 1941-01-03 | Democrat | 1 | |||||||||||||
23472 | 23472 | James Fitzpatrick F000175 | rep | NY | 1939-01-03 | 1941-01-03 | Democrat | 24 |
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);