legislator_terms
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
480 rows where "start" is on date 1935-01-03 sorted by phone
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
21994 | 21994 | Hubert Utterback U000036 | rep | IA | 1935-01-03 | 1937-01-03 | Democrat | 6 | |||||||||||||
21996 | 21996 | Theodore Werner W000299 | rep | SD | 1935-01-03 | 1937-01-03 | Democrat | 2 | |||||||||||||
22007 | 22007 | Riley Wilson W000608 | rep | LA | 1935-01-03 | 1937-01-03 | Democrat | 5 | |||||||||||||
22008 | 22008 | William Wilson W000622 | rep | PA | 1935-01-03 | 1937-01-03 | Republican | 2 | |||||||||||||
22010 | 22010 | Marion Zioncheck Z000011 | rep | WA | 1935-01-03 | 1937-01-03 | Democrat | 1 | |||||||||||||
22012 | 22012 | Prentiss Brown B000941 | rep | MI | 1935-01-03 | 1936-11-18 | Democrat | 11 | |||||||||||||
22024 | 22024 | Thomas Amlie A000176 | rep | WI | 1935-01-03 | 1937-01-03 | Progressive | 1 | |||||||||||||
22033 | 22033 | Robert Bacon B000019 | rep | NY | 1935-01-03 | 1937-01-03 | Republican | 1 | |||||||||||||
22038 | 22038 | Frederick Biermann B000449 | rep | IA | 1935-01-03 | 1937-01-03 | Democrat | 4 | |||||||||||||
22041 | 22041 | Charles Binderup B000466 | rep | NE | 1935-01-03 | 1937-01-03 | Democrat | 4 | |||||||||||||
22045 | 22045 | Gerald Boileau B000598 | rep | WI | 1935-01-03 | 1937-01-03 | Progressive | 7 | |||||||||||||
22060 | 22060 | John Boylan B000726 | rep | NY | 1935-01-03 | 1937-01-03 | Democrat | 15 | |||||||||||||
22073 | 22073 | James Buchanan B001006 | rep | TX | 1935-01-03 | 1937-01-03 | Democrat | 10 | |||||||||||||
22087 | 22087 | Raymond Cannon C000124 | rep | WI | 1935-01-03 | 1937-01-03 | Democrat | 4 | |||||||||||||
22090 | 22090 | William Citron C000397 | rep | CT | 1935-01-03 | 1937-01-03 | Democrat | 0 | |||||||||||||
22093 | 22093 | Charles Colden C000605 | rep | CA | 1935-01-03 | 1937-01-03 | Democrat | 17 | |||||||||||||
22101 | 22101 | William Connery C000694 | rep | MA | 1935-01-03 | 1937-01-03 | Democrat | 7 | |||||||||||||
22104 | 22104 | Charles Crosby C000928 | rep | PA | 1935-01-03 | 1937-01-03 | Democrat | 29 | |||||||||||||
22108 | 22108 | Braswell Deen D000187 | rep | GA | 1935-01-03 | 1937-01-03 | Democrat | 8 | |||||||||||||
22112 | 22112 | John Dockweiler D000387 | rep | CA | 1935-01-03 | 1937-01-03 | Democrat | 16 | |||||||||||||
22114 | 22114 | Frank Dorsey D000438 | rep | PA | 1935-01-03 | 1937-01-03 | Democrat | 5 | |||||||||||||
22124 | 22124 | William Driver D000503 | rep | AR | 1935-01-03 | 1937-01-03 | Democrat | 1 | |||||||||||||
22126 | 22126 | Charles Eckert E000032 | rep | PA | 1935-01-03 | 1937-01-03 | Democrat | 26 | |||||||||||||
22129 | 22129 | Edward Eicher E000094 | rep | IA | 1935-01-03 | 1937-01-03 | Democrat | 1 | |||||||||||||
22132 | 22132 | Henry Ellenbogen E000111 | rep | PA | 1935-01-03 | 1937-01-03 | Democrat | 33 | |||||||||||||
22135 | 22135 | James Farley F000019 | rep | IN | 1935-01-03 | 1937-01-03 | Democrat | 4 | |||||||||||||
22141 | 22141 | Thomas Fletcher F000205 | rep | OH | 1935-01-03 | 1937-01-03 | Democrat | 8 | |||||||||||||
22151 | 22151 | Benjamin Focht F000230 | rep | PA | 1935-01-03 | 1937-01-03 | Republican | 18 | |||||||||||||
22154 | 22154 | Oliver Frey F000382 | rep | PA | 1935-01-03 | 1937-01-03 | Democrat | 9 | |||||||||||||
22159 | 22159 | Claude Fuller F000408 | rep | AR | 1935-01-03 | 1937-01-03 | Democrat | 3 | |||||||||||||
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 | |||||||||||||
22183 | 22183 | Philip Goodwin G000302 | rep | NY | 1935-01-03 | 1937-01-03 | Republican | 27 | |||||||||||||
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 | |||||||||||||
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 | |||||||||||||
22254 | 22254 | Paul Kvale K000350 | rep | MN | 1935-01-03 | 1937-01-03 | Farmer-Labor | 7 | |||||||||||||
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 | |||||||||||||
22282 | 22282 | Henry Luckey L000499 | rep | NE | 1935-01-03 | 1937-01-03 | Democrat | 1 | |||||||||||||
22287 | 22287 | Ernest Lundeen L000514 | rep | MN | 1935-01-03 | 1937-01-03 | Farmer-Labor | 3 | |||||||||||||
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 | |||||||||||||
22306 | 22306 | Charles Millard M000709 | rep | NY | 1935-01-03 | 1937-01-03 | Republican | 25 | |||||||||||||
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 | |||||||||||||
22362 | 22362 | Quintin Paredes P000050 | rep | PI | 1935-01-03 | 1937-01-03 | 0 | ||||||||||||||
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 | |||||||||||||
22399 | 22399 | George Schneider S000137 | rep | WI | 1935-01-03 | 1937-01-03 | Progressive | 8 | |||||||||||||
22402 | 22402 | Byron Scott S000165 | rep | CA | 1935-01-03 | 1937-01-03 | Democrat | 18 | |||||||||||||
22426 | 22426 | Bertrand Snell S000652 | rep | NY | 1935-01-03 | 1937-01-03 | Republican | 31 | |||||||||||||
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 | |||||||||||||
22446 | 22446 | Lloyd Thurston T000257 | rep | IA | 1935-01-03 | 1937-01-03 | Republican | 5 | |||||||||||||
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 | |||||||||||||
22505 | 22505 | Chester Bolton B000606 | rep | OH | 1935-01-03 | 1937-01-03 | Republican | 22 | |||||||||||||
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 | |||||||||||||
22559 | 22559 | George Darrow D000063 | rep | PA | 1935-01-03 | 1937-01-03 | Republican | 7 | |||||||||||||
22568 | 22568 | René De Rouen D000265 | rep | LA | 1935-01-03 | 1937-01-03 | Democrat | 7 |
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);