legislator_terms
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
498 rows where "end" is on date 1941-01-03 sorted by state
This data as json, copyable, CSV (advanced)
Suggested facets: class, start (date)
start 9 ✖
- 1939-01-03 462
- 1935-01-03 27
- 1937-01-05 2
- 1938-01-01 2
- 1935-05-11 1
- 1936-11-03 1
- 1939-04-14 1
- 1940-11-27 1
- 1940-12-19 1
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
23415 | 23415 | Anthony Dimond D000353 | rep | AK | 1939-01-03 | 1941-01-03 | Democrat | 0 | |||||||||||||
22499 | 22499 | William Bankhead B000113 | rep | AL | 1939-01-03 | 1941-01-03 | Democrat | 7 | |||||||||||||
22832 | 22832 | Zadoc Weatherford W000222 | rep | AL | 1939-01-03 | 1941-01-03 | Democrat | 7 | |||||||||||||
23684 | 23684 | Joe Starnes S000816 | rep | AL | 1939-01-03 | 1941-01-03 | Democrat | 5 | |||||||||||||
23699 | 23699 | Henry Steagall S000820 | rep | AL | 1939-01-03 | 1941-01-03 | Democrat | 3 | |||||||||||||
24024 | 24024 | Luther Patrick P000105 | rep | AL | 1939-01-03 | 1941-01-03 | Democrat | 9 | |||||||||||||
24482 | 24482 | Peterson Jarman J000058 | rep | AL | 1939-01-03 | 1941-01-03 | Democrat | 6 | |||||||||||||
24848 | 24848 | Samuel Hobbs H000663 | rep | AL | 1939-01-03 | 1941-01-03 | Democrat | 4 | |||||||||||||
27112 | 27112 | Frank Boykin B000725 | rep | AL | 1939-01-03 | 1941-01-03 | Democrat | 1 | |||||||||||||
27817 | 27817 | George Grant G000381 | rep | AL | 1939-01-03 | 1941-01-03 | Democrat | 2 | |||||||||||||
30695 | 30695 | John Sparkman S000701 | rep | AL | 1939-01-03 | 1941-01-03 | Democrat | 8 | |||||||||||||
22532 | 22532 | William Cravens C000886 | rep | AR | 1939-01-03 | 1941-01-03 | Democrat | 4 | |||||||||||||
22660 | 22660 | Wade Kitchens K000248 | rep | AR | 1939-01-03 | 1941-01-03 | Democrat | 7 | |||||||||||||
22983 | 22983 | Clyde Ellis E000132 | rep | AR | 1939-01-03 | 1941-01-03 | Democrat | 3 | |||||||||||||
23292 | 23292 | David Terry T000133 | rep | AR | 1939-01-03 | 1941-01-03 | Democrat | 5 | |||||||||||||
24328 | 24328 | William Cravens C000887 | rep | AR | 1939-01-03 | 1941-01-03 | Democrat | 4 | |||||||||||||
27398 | 27398 | William Norrell N000137 | rep | AR | 1939-01-03 | 1941-01-03 | Democrat | 6 | |||||||||||||
28845 | 28845 | Ezekiel Gathings G000098 | rep | AR | 1939-01-03 | 1941-01-03 | Democrat | 1 | |||||||||||||
31181 | 31181 | Wilbur Mills M000778 | rep | AR | 1939-01-03 | 1941-01-03 | Democrat | 2 | |||||||||||||
21626 | 21626 | Henry Ashurst A000319 | sen | AZ | 1935-01-03 | 1941-01-03 | 1 | Democrat | |||||||||||||
25395 | 25395 | John Murdock M001081 | rep | AZ | 1939-01-03 | 1941-01-03 | Democrat | 0 | |||||||||||||
22587 | 22587 | Thomas Eaton E000026 | rep | CA | 1939-01-03 | 1941-01-03 | Republican | 18 | |||||||||||||
22892 | 22892 | Frank Buck B001017 | rep | CA | 1939-01-03 | 1941-01-03 | Democrat | 3 | |||||||||||||
23004 | 23004 | Leland Ford F000264 | rep | CA | 1939-01-03 | 1941-01-03 | Republican | 16 | |||||||||||||
23015 | 23015 | Lee Geyer G000147 | rep | CA | 1939-01-03 | 1941-01-03 | Democrat | 17 | |||||||||||||
23075 | 23075 | Hiram Johnson J000140 | sen | CA | 1935-01-03 | 1941-01-03 | 1 | Republican | |||||||||||||
23091 | 23091 | Charles Kramer K000321 | rep | CA | 1939-01-03 | 1941-01-03 | Democrat | 13 | |||||||||||||
23369 | 23369 | Albert Carter C000195 | rep | CA | 1939-01-03 | 1941-01-03 | Republican | 6 | |||||||||||||
23377 | 23377 | John Costello C000795 | rep | CA | 1939-01-03 | 1941-01-03 | Democrat | 15 | |||||||||||||
23448 | 23448 | Harry Englebright E000182 | rep | CA | 1939-01-03 | 1941-01-03 | Republican | 2 | |||||||||||||
23478 | 23478 | Thomas Ford F000267 | rep | CA | 1939-01-03 | 1941-01-03 | Democrat | 14 | |||||||||||||
23897 | 23897 | Edouard Izac I000052 | rep | CA | 1939-01-03 | 1941-01-03 | Democrat | 20 | |||||||||||||
24160 | 24160 | John Tolan T000295 | rep | CA | 1939-01-03 | 1941-01-03 | Democrat | 7 | |||||||||||||
24175 | 24175 | Horace Voorhis V000118 | rep | CA | 1939-01-03 | 1941-01-03 | Democrat | 12 | |||||||||||||
24371 | 24371 | Alfred Elliott E000119 | rep | CA | 1939-01-03 | 1941-01-03 | Democrat | 10 | |||||||||||||
24403 | 24403 | Bertrand Gearhart G000111 | rep | CA | 1939-01-03 | 1941-01-03 | Republican | 9 | |||||||||||||
24546 | 24546 | Clarence Lea L000163 | rep | CA | 1939-01-03 | 1941-01-03 | Democrat | 1 | |||||||||||||
25068 | 25068 | Richard Welch W000265 | rep | CA | 1939-01-03 | 1941-01-03 | Republican | 5 | |||||||||||||
25120 | 25120 | John Anderson A000196 | rep | CA | 1939-01-03 | 1941-01-03 | Republican | 8 | |||||||||||||
25307 | 25307 | Franck Havenner H000356 | rep | CA | 1939-01-03 | 1941-01-03 | Democrat | 4 | |||||||||||||
25994 | 25994 | John Hinshaw H000640 | rep | CA | 1939-01-03 | 1941-01-03 | Republican | 11 | |||||||||||||
28140 | 28140 | Harry Sheppard S000335 | rep | CA | 1939-01-03 | 1941-01-03 | Democrat | 19 | |||||||||||||
22509 | 22509 | William Burney B001122 | rep | CO | 1939-01-03 | 1941-01-03 | Democrat | 3 | |||||||||||||
22541 | 22541 | Fred Cummings C000985 | rep | CO | 1939-01-03 | 1941-01-03 | Democrat | 2 | |||||||||||||
22694 | 22694 | John Martin M000186 | rep | CO | 1939-01-03 | 1941-01-03 | Democrat | 3 | |||||||||||||
23285 | 23285 | Edward Taylor T000072 | rep | CO | 1939-01-03 | 1941-01-03 | Democrat | 4 | |||||||||||||
23582 | 23582 | Lawrence Lewis L000291 | rep | CO | 1939-01-03 | 1941-01-03 | Democrat | 1 | |||||||||||||
22486 | 22486 | Albert Austin A000339 | rep | CT | 1939-01-03 | 1941-01-03 | Republican | 4 | |||||||||||||
22487 | 22487 | Thomas Ball B000102 | rep | CT | 1939-01-03 | 1941-01-03 | Republican | 2 | |||||||||||||
23111 | 23111 | Francis Maloney M000088 | sen | CT | 1935-01-03 | 1941-01-03 | 1 | Democrat | |||||||||||||
23230 | 23230 | James Shanley S000285 | rep | CT | 1939-01-03 | 1941-01-03 | Democrat | 3 | |||||||||||||
23246 | 23246 | John Smith S000572 | rep | CT | 1939-01-03 | 1941-01-03 | Democrat | 5 | |||||||||||||
23621 | 23621 | Boleslaus Monkiewicz M000855 | rep | CT | 1939-01-03 | 1941-01-03 | Republican | 0 | |||||||||||||
24616 | 24616 | William Miller M000764 | rep | CT | 1939-01-03 | 1941-01-03 | Republican | 1 | |||||||||||||
21976 | 21976 | John Townsend T000335 | sen | DE | 1935-01-03 | 1941-01-03 | 1 | Republican | |||||||||||||
22835 | 22835 | George Williams W000500 | rep | DE | 1939-01-03 | 1941-01-03 | Republican | 0 | |||||||||||||
22514 | 22514 | Millard Caldwell C000038 | rep | FL | 1939-01-03 | 1941-01-03 | Democrat | 3 | |||||||||||||
22847 | 22847 | Charles Andrews A000244 | sen | FL | 1936-11-03 | 1941-01-03 | 1 | Democrat | |||||||||||||
23533 | 23533 | Robert Green G000415 | rep | FL | 1939-01-03 | 1941-01-03 | Democrat | 2 | |||||||||||||
23798 | 23798 | Arthur Cannon C000115 | rep | FL | 1939-01-03 | 1941-01-03 | Democrat | 4 | |||||||||||||
24471 | 24471 | Joseph Hendricks H000492 | rep | FL | 1939-01-03 | 1941-01-03 | Democrat | 5 | |||||||||||||
24975 | 24975 | James Peterson P000261 | rep | FL | 1939-01-03 | 1941-01-03 | Democrat | 1 | |||||||||||||
22604 | 22604 | Florence Gibbs G000155 | rep | GA | 1939-01-03 | 1941-01-03 | Democrat | 8 | |||||||||||||
22605 | 22605 | Willis Gibbs G000156 | rep | GA | 1939-01-03 | 1941-01-03 | Democrat | 8 | |||||||||||||
22741 | 22741 | Emmett Owen O000149 | rep | GA | 1939-01-03 | 1941-01-03 | Democrat | 4 | |||||||||||||
23744 | 23744 | Benjamin Whelchel W000343 | rep | GA | 1939-01-03 | 1941-01-03 | Democrat | 9 | |||||||||||||
24030 | 24030 | Hugh Peterson P000260 | rep | GA | 1939-01-03 | 1941-01-03 | Democrat | 1 | |||||||||||||
24056 | 24056 | Robert Ramspeck R000032 | rep | GA | 1939-01-03 | 1941-01-03 | Democrat | 5 | |||||||||||||
24139 | 24139 | Malcolm Tarver T000045 | rep | GA | 1939-01-03 | 1941-01-03 | Democrat | 7 | |||||||||||||
24966 | 24966 | Stephen Pace P000002 | rep | GA | 1939-01-03 | 1941-01-03 | Democrat | 3 | |||||||||||||
25196 | 25196 | Edward Cox C000831 | rep | GA | 1939-01-03 | 1941-01-03 | Democrat | 2 | |||||||||||||
25624 | 25624 | Albert Camp C000070 | rep | GA | 1939-01-03 | 1941-01-03 | Democrat | 4 | |||||||||||||
26751 | 26751 | Paul Brown B000940 | rep | GA | 1939-01-03 | 1941-01-03 | Democrat | 10 | |||||||||||||
28216 | 28216 | Carl Vinson V000105 | rep | GA | 1939-01-03 | 1941-01-03 | Democrat | 6 | |||||||||||||
23081 | 23081 | Samuel King K000214 | rep | HI | 1939-01-03 | 1941-01-03 | Republican | 0 | |||||||||||||
22582 | 22582 | Cassius Dowell D000468 | rep | IA | 1939-01-03 | 1941-01-03 | Republican | 6 | |||||||||||||
22623 | 22623 | Robert Goodwin G000303 | rep | IA | 1939-01-03 | 1941-01-03 | Republican | 6 | |||||||||||||
23025 | 23025 | Vincent Harrington H000231 | rep | IA | 1939-01-03 | 1941-01-03 | Democrat | 9 | |||||||||||||
23056 | 23056 | William Jacobsen J000039 | rep | IA | 1939-01-03 | 1941-01-03 | Democrat | 2 | |||||||||||||
23509 | 23509 | Fred Gilchrist G000181 | rep | IA | 1939-01-03 | 1941-01-03 | Republican | 8 | |||||||||||||
24447 | 24447 | John Gwynne G000543 | rep | IA | 1939-01-03 | 1941-01-03 | Republican | 3 | |||||||||||||
26048 | 26048 | Thomas Martin M000199 | rep | IA | 1939-01-03 | 1941-01-03 | Republican | 1 | |||||||||||||
26482 | 26482 | Karl Le Compte L000157 | rep | IA | 1939-01-03 | 1941-01-03 | Republican | 5 | |||||||||||||
26622 | 26622 | Henry Talle T000028 | rep | IA | 1939-01-03 | 1941-01-03 | Republican | 4 | |||||||||||||
27915 | 27915 | Benton Jensen J000100 | rep | IA | 1939-01-03 | 1941-01-03 | Republican | 7 | |||||||||||||
22052 | 22052 | William Borah B000634 | sen | ID | 1937-01-05 | 1941-01-03 | 2 | Republican | |||||||||||||
25080 | 25080 | Compton White W000361 | rep | ID | 1939-01-03 | 1941-01-03 | Democrat | 1 | |||||||||||||
27185 | 27185 | Henry Dworshak D000585 | rep | ID | 1939-01-03 | 1941-01-03 | Republican | 2 | |||||||||||||
22600 | 22600 | Frank Fries F000385 | rep | IL | 1939-01-03 | 1941-01-03 | Democrat | 21 | |||||||||||||
22653 | 22653 | Kent Keller K000056 | rep | IL | 1939-01-03 | 1941-01-03 | Democrat | 25 | |||||||||||||
22695 | 22695 | John Martin M000187 | rep | IL | 1939-01-03 | 1941-01-03 | Democrat | 0 | |||||||||||||
22704 | 22704 | James McAndrews M000296 | rep | IL | 1939-01-03 | 1941-01-03 | Democrat | 9 | |||||||||||||
22747 | 22747 | Claude Parsons P000086 | rep | IL | 1939-01-03 | 1941-01-03 | Democrat | 24 | |||||||||||||
22782 | 22782 | James Slattery S000478 | sen | IL | 1939-04-14 | 1941-01-03 | 2 | Democrat | appointment | ||||||||||||
22791 | 22791 | Thomas Smith S000620 | rep | IL | 1939-01-03 | 1941-01-03 | Democrat | 0 | |||||||||||||
22850 | 22850 | Laurence Arnold A000290 | rep | IL | 1939-01-03 | 1941-01-03 | Democrat | 23 | |||||||||||||
22859 | 22859 | James Barnes B000158 | rep | IL | 1939-01-03 | 1941-01-03 | Democrat | 20 | |||||||||||||
22865 | 22865 | Harry Beam B000274 | rep | IL | 1939-01-03 | 1941-01-03 | Democrat | 4 | |||||||||||||
23086 | 23086 | Leo Kocialkowski K000303 | rep | IL | 1939-01-03 | 1941-01-03 | Democrat | 8 | |||||||||||||
23107 | 23107 | Anton Maciejewski M000016 | rep | IL | 1939-01-03 | 1941-01-03 | Democrat | 6 |
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);