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
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
22865 | 22865 | Harry Beam B000274 | rep | IL | 1939-01-03 | 1941-01-03 | Democrat | 4 | |||||||||||||
23086 | 23086 | Leo Kocialkowski K000303 | rep | IL | 1939-01-03 | 1941-01-03 | Democrat | 8 | |||||||||||||
23107 | 23107 | Anton Maciejewski M000016 | rep | IL | 1939-01-03 | 1941-01-03 | Democrat | 6 | |||||||||||||
23122 | 23122 | Raymond McKeough M000510 | rep | IL | 1939-01-03 | 1941-01-03 | Democrat | 2 | |||||||||||||
23145 | 23145 | Arthur Mitchell M000805 | rep | IL | 1939-01-03 | 1941-01-03 | Democrat | 1 | |||||||||||||
23219 | 23219 | Edwin Schaefer S000110 | rep | IL | 1939-01-03 | 1941-01-03 | Democrat | 22 | |||||||||||||
23670 | 23670 | Leonard Schuetz S000144 | rep | IL | 1939-01-03 | 1941-01-03 | Democrat | 7 | |||||||||||||
23739 | 23739 | William Wheat W000327 | rep | IL | 1939-01-03 | 1941-01-03 | Republican | 19 | |||||||||||||
23927 | 23927 | Edward Kelly K000071 | rep | IL | 1939-01-03 | 1941-01-03 | Democrat | 3 | |||||||||||||
23963 | 23963 | Scott Lucas L000493 | sen | IL | 1939-01-03 | 1945-01-03 | 3 | Democrat | |||||||||||||
24109 | 24109 | Jessie Sumner S001071 | rep | IL | 1939-01-03 | 1941-01-03 | Republican | 18 | |||||||||||||
24488 | 24488 | Anton Johnson J000117 | rep | IL | 1939-01-03 | 1941-01-03 | Republican | 14 | |||||||||||||
24806 | 24806 | Ralph Church C000390 | rep | IL | 1939-01-03 | 1941-01-03 | Republican | 10 | |||||||||||||
25470 | 25470 | Adolph Sabath S000001 | rep | IL | 1939-01-03 | 1941-01-03 | Democrat | 5 | |||||||||||||
26095 | 26095 | Chauncey Reed R000111 | rep | IL | 1939-01-03 | 1941-01-03 | Republican | 11 | |||||||||||||
26695 | 26695 | Leo Allen A000138 | rep | IL | 1939-01-03 | 1941-01-03 | Republican | 13 | |||||||||||||
27142 | 27142 | Robert Chiperfield C000365 | rep | IL | 1939-01-03 | 1941-01-03 | Republican | 15 | |||||||||||||
27344 | 27344 | Noah Mason M000224 | rep | IL | 1939-01-03 | 1941-01-03 | Republican | 12 | |||||||||||||
27745 | 27745 | Everett Dirksen D000360 | rep | IL | 1939-01-03 | 1941-01-03 | Republican | 16 | |||||||||||||
30140 | 30140 | Leslie Arends A000216 | rep | IL | 1939-01-03 | 1941-01-03 | Republican | 17 | |||||||||||||
22537 | 22537 | Eugene Crowe C000940 | rep | IN | 1939-01-03 | 1941-01-03 | Democrat | 9 | |||||||||||||
22823 | 22823 | Frederick Van Nuys V000050 | sen | IN | 1939-01-03 | 1945-01-03 | 3 | Democrat | |||||||||||||
22878 | 22878 | John Boehne B000588 | rep | IN | 1939-01-03 | 1941-01-03 | Democrat | 8 | |||||||||||||
23101 | 23101 | William Larrabee L000100 | rep | IN | 1939-01-03 | 1941-01-03 | Democrat | 11 | |||||||||||||
23224 | 23224 | William Schulte S000145 | rep | IN | 1939-01-03 | 1941-01-03 | Democrat | 1 | |||||||||||||
24427 | 24427 | George Gillie G000207 | rep | IN | 1939-01-03 | 1941-01-03 | Republican | 4 | |||||||||||||
24433 | 24433 | Robert Grant G000384 | rep | IN | 1939-01-03 | 1941-01-03 | Republican | 3 | |||||||||||||
24455 | 24455 | Forest Harness H000217 | rep | IN | 1939-01-03 | 1941-01-03 | Republican | 5 | |||||||||||||
24497 | 24497 | Noble Johnson J000165 | rep | IN | 1939-01-03 | 1941-01-03 | Republican | 6 | |||||||||||||
24530 | 24530 | Gerald Landis L000052 | rep | IN | 1939-01-03 | 1941-01-03 | Republican | 7 | |||||||||||||
24565 | 24565 | Louis Ludlow L000501 | rep | IN | 1939-01-03 | 1941-01-03 | Democrat | 12 | |||||||||||||
24678 | 24678 | Raymond Springer S000755 | rep | IN | 1939-01-03 | 1941-01-03 | Republican | 10 | |||||||||||||
28862 | 28862 | Charles Halleck H000081 | rep | IN | 1939-01-03 | 1941-01-03 | Republican | 2 | |||||||||||||
23046 | 23046 | John Houston H000824 | rep | KS | 1939-01-03 | 1941-01-03 | Democrat | 5 | |||||||||||||
23543 | 23543 | Ulysses Guyer G000538 | rep | KS | 1939-01-03 | 1941-01-03 | Republican | 2 | |||||||||||||
23576 | 23576 | William Lambertson L000037 | rep | KS | 1939-01-03 | 1941-01-03 | Republican | 1 | |||||||||||||
24060 | 24060 | Clyde Reed R000112 | sen | KS | 1939-01-03 | 1945-01-03 | 3 | Republican | |||||||||||||
24203 | 24203 | Thomas Winter W000645 | rep | KS | 1939-01-03 | 1941-01-03 | Republican | 3 | |||||||||||||
26013 | 26013 | Clifford Hope H000768 | rep | KS | 1939-01-03 | 1941-01-03 | Republican | 7 | |||||||||||||
26972 | 26972 | Edward Rees R000132 | rep | KS | 1939-01-03 | 1941-01-03 | Republican | 4 | |||||||||||||
27702 | 27702 | Frank Carlson C000154 | rep | KS | 1939-01-03 | 1941-01-03 | Republican | 6 | |||||||||||||
23382 | 23382 | Edward Creal C000898 | rep | KY | 1939-01-03 | 1941-01-03 | Democrat | 4 | |||||||||||||
23729 | 23729 | Beverly Vincent V000100 | rep | KY | 1939-01-03 | 1941-01-03 | Democrat | 2 | |||||||||||||
23979 | 23979 | Andrew May M000272 | rep | KY | 1939-01-03 | 1941-01-03 | Democrat | 7 | |||||||||||||
24013 | 24013 | Emmet O’Neal O000089 | rep | KY | 1939-01-03 | 1941-01-03 | Democrat | 3 | |||||||||||||
24659 | 24659 | John Robsion R000358 | rep | KY | 1939-01-03 | 1941-01-03 | Republican | 9 | |||||||||||||
24797 | 24797 | Virgil Chapman C000317 | rep | KY | 1939-01-03 | 1941-01-03 | Democrat | 6 | |||||||||||||
25131 | 25131 | Joseph Bates B000237 | rep | KY | 1939-01-03 | 1941-01-03 | Democrat | 8 | |||||||||||||
25876 | 25876 | Alben Barkley B000145 | sen | KY | 1939-01-03 | 1945-01-03 | 3 | Democrat | |||||||||||||
26335 | 26335 | Noble Gregory G000447 | rep | KY | 1939-01-03 | 1941-01-03 | Democrat | 1 | |||||||||||||
27537 | 27537 | Brent Spence S000717 | rep | KY | 1939-01-03 | 1941-01-03 | Democrat | 5 | |||||||||||||
22570 | 22570 | René De Rouen D000265 | rep | LA | 1939-01-03 | 1941-01-03 | Democrat | 7 | |||||||||||||
22598 | 22598 | Joachim Fernández F000086 | rep | LA | 1939-01-03 | 1941-01-03 | Democrat | 1 | |||||||||||||
22625 | 22625 | John Griffith G000469 | rep | LA | 1939-01-03 | 1941-01-03 | Democrat | 6 | |||||||||||||
22733 | 22733 | Robert Mouton M001051 | rep | LA | 1939-01-03 | 1941-01-03 | Democrat | 3 | |||||||||||||
23141 | 23141 | Newt Mills M000775 | rep | LA | 1939-01-03 | 1941-01-03 | Democrat | 5 | |||||||||||||
23971 | 23971 | Paul Maloney M000091 | rep | LA | 1939-01-03 | 1941-01-03 | Democrat | 2 | |||||||||||||
24021 | 24021 | John Overton O000146 | sen | LA | 1939-01-03 | 1945-01-03 | 3 | Democrat | |||||||||||||
25113 | 25113 | Asa Allen A000114 | rep | LA | 1939-01-03 | 1941-01-03 | Democrat | 8 | |||||||||||||
27128 | 27128 | Overton Brooks B000884 | rep | LA | 1939-01-03 | 1941-01-03 | Democrat | 4 | |||||||||||||
22673 | 22673 | Robert Luce L000498 | rep | MA | 1939-01-03 | 1941-01-03 | Republican | 9 | |||||||||||||
22912 | 22912 | Joseph Casey C000225 | rep | MA | 1939-01-03 | 1941-01-03 | Democrat | 3 | |||||||||||||
22942 | 22942 | Lawrence Connery C000693 | rep | MA | 1939-01-03 | 1941-01-03 | Democrat | 7 | |||||||||||||
22993 | 22993 | Thomas Flaherty F000183 | rep | MA | 1939-01-03 | 1941-01-03 | Democrat | 11 | |||||||||||||
23035 | 23035 | Arthur Healey H000423 | rep | MA | 1939-01-03 | 1941-01-03 | Democrat | 8 | |||||||||||||
23308 | 23308 | George Tinkham T000283 | rep | MA | 1939-01-03 | 1941-01-03 | Republican | 10 | |||||||||||||
23724 | 23724 | Allen Treadway T000358 | rep | MA | 1939-01-03 | 1941-01-03 | Republican | 1 | |||||||||||||
23886 | 23886 | Pehr Holmes H000741 | rep | MA | 1939-01-03 | 1941-01-03 | Republican | 4 | |||||||||||||
24305 | 24305 | Charles Clason C000473 | rep | MA | 1939-01-03 | 1941-01-03 | Republican | 2 | |||||||||||||
24422 | 24422 | Charles Gifford G000169 | rep | MA | 1939-01-03 | 1941-01-03 | Republican | 15 | |||||||||||||
24733 | 24733 | George Bates B000232 | rep | MA | 1939-01-03 | 1941-01-03 | Republican | 6 | |||||||||||||
26657 | 26657 | Richard Wigglesworth W000450 | rep | MA | 1939-01-03 | 1941-01-03 | Republican | 13 | |||||||||||||
26990 | 26990 | Edith Rogers R000392 | rep | MA | 1939-01-03 | 1941-01-03 | Republican | 5 | |||||||||||||
28536 | 28536 | Joseph Martin M000191 | rep | MA | 1939-01-03 | 1941-01-03 | Republican | 14 | |||||||||||||
29370 | 29370 | John McCormack M000364 | rep | MA | 1939-01-03 | 1941-01-03 | Democrat | 12 | |||||||||||||
22622 | 22622 | Thomas Goldsborough G000265 | rep | MD | 1939-01-03 | 1941-01-03 | Democrat | 1 | |||||||||||||
22658 | 22658 | Ambrose Kennedy K000101 | rep | MD | 1939-01-03 | 1941-01-03 | Democrat | 4 | |||||||||||||
22900 | 22900 | William Byron B001206 | rep | MD | 1939-01-03 | 1941-01-03 | Democrat | 6 | |||||||||||||
22929 | 22929 | William Cole C000616 | rep | MD | 1939-01-03 | 1941-01-03 | Democrat | 2 | |||||||||||||
23733 | 23733 | David Ward W000130 | rep | MD | 1939-01-03 | 1941-01-03 | Democrat | 1 | |||||||||||||
24172 | 24172 | Millard Tydings T000446 | sen | MD | 1939-01-03 | 1945-01-03 | 3 | Democrat | |||||||||||||
24334 | 24334 | Thomas D’Alesandro D000007 | rep | MD | 1939-01-03 | 1941-01-03 | Democrat | 3 | |||||||||||||
25477 | 25477 | Lansdale Sasscer S000067 | rep | MD | 1939-01-03 | 1941-01-03 | Democrat | 5 | |||||||||||||
22784 | 22784 | Clyde Smith S000523 | rep | ME | 1939-01-03 | 1941-01-03 | Republican | 2 | |||||||||||||
24283 | 24283 | Ralph Brewster B000816 | rep | ME | 1939-01-03 | 1941-01-03 | Republican | 3 | |||||||||||||
26924 | 26924 | James Oliver O000074 | rep | ME | 1939-01-03 | 1941-01-03 | Republican | 1 | |||||||||||||
29040 | 29040 | Margaret Smith S000590 | rep | ME | 1939-01-03 | 1941-01-03 | Republican | 2 | |||||||||||||
22687 | 22687 | Carl Mapes M000119 | rep | MI | 1939-01-03 | 1941-01-03 | Republican | 5 | |||||||||||||
22713 | 22713 | Clarence McLeod M000557 | rep | MI | 1939-01-03 | 1941-01-03 | Republican | 13 | |||||||||||||
23287 | 23287 | Rudolph Tenerowicz T000124 | rep | MI | 1939-01-03 | 1941-01-03 | Democrat | 1 | |||||||||||||
23892 | 23892 | Frank Hook H000757 | rep | MI | 1939-01-03 | 1941-01-03 | Democrat | 12 | |||||||||||||
24275 | 24275 | Frederick Bradley B000742 | rep | MI | 1939-01-03 | 1941-01-03 | Republican | 11 | |||||||||||||
24508 | 24508 | Bartel Jonkman J000264 | rep | MI | 1939-01-03 | 1941-01-03 | Republican | 5 | |||||||||||||
24824 | 24824 | Albert Engel E000178 | rep | MI | 1939-01-03 | 1941-01-03 | Republican | 9 | |||||||||||||
24892 | 24892 | John Lesinski L000251 | rep | MI | 1939-01-03 | 1941-01-03 | Democrat | 16 | |||||||||||||
24942 | 24942 | Earl Michener M000693 | rep | MI | 1939-01-03 | 1941-01-03 | Republican | 2 | |||||||||||||
25139 | 25139 | William Blackney B000515 | rep | MI | 1939-01-03 | 1941-01-03 | Republican | 6 | |||||||||||||
25205 | 25205 | Fred Crawford C000889 | rep | MI | 1939-01-03 | 1941-01-03 | Republican | 8 | |||||||||||||
25562 | 25562 | Roy Woodruff W000718 | rep | MI | 1939-01-03 | 1941-01-03 | Republican | 10 | |||||||||||||
25800 | 25800 | Paul Shafer S000277 | rep | MI | 1939-01-03 | 1941-01-03 | Republican | 3 |
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);