legislator_terms
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
37 rows where "end" is on date 1941-01-03 and type = "sen"
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
21626 | 21626 | Henry Ashurst A000319 | sen | AZ | 1935-01-03 | 1941-01-03 | 1 | Democrat | |||||||||||||
21667 | 21667 | Edward Burke B001089 | sen | NE | 1935-01-03 | 1941-01-03 | 1 | Democrat | |||||||||||||
21741 | 21741 | Alvin Donahey D000410 | sen | OH | 1935-01-03 | 1941-01-03 | 1 | Democrat | |||||||||||||
21767 | 21767 | Lynn Frazier F000354 | sen | ND | 1935-01-03 | 1941-01-03 | 1 | Republican | |||||||||||||
21800 | 21800 | Frederick Hale H000031 | sen | ME | 1935-01-03 | 1941-01-03 | 1 | Republican | |||||||||||||
21817 | 21817 | Rush Holt H000749 | sen | WV | 1935-01-03 | 1941-01-03 | 1 | Democrat | |||||||||||||
21845 | 21845 | William King K000216 | sen | UT | 1935-01-03 | 1941-01-03 | 1 | Democrat | |||||||||||||
21889 | 21889 | Sherman Minton M000800 | sen | IN | 1935-01-03 | 1941-01-03 | 1 | Democrat | |||||||||||||
21931 | 21931 | Key Pittman P000372 | sen | NV | 1935-01-03 | 1941-01-03 | 1 | Democrat | |||||||||||||
21976 | 21976 | John Townsend T000335 | sen | DE | 1935-01-03 | 1941-01-03 | 1 | Republican | |||||||||||||
22052 | 22052 | William Borah B000634 | sen | ID | 1937-01-05 | 1941-01-03 | 2 | Republican | |||||||||||||
22288 | 22288 | Ernest Lundeen L000514 | sen | MN | 1937-01-05 | 1941-01-03 | 2 | Farmer-Labor | |||||||||||||
22612 | 22612 | Ernest Gibson G000158 | sen | VT | 1939-01-03 | 1941-01-03 | 3 | Republican | |||||||||||||
22782 | 22782 | James Slattery S000478 | sen | IL | 1939-04-14 | 1941-01-03 | 2 | Democrat | appointment | ||||||||||||
22845 | 22845 | Monrad Wallgren W000088 | sen | WA | 1940-12-19 | 1941-01-03 | 1 | Democrat | |||||||||||||
22847 | 22847 | Charles Andrews A000244 | sen | FL | 1936-11-03 | 1941-01-03 | 1 | Democrat | |||||||||||||
22853 | 22853 | Warren Austin A000342 | sen | VT | 1935-01-03 | 1941-01-03 | 1 | Republican | |||||||||||||
22857 | 22857 | William Barbour B000132 | sen | NJ | 1938-01-01 | 1941-01-03 | 1 | Republican | |||||||||||||
22872 | 22872 | Theodore Bilbo B000460 | sen | MS | 1935-01-03 | 1941-01-03 | 1 | Democrat | |||||||||||||
23013 | 23013 | Peter Gerry G000141 | sen | RI | 1935-01-03 | 1941-01-03 | 1 | Democrat | |||||||||||||
23017 | 23017 | Joseph Guffey G000519 | sen | PA | 1935-01-03 | 1941-01-03 | 1 | Democrat | |||||||||||||
23075 | 23075 | Hiram Johnson J000140 | sen | CA | 1935-01-03 | 1941-01-03 | 1 | Republican | |||||||||||||
23095 | 23095 | Robert La Follette L000005 | sen | WI | 1935-01-03 | 1941-01-03 | 1 | Progressive | |||||||||||||
23111 | 23111 | Francis Maloney M000088 | sen | CT | 1935-01-03 | 1941-01-03 | 1 | Democrat | |||||||||||||
23137 | 23137 | James Mead M000615 | sen | NY | 1938-01-01 | 1941-01-03 | 1 | Democrat | |||||||||||||
23182 | 23182 | George Radcliffe R000006 | sen | MD | 1935-01-03 | 1941-01-03 | 1 | Democrat | |||||||||||||
23240 | 23240 | Henrik Shipstead S000369 | sen | MN | 1935-01-03 | 1941-01-03 | 1 | Republican | |||||||||||||
23316 | 23316 | David Walsh W000097 | sen | MA | 1935-01-03 | 1941-01-03 | 1 | Democrat | |||||||||||||
23320 | 23320 | Burton Wheeler W000330 | sen | MT | 1935-01-03 | 1941-01-03 | 1 | Democrat | |||||||||||||
23790 | 23790 | Berkeley Bunker B001061 | sen | NV | 1940-11-27 | 1941-01-03 | 1 | Democrat | appointment | ||||||||||||
24229 | 24229 | Harry Truman T000387 | sen | MO | 1935-01-03 | 1941-01-03 | 1 | Democrat | |||||||||||||
24320 | 24320 | Thomas Connally C000684 | sen | TX | 1935-01-03 | 1941-01-03 | 1 | Democrat | |||||||||||||
24610 | 24610 | Kenneth McKellar M000499 | sen | TN | 1935-01-03 | 1941-01-03 | 1 | Democrat | |||||||||||||
24709 | 24709 | Arthur Vandenberg V000025 | sen | MI | 1935-01-03 | 1941-01-03 | 1 | Republican | |||||||||||||
25859 | 25859 | Joseph O’Mahoney O000088 | sen | WY | 1935-01-03 | 1941-01-03 | 1 | Democrat | |||||||||||||
26776 | 26776 | Harry Byrd B001208 | sen | VA | 1935-01-03 | 1941-01-03 | 1 | Democrat | |||||||||||||
26802 | 26802 | Dennis Chavez C000338 | sen | NM | 1935-05-11 | 1941-01-03 | 1 | Democrat | appointment |
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);