legislator_terms
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
492 rows where "end" is on date 1939-01-03
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
22938 | 22938 | Ross Collins C000642 | rep | MS | 1937-01-05 | 1939-01-03 | Democrat | 5 | |||||||||||||
22941 | 22941 | Lawrence Connery C000693 | rep | MA | 1937-01-05 | 1939-01-03 | Democrat | 7 | |||||||||||||
22954 | 22954 | Frank Crowther C000948 | rep | NY | 1937-01-05 | 1939-01-03 | Republican | 30 | |||||||||||||
22967 | 22967 | Wall Doxey D000480 | rep | MS | 1937-01-05 | 1939-01-03 | Democrat | 2 | |||||||||||||
22972 | 22972 | Richard Duncan D000536 | rep | MO | 1937-01-05 | 1939-01-03 | Democrat | 3 | |||||||||||||
22979 | 22979 | Andrew Edmiston E000051 | rep | WV | 1937-01-05 | 1939-01-03 | Democrat | 3 | |||||||||||||
22987 | 22987 | Charles Faddis F000001 | rep | PA | 1937-01-05 | 1939-01-03 | Democrat | 25 | |||||||||||||
22990 | 22990 | William Fitzgerald F000169 | rep | CT | 1937-01-05 | 1939-01-03 | Democrat | 2 | |||||||||||||
22992 | 22992 | Thomas Flaherty F000183 | rep | MA | 1937-01-05 | 1939-01-03 | Democrat | 11 | |||||||||||||
22995 | 22995 | John Flannery F000192 | rep | PA | 1937-01-05 | 1939-01-03 | Democrat | 12 | |||||||||||||
23001 | 23001 | Aaron Ford F000258 | rep | MS | 1937-01-05 | 1939-01-03 | Democrat | 4 | |||||||||||||
23007 | 23007 | Bernard Gehrmann G000118 | rep | WI | 1937-01-05 | 1939-01-03 | Progressive | 10 | |||||||||||||
23022 | 23022 | Harry Haines H000026 | rep | PA | 1937-01-05 | 1939-01-03 | Democrat | 22 | |||||||||||||
23024 | 23024 | Vincent Harrington H000231 | rep | IA | 1937-01-05 | 1939-01-03 | Democrat | 9 | |||||||||||||
23029 | 23029 | Dow Harter H000294 | rep | OH | 1937-01-05 | 1939-01-03 | Democrat | 14 | |||||||||||||
23034 | 23034 | Arthur Healey H000423 | rep | MA | 1937-01-05 | 1939-01-03 | Democrat | 8 | |||||||||||||
23039 | 23039 | Knute Hill H000600 | rep | WA | 1937-01-05 | 1939-01-03 | Democrat | 4 | |||||||||||||
23045 | 23045 | John Houston H000824 | rep | KS | 1937-01-05 | 1939-01-03 | Democrat | 5 | |||||||||||||
23048 | 23048 | John Hunter H000983 | rep | OH | 1937-01-05 | 1939-01-03 | Democrat | 9 | |||||||||||||
23053 | 23053 | Lawrence Imhoff I000010 | rep | OH | 1937-01-05 | 1939-01-03 | Democrat | 18 | |||||||||||||
23055 | 23055 | William Jacobsen J000039 | rep | IA | 1937-01-05 | 1939-01-03 | Democrat | 2 | |||||||||||||
23058 | 23058 | Benjamin Jarrett J000060 | rep | PA | 1937-01-05 | 1939-01-03 | Republican | 20 | |||||||||||||
23061 | 23061 | Arthur Jenks J000090 | rep | NH | 1937-01-05 | 1939-01-03 | Republican | 1 | |||||||||||||
23069 | 23069 | George Johnson J000132 | rep | WV | 1937-01-05 | 1939-01-03 | Democrat | 4 | |||||||||||||
23080 | 23080 | Samuel King K000214 | rep | HI | 1937-01-05 | 1939-01-03 | Republican | 0 | |||||||||||||
23085 | 23085 | Leo Kocialkowski K000303 | rep | IL | 1937-01-05 | 1939-01-03 | Democrat | 8 | |||||||||||||
23090 | 23090 | Charles Kramer K000321 | rep | CA | 1937-01-05 | 1939-01-03 | Democrat | 13 | |||||||||||||
23100 | 23100 | William Larrabee L000100 | rep | IN | 1937-01-05 | 1939-01-03 | Democrat | 11 | |||||||||||||
23103 | 23103 | Charles Leavy L000185 | rep | WA | 1937-01-05 | 1939-01-03 | Democrat | 5 | |||||||||||||
23114 | 23114 | Samuel Massingale M000231 | rep | OK | 1937-01-05 | 1939-01-03 | Democrat | 7 | |||||||||||||
23121 | 23121 | Raymond McKeough M000510 | rep | IL | 1937-01-05 | 1939-01-03 | Democrat | 2 | |||||||||||||
23125 | 23125 | Charles McLaughlin M000538 | rep | NE | 1937-01-05 | 1939-01-03 | Democrat | 2 | |||||||||||||
23140 | 23140 | Newt Mills M000775 | rep | LA | 1937-01-05 | 1939-01-03 | Democrat | 5 | |||||||||||||
23144 | 23144 | Arthur Mitchell M000805 | rep | IL | 1937-01-05 | 1939-01-03 | Democrat | 1 | |||||||||||||
23147 | 23147 | Guy Moser M001026 | rep | PA | 1937-01-05 | 1939-01-03 | Democrat | 14 | |||||||||||||
23152 | 23152 | Orrice Murdock M001082 | rep | UT | 1937-01-05 | 1939-01-03 | Democrat | 1 | |||||||||||||
23162 | 23162 | William Nelson N000046 | rep | MO | 1937-01-05 | 1939-01-03 | Democrat | 2 | |||||||||||||
23166 | 23166 | Caroline O’Day O000033 | rep | NY | 1937-01-05 | 1939-01-03 | Democrat | 0 | |||||||||||||
23172 | 23172 | Herron Pearson P000165 | rep | TN | 1937-01-05 | 1939-01-03 | Democrat | 7 | |||||||||||||
23178 | 23178 | Walter Pierce P000339 | rep | OR | 1937-01-05 | 1939-01-03 | Democrat | 2 | |||||||||||||
23186 | 23186 | Lewis Rockefeller R000362 | rep | NY | 1937-01-05 | 1939-01-03 | Republican | 27 | |||||||||||||
23191 | 23191 | Will Rogers R000405 | rep | OK | 1937-01-05 | 1939-01-03 | Democrat | 0 | |||||||||||||
23203 | 23203 | Milton Romjue R000418 | rep | MO | 1937-01-05 | 1939-01-03 | Democrat | 1 | |||||||||||||
23207 | 23207 | Albert Rutherford R000546 | rep | PA | 1937-01-05 | 1939-01-03 | Republican | 15 | |||||||||||||
23210 | 23210 | Leon Sacks S000008 | rep | PA | 1937-01-05 | 1939-01-03 | Democrat | 1 | |||||||||||||
23218 | 23218 | Edwin Schaefer S000110 | rep | IL | 1937-01-05 | 1939-01-03 | Democrat | 22 | |||||||||||||
23223 | 23223 | William Schulte S000145 | rep | IN | 1937-01-05 | 1939-01-03 | Democrat | 1 | |||||||||||||
23229 | 23229 | James Shanley S000285 | rep | CT | 1937-01-05 | 1939-01-03 | Democrat | 3 | |||||||||||||
23235 | 23235 | Joseph Shannon S000287 | rep | MO | 1937-01-05 | 1939-01-03 | Democrat | 5 | |||||||||||||
23245 | 23245 | John Smith S000572 | rep | CT | 1937-01-05 | 1939-01-03 | Democrat | 5 | |||||||||||||
23250 | 23250 | Martin Smith S000591 | rep | WA | 1937-01-05 | 1939-01-03 | Democrat | 3 | |||||||||||||
23254 | 23254 | Charles South S000683 | rep | TX | 1937-01-05 | 1939-01-03 | Democrat | 21 | |||||||||||||
23261 | 23261 | William Sutphin S001086 | rep | NJ | 1937-01-05 | 1939-01-03 | Democrat | 3 | |||||||||||||
23267 | 23267 | Martin Sweeney S001102 | rep | OH | 1937-01-05 | 1939-01-03 | Democrat | 20 | |||||||||||||
23284 | 23284 | Edward Taylor T000072 | rep | CO | 1937-01-05 | 1939-01-03 | Democrat | 4 | |||||||||||||
23291 | 23291 | David Terry T000133 | rep | AR | 1937-01-05 | 1939-01-03 | Democrat | 5 | |||||||||||||
23307 | 23307 | George Tinkham T000283 | rep | MA | 1937-01-05 | 1939-01-03 | Republican | 10 | |||||||||||||
23326 | 23326 | Clyde Williams W000494 | rep | MO | 1937-01-05 | 1939-01-03 | Democrat | 8 | |||||||||||||
23335 | 23335 | James Scrugham S000196 | rep | NV | 1937-01-05 | 1939-01-03 | Democrat | 0 | |||||||||||||
23368 | 23368 | Albert Carter C000195 | rep | CA | 1937-01-05 | 1939-01-03 | Republican | 6 | |||||||||||||
23376 | 23376 | John Costello C000795 | rep | CA | 1937-01-05 | 1939-01-03 | Democrat | 15 | |||||||||||||
23381 | 23381 | Edward Creal C000898 | rep | KY | 1937-01-05 | 1939-01-03 | Democrat | 4 | |||||||||||||
23390 | 23390 | Francis Culkin C000968 | rep | NY | 1937-01-05 | 1939-01-03 | Republican | 32 | |||||||||||||
23403 | 23403 | Thomas Cullen C000970 | rep | NY | 1937-01-05 | 1939-01-03 | Democrat | 4 | |||||||||||||
23414 | 23414 | Anthony Dimond D000353 | rep | AK | 1937-01-05 | 1939-01-03 | Democrat | 0 | |||||||||||||
23421 | 23421 | Wesley Disney D000362 | rep | OK | 1937-01-05 | 1939-01-03 | Democrat | 1 | |||||||||||||
23427 | 23427 | John Ditter D000363 | rep | PA | 1937-01-05 | 1939-01-03 | Republican | 17 | |||||||||||||
23431 | 23431 | Fred Douglas D000453 | rep | NY | 1937-01-05 | 1939-01-03 | Republican | 33 | |||||||||||||
23435 | 23435 | Joaquin Elizalde E000108 | rep | PI | 1937-01-05 | 1939-01-03 | 0 | ||||||||||||||
23447 | 23447 | Harry Englebright E000182 | rep | CA | 1937-01-05 | 1939-01-03 | Republican | 2 | |||||||||||||
23462 | 23462 | Hamilton Fish F000142 | rep | NY | 1937-01-05 | 1939-01-03 | Republican | 26 | |||||||||||||
23471 | 23471 | James Fitzpatrick F000175 | rep | NY | 1937-01-05 | 1939-01-03 | Democrat | 24 | |||||||||||||
23477 | 23477 | Thomas Ford F000267 | rep | CA | 1937-01-05 | 1939-01-03 | Democrat | 14 | |||||||||||||
23489 | 23489 | Hampton Fulmer F000417 | rep | SC | 1937-01-05 | 1939-01-03 | Democrat | 2 | |||||||||||||
23501 | 23501 | Joseph Gavagan G000101 | rep | NY | 1937-01-05 | 1939-01-03 | Democrat | 21 | |||||||||||||
23508 | 23508 | Fred Gilchrist G000181 | rep | IA | 1937-01-05 | 1939-01-03 | Republican | 8 | |||||||||||||
23532 | 23532 | Robert Green G000415 | rep | FL | 1937-01-05 | 1939-01-03 | Democrat | 2 | |||||||||||||
23542 | 23542 | Ulysses Guyer G000538 | rep | KS | 1937-01-05 | 1939-01-03 | Republican | 2 | |||||||||||||
23560 | 23560 | Martin Kennedy K000111 | rep | NY | 1937-01-05 | 1939-01-03 | Democrat | 18 | |||||||||||||
23567 | 23567 | Richard Kleberg K000257 | rep | TX | 1937-01-05 | 1939-01-03 | Democrat | 14 | |||||||||||||
23575 | 23575 | William Lambertson L000037 | rep | KS | 1937-01-05 | 1939-01-03 | Republican | 1 | |||||||||||||
23581 | 23581 | Lawrence Lewis L000291 | rep | CO | 1937-01-05 | 1939-01-03 | Democrat | 1 | |||||||||||||
23589 | 23589 | Melvin Maas M000001 | rep | MN | 1937-01-05 | 1939-01-03 | Republican | 4 | |||||||||||||
23594 | 23594 | James McGranery M000454 | rep | PA | 1937-01-05 | 1939-01-03 | Democrat | 2 | |||||||||||||
23600 | 23600 | Donald McLean M000545 | rep | NJ | 1937-01-05 | 1939-01-03 | Republican | 6 | |||||||||||||
23614 | 23614 | Matthew Merritt M000661 | rep | NY | 1937-01-05 | 1939-01-03 | Democrat | 0 | |||||||||||||
23629 | 23629 | John Nichols N000092 | rep | OK | 1937-01-05 | 1939-01-03 | Democrat | 2 | |||||||||||||
23639 | 23639 | James O’Leary O000065 | rep | NY | 1937-01-05 | 1939-01-03 | Democrat | 11 | |||||||||||||
23647 | 23647 | Nat Patton P000142 | rep | TX | 1937-01-05 | 1939-01-03 | Democrat | 7 | |||||||||||||
23659 | 23659 | Harry Sauthoff S000079 | rep | WI | 1937-01-05 | 1939-01-03 | Progressive | 2 | |||||||||||||
23669 | 23669 | Leonard Schuetz S000144 | rep | IL | 1937-01-05 | 1939-01-03 | Democrat | 7 | |||||||||||||
23677 | 23677 | Joseph Smith S000580 | rep | WV | 1937-01-05 | 1939-01-03 | Democrat | 6 | |||||||||||||
23683 | 23683 | Joe Starnes S000816 | rep | AL | 1937-01-05 | 1939-01-03 | Democrat | 5 | |||||||||||||
23698 | 23698 | Henry Steagall S000820 | rep | AL | 1937-01-05 | 1939-01-03 | Democrat | 3 | |||||||||||||
23723 | 23723 | Allen Treadway T000358 | rep | MA | 1937-01-05 | 1939-01-03 | Republican | 1 | |||||||||||||
23728 | 23728 | Beverly Vincent V000100 | rep | KY | 1937-01-05 | 1939-01-03 | Democrat | 2 | |||||||||||||
23736 | 23736 | Elmer Wene W000294 | rep | NJ | 1937-01-05 | 1939-01-03 | Democrat | 2 | |||||||||||||
23743 | 23743 | Benjamin Whelchel W000343 | rep | GA | 1937-01-05 | 1939-01-03 | Democrat | 9 | |||||||||||||
23771 | 23771 | William Barry B000191 | rep | NY | 1937-01-05 | 1939-01-03 | Democrat | 2 | |||||||||||||
23777 | 23777 | Lyle Boren B000640 | rep | OK | 1937-01-05 | 1939-01-03 | Democrat | 4 |
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);