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 sorted by state
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
23085 | 23085 | Leo Kocialkowski K000303 | rep | IL | 1937-01-05 | 1939-01-03 | Democrat | 8 | |||||||||||||
23121 | 23121 | Raymond McKeough M000510 | rep | IL | 1937-01-05 | 1939-01-03 | Democrat | 2 | |||||||||||||
23144 | 23144 | Arthur Mitchell M000805 | rep | IL | 1937-01-05 | 1939-01-03 | Democrat | 1 | |||||||||||||
23218 | 23218 | Edwin Schaefer S000110 | rep | IL | 1937-01-05 | 1939-01-03 | Democrat | 22 | |||||||||||||
23669 | 23669 | Leonard Schuetz S000144 | rep | IL | 1937-01-05 | 1939-01-03 | Democrat | 7 | |||||||||||||
23926 | 23926 | Edward Kelly K000071 | rep | IL | 1937-01-05 | 1939-01-03 | Democrat | 3 | |||||||||||||
23962 | 23962 | Scott Lucas L000493 | rep | IL | 1937-01-05 | 1939-01-03 | Democrat | 20 | |||||||||||||
24805 | 24805 | Ralph Church C000390 | rep | IL | 1937-01-05 | 1939-01-03 | Republican | 10 | |||||||||||||
25469 | 25469 | Adolph Sabath S000001 | rep | IL | 1937-01-05 | 1939-01-03 | Democrat | 5 | |||||||||||||
26094 | 26094 | Chauncey Reed R000111 | rep | IL | 1937-01-05 | 1939-01-03 | Republican | 11 | |||||||||||||
26694 | 26694 | Leo Allen A000138 | rep | IL | 1937-01-05 | 1939-01-03 | Republican | 13 | |||||||||||||
27343 | 27343 | Noah Mason M000224 | rep | IL | 1937-01-05 | 1939-01-03 | Republican | 12 | |||||||||||||
27744 | 27744 | Everett Dirksen D000360 | rep | IL | 1937-01-05 | 1939-01-03 | Republican | 16 | |||||||||||||
28055 | 28055 | Thomas O’Brien O000016 | rep | IL | 1937-01-05 | 1939-01-03 | Democrat | 6 | |||||||||||||
30139 | 30139 | Leslie Arends A000216 | rep | IL | 1937-01-05 | 1939-01-03 | Republican | 17 | |||||||||||||
22136 | 22136 | James Farley F000019 | rep | IN | 1937-01-05 | 1939-01-03 | Democrat | 4 | |||||||||||||
22191 | 22191 | Finly Gray G000395 | rep | IN | 1937-01-05 | 1939-01-03 | Democrat | 10 | |||||||||||||
22201 | 22201 | Arthur Greenwood G000437 | rep | IN | 1937-01-05 | 1939-01-03 | Democrat | 7 | |||||||||||||
22207 | 22207 | Glenn Griswold G000483 | rep | IN | 1937-01-05 | 1939-01-03 | Democrat | 5 | |||||||||||||
22238 | 22238 | Virginia Jenckes J000077 | rep | IN | 1937-01-05 | 1939-01-03 | Democrat | 6 | |||||||||||||
22369 | 22369 | Samuel Pettengill P000268 | rep | IN | 1937-01-05 | 1939-01-03 | Democrat | 3 | |||||||||||||
22536 | 22536 | Eugene Crowe C000940 | rep | IN | 1937-01-05 | 1939-01-03 | Democrat | 9 | |||||||||||||
22822 | 22822 | Frederick Van Nuys V000050 | sen | IN | 1933-03-09 | 1939-01-03 | 3 | Democrat | |||||||||||||
22877 | 22877 | John Boehne B000588 | rep | IN | 1937-01-05 | 1939-01-03 | Democrat | 8 | |||||||||||||
23100 | 23100 | William Larrabee L000100 | rep | IN | 1937-01-05 | 1939-01-03 | Democrat | 11 | |||||||||||||
23223 | 23223 | William Schulte S000145 | rep | IN | 1937-01-05 | 1939-01-03 | Democrat | 1 | |||||||||||||
24564 | 24564 | Louis Ludlow L000501 | rep | IN | 1937-01-05 | 1939-01-03 | Democrat | 12 | |||||||||||||
28861 | 28861 | Charles Halleck H000081 | rep | IN | 1937-01-05 | 1939-01-03 | Republican | 2 | |||||||||||||
21420 | 21420 | George McGill M000447 | sen | KS | 1933-03-09 | 1939-01-03 | 3 | Democrat | |||||||||||||
22365 | 22365 | Edward Patterson P000111 | rep | KS | 1937-01-05 | 1939-01-03 | Democrat | 3 | |||||||||||||
23045 | 23045 | John Houston H000824 | rep | KS | 1937-01-05 | 1939-01-03 | Democrat | 5 | |||||||||||||
23542 | 23542 | Ulysses Guyer G000538 | rep | KS | 1937-01-05 | 1939-01-03 | Republican | 2 | |||||||||||||
23575 | 23575 | William Lambertson L000037 | rep | KS | 1937-01-05 | 1939-01-03 | Republican | 1 | |||||||||||||
26012 | 26012 | Clifford Hope H000768 | rep | KS | 1937-01-05 | 1939-01-03 | Republican | 7 | |||||||||||||
26971 | 26971 | Edward Rees R000132 | rep | KS | 1937-01-05 | 1939-01-03 | Republican | 4 | |||||||||||||
27701 | 27701 | Frank Carlson C000154 | rep | KS | 1937-01-05 | 1939-01-03 | Republican | 6 | |||||||||||||
22456 | 22456 | Frederick Vinson V000106 | rep | KY | 1937-01-05 | 1939-01-03 | Democrat | 8 | |||||||||||||
23381 | 23381 | Edward Creal C000898 | rep | KY | 1937-01-05 | 1939-01-03 | Democrat | 4 | |||||||||||||
23728 | 23728 | Beverly Vincent V000100 | rep | KY | 1937-01-05 | 1939-01-03 | Democrat | 2 | |||||||||||||
23978 | 23978 | Andrew May M000272 | rep | KY | 1937-01-05 | 1939-01-03 | Democrat | 7 | |||||||||||||
24012 | 24012 | Emmet O’Neal O000089 | rep | KY | 1937-01-05 | 1939-01-03 | Democrat | 3 | |||||||||||||
24658 | 24658 | John Robsion R000358 | rep | KY | 1937-01-05 | 1939-01-03 | Republican | 9 | |||||||||||||
24796 | 24796 | Virgil Chapman C000317 | rep | KY | 1937-01-05 | 1939-01-03 | Democrat | 6 | |||||||||||||
25130 | 25130 | Joseph Bates B000237 | rep | KY | 1937-01-05 | 1939-01-03 | Democrat | 8 | |||||||||||||
25875 | 25875 | Alben Barkley B000145 | sen | KY | 1933-03-09 | 1939-01-03 | 3 | Democrat | |||||||||||||
26334 | 26334 | Noble Gregory G000447 | rep | KY | 1937-01-05 | 1939-01-03 | Democrat | 1 | |||||||||||||
27536 | 27536 | Brent Spence S000717 | rep | KY | 1937-01-05 | 1939-01-03 | Democrat | 5 | |||||||||||||
22569 | 22569 | René De Rouen D000265 | rep | LA | 1937-01-05 | 1939-01-03 | Democrat | 7 | |||||||||||||
22597 | 22597 | Joachim Fernández F000086 | rep | LA | 1937-01-05 | 1939-01-03 | Democrat | 1 | |||||||||||||
22624 | 22624 | John Griffith G000469 | rep | LA | 1937-01-05 | 1939-01-03 | Democrat | 6 | |||||||||||||
22732 | 22732 | Robert Mouton M001051 | rep | LA | 1937-01-05 | 1939-01-03 | Democrat | 3 | |||||||||||||
23140 | 23140 | Newt Mills M000775 | rep | LA | 1937-01-05 | 1939-01-03 | Democrat | 5 | |||||||||||||
23970 | 23970 | Paul Maloney M000091 | rep | LA | 1937-01-05 | 1939-01-03 | Democrat | 2 | |||||||||||||
24020 | 24020 | John Overton O000146 | sen | LA | 1933-03-09 | 1939-01-03 | 3 | Democrat | |||||||||||||
25112 | 25112 | Asa Allen A000114 | rep | LA | 1937-01-05 | 1939-01-03 | Democrat | 8 | |||||||||||||
27127 | 27127 | Overton Brooks B000884 | rep | LA | 1937-01-05 | 1939-01-03 | Democrat | 4 | |||||||||||||
22102 | 22102 | William Connery C000694 | rep | MA | 1937-01-05 | 1939-01-03 | Democrat | 7 | |||||||||||||
22228 | 22228 | John Higgins H000579 | rep | MA | 1937-01-05 | 1939-01-03 | Democrat | 11 | |||||||||||||
22672 | 22672 | Robert Luce L000498 | rep | MA | 1937-01-05 | 1939-01-03 | Republican | 9 | |||||||||||||
22911 | 22911 | Joseph Casey C000225 | rep | MA | 1937-01-05 | 1939-01-03 | Democrat | 3 | |||||||||||||
22941 | 22941 | Lawrence Connery C000693 | rep | MA | 1937-01-05 | 1939-01-03 | Democrat | 7 | |||||||||||||
22992 | 22992 | Thomas Flaherty F000183 | rep | MA | 1937-01-05 | 1939-01-03 | Democrat | 11 | |||||||||||||
23034 | 23034 | Arthur Healey H000423 | rep | MA | 1937-01-05 | 1939-01-03 | Democrat | 8 | |||||||||||||
23307 | 23307 | George Tinkham T000283 | rep | MA | 1937-01-05 | 1939-01-03 | Republican | 10 | |||||||||||||
23723 | 23723 | Allen Treadway T000358 | rep | MA | 1937-01-05 | 1939-01-03 | Republican | 1 | |||||||||||||
23885 | 23885 | Pehr Holmes H000741 | rep | MA | 1937-01-05 | 1939-01-03 | Republican | 4 | |||||||||||||
24304 | 24304 | Charles Clason C000473 | rep | MA | 1937-01-05 | 1939-01-03 | Republican | 2 | |||||||||||||
24421 | 24421 | Charles Gifford G000169 | rep | MA | 1937-01-05 | 1939-01-03 | Republican | 15 | |||||||||||||
24732 | 24732 | George Bates B000232 | rep | MA | 1937-01-05 | 1939-01-03 | Republican | 6 | |||||||||||||
26656 | 26656 | Richard Wigglesworth W000450 | rep | MA | 1937-01-05 | 1939-01-03 | Republican | 13 | |||||||||||||
26989 | 26989 | Edith Rogers R000392 | rep | MA | 1937-01-05 | 1939-01-03 | Republican | 5 | |||||||||||||
28535 | 28535 | Joseph Martin M000191 | rep | MA | 1937-01-05 | 1939-01-03 | Republican | 14 | |||||||||||||
29369 | 29369 | John McCormack M000364 | rep | MA | 1937-01-05 | 1939-01-03 | Democrat | 12 | |||||||||||||
22168 | 22168 | Stephen Gambrill G000035 | rep | MD | 1937-01-05 | 1939-01-03 | Democrat | 5 | |||||||||||||
22274 | 22274 | David Lewis L000277 | rep | MD | 1937-01-05 | 1939-01-03 | Democrat | 6 | |||||||||||||
22361 | 22361 | Vincent Palmisano P000046 | rep | MD | 1937-01-05 | 1939-01-03 | Democrat | 3 | |||||||||||||
22621 | 22621 | Thomas Goldsborough G000265 | rep | MD | 1937-01-05 | 1939-01-03 | Democrat | 1 | |||||||||||||
22657 | 22657 | Ambrose Kennedy K000101 | rep | MD | 1937-01-05 | 1939-01-03 | Democrat | 4 | |||||||||||||
22928 | 22928 | William Cole C000616 | rep | MD | 1937-01-05 | 1939-01-03 | Democrat | 2 | |||||||||||||
24171 | 24171 | Millard Tydings T000446 | sen | MD | 1933-03-09 | 1939-01-03 | 3 | Democrat | |||||||||||||
22783 | 22783 | Clyde Smith S000523 | rep | ME | 1937-01-05 | 1939-01-03 | Republican | 2 | |||||||||||||
24282 | 24282 | Ralph Brewster B000816 | rep | ME | 1937-01-05 | 1939-01-03 | Republican | 3 | |||||||||||||
26923 | 26923 | James Oliver O000074 | rep | ME | 1937-01-05 | 1939-01-03 | Republican | 1 | |||||||||||||
22284 | 22284 | John Luecke L000502 | rep | MI | 1937-01-05 | 1939-01-03 | Democrat | 11 | |||||||||||||
22449 | 22449 | Andrew Transue T000354 | rep | MI | 1937-01-05 | 1939-01-03 | Democrat | 6 | |||||||||||||
22686 | 22686 | Carl Mapes M000119 | rep | MI | 1937-01-05 | 1939-01-03 | Republican | 5 | |||||||||||||
23891 | 23891 | Frank Hook H000757 | rep | MI | 1937-01-05 | 1939-01-03 | Democrat | 12 | |||||||||||||
24823 | 24823 | Albert Engel E000178 | rep | MI | 1937-01-05 | 1939-01-03 | Republican | 9 | |||||||||||||
24891 | 24891 | John Lesinski L000251 | rep | MI | 1937-01-05 | 1939-01-03 | Democrat | 16 | |||||||||||||
24941 | 24941 | Earl Michener M000693 | rep | MI | 1937-01-05 | 1939-01-03 | Republican | 2 | |||||||||||||
25013 | 25013 | George Sadowski S000011 | rep | MI | 1937-01-05 | 1939-01-03 | Democrat | 1 | |||||||||||||
25204 | 25204 | Fred Crawford C000889 | rep | MI | 1937-01-05 | 1939-01-03 | Republican | 8 | |||||||||||||
25561 | 25561 | Roy Woodruff W000718 | rep | MI | 1937-01-05 | 1939-01-03 | Republican | 10 | |||||||||||||
25766 | 25766 | George O’Brien O000009 | rep | MI | 1937-01-05 | 1939-01-03 | Democrat | 13 | |||||||||||||
25799 | 25799 | Paul Shafer S000277 | rep | MI | 1937-01-05 | 1939-01-03 | Republican | 3 | |||||||||||||
25913 | 25913 | John Dingell D000354 | rep | MI | 1937-01-05 | 1939-01-03 | Democrat | 15 | |||||||||||||
25931 | 25931 | George Dondero D000411 | rep | MI | 1937-01-05 | 1939-01-03 | Republican | 17 | |||||||||||||
26139 | 26139 | Jesse Wolcott W000668 | rep | MI | 1937-01-05 | 1939-01-03 | Republican | 7 | |||||||||||||
27232 | 27232 | Clare Hoffman H000683 | rep | MI | 1937-01-05 | 1939-01-03 | Republican | 4 | |||||||||||||
27417 | 27417 | Louis Rabaut R000001 | rep | MI | 1937-01-05 | 1939-01-03 | Democrat | 14 |
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);