legislator_terms
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
244 rows where party = "Democrat" and "start" is on date 1943-01-06 sorted by state
This data as json, copyable, CSV (advanced)
Suggested facets: type, end (date)
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
23417 | 23417 | Anthony Dimond D000353 | rep | AK | 1943-01-06 | 1945-01-03 | Democrat | 0 | |||||||||||||
23348 | 23348 | John Bankhead B000111 | sen | AL | 1943-01-06 | 1947-01-03 | 2 | Democrat | |||||||||||||
23627 | 23627 | John Newsome N000073 | rep | AL | 1943-01-06 | 1945-01-03 | Democrat | 9 | |||||||||||||
23686 | 23686 | Joe Starnes S000816 | rep | AL | 1943-01-06 | 1945-01-03 | Democrat | 5 | |||||||||||||
23701 | 23701 | Henry Steagall S000820 | rep | AL | 1943-01-06 | 1945-01-03 | Democrat | 3 | |||||||||||||
24484 | 24484 | Peterson Jarman J000058 | rep | AL | 1943-01-06 | 1945-01-03 | Democrat | 6 | |||||||||||||
24574 | 24574 | Carter Manasco M000094 | rep | AL | 1943-01-06 | 1945-01-03 | Democrat | 7 | |||||||||||||
24850 | 24850 | Samuel Hobbs H000663 | rep | AL | 1943-01-06 | 1945-01-03 | Democrat | 4 | |||||||||||||
27114 | 27114 | Frank Boykin B000725 | rep | AL | 1943-01-06 | 1945-01-03 | Democrat | 1 | |||||||||||||
27819 | 27819 | George Grant G000381 | rep | AL | 1943-01-06 | 1945-01-03 | Democrat | 2 | |||||||||||||
29544 | 29544 | George Andrews A000206 | rep | AL | 1943-01-06 | 1945-01-03 | Democrat | 3 | |||||||||||||
30697 | 30697 | John Sparkman S000701 | rep | AL | 1943-01-06 | 1945-01-03 | Democrat | 8 | |||||||||||||
24330 | 24330 | William Cravens C000887 | rep | AR | 1943-01-06 | 1945-01-03 | Democrat | 4 | |||||||||||||
26370 | 26370 | Lawrence Hays H000405 | rep | AR | 1943-01-06 | 1945-01-03 | Democrat | 5 | |||||||||||||
27400 | 27400 | William Norrell N000137 | rep | AR | 1943-01-06 | 1945-01-03 | Democrat | 6 | |||||||||||||
28448 | 28448 | Oren Harris H000249 | rep | AR | 1943-01-06 | 1945-01-03 | Democrat | 7 | |||||||||||||
28847 | 28847 | Ezekiel Gathings G000098 | rep | AR | 1943-01-06 | 1945-01-03 | Democrat | 1 | |||||||||||||
29280 | 29280 | James Fulbright F000401 | rep | AR | 1943-01-06 | 1945-01-03 | Democrat | 3 | |||||||||||||
30565 | 30565 | John McClellan M000332 | sen | AR | 1943-01-06 | 1949-01-03 | 2 | Democrat | |||||||||||||
31183 | 31183 | Wilbur Mills M000778 | rep | AR | 1943-01-06 | 1945-01-03 | Democrat | 2 | |||||||||||||
24452 | 24452 | Richard Harless H000212 | rep | AZ | 1943-01-06 | 1945-01-03 | Democrat | 0 | |||||||||||||
25397 | 25397 | John Murdock M001081 | rep | AZ | 1943-01-06 | 1945-01-03 | Democrat | 0 | |||||||||||||
23379 | 23379 | John Costello C000795 | rep | CA | 1943-01-06 | 1945-01-03 | Democrat | 15 | |||||||||||||
23480 | 23480 | Thomas Ford F000267 | rep | CA | 1943-01-06 | 1945-01-03 | Democrat | 14 | |||||||||||||
23654 | 23654 | William Rogers R000406 | rep | CA | 1943-01-06 | 1945-01-03 | Democrat | 16 | |||||||||||||
23899 | 23899 | Edouard Izac I000052 | rep | CA | 1943-01-06 | 1945-01-03 | Democrat | 23 | |||||||||||||
24017 | 24017 | George Outland O000137 | rep | CA | 1943-01-06 | 1945-01-03 | Democrat | 11 | |||||||||||||
24162 | 24162 | John Tolan T000295 | rep | CA | 1943-01-06 | 1945-01-03 | Democrat | 7 | |||||||||||||
24177 | 24177 | Horace Voorhis V000118 | rep | CA | 1943-01-06 | 1945-01-03 | Democrat | 12 | |||||||||||||
24373 | 24373 | Alfred Elliott E000119 | rep | CA | 1943-01-06 | 1945-01-03 | Democrat | 10 | |||||||||||||
24548 | 24548 | Clarence Lea L000163 | rep | CA | 1943-01-06 | 1945-01-03 | Democrat | 1 | |||||||||||||
26838 | 26838 | Clair Engle E000181 | rep | CA | 1943-01-06 | 1945-01-03 | Democrat | 2 | |||||||||||||
28142 | 28142 | Harry Sheppard S000335 | rep | CA | 1943-01-06 | 1945-01-03 | Democrat | 21 | |||||||||||||
28943 | 28943 | Cecil King K000196 | rep | CA | 1943-01-06 | 1945-01-03 | Democrat | 17 | |||||||||||||
30481 | 30481 | Chester Holifield H000713 | rep | CA | 1943-01-06 | 1945-01-03 | Democrat | 19 | |||||||||||||
23584 | 23584 | Lawrence Lewis L000291 | rep | CO | 1943-01-06 | 1945-01-03 | Democrat | 1 | |||||||||||||
24866 | 24866 | Edwin Johnson J000127 | sen | CO | 1943-01-06 | 1949-01-03 | 2 | Democrat | |||||||||||||
23535 | 23535 | Robert Green G000415 | rep | FL | 1943-01-06 | 1945-01-03 | Democrat | -1 | |||||||||||||
23800 | 23800 | Arthur Cannon C000115 | rep | FL | 1943-01-06 | 1945-01-03 | Democrat | 4 | |||||||||||||
24473 | 24473 | Joseph Hendricks H000492 | rep | FL | 1943-01-06 | 1945-01-03 | Democrat | 5 | |||||||||||||
24632 | 24632 | Emory Price P000524 | rep | FL | 1943-01-06 | 1945-01-03 | Democrat | 2 | |||||||||||||
24977 | 24977 | James Peterson P000261 | rep | FL | 1943-01-06 | 1945-01-03 | Democrat | 1 | |||||||||||||
31801 | 31801 | Robert Sikes S000406 | rep | FL | 1943-01-06 | 1945-01-03 | Democrat | 3 | |||||||||||||
23746 | 23746 | Benjamin Whelchel W000343 | rep | GA | 1943-01-06 | 1945-01-03 | Democrat | 9 | |||||||||||||
23848 | 23848 | John Gibson G000163 | rep | GA | 1943-01-06 | 1945-01-03 | Democrat | 8 | |||||||||||||
24032 | 24032 | Hugh Peterson P000260 | rep | GA | 1943-01-06 | 1945-01-03 | Democrat | 1 | |||||||||||||
24058 | 24058 | Robert Ramspeck R000032 | rep | GA | 1943-01-06 | 1945-01-03 | Democrat | 5 | |||||||||||||
24141 | 24141 | Malcolm Tarver T000045 | rep | GA | 1943-01-06 | 1945-01-03 | Democrat | 7 | |||||||||||||
24968 | 24968 | Stephen Pace P000002 | rep | GA | 1943-01-06 | 1945-01-03 | Democrat | 3 | |||||||||||||
25198 | 25198 | Edward Cox C000831 | rep | GA | 1943-01-06 | 1945-01-03 | Democrat | 2 | |||||||||||||
25626 | 25626 | Albert Camp C000070 | rep | GA | 1943-01-06 | 1945-01-03 | Democrat | 4 | |||||||||||||
26753 | 26753 | Paul Brown B000940 | rep | GA | 1943-01-06 | 1945-01-03 | Democrat | 10 | |||||||||||||
28218 | 28218 | Carl Vinson V000105 | rep | GA | 1943-01-06 | 1945-01-03 | Democrat | 6 | |||||||||||||
29026 | 29026 | Richard Russell R000536 | sen | GA | 1943-01-06 | 1949-01-03 | 2 | Democrat | |||||||||||||
25082 | 25082 | Compton White W000361 | rep | ID | 1943-01-06 | 1945-01-03 | Democrat | 1 | |||||||||||||
23672 | 23672 | Leonard Schuetz S000144 | rep | IL | 1943-01-06 | 1945-01-03 | Democrat | 7 | |||||||||||||
24079 | 24079 | William Rowan R000473 | rep | IL | 1943-01-06 | 1945-01-03 | Democrat | 2 | |||||||||||||
24838 | 24838 | Martin Gorski G000332 | rep | IL | 1943-01-06 | 1945-01-03 | Democrat | 4 | |||||||||||||
25472 | 25472 | Adolph Sabath S000001 | rep | IL | 1943-01-06 | 1945-01-03 | Democrat | 5 | |||||||||||||
26326 | 26326 | Thomas Gordon G000316 | rep | IL | 1943-01-06 | 1945-01-03 | Democrat | 8 | |||||||||||||
28056 | 28056 | Thomas O’Brien O000016 | rep | IL | 1943-01-06 | 1945-01-03 | Democrat | 6 | |||||||||||||
29204 | 29204 | William Dawson D000158 | rep | IL | 1943-01-06 | 1945-01-03 | Democrat | 1 | |||||||||||||
24567 | 24567 | Louis Ludlow L000501 | rep | IN | 1943-01-06 | 1945-01-03 | Democrat | 11 | |||||||||||||
31143 | 31143 | Ray Madden M000039 | rep | IN | 1943-01-06 | 1945-01-03 | Democrat | 1 | |||||||||||||
23373 | 23373 | Albert Chandler C000290 | sen | KY | 1943-01-06 | 1945-12-31 | 2 | Democrat | |||||||||||||
23384 | 23384 | Edward Creal C000898 | rep | KY | 1943-01-06 | 1945-01-03 | Democrat | 4 | |||||||||||||
23731 | 23731 | Beverly Vincent V000100 | rep | KY | 1943-01-06 | 1945-01-03 | Democrat | 2 | |||||||||||||
23981 | 23981 | Andrew May M000272 | rep | KY | 1943-01-06 | 1945-01-03 | Democrat | 7 | |||||||||||||
24015 | 24015 | Emmet O’Neal O000089 | rep | KY | 1943-01-06 | 1945-01-03 | Democrat | 3 | |||||||||||||
24799 | 24799 | Virgil Chapman C000317 | rep | KY | 1943-01-06 | 1945-01-03 | Democrat | 6 | |||||||||||||
25133 | 25133 | Joseph Bates B000237 | rep | KY | 1943-01-06 | 1945-01-03 | Democrat | 8 | |||||||||||||
26337 | 26337 | Noble Gregory G000447 | rep | KY | 1943-01-06 | 1945-01-03 | Democrat | 1 | |||||||||||||
27539 | 27539 | Brent Spence S000717 | rep | KY | 1943-01-06 | 1945-01-03 | Democrat | 5 | |||||||||||||
23972 | 23972 | Paul Maloney M000091 | rep | LA | 1943-01-06 | 1945-01-03 | Democrat | 2 | |||||||||||||
23990 | 23990 | Charles McKenzie M000504 | rep | LA | 1943-01-06 | 1945-01-03 | Democrat | 5 | |||||||||||||
24351 | 24351 | James Domengeaux D000406 | rep | LA | 1943-01-06 | 1945-01-03 | Democrat | 3 | |||||||||||||
25115 | 25115 | Asa Allen A000114 | rep | LA | 1943-01-06 | 1945-01-03 | Democrat | 8 | |||||||||||||
25363 | 25363 | Henry Larcade L000095 | rep | LA | 1943-01-06 | 1945-01-03 | Democrat | 7 | |||||||||||||
27130 | 27130 | Overton Brooks B000884 | rep | LA | 1943-01-06 | 1945-01-03 | Democrat | 4 | |||||||||||||
28574 | 28574 | James Morrison M000995 | rep | LA | 1943-01-06 | 1945-01-03 | Democrat | 6 | |||||||||||||
28817 | 28817 | Allen Ellender E000112 | sen | LA | 1943-01-06 | 1949-01-03 | 2 | Democrat | |||||||||||||
31036 | 31036 | Felix Hébert H000437 | rep | LA | 1943-01-06 | 1945-01-03 | Democrat | 1 | |||||||||||||
23821 | 23821 | James Curley C000996 | rep | MA | 1943-01-06 | 1945-01-03 | Democrat | 11 | |||||||||||||
27305 | 27305 | Thomas Lane L000065 | rep | MA | 1943-01-06 | 1945-01-03 | Democrat | 7 | |||||||||||||
29372 | 29372 | John McCormack M000364 | rep | MA | 1943-01-06 | 1945-01-03 | Democrat | 12 | |||||||||||||
29406 | 29406 | Philip Philbin P000303 | rep | MA | 1943-01-06 | 1945-01-03 | Democrat | 3 | |||||||||||||
23735 | 23735 | David Ward W000130 | rep | MD | 1943-01-06 | 1945-01-03 | Democrat | 1 | |||||||||||||
23765 | 23765 | Harry Baldwin B000086 | rep | MD | 1943-01-06 | 1945-01-03 | Democrat | 2 | |||||||||||||
24336 | 24336 | Thomas D’Alesandro D000007 | rep | MD | 1943-01-06 | 1945-01-03 | Democrat | 3 | |||||||||||||
25479 | 25479 | Lansdale Sasscer S000067 | rep | MD | 1943-01-06 | 1945-01-03 | Democrat | 5 | |||||||||||||
24894 | 24894 | John Lesinski L000251 | rep | MI | 1943-01-06 | 1945-01-03 | Democrat | 16 | |||||||||||||
25014 | 25014 | George Sadowski S000011 | rep | MI | 1943-01-06 | 1945-01-03 | Democrat | 1 | |||||||||||||
25768 | 25768 | George O’Brien O000009 | rep | MI | 1943-01-06 | 1945-01-03 | Democrat | 13 | |||||||||||||
25916 | 25916 | John Dingell D000354 | rep | MI | 1943-01-06 | 1945-01-03 | Democrat | 15 | |||||||||||||
27420 | 27420 | Louis Rabaut R000001 | rep | MI | 1943-01-06 | 1945-01-03 | Democrat | 14 | |||||||||||||
23812 | 23812 | John Cochran C000565 | rep | MO | 1943-01-06 | 1945-01-03 | Democrat | 13 | |||||||||||||
24096 | 24096 | Roger Slaughter S000481 | rep | MO | 1943-01-06 | 1945-01-03 | Democrat | 5 | |||||||||||||
24269 | 24269 | Charles Bell B000332 | rep | MO | 1943-01-06 | 1945-01-03 | Democrat | 4 | |||||||||||||
24725 | 24725 | Orville Zimmerman Z000009 | rep | MO | 1943-01-06 | 1945-01-03 | Democrat | 10 | |||||||||||||
27689 | 27689 | Clarence Cannon C000117 | rep | MO | 1943-01-06 | 1945-01-03 | Democrat | 9 |
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);