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 party
This data as json, copyable, CSV (advanced)
Suggested facets: class, start (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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
23436 | 23436 | Joaquin Elizalde E000108 | rep | PI | 1939-01-03 | 1941-01-03 | 0 | ||||||||||||||
24912 | 24912 | Vito Marcantonio M000122 | rep | NY | 1939-01-03 | 1941-01-03 | American Labor | 20 | |||||||||||||
22635 | 22635 | Santiago Iglesias I000002 | rep | PR | 1939-01-03 | 1941-01-03 | Coalitionist | 0 | |||||||||||||
23643 | 23643 | Bolívar Pagán P000013 | rep | PR | 1939-01-03 | 1941-01-03 | Coalitionist | 0 | |||||||||||||
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 | |||||||||||||
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 | |||||||||||||
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 | |||||||||||||
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 | |||||||||||||
22509 | 22509 | William Burney B001122 | rep | CO | 1939-01-03 | 1941-01-03 | Democrat | 3 | |||||||||||||
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 | |||||||||||||
22520 | 22520 | Walter Chandler C000296 | rep | TN | 1939-01-03 | 1941-01-03 | Democrat | 9 | |||||||||||||
22532 | 22532 | William Cravens C000886 | rep | AR | 1939-01-03 | 1941-01-03 | Democrat | 4 | |||||||||||||
22537 | 22537 | Eugene Crowe C000940 | rep | IN | 1939-01-03 | 1941-01-03 | Democrat | 9 | |||||||||||||
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 | |||||||||||||
22547 | 22547 | John Daly D000014 | rep | PA | 1939-01-03 | 1941-01-03 | Democrat | 4 | |||||||||||||
22570 | 22570 | René De Rouen D000265 | rep | LA | 1939-01-03 | 1941-01-03 | Democrat | 7 | |||||||||||||
22586 | 22586 | Matthew Dunn D000551 | rep | PA | 1939-01-03 | 1941-01-03 | Democrat | 34 | |||||||||||||
22590 | 22590 | Marcellus Evans E000253 | rep | NY | 1939-01-03 | 1941-01-03 | Democrat | 5 | |||||||||||||
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 | |||||||||||||
22600 | 22600 | Frank Fries F000385 | rep | IL | 1939-01-03 | 1941-01-03 | Democrat | 21 | |||||||||||||
22602 | 22602 | Clyde Garrett G000080 | rep | TX | 1939-01-03 | 1941-01-03 | Democrat | 17 | |||||||||||||
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 | |||||||||||||
22622 | 22622 | Thomas Goldsborough G000265 | rep | MD | 1939-01-03 | 1941-01-03 | Democrat | 1 | |||||||||||||
22625 | 22625 | John Griffith G000469 | rep | LA | 1939-01-03 | 1941-01-03 | Democrat | 6 | |||||||||||||
22648 | 22648 | John Jones J000236 | rep | TX | 1939-01-03 | 1941-01-03 | Democrat | 18 | |||||||||||||
22653 | 22653 | Kent Keller K000056 | rep | IL | 1939-01-03 | 1941-01-03 | Democrat | 25 | |||||||||||||
22658 | 22658 | Ambrose Kennedy K000101 | rep | MD | 1939-01-03 | 1941-01-03 | Democrat | 4 | |||||||||||||
22660 | 22660 | Wade Kitchens K000248 | rep | AR | 1939-01-03 | 1941-01-03 | Democrat | 7 | |||||||||||||
22694 | 22694 | John Martin M000186 | rep | CO | 1939-01-03 | 1941-01-03 | Democrat | 3 | |||||||||||||
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 | |||||||||||||
22714 | 22714 | Clara McMillan M000565 | rep | SC | 1939-01-03 | 1941-01-03 | Democrat | 1 | |||||||||||||
22722 | 22722 | Thomas McMillan M000572 | rep | SC | 1939-01-03 | 1941-01-03 | Democrat | 1 | |||||||||||||
22731 | 22731 | Samuel McReynolds M000598 | rep | TN | 1939-01-03 | 1941-01-03 | Democrat | 3 | |||||||||||||
22733 | 22733 | Robert Mouton M001051 | rep | LA | 1939-01-03 | 1941-01-03 | Democrat | 3 | |||||||||||||
22741 | 22741 | Emmett Owen O000149 | rep | GA | 1939-01-03 | 1941-01-03 | Democrat | 4 | |||||||||||||
22747 | 22747 | Claude Parsons P000086 | rep | IL | 1939-01-03 | 1941-01-03 | Democrat | 24 | |||||||||||||
22757 | 22757 | Elmer Ryan R000555 | rep | MN | 1939-01-03 | 1941-01-03 | Democrat | 2 | |||||||||||||
22781 | 22781 | William Sirovich S000452 | rep | NY | 1939-01-03 | 1941-01-03 | Democrat | 14 | |||||||||||||
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 | |||||||||||||
22803 | 22803 | Christopher Sullivan S001051 | rep | NY | 1939-01-03 | 1941-01-03 | Democrat | 13 | |||||||||||||
22821 | 22821 | Clarence Turner T000417 | rep | TN | 1939-01-03 | 1941-01-03 | Democrat | 6 | |||||||||||||
22831 | 22831 | Lindsay Warren W000166 | rep | NC | 1939-01-03 | 1941-01-03 | Democrat | 1 | |||||||||||||
22832 | 22832 | Zadoc Weatherford W000222 | rep | AL | 1939-01-03 | 1941-01-03 | Democrat | 7 | |||||||||||||
22839 | 22839 | Reuben Wood W000702 | rep | MO | 1939-01-03 | 1941-01-03 | Democrat | 6 | |||||||||||||
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 | |||||||||||||
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 | |||||||||||||
22872 | 22872 | Theodore Bilbo B000460 | sen | MS | 1935-01-03 | 1941-01-03 | 1 | Democrat | |||||||||||||
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 | |||||||||||||
22892 | 22892 | Frank Buck B001017 | rep | CA | 1939-01-03 | 1941-01-03 | Democrat | 3 | |||||||||||||
22900 | 22900 | William Byron B001206 | rep | MD | 1939-01-03 | 1941-01-03 | Democrat | 6 | |||||||||||||
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 | |||||||||||||
22915 | 22915 | Harold Claypool C000489 | rep | OH | 1939-01-03 | 1941-01-03 | Democrat | 11 | |||||||||||||
22922 | 22922 | Harry Coffee C000582 | rep | NE | 1939-01-03 | 1941-01-03 | Democrat | 5 | |||||||||||||
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 | |||||||||||||
22942 | 22942 | Lawrence Connery C000693 | rep | MA | 1939-01-03 | 1941-01-03 | Democrat | 7 | |||||||||||||
22959 | 22959 | Colgate Darden D000050 | rep | VA | 1939-01-03 | 1941-01-03 | Democrat | 2 | |||||||||||||
22968 | 22968 | Wall Doxey D000480 | rep | MS | 1939-01-03 | 1941-01-03 | Democrat | 2 | |||||||||||||
22973 | 22973 | Richard Duncan D000536 | rep | MO | 1939-01-03 | 1941-01-03 | Democrat | 3 | |||||||||||||
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 | |||||||||||||
22983 | 22983 | Clyde Ellis E000132 | rep | AR | 1939-01-03 | 1941-01-03 | Democrat | 3 | |||||||||||||
22988 | 22988 | Charles Faddis F000001 | rep | PA | 1939-01-03 | 1941-01-03 | Democrat | 25 | |||||||||||||
22993 | 22993 | Thomas Flaherty F000183 | rep | MA | 1939-01-03 | 1941-01-03 | Democrat | 11 | |||||||||||||
22996 | 22996 | John Flannery F000192 | rep | PA | 1939-01-03 | 1941-01-03 | Democrat | 12 | |||||||||||||
22998 | 22998 | Alonzo Folger F000240 | rep | NC | 1939-01-03 | 1941-01-03 | Democrat | 5 | |||||||||||||
23002 | 23002 | Aaron Ford F000258 | rep | MS | 1939-01-03 | 1941-01-03 | Democrat | 4 | |||||||||||||
23013 | 23013 | Peter Gerry G000141 | sen | RI | 1935-01-03 | 1941-01-03 | 1 | Democrat | |||||||||||||
23015 | 23015 | Lee Geyer G000147 | rep | CA | 1939-01-03 | 1941-01-03 | Democrat | 17 | |||||||||||||
23017 | 23017 | Joseph Guffey G000519 | sen | PA | 1935-01-03 | 1941-01-03 | 1 | Democrat | |||||||||||||
23025 | 23025 | Vincent Harrington H000231 | rep | IA | 1939-01-03 | 1941-01-03 | Democrat | 9 | |||||||||||||
23030 | 23030 | Dow Harter H000294 | rep | OH | 1939-01-03 | 1941-01-03 | Democrat | 14 | |||||||||||||
23035 | 23035 | Arthur Healey H000423 | rep | MA | 1939-01-03 | 1941-01-03 | Democrat | 8 | |||||||||||||
23040 | 23040 | Knute Hill H000600 | rep | WA | 1939-01-03 | 1941-01-03 | Democrat | 4 | |||||||||||||
23046 | 23046 | John Houston H000824 | rep | KS | 1939-01-03 | 1941-01-03 | Democrat | 5 | |||||||||||||
23049 | 23049 | John Hunter H000983 | rep | OH | 1939-01-03 | 1941-01-03 | Democrat | 9 | |||||||||||||
23056 | 23056 | William Jacobsen J000039 | rep | IA | 1939-01-03 | 1941-01-03 | Democrat | 2 | |||||||||||||
23070 | 23070 | George Johnson J000132 | rep | WV | 1939-01-03 | 1941-01-03 | Democrat | 4 | |||||||||||||
23077 | 23077 | Michael Kennedy K000112 | rep | NY | 1939-01-03 | 1941-01-03 | Democrat | 15 | |||||||||||||
23086 | 23086 | Leo Kocialkowski K000303 | rep | IL | 1939-01-03 | 1941-01-03 | Democrat | 8 | |||||||||||||
23091 | 23091 | Charles Kramer K000321 | rep | CA | 1939-01-03 | 1941-01-03 | Democrat | 13 | |||||||||||||
23101 | 23101 | William Larrabee L000100 | rep | IN | 1939-01-03 | 1941-01-03 | Democrat | 11 |
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);