legislator_terms
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
502 rows where "end" is on date 1931-03-03 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
19636 | 19636 | Louis Cramton C000870 | rep | MI | 1929-04-15 | 1931-03-03 | Republican | 7 | |||||||||||||
20269 | 20269 | Charles Crisp C000909 | rep | GA | 1929-04-15 | 1931-03-03 | Democrat | 3 | |||||||||||||
21731 | 21731 | Oliver Cross C000931 | rep | TX | 1929-04-15 | 1931-03-03 | Democrat | 11 | |||||||||||||
25645 | 25645 | Robert Crosser C000932 | rep | OH | 1929-04-15 | 1931-03-03 | Democrat | 21 | |||||||||||||
22950 | 22950 | Frank Crowther C000948 | rep | NY | 1929-04-15 | 1931-03-03 | Republican | 30 | |||||||||||||
23386 | 23386 | Francis Culkin C000968 | rep | NY | 1929-04-15 | 1931-03-03 | Republican | 32 | |||||||||||||
23399 | 23399 | Thomas Cullen C000970 | rep | NY | 1929-04-15 | 1931-03-03 | Democrat | 4 | |||||||||||||
19645 | 19645 | Charles Curry C001000 | rep | CA | 1929-04-15 | 1931-03-03 | Republican | 3 | |||||||||||||
20279 | 20279 | Frederick Dallinger D000012 | rep | MA | 1929-04-15 | 1931-03-03 | Republican | 8 | |||||||||||||
22556 | 22556 | George Darrow D000063 | rep | PA | 1929-04-15 | 1931-03-03 | Republican | 7 | |||||||||||||
20283 | 20283 | Frederick Davenport D000070 | rep | NY | 1929-04-15 | 1931-03-03 | Republican | 33 | |||||||||||||
20336 | 20336 | Félix Dávila D000090 | rep | PR | 1929-04-15 | 1931-03-03 | Unionist | 0 | |||||||||||||
20290 | 20290 | Ewin Davis D000098 | rep | TN | 1929-04-15 | 1931-03-03 | Democrat | 5 | |||||||||||||
19656 | 19656 | Stephen Dempsey D000229 | rep | NY | 1929-04-15 | 1931-03-03 | Republican | 40 | |||||||||||||
18931 | 18931 | Charles Deneen D000233 | sen | IL | 1925-12-07 | 1931-03-03 | 2 | Republican | |||||||||||||
19664 | 19664 | Edward Denison D000237 | rep | IL | 1929-04-15 | 1931-03-03 | Republican | 25 | |||||||||||||
21220 | 21220 | Oscar De Priest D000263 | rep | IL | 1929-04-15 | 1931-03-03 | Republican | 1 | |||||||||||||
22565 | 22565 | René De Rouen D000265 | rep | LA | 1929-04-15 | 1931-03-03 | Democrat | 7 | |||||||||||||
20298 | 20298 | Lester Dickinson D000323 | rep | IA | 1929-04-15 | 1931-03-03 | Republican | 10 | |||||||||||||
23829 | 23829 | Samuel Dickstein D000335 | rep | NY | 1929-04-15 | 1931-03-03 | Democrat | 12 | |||||||||||||
20306 | 20306 | Frederick Dominick D000408 | rep | SC | 1929-04-15 | 1931-03-03 | Democrat | 3 | |||||||||||||
19669 | 19669 | John Dorsey D000440 | rep | KY | 1929-04-15 | 1931-03-03 | Democrat | 2 | |||||||||||||
25222 | 25222 | Robert Doughton D000448 | rep | NC | 1929-04-15 | 1931-03-03 | Democrat | 8 | |||||||||||||
20309 | 20309 | Lewis Douglas D000455 | rep | AZ | 1929-04-15 | 1931-03-03 | Democrat | 0 | |||||||||||||
21238 | 21238 | John Douglass D000459 | rep | MA | 1929-04-15 | 1931-03-03 | Democrat | 10 | |||||||||||||
21743 | 21743 | Isaac Doutrich D000460 | rep | PA | 1929-04-15 | 1931-03-03 | Republican | 19 | |||||||||||||
22578 | 22578 | Cassius Dowell D000468 | rep | IA | 1929-04-15 | 1931-03-03 | Republican | 7 | |||||||||||||
22963 | 22963 | Wall Doxey D000480 | rep | MS | 1929-04-15 | 1931-03-03 | Democrat | 2 | |||||||||||||
19673 | 19673 | Thomas Doyle D000483 | rep | IL | 1929-04-15 | 1931-03-03 | Democrat | 4 | |||||||||||||
20317 | 20317 | Herbert Drane D000486 | rep | FL | 1929-04-15 | 1931-03-03 | Democrat | 1 | |||||||||||||
24359 | 24359 | Patrick Drewry D000496 | rep | VA | 1929-04-15 | 1931-03-03 | Democrat | 4 | |||||||||||||
22121 | 22121 | William Driver D000503 | rep | AR | 1929-04-15 | 1931-03-03 | Democrat | 1 | |||||||||||||
19676 | 19676 | James Dunbar D000525 | rep | IN | 1929-04-15 | 1931-03-03 | Republican | 3 | |||||||||||||
20328 | 20328 | Leonidas Dyer D000591 | rep | MO | 1929-04-15 | 1931-03-03 | Republican | 12 | |||||||||||||
25237 | 25237 | Charles Eaton E000023 | rep | NJ | 1929-04-15 | 1931-03-03 | Republican | 4 | |||||||||||||
20338 | 20338 | William Eaton E000027 | rep | CO | 1929-04-15 | 1931-03-03 | Republican | 1 | |||||||||||||
20347 | 20347 | Charles Edwards E000062 | rep | GA | 1929-04-15 | 1931-03-03 | Democrat | 1 | |||||||||||||
19683 | 19683 | Richard Elliott E000127 | rep | IN | 1929-04-15 | 1931-03-03 | Republican | 6 | |||||||||||||
19688 | 19688 | Edgar Ellis E000133 | rep | MO | 1929-04-15 | 1931-03-03 | Republican | 5 | |||||||||||||
23443 | 23443 | Harry Englebright E000182 | rep | CA | 1929-04-15 | 1931-03-03 | Republican | 2 | |||||||||||||
20349 | 20349 | Edmund Erk E000203 | rep | PA | 1929-04-15 | 1931-03-03 | Republican | 32 | |||||||||||||
20353 | 20353 | Edward Eslick E000216 | rep | TN | 1929-04-15 | 1931-03-03 | Democrat | 7 | |||||||||||||
20357 | 20357 | Harry Estep E000221 | rep | PA | 1929-04-15 | 1931-03-03 | Republican | 35 | |||||||||||||
19690 | 19690 | Charles Esterly E000222 | rep | PA | 1929-04-15 | 1931-03-03 | Republican | 14 | |||||||||||||
20366 | 20366 | John Evans E000247 | rep | MT | 1929-04-15 | 1931-03-03 | Democrat | 1 | |||||||||||||
21255 | 21255 | William Evans E000261 | rep | CA | 1929-04-15 | 1931-03-03 | Republican | 9 | |||||||||||||
19695 | 19695 | Edward Fenn F000072 | rep | CT | 1929-04-15 | 1931-03-03 | Republican | 1 | |||||||||||||
20368 | 20368 | Charles Finley F000130 | rep | KY | 1929-04-15 | 1931-03-03 | Republican | 11 | |||||||||||||
23458 | 23458 | Hamilton Fish F000142 | rep | NY | 1929-04-15 | 1931-03-03 | Republican | 26 | |||||||||||||
19709 | 19709 | Hubert Fisher F000149 | rep | TN | 1929-04-15 | 1931-03-03 | Democrat | 10 | |||||||||||||
19714 | 19714 | Roy Fitzgerald F000166 | rep | OH | 1929-04-15 | 1931-03-03 | Republican | 3 | |||||||||||||
23467 | 23467 | James Fitzpatrick F000175 | rep | NY | 1929-04-15 | 1931-03-03 | Democrat | 24 | |||||||||||||
19717 | 19717 | Franklin Fort F000287 | rep | NJ | 1929-04-15 | 1931-03-03 | Republican | 9 | |||||||||||||
21266 | 21266 | Frank Foss F000294 | rep | MA | 1929-04-15 | 1931-03-03 | Republican | 3 | |||||||||||||
21278 | 21278 | James Frear F000355 | rep | WI | 1929-04-15 | 1931-03-03 | Republican | 10 | |||||||||||||
20376 | 20376 | Arthur Free F000359 | rep | CA | 1929-04-15 | 1931-03-03 | Republican | 8 | |||||||||||||
20385 | 20385 | Richard Freeman F000366 | rep | CT | 1929-04-15 | 1931-03-03 | Republican | 2 | |||||||||||||
20398 | 20398 | Burton French F000375 | rep | ID | 1929-04-15 | 1931-03-03 | Republican | 1 | |||||||||||||
22156 | 22156 | Claude Fuller F000408 | rep | AR | 1929-04-15 | 1931-03-03 | Democrat | 3 | |||||||||||||
23485 | 23485 | Hampton Fulmer F000417 | rep | SC | 1929-04-15 | 1931-03-03 | Democrat | 7 | |||||||||||||
19723 | 19723 | Isauro Gabaldon G000001 | rep | PI | 1929-04-15 | 1931-03-03 | 0 | ||||||||||||||
22164 | 22164 | Stephen Gambrill G000035 | rep | MD | 1929-04-15 | 1931-03-03 | Democrat | 5 | |||||||||||||
19724 | 19724 | Jacob Garber G000045 | rep | VA | 1929-04-15 | 1931-03-03 | Republican | 7 | |||||||||||||
20406 | 20406 | Milton Garber G000046 | rep | OK | 1929-04-15 | 1931-03-03 | Republican | 8 | |||||||||||||
21294 | 21294 | John Garner G000074 | rep | TX | 1929-04-15 | 1931-03-03 | Democrat | 15 | |||||||||||||
20414 | 20414 | Daniel Garrett G000081 | rep | TX | 1929-04-15 | 1931-03-03 | Democrat | 8 | |||||||||||||
22172 | 22172 | Allard Gasque G000092 | rep | SC | 1929-04-15 | 1931-03-03 | Democrat | 6 | |||||||||||||
23497 | 23497 | Joseph Gavagan G000101 | rep | NY | 1929-04-15 | 1931-03-03 | Democrat | 21 | |||||||||||||
22609 | 22609 | Ernest Gibson G000158 | rep | VT | 1929-04-15 | 1931-03-03 | Republican | 2 | |||||||||||||
24417 | 24417 | Charles Gifford G000169 | rep | MA | 1929-04-15 | 1931-03-03 | Republican | 16 | |||||||||||||
18975 | 18975 | Frederick Gillett G000201 | sen | MA | 1925-12-07 | 1931-03-03 | 2 | Republican | |||||||||||||
23522 | 23522 | Carter Glass G000232 | sen | VA | 1925-12-07 | 1931-03-03 | 2 | Democrat | |||||||||||||
21298 | 21298 | David Glover G000243 | rep | AR | 1929-04-15 | 1931-03-03 | Democrat | 6 | |||||||||||||
19731 | 19731 | James Glynn G000246 | rep | CT | 1929-04-15 | 1931-03-03 | Republican | 5 | |||||||||||||
18976 | 18976 | Guy Goff G000254 | sen | WV | 1925-12-07 | 1931-03-03 | 2 | Republican | |||||||||||||
20424 | 20424 | Benjamin Golder G000259 | rep | PA | 1929-04-15 | 1931-03-03 | Republican | 4 | |||||||||||||
22617 | 22617 | Thomas Goldsborough G000265 | rep | MD | 1929-04-15 | 1931-03-03 | Democrat | 1 | |||||||||||||
20428 | 20428 | Godfrey Goodwin G000299 | rep | MN | 1929-04-15 | 1931-03-03 | Republican | 10 | |||||||||||||
21301 | 21301 | Edward Goss G000334 | rep | CT | 1929-04-15 | 1931-03-03 | Republican | 5 | |||||||||||||
19178 | 19178 | Arthur Gould G000340 | sen | ME | 1926-01-01 | 1931-03-03 | 2 | Republican | |||||||||||||
20442 | 20442 | George Graham G000354 | rep | PA | 1929-04-15 | 1931-03-03 | Republican | 2 | |||||||||||||
21769 | 21769 | William Granfield G000372 | rep | MA | 1929-04-15 | 1931-03-03 | Democrat | 2 | |||||||||||||
23528 | 23528 | Robert Green G000415 | rep | FL | 1929-04-15 | 1931-03-03 | Democrat | 2 | |||||||||||||
22197 | 22197 | Arthur Greenwood G000437 | rep | IN | 1929-04-15 | 1931-03-03 | Democrat | 2 | |||||||||||||
21776 | 21776 | William Gregory G000448 | rep | KY | 1929-04-15 | 1931-03-03 | Democrat | 1 | |||||||||||||
19751 | 19751 | William Griest G000456 | rep | PA | 1929-04-15 | 1931-03-03 | Republican | 10 | |||||||||||||
21786 | 21786 | Anthony Griffin G000457 | rep | NY | 1929-04-15 | 1931-03-03 | Democrat | 22 | |||||||||||||
19752 | 19752 | Joseph Grundy G000510 | sen | PA | 1929-12-11 | 1931-03-03 | 3 | Republican | appointment | ||||||||||||
21793 | 21793 | Pedro Guevara G000518 | rep | PI | 1929-04-15 | 1931-03-03 | 0 | ||||||||||||||
23538 | 23538 | Ulysses Guyer G000538 | rep | KS | 1929-04-15 | 1931-03-03 | Republican | 2 | |||||||||||||
20452 | 20452 | Lindley Hadley H000008 | rep | WA | 1929-04-15 | 1931-03-03 | Republican | 2 | |||||||||||||
20456 | 20456 | Fletcher Hale H000030 | rep | NH | 1929-04-15 | 1931-03-03 | Republican | 1 | |||||||||||||
19755 | 19755 | Albert Hall H000042 | rep | IN | 1929-04-15 | 1931-03-03 | Republican | 11 | |||||||||||||
20459 | 20459 | Homer Hall H000053 | rep | IL | 1929-04-15 | 1931-03-03 | Republican | 17 | |||||||||||||
20461 | 20461 | Robert Hall H000069 | rep | MS | 1929-04-15 | 1931-03-03 | Democrat | 6 | |||||||||||||
20466 | 20466 | Thomas Hall H000071 | rep | ND | 1929-04-15 | 1931-03-03 | Republican | 2 | |||||||||||||
19756 | 19756 | Thomas Halsey H000091 | rep | MO | 1929-04-15 | 1931-03-03 | Republican | 6 | |||||||||||||
19761 | 19761 | William Hammer H000123 | rep | NC | 1929-04-15 | 1931-03-03 | Democrat | 7 | |||||||||||||
23856 | 23856 | Clarence Hancock H000146 | rep | NY | 1929-04-15 | 1931-03-03 | Republican | 35 | |||||||||||||
22209 | 22209 | Franklin Hancock H000147 | rep | NC | 1929-04-15 | 1931-03-03 | Democrat | 5 |
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);