legislator_terms
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
212 rows where party = "Democrat" and "start" is on date 1927-12-05
This data as json, copyable, CSV (advanced)
Suggested facets: type, end, district, end (date)
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
19183 | 19183 | Harry Hawes H000362 | sen | MO | 1927-12-05 | 1933-02-03 | 3 | Democrat | |||||||||||||
19220 | 19220 | Eugene Black B000495 | rep | TX | 1927-12-05 | 1929-03-03 | Democrat | 1 | |||||||||||||
19233 | 19233 | William Bowling B000702 | rep | AL | 1927-12-05 | 1929-03-03 | Democrat | 5 | |||||||||||||
19238 | 19238 | Edwin Broussard B000895 | sen | LA | 1927-12-05 | 1933-03-03 | 3 | Democrat | |||||||||||||
19261 | 19261 | Thaddeus Caraway C000139 | sen | AR | 1927-12-05 | 1931-12-31 | 3 | Democrat | |||||||||||||
19265 | 19265 | William Cohen C000599 | rep | NY | 1927-12-05 | 1929-03-03 | Democrat | 17 | |||||||||||||
19266 | 19266 | George Combs C000654 | rep | MO | 1927-12-05 | 1929-03-03 | Democrat | 5 | |||||||||||||
19290 | 19290 | Martin Davey D000080 | rep | OH | 1927-12-05 | 1929-03-03 | Democrat | 14 | |||||||||||||
19294 | 19294 | Joseph Deal D000169 | rep | VA | 1927-12-05 | 1929-03-03 | Democrat | 2 | |||||||||||||
19315 | 19315 | James Gallivan G000024 | rep | MA | 1927-12-05 | 1929-03-03 | Democrat | 12 | |||||||||||||
19318 | 19318 | Frank Gardner G000053 | rep | IN | 1927-12-05 | 1929-03-03 | Democrat | 3 | |||||||||||||
19330 | 19330 | Finis Garrett G000082 | rep | TN | 1927-12-05 | 1929-03-03 | Democrat | 9 | |||||||||||||
19348 | 19348 | Thomas Harrison H000277 | rep | VA | 1927-12-05 | 1929-03-03 | Democrat | 7 | |||||||||||||
19358 | 19358 | Everette Howard H000837 | rep | OK | 1927-12-05 | 1929-03-03 | Democrat | 1 | |||||||||||||
19361 | 19361 | Meyer Jacobstein J000040 | rep | NY | 1927-12-05 | 1929-03-03 | Democrat | 38 | |||||||||||||
19372 | 19372 | Everett Kent K000124 | rep | PA | 1927-12-05 | 1929-03-03 | Democrat | 30 | |||||||||||||
19377 | 19377 | John Kindred K000191 | rep | NY | 1927-12-05 | 1929-03-03 | Democrat | 2 | |||||||||||||
19392 | 19392 | Ladislas Lazaro L000153 | rep | LA | 1927-12-05 | 1929-03-03 | Democrat | -1 | |||||||||||||
19396 | 19396 | Bill Lowrey L000484 | rep | MS | 1927-12-05 | 1929-03-03 | Democrat | 2 | |||||||||||||
19400 | 19400 | Homer Lyon L000543 | rep | NC | 1927-12-05 | 1929-03-03 | Democrat | 6 | |||||||||||||
19426 | 19426 | Paul Moore M000912 | rep | NJ | 1927-12-05 | 1929-03-03 | Democrat | 8 | |||||||||||||
19427 | 19427 | Henry Moorman M000931 | rep | KY | 1927-12-05 | 1929-03-03 | Democrat | 4 | |||||||||||||
19438 | 19438 | John Morrow M001004 | rep | NM | 1927-12-05 | 1929-03-03 | Democrat | 1 | |||||||||||||
19442 | 19442 | William O’Brien O000018 | rep | WV | 1927-12-05 | 1929-03-03 | Democrat | 3 | |||||||||||||
19454 | 19454 | William Oldfield O000062 | rep | AR | 1927-12-05 | 1929-03-03 | Democrat | 2 | |||||||||||||
19459 | 19459 | Lee Overman O000140 | sen | NC | 1927-12-05 | 1930-12-12 | 3 | Democrat | |||||||||||||
19463 | 19463 | George Peery P000186 | rep | VA | 1927-12-05 | 1929-03-03 | Democrat | 9 | |||||||||||||
19469 | 19469 | James Reed R000119 | rep | AR | 1927-12-05 | 1929-03-03 | Democrat | 6 | |||||||||||||
19477 | 19477 | Thomas Rubey R000491 | rep | MO | 1927-12-05 | 1929-03-03 | Democrat | 16 | |||||||||||||
19510 | 19510 | John Tillman T000276 | rep | AR | 1927-12-05 | 1929-03-03 | Democrat | 3 | |||||||||||||
19528 | 19528 | Orie Ware W000149 | rep | KY | 1927-12-05 | 1929-03-03 | Democrat | 6 | |||||||||||||
19544 | 19544 | Sebastian White W000393 | rep | CO | 1927-12-05 | 1929-03-03 | Democrat | 1 | |||||||||||||
19551 | 19551 | Thomas Wilson W000617 | rep | MS | 1927-12-05 | 1929-03-03 | Democrat | 6 | |||||||||||||
19585 | 19585 | Thomas Bell B000348 | rep | GA | 1927-12-05 | 1929-03-03 | Democrat | 9 | |||||||||||||
19592 | 19592 | John Box B000710 | rep | TX | 1927-12-05 | 1929-03-03 | Democrat | 2 | |||||||||||||
19614 | 19614 | John Carew C000142 | rep | NY | 1927-12-05 | 1929-03-03 | Democrat | 18 | |||||||||||||
19620 | 19620 | John Casey C000223 | rep | PA | 1927-12-05 | 1929-03-03 | Democrat | 12 | |||||||||||||
19672 | 19672 | Thomas Doyle D000483 | rep | IL | 1927-12-05 | 1929-03-03 | Democrat | 4 | |||||||||||||
19708 | 19708 | Hubert Fisher F000149 | rep | TN | 1927-12-05 | 1929-03-03 | Democrat | 10 | |||||||||||||
19760 | 19760 | William Hammer H000123 | rep | NC | 1927-12-05 | 1929-03-03 | Democrat | 7 | |||||||||||||
19782 | 19782 | Claude Hudspeth H000910 | rep | TX | 1927-12-05 | 1929-03-03 | Democrat | 16 | |||||||||||||
19831 | 19831 | David Kincheloe K000187 | rep | KY | 1927-12-05 | 1929-03-03 | Democrat | 2 | |||||||||||||
19863 | 19863 | Whitmell Martin M000201 | rep | LA | 1927-12-05 | 1929-03-03 | Democrat | 3 | |||||||||||||
19890 | 19890 | Robert Moore M000915 | rep | VA | 1927-12-05 | 1929-03-03 | Democrat | 8 | |||||||||||||
19907 | 19907 | David O’Connell O000022 | rep | NY | 1927-12-05 | 1929-03-03 | Democrat | 9 | |||||||||||||
19917 | 19917 | James O’Connor O000028 | rep | LA | 1927-12-05 | 1929-03-03 | Democrat | 1 | |||||||||||||
19919 | 19919 | Pearl Oldfield O000061 | rep | AR | 1927-12-05 | 1929-03-03 | Democrat | 2 | |||||||||||||
19937 | 19937 | John Quayle Q000008 | rep | NY | 1927-12-05 | 1929-03-03 | Democrat | 7 | |||||||||||||
19967 | 19967 | James Spearing S000708 | rep | LA | 1927-12-05 | 1929-03-03 | Democrat | 2 | |||||||||||||
19986 | 19986 | Charles Stedman S000827 | rep | NC | 1927-12-05 | 1929-03-03 | Democrat | 5 | |||||||||||||
19988 | 19988 | Leslie Steele S000835 | rep | GA | 1927-12-05 | 1929-03-03 | Democrat | 5 | |||||||||||||
20037 | 20037 | Royal Weller W000277 | rep | NY | 1927-12-05 | 1929-03-03 | Democrat | 21 | |||||||||||||
20040 | 20040 | Joseph Whitehead W000400 | rep | VA | 1927-12-05 | 1929-03-03 | Democrat | 5 | |||||||||||||
20057 | 20057 | Otis Wingo W000635 | rep | AR | 1927-12-05 | 1929-03-03 | Democrat | 4 | |||||||||||||
20105 | 20105 | James Aswell A000321 | rep | LA | 1927-12-05 | 1929-03-03 | Democrat | 8 | |||||||||||||
20169 | 20169 | Harry Canfield C000114 | rep | IN | 1927-12-05 | 1929-03-03 | Democrat | 4 | |||||||||||||
20219 | 20219 | James Collier C000630 | rep | MS | 1927-12-05 | 1929-03-03 | Democrat | 8 | |||||||||||||
20268 | 20268 | Charles Crisp C000909 | rep | GA | 1927-12-05 | 1929-03-03 | Democrat | 3 | |||||||||||||
20289 | 20289 | Ewin Davis D000098 | rep | TN | 1927-12-05 | 1929-03-03 | Democrat | 5 | |||||||||||||
20305 | 20305 | Frederick Dominick D000408 | rep | SC | 1927-12-05 | 1929-03-03 | Democrat | 3 | |||||||||||||
20308 | 20308 | Lewis Douglas D000455 | rep | AZ | 1927-12-05 | 1929-03-03 | Democrat | 0 | |||||||||||||
20316 | 20316 | Herbert Drane D000486 | rep | FL | 1927-12-05 | 1929-03-03 | Democrat | 1 | |||||||||||||
20346 | 20346 | Charles Edwards E000062 | rep | GA | 1927-12-05 | 1929-03-03 | Democrat | 1 | |||||||||||||
20352 | 20352 | Edward Eslick E000216 | rep | TN | 1927-12-05 | 1929-03-03 | Democrat | 7 | |||||||||||||
20365 | 20365 | John Evans E000247 | rep | MT | 1927-12-05 | 1929-03-03 | Democrat | 1 | |||||||||||||
20401 | 20401 | James Fulbright F000400 | rep | MO | 1927-12-05 | 1929-03-03 | Democrat | 14 | |||||||||||||
20413 | 20413 | Daniel Garrett G000081 | rep | TX | 1927-12-05 | 1929-03-03 | Democrat | 8 | |||||||||||||
20419 | 20419 | Ralph Gilbert G000177 | rep | KY | 1927-12-05 | 1929-03-03 | Democrat | 8 | |||||||||||||
20548 | 20548 | Cordell Hull H000940 | rep | TN | 1927-12-05 | 1929-03-03 | Democrat | 4 | |||||||||||||
20561 | 20561 | James Igoe I000003 | rep | IL | 1927-12-05 | 1929-03-03 | Democrat | 6 | |||||||||||||
20617 | 20617 | Stanley Kunz K000342 | rep | IL | 1927-12-05 | 1929-03-03 | Democrat | 8 | |||||||||||||
20633 | 20633 | William Lankford L000082 | rep | GA | 1927-12-05 | 1929-03-03 | Democrat | 11 | |||||||||||||
20641 | 20641 | William Larsen L000103 | rep | GA | 1927-12-05 | 1929-03-03 | Democrat | 12 | |||||||||||||
20661 | 20661 | John Linthicum L000340 | rep | MD | 1927-12-05 | 1929-03-03 | Democrat | 4 | |||||||||||||
20688 | 20688 | Samuel Major M000074 | rep | MO | 1927-12-05 | 1929-03-03 | Democrat | 7 | |||||||||||||
20717 | 20717 | Charles Mooney M000887 | rep | OH | 1927-12-05 | 1929-03-03 | Democrat | 20 | |||||||||||||
20728 | 20728 | John Moore M000905 | rep | KY | 1927-12-05 | 1929-03-03 | Democrat | 3 | |||||||||||||
20764 | 20764 | John Norton N000152 | rep | NE | 1927-12-05 | 1929-03-03 | Democrat | 4 | |||||||||||||
20769 | 20769 | LaFayette Patterson P000125 | rep | AL | 1927-12-05 | 1929-03-03 | Democrat | 5 | |||||||||||||
20795 | 20795 | Percy Quin Q000014 | rep | MS | 1927-12-05 | 1929-03-03 | Democrat | 7 | |||||||||||||
20822 | 20822 | Samuel Rutherford R000549 | rep | GA | 1927-12-05 | 1929-03-03 | Democrat | 6 | |||||||||||||
20887 | 20887 | William Stevenson S000895 | rep | SC | 1927-12-05 | 1929-03-03 | Democrat | 5 | |||||||||||||
20959 | 20959 | Henry Tucker T000399 | rep | VA | 1927-12-05 | 1929-03-03 | Democrat | 10 | |||||||||||||
21011 | 21011 | Guinn Williams W000501 | rep | TX | 1927-12-05 | 1929-03-03 | Democrat | 13 | |||||||||||||
21036 | 21036 | William Wright W000773 | rep | GA | 1927-12-05 | 1929-03-03 | Democrat | 4 | |||||||||||||
21058 | 21058 | Thomas Yon Y000021 | rep | FL | 1927-12-05 | 1929-03-03 | Democrat | 3 | |||||||||||||
21069 | 21069 | Charles Abernethy A000015 | rep | NC | 1927-12-05 | 1929-03-03 | Democrat | 3 | |||||||||||||
21076 | 21076 | Miles Allgood A000156 | rep | AL | 1927-12-05 | 1929-03-03 | Democrat | 7 | |||||||||||||
21086 | 21086 | Edward Almon A000162 | rep | AL | 1927-12-05 | 1929-03-03 | Democrat | 8 | |||||||||||||
21092 | 21092 | Oscar Auf Der Heide A000338 | rep | NJ | 1927-12-05 | 1929-03-03 | Democrat | 11 | |||||||||||||
21101 | 21101 | William Ayres A000354 | rep | KS | 1927-12-05 | 1929-03-03 | Democrat | 8 | |||||||||||||
21119 | 21119 | Hugo Black B000499 | sen | AL | 1927-12-05 | 1933-03-03 | 3 | Democrat | |||||||||||||
21123 | 21123 | Loring Black B000505 | rep | NY | 1927-12-05 | 1929-03-03 | Democrat | 5 | |||||||||||||
21138 | 21138 | Charles Brand B000767 | rep | GA | 1927-12-05 | 1929-03-03 | Democrat | 8 | |||||||||||||
21146 | 21146 | Clay Briggs B000826 | rep | TX | 1927-12-05 | 1929-03-03 | Democrat | 7 | |||||||||||||
21165 | 21165 | Gordon Browning B000959 | rep | TN | 1927-12-05 | 1929-03-03 | Democrat | 8 | |||||||||||||
21181 | 21181 | Thomas Busby B001163 | rep | MS | 1927-12-05 | 1929-03-03 | Democrat | 4 | |||||||||||||
21186 | 21186 | Patrick Carley C000149 | rep | NY | 1927-12-05 | 1929-03-03 | Democrat | 8 | |||||||||||||
21231 | 21231 | Clement Dickinson D000316 | rep | MO | 1927-12-05 | 1929-03-03 | Democrat | 6 | |||||||||||||
21237 | 21237 | John Douglass D000459 | rep | MA | 1927-12-05 | 1929-03-03 | Democrat | 10 |
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);