legislator_terms
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
485 rows where "end" is on date 1937-01-03 sorted by party
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
22167 | 22167 | Stephen Gambrill G000035 | rep | MD | 1935-01-03 | 1937-01-03 | Democrat | 5 | |||||||||||||
22175 | 22175 | Allard Gasque G000092 | rep | SC | 1935-01-03 | 1937-01-03 | Democrat | 6 | |||||||||||||
22178 | 22178 | James Gildea G000182 | rep | PA | 1935-01-03 | 1937-01-03 | Democrat | 13 | |||||||||||||
22180 | 22180 | Don Gingery G000224 | rep | PA | 1935-01-03 | 1937-01-03 | Democrat | 23 | |||||||||||||
22190 | 22190 | Finly Gray G000395 | rep | IN | 1935-01-03 | 1937-01-03 | Democrat | 10 | |||||||||||||
22192 | 22192 | Joseph Gray G000399 | rep | PA | 1935-01-03 | 1937-01-03 | Democrat | 27 | |||||||||||||
22200 | 22200 | Arthur Greenwood G000437 | rep | IN | 1935-01-03 | 1937-01-03 | Democrat | 7 | |||||||||||||
22202 | 22202 | Paul Greever G000440 | rep | WY | 1935-01-03 | 1937-01-03 | Democrat | 0 | |||||||||||||
22206 | 22206 | Glenn Griswold G000483 | rep | IN | 1935-01-03 | 1937-01-03 | Democrat | 5 | |||||||||||||
22212 | 22212 | Franklin Hancock H000147 | rep | NC | 1935-01-03 | 1937-01-03 | Democrat | 5 | |||||||||||||
22216 | 22216 | Byron Harlan H000209 | rep | OH | 1935-01-03 | 1937-01-03 | Democrat | 3 | |||||||||||||
22224 | 22224 | Byron Harrison H000265 | sen | MS | 1931-12-07 | 1937-01-03 | 2 | Democrat | |||||||||||||
22227 | 22227 | John Higgins H000579 | rep | MA | 1935-01-03 | 1937-01-03 | Democrat | 11 | |||||||||||||
22230 | 22230 | Fred Hildebrandt H000584 | rep | SD | 1935-01-03 | 1937-01-03 | Democrat | 1 | |||||||||||||
22237 | 22237 | Virginia Jenckes J000077 | rep | IN | 1935-01-03 | 1937-01-03 | Democrat | 6 | |||||||||||||
22242 | 22242 | Edward Kenney K000120 | rep | NJ | 1935-01-03 | 1937-01-03 | Democrat | 9 | |||||||||||||
22245 | 22245 | Frank Kloeb K000271 | rep | OH | 1935-01-03 | 1937-01-03 | Democrat | 4 | |||||||||||||
22249 | 22249 | Frank Kniffin K000283 | rep | OH | 1935-01-03 | 1937-01-03 | Democrat | 5 | |||||||||||||
22258 | 22258 | John Lambeth L000038 | rep | NC | 1935-01-03 | 1937-01-03 | Democrat | 8 | |||||||||||||
22262 | 22262 | Arthur Lamneck L000040 | rep | OH | 1935-01-03 | 1937-01-03 | Democrat | 12 | |||||||||||||
22266 | 22266 | Joshua Lee L000198 | rep | OK | 1935-01-03 | 1937-01-03 | Democrat | 5 | |||||||||||||
22273 | 22273 | David Lewis L000277 | rep | MD | 1935-01-03 | 1937-01-03 | Democrat | 6 | |||||||||||||
22277 | 22277 | James Lewis L000284 | sen | IL | 1931-12-07 | 1937-01-03 | 2 | Democrat | |||||||||||||
22279 | 22279 | Marvel Logan L000404 | sen | KY | 1931-12-07 | 1937-01-03 | 2 | Democrat | |||||||||||||
22282 | 22282 | Henry Luckey L000499 | rep | NE | 1935-01-03 | 1937-01-03 | Democrat | 1 | |||||||||||||
22289 | 22289 | Gabriel Mahon M000064 | rep | SC | 1935-01-03 | 1937-01-03 | Democrat | 4 | |||||||||||||
22291 | 22291 | Fontaine Maverick M000263 | rep | TX | 1935-01-03 | 1937-01-03 | Democrat | 20 | |||||||||||||
22294 | 22294 | William McFarlane M000440 | rep | TX | 1935-01-03 | 1937-01-03 | Democrat | 13 | |||||||||||||
22297 | 22297 | John McGrath M000457 | rep | CA | 1935-01-03 | 1937-01-03 | Democrat | 8 | |||||||||||||
22299 | 22299 | John McGroarty M000462 | rep | CA | 1935-01-03 | 1937-01-03 | Democrat | 11 | |||||||||||||
22302 | 22302 | James Meeks M000631 | rep | IL | 1935-01-03 | 1937-01-03 | Democrat | 18 | |||||||||||||
22310 | 22310 | John Miller M000738 | rep | AR | 1935-01-03 | 1937-01-03 | Democrat | 2 | |||||||||||||
22314 | 22314 | John Mitchell M000823 | rep | TN | 1935-01-03 | 1937-01-03 | Democrat | 4 | |||||||||||||
22327 | 22327 | Andrew Montague M000861 | rep | VA | 1935-01-03 | 1937-01-03 | Democrat | 3 | |||||||||||||
22342 | 22342 | John O’Connell O000025 | rep | RI | 1935-01-03 | 1937-01-03 | Democrat | 2 | |||||||||||||
22350 | 22350 | John O’Connor O000030 | rep | NY | 1935-01-03 | 1937-01-03 | Democrat | 16 | |||||||||||||
22353 | 22353 | Thomas O’Malley O000087 | rep | WI | 1935-01-03 | 1937-01-03 | Democrat | 5 | |||||||||||||
22360 | 22360 | Vincent Palmisano P000046 | rep | MD | 1935-01-03 | 1937-01-03 | Democrat | 3 | |||||||||||||
22364 | 22364 | Edward Patterson P000111 | rep | KS | 1935-01-03 | 1937-01-03 | Democrat | 3 | |||||||||||||
22368 | 22368 | Samuel Pettengill P000268 | rep | IN | 1935-01-03 | 1937-01-03 | Democrat | 3 | |||||||||||||
22371 | 22371 | Theodore Peyser P000281 | rep | NY | 1935-01-03 | 1937-01-03 | Democrat | 17 | |||||||||||||
22374 | 22374 | James Quinn Q000017 | rep | PA | 1935-01-03 | 1937-01-03 | Democrat | 31 | |||||||||||||
22381 | 22381 | Michael Reilly R000155 | rep | WI | 1935-01-03 | 1937-01-03 | Democrat | 6 | |||||||||||||
22392 | 22392 | Morgan Sanders S000037 | rep | TX | 1935-01-03 | 1937-01-03 | Democrat | 3 | |||||||||||||
22402 | 22402 | Byron Scott S000165 | rep | CA | 1935-01-03 | 1937-01-03 | Democrat | 18 | |||||||||||||
22412 | 22412 | Morris Sheppard S000337 | sen | TX | 1931-12-07 | 1937-01-03 | 2 | Democrat | |||||||||||||
22428 | 22428 | Michael Stack S000773 | rep | PA | 1935-01-03 | 1937-01-03 | Democrat | 6 | |||||||||||||
22431 | 22431 | Henry Stubbs S001038 | rep | CA | 1935-01-03 | 1937-01-03 | Democrat | 10 | |||||||||||||
22435 | 22435 | John Taylor T000087 | rep | SC | 1935-01-03 | 1937-01-03 | Democrat | 3 | |||||||||||||
22439 | 22439 | Chester Thompson T000197 | rep | IL | 1935-01-03 | 1937-01-03 | Democrat | 14 | |||||||||||||
22455 | 22455 | Frederick Vinson V000106 | rep | KY | 1935-01-03 | 1937-01-03 | Democrat | 8 | |||||||||||||
22458 | 22458 | Otha Wearin W000221 | rep | IA | 1935-01-03 | 1937-01-03 | Democrat | 7 | |||||||||||||
22461 | 22461 | James Wilcox W000455 | rep | FL | 1935-01-03 | 1937-01-03 | Democrat | 4 | |||||||||||||
22483 | 22483 | William Ashbrook A000306 | rep | OH | 1935-01-03 | 1937-01-03 | Democrat | 17 | |||||||||||||
22497 | 22497 | William Bankhead B000113 | rep | AL | 1935-01-03 | 1937-01-03 | Democrat | 7 | |||||||||||||
22512 | 22512 | Millard Caldwell C000038 | rep | FL | 1935-01-03 | 1937-01-03 | Democrat | 3 | |||||||||||||
22518 | 22518 | Walter Chandler C000296 | rep | TN | 1935-01-03 | 1937-01-03 | Democrat | 9 | |||||||||||||
22521 | 22521 | David Clark C000428 | rep | ID | 1935-01-03 | 1937-01-03 | Democrat | 2 | |||||||||||||
22530 | 22530 | William Cravens C000886 | rep | AR | 1935-01-03 | 1937-01-03 | Democrat | 4 | |||||||||||||
22535 | 22535 | Eugene Crowe C000940 | rep | IN | 1935-01-03 | 1937-01-03 | Democrat | 9 | |||||||||||||
22539 | 22539 | Fred Cummings C000985 | rep | CO | 1935-01-03 | 1937-01-03 | Democrat | 2 | |||||||||||||
22542 | 22542 | Edward Curley C000995 | rep | NY | 1935-01-03 | 1937-01-03 | Democrat | 22 | |||||||||||||
22545 | 22545 | John Daly D000014 | rep | PA | 1935-01-03 | 1937-01-03 | Democrat | 4 | |||||||||||||
22568 | 22568 | René De Rouen D000265 | rep | LA | 1935-01-03 | 1937-01-03 | Democrat | 7 | |||||||||||||
22584 | 22584 | Matthew Dunn D000551 | rep | PA | 1935-01-03 | 1937-01-03 | Democrat | 34 | |||||||||||||
22588 | 22588 | Marcellus Evans E000253 | rep | NY | 1935-01-03 | 1937-01-03 | Democrat | 5 | |||||||||||||
22591 | 22591 | Phillip Ferguson F000082 | rep | OK | 1935-01-03 | 1937-01-03 | Democrat | 8 | |||||||||||||
22596 | 22596 | Joachim Fernández F000086 | rep | LA | 1935-01-03 | 1937-01-03 | Democrat | 1 | |||||||||||||
22620 | 22620 | Thomas Goldsborough G000265 | rep | MD | 1935-01-03 | 1937-01-03 | Democrat | 1 | |||||||||||||
22646 | 22646 | John Jones J000236 | rep | TX | 1935-01-03 | 1937-01-03 | Democrat | 18 | |||||||||||||
22651 | 22651 | Kent Keller K000056 | rep | IL | 1935-01-03 | 1937-01-03 | Democrat | 25 | |||||||||||||
22656 | 22656 | Ambrose Kennedy K000101 | rep | MD | 1935-01-03 | 1937-01-03 | Democrat | 4 | |||||||||||||
22692 | 22692 | John Martin M000186 | rep | CO | 1935-01-03 | 1937-01-03 | Democrat | 3 | |||||||||||||
22702 | 22702 | James McAndrews M000296 | rep | IL | 1935-01-03 | 1937-01-03 | Democrat | 9 | |||||||||||||
22720 | 22720 | Thomas McMillan M000572 | rep | SC | 1935-01-03 | 1937-01-03 | Democrat | 1 | |||||||||||||
22729 | 22729 | Samuel McReynolds M000598 | rep | TN | 1935-01-03 | 1937-01-03 | Democrat | 3 | |||||||||||||
22739 | 22739 | Emmett Owen O000149 | rep | GA | 1935-01-03 | 1937-01-03 | Democrat | 4 | |||||||||||||
22745 | 22745 | Claude Parsons P000086 | rep | IL | 1935-01-03 | 1937-01-03 | Democrat | 24 | |||||||||||||
22755 | 22755 | Elmer Ryan R000555 | rep | MN | 1935-01-03 | 1937-01-03 | Democrat | 2 | |||||||||||||
22779 | 22779 | William Sirovich S000452 | rep | NY | 1935-01-03 | 1937-01-03 | Democrat | 14 | |||||||||||||
22801 | 22801 | Christopher Sullivan S001051 | rep | NY | 1935-01-03 | 1937-01-03 | Democrat | 13 | |||||||||||||
22819 | 22819 | Clarence Turner T000417 | rep | TN | 1935-01-03 | 1937-01-03 | Democrat | 6 | |||||||||||||
22829 | 22829 | Lindsay Warren W000166 | rep | NC | 1935-01-03 | 1937-01-03 | Democrat | 1 | |||||||||||||
22837 | 22837 | Reuben Wood W000702 | rep | MO | 1935-01-03 | 1937-01-03 | Democrat | 6 | |||||||||||||
22842 | 22842 | Monrad Wallgren W000088 | rep | WA | 1935-01-03 | 1937-01-03 | Democrat | 2 | |||||||||||||
22863 | 22863 | Harry Beam B000274 | rep | IL | 1935-01-03 | 1937-01-03 | Democrat | 4 | |||||||||||||
22868 | 22868 | Alfred Beiter B000320 | rep | NY | 1935-01-03 | 1937-01-03 | Democrat | 41 | |||||||||||||
22876 | 22876 | John Boehne B000588 | rep | IN | 1935-01-03 | 1937-01-03 | Democrat | 8 | |||||||||||||
22882 | 22882 | Patrick Boland B000601 | rep | PA | 1935-01-03 | 1937-01-03 | Democrat | 11 | |||||||||||||
22890 | 22890 | Frank Buck B001017 | rep | CA | 1935-01-03 | 1937-01-03 | Democrat | 3 | |||||||||||||
22906 | 22906 | Wilburn Cartwright C000207 | rep | OK | 1935-01-03 | 1937-01-03 | Democrat | 3 | |||||||||||||
22910 | 22910 | Joseph Casey C000225 | rep | MA | 1935-01-03 | 1937-01-03 | Democrat | 3 | |||||||||||||
22920 | 22920 | Harry Coffee C000582 | rep | NE | 1935-01-03 | 1937-01-03 | Democrat | 5 | |||||||||||||
22927 | 22927 | William Cole C000616 | rep | MD | 1935-01-03 | 1937-01-03 | Democrat | 2 | |||||||||||||
22958 | 22958 | Colgate Darden D000050 | rep | VA | 1935-01-03 | 1937-01-03 | Democrat | 2 | |||||||||||||
22966 | 22966 | Wall Doxey D000480 | rep | MS | 1935-01-03 | 1937-01-03 | Democrat | 2 | |||||||||||||
22971 | 22971 | Richard Duncan D000536 | rep | MO | 1935-01-03 | 1937-01-03 | Democrat | 3 | |||||||||||||
22978 | 22978 | Andrew Edmiston E000051 | rep | WV | 1935-01-03 | 1937-01-03 | Democrat | 3 | |||||||||||||
22986 | 22986 | Charles Faddis F000001 | rep | PA | 1935-01-03 | 1937-01-03 | Democrat | 25 | |||||||||||||
23000 | 23000 | Aaron Ford F000258 | rep | MS | 1935-01-03 | 1937-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);