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 fax
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
22896 | 22896 | Richard Buckler B001023 | rep | MN | 1939-01-03 | 1941-01-03 | Farmer-Labor | 9 | |||||||||||||
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 | |||||||||||||
22918 | 22918 | Ernest Cluett C000535 | rep | NY | 1939-01-03 | 1941-01-03 | Republican | 29 | |||||||||||||
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 | |||||||||||||
22955 | 22955 | Frank Crowther C000948 | rep | NY | 1939-01-03 | 1941-01-03 | Republican | 30 | |||||||||||||
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 | |||||||||||||
23004 | 23004 | Leland Ford F000264 | rep | CA | 1939-01-03 | 1941-01-03 | Republican | 16 | |||||||||||||
23008 | 23008 | Bernard Gehrmann G000118 | rep | WI | 1939-01-03 | 1941-01-03 | Progressive | 10 | |||||||||||||
23015 | 23015 | Lee Geyer G000147 | rep | CA | 1939-01-03 | 1941-01-03 | Democrat | 17 | |||||||||||||
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 | |||||||||||||
23059 | 23059 | Benjamin Jarrett J000060 | rep | PA | 1939-01-03 | 1941-01-03 | Republican | 20 | |||||||||||||
23062 | 23062 | Arthur Jenks J000090 | rep | NH | 1939-01-03 | 1941-01-03 | Republican | 1 | |||||||||||||
23064 | 23064 | Joshua Johns J000111 | rep | WI | 1939-01-03 | 1941-01-03 | Republican | 8 | |||||||||||||
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 | |||||||||||||
23081 | 23081 | Samuel King K000214 | rep | HI | 1939-01-03 | 1941-01-03 | Republican | 0 | |||||||||||||
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 | |||||||||||||
23104 | 23104 | Charles Leavy L000185 | rep | WA | 1939-01-03 | 1941-01-03 | Democrat | 5 | |||||||||||||
23107 | 23107 | Anton Maciejewski M000016 | rep | IL | 1939-01-03 | 1941-01-03 | Democrat | 6 | |||||||||||||
23115 | 23115 | Samuel Massingale M000231 | rep | OK | 1939-01-03 | 1941-01-03 | Democrat | 7 | |||||||||||||
23117 | 23117 | Joseph McArdle M000297 | rep | PA | 1939-01-03 | 1941-01-03 | Democrat | 33 | |||||||||||||
23122 | 23122 | Raymond McKeough M000510 | rep | IL | 1939-01-03 | 1941-01-03 | Democrat | 2 | |||||||||||||
23126 | 23126 | Charles McLaughlin M000538 | rep | NE | 1939-01-03 | 1941-01-03 | Democrat | 2 | |||||||||||||
23141 | 23141 | Newt Mills M000775 | rep | LA | 1939-01-03 | 1941-01-03 | Democrat | 5 | |||||||||||||
23145 | 23145 | Arthur Mitchell M000805 | rep | IL | 1939-01-03 | 1941-01-03 | Democrat | 1 | |||||||||||||
23148 | 23148 | Guy Moser M001026 | rep | PA | 1939-01-03 | 1941-01-03 | Democrat | 14 | |||||||||||||
23153 | 23153 | Orrice Murdock M001082 | rep | UT | 1939-01-03 | 1941-01-03 | Democrat | 1 | |||||||||||||
23163 | 23163 | William Nelson N000046 | rep | MO | 1939-01-03 | 1941-01-03 | Democrat | 2 | |||||||||||||
23167 | 23167 | Caroline O’Day O000033 | rep | NY | 1939-01-03 | 1941-01-03 | Democrat | 0 | |||||||||||||
23173 | 23173 | Herron Pearson P000165 | rep | TN | 1939-01-03 | 1941-01-03 | Democrat | 7 | |||||||||||||
23179 | 23179 | Walter Pierce P000339 | rep | OR | 1939-01-03 | 1941-01-03 | Democrat | 2 | |||||||||||||
23187 | 23187 | Lewis Rockefeller R000362 | rep | NY | 1939-01-03 | 1941-01-03 | Republican | 27 | |||||||||||||
23192 | 23192 | Will Rogers R000405 | rep | OK | 1939-01-03 | 1941-01-03 | Democrat | 0 | |||||||||||||
23204 | 23204 | Milton Romjue R000418 | rep | MO | 1939-01-03 | 1941-01-03 | Democrat | 1 | |||||||||||||
23208 | 23208 | Albert Rutherford R000546 | rep | PA | 1939-01-03 | 1941-01-03 | Republican | 15 | |||||||||||||
23211 | 23211 | Leon Sacks S000008 | rep | PA | 1939-01-03 | 1941-01-03 | Democrat | 1 | |||||||||||||
23219 | 23219 | Edwin Schaefer S000110 | rep | IL | 1939-01-03 | 1941-01-03 | Democrat | 22 | |||||||||||||
23224 | 23224 | William Schulte S000145 | rep | IN | 1939-01-03 | 1941-01-03 | Democrat | 1 | |||||||||||||
23226 | 23226 | Pius Schwert S000162 | rep | NY | 1939-01-03 | 1941-01-03 | Democrat | 42 | |||||||||||||
23230 | 23230 | James Shanley S000285 | rep | CT | 1939-01-03 | 1941-01-03 | Democrat | 3 | |||||||||||||
23236 | 23236 | Joseph Shannon S000287 | rep | MO | 1939-01-03 | 1941-01-03 | Democrat | 5 | |||||||||||||
23246 | 23246 | John Smith S000572 | rep | CT | 1939-01-03 | 1941-01-03 | Democrat | 5 | |||||||||||||
23251 | 23251 | Martin Smith S000591 | rep | WA | 1939-01-03 | 1941-01-03 | Democrat | 3 | |||||||||||||
23255 | 23255 | Charles South S000683 | rep | TX | 1939-01-03 | 1941-01-03 | Democrat | 21 | |||||||||||||
23262 | 23262 | William Sutphin S001086 | rep | NJ | 1939-01-03 | 1941-01-03 | Democrat | 3 | |||||||||||||
23268 | 23268 | Martin Sweeney S001102 | rep | OH | 1939-01-03 | 1941-01-03 | Democrat | 20 | |||||||||||||
23285 | 23285 | Edward Taylor T000072 | rep | CO | 1939-01-03 | 1941-01-03 | Democrat | 4 | |||||||||||||
23287 | 23287 | Rudolph Tenerowicz T000124 | rep | MI | 1939-01-03 | 1941-01-03 | Democrat | 1 | |||||||||||||
23292 | 23292 | David Terry T000133 | rep | AR | 1939-01-03 | 1941-01-03 | Democrat | 5 | |||||||||||||
23294 | 23294 | Lewis Thill T000153 | rep | WI | 1939-01-03 | 1941-01-03 | Republican | 5 | |||||||||||||
23308 | 23308 | George Tinkham T000283 | rep | MA | 1939-01-03 | 1941-01-03 | Republican | 10 | |||||||||||||
23311 | 23311 | Albert Vreeland V000121 | rep | NJ | 1939-01-03 | 1941-01-03 | Republican | 11 | |||||||||||||
23327 | 23327 | Clyde Williams W000494 | rep | MO | 1939-01-03 | 1941-01-03 | Democrat | 8 | |||||||||||||
23330 | 23330 | Oscar Youngdahl Y000059 | rep | MN | 1939-01-03 | 1941-01-03 | Republican | 5 | |||||||||||||
23336 | 23336 | James Scrugham S000196 | rep | NV | 1939-01-03 | 1941-01-03 | Democrat | 0 | |||||||||||||
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 | |||||||||||||
23382 | 23382 | Edward Creal C000898 | rep | KY | 1939-01-03 | 1941-01-03 | Democrat | 4 | |||||||||||||
23391 | 23391 | Francis Culkin C000968 | rep | NY | 1939-01-03 | 1941-01-03 | Republican | 32 | |||||||||||||
23404 | 23404 | Thomas Cullen C000970 | rep | NY | 1939-01-03 | 1941-01-03 | Democrat | 4 | |||||||||||||
23415 | 23415 | Anthony Dimond D000353 | rep | AK | 1939-01-03 | 1941-01-03 | Democrat | 0 | |||||||||||||
23422 | 23422 | Wesley Disney D000362 | rep | OK | 1939-01-03 | 1941-01-03 | Democrat | 1 | |||||||||||||
23428 | 23428 | John Ditter D000363 | rep | PA | 1939-01-03 | 1941-01-03 | Republican | 17 | |||||||||||||
23432 | 23432 | Fred Douglas D000453 | rep | NY | 1939-01-03 | 1941-01-03 | Republican | 33 | |||||||||||||
23436 | 23436 | Joaquin Elizalde E000108 | rep | PI | 1939-01-03 | 1941-01-03 | 0 | ||||||||||||||
23448 | 23448 | Harry Englebright E000182 | rep | CA | 1939-01-03 | 1941-01-03 | Republican | 2 | |||||||||||||
23451 | 23451 | James Fay F000051 | rep | NY | 1939-01-03 | 1941-01-03 | Democrat | 16 | |||||||||||||
23463 | 23463 | Hamilton Fish F000142 | rep | NY | 1939-01-03 | 1941-01-03 | Republican | 26 | |||||||||||||
23472 | 23472 | James Fitzpatrick F000175 | rep | NY | 1939-01-03 | 1941-01-03 | Democrat | 24 | |||||||||||||
23478 | 23478 | Thomas Ford F000267 | rep | CA | 1939-01-03 | 1941-01-03 | Democrat | 14 | |||||||||||||
23490 | 23490 | Hampton Fulmer F000417 | rep | SC | 1939-01-03 | 1941-01-03 | Democrat | 2 | |||||||||||||
23502 | 23502 | Joseph Gavagan G000101 | rep | NY | 1939-01-03 | 1941-01-03 | Democrat | 21 | |||||||||||||
23509 | 23509 | Fred Gilchrist G000181 | rep | IA | 1939-01-03 | 1941-01-03 | Republican | 8 | |||||||||||||
23533 | 23533 | Robert Green G000415 | rep | FL | 1939-01-03 | 1941-01-03 | Democrat | 2 | |||||||||||||
23543 | 23543 | Ulysses Guyer G000538 | rep | KS | 1939-01-03 | 1941-01-03 | Republican | 2 | |||||||||||||
23561 | 23561 | Martin Kennedy K000111 | rep | NY | 1939-01-03 | 1941-01-03 | Democrat | 18 |
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);