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 1931-12-07 sorted by legislator_id
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
21216 | 21216 | James Connolly C000698 | rep | PA | 1931-12-07 | 1933-03-03 | Republican | 5 | |||||||||||||
20229 | 20229 | Edmund Cooke C000730 | rep | NY | 1931-12-07 | 1933-03-03 | Republican | 41 | |||||||||||||
20230 | 20230 | Marcus Coolidge C000740 | sen | MA | 1931-12-07 | 1937-01-03 | 2 | Democrat | |||||||||||||
20249 | 20249 | Henry Cooper C000752 | rep | WI | 1931-12-07 | 1933-03-03 | Republican | -1 | |||||||||||||
26251 | 26251 | Jere Cooper C000755 | rep | TN | 1931-12-07 | 1933-03-03 | Democrat | 9 | |||||||||||||
21718 | 21718 | John Cooper C000757 | rep | OH | 1931-12-07 | 1933-03-03 | Republican | 19 | |||||||||||||
21728 | 21728 | Parker Corning C000785 | rep | NY | 1931-12-07 | 1933-03-03 | Democrat | 28 | |||||||||||||
20250 | 20250 | Edward Costigan C000797 | sen | CO | 1931-12-07 | 1937-01-03 | 2 | Democrat | |||||||||||||
20253 | 20253 | James Couzens C000812 | sen | MI | 1931-12-07 | 1936-10-22 | 2 | Republican | |||||||||||||
25192 | 25192 | Edward Cox C000831 | rep | GA | 1931-12-07 | 1933-03-03 | Democrat | 2 | |||||||||||||
20256 | 20256 | William Coyle C000844 | rep | PA | 1931-12-07 | 1933-03-03 | Republican | 30 | |||||||||||||
20259 | 20259 | Joe Crail C000864 | rep | CA | 1931-12-07 | 1933-03-03 | Republican | 10 | |||||||||||||
20270 | 20270 | Charles Crisp C000909 | rep | GA | 1931-12-07 | 1933-03-03 | Democrat | 3 | |||||||||||||
21732 | 21732 | Oliver Cross C000931 | rep | TX | 1931-12-07 | 1933-03-03 | Democrat | 11 | |||||||||||||
25646 | 25646 | Robert Crosser C000932 | rep | OH | 1931-12-07 | 1933-03-03 | Democrat | 21 | |||||||||||||
22533 | 22533 | Eugene Crowe C000940 | rep | IN | 1931-12-07 | 1933-03-03 | Democrat | 3 | |||||||||||||
22951 | 22951 | Frank Crowther C000948 | rep | NY | 1931-12-07 | 1933-03-03 | Republican | 30 | |||||||||||||
21218 | 21218 | Edward Crump C000955 | rep | TN | 1931-12-07 | 1933-03-03 | Democrat | 10 | |||||||||||||
23387 | 23387 | Francis Culkin C000968 | rep | NY | 1931-12-07 | 1933-03-03 | Republican | 32 | |||||||||||||
23400 | 23400 | Thomas Cullen C000970 | rep | NY | 1931-12-07 | 1933-03-03 | Democrat | 4 | |||||||||||||
20271 | 20271 | Charles Curry C001001 | rep | CA | 1931-12-07 | 1933-03-03 | Republican | 3 | |||||||||||||
20280 | 20280 | Frederick Dallinger D000012 | rep | MA | 1931-12-07 | 1933-03-03 | Republican | 8 | |||||||||||||
22557 | 22557 | George Darrow D000063 | rep | PA | 1931-12-07 | 1933-03-03 | Republican | 7 | |||||||||||||
20284 | 20284 | Frederick Davenport D000070 | rep | NY | 1931-12-07 | 1933-03-03 | Republican | 33 | |||||||||||||
20337 | 20337 | Félix Dávila D000090 | rep | PR | 1931-12-07 | 1933-03-03 | Unionist | 0 | |||||||||||||
20291 | 20291 | Ewin Davis D000098 | rep | TN | 1931-12-07 | 1933-03-03 | Democrat | 5 | |||||||||||||
20292 | 20292 | Robert Davis D000129 | rep | PA | 1931-12-07 | 1933-03-03 | Republican | 6 | |||||||||||||
24340 | 24340 | John Delaney D000212 | rep | NY | 1931-12-07 | 1933-03-03 | Democrat | 7 | |||||||||||||
21221 | 21221 | Oscar De Priest D000263 | rep | IL | 1931-12-07 | 1933-03-03 | Republican | 1 | |||||||||||||
22566 | 22566 | René De Rouen D000265 | rep | LA | 1931-12-07 | 1933-03-03 | Democrat | 7 | |||||||||||||
21232 | 21232 | Clement Dickinson D000316 | rep | MO | 1931-12-07 | 1933-03-03 | Democrat | 6 | |||||||||||||
20299 | 20299 | Lester Dickinson D000323 | sen | IA | 1931-12-07 | 1937-01-03 | 2 | Republican | |||||||||||||
23830 | 23830 | Samuel Dickstein D000335 | rep | NY | 1931-12-07 | 1933-03-03 | Democrat | 12 | |||||||||||||
26300 | 26300 | Martin Dies D000338 | rep | TX | 1931-12-07 | 1933-03-03 | Democrat | 2 | |||||||||||||
21234 | 21234 | William Dieterich D000339 | rep | IL | 1931-12-07 | 1933-03-03 | Democrat | -1 | |||||||||||||
23418 | 23418 | Wesley Disney D000362 | rep | OK | 1931-12-07 | 1933-03-03 | Democrat | 1 | |||||||||||||
20307 | 20307 | Frederick Dominick D000408 | rep | SC | 1931-12-07 | 1933-03-03 | Democrat | 3 | |||||||||||||
25223 | 25223 | Robert Doughton D000448 | rep | NC | 1931-12-07 | 1933-03-03 | Democrat | 8 | |||||||||||||
20310 | 20310 | Lewis Douglas D000455 | rep | AZ | 1931-12-07 | 1933-03-03 | Democrat | 0 | |||||||||||||
21239 | 21239 | John Douglass D000459 | rep | MA | 1931-12-07 | 1933-03-03 | Democrat | 10 | |||||||||||||
21744 | 21744 | Isaac Doutrich D000460 | rep | PA | 1931-12-07 | 1933-03-03 | Republican | 19 | |||||||||||||
22579 | 22579 | Cassius Dowell D000468 | rep | IA | 1931-12-07 | 1933-03-03 | Republican | 7 | |||||||||||||
22964 | 22964 | Wall Doxey D000480 | rep | MS | 1931-12-07 | 1933-03-03 | Democrat | 2 | |||||||||||||
20318 | 20318 | Herbert Drane D000486 | rep | FL | 1931-12-07 | 1933-03-03 | Democrat | 1 | |||||||||||||
24360 | 24360 | Patrick Drewry D000496 | rep | VA | 1931-12-07 | 1933-03-03 | Democrat | 4 | |||||||||||||
22122 | 22122 | William Driver D000503 | rep | AR | 1931-12-07 | 1933-03-03 | Democrat | 1 | |||||||||||||
20329 | 20329 | Leonidas Dyer D000591 | rep | MO | 1931-12-07 | 1933-03-03 | Republican | 12 | |||||||||||||
21756 | 21756 | Joe Eagle E000003 | rep | TX | 1931-12-07 | 1933-03-03 | Democrat | 8 | |||||||||||||
25238 | 25238 | Charles Eaton E000023 | rep | NJ | 1931-12-07 | 1933-03-03 | Republican | 4 | |||||||||||||
20339 | 20339 | William Eaton E000027 | rep | CO | 1931-12-07 | 1933-03-03 | Republican | 1 | |||||||||||||
20348 | 20348 | Charles Edwards E000062 | rep | GA | 1931-12-07 | 1933-03-03 | Democrat | 1 | |||||||||||||
21250 | 21250 | Lawrence Ellzey E000152 | rep | MS | 1931-12-07 | 1933-03-03 | Democrat | 7 | |||||||||||||
23444 | 23444 | Harry Englebright E000182 | rep | CA | 1931-12-07 | 1933-03-03 | Republican | 2 | |||||||||||||
20350 | 20350 | Edmund Erk E000203 | rep | PA | 1931-12-07 | 1933-03-03 | Republican | 32 | |||||||||||||
20354 | 20354 | Edward Eslick E000216 | rep | TN | 1931-12-07 | 1933-03-03 | Democrat | 7 | |||||||||||||
20355 | 20355 | Willa Eslick E000217 | rep | TN | 1931-12-07 | 1933-03-03 | Democrat | 7 | |||||||||||||
20358 | 20358 | Harry Estep E000221 | rep | PA | 1931-12-07 | 1933-03-03 | Republican | 35 | |||||||||||||
20367 | 20367 | John Evans E000247 | rep | MT | 1931-12-07 | 1933-03-03 | Democrat | 1 | |||||||||||||
21256 | 21256 | William Evans E000261 | rep | CA | 1931-12-07 | 1933-03-03 | Republican | 9 | |||||||||||||
22594 | 22594 | Joachim Fernández F000086 | rep | LA | 1931-12-07 | 1933-03-03 | Democrat | 1 | |||||||||||||
21762 | 21762 | William Fiesinger F000114 | rep | OH | 1931-12-07 | 1933-03-03 | Democrat | 13 | |||||||||||||
20369 | 20369 | Charles Finley F000130 | rep | KY | 1931-12-07 | 1933-03-03 | Republican | 11 | |||||||||||||
23459 | 23459 | Hamilton Fish F000142 | rep | NY | 1931-12-07 | 1933-03-03 | Republican | 26 | |||||||||||||
20370 | 20370 | John Fishburne F000143 | rep | VA | 1931-12-07 | 1933-03-03 | Democrat | 7 | |||||||||||||
23468 | 23468 | James Fitzpatrick F000175 | rep | NY | 1931-12-07 | 1933-03-03 | Democrat | 24 | |||||||||||||
24381 | 24381 | John Flannagan F000191 | rep | VA | 1931-12-07 | 1933-03-03 | Democrat | 9 | |||||||||||||
20371 | 20371 | Joel Flood F000211 | rep | VA | 1931-12-07 | 1933-03-03 | Democrat | 10 | |||||||||||||
21267 | 21267 | Frank Foss F000294 | rep | MA | 1931-12-07 | 1933-03-03 | Republican | 3 | |||||||||||||
21279 | 21279 | James Frear F000355 | rep | WI | 1931-12-07 | 1933-03-03 | Republican | 10 | |||||||||||||
20377 | 20377 | Arthur Free F000359 | rep | CA | 1931-12-07 | 1933-03-03 | Republican | 8 | |||||||||||||
20386 | 20386 | Richard Freeman F000366 | rep | CT | 1931-12-07 | 1933-03-03 | Republican | 2 | |||||||||||||
20399 | 20399 | Burton French F000375 | rep | ID | 1931-12-07 | 1933-03-03 | Republican | 1 | |||||||||||||
20402 | 20402 | James Fulbright F000400 | rep | MO | 1931-12-07 | 1933-03-03 | Democrat | 14 | |||||||||||||
22157 | 22157 | Claude Fuller F000408 | rep | AR | 1931-12-07 | 1933-03-03 | Democrat | 3 | |||||||||||||
23486 | 23486 | Hampton Fulmer F000417 | rep | SC | 1931-12-07 | 1933-03-03 | Democrat | 7 | |||||||||||||
22165 | 22165 | Stephen Gambrill G000035 | rep | MD | 1931-12-07 | 1933-03-03 | Democrat | 5 | |||||||||||||
20407 | 20407 | Milton Garber G000046 | rep | OK | 1931-12-07 | 1933-03-03 | Republican | 8 | |||||||||||||
21295 | 21295 | John Garner G000074 | rep | TX | 1931-12-07 | 1933-03-03 | Democrat | 15 | |||||||||||||
20415 | 20415 | Daniel Garrett G000081 | rep | TX | 1931-12-07 | 1933-03-03 | Democrat | 8 | |||||||||||||
22173 | 22173 | Allard Gasque G000092 | rep | SC | 1931-12-07 | 1933-03-03 | Democrat | 6 | |||||||||||||
23498 | 23498 | Joseph Gavagan G000101 | rep | NY | 1931-12-07 | 1933-03-03 | Democrat | 21 | |||||||||||||
22610 | 22610 | Ernest Gibson G000158 | rep | VT | 1931-12-07 | 1933-03-03 | Republican | 2 | |||||||||||||
24418 | 24418 | Charles Gifford G000169 | rep | MA | 1931-12-07 | 1933-03-03 | Republican | 16 | |||||||||||||
20420 | 20420 | Ralph Gilbert G000177 | rep | KY | 1931-12-07 | 1933-03-03 | Democrat | 8 | |||||||||||||
23505 | 23505 | Fred Gilchrist G000181 | rep | IA | 1931-12-07 | 1933-03-03 | Republican | 10 | |||||||||||||
20421 | 20421 | Courtland Gillen G000193 | rep | IN | 1931-12-07 | 1933-03-03 | Democrat | 5 | |||||||||||||
23523 | 23523 | Carter Glass G000232 | sen | VA | 1931-12-07 | 1937-01-03 | 2 | Democrat | |||||||||||||
21299 | 21299 | David Glover G000243 | rep | AR | 1931-12-07 | 1933-03-03 | Democrat | 6 | |||||||||||||
20425 | 20425 | Benjamin Golder G000259 | rep | PA | 1931-12-07 | 1933-03-03 | Republican | 4 | |||||||||||||
22618 | 22618 | Thomas Goldsborough G000265 | rep | MD | 1931-12-07 | 1933-03-03 | Democrat | 1 | |||||||||||||
20429 | 20429 | Godfrey Goodwin G000299 | rep | MN | 1931-12-07 | 1933-03-03 | Republican | 10 | |||||||||||||
20433 | 20433 | Thomas Gore G000323 | sen | OK | 1931-12-07 | 1937-01-03 | 2 | Democrat | |||||||||||||
21302 | 21302 | Edward Goss G000334 | rep | CT | 1931-12-07 | 1933-03-03 | Republican | 5 | |||||||||||||
20443 | 20443 | George Graham G000354 | rep | PA | 1931-12-07 | 1933-03-03 | Republican | 2 | |||||||||||||
20444 | 20444 | Peter Granata G000370 | rep | IL | 1931-12-07 | 1933-03-03 | Republican | 8 | |||||||||||||
21770 | 21770 | William Granfield G000372 | rep | MA | 1931-12-07 | 1933-03-03 | Democrat | 2 | |||||||||||||
23529 | 23529 | Robert Green G000415 | rep | FL | 1931-12-07 | 1933-03-03 | Democrat | 2 | |||||||||||||
22198 | 22198 | Arthur Greenwood G000437 | rep | IN | 1931-12-07 | 1933-03-03 | Democrat | 2 | |||||||||||||
21777 | 21777 | William Gregory G000448 | rep | KY | 1931-12-07 | 1933-03-03 | Democrat | 1 | |||||||||||||
21787 | 21787 | Anthony Griffin G000457 | rep | NY | 1931-12-07 | 1933-03-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);