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 district
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
21660 | 21660 | William Brunner B000981 | rep | NY | 1935-01-03 | 1937-01-03 | Democrat | 2 | |||||||||||||
21693 | 21693 | Glover Cary C000214 | rep | KY | 1935-01-03 | 1937-01-03 | Democrat | 2 | |||||||||||||
21772 | 21772 | William Granfield G000372 | rep | MA | 1935-01-03 | 1937-01-03 | Democrat | 2 | |||||||||||||
21804 | 21804 | William Higgins H000580 | rep | CT | 1935-01-03 | 1937-01-03 | Republican | 2 | |||||||||||||
21832 | 21832 | Bernhard Jacobsen J000038 | rep | IA | 1935-01-03 | 1937-01-03 | Democrat | 2 | |||||||||||||
21898 | 21898 | Edward Moran M000932 | rep | ME | 1935-01-03 | 1937-01-03 | Democrat | 2 | |||||||||||||
21996 | 21996 | Theodore Werner W000299 | rep | SD | 1935-01-03 | 1937-01-03 | Democrat | 2 | |||||||||||||
22008 | 22008 | William Wilson W000622 | rep | PA | 1935-01-03 | 1937-01-03 | Republican | 2 | |||||||||||||
22310 | 22310 | John Miller M000738 | rep | AR | 1935-01-03 | 1937-01-03 | Democrat | 2 | |||||||||||||
22342 | 22342 | John O’Connell O000025 | rep | RI | 1935-01-03 | 1937-01-03 | Democrat | 2 | |||||||||||||
22521 | 22521 | David Clark C000428 | rep | ID | 1935-01-03 | 1937-01-03 | Democrat | 2 | |||||||||||||
22539 | 22539 | Fred Cummings C000985 | rep | CO | 1935-01-03 | 1937-01-03 | Democrat | 2 | |||||||||||||
22755 | 22755 | Elmer Ryan R000555 | rep | MN | 1935-01-03 | 1937-01-03 | Democrat | 2 | |||||||||||||
22813 | 22813 | James Taylor T000083 | rep | TN | 1935-01-03 | 1937-01-03 | Republican | 2 | |||||||||||||
22842 | 22842 | Monrad Wallgren W000088 | rep | WA | 1935-01-03 | 1937-01-03 | Democrat | 2 | |||||||||||||
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 | |||||||||||||
23120 | 23120 | Raymond McKeough M000510 | rep | IL | 1935-01-03 | 1937-01-03 | Democrat | 2 | |||||||||||||
23124 | 23124 | Charles McLaughlin M000538 | rep | NE | 1935-01-03 | 1937-01-03 | Democrat | 2 | |||||||||||||
23161 | 23161 | William Nelson N000046 | rep | MO | 1935-01-03 | 1937-01-03 | Democrat | 2 | |||||||||||||
23177 | 23177 | Walter Pierce P000339 | rep | OR | 1935-01-03 | 1937-01-03 | Democrat | 2 | |||||||||||||
23446 | 23446 | Harry Englebright E000182 | rep | CA | 1935-01-03 | 1937-01-03 | Republican | 2 | |||||||||||||
23488 | 23488 | Hampton Fulmer F000417 | rep | SC | 1935-01-03 | 1937-01-03 | Democrat | 2 | |||||||||||||
23531 | 23531 | Robert Green G000415 | rep | FL | 1935-01-03 | 1937-01-03 | Democrat | 2 | |||||||||||||
23541 | 23541 | Ulysses Guyer G000538 | rep | KS | 1935-01-03 | 1937-01-03 | Republican | 2 | |||||||||||||
23628 | 23628 | John Nichols N000092 | rep | OK | 1935-01-03 | 1937-01-03 | Democrat | 2 | |||||||||||||
23658 | 23658 | Harry Sauthoff S000079 | rep | WI | 1935-01-03 | 1937-01-03 | Progressive | 2 | |||||||||||||
23770 | 23770 | William Barry B000191 | rep | NY | 1935-01-03 | 1937-01-03 | Democrat | 2 | |||||||||||||
23969 | 23969 | Paul Maloney M000091 | rep | LA | 1935-01-03 | 1937-01-03 | Democrat | 2 | |||||||||||||
24064 | 24064 | James Robinson R000341 | rep | UT | 1935-01-03 | 1937-01-03 | Democrat | 2 | |||||||||||||
24940 | 24940 | Earl Michener M000693 | rep | MI | 1935-01-03 | 1937-01-03 | Republican | 2 | |||||||||||||
25194 | 25194 | Edward Cox C000831 | rep | GA | 1935-01-03 | 1937-01-03 | Democrat | 2 | |||||||||||||
25354 | 25354 | John Kerr K000138 | rep | NC | 1935-01-03 | 1937-01-03 | Democrat | 2 | |||||||||||||
25521 | 25521 | Charles Tobey T000289 | rep | NH | 1935-01-03 | 1937-01-03 | Republican | 2 | |||||||||||||
26302 | 26302 | Martin Dies D000338 | rep | TX | 1935-01-03 | 1937-01-03 | Democrat | 2 | |||||||||||||
26870 | 26870 | William Hess H000550 | rep | OH | 1935-01-03 | 1937-01-03 | Republican | 2 | |||||||||||||
27877 | 27877 | Joseph Hill H000598 | rep | AL | 1935-01-03 | 1937-01-03 | Democrat | 2 | |||||||||||||
28860 | 28860 | Charles Halleck H000081 | rep | IN | 1935-01-03 | 1937-01-03 | Republican | 2 | |||||||||||||
32242 | 32242 | Jennings Randolph R000046 | rep | WV | 1935-01-03 | 1937-01-03 | Democrat | 2 | |||||||||||||
21696 | 21696 | Bryant Castellow C000240 | rep | GA | 1935-01-03 | 1937-01-03 | Democrat | 3 | |||||||||||||
21760 | 21760 | William Ekwall E000098 | rep | OR | 1935-01-03 | 1937-01-03 | Republican | 3 | |||||||||||||
21761 | 21761 | Clare Fenerty F000071 | rep | PA | 1935-01-03 | 1937-01-03 | Republican | 3 | |||||||||||||
21839 | 21839 | Henry Kimball K000183 | rep | MI | 1935-01-03 | 1937-01-03 | Republican | 3 | |||||||||||||
21859 | 21859 | Verner Main M000071 | rep | MI | 1935-01-03 | 1937-01-03 | Republican | 3 | |||||||||||||
21895 | 21895 | Numa Montet M000862 | rep | LA | 1935-01-03 | 1937-01-03 | Democrat | 3 | |||||||||||||
22159 | 22159 | Claude Fuller F000408 | rep | AR | 1935-01-03 | 1937-01-03 | Democrat | 3 | |||||||||||||
22216 | 22216 | Byron Harlan H000209 | rep | OH | 1935-01-03 | 1937-01-03 | Democrat | 3 | |||||||||||||
22287 | 22287 | Ernest Lundeen L000514 | rep | MN | 1935-01-03 | 1937-01-03 | Farmer-Labor | 3 | |||||||||||||
22327 | 22327 | Andrew Montague M000861 | rep | VA | 1935-01-03 | 1937-01-03 | Democrat | 3 | |||||||||||||
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 | |||||||||||||
22392 | 22392 | Morgan Sanders S000037 | rep | TX | 1935-01-03 | 1937-01-03 | Democrat | 3 | |||||||||||||
22435 | 22435 | John Taylor T000087 | rep | SC | 1935-01-03 | 1937-01-03 | Democrat | 3 | |||||||||||||
22512 | 22512 | Millard Caldwell C000038 | rep | FL | 1935-01-03 | 1937-01-03 | Democrat | 3 | |||||||||||||
22692 | 22692 | John Martin M000186 | rep | CO | 1935-01-03 | 1937-01-03 | Democrat | 3 | |||||||||||||
22729 | 22729 | Samuel McReynolds M000598 | rep | TN | 1935-01-03 | 1937-01-03 | Democrat | 3 | |||||||||||||
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 | |||||||||||||
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 | |||||||||||||
23228 | 23228 | James Shanley S000285 | rep | CT | 1935-01-03 | 1937-01-03 | Democrat | 3 | |||||||||||||
23249 | 23249 | Martin Smith S000591 | rep | WA | 1935-01-03 | 1937-01-03 | Democrat | 3 | |||||||||||||
23260 | 23260 | William Sutphin S001086 | rep | NJ | 1935-01-03 | 1937-01-03 | Democrat | 3 | |||||||||||||
23697 | 23697 | Henry Steagall S000820 | rep | AL | 1935-01-03 | 1937-01-03 | Democrat | 3 | |||||||||||||
23925 | 23925 | Edward Kelly K000071 | rep | IL | 1935-01-03 | 1937-01-03 | Democrat | 3 | |||||||||||||
24011 | 24011 | Emmet O’Neal O000089 | rep | KY | 1935-01-03 | 1937-01-03 | Democrat | 3 | |||||||||||||
24281 | 24281 | Ralph Brewster B000816 | rep | ME | 1935-01-03 | 1937-01-03 | Republican | 3 | |||||||||||||
24445 | 24445 | John Gwynne G000543 | rep | IA | 1935-01-03 | 1937-01-03 | Republican | 3 | |||||||||||||
24981 | 24981 | Joseph Pfeifer P000285 | rep | NY | 1935-01-03 | 1937-01-03 | Democrat | 3 | |||||||||||||
25090 | 25090 | William Whittington W000430 | rep | MS | 1935-01-03 | 1937-01-03 | Democrat | 3 | |||||||||||||
25492 | 25492 | Karl Stefan S000845 | rep | NE | 1935-01-03 | 1937-01-03 | Republican | 3 | |||||||||||||
26708 | 26708 | Graham Barden B000139 | rep | NC | 1935-01-03 | 1937-01-03 | Democrat | 3 | |||||||||||||
27048 | 27048 | Gardner Withrow W000663 | rep | WI | 1935-01-03 | 1937-01-03 | Progressive | 3 | |||||||||||||
21686 | 21686 | Cap Carden C000140 | rep | KY | 1935-01-03 | 1937-01-03 | Democrat | 4 | |||||||||||||
21690 | 21690 | William Carpenter C000173 | rep | KS | 1935-01-03 | 1937-01-03 | Democrat | 4 | |||||||||||||
21768 | 21768 | Percy Gassaway G000094 | rep | OK | 1935-01-03 | 1937-01-03 | Democrat | 4 | |||||||||||||
21838 | 21838 | Florence Kahn K000002 | rep | CA | 1935-01-03 | 1937-01-03 | Republican | 4 | |||||||||||||
21879 | 21879 | John McSwain M000604 | rep | SC | 1935-01-03 | 1937-01-03 | Democrat | 4 | |||||||||||||
21888 | 21888 | Schuyler Merritt M000663 | rep | CT | 1935-01-03 | 1937-01-03 | Republican | 4 | |||||||||||||
21958 | 21958 | John Sandlin S000043 | rep | LA | 1935-01-03 | 1937-01-03 | Democrat | 4 | |||||||||||||
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 | |||||||||||||
22087 | 22087 | Raymond Cannon C000124 | rep | WI | 1935-01-03 | 1937-01-03 | Democrat | 4 | |||||||||||||
22135 | 22135 | James Farley F000019 | rep | IN | 1935-01-03 | 1937-01-03 | Democrat | 4 | |||||||||||||
22245 | 22245 | Frank Kloeb K000271 | rep | OH | 1935-01-03 | 1937-01-03 | Democrat | 4 | |||||||||||||
22289 | 22289 | Gabriel Mahon M000064 | rep | SC | 1935-01-03 | 1937-01-03 | Democrat | 4 | |||||||||||||
22314 | 22314 | John Mitchell M000823 | rep | TN | 1935-01-03 | 1937-01-03 | Democrat | 4 | |||||||||||||
22461 | 22461 | James Wilcox W000455 | rep | FL | 1935-01-03 | 1937-01-03 | Democrat | 4 | |||||||||||||
22530 | 22530 | William Cravens C000886 | rep | AR | 1935-01-03 | 1937-01-03 | Democrat | 4 | |||||||||||||
22545 | 22545 | John Daly D000014 | rep | PA | 1935-01-03 | 1937-01-03 | Democrat | 4 | |||||||||||||
22656 | 22656 | Ambrose Kennedy K000101 | rep | MD | 1935-01-03 | 1937-01-03 | Democrat | 4 | |||||||||||||
22739 | 22739 | Emmett Owen O000149 | rep | GA | 1935-01-03 | 1937-01-03 | Democrat | 4 | |||||||||||||
22863 | 22863 | Harry Beam B000274 | rep | IL | 1935-01-03 | 1937-01-03 | Democrat | 4 | |||||||||||||
23000 | 23000 | Aaron Ford F000258 | rep | MS | 1935-01-03 | 1937-01-03 | Democrat | 4 | |||||||||||||
23038 | 23038 | Knute Hill H000600 | rep | WA | 1935-01-03 | 1937-01-03 | Democrat | 4 | |||||||||||||
23068 | 23068 | George Johnson J000132 | rep | WV | 1935-01-03 | 1937-01-03 | Democrat | 4 | |||||||||||||
23283 | 23283 | Edward Taylor T000072 | rep | CO | 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);