legislator_terms
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
483 rows where "start" is on date 1937-01-05 sorted by url
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
22372 | 22372 | Theodore Peyser P000281 | rep | NY | 1937-01-05 | 1939-01-03 | Democrat | 17 | |||||||||||||
22373 | 22373 | Alfred Phillips P000305 | rep | CT | 1937-01-05 | 1939-01-03 | Democrat | 4 | |||||||||||||
22375 | 22375 | James Quinn Q000017 | rep | PA | 1937-01-05 | 1939-01-03 | Democrat | 31 | |||||||||||||
22382 | 22382 | Michael Reilly R000155 | rep | WI | 1937-01-05 | 1939-01-03 | Democrat | 6 | |||||||||||||
22383 | 22383 | Hugh Rigney R000256 | rep | IL | 1937-01-05 | 1939-01-03 | Democrat | 19 | |||||||||||||
22384 | 22384 | Alphonse Roy R000483 | rep | NH | 1937-01-05 | 1939-01-03 | Democrat | 1 | |||||||||||||
22393 | 22393 | Morgan Sanders S000037 | rep | TX | 1937-01-05 | 1939-01-03 | Democrat | 3 | |||||||||||||
22400 | 22400 | George Schneider S000137 | rep | WI | 1937-01-05 | 1939-01-03 | Progressive | 8 | |||||||||||||
22401 | 22401 | Henry Schwartz S000157 | sen | WY | 1937-01-05 | 1943-01-03 | 2 | Democrat | |||||||||||||
22403 | 22403 | Byron Scott S000165 | rep | CA | 1937-01-05 | 1939-01-03 | Democrat | 18 | |||||||||||||
22413 | 22413 | Morris Sheppard S000337 | sen | TX | 1937-01-05 | 1941-12-31 | 2 | Democrat | |||||||||||||
22415 | 22415 | Gomer Smith S000543 | rep | OK | 1937-01-05 | 1939-01-03 | Democrat | 5 | |||||||||||||
22427 | 22427 | Bertrand Snell S000652 | rep | NY | 1937-01-05 | 1939-01-03 | Republican | 31 | |||||||||||||
22429 | 22429 | Michael Stack S000773 | rep | PA | 1937-01-05 | 1939-01-03 | Democrat | 6 | |||||||||||||
22432 | 22432 | Henry Stubbs S001038 | rep | CA | 1937-01-05 | 1939-01-03 | Democrat | 10 | |||||||||||||
22433 | 22433 | Guy Swope S001127 | rep | PA | 1937-01-05 | 1939-01-03 | Democrat | 19 | |||||||||||||
22436 | 22436 | John Taylor T000087 | rep | SC | 1937-01-05 | 1939-01-03 | Democrat | 3 | |||||||||||||
22437 | 22437 | Henry Teigan T000112 | rep | MN | 1937-01-05 | 1939-01-03 | Farmer-Labor | 3 | |||||||||||||
22440 | 22440 | Chester Thompson T000197 | rep | IL | 1937-01-05 | 1939-01-03 | Democrat | 14 | |||||||||||||
22447 | 22447 | Lloyd Thurston T000257 | rep | IA | 1937-01-05 | 1939-01-03 | Republican | 5 | |||||||||||||
22448 | 22448 | Frank Towey T000323 | rep | NJ | 1937-01-05 | 1939-01-03 | Democrat | 12 | |||||||||||||
22449 | 22449 | Andrew Transue T000354 | rep | MI | 1937-01-05 | 1939-01-03 | Democrat | 6 | |||||||||||||
22456 | 22456 | Frederick Vinson V000106 | rep | KY | 1937-01-05 | 1939-01-03 | Democrat | 8 | |||||||||||||
22459 | 22459 | Otha Wearin W000221 | rep | IA | 1937-01-05 | 1939-01-03 | Democrat | 7 | |||||||||||||
22462 | 22462 | James Wilcox W000455 | rep | FL | 1937-01-05 | 1939-01-03 | Democrat | 4 | |||||||||||||
22472 | 22472 | Robert Allen A000145 | rep | PA | 1937-01-05 | 1939-01-03 | Democrat | 28 | |||||||||||||
22474 | 22474 | Charles Anderson A000184 | rep | MO | 1937-01-05 | 1939-01-03 | Democrat | 12 | |||||||||||||
22484 | 22484 | William Ashbrook A000306 | rep | OH | 1937-01-05 | 1939-01-03 | Democrat | 17 | |||||||||||||
22498 | 22498 | William Bankhead B000113 | rep | AL | 1937-01-05 | 1939-01-03 | Democrat | 7 | |||||||||||||
22500 | 22500 | Bruce Barton B000211 | rep | NY | 1937-01-05 | 1939-01-03 | Republican | 17 | |||||||||||||
22513 | 22513 | Millard Caldwell C000038 | rep | FL | 1937-01-05 | 1939-01-03 | Democrat | 3 | |||||||||||||
22519 | 22519 | Walter Chandler C000296 | rep | TN | 1937-01-05 | 1939-01-03 | Democrat | 9 | |||||||||||||
22522 | 22522 | David Clark C000428 | rep | ID | 1937-01-05 | 1939-01-03 | Democrat | 2 | |||||||||||||
22531 | 22531 | William Cravens C000886 | rep | AR | 1937-01-05 | 1939-01-03 | Democrat | 4 | |||||||||||||
22536 | 22536 | Eugene Crowe C000940 | rep | IN | 1937-01-05 | 1939-01-03 | Democrat | 9 | |||||||||||||
22540 | 22540 | Fred Cummings C000985 | rep | CO | 1937-01-05 | 1939-01-03 | Democrat | 2 | |||||||||||||
22543 | 22543 | Edward Curley C000995 | rep | NY | 1937-01-05 | 1939-01-03 | Democrat | 22 | |||||||||||||
22546 | 22546 | John Daly D000014 | rep | PA | 1937-01-05 | 1939-01-03 | Democrat | 4 | |||||||||||||
22569 | 22569 | René De Rouen D000265 | rep | LA | 1937-01-05 | 1939-01-03 | Democrat | 7 | |||||||||||||
22581 | 22581 | Cassius Dowell D000468 | rep | IA | 1937-01-05 | 1939-01-03 | Republican | 6 | |||||||||||||
22585 | 22585 | Matthew Dunn D000551 | rep | PA | 1937-01-05 | 1939-01-03 | Democrat | 34 | |||||||||||||
22589 | 22589 | Marcellus Evans E000253 | rep | NY | 1937-01-05 | 1939-01-03 | Democrat | 5 | |||||||||||||
22592 | 22592 | Phillip Ferguson F000082 | rep | OK | 1937-01-05 | 1939-01-03 | Democrat | 8 | |||||||||||||
22597 | 22597 | Joachim Fernández F000086 | rep | LA | 1937-01-05 | 1939-01-03 | Democrat | 1 | |||||||||||||
22599 | 22599 | Frank Fries F000385 | rep | IL | 1937-01-05 | 1939-01-03 | Democrat | 21 | |||||||||||||
22601 | 22601 | Clyde Garrett G000080 | rep | TX | 1937-01-05 | 1939-01-03 | Democrat | 17 | |||||||||||||
22621 | 22621 | Thomas Goldsborough G000265 | rep | MD | 1937-01-05 | 1939-01-03 | Democrat | 1 | |||||||||||||
22624 | 22624 | John Griffith G000469 | rep | LA | 1937-01-05 | 1939-01-03 | Democrat | 6 | |||||||||||||
22634 | 22634 | Santiago Iglesias I000002 | rep | PR | 1937-01-05 | 1939-01-03 | Coalitionist | 0 | |||||||||||||
22647 | 22647 | John Jones J000236 | rep | TX | 1937-01-05 | 1939-01-03 | Democrat | 18 | |||||||||||||
22652 | 22652 | Kent Keller K000056 | rep | IL | 1937-01-05 | 1939-01-03 | Democrat | 25 | |||||||||||||
22657 | 22657 | Ambrose Kennedy K000101 | rep | MD | 1937-01-05 | 1939-01-03 | Democrat | 4 | |||||||||||||
22659 | 22659 | Wade Kitchens K000248 | rep | AR | 1937-01-05 | 1939-01-03 | Democrat | 7 | |||||||||||||
22662 | 22662 | Bert Lord L000439 | rep | NY | 1937-01-05 | 1939-01-03 | Republican | 34 | |||||||||||||
22672 | 22672 | Robert Luce L000498 | rep | MA | 1937-01-05 | 1939-01-03 | Republican | 9 | |||||||||||||
22686 | 22686 | Carl Mapes M000119 | rep | MI | 1937-01-05 | 1939-01-03 | Republican | 5 | |||||||||||||
22693 | 22693 | John Martin M000186 | rep | CO | 1937-01-05 | 1939-01-03 | Democrat | 3 | |||||||||||||
22703 | 22703 | James McAndrews M000296 | rep | IL | 1937-01-05 | 1939-01-03 | Democrat | 9 | |||||||||||||
22721 | 22721 | Thomas McMillan M000572 | rep | SC | 1937-01-05 | 1939-01-03 | Democrat | 1 | |||||||||||||
22730 | 22730 | Samuel McReynolds M000598 | rep | TN | 1937-01-05 | 1939-01-03 | Democrat | 3 | |||||||||||||
22732 | 22732 | Robert Mouton M001051 | rep | LA | 1937-01-05 | 1939-01-03 | Democrat | 3 | |||||||||||||
22740 | 22740 | Emmett Owen O000149 | rep | GA | 1937-01-05 | 1939-01-03 | Democrat | 4 | |||||||||||||
22746 | 22746 | Claude Parsons P000086 | rep | IL | 1937-01-05 | 1939-01-03 | Democrat | 24 | |||||||||||||
22756 | 22756 | Elmer Ryan R000555 | rep | MN | 1937-01-05 | 1939-01-03 | Democrat | 2 | |||||||||||||
22773 | 22773 | George Seger S000228 | rep | NJ | 1937-01-05 | 1939-01-03 | Republican | 8 | |||||||||||||
22780 | 22780 | William Sirovich S000452 | rep | NY | 1937-01-05 | 1939-01-03 | Democrat | 14 | |||||||||||||
22783 | 22783 | Clyde Smith S000523 | rep | ME | 1937-01-05 | 1939-01-03 | Republican | 2 | |||||||||||||
22802 | 22802 | Christopher Sullivan S001051 | rep | NY | 1937-01-05 | 1939-01-03 | Democrat | 13 | |||||||||||||
22814 | 22814 | James Taylor T000083 | rep | TN | 1937-01-05 | 1939-01-03 | Republican | 2 | |||||||||||||
22820 | 22820 | Clarence Turner T000417 | rep | TN | 1937-01-05 | 1939-01-03 | Democrat | 6 | |||||||||||||
22830 | 22830 | Lindsay Warren W000166 | rep | NC | 1937-01-05 | 1939-01-03 | Democrat | 1 | |||||||||||||
22833 | 22833 | Dudley White W000364 | rep | OH | 1937-01-05 | 1939-01-03 | Republican | 13 | |||||||||||||
22838 | 22838 | Reuben Wood W000702 | rep | MO | 1937-01-05 | 1939-01-03 | Democrat | 6 | |||||||||||||
22843 | 22843 | Monrad Wallgren W000088 | rep | WA | 1937-01-05 | 1939-01-03 | Democrat | 2 | |||||||||||||
22849 | 22849 | Laurence Arnold A000290 | rep | IL | 1937-01-05 | 1939-01-03 | Democrat | 23 | |||||||||||||
22864 | 22864 | Harry Beam B000274 | rep | IL | 1937-01-05 | 1939-01-03 | Democrat | 4 | |||||||||||||
22869 | 22869 | Alfred Beiter B000320 | rep | NY | 1937-01-05 | 1939-01-03 | Democrat | 41 | |||||||||||||
22877 | 22877 | John Boehne B000588 | rep | IN | 1937-01-05 | 1939-01-03 | Democrat | 8 | |||||||||||||
22883 | 22883 | Patrick Boland B000601 | rep | PA | 1937-01-05 | 1939-01-03 | Democrat | 11 | |||||||||||||
22891 | 22891 | Frank Buck B001017 | rep | CA | 1937-01-05 | 1939-01-03 | Democrat | 3 | |||||||||||||
22895 | 22895 | Richard Buckler B001023 | rep | MN | 1937-01-05 | 1939-01-03 | Farmer-Labor | 9 | |||||||||||||
22907 | 22907 | Wilburn Cartwright C000207 | rep | OK | 1937-01-05 | 1939-01-03 | Democrat | 3 | |||||||||||||
22911 | 22911 | Joseph Casey C000225 | rep | MA | 1937-01-05 | 1939-01-03 | Democrat | 3 | |||||||||||||
22914 | 22914 | Harold Claypool C000489 | rep | OH | 1937-01-05 | 1939-01-03 | Democrat | 11 | |||||||||||||
22917 | 22917 | Ernest Cluett C000535 | rep | NY | 1937-01-05 | 1939-01-03 | Republican | 29 | |||||||||||||
22921 | 22921 | Harry Coffee C000582 | rep | NE | 1937-01-05 | 1939-01-03 | Democrat | 5 | |||||||||||||
22928 | 22928 | William Cole C000616 | rep | MD | 1937-01-05 | 1939-01-03 | Democrat | 2 | |||||||||||||
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 |
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);