legislator_terms
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
485 rows where "start" is on date 1927-12-05 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
25644 | 25644 | Robert Crosser C000932 | rep | OH | 1927-12-05 | 1929-03-03 | Democrat | 21 | |||||||||||||
22949 | 22949 | Frank Crowther C000948 | rep | NY | 1927-12-05 | 1929-03-03 | Republican | 30 | |||||||||||||
19268 | 19268 | Maurice Crumpacker C000959 | rep | OR | 1927-12-05 | 1929-03-03 | Republican | -1 | |||||||||||||
23385 | 23385 | Francis Culkin C000968 | rep | NY | 1927-12-05 | 1929-03-03 | Republican | 32 | |||||||||||||
23398 | 23398 | Thomas Cullen C000970 | rep | NY | 1927-12-05 | 1929-03-03 | Democrat | 4 | |||||||||||||
19644 | 19644 | Charles Curry C001000 | rep | CA | 1927-12-05 | 1929-03-03 | Republican | 3 | |||||||||||||
19279 | 19279 | Charles Curtis C001008 | sen | KS | 1927-12-05 | 1929-12-31 | 3 | Republican | |||||||||||||
19285 | 19285 | Porter Dale D000009 | sen | VT | 1927-12-05 | 1933-03-03 | 3 | Republican | |||||||||||||
20278 | 20278 | Frederick Dallinger D000012 | rep | MA | 1927-12-05 | 1929-03-03 | Republican | 8 | |||||||||||||
22555 | 22555 | George Darrow D000063 | rep | PA | 1927-12-05 | 1929-03-03 | Republican | 7 | |||||||||||||
20282 | 20282 | Frederick Davenport D000070 | rep | NY | 1927-12-05 | 1929-03-03 | Republican | 33 | |||||||||||||
19290 | 19290 | Martin Davey D000080 | rep | OH | 1927-12-05 | 1929-03-03 | Democrat | 14 | |||||||||||||
20335 | 20335 | Félix Dávila D000090 | rep | PR | 1927-12-05 | 1929-03-03 | Unionist | 0 | |||||||||||||
20289 | 20289 | Ewin Davis D000098 | rep | TN | 1927-12-05 | 1929-03-03 | Democrat | 5 | |||||||||||||
19294 | 19294 | Joseph Deal D000169 | rep | VA | 1927-12-05 | 1929-03-03 | Democrat | 2 | |||||||||||||
19655 | 19655 | Stephen Dempsey D000229 | rep | NY | 1927-12-05 | 1929-03-03 | Republican | 40 | |||||||||||||
19663 | 19663 | Edward Denison D000237 | rep | IL | 1927-12-05 | 1929-03-03 | Republican | 25 | |||||||||||||
22564 | 22564 | René De Rouen D000265 | rep | LA | 1927-12-05 | 1929-03-03 | Democrat | 7 | |||||||||||||
21231 | 21231 | Clement Dickinson D000316 | rep | MO | 1927-12-05 | 1929-03-03 | Democrat | 6 | |||||||||||||
20297 | 20297 | Lester Dickinson D000323 | rep | IA | 1927-12-05 | 1929-03-03 | Republican | 10 | |||||||||||||
23828 | 23828 | Samuel Dickstein D000335 | rep | NY | 1927-12-05 | 1929-03-03 | Democrat | 12 | |||||||||||||
20305 | 20305 | Frederick Dominick D000408 | rep | SC | 1927-12-05 | 1929-03-03 | Democrat | 3 | |||||||||||||
25221 | 25221 | Robert Doughton D000448 | rep | NC | 1927-12-05 | 1929-03-03 | Democrat | 8 | |||||||||||||
20308 | 20308 | Lewis Douglas D000455 | rep | AZ | 1927-12-05 | 1929-03-03 | Democrat | 0 | |||||||||||||
21237 | 21237 | John Douglass D000459 | rep | MA | 1927-12-05 | 1929-03-03 | Democrat | 10 | |||||||||||||
21742 | 21742 | Isaac Doutrich D000460 | rep | PA | 1927-12-05 | 1929-03-03 | Republican | 19 | |||||||||||||
22577 | 22577 | Cassius Dowell D000468 | rep | IA | 1927-12-05 | 1929-03-03 | Republican | 7 | |||||||||||||
19672 | 19672 | Thomas Doyle D000483 | rep | IL | 1927-12-05 | 1929-03-03 | Democrat | 4 | |||||||||||||
20316 | 20316 | Herbert Drane D000486 | rep | FL | 1927-12-05 | 1929-03-03 | Democrat | 1 | |||||||||||||
24358 | 24358 | Patrick Drewry D000496 | rep | VA | 1927-12-05 | 1929-03-03 | Democrat | 4 | |||||||||||||
22120 | 22120 | William Driver D000503 | rep | AR | 1927-12-05 | 1929-03-03 | Democrat | 1 | |||||||||||||
20327 | 20327 | Leonidas Dyer D000591 | rep | MO | 1927-12-05 | 1929-03-03 | Republican | 12 | |||||||||||||
25236 | 25236 | Charles Eaton E000023 | rep | NJ | 1927-12-05 | 1929-03-03 | Republican | 4 | |||||||||||||
20346 | 20346 | Charles Edwards E000062 | rep | GA | 1927-12-05 | 1929-03-03 | Democrat | 1 | |||||||||||||
19682 | 19682 | Richard Elliott E000127 | rep | IN | 1927-12-05 | 1929-03-03 | Republican | 6 | |||||||||||||
19295 | 19295 | Edward England E000180 | rep | WV | 1927-12-05 | 1929-03-03 | Republican | 6 | |||||||||||||
23442 | 23442 | Harry Englebright E000182 | rep | CA | 1927-12-05 | 1929-03-03 | Republican | 2 | |||||||||||||
20352 | 20352 | Edward Eslick E000216 | rep | TN | 1927-12-05 | 1929-03-03 | Democrat | 7 | |||||||||||||
20356 | 20356 | Harry Estep E000221 | rep | PA | 1927-12-05 | 1929-03-03 | Republican | 35 | |||||||||||||
20365 | 20365 | John Evans E000247 | rep | MT | 1927-12-05 | 1929-03-03 | Democrat | 1 | |||||||||||||
21254 | 21254 | William Evans E000261 | rep | CA | 1927-12-05 | 1929-03-03 | Republican | 9 | |||||||||||||
19299 | 19299 | Charles Faust F000047 | rep | MO | 1927-12-05 | 1929-03-03 | Republican | 4 | |||||||||||||
19694 | 19694 | Edward Fenn F000072 | rep | CT | 1927-12-05 | 1929-03-03 | Republican | 1 | |||||||||||||
23457 | 23457 | Hamilton Fish F000142 | rep | NY | 1927-12-05 | 1929-03-03 | Republican | 26 | |||||||||||||
19708 | 19708 | Hubert Fisher F000149 | rep | TN | 1927-12-05 | 1929-03-03 | Democrat | 10 | |||||||||||||
19713 | 19713 | Roy Fitzgerald F000166 | rep | OH | 1927-12-05 | 1929-03-03 | Republican | 3 | |||||||||||||
19301 | 19301 | William Fitzgerald F000170 | rep | OH | 1927-12-05 | 1929-03-03 | Republican | 4 | |||||||||||||
23466 | 23466 | James Fitzpatrick F000175 | rep | NY | 1927-12-05 | 1929-03-03 | Democrat | 24 | |||||||||||||
21262 | 21262 | Duncan Fletcher F000200 | sen | FL | 1927-12-05 | 1933-03-03 | 3 | Democrat | |||||||||||||
22139 | 22139 | Thomas Fletcher F000205 | rep | OH | 1927-12-05 | 1929-03-03 | Democrat | 8 | |||||||||||||
19716 | 19716 | Franklin Fort F000287 | rep | NJ | 1927-12-05 | 1929-03-03 | Republican | 9 | |||||||||||||
21265 | 21265 | Frank Foss F000294 | rep | MA | 1927-12-05 | 1929-03-03 | Republican | 3 | |||||||||||||
21277 | 21277 | James Frear F000355 | rep | WI | 1927-12-05 | 1929-03-03 | Republican | 10 | |||||||||||||
20375 | 20375 | Arthur Free F000359 | rep | CA | 1927-12-05 | 1929-03-03 | Republican | 8 | |||||||||||||
20384 | 20384 | Richard Freeman F000366 | rep | CT | 1927-12-05 | 1929-03-03 | Republican | 2 | |||||||||||||
20397 | 20397 | Burton French F000375 | rep | ID | 1927-12-05 | 1929-03-03 | Republican | 1 | |||||||||||||
19305 | 19305 | Louis Frothingham F000395 | rep | MA | 1927-12-05 | 1929-03-03 | Republican | 14 | |||||||||||||
20401 | 20401 | James Fulbright F000400 | rep | MO | 1927-12-05 | 1929-03-03 | Democrat | 14 | |||||||||||||
23484 | 23484 | Hampton Fulmer F000417 | rep | SC | 1927-12-05 | 1929-03-03 | Democrat | 7 | |||||||||||||
19307 | 19307 | Allen Furlow F000433 | rep | MN | 1927-12-05 | 1929-03-03 | Republican | 1 | |||||||||||||
19722 | 19722 | Isauro Gabaldon G000001 | rep | PI | 1927-12-05 | 1929-03-03 | 0 | ||||||||||||||
19315 | 19315 | James Gallivan G000024 | rep | MA | 1927-12-05 | 1929-03-03 | Democrat | 12 | |||||||||||||
22163 | 22163 | Stephen Gambrill G000035 | rep | MD | 1927-12-05 | 1929-03-03 | Democrat | 5 | |||||||||||||
20405 | 20405 | Milton Garber G000046 | rep | OK | 1927-12-05 | 1929-03-03 | Republican | 8 | |||||||||||||
19318 | 19318 | Frank Gardner G000053 | rep | IN | 1927-12-05 | 1929-03-03 | Democrat | 3 | |||||||||||||
21293 | 21293 | John Garner G000074 | rep | TX | 1927-12-05 | 1929-03-03 | Democrat | 15 | |||||||||||||
20413 | 20413 | Daniel Garrett G000081 | rep | TX | 1927-12-05 | 1929-03-03 | Democrat | 8 | |||||||||||||
19330 | 19330 | Finis Garrett G000082 | rep | TN | 1927-12-05 | 1929-03-03 | Democrat | 9 | |||||||||||||
22171 | 22171 | Allard Gasque G000092 | rep | SC | 1927-12-05 | 1929-03-03 | Democrat | 6 | |||||||||||||
25267 | 25267 | Walter George G000131 | sen | GA | 1927-12-05 | 1933-03-03 | 3 | Democrat | |||||||||||||
22608 | 22608 | Ernest Gibson G000158 | rep | VT | 1927-12-05 | 1929-03-03 | Republican | 2 | |||||||||||||
24416 | 24416 | Charles Gifford G000169 | rep | MA | 1927-12-05 | 1929-03-03 | Republican | 16 | |||||||||||||
20419 | 20419 | Ralph Gilbert G000177 | rep | KY | 1927-12-05 | 1929-03-03 | Democrat | 8 | |||||||||||||
19730 | 19730 | James Glynn G000246 | rep | CT | 1927-12-05 | 1929-03-03 | Republican | 5 | |||||||||||||
20423 | 20423 | Benjamin Golder G000259 | rep | PA | 1927-12-05 | 1929-03-03 | Republican | 4 | |||||||||||||
22616 | 22616 | Thomas Goldsborough G000265 | rep | MD | 1927-12-05 | 1929-03-03 | Democrat | 1 | |||||||||||||
19332 | 19332 | Frank Gooding G000288 | sen | ID | 1927-12-05 | 1929-03-03 | 3 | Republican | |||||||||||||
20427 | 20427 | Godfrey Goodwin G000299 | rep | MN | 1927-12-05 | 1929-03-03 | Republican | 10 | |||||||||||||
20441 | 20441 | George Graham G000354 | rep | PA | 1927-12-05 | 1929-03-03 | Republican | 2 | |||||||||||||
23527 | 23527 | Robert Green G000415 | rep | FL | 1927-12-05 | 1929-03-03 | Democrat | 2 | |||||||||||||
19341 | 19341 | William Green G000422 | rep | IA | 1927-12-05 | 1929-03-03 | Republican | 9 | |||||||||||||
22196 | 22196 | Arthur Greenwood G000437 | rep | IN | 1927-12-05 | 1929-03-03 | Democrat | 2 | |||||||||||||
21775 | 21775 | William Gregory G000448 | rep | KY | 1927-12-05 | 1929-03-03 | Democrat | 1 | |||||||||||||
19750 | 19750 | William Griest G000456 | rep | PA | 1927-12-05 | 1929-03-03 | Republican | 10 | |||||||||||||
21785 | 21785 | Anthony Griffin G000457 | rep | NY | 1927-12-05 | 1929-03-03 | Democrat | 22 | |||||||||||||
21792 | 21792 | Pedro Guevara G000518 | rep | PI | 1927-12-05 | 1929-03-03 | 0 | ||||||||||||||
23537 | 23537 | Ulysses Guyer G000538 | rep | KS | 1927-12-05 | 1929-03-03 | Republican | 2 | |||||||||||||
20451 | 20451 | Lindley Hadley H000008 | rep | WA | 1927-12-05 | 1929-03-03 | Republican | 2 | |||||||||||||
20455 | 20455 | Fletcher Hale H000030 | rep | NH | 1927-12-05 | 1929-03-03 | Republican | 1 | |||||||||||||
19754 | 19754 | Albert Hall H000042 | rep | IN | 1927-12-05 | 1929-03-03 | Republican | 11 | |||||||||||||
20458 | 20458 | Homer Hall H000053 | rep | IL | 1927-12-05 | 1929-03-03 | Republican | 17 | |||||||||||||
20465 | 20465 | Thomas Hall H000071 | rep | ND | 1927-12-05 | 1929-03-03 | Republican | 2 | |||||||||||||
19760 | 19760 | William Hammer H000123 | rep | NC | 1927-12-05 | 1929-03-03 | Democrat | 7 | |||||||||||||
23855 | 23855 | Clarence Hancock H000146 | rep | NY | 1927-12-05 | 1929-03-03 | Republican | 35 | |||||||||||||
20472 | 20472 | Guy Hardy H000195 | rep | CO | 1927-12-05 | 1929-03-03 | Republican | 3 | |||||||||||||
23866 | 23866 | Butler Hare H000200 | rep | SC | 1927-12-05 | 1929-03-03 | Democrat | 2 | |||||||||||||
19348 | 19348 | Thomas Harrison H000277 | rep | VA | 1927-12-05 | 1929-03-03 | Democrat | 7 | |||||||||||||
21311 | 21311 | William Hastings H000333 | rep | OK | 1927-12-05 | 1929-03-03 | Democrat | 2 | |||||||||||||
20494 | 20494 | Gilbert Haugen H000350 | rep | IA | 1927-12-05 | 1929-03-03 | Republican | 4 | |||||||||||||
19183 | 19183 | Harry Hawes H000362 | sen | MO | 1927-12-05 | 1933-02-03 | 3 | Democrat |
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);