legislator_terms
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
495 rows where "start" is on date 1939-01-03 sorted by state descending
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
22631 | 22631 | Frank Horton H000798 | rep | WY | 1939-01-03 | 1941-01-03 | Republican | 0 | |||||||||||||
22980 | 22980 | Andrew Edmiston E000051 | rep | WV | 1939-01-03 | 1941-01-03 | Democrat | 3 | |||||||||||||
23070 | 23070 | George Johnson J000132 | rep | WV | 1939-01-03 | 1941-01-03 | Democrat | 4 | |||||||||||||
23664 | 23664 | Andrew Schiffler S000126 | rep | WV | 1939-01-03 | 1941-01-03 | Republican | 1 | |||||||||||||
23678 | 23678 | Joseph Smith S000580 | rep | WV | 1939-01-03 | 1941-01-03 | Democrat | 6 | |||||||||||||
25341 | 25341 | John Kee K000039 | rep | WV | 1939-01-03 | 1941-01-03 | Democrat | 5 | |||||||||||||
32244 | 32244 | Jennings Randolph R000046 | rep | WV | 1939-01-03 | 1941-01-03 | Democrat | 2 | |||||||||||||
22626 | 22626 | Harry Griswold G000484 | rep | WI | 1939-01-03 | 1941-01-03 | Republican | 3 | |||||||||||||
22628 | 22628 | Charles Hawks H000375 | rep | WI | 1939-01-03 | 1941-01-03 | Republican | 2 | |||||||||||||
22764 | 22764 | John Schafer S000111 | rep | WI | 1939-01-03 | 1941-01-03 | Republican | 4 | |||||||||||||
22887 | 22887 | Stephen Bolles B000604 | rep | WI | 1939-01-03 | 1941-01-03 | Republican | 1 | |||||||||||||
23008 | 23008 | Bernard Gehrmann G000118 | rep | WI | 1939-01-03 | 1941-01-03 | Progressive | 10 | |||||||||||||
23064 | 23064 | Joshua Johns J000111 | rep | WI | 1939-01-03 | 1941-01-03 | Republican | 8 | |||||||||||||
23294 | 23294 | Lewis Thill T000153 | rep | WI | 1939-01-03 | 1941-01-03 | Republican | 5 | |||||||||||||
24869 | 24869 | Frank Keefe K000041 | rep | WI | 1939-01-03 | 1941-01-03 | Republican | 6 | |||||||||||||
25404 | 25404 | Reid Murray M001112 | rep | WI | 1939-01-03 | 1941-01-03 | Republican | 7 | |||||||||||||
25716 | 25716 | Merlin Hull H000943 | rep | WI | 1939-01-03 | 1941-01-03 | Progressive | 9 | |||||||||||||
26667 | 26667 | Alexander Wiley W000465 | sen | WI | 1939-01-03 | 1945-01-03 | 3 | Republican | |||||||||||||
22508 | 22508 | Homer Bone B000614 | sen | WA | 1939-01-03 | 1944-11-13 | 3 | Democrat | |||||||||||||
23040 | 23040 | Knute Hill H000600 | rep | WA | 1939-01-03 | 1941-01-03 | Democrat | 4 | |||||||||||||
23104 | 23104 | Charles Leavy L000185 | rep | WA | 1939-01-03 | 1941-01-03 | Democrat | 5 | |||||||||||||
23251 | 23251 | Martin Smith S000591 | rep | WA | 1939-01-03 | 1941-01-03 | Democrat | 3 | |||||||||||||
23815 | 23815 | John Coffee C000584 | rep | WA | 1939-01-03 | 1941-01-03 | Democrat | 6 | |||||||||||||
31161 | 31161 | Warren Magnuson M000053 | rep | WA | 1939-01-03 | 1941-01-03 | Democrat | 1 | |||||||||||||
22612 | 22612 | Ernest Gibson G000158 | sen | VT | 1939-01-03 | 1941-01-03 | 3 | Republican | |||||||||||||
24995 | 24995 | Charles Plumley P000395 | rep | VT | 1939-01-03 | 1941-01-03 | Republican | 0 | |||||||||||||
22959 | 22959 | Colgate Darden D000050 | rep | VA | 1939-01-03 | 1941-01-03 | Democrat | 2 | |||||||||||||
24086 | 24086 | Dave Satterfield S000069 | rep | VA | 1939-01-03 | 1941-01-03 | Democrat | 3 | |||||||||||||
24225 | 24225 | Clifton Woodrum W000720 | rep | VA | 1939-01-03 | 1941-01-03 | Democrat | 6 | |||||||||||||
24237 | 24237 | Thomas Burch B001069 | rep | VA | 1939-01-03 | 1941-01-03 | Democrat | 5 | |||||||||||||
24364 | 24364 | Patrick Drewry D000496 | rep | VA | 1939-01-03 | 1941-01-03 | Democrat | 4 | |||||||||||||
24385 | 24385 | John Flannagan F000191 | rep | VA | 1939-01-03 | 1941-01-03 | Democrat | 9 | |||||||||||||
24753 | 24753 | Schuyler Bland B000545 | rep | VA | 1939-01-03 | 1941-01-03 | Democrat | 1 | |||||||||||||
27490 | 27490 | Absalom Robertson R000317 | rep | VA | 1939-01-03 | 1941-01-03 | Democrat | 7 | |||||||||||||
28661 | 28661 | Howard Smith S000554 | rep | VA | 1939-01-03 | 1941-01-03 | Democrat | 8 | |||||||||||||
23153 | 23153 | Orrice Murdock M001082 | rep | UT | 1939-01-03 | 1941-01-03 | Democrat | 1 | |||||||||||||
24066 | 24066 | James Robinson R000341 | rep | UT | 1939-01-03 | 1941-01-03 | Democrat | 2 | |||||||||||||
24150 | 24150 | Elbert Thomas T000164 | sen | UT | 1939-01-03 | 1945-01-03 | 3 | Democrat | |||||||||||||
22602 | 22602 | Clyde Garrett G000080 | rep | TX | 1939-01-03 | 1941-01-03 | Democrat | 17 | |||||||||||||
22648 | 22648 | John Jones J000236 | rep | TX | 1939-01-03 | 1941-01-03 | Democrat | 18 | |||||||||||||
23255 | 23255 | Charles South S000683 | rep | TX | 1939-01-03 | 1941-01-03 | Democrat | 21 | |||||||||||||
23568 | 23568 | Richard Kleberg K000257 | rep | TX | 1939-01-03 | 1941-01-03 | Democrat | 14 | |||||||||||||
23648 | 23648 | Nat Patton P000142 | rep | TX | 1939-01-03 | 1941-01-03 | Democrat | 7 | |||||||||||||
23919 | 23919 | Luther Johnson J000159 | rep | TX | 1939-01-03 | 1941-01-03 | Democrat | 6 | |||||||||||||
23956 | 23956 | Fritz Lanham L000076 | rep | TX | 1939-01-03 | 1941-01-03 | Democrat | 12 | |||||||||||||
24126 | 24126 | Hatton Sumners S001072 | rep | TX | 1939-01-03 | 1941-01-03 | Democrat | 5 | |||||||||||||
24588 | 24588 | Joseph Mansfield M000112 | rep | TX | 1939-01-03 | 1941-01-03 | Democrat | 9 | |||||||||||||
24696 | 24696 | Robert Thomason T000189 | rep | TX | 1939-01-03 | 1941-01-03 | Democrat | 16 | |||||||||||||
24715 | 24715 | Milton West W000304 | rep | TX | 1939-01-03 | 1941-01-03 | Democrat | 15 | |||||||||||||
25278 | 25278 | Ed Gossett G000338 | rep | TX | 1939-01-03 | 1941-01-03 | Democrat | 13 | |||||||||||||
26304 | 26304 | Martin Dies D000338 | rep | TX | 1939-01-03 | 1941-01-03 | Democrat | 2 | |||||||||||||
27287 | 27287 | Paul Kilday K000171 | rep | TX | 1939-01-03 | 1941-01-03 | Democrat | 20 | |||||||||||||
27447 | 27447 | Samuel Rayburn R000082 | rep | TX | 1939-01-03 | 1941-01-03 | Democrat | 4 | |||||||||||||
28295 | 28295 | Lyndon Johnson J000160 | rep | TX | 1939-01-03 | 1941-01-03 | Democrat | 10 | |||||||||||||
28317 | 28317 | Lindley Beckworth B000296 | rep | TX | 1939-01-03 | 1941-01-03 | Democrat | 3 | |||||||||||||
28678 | 28678 | Albert Thomas T000156 | rep | TX | 1939-01-03 | 1941-01-03 | Democrat | 8 | |||||||||||||
31257 | 31257 | John Patman P000103 | rep | TX | 1939-01-03 | 1941-01-03 | Democrat | 1 | |||||||||||||
31623 | 31623 | George Mahon M000065 | rep | TX | 1939-01-03 | 1941-01-03 | Democrat | 19 | |||||||||||||
31719 | 31719 | William Poage P000398 | rep | TX | 1939-01-03 | 1941-01-03 | Democrat | 11 | |||||||||||||
22510 | 22510 | Joseph Byrns B001218 | rep | TN | 1939-01-03 | 1941-01-03 | Democrat | 5 | |||||||||||||
22520 | 22520 | Walter Chandler C000296 | rep | TN | 1939-01-03 | 1941-01-03 | Democrat | 9 | |||||||||||||
22731 | 22731 | Samuel McReynolds M000598 | rep | TN | 1939-01-03 | 1941-01-03 | Democrat | 3 | |||||||||||||
22815 | 22815 | James Taylor T000083 | rep | TN | 1939-01-03 | 1941-01-03 | Republican | 2 | |||||||||||||
22821 | 22821 | Clarence Turner T000417 | rep | TN | 1939-01-03 | 1941-01-03 | Democrat | 6 | |||||||||||||
23173 | 23173 | Herron Pearson P000165 | rep | TN | 1939-01-03 | 1941-01-03 | Democrat | 7 | |||||||||||||
23705 | 23705 | Arthur Stewart S000901 | sen | TN | 1939-01-03 | 1943-01-03 | 2 | Democrat | |||||||||||||
24323 | 24323 | William Courtney C000810 | rep | TN | 1939-01-03 | 1941-01-03 | Democrat | 6 | |||||||||||||
24859 | 24859 | John Jennings J000096 | rep | TN | 1939-01-03 | 1941-01-03 | Republican | 2 | |||||||||||||
26255 | 26255 | Jere Cooper C000755 | rep | TN | 1939-01-03 | 1941-01-03 | Democrat | 8 | |||||||||||||
27276 | 27276 | Carey Kefauver K000044 | rep | TN | 1939-01-03 | 1941-01-03 | Democrat | 3 | |||||||||||||
27467 | 27467 | Brazilla Reece R000108 | rep | TN | 1939-01-03 | 1941-01-03 | Republican | 1 | |||||||||||||
27723 | 27723 | Clifford Davis D000094 | rep | TN | 1939-01-03 | 1941-01-03 | Democrat | 9 | |||||||||||||
28425 | 28425 | Albert Gore G000320 | rep | TN | 1939-01-03 | 1941-01-03 | Democrat | 4 | |||||||||||||
23853 | 23853 | John Gurney G000532 | sen | SD | 1939-01-03 | 1945-01-03 | 3 | Republican | |||||||||||||
26215 | 26215 | Francis Case C000221 | rep | SD | 1939-01-03 | 1941-01-03 | Republican | 2 | |||||||||||||
28988 | 28988 | Karl Mundt M001078 | rep | SD | 1939-01-03 | 1941-01-03 | Republican | 1 | |||||||||||||
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 | |||||||||||||
22790 | 22790 | Ellison Smith S000530 | sen | SC | 1939-01-03 | 1945-01-03 | 3 | Democrat | |||||||||||||
23490 | 23490 | Hampton Fulmer F000417 | rep | SC | 1939-01-03 | 1941-01-03 | Democrat | 2 | |||||||||||||
23869 | 23869 | Butler Hare H000200 | rep | SC | 1939-01-03 | 1941-01-03 | Democrat | 3 | |||||||||||||
25608 | 25608 | Joseph Bryson B000999 | rep | SC | 1939-01-03 | 1941-01-03 | Democrat | 4 | |||||||||||||
26107 | 26107 | James Richards R000214 | rep | SC | 1939-01-03 | 1941-01-03 | Democrat | 5 | |||||||||||||
29931 | 29931 | John McMillan M000568 | rep | SC | 1939-01-03 | 1941-01-03 | Democrat | 6 | |||||||||||||
22753 | 22753 | Charles Risk R000269 | rep | RI | 1939-01-03 | 1941-01-03 | Republican | 1 | |||||||||||||
22758 | 22758 | Harry Sandager S000031 | rep | RI | 1939-01-03 | 1941-01-03 | Republican | 2 | |||||||||||||
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 | |||||||||||||
23436 | 23436 | Joaquin Elizalde E000108 | rep | PI | 1939-01-03 | 1941-01-03 | 0 | ||||||||||||||
22473 | 22473 | Robert Allen A000145 | rep | PA | 1939-01-03 | 1941-01-03 | Democrat | 28 | |||||||||||||
22547 | 22547 | John Daly D000014 | rep | PA | 1939-01-03 | 1941-01-03 | Democrat | 4 | |||||||||||||
22560 | 22560 | George Darrow D000063 | rep | PA | 1939-01-03 | 1941-01-03 | Republican | 7 | |||||||||||||
22563 | 22563 | James Davis D000111 | sen | PA | 1939-01-03 | 1945-01-03 | 3 | Republican | |||||||||||||
22586 | 22586 | Matthew Dunn D000551 | rep | PA | 1939-01-03 | 1941-01-03 | Democrat | 34 | |||||||||||||
22603 | 22603 | Fred Gartner G000087 | rep | PA | 1939-01-03 | 1941-01-03 | Republican | 5 | |||||||||||||
22884 | 22884 | Patrick Boland B000601 | rep | PA | 1939-01-03 | 1941-01-03 | Democrat | 11 | |||||||||||||
22988 | 22988 | Charles Faddis F000001 | rep | PA | 1939-01-03 | 1941-01-03 | Democrat | 25 | |||||||||||||
22996 | 22996 | John Flannery F000192 | rep | PA | 1939-01-03 | 1941-01-03 | Democrat | 12 | |||||||||||||
23059 | 23059 | Benjamin Jarrett J000060 | rep | PA | 1939-01-03 | 1941-01-03 | Republican | 20 | |||||||||||||
23117 | 23117 | Joseph McArdle M000297 | rep | PA | 1939-01-03 | 1941-01-03 | Democrat | 33 |
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);